Appendix
Schedule A – 2022 Consolidated Budget Variance
April 12, 2022Page 772 sections
A detailed financial spreadsheet comparing 2022 year-to-date actual revenues and expenses against the annual budget.
$417,847 YTD Revenue$2,695,448 YTD ExpenseMarch 31, 2022
Report to Committee of the Whole
Budget Variance and Projects Update Report to March 31, 2022
Meeting Date: April 12, 2022
Page 77
Schedule A – 2022 Consolidated Budget Variance
| Category | 2022 YTD | 2022 Total Budget | Variance | Status | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | $ - | $ 10,129,019 | $ 10,129,019 | 100% under budget | $ - | $ 9,614,978 | |
| User fees | - | 2,997,478 | 2,997,478 | 100% under budget | 656 | 2,856,165 | |
| Sales of services | 266,025 | 846,695 | 580,670 | 69% under budget | 319,539 | 814,514 | |
| Penalties and fines | 13,349 | 60,000 | 46,651 | 78% under budget | 3,885 | 60,000 | |
| Investment income | 17,197 | 115,000 | 97,803 | 85% under budget | 17,947 | 110,000 | |
| Other revenue | 115,275 | 247,635 | 132,360 | 53% under budget | 79,729 | 232,275 | |
| Government grants and transfers | - | 2,666,440 | 2,666,440 | 100% under budget | - | 2,095,677 | |
| Contributions from developers and others | 6,000 | 95,000 | 89,000 | 94% under budget | 27,750 | - | |
| Development cost charges | - | 496,503 | 496,503 | 100% under budget | - | 123,350 | |
| Transfers from reserves | - | 1,336,627 | 1,336,627 | 100% under budget | - | 902,720 | |
| Transfers from reserve accounts | - | 3,616,750 | 3,616,750 | 100% under budget | - | 2,480,809 | |
| Transfers from accumulated surplus | - | 440,538 | 440,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 | $ 417,847 | $ 26,724,711 | $ 26,306,864 | 98% | 98% under budget | $ 449,506 | $ 23,219,807 |
| Expense | |||||||
| General government services | 544,976 | 2,870,732 | 2,325,756 | 81% budget remaining | 596,115 | 2,898,124 | |
| Protective services | 567,106 | 6,233,613 | 5,666,507 | 91% budget remaining | 526,959 | 4,995,720 | |
| Transportation services | 356,646 | 3,891,755 | 3,535,109 | 91% budget remaining | 576,490 | 4,067,439 | |
| Environmental health services | 164,982 | 3,187,862 | 3,022,880 | 95% budget remaining | 342,063 | 2,575,128 | |
| Development services | 114,888 | 623,439 | 508,551 | 82% budget remaining | 138,400 | 747,643 | |
| Parks services | 134,493 | 1,699,218 | 1,564,725 | 92% budget remaining | 210,717 | 1,390,833 | |
| Recreation and culture services | 517,936 | 1,386,083 | 868,147 | 63% budget remaining | 425,415 | 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 | - | 378,300 | |
| Transfers to reserve accounts | 1,500 | 2,015,956 | 2,014,456 | 100% budget remaining | - | 515,956 | |
| Expense Total | 2,695,448 | 26,724,711 | 24,029,263 | 90% | 90% budget remaining | 3,130,839 | 23,219,807 |
| Grand Total | -$ 2,277,600 | $0 | $2,277,600 | -$ 2,681,333 | $0 |
Page 77
Extracted from: 2022 04 12 Committee of the Whole Agenda - Agenda - Pdf