Analyze work required versus resource availability
This Document can be found in the following categories:
After all work required on all tasks is entered, click
the RECALCULATE toolbar button.
Color highlighting shows where there is not enough resource
availability to satisfy the required work effort. In the example
below, Pat McClusky is needed .4 in August on the B2 task. He has
total availability for the project of .6 (per the detail row at the
top immediately below the task Gantt bar).
The B2 cell is red because he is needed on the B1 task .4 in the
same period; only 50% of the .4 requirement on the B2 task can be
You can double click on a cell in the resource column to filter the
sheet on that resource. This makes it easy to see where the excess
work is occurring.
to the Previous Step Proceed to the Next Step>>