Out of the box approach to simulate resource allocation – did you know that?

As Resource Manager sooner or later you will face the need to simulate scenarios to anticipate resource assignments. Microsoft Project offers you a possibility to do that with based on standard functionality. I guess this option ist not very common, so I would like to share it with you.

While for task management you could use active and inactive tasks to simulate the impact on your schedule for resource management this would be far too complex. So this is how you can simulate resource assignment scenarios:

Step 1 – create a simulation plan

    • Open your client and start with an empty project plan to create a simulation plan.
Create a new and empty plan
Create a new and empty plan
    • Add projects to your simulation plan.
    • In order to do this use the Insert Subproject functionality in the ribbon. But be careful, do not just select and open the projects. You also have to unselect the checkbox “Link to project”.
Then insert the original plan in the simulation plan
Then insert the original plan in the simulation plan

Please note: When you add subprojects while the option “Link to project” is not set the whole project plan will be copied into your simulation. With the option set there would be only a link to the external project created and each change in your simulation would affect the original plan as well. This is not what we want to achieve and you will certainly annoy some project manager. So make sure you don’t accidently enable this feature.

You should also use enterprise resources to benefit from this approach! With local resources in your plans there are no resources and analysis views available in the Resource Center.

Step 2 – Prepare the simulation

    • Open the Resource Sheet
    • Change the booking type for all resources from “Committed” to “Proposed”
Overbooked resources in the resource sheet
Overbooked resources in the resource sheet

With this option the simulated assignments are filtered out in the availability views in the Resource Center but can also be included.

In the actual plans all assignments are committed, in the simulation plan just proposed. This assures that no interference with the actual planning will occur. (And easy to guess that the resources are initially overbooked as we doubled the planned work by creating the simulation plan).

Step 3 – Run the simulation

After the simulation plan is published to the server the resource manager can work with the availability views to identify overallocation. Of course at this stage of the simulation we have the resource booked twice: In the actual plan but also in the simulation plan. To visualize that in the availability view the option “Include proposed bookings” should be set.

    • Set availability view option to “Include proposed bookings”

Now here comes the simulation part! The resource manager – that means you – changes dates, assignments, resources – basically everything he wants to simulate – and publishes the simulation plan again. And here we want to simulate a later project start. Project makes this also very easy for us:

Move your simulation to a new start date
Move your simulation to a new start date


In the availability view we can now see that the overallocation can be resolved if the project would run later.

Original and simulated project plan side by side
Original and simulated project plan side by side

Setup different simulation plans for each project and work with the filter in the availability view to identify the simulation which fits best.

Here we can clearly see that in the original planned timeframe the project would cause an overallocation but with the delay it fit’s better in the capacity of the resource!

You can now inform the project manager based on the results of his simulation, when the project should start and which resources can be assigned. The project manager will then adapt his planning.


As you can see you are able to simulate resource assignments with Microsoft Project standard functionalities. The benefit is obvious: As a Resource Manager you are enabled to simulate different scenarios and anticipate bottleneck situations.

But of course this approach has some limits. The more scenarios you wish to analyze the more sophisticated your approach has to be. For one customer I wrote therefor a VBA module and placed it in the ribbon to support this function and made his life as a Resource Manager easier.

Stay tuned for more related content. Please feel free to write me if you have questions or additions.

Requirements for this approach

  • The resource manager needs to right to save his own simulation plans on the server.
  • The resource manager needs read access to the projects he wants to run the simulation on. To achieve this a proper RBS should be set up and based on the category setting the resource manager will then have read access to all resources below his own RBS node.
  • It’s recommend to introduce a separate enterprise project type (EPT) for simulation plans.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s