Appendix
Appendix A: Consolidated Budget Variance
October 8, 2019Page 401 section
Consolidated financial summary table for 2019 and 2018 showing revenues and expenses across all Town departments.
Revenue Total YTD: ($12,795,378)Expense Total YTD: $9,764,078
Town of View Royal Appendix A
Budget Variance and Capital Projects Update Report
Consolidated Budget Variance
For period ending September 30, 2019
| Row Labels | 2019 YTD | 2019 Budget | 2019 Variance | Var % | 2018 YTD | 2018 Budget |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| Taxation | (8,923,954) | (8,929,261) | (5,307) | 0% | (8,301,775) | (8,475,680) |
| User Fees | (525,392) | (1,365,566) | (840,174) | -62% | (523,755) | (1,346,035) |
| Sales of services | (583,070) | (814,240) | (231,170) | -28% | (1,037,096) | (812,650) |
| Other revenue | (158,319) | (338,743) | (180,424) | -53% | (112,733) | (448,065) |
| Penalties and fines | (58,556) | (58,180) | 376 | 1% | (54,322) | (58,000) |
| Investment income | (152,807) | (110,000) | 42,807 | 39% | (128,380) | (105,000) |
| Contributions from developers and others | - | (20,000) | (20,000) | -100% | - | (35,500) |
| Government grants and transfers | (2,393,280) | (3,204,915) | (811,635) | -25% | (1,873,315) | (3,251,733) |
| Proceeds from borrowing | - | - | - | - | (800,000) | |
| Transfer from reserves | - | (1,032,639) | (1,032,639) | -100% | - | (559,985) |
| Transfers from/to surplus | - | (4,278,385) | (4,278,385) | -100% | - | (2,929,373) |
| Internal cost allocations | - | (502,326) | (502,326) | -100% | - | (492,476) |
| Transfer from equity in capital assets | - | (2,979,400) | (2,979,400) | -100% | - | (2,870,900) |
| Revenue Total | (12,795,378) | (23,633,655) | (10,838,277) | -46% | (12,031,377) | (22,185,397) |
| Expense | ||||||
| General government services | 1,516,336 | 2,465,228 | 948,892 | 38% | 1,424,247 | 2,276,905 |
| Protective services | 1,808,058 | 3,938,443 | 2,130,385 | 54% | 1,923,257 | 3,615,373 |
| Transportation services | 1,510,514 | 2,951,326 | 1,440,812 | 49% | 1,503,792 | 2,714,168 |
| Environmental health services | 471,663 | 807,005 | 335,342 | 42% | 473,671 | 796,259 |
| Development services | 335,387 | 676,373 | 340,986 | 50% | 317,274 | 485,175 |
| Parks | 433,049 | 708,501 | 275,452 | 39% | 427,341 | 644,802 |
| Recreation and culture services | 1,109,677 | 1,261,969 | 152,292 | 12% | 1,114,704 | 1,248,238 |
| Interest on debt | 260,633 | 260,633 | 1 | 0% | 260,633 | 260,633 |
| Principal payment on debt | 306,470 | 306,470 | 0 | 0% | 306,470 | 306,470 |
| Transfers from/to surplus | 716,247 | 2,470,000 | 1,753,753 | 71% | 234,816 | 2,769,633 |
| Transfer to reserves | - | 666,469 | 666,469 | 100% | - | 605,280 |
| Internal cost allocations | - | 502,326 | 502,326 | 100% | - | 492,476 |
| Amortization | - | 2,979,400 | 2,979,400 | 100% | - | 2,870,900 |
| Capital | 1,296,044 | 3,639,512 | 2,343,468 | 64% | 941,005 | 3,099,085 |
| Expense Total | 9,764,078 | 23,633,655) | 13,869,577 | 59% | 8,927,209 | 22,185,397 |
| Grand Total | (3,031,300) | - | 3,031,300 | (3,104,167) | - |
Page 40
Extracted from: 2019 10 08 Committee of the Whole Agenda - Agenda - Pdf