Question: Show your workings and calculation using Excel QM / QM for Windows. Then, interpret the solution using your own word. QUESTION 2 Tom Schriber, a
Show your workings and calculation using Excel QM / QM for Windows. Then, interpret the solution using your own word.


QUESTION 2 Tom Schriber, a director of personnel of Management Resources, Inc., is in the process of designing a program that its customers can use in the job-finding process. Some of the activities include preparing resumes, writing letters, making appointments to see prospective employers, researching companies and industries, and so on. Some of the information on the activities is shown in the activities is shown in the following table. DAYS IMMEDIATE ACTIVITY PREDECESSORS m b A CD 10 12 B 6 7 9 3 3 4 D 10 20 30 A E 6 7 8 F 9 10 11 B, D, E G 6 7 10 B, D, E H 14 15 16 F 10 11 13 F J 6 7 8 GH K 4 7 8 L 1 N 4 GH Discussion Questions a) Determine the expected time and variance for each activity. b) Construct a network diagram for this problem. Determine the critical path and project completion time. c) Determine the probability that the project will be finished in 70 days or less. d) Determine the probability that the project will be finished in 80 days or less. e) Determine the probability that the project will be finished in 90 days or less. Source: Barry Render, Ralph M. Stair, Jr., Michael E. Hanna, Trevor S. Hale, Quantitative Analysis for Management, 11, Prentice Hall, 2011