Recently, there was a question on the Project Server Forum (Click here) about being able to “plan” allocations on projects that do not need/have a detailed schedule. Think of work like Support work, Unplanned work and so on.
The twist here was that, while the allocations were ‘planned’, it was also necessary to track actuals, without disturbing the ‘plan’.
First of all, I would recommend you to watch this video of the presentation (around 12 min mark) done by Project MVP Cindy Lewis at the Project Conference 2014, on using Resource Plans to plan operational work. What I intend to do in this blog post, is to take it one more step further and see how we can extend that technique into allowing the actuals to be tracked.
The standard way of planning Operational work is to create a schedule with ‘buckets’ of work, pre assigned to people, at certain %, so that that capacity is ‘reserved’ before ‘projects’ start consuming the capacity. The Operational Plan will look something like this:
In the above example, you can see that the resources are reserved at 30% (or 20%) for the rest of the year, and other projects could be planned for the remaining availability (70%).
This technique works great until, resources start logging time against these tasks using Timesheets/Tasks in Project Server. Because the Actual Start/Actual Finish Dates could be different, the %work complete could be different than planned, these tasks start moving accordingly, thereby affecting the ‘planned’ allocation. Now the owner of the operational plan has to start ‘maintaining’ this plan to make sure that the allocations planned remain the way they should.
So, over time, after trying several approaches, I have come to the conclusion that this is not the most efficient technique to plan operational work (when you need actuals against those tasks). Using a Resource Plan is in my opinion.
The concept is simple. You build the Resource Plan for the project, as below and indicate the allocation you plan. ( Cindy’s video walks through the process of creating the Resource Plan).
Make sure the Resource Utilization is set to use the Resource Plan. So, once published this Resource Plan will indicate that the capacity is reserved for whatever hours that are shown above, for those resources.
Now here is the kicker. To track Actuals, here is what you do:
- Open the corresponding schedule and add tasks (or buckets).
- Add the resources to the team on the schedule.
- You can assign resources or they can add these tasks to their timesheet, as long as they are part of the team
- Important: Leave the resource utilization for this plan to ALWAYS be from Resource Plan.
So the schedule might look like this (It could be structured any way, does not matter).
If you are talking about ‘Unplanned’ work, the resources can actually request new tasks from timesheets/tasks as well.
The bottom line is that, with this approach, the resource utilization will ALWAYS show as indicated in the resource plan, no matter what happens with the Actuals.
And finally, a report could easily be developed to compare Resource Plan work with Actual Work, so that if somebody is spending way more time than planned on Operational Work, corrective steps could be taken.
This, I know will relieve the need for every day maintenance of these ‘operational’ plans for the owners.
May 19, 2014 at 12:34 pm
Excellent article Prasanna!! I bookmark it! It would be a goof idea if we could share your article directly on LinkedIn, they are really bringing added value to EPM world!
May 19, 2014 at 1:01 pm
Guillame,
Thank you for taking time to comment! I will look into adding the share buttons. BTW, this artcle has already been featured on Microsoft's project linkedin page here (https://www.linkedin.com/company/3580488?trk=NUS_CO-logo)
June 19, 2014 at 5:05 pm
So while this will work to preserve time for operational work, there's no way to set per-project-percentages too. RIght? For example, if a Resource Manager wanted to allocate a resource 25% to Project A, 25% to Project B and 50% to operational work, your method here will take care of the 50% operational work. But there doesn't seem to be a solution to control the per-project allocations. Max Units from within the Resource Center applies to ALL projects.
June 19, 2014 at 5:09 pm
Kevin,
You could use the same approach of Resource Plans to allow Resource Managers to 'Allocate' resources to a project, and have capacity calculate from there. When the PM is ready to assign real work, they can change the allocation to be calculated from project plan.
The only downside of this approach is that, when the PM's are assigning tasks, the assignment will happen at the max units value. This can be changed a) by resetting the max units value immediately after opening the project each time (or) change the assignment units to match the allocated values after all assignments are done. Hope this helps!
June 20, 2014 at 11:43 am
So while this will preserve time for operational work, per se, there's no solution to allocate resource percentages per project. Right? If a Resource Manager wanted to allocate a resource to two project and operational work as 25%, 25% and 50%, your solution here will support the 50% for administrative time but there's no way to control a resource's allocation PER PROJECT. Max Units could be set to 50% in this case but I can't do anything at the project level (25%). Right?