Appendix
Appendix A - Consolidated Budget Variance
October 17, 2017Page 501 section
Detailed financial table comparing year-to-date actuals against the 2017 budget for various revenue and expense categories.
YTD Revenue: $13,681,538YTD Expense: $10,221,432
3rd Quarter Budget Variance and Capital Project Update Report
Appendix A Consolidated Budget Variance
As at October 11, 2017
| Row Labels | 2017 YTD | Status | 2017 Budget | 2017 Variance | Var % | 2016 Actual | 2016 Budget |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | (8,098,756) | (8,308,904) | (210,148) | -3% | (7,473,918) | (7,403,363) | |
| User Fees | (1,330,582) | (1,319,347) | 11,235 | 1% | (1,270,701) | (1,272,224) | |
| Sales of services and other revenue | (2,305,617) | (1,493,902) | 811,715 | 54% | (1,436,500) | (1,143,682) | |
| Interest, penalties and fines | (83,895) | (176,466) | (92,571) | -52% | (156,619) | (173,300) | |
| Grants and contributions | (1,862,688) | (3,708,649) | (1,845,961) | -50% | (10,132,158) | (1,864,816) | |
| Proceeds from borrowing | - | (650,000) | (650,000) | -100% | (35,026) | - | |
| Transfers from reserves | - | (746,552) | (746,552) | -100% | - | (84,896) | |
| Transfers from surplus | - | (244,550) | (244,550) | -100% | - | (349,050) | |
| Amortization offset | - | (2,786,100) | (2,786,100) | -100% | (2,716,520) | (2,750,000) | |
| Revenue Total | (13,681,538) | (19,434,470) | (5,752,932) | -30% | (23,221,442) | (15,041,331) | |
| Expense | |||||||
| General government | 1,543,236 | 2,160,249 | 617,013 | 29% | 1,962,241 | 2,268,704 | |
| Protective services | 2,010,396 | 3,494,078 | 1,483,682 | 42% | 3,234,460 | 3,273,267 | |
| Transportation | 1,675,573 | 2,739,144 | 1,036,805 | 38% | 2,339,926 | 2,321,169 | |
| Environmental health-solid waste | 346,438 | 489,250 | 142,812 | 29% | 464,700 | 475,590 | |
| Environmental health-sewer | 598,640 | 845,097 | 215,621 | 26% | 616,478 | 767,135 | |
| Planning and development | 317,306 | 662,957 | 345,651 | 52% | 396,204 | 446,897 | |
| Parks | 351,108 | 591,546 | 197,497 | 33% | 463,357 | 501,435 | |
| Recreation and culture | 948,951 | 1,247,262 | 298,311 | 24% | 1,222,101 | 1,221,283 | |
| Fiscal services | 4,953 | 10,100 | 5,147 | 51% | 11,367 | 10,000 | |
| Amortization | - | 2,786,100 | 2,786,100 | 100% | 2,716,520 | 2,750,000 | |
| Debt interest | 260,633 | 261,633 | 1,000 | 0% | 260,633 | 263,033 | |
| Debt principal repayment | 385,470 | 385,470 | - | 0% | 385,470 | 385,470 | |
| Transfers to reserves | 783,699 | 736,949 | (46,750) | -6% | 365,751 | 270,550 | |
| General capital | 833,391 | 2,611,135 | 1,739,368 | 67% | 1,829,244 | - | |
| Sewer capital | 161,638 | 413,500 | 251,862 | 61% | 92,570 | - | |
| Expense Total | 10,221,432 | 19,434,470 | 9,074,119 | 47% | 16,361,022 | 14,954,533 | |
| Grand Total | (3,460,106) | - | 3,321,187 | (6,860,420) | (86,798) |
Page 50
Extracted from: 2017 10 17 Council Agenda - Agenda - Pdf