Fig3-1.xlsm

Production Report

Aqua-Spas Hydro-Luxes
Number to Make 0
A satisfied Microsoft Office user: Variable cell
0
A satisfied Microsoft Office user: Variable cell
Total Profit
Unit Profits $350 $300 $0
A satisfied Microsoft Office user: Objective cell
Constraints Used Available
Pumps Req'd 1.0 1.0 0
A satisfied Microsoft Office user: Constraint cell
200
Labor Req'd 9.0 6.0 0.0
A satisfied Microsoft Office user: Constraint cell
1566.0
Tubing Req'd 12.0 16.0 0.0
A satisfied Microsoft Office user: Constraint cell
2880.0
0.0

Blue Ridge Hot Tubs

Maximize: D6 By changing: B5:C5 Subject to: D9:D11<=E9:E11 B5:C5>=0