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

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