Loading...
2019-409-Minutes for Meeting August 26,2019 Recorded 9/30/2019BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541 ) 388-6570 1:00 PM Recorded in Deschutes County CJ2019-409 Nancy Blankenship, County Clerk Commissioners' Journal 09/30/2019 8:19:46 AM 2019-409 FOR RECORDING STAMP ONLY ALLEN CONFERENCE ROOM Present were Commissioners Phil Henderson, Patti Adair and Anthony DeBone. Also present were Tom Anderson, County Administrator; Erik Kropp, Deputy County Administrator; David Doyle, County Counsel; and Sharon Keith, Board Executive Assistant. Several citizens and several identified representatives of the media were in attendance. CALL TO ORDER: Chair Henderson called the meeting to order at 1:00 p.m. ACTION ITEMS 1. CCBHC Continuation Proposal Information Janice Garceau, Health Services presented the continued discussion on the opportunity to join the state for continuation of funding for certified community behavioral health clinic. Deschutes County would have a request to utilize service element dollars as match dollars. This item is on the BOCC meeting agenda for consideration on Wednesday August 28. BOCC MEETING AUGUST 26, 2019 PAGE 1 OF 5 2. Solid Waste Management Plan Discussion Timm Schmike Solid Waste Director presented the continued discussion. Commissioner DeBone inquired whether a private organization could be considered as an option as well. Commissioner Adair inquired where additional trash cans for separating items would be helpful in reducing the amount of food waste. Commissioner Adair commented on 25% of the items in the landfill is food waste. Mr. Schimke commented on the history of levels and types of generated waste in the landfill. Mr. Schimke explained the history of recycling collection. Commissioner DeBone recommends partnerships within the industry. Further discussion will occur on the BOCC meeting agenda of Wednesday, September 4. 3. Continuation of Terrebonne Wastewater Discussion Nick Lelack, Community Development Department Director and Chris Doty Road Department Director presented. A request for proposals is planned with the scope of the project. The Board expressed the importance of community of Terrebonne's input on this project as well. Mr. Doty and Mr. Lelack will draft a scope of work. The Board is supportive of obtaining more information. 4. Nonprime Resource Lands / Letter to the State Land Conservation and Development Commission Zechariah Heck and Peter Gutowsky, Community Development Department presented a draft letter for the Commissioners to consider. The letter is addressed to the Oregon Land Conservation and Development Commission and the Department of Land Conservation and Development. The Board recommended revisions to the letter. Commissioner Henderson will present the letter to the Eastern Oregon Counties meeting tomorrow in hopes for additional county support. DEBONE: Move approval of Board signature with recommended edits ADAIR: Second BOCC MEETING AUGUST 26, 2019 PAGE 2 OF 5 VOTE: DEBONE: Yes ADAIR: Yes HENDERSON: Chair votes yes. Motion Carried 5. Consideration of Taylor Grazing Project County Forester Ed Keith presented the application for funding through the Taylor Grazing Project. Mr. Keith published a news release announcing the funding opportunities and Desert Creek Ranch was the only applicant. Deschutes County receives Taylor Grazing Funds for the purpose of funding rangeland improvement projects. Desert Creek Ranch proposes to use the funding to install fencing to improve grazing management which also will improve sage grouse habitat. The request is for $6,000 and is reimbursed basis on successful completion of the project. The Board would act as the Taylor Grazing Committee to approve the funding. Commissioner DeBone is in support of the funding without requiring the reimbursement but requiring the announcement of the project completion. There is approximately $50,000 in the fund balance and Mr. Keith expended the $6,000 from the Natural Resources budget for the project. ADAIR: Move approval of the reimbursable payment of $6,000 of Taylor Grazing funds to Desert Creek Ranch. DEBONE: Second VOTE: ADAIR: Yes DEBONE: Yes HENDERSON: Chair votes yes. Motion Carried 6. Finance Update Finance Director Greg Munn presented the finance update. The Board recommended that the font size on the report be increased. Mr. Munn BOCC MEETING AUGUST 26, 2019 PAGE 3 OF 5 presented the treasurer and finance report as of July 31, 2019. The countywide summary for all Deschutes County departments was reviewed. A data base called the Cube provides an advantage for the departments to access the line items of the budget. There were 66 staff vacancies reported in July. Mr. Munn reported Senate Bill 1049 has several components to provide relief to employers through an incentive fund for PERS. 7. Review of the Redmond Chamber State of the County Address and 2019 County College Whitney Hale, Public Information Officer presented the draft presentations for the Redmond State of the County address that is scheduled for Thursday, August 29 at the Fair and Expo Center and the 2019 County College that begins Tuesday, September 3. The Board recommended a few revisions. OTHER ITEMS: Joint Meeting with the City of Redmond is scheduled for September 17 and County Administrator Anderson presented a draft list of agenda topics. Commissioner Henderson would like to see oversight on a master developer for the affordable housing project. • County Administrator Anderson reported Vic Russell has accepted the proposal for affordable housing incentive in La Pine. COMMISSIONER UPDATES • Commissioner DeBone attended the roundtable recruiting event for OSU Extension last week. Commissioner DeBone will not attend the Pendleton Round Up this year but has planned to attend next year. He is hoping to BOCC MEETING AUGUST 26, 2019 PAGE 4 OF 5 attend the SIEC meeting is scheduled for September 10. This morning he attended the homeless leadership coalition funding committee meeting. • Commissioner Henderson is attending the marijuana summit in Portland on September 5. • Commissioner Adair is attending the 9/11 ceremony at the Pentagon. She attended the Behavioral Health Advisory Board meeting and interviews for committee members. Committee Adair attended the Deschutes River Recreation Home Sites meeting last week. Being no further items to come before the Board, the meeting was adjourned at 4:12 p.m. DATED this Day 2019 for the Deschutes County Board of Commissioners. PHILIP G. HENDERSON,C IR ATTI ADAIR, VICE CHAIR BOCC MEETING AUGUST 26, 2019 PAGE 5 OF 5 ES \)I CD Deschutes County Board of Commissioners 1300 NW Wall St, Bend, OR 97703 (541) 388-6570 - www.deschutes.org BOCC MEETING AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:00 PM, MONDAY, AUGUST 26, 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 Board's ability to address other topics. Meetings are subject to cancellation without notice. Item start times are estimated and subject to change without notice. CALL TO ORDER ACTION ITEMS 1. 1:00 PM CCBHC Continuation Proposal Information -Janice Garceau 2. 1:30 PM Solid Waste Management Plan Discussion - Timm Schimke, Director of Solid Waste 3. 1:45 PM Continuation of Terrebonne Wastewater Discussion - Nick Lelack, Community Development Department Director 4. 2:05 PM Nonprime Resource Lands / Letter to the State Land Conservation and Development Commission - Zechariah Heck, Associate Planner 5. 2:20 PM Consideration of Taylor Grazing Project - Ed Keith, Forester 6. 2:30 PM Finance Update - Greg Munn, Finance Director Board of Commissioners BOCC Meeting Agenda Monday, August 26, 2019 Page 1 of 2 7. 2:45 PM Review of the Redmond Chamber State of the County Address and 2019 County College COMMISSIONER'S UPDATES 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. OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. ADJOURN 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 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, August 26, 2019 Page 2 of 2 �\�I E S _3 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 August 26, 2019 DATE: August 21, 2019 FROM: Timm Schimke, Solid Waste, 541-317-3177 TITLE OF AGENDA ITEM: Solid Waste Management Plan Discussion BACKGROUND AND POLICY IMPLICATIONS: The Department of Solid Waste formally presented the recently completed Solid Waste Management Plan to the Board of County Commissioners on Monday August 19,2019. Commissioners may not have had sufficient time to read the entire plan and suggested a potential discussion of the plan at their August 26 BOCC Meeting. FISCAL IMPLICATIONS:No fiscal implications at this time, however, Plan identified an excess of $26 million in required capital funding will be required over the next ten years if the Plan recommendations are approved ATTENDANCE: Timm Schimke, Director of Solid Waste \)I E S CdG o`er 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 August 26, 2019 DATE: August 21, 2019 FROM: Zechariah Heck, Community Development, 541-385-1704 TITLE OF AGENDA ITEM: Nonprime Resource Lands / Letter to the State Land Conservation and Development Commission BACKGROUND AND POLICY IMPLICATIONS: On August 21, the Board directed staff to draft a letter to the Land Conservation and Development Commission (LCDC) on behalf of the County Commissioners. The letter (attached) is intended to encourage LCDC to direct the Dept. of Land Conservation and Development (DLCD) to initiate rulemaking regarding Nonprime Resource Lands/Rural Resource Lands. FISCAL IMPLICATIONS: None. ATTENDANCE: Peter Gutowsky, Planning Manager; Nick Lelack, Community Development Director; Zechariah Heck, Associate Planner. August 28, 2019 Jerry Lidz, Commission Chair Oregon Land Conservation and Development Commission ("LCDC") 635 Capitol St. NE Suite 150 Salem, OR 97301 Jim Rue, Director Department of Land Conservation and Development ("DLCD") 635 Capitol St. NE Suite 150 Salem, OR 97301 Re: 2019-2021 Policy Agenda for DLCD / Rural Resource Lands Dear Chair Lidz and Director Rue, The Deschutes County Board of Commissioners, following a recommendation from the Planning Commission, respectfully request LCDC initiate rulemaking to establish standards to guide counties in identifying and zoning Rural Resource Lands in the 2019-2021 biennium.' We understand the demands on the department over the biennium, but disagree with the staff recommendation to discontinue or defer this action item. DLCD has been discussing this topic for over a decade most notably with the Southern Oregon Regional Pilot Project, Big Look Bill/Law (ORS 215.788 - 215.794), biannual policy agendas, and a 2019 Portland State University Hatfield Resident Fellowship case study. Unfortunately, no changes in state law have been made. We believe it is a now matter of statewide concern to provide rules to implement OAR 660- 004-005(3). As you know, Deschutes County continuously expresses interest in updating the County's inventory of Exclusive Farm Use and Forest Use zoned properties to ensure accurately designed lands. Based on the Rural Resource Lands case study written by Fellow Stephanie Campbell, 25% of non -resource land re - designations have occurred in Deschutes County; the largest of those is a 587 -acre property owned by the Department of State Lands. We frequently hear from constituents that their land is not accurately ' Rural resource lands are identified in State Rules as "Non Resource Lands." Deschutes County has renamed these lands as "Non -prime Resource Lands." 1300 NIA, VV-sII S i e:_,t E3end, 0; e- - 7 703 ?G8 b57) g @ vvw�lw.c1r_sdhurc ..crg designated. Ultimately, the absence of administrative rules encouraged us to initiate comprehensive plan amendments that address Rural Resource Lands. The amendments, proposed in April 2019, identified opportunities to re -designate six specific areas committed to residential uses that were platted or conveyed prior to State enabling planning legislation taking effect. The amendments also mirrored existing state criteria governing non -resource land re -designations while adding local eligibility criteria, e.g., requirements to be in a fire district or able to be served by one. Deschutes County has now tabled the aforementioned amendments because of a recent Land Use Board of Appeals (LUBA) remand .2 The ruling now creates tremendous uncertainty and appears to make it unlikely counties proposing non -resource lands eligibility criteria can prevail on an appeal. The remand is an unintended consequence of not having rulemaking clarifying state land use law as previously requested by Deschutes County.' The complications created by this decision can be remedied if LCDC/DLCD initiate rulemaking. Prioritizing and funding this initiative is of statewide importance. Sincerely, THE DESCHUTES COUNTY BOARD OF COMMISSIONERS Phil G. Henderson, Chair Patti Adair, Vice -Chair Anthony DeBone, Commissioner z DLCD et al vs. Douglas County 2019 3 Deschutes County has submitted letters and comments to LCDC and DLCD, such as a May 6, 2015 letter to DLCD Director)im Rue requesting rulemaking. E S C�G 2 o c 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 August 26, 2019 DATE: August 22, 2019 FROM: Ed Keith, Natural Resources - Forestry, 541-322-7117 TITLE OF AGENDA ITEM: Consideration of Taylor Grazing Project RECOMMENDATION & ACTION REQUESTED: Acting as the Taylor Grazing Committee, approve the rangeland improvement project proposed by the Desert Creek Ranch. BACKGROUND AND POLICY IMPLICATIONS: Deschutes County receives Taylor Grazing Funds for the explicit purpose of funding rangeland improvement projects. (see ORS 294.070) The opportunity for funding applications was advertised through local media and one application was received. The Desert Creek Ranch located near Hampton proposes to install fencing to improve grazing management which will also benefit sage grouse habitat. Of the total $45,200. 00 project cost, Desert Creek Ranch requests $6,000 of Taylor Grazing funds to assist in completing the project. Costs will be paid on a reimbursable basis upon successful completion of the project. FISCAL IMPLICATIONS: $6,000.00 will be paid to the Desert Creek Ranch for fence construction costs on a reimbursable basis. These dollars are budgeted for in the Natural Resources budget (fund 326) ATTENDANCE: Ed Keith, County Forester August 6, 2019 Attn: Ed Keith Deschutes County Forester 61150 SE 27tb Street Bend, Oregon, 97702 RE: Deschutes County Taylor Grazing Act Funds Dear Taylor Grazing Committee: Located on the Northeastern corner of Deschutes County near the base of Hampton Buttes lies the Desert Creek Ranch. Desert Creek Ranch currently run their livestock on private ranch property and have grazing allotments with both Bureau of Land Management (BLM) and Department of State Lands (DSL). For decades the pasture fences have not changed and certain areas of the allotments with very sensitive soils are seeing some degradation and overuse of native vegetation. This particular concern poses a potential threat to existing sage grouse habitat within the allotments. At the moment, the two pastures of concern are the North Imperial and the Barb Wire Well pastures located on DSL and private ground running adjacent to BLM on the Western and Northern cross fences. Rangeland managers from DSL and Desert Creek Ranch would like to propose a cross fence design in both the Barb Wire and the North Imperial pastures to better distribute livestock in the western side of the pastures for proper utilization and as a tool to better manage the vegetation on the eastern side of the allotment. This proposed design will allow for new pasture rotations for both duration and season of use, which is critical for sage grouse brooding areas. The proposed fence design would consist of 3 barbed wire strands that meet ODFW wildlife specifications. The fence would also have markers placed on the top strand to help prevent potential flight collision from sage grouse. Over half of the proposed fence line would be placed atop the rim that naturally acts as a barrier and is less likely in an existing sage grouse flight path (see map design). Not only is this particular area of the county of interest to Desert Creek, BLM, and DSL; it is a key focus area for the Deschutes Soil and Water Conservation District (DSWCD) and their continued support to private landowners, USFWS and NRCS for the development and implantation of Candidate Conservation Agreements with Assurances (CCAA's) for sage grouse. DSWCD continues to partner with Crook SWCD on these types of programs and technical assistance provided to these landowners. DSL will be providing the fencing materials for this proposal and are very enthusiastic about the implementation of this project and what it could do to help improve rangeland and sage grouse habitat. The permittee (Desert Creek Ranch) will be providing the contractor to construct the fence and are asking for support from the Taylor Grazing Act funds to help supplement these accrued costs. Please see the budget below to view the expense breakdown of the project. North Imperial Project Budget Quantity Funder Description Unit Price Total 41 DSL Wildlife friendly fence (materials) miles $ 5,300.00 $ 21,200.00 4 Permitee Wildlife friendly fence (Labor) miles $ 6,000.00 $ 24,000.00 DSL Total $ 21,200.00 Permittee Total $ 24,000.00 Project Total $ 45,200.00 The Department of State Lands, Prineville BLM District, Deschutes Soil & Water Conservation District, and Desert Creek Ranch are asking for the support of the North Imperial Fencing project from the Deschutes County Taylor Grazing Act Committee. All partners involved are committed to the completion of this project and are asking for match funds from the Taylor Grazing Act in the amount of $$6,000 to help supplement labor costs for constructing the division fence. Implementation of the project is scheduled for late Fall 2019 and finished no later than June 1, 2020. This project will be implemented in two phases. Phase I will include North Imperial fence and Phase II will include Barb Wire Fence. This current proposal and budget only include Phase I timelines and cost projections. Please see attached maps, designs, and letter of support. Thank you for your time and consideration. For any questions and/or comments regarding this project please contact Libby Stahancyk at 541-420-5619 or lil�laal_l�lx,�1c lc<<i;ixiailcom. Kindest Regards, elibby Stahancyk FL -16505 Proposed Fences o Prop_Fenceline -•••- Cnty_accesj_roads .Y, �. ,•Y BLOCKED �•., ..,. •`♦ i ♦�f�a '•'•� ••� Barbwire' —x FENCES `Division Fence .•� , WATER i Approx 2.8 miles �••"� LVST_Wells �.♦�� •• % lStock—ponds `� .` 1 ♦♦,YYY♦..nY..Yp♦Yf -- WATERLINES �,.`°•,.M..,YY4� ♦�•«......YY�;;. w E i `q ,Y_ . ��,• r O •♦ • u, t. r .r e Y X� �.�aP' ,,.,a•b•..Y + ��•`♦r`w �+• . , � f t cri«x� t ti f _� ♦ ,� ca' ag!♦wi , a� c- '� — Jl..� �..rM1Y11MY wrrm�ux, r�YMY • . ahl"�' '"� -"irY 'RSA •f� .� / t i »s.;', I s 4.1 00 � �a § •rte t�LL/• ,`O ,♦ ,♦ ♦r♦ r North Imperial %— Division Fence ,. �., gym`,, ..•� t Approx 3.75 Miles 7-7x ♦ Y `• ' . ` Y i �IA.YYY/IYYYI.YY.Yt�MYY\I�YY.•!•Y!•PY�Y.• ....rt. 6 ff ' a ate. � _.. ...,._ ....,,.. �♦ Y � • r �. • Y .►'''�a i 0. 0 0.25 0.5 i 1 Miles! ,, ° Copyright:© 2013 National Geographic Society, i -cubed 2i.p O, fA-ATiON tib'~ Deschutes Soil and Tater Conservatim District 625 SE Sabnon Aa a Redmond OR. 97756 541-•923-43 i8 ext. 3I90 August 7, 2029 The Deschutes Soil and Water Conservation District (DSWCD} would like to express our support for the Imperial Fencing Project located near Hampton Buttes. This project complements the Deschutes SWCD efforts in assisting private landowners and addressing Sage Grouse habitat. The project also meets federal standards (USFW and MRCS} under the Candidate Conservation Agreement with Assurances (CCAA) for Sage Grouse. Cross fencing the North Imperial pasture wiR improve livestock distribution promoting better utilization and grazing management on DSI, BLL and private lands. In addition, the Taylor Grating Act funds will provide a small portion of a greater financially effort taken on by Desert Creek Ranch. Sincerely, Ta y Harty, De utes SWCD District Manger eschutes Soil and Water Conservation District 625 SE Salmon Ave Redmond OR. 97756 Deschutes County Treasurer and Finance Report Fiscal Year to Date July 31, 2019 (unaudited) Investment Portfolio • The portfolio balance at the end of July was $184,605,717. This is a decrease of $7.5M or 4% from last month but an increase of $21.2M or 13% from a year ago. • Net investment income for the month is $380,586 which is $143,894 greater than July 2018 but $11,460 less than last month. Otal Investment Portfolio As Of 713112019 Total Portfolio: By Investment Municipal Debt $ 14,710,000 7.97% Corporate Notes 49,165,000 26.63% Time Certificates - 0.00% U. S. Treasuries 12,000,000 6.50% Federal Agencies 54,784,000 29.68% LGIP 45,502,279 24.65% First Interstate Bank 8,444,438 4.57% Total Investments $ 184,605,717 100.00% Total Portfolio: By Investment Types F -t hterstate Category Maximums: 5enk Wnbipel Debt 4.6% 80% LGP Corporate 24.6% Wt.. 100.00%` 26.6% Policy Tree Banker's Acceptances 25% Gerffic- 2.71% 0.0% Fsdsral U. s. Agencies Treasuries 29.7% 6.5% Investment Income unction Fiscal Year 2018-19 •-•Jul-19 Y -T -D $ 184,605,717 $ 400,817 $ 400,817 400,617 400,617 Less Fee: 5% of Imest. Income Investment Income - Net Term Prior Year Comparison Jul -18 $ 238,592 S 238,692 Actual Category Maximums: Yield Percentages Current Month Prior Month Under 1 Year U.S. Treasuries 100% 76.24% LGIP ($48,333,000) 1110% = e 100.00%` FedereI Agencies 75 Policy Actual Banker's Acceptances 25% I'• 2.71% Time Certificates 50% 25.00% 12.10% Municipal Debt 25% Benchmarks AA1 Corporate Debt 25% r Term Minimum Actual 0 to 30 Days 10.00% 34.64% Under 1 Year 25.00% 1 76.24% Under5Years I 100.00% 100.00%` Other Policy Actual Corp Issuer 5.00% 2.71% Callable 25.00% 12.10% Credit W/A AA2 AA1 We are within category maximums except for corporate notes which is at 26.6%. This is slightly over the 25% maximum due primarily to the decrease in the overall pool balance from May and June. This will be brought into balance by reviewing future redemptions and managing future purchases in light of the overall pool balance. Average portfolio yield for the month is 2.50% down slightly from 2.53% the prior month. This is due to declining yields in the bond market in response to a potential reduction in the federal funds rate and tariff worries. New July investments were in federal agency bonds, purchased with a yield to maturity of slightly under 2% and municipal bonds with a yield slightly over 2%. This is in contrast to our portfolio's average 2.25% YTM for both federal agencies and municipal bonds. The Local Government Investment Pool rate remains at 2.75% but decreases to 2.6% in August. The current pool balance limit is $49.5M but is expected to increase by approximately $800,000 or more by the end of August. The weighted average time to maturity is 0.62 years, down from 0.67 in May. This is reflective of a declining rate environment and shorter term investment. The average maturity for July investment is slightly over 2 years. Historical Investment Rates of Returns Budget to Actuals Report On the attached pages you will notice a refreshed set of fiscal reports. These new reports are the results of goals of Finance staff to improve information reporting, transparency and efficiency. Part of this work revised the format to align the data in a more logical flow to make it easier to read. Additionally, the new system allows departments to revise projections and make working budget adjustments directly in the system. This improves the relevancy and accuracy of the information presented. NEW FORMAT Department wide Summary Y... Co 83% B,plet, ✓' 001 - General Fund Grouping kt,<,ty lhry My Dt FI.<el Year 2428 RESOURCES ap<,ry fazes C 294678. a n Bd0 to09e ProMltS Tares P, 310000 I., 1494 4. 00 ]8 211 370000 1004: p Oleer General keven�es i.E85.5M 3.2!5.1811214 30N.<Op 121.1 11. 3.o39,d601W4 -B 821.111 950 106,159 151 63],38) 1005E ; C 1.551,585 A)4 399.669 t9 1.59],365 1004 BOPTA 82100 9 95ti 92.210 0 215E 2110 1001 --C Oistrrc: A—, 2151 369.]83 386.915 554: )15.215 336o I4 311,N94 Taa Olf�.e 198956 106,251 1064: 195.390 a3950 ri% 195.350 1404- 160.A<5 10 166.623 It01 Yttenns 96X1) 214- 166 dI3 4 Yraperty Manapen,xnl 110.000 00%_ 11),004 58] _ W 120.000 t60N _ �G TOTAL RESOURCES 319D8.668 3d.721.1001025F; 35.696.160 1163.]6] '1 5.698.t6P 1[M. REQUIREMENTS -_ Sl'a+ui✓s 991 BOPTA7312.1 11 451 145111 14 ¢63 1004 Pl'D Brseiet Anwney 1.3129)3 6.95]86 954 1.AP4.568 t BN 1.665.861 981 I36.>OS:D Medual Eaam:nar It+.t19 160,28E 934 2..561 1 04 25.50214495 T..OtfKe 6]2,014 ]19.SD1 65 964 856 (14 .)0] 5].159 ] 1469]2 100% 1665] O .261 5]98]6 IM 1 1404 10 1 ]3 3 %d 4tx 2VIII 12 ]25 AK 2. BS 1004 11001 D Non Ma asyn,en 1411819 1 964 1JSJ 702 6 J88 124 353.502 1045E - <TOTALREOU'RENENT4 486019 .i95,o66 911: 16)0119! 351515 7% 17.Ill,529 991. .9,165: TRANSFER6 1.: s 0- :uNz - 4 - 269.1165 A P 2 0401N9i Transxz a 119d<J6f811 118352,146) tOJ'h ('9263.3 ) 1119891)1111],8931 61 119.283,310) I TOTAL TRANS I 11401].559) 118.063,039) 10 (14013310) 11113.893) 6 119,D23.310) tOP4 FURD OAIANCE 4,.dJ.v 4Van>�a' Begnninp fond Ba:anu 19840'404 11946.54611 12.110'S381A01 Pti]5453811. IAN,538 Resov,ars wee Regvenranss 16.652.6]9 18.311.103 7.496.846 (181.74!) 1!.]56611 2.311' Net TransfersIn lOul) 100]1.5591 (18.053039) 19023]101 (119193) (14,023.3101 - TOTALFUNOBAIANCE 44369840 f 12110.5)6 1324 : 49563.536 i1490e.e9]t161 110,943.839116151 Y0..3 Cuve+:Y<r rases ren,v<c-PrnarY-n Neves-W.Feereary a -d lAaY. 8 xn�a'1•AGJO4 reeve ao'Man�u>v tan YTD IT-,--, rt 02n Jcv[e�.O3-Janwrv:ge. Yy141. -,+ys re:a'ei w FTE va:ames l?0 a -o swx-n!<d vra-cYra'<s anzs'en' w:e, vTD eale�rce n. era] f:.r5'cm Fnr.«0.eseeves'x EkP 1-q:<+:e^:a.an { R•e9m C<q: of l'e'-s A,3 9nntrz:ra:rsx o -a'1<'1 .-.d trdsxc nan»ect+! revsrvx �eco-e-J a; yeacnd. R nenrU.,E 4<s a-<eF 151: tl+•aY:, j., "I canParec ro Ce peel Yez. PRIOR FORMAT General FBnd S,I,edUlc of Financial 011 -ting 081a FY 2019 31120t9eY FY 2030 IB..Ux ohne year) s-Cun<v bw3<: 6ve9e: 5 17 - al 6 2600: ado - a 44 e�Gef e�a�sR<.<v<s el 3. 600 C-- n51.595 e'3:cr 25k 0 - . - NI BOPTA �1*111 TZ . w _ cl 2'11 1 1". 2M III f , r ana8em:-.: Total Revenues C9D6e % t) JPS - % BI 130 GOC 36.522,100 1,163.]68 _4 35.698160 35,698.160 Eapeneituns c n d D Ga, •y a:n 6OPTp 1 ]5. 17 n ..a 'y llana2eman: ,3a.) 6 C - 8 ,, Sil - 719.301dl 86P.)Ot - Ile,- r dl :80 c 501 2r6 fee 125 e I dl 61 1e5 daa2r? _ ?., e' To IEFPerM,evres1351,N1 1-1 .11 Tnnslers 1111* F111 See n. -O funs E>'ax< 18.201394 61,5ri 159,]65 388.OBd 2.465,410 sA 3],234,604 0R,86a 839 159,]65 213-1 ('.3010621 +.255.5891 25.165 210E33 .Ly. 'I.h:C.G .'0538 1110.5?0 EndlnP Fund Balance R p YBud8e1 1 11.2111.531 f 1 S 563.636 1 11113, . 1 Catt �. G6Ya �O.r,ey Tota eY Category _ n, 9lsx�a:reea9>edm d)Sav+2s,<lafed lc FTE 1wryv.s e)Rw>Yn,eni:o Gere 911n:efvrd Lvtl[akm.a-aG s^.`erv:9reve�.:e 7o 3`e3 + -`-323311 2 1 1 1.351516 24 f 11.201,294 - teary end M1bY. Jax �• e6 se Pivx:.,»a u,. YTD. ttDla+e lve;as4 av>:>+cyra:es sw:+srsxn3x^r. vip e.perarrc - rew,dec. n Position Control Vacancies for July total 66 out of a 1,043 or 6.3%. This compares to 5.5% for June and 6.9% for July 2018. PERS Employer Incentive Fund The recently passed PERS overhaul legislation (SB 1049) included several components with the intent to reduce the state's unfunded pension liability. One of the components is the Employer Incentive Fund (EIF). The EIF provides up to a 25% match on qualifying employer lump -sum deposits into a side account that is invested by the Oregon State Treasury in the Oregon Employee's Retirement Fund. Employer deposits, match and earnings or losses are used over time to reduce the employer's pension liability. The application period for matching funds begins September 3. The first 90 days of the application cycle are reserved for employers with an unfunded liability that exceeds 200% of payroll. Because the county's liability is less than 200% (156%) we will not be eligible to apply during the first round but must wait until the second round which begins December 2. The application cycle ends by August 2020 or when all the OF match money has been allocated. Finance will analyze options and report back to the Board at a work session this fall. Position Control Summary FY20 July - June Percent Juty A ust September Weber November December Janui February March April may June Unfilled. Assessor Filled 34.26 Unfilled 1.00 2.84% Clerk Filled 8.48 Unfilled - 0.00% ROM Filled 0.52 Unfilletl - 0.00% DA Filled 49.95 Unfilled 200 3.85% Tex Filled 4.50 YAlled - 0.00% vete-W Filled 4.00 Unfilled - 0.00% P,e ,ty Wo Filled 1.80 Unfilled - - - - - - 0.00% Total General Fund filled103.51 - - - - - - - - - - - - 2'02 Unfilled 3.00 - - - - Justice Court Filed 4.60 - Unfilled 0' Communityjmtlm filled 46.90 Unfilled 1.00 2'09 Shedff Filled 22135 Un811ed 18.25 7.80% H-111, Srvc Filled 284.55 Unfilled 20.35 6.67 CDD Filled 53.00 Unfilled 3.00 5.36% Road Filled 55.00 Unfilled 1.00 1.7 Adult P&P Filled 37.85 Unfilled 2.00 5.02% Shcd Waste Filled 24.00 Unfilled 0.50 2.04% 9.1-1 Filled 55.52 Unfilled 4.48 ].4]% victims Asslstana Filled 7.00 Unfilled 1.00 12.50% GIS Dedlcated Filled 1.30 Unfilled 1.00 43. 8 Fal,&fxpo Filled 12.00 Unfilled 0.00 Natural Resource filled 1.00 Unfilled 0' ISF- Fecllitles filled 19.00 Unfilled 6.00 24.00 ISF•Admin Filled 5.7S Unfilled 1.00 14.81 ISF-SOCC Filled 3.00 Unfilled 0.00 ISF - Floe.. Filled 10.00 Unfilled 0' ISF -teZW Filled 6.00 Unfllled 1.00 14.29% ISF - NR Filled 8.00 Unfilled 0' ISF - IT filled 14.70 Unfilled 1.00 6.37 ISF - Risk Filled 2.25 Unfilled 1.00 - - - - - 30.]] July - lune Percerd Mv Au un September October November December January Feb- March Apol May lune Unfllled T.W. Fill 976.68 - - - - - - Unfllletl Unfilled 66.06 6.94% 6'34 PERS Employer Incentive Fund The recently passed PERS overhaul legislation (SB 1049) included several components with the intent to reduce the state's unfunded pension liability. One of the components is the Employer Incentive Fund (EIF). The EIF provides up to a 25% match on qualifying employer lump -sum deposits into a side account that is invested by the Oregon State Treasury in the Oregon Employee's Retirement Fund. Employer deposits, match and earnings or losses are used over time to reduce the employer's pension liability. The application period for matching funds begins September 3. The first 90 days of the application cycle are reserved for employers with an unfunded liability that exceeds 200% of payroll. Because the county's liability is less than 200% (156%) we will not be eligible to apply during the first round but must wait until the second round which begins December 2. The application cycle ends by August 2020 or when all the OF match money has been allocated. Finance will analyze options and report back to the Board at a work session this fall. uTES C oG�� Countywide Summary All Departments Activity thru July of Fiscal Year 2020 RESOURCES 001 - General Fund 030 - Community Justice 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 618 - RV Park 670 - Risk Management 675 - Health Benefits 705-911 999- Other TOTAL RESOURCES REQUIREMENTS 001 - General Fund 030 - Community Justice 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 8.3% Year Complete Fiscal Year 2019 Fiscal Year 2019 Fiscal Year 2020 Fiscal Year 2020 Budget Budget Actuals % Budget Actuals % Projection % 33,938,668 34,722,100 102% ; 35,698,140 1,163,767 3% ; 35,698,140 100% ; 786,286 695,035 88% ; 856,930 37,764 4% 856,930 100% ; 7,282,600 7,682,623 105% ; 7,732,000 979,538 13% ; 7,732,000 100% ; 552,000 608,275 110% ; 578,000 47,590 8% ; 578,000 100% ; 39,225,869 40,217,835 103% ; 41,390,080 548,116 1% 41,390,080 100% ; 353444,454 34,764,084 98% ; 34,399,596 763,359 2% ; 33,099,596 96% ; 8,153,746 7,755,886 95% 8,468,820 787,866 9% ; 8,446,491 100% ; 22,876,423 22,720,219 99% ; 22,785,827 3,859,011 17% ; 23,547,159 103% ; 6,360,818 6,468,769 102% ; 5,775,278 1,234,979 21% ; 6,105,644 106% ; 959,104 261,131 27% 2,142,893 34,780 2% ; 2,142,893 100% ; 11,868,613 11,504,244 97% 11,724,869 1,067,374 9% ; 11,724,869 100% ; 1,499,100 1,589,820 106% ; 1,561,500 41,528 3% ; 1,5613500 100% ; 358,600 488,285 136% ; 437,700 74,842 17% ; 437,700 100% ; 3,569,944 3,454,346 97% 3,495,039 334,059 10% ; 3,495,039 100%: 21,411,563 22,699,675 106% ; 22,318,433 1,790,912 8% ; 22,318,433 100%: 10,260,013 10,220,116 100% ; 10,563,350 75,221 1% `, 10,563,350 100%: 36,330,641 36,745,752 101% ; 28,099,148 2,345,209 8% ; 28,099,148 100%: 240.878.442 6% ; 100% ; 237,796,972 242.598,195 101% ; 238,027,603 15,185,914 Fiscal Year 2019 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % 17,486,029 16,395,068 94% 18,201,294 1,351,515 7% ; 17,941,529 99% ; 7,040,903 6,638,700 94% 7,127,337 546,234 8% ; 7,001,942 98% ; 2,335,678 2,224,811 95% 2,212,140 9,878 0% ; 2,212,140 100% ; 658,081 652,039 99% 678,141 65,746 10% ; 678,141 100% ; 42,853,022 41,550,205 97% 44,494,082 3,550,467 8% 44,494,082 100%: 44,974,364 41,986,782 93% 46,305,772 3,061,763 7% 44,311,534 96% ; 7,726,157 7,331,793 95% 7,851,291 645,375 8% 7,840,040 100%: 14,689,753 12,158,580 83% ; 14,573,336 961,542 7% ; 14,391,898 99% ; 6,505,128 6,208,610 95% 6,589,491 464,823 7% 6,423,695 97% ; 8,309,501 5,455,306 66% ; 13,835,913 20,107 0% 13,835,913 100% ; Countywide S u m m a ry 1 Fiscal Year 2020 All Departments Budget Actuals % Budget Actuals % ; ; Activity thru July of Fiscal Year 2020 % 7 610 - Solid Waste 8,310,720 7,643,453 92% 8,384,039 314,310 4% 615 - Fair & Expo 2,688,885 2,786,625 104% 2,464,787 218,031 9% 618 - RV Park 521,971 499,108 96% 540,373 14,323 3% 670 - Risk Management 3,858,097 2,860,546 740/6 4,132,295 439,581 11% 675 - Health Benefits 23,144,255 21,211,014 92% 22,115,011 183,437 1% 705-911 13,379,064 10,579,411 79% 12,250,336 1,157,456 9% 999 - Other 46,792,062 35,294,006 75% 57,628,740 3,349,871 6% TOTAL 251,273,671 221,476,058 88% 269,384,378 16,354,459 6% REQUIREMENTS 100%: (14,464,308) (14,464,308) 100% (11,910,575) - TRANSFERS 001 - General Fund 030 - Community Justice 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 618 - RV Park 670 - Risk Management 705-911 999- Other TOTAL TRANSFERS 8.3% Year Complete 8,224,317 98% 2,464,787 100% 540,373 100% 4,132,295 100% 22,115,011 100%: 11,655,589 95% 57,628,740 100% 265,892,026 99% Fiscal Year 2019 1 Fiscal Year 2020 Budget Actuals % Budget Actuals % ; ; Projection % 7 (18,077,559) (18,063,039) 100% (19,023,310) (1,113,893) 6% (19,023,310) 100% 5,744,015 5,744,015 100% 5,874,465 496,788 8% 5,874,465 100% (4,649,866) (4,449,866) 96% (4,133,128) (262,648) 6% (4,133,128) 100% 30,000 30,000 100% 2,981,253 2,981,254 100% 3,119,936 282,668 9% 3,119,936 100% 6,177,535 6,179,204 100% 6,102,365 478,924 8% 6,102,365 100% (1,152,624) (1,170,172) 102%: (1,448,081) . 0% (1,448,081) 100%: (14,464,308) (14,464,308) 100% (11,910,575) - 0% (11,910,575) 100%: 165,189 165,189 100% 223,189 23,765 11% 223,189 100%: 13,811,725 13,393,963 97% 12,014,914 - 0% 12,014,914 100% (4,688,023) (5,000,029) 107% (3,296,192) - 0% (3,296,192) 100% 1,220,994 1,164,996 95% 1,022,863 18,811 2% 1,022,863 100% 160,000 160,000 100%: (307,000) . 0% (307,000) 100% (3,168) (3,168) 100%: (6,918) . 0% (6,918) 100% 12,744,837 13,331,961 105% 11,767,472 75,585 1% 11,767,472 100%: �wi,E CSG o� Countywide Summary •' • 1 8.3%`7 Year Complete All Departments Activity thru July 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,210,538 132% ; 9,563,536 10,908,897 10,943,839 114% ; 030 - Community Justice 689,399 1,149,231 167% ; 694,058 1,137,549 878,684 127% ; 160/170 - TRT 2,261,401 2,574,397 114% ; 3,686,732 3,281,408 3,961,129 107% ; 220 - Justice Court 67,919 144,227 212% ; 64,859 126,071 44,086 68% ; 255 - Sheriffs Office 13,191,907 16,522,328 125% ; 14,732,933 13,802,645 16,538,262 112% ; 274 - Health Services 3,850,339 8,261,059 215% ; 4,077,752 6,4412578 3,151,485 77% ; 295 - CDD 1,478,676 1,783,536 121% ; 1,151,452 1,926,027 941,906 82% ; 325 - Road 2,416,014 6,412,174 265% ; 2,303,905 9,309,642 3,656,860 159% ; 355 - Adult P&P 2,220,879 2,759,069 124% ; 1,998,976 3,552,993 2,650,581 133% ; 465 - Road CIP 14,148,365 17,7882615 126% ; 15,938,430 17,803,288 ; 182110,509 114% ; 610 - Solid Waste 600,000 799,753 133% ; 644,638 1,552,817 1,004,113 156% ; 615 - Fair & Expo 31,209 (92,094) -295%; 199,576 (249,787) ; 27,482 14% ; 618 - RV Park 315,629 592,657 188% ; 150,327 6532177 182,984 122% ; 670 - Risk Management 5,308,679 7,172,915 135% ; 5,455,826 7,0672393 6,528,741 120% ; 675 - Health Benefits 14,318,894 16,563,976 116% ; 16,309,716 18,171,452 16,767,398 103%: 705-911 52505,949 82301,320 151% ; 6,066,720 7,219,085 7,209,081 119% ; 999- Other 58,869,933 73,222,238 124% ; 55,089,130 72,293,162 54,872,276 100% ; TOTAL 134,540,271 176,165,937 131% ; 138,1282566 174,997,396 147,469,416 107% ; RESOURCES Department -wide Summary 001 - General Fund Grouping Activity thru July of Fiscal Year 2020 Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management TOTAL RESOURCES REQUIREMENTS Assessor Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental TOTAL REQUIREMENTS 8.3% Year Complete Fiscal Year 2019 1 4,530,088 94% Fiscal Year 2020 377,259 Budget Actuals % Budget Actuals % Projection % $ Variance 27,337,385 27,803,331 102% 29,067,840 - 0% 29,067,840 100% A 370,000 404,601 109% 370,000 78,421 21% 370,000 100% 160,296 2,685,500 3,245,181 121% 3,020,400 525,343 17% 3,020,400 100% ' B 870,658 823,127 95% 837,283 208,258 25% 837,283 100% -' C 1,787,270 1,551,585 87% 1,597,369 299,469 19% 1,597,369 100% - H 12,700 12,119 95% 12,220 3,300 27% 12,220 100% C 389,782 386,919 99% 311,215 3,360 1% 311,215 100% - 198,950 206,292 104% 195,390 43,950 22% 195,390 100% C 166,423 168,945 102% 166,423 - 0% 166,423 100% F 120,000 120,000 100% 120,000 1,667 1% 120,000 100% G 33,938,668 34,722,100 102% ; 35,698,140 19163,767 3% , 35,698,140 100% ; Budget Actuals % Budget Actuals % 4,802,452 4,530,088 94% 4,993,290 377,259 8% i 1,8549397 1,598,512 86% 2,031,590 102,864 5% i 73,125 69,561 95% 77,950 5,212 7% 7,372,932 6,993,244 95% 7,800,568 586,411 8% 173,129 160,296 93% 235,542 231 0% i 872,020 779,301 89% 846,307 57,799 7% 572,287 538,876 94% 580,360 38,628 7% 287,858 278,966 97% 281,985 22,725 8% 1,477,829 1,446,223 98% 1,353,702 160,388 12% 17,486,029 16,395,068 94% 18,201,294 1,351,515 7% ; Projection % $ Variance 4,876,081 98% 117,209, D 2,022,841 100% 8,749! D 77,843 100% 107 D 7,665,862 98% 134,706! D 235,542 100% 846,972 100%! (665)! D 580,501 100% (141)! D 282,185 100% (200); D 1,353,702 100% 6% ; 17,941,529 99% 259,765; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 326,122 289,065 89% 260,000 - 0% 260,000 100% Transfers Out (18,403,681) (18,352,104) 1001/ (19,283,310) (1,113,893) 6% (19,283,310) 100% TOTAL TRANSFERS Y (18,077,559) (18,063,039) 100% ; (19,023,310) (1,113,893) 6% ; ; (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,210,538 110% 1,120,538, Resources over Requirements 16,452,639 18,327,033 17,496,846 (187,748) 17,756,611 259,765! Net Transfers - In (Out) (18,077,559) (18,063,039) (19,023,310) (1,113,893) (19,023,310) - TOTAL FUND BALANCE $ 9,265,080 $ 12,210,538 132%: $ 9,563,536 $ 10,908,897 114% $ 10,943,839 114% $1,380,303: 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; 03 - 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. G Interfund land -sale management revenue recorded at year-end. H Recording fees are up 15% through July 2019 compared to the prior year. � ��S ES CpGZ FINANCE uTES CO -A Department -wide Summary 030 - Community Justice Grouping Activity thru July of Fiscal Year 2020 RESOURCES OYA Basic & Diversion ODE Juvenile Crime Prev Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 Interest on Investments OJD Court Fac/Sec SB 1065 Gen Fund -Crime Prevention Food Subsidy Miscellaneous Contract Payments Case Supervision Fee TOTALRESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers In- General Funds Transfers Out-Veh Reserve TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 8.3% Year Complete Fiscal Year 2019 1 Actuals % Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 407,113 i 305,407 75% 442,601 - 0% 442,601 100% 91,379 92,492 101% 91,379 - 0% 91,379 100%! -� � � 85,000 i ° � 87,311 103% ' 86,400 7,347 9% � 86,400 100%, 70,000 71,400 102% 80,000 25,800 32% 80,000 100%, -� 35,000 34,945 100% 35,000 - 0% 35,000 100% i 25,000 31,318 125% 31,000 2,767 9% 31,000 100%, - 17,000 27,158 160% 26,000 - 0% 26,000 100% 20,000 15,000 75% 20,000 0% 20,000 100% 18,744 129052 64% 16,000 0% 16,000 100%, -' 2,050 4,603 225% 14,050 1,250 9% 14,050 100% 8,000 i 7,269 91% 8,000 - 0% 89000 100% -' � 7,000 6,081 87% 6,500 600 9% � 6,500 100% 786,286 695,035 88% 856,930 37,764 4% 856,930 100% ; Budget Actuals % Budget Actuals % 5,705,245 i 1,327,658 8,000 5,412,349 1,218,785 7,566 95% 92% 95% 5,797,927 1,329,410 460,609 85,625 - 8% 6% 7,040,903 6,638,700 94% 7,127,337 546,234 8% ; Budget Actuals % Budget Actuals % 5,831,015 (87,000) 5,831,015 100% (87,000) 100% 5,961,465 (87,000) 496,788 - 8% 0% 5,744,015 5,744,015 100% ; 5,874,465 496,788 8% ; Budget Actuals % Budget Actuals % 1,200,000 (6,254,617) 5,744,015 1,348,881 (5,943,665) 5,744,015 112% 1,090,000 (6,270,407) 5,874,465 1,149,231 (508,471) 496,788 105%, $ 689,399 $ 1,149,231 167% ' $ 694,058 $ 1,137,549 164% ' A Projected Personnel savings based on FYI average vacancy rate of 2.1 % a�e 3585.co& FINANCE Projection % $ Variance 5,672,532 98% 125,395, A 1,329,410 100% 7,001,942 98% 125,395; Projection % $ Variance 5,961,465 100% ' (87,000) 100% 5,874,465 100% ; Projection % $ Variance 1,149,231 105% 59,231; (6,145,012) 125,395 5,874,465 $ 878,684 127% ' $184,626' RESOURCES Room Taxes Interest Department -wide Summary 160/170 - TRT Grouping Activity thru July of Fiscal Year 2020 TOTALRESOURCES 8.3% Year Complete Fiscal Year 2019 1 1,946,668 2,067,761 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 7,260,000 7,618,179 105% 7,670,000 973,137 13% 7,670,000 100% A 22,600 64,444 285% 62,000 6,400 10% 62,000 100% B 7,282,600 7,682,623 105% ; 7,732,000 979,538 13% 7,732,000 100% ; Software60,000 REQUIREMENTS Budget Actuals % Budget Actuals % COVA 1,946,668 2,067,761 106% 2,064,221 - 0% Interfund Contract 59,121 59,121 100% 79,160 6,597 8% Interfund Charges 39,087 39,087 100% 37,309 3,109 8% Auditing Services 12,501 10,800 86% 14,500 - 0% Software60,000 i 42,391 71% 10,350 - 0% Expenditures 3,000 1,589 53% 2,000 18 1% Printing 2,200 209 9% - 2,000 - 0% Public Notices 3,101 1,834 59% 1,600 154 10% Office Supplies 1,000 0% 1,000 - 0% ' Sunriver Service Dist 200,000 - 0% - - Temporary Help 9,000 2,020 22% - - TOTAL REQUIREMENTS 2,335,678 2,224,811 95% 2,212,140 9,878 0% ; TRANSFERS Budget Actuals % Budget Actuals % Transfer Out - RV Park - (35,000) - 0% Transfer Out - Annual Fair (150,000) (150,000) 100% (250,000) - 0% Transfer Out - F&E Reserve i (830,083) (630,083) 76% (286,687) - 0% ' Transfer Out - F&E (517,996) (517,996) 100% (409,654) - 0% ' Transfer Out -Sheriff 151,787 � (3, ) 3,151,787 ( ) 100% = 3,151,787 ( ) 262,648 ( ) 8% ' TOTAL TRANSFERS ; (4,649,866) (4,449,866) 96% ; (4,133,128) (262,648) 6% ; Projection % $ Variance 2,064,221 100% 79,160 100% C 37,309 100% 14,500 100% 10,350 100% 2,000 100% 2,000 100% 1,600 100% 1,000 100% 2,212,140 100% ; Projection % $ Variance (35,000) 100% (250,000) 100% (286,687) 100%; (409,654) 100% (3,151,787) 100%: - (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,574,397 112% 274,397: Resources over Requirements i 4,946,922 5,457,811 5,519,860 969,659 5,519,860 Net Transfers - In (Out) TOTAL FUND BALANCE (4,649,866) (4,449,866) (4,133,128) (262,648) F (4,133,128) - $ 3,961,129 107% : $274,397, $ 2,261,401 $ 2,574,397 114% $ 3,686,732 $ 3,281,408 89% A Prior year collections YTD was 11 % of budget, compared to current year collections YTD of 13% Includes interest payments from delinquent tax collections. Contracted services with the Finance Department for operating TRT program. `�V'S ES_C'pG H� 2 FINANCE VCES C Department -wide Summary $•3% Year Complete 220 - Justice Court Grouping Activity thru July 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 47,327 8% 575,000 100% Interest on Investments 2,000 2,931 147% 3,000 263 9% 3,000 100% TOTAL RESOURCES 552,000 608,275 110% ; 578,000 47,590 8% 578,000 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 508,650 508,098 100% 516,868 44,602 9% 516,868 100% Materials and Services 149,431 143,941 96% 161,273 21,144 13% 161,273 100% A TOTAL REQUIREMENTS 658,081 652,039 99% 678,141 65,746 10% 678,141 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 30,000 30,000 100% - - TOTAL TRANSFERS 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,156) (100,141) Net Transfers - In (Out) 30,000 30,000 TOTAL FUND BALANCE $ 67,919 $ 144,227 212%, $ 64,859 $ 126,071 194% : $ 44,086 68% ($20,773): A Annual software maintenance costs paid upfront in fiscal year 01,31 ES coo FINANCE 01ES C Department -wide Summary 255 - Sheriff's Office Grouping Activity thru July of Fiscal Year 2020 8.3% Year Complete REQUIREMENTS Fiscal Year 2019 Actuals % Budget Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance LED #1 Property Tax Current 24,792,245 25,166,301 102% 26,305,470 - 0% 26,305,470 100% LED #2 Property Tax Current 10,043,598 10,186,942 101% 10,640,014 - 0% 10,640,014 100% LED #1 Property Tax Prior 300,000 313,461 104% 300,000 64,779 22% 300,000 100% LED #2 Property Tax Prior 150,000 141,251 94% 140,000 27,185 19% 140,000 100% LED #1 Interest 145,000 288,269 199% 138,000 19,096 14% 138,000 100% LED#2 Interest 120,000 193,301 161% 136,000 14,393 11% 136,000 100% Sheriff's Officg Revenues 3,675,026 3,853,426 105% 3,730,596 422,662 11% 3,730,596 100% LED #1 Foreclosed Properties - 53,322 - 881,182 892,837 101% - LED #2 Foreclosed Properties 7% _ 21,561 Training 667,647 - TOTAL RESOURCES 39,225,869 40,217,835 103% ; 41,390,080 548,116 1% ; 41,390,080 100% REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Adult Jail 18,357,098 17,363,704 95% 18,359,024 1,354,633 7% 18,359,024 100% Patrol 10,003,952 10,040,921 100% 10,592,002 1,142,006 11% 10,592,002 100%, - Sheriffs Services 3,636,550 3,654,465 100% 3,740,851 275,719 7% 3,740,851 100% - Automotive/Communications 2,644,785 2,534,293 96% 2,858,337 140,589 5% 2,858,337 100%! - Detective 2,033,077 2,044,686 101% 2,132,319 174,408 8% E 2,132,319 100% Special Services 1,520,623 1,451,539 95% 1,601,871 125,411 8% 1,601i871 100% Other Law Enforcement 1,017,266 1,075,404 106% 1,330,214 95,313 7% 1,330,214 100%: - Records 881,182 892,837 101% 1,004,600 73,641 7% _ 1,004,600 100% Training 667,647 874,923 131% 743,334 46,254 6% 743,334 100% Civil/Special Units 543,129 563,801 104% 596,364 42,235 7% 596,364 100% Crisis Stabilization Center 559,308 72,308 13% 571,267 7,022 1% 571,267 100% Court Security 551,494 531,409 96% 556,740 45,099 8% 556,740 100% Emergency Services 328,581 341,586 104% 402,734 27,767 7% E 402,734 100% Non -Departmental 108,329 108,329 100% 4,425 369 8% 4,425 100% TOTAL REQUIREMENTS 42,853,022 41,550,205 97% 44,494,082 3,550,467 8% 44,494,082 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,151,787 3,151,787 100% 3,151,787 262,648 8% 39151,787 100% Transfer In - General Fund 103,132 103,132 100% 240,249 20,020 8% 240,249 100% Transfers Out - Debt Service (273,666) (273,666) 100% (272,100) - 0% (272,100) 100% TOTAL TRANSFERS 2,981,253 2,981,254 100%: 3,119,936 2829668 9% ; 3,119,936 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 13,837,807 14,873,445 107% 14,716,999 16,522,328 112% 16,522,328 112% 1,805,329: Resources over Requirements (3,627,153) (1,332,371) (3,104,002) (3,002,351) (3,104,002) Net Transfers - In (Out) 2,981,253 2,981,254 3,119,936 282,668 3,119,936 TOTAL FUND BALANCE $ 13,191,907 $ 16,522,328 125% $ 14,732,933 $ 13,802,645 94% $ 16,538,262 112% $1,805,329, may' 2� FINANCE uTES CO �`? GZ< Department -wide Summary 274 - Health Services Grouping Activity thru July of Fiscal Year 2020 RESOURCES State Grant OHP Capitation CCBHC Grant Environmental Health Fees State Miscellaneous State - OMAP Local Grants Federal Grants Patient Fees Title 19 Other Vital Records Divorce Filing Fees Interest on Investments Liquor Revenue Interfund Contract- Gen Fund State Shared- Family Planning TOTALRESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers In- General Fund Transfers In- OHP Mental Health Transfers Out TOTALTRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 8.3% Year Complete Fiscal Year 2019 Actuals % Fiscal Year 2020 Actuals Budget Actuals % Budget Actuals % Projection % $ Variance 13,262,344 i 13,274,779 100% 12,982,070 3,644 0% 11,626,496 90% (1,355,574) A ' 8,652,200 8,142,094 94% 11,569,756 - 0% 11,569,756 100% 41,986,782 5,406,848 i 3,493,034 65% 2,409,991 7% ; 0% 2,409,991 100% % 1,169,600 i 1,076,036 92% 1,058,206. 26,470 3% 1,113,780 105% 55,574 B 899,734 686,778 76% 1,040,153 - 0% 1,040,153 100% 0% 1,147,168 i 1,108,622 97% 991,900 69,180 7% 991,900 100%, - 1,208,623 1,224,128 101% 985,900 114,381 12% 985,900 100%, -' 990,189 ° 603,524 61 /o � 946,625 - 0% 946,625 100% i 236,500 637,910 270% ' 564,750 51,989 9% 564,750 100% 1,345,100 3,069,162 228% 535,400 396,503 74% 535,400 100% $ 3,850,339 343,545 i 382,965 111% 353,015 42,675 12% 353,015 100% -' 212,000 241,727 114% 220,000 8,953 4% 220,000 100% 157,603 157,603 100% 173,030 - 0% 173,030 100% - 135,000 218,767 162% 171,000 22,422 13% 171,000 100% 151,000 151,948 101% 150,800 - 0% 150,800 100% 127,000 127,000 100% 127,000 0% 127,000 100% 168,007 120,000 27,143 23% 120,000 100% r � - J 35,444,454 34,764,084 98% ; 34,399,596 763,359 2% 339099,596 96% (1,300,000); Budget Actuals % Budget Actuals % 31,702,065 29,780,257 94% 32,618,626 2,587,632 8% 13,033,299 12,000,494 92% 13,342,146 474,131 4% 239,000 206,031 86% 345,000 - 0% 44,974,364 41,986,782 93% 46,305,772 3,061,763 7% ; Budget Actuals % Budget Actuals % 6,366,223 6,367,892 100% 5,747,090 478,924 8% - i - 548,601 0% (188,688) (188,688) 100% (193,326) 0% ' 6,177,535 6,179,204 100% ; 6,102,365 478,924 8% ' Budget Actuals % Budget Actuals % 7,202,714 9,304,552 129% 9,881,563 8,261,059 84% (9,529,910) (7,222,698) (11,906,176) (2,298,404) i 6,177,535 6,179,204 6,102,365 478,924 $ 3,850,339 $ 8,261,059 215% ' $ 4,077,752 $ 6,441,578 158% ' Projection % $ Variance 31,924,388 98% 694,238, C 12,042,146 90% 1,300,000- D 345,000 100% 44,311,534 96% ; 1,994,238; Projection % $ Variance 5,747,090 100% 548,601 100% (193,326) 100% ;- 6,102,365 100% ; Projection % $ Variance 8,261,059 84% (1,620,504)' (11,211,938) 694,238 6,102,365 $ 3,151,485 77% ($926,267)' A Budgeted funds was a pass-through from the Behavioral Health State IGA for residential treatment providers, which will be paid directly during an 18 -month contract B Fees were budgeted at an increase of 3%, but were adopted at an 8.5% rate increase C Projected Personnel savings based on FYI average vacancy rate of 8% D Reduction in Contracted Services related to footnote A '�')TE5 co�� _ FINANCE RESOURCES Department -wide Summary 295 - CDD Grouping Activity thru July of Fiscal Year 2020 Admin - Operations Code Enforcement Building Safety Electrical Environmental On -Site Current Planning Long Range Planning TOTALRESOURCES REQUIREMENTS Admin - Operations Code Enforcement Building Safety Electrical Environmental On -Site Current Planning Long Range Planning TOTAL REQUIREMENTS TRANSFERS Transfers In Transfers Out Transfers Out - CDD Reserve TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 8.3% Year Complete Fiscal Year 2019 Actuals % Budget Fiscal Year 2020 % Budget Actuals % Budget Actuals % Projection % $ Variance 114,500 152,827 133% 162,000 12,086 7% 162,000 100% -° r 664,291 635,453 96% 693,960 68,932 10% 685,915 99% (8,045) A r 3,312,714 3,075,409 93% 3,433,780 319,148 9% 3,433,780 100% 1,456,128 i 804,849 738,580 92% 809,500 65,519 8% 809,500 100%! 554,385 782,984 819,608 105% 877,400 99,246 11% 877,400 100% 8% i 1,795,453 1,701,840 95% 1,807,176 142,797 8% 1,797,725 99% (9,451) A r 678,955 632,170 93% r 685,004 80,138 12% 680,171 99% (4,833), A 8,153,746 7,755,886 95% 8,468,820 787,866 9% 8,446,491 100% ; (22,329); Budget Actuals % Budget Actuals % 2,477,738 2,386,276 96% 2,575,316 235,088 9% r 456,162 445,254 98% 481,242 34,826 7% i 1,676,037 1,565,140 93% 1,665,199 130,906 8% r 445,433 439,104 99% 457,282 37,660 8% 612,596 547,203 89% 616,279 43,524 7% r 1,554,847 1,456,128 94% 1,501,588 119,906 8% i 503,344 492,687 98% 554,385 42,077 8% 7,726,157 7,331,793 95% ; 7,851,291 643,986 8% Budget Actuals % Budget Actuals 300,000 289,193 96% 100,000 0% r (79,945) i (79,945) 100% (85,695) - 0% ' (1,372,679) (1,379,420) 100% (1,462,386) - 0% (1,152,624) (1,170,172) 102% ; (1,448,081) - 0% ; Budget Actuals % Budget Actuals % 2,203,711 2,529,615 115% 1,982,004 1,783,536 90% i 427,589 424,093 617,529 143,880 (1,152,624) (1,170,172) (1,448,081) - $ 1,478,676 $ 1,783,536 121% ' $ 1,151,452 $ 1,927,416 167% A Revenue adjustment related to a decrease in the manufactured home valuation factor Projection increased to include unbudgeted health benefits trust Projection decreased due to year to date unfilled positions TES DOGS FINANCE Projection % $ Variance 2,578,083 100% (2,767) C 490,449 102% (9,207) B 1,652,391 99% 12,808 C 454,084 99% 3,198, C 609,060 99% 7,219! C 1,501,588 100% i i r 554,385 100% 7,840,040 100% ; 11,251; Projection % $ Variance 100,000 � 100% r r (85,695) 100% ' - (1,462,386) 100% (1,448,081) 100% ; Projection % $ Variance 1,783,536 90% (198,468); 606,451 (11,078)= � e � (1,448,081) � i s $ 941,906 82% ($209,546): vi ES C Department -wide Summary 8•3% Year Complete 325 - Road Grouping Activity thru July 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 1,527,442 9% 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 - 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 152,745 24% 660,000 - 0% 660,000 100% Sale of Equip & Material 365,000 285,514 78% 358,000 36,252 10% 358,000 100% Interest on Investments 150,000 220,062 147% 246,000 19,088 8% 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% t 60,000 100% Miscellaneous 45,000 118,699 264% 57,500 3,272 6% 57,500 100%! State Miscellaneous ! 739,811 710,633 96% 20,000 - 0% 20,000 100% Assessment Payments (P&I) I 80,000 22,350 28% I 11,000 1,175 11% 11,000 100% TOTAL RESOURCES 22,876,423 22,720,219 99% 22,785,827 3,859,011 17% 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 516,992 8% 6,266,233 97% 181,438: B Materials and Services I 8,094,192 5,912,229 73% 8,094,165 444,551 5% 8,094,165 100%! 2 Capital Outlay I 31,500 0% 31,500 100% TOTAL REQUIREMENTS 14,689,753 12,158,580 83% ; 14,573,336 961,542 7% 14,391,898 99% 181,438; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (14,464,308) (14,464,308) 100% (11,910,575) - 0% (11,910,575) 100% TOTAL TRANSFERS ; (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,412,174 107% 410,185, Resources over Requirements 8,186,670 10,561,639 8,212,491 2,897,469 9,155,261 942,770! Net Transfers - In (Out) (14,464,308) S (14,464,308) I (11,910,575) - E (11,910,575) ! I k TOTAL FUND BALANCE $ 2,416,014 $ 6,412,174 265% : $ 2,303,905 $ 9,309,642 404% 7-T3,656,860 3,656,860 159% $1,352,955 A PILT payment received in July. Exceeded amounts as budgeted. B Projected Personnel savings based on FY19 average vacancy rate of 4.8% `,�uTES C,0 FINANCE �v ( ES CO Department-wide Summary 8.3% Year Complete 355 - Adult P&P Grouping Activity thru July 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,782 106% 268,156, 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 17,064 11% 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 6,170 8% 77,500 100% - Interfund- Sheriff 50,000 51,034 102% 50,000 4,167 8% 50,000 100% Gen Fund/Crime Prevention 50,000 55,000 110% 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 320 16% 2,000 100% - Electronic Monitoring Fee 10,000 84,165 842% � 2,000 7,773 389% � � 2,000 100% Miscellaneous 500 6,102 999% 500 0% 500 100% - State Miscellaneous 4,300 - 0% - TOTAL RESOURCES 6,360,818 6,468,769 102% ; 5,775,278 1,234,979 21% 6,105,644 106% ; 330,366; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 4,656,363 4,522,266 97% 4,809,644 388,411 8% 4,6439848 97% 165,796: F Materials and Services 1,828,765 1,686,344 92% 1,764,847 76,412 4% 1,764,847 100% Capital Outlay 20,000 - 0% 15,000 0% 15,000 100% - TOTAL REQUIREMENTS 6,505,128 6,208,610 95% ; 6,589,491 464,823 7% 6,423,695 97% 165,796; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 285,189 23,765 8% 285,189 100% Transfer to Vehicle Maint (120,000) (120,000) 100% (62,000)0% (62,000) 100% - TOTAL TRANSFERS 165,189 165,189 100% ; 223,189 23,765 11% ; 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,745,443 106% 155,443 Resources over Requirements (144,310) 260,159 (814,213) 770,156 (318,051) 496,162 Net Transfers - In (Out) 165,189 165,189 F I 223,189 23,765 ! F 223,189 ! 1 - I TOTAL FUND BALANCE $ 2,220,879 $ 2,759,069 124% $ 1,998,976 $ 3,552,993 178% $ 2,650,581 133% $651,605, 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 Projected Personnel savings based on FY19 average vacancy rate of 3.6% ��� FINANCE v'CES �- o�`�� Department -wide Summary 8.3° Year Complete 465 - Road CIP Grouping Activity thru July 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 34,780 18% 198,000 100% -° TOTAL RESOURCES 959,104 261,131 27% 2,142,893 34,780 2% ; 2,142,893 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 73,153 73,153 100% = 71,748 5,979 8% 71,748 100% Capital Outlay 8,236,348 5,382,153 65% 13,764,165 14,128 0% 13,764,165 100% TOTAL REQUIREMENTS 8,309,501 5,455,306 66% 13,835,913 20,107 0% ; 13,835,913 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 13,811,725 13,393,963 97% 12,014,914 - 0% _ 12,014,914 100% TOTAL TRANSFERS 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,788,615 114% 2,172,079, Resources over Requirements (7,350,397) (5,194,175) (11,693,020) 14,673 (11,693,020) Net Transfers - In (Out) 13,811,725 13,393,963 k 12,014,914 12,014,914 TOTAL FUND BALANCE $ 14,148,365 $ 17,788,615 126% $ 15,938,430 $ 17,803,288 112% $ 18,110,509 114% $2,172,079, `�V5 t5 co G h Z FINANCE VIES �- o�` Department -wide Summary $•3° Year Complete 610 - Solid Waste Grouping Activity thru July 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 540,210 8% 6,437,500 100% Private Disposal Fees 2,709,370 2,379,061 88% 2,419,046 235,640 10% 2,419,046 100% Commercial Disp. Fee 2,042,050 2,060,523 101% 2,252,225 239,810 11% 2,252,225 100% Franchise 3% Fees 265,000 291,340 110% 265,000 4,385 2% 265,000 100% Yard Debris 216,761 268,830 124% 216,761 35,554 16% 216,761 100% Interest 44,000 58,235 132% 59,000 2,805 5% 59,000 100% Miscellaneous 49,955 57,067 114% 48,336 5,045 10% 48,336 100% Special Waste 15,000 21,487 143% 15,000 2,861 19% 15,000 100% Recyclables 18,000 11,063 61% 12,000 1,064 9% 12,000 100% Leases 10,801 1 0% 1 - 0% 1 100% TOTAL RESOURCES 11,868,613 11,504,244 97% 11,724,869 1,067,374 9% 11,724,869 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,504,623 2,331,135 93% 2,538,776 200,267 8% 2,379,054 94% 159,722, A Materials and Services 4,772,159 4,338,711 91% 4,927,163 102,318 2% 4,927,163 100% Capital Outlay 173,000 112,669 65% 56,000 11,724 21% 56,000 100% Debt Service r 860,938 860,937 100% a 862,100 - 0% 862,100 100% TOTAL REQUIREMENTS 8,310,720 7,643,453 92% ; 8,384,039 314,310 4% ; 8,224,317 98% 159,722; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment Reserve (4,688,023) (5,000,029) 107°/a (3,296,192) - 0% (3,296,192) 100% TOTAL TRANSFERS (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,753 133% 199,753 Resources over Requirements 3,557,893 300,791 3,340,830 753,064 3,500,552 159,722 Net Transfers - In (Out) (4,688,023) (5,000,029) (3,296,192) - (3,296,192) TOTAL FUND BALANCE $ 600,000 $ 799,753 133%, $ 644,638 $ 1,552,817 241% 7 $ 1,004,113 156% $359,47$ A Projected Personnel savings based on FY19 average vacancy rate of 6.5% L� uT ES :OG Qh, „ FINANCE RESOURCES Department -wide Summary 615 - Fair & Expo Grouping Activity thru July of Fiscal Year 2020 Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Intenfund Payment Camping Fee Miscellaneous Interest TOTALRESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay Debt Service Personnel Services - F&B Materials and Services - F&B TOTAL REQUIREMENTS TRANSFERS Transfers In - Room Tax Transfers In - County Fair Transfers In - General Fund Transfers In - Park Fund Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 8.3% Year Complete Fiscal Year 2019 1 71,855 126% 62,000 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 655,000 615,300 94% 687,000 15,200 2% 687,000 100% - 540,000 629,875 117% 568,000 12,191 2% 568,000 100% 105,000 115,650 110% 120,000 11,300 9% 120,000 100% - 83,100 76,735 92% 71,000 - 0% 71,000 100% 57,000 71,855 126% 62,000 - 0% i i 30,000 54,573 182% 30,000 2,500 8% i 18,200 19,975 110% 18,000 250 1% i 8,400 6,374 76% 3,500 400 11% 2,400 (518) -22% 2,000 (313) -16% 1,499,100 1,589,820 106% ; 1,561,500 41,528 3% ; Budget Actuals % Budget Actuals % 1,248,512 1,259,337 101% 1,000,199 109,897 11% 967,441 912,681 94% 795,788 84,552 11% - - 102 999% E 101,136 101,136 100% 100,800 - E 0% E 149,296 149,947 100% 157,430 12,198 8% i 222,500 363,524 163% 410,570 11,282 3% 2,688,885 2,786,625 104% ; 2,464,787 218,031 9% ; Budget Actuals % Budget Actuals % 517,996 517,996 100% 409,654 2,145 1% E 472,998 417,000 88% 395,000 - 0% 200,000 200,000 100% 200,000 16,666 8% 30,000 30,000 100% 30,000 - 0% - (11,791) - 0% 1,220,994 1,164,996 95% 1,022,863 18,811 2% ; Budget Actuals % Budget Actuals % (60,285) 999%: 80,000 (92,094) -115%; (1,189,785) (1,196,806) (903,287) (176,503) 1,220,994 E 1,164,996 t 1,022,863 18,811 E $ 31,209 ($92,094) -295% : $ 199,576 ($249,787) -125% A Reimbursement from RV Park for personnel expenditures recorded in F&E. Net proceeds from the County Fair are recorded in a separate fund and transferred in at year-end. `�V5 E5 COG ���� FINANCE 62,000 100% , 30,000 100%: A , 4 i � 18,000 100% i i 3,500 100%,, E 2,000 100% 1,561,500 100% ; Projection % $ Variance 1,000,199 100% 795,788 100% 100,800 100% 157,430 100% 410,570 100% 2,464,787 100% ; Projection % $ Variance 409,654 100%, 395,000 100%, - B i E , 200,000 100% � 30,000 100% (11,791) 100% 1,022,863 100% Projection % $ Variance i (92,094) -115%; (172,094); (903,287) � 1,022,863 $ 27,482 14% ($172,094): uTES �- Qh`' °G2� Department-wide Summary 8.3% Year Complete 618 - RV Park Grouping Activity thru July 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 73,622 18% 405,200 100% -= A Interest on Investments 4,400 12,255 279% 12,000 1,297 11% 12,000 100% - Cancellation Fees 4,000 12,497 312% 5,000 1,393 28% 5,000 100% -F 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 983 25% 4,000 100% Vending Machines 1,500 1,716 114% 3,000 731 24% 3,000 100% Miscellaneous - 1,896 2,000 - 0% 2,000 100% - Good Sam Membership Fee 2,561 1,500 189 13% 1,500 100%! - Good Sam Discounts (17,220) 999% (3,373) 999% - - TOTAL RESOURCES 358,600 488,285 136% ; 437,700 74,842 17% 437,700 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 298,870 276,007 92% 318,273 14,323 5% 318,273 100% Debt Service 223,101 223,101 100% 222,100 - 0% 222,100 100% TOTAL REQUIREMENTS 521,971 499,108 96% ; 540,373 14,323 3% 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% - TOTAL TRANSFERS 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,657 106% 32,657 Resources over Requirements (163,371) (10,823) (102,673) 60,520 (102,673) Net Transfers - In (Out) 160,000 160,000 (307,000) - (307,000) - TOTAL FUND BALANCE $ 315,629 $ 592,657 188% _ $ 150,327 $ 653,177 435% $ 182,984 122% $32,657 A 2,103 RV spaces, 64.01% utilization YTD. Prior year comparable was 2,670 RV spaces, 81.25% utilization YTD. VT Es C() FINANCE \CES C- a�`���`°�� Department -wide Summary 670 - Risk Management Grouping Activity thru July of Fiscal Year 2020 8.3% 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 109,134 9% 1,255,108 100% - General Liability 1,063,675 1,063,675 100% 1,072,326 87,957 8% 1,072,326 100% Property Damage 394,291 394,291 100% 392,923 32,994 8% 3929923 100% - Unemployment 280,921 297,540 106% 323,572 72,226 22% 323,572 100% Vehicle 195,250 195,250 100% 195,580 16,917 9% 195,580 100% - - Claims Reimbursement f 269,198 34,363 13% 150,000 25 0% 150,000 100%! - Interest on Investments f 85,000 148,890 175% 137,000 14,221 10% 137,000 100% Process Fee- Events/ Parades 1,800 1,575 88% 2,000 135 7% 2,000 100% Miscellaneous f 500 5 1% 500 - 0% 500 100% Loss Prevention f 30 30 100% 30 - 0% 30 100% - Skid Car Training f 32,000 44,910 140% f (34,000) 450 -1% (34,000) 100% TOTAL RESOURCES 3,569,944 3,454,346 97% 3,495,039 334,059 10% ; 3,495,039 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Workers' Compensation 1,360,000 1,013,256 75% 1,460,000 40,470 3% 1,460,000 100% General Liability 900,000 633,248 70% 1,400,000 140,195 10% 1,400,000 100% Insurance Administration 599,459 529,777 88% 592,059 42,605 7% 592,059 100% Property Damage 728,638 546,634 75% 400,236 206,967 52% 400,236 100% Vehicle 120,000 100,150 83% 150,000 9,344 6% 150,000 100% Unemployment 150,000 37,481 25% f 130,000 - 0% 130,000 100% TOTAL REQUIREMENTS 3,858,097 2,860,546 74% 4,132,295 439,581 11% 4,132,295 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out - Vehicle Replace (3,168) (3,168) 100% (6,918) - 0% (6,918) 100% TOTAL TRANSFERS (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,172,915 118% 1,072,915, Resources over Requirements (288,153) 593,800 (637,256) (105,523) (637,256) Net Transfers - In (Out) (3,168) (3,168) ! (6,918) - (6,918) TOTAL FUND BALANCE $ 5,308,679 $ 7,172,915 135% : $ 5,455,826 $ 7,067,393 130% $ 6,528,741 120%, $1,072,915: CS C'pG FINANCE JTES CO q`��� Department -wide Summary 675 - Health Benefits Grouping Activity thru July of Fiscal Year 2020 RESOURCES Internal Premium Charges COIC Premiums Retiree / COBRA Premiums Employee Co -Pay Interest Prescription Rebates Claims Reimbursement & Other TOTALRESOURCES 8.3% Year Complete Fiscal Year 2019 1 19,559,777 17,493,075 Fiscal Year 2020 Budget Actuals % Budget Actuals % Projection % $ Variance 17,054,563 18,051,440 106% 17,411,292 1,451,319 8% 17,411,292 100% - 1,834,000 1,794,789 98% 1,967,021 137,250 7% 1,967,021 100%! - 1,280,000 i 1,144,088 89% 1,433,000 77,312 5% 1,433,000 100% 963,000 1,016,748 106% 1,041,120 89,054 9% 1,041,120 100%! 2 220,000 366,207 166% 346,000 35,228 10% 346,000 100% 60,000 148,847 248% 75,000 - 0% 75,000 100%! 2 177,557 45,000 750 2% 45,000 100% 21,411,563 22,699,675 106% ; 22,318,433 1,790,912 8% ; 22,318,433 100% REQUIREMENTS Budget Actuals % Budget Actuals % Health Benefits 19,559,777 17,493,075 89% 18,550,836 178,406 1% Deschutes On -Site Pharmacy 2,284,744 2,514,018 110% 2,242,104 2,734 0% i Deschutes On -Site Clinic 1,114,864 1,045,557 94% 1,141,691 2,252 0% Wellness 184,870 158,364 86% 180,380 44 0% TOTAL REQUIREMENTS 23,144,255 21,211,014 92% ; 22,115,011 183,437 1% ; TOTAL: - - - FUND BALANCE Budget Actuals % Budget Actuals % Beginning Fund Balance 16,051,586 15,075,316 94% 16,106,294 16,563,976 103% Resources over Requirements (1,732,692) 1,488,661 203,422 1,607,475 Net Transfers - In (Out) - - - f � TOTAL FUND BALANCE $ 14,318,894 $ 16,563,976 116% $ 16,309,716 $ 18,171,452 111% A Amounts are paid 1 month in arrears ES CaG �� �� FINANCE Projection % $ Variance 18,550,836 100% A 2,242,104 100% A 1,141,691 100% A 180,380 100% A 22,115,011 100% ; Projection % $ Variance 16,563,976 103% 457,682: 203,422 $ 16,767,398 103% $457,682, �,�uTES Cpl Department -wide Summary 8.3% q� Year Complete 705 - 911 Grouping Activity thru July of Fiscal Year 2020 Fiscal Year 2019 Fiscal Year 2020 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current Yr 8,311,833 8,426,089 101% 8,809,419 - 0% 8,809,419 100% Telephone User Tax I 890,000 714,379 80% 900,000 - 0% 900,000 100% Police RMS User Fees 1 300,680 327,638 109% 250,000 5,870 2% 250,000 100% Interest 200,000 205,570 103% 157,000 16,103 10% 157,000 100% State Reimbursement 125,000 132,900 106% 125,000 15,000 12% 125,000 100% Property Taxes - Prior Yr 110,000 108,419 99% 100,000 21,576 22% 100,000 100% User Fee 1 180,000 126,144 70% 73,680 15,836 21% 73,680 100% Data Network Reimbursement 50,000 106,592 213% 55,000 - 0% 55,000 100% Contract Payments 51,300 175 0% 51,300 - 0% 51,300 100% � t Property Taxes - Jefferson Co. 30,000 33,453 112% 30,000 141 0% 30,000 100% Miscellaneous k 11,200 38,757 346% 1 11,951 695 6% 11,951 100% - TOTAL RESOURCES k 10,260,013 10,220,116 100% ; 10,563,350 75,221 1% 10,563,350 100% ; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,646,307 6,743,116 88% 7,462,575 619,025 8% 6,867,828 92% 594,747, A Materials and Services 1 3,370,357 3,297,149 98% 3,387,761 538,431 16% 3,387,761 100% Capital Outlay 2,362,400 539,146 23% 1 1,400,000 - 0% 1,400,000 100% TOTAL REQUIREMENTS 13,379,064 10,579,411 79% 12,250,336 1,157,456 9% 11,655,589 95% 594,747; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 8,625,000 8,660,615 100% F 7,753,706 8,301,320 107% 8,301,320 107% 547,614, Resources over Requirements 1 (3,119,051) k (359,295) F i (1,686,986) (1,082,235) 1 (1,092,239) 1 1 594,747; k Net Transfers - In (Out) - - - 1 k 1 k TOTAL FUND BALANCE $ 5,505,949 $ 8,301,320 151% $ 6,066,720 $ 7,219,085 119% $ 7,209,081 119%, $1,142,361, A Projected Personnel savings based on FY19 average vacancy rate of 9.0% 0") C,0 FINANCE