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 4 Engine: Standard LP/Quadratic 5 6 Objective Cell (Max) 7 Cell Name Final Value 8 $E$9 Unit Profits Total Profit 250 9 10 Decision Variable Cells 11 Final Reduced Objective Allowable Allowable 12 Cell Name Value Cost Coefficient Increase Decrease 13 $B$8 Number to Make Stand: 0.00 -5.00 20 5 1E+30 14 $C$8 Number to Make Cubes 5.00 0.00 50 1E+30 10.0000002 15 16 Constraints 17 Final Shadow Constraint Allowable Allowable 18 Cell Name Value Price R.H. Side Increase Decrease 19 $D$12 Mold Processing Used 20.00 0.00 1E+30 16 20 $D$13 Finishing Used 40.00 6.25 40 32 40 21 $D$14 Stands Demand Used 5.00 0.00 10 1E+30 36 5 22 Producing one more stand will result in a. Improving the model b. Worsening the model c. Not change the model d. None of the above 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 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