Please I would like to help.

B G M N 1 0 0 4 A D F H J L 1 Activity Time Estimate in weeks 2 A 4 3 B 1 4 C 2 5 D 6 E 7 F 8 G 7 9 H 101 2 11 J 2 12 K 3 13 L 4 14 M 2 15 N 12 16 O 3 17 P 2 18 Q 2 19 R 5 20 S 1 21 T 4 22 23 DIRECTIONS 24 Use the data provided to fill in the Template worksheet attached. Show formulas. Email your spreadsheet through Moodle. 25 26 You are asked to be the project team leader assigned to design a new management training course in your organization. 27 Your management team has calculated time estimates for you using best case, worst case & most likely case times (triple time estimates) and give you Te. 28 With the Te activity times provided to you, compute the ES, EF, LS, LF and slack or float for each activity. Show your formulas in the Template. 29 1) What is the time required to finish all your activities? 30 2) What activities are on the critical path? 31 3) If the standard deviation for finishing the project is 3 weeks, what is the probability that this project could be done in less than 29 weeks? 32 Assume the times given were derived from a triple time estimate and therefore standard deviation is relevant 33 34 Note there are 2 dummy activities, E & F. A dummy activity is used to show predecessors but no resources or time is involved. 35 EF F G LF Finish Time H 1 ES LS Start Time J J Slack or Float D, E Enter formulas in yellow section A B D E 1 Your name goes here ----> 2 3 Activity Time Estimate Predecessors Successors Description 4 A 4 none Track literature on evaluation 5 B 1 none G Set up steering committee 6 C 2 none H, I, J Develop needs assessment questionnaire 7 D 6A F Develop reaction evaluation instrument 8 E OJA O.P Dummy activity 9 F OD Dummy activity 10 G 7 B O.P Meet with advisory Committee to discuss curriculum 11 H 41C Conduct needs assessment in first division 12 7C L Conduct needs assessment in second division 13 J J 210 M Conduct needs assessment in third division 14 K 3 H N N Analyze data and develop cases and exercise 15 L 41 N Analyze data and develop cases and exercise 16 M 2J N Analyze data and develop cases and exercise 17 N N 12 K, L, M Develop first draft of curriculum 18 O 3 G, N, E Q Develop behavior evaluation instrument 19 P 2G, NE R Advisory committee reviews curriculum 20 Q 20, F S Advisory Committee reviews evaluation instruments 21 R 21P T Curriculum revisions based on advisory Committee input 22 S 1Q T Evaluation revisions based on advisory committee input 23 T 4R, S Conduct two pilot training courses 24 25 1) What is the time required to finish all your activities? 26 2) What activities are on the critical path? 27 3) If the standard deviation for finishing the project is 3 weeks, 28 what is the probability that this project could be done in 29 less than 29 weeks? 30 1) Answer 2) Answer 3) Answer B G M N 1 0 0 4 A D F H J L 1 Activity Time Estimate in weeks 2 A 4 3 B 1 4 C 2 5 D 6 E 7 F 8 G 7 9 H 101 2 11 J 2 12 K 3 13 L 4 14 M 2 15 N 12 16 O 3 17 P 2 18 Q 2 19 R 5 20 S 1 21 T 4 22 23 DIRECTIONS 24 Use the data provided to fill in the Template worksheet attached. Show formulas. Email your spreadsheet through Moodle. 25 26 You are asked to be the project team leader assigned to design a new management training course in your organization. 27 Your management team has calculated time estimates for you using best case, worst case & most likely case times (triple time estimates) and give you Te. 28 With the Te activity times provided to you, compute the ES, EF, LS, LF and slack or float for each activity. Show your formulas in the Template. 29 1) What is the time required to finish all your activities? 30 2) What activities are on the critical path? 31 3) If the standard deviation for finishing the project is 3 weeks, what is the probability that this project could be done in less than 29 weeks? 32 Assume the times given were derived from a triple time estimate and therefore standard deviation is relevant 33 34 Note there are 2 dummy activities, E & F. A dummy activity is used to show predecessors but no resources or time is involved. 35 EF F G LF Finish Time H 1 ES LS Start Time J J Slack or Float D, E Enter formulas in yellow section A B D E 1 Your name goes here ----> 2 3 Activity Time Estimate Predecessors Successors Description 4 A 4 none Track literature on evaluation 5 B 1 none G Set up steering committee 6 C 2 none H, I, J Develop needs assessment questionnaire 7 D 6A F Develop reaction evaluation instrument 8 E OJA O.P Dummy activity 9 F OD Dummy activity 10 G 7 B O.P Meet with advisory Committee to discuss curriculum 11 H 41C Conduct needs assessment in first division 12 7C L Conduct needs assessment in second division 13 J J 210 M Conduct needs assessment in third division 14 K 3 H N N Analyze data and develop cases and exercise 15 L 41 N Analyze data and develop cases and exercise 16 M 2J N Analyze data and develop cases and exercise 17 N N 12 K, L, M Develop first draft of curriculum 18 O 3 G, N, E Q Develop behavior evaluation instrument 19 P 2G, NE R Advisory committee reviews curriculum 20 Q 20, F S Advisory Committee reviews evaluation instruments 21 R 21P T Curriculum revisions based on advisory Committee input 22 S 1Q T Evaluation revisions based on advisory committee input 23 T 4R, S Conduct two pilot training courses 24 25 1) What is the time required to finish all your activities? 26 2) What activities are on the critical path? 27 3) If the standard deviation for finishing the project is 3 weeks, 28 what is the probability that this project could be done in 29 less than 29 weeks? 30 1) Answer 2) Answer 3)