I HAVE TO COMPLETE THE CONCLUSION OF THE BELOW REPORT.

SO KINDLY PROVIDE A CONCLUSION OF THE BELOW REPORT.

Please do not add points from your opinion.

Chapter 8, Problem 13 Refer to the sensitivity report in Figure 8.18. Figure 8.18 SENSITIVITY REPORT FOR THE QUALITY AIR CONDITIONING PROBLEM Variable Cells Model Reduced Objective Allowable Allowable Name Final Value Variable Cost Coefficient Increase Decrease E Economy Models 30.000 63.000 12.000 15.500 Standard Models 120.000 95.000 31.000 3.000 D Deluxe Modes 24.00 135.000 24.000 1.008+30 Constraints Constraint Shadow Constraint Allowable Allowable Name Final Value Number Price R.H. Side Increase Decrease 1 Fan Motors 200.000 31.000 200.000 80.000 40.000 N Cooling Coils 320.000 32.000 320.000 80.000 120.000 3 Manufacturing Time 2,080.000 2,400.000 1.00E+30 320.000 a. Identify the range of optimality for each objective function coefficient. For the model variable the objective coefficient range for variables is given by the expression: (Objective coefficient - Allowable decrease, Objective coefficient + Allowable increase) E 63 + 12 = 75 63 - 15.5 = 47.5 E is between 47.5 and 75 95 + 31 = 126 95 - 8 = 87 S is between 87 and 126 D 135 + 24 = 159135 - 18+30 D is between 159 with no lower bound (-co) b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal solution be? Objective coefficient range is not applicable since there is a change in multiple coefficients. In excel, to solve the optimal soluSelect Data from the Ribbon Select Solver from the Analysis Group When the solver parameter dialog appears: 0 Enter the objective function. 0 Select: To: Max as the option 0 Input the decision variables into by changing variable cells box. 0 Click Add Upon appearing of the Add Constraint dialog box: 0 Input the constraints in the Cell Reference box. 0 Select