Understand the earn value

[alex]

Hi,

Context:

Understand the earn value and use it. Be sure the data are correct before
to propose to project manager.

Issue:

I find several informations on office online and other place.

To clarify the fields:

Travail réel is equal to actual work.
Coût réel is equal to actual cost.
Coût is equal to cost.
Travail planifié is equal to baseline work.

So I try to analyse line after line for the first column:
I add my question inside the tab below the pictures.

You can find more details on this link below
http://docs.google.com/Doc?id=dgq4sw2r_2072t6k76z34

I appreciate any comments.

I use this document to help me to understand
http://www.tutorialspoint.com/earn_value_management/evm_elements.htm

Best regards,
Alexandre BARAULT

 

[Jim Aksel]

Try reading "Earned Value Project Management" by Quintin Flemming

 

[alex]

Hi,

Thank you Julie and Jim.

Jim, I find your book on my business repository books24x7 so I can read it.
thank you.

Julie
".... So, the 59% complete is incorrect for a status date of 4/8.
It appears as though you have actual work recorded beyond the status
date. Try setting your status date to the last date where you have
actual work recorded. " => Why should I do that, I can do a status of my
project to another date (not the last date where I have actual work
recorded). I change it but I dont see any change.

I update the document agree with your remarks.

I think I should add some details.
I understand why ear value it's usefull. I don't search an explanation about
what is it or something like that.

But I don't understand how the system calculated some data, I recorded the
datas in a board, you can find on my link google doc
http://docs.google.com/View?docid=dgq4sw2r_2072t6k76z34




Best regads,
Alexandre BARAULT

 

[JulieS]

Hello Alex,

You're question about the CBTE as compared to 59% complete is I
think where your confusion lies. The 59% complete is based upon the
actual duration you have recorded to the status date. At the
timeframe you are referring to (CBTE at the end of week 1), you
cannot be 59% complete. You have completed 1 week out of a total of
4 weeks. From help:

"The BCWP (budgeted cost of work performed) fields contain the
cumulative values of the task's resource's or assignment's percent
complete multiplied by the timephased baseline cost. It is also
known as earned value."

So at the end of week1 you should be 25% complete of a four week
task. From your values it appears as though you were slightly less
than 25% complete. Although it's difficult to determine from the
level of detail (weekly) that you are showing.

You're questions about CV% -- you show a value of -.02503 -- that
is -2%.

I hope this helps.

Julie

 

[alex]

Hello Alex,
You're question about the CBTE as compared to 59% complete is I
think where your confusion lies. The 59% complete is based upon the
actual duration you have recorded to the status date. At the
timeframe you are referring to (CBTE at the end of week 1), you
cannot be 59% complete. You have completed 1 week out of a total of
4 weeks. From help:

"The BCWP (budgeted cost of work performed) fields contain the
cumulative values of the task's resource's or assignment's percent
complete multiplied by the timephased baseline cost. It is also
known as earned value."

So at the end of week1 you should be 25% complete of a four week
task. From your values it appears as though you were slightly less
than 25% complete. Although it's difficult to determine from the
level of detail (weekly) that you are showing.
You're questions about CV% -- you show a value of -.02503 -- that
is -2%.
I hope this helps.

 

[JulieS]

Hello Alex,

It appears as though at some time the duration of the task was
extended from 20 days to 20.5 days. Try adding the Percent Complete
to the timescaled (right side) of the view and that may help.

Yes, Project rounds values, so apparently the -0.2503 is rounded
to -2%.

Julie

 

[alex]

Hello Alex,
It appears as though at some time the duration of the task was
extended from 20 days to 20.5 days. Try adding the Percent Complete
to the timescaled (right side) of the view and that may help.
The BCWP (budgeted cost of work performed) fields contain the
cumulative values of the task's resource's or assignment's percent
complete multiplied by the timephased baseline cost. It is also
known as earned value

Yes, Project rounds values, so apparently the -0.2503 is rounded
to -2%.

 

[JulieS]

Alex,

In Line.

Hello Alex,

[Julie] You're welcome Alex.

It appears as though at some time the duration of the task was
extended from 20 days to 20.5 days. Try adding the Percent
Complete
to the timescaled (right side) of the view and that may help.

[Julie] In the screen capture I see a duration of 20.5 jours. Not
20. After week 1 you are not 25% complete -- you are 24% complete.

 

[alex]

Hi,

Thank you for your answer.
I don't really understand how to obtain the same value for EV.
because if I take the first day, the % complete is 5%. so the baseline work
is 4 hours. The work is 4 and the actual work is 4.

My point of view is to do 4*20=80 but its' wrong because Project doesn't
propose this value.
I should obtain 78.03. How Microsoft Project can obtain this value?

Best regards,
Alexandre BARAULT

Alex,

In Line.

Hello Alex,

[Julie] You're welcome Alex.

It appears as though at some time the duration of the task was
extended from 20 days to 20.5 days. Try adding the Percent
Complete
to the timescaled (right side) of the view and that may help.

[Julie] In the screen capture I see a duration of 20.5 jours. Not
20. After week 1 you are not 25% complete -- you are 24% complete.

The BCWP (budgeted cost of work performed) fields contain the
cumulative values of the task's resource's or assignment's percent
complete multiplied by the timephased baseline cost. It is also
known as earned value


Yes, Project rounds values, so apparently the -0.2503 is rounded
to -2%.