Li, Mengheng - Microsoft Excel 14.0 Sensitivity Report...

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

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 4/20/2011 8:23:46 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $K$5 x1 number 700 0 3 2 0.7777777778 $K$6 x2 number 0 -1.3833333333 3 1.3833333333 1.0000E+030 $K$7 x3 number 133.3333333 0 5 1.75 2 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$8 plastic 1000 1.1666666667 1000 200 466.6666667 $H$8 chrome 866.6666667 0 1200 1.0000E+030 333.3333333 $I$8 stainless steel 2000 0.8 2000 555.5555556 333.3333333
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 14.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 4/20/2011 8:46:39 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $R$5 x1 new number 700 0 2.5 2.5 0.2777777778 $R$6 x2 new number 0 -0.7083333333 3 0.7083333333 1.0000E+030 $R$7 x3 new number 133.3333333 0 5 0.625 2.5 Constraints Final Shadow Constraint
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Li, Mengheng - Microsoft Excel 14.0 Sensitivity Report...

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

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