Tag: Free template for capacity planning

The number of productive hours available for a sprint is called sprint capacity. The capacity is calculated before starting a sprint to identify how many stories team can accomplish for the upcoming sprint. This process is called capacity planning. This helps the team to make a commitment (How many story-points team would complete).

The defaults will be set. These can be updated for individuals as per your team allocation.

Click “Plan Button”

This would open capacity sheet with available hours for each individual for all days (Start to end of the sprint)

You can make changes to individuals availability on specific days. Consider holidays, time off and other factors which affect hours for given days.

Fill in details of past sprints if you have data. If not, you would start having that from next sprint onwards once you start using this planner.

Based on past sprint data you get hours per story points in the Capacity sheet that would help us to derive how many story points we can really commit for upcoming sprint for which we are doing capacity planning.

Please note you can use the template I provided or any other template you or your company already have. My goal is just to make the process easy and make you understand the benefit.

Benefits

The availability percentage help us to identify available hours which eventually help us to pick the right amount of work for a given sprint.

Many sprint team does this manually which has two disadvantages

The chances of making mistake are high.

The velocity is either considered by averaging past few sprints or simply picking velocity of the previous sprint. The better way is to multiply your capacity of a team with focus factor.

Improves focus and commitment which in turn increases chances of sprint success.

The holistic view of data what you get for past sprints using capacity planning does help in taking decisions and continuous improvement.

In order to see the real benefit of this template, you are expected to use the template for at least 3-4 sprints. Further, as you move, you see more benefits.

There are multiple teams I know leveraging this template I shared and I see them getting befitted out of it. This is most basic template while if you think you want to add more to it, just provide the details in terms of what do you want and I will incorporate into my template.