Question: Project Management. A project has four activities ( A , B , C , and D ) that must be performed sequentially. For this simulation

Project Management. A project has four activities (A, B, C, and D) that must be performed
sequentially. For this simulation question, we need to consider 1000 TRIALS, and run them in EXCEL. The probability distributions for the time required to complete each of the activities
are as follows:
a. Construct a spreadsheet simulation model to estimate the average length of the project and
the standard deviation of the project length.
b. According to your simulation model, what is the estimated probability that the project will be
completed in 35 weeks or less?
(Hint: The project time includes the summation of all activity times; use VLOOKUP function in
Excel ())
 Project Management. A project has four activities (A, B, C, and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related General Management Questions!