4. Given the following data, perform a critical path analysis in Excel to determine the project’s critical path. Your spreadsheet should indicate the early start schedule, late start schedule, and slack.



Draw a network diagram for the project described in question 4.

Draw a network diagram for the project described in question 4.

Using the provided data values for minimum expected activity durations and maximum expected activity durations, use Excel to provide a PERT analysis of the project given in question 4. Include all calculations and formulas.

Activity Duration Predecessors A 3 weeks B 15 weeks A C 5 weeks D 3 weeks E 6 weeks F 4 weeks E G 2 weeks D, F