J9 Job 2 Net flow 3750 J9L9 Binding J10 Job 3 Net flow 4850 J10L10 Binding

J9 job 2 net flow 3750 j9l9 binding j10 job 3 net

This preview shows page 1 - 5 out of 7 pages.

$J$9 Job 2 Net flow 3750 $J$9=$L$9 Binding 0 $J$10 Job 3 Net flow 4850 $J$10=$L$10 Binding 0
Image of page 1
Image of page 2
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Module 6 problem set.xlsx]P5-13 (a) Report Created: 2/8/2017 3:12:11 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Central Job 1 0 1 9 1.00E+030 1 $C$5 Central Job 2 0 1 8 1.00E+030 1 $D$5 Central Job 3 1100 0 7 1 1 $B$6 Rock Job 1 250 0 7 1 4 $C$6 Rock Job 2 0 5 11 1.00E+030 5 $D$6 Rock Job 3 3750 0 6 1 1 $B$7 Acme Job 1 2250 0 4 4 1 $C$7 Acme Job 2 3750 0 3 1 1.00E+030 $D$7 Acme Job 3 0 9 12 1.00E+030 9 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $J$5 Central Net flow -1100 0 -3000 1900 1.00E+030 $J$6 Rock Net flow -4000 1 -4000 1900 1100 $J$7 Acme Net flow -6000 4 -6000 1900 250 $J$8 Job 1 Net flow 2500 8 2500 1900 250 $J$9 Job 2 Net flow 3750 7 3750 1900 250 $J$10 Job 3 Net flow 4850 7 4850 1900 1100
Image of page 3
Problem 5-13 Shipments: To Flow balance equations From Job 1 Job 2 Job 3 Flow out Location Flow in Flow out Net flow Sign Central 0.0 0.0 1100.0 1100.0 Central 0 1100 -1100 >= Rock 250.0 0.0 3750.0 4000.0 Rock 0 4000 -4000 >= Acme 2250.0 3750.0 0.0 6000.0 Acme 0 6000 -6000 >= Flow in 2500.0 3750.0 4850.0 Job 1 2500 0.0 2500 = Job 2 3750 0.0 3750 = Unit costs: To Job 3 4850 0.0 4850 = From Job 1 Job 2 Job 3 Central $9 $8 $7 Rock $7 $11 $6 Acme $4 $3 $12 Total cost = $52,200 <--- Minimize total transportation costs. Formula = SUMPRODUCT(B5:D7,B1 Note:
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '15
  • mason
  • Book of Job, Book of Proverbs, Acme Net

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture