Steel enterprises

Steel enterprises - 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: [Steel enterprises.xlsx]Sheet1 Report Created: 24-07-2010 10:43:42 Target Cell (Max) Cell Name Original Value Final Value $E$12 Profit Total 61 8800 Adjustable Cells Cell Name Original Value Final Value $C$8 Units to Make Camshafts 1 99.9999999999 $D$8 Units to Make Gears 2 350 Constraints Cell Name Cell Value Formula Status Slack $E$16 Steel(lbs) Used 3300 $E$16<=$G$16 Not Binding 1700 $E$17 Labor(hrs) Used 1500 $E$17<=$G$17 Binding 0 $E$18 Machine Time (hrs) Used 1000 $E$18<=$G$18 Binding 0
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: [Steel enterprises.xlsx]Sheet1 Report Created: 24-07-2010 10:44:46 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Steel enterprises - 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