Solved Problem 1
Line Balancing
<Back
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.3 Cycle time CT = 1.6
b0.6
c a 0.4
g e 0.1 a h
h f g 0.5 c I
i h 0.3 e
j g
0
0.2
0.4
0.6
1.2
1.4
1.6
1.8
Clear
Page 13
Step 3: Assign tasks to stations
Solved Problem 1
1.6 1.6 1.6 1.6 1.6 1.6
a FALSE 0
b FALSE b FALSE
c FALSE a FALSE
d FALSE c FALSE
e FALSE e FALSE
I FALSE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
empty TRUE
Page 14
Solved Problem 3
Minimizing Transportation Distance
<Back Step 3: Assign workcenters to locations
Step 1: Enter distance between locations A B C D E F G H
A B C D E F G H 6 2 5 3 1 4
A50 100 50 80 130 Total cost = 25,540 Note: multiply cost by $2 per foot
B50 90 40 70
A-F 1-6
Step 2: Enter trips between workcenters D-E 4-5
1 2 3 4 5 6 7 8 D-F 4-6
1125 62 64 25 50 B-C 2-3
210 17 26 54 B-D 2-4
3 2 0 20 B-E E-F 2-5 5-6
413 2 B-F 2-6
6
7
8
Page 15
Solved Problem 3
A B C D E F G H
To:62531400
A600000000
B 2 2700 01300 900 01190 0 0
C 5 500 0000000
H000000000
To: A B C D E F G H
A 0 50 100 50 80 130 0 0
B50 050 90 40 70 0 0
D50 90 140 050 120 0 0
Page 16
D 3 1000 0 0 0 0 240 0 0
G000000000
Chapter 6 – Problems 2-6 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
2. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a1.4 Cycle time CT = 1.8
b a 0.5
d b 0.7
Step 3: Assign tasks to stations
f c 0.5 a b d g
g d e 1 e c h
i
3. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a 3 Cycle time CT = 14
b a 2
c b 4
d 7
Step 3: Assign tasks to stations
e d 4 Station: 1 2 3 4 5 6
f 5 f d b h
h c e 9 e
4.a Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.2 Cycle time CT = 1.3
b a 0.4
c0.3
d b c 1.3
Step 3: Assign tasks to stations
f e 0.8 a d f h
g d f 0.3 b g
c b 0.6
h g 1.2 c
i e
4.b Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.2 Cycle time CT = 2.3
b a 0.4
e0.1 Station: 1 2 3 4 5 6
f e 0.8 a f
g d f 0.3 b g
h g 1.2 c h
i d
j e
k Task Time 2.3 2.3 0 0 0 0
5. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.2 Cycle time CT = 1.2
b a 0.4
c b 0.2
e d 1.2 Station: 1 2 3 4 5 6
f c 1.2 a e f g
g e f 1 b
h d
i c
j
k Task Time 1.2 1.2 1.2 1 0 0
6. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.1 Cycle time CT = 1.5
j
k Task Time 1 1.3 1.1 1.2 0 0
b a 0.2
d c 0.6
Step 3: Assign tasks to stations
g f 0.4 b f k
i h 0.2 e h
j I 0.7 i
k j 0.3 Task Time 1.3 1.5 1.2 0 0 0
l k 0.2 Idle Time 0.2 -0 0.3
Chapter 6 – Problems 7-16 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
7. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a45 Cycle time CT = 50
b a 11
c b 9
d50
Step 3: Assign tasks to stations
e d 26 Station: 1 2 3 4 5 6
8b. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.5 Cycle time CT = 2
b a 1.4
d a 0.7
Step 3: Assign tasks to stations
e b c 0.5 Station: 1 2 3 4 5 6
f d 1 a c e g k
g e 0.4 b d f h m
i f 0.5
k h j 0.9 Task Time 1.9 1.9 21.5 1.2 0
m k 0.3 Percentage Idle Time 15.00%
g c 12 c f
h c 10 g i
Total task time = 8.5 Efficiency 85.00%
8c. Line Balancing
Step 1: Fill in predecessors and times
Task Predecessors Time Step 2: Enter cycle time
a0.5 Cycle time CT = 2
d a 0.7
Step 3: Assign tasks to stations
e b c 0.5 Station: 1 2 3 4 5 6
f d 1 a b c f j m
i f 0.5
j e i 0.8
k h j 0.9 Task Time 1.2 1.4 1.7 1.9 20.3
14a. Minimizing Transportation Distance
Step 3: Assign workcenters to locations
Step 1: Enter distance between locations A B C D E F G H
A B C D E F G H 1 4 2 3
A40 80 70 Total cost = 14,150
B40 50
C60
F
5
6
7
8
b. Minimizing Transportation Distance
Step 3: Assign workcenters to locations
Step 1: Enter distance between locations A B C D E F G H
A B C D E F G H 2 4 3 1
A40 80 70 Total cost = 9,800
B40 50
C60 Distance Workflow
G
Step 2: Enter trips between workcenters
12345678
120 20 40 B-C 2-3
210 50 B-D 2-4
360
4
5
6
7
8
15. Minimizing Transportation Distance
Step 3: Assign workcenters to locations
Step 1: Enter distance between locations A B C D E F G H
A B C D E F G H 1 5 7 4 3 6 2 8
A40 40 60 120 80 100 110 Total cost = 143,650
4
D40 50 40 45
E90 50 40
F40 60
G40
Step 2: Enter trips between workcenters
1 2 3 4 5 6 7 8
110 590 370 135 125 0
2360 120 40 115 45 120
3350 110 40 20 200
16. Minimizing Transportation Distance
Step 3: Assign workcenters to locations
Step 1: Enter distance between locations A B C D E F G H
A B C D E F G H 3 5 1 4 6 2 7
A40 80 100 120 160 35 Total cost = 55,600
B40 60 80 120 35
D20 40 35
E40 35
F35
G
Note: location G is reception area.
Step 2: Enter trips between workcenters
1 2 3 4 5 6 7 8
1 0 40 110 80 50 20
2 0 50 40 120 50
310 250 10 210
440 90 20
8