very often there is a question: “When is Resource over allocated, and how MS PROJECT 2013is dealing with it?”
That is very easy to explain. First I will ad the three Tasks:
and my Resource will be John Wayne:
Of course that I will assign John Wayne to all three Tasks:
As you can see, John Wayne is over allocated in all three Tasks. Let’s see Resource Usage diagram:
Now, suppose that John Wayne is a Superman! He can work 24 hours at Monday, so you do not want him to be marked as over allocated. You can do it here:
and I will get:
WHY? The answer is easy! I told MS PROJECT 2013 that Over allocation is calculated on Week by Week Basic. What dose it mean? It means that MS PROJECT 2013 is making calculation: 5 days * 8 house per day = 40 hours. John Wayne is occupied on 3 Tasks (Monday) * 8 hours = 24 hours, and that is less than 40 hours.
I will add Task 4, and Task 5, and I will assign John Wayne on it, and I will get:
John Wayne is now occupied 40 hours!
Finally I will add Task 6 with 1 minute Duration, and I will assign John Wayne to it, and I will get:
Tralaaaaaaaa! John Wayne is Over allocated now because he is working 40 hours + 1 minute on six Tasks, and that is larger than 40 hours.
Finally, does it make a sense to put one Resource to work 40 hours + 1 minute on various Tasks at the same day? Of course not. So I will make predecessors for those Tasks:
John is still over allocated because in a week he is working more than 40 hours (even 1 minute more makes him over allocated)!
But what if John will work on Task 6 after Task 5?
He is not over allocated any more? WHY? Because Task 6 is scheduled on the next week!
You got the point, didn’t you!
Hi Nenad, I am wondering, why each time I reopen my MS Project plan, the resources are shown afain as overallocated (red men), although the last time I saved the plan, i had levelled all the resources and/or used the function Move when resource is available.
I have 2 projects on the same resource pool in first I planned resource A as committed for eg 6h in second as proposed for eg 4h. Project shows me that resource A is over allocated :/. Is this normal situation that Project counts both committed and proposed to one pool ? If not how can I fix it ?
It is normal situation, so over allocation has nothing in common with Commited or Proposed Resource 😦
Is it possible to workaround this somehow to counts only committed allocation. I can not leave it as is to use by our PMO and PMs because during planning resources they will see lots of over allocations.
Only if you make a custom report, or write a MAcro!
i am a beginner with microsoft project and am really interested on learning more about it ,
dont you have a tutorial , i am working as a maintenance manager and i have got a lot jobs to do but i dont know how to start ,.\
Get a Book MS PROJECT 2013 STEP BY STEP
What if i have to assign 20 labors to a single task. should i write as 2000% or what? thanks
If you assign 20 separet labours, that for each of them it should be 100%! But if you have a one Generic resource with 20 workers than you should put 2000%
Thank you very much.. really appreciate.
I have even more a bit problem with my projects while using share resources from the one to multiple projects.
I ll explain the things in Brief here
1. I created a template project with resources listed and saved the project as template
2. I created Project 2 and using “resource pool” i shared the resources with “template” project
3. I created two more projects and shared the resources with the template project
then i found the issue that “resources” of all the projects were over allocated
I think the issue a raised due to sharing the resources for all the different projects
can you solve this issue … it would be quiet helpful
I’ll love to help. Can you send me mpp files, so I’ll se what can I do?