Appendix
Schedule A – Consolidated Budget Variance
December 14, 2021Page 272 sections
Data table showing variances between the 2021 YTD actuals and the total annual budget for revenues and expenses.
Total 2021 YTD Revenue: $17,366,631Total 2021 YTD Expense: $16,925,63925% revenue variance
Report to Committee of the Whole Re: Budget Variance and Projects Update Report to December 7, 2021 Meeting Date: December 14, 2021
Page 27
Schedule A – Consolidated Budget Variance
| 2021 YTD | 2021 Total Budget | Variance | Variance % | Status | Prior YTD | Prior Year Total Budget | |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | $ 9,618,249 | $ 9,614,978 | $ (3,271) | 0% | 0% over budget | $ 9,219,894 | $ 9,251,211 |
| User fees | 2,825,652 | 2,822,165 | (3,487) | -0% | 0% over budget | 2,782,028 | 2,781,240 |
| Sales of services | 1,145,405 | 814,514 | (330,891) | -41% | 41% over budget | 720,598 | 817,225 |
| Penalties and fines | 93,513 | 60,000 | (33,513) | -56% | 56% over budget | 54,567 | 60,000 |
| Investment income | 89,686 | 110,000 | 20,314 | 18% | 18% under budget | 431,600 | 110,000 |
| Other revenue | 1,009,292 | 232,275 | (777,017) | -335% | 335% over budget | 444,436 | 298,743 |
| Government grants and transfers | 2,064,841 | 2,095,677 | 30,836 | 1% | 1% under budget | 4,187,270 | 3,230,138 |
| Contributions from developers and others | 183,750 | - | (183,750) | 0% | - | 37,500 | - |
| Development cost charges | - | 123,350 | 123,350 | 100% | 100% under budget | 806,024 | 859,887 |
| Transfers from reserves | 232,847 | 847,720 | 614,873 | 73% | 73% under budget | 398,146 | 986,595 |
| Transfers from reserve accounts | 84,177 | 2,411,061 | 2,326,884 | 97% | 97% under budget | 1,959,559 | 3,347,424 |
| Transfers from accumulated surplus | 19,219 | 312,508 | 293,289 | 94% | 94% under budget | 48,828 | 382,276 |
| Transfers from equity in capital assets | - | 3,087,648 | 3,087,648 | 100% | 100% under budget | 2,934,036 | 3,032,988 |
| Internal cost allocations | - | 523,163 | 523,163 | 100% | 100% under budget | 513,441 | 513,441 |
| Revenue Total | $ 17,366,631 | $ 23,055,059 | $ 5,688,428 | 25% | 25% under budget | $ 24,537,926 | $ 25,671,168 |
| Expense | |||||||
| General government services | 2,212,003 | 2,822,376 | 610,373 | 22% | 22% budget remaining | 2,913,265 | 3,874,033 |
| Protective services | 3,764,420 | 4,995,720 | 1,231,300 | 25% | 25% budget remaining | 4,471,647 | 5,098,361 |
| Transportation services | 2,304,029 | 4,067,439 | 1,763,410 | 43% | 43% budget remaining | 2,717,848 | 3,281,233 |
| Environmental health services | 2,244,295 | 2,541,128 | 296,833 | 12% | 12% budget remaining | 2,469,755 | 2,673,175 |
| Development services | 520,983 | 747,643 | 226,660 | 30% | 30% budget remaining | 540,979 | 789,877 |
| Parks services | 698,665 | 1,335,833 | 637,168 | 48% | 48% budget remaining | 885,221 | 1,279,625 |
| Recreation and culture services | 1,468,938 | 1,472,750 | 3,813 | 0% | 0% budget remaining | 1,305,807 | 1,306,032 |
| Interest on debt | 260,633 | 260,633 | 1 | 0% | 0% budget remaining | 260,633 | 260,633 |
| Principal payment on debt | 306,470 | 306,470 | 0 | 0% | 0% budget remaining | 306,470 | 306,470 |
| Amortization | - | 3,087,648 | 3,087,648 | 100% | 100% budget remaining | 2,934,036 | 3,032,988 |
| Internal cost allocations | - | 523,163 | 523,163 | 100% | 100% budget remaining | 513,441 | 513,441 |
| Transfers to reserves | 1,534,924 | 378,300 | (1,156,624) | -306% | 306% over budget | 1,213,449 | 712,300 |
| Transfers to reserve accounts | 1,610,281 | 515,956 | (1,094,325) | -212% | 212% over budget | 3,541,005 | 2,543,000 |
| Expense Total | 16,925,639 | 23,055,059 | 6,129,420 | 27% | 27% budget remaining | 24,073,555 | 25,671,168 |
| Grand Total | $ 440,992 | $ 0 | $ (440,992) | $ 464,371 | $ 0 |
Page 27
Extracted from: 2021 12 14 Committee of the Whole Agenda - Agenda - Pdf