BIU OA S E Mergo & Center $ % 0 Formatting Tomat Style Table Styles Number Alignment board Font D E F G H Name Sheila Perez #1 - Chpt 11. Prob 9 Wormwood, LTD produces a variety of furniture products. The Wanning committee wants to produce an aggregate plan for the next 6 months. Complete the spreadsheet cells colored in blue. 1 160 150 160 180 170 Demand Units 140 Month Demand 1 Capacity Regular Max Overtime Max Subcontract 150 150 10 10 150 10 10 10 150 10 10 160 10 10 Cost Per Unit $50 $75 $80 Regular Units Overtime Units Subcontract Units 10 Inventory, per period Beginning inventory =0 Backorders not allowed Plan based on minimzing total cost with no layoffs Totals Period 3 160 4 180 5 170 6 140 Demand 160 150 Output From Regular Overtime From Subcontract From Inventory Delta nventory Honor Code and Instructions 2.1 Hueristic 1. Work left to right 2. Total the demand 3. Total the regular time 4. Create a delta line 5. Add overtime as the next least expensive 6. Keep the cheapest alternative moving left to right For example building ahead with overtime where there and holding inventory is less expensive than subcontrac 2.8 2.9 2.10 2.2 2.3 2.4 2.5 2.6 2.7 8 9