The URL can be used to link to this page

AGENDA - Finance Advisory Committee - 20180328Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 5:30 p.m. Holland Room Aurora Town Hall Public Release March 22, 2018 Town of Aurora Finance Advisory Committee Meeting Agenda Date: Wednesday, March 28, 2018 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 February 28, 2018 Recommended: That the Finance Advisory Committee meeting minutes of February 28, 2018, be received for information. 4. Delegations 5. Consideration of Items Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Page 2 of 2 1. Review of Detailed Financial Budget Information Re: Corporate Services (CS) 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 Director, Financial Services Re: Round Table Discussion: Proposed Changes to Procurement Thresholds Recommended: 1. That the memorandum regarding Round Table Discussion: Proposed Changes to Procurement Thresholds be received; and 2. That the comments of the Finance Advisory Committee be referred to staff for consideration. 3. Distribution and Introduction of Detailed Financial Budget Information Re: Operational Services (OS) Recommended: 1. That the detailed financial budget information for Operational Services be received and deferred for discussion and detailed review at the April 25, 2018 meeting of the Finance Advisory Committee. 6. New Business 7. Adjournment Town of Aurora Finance Advisory Committee Meeting Minutes Date: Wednesday, February 28, 2018 Time and Location: 5:30 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: Doug Nadorozny, Chief Administrative Officer, Dan Elliott, Director of Financial Services/Treasurer, Lisa Warth, Acting Director of Community Services, Jason Gaertner, Manager, Financial Planning, and Linda Bottos, Council/Committee Secretary The Chair called the meeting to order at 5:35 p.m. 1. Approval of the Agenda Moved by Councillor Kim Seconded by Mayor Dawe 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. 3. Receipt of the Minutes Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Minutes Page 1 of 5 Finance Advisory Committee Meeting Minutes Wednesday, February 28, 2018 Page 2 of 5 Finance Advisory Committee Meeting Minutes of January 24, 2018 Moved by Mayor Dawe Seconded by Councillor Kim That the Finance Advisory Committee meeting minutes of January 24, 2018, be received for information. Carried 4. Delegations None 5. Consideration of Items 1. Memorandum from Acting Director, Community Services Re: Pricing Policy for Recreation Services Staff gave an overview of the memorandum and attachments, and provided additional information regarding community program subsidy considerations along with an excerpt from the Recreation Programming Audit Report of April 2017 respecting Background and Comparison of Program Pricing of Other Municipalities, noting that the Audit Report addressed revenues only and not the associated costs. The Chair noted that this memorandum was also presented to the Parks, Recreation and Cultural Services Advisory Committee for comment, and staff was asked to supply additional data in order to make any determinations. The Committee and staff discussed the various challenges and approaches to determining the appropriate cost recovery/subsidy levels, and to calculating overall program costs, including direct and indirect costs, and assumptions. Staff agreed to perform an in-depth examination of the cost data and allocations for various programs at a particular facility, and report back to the Committee at a future meeting. Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Minutes Page 2 of 5 Finance Advisory Committee Meeting Minutes Wednesday, February 28, 2018 Page 3 of 5 Moved by Councillor Kim Seconded by Mayor Dawe 1. That the memorandum regarding Pricing Policy for Recreation Services be received; and 2. That the comments of the Finance Advisory Committee be referred to staff for consideration and action as appropriate. Carried 2. Review of Detailed Financial Budget Information Re: Financial Services (FS) Staff provided an overview of the line-by-line analysis and year-to-date comparison of the final approved 2018 budget for the Financial Services department and detailed explanations respecting the highlighted items. Staff reviewed the current staffing situation and pending requests, noting that the Town’s growth has exceeded the department’s capacity to meet the service requirements related to tax and water utility administration. Staff expressed further concern regarding the budget provisions for required training and professional development. The Committee and staff discussed the value of training, development of a training policy and business cases, and relevant metrics. Staff confirmed that a complete review is underway respecting the tracking and allocation of training including courses, seminars and memberships. Moved by Mayor Dawe Seconded by Councillor Kim 1. That the comments and suggestions of the Review of Detailed Financial Budget Information for Financial Services be received and referred to staff for consideration and action as appropriate. Carried 3. Review of Draft General Committee Report No. FS18-004 – 2019 Budget Development Direction Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Minutes Page 3 of 5 Finance Advisory Committee Meeting Minutes Wednesday, February 28, 2018 Page 4 of 5 Staff provided background to the draft report noting the similarities and continued focus of the previous year, including budget principles and budget process, phase-in strategies, and inflation approach. Staff advised that a draft 2019 budget would be prepared for presentation early in the next term of Council, which will begin December 2018. The Committee made suggestions in the areas of financial implications and communications considerations, and staff agreed to apply the enhancements accordingly. Moved by Councillor Kim Seconded by Mayor Dawe 1. That Draft General Committee Report No. FS18-004 be received; and 2. That the key principles for the 2019 operating budget development be endorsed. Carried 4. Distribution and Introduction of Detailed Financial Budget Information Re: Corporate Services (CS) 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 was encouraged to contact the Director directly for any needed clarification prior to the March meeting. Moved by Mayor Dawe 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 March 28, 2018 meeting of the Finance Advisory Committee. Carried Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Minutes Page 4 of 5 Finance Advisory Committee Meeting Minutes Wednesday, February 28, 2018 Page 5 of 5 6. New Business Councillor Kim inquired about the status of the Town’s planned public art policy and staff provided a response. 7. Adjournment Moved by Councillor Kim Seconded by Mayor Dawe That the meeting be adjourned at 6:43 p.m. Carried Committee recommendations are not binding on the Town unless adopted by Council. Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Minutes Page 5 of 5 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-1000 MARRIAGE LICENSES-19,829 -18,450 -24,708-20,000 -22,0002,000 10.0% 6,258 33.9%3-1001 LOTTERY LICENSES-1,881 -2,456 -3,006-2,500 -2,500- - 550 22.4%3-1002 BURIAL/BIRTH LICENSES-7,713 -7,686 -8,855-5,500 -5,500- - 1,169 15.2%3-1003 BYLAW LICENSES-34,888 -49,510 -56,904-45,000 -47,0002,000 4.4% 7,394 14.9%3-1004 PARKING PERMITS-2,230 -6,890 -6,985-6,500 -6,600100 1.5% 95 1.4%3-1012 FARMERS MARKET PERMITS-3,675 -3,750 -3,150-3,750 -3,80050 1.3% -600 (16.0%)3-1050 COURT FINES-71,124 -56,935 -65,266-80,000 -80,000- - 8,331 14.6%3-1051 POA FINES126------ --3-1052 PARKING VIOLATIONS-104,379 -85,271 -64,595-75,000 -75,000---20,676 (24.2%)3-1102 ADMINISTRATIVE FEES-109,469 -67,211 -78,722-65,000 -65,000- - 11,511 17.1%3-1108 DOG TAGS-32,369 -21,766 -25,702-35,000 -35,000- - 3,936 18.1%3-1109 CAT TAGS-1,998 -1,821 -726-2,000 -2,000- - -1,095 (60.1%)3-1113 AFFIDAVITS/COMMISSIONING-4,240 -4,381 -5,522-4,000 -10,0006,000 150.0% 1,141 26.0%3-1114 FREEDOM OF INFORMATION FEES-1,037 -4,149 -821-1,000 -1,000- - -3,328 (80.2%)3-1117 CIVIL MARRIAGES-3,893 -7,552 -11,121-8,000 -8,000- - 3,569 47.3%3-1201 OTHER-4,675 -2,296 -5,502-3,000 -3,03030 1.0% 3,206 139.6%3-1202 GENERAL--246 -3,967-2,000 -2,000--3,7211,512.6%3-1900 CONTRIBUTION FROM CAPITAL-75,555 -79,361 -4,000-4,000 --4,000 (100.0%)-75,361 (95.0%)3-1901 CONTRIBUTION FROM DISCRETIONARY RESERVE-10,000--- -368,879368,879#DIV/0!-#DIV/0!3-1975 CIL PARKLAND CONTRIBUTION-50,000 -50,000 -10,000-10,000 -10,000---40,000 (80.0%)Total Revenue -538,829 -469,731 -379,552 -372,250 -747,309 375,059 100.8% -90,179 (19.2%)EXPENSE:4-2000 SALARIES - F/T2,995,619 3,105,734 3,529,8393,803,071 4,047,978244,907 6.4%424,105 13.7%4-2001 SALARIES - O/T2,885 2,888 5,70710,589 10,589- - 2,819 97.6%4-2002 SALARIES - P/T337,562 332,136 334,249248,208 279,71431,506 12.7% 2,113 0.6%4-2003 VACATION PAY- 9,612-----(9,612)(100.0%)4-2004 SICK PAY- 1,039-----(1,039)(100.0%)4-2005 LIEU TIME- 2,210-----(2,210)(100.0%)4-2090 YEAR END ACCRUALS20,190 -20,045 3,608----23,653 118.0%4-2100 BENEFITS - OMERS311,201 330,174 375,574404,648 428,08323,435 5.8%45,400 13.8%4-2101 BENEFITS - EHT65,064 64,953 75,21176,756 82,0095,253 6.8% 10,258 15.8%4-2102 BENEFITS - WSIB25,865 23,986 26,34929,522 31,5432,021 6.8% 2,363 9.9%4-2103 BENEFITS - CPP109,750 115,081 120,340120,894 127,3316,437 5.3% 5,259 4.6%4-2104 BENEFITS - EI58,037 61,493 55,45164,569 60,080(4,489) (7.0%) (6,042) (9.8%)4-2105 BENEFITS - DENTAL57,430 51,212 60,38378,786 76,038(2,748) (3.5%) 9,171 17.9%4-2106 BENEFITS - HEALTH100,051 99,187 111,745122,374 130,0407,666 6.3% 12,558 12.7%4-2107 BENEFITS - LTD/ADD53,813 54,061 64,20269,230 80,00210,772 15.6% 10,141 18.8%4-2108 BENEFITS - OTHER14,364 14,023 17,03417,297 20,0032,706 15.6% 3,011 21.5%4-2200 WAGE RECOVERY-93,433 -79,200 -74,900--- - 4,300 5.4%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 1 of 19 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-2201 SALARY SAVINGS----33,874 -33,874-- --TOTAL SALARIES & BENEFITS 4,058,398 4,168,544 4,704,792 5,012,070 5,339,536 327,466 6.5% 536,248 12.9%4-3000 PURCHASE CARD CLEARING- 1,775 -126--- - (1,901) (107.1%)4-4000 OFFICE SUPPLIES11,546 10,564 8,97412,073 11,411(662) (5.5%) (1,590) (15.1%)4-4004 SUBSCRIPTIONS/PUBLICATIONS28,459 28,222 33,18525,000 25,000- - 4,963 17.6%4-4005 MARRIAGE LICENSES5,330 6,720 8,3547,500 7,500- - 1,634 24.3%4-4006 OFFICE EQUIPMENT5,745 3,067 4,8236,600 4,600(2,000) (30.3%) 1,756 57.3%4-4007 COMPUTER SUPPLIES4,639 7,172 8,0307,000 7,140140 2.0% 858 12.0%4-4008 SOFTWARE2,246 2,188 2,188---- --4-4009 SAFETY SUPPLIES1,346 7,256 2,7732,000 3,0001,000 50.0% (4,483) (61.8%)4-4010 CLOTHING ALLOWANCE7,338 13,683 5,5077,500 8,8101,310 17.5% (8,176) (59.8%)4-4015 OPERATING MATERIALS5,812 15,308 12,55714,525 14,55025 0.2% (2,751) (18.0%)4-4016 DOG TAGS1,087 2,242-3,060 3,120602.0%(2,242)(100.0%)4-4017 CAT TAGS------- --4-4018 LICENSES174,338 81,703 180,632164,367 188,09723,730 14.4%98,929 121.1%4-4019 VEHICLE SUPPLIES1,343 1,2027271,600 1,545(55)(3.4%)(475)(39.5%)4-4021 EQUIPMENT - OTHER- 9,380 2,852--- - (6,528) (69.6%)4-4028 COST REALLOCATIONS-79,561 -87,844 -101,035-110,000 -90,00020,000 18.2% (13,191) (15.0%)4-4044 STAFF INITIATIVES30------ --4-4045 MUNICIPAL BUSINESS4,438 3,950 5,2164,150 4,150- - 1,266 32.1%4-4047 SUPPLIES1,988 1,206-----(1,206)(100.0%)4-4057 COPIERS, PRINTERS AND FAXES90,886 94,970 87,883110,000 90,000(20,000) (18.2%) (7,087) (7.5%)4-4065 WORKPLACE ACCOMMODATIONS-509 2,3742,500 2,500--1,865366.4%4-5018 TELEPHONE LINES59,324 68,647 73,36383,000 74,250(8,750) (10.5%) 4,716 6.9%4-5020 LONG DISTANCE LINES1,329 1,115 1,0681,500 1,500- - (47) (4.2%)4-5021 MOBILE PLAN CHARGES80,608 79,920 81,23196,284 99,1732,889 3.0% 1,311 1.6%4-5022 CORPORATE FAX LINES5,289 6,194 5,4266,000 6,000- - (768) (12.4%)4-5023 INTERNET LINE17,181 18,215 20,88125,000 25,000- - 2,666 14.6%4-5024 TELEPHONE SERVICE AGREEMENT15,910 6,331 16,31020,000 20,000- - 9,979 157.6%4-5026 COURSES & SEMINARS16,398 16,572 13,31218,700 29,06010,360 55.4% (3,260) (19.7%)4-5027 MANDATORY COURSES & SEMINARS3,397 3,560 3,5863,007 5,5072,500 83.1% 26 0.7%4-5028 MEMBERSHIPS21,465 30,995 38,08343,010 43,478468 1.1% 7,088 22.9%4-5029 MILEAGE1,954 2,716 2,0774,178 3,613(565) (13.5%) (639) (23.5%)4-5031 GENERAL OFFICE EQUIPMENT1,444 4,289 6,0568,015 2,000(6,015) (75.0%) 1,767 41.2%4-5032 VEHICLE REPAIRS59349611,015 1,030151.5%9272,726.5%4-5033 EQUIPMENT REPAIRS6,731 10,590 10,7179,100 9,600500 5.5% 127 1.2%4-5034 EQUIPMENT RENTALS193------ --4-5037 PROPERTY IMPROVEMENT2,304 27,232 1,0362,000 1,015(985) (49.3%)(26,196) (96.2%)4-5039 INSURANCE FEES531,399 520,941 541,229534,400 551,00016,600 3.1% 20,288 3.9%4-5040 INSURANCE ADJUSTER16,666 12,613 13,79420,000 60,00040,000 200.0% 1,181 9.4%4-5041 INSURANCE CLAIM DEDUCTIBLE29,415 47,870 16,41840,000 -(40,000) (100.0%)(31,452) (65.7%)4-5042 ADVERTISING-- 36,18720,000 18,000(2,000)(10.0%)36,187-Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 2 of 19 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-5043 CONSULTING53,377 47,222 74,13342,500 38,000(4,500) (10.6%)26,911 57.0%4-5044 POSTAGE70,635 101,738 72,477100,000 105,0005,000 5.0%(29,261) (28.8%)4-5045 PHOTOCOPIER CHARGES19,931 21,350 18,06120,567 19,710(857) (4.2%) (3,289) (15.4%)4-5046 PRINTING2,376 2,509 4,6684,345 4,39045 1.0% 2,159 86.1%4-5050 APPRAISALS39,967 19,779 27,89025,000 22,900(2,100) (8.4%) 8,111 41.0%4-5052 SEARCHES & REGISTRATIONS22,723 27,753 26,01225,000 20,000(5,000) (20.0%) (1,741) (6.3%)4-5054 PLANNING & DEVELOPMENT11,853 263,151 85,614110,000 50,000(60,000) (54.5%)(177,537) (67.5%)4-5055 ADVOCACY12,582 52,679 60,98450,000 50,000- - 8,305 15.8%4-5056 PERSONNEL ADMINISTRATION23,301 18,214 24,92820,000 20,000- - 6,714 36.9%4-5059 CONTRACTS295,474 294,427 360,254374,087 663,501289,414 77.4%65,827 22.4%4-5060 COST RECOVERY-10,735 -9,210 -21,185-15,000 -15,000- - (11,975) (130.0%)4-5061 SOFTWARE ANNUAL MTCE SUPPORT344,141 420,857 353,297454,812 490,92436,112 7.9%(67,560) (16.1%)4-5084 OFFICE RELOCATES3,261 1,1091732,040 1,000(1,040)(51.0%)(936)(84.4%)4-5086 SECURITY-- 18,65635,000-(35,000)(100.0%)18,656-4-5090 COURIER2,807 3,863 2,4193,800 3,800- - (1,444) (37.4%)4-5098 ACCESSIBILITY COSTS24,961 21,217 26,37025,000 25,000- - 5,153 24.3%4-5099 APPLICATION VENDOR SUPPORT-- 1,1603,000 3,000--1,1600.0%4-5100 POST ELECTION COMPLIANCE COSTS721------ -0.0%4-6001 BANK CHARGES1,846 2,862 2,4891,500 1,52525 1.7% (373) (13.0%)4-6025 EMPLOYEE RECOGNITION-- 5,446- 4,5004,500-5,4460.0%4-6026 CORPORATE COURSES & SEMINARS2,787 19,426 25,29147,313 55,0007,687 16.2% 5,865 30.2%4-8003 CONTRIBUTIONS TO DISCRETIONARY RESERVES82,500 82,500 82,50082,500 -(82,500) (100.0%) - -TOTAL OTHER EXPENSES 2,082,584 2,452,553 2,398,286 2,604,548 2,794,899 190,351 7.3% (54,267) (2.2%)TOTAL EXPENSES 6,140,982 6,621,097 7,103,078 7,616,618 8,134,435 517,8176.8%481,9817.3%NET BUDGET5,602,153 6,151,366 6,723,526 7,244,368 7,387,126142,7582.0%572,1609.3%Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 3 of 19 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-1114 FREEDOM OF INFORMATION FEES-1,037 -4,149 -821-1,000 -1,000- - -3,328 80.2%3-1117 CIVIL MARRIAGES-3,893 -7,552 -11,121-8,000 -8,000- - 3,569 (47.3%)3-1201 OTHER-27 -931------931100.0%3-1202 GENERAL--246 -3,967-2,000 -2,000--3,721(1,512.6%)3-1900 CONTRIBUTION FROM CAPITAL-75,555 -79,361 -4,000-4,000 --4,000 (100.0%)-75,361 (95.0%)Total Revenue -80,512 -92,239 -19,909 -15,000 -11,000 -4,000 (26.7%) -72,330 (78.4%)EXPENSE:4-2000 SALARIES - F/T357,817 376,000 432,894514,003 498,049(15,954) (3.1%)56,894 15.1%4-2001 SALARIES - O/T-172 2,510----2,3381,359.3%4-2002 SALARIES - P/T73,581 91,844 14,95323,802 19,672(4,130) (17.4%)(76,891) (83.7%)4-2003 VACATION PAY- 5,760-----(5,760)(100.0%)4-2004 SICK PAY-347-----(347)(100.0%)4-2005 LIEU TIME- 2,176-----(2,176)(100.0%)4-2090 YEAR END ACCRUALS4,221339173----(166)(49.0%)4-2100 BENEFITS - OMERS40,851 35,030 45,13742,487 53,76511,278 26.5% 10,107 28.9%4-2101 BENEFITS - EHT9,365 8,587 8,7588,206 10,0811,875 22.8% 171 2.0%4-2102 BENEFITS - WSIB3,810 3,288 3,3213,156 3,877721 22.8% 33 1.0%4-2103 BENEFITS - CPP18,015 18,844 15,43213,802 16,3882,586 18.7% (3,412) (18.1%)4-2104 BENEFITS - EI9,881 10,138 7,2127,379 7,662283 3.8% (2,926) (28.9%)4-2105 BENEFITS - DENTAL6,019 6,354 5,4219,204 10,4161,212 13.2% (933) (14.7%)4-2106 BENEFITS - HEALTH11,831 11,958 12,19314,296 17,8143,518 24.6% 235 2.0%4-2107 BENEFITS - LTD/ADD7,256 6,388 7,7667,471 10,2752,804 37.5% 1,378 21.6%4-2108 BENEFITS - OTHER1,872 1,671 1,9961,867 2,569702 37.6% 325 19.4%TOTAL SALARIES & BENEFITS 544,519 578,896 557,766 645,673 650,568 4,895 0.8% (21,130) (3.7%)4-4000 OFFICE SUPPLIES5,312 3,882 2,5415,000 4,000(1,000) (20.0%) (1,341) (34.5%)4-4004 SUBSCRIPTIONS/PUBLICATIONS744499232800800--(267)(53.5%)4-4006 OFFICE EQUIPMENT1,429536 1,5192,000 1,000(1,000)(50.0%)983183.4%4-4044 STAFF INITIATIVES30------ -#DIV/0!4-4045 MUNICIPAL BUSINESS1,324 1,367802450450--(565)(41.3%)4-4047 SUPPLIES1,988 1,206-----(1,206)(100.0%)4-5026 COURSES & SEMINARS3,133 2,7543663,232 3,5002688.3%(2,388)(86.7%)4-5028 MEMBERSHIPS1,634 1,3627072,400 2,000(400)(16.7%)(655)(48.1%)4-5029 MILEAGE539469317600500(100)(16.7%)(152)(32.4%)4-5039 INSURANCE FEES531,399 520,941 541,229534,400 551,00016,600 3.1% 20,288 3.9%4-5040 INSURANCE ADJUSTER16,666 12,613 13,79420,000 60,00040,000 200.0% 1,181 9.4%4-5041 INSURANCE CLAIM DEDUCTIBLE29,415 47,870 16,41840,000 -(40,000) (100.0%)(31,452) (65.7%)4-5042 ADVERTISING-- 2,4545,000 3,000(2,000)(40.0%)2,454-Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 4 of 19 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-5045 PHOTOCOPIER CHARGES9,319 9,498 4,8268,063 7,070(993) (12.3%) (4,672) (49.2%)4-5046 PRINTING--154500500--154-4-5059 CONTRACTS10,354 6,297 5,88917,000 17,000- - (408) (6.5%)4-5060 COST RECOVERY-- -3,670-10,100 -10,100--(3,670)-TOTAL OTHER EXPENSES613,286 609,294 587,578 629,345 640,72011,3751.8%(21,716)(3.6%)TOTAL EXPENSES1,157,805 1,188,190 1,145,344 1,275,018 1,291,28816,2701.3%(42,846)(3.6%)NET BUDGET1,077,293 1,095,951 1,125,435 1,260,018 1,280,28820,2701.6%29,4842.7%Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 5 of 19 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-1901 CONTRIBUTION FROM DISCRETIONARY RESERV-10,000--- -368,879368,879---Total Revenue-10,000--- -368,879368,879---EXPENSE:4-2002 SALARIES - P/T---- 80,31180,311 - - -4-2101 BENEFITS - EHT---- 1,5061,506 - - -4-2102 BENEFITS - WSIB----579579---4-2103 BENEFITS - CPP---- 2,6192,619 - - -4-2104 BENEFITS - EI---- 1,1941,194 - - -TOTAL SALARIES & BENEFITS - - - - 86,209 86,209 - - -4-4008 SOFTWARE2,188 2,188 2,188---- --4-5034 EQUIPMENT RENTALS193------ --4-5059 CONTRACTS9,141 -100-- 390,170390,170-100100.0%4-5100 POST ELECTION COMPLIANCE COSTS721------ --4-8003 CONTRIBUTIONS TO DISCRETIONARY RESERVES82,500 82,500 82,50082,500 -(82,500) (100.0%) - -TOTAL OTHER EXPENSES 94,743 84,588 84,688 82,500 390,170 307,670 372.9% 100 0.1%TOTAL EXPENSES 94,743 84,588 84,688 82,500 476,379 393,879 477.4% 100 0.1%NET BUDGET 84,743 84,588 84,688 82,500 107,500 25,000 30.3% 100 0.1%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 6 of 19 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-1003 BYLAW LICENSES-34,888 -49,510 -56,904-45,000 -47,0002,000 4.4% 7,394 14.9%3-1004 PARKING PERMITS-2,230 -6,890 -6,985-6,500 -6,600100 1.5% 95 1.4%3-1012 FARMERS MARKET PERMITS-3,675 -3,750 -3,150-3,750 -3,80050 1.3% -600 (16.0%)3-1050 COURT FINES-71,124 -56,935 -65,266-80,000 -80,000- - 8,331 14.6%3-1051 POA FINES126------ --3-1052 PARKING VIOLATIONS-104,379 -85,271 -64,595-75,000 -75,000---20,676 (24.2%)3-1201 OTHER-1,031 -1,365 -5,502-2,000 -2,03030 1.5% 4,137303.1%Total Revenue -217,201 -203,721 -202,402 -212,250 -214,430 2,180 1.0% -1,319 (0.6%)EXPENSE:4-2000 SALARIES - F/T415,683 408,765 377,058439,164 624,480185,316 42.2% (31,707) (7.8%)4-2001 SALARIES - O/T1,622937 3,196----2,259241.1%4-2002 SALARIES - P/T118,071 130,414 182,966157,384 111,577(45,807) (29.1%)52,552 40.3%4-2003 VACATION PAY- 3,172-----(3,172)(100.0%)4-2004 SICK PAY-660-----(660)(100.0%)4-2090 YEAR END ACCRUALS1,536 -10,556 -1,302--- - 9,254 87.7%4-2100 BENEFITS - OMERS47,479 49,578 45,49246,005 48,0362,031 4.4% (4,086) (8.2%)4-2101 BENEFITS - EHT10,488 10,614 11,01611,515 11,892377 3.3% 402 3.8%4-2102 BENEFITS - WSIB4,499 3,960 4,0754,429 4,574145 3.3% 115 2.9%4-2103 BENEFITS - CPP21,027 20,508 21,00721,630 22,012382 1.8% 499 2.4%4-2104 BENEFITS - EI11,537 11,221 9,93211,842 11,011(831) (7.0%) (1,289) (11.5%)4-2105 BENEFITS - DENTAL6,564 5,985 7,43310,677 10,069(608) (5.7%) 1,448 24.2%4-2106 BENEFITS - HEALTH13,036 12,297 13,34616,583 17,220637 3.8% 1,049 8.5%4-2107 BENEFITS - LTD/ADD7,430 7,970 8,1968,246 9,3761,130 13.7% 226 2.8%4-2108 BENEFITS - OTHER2,166 2,010 2,0832,060 2,344284 13.8% 73 3.6%TOTAL SALARIES & BENEFITS 661,138 657,535 684,498 729,535 872,591 143,056 19.6% 26,963 4.1%4-4000 OFFICE SUPPLIES1,642 1,415 1,9901,523 1,55027 1.8% 575 40.6%4-4010 CLOTHING ALLOWANCE5,246 12,699 5,1416,000 7,8001,800 30.0% (7,558) (59.5%)4-4015 OPERATING MATERIALS5,097 5,799 8,0545,525 5,55025 0.5% 2,255 38.9%4-4019 VEHICLE SUPPLIES1,343 1,2027271,600 1,545(55)(3.4%)(475)(39.5%)4-4045 MUNICIPAL BUSINESS849704917450450--21330.3%4-5026 COURSES & SEMINARS3,896 4,743 1,1263,060 3,060- - (3,617) (76.3%)4-5027 MANDATORY COURSES & SEMINARS-5309311,940 1,940--40175.7%4-5028 MEMBERSHIPS7626986621,575 1,595201.3%(36)(5.2%)4-5029 MILEAGE698 1,353527865400(465)(53.8%)(826)(61.0%)4-5031 GENERAL OFFICE EQUIPMENT315 1,2005111,015 1,20018518.2%(689)(57.4%)4-5032 VEHICLE REPAIRS59349611,015 1,030151.5%9272,726.5%4-5037 PROPERTY IMPROVEMENT2,304 27,232 1,0362,000 1,015(985) (49.3%)(26,196) (96.2%)Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 7 of 19 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-5045 PHOTOCOPIER CHARGES1,517 1,590 2,0521,640 1,70060 3.7% 462 29.1%4-5046 PRINTING2,376 2,188 4,5133,045 3,09045 1.5% 2,325 106.3%4-5061 SOFTWARE ANNUAL MTCE SUPPORT---1,500 1,52525 1.7% - -4-5086 SECURITY-- 18,65635,000-(35,000)(100.0%)18,656-4-6001 BANK CHARGES1,846 2,862 2,4891,500 1,52525 1.7% (373) (13.0%)TOTAL OTHER EXPENSES 27,950 64,249 50,293 69,253 34,975 (34,278) (49.5%) (13,956) (21.7%)TOTAL EXPENSES 689,088 721,784 734,791 798,788 907,566 108,778 13.6% 13,007 1.8%NET BUDGET 471,887 518,063 532,389 586,538 693,136 106,598 18.2% 14,3262.8%Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 8 of 19 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-1108 DOG TAGS-32,369 -21,766 -25,702-35,000 -35,000- - 3,936 (18.1%)3-1109 CAT TAGS-1,998 -1,821 -726-2,000 -2,000- - -1,095(60.1%)Total Revenue -34,367 -23,587 -26,428 -37,000 -37,000 - - 2,841 12.0%EXPENSE:TOTAL SALARIES & BENEFITS - - - - - - - - -4-4015 OPERATING MATERIALS- 4,188946----(3,242)(77.4%)4-4016 DOG TAGS1,087 2,242-3,060 3,120602.0%(2,242)(100.0%)4-4017 CAT TAGS------- --4-5059 CONTRACTS217,547 214,370 264,034276,000 135,000(141,000) (51.1%)49,664 23.2%TOTAL OTHER EXPENSES 218,634 220,800 264,980 279,060 138,120 (140,940) (50.5%) 44,180 20.0%TOTAL EXPENSES 218,634 220,800 264,980 279,060 138,120 (140,940) (50.5%) 44,180 20.0%NET BUDGET 184,267 197,213 238,552 242,060 101,120 (140,940) (58.2%) 41,33921.0%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 9 of 19 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-1000 MARRIAGE LICENSES-19,829 -18,450 -24,708-20,000 -22,0002,000 10.0% 6,258 (33.9%)3-1001 LOTTERY LICENSES-1,881 -2,456 -3,006-2,500 -2,500- - 550 (22.4%)3-1002 BURIAL/BIRTH LICENSES-7,713 -7,686 -8,855-5,500 -5,500- - 1,169 (15.2%)3-1113 AFFIDAVITS/COMMISSIONING-4,240 -4,381 -5,522-4,000 -10,0006,000 150.0% 1,141 (26.0%)3-1201 OTHER-2,568---1,000 -1,000-- --Total Revenue-36,231 -32,973 -42,091 -33,000 -41,0008,00024.2%9,11827.7%EXPENSE:4-2000 SALARIES - F/T430,251 490,133 476,430520,454 539,32218,868 3.6% (13,703) (2.8%)4-2002 SALARIES - P/T31,448 56,328 56,54557,197 58,163966 1.7% 217 0.4%4-2003 VACATION PAY-588-----(588)(100.0%)4-2004 SICK PAY-32-----(32)(100.0%)4-2090 YEAR END ACCRUALS-6,591 -233 2,685--- - 2,918 1,252.4%4-2100 BENEFITS - OMERS46,011 47,166 48,95954,126 56,6322,506 4.6% 1,793 3.8%4-2101 BENEFITS - EHT8,989 9,125 10,42511,221 11,607386 3.4% 1,300 14.2%4-2102 BENEFITS - WSIB3,668 3,347 3,8384,316 4,465149 3.5% 491 14.7%4-2103 BENEFITS - CPP15,986 16,606 18,66820,312 20,579267 1.3% 2,062 12.4%4-2104 BENEFITS - EI8,568 8,860 8,79110,934 9,829(1,105) (10.1%) (69) (0.8%)4-2105 BENEFITS - DENTAL10,686 10,153 12,03212,886 12,152(734) (5.7%) 1,879 18.5%4-2106 BENEFITS - HEALTH17,885 18,232 20,57220,014 20,783769 3.8% 2,340 12.8%4-2107 BENEFITS - LTD/ADD8,048 8,060 8,6009,773 11,1261,353 13.8% 540 6.7%4-2108 BENEFITS - OTHER2,051 2,047 2,3162,442 2,782340 13.9% 269 13.1%4-2200 WAGE RECOVERY-78,000 -79,200 -74,900--- #DIV/0! 4,300 5.4%TOTAL SALARIES & BENEFITS499,000 591,244 594,961 723,675 747,44023,7653.3%3,7170.6%4-4000 OFFICE SUPPLIES1,492 1,092 1,0921,000 1,500500 50.0% - -4-4005 MARRIAGE LICENSES5,330 6,720 8,3547,500 7,500- - 1,634 24.3%4-4006 OFFICE EQUIPMENT2,689 1,4106382,000 1,000(1,000)(50.0%)(772)(54.8%)4-4010 CLOTHING ALLOWANCE709353-1,000500(500)(50.0%)(353)(100.0%)4-4045 MUNICIPAL BUSINESS546531514450450--(17)(3.2%)4-5026 COURSES & SEMINARS1,206 2,298 2,1542,620 3,500880 33.6% (144) (6.3%)4-5028 MEMBERSHIPS7437797915005505010.0%121.5%4-5029 MILEAGE--31300300--31-4-5044 POSTAGE70,635 101,738 72,477100,000 105,0005,000 5.0%(29,261) (28.8%)4-5045 PHOTOCOPIER CHARGES2,230 2,135 2,2582,286 2,100(186) (8.1%) 123 5.8%4-5059 CONTRACTS-- 14,45112,500 12,500--14,451-4-5090 COURIER2,807 3,863 2,4193,800 3,800- - (1,444) (37.4%)4-5098 ACCESSIBILITY COSTS24,961 21,217 26,37025,000 25,000- - 5,153 24.3%TOTAL OTHER EXPENSES 113,348 142,136 131,549 158,956 163,700 4,744 3.0% (10,587) (7.4%)Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 10 of 19 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%TOTAL EXPENSES612,348 733,380 726,510 882,631 911,14028,5093.2%(6,870)(0.9%)NET BUDGET576,117 700,407 684,419 849,631 870,14020,5092.4%(15,988)(2.3%)Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 11 of 19 2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget2016 Actual2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease) Increase / (Decrease)REVENUE:Total Revenue----- - - - -EXPENSE:4-2000 SALARIES - F/T917,284 934,490 969,757972,744 1,001,71828,974 3.0% 35,267 3.8%4-2001 SALARIES - O/T1,263 1,422-5,412 5,412--(1,422)(100.0%)4-2090 YEAR END ACCRUALS24,361 -9,648526---#DIV/0!10,174105.5%4-2100 BENEFITS - OMERS90,564 92,553 96,928107,670 111,5083,838 3.6% 4,375 4.7%4-2101 BENEFITS - EHT18,004 18,312 19,03619,074 19,639565 3.0% 724 4.0%4-2102 BENEFITS - WSIB7,290 6,653 6,8227,336 7,553217 3.0% 169 2.5%4-2103 BENEFITS - CPP27,279 28,207 28,20528,553 28,899346 1.2% (2) (0.0%)4-2104 BENEFITS - EI14,331 14,917 12,87715,053 13,277(1,776) (11.8%) (2,040) (13.7%)4-2105 BENEFITS - DENTAL18,492 16,241 17,38220,249 19,096(1,153) (5.7%) 1,141 7.0%4-2106 BENEFITS - HEALTH30,890 30,423 30,39231,451 32,6581,207 3.8% (31) (0.1%)4-2107 BENEFITS - LTD/ADD16,965 16,778 17,88818,265 20,6652,400 13.1% 1,110 6.6%4-2108 BENEFITS - OTHER4,339 4,253 4,5364,564 5,167603 13.2% 283 6.7%TOTAL SALARIES & BENEFITS 1,171,062 1,154,601 1,204,349 1,230,371 1,265,592 35,221 2.9% 49,748 4.3%4-4000 OFFICE SUPPLIES399697380550561112.0%(317)(45.5%)4-4007 COMPUTER SUPPLIES4,639 7,172 8,0307,000 7,140140 2.0% 858 12.0%4-4008 SOFTWARE58------ -0.0%4-4010 CLOTHING ALLOWANCE1,384630366500510102.0%(264)(41.9%)4-4018 LICENSES174,338 81,703 180,632164,367 180,28715,920 9.7%98,929 121.1%4-4021 EQUIPMENT - OTHER- 9,380 2,852--- - (6,528) (69.6%)4-4028 COST REALLOCATIONS-79,561 -87,844 -101,035-110,000 -90,00020,000 18.2% (13,191) (15.0%)4-4045 MUNICIPAL BUSINESS265498422450450--(76)(15.3%)4-4057 COPIERS, PRINTERS AND FAXES90,886 94,970 87,883110,000 90,000(20,000) (18.2%) (7,087) (7.5%)4-5026 COURSES & SEMINARS7,470 5,209 4,0605,997 12,0006,003 100.1% (1,149) (22.1%)4-5028 MEMBERSHIPS7,771 13,374 14,66214,900 15,198298 2.0% 1,288 9.6%4-5029 MILEAGE484659588600600--(71)(10.8%)4-5031 GENERAL OFFICE EQUIPMENT1,129 3,090 5,5457,000 800(6,200) (88.6%) 2,455 79.4%4-5033 EQUIPMENT REPAIRS161686 2,2471,000 1,50050050.0%1,561227.6%4-5043 CONSULTING26,490 39,330 20,05320,000 20,000- - (19,277) (49.0%)4-5045 PHOTOCOPIER CHARGES286299278240260208.3%(21)(7.0%)4-5059 CONTRACTS13,714 13,358 3,03010,000 10,000- - (10,328) (77.3%)4-5061 SOFTWARE ANNUAL MTCE SUPPORT344,141 420,857 353,297453,312 489,39936,087 8.0%(67,560) (16.1%)4-5084 OFFICE RELOCATES3,261 1,1091732,040 1,000(1,040)(51.0%)(936)(84.4%)4-5099 APPLICATION VENDOR SUPPORT-- 1,1603,000 3,000--1,160-Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 12 of 19 2015 2016 20172017 20182018 vs 2018 vs 2017 vs 2017 vsFull Year Full Year Full YearApproved Approved2017 Budget 2017 Budget2016 Actual2016 ActualActuals Actuals ActualsBudget BudgetIncrease / (Decrease) Increase / (Decrease) Increase / (Decrease) Increase / (Decrease)Dollar Change > +/- $20,000ANDPercentage Change > +/- 10%TOTAL OTHER EXPENSES597,315605,177 584,623 690,956 742,70551,7497.5%(20,554)(3.4%)TOTAL EXPENSES1,768,377 1,759,778 1,788,972 1,921,327 2,008,29786,9704.5%29,1941.7%NET BUDGET1,768,377 1,759,778 1,788,972 1,921,327 2,008,29786,9704.5%29,1941.7%Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 13 of 19 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:TOTAL SALARIES & BENEFITS - - - - - - - - -4-4018 LICENSES---- 7,8107,810 - - -4-5018 TELEPHONE LINES46,501 55,279 59,32669,000 60,000(9,000) (13.0%) 4,047 7.3%4-5020 LONG DISTANCE LINES1,329 1,115 1,0681,500 1,500- - (47) (4.2%)4-5021 MOBILE PLAN CHARGES80,608 79,920 81,23196,284 99,1732,889 3.0% 1,311 1.6%4-5022 CORPORATE FAX LINES5,289 6,194 5,4266,000 6,000- - (768) (12.4%)4-5023 INTERNET LINE17,181 18,215 20,88125,000 25,000- - 2,666 14.6%4-5024 TELEPHONE SERVICE AGREEMENT15,910 6,331 16,31020,000 20,000- - 9,979 157.6%4-5033 EQUIPMENT REPAIRS6,570 9,905 8,4708,100 8,100- - (1,435) (14.5%)4-5059 CONTRACTS25,084 32,010 25,01534,125 35,8311,706 5.0% (6,995) (21.9%)TOTAL OTHER EXPENSES 198,472 208,969 217,727 260,009 263,414 3,405 1.3% 8,758 4.2%TOTAL EXPENSES 198,472 208,969 217,727 260,009 263,414 3,405 1.3% 8,7584.2%NET BUDGET 198,472208,969 217,727 260,009 263,414 3,405 1.3% 8,758 4.2%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 14 of 19 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-109,469 -67,211 -78,722-65,000 -65,000- - 11,511 (17.1%)3-1975 CIL PARKLAND CONTRIBUTION-50,000 -50,000 -10,000-10,000 -10,000---40,000 (80.0%)Total Revenue -159,469 -117,211 -88,722 -75,000 -75,000 - - -28,489 (24.3%)EXPENSE:4-2000 SALARIES - F/T579,542 500,014 573,095571,322 598,65827,336 4.8%73,081 14.6%4-2001 SALARIES - O/T-357-5,176 5,17710.0%(357)(100.0%)4-2002 SALARIES - P/T-- 8,489----8,489-4-2090 YEAR END ACCRUALS-13,595 1,236496----(740)(59.9%)4-2100 BENEFITS - OMERS61,278 54,768 65,52964,676 68,4543,778 5.8% 10,761 19.6%4-2101 BENEFITS - EHT10,264 9,991 11,39911,241 11,775534 4.8% 1,408 14.1%4-2102 BENEFITS - WSIB3,575 3,589 3,7554,324 4,529205 4.7% 166 4.6%4-2103 BENEFITS - CPP12,746 16,058 15,74515,606 15,794188 1.2% (313) (1.9%)4-2104 BENEFITS - EI6,614 8,447 7,2188,269 7,301(968) (11.7%) (1,229) (14.5%)4-2105 BENEFITS - DENTAL7,646 5,256 6,36311,045 10,416(629) (5.7%) 1,107 21.1%4-2106 BENEFITS - HEALTH12,714 11,083 12,77717,155 17,814659 3.8% 1,694 15.3%4-2107 BENEFITS - LTD/ADD8,536 8,583 9,75710,727 12,3501,623 15.1% 1,174 13.7%4-2108 BENEFITS - OTHER2,451 2,276 2,6902,680 3,088408 15.2% 414 18.2%TOTAL SALARIES & BENEFITS 691,771 621,658 717,313 722,221 755,356 33,135 4.6% 95,655 15.4%4-4000 OFFICE SUPPLIES1,691 1,498 1,6241,500 1,500- - 126 8.4%4-4004 SUBSCRIPTIONS/PUBLICATIONS27,501 27,552 30,98422,000 22,000- - 3,432 12.5%4-4006 OFFICE EQUIPMENT1,627937 1,7782,000 2,000--84189.8%4-4045 MUNICIPAL BUSINESS1,001608529450450--(79)(13.0%)4-5026 COURSES & SEMINARS2561----#DIV/0!(61)(100.0%)4-5027 MANDATORY COURSES & SEMINARS3,397 3,030 2,6551,067 3,5672,500 234.3% (375) (12.4%)4-5028 MEMBERSHIPS7,793 12,069 8,1428,000 8,500500 6.3% (3,927) (32.5%)4-5029 MILEAGE145235394500500--15967.7%4-5045 PHOTOCOPIER CHARGES3,339 4,899 3,0243,488 3,800312 8.9% (1,875) (38.3%)4-5050 APPRAISALS39,967 19,779 27,89025,000 22,900(2,100) (8.4%) 8,111 41.0%4-5052 SEARCHES & REGISTRATIONS22,723 27,753 26,01225,000 20,000(5,000) (20.0%) (1,741) (6.3%)4-5054 PLANNING & DEVELOPMENT11,853 263,151 85,614110,000 50,000(60,000) (54.5%)(177,537) (67.5%)4-5055 ADVOCACY12,582 52,679 60,98450,000 50,000- - 8,305 15.8%4-5060 COST RECOVERY-10,735 -9,210 -17,515-4,900 -4,900- - (8,305) (90.2%)TOTAL OTHER EXPENSES 122,909 405,041 232,115 244,105 180,317 (63,788)(26.1%) (172,926) (42.7%)TOTAL EXPENSES 814,680 1,026,699 949,428 966,326 935,673 (30,653) (3.2%) (77,271) (7.5%)NET BUDGET 655,211 909,488 860,706 891,326 860,673 (30,653) (3.4%) (48,782)(5.4%)Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 15 of 19 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-1201 OTHER-1,050------ --Total Revenue-1,050---- - - - -EXPENSE:4-2000 SALARIES - F/T295,042 396,331 344,024428,728 423,074(5,654) (1.3%)(52,307) (13.2%)4-2002 SALARIES - P/T114,462 53,550 71,2969,826 9,991165 1.7% 17,746 33.1%4-2003 VACATION PAY-92-----(92)(100.0%)4-2005 LIEU TIME-34-----(34)(100.0%)4-2090 YEAR END ACCRUALS10,258 -1,183 -5,828--- - (4,645) (392.6%)4-2100 BENEFITS - OMERS25,018 51,080 30,49046,980 46,213(767) (1.6%)(20,590) (40.3%)4-2101 BENEFITS - EHT7,954 8,324 7,5888,544 8,437(107) (1.3%) (736) (8.8%)4-2102 BENEFITS - WSIB3,023 3,150 2,7093,286 3,245(41) (1.2%) (441) (14.0%)4-2103 BENEFITS - CPP14,696 14,857 13,59013,230 13,186(44) (0.3%) (1,267) (8.5%)4-2104 BENEFITS - EI7,105 7,910 5,9087,026 6,223(803) (11.4%) (2,002) (25.3%)4-2105 BENEFITS - DENTAL8,023 7,224 6,2679,204 8,680(524) (5.7%) (957) (13.2%)4-2106 BENEFITS - HEALTH13,695 15,193 13,09014,296 14,845549 3.8% (2,103) (13.8%)4-2107 BENEFITS - LTD/ADD5,578 6,282 6,8538,050 8,728678 8.4% 571 9.1%4-2108 BENEFITS - OTHER1,486 1,765 1,7462,011 2,182171 8.5% (19) (1.1%)4-2200 WAGE RECOVERY-15,433------ --TOTAL SALARIES & BENEFITS490,907 564,609 497,733 551,181 544,804(6,377)(1.2%)(66,876)(11.8%)4-4000 OFFICE SUPPLIES1,010 1,9798561,500 1,300(200)(13.3%)(1,123)(56.7%)4-4004 SUBSCRIPTIONS/PUBLICATIONS214170 1,8522,000 2,000--1,682989.4%4-4006 OFFICE EQUIPMENT-183691400400--508277.6%4-4009 SAFETY SUPPLIES1,346 7,256 2,7732,000 3,0001,000 50.0% (4,483) (61.8%)4-4045 MUNICIPAL BUSINESS454242328450450--8635.5%4-4065 WORKPLACE ACCOMMODATIONS-509 2,3742,500 2,500--1,865366.4%4-5026 COURSES & SEMINARS667 1,507 2,8891,291 3,5002,209 171.1% 1,382 91.7%4-5028 MEMBERSHIPS2,763 2,712 2,2493,635 3,635- - (463) (17.1%)4-5029 MILEAGE88--513513-- --4-5042 ADVERTISING-- 33,73315,000 15,000--33,733-4-5043 CONSULTING26,887 7,893 54,08022,500 18,000(4,500) (20.0%)46,187 585.2%4-5045 PHOTOCOPIER CHARGES3,239 2,929 2,7233,450 2,780(670) (19.4%) (206) (7.0%)4-5046 PRINTING-321-800800--(321)(100.0%)4-5056 PERSONNEL ADMINISTRATION23,301 18,214 24,92820,000 20,000- - 6,714 36.9%4-5059 CONTRACTS19,634 28,492 47,83624,462 63,00038,538 157.5% 19,344 67.9%4-6025 EMPLOYEE RECOGNITION-- 5,446- 4,5004,500-5,4460.0%4-6026 CORPORATE COURSES & SEMINARS2,787 19,426 25,29147,313 55,0007,687 16.2% 5,865 30.2%TOTAL OTHER EXPENSES 82,390 91,833 208,049 147,814 196,378 48,564 32.9% 116,216 126.6%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 16 of 19 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%TOTAL EXPENSES573,297 656,442 705,782 698,995 741,18242,1876.0%49,3407.5%NET BUDGET572,247 656,442 705,782 698,995 741,18242,1876.0%49,3407.5%Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 17 of 19 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/T-- 356,582356,655 362,6766,0211.7%356,582-4-2090 YEAR END ACCRUALS-- 6,858----6,858-4-2100 BENEFITS - OMERS-- 43,03942,703 43,4767731.8%43,039-4-2101 BENEFITS - EHT-- 6,9896,955 7,0721171.7%6,989-4-2102 BENEFITS - WSIB-- 1,8302,675 2,720451.7%1,830-4-2103 BENEFITS - CPP-- 7,6927,761 7,856951.2%7,692-4-2104 BENEFITS - EI-- 3,5124,066 3,582(484)(11.9%)3,512-4-2105 BENEFITS - DENTAL-- 5,4835,522 5,208(314)(5.7%)5,483-4-2106 BENEFITS - HEALTH-- 9,3748,578 8,9073293.8%9,374-4-2107 BENEFITS - LTD/ADD-- 5,1406,697 7,48278511.7%5,140-4-2108 BENEFITS - OTHER-- 1,6671,673 1,87119811.8%1,667-4-2201 SALARY SAVINGS----33,874 -33,874-- --TOTAL SALARIES & BENEFITS - - 448,166 409,411 416,976 7,565 1.8% 448,166-4-3000 PURCHASE CARD CLEARING- 1,775 -126--- - (1,901) (107.1%)4-4000 OFFICE SUPPLIES--4921,000 1,000--492-4-4004 SUBSCRIPTIONS/PUBLICATIONS--118200200--118-4-4006 OFFICE EQUIPMENT--197200200--197-4-4045 MUNICIPAL BUSINESS-- 1,7041,450 1,450--1,704-4-5026 COURSES & SEMINARS-- 2,7162,500 3,5001,00040.0%2,716-4-5028 MEMBERSHIPS-- 10,87112,000 12,000--10,871-4-5029 MILEAGE--220800800--220-4-5045 PHOTOCOPIER CHARGES-- 2,9001,400 2,00060042.9%2,900-TOTAL OTHER EXPENSES- 1,775 19,092 19,550 21,1501,6008.2%17,317975.6%TOTAL EXPENSES- 1,775 467,258 428,961 438,1269,1652.1%465,48326,224.4%NET BUDGET- 1,775 467,258 428,961 438,1269,1652.1%465,48326,224.4%Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 18 of 19 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:TOTAL SALARIES & BENEFITS - - - - - - - - -4-4015 OPERATING MATERIALS715 5,322 3,5579,000 9,000- - (1,765) (33.2%)4-5018 TELEPHONE LINES12,823 13,368 14,03714,000 14,250250 1.8% 669 5.0%TOTAL OTHER EXPENSES 13,538 18,690 17,594 23,000 23,250 250 1.1% (1,096) (5.9%)TOTAL EXPENSES 13,538 18,690 17,594 23,000 23,250 250 1.1% (1,096) (5.9%)NET BUDGET 13,538 18,690 17,594 23,000 23,250 250 1.1% (1,096) (5.9%)Dollar Change > +/- $20,000ANDPercentage Change > +/- 10% Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 1 Page 19 of 19 Memorandum Date: March 28, 2018 To: Finance Advisory Committee From: Dan Elliott, Director, Financial Services Re: Round Table Discussion: Proposed Changes to Procurement Thresholds Recommendation 1.That the memorandum regarding Round Table Discussion: Proposed Changes to Procurement Thresholds be received; and 2.That the comments of the Finance Advisory Committee be referred to staff for consideration and action as appropriate. Background The Financial Services Department has committed to both internal client staff and to Council to revisit the thresholds within the Town’s Procurement By-law. There are several thresholds to be reviewed. Attached is a table outlining the current, proposed and comparative information for various thresholds: •Page one addresses thresholds which determine the procurement approach to be used for a purchase. • Page two addresses the thresholds for the final approvals of procurements, including the role of Council. •The final page speaks to a proposed new maximum length of contracts, and a proposed new information report, and an increase in threshold for mandatory separate Town agreement. 100 John West Way Box 1000 Aurora, Ontario L4G 6J1 Phone: 905-727-4772 Email: delliott@aurora.ca www.aurora.ca Town of Aurora Financial Services Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 1 of 6 Round Table Discussion: Proposed Changes to Procurement Thresholds March 28, 2018 Page 2 of 2 This table, along with additional details, has been circulated for comments internally to staff involved in acquiring goods, services or construction for their departments. In doing so, it is appropriate that the Finance Advisory Committee also be provided the opportunity to provide comments at this proposal stage. Bear in mind that all purchases must have approved budgets in place to complete any contract award. This detail is already within our Procurement By-law. Financial Services has committed to presenting to Council final proposed changes in these areas in the second cycle of April. I look forward to discussing these proposed changes with the Committee, and in particular hearing comments and suggestions for our consideration as we prepare our final report for April. As you can appreciate, I want to propose something that speeds the procurement process for both client departments and the procurement team, alleviating red tape and process where practical, maintains or strengthens the integrity of our public process and opportunities for vendors, yet balances risk with cost of process, and balances staff authorities with Council’s role to keep a finger on the pulse of what’s going on inside Town Hall. The comparatives are provided for context. I look forward to our discussion. Attachments Attachment 1 – Proposed Procurement Threshold Changes Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 2 of 6 1 of 4Town of AuroraPage 1 of 4Proposed Procurement Threshold Changes20-Mar-18ComparativesCurrent ProposedYork Region RHillSudbury Newmarket MarkhamProcurement Process to be used:1)Under $5,000Under $10,000 (for consulting services: up to $25K)under $100K under $10K under $2K under $10K under $5KCurrent practice is to encourage three quotes. No Req. or PO required. Can pay with Pcard or invoice. Attach quotes to Invoice for payment.Threshold Change: also bring wording to match current practice - quotes not mandatory, but an option to consider - obtain best value, no Req., no PO.best value best value best value best value, PO or Pcard required($20K for Consulting)best value, (under $25K for consulting)Threshold applied to anticipated annual requirements of same or similar goods or services for the department.Threshold applied to anticipated annual requirements of same or similar goods or services for the department.(corporation wide analysis not practical.)$2K-$10K minimum one written quote, PO2)NEW: Over $10,000, but less than $25,000$100K - $150K$10K to $50K$5K to $25KNew requirement: mandatory three competitive written quotes, using Quick Quote form, attach three to invoice for payment, no Req, no PO. Note of explanation with invoice if did not use low quote. RFP's must be handled by Procurement. mandatory three written quotes, POmandatory three written quotes, POthree written quotes3)Over $5,000Over $25,000over $150K over $10K over $50K Over $10K Over $25,000Full market competitive procurement through Procurement Services. Client department responsible to prepare market ready detailed specifications and pricing sheet.Threshold Change only: same processfull competitive procurementfull competitive procurementfull competitive procurementfull competitive procurementfull competitive procurementStaff comments:1)Thresholds should be applicable to each purchase, not annual requirement or annual budget. Request for clarity in this regard in the bylaw.Response: While this practice is in place in some smaller jurisdictions, staff feel this leads to bid splitting to avoid public procurement processes, and limits opportunity to vendors. Recent third party review recommended clarity in our processes and bylaw in this regard.2) Threshold of $5,000 too low for practicality. Results in a lot of administration for public procurement process. Response: Agreed, recommending increase to $25,000, with new range of $10k to $25K requiring three written quotes obtained based on same information sent to all bidders. Under $10K is "best value" approach - discretion of staff.3) Will require some compliance audit processes and consequences for non-compliance. Response: Agreed. Will occur procedurally, not in the bylaw. Difficult to identify where bid splitting occurs, where under $10K purchases, or under $25K purchases are repeated for same or similar goods by the same department. Consequences and progressive discipline processes will be developed procedurally as well ad auditing processesFinance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 3 of 6 Town of AuroraPage 2 of 4Proposed Procurement Threshold Changes20-Mar-18ComparativesCurrent ProposedYork Region RHillSudbury Newmarket MarkhamPurchase/Award Authority 1)Under $5,000Under $25,000All awards based on staff approval authorities funding approval, low bid, etc.All awards based on staff approval authorities funding approval, low bid, etc.All awards based on staff approval authorities funding approval, low bid, etc.All awards based on staff approval authorities funding approval, low bid, etc. up to $350,000Client department approves, based on Pcard limits, or AP invoice approval authority. No Purchase Requisition or PO.Threshold Change only: same process2)$5,000 to $100,000$25,000 to Unlimited where low bid/high score and within budget, no litigationup to $500K Following Competitive process, client department approves based on AP invoice approval authority. Procurement issues PO.Threshold Change only: same process, but CAO approves all over $1millionclient dept(If not within budget, Council report still required for additional funding, but not the award.)3)Over $100,000low bid tenders no limit CAOMulti-year contracts exceeding five years, AND >$50K/yr require Council approvalover $250K over $350,000Council approval requiredRFP's over $2M Council approvalCAOTenders within Criteria - CAO Tenders outside criteria plus all RFP's over $350K -CouncilStaff comments:1) If project budget was approved, why does Council even need to see and approve RFPs and Tenders that are lowest compliant bidder/high score and fall within budget? Council report requirement adds 30 days to administration lead time for project, and adds unnecessarily to agenda, bogging down Council. Response: Agreed. Recommending staff approval all within budget less than $1million, with CAO approving above $1million. Wording changes will be required to delegate authority to execute Town agreement down to Director of department or CAO. To keep Council in the loop, adding new quarterly information reports on awards made over $250,000. If budget is insufficient for a contract award, no change is proposed, as the funding issue must still be addressed by a report to Council, but not the technical award of the contract.Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 4 of 6 3 of 4Town of AuroraPage 3 of 4Proposed Procurement Threshold Changes20-Mar-18ComparativesCurrent ProposedYork Region RHillSudbury Newmarket MarkhamSingle/Sole Source Awards1)Under $100,000Under $100,000under $150K under $50K under $50K under $25K under $50KSingle/sole source meets qualifications for same, approved by Director and Procurement Manager.minor change: see "Project Contingency" section below for change in application. Commissioner approval50-100K CAO onlyvarious levels various levelsAlso, where Procurement Manager is of the opinion does not meet qualifications for single/sole source, CAO may approve following discussion with Director and Procurement Manager.2) Over $100,000Over $100,000Over $150K to Councilover $100K to Councilover $50K to Council$25 to 50K to CAO, over $50K to Council$50K-350K to CAO, over $350K to CouncilCouncil approval requiredNo changeProcurement Contingency 1)10% increase to approved PO but aggregate PO still less than $100K20% increase to original PO to complete items in contract and specifications, aggregate PO still within budget.15% limited to projectseparate bylaw silentsilentsilentDirector approval - PO increase formNEW: must be to complete contract and specifications onlywithin budgetThis is not budget approval, budget must be approved by Council.Director approval on PO increase form.Director 15%, Comm $30%, CAO over 30%Current wording needs clean up last sentence.Wording to be clarified. To be strictly applied. Contingencies are for unknown conditions and items unspecified in contract, but required in order to complete the specifications of the contract. Not used for extras not specified or forgotten in scope of work. Scope changes, CAO approves up to lesser of 10% or $100K aggregate, else Council2)10% increase takes contract value over $100KIncreases more than 20% or for items not specified in contractCouncil approval required.CAO approval for any increase beyond aggregate 20%, within budget, for contingency or scope change items.Staff Comments:1) Currently, Procurement Manager has final approval authority for sole source/singe source purchases under $100K. Should have opportunity for arbitration with CAO discussion at discretion of Director after receiving written reasons from Manager of Procurement. Response: Agreed. Appproaching CAO will be at discretion of Director.3) Project contingency: 10% procurement contingency is too low. Should be able to spend up to budget to complete contract as specified. Response: Agreed needs clarification. Contingency wording to be modified for greater clarity and will be applied strictly. Recommending Director has 20% contingency, with CAO anything beyond for contingency, or for scope changes to project, subject to budget availability. Procedurally, will discuss whether total budget to be reduced at time of contract award: ie. budget is $2million, and contract comes in at $1.1: should all $900K remain available to complete project and contingencies? Tighter contingency requires greater diligence in project scoping and specification details. 2) Should be able to negotiate a purchase with a single source if deemed good value. Response: Opportunity for all vendors is a hallmark of public procurement and CETA freetrade agreements. Bylaw sets out criteria for single source, and sole source situations. These are highly consistent with comparator bylaws. No change to threshold for approval of single source/sole source contracts: greater than $100,000 requires Council approval.Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 5 of 6 4 of 4Town of AuroraPage 4 of 4Proposed Procurement Threshold Changes20-Mar-18ComparativesCurrent ProposedYork Region RHillSudbury Newmarket MarkhamDuration of Total Contract before remarketing work/service/goods1)No specified limitsNEW: Total term of contract, aggregate past, present and future renewals and option years, is maximum 7 years without competitively going to market. No limit if annual purchase less than $10K.terms over 5 years Council pre-approvalsilentExceeds 5 yrs AND $50K annual valuesilentExceeds four year termNo specified limitsPreapproval by Council required prior to going to market longer than 7 years total (i.e. solid waste), or extending/renewing beyond 7 years aggregate if annual purchase more than than $10K approval by Councilapproval by CouncilInformation Reports1)NEW: Awards by Administration over $250,000Over $150K semi-annual Over $50K semi-annually Over $50KReport only awards approved by CAO under delegated authority during Council recess or after nomination day.quarterly summary report by Procurement Services Division within proposed authorities. Continue report for approvals otherwise requiring Council approval made by CAO during recess or after nomination day.quarterly all single and sole source contracts"regular information reports"all over $250K plus all emergency purchases over $50K, plus all single and sole source awards.monthly report Requirement for Town Agreement1)Awards over $30,000 Awards over $50,000 several template agreementsOver $10K Over $50K Over $100K unclearRequires Town agreement prepared by Legal. Below threshold, agreement is optional for complex or high risk situations.Threshold change only: same process. Staff Comments:1) Issue of term limits introduced as an emerging best practice. Finds balance between vendor opportunity and practical contract term lengths. Seven years chosen, as would allow one full council term to be skipped without going to market. Without limit, nothing stopping a client department from entering a fifteen year contract as their preference. Limit of seven years not practical in all circumstances. Response: Proposal makes clear that longer than 7 years is permitted, but requires explanation to and approval by Council prior to going to market or making the commitment. Example is solid waste contract and inherent capital investment expected of vendor, so long term is industry norm. All contracts have clauses allowing for early termination by Town. Multi-year contracts can be structured with CPI escalation clauses, like the existing solid waste contract.2) Currently Procurement Bylaw does not permit staff to make purchases from on-line or live auctions, due to competitive bid requirements. Response: Staff are currently researching other municipalities permissions in this regard. Based on research of best and emerging practices, staff may include in final recommendations. Any such change will be hightlighted in the cover report to Council at that time.3) Requirement for town contract too low, adds administration, should be $100k. Response: In discussion with Legal and Risk Management staff, increase from $30K to $50K finds acceptable balance, as past experience shows a number of contractor performance and management issues arising in the $50K to $100K range, which would be much more difficult to resolve if without an agreement. Agreement requirement does not add substantively to process.Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 2 Page 6 of 6 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϭϬϲ>E^W&^;ϯϲϵ͕ϰϵϮͿ ;ϳϱ͕ϯϱϯͿ ;ϭϲϭ͕ϮϭϳͿ;ϲϱ͕ϬϬϬͿ ;ϲϱ͕ϬϬϬͿͲͲϴϱ͕ϴϲϰ ϭϭϯ͘ϵйϯͲϭϮϬϭKd,Z;ϮϭϮ͕ϭϵϳͿ ;ϭϵϬ͕ϴϬϮͿ ;Ϯϯϴ͕ϬϰϲͿ;ϮϭϬ͕ϬϱϯͿ ;Ϯϲϰ͕ϬϬϬͿϱϯ͕ϵϰϳ Ϯϱ͘ϳйϰϳ͕Ϯϰϰ Ϯϰ͘ϴйϯͲϭϮϬϱ^>^;ϭ͕ϴϬϵͿ ;Ϯ͕ϬϮϯͿ ;Ϯ͕ϵϴϳͿ;ϯ͕ϬϬϬͿ ;ϯ͕ϬϬϬͿͲ Ͳ ϵϲϰ ϰϳ͘ϳйϯͲϭϮϬϲKEd/KE^Ͳ ;ϲϳϴͿ ;ϯϱϬͿͲͲͲ Ͳ ;ϯϮϴͿ ;ϰϴ͘ϰйͿϯͲϭϯϬϯ>>/DKEͬ^KZ&/>^;ϭϲϵ͕ϯϲϴͿ ;ϭϳϴ͕ϲϮϱͿ ;ϭϴϲ͕ϱϳϵͿ;ϭϲϰ͕ϯϴϭͿ ;ϭϲϰ͕ϯϴϭͿͲ Ͳ ϳ͕ϵϱϰ ϰ͘ϱйϯͲϭϯϬϰ'Z^^hdd/E';ϭϯϳ͕ϬϭϬͿͲͲͲͲͲͲ ͲͲϯͲϭϯϯϯKEdZ/hd/KE^&ZKDs>KWZ^;ϯϱϯ͕ϮϬϴͿ ;ϮϬϲ͕ϴϯϳͿ ;ϳϮ͕ϴϳϱͿͲͲͲͲ;ϭϯϯ͕ϵϲϮͿ ;ϲϰ͘ϴйͿϯͲϭϴϬϯKd,Z'ZEd^;Ϯϰϳ͕ϬϬϲͿ ;Ϯϰϰ͕ϯϯϰͿ ;Ϯϯϳ͕ϬϲϭͿ;ϮϲϬ͕ϬϬϬͿ ;ϮϲϬ͕ϬϬϬͿͲ Ͳ ;ϳ͕ϮϳϯͿ ;ϯ͘ϬйͿϯͲϭϵϭϳE'/EZ/E'KEdZ/hd/KE;ϳϬ͕ϬϬϬͿͲͲͲͲͲͲ ͲͲϯͲϭϵϯϯ>E^W&Z^ZsKEdΖE;Ϯϭ͕ϯϬϬͿ ;ϭϳ͕ϴϳϮͿ ;ϭϱ͕ϴϴϱͿ;ϭϱ͕ϴϴϱͿ ;ϭϯ͕ϴϳϳͿ;Ϯ͕ϬϬϴͿ ;ϭϮ͘ϲйͿ ;ϭ͕ϵϴϳͿ ;ϭϭ͘ϭйͿϯͲϭϵϲϯWZ<^sΘ&KEdΖE;ϭϱϰ͕ϰϮϱͿ ;ϭϭϲ͕ϮϱϳͿ ;ϭϯϲ͕ϭϱϲͿ;ϭϯϲ͕ϭϱϲͿ ;ϭϭϱ͕ϲϰϬͿ;ϮϬ͕ϱϭϲͿ ;ϭϱ͘ϭйͿ ϭϵ͕ϴϵϵ ϭϳ͘ϭйdŽƚĂůZĞǀĞŶƵĞ ;ϭ͕ϳϯϱ͕ϴϭϱͿ ;ϭ͕ϬϯϮ͕ϳϴϭͿ ;ϭ͕Ϭϱϭ͕ϭϱϲͿ ;ϴϱϰ͕ϰϳϱͿ ;ϴϴϱ͕ϴϵϴͿ ϯϭ͕ϰϮϯ ϯ͘ϳй ϭϴ͕ϯϳϱ ϭ͘ϴйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϮ͕ϳϵϳ͕ϮϮϯ ϯ͕Ϭϳϲ͕ϱϵϴ Ϯ͕ϵϯϵ͕Ϭϳϲϯ͕Ϭϱϴ͕ϴϮϬ ϯ͕Ϭϴϵ͕ϲϱϲϯϬ͕ϴϯϲ ϭ͘Ϭй ;ϭϯϳ͕ϱϮϮͿ ;ϰ͘ϱйͿϰͲϮϬϬϭ^>Z/^ͲKͬdϭϯϲ͕Ϭϲϲ ϭϯϰ͕Ϭϵϭ ϭϮϵ͕ϰϭϳϭϬϴ͕ϯϱϬ ϭϬϴ͕ϯϱϬͲ Ͳ ;ϰ͕ϲϳϰͿ ;ϯ͘ϱйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϱϯϬ͕Ϯϭϱ ϮϴϬ͕ϲϴϳ ϲϮϭ͕ϲϬϬϱϱϬ͕Ϯϭϭ ϱϵϭ͕ϴϭϲϰϭ͕ϲϬϱ ϳ͘ϲйϯϰϬ͕ϵϭϯ ϭϮϭ͘ϱйϰͲϮϬϬϯsd/KEWzͲ Ϯϭ͕ϭϳϱͲͲͲͲͲ;Ϯϭ͕ϭϳϱͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲ ϰ͕ϴϲϳͲͲͲͲͲ;ϰ͕ϴϲϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϱ>/hd/DͲ ϭ͕ϰϴϳͲͲͲͲͲ;ϭ͕ϰϴϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^ϳ͕ϴϮϵ ϭϬ͕Ϭϵϲ ϭϭ͕ϭϬϱͲͲͲ Ͳ ϭ͕ϬϬϵ ϭϬ͘ϬйϰͲϮϭϬϬE&/d^ͲKDZ^Ϯϵϭ͕ϲϬϱ ϯϰϴ͕ϰϳϲ ϯϬϵ͕ϬϵϵϯϬϱ͕ϳϱϲ ϯϭϴ͕ϱϵϴϭϮ͕ϴϰϮ ϰ͘Ϯй;ϯϵ͕ϯϳϳͿ ;ϭϭ͘ϯйͿϰͲϮϭϬϭE&/d^Ͳ,dϲϳ͕ϲϯϰ ϳϴ͕ϱϵϭ ϳϭ͕ϴϭϵϳϬ͕ϯϭϵ ϳϯ͕ϮϰϳϮ͕ϵϮϴ ϰ͘Ϯй ;ϲ͕ϳϳϮͿ ;ϴ͘ϲйͿϰͲϮϭϬϮE&/d^Ͳt^/Ϯϳ͕ϲϳϴ Ϯϴ͕ϱϯϬ Ϯϲ͕ϲϰϲϮϳ͕Ϭϰϱ Ϯϴ͕ϭϳϮϭ͕ϭϮϳ ϰ͘Ϯй ;ϭ͕ϴϴϰͿ ;ϲ͘ϲйͿϰͲϮϭϬϯE&/d^ͲWWϭϮϰ͕ϲϱϭ ϭϯϵ͕ϴϱϳ ϭϯϰ͕ϬϬϱϭϯϭ͕ϴϮϱ ϭϯϳ͕ϭϲϰϱ͕ϯϯϵ ϰ͘ϭй ;ϱ͕ϴϱϮͿ ;ϰ͘ϮйͿϰͲϮϭϬϰE&/d^Ͳ/ϲϳ͕ϬϴϬ ϳϱ͕Ϭϳϲ ϲϮ͕ϲϲϳϳϮ͕ϲϯϴ ϲϴ͕Ϭϴϵ;ϰ͕ϱϰϵͿ ;ϲ͘ϯйͿ ;ϭϮ͕ϰϬϵͿ ;ϭϲ͘ϱйͿϰͲϮϭϬϱE&/d^ͲEd>ϲϱ͕ϬϴϬ ϲϳ͕ϱϬϰ ϲϭ͕ϭϯϱϳϳ͕Ϭϱϲ ϳϰ͕ϱϳϵ;Ϯ͕ϰϳϳͿ ;ϯ͘ϮйͿ ;ϲ͕ϯϲϵͿ ;ϵ͘ϰйͿϰͲϮϭϬϲE&/d^Ͳ,>d,ϭϭϮ͕ϴϲϬ ϭϮϳ͕ϴϱϳ ϭϭϮ͕ϲϭϵϭϭϵ͕ϲϴϳ ϭϮϳ͕ϱϰϱϳ͕ϴϱϴ ϲ͘ϲй ;ϭϱ͕ϮϯϴͿ ;ϭϭ͘ϵйͿϰͲϮϭϬϳE&/d^Ͳ>dͬϰϲ͕ϴϮϮ ϱϰ͕ϱϮϱ ϰϲ͕ϭϮϭϱϭ͕ϭϯϰ ϱϴ͕ϯϲϵϳ͕Ϯϯϱ ϭϰ͘ϭй ;ϴ͕ϰϬϰͿ ;ϭϱ͘ϰйͿϰͲϮϭϬϴE&/d^ͲKd,Zϭϯ͕ϱϲϭ ϭϱ͕ϴϭϴ ϭϯ͕Ϭϳϵϭϯ͕ϵϯϬ ϭϱ͕ϵϯϳϮ͕ϬϬϳ ϭϰ͘ϰй ;Ϯ͕ϳϯϵͿ ;ϭϳ͘ϯйͿϰͲϮϮϬϬt'ZKsZz;ϵϱϰͿ ;ϯ͕ϳϲϱͿͲͲͲͲͲϯ͕ϳϲϱϭϬϬ͘ϬйϰͲϮϮϬϭ^>Zz^s/E'^ͲͲͲ;ϯϵ͕ϮϭϭͿ ;ϯϵ͕ϮϭϭͿͲͲ ͲͲdKd>^>Z/^ΘE&/d^ ϰ͕Ϯϴϳ͕ϯϱϬ ϰ͕ϰϲϭ͕ϰϳϬ ϰ͕ϱϯϴ͕ϯϴϴ ϰ͕ϱϰϳ͕ϱϲϬ ϰ͕ϲϱϮ͕ϯϭϭϭϬϰ͕ϳϱϭϮ͘ϯйϳϲ͕ϵϭϴϭ͘ϳйϰͲϮϯϬϬ/EdZE>Yh/WDEdZEd>;Ϯϯϯ͕ϲϱϵͿ ;Ϯϯϰ͕ϭϱϵͿ ;Ϯϯϯ͕ϲϱϵͿ;Ϯϯϯ͕ϲϱϵͿ ;Ϯϯϯ͕ϲϱϵͿͲ Ͳ ϱϬϬ Ϭ͘ϮйϰͲϮϯϬϮ/EdZE>&h>ZKsZz;ϯϯ͕ϮϮϳͿ ;ϭϮ͕ϳϰϴͿ ;ϴ͕ϯϯϵͿ;ϰϬ͕ϬϬϬͿ ;ϰϬ͕ϬϬϬͿͲ Ͳ ϰ͕ϰϬϵ ϯϰ͘ϲйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 1 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬйϰͲϯϬϬϬWhZ,^Z>Z/E'ϭ͕ϰϴϴ ϭ͕Ϯϳϱ;ϭϯͿͲͲͲͲ;ϭ͕ϮϴϴͿ;ϭϬϭ͘ϬйͿϰͲϰϬϬϬK&&/^hWW>/^ϭϬ͕ϳϮϱ ϴ͕ϬϭϬ ϳ͕ϲϳϰϭϭ͕ϯϱϬ ϭϭ͕ϯϱϬͲ Ͳ ;ϯϯϲͿ ;ϰ͘ϮйͿϰͲϰϬϬϰ^h^Z/Wd/KE^ͬWh>/d/KE^ϭ͕ϬϮϰϭϱϰϱϭϭϴϬϬϲϱϬ;ϭϱϬͿ;ϭϴ͘ϴйͿϯϱϳϮϯϭ͘ϴйϰͲϰϬϬϳKDWhdZ^hWW>/^ϲϭϵϯϳϵϱϬϬͲ;ϱϬϬͿ;ϭϬϬ͘ϬйͿ;ϭϰͿ;ϭϱ͘ϭйͿϰͲϰϬϬϵ^&dz^hWW>/^ϱ͕ϮϬϴ ϲ͕ϴϰϬ ϳ͕ϯϮϲϳ͕ϮϬϬ ϳ͕ϱϬϬϯϬϬ ϰ͘Ϯй ϰϴϲ ϳ͘ϭйϰͲϰϬϭϬ>Kd,/E'>>KtEϳ͕ϲϯϵ ϭϯ͕ϴϱϭ ϮϮ͕ϲϳϵϮϲ͕ϲϬϬ ϭϵ͕ϬϬϬ;ϳ͕ϲϬϬͿ ;Ϯϴ͘ϲйͿ ϴ͕ϴϮϴ ϲϯ͘ϳйϰͲϰϬϭϯhd/>/d/^ϳϲϯ͕ϮϮϲ ϲϬϯ͕ϴϵϲ ϰϱϴ͕ϮϯϰϮϳϬ͕ϬϬϬ ϰϲϴ͕ϯϭϭϭϵϴ͕ϯϭϭ ϳϯ͘ϰй;ϭϰϱ͕ϲϲϮͿ ;Ϯϰ͘ϭйͿϰͲϰϬϭϱKWZd/E'DdZ/>^ϰϮϭ͕Ϯϵϴ ϱϬϰ͕ϰϲϬ ϵϬϮ͕ϵϱϴϰϴϯ͕ϰϬϬ ϰϵϮ͕ϬϬϬϴ͕ϲϬϬ ϭ͘ϴйϯϵϴ͕ϰϵϴ ϳϵ͘ϬйϰͲϰϬϭϴ>/E^^ϮϬ͕ϵϳϭ Ϯϭ͕ϴϬϬ Ϯϴ͕ϳϲϴϮϮ͕ϬϬϬ Ϯϰ͕ϬϬϬϮ͕ϬϬϬ ϵ͘ϭй ϲ͕ϵϲϴ ϯϮ͘ϬйϰͲϰϬϭϵs,/>^hWW>/^ϮϮϭ͕ϴϮϬ Ϯϵϵ͕ϰϱϲ ϯϯϱ͕ϯϲϮϮϯϱ͕ϬϬϬ ϯϭϰ͕ϬϬϬϳϵ͕ϬϬϬ ϯϯ͘ϲйϯϱ͕ϵϬϲ ϭϮ͘ϬйϰͲϰϬϮϭYh/WDEdͲKd,Zϭϭ͕ϯϲϲ ϯϲ͕ϲϮϱ Ϯϱ͕ϮϰϲϮϭ͕ϱϬϬ Ϯϭ͕ϱϬϬͲ Ͳ ;ϭϭ͕ϯϳϵͿ ;ϯϭ͘ϭйͿϰͲϰϬϮϮdKK>^ϲ͕Ϯϯϰ ϭϬ͕Ϯϭϴ ϱ͕ϯϱϰϮϮ͕ϬϬϬ ϴ͕ϬϬϬ;ϭϰ͕ϬϬϬͿ ;ϲϯ͘ϲйͿ ;ϰ͕ϴϲϰͿ ;ϰϳ͘ϲйͿϰͲϰϬϮϯWd,tzD/EdEEDdZ/>^ϰϬ͕ϵϰϮ ϭϱ͕ϰϱϱ ϯϵ͕ϱϯϳϰϮ͕ϯϬϬ ϰϮ͕ϯϬϬͲͲϮϰ͕ϬϴϮ ϭϱϱ͘ϴйϰͲϰϬϮϰ&EDdZ/>^ϰ͕ϯϴϵ ϲ͕ϯϱϳ ϵ͕ϮϱϮϭϭ͕ϬϬϬ ϭϭ͕ϬϬϬͲ Ͳ Ϯ͕ϴϵϱ ϰϱ͘ϱйϰͲϰϬϰϱDhE//W>h^/E^^ϱ͕ϲϱϭ ϳ͕ϴϬϴ ϯ͕ϯϳϳϮ͕ϴϬϬ Ϯ͕ϯϱϬ;ϰϱϬͿ ;ϭϲ͘ϭйͿ ;ϰ͕ϰϯϭͿ ;ϱϲ͘ϳйͿϰͲϰϬϰϴ&h>K^d^ϭϴϬ͕ϱϮϳ ϭϰϳ͕ϲϴϯ ϭϳϵ͕ϳϵϵϮϮϬ͕ϬϬϬ ϭϱϱ͕ϬϬϬ;ϲϱ͕ϬϬϬͿ ;Ϯϵ͘ϱйͿϯϮ͕ϭϭϲ Ϯϭ͘ϳйϰͲϰϬϰϵ^/'E'ϰ͕ϯϮϮ ϭ͕ϱϮϴ ϰ͕ϲϰϵϱ͕ϬϬϬ ϱ͕ϬϬϬͲ Ͳ ϯ͕ϭϮϭ ϮϬϰ͘ϯйϰͲϰϬϱϬ&/>W/Edϭϲ͕Ϭϲϭ ϭϯ͕ϳϴϲ Ϯϭ͕ϲϲϭϭϳ͕ϬϬϬ ϭϴ͕ϬϬϬϭ͕ϬϬϬ ϱ͘ϵй ϳ͕ϴϳϱ ϱϳ͘ϭйϰͲϰϬϱϭ,KZd/h>dhZWZK'ZDϭϬ͕ϯϳϭ ϭϱ͕ϲϯϬ ϭϰ͕ϰϱϭϭϱ͕ϬϬϬ ϭϱ͕ϬϬϬͲ Ͳ ;ϭ͕ϭϳϵͿ ;ϳ͘ϱйͿϰͲϰϬϱϮ&Zdͬ'Z^^^ϭϱ͕ϵϯϵ ϭϳ͕ϰϴϵ ϭϳ͕ϲϮϯϯϯ͕ϬϬϬ ϯϯ͕ϬϬϬͲ Ͳ ϭϯϰ Ϭ͘ϴйϰͲϰϬϱϯWZ<>ͬ>/',d/E'ϭϴ͕ϴϵϴ ϭϲ͕ϲϱϭ ϭϲ͕ϯϴϴϭϰ͕ϬϬϬ ϭϰ͕ϬϬϬͲ Ͳ ;ϮϲϯͿ ;ϭ͘ϲйͿϰͲϰϬϱϰ/ZZ/'d/KEϰ͕Ϯϳϳ Ϯ͕ϰϰϳ ϭ͕ϭϯϵϱ͕ϭϬϬ ϱ͕ϭϬϬͲ Ͳ ;ϭ͕ϯϬϴͿ ;ϱϯ͘ϱйͿϰͲϰϬϱϵDzKZΖ^Ed/>/ddZDW/'Eϭϯϴ ϯ͕ϱϲϯ Ϯ͕Ϭϭϴϰ͕ϬϬϬ ϱ͕ϬϬϬϭ͕ϬϬϬ Ϯϱ͘Ϭй ;ϭ͕ϱϰϱͿ ;ϰϯ͘ϰйͿϰͲϱϬϬϭKE&ZE^Ϯ͕ϴϲϮͲ Ϯ͕ϲϲϰϯ͕ϬϬϬ ϭ͕ϲϬϬ;ϭ͕ϰϬϬͿ;ϰϲ͘ϳйͿϮ͕ϲϲϰͲϰͲϱϬϮϲKhZ^^Θ^D/EZ^ϰϲ͕ϭϯϵ ϳ͕Ϭϴϵ ϭϲ͕ϴϰϰϭϰ͕ϵϲϭ ϭϮ͕ϰϬϬ;Ϯ͕ϱϲϭͿ ;ϭϳ͘ϭйͿ ϵ͕ϳϱϱ ϭϯϳ͘ϲйϰͲϱϬϮϴDDZ^,/W^ϭϭ͕ϲϭϬ ϭϬ͕Ϭϱϭ ϲ͕ϳϰϰϭϭ͕ϱϬϬ ϴ͕ϮϬϬ;ϯ͕ϯϬϬͿ ;Ϯϴ͘ϳйͿ ;ϯ͕ϯϬϳͿ ;ϯϮ͘ϵйͿϰͲϱϬϮϵD/>'ϭϲ͕ϱϱϰ ϭϲ͕Ϭϴϯ ϭϰ͕ϭϴϮϭϬ͕ϳϱϬ ϭ͕ϳϱϬ;ϵ͕ϬϬϬͿ ;ϴϯ͘ϳйͿ ;ϭ͕ϵϬϭͿ ;ϭϭ͘ϴйͿϰͲϱϬϯϮs,/>ZW/Z^ϯϵ͕ϴϰϴ ϯϰ͕ϲϰϵ ϳϵ͕ϲϵϯϱϬ͕ϬϬϬ ϱϬ͕ϬϬϬͲͲϰϱ͕Ϭϰϰ ϭϯϬ͘ϬйϰͲϱϬϯϳWZKWZdz/DWZKsDEdϭϲ͕ϵϮϴ Ϯϯ͕ϭϮϳ Ϯϵ͕ϯϰϴϯϬ͕ϬϬϬ ϰϬ͕ϬϬϬϭϬ͕ϬϬϬ ϯϯ͘ϯй ϲ͕ϮϮϭ Ϯϲ͘ϵйϰͲϱϬϯϴh/>/E'ZW/ZΘD/EdEEϭϲ͕Ϭϴϲ ϭϵ͕ϬϮϮ ϮϬ͕ϳϭϰϮϭ͕ϬϬϬ Ϯϭ͕ϬϬϬͲ Ͳ ϭ͕ϲϵϮ ϴ͘ϵйϰͲϱϬϯϵ/E^hZE&^Ϯϱ͕ϬϬϬ Ϯϰ͕ϰϴϰ Ϯϰ͕ϲϯϮϮϱ͕ϬϬϬ Ϯϲ͕ϬϬϬϭ͕ϬϬϬ ϰ͘Ϭй ϭϰϴ Ϭ͘ϲйϰͲϱϬϰϮsZd/^/E'ϭϰ͕ϲϮϵ ϭϴ͕ϵϱϰ Ϯϰ͕ϰϭϯϮϲ͕ϬϬϬ Ϯϲ͕ϬϬϬͲ Ͳ ϱ͕ϰϱϵ Ϯϴ͘ϴйϰͲϱϬϰϯKE^h>d/E'ϰϱ͕ϰϰϯ ϵ͕ϳϭϯ ϱ͕ϭϭϲϭϱ͕ϬϬϬ ϭϱ͕ϬϬϬͲ Ͳ ;ϰ͕ϱϵϳͿ ;ϰϳ͘ϯйͿϰͲϱϬϰϱW,KdKKW/Z,Z'^ϭϭ͕ϱϳϱ ϭϮ͕ϱϳϴ ϭϯ͕Ϭϵϴϭϭ͕ϱϰϳ ϵ͕ϬϱϬ;Ϯ͕ϰϵϳͿ ;Ϯϭ͘ϲйͿ ϱϮϬ ϰ͘ϭйϰͲϱϬϰϳWhZ,^K&dZ^ϱϬ͕ϰϵϵ ϴϳ͕ϭϬϭ ϱϮ͕ϳϴϭϱϬ͕ϬϬϬ ϱϬ͕ϬϬϬͲͲ;ϯϰ͕ϯϮϬͿ ;ϯϵ͘ϰйͿϰͲϱϬϱϵKEdZd^Ϯ͕Ϭϲϯ͕ϬϰϮ Ϯ͕ϬϴϬ͕Ϭϰϴ Ϯ͕Ϭϱϰ͕ϭϯϬϮ͕Ϭϲϱ͕ϴϱϬ Ϯ͕ϰϵϬ͕ϬϯϬϰϮϰ͕ϭϴϬ ϮϬ͘ϱй ;Ϯϱ͕ϵϭϴͿ ;ϭ͘ϮйͿϰͲϱϬϲϬK^dZKsZz;ϭϱϰͿ ;ϯ͕ϰϯϬͿ ;Ϯ͕ϬϬϴͿͲͲͲ Ͳ ϭ͕ϰϮϮ ϰϭ͘ϱй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 2 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬйϰͲϱϬϲϮK>>d/KEKEdZd^ϭ͕ϯϯϭ͕ϯϴϰ ϭ͕ϭϲϮ͕Ϯϵϴ ϭ͕ϯϵϰ͕ϲϴϮϭ͕ϯϭϮ͕ϬϬϬ ϭ͕ϯϲϬ͕ϬϬϬϰϴ͕ϬϬϬ ϯ͘ϳйϮϯϮ͕ϯϴϰ ϮϬ͘ϬйϰͲϱϬϲϯt^d/^WK^>&ϭϰ͕ϵϰϬ ϭϰ͕ϯϰϮ ϭϮ͕ϵϰϳϭϴ͕ϬϬϬ ϭϴ͕ϬϬϬͲ Ͳ ;ϭ͕ϯϵϱͿ ;ϵ͘ϳйͿϰͲϱϬϲϰKEdZd^Ͳ'Z^^hdd/E'Ϯϳ͕ϱϰϲ ϵ͕ϲϮϳ ϭϯ͕ϭϱϯϮϬ͕ϬϬϬ ϮϬ͕ϬϬϬͲ Ͳ ϯ͕ϱϮϲ ϯϲ͘ϲйϰͲϱϬϳϳZ>dzdy^ϱϬ͕ϲϭϯ ϱϬ͕ϵϵϮͲͲͲͲͲ;ϱϬ͕ϵϵϮͿ;ϭϬϬ͘ϬйͿϰͲϱϬϴϲ^hZ/dzϯϬ͕Ϯϭϯ ϯϱ͕ϱϵϵ ϭϯ͕ϮϬϴͲͲͲͲ;ϮϮ͕ϯϵϭͿ ;ϲϮ͘ϵйͿϰͲϱϬϴϳZKZ/h>dhZ>KEdZdϮϰ͕ϮϱϮ ϭϴ͕ϯϯϬ ϰϱ͕ϳϭϴϲϬ͕ϬϬϬ ϱϬ͕ϬϬϬ;ϭϬ͕ϬϬϬͿ ;ϭϲ͘ϳйͿϮϳ͕ϯϴϴ ϭϰϵ͘ϰйϰͲϱϬϴϴ^,ZhD/EdEEϵϲ͕ϳϲϰ ϰϰ͕ϰϴϳ ϴϳ͕ϵϵϲϳϱ͕ϬϬϬ ϲϱ͕ϬϬϬ;ϭϬ͕ϬϬϬͿ ;ϭϯ͘ϯйͿϰϯ͕ϱϬϵ ϵϳ͘ϴйϰͲϲϬϬϬW/d>>KEZWzDEdͲ ϭϰϲ͕ϯϮϬ Ϯϵϳ͕ϲϴϲϮϵϳ͕ϲϴϲ ϯϬϰ͕ϱϰϮϲ͕ϴϱϲ Ϯ͘ϯйϭϱϭ͕ϯϲϲ ϭϬϯ͘ϰйϰͲϲϬϬϭE<,Z'^Ͳ ϰϭ͕ϵϮϯ ϲϵ͕ϳϴϱϲϵ͕ϳϴϱ ϲϮ͕ϵϯϬ;ϲ͕ϴϱϱͿ ;ϵ͘ϴйͿϮϳ͕ϴϲϮ ϲϲ͘ϱйϰͲϲϬϬϮd/sEd,Z'^E&^ͲͲ ϭ͕ϮϭϰͲϱϴϲϱϴϲͲϭ͕ϮϭϰͲϰͲϴϬϬϯKEdZ/hd/KE^dK/^Zd/KEZzZ^Zs^ϳϯϴ͕ϳϯϬ ϮϴϮ͕ϰϲϬ ϯϰϭ͕ϳϱϵϴϭ͕Ϯϭϭ ϴϭ͕ϮϭϭͲͲϱϵ͕Ϯϵϵ Ϯϭ͘ϬйdKd>Kd,ZyWE^^ ϲ͕ϭϴϬ͕ϭϵϮ ϱ͕ϲϱϰ͕Ϭϭϱ ϲ͕ϰϴϮ͕ϱϳϯ ϱ͕ϰϲϰ͕ϭϴϭ ϲ͕ϭϭϭ͕ϳϬϭ ϲϰϳ͕ϱϮϬ ϭϭ͘ϵй ϴϮϴ͕ϱϱϴ ϭϰ͘ϳйdKd>yWE^^ ϭϬ͕ϰϲϳ͕ϱϰϮ ϭϬ͕ϭϭϱ͕ϰϴϱ ϭϭ͕ϬϮϬ͕ϵϲϭ ϭϬ͕Ϭϭϭ͕ϳϰϭ ϭϬ͕ϳϲϰ͕ϬϭϮ ϳϱϮ͕Ϯϳϭ ϳ͘ϱй ϵϬϱ͕ϰϳϲ ϵ͘ϬйEdh'd ϴ͕ϳϯϭ͕ϳϮϳ ϵ͕ϬϴϮ͕ϳϬϰ ϵ͕ϵϲϵ͕ϴϬϱ ϵ͕ϭϱϳ͕Ϯϲϲ ϵ͕ϴϳϴ͕ϭϭϰ ϳϮϬ͕ϴϰϴ ϳ͘ϵйϴϴϳ͕ϭϬϭϵ͘ϴйFinance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 3 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϯϯ͕ϭϳϮͿ ;Ϯϰ͕ϭϳϭͿ ;Ϯϰ͕ϰϯϮͿ;ϯϱ͕ϬϱϯͿ ;ϯϱ͕ϬϬϬͿ;ϱϯͿ ;Ϭ͘ϮйͿ Ϯϲϭ ϭ͘ϭйdŽƚĂůZĞǀĞŶƵĞ ;ϯϯ͕ϭϳϮͿ ;Ϯϰ͕ϭϳϭͿ ;Ϯϰ͕ϰϯϮͿ ;ϯϱ͕ϬϱϯͿ ;ϯϱ͕ϬϬϬͿ ;ϱϯͿ ;Ϭ͘ϮйͿϮϲϭ ϭ͘ϭйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϯϯϰ͕ϭϬϴ ϯϱϲ͕ϰϭϮ ϯϴϯ͕ϰϵϴϯϵϲ͕ϮϯϮ ϰϮϲ͕ϵϵϭϯϬ͕ϳϱϵ ϳ͘ϴй Ϯϳ͕Ϭϴϲ ϳ͘ϲйϰͲϮϬϬϭ^>Z/^ͲKͬdͲϴϯϯϬϴͲͲͲͲϮϮϱϮϳϭ͘ϭйϰͲϮϬϬϮ^>Z/^ͲWͬdϭϯ͕ϭϰϯ ϱϴ͕ϵϭϮ ϭ͕ϭϭϴϯ͕ϲϭϰ ϯ͕ϳϰϲϭϯϮ ϯ͘ϳй;ϱϳ͕ϳϵϰͿ ;ϵϴ͘ϭйͿϰͲϮϬϬϯsd/KEWzͲϴϯϭͲͲͲͲͲ;ϴϯϭͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲϲϵϮͲͲͲͲͲ;ϲϵϮͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^ϵ͕ϰϵϬ ;ϭϭ͕ϴϬϵͿ ϭϲ͕ϬϱϱͲͲͲͲϮϳ͕ϴϲϰ Ϯϯϲ͘ϬйϰͲϮϭϬϬE&/d^ͲKDZ^ϯϴ͕Ϭϳϲ ϭϬϱ͕ϱϬϵ ϰϬ͕ϭϭϮϰϰ͕ϳϯϰ ϰϴ͕ϳϲϬϰ͕ϬϮϲ ϵ͘Ϭй;ϲϱ͕ϯϵϳͿ ;ϲϮ͘ϬйͿϰͲϮϭϬϭE&/d^Ͳ,dϲ͕ϳϵϬ ϭϵ͕ϯϳϴ ϳ͕ϭϯϵϳ͕ϳϵϰ ϴ͕ϯϵϱϲϬϭ ϳ͘ϳй ;ϭϮ͕ϮϯϵͿ ;ϲϯ͘ϮйͿϰͲϮϭϬϮE&/d^Ͳt^/Ϯ͕ϰϯϴ ϲ͕Ϯϲϲ Ϯ͕ϰϳϳϮ͕ϵϵϴ ϯ͕ϮϮϵϮϯϭ ϳ͘ϳй ;ϯ͕ϳϴϵͿ ;ϲϬ͘ϱйͿϰͲϮϭϬϯE&/d^ͲWWϵ͕ϲϳϱ Ϯϰ͕Ϯϯϴ ϭϬ͕ϵϱϵϭϬ͕ϵϲϵ ϭϭ͕ϯϲϱϯϵϲ ϯ͘ϲй ;ϭϯ͕ϮϳϵͿ ;ϱϰ͘ϴйͿϰͲϮϭϬϰE&/d^Ͳ/ϱ͕ϭϱϳ ϭϮ͕ϳϭϴ ϱ͕ϬϭϬϱ͕ϳϴϰ ϱ͕ϮϮϴ;ϱϱϲͿ ;ϵ͘ϲйͿ ;ϳ͕ϳϬϴͿ ;ϲϬ͘ϲйͿϰͲϮϭϬϱE&/d^ͲEd>ϳ͕ϱϰϰ ϭϯ͕ϵϴϲ ϲ͕ϵϳϱϳ͕ϳϯϭ ϳ͕ϰϲϱ;ϮϲϲͿ ;ϯ͘ϰйͿ ;ϳ͕ϬϭϭͿ ;ϱϬ͘ϭйͿϰͲϮϭϬϲE&/d^Ͳ,>d,ϭϮ͕ϱϵϰ Ϯϳ͕ϵϭϭ ϭϭ͕ϵϳϲϭϮ͕ϬϬϵ ϭϮ͕ϳϲϲϳϱϳ ϲ͘ϯй ;ϭϱ͕ϵϯϱͿ ;ϱϳ͘ϭйͿϰͲϮϭϬϳE&/d^Ͳ>dͬϱ͕ϲϬϴ ϭϱ͕ϲϰϯ ϱ͕ϲϲϱϳ͕ϰϰϬ ϴ͕ϴϬϵϭ͕ϯϲϵ ϭϴ͘ϰй ;ϵ͕ϵϳϴͿ ;ϲϯ͘ϴйͿϰͲϮϭϬϴE&/d^ͲKd,Zϭ͕ϴϭϭ ϰ͕Ϯϱϭ ϭ͕ϱϴϵϭ͕ϴϱϵ Ϯ͕ϮϬϯϯϰϰ ϭϴ͘ϱй ;Ϯ͕ϲϲϮͿ ;ϲϮ͘ϲйͿϰͲϮϮϬϭ^>Zz^s/E'^ͲͲͲ;ϯϵ͕ϮϭϭͿ ;ϯϵ͕ϮϭϭͿͲͲ ͲͲdKd>^>Z/^ΘE&/d^ ϰϰϲ͕ϰϯϰ ϲϯϱ͕ϬϮϭ ϰϵϮ͕ϴϴϭ ϰϲϭ͕ϵϱϯ ϰϵϵ͕ϳϰϲ ϯϳ͕ϳϵϯ ϴ͘Ϯй ;ϭϰϮ͕ϭϰϬͿ ;ϮϮ͘ϰйͿϰͲϯϬϬϬWhZ,^Z>Z/E'ϭ͕ϰϴϴ ϭ͕Ϯϳϱ;ϭϯͿͲͲͲͲ;ϭ͕ϮϴϴͿ;ϭϬϭ͘ϬйͿϰͲϰϬϬϬK&&/^hWW>/^ϵ͕ϬϮϬ ϲ͕ϲϮϰ ϱ͕ϵϬϮϵ͕ϱϬϬ ϵ͕ϱϬϬͲ Ͳ ;ϳϮϮͿ ;ϭϬ͘ϵйͿϰͲϰϬϬϰ^h^Z/Wd/KE^ͬWh>/d/KE^ϭ͕ϬϮϰϭϱϰϱϭϭϴϬϬϲϱϬ;ϭϱϬͿ;ϭϴ͘ϴйͿϯϱϳϮϯϭ͘ϴйϰͲϰϬϬϳKDWhdZ^hWW>/^ϲϭϵϯϳϵϱϬϬͲ;ϱϬϬͿ;ϭϬϬ͘ϬйͿ;ϭϰͿ;ϭϱ͘ϭйͿϰͲϰϬϭϬ>Kd,/E'>>KtEͲͲϮϲϴϯ͕ϭϬϬͲ;ϯ͕ϭϬϬͿ;ϭϬϬ͘ϬйͿϮϲϴͲϰͲϰϬϰϱDhE//W>h^/E^^ϱ͕ϭϵϭ ϳ͕Ϭϲϱ Ϯ͕ϲϬϴϮ͕ϯϱϬ ϭ͕ϵϬϬ;ϰϱϬͿ ;ϭϵ͘ϭйͿ ;ϰ͕ϰϱϳͿ ;ϲϯ͘ϭйͿϰͲϱϬϬϭKE&ZE^Ϯ͕ϴϲϮͲ Ϯ͕ϲϲϰϯ͕ϬϬϬ ϭ͕ϲϬϬ;ϭ͕ϰϬϬͿ;ϰϲ͘ϳйͿϮ͕ϲϲϰη/sͬϬ͊ϰͲϱϬϮϲKhZ^^Θ^D/EZ^ϰϬ͕ϭϳϮ ϱ͕ϴϭϯ ϭϬ͕ϴϴϯϴ͕ϯϲϭ ϱ͕ϴϬϬ;Ϯ͕ϱϲϭͿ ;ϯϬ͘ϲйͿ ϱ͕ϬϳϬ ϴϳ͘ϮйϰͲϱϬϮϴDDZ^,/W^ϵ͕ϵϯϳ ϳ͕ϲϵϵ ϲ͕ϬϮϳϭϬ͕ϬϬϬ ϲ͕ϳϬϬ;ϯ͕ϯϬϬͿ ;ϯϯ͘ϬйͿ ;ϭ͕ϲϳϮͿ ;Ϯϭ͘ϳйͿϰͲϱϬϮϵD/>'ϭϱ͕ϵϴϮ ϭϱ͕ϳϮϴ ϭϰ͕ϬϯϳϭϬ͕ϬϬϬ ϭ͕ϬϬϬ;ϵ͕ϬϬϬͿ ;ϵϬ͘ϬйͿ ;ϭ͕ϲϵϭͿ ;ϭϬ͘ϴйͿϰͲϱϬϰϱW,KdKKW/Z,Z'^ϵ͕Ϭϴϵ ϭϬ͕Ϭϴϳ ϭϬ͕ϯϴϯϵ͕ϬϬϬ ϲ͕ϲϱϬ;Ϯ͕ϯϱϬͿ ;Ϯϲ͘ϭйͿ Ϯϵϲ Ϯ͘ϵйϰͲϱϬϱϵKEdZd^ϭϭ͕ϱϱϯ ϱ͕ϯϳϳ ϯ͕ϰϮϵϭϬ͕ϬϬϬ ϭϬ͕ϬϬϬͲ Ͳ ;ϭ͕ϵϰϴͿ ;ϯϲ͘ϮйͿdKd>Kd,ZyWE^^ ϭϬϲ͕ϯϳϵ ϱϵ͕ϵϭϱ ϱϲ͕ϳϳϴ ϲϲ͕ϲϭϭ ϰϯ͕ϴϬϬ ;ϮϮ͕ϴϭϭͿ ;ϯϰ͘ϮйͿ;ϯ͕ϭϯϳͿ;ϱ͘ϮйͿdKd>yWE^^ϱϱϮ͕ϴϭϯ ϲϵϰ͕ϵϯϲ ϱϰϵ͕ϲϱϵ ϱϮϴ͕ϱϲϰ ϱϰϯ͕ϱϰϲϭϰ͕ϵϴϮϮ͘ϴй;ϭϰϱ͕ϮϳϳͿ;ϮϬ͘ϵйͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 4 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬйEdh'dϱϭϵ͕ϲϰϭ ϲϳϬ͕ϳϲϱ ϱϮϱ͕ϮϮϳ ϰϵϯ͕ϱϭϭ ϱϬϴ͕ϱϰϲϭϱ͕Ϭϯϱϯ͘Ϭй;ϭϰϱ͕ϱϯϴͿ;Ϯϭ͘ϳйͿFinance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 5 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϯϲ͕ϲϰϵͿ ;ϯϵ͕ϰϭϮͿ ;ϲϳ͕ϴϯϮͿ;ϰϱ͕ϬϬϬͿ ;ϰϱ͕ϬϬϬͿͲͲϮϴ͕ϰϮϬ ϳϮ͘ϭйdŽƚĂůZĞǀĞŶƵĞ ;ϯϲ͕ϲϰϵͿ ;ϯϵ͕ϰϭϮͿ ;ϲϳ͕ϴϯϮͿ ;ϰϱ͕ϬϬϬͿ ;ϰϱ͕ϬϬϬͿ Ͳ Ͳ Ϯϴ͕ϰϮϬ ϳϮ͘ϭйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϭϴϬ͕ϴϳϳ ϮϬϳ͕ϳϰϲ ϮϯϮ͕ϴϮϴϮϯϭ͕ϰϵϲ Ϯϯϱ͕ϰϬϰϯ͕ϵϬϴ ϭ͘ϳйϮϱ͕ϬϴϮ ϭϮ͘ϭйϰͲϮϬϬϭ^>Z/^ͲKͬdϳ͕ϴϬϱ Ϯ͕ϯϭϳ ϴ͕ϮϵϵͲͲͲ Ͳ ϱ͕ϵϴϮ Ϯϱϴ͘ϮйϰͲϮϬϬϮ^>Z/^ͲWͬdϮϭ͕ϭϬϲ ϯϰ͕ϯϯϵ ϭϵ͕ϬϲϬͲͲͲ Ͳ ;ϭϱ͕ϮϳϵͿ ;ϰϰ͘ϱйͿϰͲϮϬϬϯsd/KEWzͲ ϭ͕ϯϯϴͲͲͲͲͲ;ϭ͕ϯϯϴͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲϭϲϰͲͲͲͲͲ;ϭϲϰͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^ϰ͕ϮϬϮ ;ϳ͕ϱϵϬͿ ϰ͕ϮϴϱͲͲͲ Ͳ ϭϭ͕ϴϳϱ ϭϱϲ͘ϱйϰͲϮϭϬϬE&/d^ͲKDZ^ϭϲ͕Ϭϴϰ Ϯϰ͕ϬϬϳ Ϯϱ͕ϭϬϯϮϮ͕ϴϲϴ Ϯϯ͕ϯϭϱϰϰϳ Ϯ͘Ϭй ϭ͕Ϭϵϲ ϰ͘ϲйϰͲϮϭϬϭE&/d^Ͳ,dϰ͕ϭϬϴ ϱ͕ϮϮϵ ϱ͕ϬϵϮϰ͕ϱϭϰ ϰ͕ϱϵϬϳϲ ϭ͘ϳй ;ϭϯϳͿ ;Ϯ͘ϲйͿϰͲϮϭϬϮE&/d^Ͳt^/ϭ͕ϳϴϯ Ϯ͕Ϭϭϭ ϭ͕ϵϱϴϭ͕ϳϯϲ ϭ͕ϳϲϱϮϵ ϭ͘ϳй ;ϱϯͿ ;Ϯ͘ϲйͿϰͲϮϭϬϯE&/d^ͲWWϳ͕ϴϭϴ ϭϭ͕ϰϳϵ ϵ͕ϳϱϱϵ͕Ϭϱϱ ϵ͕ϭϲϱϭϭϬ ϭ͘Ϯй ;ϭ͕ϳϮϰͿ ;ϭϱ͘ϬйͿϰͲϮϭϬϰE&/d^Ͳ/ϰ͕Ϯϰϴ ϲ͕Ϯϴϰ ϰ͕ϱϯϳϰ͕ϳϰϰ ϰ͕ϭϳϵ;ϱϲϱͿ ;ϭϭ͘ϵйͿ ;ϭ͕ϳϰϳͿ ;Ϯϳ͘ϴйͿϰͲϮϭϬϱE&/d^ͲEd>ϰ͕ϲϭϲ ϲ͕Ϭϰϴ ϱ͕ϭϳϴϲ͕ϰϰϯ ϲ͕Ϭϳϲ;ϯϲϳͿ ;ϱ͘ϳйͿ ;ϴϳϬͿ ;ϭϰ͘ϰйͿϰͲϮϭϬϲE&/d^Ͳ,>d,ϵ͕ϵϲϴ ϭϭ͕ϰϯϴ ϭϭ͕ϬϲϴϭϬ͕ϬϬϳ ϭϬ͕ϯϵϭϯϴϰ ϯ͘ϴй ;ϯϳϬͿ ;ϯ͘ϮйͿϰͲϮϭϬϳE&/d^Ͳ>dͬϯ͕ϯϯϯ ϯ͕ϳϰϭ ϯ͕ϳϬϵϯ͕ϳϲϰ ϰ͕ϮϬϱϰϰϭ ϭϭ͘ϳй ;ϯϮͿ ;Ϭ͘ϵйͿϰͲϮϭϬϴE&/d^ͲKd,Zϭ͕Ϭϭϭ ϭ͕ϯϬϬ ϭ͕Ϭϳϱϭ͕Ϭϴϲ ϭ͕ϮϭϰϭϮϴ ϭϭ͘ϴй ;ϮϮϱͿ ;ϭϳ͘ϯйͿdKd>^>Z/^ΘE&/d^ Ϯϲϲ͕ϵϱϵ ϯϬϵ͕ϴϱϭ ϯϯϭ͕ϵϰϳ Ϯϵϱ͕ϳϭϯ ϯϬϬ͕ϯϬϰ ϰ͕ϱϵϭϭ͘ϲйϮϮ͕Ϭϵϲϳ͘ϭйϰͲϮϯϬϬ/EdZE>Yh/WDEdZEd>;Ϯϯϯ͕ϲϱϵͿ ;Ϯϯϰ͕ϭϱϵͿ ;Ϯϯϯ͕ϲϱϵͿ;Ϯϯϯ͕ϲϱϵͿ ;Ϯϯϯ͕ϲϱϵͿͲ Ͳ ϱϬϬ Ϭ͘ϮйϰͲϮϯϬϮ/EdZE>&h>ZKsZz;ϯϯ͕ϮϮϳͿ ;ϭϮ͕ϳϰϴͿ ;ϴ͕ϯϯϵͿ;ϰϬ͕ϬϬϬͿ ;ϰϬ͕ϬϬϬͿͲ Ͳ ϰ͕ϰϬϵ ϯϰ͘ϲйϰͲϰϬϭϱKWZd/E'DdZ/>^ϱ͕Ϭϳϰ Ϯϴ͕ϳϰϵ ϳ͕ϳϮϱϮ͕ϱϬϬ ϭϱ͕ϬϬϬϭϮ͕ϱϬϬ ϱϬϬ͘Ϭй;Ϯϭ͕ϬϮϰͿ ;ϳϯ͘ϭйͿϰͲϰϬϭϴ>/E^^ϮϬ͕ϵϳϭ Ϯϭ͕ϴϬϬ Ϯϴ͕ϳϲϴϮϮ͕ϬϬϬ Ϯϰ͕ϬϬϬϮ͕ϬϬϬ ϵ͘ϭй ϲ͕ϵϲϴ ϯϮ͘ϬйϰͲϰϬϭϵs,/>^hWW>/^ϮϮϭ͕ϴϮϬ Ϯϵϵ͕ϰϱϲ ϯϯϱ͕ϯϲϮϮϯϱ͕ϬϬϬ ϯϭϰ͕ϬϬϬϳϵ͕ϬϬϬ ϯϯ͘ϲйϯϱ͕ϵϬϲ ϭϮ͘ϬйϰͲϰϬϮϭYh/WDEdͲKd,Zϵϳ Ϯϴ͕ϳϰϭ ϭϯ͕ϬϮϱϭϬ͕ϬϬϬ ϭϬ͕ϬϬϬͲ Ͳ ;ϭϱ͕ϳϭϲͿ ;ϱϰ͘ϳйͿϰͲϰϬϮϮdKK>^ϯ͕ϵϳϴ ϲ͕ϵϱϮ Ϯ͕ϲϳϬϭϵ͕ϬϬϬ ϱ͕ϬϬϬ;ϭϰ͕ϬϬϬͿ ;ϳϯ͘ϳйͿ ;ϰ͕ϮϴϮͿ ;ϲϭ͘ϲйͿϰͲϰϬϰϴ&h>K^d^ϭϴϬ͕ϱϮϳ ϭϰϳ͕ϲϴϯ ϭϳϵ͕ϳϵϵϮϮϬ͕ϬϬϬ ϭϱϱ͕ϬϬϬ;ϲϱ͕ϬϬϬͿ ;Ϯϵ͘ϱйͿϯϮ͕ϭϭϲ Ϯϭ͘ϳйϰͲϱϬϯϮs,/>ZW/Z^ϯϵ͕ϴϰϴ ϯϰ͕ϲϰϵ ϳϵ͕ϲϵϯϱϬ͕ϬϬϬ ϱϬ͕ϬϬϬͲͲϰϱ͕Ϭϰϰ ϭϯϬ͘ϬйϰͲϱϬϯϵ/E^hZE&^Ϯϱ͕ϬϬϬ Ϯϰ͕ϰϴϰ Ϯϰ͕ϲϯϮϮϱ͕ϬϬϬ Ϯϲ͕ϬϬϬϭ͕ϬϬϬ ϰ͘Ϭй ϭϰϴ Ϭ͘ϲйϰͲϴϬϬϯKEdZ/hd/KE^dK/^Zd/KEZzZ^Zs^ϯϲ͕ϲϰϵ ϯϵ͕ϰϭϮ ϲϯ͕ϱϴϮϰϱ͕ϬϬϬ ϰϱ͕ϬϬϬͲͲϮϰ͕ϭϳϬ ϲϭ͘ϯйdKd>Kd,ZyWE^^ Ϯϲϳ͕Ϭϳϴ ϯϴϱ͕Ϭϭϵ ϰϵϯ͕Ϯϱϴ ϯϱϰ͕ϴϰϭ ϯϳϬ͕ϯϰϭ ϭϱ͕ϱϬϬ ϰ͘ϰй ϭϬϴ͕Ϯϯϵ Ϯϴ͘ϭйdKd>yWE^^ ϱϯϰ͕Ϭϯϳ ϲϵϰ͕ϴϳϬ ϴϮϱ͕ϮϬϱ ϲϱϬ͕ϱϱϰ ϲϳϬ͕ϲϰϱ ϮϬ͕Ϭϵϭ ϯ͘ϭй ϭϯϬ͕ϯϯϱ ϭϴ͘ϴйEdh'd ϰϵϳ͕ϯϴϴ ϲϱϱ͕ϰϱϴ ϳϱϳ͕ϯϳϯ ϲϬϱ͕ϱϱϰ ϲϮϱ͕ϲϰϱ ϮϬ͕Ϭϵϭ ϯ͘ϯй ϭϬϭ͕ϵϭϱ ϭϱ͘ϱйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 6 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϱϭ͕ϮϬϱͿ ;ϯϯ͕ϲϯϮͿ ;ϰϵ͕ϵϴϭͿ;ϰϴ͕ϬϬϬͿ ;ϭϬϮ͕ϬϬϬͿϱϰ͕ϬϬϬ ϭϭϮ͘ϱй ϭϲ͕ϯϰϵ ϰϴ͘ϲйϯͲϭϵϭϳE'/EZ/E'KEdZ/hd/KE;ϳϬ͕ϬϬϬͿͲͲͲͲͲͲ ͲͲdŽƚĂůZĞǀĞŶƵĞ;ϭϮϭ͕ϮϬϱͿ ;ϯϯ͕ϲϯϮͿ ;ϰϵ͕ϵϴϭͿ ;ϰϴ͕ϬϬϬͿ ;ϭϬϮ͕ϬϬϬͿϱϰ͕ϬϬϬϭϭϮ͘ϱйϭϲ͕ϯϰϵϰϴ͘ϲйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϭ͕Ϭϭϳ͕ϭϵϬ ϭ͕Ϭϭϯ͕ϲϮϴ ϭ͕Ϭϱϭ͕Ϯϱϰϭ͕Ϭϵϭ͕ϯϰϭ ϭ͕Ϭϱϳ͕ϵϵϰ;ϯϯ͕ϯϰϳͿ ;ϯ͘ϭйͿ ϯϳ͕ϲϮϲ ϯ͘ϳйϰͲϮϬϬϭ^>Z/^ͲKͬdϰϵ͕ϮϴϬ ϲϱ͕ϴϱϭ ϰϱ͕ϬϲϱϮϴ͕ϬϬϬ Ϯϴ͕ϬϬϬͲͲ;ϮϬ͕ϳϴϲͿ ;ϯϭ͘ϲйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϴϭ͕ϱϵϲ ϴϰ͕ϭϲϳ ϭϮϳ͕ϲϮϭϭϭϰ͕ϭϵϴ ϭϭϴ͕ϯϱϵϰ͕ϭϲϭ ϯ͘ϲйϰϯ͕ϰϱϰ ϱϭ͘ϲйϰͲϮϬϬϯsd/KEWzͲ ϯ͕ϴϳϭͲͲͲͲͲ;ϯ͕ϴϳϭͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲϲϱϳͲͲͲͲͲ;ϲϱϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϱ>/hd/DͲ ϭ͕ϰϴϳͲͲͲͲͲ;ϭ͕ϰϴϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^;ϭϬ͕ϴϯϭͿ ϳ͕ϵϯϯ ϯ͕ϮϲϬͲͲͲ Ͳ ;ϰ͕ϲϳϯͿ ;ϱϴ͘ϵйͿϰͲϮϭϬϬE&/d^ͲKDZ^ϭϬϴ͕Ϭϱϴ ϭϬϰ͕Ϭϴϱ ϭϭϬ͕ϳϯϭϭϬϱ͕ϰϲϲ ϭϬϲ͕ϭϬϲϲϰϬ Ϭ͘ϲй ϲ͕ϲϰϲ ϲ͘ϰйϰͲϮϭϬϭE&/d^Ͳ,dϮϮ͕ϰϬϱ ϮϮ͕Ϯϭϯ Ϯϰ͕ϭϱϰϮϯ͕ϭϰϲ Ϯϯ͕ϯϱϰϮϬϴ Ϭ͘ϵй ϭ͕ϵϰϭ ϴ͘ϳйϰͲϮϭϬϮE&/d^Ͳt^/ϵ͕ϲϮϴ ϴ͕ϰϬϯ ϵ͕ϭϭϮϴ͕ϵϬϮ ϴ͕ϵϴϮϴϬ Ϭ͘ϵй ϳϬϵ ϴ͘ϰйϰͲϮϭϬϯE&/d^ͲWWϰϮ͕Ϭϭϵ ϰϮ͕ϲϱϳ ϰϱ͕ϱϳϮϰϱ͕ϰϵϳ ϰϲ͕ϭϴϴϲϵϭ ϭ͘ϱй Ϯ͕ϵϭϱ ϲ͘ϴйϰͲϮϭϬϰE&/d^Ͳ/ϮϮ͕ϭϵϲ ϮϮ͕ϳϲϰ Ϯϭ͕ϭϮϰϮϰ͕ϳϮϳ ϮϮ͕ϯϬϬ;Ϯ͕ϰϮϳͿ ;ϵ͘ϴйͿ ;ϭ͕ϲϰϬͿ ;ϳ͘ϮйͿϰͲϮϭϬϱE&/d^ͲEd>Ϯϰ͕ϴϵϮ ϮϮ͕ϯϵϴ Ϯϯ͕ϬϭϬϮϵ͕Ϭϭϭ Ϯϳ͕ϯϲϬ;ϭ͕ϲϱϭͿ ;ϱ͘ϳйͿ ϲϭϮ Ϯ͘ϳйϰͲϮϭϬϲE&/d^Ͳ,>d,ϰϯ͕ϲϮϭ ϰϮ͕ϰϰϮ ϰϯ͕Ϭϭϵϰϱ͕Ϭϲϭ ϰϲ͕ϳϵϬϭ͕ϳϮϵ ϯ͘ϴй ϱϳϳ ϭ͘ϰйϰͲϮϭϬϳE&/d^Ͳ>dͬϭϲ͕ϱϭϴ ϭϱ͕ϮϮϭ ϭϲ͕ϯϴϱϭϳ͕ϳϭϱ ϭϵ͕ϲϬϭϭ͕ϴϴϲ ϭϬ͘ϲй ϭ͕ϭϲϰ ϳ͘ϲйϰͲϮϭϬϴE&/d^ͲKd,Zϰ͕ϲϵϲ ϰ͕ϯϭϲ ϰ͕ϲϳϰϰ͕ϵϮϯ ϱ͕ϰϱϳϱϯϰ ϭϬ͘ϴй ϯϱϴ ϴ͘ϯйϰͲϮϮϬϬt'ZKsZz;ϵϱϰͿ ;ϯ͕ϰϳϵͿͲͲͲͲͲϯ͕ϰϳϵϭϬϬ͘ϬйdKd>^>Z/^ΘE&/d^ϭ͕ϰϯϬ͕ϯϭϰ ϭ͕ϰϱϴ͕ϲϭϰ ϭ͕ϱϮϰ͕ϵϴϭ ϭ͕ϱϯϳ͕ϵϴϳ ϭ͕ϱϭϬ͕ϰϵϭ;Ϯϳ͕ϰϵϲͿ;ϭ͘ϴйͿϲϲ͕ϯϲϳϰ͘ϲйϰͲϰϬϭϬ>Kd,/E'>>KtEͲ ϲ͕ϵϮϯ ϭϯ͕ϴϲϮϭϱ͕ϬϬϬ ϭϬ͕ϬϬϬ;ϱ͕ϬϬϬͿ ;ϯϯ͘ϯйͿ ϲ͕ϵϯϵ ϭϬϬ͘ϮйϰͲϰϬϭϯhd/>/d/^ϱϱϬ͕ϲϰϬ ϱϭϳ͕ϱϱϯ ϯϴϵ͕ϭϳϳϮϮϬ͕ϬϬϬ ϰϬϬ͕ϬϬϬϭϴϬ͕ϬϬϬ ϴϭ͘ϴй;ϭϮϴ͕ϯϳϲͿ ;Ϯϰ͘ϴйͿϰͲϰϬϭϱKWZd/E'DdZ/>^Ϯϴϱ͕Ϭϰϴ ϯϱϮ͕ϰϭϴ ϳϯϬ͕ϯϴϭϯϱϮ͕ϵϬϬ ϯϲϯ͕ϬϬϬϭϬ͕ϭϬϬ Ϯ͘ϵйϯϳϳ͕ϵϲϯ ϭϬϳ͘ϮйϰͲϱϬϱϵKEdZd^ϭ͕ϱϱϳ͕ϴϱϰ ϭ͕ϯϵϴ͕ϴϬϰ ϭ͕ϱϭϬ͕ϲϰϰϭ͕ϱϲϬ͕ϳϱϬ ϭ͕ϱϭϰ͕ϵϯϬ;ϰϱ͕ϴϮϬͿ ;Ϯ͘ϵйͿ ϭϭϭ͕ϴϰϬ ϴ͘ϬйϰͲϲϬϬϬW/d>>KEZWzDEdͲ ϭϰϲ͕ϯϮϬ Ϯϵϳ͕ϲϴϲϮϵϳ͕ϲϴϲ ϯϬϰ͕ϱϰϮϲ͕ϴϱϲ Ϯ͘ϯйϭϱϭ͕ϯϲϲ ϭϬϯ͘ϰйϰͲϲϬϬϭE<,Z'^Ͳ ϰϭ͕ϵϮϯ ϲϵ͕ϳϴϱϲϵ͕ϳϴϱ ϲϮ͕ϵϯϬ;ϲ͕ϴϱϱͿ ;ϵ͘ϴйͿϮϳ͕ϴϲϮ ϲϲ͘ϱйϰͲϴϬϬϯKEdZ/hd/KE^dK/^Zd/KEZzZ^Zs^ϰ͕ϳϭϭ ϰ͕ϳϭϭ ϰ͕ϳϭϭϰ͕ϳϭϭ ϰ͕ϳϭϭͲͲ ͲͲdKd>Kd,ZyWE^^ Ϯ͕ϯϵϴ͕Ϯϱϯ Ϯ͕ϰϲϴ͕ϲϱϮ ϯ͕Ϭϭϲ͕Ϯϰϲ Ϯ͕ϱϮϬ͕ϴϯϮ Ϯ͕ϲϲϬ͕ϭϭϯ ϭϯϵ͕Ϯϴϭ ϱ͘ϱй ϱϰϳ͕ϱϵϰ ϮϮ͘ϮйdKd>yWE^^ ϯ͕ϴϮϴ͕ϱϲϳ ϯ͕ϵϮϳ͕Ϯϲϲ ϰ͕ϱϰϭ͕ϮϮϳ ϰ͕Ϭϱϴ͕ϴϭϵ ϰ͕ϭϳϬ͕ϲϬϰ ϭϭϭ͕ϳϴϱ Ϯ͘ϴй ϲϭϯ͕ϵϲϭ ϭϱ͘ϲйEdh'd ϯ͕ϳϬϳ͕ϯϲϮ ϯ͕ϴϵϯ͕ϲϯϰ ϰ͕ϰϵϭ͕Ϯϰϲ ϰ͕ϬϭϬ͕ϴϭϵ ϰ͕Ϭϲϴ͕ϲϬϰ ϱϳ͕ϳϴϱ ϭ͘ϰйϱϵϳ͕ϲϭϮϭϱ͘ϯйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 7 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϭϯ͕ϭϬϯͿ ;ϭϬ͕ϯϲϯͿ ;ϭϯ͕ϱϬϯͿ;ϭϯ͕ϬϬϬͿ ;ϭϯ͕ϬϬϬͿͲ Ͳ ϯ͕ϭϰϬ ϯϬ͘ϯйdŽƚĂůZĞǀĞŶƵĞ ;ϭϯ͕ϭϬϯͿ ;ϭϬ͕ϯϲϯͿ ;ϭϯ͕ϱϬϯͿ ;ϭϯ͕ϬϬϬͿ ;ϭϯ͕ϬϬϬͿ Ͳ Ͳ ϯ͕ϭϰϬ ϯϬ͘ϯйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϮϵϲ͕ϱϵϭ Ϯϱϯ͕ϬϯϬ Ϯϯϳ͕ϴϳϭϯϯϰ͕ϵϭϮ ϯϯϴ͕Ϭϳϵϯ͕ϭϲϳ Ϭ͘ϵй ;ϭϱ͕ϭϱϵͿ ;ϲ͘ϬйͿϰͲϮϬϬϭ^>Z/^ͲKͬdϭϵ͕ϵϱϱ ϰϬ͕ϯϳϬ Ϯϰ͕ϵϱϱϭϰ͕ϬϬϬ ϭϰ͕ϬϬϬͲ Ͳ ;ϭϱ͕ϰϭϱͿ ;ϯϴ͘ϮйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϲϰ͕ϯϯϲ ϰϰ͕ϵϱϳ ϱϵ͕ϱϲϵϲϮ͕ϱϭϬ ϲϰ͕ϳϴϴϮ͕Ϯϳϴ ϯ͘ϲй ϭϰ͕ϲϭϮ ϯϮ͘ϱйϰͲϮϬϬϰ^/<WzͲϯϮϳͲͲͲͲͲ;ϯϮϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^ϴϳϱ ;ϴϳϱͿͲͲͲͲͲϴϳϱϭϬϬ͘ϬйϰͲϮϭϬϬE&/d^ͲKDZ^ϯϯ͕ϱϳϬ ϭϳ͕Ϯϵϭ Ϯϯ͕ϲϵϭϯϮ͕ϲϱϳ ϯϮ͕ϴϲϰϮϬϳ Ϭ͘ϲй ϲ͕ϰϬϬ ϯϳ͘ϬйϰͲϮϭϬϭE&/d^Ͳ,dϳ͕ϯϰϰ ϯ͕ϳϰϭ ϲ͕Ϭϯϱϳ͕ϵϳϲ ϴ͕Ϭϱϳϴϭ ϭ͘Ϭй Ϯ͕Ϯϵϰ ϲϭ͘ϯйϰͲϮϭϬϮE&/d^Ͳt^/ϯ͕ϲϯϯ ϭ͕ϰϯϵ Ϯ͕ϮϲϬϯ͕Ϭϲϳ ϯ͕ϬϵϵϯϮ ϭ͘Ϭй ϴϮϭ ϱϳ͘ϭйϰͲϮϭϬϯE&/d^ͲWWϭϰ͕ϰϲϲ ϴ͕ϵϴϲ ϭϮ͕ϭϮϯϭϲ͕ϰϲϮ ϭϲ͕ϳϰϰϮϴϮ ϭ͘ϳй ϯ͕ϭϯϳ ϯϰ͘ϵйϰͲϮϭϬϰE&/d^Ͳ/ϳ͕ϳϳϰ ϱ͕Ϭϯϭ ϱ͕ϳϴϱϴ͕ϵϱϳ ϴ͕ϮϬϱ;ϳϱϮͿ ;ϴ͘ϰйͿ ϳϱϰ ϭϱ͘ϬйϰͲϮϭϬϱE&/d^ͲEd>ϲ͕ϱϰϳ ϰ͕ϯϲϬ ϯ͕ϯϳϳϵ͕ϵϰϬ ϵ͕ϯϳϰ;ϱϲϲͿ ;ϱ͘ϳйͿ ;ϵϴϯͿ ;ϮϮ͘ϱйͿϰͲϮϭϬϲE&/d^Ͳ,>d,ϭϭ͕ϳϮϯ ϳ͕ϯϳϲ ϲ͕ϳϯϯϭϱ͕ϰϰϬ ϭϲ͕ϬϯϮϱϵϮ ϯ͘ϴй ;ϲϰϯͿ ;ϴ͘ϳйͿϰͲϮϭϬϳE&/d^Ͳ>dͬϰ͕ϮϴϮ Ϯ͕ϰϱϯ Ϯ͕ϳϬϱϱ͕ϰϴϰ ϲ͕ϬϳϬϱϴϲ ϭϬ͘ϳй ϮϱϮ ϭϬ͘ϯйϰͲϮϭϬϴE&/d^ͲKd,Zϭ͕ϮϲϲϳϮϬϳϵϰϭ͕ϱϳϮ ϭ͕ϳϰϰϭϳϮϭϬ͘ϵйϳϰϭϬ͘ϯйdKd>^>Z/^ΘE&/d^ϰϳϮ͕ϯϲϮ ϯϴϵ͕ϮϬϲ ϯϴϱ͕ϴϵϴ ϱϭϮ͕ϵϳϳ ϱϭϵ͕Ϭϱϲϲ͕Ϭϳϵϭ͘Ϯй;ϯ͕ϯϬϴͿ;Ϭ͘ϴйͿϰͲϰϬϭϱKWZd/E'DdZ/>^ϮϬϳ͕ϴϳϲ Ϯϴϰ͕ϰϭϭ ϲϰϲ͕ϯϰϴϮϲϬ͕ϬϬϬ ϮϴϬ͕ϬϬϬϮϬ͕ϬϬϬ ϳ͘ϳйϯϲϭ͕ϵϯϳ ϭϮϳ͘ϯйϰͲϱϬϱϵKEdZd^ϲϰϱ͕Ϯϱϰ ϳϯϱ͕ϵϱϳ ϳϬϬ͕ϳϯϵϳϵϵ͕ϬϬϬ ϳϭϬ͕ϬϬϬ;ϴϵ͕ϬϬϬͿ ;ϭϭ͘ϭйͿ ;ϯϱ͕ϮϭϴͿ ;ϰ͘ϴйͿϰͲϴϬϬϯKEdZ/hd/KE^dK/^Zd/KEZzZ^Zs^ϰ͕ϳϭϭ ϰ͕ϳϭϭ ϰ͕ϳϭϭϰ͕ϳϭϭ ϰ͕ϳϭϭͲͲ ͲͲdKd>Kd,ZyWE^^ ϴϱϳ͕ϴϰϭ ϭ͕ϬϮϱ͕Ϭϳϵ ϭ͕ϯϱϭ͕ϳϵϴ ϭ͕Ϭϲϯ͕ϳϭϭ ϵϵϰ͕ϳϭϭ ;ϲϵ͕ϬϬϬͿ ;ϲ͘ϱйͿ ϯϮϲ͕ϳϭϵ ϯϭ͘ϵйdKd>yWE^^ ϭ͕ϯϯϬ͕ϮϬϯ ϭ͕ϰϭϰ͕Ϯϴϱ ϭ͕ϳϯϳ͕ϲϵϲ ϭ͕ϱϳϲ͕ϲϴϴ ϭ͕ϱϭϯ͕ϳϲϳ ;ϲϮ͕ϵϮϭͿ;ϰ͘ϬйͿϯϮϯ͕ϰϭϭϮϮ͘ϵйEdh'dϭ͕ϯϭϳ͕ϭϬϬ ϭ͕ϰϬϯ͕ϵϮϮ ϭ͕ϳϮϰ͕ϭϵϯ ϭ͕ϱϲϯ͕ϲϴϴ ϭ͕ϱϬϬ͕ϳϲϳ;ϲϮ͕ϵϮϭͿ;ϰ͘ϬйͿϯϮϬ͕ϮϳϭϮϮ͘ϴйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 8 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;Ϯ͕ϰϱϮͿ ;ϭϭ͕ϱϬϬͿ ;ϮϬ͕ϲϲϵͿ;ϱ͕ϬϬϬͿ ;ϱϵ͕ϬϬϬͿϱϰ͕ϬϬϬ ϭ͕ϬϴϬ͘Ϭй ϵ͕ϭϲϵ ϳϵ͘ϳйdŽƚĂůZĞǀĞŶƵĞ ;Ϯ͕ϰϱϮͿ ;ϭϭ͕ϱϬϬͿ ;ϮϬ͕ϲϲϵͿ ;ϱ͕ϬϬϬͿ ;ϱϵ͕ϬϬϬͿ ϱϰ͕ϬϬϬ ϭ͕ϬϴϬ͘Ϭй ϵ͕ϭϲϵ ϳϵ͘ϳйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϲϵϰ͕ϲϴϳ ϳϯϯ͕ϯϴϰ ϳϵϰ͕ϵϬϰϳϮϲ͕ϵϱϴ ϲϴϵ͕ϵϲϯ;ϯϲ͕ϵϵϱͿ ;ϱ͘ϭйͿ ϲϭ͕ϱϮϬ ϴ͘ϰйϰͲϮϬϬϭ^>Z/^ͲKͬdϮϵ͕ϯϮϲ Ϯϱ͕ϰϴϬ ϮϬ͕ϭϭϬϭϰ͕ϬϬϬ ϭϰ͕ϬϬϬͲ Ͳ ;ϱ͕ϯϳϬͿ ;Ϯϭ͘ϭйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϭϵϰ Ϯϭ͕ϴϬϮ ϱϬ͕ϴϯϮϮϰ͕ϲϲϯ Ϯϱ͕ϱϲϮϴϵϵ ϯ͘ϲйϮϵ͕ϬϯϬ ϭϯϯ͘ϮйϰͲϮϬϬϯsd/KEWzͲ ϯ͕ϱϮϱͲͲͲͲͲ;ϯ͕ϱϮϱͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲϭϲϲͲͲͲͲͲ;ϭϲϲͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϱ>/hd/DͲ ϭ͕ϰϴϳͲͲͲͲͲ;ϭ͕ϰϴϳͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^;ϭϭ͕ϳϬϲͿ ϴ͕ϴϬϴ ϯ͕ϮϲϬͲͲͲ Ͳ ;ϱ͕ϱϰϴͿ ;ϲϯ͘ϬйͿϰͲϮϭϬϬE&/d^ͲKDZ^ϳϬ͕ϭϬϭ ϴϰ͕ϰϲϭ ϴϯ͕ϰϱϵϲϴ͕ϰϲϭ ϲϴ͕ϴϭϳϯϱϲ Ϭ͘ϱй ;ϭ͕ϬϬϮͿ ;ϭ͘ϮйͿϰͲϮϭϬϭE&/d^Ͳ,dϭϰ͕ϮϮϭ ϭϳ͕ϵϵϱ ϭϳ͕ϰϮϮϭϰ͕Ϭϴϵ ϭϰ͕ϭϵϴϭϬϵ Ϭ͘ϴй ;ϱϳϯͿ ;ϯ͘ϮйͿϰͲϮϭϬϮE&/d^Ͳt^/ϱ͕ϲϯϮ ϲ͕ϳϴϭ ϲ͕ϱϴϰϱ͕ϰϭϵ ϱ͕ϰϲϬϰϭ Ϭ͘ϴй ;ϭϵϳͿ ;Ϯ͘ϵйͿϰͲϮϭϬϯE&/d^ͲWWϮϲ͕ϭϰϭ ϯϮ͕ϳϲϱ ϯϮ͕ϭϬϳϮϳ͕ϱϭϬ Ϯϳ͕ϴϴϲϯϳϲ ϭ͘ϰй ;ϲϱϴͿ ;Ϯ͘ϬйͿϰͲϮϭϬϰE&/d^Ͳ/ϭϯ͕ϱϮϮ ϭϳ͕Ϭϴϵ ϭϰ͕ϱϴϱϭϰ͕ϱϵϵ ϭϮ͕ϵϳϭ;ϭ͕ϲϮϴͿ ;ϭϭ͘ϮйͿ ;Ϯ͕ϱϬϰͿ ;ϭϰ͘ϳйͿϰͲϮϭϬϱE&/d^ͲEd>ϭϳ͕ϳϴϭ ϭϳ͕ϴϴϯ ϭϵ͕ϮϵϬϭϴ͕ϰϬϴ ϭϳ͕ϯϲϬ;ϭ͕ϬϰϴͿ ;ϱ͘ϳйͿ ϭ͕ϰϬϳ ϳ͘ϵйϰͲϮϭϬϲE&/d^Ͳ,>d,ϯϬ͕ϵϱϯ ϯϰ͕ϴϬϴ ϯϱ͕ϲϯϲϮϴ͕ϱϵϮ Ϯϵ͕ϲϴϵϭ͕Ϭϵϳ ϯ͘ϴй ϴϮϴ Ϯ͘ϰйϰͲϮϭϬϳE&/d^Ͳ>dͬϭϭ͕ϳϰϲ ϭϮ͕ϲϯϮ ϭϯ͕ϯϯϭϭϭ͕ϲϵϳ ϭϮ͕ϵϯϱϭ͕Ϯϯϴ ϭϬ͘ϲй ϲϵϵ ϱ͘ϱйϰͲϮϭϬϴE&/d^ͲKd,Zϯ͕ϯϬϲ ϯ͕ϱϲϮ ϯ͕ϳϵϮϯ͕Ϯϭϯ ϯ͕ϱϱϵϯϰϲ ϭϬ͘ϴй ϮϯϬ ϲ͘ϱйϰͲϮϮϬϬt'ZKsZz;ϵϱϰͿ ;ϯ͕ϰϳϵͿͲͲͲͲͲϯ͕ϰϳϵϭϬϬ͘ϬйdKd>^>Z/^ΘE&/d^ϵϬϰ͕ϵϱϬ ϭ͕Ϭϭϵ͕ϭϰϵ ϭ͕Ϭϵϱ͕ϯϭϮ ϵϱϳ͕ϲϬϵ ϵϮϮ͕ϰϬϬ;ϯϱ͕ϮϬϵͿ;ϯ͘ϳйͿϳϲ͕ϭϲϯϳ͘ϱйϰͲϰϬϭϬ>Kd,/E'>>KtEͲ ϲ͕ϵϮϯ ϭϯ͕ϴϲϮϭϱ͕ϬϬϬ ϭϬ͕ϬϬϬ;ϱ͕ϬϬϬͿ ;ϯϯ͘ϯйͿ ϲ͕ϵϯϵ ϭϬϬ͘ϮйϰͲϰϬϭϱKWZd/E'DdZ/>^ϲϯ͕ϵϲϳ ϲϱ͕ϴϯϬ ϳϮ͕ϳϱϱϳϵ͕ϵϬϬ ϳϬ͕ϬϬϬ;ϵ͕ϵϬϬͿ ;ϭϮ͘ϰйͿ ϲ͕ϵϮϱ ϭϬ͘ϱйϰͲϱϬϱϵKEdZd^ϱϮϵ͕ϳϵϲ ϰϮϵ͕ϯϮϵ ϱϰϱ͕ϰϵϴϱϮϲ͕ϳϱϬ ϱϮϭ͕ϵϯϬ;ϰ͕ϴϮϬͿ ;Ϭ͘ϵйͿϭϭϲ͕ϭϲϵ Ϯϳ͘ϭйdKd>Kd,ZyWE^^ ϱϵϯ͕ϳϲϯ ϱϬϮ͕ϬϴϮ ϲϯϮ͕ϭϭϱ ϲϮϭ͕ϲϱϬ ϲϬϭ͕ϵϯϬ ;ϭϵ͕ϳϮϬͿ;ϯ͘ϮйͿ ϭϯϬ͕Ϭϯϯ Ϯϱ͘ϵйdKd>yWE^^ ϭ͕ϰϵϴ͕ϳϭϯ ϭ͕ϱϮϭ͕Ϯϯϭ ϭ͕ϳϮϳ͕ϰϮϳ ϭ͕ϱϳϵ͕Ϯϱϵ ϭ͕ϱϮϰ͕ϯϯϬ ;ϱϰ͕ϵϮϵͿ;ϯ͘ϱйͿϮϬϲ͕ϭϵϲϭϯ͘ϲйEdh'dϭ͕ϰϵϲ͕Ϯϲϭ ϭ͕ϱϬϵ͕ϳϯϭ ϭ͕ϳϬϲ͕ϳϱϴ ϭ͕ϱϳϰ͕Ϯϱϵ ϭ͕ϰϲϱ͕ϯϯϬ;ϭϬϴ͕ϵϮϵͿ;ϲ͘ϵйͿϭϵϳ͕ϬϮϳϭϯ͘ϭйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 9 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϯϱ͕ϲϱϭͿ ;ϭϭ͕ϳϲϵͿ ;ϭϱ͕ϴϬϵͿ;ϯϬ͕ϬϬϬͿ ;ϯϬ͕ϬϬϬͿͲ Ͳ ϰ͕ϬϰϬ ϯϰ͘ϯйϯͲϭϵϭϳE'/EZ/E'KEdZ/hd/KE;ϳϬ͕ϬϬϬͿͲͲͲͲͲͲ ͲͲdŽƚĂůZĞǀĞŶƵĞ;ϭϬϱ͕ϲϱϭͿ ;ϭϭ͕ϳϲϵͿ ;ϭϱ͕ϴϬϵͿ ;ϯϬ͕ϬϬϬͿ ;ϯϬ͕ϬϬϬͿͲͲϰ͕ϬϰϬϯϰ͘ϯйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϮϱ͕ϵϭϯ Ϯϳ͕Ϯϭϰ ϭϴ͕ϰϳϵϮϵ͕ϰϳϭ Ϯϵ͕ϵϱϮϰϴϭ ϭ͘ϲй ;ϴ͕ϳϯϱͿ ;ϯϮ͘ϭйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϭϳ͕Ϭϲϲ ϭϳ͕ϰϬϳ ϭϳ͕ϮϭϵϮϳ͕ϬϮϱ Ϯϴ͕ϬϬϵϵϴϰ ϯ͘ϲй ;ϭϴϴͿ ;ϭ͘ϭйͿϰͲϮϬϬϯsd/KEWzͲϯϰϲͲͲͲͲͲ;ϯϰϲͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲϭϲϰͲͲͲͲͲ;ϭϲϰͿ;ϭϬϬ͘ϬйͿϰͲϮϭϬϬE&/d^ͲKDZ^ϰ͕ϯϴϳ Ϯ͕ϯϯϯ ϯ͕ϱϴϭϰ͕ϯϰϴ ϰ͕ϰϮϱϳϳ ϭ͘ϴй ϭ͕Ϯϰϴ ϱϯ͘ϱйϰͲϮϭϬϭE&/d^Ͳ,dϴϯϵϰϳϴϲϵϴϭ͕Ϭϴϭ ϭ͕ϭϬϬϭϵϭ͘ϴйϮϮϬϰϲ͘ϬйϰͲϮϭϬϮE&/d^Ͳt^/ϯϲϰϭϴϰϮϲϵϰϭϲϰϮϯϳϭ͘ϳйϴϱϰϲ͘ϮйϰͲϮϭϬϯE&/d^ͲWWϭ͕ϰϭϮϵϬϲ ϭ͕ϯϰϯϭ͕ϱϮϱ ϭ͕ϱϱϴϯϯϮ͘Ϯйϰϯϳϰϴ͘ϮйϰͲϮϭϬϰE&/d^Ͳ/ϵϬϭϲϰϰϳϱϰϭ͕ϭϳϮ ϭ͕ϭϮϱ;ϰϳͿ;ϰ͘ϬйͿϭϭϬϭϳ͘ϭйϰͲϮϭϬϱE&/d^ͲEd>ϱϲϱϭϱϰϯϰϯϲϲϯϲϮϱ;ϯϴͿ;ϱ͘ϳйͿϭϴϵϭϮϮ͘ϳйϰͲϮϭϬϲE&/d^Ͳ,>d,ϵϰϱϮϱϴϲϱϭϭ͕ϬϮϵ ϭ͕ϬϲϵϰϬϯ͘ϵйϯϵϯϭϱϮ͘ϯйϰͲϮϭϬϳE&/d^Ͳ>dͬϰϵϬϭϯϲϯϱϬϱϯϰϱϵϲϲϮϭϭ͘ϲйϮϭϰϭϱϳ͘ϰйϰͲϮϭϬϴE&/d^ͲKd,ZϭϮϰϯϰϴϴϭϯϴϭϱϱϭϳϭϮ͘ϯйϱϰϭϱϴ͘ϴйdKd>^>Z/^ΘE&/d^ϱϯ͕ϬϬϲ ϱϬ͕Ϯϱϴ ϰϯ͕ϳϳϱ ϲϳ͕ϰϬϮ ϲϵ͕Ϭϯϳϭ͕ϲϯϱϮ͘ϰй;ϲ͕ϰϴϯͿ;ϭϮ͘ϵйͿϰͲϰϬϭϯhd/>/d/^ϱϱϬ͕ϲϰϬ ϱϭϳ͕ϱϱϯ ϯϴϵ͕ϭϳϳϮϮϬ͕ϬϬϬ ϰϬϬ͕ϬϬϬϭϴϬ͕ϬϬϬ ϴϭ͘ϴй;ϭϮϴ͕ϯϳϲͿ ;Ϯϰ͘ϴйͿϰͲϰϬϭϱKWZd/E'DdZ/>^ϭϯ͕ϮϬϱ Ϯ͕ϭϳϴ ϭϭ͕Ϯϳϴϭϯ͕ϬϬϬ ϭϯ͕ϬϬϬͲ Ͳ ϵ͕ϭϬϬ ϰϭϳ͘ϴйϰͲϱϬϱϵKEdZd^ϯϴϮ͕ϴϬϱ Ϯϯϯ͕ϱϭϴ Ϯϲϰ͕ϰϬϳϮϯϱ͕ϬϬϬ Ϯϴϯ͕ϬϬϬϰϴ͕ϬϬϬ ϮϬ͘ϰйϯϬ͕ϴϴϵ ϭϯ͘ϮйϰͲϲϬϬϬW/d>>KEZWzDEdͲ ϭϰϲ͕ϯϮϬ Ϯϵϳ͕ϲϴϲϮϵϳ͕ϲϴϲ ϯϬϰ͕ϱϰϮϲ͕ϴϱϲ Ϯ͘ϯйϭϱϭ͕ϯϲϲ ϭϬϯ͘ϰйϰͲϲϬϬϭE<,Z'^Ͳ ϰϭ͕ϵϮϯ ϲϵ͕ϳϴϱϲϵ͕ϳϴϱ ϲϮ͕ϵϯϬ;ϲ͕ϴϱϱͿ ;ϵ͘ϴйͿϮϳ͕ϴϲϮ ϲϲ͘ϱйdKd>Kd,ZyWE^^ ϵϰϲ͕ϲϱϬ ϵϰϭ͕ϰϵϮ ϭ͕ϬϯϮ͕ϯϯϯ ϴϯϱ͕ϰϳϭ ϭ͕Ϭϲϯ͕ϰϳϮ ϮϮϴ͕ϬϬϭ Ϯϳ͘ϯй ϵϬ͕ϴϰϭ ϵ͘ϲйdKd>yWE^^ ϵϵϵ͕ϲϱϲ ϵϵϭ͕ϳϱϬ ϭ͕Ϭϳϲ͕ϭϬϴ ϵϬϮ͕ϴϳϯ ϭ͕ϭϯϮ͕ϱϬϵ ϮϮϵ͕ϲϯϲ Ϯϱ͘ϰй ϴϰ͕ϯϱϴ ϴ͘ϱйEdh'd ϴϵϰ͕ϬϬϱ ϵϳϵ͕ϵϴϭ ϭ͕ϬϲϬ͕Ϯϵϵ ϴϳϮ͕ϴϳϯ ϭ͕ϭϬϮ͕ϱϬϵ ϮϮϵ͕ϲϯϲ Ϯϲ͘ϯй ϴϬ͕ϯϭϴϴ͘ϮйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 10 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϮϬϭKd,Z;ϰϮ͕ϰϴϵͿ ;ϰϰ͕ϵϰϯͿ ;ϱϯ͕ϱϮϭͿ;ϰϯ͕ϬϬϬͿ ;ϰϯ͕ϬϬϬͿͲ Ͳ ϴ͕ϱϳϴ ϭϵ͘ϭйϯͲϭϮϬϱ^>^;ϭ͕ϴϬϵͿ ;Ϯ͕ϬϮϯͿ ;Ϯ͕ϵϴϳͿ;ϯ͕ϬϬϬͿ ;ϯ͕ϬϬϬͿͲ Ͳ ϵϲϰ ϰϳ͘ϳйϯͲϭϴϬϯKd,Z'ZEd^;Ϯϰϳ͕ϬϬϲͿ ;Ϯϰϰ͕ϯϯϰͿ ;Ϯϯϳ͕ϬϲϭͿ;ϮϲϬ͕ϬϬϬͿ ;ϮϲϬ͕ϬϬϬͿͲ Ͳ ;ϳ͕ϮϳϯͿ ;ϯ͘ϬйͿdŽƚĂůZĞǀĞŶƵĞ ;Ϯϵϭ͕ϯϬϰͿ ;Ϯϵϭ͕ϯϬϬͿ ;Ϯϵϯ͕ϱϲϵͿ ;ϯϬϲ͕ϬϬϬͿ ;ϯϬϲ͕ϬϬϬͿ Ͳ Ͳ Ϯ͕Ϯϲϵ Ϭ͘ϴйyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϵϮ͕Ϭϵϵ Ϯϯ͕ϭϴϱ ϴϭ͕ϱϴϬϴϲ͕ϴϬϮ ϴϴ͕ϵϭϭϮ͕ϭϬϵ Ϯ͘ϰйϱϴ͕ϯϵϱ Ϯϱϭ͘ϵйϰͲϮϬϬϭ^>Z/^ͲKͬdϮ͕Ϯϯϯ ϭ͕ϳϭϬͲͲͲͲͲ;ϭ͕ϳϭϬͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϮ^>Z/^ͲWͬdϯϯϭϱϱ ϭϬ͕ϵϬϴͲͲͲͲϭϬ͕ϳϱϯϲ͕ϵϯϳ͘ϰйϰͲϮϬϵϬzZEZh>^ϭ͕ϮϳϬ ϱ͕ϴϰϯ ;ϭ͕ϳϵϰͿͲͲͲ Ͳ ;ϳ͕ϲϯϳͿ ;ϭϯϬ͘ϳйͿϰͲϮϭϬϬE&/d^ͲKDZ^ϵ͕ϭϯϮ ϭ͕ϭϰϰ ϲ͕ϱϴϮϴ͕ϵϮϲ ϵ͕ϭϵϭϮϲϱ ϯ͘Ϭй ϱ͕ϰϯϴ ϰϳϱ͘ϯйϰͲϮϭϬϭE&/d^Ͳ,dϭ͕ϴϱϲϯϲϵ ϭ͕ϳϴϱϭ͕ϲϵϯ ϭ͕ϳϯϰϰϭϮ͘ϰйϭ͕ϰϭϲϯϴϯ͘ϳйϰͲϮϭϬϮE&/d^Ͳt^/ϳϱϲϵϬϲϰϬϲϱϭϲϲϳϭϲϮ͘ϱйϱϱϬϲϭϭ͘ϭйϰͲϮϭϬϯE&/d^ͲWWϯ͕ϲϴϮϴϰϱ ϯ͕ϭϯϯϯ͕ϭϬϱ ϯ͕ϭϰϮϯϳϭ͘ϮйϮ͕ϮϴϴϮϳϬ͘ϴйϰͲϮϭϬϰE&/d^Ͳ/ϭ͕ϵϰϲϯϭϱ ϭ͕ϰϯϵϭ͕ϲϮϳ ϭ͕ϰϯϯ;ϭϵϰͿ;ϭϭ͘ϵйͿϭ͕ϭϮϰϯϱϲ͘ϴйϰͲϮϭϬϱE&/d^ͲEd>Ϯ͕ϱϰϮ ϭ͕ϰϰϭ Ϯ͕ϬϳϭϮ͕ϮϬϵ Ϯ͕Ϭϴϯ;ϭϮϲͿ ;ϱ͘ϳйͿ ϲϯϬ ϰϯ͘ϳйϰͲϮϭϬϲE&/d^Ͳ,>d,ϰ͕ϮϲϬ Ϯ͕ϲϯϱ ϯ͕ϱϰϭϯ͕ϰϯϭ ϯ͕ϱϲϯϭϯϮ ϯ͘ϴй ϵϬϲ ϯϰ͘ϰйϰͲϮϭϬϳE&/d^Ͳ>dͬϭ͕ϳϰϳϱϰϰ ϭ͕ϰϳϳϭ͕ϲϯϬ ϭ͕ϴϯϰϮϬϰϭϮ͘ϱйϵϯϯϭϳϭ͘ϱйϰͲϮϭϬϴE&/d^ͲKd,ZϰϱϵϱϮϰϯϳϳϰϬϳϰϱϵϱϮϭϮ͘ϴй;ϭϰϳͿ;Ϯϴ͘ϭйͿdKd>^>Z/^ΘE&/d^ϭϮϮ͕Ϭϭϱ ϯϴ͕ϴϬϬ ϭϭϭ͕ϳϯϵ ϭϭϬ͕ϰϴϭ ϭϭϯ͕ϬϭϳϮ͕ϱϯϲϮ͘ϯйϳϮ͕ϵϯϵϭϴϴ͘ϬйϰͲϰϬϭϱKWZd/E'DdZ/>^ϲϭ͕ϰϱϯ ϲϱ͕ϯϱϴ ϵϵ͕ϯϵϰϳϬ͕ϬϬϬ ϱϬ͕ϬϬϬ;ϮϬ͕ϬϬϬͿ ;Ϯϴ͘ϲйͿϯϰ͕Ϭϯϲ ϱϮ͘ϭйϰͲϰϬϱϵDzKZΖ^Ed/>/ddZDW/'Eϭϯϴ ϯ͕ϱϲϯ Ϯ͕Ϭϭϴϰ͕ϬϬϬ ϱ͕ϬϬϬϭ͕ϬϬϬ Ϯϱ͘Ϭй ;ϭ͕ϱϰϱͿ ;ϰϯ͘ϰйͿϰͲϱϬϰϮsZd/^/E'ϭϰ͕ϲϮϵ ϭϴ͕ϵϱϰ Ϯϰ͕ϰϭϯϮϲ͕ϬϬϬ Ϯϲ͕ϬϬϬͲ Ͳ ϱ͕ϰϱϵ Ϯϴ͘ϴйϰͲϱϬϱϵKEdZd^ϰϴϭ͕ϵϯϳ ϲϲϵ͕ϴϲϵ ϱϯϰ͕ϵϲϵϰϳϱ͕ϬϬϬ ϵϰϱ͕ϬϬϬϰϳϬ͕ϬϬϬ ϵϴ͘ϵй;ϭϯϰ͕ϵϬϬͿ ;ϮϬ͘ϭйͿϰͲϱϬϲϬK^dZKsZz;ϭϱϰͿ ;ϯ͕ϰϯϬͿ ;Ϯ͕ϬϬϴͿͲͲͲ Ͳ ϭ͕ϰϮϮ ϰϭ͘ϱйϰͲϱϬϲϮK>>d/KEKEdZd^ϭ͕ϯϯϭ͕ϯϴϰ ϭ͕ϭϲϮ͕Ϯϵϴ ϭ͕ϯϵϰ͕ϲϴϮϭ͕ϯϭϮ͕ϬϬϬ ϭ͕ϯϲϬ͕ϬϬϬϰϴ͕ϬϬϬ ϯ͘ϳйϮϯϮ͕ϯϴϰ ϮϬ͘ϬйdKd>Kd,ZyWE^^ ϭ͕ϴϴϵ͕ϯϴϳ ϭ͕ϵϭϲ͕ϲϭϮ Ϯ͕Ϭϱϯ͕ϰϲϴ ϭ͕ϴϴϳ͕ϬϬϬ Ϯ͕ϯϴϲ͕ϬϬϬ ϰϵϵ͕ϬϬϬ Ϯϲ͘ϰй ϭϯϲ͕ϴϱϲ ϳ͘ϭйdKd>yWE^^ Ϯ͕Ϭϭϭ͕ϰϬϮ ϭ͕ϵϱϱ͕ϰϭϮ Ϯ͕ϭϲϱ͕ϮϬϳ ϭ͕ϵϵϳ͕ϰϴϭ Ϯ͕ϰϵϵ͕Ϭϭϳ ϱϬϭ͕ϱϯϲ Ϯϱ͘ϭй ϮϬϵ͕ϳϵϱ ϭϬ͘ϳйEdh'd ϭ͕ϳϮϬ͕Ϭϵϴ ϭ͕ϲϲϰ͕ϭϭϮ ϭ͕ϴϳϭ͕ϲϯϴ ϭ͕ϲϵϭ͕ϰϴϭ Ϯ͕ϭϵϯ͕Ϭϭϳ ϱϬϭ͕ϱϯϲ Ϯϵ͘ϳйϮϬϳ͕ϱϮϲϭϮ͘ϱйŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 11 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿZsEh͗ϯͲϭϭϬϲ>E^W&^;ϯϲϵ͕ϰϵϮͿ ;ϳϱ͕ϯϱϯͿ ;ϭϲϭ͕ϮϭϳͿ;ϲϱ͕ϬϬϬͿ ;ϲϱ͕ϬϬϬͿͲͲϴϱ͕ϴϲϰ ϭϭϯ͘ϵйϯͲϭϮϬϭKd,Z;ϰϴ͕ϲϴϮͿ ;ϰϴ͕ϲϰϰͿ ;ϰϮ͕ϮϴϭͿ;ϯϵ͕ϬϬϬͿ ;ϯϵ͕ϬϬϬͿͲ Ͳ ;ϲ͕ϯϲϯͿ ;ϭϯ͘ϭйͿϯͲϭϮϬϲKEd/KE^Ͳ ;ϲϳϴͿ ;ϯϱϬͿͲͲͲ Ͳ ;ϯϮϴͿ ;ϰϴ͘ϰйͿϯͲϭϯϬϯ>>/DKEͬ^KZ&/>^;ϭϲϵ͕ϯϲϴͿ ;ϭϳϴ͕ϲϮϱͿ ;ϭϴϲ͕ϱϳϵͿ;ϭϲϰ͕ϯϴϭͿ ;ϭϲϰ͕ϯϴϭͿͲ Ͳ ϳ͕ϵϱϰ ϰ͘ϱйϯͲϭϯϬϰ'Z^^hdd/E';ϭϯϳ͕ϬϭϬͿͲͲͲͲͲͲ ͲͲϯͲϭϯϯϯKEdZ/hd/KE^&ZKDs>KWZ^;ϯϱϯ͕ϮϬϴͿ ;ϮϬϲ͕ϴϯϳͿ ;ϳϮ͕ϴϳϱͿͲͲͲͲ;ϭϯϯ͕ϵϲϮͿ ;ϲϰ͘ϴйͿϯͲϭϵϯϯ>E^W&Z^ZsKEdΖE;Ϯϭ͕ϯϬϬͿ ;ϭϳ͕ϴϳϮͿ ;ϭϱ͕ϴϴϱͿ;ϭϱ͕ϴϴϱͿ ;ϭϯ͕ϴϳϳͿ;Ϯ͕ϬϬϴͿ ;ϭϮ͘ϲйͿ ;ϭ͕ϵϴϳͿ ;ϭϭ͘ϭйͿϯͲϭϵϲϯWZ<^sΘ&KEdΖE;ϭϱϰ͕ϰϮϱͿ ;ϭϭϲ͕ϮϱϳͿ ;ϭϯϲ͕ϭϱϲͿ;ϭϯϲ͕ϭϱϲͿ ;ϭϭϱ͕ϲϰϬͿ;ϮϬ͕ϱϭϲͿ ;ϭϱ͘ϭйͿ ϭϵ͕ϴϵϵ ϭϳ͘ϭйdŽƚĂůZĞǀĞŶƵĞ ;ϭ͕Ϯϱϯ͕ϰϴϱͿ ;ϲϰϰ͕ϮϲϲͿ ;ϲϭϱ͕ϯϰϯͿ ;ϰϮϬ͕ϰϮϮͿ ;ϯϵϳ͕ϴϵϴͿ ;ϮϮ͕ϱϮϰͿ ;ϱ͘ϰйͿ ;Ϯϴ͕ϵϮϯͿ ;ϰ͘ϱйͿyWE^͗ϰͲϮϬϬϬ^>Z/^Ͳ&ͬdϭ͕ϭϳϮ͕ϵϰϵ ϭ͕ϰϳϱ͕ϲϮϴ ϭ͕ϭϴϵ͕ϵϭϱϭ͕ϮϱϮ͕ϵϰϴ ϭ͕ϮϴϬ͕ϯϱϲϮϳ͕ϰϬϴ Ϯ͘Ϯй;Ϯϴϱ͕ϳϭϯͿ ;ϭϵ͘ϰйͿϰͲϮϬϬϭ^>Z/^ͲKͬdϳϲ͕ϳϰϴ ϲϰ͕ϭϯϭ ϳϱ͕ϳϰϱϴϬ͕ϯϱϬ ϴϬ͕ϯϱϬͲ Ͳ ϭϭ͕ϲϭϰ ϭϴ͘ϭйϰͲϮϬϬϮ^>Z/^ͲWͬdϰϭϰ͕ϯϯϴ ϭϬϯ͕ϭϭϱ ϰϲϮ͕ϴϵϯϰϯϮ͕ϯϵϵ ϰϲϵ͕ϳϭϭϯϳ͕ϯϭϮ ϴ͘ϲйϯϱϵ͕ϳϳϴ ϯϰϴ͘ϵйϰͲϮϬϬϯsd/KEWzͲ ϭϱ͕ϭϯϱͲͲͲͲͲ;ϭϱ͕ϭϯϱͿ;ϭϬϬ͘ϬйͿϰͲϮϬϬϰ^/<WzͲ ϯ͕ϯϱϰͲͲͲͲͲ;ϯ͕ϯϱϰͿ;ϭϬϬ͘ϬйͿϰͲϮϬϵϬzZEZh>^ϯ͕ϲϵϵ ϭϱ͕ϳϭϵ ;ϭϬ͕ϳϬϭͿͲͲͲͲ;Ϯϲ͕ϰϮϬͿ ;ϭϲϴ͘ϭйͿϰͲϮϭϬϬE&/d^ͲKDZ^ϭϮϬ͕Ϯϱϲ ϭϭϯ͕ϳϯϭ ϭϮϲ͕ϱϳϮϭϮϯ͕ϳϲϮ ϭϯϭ͕ϮϮϳϳ͕ϰϲϱ ϲ͘Ϭй ϭϮ͕ϴϰϭ ϭϭ͘ϯйϰͲϮϭϬϭE&/d^Ͳ,dϯϮ͕ϰϳϲ ϯϭ͕ϰϬϭ ϯϯ͕ϲϰϵϯϯ͕ϭϳϮ ϯϱ͕ϭϳϰϮ͕ϬϬϮ ϲ͘Ϭй Ϯ͕Ϯϰϴ ϳ͘ϮйϰͲϮϭϬϮE&/d^Ͳt^/ϭϯ͕Ϭϳϯ ϭϭ͕ϳϲϬ ϭϮ͕ϰϱϴϭϮ͕ϳϱϴ ϭϯ͕ϱϮϵϳϳϭ ϲ͘Ϭй ϲϵϴ ϱ͘ϵйϰͲϮϭϬϯE&/d^ͲWWϲϭ͕ϰϱϲ ϲϬ͕ϲϯϳ ϲϰ͕ϱϴϲϲϯ͕ϮϬϬ ϲϳ͕ϯϬϰϰ͕ϭϬϰ ϲ͘ϱй ϯ͕ϵϰϵ ϲ͘ϱйϰͲϮϭϬϰE&/d^Ͳ/ϯϯ͕ϱϯϮ ϯϮ͕ϵϵϱ ϯϬ͕ϱϱϳϯϱ͕ϳϱϱ ϯϰ͕ϵϰϵ;ϴϬϲͿ ;Ϯ͘ϯйͿ ;Ϯ͕ϰϯϴͿ ;ϳ͘ϰйͿϰͲϮϭϬϱE&/d^ͲEd>Ϯϱ͕ϰϴϱ Ϯϯ͕ϲϯϮ Ϯϯ͕ϵϬϭϯϭ͕ϲϲϮ ϯϭ͕ϱϵϲ;ϲϲͿ ;Ϭ͘ϮйͿ Ϯϲϵ ϭ͘ϭйϰͲϮϭϬϲE&/d^Ͳ,>d,ϰϮ͕ϰϭϳ ϰϯ͕ϰϯϭ ϰϯ͕Ϭϭϰϰϵ͕ϭϳϵ ϱϰ͕Ϭϯϱϰ͕ϴϱϲ ϵ͘ϵй ;ϰϭϳͿ ;ϭ͘ϬйͿϰͲϮϭϬϳE&/d^Ͳ>dͬϭϵ͕ϲϭϳ ϭϵ͕ϯϳϲ ϭϴ͕ϴϴϰϮϬ͕ϱϴϱ Ϯϯ͕ϵϮϬϯ͕ϯϯϱ ϭϲ͘Ϯй ;ϰϵϮͿ ;Ϯ͘ϱйͿϰͲϮϭϬϴE&/d^ͲKd,Zϱ͕ϱϴϰ ϱ͕ϰϮϳ ϱ͕ϯϲϱϱ͕ϲϱϱ ϲ͕ϲϬϰϵϰϵ ϭϲ͘ϴй ;ϲϮͿ ;ϭ͘ϭйͿϰͲϮϮϬϬt'ZKsZzͲ ;ϮϴϲͿͲͲͲͲͲϮϴϲϭϬϬ͘ϬйdKd>^>Z/^ΘE&/d^Ϯ͕ϬϮϭ͕ϲϯϬ Ϯ͕Ϭϭϵ͕ϭϴϲ Ϯ͕Ϭϳϲ͕ϴϯϴ Ϯ͕ϭϰϭ͕ϰϮϱ Ϯ͕ϮϮϴ͕ϳϱϱϴϳ͕ϯϯϬϰ͘ϭйϱϳ͕ϲϱϮϮ͘ϵйϰͲϰϬϬϬK&&/^hWW>/^ϭ͕ϳϬϲ ϭ͕ϯϴϲ ϭ͕ϳϳϮϭ͕ϴϱϬ ϭ͕ϴϱϬͲ Ͳ ϯϴϲ Ϯϳ͘ϴйϰͲϰϬϬϵ^&dz^hWW>/^ϱ͕ϮϬϴ ϲ͕ϴϰϬ ϳ͕ϯϮϲϳ͕ϮϬϬ ϳ͕ϱϬϬϯϬϬ ϰ͘Ϯй ϰϴϲ ϳ͘ϭйϰͲϰϬϭϬ>Kd,/E'>>KtEϳ͕ϲϯϵ ϲ͕ϵϮϳ ϴ͕ϱϰϵϴ͕ϱϬϬ ϵ͕ϬϬϬϱϬϬ ϱ͘ϵй ϭ͕ϲϮϮ Ϯϯ͘ϰйϰͲϰϬϭϯhd/>/d/^ϮϭϮ͕ϱϴϱ ϴϲ͕ϯϰϯ ϲϵ͕ϬϱϳϱϬ͕ϬϬϬ ϲϴ͕ϯϭϭϭϴ͕ϯϭϭ ϯϲ͘ϲй ;ϭϳ͕ϮϴϲͿ ;ϮϬ͘ϬйͿϰͲϰϬϭϱKWZd/E'DdZ/>^ϲϵ͕ϳϮϰ ϱϳ͕ϵϯϱ ϲϱ͕ϰϱϴϱϴ͕ϬϬϬ ϲϰ͕ϬϬϬϲ͕ϬϬϬ ϭϬ͘ϯй ϳ͕ϱϮϯ ϭϯ͘ϬйϰͲϰϬϮϭYh/WDEdͲKd,Zϭϭ͕ϮϳϬ ϳ͕ϴϴϰ ϭϮ͕ϮϮϬϭϭ͕ϱϬϬ ϭϭ͕ϱϬϬͲ Ͳ ϰ͕ϯϯϲ ϱϱ͘ϬйϰͲϰϬϮϮdKK>^Ϯ͕Ϯϱϳ ϯ͕Ϯϲϲ Ϯ͕ϲϴϰϯ͕ϬϬϬ ϯ͕ϬϬϬͲ Ͳ ;ϱϴϮͿ ;ϭϳ͘ϴйͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 12 of 13 ϮϬϭϱ ϮϬϭϲ ϮϬϭϳϮϬϭϳ ϮϬϭϴϮϬϭϴǀƐ ϮϬϭϴǀƐ ϮϬϭϳǀƐ ϮϬϭϳǀƐ&ƵůůzĞĂƌ &ƵůůzĞĂƌ &ƵůůzĞĂƌƉƉƌŽǀĞĚ ƉƉƌŽǀĞĚϮϬϭϳƵĚŐĞƚ ϮϬϭϳƵĚŐĞƚϮϬϭϲĐƚƵĂůϮϬϭϲĐƚƵĂůĐƚƵĂůƐ ĐƚƵĂůƐ ĐƚƵĂůƐƵĚŐĞƚ ƵĚŐĞƚ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ /ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿ/ŶĐƌĞĂƐĞͬ;ĞĐƌĞĂƐĞͿŽůůĂƌŚĂŶŐĞх нͬͲ ΨϮϬ͕ϬϬϬEWĞƌĐĞŶƚĂŐĞŚĂŶŐĞхнͬͲ ϭϬйϰͲϰϬϮϯWd,tzD/EdEEDdZ/>^ϰϬ͕ϵϰϮ ϭϱ͕ϰϱϱ ϯϵ͕ϱϯϳϰϮ͕ϯϬϬ ϰϮ͕ϯϬϬͲͲϮϰ͕ϬϴϮ ϭϱϱ͘ϴйϰͲϰϬϮϰ&EDdZ/>^ϰ͕ϯϴϵ ϲ͕ϯϱϳ ϵ͕ϮϱϮϭϭ͕ϬϬϬ ϭϭ͕ϬϬϬͲ Ͳ Ϯ͕ϴϵϱ ϰϱ͘ϱйϰͲϰϬϰϱDhE//W>h^/E^^ϰϲϬϳϰϮϳϲϵϰϱϬϰϱϬͲͲϮϳϯ͘ϲйϰͲϰϬϰϵ^/'E'ϰ͕ϯϮϮ ϭ͕ϱϮϴ ϰ͕ϲϰϵϱ͕ϬϬϬ ϱ͕ϬϬϬͲ Ͳ ϯ͕ϭϮϭ ϮϬϰ͘ϯйϰͲϰϬϱϬ&/>W/Edϭϲ͕Ϭϲϭ ϭϯ͕ϳϴϲ Ϯϭ͕ϲϲϭϭϳ͕ϬϬϬ ϭϴ͕ϬϬϬϭ͕ϬϬϬ ϱ͘ϵй ϳ͕ϴϳϱ ϱϳ͘ϭйϰͲϰϬϱϭ,KZd/h>dhZWZK'ZDϭϬ͕ϯϳϭ ϭϱ͕ϲϯϬ ϭϰ͕ϰϱϭϭϱ͕ϬϬϬ ϭϱ͕ϬϬϬͲ Ͳ ;ϭ͕ϭϳϵͿ ;ϳ͘ϱйͿϰͲϰϬϱϮ&Zdͬ'Z^^^ϭϱ͕ϵϯϵ ϭϳ͕ϰϴϵ ϭϳ͕ϲϮϯϯϯ͕ϬϬϬ ϯϯ͕ϬϬϬͲ Ͳ ϭϯϰ Ϭ͘ϴйϰͲϰϬϱϯWZ<>ͬ>/',d/E'ϭϴ͕ϴϵϴ ϭϲ͕ϲϱϭ ϭϲ͕ϯϴϴϭϰ͕ϬϬϬ ϭϰ͕ϬϬϬͲ Ͳ ;ϮϲϯͿ ;ϭ͘ϲйͿϰͲϰϬϱϰ/ZZ/'d/KEϰ͕Ϯϳϳ Ϯ͕ϰϰϳ ϭ͕ϭϯϵϱ͕ϭϬϬ ϱ͕ϭϬϬͲ Ͳ ;ϭ͕ϯϬϴͿ ;ϱϯ͘ϱйͿϰͲϱϬϮϲKhZ^^Θ^D/EZ^ϱ͕ϵϲϳ ϭ͕Ϯϳϳ ϱ͕ϵϲϭϲ͕ϲϬϬ ϲ͕ϲϬϬͲ Ͳ ϰ͕ϲϴϰ ϯϲϲ͘ϴйϰͲϱϬϮϴDDZ^,/W^ϭ͕ϲϳϰ Ϯ͕ϯϱϯϳϭϳϭ͕ϱϬϬ ϭ͕ϱϬϬͲͲ;ϭ͕ϲϯϲͿ;ϲϵ͘ϱйͿϰͲϱϬϮϵD/>'ϱϳϮϯϱϱϭϰϱϳϱϬϳϱϬͲͲ;ϮϭϬͿ;ϱϵ͘ϮйͿϰͲϱϬϯϳWZKWZdz/DWZKsDEdϭϲ͕ϵϮϴ Ϯϯ͕ϭϮϳ Ϯϵ͕ϯϰϴϯϬ͕ϬϬϬ ϰϬ͕ϬϬϬϭϬ͕ϬϬϬ ϯϯ͘ϯй ϲ͕ϮϮϭ Ϯϲ͘ϵйϰͲϱϬϯϴh/>/E'ZW/ZΘD/EdEEϭϲ͕Ϭϴϲ ϭϵ͕ϬϮϮ ϮϬ͕ϳϭϰϮϭ͕ϬϬϬ Ϯϭ͕ϬϬϬͲ Ͳ ϭ͕ϲϵϮ ϴ͘ϵйϰͲϱϬϰϯKE^h>d/E'ϰϱ͕ϰϰϯ ϵ͕ϳϭϯ ϱ͕ϭϭϲϭϱ͕ϬϬϬ ϭϱ͕ϬϬϬͲ Ͳ ;ϰ͕ϱϵϳͿ ;ϰϳ͘ϯйͿϰͲϱϬϰϱW,KdKKW/Z,Z'^Ϯ͕ϰϴϲ Ϯ͕ϰϵϬ Ϯ͕ϳϭϰϮ͕ϱϰϳ Ϯ͕ϰϬϬ;ϭϰϳͿ ;ϱ͘ϴйͿ ϮϮϰ ϵ͘ϬйϰͲϱϬϰϳWhZ,^K&dZ^ϱϬ͕ϰϵϵ ϴϳ͕ϭϬϭ ϱϮ͕ϳϴϭϱϬ͕ϬϬϬ ϱϬ͕ϬϬϬͲͲ;ϯϰ͕ϯϮϬͿ ;ϯϵ͘ϰйͿϰͲϱϬϱϵKEdZd^ϭϭ͕ϲϵϵ ϱ͕ϵϵϴ ϱ͕ϬϴϴϮϬ͕ϭϬϬ ϮϬ͕ϭϬϬͲ Ͳ ;ϵϭϬͿ ;ϭϱ͘ϮйͿϰͲϱϬϲϯt^d/^WK^>&ϭϰ͕ϵϰϬ ϭϰ͕ϯϰϮ ϭϮ͕ϵϰϳϭϴ͕ϬϬϬ ϭϴ͕ϬϬϬͲ Ͳ ;ϭ͕ϯϵϱͿ ;ϵ͘ϳйͿϰͲϱϬϲϰKEdZd^Ͳ'Z^^hdd/E'Ϯϳ͕ϱϰϲ ϵ͕ϲϮϳ ϭϯ͕ϭϱϯϮϬ͕ϬϬϬ ϮϬ͕ϬϬϬͲ Ͳ ϯ͕ϱϮϲ ϯϲ͘ϲйϰͲϱϬϳϳZ>dzdy^ϱϬ͕ϲϭϯ ϱϬ͕ϵϵϮͲͲͲͲͲ;ϱϬ͕ϵϵϮͿ;ϭϬϬ͘ϬйͿϰͲϱϬϴϲ^hZ/dzϯϬ͕Ϯϭϯ ϯϱ͕ϱϵϵ ϭϯ͕ϮϬϴͲͲͲͲ;ϮϮ͕ϯϵϭͿ ;ϲϮ͘ϵйͿϰͲϱϬϴϳZKZ/h>dhZ>KEdZdϮϰ͕ϮϱϮ ϭϴ͕ϯϯϬ ϰϱ͕ϳϭϴϲϬ͕ϬϬϬ ϱϬ͕ϬϬϬ;ϭϬ͕ϬϬϬͿ ;ϭϲ͘ϳйͿϮϳ͕ϯϴϴ ϭϰϵ͘ϰйϰͲϱϬϴϴ^,ZhD/EdEEϵϲ͕ϳϲϰ ϰϰ͕ϰϴϳ ϴϳ͕ϵϵϲϳϱ͕ϬϬϬ ϲϱ͕ϬϬϬ;ϭϬ͕ϬϬϬͿ ;ϭϯ͘ϯйͿϰϯ͕ϱϬϵ ϵϳ͘ϴйϰͲϲϬϬϮd/sEd,Z'^E&^ͲͲ ϭ͕ϮϭϰͲϱϴϲϱϴϲͲϭ͕ϮϭϰͲϰͲϴϬϬϯKEdZ/hd/KE^dK/^Zd/KEZzZ^Zs^ϲϵϳ͕ϯϳϬ Ϯϯϴ͕ϯϯϳ Ϯϳϯ͕ϰϲϲϯϭ͕ϱϬϬ ϯϭ͕ϱϬϬͲͲϯϱ͕ϭϮϵ ϭϰ͘ϳйdKd>Kd,ZyWE^^ ϭ͕ϱϭϵ͕ϭϬϬ ϴϮϯ͕ϴϭϲ ϴϲϮ͕ϴϮϭ ϲϯϰ͕ϴϵϳ ϲϱϭ͕ϰϰϳ ϭϲ͕ϱϱϬϮ͘ϲй ϯϵ͕ϬϬϱ ϰ͘ϳйdKd>yWE^^ ϯ͕ϱϰϬ͕ϳϯϬ Ϯ͕ϴϰϯ͕ϬϬϮ Ϯ͕ϵϯϵ͕ϲϱϵ Ϯ͕ϳϳϲ͕ϯϮϮ Ϯ͕ϴϴϬ͕ϮϬϮ ϭϬϯ͕ϴϴϬ ϯ͘ϳй ϵϲ͕ϲϱϳ ϯ͘ϰйEdh'd Ϯ͕Ϯϴϳ͕Ϯϰϱ Ϯ͕ϭϵϴ͕ϳϯϲ Ϯ͕ϯϮϰ͕ϯϭϲ Ϯ͕ϯϱϱ͕ϵϬϬ Ϯ͕ϰϴϮ͕ϯϬϰ ϭϮϲ͕ϰϬϰ ϱ͘ϰй ϭϮϱ͕ϱϴϬ ϱ͘ϳй Finance Advisory Committee Meeting Agenda Wednesday, March 28, 2018 Item 3 Page 13 of 13