Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $65.$100, and $140, respectively. The production requirements per unit are as follows: For the coming production period, the company has 250 fan motors, 310 cooling coils, and 2600 hours of manufacturing time available. In order to decide how many economy models (E), standard models (S), and deluxe models (D) should the company produces in order to maximize the profit, a linear programming model is developed. The model was solved using Excel. Answer the following questions using the sensitivity report below. Variable Cells Constraints What is the optimal solution, and the total profit? E: s: D: Profit: What are the binding constraints? Cooling coils Fan Motors Manufacturing time What are the slacks associated with the constraints? enter them in the spaces below (Only enter the numerical value, e.g. 90). Fan Motors: Manufacturing time: Cooling coils What would happen if an extre 38 hours were aflocated to the manufacturing time? The optimal solution would change and we canot quarity the change in proft. No impact on optimal salution. The profit would change by 1050 . Cannot answer based on the sensitivity report. We hive to re-nun the solver. The optimal solution would change and the profit would change by 1050 . Increase the profit per Standard model by 20. What effect would this change have on the optimal solution and the profit? The optimal solution would change and so does the profit. No impact on optimal solution. The profit would change by 1200. No impact on optimal solution or the profit. Cannot answer based on the sensitivity report. We have to re-run the solver. What would happen if the manufacturing time is decreased by 70 hours? No impact on optimal solution. The profit would change by 2170. No impact on optimal solution or the profit. No impact on optimal solution. The profit would change by 2450. Cannot answer based on the sensitivity report. We have to re-run the solver. Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $65.$100, and $140, respectively. The production requirements per unit are as follows: For the coming production period, the company has 250 fan motors, 310 cooling coils, and 2600 hours of manufacturing time available. In order to decide how many economy models (E), standard models (S), and deluxe models (D) should the company produces in order to maximize the profit, a linear programming model is developed. The model was solved using Excel. Answer the following questions using the sensitivity report below. Variable Cells Constraints What is the optimal solution, and the total profit? E: s: D: Profit: What are the binding constraints? Cooling coils Fan Motors Manufacturing time What are the slacks associated with the constraints? enter them in the spaces below (Only enter the numerical value, e.g. 90). Fan Motors: Manufacturing time: Cooling coils What would happen if an extre 38 hours were aflocated to the manufacturing time? The optimal solution would change and we canot quarity the change in proft. No impact on optimal salution. The profit would change by 1050 . Cannot answer based on the sensitivity report. We hive to re-nun the solver. The optimal solution would change and the profit would change by 1050 . Increase the profit per Standard model by 20. What effect would this change have on the optimal solution and the profit? The optimal solution would change and so does the profit. No impact on optimal solution. The profit would change by 1200. No impact on optimal solution or the profit. Cannot answer based on the sensitivity report. We have to re-run the solver. What would happen if the manufacturing time is decreased by 70 hours? No impact on optimal solution. The profit would change by 2170. No impact on optimal solution or the profit. No impact on optimal solution. The profit would change by 2450. Cannot answer based on the sensitivity report. We have to re-run the solver
