Appendix
Schedule A – 2023 Consolidated Budget Variance
June 13, 2023Page 682 sections
A detailed table showing the 2023 year-to-date budget variances for revenue and expenses.
Revenue Total (2023 YTD): $18,188,450Expense Total (2023 YTD): $10,699,857
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to May 31, 2023
Meeting Date: June 13, 2023
Page 68
Schedule A – 2023 Consolidated Budget Variance
| Revenue | 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Taxation | $ 11,118,794 | $ 11,318,193 | $ 199,399 | 2% under budget | $10,182,145 | $ 10,208,319 |
| User fees | 702,988 | 3,065,159 | 2,362,171 | 77% under budget | 639,895 | 2,979,060 |
| Sales of services | 651,178 | 863,800 | 212,622 | 25% under budget | 588,351 | 846,695 |
| Penalties and fines | 9,182 | 76,000 | 66,818 | 88% under budget | 36,737 | 60,000 |
| Investment income | 112,299 | 115,000 | 2,701 | 2% under budget | (196,731) | 115,000 |
| Other revenue | 202,130 | 298,950 | 96,820 | 32% under budget | 142,190 | 247,635 |
| Government grants and transfers | 5,215,628 | 8,079,172 | 2,863,544 | 35% under budget | 1,504,497 | 2,666,440 |
| Contributions from developers and others | 176,250 | 1,059,090 | 882,840 | 83% under budget | 818,840 | 95,000 |
| Development cost charges | - | 681,255 | 681,255 | 100% under budget | - | 496,503 |
| Transfers from reserves | - | 1,693,920 | 1,693,920 | 100% under budget | - | 1,346,427 |
| Transfers from reserve accounts | - | 5,522,556 | 5,522,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 | 100% under budget | - | 533,626 |
| Revenue Total | $ 18,188,450 | $ 36,783,810 | $ 18,595,360 | ** 51% under budget** | $13,793,343 | $ 26,841,979 |
| Expense | ||||||
|---|---|---|---|---|---|---|
| General government services | $ 1,234,335 | $ 3,404,654 | $ 2,170,319 | 64% budget remaining | $ 1,321,724 | $ 2,917,318 |
| Protective services | 1,620,528 | 5,970,421 | 4,349,893 | 73% budget remaining | 2,077,200 | 6,322,713 |
| Transportation services | 820,079 | 6,330,553 | 5,510,474 | 87% budget remaining | 1,849,157 | 3,891,755 |
| Environmental health services | 600,564 | 3,426,814 | 2,826,250 | 82% budget remaining | 495,765 | 3,169,444 |
| Development services | 223,311 | 753,608 | 530,297 | 70% budget remaining | 327,118 | 623,439 |
| Parks services | 403,655 | 2,307,812 | 1,904,157 | 83% budget remaining | 383,039 | 1,699,218 |
| Recreation and culture services | 663,215 | 1,372,072 | 708,857 | 52% budget remaining | 652,148 | 1,386,083 |
| Interest on debt | 108,556 | 217,112 | 108,556 | 50% budget remaining | 108,556 | 217,112 |
| Principal payment on debt | 184,364 | 315,615 | 131,251 | 42% budget remaining | 184,364 | 315,615 |
| Amortization | - | 3,200,270 | 3,200,270 | 100% budget remaining | 77,418 | 3,143,400 |
| Internal cost allocations | - | 544,295 | 544,295 | 100% budget remaining | - | 533,626 |
| Transfers to reserves | 4,838,250 | 6,392,000 | 1,553,750 | 24% budget remaining | - | 606,300 |
| Transfers to reserve accounts | 3,000 | 2,548,584 | 2,545,584 | 100% budget remaining | 976,050 | 2,015,956 |
| Expense Total | 10,699,857 | 36,783,810 | 26,083,953 | ** 71% budget remaining** | 8,452,538 | 26,841,979 |
| Grand Total | $7,488,593 | $0 | ($7,488,593) | $5,340,805 | $0 |
Page 68
Extracted from: 2023 06 13 Committee of the Whole Agenda - Agenda - Pdf