earned value formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Earned value formulas

resolvedResolved · Low Priority · Version 2007

replyReply Tue 11 Nov 2008, 09:38Delegate paula said...

paula has attended:
Project Intro Intermediate course

Earned value formulas

What are earned value formulas?

For upcoming training course dates see: Pricing & availability

replyReply Wed 28 Jan 2009, 11:03Trainer Andrew said...

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.

 

Please browse our web site to find out more about
advanced ms project and other Microsoft training courses.

Ms project tip:

Compare Work and Duration

Duration is the timescale within which a task is done; Work is the specific time element used. For example, 3 days work in a duration of 2 weeks. To compare, add the Work field into the Entry table by right clicking a column heading to Add Field.

View all MS Project hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard