Please do it with Excels and show the formulas. thanks

ZOOM Transportation problem - 30 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: Vaccine Shipping Cost Phoenix Atlanta $2 Memphis $2.1 Charlotte $1.8 LA $2 Tucson Bullhead $1.8 $2.2 $2 $3 $1.7 $3 $1.8 $2.5 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 - 20 points b. Draw the transportation network diagram for this distribution. Show all the numbers for the nodes, demand, capacity, flow etc 10 points