Appendix
Appendix: Schedule A – 2023 Consolidated Budget Variance
March 14, 2023Page 1482 sections
A financial table showing year-to-date actuals versus budgeted amounts for all revenue and expense categories for the 2023 fiscal year.
Total 2023 Budget: $30,609,403Total YTD Revenue: $653,829Total YTD Expense: $1,983,790
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to February 28, 2023
Meeting Date: March 14, 2023
Page 148
Schedule A – 2023 Consolidated Budget Variance
| 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget | |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Other revenue | $ 84,184 | $ 255,200 | $ 171,016 | 67% under budget | $ 124,215 | $ 247,635 |
| Taxation | - | 11,138,941 | 11,138,941 | 100% under budget | - | 10,208,319 |
| User fees | (5,426) | 3,089,761 | 3,095,187 | 100% under budget | - | 2,979,060 |
| Sales of services | 345,030 | 839,250 | 494,220 | 59% under budget | 469,782 | 846,695 |
| Penalties and fines | 3,859 | 60,000 | 56,141 | 94% under budget | 13,131 | 60,000 |
| Investment income | 33,681 | 115,000 | 81,319 | 71% under budget | 39,964 | 115,000 |
| Government grants and transfers | - | 4,680,388 | 4,680,388 | 100% under budget | 469,947 | 2,666,440 |
| Contributions from developers and others | 192,500 | 10,000 | (182,500) | 1,825% over budget | 6,000 | 95,000 |
| Development cost charges | - | 1,598,880 | 1,598,880 | 100% under budget | - | 496,503 |
| Transfers from reserves | - | 1,063,100 | 1,063,100 | 100% under budget | - | 1,346,427 |
| Transfers from reserve accounts | - | 3,908,168 | 3,908,168 | 100% under budget | - | 3,653,336 |
| Transfers from accumulated surplus | - | 106,150 | 106,150 | 100% under budget | - | 450,538 |
| Transfers from equity in capital assets | - | 3,200,270 | 3,200,270 | 100% under budget | - | 3,143,400 |
| Internal cost allocations | - | 544,295 | 544,295 | 100% under budget | - | 533,626 |
| Revenue Total | $ 653,829 | $ 30,609,403 | $ 29,955,574 | ** 98% under budget** | $ 1,123,038 | $ 26,841,979 |
| Expense | ||||||
| General government services | 494,216 | 2,885,672 | 2,391,456 | 83% budget remaining | 702,524 | 2,917,318 |
| Protective services | 379,878 | 5,259,575 | 4,879,697 | 93% budget remaining | 1,028,617 | 6,322,713 |
| Transportation services | 156,205 | 8,289,444 | 8,133,239 | 98% budget remaining | 514,068 | 3,891,755 |
| Environmental health services | 264,698 | 3,217,116 | 2,952,418 | 92% budget remaining | 227,786 | 3,169,444 |
| Development services | 108,675 | 595,390 | 486,715 | 82% budget remaining | 127,363 | 623,439 |
| Parks services | 106,229 | 1,998,721 | 1,892,492 | 95% budget remaining | 191,390 | 1,699,218 |
| Recreation and culture services | 281,389 | 1,361,309 | 1,079,920 | 79% budget remaining | 514,451 | 1,386,083 |
| Interest on debt | - | 217,112 | 217,112 | 100% budget remaining | 108,556 | 217,112 |
| Principal payment on debt | - | 315,615 | 315,615 | 100% budget remaining | 184,364 | 315,615 |
| Amortization | - | 3,200,270 | 3,200,270 | 100% budget remaining | - | 3,143,400 |
| Internal cost allocations | - | 544,295 | 544,295 | 100% budget remaining | - | 533,626 |
| Transfers to reserves | 192,500 | 686,300 | 493,800 | 72% budget remaining | - | 606,300 |
| Transfers to reserve accounts | - | 2,038,584 | 2,038,584 | 100% budget remaining | 426,090 | 2,015,956 |
| Expense Total | 1,983,790 | 30,609,403 | 28,625,613 | ** 94% budget remaining** | 4,025,208 | 26,841,979 |
| Grand Total | ($1,329,962) | $0 | $1,329,962 | ($2,902,170) | $0 |
Page 148
Extracted from: 2023 03 14 Committee of the Whole Agenda - Agenda - Pdf