The distribution network for Herman Company consists of three plants, two warehouses and four customers. Plant capacities and shipping costs (per unit) from each plant to each warehouse are as follows: Warehouse Plant Plant 1 2 acity 400 600 1 4 7 2 5 3 5 6 300 Customer demand and shipping costs per unit from each warehouse to each customer are: Customers Warehouse 1 2 Demand 1 2 4 3 4 6 8 4 6 7 7 400 300 300 300 Find the lowest cost solution for the distribution network using the warehouses as the transshipment points Analyze these additional scenarios (treat each scenario as independent of the others, and use 1. 2. separate Excel tabs to show your answers): What is the solution if Plant 2 is shut down for a week due to maintenance? a. What is the solution if there is a new Customer 5 with a demand of 200 units but this b. customer does not use the transshipment points? Instead, since Plant 1 is the closest to this customer, all shipments to this customer occurs from Plant 1 at a shipping cost of $6/unit? For each of the above questions, type in your conclusions about each question in the Excel spreadsheet. The distribution network for Herman Company consists of three plants, two warehouses and four customers. Plant capacities and shipping costs (per unit) from each plant to each warehouse are as follows: Warehouse Plant Plant 1 2 acity 400 600 1 4 7 2 5 3 5 6 300 Customer demand and shipping costs per unit from each warehouse to each customer are: Customers Warehouse 1 2 Demand 1 2 4 3 4 6 8 4 6 7 7 400 300 300 300 Find the lowest cost solution for the distribution network using the warehouses as the transshipment points Analyze these additional scenarios (treat each scenario as independent of the others, and use 1. 2. separate Excel tabs to show your answers): What is the solution if Plant 2 is shut down for a week due to maintenance? a. What is the solution if there is a new Customer 5 with a demand of 200 units but this b. customer does not use the transshipment points? Instead, since Plant 1 is the closest to this customer, all shipments to this customer occurs from Plant 1 at a shipping cost of $6/unit? For each of the above questions, type in your conclusions about each question in the Excel spreadsheet