All answers were generated using 1,000 trials and native Excel functionality.)

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:

Activity Activity Time(weeks) Probability

A 5 0.25

6 0.35

7 0.25

8 0.15

B 3 0.20

5 0.55

7 0.25

C 10 0.10

12 0.25

14 0.40

16 0.20

18 0.05

D 8 0.60

10 0.40

(a)Construct a spreadsheet simulation model to estimate the average length of the project and the standard deviation of the project length. Round your answers to one decimal place.

Average Project Length_______weeks

Standard Deviation in Project Length_____weeks

(b)What is the estimated probability that the project will be completed in 35 weeks or less? Round your answer to a whole percentage.% (THIS IS NOT .65 THAT IS INCORRECT)

(c)BASE CASE SCENARIO

(D) WORST CASE SCENARIO

(E) BEST CASE SCENARIO