12 - 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: [12.xlsx]Sheet1 Report Created: 11/11/2010 11:15:37 AM Target Cell (Min) Cell Name Original Value Final Value $E$4 overtime d+ 0 0 Adjustable Cells Cell Name Original Value Final Value $D$4 overtime d- 0 0 $E$4 overtime d+ 0 0 $D$5 profit d- 135 135 $E$5 profit d+ 0 0 $D$6 demand d- 499 499 $E$6 demand d+ 0 0 $D$7 demand d- 399 399 $E$7 demand d+ 0 0 $D$8 underulitization d- 0 0 $E$8 underulitization d+ 0 0 $B$12 Newsprint Newsprint 0 0 $B$13 Wrapping paper Newsprint 660 660 Constraints Cell Name Cell Value Formula Status Slack $F$4 overtime Constraint total 5280 $F$4=$H$4 Not Binding 0 $F$5 profit Constraint total 300 $F$5=$H$5 Not Binding 0 $F$6 demand Constraint total 500 $F$6=$H$6 Not Binding 0 $F$7 demand Constraint total 400 $F$7=$H$7 Not Binding 0 $F$8 underulitization Constraint total 0 $F$8=$H$8 Not 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: [12.xlsx]Sheet1 Report Created: 11/11/2010 11:15:37 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$4 overtime d- 0 0 0 0 0 $E$4 overtime d+ 0 1 1 1.00E+030 1 $D$5 profit d- 135 0 0 0 0
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 09/01/2011 for the course BIT 2406 at Virginia Tech.

Page1 / 6

12 - 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