Quick Links

Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy

When you create an assignment that contains an over-allocation or when a resource is assigned to a task and their work calendar doesn’t match the task schedule, a new indicator will immediately show that a resource has been over-allocated. Meet ROG, the Red Over-allocation Guy!

Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy

This indicator provides information on the Task side of Microsoft Project.

To understand and solve resource problems, we need to know both who has problems and what tasks are creating the problems. Microsoft Project has many ways of displaying this information. To view the assignment information, you can select the Resource Usage view or the new Project 2010 Team Planner:

1. Select Resource Usage.
2. Select the Filter, Overallocated Resources.
3. Click twice on the minus sign next to the name to display the tasks. Next, enlarge the Resource Name column to display more information.

Figure 2. This shows over-allocated resources and the tasks they’re assigned to.

Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy

To display overloaded resources, use the Resource Allocation View. This view provides a way to see the work spread in time along with the tasks with the Gantt chart format. Select: More Views | Resource Allocation View.

Figure 3. Only those tasks for the over-allocated resources are displayed.

Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy

To optimize resources, you have many options — most falling under five main categories:

1. Modify resource assignments. You can negotiate for more of the required resource, substitute the overloaded resource on one or more of the affected tasks, distribute the resource across multiple tasks (i.e. part time here, part time there), and remove resources from the items with float and apply to critical path items.

2. Work overtime, to modify the calendar for the resource, adding hours per day or days per week.

3. Change dependencies. You can change the predecessor and/or successor so tasks aren’t competing for the same resource and reschedule the work to avoid resource conflict.

4. Change scope to eliminate overloaded tasks, perhaps reducing project scope as well.

5. And you can do resource leveling.

But those are topics for future articles!

This article was excerpted from Microsoft Project 2010 Made Easy! Managing Projects with Microsoft Project by John Riopel, project management trainer with PM Providers and co-host of MPUG Project Talk.

Written by John Riopel

John Riopel, MCP, MCTS, PMP has over 25 years of experience as a Program/Project Manager in government service and commercial industries.  His technical background in Microsoft Project spans the entire evolution of the Microsoft Project toolset, with a deep understanding of how to apply these technology constructs and concepts to real-world project management challenges.He is President and CEO of PM Providers, a full-service project management consulting firm dedicated to delivering business results with project management solutions.

Share This Post
1 Comment
  1. Hi,
    I need help with a project assigned and trying to produce a report for the executives at my company. The stakeholders did not provide me with any costs or figures to import to be analyzed. They also don’t know anything about Microsoft project but, I have to produce the information in a format that they can understand. I think that a report like this will only show the timelines and progression of the various tasks. I also need help with the milestones and deliverables. I think that my struggles are due to the way the information was provided. I am hearing everything secondhand from the stakeholders and not a member of the team it appears. Any advice would be deeply appreciated.



Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>