Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
AGENDA - Finance Advisory Committee - 20190925
Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 5:30 p.m. Holland Room Aurora Town Hall Public Release September 20, 2019 Town of Aurora Finance Advisory Committee Meeting Agenda Date: Wednesday, September 25, 2019 Time and Location: 5:30 p.m., Holland Room, Aurora Town Hall 1. Approval of the Agenda Recommended: That the agenda as circulated by Legislative Services be approved. 2. Declarations of Pecuniary Interest and General Nature Thereof 3. Receipt of the Minutes Finance Advisory Committee Meeting Minutes of June 26, 2019 Recommended: That the Finance Advisory Committee meeting minutes of June 26, 2019, be received for information. 4. Delegations 5. Consideration of Items Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Page 2 of 2 1. Review of Detailed Financial Budget Information Re: Corporate Services Recommended: 1. That the comments and suggestions of the Review of Detailed Financial Budget Information for Corporate Services be received and referred to staff for consideration and action as appropriate. 2. Memorandum from Project Management Office Re: Town’s Major Capital Projects Update Recommended: 1. That the memorandum regarding Town’s Major Capital Projects Update be received for information. 3. Draft 2020 Detailed Capital Investment Plan Recommended: 1. That the Town’s Draft 2020 Detailed Capital Investment Plan be received for information. 6. New Business 7. Adjournment Town of Aurora Finance Advisory Committee Meeting Minutes Date: Wednesday, June 26, 2019 Time and Location: 5:30 p.m., Holland Room, Aurora Town Hall Committee Members: Councillor Michael Thompson (Chair), Councillor Harold Kim (arrived at 5:48 p.m.), and Mayor Tom Mrakas Member(s) Absent: None Other Attendees: Len Baulmer, Treasurer, Aurora Historical Society, Erika Mazanik, Executive Director/Curator, Hillary House, Doug Nadorozny, Chief Administrative Officer, Rachel Wainwright- van Kessel, Director of Financial Services, Jason Gaertner, Manager, Financial Planning, Karen Oreto, Financial Analyst, and Ishita Soneji, Council/Committee Coordinator Councillor Kim was appointed to the Finance Advisory Committee in place of Councillor Gallo at the Council meeting of June 25, 2019. The Chair called the meeting to order at 5:43 p.m. 1. Approval of the Agenda Moved by Mayor Mrakas Seconded by Councillor Thompson That the agenda as circulated by Legislative Services be approved. Carried Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Minutes Page 1 of 4 Finance Advisory Committee Meeting Minutes Wednesday, June 26, 2019 Page 2 of 4 2. Declarations of Pecuniary Interest and General Nature Thereof There were no declarations of pecuniary interest under the Municipal Conflict of Interest Act, R.S.O. 1990, c. M.50. 3. Receipt of the Minutes Finance Advisory Committee Meeting Minutes of May 22, 2019 Moved by Mayor Mrakas Seconded by Councillor Thompson That the Finance Advisory Committee meeting minutes of May 22, 2019, be received for information. Carried 4. Delegations None 5. Consideration of Items The Committee consented to consider the items in the following order: Items 3, 2, 1, and 4. 1. Review of Detailed Budget Information Re: Aurora Historical Society Mr. Len Baulmer, Treasurer of the Aurora Historical Society provided a brief overview of the line-by-line analysis and year-to-date comparison of the budget for the Aurora Historical Society including details on the grant revenue by source, decrease in expenditures over the years, and operating cost rationalization strategies to compensate for allocation towards community outreach programs and future capital projects. He identified the budget pressures including possible decrease in funding from the Province and the need of additional funding for major structural rehabilitation and heritage restoration. Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Minutes Page 2 of 4 Finance Advisory Committee Meeting Minutes Wednesday, June 26, 2019 Page 3 of 4 The Committee inquired about the multi-year budget framework for the Society and its possible impact on the annual funding, and staff noted that the process would allow for planning for multiple years and identify specific budget requirements for each year where necessary. Moved by Councillor Gallo Seconded by Mayor Mrakas 1. That the comments and suggestions of the Review of Detailed Financial Budget Information for Aurora Historical Society be received and referred to staff for consideration and action as appropriate. Carried 2. Memorandum from Project Management Office Re: Town’s Major Capital Projects Update Staff provided a brief update on the status of Town’s current major capital projects and noted that all projects are on schedule and meeting the budget targets. Moved by Councillor Kim Seconded by Mayor Mrakas 1. That the memorandum regarding Town’s Major Capital Projects Update be received for information. Carried 3. Round Table Discussion Re: Review of General Committee Report No. FS19-018 – Capital Close Report as of December 31, 2018 Staff provided a brief overview of the report. The Committee expressed no concerns and requested that the report be brought to a future Council meeting. Moved by Mayor Mrakas Seconded by Councillor Kim Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Minutes Page 3 of 4 Finance Advisory Committee Meeting Minutes Wednesday, June 26, 2019 Page 4 of 4 1. That the comments and suggestions of the Review of General Committee Report No. FS19-018 – Capital Close Report as of December 31, 2018 be received; and 2. That Report No. FS19-018 – Capital Close Report as of December 31, 2018 be brought to a future meeting of Council. Carried 4. Distribution and Introduction of Detailed Financial Budget Information Re: Corporate Services Department Staff noted that Techa van Leeuwen, Director of Corporate Services, would be present at the next meeting to review the detailed budget information for Corporate Services. The Committee requested further information regarding the election and salary expenses. Moved by Mayor Mrakas Seconded by Councillor Kim 1. That the detailed financial budget information for Corporate Services Department be received and deferred for discussion and detailed review at the September 25, 2019 meeting of the Finance Advisory Committee. Carried 6. New Business None 7. Adjournment Moved by Councillor Kim Seconded by Mayor Mrakas That the meeting be adjourned at 6:16 p.m. Carried Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Minutes Page 4 of 4 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1000 MARRIAGE LICENSES-18,450 -24,708 -26,358-22,000 -25,0003,000 13.6% 1,650 6.7% 3-1001 LOTTERY LICENSES-2,456 -3,006 -2,481-2,500 -2,000-500 (20.0%) -525 (17.5%) 3-1002 BURIAL/BIRTH LICENSES-7,686 -8,855 -7,330-5,500 -5,500- - -1,525 (17.2%) 3-1003 BYLAW LICENSES-49,510 -56,904 -57,702-47,000 -60,00013,000 27.7% 798 1.4% 3-1004 PARKING PERMITS-6,890 -6,985 -8,495-6,600 -6,800200 3.0% 1,510 21.6% 3-1012 FARMERS MARKET PERMITS-3,750 -3,150 -2,850-3,800 -3,85050 1.3% -300 (9.5%)3-1050 COURT FINES-56,935 -65,266 -60,388-80,000 -82,0002,000 2.5% -4,878 (7.5%)3-1052 PARKING VIOLATIONS-85,271 -64,595 -88,414-75,000 -105,00030,000 40.0%23,819 36.9%3-1102 ADMINISTRATIVE FEES-67,211 -78,722 -41,658-65,000 -65,000---37,064 (47.1%)A decrease in fees from development related legal agreements3-1108 DOG TAGS-21,766 -25,702 -32,832-35,000 -45,00010,000 28.6% 7,130 27.7%3-1109 CAT TAGS-1,821 -726 -920-2,000 -2,000- - 194 26.7% 3-1113 AFFIDAVITS/COMMISSIONING-4,381 -5,522 -8,797-10,000 -7,500-2,500 (25.0%) 3,275 59.3% 3-1114 FREEDOM OF INFORMATION FEES-4,149 -821 -4,323-1,000 -1,500500 50.0% 3,502 426.6% 3-1117 CIVIL MARRIAGES-7,552 -11,121 -12,859-8,000 -10,0002,000 25.0% 1,738 15.6% 3-1201 OTHER-2,296 -2,385 -10,557-3,030 -370,354367,324 12,122.9% 8,172 342.6% 3-1202 GENERAL-246 -3,967 -24,407-2,000 -5,5003,500 175.0%20,440 515.3%2018 revenue from insurance claim payment3-1900 CONTRIBUTION FROM CAPITAL-79,361 -4,000------4,000(100.0%) 3-1901 CONTRIBUTION FROM DISCRETIONARY RESERV-- -192,879-368,879--368,879(100.0%)192,879(100.0%)2018 draw from reserve for election3-1975 CIL PARKLAND CONTRIBUTION-50,000 -10,000 10,000-----20,000 (200.0%)2018 entry was booked backwards in errorTotal Revenue-469,731 -376,435 -573,250 -737,309 -797,00459,6958.1%196,81552.3% EXPENSE: 4-2000 SALARIES - F/T3,105,734 3,529,839 3,665,5514,047,978 4,275,463227,485 5.6% -135,712 3.8% 4-2001 SALARIES - O/T2,888 5,707 11,78810,589 10,589- - 6,081 106.6% 4-2002 SALARIES - P/T332,136 334,249 428,673286,441 361,73975,298 26.3%94,424 28.2%4-2003 VACATION PAY9,612------ --4-2004 SICK PAY1,039------ --4-2005 LIEU TIME2,210------ -- 4-2090 YEAR END ACCRUALS-20,045 64,781 11,146----(53,635) (82.8%)Variance due to calendarization of annula salaries4-2100 BENEFITS - OMERS330,174 385,011 399,362428,083 444,82616,743 3.9% 14,351 3.7% 4-2101 BENEFITS - EHT64,953 75,211 79,73082,016 89,1937,177 8.8% 4,519 6.0% 4-2102 BENEFITS - WSIB23,986 26,349 27,70331,545 34,3062,761 8.8% 1,354 5.1% 4-2103 BENEFITS - CPP115,081 120,340 132,460127,331 144,40917,078 13.4% 12,120 10.1% 4-2104 BENEFITS - EI61,493 55,451 61,65660,089 67,6757,586 12.6% 6,205 11.2% 4-2105 BENEFITS - DENTAL51,212 60,383 61,28376,038 79,5103,472 4.6% 900 1.5% 4-2106 BENEFITS - HEALTH99,187 111,745 113,931130,040 139,2289,188 7.1% 2,186 2.0% 4-2107 BENEFITS - LTD/ADD54,061 64,202 79,13880,002 91,85611,854 14.8% 14,936 23.3% 4-2108 BENEFITS - OTHER14,023 17,034 18,91220,003 20,983980 4.9% 1,878 11.0% 4-2200 WAGE RECOVERY-79,200 -149,800-----149,800100.0%4-2201 SALARY SAVINGS----33,874 -33,874-- --TOTAL SALARIES & BENEFITS 4,168,544 4,700,502 5,091,333 5,346,281 5,725,903379,6227.1%390,8318.3%4-3000 PURCHASE CARD CLEARING1,775 -126 -212--- - (86) (68.3%) 4-4000 OFFICE SUPPLIES10,564 8,974 17,18211,411 11,673262 2.3% 8,208 91.5% 4-4004 SUBSCRIPTIONS/PUBLICATIONS28,222 33,185 37,20725,000 25,000- - 4,022 12.1% 4-4005 MARRIAGE LICENSES6,720 8,354 10,4177,500 8,5001,000 13.3% 2,063 24.7% 4-4006 OFFICE EQUIPMENT3,067 4,823 5,4884,600 7,4502,850 62.0% 665 13.8% 4-4007 COMPUTER SUPPLIES7,172 8,030 6,6797,140 7,283143 2.0% (1,351) (16.8%) 4-4008 SOFTWARE2,188 2,188 99,989----97,801 4,469.9%2018 Election expense4-4009 SAFETY SUPPLIES7,256 2,773 1,5873,000 3,000- - (1,186) (42.8%) 4-4010 CLOTHING ALLOWANCE13,683 5,507 15,0038,810 12,7203,910 44.4% 9,496 172.4% 4-4015 OPERATING MATERIALS15,308 12,690 29,71714,550 31,07516,525 113.6% 17,027 134.2% 4-4016 DOG TAGS2,242--3,120 3,150301.0%-0.0% Higher parking enforecement due to the introduction of dedicated animal control officer & winter overnight parking strategy2018 includes the coverage of a maternity leaves - savings are reflected in the full time salary line to offset this expenseAll recoveries from Water for provision of services by the rest of the Town were consolidated in 01490 (Corporate Accounts) starting in 2018Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 1 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)4-4018 LICENSES81,703 180,632 162,659188,097 188,18790 0.0% (17,973) (10.0%) 4-4019 VEHICLE SUPPLIES1,202727 10,7611,545 2,00045529.4%10,0341,380.2% 4-4021 EQUIPMENT - OTHER9,380 2,852 1,760- 7,1007,100 - (1,092) (38.3%) 4-4028 COST REALLOCATIONS-87,844 -101,035 -89,743-90,000-90,000- - 11,292 11.2% 4-4045 MUNICIPAL BUSINESS3,950 5,216 5,4344,150 4,20050 1.2% 218 4.2% 4-4047 SUPPLIES1,206------ -- 4-4048 FUEL COSTS---- 10,00010,000 - - - 4-4057 COPIERS, PRINTERS AND FAXES94,970 87,883 87,58990,000 90,000- - (294) (0.3%) 4-4065 WORKPLACE ACCOMMODATIONS509 2,374 1,6062,500 2,500- - (768) (32.4%) 4-5018 TELEPHONE LINES68,647 73,363 76,46574,250 74,750500 0.7% 3,102 4.2% 4-5020 LONG DISTANCE LINES1,115 1,0689421,500 1,500--(126)(11.8%) 4-5021 MOBILE PLAN CHARGES79,920 81,231 15,83418,031 18,563532 3.0%(65,397) (80.5%)4-5022 CORPORATE FAX LINES6,194 5,426 6,0016,000 6,000- - 575 10.6%4-5023 INTERNET LINE18,215 20,881 18,48925,000 25,000- - (2,392) (11.5%)4-5024 TELEPHONE SERVICE AGREEMENT6,331 16,310 29,90220,000 19,000(1,000) (5.0%) 13,592 83.3% 4-5026 COURSES & SEMINARS16,572 13,312 23,02529,060 35,9606,900 23.7% 9,713 73.0% 4-5027 MANDATORY COURSES & SEMINARS3,560 3,586 9,8985,507 6,7401,233 22.4% 6,312 176.0% 4-5028 MEMBERSHIPS30,995 38,083 42,91943,478 47,7574,279 9.8% 4,836 12.7% 4-5029 MILEAGE2,716 2,077 2,1313,613 3,188(425) (11.8%) 54 2.6% 4-5031 GENERAL OFFICE EQUIPMENT4,289 6,056 -5922,000 1,800(200) (10.0%) (6,648) (109.8%) 4-5032 VEHICLE REPAIRS34961-1,030 4,0002,970288.3%(961)(100.0%) 4-5033 EQUIPMENT REPAIRS10,590 10,717 23,9289,600 2,500(7,100) (74.0%) 13,211 123.3% 4-5034 EQUIPMENT RENTALS--967----967- 4-5037 PROPERTY IMPROVEMENT27,232 1,036 9,1661,015 1,630615 60.6% 8,130 784.7% 4-5039 INSURANCE FEES520,941 541,229 551,000551,000 552,4001,400 0.3% 9,771 1.8% 4-5040 INSURANCE ADJUSTER12,613 22,394 33,24660,000 60,000- - 10,852 48.5% 4-5041 INSURANCE CLAIM DEDUCTIBLE47,870 22,668 35,845--- - 13,177 58.1% 4-5042 ADVERTISING- 6,187 21,38018,000 19,5001,500 8.3% 15,193 245.6% 4-5043 CONSULTING47,222 74,133 42,85938,000 39,0001,000 2.6%(31,274) (42.2%)2017 Consulting related to compensation review4-5044 POSTAGE101,73872,477 104,978105,000 107,5002,500 2.4%32,501 44.8%2018 election expense4-5045 PHOTOCOPIER CHARGES21,350 18,061 16,00419,710 19,210(500) (2.5%) (2,057) (11.4%) 4-5046 PRINTING2,509 4,668 6,8724,390 5,190800 18.2% 2,204 47.2% 4-5049 POLICE SEARCHES-- 1,143- 15,50015,500-1,1430.0% 4-5050 APPRAISALS19,779 27,890 20,699--- - (7,191) (25.8%) 4-5052 SEARCHES & REGISTRATIONS27,753 26,012 32,12520,000 20,000- - 6,113 23.5% 4-5054 PLANNING & DEVELOPMENT263,151 85,614 22,36150,000 35,000(15,000) (30.0%)(63,253) (73.9%)4-5055 ADVOCACY52,679 60,984 65,12650,000 50,000- - 4,142 6.8%4-5056 PERSONNEL ADMINISTRATION18,214 24,928 58,24720,000 30,00010,000 50.0%33,319 133.7%4-5057 ADJUSTOR RECOVERY-- 2,366----2,366-4-5058 TEMPORARY STAFF--53,535--- - 53,535 - 4-5059 CONTRACTS294,427 361,251 250,098663,501 320,223(343,278) (51.7%)(111,153) (30.8%)2018 Election expense4-5060 COST RECOVERY-9,210 -21,185 -2,847-15,000 -15,000- - 18,338 86.6% 4-5061 SOFTWARE ANNUAL MTCE SUPPORT420,857 353,297 480,089490,924 490,899(25) (0.0%)126,792 35.9%4-5067 REGION GIS CONTRACT---- 15,00015,000 - - -4-5084 OFFICE RELOCATES1,1091735191,000 1,000--346200.0%4-5086 SECURITY------- -- 4-5090 COURIER3,863 2,419 2,5423,800 3,300(500) (13.2%) 123 5.1% 4-5095 INTEGRITY COMMISSIONER---- 20,00020,000 - - - 4-5098 ACCESSIBILITY COSTS21,217 26,370 20,04725,000 25,000- - (6,323) (24.0%) 4-5099 APPLICATION VENDOR SUPPORT- 1,160 5,1343,000 3,000- - 3,974 342.6% 4-5150 CULTURAL CENTRE SUPPORT/SERVICES--829----8290.0% 4-6001 BANK CHARGES2,862 2,489 3,1121,525 1,57550 3.3% 623 25.0% 4-6025 EMPLOYEE RECOGNITION- 5,446 7,8894,500 6,0001,500 33.3% 2,443 44.9% 4-6026 CORPORATE COURSES & SEMINARS19,426 42,291 20,33655,000 55,000--(21,955) (51.9%)N6 HR leaders were developing training program2018 includes the introduction of annual fees for Laserfiche as well as increased costs/expanded requirements for existing software maintenance agreementsMobile Charges (budget and actuals) have been allocated directly to all departments to allow them better control of their costsLess development related outside legal costs than previous yearMore external HR legal assistance required in 2018 than previous yearFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 2 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)4-8003 CONTRIBUTIONS TO DISCRETIONARY RESERVE82,500 82,500-- 92,50092,500#DIV/0!(82,500)(100.0%)2018 election - no contribution to reserveTOTAL OTHER EXPENSES2,452,553 2,382,610 2,517,732 2,690,857 2,544,023(146,834)(5.5%)135,1225.7% TOTAL EXPENSES6,621,097 7,083,112 7,609,065 8,037,138 8,269,926232,7882.9%525,9537.4% NET BUDGET6,151,366 6,706,677 7,035,815 7,299,829 7,472,922173,0932.4%329,1384.9% Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 3 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1114 FREEDOM OF INFORMATION FEES-4,149 -821 -4,323-1,000 -1,500500 50.0% 3,502 426.6% 3-1117 CIVIL MARRIAGES-7,552 -11,121 -12,859-8,000 -10,0002,000 25.0% 1,738 15.6% 3-1201 OTHER-931------ -- 3-1202 GENERAL-246 -3,967 -24,407-2,000 -3,0001,000 50.0%20,440 515.3%2018 revenue from insurance claim payment3-1900 CONTRIBUTION FROM CAPITAL-79,361 -4,000------4,000(100.0%) Total Revenue-92,239 -19,909 -41,589 -11,000 -14,5003,50031.8%21,680108.9% EXPENSE: 4-2000 SALARIES - F/T376,000 432,894 403,925498,049 519,94421,895 4.4% (28,969) (6.7%) 4-2001 SALARIES - O/T172 2,510 4,507--- - 1,997 79.6% 4-2002 SALARIES - P/T91,844 14,953 11,70220,050 20,439389 1.9% (3,251) (21.7%) 4-2003 VACATION PAY5,760------ -0.0% 4-2004 SICK PAY347------ -0.0% 4-2005 LIEU TIME2,176------ -0.0% 4-2090 YEAR END ACCRUALS339 18,293636----(17,657)(96.5%) 4-2100 BENEFITS - OMERS35,030 45,137 41,15553,765 56,7773,012 5.6% (3,982) (8.8%) 4-2101 BENEFITS - EHT8,587 8,758 8,48410,081 10,515434 4.3% (274) (3.1%) 4-2102 BENEFITS - WSIB3,288 3,321 2,7853,877 4,044167 4.3% (536) (16.1%) 4-2103 BENEFITS - CPP18,844 15,432 14,18916,388 16,729341 2.1% (1,243) (8.1%) 4-2104 BENEFITS - EI10,138 7,212 6,2687,662 7,863201 2.6% (944) (13.1%) 4-2105 BENEFITS - DENTAL6,354 5,421 5,89510,416 10,416- - 474 8.7% 4-2106 BENEFITS - HEALTH11,958 12,193 11,76817,814 18,240426 2.4% (425) (3.5%) 4-2107 BENEFITS - LTD/ADD6,388 7,766 10,05510,275 11,7991,524 14.8% 2,289 29.5% 4-2108 BENEFITS - OTHER1,671 1,996 2,3472,569 2,695126 4.9% 351 17.6% TOTAL SALARIES & BENEFITS 578,896 575,886 523,716 650,946 679,461 28,515 4.4%(52,170)(9.1%) 4-4000 OFFICE SUPPLIES3,882 2,541 2,2364,000 3,000(1,000) (25.0%) (305) (12.0%) 4-4004 SUBSCRIPTIONS/PUBLICATIONS499232308800800--7632.8% 4-4006 OFFICE EQUIPMENT5361,519 3171,000 1,250250 25.0% (1,202) (79.1%) 4-4045 MUNICIPAL BUSINESS1,367802249450450--(553)(69.0%) 4-4047 SUPPLIES1,206------ -0.0% 4-5021 MOBILE PLAN CHARGES--716772796243.1%7160.0% 4-5026 COURSES & SEMINARS2,754366 1,7553,500 3,500--1,389379.5% 4-5028 MEMBERSHIPS1,362707 1,0322,000 2,80080040.0%32546.0% 4-5029 MILEAGE469317198500500--(119)(37.5%) 4-5039 INSURANCE FEES520,941 541,229-----(541,229)100.0%Insurance fees moved to 01202 (Legal)4-5040 INSURANCE ADJUSTER12,613 22,394 25,264--- - 2,870 12.8% 4-5041 INSURANCE CLAIM DEDUCTIBLE47,870 22,668 35,845--- - 13,177 58.1% 4-5042 ADVERTISING- 2,4544023,000 1,500(1,500)(50.0%)(2,052)(83.6%) 4-5045 PHOTOCOPIER CHARGES9,498 4,826 6,5247,070 7,070- - 1,698 35.2% 4-5046 PRINTING-154 1,841500 1,250750150.0%1,6871,095.5% 4-5059 CONTRACTS6,297 5,889 7,25317,000 12,000(5,000) (29.4%) 1,364 23.2% 4-5060 COST RECOVERY- -3,670 2,916-10,100 -10,100- - 6,586 179.5% 4-5095 INTEGRITY COMMISSIONER---- 20,00020,000 - - - TOTAL OTHER EXPENSES 609,294 602,428 86,856 30,492 44,816 14,324 47.0%(515,572) (85.6%) TOTAL EXPENSES 1,188,190 1,178,314 610,572 681,438 724,277 42,839 6.3%(567,742) (48.2%) NET BUDGET 1,095,951 1,158,405 568,983 670,438 709,777 39,339 5.9% (589,422)(50.9%) Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 4 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1901 CONTRIBUTION FROM DISCRETIONARY RESERV-- -192,879-368,879 --368,879 (100.0%)(192,879) (100.0%)2018 draw from reserve for electionTotal Revenue-- -192,879 -368,879--368,879(100.0%)(192,879)100.0% EXPENSE: 4-2001 SALARIES - O/T-- 4,462----4,462(100.0%) 4-2002 SALARIES - P/T-- 77,75281,855-(81,855)(100.0%)77,752(100.0%) 4-2101 BENEFITS - EHT-- 1,3511,506-(1,506)(100.0%)1,351(100.0%) 4-2102 BENEFITS - WSIB--515579-(579)(100.0%)515(100.0%) 4-2103 BENEFITS - CPP-- 2,6222,619-(2,619)(100.0%)2,622(100.0%) 4-2104 BENEFITS - EI-- 1,2231,194-(1,194)(100.0%)1,223(100.0%) TOTAL SALARIES & BENEFITS-- 87,925 87,753-(87,753)(100.0%)87,925(100.0%) 4-4000 OFFICE SUPPLIES-- 8,768----8,768(100.0%) 4-4008 SOFTWARE2,188 2,188 99,989----97,801 4,469.9%2018 Election expense4-4015 OPERATING MATERIALS-- 12,386----12,386(100.0%) 4-5029 MILEAGE--45----45(100.0%) 4-5034 EQUIPMENT RENTALS--967----967(100.0%) 4-5042 ADVERTISING-- 6,289----6,289(100.0%) 4-5044 POSTAGE-- 17,087----17,087(100.0%) 4-5046 PRINTING-- 2,262----2,262(100.0%) 4-5058 TEMPORARY STAFF-- 53,535----53,535(100.0%)2018 Election expense4-5059 CONTRACTS-100- 20,634390,170-(390,170)(100.0%)20,634(100.0%)2018 Election expense4-8003 CONTRIBUTIONS TO DISCRETIONARY RESERVE82,500 82,500-- 92,50092,500(100.0%)(82,500)(100.0%)2018 election - no contribution to reserveTOTAL OTHER EXPENSES84,588 84,688 221,962 390,170 92,500(297,670)(76.3%)137,274162.1% TOTAL EXPENSES84,588 84,688 309,887 477,923 92,500(385,423)(80.6%)225,199265.9% NET BUDGET84,588 84,688 117,008 109,044 92,500(16,544)(15.2%)32,32038.2% Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 5 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1003 BYLAW LICENSES-49,510 -56,904 -57,702-47,000 -60,00013,000 27.7% 798 1.4% 3-1004 PARKING PERMITS-6,890 -6,985 -8,495-6,600 -6,800200 3.0% 1,510 21.6% 3-1012 FARMERS MARKET PERMITS-3,750 -3,150 -2,850-3,800 -3,85050 1.3% -300 (9.5%) 3-1050 COURT FINES-56,935 -65,266 -60,388-80,000 -82,0002,000 2.5% -4,878 (7.5%) 3-1052 PARKING VIOLATIONS-85,271 -64,595 -88,414-75,000 -105,00030,000 40.0%23,819 36.9%3-1201 OTHER-1,365 -2,385 -6,765-2,030 -2,500470 23.2% 4,380 183.6%Total Revenue-203,721 -199,285 -224,614 -214,430 -260,15045,72021.3%25,32912.7% EXPENSE: 4-2000 SALARIES - F/T408,765 377,058 506,963561,069 515,913(45,156) (8.0%)129,905 34.5%4-2001 SALARIES - O/T937 3,196 2,819--- - (377) 11.8%4-2002 SALARIES - P/T130,414 182,966 164,937114,684 114,541(143) (0.1%) (18,029) (9.9%) 4-2003 VACATION PAY3,172------ -- 4-2004 SICK PAY660------ -- 4-2090 YEAR END ACCRUALS-10,556 3,754 6,110--- - 2,356 62.8% 4-2100 BENEFITS - OMERS49,578 45,492 52,03941,971 53,61011,639 27.7% 6,547 14.4% 4-2101 BENEFITS - EHT10,614 11,016 12,73210,655 12,1681,513 14.2% 1,716 15.6% 4-2102 BENEFITS - WSIB3,960 4,075 4,8974,098 4,680582 14.2% 822 20.2% 4-2103 BENEFITS - CPP20,508 21,007 26,92919,363 23,8184,455 23.0% 5,922 28.2% 4-2104 BENEFITS - EI11,221 9,932 12,8089,785 11,1791,394 14.2% 2,876 29.0% 4-2105 BENEFITS - DENTAL5,985 7,433 9,1738,333 11,8053,472 41.7% 1,740 23.4% 4-2106 BENEFITS - HEALTH12,297 13,346 19,47014,180 20,6716,491 45.8% 6,124 45.9% 4-2107 BENEFITS - LTD/ADD7,970 8,196 11,9587,937 11,7083,771 47.5% 3,762 45.9% 4-2108 BENEFITS - OTHER2,010 2,083 2,7422,344 2,674330 14.1% 659 31.6% TOTAL SALARIES & BENEFITS 657,535 689,554 833,577 794,419 782,767 (11,652) (1.5%)144,023 20.9% 4-4000 OFFICE SUPPLIES1,415 1,990 1,5701,550 1,500(50) (3.2%) (420) (21.1%) 4-4010 CLOTHING ALLOWANCE12,699 5,141 14,5227,800 7,900100 1.3% 9,381 182.5% 4-4015 OPERATING MATERIALS5,799 8,092 15,3995,550 5,075(475) (8.6%) 7,307 90.3% 4-4019 VEHICLE SUPPLIES1,202727 10,7611,545-(1,545)(100.0%)10,0341,380.2% 4-4045 MUNICIPAL BUSINESS704917 1,149450450--23225.3% 4-5021 MOBILE PLAN CHARGES-- 4,3494,694 4,8351413.0%4,349(100.0%) 4-5026 COURSES & SEMINARS4,743 1,126 5,3153,060 3,460400 13.1% 4,189 372.0% 4-5027 MANDATORY COURSES & SEMINARS530931 2,0941,940 2,74080041.2%1,163124.9% 4-5028 MEMBERSHIPS698662 1,2231,595 1,620251.6%56184.7% 4-5029 MILEAGE1,353527712400425256.3%18535.1% 4-5031 GENERAL OFFICE EQUIPMENT1,2005113571,200 1,000(200)(16.7%)(154)(30.1%) 4-5032 VEHICLE REPAIRS34961-1,030-(1,030)(100.0%)(961)(100.0%) 4-5037 PROPERTY IMPROVEMENT27,232 1,036 9,1661,015 1,630615 60.6% 8,130 784.7% 4-5045 PHOTOCOPIER CHARGES1,590 2,052 1,8701,700 1,700- - (182) (8.9%) 4-5046 PRINTING2,188 4,513 2,5663,090 3,14050 1.6% (1,947) (43.1%) 4-5061 SOFTWARE ANNUAL MTCE SUPPORT---1,525 1,500(25) (1.6%) - - 4-5086 SECURITY------- -- 4-6001 BANK CHARGES2,862 2,489 3,1121,525 1,57550 3.3% 623 25.0% TOTAL OTHER EXPENSES 64,249 31,675 74,165 39,669 38,550 (1,119) (2.8%)42,490134.1% TOTAL EXPENSES 721,784 721,229 907,742 834,088 821,317 (12,771) (1.5%)186,51325.9% 0.0% NET BUDGET 518,063 521,944 683,128 619,658 561,167 (58,491) (9.4%) 161,18430.9% Vacancy of Manager position for part of 2017 & addition of dedicated Animal Control Officer in 2018Higher parking enforecement due to the introduction of dedicated animal control officer & winter overnight parking strategyFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 6 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1108 DOG TAGS-21,766 -25,702 -32,832-35,000 -45,00010,000 28.6% 7,130 27.7% 3-1109 CAT TAGS-1,821 -726 -920-2,000 -2,000- - 194 26.7% 3-1201 OTHER-- -3,792- -367,854367,854100.0%3,792100.0% 3-1202 GENERAL---- -2,5002,500 100.0% - - Total Revenue-23,587 -26,428 -37,544 -37,000 -417,354380,3541,028.0%11,11642.1% EXPENSE: 4-2000 SALARIES - F/T---63,411 291,160227,749 359.2% - - 4-2002 SALARIES - P/T---- 112,704112,704 (100.0%) - - 4-2100 BENEFITS - OMERS---6,065 6,065-- -- 4-2101 BENEFITS - EHT---1,237 7,5006,263 506.3% - - 4-2102 BENEFITS - WSIB---476 2,8852,409 506.1% - - 4-2103 BENEFITS - CPP---2,649 15,73913,090 494.1% - - 4-2104 BENEFITS - EI---1,226 7,3566,130 500.0% - - 4-2105 BENEFITS - DENTAL---1,736 1,736-- -- 4-2106 BENEFITS - HEALTH---3,040 3,040-- -- 4-2107 BENEFITS - LTD/ADD---1,439 1,439-- -- 4-2108 BENEFITS - OTHER----329329(100.0%)-- TOTAL SALARIES & BENEFITS--- 81,279 449,953368,674453.6%-- 4-4000 OFFICE SUPPLIES-- 6- 1,5001,500 (100.0%) 6 (100.0%) 4-4006 OFFICE EQUIPMENT---- 2,0002,000 (100.0%) - - 4-4010 CLOTHING ALLOWANCE---- 4,0004,000 (100.0%) - - 4-4015 OPERATING MATERIALS4,188 1,041 1,505- 5,0005,000 (100.0%) 464 44.6% 4-4016 DOG TAGS2,242--3,120 3,150301.0%-- 4-4019 VEHICLE SUPPLIES---- 2,0002,000 (100.0%) - - 4-4048 FUEL COSTS---- 10,00010,000 (100.0%) - - 4-5021 MOBILE PLAN CHARGES-- 2,0822,247 2,315683.0%2,082(100.0%) 4-5026 COURSES & SEMINARS----4,0004,000 (100.0%) - - 4-5028 MEMBERSHIPS----500500(100.0%)-- 4-5032 VEHICLE REPAIRS---- 4,0004,000 (100.0%) - - 4-5059 CONTRACTS214,370 265,030 20,95613,000 30,00017,000 130.8%(244,074) (92.1%)TOTAL OTHER EXPENSES 220,800 266,071 24,549 18,367 68,465 50,098 272.8% (241,522) (90.8%)TOTAL EXPENSES 220,800 266,071 24,549 99,646 518,418 418,772 420.3% (241,522) (90.8%) NET BUDGET 197,213 239,643 -12,995 62,646 101,064 38,418 61.3% (252,638) (105.4%) Animal shelter expenses moved to 02405 (Animal Shelter) in 2018Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 7 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: TOTAL SALARIES & BENEFITS ----- - - - - 4-5059 CONTRACTS-- 108,338122,000 158,10036,10029.6%108,338(100.0%) TOTAL OTHER EXPENSES-- 108,338 122,000 158,10036,10029.6%108,338(100.0%) TOTAL EXPENSES-- 108,338 122,000 158,10036,10029.6%108,338(100.0%) NET BUDGET-- 108,338 122,000 158,10036,10029.6%108,338(100.0%) Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 8 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1000 MARRIAGE LICENSES-18,450 -24,708 -26,358-22,000 -25,0003,000 13.6% 1,650 6.7% 3-1001 LOTTERY LICENSES-2,456 -3,006 -2,481-2,500 -2,000-500 (20.0%) -525 (17.5%) 3-1002 BURIAL/BIRTH LICENSES-7,686 -8,855 -7,330-5,500 -5,500- - -1,525 (17.2%) 3-1113 AFFIDAVITS/COMMISSIONING-4,381 -5,522 -8,797-10,000 -7,500-2,500 (25.0%) 3,275 59.3% 3-1201 OTHER----1,000 --1,000 (100.0%) - - Total Revenue-32,973 -42,091 -44,966 -41,000 -40,000-1,000(2.4%)2,8756.8% EXPENSE: 4-2000 SALARIES - F/T490,133 476,430 518,476539,322 534,127(5,195) (1.0%) 42,046 8.8% 4-2002 SALARIES - P/T56,328 56,545 68,67759,668 60,8241,156 1.9% 12,132 21.5% 4-2003 VACATION PAY588------ -0.0% 4-2004 SICK PAY32------ -0.0% 4-2090 YEAR END ACCRUALS-233 6,768 2,584--- - (4,184) (61.8%) 4-2100 BENEFITS - OMERS47,166 48,959 57,19956,632 55,631(1,001) (1.8%) 8,240 16.8% 4-2101 BENEFITS - EHT9,125 10,425 11,50511,614 11,535(79) (0.7%) 1,080 10.4% 4-2102 BENEFITS - WSIB3,347 3,838 4,1724,468 4,437(31) (0.7%) 334 8.7% 4-2103 BENEFITS - CPP16,606 18,668 20,88620,579 21,311732 3.6% 2,218 11.9% 4-2104 BENEFITS - EI8,860 8,791 9,8339,839 10,091252 2.6% 1,042 11.9% 4-2105 BENEFITS - DENTAL10,153 12,032 10,99712,152 12,152- - (1,035) (8.6%) 4-2106 BENEFITS - HEALTH18,232 20,572 20,39720,783 21,279496 2.4% (175) (0.9%) 4-2107 BENEFITS - LTD/ADD8,060 8,600 10,54111,126 12,121995 8.9% 1,941 22.6% 4-2108 BENEFITS - OTHER2,047 2,316 2,5222,782 2,769(13) (0.5%) 206 8.9% 4-2200 WAGE RECOVERY-79,200 -149,800-----149,800100.0%TOTAL SALARIES & BENEFITS591,244 524,144 737,789 748,965 746,277(2,688)(0.4%)213,64540.8%4-4000 OFFICE SUPPLIES1,092 1,092 1,4451,500 1,500- - 353 32.3%4-4005 MARRIAGE LICENSES6,720 8,354 10,4177,500 8,5001,000 13.3% 2,063 24.7% 4-4006 OFFICE EQUIPMENT1,410638 1,5331,000 1,000--895140.3% 4-4010 CLOTHING ALLOWANCE353--500 300(200) (40.0%) - - 4-4045 MUNICIPAL BUSINESS531514495450450--(19)(3.7%) 4-5021 MOBILE PLAN CHARGES--9911,069 1,102333.1%991(100.0%) 4-5026 COURSES & SEMINARS2,298 2,154 2,9393,500 4,000500 14.3% 785 36.4% 4-5028 MEMBERSHIPS77979165055080025045.5%(141)(17.8%) 4-5029 MILEAGE-3194300300--63203.2% 4-5044 POSTAGE101,738 72,477 87,891105,000 107,5002,500 2.4% 15,414 21.3% 4-5045 PHOTOCOPIER CHARGES2,135 2,258 2,6202,100 2,100- - 362 16.0% 4-5059 CONTRACTS- 14,451 12,04012,500 12,500- - (2,411) (16.7%) 4-5090 COURIER3,863 2,419 2,5423,800 3,300(500) (13.2%) 123 5.1% 4-5098 ACCESSIBILITY COSTS21,217 26,370 20,04725,000 25,000- - (6,323) (24.0%) TOTAL OTHER EXPENSES 142,136 131,549 143,704 164,769 168,352 3,583 2.2% 12,155 9.2% TOTAL EXPENSES 733,380 655,693 881,493 913,734 914,629 895 0.1% 225,80034.4% NET BUDGET 700,407 613,602 836,527 872,734 874,629 1,895 0.2% 222,925 36.3% All recoveries from Water for provision of services by the rest of the Town were consolidated in 01490 (Corporate Accounts) starting in 2018Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 9 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: 4-2000 SALARIES - F/T934,490 969,757 968,5331,001,718 1,022,09920,381 2.0% (1,224) (0.1%) 4-2001 SALARIES - O/T1,422--5,412 5,412-- -- 4-2002 SALARIES - P/T-- 3,177----3,177(100.0%) 4-2090 YEAR END ACCRUALS-9,648 9,956 6,674--- - (3,282) (33.0%) 4-2100 BENEFITS - OMERS92,553 96,928 97,726111,508 114,1822,674 2.4% 798 0.8% 4-2101 BENEFITS - EHT18,312 19,036 19,00419,639 20,036397 2.0% (32) (0.2%) 4-2102 BENEFITS - WSIB6,653 6,822 6,7817,553 7,706153 2.0% (41) (0.6%) 4-2103 BENEFITS - CPP28,207 28,205 27,44128,899 29,253354 1.2% (764) (2.7%) 4-2104 BENEFITS - EI14,917 12,877 12,76413,277 13,628351 2.6% (113) (0.9%) 4-2105 BENEFITS - DENTAL16,241 17,382 16,21819,096 19,096- - (1,164) (6.7%) 4-2106 BENEFITS - HEALTH30,423 30,392 27,78632,658 33,439781 2.4% (2,606) (8.6%) 4-2107 BENEFITS - LTD/ADD16,778 17,888 21,10420,665 23,1952,530 12.2% 3,216 18.0% 4-2108 BENEFITS - OTHER4,253 4,536 4,8185,167 5,298131 2.5% 282 6.2% TOTAL SALARIES & BENEFITS 1,154,601 1,213,779 1,212,026 1,265,592 1,293,34427,7522.2%(1,753)(0.1%) 4-4000 OFFICE SUPPLIES697380-19561573122.1%(399)(105.0%) 4-4007 COMPUTER SUPPLIES7,172 8,030 6,6797,140 7,283143 2.0% (1,351) (16.8%) 4-4010 CLOTHING ALLOWANCE630366481510520102.0%11531.4% 4-4018 LICENSES81,703 180,632 155,691180,287 180,287--(24,941) (13.8%)4-4021 EQUIPMENT - OTHER9,380 2,852 1,461--- - (1,391) (48.8%)4-4028 COST REALLOCATIONS-87,844 -101,035 -89,743-90,000 -90,000- - 11,292 11.2% 4-4045 MUNICIPAL BUSINESS498422518450450--9622.7% 4-4057 COPIERS, PRINTERS AND FAXES94,970 87,883 87,58990,000 90,000- - (294) (0.3%) 4-5021 MOBILE PLAN CHARGES-- 5,5055,942 6,1101682.8%5,505(100.0%) 4-5026 COURSES & SEMINARS5,209 4,060 7,53812,000 12,000- - 3,478 85.7% 4-5028 MEMBERSHIPS13,374 14,662 16,31715,198 15,502304 2.0% 1,655 11.3% 4-5029 MILEAGE659588 317600 600- - (271) (46.1%) 4-5031 GENERAL OFFICE EQUIPMENT3,090 5,545 -949800 800- - (6,494) (117.1%) 4-5033 EQUIPMENT REPAIRS686 2,2476341,500 1,500--(1,613)(71.8%) 4-5043 CONSULTING39,330 20,053 20,92520,000 21,0001,000 5.0% 872 4.3% 4-5045 PHOTOCOPIER CHARGES299278357260260--7928.4% 4-5059 CONTRACTS13,358 3,030 3,52410,000 10,000- - 494 16.3% 4-5061 SOFTWARE ANNUAL MTCE SUPPORT420,857 353,297 480,089489,399 489,399--126,792 35.9%4-5084 OFFICE RELOCATES1,1091735191,000 1,000--346200.0%4-5099 APPLICATION VENDOR SUPPORT- 1,160 5,1343,000 3,000- - 3,974 342.6%4-5150 CULTURAL CENTRE SUPPORT/SERVICES--829----829(100.0%) TOTAL OTHER EXPENSES605,177 584,623 703,396 748,647 750,2841,6370.2%118,77320.3% TOTAL EXPENSES1,759,778 1,798,402 1,915,422 2,014,239 2,043,62829,3891.5%117,0206.5% NET BUDGET1,759,778 1,798,402 1,915,422 2,014,239 2,043,62829,3891.5%117,0206.5% 2017 expenses included expenses that belonged to 2016 but not accrued to that year2018 includes the introduction of annual fees for Laserfiche as well as increased costs/expanded requirements for existing software maintenance agreementsFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 10 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: TOTAL SALARIES & BENEFITS ----- - - - - 4-4018 LICENSES-- 6,9697,810 7,900901.2%6,969(100.0%) 4-4021 EQUIPMENT - OTHER--299- 7,1007,100(100.0%)299(100.0%) 4-5018 TELEPHONE LINES55,279 59,326 61,85660,000 60,000- - 2,530 4.3% 4-5020 LONG DISTANCE LINES1,115 1,0689421,500 1,500--(126)(11.8%) 4-5021 MOBILE PLAN CHARGES79,920 81,231 -873----(82,104) (101.1%)4-5022 CORPORATE FAX LINES6,194 5,426 6,0016,000 6,000- - 575 10.6%4-5023 INTERNET LINE18,215 20,881 18,48925,000 25,000- - (2,392) (11.5%)4-5024 TELEPHONE SERVICE AGREEMENT6,331 16,310 29,90220,000 19,000(1,000) (5.0%) 13,592 83.3% 4-5033 EQUIPMENT REPAIRS9,905 8,470 23,2958,100 1,000(7,100) (87.7%) 14,825 175.0% 4-5059 CONTRACTS32,010 25,015 27,13935,831 37,6231,792 5.0% 2,124 8.5% TOTAL OTHER EXPENSES 208,969 217,727 174,019 164,241 165,123 882 0.5% (43,708) (20.1%) TOTAL EXPENSES 208,969 217,727 174,019 164,241 165,123 882 0.5% (43,708) (20.1%) NET BUDGET 208,969 217,727 174,019 164,241 165,123 882 0.5% (43,708) (20.1%) Mobile Charges (budget and actuals) have been allocated directly to all departments to allow them better control of their costsFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 11 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: 3-1102 ADMINISTRATIVE FEES-67,211 -78,722 -41,658-65,000 -65,000---37,064 (47.1%)A decrease in fees from development related legal agreements3-1975 CIL PARKLAND CONTRIBUTION-50,000 -10,000 10,000-----20,000 (200.0%)2018 entry was booked backwards in errorTotal Revenue -117,211 -88,722 -31,658 -65,000 -65,000 - - -57,064 (64.3%) EXPENSE: 4-2000 SALARIES - F/T500,014 573,095 571,254598,658 617,33318,675 3.1% (1,841) (0.3%) 4-2001 SALARIES - O/T357--5,176 5,176-- -- 4-2002 SALARIES - P/T- 8,489 41,346----32,857 387.1%4-2090 YEAR END ACCRUALS1,236 10,575 6,793--- - (3,782) (35.8%)4-2100 BENEFITS - OMERS54,768 65,529 65,28368,454 70,9722,518 3.7% (246) (0.4%) 4-2101 BENEFITS - EHT9,991 11,399 11,97211,775 12,139364 3.1% 573 5.0% 4-2102 BENEFITS - WSIB3,589 3,755 3,8364,529 4,669140 3.1% 81 2.2% 4-2103 BENEFITS - CPP16,058 15,745 16,72215,794 15,994200 1.3% 977 6.2% 4-2104 BENEFITS - EI8,447 7,218 7,6987,301 7,492191 2.6% 480 6.7% 4-2105 BENEFITS - DENTAL5,256 6,363 7,14610,416 10,416- - 783 12.3% 4-2106 BENEFITS - HEALTH11,083 12,777 12,12117,814 18,240426 2.4% (656) (5.1%) 4-2107 BENEFITS - LTD/ADD8,583 9,757 11,72312,350 14,0091,659 13.4% 1,966 20.1% 4-2108 BENEFITS - OTHER2,276 2,690 2,9533,088 3,200112 3.6% 263 9.8% TOTAL SALARIES & BENEFITS 621,658 727,392 758,847 755,355 779,640 24,285 3.2%31,4554.3% 4-4000 OFFICE SUPPLIES1,498 1,624 1,2091,500 1,500- - (415) (25.6%) 4-4004 SUBSCRIPTIONS/PUBLICATIONS27,552 30,984 36,20022,000 22,000- - 5,216 16.8% 4-4006 OFFICE EQUIPMENT937 1,778 1,5302,000 2,000- - (248) (13.9%) 4-4045 MUNICIPAL BUSINESS608529604450450--7514.2% 4-5021 MOBILE PLAN CHARGES-- 1,9722,129 2,192633.0%1,972(100.0%) 4-5026 COURSES & SEMINARS61------ -0.0% 4-5027 MANDATORY COURSES & SEMINARS3,030 2,655 7,8043,567 4,000433 12.1% 5,149 193.9% 4-5028 MEMBERSHIPS12,069 8,142 8,1358,500 8,500- - (7) (0.1%) 4-5029 MILEAGE235394204500450(50)(10.0%)(190)(48.2%) 4-5039 INSURANCE FEES-- 551,000551,000 552,4001,4000.3%551,000(100.0%) 4-5040 INSURANCE ADJUSTER-- 7,98260,000 60,000--7,982(100.0%) 4-5045 PHOTOCOPIER CHARGES4,899 3,024 2,2683,800 3,800- - (756) (25.0%) 4-5050 APPRAISALS19,779 27,890 20,699--- - (7,191) (25.8%) 4-5052 SEARCHES & REGISTRATIONS27,753 26,012 32,12520,000 20,000- - 6,113 23.5% 4-5054 PLANNING & DEVELOPMENT263,151 85,614 22,36150,000 35,000(15,000) (30.0%)(63,253) (73.9%)4-5055 ADVOCACY52,679 60,984 65,12650,000 50,000- - 4,142 6.8%4-5057 ADJUSTOR RECOVERY-- 2,366----2,366(100.0%) 4-5060 COST RECOVERY-9,210 -17,515 -5,763-4,900 -4,900- - 11,752 67.1% 4-5067 REGION GIS CONTRACT---- 15,00015,000 (100.0%) - - 4-5095 INTEGRITY COMMISSIONER------- -- TOTAL OTHER EXPENSES405,041 232,115 755,822 770,546 772,3921,8460.2%523,707225.6% TOTAL EXPENSES1,026,699 959,507 1,514,669 1,525,901 1,552,03226,1311.7%555,16257.9% NET BUDGET909,488 870,785 1,483,011 1,460,901 1,487,03226,1311.8%612,22670.3% 2018 includes the coverage of a maternity leave - savings are reflected in the full time salary line to offset this expenseLess development related outside legal costs than previous yearFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 12 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: 4-2000 SALARIES - F/T396,331 344,024 374,843423,074 440,63917,565 4.2% 30,819 9.0% 4-2002 SALARIES - P/T53,550 71,296 59,31710,184 53,23143,047 422.7% (11,979) (16.8%) 4-2003 VACATION PAY92------ -0.0% 4-2005 LIEU TIME34------ -0.0% 4-2090 YEAR END ACCRUALS-1,183 7,104 -6,597--- - (13,701) (192.9%) 4-2100 BENEFITS - OMERS51,080 39,927 49,17546,213 48,3682,155 4.7% 9,248 23.2% 4-2101 BENEFITS - EHT8,324 7,588 8,4248,437 8,783346 4.1% 836 11.0% 4-2102 BENEFITS - WSIB3,150 2,709 2,9763,245 3,378133 4.1% 267 9.9% 4-2103 BENEFITS - CPP14,857 13,590 15,15413,186 13,619433 3.3% 1,564 11.5% 4-2104 BENEFITS - EI7,910 5,908 7,0996,223 6,388165 2.7% 1,191 20.2% 4-2105 BENEFITS - DENTAL7,224 6,267 7,3688,680 8,680- - 1,101 17.6% 4-2106 BENEFITS - HEALTH15,193 13,090 14,66614,845 15,200355 2.4% 1,576 12.0% 4-2107 BENEFITS - LTD/ADD6,282 6,853 8,7938,728 10,0001,272 14.6% 1,940 28.3% 4-2108 BENEFITS - OTHER1,765 1,746 2,0192,182 2,285103 4.7% 273 15.6% TOTAL SALARIES & BENEFITS 564,609 520,102 543,237 544,997 610,571 65,574 12.0%23,1354.4% 4-4000 OFFICE SUPPLIES1,979856 1,3181,300 1,300--46254.0% 4-4004 SUBSCRIPTIONS/PUBLICATIONS170 1,8525742,000 2,000--(1,278)(69.0%) 4-4006 OFFICE EQUIPMENT183691 1,203400400--51274.1% 4-4009 SAFETY SUPPLIES7,256 2,773 1,5873,000 3,000- - (1,186) (42.8%) 4-4045 MUNICIPAL BUSINESS2423284344505005011.1%10632.3% 4-4065 WORKPLACE ACCOMMODATIONS509 2,374 1,6062,500 2,500- - (768) (32.4%) 4-5021 MOBILE PLAN CHARGES--486524540163.1%486(100.0%) 4-5026 COURSES & SEMINARS1,507 2,889 2,5673,500 5,5002,000 57.1% (322) (11.1%) 4-5028 MEMBERSHIPS2,712 2,249 1,6313,635 3,535(100) (2.8%) (618) (27.5%) 4-5029 MILEAGE--55513513--55(100.0%) 4-5042 ADVERTISING- 3,733 14,68915,00018,0003,000 20.0% 10,956 293.5% 4-5043 CONSULTING7,893 54,080 21,93318,000 18,000--(32,147) (59.4%)4-5045 PHOTOCOPIER CHARGES2,929 2,723 2,0512,780 2,780- - (672) (24.7%)4-5046 PRINTING321-202800800--202(100.0%) 4-5049 POLICE SEARCHES-- 1,143- 15,50015,500(100.0%)1,143(100.0%) 4-5056 PERSONNEL ADMINISTRATION18,214 24,928 58,24720,000 30,00010,000 50.0%33,319 133.7%4-5059 CONTRACTS28,492 47,836 50,21463,000 60,000(3,000) (4.8%) 2,378 5.0%4-6025 EMPLOYEE RECOGNITION- 5,446 7,8894,500 6,0001,500 33.3% 2,443 44.9% 4-6026 CORPORATE COURSES & SEMINARS19,426 42,291 20,33655,000 55,000--(21,955) (51.9%)N6 HR leaders were developing training programTOTAL OTHER EXPENSES 91,833 195,049 188,165 196,902 225,868 28,966 14.7% (6,884) (3.5%) TOTAL EXPENSES 656,442 715,151 731,402 741,899 836,439 94,540 12.7% 16,251 2.3% NET BUDGET 656,442 715,151 731,402 741,899 836,439 94,540 12.7% 16,251 2.3% 2017 Consulting related to compensation reviewMore external HR legal assistance required in 2018 than previous yearFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 13 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: 4-2000 SALARIES - F/T- 356,582 321,556362,676 334,247(28,429) (7.8%) (35,026) (9.8%) 4-2002 SALARIES - P/T-- 1,764----1,764(100.0%) 4-2090 YEAR END ACCRUALS- 8,331 -5,054--- - (13,385) (160.7%) 4-2100 BENEFITS - OMERS- 43,039 36,78343,476 39,221(4,255) (9.8%) (6,256) (14.5%) 4-2101 BENEFITS - EHT- 6,989 6,2587,072 6,518(554) (7.8%) (731) (10.5%) 4-2102 BENEFITS - WSIB- 1,830 1,7422,720 2,507(213) (7.8%) (88) (4.8%) 4-2103 BENEFITS - CPP- 7,692 8,5167,856 7,94791 1.2% 824 10.7% 4-2104 BENEFITS - EI- 3,512 3,9623,582 3,67896 2.7% 450 12.8% 4-2105 BENEFITS - DENTAL- 5,483 4,4865,208 5,208- - (997) (18.2%) 4-2106 BENEFITS - HEALTH- 9,374 7,7238,907 9,120213 2.4% (1,651) (17.6%) 4-2107 BENEFITS - LTD/ADD- 5,140 4,9657,482 7,585103 1.4% (175) (3.4%) 4-2108 BENEFITS - OTHER- 1,667 1,5111,871 1,733(138) (7.4%) (156) (9.4%) 4-2201 SALARY SAVINGS----33,874 -33,874-- -- TOTAL SALARIES & BENEFITS - 449,639 394,212 416,976 383,890 (33,086) (7.9%)(55,427) (12.3%) 4-3000 PURCHASE CARD CLEARING1,775 -126 -212--- - (86) (68.3%) 4-4000 OFFICE SUPPLIES-4926491,000800(200)(20.0%)15731.9% 4-4004 SUBSCRIPTIONS/PUBLICATIONS-118125200200-- 75.9% 4-4006 OFFICE EQUIPMENT-197904200800600300.0%707358.9% 4-4045 MUNICIPAL BUSINESS- 1,704 1,9831,450 1,450- - 279 16.4% 4-5021 MOBILE PLAN CHARGES--606654673192.9%606(100.0%) 4-5026 COURSES & SEMINARS- 2,716 2,9113,500 3,500- - 195 7.2% 4-5028 MEMBERSHIPS- 10,871 13,93212,000 14,5002,500 20.8% 3,061 28.2% 4-5029 MILEAGE-220506800400(400)(50.0%)286130.0% 4-5045 PHOTOCOPIER CHARGES- 2,9003152,000 1,500(500)(25.0%)(2,585)(89.1%) TOTAL OTHER EXPENSES1,775 19,092 21,719 21,804 23,8232,0199.3%2,62713.8% TOTAL EXPENSES1,775 468,731 415,931438,780 407,713(31,067)(7.1%)(52,800)(11.3%) NET BUDGET1,775 468,731 415,931 438,780 407,713(31,067)(7.1%)(52,800)(11.3%) Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 14 of 15 2016 2017 20182018 20192019 vs 2019 vs 2018 vs 2018 vsFull Year Full Year Full YearApproved Approved2018 Budget 2018 Budget 2017 Actual 2017 Actual Variance ExplanationActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE: Total Revenue----- - - - - EXPENSE: TOTAL SALARIES & BENEFITS ----- - - - - 4-4015 OPERATING MATERIALS5,322 3,5574289,000 21,00012,000133.3%(3,129)(88.0%) 4-5018 TELEPHONE LINES13,368 14,037 14,60914,250 14,750500 3.5% 572 4.1% TOTAL OTHER EXPENSES 18,690 17,594 15,037 23,250 35,750 12,500 53.8% (2,557) (14.5%) TOTAL EXPENSES 18,690 17,594 15,037 23,250 35,750 12,500 53.8% (2,557) (14.5%) NET BUDGET 18,690 17,594 15,037 23,250 35,750 12,500 53.8% (2,557) (14.5%) Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 1 Page 15 of 15 Memorandum Date: September 25, 2019 To: Finance Advisory Committee From: Lianne Jalali, Project Management Office, Corporate Services Re: Town’s Major Capital Projects Update Recommendation 1. That the memorandum regarding Town’s Major Capital Projects Update be received for information. Background The Town currently has multiple major capital projects underway in varying stages of completion. These major projects include the following: • Library Square • 89 Mosley (Armoury) Renovation • Fire Hall 4-5 • Joint Operations Centre Additional Work Analysis Library Square The detailed design of the whole complex including Addition to the Church Street School, Outdoor Square, Parking, Bridge, and Corridor is completed. The Site Plan Application consisting of the completed Design Development drawing package has been informally submitted to the Town’s Planning department for their review and comment. Turner and Townsend has been engaged to perform an interim cost estimate on the completed Design Development drawing package in order to assess where the project stands in relation to the estimated budget. The development of the construction documents is underway and will be finalized in December 2019. 100 John West Way Box 1000 Aurora, Ontario L4G 6J1 Phone: 905-727-3123, ext 4345 Email: ljalali@aurora.ca www.aurora.ca Town of Aurora Financial Services Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 2 Page 1 of 4 Town’s Major Capital Projects Update September 25, 2019 Page 2 of 3 The project management team developed a Master Schedule for the project with the key milestones outlined below. As the project progresses, the status of each item will be updated. Milestone Expected Completion Status Design Development August 2019 Complete Construction Documents January 2020 In Progress Tender Period February 2020 Not Started Evaluation and Award March 2020 Not Started Construction Mobilization April 2020 Not Started Completion April 2022 Not Started At this point, staff are working with the Aurora Cultural Centre and the Aurora Museum and Archives to find space to relocate their operations during the construction period. The monthly status update for this project can be found under Attachment #1. 89 Mosley (Armoury) Renovation The project construction completion was postponed to October 15, 2019. The main causes of the delay in the project completion are relevant to the weather conditions during the months of construction and slow deliveries of the critical components of the renovation. The Niagara College has been informed of the revised completion date and the project team is working closely with their suppliers to fast track the delivery and installation of the kitchen equipment. The Town is working with Niagara College staff on an official opening of the facility in November 2019. The monthly status update for this project can be found under Attachment #1. Fire Hall 4-5 The proposals for construction of the new Firehall have been evaluated. All proposals are above the approved budget. The revised project cost was presented to the Joint Council Committee (JCC) for their direction. JCC advised to modify the station’s design to meet the budget. Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 2 Page 2 of 4 Town’s Major Capital Projects Update September 25, 2019 Page 3 of 3 The monthly status update for this project can be found under Attachment #1. Joint Operations Centre Additional Work The objective of this project is to complete the outstanding capital works of the JOC. The project is divided into thirteen (13) sub-projects of which four (4) sub-projects have been completed and seven (7) sub-projects will be complete by end of 2019. The Intercom System and South Side Exterior Finishing projects will be completed in 2020. All projects are on schedule and on budget so far. The monthly status update for this project can be found under Attachment #1. Attachments Attachment #1 – Major Capital Project Update: • Library Square • 89 Mosley (Armoury) Renovation • Fire Hall 4-5 • Joint Operations Centre Additional Work Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 2 Page 3 of 4 PROJECT NAMEBEGINFINISH # of DAYS STATUS PROJECTED ACTUAL REMAINDER STATUS HIGH MEDIUM LOW89 Mosley (Armoury) October 9, 2018 October 15, 2019371 On schedule $5,359,900 $3,657,703 $1,702,197 On budget 0 0 0FirehallMay 3, 2019 December 31, 2020 608 Concerned $11,087,300 $346,768 $10,740,532 Concerned 0 0 0JOC - Additional Work October 1, 2018 September 30, 2020 730 On schedule $2,185,200 $729,851 $1,455,349 On budget 0 0 0Library Square July 2, 2018 December 31, 2021 1278 On schedule $2,340,135 $947,549 $1,392,586 On budget 0 0 0Total $20,972,535 $5,681,871 $15,290,66400 0Project Status LegendOn schedule Everything is progressing as planned. No intervention from the sponsor is required Concerned Some risks and issues have been identified but the project team is handling and monitoring them Delayed/Over budget Major problems affected the project timeline and budget. The sponsor's intervention is required in this case Row Labels Sum of REMAISum of ACTUALSum of PROJECTEDFirehall 10740531.78 346768.22 1.1E+07Library Square 1392586 947549 2340135JOC - Additional W1455349 729851 218520089 Mosley (Armou 1702197.26 3657702.74 5359900Grand Total 15290664.04 5681870.96 2.1E+07Projects Gantt Chart Attachement#1Major Capital Projects Update Summary - September 2019TimelineBUDGETRISKSRow LaabbelSummofoffRuummofAACTUUALSSummofofPPROJECTCTEDEDFirehall1107444005344676868.22211.1E1E+07Library y Squ1399494755449923234013355JOC - AAddit14577298985151221855220089 Moosley (1177021133657770022.77453559900GranddTota155229066568818770..9662.11E+07(100213602399001107405534676682211EE+07ssSSSuaati(AAaa(RRRRRRSSSSSSSS533333999995555559999666669999995333333$0$2,000,000$4,000,000$6,000,000$8,000,000$10,000,000$12,000,000Firehall Library Square JOC - Additional Work 89 Mosley (Armoury)Project Budget SummarySum of REMAINDERSum of ACTUALSum of PROJECTEDValuesPROJECT NAMEFinance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 2 Page 4 of 4 Project # Project Description AmountRequested Roads 31054 1,705,300 31118 4,762,000 31119 4,500,700 31124 175,000 31178 2,960,000 14,103,000$ Storm Sewer 42064 760,000 42075 80,000 42079 200,000 42083 150,000 1,190,000$ Planning 81025 10,000 10,000$ 15,303,000$ Facilities Library 72431 Library - Rooftop HVAC Units 850,000 72432 Library - Fire Alarm Panel 21,000 72451 Library - Exterior LED Retrofit 31,400 72425 Library - Roofing 440,000 72429 Library - Repairs to elevator door system 10,200 1,352,600 Aurora Family Leisure Centre 72302 51,200 72303 25,600 72324 55,000 72328 90,100 72441 150,000 72455 25,000 396,900 Stronach Aurora Recreation Complex 72263 90,000 72305 10,200 72316 92,100 72450 128,000 72456 20,000 340,300 Town Hall 72201 250,000 72419 33,500 283,500 2020 Draft 1 Repair & Replacement Capital Projects SARC - Replacement of Plumbing Fixtures SARC - Low - E Ceiling - Arenas Planning and Development Services Road Resurfacing - Industrial Pkwy S (Engelhard - Yonge St), Vandorf Sdrd (Ind Pkwy S - Bayview) Recon - Adair, Dr., Bailey Cres., Davidson Rd., Harriman Rd. AFLC, SARC - Transfer Stations - Accessibility Plan Implementation SARC - Hoyer Lifts - Accessibility Implementation Plan AFLC - Replace Built Up Roofing above Arena Dressing Rooms AFLC - Pool Boiler Replacement SARC - West roof Area - Window Sealant SARC - Cooling Evaporator Tower Community Services Recon - Browning Crt., Johnson, Rd., Holman Cres., Baldwin Rd. AFLC - Replacement of Arena Seating AFLC - Blinds for Pool Windows AFLC - Replace Hollow Metal Doors & Exterior Exit Doors TH - Workstation Refurbishment TH - Repair of concrete/stone walkways Road Resurfacing - Henderson Dr Reconstruction of Poplar Crescent Roads 2020 Repair and Replacement Storm Sewer Outlet Cleanup Performance Monitoring of LID Controls Devlin Place Stream Rehabilitation Willow Farm Lane Stream Rehabilitation Storm Sewer 2020 Repair and Replacement GIS Scanner Planning 2020 Repair and Replacement Planning and Development Services 2020 Repair and Replacement 10 Year Capital Plan Pre-approved Capital Outcome of Council Approved Study Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 3 Page 1 of 5 Project # Project Description AmountRequested 10 Year Capital Plan Pre-approved Capital Outcome of Council Approved Study Other 72452 50,000 72453 100,000 72454 20,000 170,000 22 Church Street 72121 30,700 72388 90,800 72388 35,800 157,300 Aurora Community Centre 72172 73,900 72297 20,500 72346 28,700 72347 26,900 150,000 Central York Fire Service 72379 10,200 72381 28,800 72384 26,900 65,900 2,916,500$ 2,916,500$ Parks 73160 235,000 73212 175,000 73213 153,600 73232 102,400 666,000$ Roads 34001 50,000 34008 200,000 34616 200,000 450,000$ Water & Sewer 41013 50,000 50,000$ 1,166,000$ Corporate Management 43038 511,900 511,900$ Operational Services 2020 Repair and Replacement Roads 2020 Repair and Replacement Replace Vandorf Lift Station Pumps Emerald Ash Borer Management Program Water & Sewer 2020 Repair and Replacement Roads Operations Infrastructure Inspection, Repair and Maintenance Programs Sidewalk/Engineered Walkway Reconstruction Playground Replacement - Taylor Park Playground Replacement - Harman Park Trail/Playground Redesign - Jack Wood Park Parks 2020 Repair and Replacement Operational Services 22 Church St - Exterior Doors CYFS 4-3 - Replace windows CYFS 4-3 - Replace Suspended Ceiling Panels 22 Church St - Brick Repairs Victoria Hall - Accessible Ramp - Accessibility Implementation Unplanned - Emergency Repairs Contingency Energy and Demand Management Plan Implementation ACC - Sport Flooring Community Services 2020 Repair and Replacement 22 Church St - Repaint Interior Wall Surfaces Facilities 2020 Repair and Replacement CYFS 4-4 - Replacement of two steam humidifiers ACC - Ice Resurfacer Room Heater ACC - Reseal concrete floors ACC - Replacement of Suspended Ceiling in Lobby Financial Services Water Meter Replacement Program Financial Services 2020 Repair and Replacement Christmas Decorations Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 3 Page 2 of 5 Project # Project Description AmountRequested 10 Year Capital Plan Pre-approved Capital Outcome of Council Approved Study 14047 171,309 14070 50,000 14075 Business Process Automation and Data Integration 105,000 326,309$ 326,309$ 12037 15,000 15,000$ 20,238,709$ Information Technology 2020 Repair and Replacement Corporate Services 2020 Repair and Replacement Corporate Services Information Technology Computer & Related Infrastructure Renewal Boardroom Audio/Video Equipment CAO 2020 Draft 1 Total Repair and Replacement Projects Town of Aurora Website CAO 2020 Repair and Replacement Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 3 Page 3 of 5 Project # Project Description AmountRequested 31176 10,200 73085 96,000 73169 1,000,000 73290 15,000 73323 100,000 73327 DeGraaf Cres Trail 75,000 34003 12,000 34006 350,000 34009 15,000 1,673,200$ 34637 1,216,100 1,216,100$ Corporate Management 14037 10,000 14068 20,500 13023 Access Aurora Telephony Project 51,200 14072 Cityview Upgrade 92,100 14076 Digital Education Program 25,000 198,800$ 73324 20,000 74015 20,000 74019 20,000 72445 30,000 90,000$ 21107 Fire Hall 4-5 Turn Out Gear 75,600 75,600$ 3,253,700$ 2020 Draft 1 Total Growth and New Projects Fire Fire 2020 Growth and New Community Services Active Net Scan System Cultural Services Master Plan 2020 Draft 1 Growth & New Capital Projects Operational Services 2020 Growth and New Planning and Development Services Winter Road Monitoring System Wildlife Park - Phase 3/4 Tree Inventory for 2C Mattamy Phase 4/5 Trail Joint Ops LAN Room & DR Site Wireless Upgrades and Enhancements Operational Services Arboretum Development Community Services 2020 Growth and New CYFS 4-3 - Pylon Sign Corporate Services 2020 Growth and New Corporate Services Pet Cemetery Restoration Handheld Radios for Operations Planning and Development Services 2020 Growth and New Snow Plow Safety Enhancements Pilot Project Sidewalk - Leslie St - 600m north of Wellington to North Town Limit Pave Snow Storage Facility at Lambert Willson Park Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 3 Page 4 of 5 Project # Project Description AmountRequested 42810 200,000 81027 100,000 81031 75,000 81032 50,000 425,000$ 73329 175,000 175,000$ Corporate Management 13011 25,000 13015 50,000 13026 30,000 13027 Job Hazard Assessment 30,000 14073 Information Technology Strategic Plan Implementation 230,000 365,000$ 12026 25,000 25,000$ 14077 100,000 100,000$ 1,090,000$ Financial Services Community Benefit Charge Study Financial Services 2020 Growth and New Emergency Response Plan Update and Continuation of Operations Plan 2020 Draft 1 Studies & Other Capital Projects Planning and Development Services Community Services Climate Change Adaptation Plan Community Services 2020 Studies and Other 2020 Draft 1 Total Studies and Other Projects Planning and Development Services 2020 Studies and Other Corporate Services 2020 Studies and Other CAO Organization Structural Review CAO 2020 Studies and Other Corporate Services Employee Engagement Survey - 2020 Risk Management Building Condition Assessment and Energy Audit Municipal Heritage Register Review and Update Development Review Process and Fee Structure Town Wide Green Development Guidelines Finance Advisory Committee Meeting Agenda Wednesday, September 25, 2019 Item 3 Page 5 of 5