$**$THIS IS A CONTINUATION OF THE PREVIOS QUESTION PLEASE SHOW HOW ITS SUPPOSED TO LOOK LIKE ON EXCEL$***$ Part $2.$ Use Excel Solver to solve the LP models formulated.

Important: you should complete Part $1$ before you start Part $2$

a$)$ The Excel file should contain $4$ sheets

Sheets $1$&$2$ are sheets containing the Excel Solver setups and Solutions of the two LP models.

Name the Sheet$1$ as LP Toledo, Sheet $2$ as LP Cincinnati, correspondingly

Please give Enough Explanations on cell definitions in the Excel Spreadsheet Setup so that you can obtain easy$-$to$-$read Solver Output Reports

Sheets $3$&$4$ contains the Answer report and Sensitivity reports generated by the Solver Outputs from solving the LP model of the Toledo Case.

Part $3.$ Use the Solver output reports from the two LP models from Part $2$ to answer the following questions.

a$)$ Summarize the Optimal Solutions and the Optimal Objective Values of Linear Programming models $($Toledo and Cincinnati$).$ Then draw a conclusion on which site, "Toledo" or "Cincinnati", should be chosen as a New Plant location.

b$)$ Use the information from the Sensitivity Report from the Toledo case to answer the following four questions.

Important: questions should be answered using the information from the Sensitivity Report ONLY $($it is not acceptable to answer the questions by changing the Parameters and resolving the LP model.

Please Give clear explanations and point out locations $($Exact cell position$)$ in the Sensitivity Report where you come up with the answers.

i$.$ If the shipping cost from Supplier $2$ to Demand $A$ is increased to $$14,$ can you conclude the optimal solution$/($shipping quantities from Suppliers to Customers$)$ remains the same, and provide the updated optimal Transportation Cost based on the sensitivity report from the solver? Please provide the updated optimal Transportation cost if you can. Explain.

ii$.$ If the shipping cost from Supplier $2$ to Demand A is Reduced by $$2,$ can you conclude the optimal solution$/($shipping quantities from Suppliers to Customers$)$ remains the same, and provide the updated optimal Transportation Cost based on the sensitivity report from the solver? Please provide the updated optimal Transportation cost if you can. Explain.

iii. If the new Toledo capacity is Increased by $30$ units, can you determine the updated Optimal Transportation cost based on the sensitivity report from the solver? Please provide the updated cost if you do$.$ Explain.

iv$.$ If the new Toledo capacity is Reduced by $30$ units, can you determine the updated Optimal Transportation cost based on the sensitivity report from the solver? Please provide the updated cost if you do$.$ Explain.

Important Order to complete this project:

Important: A Linear Programming Model formulation is a Mathematical Model that contains three parts.

Important: You should complete Part $1$ before you start Part $2.$

Important: You should complete Part $2$ before you start Part $3.$ Only the Solver Solution & Sensitivity Report can be used to answer questions of Part $3.$