Question: Consider the hypothetical transportation problem shown in Table 1 below. Table 1: Hypothetical Transportation Problem from to to to supply A 100 150 120 1000
Consider the hypothetical transportation problem shown in Table 1 below. Table 1: Hypothetical Transportation Problem
| from | to | to | to | supply |
| A | 100 | 150 | 120 | 1000 |
| B | 120 | 80 | 75 | 700 |
| C | 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
