Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 20

A project has four activities (A, B, C, and D) that must be performed sequentially. 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. What is the estimated probability that the project will be completed in 35 weeks or less