Overallocations

R

Rai

I have two situations where resources are shown to be overallocated on the
resources graph, and are highlighted in red in all other views BUT...they are
allocated for 8 hours of an 8 hour day at 100%. Resources have 8 hours
available on their calendar, with no other commitments.

In one of the situations, the 'work' column has turned blue.....and I can't
find that mentioned in any help files...
If I reduce the resource to 5 hours total for the day, the overallocation is
solved but the second of the two tasks turns blue instead.
 
D

Darrell

Rai,

I do not know what version you are using so I will just share some
information. I have found that a resource will turn Red if they are allocated
over 100% even if the work is less than the 8hrs they are available. If you
take a resource that is not red and change the allocation of a task to 101%
the resource will turn red. I mention this because if a resource has two
assignments on the same day that together total 8 hrs or less but they are
allocated to each task at 100% they will turn red.

Darrell
 
R

Rai

Hi Darrell

I am using 2007 Standard.

I tried changing things around, as both these situations resulted from
resources completing 2 tasks in one day. What do I need to do, to allow a
resource to work 8 hours on more than one task, and is there some settings
that can be changed to prevent this continually occurring?
It appears that a similar situation occurs when two people work on the same
task on the same day???
 
D

Darrell

Well for multiple tasks assigned on the same day, it works like this. If you
schedule a task for Monday and there is only 1hr of work to be done the
resource allocation is approx. 13% for that day on that task. That leaves 87%
of the resource's time to do something else. So, the resource can have a
second task on Monday where there is 4hrs of work to be done which uses up
another 50% of the resource's day. The resource now has 37% of their time
left to do even more work on Monday so yet another task can be assigned with
3hrs of work. Now the resource is fully allocated for Monday.

Monday – 1hr = 13%
Monday – 4hr = 50%
Monday – 3hr = 37%
Totaling – 8hr = 100%

Work / Duration = Units
1hr / Monday (8hrs) = 13%
4hr / Monday (8hrs) = 50%
3hr / Monday (8hrs) = 37%

Darrell
 
J

Jan De Messemaeker

Hello Rai,

For a longer explanantoion of this, read FAQ 34 on
http://www.mvps.org/project/faqs.htm

The bottom line is, when you have two meetings scheduled, boith for 8-9
tomorrow morning, even if you have no other work planned for tomorrow you
are overallocated between 8-9 aren't you?
That's how Project works; if you don't like the red color you have to make
sure the two tasks don't overlap.
To watch only the overallocations on a daily basis
Tools
Resource leveling
If it isn't set that way for Look for overallocations on a ... set day by
day basis
Now in the Indicator column of every resource view a yellow diamond will
appear when the resource is overallocated somewhere on a day by day basis.
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 
S

Steve House [MVP]

Don't think in terms of total hours. "Overallocation" does not refer to
totals - it is an instantaneous thing. If a resource is on two tasks, each
at 100%, and those two tasks overlap for even one minute, no matter how long
each task may last, the resource is overallocated. For example, I have a
sample file with a situation where a resource works 8 to 5 and has an
allowed maximum allocation of 100%, 8 hours of work during an 8 hour day.
On a certain day, she is booked on two tasks, each 100%. One task is 2
hours long, the other is 4 hours, for a total of 6 hours work she's
scheduled to do that day. Now you might think that she's only booked for
75%, 6 divided by 8 is 0.75. But Project says she's overallocated and shows
a peak allocation of 200%. Why? There's a couple of crucial pieces of
information I haven't mentioned yet. Task A starts at 8am and ends at 10am.
Task B starts at 8am and ends at 12 noon. The overallocation occurs because
during the 2 hours of time between 8am and 10am, she is required to perform
a total of 4 man-hours of work, 2 hours of each task and that's physically
impossible. Resource leveling resolves the overallocation by moving one of
those tasks so they happen sequentially rather than simultaneously.
 
R

Rai

Firstly let me say that this resource is several hundred percent better than
the programs help files, and thankyou all for responding.

This seems to be an over zealous way of controlling resources.
IMHO the majority of resource managers would book Fred in to inspect the
Steelwork, at one point on Thursday, and then inspect the Brickwork that
afternoon. If the 2 tasks absorb a total of 6 hours...the only way that he
can be overallocated is that the program assumes they both occur at 8 am.
I dont get the % thing, particularly when he has 6 hours of work to do in an
8 hour day...???? If the % doesn't relate to the amount of time he has
booked, versus the amount of work to do, then what does it represent?? I
would have thought that the default setting would be that the tasks occur
sequentially instead of simultaneously. Can I change 'projects' way of
thinking?? I can't allocate Fred to an afternoon meeting without
overallocation as there is no function other than multiple calendars (messy)
The program is meant to make life easy......isn't it?
The further i get into programming this project, the more over allocations I
am getting because all meeting start at 8 ??
I am really getting frustrated at having to tell project that it's
assumptions aren't what happen in the real world.

