SunshineSolar has forecasted its production requirements for the next four month

Question

SunshineSolar has forecasted its production requirements for the next four months:

SunshineSolar has forecasted its production requirements for the next four months Productive Days Demand Available(units) Month 21 25000 16000 18000 14000 June July August September 12 21 Currently there are 95 employees with a productivity of 12 units per employee per day There are 50 units in inventory. SunshineSolar plans to use all employees and all productive days available How many units will be produced in July? How many units will be in inventory (or short) at the end of June? How many units will be produced in September? How many units will be in inventory (or short) at the end of August? Express as whole numbers; include a negative sign if needed, no commas. Remember that negative inventory means a shortage.

Explanation / Answer

Answer : The table is calculated for the production for each month based on the days available for production, productivity and number of employees available for production.

Production in the month of July = Productivity * Employees* Days available = 12*95*22 = 25080 nos.

Number of units will be in inventory (short) at the end of June = Production + Previous Invenotry -Sale
Number of units will be in inventory (short) at the end of June = Productivity* employee*days available + Previous Invenotry -Sale
Number of units will be in inventory (short) at the end of June = 12* 95*21 + 50 -25000
Number of units will be in inventory (short) at the end of June = 23940 + 50 -25000 = -1010 nos. (Ans)

Number of units will be produced in septamber = Productivity * Employees* Days available = 12*95*21 = 23940 nos.

Number of units will be in inventory (short) at the end of August = Production + Previous Invenotry -Sale
Number of units will be in inventory (short) at the end ofAugust = Productivity* employee*days available + Previous Invenotry -Sale
Number of units will be in inventory (short) at the end ofAugust = 12* 95*13 + 8070 -18000
Number of units will be in inventory (short) at the end of August = 13680 +8070-18000 = 21750-18000= 3750 nos. (Ans)

Month Productive Days Available Demand Employees Productivity (unit/employee/day) Previous Inventory Production
(Employee*Days* Productivity) Sale Total Invenotry at Month End (Production - sale) Jun 21 25000 95 12 50 23940 25000 -1010 July 22 16000 95 12 25080 16000 8070 Aug 12 18000 95 12 8070 13680 18000 3750 Sep 21 14000 95 12 23940 14000 9940

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.