Capacity Planning Tool - Google Sheets

Why do I need this?

If you are managing a software project and need to plan capacity this sheet can help. Quickly understand if you'll be able to meet target deadlines:

• Supports up to three Milestones
• Estimate both Frontend and Backend work independently

How does it work?

The template is split into four sections:

• Team Velocity
• Total Work Remaining
• Forecast Velocity by Milestone
• Targets

Team Velocity

In this section, enter the capacity for each team member per week. For example: 8 story points.

Total Work Remaining

In this section, enter the total work remaining. It supports three separate milestones, with each milestone supporting a separate estimate for Backend and Frontend work.

Forecast Velocity

This section will update based on the values in the previous sections. It gives a visual representation of

Target Releases

This section is useful for understanding if you will hit a target release date. Simply, enter the milestone name in the week you want to target the release, and it calculates if you'll be over-capacity and by how much.

Why should I use it?

• Plan your team's upcoming projects
• Take into consideration the split between Frontend and Backend

Who made it?

Piers Rollinson is a Engineering manager with many years of experience managing teams and software projects.

What's included?

A copy of the template ready to use.

Main features:

• Supports up to three milestones
• Supports two types of team/work (Default is backend and frontend)