Question: 10) Examine the following sensitivity report from Excel: Variable Cells Final Reduced Objective Allowable Allowable Cell Name ValueCost Coefficient Increase Decrease SASS inkjet B$S laser
10) Examine the following sensitivity report from Excel: Variable Cells Final Reduced Objective Allowable Allowable Cell Name ValueCost Coefficient Increase Decrease SASS inkjet B$S laser 40 60 20 60 20 20 25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease 70 sc$2 production SC$3 labor hours 120 30 50 70 30 10 120 90 How much would the profit contribution on laser printers have to go up before the final values of the decision variables would be changed in the optimal solution? Which part(s) of the Sensitivity Report allowed you to answer a)? If an additional 3 laborers, each working 8 hours, was suggested to improve profits, would this change increase profits, and if so, by how much, per hour? a) b) c) d) Which part(s) of the Sensitivity Report allowed you to answer c)? e) How should you treat the value '1E+30 when seen on a Sensitivity Report
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
