Aggregate Planning

EXERCISE #4 The table below contains an Information on hard disks production operations in aggregate planning from July until December 2020 for the Coing-Global Enterprise. Complete the tables by following the provided plans Demand Information Month Holding Cost (Unit) 1000 July Regular Production Cost August 100 Overtime Cost September 400 Subcontracting Cost IS/K) Back Ordering Cost 1200 $8 per unit per month $20 per unit per month $30 per unit / per month 540 per unit per month $50 per unit per month $1000 per worker $1200 per worker 100 units October November 800 December 700 Hiring Cost Firing Cost Beginning Inventory Current Worker Average Monthly Output 5 workers 100 units per worker a) Plan A: Using chase demand strategy. Mth Demand Reg Prod ot S/K Inventory W Back Orders H J 1000 100 S 400 o 1200 N 800 D 700 Total 1000 Cost: b) Plan : Using strategy of workers only. Use aver time with maximum of 2 workera, S/limited to 200 units and back orders as needed. Mth Demand Reg Prod OT 57K 1000 Inventory Back Orders F 100 S 400 1200 N 800 700 Total 4200 Coat: c) plan c: Using a level production strategy. Use over time limited to 2 workers) and back orders as needed. Mth Demand Reg Pro OT S/K Inventory W H Back Orders F 1000 100 S 400 O 1200 N 800 700 Total 4200 Cost: d) Plan D: Using mixed strategy level production (July - September) and chase demand roctober - December). Use OT 12 workers) and beci . Kth Demand S/K Inventory Feg Pro Back Order 1000 A 100 400 1200 N 800 D 700 Total 4200 Cost: e) Plan E: Using a level of strategy that produces 600 every month. Use OT (3 workers) and back orders as needed. Mth Demand Reg Pro OT S/K Inventory w H Back Order E 1000 100 S 400 o 1200 N 800 D 700 Total 4200 Cost