Transportation models may be used when a firm is trying to decide where to locate a new facility

1 4 UNIT FOUR: Transportation and Assignment problems 4.1 Objectives By the end of this unit you will be able to: formul...

4

UNIT FOUR: Transportation and Assignment problems

4.1

Objectives

By the end of this unit you will be able to: • formulate special linear programming problems using the transportation model. • define a balanced transportation problem • develop an initial solution of a transportation problem using the Northwest Corner Rule • use the Stepping Stone method to find an optimal solution of a transportation problem • formulate special linear programming problems using the assignment model • solve assignment problems with the Hungarian method.

4.2

Introduction

In this unit we extend the theory of linear programming to two special linear programming problems, the Transportation and Assignment Problems. Both of these problems can be solved by the simplex algorithm, but the process would result in very large simplex tableaux and numerous simplex iterations. Because of the special characteristics of each problem, however, alternative solution methods requiring significantly less mathematical manipulation have been developed.

4.3

The Transportation problem

The general transportation problem is concerned with determining an optimal strategy for distributing a commodity from a group of supply centres,such as factories, called sources, to various receiving centers, such as warehouses, called destinations, in such a way as to minimise total distribution costs. Each source is able to supply a fixed number of units of the product, usually called the capacity or availability, and each destination has a fixed demand, often called the requirement.

105

Transportation models can also be used when a firm is trying to decide where to locate a new facility. Good financial decisions concerning facility location also attempt to minimize total transportation and production costs for the entire system. 4.3.1

Setting up a Transportation problem

To illustrate how to set up a transportation problem we consider the following example; Example 4.1 A concrete company transports concrete from three plants, 1, 2 and 3, to three construction sites, A, B and C. The plants are able to supply the following numbers of tons per week: Plant 1 2 3

Supply (capacity) 300 300 100

The requirements of the sites, in number of tons per week, are: Construction site A B C

Demand (requirement) 200 200 300

The cost of transporting 1 ton of concrete from each plant to each site is shown in the figure 8 in Emalangeni per ton. For computational purposes it is convenient to put all the above information into a table, as in the simplex method. In this table each row represents a source and each column represents a destination. Sites PP P

PP P

From Plants

To PP P

1 2 3 Demand (requirement)

A

B

C

4 7 4

3 5 5

8 9 5

200

200

300

106

Supply (Availability) 300 300 100

Figure 8: Constructing a transportation problem

4.3.2

Mathematical model of a transportation problem

Before we discuss the solution of transportation problems we will introduce the notation used to describe the transportation problem and show that it can be formulated as a linear programming problem. We use the following notation; xij =

si = dj = cij =

the number of units to be distributed from source i to destination j (i = 1, 2, . . . , m; j = 1, 2, . . . , n); supply from source i; demand at destination j; cost per unit distributed from source i to destination j

With respect to Example 4.1 the decision variables xij are the numbers of tons transported from plant i (where i = 1, 2, 3) to each site j (where j = A, B, C) A basic assumption is that the distribution costs of units from source i to destination j is directly proportional to the number of units distributed. A typical cost and requirements table has the form shown on Table 4. Let Z be total distribution costs from all the m sources to the n destinations. In example 4.1 each term in the objective function Z represents the total cost of tonnage transported on one route. For example, in the route 2 −→ C, the term in 9x2C , that is: (Cost per ton = 9) × (number of tons transported = x2C )

107

1 2 . Source .. m Demand

1 c11 c21 .. . cm1 d1

Destination 2 ... n c12 . . . c1n c22 . . . c2n .. .. . ... . cm2 . . . cmn d2 . . . dn

Supply s1 s2 .. . sm

Table 4: Cost and requirements table Hence the objective function is: Z = 4x1A + 3x1B + 8x1C + 7x2A + 5x2B + 9x2C + 4x3A + 5x3B + 5x3C

Notice that in this problem the total supply is 300 + 300 + 200 = 700 and the total demand is 200 + 200 + 300 = 700. Thus Total supply = total demand. In mathematical form this expressed as m X

si =

i=1

n X

dj

(47)

j=1

This is called a balanced problem . In this unit our discussion shall be restricted to the balanced problems. In a balanced problem all the products that can be supplied are used to meet the demand. There are no slacks and so all constraints are equalities rather than inequalities as was the case in the previous unit. The formulation of this problem as a linear programming problem is presented as Minimise Z =

m X n X

cij xij ,

(48)

i=1 j=1

subject to n X

j=1 n X

