Sprint Planning, Team Capacity Calculator

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!



About Stephanie Davis

Stephanie Davis is Senior Director of Enterprise Agility & Digital Product Leadership at Cox Target Media. In this role, Stephanie champions agility across the enterprise, leads the Agile PMO, and manages the CTM portfolio while also overseeing the Digital Product Leadership team. Stephanie leads the team of Agile Project Leaders in the roles of ScrumMaster, Kanban Lead, and/or Agile Project Manager as well as overseeing the IT Business Analysts. Stephanie is a career project leader with over 16 years in the field, including past positions with AT&T Business and IBM Global Services, and has maintained the Project Management Professional (PMP) certification since early in her career. She also maintains the PMI-Agile Certified Practitioner (ACP) and Certified Scrum Master (CSM) credentials. Her academic credentials include a BS in Marketing and an MBA in International Business. Stephanie serves and supports Agile within her community and beyond as organizer for the Tampa Bay Agile Meetup and the Agile Open Florida. Most recently, Stephanie has been elected to the Agile Alliance board for the 2015 to 2017 term. View all posts by Stephanie Davis

4 responses to “Sprint Planning, Team Capacity Calculator

  • dcbain

    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?


    • Stephanie

      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!

  • dcbain

    Makes sense. A big “amen” to prod support being the wild card. Like the blog. Cheers, -dana

  • sandeepjainblr

    Nice article!

    The free template can be downloaded from

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: