Appendix
Schedule A – 2022 Consolidated Budget Variance
February 8, 2022Page 1232 sections
A financial spreadsheet detailing year-to-date revenue and expenses compared to the 2022 total budget.
Revenue Total YTD: $109,924Expense Total YTD: $710,608Total 2022 Budget: $23,402,875
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to January 31, 2022
Meeting Date: February 8, 2022
Page 123
Schedule A – 2022 Consolidated Budget Variance
| Revenue | 2022 YTD | 2022 Total Budget | 2022 Total Variance | Status | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|---|
| Taxation | $ - | $ 10,484,768 | $ 10,484,768 | 100% under budget | $ - | $ 9,614,978 | |
| User fees | - | 2,881,841 | 2,881,841 | 100% under budget | 656 | 2,856,165 | |
| Sales of services | 100,181 | 812,906 | 712,725 | 88% under budget | 319,539 | 814,514 | |
| Penalties and fines | 1,292 | 60,000 | 58,708 | 98% under budget | 3,885 | 60,000 | |
| Investment income | - | 110,000 | 110,000 | 100% under budget | 17,947 | 110,000 | |
| Other revenue | 5,452 | 204,820 | 199,368 | 97% under budget | 79,729 | 232,275 | |
| Government grants and transfers | - | 1,378,956 | 1,378,956 | 100% under budget | - | 2,095,677 | |
| Contributions from developers and others | 3,000 | 5,000 | 2,000 | 40% under budget | 27,750 | - | |
| Development cost charges | - | 413,208 | 413,208 | 100% under budget | - | 123,350 | |
| Transfers from reserves | - | 689,987 | 689,987 | 100% under budget | - | 902,720 | |
| Transfers from reserve accounts | - | 2,509,930 | 2,509,930 | 100% under budget | - | 2,480,809 | |
| Transfers from accumulated surplus | - | 173,843 | 173,843 | 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 | - | 534,216 | 534,216 | 100% under budget | - | 523,163 | |
| Revenue Total | $ 109,924 | $ 23,402,875 | $ 23,292,951 | 100% | 100% under budget | $ 449,506 | $ 23,219,807 |
| Expense | |||||||
| General government services | 198,244 | 2,714,133 | 2,515,889 | 93% budget remaining | 596,115 | 2,898,124 | |
| Protective services | 171,049 | 4,821,067 | 4,650,018 | 96% budget remaining | 526,959 | 4,995,720 | |
| Transportation services | 41,033 | 4,000,273 | 3,959,240 | 99% budget remaining | 576,490 | 4,067,439 | |
| Environmental health services | 11,174 | 2,765,635 | 2,754,461 | 100% budget remaining | 342,063 | 2,575,128 | |
| Development services | 29,174 | 615,248 | 586,074 | 95% budget remaining | 138,400 | 747,643 | |
| Parks services | 22,174 | 1,216,828 | 1,194,654 | 98% budget remaining | 210,717 | 1,390,833 | |
| Recreation and culture services | 237,761 | 1,422,716 | 1,184,955 | 83% budget remaining | 425,415 | 1,472,750 | |
| Interest on debt | - | 260,633 | 260,633 | 100% budget remaining | 130,316 | 260,633 | |
| Principal payment on debt | - | 306,470 | 306,470 | 100% budget remaining | 184,364 | 306,470 | |
| Amortization | - | 3,143,400 | 3,143,400 | 100% budget remaining | - | 3,087,648 | |
| Internal cost allocations | - | 534,216 | 534,216 | 100% budget remaining | - | 523,163 | |
| Transfers to reserves | - | 686,300 | 686,300 | 100% budget remaining | - | 378,300 | |
| Transfers to reserve accounts | - | 915,956 | 915,956 | 100% budget remaining | - | 515,956 | |
| Expense Total | 710,608 | 23,402,875 | 22,692,267 | 97% | 97% budget remaining | 3,130,839 | 23,219,807 |
| Grand Total | -$ 600,684 | $0 | $600,684 | -$ 2,681,333 | $0 |
Page 123
Extracted from: 2022 02 08 Committee of the Whole Agenda - Agenda - Pdf