Appendix
Appendix A: Consolidated Budget Variance
July 11, 2017Page 221 section
A detailed table showing the actual year-to-date revenue and expenses compared to the 2017 budget for the period ending June 30, 2017.
Total Revenue YTD: $12,057,920Total Expense YTD: $6,777,514Grand Total (Net): $5,280,406
2nd Quarter Budget Variance and Capital Project Update Report Appendix A
For period ending June 30, 2017 Consolidated Budget Variance
| Row Labels | 2017 YTD | 2017 Budget | 2017 Variance | Var % | 2016 Actual | 2016 Budget | |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | (7,981,803) | (8,308,904) | (327,101) | -4% | (7,473,918) | (7,403,363) | |
| User Fees | (494,693) | (1,319,347) | (824,654) | -63% | (1,272,601) | (1,272,224) | |
| Sales of services and other revenue | (1,904,906) | (1,493,902) | 411,004 | 28% | (1,436,500) | (1,143,682) | |
| Interest, penalties and fines | (12,518) | (176,466) | (163,948) | -93% | (156,619) | (173,300) | |
| Grants and contributions | (1,664,000) | (3,708,649) | (2,044,649) | -55% | (10,130,258) | (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 | (12,057,920) | (19,434,470) | (7,376,550) | -38% | (23,221,442) | (15,041,331) | |
| Expense | |||||||
| General government | 1,010,584 | 2,160,249 | 1,149,665 | 53% | 1,962,241 | 2,268,704 | |
| Protective services | 1,147,113 | 3,494,078 | 2,346,055 | 67% | 3,234,460 | 3,273,267 | |
| Transportation | 891,977 | 2,739,144 | 1,809,672 | 66% | 2,339,926 | 2,321,169 | |
| Environmental health-solid waste | 204,995 | 489,250 | 284,255 | 58% | 464,700 | 475,590 | |
| Environmental health-sewer | 511,001 | 845,097 | 334,096 | 40% | 616,478 | 767,135 | |
| Planning and development | 208,103 | 662,957 | 454,854 | 69% | 396,204 | 446,897 | |
| Parks | 190,665 | 591,546 | 351,115 | 59% | 463,357 | 501,435 | |
| Recreation and culture | 789,972 | 1,247,262 | 457,290 | 37% | 1,222,101 | 1,221,283 | |
| Fiscal services | 2,926 | 10,100 | 7,174 | 71% | 11,367 | 10,000 | |
| Amortization | - | 2,786,100 | 2,786,100 | 100% | 2,716,520 | 2,750,000 | |
| Debt interest | 274,949 | 261,633 | (13,316) | -5% | 260,633 | 263,033 | |
| Debt principal repayment | 118,731 | 385,470 | 266,739 | 69% | 385,470 | 385,470 | |
| Transfers to reserves | 832,314 | 736,949 | (95,365) | -13% | 365,751 | 270,550 | |
| General capital | 438,904 | 2,611,135 | 2,133,855 | 82% | 1,829,244 | - | |
| Sewer capital | 155,280 | 413,500 | 258,220 | 62% | 92,570 | - | |
| Expense Total | 6,777,514 | 19,434,470 | 12,530,409 | 64% | 16,361,022 | 14,954,533 | |
| Grand Total | (5,280,406) | - | 5,153,859 | (6,860,420) | (86,798) |
Page 22
Extracted from: 2017 07 11 Committee of the Whole Agenda - Agenda - Html