PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD ALSO GREATLY APPRECIATE IT IF YOU COULD SHOW WHAT FORMULAS TO USE.

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 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. d. Formulate and solve a spreadsheet model for this