Committee of the Whole/Documents/Appendix A: Consolidated Budget Variance - For period ending March 31, 2018
Appendix
Appendix A: Consolidated Budget Variance - For period ending March 31, 2018
April 10, 2018Page 241 section
Table showing year-to-date actuals vs. budget for various revenue and expense categories for the period ending March 31, 2018.
Revenue Total (YTD): ($648,738)Expense Total (YTD): $2,325,224
Town of View Royal
Appendix A: 3rd Quarter Budget Variance and Capital Project Update Report
Consolidated Budget Variance
For period ending March 31, 2018
| Row Labels | 2018 YTD | 2018 Budget | 2018 Variance | Var % | 2017 YTD | 2017 Budget | |
|---|---|---|---|---|---|---|---|
| Revenue | |||||||
| Taxation | - | (8,475,680) | (8,475,680) | -100% | (8,255,984) | (8,308,904) | |
| User Fees | (14,900) | (1,346,035) | (1,331,135) | -99% | (1,339,414) | (1,319,347) | |
| Sales of services | (552,572) | (812,650) | (260,078) | -32% | (1,087,686) | (739,576) | |
| Other revenue | (66,939) | (448,065) | (381,126) | -85% | (252,514) | (284,726) | |
| Penalties and fines | (2,460) | (58,000) | (55,540) | -96% | (51,429) | (59,466) | |
| Investment income | (11,867) | (105,000) | (93,133) | -89% | (60,090) | (117,000) | |
| Contributions from developers and others | - | (35,500) | (35,500) | -100% | (4,772,536) | (242,000) | |
| Government grants and transfers | - | (3,251,733) | (3,251,733) | -100% | (2,935,913) | (1,882,170) | |
| Proceeds from borrowing | - | (800,000) | (800,000) | -100% | - | (650,000) | |
| Transfer from reserves | - | (559,985) | (559,985) | -100% | (409,236) | (746,552) | |
| Transfers from/to surplus | - | (2,929,373) | (2,929,373) | -100% | (2,125,779) | (1,829,029) | |
| Internal cost allocations | - | (492,476) | (492,476) | -100% | (469,600) | (469,600) | |
| Transfer from equity in capital assets | - | (2,870,900) | (2,870,900) | -100% | (2,798,629) | (2,786,100) | |
| Revenue Total | (648,738) | (22,185,397) | (21,536,659) | -97% | (24,558,810) | (19,434,470) | |
| Expense | |||||||
| General government services | 471,285 | 2,276,905 | 1,805,620 | 79% | 2,019,358 | 2,156,099 | |
| Protective services | 344,333 | 3,615,373 | 3,271,041 | 90% | 3,598,723 | 3,494,078 | |
| Transportation services | 214,876 | 2,714,168 | 2,499,292 | 92% | 2,604,329 | 2,739,144 | |
| Environmental health services | 114,418 | 796,259 | 681,841 | 86% | 753,867 | 864,747 | |
| Development services | 108,536 | 485,175 | 376,639 | 78% | 426,331 | 677,207 | |
| Parks | 91,864 | 644,802 | 552,938 | 86% | 563,880 | 591,546 | |
| Recreation and culture services | 482,153 | 1,248,238 | 766,085 | 61% | 1,213,603 | 1,247,262 | |
| Interest on debt | 130,316 | 260,633 | 130,317 | 50% | 260,633 | 261,633 | |
| Principal payment on debt | 184,364 | 306,470 | 122,106 | 40% | 385,470 | 385,470 | |
| Transfers from/to surplus | - | 2,769,633 | 2,769,633 | 100% | 2,436,426 | - | |
| Transfer to reserves | - | 605,280 | 605,280 | 100% | 1,202,490 | 736,949 | |
| Internal cost allocations | - | 492,476 | 492,476 | 100% | 469,600 | 469,600 | |
| Amortization | - | 2,870,900 | 2,870,900 | 100% | 2,798,629 | 2,786,100 | |
| Capital | 183,080 | 3,099,085 | 2,916,005 | 94% | 5,920,943 | 3,024,635 | |
| Expense Total | 2,325,224 | 22,185,397 | 19,860,173 | 90% | 24,654,282 | 19,434,470 | |
| Grand Total | 1,676,486 | - | (1,676,486) | 95,472 | - |
Page 24
Extracted from: 2018 04 10 Committee of the Whole Agenda - Agenda - Pdf