Loading...
2018-38-Minutes for Meeting December 18,2017 Recorded 1/25/2018Recorded in Deschutes County Nancy Blankenship, County Clerk Commissioners' Journal CJ2018-38 01/25/2018 7:40:42 AM uiiimimuimimuuii I -A For Recording Stamp Only Deschutes County Board of Commissioners 1300 NW Wall St., Bend, OR 97703-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS Allen Conference Room Monday December 18, 2017 Present were Commissioners Tammy Baney, Anthony DeBone and Phil Henderson. Also present were Tom Anderson, County Administrator, Erik Kropp, Deputy County Administrator, David Doyle, County Counsel; Christopher Ogren, Administrative Intern; and Sharon Ross, Board Executive Secretary. No representatives of the media were in attendance. CALL TO ORDER: Chair Baney opened the meeting at 4:35 p.m. EXECUTIVE SESSION: At the time of 4:36 p.m., the Board went into Executive Session under ORS 192.660 (2) (h) Litigation. The Board came out of Executive Session at 5:45 p.m. Minutes of Board of Commissioners' Work Session December 18, 2017 Page 1 of 3 ACTION ITEMS: 1. November 2017 Treasurer's Report and Financial Reports: This item was rescheduled to a future meeting agenda. 2. Health and Wellness Contracts Update: Kathleen Hinman and Trygve Bolken, Human Resources presented this item for discussion. The new plan year starts in January and the contracts for health and wellness will be presented for consideration on the December 27th Business Meeting Agenda. Staff gave an update on the proposed plan changes, status of Deschutes On - Site service partner contract renewals, and finalization of the Third Party Administrator agreement. A summary of plan changes and benefits were reviewed. These changes were recommended by the Employee Benefits Advisory Committee. OTHER ITEMS: • County Administrator Anderson presented for consideration a letter of support of EDCOs grant application to be submitted to Oregon Community Foundation for Venture Catalyst Initiative. DEBONE: Move approval of signature HENDERSON: Second VOTE: DEBONE: Yes HENDERSON: Yes BAN EY: Chair votes yes. Motion Carried • Deputy County Administrator Kropp reported on a request from Sally Pfiefer for Sagewood and whether the County would allow the use of our Cascade Peer Support Center to allow a temporary homeless shelter. The building is in terrible condition and because of zoning would need to go through city land use. Minutes of Board of Commissioners' Work Session December 18, 2017 Page 2 of 3 ADJOURN: Being no further discussion, the meeting adjourned at 6:08 p.m. DATED this CPACPI- Board of Commissioners. ATTEST: Recording Secretary Day of 201_ for the Deschutes County Tammy Baney, Chair, 7 Anthony DeBone, Vice Chair 2017 Philip G. Hent son, Commissioner Minutes of Board of Commissioners' Work Session December 18, 2017 Page 3 of 3 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/ 1�i'I�1����9L�I`►IS - ` � �1 DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 PM, MONDAY, DECEMBER 18, 2017 Allen Conference Room - Deschutes Services Building, 2ND Floor — 1300 NW Wall Street — Bend Pursuant to ORS 192.640, this agenda includes a list of the principal subjects anticipated to be addressed at the meeting. This notice does not limit the ability of the Board to address additional subjects. Meetings are subject to cancellation without notice. This meeting is open to the public and interested citizens are invited to attend. Work Sessions allow the Board to discuss items in a less formal setting. Citizen comment is not allowed, although it may be permitted at the Board's discretion. If allowed, citizen comments regarding matters that are or have been the subject of a public hearing process will NOT be included in the official record of that hearing. Work Sessions are not normally video or audio recorded, but written minutes are taken for the record. CALL TO ORDER ACTION ITEMS 1. November 2017 Treasurers Report and Financial Reports - Wayne Lowry, Finance Director/Treasurer 2. Health and Wellness - Contracts Update - Kathleen Hinman, Human Resources Director EXECUTIVE SESSION 3. Executive Session under ORS 192.660 (2) (d) Labor Negotiations At any time during the meeting, an executive session could be called to address issues relating to ORS 192.660(2)(e), real property negotiations; ORS 192.660(2)(h), litigation; ORS 192.660(2)(d), labor negotiations; ORS 192.660(2)(b), personnel issues; or other executive session categories. Executive sessions are closed to the public; however, with few exceptions and under specific guidelines, are open to the media. Board of Commissioners Work Session Agenda Monday, December 18, 2017 Page 1 of 2 OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. F-ITIK01110111 Deschutes County encourages persons with disabilities to participate in all programs and activities. To request this information in an alternate format please call (541) 617-4747. FUTURE MEETINGS: Additional meeting dates available at www.deschutes.org/meetingcalendar (Please note: Meeting dates and times are subject to change. All meetings take place in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572.) Board of Commissioners Work Session Agenda Monday, December 18, 2017 Page 2 of 2 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners Work Session of December 18, 2017 DATE: December 12, 2017 FROM: Wayne Lowry, Finance, 541-388-6559 TITLE OF AGENDA ITEM: November 2017 Treasurers Report and Financial Reports RECOMMENDATION & ACTION REQUESTED: Discussion of November 2017 Treasurers Report and Selected Financial Reports ATTENDANCE: Wayne Lowry, Finance Director/Treasurer SUMMARY: Monthly Report @@�@@@/ 41 @in©1izo 6 w$dc/ condo=M co_oo=� 00000no BS2E2) �$ «o_o -cM _ 1_ k � @ @ @ @ c omU) 0R2 kkp�GNN 40 � $ 2 \ E m , U)k\kit£$ F ' \kK. § T)■ = A 0 \f § E ■)-r 2k , _ ; i 2 4 8 2§$,§ E @ k u=u==Q2o o � a§¥ � ® LD / E± EU! cm 4)_ r % _ _ _ § \ c � \ ' kak gn � I m - � RQ§ o �R . & N 04 - � 2 - 04 ® - � k k � 0 u § » )( . / / K §� 2 - ®©Ea 0 �k§ k J §%S k E\§ m aU) ; § U ELL 2 §J/c o § £ a ) � . o @@�@@@/ 41 @in©1izo 6 w$dc/ condo=M co_oo=� 00000no BS2E2) �$ «o_o -cM _ 1_ k � @ @ @ @ e a @ 0R2 kkp�GNN 40 � $ \ E m , U)k\kit£$ § T)■ = A 0 0 ��� ■)-r 0z , _ ; i 2 4 8 2§$,§ E @ k u=u==Q2o moo== , c c � (]z .]% 0 0 CL 0z a\/ a§¥ ® LD / E± EU! 4)_ 2@ k\ c � I m - � o . � � � u )( §� Deschutes County Investments Tennessee Valley Authority CASTLE 11/2112014 12115/2017 14 AA+ A92 _... 1,268 _ Portfolio Management 1,058,504 - - 0189AK1 Precision Castparts Corp , 12/13/2016 1/151201845 AA- A2 1 250 Portfolio Details - Investments 1.250,000 1,249.700 <. 9748FGO Wells Fargo Corporate Note .. 12/9/2016 :... ........... November 30, 2017 1,500 1,601 2,000,000 1,999.700, 1,999,751, - - 988J5A1 Wells Fargo Corporate Note CASTLE 1129/2016 1/22120181 52 Purchase Maturity 1: Days To Ratings Coupon 999,940, Par Market Book Call CUSIP'. Security Broker Date DateMaturity S&P ;Moody's Rate YTM 365 Value ' Value Value Date 427542KW4 Hermiston OR DADAV 9/21/2016' 1 2/112 01 7 1 DAA- 2.000, 0.901 590,000! 590.000. 590,000 - 494751 DHO King County Washington FPD PJ 12115/2015 12/1/2017 o AA+ 1,220 1.218 23D,000, 230,000 230,000. - - 3696045BC6 General Electric - CorporateN CASTLE : 9/6/2016 12/6/2017 5,AA+ Al 5.250 1,050 1,000,000 1,000,220 1,000,578 - - SYS10520 Lewis & Clark Bank 1.050 6/8/2018 12/8/2017 7 1.000 1,000 240,000 240,000 240,000 - - 880591CU4 Tennessee Valley Authority CASTLE 12/1/2016 12/15/2017' 14 AA+ 6250, 1 011 1,00000,0 1,001,940 1,002,021 - - 059FAZ4 Tennessee Valley Authority CASTLE 11/2112014 12115/2017 14 AA+ A92 1205 1,268 1,059,000 1,056.396 1,058,504 - - 0189AK1 Precision Castparts Corp CASTLE 12/13/2016 1/151201845 AA- A2 1 250 1 318 1.250,000 1,249.700 1,249,896, - 9748FGO Wells Fargo Corporate Note CASTLE 12/9/2016 111612018, 46A A2 1,500 1,601 2,000,000 1,999.700, 1,999,751, - - 988J5A1 Wells Fargo Corporate Note CASTLE 1129/2016 1/22120181 52 Aa2 1 650' 1.580 1,000,000' 999,940, 1,000,097 - - 976WBH8 Wachovia Corp CASTLE 2/26/2016 2/1/2018 62'A A2 5,750 1,690 1,000.000 1,006,510 1,006,628 - 771EAL5 FICO Strip CASTLE 2/24/2015 218/2018; 69. Al J 252' 1.318 _ 1,260,000 1,256,485 1,256 975, - - 771EALS FICO Strip CASTLE ' 2/25/2015 2/8/2018 69' 1,257 1 323 740,0001 737,935 738,2161 - - 34G8M71 'Federal Home Loan Mtg Corp CASTLE 2/26/2016 212612018, 87AA+ : 1.050 1,050 3,000.000' 2,998,050 3,000,000' - - 607VA96 Oregon State Lottery DA DAV 6/1312016 411/2098 121 AAA AA2 1.353 0.970 200,000 199,888 200,252 - - 607VA96 Oregon State Lottery DA DAV 11/27/2017 4/1/2018 121 AAA AA2 1 353 1.500 250,000 249,860 249,874 - - 642434CD2 Southern CA Gas Co CASTLE 4/1012017 4/15/2018 135 A+ A92 5.450 1A73 1,000,000_ 1,013,800 1,014,637 - - 913366HS2 University of California CASTLE 3/21/2017 5/1512018' 165 AA- Aa3 0.936 1.351 3,000.000 2,991,060 2,994.391. - - 912828XA3 U.S. Treasury PJ 11/30/2616 5/15/2016 165, AA, Aaa 1.000 1,000. 2,000,000, 1,996,100 2,000,000: - - 3135GOXDO Federal National Mtg Assn CASTLE 1/412017 5/2112018, 171 AA+ Aaa 1.000 1,250 500,000. 498,740 500,000, 2/2112018 3130A8763 Federal Home Loan Bank VINISP 12/6/2016 5/30/2018' 180 AA+ Aaa 1.000 1.141' 1,500,000, 1,496,085' 1,500,000 - - 06050TMC3 Bank of America - Cor orate N. p CASTLE 51912017 6/5!2016 : 1864+ Al ' 1.7x0 1.540 ' 1,000,000 '. 1,000,100 1,001,058 3132XOLRO Federal Agriculture Mtg Corp PJ 1218/2016 8/8/2018' 1891 , 1-100 1.100 2,000,000 1,997,000 2.000,000' - - 904121NCO -Umatilla School District PJ 5/7/20151 6115/2018 196. AA+ Aa3 1430 1,430' 750,000` 747,848 750,000: - - 98385XAP1 XTO Energy Inc CASTLE 8/4/2015 6/1512018 196 AAA Aaa 5,500 1.500 1,000,000' 1,019,890 1,021,018; - - 10592 Washington Federal CD PJ 5/22/2017 612212018 203 AA2 0.900' 0.913 243,643' 243,643 243,643 - - 166764AEO Chevron Corp CASTLE 4/15/2016 6/24/2D18' 205 AA- Aa2 1.718 1 191' 2,000,000 2,000,3601 2,005,846; 5/24/2018 166764AEO Chevron Corp CASTLE 10/11/2016 6/24/2018 205'AA- Aa2 1.718` 1.259` 1,000,000 1,000,180 1,002,285. - - 939307HF4 Hillsboro SO Pension Bonds PJ 3/30/2015 6/30/2018; 211 Aa3 1 732 1.650' 985,000 984,517' 985,452 - - 938429M46 Washington County SO Municipal PJ 9/6/2016 6/30120181 211 Aa3 1,585 0,999 250,000 249,795 250,839 - - 3135GOL43 Federal National Mtg Assn CASTLE 12/13/2016 7/13/2018 224;AA+ Aaa 0 850 1,221 1,000,0001 995,130 1,00D,000 1/13/2018 88059EM78 Tennessee Valley Authority y y DA DAV 2/2212018 7/95/2018 226 1 021': L065 500 000, 494,525 496,7951 , 3133EGNU5 Federal Farm Credit Bank CASTLE 8/112016 7/27120181 238 AA+ Aaa 0.9601 0,960 1,000000' 996,070 1,000,0001 • - 3134G9067 Federal Home Loan Mtg Corp CASTLE 7/2712016 712712018, 238;.AA+ _Aaa 1,050' 1,0501 3,000,000' 2,987,580 3,000,000: 1/27/2018 934876AGO Port of Newport OR Lease DA DAV 3/2712017 811/2018 243 AA 4.500' 1450 610,000 620,291 622,232 - - 842400FJ7 Southern Cal Edison CASTLE 5/26/2017 8/1512018 257IA Aa3 5500 1 5201 2,000,0001 2,050,900 2,055,406 - - 65371AU2 Oceanside California Pension _ CASTLE 1/27/2017 8/15/2018 2571 AA 2298: 1.551. 1,850,000 1,857,086: 1,859,600 - - 544351KMO Los Angeles Calif Go Ref Bds PJ 12/21/2016 9/1/2018 274 AA2 1.210 1,209 1,000,000' 995,7501 1,000,000' - - 3134GAKF0 Federal Home Loan MtgCorp CASTLE 1011812016' 9/12/2018 285'AA+ ,Aaa 1.110 1,110 3,000,000 2,990,010 3,000,00012/12/2017 3134G8UN7 Federal Home Loan Mtg Corp ,CASTLE : 3/3012016 9/2812018 301 SAA+ :Aaa 1.200: 1-200 2,000.000** 1,991,800:. 2,000,000 12/28/2017 3134G9YA9 Federal Home Loan Mtg Corp CASTLE 6/28/2016 9/28/2018 301 AA+ Aaa 1.010 1 000 2,520,000, 2,507.980 2,520,000 12/28/2017 3134GAND3 Federal Home Loan Mtg Corp CASTLE 9/28/2016 9/28/2016 301 AA+ Aaa 1,050 1 050 4,000,000 3,980,440 4.000,000 - - 3133EFJP3 Federal Farm Credit Bank CASTLE 11/412016 10/15/2018 318 AA+ Aaa 1 100_` 1 100 5,000000 4.971.250 5,000,000 - 3136G2PZ4 Federal National Mtg Assn CASTLE 5/22/2017 10/29/2018 332 AA+ Aaa 1 190 1 340 5,000,000', 4,972,650 5,000,000 1/29/2018 912828WDB U.S Treasury CASTLE 12/112015, 10/31/2016 3341AAA Aaa 1.250 1 223, 1,000,000 996,210. 1,000,245 - - 91282BT83 U.S. Treasury -CASTLE 12/14/2016 10131/2018` 334', AAA Aaa 0.750,_ 1.155' 3,000,000 2,975,280 2,989,045 - - 31771KAJ6 FICO Strip CASTLE 9/28/2017 11/212018 336 1.460 1 520 5,000,000 4,919,900 4,931,863 - - 427542KX2 Hermiston OR DA DAV 9/21/2016 12/1/2018 365 AA- 3.000 1.001 605,000 614,136 616,935 - - 0605OTME9 Bank ofAmerica- Corporate CASTLE 5/16/2017 12/7/2018 371 :A+ Al 2050, 1700 3,180000' 3,184,675 3,191,099 - - 31771EAN1 FICO Strip CASTLE 11/3/2016 12/27/2018: 391 0.984 1 025 1,000,000 979,890 989,312 - - 912828A75 U.S. Treasury CASTLE 6/812015; 12/31/2018 395 AAA Aaa 1.500' 1,324 1,000000 997,810 1,001,849 - - 3132XONJ6 Federal Agriculture Mtg Corp CASTLE 5/1/2017 1/23/2019 418 1.270 1,400' 3.000.000' 2.988,480,] 2,995,589, - - 20271RAF7 ICommonwealth BKAustrNY CASTLE 9/18/2017 3/13/2019 467 AA- Aa3 2.250 1720' 2,600,000 2,605,850 2,617,378; - - 68607VS71 Oregon State Lottery CASTLE 4/5/2017 4/1/2019, 486. Aa2 1.602: 1,581 1,000,000 995,800 1,000,282 - - 459058FC2 International Bonds for Recons CASTLE 12/15/2016 4/26/2019 511 AAA Aaa 1.250' 1,500 2,000,000 1,983,540 2,000,000' - - 06406HBMO Bank of New York Mellon Corp CASTLE 11/15/2017 5/15/2019 530 A Al 5.450 1.950 1,000,000 1,047,560 1,049,964 250351FJ7 Deschutes County Ore Sch Dist PJ 8/16/2016 6/15/2019. 561 AA1 1.360 1,360 245,ODO. 241,808 245,000 - - 938429R66 Washington County SO Municipal I IPJ 5/11/2017 6/15/2019 561,AA+ Aal 1488' 1488 400,000 397,404 400,000` - - 3137EAB1 Federal Home Loan Mtg Corp CASTLE 7/20/2016 7/1912019 595 AA+ Aaa 0.875 0957 1,000,000 984,860 998,681 - 13034PZD2 CALIFORNIA ST HOUSING FINANt CASTLE 11/2/2017 8/1/2019 608 AA- Al 1.952 1.850 1,070,000 1,068,128 1,071,766 • - 3135GON33 Federal National Mig Assn CASTLE 8/1812016 8/2/2019 609.AA+ Aaa 0.875 1000, 1,000,000 984.620 997,944 - - 06406HCW7 Bank of New York Mellon Corp CASTLE 11/312016 9/11/2019 649,4 Al 2.300 1,532 1,675.000 1,680,343 i 1,696,868' 8/11/2019 48125LRJ3 JPMorgan Chase • Corporate N CASTLE 4/10/2017 9/23/2019 661,A+ Asa 1.918; 1.617; 3,000.000 3,022,5301 3,016,212 8/23/2019 48125LRG9 JPMorgan Chase - Corporate N CASTLE 6/28/2017 9/23/2019 661,A+ Aa3 ! 1 650 1 8401 1,300,000 1,291,6281 1,295.660 8/23/2019 313586RC5 Federal National Mtg Assn CASTLE 12/412015 10/9/2019 677AA- 1.891 2.031 1,400,000 1.347,948 1,350,215'_ - - 313586RC5 Federal National Mlg Assn CASTLE 3117/2016 10/912019: 677.AA- 1 665 1,774 600.000 577,6921 581,214 - - 313586RC5 Federal National Mtg Assn CASTLE 818/2016 10/9/2019 677 AA- 1.252 1.3181 400,000, 385,128 390,5821 - - 313586RC5 Federal National Mtg Assn CASTLE 11/22/2017 10/9/2019 677 AA- 1.928 2.030 3,600,000 3,466,152 3,469,471 - - 76116FAA5 RFSCP STRIP PRIN CASTLE 9/21/20171 10/15/20191 683' 1.499 1.572 1,000,000`, 965,190' 971,566' - - 3135GOR39 Federal National Mtg Assn CASTLE 11/10/2016 10/24/20191 692,AA+ Aaa 1.000; 1,173 2,000,000, 1,968,220 1,993,581 - - 1912828F62 U.S. Treasury CASTLE 1D111/2016; 10/3112019' 699 AAA Aaa 1.500 1,008, 2,000,000 1,988,900 2,018.513 - - 961214BK8 Westpac CASTLE 8/30/2017 11/1912019 718 AA- Aa3 4.875 1.826 2,OOD,000, 2,100,320 2,116,966, - - 594918AYO Microsoft Corp CASTLE 8/812016! 2/12/2020 803 AAA Aaa 1.850 1,298 1,000,000' 996,010 1,011,827 1/1212020 13063CSO4 California St VINISP 9/21/2017 41112020` 852 AA- Aa3 1.800) 1,800 78D.000 775,414 780,000 - - 3134GBNK4 Federal Home Loan Mtg Corp CASTLE 7/13/2017 5/29/2020 910 Aaa 1,625! 1.671 3.000,000 2,976,360 2,996,896 5/29/2019 569203MA7 Salem-Keizer School District CASTLE 7/26/2017 6/30/2020 942 Aa2 2.107 1.778 2,310,OOD' 2,302,100 2,328,894 - - 686053DH9 Oregon School Boards Assoc DA DAV 11/2/2015 6/30/2020 942 AA Aa2 5,373 2.050 875,00D, 942,576. 946,197, - - 686053DH9 Oregon School Boards Assoc CASTLE 6/24/2016 6/30/2020 942 iAA Aa2 5.373 1.570 500,OOD, 538,615, 547,3721 - - 686053CK3 Oregon School Boards Assoc CASTLE 3/1512017 6/30/2020 942 AA- Aa2 2.063 2 149 1,000.000 938,940 946,7691 - - 949746GM6 'Wells Fargo Corporate Note PJ 1/19/2017 7/22/2020' 9641A A2 2.600 2.350 1.000,000' 1,006,460 1,006,302, - - 940093R25 Washington Univ Higher Ed PJ 1/19/2017 10/1/2020' 1035' Aa2 5.930 1.970.1 400,000 440,300: 443,067 - - 492244DV7 Kern CommunityCollege CASTLE 11115/2010 11/1/20201 1066 AA- 2.893 1,800 500,000' 509,030 515,316 - GENERAL FUND Schedule of Financial Operating Data a) Historically, 91 % of the current year taxes are received by the end of November. b) Includes $500,000 PIAT c) A & T Grant received quarterly. Q1 received July; Q2 received October d) Projected to be less than budgeted due to YTD unfilled positions. Page 1 FY 2017 Year to Date July 1, 2017 through November 30, 2017 (42% of the year) FY 2018 %Of Actual Actual Budget Budget Projected Variance Revenues Property Taxes - Current $ 25,816,331 $ 24,455,658 93% a) $ 26,296,000 26,296,000 - Property Taxes - Prior 465,085 299,588 86% 350,000 350,000 - Other General Revenues 2,499,968 1,942,590 83% b) 2,345,822 2,345,822 - Assessor 860,861 463,195 55% c) 848,867 848,867 County Clerk 1,952,209 713,746 38% 1,896,945 1,896,945 - BOPTA 12,546 7,139 57% c) 12,480 12,480 - District Attorney 253,480 1,223 1% 187,400 187,400 - Tax Office 196,203 119,058 61% c) 196,200 196,200 - Veterans 96,889 40,556 25% 162,223 162,223 - Property Management 94,500 7,250 7% 97,000 97,000 - Total Revenues 32,248,072 28,050,002.17 87% 32,392,937 32,392,937 - Expenditures Assessor 3,993,958 1,722,083 40% 4,291,041 4,291,041 - County Clerk 1,684,783 456,247 25% 1,820,344 1,795,344 25,000 BOPTA 65,175 28,786 42% 68,138 68,138 - District Attorney 6,095,393 2,601,721 39% d) 6,701,724 6,601,724 100,000 Medical Examiner 146,817 51,561 30% 172,184 172,184 - Tax Office 785,346 345,841 41% 849,312 849,312 - Veterans 403,775 176,239 36% 492,630 492,630 - Property Management 247,568 103,237 37% 276,097 276,097 - Non -Departmental 1,268,363 446,694 34% 1,328,089 1,328,089 - Total Expenditures 14,691,178 5,932,410 37% 15,999,559 15,874,559 125,000 Transfers Out 17,856,310 6,269,886 36% 17,445,890 17,445,890 - Total Exp & Transfers 32,547,489 12,202,296.08 36% 33,445,449 33,320,449 125,000 Change in Fund Balance (299,416) 15,847,706 (1,052,512) (927,512) 125,000 Beginning Fund Balance 11,217,374 10,917,957 109% 10,000,000 10,917,957 917,957 Ending Fund Balance $10,917,957 $ 26,765,664 $ 8,947,488 $ 9,990,445 $1,042,957 a) Historically, 91 % of the current year taxes are received by the end of November. b) Includes $500,000 PIAT c) A & T Grant received quarterly. Q1 received July; Q2 received October d) Projected to be less than budgeted due to YTD unfilled positions. Page 1 COMM JUSTICE -JUVENILE Schedule of Financial Operating Data Revenues OYA Basic & Diversion $ ODE Juvenile Crime Prev Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 Food Subsidy Gen Fund -Crime Prevention Interest on Investments OJD Court Fac/Sec SB 1065 Contract Payments Case Supervision Fee Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Transfers Out-Veh Reserve Total Expenditures 355,586 86,497 84,121 74,700 36,045 18,744 20,000 17,512 18,438 10,920 5,964 3,170 731,697 5,005,247 1,204,317 FY 2018 Variance $ - Year to Date July 1, a) 2017 through FY 2017 November 30, 2017 21,137 (42% of the year) a) 71,982 % of Actual Actual Budget Revenues OYA Basic & Diversion $ ODE Juvenile Crime Prev Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 Food Subsidy Gen Fund -Crime Prevention Interest on Investments OJD Court Fac/Sec SB 1065 Contract Payments Case Supervision Fee Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Transfers Out-Veh Reserve Total Expenditures 355,586 86,497 84,121 74,700 36,045 18,744 20,000 17,512 18,438 10,920 5,964 3,170 731,697 5,005,247 1,204,317 FY 2018 Variance $ - 0% a) $ 346,046 $ 407,113 $ 61,067 21,137 29% a) 71,982 91,379 19,397 35,893 42% b) 85,000 77,000 (8,000) 29,250 53% c) 55,000 60,000 5,000 17,747 48% d) Internal grant funded quarterly. 36,658 36,658 - 7,898 39% 20,000 20,000 - 5,000 25% d) 20,000 20,000 - 7,862 52% 15,000 16,000 1,000 8,054 47% c) 17,000 21,600 4,600 2,864 36% 8,000 8,000 - 2,592 43% c) 6,000 7,000 1,000 2,155 117% 1,850 3,000 1,150 140,452 21% 682,536 767,750 85,214 2,130,478 40% e) 5,313,863 5,100,000 213,863 485,612 41% 1,198,996 1,198,996 - 17,250 25% f) 69,000 69,000 - 2,633,340 40% 6,581,859 6,367,996 213,863 Revenues less Expenditures (5,521,867) (2,492,888) (5,899,323) (5,600,246) 299,077 Transfers In -General Fund 5,464,591 2,332,351 42% 5,597,643 5,597,643 - Change in Fund Balance (57,276) (160,537) 1 (301,680) (2,603) 299,077 Beginning Fund Balance 1,415,374 1,358,098 113% 1,200,000 1,358,098 158,098 Ending Fund Balance $ 1,358,098 $1,197,561 $ 898,320 $ 1,355,495 $ 457,175 a) Reimbursement payment received quarterly. 1st quarter received/requested. Grant was increased by legislature subsequent to budget adoption. b) Less than budgeted lease revenue c) Inmate housing trending at greater than budgeted. d) Internal grant funded quarterly. e) Projection decreased due to staff vacancies in Q1 and new hires who started at a lower salary step range in beginning of fiscal year. f) Includes vehicle repair and maintenance costs. Page 2 Sheriffs Office and LEDs Schedule of Financial Operating Data FY 2018 Bud et Projected I Variance REVENUES Year to Date July 1, 2017 through FY 2017 November 30, 2017 42% of the ear LED #1 Countywide of Actual Actual Bud et FY 2018 Bud et Projected I Variance REVENUES LED #1 Countywide Property Taxes Current Year $21,137,803 $20,500,654 93% a) $22,045,228 $22,045,228 $ - Prior Year 308,837 215,041 54% 400,000 400,000 - Interest 110,368 32,995 41% 80,000 80,000 - Total LED #1 Countywide 21,557,009 20,748,690 92% 22,525,228 22,525,228 - LED #2 Rural Property Taxes Current Year 9,474,144 9,183,208 93% a) 9,916,642 9,916,642 Prior Year 141,704 97,532 53% 185,000 185,000 - Interest 90,261 34,079 56% 61,300 61,300 - Total LED #2 Rural 9,706,109 9,314,819 92% 10,162,942 10,162,942 - Sheriff's Office Revenues 8,249,855 2,952,857 40% e) f) 7,386,585 7,444,585 58,000 Total Revenues 39,512,973 33,016,366 82% 40,074,755 40,132,755 58,000 EXPENDITURES Sheriffs Services 2,386,420 1,108,482 42% b) 2,639,355 2,750,737 (111,382) Civil/Special Units 1,117,489 590,046 42% b) 1,402,554 1,303,939 98,615 Automotive/Communications 2,601,537 808,650 33% 2,481,701 2,481,701 - Detective 1,796,143 813,203 41% 1,995,351 1,995,351 - Patrol 8,822,794 3,903,568 40% h) 9,724,673 9,715,876 8,797 Records 695,956 267,964 35% d) 761,258 806,258 (45,000) Adult Jail 16,236,326 6,976,083 40% i) 17,488,887 17,644,400 (155,513) Court Security 270,173 190,069 46% c) 410,659 359,100 51,559 Emergency Services 284,009 152,438 40% e) 379,092 387,092 (8,000) Special Services 1,500,791 717,430 46% f) 1,543,848 1,611,348 (67,500) Training 590,962 305,556 47% g) 654,646 667,246 (12,600) Other Law Enforcement Services 904,547 342,033 37% c) 935,144 928,544 6,600 Crisis Stabilization Center 20,160 4% 558,424 558,424 - Non -Departmental 112,846 865 42% 2,077 2,077 Total Expenditures 37,319,993 16,196,546 40% 40,977,669 41,212,093 (234,424) Revenues less Expenditures 2,192,980 16,819,820 (902,914) (1,079,338) (176,424) Beginning Balance 11,225,692 13,418,672 121% 11,113,000 13,418,672 2,305,672 Ending Balance $13,418,672 $ 30,238,493 $10,210,086 $12,339,334 $ 2,129,248 a) Historically, 91 % of the current year taxes are received by the and of November. b) $25,000 contribution to suicide/substance abuse hotline. Open Civil Tech position in Civil/Special Units division reclassified as HR Analyst in Sheriff Services division c) Unfilled FTE. Overtime is expected to exceed budget. d) Open Records Admin Supervisor position will be converted to a Sergeant position. e) Projection includes $8,000 reimbursement for Solar Eclipse expenditures. f) Grant of $50,000 for purchase of $67,500 boat. g) Projection increased due to an unbudgeted rifle purchase. h) Projection includes unfilled FTE, increase in overtime, increased expenditures related to new K-9, and cost savings on web licensing, Anticipated overtime makes up 56% of adjusted projection expenditures. i) Projection includes unfilled FTE, increase in overtime, increase in medical expenses for one inmate, and increase in miscellaneous M&S expenditures. Anticipated overtime makes up 79% of adjusted projection expenditures. Page 3 HEALTH SERVICES Schedule of Financial Operating Data FY 2018 Variance Revenues Year to Date July 1, 2017 FY 2017 through November 30, 2017 (42% of the year) % of Actual Actual Budget, FY 2018 Variance Revenues State Grants $ 13,186,170 $ 4,974,099 32% a)f) $ 15,473,337 $ 16,605,615 $ 1,132,278 OHP Capitation 9,950,347 3,431,900 31% b) 11,044,000 8,834,900 (2,209,100) Administrative Fee 1,143,411 538,500 42% 1,293,910 1,293,910 - Environmental Health Fees 909,870 112,393 12% 964,397 965,081 684 State - OMAP 938,760 449,472 43% 1,037,735 1,052,550 14,815 Federal Grants 574,848 102,455 13% 789,575 639,585 (149,990) Patient Fees 335,616 206,399 57% 364,370 521,545 157,175 Local Grants 1,846,627 324,059 47% c) 696,496 974,810 278,314 Local Government payments 510,428 - N/A - - - Title 19 602,998 467,313 155% d) 302,170 1,204,000 901,830 State Shared -Family Planning 166,903 45,186 23% 200,000 200,000 - State Miscellaneous 206,999 101,242 14% f) 744,753 769,087 24,334 Liquor Revenue 156,399 17,870 12% 151,000 151,000 - Divorce Filing Fees 157,603 131,745 84% 157,603 131,745 (25,858) Interfund Contract -Gen Fund 127,000 - 0% 127,000 127,000 - Vital Records 260,545 75,485 38% 198,000 181,600 (16,400) Interest on Investments 99,844 41,599 29% 145,000 105,000 (40,000) Other 386,400 226,732 55% 413,083 424,526 11,443 Total Revenues 31,560,767 11,246,451 33% 34,102,429 34,181,954 79,525 Expenditures Personnel Services 24,133,045 11,212,635 39% e) 28,611,936 28,172,242 439,694 Materials and Services 10,989,018 3,887,319 29% 13,189,523 13,270,270 (80,747) Capital Outlay 135,653 33,109 3% 1,020,000 1,170,000 (150,000) Transfers Out 445,740 122,580 25% 490,320 490,320 - Total Expenditures 35,703,456 15,255,643 35% 43,311,779 43,102,832 208,947 Revenues less Expenditures (4,142,689) (4,009,192) (9,209,350) (8,920,878) 288,472 Transfers In -General Fund 4,684,193 1,910,080 42% 4,584,193 4,584,193 - Change in Fund Balance 541,504 (2,099,112) (4,625,157) (4,336,685) 288,472 Beginning Fund Balance 7,688,209 8,229,714 98% 8,434,473 8,229,714 (204,759) Ending Fund Balance $ 8,229,714 $ 6,130,602 $ 3,809,316 $ 3,893,029 $ 83,713 a) Collections from CCBHC exceeded the amount accrued at June 30, 2017. FY 17 revenue will be reported as FY 18 revenues. b) Projection based on FY 2017 collections and anticipated withholdings for panel providers. c) COHC grants - Diabetes Prevention and Prenatal Care. Not included in FY 2018 original budget. Supplemental budget pending. d) Title 19 revenue during the CCBHC demonstration project is projected to be reimbursed at a higher rate than previous years. e) Projections based on YTD unfilled positions and forecasted unfilled positions during the remainder of the year. f) Reclassification from State Grants to State Miscellaneous for presentation purposes. State Grant projection increased due to higher than anticipated receipts from CCBHC wraparound payment. This offsets the reclassification to State Miscellaneous. NOTE: Year-end projections for Health Service Programs are updated monthly. Projection amounts will fluctuate from month to month. Page 4 COMMUNITY DEVELOPMENT Schedule of Financial Operating Data FY 2018 Bud et Projected Variance Revenues Year to Date July 1, 2017 through FY 2017 November 30, 2017 (42% of the year) Admin -Operations $ 110,639 % of Actual Actual Budget FY 2018 Bud et Projected Variance Revenues Admin -Operations $ 110,639 $ 47,680 47% $ 102,042 $ 109,742 $ 7,700 Admin -GIS 230 - 0% 150 150 - Admin -Code Enforcement 451,837 245,888 43% 565,544 571,544 6,000 Building Safety 2,903,075 1,253,374 43% 2,948,636 2,957,591 8,955 Electrical 745,810 326,897 44% 743,927 728,220 (15,707) Env Health -On Site Prog 678,469 311,425 46% 680,460 685,384 4,924 Planning -Current 1,530,513 721,902 45% 1,614,855 1,614,855 - Planning -Long Range 577,420 259,653 38% 682,919 682,919 - Total Revenues 6,997,994 3,166,820 43% 7,338,533 7,350,405 11,872 Expenditures (by division) Admin -Operations 1,750,586 804,658 39% a) 2,051,239 1,969,477 81,762 Admin -GIS 136,312 66,375 47% a) 141,439 137,038 4,401 Admin -Code Enforcement 357,992 163,550 36% a) 448,238 438,028 10,210 Building Safety 1,249,842 497,399 35% a) 1,433,852 1,370,931 62,921 Electrical 320,568 128,211 34% a) 374,974 363,474 11,500 Env Health -On Site Pgm 399,914 185,849 41% 456,234 456,234 - Planning -Current 1,179,944 541,899 39% a) 1,375,541 1,336,491 39,050 Planning -Long Range 390,649 126,665 27% a) 472,040 434,377 37,663 Total Expenditures 5,785,808 2,514,606 37% 6,753,557 6,506,050 247,507 Revenues less Expenditures 1,212,186 652,215 584,976 844,355 259,379 Transfers In/Out Out: CDD Reserve Funds 1,375,000 205,903 25% (823,610) (823,610) - Net Transfers In/Out 1,375,000 205,903 (823,610) (823,610) - Change in Fund Balance (162,814) 446,312 (238,634) 20,745 259,379 Beginning Fund Balance 2,330,492 2,167,678 132% 1,640,386 2,167,678 527,292 Ending Fund Balance $2,167,678 1 $ 2,613,990 $ 1,401,752 $ 2,188,423 $786,671 a) Projection decreased due to year to date unfilled positions. Page 5 ROAD Schedule of Financial Operating Data FY 2018 Variance Revenues Year to Date July 1, 2017 through FY 2017 November 30, 2017 (42% of the year) $ 12,930,670 $ 5,678,683 % of Actual Actual Budget FY 2018 Variance Revenues Motor Vehicle Revenue $ 12,930,670 $ 5,678,683 43% b) $13,260,000 $ 14,300,000 $ 1,040,000 Federal - PILT Payment 1,323,365 1,574,248 97% a) 1,623,000 1,574,248 (48,752) Other Inter -fund Services 1,065,930 198,129 13% 1,501,525 1,501,525 - Federal Reimbursements - - 0% 955,549 955,549 - Cities-Bend/Red/Sis/La Pine 488,114 56,041 8% 710,000 710,000 - State Miscellaneous 593,969 57,269 9% 651,213 651,213 - Forest Receipts 381,533 - 0% 400,000 400,000 - Sale of Equip & Material 273,353 192,949 51% 381,900 381,900 - Mineral Lease Royalties 183,312 7,774 4% 175,000 175,000 - Assessment Payments (P&I) 87,079 17,170 20% 88,000 88,000 - Interest on Investments 112,444 45,756 51% 90,000 90,000 - Miscellaneous 50,391 23,605 57% 41,092 41,092 - Total Revenues 17,490,159 7,851,623 40% 19,877,279 20,868,527 991,248 Expenditures Personnel Services 5,877,065 2,467,709 40% 6,161,974 6,133,974 28,000 Materials and Services 8,903,281 3,174,992 23% c) 13,715,873 10,715,873 3,000,000 Capital Outlay 68,721 3,160 1% 228,000 228,000 - Total Expenditures 14,849,067 5,645,861 28% 20,105,847 17,077,847 3,028,000 Revenues less Expenditures 2,641,092 2,205,762 (228,568) 3,790,680 4,019,248 Payment from Solid Waste 362,453 - - - - - Transfers Out 9,067,643 3,000,000 50% (6,000,000) (6,000,000) - Total Transfers (8,705,190) (3,000,000) 50% (6,000,000) (6,000,000) - Change in Fund Balance (6,064,098) (794,238) (6,228,568) (2,209,320) 4,019,248 Beginning Fund Balance 14,840,939 8,776,841 101% 8,684,589 8,776,841 92,252 Ending Fund Balance $ 8,776,841 $ 7,982,603 $ 2,456,021 $ 6,567,521 $ 4,111,500 a) PILT payment received in July. b) Includes 4 -months of HB 2017 Revenue c) Projection decreased due to intention to hold $3.0 million in overlay reserve for future expenditures. Page 6 ADULT PAROLE & PROBATION Schedule of Financial Operating Data Year to Date July 1, FY 2017 2017 through November 30, 2017 (42% of the year) % of Actual Actual Budget FY 2018 Variance Revenues DOC Grant in Aid SB 1145 $ 3,650,168 $2,166,664 55% a) $3,940,708 $ 4,333,290 $ 392,582 CJC Justice Reinvestment 845,836 - 0% b) 699,506 757,735 58,229 DOC Measure 57 240,315 - 0% c) 234,315 233,900 (415) Electronic Monitoring Fee 133,292 53,990 32% 170,000 155,000 (15,000) Probation Superv. Fees 209,708 76,962 37% 210,000 210,000 - DOC -Family Sentence Alt 110,797 114,683 N/A a) - 115,683 115,683 Interfund - Sheriff 50,000 20,833 42% 50,000 50,000 - Gen Fund/Crime Prevention 50,000 12,500 25% 50,000 50,000 - DOJ/Arrest Grant 46,736 11,684 106% 11,000 11,684 684 Alternate Incarceration 29,985 6,908 34% i) 20,035 6,908 (13,127) State Subsidy 16,367 8,168 52% a) 15,610 16,337 727 Interest on Investments 28,990 10,937 109% f) 10,000 20,000 10,000 Probation Work Crew Fees 5,958 668 11% d) 6,000 2,000 (4,000) State Miscellaneous - - 0% 4,300 4,300 - Miscellaneous 1,256 - 0% 500 500 - Total Revenues 5,419,408 2,483,998 46% 5,421,974 5,967,337 545,363 Expenditures Personnel Services 4,097,354 1,768,583 40% e) 4,455,860 4,350,000 105,860 Materials and Services 1,509,684 513,924 28% h) 1,843,865 1,600,000 243,865 - Transfer to Veh Maint 22,000 11,000 25% 44,000 44,000 - Capital Outlay 15,986 - N/A g) - 24,902 (24,902) Total Expenditures 5,645,023 2,293,507 36% 6,343,725 6,018,902 324,823 Revenues less Expenditures (225,615) 190,491 (921,751) (51,565) 870,186 Transfers In -General Fund 451,189 187,995 42% 451,189 451,189 - Change in Fund Balance 225,574 378,486 (470,562) 399,624 870,186 Beginning Fund Balance 1,465,370 1,690,943 123% 1,375,000 1,690,943 315,943 Ending Fund Balance $ 1,690,943 $ 2,069,430 $ 904,438 $ 2,090,567 $1,186,129 a) Projection increased due to additional revenue being granted by legislature after budget adoption. b) Annual payment expected to be received in January 2018. Projection increased due to additional revenue granted by legislature after budget adoption. c) Annual payment expected January 2018. Projection decreased due to less than anticipated revenue granted by legislature after budget adoption. d) Projection decreased due to less than anticipated revenue. e) Projection decreased due to several staff vacancies through November 2017. f) Projection based on trending. g) Projection increased due to unanticipated capital outlay requirement. h) Projection decreased due to less than anticipated expenditure Page 7 i) Project decreased due to less than anticipated revenue after budget adoption. SOLID WASTE Schedule of Financial Operating Data Operating Revenues Year to Date July 1,757,500 1, 2017 through FY 2017 November 30, 2017 Private Disposal Fees (42% of the year) 1,166,644 Commercial Disp. Fees % of Actual Actual Budget Operating Revenues 3,075,000 3,075,000 (572,588) 1,810,265 $1,237,677 1 1,757,500 Franchise Disposal Fees $ 5,459,396 $ 2,615,759 Private Disposal Fees 2,095,262 1,166,644 Commercial Disp. Fees 1,729,096 856,709 Franchise 3% Fees 254,304 21,364 Yard Debris 171,470 104,495 Recyclables 13,467 8,310 Equip & Material 18,590 - Special Waste 28,812 7,576 Interest 31,959 8,521 Leases 10,801 5,400 Miscellaneous 59,241 28,102 4,822,880 Total Operating Revenues 9,872,398 Operating Expenditures 10,801 - 80% Personnel Services 2,049,320 1 895,741 Materials and Services 4,334,705 1,630,749 Capital Outlay 127,449 31,107 Debt Service 858,512 310,982 2,868,579 Total Operating Expenditures 7,369,985 1 1,954,301 Operating Rev less Exp 2,502,412 Transfers Out SW Capital & Equipment Reserve Total Transfers Out Change in Fund Balance Beginning Fund Balance Ending Fund Balance 3,075,000 3,075,000 (572,588) 1,810,265 $1,237,677 1 1,757,500 1,757,500 196,801 1,237,677 $1,434,478 a) Disposal fees will slow down during winter months b) Franchise fee payment is due on May 15, 2018. c) Debt Service payments are made in November and May. FY 2018 Bud et Projected I Variance 41% 2,278,466 $ 6,391,644 $ 6,391,644 $ - 58% a) 2,012,522 2,012,522 - 49% a) 1,742,832 1,742,832 - 9% b) 240,000 240,000 - 62% a) 168,000 168,000 - 69% a) 12,000 12,000 - N/A - - - 30% a) 25,000 25,000 - 43% 20,000 20,000 - 50% 10,801 10,801 - 80% 35,000 35,000 - 45% 10,657,799 10,657,799 - 39% 2,278,466 2,258,466 20,000 33% 4,909,217 4,909,217 - 25% 125,000 125,000 - 36% c) 861,102 861,102 - 35% 8,173,785 8,153,785 20,000 2,484,014 2,504,014 20,000 68% 2,580,000 2,580,000 - 68% 2,580,000 2,580,000 - (95,986) (75,986) 20,000 201% 615,872 1,237,677 621,805 $ 519,886 $ 1,161,691 $ 641,805 Page 8 RISK MANAGEMENT Schedule of Financial Operating Data Revenues 42% Inter -fund Charges: Year to Date July 1, 2017 FY 2017 through November 30, Property Damage 389,101 2017 (42% of the year) Vehicle 197,155 - % of Actual Actual Budget Revenues 42% Inter -fund Charges: $1,051,283 General Liability $ 931,319 $ Property Damage 389,101 391,542 Vehicle 197,155 - Workers' Compensation 1,228,053 42% Unemployment 280,921 195,085 Claims Reimb-Gen Liab/Property 33,863 517,383 Process Fee-Events/Parades 1,980 1,241,718 Miscellaneous 30 - Skid Car Training 43,853 42% Interest on Investments 58,644 354,609 TOTAL REVENUES 3,164,919 58,592 195% Direct Insurance Costs: GENERAL LIABILITY 32,000 Settlement / Benefit 711,705 38% Defense 27,039 1,800 Professional Service 6,250 1,500 Insurance 339,723 30 Loss Prevention 1,347 1,470 Miscellaneous 171 44% Repair / Replacement 33,673 32,000 - Total General Liability 1,119,908 40% PROPERTY DAMAGE Property Damage Charges - - Settlement / Benefit - 43% Insurance 5,101 3,405,001 Loss Prevention 12,000 9,040 Repair / Replacement 122,074 Total Property Damage 139,175 5,335 VEHICLE Professional Service 781 Insurance - 6,622 Loss Prevention 25,397 Miscellaneous 6,985 Repair / Replacement 102,994 Total Vehicle 136,157 WORKERS' COMPENSATION Settlement / Benefit 539,792 Professional Service 6,250 Insurance 159,212 29% Loss Prevention 49,683 700,000 Miscellaneous 52,937 98 Total Workers' Compensation 807,875 UNEMPLOYMENT - Settlement/Benefits 56,497 173,873 Total Direct Insurance Costs 2,259,612 Insurance Administration: Personnel Services 327,505 582 Materials & Srvc, Capital Out. & Tranfs. 146,503 Total Expenditures 2,733,620 174,553 Change in Fund Balance 431,299 Beginning Fund Balance 4,928,271 215,000 $ Ending Fund Balance $ 5,359,570 FY 2018 Budget Projected Variance 438,035 42% $1,051,283 $1,051,283 $ - 163,143 42% 391,542 391,542 - 81,285 42% 195,085 195,085 - 517,383 42% 1,241,718 1,241,718 - 148,137 42% 354,609 354,609 - 58,592 195% 30,000 62,000 32,000 680 38% 1,800 1,800 - 1,500 5000% 30 1,500 1,470 14,182 44% 32,000 32,000 - 29,358 40% 73,464 73,464 - 1,452,294 43% 3,371,531 3,405,001 33,470 9,040 5,335 6,622 207,262 582 228,840 29% 800,000 700,000 (100,000) 98 173,873 582 174,553 81% 215,000 215,000 - 5,101 635 36,472 42,207 42% 100,000 100,000 - 294,389 18,077 111,730 30,361 12,316 466,874 52% 900,000 1,050,000 150,000 30,960 21% 150,000 100,000 (50,000) 943,434 44% 2,165,000 2,165,000 - 140,694 41% 345,627 345,627 - 57,928 26% 226,699 226,699 - 1,142,056 42% 2,737,326 2,737,326 - 310,238 634,205 667,675 33,470 5,359,570 109% 4,897,636 5,359,570 461,934 5,669,808 $ 5,531,841 6,027,245 495,404 Page 9 DC 9-1-1 (Funds 705 and 707) Schedule of Financial Operating Data Revenues Year to Date July 1, Property Taxes - Current 2017 through FY 2017 November 30, 2017 Property Taxes - Jefferson County (42% of the year) State Reimbursement 869,734 % of Actual Actual Budget Revenues 92% Property Taxes - Current $ 7,496,065 Property Taxes - Prior 109,702 Property Taxes - Jefferson County 32,518 State Reimbursement 869,734 State Grant 276,510 Telephone User Tax 865,111 Data Network Reimb. 86,263 User Fee 58,981 Police RMS User Fees 326,030 Contract Payments 130,756 Miscellaneous 3,562 Interest 105,258 Total Revenues 10,360,491 Expenditures Personnel Services 5,867,156 Materials and Services 3,254,372 Capital Outlay 4,941,447 Total Expenditures 14,062,974 Transfer In - Fund 710 400,000 FY 2018 Variance 7,271,865 92% a) $7,926,725 $ 7,926,725 $ - 75,620 89% 85,000 85,000 - 29,232 89% a) 33,000 33,000 - 15,000 14% b) 110,000 - (110,000) - N/A - - - 223,749 25% c) 880,000 880,000 - - 0% 55,000 55,000 - 2,156 2% 90,000 90,000 - 31,202 12% 250,119 250,119 - - 0% 193,000 193,000 - 3,519 13% 27,000 27,000 - 30,123 47% 64,000 64,000 - 7,682,466 79% 9,713,844 9,603,844 (110,000) 2,870,567 41% 7,070,919 7,004,919 66,000 1,768,120 58% b) 3,047,724 2,937,724 110,000 1,202,645 54% d) 2,210,000 2,210,000 - 5,841,333 12,328,643 12,152,643 176,000 - 0% 806,137 806,137 - Revenues less Expenditures (3,3021483) 1,841,133 (1,808,662) (1,742,662) 66,000 Beginning Fund Balance 10,563,485 7,261,001 110% 6,600,000 7,261,001 661,001 Ending Fund Balance $ 7,261,001 $ 9,102,135 $4,791,338 $ 5,518,339 $727,001 a) Historically, 91 % of the current year taxes are received by the end of November. b) Four workstations will not be purchased as the State will not be providing the resources. c) Q2 payment expected by the end of January. d) Several capital project expenditures made during Q1. Page 10 Revenues: Internal Premium Charges Part -Time Employee Premium Employee Monthly Co -Pay COIC Retiree / COBRA Co -Pay Prescription Rebates Claims Reimbursements & Mise Interest Total Revenues Expenditures: Materials & Services Admin & Wellness Claims Paid -Medical Claims Paid -Prescription Claims Paid-Dental/Vision Stop Loss Insurance Premium State Assessments Administration Fee (TPA) Preferred Provider Fee Other - Administration Other- Wellness Admin & Wellness Deschutes On-site Clinic Contracted Services Medical Supplies Other Total DOC Deschutes On-site Pharmacy Contracted Services Prescriptions Other Total Pharmacy Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance Health Benefits Fund Statement of Financial Operating Data FY 2018 July 1, 2017 through November 30, 2017 FY 2017 FY 2018 Actual Actual % °f Budget Projection $ Variance $ 16,955,229 $ 7,306,585 43% a) 16,865,000 17,535,804 670,804 2,585 1,172 N/A a) - 2,814 2,814 923,805 376,965 41% a) 925,000 943,965 18,965 2,165,312 771,253 35% a) 2,224,000 1,851,007 (372,993) 1,202,895 513,338 42% a) 1,211,803 1,232,011 20,208 52,995 17,784 N/A - 17,784 17,784 82,361 - 0% 150,000 150,000 - 168,140 82,259 9,069,356 39% 42% a) 210,000 21,585,803 197,421 21,930,805 (12,579) 345,002 21,553,322 13,016,901 5,239,844 37% b) 14,088,936 13,196,234 892,703 977,260 533,163 50% b) 1,069,006 1,262,496 (193,490) 2,141,054 763,274 33% b) 2,342,057 2,252,147 89,910 366,633 179,532 42% 425,000 425,000 - 6,269 - 0% 6,600 6,600 461,375 196,792 42% 465,000 465,000 - 91,904 (3,294) -5% 65,000 65,000 - 221,307 59,877 28% 214,431 214,431 - 174,028 63,099 7,032,287 35% 37% 178,900 18,854,931 178,900 18,065,808 - 789,123 17,456,731 953,281 72,219 45,308 1,070,808 382,900 1,728,845 34,083 2,145,828 20,673,366 879,955 14,502,622 345,331 35% 975,000 975,000 34,565 41% 85,000 85,000 12,324 27% 45,943 45,943 392,220 35% 1,105,943 1,105,943 96,367 595,084 37,720 729,172 8,153,678 915,677 15,382,578 % of Exp covered by Revenues 1 104.3%] 1 111.2% a) Year to Date Annualized b) 12 -Month roiling average with 8% increase over prior year 31% 312,000 312,000 - 35% a) 1,700,000 1,785,252 (85,252) 58% 65,418 65,418 - 35% 2,077,418 2,162,670 (85,252)_ 37% 22,038,292 21,334,421 703,871 (452,489) 596,384 1,048,873 103% 15,000,000 15,382,578 382,578 $ 14,547,511 $15,978,961 $1,431,450 r 97.9% W 102.8% Page 11 irf 12/1/2017 Operating Revenues Events Revenues Storage Camping at F & E Horse Stall Rental Food & Beverage Activities, net Annual County Fair (net) Interfund Contract Miscellaneous Total Operating Revenues Operating Expenditures, net of TRT: General F & E Activities Personnel Services TRT Grant Materials and Services TRT Grant Capital Outlay Total Operating Exp, net of TRT Other: Park Acq/Dev (Fund 130) Rights & Signage Interest Total Other Results of Operations Transfers In / Out Transfer In -General Fund Transfer In -Room Tax - (Fund 160) Trans in(Out)-Fair & Expo Reserve Total Transfers In Non -Operating Rev & Exp Debt Service Total Non -Operating Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance FAIR AND EXPO CENTER Schedule of Financial Operating Data Year to Date July 1, 2017 through November 30, 2017 (42% of the year) $ 538,512 $ 134,432 25% Year to Date July 1, 2017 44% FY 2017 through November 30, 2017 21,148 (167,827) (42% of the year) 21% 34,953 1 % of 24% Actual Actual Budget -19% 'a) $ 538,512 $ 134,432 25% 66,879 44% 33,116 51% 21,148 (167,827) 4,150 21% 34,953 1 9,993 24% 119,129 (22,702) -19% 'a) 440,000 430,626 245,452 57% b 30,000 30,000 12,500 42% c) 14,198 1 2,119 419,060 28% 33% 11264,818 940,667 403,750 38% d) (188,255) (87,684) 44% 812,908 408,978 33% (167,827) (105,729) 17% - - 619,315 0% 43% 1,397,493 30,000 7,500 25% 116,130 42% 10,600 9% 1,789 42% 458 46% 147,919 100% 18,558 12% 15.244 41,000 (181.697) 250,000 FY 2018 83,333 42% 25,744 Variance 10,727 42% 55,000 65,000 105,452` 100% 220,744 20,000 (11,392) 41,000 102,536 56,660 56% 102,536 430,626 56,660 56% 133,452 1 30,000 (249,748) 7,500 47,283 180,735 80% 180.735 $ (69,013) 30,000 a) See "Food & Beverage Activities Schedule" b) Revenues and Expenses for the annual County Fair are recorded in a separate fund and the available net income is transferred to the Fair & Expo Center Fund c) Reimbursement from RV Park for personnel expenditures recorded in F&E d) Personnel projected to be less than budgeted due to open positions through November 30, 2017 Page 12 FY 2018 Bud et Projected Variance 544,000 $ 544,000 $ 65,000 65,000 20,000 20,000 41,000 41,000 120,695 120,695 430,626 285,452 (145,174) 30,000 30,000 - 7,500 7,500 1,258,821 1,113,647 (145,174) 1,050,695 1,020,695 30,000 (200,000) (200,000) - 1,223,563 1,223,563 (635,070) (635,070) 15,000 15,000 1,454,188 1,424,188 30,000 30,000 30,000 - 118,000 107,700 (10,300) 1,000 1,000 149,000 138,700 (10,300) (46,367) (171,841) (125,474) 200,000 200,000 25,744 25,744 105,452 105,452 120,292 120,292 - 101,824 101,824 101,824 101,824 - (27,899) (153,373) (125,474) 225,000 180,735 44,265 $ 197,101 $ 27,362 =!===U=69,7=39 a) See "Food & Beverage Activities Schedule" b) Revenues and Expenses for the annual County Fair are recorded in a separate fund and the available net income is transferred to the Fair & Expo Center Fund c) Reimbursement from RV Park for personnel expenditures recorded in F&E d) Personnel projected to be less than budgeted due to open positions through November 30, 2017 Page 12 Deschutes County Fair and Expo Center Food and Beverage Activity Revenues $ 473,489 $ 4,698 $ 33,117 $ 19,711 $ 15,086 $ 32,621 $ 105,233 $ 412,000 Direct Costs Beginning Inventory 24,921 25,933 25,779 35,014 33,385 29,246 25,933 - Purchases 121,019 848 19,053 2,817 2,823 8,159 33,699 102,000 Ending Inventory (25,933) 25,779 35,014 (33,385) (29,246) _( 9,918) (29,918) - Cost of Food & Beverage 120,007 1,002 9,818 4,446 6,961 7,487 29,714 102,000 Cost of F&B Percentage 25.35% 21.32% 29.65% 22.56% 46.14% 22.95% 28.24% 24.76% Event Expenses 23,802 1,186 4,124 1,940 2,559 2,875 12,684 6,000 Labor 105,325 3,666 7,990 3,847 7,336 4,826 27,665 57,800 Total Direct Costs 249,135 5,854 21,933 10,234 16,856 15,187 70,063 165,800 Gross Profit 224,355 1,156 11,184 9,477 1,770) 17,434 35,170 246,200 Gross Profit Percentage 47.4% -24.6% 33.8% 48.1% -11.7% 53.4% 33.4% 59.8% Other Revenues Catering/3rd Party 10,461 383 96 899 - 1,377 10,000 Concessions/3rd Party 20,036 - - - 2,083 2,083 14,000 Total Other Revenues 30,497 383 96 899 - 2,083 3,460 24,000 Expenses Personnel 125,509 10,762 10,793 11,250 11,250 11,257 55,310 135,755 Other Materials & Services 10,214 454 474 703 491 3,899 6,021 13,750 Total Expenses 135,723 11,216 11,267 11,953 11,740 15,156 61,331 149,505 Income (Loss) F&B Activity $ 119,129 $ 11,98 $ 14 $ (1,577) $ (13,510} $ 4,361 22,7 2 $ 120,695 Page 13 JUSTICE COURT Schedule of Financial Operating Data FY 2018 Bud et Projected Variance Revenues Year to Date July 1, 2017 through FY 2017 November 30, 2017 (42% of the year) $ 545,628 193,979 % Of Actual I Actual I Budget FY 2018 Bud et Projected Variance Revenues Court Fines & Fees $ 545,628 193,979 37% a) $ 530,000 $ 581,937 $ 51,937 Interest on Investments 1,348 324 22% 1,500 1,500 - Total Revenues 546,976 194,303 37% 531,500 583,437 51,937 Expenditures Personnel Services 467,419 1 195,813 40% 486,471 486,471 - Materials and Services 153,817 63,322 44% 142,392 142,392 - Total Expenditures 621,236 259,135 41% 628,863 628,863 - Revenues less Expenditures (74,260) (64,832) (97,363) (45,426) 51,937 Transfers In -General Fund 25,000 29,167 42% 70,000 70,000 - Change in Fund Balance (49,260) (35,665) (27,363) 24,574 51,937 Beginning Fund Balance 161,702 1 112,442 132% 85,000 112,442 27,442 Ending Fund Balance $112,442 $ 76,777 $ 57,637 $137,016 $ 79,379 a) Year to date annualized. Page 14 Deschutes County Room Taxes (Funds 160 and 170) Budget and Actual - FY 2018 YTD November 2017 Fund 160 - 7% of TRT ■ Fund 170 - 1% of TRT ■ Combined - 8% TRT Page 15 % of Budget Actual Budget Actual Budget Actual Budget REVENUES Room Taxes $ 5,880,000 $ 4,015,980 $ 840,000 $ 573,714 $ 6,720,000 $ 4,589,694 68.3% Interest 10,000 8,180 7,000 3,273 17,000 11,453 67.4% Total Revenues 5,890,000 4,024,160 847,000 576,987 6,737,000 4,601,147 68.3% EXPENDITURES Administrative Auditing Services 10,937 - 1,563 - 12,500 - Temporary Help 7,064 847 - 113 7,064 960 Interfund Contract 48,238 20,099 9,048 3,350 57,286 23,449 ISF 32,287 13,453 15,305 6,377 47,592 19,830 Public Notices 2,669 613 381 88 3,050 700 Printing 1,881 - 269 - 2,150 - Office Supplies 897 128 1,025 Postage 2,647 - 378 - 3,025 - Total Administrative 106,620 35,012 27,072 9,927 133,692 44,939 Current Distributions Sheriff's Office 31151,787 1,313,245 - - 3,151,787 1,313,245 Sunriver Service Dist 200,000 - 200,000 - COVA - 6% 982,256 621,779 982,256 621,779 COVA-1% 820,164 521,275 - 820,164 521,275 Grants Third Party Grants - - - 8,000 - 8,000 Inter -fund Grants ME Center - 839,242 193,413 839,242 193,413 Annual County Fair - 70,000 91,421 70,000 91,421 RV Park - - 70,000 26,027 70,000 26,027 Inter -fund Transfers ME Center 25,744 10,727 - 25,744 10,727 ME Reserve Fund - - 245,978 61,495 245,978 61,495 Total Distributions 5,179,951 2,467,025 1,225,220 380,355 6,405,171 2,847,381 Total Expenditures 5,286,571 2,502,037 1,252,292 390,282 6,538,863 2,892,320 Change in Balance 603,429 1,522,123 (405,292) 186,704 198,137 1,708,827 Beginning Balance 407,000 449,923 405,292 467,133 812,292 917,056 Ending Balance $ 1,010,429 $ 1,972,045 $ - $ 653,838 $ 1,010,429 $ 2,625,883 Page 15 Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/ AGENDA REQUEST & STAFF REPORT For Board of Commissioners Work Session of December 18, 2017 DATE: December 13, 2017 FROM: Kathleen Hinman, Human Resources, 541-385-3215 TITLE OF AGENDA ITEM: Health and Wellness - Contracts Update ATTENDANCE: Kathleen Hinman, HR Director and Trygve Bolken, HR Analyst SUMMARY: Staff update to Board on proposed Health and Wellness Plan changes, status for DOC service partner contract renewals, and finalization of the Third Party Administrator agreement. Deschutes County Employee Benefit Plan for 2018 Plan Year Proposed Updates effective 1/1/2018 Third Party Administrator Durable Medical Equipment Vision Benefit Move from EBMS to PacificSource effective 1/1/2018. Administrative Services Agreement for Board consideration at Business Meeting on 12/27/17. The durable medical equipment benefit also covers hearing aids for members 18 years of age or younger. Coverage is limited to a maximum benefit of one hearing aid per ear, every 48 months. For members age 19 and older, the benefit is limited to one hearing aid per ear, up to a Other Medical Remove the language that states "up to ACA does not allow annual limits on Services and Supplies 400 miles maximum" emergency services. —Air Ambulance Standard and High Deductible Plans Schedule of Benefits — Pregnancy: In G�JTES CC` , —A 0 C RFP for TPA services completed and PacificSource awarded contract. Quality of care: This is a highly requested benefit that is now covered under most benchmarked plans. maximum dollar amount of $2,500 every 24 months. Progressive lenses not clearly defined Define Progressive lenses in the vision under the Plan and were covered benefits section and define coverage at under the tri -focal benefit level. $220 (the same and Lenticular lenses) Change is consistent with benchmarked plans. If maternity care billed as "global maternity fee:" 100% of covered charges are paid at 88%. Network Coverage of certain medical services and surgical procedures requires a benefit determination before the services are performed. This process is called 'preauthorization'. PacificSource will Preauthorization utilize the criteria adopted by the Plan Sponsor and, where necessary, will coordinate review with the Plan Sponsor, to render a determination based on the Plan. Change to TPA claim processing as this will streamline Global Maternity billing and allow claims to be auto adjudicated with new TPA. Does not change access to covered plan benefits. Protects members from engaging in services that are not covered in the plan. Moves claim review for certain items to the before billing stage. t Becoming Eligible — The annual open enrollment period is ew open enro ment anguage o Status Change — every November. All changes will become correspond with the new calendar plan Open Enrollment effective January 11t. year. Becoming Eligible — Family Members Becoming Eligible — Family Members Becoming Eligible — Enrolling After the Initial Enrollment "Domestic Partner" is changes to "Same This is language clarification only. This Gender Domestic Partner" does not change coverage under the Plan. Language was clarified to surrounding dual This is language clarification only. This coverage under the same employer (i.e. does not change coverage under the Deschutes County and COIC). Plan. "Under FMLA, if you return to work after a qualifying FMLA medical leave, you will not have to satisfy another probationary waiting period under this Plan. Your health This language was added to the plan to coverage will continue for you and your ",; articulate current practice for covering Period — Returning dependents while you are out on leave. ! employees when they are out on After Leaves Any missed coinsurance contributions will protected leaves of absence. be collected through payroll deduction once you return." Removed "On the last day of the calendar Correct Plan language already states month the covered retired employee that retirees and their dependents are Continuation When reaches age 65;" and "the last day of the eligible for Medicare coverage on the You Retire calendar month the dependent spouse or first day of the calendar month they domestic partner turns age 65;" reach age 65. Retiree benefits would Professional Service — Outpatient Rehabilitation Services Preferred Provider Networks Online and Mobile Tools "Provided by a licensed physical therapist, occupational therapist, speech language pathologist, physician or other practitioner licensed to provide physical, occupational, or speech therapy within the scope of the provider's license." terminate on the 15Y of the month. This language was crafted to articulate current practice for covering outpatient rehabilitation services including vision and speech therapy. It clarifies that practitioners can only prescribe the services if they are within the scope of the provider's license. PacificSource Value-added Extras Included in their Suite of Service PacificSource uses participating provider networks to ensure maximum access to providers for all members. Provider networks also include dental, vision and alternative care providers. InTouch_ You can access coverage and benefit information through InTouch, our secure web portal at PacificSource.com. It allows you to easily and conveniently manage your insurance coverage and health, 24/7. myPacificSource Mobile App Health Management Programs Our free mobile app gives you secure, on -the -go access to all your coverage information, no matter where you are. Deschutes County Landing Page PacificSource has created a landing page specifically for Deschutes County employees at www.pacificsource.com/deschutescounty Condition Support Our Condition Support Program offers education and support to members with asthma, diabetes, heart failure, chronic obstructive pulmonary disease, coronary artery disease, or juvenile diabetes. This program is available to eligible PacificSource members with medical coverage. AccordantCare With AccordantCare, we offer rare disease management and specialty pharmacy programs that provide individual support and coordination for our members with certain rare diseases, or those requiring injectable medications or biotech drugs. 24 -Hour Nurseline is staffed around the clock, 7 days a week—so you'll never be 24 -Hour NurseLine without a registered nurse to talk to. As part of your Deschutes County coverage, administered by PacificSource, you can enjoy special offers for one of the following programs: Weight Management I Weight Watchers®: Be reimbursed for some program costs when you participate in Programs person or in the online program. Jenny Craig®: Join the Jenny All Access program for 50% off the enrollment fee, plus 5% off all Jenny Craig food. Hospital Based Get reimbursed up to $150 per plan year for health and wellness classes offered by Education Classes hospitals, including first aid, CPR, financial planning, and more. If you're expecting, our free Prenatal Program offers you support, useful Prenatal Program information, and resources during this very important time for you and your baby. With the Active&Fit® gym membership program, you can access any gym within Gym Membership your plan's network for a one-time initiation fee of $25 plus a monthly fee of $25 Program per member. Wellness Coordinator PacificSource wellness consultant will partner with County Wellness Coordinator and Support determine where they can add value to our existing wellness program. Flexible Spending Account Plan for 2018 Plan Year Health FSA Plan Health FSA Plan Adopt FSA policy that allows for a $500 carry over on Health FSA accounts into the new plan year. Increase the Health FSA annual plan limit to match Federal limit; from $2550 to $2650 per plan year. Employees have greater control over their unused Health FSA benefit. Able to "bank" larger FSA dollars for planned out of pocket expenses. Change from Grace Period to Roll Over Plan type. Increase the plan limit to match the IRS maximum allowable contribution Deschutes Onsite Clinic (DOC) 2018 Plan Year Medcor (clinic) - Amend existing contract to renew services for 2018 plan year. For Board Personal Services consideration at Business Meeting on Contract 12/27/17. Premise (pharmacy) - Amend existing contract to renew services Personal Services for 2018 plan year. For Board Contract consideration at Business Meeting on 12/27/17. Current contract expires 2017. RFP for clinic services will be issued in early 2018. Current contract expires 2017. RFP for pharmacy services will be issued in early 2018. Commissioners December 15, 2017 Maggie Finnerty Oregon Entrepreneurs Network 309 SW 6th Ave., Suite 212 Portland, OR. 97204 t54"1 J JtJti-tin/U • I -ax t04"I J dtJO-ddue- www.deschutes.org board@deschutes.org Tammy Baney Anthony DeBone Phil Henderson Dear Maggie: We are writing in support of Economic Development for Central Oregon (EDCO) and the proposal being submitted to Oregon Community Foundation (OCF) for the Venture Catalyst Initiative. Deschutes County has financially supported the Venture Catalyst (VC) position in Central Oregon for the past four years, and sees the program as an integral part of the overall economic development strategy of our region. In the past three years the VC has assisted in helping Portfolio Companies raise $39 million in investment, and new employment of close to 250 Central Oregonians. The region's vibrant startup ecosystem is a key element behind Central Oregon's nationally recognized economy (in the past year, #1 GDP growth, #2 job growth and #6 population growth for all U.S. metros). We understand the need for collaboration in this initiative, and the value in leveraging statewide resources to help bridge the gaps that each region may have. Central Oregon has seen an explosion in startup activity over the past 10 years, and the gaps that we have actively tried to service are around both access to capital and talent. Deschutes County is committed to ongoing support of the Venture Catalyst program financially, and has again provided $30,000 in funding for the July 1St 2017, to June 30th 2018 fiscal year. We look forward to working with the Oregon Community Foundation to grow and provide increased access throughout the region to the Venture Catalyst program. Sincerely, The Deschutes County Board of Commissioners Tammy Baney, Chair Anthony DeBone, Vice Chair Philip G. Henderson, Commissioner Enhancing the Lives of Citizens by Delivering Quality Services in a Cost -Effective Manner