22 Earned Value PDF
22 Earned Value PDF
22 Earned Value PDF
Monitoring
Dr. Ashwin Mahalingam
Planning Levels
Master Plan
Macro Plan
Micro Plan
Execution
Monitoring Levels
Master Plan
Monthly Reports &
EVM Parameters.
Macro Plan
Micro Plan
Weekly Reports
& Activity Targets
Productivity Trends
Daily Progress Reports
Productivity Measurement
& Improvement
Execution
Schedule Updating
1. Schedule durations and sequences often vary
from actual durations and sequences
2.
More on updates
Schedules should be updated periodically
Especially if a major event such as a logic
change occurs
Percentage Complete
3
A 3
B (4)6
3
8
D 2
9
9
0
0
Finish
E 3
Start
0
F (3)4
3
9
7
6
8
C 2
7 1 9
Project Monitoring
Project Monitoring
This graph shows Project Progress
Time over-run
Cost
Ideal
Curve
Time
At 8 Weeks
14
ANSWER
Week 02 Bad ?
Week 08 Good ?
In this case ?
160
RR
140
CSK
120
Optimistic ?!
100
80
60
40
20
0
0
9 10 11 12 13 14 15 16 17 18 19 20
Example -2.1
What is % Complete of this
Piping Package
Activity
Total Est.
Qty (M)
Qty
In-place (M)
% Complete
Small Bore
Piping
1063
197
Large bore
piping
10,000
701
Total Piping
Example -2.2
What is % Complete of this
Piping Package
Activity
Total Est.
Qty (M)
Qty
In-place
(M)
Est.
Man
Hours
Mhrs
Act.
Man
Hours
%
Complete
Small Bore
Piping
1063
197
1,350
300
Large bore
piping
10,000
701
10,200
1000
Total Piping
18
Example-2.3
What is % Complete of this
Piping Package
Activity
Total
Est. Qty
(M)
Qty
Inplace
(M)
Planned
Rate
Mhr/M
Est.
Man
Hours
Mhrs
Act.
Man
Hours
%
Complete
Small
Bore
Piping
1063
197
1.27
1,350
300
Large
bore
piping
10,000
701
1.02
10,200
1000
Total
Piping
19
Example -2.4
What is % Complete of this
Piping Package
Activity
Total
Est. Qty
(M)
Qty
Inplace
(M)
Planned
Rate
Mhr/M
Est.
Man
Hours
Mhrs
Small
Bore
Piping
1063
197
1.27
1,350
Large
bore
piping
10,000
Total
Piping
701
1.02
10,200
11,550
Earned
%
Manhours Complete
Mhr
197*1.27
=250
701*1.02
=715
250+715
=965
?
20
Example -2.4
What is % Complete of this
Piping Package
Activity
Total
Est. Qty
(M)
Qty
Inplace
(M)
Planned
Rate
Mhr/M
Est.
Man
Hours
Mhrs
Small
Bore
Piping
1063
197
1.27
1,350
197*1.27
=250
250/1350
=18.5%
Large
bore
piping
10,000
701
1.02
10,200
701*1.02
=715
715/10,200
=7.0%
Total
Piping
250+715
=965
965/11550
11,550
Questions & Comments ?
Earned
%
Manhours Complete
Mhr
=8.4%
21
Earned Value
Process
Planning Phase
1. Establish the Work Breakdown Str. (WBS)
2. Identify the activities to be scheduled within
WBS.
3. Allocate resources to be expended on each
activity, calculate costs
4. Schedule the activities over time. Level
resources- Plot relevant S curve.
5. Confirm that the plan is acceptable.
Effort expended
Plastering = 50%, Painting = 50% effort
3 walls plastered, two painted out of 4 walls
Percentage complete = (3x0.5+2x0.5)/4 = 62.5%
Expert opinion
Amount spent
Time taken (?)
http://www.iceincusa.com/16CSP/content/4_ev/gifs/image1.gif (17.01.2007)
Example 1
Example 1
700 (man-hours)
Excavation
5000
5000 (money)
500
800 (man-hours)
Transportation
10000
70000 (money)
Example 1
700 (man-hours)
Excavation
5000
5000 (money)
500
800 (man-hours)
Transportation
10000
7000 (money)
Daily Cumulative
300
1200
800
Total Cumulative
300
1500
2300
% Complete
300
2300
1200
2300
300
2300
= 0.13
= 0.65
= 1.0
Example 1
700 (man-hours)
Excavation
5000
5000 (money)
500
800 (man-hours)
Transportation
10000
10000 (money)
Daily Cumulative
5000
15000
7000
Total Cumulative
5000
20000
27000
5000
27000
20000
27000
90000
27000
= 0.185
= 0.741
= 1.0
% Complete
Percentage
Example 1
Stages
Example 1
BCWS Man-hours
Stages
Total
Excavation
300
700
1000
Transportation
500
800
1300
Stage Total
300
1200
800
Cumulative Total
300
1500
2300
Project % Complete
0.13
0.65
1.0
2300
Example 1
BCWS Money
Stages
Total
Excavation
5000
5000
10000
Transportation
10000
7000
17000
Stage Total
5000
15000
7000
Cumulative Total
5000
20000
27000
Project % Complete
0.185
0.741
1.0
27000
Example 1
Excavation
300
Transportation
700
500
800
0.95
1.0
0.6
0.95
% Complete
Excavation
Transportation
0.25
scheduled
Example 1
Determination of Earned Value of Man-hour.
Stage 1:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 2300
Example 1
Determination of Earned Value of Man-hour.
Stage 2:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 2300
Example 1
Determination of Earned Value of Man-hour.
Stage 3:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 2300
Example 1
Excavation
250
700
300
700
50
Man-hours
Earned Value
Transportation
780
455
500
800
0.95
1.0
0.6
0.95
0.752
0.971
% Complete
Excavation
0.25
Transportation
Project - % Complete
0.108
Man-hours
(man-hours)
scheduled
Example 1
BCWP
Stages
Excavation
Transportation
0.25
0
0.95
0.6
1.0
0.95
Excavation
Transportation
Stage total
250
0
250
700
780
1480
50
455
505
Excavation (cum)
Transportation
(cum)
250
0
950
780
1000
1235
250
1730
2235
0.109
0.752
0.972
% complete
Total cumulative
Project % complete
Example 1
Excavation
400
500
300
700
100
Man-hours
Actual
Transportation
450
1000
500
800
Man-hours
(man-hours)
scheduled
Example 1
Stages
Excavation
Transportation
400
0
500
450
100
1000
Stage Total
400
950
1100
Cumulative Total
400
1350
2450
Example 1
Stage 2
Stage 3
BCWS
SCHEDULED MAN-HOUR
(Cumulative)
300
1500
2300
BCWP
EARNED MAN-HOUR
(Cumulative)
250
1730
2235
ACWP
ACTUAL MAN-HOUR
(Cumulative)
400
1350
2450
SV
BCWP-BCWS
-50
230
-65
CV
BCWP-ACWP
-150
380
-215
SPI
BCWP/BCWS
0.83
1.15
0.97
CPI
BCWP/ACWP
0.63
1.28
0.9122
Example 1
Determination of Earned Value of Man-hour:
Earned Value
Man-hour
Stages
Example 1
Excavation
5000
Transportation
5000
10000
7000
0.95
1.0
0.6
0.95
% Complete
Excavation
Transportation
0.25
scheduled
Example 1
Determination of Earned Value of Money.
Stage 1:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 27000
Example 1
Determination of Earned Value of Money.
Stage 2:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 27000
Example 1
Determination of Earned Value of Money.
Stage 3:
EMh (Excavation)
EMh (Transportation)
% complete of project:
Total Man-hours = 27000
Example 1
Excavation
2500
7000
5000
5000
500
Money
Earned Value
Transportation
10200
5950
10000
7000
0.95
1.0
0.6
0.95
0.730
0.969
% Complete
Excavation
0.25
Transportation
Project - % Complete
0.093
Money
(money)
scheduled
Example 1
BCWP
Stages
Excavation
Transportation
0.25
0
0.95
0.6
1.0
0.95
Excavation
Transportation
Stage total
2500
0
2500
7000
10200
17200
500
5950
6450
Excavation (cum)
Transportation
(cum)
2500
0
9500
10200
10000
16150
Total cumulative
2500
19700
26150
Project % complete
0.093
0.730
0.969
% complete
Example 1
Excavation
4500
6000
5000
5000
5000
Money
Actual
Transportation
8500
7500
10000
7000
Money
(money)
scheduled
Example 1
Stages
Excavation
Transportation
4500
0
6000
8500
5000
7500
Stage Total
4500
14500
12500
Cumulative Total
4500
19000
31500
Example 1
Stage 2
Stage 3
BCWS
SCHEDULED MONEY
(Cumulative)
5000
20000
27000
BCWP
EARNED MONEY
(Cumulative)
2500
19700
26150
ACWP
ACTUAL MONEY
(Cumulative)
4500
19000
31500
SV
BCWP-BCWS
-2500
-300
-850
CV
BCWP-ACWP
-2500
700
-5350
SPI
BCWP/BCWS
0.5
0.99
0.97
CPI
BCWP/ACWP
0.56
1.04
0.83
Example 1
Determination of Earned Value of Money.
Earned Value
Money
Stages
Thank You