Homework Help is Here – Start Your Trial Now!
Math
Probability
Техas 11 8. California 4 7 Alaska 7 12 Middle East 8 9 4 15 Distribution Center Refinery Pittsburgh Atlanta Kansas City San Francisco New Orleans 6. Charleston 8. 7 9. Seattle 4 6 8. St. Louis 12 11 9. The Texago management now wants to determine a plan for how many units to ship from each oil field to each refinery and from each refinery to each distribution center that will centers. c. Use the distribution network from part b to formulate a network model for Texago's problem as a variant of a maximum flow problem.

Техas 11 8. California 4 7 Alaska 7 12 Middle East 8 9 4 15 Distribution Center Refinery Pittsburgh Atlanta Kansas City San Francisco New Orleans 6. Charleston 8. 7 9. Seattle 4 6 8. St. Louis 12 11 9. The Texago management now wants to determine a plan for how many units to ship from each oil field to each refinery and from each refinery to each distribution center that will centers. c. Use the distribution network from part b to formulate a network model for Texago's problem as a variant of a maximum flow problem.

Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter2: Systems Of Linear Equations
Section2.4: Applications
Problem 28EQ
See similar textbooks
icon
Related questions
Question

Please see screenshot. I am interested mostly in the setup/configuration of the solver. 

6.12. The Texago Corporation has four oil fields, four refineries, and four distribution centers in the locations identified in the next tables. A major strike involving the transportation industries now has sharply curtailed Texago's Page 234 capacity to ship oil from the four oil fields to the four refineries and to ship petroleum products from the refineries to the distribution centers. Using units of thousands of barrels of crude oil (and its equivalent in refined products), the following tables show the maximum number of units that can be shipped per day from each oil field to each refinery and from each refinery to each distribution center. Refinery Oil Field New Orleans Charleston Seattle St. Louis Texas 11 California 4 8 7 Alaska 12 6 Middle East 8 9 4 15 Distribution Center Refinery Pittsburgh Atlanta Kansas City San Francisco New Orleans 6. 4 Charleston 7 5 Seattle 4 7 8 St. Louis 12 11 7 The Texago management now wants to determine a plan for how many units to ship from each oil field to each refinery and from each refinery to each distribution center that will maximize the total number of units reaching the distribution centers. c. Use the distribution network from part b to formulate a network model for Texago's problem as a variant of a maximum flow problem. d. Formulate and solve a spreadsheet model for this problem.
Transcribed Image Text:6.12. The Texago Corporation has four oil fields, four refineries, and four distribution centers in the locations identified in the next tables. A major strike involving the transportation industries now has sharply curtailed Texago's Page 234 capacity to ship oil from the four oil fields to the four refineries and to ship petroleum products from the refineries to the distribution centers. Using units of thousands of barrels of crude oil (and its equivalent in refined products), the following tables show the maximum number of units that can be shipped per day from each oil field to each refinery and from each refinery to each distribution center. Refinery Oil Field New Orleans Charleston Seattle St. Louis Texas 11 California 4 8 7 Alaska 12 6 Middle East 8 9 4 15 Distribution Center Refinery Pittsburgh Atlanta Kansas City San Francisco New Orleans 6. 4 Charleston 7 5 Seattle 4 7 8 St. Louis 12 11 7 The Texago management now wants to determine a plan for how many units to ship from each oil field to each refinery and from each refinery to each distribution center that will maximize the total number of units reaching the distribution centers. c. Use the distribution network from part b to formulate a network model for Texago's problem as a variant of a maximum flow problem. d. Formulate and solve a spreadsheet model for this problem.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer