To be solved in excel using solver, need excel solver answer reports and sensitivity reports and step by step explanation for answers

1) A shoe manufacturer has four production plants (Pontiac, Daytona, Atlanta and Washington DC) and four distribution centers (Cleveland, New York, San Francisco and Houston). Each distribution center has submitted their projected demand for the upcoming season. Demand for the upcoming season is very strong. However, disruptions in the supply chain meant that production capacity is limited and demand might not be able to be met for all distribution centers. The table provided shows the demand at each center, the production capacity at each plant, and the transportation cost per unit from each plant to each distribution center. Management wants to determine the transportation plan that minimizes transportation cost and best utilizes production capacity. A. Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. a. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. b. Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal transportation plan for the shoe manufacturer? What is the minimum total shipping cost? Communicate the recommendation in plain English. It is acceptable to use tables for clarity