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. 2 150 MONTH 3 160 180 160 5 170 140 Demand Capacity Regular Overtime 150 10 150 10 150 0 150 10 160 10 160 10 Cost Per Unit Regular time Overtime Subcontract Inventory holding. per month $50 75 80 4 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 "0" wherever required.) Period 2 3 5 Total 160 150 100 180 170 140 960 Forecast Output Regular Overtime 150 150 150 150 0 10 10 160 10 160 0 920 40 10 TUNU 160 150 160 180 170 960 140 150 150 150 160 160 920 150 10 10 10 0 10 40 0 D 0 10 0 10 0 0 20 20 0 0 0 Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: 0 0 0 0 0 0 10 10 20 10 50 OOO olo 0 0 0 0 0 0 $7,500 7,500 Regular 7,500 7,500 8.000 8,000 IS 46,000 3.000 1.600 750 S sls 0 750 0 750 750 800 OOO 0 800 0 0 0 Overtime Subcontract Inventory Backlog Total 0 40 0 0 $ 8.250 0 0 0 . 0 9,090 0 8.750