% Complete VS Physical % Complete in MS PROJECT 2013

Hi,

I will explain hot to track Physical % Complete in MS PROJECT 2013.

In MS PROJECT you can Track %Complete, % Work Complete, and Physical % Complete. Where are the differences?

  • % Complete is about Duration
  • % Work Complete is about how much work (in hours, for example) is done
  • Physical % Complete is how much Physical work is done

Let’s go! First I will make a brand new Project with one Task:

image

I’ll now add John as Resource and I’ll assign him to the Task:

image

and:

image

I’ll switch to the Task Usage View, and I’ll add Actual work field:

image

and I’ll get:

image

I’ll now change Work field, so John will have to work only 4 hours at Monday, and Tuesday:

image

Now, I’ll add %Complete, %Work Complete, and Physical % Complete fields on the right part of the screen:

image

Let say that it was 50% spent on the Task 1:

image

As you can see, %Complete is 50%, but % Work Complete is 38%. Where is the difference?

%Complete is 50%, and that means that John has worked 50% of duration, e.g. 5 Days * 50% = 2,5 days! So, if he worked only 2,5 days Actual work (in hours) is 4 hours at Monday, 4 hours at Tuesday, and 4 hours at Wednesday (half day, because John has to work 8 hours at Wednesday). This is what %Complete means = %Duration

On the other hand, John is supposed to work 32 hours to complete his Task. Hi already worked 12 hours (4 hours at Monday, 4 hours at Tuesday, and 4 hours at Wednesday). Simple math:  %Work = 12 hours (Sum of Actual hours)/ 32 (Sum of work) = 0,375 = 38%

OK! I know that, you idiot, you will say. You had the same example few days ago! I know! But what about Physical % Complete?

John spent 2,5 days (50% of Duration) and 12 hours (38% of %Work Completed), but, just for example, he completed 90% of Task! So next 2,5 days, he will spend 20 hours for finishing 10% of his physical work. If the Task is, for example, Publishing the Book, he might wrote in 2,5 days, but next 2,5 days (and 2’0 hours), he need for reviewing it with editor, fix misspelling etc.

For that purpose I will put 90% in Physical % Complete!

image

OK! What can you do with that? You can calculate EVM on that way! I’m not going to show you here EVM report, because I have to leave something for my further Posts.

But, as you can see there is 0% of Physical Complete in Project Summary Task. To have it roll up, you should follow this steps:

  1. Make sure that you have put value greater than 0 in Standard Rate in Resource Sheet.
  2. Change Earned Value Method to Physical % Complete:

image

3. Save the Baseline:

image

and:

image

And, here it is:

image

Regards!

Advertisements

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, MS PROJECT 2010, PMI, PRoject Management and tagged , , , . Bookmark the permalink.

10 Responses to % Complete VS Physical % Complete in MS PROJECT 2013

  1. Pingback: % Complete VS Physical % Complete in MS PROJECT 2013-6 | It's all about Project Management....

  2. Azzizan says:

    Good day to you sir. Regarding to this matter. I have enter the figure for my Physical %. However, the summary on the Physical remains zero. Can you help me Sir. Thank You

    • Nenad Trajkovski says:

      Yes it does. It make a sense because sum of Physical % is not logical

      • Ram says:

        Dear Sir, This Ram from Bahrain. i had the same issue with Physical % complete field. i did all the steps which you stated above and in the project summery field overall physical % complete is not displaying. i entered the actual values only as all those are quantity based. can you help in this issue .
        Thanks & Reg..
        Ram.

      • Nenad Trajkovski says:

        Did you put standard rate for resource? did you assign resource to the Task? did you save the Baseline? dd you change the EMV method?

  3. ailukewitsch says:

    Hi you know why some tasks even thou you might put 100% the summarize doesn’t make it to 100% stays in 99%. Any idea why this might be happening? I been searching for something similar to implement as a physical 100% complete with summarize included. Thanks!

  4. Pingback: % Complete VS Physical % Complete in MSP-2013 | It's all about Project Management....

  5. Siddeshwar says:

    Mr. Nenad Trajkovski

    I am Siddeshwar from Mumbai, India, can you plz tel me if I enter 50% in % physical complete, will the roll up to project summary shows me the same 50%?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s