xij = si ,

for i = 1, 2, . . . , m

(49)

xij = dj ,

for j = 1, 2, . . . , n

(50)

i=1

108

and xij ≥ 0, for all i and j. Any linear programming problem that fits this special formulation is of the transportation type, regardless of its physical context. For many applications, the supply and demand quantities in the model will have integer values and implementation will require that the distribution quantities also be integers. Fortunately, the unit coefficients of the unknown variables in the constraints guarantee an optimal solution with only integer values. 4.3.3

Initial solution - Northwest Corner Rule

The initial basic feasible solution can be obtained by using one of several methods. We will consider only the North West corner rule of developing an initial solution. Other methods can be found in standard texts on linear programming. The procedure for constructing an initial basic feasible solution selects the basic variables one at a time. The North West corner rule begins with an allocation at the top left-hand corner of the tableau and proceeds systematically along either a row or a column and make allocations to subsequent cells until the bottom right-hand corner is reached, by which time enough allocations will have been made to constitute an initial solution. The procedure for constructing an initial solution using the North West Corner rule is as follows: NORTH WEST CORNER RULE 1. Start by selecting the cell in the most “North-West” corner of the table. 2. Assign the maximum amount to this cell that is allowable based on the requirements and the capacity constraints. 3. Exhaust the capacity from each row before moving down to another row. 4. Exhaust the requirement from each column before moving right to another column. 5. Check to make sure that the capacity and requirements are met. Let us begin with an example dealing with Executive Furniture corporation, which manufactures office desks at three locations: D, E and F. The firm distributes the desks through regional warehouses located in A, B and C (see the Network format diagram below)

109

Factories (Sources)

Warehouses (Destinations)

100 Units

D

1 *

A

300 Units

300 Units

E

q :

B

200 Units

300 Units

F

s q -

C

200 Units

6

Capacities

6

6

Requirements

Shipping Routes

It is assumed that the production costs per desk are identical at each factory. The only relevant costs are those of shipping from each source to each destination. The costs are shown in Table 5 PP PP

From

To PP P

D E F

PP

A

B

C

$5 $8 $9

$4 $4 $7

$3 $3 $5

Table 5: Transportation Costs per desk for Executive Furniture Corp. We proceed to construct a transportation table and label its various components as show in Table 6. We can now use the Northwest corner rule to find an initial feasible solution to the problem. We start in the upper left hand cell and allocate units to shipping routes as follows:

110

PP P

PP P

From

D

To

A

B

PP P

5

C 4

Capacity 3 100

E

8

4

3 300

F

9

Requirements

300

7 200

5 300 700

200

Table 6: Transportation Table for Executive Furniture Corporation 1. Exhaust the supply (factory capacity) of each row before moving down to the next row. 2. Exhaust the demand (warehouse) requirements of each column before moving to the next column to the right. 3. Check that all supply and demand requirements are met. The initial shipping assignments are given in Table 7 PP PP

From

To PP P

PP

D E F Warehouse Requirements

B

C

100 100

200

Factory Capacity 100 300 300

200

200

700

A 100 200 300

Table 7: Initial Solution of the North West corner Rule This initial solution can also be presented together with the costs per unit as shown in the Table 8. We can compute the cost of this shipping assignment as follows; Therefore, the initial feasible solution for this problem is $4200. Example 4.2 Consider a transportation problem in which the cost, supply and demand values are presented in Table 10. (a) Is this a balanced problem? Why?

111

PP P

PP P

From

D

To

A

PP P

B 5

C

Capacity

4

3

100

100

E

8

4

200 F Requirements

3

100 9

300 7

100 200

300

5 200 200

300 700

Table 8: Representing the initial feasible solution with costs ROUTE FROM TO D A E A E B F B F C

UNITS SHIPPED 100 200 100 100 200

×

PER UNIT COST ($) 5 8 4 7 5

=

TOTAL COST ($) 500 1600 400 700 1000 Total 4200

Table 9: Calculation of costs of initial shipping assignments (b) Obtain the initial feasible solution using the North-West Corner rule. Solution: (a) We calculate the total supply and total demand. Total supply = 14 + 10 + 15 + 13 = 52 Total demand = 10 + 15 + 12 + 15 = 52 Since the total supply is equal to the total demand we conclude that the problem is balanced. (b) The allocations according to the North-West corner rule are shown in Table 11 The initial feasible solution is

