2. A distribution company has 3 warehouses and serves four retail customers. The shipping cost from each warehouse to each customer is the following: Customer 1 2 3 4 1 7 6 5 4 Warehouse 2| 9 7 3 6 3 8 8 7 3 Each warehouse has a capacity of 50 units per day. The daily demand from customer 1,2,3 and 4 is 20, 40, 30 and 60 respectively. The company wishes to minimize its shipping costs. a) Formulate the problem as an LP. b) Solve the problem using Excel. c) Because of a detour near customer 1, the shipping cost from each warehouse increases by $1. Explain how this will affect your optimal solution