This question was answered as below but i didn't understand what was choosed from the QM excel to get this answer can anyone explain the steps to get those answers. Please don't give the same answer.
Solve the following using Excel QM 11-19 The Laurenster Corporation needs to set up an assembly line to produce a new product. The following table describes the relationships among the activities that need to be completed for this product to be manufactured. ACTIVITY DAYS IMMEDIATE PREDECESSORS m 11 5 6 10 2 E, F, H a) Develop a project network for this problem. b) Determine the expected duration and variance for each activity. c) Determine the ES, EF, LS, LF, and slack time for each activity. Also determine the total project completion time and the critical path(s). d) Determine the probability that the project will be completed in 34 days or less. e) Determine the probability that the project will take longer than 29 days. Activity Predeces a m b Te ESEF LF LS Slack Std De Variance 3 6 6 5.50 0.00 5.50 5.50 0.00 0.00 0.50 0.25 B A T 5 811 8.00 5.50 13.50 13.50 5.50 0.00 1.00 1.00 C A T 5 61 10 6.50 5.50 12.00 13.500 7.000 1.50 0.83 0.69 D B .C 11 216 2.50 13.50 16.00 16.00 13.50 0.00 0.83 0.69 E D 711111511100 16.00 27.00 30.00 19.00 3.00 1.33 1.78 FD 71914 9.50 16.00 25.50 25.50 16.00 0.00 1.17 1.36 D 6 8 10 8.00 16.00 24.00 25.50 17.50 1.50 0.67 0.44 HFG 4.50 25.50 30.00 30.00 25.50 0.00 0.83 0.69 E, F, H 357 5.00 30.00 35.00 35.00 30.00 0.00 0.67 0.44 35.00 week ES, EF calculated from start to end EFEES+cycle time 2 Shown intable LS, LF calculated from end to start Te-expected time=(a+4'm+b)/6 LSELF-cycle time variance= ((b-a)/6)^2 Review: Std dev Ib-a)/6 Expected completion of the project = 35 days Critical path ABOFHI Probability to complete in less than 34 days z=(specified time-path expected Z= -0.47 Hence probability 32% normsdist(z) Probability to complete in more than 29 days z=(specified time-path expected Z= -2.85 Hence probability 99.78% normsdist(z) Solve the following using Excel QM 11-19 The Laurenster Corporation needs to set up an assembly line to produce a new product. The following table describes the relationships among the activities that need to be completed for this product to be manufactured. ACTIVITY DAYS IMMEDIATE PREDECESSORS m 11 5 6 10 2 E, F, H a) Develop a project network for this problem. b) Determine the expected duration and variance for each activity. c) Determine the ES, EF, LS, LF, and slack time for each activity. Also determine the total project completion time and the critical path(s). d) Determine the probability that the project will be completed in 34 days or less. e) Determine the probability that the project will take longer than 29 days. Activity Predeces a m b Te ESEF LF LS Slack Std De Variance 3 6 6 5.50 0.00 5.50 5.50 0.00 0.00 0.50 0.25 B A T 5 811 8.00 5.50 13.50 13.50 5.50 0.00 1.00 1.00 C A T 5 61 10 6.50 5.50 12.00 13.500 7.000 1.50 0.83 0.69 D B .C 11 216 2.50 13.50 16.00 16.00 13.50 0.00 0.83 0.69 E D 711111511100 16.00 27.00 30.00 19.00 3.00 1.33 1.78 FD 71914 9.50 16.00 25.50 25.50 16.00 0.00 1.17 1.36 D 6 8 10 8.00 16.00 24.00 25.50 17.50 1.50 0.67 0.44 HFG 4.50 25.50 30.00 30.00 25.50 0.00 0.83 0.69 E, F, H 357 5.00 30.00 35.00 35.00 30.00 0.00 0.67 0.44 35.00 week ES, EF calculated from start to end EFEES+cycle time 2 Shown intable LS, LF calculated from end to start Te-expected time=(a+4'm+b)/6 LSELF-cycle time variance= ((b-a)/6)^2 Review: Std dev Ib-a)/6 Expected completion of the project = 35 days Critical path ABOFHI Probability to complete in less than 34 days z=(specified time-path expected Z= -0.47 Hence probability 32% normsdist(z) Probability to complete in more than 29 days z=(specified time-path expected Z= -2.85 Hence probability 99.78% normsdist(z)
