Resource Leveling in Microsoft Project
In this article we take you through 3 examples of how to level rescources in MS Project. Start by looking at the project in the Resource Usage view. In image below you will see that three Resources are over allocated. This means that:
- the project schedule is incorrectly planned; and/or
- your resources really are literally over allocated; and/or
- your resources have been incorrectly set up for this project.
In fact, in this project all these factors exist and are causing the project to be incorrectly represented and scheduled.
Need to learn MS Project? Why not join one of our small Microsoft Project training classes in Los Angeles call us on 888.815.0604.
- Check the first over allocation for Bryan Hayden.
In the resource usage view you can see quite clearly that there are a number of days where Bryan is working more than 8 hours a day.Either the allocation is illogical, or he is simply working too many hours, which could lead to high extra costs or work not being completed.
Analysis of the Resource Usage view will show that from 9 September Bryan is spending 8 hours per day viewing available plots. This means that if he is required to undertake another task during the day he will appear over-allocated on the system, which is clearly illogical.
To resolve this over-allocation
The link between tasks 3 and 4 is Start to Start. Whilst it is true that task 4 (make an offer on a plot) can come at any time within the one month period that has been allocated to viewing plots, it cannot take place, logically, until viewing has stopped.
One solution here is to make the link between the tasks Finish to Start. That is to say that, although we do not know when viewing will finish (i.e. when a suitable plot is found), it must be finished before the next task (making an offer) can start. In your own planning you might consider various other ways of restructuring the project. For example, the omission altogether of the task called ‘Make an offer’ and consider it as part and parcel of the Viewing task. In which case, the next task would be Pay Deposit.
This would be a partial, and logical solution. However, you would still end up with the same problem regarding a finish to start link, unless you physically moved the next task or allowed an over allocation.
For the sake of this exercise, let’s assume that Bryan will stop viewing when he makes an offer. So on the Gantt Chart, double click the link line between tasks 3 and 4 and change the relationship to Finish-to-Start:
You will note that the resource, Bryan Hayden, is no longer over allocated.
Check the over allocation for the Amenity Contractor.
This resource is committed to a total of three tasks simultaneously and at 100 % availability. However, this resource is a contractor and, as per the Resource notes ‘Has own workforce for projects’.
Since this resource CAN work on three tasks simultaneously due to having his own resources and team, we can set his percentage availability to 300% - on the Resource Sheet increase the percentage and then note that this clears the over allocation of this resource.Need onsite Microsoft Project training?
The third over allocation is the Architect.
Checking the logic of the tasks on the Gantt Chart - it makes sense that:
- Build Double Garage is dependent on the finished tasks of: Design Double Garage and the Installation of Amenities
- Build House is dependent on Design House.
- Build Swimming Pool is dependent on Swimming Pool.
The problem is the lack of resources - since we only have one architect, he/she cannot work 100% on three different tasks simultaneously and therefore we need to change the sequence of the tasks.
- In the Gantt Chart, change the Design Garage Task to Manually Scheduled and type a start date of 13 Oct
- Change the Design House Task to Manually Scheduled and drag the Gantt bar to the right to fit when the architect is available (this is the same as typing in a date)
This should solve the over allocation problem and your project should look similar to the following will all resources 'levelled':