This 2-part question is from Mark Moeller of Woodinville, WA, USA:
I have two different resource assignment issues to solve:
1) I have a resource who needs to be on a project 25% of their time for the entire project, regardless of when it starts or ends. How do I set that up?
2) I have a fixed pool of days of work that needs to be spread evenly across 'n' resources for the duration of the project. This should then take away some small fraction of availability of those same resources for other tasks (basically allocating specific overhead tasks). How do I do this?
As Mark is looking to schedule resource work over the entire project’s duration, the temptation would be to simply use a project summary task. Unfortunately, a project summary task isn’t really a task at all. It is merely a mechanism that rolls up duration, work and cost from the “real” tasks within the project.
What Mark therefore needs to help him is a “Hammock” task. Hammock tasks (as they are commonly known) span between two parts of a project. In Mark’s case this is between the project’s start and end dates; but hammocks can be used to span between any two points within a project’s schedule. Once created, resources can be assigned to hammocks to represent project overheads. Creating a hammock task is a fairly straightforward thing to do:
1. Create a summary task at level 1 of the project’s outline. If you create this task at the top of the list of tasks or at its base, this will make the summary task easier to identify.
2. Hierarchically beneath this summary task, add two Milestones with no fixed dates against them; i.e. their Constraint Type is ‘ASAP’. Give these milestones recognizable names; such as. “Hammock start” and “Hammock end”.
3. Within the main body of the task list create two milestones entitled “Project start” and “Project end”. Ensure these milestones are linked to the first and last tasks (or summary tasks) within the project respectively. Ideally, these milestones should not be embedded within a summary task.
4. Create an F-S link from your “Project start” milestone to your “Hammock start” milestone. Repeat the process for the “Project start” and “Hammock end” milestones.
You will now have created a hammock task. It will start when the project starts and it will finish when the project finishes. Any change to the start and finish of the project will automatically be reflected in the hammock’s duration and its dates. The next step is to assign some resources:
- To reflect assigning 25% of a person’s time over the project duration, simply assign that person to the hammock task, choosing 25% as the Assigned Units value. You can use the Assign Resources dialog or a Task Form to do this. As the hammock is a summary task, it is Fixed Duration in type. As such, the work for the resource will be calculated as Task Duration x Assigned Units. All this useful information is displayed within the Task Form view
- To assign work for several resources out of the pool, these resources can also be assigned to the hammock. Due to the scheduling rules regarding summary tasks, their non effort-driven status means that all assignments against summary tasks are independent of one another. Thus, Mark will have to apportion the total work for the pool between each pool member. This in turn will calculate the assigned units by the formula: Assigned Work / Task Duration = Assigned work. The remaining availability for each resource can then be seen within the Resource Usage view.
Download scheduling_projectwide_resource_overheads.mpp
Project Plan notes:
- The start of the hammock task is controlled by the “Project start” milestone as this is the earliest task in the project’s schedule. The end of the hammock could be controlled by either the “Project end” milestone, or the end of “Summary B” (chosen in this case for illustration purposes), as either of these are scheduled at the end of the project.
- All resources within the resource pool have max units (availability of 100%). The resource Usage view illustrates:
- The resource “Management resource” is assigned to the hammock task at 25% units to represent an overhead against the project. The assignments at 75% for this resource against “Task A1” and “Task B2” show work against real tasks and illustrate how remaining availability can be consumed.
- The resource “Pool Member 1” does not exceed their max units. This is because the sum of the assignments for this resource against parallel tasks “Task A2”, “Task B1” and “Hammock” is less than 100%.
- The resource “Pool member 2” is overallocated. This is due to an assignment at 100% units (the default) against “Task B1” and an 8% unit assignment against “Hammock”. You should therefore be careful not to allocate any resource greater than their remaining availability when resource overheads are being scheduled.
- To display Remaining Availability within the Resource Usage veiw, simply select this option by choosing Details from the Format menu.
- The Gantt Chart view has been customized to highlight the hammock task to differentiate it from normal summary tasks. In this instance, the Bar for “Hammock” has been formatted to a different bar shape and Resource Names have been appended as bar text.
This useful hint and tip came from Project Mentor, our computer based training package for Microsoft Project.
Posted by Andy Jessop
