6:Resource -Leveled Gantt Chart
Assuming that one worker is required for each activity, prepare a resource-leveled schedule. What is the maximum number of workers required to finish the project on time? Show all work and provide a completed Gantt chart using Excel.
7: CPM NETWORK ANALYSIS
Given the data in the table below, perform a critical path analysis to determine the project's critical path. Draw a AON project network diagram for the project. Identify all of the possible paths, duration of each path, and identify the critical path. Calculate and indicate the ES/EF schedule, LS/LF schedule, and slack. Show all work and provide a completed Gantt chart of the CPM Network Analysis. Note: Use the drawing tool in Word, Excel or PowerPoint to draw the diagram. Use Excel to create a Gantt chart.
|
Activity
|
Duration
|
Predecessor(s)
|
|
A
|
3 weeks
|
--
|
|
B
|
15 weeks
|
A
|
|
C
|
5 weeks
|
B
|
|
D
|
3 weeks
|
C
|
|
E
|
6 weeks
|
B
|
|
F
|
4 weeks
|
E
|
|
G
|
2 weeks
|
D, F
|
8: PERT ANALYSIS
Using the following data values for minimum expected activity durations and maximum expected activity durations, provide a PERT analysis of the network analysis given in question 7. Include all calculations and show all work.
|
Activity
|
Minimum Duration
|
Maximum Duration
|
|
A
|
2
|
4
|
|
B
|
12
|
18
|
|
C
|
3
|
7
|
|
D
|
2
|
4
|
|
E
|
4
|
8
|
|
F
|
3
|
5
|
|
G
|
1
|
3
|