Description of this paper

Loading

PLEASE NOTICE THE EXCEL SPREADSHEET THAT IS ATTACHED. PLEASE USE-(Answered)

Description

Step-by-step Instant Solution


Question

PLEASE NOTICE THE EXCEL SPREADSHEET THAT IS ATTACHED. PLEASE USE THAT, THANK YOU.

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 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.

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.

? a.??Draw a rough map that shows the location of Texago?s oil fields, refineries, and distribution centers. Add arrows to show the flow of crude oil and then petroleum products through this distribution network.
? b.??Redraw this distribution network by lining up all the nodes representing oil fields in one column, all the nodes representing refineries in a second column, and all the nodes representing distribution centers in a third column. Then add arcs to show the possible flow.
? 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.
E*

d.??Formulate and solve a spreadsheet model for this problem.

 

Paper#9256084 | Written in 27-Jul-2016

Price : $16
SiteLock