Progress Reporting - Earned Value - PK Consulting

[PK Consulting]

II asked this question earlier today but I can't find the question or the
response in the discussion group.

I'm trying to create a "earned-value" type report but I want to analyze the
project in terms of hours planned vs. actual rather than budgeted costs. For
example, if I create a project with 100 hours, and 5 deliverables at 20 hours
each, and I complete the first two deliverables, I'd like to be able to
report that I earned 40 hours of deliverables. Any ideas?
'
PK Consulting

 

[Rod Gill]

Only way I know is to set the Resource rate to $1/h so normal Earned Value
reporting is now in hours (if you can ignore the $)!

If you don't want to over-write a standard rate use rate B, C, D or E for
the $1 rate then set that rate as the Cost Rate table by inserting the Cost
Rate Table column in a Usage View. You can copy values or create a macro.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[JulieS]

Hello PK Consulting,

[This is a copy of the response to your question that I posted
yesterday. There appears to be some synchronization problems]

MS Project calculates earned value for you as long as the following are
true:

Task have resources assigned therefore there is work.
Resource assigned to tasks have standard rates. The rates can be as
little as $1.00 per hour.
A baseline has been saved.
Tracking (actual data) has been applied to the project plan.

There is an Earned Value table which shows:
BCWS, BCWP, ACWP, SV, CV, EAC, BAC, and VAC.

There is also an Earned Value Schedule Indicator table and an Earned
Value Cost Indicators table. Help in MS Project is fairly
comprehensive, but please feel free to post any follow up questions you
may have.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project



--
I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project