Scrum Metrics with Formulas
Hi All,
Below are some of the metrics used in SCRUM. I have categorized Phasewise with their formulas.
Six Sigma metrics focus on the following critical factors - Cost, Quality and Schedule.
Phase | Metrics |
Sprint Planning | # of User Stories Committed in a Sprint |
Story Points Committed in a Sprint | |
Initial Estimated Effort (Hours) | |
Available Effort - for each resource | |
Size (Story Point) | |
Sprint Execution | Remaining Effort (Hours) |
Remaining Story Points | |
Actual Effort - for each resource | |
Pre Release Defects Count | |
Test Case Review | Test Case Review Defects Count |
Actual Effort (Hours) | |
Sprint Review / Demo | # of User Stories Delivered in a Sprint |
Story Points Delivered in a Sprint | |
Deployment / UAT | Post Release / UAT Defects Count |
Release Planning | Size (Story Point) |
Deliverable Based Metrics
Sprint Goal Success - Story points completed, Objectives of the
business met.
Escaped Defects - User experienced defects
Defect Density - Number of defects per lines of code (LOC)
Team Velocity - How many average user stories completed by team in
previous sprints.
Sprint Burndown - Number of hours remaining to complete the stories
for each day during the sprint.
Metrics to report with Stakeholders
Sprint and release Burndown - Gives stakeholders a view of your
progress at a glance.
Sprint velocity - How much value you have been delivering.
Scope change - Number of stories added to project during release, Which
caused delays.
Team capacity - How many Full
time / Part time developers? Any vacations (or) sick leave?
Escaped defects - User experienced defects
Metrics Formula
Metric |
Formula |
Resource Utilization |
(Actual Efforts
/ Actual Variance Efforts)*100 |
Velocity trend for the current Scrum Release |
Story Points
Delivered in a Sprint |
Spill Over Index (User Stories) |
(# of User Stories Committed in a Sprint - #
of User Stories Delivered in a Sprint) / (# of User Stories Committed in a
Sprint) |
Spill Over Index (Story Points) |
(Story Points Committed in a Sprint - Story
Points Delivered in a Sprint ) / (Story Points Committed in a Sprint ) |
Sprint burndown charts for the sprints executed in the
month |
Work/Effort/Story
Points remaining |
% of post release defects |
(User
Acceptance Testing / (Design Review Defects + Code Review Defects + Unit
Testing Defects + QA Testing Defects + User Acceptance Testing))*100 |
CRD |
Customer Reported
defects |
|
DDE |
Delivered Defects
Efficiency |
|
CoQ |
Cost of Quality |
CoQ = Cost of Control (Prevention + Appraisal) + Failure Costs
(Internal + External) |
CAR |
Causal Analysis &
Resolution |
Identify causes of defects and take action to prevent from
occurring in future |
Pys |
Productivity |
Actual Efforts/ Planned efforts (Formula) |
SLA Closure Time |
Ticket raised time – Ticket closure time |
0 comments