Please show all steps in Excel

Question 2. An ABC company is a vertically integrated company (both producing and selling the goods in its own retail outlets). After production, the goods are stores in two warehouses until needed by retail outlets. Trucks are used to transport the goods from two plants to two warehouses, and then from the warehouses to the three retail outlets. Using full truckloads, the following table shows each plant's monthly output, its shipping cost per truckload sent to each warehouse and the maximum amount it can ship per month to each warehouse. From Output Unit Shipping Cost To Warehouse 1 Warehouse 2 $425 $560 I $510 $600 Shipping Capacity Warehouse 1 Warehouse 2 125 150 175 200 Plant 1 Plant 2 200 300 For each retail outlet (RO), the next table shows its monthly demand, its shipping cost from each warehouse, and the maximum amount that can be shipped per month from each warehouse. The management wants to determine a distribution plan that will minimize the total shipping cost. From Shipping Capacity RO2 To RO1 100 Unit Shipping Cost RO2 RO3 $500 $450 $400 $410 200 150 RO3 100 Warehouse 1 Warehouse 2 Demand 150 RO1 $470 $390 150 125 75 150 200 150 150 a) Draw a graph that shows the company's distribution network. Identify the supply nodes, transshipment nodes and demand nodes. Write down the arc costs and capacities. b) Formulate this problem as a linear programming formulation with notation. c) Use a solver to find the optimal solution and report your solution. Question 2. An ABC company is a vertically integrated company (both producing and selling the goods in its own retail outlets). After production, the goods are stores in two warehouses until needed by retail outlets. Trucks are used to transport the goods from two plants to two warehouses, and then from the warehouses to the three retail outlets. Using full truckloads, the following table shows each plant's monthly output, its shipping cost per truckload sent to each warehouse and the maximum amount it can ship per month to each warehouse. From Output Unit Shipping Cost To Warehouse 1 Warehouse 2 $425 $560 I $510 $600 Shipping Capacity Warehouse 1 Warehouse 2 125 150 175 200 Plant 1 Plant 2 200 300 For each retail outlet (RO), the next table shows its monthly demand, its shipping cost from each warehouse, and the maximum amount that can be shipped per month from each warehouse. The management wants to determine a distribution plan that will minimize the total shipping cost. From Shipping Capacity RO2 To RO1 100 Unit Shipping Cost RO2 RO3 $500 $450 $400 $410 200 150 RO3 100 Warehouse 1 Warehouse 2 Demand 150 RO1 $470 $390 150 125 75 150 200 150 150 a) Draw a graph that shows the company's distribution network. Identify the supply nodes, transshipment nodes and demand nodes. Write down the arc costs and capacities. b) Formulate this problem as a linear programming formulation with notation. c) Use a solver to find the optimal solution and report your solution