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 renery and from each refineryto each distribution center. Refinery Oil Field New Orleans Charleston Seattle St. Louis Texas 11 I" 2 8 California 5 4 8 7' Alaska I" 3 12 5 Middle East 8 9 4 15 Distribution Center Refineryr Pittsburgh Atlanta Kansas City San Francisco New Orleans 5 9 E ri- Charleston 8 1" 9 5 Seattle 4- E I" S 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 centerthat 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. 6 Answer is complete but not entirely correct