Transportation Problem
Download
Report
Transcript Transportation Problem
Learning Outcomes
• Mahasiswa dapat menghitung
solusi model transportasi dengan
menggunakan program komputer..
Outline Materi:
• Masalah Transportasi
• Pembuatan program komputer
• Contoh & Penyelesaian..
Transportation Problem
• The transportation problem seeks to minimize
the total shipping costs of transporting goods
from m origins (each with a supply si) to n
destinations (each with a demand dj), when
the unit shipping cost from an origin, i, to a
destination, j, is cij.
• The network representation for a
transportation problem with two sources and
three destinations is given on the next slide.
Transportation Problem
• Network Representation
c11
c12
1
s1
c13
c21
c22
s2
2
c23
SOURCES
1
d1
2
d2
3
d3
DESTINATIONS
Transportation Problem
• LP Formulation
The LP formulation in terms of the amounts
shipped from the origins to the destinations, xij , can be
written as:
Min cijxij
ij
s.t.
xij < si for each origin i
j
xij = dj for each destination j
i
xij > 0 for all i and j
Transportation Problem
• LP Formulation Special Cases
The following special-case modifications to the linear
programming formulation can be made:
– Minimum shipping guarantee from i to j:
xij > Lij
– Maximum route capacity from i to j:
xij < Lij
– Unacceptable route:
Remove the corresponding decision variable.
Example: BBC
Building Brick Company (BBC) has orders for 80
tons of bricks at three suburban locations as follows:
Northwood -- 25 tons, Westwood -- 45 tons, and
Eastwood -- 10 tons. BBC has two plants, each of
which can produce 50 tons per week. Delivery cost
per ton from each plant to each suburban location is
shown on the next slide.
How should end of week shipments be made to
fill the above orders?
Example: BBC
Delivery Cost Per Ton
Northwood
Plant 1
24
Plant 2
30
Westwood
30
40
Eastwood
40
42
Example: BBC
Partial Spreadsheet Showing Problem Data
A
B
1
2 Constraint
X11
3
#1
1
4
#2
5
#3
1
6
#4
7
#5
8 Obj.Coefficients 24
C
D
E
F
G
H
X22
X23
RHS
LHS Coefficients
X12
X13
1
1
X21
50
1
1
1
1
1
25
1
1
30
40
30
50
40
45
1
10
42
30
Example: BBC
Partial Spreadsheet Showing Optimal Solution
A
B
C
D
10
X11
X12
X13
11 Dec.Var.Values
5
45
0
12
Minimized Total Shipping Cost
13
14
LHS
Constraints
15
P1.Cap.
50
16
P2.Cap.
30
17
N.Dem.
25
18
W.Dem.
45
19
E.Dem.
10
E
X21
20
2490
<=
<=
=
=
=
F
X22
0
RHS
50
50
25
45
10
G
X23
10
Example: BBC
Optimal Solution
From
To
Amount Cost
Plant 1 Northwood
5
120
Plant 1 Westwood
45
1,350
Plant 2 Northwood
20
600
Plant 2 Eastwood
10
420
Total Cost = $2,490
Example: BBC
Partial Sensitivity Report (first half)
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value
Cost
Coefficient Increase Decrease
$C$12 X11
5
0
24
4
4
$D$12 X12
45
0
30
4
1E+30
$E$12 X13
0
4
40
1E+30
4
$F$12 X21
20
0
30
4
4
$G$12 X22
0
4
40
1E+30
4
$H$12 X23 10.000
0.000
42
4
1E+30
Example: BBC
Partial Sensitivity Report (second half)
Constraints
Cell
$E$17
$E$18
$E$19
$E$20
$E$16
Name
P2.Cap
N.Dem
W.Dem
E.Dem
P1.Cap
Final Shadow Constraint Allowable Allowable
Value
Price
R.H. Side
Increase Decrease
30.0
0.0
50
1E+30
20
25.0
30.0
25
20
20
45.0
36.0
45
5
20
10.0
42.0
10
20
10
50.0
-6.0
50
20
5