View resource workloads and availability in MS Project 2007

Author: mety Nagm Labels::

As a project manager, one of the most important aspects of your role is to monitor the assignments for each of your resources so that you can effectively balance their workloads. Some resources might be overallocated , and others might be underallocated . You can review how efficiently your resources are being used in your project, and whether you need to make any adjustments, by viewing their workloads and availability in Microsoft Office Project.

Review resource workloads by using the Resource Usage view

  1. On the View menu, click Resource Usage.
  2. Review the resource names and their assigned tasks in the table portion of the Resource Usage view.
  3. Review the timescale portion of the view to see how work is allocated over the selected time period.
In many resource views, including the Resource Usage view, overallocated resources are shown in red. An overallocation occurs whenever a resource's maximum units have been exceeded for any period of time. In resource sheets, the indicator field for overallocated resources also includes the Resource leveling indicator Resource leveling indicator , which indicates that the resource be leveled . Check for the indicator, and review the task assignments to assess whether the overallocation is acceptable.
For example, suppose that two tasks have a duration of four hours, and that they both start and finish at the same times. If you assign both tasks to Bob, he is technically overallocated, because during that four-hour span of the two tasks, Bob is working at 200 percent. However, if leveling is set to a day-by-day basis, Bob does not need to be leveled, because during the whole day he doesn't exceed his total eight-hour capacity to work.
You can also display and modify the Resource Usage view to see all of the resource assignments and their percentages of work allocation in a timesheet. This view shows all assignments by resource, and shows how fully these resources are allocated to assigned tasks over time.
  1. On the View menu, click Resource Usage.
  2. On the Format menu, click Detail Styles.
  3. In the Available fields list, click Percent Allocation, and then click Show.
  4. Review the timescale portion of the view. In the % Alloc. row that you've just added, you can see the percentage of the resource's total available working time that is allocated to assignments during the selected time period. In addition, the timescale portion of the view shows both the resource's overallocated work and its allocation percentage in red, making it possible for you to pinpoint exactly when the resource becomes overallocated.
Tip You can zoom in on the time period shown in the timescale (for example, you can change the view from days to hours) by clicking Zoom In Button image . Likewise, you can zoom out from the time period (for example, you can change the view from days to weeks) by clicking Zoom Out Button image .

Use a graph to view individual workloads

The Resource Graph view displays a bar chart view of an individual resource's workload and availability. This view allows you to quickly discover whether the selected resource is overallocated or underallocated for a specific period of time. You can also see the percentage of units allocated for assignments, along with the resource's maximum units availability.
  1. On the View menu, click Resource Graph.
  2. Review the name of the first resource in the Resource Graph view. If the resource name is listed in red, then the resource is overallocated. Resources listed in black are allocated either exactly at or under their full capacity.
  3. Review the bar chart to see the level of overallocation or underallocation. Blue bars (by default) indicate the amount of allocated work that is at or below the resource's maximum unit and working time availability for that time period. Red bars (by default) indicate that the resource is overallocated because the resource has exceeded their maximum unit and working time availability for a given time period.
  4. Review the highest allocation percentages that occur in the time period shown — that is, the peak units for the resource in the time period. Peak units are listed at the bottom of the graph.
  5. To view the bar graph for the next resource, either press PAGE DOWN or use the scroll bar or the arrow keys.

View a list of resources who are overallocated

You can see a list of only those resources that are overallocated by displaying the Resource Sheet view or the Resource Usage view, and then filtering for overallocated resources.
  1. On the View menu, click Resource Sheet or Resource Usage.
  2. In the view, click Filter, and then click Overallocated Resources.
  3. To see the full list of resources again, click Filter, and then click All Resources.
Note Even without filtering for overallocated resources, you can easily see which resources are overallocated, because their names are shown in red in any resource view . Also, in the Resource Sheet and Resource Usage views, an indicator Resource leveling indicator appears in the indicator field , indicating that overallocated resources be leveled.
Task views can also be used to display overallocations, though they don't show overallocations in red the way that resource views do. If you are working in a task view, you can step through each task that has resource overallocations, though a task view won't show you which resources (or how many) are overallocated.
  1. While in any task view, such as the Gantt Chart or Network Diagram, on the View menu, point to Toolbars, and then click Resource Management.
  2. On the Resource Management toolbar, click Go To Next Overallocation Button image .

Group resources who are overallocated

In the Resource Sheet or Resource Usage view, you can group resources who are overallocated. You can also group resources by their peak units , which indicate their maximum percentage allocations on assignments during the project. Reviewing overallocated resources by the extent of their overallocations can help you to focus on the most extensively overallocated resources first.
  1. On the View menu, click Resource Sheet or Resource Usage.
  2. On the Project menu, point to Group by, and then click Customize Group By.
  3. In the Field Name box, click Overallocated.
  4. In the Order box, click Ascending or Descending. If you click Ascending, the group of resources that are not overallocated appears first and the group of overallocated resources appears second.
  5. To create a nested grouping of peak units , click the Then by box, and then click Peak Units.
  6. To save this grouping, click Save. Supply a name for the grouping, and if you want the grouping to show in the Group by menu, select the Show in menu check box. Click OK to close the Save Group dialog box. The view is grouped according to your specifications. Any resource that has any assignment exceeding 100 percent of peak units at any time during the project is grouped under Overallocated: Yes. If you specify a nested grouping of peak units, you might have additional groupings under headings such as Peak: 200%, Peak: 300%, and so on.
  7. To see resources listed in their original order in the Group by box, click No Group.

Find resources who have available time

If you have resources who are overallocated, you might want to identify resources in the project who have available time, so that you can distribute the workload more evenly. This capacity is also useful if there are additional unassigned tasks and you want to find out who is available to take on more work.
Resource availability is calculated using the following formula:
Resource Availability = Resource Capacity - (Summary Resource Assignment + Calendar Exceptions)
The Summary Resource Assignment is the sum of all work done by the resource, and Calendar Exceptions are any exceptions on the resource's base calendar.
To find resources who can work additional hours on a job, you can display and modify the Resource Usage view to see the amount of time (hours, days, or weeks) that a resource has available for additional assignments . You can also use this view to redistribute work from overallocated resources to underallocated ones.
  1. On the View menu, click Resource Usage.
  2. On the Format menu, point to Details, and then click Remaining Availability.
  3. In the Rem. Avail. (remaining availability) row, review the amount of work that represents remaining availability, or underallocation, for each time period.
You can also display and modify the Resource Graph view to view a bar chart of an individual resource's workload, which can help you to discover who can work additional hours on a task. You can review information about one underallocated resource at a time in the Resource Graph view. You can see the amount of available work by time period.
  1. On the View menu, click Resource Graph.
  2. On the Format menu, point to Details, and then click Work Availability.
  3. For the selected resource, review the amount of available work shown in the bar chart. Scroll through the timescale to see underallocations during varying periods of time.
  4. Review the amount of available time for the selected resource at the bottom of the graph .
  5. To move to the next resource that has available time, press PAGE DOWN or use the scroll bar or the arrow keys.



Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2