A7-1 (Algo) Given the project information...

Given the project information in the following table, what is the probability of completing the National Holiday Toy project in 93-time units? Hint: Use the =NORM.S.DIST(z, TRUE) function in Excel to compute the probability. (Carry at least 2 decimal places in your task time and variance calculations and at least 3 decimal places in your z value calculation. Enter your final probability answer to 3 decimal places.)

Acct. ID	Description	Predecessor	Optimistic (a)	Most Likely (m)	Pessimistic (b)	Activity Time (te)	Variance [(b - a)/6]2	Critical ?
1	Design package	None	6	12	24	13	9	x
2	Design product	1	17	19	28	20.17	3.36	x
3	Build package	1	4	7	10	7	1
4	Secure patent	2	24	27	36	28	4
5	Build product	2	17	29	47	30	25	x
6	Paint	3,4,5	4	7	10	7	1	x
7	Test market	6	13	14	19	14.67	1	x