Assignment:
Resource Scheduling Problems
Do all of your work and answer all the questions in an Excel file.
The following information has been developed to manage a computer project
|
Activity
|
Predecessor
|
Duration weeks
|
Resource units required
|
|
Start
|
-
|
0
|
0
|
|
A
|
Start
|
5
|
6
|
|
B
|
A
|
4
|
2
|
|
C
|
A
|
5
|
4
|
|
D
|
A
|
6
|
3
|
|
E
|
B
|
6
|
3
|
|
F
|
C
|
6
|
2
|
|
G
|
D
|
4
|
4
|
|
H
|
E, F
|
7
|
3
|
|
I
|
G
|
5
|
4
|
|
J
|
G
|
3
|
2
|
|
K
|
H. I, J
|
5
|
5
|
|
End
|
K
|
0
|
0
|
a. Draw the network and determine the ES, LS, EF, LF, and slack for each activity and the total project time.
b. Draw a Gantt chart for the network using the ES times for each activity
c. Draw a resource loading profile.
d. What is the maximum number of resource units needed?
e. What is the utilization percent?
f. Use the resource leveling technique - leveling within slack - to determine how the project can be done with fewer resources in the same amount of time. Draw a revised Gantt chart and resource loading profile for your solution.
g. What is the utilization percent now?
Provide complete and step by step solution for the question and show calculations and use formulas.