Appendix
Schedule A – 2023 Consolidated Budget Variance
December 12, 2023Page 232 sections
A detailed table showing actual versus budgeted revenues and expenses for various municipal departments.
2023 YTD Revenue Total: $25,701,0852023 YTD Expense Total: $24,096,755Investment income variance: $778,037 over budget
Report to Committee of the Whole Re: Budget Variance and Projects Update Report to November 30, 2023 Meeting Date: December 12, 2023
Page 23
Schedule A – 2023 Consolidated Budget Variance
Revenue
| Revenue | 2023 YTD | 2023 Total Budget | Variance | Variance % | 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,174 | 3,065,159 | 11,985 | 0% under budget | 2,960,901 | 2,979,060 |
| Sales of services | 1,639,227 | 918,800 | (720,427) | 78% over budget | 1,200,730 | 846,695 |
| Penalties and fines | 78,875 | 76,000 | (2,875) | 4% over budget | 109,361 | 60,000 |
| Investment income | 893,037 | 115,000 | (778,037) | 677% over budget | 301,274 | 115,000 |
| Other revenue | 253,749 | 298,950 | 45,201 | 15% under budget | 420,863 | 247,635 |
| Government grants and transfers | 7,013,603 | 8,079,172 | 1,065,569 | 13% under budget | 3,266,068 | 2,666,440 |
| Contributions from developers and others | 913,350 | 1,059,090 | 145,740 | 14% under budget | 1,910,229 | 95,000 |
| Development cost charges | - | 681,255 | 681,255 | 100% under budget | 119,257 | 496,503 |
| Transfers from reserves | - | 1,736,820 | 1,736,820 | 100% under budget | 511,029 | 1,346,427 |
| Transfers from reserve accounts | 3,326 | 5,702,556 | 5,699,230 | 100% 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 | $ 25,701,085 | $ 37,061,710 | $ 11,360,625 | 31% under budget | $ 26,282,092 | $ 26,841,979 |
Expense
| Expense | 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| General government services | $ 2,559,977 | $ 3,574,654 | 1,014,677 | 28% budget remaining | $ 2,885,352 | $ 2,917,318 |
| Protective services | 4,519,424 | 6,035,421 | 1,515,997 | 25% budget remaining | 4,605,812 | 6,322,713 |
| Transportation services | 2,468,274 | 6,330,553 | 3,862,279 | 61% budget remaining | 3,910,714 | 3,891,755 |
| Environmental health services | 2,446,925 | 3,456,314 | 1,009,389 | 29% budget remaining | 2,709,974 | 3,169,444 |
| Development services | 469,067 | 753,608 | 284,541 | 38% budget remaining | 561,941 | 623,439 |
| Parks services | 941,084 | 2,321,212 | 1,380,128 | 59% 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,984,190 | 2,548,584 | 564,394 | 22% budget remaining | 2,663,548 | 2,015,956 |
| Expense Total | 24,096,755 | 37,061,710 | 12,964,955 | 35% budget remaining | 26,153,449 | 26,841,979 |
| Grand Total | $ 1,604,330 | $ - | -$ 1,604,330 | - | $ 128,642 | $ - |
Page 23
Extracted from: 2023 12 12 Committee of the Whole Agenda - Agenda - Pdf