!!!! I NEED IT IN EXCEL QM !!!!!!!!!! I NEED IT IN EXCEL QM !!!!!!

?

2. You are asked to manage an upcoming project for a client based in Chicago. Your supervisor, Susan, asked you to determine if the project will be completed in 2 months (60 days). Susan sent you the estimated time durations (in days) for the project. The information is given below: Activity Immediate Optimistic Most Likely Pessimistic Predecessor Time Time Time 10 12 15 B A 6 10 14 A 10 15 20 A 9 9 18 B 5 6 8 C.E 10 12 13 B 12 14 16 H B,D 18 21 24 B,D 10 15 20 F.G.H 8 10 14 1. Compute the expected time and variance for each activity. 2. What is the critical path and the expected duration of the project? 3. What is the probability that the project will take longer than 58 days to complete? 4. Your supervisor was told that the client would like to complete the project in 56 days. Which path in the project network has the greatest risk of running over this new deadline of 56 days? 5. Prepare a report for Susan regarding your findings. Include your recommended strategy to finish the project in the least possible time