Officesolution is a furniture company that provides office desks in Ontario. Presently, the company considers renting warehouses among three potential warehouses (A,B, and C) to serve the customers in Toronto, Hamilton, London, and Windsor. The following table summarizes the average unit transportation cost to each city from each warehouse, the number of demands per year for the desks in each city, and the service capacity and rent cost at each warehouse. (a) Assume each city only can be served by one warehouse. Officesolution would like to determine which warehouse will be rented and how to assign each city to the rented warehouses in order to minimize total cost. (b) Solve the problem by Excel solver and write your answer. Solution: Total cost: Optimal assignment for each city