Question 1 (20 points)

In the following table, the project activity durations are given in weeks along with their predecessor relationships. For example, activity A can start anytime, as it does not have any predecessor. But activity B can start only when activity A is complete; so is activity C. Use Microsoft Excel for answering the following questions.

ActivityDurationPredecessorA4NoneB6AC4AD2CE4BF5B, DG3CH4F, GI2E, H

a) Construct the network diagram. Hint: Refer to the CPM tutorial on excel. (5 points)

b) Find each activity's ES, EF, LS, and LF. Calculate the slack for each activity. List them in the following table. Hint: Refer to Video #3. (5 points)

ActivityESEFLSLFSlackA B C D E F G H I

c) Identify all project paths with their duration. Which path is the critical path? Fill in the following table. Add more cells if needed. (5 points)

PathDurationCritical? (Yes/No)

d) How long will it take to complete the project? (5 points)