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: Economy Standard Deluxe Number of Fans 1 1 1 Number of Cooling Coils 1 2 4 Manufacturing Time (hours) 8 12 14 For the coming production period, the company has 240 fan motors, 340 cooling coils, and 2,600 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: Max 63E+ 95S + 135D
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: Economy Standard Deluxe Number of Fans 1 1 1 Number of Cooling Coils 1 2 4 Manufacturing Time (hours) 8 12 14 For the coming production period, the company has 240 fan motors, 340 cooling coils, and 2,600 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: Max 63E+ 95S + 135D
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
![E
S
D
Variable
E
HSD
E
S
D
profit
~ 3
Constraint
1
NH
2
3
Objective Allowable
Coefficient
Increase
12.00000
31.00000
24.00000
to
0.00000
280.00000
to
to
63.00000
95.00000
135.00000
(a) Identify the range of optimality for each objective function coefficient. (If there is no upper or lower limit, enter NO LIMIT.)
RHS
Value
240.00000
340.00000
2600.00000
32.00000
0.00000
Allowable
Increase
70.00000
70.00000
Infinite
units
units
units
Allowable
Decrease
15.50000
8.00000
Infinite
Allowable
Decrease
70.00000
100.00000
280.00000
(b) Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe
model is increased by $4 per unit. What will the new optimal solution be?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8ad87420-52d2-4e34-815e-eb9bcb5c95c0%2Fa886ca7f-d1f0-4652-9e2a-432e82ddde8c%2Fbxufzd_processed.png&w=3840&q=75)
Transcribed Image Text:E
S
D
Variable
E
HSD
E
S
D
profit
~ 3
Constraint
1
NH
2
3
Objective Allowable
Coefficient
Increase
12.00000
31.00000
24.00000
to
0.00000
280.00000
to
to
63.00000
95.00000
135.00000
(a) Identify the range of optimality for each objective function coefficient. (If there is no upper or lower limit, enter NO LIMIT.)
RHS
Value
240.00000
340.00000
2600.00000
32.00000
0.00000
Allowable
Increase
70.00000
70.00000
Infinite
units
units
units
Allowable
Decrease
15.50000
8.00000
Infinite
Allowable
Decrease
70.00000
100.00000
280.00000
(b) Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe
model is increased by $4 per unit. What will the new optimal solution be?
![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:
Economy
Standard
Deluxe
Max
s.t.
Number of
Fans
1
1
1
63E+ 95S +
Variable
E
S
D
1E + 1S +
1E + 2S +
8E+12S +
Constraint
1
2
The computer solution is shown below.
Number of
Cooling Coils
135D
For the coming production period, the company has 240 fan motors, 340 cooling coils, and 2,600 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:
Value
140.00000
100.00000
0.00000
1
1D ≤ 240
4D ≤ 340
14D ≤ 2,600
E, S, D≥ 0
2
Optimal Objective Value = 18320.00000
4
Slack/Surplus
0.00000
0.00000
Reduced Cost
0.00000
0.00000
-24.00000
Manufacturing
Time (hours)
8
12
Fan motors
Cooling coils
Manufacturing time
Dual Value
31.00000
32.00000
14](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8ad87420-52d2-4e34-815e-eb9bcb5c95c0%2Fa886ca7f-d1f0-4652-9e2a-432e82ddde8c%2F5497h5r_processed.png&w=3840&q=75)
Transcribed Image Text: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:
Economy
Standard
Deluxe
Max
s.t.
Number of
Fans
1
1
1
63E+ 95S +
Variable
E
S
D
1E + 1S +
1E + 2S +
8E+12S +
Constraint
1
2
The computer solution is shown below.
Number of
Cooling Coils
135D
For the coming production period, the company has 240 fan motors, 340 cooling coils, and 2,600 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:
Value
140.00000
100.00000
0.00000
1
1D ≤ 240
4D ≤ 340
14D ≤ 2,600
E, S, D≥ 0
2
Optimal Objective Value = 18320.00000
4
Slack/Surplus
0.00000
0.00000
Reduced Cost
0.00000
0.00000
-24.00000
Manufacturing
Time (hours)
8
12
Fan motors
Cooling coils
Manufacturing time
Dual Value
31.00000
32.00000
14
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
Step 1: State the information given.
Sensitivity Report-
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 21 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.