Problem 2 Use Excel Solver on the transshipment problem depicted on the pdf attached where the objective is to have cost of shipping minimized. Then answer the additional questions. Please write a complete sentence as your answer for each part and make explanations incorporate the actual numerical values in the problem. Note the mapping on the pdf and relabel nodes to facilitate the Excel solution.

1) What amounts are shipped on each route? 2) Give an explanation of the range of optimality of variable that represents the shipping from plant 3 to warehouse 1. 3) What is the reduced cost of the variable that represents the shipment from warehouse 2 to customer 2 and explain what the reduced cost means. 4) Give an explanation of the range of feasibility of plant 2 and what the shadow price there means. 5) Give an explanation of the range of feasibility of customer 3 and what the shadow price there means. Please include your Excel file with a least a answer report and sensitivity report when you conduct your discussion.

The distribution system for the Herman Company consists of three plants, two ware- houses, and four customers. Plant capacities and shipping costs per unit in $) from each plant to each warehouse are as follows: 1 Warehouse 1 2 Plant 1 2 3 4 8 5 7 5 6 Capacity 450 600 380 Customer demand and shipping costs per unit in $) from each warehouse to each customer are as follows: Customer Warehouse 1 2 4 6 3 4 6 3 8 7 4 7 2 Demand 400 300 300 400 Customer Plant I t Warehouse cz 1 Planta c3 Warehouse 2 Plant 3 C4 The distribution system for the Herman Company consists of three plants, two ware- houses, and four customers. Plant capacities and shipping costs per unit in $) from each plant to each warehouse are as follows: 1 Warehouse 1 2 Plant 1 2 3 4 8 5 7 5 6 Capacity 450 600 380 Customer demand and shipping costs per unit in $) from each warehouse to each customer are as follows: Customer Warehouse 1 2 4 6 3 4 6 3 8 7 4 7 2 Demand 400 300 300 400 Customer Plant I t Warehouse cz 1 Planta c3 Warehouse 2 Plant 3 C4