On the Resource Sheet view, the resource will be coloured red.
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image003.jpg"><img style="display:inline;border:0;" title="clip_image003" src="http://epmpire.files.wordpress.com/2010/01/clip_image003_thumb.jpg" border="0" alt="clip_image003" width="244" height="32" /></a></td>
<td width="316" valign="top">
On the Resource Sheet view, the resource will be coloured red.</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image004.png"><img style="display:inline;border:0;" title="clip_image004" src="http://epmpire.files.wordpress.com/2010/01/clip_image004_thumb.png" border="0" alt="clip_image004" width="244" height="29" /></a>
</p>
<p>
On the Gantt chart view, the task will have a red person indicator next to it.
</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image0061.jpg"><img style="display:inline;border:0;" title="clip_image006" src="http://epmpire.files.wordpress.com/2010/01/clip_image006_thumb1.jpg" border="0" alt="clip_image006" width="244" height="28" /></a></td> </tr> </tbody> </table>
<p>
There are a couple of ways that a resource overallocation can be corrected, how you approach it will depend on which version of MS Project you are using and which method you are most comfortable with.
</p>
<p>
<strong>Manual correction</strong>
</p>
<p>
The simplest method is to manually correct the overallocation. This is most easily achieved by setting a filter on the Gantt chart against the overallocated resource and identifying where tasks are occurring on the same day. Once identified, the tasks can be moved manually by changing the start date, moving the Gantt chart item with the mouse, or moving the hours in the resource usage sheet.
</p>
<p>
<strong>Team Planner </strong>
</p>
<p>
Project 2010 includes a new feature that can assist in resolving overallocations called the Team Planner. Only available in Project Professional 2010, this feature is designed to provide a simple interface to assign resources to tasks, schedule those tasks, and identify and correct resource oveallocations. To invoke the team planner, select the Team Planner view from the view menu.
</p>
<p>
The default team planner view consists of four quadrants containing:
</p>
<p>
· Resourced / Unscheduled tasks
</p>
<p>
· Resourced / Scheduled tasks
</p>
<p>
· Unassigned / Unscheduled tasks
</p>
<p>
· Unassigned / Scheduled tasks
</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image008.jpg"><img style="display:inline;border:0;" title="clip_image008" src="http://epmpire.files.wordpress.com/2010/01/clip_image008_thumb1.jpg" border="0" alt="clip_image008" width="457" height="484" /></a>
</p>
<p>
To correct overallocations, we are only interested in the Resourced / Scheduled quadrant. As you can see from the above screen shot, tasks 1 and 2 are currently overallocated, as seen by the red highlighting. To correct the overallocation you can either right click on the resource name and choose Level Resource, or my preferred method, drag and drop Task 2 to the next day to remove the overallocation.
</p>
<p>
<strong>Leveling</strong>
</p>
<p>
Both Microsoft Project 2007 and 2010 include a leveling feature that enables the project schedule resourcing to be leveled either automatically or manually. Whilst present in Project 2007, it was buried in the menus and not easy to find, whereas Project 2010 has surfaced more of the capability.
</p>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="616" valign="top">
<strong>Project 2007</strong>
</td>
</tr>
<tr>
<td width="616" valign="top">
Select Tools > Level Resources…</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image009.png"><img style="display:inline;border:0;" title="clip_image009" src="http://epmpire.files.wordpress.com/2010/01/clip_image009_thumb.png" border="0" alt="clip_image009" width="533" height="484" /></a></td> </tr>
<tr>
<td width="616" valign="top">
<strong>Project 2010</strong>
</td>
</tr>
<tr>
<td width="616" valign="top">
Select the Resource tab and Level grouping.</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image011.jpg"><img style="display:inline;border:0;" title="clip_image011" src="http://epmpire.files.wordpress.com/2010/01/clip_image011_thumb.jpg" border="0" alt="clip_image011" width="644" height="123" /></a></td> </tr> </tbody> </table>
<p>
The levelling feature has a variety of options that the user can select when levelling, including the calculation type, the order in which levelling should occur (either based on task id, task priority or standard which is based on a combination of predecessors, slack, dates, priorities and constraints).
</p>
<p>
<a href="http://epmpire.files.wordpress.com/2010/01/clip_image012.png"><img style="display:inline;border:0;" title="clip_image012" src="http://epmpire.files.wordpress.com/2010/01/clip_image012_thumb.png" border="0" alt="clip_image012" width="584" height="484" /></a>
</p>
<p>
I am not going to go into the nitty gritty of levelling as I would be here for hours, but if you want to know more specifics on the leveling feature, check out the online help for a detailed overview of each option.
</p>
<p>
To level the plan, select Manual calculation, this retains an element of control of the leveling, as opposed to automatically leveling the whole plan. Choose to look for overallocations on a Day by Day basis, leaving the remaining options as is, and click on Level Now to level the plan.
</p>
<p>
A word of warning though, automated resource leveling function is very powerful, and as we all know, with great power comes great responsibility. It is incredibly dangerous to use the automated leveling features blindly, accepting that Level Now will create a perfectly allocated schedule without going through and checking the minute detail of what the function has done. Certainly experience gained from watching colleagues pulling their hair out after auto leveling the entire plan has turned me off using the feature on more complicated plans.
</p>
|