Estimate at Competion

[verossa]

Hi All

What formula does MS Project use to calculate the EAC for each task? I can't find anything in the help

TIA
Vers

 

[Gérard Ducouret]

Hi,

EAC = ACWP + (BAC - BCWP) / CPI
Where CPI = Cost Performance Index.
MS Project measures the actual drift in costs, but nastily, it assumes you
will drift more. So it multiplies the actual drift by the CPI.

Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris

Hi All,

What formula does MS Project use to calculate the EAC for each task? I

can't find anything in the help.

 

[JulieS]

Hi Verossa,
In Project 2003/2002:
In previous versions of Microsoft Project, EAC was
equivalent to the scheduled Cost field. However, now EAC
is calculated as:

EAC = ACWP + (Baseline cost X - BCWP) / CPI

When a task is created, resources are assigned, and a
baseline saved, EAC is the same as scheduled cost, which
is the total work value multiplied by the resource cost
rate. As actual work or actual cost is reported on the
task, Microsoft Office Project 2003 calculates EAC
according to this formula.

This is from the help files in 2003. I find that in both
2002 and 2003 the easiest way to get help on a specific
field is to show a table that contains the field (Earned
Value for EAC) and then use the help hyperlink from the
field heading. This takes me directly to help on that
field.

Hope this helps.
Julie

-----Original Message-----
Hi All,

What formula does MS Project use to calculate the EAC

for each task? I can't find anything in the help.

 

[Sean]

Verossa:

EAC = ACWP + (Baseline cost X - BCWP) / CPI

Hope this helps!

----------------------
Sean Pales
EPM Solutions Group
Bennett Adelson
www.bennettadelson.com

-----Original Message-----
Hi All,

What formula does MS Project use to calculate the EAC

for each task? I can't find anything in the help.