Show LP models for all problems. Attach the original Excel Solver solutions, including the answer report and the sensitivity report for the LP models.

PLEASE SOLVE USING EXCEL

Show LP models for all problems. Attach the original Excel Solver solutions, including the answer report and the sensitivity report for the LP models.

2. (25 points) 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: Number of fans Number of cooling Manufacturing Coils Time (hours) Economy 1 1 8 Standard 1 2 12 Deluxe 1 4 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, standard models, and deluxe models should the company produce in order to maximize profit? Formulate the problem and answer the following questions. a. Show LP model. 6. What is the optimal solution, and what us the value of the objective function? C. Which constraints are binding? d. Which constraints show extra capacity? How much? e. If the profit for the deluxe model were increased to $150 per unit, would the optimal solution change? Explain