Some of our Product Owners and managers expressed an interest in the ScrumMasters refining the team capacity calculations that we facilitate during sprint planning. There may be hundreds of these online, but attached is our version of a Team Capacity Calculator. The best approach is to bring this spreadsheet up on the big screen and fill it in live at the start of sprint planning.
Hope others may find it useful. Feedback welcome!
TeamCapacityCalculator
About Stephanie Davis
I’m currently VP of Innovation & Delivery Enablement at NMI, where I get to work at the intersection of strategy, delivery, and transformation. I lead an incredible team responsible for portfolio, program, and project management—and we’re also driving some of the most exciting shifts in how we work through AI, Agile Ops, and automation.
At the core, I’m passionate about making things work better—whether that’s helping teams deliver with more clarity and confidence, modernizing how we operate, or scaling new ways of working across the business. I love connecting big-picture vision with practical execution, and I take pride in creating the conditions for people and ideas to thrive.
I believe transformation isn’t just about process or tech—it’s about mindset. And the most powerful results come when we combine innovation with intentionality, and execution with joy.
View all posts by Stephanie Davis
i.am.agile 
July 20th, 2012 at 3:55 pm
Interesting. So ideal days and ideal time for your team members? 8 days? Mean 2 week sprints with 2 days off of the top for R&R, planning? Other than varying “hours off” are the team members dedicated or also committed at varying levels? Did this originate as a means to begin to shift your teams from a more traditional resource allocation model towards dedicated, stable teams?
Sincerely,
dcbain
July 20th, 2012 at 8:48 pm
We do 2-week sprints that run from Monday through Friday. Monday of the 1st week is Sprint Planning and Friday of the 2nd week is Sprint Review; hence, 8 sprint days.
The team members are dedicated to the Scrum team they are on, but also responsible for support for their product. Support time is always the wild card!
July 21st, 2012 at 3:20 pm
Makes sense. A big “amen” to prod support being the wild card. Like the blog. Cheers, -dana
December 1st, 2017 at 4:54 am
Nice article!
The free template can be downloaded from
http://www.agilechamps.com/agile-capacity-planning-download-template/
December 8th, 2020 at 12:41 pm
I have a question, one of my team members is going on planned leave for 8 days do I need to calculate the capacity as 0? Since he is not part of Daily stand up, Sprint R & R to reduce 2 days.
December 8th, 2020 at 12:43 pm
Yes, that sounds right.