Total Cost = 10 · 10 + 4 · 30 + 10 · 15 + 1 · 30 + 12 · 20 + 2 · 20 + 13 · 45 = $1265 Note that this is not necessarily equal to the optimal solution.

112

Source

1 2 3 4 Demand

Destination 1 2 3 10 30 25 20 15 20 10 30 20 30 40 35 10 15 12

4 15 10 20 45 15

Supply 14 10 15 13

Table 10: Supply and Demand values for Transportation problem

1 2 3 4 Demand

1 10

10

2 4 10 1

3

4

12

15

12

2 13 15

Supply 14 10 15 13

Table 11: Initial feasible solution

4.4

Exercises 4.1: Northwest Corner rule

In each of the following problems check whether the solution is balanced or not then use the North West Corner rule to find the basic feasible solution. PP P

TO PP PP FROM PP

1.

1 2 3 Demand

1

2

3

Supply

3 1 5 50

2 5 4 60

0 0 0 30

45 60 35

2

3

Supply

4 4 7 200

3 3 5 200

100 300 300

PP P

2.

TO PP 1 FROM PPPP 1 5 2 8 3 9 Demand 300

113

PP PP

FROM 3.

A B C Demand

PP PP

FROM 4.

4.4.1

TO PP P

PP

TO PP P

1 2 3 4 Demand

PP

1

2

3

4

Supply

12 6 10 400

13 4 9 900

4 10 12 200

6 11 4 500

500 700 800

1

2

3

4

Supply

10 20 10 30 10

30 15 30 40 15

25 20 20 35 12

15 10 20 45 15

14 10 15 13

Optimality test - the Stepping Stone method

The next step is to determine whether the current allocation at any stage of the solution process is optimal. We will present one of the methods used to determine optimality of and improve a current solution. The method derives its name from the analogy of crossing a pond using stepping stones. The occupied cells are analogous to the stepping stones, which are used in making certain movements in this method. The five steps of the Stepping-Stone Method are as follows:

114

STEPPING-STONE METHOD 1. Select an unused square to be evaluated. 2. Beginning at this square, trace a closed path back to the original square via squares that are currently being used (only horizontal or vertical moves allowed). You can only change directions at occupied cells!. 3. Beginning with a plus (+) sign at the unused square, place alternative minus (-) signs and plus signs on each corner square of the closed path just traced. 4. Calculate an improvement index, Iij by adding together the unit cost figures found in each square containing a plus sign and then subtracting the unit costs in each square containing a minus sign. 5. Repeat steps 1 to 4 until an improvement index has been calculated for all unused squares. • If all indices computed are greater than or equal to zero, an optimal solution has been reached. • If not, it is possible to improve the current solution and decrease total shipping costs. 4.4.2

The optimality criterion

If all the cost index values obtained for all the currently unoccupied cells are nonnegative, then the current solution is optimal. If there are negative values the solution has to be improved. This means that an allocation is made to one of the empty cells (unused routes) and the necessary adjustments in the supply and demand effected accordingly. To see how the Stepping-Stone method works we apply these steps to the Furniture Corporation example to evaluate the shipping routes. Steps 1-3 Beginning with the D-B route, we first trace a closed path using only currently occupied squared (see Table 12) and then place alternate plus signs and minus signs in the corners of this path. Step 4 An improvement index Iij for the D-B route in now computed by adding unit costs in squares with plus signs and subtracting costs in squares with minus signs. Thus IDB = +4 − 5 + 8 − 4 = +3 This means that for every desk shipped via the D-B route, total transportation costs will increase by $3 over their current level.

115

PP PP

To

A

PP PP From P

B

D

100

5 ← 8 → 9

↓ +

E 200 F Requirements

300

Start + ↑ - 100

C

Capacity

4

3 100

4

3 300

7 100 200

5 200 200

300 700

Table 12: Evaluating the D-B route Step 5 Next we consider the D-C unused route. The closed path we use is (see Table 13) +DC − DA + EA − EB + F B − F C The D-C improvement index is IDC = +3 − 5 + 8 − 4 + 7 − 5 = +4 PP PP P

From

D

To

A

PP PP

100 E 200

B 5 ← 8 → 9

↓ +

F Requirements

300

←−

C ←−

- 100 ↓ + −→ 100 200

4 ← 4 7 →

Start + ↑ ↑ ↑ 200 200

Capacity 3 100 3 300 5 300 700

Table 13: Evaluating the D-C route The other two routes may be evaluated in a similar fashion E-C route: closed path = +EC - EB + FB - FC IEC = +3 − 4 + 7 − 5 = +1 FA route: closed path = +FA - FB + EB - EA IF A = +9 − 7 + 4 − 8 = −2 Because the IF A index is negative, a cost saving may be attained by making use of the FA route i.e the FA cell can be improved. The Stepping-Stone path used to evaluate the route FA is shown in Table 14 116

PP

PP P

From

D

To

A

PP PP

B

C

5

Capacity

4

3

100

100

E 200 F Start Requirements

↓ + 300

8 ← 9 →

4 + ↑ -

3

100

300 7

100 200

5 200 200

300 700

Table 14: Stepping-Stone Path used to evaluate FA route The next step, then is to ship the maximum allowable number of units on the new route (FA route). What is the maximum quantity that can be shipped on the money-saving route? The quantity is found by referring to the closed path of plus signs and minus signs drawn for the route and selecting the smallest number found in those squares containing minus signs. To obtain a new solution, that number is added to all squares on the closed path with plus signs and subtracted from all squares on the path assigned minus signs. All other squares are left unchanged. The new solution is shown in Table 15. PP P

PP P

From

D

To

A

PP P

B 5

C 4

Capacity 3

100

100

E

8 100

4

F

9

300 7

100 Requirements

3

200

300

200

5 200 200

300 700

Table 15: Improved solution: Second solution The shipping cost for this new solution is 100 · 5 + 100 · 8 + 200 · 4 + 100 · 9 + 200 · 4 = $4000 This solution may or may not be optimal. To determine whether further improvement is possible, we return to the first five steps to test each square that is now unused. The four improvement indices - each representing an available shipping route are as follows:

D to B = IDB = 4 − 5 + 8 − 4 = +$3 (Closed path : +DB − DA + EA − EB) 117

D to C = IDC = 3 − 5 + 9 − 5 = +$2 (Closed path : +DC − DA + F A − F C) E to C = IEC = 3 − 8 + 9 − 5 = −$1 (Closed path : +EC − EA + F A − F C) F to B = IF B = 7 − 4 + 8 − 9 = +$2 (Closed path : +F B − EB + EA − F A) Hence, an improvement can be made by shipping the maximum allowable number of units from E to C (see Table 16). PP

PP P

From

D

To

A

PP PP

B

C

5

Capacity

4

3

100 E 100 F 100 Requirements

100 ↓ ↓ + 300

8 9 →

← 200

←

→ → 200

4

← Start

7 →

+

3 300

↑ → 200 200

5 300 700

Table 16: Path to evaluate the E-C route The improved solution is shown in Table 17. The total cost for the third solution is 100 · 5 + 200 · 4 + 100 · 3 + 200 · 9 + 100 · 5 = $3900 To determine if the current solution is optimal we calculate the improvement indices - each PP P

PP P

From

D

To

A

PP P

B 5

C 4

Capacity 3

100

100

E

8

4 200

F

9

7

200 Requirements

3 100

300

200

5 100 200

Table 17: Improved solution: Third solution representing an available shipping route - as follows:

D to B = IDB = 4 − 5 + 9 − 5 + 3 − 4 = +$2 118

300 300 700

(Closed path: + DB − DA + F A − F C + EC − EB) D to C = IDC = 3 − 5 + 9 − 5 = +$2 (Closed path: + DC − DA + F A − F C) E to A = IEA = 8 − 9 + 5 − 3 = +$1 (Closed path: + EA − F A + F C − EC) F to B = IF B = 7 − 5 + 3 − 4 = +$1 (Closed path: + F B − F C + EC − EB) Table 17 contains the optimal solution because each improvement index for the Table is greater than or equal to zero.

4.5

Summary

In this section we discussed the formulation of transportation problems and their methods of solution. We used the North West corner rule to obtain the initial feasible solution and the Stepping-Stone method to find the optimal solution. We restricted focus to balanced transportation problems where it is assumed that the total supply is equal to total demand.

4.6

Exercises 4.2: Transportation problems

1. A company has factories at A, B and C which supply warehouses at D, E and F. Weekly factory capacities are 200, 160 and 90 units respectively. Weekly warehouse requirements (demands) are 180, 120 and 150 units respectively. Unit shipping costs (in Emalangeni) are as follows: Factory A B C Demand

D 16 14 26 180

E 20 8 24 120

F 12 18 16 150

Capacity 200 160 90 450

Determine the optimum distribution for this company to minimize shipping costs. [E5920] 2. A Timber company ships pine flooring to three building supply houses from its mills in Bhunya, Mondi and Pigg’s Peak. Determine the best transportation schedule for the data given below using the Northwest corner rule and the Stepping Stone method. [E230]

