Question: Sheet: Blue Ridge Problem Statement: Alyssa Wise owns and operates Blue Ridge Hot Tubs, a company that sells two models of hot tubs: the Aqua-

Sheet: Blue Ridge Problem Statement: Alyssa WiseSheet: Blue Ridge Problem Statement: Alyssa Wise

Sheet: Blue Ridge Problem Statement: Alyssa Wise owns and operates Blue Ridge Hot Tubs, a company that sells two models of hot tubs: the Aqua- Spa and the Hydro-Lux. Alyssa purchases prefabricated fiberglass hot tub shells and installs common water pumps and the appropriate amount of tubing into each hot tub. Every Aqua-Spa requires a pump, 12 hours of labor and 16 feet of tubing. Every Hydro-Lux requires 2 pumps, 16 hours of labor and 8 feet of tubing. Demand for these products is such that each Aqua-Spa produced can be sold to generate a profit of $275, and each Hydro-Lux produced can be sold to generate a profit of $250. The company expects to have 450 pumps, 91 workers, and 3,080 feet of tubing available during the next week's production cycle. All employees work their 40 hours with no overtime. Using the Blue Ridge Sheet and Excel Solver, determine the optimal number of Aqua-Spas and Hydro-Luxes to produce to maximize profit. Blue Ridge Hot Tubs Decision Variables Aqua-Spa Hydro-Lux Total Profit Quantity Profit/Tub Constraints # Used Per Aqua-Spa # Used Per Hydro-Lux Total Used Available

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!