In-Class Assignment - Transportation Algorithm The table below provides information (names, supply, demand, and cost/unit) for a transportation problem involving three warehouses and three customers. Use that data to answer the questions that follow the table. Warehouse 1 Warehouse 2 Warehouse 3 Demand Customer 1 10 12 15 1000 Customer 2 8 15 9 700 Customer 3 13 9 11 950 Supply 800 1100 900 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 WiC1 route at $10/unit rather than the W1C2 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 ed States