.

Use Microsoft Excel to perform a Monte Carlo simulation of the above schedule. Use the optimistic and pessimistic durations for your range of durations. Run the simulation 100 times. Determine the average project duration for the 100 trials and create a table or histogram of the number of times the duration is between 20-30 days, 31-40 days, 41-50 days, and over 50 days.

In a CPM network, the critical path includes five activities. Their durations are estimated as follows