New Exercise Bank Content Qu$.09-13$

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.

$\backslash$table$[[,$Refinery$],[$Oil Field,New Orleans,Charleston,Seattle,St$.$ Louis$],[$Texas$,11,7,2,8],[$California$,5,4,8,7],[$Alaska$,7,3,12,6],[$Middle East,$8,9,4,15]]$

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.

Click here for the Excel Data File

Formulate and solve a spreadsheet model for this problem.

Determine the units to ship from each oil field that will maximize the total number of units reaching the distribution centers.

Maximum flow