Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started