Texago 1c

.xlsx
School
University of Texas **We aren't endorsed by this school
Course
BUSINESS 7E
Subject
Statistics
Date
Sep 29, 2023
Pages
2
Uploaded by trantony2293 on coursehero.com
Texago Corp. Site-Selection Problem (Shipping to Refineries, Inclu Refineries Unit Cost ($millions) New Orleans Charleston Seattle St. Louis Texas 2 4 5 1 Oil California 5 5 3 4 Fields Alaska 5 7 3 7 Middle East 2 3 5 4 Shipment Quantity Refineries (millions of barrels) New Orleans Charleston Seattle St. Louis Texas 0 0 0 80 Oil California 0 20 0 40 Fields Alaska 20 0 80 0 Middle East 80 40 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
uding St. Louis) 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) 960 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
Page1of 2
Uploaded by trantony2293 on coursehero.com