Burndown Chart Examples

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

Burndown Chart Template

Day Start 1 2 3 4 5 6 7 8 9 10 11

Estimated % Remaining 100 97 93 90 87 83 80 77 73 70 67 63


CHG 3 3 3 3 3 3 3 3 3 3 3
Actual % Remaining 100 97 93 90 87 83 80 77 73 70 67 63

Estimated Work Effort 0 15 30 45 60 75 90 105 120 135 150 165


CHG 15 15 15 15 15 15 15 15 15 15 15
Actual Work Effort 0 15 30 45 60 75 90 105 120 135 150 165

This example model uses a 30 day sprint. Below, you 100


can define the total capacity of your team and how
much estimated completion and work effort is
accomplished each day. Using the cream colored cells 90
above, replace the calculated cells with your actual
burndown information.
80

Estimated % Complete Per Day 3.3 70

Total Capacity 450 60

Total Work Per Day 15 50

40

30

20

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

60 57 53 50 47 43 40 37 33 30 27 23 20 17 13 10
3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
60 57 53 50 47 43 40 37 33 30 27 23 20 17 13 10

180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405
15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15
180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405

450

400

350

300

250 Estimated Work Effort


Actual Work Effort
Estimated % Remaining
200 Actual % Remaining

150

100

50

0
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
28 29 30

7 3 0
3 3 3
7 3 0

420 435 450


15 15 15
420 435 450

ed Work Effort
Work Effort
ed % Remaining
% Remaining
Burndown Chart Template
Day Start 1 2 3 4 5 6 7 8 9 10 11

Estimated % Remaining 100 99 99 99 99 98 97 96 94 92 90 87


CHG 0 0 0 0 1 1 1 2 2 2 3
Actual % Remaining 100 100 100 100 100 99 98 97 95 93 91 88

Estimated Work Effort 0 15 30 45 60 75 90 105 120 135 150 165


CHG 15 15 15 15 15 15 15 15 15 15 15
Actual Work Effort 0 15 30 45 60 75 90 105 120 135 150 165

This example model uses a 30 day sprint, showing a 100


curved model for the amount of progress in
completion of features.
90

80

Estimated % Complete Per Day 3.3 70

Total Capacity 450 60

Total Work Per Day 15 50

40

30

20

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

84 81 77 73 69 64 59 54 48 42 36 29 22 15 9 4
3 3 4 4 4 5 5 5 6 6 6 7 7 7 6 5
85 82 78 74 70 65 60 55 49 43 37 30 23 16 10 5

180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405
15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15
180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405

450

400

350

300

250 Estimated Work Effort


Actual Work Effort
Estimated % Remaining
200 Actual % Remaining

150

100

50

0
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
28 29 30

0 0 0
4 0 0
1 1 0

420 435 450


15 15 15
420 435 450

ed Work Effort
Work Effort
ed % Remaining
% Remaining
Burndown Chart Template
Day Start 1 2 3 4 5 6 7 8 9 10 11

Estimated % Remaining 100 97 93 90 87 83 80 77 73 70 67 63


CHG 0 0 0 5 5 5 5 10 10 10 5
Actual % Remaining 100 100 100 100 95 90 85 80 70 60 50 45

Estimated Work Effort 0 15 30 45 60 75 90 105 120 135 150 165


CHG 10 12 15 17 12 15 15 12 16 17 15
Actual Work Effort 0 10 22 37 54 66 81 96 108 124 141 156

This example model shows a good burndown where 100


the work effort is below the estimate and features
are completed before the end of the sprint.
90

80

Estimated % Complete Per Day 3.3 70

Total Capacity 450 60

Total Work Per Day 15 50

40

30

20

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

60 57 53 50 47 43 40 37 33 30 27 23 20 17 13 10
0 0 0 5 0 -10 5 5 5 5 10 10 5 0 0 0
45 45 45 40 40 50 45 40 35 30 20 10 5 5 5 5

180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405
10 10 5 5 20 30 10 15 10 7 5 8 9 7 6 9
166 176 181 186 206 236 246 261 271 278 283 291 300 307 313 322

450

400

350

300

250 Estimated Work Effort


Actual Work Effort
Estimated % Remaining
200 Actual % Remaining

150

100

50

0
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
28 29 30

7 3 0
5 0 0
0 0 0

420 435 450


8 7 6
330 337 343

ed Work Effort
Work Effort
ed % Remaining
% Remaining
Burndown Chart Template
Day Start 1 2 3 4 5 6 7 8 9 10 11

Estimated % Remaining 100 97 93 90 87 83 80 77 73 70 67 63


CHG 0 0 0 5 3 5 4 6 2 3 6
Actual % Remaining 100 100 100 100 95 92 87 83 77 75 72 66

Estimated Work Effort 0 15 30 45 60 75 90 105 120 135 150 165


CHG 10 12 11 13 14 13 12 11 10 9 12
Actual Work Effort 0 10 22 33 46 60 73 85 96 106 115 127

This example model shows a bad burndown where 100


the work effort exceeds the estimate and features
aren't completed at the end of the sprint.
90

80

Estimated % Complete Per Day 3.3 70

Total Capacity 450 60

Total Work Per Day 15 50

40

30

20

10

0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

60 57 53 50 47 43 40 37 33 30 27 23 20 17 13 10
3 2 1 0 0 0 0 0 2 2 1 2 3 1 5 10
63 61 60 60 60 60 60 60 58 56 55 53 50 49 44 34

180 195 210 225 240 255 270 285 300 315 330 345 360 375 390 405
23 12 18 13 16 25 21 25 23 18 17 15 13 15 20 25
150 162 180 193 209 234 255 280 303 321 338 353 366 381 401 426

500

450

400

350

300
Estimated Work Effort
250 Actual Work Effort
Estimated % Remaining
Actual % Remaining
200

150

100

50

0
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
28 29 30

7 3 0
5 0 5
29 29 24

420 435 450


20 30 15
446 476 491

ed Work Effort
Work Effort
ed % Remaining
% Remaining

You might also like