Use Microsoft Excel SOLVER for the solution.

Text Book: Optimization Modeling with Spreadsheets By Kenneth R. Baker ISBN: 9781118937730

Please solve a), b) and c).

.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. (a) Determine the least costly way of shipping locks from plants to distributors. (b) Show the network diagram 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? .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. (a) Determine the least costly way of shipping locks from plants to distributors. (b) Show the network diagram 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