Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

earned value formulas

Forum home » Delegate support and help forum » Microsoft Project Training and help » Earned value formulas

Earned value formulas

ResolvedVersion 2007

paula has attended:
Project Intro Intermediate course

Earned value formulas

What are earned value formulas?

RE: Earned value formulas

Hi Paula

Thanks for your question. A starting point for Earned Value would be to look at some simple calculations:

Budgeted Cost of Work Scheduled (BCWS) - our budget (or baseline)
Budgeted Cost of Work Performed (BCWP) - the agreed resource rate applied to work carried out
Actual Cost of Work Performed (ACWP) - what we really paid for the work carried out.

Once we have these figures we can do some simple analysis. For example :

Performance Index:
BCWP/ACWP = CPI or Cost Performance Index. Less than 1 the project is over spending

BCWP/BCWS = SPI or Schedule Performance Index. Less than 1 means the project is behind schedule.

These calculations offer a starting point. I hope this helps - do let us know if you have any further questions.

Tue 3 Feb 2009: Automatically marked as resolved.

MS Project tip:

Formatting Bar Text

To display notes or resource initials on the Gantt chart bars, choose Format, Bar Styles and the Text tab. Select the position you want to show the text i.e. Top or Inside etc, then choose the field name you are looking for from the drop down arrow. Type the first letter of the name to get quickly to the top of the letter range. Click OK.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.