Transportation example, pr.5

Transportation example, pr.5 - Microsoft Excel 9.0 Answer...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Book1]Sheet1 Target Cell (Min) Cell Name Original Value Final Value $B$14 Min cost x11 0 11900 Adjustable Cells Cell Name Original Value Final Value $B$12 x11 0 200 $C$12 x12 0 0 $D$12 x13 0 300 $E$12 x21 0 200 $F$12 x22 0 200 $G$12 x23 0 0 Constraints Cell Name Cell Value Formula Status Slack $B$16 s.t. x11 500 $B$16<=$E$16 Binding 0 $B$17 x11 400 $B$17<=$E$17 Binding 0 $B$18 x11 400 $B$18=$E$18 Binding 0 $B$19 x11 200 $B$19=$E$19 Not Binding 0 $B$20 x11 300 $B$20=$E$20 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
Worksheet: [Book1]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 x11 200 0 10 2 1 $C$12 x12 0 7 20 1.00E+030 7 $D$12 x13 300 0 15 1 1.00E+030 $E$12 x21 200 0 12 1 2 $F$12 x22 200 0 15 7 1.00E+030 $G$12 x23 0 1 18 1.00E+030 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 s.t. x11 500 -2 500 200 0 $B$17 x11 400 0 400 1.00E+030 0 $B$18 x11
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 11/18/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Page1 / 5

Transportation example, pr.5 - Microsoft Excel 9.0 Answer...

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