This problem should be solved in Excel ( Please use separate spreadsheets for different parts).
- Consider a project having the following activities and time estimates:
Activities Optimistic Most Likely Pessimistic
1-2 10 22 22
1-3 20 20 20
1-4 4 10 16
2-6 2 14 26
3-5 4 4 4
3-6 8 8 20
3-7 8 14 20
4-5 0 12 12
5-7 4 16 28
6-7 2 8 14
a. Construct a PERT network for the project
b. Compute the te value for each activity, the ?e value for each activity, identify the critical path and determine the expected project completion time.
c. Determine the probability of completing the project within 55 days.
d. What is the probability that the project will require at least 45 days to complete?
e. Find the probability of completing the project between 40 days and 65 days.