Problem #12: Please resolve this problem using solver in Excel (part c). Step by step screen shoots would be very helpful. Thank you.

b. Determine the optimal assignment of 11. The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit in S) from each plant to each warehouse are as follows: Warehouse 2 1 Plant 1 2 3 Capacity 450 600 380 7 5 6 4 8 5 Customer demand and shipping costs per unit in $) from each warehouse to each customer are as follows: Customer 2 Warehouse 1 3 7 + 1 2 6 3 4 6 8 7 7 Demand 300 300 300 400 a. Develop a network representation of this problem. b. Formulate a linear programming model of the problem. c. Solve the linear program to determine the optimal shipping plan. 12. Refer to Problem 11. Suppose that shipments between the two warehouses are permitted at $2 per unit and that direct shipments can be made from Plant 3 to Customer 4 at a cost of $7 per unit a. Develop a network representation of this problem. b. Formulate a linear programming model of this problem. Solve the linear program to determine the optimal shipping plan. C