Question: Please enter the information from the problem into Excel to solve the problem. Use the Solver tool in Excel to find the solution for you

Please enter the information from the problemPlease enter the information from the problem

Please enter the information from the problem into Excel to solve the problem. Use the Solver tool in Excel to find the solution for you and obtain the Answer Report and Sensitivity Report. I just need to know who to add problem into excel

2. 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, respectively. The production requirements per unit are as follows: 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. Maxs.t.63E+95S+135D1E+1S+1D2001E+2S+4D3208E+12S+14D2400E,S,D0FanmotorsCoolingcoilsManufacturingtime FIGURE 8.18 SENSITIVITY REPORT FOR THE QUALITY AIR CONDITIONING PROBLEM The sensitivity report is shown in Figure 8.18. a. What is the optimal solution, and what is the value of the objective function? b. 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 solution change? Use the information in Figure 8.18 to answer this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!