Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Earned Value Method

12 replies [Last post]
Nitin Naik
User offline. Last seen 7 years 42 weeks ago. Offline
Joined: 1 Feb 2005
Posts: 27
Groups: None
Dear All,

I am looking for methods in demonstrating earned value comparison on a engineering/buildings project

Please share your experiences on this aspect of the project management.

I highly appreciate your inputs.

Nitin

Replies

Anand Kulkarni
User offline. Last seen 11 years 41 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 41
Groups: None
Good one Sonia,

Just will like to add a bit, then make excel file of total quantities & cost with respect to early dates,late date & actual.

Plot the same on graph which gives the over-all trend for the project.

First line shows trend with respect to early dates, 2nd with late date, 3rd actual & 4th forecast to complete which will be in reverse order.

And same way individual packages can be plotted.
Sonia Thomas
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 17 Nov 2004
Posts: 12
Groups: None
Hi,

Since many members requested me for details on Earned value analysis and Schedule Variance & Cost variance, let me put the details here.

Let me explain various terminologies first for those who are not familiar about them nad then how to do it in P3.
----------------------------------
Assume there is a budgeted cost of 10,000/- for a work. As of a specific date (data date), we planned to achive, say 50% progress. So we should have spent 5,000/- by the data date, according to the baseline schedule. So, this 5,000 is known as ’Planned value’ or BCWS (Budgeted cost of work scheduled).

But, assume that the actual progress (PCT) is only 25%. So, for this 25% progress we should spend only 2,500/-. This is the worth of work done or Earned value of the activity or BCWP (Budgeted cost of work performed.

Now, if the actual cost incurred on the activity so far is 4,000/-, we say 4,000/- is the actual cost or ACWP (actual cost of work performed.

Now ’schedule variance’ is the difference between earned value & planned value (BCWP - BCWS). This will show the monetary value of delay. In the above example, it will be
-2,500/- meaning, work is 2,500/- worth delayed.

Cost variance is the difference between Earned value and Actual value (BCWP - ACWP). This will show the cost over run. In the above example it is -1,500/- which means the loss is 1,500 on this work since we spent 40% cost for 25% work.

Schedule perfomance index is the ratio between Earned Value & Planned value (BCWP/BCWS) and Cost perfomance Index is the ratio between Earned value & actual value (BCWP/ACWP).

Now coming to P3..If there is cost loaded on activites, and there is a baseline (target) saved, P3 automatically gives Planned value, earned value, actual value, scheduled variance & cost variance. (actaul cost you may need
to manually record using ’cost window’ of activity, if it is different than earned value). So, getting this report is a matter of bringing the respective columns to the layout..

But P3 doesnt have CPI & SPIs. This we can get by use of custom data items & global change.

Trust the above information is useful.

regards
Sonia
Waseem Saber
User offline. Last seen 1 year 34 weeks ago. Offline
Joined: 1 Dec 2004
Posts: 63
Groups: None
hi sonia,

i would love to receive the details as you provided to nitin.

thanks my email:mohdwaseemsaber@yahoo.com

Nitin Naik
User offline. Last seen 7 years 42 weeks ago. Offline
Joined: 1 Feb 2005
Posts: 27
Groups: None
Hi Sonia,

My email address is naik_nitin@hotmail.com

thanks
Sonia Thomas
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 17 Nov 2004
Posts: 12
Groups: None
Nitin,

I got your message..give me your email ID to send details.
Nitin Naik
User offline. Last seen 7 years 42 weeks ago. Offline
Joined: 1 Feb 2005
Posts: 27
Groups: None
Dear All,

Thanks for the reply on the two queries on Earn Value Method and Forecasting methods

Highly appreciate your feedback.

Nitin
Gary France
User offline. Last seen 16 years 1 week ago. Offline
Joined: 18 Nov 2003
Posts: 137
Groups: None
Nitin,

There is a very good paper about "Controlling Construction Projects using Earned Value Analysis" on the Planning Engineers Organisation website, by Paul Kidston.

You will find it on this page....

Planning Engineers Organisation - Dissertation Papers

This might help you with your query.

Best wishes.

Gary France
Waseem Saber
User offline. Last seen 1 year 34 weeks ago. Offline
Joined: 1 Dec 2004
Posts: 63
Groups: None
HI,

i think i go with Jaco with regards to the usage of the EVA reports and i presume for the realtime planners the provided heirarchy by Jaco is good enough to take a leaf and built their trees,’

well presented Jaco keep it up

cheers
Jaco Stadler
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Well

Earned Value.

Two Type’s

Type 1 = Earned Value Fixed Budget
Type 2 = Earned Value variable Budget.
For Engineering Type project Earned Value Variable Budget is the easiast but it depends on your Contract Type.

6 Methods to Calculate Earned Value

1 = Units Complete
2 = Incremental Milestone
3 = Start Finish
4 = Supervisor Opinion
5 = Cost ratio
6 = Weighted or Equivalent Units

For Engineering Type of Projects I Prefer a Incremental Milestone Method Due to Revision of Dwg/Spec.

For Construction Weighted or Equivalent Units

I Hope this Helps.

PS If this looks like a text book answer you are 50 % right. If you require more info you can PP me or GET SKILLS & KNOWLEDGE OF COST ENGINEERING.

Cheers
Zubaer Shariff
User offline. Last seen 2 years 35 weeks ago. Offline
Joined: 17 Jan 2004
Posts: 12
Groups: None
The primary purpose to get earned value is to get to know value of work done. The accurcy of EV depends on how accurately you have loaded the cost by sudying distribution of project scope and quantities. After you obtain the EV, it is upto you and requirement of your company/client to analyse by comparing with planned value based on early or late dates, or make a forecast based on current trend or forecst if the trend does not continue. The most desired result is comparision with actual cost for each cost account.

-Zubaer
Sonia Thomas
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 17 Nov 2004
Posts: 12
Groups: None
Hi,

There is another type of comparison - compare ’earned value’ against ’Planned value’ and ’actual value’.

These comparative datas are 2 types - variances (Schedule variance & Cost variance) and Index (Schedule perfomance Index & Cost perfomance index).

If this is what u look for, and if u desire more info on these I can help u..
Anand Kulkarni
User offline. Last seen 11 years 41 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 41
Groups: None
Nitin,

Comparison of the earned value can done on Early dates, Late dates, Actual & Forecast to complete.

All the four curves plotted on single graph gives the best comparison for the project.