Appendix
Schedule A – 2022 Consolidated Budget Variance
June 14, 2022Page 172 sections
Detailed financial table showing 2022 YTD revenues and expenses versus total budget by category.
Total Revenue YTD: $11,795,174Total Expense YTD: $5,460,112Taxation Revenue YTD: $10,012,84580% of expense budget remaining
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to May 31, 2022
Meeting Date: June 14, 2022
Page 17
Schedule A – 2022 Consolidated Budget Variance
| Row Labels | 2022 YTD | 2022 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Taxation | $ 10,012,845 | $ 10,208,319 | $ 195,474 | 2% under budget | $ 9,594,907 | $ 9,614,978 |
| User fees | 639,895 | 2,979,060 | 2,339,165 | 79% under budget | 536,249 | 2,856,165 |
| Sales of services | 355,430 | 846,695 | 491,265 | 58% under budget | 488,474 | 814,514 |
| Penalties and fines | 32,793 | 60,000 | 27,207 | 45% under budget | 6,544 | 60,000 |
| Investment income | 43,878 | 115,000 | 71,122 | 62% under budget | 41,556 | 110,000 |
| Other revenue | 134,750 | 247,635 | 112,885 | 46% under budget | 545,549 | 232,275 |
| Government grants and transfers | 569,952 | 2,666,440 | 2,096,488 | 79% under budget | 518,456 | 2,095,677 |
| Contributions from developers and others | 5,633 | 95,000 | 89,368 | 94% under budget | 30,750 | - |
| Development cost charges | - | 496,503 | 496,503 | 100% under budget | - | 123,350 |
| Transfers from reserves | - | 1,346,427 | 1,346,427 | 100% under budget | - | 902,720 |
| Transfers from reserve accounts | - | 3,653,336 | 3,653,336 | 100% under budget | - | 2,480,809 |
| Transfers from accumulated surplus | - | 450,538 | 450,538 | 100% under budget | - | 318,508 |
| Transfers from equity in capital assets | - | 3,143,400 | 3,143,400 | 100% under budget | - | 3,087,648 |
| Internal cost allocations | - | 533,626 | 533,626 | 100% under budget | - | 523,163 |
| Revenue Total | $ 11,795,174 | $ 26,841,979 | $ 15,046,805 | 56% 56% under budget | $ 11,762,487 | $ 23,219,807 |
| Expense | ||||||
| General government services | 1,076,757 | 2,917,318 | 1,840,561 | 63% budget remaining | 1,224,639 | 2,898,124 |
| Protective services | 1,434,902 | 6,322,713 | 4,887,811 | 77% budget remaining | 1,546,460 | 4,995,720 |
| Transportation services | 664,415 | 3,891,755 | 3,227,340 | 83% budget remaining | 1,238,240 | 4,067,439 |
| Environmental health services | 311,523 | 3,169,444 | 2,857,921 | 90% budget remaining | 535,279 | 2,575,128 |
| Development services | 267,011 | 623,439 | 356,428 | 57% budget remaining | 278,709 | 747,643 |
| Parks services | 285,191 | 1,699,218 | 1,414,027 | 83% budget remaining | 381,837 | 1,390,833 |
| Recreation and culture services | 652,148 | 1,386,083 | 733,936 | 53% budget remaining | 999,877 | 1,472,750 |
| Interest on debt | 108,556 | 217,112 | 108,556 | 50% budget remaining | 130,316 | 260,633 |
| Principal payment on debt | 184,364 | 315,615 | 131,251 | 42% budget remaining | 184,364 | 306,470 |
| Amortization | - | 3,143,400 | 3,143,400 | 100% budget remaining | - | 3,087,648 |
| Internal cost allocations | - | 533,626 | 533,626 | 100% budget remaining | - | 523,163 |
| Transfers to reserves | - | 606,300 | 606,300 | 100% budget remaining | 570,872 | 378,300 |
| Transfers to reserve accounts | 475,247 | 2,015,956 | 1,540,709 | 76% budget remaining | 1,200 | 515,956 |
| Expense Total | 5,460,112 | 26,841,979 | 21,381,867 | 80% 80% budget remaining | 7,091,792 | 23,219,807 |
| Grand Total | $ 6,335,062 | $ 0 | ($ 6,335,062) | $ 4,670,695 | $ 0 |
Page 17
Extracted from: 2022 06 14 Committee of the Whole Agenda - Agenda - Pdf