blue ridge hot tubs 2
TRANSCRIPT
-
8/6/2019 Blue Ridge Hot Tubs 2
1/26
Microsoft Excel 12.0 Answer Report
Worksheet: [Blue Ridge Hot Tubs.xlsx]Sheet1
Report Created: 04/21/2009 18:38:52 PM
Result: Solver found a solution. All constraints and optimality conditio
Engine: Standard LP Simplex
Solution Time: 00 Seconds
Iterations: 2Subproblems: 0
Incumbent Solutions: 0
Target Cell (Max)
Cell Name Original Value Final Value
$D$6 Unit Profits Total Profit 66100 66100
Adjustable CellsCell Name Original Value Final Value
$B$5 Number to Make Aqua-Spas 122 122
$C$5 Number to Make Hydro-Luxes 78 78
Constraints
Cell Name Cell Value Formula
$D$11 Tubing Req'd Used 2712 $D$11
-
8/6/2019 Blue Ridge Hot Tubs 2
2/26
s are satisfied.
Status Slack
Not Binding 168
Binding 0
Binding 0
Not Binding 168
-
8/6/2019 Blue Ridge Hot Tubs 2
3/26
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Blue Ridge Hot Tubs.xlsx]Sheet1
Report Created: 04/21/2009 18:38:52 PM
Target Cell (Max)
Cell Name Final Value
$D$6 Unit Profits Total Profit 66100
Adjustable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$B$5 Number to Make Aqua-Spas 122 0 350
$C$5 Number to Make Hydro-Luxes 78 0 300
Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side$D$11 Tubing Req'd Used 2712 0 2880
$D$9 Pumps Req'd Used 200 200 200
$D$10 Labor Req's Used 1566 16.67 1566
$D$11 Tubing Req'd Used 2712 0 2880
If allowable in
If allowable d
Change in OF
Shadow price
-
8/6/2019 Blue Ridge Hot Tubs 2
4/26
Allowable Allowable
Increase Decrease
100 50
50 66.67
Allowable Allowable
Increase Decrease1.00E+030 168
7 1.00E+030
234 126
1.00E+030 168
crease = 0 , change the objective to Maximize
crease= 0 , change the objective to Minimize
V= Change in RHS *Shadow Price
s for nonbinding constraints are always 0.
-
8/6/2019 Blue Ridge Hot Tubs 2
5/26
Microsoft Excel 12.0Limits Report
Worksheet: [Blue Ridge Hot Tubs.xlsx]Sheet1
Report Created: 04/21/2009 18:38:52 PM
Target
Cell Value$D$6 Unit Profits Total Profit $66,100
Adjustable Lower Target Upper
Cell Name Value Limit Result Limit
$B$5 Number to Make Aqua-Spas 122 0 $23,400 122
$C$5 Number to Make Hydro-Luxes 78 0 $42,700 78
-
8/6/2019 Blue Ridge Hot Tubs 2
6/26
Target
Result
$66,100
$66,100
-
8/6/2019 Blue Ridge Hot Tubs 2
7/26
Microsoft Excel 12.0 Answer Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 18:59:46 PM
Result: Solver found a solution. All constraints and optimality conditio
Engine: Standard LP Simplex
Solution Time: 00 Seconds
Iterations: 2Subproblems: 0
Incumbent Solutions: 0
Target Cell (Max)
Cell Name Original Value Final Value
$D$6 Unit Profits Total Profit 66100 68800
Adjustable CellsCell Name Original Value Final Value
$B$5 Number to Make Aqua-Spas 122 176
$C$5 Number to Make Hydro-Luxes 78 24
Constraints
Cell Name Cell Value Formula
$D$11 Tubing Req'd Used 2496 $D$11
-
8/6/2019 Blue Ridge Hot Tubs 2
8/26
s are satisfied.
Status Slack
Not Binding 384
Binding 0
Binding 0
Not Binding 384
-
8/6/2019 Blue Ridge Hot Tubs 2
9/26
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 18:59:46 PM
Target Cell (Max)
Cell Name Final Value
$D$6 Unit Profits Total Profit 68800
Adjustable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$B$5 Number to Make Aqua-Spas 176 0 350
$C$5 Number to Make Hydro-Luxes 24 0 300
Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side$D$11 Tubing Req'd Used 2496 0 2880
$D$9 Pumps Req'd Used 200 200 200
$D$10 Labor Req's Used 1728 16.67 1728
$D$11 Tubing Req'd Used 2496 0 2880
-
8/6/2019 Blue Ridge Hot Tubs 2
10/26
Allowable Allowable
Increase Decrease
100 50
50 66.67
Allowable Allowable
Increase Decrease1.00E+030 384
16 1.00E+030
1.00E+030 288
1.00E+030 384
-
8/6/2019 Blue Ridge Hot Tubs 2
11/26
Microsoft Excel 12.0Limits Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 18:59:47 PM
Target
Cell Value$D$6 Unit Profits Total Profit $68,800
Adjustable Lower Target Upper
Cell Name Value Limit Result Limit
$B$5 Number to Make Aqua-Spas 176 0 $7,200 176
$C$5 Number to Make Hydro-Luxes 24 0 $61,600 24
-
8/6/2019 Blue Ridge Hot Tubs 2
12/26
Target
Result
$68,800
$68,800
-
8/6/2019 Blue Ridge Hot Tubs 2
13/26
Microsoft Excel 12.0 Answer Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:01:39 PM
Result: Solver found a solution. All constraints and optimality conditio
Engine: Standard LP Simplex
Solution Time: 00 Seconds
Iterations: 2Subproblems: 0
Incumbent Solutions: 0
Target Cell (Max)
Cell Name Original Value Final Value
$D$6 Unit Profits Total Profit 68800 72000
Adjustable CellsCell Name Original Value Final Value
$B$5 Number to Make Aqua-Spas 176 144
$C$5 Number to Make Hydro-Luxes 24 72
Constraints
Cell Name Cell Value Formula
$D$11 Tubing Req'd Used 2880 $D$11
-
8/6/2019 Blue Ridge Hot Tubs 2
14/26
s are satisfied.
Status Slack
Binding 0
Not Binding 34
Binding 0
Binding 0
-
8/6/2019 Blue Ridge Hot Tubs 2
15/26
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:01:39 PM
Target Cell (Max)
Cell Name Final Value
$D$6 Unit Profits Total Profit 72000
Adjustable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$B$5 Number to Make Aqua-Spas 144 0 350
$C$5 Number to Make Hydro-Luxes 72 0 300
Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side$D$11 Tubing Req'd Used 2880 0 2880
$D$9 Pumps Req'd Used 216 0 250
$D$10 Labor Req's Used 1728 27.78 1728
$D$11 Tubing Req'd Used 2880 8.33 2880
-
8/6/2019 Blue Ridge Hot Tubs 2
16/26
Allowable Allowable
Increase Decrease
100 125
166.67 66.67
Allowable Allowable
Increase Decrease1.00E+030 0
1.00E+030 34
612 1.00E+030
0 1.00E+030
-
8/6/2019 Blue Ridge Hot Tubs 2
17/26
Microsoft Excel 12.0Limits Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:01:39 PM
Target
Cell Value$D$6 Unit Profits Total Profit $72,000
Adjustable Lower Target Upper
Cell Name Value Limit Result Limit
$B$5 Number to Make Aqua-Spas 144 0 $21,600 144
$C$5 Number to Make Hydro-Luxes 72 0 $50,400 72
-
8/6/2019 Blue Ridge Hot Tubs 2
18/26
Target
Result
$72,000
$72,000
-
8/6/2019 Blue Ridge Hot Tubs 2
19/26
Microsoft Excel 12.0 Answer Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:02:11 PM
Result: Solver found a solution. All constraints and optimality conditio
Engine: Standard LP Simplex
Solution Time: 00 Seconds
Iterations: 2Subproblems: 0
Incumbent Solutions: 0
Target Cell (Max)
Cell Name Original Value Final Value
$D$6 Unit Profits Total Profit 72000 67500
Adjustable CellsCell Name Original Value Final Value
$B$5 Number to Make Aqua-Spas 144 108
$C$5 Number to Make Hydro-Luxes 72 99
Constraints
Cell Name Cell Value Formula
$D$11 Tubing Req'd Used 2880 $D$11
-
8/6/2019 Blue Ridge Hot Tubs 2
20/26
s are satisfied.
Status Slack
Binding 0
Not Binding 43
Binding 0
Binding 0
-
8/6/2019 Blue Ridge Hot Tubs 2
21/26
Microsoft Excel 12.0 Sensitivity Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:02:11 PM
Target Cell (Max)
Cell Name Final Value
$D$6 Unit Profits Total Profit 67500
Adjustable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$B$5 Number to Make Aqua-Spas 108 0 350
$C$5 Number to Make Hydro-Luxes 99 0 300
Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side$D$11 Tubing Req'd Used 2880 0 2880
$D$9 Pumps Req'd Used 207 0 250
$D$10 Labor Req's Used 1566 27.78 1566
$D$11 Tubing Req'd Used 2880 8.33 2880
-
8/6/2019 Blue Ridge Hot Tubs 2
22/26
Allowable Allowable
Increase Decrease
100 125
166.67 66.67
Allowable Allowable
Increase Decrease1.00E+030 0
1.00E+030 43
774 1.00E+030
0 1.00E+030
-
8/6/2019 Blue Ridge Hot Tubs 2
23/26
Microsoft Excel 12.0Limits Report
Worksheet: [Blue Ridge Hot Tubs 2.xls]Sheet1
Report Created: 04/21/2009 19:02:11 PM
Target
Cell Value$D$6 Unit Profits Total Profit $67,500
Adjustable Lower Target Upper
Cell Name Value Limit Result Limit
$B$5 Number to Make Aqua-Spas 108 0 $29,700 108
$C$5 Number to Make Hydro-Luxes 99 0 $37,800 99
-
8/6/2019 Blue Ridge Hot Tubs 2
24/26
Target
Result
$67,500
$67,500
-
8/6/2019 Blue Ridge Hot Tubs 2
25/26
Blue Ridge Hot Tubs
Aqua-Spas Hydro-Luxes
Number to Make 108 99 Total Profit
Unit Profits $350 $300 $67,500
Constraints Used
Pumps Req'd 1 1 207
Labor Req's 9 6 1566
Tubing Req'd 12 16 2880
-
8/6/2019 Blue Ridge Hot Tubs 2
26/26
Available
250
1566
2880