Appendix
Schedule A – Consolidated Budget Variance
November 9, 2021Page 512 sections
A detailed table showing year-to-date financial variances for revenues and expenses compared to the 2021 total budget.
2021 YTD Revenue Total: $17,181,1772021 YTD Expense Total: $15,134,855
Report to Committee of the Whole Re: Budget Variance and Projects Update Report to October 31, 2021 Meeting Date: November 9, 2021
Page 51
Schedule A – Consolidated Budget Variance
| Revenue | 2021 YTD | 2021 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Taxation | $ 9,610,655 | $ 9,614,978 | $ 4,323 | 0% under budget | $ 9,219,894 | $ 9,251,211 |
| User fees | 2,831,961 | 2,822,165 | (9,796) | 0% over budget | 2,782,028 | 2,781,240 |
| Sales of services | 1,098,899 | 814,514 | (284,385) | 35% over budget | 720,598 | 817,225 |
| Penalties and fines | 96,477 | 60,000 | (36,477) | 61% over budget | 54,567 | 60,000 |
| Investment income | 80,278 | 110,000 | 29,722 | 27% under budget | 431,600 | 110,000 |
| Other revenue | 1,007,849 | 232,275 | (775,574) | 334% over budget | 444,436 | 298,743 |
| Government grants and transfers | 2,064,841 | 2,095,677 | 30,836 | 1% under budget | 4,187,270 | 3,230,138 |
| Contributions from developers and others | 183,750 | - | (183,750) | - | 37,500 | - |
| Development cost charges | - | 123,350 | 123,350 | 100% under budget | 806,024 | 859,887 |
| Transfers from reserves | 160,029 | 847,720 | 687,691 | 81% under budget | 398,146 | 986,595 |
| Transfers from reserve accounts | 27,219 | 2,411,061 | 2,383,842 | 99% under budget | 1,959,559 | 3,347,424 |
| Transfers from accumulated surplus | 19,219 | 312,508 | 293,289 | 94% under budget | 48,828 | 382,276 |
| Transfers from equity in capital assets | - | 3,087,648 | 3,087,648 | 100% under budget | 2,934,036 | 3,032,988 |
| Internal cost allocations | - | 523,163 | 523,163 | 100% under budget | 513,441 | 513,441 |
| Revenue Total | $ 17,181,177 | $ 23,055,059 | $ 5,873,882 | 25% under budget | $ 24,537,926 | $ 25,671,168 |
| Expense | ||||||
| General government services | 1,872,866 | 2,822,376 | 949,510 | 34% budget remaining | 2,913,265 | 3,874,033 |
| Protective services | 3,104,307 | 4,995,720 | 1,891,413 | 38% budget remaining | 4,471,647 | 5,098,361 |
| Transportation services | 1,964,837 | 4,067,439 | 2,102,602 | 52% budget remaining | 2,717,848 | 3,281,233 |
| Environmental health services | 2,186,519 | 2,541,128 | 354,609 | 14% budget remaining | 2,469,755 | 2,673,175 |
| Development services | 447,988 | 747,643 | 299,655 | 40% budget remaining | 540,979 | 789,877 |
| Parks services | 600,743 | 1,335,833 | 735,090 | 55% budget remaining | 885,221 | 1,279,625 |
| Recreation and culture services | 1,423,039 | 1,472,750 | 49,712 | 3% budget remaining | 1,305,807 | 1,306,032 |
| Interest on debt | 260,633 | 260,633 | 1 | 0% budget remaining | 260,633 | 260,633 |
| Principal payment on debt | 306,470 | 306,470 | 0 | 0% budget remaining | 306,470 | 306,470 |
| Amortization | - | 3,087,648 | 3,087,648 | 100% budget remaining | 2,934,036 | 3,032,988 |
| Internal cost allocations | - | 523,163 | 523,163 | 100% budget remaining | 513,441 | 513,441 |
| Transfers to reserves | 1,357,174 | 378,300 | (978,874) | 259% over budget | 1,213,449 | 712,300 |
| Transfers to reserve accounts | 1,610,281 | 515,956 | (1,094,325) | 212% over budget | 3,541,005 | 2,543,000 |
| Expense Total | 15,134,855 | 23,055,059 | 7,920,204 | 34% budget remaining | 24,073,555 | 25,671,168 |
| Grand Total | $ 2,046,322 | $0 | ($2,046,322) | $ 464,371 | $0 |
Page 51
Extracted from: 2021 11 09 Committee of the Whole Agenda - Agenda - Pdf