Book1 - Microsoft Excel 12.0 Sensitivity Report Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 3/1/2010 9:41:44 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Dec Var x1 40 0 400 1.00E+030 172 $D$4 Dec Var x2 0 -325 275 325 1.00E+030 $E$4 Dec Var x3 0 -143.33 190 143.33 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $I$9 Wood 280 0 2250 1.00E+030 1970 $I$10 Upholster 480 0 1000 1.00E+030 520 $I$11 Labor 240 66.67 240 260 240 $I$12 Space 40 0 650 1.00E+030 610
Background image of page 1

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

View Full DocumentRight Arrow Icon
sofa table chair x1 x2 x3 Objective Function Dec Var 40 0 0 16000 Parameters Profit 400 275 190 RHS Const Wood 7 12 6 2250 Wood 280 Upholst 12 0 7 1000 Upholster 480 Labor 6 9 5 240 Labor 240 Space 1 1 1 650 Space 40
Background image of page 2
traints <= 2250 <= 1000 <= 240 <= 650
Background image of page 3

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: [Book1]Sheet2 Report Created: 3/1/2010 10:18:43 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Book1 - Microsoft Excel 12.0 Sensitivity Report Worksheet:...

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

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