Question: 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
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.
Consider the network described in the table on the right.
a. Calculate the expected duration of each activity.
b. Calculate the expected duration and variance of the critical path.
c. Calculate the probability that the project will be completed in fewer than 30 time units.
| Activity | Immediate | Pessimistic | Probable | Optimistic |
| Predecessor(s) | ||||
| J | -- | 15 | 10 | 8 |
| K | -- | 9 | 8 | 7 |
| L | J | 10 | 6 | 5 |
| M | J | 3 | 3 | 3 |
| N | K,M | 9 | 5 | 1 |
| O | K,M | 10 | 7 | 4 |
| P | L,N | 10 | 8 | 3 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
