I need problem #18. Please do it in Excel and show formulas

7. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in dollars) from each plant to each warehouse are as follows: Customer demand and shipping costs per unit (in dollars) from each warehouse to each customer are a. Develop a network ref esentation of this problem. b. Formulate a linear programming nodel of the problem. c. Solve the linear program to deternaine the optimal shipping plan. 18. Refer to Problem 17. Suppese that shipments between the two warehouses are permitted at $2 per unit and that direct shipmeats can be made from plant 3 to customer 4 at a cost of $7 per unit. a. Develop a network representatuon of this problem. b. Formulate a linear prostamming model of this problem. c. Solve the linear program to dekernaine the optimal stipping olan 7. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in dollars) from each plant to each warehouse are as follows: Customer demand and shipping costs per unit (in dollars) from each warehouse to each customer are a. Develop a network ref esentation of this problem. b. Formulate a linear programming nodel of the problem. c. Solve the linear program to deternaine the optimal shipping plan. 18. Refer to Problem 17. Suppese that shipments between the two warehouses are permitted at $2 per unit and that direct shipmeats can be made from plant 3 to customer 4 at a cost of $7 per unit. a. Develop a network representatuon of this problem. b. Formulate a linear prostamming model of this problem. c. Solve the linear program to dekernaine the optimal stipping olan