Enter the following information into an Excel spreadsheet. The time estimates were made at the 90
Question:
Enter the following information into an Excel® spreadsheet. The time estimates were made at the 90 percent level (Calculating Probabilistic Activity Times subsection). All activity times are in days.
a. Draw the network. (You may use MSP, or draw an AOA or AON network by hand.)
b. Using Excel®, calculate the expected time (TE) and variance for each activity.
c. Using the expected times, find the critical path and critical time. (Use the analytic method.)
d. Find the probability that the critical path will be completed in 38 days or less.
e. Are there any serious sources of merge bias? What are they? Calculate the probability of finishing the project on or before day 38 when merge bias is included.
f. Assume that the times in the table were made on the 99+ percent level. Recalculate the activity variances with this assumption and find the probability that the critical path will be complete in 38 days. Briefly explain the difference in probabilities.
g. How many days are required for the critical path to have a .9 probability of completion?
Step by Step Answer:
Project Management in Practice
ISBN: 978-0470533017
4th edition
Authors: Samuel J. Mantel Jr., Jack R. Meredith, Sco