Not sure where im going wrong it is saying no answer for solver not sure why mine is differnet then others who have answered this. if you could show as simple as possible what to put in to produce the reports

1. Update the model with the profit of $300 for a unit of Aqua-Spas, $350 for a unit of Hydro-Luxes, and $330 for a unit of Typhoon-Lagoons. (30%) 2. Run the Excel solver using Simplex LP under the Select a Solving Method and generate an answer report and a sensitivity report (20%: 10% for each). The solver generates Answer Report 1" and Sensitivity Report 1." 3. Insert a textbox in the sheet of Production Report" and then answer the following questions: Calculate the reduced cost of Typhoon-Lagoons (10%) o In the textbox, explain the reduced cost of Hydro-Luxes. (10%) In the textbox, explain the shadow price of Labor. (10%) o In the textbox, explain what would happen if two pumps are defective due to an accident in the company's warehouse. (use the Sensitive Report) (10%) o o B D E F A 1 Blue Ridge Hot Tubs 2 3 4 Total Profit: 5 6 7 Number to make: Unit profit: Aqua-Spa 0 $300 Hydro-Lux Typhoon-Lagoons 0 0 $350 $330 8 9 10 Used: Available: 1 11 12 13 Constraints: Pumps required: Labor required: Tubing required: 1 9 12 6 16 1 8 13 200 1,566 2,880 1 A B C D E F Blue Ridge Hot Tubs 1 2 3 4 Total Profit: $67,870 o 7 Number to make: Unit profit: Aqua-Spa 0 $300 Hydro-Lux Typhoon-Lagoons 93.34 106.67 $350 $330 8 9 10 Used: Available: 1 1 1 200 200.01 11 12 13 Constraints: Pumps required: Labor required: Tubing required: 9 6 8 13 141 A 1,413 2,880 12 16 2880 14