Appendix
Schedule A – 2022 Consolidated Budget Variance
May 10, 2022Page 602 sections
Detailed financial table comparing actual year-to-date figures against the 2022 total budget.
Taxation budget: $10,208,319Total budget variance: $26,269,244
Report to Committee of the Whole Re: Budget Variance and Projects Update Report to April 30, 2022 Meeting Date: May 10, 2022
Page 60
Schedule A – 2022 Consolidated Budget Variance
| Row Labels | 2022 YTD | 2022 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget | |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | $ - | $ 10,208,319 | $ 10,208,319 | 100% under budget | $ 9,594,907 | $ 9,614,978 | |
| User fees | - | 2,979,060 | 2,979,060 | 100% under budget | 536,249 | 2,856,165 | |
| Sales of services | 287,582 | 846,695 | 559,113 | 66% under budget | 488,474 | 814,514 | |
| Penalties and fines | 28,434 | 60,000 | 31,566 | 53% under budget | 6,544 | 60,000 | |
| Investment income | 29,063 | 115,000 | 85,937 | 75% under budget | 41,556 | 110,000 | |
| Other revenue | 122,024 | 247,635 | 125,611 | 51% under budget | 545,549 | 232,275 | |
| Government grants and transfers | 100,000 | 2,666,440 | 2,566,440 | 96% 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 | $ 572,735 | $ 26,841,979 | $ 26,269,244 | 98% | 98% under budget | $ 11,762,487 | $ 23,219,807 |
| Expense | |||||||
| General government services | 799,090 | 2,917,318 | 2,118,228 | 73% budget remaining | 1,224,639 | 2,898,124 | |
| Protective services | 759,275 | 6,322,713 | 5,563,438 | 88% budget remaining | 1,546,460 | 4,995,720 | |
| Transportation services | 519,862 | 3,891,755 | 3,371,893 | 87% budget remaining | 1,238,240 | 4,067,439 | |
| Environmental health services | 190,794 | 3,169,444 | 2,978,650 | 94% budget remaining | 535,279 | 2,575,128 | |
| Development services | 180,879 | 623,439 | 442,560 | 71% budget remaining | 278,709 | 747,643 | |
| Parks services | 184,614 | 1,699,218 | 1,514,604 | 89% budget remaining | 381,837 | 1,390,833 | |
| Recreation and culture services | 560,350 | 1,386,083 | 825,734 | 60% 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 | 5,300 | 2,015,956 | 2,010,656 | 100% budget remaining | 1,200 | 515,956 | |
| Expense Total | 3,493,082 | 26,841,979 | 23,348,897 | 87% | 87% budget remaining | 7,091,792 | 23,219,807 |
| Grand Total | -$ 2,920,347 | $0 | $2,920,347 | $ 4,670,695 | $0 |
Page 60
Extracted from: 2022 05 10 Committee of the Whole Agenda - Agenda - Pdf