A company transports products from their three processing plants directly to three warehouses. The products are processed in plants located in City 01, City 02 and City 03 . The warehouses are located in Kilkenny, Limerick, and Mayo. In line with the research supporting a shorter working week and higher productivity, the plants and warehouses operate on a FOUR-day week basis. Supply and demand are as follows: City 01 can supply 120 units/week; City 02 can supply 80 units/week; and City 03 can supply 20 units/week. Demand is 60 units/week at warehouse 01, 120 units/week at warehouse 02 and 40 units/week at warehouse 03 . Daily Per unit shipping costs (in Euro) from the processing plants to each of the warehouses are displayed in the table below. (i) Formulate this problem as a transportation problem to minimize the daily total shipping cost. [4 Marks] (ii) Solve this problem using Excel to find the optimal solution. [5 Marks]