soal 9.
11
9/10/15
transport
Transportation
Enter
Enter the
the transportation
transportation data
data in
in the
the shaded
shaded area.
area. Then
Then go
go to
to the
the DATA
DATATab
Tab on
on the
the ribbon,
ribbon, click
click on
on Solver
Solver in
in the
the Data
Dat
Group
Group and
and then
then click
click SOLVE.
SOLVE.
IfIf SOLVER
SOLVER isis not
not on
on the
the Data
Data Tab
Tab then
then please
please see
see the
the Help
Help file
file (Solver)
(Solver) for
for instructions.
instructions.
Data
COSTS
Origin 1
Origin 2
Origin 3
Demand
Shipments
Shipments
Origin 1
Origin 2
Origin 3
Column Total
Total Cost
Dest 1
Dest 2
5
8
9
200
Dest 1
Dest 3
4
4
7
200
3
300
3
150
5
250
300 700 \ 700
Dest 2
Dest 3
200
50
150
200
200
0
0
Supply
3200
Page 1
Row Total
300
0
150
250
250
300 700 \ 700
50
soal 9.11
ribbon,
ribbon, click
click on
on Solver
Solver in
in the
the Data
DataAnalysis
Analysis
tions.
ctions.
Page 2
9.39
A
9/10/15
1
2
9.39
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Assignment
Enter
Enter the
the assignment
assignment costs
costs in
in the
the shaded
shaded area.
area. Then
Then go
go to
to the
the DATA
DATATab
Tab on
on the
the ribbon,
ribbon, click
click on
on Solver
Solver in
in
the
the Data
Data Analysis
Analysis Group
Group and
and then
then click
click SOLVE.
SOLVE.
IfIf SOLVER
SOLVER isis not
not on
on the
the Data
Data Tab
Tab then
then please
please see
see the
the Help
Help file
file (Solver)
(Solver) for
for instructions.
instructions.
Data
COSTS
S
A
O
B
Assignments
Shipments
S
A
O
B
Column Total
Total Cost
C
1500
460
1500
960
D
1730
810
1850
610
T
1940
1020
2080
400
T
1
1
1
1
4580
Page 3
2070
1270
###
330
Row Total
1
1
1
1
1
1
4
9.39
G
1
2
3
4
5
6
TA Tab
click
ATA
Tab on
on the
the ribbon,
ribbon,
click on
on Solver
Solver in
in
7
8
olver)
olver) for
for instructions.
instructions.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Page 4
9.41
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
A
9/10/15
9.41
Assignment
Enter
Enter the
the assignment
assignment costs
costs in
in the
the shaded
shaded area.
area.Then
Then go
go to
to the
the DATA
DATATab
Tab on
on the
the ribbon,
ribbon, click
click on
on
Solver
Solver in
in the
the Data
DataAnalysis
Analysis Group
Group and
and then
then click
click SOLVE.
SOLVE.
IfIf SOLVER
SOLVER isis not
not on
on the
the Data
DataTab
Tabthen
thenplease
please see
seethe
the Help
Helpfile
file (Solver)
(Solver)for
for instructions.
instructions.
Data
Prof
Anderson
sweeney
william
mckinney
Assignments
Shipments
Anderson
sweeney
william
mckinney
Column Total
Total Cost
statistic
90
70
85
85
statistic
managementfinance
65
60
40
80
95
80
80
65
managemenfinance
economic
1
1
1
1
1
335
Page 5
economic
40
75
60
55
Row Total
1
1
1
1
1
1
4
9.41
H
1
2
3
4
5
6
ab
ab on
on the
the ribbon,
ribbon, click
on
7click on
8
)for
for instructions.
instructions.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Page 6
9.17
9/10/15
9.17
Transportation
Enter
Enter the
the transportation
transportation data
data in
in the
the shaded
shaded area.
area. Then
Then go
go to
to the
the DATA
DATATab
Tab on
on the
the ribbon,
ribbon, click
click on
on Solver
Solver in
in th
th
Group
Group and
and then
then click
click SOLVE.
SOLVE.
IfIf SOLVER
SOLVER isis not
not on
on the
the Data
Data Tab
Tab then
then please
please see
see the
the Help
Help file
file (Solver)
(Solver) for
for instructions.
instructions.
Data
COSTS
MT
YT
PB
Demand
Shipments
Shipments
MT
YT
PB
Column Total
Total Cost
CV
CT
50
20
100
30
CV
0
30
0
30
CJ
30
80
40
45
CB
60
10
80
25
CT
CJ
35
5
5
45
3100
Page 7
0
25
0
25
Supply
70
35
90
60
30
25
20 120 \ 120
CB
0
0
Row Total
35
60
20
25
20 120 \ 120
9.17
on
on the
the ribbon,
ribbon, click
click on
on Solver
Solver in
in the
the Data
DataAnalysis
Analysis
nstructions.
instructions.
Page 8
