Assignment Help

 Using Excel, download Figure 3-1 and run solver to solve the optimization. Then create a brand new excel file from scratch and re-create this figure 3-1 Hot Tubs model. Include your first and last name in your file. Feel free to change the font color size or customize your worksheet in any way that you would like. 

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=0

,

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=0