SOLVE USING EXCEL ONLY.

2. Consider the hypothetical transportation problem shown in Table 1 below. Table 1: Hypothetical Transportation Problem TO FROM I III SUPPLY 100 A 150 120 1000 120 B 80 75 700 90 70 100 800 DEMAND 700 900 900 a) Formulate the transportation problem as a linear programming model. Clearly present details of the formulation, state and justify your assumptions. b) Use Microsoft Excel to solve the problem. c) Present your findings, including a critical discussion of the results