Question: 3 . Use the Solver results from the two LP models from Part 2 to answer the following questions.a ) Summarize the Optimal Solutions and

3.Use the Solver results 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 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, will the overall optimal shipping quantities from Suppliers to Customers remain the same? What will be Total Transportation Cost now? Explain.ii. If the shipping cost from Supplier 2 to Demand B is Reduced by $4 will this affect optimal shipping quantities from Suppliers to Customers? Explain.iii. If the new Toledo capacity is Increased to 220 units, how much Total Transportation costs can be reduced? Explain.iv. If the new Toledo capacity is Reduced to 150 units, can you determine the optimal total shipping cost from the sensitivity reports? Explain.
 3.Use the Solver results from the two LP models from Part

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!