3 e 2 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: [EXAM 1 excel.xlsx]Cool Dorm 3 Report Created: 10/25/2016 10:03:30 AM - Engine: Standard LP/Quadratic 5 6 Object ve Cel(Nex) 250 8 SESO Unit Profits Total Drofit 9 O Dec son Variable Ces 11 12 3 5358 Number to Make Stand 4 SC56 Number to Make Cubes 6 16 Constraints 17 0.00 5.00 -5.00 0.00 20 50 5 E-30 25-30 20.0000002 20 21 $D$12 Molc Processing used 5D5:3 Finishing Used S05:4 Stancs Demand used 20.00 40.00 5.00 0.00 6.25 0.00 35 40 10 32 15-30 13 40 5 15. Cool Dorm has decided to hire another employee to work in finishing. This doubles the number of hours available. The added hours will result in a. Increasing the objective function by $250 b. Decreasing the objective function by $250 C. Going beyond the scope of the sensitivity report; will have to rework the model d. None of the above 16. Molding constraint has a shadow price of 0, which means a. It is a binding constraint b. Additional molding hours will improve the objective function value c. Decreasing molding hours by 15 will worsen the model d. There will be no effect on the optimum solution when increasing or decreasing the RHS, within limits Mierove Excel 10.0 Senallvity Report 2 Worksheet (EXAM 1 alex Cool Dorm Repert Created 10/25/2018 10:01.30 AM Engine Standard LP/Quadratie Objective Cell (Max) Call Name Final Value SE59 Unit Profits Total Profit 250 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.00 -5.00 20 5 15.30 5.00 0.00 50 18.30 10.0000002 10 Decision Variable Cells 11 Call Name 13 $8$8 Number to Make Stand 14 $C$8 Number to Make Cubes IS 16 Constraints 17 18 Call Name 19 $D$12 Mold Processing Used 20 $D$13 Finishing Used 21 $D$14 Stands Demand Used >2 Final Value 20.00 40.00 5.00 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0.00 36 1E30 16 6.25 40 32 0.00 10 1E430 5 40 Mierove Excel 10.0 Senallvity Report 2 Worksheet (EXAM 1 alex Cool Dorm Repert Created 10/25/2018 10:01.30 AM Engine Standard LP/Quadratie Objective Cell (Max) Call Name Final Value SE59 Unit Profits Total Profit 250 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0.00 -5.00 20 5 15.30 5.00 0.00 50 18.30 10.0000002 10 Decision Variable Cells 11 Call Name 13 $8$8 Number to Make Stand 14 $C$8 Number to Make Cubes IS 16 Constraints 17 18 Call Name 19 $D$12 Mold Processing Used 20 $D$13 Finishing Used 21 $D$14 Stands Demand Used >2 Final Value 20.00 40.00 5.00 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0.00 36 1E30 16 6.25 40 32 0.00 10 1E430 5 40