Loading...
2017-384-Minutes for Meeting May 17,2017 Recorded 7/14/2017Recorded in Deschutes County CJ2017-384 Nancy Blankenship, County Clerk Commissioners' Journal 07/14/2017 4:20:19 PM • 1111111111111111111111111 11111 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 WEDNESDAY, MAY 17, 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; and Sharon Ross, Board Executive Secretary. One representative of the media was in attendance. CALL TO ORDER: Chair Baney opened the meeting at 1:34 p.m. ACTION ITEMS 1. Finance/Tax Update: Wayne Lowry, Finance Director presented the financial report for the month of April. The total investment portfolio as of April 30, 2017 was reviewed. Monthly financial reports were reviewed by statements of financial operating data for the general fund, Community Justice - Juvenile, Sheriffs Office, Health Services, Community Development, Road, Community Justice -Adult, Solid Waste, insurance fund, 9-1-1, health benefits trust, Fair & Expo, Justice Court, and transient room tax. One note of interest was the Fair & Expo Center food and beverage activity was at $82,118 for the month of March. Mr. Lowry reviewed reserve funds that are designed to meet department future needs. Cash balances as of May 15, 2017 were presented. Minutes of Board of Commissioners' Work Session May 17, 2017 Page 1 of 5 2. DOCUMENT NO. 2017- 294, DECISION OF THE BOARD OF COUNTY COMMISSIONERS FOR DESCHUTES COUNTY RELATIVE TO FILE NO. 247 -16- 000600 -AD Jacob Ripper, Associate Planner, presented the amended version of the decision relating to Document No. 2017-294 as recommended at the Business Meeting this morning. The Board reviewed the amended statement and signed the document in approval. 3. SOLID WASTE MANAGEMENT PLANNING/RFP REVIEW: Timm Schimke, Director of Solid Waste noted Knott Landfill is expected to reach capacity in 2029. The timeframe for a new facility is typically seven years. Mr. Schimke has developed a request for proposals (RFP) for solid waste management planning services. If there is a decision is made to transport, then the cost of transport will require an investment and review of processes required for collection, recycling, and transfer. Mr. Schimke suggested forming a stakeholders group including members of the franchise group to choose a consultant. Recommendations would then come to the Board along with input from the community. The Board expressed support of moving forward. Request for Proposals are due May 31, 2017. Commissioner Baney suggested soliciting involvement from the general public for applications for the stakeholder's group. The Board would like the planning to be enviromnentally conscious and cost effective. Relocating the transfer station within the County may prove to have more struggles than transporting. Mr. Schimke recalled over twenty years ago the County went through a similar planning effort and recommendations were made by the consultant for a tri -county effort between Crook, Jefferson, and northern Klamath along with Deschutes County. Commissioner Baney suggested having a conversation with the neighboring counties to see if there is interest. 4. STATE OF THE COUNTY — WHAT'S BREWING/BEND CHAMBER: Whitney Hale, Public Information Officer explained the Bend Chamber of Commerce is requesting topics that will be covered by the Board for the State of the County address on July 11t11. The event will be held at Deschutes Brewery downtown. Ms. Hale reviewed a few potential topics. Discussion held on topics of interest and was narrowed down to budget update, capital projects, and affordable housing. Minutes of Board of Commissioners' Work Session May 17, 2017 Page 2 of 5 5. EMPLOYEE RECOGNITION BREAKFAST DISCUSSION: Whitney Hale, Public Information Officer stated the Employee Recognition Breakfast is scheduled on the first Saturday of the County Fair and is open for employees and families. Ms. Hale's proposal is to not make any changes this year. The Commissioners serve breakfast and give out prizes. The Board expressed support for moving forward. Ms. Hale will send out the invitation to employees. 6. MARIJUANA LEGISLATIVE UPDATE: Commissioner Henderson gave an update on his recent meetings in Salem with legislators and of his presentation including maps, charts, and rules & regulations. Commissioner Henderson noted his commitment to meet with marijuana growers to review their concerns. Commissioner Baney noted there was one grower that reached out to her. Commissioner DeBone noted the only communication he had received was a grower in his community asking if there was any chance to not have public awareness of his application. Commissioner Baney commented on new application process and work plan that is open to be revisited. Commissioner Baney commented on the concerns of the Farm Bureau of the regulations of dark skies. County Administrator Anderson noted the CDD Work Plan coming before the Board which will include timing, the matrix, and drafted list of options. Mr. Lelack suggested forming a focus group or reconvening the marijuana advisory committee for the one-year review of the process. Mr. Lelack noted the grower community has different views of the regulations. Commissioner Bancy likes Commissioner Henderson's idea of a communication back to the legislators and informing thein of numbers of approvals, appeals, denials and of the plan for a one year review of the regulations. Judith Ure, Management Analyst also expressed agreement with a communication piece to respond to our legislators and including our lobbyist, PAC West. Commissioner Baney suggested a letter drafted from the Board as a whole along with a letter from Commissioner Henderson's want to follow-up with the legislators he spoke with. Commissioner Henderson noted for future sessions he suggested the Deschutes County presence earlier in the session to create relationships. 7. AFFORDABLE HOUSING DISCUSSION: Commissioner Henderson presented on affordable housing and his opinions of the fees involved causing the high costs of housing. Commissioner Henderson has been involved in the community discussions and asked to bring this for discussion on what Deschutes County can do in the role of affordable housing to address lower cost housing. Commissioner DeBone talked on cost of infrastructure and lot sizes. Existing parcels are hard to turn into cost effective sites. Statewide land use and cost of infrastructure seems to be an issue. Minutes of Board of Commissioners' Work Session May 17, 2017 Page 3 of 5 Peter Gutowsky commented on a meeting with investors for mobile home parks. There is an interest in a mobile home park outside of the urban growth boundary. Mr. Gutowsky noted under the current code an expansion of a current mobile home park can be done. Commissioner Baney commented on a process in 2008 to end homelessness with the work supported by Oregon Housing. Commissioner Baney noted the timeliness of this conversation. Discussions are being facilitated by Nathan Bodie and Bruce Abernathy in finding ways of caring for the homeless in Bend. There is a new push for supporting mobile home parks in Salem. Commissioner Baney also noted the condition of some of the current mobile homes. Commissioner Henderson commented on a study in Tillamook County on rental homes and land use restrictions. Discussion held on evaluating lands within the county for affordable housing developments. Mr. Lelack suggested reviewing what Tillamook County did and what our abilities would be. Commissioner Henderson commented on his interest in finding information on the vacancy of buildable lots. Commissioner DeBone also pointed out the importance of creating jobs that would not force commuting. Commissioner Henderson spoke on frustration of land donations and the lack of commitment of development. County Administrator Anderson noted the CDD Work Plan and the potential long range planner taking on responsibility of overseeing these types of projects. OTHER ITEMS • The Board went into Executive Session under ORS 192.660 (2) (d) Labor Negotiations at 4:29 p.m. The Board came out of Executive Session at 4:50 p.m. HENDERSON: Made motion to direct Steve Reinke, 911 Operations Director to proceed as discussed. DEBONE: Second VOTE: HENDERSON: Yes BANEY: Absent DEBONE: Vice Chair votes yes. Motion carried. • County Administrator Anderson brought forward the annual Association of Oregon Counties bill that was just received and asked if the item should be brought forward for consideration when all three Commissioners are present. Discussion held on affiliations. The current invoice is approximately $50,000. Commissioner DeBone noted his approval but will review levels of costs with the AOC board. Minutes of Board of Commissioners' Work Session May 17, 2017 Page 4 of 5 HENDERSON: Move approval of paying the membership as presented DEBONE: Second VOTE: HENDERSON: BANEY: DEBONE: Yes Absent Vice Chair votes yes. Motion carried • County Administrator Anderson stated we received an invoice from Eastern Oregon Counties Association related to extra debt service. Commissioner DeBone will bring this item forward at the NACO meeting in Sunriver and ask for clarification. • Commissioner DeBone explained the Central Oregon Intergovernmental Council Board is made up of elected officials and explained the representation on the Board. The bylaws were created in the 1990s and are not consistent with articles of incorporation. Commissioner DeBone noted the need for the memberships and appointments to be restructured according to bylaws. He noted the process of changing the bylaws or articles would require ratification by each entity. ADJOURN: Being no further discussion, the meeting adjourned at 5:10 p.m. DATED this 2—Day of County Board of Commissioners. ATTES Recording Secretar Minutes of Board of Commissioners' Work Session 2017 for the Deschutes � / -� te Tammy ane C r y, 1Z� a-7110/ Anthony DeBone, Vice C air Philip G derso, Commissioner May 17, 2017 Page 5 of 5 TE G o,+, Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 — Fax (541) 385-3202 — https://www.deschutes.org/ WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 PM, WEDNESDAY, MAY 17, 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. Finance/Tax Update - Wayne Lowry, Finance Director/Treasurer 2. Solid Waste Management Planning/RFP Review - Timm Schimke, Director of Solid Waste 3. State of the County - What's Brewing / Bend Chamber - Whitney Hale, Public Information Officer 4. Employee Recognition Breakfast Discussion - Whitney Hale, Public Information Officer 5. Marijuana Legislative Update 6. Affordable Housing Discussion OTHER ITEMS 7. EXECUTIVE SESSION: under ORS 192.660 (2) (e) Real Property Negotiations 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. Board of Commissioners Work Session Agenda Wednesday, May 17, 2017 Page 1 of 2 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. ADJOURN ® 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.ora/meetinacalendar (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 Wednesday, May 17, 2017 Page 2 of 2 Investment Income / //k 0 k kcok ~ (fir‘- ;Fr, k 0)EA k & Li: 9 .co 0. Investments By County Function $ 164,292,861 15- a) c $ 164,292,861 Total Investments _ _ c2M C -_ @fCI 2 0 �2 r k L CD a. ) � § 49 49.U Prior Month Investment Income - Net e 2@4@22/ $1.) r` G$c -tt C'4 0 Vi 0 00000'-_ 0 0 0 0 0= CD 9RRR9sf o=oowoN / N Lo Lo N \2 ®ƒ/CO - 0 (0 3z/)\O F- ro.— �(Oe#c \0E cij -8 20I=:5 Total Investments CD ƒ Prior Year Comparison @@@@a@@ 0 0 o 0 0 N.( 10 C4 C1 r ,A .o- kC0 \o E 2 w \ _ \ m\§ f a 2 j E . _ c o ® o , EN\/�\/\\ ki\ 0 @ a_ a 0 £ P. & _ o) I— EL t2\ O D qƒ/// 0 i- o D Under 5 Years Total Portfolio: By Investment Types CL }3\ 0o Deschutes County Investments Portfolio Management Portfolio Details - Investments April 30, 2017 CUSIP 91412GUU7 961214CH4 WASH FED CD 31771CS97 48125LRD6 29270CYZ2 84247PHS3 3137EADV8 298191N37 005158VE7 675371AT5 3130A62S5 94974BGB0 313383.1138 31771 J MR8 31771KAD90 427542KW4 494751DHO 3696045BC6 SYS10520 680591CU4 88059FAZ4 961214BZ5 740189AK1 949748FG0 94988J5A1 90331 HMQ3 92976W8H8 31771EAL5 Security University of California _ Westpac Washington Federal CD FICO Std JPMorgan Chase - Corporate N Bonneville Power Administratio • Southern CA Public Power Autho Federal Horne Loan Mtg Corp 'Eugene Power Ada County SD Oceanside California Pension Federal Home Loan Bank Wells Fargo Corporate Note Federal Horne Loan Bank :FICO Strip 'FICO Strip Hermiston OR 'King County Washington FPD .General Electric - Corporate N Lewis & Clark Bank Tennessee Valley Authority Tennessee Valley Authority Westpac Precision Castparts Corp Wells Fargo Corporate Note 'Wells Fargo Corporate Note U S Bank - Corp Note 'Wachovia Corp FICO Strip Purchase MaturityDays To Ratings Coupon Par Market Broker Date Date 'Maturity S&P Moody's Rate ,YTM 365 Value Value PJ 12/19/2016 5/15/2017 14 AA Aa2 1.222' 0.993' 1,000,000 1,000,000 CASTLE 4/7/2015 5/19/2017 18 AA- Aa2 1.200 1.061 ~ 2,000,000 2,000,020 5/20/2015 5/22/2017 21 0.900 0.913 200,000 200,000 CASTLE 12/9/2014 6/6/2017 36' 'Aaa 1.019 1.065 1,028,000 1,026,797 (CASTLE 6/10/2016 6/14/2017 44jA+ 'Aa3 1.521 1.313 1,000,000 1,000,370: CASTLE 4/24/2014 7/1/2017 61AA- Aal 1.197 1.171 670,000 670,268 'CASTLE 6/17/2014 7/1/2017 61 ,,AA- 1.145 1.180 1,000,000 999,360', MBS 5/29/2015 7/14/2017 74 Aaa 0.750 0.787 1,000,000 999,810. R W B 12/13/2016 8/1/2017' 92 AA- Aa2 0.835' 1.102' 150,000 149,895': PJ 6/1/2015 8/15/2017, 106 AA+ Aa1 3000 0.930'+ 1,000,000 1,006,060 'PJ 5/20/2016 8/15/2017 106 AA 1.806 1.000 500,000 500,775., CASTLE 7/24/2015 8/28/2017 119 ;,Aaa 0.750 0.858, 1,000,000 999,460 'DADAV 3/8/2016 9/8/2017 130 A ,A2 1.400 1.450 461,000 460,866 'VINISP 12/26/2013 9/27/2017 149 AA+ Aaa 1.000 1.250 1,000,000 1,000,750 'CASTLE 10/22/2015 10/6/2017 158 0.751 0.781 2,000,000 1,989,800 IDA DAV 12/10/2014 11/30/2017 213 1.205 1.267 2,000,000 1,986,740 DA DAV 9/21/2016 12/1/2017 214 AA- 2.000 0.901 590,000 592,513, .PJ 12/15/2015 12/1/2017, 214 AA+ 1.220 1.218 230,000 229,736 CASTLE 9/6/2016 12/6/2017' 219 AA+ Al 5.250 1.050 1,000,000 1,023,230: 6/8/2016' 12/8/2017; 221 1.000 1.000 240,000 240,0001 CASTLE 12/1/2016' 12/15/2017 ' 228 AA+ _ ' 6.250 1.011 1,000,000 1,031,830! CASTLE 11/21/2014 12/15/2017, 228 AA+ 1.205 1 268 1,059,000 1,050,539' ICASTLE ' 3/5/2015, 1/12/2018' 256 AA- '!,Aa2 1.600 1.490. 2,000,000 2,000,680 !CASTLE 12/13/2016' 1/15/2018' 259AA- ,A2 1.250 1.318 1,250,000 1,248,900 ', _CASTLE 12/9/2016 1/16/2018' 260, H 'A2 1.500 1.601 2,000,000 1,999,160 'CASTLE 1/29/2016 1/22/2018 266' ,Aa2 1.650 1.580 1,000,000 1,001,600 :CASTLE 11/18/2016 1/26/2018 2701AA- Al 1.350 1.316 2,850,000 2,847,692 CASTLE ' 2/26/2016 2/1/2018 276;,4 _ A2 5.750, 1.690 1,000,000 1,029,960 :CASTLE 2/24/2015 2/8/2018 283. .252 1.318 1,260,000 1,247,274 , 31771EAL5 FICO Strip CASTLE ; 2/25/2015 2/8/2018 283', 1.257, 1.323 740,000, 732,526 3134G8M71 Federal Home Loan Mtg Corp 'CASTLE ' 2/26/2016 2/26/2018 301'M+ 1.050 1.050" 3,000,000 2,997,960 06050TLY6 IBankofAmerica- Corporate CASTLE 5/14/2015 3/26/2018 329'1.0 Al 1.650, 1.570 2,000,000 2,003,380 06050TLY6 !Bank of America - Corporate CASTLE 5/21/2015 3/26/2018 329 A Al 1.650 1.540 1,000,000 1,001,690 06050TLY6 Bank of America - Corporate CASTLE 5/27/2016 3/26/2018 329,A Al 1.650 1.620 1,000,000 1,001,690 68607VG66 'Oregon State Lottery DA DAV 6/12/2015 4/1/2018 335, AAA ,HA2 5.000, 1.120 610,000 632,753 68607VA96 (Oregon State Lottery DA DAV 6/13/2016 4/1/2018 335:AAA 'AA2 1.353 0.970 200,000 200,154 842434CD2 Southem CA Gas Co CASTLE 4/10/2017 4/15/2018 349 A+ Aa2 5,450 - 1.473 1,000,000 1.035,420 912828XA3 U.S. Treasury PJ 11/30/2016 5/15/2018 379 AA+ Aaa 1.000 1.000 2,000,000 1,996,880 913366HS2 , University ofCalifornia CASTLE 3/21/2017 5/15/2018 379 AA- Aa3 0.936 1.351 3,000,000 2,986,770 3135GOXD0 Federal National Mtg Assn CASTLE 1/4/2017 5/21/2018 385 AA+ Aaa 1.000 1 250 500,000 499,105' 3130A8783 ',Federal Home Loan Bank VINISP 12/6/2016 5/30/2018 394 AA+ Aaa 1.000 1.141 1,500,000 1,496,220 3132XOLR0 Federal Agriculture Mtg Corp ' PJ 12/8/2016 6/8/2018, 403. 1.100 1.100 2,000,000 1,999,560 98385XAP1 'XTOEnergy Inc CASTLE 8/4/2015 6/15/2018': 410'AAA Aaa 5.500 1.500' 1,000,000 1,044,700 904121NC0 ,Umatilla School District PJ 5/7/2015 6/15/2018 410.AA+ 1.430' 1.430 750,000 748,200 166764AE0 :Chevron Corp CASTLE 4/15/2016 6/24/2018 419 AA- ,Aa2 1.718' 1.191': 2,000,000 2,006,700' 166764AE0 Chevron Corp CASTLE 10/11/2016 6/24/2018, 419 f AA- Aa2 1.718, 1.259' 1,000,000 1,003,350 939307HF4 Hillsboro SD Pension Bonds PJ 3/30/2015 6/30/2018' 425,Aa3 1.732' 1.650, 985,000 987,236 938429M46 Washington County SD Municipal PJ 9/6/2016 6/30/2018 425' .Aa3 1.585, 0.999' 250,000 250,578 3135GOL43 Federal National Mtg Assn 'CASTLE 12/13/2016 7/13/2018. 438 AA+ ,,Aaa ' 0.850 1.221 1,000,000 995,950 88059EMT8,Tennessee Valley Authority DA DAV 2/22/2016 7/15/2018 440, , 1.021 1.065 500,000 491,820 3133EGNU5 _FederalFarm Credit Bank CASTLE 8/1/2016 7/27/2018 452 AA-,Aaa 0.960 0.960 1,000,000 996,710 3134G9Q67 'Federal Home Loan Mtg Corp CASTLE 7/27/2016 7/27/2018' 452,AA+ Aaa 1.050 1.050 3,000,000 2,993,430 934876AG0 Port of Newport OR Lease :DA DAV ' 3/27/2017 8/1/2018 457,AA 4.500, 1.450 610,000 632,186 65371AU2 'Oceanside California Pension CASTLE 1/27/2017 8/15/2018 471 AA 2.298 1.551 1,850,000 1,864,319 544351KM0 Los Angeles Calif Go Ref Bds PJ 12/21/2016 9/1/2018 488 M2 1.210 1.209', 1,000,000 997,730 3134GAKFO Federal Home Loan Mtg Corp CASTLE 10/18/2016' 9/12/2018, 499AA+ Aaa 1.110 1.110 3,000,000 2,995,440 3134G8UN7 'Federal Home Loan Mtg Corp CASTLE 3/30/2016 9/28/2018 515 AA+ Aaa ' 1.200: 1.200, 2,000,000 1,993,200' 3134G9YA9 'Federal Home Loan Mtg Corp CASTLE 6/28/2016 9/28/2018 515 AA+ Aaa 1.010 1.000 2,520,000 2,512,062. 3134GAND3 Federal Home Loan Mtg Corp CASTLE 9/28/2016 9/28/2018 515 AA+ 'Aaa , 1.050' 1.050 4,000,000 3,990,120 3133EFJP3 'Federal Farm Credit Bank CASTLE 11/4/2016 10/15/2018 5321AA+ Aaa 1.100 1.100' 5,000,000 4,983,550 89236TAY1 'Toyota Mtr Cred - Corp N CASTLE 1/5/2016' 10/24/2018, 541 AA- Aa3 2.000 1.770 784,000 789,065 89236TAY1 'Toyota Mtr Cred - Corp N CASTLE 3/15/2017 10/24/2018 541 IAA- Aa3 2.000, 1.700 3,216,000 3,236,775 912828WD8 ;U.S. Treasury CASTLE 12/1/2015 10/31/2018 548 1.250 1.223 1,000,000 1,000,590 912828T83 U.S. Treasury CASTLE 12/14/2016 10/31/2018 548' 0.750 1.155 3,000,000 2,979,270 91159HHF0 ;US Bancorp ICASTLE 12/1/2016 11/15/2018 563 AlI' 1529 1.326 2,000,000 2,009,680. 3134GAVU51 .Federal Home Loan Mtg Corp :CASTLE 12/28/2016. 11/16/2018 564 AA+ ' 0.625' 0.672 4,000,000 3,999,680 42754210X2 'Hermiston OR i DA DAV ' 9/21/2016 12/1/2018 579'AA- 3.000. 1.001 605,000 620,046 31771EAN1 ,FICO Strip ,CASTLE' 11/3/2016 12/27/2018 605' 0.984 1.025' 1,000,000 975,530' 912828A75 ,U.S.Treasury CASTLE I 6/8/2015 12/31/20 8 609 ,AAA ,Aaa 1.500 1.324 1,000,000. 1,004,340 68607VS71 Oregon State Lottery CASTLE 4/5/2017 4/1/2019 700 1.602 1.581 1,000,000 1,000,620 459058FC2 ,International Bonds for Recons 'CASTLE 12/15/2016 4/26/20 725 AAA ,Aaa , 1.250, 1.500, 2,000,000 1,985,320 250351 FJ7 Deschutes County Ore Sch Dist PJ 8/16/2016' 6/15/2019 775 A1 , 1.360 1.360', 245,000, 242,555, 3137EAB1 ,Federal Home Loan Mtg Corp CASTLE . 7/20/2016 7/19/2019' 809 'A AA+ aa 0.875' 0.957' 1,000,000 988,530, 3135GON33 ' Federal National Mtg Assn CASTLE 8/18/2016 8/2/2019! 823,AA+ ',Aaa 0.875: 1.000 ' , 1,000,000' 987,870, 3134GA5Q3 !Federal Home Loan Mtg Corp CASTLE 2/28/2017 8/28/2019' 849 .0+ !Aaa , 1.550' 1.558: 3,000,000 2,999,790 06406HCW7 Bank of New York MelIon Corp 'CASTLE 11/3/2016, 9/11/2019, 863:A 'Al ; 2.300' 1.532] 1,675,000 1,690,929. 48125LRJ3 JPMorgan Chase - Corporate N CASTLE 4/10/2017 9/23/2019 875 A+ Aa3 1.746 1.462 3,000.000 3,018,360 313586RC5 Federal National Mtg Assn CASTLE 12/4/2015: 10/9/2019 891 AA- j 1.891; 2.031 ; 1,400,000, 1,339,758 313586RC5 '!Federal National Mtg Assn CASTLE 3/17/2016 10/9/20191 891 AA- 1.665. 1.774, 600,00 574,182 313586RC5 IFederal National Mtg Assn CASTLE 8/8/2016 10/9/2019' 891 ,M- : 1.2521 1.318 400,000 382,788, 3135GOR39 Federal National CASTLE 11/10/2016 10/24/2019' 9061AA+ :Aaa . 1.000 1.173 2,000,000 1,978,360 912828F62 'U.S. Treasury CASTLE 10/11/2016 10/31/2019 913AAA Aaa 1.500' 1.008, 2,000,000! 2,007,040' 912828U73 U.S. Treasury 'CASTLE 3/3/2017' 12/15/2019 958; 1.375, 1.527 3,000,000 2,999,190' 594918AY0 Microsoft Corp r CASTLE 8/8/2016 2/12/2020. 1017IAAA ';Aaa 1.850 1.298: 1,000,000 1,002,680 686053CK3 Oregon School Boards Assoc ,CASTLE 3/15/2017 6/30/2020 1156; AA- ,Aa2 ' 2.063! 2.149, 1,000,000', 938,960 686053DH9 Oregon School Boards Assoc DA DAV 11/2/2015 6/30/2020: 1156iAA Aa2 5.373; 2.050' 875,000: 965,038 686053DH9 Oregon School Boards Assoc CASTLE 6/24/2016, 6/30/2020 1156 AA 'Aa2 5.373 1.570, 500,000 551,450' 94974BGM6 Wells Fargo Corporate Note ,PJ 1/19/2017 7/22/2020 1178:A IA2 2.600; 2.350: 1,000,000 1,012,410 940093R25 Washington Univ Higher Ed ',PJ 1/19/2017! 10/1/2020 1249; _ , 5.930 1.9701 400,000' 452,700 492244DV7 Kern Community College CASTLE 11/15/2016, 11/1/2020 1280 AA- 2.893' 1.8001 500,000' 515,910, Local Govt Investment Pool 1.300' 1.300'! 33,988,456 33,988,456: :Bank of the Cascades _ _ _ _ _ _ _ , 1.300; 1.300'1 4,601,405, 4,601,405 Book Call Value Date 1,000,088 - - 2,000,137 - - 200,000 - - 1,026,952 - - _ 1,000,000 - - 670,029 - - 999,942 - - 999,926 - - 149,901 - - 1,005,903 - - 501,153 - - 999,652 460,920 - - 999,012 - - _ 1,993,406 - - 1,985,737 - - 593,754 - - 230,000 - - 1,024,844, - 240,000. - - 1,032,342, - - 1,050,916 - - 2,001,493 - - 1,249,401 - 1,998,587 - - -- 1,000,498 - - 2,850,673 12/26/2017 1,029,828 - - 1,247,594 - - 732,685 - - 3,000,000, 5/26/2017 2,001,411 - - 1,000,966 - - 1,000,261 - - 631,295 - - 200,694 - - 1,037,576 - - 2,000,000 - - 2,987,208 - - 500,000 5/21/2017 1,499,483 5/30/2017 2,000,000 - 1,043,770' - - 750,000 - - 2,011,893 5/24/2018 1,005,058 - - 985,907 - - 251,682 - 1,000,000 7/13/2017 493,759 - - 1,000,000 7/27/2017 3,000,000 7/27/2017 632,936 - - 1,867,537 - - 1,000,000 - - 3,000,000' 6/12/2017 2,000,000' 6/28/2017 2,520,000 6/28/2017 4,000,000 - - 5,000,000 - - 786,588 - - 3,230,003 - - _ 1,000,402 - - 2,982,026, - - 2,006,294, 10/15/2018 3,999,615, 5/16/2017 623,897' - - 983,463 - - 1,002,850, - - 1,000,405 - - 2,000,000 - - 245,000 - - 998,210' - - 997,226 - 2,999,610 8/28/2017 1,704,397, 8/11/2019 3.021,720 8/23/2019 1,334,478' - - 575,275 - - _ 387,605' - - 1,991,607 - - - -- 2,024,181 - - -- 2,988,299 - 1,014,967 1/12/2020 934,676. - - 962,291 - - 558,080 - - 1,007,694: - - 451,933' - _ 518,379 - 33,988,456 - - 4,601,405: - 164,292,861 ' 164 444.750 164,617.842' Memorandum Date: To: From: RE: May 9, 2017 Board of County Commissioners Tom Anderson, County Administrator V Wayne Lowry, Finance Director Monthly Financial Reports Attached please find April 2017 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriff's (255, 701, 702), Health Services (274), Community Development (295), Road (325), Community Justice - Adult (355), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), Fair & Expo Center (618), and Justice Court (123), Transient Room Tax (160, 170). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads Revenues Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor County Clerk BOPTA District Attorney Tax Office Veterans Property Management Total Revenues Expenditures Assessor County Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental Total Expenditures Transfers Out Total Exp & Transfers Change in Fund Balance Beginning Fund Balance Ending Fund Balance GENERAL FUND Statement of Financial Operating Data Year to Date July 1, 2016 through April 30, FY 2016 2017 (83% of the year) FY 2017 % Actual Actual Budget Budget Projected 24,561,964 24,847,340 96% a) 25,749,791 25,749,791 516,994 353,779 71% 500,000 400,000 2,412,614 2,073,143 85% b) 2,450,622 2,429,700 875,075 850,179 100% c) 849,349 850,179 1,721,618 1,506,760 83% 1,810,837 1,910,837 12,413 12,546 102% c) 12,350 12,546 194,675 118,722 63% 188,400 188,400 212,618 189,203 92% c) 204,730 204,730 98,161 72,985 75% 97,400 97,400 75,000 12,500 13% 94,500 94,500 30,681,131 30,037,157 94% 31,957,979 31,938,083 3,857,613 1,447,322 61,911 5,776,482 54,173 751,319 333,745 288,776 1,161,328 13, 732, 670 15,520,033 29,252,703 1,428,428 9,788,945 $ 11,217,374 3,313,920 1,363,761 55,547 5,077,965 119,920 666,602 334,604 207,699 917,570 12,057,587 14,729,837 26,787,424 3,249,733 11,217,374 $ 14,467,107 Beginning Net Working Capital per FY 2018 Proposed Budget a) Current year taxes received beginning in October b) Includes annual PILT Grant - $500,000. Close out of Fund 129 not likely to occur in FY 2017 - $53,122 c) Includes A & T Grant. Received quarterly and all quarters have been received d) Personnel expenditures projected to be less than budgeted e) Expenditures for printing, office supplies and remodel projected to be less than budgeted f) Formerly combined with District Attorney. The projection is year to date annualized 79% d) 4,187,123 67% e) 2,043,672 81% 68,890 79% d) 6,401,372 127% f) 94,155 82% 812,314 79% 422,673 75% d) 275,729 72% 1,273,153 77% 15,579,081 82% 17,865,428 80% 33,444,509 (1,486,530) 108% 10,411,770 $ 8,925,240 4,087,123 1,743,672 68,890 6,281,372 143,904 812,314 422,673 260,729 1,273,153 15,093,830 17,865,428 32,959,258 (1,021,175) 11,217,374 $ 10,196,199 $ 10,000,000 Variance (100,000) (20,922) 830 100,000 196 (19,896) 100,000 300,000 200,000 (49, 749) 15,000 565,251 565,251 545,355 805,604 $ 1,350,959 Page 1 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 Revenues less Expenditures Transfers In -General Fund Change in Fund Balance Beginning Fund Balance Ending Fund Balance COMM JUSTICE -JUVENILE Statement of Financial Operating Data FY 2016 Actual 413,233 88,030 33,759 59,100 36,090 23,811 20,000 13,147 22,661 8,870 6,347 42,490 767,538 4,947,639 1,172, 705 3,660 6,124,004 (5,356,466) 5,464,591 108,125 1,307,249 $ 1,415,374 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) "/o of Actual I Budget 147,279 38% 61,606 67% 75,344 154% 51,900 94% 27,034 74% 13,707 69% 15,000 75% 14,353 179% 14,571 86% 6,659 5,070 84% 2,164 228% 434,686 62% 95% 4,180,920 955,656 33,000 5,169,576 (4,734,890) 4,553,830 (181,060) 1,415, 374 $ 1,234,314 Beginning Net Working Capital per FY 2018 Proposed Budget a) 386,725 a) 91,379 b) 48,840 c) 55,000 36,658 d) 20,000 e) 20,000 f) 8,000 17,000 f) 7,000 6,000 f) 950 697,552 81% d) 5,186,945 75% d) 1,273,154 75% 44,000 79% 6,504,099 FY 2017 Projected 350,000 94,728 90,000 61,000 36,658 18,000 20,000 17,000 17,000 8,500 6,000 2,500 721,386 Variance (36,725) 3,349 41,160 6,000 (2,000) 9,000 1,500 1,550 23,834 5,050,000 136,945 1,200,000 73,154 44,000 6,294,000 210,099 (5,806,547) (5,572,614) 233,933 83% 5,464,591 5,464,591 (341,956) (108,023) 233,933 118% 1,200,000 1,415,374 215,374 $ 858,044 $ 1,307,351 $ 449,307 $ 1,200,000 I a) Biennial allocation; reimbursements received quarterly. Projections changed due to FY 16 expenditures of the biennial award b) Additional detention space leased (beginning 9/26/16) c) Projection increased due to revenue received YTD from other counties' use of detention d) Decreased expense projection due to YTD Personnel and Materials & Services expenses e) Grant received quarterly f) Increased projection due to revenue received YTD Page 2 REVENUES LED #1 Countywide Property Taxes Current Year (a) Prior Year Interest Total LED #1 Countywide LED #2 Rural Property Taxes Current Year (a) Prior Year Interest Total LED #2 Rural Sheriffs Office Revenues Total Revenues EXPENDITURES Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Other Law Enforcement Services Non -Departmental Total Expenditures Revenues less Expenditures Beginning Balance Ending Balance Sheriffs Office and LEDs Statement of Financial Operating Data FY 2016 I Year to Date July 1, 2016 through April 30, 2017 (83% of the year) Of Actual Budget Actual Budget 20,079,835 20,382,065 97% 21,033,596 372,660 265,229 66% 400,000 75,743 90,471 N/A - 20,528,238 20,737,765 97% 21,433,596 8,904,294 9,130,830 99% 9,258,083 178,807 121,435 66% 185,000 61,532 73,050 N/A 9,144,633 9,325,314 99% 9,443,083 7,899,943 6,909,845 91% 7,634,391 37,572,814 36,972,924 96% 38,511,070 2,946,663 1,956,139 77% 2,552,004 1,133,697 924,219 79% 1,175,801 1,977,223 1,961,371 77% 2,552,419 1,785,375 1,501,585 85% 1,759,576 8,583,641 7,295,417 80% 9,083,787 718,786 590,093 76% 773,412 15,633,055 13,141,464 76% 17,237,586 262,486 220,137 57% 387,878 212,012 215,466 76% 283,141 1,488,556 1,208,554 77% 1,577,367 522,986 457,936 76% 604,033 1,014,820 759,238 89% 854,664 93,312 94,040 83% 112,846 36,372,611 30,325,659 78% 38,954,514 1,200,203 6,647,264 (443,444) 10,025,490 11,225,692 113% 9,894,937 11,225,692 17,872,957 9,451,493 LED #1 5,780,690 LED #2 5,445,002 11,225,692 a) Current year taxes received beginning in October. Beginning Fund Balance per Proposed Budget LED #1 LED #2 10,267,557 7,605,400 17,872,957 4,042,157 5,409,336 9,451,493 FY 2017 Projected Variance 21,033,596 300,000 (100,000) 100,000 100,000 21,433,596 9,258,083 121,435 85,000 9,464,518 7,634,391 38, 532, 505 2,487,260 1,211,246 2,521,663 1,843,344 8,876,562 688,080 16,907,084 353,373 286,079 1,574,757 638,467 958,404 112,846 (63,565) 85,000 21,435 21,435 64,744 (35,445) 30,756 (83, 768) 207,225 85,332 330,502 34,505 (2,938) 2,610 (34,434) (103, 740) 38,459,165 495,349 73,340 11,225,692 11,299,032 5,413,355 5,885,677 11,299,032 516,784 1,330,755 1,847,539 1,371,198 476,341 1,847,539 5,073,000 6,040,000 Nage i Revenues State Grants OHP Capitation Administrative Fee Environmental Health Fees State - OMAP Federal Grants Patient Fees Local Grants Local Government payments Title 19 State Shared -Family Planning State Miscellaneous Liquor Revenue Divorce Filing Fees Interfund Contract -Gen Fund Vital Records Interest on Investments Other Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Total Expenditures Revenues less Expenditures Transfers In -General Fund Transfers In -Other Total Transfers In Change in Fund Balance Beginning Fund Balance Ending Fund Balance HEALTH SERVICES Statement of Financial Operating Data FY 2016 Actual 11,940,592 11, 756, 788 920,156 878,929 1,116, 399 676,462 350,727 605,656 129,514 226,258 211,627 151,973 131,689 194,785 61,273 365,510 29,718,339 22, 769, 593 9,402,751 213,459 445,740 32,831,544 (3,113,205) 4,408,227 227,587 4,635,814 1,522,609 6,165,600 $ 7,688,209 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) % of Actual I Budget Budget 9,720,968 82% 8,220,048 69% 1,014,107 89% 822,808 90% 744,207 79% 239,620 35% 265,169 67% 1,658,515 139% 510,428 N/A 418,213 165% 103,128 52% 112,145 65% 82,906 55% 157,603 120% 82,717 65% 199,475 114% 81,027 147% 372,661 101% 24,805,745 81% 19,972,382 8,397,672 58,427 334,305 28,762,786 (3,957,042) a) b) c) d) d) 77% e) 74% f) N/A g) 75% 77% 3,903,500 83% N/A 3,903,500 83% (53,542) 7,688,209 132% $ 7,634,668 Beginning Net Working Capital per FY 2018 Proposed Budget 11,915,605 11,941,755 1,143,411 915,350 945,650 683,417 397,225 1,193,613 253,461 200,000 172,000 151,000 131,689 127,000 175,000 55,000 367,888 30,769,064 25, 786,129 11,338,623 445,740 37,570,492 FY 2017 Projected 12, 346, 988 11,001,276 1,083,411 918,284 898,598 606,400 351,713 1,697,835 510,428 471,000 180,000 185,860 141,088 157,603 127,000 ' 231,000 92,820 433,597 31,434,901 24,312,918 10,529,946 84,226 445,740 35,372,830 Variance 431,383 (940,479) (60,000) 2,934 (47,052) (77,017) (45, 512) 504,222 510,428 217,539 (20,000) 13,860 (9,912) 25,914 56,000 37,820 65,709 665,837 1,473,211 808,677 (84,226) 2,197, 662 (6,801,428) (3,937,929) 2,863,499 4,684,193 4,684,193 4,684,193 (2,117,235) 5,827,329 $ 3,710,094 4,684,193 746,264 7,688,209 8,434,473 $ 8,434,473 I 2,863,499 1,860,880 $ 4,724,379 a) Additional grants received during FY 17 for crisis services, children's intensive services, and adult intensive services b) Estimates provided by Pacific Source have been revised since budget adoption c) Draws from OHA Reserves are done on an as -needed basis d) Grants of $510,000 & $504,000 for Crisis Stabilization Center not anticipated at time FY 2017 budget was adopted e) Personnel Services savings are anticipated to be 6% of budget for the year f) Savings anticipated for contracted medical services, medical supplies, and program supplies g) Incurred capital purchase of building security system; anticipate two grant -funded vehicle purchases Page 4 Revenues Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Prog Planning -Current Planning -Long Range Total Revenues Expenditures Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Planning -Current Planning -Long Range Transfers Out (D/S Fund) Total Expenditures Revenues less Expenditures COMMUNITY DEVELOPMENT Statement of Financial Operating Data FY 2016 Actual 86,401 877 349,648 2,435,823 572,160 536,646 671,414 1,325,662 686,012 6,664,642 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) of Actual Budget 78,847 97% 180 18% 358,061 82% 2,283,352 88% 587,207 94% 0% a) 509,563 85% 1,220,520 91% 490,226 5,527,955 81% 75% 1,621,971 1,462, 780 134,450 112,563 306,588 295,368 836,425 1,018,493 295,001 259,084 328,534 - 346,978 326,201 998,174 955,929 506,993 328,444 163,940 5,539,054 1 4,758,862 1,125,588 1 769,094 Transfers In/Out In: General Fund - L/R Planning 90,783 Out: CDD Reserve Funds (1,037,652) Net Transfers In/Out (946,869) Change in Fund Balance 178,719 Beginning Fund Balance 2,151,773 Ending Fund Balance $ 2,330,492 84% 78% 69% 67% 78% N/A a) 73% 76% 73% N/A 75% N/A (1,036,200) 75% (1,036,200) 75% (267,106) 2,330,492 148% $ 2,063,386 Beginning Net Working Capital per FY 2018 Proposed Budget Budget 81,551 1,000 436,000 2,600,000 622,500 502,500 598,750 1,343,350 656,500 6,842,151 1,732,376 143,702 427,837 1,522,708 330,955 444,755 1,256,203 452,653 FY 2017 Projected 104,266 180 436,000 2,842,238 683,710 632,250 1,410,150 632,211 6,741,005 1,754,962 143,602 376,860 1,340,218 330,865 413,043 1,187,421 406,322 6,311,189 5,953,293 530,962 787,712 (1,381,600) (1,381,600) (1,381,600) (1,381,600) (850,638) (593,888) 256,750 1,578,206 2,330,492 752,286 $ 727,568 $ 1,736,604 $ 1,009,036 Variance 22,715 (820) 242,238 61,210 (502,500) 33,500 66,800 (24,289) (101,146) (22,586) 100 50,977 182,490 90 31,712 68,782 46,331 357,896 256,750 Is 1,640,386 I a) City of Redmond contract cancelled. Services for City of Sisters are reported in the County's Building Safety and Electrical Divisions Page 5 Revenues Motor Vehicle Revenue Federal - PILT Payment Other Inter -fund Services Cities-Bend/Red/Sis/La Pine State Miscellaneous Forest Receipts Sale of Equip & Material Mineral Lease Royalties Assessment Payments (P&I) Interest on Investments Miscellaneous Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Total Expenditures Revenues Tess Expenditures Payment from Solid Waste Trans In - Transp SDC Transfers Out Total Transfers Change in Fund Balance Beginning Fund Balance Ending Fund Balance ROAD Statement of Financial Operating Data FY 2016 Actual 12,487,163 1,203,216 1,132,400 728,980 603,572 1,067,643 345,190 135,663 109,142 123,836 402,358 18,339,163 5,668,320 8,658,040 1,605,077 15,931,437 2,407,727 326,539 1,000,000 (600,000) 726,539 3,134,266 11,706,673 $ 14,840,939 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) Actual % of Budget 10,811,807 1,323,365 271,093 111,395 593,969 381,533 191,508 191,818 81,863 91,450 35,077 14,084,878 4,819,557 4,680,076 46,244 9,545,877 4,539,001 271,840 (9,067,643) (8,795,803) (4,256,802) 14, 840, 939 $ 10,584,136 Beginning Net Working Capital per FY 2018 Proposed Budget a) Motor Vehicle Revenue trending to $13M b) PILT Grant received in July c) Chip seal to be billed this Spring/Summer d) Chip rock has yet to be purchased 87% a) 106% b) 28% 13% c) 100% 95% 61% 110% 82% 229% 83% 82% 79% 37% d) 17% 50% FY 2017 12,470,647 1,250,000 977,400 847,000 593,969 400,000 316,200 175,000 100,000 40,000 42,070 17,212,286 6,106, 592 12,582,412 273,000 18,962,004 (1,749,718) 75% 362,453 N/A 100% (9,067,643) 101% (8,705,190) (10,454,908) 118% 12,549,601 $ 2,094,693 13,000,000 1,323,365 977,400 847,000 593,969 381,533 316,200 191,818 100,000 110,000 42,070 17,883,355 Variance 529,353 73,365 (18,467) 16,818 70,000 671,069 5,681,592 425,000 9,022,197 3,560,215 273,000 14,976,789 3,985,215 2,906,566 4,656,284 362,453 (9,067,643) (8,705,190) (5,798,624) 4,656,284 14,840,939 2,291,338 $ 9,042,315 $ 6,947,622 M $ 8,684,589 I Page 6 Revenues DOC Grant in Aid SB 1145 CJC Justice Reinvestment DOC Measure 57 Electronic Monitoring Fee Probation Superv. Fees DOC -Family Sentence Alt Interfund - Sheriff Gen Fund/Crime Prevention DOJ/Arrest Grant Alternate Incarceration State Subsidy Interest on Investments Probation Work Crew Fees State Miscellaneous Miscellaneous Total Revenues ADULT PAROLE & PROBATION Statement of Financial Operating Data FY 2016 Actual 3,650,200 845,836 234,316 175,399 216,170 110,797 50,000 50,000 46,736 19,492 16,317 15,022 9,531 11,623 842 5,452,282 Expenditures Personnel Services 3,770,605 Materials and Services 1,489,673 Transfer to Veh Maint 41,472 Capital Outlay Total Expenditures 5,301,750 Revenues Tess Expenditures 150,532 Transfers In -General Fund Change in Fund Balance Beginning Fund Balance Ending Fund Balance 451,189 601,721 863,649 $ 1,465,370 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) FY 2017 % of Actual Budget Budget Projected 3,650,168 100% a) 3,650,168 3,650,168 845,836 100% b) 845,836 845,836 240,315 103% c) 234,316 240,315 109,435 55% d) 200,000 150,000 178,195 85% 210,000 210,000 110,797 100% b) 110,796 110,796 41,670 83% 50,000 50,000 37,500 75% e) 50,000 50,000 23,368 50% e) 46,736 46,736 21,779 109% f) 20,035 22,000 16,367 105% f) 15,610 17,000 24,089 344% g) 7,000 28,000 4,689 78% 6,000 6,000 0% 4,300 4,300 1,238 248% g) 500 1,238 5,305,446 97% 5,451,297 5,432,389 3,411,640 77% h) 4,407,793 4,175,000 1,208,846 70% h) 1,721,927 1,575,000 16,500 75% 22,000 22,000 5,760 58% g) 10,000 13,000 4,642,746 75% 6,161,720 5,785,000 662,700 (710,423) 375,990 1,038,690 1,465,370 $ 2,504,060 Beginning Net Working Capital per FY 2018 Proposed Budget a) Quarterly payments based on biennial allocation b) Annual payment based on biennial allocation c) Received a small grant in addition to biennial allocation d) Decreased projection due to less fee revenue than budgeted e) Grant received quarterly f) Reimbursed based on actual offender expenses. Increased projection due to YTD revenue received g) Increased projection due to YTD revenue received or expenses incurred h) Decreased projection due to YTD Personnel and Materials & Services expenses 83% 451,189 (259,234) 126% 1,162,000 $ 902,766 $ I$ Variance 5,999 (50,000) 1,965 1,390 21,000 738 (18,908) 232,793 146,927 (3,000) 376,720 (352,611) 357,812 451,189 98,578 357,812 1,465,370 303,370 1,563,948 $ 661,182 1,375,000 I Page 7 SOLID WASTE Statement of Financial Operating Data FY 2016 Actual Operating Revenues Franchise Disposal Fees 4,964,159 Private Disposal Fees 1,869,094 Commercial Disp. Fees 1,446,733 Franchise 3% Fees 238,665 Yard Debris 178,658 Recyclables 18,238 Equip & Material 16,490 Special Waste 21,806 Interest 24,335 Leases 10,801 Miscellaneous 42,543 Total Operating Revenues 8,831,521 Operating Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Total Operating Expenditures Operating Rev Tess Exp Transfers Out SW Capital & Equipment Reserve Total Transfers Out Change in Fund Balance Beginning Fund Balance Ending Fund Balance 1,967,190 3,832,421 911,224 74,313 6,785,148 2,046,372 1,400,000 1,400,000 646,372 1,163, 893 $ 1,810,265 Year to Date July 1, 2016 through April 30, 2017 (83% of the year) % of Actual Budget Budget FY 2017 Projected Variance 4,541,533 87% 5,195,799 5,565,802 370,003 1,607,424 90% 1,787,980 1,829,602 41,622 1,349,222 92% 1,473,817 1,641,805 167,988 247,341 108% a) 230,000 247,341 17,341 125,499 87% 145,000 160,000 15,000 11,165 74% 15,000 13,000 (2,000) 10,187 N/A 10,187 10,187 28,358 113% 25,000 32,000 7,000 25,936 144% 18,000 29,621 11,621 9,001 83% 10,801 10,801 42,190 130% b) 32,500 46,740 14,240 7,997,856 90% 8,933,897 9,586,899 653,002 1,709,030 81% 2,120,146 2,119,100 1,046 3,101,008 71% 4,395,018 4,508,846 (113,828) 312,735 34% c) 930,944 858,512 72,432 71,882 45% d) 158,000 117,650 40,350 5,194,655 68% 7,604,108 7,604,108 2,803,201 1,329,789 1,982,791 653,002 1,375,000 100% e) 1,375,000 3,177,184 (1,802,184) 1,375,000 100% 1,375,000 3,177,184 (1,802,184) 1,428,201 (45,211) (1,194,393) (1,149,182) 1,810,265 302% 600,000 1,810,265 1,210,265 $ 3,238,466 $ 554,789 $ 615,872 $ 61,083 Beginning Net Working Capital per FY 2018 Proposed Budget I$ 615,8721 a) Fee due in April 2017 b) Includes $10,000 from sale of reportable assets c) Semi-annual payments (November and May). FY 2017 budget was not updated for refunding of FF&C 2007 d) Several capital purchases are in process e) Additional transfers will be made in June. Appropriation transfers will be made, as necessary, prior to June 30, Pd de 8 Revenues Inter -fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Transfer In -Fund 340 Interest on Investments TOTAL REVENUES Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Miscellaneous Repair / Replacement Total General Liability PROPERTY DAMAGE Settlement / Benefit Insurance Loss Prevention Repair / Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Miscellaneous Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Professional Service Insurance Loss Prevention Miscellaneous Total Workers Compensation UNEMPLOYMENT 'Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Srvc, Capital Out. & Tranfs. Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance RISK MANAGEMENT Statement of Financial Operating Data FY 2016 Actual 859,198 394,092 179,850 1,140,241 335,660 71.553 1,595 0 30,240 95,000 39,075 3,146,510 205,873 36,380 6,304 198,516 5,049 98 29,876 482,096 48,500 166,978 23,145 190,123 21,097 141,853 162,949 381,919 7,450 139,185 45,289 41,895 615,738 81,487 1,580,894 308,591 198,474 2,087,958 1,058,552 3,869,719 $4,928,271 Year to Date July 1. 2016 through April 30, 2017 (83% of the year) | % of Actual I Budget 777,150 324,260 164,330 1,014,130 228,470 32,045 1,395 30 34,830 47,303 2,623,943 FY 2017 Budget | Projected Variance 83% 931.319 931,318 83% 389'101 888.101 83% 197,155 197.155 83% 1,210,960 1,218.966 83% 273,824 273,824 - 100% 20.000 34.000 14,000 78% 1,800 1.800 ' 29% 105 105 - 109% 52.000 36.000 4.000 N/A - 118% 40,000 50.000 10.000 85% 3,102,270 3.130'370 28.000 711,537 22,616 6,250 339,623 1,347 171 32,869 1,114,412 143% 5,101 12,000 100,233 117,334 55% 781 24,796 6,985 91,853 124,415 124m 390,649 6,250 148,915 47,673 40,553 634,039 27,862 2,018,063 274,094 111,975 2,404,132 219,811 4,928,271 $ 5.148.082 780,000 1,300,000 (520,000) 215,000 100,000 70% 900'008 19% 150,000 94% 2.145,000 81% 337.106 53% 212,799 89% a) 2.694,905 407,365 123% 4.000.000 * $4.407.365 Beginning Net Working Capital perFY2Ol8 Proposed Budget * Ending Fund Balance includes $2,900,000 restricted for Workers' Comp Loss Reserve a) Appropriation transfer is necessary and will be made prior to June 30, 2017 170,000 45,000 135,000 (35,000) 715,000 50,000 2,370,000 330,106 212,799 2,912,905 217,365 4,928,271 U$ ~ 185,000 100,000 (225,000) 7,000 (218,000) (190,000) 928,271 $ 738,271 Page 9 Revenues Property Taxes - Current Property Taxes - Prior State Reimbursement State Grant Telephone User Tax Data Network Reimb. Jefferson County User Fee Police RMS User Fees Contract Payments Miscellaneous Interest Total Revenues Expenditures Personnel Services Materials and Services Capital Outlay Total Expenditures Transfer In - Fund 710 Revenues less Expenditures Beginning Fund Balance Ending Fund Balance DC 9-1-1 (Funds 705 and 707) Statement of Financial Operating Data FY 2016 Actual Year to Date July 1, 2016 through April 30, 2017 (83% of the year) FY 2017 % of Actual Budget Budget Projected 7,091,838 7,228,277 97% a) 7,430,701 7,430,701 139,516 94,205 67% 140,000 100,000 52,851 44,493 7% b) 640,000 820,000 0% c) 278,500 278,500 825,758 429,989 55% d) 780,000 880,000 51,399 59,466 112% e) 53,000 59,466 31,743 32,302 98% 33,000 33,000 56,776 56,825 103% 55,000 56,825 314,631 198,541 71% e) 280,000 280,000 486,783 42,698 8% f) 547,653 142,000 333,046 289 N/A - 289 76,500 89,708 209% 43,000 100,000 9,460,840 8,276,793 81% 10,280,854 10,180,781 5,066,537 4,821,541 2,727,787 2,238,546 1,821,228 4,422,896 9,615,552 11,482,984 5,723,091 5,568,379 71% g) 6,748,556 75% 2,968,767 78% 5,650,000 75% 15,367,323 400,000 400,000 (2,806,191) (4,686,469) 4,995,106 10,563,485 $ 10,563,485 $ 7,757,294 Beginning Net Working Capital per FY 2018 Proposed Budget 114% 9,290,627 $ 4,604,158 a) Current year taxes received beginning in October b) Reimbursement for the State's share ($780,000) of the new 9-1-1 phone system is pending c) All grant work has been completed. Submitting a reimbursement request d) 3rd Qtr payment is pending. Revenue is trending higher than expected e) Annual payment recently invoiced f) Radio system user fees will not be invoiced due to the levy passing g) Projection based on unfilled positions 6,148,556 2,868, 767 5,650,000 14,667,323 400,000 Variance (40,000) 180,000 100,000 6,466 1,825 (405,653) 289 57,000 (100,073) 600,000 100,000 700,000 (4,086,542) 599,927 10,563,485 $ 6,476,943 6,600,000 J 1,272,858 $ 1,872,785 Page 10 Health Benefits Fund Statement of Financial Operating Data FY 2016 Actual Revenues: Internal Premium Charges $ 15,745,144 Part -Time Employee Premium 8,000 Employee Monthly Co -Pay 900,225 COIC 2,103,195 Retiree / COBRA Co -Pay 1,147,682 Prescription Rebates 66,573 Claims Reimbursements & Misc 314,287 Interest 119,284 Total Revenues 20,404,390 Expenditures: Materials & Services Admin & Wellness Claims Paid -Medical 12,745,706 Claims Paid -Prescription 914,949 Claims Paid-Dental/Vision 1,927,875 Stop Loss Insurance Premium 358,991 State Assessments 119,231 Administration Fee (EBMS) 487,091 Preferred Provider Fee 155,634 Other - Administration 201,166 Other - Wellness 152,033 Admin & Wellness 17,062,675 Deschutes On-site Clinic Contracted Services 905,222 Medical Supplies 68,477 Other 31,690 Total DOC 1,005,389 Deschutes On-site Pharmacy Contracted Services 350,144 Prescriptions 1,670,080 Other 21,002 Total Pharmacy 2,041,226 Total Expenditures 20,109,291 Change in Fund Balance 295,100 Beginning Fund Balance 14,207,523 Ending Fund Balance $ 14,502,622 % of Exp covered by Revenues 101.5%11 July 1, 2016 through April 30, % of 2017 (83% of Budget Fiscal Year) $ 14,126,556 2,261 762,885 1,815,137 992,675 33,885 82,361 136,108 17,951,869 85% a) N/A 82% a) 89% a) 82% 26% 55% 118% a) 84% 10,890,368 81% a) 785,777 80% a) 1,788,471 87% a) 305,481 73% 0% 383,106 80% 77,753 45% 188,963 101% 151,000 14,570,920 80% 97% 727,543 80% 57,101 67% 34,500 73% 819,144 79% 281,131 83% 1,299,346 79% a) 28,260 93% 1,608,737 80% 16,998,801 80% 953,068 14, 502, 622 $ 15,455,691 105.6%I FY 2017 Approved Budget 16, 670, 000 928,800 2,050,000 1,208,893 130,000 150,000 115,000 21,252,693 13,463,599 977,251 2,059,150 420,000 225,000 481,500 171,800 186,574 156,350 18,141,224 905,000 85,000 47,525 1,037,525 339,200 1,650,000 30,374 2,019,574 21,198,323 FY 2017 Projection 16, 951, 868 2,714 915,462 2,178,164 1,191,209 130,000 150,000 163,330 21,682,747 13,136, 444 942,933 2,154,295 420,000 225,000 481,500 171,800 230,000 156,350 17,918,322 905,000 85,000 47,525 1,037,525 339,200 1,732,461 30,374 2,102,035 21,057,882 54,370 624,865 101% 14,327,000 14,502,622 $ 14,381,370 $ 15,127,488 $ 100.3%1 103.0%1 Beginning Net Working Capital per FY 2018 Proposed Budget I $ 15,000,000 I a) Year to date annualized $ Variance 281,868 2,714 (13, 338) 128,164 (17,684) 48,330 430,054 327,155 34,318 (95,145) (43,426) 222,902 (82,461) (82,461) 140,441 570,495 175,622 746,118 Page 11 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 TRT Grant Total Operating Exp, net of TRT Other: Park Acq/Dev (Fund 130) Rights & Signage Interest Total Other I 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 Statement of Financial Operating Data July 1, 2016 through April 30, 2017 Year to Date (83% of the FY 2016 year) Actual Actual I% of Budget $ 539,591 59,700 19,475 51,449 92,159 283,000 43,605 7,384 1,096,364 899,882 (124,842) 714,323 (95,265) 1,394,098 30,000 101,630 1,587 133,217 (164,516) 300,000 25,744 (62,740) 263,004 $ 412,333 75.7% 66,951 111.6% 4,050 18.4% 3,690 7.1% 105,996 100.0% a) 440,000 145.3% b) 25,000 83.3% c) 8,566 96.3% 1,066,586 94.7% 784,305 78.8% (155,329) 83.2% 638,279 79.7% (110,444) 48.7% 0.0% 0.0% 1,156,810 83.7% 22,500 75.0% 96,265 87.5% 1,314 164.3% 120,079 85.3% 29,855 208,330 83.3% 21,450 83.3% (55,000) 100.0% 174,780 79.2% 109,927 57,422 52.9% 109,927 57,422 52.9% 1 Beginning Net Working Uapital per Proposed budget (11,440) 147,213 58,723 47,283 120.4% 47,283 $ 194,497 FY 2017 Budget I Projection $ 545,000 60,000 22,000 52,000 106,015 302,814 30,000 8,900 1,126,729 995,217 (186,672) 800,712 (226,594) 255,000 (255,000) 1,382,663 30,000 110,000 800 140,800 (115,134) 250,000 25,744 (55,000) 220,744 $ 528,929 66,951 18,950 22,670 118,067 440,000 30,000 10,767 1,236,334 109,605 $ Variance $ (16,071) 6,951 (3,050) (29,330) 12,052 137,186 1,867 948,305 46,912, (186,672) 787,579 13,133 (153,250) (73,344) 255,000 (255,000) 1,395,962 (13,299) 30,000 - 112,265 2,265 1,446 646 143,711 2,911 (15,917) 99,217 I 250,000 25,744 (55,000) 220,744 108,488 102,536 5,952 108,488 102,536 5,952 (2,878) 102,291 105,169 39,277 47,283 8,006 $ 36,399 $ 149,574 $ 113,175 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 $ 225,000' Page 12 >, N .> O > U M Q a) O o (� Q a> 0) W a) o c '0 m s o C 0) C CO (0-00 LL 0 N 0 LL FY 2017 Actual Year to Date O) et O) � CO CO V' O o r- O) ti N V' <0 (0 co N V' CO O M O) Co (0 r CO n O) C0 0) CO r et N CO Ln r > I` Ln ' M r M er 0) 0) d' O) O ' 0) M N N 0) N N M 00 M L() CO N 0) CO 0) r CO 0) 0) r N 0 r 0 r r O 0 O (O O) tt N o CO N 00 O 00 CO N CO 0 et CO I` CO 00 N 0) 0 Ln Ln et in 0) 00 tt r O r CON ti CO Lt) et NCO ' O r CO O) co p_ N((N O 0 N V' O N M in CV r 4 N (O 00 Q r 0 U co 2 EA 0 0 0 Oct r o N N 0 1s CO CO CO 0 00 Ln O CO I` 00 00 o O O r 0 r 001` (O Cej ' 0 ' O CNI N et Net CO CONN M ti 0000 W 00 O O 00 E9 et 00 O M co .- N N o '4) N N. 0 0) O 0 O co N et CO O 0) 00 a0 N 0 M d' 00 0 (0 CO 0) O (0 C) r ti 0) r N- ti ' LC) N r M r 2 (0 L<) N M O (O 00 Ln r N O O r .fl M N N r r r r r r 0) LL EA E9 0) Ln N et CO CO CO O) 0 o co co 0 in in 6- 6-. in 0 00 M co M CN N 0 et et CO 0 (0 00)(O M MCF (fl 0 00 ' ' r N N O) D (0 et N Ln r M I'N et M N N O O Lt) C CO N r N r N r r .1 - CO L0 -) E9 69- It A N 00 Lf) r LO) r r Ln CO N o 00 CO CO 0 CO (0 00 0) 0) 0) O M N r 0) t` 0) n 0 Ln Lt) 0 00 r CO 0 et r r t` r M r er CO N N et E E�' N N r N 0") r N r r N O O ((0 U r 0) 0 E9 0) E 0) O Z 0) 0 U 0 0 E Q O 16,506 $ 24,988 $ 41,302 0 0 L!) Ln L4 0 O) M CO 0 O) 6 et N CO CO Ln t` N r Ln h L<) 0 N N r Ln L() N r v r r N r N co O O 00)) CO et CO (0 N -- Cs/ N O r r ti r r EA LI) N O CO et CO N o O) O) O co (0 co O W CO Ns (` 00 O V' et' 0 (` ti r- ix) Ln O to W I- co r ou 00 ' ' 0 N r M to (O (xLn 00 N r N N et r r O O M N v r r r r EA. CO O LC) 0) N 0 0 U) 0 00 CO 0 00 00 Ll) Ns N t` co co N CO r CO M O I` n in I` M Ln Ln r d' N N 00 r ' ' is:, N (0 CO 00 t` M (0 V' r et O LO M r - O O N N v r r r M Ps et CO CO CO CO N. o 0 0 0) 0) 00 O Mszr r- 00 (0 co in h r` LC) Lt) CO O 0) h ry) r et et I` O CO CO„ Ln LC)O M ' ' M O <0 6- ') to Ln M 0 r r M r M O) r 0) CO N EA EA (0 O N.- CO 0 Ln CO CO o LO CO 0) Nr 00 Lt) N CO (0 0 0 CO CO r 0) Lt) et 00 in et O T 0) O) 00 V' CO N N I\ r 05 CO CO ' M t` r O) et 0 O N N N N (0 CO r O) .- O M.. CN r EA FY 16 Actual r et Ln O O) r o M 00 r N M 0) tt) (0 CO CO r h L<) CO CO 00 CO to n et 00 et N Co co ' Lt) O Ln r OO) 00) .r- O 00 O to Oto N M r N r r EA 0) on 0 0) 0) Z, oiS 0 O cn > Q) lL c 0 c Q 0) N - H c 0) 17;X 0 c o U W v'rna W a _o W J CC o Total Direct Costs Gross Profit Gross Profit Percentage Total Expenses EA Income (Loss) F&B Activity M 0) L0 0 Revenues Court Fines & Fees Interest on Investments Total Revenues Expenditures Personnel Services Materials and Services Total Expenditures JUSTICE COURT Statement of Financial Operating Data FY 2016 Actual Year to Date July 1, 2016 through April 30, 2017 (83% of the year) % of Actual Budget 530,437 400,496 77% a) 803 1,139 N/A 531,240 401,635 77% Budget 520,000 520,000 435,314 385,051 84% 458,984 158,695 130,267 74% 175,007 594,008 515,318 81% 633,991 Revenues less Expenditures (62,768) (113,683) Transfers In -General Fund 145,747 20,830 83% Change in Fund Balance 82,979 (92,853) Beginning Fund Balance 78,723 161,702 111% End Fund Bal (Contingency) $ 161,702 $ 68,849 Beginning Net Working Capital per FY 2018 Proposed Budget FY 2017 Projected (113,991) 25,000 (88,991) 145,608 $ 56,617 $ Is a) Year to date: July through March. April revenue: $45,292. Projection: Ten months actual annualized $534,946 Variance 534,946 14,946 1,500 1,500 536,446 16,446 458,984 175,007 633,991 (97,545) 16,446 25,000 (72,545) 16,446 161,702 16,094 89,156 $ 32,539 85,000 I Page 14 REVENUES Room Taxes Interest Total Revenues EXPENDITURES Administrative Auditing Services Temporary Help Interfund Contract ISF Public Notices Printing Office Supplies Postage Total Administrative Current Distributions LED #2 Sunriver Chamber (1) Sunriver Chamber (2) Sunriver Service Dist (3) COVA-6% COVA - 1% RV Park Annual Fair F&E-6% F&E Reserve Fund F&E - 1% Total Distributions Total Expenditures Balance Transfer to Gen Cap Reserve Change in Balance Beginning Balance Ending Balance Fund 160 Budget Deschutes County Room Taxes (Funds 160 and 170) Budget and Actual - FY 2017 YTD 04-30-2017 Fund 170 Actual Budget 1 Actual $ 5,425,000 $ 5,100,804 3,000 8,616 5,428,000 5,109,420 11,000 68,951 37,291 2,650 1,800 900 2,625 125,217 3,151, 787 34,500 10,000 200,000 868,696 758,007 25,744 5,048,734 5,173,951 254,049 489,049 8,750 865 57,460 31,080 1,225 870 150 730 101,130 2,889,139 44,500 758,733 672,360 23,595 4,388,326 4,489,456 $ 775,000 $ 728,686 5,288 775,000 733,975 1,500 1,250 124 11,324 9,440 11,932 9,950 400 175 350 124 125 21 400 104 26,031 21,189 40,000 28,721 61,000 76,112 224,703 168,527 668,266 233,031 993,969 506,391 1,020,000 527,579 619,964 1 (245,000) 206,395 489,049 (235,000) 130,915 235,000 313,406 - $ 444,321 1) $30,000 base plus 15% increase to match COVA's increase 2) $10,000 To Sunriver Chamber for consultant 3) $200,000 to Sunriver Service District for Training Facility (245,000) 206,395 245,000 405,292 $ - $ 611,687 Combined Budget 1 %of Actual Budget $ 6,200,000 $ 5,829,490 94.0% 3,000 13,904 463.5% 6,203,000 5,843,394 94.2% 12,500 10,000 989 80,275 66,900 49,223 41,030 3,050 1,400 2,150 994 1,025 171 3,025 835 151,248 122,318 3,151,787 2,889,139 34,500 44,500 10,000 200,000 868,696 758,007 40,000 61,000 25,744 224,703 668,266 6,042, 703 6,193,951 9,049 489,049 9,049 480,000 489,049 $ 758,733 672,360 28,721 76,112 23,595 168,527 233,031 4,894,717 5,017,035 826,359 489,049 337,310 718,698 1,056,008 JRF 5/2/2017 Fund # Fund Name Technology Reserves 111 Court Tech Reserve 114 Assessment/Tax/Clerk Reserve 631 Finance/HR Project Reserve 661 IT Reserve 710 9-1-1 System Reserve General Reserves 140 Project Dev&opment and Debt Reserve 142 General County Projects 143 General Capital Reserve Department Reserves 300 CDD Reserve 301 CDD BuiJdng Program Reserve 303 CDD Building mprovement Reserve 330 Road Building and Equipment Reserve 465 Road Capital Projects Reserve 611 Sod Waste - Landfill Closure 612 Solid Waste LandfiUPostz|osune 613 SoIid Waste Capital Projects 614 Solid Waste Equipment Reserve 617 Faft arid Expo Center Capital Reserve 721 Extension 4H Capita Reserve 135 PERS Reserve Total Deschutes County, Oregon As of May 15, 2017 Summary of County Reserve Funds Balance 5/15/17 Purpose 112,717 Replace and mantain courtroom technology 834,100 Repace and upgradetaxation and clerk systems 556,324 To Fund IOSS/MUNIS Project 668,584 Countywide IT System Replacement and Upgrade 3,470,382 To Fund current 9-1-1 system projects through FY 2018 5,652,107 822,353 Land purchases and payment of debt obligations 1,073,049 County facility upgrades and major maintenance 6,531'540 Capital reserve for future facility needs/BOCC priorities 8,416,942 1,880,345 Service stabfUzaton during economic fluctuations 840,016 Buliding Permit program reserve for economic stabHity 69,534 CDD FaciIity improvement reserve fund 2,789,895 1,271,736 Replacement of Road facilities and equipment 7,357,685 To fund 5 year Road CIP Plan 8,629,421 3,790,430 Landfihl CelI cap construction & run off and gas mgmt /84870 Knott 30 year ongoing monitoring and maintenance 2'517'621 Reserve for future construction of additional cells 402,146 Replacement of equipment used in the Solid Waste process 7,495,067 545,235 Major maintenance and replacement of Fair and Expo facility 532,571 Reserve for buding expansion 13,102,633 To offset significant PERS employer ratincreases 47,163,871 Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA May 15, 2017 (1) Monthly Investment Reports — April 2017 (2) April Financials W -< O Deschutes County Board of Commissioners � .1.'kr iA'�a F S'�� 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 Mav 17, 2017 DATE: FROM: Timm Schimke, Solid Waste, 541-317-3177 TITLE OF AGENDA ITEM: Solid Waste Management Planning/RFP Review PUBLIC HEARING ON THIS DATE?: No To: BOCC From: Timm Schimke, Director CC: Tom Anderson Date; May 12, 2017 Re: SoIid Waste Planning Knott LandfiII, as operated today, is expected to reach capacity in 2029. The time frame needed to site a new disposal facility typically takes 7 to 10 years. In addition, none ofthe new waste to energy technologies are able to process all ofthe waste that a IandffH accepts. Some waste cannot be processed, and most technologies have a residual at the end of the process that may need to be disposed. If we were to embrace waste to energy, we would still need landfill capacity although the amount of material to be Iandfilled wouki be greatly reduced. For these reasons, it would be advantageous for Deschutes County to start the process of deciding on how we want to approach solid waste disposal in the future sooner rather than later. We should have sufficient time to develop whatever option is most appealing, and also have some remaining capacity at Knott Landfill if we choose to pursue a waste to energy technology that requires continued landfilling of a smafl portion of the waste stream. We have developed a request for proposals for the development of a solid waste management plan. The primary purpose will be to develop a number of disposal options for consideration. These options would include but is not timited to: 1. Siting and developing a new IandfiII in Deschutes County or Central Oregon 2. Contracting for transport and disposal with an existing landfill out of the area 3. Siting and developing some form of waste to energy facility 4. A combination of disposal options. Identified options would be analyzed from a number of perspectives such as economic impact, environmental impact, ease of implementatiori etc. We would gather input from a stakehokier group as well as the community at large, and the Board would make a decision on a preferred option. In addition, all other aspects of the solid waste system such as collection, recycling, and transfer would be examined and recommendations would be made primarily to ensure that those aspects of the system are integrated as efficiently as possible with the new disposal option. We are aware that Negus Transfer Station in Redmond is operating at capacity and will need substantial improvements regardless of future disposal. Development of a master plan and budget for those improvements will be a part of this work. We also intend to address an approach to implementing a beneficial use for our landfill gas. The Solid Waste Management Plan will provide a timeline and estimated capital requirement for improvements to the system that will be developed over the next 10 to 15 years as we transition from disposal at Knott Landfill to the next generation of solid waste management in Deschutes County. We look forward to discussing this with you. We would like to hear any concerns or thoughts you might have on our approach, or the disposal options listed above so we can better direct the efforts of the consultant. The expect cost of this project will be between $150,000 and $200,000, and take 6 to 9 months to complete. Request for Proposals For development of a Solid Waste Management Plan Deschutes County Department of Solid Waste 61050 S.E. 27th Street Bend, Oregon 97702 Issue Date: May 2017 Response Due Date: 4:00 pm Pacific Daylight Time on June , 2017 INTRODUCTION The Deschutes County Department of Solid Waste is seeking proposals from qualified proposers for the development of a Solid Waste Management Plan. The primary purpose of the plan will be to assist the County in determining the future disposal method(s) to be used after the current landfill serving the County has reached the end of its useful life. All aspects of the solid waste system (disposal, collection, recycling, and transfer) will be examined and evaluated for efficiency and compatibility with the other components of the system Il. CONTACT PERSON Timm Schimke, Director Phone: 541 317-3177 Email: timm.schimke@deschutes.ora All questions should be directed to Mr. Schimke III. SCHEDULE RFP issue date: May 1, 2017 Deadline for questions or clarifications: May 15, 2017 Proposals due: May 31, 2017 IV. SUBMITTAL REQUIREMENTS Firms must submit six (6) hard copies of the proposal in a sealed envelope or package. Proposals must be received by 4:00 p.m. on Wednesday- , 2017. Proposals are limited to fifteen pages of written material (not including biographies which may be included in an appendix). NOTE: All proposals submitted in response to this RFP shall become the property of Deschutes County and may be utilized in any manner and for any purpose by Deschutes County. Be advised that proposals submitted in response to this RFP are subject to public disclosure as required by applicable state and/or federal laws. If you intend to submit any information with your proposal which you believe is confidential, proprietary or otherwise protected from public disclosure (trade secret, etc.), you must separately bind and clearly identify all such material. The cover page of the separate binding must be red, and the header or footer for each page must provide as follows: "Not Subject to Public Disclosure." Where authorized by law, and at its sole discretion, Deschutes County will endeavor to resist public disclosure of properly identified portions of the proposals. Envelopes or packages must be addressed as follows: Deschutes County Department of Solid Waste, SWMP Attention: Timm Schimke, Director 61050 SE 27th Street Bend, OR 97702 Page 1 of 7 V. BACKGROUND Deschutes County is a political subdivision of the State of Oregon located in central part of the state. It has a population of about 175,000 people. There are 4 incorporated cities in the county. Bend, the largest city has over 83,000 people, Redmond has a population of over 28,000, Sisters has a population over 2,400, and La Pine with a population of about 1,700. Solid waste generated in Deschutes County is disposed at Knott Landfill located in Bend, Oregon. The landfill has been in operation since 1972, and is expected to reach final capacity in 2029. Approximately 161,000 tons of municipal and non -municipal solid waste was accepted at the landfill in 2016. While we experienced a 40% reduction in annual waste flows into the landfill through the economic downturn (2007 — 2011) robust growth in waste flows has returned and we have experienced 11% growth in tons disposed in each of the last 2 years. Wastes generated in the other incorporated communities in the County outside of the Bend area (Redmond, Sisters and La Pine) as well as unincorporated rural areas of the county are served by 4 rural transfer stations. Waste collected at these transfer stations account for about 25% of the waste disposed at Knott Landfill. The rural transfer stations are an open air design in a Z -wall configuration where the general public as well as franchised collection companies top load into trailers. The largest of these transfer station located near Redmond, Oregon is believed to be operating at capacity and accounts for over half of all waste generated through the transfer system. Prior to 2006, all vehicles disposed of waste directly at the working face at Knott landfill. New receiving facilities were constructed adjacent to the landfill in 2006 including a compost area, recycling facilities, household hazardous waste facility, new administration office and a 30,000 square foot transfer station. These facilities allowed further development of landfill cells, improved safety for customers, and are intended to provide receiving facilities for transport to the new disposal option long after Knott Landfill closes. Curbside collection in the County is provided through private companies operating under franchise ordinances. The County franchises collection in unincorporated areas and each of the incorporated cities has its own franchise ordinance although all ordinances are very similar. The County is divided into four (4) geographically defined areas with one franchised company having exclusive rights to serve the area assigned to it. The local government dictates a minimum level of service to be provided, and establishes a maximum rate that can be charged for the service. Self- haul by citizens is allowed. Redmond and Sisters have mandatory collection service within thier city limits. Recycling education and promotion is provided by the franchised collectors as well as through the efforts of The Environmental Center, a local non-profit organization which receives a grant from Deschutes County to assist the local governments in meeting state requirements to provide the opportunity to recycle to citizens. Franchised company education and promotion efforts are primarily through newsletters providing information to customers. The Page 2 of 7 Environmental Center conducts programs in youth education, waste prevention, and community outreach. Oregon Department of Environmental Quality reports Deschutes County's diversion rate at about 36%. Deschutes County has a diversion rate goal of 45%. Diversion is 100% reliant on source separation by the waste generators. There are minimal efforts to recover materials that are delivered for disposal. VL PROPOSED SCOPE OF WORK The purpose of the work described herein is to provide Deschutes County with an analysis of available disposal options/technologies and to recommend a preferred option and/or technology, or combination thereof to meet the County's needs in the future. In addition, the other components of the solid waste system should be reviewed, and changes to those components should be identified with the intent of having those components integrated as efficiently and effectively as possible with the preferred option(s). The successful proposer may recommend a different approach to the project than outlined below, therefore, a final scope of work, schedule and budget will be developed with the successful proposer. The work may include arranging and leading tours of facilities that use new or emerging waste management technologies, but will not include facility siting, or detailed facility designs. The County intends to convene a stakeholder group consisting of representatives from the franchised collectors in the county, the recycling community and representatives from each incorporated city. The Contractor will be expected to assist the County with stakeholder meetings and other public outreach efforts to better understand the citizens' interests. The County is interested in the following approach but is open to other approaches or additional tasks to accomplish the purpose. Task 1: Disposal Identify available disposal options including but not limited to a) construction of a new landfill in Deschutes County or Central Oregon, b) contract for transportation and disposal services with an existing landfill, c) incorporate new conversion technology to recover energy from the waste stream or portion of the waste stream. Analysis should include economic impacts, environmental impacts and/or other criteria which will assist in an informed decision regarding future disposal. Analysis should also include required or beneficial modifications or changes to other components of the solid waste system for each disposal option, and how those modifications or changes affect the criteria being used. This task should include a process to gain input from stakeholders and the general public which will be included in the analysis. It is anticipated that this task will result in a detailed report of the options and analysis conducted which will be a basis for the Board of County Commissioners' decision on a future disposal method. Task 2: Transfer The transfer system in the County should be reviewed for efficiency and effectiveness. Focus Page 3 of 7 should be on any changes or modifications that would be desirable based on the new disposal options identified in task one. In addition, Negus Transfer Station in Redmond is believed to be operating at capacity, and will need improvements regardless of its current suitability for integration with the new disposal option. The County is interested in developing a master plan for the site to identify improvements including preliminary design and site layout, recommended timelines for improvements and budgetary cost estimates for improvements. Task 3: Collection Deschutes County recognizes that County jurisdiction and control over the franchised collection system is limited to unincorporated areas of the county, however we would like to see the general approach to collection assessed for efficiency and effectiveness considering potential changes in disposal. Task 4: Recycling/Diversion Deschutes County relies on source separation to realize the current diversion rate. Citizens deposit materials at the curb, disposal sites or recycling depots. Recyclables are collected in a dual stream system with glass handled separately. Co -mingled materials are shipped to materisl recovery facilities located over 100 miles away to have the commodities separated and marketed. Deschutes County would like to meet and exceed its designated diversion goals and seeks an assessment of the system and recommendations to achieve that goal. Task 5: Landfill Gas to Energy Despite the relatively small size of Knott Landfill and the arid climate of the region, a number of developers have expressed interest in installing a landfill gas to energy project at the landfill. An attempt to implement a project with a developer was attempted, but the developer was unable to secure financing in a timely manner and the contract was terminated. Deschutes County continues to be open to the possibility of a landfill gas to energy project, however we feel any approach should be considered along with future disposal to take advantage of any benefits or synergies that may be realized from a joint approach. This task should include an assessment of these factors and a review of established and new approaches to establishing a beneficial use of our landfill gas. VII. DOCUMENT DELIVERABLES The County envisions 3 separate documents for the project. • Task 1 will be a stand alone document that will be used to assist the Board of County Commissioners to make a decision regarding future solid waste disposal in Deschutes County. • The master plan for Negus Transfer Station referenced in task 2 should be a separate document. Page 4 of 7 The all-encompassing Solid Waste Management Plan will include the information of tasks 1 through 5 including the County's decision regarding disposal. VIII. PROPOSAL FORMAT AND CONTENT Proposal must contain the following information: a. Cover Letter. Provide name and address of the proposer and project contact person with address, telephone number, and email address. Acknowledge receipt of any addenda if applicable. Briefly summarize your understanding of the project scope and services being required. Provide a summary of the benefits you believe the County would receive from selecting you. The cover letter must be signed by a duly authorized official of the proposer. Consortiums, joint ventures, or teams submitting proposals must establish that contractual responsibility rests solely with one company or one legal entity. b. Project Team Experience and Qualifications. Prepare an organizational chart showing your team. Provide resumes or listing of information for each person assigned to this project. State the years of experience, length of employment with proposer, and experience providing solid waste management related services. For each person, list specific responsibilities, experience with similar counties of similar size and type, and current work assignments and availability. c. References. Provide a list with contact information of agencies that have requested your services to provide Solid Waste Management Planning Services. d. Experiences. Each proposer shall supply recent examples of similar projects in other solid waste systems the proposer has been involved with. Include related past projects completed along with discussion comparing similarities with this proposed project. e. Understanding of Project. Provide in detail your understanding of what the project entails. f. Approach to the Scope of Work. Discuss how you will accomplish the scope of work. Include details of how and when you will interact with staff, the process to develop the SWMP and how you plan to complete each task. g. Page 5 of 7 Project Schedule. Provide your schedule for performing the work, including major milestones and deliverables. VIII. REVIEW AND SELECTION An evaluation team consisting of County staff and members of the stakeholders group will determine the best proposal deemed most qualified based on the below criteria. The evaluation team will rely on the qualitative information contained and presented in the proposals and reference checks in making the decision to select the most qualified proposer for further consideration to provide services for the County. Selection criteria will be based on: • Experience, Capabilities and Resources of the Proposer. 25 points, Proposals will be scored on the capabilities of the proposer including the degree that the proposer demonstrates an understanding of County objectives and the ability to meet these objectives. Includes available resources to perform the work, availability of key staff to the Bend area and ability to provide on-site responses to issues during development of the plan. • Experience of project team members. 25 points. Project team experience and demonstrated knowledge and experience with similar assignments; past experience working with integrated solid waste systems; a satisfactory record of performance. • Approach to the scope of work. 25 points Understanding of the project, proposed approach, methodology and ability of the proposer to create a SWMP that meets the needs of the County and complete each task in an effective and efficient manner. Project team's organization, chain of command, and ability to develop fact sheets, presentation materials, and memos during plan development. • Schedule. 10 points Reasonableness and ability to complete the project during the proposed timeframe. • Reasonableness of the Cost Proposal. 15 points Upon review of the proposals. The proposals will be ranked. The highest ranking proposal may be invited in for an interview or start negotiations with the County. If an agreement cannot or is not reached with the highest ranked proposer, we reserve the ability to consider the second ranked proposal. The same process may be repeated with the other ranked proposals if no such agreement is reached. The County reserves the right to not select any proposal associated with this RFP process. The County expects to make a selection based on the written proposals. However, Proposers determined to be reasonably acceptable for award may be required to provide an on-site presentation of the proposed solution for the evaluation committee. If presentations are needed the County will schedule a date, time, and location for each of the proposers if necessary. Proposers will be responsible for all costs associated with providing the presentation. The County reserves the right to reject any proposal determined to be nonresponsive and to reject any proposal determined to be nonresponsive. The County also reserves the right to refrain from making an award if it determines it to be in its best interest. Page 6 of 7 IX. AGREEMENT If the County proceeds with a contract, the selected proposer shall be required to enter into a formal agreement for the subject services and to provide insurance certificates and other information as required by the County. The County's Services Contract will form the basis of the contract between the proposer and the County. Unconditional refusal to accept the contract provisions proposed in the County's Services Contract without offering reasonable alternatives that do not substantially impair the County's rights under the contract may result in disqualification. Unless indicated otherwise, submission of a proposal indicates that the proposer is willing to enter into a contract with the County substantially incorporating the terms of the County's Services Contract. A copy of the County's Services Contract is attached. Page 7 of 7 TE 0) w 0 -< Deschutes County Board of Commissioners 1300 NW WaII 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 Mav 17. 2017 DATE: May 8, 2017 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: State of the County - What's Brewing / Bend Chamber PUBLIC HEARING ON THIS DATE?: No ATTENDANCE: Whitney Hale, Administrative Services SUMMARY: The Bend Chamber's "State of the County" What's Brewing event is coming up on July 11 from 5 - 7 p.m. The event will be held at Deschutes Brewery. The Chamber would like a high-level list of topics that will be discussed at the What's Brewing event, so they can start their marketing efforts. What's Brewing: State of the County Presentation with the Bend Chamber Scheduled Date: Tuesday, July 11 Time: 5 p.m. to 7 p.m. Location: Deschutes Brewery (Downtown) The Chamber is hoping to begin promoting the event soon and has asked us for some high level themes of what you might be discussing. Here are a few draft potential topics for consideration: • Adopted FY 2018 Budget Highlights • Long Term Solid Waste Options (RFP) • Fair & Expo Future (Study) • FY 2018 Capital Project — Old Bend -Redmond Highway Improvements • Economic Development: Continued strategic land development and workforce development • Housing: Developing opportunities for increased flexibility and efficiency in land use • CCBHC Pilot • Crisis Stabilization and Sober Center Concept / Update • Solar Eclipse: Planning and preparedness • 9-1-1 Radio Project Update TES o `'3 -< Deschutes County Board of Commissioners 1300 NW WaII 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 Mav 17. 2017 DATE: April 24, 2017 FROM: Whitney Hale, Administrative Services, 541-330-4640 TITLE OF AGENDA ITEM: Employee Recognition Breakfast Discussion PUBLIC HEARING ON THIS DATE?: No ATTENDANCE: Whitney Hale SUMMARY: Discussion about this year's employee recognition breakfast. 2017 Employee Recognition Breakfast Proposed Date: Saturday, August 5th Time: 9 -10:30 a.m. Place: Deschutes County Fair & Expo Center Buckaroo Breakfast Area Menu: Sausage Links, Pit Ham (carved at the end of the line), scrambled eggs, Obrien breakfast potatoes, baking powder biscuits and gravy, fresh cut fruit bowls, orange juice, coffee, tea and ice water. Logistics: • Prior to the breakfast, employees will receive two tickets to the Fair concerts • At the breakfast, they'll receive free Saturday admission to the fair, two tickets to the Saturday night concert and one free carnival ride per person. MARIJUANA DISCUSSION DESCHUTES COUNTY COMMISSION — WORK SESSION 5/17/2017 MEETING WITH LEGISLATORS 5/8 Materials presented Feedback on legislator concerns Commitment on meeting with growers/other citizens COUNTY REGULATIONS GOING FORWARD Meeting on progress ? Annual review? AFFORDABLE HOUSING DISCUSSION DESCHUTES COUNTY COMMISSION — WORK SESSION 5/17/2017 (Outline prepared by Commissioner Henderson for discussion of all Commissioners OVERVIEW OF HOUSING NEEDS IN DESCHUTES COUNTY Areas of County/Cities where some level of affordable housing is needed Price -point?? Type of Housing (single family vs. multi -family) COUNTY ROLE TO -DATE Land transfers Housing works/ Habitat for Humanity Others? Legislative (2017) HB 2222 --- Resource land re -designation where appropriate ADU Bill Tiny Homes Bill Others? GOING FORWARD Vacant land inventory on different types of parcels Resource land re -designation (with cooperation of DLCD,some areas Inventory other county solutions (ie. Tillamook study) Compare with City solutions (Bend,Lapine, Redmond, Sisters) Surveys, hearings or public meetings on needs Others?