earned value
RH

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

Earned Value

resolvedResolved · Low Priority · Version 2007

Earned Value

Would be interested to hear more on Earned Value calculations.

RE: Earned Value

Hi Carl

Thank you for your question.

We have a blog dedicated to project training which you can find at

https://www.stl-training.co.uk/b/category/project-training/

which has an article on this subject:

https://www.stl-training.co.uk/b/how-to-effectively-monitor-your-project-by-learning-earned-value-equations/

We saw on the training that a useful place to start with Earned Value is to work with some simple numbers 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

The following related Microsoft article may also be of interest:
http://office.microsoft.com/en-us/project-help/analyze-project-performance-with-earned-value-analysis-HA101819808.aspx

And one more link for you: https://www.stl-training.co.uk/post-29374-ev.html #ixzz2TAKTrweW


I hope this helps.

Kind regards,
Andrew

Mon 20 May 2013: 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:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.


View all Microsoft Office hints and tips


Server loaded in 0.06 secs.