Appendix
Schedule A – 2022 Consolidated Budget Variance
January 10, 2023Page 411 section
A consolidated table comparing 2022 YTD actuals against the total budget for revenues and expenses.
2022 YTD Revenue: $19,285,5652022 YTD Expense: $24,091,711
Schedule A – 2022 Consolidated Budget Variance
| 2022 YTD | 2022 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget | |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Taxation | $ 10,207,973 | $ 10,208,319 | $ 346 | 0% 0% under budget | $ 9,616,909 | $ 9,614,978 |
| User fees | 2,960,901 | 2,979,060 | 18,159 | 1% 1% under budget | 2,825,652 | 2,856,165 |
| Sales of services | 1,456,573 | 846,695 | (609,878) | 72% over budget | 974,535 | 814,514 |
| Penalties and fines | 104,243 | 60,000 | (44,243) | 74% over budget | 95,780 | 60,000 |
| Investment income | 421,013 | 115,000 | (306,013) | 266% over budget | (1,588) | 110,000 |
| Other revenue | 283,788 | 247,635 | (36,153) | 15% over budget | 1,153,791 | 232,275 |
| Government grants and transfers | 2,688,447 | 2,666,440 | (22,007) | 1% over budget | 2,551,388 | 2,095,677 |
| Grants and contributions | - | - | - | - | 529,430 | - |
| Contributions from developers and others | 629,000 | 95,000 | (534,000) | 562% over budget | 183,750 | - |
| Development cost charges | - | 496,503 | 496,503 | 100% under budget | 26,055 | 123,350 |
| Transfers from reserves | - | 1,346,427 | 1,346,427 | 100% under budget | 577,971 | 902,720 |
| Transfers from reserve accounts | - | 3,653,336 | 3,653,336 | 100% under budget | 1,949,472 | 2,480,809 |
| Transfers from accumulated surplus | - | 450,538 | 450,538 | 100% under budget | 82,078 | 318,508 |
| Transfers from equity in capital assets | - | 3,143,400 | 3,143,400 | 100% under budget | 2,831,523 | 3,087,648 |
| Internal cost allocations | 533,626 | 533,626 | - | 0% under budget | 523,163 | 523,163 |
| Revenue Total | $ 19,285,565 | $ 26,841,979 | $ 7,556,414 | 28% 28% under budget | $ 23,919,908 | $ 23,219,807 |
| Expense | ||||||
| Loss on disposal of assets | 5,474,228 | - | (5,474,228) | - | 3,013 | - |
| General government services | 2,522,988 | 2,917,318 | 394,330 | 14% budget remaining | 2,763,847 | 2,898,124 |
| Protective services | 3,924,324 | 6,322,713 | 2,398,389 | 38% budget remaining | 4,783,064 | 4,995,720 |
| Transportation services | 2,044,009 | 3,891,755 | 1,847,746 | 47% budget remaining | 3,303,998 | 4,067,439 |
| Environmental health services | 2,441,187 | 3,169,444 | 728,257 | 23% budget remaining | 2,416,029 | 2,575,128 |
| Development services | 546,794 | 623,439 | 76,645 | 12% budget remaining | 609,189 | 747,643 |
| Parks services | 798,693 | 1,699,218 | 900,525 | 53% budget remaining | 845,981 | 1,390,833 |
| Recreation and culture services | 1,379,063 | 1,386,083 | 7,020 | 1% budget remaining | 1,475,311 | 1,472,750 |
| Interest on debt | 217,112 | 217,112 | 1 | 0% budget remaining | 251,094 | 260,633 |
| Principal payment on debt | 315,615 | 315,615 | (0) | 0% over budget | 306,470 | 306,470 |
| Amortization | - | 3,143,400 | 3,143,400 | 100% budget remaining | 2,831,523 | 3,087,648 |
| Internal cost allocations | 533,626 | 533,626 | - | 0% budget remaining | 523,163 | 523,163 |
| Transfers to reserves | 2,132,926 | 606,300 | (1,526,626) | 252% over budget | 1,555,531 | 378,300 |
| Transfers to reserve accounts | 1,761,146 | 2,015,956 | 254,810 | 13% 13% budget remaining | 2,079,108 | 515,956 |
| Expense Total | 24,091,711 | 26,841,979 | 2,750,268 | 10% 10% budget remaining | 23,747,321 | 23,219,807 |
| Grand Total | ($4,806,147) | $0 | $4,806,147 | $ 172,588 | $0 |
Page 41
Extracted from: 2023 01 10 Committee of the Whole Agenda - Agenda - Pdf