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

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.

Enter the following information into an Excel® spreadsheet. The


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?

96567706804 - 2 1 172 1 64965629429 P54764287067 rde | | | abb cc d, f, h A-abcdefgh ijk

Step by Step Solution

3.32 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The spreadsheet below was used to calculate the expected time and variance for each activity b The network c As shown in the spreadsheet above this ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

132-B-M-L-P-M (1043).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!