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) 30 points b. Draw the transportation network diagram for this distribution. Show all the numbers for the nodes, demand, capacity, flow etc 10 points Notes on points distribution: Part a: ( 30 points) Model Setup: 10 points Naming cells: 5 points Color coding cells: 5 points Cell formatting ( $ format etc): 5 points Correct answer: 5 points Part b: 10 points - Missing diagram 10 points, demand, capacity, flow missing 2 points each