operations

profilewmashles88
ch16hmwkdata.xlsx

Prob1&2

Problem 1/2
Activity Activity Time Immediate Prd
A 3 none
B 4 A
C 2 B
D 5 B
E 4 C
F 3 D
G 2 E,F
Use the fill shape tool to identify the critical path
4
2
2
3 4
5 3
a
b

a

b

c

d

e

f

g

Prob4-8

Problem 6
#4> Draw together
#7> Completion time
Critical path acegij
#8> Standard Deviation 0
38 P(project<38wks) 38
42 P(project<42wks) 42
= normdist(x,mean,sdev,1)
Activity Immediate Prd Optimistic Time Most Likely Time Pessimistic Time (#5) Expected Time (#6) Variance
A none 3 6 9
B A 3 5 7
C A 4 7 12
D B 4 8 10
E C 5 10 16
F D,E 3 4 5
G D,E 3 6 8
H F 5 6 10
I G 5 8 11
J H,I 3 3 3 Possible Paths
Path1 Path2 Path3 Path4
Total Time

a

b

e

f

g

j

h

d

i

c

Prob10

Problem 10
1.Determine how much the project needs to be reduced
2. Determine which activities on the critical path can be reduced
3. Crash critical activities on the basis of increasing costs
Crash the least expensive activity first and so on
Calculate the total costs associated with crashing the project
Crash this project by 3 weeks
Activity Normal Time Normal Cost Crash time Crash Cost Max Weeks Reduced Crash Cost per Week
A 4 $ 800 3 $ 1,200 1.0 $ 400
B 3 $ 900 2 $ 1,000 1.0 $ 100
C 5 $ 1,250 3 $ 2,250 2.0 $ 500
D 2 $ 800 2 $ 800 0.0 $ - 0
E 5 $ 1,500 4 $ 2,000 1.0 $ 500
F 6 $ 2,000 5 $ 3,000 1.0 $ 1,000
G 4 $ 600 3 $ 900 1.0 $ 300
H 3 $ 900 3 $ 900 0.0 $ - 0
Activity Savings
Take one week from
Take one week from
Take one week from