Please help fill out the excel sheet B

Excel Sheet A) Aggregate Plan

Excel Sheet B) Fill in the table for subcontracting.

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 500 500 $20 30 200 Safety Stock Beg Inv Beg Workers Avg Monthly Output/worker Inv Holding Cost Regular Wage Regular Production hours/month OT Wage Rate Hiring Cost Firing/Lay Off Cost Subcontracting Cost per hour per worker per worker 100 300 11.00 $ per case 1 $10 100 per case per month per hour DEMAND REGULAR PRODUCTION SUBCONTRACTING ENDING INVENTORY WORKERS HIRE FIRE 2400 JANUARY FEBRUARY MARCH 3200 3200 4800 6000 4400 APRIL MAY JUNE TOTAL COST PER CATEGORY TOTAL COST PER CATEGORY 24000 TOTAL COST OF STRATEGY $0.00 REGULAR PRODUCTION=MINIMUM DEMAND