Planned vs Actual Percentage Completed

[Jason]

Is there a way where MS Project calaculates Planned or base percentage
complete of work to be done, which can then be used to compare actuals
percentages of work completed. To determine whether the actual percentage of
works completed is progressing as scheduled??

 

[Mike Glen]

Hi Jason,

Welcome to this Microsoft Project newsgroup

You could enter a custom column with a formula subtracting the two, but a better method is to try entering the world of Earned Value - search Help.

FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials



Is there a way where MS Project calaculates Planned or base percentage
complete of work to be done, which can then be used to compare actuals
percentages of work completed. To determine whether the actual percentage of
works completed is progressing as scheduled??

 

[Jim Aksel]

Hi Janson - Go to my blog and read the paper about "What %Complete Should I
be?"
You need to consider a couple of things.

Just becuase someone logs an hour of work, does not mean they have produced
an hour or value for that work (the task could be easier or harder than you
originally estimated).

You are hinting at something called Earned Value (you can read about it in
the help). In order to properly track a schedule, you need to know three
things:

1. What I planned to due (Plan Value - or scheduled effort)
2. The number of hours billed to the task (Actual Costs)
3. The value received for that work actually performed (Earned Value).

For example, I bid 32 hours to paint 4 walls in a room (8 hours for each
wall). If I give you a bill Wednesday morning for 12 hours of work you may
accuse me of being behind schedule (it should be 16 hours right?).

But suppose I told you that I have completed two walls already. Now I am on
schedule, but under cost. Or suppose I came to you Tuesday AM and said, I
put in only 6 hours yesterday but got two walls done. Now I am ahead of
schedule and under cost.

In reality, I am going to come to you Wednesday AM and say, here is my bill
for 20 hours and I have 1 wall done (behind schedule and over cost).

See?
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com