PLEASE SHOW FORMULAS IF SOVLING WITH EXCEL

Problem 2 (Chapter 5 Project Management). Recently, you were assigned to manage a project for your company. You have constructed a network diagram (depicting the various activities in the project, see figure below). In addition, you have asked your team to estimate the amount of time (in days) that they would expect each of the activities to take. Their responses are shown in the table below. (Hint: This problem is similar to the examples in Slides 44-50 of Chapter 5) Start D Finish B E Activity Optimistic Most Likely Pessimistic te 5 8 6 U A A 11 B 4 8 11 5 7 D 2 4 6 E 4 7 10 What is the expected time and variance for each activity? b. What is the expected completion time of the project? What is the probability of completing the project in 21 days? d. What is the probability of completing the project in 17 days? a. c