Sprint Capacity Planning Excel Template Free Download

Capacity Planning for Sprint based Agile projects is the process in which the amount of work that can be done in the sprints with available resources is planned. This excel template helps a Scrum Master or Project Manager in capacity planning for sprints. 
The planner has 3 sections - Capacity Planner, Resource Plan and Data Config.

Sprint Capacity Planning Excel Template
Sprint Capacity Planning Excel Template

About the template

  • Capacity planner to do the planning of tasks and sprints.
  • Resource plan which includes capacity plan on a daily basis.
  • A config section which allows changing the work streams and sprint names.
  • The template can handle up to 4 sprints of two weeks each, 5 work streams and 30 tasks in the backlog.

  • Task ID a primary key which can be used in task planning,
  • A detailed resource plan to capture resource available on a daily basis.
  • For each sprint shows the available and planned capacity for each work stream.
  • Highlights gaps in available and planned capacity for each sprint.
  • Highlights tasks which have not been allocated to any sprint and duplicate tasks in sprints.

Capacity Planner Tab

Sprint Capacity Planner
Sprint Capacity Planner
  • The capacity planning tab is the key in the template as it gives a the planner a view where these is capacity shortage. 
  • It has a backlog which has the list of items to be done in the sprints.
  • Each item can have estimates for each of the work streams.
  • There are total of 4 sprints which each sprint have the same item number, description and estimates field. 
  • To allocate an item to the sprint simply put the serial number in the # column. The item description and the estimates will appear in the relevant work streams.

  • Above each of the columns there is a capacity available and capacity planned columns.
  • Available capacity comes from the resource plan. Planned capacity comes from the list of the items added in the that particular sprint.
  • If the planned capacity is less than the available that means there is capacity in the sprint. This is indicated by green color.
  • If the planned  capacity is more than the available then you either need to drop something. This is indicated by red color.
  • If the same task id is used multiple times the task id highlighted in red.
  • If you want to delete the task then enter ".". If you do not enter a "." and leave it blank then the columns will show n/a.

Resource Plan and Data

  • The resource plan captures resource name, resource type and daily allocations for 4 sprints.
  • The allocation is based on hours. So, if someone is working full time then it is 8 hours, half day it is 4 and part time could be 6 hours.
  • If someone is not available or is on leave then enter 0(zero).
  • Change the first date in D2 to change sprint start date.

  • The data tab has a resource type, code and capacity per sprint.
  • You can change the resource type and code as per your needs. 
  • The resource code is a short name which allows us to use the screen space optimally.
Sprint Resource Plan
Sprint Resource Plan

Capacity Planning Steps

Step 1: Create a backlog with items.
Step 2: Identify different work streams and their estimates.
Step 3: Identify the resources and populate the resource plan.
Step 4: On capacity planning tab move the items from backlog to sprints using the task ID.
Step 5: Move the items till the planned and actual capacity are same. 

Techno-Tips
  1. If the task planned are more then capacity then move items to next sprint.
  2. Most of the times one of the work streams runs out of capacity. In that situation you can break up the an item to be split across multiple sprints.
Swapnil Wale

Written by

Swapnil Wale is an IT Professional based in Sydney, Australia with over 10 years of experience in technology and project management. He is a passionate blogger and focuses on project management and BRMS articles.

0 comments:

Post a Comment

 

© 2013 Techno-PM. All rights resevered. Designed by Templateism

Back To Top
Real Time Web Analytics