Question

(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.

%

Answer 1