Transportation problem $-40$ points total

You have recently joined a SWAT effort to help with minimizing the cost of distributing the Covid variant vaccines between the supply locations $($Atlanta$,$ Memphis, Charlotte, LA$)$ and destination sites $($Phoenix$,$ Tucson, Bullhead$).$ Cost of shipping is referred in the table below:

On a daily basis, there is a minimum need for $200,000$ vaccines in Phoenix, $100,000$ at Tucson and $25,000$ at Bullhead city.

The supply available at each of the origin cities is $100,000$ vaccinations per site

a$.$ Create and Solve the transportation model for this distribution to minimize the daily cost. Make sure to name and color code all the cells or cell ranges properly. Format the currency cells properly. Solver dialog box should show up with proper naming $($not cell names$)-\backslash (\backslash$mathbf$\{30\}\backslash )$ points

b$.$ Draw the transportation network diagram for this distribution. Show all the numbers for the nodes, demand, capacity, flow etc $-\backslash (\backslash$mathbf$\{10\}\backslash )$ points