Q5.2. How much the objective function would change if the number of pumps would increase by 5 units? Q5.3. How much the objective function would change if the number of feet of tubing would increase by 10 units? ( Q. 5.4. Would it be profitable to introduce a new product, Typhoon Lagoon, with profit contribution $ 320 per unit and resource requirements 1 pump, 8 labor hours, and 13 feet of tubing per unit?

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...
icon
Related questions
Question
Given information below
profit in $
pumps
labor hours
feet of tubing
Aqua-Spa (x1) Hydro-Lux (x2)
1
2
MAX
S.T.
350
1
9
12
300
1
6
16
x₁ = # of Aqua-Spa hot tubs to produce
x₂ = # of Hydro-Lux hot tubs to produce
350x1 + 300x2
x1 + x₂ ≤ 200
9x1+6x2 ≤ 1566
12x₁ +16x2 ≤2880
*120
X220
total
950
3
21
44
RHS
200
1566
2880
(total profit in $)
(pumps)
(labor hours)
(feet of tubing)
Q5.1. How many resources were used to produce the optimal solution?
Transcribed Image Text:Given information below profit in $ pumps labor hours feet of tubing Aqua-Spa (x1) Hydro-Lux (x2) 1 2 MAX S.T. 350 1 9 12 300 1 6 16 x₁ = # of Aqua-Spa hot tubs to produce x₂ = # of Hydro-Lux hot tubs to produce 350x1 + 300x2 x1 + x₂ ≤ 200 9x1+6x2 ≤ 1566 12x₁ +16x2 ≤2880 *120 X220 total 950 3 21 44 RHS 200 1566 2880 (total profit in $) (pumps) (labor hours) (feet of tubing) Q5.1. How many resources were used to produce the optimal solution?
Q5.2. How much the objective function would change if the number of pumps would increase by
5 units?
Q5.3. How much the objective function would change if the number of feet of tubing would
increase by 10 units? (
Q. 5.4. Would it be profitable to introduce a new product, Typhoon Lagoon, with profit
contribution $ 320 per unit and resource requirements 1 pump, 8 labor hours, and 13 feet of
tubing per unit?
Transcribed Image Text:Q5.2. How much the objective function would change if the number of pumps would increase by 5 units? Q5.3. How much the objective function would change if the number of feet of tubing would increase by 10 units? ( Q. 5.4. Would it be profitable to introduce a new product, Typhoon Lagoon, with profit contribution $ 320 per unit and resource requirements 1 pump, 8 labor hours, and 13 feet of tubing per unit?
Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.