Solve using excel solver and show steps.

est 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, $95, and $135, respec tively. The production requirements per unit are as follows: Number of Fans Number of Cooling Coils Economy Standard Deluxe Manufacturing Time (hours) 8 12 14 2 1 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. h Max 63955+ 1350 SL. TE 15+ 1D 200 Fan motors TE 25+ 405 320 Cooling coils SE 125 + 140 2400 Manufacturing time ES, D20 Chapter 8 Linear Programming: Sensitivity Analysis and Interpretation of Solution RE 8.18 SENSITIVITY REPORT FOR THE QUALITY AIR CONDITIONING PROBLEM iable Cells Model Variable E S D Name Economy Models Standard Models Deluxe Models Final Viilue 80.000 120.000 0.000 Reduced Cost 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.500 8.000 IE+30 onstraints Constraint Number Name Fan Motors Cooling Coils Manufacturing Time Final Value 200.000 320.000 2080.000 Shadow Price 31.000 32.000 0.000 constrain R. H. Side 200.000 320.000 2400.000 Allowable Increase 80.000 80,000 IE+30 Allowable Decrease 40.000 120.000 320.000 Cenage Learning 2013 The sensitivity report is shown in Figure 8.18. What is the optimal solution, and what is the value of the objective function? b. Which constraints are binding! Which constraint shows extra capacity? How much? d If the profit for the deluxe model were increased to $150 per unit would the optimal solution change? Use the information in Figure 8.18 to answer this