Question

• Refer to the information below:

	Depends On	Optimistic Duration(days)	Most Likely Duration(days)	Pessimistic Duration(days)
A	-	7	10	18
B	A	3	8	14
C	B	10	14	22
D	A	2	5	9
E	B,D	7	9	15
F	C,D	4	9	19
G	B	10	15	29
H	C,E,F	2	8	19
I	G,H	1	2	7
J	I	3	9	18

• Determine the following for each activity:
  • Expected Duration (round to the nearest whole number)
  • Early Start (ES)
  • Early Finish (EF)
  • Late Start (LS)
  • Late Finish (LF)
  • Total Float (TF)
  • Variance

• Determine the following for the project:
  • Critical Path (CP)
  • Number of Days required to complete the project (i.e., Expected Project Duration)

• Determine the probability that the project will complete in 76 days or less.

• Determine the probability that the project will complete in 58 days or less.

Please complete in excel and include formulas used.

Answer 1