[vc_row full_width_row=”true”][vc_column][vc_raw_js]JTNDJTIxLS0lMjBHb29nbGUlMjBUYWclMjBNYW5hZ2VyJTIwJTI4bm9zY3JpcHQlMjklMjAtLSUzRSUwQSUzQ25vc2NyaXB0JTNFJTNDaWZyYW1lJTIwc3JjJTNEJTIyaHR0cHMlM0ElMkYlMkZ3d3cuZ29vZ2xldGFnbWFuYWdlci5jb20lMkZucy5odG1sJTNGaWQlM0RHVE0tVDRWNVA0TSUyMiUwQWhlaWdodCUzRCUyMjAlMjIlMjB3aWR0aCUzRCUyMjAlMjIlMjBzdHlsZSUzRCUyMmRpc3BsYXklM0Fub25lJTNCdmlzaWJpbGl0eSUzQWhpZGRlbiUyMiUzRSUzQyUyRmlmcmFtZSUzRSUzQyUyRm5vc2NyaXB0JTNFJTBBJTNDJTIxLS0lMjBFbmQlMjBHb29nbGUlMjBUYWclMjBNYW5hZ2VyJTIwJTI4bm9zY3JpcHQlMjklMjAtLSUzRQ==[/vc_raw_js][vc_single_image image=”949″ img_size=”full”][/vc_column][/vc_row][vc_row][vc_column][vc_row_inner][vc_column_inner][vc_raw_html]JTNDYnV0dG9uJTIwY2xhc3MlM0QlMjJidG4lMjJvbmNsaWNrJTNEJTIyd2luZG93LmxvY2F0aW9uLmhyZWYlM0QlMjclMjNXSEFUJTI3JTIyJTNFV2hhdCUyMGlzJTIwQ2FwYWNpdHklMjBQbGFubmluZyUzRiUzQyUyRmJ1dHRvbiUzRSUwQSUzQ2J1dHRvbiUyMGNsYXNzJTNEJTIyYnRuJTIyb25jbGljayUzRCUyMndpbmRvdy5sb2NhdGlvbi5ocmVmJTNEJTI3JTIzSE9XJTI3JTIyJTNFSG93JTIwdG8lMjBkbyUyMENhcGFjaXR5JTIwUGxhbm5pbmclMjAlMjhpbiUyMEhvdXJzJTI5JTNDJTJGYnV0dG9uJTNFJTBBJTNDYnV0dG9uJTIwY2xhc3MlM0QlMjJidG4lMjJvbmNsaWNrJTNEJTIyd2luZG93LmxvY2F0aW9uLmhyZWYlM0QlMjclMjNXSEVOJTI3JTIyJTNFV2hlbiUyMHdlJTIwc2hvdWxkJTIwZG8lMjBDYXBhY2l0eSUyMFBsYW5uaW5nJTNGJTNDJTJGYnV0dG9uJTNFJTBBJTNDYnV0dG9uJTIwY2xhc3MlM0QlMjJidG4lMjJvbmNsaWNrJTNEJTIyd2luZG93LmxvY2F0aW9uLmhyZWYlM0QlMjclMjNCRU5FRklUUyUyNyUyMiUzRUJlbmVmaXRzJTIwb2YlMjBDYXBhY2l0eSUyMFBsYW5uaW5nJTNDJTJGYnV0dG9uJTNFJTBB[/vc_raw_html][/vc_column_inner][/vc_row_inner][vc_column_text][ps2id id=’WHAT’ target=”/A]
What is Capacity Planning
[/vc_column_text][vc_column_text]Planning the Capacity means estimate and calculate the capacity of Agile team. There are two widely used capacity measurement units
[dt_highlight color=”” text_color=”” bg_color=””]1. Story Points[/dt_highlight]
This is Simple way to calculate the velocity (Average of last 6 to 10 Sprint’s Accepted Story Points). and target the upcoming Sprint to commit the User Story that closely match with the velocity.
I Personally recommend the other way of doing the capacity planning by calculate it by Hours.
[dt_highlight color=”” text_color=”” bg_color=””]2. Hours [/dt_highlight]
I personally recommend Capacity Planning by Hours. I will explain only on this way of Capacity Planning in this Article. Its gives better visibility and accuracy. And many other benefits that we will discuss later in this article.
Here we Calculate the available bandwidth of the Agile Team (except PO & SM). By calculate their available hours for the upcoming Sprint.
Will discuss in details about who to calculate it, what are Factors we should consider in this article.
[/vc_column_text][vc_empty_space][vc_single_image image=”13808″ img_size=”full” onclick=”custom_link” link=”https://alumni.agiledigest.com/product/safe-scrum-master-certification-workshop/”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text][ps2id id=’HOW’ target=”/A]
How to do Capacity Planning (in Hours)
[/vc_column_text][vc_column_text]The technique is very simple to calculate & plan your capacity. I have explained below the steps to calculate it manually. However in todays days all major popular ALM tools have that inbuilt, You just need to feed in the details.
At the end of this article will show example of doing Capacity Planning in one or two ALM tool.
I have explained below step by step you can follow to do your capacity planning, even if you are not using any ALM tool, just by maintaining an Excel.[/vc_column_text][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_column_text][ps2id id=’STEP1′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 1 – Calculate Sprint Duration[/dt_highlight]
Calculate the Sprint Duration in Days, Identify the Sprint Start Day and End Day. To explain this I have taken a 2 Week Sprint which Start on Wednesday and Ends on Tues day. And we are doing our Capacity Planning for Sprint 2.
The picture in the right Represent a 2 week Sprint – Calendar, of 10 days. Spread in three Physical Calendar Week. Through out the rest of the article, I will explain with this color legends , where
Yellow = Previous Sprint
Green = Current Sprint (for the Sprint we are doing the Capacity Planning)
Blue = Future Sprint.[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_single_image image=”960″ img_size=”medium” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_column_text][ps2id id=’STEP2′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 2 – Calculate Team Members Availability[/dt_highlight]
Assuming We have 7 Members team 4 Developer and 3 Testers, Not Counting the SM and PO here, as we don’t need to count their capacity in Capacity Planning[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_single_image image=”968″ img_size=”medium” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_single_image image=”959″ img_size=”medium” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text][ps2id id=’STEP3′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 3 – Identify Allocation %[/dt_highlight]
Now Identify the Shared resource if any, If there is No shared resource, we will count every one is 100% allocated to this Scrum Team. For example lets assume we have one Tester (Tester 3) who is shared between two teams, and his allocation is 50% for this team in example.[/vc_column_text][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_column_text][ps2id id=’STEP4′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 4 – Calculated The Standard Hours per day[/dt_highlight]
If we assume every one has 8 hours per day on full allocation, The Shared resource will have 4 Hours per day allocated for this team. For this sprint.
For 10 Days Sprint the total Max capacity is 520 Hours for the entire Team and having 52 Hours per day, Including Shared Tester. Every One has 80 hours for 10 days and the Shared Resource with 50% allocation have 40 Hours, for this sprint Duration.[/vc_column_text][/vc_column_inner][vc_column_inner width=”1/2″][vc_single_image image=”1018″ img_size=”medium” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_single_image image=”1019″ img_size=”medium” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][vc_column_inner width=”1/2″][vc_column_text]Now Lets See how does that looks like in our calendar[/vc_column_text][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner][vc_single_image image=”13806″ img_size=”full” onclick=”custom_link” link=”https://alumni.agiledigest.com/product/leading-safe-sa-certification-workshop/”][vc_column_text][ps2id id=’STEP5′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 5 – Consider The Factors[/dt_highlight]
1. Team Holiday
Mark the date that is off for the entire team. National Holidays etc.
2. Calculate the Individual working off.
Calculate based on – if any resource have planned off / out of office.
3. Override default working day hour.
If Required – Take an exception for individual team member, to change default hours from 8 Hours to some thing else, Specially if some one has a plan half day or the plan hours have other than other than the default 8 Hours (100% Allocation)
[/vc_column_text][vc_single_image image=”971″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][vc_column_text]Assuming – 9th of Jan is a Team Holiday
In this case : we can see from this picture, that the total and Individual capacity is reduced accordingly.[/vc_column_text][vc_single_image image=”974″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][vc_column_text]Assuming – Developer 1, Developer 2 and Tester 1 have a Planned full day off for three different days. By applying that we can see from this picture, that the total and Individual capacity is reduced accordingly.[/vc_column_text][vc_single_image image=”966″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][vc_column_text]If Developer 3 plans a Half day work on 13th Jan. The plan capacity will change accordingly as below[/vc_column_text][vc_single_image image=”973″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner][vc_column_text][ps2id id=’STEP6′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 6 – Consider Other Work that eat up Times for every one[/dt_highlight]
Consider the Time it will take for other meetings and Agile Ceremonies. The below picture represents typical time a Teams Spends each ceremony and other meetings[/vc_column_text][vc_single_image image=”1017″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][vc_column_text]
Reduce 12.33 Hours from the Capacity
[/vc_column_text][vc_single_image image=”1020″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner][vc_column_text][ps2id id=’STEP7′ target=”/A]
[dt_highlight color=”” text_color=”” bg_color=””]Step 7 – Consider Focus Factor[/dt_highlight]
Plan it accordingly to your team can focus, for any unplanned time loss keeping in mind the daily time off, adhoc unplanned meetings , other official activity, training, Discussion with SME etc. Remember for planned activity your can still calculate before hand. We keep focus factor for any thing that can not be plan. That value can vary 75% to 95%[/vc_column_text][vc_single_image image=”1021″ img_size=”large” alignment=”center” onclick=”link_image” lazy_loading=”true”][vc_column_text]
So The Final Capacity for this Team for Sprint 2 is 318.32 Hours
[/vc_column_text][vc_column_text]
Summarizing the 7 Steps
[/vc_column_text][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”top”][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ package_heading=”Step 1″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP1||”]Calculate – Sprint Duration[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”red” package_heading=”Step 2″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP2||”]List Down Team Members[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”yellow” package_heading=”Step 3″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP3||”]Calculate Team members Allocation[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”blue” package_heading=”Step 4″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP4||”]Calculate – Standard Working Hours / Day[/ultimate_info_table][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”top”][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”green” package_heading=”Step 5″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP5||”]Consider The Factors
- Team Holiday
- Individual planned vacation
- Individual Partial off day
[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”green” package_heading=”Step 6″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP6||”]
Calculate Ceremony Time
and other work
[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][ultimate_info_table design_style=”design05″ color_scheme=”gray” package_heading=”Step 7″ use_cta_btn=”box” package_link=”url:http%3A%2F%2Flocalhost%2Fwordpress1%2Fagile-digest-tutorial%2Fcapacity-planning%2F%23STEP7||”]Calculate Focus Factor[/ultimate_info_table][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner][vc_column_text]
Please Note
The Values , Percentage and amount of hours are for the above example only. You need to put values based on your own need and facts.
- Calculate the Focus Factor the best suits your project.
- Sprint Duration as per your Sprint Cycle
- Plan it for Developers/ Tester and any other Role in your Scrum team (except SM and PO)
- Team members allocation as actual in your team
- Factors like Team Holiday, Planned Vacation, partial are not just limited to these tree factors.
- Calculate the Times of Ceremonies as per your schedule with addition to any other planned meeting
- In The above example I have not calculated the vacation day is falling under any ceremony day, to avoid complication and granular level calculation.
[/vc_column_text][/vc_column_inner][/vc_row_inner][vc_single_image image=”13801″ img_size=”full” onclick=”custom_link” link=”https://alumni.agiledigest.com/product/4-stages-to-scrum-master/”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text][ps2id id=’WHEN’ target=”/A]
When we should do Capacity Planning
[/vc_column_text][vc_column_text]With Scrum Master’s facilitation A Scrum Team can identify the capacity before the sprint planning. The best time is just before the Sprint Planning for any specific Sprint, That gives the best visibility of Resource’s vacation plan or Ceremony time.
If the Team is using any ALM tool, Individual team can update their available time, Scrum Master can help the team understand how to calculate their Individual Capacity. Before hitting the Sprint Planning, the Scrum Master can conduct a quick 30 min meeting with the team and get the Capacity Calculated and Update accordingly. When I was a Scrum Master I used to calculate all the factors in Excel initially with the team 1 or 2 day before Sprint Planning, and eventually the team was mature enough to do that by their own with very minimal intervention.[/vc_column_text][vc_empty_space][/vc_column][/vc_row][vc_row][vc_column][vc_column_text][ps2id id=’BENEFITS’ target=”/A]
Benefits of Capacity Planning
[/vc_column_text][vc_column_text]Capacity Planning helps the team to gauge the available bandwidth for the team to commit and complete User stories. Specially when you estimate your capacity by hours and map task of committed user stories with the Individual capacity and his/her assigned estimated task hours. The team can identify the limit of committing user story in Sprint Planning. We will discuss more in details how we map our tasks and capacity during Sprint Planning, in a different article of Understanding Sprint Planning.
The Reason why I always prefer Capacity Planning and Mapping on Hours Rather than Velocity is, Its easy to calculate available Hours by simply math with Days, Vacation, Leave, Other Time, Focus Factor etc. to get a Team Capacity. That’s is technically not possible with Velocity and the team needs to make assumptions which is dangerous,
Secondly you can not assign a Story (having Story points) to a single member, as completing a story is mostly a team effort. And distributing any story points between team member, Huh!! Cant even think about it, where One Story (what ever the story point is) can have multiple tasks (each task having efforts estimated in Hours) can easily be assigned to one or more Team Member, each task can assigned to each member. We will see more in details with demonstration in a different article of Understanding Sprint Planning.[/vc_column_text][vc_empty_space][vc_single_image image=”13804″ img_size=”full” onclick=”custom_link” link=”https://alumni.agiledigest.com/product/mastering-jira-software-jira-training/”][/vc_column][/vc_row][vc_row][vc_column][vc_column_text][ps2id id=’VIDEO’ target=”/A]
Video with Demonstration
[/vc_column_text][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_video link=”https://www.youtube.com/embed/dO-jHtzsKWQ”][/vc_column_inner][vc_column_inner width=”1/2″][vc_video link=”https://www.youtube.com/embed/RY7j5c8DZJo”][/vc_column_inner][/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”middle”][vc_column_inner width=”1/2″][vc_video link=”https://www.youtube.com/embed/VLLwAB6QcTQ”][/vc_column_inner][vc_column_inner width=”1/2″][vc_video link=”https://www.youtube.com/embed/H7AcgKGqB74″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column][vc_message message_box_style=”3d” style=”square” message_box_color=”green” icon_type=”openiconic” icon_openiconic=”vc-oi vc-oi-info”]Hope this page was able to provide the information you were looking for, In case we missed something, feel free to leave your comments, feedback and suggestions, at bottom of the page’s comment section.[/vc_message][/vc_column][/vc_row][vc_row type=”1″ full_width=”stretch_row_content”][vc_column][vc_empty_space][vc_column_text]
Author(s) of this article
[/vc_column_text][vc_row_inner][vc_column_inner width=”1/4″][vc_raw_html]JTNDZGl2JTIwY2xhc3MlM0QlMjJMSS1wcm9maWxlLWJhZGdlJTIyJTIwJTIwZGF0YS12ZXJzaW9uJTNEJTIydjElMjIlMjBkYXRhLXNpemUlM0QlMjJtZWRpdW0lMjIlMjBkYXRhLWxvY2FsZSUzRCUyMmVuX1VTJTIyJTIwZGF0YS10eXBlJTNEJTIyaG9yaXpvbnRhbCUyMiUyMGRhdGEtdGhlbWUlM0QlMjJsaWdodCUyMiUyMGRhdGEtdmFuaXR5JTNEJTIybmlsYWRyaS1tYWhhcGF0cmEtMzA2OGExNSUyMiUzRSUzQ2ElMjBjbGFzcyUzRCUyMkxJLXNpbXBsZS1saW5rJTIyJTIwaHJlZiUzRCUyN2h0dHBzJTNBJTJGJTJGaW4ubGlua2VkaW4uY29tJTJGaW4lMkZuaWxhZHJpLW1haGFwYXRyYS0zMDY4YTE1JTNGdHJrJTNEcHJvZmlsZS1iYWRnZSUyNyUzRU5pbGFkcmklMjBNYWhhcGF0cmElM0MlMkZhJTNFJTNDJTJGZGl2JTNF[/vc_raw_html][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]
Great video again. Is it possible to get final xls with all the formulas, that would be great help.
Hi Nitin,
Thank you for your appreciation. Generally we don’t share our contents or materials. However this particular excel we have made it public because of multiple request. You can find the excel to download from the sidebar of this page. Search for “Related Template to Download”
Best Regards
Agile Digest Team.
There is a another template to do capacity Planning, You may consider buying. here is the link https://alumni.agiledigest.com/product/capacity-sprint-planning-template/
Can you tell with what you divided cermony time adding up all the total is divide by 100?
can you please tell what formula you have used to calculate cermonry time and focus facor formulas.Thanks
Please watch the video on youtube, you will get the details.
HI i;ve watched video but no where it says the actual formula to be used, can you please let me know the actual formula used. so in grooming video it says take last 6 sprints average – can you please provide actual formula do i need to add all the last 6 sprints and divide by what ? Thanks
can any one answer how ceremony time is calculated 12.33 has come up what formula is being used,
can any1 answer my questions on the calculation formula used