Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
March 12, 2015 - Special Council
THE CORPORATION OF THE MUNICIPALITY OF BAYHAM COUNCIL BUDGET MEETING AGENDA Thursday, March 12, 2015 MUNICIPAL OFFICE STRAFFORDVILLE, ONTARIO 6:30 P.M. Page 1. CALL TO ORDER 2. DECLARATION OF PECUNIARY INTEREST AND THE GENERAL NATURE THEREOF 3. 2015 - 2016 DRAFT BUDGET 2 - 35 (a) Report CAO-16/15 by Paul Shipway, Administrator re 2015 - 2016 Operating Budget - Draft 36 - 39 (b) Report CAO-18115 by Paul Shipway, Administrator re Reserves Balances - Structure 4. BY-LAW 40 (a) By-law 2015-025 Being a By-law to confirm all actions of Council 5. ADJOURNMENT (a) Adjournment Page 1 of 40 VAY11444/ '� REPORT o 0P.- , CAO PP(' unity Is�to TO: Mayor& Members of Council FROM: Paul Shipway,Administrator DATE: March 05, 2015 REPORT: CAO-16/15 SUBJECT: 2015-2016 OPERATING BUDGET-DRAFT BACKGROUND: Attached for Council review and direction is a 2015-2016 Operating Budget. The Operating Budget, as presented, introduces the finalized capital budget which includes normalized projections. This 2015-2016 Draft Operating Budget is for Council consideration and deliberation and will require additional modifications to attain a normalized levy over the next four years and into the future. The Draft Operating Budget as presented shows a 12.16% notional value 2014 levy increase. The presentation and consideration of a two(2)year Operating Budget allows Council to be aware of, and proactive towards, future financial commitments and to be able to strategically financially plan for the procurement, maintenance and/or offering of various services. Note: i. Unknown and variable 2016 Operating Budget numbers utilize the 2015 values. 2016 values are subject to change. DISCUSSION The financial environment in which Ontario Municipalities operate within is rapidly changing. Stable Provincial funding that has been historically utilized to offset Municipal Operating Budgets has significantly changed and been reduced. Further the Municipal sector anticipates additional reductions in said transfers. The most significant of the aforementioned changes in the Provincial Municipal financial relationship has been the phase-down of the Ontario Municipal Partnership Fund. The reduction in funding from 2014 to 2015 is$113,559,with additional reductions coming annually thereafter. When the OMPF reductions are coupled with the new Provincial OPP Billing model, which is an increase of$114,449 over 2014 costs, the two changes in funding and billing represent a$228,008 notional dollar increase over 2014 or a 7.6% levy increase. The combined OPP and OMPF increase is further subject to escalating energy and insurance costs, along with levies from other organizations which the Municipality has no control over. Like the Capital Budget, staff have fully incorporated all expenses into the Operating Budget and Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 2 of 40 have stopped the historic tagging practice and posting of unbudgeted liabilities. Additionally, staff have placed rolling four year average revenue projections, to ensure the same are not overstated. Looking towards 2015 and beyond, staff would respectfully note the following pressure points which Council may consider during budget deliberations, and will be critical in the future Budgets of the Municipality: i. The current Canadian Dollar value has caused the Municipality to experience significant spikes in product procurement values. ii. Capital requirements and how the same will be funded. a. Storm Sewers are a significant concern until such time(2015)as the Storm Sewers Needs Study is completed. b. Municipal Facilities. iii. Project Ojibwa and any financial responsibilities of the Municipality. From staff perspective, the greatest concern moving forward is twofold, and as a result of the continued OMPF reductions. The Municipality has historically utilized significant funds to offset the levy from the OMPF reserve. Due to the recent OMPF reductions, the Municipality has not been able to refund the OMPF reserve, and with further OMPF reductions in 2016 and beyond, without the direction of Council, said reserve will not be replenished and the combined OMPF reductions and inability to offset with reserves will be tangible. For example, in the 2015 Draft Operating Budget staff have utilized $140,000 of OMPF reserve which leaves only$120,000 in the OMPF reserve. Addressing and communicating this fact will be critical moving forward. For Council information staff present a chart which indicates the various historical Municipal Levies and the notional value increases year over year. The chart demonstrates the changes in Provincial funding. 2011 2012 2013 2014 2015 LEVY $3,029,604.00 $3,089,307.00 $3,156,307.00 $3,295,521.00 $3,696,290.00 Dollar Increase $59,703.00 $67,000.00 $139,214.00 $400,769.00 Previous Year Increase(Notional Value) 1.97 2.17 4.41 12.16 At the first scheduled Operating Budget meeting, staff will present a proposed restructuring of the current Municipal reserves. RECOMMENDATION 1. THAT Report CAO-16/15 re 2015-2016 Operating Budget-Draft be received for information; 2. AND THAT Council direct staff to schedule budget meetings. Respectfully Submitted by: Paul Shipway Administrator Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 3 of 40 Municipality of Bayham I I 2014-2015 Budget Summary 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budeet Budget Budget Budget Revenues General Taxation 3,121,468 3,113,710 3,225,715 3,323,785 3,156,307 3,295,521 - - Other Revenues 1,263,316 1,431,141 1,431,437 1,250,951 1,333,838 1,269,900 1,222,100 1,129,600 General Govemment 50,789 51,485 53,736 64,990 52,000 61,200 55,750 55,750 Council - - 9,213 22,500 22,500 22,500 - - Fire Services 5,283 30,258 18,940 68,460 12,500 60,500 13,000 13,000 Police Services 50,865 34,312 33,984 127,168 85,000 85,000 110,000 70,000 Conservation Authority - - -I -I - - - - OtherprotectiveServices 68,437 84,094 75,592 73,165 75,500 76,500 66,500 66,500 Bylaw Enforcement Services 26,476 26,363 27,788 22,715 27,400 27,200 25,000 25,000 Roads 454,364 437,508 490,292 522,448 466,600 521,600 442,678 442,678 Winter Control 12,640 11,128 11,655 11,655 12,000 12,000 12,000 12,000 Street Lights - - - - - - - Water 566,438 590,795 536,994 543,754 559,275 568,143 794,709 560,975 Richmond Water 62,200 49,248 49,056 48,480 52,948 48,336 50,753 53,290 Waste Disposal 47,552 90,838 138,988 103,742 63,000 61,500 93,190 93,190 Waste Water 865,932 753,094 741,989 771,294 736,171 730,862 782,287 815,977 Health Services 4,629 4,628 - - - - - - Cemeteries - - 762 3,765 - - - - General Assistance - - 1,150 - 1,400 1,200 - - Parks 8 Recreation 1,665 356 - 2,861 600 - 2,500 2,600 Straffordville Community Centre 17,959 15,359 12,515 16,639 14,000 23,400 - - ViennaCommunityCentre 13,523 6,079 6,172 13,788 12,000 12,000 7,000 7,000 Eden Community Centre - - - - - - - - Libraries 61,835 63,525 64,288 65,123 64,800 65,000 66,000 66,500 Museums 27,046 25,817 39,376 30,531 25,400 26,400 31,800 32,800 Planning,Development&Tourism 16,469 17,717 33,631 29,056 27,000 28,000 27,000 27,000 Business&Commerce 600 - - 640 - - - Tourism&Marketing 7,403 10,687 15,510 19,086 9,600 16,200 5,500 5,500 Environmental Services 15,638 10,202 13,035 9,761 10,000 11,500 12,838 12,838 Capital 2,111,177 2,249,113 1,249,326 1,214,683 1,568,290 1,578,700 2,599,587 227,452 8,873,106 9,108,058 8,281,144 8,360,400 8,388,769 8,603,162 6,420,192 3,719,650 Expenditures General Taxation 256 - - - 7,109 - - 5,000 5,000 Other Revenues - 5,880 - - - - - General Government 613,074 615,873 653,508 789,457 633,797 658,291 885,220 817,633 Council 89,886 76,786 76,869 87,026 91,369 99,369 75,198 75,938 Fire Services 345,462 383,814 407,692 497,186 366,554 486,814 510,783 514,991 Police Services 699,734 743,585 725,206 777,523 782,973 805,212 925,985 925,985 Conservation Authority 44,347 45,689 46,742 53,943 46,742 53,943 58,802 64,682 Other Protective Services 85,968 89,933 88,593 82,130 93,628 96,510 87,860 90,841 Bylaw Enforcement Services 45,711 52,571 51,740 40,615 70,727 69,985 38,748 39,517 Roads 1,434,377 1,293,214 1,555,607 1,456,044 1,384,193 1,445,384 1,446,906 1,472,896 Winter Control 126,066 84,918 119,793 137,343 114,724 116,937 107,000 107,600 Street Lights 64,848 58,982 70,492 77,132 70,000 70,000 54,000 35,000 Water 566,438 590,795 536,994 543,754 559,275 568,143 794,709 560,975 Municipality of Bayham 2014-2015 Budget Summary 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Expenditures(Continued) Richmond Water 62,200 49,248 49,056 48,480 52,948 48,336 50,753 53,290 Waste Water 865,932 753,094 741,989 771,294 736,171 730,862 782,287 815,977 Waste Disposal 468,569 514,981 521,805 516,410 473,024 477,016 493,368 509,224 Health Services 9,858 9,733 4,376 - 4,500 - - - Cemeteries 12,054 8,279 10,400 11,277 11,000 11,000 14,000 14,500 General Assistance 6,805 13,934 15,459 10,141 15,100 11,500 10,000 10,000 Parks 8 Recreation 55,964 68,060 52,492 66,494 61,174 54,169 54,439 55,102 Straffordville Community Centre 64,897 59,776 66,670 68,073 68,929 79,767 27,363 27,606 Vienna Community Centre 40,678 43,008 48,926 45,994 50,447 55,169 55,763 56,506 Eden Community Centre 5,770 4,871 4,419 8,062 4,460 4,621 5,225 5,336 Libraries 48,929 63,525 64,288 65,123 64,800 65,000 66,000 66,500 Museums 68,705 60,640 67,174 64,061 66,000 68,203 78,608 77,124 Planning,Development&Tourism 96,118 102,260 108,969 102,257 106,804 107,980 90,947 93,409 Business&Commerce 4,389 3,857 - - 4,460 - - Tourism&Marketing 47,954 56,777 47,481 46,983 53,336 63,263 52,500 52,500 Environmental Services 29,678 24,472 25,124 23,147 22,344 22,626 23,580 24,438 Capital 2,873,642 3,222,416 2,128,407 1,955,307 2,369,290 2,403,700 3,563,438 1,183,166 8,880,320 9,102,985 8,290,270 8,338,147 8,378,769 8,673,800 10,358,482 7,755,737 1 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 4 of 40 Municipality of Bavham 2014-2015 Summary Net(Revenue)/Expenditure 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budaet Budaet Budaet Budget General Taxation - 3,121,212 - 3,113,710 - 3,225,715 - 3,330,894 -3,156,307 - 3,295,521 5,000 5,000 Other Revenues - 1,263,316 - 1,425,261 - 1,431,437 - 1,250,951 -1,333,838 - 1,269,900 - 1,222,100 - 1,129,600 General Government 562,285 564,388 599,772 724,467 581,797 597,091 829,470 761,883 Council 89,886 76,786 67,656 64,526 68,869 76,869 75,198 75,938 Fire Services 340,178 353,557 388,752 428,726 354,054 426,314 497,783 501,991 Police Services 648,869 709,273 691,222 650,355 697,973 720,212 815,985 855,985 Conservation Authority 44,347 45,689 46,742 53,943 46,742 53,943 58,802 64,682 Other Protective Services 17,531 5,839 13,001 8,966 18,128 20,010 21,360 24,341 Bylaw Enforcement Services 19,235 26,208 23,952 17,900 43,327 42,785 13,748 14,517 Roads 980,012 855,706 1,065,315 933,596 917,593 923,784 1,004,228 1,030,218 Winter Control 113,426 73,791 108,138 125,688 102,724 104,937 95,000 95,600 Street Lights 64,848 58,982 70,492 77,132 70,000 70,000 54,000 35,000 Water - - - - - - 0 Richmond Water - - - - - - Waste Water - - - - - - - - Waste Disposal 421,017 424,143 382,816 412,668 410,024 415,516 400,178 416,034 Health Services 5,230 5,105 4,376 - 4,500 - - - Cemeteries 12,054 8,279 9,638 7,512 11,000 11,000 14,000 14,500 General Assistance 6,805 13,934 14,309 10,141 13,700 10,300 10,000 10,000 Parks&Recreation 54,299 67,704 52,492 63,634 60,574 54,169 51,939 52,502 Strattordville Community Centre 46,938 44,418 54,155 51,434 54,929 56,367 27,363 27,606 Vienna Community Centre 27,155 36,929 42,754 32,206 38,447 43,169 48,763 49,506 Eden Community Centre 5,770 4,871 4,419 8,062 4,460 4,621 5,225 5,336 Libraries - 12,907 - - - - - 0 0 Museums 41,659 34,822 27,798 33,530 40,600 41,803 46,808 44,324 Planning,Development&Tourism 79,649 84,543 75,338 73,201 79,804 79,980 63,947 66,409 Business&Commerce 4,389 3,257 - - 3,820 - - Tourism&Marketing 40,551 46,090 31,971 27,897 43,736 47,063 47,000 47,000 Environmental Services 14,040 14,271 12,089 13,386 12,344 11,126 10,742 11,600 Capital 762,465 973,302 879,081 740,623 801,000 825,000 721,851 955,714 In Year Deficit(Surplus) - - 9,125.87 - 22,253.15 - 70,638 3,696,290 4,036,086 2 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 5 of 40 Municipality of Bayham _ 2015-2016 Other Revenues 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 0520-4110 Grants&Subsidies 1,063,400.00 1,099,600.00 1,072,200.00 1,010,600.00 1,072,200 1,016,900 917,100 904,100 0520-4120 Sundry Revenue 3,175.60 37,193.40 103,719.70 - 2,511.62 2,000 2,000 2,000 2,000 0520.4130 Interest on Taxes-Current 42,931.20 40,553.92 45,374.20 44,866.06 41,000 41,000 43,000 43,000 0520-4140 Interest on Taxes-Prior 63,246.98 64,145.54 64,473.51 63,924.19 55,000 65,000 64,000 64,000 0520-4150 Investment income 59,982.04 56,676.87 60,669.74 49,072.02 70,000 60,000 45,000 50,000 0520-4180 Opening Surplus(Deficit) - 132,971.40 - - - 0520-4190 Transfer from ompf res 30,580.20 - 85,000.00 85,000.00 85,000 85,000 140,000 55,000 Railway Corridor - - - 8,638 - 11,000 11,500 1,263,316.02 1,431,141.13 1,431,437.15 1,250,950.65 1,333,838 1,269,900 1,222,100 1,129,600 Expenditures 0520-5370 Sundry - 5,879.94 - - - - - - 8 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 6 of 40 Municipality of Bayham _ 2015-2016 General Government 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 1010-4120 Tax Certificates 5,070.00 7,040.00 6,830.00 7,830.00 6,000 6,000 10,000 10,000 1010-4130 Fees&Service Charges 41,055.37 40,819.57 42,675.74 40,695.05 42,000 44,000 42,000 42,000 1010-4140 Lottery Licences 3,838.52 2,875.50 2,730.35 3,016.35 3,000 3,000 3,000 3,000 1010-4145 Manages 825.00 750.00 1,500.00 500.00 1,000 1,000 750 750 1010-4190 Contribution from Reserves - - - 12,948.44 - 7,200 50,788.89 51,485.07 53,736.09 64,989.84 52,000 61,200 55,750 55,750 1 Expenditures 1010-5100 Salaries&Wages 337,662.89 362,282.80 I 371,903.16 400,216.13 367,808 373,331 466,694 406,735 1010-5110 Statutory Benefits 25,788.82 34,720.22 1 33,042.46 42,897.62 34,351 35,085 46,000 40,700 1010-5120 Non-Statutory Benefits 54,180.69 63,383.841 61,192.14 70,296.29 65,763 67,088 74,000 79,920 1010-5140 Payroll Service Charge 4,023.99 3,917.59 1 4,241.29 4,317.37 3,800 4,000 4,000 4,000 1010-5145 Bank charges 1,647.22 1,564.60 1 1,807.51 1,686.03 1,600 1,600 1,600 1,600 1010-5160 Internet Charges 935.29 1,163.631 1,063.51 2,453.86 1,100 1,100 6,500 6,500 1010-5170 Supplies 7,801.47 8,325.48_ 9,287.24 9,247.80 9,000 9,000 9,000 9,000 1010-5180 Computer Software&Support 17,251.97 17,307.92 17,075.33 25,806.50 17,300 20,300 50,000 40,000 1010-5185 IT&GIS personnel 19,909.82 17,156.43 25,658.99 24,344.83 19,500 24,000 24,000 24,000 1010-5210 Utilities 7,587.37 6,993.71 7,305.50 8,397.81 7,300 7,300 7,600 7,900 1010-5220 Subscriptions&Publications 857.05 917.41 708.02 1,282.20 1,100 1,100 1,500 1,500 1010-5240 Advertising 1,957.01 776.74 589.65 10,124.01 1,000 1,000 2,000 2,000 1010-5250 Association&Membership Fee: 2,153.44 4,213.43 3,117.95 3,761.07 3,200 3,200 4,300 4,300 1010-5260 Auditing Fees 31,401.60 9,649.60 I 9,551.39 19,072.37 9,000 9,000 17,000 17,000 1010-5270 Building Maintenance 5,862.79 5,921.50 6,299.72 6,606.70 6,000 6,000 7,000 7,000 1010-5280 Equipment Maintenance 17,551.13 14,254.36 12,189.92 11,762.64 13,500 13,500 13,500 13,500 1010-5290 Grounds Maintenance 1,859.04 848.22 818.78 700.20 1,900 1,900 2,000 2,000 1010-5300 Insurance 17,357.13 15,426.88 16,761.92 18,388.25 16,775 18,137 19,026 19,978 1010-5305 Insurance Deductibles 10,744.00 6,605.97 12,670.11 25,292.24 10,000 10,000 30,000 30,000 1010-5310 Legal Fees 5,043.86 4,649.24 I 6,659.23 33,850.27 3,500 3,500 12,000 12,000 1010-5320 Postage&Courier 13,768.13 11,622.62 I 12,713.89 18,770.93 12,300 16,700 16,000 16,000 1010-5330 Training&Education 3,645.25_ 2,078.88 2,167.30 4,757.30 3,000 3,000 4,000 4,500 1010-5340 Conferences&Seminars 2,407.50 1,077.22 2,969.37 2,417.74 3,500 3,500 3,500 3,500 1010-5350 Travel 4,362.53 3,715.80 4,336.40 4,295.91 4,100 4,100 5,000 5,000 1010-5355 Marriage Officiant expenses 250.00 380.59 625.00 375.00 850 850 1,000 1,000 1010-5360 Telephone 10,328.71 9,732.76 8,115.29 8,168.60 9,800 9,800 10,000 10,000 1010-5370 Sundry 6,231.74 3,435.26 2,154.95 10,658.38 3,000 3,000 3,000 3,000 1010-5450 Service contracts 503.71 3,750.00 4,355.90 19,508.58 3,750 7,200 0 0 • 1010-5490 Gurantorship 45000 45000 1010-5500 Amortization 14,126 613,074.15 615,872.70 653,507.79 789,456.63 633,797 658,291 885,220 817,633 9 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 7 of 40 Municipality of Bayham 2015-2016 Council 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 1020-4130 Sundry - - 1,012.85 - - 1020-4190 Election Reserve - - 8,200.00 22,500.00 22,500 22,500 - - 9,212.85 22,500.00 22,500 22,500 - - Expenditures 1020-5100 Salaries&Wages 56,601.74 55,440.69 54,061.93 56,809.77 58,149 58,149 58,847 59,553 1020-5110 Statutory Benefits 2,483.19 2,792.44 2,608.29 2,431.55 2,768 2,768 2,801 2,835 1020-5250 Associatio&Membership 1,950.61 2,924.88 2,105.04 2,412.96 3,026 3,026 3,050 3,050 1020-5260 Prof!ServlCouncil Directed 13,535.68 1,939.03 - - - 1020-5340 Conferences&Seminars 6,949.40 6,432.25 5,403.80 4,438.51 6,926 6,926 7,000 7,000 1020-5350 Travel 1,195.65 1,142.10 949.50 1,207.56 1,750 1,750 1,750 1,750 1020-5370 Sundry 3,669.50 1,115.03 2,184.87 161.24 1,750 1,750 1,750 1,750 1020-5410 Election Expense 3,500.00 5,000.00 9,555.76 19,564.06 17,000 25,000 0 0 89,885.77 76,786.42 76,869.19 87,025.65 91,369 99,369 75,198 75,938 10 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 8 of 40 Municipality of Bayham 2015-2016 Fire Department 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 2010-4130 Fees&Service Charges 4,350.00 30,257.82 18,740.15 13,460.00 12,000 10,000 13,000 13,000 2010-4180 Donations 933.33 - 200.00 5,000.00 500 500 2010-4190 Contributions from Reserves - - - 50,000.00 - 50,000 0 0 5,283.33 30,257.82 18,940.15 68,460.00 12,500 60,500 13,000 13,000 Expenditures Fire Chief/Emergency Mgmt Office 2010-5100 Salaries&Wages 74,188.74 86,049.86 66,467.13 77,393.42 68,350 68,181 94,262 95,969 2010-5102 FireFighters Remuneration 94,068.98 103,659.55 110,941.50 113,317.65 94,000 94,000 120,000 120,000 2010-5103 FireFighters Remuneration Specialty 3,298.39 - - - - 2010-5104 FireFighters Remuneration Auxiliary 6,601.72 2,000.00 4,000.00 4,000 - 4,000 3,000 2010-5110 Statutory Benefits 14,892.60 15,306.85 17,137.01 21,594.91 14,139 14,357 22,000 24,000 2010-5120 Non-Statutory Benefits 11,274.33 16,493.30 14,911.19 14,727.09 15,255 16,565 15,905 17,178 2010-5365 Telephone-Fire Chief 2,362.72 1,398.82 1,180.43 611.54 1,500 1,500 500 500 2010-5130 Uniforms - 3,068.01 3,060.67 1,418.92 2,500 1,500 3,000 3,000 2010-5320 Postage&Courier 586.70 354.93 272.97 365.34 500 500 500 500 Emergency Planning 2010-5105 Emergency Planning-Wages 81.38 4,892.92 209.60 - 4,000 4,066 0 0 2010-5335 Emergency Planning-Training - - - 100.00 - - 0 0 2010-5150 EOC Supplies - 215.14 499.41 - 500 500 500 500 2010-5425 Public Awareness/Education 152.65 - - - - - 0 0 Fire 2010-5170 Office Supplies 885.84 736.87 551.90 393.66 1,000 1,000 600 600 2010-5160 Medical Response Supplies 5,616.08 3,877.06 3,489.43 1,803.06 2,500 2,500 2,500 2,500 2010-5165 Municipal Water Consumption - - - - - - 1,000 1,050 2010-5175 Equipment Purchase-Operating 4,166.44 11,903.41 8,745.78 14,797.66 7,500 13,500 13,500 13,500 2010-5180 Equipment Purchase-Protective 9,623.09 5,261.52 15,231.92 4,912.42 15,000 5,000 20,000 18,000 2010-5210 Utilities 12,774.49 17,786.77 30,511.37 25,023.13 15,000 20,000 20,800 21,600 2010-5240 Advertising 521.69 633.58 969.64 514.81 500 500 0 0 2010-5250 Association&Membership Fees 620.59 428.96 300.00 429.20 220 500 500 500 2010-5270 Building Maintenance 2,314.97 4,949.54 3,996.88 4,126.74 3,500 3,500 3,500 3,500 2010-5275 Cleaning Supplies 84.15 711.67 588.18 455.25 750 1,000 750 750 2010-5280 Equipment Maintenance 4,263.71 9,957.14 10,658.93 7,582.22 9,000 9,000 9,000 9,000 2010-5285 Communications Eq Maintenance 6,041.61 6,206.48 8,673.24 7,586.26 7,500 7,500 7,500 7,500 2010-5290 Grounds Maintenance 2,998.55 2,711.76 4,692.36 5,477.21 3,000 3,000 4,000 4,000 2010-5295 Vehicle Maintenance 10,651.49 8,806.86 9,409.47 14,396.82 9,000 12,500 10,000 10,000 2010-5300 Insurance 20,752.65 15,259.65 15,475.47 16,744.60 15,490 16,745 17,566 18,444 2010-5310 Legal - 442.14 80.39 36,629.75 500 50,500 0 0 2010-5325 Health&Safety - 403.76 - 1,347.30 250 500 500 500 2010-5330 Training&Education 21,756.67 24,965.22 27,193.65 19,714.23 25,000 26,000 26,000 26,000 2010-5340 Conferences&Seminars 2,286.51 2,279.36 3,416.31 1,417.04 4,000 3,000 3,000 3,000 2010-5350 Travel 2,059.24 685.41 1,252.39 1,465.23 1,000 1,000 1,000 1,000 2010-5360 Telephone-Stations 4,110.64 3,784.57 2,566.40 2,195.88 4,000 2,500 2,500 2,500 2010-5370 Sundry 1,427.74 2,270.17 3,040.89 998.38 1,500 1,500 1,000 1,000 2010-5420 Fire Prevention Expense 55.00 1,644.90 2,069.42 986.74 1,500 2,500 2,500 2,500 2010-5430 911 Dispatching 16,701.62 16,638.95 25,047.62 25,579.70 23,000 25,700 26,200 26,700 2010-5440 911 Other 3,100.50 3,080.43 3,123.45 3,190.43 3,100 3,200 3,200 3,200 2010-5450 Automatic Aid 3,858.13 1,852.03 4,436.27 2,906.08 5,000 5,000 5,000 5,000 2010-5460 Fire Pro Software 1,282.18 3,096.81 3,490.66 1,983.82 3,000 3,000 3,000 3,000 Longterm Debt Principal 41,330.96 41,331 42,815 44,353 Longterm Debt Interest 23,669.04 23,669 22,185 20,647 345,461.79 383,814.40 407,691.93 497,186.49 366,554 486,814 510,783 514,991 11 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 9 of 40 Municipality of Bayham 2015-2016 Police Services 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 2020-4120 POA 50,864.67 34,312.31 33,983.89 77,167.59 35,000 35,000 30,000 30,000 2020-4190 From Reserves - - - 50,000.00 50,000 50,000 80000 40000 50,864.67 34,312.31 33,983.89 127,167.59 85,000 85,000 110,000 70,000 Expenditures 2020-5210 utilities 65.69 1,290.40 1,304.42 787.51 1,200 1,200 2020-5270 Building Maintenance 381.60 91.58 91.58 - 100 100 2020-5290 Grounds Maintenance 446.57 152.64 152.64 152.64 200 200 2020-5300 Insurance 168.00 159.98 162.24 175.54 170 176 2020-5360 Telephone - - 50.88 - - - 2020-5450 Service Contract 696,865.15 739,105.76 721,131.06 771,987.78 776,647 799,536 913,985 913,985 2020-5470 Fees and Services 1,539.94 10000 10000 2020-5460 Police Services Board 1,807.13 2,784.76 2,312.77 2,879.20 4,656 4,000 2000 2000 699,734.14' 743,585.12' 725,205.59 777,522.61 782,973 805,212 925,985 925,985 12 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 10 of 40 Municipality of Bayham 2015-2016 Conservation Authority 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues Expenditures 2030-5460 Conservation Authority 44,347.00 45,689.00 46,742.00 53,943.00 46,742.00 53,943.00 58,802.00 64,682.20 44,347.00 45,689.00 46,742.00 53,943.00 46,742.00 53,943.00 58,802.00 64,682.20 **2016 is an estimate based on 5 year average increase. 13 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 11 of 40 Municipality of Bayham 2015-2016 Building Services 2011 2012 I 2013 2014 2013 2014 2015 2016 Actuals Actuals I Actuals Actuals Budget Budget Budget Budget Revenues 2040-4130 Building Permits 59,952.00 80,003.00 70,027.00 67,492.00 75,000 75,000 65,000 65,000 2040-4140 Septic System Permits 5,580.00 1,780.00 - - - 2040-4150 Sundry Revenues 2,905.43 2,310.70 5,565.25 5,672.50 500 1,500 1,500 1,500 68,437.43 84,093.70 75,592.25 73,164.50 75,500 76,500 66,500 66,500 Expenditures 20.40-5100 Salaries&Wages 58,630.38 63,117.59 60,194.76 55,562.75 62,272 63,201 57,502 59,227 2040-5110 Statutory Benefits 5,485.20 5,423.36 5,780.14 5,498.42 5,397 5,527 5,748 5,921 2040-5120 Non-Statutory Benefits 10,390.37 12,418.50 11,998.22 12,396.98 11,709 11,964 12,921 13,955 2040-5170 Supplies 38.48 193.98 37.13 157.35 500 500 500 500 2040-5175 Enforcement Costs 712.58 - - 500 500 0 0 2040-5220 Subscriptions and Publications 50.81 94.89 249.25_ 200 200 200 200 2040-5240 Advertising 94.03 42.73 - 169.53 100 100 0 0 2040-5510 Administrative Overhead 2,600.00 2,600.00 2,800.00 2,800.00 2,800 2,800 2,800 2,800 2040-5250 Association&Membership Fees 992.25 765.33_ 801.55 642.75 825 825 950 950 2040-5295 Vehicle Maintenance 2,038.64 1,094.20 1,173.45 675.06 1,500 1,500 1,500 1,500 2040-5300 Insurance 902.00 858.92 871.07 942.50 875 943 989 1,038 2040-5310 Legal Fees 1,261.36 160.78 1,704.71 - 2,000 2,000 0 0 2040-5330 Training&Education 508.12 724.79 662.80 216.51 1,500 3,000 1,500 1,500 2040-5340 Conferences&Seminars 898.56 1,306.93 1,256.15 1,643.18 1,500 1,500 1,500 1,500 2040-5350 Travel - - - 35.10 - - 2040-5360 Telephone 733.30 687.88 556.78 615.04 750 750 750 750 2040-5450 Contract Services 96.67 - - - 200 200 0 0 2040-5370 Sundry 535.56 443.27 507.44 774.90 1,000 1,000 1,000 1,000 85,968.31 89,933.15 88,593.45 82,130.07 93,628 96,510 87,860 90,841 14 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 12 of 40 Municipality of Bayham _ 2015-2016 Bylaw Enforcement 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 2050-4120 Dog Tag Sales 25,456.00 25,143.00 26,453.00 22,200.00 26,000 26,000 25,000 25,000 2050-4130 Administration fees 50.00 - - - 100 - 2050-4160 Fines/Court Awards - - 256.50 - 300 200 2050-4150 Recoverable Costs 970.00 1,220.00 1,078.00 515.00 1,000 1,000 0 0 26,476.00 26,363.00 27,787.50 22,715.00 27,400 27,200 25,000 25,000 Expenditures 2050-5100 Salaries&Wages 19,305.26 21,554.67 24,872.58 9,744.24 30,000 30,500 15,482 15,946 2050-5110 Statutory Benefits 1,552.74 2,844.81 1,573.07 910.61 2,798 2,861 1,404 1,446 2050-5120 Non-Statutory Benefits 3,653.65 3,630.51 3,508.19 2,466.57 5,404 5,532 2,664 2,877 2050-5170 Office Supplies 63.98 52.83 - 500 200 0 0 2050-5175 Enforcement Costs 2,016.82 208.90 313.11 6,089.76 2,000 6,000 2,000 2,000 2050-5240 Advertising 454.23 1,098.76 1,083.54 36.47 500 500 0 0 2050-5250 Association&Membership Fee - - - 500 - 110 110 2050-5295 Vehicle Maintenance 508.80 451.65 61.06 163.78 500 450 500 500 2050-5300 Insurance 902.00 858.92 871.07 942.50 875 942 989 1,038 2050-5310 Legal Fees 2,314.73 7,739.07 4,047.67 5,627.47 7,500 5,000, 0 0 2050-5320 Postage&Courier - - 300.19 250 100 0 0 2050-5330 Training&Education _ - - 1,221.12 1,000 1,000 1,200 1,200 2050-5350 Travel - - - 53.55 2,000 - 0 0 2050-5370 Sundry - 269.66 - 200 200 200 200 2050-5450 Service Contract 14,735.39 13,686.72 13,890.24 13,181.99 15,500 15,500 14,000 14,000 2050-5460 Computer and Software - - 1,032.86 1,000 1,000 0 0 2050-5475 Dog Tags-Supplies 203.15 174.90 186.07 176.58 200 200 200 200 45,710.75 52,571.40 51,739.65 40,614.64 70,727 69,985 38,748 39,517 15 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 13 of 40 I Municipality of Bayham 2015-2016 Roads Department 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 2510-4110 Grants&Subsidies 389,592.12 413,145.95 418,071.60 426,657.57 418,000 423,000 434,078 434,078 2510-4120 Sundry 22,522.30 21,961.87 31,260.71 3,550.13 6,200 6,200 6,200 6,200 2510-4140 Permit Fes 2,250.00 2,400.00 960.00 2,240.00 2,400 2,400 2,400 2,400 2510-4190 Transfer from County Reserve 40,000.00 - 40,000.00 90,000.00 40,000 90,000 - 0 454,364.42 437,507.82 490,292.31 522,447.70 466,600 521,600 442,678 442,678 Expenditures 2510-5100 Salaries&Wages 168,910.81 146,987.01 160,893.03 210,804.19 164,021 165,904 232,570 237,221 2510-5110 Statutory Benefits 44,781.97 47,276.01 49,461.89 53,980.53 51,242 52,698 55,060 56,161 2510-5120 Non-Statutory Benefits 93,371.04 102,008.69 100,648.59 107,429.95 99,678 100,410 108,443 117,118 2510-5130 Clothing Allowance 3,755.64 3,947.97 4,522.88 3,421.05 3,500 2,000 3,500 3,500 2510-5170 Materials 4,118.53 15,487.93 25,289.87 16,935.54 9,500 10,000 18,000 18,000 2510-5175 Tools 33.10 611.44 5,338.10 3,488.84 1,000 5,000 5,000 5,000 2510-5180 Fuel Clearing 132,479.67 118,059.65 147,618.50 139,226.90 113,736 113,736 125,000 125,000 2510-5185 Clearing-Other 25.00 327.71 33.08 - - - - - Vehicle Repairs-Wages 22,006.02 19,916.10 33,223.08 30,470.74 18,519 19,038 15,000 15,300 Vehicle Repairs-Materials 102,866.50 65,689.71 154,851.11 102,778.70 102,441 107,441 90,000 90,000 2510-5210 Utilities 19,085.65 15,372.82 18,353.33 21,304.78 21,855 21,855 22,729 23,638 2510-5240 Advertising - 1,783.54 122.57 480.52 250 250 - - 2510-5250 Association fees 1,057.91 1,024.45 1,645.83 1,322.54 1,000 1,000 1,000 1,000 2510-5270 Building Maintenance 17,704.64 15,805.69 19,673.07 13,233.36 14,000 14,000 12,000 12,000 2510-5275 Equipment Maintenance 13,685.82 13,221.41 11,475.94 16,485.75 12,000 10,000 12,000 12,000 2510-5290 Drainage&Assessments 68,901.78 48,800.93 3,739.68 6,332.60 1,000 59,000 4,000 4,000 2510-5291 Drainage-Wages 2,771.49 1,575.16 2,841.90 3,781.97 - 5,440 3,000 3,060 2510-5300 Insurance 44,561.46 42,433.21 44,592.80 46,562.48 43,065 46,562 48,847 56,340 2510-5310 Legal Fees,Engineer - 656.94 5,240.45 14,595.91 500 5,500 10,000 10,000 2510-5330 Training&Education 8,315.18 6,131.19 19,115.08 2,018.57 20,000 10,000 10,000 10,000 2510-5340 Conferences&Seminars 3,621.26 1,527.08 1,998.37 1,903.61 3,800 3,800 3,800 3,800 2510-5350 Travel 621.74 518.89 1,000.20 1,087.45 500 1,000 1,500 1,500 2510-5360 Telephone 4,939.34 4,195.40 2,982.53 2,401.78 3,000 3,000 2,000 2,000 2510-5370 Sundry 290.61 1,558.51 8,562.50 8,514.35 500 5,000 5,000 5,000 2510-7620 Loose Top Maintenance-Wage 13,775.29 15,818.33 10,719.37 271.36 11,640 12,239 12,239 12,239 2510-7630 Loose Top Maintenance-Mater 31,193.50 43,265.04 22,820.93 5,583.74 37,000 30,000 30,000 30,000 2510-7400 Bridge Maintenance-Wages 811.64 589.44 44.86 113.25 529 1,360 1,360 1,360 2510-7410 Bridge Maintenance-Materials 871.30 1,016.55 3,335.69 10,512.60 4,000 4,000 4,000 4,000 2510-7450 Culvert Maintenance-Wages 4,954.62 3,595.76 6,710.31 6,636.12 6,878 7,344 8,000 8,000 2510-7460 Culvert Maintenance-Material 13,695.58 2,322.66 5,038.99 5,858.91 11,000 6,000 6,000 6,000 2510-7500 Weed/Brush/Ditch-Wages 13,730.86 21,406.47 19,639.62 12,368.04 18,254 19,310 30,000 30,000 2510-7510 Weed/Brush/Ditch-Material 1,803.92 7,101.49 7,932.92 2,209.42 14,000 8,000 8,000 8,000 2510-7520 Catch Basins-Wages 3,581.06 3,378.29 6,971.25 8,381.17 6,878 7,343 7,000 7,000 2510-7530 CatchBasins-Material 7,917.23 13,160.91 14,162.21 14,011.79 2,000 2,000 10,000 10,000 2510-7600 Hardtop Maintenance-Wages 11,816.25 17,757.04 15,534.42 18,661.04 10,582 14,959 15,000 15,000 2510-7610 Hardtop Maintenance-Material 20,941.75 19,890.28 8,901.94 7,682.97 21,000 10,000 10,000 10,000 2510-7650 Grading-Wages 8,162.47 7,362.08 15,816.53 11,591.54 11,641 17,679 10,000 10,000 2510-7660 Grading-Materials 75.30 - - - - - - - 2510-7700 Dust Control-Wages 4,375.77 6,231.52 4,979.46 3,571.77 6,879 5,440 3,000 3,000 2510-7710 Dust Control-Material 709.90 - - - 1,000 1,000 1,000 1,000 2510-7800 Safety Devices-Wages 6,434.92 7,500.03 4,387.53 5,096.56 10,053 6,799 7,000 7,000 2510-7810 SafetyDevices-Material 11,087.13 13,133.64 18,763.38 15,419.05 16,320 16,320 20,000 20,000 2510-7850 Sidewalk Maintenance-Wages 6,596.66 876.39 201.83 2,259.80 5,820 1,904 6,000 6,000 2510-7860 Sidewalk Maintenance-Materia 730.66 137.38 478.78 - 3,000 3,000 4,000 4,000 2510-7900 CN Crossing Safety Devices 5,370.12 5,370.12 4,977.14 458.42 5,000 5,000 500 500 2510-7950 Road Names 1,838.42 938.31 - 2,000 2,000 2510-8000 County Roads-Wages 149,621.65 131,340.28 174,810.01 139,488.34 168,254 175,695 140,000 142,800 2510-8010 CountyRoads-Materials 356,375.52 296,104.52 386,155.63 377,306.14 325,358 325,358 325,358 325,358 1,434,376.68 1,293,213.97 1,555,607.18 1,456,044.14 1,384,193 1,445,384 1,446,906 1,472,896 16 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 14 of 40 Municipality of Bayham 2015-2016 Winter Control 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 2520-4110 Grants&Subsidies 12,640.30 11,127.80 11,655.00 11,655.00 12,000 12,000 12000 12000 Expenditures 2520-5100 Salaries&Wages 26,340.44 13,097.81 31,067.96 39,388.83 30,424 32,637 30,000 30,600 2520-5170 Materials 50,593.85 35,574.15 33,256.47 28,285.50 40,000 40,000 30,000 30,000 2520-5280 Equipment Maintenance 19,141.22 12,397.60 7,004.69 18,671.60 16,000 16,000 10,000 10,000 2520-5370 Sundry 565.88 - 610.56 565.79 300 300 - - 2520-5520 Service Contract-Pt Burwell 7,479.35 4,151.80 9,761.33 8,921.80 9,000 9,000 7,000 7,000 2520-5530 Service Contract-Vienna 8,456.26 2,655.93 7,200.77 6,797.57 5,000 5,000 5,000 5,000 2520-5540 Service Contract-Straff 3,789.60 3,924.21 8,765.78 8,116.64 4,500 4,500 4,500 4,500 2520-5550 Service Contract-Eden 3,902.49 2,050.46 4,365.51 5,093.10 3,000 3,000 3,000 3,000 2520-5555 Service Contract-Richmond 4,894.66 2,778.05 6,151.39 7,077.40 2,500 2,500 2,500 2,500 2520-5500 Service Contract-Sidewalks 902.61 8,288.34 11,608.26 14,424.46 4,000 4,000 15,000 15,000 126,066.36 84,918.35 119,792.72 137,342.69 114,724 116,937 107,000 107,600 17 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 15 of 40 Municipality of Bayham 2015-2016 Street Lights 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Expenditures 2540-5510 SLA Bayham 54000 35000 2540-5520 SLA Port Burwell 23,619.90 18,386.23 24,888.88 28,438.64 23,000 23,000 2540-5530 SLA Vienna 7,119.56 9,353.64 10,425.08 11,655.63 9,400 9,400 2540-5540 SLA Straffordville 17,872.82 19,095.42 18,428.35 20,557.87 17,200 17,200 2540-5550 SLA Eden 9,949.29 6,752.13 9,373.14 9,262.06 12,400 12,400 2540-5560 SLA Corinth 3,504.17 3,075.04 4,013.30 4,385.50 4,900 4,900 2540-5570 SLA Richmond 2,781.90 2,319.59 3,362.80 2,832.16 3,100 3,100 64,847.64 58,982.05 70,491.551 77,131.86 70,000.00 70,000.00 54,000.00 35,000.00 18 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 16 of 40 Municipality of Bayham 2015-2016 Water Services Budget 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3010-4010 Water Billings 463,749.64 479,736.79 468,511.26 478,496.94 501,970 510,911 507,523 501,613 3010-4110 Grants 40,019.68 40,019.68 - - - 3010-4120 Water Meters 2,500.00 2,719.70 3,167.50 2,360.07 2,500 2,500 2,500 2500 3010-4130 Water Sundry 3,123.23 - - - - 3010-4140 Water Connect Chgs 5,658.01 16,742.32 13,346.65 5,665.11 5,658 5,585 5,585 5,585 3010-4145 Water Services Permit fee 170.00 170.00 170.00 340.00 - - 170 170 3010-4150 Penalties&Interest 9,433.84 10,365.13 10,651.24 9,394.79 8,000 8,000 9,960 9,960 3010-4160 Landowners Debenture Payments 41,783.70 41,041.35 41,147.40 41,147.40 41,147 41,147 41,147 41,147 3010-4190 Contributions from Reserves 6,349.36 227,824 566,438.10 590,794.97 536,994.05 543,753.67 559,275 568,143 794,709 560,975 Expenditures 3010-5100 Salaries&Wages 74,694.54 44,382.61 44,131.47 51,841.68 47,627 50,291 52,303 54,395 3010-5110 Statutory Benefits 7,051.94 3,645.69 4,129.07 5,663.38 4,288 4,470 5,891 6,126 3010-5120 Non Statutory Benefits 14,814.18 8,215.89 8,939.81 10,293.06 9,147 9,751 ' 21,916 23,669 30.10.5170 Supplies 1,053.78 2,928.96 2,086.02 1,483.26 1,800 1,800 1,800 1,800 3010-5175 Tools and Equipment - 17.73 372.93 294.08 500 500' 500 500 3010-5180 Lab Fees 4,547.66 4,964.89 4,268.85 4,954.69 5,000 5,000 5,000 5,100 3010-5210 Utilities 1,891.55 1,978.83 1,858.42 1,169.03 2,075 2,075' 2,158 2,245 3010-5240 Advertising - - - 206 206 0 0 3010-5250 Association Fees 538.38 516.94 519.45 549.44 550 550' 700 750 3010-5260 Auditing Fees 1,750.00 3,757.20 3,408.96 6,210.09 3,400 3,400 3,500 3,600 3010-5280 System Maintenance 6,022.92 6,507.33 6,282.66 9,027.11 6,550 6,550 6,700 6,800 3010-5295 Vehicle maintenance 378.29 971.78 504.73 734.74 700 700, 700 700 3010-5300 Insurance 676.00 643.71 5,927.98 706.36 655 706 741 778 3010-5310 Legal Fees 548.49 - 200.97 - - 400 400 3010-5320 Truck water distribution 3,625.01 2,324.68 3,021.45 3,852.45 2,850 2,850 0 0 3010-5330 Training&Education 1,662.53 1,850.92 1,193.73 1,876.36 1,900 1,900, 1,900 1,900 3010-5335 Licences - 115.00 172.50 57.50 150 150 0 450 3010-5340 Conferences&Seminars 650.00 1,880.96 797.07 2,087.79 2,000 2,000, 2,000 2,000 3010-5360 Telephone&Internet 1,929.08 676.89 768.42 559.07 2,000 2,000 2,000 2,000 3010-5370 Sundry - 4,981.66 24.93 100 100, 100 100 3010-5375 Long Term Debt Principal 7,386.39 30,495.02 32,729.47 34,085.14 31,428 32,729 222,824 0 3010-5380 Long Term Debt Interest 3,625.60 13,552.94 11,318.49 9,962.82 12,620 11,319 5,000 0 3010-5400 Transfers to Reserves 156,142.03 153,637.66 70,845.22 94,544 108,696 103,149 118,298 3010-5410.Water Quality Management - 2,803.49 2,257.94 1,272.00 3,000 3,000 3,100 3,200 3010-5450 Secondary Water System Costs 191,489.67 212,795.58 239,166.88 275,079.67 231,013 221,158 246,147 227,212 3010-5510 Administrative Overhead 4,945.00 4,945.00 5,400.00 5,400.00 4,945 5,400 5,500 5,600 3010-5520 Primary Water System Costs 71,887.68 75,686.76 84,898.91 107,951.33 84,227 86,842 96,581 89,151 3010-5620 Utility Adjustments 9,127.38 6,516.85 1,767.72 8,642.62 6,000 4,000 4,100 4,200 566,438.10 590,794.97 536,994.05 543,753.67 559,275 568,143 794,709 560,975 • Net(Revenue)/Expenditure - - - - - - - 0.00 19 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 17 of 40 Municipality of Bayham 2015-2016 Richmond Water Budget r 2011 2012 2013 _ 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3015-4160 Water Billings 49,248.00 49,248.00 49,056.22 48,336.00 49,248 48,336 50,753 53,290 3015-4190 Contribution from Reserves 12,951.83 - - 144.40 3,700 - 62,199.83 49,248.00 49,056.22 48,480.40 52,948 48,336 50,753 53,290 Expenditures - 3015-5100 Salaries&Wages 19,405.70 18,333.78 14,303.56 16,970.30 20,242 19,868 20,664 21,284 3015-5110 Statutory Benefits 2,559.72 2,000.00 1,821.19 - 1,822 1,766 1,837 1,892 3015-5120 Non Statutory Benefits 207.84 2,721.95 2,597.33 2,751.78 3,476 3,852 812 877 3015-5170 Supplies 8,991.01 4,039.06 4,539.50 2,554.15 5,000 3,000 3,100 3,200 3015-5175 Tools and Equipment - - 59.14 150 150 200 200 3015-5180 Lab Fees 6,432.23 5,546.42 8,821.57 4,368.57 6,000 3,500 3,600 3,700 3015-5210 utilities 3,962.47 3,620.70 3,598.25 4,866.71 4,000 4,000 4,160 4,326 3015-5215 Property razes - - 1,992.26 - 2,000 2,000 2,000 3015-5240 Advertising - - - 75 75 0 0 3015-5250 Association Fees - - - 89.67 82 81 150 175 3015-5260 Auditing Fees - 608.80 - 5,288.80 - - 3015-5275 Water Quality Management - - - 3,372.17 2,000 2,000 2,200 2,400 3015-5280 System Maintenance 14,905.84 1,273.40 2,626.52 1,904.01 2,000 2,000 2,000 2,000 3015-5285 Equipment Maintenance 1,000 1,000 3015-5295 Vehicle maintenance - - 132.75 283.16 331 331 300 300 3015-5320 Richmond Truck 5,333.66 5,635.74 4,828.17 3,176.15 5,500 2,750 2,800 2,900 3015-5330 Training&Education - - 375.00 502.88 725 725 700 700 3015-5335 Licences - - 287.50 57.50 345 345 0 450 3015-5340 Conferences&Seminars - - 153.42 346.07 400 400 400 400 3015-5310 Legal Fees 235.07 - 884.29 - - 0 0 3015-5360 Richmond Water Amtelecom 166.29 647.41 799.27 1,058.41 800 1,200 1,200 1,200 3015-5400 Transfers to Reserves - 2,820.74 1,236.50 890.07 - 293 3,630 4,286 3015-5510 Administrative Overhead - 2,000.00 - - - 62,199.83 49,248.00 49,056.22 48,480.40 52,948 48,336 50,753 53,290 Net(Revenue)/Expenditure - - - - - - - 20 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 18 of 40 Municipality of Bayham 2015.2016 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3020-4010 Sewer Billings 623,882.93 633,151.38 636,025.00 639,449.89 633,871 638,649 682,784 716,474 3020-4120 Sewer Sundry Charges 1,020.00 229.55 - - 265.50 1,200 1,200 1,200 1,200 3020-4130 Septage Receiving Charges 10,005.67 6,242.38 - 10,000 - 0 0 3020-4140 Sewer Connection Charges - 21,560.40 15,075.24 35,241.77 - 2,000 2,000 3020-4150 Penalties&Interest 5,508.00 4,257.44_ 5,375.09 5,800.25 5,500 5,500 5,235 5,235 3020-4160 Landowner Debenture Payments 225,515.87 87,653.22 85,513.27 91,067.87 85,600 85,513 91,068 91,068 865,932.47 753,094.37 741,988.60 771,294.28 736,171 730,862 782,287 815,977 Expenditures-Administrative 3020-5100 Salaries&Wages 148,277.70 156,335.75 144,246.36 144,166.08 170,267 178,193 186,361 191,952 3020-5110 Statutory Benefits 14,878.22 15,472.16 16,535.86 15,633.06 15,331 15,838 16,258 16,746 3020-5120 Non Statutory Benefits 22,566.22 25,819.09 32,221.17 26,671.44 32,701 34,551 20,165 21,779 3020-5130 Clothing Allowance 503.58 411.10 230.99 368.36 633 633 600 600 3020-5140 Man Hours One Call _ 3,800 3,800 3020-5240 Advertising 194.52 345.98 - 200 200 0 0 3020-5250 Association&Mem Fees 199.97 203.52 206.03 279.25 200 200 400 450 3020-5260 Auditing Fees 1,850.00 3,757.20 3,408.96 6,130.45 3,400 3,400 3,500 3,600 3020-5305 Insurance 5,654.00 15,383.97 5,460.11 5,907.89 5,465 5,908 6,198 6,508 3020-5330 Training&Education 1,053.95 973.47 - 310.00 2,300 2,300 2,300 2,300 3020-5335 Licences 75.00 150.00 150.00 225.00 150 150 200 200 3020-5340 Conferences&Seminars 1,833.76 - 1,225.83 1,963.78 2,500 2,500 2,600 2,700 3020-5350 Travel 324.90 159.75 40.00 107.00 250 250 250 250 3020-5360 Telephone&Internet 4,350.52 3,272.46 2,989.94 2,776.79 3,500 3,500 3,200 3,300 3020-5370 Sundry 75.00 - 24.93 112 112 100 100 3020-5375 Long Term Debt Principal 203,690.66 106,629.47 - 0 0 3020-5380 Long Term Debt Interest 16,252.04 3,341.88 - - - 0 0 3020-5400 Transfers to Reserves 245,222.39 200,452.09 340,918.16 352,912.73 281,229 265,094 315,515 334,463 3020-5510 Administrative Overhead 8,282.00 9,200.00 9,500.00 9,500.00 9,200 9,500 9,500 9,500 3020-5580 Writeoffs - 21,693.76 - - - 675,284.43 563,601.65 557,158.34 566,951.83 527,438 522,329 570,947 598,247 Expenditures-Treatment Plant 3020-5180 Lab Fees 11,517.62 10,416.69 9,684.02 10,552.00 9,800 9,800 9,800 9,900 3020-5190 Chemicals 8,783.11 9,225.12 7,736.70 6,337.16 7,800 7,800 7,500 7,600 3020-5210 Utilities Plant 57,304.93 58,550.36 67,547.72 75,010.23 64,000 64,000 66,560 69,225 3020-5170 Supplies-Plant 1,741.16 954.08 925.59 1,449.68 1,600 1,600 1,600 1,600 3020-5215 Property taxes 5,484.68 6,547.50 4,123.70 1,033.00 4,683 4,683 4,800 4,900 3020-5270 Building/Plant Maintenance 8,699.86 5,745.69 2,825.93 5,389.82 7,500 7,500 7,500 7,600 3020-5285 EquipmentMtce-Plant 16,176.55 9,455.93 7,479.35 16,386.87 13,000 13,000 13,300 13,600 3020-5290 Grounds Maintenance 1,963.98 2,986.15 3,570.39 4,164.51 2,100 2,500 2,500 2,600 3020-5300 Sludge Haulage/Disposal 11,372.94 16,551.77 15,316.30 9,947.29 18,750 18,750 16,500 17,000 3020-5315 Odour Control(septage) - - - - 750 - 0 0 123,044.83 120,433.29 119,209.70 130,270.56 129,983 129,633 130,060 134,025 Expenditures-Collection System 3020-5320 Trucks 2,334.90 3,146.60 2,376.02 3,305.34 3,000 3,000 3,100 3,200 3020-5175 Supplies-Collection 1,012.55 607.00 747.45 631.92 900 900 900 900 3020-5211 Utilities-Collection System 24,028.16 24,642.43 23,976.45 31,515.56 27,000 27,000 28,080 29,305 3020-5275 Odour Control 18,381.54 24,519.43 22,922.46 21,269.43 24,000 24,000 24,500 25,000 3020-5280 System Maintenance 21,319.81 14,613.57 14,429.02 14,724.27 23,000 23,000 23,500 24,000 3020-5295 Vehicle Maintenance 526.25 1,530.40 1,169.16 2,625.37 850 1,000 1,200 1,300 I 67,603.21 69,059.43 65,620.56 74,071.89 78,750 78,900 81,2801 83,705 Total Expenditures 865,932.47 753,094.37 741,988.60 771,294.28 736,171 730,862 782,2871 815,977 Net(Revenue)/Expenditure - - - - - - - 1 0.00 21 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 19 of 40 Municipality of Bayham 2015-2016 Waste Disposal 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3030-4110 Grants 47,551.69 48,053.66 83,417.87 45,964.84 54,000 54,000 47,190 47,190 3030-4120 Sundry-WDO 7,302.91 42,784.72 55,570.40 57,777.60 9,000 7,500 46,000 46,000 54,854.60 90,838.38 138,988.27 103,742.44 63,000 61,500 93,190 93,190 Expenditures 3030-5100 Salaries and Wages 1,310.68 5,055.15 2,473.84 181.48 2,500 2,500 500 500 3030-5240 Advertising 259.49 1,900.10 1,786.13 1,788.11 1,000 1,100 1,000 1,000 3030-5450 Waste Disposal 285,915.40 295,545.03 291,829.84 289,571.54 289,774 295,571 304,438 313,571 3030-5455 Recycling 162,237.05 183,538.22 197,550.18 196,814.81 154,750 152,845 157,430 162,153 3030-5460 Large Item Drop of/HHW Day 18,846.39 28,942.39 28,164.62 28,054.22 25,000 25,000 30,000' 32,000 468,569.01 514,980.89 521,804.61 516,410.16 473,024 477,016 493,368 509,224 22 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 20 of 40 Municipality of Bayham 2015-2016 Health Services 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3510-4110 Grants&Subsidies 4,628.75 4,628.00 - - - - - Expenditures 3510-5100 Salaries&Wages 221.19 756.93 - - - - 3510-5120 Non Statutory Benefits - - - - - - 3510-5210 Utilities 3,692.18 3,297.91 1,757.78 - 1,500 - 3510-5270 Building Maintenance 2,208.65 3,112.88 998.72 - 1,500 - 3510-5290 Grounds Maintenance 1,878.42 789.52 215.07 - 400 - 3510-5300Insurance 1,826.00 1,738.79 1,361.62 - 1,000 - 3510-5370 Sundry 32.00 36.72 42.74 - 100 - 9,858.44 9,732.75 4,375.93 - 4,500 - 23 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 21 of 40 Municipality of Bayham 2015-2016 Cemeteries 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 3520-4120 Sundry Revenue - - 762.00 3,765.00 - - - - Expenditures 3520-5290 Grounds Maintenance 8,750.65 6,057.57 7,164.41 10,678.01 8,000 7,500 12500 13000 3520-5370 Sundry/Interest 1,972.64 1,869.52 3,235.56 599.29 2,000 3,500 1500 1500 Inactive Cemetery Improvement 1,331.18 351.63 - 1,000 - - - 12,054.47 8,278.72 10,399.97 11,277.30 11,000 11,000 14,000 14,500 24 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 22 of 40 Municipality of Bayham 2015-2016 General Assistance 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 40104190 Grants and Donations - - 1,150.00 - 1,400 1,200 Expenditures 4010-5590 General Assistance Grants 6,804.63 13,934.32 15,459.43 10,140.93 15,100 11,500 10,000 10,000 6,804.63 13,934.32 15,459.43 10,140.93 15,100 11,500 10,000 10,000 25 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 23 of 40 Municipality of Bayham 2015-2016 Parks&Recreation 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals i Actuals Actuals Budget Budget Budget Budget Revenues 4510-4110,Grants&Subsidies 1,400.00 - - 2,460.65 600 - 2500 2600 4510-41200ISundry 15.00 356.40 - 400.00 - - 4510-41801Special events 250.00 - - - - - - - 1,665.00 356.40 - 2,860.65 600 - 2,500 2,600 Expenditures 4510-5100jSalaries&Wages 25,634.29 18,182.73 10,058.39 15,307.57 18,519 10,879 11,000 11,000 4510-5110iStatutoryBenefits - - 596.91 - 1,099 994 994 994 4510-517DSupplies - 669.75 1,129.93 905.94 525 525 700 700 4510-521dUtilities 3,576.60 3,501.06 3,672.30 4,341.56 3,500 3,500 3,640 3,785 4510-5241 Advertising 179.63 - - - 100 100 - - 4510-5270 Building Maintenance 1,036.08 2,594.16 1,105.97 1,650.52 1,250 1,250 1,500 1,500 4510-5280Equipment Maintenance 571.66 926.51 175.95 568.49 500 500 700 700 4510-52901Grounds Maintenance 14,480.07 32,836.29 26,047.52 30,483.80 25,541 25,541 25,541 25,541 4510-530DInsurance 9,455.00 9,003.43 9,130.77 9,879.57 9,140 9,880 10,364 10,882 4510-53701Sundry - 182.15 366.34 - 500 500 - - 4510-55901GeneralAssistance - - - _ 3,348.09 500 500 - _ - 4510-56001Canada Day 1,030.42 100.00 208.17 8.80 - - 4510-5620 Special Events-Other - 64.41 - - - - - - 55,963.75 68,060.49 52,492.25 66,494.34 61,174 54,169 54,439 55,102 26 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 24 of 40 Municipality of Bayham 2015-2016 Straffordville Community Centre 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget RevenuesII 4520-4120 Sundry Revenue - - 4520-4130 Rentals 17,444.24 14,570.00 12,515.00 7,200.39 14,000 14,000 4520-4140 Mix 465.00 788.74 - - - 4520-4180 Donations 50.00 - - 38.45 - - 4520-4190 Contributions from Reserves - - - 9,400.00 - 9,400 17,959.24 15,358.74 12,515.00 16,638.84 14,000 23,400 - - Expenditures 4520-5100 Salaries&Wages 12,424.36 12,100.62 12,454.84 16,999.48 12,100 12,282 4520-5110 Statutory Benefits 631.86 738.79 857.20 1,082.07 934 1,000 4520-5170 Supplies 2,426.18 1,336.39 1,141.47 557.35 2,000 2,000 4520-5210 Utilities 19,655.35 17,159.31 19,409.56 17,593.10 21,000 21,000 15,000 15,000 4520-5240 Advertising - - 536.31 803.86 500 750 4520-5270 Building Maintenance 1,666.98 1,501.87 3,797.02 11,253.92 3,300 12,700 2,500 2,500 4520-5280 Equipment Maintenance 2,977.07 2,735.50 3,245.39 1,234.45 3,000 3,000 4520-5290 Grounds Maintenance 6,005.20 5,943.15 5,411.57 5,054.91 6,000 6,500 5,000 5,000 4520-5300 Insurance 4,436.00 4,224.14 4,283.88 4,635.20 4,290 4,635 4,863 5,106 4520-5360 Telephone 447.82 519.56 894.96 883.50 1,000 1,000 4520-5370 Sundry 528.34 584.36 504.00 92.38 900 900 4520-5450 Service Contract 13,698.00 12,932.57 14,133.58 7,882.58 13,905 14,000 64,897.16 59,776.26 66,669.78 68,072.80 68,929 79,767 27,363 27,606 27 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 25 of 40 Municipality of Bayham 2015-2016 Vienna Community Centre 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 4530-4130 Rentals 13,523.00 6,079.00 6,171.90 8,787.99 12,000 7,000 7000 7000 45304190 Contribution from Reserves - - - 5,000.00 - 5,000 13,523.00 6,079.00 6,171.90 13,787.99 12,000 12,000 7,000 7,000 Expenditures 4530-5100 MgmtContract 9,499.92 9,898.08 10,077.70 9,422.71 9,500 10,284 13,000 13,000 4530-5110 Statutory Benefits 153.52 200 200 4530-5170 Supplies 1,414.71 1,474.42 803.77 896.00 1,500 1,500 1,000 1,000 4530-5210 Utilities 6,672.38 9,042.03 9,623.03 13,738.36 9,000 9,200 12,500 13,000 4520-5240 Advertising - - 536.35 571.74 500 750 0 0 4530-5270Building Maintenance 694.67 3,502.96 6,680.92 1,202.50 4,600 9,600 5,000 5,000 4530-5280i.Equipment Maintenance 2,641.75 3,020.56 6,909.71 2,586.19 3,000 3,100 3,100 3,100 4530-5290 Grounds Maintenance 5,357.17 2,991.29 3,525.95 2,912.84 5,000 5,000 5,000 5,000 4530-5300,Insurance 4,436.00 4,224.14 4,283.88 4,635.20 4,847 4,635 4,863 5,106 4530-5360ITelephone 460.06 605.50 1,058.59 920.16 1,000 1,100 1,100 1,100 4530-5370ISundry 213.04 348.98 - 7.91 1,000 1,000 0 0 4530-5450IService Contract 9,288.00 7,900.09 5,426.49 8,946.75 10,500 9,000 10,000 10,000 40,677.70 43,008.05 48,926.39 45,993.88 50,447 55,169 55,763 56,506 28 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 26 of 40 Municipality of Bayham 2015-2016 Eden Community Centre 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 4535-4130 Rentals - - - - - - 45.5-4180 Donations - - - - - - - - Expenditures 4535-5210 Utilities - - - - 88.48 - - 0 0 4535-5270 Building Maintenance 2,244.54 1,228.79. 876.02 528.98 750 750 1000 1000 4535-5280 Equipment Maintenance - - 117.02 - 250 250 500 500 4535-5290 Grounds Maintenance 1,495.86 1,709.54 1,465.32 5,500.00 1,500 1,500 1500 1500 4535-5300 Insurance 2,030.00 1,933.05 1,960.39 2,121.16 1,960 2,121 2,225 2,336 5,770.40 4,871.38 4,418.75 8,061.66 4,460 4,621 5,225 5,336 29 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 27 of 40 Municipality of Bayham 2015-2016 Libraries -- - 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 45404130 Lease Revenues 61,835.33 63,525.42 64,287.73 65,123.48 64,800 65,000 66,000 66,500 Expenditures 4540-5210 Utilities 9,965.48 9,108.54 9,333.48 8,600.74 10,500 10,500 9,289 10,032 4540-5270 Building Maintenance 7,802.51 7,486.79 10,139.55 13,390.12 8,500 8,500 10,000 10,000 4540-5290 Grounds Maintenance 4,006.76 1,683.11 2,062.38 1,979.68 3,400 3,400 2,500 2,500 4540-5300 Insurance 2,154.00 2,051.13 2,080.14 2,250.72 2,080 2,251 2,361 2,479 4540-5510 Administrative Overhead - - - - 2,000 4540-5400 Library Reserve 25,000.00 43,195.85 40,672.18 38,902.22 40,320 38,349 41,850 41,489 48,928.75 63,525.42 64,287.73 65,123.48 64,800 65,000 66,000 66,500 30 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 28 of 40 Municipality of Bayham 2015-2016 - Museums 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 4550-4110 Grants&Subsidies 14,519.65 17,032.85 18,679.05 15,674.40 13,000 13,000 12000 12000 4550-4130 Admissions 5,649.41 5,262.61 8,125.75 5,641.17 6,000 6,000 5600 5600 4550-4170 Children's Programs 280.00 132.00 128.00 104.00 400 400 200 200 4550-4120 Sundry 301.06 286.66 - 200.97 - - 7000 7500 4550-4190 Contribution from Reserves - - 1,440.85 - - - - - 20,750.12 22,714.12 28,373.65 21,620.54 19,400 19,400 24,800 25,300 Expenditures 4550-5100 Salaries&Wages 32,767.28 30,595.24 28,218.84 30,747.66 33,000 33,000 31,000 31,500 4550-5110 Statutory Benefits 2,855.67 2,636.71 2,432.02 2,666.82 3,050 3,050 3,100 3,150 4550-5170 Office Supplies 297.74 253.99 76.26 33.57 250 250 0 0 4550-5190 Children's Programs 132.64 32.04 - 11.85 150 150 4,600 4,700 4560-5200 Building Renovations - - - - - - 4550-5210 Utilities 8,216.09 9,058.10 8,184.29 8,842.52 8,500 8,500 8,112 8,436 4550-5240 Advertising 1,404.17 934.17 3,340.69 1,864.26 1,000 1,340 1,700 1,700 4550-5245 Marketing - - - - 100 100 0 0 4550-5250 Memberships 293.58 251.76 1,231.17 301.76 300 300 550 550 4550-5270 Building Maintenance 5,986.44 2,871.19 3,389.68 1,060.77 3,800 4,500 7,500 4,300 4550-5280 Equipment Maintenance 2,790.32 1,304.36 2,133.06 1,567.38 1,500 1,800 2,500 2,500 4550-5290 Grounds Maintenance 2,640.05 3,391.15 2,692.08 3,674.79 3,000 3,000 3,600 3,700 4550-5300 Insurance 2,596.00 2,472.00 2,506.98 2,712.57 2,510 2,713 2,846 2,988 4550-5360 Telephone 1,948.93 1,691.30 1,106.02 1,006.68 1,800 1,800 1,300 1,300 4550-5340 Conferences&Seminars - - - 100 100 0 0 4550-5350 Travel - - 79.65 100 100 0 0 4550-5370 Sundry 444.33 410.23 780.71 596.78 500 500 4,800 4,800 4550-5600 Special Project 36.00 34.09 - 63.45 - - 4550-5610 Special Events - - - - 340 - - - 62,409.24 55,936.33 56,171.45 55,150.86 60,000 61,203 71,608 69,624 - 41,659.12 - 33,222.21 - 27,797.80 - 33,530.32 - 40,600 - 41,803 - 46,808 - 44,324 FUND RAISING Revenue: 4550-4180 Fundraising 4,236.35 2,199.89 10,179.69 5,987.43 5,000 5,500 5500 6000 4550-4185 Donations 2,059.89 903.43 822.40 2,922.90 1,000 1,500 1,500 1,500 6,296.24 3,103.32 11,002.09 8,910.33 6,000 7,000 7,000 7,500 Expenditures: 4550-5180 Fundraising expense 2,424.16 226.73 3,994.21 3,980.03 4,000 4,500 4500 4600 4550-5400 Transfer to Reserves 3,872.08 4,476.59 7,007.88 4,930.30 2,000 2,500 2,500 2,900 6,296.24 4,703.32 11,002.09 8,910.33 6,000 7,000 7,000 7,500 - - 1,600.00 - - - - - - 31 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 29 of 40 Municipality of Bayham 2015-2016 Planning&Development 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 5010-4120 Sundry Revenue 162.00 679.00 1,078.00 521.00 300 1,300 500 500 5010-4130 Zoning Certificates 910.00 1,190.00 700.00 1,295.00 1,200 1,200 1,200 1,200 5010-4140 Zoning Charges 9,548.07 8,635.00 18,529.00 9,167.10 13,000 13,000 12,000 12,000 5010-4150 OPA Charges - - - 6,540.00 1,000 1,000 2,000 2,000 5010-4160 Minor Variance Charges 5,149.00 3,000.00 8,188.00 3,642.00 4,000 4,000 4,000 4,000 5010-4170 Site Plan Charges 380.00 2,743.00 500.00 2,466.00 3,000 3,000 3,000 3,000 5010-4175 Planning Report Fees - 1,150.00 4,025.00 5,275.00 3,000 3,000 3,000 3,000 5010-4180 Plan of Subdivision fees - - - - 1,000 1,000 1,000 1,000 5010-4190 Development Agreement fees 320.00 320.00 611.00 150.00 500 500 300 300 16,469.07 17,717.00 33,631.00 29,056.10 27,000 28,000 27,000 27,000 Expenditures 5010-5100 Salaries 8 Wages 45,565.25 54,448.25 55,769.14 44,633.06 54,749 55,563 44,995 46,345 5010-5110 Statutory Benefits 4,042.00 5,086.50 5,323.07 4,524.66 5,431 5,566 4,388 4,519 5010-5120 Non-Statutory Benefits 8,967.79 11,027.78 11,107.56 11,076.90 10,623 10,851 11,963 12,920 5010-5170 Supplies - 20.33 - - 100 100 0 0 5010-5240 Advertising 4,131.85 4,081.70 2,832.14 2,581.56 4,500 4,500 2500 2500 5010-5250 Association&Membership Fees 351.07 361.25 371.42 376.51 400 400 400 425 5010-5310 Legal Fees 2,507.38 2,829.10 599.15 426.04 4,000 4,000 0 0 5010-5320 Postage - 12.97 - - 100 100 0 0 5010-5340 Conferences 8 Seminars 40.00 - 63.04 - 450 450 450 450 5010-5350 Travel 191.70 216.50 245.25 308.70 250 250 250 250 5010-5370 Sundry 5.00 - - - 200 200 0 0 5010-5450 Consulting Fees 30,315.60 24,175.26 32,658.48 38,329.64 26,000 26,000 26,000 26,000 96,117.64 102,259.64 108,969.25 102,257.07 106,804 107,980 90,947 93,409 32 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 30 of 40 Municipality of Bayham 2015-2016 Business and Commerce 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues -- 5012-4110 Grants 8 Subsidies - - - - - - 5012-4170 Lease Revenues - 600.00 - - 640 - - - - 600.00 - - 640 - - - Expenditures -- 5012-5210 Utilities - - - - 960 - 5012-5240 Advertising - - - - - - 5012-5270 Beautification 3,705.96 3,477.91 - - 3,500 - 5012-5370 Sundry 683.17 379.26 - - - - - - 4,389.13 3,857.17 - - 4,460 - - - 33 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 31 of 40 Municipality of Bayham 2015-2016 Tourism&Marketing I 2011 2012 2013 2014 2013 2014 I 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 5015-4110 Grants&Subsidies 4,332.55 4,015.79 - 12,684.00 - - 4000 4000 5015-4120 Sundry 670.00 2,037.98 6,535.95 2,715.06 - 1,000 5015-4170 Lease Revenues 2,400.00 4,633.00 5,233.25 - 1,312.63 4,600 5,200 1500 1500 5015-4190 Transfer from Reserve - - 3,741.05 5,000.00 5,000 10,000 7,402.55 10,686.77 15,510.25 19,086.43 9,600 16,200 5,500 5,500 Expenditures 5015-5100 Salaries&Wages 10,860.79 15,965.64 9,526.01 8,933.32 11,111 10,063 11000 11000 Inter Centre staffing - - - 200 - 5015-5110 Statutory benefits - - 664.45 775 - 1000 1000 5015-5210 Utilities 5,612.47 11,354.11 7,887.05 7,486.16 10,700 10,700 8000 8000 5015-5215 Interpretive Centre Operations 1,299.75 4,641.09 1,551.66 2,350 - 5015-5230 Brochures 994.20 5,610.73 1,978.21 1,015.56 3,500 3,500 1000 1000 5015-5240 Advertising 6,375.60 8,426.09 7,244.16 6,366.03 7,000 7,000 7000 7000 5015-5245 Promotional items 2,096.00 - - - 1,000 5015-5250 Memberships 442.03 344.46 710.56 5,476.51 500 5,500 6000 6000 5015-5260 Festivals 4,662.55 - - - - 5015-5270 Beautification - - 2,829.91 4,814.05 200 3,500 5000 5000 5015-5290 Beach Maintenance 2,739.59 10,220.01 11,164.86 12,676.83 12,000 12,000 13500 13500 5015-5370 Sundry - - 183.17 183.17 - - 5015-5600 Special Projects 12,870.78 214.63 3,741.05 31.30 5,000 10,000 47,953.76 56,776.76 47,481.09 46,982.93 53,336 63,263 52,500 52,500 34 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 32 of 40 Municipality of Bayham 2015-2016 Environmental Services 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues 5020-4110 Grants&Subsidies 10,034.22 10,201.86 13,035.37 9,760.53 10,000 11,500 12,838 12,838 5020-4140 Tile Drain Charges 5,603.51 - - - - - - 15,637.73 10,201.86 13,035.37 9,760.53 10,000 11,500 12,838 12,838 Expenditures 5020-5100 Salaries&Wages 15,570.15 15,369.77 18,110.93 16,425.76 15,568 15,800 17,051 17,563 5020-5110 Statutory Benefits 1,416.56 1,333.51 1,926.72 1,846.11 1,349 1,374 1,920 1,978 5020-5120 Non-Statutory Benefits 3,063.54 2,493.91 3,236.34 3,341.94 2,927 2,952 3609 3,898 5020-5270 Water Sampling&Testing 1,631.20 554.58 562.74 403.99 900 900 500 500 5020-5275 Water Quality Management 70.21 - - - - 5020-5290 Drain Maintenance 903.83 - - - - 5020-5320 truck water sampling 1,418.50 1,042.09 992.38 1,006.87 1,100 1,100 5020-5340 Conferences&Seminars - 295.10 295.10 122.11 500 500 500 500 5020-5370 Sundry - 760.53 - - - 5020-5380 Tile Drain Debt Charges 5,603.51 2,622.92 - - - - - 29,677.50 24,472.41 25,124.21 23,146.78 22,344 22,626 23,580 24,438 35 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 33 of 40 Municipality of Bayham 2015-2016 Capital 2011 2012 2013 2014 2013 2014 2015 2016 Actuals Actuals Actuals Actuals Budget Budget Budget Budget Revenues Financing 2,111,177.07 2,249,113.43 1,249,325.60 1,214,683.38 1,568,290 1,578,700 2,599,587 227,452 2,111,177.07 2,249,113.43 1,249,325.60 1,214,683.38 1,568,290 1,578,700 2,599,587 227,452 Expenditures Gross Expenditures 2,873,642.13 3,222,415.63 2,128,406.83 1,955,306.57 2,369,290 2,403,700 3,563,438 1,183,166 2,873,642.13 3,222,415.63 2,128,406.83 1,955,306.57 2,369,290 2,403,700 3,563,438 1,183,166 Net Capital Expense 762,465.06 973,302.20 879,081.23 740,623.19 801,000 825,000 963,851 955,714 36 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 34 of 40 2015 OMPF funding (projected) 912,000 Interest earned on reserve 2,300 OMPF reserve opening balance 255,000 Use of OMPF 140,000 OMPF closing balance 115,000 Total Revenue(OMPF,Tax increase,lnterest, Use of Reserve) 1,054,300 37 Report CAO-16/15 by Paul Shipway,Administrator re 2015 -20... Page 35 of 40 -15XY11444/ '� REPORT o 0P.- ow , CAO Pp°1 tunny Is•' TO: Mayor& Members of Council FROM: Paul Shipway,Administrator DATE: March 12, 2015 REPORT: CAO-18/15 SUBJECT: RESERVES BALANCES-STRUCTURE BACKGROUND This report provides information on reserve and reserve fund balances as at December 31, 2014, and projected year-end balances as at December 31, 2015. The vast majority of these funds have been committed to fund capital projects and known future liabilities, leaving minimal amounts for discretionary spending. This report also outlines proposed restructuring for strategic purposes to the reserve accounts. The reserves are attached hereto as Appendix'A'. Note: i. Reserve and Reserve fund balances are subject to change with final year end adjustments. DISCUSSION Reserve and Reserve Funds are created with Council approval to set monies aside: i. for planned future expenditures; ii. to protect the Municipality against an unbudgeted or unforeseen event; iii. to smooth out future program expenditures which may fluctuate from one year to the next; or iv. to accumulate funds for future capital expenditures or irregular or occasional expenses (such as municipal elections every four(4)years). The major difference between Reserves and Reserve Funds is that all earnings (i.e. interest)from the investment of Reserve Funds must be allocated to, and form part of, the Reserve Fund; while the earnings from Reserves is allocated to the operating budget as investment revenue. There are two types of Reserve Funds: Obligatory Reserve Funds and Council Directed Reserve Funds: a) Obligatory Reserve Funds are funds received and set aside for specific purposes by legislation or contractual agreements. These funds can only be used for the purposes prescribed. b) Council Directed Reserve Funds are created by Council for specific purposes through by- law. The vast majority of these funds are committed to fund capital projects identified in the ten year capital plan, and known future liabilities, leaving minimal funds available for discretionary spending. Report CAO-18/15 by Paul Shipway,Administrator re Reserves ... Page 36 of 40 Also, the current balances of many of the reserve and reserve funds (e.g. Water and Wastewater Capital, Fire, Public Works and Facilities)are not sufficient to cover the future obligations for which they have been set aside. To centralize funds and structure the reserves so they are in line with the municipal priorities outlined within the Ten Year Capital Budget, staff propose the following structural changes: i. Merge Fire Apparatus and Fire Equipment into one reserve ii. Delete the Computer Equipment and Records reserves iii. Merge the Water Works and Richmond Water reserves iv. Combine the Operating Stabilization and Capital Stabilization reserves v. Rename the Contingency reserve to the Liability reserve The proposed changes and corresponding reserve balances are attached hereto as Appendix B'. RECOMMENDATION 1. THAT Report CAO-18/15 re Reserves Balances- Structure be received for information; 2. AND THAT the Council of the Corporation of the Municipality of Bayham direct staff restructure the reserves in accordance with Appendix'B' attached hereto. Respectfully Submitted by: Paul Shipway Administrator Report CAO-18/15 by Paul Shipway,Administrator re Reserves ... Page 37 of 40 Appendix 'A' Municipality of Bayham 2015 Opening Reserves Account Balance Transfer Transfer Balance No. 31-Dec-14 To From 31-Dec-15 RESERVES 2301 Working Capital $316,142.00 $10,000.00 $85,000.00 $241,142.00 2302 Equipment $364,828.34 $350,000.00 $14,828.34 2303 Fire Department Apparatus $75,029.68 $75,029.68 2304 Computer Equipment $0.00 $0.00 2305 Road Construction $531,495.65 $407,000.00 $124,495.65 2306 Otter Valley Chamber $1,414.92 $1,414.92 2307 Trail Improvements $107,781.82 $10,000.00 $117,781.82 2308 Fire Equipment $5,000.00 $5,000.00 $0.00 2310 Water Works $580,211.33 $103,149.00 $403,824.00 $279,536.33 2311 Richmond Water $6,127.30 $3,630.00 $9,757.30 2313 County Road Maintenance $0.00 $0.00 2314 Building Vehicle $20,000.00 $20,000.00 2315 Fire Renumeration $12,500.00 $12,500.00 2318 Parks&Playgrounds $71,722.39 $71,722.39 2319 By-law Vehicle $20,000.00 $20,000.00 2320 Records Management $0.00 $0.00 2322 Dredging $63,600.00 $63,600.00 2323 Library Buildings $151,673.77 $41,850.00 $193,523.77 2324 Musuem Artifacts $1,000.00 $1,000.00 2326 Museums General $4,365.90 $4,365.90 2327 Election $0.00 $10,000.00 $10,000.00 2328 Waste Transfer Station $144,517.06 $144,517.06 2330 Police Services $200,000.00 $80,000.00 $120,000.00 2331 Liability $23,600.00 $70,000.00 $93,600.00 2332 Capital Rate Stabilization $223,000.00 $223,000.00 2333 Operating Rate Stabilization $170,000.00 $170,000.00 2334 Straffordville Skate Park $1,731.70 $1,731.70 2335 OMPF $255,000.00 $140,000.00 $115,000.00 2336 Reserve Municipal Facilities $97,792.23 $150,000.00 $247,792.23 $3,448,534.09 $398,629.00 $1,470,824.00 $2,376,339.09 Municipality of Bayham 2015 Opening Reserve Funds and Deferred Revenue Account Balance Transfer Transfer Balance No. 31-Dec-14 To From 31-Dec-15 RESERVE FUNDS 2312 Sewage Works 1,698,007.36 $315,515.00 $99,967.00 $1,913,555.36 2316 Edison Museum 81,513.76 $81,513.76 2352 Environmental 66,482.07 $66,482.07 2360 Straffordville Community Centre 94,021.10 $94,021.10 2361 Vienna Community Centre 85,809.42 $85,809.42 2,025,833.71 $315,515.00 $99,967.00 $2,241,381.71 DEFERRED REVENUE 2350 Parkland 65,595.21 $65,595.21 2357 Developer Deposits 26,256.88 $26,256.88 2362 Federal Gas Tax 129,797.76 $201,620.00 $201,620.00 $129,797.76 221,649.85 $201,620.00 $201,620.00 $221,649.85 **Balances subject to change with final year end balances. Report CAO-18/15 by Paul Shipway,Administrator re Reserves ... Page 38 of 40 Appendix 'B' Municipality of Bayham 2015 Revised Opening Reserves Account Balance Transfer Transfer Balance No. 31-Dec-14 To From 31-Dec-15 RESERVES 2301 Working Capital $316,142.00 $10,000.00 $85,000.00 $241,142.00 2302 Public Works Reserve $364,828.34 $350,000.00 $14,828.34 2303 Fire $80,029.68 $5,000.00 $75,029.68 2305 Road Construction $531,495.65 $407,000.00 $124,495.65 2306 Otter Valley Chamber $1,414.92 $1,414.92 2307 Trail Improvements $107,781.82 $10,000.00 $117,781.82 2310 Water $586,338.63 $106,779.00 $403,824.00 $289,293.63 2313 County Road Maintenance $0.00 $0.00 2314 Building Vehicle $20,000.00 $20,000.00 2315 Fire Renumeration $12,500.00 $12,500.00 2318 Parks&Playgrounds $71,722.39 $71,722.39 2319 By-law Vehicle $20,000.00 $20,000.00 2322 Dredging $63,600.00 $63,600.00 2323 Library Buildings $151,673.77 $41,850.00 $193,523.77 2324 Musuem Artifacts $1,000.00 $1,000.00 2326 Museums General $4,365.90 $4,365.90 2327 Election $10,000.00 $10,000.00 2328 Waste Transfer Station $144,517.06 $144,517.06 2330 Police Services $200,000.00 $80,000.00 $120,000.00 2331 Liability $23,600.00 $70,000.00 $93,600.00 2332 Rate Stabilization $393,000.00 $393,000.00 2334 Straffordville Skate Park $1,731.70 $1,731.70 2335 OMPF $255,000.00 $140,000.00 $115,000.00 2336 Reserve Municipal Facilities $97,792.23 $150,000.00 $247,792.23 $3,448,534.09 $398,629.00 $1,470,824.00 $2,376,339.09 Municipality of Bayham 2015 Revised Opening Reserve Funds and Deferred Revenue Account Balance Transfer Transfer Balance No. 31-Dec-14 To From 31-Dec-15 RESERVE FUNDS 2312 Sewage Works 1,698,007.36 $315,515.00 $99,967.00 $1,913,555.36 2316 Edison Museum 81,513.76 $81,513.76 2352 Environmental 66,482.07 $66,482.07 2360 Straffordville Community Centre 94,021.10 $94,021.10 2361 Vienna Community Centre 85,809.42 $85,809.42 2,025,833.71 $315,515.00 $99,967.00 $2,241,381.71 DEFERRED REVENUE 2350 Parkland 65,595.21 $65,595.21 2357 Developer Deposits 26,256.88 $26,256.88 2362 Federal Gas Tax 129,797.76 $201,620.00 $201,620.00 $129,797.76 221,649.85 $201,620.00 $201,620.00 $221,649.85 **Balances subject to change with final year end balances. Report CAO-18/15 by Paul Shipway,Administrator re Reserves ... Page 39 of 40 THE CORPORATION OF THE MUNICIPALITY OF BAYHAM BY-LAW NO. 2015-025 A BY-LAW TO CONFIRM ALL ACTIONS OF THE COUNCIL OF THE CORPORATION OF THE MUNICIPALITY OF BAYHAM FOR THE BUDGET MEETING HELD MARCH 12, 2015 WHEREAS under Section 5(1)of the Municipal Act,2001 S.O. 2001, Chapter 25, the powers of a municipal corporation are to be exercised by the Council of the municipality; AND WHEREAS under Section 5(3)of the Municipal Act,2001,the powers of Council are to be exercised by by-law; AND WHEREAS the Council of the Corporation of the Municipality of Bayham deems it advisable that the proceedings of the meeting be confirmed and adopted by by-law. THEREFORE THE COUNCIL OF THE CORPORATION OF THE MUNICIPALITY OF BAYHAM ENACTS AS FOLLOWS: 1. THAT the actions of the Council of the Corporation of the Municipality of Bayham in respect of each recommendation and each motion and resolution passed and other action by the Council at the budget meeting held March 12, 2015 is hereby adopted and confirmed as if all proceedings were expressly embodied in this by-law. 2. THAT the Mayor and Clerk of the Corporation of the Municipality of Bayham are hereby authorized and directed to do all things necessary to give effect to the action of the Council including executing all documents and affixing the Corporate Seal. READ A FIRST, SECOND AND THIRD TIME and finally passed this 12'day of March 2015. MAYOR CLERK By-law 2015-025 Being a By-law to confirm all actions of Cou... Page 40 of 40