Problem 3-EXTRA POINTS (150) Use Chapter 19, Section 19.3. pare $40 torst started using solver. Blue Ridge Hot Tubs The Problem Blue Ridge Hot Tulos, Inc, sells two models of hot tubs: The Agus-Spa and the Hydro-Lux. The company purchases prefabricated fiberglass hot tub shells and installs a common water pump and the appropriate amount of tubing into each hot tub. The number of hours at takes to install each model the tubing required, and the profit for each of the two models is described in the table below. Hot Tub Model Installation Labor Hours Tubing Required Profit Aqua Spa 12 $350 Hydro-lus 6 16 $300 9 The company expects to have 200 pumps, 1.566 hours of labor and 2880 feet of tubing available during the next production cycle. The company can sell all the hot tubs it makes Create an excel solver spreadsheet model to determine the optimal number of Aqua-Spa and Hydro- Lux hot tubs to produce in order to maximize profits Steps: 1. Arrange the data in the excel spreadsheet 2. Add formulas to the model 3. Use the solver function to find the best solution 4. Also run and include the "Answer Report and the sensitivity Report for the problem. Provide excel worksheet, answer and sensitivity reports. Your worksheet should reflect this information: Blue Ridge Hot Tubs Total Profit Aqua Spa Hydro-Lex S Namber to make Unit profit: Constraints Paupsrariral | Lahar retirel Tubing required 5 Aqua Spa Hydro-Lex Used Available Problem 3-EXTRA POINTS (150) Use Chapter 19, Section 19.3. pare $40 torst started using solver. Blue Ridge Hot Tubs The Problem Blue Ridge Hot Tulos, Inc, sells two models of hot tubs: The Agus-Spa and the Hydro-Lux. The company purchases prefabricated fiberglass hot tub shells and installs a common water pump and the appropriate amount of tubing into each hot tub. The number of hours at takes to install each model the tubing required, and the profit for each of the two models is described in the table below. Hot Tub Model Installation Labor Hours Tubing Required Profit Aqua Spa 12 $350 Hydro-lus 6 16 $300 9 The company expects to have 200 pumps, 1.566 hours of labor and 2880 feet of tubing available during the next production cycle. The company can sell all the hot tubs it makes Create an excel solver spreadsheet model to determine the optimal number of Aqua-Spa and Hydro- Lux hot tubs to produce in order to maximize profits Steps: 1. Arrange the data in the excel spreadsheet 2. Add formulas to the model 3. Use the solver function to find the best solution 4. Also run and include the "Answer Report and the sensitivity Report for the problem. Provide excel worksheet, answer and sensitivity reports. Your worksheet should reflect this information: Blue Ridge Hot Tubs Total Profit Aqua Spa Hydro-Lex S Namber to make Unit profit: Constraints Paupsrariral | Lahar retirel Tubing required 5 Aqua Spa Hydro-Lex Used Available