Appendix
Schedule A - 2022 Consolidated Budget Variance
July 12, 2022Page 1231 section
Financial table showing year-to-date revenue and expenses compared to the total 2022 budget.
Revenue Total YTD: $12,425,274Expense Total YTD: $6,229,155
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to June 30, 2022
Meeting Date: July 12, 2022
Schedule A – 2022 Consolidated Budget Variance
| Row Labels | 2022 YTD | 2022 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Taxation | $ 10,182,145 | $ 10,208,319 | $ 26,174 | 0% 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 | 383,554 | 846,695 | 463,141 | 55% under budget | 488,474 | 814,514 |
| Penalties and fines | 36,706 | 60,000 | 23,294 | 39% under budget | 6,544 | 60,000 |
| Investment income | 61,839 | 115,000 | 53,161 | 46% under budget | 41,556 | 110,000 |
| Other revenue | 136,076 | 247,635 | 111,559 | 45% under budget | 545,549 | 232,275 |
| Government grants and transfers | 979,427 | 2,666,440 | 1,687,013 | 63% 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 | $ 12,425,274 | $ 26,841,979 | $ 14,416,705 | ** 54% 54% under budget** | $ 11,762,487 | $ 23,219,807 |
| Expense | ||||||
| General government services | 1,277,871 | 2,917,318 | 1,639,447 | 56% budget remaining | 1,224,639 | 2,898,124 |
| Protective services | 1,623,149 | 6,322,713 | 4,699,564 | 74% budget remaining | 1,546,460 | 4,995,720 |
| Transportation services | 844,858 | 3,891,755 | 3,046,897 | 78% budget remaining | 1,238,240 | 4,067,439 |
| Environmental health services | 397,301 | 3,169,444 | 2,772,143 | 87% budget remaining | 535,279 | 2,575,128 |
| Development services | 315,139 | 623,439 | 308,300 | 49% budget remaining | 278,709 | 747,643 |
| Parks services | 350,524 | 1,699,218 | 1,348,694 | 79% 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 | 6,229,155 | 26,841,979 | 20,612,824 | ** 77% 77% budget remaining** | 7,091,792 | 23,219,807 |
| Grand Total | $ 6,196,119 | $ 0 | ($ 6,196,119) | $ 4,670,695 | $ 0 |
Page 123
Extracted from: 2022 07 12 Committee of the Whole agenda - Agenda - Pdf