show how to put problem 3.20 (f) in Excel
3.20 Show how to do in Excel
MANAGEMENT a) Calculate the TIME (DAYS) late the expected time and variance for each activitu is the expected completion time of the critical is the expected completion time of the other path b) What is the exper IMMEDIATE PREDECESSOR(S) What is the expected complet ACTIVITY network? he variance of the critical path? What is the vas of the other path in the network? d) If the time to time to complete path A-C is normally distributed probability that this path will be finished in 22 we less? be time to complete path B-D is normally distributed robability that this path will be finished in 22 we is the probability that in less? plain why the probability that the critical path will in 22 weeks or less is not necessarily the probabili roject will be finished in 22 weeks or less. PX 24 Rich Cole Control Devices, Inc., produces ci lay devices for auto makers. The most recent ndertaken by Cole requires 14 diferent activities. Cole er would like to determine the total project completi vs) and those activities that lie along the critical pa propriate data are shown in the following table What is the probability of being done in 53 days? What date results in a 99% probability of completion? a) Determine the expected completion time and variance for each activity b) Determine the total project completion time and the critical path for the project. c) Determine ES, EF, LS, LF, and slack for each activity d) What is the probability that Kelle Carpet and Trim will finish the project in 40 days or less? PX ... 3.20 The estimated times and immediate predecessors for the activities in a project at George Kyparis's retinal scanning company are given in the following table. Assume that the active ity times are independent. IMMEDIATE ACTIVITY PREDECESSOR(S) MOST OPTIMISTIC UKELY PESSIMIST TIME TIME TIME TIME (WEEKS) IMMEDIATE PREDECESSOR ACTIVITY EF G H TIME (DAYS) IMMEDIATE PREDECESSORIS ACTIVITY has sin net- a) Calculate the expected time and variance for each activity b) What is the expected completion time of the critical path? What is the expected completion time of the other path in the network? What is the variance of the critical path? What is the variance of the other path in the network? d) If the time to complete path A-Cis normally distributed, what is the probability that this path will be finished in 22 weeks or less? If the time to complete path B-D is normally distributed, what is the probability that this path will be finished in 22 weeks or less? Explain why the probability that the critical path will be fin ished in 22 weeks or less is not necessarily the probability that the project will be finished in 22 weeks or less PX B.D variance for each a) Determine the expected completion time and variance for activity b) Determine the total project completion time and the cri path for the project. c) Determine ES, EF, LS, LF, and slack for each activity d) What is the probability that Kelle Carpet and Trim will find the project in 40 days or less? PX ... 3.21 Rich Cole Control Devices, Inc. produces custom built relay devices for auto makers. The most recent project undertaken by Cole requires 14 different activities. Cole's man- arers would like to determine the total project completion time (in days) and those activities that lie along the critical path. The appropriate data are shown in the following table. a) What is the probability of being done in 53 days? b) What date results in a 99% probability of completion? IMMEDIATE ACTIVITY PREDECESSOR(S) MOST OPTIMISTIC UKELY PESSIMISTIC TIME TIME TIME ... 3.20 The estimated times and immediate predecessors for the activities in a project at George Kyparis's retinal scanning company are given in the following table. Assume that the acts ity times are independent. W 0 TIME (WEEKS) - ACTIVITY IMMEDIATE PREDECESSOR - o - w - EF = 0 - = 0 =
