Merton Truck Company

Merton Truck Company - Microsoft Excel 12.0 Answer Report...

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 Truck Company.xlsx]Sheet1 Report Created: 03-08-2010 19:31:55 Target Cell (Max) Cell Name Original Value Final Value $B$8 Objetive Function Model 101 7500000 10999999.9242 Adjustable Cells Cell Name Original Value Final Value $B$4 Units Model 101 0 2000.00005052 $C$4 Units Model 102 1500 999.999954526 Constraints Cell Name Cell Value Formula Status Slack $D$13 Engine Assembly Used 3999.99995958 $D$13<=$F$13 Not Binding 4.04246E-005 $D$14 Metal Stamping Used 6000.0000101 $D$14<=$F$14 Not Binding 1.00997E-005 $D$15 Model 101 assembly Used 4000.00010105 $D$15<=$F$15 Not Binding 999.999899 $D$16 Model 102 assembly Used 2999.99986358 $D$16<=$F$16 Not Binding 1500.000136
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 Truck Company.xlsx]Sheet1 Report Created: 03-08-2010 19:31:55 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Units Model 101 2000.000051 0 3000.000026 1999.999961 499.9999755 $C$4 Units Model 102 999.9999545 0 5000 999.9999309 1999.999966 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$13 Engine Assembly Used 3999.99996 2000.000012 4000 500.0000341 499.9999368 $D$14 Metal Stamping Used 6000.00001 499.9999882 6000 499.9999368 1000.000045 $D$15 Model 101 assembly Used 4000.000101
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.

This note was uploaded on 03/01/2012 for the course STRATEGY Om121 taught by Professor Abhinavdhar during the Spring '12 term at Harvard.

Page1 / 9

Merton Truck Company - Microsoft Excel 12.0 Answer 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