You must submit screenshot of excel solver and formulas screenshot for the answer to this problem.

Crimson Horizon Petroleum is an oil company that operates the pipeline network shown below, where each pipeline is labeled with its maximum flow rate in million cubic feet (MMcf) per day. A new oil well has been constructed near A. They would like to transport oil from the well near A to their refinery at G. a) Formulate this model algebraically. (1 points) b) Formulate and solve a network optimization model to determine the maximum flow rate from A to G.(4 points)