{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Transportation example, pr.5

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

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

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

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

View Full Document
Microsoft Excel 9.0 Sensitivity Report 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 400 12 400 0 200 \$B\$19 x11 200 15 200 0 200 \$B\$20 x11 300 17 300 0 200
Problem 5, Transportation, pg 344 Data Destinations Sources Hamilton Butler Clermont SUPPLY S. Gas 10 20 15 500 N. Gas 12 15 18 400 DEMAND 400 200 300 Model Variables x11 x12 x13 x21 x22 x23 200 0 300 200 200 0 Min cost 11900 s.t. 500 <= 500 400 <= 400 400 = 400 200 = 200 300 = 300

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

View Full Document