Capacity: Help with Excel

For every Sprint Planning the capacity, the hours available for the team is an important ingredient. Usually, this is rather straight forward and easy to do. At my current project we have two teams. Each team is cross-functional, i.e. being able to deliver a piece of done software. However, in this case, the skills are very different, so that the overall number of available hours can be deceptive as there might be 120 h of development tasks and only 80 h available. We actually run into this problem when we got additional business analysts. The overall capacity went up so that we could commit to more user stories. As a result, we had far too much programming work and not enough analysis work.

Now, we break the capacity down per skills we need in our teams. Once Sprint Planning Two is over, we add up the hours per skill and see if we are still in the range. If yes – great! Otherwise the Dev Team and Product Owner self-organize and figure out a way to handle it.
Long story short – here is the link to the Excel sheet. It is not fancy but does a great job for the current project.
Enjoy!

2 Comments

  1. Rafael Gorski

    Hi Ralph,

    A minor change in your spread sheet, the cells D20 and D27 is not summing the BA values.

    []s
    Rafael Gorski

  2. Ralph Jocham

    Hi Rafael – thanks for your input. I checked it and it does look ok to me
    Best,
    Ralph

Leave a Reply

Your email address will not be published. Required fields are marked *