119

PP

PP P

TO

FROM Bhunya Mondi Pigg’s Peak Supply House Demand (tons)

PP PP

Supply House 1 3 4 3

Supply House 2 3 2 2

Supply House 3 2 3 3

M ill Capacity (tons) 25 40 30

30

30

35

95

3. A trucking company has a contract to move 115 truckloads of sand per week between three sand-washing plants W,X and Y, and three destinations, A,B and C. Cost and volume information is given below. Compute the optimal transportation cost. PP

PP P

To

Project A PP PP

From Plant W Plant X Plant Y Demand

5 20 5 45

Project B

Project C

Supply

10 30 8 50

10 20 12 20

35 40 40

[C=1345] 4. In each of the following cases write down the North West corner solution and use the Stepping Stone method to find the minimal cost. PP

PP P

FROM

TO PP PP

A B C Demand

(a)

D

E

F

Capacity

8 6 10 90

6 3 7 20

9 8 9 10

20 30 70 120 [E970]

PP

PP P

FROM (b)

TO PP PP

A B C Demand

D

E

F

Capacity

2 2 1 2

2 1 3 5

3 6 4 11

4 6 8 18 [E48]

120

PP

PP P

FROM (c)

TO PP PP

A B C Demand

D

E

F

Capacity

5 7 6 4

2 3 4 5

2 4 3 6

7 5 3

121

4.7

Assignment Problem

The assignment problem refers to the class of linear programming problems that involve determining the most efficient assignment of • people to projects • salespeople to territories • contracts to bidders • jobs to machines, etc. The objective is most often to minimize total costs or total time of performing the tasks at hand. One important characteristic of assignment problems is that only one job or worker is assigned to one machine or project. An example is the problem of a taxi company with 4 taxis and 4 passengers. Which taxi should collect which passenger in order to minimize costs? Each assignment problem has associated with it a table, or matrix. Generally, the rows contain the objects or people we wish to assign, and the columns comprise the tasks or things we want them assigned to. The numbers in the table are the costs associated with each particular assignment. An assignment problem can be viewed as a transportation problem in which • the capacity from each source (or person to be assigned) is 1 and • the demand at each destination (or job to be done) is 1. As an illustration of the assignment problem, let us consider the case of a Fix-It-Shop, which has just received three new rush projects to repair: (1) a radio, (2) a toaster oven, and (3) a broken coffee table. Three repair persons, each with different talents and abilities, are available to do the jobs. The owner of the shop estimates what it will cost in wages to assign each of the workers to each of the three projects. The costs which are shown in Table 18 differ because the owner believes that each worker will differ in speed and skill on these quite varied jobs. Table 19 summarizes all six assignment options. The table also shows that the least-cost solution would be to assign Cooper to project 1, Brown to project 2, and Adams to project 3, at a total cost of $25. The owner’s objective is to assign the three projects to the workers in a way that will result in the lowest cost to the shop. Note that the assignment of people to projects must be on a one-to-one basis; each project will be assigned exclusively to one worker only. 122

PERSON Adams Brown Cooper

1 $11 8 9

PROJECT 2 $14 10 12

3 $6 11 7

Table 18: Repair costs of the Fix-It-Shop assignment problem PROJECT ASSIGNMENT 1 2 3 Adams Brown Cooper Adams Cooper Brown Brown Adams Cooper Brown Cooper Adams Cooper Adams Brown Cooper Brown Adams

LABOUR COSTS ($) 11 + 10 +7 11 + 12 +11 8 + 14 + 7 8 + 12 + 6 9 + 14 + 11 9 + 10 + 6

TOTAL COSTS ($) 28 34 29 26 34 25

Table 19: Assignment alternatives and Costs of Fix-It-Shop assignment problem Special algorithms exist to solve assignment problems. The most common is probably the Hungarian solution method. The Hungarian method of assignment provides us with an efficient means of finding the optimal solution without having to make a direct comparison of every assignment option. It operates on a principle of matrix reduction, which means that by subtracting and adding appropriate numbers in the cost table or matrix, we can reduce the problem to a matrix of opportunity costs. Opportunity costs show the relative penalties associated with assigning any person to a project as opposed to making the best or least-cost assignment. We would like to make assignments such that the opportunity cost for each assignment is zero. The steps involved in the Hungarian method are outlined below.

123

