JB_Q3-14 - Microsoft Excel 9.0 Answer Report Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [JB_Q3-14.xls]Sheet1 Report Created: 2010/9/30 23:05:38 Target Cell (Min) Cell Name Original Value Final Value $B$4 Objective 0 7 Adjustable Cells Cell Name Original Value Final Value $B$6 y1 0 0 $B$7 y1' 0 3 $B$8 y2 0 8 $B$9 y2' 0 0 Constraints Cell Name Cell Value Formula Status Slack $B$11 Con1 11 $B$11=$C$11 Binding 0 $B$12 Con2 13 $B$12>=$C$12Not Binding 3 $B$13 Con3 3 $B$13<=$C$13Binding 0 $B$14 Non-neg1 0 $B$14>=$C$14Binding 0 $B$15 Non-neg2 3 $B$15>=$C$15Not Binding 3 $B$16 Non-neg3 8 $B$16>=$C$16Not Binding 8 $B$17 Non-neg4 0 $B$17>=$C$17Binding 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 9.0 Sensitivity Report Worksheet: [JB_Q3-14.xls]Sheet1 Report Created: 2010/9/30 23:05:38 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 y1 0 0 3 1.00E+030 0 $B$7 y1' 3 0 -3 5 0 $B$8 y2 8 0 2 1.00E+030 0 $B$9 y2' 0 0 -2 1.00E+030 0 Constraints Final Shadow Constraint Allowable Allowable
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

JB_Q3-14 - Microsoft Excel 9.0 Answer Report Worksheet:...

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

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