Rich's profilePMConnection ArticlesBlogLists Tools Help

Blog


    July 09

    How to Overlay Committed and Proposed Resource Information within the Resource Graph of Microsoft Project

    Definitions:

    Committed - A resource that is formally allocated to any task assignments they have within a project. This is the default booking type.

    Proposed - A resource with a pending resource allocation to a task assignment that has not yet been authorized. This resource assignment does not detract from the availability of the resource to work on other projects.

    1. Within your schedule, click on >View, >Resource Sheet
    2. Insert the column Booking Type
    3. Code your resources either Committed or Proposed

    clip_image002

    1. Develop your schedule assigning resources to tasks

    clip_image004

    1. Click on >View, >Resource Usage
    2. Click on >Window, >Split
    3. Click anywhere on the bottom pane to activate

    clip_image006

    1. Click on >View, >Resource Graph

    clip_image008

    The Resource Graph will now appear in the bottom pane. Note that this shows a graph for Peak Units. (this is not the graph we would like to leverage)

    1. Right click in the TimePhased portion of the Resource Graph and click on Work

    clip_image010

    1. Right click in the TimePhased portion of the Resource Graph again and click on Bar Styles. The following dialogue box will appear:

    clip_image012

    1. Under Selected resources, for Overallocated work (left side) show as Bar. For Allocated work, show as Bar. For Proposed Bookings, Show as Bar.
    2. Under Resource, for Overallocated work, Show as Don’t Show. For Allocated work, show as Don’t Show. For Proposed Bookings, Show as, Don’t Show. As a final step, check the Show Availability line. Here is how the dialogue box should be configured:

    clip_image014

    Click on OK!

    1. Now, click on the first resource name and lets examine the screen.

    clip_image016

    1. Now click on the second resource name, and let’s inspect this view.

    clip_image018

    1. Now click in the blank square in the upper left corner (above the ID number) to select all resources.

    clip_image020

    1. Before leaving this exercise, let’s look at one more scenario. Let’s play with a Role.
    2. On the Resource Sheet, set Resource 2 Booking Type to Committed. Then add a resource named Role 1. Set the Booking Type to Proposed….AND…the Max Units to 0%.

    clip_image022

    1. Now let’s say two new tasks are identified for our project. We are not sure exactly which resource we want to assign to those tasks yet, so we assign Role 1.

    clip_image024

    1. Moving back to our combination view of Resource Usage on top and Resource Graph on bottom, let’s examine the details.

    clip_image026

    By clicking on Role 1, we see there is 40 hours of Proposed Work for the weeks of July 6th and July 13th. But notice there is no Availability line. This is because Role 1 is actually a placeholder and has no 0 hours of availability. We need to figure out which resource we can assign these tasks to.

    1. Now hold down the Control Key and click on Resource 1.

    clip_image028

    From this graph we see that if we moved this work from Role 1 to Resource 1, Resource 1 would become overallocated. We would be asking Resource 1 to do 80 hours worth of Work for the weeks of July 6th and July 13th.

    1. Let’s see if Resource 2 could handle the Work. Click on Role 1, hold down your Control Key and click on Resource 2.

    clip_image030

    Upon examining this graph, we can see that Resource 2 has the availability to handle this Proposed Work.

    EXTRA: How to easily transfer the assignments from Role 1 to Resource 2.

    1. Click on the row to highlight Task 5.

    clip_image032

    1. Hover over this row within the indicator column. You will see your cursor turn into 4 arrows. Now hold down with your left mouse button and drag this task until it is under Task 4. Release the left mouse button.

    clip_image034

    1. Click on the row to highlight Task 6. Hover over this row within the indicator column. You will see your cursor turn into 4 arrows. Now hold down the left mouse button and drag this task until it is under Task 5. Release the left mouse button.
    1. Click on Resource 2

    clip_image036

    Notice that Role 1 no longer has any assignments. Resource 2 has all 4 assignments and the graph indicates all this work can be done without causing Resource 2 to be overallocated.