Hope you can help.....:-(




Steve House said:
Don't think in terms of total hours. "Overallocation" does not refer to
totals - it is an instantaneous thing. If a resource is on two tasks, each
at 100%, and those two tasks overlap for even one minute, no matter how long
each task may last, the resource is overallocated. For example, I have a
sample file with a situation where a resource works 8 to 5 and has an
allowed maximum allocation of 100%, 8 hours of work during an 8 hour day.
On a certain day, she is booked on two tasks, each 100%. One task is 2
hours long, the other is 4 hours, for a total of 6 hours work she's
scheduled to do that day. Now you might think that she's only booked for
75%, 6 divided by 8 is 0.75. But Project says she's overallocated and shows
a peak allocation of 200%. Why? There's a couple of crucial pieces of
information I haven't mentioned yet. Task A starts at 8am and ends at 10am.
Task B starts at 8am and ends at 12 noon. The overallocation occurs because
during the 2 hours of time between 8am and 10am, she is required to perform
a total of 4 man-hours of work, 2 hours of each task and that's physically
impossible. Resource leveling resolves the overallocation by moving one of
those tasks so they happen sequentially rather than simultaneously.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs



Rai said:
I have two situations where resources are shown to be overallocated on the
resources graph, and are highlighted in red in all other views BUT...they
are
allocated for 8 hours of an 8 hour day at 100%. Resources have 8 hours
available on their calendar, with no other commitments.

In one of the situations, the 'work' column has turned blue.....and I
can't
find that mentioned in any help files...
If I reduce the resource to 5 hours total for the day, the overallocation
is
solved but the second of the two tasks turns blue instead.
 
S

Steve House [MVP]

In this case I think you've misunderstood what "% assignment" really means.
If someone works an 8 hour day and I assign them to a task at 50%, that does
NOT mean I expect them to work on the task for 4 hours. The assignment
percentage is actually a RATE measure that describes the way the resource
efforts converts time spent into work accomplished. If you have a task that
has 8 hour's duration and someone is assigned to it at 50%, the resource is
still actively working on it for the full 8 hours but because of some other
simultaneous demands on his time, he gets the amount of work done that would
have taken him 4 hours if he could have devoted his undivided attention to
it.

Assume the default calendar and a 1 day (8 hour) duration task. Assign the
resource to it 100% and he spends 8 hours generating 8 man-hours of work.
Assign him to it 50% and he spends 8 hours to generate 4 man-hours of work.
Assign him to it 25% and he spends 8 hours to generate 2 man-hours of work.
But in all cases the amount of time he spends on the task is 8 hours, with
it starting at 8am and ending at 5pm.

You usually would expect a resource to devote his full attention to the task
at hand. If you have a task that requires 2 hours of effort, make it a
2-hour duration task and book the resource 100%, not an 8-hour duration task
with the resource booked on it 25%.

The program doesn't assume both tasks start at 8am. It actually doesn't
assume anything. The project calendar determines the initial start time of
tasks since work can only take place when people are there to do it and that
information comes from the project calendar. Those tasks start at 8am
because you told Project that's when work can start. If there were infinite
resources, all resources could do any task, and no physical dependencies,
all the tasks could begin simultaneously at the first possible working
moment in the calendar after the project kicks off. It defaults to
simultaneous rather than sequential because the 'prime directive' is to get
the entire project done ASAP. The first reason they can't all happen at once
is that some tasks are physically dependent on the scheduling of
predecessors, so their timing is modified by dependency links. The second
determiner of the task's start is the availability of the specific resources
who are able to do the work - a task has to wait until a person with the
required skills comes to work, if he's on vacation the task has to wait.
Resource calendars are the source of that information. And the third
determiner is that resources can't be in two places at once so the final
schedule is determined by delaying some tasks through resource leveling to
resolve overallocations.

In your example, both tasks COULD start at 8am. You didn't specify that you
have to inspect the steelwork and brickwork in any particular order so from
that standpoint they could both start at 8. If you had two inspectors they
could both start at 8. With one inspector they will initially be
overallocated but leveling will sequence them. Or could if they happen at
the same time, Fred doing both at once, make each of them 6 hours duration
and assign him 50% to each.

If you don't want meetings to start at 8am, specify the start time as part
of your entry for the task.

--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs


Rai said:
Firstly let me say that this resource is several hundred percent better
than
the programs help files, and thankyou all for responding.

This seems to be an over zealous way of controlling resources.
IMHO the majority of resource managers would book Fred in to inspect the
Steelwork, at one point on Thursday, and then inspect the Brickwork that
afternoon. If the 2 tasks absorb a total of 6 hours...the only way that he
can be overallocated is that the program assumes they both occur at 8 am.
I dont get the % thing, particularly when he has 6 hours of work to do in
an
8 hour day...???? If the % doesn't relate to the amount of time he has
booked, versus the amount of work to do, then what does it represent?? I
would have thought that the default setting would be that the tasks occur
sequentially instead of simultaneously. Can I change 'projects' way of
thinking?? I can't allocate Fred to an afternoon meeting without
overallocation as there is no function other than multiple calendars
(messy)
The program is meant to make life easy......isn't it?
The further i get into programming this project, the more over allocations
I
am getting because all meeting start at 8 ??
I am really getting frustrated at having to tell project that it's
assumptions aren't what happen in the real world.

Hope you can help.....:-(




Steve House said:
Don't think in terms of total hours. "Overallocation" does not refer to
totals - it is an instantaneous thing. If a resource is on two tasks,
each
at 100%, and those two tasks overlap for even one minute, no matter how
long
each task may last, the resource is overallocated. For example, I have a
sample file with a situation where a resource works 8 to 5 and has an
allowed maximum allocation of 100%, 8 hours of work during an 8 hour day.
On a certain day, she is booked on two tasks, each 100%. One task is 2
hours long, the other is 4 hours, for a total of 6 hours work she's
scheduled to do that day. Now you might think that she's only booked for
75%, 6 divided by 8 is 0.75. But Project says she's overallocated and
shows
a peak allocation of 200%. Why? There's a couple of crucial pieces of
information I haven't mentioned yet. Task A starts at 8am and ends at
10am.
Task B starts at 8am and ends at 12 noon. The overallocation occurs
because
during the 2 hours of time between 8am and 10am, she is required to
perform
a total of 4 man-hours of work, 2 hours of each task and that's
physically
impossible. Resource leveling resolves the overallocation by moving one
of
those tasks so they happen sequentially rather than simultaneously.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs



Rai said:
I have two situations where resources are shown to be overallocated on
the
resources graph, and are highlighted in red in all other views
BUT...they
are
allocated for 8 hours of an 8 hour day at 100%. Resources have 8 hours
available on their calendar, with no other commitments.

In one of the situations, the 'work' column has turned blue.....and I
can't
find that mentioned in any help files...
If I reduce the resource to 5 hours total for the day, the
overallocation
is
solved but the second of the two tasks turns blue instead.
 
J

Jan De Messemaeker

Hi,

Even in the real world, if you are to be present at 2 different jobs
simultaneously, you have a problem.
That is what Project shows.
And you can enter ezch date in project as 27/11/08 13:50 because Project
does EVERYTHING by the minute.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Rai said:
Firstly let me say that this resource is several hundred percent better
than
the programs help files, and thankyou all for responding.

This seems to be an over zealous way of controlling resources.
IMHO the majority of resource managers would book Fred in to inspect the
Steelwork, at one point on Thursday, and then inspect the Brickwork that
afternoon. If the 2 tasks absorb a total of 6 hours...the only way that he
can be overallocated is that the program assumes they both occur at 8 am.
I dont get the % thing, particularly when he has 6 hours of work to do in
an
8 hour day...???? If the % doesn't relate to the amount of time he has
booked, versus the amount of work to do, then what does it represent?? I
would have thought that the default setting would be that the tasks occur
sequentially instead of simultaneously. Can I change 'projects' way of
thinking?? I can't allocate Fred to an afternoon meeting without
overallocation as there is no function other than multiple calendars
(messy)
The program is meant to make life easy......isn't it?
The further i get into programming this project, the more over allocations
I
am getting because all meeting start at 8 ??
I am really getting frustrated at having to tell project that it's
assumptions aren't what happen in the real world.

Hope you can help.....:-(




Steve House said:
Don't think in terms of total hours. "Overallocation" does not refer to
totals - it is an instantaneous thing. If a resource is on two tasks,
each
at 100%, and those two tasks overlap for even one minute, no matter how
long
each task may last, the resource is overallocated. For example, I have a
sample file with a situation where a resource works 8 to 5 and has an
allowed maximum allocation of 100%, 8 hours of work during an 8 hour day.
On a certain day, she is booked on two tasks, each 100%. One task is 2
hours long, the other is 4 hours, for a total of 6 hours work she's
scheduled to do that day. Now you might think that she's only booked for
75%, 6 divided by 8 is 0.75. But Project says she's overallocated and
shows
a peak allocation of 200%. Why? There's a couple of crucial pieces of
information I haven't mentioned yet. Task A starts at 8am and ends at
10am.
Task B starts at 8am and ends at 12 noon. The overallocation occurs
because
during the 2 hours of time between 8am and 10am, she is required to
perform
a total of 4 man-hours of work, 2 hours of each task and that's
physically
impossible. Resource leveling resolves the overallocation by moving one
of
those tasks so they happen sequentially rather than simultaneously.
--
Steve House [Project MVP]
MS Project Trainer & Consultant
Visit http://project.mvps.org/faqs.htm for the FAQs



Rai said:
I have two situations where resources are shown to be overallocated on
the
resources graph, and are highlighted in red in all other views
BUT...they
are
allocated for 8 hours of an 8 hour day at 100%. Resources have 8 hours
available on their calendar, with no other commitments.

In one of the situations, the 'work' column has turned blue.....and I
can't
find that mentioned in any help files...
If I reduce the resource to 5 hours total for the day, the
overallocation
is
solved but the second of the two tasks turns blue instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top