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

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Merton.xlsx]Sheet1 Report Created: 01-08-2010 04:31:25 PM Target Cell (Max) Cell Name Original Value Final Value $D$7 Contribution 11000000 11000000 Adjustable Cells Cell Name Original Value Final Value $B$4 Model 101 2000 2000 $C$4 Model 102 1000 1000 Constraints Cell Name Cell Value Formula Status Slack $E$11 Engine Capacity Sumproduct 4000 $E$11<=$G$11 Binding 0 $E$12 Metal Stamping Sumproduct 6000 $E$12<=$G$12 Binding 0 $E$13 Model 101 Assembly Sumproduct 4000 $E$13<=$G$13 Not Binding 1000 $E$14 Model 102 Assembly Sumproduct 3000 $E$14<=$G$14 Not Binding 1500
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: [Merton.xlsx]Sheet1 Report Created: 01-08-2010 04:31:26 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Model 101 2000 0 3000 2000 500 $C$4 Model 102 1000 0 5000 1000 2000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side
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 / 6

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

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