Тех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.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
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

Blurred answer
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON