Pert method - excel

PERTSampleFormulas.xlsx

Sheet1

Sample ex.
	Example		Time Estimates (in weeks) for a Project / Cost estimates in $
	ACTIVITY	OPTIMISTIC		MOST LIKELY	PESSIMISTIC	EXPECTED TIME	VARIANCE
		a		m	b	t = (a + 4m + b)/6	[(b – a)/6]2
	A	1		2	3	2	0.1111111111

3 pt estimates		PERT Method		Budget		average		variance
			O	M	P	(O+4*M+P)/6	(p-o)/6	((p-o)/6)^2
	rent	A	1000	1300	2000	1366.6666666667	166.6666666667	27777.7777777778
	utilities	B	100	125	170	128.3333333333	11.6666666667	136.1111111111
	parking spot	C	40	50	75	52.5	5.8333333333	34.0277777778
						1547.5		27947.9166666667	Var
								167.1763041423	St dev	σ
				estimated cost		1547.5		27947.9166666667	Variance	Sum of the errrors from the mean
				Average				167.1763041423	Std Dev		z = x- u/sigma
								Z value
				z = x-u/sigma				X
				z*sigma = x- u
			z= 1.64	2.7388	x- 1547.5
				1550.2388	X