1. What is the value of objective function at its best according to your solution?

2. Use the sensitivity report: will the optimal solution point change if the profit contribution coefficient for Aqua Spa increases by $25? Can you estimate the objective function values without resolving the problem in Excel? Show calculations

3. Which constraints are binding? Is there any slack or surplus for each constraint?

4. You are given the following options: (a) the supplier of equipment contacted you that one additional pump is available next production cycle, but he asks to pay $50 for it (b) you got an approval to lower the minimum production level of Hydro-Lux models by 5 units (c) additional 100 feet of tubing is available without any cost. Between those three options, which one would be the best to choose? Use the sensitivity report and show calculations.

Red River Hot Tubs manufactures and sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Chris 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. Chris 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 Chris needs). Chris installs the same type of pump into both hot tubs. He will have only 183 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. Chris expects to have 1,566 production labor hours and 2,880 feet of tubing available during next production cycle. There is a minimum level of production for Hydro-Lux model 40 tubs. Chris earns a profit of $300 on each Aqua-Spa he sells and $250 on each Hydro-Lux he sells. He is confident that he can sell all the hot tubs he produces. The questions is, how many Aqua-Spas and Hydro-Luxes should Chris produce if he wants to maximize his profit during the next production cycle? Red River Hot Tubs manufactures and sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Chris 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. Chris 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 Chris needs). Chris installs the same type of pump into both hot tubs. He will have only 183 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. Chris expects to have 1,566 production labor hours and 2,880 feet of tubing available during next production cycle. There is a minimum level of production for Hydro-Lux model 40 tubs. Chris earns a profit of $300 on each Aqua-Spa he sells and $250 on each Hydro-Lux he sells. He is confident that he can sell all the hot tubs he produces. The questions is, how many Aqua-Spas and Hydro-Luxes should Chris produce if he wants to maximize his profit during the next production cycle