2.17.11 - Microsoft Excel 12.0 Answer Report Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [P4.7.xlsx]Sheet1 Report Created: 08/04/2010 7:10:43 PM Target Cell (Max) Cell Name Original Value Final Value $J$4 Max P = 250G + 150A Max P 0 32500 Adjustable Cells Cell Name Original Value Final Value $H$2 Production G 0 130 $I$2 Production A 0 0 Constraints Cell Name Cell Value Formula Status Slack $J$6 Wiring Required 260 $J$6<=$L$6 Binding 0 $J$7 Testing Required 130 $J$7<=$L$7 Not Binding 10
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: [P4.7.xlsx]Sheet1 Report Created: 08/04/2010 7:10:44 PM Adjustable Cells Cell Name $H$2 Production G $I$2 Production A Constraints Cell Name $J$6 Wiring Required $J$7 Testing Required
Background image of page 2
change in your objective function by Final Reduced Objective Allowable Value Cost Coefficient Increase 130 0 250 1.00E+030 0 -225 150 225 Final Shadow Constraint Allowable Value Price R.H. Side Increase 260 125 260 20 130 0 140 1.00E+030
Background image of page 3

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

View Full DocumentRight Arrow Icon
y 1; gain $ in revenue Allowable Decrease 150 1.00E+030 Allowable Decrease 260 10 we can add 10 hours because this says 20
Background image of page 4
Microsoft Excel 12.0 Limits Report
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

2.17.11 - Microsoft Excel 12.0 Answer Report Worksheet:...

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

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