Overview
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 4 weeks, what is the probability that this project could be done in less than 27 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.