Problem 11-9 (Static) Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information. MONTH 2 3 5 Demand 160 150 140 180 170 140 Capacity Regular 150 150 150 150 160 Overtime 10. 20 0 10 10 160 10 Cost Per Unit Regular time Overtime Subcontract Inventory holding, per month $50 25 Click here for the Excel Data File Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero. Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity Regular production. (Negative amounts should be indicated by a minus sign. Leave no cells blank-be certain to enter "O" wherever required.) Period Answer is complete but not entirely correct. 2 5 6 Total 160 150 160 180 170 140 960 Forecast Output Regular 150 150 150 150 160 140x 900 Overtime 100 10 10 100 40- Subcontract 00 100 10 00 00 20 Output - Forecast 10 - 0 -10 0 Inventory Beginning 10 10 Ending 0 10- 10 Average 00 SO 10 50 Backlog 0 00 09 00 0000 0 0 tooo 00 00 Costs Regular $7.500 7,500 7,500 7,500 S 8,000 7,000 * 45,000 Overtime 750 750 O 00 D 750 00 3,000 Subcontract 800 800 1,600 Inventory 20 40 20 00 0 80 Backlog 0 0 $8.250 8,280 x 8.340 9,070 8.750 7,000 Total 49,680