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 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 weeks or less?
Hint: The project time includes the summation of all activity times; use VLOOKUP function in
Excel
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
