Could I possibly get help with this project? I am very confused on how to do it Trask Outlines: The detailed Project is given on the Next Page of this guideline $($you may read the project first before you

continue on the guideline$).$

You need to complete the following three parts in this.

Part $1.$ Describe the problem and formulate the problem into two Linear Programming models.

Part $2.$ Use the Excel Solver to solve the two formulated LP models from Part $1.$

Part $3.$ Summarize solver solution results using the solver solution reports and

Answer questions asked at the end of the project using the Solver sensitivity report from the Toledo case.

Location Section Project

A small company named LogTransit currently has three manufacturing facilities $($suppliers$)$ called Suppliers $\backslash$#$1,\backslash$#$2,$ and $\backslash$#$3$ to supply goods to its three retail stores $($customers$)$ named Customer A$,$ B$,$ and C$.$ Due to customer demands at stores increasing, the company is considering building a new manufacturing facility $($Supplier$)$ that will have a capacity of $1500$ units per week. After screening many potential sites, Toledo and Cincinnati have been determined to be the two leading candidate locations for the new facility. Assume that Overall Transportation Costs from Suppliers to Customers will be the main determinant to determine which of the two locations to be selected as the new plant site. The following two tables provide information on i$)$ the capacities of old suppliers and new supplier candidates, ii$)$ The per unit Transportation cost from existing Suppliers to customers and per unit Transportation cost from the new candidate supplier location to customers, and $3)$ demands from customers and available capacity of each supplier.

One of the most important tasks of this project is to determine which New Supplier locations will result in the smallest total transportation costs.

following is what you need to do to complete this project

Part $1$: LP formulation a$.$ Give a summary of the project Problem:

$-$ Describe in WORDS what Decisions you need to make, the criterion on which your decision is based,

and how Linear Programming models can be used to help you make your decision.

b$.$ Formulate the project problem into TWO LP models.

$-$ To make the right decision for the project, you need to formulate TWO Linear Programming models.

$-$ You may only provide a complete and detailed LP formulation for only one of the models. For example, assuming "TOLEDO" is chosen as the new plant. Then, give brief explanations of the difference in LP model formulation when "CINCINNATI" is chosen as the new plant.

Important: A Linear Programming Model formulation should be a Mathematical Model that contains

$-$ Clearly defined decision variables

$-$ A linear function of the Objective

$-$ All constraints in the form of Linear inequalities$/$equalities for which your decision variables need to

satisfy, including non$-$negativity constraints.

Part $2.$ Use Excel Solver to solve the LP models formulated.

Important: you should complete Part $1$ before you start Part $2.$ Your Excel solver setup should be consistent

with the LP Models you formulated in Part $1.$

a$)$ The Excel file should contain four sheets.

$-$ Sheets $\backslash (1\backslash$& $2\backslash )$ 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.

$-$ Sheet $\backslash (3\backslash$& $4\backslash )$ contains the Answer report and Sensitivity reports generated by the Solver Outputs from

solving the LP model of the Toledo Case.

$-$ You are not required to save the Answer report and Sensitivity reports from the Cincinnati case.

$-$ Part $3.$ Use the Solver results 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. Summarize your optimal shipping schedule.

b$)$ Use 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.

You are required to give clear explanations by referring to where $($Exact cell position$)$ in the Sensitivity Report for your conclusions.

i$.$ If the shipping cost from Supplier $2$ to Demand B is increased by $\backslash (\backslash$$ $2\backslash ),$ will the overall optimal

shipping quantities from Suppliers to Customers remain the same? What will be the Total Transportation Cost now? Explain.

ii$.$ If the shipping cost from Supplier $2$ to Demand $\backslash ($ B $\backslash )$ is decreased to $\backslash (\backslash$$ $13\backslash ),$ will this affect optimal

shipping quantities from Suppliers to Customers? Explain.

iii. If the production capacity of the new Toledo plant is reduced to $1000$ units, will the Total Transportation Costs be reduced or increased? By how much? Explain.

iv$.$ If the new Toledo capacity is increase