Model A B C Labor Hours Used Hours Available Tubing Pumps Blue Ridge Hot Tubs A B C Number to Assembl Require Make y hours Resources Used Demand Min 15 12 10 3 Max 22 130 Available 650 88 Pumps Tubing Require 30 40 45 d 1 1 2 d A B C 11 10 12 Profit/Unit $ 96.00 $75.00 $11 Blue Ridge Hot Tubs is a local company that just received a donation of tubes and pumps used for hot tubs. The company wants to know how many of each model they should make in order to maximize their profits. They need to stay within the amount of available hours, can't make more than what they have the resources for, and want to stay within the minimum and maximum demand.
Model A B C Labor Hours Used Hours Available Tubing Pumps Blue Ridge Hot Tubs A B C Number to Assembl Require Make y hours Resources Used Demand Min 15 12 10 3 Max 22 130 Available 650 88 Pumps Tubing Require 30 40 45 d 1 1 2 d A B C 11 10 12 Profit/Unit $ 96.00 $75.00 $11 Blue Ridge Hot Tubs is a local company that just received a donation of tubes and pumps used for hot tubs. The company wants to know how many of each model they should make in order to maximize their profits. They need to stay within the amount of available hours, can't make more than what they have the resources for, and want to stay within the minimum and maximum demand.
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

Transcribed Image Text:3
4
(Hot Tubs) What is the amount of Tubing used?
600
590
645
650
(Hot Tubs) How many model C should Blue Ridge Hot Tubs make?
012
15
28
30

Transcribed Image Text:Model
A
B
C
Labor Hours Used
Hours Available
Tubing
Pumps
A
B
C
Blue Ridge Hot Tubs
Total Profit
Pumps Tubing
Number to Assembl Require Require
Make
y hours
d
Resources
Used
Demand
Min
15
12
10
322
Max
130
Available
650
88
30
40
45
d
112
A
B
C
11
10
12
Profit/Unit
$ 96.00
$ 75.00
$ 116.00
Blue Ridge Hot Tubs is a local company that just
received a donation of tubes and pumps used
for hot tubs. The company wants to know how
many of each model they should make in order
to maximize their profits. They need to stay
within the amount of available hours, can't
make more than what they have the resources
for, and want to stay within the minimum and
maximum demand.
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 5 steps with 4 images

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.