I got interesting question from one of my Blog Readers:
“Nenad this is very helpful, however, how would you adjust the scenario where the Actual work by John (100%) and Tom (50%) who are two resources assigned to this 5 days of task i.e. planned work will be John (5*8 = 40hrs) and Tom (5*4=20hrs) total work will be 60hrs.
And if John has worked for 60 hrs alone and Tom has worked for 40 hrs but still the work is only 50% done i.e. at 100hrs spent already the % complete is still 50%, but MS Project will default it to 100% complete, so how can I control this in MS Project?”
OK! Let’s go. First I will create a Project with one Task and 5 days duration in MS PROJECT 2016:
Now I’m going to create Resources: John with 100% max capacity, and Tom with 50% max capacity:
Finally, I’m going to assign John and Tom to the Task:
OK! Now I will show Task Usage View, and I will add Actual work fields in it:
I now put 60 hours in Actual Work field for John, and 40 hours for Tom I will get:
As you can see, this Task is considered Completed. But that is not what my Reader wants. So instead of that I will do next:
Now I will add the Remaining work in Task Usage view: and I will get:
As you can see:
- John has to work 120 hours to complete the Task, and he worked 60 hours already, but it is only 50% of what he has to do, so Remaining work is 60 hours
- Tom has to work 80 hours to complete the Task, and he worked 40 hours already, but it is only 50% of what he has to do, so Remaining work is 40 hours
- In total, John and Tom have to work 200 hours to complete the Task, and they already worked 100 hours, but it is only 50% of what they have to do, so Remaining work is 100 hours in total
So yes, you can do it, but it has few more steps!