Capacity Planning Template will help in identifying resource requirements for multiple or single projects. The key foundation of the planning template which is part of our inventory of project management templates is based on Resource Type as during the initial phases of planning the exact resource names will not be available.
There are two key sections - Capacity Planner and Resource Requirements.
There are two key sections - Capacity Planner and Resource Requirements.
![]() |
Capacity Planning Excel Template |
Few thoughts and tips on Capacity PlanningHaving a Resource Management Plan in excel or any other tool is a must for any organisation. Capacity planning is on top of the basic resource management planning.Capacity planning is an essential task for portfolio management.A portfolio manager needs to to know where exactly his resources are getting used.
One of the common issues in capacity planning is that the management ignores the need of project management capacity. This can be very dangerous as even with all the resources and manpower any project in the portfolio will need a project manager.
Capacity planning should be part of any project managers tasks whether it is waterfall or agile project management. Check out our Agile Sprint Based Capacity planner. |
---|
Features and Advantages of the Capacity Planning Template Excel
- Using the planning capacity XLS tool a portfolio manager or a resource manager will be able to pinpoint where there is shortage of resources and also be able to tell what type of resources.
- The capacity planner will highlight resource gaps on a weekly basis which makes the job of the resource manager easy.
- Allows planning for resources across multiple projects. Based on weekly planning so allows planning up to one year.
- Provides flexibility of setting up working days for resources every week.
- Highlights which resource types are in high demand or resource types which are free.
- Has a built in resource pool which can be used to setup resources.
- The resource pool can be used set the availability of the resource types on a weekly basis.
- The Capacity Planning Template can handle up to 10 resource types. (You can add more by changing the sheet structure and updating the formulas).
- Planned leaves can be captured by setting the availability in the resource pool for the resource type.
Sections in Capacity Planning Template Excel
There are two key sections - Capacity Planner and Resource Requirements.
The Capacity Planner consists of two areas - Planner and Resource Pool. Resource Pool is the area where you configure all your resources and their availability. The availability is based on weekly time so if a person is working full time then they are assumed to be available 5 days per week, if they are working 50% part time then 2.5 and so on.
The Planner area is the key as it displays the availability and deficit based on the Resource Requirements. The Resource Requirements tab is the area where the planned projects and resource are allocated. The resource requirements can handle multiple projects and resource types.
How to use the Capacity Planner
Follow the below steps to start using the Capacity Planning Excel Template -
Step 1: Gathering Project Information
Step 1: Gathering Project Information
- Gather a list of projects which are to be planned for the specified duration.
- Collect high level estimates for the projects. During the capacity planning phase it is natural to not have the detailed estimates and WBS.
- Generally, the projects are also resourced on past estimates or guesstimates.
![]() |
Capacity Planning Excel Template |
Step 2: Updating the Resource Pool or Resource Loading
- Update the Resource Pool Section with the resource types in your organisation.
- This activity can be called as resource loading because a resource managers goes ahead and allocates all the tasks even if it means overloading the resource.
- If you have too many resource types I would recommend keeping the resource type to as minimum as possible to avoid maintenance overhead.
- In the resource pool section update the total availability for the resource type. For example if you have two project managers who are full time then the total availability will be 10 days, if you have DBA who is part time then it 2.5.
- Also, update the holidays or vacation times. For example if there one public holiday in week starting 4th Jan then that week everyone should be available for 4 days.
- If an individual is going on leave then you can update the availability for that resource type. For example if you have two project managers then the usual availability would be 10 days but if one of then is going on leave it would reduce to 5 days a week.
![]() |
Capacity Planning Excel Template |
Note : No changes are required in the planner section so do not update any data under the planner area.
Step 3: Update the resource requirements
- For each project start entering the project name, project phase and select the resource type.
- Then enter the requirements for that resource in weeks.
- Review the planner section to see issues with the resource needs.
- The capacity planner auto highlights cells to indicate any issues with the allocations or utilization.
I can't download the file from Dropbox. Do you have an alternate method?
ReplyDeleteYou don't need to. Click download and it asks you to sign in or create an account. Ignore this and look at the bottom of this popup. You will see an option to download.
ReplyDeleteGreat and very handy tool. Thank you for making is so simple to adopt.
ReplyDeleteThe download link isn't available anymore. Could you please reupload.
ReplyDeleteMany thanks.
Fix the link. Thanks.
ReplyDeleteHow can I incorporate Vacations and Holidays into the Capacity 'Resource Pool" section?
ReplyDeleteYou can easily setup number of days per week for a resource. For holidays you can reduce total working days per week for everyone.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete