Use the sensitivity report from Excel solver. Please show steps.

2. Davison Electronics manufactures two LCD television monitors, identified as model A and model B. Each model has its lowest possible production cost when produced on Davison's new production line. However, the new production line does not have the capacity to handle the total production of both models. As a result, at least some of the production must be routed to a higher-cost, old production line. The following table shows the minimum production requirements for next month, the production line capacities in units per month, and the production cost per unit for each production line. model Production cost per unit New line Old line $30 $50 Minimum production requirements 50,000 1 $25 70,000 B Production line capacity $40 60,000 80,000 Davison's objective is to determine the minimum cost production plan. a. Formulate the linear programming model for this problem. b. What is the optimal solution and what is the minimum total production cost? c. The manager said that one-unit increase in the capacity of the new production line would increase the total production cost by $15. Do you agree? d. Would you recommend increasing the capacity of the old production line? e. The production cost for model A on the old production line is $50 per unit. How much would this cost have to change to make it worthwhile to produce model A on the old production line? f. Suppose that the minimum production requirement for model B is reduced from 70,000 units to 60,000 units. What effect would this change have on the total production cost