I need a Report. The report should have the appearance of being professionally done.

Below data is required:

Executive summary

Recommendations

Approach and methods

Findings & Analysis $($including LP formulation$($s$)$ and solution output$)$

Is$($are$)$ the model formulation$($s$)$ meaningful and correct $($according to the supporting information$)$

Has the project team correctly interpreted the solution and made appropriate recommendations?

Would I forward this report to the client?

Heres the problem:

Ernies Market is a small independent chain of neighborhood grocery stores. Ernies distributes high volume product to its stores from a company owned and operated warehouse. Additionally, the company is looking to start a back$-$hauling program with its suppliers in an effort to reduce its transportation costs.

Kimberly$-$Clark operates a factory in the vicinity of Ernies stores and warehouse and will be the first participant in a pilot back$-$hauling program. Figure $1$ is a road map showing the locations of Kimberly$-$Clark and Ernies warehouse and stores and the distances along each of the road segments.

Here are your tasks:

Develop detailed cost minimizing outbound and backhaul routes for sending:

A full truck from the warehouse to each store, then from each store to Kimberly Clark

A full truck from Kimberly Clark to each store, then from each store to the warehouse

Calculate the costs of:

All outbound routes $($i$.$e$.$ the combined outbound cost$)$

All return routes $($i$.$e$.$ the combined backhaul cost$)$

Present your recommendations to your client in an easily understandable, and actionable, format; for example, the client should be able to clearly see and easily implement, the route from the warehouse to store E and then from store E to Kimberly Clark.

Be careful that you do not strand trucks at stores

Ernies has stated the following assumptions to help guide your efforts:

Outbound transportation costs are directly proportional to travel distance

Backhaul transportation costs are a linear function of the distance.

Table $1$ shows the reverse route cost ratios which can be used as multipliers to calculate the relative transportation costs associated with traversing road segments in the reverse direction. Find the cost minimizing return routes from the Kimberly$-$Clark factory to each of Ernie's stores and Ernie's warehouse Warehouse Figure $1-$ Road System showing Ernie's Warehouse, Stores, and Kimberly$-$Clark Factory Ending Cost per Mile Ratio Warehouse Warehouse $2\mathrm{.}001\mathrm{.}502\mathrm{.}002\mathrm{.}001\mathrm{.}751\mathrm{.}751\mathrm{.}751\mathrm{.}251\mathrm{.}251\mathrm{.}501\mathrm{.}25$ Kimberly$-$Clark $2\mathrm{.}001\mathrm{.}75$ Kimberly Clark Kimberly$-$Clark $1\mathrm{.}25$ Table $1-$ Reverse Route

Warehouse$34$Fiaure $1$ Poad SvetonB$7$Dio'e AlRrab$38$E$62$Kimberly$-$Clark

Executive summary

Recommendations $($including immediate, intermediate, and long term as appropriate$)$

Methodology and approach

Analysis and findings.

Submissions will be graded according to the criteria outlined in the grading template $($see assignment folder$).$ Be sure that your recommended routes are easily identifiable $($the client should not have to work hard to understand how to implement your recommendations$).$ Moreover, take care to explain the business relevance of your recommendations.

$\backslash$table$[[$Location$,$Cost per$],[$Starting$,$Ending,Mile Ratio$],[$Warehouse$,$A$,2\mathrm{.}00],[$Warehouse$,$B$,2\mathrm{.}00],[$A$,$C$,2\mathrm{.}00],[$A$,$B$,1\mathrm{.}50],[$B$,$D$,1\mathrm{.}50],[$B$,$D$,1\mathrm{.}25],[$B$,$C$,2\mathrm{.}00],[$C$,$E$,2\mathrm{.}00],[$D$,$E$,1\mathrm{.}75],[$D$,$E$,1\mathrm{.}75],[$E$,$F$,1\mathrm{.}75],[$E$,$F$,1\mathrm{.}25],[$E$,$G$,1\mathrm{.}25],[$F$,$H$,1\mathrm{.}50],[$F$,$G$,1\mathrm{.}25],[$G$,$Kimberly$-$Clark,$2\mathrm{.}00],[$G$,$Kimberly$-$Clark,$1\mathrm{.}75],[$H$,$Kimberly$-$Clark,$1\mathrm{.}25]]$

Table $1-$ Reverse Route Cost Multipliers