Appendix
Schedule A – 2023 Consolidated Budget Variance
October 10, 2023Page 262 sections
Tabular consolidated budget variance showing YTD actuals versus total 2023 budget for revenue and expense categories.
Revenue Total YTD: $21,758,079Expense Total YTD: $19,541,218Taxation Revenue YTD: $11,316,271
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to September 30, 2023 Meeting Date: October 10, 2023
ATTACHMENTS:
- Schedule A: 2023 Consolidated Budget Variance
- Schedule B: 2023 Non-core Projects
- Schedule C: 2023 Capital Projects
Page 26
Schedule A – 2023 Consolidated Budget Variance
| 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget | |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Taxation | $ 11,316,271 | $ 11,318,193 | $ 1,922 | 0% under budget | $ 10,207,973 | $ 10,208,319 |
| User fees | 703,692 | 3,065,159 | 2,361,467 | 77% under budget | 640,245 | 2,979,060 |
| Sales of services | 1,549,625 | 918,800 | (630,825) | 69% over budget | 1,139,612 | 846,695 |
| Penalties and fines | 78,346 | 76,000 | (2,346) | 3% over budget | 100,420 | 60,000 |
| Investment income | 639,769 | 115,000 | (524,769) | 456% over budget | (112,162) | 115,000 |
| Other revenue | 237,133 | 298,950 | 61,817 | 21% under budget | 1,161,299 | 247,635 |
| Government grants and transfers | 6,512,698 | 8,079,172 | 1,566,474 | 19% under budget | 2,398,907 | 2,666,440 |
| Contributions from developers and others | 176,250 | 1,059,090 | 882,840 | 83% under budget | 1,379,540 | 95,000 |
| Development cost charges | - | 681,255 | 681,255 | 100% under budget | - | 496,503 |
| Transfers from reserves | - | 1,736,820 | 1,736,820 | 100% under budget | - | 1,346,427 |
| Transfers from reserve accounts | - | 5,702,556 | 5,702,556 | 100% under budget | - | 3,653,336 |
| Transfers from accumulated surplus | - | 266,150 | 266,150 | 100% under budget | - | 450,538 |
| Transfers from equity in capital assets | - | 3,200,270 | 3,200,270 | 100% under budget | 77,418 | 3,143,400 |
| Internal cost allocations | 544,295 | 544,295 | - | 0% under budget | - | 533,626 |
| Revenue Total | $ 21,758,079 | $ 37,061,710 | $ 15,303,631 | ** 41% under budget** | $ 16,993,253 | $ 26,841,979 |
| Expense | ||||||
| General government services | $ 2,018,792 | $ 3,574,654 | $ 1,555,862 | 44% budget remaining | $ 1,933,638 | $ 2,917,318 |
| Protective services | 3,344,807 | 6,035,421 | 2,690,614 | 45% budget remaining | 3,340,000 | 6,322,713 |
| Transportation services | 1,707,925 | 6,330,553 | 4,622,628 | 73% budget remaining | 2,524,664 | 3,891,755 |
| Environmental health services | 2,259,202 | 3,456,314 | 1,197,112 | 35% budget remaining | 2,134,871 | 3,169,444 |
| Development services | 398,741 | 753,608 | 354,867 | 47% budget remaining | 442,659 | 623,439 |
| Parks services | 717,511 | 2,321,212 | 1,603,701 | 69% budget remaining | 638,167 | 1,699,218 |
| Recreation and culture services | 1,024,082 | 1,372,072 | 347,990 | 25% budget remaining | 1,051,168 | 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 | 77,418 | 3,143,400 |
| Internal cost allocations | 544,295 | 544,295 | - | 0% budget remaining | - | 533,626 |
| Transfers to reserves | 5,528,250 | 6,392,000 | 863,750 | 14% budget remaining | 1,148,000 | 606,300 |
| Transfers to reserve accounts | 1,464,887 | 2,548,584 | 1,083,697 | 43% budget remaining | 1,769,388 | 2,015,956 |
| Expense Total | 19,541,218 | 37,061,710 | 17,520,492 | ** 47% budget remaining** | 15,592,700 | 26,841,979 |
| Grand Total | $2,216,861 | $0 | ($2,216,861) | $1,400,553 | $0 |
Page 26
Extracted from: 2023 10 10 Committee of the Whole Agenda - Agenda - Pdf