THE HUNGARIAN METHOD 1. Find the opportunity cost table by (a) Subtracting the smallest number in each row of the original cost table or matrix from every number in that row. (b) Then subtracting the smallest number in each column of the table obtained in part (a) from every number in that column. 2. Test the table resulting from step 1 to see whether an optimal assignment can be made. The procedure is to draw the minimum number of vertical and horizontal straight lines necessary to cover all zeros in the table. If the number of lines equals either the number of rows or columns, an optimal assignment can be made. If the number of lines is less than the number of rows or columns, we proceed to step 3. 3. Revise the present opportunity cost table. This is done by subtracting the smallest number not covered by a line from every other uncovered number. This same smallest number is also added to any number(s) lying at the intersection of the horizontal and vertical lines. We then return to step 2 and continue the cycle until an optimal assignment is possible. Let us now apply the three steps to the Fix-It-Shop assignment example. The original cost table for the problem is given in Table 20

PERSON Adams Brown Cooper

PROJECT 1 2 3 11 8 9

14 10 12

Table 20: Initial Table

PERSON Adams Brown Cooper

6 11 7

PROJECT 1 2 3 5 0 2

8 2 5

0 3 0

Table 21: Row reduction (part a)

After the row reduction (Step 1 part a) we get the cost Table 21. Taking the costs in Table 21 and subtracting the the smallest number in each column from each number in that column results in the total opportunity costs given in Table 22. This step is the column reduction of Step 1 part (b) If we draw vertical and horizontal straight lines (Step 2) to cover all the zeros in Table 22 we get Table 23. Since the number of lines is less than the number of rows or columns an optimal assignment cannot be made. Since Table 23 doesn’t give an optimal solution we revise the table. This is accomplished by subtracting the smallest number not covered by a line from all numbers not covered by 124

PERSON Adams Brown Cooper

1

PROJECT 2

3

6 0 3

0 3 0

5 0 2

Table 22: Column Reduction (Step 1 part b)

PERSON Adams Brown Cooper

1

PROJECT 2

3

6 0 3

0 3 0

5 0 2

Table 23: Testing for an optimal solution a straight line. This same smallest number is then added to every number (including zeros) lying in the intersection on any two lines. The smallest uncovered number in Table 23 is 2, so this value is subtracted from each of the four uncovered numbers. A 2 is also added to the number that is covered by the intersecting horizontal and vertical lines. The results of this step are shown in Table 24 To test now for an optimal assignment, we return to Step 2 and find the minimum number of lines necessary to cover all zeros in the revised opportunity cost table. Because it requires three lines to cover the zeros (see Table 25), an optimal assignment can be made.

PERSON Adams Brown Cooper

PROJECT 1 2 3 3 0 0

4 0 1

0 5 0

Table 24: Revised opportunity cost table

PERSON

1

Adams Brown Cooper

3 0 0

PROJECT 2 3 4 0 1

0 5 0

Table 25: Optimality test on the revised table

Finally, we make the allocation. Note that only one assignment will be made from each row or column. We use this fact to proceed to making the final allocation as follows: (a) Find a row or column with only one zero cell. (b) Make the assignment corresponding to that zero cell. (c) Eliminate that row and column from the table. (d) Continue until all the assignments have been made. 125

For our Fix-It-Shop problem these steps are summarized in Table 26. FIRST ASSIGNMENT 1 2 3 Adams Brown Cooper

3 0 0

4 0 1

0 5 0

SECOND ASSIGNMENT 1 2 3 Adams Brown Cooper

3 0 0

4 0 1

THIRD ASSIGNMENT 1 2 3

0 5 0

Adams Brown Cooper

3 0 0

4 0 1

0 5 0

Table 26: Making the final assignment To interpret the table we recall that our objective was to minimize costs, there is only one assignment that Adams can go to where the opportunity costs are $0. That is to assign Adams Project 3. If Adams gets assigned to Project 3, then there is only one project left where the opportunity cost is $0 for Cooper. Therefore Cooper gets assigned to Project 1. This leaves Brown being assigned to Project 2, where the opportunity costs are $0. The optimal allocation is to assign Adams to Project 3, Brown to Project 2, and Cooper to Project 1. The total labour cost of this assignment are computed from the original cost table (see Table 18). They are as follows: ASSIGNMENT Adams to Project 3 Brown to Project 2 Cooper to Project 1 Total cost

COST ($) 6 10 9 25

Example 4.3 Suppose we have to allocate 4 tasks (1,2,3,4) between 4 people (W,X,Y,Z). The costs are set out in the following table:

