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 1 2 3 4 5 6 Demand 160 150 160 180 170 140 Capacity Regular 150 150 150 150 160 160 Overtime 10 10 0 10 10 10 Cost Per Unit Regular time $ 50 Overtime 75 Subcontract 80 Inventory, per period 4 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 production and overtime production can be less than capacity in any month. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) Period 1 2 3 4 5 6 Total Forecast 160 150 160 180 170 140 960 Output Regular Overtime Subcontract Output- Forecast Inventory Beginning Ending Average Backlog Costs: Regular $ $ Overtime Subcontract Inventory Backlog Total $ $ rev: 10_13_2017_QC_CS-103666, 10_28_2017_QC_CS-107318,