Texago 1a

Texago Corp. Site-Selection Problem (Shipping to Refineries, Includ Refineries Unit Cost ($millions) New Orleans Charleston Seattle Los Angeles Texas 2 4 5 3 Oil California 5 5 3 1 Fields Alaska 5 7 3 4 Middle East 2 3 5 4 Shipment Quantity Refineries (millions of barrels) New Orleans Charleston Seattle Los Angeles Texas 40 0 0 40 Oil California 0 0 0 60 Fields Alaska 0 0 80 20 Middle East 60 60 0 0 Total Received 100 60 80 120 = = = = Demand 100 60 80 120 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

ding Los Angeles) Range Name Cells Demand D19:G19 ShipmentQuantity D13:G16 Supply J13:J16 TotalCost J20 TotalReceived D17:G17 TotalShipped H13:H16 UnitCost D5:G8 Total Shipped Supply 80 = 80 60 = 60 100 = 100 120 = 120 Total Cost ($millions) 880 H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20