$(14$ points total$)3.$ A manufacturer produces goods at five US cities, from which the goods are sent to seven: major customers in the following cities: Flint, Houston, Jackson, Kent, Lakeland, Miami, and Oakdale. The monthly production of the goods is shown in the table below: The monthly demands for each customer $($in tons$)$ are shown below, The shipping costs per ton of product from the manufacturers to the customers are shown in the table below. a$)$ Solve a Transportation Problem in Excel to find the lowest cost delivery plan to meet the customers' requirements. $($i$)$ Report the minimum cost from your solution. $($ii$)$ Insert $($paste$)$ below the Excel spreadsheet that you used showing the optimal solution. $($include all rows and columns of the spreadsheet$)($i$)$ Minimum cost $\backslash (=\backslash )($ii$)--$ Paste Your Excel Spreadsheet Here $-.$ b$)$ How much does Boston send to each destination? c$)$ From which manufacturing cities does Lakeland receive shipments $-$ and how many tons are sent fro$(14$ points total$)$

A manufacturer produces goods at five US cities, from which the goods are sent to seven

major customers in the following cities: Fillmore, Grant, Hayes, Jefferson, Kennedy, Lincoln

and Madison. The monthly production capacity of the goods is shown in the table below:

The monthly demands for each customer $($in tons$)$ are shown below.

The shipping costs per ton of product from the manufacturers to the customers are shown in

the table below.

Shipping costs per ton $($$$)$:

a$)$ Solve a Transportation Problem in Excel to find the lowest cost delivery plan to meet

the customers' requirements.

$($i$)$ Report the minimum cost from your solution.

$($ii$)$ Insert $($paste$)$ below the Excel spreadsheet that you used showing the optimal

solution. $($include all rows and columns of the spreadsheet$)$

$($i$)$ Minimum cost $=$

$($ii$)--$ Paste Your Excel Spreadsheet Here $--$

b$)$ How much does Boston send to each destination?

c$)$ From which manufacturing cities does Lincoln receive shipments $-$ and how many tons

are sent from each?m each?