Resource leveling by hand using Microsoft Project | TechRepublic - Feature-specific data

Looking for:

A Beginner’s Guide to Resource Leveling in MS Project - MPUG 

Click here to DOWNLOAD

     

- Microsoft project 2010 leveling resources free

 

How would you feel about someone else doing a job for you and not charging you a penny? Well, then you would likely be pretty angry. The resource leveling feature in MS Project is somewhat similar. You will fall in love with it if it works for you, but in most cases, it frustrates people to no end. Resource leveling is a hotly debated topic among MS Project experts. Some people say that no one should ever use it, while others say that you should use it only if you understand the consequences.

So, what is the reality? Resource leveling is an advanced feature in MS Project. In my opinion, you should not dabble with it unless you understand it properly.

I have written this article to tell you how you can use resource leveling to optimize your project schedule. You can also read best practices of Resource leveling for a deeper understanding of the subject. Resource leveling is used to remove over-allocation of project resources. This is done by adjusting the scheduled dates of project activities. There are several methods to employ, which we will consider in the following paragraphs.

Resource leveling can be done manually by analyzing various different views of MS Project simultaneously and then adjusting the dates of tasks to remove over-allocation. The manual method of analyzing various views simultaneously is cumbersome and tedious. It requires a lot of time and effort. Resource leveling is not just about delaying a task; it involves analyzing scheduled dates of predecessor and successor tasks also.

Delaying a task can delay many other dependent tasks that are assigned to other resources. This can over-allocate other resources and eventually spoil the whole project schedule just as is possible with the automated option. Fortunately, there is a better, automated way to do resource leveling through MS Project. It is not possible for a human brain to analyze millions of permutations in a short period of time, but computer software in this case, Project can simultaneously look at relationships between hundreds of tasks and calculate a highly optimized schedule in a flash.

You should first ascertain that resources are over-allocated before doing the Resource leveling. This can be done by one of the following two ways:. Look at the Information column in the Gantt chart view. It will have a red resource icon suggesting the over-allocation of resource s in a particular task. Once you confirm that some resources are over-allocated, you can go to Level group in the Resource tab to remove the over-allocation.

Level resources allocated to the selected tasks. Level a particular resource. Level all the resources in the project. Automated Resource leveling is a great feature, as it optimizes resource usage in a matter of seconds. However, it has some limitations. In those cases, manual leveling becomes useful. MS Project does not change the resources assignments of a task. Sometimes, it is more prudent to assign free resources rather than remove the over-allocation.

Secondly, automation can level work resources only. It cannot level other type of resources, such as material and cost resources. Have you done Resource leveling in your project?

Did you use a manual approach or automated method? What was your experience? I would love to hear your comments below. Praveen Malik, PMP, has two-plus decades of experience as a project management instructor and consultant.

He regularly conducts project management workshops in India and abroad and shares his project management thinking in his blog, PM by PM. Review Title. Your Review. Sign me up for the newsletter. Remember Me. Please enter your username or email address. You will receive a link to create a new password via email.

Quick Links. The Manual Method Resource leveling can be done manually by analyzing various different views of MS Project simultaneously and then adjusting the dates of tasks to remove over-allocation.

This can be done by one of the following two ways: 1. Go to the Resource Sheet view. The rows of over-allocated resources will be displayed in red. Before leveling the resources, take a look at the Leveling options and change them as needed. The Leveling options are: Automatic vs Manual: MS Project performs automatic leveling as soon as a resource or a task is changed.

Manual leveling is done only when you ask MS Project to do so. I would suggest you to use Manual leveling as it is a much safer option.

Automatic leveling can be befuddling as MS Project makes real-time changes to your tasks in response your changes without asking you for the confirmation. Clear leveling values before leveling: If this checkbox is checked, then MS Project clears the leveling values of existing tasks and starts afresh each time leveling is done.

This should be left unchecked if you are doing Automatic leveling as it will hog your computer resources. Leveling range: You can either level the entire project or tasks between specified dates. Leveling order: There are three options here. I would suggest you avoid this, as it has no practical utility. Standard: MS Project uses a combination of predecessor relationships, slack, priorities, and constraints to level the resources.

Priority: MS Project gives higher precedence to tasks with priority and then uses the Standard algorithm for leveling the resources. After setting the Leveling options, you can level resources in one of the following ways: 1. Conclusion Automated Resource leveling is a great feature, as it optimizes resource usage in a matter of seconds. Written by Praveen Malik. Share This Post. You May Also Like. Excel Data Visualization — Lesson 2 Transcription.

Customer Reviews. I am checking all my plans now to ensure leveling is manual calculation only. Thank you for taking a complex subject and making it easy to understand!

The post is useful. Thanks for your sharing. Leave a Reply Cancel Reply Your email address will not be published. Sign In. Lost Password. Lost Password Please enter your username or email address.