AGENDA - Finance Advisory Committee - 20180124
Finance
Advisory Committee
Meeting Agenda
Wednesday, January 24, 2018
5:30 p.m.
Holland Room
Aurora Town Hall
Public Release
January 17, 2018
Town of Aurora
Finance Advisory Committee
Meeting Agenda
Date: Wednesday, January 24, 2018
Time and Location: 7 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 October 12, 2017
Recommended:
That the Finance Advisory Committee meeting minutes of October 12, 2017, be
received for information.
4. Delegations
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018 Page 2 of 3
5.Consideration of Items
1.2018 Work Plan for Finance Advisory Committee
Recommended:
1.That the 2018 Work Plan for Finance Advisory Committee be received; and
2.That the 2018 Work Plan be approved.
2.2018 Work Plan for Financial Planning Division
Recommended:
1.That the 2018 Work Plan for Financial Planning Division be received for
information.
3.Budget Committee Schedule – 2019 Budget Process
Recommended:
1.That the Budget Committee Schedule – 2019 Budget Process be received
for information.
4.Distribution and Introduction of Detailed Financial Budget Information
Re: Financial Services (FS) Department
Recommended:
1.That the detailed financial budget information for Financial Services
department be received and deferred for discussion and detailed review at
the February 28, 2018 meeting of the Finance Advisory Committee.
5.Extract from Council Meeting of November 14, 2017
Re: Finance Advisory Committee Meeting Minutes of September 27, 2017, and October 12, 2017
Recommended:
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018 Page 3 of 3
1.That the Extract from Council Meeting of November 14, 2017, regarding
Finance Advisory Committee meeting minutes of September 27, 2017, and
October 12, 2017, be received for information.
6.New Business
7.Adjournment
Town of Aurora
Finance Advisory Committee
Meeting Minutes
Date: Thursday, October 12, 2017
Time and Location: 7 p.m., Holland Room, Aurora Town Hall
Committee Members: Councillor Michael Thompson (Chair), Councillor Harold
Kim, and Mayor Geoffrey Dawe
Member(s) Absent: None
Other Attendees: Dan Elliott, Director of Financial Services/Treasurer, Jason
Gaertner, Manager, Financial Planning, and Linda Bottos,
Council/Committee Secretary
The Chair called the meeting to order at 7:04 p.m.
1. Approval of the Agenda
Moved by Mayor Dawe
Seconded by Councillor Kim
That the agenda as circulated by Legislative Services be approved.
Carried
2. Declarations of Pecuniary Interest and General Nature Thereof
There were no declarations of pecuniary interest under the Municipal Conflict of
Interest Act.
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Minutes
Page 1 of 4
Finance Advisory Committee Meeting Minutes
Thursday, October 12, 2017 Page 2 of 4
3. Receipt of the Minutes
Finance Advisory Committee Meeting Minutes of September 27, 2017
Moved by Councillor Kim
Seconded by Mayor Dawe
That the Finance Advisory Committee meeting minutes of September 27, 2017, be
received for information.
Carried
4. Delegations
None
5. Consideration of Items
1. Walkthrough of the Online 2018 Citizen Budget Survey
Staff provided an online demonstration of the Town’s 2018 Citizen Budget
Survey at aurora.citizenbudget.com, noting that the primary purposes of the
Survey are to educate residents on the Town’s services and obtain feedback
from residents on their priorities as to where they would like to see public
funds focussed. The Committee discussed various aspects of the Survey and
acknowledged the challenges of engaging citizens to participate in the Budget
process.
Moved by Mayor Dawe
Seconded by Councillor Kim
1. That the Walkthrough of the Online 2018 Citizen Budget Survey be
received for information.
Carried
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Minutes
Page 2 of 4
Finance Advisory Committee Meeting Minutes
Thursday, October 12, 2017 Page 3 of 4
2. Memorandum from Director of Financial Services/Treasurer
Re: Round Table Discussion: 2018 Operating Budget Pressures
Staff provided a brief overview of the memorandum and attachments regarding
the key 2018 Operating Budget pressures that are addressed within staff’s
recommended draft budget, resulting in a total tax levy increase of 2.9%, and
the list of Council budget decision options over and above staff’s
recommended draft Budget. The Committee discussed various aspects
including Budget presentation options, phase-in of the new provincial labour
legislation (Bill 148), departmental key pressures and lost revenue, and a
policy/principles-based framework under which third-party funding
arrangements would be governed.
Moved by Councillor Kim
Seconded by Mayor Dawe
1. That the memorandum regarding Round Table Discussion: 2018
Operating Budget Pressures be received for information; and
2. That the comments and suggestions of the discussion regarding the 2018
Operating Budget Pressures be received and referred to staff for
consideration and action as appropriate; and
3. That the Finance Advisory Committee endorse the practice of using
the Tax Rate Stabilization Reserve Fund to balance the Budget; and
4. That staff provide a report on the development of a policy/principles-
based framework under which third-party funding arrangements
would be managed.
Carried as amended
6. New Business
The Committee agreed that the meetings scheduled for October 25, November 22,
and December 14, 2017, be cancelled, and that any required meeting would be at
the call of the Chair.
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Minutes
Page 3 of 4
Finance Advisory Committee Meeting Minutes
Thursday, October 12, 2017 Page 4 of 4
7. Adjournment
Moved by Councillor Kim
Seconded by Mayor Dawe
That the meeting be adjourned at 8:21 p.m.
Carried
Committee recommendations are not binding on the Town unless adopted by Council.
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Minutes
Page 4 of 4
Finance Advisory Committee: 2018 Work Plan Outline – Proposed by Staff
(All meetings currently scheduled for Wednesdays 5:30 p.m.)
January 24, 2018:
•Review and approval of FAC 2018 Work Plan
•Review of 2018 Work Plan for Financial Planning Division
•Review of Budget Committee Schedule – 2019 Budget Process
•Receipt of Financial Services (FS) department budget materials (review at next meeting)
February 28, 2018:
•Detailed Budget Review: Financial Services (45 minutes)
•Review of work plan for Cultural Partners review and third party funding framework
projects
•Review of 2019 Budget Preparation Directives report
•Receipt of Corporate Services (CS) department budget materials (review at next
meeting)
March 28, 2018:
•Detailed Budget Review: Corporate Services (45 minutes)
•Receipt of Operational Services (OS) department budget materials (review at next
meeting)
•Identification of specific areas of focus for OS budget review
April 25, 2018:
•Detailed Budget Review: Operational Services (45 minutes)
•Review of Public Art funding models, best practices, and recommendations
May 23, 2018:
•Detailed Budget Review: Operational Services continued (45 minutes)
•Receipt of Water/Wastewater/Storm utilities budget materials (review at next meeting)
June 27, 2018:
•Detailed Budget Review: Water/Wastewater/Storm utilities budget
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Item 1
Page 1 of 1
2018 / 2019 Financial Planning WorkplanTown of Aurora51219262 9 1623 2 9 162330 6 132027 4 111825 1 8 152229 6 132027 3 10172431 7 1421 28 5 12 19 26 2 9 16 23 30 7 14 21 28Town KPI review & updateCouncil direction to staff Re: operating budget tax increase thresholds for 2019 & approval of 2019 budget workplan2018 water, wastewater, storm water budget approvalReview and update of four year staffing plan ( 2019 to 2022 )2018 R&R in-year capital budget creation2018 ten year capital plan updateDetailed 2019 capital budget creationAsset management plan foundational rationale review & update (Formal approval required - new Council)NEW strategic asset management policy (Formal approval required - new Council)2019 fees & service charge schedule update (Includes any NEW revenue generation opportunities)2019 tax levy funded operating budget AND water operating budget creation (Includes review & update of the 'out years' 2020, 2021, 2022)April MayMilestoneJanuary FebruaryDecemberBUDGETJuneJulyAugust September October NovemberMarchJan. 29 to Feb. 11th: Creation of reportFeb. 28th: FAC review of proposed 2019 Council Budget Direction & Budget WorkplanApr. 3rd: GC;Apr. 10th: Council Jan. 15th to Mar. 9th:Review and update of applicable detailed Capital ProjectsMar. 12 to 23rd: Finalization of draft budget, report and attachmentsApr. 17th: GC; Apr. 24th: Council approvalApr. 2nd to Jul. 27th: Staff review and update and finalization of ten year capital planSpecial GC's: Feb. 9, 2019 and Feb. 11, 2019, Feb. 26, 2019: Council Approval Apr. 2nd to July 27th:Staff review, update and finalization of detailed 2019 capital plan including all binder contentsSpecial GC's: Feb. 9, 2019 and Feb. 11, 2019, Feb. 26, 2019: Council Approval Feb. 14 - May 25th: Capital asset management steering committee (CAMSC) review & update of AMP foundational contentsSpecial GC's: Feb. 9, 2019 and Feb. 11, 2019, Feb. 26, 2019: Council Approval Feb. 14 - July 27th: Capital Asset Management Steering Committee (CAMSC) coordinated creation of newly required strategic asset management policySpecial GC's: Feb. 9, 2019 and Feb. 11, 2019, Feb. 26, 2019: Council Approval Jun. 18 to Jul. 27th:Departmental review & update of 2019 fee schedulesAug. 14th: Council initiation; Public Review Period (2 weeks); Sep. 18th: Council (Bylaw Approval)Jan. 15th to Oct. 19th: Departmental review and update of 2019 Operational plans plus three out years, including all binder contentsFeb. 12th, 2019 Council: 2019 Operating Budget Kick-off and Binder material distributionJan. 8 to Feb. 26:Finalization of draft budget, report and presentationMar. 20th: GC; Mar. 27th: Council Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 2 Page 1 of 2
2018 / 2019 Financial Planning WorkplanTown of Aurora51219262 9 1623 2 9 162330 6 132027 4 111825 1 8 152229 6 132027 3 10172431 7 1421 28 5 12 19 26 2 9 16 23 30 7 14 21 28April MayMilestoneJanuary FebruaryDecemberJune July August September October NovemberMarchExecutive Leadership Team (ELT) financial performance management meetingCapital close report #1 ( As of December 31, 2017 )2017 Final audit & financial statement preparation2018 Interim operating budget forecast update ( As of April 30, 2018 ) 2017 year end financial performance reportCapital Close Report #2 (As of July 31, 2018)2018 Interim operating budget forecast update ( As of August 31, 2018 )2018 Interim operating budget forecast update ( As of October 31, 2018 )Finance Advisory Committee (FAC) Meetings2018 year end surplus control bylaw reportREPORTINGOTHERFinanical Planning faciliated External Audit of corporation and preparation of annual financial statementsJun. 26th: Council receipt of final 2017 audit report and financial statementsMay 9 to 25th:Department review and forecast update and report creationJun. 19th: GC; Jun. 26th:Council May 14 to 25th:Creation of 2017 year end reportJune 12th: Council ReceiptAug. 7-24th: Department review and update of open list of capital projects and finalization of projects requiring closureSept. 11th: GC, Sept. 18th: Council Sept. 10-25thDepartment review and forecast update and report creationOct. 2018: Council information report formatNov. 12-30th:Department review and forecast update and report creationDec. 18th:Straight to Council Aug. 13-24th: Creation of report & BylawSept. 11th: GC; Sept. 18th:Council approval of bylawFeb. 20 to Mar. 23rd: Department review and update of open list of capital projects and finalization of projects requiring closureApril 17th: GC,April 24th: Council Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 2 Page 2 of 2
Budget Committee Schedule – 2019 Budget Process
(All Budget Committee meeting dates subject to confirmation by the incoming Council)
Special Budget Consultation Meeting
Date: Monday, January 14, 2019 (Budget Committee)
Time: 6:00pm
Where: Council Chambers
Agenda: The budget committee will hear delegations with suggestions regarding how the Town could
increase non-tax revenues and/or save money on its delivery of existing processes and services. The
budget committee will also ask community groups, organizations or individuals seeking funding or
services in-kind from the Town to make a presentation of any requests of this nature to the committee
for its consideration for inclusion in the upcoming 2019 budget process.
Capital Budget Review
Date: Tuesday, January 29, 2019 (regular Council meeting)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Treasurer will make a short presentation and kick off the Budget Committee’s review of
the Town’s draft Ten Year Capital Investment Plan and draft Detailed 2019 Capital Plan. Also, budget
material will be distributed to committee members for their review prior to their first scheduled formal
review meeting.
Capital Budget Review
Date: Monday, February 4, 2019 (Budget Committee)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will undertake its review of the Town’s Ten Year Capital Investment
Plan as well as its draft Detailed 2019 Capital Plan.
Capital Budget Review
Date: Monday, February 11, 2019 (Budget Committee, if required)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will continue its review of the Town’s draft Detailed 2019 Capital
Plan.
Council – Capital Budget Approval
Date: Tuesday, February 26, 2019 (regular Council meeting)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The final 2019 Capital Budget will be brought to Council for its review and approval.
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Item 3
Page 1 of 2
Operating Budget
Date: Tuesday, February 12, 2019 (regular Council meeting)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Treasurer will make a short presentation and kick off the Budget Committee’s review of
the Town’s draft 2019 plus outlook Years (2020 to 2022) Operating Budget. Also, budget material will
be distributed to committee members for their review prior to their first scheduled formal review
meeting.
Operating Budget
Date: Monday, February 25, 2019 (Budget Committee)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will commence its review of the Town’s draft 2019 Operating Budget.
Operating Budget
Date: Monday, March 4, 2019 (Budget Committee)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will continue its review of the Town’s draft 2019 Operating Budget.
The Aurora Public Library Board, Aurora Cultural Centre Board, Aurora Historical Society Board, Sport
Aurora, and Aurora Sport Hall of Fame will make their budget presentations.
Operating Budget
Date: Monday, March 11, 2019 (Budget Committee)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will continue its review of the Town’s draft 2019 Operating Budget.
Operating Budget
Date: Monday, March 18, 2019 (Budget Committee, if required)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The Budget Committee will continue its review of the Town’s draft 2019 Operating Budget.
Council – Operating Budget Approval
Date: Tuesday, March 26, 2019 (regular Council meeting)
Time: 7:00 p.m. to 10:30 p.m.
Agenda: The final 2019 Operating Budget will be brought to Council for its review and approval.
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Item 3
Page 2 of 2
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE:3‐1010 PROPERTY TAX OWNERSHIP CHANGE FEE(59,903) (66,464) (55,187)(37,600) (50,000)12,400 33.0% (11,277) (17.0%)3‐1011 WATER/WASTEWATER OWNERSHIP CHANGE FE(71,759) (110,589) (128,761)(68,500) (75,000)6,500 9.5% 18,172 16.4%3‐1102 ADMINISTRATIVE FEES(14,022) (13,803) (13,395)(13,300) (13,600)300 2.3% (408) (3.0%)3‐1112 TAX CERTIFICATES(61,655) (62,991) (57,483)(52,000) (54,100)2,100 4.0% (5,508) (8.7%)3‐1200 OVER/UNDER12611‐‐‐‐6098.4%3‐1201 OTHER(10,248) (9,868) (16,764)(10,000) (10,000)‐ ‐ 6,896 69.9%Total Revenue (217,575) (263,654)(271,589) (181,400) (202,700) 21,300 11.7% 7,935 3.0%EXPENSE:4‐2000 SALARIES ‐ F/T1,343,363 1,286,835 1,367,4541,418,507 1,483,08864,581 4.6% 80,619 6.3%4‐2001 SALARIES ‐ O/T817 2,907 2,450‐‐‐ ‐ (457) (15.7%)4‐2002 SALARIES ‐ P/T8,989 67,112 80,45960,143 73,87013,727 22.8% 13,347 19.9%4‐2003 VACATION PAY‐ 1,441‐‐‐‐‐(1,441)(100.0%)4‐2004 SICK PAY‐159‐‐‐‐‐(159)(100.0%)4‐2090 YEAR END ACCRUALS(44,165) 30,106 19,043‐‐‐ ‐ (11,063) (36.7%)4‐2100 BENEFITS ‐ OMERS133,243 129,074 139,011151,522 165,99614,474 9.6% 9,937 7.7%4‐2101 BENEFITS ‐ EHT26,216 26,387 27,82226,648 30,3053,657 13.7% 1,435 5.4%4‐2102 BENEFITS ‐ WSIB9,937 8,712 9,34810,249 11,6561,407 13.7% 636 7.3%4‐2103 BENEFITS ‐ CPP38,046 36,226 38,84239,113 44,9805,867 15.0% 2,616 7.2%4‐2104 BENEFITS ‐ EI21,476 20,404 19,05520,541 20,733192 0.9% (1,349) (6.6%)4‐2105 BENEFITS ‐ DENTAL23,341 20,870 22,48027,612 27,776164 0.6% 1,610 7.7%4‐2106 BENEFITS ‐ HEALTH41,653 41,523 44,10042,889 47,5034,614 10.8% 2,577 6.2%4‐2107 BENEFITS ‐ LTD/ADD21,249 20,905 21,53125,511 30,5965,085 19.9% 626 3.0%4‐2108 BENEFITS ‐ OTHER6,275 6,115 6,2316,374 7,6501,276 20.0% 116 1.9%4‐2200 WAGE RECOVERY(302,230) (306,800) (363,765)(363,765) 0363,765 0.0% (56,965) (18.6%)4‐2201 SALARY SAVINGS‐‐‐(12,279) (12,279)‐‐ ‐‐TOTAL SALARIES & BENEFITS 1,328,210 1,391,976 1,434,061 1,453,065 1,931,874478,80933.0%42,0853.0%4‐3000 PURCHASE CARD CLEARING‐‐284‐‐‐‐284‐4‐4000 OFFICE SUPPLIES4,072 3,080 3,9173,000 3,000‐ ‐ 837 27.2%4‐4004 SUBSCRIPTIONS/PUBLICATIONS1,414 2,803 1,6341,690 1,340(350) (20.7%) (1,169) (41.7%)4‐4006 OFFICE EQUIPMENT‐51 ‐‐‐‐‐(51)(100.0%)4‐4028 COST REALLOCATIONS(25,000) (25,400) (6,500)‐‐‐ ‐ 18,900 74.4%4‐4045 MUNICIPAL BUSINESS1,922 2,671 1,4392,350 2,350‐ ‐ (1,232) (46.1%)4‐4060 CENTRAL SUPPLIES431 2,021591‐‐‐‐(1,430)(70.8%)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%1Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 1 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%4‐5026 COURSES & SEMINARS6,151 8,153 8,6195,020 5,10282 1.6% 466 5.7%4‐5027 MANDATORY COURSES & SEMINARS2,658 2,610 2,327‐‐‐ ‐ (283) (10.8%)4‐5028 MEMBERSHIPS8,505 9,144 8,15710,475 10,475‐ ‐ (987) (10.8%)4‐5029 MILEAGE557691694725725‐‐ 30.4%4‐5031 GENERAL OFFICE EQUIPMENT51 3,493129500500‐‐(3,364)(96.3%)4‐5033 EQUIPMENT REPAIRS‐465‐‐‐‐‐(465)(100.0%)4‐5035 EQUIPMENT SERVICE CONTRACTS2,798656‐3,400 3,5001002.9%(656)(100.0%)4‐5043 CONSULTING388 39,999 23,55340,200 33,100(7,100) (17.7%) (16,446) (41.1%)4‐5045 PHOTOCOPIER CHARGES12,334 11,913 12,07213,656 13,310(346)(2.5%)1591.3%4‐5046 PRINTING8,028 4,157 10,8789,550 9,900350 3.7% 6,721 161.7%4‐5059 CONTRACTS14,537 20,760 17,20518,600 19,200600 3.2% (3,555) (17.1%)4‐5060 COST RECOVERY(5,500) (5,700) (1,450)‐‐‐ ‐ 4,250 74.6%4‐6001 BANK CHARGES19,859 20,285 19,74122,650 23,330680 3.0% (544) (2.7%)TOTAL OTHER EXPENSES 53,205 101,852 103,290 131,816 125,832 (5,984) (4.5%) 1,438 1.4%TOTAL EXPENSES 1,381,415 1,493,828 1,537,351 1,584,881 2,057,706 472,825 29.8% 43,523 2.9%NET BUDGET 1,163,840 1,230,174 1,265,762 1,403,481 1,855,006 451,525 32.2% 35,588 2.9%2Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 2 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE:3‐1200 OVER/UNDER1261‐‐‐‐‐61100.0%3‐1201 OTHER‐‐ (247)‐‐‐‐247‐Total Revenue1261 (247)‐‐‐‐308504.9%EXPENSE:4‐2000 SALARIES ‐ F/T235,531 238,485 247,885241,281 245,3544,073 1.7% 9,400 3.9%4‐2002 SALARIES ‐ P/T‐‐‐9,000 8,766(234) (2.6%) ‐ ‐4‐2090 YEAR END ACCRUALS3,280 3,359 40,403‐‐‐‐37,044 1,102.8%4‐2100 BENEFITS ‐ OMERS28,552 28,841 29,19528,981 29,505524 1.8% 354 1.2%4‐2101 BENEFITS ‐ EHT4,615 4,673 4,8574,705 4,949244 5.2% 184 3.9%4‐2102 BENEFITS ‐ WSIB1,330 1,156 1,2121,810 1,90494 5.2% 56 4.8%4‐2103 BENEFITS ‐ CPP4,960 5,089 5,1285,174 5,481307 5.9% 39 0.8%4‐2104 BENEFITS ‐ EI2,606 2,674 2,3412,711 2,610(101) (3.7%) (333) (12.5%)4‐2105 BENEFITS ‐ DENTAL2,463 2,308 2,5273,682 3,472(210) (5.7%) 219 9.5%4‐2106 BENEFITS ‐ HEALTH4,063 4,201 4,2595,718 5,938220 3.8% 58 1.4%4‐2107 BENEFITS ‐ LTD/ADD3,185 3,187 3,0994,531 5,062531 11.7% (88) (2.8%)4‐2108 BENEFITS ‐ OTHER1,083 1,113 1,1011,132 1,266134 11.8% (12) (1.1%)4‐2200 WAGE RECOVERY(31,300) (31,800) (32,300)(32,300) 032,300 0.0% (500) (1.6%)4‐2201 SALARY SAVINGS‐‐‐(12,279) (12,279)‐‐ ‐‐TOTAL SALARIES & BENEFITS 260,368 263,286 309,707 264,146 302,028 37,88214.3%46,42117.6%4‐3000 PURCHASE CARD CLEARING‐‐284‐‐‐‐284‐4‐4000 OFFICE SUPPLIES3,950 2,808 3,6642,500 3,000500 20.0% 856 30.5%4‐4004 SUBSCRIPTIONS/PUBLICATIONS45 1,443202310300(10)(3.2%)(1,241)(86.0%)4‐4045 MUNICIPAL BUSINESS916 1,4907171,000 1,000‐‐(773)(51.9%)4‐5026 COURSES & SEMINARS678 1,986 1,2641,451 1,451‐ ‐ (722) (36.4%)4‐5027 MANDATORY COURSES & SEMINARS1,106941‐‐‐‐‐(941)(100.0%)4‐5028 MEMBERSHIPS3,561 3,512 2,3853,650 3,650‐ ‐ (1,127) (32.1%)4‐5029 MILEAGE‐32 ‐‐‐‐‐(32)(100.0%)4‐5031 GENERAL OFFICE EQUIPMENT51 3,493129500500‐‐(3,364)(96.3%)4‐5033 EQUIPMENT REPAIRS‐465‐‐‐‐‐(465)(100.0%)4‐5043 CONSULTING‐ 25,794 16,93924,000 17,000(7,000) (29.2%) (8,855) (34.3%)4‐5045 PHOTOCOPIER CHARGES11,541 10,713 11,24312,776 12,200(576)(4.5%)5304.9%4‐5046 PRINTING1,198‐‐‐‐‐‐ ‐‐4‐5059 CONTRACTS‐ 1,427 2,422‐‐‐ ‐ 995 69.7%Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%3Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 3 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%4‐5060 COST RECOVERY(5,500) (5,700) (1,450)‐‐‐ ‐ 4,250 74.6%TOTAL OTHER EXPENSES 17,546 48,404 37,799 46,187 39,101 (7,086) (15.3%) (10,605) (21.9%)TOTAL EXPENSES 277,914 311,690 347,506 310,333 341,129 30,796 9.9% 35,816 11.5%NET BUDGET 277,926 311,751 347,259 310,333 341,129 30,796 9.9% 35,508 11.4%4Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 4 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE:3‐1010 PROPERTY TAX OWNERSHIP CHANGE FEE(59,903) (66,464) (55,187)(37,600) (50,000)12,400 33.0% (11,277) (17.0%)3‐1011 WATER/WASTEWATER OWNERSHIP CHANGE FE(71,759) (110,589) (128,761)(68,500) (75,000)6,500 9.5% 18,172 16.4%3‐1102 ADMINISTRATIVE FEES(13,956) (13,471) (13,395)(13,300) (13,600)300 2.3% (76) (0.6%)3‐1112 TAX CERTIFICATES(61,655) (62,991) (57,483)(52,000) (54,100)2,100 4.0% (5,508) (8.7%)3‐1200 OVER/UNDER‐‐1‐‐‐‐(1)‐3‐1201 OTHER(10,248) (9,868) (16,517)(10,000) (10,000)‐ ‐ 6,649 67.4%Total Revenue (217,521) (263,383)(271,342) (181,400) (202,700) 21,300 11.7% 7,959 3.0%EXPENSE:4‐2000 SALARIES ‐ F/T457,984 442,867 449,956479,158 481,1832,025 0.4% 7,089 1.6%4‐2001 SALARIES ‐ O/T817‐ 2,406‐‐‐‐2,406‐4‐2002 SALARIES ‐ P/T‐ 39,113 88,15042,900 56,72113,821 32.2%49,037 125.4%4‐2003 VACATION PAY‐ 1,199‐‐‐‐‐(1,199)(100.0%)4‐2004 SICK PAY‐73 ‐‐‐‐‐(73)(100.0%)4‐2090 YEAR END ACCRUALS6,521 9,649 (10,127)‐‐‐ ‐ (19,776) (205.0%)4‐2100 BENEFITS ‐ OMERS36,040 34,049 35,97951,221 51,30281 0.2% 1,930 5.7%4‐2101 BENEFITS ‐ EHT8,993 9,454 9,8419,343 10,4471,104 11.8% 387 4.1%4‐2102 BENEFITS ‐ WSIB3,589 3,300 3,5423,594 4,018424 11.8% 242 7.3%4‐2103 BENEFITS ‐ CPP12,400 13,318 14,45015,523 18,2382,715 17.5% 1,132 8.5%4‐2104 BENEFITS ‐ EI7,817 8,250 7,8848,133 8,359226 2.8% (366) (4.4%)4‐2105 BENEFITS ‐ DENTAL9,587 8,850 9,29111,045 10,416(629) (5.7%) 441 5.0%4‐2106 BENEFITS ‐ HEALTH15,986 16,269 17,70717,156 17,814658 3.8% 1,438 8.8%4‐2107 BENEFITS ‐ LTD/ADD6,613 6,628 6,6048,997 9,926929 10.3% (24) (0.4%)4‐2108 BENEFITS ‐ OTHER2,172 2,174 2,0972,248 2,482234 10.4% (77) (3.5%)4‐2200 WAGE RECOVERY(212,330) (215,500) (226,700)(226,700) 0(226,700) ‐ 11,200 5.2%TOTAL SALARIES & BENEFITS 356,189 379,693 411,080 422,618 670,906 248,288 58.7% 31,387 8.3%4‐4004 SUBSCRIPTIONS/PUBLICATIONS1,369 1,360 1,3431,380 1,040(340) (24.6%) (17) (1.3%)4‐4028 COST REALLOCATIONS(25,000) (25,400) (6,500)‐‐‐ ‐ 18,900 74.4%4‐4045 MUNICIPAL BUSINESS86419292450450‐‐(127)(30.3%)4‐5026 COURSES & SEMINARS3,238 1,550 3,6971,257 1,257‐ ‐ 2,147 138.5%4‐5028 MEMBERSHIPS2,333 2,405 2,5312,825 2,825‐ ‐ 126 5.2%4‐5029 MILEAGE326478432425425‐‐(46)(9.6%)4‐5035 EQUIPMENT SERVICE CONTRACTS2,798656‐3,400 3,5001002.9%(656)(100.0%)4‐5043 CONSULTING163946‐10,000 10,000‐‐(946)(100.0%)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%5Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 5 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%4‐5046 PRINTING6,830 4,157 10,8789,550 9,900350 3.7% 6,721 161.7%4‐5059 CONTRACTS14,537 19,333 14,78318,600 19,200600 3.2% (4,550) (23.5%)4‐6001 BANK CHARGES19,859 20,285 19,74122,650 23,330680 3.0% (544) (2.7%)TOTAL OTHER EXPENSES 26,539 26,189 47,197 70,537 71,927 1,390 2.0% 21,008 80.2%TOTAL EXPENSES 382,728 405,882 458,277 493,155 742,833 249,678 50.6% 52,395 12.9%NET BUDGET 165,207 142,499 186,935 311,755 540,133 228,378 73.3% 44,43631.2%6Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 6 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE:Total Revenue ‐‐‐‐‐ ‐ ‐ ‐ ‐EXPENSE:4‐2000 SALARIES ‐ F/T365,364 372,863 381,306382,943 392,8479,904 2.6% 8,443 2.3%4‐2090 YEAR END ACCRUALS(1,920) 7,614 (7,247)‐‐‐ ‐ (14,861) (195.2%)4‐2100 BENEFITS ‐ OMERS41,622 42,428 43,57543,418 44,7221,304 3.0% 1,147 2.7%4‐2101 BENEFITS ‐ EHT7,162 7,308 7,4747,467 7,660193 2.6% 166 2.3%4‐2102 BENEFITS ‐ WSIB2,801 2,584 2,6292,872 2,94674 2.6% 45 1.7%4‐2103 BENEFITS ‐ CPP9,920 10,177 10,25610,348 10,474126 1.2% 79 0.8%4‐2104 BENEFITS ‐ EI5,211 5,348 4,6835,422 4,776(646) (11.9%) (665) (12.4%)4‐2105 BENEFITS ‐ DENTAL7,124 6,678 7,3117,363 6,944(419) (5.7%) 633 9.5%4‐2106 BENEFITS ‐ HEALTH11,923 12,328 12,49911,437 11,876439 3.8% 171 1.4%4‐2107 BENEFITS ‐ LTD/ADD6,690 6,805 6,9347,190 8,104914 12.7% 129 1.9%4‐2108 BENEFITS ‐ OTHER1,815 1,752 1,7911,797 2,026229 12.7% 39 2.2%4‐2200 WAGE RECOVERY(58,600) (59,500) (60,400)(60,400) 060,400 0.0% (900) (1.5%)TOTAL SALARIES & BENEFITS 399,112 416,385 410,811 419,857 492,375 72,518 17.3% (5,574) (1.3%)4‐4006 OFFICE EQUIPMENT‐51 ‐‐‐‐‐(51)(100.0%)4‐4045 MUNICIPAL BUSINESS‐12815450450‐‐(113)(88.3%)4‐5026 COURSES & SEMINARS461 1,572335968 1,050828.5%(1,237)(78.7%)4‐5027 MANDATORY COURSES & SEMINARS1,551 1,669 2,327‐‐‐ ‐ 658 39.4%4‐5028 MEMBERSHIPS1,882 1,951 1,9682,500 2,500‐ ‐ 17 0.9%4‐5029 MILEAGE‐181‐‐‐‐‐(181)(100.0%)4‐5043 CONSULTING225 13,260 6,6146,200 6,100(100) (1.6%) (6,646) (50.1%)TOTAL OTHER EXPENSES 4,119 18,812 11,259 10,118 10,100 (18) (0.2%) (7,553)(40.1%)TOTAL EXPENSES403,231 435,197 422,070 429,975 502,47572,50016.9%(13,127)(3.0%)NET BUDGET403,231 435,197 422,070 429,975 502,47572,50016.9%(13,127)(3.0%)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%7Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 7 of 8
2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget 2016 Actual 2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease)Increase / (Decrease)REVENUE:3‐1102 ADMINISTRATIVE FEES(66) (332)‐‐‐‐‐(332)(100.0%)Total Revenue(66) (332)‐‐‐‐‐(332)(100.0%)EXPENSE:4‐2000 SALARIES ‐ F/T284,484 232,619 288,307315,125 363,70448,579 15.4%55,688 23.9%4‐2001 SALARIES ‐ O/T‐ 2,90744‐‐‐‐(2,863)(98.5%)4‐2002 SALARIES ‐ P/T8,989 27,999 19,9848,243 8,383140 1.7% (8,015) (28.6%)4‐2003 VACATION PAY‐242‐‐‐‐‐(242)(100.0%)4‐2004 SICK PAY‐86 ‐‐‐‐‐(86)(100.0%)4‐2090 YEAR END ACCRUALS(52,046) 9,484 (3,986)‐‐‐ ‐ (13,470) (142.0%)4‐2100 BENEFITS ‐ OMERS27,028 23,757 30,26227,902 40,46712,565 45.0% 6,505 27.4%4‐2101 BENEFITS ‐ EHT5,447 4,952 5,6505,132 7,2492,117 41.3% 698 14.1%4‐2102 BENEFITS ‐ WSIB2,216 1,673 1,9651,974 2,788814 41.2% 292 17.5%4‐2103 BENEFITS ‐ CPP10,767 7,642 9,0088,067 10,7872,720 33.7% 1,366 17.9%4‐2104 BENEFITS ‐ EI5,842 4,131 4,1474,275 4,988713 16.7% 16 0.4%4‐2105 BENEFITS ‐ DENTAL4,167 3,034 3,3515,522 6,9441,422 25.8% 317 10.4%4‐2106 BENEFITS ‐ HEALTH9,681 8,725 9,6358,578 11,8763,298 38.4% 910 10.4%4‐2107 BENEFITS ‐ LTD/ADD4,761 4,284 4,8944,793 7,5032,710 56.5% 610 14.2%4‐2108 BENEFITS ‐ OTHER1,206 1,075 1,2421,198 1,876678 56.6% 167 15.5%4‐2200 WAGE RECOVERY‐‐ (44,365)(44,365)‐44,365‐(44,365)(100.0%)TOTAL SALARIES & BENEFITS312,542 332,610 330,138 346,444 466,565120,12134.7%(2,472)(0.7%)4‐4000 OFFICE SUPPLIES122272254500‐(500)(100.0%)(18)(6.6%)4‐4004 SUBSCRIPTIONS/PUBLICATIONS‐‐90‐‐‐‐90‐4‐4045 MUNICIPAL BUSINESS920634414450450‐‐(220)(34.7%)4‐4060 CENTRAL SUPPLIES431 2,021591‐‐‐‐(1,430)(70.8%)4‐5026 COURSES & SEMINARS1,774 3,046 3,3231,344 1,344‐ ‐ 277 9.1%4‐5028 MEMBERSHIPS729 1,276 1,2731,500 1,500‐ ‐ (3) (0.2%)4‐5029 MILEAGE232‐262300300‐‐262‐4‐5045 PHOTOCOPIER CHARGES793 1,200829880 1,11023026.1%(371)(30.9%)TOTAL OTHER EXPENSES5,001 8,449 7,036 4,974 4,704(270)(5.4%)(1,413)(16.7%)TOTAL EXPENSES317,543 341,059 337,174 351,418 471,269119,85134.1%(3,885)(1.1%)NET BUDGET317,477 340,727 337,174 351,418 471,269119,85134.1%(3,553)(1.0%)Dollar Change > +/‐ $20,000ANDPercentage Change > +/‐ 10%8Finance Advisory Committee Meeting Agenda Wednesday, January 24, 2018 Item 4 Page 8 of 8
Page 1 of 1
5. Consent Agenda
Moved by Councillor Thompson
Seconded by Councillor Gaertner
C1. General Committee Meeting Report of November 7, 2017
1. That the General Committee meeting report of November 7, 2017, be received
and the following recommendations carried by the Committee be approved:
(C2) Finance Advisory Committee Meeting Minutes of September 27, 2017
1. That the Finance Advisory Committee meeting minutes of September 27,
2017, be received for information.
(C6) Finance Advisory Committee Meeting Minutes of October 12, 2017
1. That the Finance Advisory Committee meeting minutes of October 12,
2017, be received for information.
Carried
Extract from
Council Meeting of
Tuesday, November 14, 2017
Finance Advisory Committee Meeting Agenda
Wednesday, January 24, 2018
Item 5
Page 1 of 1