Explain how the answer is found, and also provide the formulas in each cell:

 

Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month Forecast May Jun Jul Aug Sep Oct 4,000 4,800 5,600 7,200 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? Note: Backlogs are not allowed. a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (1,000 cases per period maximum), inventory, and subcontracting (1,000 cases per period maximum) to handle variations in demand.