Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Project Management

Create a resource management model in Microsoft Project 2007

By Dr. Andrew Makar September 21, 2010, 10:40 AM PDT

Image
1
of 8

ProjectResourceModel_Figure_1.jpg
ProjectResourceModel_Figure_1.jpg
Create a resource management model in Microsoft Project 2007

WBS using Matchware MindView

WBS using Matchware MindView

I received an email from an employee in the United States Central Command inquiring about how to use Microsoft Project to track personnel on a military base and monitor resource levels as units deactivate during a base closing. The goal was to measure the total number of personnel at any given point in time and track the resources as the base downsizes.

I developed a quick resource management model in Microsoft Project 2007 that will produce this information. Since Microsoft Project supports resource assignments and resource pools, developing an ongoing model was relatively easy. This example creates a work breakdown structure (WBS) that is comprised of teams or units that are allocated to different tasks.

This TechRepublic gallery is also available as an IT Leadership blog post.

Step 1: Develop the WBS

The first step is to develop a WBS that resembles the location hierarchy. I like to think visually before detailing the work in Microsoft Project, so I used Matchware MindView to develop a hierarchical WBS.

The base (the top level WBS deliverable) was divided into regions. Each region was comprised of specific buildings, and each building was further defined into specific floors. A general term “location” could also be used if resources were not assigned to a specific building but rather another ambiguous sub-region. The level of detail can be extended to individual offices or cube locations.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

WBS in Microsoft Project

WBS in Microsoft Project

Once I had a visual breakdown of the base locations, I exported the model into Microsoft Project. I could have used MindView to assign resources and dates, but I chose to detail the WBS further in Microsoft Project due to the number of resources that would be added to each location or building.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Project start date

Project start date

Step 2: Set the project start date

As each location is assigned a decommission date, you’ll want to have the correct project start date in Microsoft Project. To set the project start date, go to Project | Project Information and select the desired Start Date from the drop-down menu.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Resource pool

Resource pool

Step 3: Define the resource pool

The next step is to define all the resources that currently occupy the base. Since this could extend to several hundred or thousand resources, you may want to import them from an Excel extract of a resource management system. Follow these steps to customize the resource sheet:

1. Go to View | Resource Sheet.

2. Right-click these columns and select Hide: Type, Material Label, Max Units, Standard Rate, Ovt. Rate, Accrue At, and Code.

3. Enter a name and a team name in the Resource Name and Group column.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Assign Resources

Assign Resources

Step 4: Assign resources to locations

Now you should switch back the Gantt Chart view and assign resource names to the specific buildings in the WBS. Resources can be assigned by selecting the names from the Resource Name column or using the Assign Resource dialog box. Simply click the task and press [Alt][F10] to display the resource box.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Decommission schedule

Decommission schedule

Step 5: Assign location decommission dates

With your resources assigned, the next step is to either enter the duration it takes to evacuate the building or select a target Finish date. If this is a simple planning scenario where a specific building would be decommissioned, then a Finish date would be selected. If there are building dependencies for each building, then task predecessors may be used.

It is assumed that all the resources are assigned to the building at the start of the project, so all tasks should have the same Start date. By selecting the decommission date, the Finish date will be populated. This figure depicts the completed schedule with target dates.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Bar Styles options

Bar Styles options

Step 6: Set up the resource graph

The final step in setting up the model is to change the resource graph.

1. Go to View | Resource Sheet.

2. Go to Window | Split.

3. Click the lower window pane and select View | Resource Chart.

4. Right-click the Resource Graph and select the Peak Units graph.

5. Right-click the Resource Graph and select Bar Styles.

6. Under the Selected Resources section (left-side), change the Overallocated and Allocated Resources Show As options to Area.

7. Under the Resource section (right-side), change the Overallocated and Allocated Resources Show As options to Don’t Show.

8. Confirm the options are the same as in this figure and click OK.

Screenshots by Andy Makar for TechRepublic

Create a resource management model in Microsoft Project 2007

Resource curve

Resource curve

Step 7: View the resource graph

With the resources selected and assigned to specific buildings, you can view the resource ramp down curve overtime. By clicking the magnifying glass in the lower resource graph pane, you can view the resource allocation over time. By selecting multiple resources in the upper pane resource sheet, you can view the specific resource curve for each resource in the model.

The horizontal axis of the resource curve provides the resource count over time. Over the five month time span, the graph starts with 23 resources and gradually reduces to zero when the base closes. The horizontal line at the top of the graph represents the original resource level at the start of the project. By adding more resources and filtering on specific team names, project managers can view individual, team, and entire resource pool curves.

Download the .mpp file

If you want to download the baseShutdown.mpp file, you can access it on my site. In my next article, I’ll show how to interpret the resource management model and use several views to manage the resource decommission.

Screenshots by Andy Makar for TechRepublic

  • Project Management
  • Account Information

    Share with Your Friends

    Create a resource management model in Microsoft Project 2007

    Your email has been sent

Share: Create a resource management model in Microsoft Project 2007
Image of Dr. Andrew Makar
By Dr. Andrew Makar
Dr. Andrew Makar is an IT program manager and is the author of How To Use Microsoft Project and Project Management Interview Questions Made Easy. For more project management advice visit http://www.tacticalprojectmanagement.com.
  • Account Information

    Contact Dr. Andrew Makar

    Your message has been sent

  • |
  • See all of Dr. Andrew's content

TechRepublic Premium

  • TechRepublic Premium

    Office relocation checklist

    PURPOSE New office launches and site relocations run the range from straightforward to overly complex. For intricate, sophisticated new office deployments and larger site moves, TechRepublic Premium’s Office relocation checklist can help plan, monitor and execute such projects. From the checklist: LIST REQUIRED OF EQUIPMENT AND SERVICES Begin by creating a simple list of required ...

    Downloads
    Published:  May 25, 2023, 4:00 PM EDT Modified:  May 26, 2023, 11:17 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Onboarding and offboarding IT staff checklist

    PURPOSE Onboarding and offboarding employees requires careful attention. Otherwise, team members may receive insufficient permissions to perform their jobs or continue to have access long after their employment’s termination. Given the stakes, the problem is even worse when managing IT staff permissions, so it’s imperative that your company adopts a system to ensure consistency. Employees, ...

    Downloads
    Published:  May 24, 2023, 4:00 PM EDT Modified:  May 25, 2023, 9:19 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    10 must-know Firefox tips

    PURPOSE TechRepublic Premium presents 10 tips for the Firefox open-source browser. Even if you only follow some of these, you’ll find your browser experience to be much improved. From the article: 1. USE CAUTION WITH ADD-ONS AND THEMES This is one of the first tips I always offer. I’ve seen web browsers with so many ...

    Downloads
    Published:  May 23, 2023, 4:00 PM EDT Modified:  May 24, 2023, 6:46 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Bring your own device policy

    PURPOSE The purpose of this Bring your own device policy from TechRepublic Premium is to provide requirements for BYOD usage and establish the steps that both users and the IT department should follow to initialize, support and remove devices from company access. These requirements must be followed as documented in order to protect company systems ...

    Downloads
    Published:  May 22, 2023, 4:00 PM EDT Modified:  May 23, 2023, 7:26 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice