Download the attached Excel shell file and set up a Solver Model for the aggregate planning problem. Run Solver and develop the least cost aggregate plan. (50 points) B D E F Cost data Wage/hour Demand forecast Month Demand OT pay rate 1 2 $12.00 $18.00 $80.00 $5.00 $500.00 $700.00 Subcontracting rate/unit Carrying cost Hiring cost/worker Firing cost/worker 3 4800 5200 5800 5500 52001 5500 4 5 6 Initial condition Workers on roll Current inventory Safety stock 100 50 20 Other data Std. hours Hours/day Days/Month OT Limit 4 8 22 25% Computed from given data Production rate/worker/day Production rate/worker/Month Wage/worker/Month = OT cost/unit A B D E F G G H 25 OT cost/unit 26 Workers 27 28 Month Begin Hire Fire Workers 1 29 30 31 32 33 34 35 38 37 2 3 4 5 6 Sum= Production and Inventory Production 38 Month Beginning Inventory RT OT Ending Demand Inventory SC OT Limit 39 1 40 41 AN- 42 43 5 6 44 45 46 Sum = 47 48 49 50 51 52 53 Cost summary Regular wages OT Cost SC cost Hiring cost Firing cost Carrying cost Total cost 54