please answer all question require , and use computer writing not hand writing .

1. XYZ company has 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 concrete, daily plant capacities, and daily project requirements are provided in the table below. To From Project A Project B Project C Plant Capacities Plant 1 $10 $11 70 Plant 2 S12 S8 50 Plant 3 S9 S6 30 Project 40 60 150 Requirements S4 SS $7 50 a. Formulate an initial feasible solution to the transportation problem using the northwest corner rule. b. Use U-V Method to optimize the basic feasible solution to evaluate each unused shipping route by computing all improvement indices. Is this solution optimal? c. The management has decided to increase the capacity at Plant 3 to 60 loads of concrete per day. Find the new optimal solution using the northwest corner rule and U-V method. How has changing the third plant's capacity altered the optimal shipping assignment? d. Write the problem in LP formulation and solve using Excel or Lindo to solve (a) and (c)