AGENDA-Finance Advisory Committee-20210119Town of Aurora
Finance Advisory Committee
Meeting Agenda
Date:Tuesday, January 19, 2021
Time:5:45 p.m.
Location:Video Conference
Pages
1.Procedural Notes
This meeting will be held electronically as per Section 19. i) of the Town's
Procedure By-law No. 6228-19, as amended, due to the COVID-19 situation.
2.Appointment of Committee Chair
That the Committee elect a Chair for year 2021 of the Finance Advisory
Committee (2018-2022 term).
3.Approval of the Agenda
4.Declarations of Pecuniary Interest and General Nature Thereof
5.Receipt of the Minutes
5.1.Finance Advisory Committee Meeting Minutes of December 8, 2020 1
That the Finance Advisory Committee meeting minutes of December 8,
2020, be received for information.
6.Delegations
Note: At this time, the Municipal Offices are closed. This meeting will be live
streamed at https://www.youtube.com/user/Townofaurora2012/videos.
Anyone wishing to provide comment on an agenda item is encouraged to visit
www.aurora.ca/participation for guidelines on electronic delegation.
7.Matters for Consideration
7.1.Memorandum from Manager, Financial Management; Re: Council
Administration and Office of the CAO Budget Materials
4
That the memorandum regarding Council Administration and
Office of the CAO Budget Materials be received; and
1.
That the comments and suggestions of the review of the
detailed financial information for Council Administration and the
Office of the CAO Budget Materials be received and referred to
staff for consideration and action as appropriate.
2.
7.2.Memorandum from Project Management Office; Re: Town’s Major
Capital Projects Update
14
That the memorandum regarding Town’s Major Capital Projects
Update be received for information.
1.
7.3.Memorandum from Manager, Financial Management; Re: 2021 Draft
Work Plan for the Finance Advisory Committee
21
That the memorandum regarding 2021 Draft Work Plan for the
Finance Advisory Committee be received; and
1.
That the 2021 Draft Work Plan for the Finance Advisory
Committee be approved.
2.
7.4.Memorandum from Manager, Financial Management; Re: Corporate
Revenues and Expenses Budget Materials
24
That the memorandum regarding Corporate Revenues and
Expenses Budget Materials be received; and
1.
That the detailed financial information for the Corporate
Revenues and Expenses be received and deferred for discussion
and detailed review at the next meeting of the Finance Advisory
Committee.
2.
8.New Business
9.Adjournment
1
Town of Aurora
Finance Advisory Committee
Meeting Minutes
Date:
Time:
Location:
Tuesday, December 8, 2020
6:00 p.m.
Video Conference
Committee Members: Councillor John Gallo (Chair)
Mayor Tom Mrakas
Councillor Michael Thompson
Other Attendees: Councillor Wendy Gaertner
Rachel Wainwright-van Kessel
Jason Gaertner, Manager, Financial Management
Tracy Evans, Advisor, Financial Management
Laura Sheardown, Advisor, Financial Management
Ishita Soneji, Council/Committee Coordinator
_____________________________________________________________________
1. Procedural Notes
This meeting was held electronically as per Section 19. i) of the Town's
Procedure By-law No. 6228-19, as amended, due to the COVID-19 situation.
The meeting time was changed to 6 p.m.
The Chair called the meeting to order at 6 p.m.
2. Approval of the Agenda
Moved by Councillor Thompson
Seconded by Mayor Mrakas
That the agenda as circulated by Legislative Services, be approved.
Carried
Page 1 of 29
2
3. 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.
4. Receipt of the Minutes
4.1 Finance Advisory Committee Meeting Minutes of November 26, 2020
Moved by Mayor Mrakas
Seconded by Councillor Thompson
1. That the Finance Advisory Committee meeting minutes of November
26, 2020, be received for information.
Carried
5. Delegations
None.
6. Matters for Consideration
6.1 Memorandum from Manager, Financial Management; Re: Department of
Finance Budget Materials
The Committee referred to the variances and loss of revenue in water to
taxes transfer fees and tax reminder notice fees due to the COVID-19
pandemic and inquired if similar losses are expected in 2021. Staff
provided a response noting that at this time there is no loss of revenue
forecasted for the upcoming year as it is assumed that all operations in
these areas will return to their normal practices. The Committee further
sought clarification regarding variance in year-end accruals and staff
provided clarification.
Moved by Mayor Mrakas
Seconded by Councillor Thompson
1. That the memorandum regarding the Department of Finance Budget
Materials be received; and
Page 2 of 29
3
2. That the comments and suggestions of the review of the detailed
financial information for the Department of Finance be received and
referred to staff for consideration and action as appropriate.
Carried
6.2 Memorandum from Manager, Financial Management; Re: Council
Administration and the Office of the CAO Budget Materials
Moved by Councillor Thompson
Seconded by Mayor Mrakas
1. That the memorandum regarding the Council Administration and the
Office of the CAO Budget Materials be received; and
2. That the detailed financial information for Council Administration and
the Office of the CAO be received and deferred for discussion and
detailed review at the next meeting of the Finance Advisory
Committee.
Carried
7. New Business
None.
8. Adjournment
Moved by Councillor Thompson
Seconded by Mayor Mrakas
That the meeting be adjourned at 6:08 p.m.
Carried
Page 3 of 29
100 John West Way
Aurora, Ontario
L4G 6J1
(905) 727-3123
aurora.ca
Town of Aurora
Memorandum
Finance
______________________________________________________________________
Re: Council Administration & Office of the CAO Budget Materials
To: Finance Advisory Committee
From: Jason Gaertner, Manager, Financial Management
Date: January 19, 2021
______________________________________________________________________
Recommendation
1. That the memorandum regarding the Council Administration & Office of the CAO
Budget Materials be received; and
2. That the comments and suggestions of the review of the detailed financial
information for Council Administration & the Office of the CAO Budget Materials be
received and referred to staff for consideration and action as appropriate.
Background
As per its budget process document, the Finance Advisory Committee is required to
undertake a detailed review of each department and community service partner’s core
operating budgets prior to the conclusion of the Council term. These detailed reviews
allow for a more strategic review of the Town’s draft operating budgets by the Budget
Committee. During the course of these detailed reviews any arising budget concern
areas can be explored and addressed as part of a future town budget process.
Attachments
1) Council Administration & Office of the CAO Detailed Budget Materials
Page 4 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE:3‐1201 OTHER‐‐ (35,043)‐‐(35,043)‐See divisional detail for variance explanations.Total Revenue‐‐ (35,043)‐‐(35,043)‐EXPENSE:4‐2000 SALARIES ‐ F/T443,554 501,226 461,386411,639 446,360(15,026)(3.4%)4‐2002 SALARIES ‐ P/T‐ 9,000‐‐‐‐‐4‐2090 YEAR END ACCRUALS1,518 (381) 4,1629,520 (1,401)(5,563)(397.1%)4‐2100 BENEFITS ‐ OMERS22,301 29,762 30,39120,996 27,220(3,171)(11.6%)4‐2101 BENEFITS ‐ EHT7,144 10,253 9,4698,027 9,027(442)(4.9%)4‐2102 BENEFITS ‐ WSIB61862964065264771.1%4‐2103 BENEFITS ‐ CPP9,652 15,195 14,55417,443 16,0681,5149.4%4‐2104 BENEFITS ‐ EI1,171 1,201 1,2041,250 1,236322.6%4‐2105 BENEFITS ‐ DENTAL3,655 3,328 1,7363,320 3,5061,77050.5%4‐2106 BENEFITS ‐ HEALTH6,250 5,974 5,9375,700 6,1772403.9%4‐2107 BENEFITS ‐ LTD/ADD1,538 1,853 1,9202,030 2,16024011.1%4‐2108 BENEFITS ‐ OTHER717905839840912738.0%4‐2200 WAGE RECOVERY(62,888) (63,219) (65,766)‐ (65,000)7661.2%TOTAL SALARIES & BENEFITS435,230 515,726 466,472 481,417 446,912(19,560)(4.4%)4‐4000 OFFICE SUPPLIES1,839 1,286 1,9431,900 1,737(206)(11.9%)4‐4004 SUBSCRIPTIONS/PUBLICATIONS1,838982‐600‐‐‐4‐4006 OFFICE EQUIPMENT633102 1,010200 2,6021,59261.2%4‐4045 MUNICIPAL BUSINESS2,927 3,008 4,4175,000 4,267(150)(3.5%)4‐5000 SPECIAL FUNCTIONS1,391 3,384 15,1226,000 3,970(11,152)(280.9%)4‐5001 CONFERENCES17,492 14,570 40,87021,000 ‐(40,870)‐4‐5003 FCM/AMO BOARD MEETINGS5,470660‐‐‐‐‐4‐5021 MOBILE PLAN CHARGES‐‐ 9,6605,446 4,996(4,664)(93.4%)4‐5026 COURSES & SEMINARS‐27380200200(180)(90.0%)4‐5028 MEMBERSHIPS10,659 11,398 13,86110,200 12,649(1,212)(9.6%)4‐5029 MILEAGE33620150‐‐(50)‐4‐5030 VEHICLE ALLOWANCE23,261 23,613 20,49821,115 21,0015032.4%4‐5042 ADVERTISING1,9687764632,000 2,0001,53776.9%4‐5045 PHOTOCOPIER CHARGES2,289 2,123 3,0652,798 3,68562016.8%4‐5091 CIVIC RESPONSIBILITIES12,932 12,093 11,94810,000 8,703(3,245)(37.3%)4‐5999 INTERNAL GRANTS16,636 13,340‐5,000121121100.0%4‐7002 EDUCATION GRANTS4,000 4,000‐4,000 4,0004,000100.0%TOTAL OTHER EXPENSES103,671 91,563 123,287 95,459 69,931(53,356)(76.3%)TOTAL EXPENSES538,901 607,289 589,759 576,876 516,843(72,916)(14.1%)NET BUDGET538,901 607,289 554,716 576,876 516,843(37,873)(7.3%)+/‐ $20,000 AND +/‐ 10% ChangeCouncil ConsolidationAttachment 1Page 5 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1201 OTHER‐ ‐ (35,043)‐‐(35,043) ‐Reflects the net revenue collected from the Mayor's Charity Golf tournament in 2019. The 2020 event was cancelled as a result of COVID‐19.Total Revenue ‐ ‐ (35,043) ‐ ‐ (35,043) ‐ EXPENSE: 4‐2000 SALARIES ‐ F/T443,554 501,226 461,386411,639 446,360(15,026)(3.4%) 4‐2002 SALARIES ‐ P/T‐ 9,000 ‐‐‐‐‐ 4‐2090 YEAR END ACCRUALS1,518 (381) 4,1629,520 (1,401)(5,563)(397.1%) 4‐2100 BENEFITS ‐ OMERS22,301 29,762 30,39120,996 27,220(3,171)(11.6%) 4‐2101 BENEFITS ‐ EHT7,144 10,253 9,4698,027 9,027(442)(4.9%) 4‐2102 BENEFITS ‐ WSIB618 629 640652 64771.1% 4‐2103 BENEFITS ‐ CPP9,652 15,195 14,55417,443 16,0681,5149.4% 4‐2104 BENEFITS ‐ EI1,171 1,201 1,2041,250 1,236322.6% 4‐2105 BENEFITS ‐ DENTAL3,655 3,328 1,7363,320 3,5061,77050.5% 4‐2106 BENEFITS ‐ HEALTH6,250 5,974 5,9375,700 6,1772403.9% 4‐2107 BENEFITS ‐ LTD/ADD1,538 1,853 1,9202,030 2,16024011.1% 4‐2108 BENEFITS ‐ OTHER717 905 839840 912738.0% 4‐2200 WAGE RECOVERY(62,888) (63,219) (65,766)‐ (65,000)7661.2%TOTAL SALARIES & BENEFITS 435,230 515,726 466,472 481,417 446,912 (19,560) (4.4%) 4‐4000 OFFICE SUPPLIES1,839 1,286 1,9431,900 1,737(206)(11.9%) 4‐4004 SUBSCRIPTIONS/PUBLICATIONS1,838 982 ‐600 ‐‐‐ 4‐4006 OFFICE EQUIPMENT633 102 1,010200 2,6021,59261.2% 4‐4045 MUNICIPAL BUSINESS1,562 1,107 3,2492,000 518(2,731)(527.2%) 4‐5000 SPECIAL FUNCTIONS1,391 3,384 15,1226,000 3,970(11,152)(280.9%) 4‐5001 CONFERENCES17,492 14,570 40,87021,000 ‐(40,870)‐ 4‐5003 FCM/AMO BOARD MEETINGS5,470 660 ‐‐‐‐‐ 4‐5021 MOBILE PLAN CHARGES‐ ‐ 9,6605,446 4,996(4,664)(93.4%) 4‐5026 COURSES & SEMINARS‐ 27 380200 200(180)(90.0%) 4‐5028 MEMBERSHIPS10,659 11,398 12,33410,200 12,6493152.5% 4‐5029 MILEAGE336 201 50‐‐(50)‐ 4‐5030 VEHICLE ALLOWANCE23,261 23,613 20,49821,115 21,0015032.4% 4‐5042 ADVERTISING1,968 776 4632,000 2,0001,53776.9% 4‐5045 PHOTOCOPIER CHARGES2,289 2,123 3,0652,798 3,68562016.8% 4‐5091 CIVIC RESPONSIBILITIES12,932 12,093 11,94810,000 8,703(3,245)(37.3%) TOTAL OTHER EXPENSES 81,670 72,322 120,592 83,459 62,061 (58,531) (94.3%) TOTAL EXPENSES 516,900 588,048 587,064 564,876 508,973 (78,091) (15.3%) +/‐ $20,000 AND +/‐ 10% ChangeCouncil AdministrationPage 6 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)+/‐ $20,000 AND +/‐ 10% ChangeCouncil Administration NET BUDGET 516,900 588,048 552,021 564,876 508,973 (43,048) (8.5%) Page 7 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: Total Revenue ‐‐‐‐‐ ‐ ‐ EXPENSE: TOTAL SALARIES & BENEFITS ‐‐‐‐‐ ‐ ‐ 4‐4045 MUNICIPAL BUSINESS1,365 1,900 1,1683,000 3,7492,58168.8% 4‐5028 MEMBERSHIPS‐ ‐ 1,526‐‐(1,526) ‐ 4‐5999 INTERNAL GRANTS16,636 13,340 ‐5,000 121121100.0% 4‐7002 EDUCATION GRANTS4,000 4,000 ‐4,000 4,0004,000100.0% TOTAL OTHER EXPENSES 22,001 19,240 2,694 12,000 7,870 5,176 65.8% TOTAL EXPENSES 22,001 19,240 2,694 12,000 7,870 5,176 65.8% NET BUDGET 22,001 19,240 2,694 12,000 7,870 5,176 65.8% +/‐ $20,000 AND +/‐ 10% ChangeTown Committees & GrantsPage 8 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1202 GENERAL(377) (474) (127)(300) (309)18258.9% Total Revenue (377) (474) (127) (300) (309) 182 58.9% EXPENSE: 4‐2000 SALARIES ‐ F/T640,170 670,037 680,617854,446 820,345139,72817.0%See divisional detail for variance explanations.4‐2001 SALARIES ‐ O/T248 ‐ ‐‐‐‐‐ 4‐2002 SALARIES ‐ P/T9,134 44,076 79,1039,916 9,705(69,398)(715.1%)See divisional detail for variance explanations.4‐2090 YEAR END ACCRUALS1,253 14,384 4,376‐ (20,123)(24,499)(121.7%)See divisional detail for variance explanations.4‐2100 BENEFITS ‐ OMERS74,805 75,989 81,27390,124 86,9075,6346.5% 4‐2101 BENEFITS ‐ EHT12,932 14,128 14,98015,265 14,667(313)(2.1%) 4‐2102 BENEFITS ‐ WSIB3,855 3,979 4,2865,871 5,06978315.4% 4‐2103 BENEFITS ‐ CPP18,743 18,576 21,01019,290 18,877(2,133)(11.3%) 4‐2104 BENEFITS ‐ EI8,756 8,721 9,1018,996 8,221(880)(10.7%) 4‐2105 BENEFITS ‐ DENTAL8,422 8,873 10,68111,621 11,8661,18510.0% 4‐2106 BENEFITS ‐ HEALTH18,008 17,461 18,87919,951 20,0491,1705.8% 4‐2107 BENEFITS ‐ LTD/ADD9,739 11,741 13,20518,067 16,1882,98318.4% 4‐2108 BENEFITS ‐ OTHER2,938 3,244 3,3003,448 3,67337310.2% 4‐2201 SALARY SAVINGS‐‐‐(6,042) ‐‐‐ TOTAL SALARIES & BENEFITS 809,003 891,209 940,811 1,050,953 995,444 54,633 5.5% 4‐3000 PURCHASE CARD CLEARING1,036 54 ‐‐ 5,7115,711100.0% 4‐4000 OFFICE SUPPLIES2,077 1,259 1,9741,800 1,525(449)(29.4%) 4‐4002 RECEPTIONS3,038 ‐ ‐5,000 2,5002,500100.0% 4‐4004 SUBSCRIPTIONS/PUBLICATIONS16,264 41,679 54,75231,000 29,276(25,476)(87.0%)See divisional detail for variance explanations.4‐4006 OFFICE EQUIPMENT7,763 3,513 1,8597,000 5,0003,14162.8% 4‐4044 STAFF INITIATIVES4,452 6,514 6,5896,000 4,500(2,089)(46.4%) 4‐4045 MUNICIPAL BUSINESS8,076 8,153 13,0353,550 3,846(9,189)(238.9%) 4‐4046 WEB SITE MANAGEMENT10,513 15,628 41,50710,000 10,000(31,507)(315.1%)See divisional detail for variance explanations.4‐5021 MOBILE PLAN CHARGES‐ ‐ 5,5634,297 8,5713,00835.1% 4‐5026 COURSES & SEMINARS12,684 12,809 9,0997,100 3,501(5,598)(159.9%) 4‐5028 MEMBERSHIPS1,906 1,673 1,5335,800 4,7033,17067.4% 4‐5029 MILEAGE3,075 2,222 3651,100 1,18481969.2% 4‐5030 VEHICLE ALLOWANCE8,400 8,400 8,40011,700 8,399‐‐ 4‐5031 GENERAL OFFICE EQUIPMENT1,688 ‐ ‐1,300 ‐‐‐ 4‐5042 ADVERTISING104,043 113,738 95,372111,000 106,54611,17410.5% 4‐5043 CONSULTING29,354 40,412 61,50386,600 83,87622,37326.7%See divisional detail for variance explanations.4‐5045 PHOTOCOPIER CHARGES3,554 2,769 4,5823,826 5,56698417.7% 4‐5059 CONTRACTS21,475 842 86314,500 14,50013,63794.0% 4‐5060 COST RECOVERY‐‐‐(81,000) (81,000)(81,000)(100.0%)See divisional detail for variance explanations.4‐5076 PRINTING ‐ ADVERTISING1,803 6,044 5,4095,000 2,858(2,551)(89.3%) +/‐ $20,000 AND +/‐ 10% ChangeConsolidation Office of the CAOPage 9 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)+/‐ $20,000 AND +/‐ 10% ChangeConsolidation Office of the CAO4‐5092 EVENTS AND PROMOTIONS15,775 9,542 38,66530,000 22,545(16,120)(71.5%) 4‐5999 INTERNAL GRANTS‐ ‐ 21,22757,600 23,7562,52910.6% TOTAL OTHER EXPENSES 256,976 275,251 372,297 323,173 267,363 (104,934) (39.2%) TOTAL EXPENSES 1,065,979 1,166,460 1,313,108 1,374,126 1,262,807 (50,301) (4.0%) NET BUDGET 1,065,602 1,165,986 1,312,981 1,373,826 1,262,498 (50,483)(4.0%) Page 10 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: Total Revenue ‐‐‐‐‐ ‐ ‐ EXPENSE: 4‐2000 SALARIES ‐ F/T294,218 326,517 336,732344,278 341,0284,2961.3% 4‐2090 YEAR END ACCRUALS4,195 8,649 2,523‐ (9,114)(11,637)(127.7%)This variance relates to how many days are accrued at fiscal year end; the required accrual varies each year.4‐2100 BENEFITS ‐ OMERS38,206 39,957 44,20743,751 44,199(8)‐ 4‐2101 BENEFITS ‐ EHT5,930 6,563 6,7626,714 6,778160.2% 4‐2102 BENEFITS ‐ WSIB1,282 1,306 1,3352,582 2,03469934.4% 4‐2103 BENEFITS ‐ CPP5,128 5,188 5,4985,412 5,7252274.0% 4‐2104 BENEFITS ‐ EI2,341 2,403 2,4092,500 2,435261.1% 4‐2105 BENEFITS ‐ DENTAL3,655 3,473 3,4733,320 3,6501774.8% 4‐2106 BENEFITS ‐ HEALTH6,250 5,974 5,9375,700 6,1772403.9% 4‐2107 BENEFITS ‐ LTD/ADD3,491 4,164 4,2688,042 6,0171,74929.1% 4‐2108 BENEFITS ‐ OTHER1,367 1,510 1,5331,535 1,6671348.0% 4‐2201 SALARY SAVINGS‐‐‐(6,042) ‐‐‐ TOTAL SALARIES & BENEFITS 366,063 405,704 414,677 417,792 410,596 (4,081) (1.0%) 4‐3000 PURCHASE CARD CLEARING1,036 54 ‐‐ 5,7115,711100.0% 4‐4000 OFFICE SUPPLIES1,317 793 1,1491,300 1,40125218.0% 4‐4002 RECEPTIONS3,038 ‐ ‐5,000 2,5002,500100.0% 4‐4004 SUBSCRIPTIONS/PUBLICATIONS839 553 1,0081,000 128(880)(687.5%) 4‐4044 STAFF INITIATIVES4,452 6,514 6,5896,000 4,500(2,089)(46.4%) 4‐4045 MUNICIPAL BUSINESS7,492 7,630 12,5233,100 3,787(8,736)(230.7%) 4‐5021 MOBILE PLAN CHARGES‐ ‐ 3,1801,575 5,3742,19440.8% 4‐5026 COURSES & SEMINARS12,338 6,965 7,3426,100 2,501(4,841)(193.6%) 4‐5028 MEMBERSHIPS1,881 1,394 1,5334,800 3,7032,17058.6% 4‐5029 MILEAGE2,613 1,464 167100 68451775.6% 4‐5030 VEHICLE ALLOWANCE8,400 8,400 8,40011,700 8,399(1)‐ 4‐5031 GENERAL OFFICE EQUIPMENT1,688 ‐ ‐1,300 ‐‐‐ 4‐5043 CONSULTING29,354 40,412 61,50386,600 83,87622,37326.7%Full consulting budget was not spent in 2019.4‐5045 PHOTOCOPIER CHARGES3,554 2,769 4,5823,826 5,56698417.7% 4‐5059 CONTRACTS21,475 842 86314,500 14,50013,63794.0% TOTAL OTHER EXPENSES 99,477 77,790 108,839 146,901 142,630 33,791 23.7% TOTAL EXPENSES 465,540 483,494 523,516 564,693 553,226 29,710 5.4% NET BUDGET 465,540 483,494 523,516 564,693 553,226 29,710 5.4% +/‐ $20,000 AND +/‐ 10% ChangeOffice of the CAOPage 11 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1202 GENERAL(377) (474) (127)(300) (309)18258.9% Total Revenue (377) (474) (127) (300) (309) 182 58.9% EXPENSE: 4‐2000 SALARIES ‐ F/T345,952 343,520 343,886510,167 479,317135,43128.3%Staff vacancies.4‐2001 SALARIES ‐ O/T248 ‐ ‐‐‐‐‐ 4‐2002 SALARIES ‐ P/T9,134 44,076 79,1039,916 9,705(69,398)(715.1%)Part‐time position to cover maternity leave in 2019, which is offset by savings in full‐time line.4‐2090 YEAR END ACCRUALS(2,942) 5,735 1,853‐ (11,009)(12,862)(116.8%)This variance relates to how many days are accrued at fiscal year end; the required accrual varies each year.4‐2100 BENEFITS ‐ OMERS36,598 36,031 37,06646,374 42,7085,64213.2% 4‐2101 BENEFITS ‐ EHT7,002 7,565 8,2178,552 7,889(328)(4.2%) 4‐2102 BENEFITS ‐ WSIB2,573 2,673 2,9513,289 3,034832.7% 4‐2103 BENEFITS ‐ CPP13,615 13,388 15,51213,878 13,152(2,360)(17.9%) 4‐2104 BENEFITS ‐ EI6,415 6,318 6,6926,496 5,787(905)(15.6%) 4‐2105 BENEFITS ‐ DENTAL4,767 5,400 7,2088,301 8,2161,00812.3% 4‐2106 BENEFITS ‐ HEALTH11,758 11,488 12,94214,251 13,8729306.7% 4‐2107 BENEFITS ‐ LTD/ADD6,247 7,577 8,93610,025 10,1711,23512.1% 4‐2108 BENEFITS ‐ OTHER1,571 1,734 1,7671,913 2,00623911.9% TOTAL SALARIES & BENEFITS 442,938 485,505 526,133 633,162 584,848 58,715 10.0% 4‐4000 OFFICE SUPPLIES760 466 825500 124(701)(565.3%) 4‐4004 SUBSCRIPTIONS/PUBLICATIONS15,425 41,126 53,74430,000 29,148(24,596)(84.4%)Online community consultation tool cost higher than budgeted.4‐4006 OFFICE EQUIPMENT7,763 3,513 1,8597,000 5,0003,14162.8% 4‐4045 MUNICIPAL BUSINESS584 523 511450 59(452)(766.1%) 4‐4046 WEB SITE MANAGEMENT10,513 15,628 41,50710,000 10,000(31,507)(315.1%)Variance relates to higher expenses in 2019 due to an update of the Town's website.4‐5021 MOBILE PLAN CHARGES‐ ‐ 2,3832,722 3,19781425.5% 4‐5026 COURSES & SEMINARS346 5,845 1,7571,000 1,000(757)(75.7%) 4‐5028 MEMBERSHIPS25 279 ‐1,000 1,0001,000100.0% 4‐5029 MILEAGE463 758 1981,000 50030260.4% 4‐5042 ADVERTISING104,043 113,738 95,372111,000 106,54611,17410.5% 4‐5060 COST RECOVERY‐‐‐(81,000) (81,000)(81,000)(100.0%)Cost recovery is new for 2020. It relates to Library Square funding capital project funding of new contract Graphic Designer position.4‐5076 PRINTING ‐ ADVERTISING1,803 6,044 5,4095,000 2,858(2,551)(89.3%) 4‐5092 EVENTS AND PROMOTIONS15,775 9,542 38,66530,000 22,545(16,120)(71.5%) 4‐5999 INTERNAL GRANTS‐ ‐ 21,22757,600 23,7562,52910.6% TOTAL OTHER EXPENSES 157,500 197,462 263,457 176,272 124,733 (138,724) (111.2%) TOTAL EXPENSES 600,438 682,967 789,590 809,434 709,581 (80,009) (11.3%) +/‐ $20,000 AND +/‐ 10% ChangeCorporate CommunicationsPage 12 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)+/‐ $20,000 AND +/‐ 10% ChangeCorporate Communications NET BUDGET 600,061 682,493 789,463 809,134 709,272 (80,191) (11.3%) Page 13 of 29
100 John West Way
Aurora, Ontario
L4G 6J1
(905) 727-3123
aurora.ca
Town of Aurora
Memorandum
Corporate Services
______________________________________________________________________
Re: Town’s Major Capital Projects Update
To: Finance Advisory Committee
From: Lianne Jalali, Project Management Office, Corporate Services
Date: January 19, 2021
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
Fire Hall 4-5
Joint Operations Centre Additional Work
Analysis
Library Square
The project is generally on track. Chandos Construction Ltd. have continued demolition
and excavation works throughout the site and continue to maintain all hoarding, fencing
and site entrances. Parking improvement work has been completed off Victoria &
Church street with concrete curbs and asphalt basecoat being installed for additional
lay-by parking. The interim grading solution at the north Library laneway has been
completed providing accessible ingress and egress at the north elevation of the Library,
while the main east and west tower entrances are enclosed and demolished.
Page 14 of 29
Town’s Major Capital Projects Update
January 19, 2021 2 of 6
Project Schedule:
Chandos developed four separate construction schedules related to the Performing
Arts Addition, Pedestrian Bridge, Library Renovations and Library Square development.
Chandos is now reflecting roughly a 2 month delay of works for the Library, Performing
Arts Addition and Pedestrian Bridge due to the unforeseen delays with existing site and
Library infrastructure (Enbridge gas, Yorknet & Bell Fibre lines, and Library tower and
interior demolition works), however the targeted Substantial Performance date of
August 16th, 2022 currently remains intact.
Milestone Baselined
Completion
Expected
Completion Status
Library Renovation September 2021 September 2021 In progress
Performing Arts
Building Addition October 2022 October 2022 In progress
Pedestrian Bridge February 2022 February 2022 Not started
Library Square August 2022 August 2022 Not started
Substantial
Performance August 2022 August 2022 Not started
Occupancy August 2022 August 2022 Not started
Total Completion November 2022 November 2022 Not started
Budget Status:
The project budget has been baselined for $51,939,700 (including HST). Chandos’
contract price excluding Cash Allowances is $39,394,615. The Cash Allowance amount
of $1,615,250 will be tracked separately as the various areas of scope are implemented
throughout the Construction process. Currently there are eleven (11) Contemplated
Change Notices (CCNs) issued by RAW and TPP, any potential costs for these will be
drawn from the construction contingency.
Page 15 of 29
Town’s Major Capital Projects Update
January 19, 2021 3 of 6
Description Total Budget Committed
Forecast Cost at
Completion
Forecast
Variance at
Completion
Consultant Fees $4,750,272 $4,695,834 $4,750,272 $0
Construction
Costs
$41,009,865 $41,009,865 $41,009,865 $0
Town
Allowances
$1,280,735 $368,221 $1,280,735 $0
Contingencies $4,000,500 $0 $4,000,500 $0
HST $898,328 $819,901 $898,328 $0
Total $51,939,700 $46,884,810 $51,939,700 $0
The overall status update for this project can be found under Attachment #1.
Fire Hall 4-5
Overall progress of the project is satisfactory.
Building: Helical Pier installation are completed. The installation of the foundation is at
80% completion.
Site work: One permeable paver area is completed. Overall permeable paver installation
is at 15% completion. Subbase of asphalt is at 10% completion.
Service connections: Storm, sanitary and water servicing to the site are completed.
Remo has already submitted a request for the Electrical Panels to Alectra. Enbridge is
currently processing the application for the gas meter connection.
Project Schedule:
Milestone Baselined Completion Expected Completion
Occupancy February 28, 2022 February 28, 2022
Substantial Performance March 8, 2022 March 8, 2022
Page 16 of 29
Town’s Major Capital Projects Update
January 19, 2021 4 of 6
Milestone Baselined Completion Expected Completion
Total Completion May 25, 2022 May 25, 2022
Budget Status:
Non-Construction
Costs Approved Budget
Change Orders
Approved to
Date Payments to Date
Architect $600,000 $528,247.00
Furniture, Fixture,
Signage etc.
$506,500 $0
Prefab shed for
training
$250,000 $0
Allowance for props $100,000 $0
Total $1,456,500 $528,247.00
Construction Costs
Tender Revised Bid $10,836,817 $2,349,615.00
Non-Recoverable HST
(1.76%)
$190,728 $0
Contingency (10%) $1,083,682 $759,778.14
Total $13,567,727 $2,349,615.00
Currently there are four (4) Change Orders have been approved. The total amount of the
approved Change Orders is $759,778.14 that has been drawn from the construction
contingency.
Page 17 of 29
Town’s Major Capital Projects Update
January 19, 2021 5 of 6
Risks and issues:
The installation of the foundation and steel structure progress may be impacted by
winter weather.
The overall 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. The following table reflects the
status of each sub-project.
Sub-Project Status
Back Lot Paving and Full Build Out Complete
Upper Parking Lot and Rear Yard Complete
JOC Landscaping In progress – Completion in Spring 2021
Garbage Tipping Station Complete
Storage Buildings In progress – Completion in Summer 2021
Automated Gate Control Complete
South Side Exterior Finishing Complete
Furniture Complete
Entry Pylon Exterior Sign This is a part of the Exterior Pylon Sign project
for the Town’s facilities
Intercom System Cancelled
Third Floor Build Out Complete
Building Exterior Sign Complete
Soil Quality at Back of Property Complete
Page 18 of 29
Town’s Major Capital Projects Update
January 19, 2021 6 of 6
Budget Status:
Budget Status Cost Note
Approved Budget $2,185,200
Committed $1,431,086 65% project budget
The overall status update for this project can be found under Attachment #1.
Attachment
Attachment #1 – Major Capital Project Update:
Library Square
Fire Hall 4-5
Joint Operations Centre Additional Work
Page 19 of 29
PROJECT NAME BEGIN FINISH (Total Completion)# of DAYS STATUS PROJECTED COMMITTED REMAINDER STATUS
Firehall May 20, 2020 May 25, 2022 735 On schedule $13,567,727 $2,349,615 $11,218,112 On budgetJOC - Additional October 1, 2018 September 30, 2021 1095 On schedule $2,185,200 $1,431,086 $754,114 On budgetLibrary Square July 2, 2018 November 30, 2022 1612 On schedule $51,939,489 $46,884,810 $5,054,679 On budgetTotal $67,692,416 $50,665,511 $17,026,905
Project 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 budgetMajor problems affected the project timeline and budget. The sponsor's intervention is required in this case
Row Labels Sum of REMAINDER Sum of PROJECTED Sum of COMMITTED Firehall 11218112 13567727 2349615Library Square 5054679 51939489 46884810
JOC - Additional Work 827198 2185200 1358002Grand Total 17099989 67692416 50592427
Attachement#1Major Capital Projects Update Summary - January 2021
Timeline BUDGET
$0
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
Firehall Library Square JOC - Additional Work
Project Budget Summary
Sum of REMAINDER
Sum of PROJECTED
Sum of COMMITTED
Values
PROJECT NAME
Page 20 of 29
100 John West Way
Aurora, Ontario
L4G 6J1
(905) 727-3123
aurora.ca
Town of Aurora
Memorandum
Finance
______________________________________________________________________
Re: 2021 Draft Work Plan for the Finance Advisory Committee
To: Finance Advisory Committee
From: Jason Gaertner, Manager, Financial Management
Date: January 19, 2021
______________________________________________________________________
Recommendation
1. That the memorandum regarding 2021 Draft Work Plan for the Finance Advisory
Committee be received; and
2. That the 2021 Draft Work Plan for the Finance Advisory Committee be approved.
Background
In support of its mandate, the Finance Advisory Committee develops an annual work
plan outlining its key deliverables and the timing for their completion.
Attachments
1) 2021 Draft Work Plan for the Finance Advisory Committee
Page 21 of 29
As of January 19, 2021
2021 Draft Work Plan for the Finance Advisory Committee
(All meetings currently scheduled for Tuesdays at 5:45 p.m.)
January 19, 2021
•Detailed Budget Review: Council Administration & the Office of the CAO (45
minutes)
•Major Project Update
•Receipt of Corporate Revenues & Expenses materials (review at next meeting)
o Identification of specific areas of focus for Corporate Revenues &
Expenses, if any
February 9, 2021
•Detailed Budget Review: Corporate Revenues & Expenses (45 minutes)
•Audit plan update #1
•Major Project Update
March 9, 2021
•Summary of FAC Accomplishments in 2019 to 2020
•Council 2022 Budget Direction
•Major Project Update
April 13, 2021
•Introduction to Town’s draft Fiscal Strategy
•Major Project Update
May 11, 2021
•Status update on ERP Financial Solution Implementation
•Major Project Update
June 8, 2021
•Introduction to the Town’s 2nd Generation Asset Management Plan
•Major Project Update
September 14, 2021
•Audit plan Update #2
•Major Project Update
Attachment 1
Page 22 of 29
As of January 19, 2021
October 12, 2021
•2022 Draft Budget Introduction
•Procurement Modernization Update
•Major Project Update
November 9, 2021
•If Required
December 7, 2021
•Fiscal Strategy Implementation Update
•Major Project Update
Page 23 of 29
100 John West Way
Aurora, Ontario
L4G 6J1
(905) 727-3123
aurora.ca
Town of Aurora
Memorandum
Finance
______________________________________________________________________
Re: Corporate Revenues & Expenses Budget Materials
To: Finance Advisory Committee
From: Jason Gaertner, Manager, Financial Management
Date: January 19, 2021
______________________________________________________________________
Recommendation
1. That the memorandum regarding Corporate Revenues & Expenses Budget Materials
be received; and
2. That the detailed financial information for the Corporate Revenues & Expenses be
received and deferred for discussion and detailed review at the next meeting of the
Finance Advisory Committee.
Background
As per its budget process document, the Finance Advisory Committee is required to
undertake a detailed review of each department and community service partner’s core
operating budgets prior to the conclusion of the Council term. These detailed reviews
allow for a more strategic review of the Town’s draft operating budgets by the Budget
Committee. During the course of these detailed reviews, any arising budget concern
areas can be explored and addressed as part of a future Town budget process.
Attachments
1) Corporate Revenues & Expenses Detailed Budget Materials
Page 24 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE:3‐1201 OTHER‐ (100,227) (532,809)‐ (12,430)(520,379) (4,186.5%)3‐1332 LEASES(7,250) (3,000) (13,500)(1,000) (5,700)(7,800) (136.8%)3‐1400 PENALTIES ON TAXES(970,839) (1,188,360) (1,444,127)(1,395,274) (1,086,174) (357,953) (33.0%)3‐1401 INVESTMENT INCOME(1,550,035) (1,600,000) (1,600,000)(1,600,000) (1,450,000) (150,000) (10.3%)3‐1402 INTEREST FROM HYDRO PROCEEDS(100,000)‐‐‐‐‐‐3‐1800 FEDERAL GRANTS‐‐ (1,002)‐‐(1,002)‐3‐1801 PROVINCIAL GRANTS(481,917) (2,030,106) (1,171,712)(1,261,500) (2,674,783) 1,503,071 56.2%3‐1803 OTHER GRANTS(1,646,176) (1,694,566) (3,408,119)(1,694,600) (1,694,600) (1,713,519) (101.1%)3‐1901 CONTRIBUTION FROM DISCRETIONARY RESER(58,480) (343,352) (222,100)‐‐(222,100) ‐3‐1929 TAX RATE STABILIZATION CONTRIBUTION(84,277) (569,900) (131,900)‐‐(131,900) ‐3‐1932 WORKERS COMPENSATION CONTRIBUTION(106,280) (105,731) (115,129)(105,000) (127,000)11,871 9.3%3‐1963 PARKS DEV & FAC DC CONT'N‐‐ (260,700)(260,700) (260,700)‐‐3‐1964 INDOOR REC DC CONT'N(320,543) (320,543) (320,500)(320,500) (320,500)‐‐3‐1965 LIBRARY DC CONT'N(289,500) (289,500) (289,500)(289,500) (289,500)‐‐3‐1967 ROADS & RELATED DC CONT'N‐‐ (375,300)(375,300) (375,300)‐‐Total Revenue(5,615,297) (8,245,285) (9,886,398) (7,303,374) (8,296,687)(1,589,711)(19.2%)EXPENSE:4‐2000 SALARIES ‐ F/T58,480 1,895 229,035197,381 202,050(26,985) (13.4%)4‐2005 LIEU TIME‐‐‐‐‐‐‐4‐2105 BENEFITS ‐ DENTAL13,708 12,001 34,90117,763 23,117(11,784) (51.0%)4‐2106 BENEFITS ‐ HEALTH23,492 20,003 49,01030,365 38,921(10,089) (25.9%)4‐2200 WAGE RECOVERY23,190‐‐‐‐‐‐TOTAL SALARIES & BENEFITS118,870 33,899 312,946 245,509 264,088(48,858)(18.5%)4‐4028 COST REALLOCATIONS(453,800) (1,629,700) (1,815,200)(2,050,312) (2,050,312)(235,112) (11.5%)4‐5048 AUDIT FEES63,512 77,110 (16,196)40,900 63,10079,296 125.7%4‐5059 CONTRACTS‐ 14,035‐‐‐‐‐4‐5068 OPERATING CONTINGENCIES3,840 31,436 8,10110,000 20,20012,099 59.9%4‐5903 WSIB CLAIMS COSTS106,280 105,731 115,129105,000 127,00011,871 9.3%4‐6000 CAPITAL LOAN REPAYMENT318,144 636,026 728,9191,209,500 753,56724,648 3.3%4‐6001 BANK CHARGES‐‐ 222,659‐ 202,933(19,726)(9.7%)4‐8002 CONTRIBUTIONS TO CAPITAL4,837,800 5,053,400 5,263,9005,700,200 5,700,200436,300 7.7%4‐8003 CONTRIBUTIONS TO DISCRETIONARY RESERVE625,443 2,790,797 2,882,443519,442 2,249,106(633,337) (28.2%)4‐8004 CONTRIBUTIONS TO OBLIGATORY RESERVES2,128,093 2,480,176 3,408,1192,795,700 2,795,700(612,419) (21.9%)TOTAL OTHER EXPENSES7,629,312 9,559,011 10,797,874 8,330,430 9,861,494(936,380)(9.5%)TOTAL EXPENSES7,748,182 9,592,910 11,110,820 8,575,939 10,125,582(985,238)(9.7%)NET BUDGET2,132,885 1,347,625 1,224,422 1,272,565 1,828,895604,47333.1%+/‐ $20,000 AND +/‐ 10% ChangeCorporate Revenues & ExpensesAttachment 1Page 25 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1411 RESIDENTIAL TAX CLASS(35,564,546) (37,819,888) (40,610,248)(50,104,475) (43,204,457)2,594,209 6.0% 3‐1412 MULTI‐RESIDENTIAL TAX CLASS(396,468) (390,072) (390,635)‐ (403,464)12,829 3.2% 3‐1413 COMMERCIAL TAX CLASS(2,479,776) (2,468,460) (2,497,966)‐ (2,595,516)97,550 3.8% 3‐1414 COMMERCIAL EXCESS LAND TAX CLASS(30,367) (27,587) (28,291)‐ (30,726)2,435 7.9% 3‐1415 COMMERCIAL VACANT LAND TAX CLASS(130,124) (95,238) (82,681)‐ (80,425)(2,256) (2.8%) 3‐1416 SHOPPING CENTRE TAX CLASS(417,406) (515,931) (576,733)‐ (617,030)40,297 6.5% 3‐1417 SHOPPING CENTRE EXCESS LAND TAX CLASS(745) (763) (1,045)‐ (1,161)116 10.0% 3‐1419 INDUSTRIAL TAX CLASS(432,352) (442,537) (443,539)‐ (457,029)13,490 3.0% 3‐1420 INDUSTRIAL EXCESS LAND TAX CLASS(19,278) (18,513) (18,822)‐ (19,205)383 2.0% 3‐1421 INDUSTRIAL VACANT LAND TAX CLASS(207,815) (238,830) (243,785)‐ (283,810)40,025 14.1% 3‐1423 INDUSTRIAL (SHARED LIKE PIL) TAX CLASS(5,786) (5,974) (6,171)‐ (6,393)222 3.5% 3‐1424 LARGE INDUSTRIAL TAX CLASS(279,709) (285,726) (292,866)‐ (300,427)7,561 2.5% 3‐1427 PIPELINE TAX CLASS(39,716) (40,881) (40,889)‐ (40,808)(81) (0.2%) 3‐1428 FARM TAX CLASS(10,893) (11,404) (11,440)‐ (11,984)544 4.5% 3‐1429 MANAGED FORESTS TAX CLASS(730) (726) (726)‐ (707)(19) (2.7%) 3‐1430 RAIL WAY RIGHT OF WAYS TAX CLASS(15,748) (15,811) (15,892)‐ (15,808)(84) (0.5%) 3‐1431 UTILITY TRANSMISSIONS/DISTRIBUTION TAX C(86,863) (86,950) (87,362)‐ (86,599)(763) (0.9%) 3‐1435 OFFICE BUILDINGS TAX CLASS(216,953) (217,920) (219,694)‐ (223,203)3,509 1.6% 3‐1436 OFFICE BUILDINGS EXCESS LAND TAX CLASS(12,619) (13,972) (15,359)‐ (16,883)1,524 9.0% 3‐1437 INDUSTRIAL (NEW CONSTRUCTION) TAX CLASS(45,206) (45,790) (70,870)‐ (73,122)2,252 3.1% 3‐1438 INDUSTRIAL (NEW CON) EXCESS LAND TX CLS(739) (751) (765)‐ (781)16 2.0% 3‐1443 COMMERCIAL (NEW CON) TAX CLASS(629,893) (705,778) (818,753)‐ (860,805)42,052 4.9% 3‐1444 COMMERCIAL (NEW CON) EXCESS LAND TX CL(15,533) (7,122) (17,781)‐ (8,997)(8,784) (97.6%) 3‐1446 OFFICE BLDG (NEW CON) TAX CLASS(6,314) (6,326) (6,362)‐ (6,455)93 1.4% 3‐1448 SHOPPING CTRE (NEW CON) TAX CLASS(637,683) (694,993) (724,232)‐ (731,965)7,733 1.1% 3‐1449 SHOPPING CTRE (NEW CON) EXCESS LND TX CL(3,102) (1,871) (1,611)‐ (3,116)1,505 48.3% 3‐1453 PARKING LOTS TAX CLASS(1,717) (4,445) (4,718)‐ (4,928)210 4.3% 3‐1454 COMMERCIAL C1 TAX CLASS‐ (10,880) (11,316)‐ (18,671)7,355 39.4% 3‐1455 BIA TAX LEVY‐ ‐ (40,412)(41,200) (41,200)788 1.9% Total Revenue (41,688,081) (44,175,139) (47,280,964) (50,145,675) (50,145,675) 2,864,711 5.7% EXPENSE: TOTAL SALARIES & BENEFITS ‐‐‐‐‐ ‐ ‐ 4‐9000 RESIDENTIAL TAX CLASS136,257 41,286 52,402280,000 254,183201,781 79.4% 4‐9002 COMMERCIAL TAX CLASS18,902 35,832 14,308‐‐(14,308) ‐ 4‐9003 COMMERCIAL EXCESS LAND TAX CLASS706 4,022 ‐‐‐‐‐ 4‐9004 COMMERCIAL VACANT LAND TAX CLASS174 34,645 44,826‐‐(44,826) ‐ 4‐9005 SHOPPING CENTRE TAX CLASS31,455 ‐ ‐‐‐‐‐ 4‐9006 SHOPPING CENTRE EXCESS LAND TAX CLASS7,504 ‐ ‐‐‐‐‐ +/‐ $20,000 AND +/‐ 10% ChangeRegular Tax RevenuesPage 26 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)+/‐ $20,000 AND +/‐ 10% ChangeRegular Tax Revenues4‐9008 INDUSTRIAL TAX CLASS775 5,100 ‐‐‐‐‐ 4‐9009 INDUSTRIAL EXCESS LAND TAX CLASS‐ 850 ‐‐‐‐‐ 4‐9010 INDUSTRIAL VACANT LAND TAX CLASS(841) ‐ ‐‐‐‐‐ 4‐9013 LARGE INDUSTRIAL TAX CLASS49,859 16,681 ‐‐‐‐‐ 4‐9017 FARM TAX CLASS3‐‐‐‐‐‐ 4‐9021 VACANCY TAX REBATES‐COMMERCIAL1,776 73,602 ‐‐‐‐‐ 4‐9022 VACANCY REBATES‐INDUSTRIAL‐ (550) ‐‐‐‐‐ 4‐9023 CHARITY REBATES21,634 25,952 25,118‐ 25,817699 2.7% 4‐9035 COMMERCIAL (NEW CONSTRUCTION) TAX CLA1,590 64,377 ‐‐‐‐‐ 4‐9036 COMM (NEW CON) EXCESS LAND TAX CLASS‐ (9,422) 3‐‐(3) ‐ 4‐9040 SHOP CTRE (NEW CON) TAX CLASS‐ 94,770 ‐‐‐‐‐ 4‐9041 SHOP CTRE (NEW CON) EXCESS LAND TAX‐ 300 20‐‐(20) ‐ 4‐9045 COMMERCIAL C1 TAX CLASS‐ (10,474) (21,064)‐‐21,064 ‐ TOTAL OTHER EXPENSES 269,794 376,971 115,613 280,000 280,000 164,387 58.7% TOTAL EXPENSES 269,794 376,971 115,613 280,000 280,000 164,387 58.7% NET BUDGET (41,418,287) (43,798,168) (47,165,351) (49,865,675) (49,865,675) (2,700,324) (5.4%) Page 27 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1411 RESIDENTIAL TAX CLASS(1,217) (1,299) (1,381)(348,000) (1,466)85 5.8% 3‐1413 COMMERCIAL TAX CLASS(258,352) (263,286) (311,992)‐ (317,763)5,771 1.8% 3‐1414 COMMERCIAL EXCESS LAND TAX CLASS(12,875) (13,044) (13,260)‐ (13,594)334 2.5% 3‐1421 INDUSTRIAL VACANT LAND TAX CLASS(355) (362) (369)‐ (4,637)4,268 92.0% 3‐1430 RAIL WAY RIGHT OF WAYS TAX CLASS(13,737) (13,951) (14,225)‐ (13,940)(285) (2.0%) Total Revenue (286,536) (291,942)(341,227) (348,000) (351,400) 10,1732.9% EXPENSE: TOTAL SALARIES & BENEFITS ‐‐‐‐‐ ‐ ‐ 4‐9002 COMMERCIAL TAX CLASS762 ‐ ‐‐‐‐‐ TOTAL OTHER EXPENSES 762‐‐‐‐ ‐ ‐ TOTAL EXPENSES 762‐‐‐‐ ‐ ‐ NET BUDGET (285,774) (291,942) (341,227) (348,000) (351,400) (10,173)(2.9%) +/‐ $20,000 AND +/‐ 10% ChangePayment in Lieu Tax RevenuesPage 28 of 29
2017 2018 20192020 20202020 Fcst vs 2020 Fcst vsFull Year Full Year Full YearApproved Forecast2019 Actual 2019 Actual Variance ExplanationActuals Actuals ActualsBudget to Year‐endIncrease / (Decrease) Increase / (Decrease)REVENUE: 3‐1411 RESIDENTIAL TAX CLASS(1,098,219) (2,181,277) (1,344,044)(675,000) (884,431)(459,613) (52.0%) 3‐1412 MULTI‐RESIDENTIAL TAX CLASS5,451 9,024 (1,326)‐‐(1,326) ‐ 3‐1413 COMMERCIAL TAX CLASS(14,051) (55,011) (14,785)‐ (208)(14,577) (7,008.2%) 3‐1414 COMMERCIAL EXCESS LAND TAX CLASS1,915 ‐ ‐‐‐‐#DIV/0! 3‐1415 COMMERCIAL VACANT LAND TAX CLASS5,698 4,455 ‐‐ (227,792)227,792 100.0% 3‐1416 SHOPPING CENTRE TAX CLASS(8,465) ‐ ‐‐‐‐‐ 3‐1419 INDUSTRIAL TAX CLASS‐ ‐ (627)‐‐(627) ‐ 3‐1420 INDUSTRIAL EXCESS LAND TAX CLASS2,048 ‐ ‐‐‐‐‐ 3‐1421 INDUSTRIAL VACANT LAND TAX CLASS(6,689) 19,046 (20,200)‐ 1,517(21,717) (1,431.6%) 3‐1427 PIPELINE TAX CLASS(3,046) (1,054) (622)‐ (425)(197) (46.4%) 3‐1428 FARM TAX CLASS‐ 493 ‐‐ (50)50 100.0% 3‐1437 INDUSTRIAL (NEW CONSTRUCTION) TAX CLASS‐ (23,117) ‐‐‐‐‐ 3‐1443 COMMERCIAL (NEW CON) TAX CLASS(58,322) (77,160) (21,391)‐ (8,111)(13,280) (163.7%) 3‐1444 COMMERCIAL (NEW CON) EXCESS LAND TX CL7,151 (4,298) 8,462‐‐8,462 ‐ 3‐1448 SHOPPING CTRE (NEW CON) TAX CLASS(40,252) (4,698) (35,932)‐‐(35,932) ‐ 3‐1449 SHOPPING CTRE (NEW CON) EXCESS LND TX CL1,506 356 (1,828)‐‐(1,828) ‐ 3‐1453 PARKING LOTS TAX CLASS(1,388) ‐ ‐‐‐‐‐ Total Revenue (1,206,663) (2,313,241) (1,432,293) (675,000) (1,119,500) (312,793) (27.9%) EXPENSE: TOTAL SALARIES & BENEFITS ‐‐‐‐‐ ‐ ‐ 4‐8003 CONTRIBUTIONS TO DISCRETIONARY RESERVE648,063 1,963,241 1,082,293400,000 844,500 (237,793) (28.2%) TOTAL OTHER EXPENSES 648,0631,963,241 1,082,293 400,000 844,500 (237,793) (28.2%) TOTAL EXPENSES 648,063 1,963,2411,082,293 400,000 844,500 (237,793) (28.2%) NET BUDGET (558,600) (350,000) (350,000) (275,000) (275,000) 75,000 27.3% +/‐ $20,000 AND +/‐ 10% ChangeSupplemental Tax RevenuesPage 29 of 29