The Oman Cement Company have plants in three locations, and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of cement (in OMR), daily plant capacities, and daily project requirements are provided in the table 1 below. Table 1 D2 7 D3 3 Capacities 300 D1 A 5 B 8 9 Requirements 400 4 3 450 7 5 250 1000 400 200 i. Using standard computer software (Windows QM/ Excel) to find an initial feasible solution to Oman Cement's transportation problem using the northwest corner rule, and determine its cost. ii. Evaluate each unused shipping route by computing all improvement indices, Is this solution optimal? Why? iii. Find an optimum solution, and determine the optimum cost. Also show the shipping list. The Oman Cement Company have plants in three locations, and is currently working on three major construction projects, each located at a different site. The shipping cost per truckload of cement (in OMR), daily plant capacities, and daily project requirements are provided in the table 1 below. Table 1 D2 7 D3 3 Capacities 300 D1 A 5 B 8 9 Requirements 400 4 3 450 7 5 250 1000 400 200 i. Using standard computer software (Windows QM/ Excel) to find an initial feasible solution to Oman Cement's transportation problem using the northwest corner rule, and determine its cost. ii. Evaluate each unused shipping route by computing all improvement indices, Is this solution optimal? Why? iii. Find an optimum solution, and determine the optimum cost. Also show the shipping list