Person W X Y Z

1 8 15 22 25

Task 2 20 16 19 15

3 15 12 16 12

4 17 10 30 9

The entries in the table denote the costs of assigning a task to a particular person. Solution: Step 1 of the Hungarian method involves the following parts: (a) subtract the minimum value from each column (see Table 27) (b) subtract the minimum value from each column (see Table 28) 126

Person W X Y Z

1 0 5 6 16

Task 2 12 6 3 6

3 7 2 0 3

4 9 0 14 0

Person W X Y Z

Table 27: Subtract the minimum value from each row

1 0 5 6 16

Task 2 9 3 0 3

3 7 2 0 3

4 9 0 14 0

Table 28: subtract the minimum value from each column

The next step is to check whether optimal assignment can be made. This is done by finding the minimum number of lines necessary to cross-out all the zero cells in the table. If this is equal to n (the number of people/tasks) then the solution has been found. The minimum number of lines necessary to cross through all the zeros (see Table 29)is 3 ¡ n = 4 so that an optimal allocation has not been found. ( Note that there may be more than one way to draw the lines through the zero cells. It does not matter which way you choose as long as there is no alternative way involving fewer lines)

Person W X Y Z

1 0 5 6 16

Task 2 9 3 0 3

3 7 2 0 3

4 9 0 14 0

Table 29: Checking if an optimal assignment can been made Next we revise the table by (a) Finding the minimum uncovered cell. Table 29 shows that the minimum uncovered cell has a value of 2 (b) Subtracting the value obtained in (a) (i.e subtract 2) from all the uncovered cells. (c) Adding to all the cells at the intersection of the two lines. The result of the above steps is given in Table 30. We then check if the revised allocation is optimal. This is done by finding the minimum number of lines required to cover all zeros (see Table 31). This time the minimum number of lines necessary to cross through all the zeros is n = 4 so that an optimal allocation has been found. To make the final allocation we use the following steps. 127

Person W X Y Z

1 0 5 8 16

Task 2 7 1 0 1

3 5 0 0 1

4 9 0 16 0

Table 30: Revising the Table

Person W X Y Z

1 0 5 8 16

Task 2 7 1 0 1

3 5 0 0 1

4 9 0 16 0

Table 31: Checking for optimality

• Find a row or column with only one zero cell. • Make the assignment corresponding to that zero cell. • eliminate that row and column from the table. • Continue until all assignments have been found.

Person W X Y Z

1 0 5 8 16

Task 2 7 1 0 1

3 5 0 0 1

4 9 0 16 0

• Assign person W to task 1 and eliminate row W and column 1. • Assign person Y to task 2 and eliminate row Y and column 2. • Assign person Z to task 4 and eliminate row Z and column 4. • This leaves final person X assigned to remaining task 3. From the original cost table, we can determine the costs associated with the optimal assignment: T otal Cost = 48

4.8

Maximization Assignment Problems

Some assignment problems are phrased in terms of maximizing the payoff, profit, or effectiveness of an assignment instead of minimization costs. It is easy to obtain an equivalent minimization problem by converting all numbers in the table to opportunity costs; efficiencies to inefficiencies,etc. This is achieved through subtracting every number in the original payoff table from the largest single number in the number. The transformed entries represent opportunity costs; it turns out that minimizing the opportunity costs produces the same 128

assignment as the original maximization problem. Once the optimal assignment for this transformed problem has been computed, the total payoff or profit is found by adding the original payoffs of those cells that are in the original assignment. Example. The British Navy wishes to assign four ships to patrol four sectors of the North Sea. In some areas ships are to be on the outlook for illegal fishing boats, and in other sectors to watch for enemy submarines, so the commander rates each ship in terms of its profitable efficiency in each sector. These relative efficiencies are illustrated in Tables 32. On the basis of the ratings shown, the commander wants to determine the patrol assignments producing the greatest overall efficiencies.

SHIP

A

SECTOR B C

1 2 3 4

20 60 80 65

60 30 100 80

50 80 90 75

D 55 75 80 70

Table 32: Efficiencies of British Ships in Patrol sectors

SHIP

A

1 2 3 4

80 40 20 35

SECTOR B C 40 70 0 20

50 20 10 25

D 45 25 20 30

Table 33: Opportunity Costs of British Ships

