chegg.com G Excel File Edit View Insert Format Tools Mon 1:05 ... | Chegg.com + (25 points) General Electric produces 4 types of appliances (i.e. refrigerator, dishwasher, ranges and microwave). There are currently 1000 workers employed who can be hired and laid off at any time. Initial inventory is 500 units for refrigerators, and 420 units for dishwashers, 380 units for ranges and 450 for microwaves. Number of units that can be made by one worker, forecasted demand, unit costs, and holding costs, as well as costs of firing and hiring and cost per worker are all given below. a)(5 points) Develop the cost function for General Electric. b)(10 points) Input all the constraints into Excel's Solver to minimize the cost. c)(10 points) Report your optimized cost value through Solver report. Save the report as a separate sheet on your Excel file. Microway Time Holding Costs Dishwasher Range 13 15 160 Microwave Refrigerat 147 17 155 17 134 20 138 17 16 16 13 16 19 11 19 Spring Summer Fall Winter 19 12 10 Forecasted Demand Unit Costs Time period Refrigerato Microway Dishwasher 6 Range Refrigerator Dishwasher Range 7 Spring 3820 4979 4685 3789 131 149 8 Summer 5256 4134 3659 3955 160 143 129 9 Fall 4260 4126 4833 5280 159 140 134 10 Winter 3785 4168 3912 4112 159 153 135 11 12 Number of units that can be made by one worker per period: Retrigerato Microway 13 Time period Dishwasher Ranges 14 Spring 393 469 421 294 15 Summer 278 480 443 248 16 Fall 319 382 248 465 17 Winter 477 354 232 18 19 20 Time period Spring Summer Fall Winter 21 Costs of hiring 408 407 408 431 22 Costs of lay off 736 799 748 23 Costs per worker 576 555 648 596 Number Time per Spring Summer Fall Winter 314 Time per Costs of Costs of Costs per 725 Instructions Problem 1 Problem 2 Problem 3 Problem 4 Prolem 5 + chegg.com G Excel File Edit View Insert Format Tools Mon 1:05 ... | Chegg.com + (25 points) General Electric produces 4 types of appliances (i.e. refrigerator, dishwasher, ranges and microwave). There are currently 1000 workers employed who can be hired and laid off at any time. Initial inventory is 500 units for refrigerators, and 420 units for dishwashers, 380 units for ranges and 450 for microwaves. Number of units that can be made by one worker, forecasted demand, unit costs, and holding costs, as well as costs of firing and hiring and cost per worker are all given below. a)(5 points) Develop the cost function for General Electric. b)(10 points) Input all the constraints into Excel's Solver to minimize the cost. c)(10 points) Report your optimized cost value through Solver report. Save the report as a separate sheet on your Excel file. Microway Time Holding Costs Dishwasher Range 13 15 160 Microwave Refrigerat 147 17 155 17 134 20 138 17 16 16 13 16 19 11 19 Spring Summer Fall Winter 19 12 10 Forecasted Demand Unit Costs Time period Refrigerato Microway Dishwasher 6 Range Refrigerator Dishwasher Range 7 Spring 3820 4979 4685 3789 131 149 8 Summer 5256 4134 3659 3955 160 143 129 9 Fall 4260 4126 4833 5280 159 140 134 10 Winter 3785 4168 3912 4112 159 153 135 11 12 Number of units that can be made by one worker per period: Retrigerato Microway 13 Time period Dishwasher Ranges 14 Spring 393 469 421 294 15 Summer 278 480 443 248 16 Fall 319 382 248 465 17 Winter 477 354 232 18 19 20 Time period Spring Summer Fall Winter 21 Costs of hiring 408 407 408 431 22 Costs of lay off 736 799 748 23 Costs per worker 576 555 648 596 Number Time per Spring Summer Fall Winter 314 Time per Costs of Costs of Costs per 725 Instructions Problem 1 Problem 2 Problem 3 Problem 4 Prolem 5 +