Appendix
Schedule A – 2023 Consolidated Budget Variance
January 9, 2024Page 1002 sections
Detailed spreadsheet comparing 2023 year-to-date actuals against the total budget for all municipal departments.
Revenue Total 2023 YTD: $28,426,712Expense Total 2023 YTD: $25,188,451Surplus/Grand Total: $3,238,261
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to December 31, 2023
Meeting Date: January 9, 2023
Page 100
Schedule A – 2023 Consolidated Budget Variance
| Revenue | 2023 YTD | 2023 Total Budget | Variance | Variance % | Status | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|---|
| Taxation | $ 11,308,449 | $ 11,318,193 | $ 9,744 | 0% under budget | $ 10,203,427 | $ 10,208,319 | |
| User fees | 3,053,445 | 3,065,159 | 11,714 | 0% under budget | 2,960,901 | 2,979,060 | |
| Sales of services | 1,665,160 | 918,800 | (746,360) | 81% over budget | 1,200,730 | 846,695 | |
| Penalties and fines | 78,420 | 76,000 | (2,420) | 3% over budget | 109,361 | 60,000 | |
| Investment income | 1,067,137 | 115,000 | (952,137) | 828% over budget | 301,274 | 115,000 | |
| Other revenue | 256,451 | 298,950 | 42,499 | 14% under budget | 420,863 | 247,635 | |
| Government grants and transfers | 7,063,327 | 8,079,172 | 1,015,845 | 13% under budget | 3,266,068 | 2,666,440 | |
| Contributions from developers and others | 945,417 | 1,059,090 | 113,673 | 11% under budget | 1,910,229 | 95,000 | |
| Development cost charges | - | 681,255 | 681,255 | 100% under budget | 119,257 | 496,503 | |
| Transfers from reserves | 526,225 | 1,736,820 | 1,210,595 | 70% under budget | 511,029 | 1,346,427 | |
| Transfers from reserve accounts | 1,918,387 | 5,702,556 | 3,784,169 | 66% under budget | 1,720,310 | 3,653,336 | |
| Transfers from accumulated surplus | - | 266,150 | 266,150 | 100% under budget | 14,384 | 450,538 | |
| Transfers from equity in capital assets | - | 3,200,270 | 3,200,270 | 100% under budget | 3,010,633 | 3,143,400 | |
| Internal cost allocations | 544,295 | 544,295 | - | 0% under budget | 533,626 | 533,626 | |
| Revenue Total | $ 28,426,712 | $ 37,061,710 | $ 8,634,998 | 23% under budget | $ 26,282,092 | $ 26,841,979 |
| Expense | 2023 YTD | 2023 Total Budget | Variance | Variance % | Status | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|---|
| General government services | $ 2,825,203 | $ 3,574,654 | $ 749,451 | 21% budget remaining | $ 2,885,352 | $ 2,917,318 | |
| Protective services | 4,771,740 | 6,035,421 | 1,263,681 | 21% budget remaining | 4,605,812 | 6,322,713 | |
| Transportation services | 2,829,821 | 6,330,553 | 3,500,732 | 55% budget remaining | 3,910,714 | 3,891,755 | |
| Environmental health services | 2,485,504 | 3,456,314 | 970,810 | 28% budget remaining | 2,709,974 | 3,169,444 | |
| Development services | 509,858 | 753,608 | 243,750 | 32% budget remaining | 561,941 | 623,439 | |
| Parks services | 1,075,321 | 2,321,212 | 1,245,891 | 54% budget remaining | 938,529 | 1,699,218 | |
| Recreation and culture services | 1,365,442 | 1,372,072 | 6,630 | 0% budget remaining | 1,383,760 | 1,386,083 | |
| Interest on debt | 217,112 | 217,112 | 1 | 0% budget remaining | 217,112 | 217,112 | |
| Principal payment on debt | 315,615 | 315,615 | (0) | 0% over budget | 315,615 | 315,615 | |
| Amortization | - | 3,200,270 | 3,200,270 | 100% budget remaining | 3,010,633 | 3,143,400 | |
| Internal cost allocations | 544,295 | 544,295 | - | 0% budget remaining | 533,626 | 533,626 | |
| Transfers to reserves | 6,265,350 | 6,392,000 | 126,650 | 2% budget remaining | 2,416,834 | 606,300 | |
| Transfers to reserve accounts | 1,983,190 | 2,548,584 | 565,394 | 22% budget remaining | 2,663,548 | 2,015,956 | |
| Expense Total | 25,188,451 | 37,061,710 | 11,873,259 | 32% budget remaining | 26,153,449 | 26,841,979 | |
| Grand Total | $ 3,238,261 | $ - | -$ 3,238,261 | $ 128,642 | $ - |
Page 100
Extracted from: 2024 01 09 Committee of the Whole Agenda - Agenda - Pdf