Answer:
Using Excel solver, the optimal solution is: 122 Aqua-Spa + 78 Hydro-Lux, and the maximum profit = $66,100
Explanation:
you have to maximize the following equation: 350A + 300H
where:
A = number of Aqua-Spa hot tubs sold
H = number of Hydro-Lux hot tubs sold
the constraints are:
A + H ≤ 200 ⇒ number of water pumps available
9A + 6H ≤ 1,566 ⇒ number of labor hours available
12A + 16H ≤ 2,880 ⇒ number of feet of tubing available
A ≥ 0 ⇒ non-negative numbers
B ≥ 0 ⇒ non-negative numbers
both A and B are integers
Using Excel solver, the optimal solution is: 122A + 78B, and the maximum profit = $66,100
