Skip to content
Business

Burndown Chart Calculator

Calculate agile sprint ideal vs actual burndown rate, remaining story points per day, projected completion day, and scope creep impact.

Report tool

Understanding Agile Burndown Charts, Sprint Velocity, and Project Delivery

A burndown chart is a foundational visual measurement tool used by Scrum teams, product owners, and engineering leaders to track the rate at which work is completed over the course of a timeboxed sprint or project release. By plotting remaining story points or task hours against time, teams gain immediate visibility into whether they are on track to meet their sprint commitments or need to adjust scope.

Sprint delivery speed directly influences development budgets and organizational capital allocation. To analyze your engineering team operating burn, evaluate cash consumption with our burn rate calculator, calculate team billing rates with the bill rate calculator, track engineer time utilization via the billable hours calculator, assess architectural trade-offs with the build or buy calculator, and evaluate project cost efficiency using our earned value calculator.

Key Components of an Agile Burndown Chart

An effective sprint burndown chart relies on several fundamental metrics:

1. Total Committed Scope (Story Points)

The total amount of work agreed upon during sprint planning, quantified in story points or ideal engineering hours. This establishes the vertical intercept on Day 0 of the sprint.

2. Ideal Burndown Line (The Guideline)

A straight reference line connecting the initial committed story points on Day 0 to zero points on the final working day of the sprint. It represents the hypothetical linear completion rate required to finish all work perfectly on time.

3. Actual Burndown Line (Empirical Progress)

The real-time trajectory of remaining story points recorded at the end of each working day. Fluctuation above the ideal line indicates the team is behind schedule, while points below the ideal line signify the team is ahead of schedule.

4. Scope Creep and Backlog Additions

Any new user stories, bug tickets, or technical tasks injected into the sprint after kickoff. Scope additions increase the remaining points balance, causing upward spikes on the burndown chart.

Mathematical Formulas for Sprint Burndown Analysis

Scrum teams apply core mathematical formulas to compute velocity, projected finish dates, and schedule variances:

1. Ideal Daily Burndown Rate

The target number of story points the team must complete each working day:

Ideal Daily Burn Rate=Initial Committed Story PointsTotal Working Days in Sprint\text{Ideal Daily Burn Rate} = \frac{\text{Initial Committed Story Points}}{\text{Total Working Days in Sprint}}

2. Actual Daily Velocity

The empirical burn rate achieved by the engineering team over elapsed sprint days:

Actual Daily Velocity=Story Points CompletedWorking Days Elapsed\text{Actual Daily Velocity} = \frac{\text{Story Points Completed}}{\text{Working Days Elapsed}}

3. Required Daily Burn Rate for Remaining Days

The pace needed over remaining days to finish all outstanding story points:

Required Daily Burn Rate=Total Scope−Completed PointsTotal Sprint Days−Days Elapsed\text{Required Daily Burn Rate} = \frac{\text{Total Scope} - \text{Completed Points}}{\text{Total Sprint Days} - \text{Days Elapsed}}

4. Projected Sprint Completion Day

Estimating the actual day the backlog will reach zero based on current empirical velocity:

Projected Completion Day=Days Elapsed+Remaining Story PointsActual Daily Velocity\text{Projected Completion Day} = \text{Days Elapsed} + \frac{\text{Remaining Story Points}}{\text{Actual Daily Velocity}}

5. Schedule Variance

Measuring deviation between the planned ideal remaining balance and actual remaining points:

Schedule Variance=Ideal Remaining Points−Actual Remaining Points\text{Schedule Variance} = \text{Ideal Remaining Points} - \text{Actual Remaining Points}

A positive variance indicates the team is ahead of schedule, whereas a negative variance indicates an unburned point deficit.

Common Burndown Chart Patterns and How to Interpret Them

The shape of an actual burndown line reveals important team dynamics, estimation accuracy, and process bottlenecks:

The Mid-Sprint Plateau (Flatline)

Points remain unchanged for multiple consecutive days. This occurs when user stories are too large, tasks are blocked by external dependencies, or work is held up in code review or quality assurance testing.

