FINANCIAL OBJECTIVES 333
Figure 13.7 Sample monthly budget health check
A B C D E B C D E
1 Marketing Department
2 Budget report June 20xx
3 Local currency
4 Month of June Year to end June
5 Actual Budget Variance Var, % Actual Budget Variance Var, %
6 Salaries 11 004 10 000 1,004 10.0 61 351 60 000 1 351 2.3
… … … … … … … … … …
24 Travel 5 995 5 000 995 19.9 33 531 28 750 4 781 16.6
… … … … … … … … … …
51 Total spending 458 204 399 750 58 454 14.6 2 619 356 2 481 600 137 756 5.6
52 Contingency used 58 454 39 975 18 479 46.2 137 756 248 160 –110 404 –44.5
53 Total spending 458 204 439 725 18 479 4.2 2 619 356 2 729 760 –110 404 –4.0
A B C D E F G H
1 ZXTY International
2 Marketing Department
3 Budget for calendar year 20xx
4 Local currency Year to
5 Jan Feb Mar Apr May Jun end June
6 Salaries 10 000 10 000 10 000 10 000 10 000 10 000 60 000
… … … … … … … … …
24 Travel 5 000 5 500 4 000 4 500 4 750 5 000 28 750
… … … … … … … … …
51 Total actual 400 050 410 150 385 450 433 000 453 200 399 750 2 481 600
52 Contingency 40 005 41 015 38 545 43 300 45 320 39 975 248 160
53 Total spending 440 055 451 165 423 995 476 300 498 520 439 725 2 729 760
54 Cumulative 440 055 891 220 1 315 215 1 791 515 2 290 035 2 729 760
56
A B C D E F G H
1 Marketing Department
2 Outturn for January to June 20xx
3 Local currency
4 Year to
5 Jan Feb Mar Apr May Jun end June
6 Salaries 9 986 9 986 10 125 10 125 10 125 11 004 61 351
… … … … … … … … …
24 Travel 5 120 5 977 5 450 5 569 5 420 5 995 33 531
… … … … … … … … …
51 Total actual 399 457 420 435 399 499 451 397 490 364 458 204 2 619 356
52 Unused contingency 40 598 30 730 24 496 24 903 8 156 –18 479 110 404
53 Total budget 440 055 451 165 423 995 476 300 498 520 439 725 2 729 760
54 Cumulative, actual 399 457 819 892 1 219 391 1 670 788 2 161 152 2 619 356
56
Salaries within acceptable % variance
but check if Marketing recruited
above headcount budget in June
or conceded big pay increases
Total spending was high in June.
Contingency for month was exceeded
by 46% (worrying) BUT less than half
the contingency for Jan-June was
consumed (good) and overall spending
is 4% below the total provision
Travel is running over budget.
Check and control or revise budget