PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.

Ross Hopkins, president of Hopkins Hospitality, has developed the tasks, durations, and predecessor relationships in the following table for building new motels. Draw the AON net- work and answer the questions that follow.

		Time Estimates (IN WEEKS)
Activity	Immediate Predecessor(s)	Optimistic	Most Likely	Pessimistic
A		4	8	10
B	A	2	8	24
C	A	8	12	16
D	A	4	6	10
E	B	1	2	3
F	E,C	6	8	20
G	E,C	2	3	4
H	F	2	2	2
I	F	6	6	6
J	D,G,H	4	6	12
K	I,J	2	2	3

a) What is the expected (estimated) time for activity C?

b) What is the variance for activity C?

c) Based on the calculation of estimated times, what is the critical path?

d) What is the estimated time of the critical path?

e) What is the activity variance along the critical path?

f) What is the probability of completion of the project before week 36?