The Upward Spike (Scope Ingestion)

The line jumps upward mid-sprint. This signals scope creep where new requirements or emergent bugs were pulled into an active sprint without removing lower-priority items.

The End-of-Sprint Cliff (Water-Scrum-Fall)

The chart stays high until the penultimate day, then plummets to zero on Day 10. This indicates stories are only marked complete when the entire batch is deployed, rather than delivering vertical slices continuously.

The Steady Staircase (Ideal Agile Flow)

The line descends in regular small increments every 1 to 2 days, hugging the ideal guideline. This demonstrates small story slicing, fast QA verification, and consistent daily throughput.

Comprehensive Worked Example

Consider a cross-functional software development team executing a 2-week (10 working days) sprint:

  • Initial Sprint Commitment: 80 story points across 10 working days.
  • Mid-Sprint Progress (Day 5): 36 story points completed by end of Day 5.
  • Scope Injected: 8 story points added on Day 3 due to an urgent client API requirement.

Step-by-Step Sprint Delivery Calculations

1. Total Scope: 80 (Initial) + 8 (Added) = 88 total story points.

2. Remaining Points on Day 5: 88 - 36 = 52 story points remaining.

3. Ideal Daily Burn Rate: 80 / 10 = 8.0 points per day.

4. Actual Daily Velocity: 36 completed / 5 days = 7.2 points per day.

5. Required Rate for Remaining 5 Days: 52 remaining points / 5 days = 10.4 points per day.

6. Projected Total Completion Day: 5 + (52 / 7.2) = Day 12.2 (2.2 working days overdue).

7. Strategic Takeaway: At the current pace of 7.2 points/day, the team will only complete 36 more points by Day 10, leaving 16 points unburned. During the Day 5 standup, the Scrum Master and Product Owner should de-scope at least 12 to 16 points of non-critical backlog items to ensure all core sprint goals are met on time.

Best Practices for Managing Sprint Burndown in Daily Standups

To maximize sprint success, engineering teams should incorporate burndown chart insights into their daily ceremonies:

1. Update Task States Immediately

Ensure engineers transition Jira or GitHub issues to Done as soon as code passes review and automated tests merge. Outdated ticket statuses distort burndown metrics and mask delivery risks.

2. Slice Stories Vertically

Break large 8-point and 13-point epics into small 2-point or 3-point vertical slices that can be delivered within 24 to 48 hours. Smaller tickets produce a smoother burndown slope and faster feedback loops.

3. Enforce a Trade-Off Rule for Scope Changes

If stakeholders insist on adding a new 5-point feature mid-sprint, the team must remove 5 points of equal or lower priority items to maintain a sustainable burndown trajectory.

Frequently asked questions

What is the difference between a sprint burndown chart and a burnup chart?
A sprint burndown chart displays remaining work decreasing over time toward zero, making it ideal for tracking daily team progress within a single sprint. A burnup chart displays total completed work accumulating upward toward a total scope line, making it better suited for tracking long-term release milestones where total scope expands over time.
Should sprint burndown charts track story points or hours?
Most modern Agile teams track story points because points represent relative complexity and value rather than time estimations. However, teams that break user stories into granular subtasks often track remaining hours during the first few days of a sprint to monitor day-to-day tactical execution.
What should a team do if the burndown line is consistently above the ideal line?
When the actual line remains above the ideal guideline for 3 or more consecutive days, the team should swarm on in-progress blockers, limit work in progress (WIP), and consult the Product Owner to de-scope lower-priority stories before the sprint concludes.
Does a flat burndown chart mean the team is not working?
Not necessarily. A flatline usually occurs when user stories are too large and remain in progress for days without reaching the Definition of Done. It can also occur when tasks are stuck waiting for QA verification, third-party API keys, or design reviews.
How do weekends and non-working days factor into burndown calculations?
Standard sprint burndown charts only count active working days (typically Monday through Friday). Non-working weekend days and public holidays are excluded from the horizontal axis so the ideal burn rate accurately reflects working hours.

Resources and references

The formulas and methods in this calculator were checked against these independent sources.