AGGREGATE PLANNING

Using the Aggregate Planning spreadsheet data from Canvas, implement the following strategies and compute their cost, showing all spreadsheet details

1. Implement a level workforce strategy with capacity constraint of 30 units/ period. Be cost conscious.
2. Implement a Plant Closing strategy using the cost of P(Sub) as $9/unit

AutoSave AAP 2O... OF Aggregate_Planning_data-2-1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Body! v 18 v P A y a Wran Text General SI V X [G v WS Paste BIU 1 A , - Merge & Center $ % Insert Delete Format Y Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data 918 . fx . B B D E F H J K L M N o P Q F 1 6 7 8 9 40 50 30 20 11 Unit 10 20 12 20 Total Cost 60 30 Cost 30 30 30 30 30 30 30 30 30 $30 $45 $85 8 8 1 Time 1 2 3 4 5 2 Demand 40 50 60 60 4 P(Reg) 30 30 30 5 P(OT) 6 P(Sub) Inv(Beg) 9 Inv(End) Inv(Avg) #W #Hired #Fired 16 Backorders 18 Productivity= 0.25 units/worker/period 19 100 10 $5 12 13 14 $300 $ $500 $10 TOTAL= #Wold 20 21 22 Sheet1 Sheet2 Shect3 Sheet4 Shoots Sheets + Ready S: + 150%