Appendix
Schedule A – 2022 Consolidated Budget Variance
November 8, 2022Page 421 section
Financial table comparing YTD actuals to 2022 budget for all revenue and expense categories.
$19,167,247 total YTD revenue$13,855,539 total YTD expense$5,311,708 grand total surplus as of Oct 31
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,967,071 | 2,979,060 | 11,989 | 0% 0% under budget | 2,825,652 | 2,856,165 |
| Sales of services | 1,358,227 | 846,695 | (511,532) | 60% over budget | 974,535 | 814,514 |
| Penalties and fines | 100,786 | 60,000 | (40,786) | 68% over budget | 95,780 | 60,000 |
| Investment income | 296,590 | 115,000 | (181,590) | 158% over budget | (1,588) | 110,000 |
| Other revenue | 1,179,031 | 247,635 | (931,396) | 376% over budget | 1,153,791 | 232,275 |
| Government grants and transfers | 2,428,569 | 2,666,440 | 237,871 | 9% under 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 | 100% under budget | 523,163 | 523,163 |
| Revenue Total | $ 19,167,247 | $ 26,841,979 | $ 7,674,732 | 29% 29% under budget | $ 23,919,908 | $ 23,219,807 |
| Expense | ||||||
| Loss on disposal of assets | - | - | - | 3,013 | - | |
| General government services | 2,011,648 | 2,917,318 | 905,670 | 31% budget remaining | 2,763,847 | 2,898,124 |
| Protective services | 2,879,545 | 6,322,713 | 3,443,168 | 54% budget remaining | 4,783,064 | 4,995,720 |
| Transportation services | 1,654,631 | 3,891,755 | 2,237,124 | 57% budget remaining | 3,303,998 | 4,067,439 |
| Environmental health services | 2,107,845 | 3,169,444 | 1,061,599 | 33% budget remaining | 2,416,029 | 2,575,128 |
| Development services | 451,788 | 623,439 | 171,651 | 28% budget remaining | 609,189 | 747,643 |
| Parks services | 657,221 | 1,699,218 | 1,041,997 | 61% budget remaining | 845,981 | 1,390,833 |
| Recreation and culture services | 1,239,545 | 1,386,083 | 146,538 | 11% 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 | 100% budget remaining | 523,163 | 523,163 |
| Transfers to reserves | 587,300 | 606,300 | 19,000 | 3% budget remaining | 1,555,531 | 378,300 |
| Transfers to reserve accounts | 1,733,289 | 2,015,956 | 282,667 | 14% budget remaining | 2,079,108 | 515,956 |
| Expense Total | 13,855,539 | 26,841,979 | 12,986,440 | 48% 48% budget remaining | 23,747,321 | 23,219,807 |
| Grand Total | $ 5,311,708 | $ 0 | ($ 5,311,708) | $ 172,588 | $ 0 |
Page 42
Extracted from: 2022 11 08 Committee of the Whole Agenda - Agenda - Pdf