Download - Resource Scheduling Spcl
-
8/21/2019 Resource Scheduling Spcl
1/60
RESOURCE SCHEDULING INPROJECTS
Dr.K.ANANTHANARAYANAN
ASSOCIATE PROFESSOR
DEPARTMENT OF CIVIL ENGINEERING
IIT MADRAS,CHENNAI -600036
-
8/21/2019 Resource Scheduling Spcl
2/60
Start
WBS -WorkBreakdown
Network CPM
PERT, PDM
Resource Estimate
Analysis with
normal Time/Cost
Check with the specified
schedule
Time/cost
trade-off
ScheduledecidedResource Allocation
Check with Resource
availability
Execute
0k
Not ok
Ok
NOT OK
IMPLEMENTATION PLAN WITH NETWORK SYSTEM
-
8/21/2019 Resource Scheduling Spcl
3/60
-
8/21/2019 Resource Scheduling Spcl
4/60
Resource Scheduling
RESOURCE LEVELLING RESOURCE ALLOCATION
# Aims to deploy constant
rate of resources on each day
# To minimize day-to-day
fluctuations
# Aims to complete the
Project as soon as possible
# Optimal allocation of
resources to all activities
involved
-
8/21/2019 Resource Scheduling Spcl
5/60
RESOURCE LEVELING
TRIAL AND ERROR METHODGeneral method of Resource Leveling and enhancing knowledgeSelect a possible schedule - work out for time and cost constraintsif satisfied OK
If not satisfied ( Error ) try another possible schedule
MATHEMATICAL PROGRAMMINGChoosing the best from available alternatives through expressions
HEURISTICS METHOD
Experience based Rule of thumb like solutionA rapid way of getting solution that is hoped to be close to the bestEducated guess or common sense
-
8/21/2019 Resource Scheduling Spcl
6/60
TRIAL AND ERROR METHOD FOR
RESOURCE LEVELLING
Allocate the daily work force for the network schedulefor a maximum crew size of 13 workers per day. Lets nowlevel the labour requirements by following the rues:
Rule 1:The CPM logic must be maintained. This meansthat the preceding activity must be finished, not just in
progress, before a succeeding activity can start. Rule 2:Activities in the critical path must use normal crew
size. This is necessary so that the project will be completedon time.
Rule 3: The planned crew size must be between and
including, the maximum and normal crew sizes.NOTE:
Dont shift any resource in critical activities
For critical activities, both normal and minimum resource will be the same
For non critical activities, amount of resource should be between the normal and
minimum range but should be continuous
-
8/21/2019 Resource Scheduling Spcl
7/60
RESOURCE ALLOCATION
MODER AND PHILIPS METHOD
WIESTS METHOD
A NEW METHOD HAS BEEN DEVELOPED IN IITMADRAS
-
8/21/2019 Resource Scheduling Spcl
8/60
START
C - 6
B - 3
A - 5
F -10
E - 5
D - 5
END
Activity Start A B C D E F End
Duration 0 5 3 6 5 5 10
IPA Start Start Start A,B B C D,E,F
Relationship FS FS FS FS FS FS FS FS
-
8/21/2019 Resource Scheduling Spcl
9/60
AC
TIVITY
NORMAL
DU
RATION
RE
QUIRED
W
ORKER
DAYS CREW SIZE WORK DAYS
NORMAL MINIMUM1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 5 25 5 1 ( )
B 3 12 4 2 ( )
C 6 48 8 8 ( 8 8 8 8 8 8 )
D 5 30 6 3 ( )
E 5 20 4 2 ( )
F 10 40 4 4 ( 4 4 4 4 4 4 4 4 4 4 )
TOTAL =
175DAILY =
-
8/21/2019 Resource Scheduling Spcl
10/60
ACTIVITY
NOR
MAL
DURATION
REQUIRED
WORKER
DAYSCREW
SIZE WORK DAYS
NORMAL
MINIM
UM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 5 25 5 1 ( 3 3 3 3 3 5 5 )
B 3 12 4 2 ( 2 2 2 2 4 )
D 5 30 6 3 ( 5 5 5 5 5 5 )
E 5 20 4 2 ( 4 4 4 4 4 )
C 6 48 8 8 ( 8 8 8 8 8 8 )
F 10 40 4 4 ( 4 4 4 4 4 4 4 4 4 4 )TOTAL =
175
DAILY
= 8 11 13 13 13 13 13 13 13 13 13 13 9 9 4 4
-
8/21/2019 Resource Scheduling Spcl
11/60
-
8/21/2019 Resource Scheduling Spcl
12/60
ACTIVITY
NORMAL
DURATION
REQUIRED
WORKER
DAYS CREW
SIZE WORK DAYS
NORMAL
MINIM
UM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 5 25 5 1 ( 2 2 2 2 2 5 5 5 )
B 3 12 4 2 ( 2 2 2 3 3 )
D 5 30 6 3 ( 5 5 4 4 4 4 4 )
E 5 20 4 2 ( 3 3 3 3 3 3 2 )
C 6 48 8 8 ( 8 8 8 8 8 8 )
F 10 40 4 4 ( 4 4 4 4 4 4 4 4 4 4 )TOTAL =
175DAILY = 8 10 10 12 12 12 12 12 12 12 12 11 11 11 10 8
-
8/21/2019 Resource Scheduling Spcl
13/60
-
8/21/2019 Resource Scheduling Spcl
14/60
A
CTIVITY
NORMAL
D
URATION
R
EQUIRED
WORKER
DAYSCREW
SIZE WORK DAYS
NORMA
L
MINI
MUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 5 25 5 1 ( 1 1 1 1 1 5 5 5 )
B 3 12 4 2 (2 2 2 2 2 2 )
D 5 30 6 3 ( 5 5 5 5 5 5 )
E 5 20 4 2 ( 2 2 2 2 2 2 2 2 2 2 )
C 6 48 8 8 ( 8 8 8 8 8
8
)
F 10 40 4 4 ( 4 4 4 4 4 4 4 4 4 4 )
TOTAL =
175
DAILY
=10
-
8/21/2019 Resource Scheduling Spcl
15/60
-
8/21/2019 Resource Scheduling Spcl
16/60
ACTIVITY
NORMAL
DURATION
REQUIRED
WORKER
DAYS
CREW SIZE WORK DAYS
NORM
AL
MINIM
UM1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 5 25 5 1 (5 5 5 1 1 1 4 3 )
B 3 12 4 2 (4 4 4 4 4 4 )
C 6 48 8 8 ( 8 8 8 8 8 8)
D 5 30 6 3 (6 6 6 6 6 6 )
E 5 20 4 2 ( )
F 10 40 4 4 ( 4 4 4 4 4 4 4 4 4
4
)
TOTAL = 175 DAILY =17 17 17 17 17 18 14 14 10 10 4 4 4 4 4 4
Day 1 -4 413 17 17 21 17 18 14 14 10 10 4 4 4 4 4 4
Day 2 -4 4
13 17 21 21 18 14 14 10 10 4 4 4 4 4 4
Day 3 -4 4
13 21 21 22 14 14 10 10 4 4 4 4 4 4
Day 4 -8 4 4
13 21 26 14 14 14 10 4 4 4 4 4 4
Day 5 -8 4 4
13 26 18 14 14 14 4 4 4 4 4 4
Day 6 -13 3 10
13 18 17 14 14 14 4 4 4 4 4
Day 7 -6 6
12 17 14 14 14 10 4 4 4 4
Day 8 -6 6
11 14 14 14 10 10 4 4 4
Day 9 -2 2
12 14 14 12 10 4 4 4
Day 10 -2 2
12 14 12 12 4 4 4
-
8/21/2019 Resource Scheduling Spcl
17/60
BLOCK
WORK -
12
WINDOW
S
DOORS -4
PLASTERI
NG - 6
PAINTIN
G - 3
FLOORIN
G - 5
FINISH
START
Example 1
-
8/21/2019 Resource Scheduling Spcl
18/60
ACTIVIT
Y
normaldu
ration
REQUIRED
CRE
W
SIZE
WORK DAYS
WORKER
DAYS
NOR
MAL
MINI
MUM
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
BLOCK
WORK 12
12
0 10 10 10 10 10 10 10 10 10 10 10 10 10 10
WINDOW,D
OOR 4 28 7 4 (7 7 7 7 )
PLASTERIN
G 6 30 5 5 5 5 5 5 5 5
PAINTING 3 12 4 2 (4 4 4 )
FLOORING 5 20 4 4 4 4 4 4 4
TOT
AL =
152
DAIL
Y =10 10 10 10 10 10 10 10 10 10 10 10 12 12 12 12 5 5 8 8 8 4 4
-
8/21/2019 Resource Scheduling Spcl
19/60
ACTIVITY
normalduration
REQUIRED
WORKER
DAYS
CRE
WSIZE WORK DAYS
NOR
MAL
MINI
MUM
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
BLOCK
WORK 12 120 10 10 10 10 10 10 10 10 10 10 10 10 10 10
WINDOW,D
OOR 4 28 7 4 (7 7 7 7 )
PLASTERIN
G 6 30 5 5 5 5 5 5 5 5
PAINTING 3 12 4 2 (4 4 4 )
FLOORING 5 20 4 4 4 4 4 4 4
TOTAL =
210
DAIL
Y =10 10 10 10 10 10 10 10 10 10 10 10 12 12 12 12 5 5 8 8 8 4 4
-
8/21/2019 Resource Scheduling Spcl
20/60
-
8/21/2019 Resource Scheduling Spcl
21/60
ACTIVITY
normaldurationRE
QU
IRED
CREW
SIZE WORK DAYSWO
R
KER
DAYS
NO
RM
AL
MI
NI
M
U
M
1 2 3 4 5 6 7 8 91
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
2
3
BLOCK
WORK 12
12
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
WINDO
W,DOO
R 4
2
8 7 4 (4 4 4 4 4 4 4 )
PLAST
ERING 6
3
0 5 5 5 5 5 5 5 5
PAINTI
NG 3
1
2 4 2 (4 4 4 )
FLOOR2
-
8/21/2019 Resource Scheduling Spcl
22/60
-
8/21/2019 Resource Scheduling Spcl
23/60
Problem: Assume that there are no constraints in the resources
availability, prepare the resource loaded bar chart and resources
histogram for following cases:
a) Activities planned based on ES and EF
b) Activities planned based on LS and LFc) Resource leveling
A
4, 2
B
7, 4
E
4, 4
D
5, 5
F
10, 3
C
3, 6
Finish
G
6, 5
Start
-
8/21/2019 Resource Scheduling Spcl
24/60
Solution:
1) ES, EF, LS, LF, Total Float, Free Float, Project duration and Citical path
Start
0 0
0 0
A
4, 2
B
7, 4E
4, 4
D
5, 5
F
10, 3
C
3, 6
Finish
G
6, 5
0 4
4 7
7 12
0 7
7 11
12 22
11 17
22 22
22 22
12 22
7 12
0 7 16 22
12 16
9 12
3 70 / 0
0 / 0
0 / 0
0 / 0
0 / 0
5 / 0
5 / 5
3 / 0
5 / 5
Project duration22 days
Critical path: B-D-F
-
8/21/2019 Resource Scheduling Spcl
25/60
2. a) Resource loaded bar chart for activities planned based on ES and EF
Case 1: activities planned based on ES andEF
Resource loaded bar chart
Act D R FF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Critical activities
B 7 4 0 4 4 4 4 4 4 4
D 5 5 0 5 5 5 5 5
F 10 3 0 3 3 3 3 3 3 3 3 3 3
Non critical activities
A 4 2 0 2 2 2 2
C 3 6 5 6 6 6
E 4 4 0 4 4 4 4
G 6 5 5 5 5 5 5 5 5
Total resources 6 6 6 6 10 10 10 9 9 9 9 10 8 8 8 8 8 3 3 3 3 3
-
8/21/2019 Resource Scheduling Spcl
26/60
2.a) Resource histogram based for activities planned on ES and EF
0
2
4
6
8
10
12
1 2 3 4 5 6 7 8 9 10111213141516171819202122
-
8/21/2019 Resource Scheduling Spcl
27/60
2. a) Resource loaded bar chart for activities planned based on ES and EF after leveling
Case 1: activities planned based on ES and EF
Resource loaded bar chart
Act D R FF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Critical activities
B 7 4 0 4 4 4 4 4 4 4
D 5 5 0 5 5 5 5 5
F 10 3 0 3 3 3 3 3 3 3 3 3 3
Non critical activities
A 4 2 0 2 2 2 2
C 3 6 5 6 6 6
E 4 4 0 4 4 4 4
G 6 5 5 5 5 5 5 5 5
Total resources 6 6 6 6 10 10 10 9 9 9 9 5 3 3 3 3 8 8 8 8 8 8
-
8/21/2019 Resource Scheduling Spcl
28/60
2.a) Resource histogram based for activities planned on ES and EF after leveling
0
2
4
6
8
10
12
1 2 3 4 5 6 7 8 9 10111213141516171819202122
-
8/21/2019 Resource Scheduling Spcl
29/60
2. b) Resource loaded bar chart for activities planned based on LS and LF
Case 2: Activities planned based on LS and LF
Resource loaded bar chart
Act D R FF 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Critical activities
B 7 4 0 4 4 4 4 4 4 4D 5 5 0 5 5 5 5 5
F 10 3 0 3 3 3 3 3 3 3 3 3 3
Non critical activities
A 4 2 0 2 2 2 2
C 3 6 5 6 6 6
E 4 4 0 4 4 4 4
G 6 5 5 5 5 5 5 5 5
Total resources 4 4 4 6 6 6 6 5 5 11 11 11 7 7 7 7 8 8 8 8 8 8
-
8/21/2019 Resource Scheduling Spcl
30/60
2.b) Resource histogram based for activities planned on LS and LF
0
2
4
6
8
10
12
1 2 3 4 5 6 7 8 9 10111213141516171819202122
-
8/21/2019 Resource Scheduling Spcl
31/60
8
Dur 2
Res 3
7
Dur 6
Res 5
6
Dur 5
Res 6
5
Dur 4
Res 4
1Dur 4
Res 7
4
Dur 2
Res. 8
3Dur 3
Res 3
2Dur 6Res 4
-
8/21/2019 Resource Scheduling Spcl
32/60
-
8/21/2019 Resource Scheduling Spcl
33/60
ase studies
-
8/21/2019 Resource Scheduling Spcl
34/60
-
8/21/2019 Resource Scheduling Spcl
35/60
-
8/21/2019 Resource Scheduling Spcl
36/60
-
8/21/2019 Resource Scheduling Spcl
37/60
-
8/21/2019 Resource Scheduling Spcl
38/60
IIT hostel building
218 activities
8 types of resources
Application to large projects
-
8/21/2019 Resource Scheduling Spcl
39/60
-
8/21/2019 Resource Scheduling Spcl
40/60
-
8/21/2019 Resource Scheduling Spcl
41/60
-
8/21/2019 Resource Scheduling Spcl
42/60
-
8/21/2019 Resource Scheduling Spcl
43/60
-
8/21/2019 Resource Scheduling Spcl
44/60
RESOURCEALLOCATION
-
8/21/2019 Resource Scheduling Spcl
45/60
Resource Allocation
Act EDur 25 days
Act DDur4 days
Res 2 units
finish
Act B
Dur 10 days
Act C
Dur 10 days
Act A
Dur 10 days
Res 2 units
Start
Resource constraints :
Resource A: availability = 2 units only
-
8/21/2019 Resource Scheduling Spcl
46/60
START
B - 8
A - 6
E - 3
D - 6
C - 7
F - 4 END
CPM DIAGRAM WITH TASK RESOURCE
REQUIREMENTS
Example 1
-
8/21/2019 Resource Scheduling Spcl
47/60
NO RESOURCE CONSTRAINTS - PROJECT DURATION 16 DAYS
TASK
NO
I - N
NO
J - N
NO
DURA
TION TF RSC WORK DAYS
WD WD 1 2 1 2 3 4 5 6 7 8 91
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
2
3
2
4
2
5
A 2 4 6 0 2 5
B 2 6 8 1 4 0
C 4 10 7 3 3 2
D 4 8 6 0 2 2
E 6 8 3 1 5 3
F 8 10 4 0 2 4
TYPE 1 RESOURCE USED
6 6 6 6 6 6 9 9 10
10
10
5 5 2 2 2MAX DAILY USAGE = 10
TOTAL USAGE = 100 RD
TYPE 2 RESOURCE USED
5 5 5 5 5 5 4 4 7 7 7 4 6 4 4 4MAX DAILY USAGE = 7
TOTAL USAGE = 81 RD
Example 1
-
8/21/2019 Resource Scheduling Spcl
48/60
TWO CONSTRAINED RESOURCES - PRIORITY TO TASK WITH LOW NO J NODES -
PROJECT DURATION 22 DAYS
Taskno
I - Nno
J - Nno
DURA
TION
TF RSC WORK DAYS
WD WD 1 2 1 2 3 4 5 6 7 8 91
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
2
3
2
4
2
5
A 2 4 6 0 2 5
B 2 6 8 1 4 0
D 4 8 6 0 2 2
E 6 8 3 1 5 3
C 4 10 7 3 3 2
F 8 10 4 0 2 4
TYPE 1 RESOURCE USED
6 6 6 6 6 6 6 6 7 7 7 5 3 3 3 3 3 3 2 2 2 2MAX DAILY USAGE = 7
TOTAL USAGE = 100 RD
TYPE 2 RESOURCE USED
5 5 5 5 5 5 2 2 5 5 5 4 2 2 2 2 2 2 4 4 4 4MAX DAILY USAGE = 5
TOTAL USAGE = 81 RD
NOTE - MAX RESOURCE AVAILABLE --- ( RES 1: 7 ) ; RES ( 2: 5 )
PRIORITY TO TASK WITH LOWEST TOTAL FLOAT PROJECT
-
8/21/2019 Resource Scheduling Spcl
49/60
PRIORITY TO TASK WITH LOWEST TOTAL FLOAT - PROJECT
DURATION 23 DAYS
TAS
K
NO
I - N
NO
J - N
NO
DUR
ATIO
NWD
TF
WD
RESOUR
CEWORK DAYS
1 2 1 2 3 4 5 6 7 8 9 10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
A 2 4 6 0 2 5
D 4 8 6 0 2 2
F 8 10 4 0 2 4
B 2 6 8 1 4 0E 6 8 3 1 5 3
C 4 10 7 3 3 2
TYPE 1 RESOURCE USED
MAX DAILY USAGE = 7
TOTAL UAGE = 100 RD
6 6 6 6 6 6 6 6 7 7 7 2 2 2 2 2 3 3 3 3 3 3 3
TYPE 2 RESOURCE USED
MAX DAILY USAGE = 5
TOTAL USAGE = 81 RD
5 5 5 5 5 5 2 2 5 5 5 2 4 4 4 4 2 2 2 2 2 2 2
NOTE: MAX RESOURCE AVAILABLE: RES 1: 7 ; RES 2: 5
-
8/21/2019 Resource Scheduling Spcl
50/60
PRIORITY TO TASK WITH LOWEST TOTAL FLOAT - PROJECT
DURATION 23 DAYS
TASK
NO
I - N
NO
J - N
NO
DUR
ATIO
N
WD
TF
WD
RSC WORK DAYS
1 2 1 2 3 4 5 6 7 8 91
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
2
3
2
4
2
5
A 2 4 6 0 2 5
D 4 8 6 0 2 2
F 8 10 4 0 2 4
B 2 6 8 1 4 0
E 6 8 3 1 5 3
C 4 10 7 3 3 2
TYPE 1 RESOURCE USED
MAX DAILY USAGE = 7TOTAL USAGE = 100 RD
6 6 6 6 6 6 6 6 7 7 7 5 0 0 0 0 3 3 3 5 5 5 2
TYPE 2 RESOURCE USED
MAX DAILY USAGE = 5
TOTAL USAGE = 81 RD
5 5 5 5 5 5 2 2 5 5 5 4 0 0 0 0 2 2 2 6 6 6 4
NOTE: MAX RESOURCE AVAILABLE: RES 1: 7 ; RES 2: 5
-
8/21/2019 Resource Scheduling Spcl
51/60
-
8/21/2019 Resource Scheduling Spcl
52/60
Multipleproject Resource Allocation
Resource that become surplus in one
project are transferred to other projects inthe organization.
-
8/21/2019 Resource Scheduling Spcl
53/60
The key to multi project resourceallocation lies in linking all the keyindividual projects with one initial and one
terminal event.
http://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://c/Documents%20and%20Settings/admin/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/G9ZEL3L0/Example%204%20-%20Multiple%20resource%20allocation.xls -
8/21/2019 Resource Scheduling Spcl
54/60
Project Alpha 12 14 20
1 3 9
A 2A B 4A C1 5A D 24
B B 6 C 4 C 12
1A 9A
0 3 7 12 18
E1 3 F1 7 G1 12 H1 1B I13 2A 3A 4 2A 6A 3 B 7A 6 C 8A 6 C
3 25
3 25
0
Project Beta
21 B2 3B C2
13 2 B 4 2A
A2 D2 23 25 293 C 2B 2 B 23 G2 25 H2 29
1B 1B 1B 5B 2 0 6B 4 B 7B 11
10 E2 4B F2 40
10 8 2A 5 B 40
12
7 C
0
Project Gamma
28
18
B3 3C C3 6C D3
3 A 1 B 3 2A
12 31 40
12 31 40
1C A3 2C E3 7C 13 8C
10 2 B 1 2B 9 A
10
F3 4C G3 5C H3
4 A 7 B 8 B16 23
23 23
0
S
0
10
T
http://c/Documents%20and%20Settings/admin/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/G9ZEL3L0/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://c/Documents%20and%20Settings/admin/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/G9ZEL3L0/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://c/Documents%20and%20Settings/admin/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/G9ZEL3L0/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://localhost/var/www/apps/conversion/tmp/scratch_10/Example%204%20-%20Multiple%20resource%20allocation.xlshttp://c/Documents%20and%20Settings/admin/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/G9ZEL3L0/Example%204%20-%20Multiple%20resource%20allocation.xls -
8/21/2019 Resource Scheduling Spcl
55/60
THANK YOU
-
8/21/2019 Resource Scheduling Spcl
56/60
STARTA -4
C - 3
D - 2
B - 8
F - 5
E - 7
G - 2 FINISH
Example 2
Y L N D R
-
8/21/2019 Resource Scheduling Spcl
57/60
ACTIVITY
NORMAL
DURATION
REQUIRED
WORKER
DAYSCREW SIZE WORK DAYS
NORMAL MINIMUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
A 4 20 5 5 (5 5 5 5 )
B 8 32 4 4 (4 4 4 4 4 4 4 4)
C 3 24 8 4 (5 5 5 5 4 )
D 2 12 6 3 (3 3 3 3 )
E 7 28 4 4 (4 4 4 4 4 4 4)
F 5 20 4 2 ( 2 2 2 2 4 4 4 )
G 2 16 8 8 (8 8)TOTAL =
152DAILY =
5 5 5 5 12 12 12 12 10 6 6 6 8 8 8 4 4 4 4 8 8
Y L ON D R
-
8/21/2019 Resource Scheduling Spcl
58/60
ACTIVITY
NORMAL
DURATIO
REQUIRE
WORKER
DAYSCREW SIZE WORK DAYS
NORMAL MINIMUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
A 4 20 5 5 (5 5 5 5 )
B 8 32 4 4 (4 4 4 4 4 4 4 4)
C 3 24 8 4 ( 5 5 5 5 4 )
D 2 12 6 3 ( 3 3 3 3 )
E 7 28 4 4 (4 4 4 4 4 4 4)
F 5 20 4 2 ( 2 2 2 2 2 2 2 2 2 2)
G 2 16 8 8 (8 8)TOTAL =
152DAILY =
5 5 5 5 4 7 7 12 12 11 11 10 6 6 6 6 6 6 6 8 8
Y L ON
ED R
-
8/21/2019 Resource Scheduling Spcl
59/60
ACTIVITY
NORMAL
DURATIO
REQUIRE
WORKER
DAYSCREW SIZE WORK DAYS
NORMAL MINIMUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
A 4 20 5 5 (5 5 5 5 )
B 8 32 4 4 (4 4 4 4 4 4 4 4)
C 3 24 8 4 ( 8 8 8 )
D 2 12 6 3 ( 6 6)
E 7 28 4 4 (4 4 4 4 4 4 4)
F 5 20 4 2 ( 5 5 5 5)
G 2 16 8 8 (8 8)TOTAL =
152DAILY =
5 5 5 5 4 4 4 4 4 12 12 12 10 10 4 9 9 9 9 8 8
Y L ON
ED R
-
8/21/2019 Resource Scheduling Spcl
60/60
ACTIVITY
NORMAL
DURATIO
REQUIRE
WORKE
DAYSCREW SIZE WORK DAYS
NORMAL MINIMUM 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
A 4 20 5 5 (5 5 5 5 )
B 8 32 4 4 (4 4 4 4 4 4 4 4)
C 3 24 8 4 (4 4 4 4 4 4 )
D 2 12 6 3 ( 3 3 3 3)
E 7 28 4 4 (4 4 4 4 4 4 4)
F 5 20 4 2 ( 3 3 4 5 5)
G 2 16 8 8 (8 8)TOTAL =
152DAILY =
5 5 5 5 8 8 8 8 8 8 7 7 7 7 7 7 8 9 9 8 8