Earned Value Cost Indicator View/Sheet

L

Lee

Good Morning!

After I select the Earned Value Cost Indicator View/Sheet option from the
drop down (from "more tables") I see a variety of earned value columns.

We all know that:EV-AC = VC
for example (EV)75,000 - (AC)125,000 = -50,000. This means a cost overrun.

But when I calculate Earned Value(BCWP) - Actual Cost, the CV does not give
me the number that I expect.

Can anyone inlighten me?
 
R

Rod Gill

You're going to have to look at the source data - work, actual work baseline
work etc, read help for each column and manually calculate values based on
formula described in help to see what's going on.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




Lee said:
Good Morning!

After I select the Earned Value Cost Indicator View/Sheet option from the
drop down (from "more tables") I see a variety of earned value columns.

We all know that:EV-AC = VC
for example (EV)75,000 - (AC)125,000 = -50,000. This means a cost overrun.

But when I calculate Earned Value(BCWP) - Actual Cost, the CV does not
give
me the number that I expect.

Can anyone inlighten me?



__________ Information from ESET Smart Security, version of virus
signature database 5048 (20100421) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5048 (20100421) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
L

Lee

Hi Rod,

Thank you for helping. Below is what I see in the two of the columns on the
sheet.

What I see in MS is:

EV/ (BCWP) Column
1,150.00

Actual Cost Column
7,750.00

CV Column
$3,429.55

CV% Column
-298%

The standard formula for CV below does not give me what MS Project gives me
as CV that you see above. What I get is:
(EV)1,150.00 - (AC)7,750.00 = (CV)6,600.00

Therefore I can not explain what MS Project is doing the management. Can you
help please? What do you think?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top