Time Estimate in weeks 4 1 Activity A B D E F G H I J K L M N o Q R S T 2 1 0 0 7 4 2 2 3 4 2 12 3 2 2 5 1 4 DIRECTIONS Use the data provided to fill in the Template worksheet attached. Show formulas. Email your spreadsheet through Moodle. You are asked to be the project team leader assigned to design a new management training course in your organization. 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. 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. 1) What is the time required to finish all your activities? 2) What activities are on the critical path? 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? Assume the times given were derived from a triple time estimate and therefore standard deviation is relevant Note there are 2 dummy activities, E & F. A dummy activity is used to show predecessors but no resources or time is involved. Your name goes here ----> EF ES LF Finish Time LS Start Time Slack or Float Enter formulas in yellow section Activity A B D G H H WLUI-ZYJEZOLO Time Estimate Predecessors Successors Description 4 none DE Track literature on evaluation 1 none G Set up steering committee 2 none H,I,J Develop needs assessment questionnaire 6A F Develop reaction evaluation instrument O, P Dummy activity OID Q Dummy activity 7B O, P O Meet with advisory committee to discuss curriculum 4c 41C Conduct needs assessment in first division 71C L Conduct needs assessment in second division 20 M M Conduct needs assessment in third division 3H N Analyze data and develop cases and exercise 41 N Analyze data and develop cases and exercise 23 N Analyze data and develop cases and exercise 12 K, L, M OP Develop first draft of curriculum 3G, N, E Q Q Develop behavior evaluation instrument GN, E R Advisory Committee reviews curriculum 20, F s Advisory Committee reviews evaluation instruments 2P T Curriculum revisions based on advisory Committee input 10 T Evaluation revisions based on advisory committee input 4R, S Conduct two pilot training courses K . M IN lo 1) What is the time required to finish all your activities? 2) What activities are on the critical path? 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? 1) Answer 2) Answer 3)