We start by converting the maximizing efficiency table into a minimization opportunity cost table. This is done by subtracting each rating from 100, the largest rating in the whole table. The resulting opportunity costs are given in Table 33. Next, we follow steps 1 and 2 of the assignment algorithm. The smallest number is subtracted from every number in that row to give Table 34; and then the smallest number in each column is subtracted from every number in that column as shown in Table 35.

SHIP

A

1 2 3 4

40 20 20 15

SECTOR B C 0 50 0 0

10 0 10 5

D 5 5 20 10

Table 34: Row opportunity costs for the British Navy Problem

SHIP

A

1 2 3 4

25 5 5 0

SECTOR B C 0 50 0 0

10 0 10 5

D 0 0 15 5

Table 35: Total opportunity costs for the British Navy Problem

The minimum number of straight lines needed to cover all zeros in this total opportunity cost table is four. Hence an optimal assignment can be made. The optimal assignment is ship 1 to sector D, ship 2 to sector C, ship 3 to sector B, and ship 4 to sector A. The overall efficiency, computed from the original efficiency data Table 32, can now be shown: 129

ASSIGNMENT Ship 1 to Sector D Ship 2 to Sector C Ship 3 to Sector B Ship 4 to Sector A Total Efficiency

4.9

EFFICIENCY 55 80 100 65 300

Summary

In this section we discussed the Hungarian method for solving both maximization and minimization assignment problems.

4.10

Exercises 4.3: Minimization Assignment Problems

1. Three accountants, Phindile, Rachel and Sibongile, are to be assigned to three projects, 1, 2 and 3. The assignment costs in units of E1000 are given in the table below.

Accountant

1 15 7 13

P R S

Project 2 9 5 4

3 12 10 6

2. Joy Taxi has four taxis, 1,2,3 and 4, and there are four customers, P, Q, R and S requiring taxis. The distance between the taxis and the customers are given in the table below, in Kilometres. The Taxi company wishes to assign the taxis to customers so that the distance traveled is a minimum.

Taxis

1 2 3 4

P 10 6 14 4

Customers Q R 8 4 4 12 10 8 14 10

S 6 8 2 8

3. Four precision components are to be shaped using four machine tools, one tool being assigned to each component. The machining times, in minutes, are given in the table below.

130

Machine Tool

1 21 25 36 34

A B C D

Component 2 3 20 39 22 24 22 36 21 25

4 36 25 26 39

4. In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like to assign jobs so that total time in minimized. Use the assignment method to find the best solution.

JOB A12 A15 B2 B9

MACHINE X Y

W 10 12 9 14

14 13 12 16

16 15 12 18

Z 13 12 11 16

Answer: A12 to W, A15 to Z, B2 to Y, B9 to Z, 50 hours.

4.11

Exercises 4.4: Maximization Assignment Problems

1. A head of department has four lecturers to assign to pure maths (1), mechanics (2), statistics (3) and Quantitative techniques (4). All of the teachers have taught the courses in the past and have been evaluated with a score from 0 to 100. The scores are shown in the table below.

Peters Radebe Tsabedze Williams

1 80 58 70 90

2 55 35 50 70

3 45 70 80 40

4 45 50 65 80

The head of department wishes to know the optimal assignment of teachers to courses that will maximize the overall total score. Use the Hungarian algorithm to solve this problem. [ P → 1 , R → 3, T → 4, W → 2 Max Score = 285] 2. A department store has leased a new store and wishes to decide how to place four departments in four locations so as to maximize total profits. The table below gives the profits, in thousands of emalangeni, when the departments are allocated to the various locations. Find the assignment that maximizes total profits. 131

Department

Shoes Toys Auto Housewares

Location 1 2 20 16 25 28 27 20 24 22

3 22 15 23 23

4 18 21 26 22

3. The head of the business department, has decided to apply the Hungarian method in assigning lecturers to courses next semester. As a criterion for judging who should teach each course, the head of department reviews the past two years’ teaching evaluations. All the four lecturers have taught each of the courses at one time or another during the two year period. The ratings are shown in the table below. Find the best assignment of lecturers to courses to maximize the overall teaching rating. Total Rating = 335

LECTURER

STATISTICS

Dlamini Khumalo Masuku Nxumalo

90 70 85 55

COURSE MANAGEMENT FINANCE 65 60 40 80

132

95 80 80 65

ECONOMICS 40 75 60 55

What is the usual objective of the transportation model?

What is a general transportation problem find the optimal assignment and total cost of assignments?

In what situations a transportation problem is certainly infeasible?

Which of the following is the first step in minimizing the total cost in the assignment model?