Transportation and Assignment Models
Transportation and Assignment Models
AND
ASSIGNMENT
MODELS
Overview
The transportation model and assignment model are considered special-purpose
algorithm linear programming models because of their structures.
Two (2) methods are used in finding the initial solution to a transportation
problem.
1. Northwest Corner Method (NWCM) - Is a procedure for obtaining an initial
feasible solution to a transportation problem that starts with allocating units
to the upper left-hand corner of any transportation problem.
2. Vogel's Approximation Method (VAM) - Is used to find the feasible solution
for transportation of goods where the solution is either optimal or near to the
optimal solution.
These are the steps in solving transportation problems:
1. Set up the initial transportation table.
2. Compute the transportation cost.
3. Test if improvements should be made.
4. Improve the transportation table and repeat step 2.
5. Make a recommendation.
Stepping Stone Method: Balance Transportation
In a balance transportation problem, the supply (source) is equal to the
demand (destination).
NORTHWEST METHOD
The North-West Corner Rule is a technique for calculating the first feasible
solution to a transportation problem. The method is called North-West
Corner because the basic variables are chosen from the far left corner.
Solving a Balanced Transportation Problem Using the Stepping-
Stone Method (Northwest Corner Method for the Initial Solution)
Required: Using stepping-stone method, determine the distribution of the frames from
the three warehouses to the projects.
Answer: The following steps are performed to determine the distribution of the frames
to the projects.
Step 1.
Construct the initial transportation table. The total available window frames in the
warehouses are 1,050 (150 + 450 + 450), and the total requirements of the three projects
are 1,050 frames (450 + 300 + 300) as well. The total supply is equal to the total demand.
Hence, the transportation problem is balanced. Table 1a shows the initial table with vacant
cells.
Table 1a. Initial Table
To Project 1 Project 2 Project 3 Total Supply
From
6 5 4
Warehouse A 150
9 8 4
Warehouse B 450
10 8 6
Warehouse C 450
1,050
Total Demand 450 300 300 1,050
The unit cost of transporting the goods is placed on the upper right corner of a cell. Using
the northwest corner rule, the first cell to be filled up is a cell A1. Project 1 needs 450
frames, but warehouse A only has 150 frames available. The balance (450-150) will come
from warehouse B.
This movement is shown in Table 1b.
Table 1b. Improved Initial Table
To Project 1 Project 2 Project 3 Total Supply
From
6 5 4
Warehouse A 150 150
9 5 4
Warehouse B 300 450
10 8 6
Warehouse C 450
1,050
Total Demand 450 300 300 1,050
The requirements of project 1 have been met already with 150 frames from warehouse 1
and 300 frames from warehouse 2. At this point, warehouse B still has 150 frames
available (450 – 300 frames). This unit will be supplied to project 2. However, project 2
needs 300 units. The balance of 150 (300 – 150) will come from warehouse C. The
movement is shown in Table 1c.
Table 1c. Improved Initial Table
9 5 4
Warehouse B 300 150 450
10 8 6
Warehouse C 150 300 450
1,050
Total Demand 450 300 300 1,050
Step 2.
Compute the transportation cost. The transportation cost shown in Table
1d is determined as follows:
A1 (150 x Php6.00) Php900.00
B1 (300 x Php9.00) 2,700.00
B2 (150 x Php5.00) 750.00
C2 (150 x Php8.00) 1,200.00
C3 (300 x Php6.00) 1,800.00
Total Cost Php7,350.00
Step 3
Test if the table is optimal. A table is optimal if there is no negative improvement index on
the empty cells. If a vacant cell has a negative improvement index, the table has to be
improved.
A negative improvement index indicates that if the corporation allocates on that vacant
cell, the overall cost per unit may be decreased by that amount.
However, before a transportation table can be improved, the solution’s degeneracy must
be determined. The number of occupied cells is equal to the total number of columns and
rows minus one, according to the law of degeneracy.
There are five occupied cells in table 1d (A1, B1, B2, C2 and C3). It has three
rows and three columns.
Hence, the number of occupied cells, which is five, is equal to the total number
of rows and columns minus one (5 = 3 + 3 – 1). The rule of degeneracy,
therefore, is not violated.
To improve the table, the vacant cells A2, A3, B3 and C1 shall be tested whether
the transfer of one unit produces a positive or negative value.
THE FOLLOWING ARE THE PROCEDURES THAT MUST BE
OBSERVED WHEN TESTING A VACANT CELL:
1) Select any vacant cell to be tested.
2) Test the vacant cell by making a horizontal or vertical path back to the
original vacant cell.
3) Begin with a plus sign on the original vacant cell and alternately place
minus and plus signs on each square of the path.
6 5 4
Warehouse A 150 Vacant cell A2 Vacant cell A3 150
9 5 4
Warehouse B 300 150 Vacant cell B3 450
10 8 6
Warehouse C Vacant cell C1 150 300 450
1,050
Total Demand 450 300 300 1,050
* The vacant cells are: A2, A3, B3, and C1
Compare the contents of these two negative cells and transfer all the contents
of the cell with the lower value.
Cell B1 has 300 units, while cell C2 has 150 units. Therefore, the contents of
the cell C2 should be transferred to cell C1.
Improvement of Cell C1
-9 +5
300 150
+10 -8
C1 150
150 300
300 150
+10 -8 10 8
150
C1 150
1. Add 150 units to 150 units in cell +5. (300)
2. Subtract 150 units from 300. (150)
Subtract because the sign of 9 is negative.
3. Lastly, we’ll add 150 to the cell +10.
Another Examples:
Path: +8 -24 +16 -4 = -4 Path: +16 -24 +16 -24 = -16
-4 +8 -24 +16
16 66 36 41
4 8 24 16
56 25 41
16 24 16 24
72 10 77
STEP 4: IMPROVE THE TRANSPORTATION TABLE AND REPEAT
STEP 2.
FIRST ITERATION
To
Project 1 Project 2 Project 3 Total Supply
From
6 5 4
Warehouse A
150 150
9 5 4
Warehouse B
150 300 450
10 8 6
Warehouse C
150 300 450
1,050
Total Demand
450 300 300 1,050
The transportation cost of table 2 is computed as follows:
From
Warehouse A 6 5 4
150 Vacant Cell A2 Vacant Cell A3 150
Warehouse B 9 5 4
150 300 Vacant Cell B3 450
Warehouse C 10 8 6
150 Vacant Cell C2 300 450
1,050
Total Demand 450 300 300 1,050
Before a test is conducted, the table must be checked whether it is degenerate or not.
Table 3 has three columns , three rows, and five occupied cells.
The total number of columns and rows minus one is equal to the number of occupied cells.
Hence, the table is not degenerate. The tests for vacant cells of Table 3 appear as follows:
Vacant Cells (Table 3) Path and Improvement
A2 +5 -5 +4 -6 +10 = +2
A3 +4 -6 +10 -6 =+2
B1 +9 -4 +6 -10 =+1
C2 +8 -6 +4 -5 = +1
The tests for vacant cells produced positive values for the
improvement indices. Hence, the optimal solution has been reached.
Table 3. Second Iteration
To
Project 1 Project 2 Project 3 Total Supply
From
6 5 4
Warehouse A
150 Vacant Cell A2 Vacant Cell A3 150
9 5 4
Warehouse B
Vacant Cell B1 300 150 450
10 8 6
Warehouse C
300 Vacant Cell C2 150 450
1,050
Total Demand
450 300 300 1,050
Step 5. Makes a recommendation. Based on Table 3, Jenny Company should distribute the
window frames to the three projects as follows:
When the supply (source) is greater than the demand (destination), a dummy
column or dummy destination is added. On the other hand, when the
demand is greater than the supply, a dummy row or dummy source is added
with artificial values.
A dummy column or dummy row is added to balance the source and the with
artificial values. A dummy column or dummy row is added to balance the
source and the destination.
In either case, the transportation cost assigned to the dummy cell is equal to
zero. The dummy cells are not tested for improvement since their value is
equal to zero, and there is no actual transfer that will be made on them.
Illustration 2
Solving an Unbalanced Transportation Problem Using the Stepping-Stone
Method (Supply is Greater than Demand)
Use the same information in Illustration 1, but assume that warehouse A has
375 units of window frames. This time, the supply is 1,275 units of window
frames, while the demand is 1,050 units. In such a case, a dummy column is
added with an artificial value to make the supply and demand equal. The
initial table appears as follows:
Table 4. Initial Table with a Dummy Column
To Project 1 Project 2 Project 3 Dummy Project Total Supply
From
6 5 4
Warehouse A
375 375
9 5 4
Warehouse B
75 300 75 450
10 8 6 0
Warehouse C
225 225 450
1,275
Total Demand
450 300 300 225 1,275
Table 4 has a transportation cost of Php6,075.00, which is computed as follows:
The two negative cells in the path of cell C1 are cells B1 and C3 with 75 units
and 225 units, respectively. Since the contents of cell B1 are lower than that of
cell C3, all the contents of cell B1 will be transferred to cell C1.
Table 5. Improved Table
To Project 1 Project 2 Project 3 Dummy Project Total Supply
From
6 5 4
Warehouse A
375 375
9 5 4
Warehouse B
300 150 450
10 8 6 0
Warehouse C
75 150 225 450
1,275
Total Demand
450 300 300 225 1,275
Table 5 has a transportation cost of Php6,000.00, which is computed as follows:
A1 (375 x Php6.00) Php2,250.00
B2 (300 x Php5.00) 1,500.00
B3 (150 x Php4.00) 600.00
C1 (75 x Php10.00) 750.00
C3 (150 x Php6.00) 900.00
Total Cost Php6,000.00
The transportation cost is reduced by Php75.00 because of the 75 units
transferred to cell C1. The vacant cells of Table 5 are then tested for further
improvement as follows:
Vacant Cells (Table 5) Path and Improvement Index
A2 +5 -5 +4 -6 +10 -6 = +2
A3 +4 -6 +10 -6 = +2
B1 +9 -4 +6 -10 = +1
C2 +8 -6 +4 -5 = +1
The improvement indices have a positive values. Hence, the optimal solution
has been reached.
Illustation 3
Solving an Unbalanced Transportation in Illustration 1, but assume that
project 1 needs 550 units of window frames. Since the demand of
1,150 is greater than the the supply of 1,050, a dummy row is added.
The initial table appears as follows:
Table 6. Initial Table with Dummy Row
To Project 1 Project 2 Project 4 Total Supply
From
6 5 4
Warehouse A 150 150
9 5 4
Warehouse B 400 50 450
10 8 6
Warehouse C 250 200 450
0 0 0
Dummy Warehouse 100 100
1,150
Total Demand 550 300 300 1,150
Table 6 has a transportation cost of Php7,950.00, which is computed as follows:
A1 (150 x Php6.00) Php900.00
B1 (400 x Php9.00) 3,600.00
B2 ( 50 x Php5.00) 250.00
C2 (250 x Php8.00) 2,000.00
C3 (200 x Php6.00) 1,200.00
Total Cost Php7,950.00
Table 6 is not degenerate. Hence, the vacant cells are tested for further
Improvement as follows:
Vacant Cells (Table 6) Path and Improvement Index
A2 +5 -5 +9 -6 = +3
A3 +4 -6 +8 -5 +9 -6 = +4
B3 +4 -6 +8 -5 = +1
C1 +10 -8 +5 -9 = -2
Cell C1 has an has an improvement index of -2; hence, a certain number of
units shoulb be transferred to it. The cells that have negative values in cell
C1’s path are cells B1 and C2. The contents of cell C2 are lower than that of
cell B1; hence, 250 units should be transffered to cell C1.
Table 7. Improved Table
To Project 1 Project 2 Project 3 Total Supply
From
6 5 4
Warehouse A 150 150
9 5 4
Warehouse B 150 300 450
10 8 6
Warehouse c 250 200 450
0 0 0
Dummy Warehouse 100 100
1,050
Total Demand 550 300 300 1,050
The Transportation cost of Table 7 is computed as follows:
6 5 4
Warehouse A 150 150
9 5 4
Warehouse B 300 150 450
10 8 6
Warehoouse C 400 50 450
0 0 0
Dummy Warehouse 100 100
1, 150
Total Demand 550 300 300 1,150
The transportation cost of Table 8 is computed as follows: