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

earned valued fields

Forum home » Delegate support and help forum » Microsoft Office general help » Earned valued fields

Earned valued fields

ResolvedVersion 2003

Earned valued fields

what are the earned valued fields?

RE: earned valued fields

Hi Neil

Thanks for your question. A good starting point is to work with some straightforward values from your Project. For example:

Budgeted Cost of Work Scheduled (BCWS) - what we agreed we'd spend to complete the project
Budgeted Cost of Work Performed (BCWP) - what we agreed we'd pay for the work that's been completed
Actual Cost of Work Performed (ACWP) - what we really paid for the work completed.

With these figures we can do some simple analysis. For example Performance Indices can be calculated:

BCWP/ACWP = CPI or Cost Performance Index. If it's less than 1 the project is over spending

BCWP/BCWS = SPI or Schedule Performance Index. This time a result less than 1 means the project is behind schedule.

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


Kind regards,
Andrew

Fri 16 Jan 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Viewing the whole dropdown menu bar

If you dont like having to point to the double chevron to see the full menus, you can click on Tools, Customise and the options tab.

Clci on Always show full menus to see the full drop down menu bar.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.