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 Insert Draw Page Layout Formulas Data Home - Review View Tell me Share 0 Comments Calibri (Body! v 18 v P A y a Wran Text General SR V () X IG Paste BIU 1 A , Merge & Center $ % Insert Delete Format Y Conditional Format Cell Formatting as Table Styles Sort Filter V Find Select Analyze Data E30 . fx . B B D E F G H K L M N o Q 6 7 40 1 J 8 9 30 20 10 20 11 30 12 20 Unit Cost Total Cost 50 60 50 $30 $45 $85 8 1 Time 1 2 3 4 5 2 Demand 40 60 60 4 P(Reg) 5 P(OT) 6 P(Sub) 8 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%