1. Consider a problem of transporting perishable products (e.g., vegetables, eggs, milk) where the quality of products may deteriorate according to the transportation condition and time. Company IELM logistics is one of the world-leading companies for the transportation of perishable products. One of their clients, IMSE, is running a business producing a dairy product. Due to the high perishability of the product, IELM has conducted research on understanding how the different routes impact the percentage of the product suitable for consumption upon arrival at the retail stores. The numbers in Table 1 (i) represent the percentage of the product suitable for consumption upon arrival at the grocery store, while the last row and column in the table show the demand of the grocery store and the supply of the factory. Table 1 (i) % suitable for consumption A 1 86% 4 91% Grocery store 2 3 90% 90% 86% 86% 96% 350 270 Supply 500 350 390 B 96% 85% 280 91% 190 Demand From the above table, Routes B-4 and C-2 are not feasible due to the lack of transportation infrastructure. a. [10 marks] Suppose that the transportation costs are not considered here. What is the transportation plan to maximize the expected total quantity of the product suitable for consumption upon arrival at the grocery stores? Please work it out manually. b. [10 marks] Please use Excel Solver Add-in to find out the optimal solution in part (a). c. [10 marks] Suppose that, now, the unit transportation costs are given, as shown in Table 1 (ii). Each unit of product suitable for consumption can generate a revenue of $20 and can be sold definitely due to the high demand. What is the transportation plan to maximize the expected total profit? Please work it out manually