Develop simulation model for a PERT/CPM assignment based on problem 14 from chapter 11. Use the attached template (it has probability distributions of durations of activities A through D that you should consider) and perform 160 recalculations/trials using the Data Table feature of Excel. Calculate the following summary statistics - display them on top of the sheet:

• 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		10
0.25		5		0.2		3		0.25		12		Probability	Cumulative Probability	Time
0.35		6		0.55		5		0.4		14		0.6		8
0.25		7		0.25		7		0.2		16		0.4		10
0.15		8						0.05		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

Problem 14: A profit 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:

Here's the data:

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