Please provide detailed steps in how to complete using Solver in Excel. Thank you.

Problem 2: Using Solver to solve transportation or distribution problems Suppose that each day, Northern, Central, and Southern California each use 100 billion gallons of water. Also assume that Northern California and Central California have available 120 billion gallons of water, whereas Southern California has 40 billion gallons of water available. The cost of shipping 1 billion gallons of water between the three regions is as follows: MIS 4390 Business Analytics FALL 2021 Page 2 of 3 Northern Central Southern Northern $5,000 $7,000 $10,0000 Central $7,000 $5,000 $6,000 Southern $10,000 $6,000 $5,000 You will not be able to meet all the demand for water, so assume that each billion gallons of unmet demand incurs the following shortage costs: Northern Shortage cost/billion gal- $6,000 lons short Central $5,500 Southern $9,000 How should California's water be distributed to minimize the sum of shipping and shortage costs