Question: Here's the question Here's the excel Please only answer if you'll give an answer and not just write paragraphs about solving it. Save your time

Here's the question

Here's the excel
Please only answer if you'll give an answer and not just write paragraphs about solving it. Save your time because I'll thumbs down. thanks
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. 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
