Neil has attended:
Excel Introduction course
Project Management - Framework & Processes course
Excel Intermediate course
Excel Advanced course
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