generate answers using excel

SELF test 12. Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63,895, and $135, respec tively. The production requirements per unit are as follow Number of Fans Number of Cooling Colls Manufacturing Time hours) Economy Standard Deluxe 14 For the coming production period, the company has 200 fan motors, 320 cooling coils, and 2400 hours of manufacturing time available. How many economy models (E), standard models (S), and deluxe models (D) should the company produce in order to maximize profit? The linear programming model for the problem is as follows Max 63 +955 + 1350 S.L. LE + 15 + IDS 200 Fan motors 1E + 25+ 40 S 320 Cooting coils SE + 12 + 14D 2400 Manufacturing time ESD 0 338 Chapter 8 Linear Programming: Sensitivity Analysis and Interpretation of Solution FIGURE 8.18 SENSITIVITY REPORT FOR THE QUALITY AIR CONDITIONING PROBLEM Variable Cells Model Variable E S D Name Economy Models Standard Models Deluxe Models Final Value 0.000 120.000 0.000 Reduced Cast 0.000 0.000 -24.000 Objective Coefficient 63.000 95.000 135.000 Allowable Increase 12.000 31.000 24,000 Allowable Decrease 15. SOO 8.000 IE+30 Allowable Increase Constraints Constraint Number 1 2 3 Final Value 200.000 320.000 2080.000 Name Fan Motors Cooling Coil Manufacturing Time Shadow Price 31.000 32.000 0.000 Constraint R.H. Side 200.000 320.000 2400.000 000 Allowable Deca 40.000 120.000 320.000 Com 80.000 IE+30 The sensitivity report is shown in Figure 8.18. a. What is the optimal solution, and what is the value of the objective function? Which constraints are binding? c. Which constraint shows extra capacity? How much? d. If the profit for the deluxe model were increased to $150 per unit, would the optimal