Loading...
2019-426-Minutes for Meeting September 23,2019 Recorded 10/7/2019GwTES COG 2� BOARD OF COMMISSIONERS 1300 NW wall Street, Bend, Oregon (541 ) 388-6570 11' Recorded in Deschutes County Nancy Blankenship, County Clerk CJ2019-426 Commissioners, Journal 10/07/2019 10:21:17 AM 2019-426 FOR RECORDING STAMP ONLY MONDAY September 23, 2019 ALLEN CONFERENCE ROOM Present were Commissioners Phil Henderson, Patti Adair and Anthony DeBone. Also present were Erik Kropp, Deputy County Administrator; David Doyle, County Counsel; and Sharon Keith, Board Executive Assistant. Several staff and several identified representatives of the media were in attendance. CALL TO ORDER: Chair Henderson called the meeting to order at 1:02 p.m. ACTION ITEMS 1. Monthly Treasury and Finance Report Greg Munn, Chief Finance Officer presented the treasury, investments, and finance report for the month of August 2019. Commissioner Henderson requested a history of funding that Deschutes County has in reserve and capital. The Investment Advisory Committee meets this Thursday, September 26. Commissioner DeBone inquired on budget work and the possibility of expanding the planning horizon for a two year budget cycle. Commissioners Adair and Henderson like the budget process (annual) as is. Property tax season is approaching and Mr. Munn noted the property tax bills have been revised to provide clarity for the tax payer. There are 65 department staff vacancies. Mr. BOCC MEETING SEPTEMBER 23, 2019 PAGE 1 OF 5 Munn will make revisions to the formatting of the department wide summary reports to allow additional room for data. 2. Continued: Wildfire Mitigation Advisory Committee Appointments, Finalize Charter County Forester Ed Keith and Planning Manager Peter Gutowsky presented the continued discussion. The Board reviewed their nominations for applicants representing: fire/first responders, insurance, home owners associations, builder/construction/real estate, planning commission, and other. Commissioner Henderson asked for clarification on the goals of the committee. Is it simply for Deschutes County to come up with a map to implement if deciding to opt into the new building codes? Mr. Keith stated the wildfire hazard mitigation map wouldn't need to be updated if we do not update the building code relative to R327. The committee's purpose is to make recommendations based on factors such as land use and zoning and also look at the University of Oregon study results. Discussion held on the needs for certain expertise on the committee. Mr. Keith presented the draft wildfire mitigation advisory committee charter. The Board expressed support of the charter. The committee appointments (via letter) will be presented for Board consideration and approval at an upcoming BOCC meeting. 3. La Pine Special Service District Sewer Loan Revision Management Analyst Sheri Pinner reported on the general obligation bond with the La Pine Special Sewer District that was later assumed by the City of La Pine in 2012. The City of La Pine has requested that the interest rate to be lowered to match the refinanced bond. The Board expressed support. A document will be presented for the Board's approval. BOCC MEETING SEPTEMBER 23, 2019 PAGE 2 OF 5 4. CDD Code Enforcement Staffing Conversion Request Community Development Department Director Nick Lelack, Management Analyst Sheri Pinner and Administrative Manager Angela Havniear reported on the current code enforcement division staffing. The department is requesting to convert the approved part-time on-call Code Enforcement Specialist position to a permanent full time position to manage the increased caseload. The Board expressed support. DEBONE: Move approval ADAIR: Second VOTE: DEBONE: ADAIR: HENDERSON: Yes Yes Chair votes yes. Motion Carried 5. 2019 Legislative Session Text Amendments Nicole Mardell presented the proposed text amendments and explained the housekeeping items. Ms. Mardell reviewed house bills that Deschutes County is required to adopt relative to House Bills 2225, 2435, 2844 and 3024. Ms. Mardell reported on permissive and voluntary amendments that the Board may choose to adopt. The Board supported text amendments regarding House Bill 2469 and second dwellings on properties in Forest Use Zones similar to the family farm help dwelling currently allowed in the EFU Zone. Regarding House Bill 2790 and outdoor mass gatherings, Mr. Lelack will provide additional information to the Board for review. Two senate bills regarding breweries and cider businesses were also presented. BOCC MEETING SEPTEMBER 23, 2019 PAGE 3 OF 5 RECESS: At the time of 3:07 p.m. the Board took a recess and reconvened the meeting at 3:15 p.m. COMMISSIONER UPDATES: • Commissioner Henderson went to Sunriver La Pine Economic Development meeting on Thursday • Commissioner Henderson asked for an update from CDD for the affordable housing options and proposed developments. • Commissioner Adair met with Chief Justice Walters on Thursday and is meeting with Representative Helt tomorrow. She is also working on communications regarding cattle prices. She met with the Sisters Ranger Station regarding the Community Wildfire Protection Plan. • Commissioner DeBone reported the La Pine Community Wildfire Protection Plan process starts soon. • Commissioner DeBone will meet on October 8 for the Governor's Wildfire Council and Regional Solution Committee. He also attended the Central Oregon Recover event in Redmond last week. He is also traveling to Baker City for the Eastern Oregon Counties Association meeting tomorrow. EXECUTIVE SESSION: At the time of 3:38 p.m. the Board went into Executive Session under ORS 192.660 (2) (e) Real Property. The Board came out of Executive Session at 4:08 p.m. At the time of 4:08 p.m., the Board went into Executive Session under ORS 192.660 (2) (d) Labor Negotiations. The Board came out of Executive Session at 4:26 p.m. At the time of 4:26 p.m. the Board went into Executive Session under ORS 192.660 (2) (h) Litigation. The Board came out of Executive Session at 4:32 p.m. BOCC MEETING SEPTEMBER 23, 2019 PAGE 4 OF 5 OTHER ITEMS: Community Development Department and Legal staff have been working on a proposed response to OLCC regarding licensing impacts, if any, due to the recent county marijuana opt out ordinance. OLCC/DOJ staff have requested some form of clarification from Deschutes County. A draft letter was presented for review. Mr. Smith suggested three options for the Board to consider: do nothing, amend the ordinance to provide greater clarity, or send a letter clearly articulating the Board's intent as to the impact/reach of the Opt Out. Mr. Smith feels the letter will be sufficient. The Board expressed support of the letter. Mr. Smith will notify OLCC that a letter will be forthcoming. �`` x # e gal val Being no further items to come before the Board, the meeting was adjourned at 4:54 p.m. DATED this Day of C/i 2019 for the Deschutes County Board of Commissioners. ATTEST: T a i`}.i.,f �� II■ M1 i.. ��. '."E ...., , i .fir., tom.' PHILIP ERS , CHAIR r PATTI A AI , VICE CHAIR sp I dr --,/- 1 t ,, V # . i * 1 DE%ONE, ... . Y E I S S I O kS ' t't. BOCC MEETING SEPTEMBER 23, 2019 PAGE 5 OF 5 BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:00 PM, MONDAY, SEPTEMBER 23, 2019 Allen Conference Room - Deschutes Services Building, 2ND Floor - 1300 NW Wall Street - Bend This meeting is open to the public, and allows the Board to gather information and give direction to staff. Public comment is not normally accepted. Written minutes are taken for the record Pursuant to ORS 192.640, this agenda includes a list of the main topics that are anticipated to be considered or discussed. This notice does not limit the Boards ability to address other topics. 'Meetings are subject to cancellation without notice. CALL TO ORDER ACTION ITEMS 1:00 PM 2. 1:20 PM 3. 1:50 PM 4. 2:05 PM 5. 2:20 PM Item start times are estimated and subject to change without notice. Monthly Treasury and Finance Report - Greg Munn, Finance Director Continued: Wildfire Mitigation Advisory Committee Appointments, Finalize Charter - Nick Lelack, Community Development Director La Pine Special Service District Sewer Loan Revision - Nick Lelack, Community Development Director CDD Code Enforcement Staffing Conversion Request - Nick Lelack, Community Development Director 2019 Legislative Session Text Amendments - Nicole Mardell, Associate Planner COMMISSIONER'S UPDATES Board of Commissioners BOCC Meeting Agenda Monday, September 23, 2019 Page 1 of 2 EXECUTIVE SESSION 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. Executive Session under ORS 192.660 (2) (e) Real Property Negotiations and ORS 192.660 (2) (h) Litigation SH.T4- i i-4LIF, l;� 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. ADJOURN ®ru ® Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need 011 accommodations to make participation possible, please call (541) 617-4747. FUTURE MEETINGS: Additional meeting dates available at www.deschutes.org/meetingcalendar Meeting dates and times are subject to change. If you have questions, please call (541) 388-6572. Board of Commissioners BOCC Meeting Agenda Monday, September 23, 2019 Page 2 of 2 ES CC1 =4. 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 BOCC Monday Meeting of September 23, 2019 DATE: September 19, 2019 FROM: Greg Munn, Finance, 541-388-6559 TITLE OF AGENDA ITEM: Monthly Treasury and Finance Report DATE: September 18, 2019 TO: Board of County Commissioners FROM: Greg Munn, Chief Financial Officer SUBJECT: Treasury and Finance Report Following is the monthly finance report as of fiscal year to date August 31, 2019 (unaudited). Treasury and Investments • The portfolio balance at the end of August was $181,567,383. This is a decrease of $3M (1.6%) from last month but an increase of $19.6M (12%) from a year ago. • Net investment income for the month is $358,368 which is $119,891 greater than August 2018 but $22,218 less than last month. • All portfolio category balances are within maximums. • Average portfolio yield for the month is 2.50% - no change from the prior month. • The Local Government Investment Pool rate decreased from 2.75% to 2.6% on August 9. The pool balance limit was increased from $49.5M to $50.4M on August 31. • The weighted average time to maturity is 0.67 which approximates the level over the last several months. PortfolioTotal Investment Aug -18 $ 238,477 $ 475,168 Category Maximums: Yield Percentages U.S. Treasuries 100% 1 Current Month Prior Month Investment Income 100% c ® I Investments By County Function Fisoal Year 2018.19 Municipal Debt $ 14,710,000727.30% Aug-19 Y -T -D Corporate Notes 41,165,000 General $ 181,567,383 $ 377,229 $ 777,179 Time Certificates - Municipal Debt U. S. Treasuries 10,000,000 Benchmarks - - Federal Agencies 60,509,000 1.50% Weighted Ave Maturity LGIP 49,571,638 Total Investments $ 181 567,383 First Interstate Bank 5,611,745 3.08% Total Investment Income 377,229 777,179 Total Investments $ 181,667,383 100.00% Less Fee: 5% of Ingest. Income 18 861 (38,859) 0 to `30 Days 10.00% ! 34.41% Investment Income -Not $ 368,368 $ _ 738,320 Total Portfolio: By Investment Types First Interstate Bank NLnicipal Debt 3.1% 8.1% LGIP Corporate 27.3% ¢� �Ta`', u 22.7% y �IZr r. @, Tine Certiricales 0.0% U. S. Federal Treasuries Agencies 5.5% 33.3% Prior Year Comparison Aug -18 $ 238,477 $ 475,168 Category Maximums: Yield Percentages U.S. Treasuries 100% 1 Current Month Prior Month LGIP ($48,333,000) 100% c ® I Federal Agencies 78% Banker's Acceptances 261/6 Time Certificates 60% Municipal Debt 261/6 Benchmarks Corporate Debt 25%1 • 1.50% Weighted Ave Maturity 36 Max 3.8 Years Term Minimum Actual 0 to `30 Days 10.00% ! 34.41% Under 1 Year 26.00% 72.14% Under 5 Years 100.00% - 100.00% Other PolicyActual Corp Issuer 5.00% = 2.20% Callable 25.00% 13.97% Credit W/A AA2 AA1 Deschutes County Investments Portfolio Management Portfolio Details - Investments August31,2019 Purchase Maturity Days To Ratings Coupon Par Market Book Call Inv# w' Inv Tyr CUSIP r Security Broker' Data Data -I Matur.. Moor :'S&PIRI . Rab - YTM 3 - Value Value Value _ Data °10645 MUN 798189PB6 SAN JOSE EVERGREEN COMM PJ 6/5/2018 9/1/2019 0 Aal AA+ 2.657 2.659 500,000 500,000 500,000 - - 10544 MCI 06406HCW7 Bank of New York Mellon Corp CASTLE 11/3/2016 9/11/2019 10 Al A 2.300 1.532 1,675,000 1,674,983 1,675,000 - - 10641 AFD 88059E4H4 Tennessee Valley Authority CASTLE 5/212018 9/15/2019 14 2.422 2.555 1,020,000 1,019,225 1,019,039 - - 10596 MCI 48125LRG9 JPMorgan Chase - Corporate N CASTLE 6/28/2017 9/23/2019 22 Aa2 A+ 1.650 1.840 1,300,000 1,299,610 1,300,000 - - 10678 FAC 317705AP6 FICO Stip CASTLE 12/20/2018 9/26/2019 25 Asa 8.600 2.709 2,800,000 2,812,740 2,811,243 - - 10485 AFD 313586RC5 Federal National Mtg Assn CASTLE 1214/2015 10/9/2019 38 AA 1.891 2.031 1,400,000 1,397,032 1,397,206 - - 10507 AFD 313586RC5 Federal National Mtg Assn CASTLE 3/17/2016 10/9/2019 38 AA 1.665 1.774 600,000 598,728 598,946 - - 10529 AFD 313586RC5 Federal National Mtg Assn CASTLE 8/8/2016 10/9/2019 38 AA 1.252 1.318 400,000 399,152 399,471 - - 10614 AFD 313586RC5 Federal National Mtg Assn CASTLE 11/22/2017 10/9/2019 38 AA 1.928 2.030 3,600,000 3,592,368 3,592,673 - - 10605 AFD 76116FAA5 RFSCP STRIP PRIN CASTLE 9/21/2017 10/15/2019 44 1.499 1.572 1,000,000 997,520 998,168 - - 10649 AFD 76116FAAS RFSCP STRIP PRIN CASTLE 7/19/2018 10/15/2019 44 2.506 2.636 1,000,000 997,520 996,937 - - 10651 AFD 76116FAAS RFSCP STRIP PRIN CASTLE 9/12/2018 10/15/2019 44 2.560 2.688 2,000,000 1,995,040 1,993,743 - - 10547 FAC 3135GOR39 Federal National Mtg Assn CASTLE 11/10/2016 10/24/2019 53 Aaa AA+ 1.000 1.173 2,000,000 1,997,060 1,999,502 - - 10662 MCI 90331HML4 US Bancorp CASTLE 11/19/2018 10/28/2019 57 Al AA- 2.125 3.050 1,600,000 1,599,760 1,597,705 9/28/2019 10541 TRC 912828F62 U.S. Treasury CASTLE 10/11/2016 10/31/2019 60 Aaa AA+ 1.500 1.008 2,000,000 1,998,100 2,001,589 - - 10602 MCI 961214BK8 Westpac CASTLE 8/30/2017 11/19/2019 79 Aa3 AA- 4.875 1.826 2,000,000 2,011,560 2,012,886 - - 10697 MCI 66765RBF2 NORTHWEST NATURAL CASTLE 4/25/2019 12/9/2019 99 Al AA- 7.630 2.796 2,000,000 2,026,060 2,025,883 - - 10624 TRC 912828G95 U.S. Treasury PJ 1/16/2018 12/31/2019 121 Aaa 1.625 2.000 2,000,000 1,997,740 1,997,573 - - 10704 AFD 76116EFV7 RFSCP STRIP PRIN CASTLE 6/27/2019 1/15/2020 136 2.222 2.311 1,225,000 1,215,825 1,214,715 - - 10625 MCI 94988J151-7 Wells Fargo Corporate Note CASTLE 1/23/2018 1/15/2020 136 Aa2 A+ 2.400 2.444 3,000,000 3,002,730 2,999,526 - - 10677 FAC 3137EAEE5 Federal Home Loan Mtg Corp CASTLE 12/19/2018 1/17/2020 138 Aaa AA+ 1.500 2.770 1,500,000 1,497,510 1,492,955 - - 10682 FAC 3135GOA78 Federal National Mtg Assn PJ 12/21/2018 1/21/2020 142 Aaa AA, 1.625 2.665 2,000,000 1,997,540 1,992,073 - - 10707 FAC 3136G1C98 Federal National Mtg Assn DA DAV 7/19/2019 2/5/2020 157 Aaa AA+ 1.420 2.080 2,000,000 1,995,900 1,994,406 - - 10679 FAC 3130ACRP1 Federal Home Loan Bank R W B 12/21/2018 2/7/2020 159 Aaa AA- 1.680 2.682 2,000,000 1,997,360 1,991,493 - - 10528 MCI 594918AYO Microsoft Corp CASTLE 8/8/2016 2/12/2020 164 Aaa AAA 1.850 1.298 1,000,000 999,550 1,002,407 1/12/2020 10635 FAC 3133EJDCO Federal Farm Credit Bank CASTLE 3/12/2018 2/20/2020 172 Aaa AA+ 2.150 2.360 925,000 925,009 925,000 - - 10673 MCI 89236TCFO Toyota Mtr Cred - Corp N CASTLE 1211212018 3/12/2020 193 Aa3 AA- 2.150 3.301 2,000,000 2,002,220 1,988,116 - - 10698 FAC 880591EVO Tennessee Valley Authority CASTLE 4/25/2019 3/15/2020 196 Aaa 2.250 2.474 3,000,000 3,004,650 2,996,419 - - 10655 TRC 912828.184 U.S. Treasury DA DAV 9/28/2018 3/31/2020 212 Aaa AA+ 1.375 2.760 2,000,000 1,994,060 1,984,358 - - 10606 MUN 13063CSQ4 California St VINISP 9/21/2017 4/1/2020 213 Aa3 AA- 1.800 1.800 780,000 779,446 780,000 - - 10695 MCI 06051GFN4 Bank of America Corp CASTLE 4/10/2019 4/21/2020 233 A2 A- 2.250 2.674 1,500,000 1,501,365 1,496,017 - - 10639 FAC 3137EAEM7 Federal Home Loan Mtg Corp CASTLE 4/19/2018 4/23/2020 235 Aaa AA+ 2.500 2.511 2,000,000 2,007,700 1,999,859 - - 10688 MCI 037833BE9 Apple Inc CASTLE 1/15/2019 5/6/2020 248 Aal AA+ 2.576 2.546 2,000,000 2,004,280 2,002,392 - - 10650 MCI 961214CP6 Westpac CASTLE 8/21/2018 5/26/2020 268 Aa3 AA- 2.300 3.015 1,000,000 1,001,800 994,904 - - 10597 FAC 3134GBNK4 Federal Home Loan Mtg Corp CASTLE 7/13/2017 5/29/2020 271 Aaa AA+ 1.625 1.671 3,000,000 2,995,290 3,000,000 - - 10664 MUN 736688LD2 Portland Community College PJ 11/27/2018 6/1/2020 274 Aal AA- 3.126 3.126 515,000 519,692 515,000 - - 10690 MCI 740189AL9 Precision Castparts Corp CASTLE 2/19/2019 6/15/2020 288 A2 AA- 2.250 2.800 1,000,000 1,000,240 995,758 5/15/2020 10580 ACB 686053CK3 Oregon School Boards Assoc CASTLE 3/15/2017 6/30/2020 303 Aa2 A+ 2.063 2.149 1,000,000 983,510 982,878 - - 10599 MUN 569203MA7 Salem-Keizer School Distict CASTLE 7/26/2017 6/30/2020 303 Aa2 2.107 1.778 2,310,000 2,313,812 2,316,081 - - 10479 MUN 686053DH9 Oregon School Boards Assoc DA DAV 11/2/2015 6/30/2020 303 Aa2 AA 5.373 2.050 875,000 900,944 897,915 - - 10523 MUN 686053DH9 Oregon School Boards Assoc CASTLE 6/24/2016 6/30/2020 303 Aa2 AA 5.373 1.570 500,000 514,825 515,247 - - 10572 MC1 94974BGM6 Wells Fargo Corporate Note PJ 1/19/2017 7/22/2020 325 A2 A- 2.600 2.350 1,000,000 1,004,830 1,002,127 - - 10691 MCI 94974BGM6 Wells Fargo Corporate Note CASTLE 2/22/2019 7/22/2020 325 A2 A- 2.600 2.940 1,000,000 1,004,830 997,042 - - 10674 FAC 3136G4PC1 Federal National Mtg Assn MORETN 12/13/2018 7/24/2020 327 Aaa AA, 1.750 2.820 1,275,000 1,273,725 1,263,106 10/24/2019 10675 FAC 3136G4NP4 Federal National Mtg Assn MORETN 12/13/2018 7/24/2020 327 Aaa AA, 1.800 2.820 1,000,000 999,060 991,105 10/24/2019 10676 MCI 90331HNW9 US Bank - Corp Note CASTLE 12/18/2018 7/24/2020 327 At AA- 2.533 2.859 1,500,000 1,502,145 1,498,003 6/24/2020 10680 FAC 313OA5Z77 Federal Home Loan Bank MORETN 12/21/2018 7/29/2020 332 Aaa AA, 1.830 2.691 2,000,000 2,001,340 1,984,735 - - 10656 TRC 9128284Y3 U.S. Treasury MORETN 9/28/2018 8/31/2020 365 Aaa AA+ 2.625 2.818 2,000,000 2,016,020 1,996,268 - - 10633 MCI 053015AD5 AUTOMATIC DATA CASTLE 2/26/2018 9/15/2020 380 Aa3 AA 2.250 2.570 2,710,000 2,717,778 2,701,320 8/15/2020 10653 TRC 9128281-65 U.S. Treasury CASTLE 9/17/2018 9/30/2020 395 Aaa AA+ 1.375 2.751 2,000,000 1,991,560 1,971,278 - - 10573 MUN 940093R25 Washington Univ Higher Ed PJ 1/19/2017 10/1/2020 396 Aa3 A+ 5.930 1.970 400,000 416,484 416,467 - - 10629 MC1 45905U7J7 International Bonds for Recons CASTLE 2/9/2018 10/5/2020 400 Aaa AAA 2.000 2.471 2,000,000 2,001,740 1,986,482 - - 10659 MCI 459051.17J7 International Bonds for Recons CASTLE 10/26/2018 10/5/2020 400 Aaa AAA 2.000 3.072 820,000 820,713 809,993 - - 10703 MCI 459051,17J7 International Bonds for Recons CASTLE 6/26/2019 10/5/2020 400 Aaa AAA 2.000 2.000 750,000 750,653 750,000 - - 10657 AFD 76116FAE7 RFSCP STRIP PRIN CASTLE 10/4/2018 10/15/2020 410 2.764 2.951 2,445,000 2,397,323 2,368,033 - - 10548 MUN 492244DV7 Kenn Community College CASTLE 11/15/2016 11/1/2020 427 AA- 2.893 1.800 500,000 506,105 506,126 - - 10689 MUN 544587C30 LOS ANGELES MUNI IMP CASTLE 2/11/2019 11/1/2020 427 AA- 3.146 2.872 2,310,000 2,342,201 2,317,104 - - 10617 FAC 3134GBX56 Federal Home Loan Mtg Corp CASTLE 12/13/2017 11/24/2020 450 Aaa AA+ 2.250 2.172 3,000,000 3,022,020 3,000,000 - - 10712 FAC 3133EHBC6 Federal Farm Credit Bank CASTLE 8/28/2019 12/2/2020 458 Aaa AA- 1.930 1.950 2,725,000 2,724,373 2,724,296 - - 10621 FAC 3134GBJH3 Federal Home Loan Mtg Corp CASTLE 12/27/2017 2/17/2021 535 Aaa AA+ 2.500 1.915 2,000,000 2,005,500 1,999,339 2/17/2020 10687 VR2 89236TEV3 Toyota Mir Cred - Corp N CASTLE 1/9/2019 4/13/2021 590 Aa3 AA- 2.5834 2.95087 2,000,000 2,001,280 1,991,185 - - 10702 VR2 06051GFV6 Bank ofAmenca Corp CASTLE 5/31/2019 4/19/2021 596 Aaa A- 3.7225 3.47863 1,050,000 1,068,963 1,069,010 - - 10706 MUN 801577NR4 SANTA CLARA CNN CALIF FINC CASTLE 7/2/2019 5/1/2021 608 AA+ 2.050 2.263 1,095,000 1,097,245 1,094,701 - - 10700 MCI 06051GEHB Bank of America Corp CASTLE 5/9/2019 5/13/2021 620 A2 A- 5.000 2.700 1,560,000 1,634,802 1,618,971 - - 10609 FAC 3136G4NN9 Federal National Mtg Assn CASTLE 10/18/2017 5/24/2021 631 Aaa AA- 2.000 2.000 1,080,000 1,080,313 1,080,000 11/24/2019 10667 MCI 695114CMB Pacific Corp CASTLE 11/29/2018 6/15/2021 653 Al A+ 3.850 3.350 1,170,000 1,203,099 1,179,937 3/15/2021 10672 MCI 695114CMB Pacific Corp CASTLE 12/6/2018 6/15/2021 653 At A+ 3.850 3.351 830,000 853,481 837,045 3/15/2021 10692 MCI 695114CMB Pacific Corp CASTLE 2/22/2019 6/15/2021 653 At A+ 3.850 2.850 2,000,000 2,056,580 2,030,770 3/15/2021 10708 FAC 3133EKVC7 Federal Farm Credit Bank CASTLE 7/29/2019 7/19/2021 687 Aaa AA+ 1.875 1.875 3,000,000 3,016,620 3,000,000 - - 10705 MUN 797398DK7 SAN DIEGO CNTY CALIF PENSIC CASTLE 7/1/2019 8/15/2021 714 AA2 AAA 5.835 2.000 2,000,000 2,155,280 2,146,071 - - 10711 FAC 3134GT205 Federal Home Loan Mtg Corp CASTLE 8/16/2019 8/19/2021 718 2.000 2.000 3,000,000 2,997,870 3,000,000 2/19/2020 10696 AFD 88059E4M3 Tennessee Valley Authority CASTLE 4/18/2019 9/15/2021 745 2.373 2.536 1,020,000 981,158 969,903 - - 10648 MCI 45905UC36 International Bonds for Recons CASTLE 7/16/2018 9/28/2021 758 Aaa AAA 2.000 2.967 2,000,000 1,941,400 1,962,002 - - 10701 FAC 3134GTEY5 Federal Home Loan Mtg Corp CASTLE 5/17/2019 10/8/2021 768 Aaa AA+ 2.600 2.593 1,494,000 1,494,926 1,494,197 10/8/2019 10654 MCI 695114CPI Pacific Corp CASTLE 9/25/2018 2/1/2022 884 Al A+ 2.950 3.320 700,000 715,050 694,107 11/1/2021 10652 MUN 686053BQI Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 1033 Aa2 AA 5.480 3.120 925,000 1,017,001 982,810 - - 10710 FAC 3130AGUG8 Federal Home Loan Bank CASTLE 8/9/2019 8/5/2022 1069 Aaa AA+ 2.250 2.084 3,000,000 3,001,470 3,002,351 2/5/2020 10709 MUN 2927OCNU5 BonneAlle Power Administratio CASTLE 7/30/2019 7/1/2023 1399 Aal AA- 5.803 2.125 1,000,000 1,150,400 1,134,577 - - 10078 RRP SYS10078 Local Goet Investment Pool 7/1/2006 - - 1 2.750 2.750 49,571,638 49,571,638 49,571,638 - - 10084 RR2 SYS10084 First Interstate 7/1/2006 - - 1 2.750 2.750 5,611,745 5,611,745 5,611,745 - - 181,567,383 182,218,176 181,748,924 • Average corporate and 2 treasury rates continue to decline while the county's average return has been stable due to the LGIP pool rate and yield to maturities on investments owned that were previously purchased during a higher yield environment. Historical Investment Rate of Returns 4.50% 4.00 3.50% 3.00 2.50% 2.00 1.50% 1.00% -- — - -- _ _____._.____.._...._..___.__—.----______.--- June Aug OctDec Feb April June Aug Oct Dec Feb April June August Average County Rate 2 Year Treasury Rate Corporate Bond Rate Budget to Actuals Report On the attached pages you will find the Budget to Actuals Report with actual revenue and expense data compared to budget through August 31, 2019. Room Tax Update Transient room tax collections for FY19 increased by $661,039 (9.5%) over FY18. Collections in FY20 through August are running at 12% more than the same period in FY19. Part of this increase is due to the continued growth in tourism but we believe that part is due to legislation that changed the way room tax is reported and paid to the county. Vacation rental platforms such as Airbnb and VRBO. Vacation stay data and room tax payments are collected by these platforms and submitted to the county whereas previously this was the responsibility of each individual property owner. ,Budget Staff is reviewing options to improve departmental collaboration, process efficiency and information transparency for future budget development cycles. Property Tax Tax season is right around the corner. We are in the process of finalizing tax statements which we've made a few improvements on to improve clarity for the taxpayer and reduce erroneous payments. Audit Staff is working diligently to close out the FY19 books in preparation for the auditors who will be on-site beginning the week of August 23. Position Control Summary July -June Percent Org July August Unfilled Assessor Filled 34.26 34.26 Unfilled 1.00 1.00 2.84% Clerk Filled 8.48 8.48 Unfilled - 0.00% BOPTA Filled 0.52 0.52 Unfilled - - 0.00% DA Filled 49.95 49.95 Unfilled 2.00 2.00 3.85% Tax Filled 4.50 4.50 Unfilled - 0.00% Veterans' Filled 4.00 4.00 Unfilled - 0.00% Property Mngt Filled 1.80 1.80 Unfilled - - 0.00% Total General Fund Filled 103.51 103.51 Unfilled 3.00 3.00 2.82% Justice Court Filled 4.60 4.60 Unfilled - 0.00% Community Justice Filled 46.90 47.20 Unfilled 1.00 0.70 1.77% Sheriff Filled 221.75 221.75 Unfilled 18.75 18.75 7.80% Health Srvcs Filled 284.55 286.65 Unfilled 20.35 18.25 6.33% CDD Filled 53.00 54.00 Unfilled 3.00 2.00 4.46% Road Filled 55.00 55.00 Unfilled 1.00 1.00 1.79% Adult P&P Filled 37.85 38.55 Unfilled 2.00 1.30 4.14% Solid Waste Filled 24.00 24.00 Unfilled 0.50 0.50 2.04% 9-1-1 Filled 55.52 53.53 Unfilled 4.48 6.48 9.13% Victims Assistance Filled 7.00 7.00 Unfilled 1.00 1.00 12.50% GIS Dedicated Filled 1.30 1.30 Unfilled 1.00 1.00 43.48% Fair & Expo Filled 12.00 11.00 Unfilled - 1.00 4.17% Natural Resource Filled 1.00 1.00 Unfilled - - 0.00% ISF - Facilities Filled 19.00 19.00 Unfilled 6.00 6.00 24.00% ISF - Admin Filled 5.75 5.75 Unfilled 1.00 1.00 14.81% ISF - BOCC Filled 3.00 3.00 Unfilled 0.00% ISF - Finance Filled 10.00 10.00 Unfilled - 0.00% ISF - legal Filled 6.00 6.00 Unfilled 1.00 1.00 14.29% ISF - HR Filled 8.00 8.00 Unfilled - - 0.00% ISF - IT Filled 14.70 14.70 Unfilled 1.00 1.00 6.37% ISF - Risk Filled 2.25 2.25 Unfilled 1.00 1.00 30.77% July -lune Percent July August Unfilled Total. Filled 976.68 977.79 Unfilled 66.08 64.98 %Unfilled 6.34% 6.23% 6.28% 0 -!ES C Countywide Summa Countywide - � 16-'% Year Complete All Departments Activity thru August of Fiscal Year 2020 610 - Solid Waste 8,310,720 7,643,635 92% 8,384,039 776,554 9% 8,221,874 98% ; 615 - Fair & Expo 2,688,885 2,789,095 104% ; 2,464,787 466,792 19% ; 2,464,787 100%: 618 - RV Park 521,971 499,108 96% ; 540,373 66,655 12% ; 540,373 100% ; 670 - Risk Management 3,858,097 2,862,764 74% 4,132,295 955,207 23% ; 4,382,059 106% ; 675 - Health Benefits ; 23,144,255 21,211,086 92% 22,115,011 1,859,113 8% ; 22,115,011 100%: 705-911 13,379,064 10,570,113 79% ; 12,250,336 2,094,957 17% ; 11,650,303 95% ; 999- Other 46,792,062 35,262,851 75% ; 57,628,740 6,123,711 11% ; 57,628,740 100%: TOTAL 251,273,671 221,855,956 88% 269,384,377 35,093,841 13% ; 265,048,640 98% REQUIREMENTS Fiscal Year 2019 Fiscal Year 2020 TRANSFERS Budget Actuals % Budget Actuals % Projection % 001 - General Fund (18,077,559) (18,063,039) 100% ; (19,023,310) (2,225,556) 12% ; (19,023,310) 100% ; 030 - Community Justice 5,744,015 5,744,015 100% ; 5,874,465 993,576 17% ; 5,874,465 100% ; 160/170 - TRT (4,649,866) (4,449,866) 96% ; (4,133,128) (527,441) 13% ; (4,133,128) 100%: 220 - Justice Court 30,000 30,000 100% ; - - - 255 - Sheriffs Office 2,981,253 2,981,254 100% ; 3,119,936 565,336 18% ; 3,119,936 100% ; 274 - Health Services 6,177,535 6,179,204 100% ; 6,102,365 957,848 16% ; 6,102,365 100% ; 295 - CDD (1,152,624) (1,170,172) 102%: (1,448,081) - 0% ; (1,448,081) 100%: 325 - Road (14,464,308) (14,464,308) 100%: (11,910,575) - 0% ; ; (11,910,575) 100%: 355 - Adult P&P 165,189 165,189 100%: 223,189 47,530 21% ; 223,189 100%: 465 - Road CIP 13,811,725 13,393,963 97% 12,014,914 - 0% 12,014,914 100%: 610 - Solid Waste (4,688,023) (5,000,029) 107% ; (3,296,192) - 0% ; (3,296,192) 100% ; 615 - Fair & Expo 1,220,994 1,164,996 95% 1,022,863 37,622 4% ; 1,022,863 100% ; 618 - RV Park 160,000 160,000 100% ; (307,000) - 0% (307,000) 100% ; 670 - Risk Management (3,168) (3,168) 100%: (6,918) - 0% (6,918) 100%: 705-911 - - - - - 999- Other 12,744,837 13,331,961 105%: 11,767,472 151,085 1% ; 11,767,472 100% ; TOTALTRANSFERS - - 0%; - - 0% ; - 0% ; vTES C o�� Countywide Summary Year Complete All Departments Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 ENDING FUND BALANCE Budget Actuals % Budget Actuals % Projection % 001 - General Fund 9,265,080 12,388,048 134% ; 9,563,536 8,686,928 11,268,554 118% ; 030 - Community Justice 689,399 1,296,490 188% ; 694,058 1,071,751 1,030,092 148%: 160/170 - TRT 2,261,401 2,565,255 113% ; 3,686,732 4,490,073 4,129,254 112%: 220 - Justice Court 67,919 144,227 212% ; 64,859 125,679 44,086 68% ; 255 - Sheriffs Office ; 13,191,907 16,801,539 127% ; 14,732,933 10,699,955 ; 16,791,286 114% ; 274 - Health Services 3,850,339 11,115,196 289% ; 4,077,752 5,991,841 5,699,282 140% ; 295 - CDD 1,478,676 1,783,536 121% ; 1,151,452 2,115,648 986,180 86% ; 325 - Road 2,416,014 6,702,644 277% ; 2,303,905 8,815,398 4,047,260 176% ; 355 - Adult P&P 2,220,879 2,754,005 124% ; 1,998,976 3,103,030 2,679,500 134%: 465 - Road CIP 14,148,365 17,759,555 126% ; 15,938,430 17,627,987 ; 19,038,583 119% ; 610 - Solid Waste 600,000 799,570 133% ; 644,638 2,313,111 1,101,373 171% ; 615 - Fair $ Expo 31,209 (94,564) -303%; 199,576 (322,655) ; 25,012 13% ; 618 - RV Park 315,629 592,992 188% ; 150,327 694,572 203,569 135% ; 670 - Risk Management 5,308,679 7,193,407 136% ; 5,455,826 6,897,420 6,299,469 115% ; 675 - Health Benefits 14,318,894 16,563,905 116% ; 16,309,716 18,299,463 16,450,894 101% ; 705-911 5,505,949 8,589,816 156% ; 6,066,720 6,288,186 7,502,862 124%: 999- Other ; 58,869,933 75,133,069 128% ; 55,089,130 72,902,691 54,872,276 100% ; TOTAL ; 134,540,271 182,088,689 135% ; 138,128,566 169,801,078 152,169,532 110% ; 3 quTES CO QAC RESOURCES Department -wide Summary 001 - General Fund Grouping Activity thru August of Fiscal Year 2020 Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management TOTALRESOURCES REQUIREMENTS Assessor Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental TOTAL REQUIREMENTS 16.7% Year Complete Fiscal Year 2019 1 823,127 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 27,318,385 27,774,133 102% 29,046,840 - 0% 29,046,840 100% , -1 A 389,000 433,798 112% 391,000 138,778 35% 519,000 133% 128,000! 1 2 685 500 3 272 354 122% 3,020,400 647,992 21% 3,020,400 100% B 870,658 823,127 95%837,283 4,993,290 211,938 25% 1,787,270 1,702,762 95% 1,597,369 371,739 23% 12,700 12,119 95% 12,220 3,300 27% 389,782 386,919 99% 311,215 5,106 2% 198,950 206,292 104% 195,390 51,290 26% 166,423 168,945 102% 166,423 3,000 2% 120,000 120,000 100% 120,000 4,333 4% 33,938,668 34,900,450 103% ; 35,698,140 1,437,477 4% ; Budget Actuals % Budget Actuals % 4,802,452 4,530,558 94% 4,993,290 773,340 15% 1,854,397 1,598,595 86% 2,031,590 207,238 10% 73,125 69,565 95% 77,950 15,793 20% 7,372,932 6,993,244 95% 7,800,568 1,226,870 16% ! ! 173,129 160,296 93% 235,542 14,781 6% ! 872,020 779,330 89% 846,307 125,143 15% ! 572,287 539,026 94% 580,360 83,517 14% ! 287,858 278,966 97% 281,985 48,284 17% ! 1,477,829 1,446,326 98% 1,353,702 240,564 18% ! 17,4862029 16,395,907 94% 18,201,294 2,735,530 15% ; 837,283 100%! C 1,622,369 102%, 25,000! H 12,220 100%! -! C 311,215 100% 278, D 195,390 100%! C 166,423 100%! F 120,000 100%, G 35,851,140 100% ; 153,000; 281,985 100% $ 8,686,928 91% 7T1 -1,268,554 118% $1,705,018: Projection % $ Variance 4,877,077 98% 116,213: D 2,014,094 99% 17,496;'D 77,672 100% : 278, D 7,680,585 98% ! 119,983! D 235,542 100% 12,210,538 110% 12,388,048 112% 1,298,048 846,307 100%! - 580,360 100% (2,225,556) ! (19,023,310) 0 281,985 100% $ 8,686,928 91% 7T1 -1,268,554 118% $1,705,018: 1,353,702 100% 17,947,324 99% 253,970; B PILT payment of $500,000 received in July. Includes $0 of Marijuana tax YTD. TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 326,122 289,065 89% 260,000 0% 260,000 100% E Transfers Out ! (18,403,681) (18,352,104) 100% (19,283,310) (2,225,556) 12% ! (19,283,310) 100% ! TOTALTRANSFERS ; (18,077,559) (18,063,039) 100% ; (19,023,310) (2,225,556) 12% (19,023,310) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 10,890,000 11,946,544 110% 11,090,000 12,210,538 110% 12,388,048 112% 1,298,048 Resources over Requirements ! 16,452,639 18,504,543 17,496,846 (1,298,053) ! 17,903,816 406,970, Net Transfers - In (Out) (18,077,559) (18,063,039) (19,023,310) (2,225,556) ! (19,023,310) 0 TOTAL FUND BALANCE $ 9,265,080 $ 12,388,048 134% $ 9,563,536 $ 8,686,928 91% 7T1 -1,268,554 118% $1,705,018: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Current year taxes received primarily in November, February and May. B PILT payment of $500,000 received in July. Includes $0 of Marijuana tax YTD. C A & T Grant received quarterly. Q1 - July; Q2 - October; Q3 - January; Q4 - April. D Savings related to FTE vacancies YTD and forecasted vacancy rates consistent with YTD experience. E Repayment to General Fund from Finance Reserves for ERP Implementation F Oregon Dept of Veteran's Affairs grant reimbursed quarterly. 6 Interfund land -sale management revenue recorded at year-end. H Recording fees are up 21% through August 2019 compared to the prior year. I TDS Baja deferred billing credits per ORS 305.286 0 C S co "I { FINANCE 4 FTEs Department -wide Summary 030 - Community Justice Grouping Activity thru August of Fiscal Year 2020 16.7% Year Complete Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Quarterly Reimbursement B Out of county juvenile detention housing. Fluctuates in accordance with other county policy/usage. Current YTD trend higher than budgeted. C Budgeted less than FY19 actual due to concerns of state funding source reduction. Quarterly payment yet to be received to confirm. D FY20 higher than FY19 actual due to anticipated grant revenue from youth substance abuse research study. E Payments for community service crew projects. Fluctuates depending on community need/request. Current YTD trend lower than budgeted. F Projected Personnel savings based on FY19 average vacancy rate of 2.1 % `�Vi ES CpG FINANCE 5 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OYA Basic & Diversion 407,113 413,320 102% 442,601 0% 442,601 100% A ODE Juvenile Crime Prev 91,379 92,492 101% 91,379 0% 91,379 100%! A Leases I 85,000 87,311 103% 86,400 14,694 17% 86,400 100% Inmate/Prisoner Housing 70,000 97,200 139% 80,000 19,950 25% 80,000 100% B DOC Unif Crime Fee/HB2712 35,000 43,681 125% 35,000 0% 35,000 100%! C Interest on Investments I 25,000 31,318 125% 31,000 5,551 18% 31,000 100% OJD Court Fac/Sec SB 1065 I 17,000 27,158 160% 26,000 3,703 14% 26,000 100% Gen Fund -Crime Prevention 20,000 20,000 100% 20,000 . 0% 20,000 100%! A Food Subsidy 18,744 12,052 64% 16,000 1,775 11% 16,000 100% Miscellaneous ! 2,050 4,603 225% 142050 1,592 11% 14,050 100%! D Contract Payments 8,000 7,269 91% 8,000 240 3% 8,000 100%! E Case Supervision Fee ! 7,000 6,081 87% 6,500 1,200 18% 6,500 100% TOTALRESOURCES 786,286 842,485 107% ; 856,930 48,705 6% 856,930 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,705,245 5,412,349 95% 5,797,927 938,331 16% 5,668,383 98% 129,544, F Materials and Services 1,327,658 1,218,976 92% 1,329,410 181,430 14% 1,329,410 100% 2 Capital Outlay ! 8,000 7,566 95% - - TOTAL REQUIREMENTS 7,040,903 6,638,892 94% 7,127,337 1,119,762 16% ; 6,997,793 98% 129,544; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 5,831,015 5,831,015 100% 5,961,465 993,576 17% 5,961,465 100% Transfers Out-Veh Reserve (87,000) (87,000) 100% (87,000) - 0% (87,000) 100% TOTALTRANSFERS 5,744,015 5,744,015 100% ; 5,874,465 993,576 17% 5,874,465 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,200,000 1,348,881 112% 1,090,000 1,149,231 105% 1,296,490 119% 206,490: Resources over Requirements (6,254,617) (5,796,407) (6,270,407) (1,071,057) (6,140,863) 129,544 Net Transfers - In (Out) 5,744,015 ! 5,744,015 k 5,874,465 993,576 ! 5,874,465 I I 0 I TOTAL FUND BALANCE $ 689,399 $ 1,296,490 188% $ 694,058 $ 1,071,751 154% $ 1,030,092 148%, $336,034, Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Quarterly Reimbursement B Out of county juvenile detention housing. Fluctuates in accordance with other county policy/usage. Current YTD trend higher than budgeted. C Budgeted less than FY19 actual due to concerns of state funding source reduction. Quarterly payment yet to be received to confirm. D FY20 higher than FY19 actual due to anticipated grant revenue from youth substance abuse research study. E Payments for community service crew projects. Fluctuates depending on community need/request. Current YTD trend lower than budgeted. F Projected Personnel savings based on FY19 average vacancy rate of 2.1 % `�Vi ES CpG FINANCE 5 �,�uTES:��G q 2� Department -wide Summary 16.7% Year Complete 160/170 - TRT Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 7,260,000 7,618,179 105% 7,670,000 2,721,338 35% 7,961,471 104% 291,471: A Interest I 22,600 64,444 285% 62,000 14,016 23% 34,000 55% (28,000) B TOTALRESOURCES 7,282,600 7,682,623 105% ; 7,732,000 2,735,355 35% 7,995,471 103% ; 263,471; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 1,946,668 2,067,761 106% 2,064,221 268,234 13% 2,150,425 104% (86,204) C Interfund Contract I 59,121 59,121 100% 79,160 13,193 17% 79,160 100% D Interfund Charges 39,087 39,087 100% 37,309 6,218 17% 37,309 100% Auditing Services 12,501 10,800 86% 14,500 0% 14,500 100% Software I 60,000 51,533 86% 10,350 4,200 41% 10,350 100% Office Supplies 4,000 1,589 40% I 3,000 84 3% I 3,000 100% I i i Printing 2,200 209 9% 2,000 - 0% 2,000 100%I Public Notices 3,101 1,834 59% 1,600 308 19% f 1,600 100% I 1 i 1 Sunriver Service Dist 200,000 I . 0% - - - - I Temporary Help 9,000 2,020 22% - TOTAL REQUIREMENTS 2,335,678 2,233,953 96% 2,212,140 292,238 13% ; 2,298,344 104%; (86,204); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (35,000) 0% (35,000) 100% Transfer Out - Annual Fair (150,000) (150,000) 100% (250,000) - 0% (250,000) 100% Transfer Out - F&E Reserve 1 (830,083) (630,083) 76% (286,687) 0% (286,687) 100% Transfer Out - F&E (517,996) (517,996) 100% (409,654) (2,145) 1% (409,654) 100%; - Transfer Out - Sheriff I (3,151,787) (3,151,787) 100% (3,151,787) (525,296) 17% (3,151,787) 100% TOTALTRANSFERS (4,649,866) (4,449,866) 96% (4,133,128) (527,441) 13% (4,133,128) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,964,345 1,566,452 80% 2,300,000 2,574,397 112% 2,565,255 112% 265,255, Resources over Requirements 4,946,922 5,448,669 5,519,860 2,443,117 5,6979127 177,267. Net Transfers - In (Out) t (4,649,866) (4,449,866) I (4,133,128) (527,441) 1 (4,133,128) F I 0 I TOTAL FUND BALANCE $ 2,261,401 $ 2,565,255 113% $ 3,686,732 $ 4,490,073 122% $ 4,129,254 112%, $442,522: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Prior year collections YTD was 33% of budget, compared to current year collections YTD of 35%. B Includes interest payments from delinquent tax collections. C COVA is estimated to receive -27.5% of TRT revenue above budgeted amounts D Contracted services with the Finance Department for operating TRT program. a 2a FINANCE 6 �viES Co 2{ Department -wide Summary O 16.7/0 Year Complete 220 - Justice Court Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 550,000 605,344 110% 575,000 100,637 18% 575,000 100% Interest on Investments E 2,000 2,931 147% 3,000 490 16% 3,000 100% TOTAL RESOURCES 552,000 608,275 110% ; 578,000 101,127 17% 578,000 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 508,650 508,098 100% 516,868 88,993 17% 516,868 100% Materials and Services E 149,431 143,941 96% 161,273 30,681 19% 161,273 100% A TOTAL REQUIREMENTS 658,081 652,039 99% 678,141 119,674 18% 678,141 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 30,000 30,000 100% TOTALTRANSFERS 30,000 30,000 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 144,000 157,990 110% 165,000 144,227 87% 144,227 87% (20,773) Resources over Requirements (106,081) (43,764) (100,141) (18,547) (100,141) 0 Net Transfers - In (Out) 30,000 30,000 - - 0' TOTAL FUND BALANCE $ 67,919 $ 144,227 212% $ 64,859 $ 125,679 194%, $ 44,086 68% ($20,773): Note: Beginning Fund Balance projection reflects FYI Ending Working Capital A Annual software maintenance costs paid upfront in fiscal year. y`�3iEs COGS FINANCE vi ES C q`� ; Department -wide Summary 255 - Sheriff's Office Grouping Activity thru August of Fiscal Year 2020 16.7% Year Complete REQUIREMENTS Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Crisis Stabilization Center Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS Budget Actuals % Budget Actuals % 3,636,550 Fiscal Year 2019 1 100% 3,740,851 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance LED #1 Property Tax Current 24,780,245 25,153,487 102% 26,293,470 - 0%26,293,470 100% LED #2 Property Tax Current 10,027,098 10,171,051 101% 10,632,014 - 0% 10,632,014 100% - Sheriffs Office Revenues 3,675,026 4,136,329 113% 3,730,596 595,836 16% 3,730,596 100% - LED #1 Property Tax Prior 312,000 326,275 105% 312,000 114,567 37% 312,000 100% LED #2 Property Tax Prior 166,500 157,143 94% 148,000 48,199 33% 148,000 100% LED #1 Interest k 145,000 288,269 199% 138,000 34,421 25% 138,000 100% LED #2 Interest k 120,000 193,301 161% 136,000 25,872 19% 136,000 100% LED #1 Foreclosed Properties - 53,322 k - - i i i k k LED #2 Foreclosed Properties - 21,561 - - 1,070,404 105% TOTALRESOURCES 39,225,869 40,500,738 103% ; 41,390,080 818,895 2% ; 41,390,080 100% ; REQUIREMENTS Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Crisis Stabilization Center Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS Budget Actuals % Budget Actuals % 3,636,550 3,654,560 100% 3,740,851 571,483 15% i 543,129 563,801 104% 596,364 108,218 18% i 2,644,785 2,532,545 96% 2,858,337 302,584 11% i 2,033,077 2,044,686 101% 2,132,319 351,142 16% k 10,003,952 10,040,921 100% 10,592,002 2,104,642 20% k 881,182 892,837 101% 1,004,600 135,143 13% i 18,357,098 17,364,464 95% 18,359,024 2,856,982 16% 551,494 531,409 96% 556,740 82,204 15% 328,581 341,586 104% 402,734 58,495 15% 1,520,623 1,451,124 95% 1,601,871 288,662 18% k 667,647 874,923 131% 743,334 146,299 20% i 559,308 82,308 15% 571,267 14,045 2% 1,017,266 1,070,404 105% 1,330,214 185,966 14% i 108,329 108,329 100% 4,425 738 17% 42,853,022 41,553,897 97% 44,494,082 7,206,603 16% ; TRANSFERS Budget Actuals % Budget Actuals % Transfer In - TRT 3,151,787 3,151,787 100% 3,151,787 525,296 17% Transfer In - General Fund 103,132 103,132 100% 240,249 40,040 17% Transfers Out - Debt Service ' (273,666) (273,666) 100% (272,100) - 0% TOTALTRANSFERS 2,981,253 2,981,254 100% ; 3,119,936 565,336 18% ; FUND BALANCE Budget Actuals % Budget Actuals % Beginning Fund Balance 13,837,807 14,873,445 107% 14,716,999 16,522,328 112%, Resources over Requirements (3,627,153) (1,053,160) (3,104,002) (6,387,709) Net Transfers - In (Out) 2,981,253 i 2,981,254 t k 3,119,936 565,336 4 TOTAL FUND BALANCE $ 13,191,907 $ 16,801,539 127% $ 14,732,933 $ 10,699,955 73% Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital Projection % $ Variance 3,710,395 99% i � 30,456: A k 596,364 100% 2,933,232 103% (74,895); 2,292,066 107% (159,747); 10,667,101 101% (75,099); 932,164 93% � 72,436 k k 18,041,905 98% � 317,119! i 504,993 91% 51,747!k 448,267 111% (45,533); 1,793,087 112% (191,216); 870,494 117% (127,160); 581,067 102% (9,800); 1,154,708 87% 175,506, 4,425 100% 44,530,268 100% ; (36,186); Projection % $ Variance 3,151,787 100% 240,249 100% (272,100) 100% 3,119,936 100% ; Projection % $ Variance 16,811,538 114% 2,094,539 (3,140,188) (36,186); 3,119,936 0 $ 16,791,286 114% $2,058,353 A August variances in all Divisions are from projections based on YTD personnel and positions that are unfilled or over -filled X01 ES C0 FINANCE 8 �v'CES CO Department -wide Summary O 16•'% Year Complete 274 - Health Services Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 13,262,344 13,215,044 100% 13,061,070 83,901 1% 11,765,698 90% (1,295,372); OHP Capitation 8,652,200 8,142,094 94% 11,569,756 1,281,490 11% 7,242,431 63% (4,327,325); CCBHC Grant d 5,406,848 4,884,430 90% 2,330,991 - 0% 2,330,991 100% Environmental Health Fees d 1,169,600 1,076,036 92% 1,058,205 49,995 5% 1,113,779 105%, 55,574 State Miscellaneous d 899,734 1,808,299 201% 1,040,153 110 0% 1,040,153 100% - State - OMAP d 1,147,168 1,108,622 97% 991,900 137,721 14% 991,900 100% Local Grants d 1,208,623 1,259,178 104% 985,900 338,432 34% 985,900 100% - Federal Grants d 990,189 1,311,567 132% 946,625 - 0% 946,625 100% Patient Fees d 236,500 637,910 270% 564,750 117,953 21% 664,750 118% 100,000! Title 19 1,345,100 3,069,162 228% 535,400 655,764 122% 4,243,579 793% 3,708,179! Other i 343,545 398,786 116% 353,015 74,678 21% 353,015 100% Vital Records d 212,000 241,727 114% 220,000 39,438 18% 220,000 100% Divorce Filing Fees 157,603 157,603 100% 173,030 173,030 100% 173,030 100% Interest on Investments d 135,000 218,767 162% 171,000 42,406 25% 171,000 100% Liquor Revenue 151,000 166,372 110% 150,800 - 0% 150,800 100% Interfund Contract- Gen Fund d 127,000 127,000 100% 127,000 0% 127,000 100% State Shared- Family Planning 168,007 120,000 45,709 38% 120,000 100% TOTALRESOURCES 35,444,454 37,990,604 107% ; 34,399,595 3,040,626 9% ; 32,640,651 95% (1,758,944); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation - - - 0% - 0% - Personnel Services 31,702,065 29,780,257 94% 32,618,625 5,209,415 16% 31,841,157 98% 777,468! Materials and Services d 13,033,299 12,372,877 95% 13,342,146 1,058,277 8% 12,042,146 90% 1,300,000: Capital Outlay d 239,000 206,031 86% 345,000 - 0% 345,000 100% TOTAL REQUIREMENTS 44,974,364 42,359,164 94% 46,305,771 6,267,692 14% ; 44,228,303 96% 2,077,468; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 6,366,223 6,367,892 100% 5,747,090 957,848 17% 5,747,090 100% Transfers In- OHP Mental Health 548,601 - 0% 548,601 100% Transfers Out d (188,688) (188,688) 100% (193,326) - 0% (193,326) 100% TOTALTRANSFERS 6,1772535 6,179,204 100% ; 6,102,365 957,848 16% 6,102,365 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,202,714 9,304,552 129%, 9,881,563 8,261,059 84% 11,184,569 113% 1,303,006: Resources over Requirements (9,529,910) (4,368,561) (11,906,176) (3,227,065) (11,587,652) 318,524! Net Transfers - In (Out) 6,177,535 d 6,179,204 d 6,102,365 957,848 F 6,102,365 4 I 0! I TOTAL FUND BALANCE $ 3,850,339 $ 11,115,196 289% $ 4,077,752 $ 5,991,841 147% $ 5,699,282 140% $1,621,530; ES c,O &� FINANCE Zle N vtES Department -wide Summary 274 - Health Services - Admin Grouping Activity thru August of Fiscal Year 2020 16.7% Year Complete REQUIREMENTS Fiscal Year 2019 1 % Budget Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance CCBHC Grant 946,400 876,190 93% 670,365 I 4,600,091 0% 670,365 100% Interest on Investments I 135,000 218,767 162% 171,000 42,406 25% 171,000 100% - Federal Grants ! 108,940 303,065 278% 56,292 0% 56,292 100% - Other 9,000 16,192 180% 9,000 3,836 43% 9,000 100% -E TOTALRESOURCES 1,199,340 1,414,215 118% ; 906,657 46,242 5% 906,657 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,067,132 4,946,052 98% 5,241,272 848,092 16% 5,225,722 100% 15,550, A Materials and Services I 4,600,091 4,671,464 102% 4,952,469 717,498 14% 4,952,469 100% Capital Outlay 5,000 - 0% 5,000 0% 5,000 100% Administration Allocation (8,327,487) (8,295,196) 100% (9,289,585) 0% (9,289,585) 100% TOTAL REQUIREMENTS 1,344,736 1,322,320 98% ; 909,156 1,565,591 172% ; 893,606 98% 15,550; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund - 40,000 6,667 17% 40,000 100% Transfers Out (188,688) (188,688) 100% (193,326) 0% (193,326) 100% TOTALTRANSFERS (188,688) (188,688) 100% ; (153,326) 6,667 -4% (153,326) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,6425514 2,862,108 108% 23660,832 2,224,475 84% 3,011,696 113% 350,864 Resources over Requirements (145,396) 91,895 (2,499) (1,519,349) 13,051 15,550; Net Transfers - In (Out) (188,688) E (1883688) ! (153,326) 6,667 a d (153,326) E I 0 I TOTAL FUND BALANCE $ 2,308,430 $ 2,765,315 120% $ 2,505,007 $ 711,793 28% 7-$72-,871,421 115% $366,413, Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Projected Personnel savings based on experienced vacancy rate in FY19 '31Es coG�-, FINANCE 10 TES CSG 16.7% 2� Department -wide Summary Year Complete 274 - Health Services - Behavioral Health Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OHP Capitation 8,652,200 8,142,094 94% 11,569,756 1,281,490 11% 7,242,431 63% (4,327,325); A State Grant k 10,187,361 9,932,546 97% 10,391,838 4,901 0% 9,036,264 87% (1,355,574) B CCBHC Grant k 4,381,400 3,929,191 90% 1,660,626 - 0% 1,660,626 100% Title 19 k 1,345,100 3,069,162 228% 535,400 655,764 122% 4,243,579 793% 3,708,179, A Federal Grants k 499,249 639,680 128% 508,333 - 0% 508,333 100% Patient Fees 236,500 515,196 218% 443,450 90,572 20% 543,450 123%, 100,000, A State Miscellaneous 351,200 995,622 283% 437,100 - 0% 437,100 100% Local Grants k 412,987 424,012 103% 412,900 5,000 1% 412,900 100% Other k 334,545 346,812 104% 342,655 60,412 18% 342,655 100% Divorce Filing Fees 157,603 157,603 100% 173,030 173,030 100% 173,030 100% Liquor Revenue 151,000 166,372 110% 150,800 - 0% 150,800 100% State - OMAP i 131,900 270,591 205% 131,900 45,310 34% 131,900 100% Interfund Contract- Gen Fund 127,000 127,000 100% r 127,000 - 0% 127,000 100%! - TOTALRESOURCES 26,968,045 28,715,882 106% ; 26,884,788 2,316,479 9% ; 25,010,068 93% (1,874,720), REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 6,253,121 6,248,556 100% 6,978,412 - 0% 6,978,412 100%, - Personnel Services k 19,172,838 17,819,840 93% 19,790,950 3,196,896 16% 19,044,581 96% 746,369 C Materials and Services k 6,509,514 5,534,476 85% 6,599,618 192,714 3% 5,299,618 80% 1,300,000! D Capital Outlay 234,000 199,979 85% 340,000 0% 340,000 100%, TOTAL REQUIREMENTS 32,169,473 29,802,851 93% 33,708,980 3,389,609 10% 31,662,611 94% ; 2,046,369; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 2,282,708 2,282,580 100% 1,734,107 289,018 17% 1,734,107 100% Transfers In- OHP Mental Health r 548,601 - 0% 548,601 100% TOTALTRANSFERS 2,282,708 2,282,580 100% ; 2,282,708 289,018 13% 2,282,708 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,976,398 5,628,746 142% 5,883,114 4,918,326 84% 6,658,875 113% 775,761 Resources over Requirements ! (5,201,428) (1,086,969) (6,824,192) (1,073,131) (6,652,543) 171,649, Net Transfers - In (Out) 2,282,708 E 2,282,580 k 2,282,708 289,018 i 2,282,708 1 I 0! i TOTAL FUND BALANCE $ 1,057,678 $ 6,824,357 645% $ 1,341,630 $ 4,134,213 308% 7 $ 2,289,040 171% $947,410: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A The 2019 contract with the Coordinated Care Organization is comprised of a fee-for-service component corresponding to patient visits. Revenue in Patient Fees and Title 19 will be higher than budgeted, and capitation will be lower than budgeted. B Budgeted funds was a pass-through from the Behavioral Health State IGA for residential treatment provides, which will be paid directly during an 18 -month contract. C Projected Personnel savings based on experienced vacancy rate in FY19 D Reduction in Contracted Services related to footnote A } CS ('0G FINANCE 11 Vi ES C Department -wide Summary 274 - Health Services - Public Health Grouping Activity thru August of Fiscal Year 2020 RESOURCES State Grant Environmental Health Fees State - OMAP State Miscellaneous Local Grants Federal Grants Vital Records Patient Fees State Shared- Family Planning Other CCBHC Grant TOTALRESOURCES REQUIREMENTS Administration Allocation Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers In- General Fund TOTALTRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 16.7%O Year Complete Fiscal Year 2019 1 Actuals % Budget Fiscal Year 2020 % Budget Actuals % Budget Actuals % Projection % $ Variance 3,074,983 3,282,497 107% 2,669,232 79,000 3% 2,729,434 102% 60,202: A 1,169,600 1,076,036 92% 1,058,205 49,995 5% 1,113,779 105% 55,574! B 1,015,268 838,031 83% 860,000 92,411 11% 860,000 100% Budget 548,534 812,677 148% 603,053 110 0% 603,053 100% 17% 795,636 835,167 105% 573,000 333,432 58% _ 573,000 100% Actuals % 382,000 368,821 97% 382,000 - 0% 382,000 100% 1,118,258 212,000 241,727 114% 220,000 39,438 18% 220,000 100% 4,083,515 � 4,085,312 � 122,714 121,300 27,381 23% 121,300 100% $ 231,115 $ 1,145,835 496% 168,007 120,000 45,709 38% 120,000 100% - 35,782 f 1,360 10,430 767% 11,000 100%! 9,640 79,048 79,048 100% 7,277,069 7,860,507 108% ; 6,608,150 677,906 10% 6,733,566 102% ; 125,416; Budget Actuals % Budget Actuals % 2,074,366 2,046,640 99% 2,311,173 - 0% 7,462,095 7,014,365 94% 7,586,403 1,164,427 15% 1,923,694 2,166,937 113% 1,790,059 148,065 8% - 6,051 999% 11,460,155 11,233,994 98% 11,687,635 1,312,491 11% ; Budget Actuals % Budget Actuals % 4,083,515 4,085,312 100% 3,972,983 662,163 17% 4,083,515 4,085,312 100% ; 3,972,983 662,163 17% ; Budget Actuals % Budget Actuals % 583,802 813,698 139% = 1,337,617 1,118,258 84% (4,183,086) (3,373,487) k (5,079,485) (634,586) 4,083,515 � 4,085,312 � 3,972,983 662,163 t $ 484,231 $ 1,525,524 315% $ 231,115 $ 1,145,835 496% Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Includes funding from extension of Garrett Lee Smith grant, and a reduction from Ryan White. B Fees were budgeted at an increase of 3%, but were adopted at an 8.5% rate increase C Projected Personnel savings based on experienced vacancy rate in FY19 ES C-0 o" FINANCE 12 Projection % $ Variance 2,311,173 100% 7,570,854 100% 15,550 C 1,790,059 100% 11,672,086 100% ; 15,550; Projection % $ Variance 3,972,983 100% 3,972,983 100% ; Projection % $ Variance 1,513,998 113% 176,382; (4,938,520) 140,966 3,972,983 0! $ 548,461 237% $317,348: Department-wide Summary 16.7% 16•'% Year Complete 295 - CDD Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 114,500 152,827 133% 162,000 25,207 16% 162,000 100% Code Enforcement 664,291 635,453 96% 693,960 128,258 18% 685,915 99% (8,045), A Building Safety 3,312,714 3,075,409 93% 3,433,780 636,932 19% 3,435,450 100% 1,670! Electrical 804,849 738,580 92% 809,500 131,181 16% 809,500 100% Environmental On -Site 782,984 819,608 105% 877,400 208,362 24% 877,400 100% Current Planning 1,795,453 1,701,840 95% 1,807,176 319,825 18% 1,778,525 98% (28,651) A Long Range Planning 678,955 632,170 93% 685,004 133,952 20% 680,171 99% (4,833) A TOTAL RESOURCES 8,153,746 7,755,886 95% 8,468,820 1,583,717 19% 8,428,961 100% ; (39,859); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,477,738 2,386,276 96% 2,575,316 433,183 17% 2,578,083 100% ; (2,767) B Code Enforcement ! 456,162 445,254 98% 481,242 75,281 16% 490,449 102% (9,207) B Building Safety 1,676,037 1,565,140 93% 12665,199 257,901 15% 1,647,490 99% 17,709, C Electrical 445,433 439,104 99% 457,282 73,954 16% 458,985 100% (1,703)! Environmental On -Site ! 612,596 547,203 89% 616,279 85,814 14% 602,342 98% 13,937 C Current Planning 1,554,847 1,456,128 94% 1,501,588 240,992 16% 1,446,501 96% 55,087- C Long Range Planning 503,344 492,687 98% 554,385 84,479 15% 554,385 100%! t TOTAL REQUIREMENTS 7,726,157 7,331,793 95% ; 7,851,291 1,251,604 16% 7,778,236 99% 73,055; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 300,000 289,193 96% 100,000 0% 100,000 100% Transfers Out (79,945) (79,945) 100% (85,695) 0% (85,695) 100% Transfers Out - CDD Reserve ! (1,372,679) (1,379,420) 100% (1,462,386) 0% (1,462,386) 100% TOTALTRANSFERS (1,152,624) (1,170,172) 102% ; (1,448,081) 0% ; (1,448,081) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,203,711 2,529,615 115%, 1,982,004 1,783,536 90% 1,783,536 90% (198,468): Resources over Requirements 427,589 424,093 617,529 332,113 650,725 33,196! Net Transfers - In (Out) (1,152,624) (1,170,172) (1,448,081) - (1,448,081) 0� TOTAL FUND BALANCE $ 1,478,676 $ 1,783,536 121% $ 1,151,452 $ 2,115,648 184% $ 986,180 86% ($165,272) Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Revenue adjustment related to a decrease in the manufactured home valuation factor B Projection increased to include unbudgeted health benefits trust c Overall, projection decreased due to year to date unfilled positions �` ,31 E S cC,G FINANCE t< 13 VIES C- °6_, Department -wide Summary 16•'% o�`�� Year Complete 325 - Road Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Motor Vehicle Revenue 16,234,849 16,726,428 103% 17,609,539 2,638,777 15% 17,609,539 100%, - Federal - PILT Payment 1,900,000 2,153,308 113% 1,510,450 2,271,781 150% 2,271,782 150%, 761,332, A Other Inter -fund Services ! 1,044,353 1,096,023 105% 1,156,581 904 0% 1,156,581 100% Forest Receipts 963,410 801,125 83% 915,000 - 0% 915,000 100% Cities-Bend/Red/Sis/La Pine 635,000 400,849 63% 660,000 2,997 0% 660,000 100% Sale of Equip & Material 365,000 327,920 90% 358,000 2,096 1% 358,000 100% Interest on Investments ! 150,000 220,062 147% 246,000 37,320 15% 246,000 100% - Federal Reimbursements ! 544,000 363,910 67% 181,757 - 0% 181,757 100%! - Mineral Lease Royalties 175,000 69,422 40% 60,000 - 0% 60,000 100%, - Miscellaneous ! 45,000 118,699 264% 57,500 5,772 10% 57,500 100% State Miscellaneous ! 739,811 710,633 96% 20,000 - 0% 20,000 100% Assessment Payments (P&I) 80,000 22,350 28% 11,000 2,640 24% 11,000 100% TOTALRESOURCES 22,876,423 23,010,728 101% ; 22,785,827 4,962,288 22% 23,547,159 103% ; 761,332; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,595,561 6,246,351 95% 6,447,671 1,052,217 16% 6,166,303 96% 281,368, B Materials and Services ! 8,094,192 5,912,268 73% 8,094,165 1,506,847 19% 8,094,165 100% Capital Outlay ! - - 31,500 - 0% 31,500 100% TOTAL REQUIREMENTS 14,689,753 12,158,619 83% 14,573,336 2,559,064 18% 14,291,968 98% 2819368; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (14,464,308) (14,464,308) 100% (11,910,575) - 0% (11,910,575) 100% TOTALTRANSFERS ; (14,464,308) (14,464,308) 100% ; (11,910,575) 0% ; ; (11,910,575) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 8,693,653 10,314,842 119%, 6,001,989 6,412,174 107% 6,702,644 112% 700,655; Resources over Requirements 8,186,670 10,852,110 8,212,491 2,403,224 9,255,191 1,042,700 Net Transfers - In (Out) (14,464,308) (14,464,308) (11,910,575) - (11,910,575) 0; TOTAL FUND BALANCE $ 2,416,014 $ 6,702,644 277%, $ 2,303,905 $ 8,815,398 383% 7 $ 4,047,260 176%, $1,743,355: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A PILT payment received in July. Exceeded amounts as budgeted. 8 Projected Personnel savings based on FYI average vacancy rate of 4.8% `�pY ES CpG FINANCE 14 v'CES C Department -wide Summary 16.7% Year Complete 355 - Adult P&P Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,781,604 4,781,604 100% 4,353,626 1,195,401 27% 4,621,752 10b/o M5,196; A CJC Justice Reinvestment 844,831 853,831 101% 712,530 - 0% 774,281 109% 61,751, B DOC Measure 57 233,900 233,900 100% 236,142 - 0% 239,005 101% 2,863! C Probation Supervision Fees 210,000 191,536 91% 160,000 33,774 21% 160,000 100% DOC -Family Sentence Alt 114,683 114,683 100%! 114,682 - 0% 111,873 98% (2,809) D Interest on Investments 40,000 77,778 194% 77,500 12,928 17% 77,500 100% Interfund- Sheriff 50,000 51,034 102% 50,000 9,167 18% 50,000 100% Gen Fund/Crime Prevention 50,000 50,000 100% 50,000 - 0% 50,000 100% State Subsidy 17,000 16,337 96% 16,298 4,084 25% 16,703 102% 405, E Probation Work Crew Fees 4,000 2,800 70% 2,000 440 22% 4 2,000 100% Electronic Monitoring Fee 10,000 84,165 842% 2,000 9,566 478% 15,000 750% 13,000, F Miscellaneous 500 6,102 999% 500 242 48% 500 100% G State Miscellaneous 4,300 - 0% - TOTALRESOURCES 6,360,818 6,463,769 102% ; 5,775,278 1,265,602 22% 6,118,644 106% ; 343,366; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,656,363 4,522,266 97% 4,809,644 775,292 16% 4,636,491 96% 173,153: H Materials and Services 1,828,765 1,686,408 92% 1,764,847 193,883 11% 1,764,847 100% Capital Outlay 20,000 - 0% 15,000 - 0% 15,000 100% TOTAL REQUIREMENTS 6,505,128 6,208,673 95% 6,589,491 969,174 15% ; 6,416,338 97% 173,153; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 47,530 17% 285,189 100% Transfer to Vehicle Maint (120,000) (120,000) 100% (62,000) - 0% (62,000) 100% TOTALTRANSFERS 165,189 165,189 100% ; 223,189 47,530 21% 223,189 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,200,000 2,333,720 106% 2,590,000 2,759,072 107% 2,754,005 106% 164,005: Resources over Requirements (144,310) 255,096 (814,213) 296,428 (297,694) 516,519, Net Transfers - In (Out) 165,189 165,189 223,189 47,530 223,189 0! TOTAL FUND BALANCE $ 2,220,879 $ 2,754,005 124% : $ 1,998,976 $ 3,103,030 155% $ 2,679,500 134% $680,524: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A State Criminal Justice Commission received more funding for dispersal than anticipated at time of budgeting B State Criminal Justice Commission received more funding for dispersal than anticipated at time of budgeting C State Dept of Corrections received more funding for dispersal than anticipated at time of budgeting D State Dept of Corrections allocated less than anticipated at time of budgeting E State Dept of Corrections received more funding for dispersal than anticipated at time of budgeting F Revenue from prior pretrial EM clients more than anticipated at time of budgeting due to account close-out offer made to clients in June -Aug 2019 G Revenue includes miscellaneous refunds or staff uniform overage fees. YTD trend is higher than anticipated. H Projected Personnel savings based on FY19 average vacancy rate of 3.6% UT E5 c FINANCE 15 �01ES CO 00, Department -wide Summary O 16•'x° Year Complete 465 - Road CIP Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ variance State Miscellaneous 853,104 - 0% 1,944,893 - 0% 1,944,893 100% Interest on Investments 106,000 261,131 246% 198,000 68,884 35% 198,000 100% - TOTALRESOURCES 959,104 261,131 27% 2,142,893 68,884 3% 2,142,893 100%; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ variance Materials and Services 73,153 73,153 100% 71,748 11,958 17% 71,748 100% Capital Outlay { 8,236,348 5,411,213 66% 13,764,165 217,553 2% 12,807,031 93% 957,134 A TOTAL REQUIREMENTS 85309,501 5,484,366 66% 13,835,913 229,511 2% 12,878,779 93% ; 957,134; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ variance Transfers In 13,811,725 13,393,963 97% 12,014,914 - 0% 12,014,914 100% - TOTALTRANSFERS 13,811,725 13,393,963 97% 12,014,914 0% ; 12,014,914 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ variance Beginning Fund Balance 7,687,037 9,588,827 125% 15,616,536 17,788,615 114%, 17,759,555 114% 2,143,019 Resources over Requirements (7,350,397) (5,223,236) (11,693,020) (160,627) (10,735,886) 957,134 Net Transfers - In (Out) 13,811,725 13,393,963 12,014,914 12,014,914 0 TOTAL FUND BALANCE $ 14,148,365 $ 17,759,555 126% : $ 15,938,430 $ 17,627,987 111% 7$ 19,038,583 119%, $3,100,153, Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Construction delays on the NE 17th SUNegus project will push some expenses to FY 21 FINANCE 16 Department -wide Summary 465 - Road CIP - Capital Outlay Summary by Project Activity thru August of Fiscal Year 2020 16.7% Year Complete Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection $ Variance Burgess Road / Day Road Intersection 900,106 658,203 73% Deschutes Market/ Dale Road Intersection 1,500,000 1,285,822 86% Erickson Road Paving 468,544 Old Bend Redmond Highway Phase II 3rd Street Drainage Extension 300,000 112,655 38% US 20 at Tumalo 300,000 1,100,000 367% 300,000 0% E € 300,000 100% Paving Knott Rd 850,286 495,978 58% S. Canal / Helmholtz Way 714,937 141,751 20% 800,000 13,800 2% € 665,726 83% € (134,274); S. Canal - "SIX" Corners 798,699 537,724 67% I 900,000 - 0% 965,562 107% I 65,5621: Six Corners Irrigation Tumalo Road / Tumalo Place 406,879 49,123 12% 1 769,521 0% € 740,579 96% E (28,942) Quail Road Improvements 100,000 100,000 100% i La Pine Guardrail Repair - 40,099 C Avenue: Hwy 97 to 6th St Improvement 180,746 35,351 20% 1 300,000 173,526 58% 1 369,378 123% 1 69,378: Solar Drive Bridge 160,000 70,334 44% Old Bend Rdm/Tumalo Rd Inter 346,426 50,355 15% 625,642 0% € 570,150 91% 1 (55,492); Sisemore Bridge 220,000 100,596 46% € 632,174 5,571 1% ; 636,992 101 % i 4,818: Spring River Bridge Parking Imp 163,776 12,122 12,009 12,009: NE 17TH and Negus 360,000 221 0% € 1,025,472 0% E 180,000 18% i (845,472); Paving Ward Road 339,810 681 0% @ 139,810 678 0% € 696,692 498% 556,882: TSAP 180,746 0% a 180,746 100% Runnel Rd: Loco Rd to Tumalo Rd 275,000 0% = 120,000 44% (155,000); Cascade Lakes Hwy Bike Facilities MP 11,856 11,856 11,856; Fyrear Rd US 20 to Stevens 300,000 0% E 300,000 100 Alfalfa Mkt Rd: Powell Butte Hwy to MP 4 300,000 0% 300,000 100% Bend District Local Roads 558,459 0% 458,459 0% E 0% i (458,459): City of LaPine Local Roads 500,000 0% = 500,000 100% US 97 Bend North Corridor 5,000,000 o% E 5,000,000 100 Tumalo Res Rd: OB Riley to Bailey Rd 247,342 0% 247,342 100% US 20 Ward Rd to Hamby 500,000 0% `• 500,000 100% Transportation System Plan Update 250,000 0% ': 250,000 100% Gribbling Rd Bridge 60,000 0% 60,000 100% Signage Improvements 100,000 0% 100,000 0% 100,000 100% Guardrail Improvements 100,000 0% 100,000 0% 100,000 100% TOTAL CAPITAL OUTLAY $ 8,236,346 $ 5,411,213 66% $ 13,764,165 $ 217,553 2% $ 12,807,031 93%i ($ 957, FINANCE 17 ES °�� Department -wide Summary 16.7% Year Complete 610 - Solid Waste Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Franchise Disposal Fees 6,497,676 6,356,636 98% 6,437,500 1,149,944 18% 6,437,500 100%, Private Disposal Fees 2,709,370 2,379,061 88% 2,419,046 470,706 19% 2,419,046 100% Commercial Disp. Fee 2,042,050 2,060,523 101% 2,252,225 468,558 21% 2,252,225 100% Franchise 3% Fees I 265,000 291,340 110% 265,000 9,585 4% 265,000 100% Yard Debris 216,761 268,830 124% 216,761 68,251 31% 216,761 100%! A Interest 44,000 58,235 132% 59,000 6,499 11% 59,000 100% Miscellaneous 49,955 57,067 114% 48,336 110,744 229% 143,336 297% 95,000! B Special Waste 15,000 21,487 143% 15,000 3,521 23% 15,000 100% Recyclables 18,000 11,063 61% 12,000 2,104 18% 12,000 100% Leases I 10,801 1 0% 1 - 0% 1 100% TOTALRESOURCES 11,868,613 11,504,244 97% 11,724,869 2,289,913 20% 11,819,869 101% ; 95,000; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,504,623 2,331,135 93% 2,538,776 400,177 16% 2,376,611 94% 162,165: C Materials and Services k 4,772,159 4,341,881 91% 4,927,163 364,653 7% 4,927,163 100% Capital Outlay 173,000 109,681 63% 56,000 11,724 21% 56,000 100%! D Debt Service 860,938 860,937 100% 862,100 - 0% 862,100 100%! TOTAL REQUIREMENTS 8,310,720 7,643,635 92% 8,384,039 776,554 9% 8,221,874 98% 162,165; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment Reserve (4,688,023) (55000,029) 107% (3,296,192) 0% (3,296,192) 100% TOTALTRANSFERS (4,688,023) (5,000,029) 107% ; (3,296,192) 0% ; (3,296,192) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,730,130 1,938,991 112% 600,000 799,753 133% 799,570 133%: 199,570: Resources over Requirements 3,557,893 3,860,608 3,340,830 1,513,359 3,597,995 257,165! Net Transfers - In (Out) (4,688,023) (5,000,029) I k (3,296,192) C (3,296,192) I I 0� i TOTAL FUND BALANCE $ 600,000 $ 799,570 133% : $ 644,638 $ 2,313,111 359%, $ 1,101,373 171% $456,735, Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Revenue is seasonal with higher utilization in the summer months B Includes an unbudgeted sale of loader 7-279 for $95K C Projected Personnel savings based on FY19 average vacancy rate of 6.5% D FY19 extended the life of an existing vehicle and did not purchase a second pick-up; FY20 purchased the budgeted gas monitoring equipment FINANCE 18 �uIES C- Department -wide Summary 16.7% 16•' Year Complete 615 - Fair & Expo Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue 655,000 615,300 94% 687,000 110,015 16% 687,000 100%, - Food & Beverage 540,000 629,875 117% 568,000 69,084 12% 568,000 100%! - Rights & Signage 105,000 115,650 110% 120,000 14,300 12% 120,000 100% Storage 83,100 76,735 92% 71,000 - 0% 71,000 100% Horse Stall Rental 57,000 71,855 126% 62,000 - 0% 62,000 100% Interfund Payment 30,000 54,573 182% 30,000 5,000 17% 30,000 100%, A Camping Fee 18,200 19,975 110% 18,000 250 1% 18,000 100% Miscellaneous 8,400 6,374 76% 3,500 734 21% 3,500 100%! - Interest 2,400 (518) -22% 2,000 (774) -39% 2,000 100% TOTAL RESOURCES 1,499,100 1,589,820 106% ; 1,561,500 198,609 13% 1,561,500 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 1,248,512 1,259,337 101% 1,000,199 210,861 21% 1,000,199 100% Personnel Services - F&B 149,296 149,947 100% 157,430 24,396 15% 157,430 100% Materials and Services967,441 912,724 94% 795,788 187,995 24% 795,788 100% Materials and Services - F&B 222,500 365,951 164% 410,570 43,540 11% 410,570 100% Debt Service 101,136 101,136 100% 100,800 0% 100,800 100% TOTAL REQUIREMENTS 2,688,885 2,789,095 104% ; 2,464,787 466,792 19% ; 2,464,787 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 517,996 517,996 100% 409,654 4,290 1% 409,654 100%, Transfers In - County Fair 472,998 417,000 88% 395,000 - 0% 395,000 100% B Transfers In - General Fund 200,000 200,000 100% 200,000 33,332 17% 200,000 100% - Transfers In - Park Fund 30,000 30,000 100% 30,000 - 0% 30,000 100% - Transfers Out - - (11,791) - 0% (11,791) 100% TOTALTRANSFERS 1,220,994 1,164,996 95% 1,022,863 37,622 4% 1,022,863 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance - (60,285) 999% 80,000 (92,094) -115%, (94,564) -118%; (174,564); Resources over Requirements (1,189,785) (1,199,275) (903,287) (268,183) (903,287) 0� Net Transfers - In (Out) t 1,220,994 1,164,996 1,022,863 37,622 1,022,863 0 TOTAL FUND BALANCE $ 31,209 ($94,564) -303%; $ 199,576 ($322,655) -162% 7 $ 25,012 13% ($174,564): Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Reimbursement from RV Park for personnel expenditures recorded in F&E. 8 Net proceeds from the County Fair are recorded in a separate fund and transferred in at year-end. Oy 2{ FINANCE 19 V1 ES C- o`��` °�� Department -wide Summary 16•'° Year Complete 618 - RV Park Grouping Activity thru August of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 340,200 458,331 135% 405,200 165,269 41% 435,400 107% 30,200, A Interest on Investments 4,400 12,255 279% 12,000 2,658 22% 15,950 133% 3,950! Cancellation Fees 4,000 12,497 312% 5,000 3,226 65% 10,000 200% 5,000! RV Park Fees > 30 Days 5,000 11,600 232% 5,000 - 0% 5,000 100% - Washer/Dryer 3,500 4,650 133% 4,000 2,007 50% 2,900 73% (1,100) Vending Machines 1,500 1,716 114% 3,000 1,427 48% 2,200 73% (800); Miscellaneous - 2,231 2,000 689 34% 2,000 100% Good Sam Membership Fee - 2,561 1,500 351 23% 1,500 100%! - Good Sam Discounts - (17,220) 999% - (7,057) 999% (17,000) 999% 1 (17,000) TOTALRESOURCES 358,600 488,620 136% ; 437,700 168,570 39% 457,950 105% ; 20,250; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 298,870 276,007 92% 318,273 66,655 21% 318,273 100% B Debt Service 223,101 223,101 100% 222,100 - 0% 222,100 100% t TOTAL REQUIREMENTS 521,971 499,108 96% 540,373 66,655 12% 540,373 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 0% 160,000 100% Transfers In - TRT Fund - - 35,000 0% 35,000 100% Transfer Out - RV Reserve - - (502,000) 0% (502,000) 100% TOTALTRANSFERS 160,000 160,000 100% ; (307,000) 0% (307,000) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 319,000 443,480 139% 560,000 592,657 106% 592,992 106% 32,992; Resources over Requirements (163,371) (10,488) (102,673) 101,915 (82,423) 20,250, Net Transfers - In (Out) 160,000 160,000 (307,000) - (307,000) 0! TOTAL FUND BALANCE $ 315,629 $ 592,992 188% $ 150,327 $ 694,572 462% 7 $ 203,569 135% $53,242; Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A 4,722 RV spaces, 72% utilization YTD. Prior year comparable was 4,732 RV spaces, 72% utilization YTD. B Advertising in Good Sam paid early in the fiscal year. QyL G� FINANCE 20 01ES C °��A Department -wide Summary 670 - Risk Management Grouping Activity thru August of Fiscal Year 2020 16.7% Year Complete REQUIREMENTS Fiscal Year 2019 Actuals % Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,247,279 1,273,816 102% 1,255,108 218,254 17% 1,255,108 100% - General Liability 1,063,675 1,063,675 100% 1,072,326 175,914 16% 1,072,326 100% ! Property Damage 394,291 394,291 100% 392,923 65,987 17% 392,923 100% Unemployment 280,921 297,540 106% 323,572 144,617 45% 323,572 100% Vehicle 195,250 195,250 100% 195,580 33,834 17% 195,580 100%! - Interest on Investments 85,000 148,890 175% 137,000 27,860 20% 137,000 100% Claims Reimbursement 269,198 57,073 21% 82,000 11,670 14% 82,000 100% - Skid Car Training 32,000 44,910 140% 34,000 1,260 4% 34,000 100% Process Fee- Events/ Parades 1,800 1,575 88% 2,000 315 16% 2,000 100% - Miscellaneous 500 5 1% 500 Projection % 0% 500 100% Loss Prevention 30 30 100% 30 0% 30 100% TOTALRESOURCES 3,569,944 3,477,056 97% 3,495,039 679,711 19% 3,495,039 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,360,000 1,013,256 75% 1,460,000 196,012 13% 1,460,000 100% General Liability 900,000 633,248 70% 1,400,000 150,094 11% 1,400,000 100% Insurance Administration 599,459 529,833 88% 592,059 80,198 14% 592,059 100% Property Damage 728,638 548,796 75% 400,236 493,354 123% 650,000 162% ! (249,764) A Vehicle 120,000 100,150 83% 150,000 35,550 24% 150,000 100% Unemployment 150,000 37,481 25% 130,000 - 0% 130,000 100% TOTAL REQUIREMENTS 3,858,097 2,862,764 74% 4,132,295 955,207 23% 4,382,059 106%; (249,764); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (3,168) (3,168) 100% (6,918) 0% (6,918) 100% - TOTALTRANSFERS (3,168) (3,168) 100% ; (6,918) 0% (6,918) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 5,600,000 6,582,283 118% 6,100,000 7,172,915 118% 7,193,407 118% 1,093,407; Resources over Requirements (288,153) 614,292 (637,256) (275,496) (887,020) (249,764); Net Transfers - In (Out) (3,168) (3,168) (6,918) t (6,918) 0; TOTAL FUND BALANCE $ 5,308,679 $ 7,193,407 136% $ 5,455,826 $ 6,897,420 126% $ 6,299,469 115% $843,643: Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Majority of Fair/Expo roof replacement costs were expected in FY19, but are being incurred in FY20. FINANCE 21 VIES CO Department -wide Summary 675 - Health Benefits Grouping Activity thru August of Fiscal Year 2020 16.7% Year Complete REQUIREMENTS Fiscal Year 2019 Actuals % Fiscal Year 2020 Actuals RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,054,563 18,051,440 106% 17,411,292 2,910,950 17% 17,466,000 100% 54,708: COIC Premiums 1,834,000 1,794,789 98% 1,967,021 272,876 14% 1,800,000 92% (167,021); Retiree / COBRA Premiums 1,280,000 1,144,088 89% 1,433,000 162,197 11% 1,200,000 84% (233,000); Employee Co -Pay 963,000 1,016,748 106% 1,041,120 178,377 17% 1,070,000 103% 28,880 Interest 220,000 366,207 166% 346,000 69,450 20% 346,000 100% Prescription Rebates 60,000 148,847 248% 75,000 - 0% 75,000 100% Claims Reimbursement & Other - 177,557 45,000 750 2% 45,000 100% % TOTALRESOURCES21,411,563 $ Variance 22,699,675 106% ; 22,318,433 3,594,600 16% 22,002,000 99% (316,433); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Health Benefits 19,559,777 17,493,075 89% 18,550,836 1,814,744 10% 18,550,836 100% A Deschutes On -Site Pharmacy 2,284,744 2,514,038 110% 2,242,104 5,782 0% 2,242,104 100% A Deschutes On -Site Clinic 1,114,864 1,045,588 94% 1,141,691 26,823 2% 1,141,691 100% A Wellness 184,870 158,384 86% 180,380 11,764 7% 180,380 100% A TOTAL REQUIREMENTS 23,144,255 21,211,086 92% 22,115,011 1,859,113 8% ; 22,115,011 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 16,051,586 15,075,316 94% 16,106,294 16,563,976 103% 16,5639905 103% 457,611 Resources over Requirements (1,732,692) 1,488,590 203,422 1,735,487 (113,011) (316,433); Net Transfers - In (Out) - F - l - - E - k I 0' TOTAL FUND BALANCE $ 14,318,894 $ 16,563,905 116% $ 16,309,716 $ 18,299,463 112%, $ 16,450,894 101% $141,178; Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Amounts are paid 1 month in arrears; projection compared to historical costs for reasonableness ,)I ES CQG off- 2� FINANCE 22 RESOURCES Department -wide Summary 705 - 911 Grouping Activity thru August of Fiscal Year 2020 Property Taxes - Current Yr Telephone User Tax Police RMS User Fees Interest State Reimbursement Property Taxes - Prior Yr User Fee Data Network Reimbursement Contract Payments Property Taxes - Jefferson Co. Miscellaneous TOTALRESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS Transfers In Transfers Out TOTALTRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 16.7% Year Complete Fiscal Year 2019 1 Actuals % Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ variance 8,311,833 8,426,089 101% 8,809,419 10,570,113 0% 8,809,419 100% 890,000 955,187 107% 900,000 Actuals 0% 900,000 100%! - k 300,680 335,192 111% 250,000 11,591 5% 250,000 100%, - t 200,000 205,570 103% 157,000 30,167 19% 157,000 100%! - 125,000 147,900 118% 125,000 - 0% 125,000 100% - 110,000 108,419 99% 100,000 38,155 38% 100,000 100% - 180,000 141,980 79% 73,680 - 0% 73,680 100% 50,000 106,592 213% 55,000 - 0% 55,000 100% i 51,300 175 0% ! 51,300 - 0% 51,300 100% 30,000 33,453 112% 30,000 272 1% 30,000 100% i 11,200 38,757 346% 11,951 1,638 14% 11,951 100% 10,260,013 10,499,313 102% ; 10,563,350 81,823 1% 10,563,350 100% ; Budget Actuals % Budget Actuals % 7,646,307 3,370,357 2,362,400 6,743,116 3,297,619 529,377 88% 98% 22% 7,462,575 3,387,761 1,400,000 1,206,166 877,209 11,582 16% 26% I 1% 13,379,064 10,570,113 79% ; 12,250,336 2,094,957 17% ; Budget Actuals % Budget Actuals - - - � 2,734,185 (2,734,185) - 0% I 0% Budget Actuals % Budget Actuals % 8,625,000 (3,119,051) 8,660,615 100% (70,800) 7,753,706 (1,686,986) 8,301,320 (2,013,134) 107% $ 5,505,949 $ 8,589,816 156%; $ 6,066,720 $ 6,288,186 104% Note: Beginning Fund Balance projection reflects FY19 Ending Working Capital A Projected Personnel savings based on FY19 average vacancy rate of 9.0% ,31 ES C'0G FINANCE 23 Projection % $ Variance 6,862,542 92% � 600,033; A i I � 3,387,761 100% I I 1,400,000 100% 11,650,303 95% 600,033; Projection % $ Variance � 2,734,185 100% I F (2,734,185) 100% Projection % $ Variance 8,589,815 111% 836,109, (1,086,953) 600,033! _ 0 t t I $ 7,502,862 124% $1,436,142 AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of September 23, 2019 DATE: September 18, 2019 FROM: Nick Lelack, Community Development, 541-385-1708 TITLE OF AGENDA ITEM: Continued: Wildfire Mitigation Advisory Committee Appointments, Finalize Charter BACKGROUND AND POLICY IMPLICATIONS: On September 18, the Board conceptually approved the Draft Wildfire Mitigation Advisory Committee (WMAC) Charter and directed staff to schedule Monday, Sept. 23 to appoint Committee members. FISCAL IMPLICATIONS: None. ATTENDANCE: Nick Lelack, CDD Director; Ed Keith, County Forester. MEMORANDUM DATE: September 18, 2019 TO: Board of County Commissioners FROM: Nick Lelack, CDD Director Ed Keith, County Forester Zechariah Heck, Associate Planner RE: Continued: Wildfire Mitigation Advisory Committee Appointments, Finalize Charter On September 18, the Board conceptually approved the Draft Wildfire Mitigation Advisory Committee (WMAC) Charter and directed staff to schedule Monday, Sept. 23 to appoint Committee members. The purpose of this meeting is to appoint members to the WMAC and approve the Charter as proposed or modified. The column on the right is to provide workspace for Commissioners to select their preferred candidates. I. Applicants Fire/First Responder Representative(s) - Two (2) to four (4) positions Name Agency Board Selections Brett Huet' Consultant Glenn Voelz2 Search and Rescue Volunteer Ken Kehmna Redmond Fire & Rescue Roger Johnson Sisters -Camp Sherman Fire Matt C rus3 Cloverdale Fire Greg Davis State Fire Marshal Gary Marshall Deschutes County Rural Fire #2 Doug Green Bend Fire / Sisters -Camp Sherman Fire Craig Letz4 Consultant Joe Forans BLM (Retired) Brett Huet also applied as an arborist in the "Other" category. 2 Glenn Voelz also applied as a member of the Summit West HOA. 3 Matt Cyrus also applied as a developer, and HOA board member. 4 Craig Letz also applied as a member of the Architectural Review Committee for several HOAs. 5 doe Foran also applied as a Wildland Fuels expert in the "Other" Category. 117 NW Lafayette Avenue, Bend, Oregon 97703 1 P.O. Box 6005, Bend, OR 97708-6005 tom"' (541) 388-6575 @ cdd@deschutes.org @ www.deschutes.org/cd Insurance Representative - One (1) position Name Agency Board Selections Gary Githens Brown & Brown NW Insurance Central Oregon Association of Realtors Farmers Insurance (Former U -Unincorporated Brian Braddock Representative) Board HOA Board Member/ Home Owner Representative(s) - One (1) position Builder/Construction/Real Estate Representative(s) - Two (2) to four (4) positions Name Address Provided Tyler Neese Central Oregon Association of Realtors U -Unincorporated Zoning of Board Name I- Address Provided Selections Rick Hayes Incorporated(City) Address Provided Rory Isbell 6 1(Bend) Residential Multi -Family Susan Altman? U (Bend) Exclusive Farm Use Stephen Gardner I (Bend) Residential Multi -Family Geoffrey Reynolds U (DRW) Rural Residential Residential Standard Glen Ardt I (Bend) Density Residential StandardDensity Keith Winsor I (Bend) Martha Meeker U (Sisters) Exclusive Farm Use Jim Powell U (Bend) Rural Residential Raymond Miao U (Bend) Rural Residential Catherine Smith$ U (Bend) Multiple Use Agricultural Builder/Construction/Real Estate Representative(s) - Two (2) to four (4) positions Name Agency/Occupation Board Selections Tyler Neese Central Oregon Association of Realtors Salvador Law, LLC —AnthonySalvador Brent Landels Realtor Karna Gustafson Central Oregon Builders Association Matt Van Coutren Hayden Homes Rick Hayes Brooks Resources Planninz Commission Representative(s) - Two (2) positions 6 Rory Isbell also applied as a Land Use Professional in the "Other" category. Susan Altman also applied as the Director of the Soil & Water Conservation District in the "Other" category. 8 Catherine Smith also applied as an owner of a business that manages HOAs in the "Other" category. Page 2 of 3 Address Provided Zoning of Name U -Unincorporated Board Selections Address Provided 1 -incorporate (Cit ) Jim Seeger U (Bend) Exclusive Farm Use Steve Swisher U (Sisters) Rural Residential 6 Rory Isbell also applied as a Land Use Professional in the "Other" category. Susan Altman also applied as the Director of the Soil & Water Conservation District in the "Other" category. 8 Catherine Smith also applied as an owner of a business that manages HOAs in the "Other" category. Page 2 of 3 Other Attachments: 1) DRAFT -- WMAC Charter Page 3 of 3 Address Provided Zoning of Board Name Background U -Unincorporated Address Selections 1-1 ncorporated(City) Provided Jim Landscape I(Bend) Low-density Figurski Architect Residential Residential joetteFormer BLM/USFS l(Bend) Standard Storm Storm employee Density Attachments: 1) DRAFT -- WMAC Charter Page 3 of 3 Al 11 �kl VYA VON IN "111111115111- , R September 2019 Background The Deschutes County Board of Commissioners (Board) 2019-20 Goals and Objectives includes a Safe Communities Goal to "Protect the community through planning, preparedness and delivery of coordinated services." One objective to achieve this goal is to "Collaborate with partners to prepare for and respond to emergencies and disasters." The Community Development Department's (CDD) 2019-20 Work Plan includes an action item to implement this goal and objective: "Consider implementing wildfire mitigation recommendations from the University of Oregon's Community Service Center (CSC) code audit, coordinate with the County Forester, and consider adopting a new Wildfire Hazard Zone." In addition, in January 2019, the Oregon Building Codes Division (BCD) adopted R327.4 Wilfire Hazard Mitigation amendments to the Oregon Residential Specialty Code. R327.4 is optional for local governments to choose to implement for fire hardening structures in areas mapped as wildfire hazard zones in compliance with the Oregon Department of Forestry's standards. The Board has discussed and considered approaches to updating the wildfire hazard zone / map and adopting building and land use mitigation standards over nearly the past year. In summer 2019, the Board decided to establish a Wildfire Mitigation Advisory Committee (WMAC) to provide recommendations on updating the County's Wildfire Hazard Zone / Map and whether the County should implement new building code standards and land use regulations to mitigate wildfire hazards and improve wildfire safety. Mission and Purpose The Board appointed the WMAC in September 2019 to review and provide recommendations on a Deschutes County Wildfire Hazard Zone / Map, Oregon Revised Specialty Code (ORSC) R327.4 Wildfire Hazard Mitigation, and land use regulations over approximately four (4) months and bimonthly meetings. The purposes of the WMAC include the following objectives: 1. Recommend an updated Deschutes County Wildfire Hazard Zone/ Map based on the Oregon Department of Forestry's (ODF) criteria in Oregon Administrative Rules (OAR) 629-044-0200 (weather, slope, fuel hazard, fuel distribution); 2. Review and recommend whether and how to apply R327.4 construction standards in areas under Deschutes County's building jurisdiction, which include the unincorporated County, and in the cities of Sisters and La Pine; and 3. Review and recommend whether and where to propose new land use regulations based on the University of Oregon's Community Service Center audit of Deschutes County Code, and other sources agreed to by the committee and project management team. Structure and Membership The WMAC consists of X (TBD) voting members appointed by the Board. A project management team consisting of county and city staff will support the WMAC in the following areas: • Meeting facilitation and communications • Website updates and maintenance • Provide an overview of public meeting laws and ethics, education (i.e., applicable laws and rules), technical information and memorandums, and options for decision making • Meeting minutes Record Keeping and Transparency As an official public body, meeting minutes will taken and posted on a designated websites for this project. Meeting minutes will be shared via email with all members prior to the meeting for review, and will be approved as drafted or modified by the committee at the subsequent meeting. This Charter will be posted to the project website and remain a publically available document for as long as the project exists. Membership The WMAC is comprised of members listed in the table below. Membership is at the will of the Board. The committee may or may not be comprised of equal representation from different perspectives, affiliations, etc. A lack of equal representation does not diminish the integrity of the process as all opinions, perspectives, and views will be captured in meeting minutes and project management teams reports to the Board. Name Recommendations The project management team and facilitator will make every effort to facilitate a process to develop and approve recommendations by consensus. When necessary, recommendations will be made by majority vote. Members not present at the time of a vote will not participate in the vote. The project management team will summarize committee recommendation votes to the Board in addition to meeting minutes to articulate the various opinions on issues. The goal will be to achieve consensus or clearly explain areas where disagreements exist and the reasons for different opinions. Ground Rules and Expectations 1. Attendance. The WMAC strives for full attendance at every meeting. Members must be able to attend at least 70% of the scheduled meetings based on the tentative schedule. 2. Work and progress. WMAC members should expect to complete work between meetings. Members will make every effort to prepare for meetings, ask the project management team for assistance as needed between meetings. Members will notify the PMT if unable to attend a meeting. 3. Think collaboratively. The WMAC will attempt to find common ground in developing recommendations. 4. Inclusivity and Civility. WMAC members are expected to create space for diverse or contradictory opinions, and support collaboration in all meetings. IV. Meeting Times, Quorum, Participation, Tentative Schedule WMAC meetings are tentatively scheduled for every other Monday from 4:00-6:30 p.m. at the Deschutes Services Building, 1300 NW Wall Street, Bend, OR. Meetings that conflict with a holiday may be rescheduled to a prior or subsequent Monday at the same time and location. Approximately 10 meetings are anticipated. Meeting agendas will be posted on the project website and provided to WMAC members via email approximately one (1) week prior to each meeting. Regular check -ins with the Board may occur monthly or more frequently if necessary. A quorum (majority) of the members shall be required to make recommendations. TENTATIVE SCHEDULE Date Topics of Discussion Orientation, Introductions, Purpose/Charter, Ground Rules, Overview of Draft October 14 Wildfire Hazard Maps/Zones, R327, Land Use Standards, Major Decision Points. 3 Wildfire Hazard Maps/Zones: Review and discuss concepts; develop additional October 21 concepts? Review and discuss draft Wildfire Hazard Map/Zone Concepts; Identify and November 4 discuss: R327 Decision Points, Questions, and Informational Needs to make recommendations. Discuss and potentially recommend Wildfire Hazard Maps/Zones; Discuss November 18 R327 Decision Pts. Finalize Wildfire Hazard Map/Zone; Discuss and potentially recommend R327 December 2 Decision Pts. Finalize R327 recommendations; Identify and discuss Land Use Standards December 16 Decision Points, Information Needs. January 6 Review and discuss Land Use Standards. January 13 Finalize Land Use Standards recommendations. January 27 If necessary, finalize any outstanding recommendations. ES CSG ci 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 BOCC Monday Meeting of September 23, 2019 DATE: September 12, 2019 FROM: Nick Lelack, Community Development, 541-385-1708 TITLE OF AGENDA ITEM: La Pine Special Service District Sewer Loan Revision RECOMMENDATION & ACTION REQUESTED: CDD recommends amending the interest rate on the La Pine Special Service District loan to match our Full Faith and Credit Obligation Series 2012 Refunding 2003 interest rate of 2.86%. BACKGROUND AND POLICY IMPLICATIONS: The original Full Faith and Credit Obligation Series 2003 had an interest rate of 4.49% which resulted in the sewer loan having an interest rate of 4.5%. The Full Faith and Credit Obligation Series 2012 Refunding 2003 decreased the interest rate to 2.86% in 2012, while the sewer loan interest rate remained at 4.5% FISCAL IMPLICATIONS: Reduces accrued interest by an estimated $105,000. ATTENDANCE: Nick Lelack and Sherri Pinner MEMORANDUM TO: Deschutes County Board of Commissioners FROM: Nick Lelack, AICP, Director Sherri Pinner, Sr. Management Analyst DATE: September 23, 2019 SUBJECT: City of La Pine Sewer Loan Amendment I. SUMMARY The Board of County Commissioners (Board) entered into IGA #2004-092 with La Pine Special Sewer District (District), later assumed by City of La Pine through annexation in 2012, to accommodate the extension of sewer services to the entire Newberry Neighborhood. The County aided the District in constructing the increased sewer capacity through the transfer of Federal Grant funds and a County loan in the amount of $1,130,350. Further, in 2003 the Board approved the annexation of the Newberry Neighborhood to the District conditioned upon the signing of this IGA. La Pine Special Sewer District Loan (Assumed by City of La Pine in 2012) Original Amount: $1,109,801 @ 4.5% Obligation to Repay: Loan payments are from system development charges (SDC's) generated from development within the New Neighborhood. Termination: Obligation to pay the loan terminates in 50 years. (Contract executed March 2004) Balance @ 6/30/2019 = $769,494 County Bond Details: Full Faith and Credit Obligation - Series 2003 - $1,022,783 - 4.49% Full Faith and Credit Obligation - Series 2012 Refunding 2003 - $840,321 - 2.86% Callable December 1, 2022 (Principle Balance = $521,558) Final bond payment due December 1, 2032 Balance @ 6/30/2019 = $634,778 Proposal/Recommendation The agreement for the County to retain SDC's as payment against the loan went well while development occurred between 2004 and 2010. During the recession between 2010 and 2016, very little development occurred resulting in interest accruals with no SDC's collected and retained as loan payments. The original Full Faith and Credit Obligation had an interest rate of 4.49% which resulted in the sewer loan having an interest rate of 4.5%. The Series 2012 Refunding Obligation decreased the bond interest rate to 2.86% in 2012, while the sewer loan interest rate remained at 4.5%. Staff recommends amending the sewer loan interest rate to 2.86%, effective 7/1/2012, reducing the balance by an estimated $105,000 for an estimated revised 6/30/2019 balance of $664,000. RECAP: Principal Capitalized Interest (through June 30, 2019) Repayments Balance attune 30, 2019 La Pine Special Sewer District Loan Balance as of 6/30/2019 4.59{ Interest 1 12.86% Interest * variance $ 1,109,801 $ 1,109,801 599,172 493,991 (939,479) (939,479) $ 769,494 $ 664,313 105,181 $ 105,181 * Estimated interest rate change 7/1/2012 Separately, County CDD and City staff share the goal to repay the loan and bond as soon as possible following the 2022 bond repayment requirements. Upon paying off this debt, the City will collect and retain SDC's in the New Neighborhood to provide resources to serve future growth and development. Board Direction Staff seeks Board direction to schedule this loan amendment for Board approval as proposed or modified. AGENDA REQUEST & STAFF REPORT For Board of Commissioners BOCC Monday Meeting of September 23, 2019 DATE: September 13, 2019 FROM: Nick Lelack, Community Development, 541-385-1708 TITLE OF AGENDA ITEM: CDD Code Enforcement Staffing Conversion Request RECOMMENDATION & ACTION REQUESTED: Convert CDD's approved part-time, on-call Code Enforcement Specialist position to a permanent, full-time position to manage an increasing caseload and improve services. BACKGROUND AND POLICY IMPLICATIONS: The Board of County Commissioners (Board) approved the Community Development Department's (CDD) request to hire an on-call code enforcement specialist in the FY 2019-20 budget to manage increasing complaints and caseload. Since spring, the number of complaints and cases have further increased; the City of Sisters has requested County CDD consider providing solid waste code enforcement on a fee for service basis; and CDD attempted to hire on-call staff. The purpose of this request is to convert the approved on-call staff to one (1) full time code enforcement specialist position to manage the increasing volume of complaints and cases (up 44% from 2018, which was a record-setting year), including providing services to the City of Sisters. FISCAL IMPLICATIONS: The cost increase from the part-time, on-call position ($33,000) to a permanent, full-time position ($90,500) is $57,000, which will be covered by CDD's fees. CDD has a work station, computer, equipment, and a shared vehicle for this position. ATTENDANCE: Angela Havniear, Coordinated Services Division Manager, Sherri Pinner, Sr. Management Analyst, Nick Lelack, CDD Director. Ll I LTA 14 kTA IQ 'j-11 011 pill IT, TO: Deschutes County Board of Commissioners FROM: Nick Lelack, AICP, Director Angela Havniear, Coordinated Services Manager Sherri Pinner, Sr. Management Analyst DATE: September 23, 2019 SUBJECT: Community Development - Code Enforcement Staffing Request I. SUMMARY The Board of County Commissioners (Board) approved the Community Development Department's (CDD) request to hire an on-call code enforcement specialist in the FY 2019-20 budget to manage increasing complaints and caseload. The approved budget allocated $33,000 for the on-call staff. Since spring, the number of complaints and cases have further increased; the City of Sisters has requested County CDD consider providing solid waste code enforcement on a fee for service basis; and CDD attempted to hire on-call staff. The purpose of this memorandum is to request to convert the approved on-call staff to one (1) full time code enforcement specialist position to manage the increasing volume of complaints and cases, including providing services to the City of Sisters.' In addition, CDD was not successful in hiring an on-call staff for several reasons. CDD currently employs three (3) code enforcement specialists responsible for investigating complaints and resolving code violations for land use, onsite wastewater disposal, building, and solid waste codes (by contract with the Solid Waste Department). In addition, the department has one part-time volunteer who reviews Temporary Use Permits for compliance with conditional use decisions, including medical hardships, removal of manufactured homes for storage permits, and living in RVs. CDD also provides solid waste code enforcement services to the City of La Pine through an Intergovernmental Agreement (IGA), and is in discussions with Sisters to provide similar services. 11. PERMIT VOLUMES & PROJECTIONS This section summarizes historical and current permit volumes. 1 Providing solid waste and nuisance code enforcement services to the City of Sisters on a fee-for-service basis is on the Joint Board -Sisters City Council meeting agenda for Sept. 25. Graph 1 highlights code enforcement cases over a nine (9) year period. For the period fan - Aug 2018, CDD received 531 code enforcement complaints. For the same period in 2019, the department has received 760 code enforcement complaints, a 44% increase. CodeEnforcementCases f ei 903 900 760 800 700 605 ;'` Jan - Aug 2019 600 494 500 422 400 348 300 , 224 186 277 255 200 100 0 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 ,� Graph 2 identifies current code enforcement active cases by type of violation. 250 Current Active Cases = 566 W• 150 142 100 100 50 0 200 121 3 Building Code Environrnental Marijuana Solid Waste Zoning Violations Soils o Key Staffing Issues: • Code enforcement complaints continue to increase annually. • While voluntary compliance is the primary objective, an ever-growing number of cases require further code enforcement action due to lagging correction or non-compliance. • CDD currently has an estimated 170 complaints that are unassigned due to caseload volume. The program is currently operating in triage mode, meaning that the number of cases far exceeds staff capacity and staff is primarily only able to prioritize public health, life and safety issues first. Unfortunately, it is often several weeks before staff have the capacity to review a new complaint. • On average, CDD closes between 84% - 88% of cases within one year and the department has approximately 119 cases that are older than one year at this time. • Increase in complaints received from Sheriffs Office. An est. 33% (250 complaints) in 2019, which achieves multiple objectives, including preserving the high quality of life across the County. • City of La Pine anticipates an expansion of enforcement of their code violations to include procedures for administrative civil penalty citations pending City Council approval. • City of Sisters is interested in contracted limited code enforcement services for solid waste. • Processing complex and controversial code enforcement cases often take longer to resolve. • The current volunteer will "retire" soon. • On average, each code enforcement specialist can effectively manage about 80 cases at one time (and about 150 cases annually). Currently, each code enforcement specialist is managing on average over 125 cases at one time. Cost/Financial Impact The total cost of the new position would be an estimated $90,500. CDD has a work station, computer, equipment and a shared vehicle for this position. Adding this FTE and eliminating the use of on-call staff will increase expenditures in our code enforcement division by an estimated $57,000. CDD's current budgeted revenues are anticipated to cover the cost of this position. Additionally, if City of Sisters contracts for limited code enforcement services, revenues received would offset the cost of staffing. Proposal/Recommendation & Board Direction CDD recommends: Convert the on-call Code Enforcement position to a full-time, permanent position to: • Reduce staff caseload to a manageable level. • Allow for timely review of each new code enforcement complaint. • Manage the increased complaints received from the Sheriff's Office. • Manage increase in contracted services. Staff seeks Board direction: 1. Schedule this item for Board approval at a future meeting; or 2. Continue this item to a subsequent meeting for further discussion; or 3. Do not proceed with this change at this time. L�\)I E S COG Z o 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 BOCC Monday Meeting of September 23, 2019 DATE: September 16, 2019 FROM: Nicole Mardell, Community Development, TITLE OF AGENDA ITEM: 2019 Legislative Session Text Amendments BACKGROUND AND POLICY IMPLICATIONS: Discussion to (1) receive information regarding relevant land use bills resulting from the 2019 legislative session and, (2) provide direction to staff on a number of permissive code text amendments. FISCAL IMPLICATIONS: None. ATTENDANCE: Nicole Mardell, Associate Planner, Peter Gutowsky, Planning Manager MEMORANDUM TO: Deschutes County Board of County Commissioners ('Board") FROM: Nicole Mardell, Associate Planner DATE: September 17, 2019 SUBJECT: 2019 Legislative Session Text Amendments - Work Session The Board will conduct a work session on September 23, 2019 to (1) receive information regarding relevant land use bills resulting from the 2019 legislative session and, (2) provide direction to staff on a number of permissive code text amendments. I. BACKGROUND In June 2019, the Oregon Legislature passed a variety of bills that impact Deschutes County. Of these, four are mandatory forjurisdictions to adopt and three are permissive, meaning the jurisdiction could choose whether or not to adopt. Two bills, HB 2106 relating to resource dwelling extensions and HB 3384 relating to nonconforming schools in the Exclusive Farm Use Zone, were adopted by emergency on duly 1, 2019. Due to the need for timely code amendments for these items, Izze Liu, Associate Planner is undertaking the adoption process of these bills separately. II. MANDATORY AMENDMENTS The following bills are mandatory, meaning Deschutes County is required to adopt the updated requirements for consistency between local and state requirements. Staff is informing the Board of these changes to the Deschutes County Code (DCC) that will be forthcoming through a text amendment process. • House Bill 2225 Defines center of a tract and provides clarity on impact of lot lines adjustments for template dwellings in Forest Use Zones. • House Bill 2435 Eliminates previous sunset date of April 15, 2020 for approval of guest ranches. • House Bill 2844 Exempts farm processing facilities in the Exclusive Farm Use (EFU) zone and under 2,500 square feet in size from siting standards. • House Bill 3024 Prohibits County from considering property tax classification of dwellings that were previously removed, destroyed, demolished or converted to nonresidential uses when reviewing an application for replacement dwelling on EFU properties III. PERM ISSIVENOLUWARY AMENDMENTS The following bills are permissive, meaning the Board has the authority to decide whether or not to adopt the proposed text. Staff looks for direction from the Board on moving forward with text amendments relating to the following three bills, with an additional related bill from 2017. • House Bill 2469 Allows establishment of a second dwelling on property in Forest Use Zones to allow relatives to assist in on-site forestry practices. Dwellings must be within 200 feet of the existing dwelling, must be on forestlands within rural fire protection district, and cannot be partitioned. This language is similar to a "relative farm help dwelling' currently allowed in the EFU Zone'. • House Bill 2790 Allows jurisdictions to review an Outdoor Mass Gathering (OMG)2 through a land use application process. Currently, Deschutes County issues a single use permit following the criteria in DCC 8.16, Events, Parades, Funeral Processions and Outdoor Mass Gatherings relating to public health and safety, and a public hearing before the Board. Reviewing OMGs through a land use process could allow for a property to hold events of the same size and scale annually. A potential impact to event organizers however, could be the potential of lengthy appeals. • Senate Bill 287 Allows establishment of farm breweries on EFU, or mixed Farm and Forest Use properties that are in use as, or immediately adjacent to, a hop farm of at least 15 acres in size. A brewery would be required to produce less than 150,000 barrels annually through any entity owned or affiliated with the brewery, and less than 15,000 barrels produced on site. This text is similar to a winery, currently allowed in the EFU Zone'. • Senate Bill 677 (from 2017 session) Allows establishment of cider business on EFU, or mixed Farm and Forest Use properties that are in use as, or immediately adjacent to, an orchard of at least 15 acres in size. Cider business would be required to produce less than 100,000 gallons of cider annually. As orchards are not very common in Deschutes County, this item was not reviewed in 2017. As the Board is reviewing a similar bill (Senate Bill 287), staff offers this bill for additional consideration. 1 DCC 18.16.025(B) 2 Outdoor Mass Gathering is defined as a gathering of more than 3,000 person which typically continues for more than 120 hours within any three-month period. The law added a section that allows review of events exceeding this time limitation and with no minimum persons in attendance. 3 DCC 18.16.025(F) Page 2 of 3 IV. NEXT STEPS / BOARD DIRECTION Staff seeks Board direction to initiate all, or any of, the permissive amendments presented in Section III above. The first evidentiary hearing with the Planning Commission is tentatively scheduled for November 14, 2019 to accommodate a 35 -day notice to the Department of Land Conservation and Development. Page 3 of 3