Appendix
Schedule A – 2023 Consolidated Budget Variance
April 11, 2023Page 432 sections
A financial summary table showing year-to-date actual revenues and expenses compared to the 2023 total budget.
2023 YTD Total Revenue: $5,517,8662023 YTD Total Expense: $2,830,648Government grants and transfers YTD: $4,665,000
Report to Committee of the Whole
Re: Budget Variance and Projects Update Report to March 31, 2023
Meeting Date: April 11, 2023
Page 43
Schedule A – 2023 Consolidated Budget Variance
| Revenue | 2023 YTD | 2023 Total Budget | Variance | Variance % | Prior YTD | Prior Year Total Budget |
|---|---|---|---|---|---|---|
| Taxation | $ - | $ 11,138,941 | $ 11,138,941 | 100% under budget | $ - | $ 10,208,319 |
| User fees | (6,491) | 3,089,761 | 3,096,252 | 100% under budget | - | 2,979,060 |
| Sales of services | 443,880 | 839,250 | 395,370 | 47% under budget | 469,782 | 846,695 |
| Penalties and fines | 7,579 | 60,000 | 52,421 | 87% under budget | 13,131 | 60,000 |
| Investment income | 48,790 | 115,000 | 66,210 | 58% under budget | (140,668) | 115,000 |
| Other revenue | 185,857 | 255,200 | 69,343 | 27% under budget | 124,215 | 247,635 |
| Government grants and transfers | 4,665,000 | 4,680,388 | 15,388 | 0% under budget | 469,947 | 2,666,440 |
| Grants and contributions | - | - | - | - | 812,840 | - |
| Contributions from developers and others | 173,250 | 10,000 | (163,250) | 1,633% over budget | 6,000 | 95,000 |
| Development cost charges | - | 1,598,880 | 1,598,880 | 100% under budget | - | 496,503 |
| Transfers from reserves | - | 1,063,100 | 1,063,100 | 100% under budget | - | 1,346,427 |
| Transfers from reserve accounts | - | 3,908,168 | 3,908,168 | 100% under budget | - | 3,653,336 |
| Transfers from accumulated surplus | - | 106,150 | 106,150 | 100% under budget | - | 450,538 |
| Transfers from equity in capital assets | - | 3,200,270 | 3,200,270 | 100% under budget | 77,418 | 3,143,400 |
| Internal cost allocations | - | 544,295 | 544,295 | 100% under budget | - | 533,626 |
| Revenue Total | $ 5,517,866 | $ 30,609,403 | $ 25,091,537 | 82% 82% under budget | $ 1,832,664 | $ 26,841,979 |
| Expense | ||||||
| General government services | $ 615,468 | $ 2,885,672 | $ 2,270,204 | 79% budget remaining | $ 702,524 | $ 2,917,318 |
| Protective services | 482,747 | 5,259,575 | 4,776,828 | 91% budget remaining | 1,028,617 | 6,322,713 |
| Transportation services | 234,386 | 8,289,444 | 8,055,058 | 97% budget remaining | 1,300,817 | 3,891,755 |
| Environmental health services | 365,785 | 3,217,116 | 2,851,331 | 89% budget remaining | 253,877 | 3,169,444 |
| Development services | 126,711 | 595,390 | 468,679 | 79% budget remaining | 127,363 | 623,439 |
| Parks services | 209,488 | 1,998,721 | 1,789,233 | 90% budget remaining | 191,390 | 1,699,218 |
| Recreation and culture services | 327,895 | 1,361,309 | 1,033,414 | 76% budget remaining | 514,451 | 1,386,083 |
| Interest on debt | 108,556 | 217,112 | 108,556 | 50% budget remaining | 108,556 | 217,112 |
| Principal payment on debt | 184,364 | 315,615 | 131,251 | 42% budget remaining | 184,364 | 315,615 |
| Amortization | - | 3,200,270 | 3,200,270 | 100% budget remaining | 77,418 | 3,143,400 |
| Internal cost allocations | - | 544,295 | 544,295 | 100% budget remaining | - | 533,626 |
| Transfers to reserves | 173,250 | 686,300 | 513,050 | 75% budget remaining | - | 606,300 |
| Transfers to reserve accounts | 2,000 | 2,038,584 | 2,036,584 | 100% budget remaining | 452,654 | 2,015,956 |
| Expense Total | 2,830,648 | 30,609,403 | 27,778,755 | 91% 91% budget remaining | 4,942,030 | 26,841,979 |
| Grand Total | $2,687,217 | $0 | ($2,687,217) | ($3,109,366) | $0 |
Page 43
Extracted from: 2023 04 11 Committee of the Whole Agenda - Agenda - Pdf