Fig8-32 - 7.00 $E$10 Labor Req'd Used 1566.00 16.67 1566.00...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Aqua-Spas Hydro-Luxes Typhoon-Lagoons Number to make 122 78 0 Total Profit Unit Profits $350 $300 $320 $66,100 Constraints Used Available Pumps Req'd 1 1 1 200 200 Labor Req'd 9 6 8 1566 1566 Tubing Req'd 12 16 13 2712 2880 Blue Ridge Hot Tubs Maximize: D6 By changing: B5:C5 Subject to: D9:D11<=E9:E11 B5:C5>=0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Fig8-32.xls]Production Report Report Created: 04/08/2007 16:10:54 PM Target Cell (Max) Cell Name Final Value $E$6 Unit Profits Total Profit 66100 Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$5 Number to make Aqua-Spas 122.00 0.00 350.00 100.00 $C$5 Number to make Hydro-Luxes 78.00 0.00 300.00 50.00 $D$5 Number to make Typhoon-Lagoons 0.00 -13.33 320.00 13.33 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $E$9 Pumps Req'd Used 200.00 200.00 200.00
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7.00 $E$10 Labor Req'd Used 1566.00 16.67 1566.00 234.00 $E$11 Tubing Req'd Used 2712.00 0.00 2880.00 1.00E+030 Allowable Decrease 20.00 40.00 1.00E+030 Allowable Decrease 26.00 126.00 168.00 Microsoft Excel 12.0 Sensitivity Report Worksheet: [Fig8-32.xls]Production Report Report Created: 04/08/2007 16:11:12 PM Target Cell (Max) Cell Name Final Value $E$6 Unit Profits Total Profit 66100 Adjustable Cells Final Reduced Cell Name Value Gradient $B$5 Number to make Aqua-Spas 122.00 0.00 $C$5 Number to make Hydro-Luxes 78.00 0.00 $D$5 Number to make Typhoon-Lagoons 0.00-13.33 Constraints Final Lagrange Cell Name Value Multiplier $E$9 Pumps Req'd Used 200.00 200.00 $E$10 Labor Req'd Used 1566.00 16.67 $E$11 Tubing Req'd Used 2712.00 0.00...
View Full Document

This note was uploaded on 05/20/2010 for the course DATA MODEL 4567 taught by Professor Dr.sawar during the Spring '10 term at Universidad San Jorge.

Page1 / 4

Fig8-32 - 7.00 $E$10 Labor Req'd Used 1566.00 16.67 1566.00...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online