gases - Formulas Industrial Gases Transportation Problem...

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

View Full Document Right Arrow Icon
dae55e9cfcdac9109d80ae9bfd6abf797c6f1c5b.xls Values Industrial Gases Transportation Problem Unit Unit shipping costs to Customer Total Production 1 2 3 4 5 Available Cost Plant 1 $8 $6 $7 $10 $9 45 $40 From Plant 2 $9 $12 $5 $13 $7 60 $50 Plant 3 $14 $9 $12 $16 $5 55 $37 Total required 45 20 25 30 30 Shipments to Customer Total Operating 1 2 3 4 5 Shipped Cost Plant 1 20 0 0 25 0 45 $1,800 From Plant 2 25 0 25 0 0 50 $2,500 Plant 3 0 20 0 5 30 55 $2,035 Total received 45 20 25 30 30 Shipping Cost $1,170 Operating Cost $6,335 Total Cost $7,505 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Background image of page 1

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

View Full DocumentRight Arrow Icon
Unit Unit shipping costs to Customer Total Production 1 2 3 4 5 Available Cost Plant 1 $8 $6 $7 $10 $9 45 $40 From Plant 2 $9 $12 $5 $13 $7 60 $50 Plant 3 $14 $9 $12 $16 $5 55 $37 Total required 45 20 25 30 30 Unit shipping costs to Customers 1 2 3 4 5 Produced Plant 1 15 0 0 30 0 45 <= 45 Plant 2 25 0 25 0 0 50 <= 60 Plant 3 5 20 0 0 30 55 <= 55 Received 45 20 25 30 30 = = = = = Total required 45 20 25 30 30 Production Cost 6335 Shipping Cost 1170 Total Cost 7505
Background image of page 2
dae55e9cfcdac9109d80ae9bfd6abf797c6f1c5b.xls
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Formulas Industrial Gases Transportation Problem Unit Unit shipping costs to Customer Total Production 1 2 3 4 5 Available Cost Plant 1 $8 $6 $7 $10 $9 45 $40 FroPlant 2 $9 $12 $5 $13 $7 60 $50 Plant 3 $14 $9 $12 $16 $5 55 $37 Total req 45 20 25 30 30 Shipments to Customer Total Operating 1 2 3 4 5 Shipped Cost Plant 1 20 25 45 $1,800 FroPlant 2 25 25 50 $2,500 Plant 3 20 5 30 55 $2,035 Total rec 45 20 25 30 30 Shipping Cost $1,170 Operating Cost $6,335 Decision C15:G15 Total Cost $7,505 Variables, Constrained >= 0 = C8:G8 H12:H14 Constrained Objective, Minimize <= H5:H7 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24...
View Full Document

This note was uploaded on 12/17/2010 for the course MSIS 623:386 taught by Professor Markowitz during the Fall '09 term at Rutgers.

Page1 / 3

gases - Formulas Industrial Gases Transportation Problem...

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