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 Coils Economy E Standard S Deluxe D The computer solution is shown below. Variable E S D Constraint 2 2 3 For the coming production period, the company has 260 fan motors, 360 cooling coils, and 2,500 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+ 955 + 1350 S.L. E S D Constraint 1E + 15 + 1E+ 25 + BE+ 125 + E S D profit $ 1 Optimal objective Value 19580.00000 2 3 constraint 2 constraint 3 1 1 160.00000 100.00000 0.00000 to Slack/Surplus 0.00000 0.00000 20.00000 to 1Ds 260 40 s 360 140 s 2,500 E,S, D 20 to 260.00000 360.00000 2500.00000 1 RNS 2 units units units 4 Reduced Cost 0.00000 0.00000 -24.00000 Objective Allowable Allowable Coefficient Increase Decrease 63.00000 12.00000 15.50000 95.00000 31.00000 8.00000 135.00000 24.00000 Infinite (a) Identify the range of optimality for each objective function coefficient. (If there is no upper or lower limit, enter NO LIMIT.) to to Manufacturing Time (hours) to 8 12 Fan motors Cooling coils Manufacturing time Dual Value 31.00000 32.00000 0.00000 14 (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? Allowable Allowable Increase 5.00000 5.00000 (c) Identify the range of feasibility for the right-hand-side values. (If there is no upper or lower limit, enter NO LIMIT.) constraint 1 Decrease 80.00000 100.00000 20.00000
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 Coils Economy E Standard S Deluxe D The computer solution is shown below. Variable E S D Constraint 2 2 3 For the coming production period, the company has 260 fan motors, 360 cooling coils, and 2,500 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+ 955 + 1350 S.L. E S D Constraint 1E + 15 + 1E+ 25 + BE+ 125 + E S D profit $ 1 Optimal objective Value 19580.00000 2 3 constraint 2 constraint 3 1 1 160.00000 100.00000 0.00000 to Slack/Surplus 0.00000 0.00000 20.00000 to 1Ds 260 40 s 360 140 s 2,500 E,S, D 20 to 260.00000 360.00000 2500.00000 1 RNS 2 units units units 4 Reduced Cost 0.00000 0.00000 -24.00000 Objective Allowable Allowable Coefficient Increase Decrease 63.00000 12.00000 15.50000 95.00000 31.00000 8.00000 135.00000 24.00000 Infinite (a) Identify the range of optimality for each objective function coefficient. (If there is no upper or lower limit, enter NO LIMIT.) to to Manufacturing Time (hours) to 8 12 Fan motors Cooling coils Manufacturing time Dual Value 31.00000 32.00000 0.00000 14 (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? Allowable Allowable Increase 5.00000 5.00000 (c) Identify the range of feasibility for the right-hand-side values. (If there is no upper or lower limit, enter NO LIMIT.) constraint 1 Decrease 80.00000 100.00000 20.00000
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
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
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.