Please provide step by step with excel solver

eBookshelt: Optix Optimation Modeling with X Poy Products seis package X C Poly Products Sels Package X + 4/34/4/2/6/16/2/4/2/2/260:70.0 the solution and verify that the flows are consistent with the given information 3.4 Distributing a Product: The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each plant is 35,50, 37.50, 37.25, and $36.25, and the annual capacities are 18,000,15,000,25,000, and 20,000, respectively. The locks are sold through wholesale distributors in seven locations around the country. The unit shipping cost for each plant-distributor combination is shown in the following table, along with the forecasted demand from each distributor for the coming year, Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65 Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85 Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00 Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65 Demand 5500 11,500 10.500 9,600 15.400 12,500 6600 + (a) Determine the least costly way of shipping locks from plants to distributors. (b) Show the network dingram corresponding to the solution in (a). That is, label each of the arcs in the solution and verify that the flows are consistent with the given information. (c) Suppose that the unit cost at each plant were $10 higher than the original figure. What change in the optimal distribution plan would result? What if the plant costs were $20 higher? 3.5 Repositioning Supply: The American Rent-a-Car Company has eight outlets in a metropolitan area. American operates under a policy that calls for a specifie "target" percentage of all available cars to be located at each outlet at the start of each day. These percentages are summarized in the following table. Outlet 1 2 3 4 5 6 7 8 Percentage 20 10 20 5 10 20 5 10 0 Aa Jo E BD * 3 de eBookshelt: Optix Optimation Modeling with X Poy Products seis package X C Poly Products Sels Package X + 4/34/4/2/6/16/2/4/2/2/260:70.0 the solution and verify that the flows are consistent with the given information 3.4 Distributing a Product: The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each plant is 35,50, 37.50, 37.25, and $36.25, and the annual capacities are 18,000,15,000,25,000, and 20,000, respectively. The locks are sold through wholesale distributors in seven locations around the country. The unit shipping cost for each plant-distributor combination is shown in the following table, along with the forecasted demand from each distributor for the coming year, Tacoma San Diego Dallas Denver St. Louis Tampa Baltimore Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65 Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85 Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00 Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65 Demand 5500 11,500 10.500 9,600 15.400 12,500 6600 + (a) Determine the least costly way of shipping locks from plants to distributors. (b) Show the network dingram corresponding to the solution in (a). That is, label each of the arcs in the solution and verify that the flows are consistent with the given information. (c) Suppose that the unit cost at each plant were $10 higher than the original figure. What change in the optimal distribution plan would result? What if the plant costs were $20 higher? 3.5 Repositioning Supply: The American Rent-a-Car Company has eight outlets in a metropolitan area. American operates under a policy that calls for a specifie "target" percentage of all available cars to be located at each outlet at the start of each day. These percentages are summarized in the following table. Outlet 1 2 3 4 5 6 7 8 Percentage 20 10 20 5 10 20 5 10 0 Aa Jo E BD * 3 de