Untitled
Untitled
Untitled
Transshipment, and
Assignment Problems
Objective function
=C7+D7+E7
Cost array in
=D5+D6+D7 Decision variables cells K5:M7
in cells C5:E7
Exhibit 6.1
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-6
Transportation Model Example
Computer Solution with Excel (2 of 4)
Supply constraints
Demand constraints
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 6.2 6-7
Transportation Model Example
Computer Solution with Excel (3 of 4)
Exhibit 6.3
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-8
Transportation Model Example
Computer Solution with Excel (4 of 4)
6-10
Example
6-15
6-16
6-17
Least cost Method
6-18
6-19
6-20
Vogel Approximation Method (VAM)
6-21
6-22
6-23
6-24
Iterative Computations of the Transportation
Algorithm
Step 1. Use the simplex optimality condition to determine the entering
variable as the current nonbasic variable that can improve the
solution. If the optimality condition is satisfied, stop. Otherwise,
go to Step 2.
6-25
n Method of multipliers:
n Ui and vj for row i and column j respectively
for each current basic variable Xij
Grain Elevator
Farm 3. Kansas City 4. Omaha 5. Des Moines
1. Nebraska $16 10 12
2. Colorado 15 14 17
=SUM(B6:D6)
Cost arrays
=SUM(C13:C15) =SUM(C13:E13)
Transshipment
constraints in
cells C20:C22
Exhibit 6.12
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-39
Transshipment Model Example
Network Solution for Wheat Shipping (3 of 3)
Decision
variables,
C5:F8
=C5+D5+E5+F5
=D5+D6+D7+D8
Mileage array
Exhibit 6.13
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-44
Assignment Model Example
Computer Solution with Excel (2 of 3)
Exhibit 6.14
Simplex LP
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall Exhibit 6.15 6-46
Assignment Model Example
Assignment Network Solution
n Joe’s three children, John, Karen and Terri, want to earn some money to take care of
personal expenses during a school trip to the local zoo.
n Joe has chosen three chores for his children: moving the lawn, painting the garage
door, and washing the family cars.
n To avoid anticipating sibling competition, he asks them to submit (secret) bids for
what they feel is fair pay for each of the three chores.
n Table 5.32 summarizes the bids received.
n Based on this information, how should Joe assign the chores?
6-49
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-50
Example 2.
2 $9 $7 $1 $9
0
3 $4 $5 $1 $7
1
4 $8 $7 $8 $5
6-51
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-52
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall 6-53
Example Problem Solution
Transportation Problem Statement
A concrete company transports concrete from three
plants to three construction sites. The supply capacities of
the three plants, the demand requirements at the three
sites, and the transportation costs per ton are as follows:
Construction site
Plant A B C Supply (tons)
1 $8 $5 $6 120
2 15 10 12 80
3 3 9 10 80
Demand (tons) 150 70 100