Earned Value
In the Open Standard
PR
Philip RichardsMember for 16 years 11 months
- Created
- 15
- 4
0
I am aiming to use the data from my MS project Plan to produce Earned Value information.
I understand that the Earned Value is derived by taking the % complete of each task, and applying it to the baseline cost of that task, and that at completion, EV = Total Baseline Value (you have earned 100% of your Budget)
I am worried however that during the project execution, tasks may be added &/or deleted from the current plan, causing discrepancies with the baseline, and therefore corrupting the EV figures.
Are there any basic rules I should follow to prevent this and any other possible pitfalls.
I understand that the Earned Value is derived by taking the % complete of each task, and applying it to the baseline cost of that task, and that at completion, EV = Total Baseline Value (you have earned 100% of your Budget)
I am worried however that during the project execution, tasks may be added &/or deleted from the current plan, causing discrepancies with the baseline, and therefore corrupting the EV figures.
Are there any basic rules I should follow to prevent this and any other possible pitfalls.
15 replies
Oldest first- 0TRTrevor Rabey ·Since BCWS and BCWP both come straight from the Baseline, anything not in the Baseline will not be included in the EV.
This is not corruption, just arithmetic.
The EV becomes progressively less meaingful, and more irrelevant, as the Baseline becomes more superseded, and that can happen pretty fast if there are a lot of changes. - 0PRPhilip Richards ·Thanks Trevor
But surely that is the whole point of Earned Value. To monitor progress against your original budget in terms of Time & Cost.
I understand that when a task is added, it will increase the cost (ACWP), but will earn no value (which is what we want to see)
But I’m not sure how to deal with tasks which are no longer needed. I think maybe to set its budget to zero, and mark it as complete. That way, its Actual cost is zero. It will have earned 100% of its budget (which doesn’t seem right, as no work has been done) & BCWS will have been maintained.
So I suggest:
Rule 1 Never delete a redundant task, but set its budget to zero and mark it as complete.
Any comments or further suggestions ? - 0TRTrevor Rabey ·I have to say that I am not all that fond of EV.
I don’t think it is all it is cracked up to be.
I don’t think that it is a very good measure of progress, but many people think it is.
I don’t think that the point of EV is all that well understood or appreciated.
What exactly is the "whole point of Earned Value".
You can earn value by doing the wrong tasks.
That is, EV makes no distinction between critical and non-critical.
It also supposes that reducing the mixed results of the progress of numerous tasks to 1 or 2 indicator numbers such as SPI and CPI actually means something. Do they, really?
Also, EV does not tell you what went wrong or what to do about it.
There is a lot to be said for your approach of not deleting the unwanted tasks, but at least if you delete the task you also delete its Baseline numbers as well.
But you can also leave the task in, and delete its duration, resource assignments, work, cost and its Baseline numbers (duration, work, cost) as well. The task disappears except for a remnant, an artifact. - 0PRPhilip Richards ·Earned Value doesn’t claim to be the be all and end all. Detailed analysis of the project plan (such as CPA, Resource loading etc) are fundamental in monitoring and controling the project execution.
What EV does give you is a high level overview, (usually for higher management who are not interestd in the nitty gritty) accross disciplins & functions, of project performance to date.
A 1 page EVA graph together with a 1 page CPA and maybe a 1 page Key Milestone status report will give higher management a good picture of the project performance - 0DKDavid Kelly ·**** EMERGENCY BULLETIN FROM THE EVA THOUGHT POLICE ****
Trevor,
< I don’t think it is all it is cracked up to be.
I don’t think that it is a very good measure of progress, but many people think it is.>>
All projects have a time, resource and cost budget. EVA does resource and cost, CPM/barcharts does time. So EVA is TWICE as useful as the baseline barchart for measuring progress
<>
Correct.
<>
To measure projects more accurately than CPM
<>
Yes of course BUT you always know EXACTLY what “wrong” work you have done
<>
Not really – schedule variance gives you a clue , but critical/non critical is really a CPM thing.
<>
Yes., they do, but from your comments above it is surely Scheduled variance you want most
<>
Your kidding me, you don’t REALLY think that, do you?
<>
And the cost engineer, contract analyst thinks what about deleting base scope?
- 0DKDavid Kelly ·Hope this reads better - a "preview" button would be good
Trevor : I have to say that I am not all that fond of EV.
I don’t think it is all it is cracked up to be.
I don’t think that it is a very good measure of progress, but many people think it is.>>
David : All projects have a time, resource and cost budget. EVA does resource and cost, CPM/barcharts does time. So EVA is TWICE as useful as the baseline barchart for measuring progress
Trevor : I don’t think that the point of EV is all that well understood or appreciated.
David : Correct.
Trevor : What exactly is the "whole point of Earned Value".
David :To measure projects more accurately than CPM
Trevor : You can earn value by doing the wrong tasks.
David : Yes of course BUT you always know EXACTLY what “wrong” work you have done
Trevor : That is, EV makes no distinction between critical and non-critical.
David : Not really – schedule variance gives you a clue , but critical/non critical is really a CPM thing.
Trevor : It also supposes that reducing the mixed results of the progress of numerous tasks to 1 or 2 indicator numbers such as SPI and CPI actually means something. Do they, really?
David : Yes., they do, but from your comments above it is surely Scheduled Variance you want most
Trevor : Also, EV does not tell you what went wrong or what to do about it?
David : Your kidding me, you don’t REALLY think that, do you?
Trevor : There is a lot to be said for your approach of not deleting the unwanted tasks, but at least if you delete the task you also delete its Baseline numbers as well.
David : And the cost engineer, contract analyst thinks what about deleting base scope?
- 0DKDarren Kosa ·Hi Phillip,
There may be others out there who disagree with me, but if you use MS Project for EV you’re on a hiding to nothing.
We tried to use 2k3 Professional (standalone not server) to provide for our EV reporting needs and it proved so inflexible that we ditched it after a couple of months. There were so many ways in which we found MS Project to be deficient, it would probably take me a week to go list them all. Suffice to say the biggest showstoppers were, in no particular order:
The only techniques you could use to claim EV is percentage complete, which is fine for LOE tasks, but not if you want to include discrete or apportioned effort in your schedule. The percentage complete method is subjective and MS Project didn’t measure EV as work accomplished, instead it only calculated BCWP using duration at the core of its calculation.
BCWP actually decreases when we increased the duration of a task in progress, in effect we were unclaiming EV which defied logic in my book.
As you mentioned in Post #1, rebaselining MS Project and then using it to report EV is like oil and water they don’t mix very well. We tended to end up checking and rechecking the baseline each time we wanted to report any performance data to make sure it had ’rolled-up’ correctly.
We couldn’t reconcile the EAC and VAC when sub-contractor milestones were part-paid, even though all the milestones at task level added up to the BAC they didn’t always have the same total at summary levels.
Actuals are a pain to input into the schedule if you use timesheets. Mapping between the timesheets and verbal progress is time consuming if you can’t auto-populate.
The EV report from MS Project is an absolute joke. We couldn’t run any cost performance reports on the WBS, OBS, Baseline, Resources and there weren’t any Variance reports either. We ended up exporting or cutting and pasting data into Excel which kind of defeats the purpose of holding a baseline in MS Project in the first place.
The schedule also started to take on the shape of a RAM and ceased to be a schedule that only showed deliverables or products in a project lifecycle. To report at different levels of granularity we had to structure the MS Project schedule so that we could report at WP, CA and project levels and that didn’t equate to an easily read project schedule that we could to use to communicate progress with.
Like I said I could go on, in the end we transferred the baseline into Excel, used the MS Project schedule for delivery and the spreadsheet to report on EV. We did look at using Deltek Cobra, but the cost was a little too prohibitive, it didn’t mesh that well with our timesheeting system and the business unit manager at the time didn’t want to fork out for it.
Drop me a line if you want to know else.
Regards,
Darren - 0TRTrevor Rabey ·Darren,
You know that I disagree with you.
The most obvious possibility, which is probably the one that you are probably least likely to consider, is that you have mis-understood something or have made cricial assumptions or have adopted conclusions which are wrong.
Just because you and you crew can’t do it doesn’t mean that it can’t be done or that MSP does not work. - 0DKDarren Kosa ·Trevor,
I’m quite happy to agree with you for the most part, I find MS Project, as a scheduling tool, is adequate enough to fulfil most requirements, however, an EV performance reporting suite it ain’t. If anyone wants to use it for that purpose whilst trying to maintain a lean schedule then good luck to them.
I don’t think it’s a question of us not being able to do it, it’s more that if you’re having to export data into Excel all the time just to report EV, then cut out the middle man and keep the baseline in Excel. No fuss, it keeps it simple and we found it reduced the maintenance overhead.
Regards,
Darren - 0SPScarllet Pimpernel ·Earned value EV used is only usedful if you have the same structure as that in US of America.
It is not useful if the project is to lure investors like what happen in some Middle East countries because it will expose all the anomalies in the projects from the early stage, so the client, the developer and others will not be able to squeeze more money from investors.
Thank you,
Scarlett - 0EMErnesto Montales ·Earned value is a good measure of the critical and specially the non critical activities on the programme based on cost or effort.. but the I think the major weakness of this tool is in the forecast. It is purely based on the current outputs. To balance this, we use CPM in conjuction with EVA.
- 0DKDarren Kosa ·Phillip,
It’s an issue that I alluded to earlier in this thread. Why on earth anyone would use Duration (% Complete), as the basis of all EV performance measurement on a project is beyond my comprehension.
Physical % Complete is the nearest thing you’ll get to Work % Complete, but you’ll have to manually enter the value each time you update the project schedule.
Regards,
Darren
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?