Could you include work/spreadeheets used , Thank you!

In-Class Assignment - Solver The table below provides information on the shipping of snow machines from warehouses in three cities to three National Parks in Alaska. Use that data (some of it have been changed from the previous assignment) to answer the questions that follow the table. Fairbanks Anchorage Juneau Demand Denali 8 9 10 1200 Glacier Bay 15 14 5 800 Yukon 9 12 8 1000 Supply 1200 1300 750 1) Use Solver to get the optimal solution for this problem. Write a paragraph telling your boss the optimal shipping plan. 2) Use the spreadsheet to show that the algorithm was correct to ship on the Fairbanks-Yukon route at $9/unit rather than the Juneau-Yukon route at $8/unit. 3) Suppose you are told that shipping fewer than 100 units on a route is not cost effective. Make a change to the data to block the route with too few units and then interpret the results you get from Solver