Predecessors	activity time		most optimist	most probable	most pessimist	variance
A		15
B		50
C		30
D		3
E	A	7
F	B,C,D,E	6
G	F	1
H	G	36
I	H	6
J	I	6
K	I	32
L	I	4
M	J,K,L	3
N	M	15
O	M	18
P	N,O	2
Q	P	5

a) Based on the data provided (activity, predecessors, and activity time), establish the shortest completion time for the project (i.e. the critical path).

b) Let optimistic time be 75% of activity time, most probable 100%, and most pessimistic 200%, calculate the expected activities time.

c) Obtain the variance around each expected activity time.

d) Establish the new expected duration of the project (i.e. the critical path).

please complete in excel

thank you