Resource Requirements Plan Excel Template

Resource Requirements Plan Excel Template: Download

View other templates here: Excel Templates

This template does not contain macros/VBA code.

rp1

Directions:

Modify the resource names under the Resources section to your desired names. For additional data purposes, you can enter in how many hours you expect the resource to be made available to your project in the white boxes above the resource name. This is not important, it is purely optional and it later calculates their utilization balance.

rp2

Modify the task names. You can add in the month you plan to complete the task, as well as expected start and completion dates. Your Estimated hours to complete field will autocomplete based on what you enter under your resource names. Optionally filling in the actual effort will complete a graph that compares expected to actual hours (Plan Effectiveness).

rp3

As you fill in the hours under each resource, Estimated Effort Hours autocompletes and it tallies up total hours below. If you optionally used the resource Available Hours it will determine whether you have overutilized or underutilized the resource.

RP4.png

RP5.png

Once completed, go to the Resource Plan sheet. On that sheet is a Pivot Table and Chart. You will need to right-click and select refresh to bring over the data.

RP6.png

Once the data is refreshed, you will see it all. You may need to sort to clean things up some, and as you change the resource names you may have to make sure they get included in the pivot table.

RP7.png

This is where placing in the month is important as well, the data sorts it based on a month by default. If you are comfortable pivot tables, you can change this up some or add to it.

RP8.png

As you progress through your project and you optionally complete the Actual Effort Hours, you can switch to the Plan Effectiveness sheet and it will display a chart comparing Estimated Effort to Actual Effort.

RP9.png

 

Advertisements

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: