Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 1.10C

For the Lines They Are a-Changin’ (with apologies to Bob Dylan)

The owner of Blue Ridge Hot Tubs, Howie Jones, has asked for your assistance analyzing how the feasible region and solution to his production problem might change in response to changes in various parameters in the LP model. He is hoping this might further his understanding of LP and how the constraints, objective function, and optimal solution interrelate. To assist in this process, he asked a consulting firm to develop the spreadsheet shown earlier in Figure 2.8 (and the file Fig2-8.xlsm that accompanies this book) that dynamically updates the feasible region and optimal solution as the various parameters in the model change. Unfortunately, Howie has not had much time to play around with this spreadsheet, so he has left it in your hands and asked you to use it to answer the following questions. Click the Reset button in file Fig2-8.xlsm before answering each of the following questions.

Blue Ridge Hot Tubs manufactures and sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Howie Jones, the owner and manager of the company, needs to decide how many of each type of hot tub to produce during his next production cycle. Howie buys prefabricated fiberglass hot tub shells from a local supplier and adds the pump and tubing to the shells to create his hot tubs. (This supplier has the capacity to deliver as many hot tub shells as Howie needs.) Howie installs the same type of pump into both hot tubs. He will have only 200 pumps available during his next production cycle. From a manufacturing standpoint, the main difference between the two models of hot tubs is the amount of tubing and labor required. Each Aqua-Spa requires 9 hours of labor and 12 feet of tubing. Each Hydro-Lux requires 6 hours of labor and 16 feet of tubing. Howie expects to have 1,566 production labor hours and 2,880 feet of tubing available during the next production cycle. Howie earns a profit of $350 on each Aqua-Spa he sells and $300 on each Hydro-Lux he sells. He is confident that he can sell all the hot tubs he produces. The question is, how many Aqua-Spas and Hydro-Luxes should Howie produce if he wants to maximize his profits during the next production cycle?

By how much would the unit profit on Hydro-Luxes have to change before the optimal product mix changes?

Blurred answer
Students have asked these similar questions
elijah wants to start a carpet cleaning business. to do so, he needs to purchase a carpet cleaner and advertise. he estimates the cleaner will cost $400 and advertising will cost $1,600 initially. the cleaning solution is fairly cheap, costing only $5 per room cleaned. he also thinks he will have $3 in gas on average for each client. if he charges $40 per room cleaned and cleans an average of 2 rooms per house, how many houses will he have to clean before breaking even? if taxes are 25% of profits, how many rooms will he have to clean before making $5,000 profit? answer the question by making a cvp worksheet similar to the depreciation sheets. make sure it works well, uses cell references and functions/formulas when appropriate, and looks nice.
What insights can you gain from working in a laundry business while maintaining a balance in your personal life? What about the joy of doing your work?
How can you improve your lost and found system in laundry business? Like if there's a customer who has a missing garments and another customer found it accidentally in their clothes?
Knowledge Booster
Background pattern image
Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY