Resource Leveling

1. Resource Leveling Exercise
Given below is the information about the IT project we discussed in our Lesson 5 commentary under Resource Leveling. Also given below is the current resource loading Gantt chart along with a histogram. Now, have a close look at figures given below and using the concept of resource leveling, determine the flaws in this resource schedule, write down the disadvantages of such resource loading, and develop a more leveled schedule. For your ready reference, an Excel sheet (ResourceLevelingExercise.xls) is provided to complete this exercise.
Activity ID Predecessor Duration Number of People
needed per week
A – 3 7
B – 2 9
C – 2 12
D – 2 6
E B 2 11
F C 6 5
G D 3 5
H E,F 3 2
Submission: You must submit your answers to this exercise in the form of a single word document. You may cut and paste your excel work on this word document. Name your file as: LastName_FirstName_ResourceLevelingExercise.docx
Submit exercise in the Resource Leveling Exercise drop box.
2. Crashing Projects Exercise
Given below is the information for the IT project we discussed in our Week 5 commentary and its network diagram. In the Week 5 commentary, we crashed the project by three days, i.e., from 20 to 17 days by crashing Activity C for two days and Activity F by a day. Now proceeding from here:
Activity ID Predecessor Normal Time
(Days) Crash Time
(Days) Normal Cost Crash Cost
($’000) ($’000)
A – 5 2 $100 $205
B – 6 3 $140 $205
C – 7 5 $140 $200
D A, B 6 2 $100 $340
E C 3 1 $120 $200
F C 8 5 $580 $700
G D, E, F 5 3 $400 $660
Note: A “fully crashed schedule” means a project that has been crashed until the cost of crashing exceeds the marginal gain associated with eliminating overhead cost (which is $100,000 per day for this project).
o Continue crashing the project until the cost of crashing exceeds the marginal gain associated with eliminating overhead cost ($100,000 per day).
o Assume you have begun the project under the fully crashed schedule and you are now at the end of Day 6. Tasks A and C are finished, but Task B will require two more days of work. What corrective crashing decisions might you make to increase the likelihood that you can complete the schedule within the remaining 14 days? Are there any tasks you might consider uncrashing? What other actions could you consider?
Submission: You must submit your answers to this exercise in the form of a single word document. You may cut and paste your excel work on this word document. Name your file as: LastName_FirstName_CrashingProjectExercise.docx