Hey readers, Here is another post for you to bite into. This post is about using Max units in Microsoft Project. And if you are not familiar with the term max units, don’t worry I’ll start with a little explanation. Here we go.
What are max units?
Well let’s have Microsoft itself describe this resource field first:
The Max Units field contains the maximum percentage or number of units (units: The quantity of a resource assigned to a task. The maximum units is the maximum number of units available for the resource. For example, if you have three plumbers, the maximum units is 300 percent or three plumbers working full-time.) representing the maximum capacity for which a resource (resources: The people, equipment, and material that are used to complete tasks in a project.) is available to accomplish any tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.) during the current time period. The default for the Max Units field is 100 percent.
Awesome, any questions? Now let’s complicate the definition a bit, because the Microsoft site doesn’t talk about (resource)calendars although it’s a big deal.
Calendars and max units
Lets have a little nuance with the plumbers example. You are able too create a calendar for a resource with part time availability and still have resource with max units 100%. Let’s say you have Dave, Mario and Bill the plumbers (All characters appearing in this post are fictitious. Any resemblance to real persons, living or dead, is purely coincidental 🙂 )
- Dave works for the company, has a desk job, but will do some plumbing twice a week.
- Mario is a full time plumber (and occasionally wears a red had and has a thick mustache).
- Bill is also a plumber, but doesn’t work on Monday’s.
Now if I would count the max units of these people for a plumbing project I would get 240%.
- That’s 40% for Dave because he works as a plumber just 2 days a week but can do other work during the rest of the week, 2/5 = 40 percent.
- Mario is a full time plumber and will therefore have 100% of his time dedicated to the project.
- Bill doesn’t work on one day, but during the 4 day’s that remain he will still have 100% of his time dedicated to the plumbing cause.
Here’s how it looks in Microsoft project 2013, when I give the guys a job that needs to take 10 days (fixed duration):
Here’s what the same situation looks like in Microsoft Project 2013 for the individuals if they all get 40 hours of plumbing work to do (fixed work):
Now here something strange happened; why does Bill still have a 5 day duration in his task? As long as the task has only one resource assigned to it, and the task is in a “fixed work” mode, the duration will show the amount of working days Bill will be able to work on the task, and NOT the amount of days according to the project calendar day’s.
As soon as you change the task type to fixed duration you will see the following changes happen to the task:
I could explain these changes as follows: A fixed work task looks at the calendar of the resource, where the resource availability leads the amount of “work days duration”. A fixed duration task looks at the project calendar, and the duration changes because Bill just doesn’t work on all the project calendar day’s so the duration lengthens. Now for some more trickery, let’s set the button that ignores Bills calendar :). You can find this option (that only works when you set a calendar on a task) in the Advanced tab in the task information. Starting with the version where the task is set to fixed work. This will be your result:
And now we tell Bill, forget about your Monday off, we need you bro! And we get a nice little burning man (that’s Bill’s burn-out in case you were wondering). And the task has a nice little message telling you that you told MS Project to ignore the resource calendar. Let’s have a look at the situation when you had the task on a fixed duration (with 7 day’s remember?) and set the task to ignore the calendar of the resource:
Wooohoo, would you look at that! Damn that doesn’t look like something you would like to see at all! But hey, it can be explained: We had a fixed duration, ranging from 19 January until 27 January, this was the time that Bill needed to do his job taking the Monday’s off into account.
But now we say “Microsoft Project, ignore his calendar and make him work on Monday’s as well”. Now MS Project tells you: “Hold on, this guy needs to work on Monday, sure he will be over allocated for that day, and will be finished working on the Friday that follows, because he has 100% units available. And you also have a fixed duration, so I’ll show you a dotted line until the 27th. But don’t worry Bill won’t work on those days.”. Sounds reasonable right?
The duration was fixed, that means the end date of the task doesn’t change. How would you get the actual finish date for that resource? Just change the task type to fixed work and the task changes to the intended finish date. You will now be able to change it back to fixed duration by the way.
I would like to cut this post short here. I know there is a lot more to tell about Max units, however it would be best to pick these subjects in follow up posts.
I have tackled the Unit vs peak unit situation that is new since the 2010 installment of Microsoft Project. Here is the link to this post.
I also created a post where I look into the use of unit’s instead of using resource calendars; I use this a lot with municipals and other companies that are more interested in the broad availability of resources instead of knowledge that Bill the Resource doesn’t work on Monday.
So there will be at least two follow up posts coming up. I will share the links in this post as soon as they come available. Do you have a specific question about Max. Units and would like me to elaborate on it in a blog post? Let me know in the comments and I will see what I can do for you.
If this is your first visit to my blog, go ahead and check out the resource page, it’s a page where I share the best content I have found on the web about Microsoft Project, Project Server and Project Online. Or check out the book reviews I’ve done if you would rather get hold of a good book on the subjects.
And lastly: Thank you all for reading the post! I really enjoyed writing it and look forward to the next ones that will dive even deeper into the subject.
Erik van Hurck