need step by step excel solutions need to show and understand

The High-Price Oil Company owns a pipeline network that is used to convey oil from its source to several storage locations. A portion of the network is as follows: 3 Flow capacity: 2 5000 gallons per hour 2 5 3 2 2 2 5 2 Source 1 3 2 5 6 7 4 Due to the varying pipe sizes, the flow capacities vary. By selectively opening and closing sections of the pipeline network, the firm can supply any of the storage locations. 1. If the firm wants to fully utilize the system capacity to supply storage location 7, how long will it take to satisfy a location 7 demand of 100,000 gallons? What is the maximal flow for this pipeline system? Develop a relevant linear programming model and solve it using Excel. 2. If a break occurs on line 23 and that line is closed down, what is the maximal flow for the system? How long will it take to transmit 100,000 gallons to location 7? Develop a relevant linear programming model and solve it. Attach all relevant exhibits from your Excel's Solver calculations. Use PrintScreen, edit/copy/paste, etc