Project Resource Capacity Planning

Moderator: kwalford

New Member
New Member
Posts: 2
Joined: Tue 09 Feb 2016 8:48 pm

Project Resource Capacity Planning

Postby Keith_Harrison » Tue 09 Feb 2016 8:59 pm

Hello, this is my first post. Hopefully, it will be both useful to me and those reading.

I've attached a tool I put together for Resource Capacity Planning, which forms part of this discussion. PLEASE FEEL FREE TO USE FOR YOUR PROJECTS IF YOU LIKE IT.

(50.56 KiB) Downloaded 1653 times

I wanted to gauge opinion on the best tool for Project Resource Capacity planning, as I have seen many different tools used and in the main, none seem to tick all boxes. For instance, MS Project is great to accurately capture all resource variables, however navigating between Resource Sheet, Resource Usage, Tracking Gantt...and so on just makes visualising and forming an overall picture of the 'state of play' a huge faff.

I suppose this question will have different answers depending on context too, as you'll see from the template I have attached. Sometimes a simplistic approach is needed and sometimes a more all-encompassing and detailed approach is needed.

But please let me know you thoughts on best systems, tools, templates for Resource Capacity Planning and in what scenarios. Please fire back comments on my template too, if you find it useful or if not.


Full Member
Full Member
Posts: 3
Joined: Fri 19 Feb 2016 2:06 pm

Re: Project Resource Capacity Planning

Postby Fuzzynavel » Fri 19 Feb 2016 2:15 pm

It's not too difficult in MS Project 2010 to set up custom reports if you need to produce the same or updated datasets frequently.
You can also set up the view so that you can see a couple of the resource elements at the same time.

New Member
New Member
Posts: 1
Joined: Tue 13 Sep 2016 7:39 am

Re: Project Resource Capacity Planning

Postby katyeileen » Tue 13 Sep 2016 7:44 am

Hi Keith,

Your Planner is extremely helpful, thank you so much for sharing - I've been looking for something exactly like this!

I was wondering, there are a few protected cells in the worksheets - would you be kind enough to share the password also? (I'm considering to make this a 12 monthly plan, which would suit better for our needs).

To your particular question - I've been finding it difficult to find something this simple - I would prefer to avoid MSProject, as our team really just needs a solid overview of FTE's allocation to projects (both owned & not-owned by our function). So far, I have managed to find a wealth of the more complicated templates (and by which time, I think it is easier just to USE Project), but again, I've not found any others as simple as yours.

Thanks so much again!!!

New Member
New Member
Posts: 1
Joined: Wed 30 Nov 2016 9:20 pm

Re: Project Resource Capacity Planning

Postby Ashooks » Wed 30 Nov 2016 9:37 pm

Hello Keith,

Your worksheet is very helpful. Are you willing to share the password for the protected fields? Would like to make some modifications to it. Thanks.

Who is online

Users browsing this forum: No registered users and 17 guests