I am trying to initiate a very simplistic view of earned value in an immature organization. I would like to be able to use MS Project "Percent Complete" and be able to compare that to a "Planned Percent Complete", without using hours or earned value (BCWP, ACWP, etc). Example, after 3 months, the program schedule 'percent complete' is updated to reflect 35% complete. The program can be viewed as behind by looking at the gantt chart, but I cannot find a way to get a rolled-up planned percent complete (e.g. 50%). Has anyone tried to do something like this? Saving Changes...
First – MS Project does not have a field for % planned complete, but it does compute the values:
BCWS = (planned percent complete) X (planned cost) & BCWP = (percent complete) x (planned cost).
Therefore, the following assumption can be made via simple algebra:
Planned percent complete = (BCWS) / (planned cost) &
Percent complete = (BCWP) / (planned cost).
Applying this to a project:
Assign $1.00 per hour rate for all resources if you are not using costs or assign the actual costs for resources.
Be sure the project has been baselined
Add the BCWS and BCWP and Cost Columns to your view.
Percent complete = BCWP/Cost = the % complete column in MS Project) &
Planned percent complete = BCWS/Cost
I had to calculate these values by hand from the numbers on the overall summary task, but it worked. The comparison for % complete was a good accuracy check. Saving Changes...
