earned valued fields
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 Office general help » Earned valued fields

Earned valued fields

resolvedResolved · Low Priority · Version 2003

replyReply Tue 6 Jan 2009, 16:07Delegate Neil said...

Neil has attended:
Excel Introduction course
Project Management course
Excel Intermediate course
Excel Advanced course

Earned valued fields

what are the earned valued fields?

For upcoming training course dates see: Pricing & availability

replyReply Fri 9 Jan 2009, 11:11Trainer Andrew said...

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.

 

Please browse our web site to find out more about
time management courses - london and other Microsoft training courses.

Microsoft office tip:

Draw a perfect square or circle

Click on the Rectangle or Oval button on the Drawing toolbar. (If necessary, click Customize on the Tools menu, and then click the Drawing check box on the Toolbars to display the toolbar.)
Press and hold down both the [SHIFT] key and the mouse button.
Drag the mouse pointer diagonally downward and to the right until the rectangle or circle drawn has your preferred measurements.
Release the mouse button.
Release the [SHIFT] key.
In short, simply hold down the SHIFT key while dragging the mouse pointer!

View all Microsoft Office 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