The URL can be used to link to this page

2023-116-Minutes for Meeting March 20,2023 Recorded 4/3/2023Recorded in Deschutes County Steve Dennison, County Clerk CJ2023-116 Commissioners' ,journal 04/03/2023 10:21:14 AM \,\�'ras coif II'll�'I�I'�II'I�II� 2023-116 II �I I II I'II Do not remove this page from original document. Deschutes County Clerk Certificate Page ��`�vS E S _'61 BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS MEETING 1:00 PM, MONDAY, MARCH 20, 2023 Allen Room - Deschutes Services Building - 1300 NW Wall St - Bend (541) 388-6570 1 www.deschutes.org MEETING FORMAT: In accordance with Oregon state law, this meeting is open to the public and can be accessed and attended in person or remotely, with the exception of any executive session. Members of the public may view the meeting in real time via YouTube using this link: http://bit.ly/3mminzy. To view the meeting via Zoom, see below. Citizen Input: The public may comment on any topic that is not on the current agenda. Comments and testimony regarding public hearings are allowed at the time of the public hearing. Alternatively, comments may be submitted on any topic at any time by emailing citizeninput@deschutes.org or leaving a voice message at 541-385-1734. When in -person comment from the public is allowed at the meeting, public comment will also be allowed via computer, phone or other virtual means. Zoom Meeting Information: This meeting may be accessed via Zoom using a phone or computer. • To join the meeting from a computer, copy and paste this link: bit.ly/3h3ogdD. • To join by phone, call 253-215-8782 and enter webinar ID # 899 4635 9970 followed by the passcode 013510. • If joining by a browser, use the raise hand icon to indicate you would like to provide public comment, if and when allowed. If using a phone, press *6 to indicate you would like to speak and *9 to unmute yourself when you are called on. 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, call (541) 388-6572 or email brenda.fritsvold@deschutes.org. CALL TO ORDER CITIZEN INPUT: Citizen Input may be provided as comment on any topic that is not on the agenda. Note: In addition to the option of providing in -person comments at the meeting, citizen input comments may be emailed to citizeninput@deschutes.org or you may leave a brief voicemail at 541.385.1734. AGENDA ITEMS 1. 1:05 PM Department Performance Measures Updates for Q2 2. 1:30 PM Update on Redmond Safe Parking Program 3. 1:40 PM Treasury Report for February 2023 4. 1:50 PM Consideration of revisions to the County's Investment Policy 5. 1:55 PM Finance Report for February 2023 6. 2:10 PM Environmental Health Fees and FY 2024 Budget 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. 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. ADJOURN March 20, 2023 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 2 \�I Es BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 1:00 PM BOCC MEETING MINUTES MONDAY March 20, 2023 Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Anthony DeBone, Patti Adair and Phil Chang. Also present were Whitney Hale, Deputy County Administrator; Kim Riley, Assistant County Counsel; and Angie Powers, Board Administrative Assistant. This meeting was audio and video recorded and can be accessed at the Deschutes County Meeting Portal website www.deschutes.org/meetings. CALL TO ORDER: Chair DeBone called the meeting to order at 1:00 p.m. CITIZEN INPUT: None provided. AGENDA ITEMS: 1. Department Performance Measures Updates for Q2 Jen Patterson, Strategic Initiatives Manager, provided a brief update on progress made towards Q2 department performance measures by the following departments: 9-1-1, Community Development, Community Justice and the District Attorney's Office. This update provides a snapshot of departmental progress towards performance measures. This performance measure's objective was Safe Communities - Reduce crime and recidivism through prevention, intervention, supervision and enforcement. BOCC MEETING MARCH 20, 2023 PAGE 1 OF 7 Megan Craig and Chris Perry provided the update for 9-1-1. Commissioner Chang asked how many 9-1-1 calls are related to behavioral health crisis, and also about the 9-8-8 mental health crisis hotline. Mr. Perry didn't have specific data to share at this time, but explained that calls to 9-8-8 are routed to a call center and answered by clinicians all over the U.S., some of whom are located in Oregon. Commissioner Adair added that 9-1-1 is still short 7 employees, and staffing continues to be a challenge. She thanked Mr. Perry and Ms. Craig for their extraordinary teamwork. Peter Gutowsky and Angie Havinear with Community Development provided a summary of their department's progress. Staffing, retention and training have presented unique challenges in meeting the measures. Commissioner Chang asked about voluntary compliance and prompt compliance, and if there is a trade-off between the two types of compliance. Homeowners sign an acknowledgement that they are in violation, and progress is measured from the date the complaint is made to the date the homeowner comes into compliance, and this can take up to a year. Mr. Gutowsky commended Ms. Havinear's leadership and her collaboration with the Sheriff's Office towards abatement. Legal processes and procedures towards code compliance are complex and her department must navigate the system while being transparent and forthright. Tanner Wark provided a summary of the Community Justice department's progress. Commissioner Chang said that it would be helpful to see numbers extrapolated out beyond 60 days. Based on a number of factors related to the population with whom the department works, Mr. Wark explained that it is unlikely to reach 100%. Commissioner Adair spoke to the increasing number of vehicle thefts in our area. Mr. Wark highlighted his department's skill -building exercises, in response to Commissioner Chang's question about metrics. Responding to Commissioner DeBone, Mr. Wark said that 75% is an attainable target for criminogenic risk assessments. Kathleen Meehan -Coop presented the District Attorney's Office progress. She spoke about two of her department's programs: Veterans Intervention Strategy (VIS) and the Emerging Adult Program (EAP), adding that her department's goals are largely recidivism -based. Responding to Commissioner Chang, Ms. Meehan - Coop explained that "revocation" means that the participant in the program has not followed the program plan or has committed another crime and were removed from the program due to non-compliance. Both of these programs have had great results. The EAP program was a pilot program with Criminal Justice Commission (QC) state funding. BOCC MEETING MARCH 20, 2023 PAGE 2 OF 7 Commissioner DeBone expressed disappointment that our county's drug treatment court is going away. Commissioner Adair shared that 12 people from Veteran's Village have transitioned to more permanent housing. 2. Update on Redmond Safe Parking Program Kristie Bollinger, Property Manager, introduced Rick Russell and Sierra Hopper with Mountain View Community Development. Some amenities provided for Safe Parking sites are: portable toilets, clean water, garbage service and electricity. Employment support and access to healthcare are some services that are often provided. Mr. Russell asked for support to increase the number of vehicles at the Redmond Safe Parking (located at SE 71h @ SE Evergreen) site on county -owned land from 4 to 6, and to extend the term of the lease for one year. He shared that there is no unauthorized camping allowed within 500 feet of Safe Parking sites. One neighbor complaint has been received, in connection with speeding vehicles to/from the site. Mr. Russell provided a map of the areas where previous Safe Parking program participants had been parked/camping prior to the Safe Parking participation. Currently the program as a whole has 11 spaces in total, but they hope to reach 39. He provided some input towards a proposed County ordinance on Safe Parking, and suggested the County operate the program similar to how the City of Redmond operates while also acknowledging that there may be additional land use issues in the unincorporated county. Ms. Hopper shared some case studies about individuals who have benefitted from participation in the Safe Parking program, adding that there is a 90-day limit on participation in the program. Their waitlist is first -come, first -served, and certain requirements must be met. Typically, they have approximately ten people waiting, but they are constantly filling the spaces and don't leave them empty for long. Redmond City Councilor Kathryn Osborne shared the story of her friend "Jill," a close personal friend who is homeless. Jill is a single mom with a special needs daughter and a baby. When they met, they were not a city councilor and a homeless single mom. The Safe Parking program was an opportunity for her and her children. She now has a job, a bank account and an Oregon photo ID. Responding to Commissioner Chang's question about whether the Redmond Police Department has seen an increase in incidents of crime due to the Safe Parking site, Mr. Russell said that, aside from an RV being parked within 500 feet of the site and neighbor concerns about speeding vehicles, he's unaware of additional concerns. BOCC MEETING MARCH 20, 2023 PAGE 3 OF 7 Mr. Russell shared that $300,000 to $350,000 is the annual funding required for their continued operations. Unfortunately, Recreational Vehicles do not meet the state's definition of "shelter", so this poses a challenge for acquiring longer term state funding to make Safe Parking a sustainable program. Commissioner DeBone acknowledged that this County -owned property was removed from the auction list to be designated as a Safe Parking site. He asked about Board support for routing these types of requests through the Coordinated Houseless Response Office (CHRO) and Cheyenne Purrington, Houseless Strategies and Solutions Director. Commissioner Adair spoke about many opportunities in our region for making progress towards tackling homelessness in Central Oregon. Commissioner Chang urged the Board to engage with HB 2001, the governor's houseless package, early on in the legislative session, to increase the likelihood that they'd be receptive to considering the classification of RVs as "shelter". The Board expressed overall support for increasing the number of spaces from 4 to 6, and for extending the ground lease one year. Kristie Bollinger, Deschutes County Property Manager, will come to the Board with a Consent Agenda item next week. 3. Treasury Report for February 2023 Bill Kuhn, Treasurer, presented the highlights from the February 2023 treasury report. He spoke at a high level, about the recent bank failures in the media, much attributed to asset management oversight and dramatic interest rate increases catching bank management off -guard. These national events have local impacts. He stressed that all of the County's bank deposits are collateralized to protect against losses, and not reliant on FDIC insurance. The Federal government has very few tools to fight inflation, and raising short-term interest rates is their main one. Responding to Commissioner Adair about the LGIP being down to $31.5 million, Mr. Kuhn explained that we are in the process of building our short-term liquidity back up. Mr. Kuhn is focusing on preservation of capital in light of the recent bank failures, and the County is in close contact with our Investment Brokers. At a high level, the County's portfolio balance at the end of February was $319 million and investment earnings were $540,627 (higher than last month and this month last year). Average portfolio yield was higher, at 2.28% (January 2023 was 2.23%). The yield is being calculated on a weighted average time to maturity, BOCC MEETING MARCH 20, 2023 PAGE 4 OF 7 4. 5. which is more accurate. The County has maximum flexibility in a time of market volatility. Consideration of revisions to the County's Investment Policy Mr. Kuhn summarized two proposed revisions to the County's Investment Policy: ■ Remove a reference to 294.085 which was repealed in 2015. 294.145(1) references to make a commitment to invest funds or sell securities more than 14 business days prior to the anticipated date of settlement of the purchase or sale transaction. Deschutes County's policy references 21 calendar days. Adjusting the County's policy to align with ORS standards. CHANG: Move approval of County Administrator signature on revised County Investment Policy F-10. ADAIR: Second VOTE: CHANG: Yes ADAIR: Yes DEBONE: Chair votes yes. Motion carried. Finance Report for February 2023 Robert Tintle, CFO, presented the key points from the February 2023 finance report. For the month of February 2023, 3.5 FTEs were added. Revenue YTD in the General Fund is $40 million or 91.5% of budget (last year's was $37.1 million and 91 % of budget). Expenses YTD are $28.7 million or 63.3% of budget. Mr. Tintle highlighted that many of the County's larger departments experienced vacancy savings due to unfilled positions. 6. Environmental Health Fees and FY 2024 Budget Tom Kuhn, Community Health Manager (via Zoom) and Eric Mone, Environmental Health (EH) Supervisor, provided an update to the Board on current activity in the Environmental Health program. Cheryl Smallman and Arielle Samuel were also in attendance to answer any budget -related questions. He explained the budget and fees for the Environmental Health division of the Health Department. Environmental Health inspects restaurants, mobile food carts, pools/spas, hotels/motels/RV parks/campgrounds, temporary restaurants (Winter Fest, Munch'n Music, etc.), public water systems, childcare facilities and school lunch programs. Restaurant fees make up 57% of EH's revenue. They have seen a dramatic rise in the number of mobile food carts and food cart "pods" or lots over the past decade. Ideally, these mobile food cart pods have city services BOCC MEETING MARCH 20, 2023 PAGE 5 OF 7 for water supply to encourage frequent handwashing and proper dishwashing. They have also seen a large increase in the number of temporary restaurants, and a slight uptick in the number of food/pool/lodging issued licenses. Currently, the number of FTE inspectors does not meet the FDA Program Standards for staffing ratios. Currently, 4.95 FTE food service inspectors are projected to have 494 annual inspections per 1.0 FTE and the FDA recommends 280 to 320 inspections per 1.0 FTE. Mr. Kuhn said that to balance the budget, staff suggests one of three options for the FY 24 budget: ■ Adjust fees to increase with CPI at 6.4% and continue to allocate TRT (Transient Room Tax) at FY 23 level ($418,417) Increase inspection fees by 37% and provide no additional TRT or CGF (County General Fund) Increase fees by 10% and consider reduction of TRT by $50,000, or keep TRT level and use to offset increased expenditures in future years In response to a question from Commissioner DeBone about the start-up cost of mobile food cart permit fees, Mr. Mone shared that Deschutes County ranks 7tn highest in the state. Commissioners DeBone and Chang were supportive of the third bullet point (increasing fees by 10% and consider reduction of TRT by $50,000), while Commissioner Adair was supportive of the first bullet point (increasing fees 6.4% and continuing to allocate TRT at FY 23 level). The Board directed staff to proceed as directed with bullet point three guiding EH's FY 24 budget. OTHER ITEMS: Commissioner Chang met with the Solid Waste department and Bureau of Land Management (BLM) to discuss potential BLM land conveyance opportunities in relation to the new landfill siting. A land exchange would be more feasible from BLM's standpoint. Congressionally -directed land exchanges can occur quickly and no exchange of money is necessary. Commissioner Chang spoke at the Wildfire Workshop in Klamath Falls last week. The topic of his presentation was the Skeleton and Awbrey Hall fires, and the community's growing fatigue over topics related to wildfire resiliency and community wildfire protection work. Commissioner DeBone testified in front of the joint Committee on Semiconductors, in support of Redmond's industrial land inside the UGB for this purpose. BOCC MEETING MARCH 20, 2023 PAGE 6 OF 7 • Commissioner DeBone discussed a Capital Outlay Expenditure Authorization Form from Finance which required his signature. Ms. Hale clarified that the funds were budgeted but expenditures required reclassification. • Commissioner DeBone attended a tour with the Wildfire Leadership Council in Klamath Falls. Inclement weather required the tour to take place virtually. • Commissioner DeBone remotely attended the Sunriver La Pine Economic Development (SLED) meeting • Commissioner Adair attended a tour of the Bend Airport. • Commissioner Adair attended an art event in Sunriver in support of youth behavioral health. • Whitney Hale discussed the upcoming REDI luncheon. • Commissioner Chang spoke about legislation relative to a water/drought package, and suggested it may be worth taking a serious look at this bill, and how it impacts Deschutes County. Commissioner DeBone suggested adding this as an agenda item at a future meeting. Ms. Hale will work with Doug Riggs on scheduling this item. ADJOURN: Being no further items to come before the Board, the meeting was adjourned at 3:52 p.m. DATED this Day of _�llN`-r d^— 2023 for the Deschutes County Board of Commissioners. ANTHONY DEBONE, CHAIR ATTEST: —P odia PATTI ADAIR, VICE CHAIR PHIL CHANG, COMM-SIGNER BOCC MEETING MARCH 20, 2023 PAGE 7 OF 7 E S COG2,A BOARD 1301 1L MEETING DATE: March 20, 2023 SUBJECT: Department Performance Measures Updates for Q2 RECOMMENDED MOTION: N/A BACKGROUND AND POLICY IMPLICATIONS: Four departments have been selected to provide updates on progress made during Q2 on selected performance measures that fall under the County goal of Safe Communities. 9=9 e1 Objective: Safe Communities ® Provide safe and secure communities through coordinated public safety and crisis management services Performance Measure: Develop partnerships with existing and future behavioral health crises programs locally and statewide alongside local law enforcement to implement a more effective response and service delivery to mental health crisis. Target: True Q2 Update: Continuing engagement with 988 to understand and develop work flows to transferring and receiving calls from those crisis centers. Also working closely with DCBH on development of non -law enforcement crisis response for potential go -live in Q4 this year. Community Development Objective: Safe Communities - Provide safe and secure communities through coordinated public safety and crisis management services Performance Measure: Achieve 85% resolution of Code Compliance cases within 12 months. Target: 85% Q2 Update: 67% - The team continues to revise current processes to ensure efficient and effective service delivery. Staff new to the team continue to train on processes and procedures. Objective: Safe Communities - Provide safe and secure communities through coordinated public safety and crisis management services Performance Measure: Achieve 90% voluntary compliance in Code Compliance cases. Target: 90% Q2 Update: 91.5% - The team continues to revise current processes to ensure efficient and effective service delivery. Staff new to the team continue to train on processes and procedures. Community Justice Objective: Safe Communities - Reduce crime and recidivism through prevention, intervention, supervision, and enforcement Performance Measure: Adult PO's ensure supervised adults have active and updated Behavior Change Plans. Target: 75% Q2 Update: 76% Objective: Safe Communities - Reduce crime and recidivism through prevention, intervention, supervision, and enforcement Performance Measure: Supervised adults receive criminogenic risk assessments within 60 days of admission. Target: 75% Q2 Update: 72% District Attorney Objective: Safe Communities - Reduce crime and recidivism through prevention, intervention, supervision, and enforcement Performance Measure: A 2018 study of veteran treatment courts indicates that 14% of participating veterans, in a veteran's treatment court, experienced a new incarceration. Goal is to maintain a number of no greater than 20%. Most veteran court programs across the nation only engage with veterans with misdemeanor crimes, VIS allows veterans with felonies as well. Target: 20% Q2 Update: 14% - Two-year incarceration recidivism rate Objective: Safe Communities - Reduce crime and recidivism through prevention, intervention, supervision, and enforcement Performance Measure: Currently the long-term, one-year average recidivism rate for 18-30 year olds in Deschutes County is 54.2%. Goal is to maintain a one-year recidivism rate for all enrolled EAP participants (18-24 year olds) of 35% or less. Target: 35% Q2 Update: 18% - One-year arrest recidivism rate BUDGET IMPACTS: No anticipated budget impact. ATTENDANCE: Jen Patterson, Strategic Initiatives Manager Chris Perry, Manager, 9-1-1 Operations Megan Craig, Manager, 9-1-1 Training Angie Havniear, Administrative Manager, Community Development Tanner Wark, Deputy Director for Adult P & P, Community Justice Kathleen Meehan -Coop, District Attorney's Office \31 ES c0G�� BOARD OF COMMISSIONERS MEETING DATE: March 20, 2023 SUBJECT: Update on Redmond Safe Parking Program RECOMMENDED MOTION: Direct staff to return with a consent agenda item to authorize a one-year extension of the ground lease with Mountain View Community Development to utilize County -owned property for a safe parking site in Redmond. BACKGROUND AND POLICY IMPLICATIONS: In December 2022, the Board authorized a ground lease on a 90-day trial period with Mountain View Community Development (MVCD) to utilize County -owned property located at SE 7`" Street and SE Evergreen Avenue for the Redmond Safe Parking Program (program). Prior to the end of the 90 days, MVCD agreed to provide an update including successes and any challenges or incidents related to the program. Because of delays related to acquiring the required insurance documents, MVCD did not mobilize the first participant to the program until the first week of January. As the adjusted 90-day trial period is approaching, MVCD will provide a program update. If the Board supports continued use of this property for the safe parking program, staff will return with a Consent Agenda item to memorialize a one-year extension of the ground lease. BUDGET IMPACTS: None ATTENDANCE: Kristie Bollinger, Property Manager Rick Russell and Sierra Hopper, Mountain View Community Development 7 T =,,:if If 1111111--'Jil 'Sw Or a Ft L O -r-+ M L N . C6 cr L- O � U CCS Chi O U (,o O Cll > U U) Q >, cn O Cll C -0 j .> O -0 ILW _ N U t� L O 4-4 .� L U_ OD N V U L � U 06 N � (U O i � >1 C U 0 N C6 t6 cn � N C U (Ci to L N a) E N co N U O O 'U (a cn .� L }, a)Z3 p C: O :3 O O U cn i> j= Q w Q 0 Q u N U) U) m CL i O O LO .0�. E CIO U (D 'i O • T- O N N Q U) O N 11 f thin WON H. i ea :O'er ♦ � �»� av t :r r � (6 O p � O O O � O N .� co � U i Q LO d .T .� L- a� -.°--cm aD O O O CO E CL a� N to � O � C6 U— E N .� uj 0 O O cn N 0 E a) O U L -'>1 � -� C O O =3 O U 0 0 Z O MEETING DATE: March 20, 2023 SUBJECT: Treasury Report for February 2023 ATTENDANCE: Bill Kuhn, County Treasurer ES Ale. fix• -� MEMORANDUM DATE: March 10, 2023 TO: Board of County Commissioners FROM: Bill Kuhn, Treasurer SUBJECT: Treasury Report for February 2023 Following is the unaudited monthly treasury report for fiscal year to date (YTD) as of February 28, 2023. Treasury and Investments • The portfolio balance at the end of February was $319.4 million, an increase of $1.1 million from January and an increase of $41.8 million from last year (February 2022). • Net investment income for February was $540,627 approximately $21K more than last month and $364K more than February 2022. YTD earnings of $3,087,805 are $1.4 million more than the YTD earnings last year. • All portfolio category balances are within policy limits. • The LGIP interest rate remained at 3.75% throughout the month of February. Benchmark returns for 24-month treasuries are up from the prior month by 60 basis points and 36-month treasuries are up from the prior month by 61 basis points. • Average portfolio yield is 2.28% which is higher than the prior month's average of 2.23%. The portfolio weighted average time to maturity is 1..27 years compared to 1.34 it i January. y. Municipal Debt $ 47.350,000 14.8% Corporate Notes 48,321,000 15.1% Time Certificates 1,245,000 0.40A U.S. Treasuries 67,000,000 21.0% Federal Agencies 112,965,000 35.4% LGIP 31,169,479 9.8% First Interstate Sank 11,314,978 3.50% Total Investments $ 319,365,457 100.00/6 �#�Cffc�io.bY:SnQker' w $100 $92.4 o $80 $60 $45.7 $47.0 $47.8 $40 $32.4 $20 $11.5 $- DA Robert W Great Moreton Piper Castte Oak Davidson Baird & Co Pacific Capital Sandier Securities Markets Feb-23 Total Investment Income $ 545,627 $ 3127,805 Less Fee: $5,000 per month (5,000) 40,000 Investment Income - Net $ 540,627 $ 3,087,805 Prior Year Comparison Feb-22 $ 176,794 $ 1,698,637 �;�Eg�?ry 1t1111i1'JS , U.S. Treasuries 100% LGIP ($56,763,000) 10001. Federal Agencies 100010 Bankers Acceptances 25% Time Certificates 50% Municipal Debt 250A Corporate Debt 25%, Current Month Prior Month FIB/ LGIP 3.751% 3.75% Investments 2.051% 2.051/6 Average 2.281% 2.23% ,.. $�t1CI1jfliiltS` �24 Month Treasury 4.81% LGIP Rate 3.75% imam ears , 36 Month Treasury 4.51% Max Weighted Average 3.71 1.27 fiet?�?,, Mtttttum Actual' � 0 to 30 Days 10% 15.6% Under 1 Year 25% 42.3% Under 5 Years 100% 100.0% 24 Month Historic Investment Returns 5.50% 5.00% ------------ 4.50% 4.00% 0ow- 3.50% 3,00% 2.50% . . . . . . . . . . . . . . . . . 2.00% 1.50% 1.00% 0.50% 0100% . ... . .. .... Feb Apr Jun Aug Oct Dec Feb Apr Jun Aug Oct Dec Feb - County Rate - 2 Year Treasury Rate - Corporate Bond Rate - LGIP Rate Three Year Portfolio Balance O 010OI010 O O0 OOOOI0 '0.o1000OO1 0J O O0000(0p '0'.W 0.O(11 0A O.�i;��i0O ImQ '!O.� OWOOWjJIW :JJ;0O OOOV DO 0D0WJJOD: WWj O) N O JIO) cn'W W W WO DAW N N J V OO) T AW OiOO OI 0,ANN OoiO) 01.,OW 00 NicD W O iV0V W 8U I1 j100 N A 0DA:: fiI T T T TTT T TT , T TT ,jTTI , T m T,TI-n -niT T�TTI ICO O S0 . ItC"o 2 IT ID D D'I Dn D!D DDD DIDD'D ' nDiDC) nDp n nOpC�)�O n �0�D O10 0I0 (p S�IOW OO, O O , < i0 �m wi-w w w w_,, 'W W W W W WIW W W W WjW W W W W W W W w w w W�w wlw_'w_iw w'w'wi�l� w1wl��w ww_ w w_Iw_'Iw_�w_ w_ w_' t (D�00 V C.) � �. ,I�i „� y' IW W'W W W WIW W WIW W W W W W W WiW W Cl) WiW WIWIWIW W W W'',,WIWIW w;W W W!WI W- -W W.W:. WIWIW WIW W:.W W W WIA WIN M'.0 ;m w.IN ''H 'IN NIUt O) WIW O) O)IW 0) JJA A A A,VIA A A;V A010 O O O O:O O O O OD W WI WIwIWiW W WWW IW W W WW W W W N A W D. W olo Dp a a:A A �;'a p DID'{ G� X L�;mDG� O L�!D G� D CDaio D:D-DI D fDn UDi!�',Z ZIZ Z1� mT. ZZ� 3 �'� �� X �'� D �G,j�f�1 `2 l2!m (�' '3 c < W z x Z ��(( r, Zl,m m m A *!� z C ,'pIT ut zlz',oIW O r cIC) (� U (A m Z;fA G) mlm -I Z r'r p w W:Oo w;0 z V N J IV 0o V J C iC N �fNIUt W �,C Z cil ":j m N <Ip J ALZ7!< NIZ=� O) J O)IW C] iW v.m z12 A I.W O A A.A A A AIA W W.,,A G Cop N- N N tO lIJ -' co Ot O V`(O OO W W;V fn JAW V' O) �.,�W W SIo IIN Mj (oIJ W AA V A W:,O O A A .� J ._- - ' ' T T T T T T CL T T T T T T T T T T T T T T- T -n T�TIT �l T T TIT T T T T � [n G� W IT T12 n Q nlTlm m m im m m m m m m mIm N N N N N N N N N N N N N N N N N NIN N N N W N N N N f0 N N N NIN IN N N N N N N N N m O D lain nla ID a a;a a ally a a n 0 a1n n�a a s ajn n a M IM im n a. :n a a n a a a n n �I j r'.0 C CID m m m m m m m m m m m m m m m m m m m m mlmlm m m mi 1 O O O O:N Im Im m N (D N N N W NIN N N (D :N W N tD (0 Ir; < Id d'd Id d did IN d d d 0) d d d �N Id d d Id d d'N N d d d d d d d d d d d d d d d d d d d d d d d N d d d d F-n ---I-I- --- - - - - - - D -II 2.2 22 x xISI: ZZ Z Z.ZZ Z ZIZZ S;SId S S 2:25 2 2i212 2 2 2: T T Tm T.T T:T T T,mIT T!T T'D Z'DI 0 N N d q) 0') did d!did d Ind 0 O o 0;0!0 0 0 0 O,O 0 0 0 0 0 0j0 0l0 010 d d d d d did:d d did d d d d1O �T�II z; 0 0 o 0"0 010 0'l0 m m m m mIm m'm Im !m'm m Im m 3:33 3 I3 :3 3 3 3'3 3 3 3'13 3 3''3I10 c ziml(nl Im m jm Im m m 1 Io jN :m Dz Inl (A D :D r r rlr,rlr r rrr r r rir r r r r r r r'r n Q 0 n 0 60 0 0 n-nlnn'n O10 O n:� �03 000 010;0,0 0 0 0:0 0 0010 0 oIo 0 0 �� m m m'm m m m m' mm mm m ml� �I�I� �II� g 3 �I�Id d;d d w ;d Id w,w':w'd d d d d d Id Id d d d!d n n a n a a a a m a'la MIO-Im �. n n nm 0 Ix3 _ m ro ,O �o an lO '�o�vol y ggl��I3�;�3�313�3mmmmma 0)a)0) WmaoWoo!aoaocomWwlwaocom!mcolco03 r d d d d d d j d d d d d d d d d d d d d d d 10) d d d d d d d [n a z a E V% m C I� 0 !a i0 3 3 3 3 3 3 3 3 13 3 3 3 :1"3 3 3 3 1 3 3 3 3 w N N (/) V) N w 0 W I, '� 3 ;3I3 3 3 3 ci i� n n'': �: 0 plpn n F F'I JCIJC T. Or=� F T. >r 1, >< 7< 1C; 7C 7r ><:>Ti T.' 7C' 7C,7C'IO G)i :3 13 I3 113 �i�Ic: 0,010 O O O':O O Rig O ro'I'o a !. z i I I 1 1 1-, , , GY Q�� O A-0A 3 n X10 Oi(�i(� (� 0 Q mi 7 O Ll n t�'(� (� 0 0 X (� O v m O 0 010 0 O G� Ip D 3 31 A OO m!(� A O O O:D D p O O-D ID D D D D D (A'D D D D.D D p p D D`D DlvI> D D p p D p v v -o mom y m cn:� O� y�(nmmto> IOC to C) ;u O p p!0 0 I O `e cA rn to to y D `< too (A �;D D D D,D D '� O �I m -I' 1 :'� .-III-I:�,D p:r W 07 r W r m r r m:mlr W1r r rir r � m W W DI I� ��:D _m W r�-'i� O pIW 1- D m W p n n,nln nC m m m �Im m (I m: ,m m m mlm,m ml I�,1 <, ''Im m m r< m �I`+I m,mlm m m< m ZI ZIZ 1 Z: ! Iz!Z ZI m IWw IW I':J V ��IW W �'C.N WIN W--� NNIN O �!N W N'N N N'.:D w N N"� NN WINIO WIW: � ViV N WIN) NN N N':.W W N A W W,` OD 00 O ODO 00 Ut OD O O (DMA O W W V` W 0 01 W O A (`.0 O,fO W A w1t0 O) N100 O) N NI(Ii (`1I N-00 O 0 . N N N N N N NIN N N N N N N.N N N N N N N N N N N-N N N N N N N Ni NIN N N N N N N'N N N N N N N'IN NIN N'N NIN N:N N N NIN Np 010 0 0 0 0 N N N N N N N N N N N N N N NIN N N N N N N N NIN N N N N N N N N N S lu O) N N N N N N N N N N N I i0 N N N N N N N O OI0 0� O�O OHO O O O O O N N N N 0 0 0 CD! 0 0 0 N N N N N N N N N N INN NIN N N N - �'I m l - ` ' \N ODIWW W 001W J (O O O OIfO WN W o N!O (O O,J J OtiV N JN'W 0 � � ` ` N» N N:N N NIN � N N N - N N �D 401� N O N N.N V N N N ��. N �,� A NIN C N N N'.N W jP �I� N:N W 0 d W 0)..N (TW`'I O) 0 00 (OIA N CO O). CO A ` V'10J 01 (J) OOIW (\ W AIV �I"A (`) A W(O D) N WIN !r N N'N N (J`l N:(O O N N N N NIN N N NjN N N NIN N N'N N N NIN N N N N N N N!N N N NIN N N N.'N N N:N IN N'N''N N N N.N NIN NIN C: 000000000 0000,0000,0000 O N N N N N N N N N N N N N N N N N N N N N N' N N N N N N N N N N N N N NIA N N N N NNN=N NIN N N N N N N NI_-, A NI M. M w 0)_,. U) (P A. (Ji A A W N A N W 0t N W W WIW A A A W (n A A W _ -O , .� yN A W 0) N O) WIN N _ W W W W A A A A ' W A N W W A{? A . ' _ A .- . IN 3 O I W (O O U(Oo(0 Oo O:J CO (0 0 i00 0'N)(O'Nii(nN� O(A O)Nn 0 OD U W)OO)I WO ' IDd IdD C NI !• II OuVO OWNO ON -10N(O'n N JD �1WW W ON to A ON CID W O OVWIT 0) WIVINO N(O W UAN OW(OOW CO) J iD +. D yy ;dD 1-dy ddD Dd dD dD dD dD oDi D6i D5i �i d 611Nd yp) �d ;;07 hl d Slid _._. 0) 0) d d iw d d d) 0) 0a) 0) d d d I. dd dd d d IN 0) d d d d d d 11 0. m d' g11g1ggglgggllggggg g g gg�g. O O :O O OI,O W W '.O O'W IO O O'I,O O I A :L] W AAA N W,O -� A A ,� N O W'.o O O O 0 O 010 O 0 1 0 0 O N OIL O.� O N!N J J� 01 W J N AIIA A1N � J J J J O N W ,AiO) w V V;W N N-N N A V A N W W'-+ o Ln inlN (n 0) U M N N V1I (It (7) Q) O) O).m O) J O): ., , ;_- I 0) 0t . _ .. 0) W J✓rINN 0)'0)NO)Ot.N O) N10A V W NN OtN �'� m O.. :7 ,I O O O O O O O A A U):W O O10 0 0 A A A U) W W W W A A WIO 0 O O I O O O NI•(WO i w N fh 1,W N O)I U)'• 'P A N -W A N W W ._4 Ot0 � 3 UW) l,W OIJI (n1O � O (NO ':.N v �.(VO N) N OW) v �,:V �.tl) W O) W N J' N 4) O A Ut - OjN (O O:(7)00 !O) W 00.0 00 NO) AO J W J C W AJ W 0OIA� O IN) (4,00 OOIOON (O00 .A W `00 NI(O O O O O OI O (O (J N N.O _ W� O.O J w N ,P J J W f0 O O) -� i W J 0 0 0 OO W O c0=0 O) iWl (D O IOO N 00 W (m cm W O V V W N W W W D)N O) a,.m W :. (7t OtIA W W 0U)o(OI O V OOIV j0000p) O) A N NIOiN O NI(t) (O 0 A (1) 00 4:(0 A O) A'A co O AIW N O �I'(I) J O) O100 O O J': A m,co N iw V-j Mk( W'Oo'W N 0tiin O) (T Ln V7 G) W (n J O un W W V OO V) 0) V N - O7 00 A N WI-' A (D;N f00); l0)I� V WiA A fn Ut(J) N W; - ��W N:w�� N N N NiN N N -NIN O OO 0 0 OIO OIO:O A 0 0 0 O O O;O (7) O �O O O O:00 O O O O'Q) O O Jt-O Ol Ok0 (7) 0 010 O O)O'IO OHO-O'.OIN N N:N N 0�I �` O!O O O Oi0 O O. O'O O O O'IO O Oi0 O O OI,O O O O!A O cn O10 O O OIV O O O'I,O O'O10'OI OIO O O O:O'10 O O O'O A A A'A A O'O O O oi0 oI0 oio O 0.010 o O:o O o OI,O O Ol0'0 o U) olo!0 0l0 _O o o;olo:o o'i010 !pip PPp Ol0 oIo o-_O (O (O (O,(O to 00000010000000000!000 00000000000!0000001000000 d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O'O o 0 oIo 0 0 0 0 o 0 0 0 0 O'O 0 0 0 0 0 oIo 0 0 0 Ot0 0 Oi0�0�0 O O oIo O oIo 0 0 0 0 0�010 0 0 070 0 oIo 0 0 0 0 0 0 0 0 CIO 0*o 0 o oro it y W 00JJ DV NJW 0JO1o CO 0N (O (O O)'(OOA OI0000 NW (On81O1 0A0W OWWWNIW(OO , (A O0 W 0A'W POD Oo((0(OA W iw O O0n0OW m -D0 CON _OWJ J1W W N nIlJ 0 O IV1W N4N �vO n;OO JJm�0 WOl��WA ww0NJAWWJIW0N0,:,,,JN ON Wi00 V(7)O'NOO O O JODN m_(O`WWN11 co(O (W NOOO O1NIO m (O �W J iI, .;1 1 , N N _W W NI 0 0!(DiOOO_'OA000OO0(OO000 oO(0 O,(0IAO!O (0O (O O O IO NCdm W3d - OOONANOWIOI0OO;O O N V OO(DOJW OO Op NODf0 t101O fl 0OO OW 0OlO'O (O0O10(000 OO JOOOO_Olo OO OOUNOOW_OOOOO 7V OOOO1 0N00 NW O'OOCOIOIIO00N'OIO W AOoIW O Oi0 O OAO:nV coJO O O'O O OO1O O :m N O0 OIODNO{JO O N1OoINW O O o:oO00 tcn 0 I AIA .- W ) OA WOI O N NjN N �'IN NI w' W I, I� i N i 1 �I. O, A Im'I m N N NIN NIN N:N N! INI N N r) IN N N N,NIN I IOI; (p O O O'0 0 o;0'�O O; :., O O O O O o' oloic) o . NININ'IN�N N: N:N: N'. ;N: N.mim: N: �N;N: : NIN'N: N ! ! WSW W WIWIWIWW'. I, IWI .W: :WIW'', W'' W'. IW:WI IWI IW . WIW. oloiolo o:o olo o:o ololo oo�ojo oolo'o ololoolo'o�olo 0 0l0 0 0 0l0 0 0 0:0 0 0 oio 0 0 oo 0 0 0l0 0 0!0 0' 0:0;0 0 oIoo m a 0. m.m V m co 00 00OD I,m m m OD;mIm V�(O;,m 00 m m;m m tOiCO,m (O CO:m COO m'm [O O O:(O (O CO (O!(O (O (O (OI(� W O W O (O (O-m m m-m:m O -�10 mIN CO m Vim m N > OIN ;W N :N�Cn A W m,ml0 A N:COjm m=Cn Cn A AlA A A A?W W ((��I NINININ NIN IO O O OI(O (O (pim 55,5 O(m O m m;IJ N A m',O N WIWI-` m N m:N m >INiJ O m'm W (O I.I.1Cn W N:m N .P (O;m CILIA -CIO (O m11 V'IlA N >1CD (O 00.A O) OCO OD N . 1 -I;. -1177 .11 .'Zl :U ::7 .-(1; :f1 .Z1 .Z7 .-O, 5I�.� nln Ol n101n nIn C>) nIn n olo n n n Oln -In n n n''1n nln;n,nlA n n nlnln n nln n n n DnIDn HOODO OOII I I I _O I- m 00 A;A A A "A A N W O;O O Oi0 0 O (D (O'(O W (O�tO m�fOlcO (OI(OICD{CO "i, tO tO (O W W1O (O 1 _ _ _ - m O�O WI-�':N Nmlmim O O]::m N m m N Nlm m:m m O) WIW W > >>>:,> >:> > >: > >`> > AIN N ';W N O'm!m O) O O) CO O m Cl O O O O -4 -4 V N N:N N NIN N N'1NIN N.N1N�N NNNN N N N:NIN N NlN N N�N N N NIN NIW W w (It:W W lrlm (n NiN N N,N O J J.A J m (ni(n (n (n ()D:m m V J:J m',mlm m m m m m m;m�m 'CO m m;mlm CDICO;00 00 m 00.00 m 00 00 m OD 00 00 m W W m (O!-� A OI,m mCn(n(n (T (n m (nlm m:m N m>"> W WIW W O OO N NIN NINININ N N N;N N N N:N N N N,N N N IN): 00 N N:N N N N;N N OD m G) G) G) NIS N N T. S,S S S 2 m A A!f) ra N GiiGi G) T WI,W W m m:m () ()'() i7lm min O O (T 0 O of m () 00 00 n n c)'I. i) n n Ci A A.p CI. � _ X O O�n;n m W:D D o -n!T D O10 O< W m mllco o:m n o�olm m m:oi� ml�"� m,ao o mmlm;o { �0 o D [[]] ((]] m;o �21'0 G) COa� M D z G� A ,� 3 C'{ ::7 G J �. � pIN Z,,< C C7'Nlp I CnIA N >,A A�W m W;W m Cp CpiN pl O.> m J VI,W (n :,WII>,O _Cn'W OD:IW > (O:> Cn N > m OO mI NIO > ml O N D ,XI D �., Tl 'il p In N N 0 0 CD d',,d d d �� ,INIIIC C C C C C C C C C:C - _- _ �1 C}C CICIC C C CSC C C C GC{CIC C C C C C -1 T OOr W OO I�� < <ImmIIF.�cIIcIc,r 0w0v,wOcniinlvrcncn!cnvitnitn!cn0rntoin0ininNOcn'inrn0cnlin0orrm "' m m d D D O ;O to 'o II� G)Is o l,o 0 o CD jN N �II� I� ��-i. 1-i i1 111� -III W C> > D° rrCID !(o[cc (o(oco > >,� S �'mmlmlm m mm m' m;m'Im m m!m' m m m;m m m m'm m'm m'!m m m m'm m mm m OIp'm �xOO> >>> >!�I° cn'�'('D''DIIDDIDI°!°I° n!mlmm:m m m mld mllm m;m m m mm m m m m m m m m w m:m m gll�!z �;0 nI O2'3 3 � (/ NIN N N NIN N N-N fA NIN (n N N N;N N N N:N N N N N N (A N',N N N:N N 'N lC A'3S 'Inn° s�iiR1 �-o'°-o'°l�n�sl'(�Im mlc� I�: '�I��Qz�Q! 42 ��2�2�Qz'z'',�z�� '�Ir.o10 �' m m m mm oI : O �� O W 'lo o 2 2 O (n'm m w:N m m I _ 1 D� m 0) CD CD W N N .2r2= hz 'i cn <oo a01000o mmwISSR co y - D-Dc rr m:'m'm mld a -n CID Z 'z Z.!zllz rn IIM''. U o.olvv DDD D cn DDDCDi>vDicDi� Occn 0 0 m D O D O rn'0 0 O D!D D A OO -:O IO -_ i� :U :o A'� Cmn.c�i1 �I� �A 0'O;0''.� -i;� :1'1 --1 : - �' - -� -� 0--� 0 i D D D D O'0 0 D D cn rn to"D D',O� x� p1I0 0 0 010 0 0 O 0 0 W G)�G�G)G)�IOG)�C�OOO0000OG)0000OG)G)L��OO�v�OG)0�� 1�� G)000��0 CnD'UCnD' DDDmD-oD cDi�cDi� 0� 0111��-Oi-i:-i-1 -� dal Ir rIr r r r r r r (- r-;r r DI m D.r (- D m m m m.m m m r m ',r r r r. o lmmlmmm!mmm m mmImml� > > N f0 N N W"(n O O OI' .> } > N N O N O N NI co V N I_ > m -� -� > O O O O -� > mIm m;m m > -•C -'+ N > N N NI N N N �I N W W W W W W >> N N N N O O O O N N Ni °) O O W D m. >NA V 00I A WINiN JIW m `W OOO W\0D OD OD -.P AAC\NOOC`lW W W W.. 00 OD 00 ODiN U)(O ` >>Op( f7 N.N N N N-.N N N N NINININ N N NI,N N N N,N N N N:N N N N:N N N.N N N N'N N N N,N N N NIN N N NN N N NN N N'NI NIN NI,N ,d O.O 010:0 O10 Oi0 0 0 OIO O O O:O O O OHO 0 0 O.O O o'O o ) 0 0 0 0 O;O O O O,O O O O;O O O O10 O Oy010 0 010 N :N N N N':. j N N �I� NIN N N!� N jNN �I� N N N'IN N N N:.N N to N N' NIN N N N,N N N'.NNNNI,N N N:N� _ ,NNN N;N N N NIN N N NIN N N;>I> N NIIV N) O O O I�,.O O O' (O -' O N N':N N N NIN N N N N N N,N N N N W V > O) \ (O: -+ W W:W m W'> Q zi O N N'I� m W Ni-� m A C\:A W A'O A mIW >!\ m A''. (` (O CO (I1'A d NIA W WIW W N W"N v':C (n.m (O N Oliv V NIN Olc)i('Tt O > O (O ON N N N N NIN N N N;N N N:N N N N N N N NIN N N N.N N N N:,N N N NN N N'IN NNN N N N NIN N N N N N'N N I NIN N NN N N:N N N N'N a';. O, O O O OO O O O ,O O CD O O O ', ) O O O IlO O O O.O O O O O O O O O O O'lo O O O;O O O O O O O O,O 0 0 OIO O O O:O 0 0 0 0 0 0 O ` N N NIN N N N N-N N N N N N N N } iA (nW W W mfnA mm�(n A;m NCJ)CN)1 l , - cn N N N N N N NIN N N N N N N N NN N N N N N N N N N N N N N N N N N N N N N N;N N N N NIN N ! fnA (1(A AiA A W�A A W Cn.Cn W Cn Cn'A Cn W A_A A W O) A A A� AAA (n (n A W WL(T A A A;W W W W W W W- ___ w id c Im V ()) V O mlm m W: 1 m'm N m 00im V W. A NIW O) ! 00 CD:WIIW � A:mI(O � O)IOO Ou VI�i,W A � 00.V W N.V A W WI> :� IV'•I-� V W A N A W�.W J m 0 m O OIN A W N,(O V A (0 A cD N N:N W m'm W A:mIA (n:m W A -- OD):DA CO (DT DV,DV VD 00 A A 00 N N1,W Ln O) VIV (O!N V VIOIO) 00 > V A V (T'iJ V (T V Ow1 � > N'� O O A,D� Dv �y D�i,� yN O D� W_O O.W -- I� 6i i�i w Ai Fa i�i pi D D D D D"D ND, Dw w DAD D D mD IN mDlm m m m�!D D D D y D D.D.Si 5i Ci ci pi �i CiD�DiI 3 w Ci oDi .F i � F i iv .F i 5i 5i �i oDi oDi of 5i 5i uDi " oDi oDi Bi oDi oDi oDi hi �i 6i 5i b5i O) ,N N N N N 01 N O) 03 0) IN 0) 0) 0) 0) 0) N 0) IN O) O) 0) 0) 0) O) 0) 01 O) 0)0) 0) 0) 10) gID D IjD Sr _N > > > I_ N : CO CO f0 (O m m (O O A (fl O:(O O m (I) V O m (D O (O m a0' co (O (O (O (O (O "0 (O I iO (O (o . CO . a i. (O OD -4: to co oD OD': ao CO (O (O'': iO (O (O' (O , (O (o (O io I� (O A CO c W: N N:N m (O OD,V m NNNN, AIm.N O: m'V m CO N;(n N W 212 N N OIN O W N'N V m N N m V.A W CO ;� O OD W, W W N!m f0 (OIJ Alm-J•C m> CO J O N O A N m m,m (O O),WIIV"WIWIOIO W Cn O D m:N;N N w IA CO 00 (n_N m O),m N O W W m A mliW m m A' N W _m,A W m!- m,V w V (O:(O m N (O NIV V (nNIA L4 O A�O cO A w In!IO Cp > m A N -+ A m�(n A aim >10 -P (n AI V. AIcO A Alml(DIm (O NUJ (n iN A WIP V:(01, mim f0 00 p N ,(O A W N'O O IN O:(O W (0':OIiV ()o (O'(DIO A O (D,> C', CIt A�- N W A O OD `O A A W O , - O N> O m JIm O O Cn m'J O N N IO A O O m A O m 00 A O CD A OOI cn c) O) co IA;(A O IO) O) I_ NIN N N NI W N > N N _N NI I,W N N _N >IN.'N N -� >N > > O Oio Oi OI�I,0 0'ol:(n oio.o CO o fALo o Cn:0 0 o O o10 0 (O (O!W CO w (O':CO,CO (OICO CO OD OO [O CO OD:,W CO LO CO o0':(D�(�I(O (O tO CO (D (OICO c0 o w (O A CO'c .A co V A'A.ml O!NI O m m m A m m O O m!V O AIW J O m (D W A W N AIAIA O m:N N Ou mI N fn O W A co m;m m m mIm (a0:O O V m 4 N-.N J W WI1fp;A NIm'm m m:m m O m_(n A (O W:N O Cn'Olm V N W"_(n O N O. N co AIN W Alm A (fl,(D IIO O 00 N W (D J O, (n W _(OI(DI> m-V A W,� W;c) m A A,A WIA O) (O W AIN (O A fn:m A A m cw O W WI,V m OD:> IW O:J c) m:N:c) (o:m A!N.N m m > V WIW N:Ut (O NIJ c) D) VIO) O A,C' N!(n m m fnl0 A WIV V m IN fn (O Oo I,O J V'c) N N V,-� m m:(o V m (O!m pp O:VIN m m-N N 01(O (O (O m O; m'(o (O m,N1N JI Jj OICn JIA W O >I(n A (n-0?(n,(J IOI(OIA > JiJ W (O A`V ? Oiml> OII n:> N imjW m m,lO N m m Al O WIO m (O 00 ImIJ OIi O O m J:N NCI) N N N N NIN N IO O: IOO O. OIOO N IA AI '.A A: 010:0 0 0 0 0 0 0 0lo 0 0 o Olo o!w 0 0 oIo 0 0 0�0 0 0 0.0 0 0�0 0 010 0',0 0 0{0 0 0 ojo 0 0 o a O 0i00 J V VIV V aD J!(0 W QO jD (D QD V:'(D 0 W J:QD do W W'. QO W W J1. 00i j0 W''.J W do W ViJ JIJ OD 00 J W:OO W J J O( ppVIW W.WI V'00 W V:N W W. A O pp'V O) N ViV N 101Ut V O)IA IN OOjJ N A 00!00 V OI JOI JIW-O A Do do!W .P WkW (D_N, (DJ O 0)I!>[p W ?,m WIW >A W N >'!(T O{{fT OJI> CT(T) N:O JO. f0 O (O>J J 0�00 W W OOjV 2�ccc'c lccccicccc!,cllcicc':ccc1cCicClc13c ' �i�� Icccc-Icccccccl, cccccccicccccccc-c NIA Z Z Z Z ZIZ Z Z ZIZ 2 Z Z Z Z 2 ZIZ Z Z Z Z Z Z ZIZ Z;Z Z ZIZ:IZIZ Z Z Z Z Z Z;Z Z Z Z Z Z Z'Z fn l Cn . OD W W O' OWD IIW (VO ONi I W W J I W W W W� W 00 w 0000 ONO ONO ONO 000 OD ONO II I N I N i N ON. a) N W V! V C W N, :> O 010 0 { N (T A A A �!A OD (O 0),O)!(T(0�0o N A(p� 'J J W,W f0 Cn(n O)IA W A J (TO N > V V J'm Qi 0.0 ONO O�O�O�D'�O O O'10'IO O W C�J,(�Itl' NIN OJIW Op'.A v WI� O A (.O.) AW W!000 JNO N(T O)CT�A W wAO00IWIJ WIW,W W JIOOIW W J N 000'o0 V 0)N'N (TONtO W 00 A 0)0) W 0 0 to Tv� IT COIG) (o:yl(o NI J �I� o 00100;< n n n � kC:C:IN �!D W Z J mloo o o w L7:� NIZ C'aDI WT.I Tom, Dr gi0 O'O ? a,.In < m'cn;Q �C N'`- �1o!rn!!:rn 01 N'''!n 07Lin -f Cn tnjCn KIK Flo o!m K!3 3 p m O,n n 0Il cl� � Im m m m � w D W 1 r m m;r r D p r r r p1 O'!D z ZI<:z x ,xlx 3 O to (n _Wt In W W w m mIT. r r r O m= I(n;D 1> 1 zl0 O D � �IOI-il��q,olo o o;o O r-i-i-i-n3 BOO n:nn.1mzmml3 m o Z� (a O D �1210 0 O.a a zlx >>> := I= O Z z z z O. O D K! 0< 2 10 m i1lZllm <: n1 D>i;um D nnn;�tncncncnz OOO�� ! m:mcn C��IKX'<*o W F <IA n m �'i�lm v -oi0 0 0� K K;R W Si'Im IIW "O o 3 3 O N 2 Olp coIm.m'D D Z;Z J O O,D F it n O r D� 3 3 D m n D D 0;m DI0ID D �°lo N fn !n 1D m 0 O;n m <;m o 0 0l� O n:cn z 0 0 0�3 3 C c.� r r r rlr D -A D x� 2 �;�IOIz 2 210iE I Im — i0 O:z 13 nl> > �'� ,DiLo�D � �I> > C'm Z Z Zl4 = � �Im m m 0 O OIL sl�l< 0�10 OO fD �O{ n C�iIZ1-n W 2 � < xlm 21`� �c n (n 10 G) --i --I-I:...4 Z � 1 1 m m mmm m 0-cic mm o C� 0��lai <;� x D'� Z D D'n cnmx, (�7 y<<<� �� QDm"zzl�< IOAI D cw 0CI D pIO O O,c�iil I� O ZI� �I,4 o n X n n n -np !!<1<1<'mn:z 9 A �'20 201Z 1='0 O S _ �!� o r KX 1m .Dcncncnl,m (bx�'l011010' m!cl'I cT n001 y c3 Q,m I° 01> > p:m !� n m m m 0 m zln O O�>< M x r r D CIC m: no o :m n �DDD <ITMM rnn�cn colrlIootoci'd:�°'i�<�-ni�� n n n ''1,m mlm Iz c02 x --I �� m,'nn c< �:D O p!O O A A m m m cn `z 2ic x 2 r Fn1cni WOO m ,-I P 0 .O W — �crii z nnOI2 'O ! c 2 O—1 NCn'I m m m v m u'IlO m ;nn0 Zvcvn:c-no vm �n �A !Du)) )0 cnln to D N D p�OG�iv�D,nnm Co '1W�W�IAW r W z m m nD m I i W N N NN.>11N J 10 W N:N O NI> J N Wi O O N W N JNO OO Oo N N QV V N O O 00 V O N > ` N 0) \ � � 00 > N O :A ` N W;W OD O `: W 0' z Nji N A NI NINN N NlN N N N.NIN NN.N N N N N N N,,NN N N N!N N N NIN N N N.N N N N N N N NN N N N'� N N ��N N N Q O;O N 0,� O �IOIN NIN OO O}(p{O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 O O O O O O O O'O O O OI O0 NNN NI 'NIN N N,N N N (T 0)!> O 01010 O > O'N > O O O O:> O 0,-- I M D7 M:Mrn m- m m N O)10) 1m :� 0 W "f0 O) N (0 W �:,.W W W,on A co 00 001CT Ln(` (1\l > N N NIN NIN,N N N NIN I"). N N. N1N N N'IN N N NIN N N N.N N N N N N1N'1N .O O O O O O O O,O O O o!o O O 010 O O C.,O O O!O O O O!O O O 010 O O O�O O O O.O O O O,,O O OI,O W1W A A CT O W:CT A�WT A 0) W�(T A;W A W D7 _A AMAIN NIN N I 'W WIA W N N N N W N A A N A N A m A A 0) O) A A : W0 J WT O J I> Lin COO N t0 WO W -N J N I O O W O) I W O) N O{ A A (O N N W A A W N aD A W N (T N A CT W: N A A A W CT (T' J (D A Do N N 00 N CT ! V J A OD,(D J�cD O W J J OO 0 J;> J J t0 W.W N J A N N W N) N) O J A 00 A N NIN NJ01 0 00 N N !m J N N A tO AINI(T(T'JIV J >:N N;> > W > —IN) .� > W IN) 0l N N':,,> 1 I I I r I +;+ ++++++ glgl g �� I 1 O O' N O Wi0 O IOr O OJN N'N O O> W- > O Ch O N O W N (T 00 N (O (TIN V (T!A O O >;(O N I A OD W m WT W)1 V m, O .-�. COI �_ r >,(' I I W W O N (0 W A OO O) O) O 0) N N N W A W W OAO (AT A{> > OW) W W O W O N O N 0 J1 N'00 (n O WO.N N N J;N m W7) 00 >> A J J N (T J 1 O) W N I W N t0 J J W 01 W O W O J J CT OD V f)D N A N N N N Ou O O OIO O OIA O O 1:0 0; 01-+ -� O O 0:0 O O O A -� 0 0 0 0 4. 0> 010 O'I,O O!N -+ O (T O,O o C) O)ND7'O0 A(T'O) V V A OD CT O) W A(T 0) J;W W W A_ J W 0)In AN0) NADD !A 0)I .NOO)O D) Aim W:i IA W! V!0' O) V'fT!N O O NIO V10 O10 COO W;[O W W: N W OIOD O O (T:(0 N O)!N J IN'W ? O A'W N (T:(D A A;WT!O O O Oi(0 O O O O N O O) O W O O"O Ou Ou A W O V N OIO�,;O O (nifD OA'OIW W O (T:O N O N W W:0 OD O OIA 010 O�fO O O 00 O O O O T O OD �.O N OW;O Co O W.W ,rl COO O O;J O W V O W;> N (O NIW 0) Ul ODIN O V 0.0 W W Cn N O)'-V(Ti0 ! I0) Y 'OIN W ((TT L) 0 -ti- ((TT ''> W J O N Co O V N O]'. O� ((TT WI-• (4,W (0 0): OD 00 N AI> W W;A > W CT (JS),W A W A;(AO�A (Np A!N ONi O) m1,A N (NT �:_ _�, A 0)IOD W-4tj-J:N A N --� > ;> N N> NIN N >> N� N W N A'.W NItT W:0 N O V'IN O N NiNlO (T'.W tT JIO) (T N fT NIV 00;0 A N;N 0 0 O'W N O O''10 N w o O)'V (T O W N O I O O W O�N (TOO M' O WIO''N O NI O O N O N N m O O N 0 0 0 0 O O D) O O J W W A C0000 0000 O NIN O_0000 O_01000I00 Ut:tT 0010 NOfTN O 0100_O 000:01000100(T ;O (O Ay0 O O O-O 010 O;O O O�OIO O O O[O 010 0;0 0 0 01010 O O O O OIO CD O,0 0 0 O:O O ojo O O O 0 J V 0 0 0 O-A O O;O;O Ol010!O 0 0 Oi0 O O O10 O:O'O 0, C O'.0 O 0 0.0 0 0 O10 0 010 :0 0'0; 010 O O:O CID 00 0 0.0 0 0 0 - 0 0 0 0 .0 0 O:O;o 0 oio I II � � I � W '> WIA AiW A JI j N WO J> W> N 0 (0 A N A J-A A N A: 0) (0 V V N WIN -+ O O JN AI(O (O (O N oD O Q) D7 N O) N (T 04,0 0) O' O A WIN A W J 00 (0 W: J (T j V A (T 00 OO W O) W O O J. Ou J I N W (O 0)' ) V 0) A tOIJO O7 W'O N AIN NIW WOiN NIW WT A O W N N _Ol W A_0) tT NWiO A (0;(0 O N (DIA N O 0) W NIA!V > 00.0 O O O W O > N W a m A�'O A A;AIO O�O) J;O) O O!> O Q) 0i0 N J O W W O0!(T000(0000 Owi0 W DD 0DO NOD '011W 4A O A00 A No0,N WO AOD OO (T f0O O N N N CO A CT O).W 101aDICT : ..... JA W W V 0 CO 0) A W 0) J(O N O)O)N 00 V OAOAO N > 1O) W A N N 00 OIV N O W A J N,J NWT Wi j I 1 NI> NN WIW N A''.W N N WOIJ N O ODIN OIN N'.N O I(TIA WT J1!U, A N;(T N W C0 0 N A N N O O O''i W1cn co 01.0 N W-> (0 (T N O NI O NI(J) O 0 wT O WO O;O JIO 0) A W 0) O W NtO O Wi0 a) O O N OI J A,O AlWDONOOI(OA WOIW fT ONWONtT000(T O{WNWIO)WJ INOfDI(D ,(OO OLPAO) O>OO O_[OOO' Ai, O'V:O'O QD;W O 00 (Di00 0(O WIA O NWT W J �iN N O WIA O10)'1fJ V V;O O O 01> CT10N OO; JiW O fT,ODIOO O W; V;N J WOOD O) W :V N 01 OOIN O O AW A Ol WSW 01(O OiN OIA J DD (Oj0 N, O; O;> D).WOI O,O)'O O;N -� O J OO O >i(T W JIJ;N V > >'A J O,(a IN, O,O W W: OD N 0) (a N�O;J N O (T MEETING DATE: March 22, 2023 SUBJECT: Consideration of revisions to the County's Investment Policy RECOMMENDED MOTION: Move approval of County Administrator signature on revised County Investment Policy F-10. BACKGROUND AND POLICY IMPLICATIONS: The County is required to have its investment policy approved by the governing body annually. The policy was last approved by the Board in March 2022 at which time only minor changes were made to the policy. A recent review by the County Treasurer, Chief Financial Officer and Deschutes County's Investment Advisory Committee (IAC) recommend minor changes to align with State Treasurer guidance through ORS 294. The IAC voted unanimously in favor of these amendments on March 7, 2023. Attached is the current investment policy with proposed changes noted. Modifications to the investment policy are normally required to be reviewed by the Oregon Short Term Fund Board for comment. However, these proposed changes are recommended to bring our policy into alignment with the State Policy. BUDGET IMPACTS: The Board is required to approve the Investment Policy annually to allow the county to invest funds with a maturity beyond 18 months. ATTENDANCE: Bill Kuhn, County Treasurer Robert Tintle, Chief Financial Officer JTEs O Deschutes County Administrative Policy No. IT-10 0 < Effective Date: January 7, 2008 Revised Date: March 20, 2019 Revised Date: June 24, 2009 Revised Date: March 11, 2020 Revised Date: September 20, 2012 Revised Date: March 17, 2021 Revised Date: March 16, 2022 Revised Date: December 11, 2013 Revised Date: December 15, 2014 Revised Date: December 17, 2015 Revised Date: December 27, 2017 INVESTMENT POLICY GUIDELINES PURPOSE This Investment Policy defines the parameters within which funds are to be invested by Deschutes County. Deschutes County's purpose is to provide County Level Services for a large portion of Central Oregon. This policy also formalizes the framework, pursuant to ORS 294.135, for Deschutes County's investment activities to ensure effective and judicious management of funds within the scope of this policy. These guidelines are intended to be broad enough to allow designated investment staff to function properly within the parameters of responsibility and authority, yet specific enough to adequately safeguard the investment assets. GOVERNING AUTHORITY Deschutes County's investment program shall be operated in conformance with Oregon Revised Statutes and applicable Federal Law. Specifically, this investment policy is written in conformance with ORS 294.035; 294.040; 294.052; 294.135; 294.145; and 294.810. All funds within the scope of this policy are subject to Laws established by the State of Oregon. Any revisions or extensions of these sections of the ORS shall be assumed to be part of this Investment Policy immediately upon being enacted. SCOPE This policy applies to activities of Deschutes County with regard to investing the financial assets of all County funds including County Service Districts and Trust Funds. Investments of employees' retirement funds, deferred compensation plans, and other funds are not covered by this policy. The amount of funds falling within the scope of this policy over the next three years is expected to range between $160 million and $230 million. GENERAL OBJECTIVES The primary objectives, in priority order, of investment activities shall be: 1. Preservation of Invested Capital. Investments shall be undertaken in a manner that seeks to ensure the preservation of capital in the overall portfolio. The goal is to manage credit risk and interest rate risk. 2. Liquidity. The investment portfolio shall remain sufficiently liquid to meet all reasonably anticipated operating requirements. Furthermore, the portfolio should consist largely of securities with active secondary or resale markets. A portion of the portfolio also may be placed in the Oregon Policy U-10, Investment Policy Guidelines Page 1 of 1 I Short Term Fund which offers next -day liquidity. Where possible and prudent, the portfolio should be structured so that investments mature concurrent with anticipated demands. 3. Return. The investment portfolio shall be designed with the objective of attaining a market rate of return throughout budgetary and economic cycles, taking into consideration the safety and liquidity needs of the portfolio. Although return consists of both principal return (gains and losses due to market value fluctuations) and income return (yield), this policy discourages active trading and turnover of investments. Investments should generally be held to maturity. STANDARDS OF CARE Prudence. The standard of prudence to be used by investment officials shall be the "prudent person" standard and shall be applied in the context of managing an overall portfolio. Investment officers acting in accordance with written procedures and this investment policy, and exercising due diligence shall be relieved of personal responsibility for an individual security's credit risk or market price changes, provided deviations from expectations are reported and appropriate action is taken to control adverse developments within a timely fashion as defined in this policy. The "prudent person" standard states that `Investments shall be made with judgment and care, under circumstances then prevailing, which persons ofprudence, discretion and intelligence exercise in the management of their own affairs, notfor speculation, but for investment, considering the probable safety of their capital as well as the probable income to be derived. " Ethics and Conflicts of Interest. Officers and employees involved in the investment process shall refrain from personal activity that could conflict with the proper execution and management of the investment program, or that could impair their ability to make impartial decisions. Employees and FF t L 11 l: l �o 1 ro o�r� : , fi , ;�1 ; ,�r;�„t; ,,,� .:,;th -,h;,h th- 111VUbL111G111 V111V10.1J Mall UISC1VJl. ally 111a Ltillal 111 L1i1 NJ LJ 1111111u111'1 u1 111J L1LuL1V vvl yr Haul. u1V y conduct business. Disclosure shall be made to the governing body. They shall further disclose any personal financial/investment positions that could be related to the performance of the investment portfolio. Employees and officers shall refrain from undertaking personal investment transactions with the same individual with whom business is conducted on behalf of the County. Officers and employees shall, at all times, comply with the State of Oregon Government Standards and Practices code of ethics set forth in ORS Chapter 244. 3. Delegation of Authority and Responsibilities a. Governing Body. The Board of County Commissioners will retain ultimate fiduciary responsibility for invested funds. The governing body will receive reports, pursuant to, and with sufficient detail to comply with ORS 294.155. b. Delegation of Authority. Authority to manage investments within the scope of this policy and operate the investment program in accordance with established written procedures and internal controls is granted to the Treasurer and/or Chief Financial Officer, hereinafter referred to as Investment Officer, and derived from the following: ORS 294.035 to 294.053, 294.125 to 294.145, and 294.810. No person may engage in an investment transaction except as provided under the terms of this policy and the procedures established by the Investment Officer. The Investment Officer shall be responsible for all transactions undertaken and shall establish a system of controls to regulate the activities of subordinate officials. All participants in the investment process shall seek to act responsibly as custodians of the public Policy #F-10, Investment Policy Guidelines Page 2 of 11 trust. No officer or designee may engage in an investment transaction except as provided under the terms of this policy and supporting procedures. c. Investment Committee. The Deschutes County Board of County Commissioners established an investment advisory committee on April 19, 1995 by resolution 95-12520 to provide guidance to the Investment Officer and monitor investment policy compliance. d. Investment Adviser. The Investment Officer may engage the services of one or more external investment managers to assist in the management of the County's investment portfolio in a manner consistent with this investment policy. Investment advisers may be hired on a non - discretionary basis. All investment transactions by approved investment advisers must be pre - approved in writing by the Investment Officer and compliant with this Investment Policy. If the Investment Officer hires an investment adviser to provide investment management services, the adviser is authorized to transact with its direct dealer relationships on behalf of Deschutes County. TRANSACTION COUNTERPARTIES, INVESTMENT ADVISERS AND DEPOSITORIES 1. Broker/Dealers. The Investment Officer shall determine which broker/dealer firms and registered representatives are authorized for the purposes of investing funds within the scope of this investment policy. A list will be maintained of approved broker/dealer firms and affiliated registered representatives. The following minimum criteria must be met prior to authorizing investment transactions. The Investment Officer may impose more stringent criteria. iSrUXCr/LG[L1Gr 111111J liilAJl 111eG1 111e lvllvwii'1g 1111 rliiuiit er lt%.r ia: i. Be registered with the Securities and Exchange Commission (SEC); ii. Be registered with the Financial Industry Regulatory Authority (FINRA). iii. Provide most recent audited financials. iv. Provide FINRA Focus Report filings. b. Approved broker/dealer employees who execute transactions with Deschutes County must meet the following minimum criteria: i. Be a registered representative with the Financial Industry Regulatory Authority (FINRA); ii. Be licensed by the state of Oregon; iii. Provide certification (in writing) of having read; understood; and agreed to comply with the most current version of this investment policy. Periodic (at least annual) review of all authorized broker/dealers and their respective authorized registered representatives will be conducted by the Investment Officer. Factors to consider would be: i. Pending investigations by securities regulators. ii. Significant changes in net capital. iii. Pending customer arbitration cases. iv. Regulatory enforcement actions. 2. Investment Advisers. A list will be maintained of approved advisers selected by conducting a process of due diligence. a. The following items are required for all approved Investment Advisers: Policy U-10, Investment Policy Guidelines Page 3 of 11 i. The investment adviser firm must be registered with the Securities and Exchange Commission (SEC) or licensed by the state of Oregon; (Note: Investment adviser firms with assets under management > $100 million must be registered with the SEC, otherwise the firm must be licensed by the state of Oregon) ii. All investment adviser firm representatives conducting investment transactions on behalf of Deschutes County must be registered representatives with FINRA; iii. All investment adviser firm representatives conducting investment transactions on behalf of Deschutes County must be licensed by the state of Oregon; iv. Certification, by all of the adviser representatives conducting investment transactions on behalf of Deschutes County, of having read, understood and agreed to comply with this investment policy. b. A periodic (at least annual) review of all authorized investment advisers will be conducted by the Investment Officer to determine their continued eligibility within the portfolio guidelines. Factors to consider would be: i. Pending investigations by securities regulators. ii. Significant changes in net capital. iii. Pending customer arbitration cases. iv. Regulatory enforcement actions. 3. Depositories. All financial institutions who desire to become depositories must be qualified Oregon Depositories pursuant to ORS Chapter 295. 4. Competitive Transactions a. The Investment Officer shall obtain and document competitive bid information on all investments purch,__ 1 �a .1,, a,,.... t,o+ r o+:�:.,o l.:a� VV t tat, obtained, a when ased or sold 111 L11G nGk V11Ualy mam%,L. VV111FJ L1L1VV VIM or o..v s J.. - be obtainVd, vv possible, from at least three separate brokers/financial institutions or through the use of a nationally recognized trading platform. b. In the instance of a security for which there is no readily available competitive bid or offering on the same specific issue, the Investment Officer shall document quotations for comparable or alternative securities. c. When purchasing original issue securities, no competitive offerings will be required as all dealers in the selling group offer those securities at the same original issue price. However, the Investment Officer is encouraged to document quotations on comparable securities. d. If an investment adviser provides investment management services, the adviser must retain documentation of competitive pricing execution on each transaction and provide upon request. ADMINISTRATION AND OPERATIONS 1. Delivery vs. Payment. All trades of marketable securities will be executed (cleared and settled) by delivery vs. payment (DVP) to ensure that securities are deposited in the County's safekeeping institution prior to the release of funds. 2. Third -Party Safekeeping. Securities will be held by an independent third -party safekeeping institution selected by the County. All securities will be evidenced by safekeeping receipts in the County's name. Upon request, the safekeeping institution shall make available a copy of its Statement on Standards for Attestation Engagements (SSAE) No. 16. Policy #F-10, Investment Policy Guidelines Page 4 of I I 3. Internal Controls. The investment officer is responsible for establishing and maintaining an adequate internal control structure designed to reasonably assure that invested funds are invested within the parameters of this Investment policy and, protected from loss, theft or misuse. Specifics for the internal controls shall be documented in writing. The established control structure shall be reviewed and updated periodically by the Investment Officer. The concept of reasonable assurance recognizes that the cost of a control should not exceed the benefits likely to be derived and the valuation of costs and benefits requires estimates and judgments by management. The internal controls shall address the following points at a minimum: a. Compliance with Investment Policy. b. Control of collusion. c. Separation of transaction authority from accounting and record keeping. d. Custodial safekeeping. e. Avoidance of physical delivery of securities whenever possible and address control requirements for physical delivery where necessary. f. Clear delegation of authority to subordinate staff members. g. Confirmation of transactions for investments and wire transfers in written or digitally verifiable ctct;uvtuc ivtut. h. Dual authorizations of wire and automated clearing house (ACH) transfers. i. Staff training. j. Review, maintenance and monitoring of security procedures both manual and automated. 4. An external auditor in conjunction with the annual County audit shall review compliance with Oregon state law and Deschutes County policies and procedures. SUITABLE AND AUTHORIZED INVESTMENTS 1. Permitted Investments. The following investments are permitted pursuant to ORS 294.035, 294.040, and ORS 294.810. (Note: Permitted investments maybe more restrictive than ORS 294.035 and 294.810). a. US Treasury Obligations. U.S. Treasury and other government obligations that carry the full faith and credit guarantee of the United States for the timely payment of principal and interest. b. US Agency Obligations. Senior debenture obligations of US federal agencies and instrumentalities or U.S. government sponsored enterprises (GSE). c. Oregon Short Tenn Fund. Policy ##F-10, Investment Policy Guidelines Page 5 of 11 d. Corporate Indebtedness. e. Commercial Paper issued under the authority of section 3(a)2 or 3(a)3 of the Securities Act of 1933. f. Corporate Bonds. g. Municipal Debt. h. Bankers Acceptances. i. Qualified Institution Time Deposits/Savings Accounts/Certificates of Deposit. 2. Approval of Permitted Investments. If additional types of securities are considered for investment, per Oregon state statute they will not be eligible for investment until this Policy has been amended and the amended version adopted by Deschutes County. 3. Prohibited Investments a. Private Placement or "144A" Securities. Private placement or "144A" securities are not allowed. For purposes of the policy, SEC Rule 144A securities are defined to include commercial paper privately placed under section 4(a)(2) of the Securities Act of 1933. b. US Agency Mortgage -backed Securities. US agency mortgage -backed securities such as those securities issued by FNMA and FHLMC are not allowed. Securities Lending. The County shall not land securities nor directly nartirinate in a Securities c. u�li UL1l1VJ LViil.liii�,. The County vaauaa a.v� +va.v vvv.n+a..v� aava directly eH. .avaru.v ... w �vv.n. lending program. 4. Demand Deposits and Time Deposits a. All demand deposits and time deposits (Examples of time deposits are: certificates of deposit and savings accounts) shall be held in qualified Oregon depositories in accordance with ORS Chapter 295. b. Demand deposits in qualified depository institutions are considered cash vehicles and not investments and are therefore outside the scope and restrictions of this policy. Pursuant to ORS 294.035(3)(d), time deposits, certificates of deposit and savings accounts are considered investments and within the scope of this policy. INVESTMENT PARAMETERS 1. Credit Risk. Credit risk is the risk that a security or a portfolio will lose some or all of its value due to a real or perceived change in the ability of the issuer to repay its debt. Credit risk will be managed by the following guidelines: Diversification. It is the policy of Deschutes County to diversify its investments. Where appropriate, exposures will be limited by security type; maturity; issuance, issuer, and security type, Allowed security types and Investment exposure limitations are detailed in the table below. b. Recognized Credit Ratings. Investments must have a rating from at least one of the following nationally recognized statistical ratings organizations (NRSRO): Moody's Investors Service; Policy #F-10, Investment Policy Guidelines Page 6 of 11 Standard & Poor's; and Fitch Ratings Service as detailed in the table below. At least one such rating must meet the minimum rating requirements shown in the table below. Ratings used to apply the guidelines below should be investment level ratings and not issuer level ratings. Portfolio Average Credit Rating. The minimum weighted average credit rating of the portfolio's rated investments shall be Aa2/AA/AA by Moody's Investors Service; Standard & Poor's; and Fitch Ratings Service respectively. For purposes of evaluating the average credit rating for the portfolio, the County will use the single rating for those securities that only have one rating, the lower of two ratings for those securities that have two ratings and the middle rating for those securities that have three ratings. d. Exposure Constraints and Minimum Investment Credit Ratings. The following table limits exposures among investments permitted by this policy. Maximum% MinimumRatings Oregon ReXised Statue #ssueType lliaidtngs'. Nloody's/S&P/Fitch Reference US Treasury Obligations 100% N/A US Agency Securities 100%� Per Agency (Senior Obligations Only) 33% Oregon Short Term Fund Maximum allowed per ORS 294.810 Bankers' Acceptances 25% Al+/P1/F1+ 25% maximum holding per ORS 294.035(3)(h)(C). Time Deposits, Savings Accounts, 50% Authorized by ORS 294.035(3)(d). Certificates of Deposit Per Institution 25% COrpOrateDebt (Total) _ 25% 35% maximum holding per ORS 294.035(3)(h)(D). Corporate Commercial Paper per issuer 5% Al/P1/F1 5% maximum ho1di11g per O„S 294.035(3)(h)(D). Corporate Bonds Per Oregon Issuer 5% A2/A/A 5% max holding per ORS 294.035(3)(h)(D), A- min rating per ORS 294.035(3)(b). All Other Issuers 5% Aa3/AA-/AA- 5% max holding per ORS 294.035(3)(h)(D), AA -min rating for CA, WA & ID per ORS _............................................,...................................................................................... ......................-............................................................................................................. 294.035(3)(b). ............... ................................................................... Municipal Debt 25/0 Municipal Bonds Aa3/AA-/AA- e. Restriction on Issuers with Prior Default History. Per ORS 294.040, the bonds of issuers listed in ORS 294.035 (3)(a) to (c) may be purchased only if there has been no default in payment of either the principal of or the interest on the obligations of the issuing county, port, school district or city, for a period of five years next preceding the date of the investment. 2. Liquidity Risk. Liquidity risk is the risk that an investment may not be easily marketable or redeemable. The following strategies will be employed to manage liquidity risks: a. The value of at least 10% of funds available for investing or three months of budgeted operating expenditures will be invested in the Oregon Short Tenn Fund, with a qualified depository institution, or investments maturing in less than 30 days to provide sufficient liquidity for expected disbursements. b. Funds in excess of liquidity requirements are allowed for investments maturing in greater than one year. However, longer -term investments tend to be less liquid than shorter term investments. Policy #F-10, Investment Policy Guidelines Page 7 of I I Portfolio investment maturities will be limited as follows: Total Portfolio Maturity Constraints: c. Reserve or Capital Improvement Project funds may be invested in securities exceeding the maximum term if the maturities of such investments are made to coincide as nearly as practicable with the expected use of the funds. d. Larger issuance sizes enhance liquidity as there are likely to be a greater number of investors. Issuance sizes above a minimum amount qualify a corporate or municipal debt bond issuance for index eligibility. Index eligible bonds have a significantly larger investor base which improves liquidity. e. Limiting investment in a specific debt issuance improves secondary market liquidity by assuring there are other owners of the issuance. Maximum % of i�s'.'4 T •.. lance fear\ US Agency Securities 50% Corporate Debt Corporate Commercial Paper 25% Corporate Bonds __ __ _ 25% Municipal Bonds 25% Interest Rate Risk. Longer -term investments have the potential to achieve higher returns but are also likely to exhibit higher market value volatility due to the changes in the general level of interest rates over the life of the investment(s). Interest rate risk will be managed by providing adequate liquidity for short term cash needs, and by making longer -term investments only with funds that are not needed for current cash flow purposes. Certain types of securities, including variable rate securities, securities with principal pay -downs prior to maturity, and securities with embedded options, will affect the interest rate risk profile of the portfolio differently in different interest rate environments. The following strategies will be employed to control and manage adverse changes in the market value of the portfolio due to changes in interest rates: a. Where feasible and prudent, investment maturities should be matched with expected cash outflows to manage market risk. b. To the extent feasible, investment maturities not matched with cash outflows, including liquidity investments under one year, should be staggered to manage re -investment risk. c. No commitments to buy or sell securities may be made more than 14 business days prior to the anticipated settlement date or receive a fee other than interest for future deliveries. Policy #P-10, investment Policy Guidelines Page 8 of I I d. The maximum percent of callable securities in the portfolio shall be 25%; e. The maximum stated final maturity of individual securities in the portfolio shall be five years, except as otherwise stated in this policy. f. The maximum portfolio average maturity (measured with stated final maturity) shall be 2.0 years. INVESTMENT OF PROCEEDS FROM DEBT ISSUANCE 1. Investments of bond proceeds are restricted under bond covenants that may be more restrictive than the investment parameters included in this policy. Bond proceeds shall be invested in accordance with the parameters of this policy and the applicable bond covenants and tax laws. 2. Funds from bond proceeds and amounts held in a bond payment reserve or proceeds fund may be invested pursuant to ORS 294.052. Investments of bond proceeds are typically not invested for resale and are maturity matched with outflows. Consequently, surplus funds within the scope of ORS 294.052 are not subject to this policy's liquidity risk constraints within section IX (2). INVESTMENT OF RESERVE OR CAPITAL IMPROVEMENT FUNDS Pursuant to ORS 294.135(1)(b), reserve or capital Improvement project funds may be invested in securities exceeding three years when the funds in question are being accumulated for an anticipated use that will occur more than 18 months after the funds are invested, then, upon the approval of the governing body of the county, the maturity of the investment or investments made with the funds may occur when the funds are expected to be used. GUIDELINE ANASUREiviEN T AND A"HEREj rCE 1. Guideline Measurement. Guideline measurements will use par value of investments. 2. Guideline Compliance. a. If the portfolio falls outside of compliance with adopted investment policy guidelines or is being managed inconsistently with this policy, the Investment Officer shall bring the portfolio back into compliance in a prudent manner and as soon as prudently feasible. b. Violations of portfolio guidelines as a result of transactions; actions to bring the portfolio back into compliance and; reasoning for actions taken to bring the portfolio back into compliance shall be documented and reported to the Board of County Commissioners. c. Due to fluctuations in the aggregate surplus funds balance, maximum percentages for a particular issuer or investment type may be exceeded at a point in time. Securities need not be liquidated to realign the portfolio; however, consideration should be given to this matter when future purchases are made to ensure that appropriate diversification is maintained. REPORTING AND DISCLOSURE 1. Compliance. The Investment Officer shall prepare a report at least monthly that allows the Board of County Commissioners to ascertain whether investment activities during the reporting period have conformed to the investment policy. The report will also be provided to the investment advisory committee. The report will include, at a minimum, the following: Policy #F-10, Investment Policy Guidelines Page 9 of I I a. A listing of all investments held during the reporting period showing: par/face value; accounting book value; market value; type of investment; issuer; credit ratings; and yield to maturity (yield to worst if callable). b. Average maturity of the portfolio at period -end. c. Maturity distribution of the portfolio at period -end. d. Average portfolio credit quality of the portfolio at period -end. e. Average weighted yield to maturity (yield to worst if callable investments are allowed) of the portfolio. f. Distribution by type of investment. g. Transactions since last report. h. Distribution of transactions among financial counterparties such as broker/dealers. i. Violations of portfolio guidelines or non-compliance issues that occurred during the prior period or that are outstanding. This report should also note actions (taken or planned) to bring the portfolio back into compliance. 2. Performance Standards/ Evaluation. At least annually, the Investment Officer shall report comparisons of investment returns to relevant alternative investments and comparative Bond Indexes. The performance of the portfolio should be compared to the performance of alternative investments '- - -- 11 b1e __...:c ates ofde_..-sit:t..L1,. n..,.g01- SIt10Irt, Tce..,, IF..„,L. Lrc rr..,.,..,..... ratL,.,.. ,..-..,...: r.n4 S LII%Il AJ AVclllil UlG l%GL 11111;0.1.GJ V1 UG1JV, tllc V1Gb'Vll J11Vlt lcllll l'U11U, lJJ 11GAJ Uly taLGJ, Vt a�auiJ1, one or more bond indices with a similar risk profile (e.g., Bond indexes comprised of high grade investments and maximum maturities of three years). When comparing perfonmance, all fees and expenses involved with managing the portfolio shall be included in the computation of the portfolio's rate of return. 3. Marking to Market. The market value of the portfolio shall be calculated at least monthly and a statement of the market value of the portfolio shall be included in the monthly report. 4. Audits. Management shall establish an annual process of independent review by the external auditor to assure compliance with internal controls. Such audit will include tests deemed appropriate by the auditor. POLICY MAINTENANCE AND CONSIDERATIONS 1. Review. The investment policy shall be reviewed at least annually to ensure its consistency with the overall objectives of preservation of principal, liquidity and return, and its relevance to current law and financial and economic trends. The annual report should also serve as a venue to suggest policies and improvements to the investment program, and shall include an investment plan for the coming year. 2. Exemptions. Any investment held prior to the adoption of this policy shall be exempted from the requirements of this policy. At maturity or liquidation, such monies shall be reinvested as provided Policy #F-10, Investment Policy Guidelines Page 10 of 1 I by this policy. 3. Policy Adoption and Amendments. This investment policy and any modifications to this policy must be formally approved in writing by the Board of County Commissioners. This policy must be submitted to the Oregon Short Term Fund (OSTF) Board for review if: a. This policy allows maturities beyond 18 months unless the funds are being accumulated for a specific purpose, including future construction projects, and upon approval of the Board of County Commissioners, the maximum maturity date matches the anticipated use of the funds (ORS 294.135(1)(b) and 294.135(3)). b. And either: i. This policy has never been submitted to the OSTF Board for comment; or ii. Material changes have been made since the last review by the OSTF Board. Regardless of whether this policy is submitted to the OSTF Board for comment, this policy shall be re- submitted not less than annually to the Board of County Commissioners for approval. Approved by the Board of Commissioners Nick Lelack t,viiiity tiuuliriiauawr Policy #F-IQ, Investment Policy Guidelines Page 11 of I 1 J-ces c Deschutes County Administrative Policy No. F-10 0 2{ Effective Date: January 7, 2008 Revised Date: March 20, 2019 Revised Date: June 24, 2009 Revised Date: March 11, 2020 Revised Date: September 20, 2012 Revised Date: March 17, 2021 Revised Date: December 11, 2013 Revised Date: March 20, 2023 Revised Date: December 15, 2014 Revised Date: December 17, 2015 Revised Date: December 27, 2017 INVESTMENT POLICY GUIDELINES PURPOSE This Investment Policy defines the parameters within which funds are to be invested by Deschutes County. Deschutes County's purpose is to provide County Level Services for a large portion of Central Oregon. This policy also formalizes the framework, pursuant to ORS 294.135, for Deschutes County's investment activities to ensure effective and judicious management of funds within the scope of this policy. These guidelines are intended to be broad enough to allow designated investment staff to function properly within the parameters of responsibility and authority, yet specific enough to adequately safeguard the investment assets. GOVERNING AUTHORITY Deschutes County's investment program shall be operated in conformance with Oregon Revised Statutes and applicable Federal Law. Specifically, this investment policy is written in conformance with ORS 294.035; 294.040; 294.052; 294.135; 294.145; and 294.810. All funds within the scope of this policy are subject to Laws established by the State of Oregon. Any revisions or extensions of these sections of the ORS shall be assumed to be part of this Investment Policy immediately upon being enacted. SCOPE This policy applies to activities of Deschutes County with regard to investing the financial assets of all County funds including County Service Districts and Trust Funds. Investments of employees' retirement funds, deferred compensation plans, and other funds are not covered by this policy. The amount of funds falling within the scope of this policy over the next three years is expected to range between $160 million and $230 million. GENERAL OBJECTIVES The primary objectives, in priority order, of investment activities shall be: 1. Preservation of Invested Capital. Investments shall be undertaken in a manner that seeks to ensure the preservation of capital in the overall portfolio. The goal is to manage credit risk and interest rate risk. 2. Liquidity. The investment portfolio shall remain sufficiently liquid to meet all reasonably anticipated operating requirements. Furthermore, the portfolio should consist largely of securities with active secondary or resale markets. A portion of the portfolio also may be placed in the Oregon Policy #F-10, Investment Policy Guidelines Page I of 11 Short Term Fund which offers next -day liquidity. Where possible and prudent, the portfolio should be structured so that investments mature concurrent with anticipated demands. 3. Return. The investment portfolio shall be designed with the objective of attaining a market rate of return throughout budgetary and economic cycles, taking into consideration the safety and liquidity needs of the portfolio. Although return consists of both principal return (gains and losses due to market value fluctuations) and income return (yield), this policy discourages active trading and turnover of investments. Investments should generally be held to maturity. STANDARDS OF CARE Prudence. The standard of prudence to be used by investment officials shall be the "prudent person" standard and shall be applied in the context of managing an overall portfolio. Investment officers acting in accordance with written procedures and this investment policy, and exercising due diligence shall be relieved of personal responsibility for an individual security's credit risk or market price changes, provided deviations from expectations are reported and appropriate action is taken to control adverse developments within a timely fashion as defined in this policy. The "prudent person" standard states that `Investments shall be made with judgment and care, ender circumstances then prevailing, which persons of prudence, discretion and intelligence exercise in the management of their own affairs, not for speculation, but for investment, considering the probable safety of their capital as well as the probable income to be derived. " 2. Ethics and Conflicts of Interest. Officers and employees involved in the investment process shall refrain from personal activity that could conflict with the proper execution and management of the investment program, or that could impair their ability to make impartial decisions. Employees and lIlvestillent officials shall disclose any material interests Ill 1111alleiai iiistiiiiioiis WIlll wlllcll they conduct business. Disclosure shall be made to the governing body. They shall further disclose any personal financial/investment positions that could be related to the performance of the investment portfolio. Employees and officers shall refrain from undertaking personal investment transactions with the same individual with whom business is conducted on behalf of the County. Officers and employees shall, at all times, comply with the State of Oregon Government Standards and Practices code of ethics set forth in ORS Chapter 244. 3. Delegation of Authority and Responsibilities a. Governing Body. The Board of County Commissioners will retain ultimate fiduciary responsibility for invested funds. The governing body will receive reports, pursuant to, and with sufficient detail to comply with ORS 294.155. b. Delegation of Authority. Authority to manage investments within the scope of this policy and operate the investment program in accordance with established written procedures and internal controls is granted to the Treasurer and/or Chief Financial Officer, hereinafter referred to as Investment Officer, and derived from the following: ORS 294.035 to 294.053, 294.125 to 294.145, and 294.810. No person may engage in an investment transaction except as provided under the terms of this policy and the procedures established by the Investment Officer. The Investment Officer shall be responsible for all transactions undertaken and shall establish a system of controls to regulate the activities of subordinate officials. All participants in the investment process shall seek to act responsibly as custodians of the public Policy 417-10, Investment Policy Guidelines Page 2 of 11 trust. No officer or designee may engage in an investment transaction except as provided under the terns of this policy and supporting procedures. c. Investment Committee. The Deschutes County Board of County Commissioners established an investment advisory committee on April 19, 1995 by resolution 95-12520 to provide guidance to the Investment Officer and monitor investment policy compliance. d. Investment Adviser. The Investment Officer may engage the services of one or more external investment managers to assist in the management of the County's investment portfolio in a manner consistent with this investment policy. Investment advisers may be hired on a non - discretionary basis. All investment transactions by approved investment advisers must be pre - approved in writing by the Investment Officer and compliant with this Investment Policy. If the Investment Officer hires an investment adviser to provide investment management services, the adviser is authorized to transact with its direct dealer relationships on behalf of Deschutes County. TRANSACTION COUNTERPARTIES, INVESTMENT ADVISERS AND DEPOSITORIES 1. Broker/Dealers. The Investment Officer shall determine which broker/dealer firms and registered representatives are authorized for the purposes of investing funds within the scope of this investment policy. A list will be maintained of approved broker/dealer firms and affiliated registered representatives. The following minimum criteria must be met prior to authorizing investment transactions. The Investment Officer may impose more stringent criteria. r, i _ire _ _ l _.. firms .____. t meet the following criteria: a. tSrOKer/LGa1Cr 111111J 111UJt 111GGL u1c ivii�wluy luuuuiuui c>,i�ciia. i. Be registered with the Securities and Exchange Commission (SEC); ii. Be registered with the Financial Industry Regulatory Authority (FINRA). iii. Provide most recent audited financials. iv. Provide FINRA Focus Report filings. b. Approved broker/dealer employees who execute transactions with Deschutes County must meet the following minimum criteria: i. Be a registered representative with the Financial Industry Regulatory Authority (FINRA); ii. Be licensed by the state of Oregon; iii. Provide certification (in writing) of having read; understood; and agreed to comply with the most current version of this investment policy. c. Periodic (at least annual) review of all authorized broker/dealers and their respective authorized registered representatives will be conducted by the Investment Officer. Factors to consider would be: i. Pending investigations by securities regulators. ii. Significant changes in net capital. iii. Pending customer arbitration cases. iv. Regulatory enforcement actions. Investment Advisers. A list will be maintained of approved advisers selected by conducting a process of due diligence. a. The following items are required for all approved Investment Advisers: Policy #F-10, Investment Policy Guidelines Page 3 of I I i. The investment adviser firm must be registered with the Securities and Exchange Commission (SEC) or licensed by the state of Oregon; (Note: Investment adviser firms with assets under management > $100 million must be registered with the SEC, otherwise the firm must be licensed by the state of Oregon) ii. All investment adviser firm representatives conducting investment transactions on behalf of Deschutes County must be registered representatives with FINRA; iii. All investment adviser firm representatives conducting investment transactions on behalf of Deschutes County must be licensed by the state of Oregon; iv. Certification, by all of the adviser representatives conducting investment transactions on behalf of Deschutes County, of having read, understood and agreed to comply with this investment policy. b. A periodic (at least annual) review of all authorized investment advisers will be conducted by the Investment Officer to detennine their continued eligibility within the portfolio guidelines. Factors to consider would be: i. Pending investigations by securities regulators. ii. Significant changes in net capital. iii. Pending customer arbitration cases. iv. Regulatory enforcement actions. Depositories. All financial institutions who desire to become depositories must be qualified Oregon Depositories pursuant to ORS Chapter 295. 4. Competitive Transactions a. The Investment Officer shall obtain and document competitive bid information on all investments purcnaseUi Ur sold 11the secondary market. 1rw.....1..1I.,.G,.aLl:�LIVko; iUIUJ y,.r U11 G,1..J..3..11,1y,.ULU U%�+ v„UL uu:.,l�0u.7, v.v.llx�o.u. possible, from at least three separate brokers/financial institutions or through the use of a nationally recognized trading platform. b. In the instance of a security for which there is no readily available competitive bid or offering on the same specific issue, the Investment Officer shall document quotations for comparable or alternative securities. c. When purchasing original issue securities, no competitive offerings will be required as all dealers in the selling group offer those securities at the salve original issue price. However, the Investment Officer is encouraged to document quotations on comparable securities. d. If an investment adviser provides investment management services, the adviser must retain documentation of competitive pricing execution on each transaction and provide upon request. ADMINISTRATION AND OPERATIONS 1. Delivery vs. Payment. All trades of marketable securities will be executed (cleared and settled) by delivery vs. payment (DVP) to ensure that securities are deposited in the County's safekeeping institution prior to the release of funds. 2. Third -Party Safekeeping. Securities will be held by an independent third -party safekeeping institution selected by the County. All securities will be evidenced by safekeeping receipts in the County's name. Upon request, the safekeeping institution shall snake available a copy of its Statement on Standards for Attestation Engagements (SSAE) No. 16. Policy #F-10, Investment Policy Guidelines Page 4 of 11 3. Internal Controls. The investment officer is responsible for establishing and maintaining an adequate internal control structure designed to reasonably assure that invested funds are invested within the parameters of this Investment policy and, protected from loss, theft or misuse. Specifics for the internal controls shall be documented in writing. The established control structure shall be reviewed and updated periodically by the Investment Officer. The concept of reasonable assurance recognizes that the cost of a control should not exceed the benefits likely to be derived and the valuation of costs and benefits requires estimates and judgments by management. The internal controls shall address the following points at a minimum: a. Compliance with Investment Policy. b. Control of collusion. c. Separation of transaction authority from accounting and record keeping. d. Custodial safekeeping. e. Avoidance of physical delivery of securities whenever possible and address control requirements for physical delivery where necessary. f. Clear delegation of authority to subordinate staff members. g. Confirmation of transactions for investments and wire transfers in written or digitally verifiable electronic form. h. Dual authorizations of wire and automated clearing house (ACH) transfers. i. Staff training. j. Review, maintenance and monitoring of security procedures both manual and automated. 4. An external auditor in conjunction with the annual County audit shall review compliance with Oregon state law and Deschutes County policies and procedures. SUITABLE AND AUTHORIZED INVESTMENTS 1. Permitted Investments. The following investments are permitted pursuant to ORS 294.035, 294.040, and ORS 294.810. (Note: Permitted investments may be more restrictive than ORS 294.035 and 294.810). a. US Treasury Obligations. U.S. Treasury and other government obligations that carry the full faith and credit guarantee of the United States for the timely payment of principal and interest. b. US Agency Obligations. Senior debenture obligations of US federal agencies and instrumentalities or U.S. government sponsored enterprises (GSE). c. Oregon Short Term Fund. Policy #F-10, Investment Policy Guidelines Page 5 of 11 d. Corporate Indebtedness. e. Commercial Paper issued under the authority of section 3(a)2 or 3(a)3 of the Securities Act of 1933. f. Corporate Bonds. g. Municipal Debt. h. Bankers Acceptances. i. Qualified Institution Time Deposits/Savings Accounts/Certificates of Deposit. 2. Approval of Permitted Investments. If additional types of securities are considered for investment, per Oregon state statute they will not be eligible for investment until this Policy has been amended and the amended version adopted by Deschutes County. 3. Prohibited Investments a. Private Placement or "144A" Securities. Private placement or "144A" securities are not allowed. For purposes of the policy, SEC Rule 144A securities are defined to include commercial paper privately placed under section 4(a)(2) of the Securities Act of 1933. b. US Agency Mortgage -backed Securities. US agency mortgage -backed securities such as those securities issued by FNMA and FHLMC are not allowed. C. Securities Lending. The Coun ty shall not lend securrties not diiec±ly part:cipa±e m a SPCA»::t:eS lending program. 4. Demand Deposits and Time Deposits a. All demand deposits and time deposits (Examples of time deposits are: certificates of deposit and savings accounts) shall be held in qualified Oregon depositories in accordance with ORS Chapter 295. b. Demand deposits in qualified depository institutions are considered cash vehicles and not investments and are therefore outside the scope and restrictions of this policy. Pursuant to ORS 294.035(3)(d), time deposits, certificates of deposit and savings accounts are considered investments and within the scope of this policy. INVESTMENT PARAMETERS 1. Credit Risk. Credit risk is the risk that a security or a portfolio will lose some or all of its value due to a real or perceived change in the ability of the issuer to repay its debt. Credit risk will be managed by the following guidelines: a. Diversification. It is the policy of Deschutes County to diversify its investments. Where appropriate, exposures will be limited by security type; maturity; issuance, issuer, and security type, Allowed security types and Investment exposure limitations are detailed in the table below. b. Recognized Credit Ratings. Investments must have a rating from at least one of the following nationally recognized statistical ratings organizations (NRSRO): Moody's Investors Service; Policy #F-10, Livestment Policy Guidelines Page 6 of I 1 Standard & Poor's; and Fitch Ratings Service as detailed in the table below. At least one such rating must meet the minimum rating requirements shown in the table below. Ratings used to apply the guidelines below should be investment level ratings and not issuer level ratings. c. Portfolio Average Credit Rating. The minimum weighted average credit rating of the portfolio's rated investments shall be Aa2/AA/AA by Moody's Investors Service; Standard & Poor's; and Fitch Ratings Service respectively. For purposes of evaluating the average credit rating for the portfolio, the County will use the single rating for those securities that only have one rating, the lower of two ratings for those securities that have two ratings and the middle rating for those securities that have three ratings. d. Exposure Constraints and Minimum Investment Credit Ratings. The following table limits exposures among investments permitted by this policy. Maximum % 11!linimum'Ratings Oregon Revised Statue issue Type Holdings Moody's/5&P/Fitch Reference , US Treasury Obligations 100% N/A US Agency Securities 100% Per Agency (Senior Obligations Only) 33% Oregon Short Term Fund Maximum allowed per ORS 294.810 _ Bankers' Acceptances 25%� Al+/P1/F1+ 25% maximum holding per ORS 294.035(3)(h)(C). Time Deposits, Savings Accounts, 50% Authorized by ORS 294.035(3)(d). Certificates of Deposit Per Institution 25% _ Corporate Debt (Total) mm 25% 35%maximum holding per ORS 294.035(3)(h)(D). Corporate Commercial Paper per Issuer 5% A1/P1/F1 5% maximum holding per ORS 294.035(3)(h)(D). Corporate Bonds Per Oregon Issuer 5% A2/A/A 5% max holding per ORS 294.035(3)(h)(D), A- min rating per ORS 294.035(3)(b). All Other Issuers 5% Aa3/AA-/AA- 5% max holding per ORS 294.035(3)(h)(D), AA -min rating for CA, WA & ID per ORS .............................................. .............................. ................................................ .................................................... ........ 294.035(3)(b)............................ ........ ............ ....... ...... ............... ........ ..... _................... .................... ................................ Municipal Debt 25% Municipal Bonds Aa3/AA-/AA- e. Restriction on Issuers with Prior Default History. Per ORS 294.040, the bonds of issuers listed in ORS 294.035 (3)(a) to (c) may be purchased only if there has been no default in payment of either the principal of or the interest on the obligations of the issuing county, port, school district or city, for a period of five years next preceding the date of the investment. 2. Liquidity Risk. Liquidity risk is the risk that an investment may not be easily marketable or redeemable. The following strategies will be employed to manage liquidity risks: a. The value of at least 10% of funds available for investing or three months of budgeted operating expenditures will be invested in the Oregon Short Term Fund, with a qualified depository institution, or investments maturing in less than 30 days to provide sufficient liquidity for expected disbursements. Funds in excess of liquidity requirements are allowed for investments maturing in greater than one year. However, longer -term investments tend to be less liquid than shorter term investments. Policy #F-10, Investment Policy Guidelines Page 7 of I I Portfolio investment maturities will be limited as follows: Total Portfolio Maturity Constraints: c. Reserve or Capital Improvement Project funds may be invested in securities exceeding the maximum term if the maturities of such investments are made to coincide as nearly as practicable with the expected use of the funds. d. Larger issuance sizes enhance liquidity as there are likely to be a greater number of investors. Issuance sizes above a minimum amount qualify a corporate or municipal debt bond issuance for index eligibility. Index eligible bonds have a significantly larger investor base which improves liquidity. e. Limiting investment in a specific debt issuance improves secondary market liquidity by assuring there are other owners of the issuance. Interest Rate Risk. Longer -term investments have the potential to achieve higher returns but are also likely to exhibit higher market value volatility due to the changes in the general level of interest rates over the life of the investment(s). Interest rate risk will be managed by providing adequate liquidity for short term cash needs, and by making longer -term investments only with funds that are not needed for current cash flow purposes. Certain types of securities, including variable rate securities, securities with principal pay -downs prior to maturity, and securities with embedded options, will affect the interest rate risk profile of the portfolio differently in different interest rate environments. The following strategies will be employed to control and manage adverse changes in the market value of the portfolio due to changes in interest rates: a. Where feasible and prudent, investment maturities should be matched with expected cash outflows to manage market risk. b. To the extent feasible, investment maturities not matched with cash outflows, including liquidity investments under one year, should be staggered to manage re -investment risk. c. No commitments to buy or sell securities may be made more than 14 business days prior to the anticipated settlement date or receive a fee other than interest for future deliveries. Policy #F-10, Investment Policy Guidelines Page 8 of 1 1 d. The maximum percent of callable securities in the portfolio shall be 25%; e. The maximum stated final maturity of individual securities in the portfolio shall be five years, except as otherwise stated in this policy. f. The maximum portfolio average maturity (measured with stated final maturity) shall be 2.0 years. INVESTMENT OF PROCEEDS FROM DEBT ISSUANCE 1. Investments of bond proceeds are restricted under bond covenants that may be more restrictive than the investment parameters included in this policy. Bond proceeds shall be invested in accordance with the parameters of this policy and the applicable bond covenants and tax laws. 2. Funds from bond proceeds and amounts held in a bond payment reserve or proceeds fund may be invested pursuant to ORS 294.052. Investments of bond proceeds are typically not invested for resale and are maturity matched with outflows. Consequently, surplus funds within the scope of ORS 294.052 are not subject to this policy's liquidity risk constraints within section IX (2). INVESTMENT OF RESERVE OR CAPITAL IMPROVEMENT FUNDS Pursuant to ORS 294.135(1)(b), reserve or capital Improvement project funds may be invested in securities exceeding three years when the funds in question are being accumulated for an anticipated use that will occur more than 18 months after the funds are invested, then, upon the approval of the governing body of the county, the maturity of the investment or investments made with the funds may occur when the funds are expected to be used. GUIDELINE MEASUREMENT AND ADHERENCE 1. Guideline Measurement. Guideline measurements will use par value of investments. 2. Guideline Compliance. a. If the portfolio falls outside of compliance with adopted investment policy guidelines or is being managed inconsistently with this policy, the Investment Officer shall bring the portfolio back into compliance in a prudent manner and as soon as prudently feasible. b. Violations of portfolio guidelines as a result of transactions; actions to bring the portfolio back into compliance and; reasoning for actions taken to bring the portfolio back into compliance shall be documented and reported to the Board of County Commissioners. c. Due to fluctuations in the aggregate surplus funds balance, maximum percentages for a particular issuer or investment type may be exceeded at a point in time. Securities need not be liquidated to realign the portfolio; however, consideration should be given to this matter when future purchases are made to ensure that appropriate diversification is maintained. REPORTING AND DISCLOSURE 1. Compliance. The Investment Officer shall prepare a report at least monthly that allows the Board of County Commissioners to ascertain whether investment activities during the reporting period have conformed to the investment policy. The report will also be provided to the investment advisory committee. The report will include, at a minimum, the following: Policy U-10, Investment Policy Guidelines Page 9 of I I a. A listing of all investments held during the reporting period showing: par/face value; accounting book value; market value; type of investment; issuer; credit ratings; and yield to maturity (yield to worst if callable). b. Average maturity of the portfolio at period -end. c. Maturity distribution of the portfolio at period -end. d. Average portfolio credit quality of the portfolio at period -end. e. Average weighted yield to maturity (yield to worst if callable investments are allowed) of the portfolio. f. Distribution by type of investment. g. Transactions since last report. h. Distribution of transactions among financial counterparties such as broker/dealers. i. Violations of portfolio guidelines or non-compliance issues that occurred during the prior period or that are outstanding. This report should also note actions (taken or planned) to bring the portfolio back into compliance. Performance Standards/ Evaluation. At least annually, the Investment Officer shall report comparisons of investment returns to relevant alternative investments and comparative Bond Indexes. The performance of the portfolio should be compared to the performance of alternative investments .. r . .i Oregon _ ... fit_._.. m_____ r__._a. rm T..__,.__._..... 4,.,..-_-_,.:« such as available certificates or deposit; the Oregon Short Tenn Fund, US 11Casu1y ta1cN, 01 aga111SL one or more bond indices with a similar risk profile (e.g., Bond indexes comprised of high grade investments and maximum maturities of three years). When comparing perfonnance, all fees and expenses involved with managing the portfolio shall be included in the computation of the portfolio's rate of return. 3. Marking to Market. The market value of the portfolio shall be calculated at least monthly and a statement of the market value of the portfolio shall be included in the monthly report. 4. Audits. Management shall establish an annual process of independent review by the external auditor to assure compliance with internal controls. Such audit will include tests deemed appropriate by the auditor. POLICY MAINTENANCE AND CONSIDERATIONS 1. Review. The investment policy shall be reviewed at least annually to ensure its consistency with the overall objectives of preservation of principal, liquidity and return, and its relevance to current law and financial and economic trends. The annual report should also serve as a venue to suggest policies and improvements to the investment program, and shall include an investment plan for the coming year. 2. Exemptions. Any investment held prior to the adoption of this policy shall be exempted from the requirements of this policy. At maturity or liquidation, such monies shall be reinvested as provided Policy #F-10, Investment Policy Guidelines Page 10 of 1 I by this policy. 3. Policy Adoption and Amendments. This investment policy and any modifications to this policy must be formally approved in writing by the Board of County Commissioners. This policy must be submitted to the Oregon Short Term Fund (OSTF) Board for review if: a. This policy allows maturities beyond 18 months unless the funds are being accumulated for a specific purpose, including future construction projects, and upon approval of the Board of County Commissioners, the maximum maturity date matches the anticipated use of the funds (ORS 294.135(l)(b) and 294.135(3)). b. And either: i. This policy has never been submitted to the OSTF Board for comment; or ii. Material changes have been made since the last review by the OSTF Board. Regardless of whether this policy is submitted to the OSTF Board for comment, this policy shall be re- submitted not less than annually to the Board of County Commissioners for approval. Approved by the Board of Commissioners M Gilt C-A - �'03 d-O I- ,e -MA Lelack County Administrator Policy #F-10, Investment Policy Guidelines Page 11 of I I MEETING DATE: March 20, 2023 SUBJECT: Finance Report for February 2023 ATTENDANCE: Robert Tintle, Chief Financial Officer DATE: March 20, 2023 TO: Board of County Commissioners FROM: Robert Tintle, Chief Financial Officer SUBJECT: Finance Report for February 2023 Following is the unaudited monthly finance report for fiscal year to date (YTD) as of February 28, 2023. Budget to Actuals Report General Fund • Revenue YTD in the General Fund is $40M or 91.5% of budget. By comparison, last year revenue YTD was $37.1M and 91.0% of budget. • Expenses YTD are $28.7M and 63.3% of budget. By comparison, last year expenses YTD were $27.3M and 63.1% of budget. • Beginning Fund Balance is $13.8M or 106.7% of the budgeted $12.9M beginning fund balance. L'90+CS to /- .-- Cnut Fund Select all (Blank) 001 - General Fund` '. 010 - Assmt-Clerk... 020 - Code Abate... 030 - Community ... 040 - Court Techn... 050 - Economic D- 060 - General Co... 070 - General Co... 090 - Project Dev- 120 - Laev Library 130 - Park .Accluis - 132 - Park Develo... Monthly GL Per... 0 8 $11 AM (Blank) ity Wide Financial Dashboard 001 - General Fund 8 66.7% Year Complete Budget to Actuals Requirements Resources Beginning Working Capital Budget to Actuals by Category b Actuals *Budget OProjection $28.7M $40.OM f$13.8M% 63.3% 01.50A 106 7% Monthly Expenditures st^.a jgo-d 0 _ 1 d N 0Last33 fear Actuals OCurrentYYea, Actuals Monthly Revenues -- e e • Last Year Actuals *Current Year Actuals Projec % of last vear budget ?0 91.1% % of last vear budget ion:+ I i All Major Funds On the attached pages you will find the Budget to Actuals Report for the County's major funds with actual revenue and expense data compared to budget through February 28, 2023. Position Control Summary Position Control Summary FY23 July -June Percent Org Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Unfilled Assessor Filled 33,26 31.00 1 32.00 4 31.00 31.00 ' 33.26 32.26 32.26 Unfilled 2.00 4,26 3.26 : 4.26 4.26 I 2.00 3.00 ' 3.00 9.23% Clerk Filled 9,48 9.48 '' 10.48 ': 10.48 10.48 10.48 ': 10.48 9,48 Unfilled 1.00 1.00 'I - - 1.00 3.58% BOPTA i Filled 0.52 0.52 ` 0.52 0.52 0.52 0.52 0,52 0.52 Unfilled - - - - 0,00% DA Filled 57.40 ' 58.40 59.20 61.20 61.20 59.80 58.30 ` 58.80 Unfilled 3.20 2.20 ' 1.40 0.40 :' 0.40 i 1.30 2.80 2.80 - 2,97% Tax Filled 5.50 5.50 6.50 6,50 6.50 i 6.50 ; 6,50 6.50 > Unfilled 100 1.00 - 3.85% Veterans' Filled 5.00 '. 5,00 I 5.00 ' 4.00 4.00 4.00 5.00 5.00 Unfilled - 1.00 `. 1.00 : 1.00: - '. 7,50% Property Mgmt Filled 2.00 2.00 2,00 2.00 2.00 2.00 2.00'. 2.00 Unfilled 1.00 :: 1.00 1.00 / 1,00 : 1,00 <. 1.00 1.00 1.00'. `33.33% Total General Fund Filled : 113.16 111.90 115.70 : 115,70 : 115,70 116,561 115.06': 114.56' - - Unfilled 8.20 i 9.46 ? 5.66 6.66 ' 6.66 - 5.30 6.80 i 7.80 5.80% Justice Court Filled 4.60 4.60 4.60 4.60 4.60 4.60' 4.60 4.602 Unfilled - - 0.00% Community Justice Filled 45.20 45.20 45.90 4430 44.90 45.90 45.90 45.90 Unfilled 2.70 2.70 2.00 3.00 3.00 2.00 2.00 2.00 5.06% Sheriff .Filled 218.25 232.25 c 230,25 230.25 231.75 229.75:' 228.75-: 235.75; Unfilled 44.75 30.75 ' 32.75 32.75 31.25 33.25 : 36.25 29.25 12,86% Houseless Effort Filled - - 1.00 1.00 1.00 1.00 1.00 1.00 Unfilled 2.00 2.00 1.00 1,00 1.00 1.00 1.00 1.00 62.50% Health Srvcs 'Filled +' 355.80 - 357.50 ':: 368.30 371.30 374.55 380.20 38010` 383.30% Unfilled 49.55 47.85 48.25 46.25 ? 4425 39.60 39.70 38.50 10,65% CDD Filled 59.80 58.80 59.80 58.80 59.80 57.80 57.80 5830 Unfilled 12.20 13.20 12.20 13.20 12.20 14.20 6.20 5.20 15.82% Road Filled 55.00 55.00 : 58.00 '. 57.00 58.00 58.00' 57.00': 57.00::. Unfilled 6.00 `- 6.00 3.00 4.00 i 3.00 3.00 4.00 4.00! 6.76% Adult v&P Fiiied .3555 3555 35.85 34.85 34.85 34.85 ,6.00 '7.00 Unfilled 5.30 5.30 5.00 6.00 6.00 6.00 14.26% Solid Waste Filled 27,00 26.00 28,00 26.00 27.00 28,00 27.00 28.00 Unfilled 3,00 4.00 :: 2.00 ':: 4.00 3.00 2,00 3.00 2,00 [ 9.58% Victims Assistance Filled 8.00 8.00 8.00 8.50 8.50 8.50 7.50 7.50 Unfilled - - - 1.00 2.00 4.44% GIS Dedicated Filled 2,30 ` 2.30 ' 2.30 `, 2.30 2,30 2.30 2.30 2.30 Unfilled - - - - 0.00% Fair & Expo Filled 9.75 9.75 9.75 10.75 10.75 10.75 10.75 11.75 Unfilled 3.75 3.75 3.75 2.75 2.75 2.75 2.75 1.75 22.22% Natural Resource Filled 1.00 - 2.00 2,00 2.00` 2.00' Unfilled 1.00 ` 2A0 2.00 2.00 '< 43.75% ISF - Facilities Filled 20.75 21.75 20.75 21.75 21.75 19,75 19.75 21.75 Unfilled 4.25 3.25 4.25 3.25 3.25 5.25 5.25 3.25 16.00% ISF -Admin .Filled 8.75 ' 8.75.' 9.75 ,` 10.75 10.75': 10.75- 9,75;. 975 Unfilled 2.00 ': 2.00 1.00 - 5.95% ISF -SOCC Filled 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Unfilled - - 0.00% ISF - Finance Filled 10.00 8.00 10.00 10.00 ' 10.00 12.00 ` 12.00` 12.00 Unfilled 1.00 3.00 ; 1.00 1.00 1.00 - - 7.69% ISF - Legal Filled 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 Unfilled - - 0.00% ISF -HR i 'Filled 900 '. 9.00 +. 9,00 + 9.00 '+ 9.00 - 9.00'. 9.00'.: 9.004 Unfilled 1.00 1.00 f 1,00 ;' 1.00 1.00 1,00 1.00' 1.00 10.00% ISF - IT Filled 16.70 16.70 16.70 16.70 16.70 15.70 15.70 16.70 Unfilled - - - - 1.00 1.00 - 1.50% ISF - Risk' Filled 2.25 2.25 - 2.25 2.25 2.25 2.25 3.25' 3.25' Unfilled - - - - 0.00% 911 Filled 52,00 51.00 49.57 50.57 51.57 52.10 50.10 52.10 Unfilled 8.00 9.00 10.43 9.43 8.43 7.91 9.91 7.91 14.79% Total: Filled 1,064,86 1,074.30 1,095.47 1,096.97 1,107.72 1,111.76 1,104.16 1,120,86 - - - - Unfilled 154.70 145.26 135.29 136,29 126.79 124.26 125.86 112.66 - - - - Total 1,219.56 1,219.56 1,230.76 1,233,26 1,234.51 1,236,01 1,230.01 1,233.51 A - - - - %Unfilled 12.68% 11.91% 10.99% 11.05% 10.27% 10.05% 10.23% 9.13% 10.79% A 3.5 increase in FTE. OA +.5, HS+2, Victims Assistance+1 o`\\v(ESc0G�� Budget to Actuals - Countywide Summary All Departments FY23 YTD February 28, 2023 (unaudited) RESOURCES 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 220 - Justice Court 255 -Sheriff's Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual Countv Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other TOTAL RESOURCES REQUIREMENTS 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 220 - Justice Court 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % 40,504,168 40,047,506 99% 43,472,708 39,853,877 92% ; 43,055,503 99% ; 901,143 1,007,843 112% ; 1,010,203 368,277 36% ; 1,044,516 103% ; 12,578,435 13,029,089 104% ; 13,631,282 9,985,248 73% ; 13,470,028 99% ; 19,000,000 14,281,402 75% 105,186 26,696,233 999% ; 29,118,051 999% ; 550,832 494,676 90% 525,032 329,844 e a 63% 525,490 100% ; 44,947,745 45,776,980 102% ; 48,877,055 47,709,547 98% 49,260,711 101% ; 485727,400 48,848,440 100% ; 57,787,985 41,050,518 71% 62,060,285 107% ; 9,580,316 10,542,434 110% ; 11,675,519 6,404,460 55% 10,158,940 87% ; 22,629,649 24,768,506 109% ; 24,889,063 17,236,267 69% 25,541,559 103% ; 5,840,250 6,1785356 106% ; 6,134,018 4,884,653 80% 6,209,920 101% ; 2,471,190 1,124,832 46% 1,943,063 210,570 11% 570,956 29% ; 13,350,600 13,930,834 104% ; 14,503,499 8,882,936 61% 14,152,571 98% ; 1,395,724 1,779,723 128% ; 1,408,534 1,283,720 91% 1,968,845 140% ; 1,560,500 1,922,671 123% ; 1,849,380 2,365,603 128% ; 2,379,267 129% ; 8,544 8,012 94% 7,414 78,653 999% ; 310,827 999% ; 517,524 584,713 113% ; 642,252 349,099 54% ; 7,546 6,354 84% 6,298 13,065 207% ; 3,146,973 4,409,440 140% ; 3,311,477 2,287,162 69% ; 23,027,177 25,070,639 109% ; 23,658,700 16,200,097 68% ; 12,019,306 12,896,533 107% ; 13,744,678 11,521,383 84% ; 50,071,869 34,055,652 68% 57,902,131 45,469,313 79% ; 312,836,891 300,764,634 96% 327,085,478 283,180,525 87% ; 515,933 80% ; 18,950 301% ; 3,378,141 102% ; 23,980,674 101% ; 13,905,001 101% ; 59,659,653 103% ; 361,285,822 110% ; Fiscal Year 2022 1Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % 21,298,809 19,383,248 91% 24,202,373 14,822,633 61% 23,241,795 96% ; 7,496,355 6,674,328 89% 7,928,538 4,746,165 60% 7,461,591 94% ; 4,010,388 3,826,539 95%' ; 13,113,218 9,628,262 73% 13,046,678 99% ; 38,000,000 14,187,441 37% 23,129,361 10,409,019 45% 23,129,361 100% ; 736,142 690,802 94% 731,183 483,912 o 66% 734,987 101% ; TES` 2� 0 Budget to Actuals - Countywide Summary L� All Departments FY23 YTD February 28, 2023 (unaudited) 255 -Sheriff's Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other 54,162,360 51,382,461 95% ; 58,872,642 51,718,597 88% ; 9,978,889 8,963,943 90% ; 15,024,128 13,771,124 92% ; 7,079,915 6,392,578 90% ; 29,722,691 8,106,117 27% ; 9,709,991 8,792,122 91% ; 2,504,877 2,626,480 105% ; 1,468,131 1,352,783 92% 568,000 7,670 1% ; 552,188 466,135 84% ; 100,000 885 1 % ; 6,427,292 4,982,451 78% ; 29,424,393 29,294,027 100% ; 14,563,007 10,896,900 75% ; 86,872,890 41,149,853 47% TOTAL REQUIREMENTS ; 398,573,088 284,666,484 71% 59,715,533 36,773,861 62% ; 71,019,127 40,493,883 57% ; 11,233,304 6,102,267 54% ; 16,188,996 8,208,427 51% ; 7,575,910 4,266,230 56% ; 28,387,166 13,013,167 46% ; 11,754,672 6,039,776 51% ; 2,768,054 1,892,743 68% ; 1,852,030 1,926,436 104% ; 870,000 133,402 15% ; 594,181 353,494 59% ; 100,000 5,048 5% ; 5,887,806 1,919,657 33% ; 26,769,217 16,085,049 60% ; 17,709,497 8,277,763 47% ; 107,868,168 35,344,106 33% ; 439,398,334 220,925,302 50% ; 66.7% Year Complete 59,075,830 99% ; 66,708,233 94% ; 9,525,958 85% ; 15,479,678 96% ; 6,707,369 89% 22,913,621 81% ; 11,116,519 95% ; 2,735,739 99% ; 2,056,939 111 % ; 870,000 100% ; 548,281 92% ; 100,000 100% ; 4,705,841 80% ; 26,769,217 100% ; 16,636,918 94% ; 99,159,102 92% ; 412,723,657 94% ; ,�31ESC,06 Budget to Actuala - Countywide Summary All Departments 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 TRANSFERS Budget Actuais % Budget Actuals % Projection % 001 - General Fund (21,952,604) (21,807,006) 99% (20,871,416) (13,698,331) 66% (19,698,572) 94% ; 030 - Juvenile 6,223,387 6,223,387 100% ; 6,452,997 4,301,992 67% 6,452,997 100% ; 160/170 -TRT (6,024,574) (5,916,413) 98% ; (6,031,446) (4,020,936) 67% (6,007,331) 100% ; 220 - Justice Court 240,956 196,126 81% ; 263,217 175,472 67% ; 263,217 100% ; 255 -Sheriff's Office 3,500,737 3,501,246 100% ; 3,448,587 2,416,095 70% 3,448,587 100% ; 274 - Health Services 6,122,830 6,122,830 100% ; 8,007,942 4,640,984 58% 5,924,230 74% ; 295 - CDD (270,622) (1,159,207) 428% ; (911,585) (667,494) 73% ; (1,190,207) 131% ; 325 - Road (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% (12,330,136) 100% ; 355 - Adult P&P 471,072 471,071 100% ; 267,532 111,824 42% 267,532 100% ; 465 - Road CIP 12,193,917 10,672,113 88% ; 14,230,313 4,889,361 34% 14,131,212 99% ; 610 - Solid Waste (6,029,323) (6,029,323) 100% ; (5,299,665) (2,649,304) 50% (5,299,665) 100% ; 615 - Fair & Expo 962,736 918,804 95% ; 704,127 469,416 67% 687,245 98% ; 616 - Annual County Fair (75,000) (75,000) 100% ; (156,706) (104,464) 67% (156,706) 100% ; 617 - Fair & Expo Capital 798,901 779,502 98% ; 1,149,827 766,536 67% ; 1,142,594 99% ; Reserve 618 - RV Park 47,958 47,958 100% ; (81,566) (1,048) 1% (81,566) 100% ; 619 - RV Park Reserve 132,042 132,042 100% ; 261,750 174,376 67% 261,566 100% ; 670 - Risk Management (3,500) (3,500) 100% ; (3,500) (2,328) 67% ; (3,500) 100% ; 705 - 911 - - 0% (59,900) (59,900) 100% ; (59,900) 100% ; 999 - Other 15,418,726 17,682,916 115% ; 10,959,373 10,698,525 98% 12,248,403 112% ; TOTAL TRANSFERS 91 - 0 (255) - 0 ; - 0% ; uTES COG2� Budget to Actuals - Countywide Summary All Departments 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 ENDING FUND BALANCE Budget Actuals % Budget Actuals Projection % 001 - General Fund 10,723,375 13,847,827 129% ; 11,374,637 25,180,740 13,962,964 123% ; 030 - Juvenile 596,681 1,522,125 255% ; 634,663 1,446,230 1,558,048 245% ; 160/170 - TRT 8,433,816 9,475,532 112% ; 4,000,000 5,811,581 3,891,551 97% ; 200 - American Rescue - 108,098 999% ; - 16,395,312 6,096,788 999% ; Fund 220 - Justice Court 55,646 - 0% 57,066 21,404 53,720 94% ; 255 -Sheriff's Office 12,160,633 15,162,285 125% ; 7,024,650 28,514,066 8,795,753 125% ; 274 - Health Services 6,011,534 13,942,649 232% ; 6,005,519 19,140,267 15,218,930 253% ; 295 - CDD 763,172 2,168,956 284% ; 1,627,134 1,803,656 1,611,731 99% ; 325 - Road 2,231,806 7,806,356 350% ; 2,262,898 9,393,421 5,538,101 245% ; 355 - Adult P&P 1,971,182 3,238,905 164% ; 1,925,640 3,969,151 3,008,988 156% ; 465 - Road CIP 5,316,460 27,223,832 512% ; 12,334,484 19,310,596 19,012,379 154% ; 610 - Solid Waste 583,520 3,066,662 526% ; 556,359 3,260,518 803,050 144% ; 615 - Fair & Expo 604,256 995,519 165% ; 315,960 855,912 915,871 290% ; 616 - Annual County Fair 17,369 385,854 999% ; 225,358 720,558 551,476 245% ; 617 - Fair & Expo Capital 1,341,108 1,809,440 135% ; 1,587,183 2,521,228 2,392,861 151% ; Reserve o 618 - RV Park 13,294 166,536 999% ; 82,920 161,093 52,622 63% ; 619 - RV Park Reserve 824,054 1,191,937 145% ; 1,340,766 1,374,330 1,372,453 102% ; 670 - Risk Management 5,045,296 8,944,938 177% ; 5,107,351 9,310,115 7,613,738 149% ; 675 - Health Benefits 8,375,402 11,304,191 135% ; 8,815,139 11,419,239 8,515,648 97% ; 705 - 911 9,307,082 12,708,705 137% ; 8,926,080 15,892,424 9,916,888 111% ; 999 - Other 55,322,038 95,096,396 172% ; 56,713,214 118,422,944 71,695,091 126% ; TOTAL FUND BALANCE 129,697,724 230,166,744 177% ; 130,917,021 294,924,784 182,578,651 139% ; o`�uSESC'G1' Budget to Actuals Report General Fund - Fund 001 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance 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 TRANSFERS Transfers In Transfers Out TOTAL TRANSFERS 32,410,716 32,791,880 101% 34,467,173 33,435,857 97% 460,000 337,612 73% 301,000 248,260 82% 2,689,926 2,880,344 107% 3,591,874 3,399,020 95% 987,411 886,514 90% 964,246 350,502 36% o 2,741,215 2,225,591 81% 2,298,566 860,432 37% 14,588 13,216 91% 14,588 5,261 36% 448,201 258,776 58% 1,183,942 1,327,145 112% 341,004 321,554 94% 221,483 89,667 40% 259,107 182,018 70% 214,836 ' 91,009 42% 152,000 150,000 99% 215,000 46,724 22% 40,504,168 40,047,506 99% 43,472,708 39,853,877 92% ; Budget Actuals % Budget Actuals % 5,454,784 5,157,534 95% 5,910,478 3,522,450 60% 2,080,739 1,735,214 83% 2,432,710 1,378,114 57% 82,911 77,147 93% 87,177 56,192 64% 9,715,707 8,677,696 89% 10,979,839 6,747,250 61% 242,652 241,582 100% 438,702 157,821 36% 932,570 886,019 95% 905,262 587,824 65% 795,189 762,328 96% 809,390 469,106 58% 380,061 360,274 95% 508,359 240,957 47% 1,614,196 1,485,453 92% 2,130,456 1,662,919 78% 21,298,809 19,383,248 91% 24,202,373 14,822,633 61% ; Budget Actuals % Budget Actuals % 260,000 260,000 100% 260,000 173,624 67% (22,212,604) (22,067,006) 99% (21,131,416) (13,871,955) 66% (21,952,604) (21,807,006) 99% (20,871,416) (13,698,331) 66% ; 34,378,087 100% (89,086); A 301,000 100% I I 1 3,744,408 104% � 152,534- B I I 964,246 100% - I I 1,598,566 70% 1 (700,000):I C I 14,588 100% I I 1,403,289 119% 1 219,347!1 D 1 I 221,483 100% 214,836 100% � E 1 1 215,000 100% F 43,055,503 99% (417,205); Projection % $ Variance 5,443,924 92% 466,554, G 2,362,964 97% 69,746! H 95,578 I 110% (8,401)1 1 10,617,050 I 97% 362,789- 1 I 438,702 I 100% 884,605 i 98% 20,657! H 808,721 1 I 100% - I 669- H 459,795 � 1 90% 48,564!I H I 1 2,130,456 100% J 23,241,795 96% 960,578: Projection % $ Variance 260,439 100% 439, K I I I (19,959,011) 94% 1,172,405, (19,698,572) 94% 1,172,844, FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 13,470,620 14,990,575 111% 12,975,718 13,847,828 107% 13,847,828 107% 872,110, Resources over Requirements 19,205,359 20,664,258 19,270,335 25,031,244 199813,708 543,373 Net Transfers - In (Out) (21,952,604) (21,807,006) I (20,871,416) (13,698,331) I I (19,698,572) 1 1,172,844 I TOTAL FUND BALANCE . $ 10,723,375 $ 13,847,828 129% ; $ 11,374,637 $ 25,180,740 221% ; $ 13,962,964 123% ; $2,588,327: A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted B PILT payment of $500,000 received in July 2022; includes -$585K for a State Grant that will be passed through to Neighborlmpact for domestic well assistance C Recording fees expected to be lower than budget due to decreased loan origination volume from rising interest rates D Recent budget adjustment to increase State grant funding which is expected to come in later this fiscal year E Oregon Dept. of Veteran's Affairs grant reimbursed quarterly F Interfund land -sale management revenue recorded at year-end G Projected Personnel savings based on FY22/FY23 average vacancy rate of 7.9% H Projected Personnel based on vacancy savings to date I Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.2% j Includes $100K loan to Alfalfa Fire District K Repayment to General Fund from Finance Reserves for ERP Implementation O`�' COG,' Budget to Actuals Report Juvenile -Fund 030 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OYA Basic & Diversion ODE Juvenile Crime Prev Gen Fund -Crime Prevention Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 Miscellaneous OJD Court Fac/Sec SB 1065 Food Subsidy Contract Payments Interest on Investments TOTAL RESOURCES 432,044 500,765 116% 525,049 97,007 18% 100,517 117,184 117% 123,000 51,261 42% 89,500 89,500 100% 89,500 - 0% a s 88,000 89,154 101% 86,000 60,152 70% 80,000 92,400 116% 55,000 79,050 144% 49,339 50,462 102% 49,339 12,616 26% 7,500 29,113 388% 42,500 30,106 71% ee 20,000 10,291 51% 15,000 9,192 61% 12,000 11,380 95% 10,000 7,493 75% 8,000 9,947 124% 8,000 2,930 37% 14,243 7,647 54% 6,815 18,472 271% r 901,143 1,007,843 112% ; 1,010,203 368,277 36% ; 525,049 100% 107,720 88% (15,280)! 89,500 100% i 90,228 105% 4,228! A 90,000 164% 35,000: B 49,339 100% 37,000 87% (5,500); 15,000 100% - 10,000 100% 5,000 63% (3,000); C 25,680 377% 18,865- D r--s 1,044,516 103% ; 34,313: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,082,895 5,411,118 89% 6,332,160 3,849,674 61% 5,884,136 93% 448,024, E Materials and Services 1,363,409 1,249,983 92% 1,527,992 888,891 58% 1,469,180 96% 58,812! F Capital Outlay 50,051 13,226 26% 68,386 7,600 11% 108,275 158% (39,889) TOTAL REQUIREMENTS ; 7,496,355 6,674,328 89% 7,928,538 4,746,165 60% 7,461,591 94% 466,947: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 6,304,397 6,304,397 100% 6,529,064 4,352,696 67% 6,529,064 100% Transfers Out-Veh Reserve (81,010) (81,010) 100% (76,067) (50,704) 67% (76,067) 100% - TOTAL TRANSFERS 6,223,387 6,223,387 100% ; 6,452,997 4,301,992 67% 6,452,997 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 968,506 965,223 100% 1,100,001 1,522,125 138% 1,522,125 138% 422,125, Resources over Requirements (6,595,212) (5,666,485) (6,918,335) (4,377,888) (6,417,075) 501,260! Net Transfers - In (Out) 6,223,387 6,223,387 6,452,997 4,301,992 6,452,997 TOTAL FUND BALANCE $ 596,681 $ 1,522,125 255% ; $ 634,663 $ 1,446,230 228% ; $ 1,558,048 245% ; $923,385: A New lease payment for JBarJ B Savings based on current expense trends for materials and services. C Out of county utilization for last two months is higher than anticipated based on original projection. Can shift daily based on intake activity. D Investment Income projected to come in higher than budget E Projected Personnel savings based on FY23 average vacancy rate of 5.2% F Savings based on current expense trends for materials and services. TES COG2< Budget to Actuals Report TRT - Fund 1601170 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 12,519,987 12,977,205 104% = 13,580,874 9,918,853 73% 13,368,487 98% (212,387); A Interest on Investments 58,448 51,884 89% ! 50,408 66,233 131% ' 101,380 201% 50,972- B Miscellaneous - - - 161 161 161 TOTAL RESOURCES 12,578,435 13,029,089 104% ; 13,631,282 9,985,248 73% 13,470,028 99% (161,254); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Grants & Contributions - - 5,600,000 4,600,000 82% 5,600,000 100% C COVA 3,660,659 3,512,891 96% 3,675,886 2,492,435 68% 3,609,346 98% 66,540: D Interfund Charges 239,526 239,526 100% 3,574,573 2,383,049 67% 3,574,573 100% - E Administrative 15,203 9,365 62% 215,508 122,778 57% 215,508 100% Software 95,000 64,758 68% 47,251 30,000 63% 47,251 100% TOTAL REQUIREMENTS 4,010,388 3,826,539 95% 13,113,218 9,628,262 73% 13,046,678 99% 66,540; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (20,000) (20,000) 100% (20,000) (13,328) 67% (20,000) 100% Transfer Out - Annual Fair (75,000) (75,000) 100% (75,000) (50,000) 67% (75,000) 100% Transfer Out - Justice Court (240,956) (196,126) 81% (263,217) (175,472) 67% (263,217) 100% Transfer Out - Health (444,417) (444,417) 100% (418,417) (278,944) 67% (418,417) 100% Transfer Out - F&E Reserve (498,901) (479,502) 96% (501,683) (334,448) 67% (494,450) 99% 71233� F Transfer Out -F&E (1,093,513) (1,049,581) 96% (1,101,342) (734,224) 67% (1,084,460) 98% 16,882-G Transfer Out - Sheriff (3,651,787) (3,651,787) 100% - (3,651,787) (2,434,520) 67% (3,651,787) 100% TOTAL TRANSFERS (6,024,574) (5,916,413) 98% (6,031,446) (4,020,936) 67% (6,007,331) 100% ; 24,115, FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 5,890,343 6,189,395 105% 9,513,382 9,475,532 100% 9,475,532 100% (37,850); Resources over Requirements 8,568,047 9,202,550 518,064 356,985 423,350 (94,714); Net Transfers - In (Out) (6,024,574) (5,916,413) (6,031,446) (4,020,936) (6,007,331) 24,115 TOTAL FUND BALANCE $ 8,433,816 $ 9,475,532 112% ; $ 4,000,000 $ 5,811,581 145% ; $ 3,891,551 97% ($108,449); A Room Tax collections up 3% over last year versus 5.0% budget assumption B Investment Income projected to come in higher than budget C Includes contributions of $4M to Sunriver Service District, $600K to Deschutes Trail Coalition and $1 M to Mt. Bachelor D Payments to COVA based on a percent of TRT collections E Includes -$3.5M for Interfund Payments to the General County Reserve Fund F The balance of the 1 % F&E TRT is transferred to F&E reserves G Transfer projected to be lower based on decreased Room Tax revenue \)IESCaG2< Budget to Actuals Report ARPA — Fund 200 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments - 93,961 105,186 205,384 195% 316,130 301% 210,944, A Local Assistance & Tribal - - 2,311,073 4,622,145 4,622,145! B Consistency State & Local Coronavirus Fiscal: 19,000,000 14,187,441 75% - 24,179,776 24,179,776 24,179,776: C Recovery Funds TOTAL RESOURCES 19,000,000 14,281,402 75% 105,186 26,696,233 999% ; 29,118,051 999% ; 29,012,865: REQUIREMENTS Services to Disproportionately Impacted Communities Administrative Infrastructure Negative Economic Impacts Public Health TOTAL REQUIREMENTS Budget Actuals % Budget Actuals % 20,650,098 5,242,251 25% 15,394,824 8,250,526 54% 5,281,005 143,079 3% 4,317,328 116,232 3% 2,050,000 527,275 26% 1,634,710 499,535 31% 6,285,840 5,488,685 87% 899,577 674,792 75% 3,733,057 2,786,152 75% 882,922 867,934 98% 38,000,000 14,187,441 37% 23,129,361 10,409,019 45% ; FUND BALANCE Budget Actuals % Budget Actuals Beginning Fund Balance 19,000,000 14,137 0% 23,024,175 108,098 0% Resources over Requirements (19,000,000) 93,961 (23,024,175) 16,287,214 Net Transfers - In (Out) - - TOTAL FUND BALANCE $ 108,098 999% ; $ 16,395,312 999% ; A Investment Income projected to come in higher than budget B A budget adjustment for additional Local Assistance & Tribal Consistency funds is forthcoming Projection % $ Variance 15,394,824 100% D 4,317,328 100% E 1,634,710 100% F 899,577 100% - G 882,922 100% H 23,129,361 100% ; Projection % $ Variance 108,098 0% : (22,916,077- 5,988,690 29,012,865; $ 6,096,788 999% ; $6,096,788, C The revenue received in FY22, but unspent at 06.30.22, was recorded as Deferred Revenue and recognized in FY23 D Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects E Administration holds the balance of the ARPA funds, as well as an approved Management Analyst for ARPA reporting and administration F Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment G Majority of funding is for food programs, $2.5 million in small business assistance and additional funding for Ronald McDonald House and an Apprenticeship jobs program H Approved ARPA funding consists of Isolation Motel Liability Insurance, COVID-19 testing done by Dr. Young, UV sanitizer for the jail to prevent COVID-19 in congregate settings and various Health Services expenses such as temporary staffing costs to support the COVID-19 response oy`�' c�G,< Budget to Actuals Report Justice Court -Fund 220 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 550,000 494,265 90% 525,000 329,483 63% 525,000 100% Interest on Investments 95 45 48% 32 360 999% a 490 999% 458, A Miscellaneous 737 365 50% - - - 2 TOTAL RESOURCES 550,832 494,676 90% 525,032 329,844 63% 525,490 100% ; 458; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 577,209 541,792 94% 569,648 384,053 67% 573,452 101% (3,804); Materials and Services 158,933 149,011 94% 161,535 99,859 62% 161,535 100% B TOTAL REQUIREMENTS 736,142 690,802 94% 731,183 483,912 66% 734,987 101% ; (3,804); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -TRT 240,956 196,126 81% 263,217 175,472 67% 263,217 100% TOTAL TRANSFERS 240,956 196,126 81% 263,217 175,472 67% 263,217 100% ; Resources over Requirements (185,310) (196,126) (206,151) (154,068) ; (209,497) (3,346): Net Transfers - In (Out) 240,956 196,126 263,217 175,472 263,217 TOTAL $ 55,646 - 0% ; $ 57,066 $ 21,404 38% $ 53,720 94% ($3,346); A Investment Income projected to come in higher than budget B One time yearly software maintenance fee paid in July for entire fiscal year Qy`��3 -�ES C-0&' Budget to Actuals Report Sheriff's Office - Fund 255 FY23 YTD February 28, 2023 (unaudited) RESOURCES LED #1 Property Tax Current LED #2 Property Tax Current Sheriffs Office Revenues LED #1 Property Tax Prior LED #2 Property Tax Prior LED #1 Interest LED #2 Interest LED #2 Foreclosed Properties LED #1 Foreclosed Properties TOTAL RESOURCES REQUIREMENTS Digital Forensics Concealed Handgun Licenses Rickard Ranch Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 28,448,529 28,828,746 101% 30,282,049 29,435,182 97% 30,239,651 100% (42,398) A 11,813,562 11,962,302 101% 13,400,541 12,955,817 97% 13,313,046 99% (87,495) B 3,993,964 4,407,029 110% = 4,607,630 4,793,112 104% 4,945,024 107% 337,394, C 330,000 288,862 88% ! 330,000 208,135 63% 330,000 100% 145,000 118,145 81% 145,000 86,050 59% 145,000 100% 147,416 96,152 65% 89,119 185,635 208% 240,230 270% 151,111! C 69,274 24,356 35% 22,716 45,616 201% 47,760 210% 25,044! D 15,070 - - - 36,317 - - - - 44,947,745 45,776,980 102% ; 48,877,055 47,709,547 98% 49,260,711 101% ; 383,656: Budget Actuals % Budget Actuals % Projection % $ Variance - - 808,610 513,303 63% 789,644 98% 18,96& - 335,044 207,406 62% 326,804 98% 8,240, - - 264,871 135,514 51% 264,871 100% 4,002,499 4,208,992 105% 5,863,885 3,295,388 56% 5,172,145 88% 691,740 1,154,204 1,112,473 96% 1,168,300 771,546 66% 1,082,781 93% 85,519! 3,576,342 3,738,777 105% 4,005,888 2,244,153 56% 3,902,719 97% 103,169 3,029,130 3,013,632 99% 3,583,825 2,500,300 70% 3,941,343 110% (357,518)! 14,015,461 13,440,565 96% 14,640,315 9,343,899 64% 14,696,309 100% (55,994) 1,025,023 735,218 72% 944,493 446,609 47% 693,695 73% 250,798! 21,033,697 18,807,184 89% 22,069,320 13,414,302 61% 21,662,166 98% 407,154! 444,617 431,758 97% 424,769 - -- 353,618 ---- 83% --- --- 538,116 ----' 121% ...- -.-.I (113,34t); 789,912 543,303 69% a 829,997 342,473 41% 642,989 77% 187,008 1,775,588 2,053,196 116% 2,047,792 1,547,358 76% 2,429,126 119% (381,334)! 1,626,207 1,786,439 110% 1,907,588 1,024,919 54% 1,901,401 100% 6,187! 1,389,684 1,510,925 109% 820,836 633,073 77% 1,031,721 126% (210,885)! 299,998 - 0% eJ - - 0% - 100% 54,162,360 51,382,461 95% 59,715,533 36,773,861 62% 59,075,830 99% 639,703: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,651,787 3,651,787 100% 3,651,787 2,434,520 67% 3,651,787 100% Transfer In - General Fund 121,950 121,950 100% 70,000 46,664 67% 70,000 100% Transfers Out - Debt Service (273,000) (272,491) 100% (273,200) (65,089) 24% (273,200) 100% TOTAL TRANSFERS 3,500,737 3,501,246 100% ; 3,448,587 2,416,095 70% 3,448,587 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 17,874,511 17,266,520 97% 14,414,541 15,162,285 105% 15,162,285 105% 747,744. Resources over Requirements (9,214,615) (5,605,481) (10,838,478) 10,935,686 (9,815,119) 1,023,359 Net Transfers - In (Out) 3,500,737 3,501,246 3,448,587 2,416,095 3,448,587 TOTAL FUND BALANCE $ 12,160,633 $ 15,162,285 125% ; $ 7,024,650 $ 28,514,066 406% ; $ 8,795,753 125% ; $1,771,103, Note: Vacant positions are driving projected department savings, with other fluctuations causing projected budget overages A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted B Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 4.79% over FY21-22 vs. 5.45% budgeted C Investment Income projected to come in higher than budget D Investment Income projected to come in higher than budget E Savings due to vacant positions oy �jES ` Budget to Actuals Report .�,�. Health Services - Fund 274 FY23 YTD February 28, 2023 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous OHP Fee for Service Federal Grants Local Grants Environmental Health Fees Other State - Medicaid/Medicare Patient Fees Medicaid State - Medicare Vital Records Liquor Revenue Divorce Filing Fees Interfund Contract- Gen Fund State Shared- Family Planning Interest on Investments CCBHC Grant TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 17,641,302 16,634,837 94% 22,223,536 15,038,022 68% 23,838,199 107% 1,614,663: 8,947,837 11,776,144 132% 12,882,624 8,815,044 68% 12,115,681 94% (766,943)! 4,129,465 3,518,729 85% 8,901,719 6,075,414 68% 8,776,839 99% (124,880)= 3,627,151 4,032,343 111% a 3,232,620 2,691,605 83% 4,909,696 152% 1,677,076= 4,303,483 4,090,251 95% 2,615,634 1,400,369 54% 2,694,217 103% 78,583! 1,936,838 3,350,227 173% 2,332,031 1,706,832 73% 1,086,019 1,213,172 112% 1,238,499 1,166,286 94% 884,036 866,362 98% 1,169,317 1,633,353 140% 843,050 777,348 92% 807,530 737,535 91% 468,415 538,392 115% 615,644 419,240 68% 1,014,100 750,524 74% 430,863 416,122 97% 172,200 194,470 113% 337,614 131,660 39% 280,000 342,960 122% 300,000 213,835 71% 157,000 199,100 127% 177,574 84,488 48% 173,030 178,331 103% 173,030 63,178 37% 127,000 127,000 100% 127,000 127,000 100% 152,634 118,228 77% 125,000 94,272 75% 156,549 101,438 65% 97,750 236,264 242% 2,627,291 38,587 1% - - 48,727,400 48,848,440 100% ; 57,787,985 41,050,518 71% ; REQUIREMENTS Budget Actuals % Budget Actuals % Administration Allocation - - 999% - 0% Personnel Services 43,994,358 39,393,426 90% 50,658,752 31,667,391 63% Materials and Services 14,721,284 12,243,043 83% 19,902,800 8,567,085 43% Capital Outlay 157,000 82,128 52% 457,575 259,408 57% TOTAL REQUIREMENTS ; 58,872,642 51,718,597 88% 71,019,127 40,493,883 57% ; TRANSFERS Budget Actuals % Budget Actuals Transfers In- General Fund 5,909,168 5,909,168 100% 6,608,245 4,405,424 67% Transfers In- OHP Mental Health - 1,473,586 368,382 25% Transfers In - TRT 444,417 444,417 100% 418,417 278,944 67% Transfers Out (230,755) (230,755) 100% (492,306) (411,766) 84% TOTAL TRANSFERS 6,122,830 6,122,830 100% ; 8,007,942 4,640,984 58% ; FUND BALANCE Budget Actuals % Budget Actuals Beginning Fund Balance 10,033,946 10,689,975 107% 11,228,719 13,942,649 124% Resources over Requirements (10,145,242) (2,870,157) (13,231,142) 556,635 Net Transfers - In (Out) 6,122,830 6,122,830 o 8,007,942 4,640,984 � TOTAL FUND BALANCE ; $ 6,011,534 $ 13,942,649 232% ; $ 6,005,519 $ 19,140,267 319% ; 2,525,159 108% ! 193,128! 1,261,920 102% 23,421! 2,101,216 180% 931,899! 1,111,814 138% 304,284! 705,952 115% 90,308! 624,183 145% 193,320: 206,824 61% (130,790)! 315,000 105% 15,000! 177,574 100% 63,178 37% (109,852); 127,000 100% -1 158,733 127% 33,733! 347,100 355% 249,350: 62,060,285 107% ; 4,272,300; Projection % $ Variance - 0% - 46,112,138 91% 4,546,614! 20,144,520 101% (241,720); 451,575 99% 6,000- 66,708,233 94% 4,310,894; Projection % $ Variance 5,435,840 82% (1,172,405); 562,279 38% (911,307) 418,417 100% - (492,306) 100% 5,924,230 74% (2,083,712); Projection % $ Variance 13,942,649 124% 2,713,929, (4,647,948) 8,583,194! 5,924,230 (2,083,712) $ 15,218,930 253% ; $9,213,411: o`�uTESCpG2< Budget to Actuals Report Health Services - Admin - Fund 274 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 1,438,843 1,183,981 82% 454,405 323,040 71% ; 747,892 165% 293,487; A State Grant 1 769,319 493,270 64% 379,180 313,969 83% 340,782 90% (38,398)! OHP Capitation - 436,443 367,074 271,662 74% 367,074 100% Other 1 9,200 12,146 132% 160,495 156,577 98% 162,949 102% 2,454- Interest on Investments 1 156,549 101,438 65% 97,750 236,264 242% _ 347,100 355% 249,350! CCBHC Grant 1 486,804 6,938 1% - - Patient Fees � - 1,124 - - - TOTAL RESOURCES 2,860,715 2,235,340 78% 1,458,904 1,301,513 89% 1,965,797 135% ; 506,893: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,904,224 5,832,219 84% 6,738,820 3,934,913 58% 5,875,946 87% 862,874; B Materials and Services 1 6,580,649 6,134,705 93% 7,010,683 4,406,479 63% 7,070,908 101% (60,225)! Administration Allocation (10,188,902) (10,188,901) 100% (11,228,846) (5,530,452) 49% (11,228,846) 100% TOTAL REQUIREMENTS 3,295,971 1,778,023 54% 2,520,656 2,810,940 112% ; 1,718,008 68% 802,649: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In-OHP Mental Health - - 80,771 20,190 25% - 0% (80,771) C Transfers Out 1 (219,794) (219,794) 100% (230,635) (153,752) 67% 1 (230,635) 100% TOTAL TRANSFERS (219,794) (219,794) 100% ; (149,864) (133,562) 89% (230,635) 154% ; (80,771); FUND BALAVAICE Budget Actuals % Budget Actuals % Projection 1 .p %I-.: Beginning Fund Balance ; 3,552,000 3,769,942 106% ; 3,884,332 4,007,465 103% ; ; 4,007,465 103% ; 123,133; Resources over Requirements (435,256) 457,317 (1,061,752) (1,509,428) 247,789 1,309,542! Net Transfers - In (Out) (219,794) (219,794) (149,864) (133,562) (230,635) (80,771) TOTAL FUND BALANCE $ 2,896,950 $ 4,007,465 138% ; $ 2,672,716 $ 2,364,476 88% ; $ 4,024,620 151% ; $1,351,904; A Projection includes unbudgeted FEMA carryforward from FY22 for vaccine clinics and outreach. B Personnel projections based on year to date vacancy savings and assume 3% moving forward. C Transfers In from OHP Mental Health Reserves will occur at end of year. No funds are currently projected to be transferred to Admin Services oy �1Es C, 2� 0 Budget to Actuals Report C� Health Services -Behavioral Health -Fund 274 FY23 YTD February 28, 2023 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous OHP Fee for Service Federal Grants Local Grants Other Patient Fees Medicaid State - Medicare Liquor Revenue Divorce Filing Fees Interfund Contract- Gen Fund CCBHC Grant TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 11,907,014 12,160,202 102% 15,718,843 11,027,434 70% 16,883,785 107% 1,164,94Z A 8,947,837 11,339,701 127% 12,515,550 8,543,381 68% 11,748,607 94% (766,943)! B 1,934,643 1,712,171 89% 8,027,373 5,787,244 72% 7,843,956 98% (183,417); C 3,627,151 4,009,351 111% 3,214,360 2,672,347 83% 4,877,317 152% 1,662,957, B 2,725,623 2,781,433 102% 2,017,169 1,005,729 50% ! 1,783,587 88% (233,582) 1,093,055 1,378,335 126% 1,475,139 840,395 57% a 1,537,053 104% 61,914- 682,180 668,038 98% 719,670 481,960 67% 721,717 100% 0 2,047- 372,115 431,526 116% 519,344 328,696 63% 503,421 97% (15,923) 1,014,100 750,524 74% 430,863 416,122 97% 624,183 145% a 193,320 172,200 194,470 113% 337,614 131,660 39% 206,824 61% (130,790)! 157,000 199,100 127% 177,574 84,488 48% 177,574 100% 173,030 178,331 103% 173,030 63,178 37% a 63,178 37% (109,852); D 127,000 127,000 100% 127,000 127,000 100% 127,000 100% 2,140,487 31,649 1% - - 35,073,435 35,961,830 103% ; 45,453,529 31,509,633 69% 47,098,202 104% ; 1,644,673: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 7,523,855 7,523,855 100% = 8,265,132 4,088,436 49% 8,265,132 100% Personnel Services 26,606,065 24,513,386 92% 32,453,031 20,880,821 64% 29,854,588 92% 29598,443! E Materials and Services 4,882,963 3,690,305 76% 10,260,652 3,218,791 31% 10,078,316 98% 182,335! Capital Outlay 80,000 54,752 68% 225,443 109,100 48% 219,443 97% 6,000, TOTAL REQUIREMENTS 39,092,883 35,782,298 92% 51,204,258 28,297,147 55% 48,417,479 95% 2,786,779. TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -General Fund 2,278,087 2,278,087 100% 2,231,439 1,487,592 67% 1,227,695 55% (1,003,744); F Transfers In- OHP Mental Health - - 1,392,815 348,192 25% a 562,279 40% (830,536); G Transfers Out (10,961) (10,961) 100% (152,921) (149,264) 98% (152,921) 100% , TOTAL TRANSFERS 2,267,126 2,267,126 100% ; 3,471,333 1,686,520 49% 1,637,053 47% (1,834,280); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,612,014 3,870,664 107% 4,788,795 6,317,144 132% 6,317,144 132% 1,528,349- Resources over Requirements (4,019,448) 179,532 (5,750,729) 3,212,487 (1,319,277) 4,431,452- Net Transfers - In (Out) 2,267,126 2,267,126 3,471,333 1,686,520 1,637,053 (1,834,280) TOTAL FUND BALANCE . $ 1,859,692 $ 6,317,322 340% ; $ 2,509,399 $ 11,216,150 447% ; $ 6,634,919 264% ; $4,125,520: A Increase of $1.1 M related to new funds for Aid & Assist ($431 K), a cost of living adjustment ($358K), and carryforward revenue from FY22 ($455k). B A new System of Care wraparound payment was budgeted as part of OHP Capitation, but is coming in as OHP Fee for Service. C Vacancies in I/DD are estimated to result in lower State Miscellaneous revenue than budgeted. D Mediation Program will no longer be managed within Health Services, so funds are transferred out of Health Services E Personnel projections based on year to date vacancy savings and assume 10% moving forward. F Estimating Behavioral Health will return approximately $11M return of County General Funds in FY23. G Transfers In from OHP Mental Health Reserves will occur at end of year. Fewer funds are currently projected to be transferred to Behavioral Health than budgeted. o vTES C �< Budget to Actuals Report L �0 .�� Health Services - Public Health -Fund 274 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 4,964,969 3,981,365 80% 6,125,513 3,696,620 60% 6,613,632 108% 488,119� A Environmental Health Fees 1,086,019 1,213,172 112% 1,238,499 1,166,286 94% 1,261,920 102% 23,421! State Miscellaneous 2,194,822 1,806,557 82% 874,346 288,170 33% 932,883 107% a 58,537! Local Grants 843,783 1,971,892 234% 856,892 866,437 101% 988,106 115% 131,214! B State - Medicaid/Medicare 843,050 777,348 92% 807,530 737,535 91% 1,111,814 138% 304,284! C Vital Records 280,000 342,960 122% 300,000 213,835 71% 315,000 105% 15,000! Other 192,656 186,177 97% 289,152 994,815 344% ' 1,216,550 421% 927,398! D Federal Grants 139,017 124,837 90% 144,060 71,600 50% 162,738 113% 18,678! State Shared- Family Planning 152,634 118,228 77% 125,000 94,272 75% 158,733 127% 33,733- Patient Fees 96,300 105,742 110% 96,300 90,544 94% 202,531 210% 106,231 OHP Fee for Service - 22,993 18,260 19,258 105% 32,379 177% 14,119! TOTAL RESOURCES 10,793,250 10,651,270 99% 10,875,552 8,239,372 76% ; 12,996,286 120% ; 2,120,734: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,665,047 2,665,046 100% 2,963,714 1,442,016 49% 2,963,714 100% Personnel Services 10,484,069 9,047,822 86% 11,466,901 6,851,657 60% 10,381,604 91% 1,085,297: E Materials and Services 3,257,672 2,418,033 74% 2,631,466 941,815 36% 2,995,296 114% (363,830): F Capital Outlay 77,000 27,376 36% 232,132 150,308 65% 232,132 100% a TOTAL REQUIREMENTS 16,483,788 14,158,277 86% 17,294,213 9,385,796 54% 16,572,746 96% 721,467: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -General Fund 3,631,081 3,631,081 100% 4,376,806 2,917,832 67% 4,208,145 96% (168,661): G Transfers In - TRT 444,417 444,417 100% 418,417 278,944 67% 418,417 100% Transfers Out - - (108,750) (108,750) 100% (108,750) 100% TOTAL TRANSFERS 4,075,498 4,075,498 100% ; 4,686,473 3,088,026 66% 4,517,812 96% (168,661); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,869,932 3,049,370 106% 2,555,592 3,618,039 142% 3,618,039 142% 1,062,447, Resources over Requirements (5,690,538) (3,507,006) (6,418,661) (1,146,424) (3,576,460) 2,842,201 Net Transfers - In (Out) 4,075,498 4,075,498 4,686,473 3,088,026 4,517,812 (168,661) TOTAL FUND BALANCE $ 1,254,892 $ 3,617,861 288% ; $ 823,404 $ 5,559,641 675% ; $ 4,559,391 554% ; $3,735,987: A Carryforward of unbudgeted funds are related to vacancies in COVID Team and Public Health Modernization; Includes additional funds for Problem Gambling B Carryforward from FY22 of appx. $40K for Living Well and Diabetes Prevention Programs, as well as reclassifying $60K from Jefferson County for disease investigation C Medicaid revenue trending more than budgeted for the Family Support Services - Nurse Home Visiting Programs D Revenue over budget is related to receipt of additional Opioid Settlement funds for years 1-3 of two settlements. Currently the resources are not obligated, and will fall to fund balance. E Personnel projections based on year to date vacancy savings and assume 6% moving forward. F Increase in expenditures related to additional funds in Prevention Services, including Tobacco Prevention, Diabetes Prevention, and Alcohol and Drug Prevention. Also includes estimated isolation motel expenses and increase MAC/TCM match amounts. G Due to Health Officer vacancy, anticipate returning associated County General Fund ($168K). Q`,��3TES c0' Budget to Actuals Report Community Development - Fund 295 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 138,716 153,688 111% 153,445 104,781 68% 153,095 100% (350)= Code Compliance 842,906 995,865 118% 1,171,592 658,621 56% 994,467 85% (177,125)! A Building Safety 3,819,940 4,325,818 113% 4,821,160 2,819,501 58% 4,549,660 94% (271,500)! A Electrical 914,750 979,129 107% 1,022,005 504,238 49% 785,505 77% (236,500)! A Onsite Wastewater 1,056,678 983,462 93% 1,017,678 484,326 48% 741,551 73% (276,127)! A Current Planning 1,980,521 2,223,570 112% 2,425,334 1,265,790 52% 2,020,184 83% (405,150): A Long Range Planning 826,806 880,902 107% 1,064,305 567,203 53% 914,478 86% (149,827)A TOTAL RESOURCES 9,580,316 10,542,434 110% ; 11,675,519 6,404,460 55% 10,158,940 87% , (1,516,579); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 3,137,795 2,960,981 94% 3,432,980 2,010,780 59% 3,036,185 88% 396,795: B Code Compliance 617,012 618,343 100% 805,614 481,471 60% 727,486 90% 78,128- B Building Safety 2,284,444 2,022,820 89% 2,538,721 1,232,323 49% 1,958,475 77% 580,246! B Electrical 556,531 553,223 99% 641,837 352,498 55% 542,970 85% 98,867! B Onsite Wastewater 765,935 643,079 84% 753,369 478,737 64% a 736,269 98% 17,100- Current Planning 1,769,333 1,589,882 90% 2,062,044 993,775 48% 1,566,634 76% 495,410. B Long Range Planning 847,839 575,615 68% 998,739 552,683 55% 957,939 96% 40,800! TOTAL REQUIREMENTS ; 9,978,889 8,963,943 90% 11,233,304 6,102,267 54% 9,525,958 85% 1,707,346: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 290,000 170,661 59% 160,000 90,556 57% 160,000 100% C Transfers In - CDD Electrical - - - 65,000 98,714 98,714, D Reserve Transfers Out (99,360) (99,360) 100% (112,619) (75,056) 67% ; (112,619) 100% -� Transfers Out - CDD Reserve (461,262) (1,230,508) 267% (958,966) (747,994) 78% (1,336,302) 139% (377,336). E TOTAL TRANSFERS (270,622) (1,159,207) 428% ; (911,585) (667,494) 73% (1,190,207) 131% ; (278,622); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,432,367 1,749,673 122% 2,096,504 2,168,956 103% 2,168,956 103% 72,452- Resources over Requirements (398,573) 1,578,491 442,215 302,193 632,982 190,767! Net Transfers - In (Out) (270,622) (1,159,207) (911,585) (667,494) (1,190,207) (278,622)! TOTAL FUND BALANCE ; $ 763,172 $ 2,168,956 284% ; $ 1,627,134 $ 1,803,656 111% ; ; $ 1,611,731 99% ($15,403); A YTD revenue collection is lower than anticipated due to application volume decrease B Projections reflect unfilled positions C $40K to Current Planning will be transferred as needed D Transfer in from reserves anticipated due to revenue collection less than anticipated E Transfer out projection increased due to reduced expenditures related to unfilled FTE Q`�uTES COG2< Budget to Actuals Report Road - Fund 325 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Motor Vehicle Revenue 17,485,000 19,740,504 113% a 19,483,147 14,030,626 72% 20,103,788 103% 620,641- A Federal - PILT Payment 2,096,751 2,195,918 105% 2,200,000 2,239,616 102% 2,239,616 102% 39,616- B Other Inter -fund Services 1,221,632 1,254,413 103% 1,311,901 208,399 16% 1,300,901 99% (11,000) Forest Receipts 627,207 792,420 126% 882,502 - 0% 792,322 90% (90,180); Sale of Equip & Material 449,150 341,833 76% 426,000 334,223 78% 474,833 111% 48,833 Cities-Bend/Red/Sis/La Pine 560,000 155,269 28% 403,731 266,129 66% 399,488 99% (4,243) Miscellaneous 67,340 68,747 102% 77,610 51,362 66% 84,410 109% 6,800 Interest on Investments 59,109 55,083 93% 54,172 61,557 114% 70,000 129% 15,828- C Mineral Lease Royalties 60,000 148,267 247% - 50,000 20,429 41% 50,000 100% State Miscellaneous - 20,000 20,000 20,000- Assessment Payments (P&I) 3,460 16,052 464% - - 3,927 6,200 6,200! D TOTAL RESOURCES 22,629,649 24,768,506 109% ; 24,889,063 17,236,267 69% 25,541,559 103% ; 652,496: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,916,229 6,751,810 98% 7,802,271 4,728,072 61% 7,166,909 92% 635,362, E Materials and Services 7,843,400 6,877,560 88% 8,246,700 3,391,333 41% 8,175,661 99% 71,039! Capital Outlay 264,500 141,754 54% 140,025 89,022 64% 137,109 98% 2,917- TOTAL REQUIREMENTS 15,024,128 13,771,124 92% ; 16,188,996 8,208,427 51% ; ; 15,479,678 96% 709,317, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (11,757,547) (11,757,547) 100% (12,330,136) (7,440,775) 60% (12,330,136) 100% TOTAL TRANSFERS (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% ; (12,330,136) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,383,832 8,566,521 134% 5,892,967 7,806,356 132% 7,806,356 132% 1,913,390: Resources over Requirements 7,605,521 10,997,382 8,700,067 9,027,840 10,061,881 1,361,813! Net Transfers - In (Out) (11,757,547) (11,757,547) (12,330,136) (7,440,775) (12,330,136) TOTAL FUND BALANCE $ 2,231,806 $ 7,806,356 350% ; $ 2,262,898 $ 9,393,421 415% ; $ 5,538,101 245% ; $3,275,203: A Updated fall projection per AOC/CRP g Actual payment higher than budget C Investment Income projected to come in higher than budget D Updated based on YTD actuals trending higher than budgeted E Projected Personnel savings based on FY23 average vacancy rate of 6.8% ES cOG2< Budget to Actuals Report Adult P&P - Fund 355 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,202,885 4,734,453 113% 4,734,453 3,550,840 75% 4,734,453 100% CJC Justice Reinvestment 781,597 892,038 114% 892,038 943,172 106% 943,171 106% 51,133, A DOC Measure 57 255,545 244,606 96% 244,606 271,606 111% 271,606 111% 27,000- B State Miscellaneous 138,000 96,068 70% 123,453 44,771 36% 100,000 81% (23,453)! C Interfund- Sheriff 50,000 55,000 110% 50,000 33,333 67% 50,000 100% Gen Fund/Crime Prevention 50,000 50,000 100% 50,000 - 0% 50,000 100% Oregon BOPPPS 24,281 20,318 84% 20,318 - 0% - 0% (20,318); D Interest on Investments 45,193 19,125 42% 18,151 40,256 222% 59,390 327% 41,239, E Miscellaneous 500 3,904 781% 500 74 15% 500 100% Electronic Monitoring Fee 2,500 280 11% 500 601 120% 800 160% 300- F DOC-Family Sentence Alt 118,250 58,958 50% - - - Probation Work Crew Fees 1,500 - 0% - - - Probation Supervision Fees 170,000 3,606 2% - - - TOTAL RESOURCES 5,840,250 6,178,356 106% ; 6,134,018 4,884,653 80% 6,209,920 101% ; 75,902; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,379,503 4,864,354 90% 5,683,822 3,280,115 58% 4,888,952 86% 794,870; G Materials and Services 1,700,412 1,528,224 90% 1,883,614 985,517 52% 1,809,942 96% 73,672! H Capital Outlay - - 8,475 598 7% 8,475 100% TOTAL REQUIREMENTS 7,079,915 6,392,578 90% 7,575,910 4,266,230 56% 6,707,369 89% 868,542: TRANSFERS Budget Actuals q/ Budget Actuals % Proiprainn % $ Variance Transfers In- General Funds 662,046 662,045 100% 536,369 357,568 67% 536,369 100% Transfer to Vehicle Maint (190,974) (190,974) 100% (69,277) (46,184) 67% (69,277) 100% Transfers Out - - (199,560) (199,560) 100% (199,560) 100% TOTAL TRANSFERS 471,072 471,071 100% ; 267,532 111,824 42% 267,532 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,739,775 2,982,055 109% 3,100,000 3,238,905 104% - 3,238,905 104% 138,904- Resources over Requirements (1,239,665) (214,221) (1,441,892) 618,422 (497,448) 944,444 Net Transfers - In (Out) 471,072 471,071 267,532 111,824 267,532 TOTAL FUND BALANCE $ 1,971,182 $ 3,238,905 164% ; $ 1,925,640 $ 3,969,151 206% ; ; $ 3,008,988 156% ; $1,083,348, A Received additional JRI funding for training, equity plan, and community engagement. B DOC has increased funds for M57. Deschutes County received an additional $27K for housing and curriculum training C Close out of Adult Treatment Court. No longer accepting new clients. D Hearings officer agreement with board of supervision is payment in even year. Payment will come next year. E Investment Income projected to come in higher than budget F Received additional electronic monitoring restitution payments. G Projected Personnel savings based on FY23 average vacancy rate of 13.9% H Adult Treatment Court Closure and based on other expense trends. 01ES c0' Budget to Actuals Report Road CIP - Fund 465 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Miscellaneous 2,191,461 1,000,000 46% 1,818,500 - 0% 267,106 15% (1,551,394): A Interest on Investments 279,729 124,832 45% 124,563 210,570 169% 303,850 244% 179,287: B TOTAL RESOURCES 2,471,190 1,124,832 46% 1,943,063 210,570 11% 570,956 29% (1,372,107); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 109,870 109,870 100% 127,640 85,093 67% 127,640 100% Capital Outlay 29,612,821 7,996,247 27% 28,259,526 12,928,074 46% 22,785,981 81% 5,473,545� TOTAL REQUIREMENTS 29,722,691 8,106,117 27% ; 28,387,166 13,013,167 46% 22,913,621 81% 5,473,545: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 12,193,917 10,672,113 88% 14,230,313 4,889,361 34% 14,131,212 99% (99,101) TOTAL TRANSFERS 12,193,917 10,672,113 88% 14,230,313 4,889,361 34% 14,131,212 99% (99,101); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 20,374,044 23,533,004 116% 24,548,274 27,223,832 111% 27,223,832 111% 2,675,558, Resources over Requirements (27,251,501) (6,981,285) (26,444,103) (12,802,597) (22,342,665) 4,101,438! Net Transfers - In (Out) 12,193,917 10,672,113 14,230,313 4,889,361 14,131,212 (99,101) TOTAL FUND BALANCE $ 5,316,460 $ 27,223,832 512% ; $ 12,334,484 $ 19,310,596 157% ; $ 19,012,379 154% ; $6,677,895: A $1 M was budgeted in FY23, but received in FY22 B Investment Income projected to come in higher than budget �yC.w1E5C�G� Budget to Actuals Report Road CIP (Fund 465) - Capital Outlay Summary by Project 66.7% FY23 YTD February 28, 2023 (unaudited) Year Completed Fiscal Year 2022 Fiscal Year 2023 Budget I Actuals % Budget Actuals % Projection % $ Variance Terrebonne Refinement Plan i $ 10,000,000 $ - US 20 at Tumalo 6,700,000 - Tumalo Road / Tumalo Place - 67,998 Old Bend Rdm/Tumalo Rd Inter - 16,907 NE Negus and 17TH 2,363,532 2,142,875 91 Hunnel Rd: Loco Rd to Tumalo Rd 2,168,940 637,975 29 Transportation System Plan Update 108,510 86,081 79 Gribbling Rd Bridge 279,575 1,110 0% Terrebonne Wastewater Feasibility St. - 35,130 Rickard Rd: Groff Rd to US 20 1,716,142 1,391,051 81 Paving Powell Butte Hwy 931,140 1,319,374 142 Smith Rock Way Bridge Replace 505,000 1,869 0% Deschutes Mkt Rd/Hamehook Round 671,000 208,367 31 Paving Cottonwood: Us 97 To BSNF RR 618,144 499,075 81 Paving Desch Mkt Rd: Yeoman Hamehoo 310,836 - 0 Paving Alfalfa Mkt Rd: Mp 4 Dodds 266,000 2,638 1 Paving Of Hamby Rd: Us 20 To Butler 200,000 1,912 1 % Powell Butte Hwy/Butler Market RB 150,000 38,562 26% Wilcox Ave Bridge #2171.03Replacement 100,000 - 0% US 20: Tumalo Multi -Use Path Crossing 1,250,000 1,200,000 96% Highway Warning Systems 2021 - 69,536 Tumalo Wastewater Feasibility Study 219 Paving Tumalo Rd/Deschutes Mkt Rd - 1,640 Slurry Sea[ 2022 - 1,148 Paving of Rosland Rd: US 20 to Draf ' Intersection Safety Improvements ' Hamehook Rd Bridge #16181 Rehabilitation NW Lower Bridge Way: 43rd St to Holmes Rd " Northwest Way: NW Coyner Ave to NW Altmeter Wy ' Slurry Scal 2023 - - Terrebonne Wastewater System Phase 1 ' Tumalo Reservoir Rd: OB Riley to Sisemore Rd - - Local Road Pavement Preservation " Paving Butler Market - Hamehook to Powell Butte Old Bend Rdm Hwy - US 20 to Tumalo FY 22 Guardrail Improvements 100,000 114,378 114 % FY 23 Guardrail Improvements " Redmond District Local Roads 500,000 - 0% Bend District Local Roads 500,000 - 0 Sidewalk Ramp Improvements 75,000 156,557 209% Signage Improvements 100,000 1,843 2% TOTAL CAPITAL OUTLAY $ 29,612,821 $ 7,996,247 27' A Budgeted in FY 22 in project US 20: Cook Ave/OB Riley Rd (Tumalo) B This project will be moved to FY 24 C These projects were re -named to Local Road Pavement Preservation $ 7,319,310 $ 2,200,000 30% :$ 2,200,000 30% $ 5,119,310 6,700,000 6,700,000 100% 6,700,000 100% 4,265,216 132,792 3% i 4,017,815 94% - 37,725 77,100 818,500 53,796 7% 267,106 33% 985,000 49,567 5% 's 256,699 26% 1,663,000 190,438 11 % 2,305,294 139 % 443,000 0% 0% 1,200,000 1,788,826 149% 1,788,826 149% 333,000 999,285 300% 999,286 300% 785,000 125,788 16% ': 306,153 39% 160,000 0% 0% 246,000 32,693 13% 32,693 13% - 337,183 337,183 380,000 0% i 393,000 103% 150,000 - 0% 0% 96,500 - 0% 40,000 41% 100,000 155 0% 60,000 60% 815,000 - 0% $15,000 100% 300,000 0% i 300,000 100% 1,000,000 - 0% i 0% 100,000 - 0% i 35,000 35 200,000 - 0% 0% 1,000,000 500,000 150,000 - 0% 1: 75,000 50% 50,000 182,670 365% 182,670 365% - 97,156 97,156 247,401 (77,100) 551,394 728,301: (642,294) 443,000 (588,826) (666,286) 478,847 160,000 213,308 (337,183) (13,000) 150,000 56,500 40,000 1,000,000:: IS 65,000 200,000 C 75,000: - C -iC (132,670) (97,156):: $ 6,973,546 �v(ES CpG2� Budget to Actuals Report Solid Waste -Fund 610 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Franchise Disposal Fees 7,124,000 6,891,500 97% 7,210,000 4,328,467 60% 7,030,000 98% (180,000); A Private Disposal Fees 2,827,000 3,191,189 113% 3,337,000 1,952,171 59% 3,020,000 91% (317,000); A Commercial Disp. Fee 2,686,000 3,075,123 114% 3,234,000 1,976,744 61% 3,210,000 99% (24,000); A Franchise 3% Fees 290,000 337,878 117% 305,000 273,469 90% 350,000 115% 45,000- B Yard Debris 300,000 268,060 89% 290,000 185,544 64% 290,000 100% ! C Miscellaneous 55,000 88,470 161% 70,000 93,367 133% : 140,000 200% 70,000! D Interest on Investments 41,599 27,916 67% 30,498 23,785 78% 35,570 117% 5,072! E Special Waste 15,000 37,718 251% 15,000 44,444 296% 70,000 467% 55,000: F Recyclables 12,000 12,980 108% 12,000 4,944 41% 7,000 58% (5,000); G Leases 1 1 100% 1 1 100%! 1 100% TOTAL RESOURCES 13,350,600 13,930,834 104% ; 14,503,499 8,882,936 61% ; 14,152,571 98% (350,928); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,754,132 2,694,834 98% 3,277,684 1,966,880 60% 3,277,684 100% Materials and Services 5,651,103 5,192,786 92% 6,473,358 3,217,340 50% 5,890,740 91% 582,619- H Capital Outlay 53,141 76,304 144% 264,000 109,970 42% 208,465 79% 55,535! 1 Debt Service 1,251,615 828,197 66% 1,739,630 745,586 43% 1,739,630 100% TOTAL REQUIREMENTS 9,709,991 8,792,122 91% ; 11,754,672 6,039,776 51% ; 11,116,519 95% 638,154: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment (6,029,323) (6,029,323) 100% (5,299,665) (2,649,304) 50% (5,299,665) 100% - Reserve TOTAL TRANSFERS (6,029,323) (6,029,323) 100% ; (5,299,665) (2,649,304) 50% (5,299,665) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,972,234 3,957,273 133% 3,107,198 3,066,662 99% 3,066,662 99% (40,535); Resources over Requirements 3,640,609 5,138,712 2,748,827 2,843,160 3,036,052 287,226- Net Transfers - In (Out) (6,029,323) (6,029,323) (5,299,665) (2,649,304) (5,299,665) TOTAL FUND BALANCE $ 583,520 $ 3,066,662 526% ; $ 556,359 $ 3,260,518 586% ; $ 803,050 144% ; $246,690: A Total disposal fee projections reflect management's best estimate of revenues to be collected. Although YTD total disposal volumes slightly exceed last year-to-date by -1 %, they are less than budgeted. Franchise disposal fee payments of $416K were not received from Republic Services (Bend Garbage, High Country, Wilderness) by closing. B Annual fees due April 15, 2023; received year-to-date monthly installments from Republic and the annual payment from Cascade Disposal C Revenue is seasonal with higher utilization in summer months D Proceeds from cell 9 rock excavation have positively impacted miscellaneous revenue E Investment Income projected to come in higher than budget F Revenue source is unpredictable and dependent on special clean-up projects of contaminated soil and asbestos (i.e. gas station remediation) G Recycling material values have dropped H Projecting to spend less than anticipated due to the timing of services (waste characterization study, mulch grinding, etc.), adding Site Attendants versus using temporary labor, environmental and general repair and maintenance costs. I Postponing the Negus kiosks to early next fiscal year; Negus push box included in the purchase of the loader in Fund 614 O`�uTESCOG2< Budget to Actuals Report Fair &Expo - Fund 615 FY23 YTD February 28, 2023 (unaudited) RESOURCES Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Camping Fee Interest on Investments Miscellaneous Interfund Payment TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 578,000 786,724 136% = 745,759 553,398 74% 857,000 115% 111,241- 513,500 792,639 154% 415,000 583,481 141% - 843,000 203% ° 428,000- 105,000 38,192 36% 105,000 54,400 52% 77,500 46,525 60% 65,000 31,374 48% 71,500 66,636 93% 49,000 44,625 91% 19,500 11,675 60% 20,000 3,475 17% 474 5,301 999% 5,221 9,813 188% 250 2,032 813% 3,554 3,155 89% 30,000 30,000 100% - - 1,395,724 1,779,723 128% ; 1,408,534 1,283,720 91% ; 80,000 76% (25,000); 44,000 68% (21,000); 104,000 212% 55,000, 23,000 115% 3,000! 14,690 281% 9,469! A 3,155 89% (399); 1,968,845 140% ; 560,311: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 1,118,980 1,129,821 101% 1,256,902 800,294 64% 1,126,030 90% 130,872- B Personnel Services - F&B 181,593 200,062 110% 170,247 53,439 31% 114,438 67% 55,809! C Materials and Services 818,804 852,050 104% 965,684 703,502 73% 1,019,000 106% (53,316) Materials and Services - F&B 282,500 342,748 121% 273,950 278,458 102% 375,000 137% (101,050)! Debt Service 103,000 101,799 99% 101,270 57,050 56% 101,270 100% TOTAL REQUIREMENTS 2,504,877 2,626,480 105% ; 2,768,054 1,892,743 68% ; 2,735,739 99% ; 32,315: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 1,093,513 1,049,581 96% 1,101,342 734,224 67% 1,084,460 98% (16,882): D Transfers In - Park Fund 30,000 30,000 100% 30,000 20,000 67% 30,000 100% Transfers In - County Fair 150,000 150,000 100% - - Transfers Out (310,777) (310,777) 100% (427,215) (284,808) 67% (427,215) 100% TOTAL TRANSFERS 962,736 918,804 95% 704,127 469,416 67% 687,245 98% (16,882); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 750,673 923,473 123% - 971,352 995,519 102% - 995,519 102% - 24,167• Resources over Requirements (1,109,153) (846,757) (1,359,520) (609,023) (766,894) 592,626! Net Transfers - In (Out) 962,736 918,804 704,127 469,416 687,245 (16,882) TOTAL FUND BALANCE $ 604,256 $ 995,519 165% ; $ 315,960 $ 855,912 271% ; $ 915,871 290% ; $599,911: A Investment Income projected to come in higher than budget B Projected Personnel savings based on FY23 average vacancy rate of 20% C Projected Personnel based on vacancy savings to date D Transfers expected to be higher than budget due to increased Room Tax revenue \)IES coG�< Budget to Actuals Report Annual County Fair -Fund 616 FY23 YTD February 28, 2023 (unaudited) RESOURCES Gate Receipts Concessions and Catering Carnival Commercial Exhibitors Fair Sponsorship State Grant Rodeo R/V Camping/Horse Stall Rental Livestock Entry Fees Merchandise Sales Interest on Investments TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 550,000 738,029 134% = 710,000 782,364 110% 782,424 110% 72,424- 385,000 526,737 137% 0 505,000 815,458 161% - 815,461 161% - 310,461- 330,000 415,716 126% 385,000 433,682 113% 433,682 113% - 48,682- 110,000 86,200 78% 80,000 117,100 146% 117,100 146% 37,100: 83,500 51,035 61% 61,000 101,370 166% 109,370 179% 48,370! 52,000 53,167 102% 53,167 53,167 100% 53,167 100% 20,000 24,050 120% 24,000 30,970 129% 30,970 129% 6,970! 25,500 19,815 78% 20,000 17,520 88% 17,520 88% (2,480)' 4,500 - 0% ! 5,000 1,925 39% 2,169 43% (2,831) - 5,239 3,500 3,245 93% 3,245 93% (255) - 2,683 2,713 8,803 324% 14,160 522% - 11,447- A 1,560,500 1,922,671 123% ; 1,849,380 2,365,603 128% ; ; 2,379,267 129% ; 529,887; REQUIREMENTS Budget Actuals % Budget Actuals % Personnel Services 155,959 36,681 24% 169,445 124,375 73% Materials and Services 1,312,172 1,316,102 100% 1,682,585 1,802,061 107% TOTAL REQUIREMENTS 1,468,131 1,352,783 92% 1,852,030 1,926,436 104% ; TRANSFERS Budget Actuals % Budget Actuals Transfer In - TRT 1% 75,000 75,000 100% 75,000 50,000 67% Transfer Out - Fair & Expo (150,000) (150,000) 100% o - Transfers Out - (231,706) (154,464) 67% TOTAL TRANSFERS (75,000) (75,000) 100% ; (156,706) (104,464) 67% ; FUND BALANCE Budget Actuals % Budget Actuals % Beginning Fund Balance - (109,033) 999% 384,715 385,854 100% Resources over Requirements 92,369 569,888 (2,650) 439,167 Net Transfers - In (Out) (75,000) (75,000) (156,706) (104,464) TOTAL FUND BALANCE $ 17,369 $ 385,854 999% ; $ 225,358 $ 720,558 320% ; A Investment Income projected to come in higher than budget Projection % $ Variance 179,354 106% (9,909); 1,877,585 112% (195,000) 2,056,939 111% ; (204,909); Projection % $ Variance i 75,000 100% � e (231,706) 100% (156,706) 100% ; Projection % $ Variance 385,854 100% 1,139, 322,328 324,978, (156,706) $ 551,476 245% ; $326,118: `\XV"CES CMG Budget to Actuals Report Annual County Fair - Fund 616 z�. Fair 2023 << Actuals to 2023 Fair 2022 Date Projection RESOURCES Gate Receipts $ 782,364 $ 775,000 Carnival 433,682 M, 430,000 Commercial Exhibitors 436,292 .�M4� - 433,200 Livestock Entry Fees 1,925 - 2,000 RN Camping/Horse Stall Rental 17,392 z - 17,250 Merchandise Sales 3,245 2,500 Concessions and Catering 497,366 - 475,000 Fair Sponsorship 126,300 - 64,825 TOTAL FAIR REVENUES $ 2,298,566 $ - $ 2,199,775 OTHER RESOURCES State Grant 53,167 a - 53,167 Interest 5,794 _gl 2,769 2,769 ? Miscellaneous - TOTAL RESOURCES $ 2,357,526$ 2,769 $ 2,255,711 REQUIREMENTSzti Personnel 102,763 30,527 183,155 Materials & Services 1,722,703 63,056 1,982,066 TOTAL REQUIREMENTS $ 1,825,466 ' $ 93,583 $ 2,165,222 TRANSFERS Transfer In - TRT 1 % 68,750 12,500 12,500 Transfer Out - F&E Reserve (96,540) s (38,616) (38,616) Transfer Out - Fair & o Exp rs- - ' - - TOTAL TRANSFERS $ (27,790) $ (26,116) $ (26,116) Net Fair $ 504,270 $ (116,930) $ 64,373 Beginning Fund Balance on Jan 1 k`zsk n1 $ 448,151 01,111 $ 952,421 $ 952,421 3uy}a Ending Balance $ 952,421 835,491 $ 1,016,794 Es `oGZ� Budget to Actuals Report Fair & Expo Capital Reserve - Fund 617 66 7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 8,544 8,012 94% 7,414 23,098 312% 33,050 446% 25,636- A Local Government Payments 1 - - - 55,555 277,777 1 277,777! B TOTAL RESOURCES 8,544 8,012 94% 7,414 78,653 999% ; 310,827 999% ; 303,413: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 180,000 8,564 5% 220,000 33,402 15% 220,000 100% Capital Outlay 1 388,000 (894) 0% 650,000 100,000 15% I 650,000 100% C TOTAL REQUIREMENTS 568,000 7,670 1% 870,000 133,402 15% 870,000 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -TRT 1% 498,901 479,502 96% 501,683 334,448 67% 494,450 99% (7,233) D Transfers In - Fair & Expo 300,000 300,000 100% 1 416,437 277,624 67% 1 416,437 100% Transfers In -Annual County Fair - 231,706 154,464 67% 231,706 100% TOTAL TRANSFERS 798,901 779,502 98% 1,149,827 766,536 67% 1,142,594 99% (7,233); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,101,663 1,029,596 93% 1,299,942 1,809,440 139% 1,809,440 139% 509,4W Resources over Requirements (559,456) 342 (862,586) (54,749) (559,173) 303,413- Net Transfers - In (Out) I 798,901 779,502 1 1,149,827 766,536 1 1 1,142,594 1 (7,233) I TATAI ClIIA,D BALANCE1,341,108 _ $ 1,341, 108 $ 1,809,440 135% ; G IS 1,58/, 183 E n A �f0 A_ n°/ .p 2,521,2L0 I5' /0 , C �1 n�1 O A AGA O/ �p 2,392,061 1J1 /O , COAL C']O� .PO- &70, A Investment Income projected to come in higher than budget B Awarded a grant for 278k which will help offset the budgeted HVAC replacement expenses C Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction D Transfers expected to be higher than budget due to increased Room Tax revenue Qy`�viES C-0Gz' Budget to Actuals Report RV Park - Fund 618 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 495,000 551,683 111% 605,000 326,462 54% _ 480,000 79% (125,000); A Cancellation Fees - 15,725 14,000 5,557 40% 13,916 99% (84) RV Park Fees > 30 Days 10,500 8,499 81% 13,000 8,914 69% 10,000 77% (3,000); B Washer/Dryer 5,000 3,476 70% 4,200 3,815 91% 5,302 126% 1,102, Miscellaneous 2,500 3,731 149% 3,750 1,665 44% 2,557 68% (1,193)a Vending Machines 2,500 1,021 41% 1,750 988 56% 1,498 86% (252) Interest on Investments 2,024 578 29% 552 1,698 308% 2,660 482% 2,108� C TOTAL RESOURCES 517,524 584,713 113% ; 642,252 349,099 54% 515,933 80% (126,319); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 19,456 1,643 8% 111,153 51,743 47% 91,063 82% 20,090, D Materials and Services 310,805 242,863 78% 259,755 136,218 52% 233,945 90% 25,810, Debt Service 221,927 221,629 100% 223,273 165,533 74% 223,273 100% TOTAL REQUIREMENTS 552,188 466,135 84% 594,181 353,494 59% 548,281 92% 45,900: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 160,000 100% 160,000 100% Transfers In -TRT Fund 20,000 20,000 100% 20,000 13,328 67% 20,000 100% Transfer Out - RV Reserve (132,042) (132,042) 100% (261,566) (174,376) 67% (261,566) 100% TOTAL TRANSFERS 47,958 47,958 100% ; (81,566) (1,048) 1% (81,566) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 116,415 166,536 143% ; 166,536 143% ; 50,121: Resources over Requirements (34,664) 118,578 48,071 (4,395) (32,348) (80,419); Net Transfers - In (Out) 47,958 47,958 (81,566) (1,048) (81,566) TOTAL FUND BALANCE ; $ 13,294 $ 166,536 999% ; $ 82,920 $ 161,093 194% ; $ 52,622 63% ($30,298); A Expecting less volume due to higher fuel prices and economic concerns B Expecting less volume due to new RV park in Redmond offering stays longer than 45 days C Investment Income projected to come in higher than budget D Projected Personnel based on vacancy savings to date \31ES C0& Budget to Actuals Report i RV Park Reserve - Fund 619 66.7% FY23 YTD February 28, 2023 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 7,546 6,354 84% 6,298 13,065 207% 18,950 301 % 12,652, A TOTAL RESOURCES 7,546 6,354 84% 6,298 13,065 207% ; ; 18,950 301% ; 12,652: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Capital Outlay 100,000 885 1% 100,000 5,048 5% 100,000 100% B TOTAL REQUIREMENTS 100,000 885 1% 100,000 5,048 5% 100,000 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - RV Park Ops 132,042 132,042 100% 261,750 174,376 67% 261,566 100% (184): TOTAL TRANSFERS 132,042 132,042 100% ; 261,750 174,376 67% 261,566 100% ; (184); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 784,466 1,054,426 134% 1,172,718 1,191,937 102% 1,191,937 102% 19,219- Resources over Requirements (92,454) 5,469 (93,702) 8,017 (81,050) 12,652, Net Transfers - In (Out) 132,042 132,042 261,750 174,376 261,566 (184) TOTAL FUND BALANCE $ 824,054 $ 1,191,937 145% ; $ 1,340,766 $ 1,374,330 103% ; $ 1,372,453 102% ; $31,687: A Investment Income projected to come in higher than budget B Capital Outlay appropriations are a placeholder \)IES COG%' Budget to Actuals Report Risk Management - Fund 670 FY23 YTD February 28, 2023 (unaudited) RESOURCES Workers' Compensation General Liability Unemployment Property Damage Vehicle Interest on Investments Claims Reimbursement Skid Car Training Process Fee- Events/ Parades Miscellaneous 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 1,120,766 1,164,543 104% 1,234,761 817,147 66% 1,234,761 100% 944,278 940,773 100% 892,681 595,121 67% a 892,681 100% 323,572 334,147 103% 430,179 330,565 77% 430,179 100% A 393,546 409,593 104% 419,566 279,711 67% 419,566 100% 227,700 227,700 100% 248,764 165,843 67% 248,764 100% 101,111 50,142 50% 49,346 91,679 186% 134,010 272% 84,664! B 25,000 1,280,876 999% 25,000 6,476 26% 15,000 60% (10,000); 10,000 - 0% 10,000 (144) -1% 2,000 20% (8,000); C 1,000 1,485 149% 1,000 765 77% 1,000 100% - 180 180 - 0% 180 100% TOTAL RESOURCES 3,146,973 4,409,440 140% ; 3,311,477 2,287,162 69% ; , 3,378,141 102% ; 66,664: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance General Liability 3,600,000 2,706,359 75% 3,000,000 354,399 12% 1,500,000 50% 1,500,000: D Workers' Compensation 1,580,000 953,365 60% 1,580,000 967,909 61% 2,000,000 127% (420,000)! E Insurance Administration 547,047 491,393 90% 607,558 381,189 63% 605,841 100% 1,717 Property Damage 300,245 604,926 201% 300,248 81,517 27% 200,000 67% 100,248! F Vehicle 200,000 137,356 69% 200,000 134,642 67% 200,000 100% Unemployment 200,000 89,053 45% 200,000 - 0% 200,000 100% TOTAL REQUIREMENTS ; 6,427,292 4,982,451 78% 5,887,806 1,919,657 33% 4,705,841 80% 1,181,965: TRANSFERS Budges Actuals % Bridget Actuals °/ Projection % $ Variance Transfers Out - Vehicle (3,500) (3,500) 100% ; (3,500) (2,328) 67% (3,500) 100% Replacement TOTAL TRANSFERS (3,500) (3,500) 100% ; (3,500) (2,328) 67% ; (3,500) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 8,329,115 9,521,450 114% 7,687,180 8,944,938 116% 8,944,938 116% 1,257,758, Resources over Requirements (3,280,319) (573,012) (2,576,329) 367,505 (1,327,700) 1,248,629! Net Transfers - In (Out) (3,500) (3,500) (3,500) (2,328) (3,500) TOTAL FUND BALANCE $ 5,045,296 $ 8,944,938 177% ; $ 5,107,351 $ 9,310,115 182% ; $ 7,613,738 149% ; $2,506,387. A Unemployment collected on first $25K of employee's salary in fiscal year g Investment Income projected to come in higher than budget C Skid Car training resuming; there will be revenue from public participation D Trending lower than budget E Trending higher than budget F FY22 had abnormally high property damage; anticipating less in FY23 Q('�V1ES C0 Budget to Actuals Report Health Benefits - Fund 675 FY23 YTD February 28, 2023 (unaudited) 66.7% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $ variance Internal Premium Charges 18,767,900 19,164,548 102% 19,908,221 13,106,679 66% 19,908,221 100% COIC Premiums I 1,589,000 1,255,305 79% 1,547,778 1,179,197 76% ' 1,547,778 100% Employee Co -Pay 1,200,000 1,238,034 103% 1,282,015 828,282 65% 1,282,015 100% Retiree / COBRA Premiums 1,060,000 1,438,217 136% ° 595,000 576,435 97% 595,000 100% Prescription Rebates 128,000 396,119 309% 175,000 280,620 160% 320,000 183% 145,000- A Interest on Investments I 200,277 90,816 45% 95,686 119,669 125% 177,660 186% 81,974: B Claims Reimbursement & Other 82,000 1,487,600 999% 55,000 109,217 199% 150,000 273% 95,000! TOTAL RESOURCES 23,027,177 25,070,639 109% ; 23,658,700 16,200,097 68% 23,980,674 101% ; 321,974: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Health Benefits 25,140,847 24,583,764 98% 21,597,563 14,007,835 65% 21,597,563 100% C Deschutes On -Site Pharmacy 2,970,575 3,381,197 114% 3,779,608 1,377,571 36% 3,779,608 100% C Deschutes On -Site Clinic I 1,141,829 1,190,855 104% 1,212,497 608,754 50% 1,212,497 100% C Wellness I 171,142 138,211 81% 179,549 90,889 51% I 179,549 100% C TOTAL REQUIREMENTS 29,424,393 29,294,027 100% ; 26,769,217 16,085,049 60% 26,769,217 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 14,772,618 15,527,580 105% 11,925,656 11,304,191 95% 11,304,191 95% (621,465): Resources over Requirements (6,397,216) (4,223,389) (3,110,517) 115,048 (2,788,543) 321,974! I I I I I I Not Transfers _ In (Out', _ - - - - TOTAL FUND BALANCE $ 8,375,402 $ 11,304,191 135% ; $ 8,815,139 $ 11,419,239 130% ; ; $ 8,515,648 97% ($299,491); A Budget estimate is based on claims which are difficult to predict B Investment Income projected to come in higher than budget C Amounts are paid 1 month in arrears Oy`�V(ES COG2< Budget to Actuals Report 911 - Fund 705 and 710 FY23 YTD February 28, 2023 (unaudited) RESOURCES Property Taxes - Current Yr Telephone User Tax State Reimbursement Police RMS User Fees Contract Payments User Fee Data Network Reimbursement Property Taxes - Prior Yr Interest on Investments Property Taxes - Jefferson Co. Miscellaneous TOTAL RESOURCES 66.7% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection % $ Variance 9,803,579 9,931,743 101% 10,402,834 10,143,455 98% 10,421,062 100% 18,228, A 1,106,750 1,815,283 164% ! 1,668,000 920,835 55% 1,668,000 100% o B 60,000 123,282 205% 810,000 30,000 4% 810,000 100% 2 C 236,576 237,221 100% 237,221 - 0% 237,221 100% D 147,956 157,552 106% 153,292 33,120 22% 153,292 100% 233,576 140,986 60% 140,445 72,183 51% 140,445 100% 162,000 244,799 151% 120,874 48,281 40% 120,874 100% 115,000 92,601 81% 80,000 68,321 85% 80,000 100% 96,867 69,988 72% 67,515 148,376 220% 209,610 310% 142,095: E 38,344 37,525 98% 39,497 36,227 92% 39,497 100% 18,658 45,553 244% 25,000 20,584 82% 25,000 100% 12,019,306 12,896,533 107% ; 13,744,678 11,521,383 84% 13,905,001 101% ; 160,323: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Expenditures - - 64,754 - 0% - 0% 64,754- Personnel Services 8,005,795 7,462,327 93% 8,606,196 5,075,318 59% 7,473,717 87% 1,132,479! F Materials and Services 3,582,212 2,915,749 81% 4,088,201 2,364,084 58% 4,088,201 100% Capital Outlay 2,975,000 518,824 17% 4,950,346 838,361 17% 5,075,000 103% (124,654) TOTAL REQUIREMENTS 14,563,007 10,896,900 75% 17,709,497 8,277,763 47% 16,636,918 94% 1,072,579: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 4,804,813 4,804,813 100% 1,750,000 1,750,000 100% 1,750,000 100% Transfers Out (4,804,813) (4,804,813) 100% (1,809,900) (1,809,900) 100% (1,809,900) 100% TOTAL TRANSFERS - 0% (59,900) (59,900) 100% ; (59,900) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 11,850,783 10,709,072 90% 12,950,799 12,708,705 98% 12,708,705 98% (242,094); Resources over Requirements (2,543,701) 1,999,633 (3,964,819) 3,243,620 (2,731,917) 1,232,902, Net Transfers - In (Out) - (59,900) (59,900) (59,900) TOTAL FUND BALANCE $ 9 307,082 $ 12,708,705 137% ; $ 8,926,080 $ 15,892,424 178% ; $ 9,916,888 111% ; $990,808, A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted 8 Telephone tax payments are received quarterly C State GIS reimbursements are received quarterly D Invoices are mailed in the Spring E Investment Income projected to come in higher than budget F Projected Personnel savings based on FY23 average vacancy rate of 15% MEETING DATE: March 20, 2023 SUBJECT: Environmental Health Fees and FY 2024 Budget RECOMMENDED MOTION: None at this time. BACKGROUND AND POLICY IMPLICATIONS: Since Fiscal Year 2022, the Environmental Health Program (EH) has recommended EH fee increases be commensurate with Consumer Price Index (CPI). The CPI for January, 2023 is 6.4%. EH staff would like to update the Commissioners on statistics related to the program, as well as provide scenarios to consider during the FY 2024 budget process. This may include increasing fees beyond CPI, increasing Transient Room Tax or County General Fund subsidy to FH. or snme combination thereof. BUDGET IMPACTS: Health Services will prepare a FY 2024 Requested Budget based on feedback from the Board. ATTENDANCE: Tom Kuhn, Community Health Manager Eric Mone, Environmental Health Supervisor