How to Allocate Resources in Microsoft Project

One of the most important but often overlooked parts of the project management process is allocating resources properly. Once a project schedule is created, it will usually have to be altered to avoid over-allocating a particular resource (for instance, a subcontractor), which will cause the schedule to be held up. Knowing how to allocate resources in Microsoft Project will help keep you in control of your project from start to finish.

The best way to keep your resources organized is through the resource sheet. To access this sheet, click on the “View” menu and select “Resource Sheet.” Make sure all of your resources have clear names, and make sure you at least specify the resource type.

  • Work: resources are the most useful, and should be used to categorize people who will spend time working on tasks. On a small project, this type of resource could refer to each team member by name. On a larger project, this resource could specify different subcontractors.
  • Material:  resources should refer to materials that get used up during the work, such as lumber, nails, and gasoline.
  • Cost: resources should be used to track resources that have a clear cost rate attached to them. The daily rate for renting a crane or a field trailer could be tracked as a cost resource.

After creating the schedule in the Gantt chart view, you will need to specify which resource(s) is associated with each task. To do this, find the task’s line in the left panel, and click the cell in the “Resource” column. A drop-down menu will appear listing all the resources you have created. Select the appropriate resource; for instance, a task called “Wire light fixtures” could be assigned the resource “Electrician.”

After creating your schedule and assigning resources, you can check for over-allocation. To do this, click on “View” and select “Resource Graph.” You will be allowed to select each resource and view its allocation throughout the project. Each workday is shown along the horizontal axis, and resource usage is expressed as a percentage along the vertical axis.

  • Any point at which a resource exceeds 100 percent usage represents an over-allocation (meaning the resource can’t possibly perform all the tasks assigned to it in the given time). Over-allocation is represented in red. To remedy this, increase the task durations, assign more resources to the tasks, or shift concurrent tasks to create less overlap. 
  • Any point at which the resource is being used very little may point to inefficient under-allocation. Consider decreasing the task durations or using fewer total resources.




One thought on “How to Allocate Resources in Microsoft Project

  1. Pingback: Estimating Resource Requirements using Microsoft Project | Tech Currents

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s