Develop simulation model for problem described in the attached file. Use the attached template and perform 150 recalculations/trials using the Data Table feature of Excel (recalculate the completion time of the project based on the formula for trial 1). Provide the following summary statistics (display them on top of the sheet for easy reference) :

• the estimate of the average length (duration) of the project
• the standard deviation of the project length (duration)
• mode, minimum, maximum and range of the project length (duration).

Calculate the probability that the project will be completed in 33 weeks or less.

Create also a histogram showing frequency distribution of project duration on a new sheet. Rename the sheet to Histogram.

Project duration problem (PERT/CPM model)
Input Parameters									Activity C
	Activity A				Activity B
								Probability	Cumulative Probability	Time			Activity D
Probability	Cumulative Probability	Time		Probability	Cumulative Probability	Time		0.1	0	10
0.25	0	5		0.2	0	3		0.25	0.1	12		Probability	Cumulative Probability	Time
0.35	0.25	6		0.55	0.2	5		0.4	0.35	14		0.6	0	8
0.25	0.6	7		0.25	0.75	7		0.2	0.75	16		0.4	0.6	10
0.15	0.85	8						0.05	0.95	18
		Activity A		Activity B		Activity C		Activity D	PROJECT
TRIAL	Rand #	duration of A	Rand #	duration of B	Rand #	duration of C	Rand #	duration of D	DURATION