Please help fill out the excel sheet B

Excel Sheet A) Aggregate Plan

Excel Sheet B) Fill out the excel sheet for overtime, please

D D E F G H I 20 A 1 Safety stock 2 Beg Inv 3 Beg Workers 4 Avg Monthly Output/worker 5 Inv Holding Cost 6 Regular Wage 7 Regular Production hours/month 8 B 500 500 30 100 1 200 OT Wage Rate Hiring Cost Firing/Layoff Cost Subcontracting Cost /hour / worker 1/ worker / case 300 11 1 case / month /hour 10 100 Demand Regular Production Workers Hire Fire Ending Overtime Inventory 500 0 2100 30 2400 40 10 0 0 0 0 3200 3200 4800 6000 4400 4000 4000 4000 4000 4000 4000 24000 0 0 Month 9 10 11 January 12 February 13 March 14 April 15 May 16 June 17 Total 18 Cost per Category 19 Total cost per Category 20 21 2900 3700 2900 900 500 40 40 40 40 40 0 0 0 0 0 0 0 0 0 0 10 24000 13000 240 0 20 0 300 10 1 200 2000 Total Cost of Strategy 255000 240000 0 13000 0 $20 200 Safety Stock Beg Inv Beg Workers Avg Monthly Output/worker Inv Holding Cost Regular Wage Regular Production hours/ month 500 500 30 100 1 $10 100 OT Wage Rate Hiring Cost Firing/Lay Off Cost Subcontracting Cost per hour per worker per worker per case 300 $ 11.00 per case per month per hour DEMAND REGULAR PRODUCTION OVERTIME ENDING INVENTORY WORKERS HIRE FIRE 2400 JANUARY FEBRUARY 3200 3200 MARCH APRIL MAY 4800 6000 4400 24000 JUNE TOTAL COST PER CATEGORY TOTAL COST PER CATEGORY TOTAL COST OF STRATEGY $0.00 REGULAR PRODUCTION=MINIMUM DEMAND