Formulate a Mathematical model and solve the model using Excel Solver. Submit both word document and excel file that show mathematical model and solver. results. Thank you very much for the help.

1. Suppose that northern, central, and southern California each uses 100 billion gallons of water each day. Also, assume that northern California and central California have 120 billion gallons of water available, whereas southern California has 40 billion gallons of water available. The cost of shipping 1 billion gallons of water between the three regions and shortage cost is as follows: Northern Central Southern Northern 5000 7000 8000 Central 7000 5000 6000 Southern 8000 6000 5000 Shortage cost 6000 5500 9000 How should California's water be distributed to minimize the sum of shipping and shortage costs? 2. A corporation plans on building a maximum of 11 new stores in a large city. They will build these stores in one of three sizes for each location - a convenience store (open 24 hours), standard store, and an expandedservices store. The convenience store requires $4.125 million to build and 30 employees to operate. The standard store requires $8.25 million to build and 15 employees to operate. The expanded-services store requires $12.375 million to build and 45 employees to operate. The corporation can dedicate $82.5 million in construction capital, and 300 employees to staff the stores. On the average, the convenience store nets $1.2 million annually, the standard store nets $2 million annually, and the expandedservices store nets $2.6 million annually. How many of each should they build to maximize revenue? Submission Formulate a Mathematical model and solve the model using Excel Solver. Submit both word document and excel file that show mathematical model and solver results