Loading...
2022-457-Minutes for Meeting November 28,2022 Recorded 12/20/2022Recorded in Deschutes County CJ2022-457 Steve Dennison, County Clerk Commissioners' Journal 12/20/2022 10:52:30 AM BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 I 11 III 11 11111111111 FOR RECORDING STAMP ONLY lulu BOCC MEETING MINUTES 1:00 PM MONDAY November 28, 2022 Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Patti Adair, Anthony DeBone, and Phil Chang. Also present were Nick Lelack, County Administrator; David Doyle, County Counsel; and Brenda Fritsvold, BOCC Executive 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 Adair called the meeting to order at 1:00 p.m. PLEDGE OF ALLEGIANCE CITIZEN INPUT: Chair Adair reported the receipt of three citizen input emails: • Larry Lovelin, expressing opposition to allowing a private sewer utility to operate in Tumalo; • Timothy Cedarbloom, describing the benefits of psilocybin therapy and sharing suggestions on the proposed regulations relating to place and manner of cultivation and use; and • Karen Watt, objecting to the placement of small "body hold" animal traps on public lands in Oregon. BOCC MEETING NOVEMBER 28, 2022 PAGE 1 OF 7 CONSENT AGENDA: Before the Board was Consideration of the Consent Agenda. CHANG: Move Board approval of Consent Agenda DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 1. Consideration of Order 2022-056 for the Deschutes County Sheriff's Office to donate a van to a nonprofit corporation 2. Approval of the minutes of the November 14 2022 BOCC meeting ACTION ITEMS: 3. Presentation from SriPonya Stephanie Robinson, Administrative Analyst, introduced Jennifer Eales and Greg Mead, founders of the non-profit organization SriPonya. Eales and Mead reported that SriPonya hat received f ending from the Central Oregon Health council and the Roundhouse Foundation to support its efforts to help people recover from addictive patterns or behaviors. Eales and Mead described the organization's events and programs as well as its plans to establish a detoxification facility and offer long-term sobriety housing. They concluded that SriPonya will launch its latest initiative, a recovery collective, in December. 4. Public Hearing and Orders Considering Barg and Hellmuth annexations to River Forest Acres Special Road District The public hearing on the Barg annexation was opened at 1:22 p.m. There being no one who wished to speak, the public hearing was closed at 1:23 p.m. DEBONE: Move approval of Board Signature of Order No. 2022-060, annexing certain properties into River Forest Acres Special Road District (Barg) CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried BOCC MEETING NOVEMBER 28, 2022 PAGE 2 OF 7 The public hearing on the Hellmuth annexation was opened at 1:25 p.m. There being no one who wished to speak, the public hearing was closed at 1:25 p.m. CHANG: Move approval of Board Signature of Order No. 2022-061, annexing certain properties into River Forest Acres Special Road District (Hellmuth) DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 5. Public Hearing and Order Considering City of Bend annexation to Bend Park & Recreation District The public hearing was opened at 1:27 p.m. Henry Straud, Planner for Bend Park & Recreation District, said this property, which was inadvertently left out of a previous annexation, is now being vacated to enable its sale to a private party. The City wishes to ensure that the new owner pays taxes to the District following the salo 1V the VIJ111L1 IVIIL'VVII 15 the sale. The public hearing was closed at 1:29 p.m. DEBONE: Move approval of Board signatures of Order No. 2022-063, approving the request from the City of Bend to annex 2.4 acres northwest of NE 18th Street and south of Cooley Road into the Bend Park & Recreation District CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 6. Request to accept Oregon Health Authority grant funding and authorization to convert two limited duration FTEs to regular for the Public Health Early Intervention Services and Outreach Program Rita Bacho, Program Manager, announced that the Oregon Health Authority has awarded Deschutes County Health Services $1,900,000 for the term January 1, 2023 through June 30, 2027 to support the continuation of the County's Early Intervention BOCC MEETING NOVEMBER 28, 2022 PAGE 3 OF 7 Services and Outreach program. This program strives to ensure that those living with HIV have access to high -quality care without discrimination. Program components include STD/HIV testing and disease intervention, health literacy and education, prevention activities, and connections and access to care. CHANG: Move approval to accept funding from Oregon Health Authority for Early Intervention Services and Outreach services DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried DEBONE: Move Resolution No. 2022-075 to convert 2.0 limited duration FTEs to regular FTE positions within the Health Services Fund CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 7. Authorization to apply for PacificSource Behavioral Health Workforce ✓ • ivri wLy 61 aHM Holly Harris, Interim Deputy Director, Health Services, said PacificSource is extending one-time, non-competitive funding to a limited number of behavioral health providers and has made $147,595.40 available to Deschutes County Health Services. The funds would be used for staff training and to increase access to behavioral health services for persons from diverse cultural backgrounds, including non-English speakers. Janice Garceau, Director of Health Services, added that the work needed to ensure access to translation services continues to grow. For example, the department must translate all client documents into Spanish, offer interpretation services, and accommodate deaf and hard -of -hearing persons. DEBONE: Move approval to authorize an application for a PacificSource Behavioral Health Workforce Diversity grant as described CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried BOCC MEETING NOVEMBER 28, 2022 PAGE 4 OF 7 8. Consideration of Board Signature for Order No. 2022-068 to authorize the sale of certain County -owned property by private sale Kristie Bollinger, Property Manager, explained the proposal to sell certain properties which did not sell at auction at a price no less than 15% lower than the minimum bid identified at the public auction. The properties are located at 17075 Bakersfield Road in Bend; the corner of Silver Fox and Caribou in Bend; and 52745 Rainbow Drive in La Pine. CHANG: Move approval of Board signature of Order No. 2022-068 to authorize the sale of certain County -owned property by private sale DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 9. Contract with Youth Villages, Inc. for Intensive In -Home Behavioral Health Treatment services Shannon Brister-Raugust, Program Manager, explained the proposal to contract with Youth Villages facilitate critical response services to youth crisis. Youth with Youth i Villages to �u�..i�u��., critical response �✓�. services youth in Youth Villages offers an array of intensive in -home services to children from infancy through age 20 and their families, including mental health therapy, skills training and peer support. DEBONE: Move approval of Board Signature of Document No. 2022-813, a Contract with Youth Villages, Inc. to provide intensive in -home behavioral health treatment services CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 10. Consideration of Resolution 2022-077 transferring Contingency within the 2022-23 Deschutes County Budget Robert Tintle, Chief Finance Officer, said this resolution constitutes the necessary budget authority for the $100,000 loan from the County to the Alfalfa Fire District which was approved in October. BOCC MEETING NOVEMBER 28, 2022 PAGE 5 OF 7 CHANG: Move approval of Resolution 2022.-077 transferring contingency within the 2022-23 Deschutes County Budget DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 11. Treasury and Finance Reports for October 2022 Finance Director Robert Tintle presented the Treasury and Finance reports for October 2022, including year-to-date earnings, current portfolio balance, and budget to actual numbers for the General Fund. OTHER ITEMS: • Commissioner DeBone announced that Trinity Lutheran School will hold a mock Congressional hearing in Barnes & Sawyer on Wednesday, December 14th • Commissioner DeBone toured a renewable natural gas facility and landfill in Roosevelt, WA. 12. Consideration of support for a letter from CLHO to Governor -elect Kotek Urging investments in public health Deputy County Administrator Whitney Hale presented a letter to be sent from the Oregon Coalition of Local Health Officials (CHLO) to Governor -elect Kotek urging investments in public health and specifically supporting the Oregon Health Authority's proposal that $286 million be appropriated for a Public Health Modernization policy option package. Chair Adair noted the Board's consensus to support this communication and authorize the inclusion of Deschute County's logo . EXECUTIVE SESSIONS: At 2:39 p.m., the Board went into Executive Session under ORS 192.660 (2) (d) Labor Negotiations. The Board moved out of executive session at 3:00 p.m. to direct staff to proceed as discussed. BOCC MEETING NOVEMBER 28, 2022 PAGE 6 OF 7 At 3:01 p.m., the Board went into Executive Session under ORS 192.660 (2) (e) Real Property Negotiations. The Board moved out of executive session at 3:28 p.m. to direct staff to proceed as discussed. At 3:29 p.m., the Board went into Executive Session under ORS 192.660 (2) (e) Real Property Negotiations. The Board moved out of executive session at 3:48 p.m. to direct staff to proceed as discussed. ADJOURN: Being no further items to come before the Board, the meeting was adjourned at 3:48 p.m. DATED this Commissioners. ATTEST: day of 4re-ineA -i-s)4(01 RECORDING SECRETARY 2022 for the Deschutes County Board of PA TI ADAIR, CHAIR ANTHONY DEBONE, VICE CHAIR PHIL CHANG, COMMISSIONER BOCC MEETING NOVEMBER 4, 2022 PAGE 7 OF 7 vi"ES BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS MEETING 1:00 PM, MONDAY, NOVEMBER 28, 2022 Barnes Sawyer Rooms - Deschutes Services Bldg - 1300 NW Wall St - Bend (541) 388-6570 I www.deschutes.org AGENDA MEETING FORMAT: The Oregon legislature passed House Bill (HB) 2560, which requires that public meetings be accessible remotely, effective on January 1, 2022, with the exception of executive sessions. Public bodies must provide the public an opportunity to access and attend public meetings by phone, video, or other virtual means. Additionally, when in -person testimony, either oral or written is allowed at the meeting, then testimony must also be allowed electronically via, phone, video, email, or other electronic/virtual means. Attendance/Participation options are described above. Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at ww.deschutes.org/meetings. Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to: citizeninput@deschutes.org or by leaving a voice message at 541-385- 1734. Citizen input received by noon on Tuesday will be included in the Citizen Input meeting record for topics that are not included on the Wednesday agenda. Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for consideration or who are planning to testify in a scheduled public hearing may participate via Zoom meeting. The Zoom meeting id and password will be included in either the public hearing materials or through a meeting invite once your agenda item has been included on the agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are providing testimony during a hearing, you will be placed in the waiting room until the time of testimony, staff will announce your name and unmute your connection to be invited for testimony. Detailed instructions will be included in the public hearing materials and will be announced at the outset of the public hearing. For Public Hearings, the link to the Zoom meeting will be posted in the Public Hearing Notice as well as posted on the Deschutes County website at https://www.deschutes.org/bcc/page/public- hearing-notices. CALL TO ORDER PLEDGE OF ALLEGIANCE 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. To be timely, citizen input must be received by noon on Tuesday in order to be included in the meeting record. CONSENT AGENDA 1. Consideration of Order 2022-056 for the Deschutes County Sheriff's Office to donate a van to a nonprofit corporation 2. Approval of the minutes of the November 14 2022 BOCC meeting ACTION ITEMS 3. 1:05PM Presentation from SriPonya 4. 1:15PM Public Hearing and Orders Considering Barg and Hellmuth annexations to River Forest Acres Special Road District 5. 1:20PM Public Hearing and Order Considering City of Bend annexation to Bend Park & Recreation District 6. 1:25PM Request approval to accept Oregon Health Authority grant funding and authorization to convert two limited duration FTEs to regular for the Public Health Early Intervention Services and Outreach Program 7. 1:40PM Authorization to apply for PacficSource Behavioral Health Workforce Diversity grant 8. 1:55PM Consideration of Board Signature for Order No. 2022-068, to authorize the sale of certain County -owned property by private sale 9. 2:05PM Contract with Youth Villages, Inc. for Intensive In -Home Behavioral Health Treatment services 10. 2:20PM Consideration of Resolution 2022-077 transferring Contingency within the 2022-23 Deschutes County Budget 11. 2:25PM Treasury and Finance Reports for October 2022 November 28, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 3 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. 12. Executive Session under ORS 192.660 (2) (d) Labor Negotiations 13. Executive Session under ORS 192.660 (2) (e) Real Property Negotiations OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. ADJOURN Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need accommodations to make participation possible, please call (541) 617-4747. November 28, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 3 of 3 Angie Powers From: Larry Lovelin <larrylovelin@springwaterjewelers.com> Sent: Tuesday, November 22, 2022 4:58 PM To: citizeninput Subject: public input [Some people who received this message don't often get email from Iarrylovelin@springwaterjewelers.com. Learn why this is important at https://aka.ms/Lea rnAboutSenderldentification ] [EXTERNAL EMAIL] Hi my name is Larry. l do not want in any form a private sewage owner to have a foothold in Tumalo. Thank you for you time, Larry Angie Powers From: Timothy s. Cedarbloom <tcedarbloom@yahoo.com>. Sent: Tuesday, November 22, 2022 4:35 PM To: citizeninput Subject: TPM for measure 109 >ome people who received this message don't often get email from'tcedarbloom@yahoo.corn Learn why this is important? [EXTERNAL EMAIL] To the Deschutes county Comissioners, board members and all whom this email concerns, My name is Timothy Cedarbloom and my address is 62221 Powell Butte Hwy. Bend, Oregon 97701 Mailing address is PO Box 1162 Bend, Oregon 97709 I have been a resident of Deschutes County for over ten years and am extremely concerned about measure 109 and the TPM amendments here in our county. I did attend the Commissioners meeting on November 21, 2022, and I did hear all the testimonies. I have approximately thirty five years years of experience with psychedelic substances, from recreational use to layman therapy for ptsd, alcoholism, drug addiction and depression plus religious issues in other people. I am not a degreed psychologist nor do I have any accreditation in facilitating their use, but I found my own way and it works. I have given therapies to half a dozen people in those thirty five years with much success. I currently have been working with a Marine Corps. veteran who is a latest success story here in our area and I will ask him if he would be willing to testify or email his, well, testimony to the success that these substances have afforded him. I heard testimony from a man at the commissioners meeting say that he has veteran friends who are scared of all of this. People who are scared or nervous tend to relax after information and screening sessions take place pre therapy. I heard testimony from the woman from Terrebonne who said she's used magic mushrooms and they're scary. People are using these substances incorrectly without proper guidance and that's what makes them scared. I like to think of it like this, use of marijuana products legally is akin to a license for driving a car. It doesn't take a lot to learn how and learn all of the effects and responsibilities that come with it. Using psychedelic substances is akin to being licensed to fly an airplane. You are the pilot. It takes extensive training and licensing to know all the controls and functions and how it operates, and then even more skill to properly get it where you're trying to go in a safe manner. As far as TPM goes I'd like to start with manner of cultivation and farming. First of all it is unnecessary to license many cultivators in the county. A dozen should be more than enough. These magic mushrooms are gregarious and grow like wild fire and we will be setting ourselves up for illicit activities. Only a few cultivators are necessary because we should be having the mushrooms sent to a company with chemists hired by the county to extract the psilocybin from the mushrooms refining it to its pure concentrated form of psilocybin, which is in a crystalized form in a pill, making strength of dosage much easier to manage based on body weight, prescreening for mental health, etc.. Magic mushrooms themselves should not be used in therapeutic setting because they have impurities in them such as norpsilocin, baeocystin, norbaeocystin, and aeruginascin. The side effects from mushrooms without purification into pure psilocybin are, but not limited to, stomach discomfort, nausea, vomiting, chills, cold extremities with hot flashes in the body, accelerated heart rate, lack of coordination and muscle weakness to name a few. Purified and refined magic mushrooms into crystalized psilocybin in capsule form is what should be used in the therapy treatments here in our county. 1 On that note, it is my genuine hope that we blaze the trail for the rest of the counties and states, and North America for that matter. It is not difficult to do. The providers and therapist are helping people with the difficulties in their lives such as terminal illness, ptsd, depression, alcoholism and drug addiction to name just a few, so we need to have the best providers and therapists to achieve the best outcomes for our patients, having the best product available, and our data should be able to prove it. With a good proven track record comes great reviews and referrals across the country which will in turn boost tourism and revenue for our services. We have to help our patients who undergo our therapies and it takes quality providers and therapists. Our therapists should have no less than a bachelor's degree in psychology with extensive psychedelic experience, and some theology. As far as place goes, the things that are really important under the influence of these chemicals are the four elements plus sky. Our desert environments are capable of wonderful psychedelic experiences. I was at the commissioners meeting and l know pronghorn resort will be offering its services for therapies. They have plenty of acreage to create a setting for the therapies for any outdoor parts of these experiences as some parts of the experiences take place in a room on a couch with a blindfold on. I'm excited for them and hope they have the best reputation for the therapies. I don't have comments on times for the therapies yet. I hope this email finds you well. l want to see us trail blaze these life changing therapies and assist our fellow man with the help they need to recover from their problems. l will be attending the November thirtieth commissioners meeting and am looking forward to it. Thank you very much. Sincerely, Tim Cedarbloom Brenda Fritsvold From: Sent: To: Cc: Subject: Brenda Fritsvold Monday, November 28, 2022 11:48 AM 'Karen Watt' Angie Powers; citizeninput RE: Reporting pet dog caught in leg hold trap in Deschutes County Thank you for your input; As your email was submitted through the Citizen Input email address, it is not only shared with the Deschutes County Board of Commissioners but is also included in the meeting record of the next scheduled Board of Commissioners meeting where Citizen Input is a portion of the agenda. Brenda Fritsvold I Executive Assistant DESCHUTES COUNTY BOARD OF COMMISSIONERS (541) 388-6572 Enhancing the lives of citizens by delivering quality services in a cost-effective manner. From: Karen Watt <karen_watt@outlook.com> Sent: Monday, November 28, 2022.11:40 AM To: OSPFWD@osp.oregon.gov; odfw.info@odfw.oregon.gov; odfw:commission@odfw.oregon:gov; citizeninput <citizeninput@deschutes.org>; Sen.TimKnopp@oregonlegislature.gov; Rep:JackZika@oregonlegislature.gov Subject: Reporting pet dog caught in leg hold trap in Deschutes County Some people who received this message don't often ge [EXTERNAL EMAIL] To: Oregon State Police, OSPFWD@osp.oregon.gov Oregon Department of Fish and Wildlife, odfw.info@odfw.oregon.gov odfw.commission@odfw.oregon.gov Deschutes County Elected Commission, citizeninput@deschutes.org Senator Tim Knopp, District 27, Sen.TimKnopp@oregonlegislature.gov Representative Jack Zika, District 53, Rep.JackZika@oregonlegislature.gov Congressman Cliff Bentz (emailed via online contact form at Contact I Representative Cliff Bentz (house.gov)) U.S. Senator Ron Wyden (emailed via online contact form at Email Ron I Contact I U.S. Senator Ron Wyden of Oregon (senate.gov)) U.S. Senator Jeff Merkley (emailed via online contact format Email Jeff I Connect 1 U.S. Senator Jeff Merkley of Oregon (senate.gov)) from'karenwatt@outlook.com._Learn why this is important Dear Oregon State and Deschutes County Wildlife Representatives: On Sunday, November 20th 2022, my dog Raven was caught in a leg hold trap while hiking through the forest near our home in Three Rivers, Oregon. Although I realize that unfortunately body traps are legal on public lands, I wanted to t report this issue in order to bring awareness to trapping occurring so close to residential areas where many people recreate with their dogs, and to voice my support for a ban on body traps on our public lands. We were able to cut the trap line with bolt cutters and transport Raven to an emergency vet in Bend, the Veterinary Referral Center, where she received emergency care. The trap was removed from Raven at this location, and the vet kept the trap. We did take a picture of the tag on the trap, which I have attached for identification purposes. 1 do not wish to have contact with the owner of this trap and am not seeking retribution. I have included a link to the approximate location of the trap. The trap was baited, unmarked, and set what I would consider close to the road. We did not measure the distance from the forest road and have not returned to the area to see if there are any more traps set. https://maps.app.goo.gl/YGwPxdc1MBRPkCgx8?g st=i I would also like to formally voice my opinion that body hold traps should be illegal on public lands in Oregon. There are too many people who enjoy our National Forests and public lands, and it is extremely disheartening that these lands are. essentially unsafe for any sort of recreation. Unmarked traps cause incredible danger to people and pets, and there is clear government bias favoring a minority of trappers at the expense of the general public. Oregon's trapping laws must be reformed, at the very least, to make trapping illegal in public lands that are near publicly frequented areas and trails, and to require posting of warning signs. I certainly would not have entered this forest if I had been alerted to the presence of traps. Simply put, body -gripping traps are inherently cruel and non -selective. Traps causes injuries and trauma for people and animals caught in their grip, and I firmly support Oregon banning all recreational and commercial trapping on our public lands. Best regards, Karen Watt 17299 White Oak Place Bend, OR 97707 541-678-3857 karen watt@outlook.com BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: November 28, 2022 SUBJECT: Presentation from SriPonya BACKGROUND AND POLICY IMPLICATIONS: At its October 26th meeting, the Board of Commissioners reviewed discretionary grant applications for the second quarter of fiscal year 2023. Parousia, dba SriPonya, had submitted a discretionary grant application; during their review of applications, the Board indicated an interest in learning more about the organization and its work. SriPonya founders Jennifer Eales and Greg Mead, will attend the Board's November 28th meeting to share information about the organization. SriPonya' s mission is to empower individuals, couples, families, organizations and communities to recover from addictions and self-defeating patterns and to support long- term recovery communities by providing recovery events, a virtual recovery community, and culturally responsive and trauma -informed programs. BUDGET IMPACTS: None. ATTENDANCE: Stephanie Robinson, Administrative Analyst Jennifer Eales, founder of SriPonya Greg Mead, founder of SriPonya BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: November 28, 2022 SUBJECT: Authorization to apply for PacficSource Behavioral Health Workforce Diversity grant RECOMMENDED MOTION: Move approval to authorize the application for a PacificSource Behavioral Health Workforce Diversity grant. BACKGROUND AND POLICY IMPLICATIONS: Pacificsource is extending one-time, non-competitive funding to a limited number of behavioral health (BH) providers and has made $147,595.40 available to Deschutes County Health Services. The goal of this funding is to diversify the workforce so that PacificSource members have increased access to BH providers who are more reflective of the cultures and languages of PacificSource members. Quality incentive metrics (QIMs) for Central Oregon include a required metric related to improving language access for members. This has increased demand for language services within Health Services. In addition, PacificSource members who reside in Oregon and who are Black, Indigenous, or People of Color (BIPOC), or who speak languages other than English, engage in BH services at lower rates compared to white and English-speaking members. Increasing access to a diverse workforce which reflects member race/ethnic, cultural background and language needs is an evidence -based strategy known to reduce health disparities and is a key workforce development priority for PacificSource. At this time, the largest need is for additional Latinx and Spanish-speaking BH providers. The aim of the PacificSource BH Workforce Diversity funds are to: • Retain culturally and linguistically diverse BH providers ; • Decrease BH service utilization gaps for BIPOC and non-English speaking members; • Improve member experience in BH care for BIPOC and non-English speaking members; and • Improve diverse BH provider experience in providing services and/or working in BH settings. If approved, DCHS intends to use the funds for staff training and to increase access to BH services for our BIPOC and non-English speaking communities. The department would hire a temporary, 20 hour/week Language Access Liaison who would: provide translations and in -person interpreting, coordinate interpreting/translations with vendors, implement consistent processes to be compliant with HB requirements, and collaborate with the Language Access Coordinator to identify service area needs and solutions. To increase access to services, the department would contract for interpreter services and increase our contract with Promotoras de Salud to reduce barriers and increase engagement through culturally and linguistically -specific communication and outreach material for our Latinx and Spanish-speaking populations. Additionally, staff would receive training on working with interpreters and serving the BIPOC community. The grant term begins December 2022. Reporting requirements are as follows: a virtual check -in meeting is required in March 2023, a progress report in June 2023 and a final report in October 2023. BUDGET IMPACTS: $147,595.40 revenue. ATTENDANCE: Janice Garceau, Director, Health Services Holly Harris, Interim Deputy Director, Health Services BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: November 28, 2022 SUBJECT: Treasury and Finance Reports for October 2022 ATTENDANCE: Robert Tintle, Chief Financial Officer DATE: TO: FROM: SUBJECT: MEMORANDUM November 10, 2022 Board of County Commissioners Robert Tintle, Chief Financial Officer Treasury and Finance Report for October 2022 Following is the unaudited monthly finance report for fiscal year to date October 31, 2022. Treasury and Investments • The portfolio balance at the end of October was $295.3 million, an increase of -$30 million from September and an increase of $ 37.5 million from last year (October 2021). • Net investment income for the month is $292,816 approximately $52K more than last month and $178K more than October 2021. YTD earnings of $941,018 are $430K more than the YTD earnings last year. • All portfolio category balances are within policy limits. • The LGIP interest rate increased from 1.90% to 2.20% on 10/11. Benchmark returns for 24 month treasuries are up from the prior month by 29 basis points and 36 month treasuries are up from the prior month by 20 basis points. • Average portfolio yield is 1.60% which is higher than the prior month's average of 1.22%. • The portfolio's weighted average time to maturity is at 1.33 years compared to 1.36 in September. Portfolio Breakdown: Par Value by Investment Type Municipal Debt Corporate Notes Time Certificates U.S. Treasuries Federal Agencies LGIP First Interstate Bank Total Investments 45,770,000 58,102,000 1,245,000 44,000,000 96,125,000 15,498,384 34,526,371 $ 295,266,755 15.5% 19.7% 0.4% 14.9% 32.6% 5.2% 11.7% 100.0% Total Portfolio: By Investment Types First Interstate Bank 11.7% LGIP 52% Federal Agencies 32.6% Municipal Debt 15.5% Corporate Notes 19.7% U. S. Treasuries 14.9% Time Certificates 0.4% $120 o $100 $80 $60 $40 $20 $- $9.5 DA Davidson Partfoii0 by Broker; $23.6 $26.8 Moreton Robert W Capital Baird & Co Markets $98.2 $42.4 $45.3 Piper Great Castte Oak S ndter Pacific Securities nvestrnent Income Total Investment Income Less Fee: $5,000 per month Investment Income - Net Prior Year Comparison Oct-21 Oct-22 297,816 (5,000) 292,816 115,185 Y-T-D 961,018 (20,000) 941,018 511,038 Category Maximums: U.S. Treasuries LGIP ($52,713,000) Federal Agencies Banker's Acceptances Time Certificates Municipal Debt Corporate Debt 100% 100% 100% 25% 50% 25% 25% Maturity (Years) Max 4.041 Weighted Average 1.33 FIB/ LGIP Investments Average Yield Percentages Current Month 2.20% 1.53% 1.60% Prior Month 1.90% 1.26% 1.22% Benchmarks 24 Month Treasury LGIP Rate 36 Month Treasury 4.51% 2.20% 4.45% Ter inimum Actual 0 to 30 Days Under 1 Year Under 5 Years 10% 25% 100% 16.9% 43.5% 100.0% Other Poll+ Actual Corp Issuer Callable Credit W/A 5% 25% AA2 3.0% 18.7% AM Investtent Activity Purchases in Month $ 36,115,000 Sales/Redemptions in Month $ 9,640,000 5.50% 5.00% 4.50% 4.00 % 3.50% 3.00% 2.50% 2.00% 1.50% 1.00% 0.50% 0.00% Nov 350,000,000 300,000,000 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 24 Month Historic Investment Returns Feb May County Rate Aug 2Y ar Treasury Rate Nov Feb Three Year Portfolio Balance ti0) ti0) 0 0 0 ,1, '1. 0 Oe? <<e� QQt ' ' PJ� p Oe 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 May August GIP Rate 1> 1> '1> ti 1> '1>`titi 2titi �ti �ti ��ti <<Qo Phi �` Pao 0 Oec < eo P9 � PJeo pc Five Year Maturity Distribution Schedule Oct-22 Feb-23 Jun-23 Oct-23 Feb-24 Jun-24 Oct-24 Feb-25 Jun-25 Oct-25 Feb-26 Jun-26 Oct-26 II) U U I 0 • 0 CO 0) N N 01 N 0) 1 co 0 N (O 0 ccj 01 d' co O r 01‘.- r 0 O) O riM10 r d' co O N O N co10 CIa LO-I 0)1d' O 0)' O)10) CO O O co O N r 0,10) N O10 r,0 N dMM ' 0) '1M ( (0 V V'0 co co co:.0 M d' O rIM:W 0)'Ico;d;O: 0) co 0 M!0' 0I00 O col 00 0) N 0) Wico 0)I0) (O O)Ir .- a)110)� N 0),0)Ir 0);0) •- (V N 11 i•-- N N 04 0 0 00 c c 0 C( E 1: 0 ,0) toto 0 0: a1a-- 0 0 M 00 o CO N r (00 0 O O 0 0 ON N N N N 0 0 N N 0 0 N N 0 0 N N CV NI. N 0 0 N 0 0lCD CD 0 0 00 0 CD00 00 0 0.0 010 0 ON 0 0 0 o r 0 0 r 0 0 0 O N.O O! r 0 0 0 .- N N IN '- N,•t- M N N 0) M 0I00 O (p Q)IM M • .- M'I .- 00 00 12/15/2022 N O N 0) 0 (O N10 M (NI' M 0IN0I0 0 0 M I i 1 I0 IID 1 IO r10'�O 0.1. 0>�( VC cor. N'O r d' (Oi 0i 1"-- O COI LO l 0)I 0) co M 0;0 0) M O)0) O to co:O• co r 0- 0 O O co,0 00 O N l0)j co j O TI a)l 4 vjr (0 7I M.O•N coI0 0 �- V N CO m 0) 00 CO-: CO- N CO- V' N •O Ir': WIN 0) O 1,- co IN a)Ico0;" 0I10 cola OI(O NIO 0 0Ni� r 0);NIW 0 0)10): 0): CV 010)' VI 0 0I 0)101 O O) 0)'c-'N CO Y- 0)10 0) 0) N SIN 1 IO DI CV (DM CO 0 O) 0 0 CV 0) M O 010 CO I CO co n 0I01 (0 ro;co a) D) N10) 0"VIO) IN I O 010,0 0 0 o OIO O o O 0 o 0,0 0 010 0f0 0 01-0000 0,N 0:0 0 0 N; MIN .- •NI IN1I N. • I lLI O 04 0) 0DIO (OIN • (0 to co " N co d' rIrIM'1. a) co O 00-01r 01d' d' 0 • O; O) 011 O 0 00 '10 100 0 0010 0 0I (01Vri01 d' d' d' co 0IId'Ico OII co co • co co NI.-10 IM t- 714 cola N IN,O M O O,N• M N QQ qq+1+ Q Q Q'14 4I - N OMI M 0 DI'N 0 0 O O N N N 0)IO NI 1--I_ N 11� a) N,N O'O O N N N co 0 O .-N N `-I M,M NI 10 O N N_ Y-I10 0 NIN 0'0 NI1N O'IN- ml1N -1 (0 MI MM CO N N N N1N 010 010IN0 W 0 M 0'7 N.NN N N'1,NII N N NIN W 0 NOZ II �¢Q(n¢¢v)¢> ce U Ul,a!U U a UIw co i IZ V) I II IIH QI ' W W Q w IA O z I O Q 'COI 111' OH OI O O ,1-Ia 0m ofo U rn m ''O mll 21 ,U m., 'QI;L` toQ Z UU I( a�i m!O d OH Pm p ((0i (f0) O.I2U UU ICU'&I IQ= OU o Lwl, Ia)I a) mllo E 0 0Q o 0 E 0 a-`LHt E o L'1UId O c m• E E U 11 m m (n a 2 m 1 m 0I ' I N' c N c) ' Q -,,, 01 E''Y QIQ 0 Z W co coo 0 (0 W O 0 2 O w N N O �a)O''1. c1000",m m!�OO �,m1�°la-E �LLl 1'10 c� 1- _ 0I t+1 r 1-. 1- I WW mY01OO O>. jO Om ISO UD�o�1(n m m 1Id dviv.i)=Uvi v1o�Ioid 0-u).1_,O O W W U 0IQ'IDID M 00 u.IO Q 2 oQ• 7ljawwQrnO�z',o?���IJmawWIUOo 0 r rn rn o v _ Lpoco M co 1 O Z (olU:o o (o 00 Y oo Ui= Z v U 0iK co o NIco,- IcoO w 0) N-r 0) 0) W O N N,0 W co N M=M CO N 01MIM 0 0 010 M rlco,r 0-0-0) 0) 0 coCO N M M co 0;r 0 N M M O O O M M N N co N N M O W N (0 M M I .N-‘-..co " 0) O O 0 0 0 .-1(0 0) 0) 0 0)•0)I(co ;0) 0 OI O'r I I 1, O O) O) M•m 0 0 r•M M O) d) 0 I co O I M r I O) O) d' M M O) I II U 0 �:U U U UUIIU ❑IU;=Io a U;UIU10!U• U o i,z E Q.E Ell u.lu_ Q1i E1Q Q u..,2 �:� u.. Q 1- • ._ _.. o V' 0) o'0) r V M WlO rl (0;r-Ir N 010) 0ico r 0 (0 (0 CO co 0) 1, r N 0 00 0- (0 0 OD II 0 CO N co (0 0 co O (O' M r co co • co,o 0 0 M m M cm m co.co rn NI,- co1co rnlao coo co coIco 0 0•0 0 0 oIo 0 oIo 0 0l0l0 0 0 010 OIo 0 O'0l0 -��1�1 11 1 l-I,- 0 0,010 OI010 0100 NININ N,000 DI 10 00 co O COIN- ,r N10'IN 0 N O co O (0 03 0 0 co M co co0 N M M MIM Tr.), co N N NIN N N 0 0 0 O O O N N N''NIN N M 0,0110-M O.O N M d, IM M M N N N N NI LIN 04 co o 0 0 0, 0:- 0 0 O 0' 0 N NNN N= N N N N N N • (- N 0 M O)10 10) COO)' of 0 N0O 0'I T.:I0O N.N 0 0 r IN m 0 O 1- U,I- p I-: IH 111 U a00l'Q0Q00.0(nI co'¢a c�Uc�lloUoC.)o_ alc.)c� 10838 MUN 04 O N1 i r 1 N 1 I I 0):(O 0 0- (NO 00010 T.a) co O 01,M OIOIW...0) 0- 010O N 0) 0 0 O 0 O rlco O coI N 0 O 01,0 N 0 0 rl0•Ok0 co.r 0 0 0 r 0 010) O 'N O O r d' d' CO 0 Old' - 0)tr OI00 (O N:0)10 r 001(O 0;0:0 WI00 O 0 ri00 r,0:N cw 0 0.0) M O O•0i0) O O'N 0) 0) r 0 OIM'V' 0)10 0:0 0) d'I0;0)l0 N O; OI0)IO'010) a)IO) NIO 010-0) NI- d'.- (VI•- Y- IN:NI, IN,NIx d',� Ty- NIN`- II1I I r I O'0 O V' co1M 1 O 0)� 0). N 0 V' co 1 O c‘c co co O10 0 :N10) 01r I.-- Nl0 0 (O 0 (O (O O N (O N 01.- M I 0 CO Y- N N IN (O O) O) Cr) N.. v I0 0o.,,o 0- 0-0 rI(0 w a),v v (0 r. d ' 010o O) O 10)1 N 00: 0) r l 0 010 0 r I 0 V' V' 0) 0) N a)' O)' 0) COI O) O) r O) N'I O) 0) O) 10) M V' NIMIO N 0) O! N d N!d' a a- 0I co O (O CO O 0) M 0•0 OLIO 0 0 r __.._IO O 0 0 010 0 0 0 0 o O oIo olo,o o.o,o'1Io',o 010 oo0,00.0 0 0 01( 0) o10 0•0 0l0''0 0 O OI00 N 0 0 0O;0 00 0 0 OI N co 0 0 0 OO 0 0 C01, V M ViM.O N10IN O (00 , O M O O`O•N O MTN M M!M N r (r0 O { DJ (00 0 co O O d d 0 0)10 • 0 a) co coI N O (OI M,coi OI Ml0)N O 0)10):0)I0 O)10) W 0 N 0) 0 0 N 0 MO 0-1M (0 0 r O N c0',Oo 0)) M O M10 0 O NI0 NIO),O r (0 0 O N ':N M M M.MIM M M M MII MM N N N N.N N N N N N N O O O O'O O O O O O O N N N N',NIN N \ N M M10 M',r r n N 0 0 01. ,N,,N N N 0,OTIN 00 01010 O O 0:0 N N CVIN N N N I N N r Ol,-04 0 'IN;W W WI, W W W ▪ W m aa 01a1-' (n (n al1¢:a 0.2101K a a 010 W = d r N:O rmaur CO 'd, N:N r 0)) O)' NIM M0)IM CO (01 ccu Q: co co 0 ,;0 N '1N Q N O O 0 O O M N O O 0 0 0 V' 0 r m CO M O 0 N N10 O,M oo1 N V OIM co (o (0 N CO Q Q.Q COLO CD NN oIo 0,0 OIO 1 0001 00• 0 01010101010 Oi01001010 Oj0 0 0:010 NIO O 01010 N N NII NIN cola) 0I101cO co'1 d- 0 0 N 0 O M (0 • co • 0 • 0 0 f0I 0 111 co Q Q,Q Q <1<l<1 jQ O 1.4] 0'co- NIM M 10010 M M M M M M M..M1(O M I M 0):0):M C') 0) N N N N N N O O 00,00 N �1COI I� N 04 0 04 0 0 N N NIN N N N DUN 0 010 0 010 010 N NIN N N N N.N co M 0 0)', 0 0 N CV V 0 0 0 0 0 0 0 0 0',0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O I O 0- 0 O co OO NO O (()TIN ,- N N 11 II 0,N0.0 IN N N MIO.r N10'10 O O O' O O TITT O M• co 0 0 N N O did CO M l00 r 0 0) CD00 0 010 0 0;0 O Old O 010 O 0;,0 N N - d O 0 r N �0 Nl0O O O N M co 0 co O V' O NIIM1111 0,csi 4 0 r o 0)0) 0'10 0:0 010 0I0 01.0 N1N N 1a) O IIO 0 0 N IM T 0 N. @ ' [01� I< < IQ Q. IQ Q�IQ . O co 0 .0 0) r co (0. r 0 CO M CO 0) d' d0' V0' V0' V 7V co'I co-', MI M co co (0 co co V' 0.V . V', d' N.N N N N N N N N N N N CV CV N N 0IO O O'O 0 0 0 0 0 0 0 0 0 O 0 NIN N NN N N N N N N N N.N N N 0 0 r r (O V O N .- 0,0 NIM NIM N NN N MIM N',N 0 0)O 010 N .- ",. (V N N'. o,,,' O.� 1N N 04 04 04 N N N' N N N, N N N N N N N:N O O O O O O'O 0 0 0 ,0 0 O O N N N N N DI DI N N N N:N N N 0 r CO: (�) V' N'- 0 N M 0 N'- r N 01 N O',- N �. V N N:N N.� J JJ >.J J1 JIZ J r�r )Q,r r'1 rwr (aj 000(n<_Ill 0I00CL (n0(n Q Q Q 0 0Qi0 (n 0 Q1(n (n (nQ 0 Q I � 1 Z1 = I 0 K �N: - Lij 0) IU} LU WIW I- � n OIU Z U 0 I U - Y 10121 m12i2QIw ml0 0lmllm Im 11 m'O O: clm 0 cZ(Ut-IIm 'o O U;m z w o m O 0 O = •U J O J 06 = o I J U �, ... C O) J Q O I W N �, y ''= N E O W 0I O J N O o 0 0 O W M O = W= m-LL m A''1 m .c 2 o 2= Q m m -1 --, m OO'I1-1")OYO J OIzOOOleo W a co� 'O c 'O v 'o 'o I (n 'O O •I O O m,1 O w Q 1 OIOiw O O -0 O 00 O,m LLmw000 wm'ow W Ow W J 0Q 00 a¢ 0L0 U �, G1 Y 01O IY Q O, STY 0) (n (0 m °��Iam oa 00 II m iT� of a1 c c y) IIF oU rn U 3 m °1Q K° O �I 1 COI 12 c0I1� u .�Im E ImEOE UEJ EE E���°�Oa�`mjv° f0 O O y 0 0 O O) E V) N Q Z >Iw l m 2 qt 0 � Q Q A m mIZ: o O w 7� m T K O m o .,Y p YI IZ -00 (n N 0 0 a coo 0 �Ii-�;U W rT,W Qum m.� O o UIOZ'Z O WI O&O m m O H> Q.=Q. Q!� W m=7,. VM >Q> wUQ(o • A• li (0)')Z00.< HH0)0) HOz�0<(0�IcoN)< .>(I=I01co Q W N100 W M W Q N W Q N W 0 coM N N N!10 01,(0 O M coI0 M 0 r MIM 010 M10 co M 0 01r O M.r N 0TM"N,N 0'I1 ^" O M M N MIco 0 M M.N MIM 040) 0) a,'d d' O N NI(0 M1r V M O O M M (r0 MIO AIM M O M M O � M � -.. 1 ,MV O r M 00) O''1. Z ZIU Z U U (..).-'0 - U pTZ UYZ Z -IU U UIU UIU Z Z `-" U UI.- U1.- 7 Q';= Q Q )- 0 QIU Q w Q:= 0 Q)- Q Q CKIQ 0 O= 0 0 KIU U.0 1 I_ (0 01 (Oro M1c 01010 co•0- 0'oo10 0) (ro a);co 0 Ico,co mo 0) coIo 0- o.0,00 cola 0)0) 00.ro'coo 0 0 0 oIo 0 0 0 0 0'Io O o 0 0 0 0 0 0 0 coo O o o,,,0 0l0 O 0ll0 0 0 u) 0 co irkr li w r 31 0 ) N a U d 0 h c 00 c NI N O N I I O O N .N NI 1100N 1'1 . �' 1 11 O MN'l- IN 11 1 1 0 1 0 i 1 ( i M OIN O N' V' N N 0 r 0 0,0 0.0 0110{0 O 010)l u) V' O CO N M'O CO 0 010 00 0;0 0 r 0 ,0�ONI'V O <O 0.IN,0 0 0 0 0!C0 0,0 O !0.10 O 0)GO O '00 N O O rIM0d N O O 0I0 0 0 O r,01M 1,-.0),0)10 r'0 CO 0 0 0)10 010 0 N 0 0;0 0 0)j0GO 0 0 .0i0 0{0J V' co tO Lc), 00 O co 0 .Oit1o10?V' 01 10 co jc N = NINE .- Nv-1�' v- I I , 1 co 0 N 0 Go V' 0) 0 u) 0 0 0 0 Go M c)M r+ 010 d' 010 co 0 O10 N 0 - 01r 0 Io,co o r O rlr 0 V' co 0 OIM r1M 1 O MHO .- 0 u) V' d' 0 r 1 01I CO u) cor1 ; -10o r<o co co co 00o u) co co i a)0I 0l N 10o 1 GO GO 0i0 0 NI-N �'N�I I 0 0 0ll010:010:-0 0I0 0-10 0 010 0I01010 010 010 0 OO 0 0110 10 0 0 O,o 0 0 0 0 0 010 O10 0 0 O'O 010- 0 0 0 r10 0 0 0 0 u)I O O I O O O O 0 O O?0 O10 M O t010 0 010 01-1 NI NI N N'1 N1 N <- O N,- 1 _ .._. to 0 0101O N M'00 CO 0 N1G10. O N NIM O0 01M c0 r:0 0 O u)101V'1V o O d' M M O 11 V O II O, O V' M o O I O 1 O u) MI CO 0 LC) N O O M (0 0 0 (0NI (0 aQ aaa< 0 N 0 M (O r r V �1u) Go GO.1. t01'1 u) • (Q IN a1Ia r 0 Ir ,-NjN N N!,N N Tr 00 r 0j0 0 0 0 0 0 u)' u) Lo N u) I u)'1 u) Lo u) u) u) 0 N N 010 u) M Go 0 co 0 0 t0 0 0 NI- 11 MI 1 '.M CO GO IN1 11 iM 1.N N N'. Ni : ;N '- 0I O t4- M 0 ,-' 1 N ' 'O 4) r 1 o10 o olr u)I0 0 N V'O Olr u) O 0 Go Go N 01V"V' t010100 O 01u)1N N GO 0 0 0:0 0 r Go:N V' 0 VIu) 0 010'0 0 0 01 Go 0)IN N10 01 N'00 0; M0 ., OI GO u) 0) 010 0 0 co <Or C' M O10 0N 0IO G jr 0010 0 0 71017 7 u)IO'r IO Ml.* s{ u)M O eo;M 0,0 0 0 0 N'vO N N O 0-r N N;N,N N O 010 O!N 0 010 0 N 0 01N COCO G10 0 r!,0 0) tii0) 00001000.00 0010101010 01010 0 0000;00000 00010 0 0101010 010 Go 0'O 0 0 0I0 Lair) r010 NISI Ii 01W 0 O '!, 0110 N r to O <0,0 01° OIO O'IO 0 0 N co 0 r CO r Lo co N1 �I IN'1.�1 M �I _ II 0 N r! co u) CO N!0 u) O M u) .- O 010 0 r10 MIO 0 GO1N 0 V 01M M 0) 0I0f G1G Iu) r N <O 0 0 0 01.c co co 0!,r V 0 O 01M co u) 0 r calco O OI0 N Oi a1I '-G,OIN30 N OIGO N Go M M 4-lN 0,- d'1 M MIOIO N V' 01N O N M,0 N N 0 GO r GO <-1N N, 01r 0 r O'IN 0 0 0;0 NSI I L1 010 0 0 0 0,0 0 0 0', 0 0 00 0 00 010 0 010 0 0 0 0�010 0 010 0 0 0 oI0 0 0 010 01010 O;O 0 0 010 010 010100 0 0 of o 010 o to ;, tu) o 0 0 0! of of 0 0 0 0 0: 0 O V V O .GIOl0 -I O O '1V GO O0,tu) o O -OIN NN OIN 0 ,0,01r'. 0!N OEN N O''.r10 0101N N N 1 N� N1', 1 1 o Go I 0 O I,O'10 tO to O V 1 <0; CO 11u) u) Old O'O Old r I u) 0 0 <O 0.o NIGlG u)I Lo co t0 0 u).OIt u)!M 0 0 0 O to O1N O 0110 Q a a1Q 1Q QIQ Q N N 0101N N.N N NIN N N N 0 0 0 O O 010 0 0 0 010,0 ` NN N,N,N!1N NIN (O 0.110.11N N 04 INIM .4Id. IM1Go N N (") M MI V Lou)I(O N N N 4 NN N N N N'N N 0 N O I O O1 O 0 O I O O O O O O O N N NIN NI, NIN G,�1 NIN il•N-N M c0 M.00: 01100 NIW,000 IY` N N Oir NGN Go N Old 0 0 0 0 0 0 0 0 N __I V 1 V' 0 O O u) ,r V. N 00r (010,0 1 CO V1,0 0 <o I<ou) N Lodyr, u) co. NIIN 0 O old O O OFO O Oi00{O O 01V'10 I u) u) N N OMIO 0 V,00 N r 011 V' 0-.00rO.. u) u)ON .71010 N 01N N O NI10 0 4') M O M,,.u) la a cocco 0 0'!:0 V V' V 04104104 0 0,0 N NIN 0) 01 O N M11M r r r N O CO r- as a cv r- 0 0 01101N N tO 0 01010 1a: Go N N N N N'',N N N N N N 0.1104• 00 O 0 010 0 0 0 0 0 0'0 `IN N N'1N N N. N,N ` V.' NIN• M .- SIN . OD''I1c0 (000<O(Ol1M 0 (O1r rf� 0 0 0 0 0 0 0 o,•,-10 NIN NN N1N 01NIN1N N N N 010 0,0 0 0 01010'10 0 0 0 NIN 01N NI,N 01NININ N NIN IcOO I� �'100 0 r d' 0 ',N O I,N 0J 1,p N NI(G !1� N:N {- f _ I m 'm co Go Go v) 1 U aaaala_a� I co 0 C N N Go O N NI N N N 0 0)'<- M N N I"- 0 m Q a 0 a'10 - M (0 (0 !, co a¢IQ 0 010 co 0'',co V GO V' N 01,N 0 0 0 01N;N V N O N 1. _. O 00 O 0 0 N 0 0 0 O O r O N N!N N N 010 CO CO U CC 0_ ' 1- ' Z a1 . IYlYo NDH0 OU1N, UoJWJ�C,IWYm v) K o _1 1Ot' 0 1O O OIO1= c -OIDOWlmmCIc ccl 00 () }m m'Im e.' 'U a,0Z U- >Iw ,Z`IZ` 1-1 o 0= 2,y.F 'oU l )awiz;c"I cl c,..- ,0 `o co U' ml6 o o •" acoU212 o E(0IUc1z zWIo e'2 , 1I &U,UE o JU co)IUU UvI0 01 0'< _I°.7 UEEC-j <II 1,0mIUI coELaIE' ak- c00D a oZ 1�!IZ=o `my oa E N t0 0 w alw U0lIW2W a YUv)Ix W1l xa v) (0 (I) ° am) daa pa ujoUUIOI1u21cccH11217,12 1(0pc crn oYcZcFC0I ,�510 oI2Zmm�dY10�I rn0 I-1-IY,U U�1oljp y1)(0,01-JN0I0m1�)1O 1v o1cUIn U c'g= Jz�w �00U10Ol0v, 1, 0_ i-1i=i co. O = 01=D mI00 0-0!=0011W1)1w 400 .1 1 1 a > ▪ N:40 O�U' W ti > O X 01}:O v p01NIW >� 1. Y,K 0 u. N co 2 W -)•Y U U W Y 0W a �1U U U 0 >IU 2 0 0 0 M eolrlm_0N40 4m 1;ID Q W N Q N r1N 01t0 N N ;0 0 10 r N O M M€0 W 0 M 0 01010 010 O N 0 01G'O 0 0 u) V M co 0tN M M,M N M N 0;0 N 010 041011010,_ 0 u) 0 01i1010 N u)'. V' M 0.;0 0,0 01r NGO r 0 0 M 01010 CO GOl0MI00000r d' 000-- <10 r GO10 of colo ) M U ":U 1 U 10 BIZ UIZ 1U U IIIZ ZIZ Z Z Z1Z ,Z IZ Q 0 U K Q K = = 0 KIU = _ _ _ _ _ = U = _ w H w 1- 2 �L FH121212 212 2 E12 212 •d' OjM' 0 V'{V'1 V' u) N10 r r u)1010 0 N1� MIN u) NNr0N0 V'rO�Orr0r tn0 co co;0) co 0 0 0 co r,0 co 1 0 I rGo1r O O O 0 0 0 0 01010 OI 0 0 0 0 0 010 0 GO1,- O 0 CO G010 010 0 0 0 o 0 10842 FAC �'YIO r XI'K IOW I'Z'XIco 211V (n', v) a 0) a 211-I= m to1 w 0 o o) 0!,0 0 0 GM'- 0 010'010 .0-,10 N IW'100 011,M 1`...101,M 00 0.0 0!11- I ❑'I00-Z U 0 0 UIU = 0 0 r V010 V' N I d' 0 -, 00 100 0 C010 0010 0 010 0 40 0 CO to CO 0 0 N N t< 0 CO O 0 N N 0 Go U 00 al I- H QQa3 CO CO 0a0 <<Go CD CC UIW UI 11 Z W 1 W 40 LQL 01! v) U'' a Z o Y • 'r a CCI a of 4:- 0 Z v) cp 0v)O o`er`)a o = co v) F m W O O v) p-.0 �0u12 moo, 40a = X:;w U�0 0 u):0 .,G1N10 LLKGQw1a''1� 0 1- 1N to co 4.''- O0lu) Mr M GOGOGo N M N V0I Go 0 0 0 M N u) 0 0M rIM N V M co 0 Q co O u),tO O N<o (0 LO CO CO 0 0Ir 0 0 0 0 00 N O V O N co r N OD V N a co N1,01 N N N N N 0;0 O O O O10 NIN N N N-N1N 0 0 G14. W 10 N O' 810 0 810 N _ 1 O N O O 'N N,N 01N N 01C, 010101010 <?\l'N N NIN N N N (V O)I0 0•Q. W'I (a (,)kt ;0 a W J H Q U 0 W W 40 0 = Y Q m CC 0 Z U a E ZI ccILL. 0 t- 74 011oi z Z Z Z110 coIZIU Z Z UIz 0 = = =I0 0 U'!= a U'= = Q = Q .2!21c0 2121u..i W1 a N V 010 01 Go 0IGO O 0t-010 M 0 0 V' Go 1r GO ri0 0 0 Go 0 r1.r Go 0 0010o r 0 rir 0 01r O o 0l0 0 0 0 0 0 0 0l0 0 0 0 40 10926IFAC 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 .. 32.00 31.00'' .. " Unfilled 2.00 4.26 3.26 4.26 9.77% Clerk . Filled 9.48 " 9.48 ' 10.48 10.48" Unfilled 1.00 1.00 4.77% BOPTA Filled. 0.52" 0,52 0.52 0.52 Unfilled 0.00% DA Filled 57.40 58.40 59.20 61.20 Unfilled 3,20 2.20 1.40 0.40 2.96% Tax Filled 5.50 5.50 6.50 6.50 Unfilled 1.00 1.00 - 7.69% Veterans' " Filled 5.00. 5.00 5.00 4.00 Unfilled - 1.00 5.00% Property Mngt Filled 2.00 2.00 2.00 2.00 Unfilled 1.00 1.00 1.00 1.00 33.33% Total General Fund Filled 113.16 111.90 115.70 115.70 - - - - - - - - Unfilled 8.20 9.46 5,66 6.66 - - - - - - - - 6.16% Justice Court Filled 4.60 4.60 4.60 4.60 Unfilled - - - 0,00% Community Justice Filled 45.20 45.20 45.90 44.90 Unfilled 2.70 2.70 2.00 3.00 5.43% Sheriff Filled 218.25 232.25 230.25 230.25 Unfilled 44.75 30.75 32.75 32.75 13.40% Houseless Effort Filled - - 1.00 1.00 Unfilled 2.00 2.00 1.00 1.00 75.00% Health Srvcs Filled 355.80 357.50 368.30 371.30 Unfilled 49.55 47.85 48.25 46.25 11.67% CDD Filled 59.80 58.80 59.80 58.80 Unfilled 12.20 13.20 12.20 13.20 17.64% Road Filled 55.00 55.00 58.00 57.00 Unfilled 6.00 6.00 3.00 4.00 7.79% Adult P&P Filled 35.55 35.55 35.85 34.85 Unfilled 5.30 5.30 5.00 6.00 13.22% Solid Waste Filled 27,00 26.00 28.00 26.00 Unfilled" 3.00 4.00 2.00 4.00 10.83% Victims Assistance Filled 8.00 8.00 8.00 8.50 Unfilled - - 0.00% GIS Dedicated Filled 2.30 2.30. 2.30 2.30 Unfilled - - - - 0.00% Fair & Expo Filled 9.75 9.75 9.75 10.75 Unfilled 3.75 3.75 3.75 2.75 25.93% Natural Resource Filled 1.00 - - - Unfilled 1.00 2.00 2.00 2.00 87.50% ISF-Facilities Filled 20.75 21.75 20.75 21.75 Unfilled 4.25 3.25 4.25 3.25 15.00% ISF -Admin Filled 8.75 8.75 9,75 10,75 Unfilled 2.00 2.00 1.00 - 11.63% ISF - BOCC Filled 3.00 3.00 3.00 3.00 Unfilled - - - - 0.00% ISF-Finance Filled 10.00 8.00 10.00 9.00 Unfilled 1.00 3.00 1.00' 2.00 15.91% ISF - Legal Filled 7.00 7.00 7.00 7.00 Unfilled - - - - 0.00% ISF - HR Filled 9.00 9.00 9.00 9.00 Unfilled 1.00 1.00 1.00 1.00 10.00% ISF - IT Filled 16.70 16.70 16.70 16.70 Unfilled - - - 0.00% ISF - Risk Filled 2.25 2.25 2.25 2.25 Unfilled - - "- - 0.00% 911 Filled 52.00 51.00 49.57 50.57 Unfilled 8.00 9.00 10.43 9.43 15.36% Total: - Filled Unfilled Total 1,064.86 154.70 1,219.56 1,074.30 145.26 1,219.56 1,095.47 135.29 1,230.76 1,095.97 137.29 1,233.26 A - - - - - - - - - - - - - - - - - - - - - Unfilled 12.68% 11.91% 10.99% 11.13% 11.68% A 2.50 increase in FTE. DA+1.0, Health Services+1.0, Victims Assistance+0.50 Budget to Actuals Report General Fund Revenue YTD in the General Fund is $6.2M or 14.2% of budget. By comparison, last year revenue YTD was $6.8M and 16.7% of budget. Expenses YTD are $14.5M and 32.0% of budget. By comparison, last year expenses YTD was $13.4M and 31.0% of budget. Beginning Fund Balance is $13.8M or 106.7% of the budgeted $12.9M beginning fund balance. Final beginning fund balance will be determined after the final close of FY22. County Wide Financial Dashboard 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 - Law Lihrary 130 - Park Acquisi... 132 - Park Develo... Monthly GL Period 0 4 (Blank) All Major Funds SO OM M Srtm SO $5M SO 001 - General Fund Budget to Actuals Requirements Resources Beginning Working Capital Budget to Actuals by Category 6Actuals •Budget •Projection 4 33.3% Year Complete $14.5M 32.0% z 5452,1 880M $6.2 M 14.2% Monthly Expenditures 4 6 8 Last Year Actuals Oa. rtent Year Actuals Monthly Revenues 6 8 ® Last Year Actuals •Covent Year Actuals S4371.1 S00M 30.8% % of last year budget 10 12 16.8% % of last year budget 12 106.7% 8201,4 413 OM S0M .11 Transfers Out Personnel Materials 7< Capital 50,0<0es Services_ Outlay Projected Ending Working Capital Approved FTE 122.36 VACANT @Budget 5.26% @Projection FILLED 94.74% 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 October 31, 2022. Budget to Actuals - Countywide Summary An Departments FY23 YTD October 31, 2022 (unaudited) 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget 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 County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other Actuals Budget Actuals OA 40,504,168 40,047,506 99% 43,472,708 6,137,721 14% 901,143 1,007,843 112% ; 1,010,203 86,860 9% 12,578,435 13,029,089 104% ; 13,631,282 7,303,332 54% 19,000,000 14,281,402 75% 105,186 26,577,172 999% 550,832 494,676 90% ; 44,947,745 45,776,980 102% ; 48,727,400 48,848,440 100% ; 9,580,316 10,542,434 110% ; 22,629,649 24,768,506 109% ; 5,840,250 6,178,356 106% ; 2,471,190 1,124,832 46% ; 13,350,600 13,930,834 104% ; 1,395,724 1,779,723 128% ; 1,560,500 1,922,671 123% ; 8,544 8,012 94% ; 525,032 174,410 33% 48,790,055 6,960,539 14% 56,765,218 21,154,461 37% 11,675,519 3,443,886 29% 24,889,063 9,536,825 38% 6,134,018 3,126,900 51% 1,943,063 85,266 4% 14,503,499 5,187,652 36% 1,408,534 624,451 44% 1,849,380 2,360,021 128% 7,414 7,350 99% 517,524 584,713 113% ; 642,252 233,629 36% 7,546 6,354 84% 6,298 4,477 71% 3,146,973 4,409,440 140% ; 3,311,477 1,258,475 38% 23,027,177 25,070,639 109% ; 23,658,700 7,850,592 33% 12,019,306 12,896,533 107% ; 13,744,678 1,078,309 8% 50,071,869 34,055,652 68% 57,508,737 33,713,305 59% Projection Ok 42,650,786 98% 1,026,366 102% 13,981,003 103% 29,044,591 999% 525,510 100% 48,659,191 100% 59,830,197 105% ; 10,287,817 88% ; 24,924,977 100% ; 6,128,554 100% 1,074,060 55% ; 14,516,491 100% ; 1,413,513 100% ; 2,372,997 128% ; 19,950 269% 643,360 100% 12,400 197% ; 3,344,351 101% 23,694,394 100% ; 13,811,671 100% ; 59,326,870 103% ; TOTAL RESOURCES ; 312,836,891 300,764,634 96% 325,582,317 136,905,632 42% ; ; 357,289,051 110% ; Fiscal Year 2022 1 Fiscal Year 2023 REQUIREMENTS Budget 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 220 - Justice Court 736,142 690,802 94% 731,183 246,359 34% 731,183 100% Actuals % Budget Actuals Ok Projection % 21,298,809 19,383,248 91% 7,496,355 6,674,328 89% 4,010,388 3,826,539 95% 38, 000,000 14,187,441 37% 24,106,083 7,628,947 32% 7,928,538 2,329,774 29% 13,113,218 7,409,578 57% 23,129,361 1,661,065 7% 23,259,722 96% 7,496,826 95% 13,204,157 101% ; 23,129,361 100% u1ES Budget to Actuals - Countywide Summary All Departments FY23 YTD October 31, 2022 (unaudited) 255 - Sheriffs Office i 54,162,360 51,382,461 95% ; 59,628,533 18,770,605 31% ; 274 - Health Services 58,872,642 51,718,597 88% ; 70,247,070 20,594,940 29% 295 - CDD 9,978,889 8,963,943 90% ; 11,233,304 3,057,569 27% ; 325 - Road 15,024,128 13,771,124 92% ; 16,188,996 4,516,688 28% ; 355 - Adult P&P 7,079,915 6,392,578 90% ; 7,575,910 2,175,645 29% ; 465 - Road CIP 29,722,691 8,106,117 27% ; 28,387,166 12,562,399 44% 610 - Solid Waste 9,709,991 8,792,122 91% ; 11,754,672 2,722,262 23% ; 615 - Fair & Expo 2,504,877 2,626,480 105% ; 2,768,054 752,097 27% ; 616 -Annual County Fair 1,468,131 1,352,783 92% ; 1,852,030 1,673,069 90% ; 617 - Fair & Expo Capital 568,000 7,670 1% ; 870,000 92 0% Reserve 618 - RV Park 552,188 466,135 84% ; 594,181 124,184 21% ; 619 - RV Park Reserve 100,000 885 1% ; 100,000 4,490 4% ; 670 - Risk Management 6,427,292 4,982,451 78% ; 5,887,806 1,280,507 22% 675 - Health Benefits 29,424,393 29,294,027 100% ; 26,769,217 6,446,730 24% ; 705 - 911 14,563,007 10,896,900 75% ; 17,769,397 3,645,756 21% ; 999 - Other i 86,872,890 41,149,853 47% ; 106,795,564 12,534,824 12% ; 33.3% Year Complete 58,855,575 99% 66,267,224 94% 9,704,473 86% 15,968,699 99% 6,841,393 90% 27,419,323 97% 11,754,672 100% 2,552,897 92% 1,852,030 100% 870,000 100% ; 587,668 99% 100,000 100% 5,837,558 99% 26,769,217 100% 16,726,613 94% 106,686,217 100% TOTAL REQUIREMENTS 398,573,088 284,666,484 71% 437,430,283 110,137,580 25% 426,614,808 98% Budget to Actuals - Countywide Summary All Departments FY23 YTD October 31, 2022 (unaudited) TRANSFERS 001 - General Fund 030 - Juvenile 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 705 - 911 999 - Other 33.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals 010 Budget Actuals OA (21,952,604) (21,807,006) 6,223,387 6,223,387 (6,024,574) (5,916,413) 240,956 196,126 3,500,737 3,501,246 6,122,830 6,122,830 (270,622) (1,159,207) (11,757,547) (11,757,547) 471,072 471,071 12,193, 917 10, 672,113 (6,029,323) (6,029,323) 962,736 918,804 (75,000) (75,000) 798,901 779,502 47,958 132,042 (3,500) 15,418,726 99% (20,867,706) (6,745,372) 32% 100% ; 6,452,997 2,150,996 33% 98% (6,031,446) (2,010,468) 33% 81% 263,217 87,736 33% 100% ; 3,448,587 1,240,592 36% 100% ; 8,258,652 2,630,038 32% 428% ; (911,585) (435,929) 48% 100% ; (12,330,136) (7,440,775) 60% 100% ; 467,092 155,692 33% 88% 14,230,313 4,889,361 34% 100% ; (5,299,665) (2,644,652) 50% 95% 704,127 234,708 33% 100% ; (156,706) (52,232) 33% 98% 1,149,827 383,268 33% 47,958 100% ; (81,566) (80,524) 99% ; 132,042 100% ; 261,750 87,188 33% ; (3,500) 100% ; (3,500) (1,164) 33% ; - 0% - 17,682,916 115% ; 10,445,493 7,551,538 72% ; Projection (20,867,267) 100% 6,452,997 100% ; (6,072,784) 101% ; 263,217 100% 3,448,587 100% 7,013,388 85% (1,274,423) 140% (12,330,136) 100% 467,092 100% 14,230,313 100% (5,299,665) 100% 733,062 104% (156,706) 100% 1,162,230 101% ; (81,566) 100% 261,566 100% (3,500) 100% 12,053,595 115% • TOTAL TRANSFERS 91 0 (255) 0 - 0% Budget to Actuals - Countywide Summary A11 Departments FY23 YTD October 31, 2022 (unaudited) 33.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 ENDING FUND BALANCE Budget 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 County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other Actuals % Budget Actuals 10,723,375 596,681 8,433,816 13,847,827 129% 1,522,125 255% 9,475,532 112% 108,098 999% 55,646 0% 12,160,633 15,162, 285 125% 6,011,534 13,942,649 232% 763,172 2,168,956 284% 2,231,806 7,806,356 350% 1,971,182 3,238,905 164% 5,316,460 27,223,832 512% 583,520 3,066,662 526% 604,256 995,519 165% 17,369 385,854 999% 1,341,108 1,809,440 135% 13,294 166,536 999% 824,054 1,191,937 145% 5,045,296 8,944,938 177% 8,375,402 11,304,191 135% 9,307,082 12, 708, 705 137% 55,322,038 95,096,396 172% 11,474,637 5,611,230 634,663 1,284,662 4,000,000 7,358,818 25,024,205 57,066 15,787 7,024,650 5,340,801 6,005,519 17,189,883 1,627,134 2,119,344 2,262,898 5,385,718 2,125,200 4,345,851 12, 334,484 19,636,059 556,359 2,917,745 315,960 1,103,482 225,358 1,020,574 1,587,183 2,199,967 82,920 1,340,766 5,107,351 8,815,139 8,926,080 56,813,544 195,458 1,279,112 8,921,742 12,708,052 10,141,258 124,974,738 Projection 12,371,625 108% 1,359,117 214% 4,179,594 104% 6,023,328 999% 57,544 101% 9,162,478 130% 14,518,962 242% 1,477,877 91% 4,432,499 196% 2,993,158 141% 15,108,882 122% 559,161 101% 590,098 187% 750,115 333% 2,121,620 134% 140,662 170% 1,365,903 102% 6,448,231 126% 8,229,368 93% 9,793,763 110% 64,027,918 113% TOTAL FUND BALANCE ; 129,697,724 230,166,744 177% ; 131,316,911 258,774,485 ; 165,711,903 126% o1Es ` z� Budget to Actuals Report General Fund - Fund 001 FY23 YTD October 31, 2022 (unaudited) RESOURCES Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals 32,410,716 32,791,880 101% : 34,467,173 2,636,604 8% 460,000 337,612 7 3 % ! 301,000 144,724 48% 2,689,926 2,880,344 107% : 3,591,874 2,499,828 70% 987,411 886,514 90% : 964,246 202,604 21% 2,741,215 2,225,591 81% ; 2,298,566 479,128 21% 14,588 13,216 91% . 14,588 3,072 21% 448,201 258,776 58% : 1,183,942 90,789 8% 341,004 321,554 94% . 221,483 57,581 26% 259,107 182,018 70% l 214,836 0% 152,000 150,000 99% . 215,000 23,391 11% TOTAL RESOURCES 40,504,168 40,047,506 99% ; 43,472,708 6,137,721 14% REQUIREMENTS Projection % $ Variance 34,378,087 100% a (89,086); A 301,000 100% 3,591,874 100% B 964,246 100% 1,598,566 70% ; (700,000): C 14,588 100% 1,183,942 100% D 221,483 100% 182,000 85% (32,836)1 E 215,000 100% ; F 42,650,786 98% : (821,922): Budget Actuals % Budget Actuals % Projection % $ Variance Assessor 5,454,784 5,157,534 95% : 5,910,478 1,853,527 Clerk 2,080,739 1,735,214 83% 2,432,710 696,584 BOPTA 82,911 77,147 93% 87,177 29,819 District Attorney 9,715,707 8,677,696 89% 10,979,839 3,206,969 Medical Examiner 242,652 241,582 100% 438,702 62,984 Tax Office 932,570 886,019 95% 905,262 311,390 Veterans 795,189 762,328 96% 813,100 258,582 Property Management 380,061 360,274 95% 508,359 121,499 Non -Departmental 1,614,196 1,485,453 92% ; 2,030,456 1,087,594 TOTAL REQUIREMENTS ; 21,298,809 19,383,248 91% : 24,106,083 7,628,947 TRANSFERS 31% 29% 34% 29% 14% 34% 32% 24% 54% 32% I1 ii I II Budget Actuals % Budget Actuals OA 5,521,101 93% : 389, 377' G 2,393,305 98% ; 39,405; H 87,177 100% 10,636,967 97% 342,872; I 438,702 100% 892,184 99% 13,078: H 780,264 96% 32,836 479,566 94% ; 28,793; H 2,030,456 100% 23,259,722 96% ; 846,361: Projection % $ Variance Transfers In 260,000 260,000 100% : 260,000 86,812 33% : : 260,439 100% : 439: J Transfers Out (22,212,604) (22,067,006) 99% (21,127,706) (6,832,184) 32% : (21,127,706) 100% TOTAL TRANSFERS ; (21,952,604) (21,807,006) 99% ; (20,867,706) (6,745,372) 32% ; ; (20,867,267) 100% ; 439: FUND BALANCE Budget Actuals Budget Actuals OA 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: K Resources over Requirements 19,205,359 20,664,258 19,366,625 (1,491,226) ; ; 19,391,064 24,439 Net Transfers - In (Out) ; (21,952,604) (21,807,006) (20,867,706) (6,745,372) ; ; (20,867,267) 439; TOTAL FUND BALANCE $ 10,723,375 $ 13,847,828 129% ; $ 11,474,637 $ 5,611,230 49% ; ; $ 12,371,625 108% ; $896,988: 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 g 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 Repayment to General Fund from Finance Reserves for ERP Implementation K Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Juvenile - Fund 030 FY23 YTD October 31, 2022 (unaudited) RESOURCES 33.3% Year Complete Fiscal Year 2022 I Fiscal Year 2023 I Budget Actuals 0/0 Budget Actuals Ok OYA Basic & Diversion 432,044 500,765 116% : 525,049 - 0% ODE Juvenile Crime Prev 100,517 117,184 117% : 123,000 - 0% Gen Fund -Crime Prevention 89,500 89,500 100% : 89,500 - 0% Leases 88,000 89,154 101% 86,000 30,076 35% Inmate/Prisoner Housing 80,000 92,400 116% 55,000 32,250 59% DOC Unif Crime Fee/HB2712 49,339 50,462 102% 49,339 0% Miscellaneous 7,500 29,113 388% 42,500 9,863 23% OJD Court Fac/Sec SB 1065 20,000 10,291 51% 15,000 3,670 24% Food Subsidy 12,000 11,380 95% 10,000 2,720 27% Contract Payments 8,000 9,947 124% 8,000 1,547 19% Interest on Investments 14,243 7,647 54% 6,815 6,735 99% TOTAL RESOURCES 901,143 1,007,843 112% ; 1,010,203 86,860 9% REQUIREMENTS Projection % $ Variance • 525,049 100% 123,000 100% 89,500 100% 90,228 105% 55,000 100% 49,339 100% 42,500 100% 15,000 100% 10,000 100% o 8,000 100% 18,750 275% , 1,026,366 102% 4,228: A 11,935; B 16,163: Budget Actuals 0/0 Budget Actuals Projection % $ Variance Personnel Services 6,082,895 5,411,118 89% : 6,332,160 1,901,347 30% , : 5,912,823 93% : 419,337; C Materials and Services , 1,363,409 1,249,983 92% ; 1,527,992 420,827 28% : : 1,515,617 99% 12,375 Capital Outlay 50,051 13,226 26% 68,386 7,600 11% : ; 68,386 100% TOTAL REQUIREMENTS : 7,496,355 6,674,328 89% : 7,928,538 2,329,774 29% : : 7,496,826 95% : 431,712: TRANSFERS Transfers In- General Funds Transfers Out-Veh Reserve TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Budget Actuals % Budget Actuals OA Projection % $ Variance 6,304,397 6,304,397 100% : 6,529,064 2,176,348 33% : : 6,529,064 100% (81,010) (81,010) 100% ; (76,067) (25,352) 33% a (76,067) 100% 6,223,387 6,223,387 100% ; 6,452,997 2,150,996 33% ; , 6,452,997 100% Budget Actuals OA Budget Actuals % Projection % $ Variance 968,506 965,223 100% : 1,100,001 1,376,580 125% : : 1,376,580 125% : 276,579: D (6,595,212) (5,666,485) (6,918,335) (2,242,914) . . (6,470,460) 447,875; 6,223,387 6,223,387 6,452,997 2,150,996 ' , 6,452,997 , 1 , I $ 596,681 $ 1,522,125 255% ; $ 634,663 $ 1,284,662 202% ; ; $ 1,359,117 214% ; $724,454: A New lease payment for JBarJ g Investment Income projected to come in higher than budget c Projected Personnel savings based on FY22/FY23 average vacancy rate of 6.3% D Final Beginning Fund Balance will be determined after the final close of FY22 TRT - Fund 160/170 FY23 YTD October 31, 2022 (unaudited) Budget to Actuals Report RESOURCES 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals OA Room Taxes 12,519,987 12,977,205 104% : 13,580,874 Interest on Investments 58,448 51,884 89% 50,408 TOTAL RESOURCES 12,578,435 13,029,089 104% 13,631,282 REQUIREMENTS Projection % $ Variance 7,277,729 54% 25,603 51% 7,303,332 54% Budget Actuals Budget Actuals Grants & Contributions COVA Interfund Charges Administrative Software TOTAL REQUIREMENTS TRANSFERS Transfer Out - RV Park Transfer Out - Annual Fair Transfer Out - Justice Court Transfer Out - Health Transfer Out - F&E Reserve Transfer Out - F&E Transfer Out - Sheriff TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 3,660,659 239,526 15,203 95,000 4,010,388 5,600,000 3,512,891 96% 3,675,886 239,526 100% 3,574,573 9,365 62% 1 215,508 64,758 68% 47,251 3,826,539 95% ; 13,113,218 4,600,000 82% 1,538,333 42% 1,191,524 33% 60,971 28% 18,750 40% 7,409,578 13,911,563 102% 69,440 138% 13,981,003 103% 330,689: A 19,032; B 349,721: Projection % $ Variance 57% , 5,600,000 100% 3,766,825 102% 3,574,573 100% 215,508 100% 47,251 100% 13,204,157 101% C (90,939): D E (90,939): Budget Actuals % Budget Actuals (20,000) (75,000) (240,956) (444,417) (498,901) (1,093,513) (3,651,787) (6,024,574) (20,000) (75,000) (196,126) (444,417) (479,502) (1,049,581) (3,651,787) (5,916,413) 100% : (20,000) 100% (75,000) 81% (263,217) 100% (418,417) 96% (501,683) 96% (1,101,342) 100% (3,651,787) 98% ; (6,031,446) (6,664) (25,000) (87,736) (139,472) (167,224) (367,112) (1,217,260) (2,010,468) 33% 33% 33% 33% 33% 33% 33% 33% Projection % $ Variance (20,000) 100% ; (75,000) 100% (263,217) 100% (418,417) 100% (514,086) 102% (1,130,277) 103% (3,651,787) 100% (6,072,784) 101% (12,403)1 F (28,935); G (41,338): Budget Actuals Budget Actuals OA 5,890,343 8,568,047 (6,024,574) 6,189,395 105% 9,202,550 (5,916,413) 9,513,382 518,064 (6,031,446) 9,475,532 100% (106,246) (2,010,468) s $ 8,433,816 $ 9,475,532 112% ; $ 4,000,000 Projection % $ Variance 9,475,532 100% 776,846 (6,072,784) i (37,850): H 258,782 (41,338) $ 7,358,818 184% ; $ 4,179,594 104% ; $179,594: A Room Tax collections up 7.2% over last year versus 5% budget assumption g Investment Income projected to come in higher than budget c Includes $4M payment to Sunriver Service District 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 higher based on increased Room Taxes H Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report ARPA — Fund 200 FY23 YTD October 31, 2022 (unaudited) RESOURCES Interest on Investments Local Assistance & Tribal Consistency State & Local Coronavirus Fiscal Recovery Funds TOTAL RESOURCES REQUIREMENTS Services to Disproportionately Impacted Communities Administrative Infrastructure Negative Economic Impacts Public Health TOTAL REQUIREMENTS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) A B C D E F G H TOTAL FUND BALANCE 33.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals Budget Actuals OA 93,961 19, 000, 000 14,187,441 75% 105,186 86,323 82% 2,311,073 - 24,179,776 19,000,000 14,281,402 75% 105,186 26,577,172 999% Budget Actuals Budget Actuals 20,650,098 5,242,251 25% 5,281,005 143,079 3% 2,050,000 527,275 26% 6,285,840 5,488,685 87% 3,733,057 2,786,152 75% 38,000,000 14,187,441 37% 15,394,824 748,757 5% 4,317,328 73,312 2% 1,634,710 107,546 7% 899,577 32,141 4% 882,922 699,309 79% 23,129,361 1,661,065 7% Budget Actuals OA Budget Actuals OA 19,000,000 14,137 0% (19,000,000) 93,961 23,024,175 108,098 0% (23,024,175) 24,916,107 $ 108,098 999% Projection % $ Variance 242,670 231% 4,622,145 24,179,776 137,484: A 4,622,145 B 24,179,776 29,044,591 999% 28,939,405: Projection % $ Variance 15,394,824 100% 4,317,328 100% - E 1 1,634,710 100% 1 F 899,577 100% I G 882,922 100% 1 -! H 23,129,361 100% : , Projection % $ Variance 108,098 0% 5,915,230 (22,916,077) 28,939,405 $ 25,024,205 999% ; ; $ 6,023,328 999% ; $6,023,328: Investment Income projected to come in higher than budget Local Assistance & Tribal Consistency funding will be appropriated in FY24 The revenue received in FY22, but unspent at 06.30.22, was recorded as Deferred Revenue and recognized in FY23 Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects Administration holds the balance of the ARPA funds, as well as an approved Management Analyst for ARPA reporting and administration Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment 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 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 Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Justice Court - Fund 220 FY23 YTD October 31, 2022 (unaudited) RESOURCES Court Fines & Fees Interest on Investments Miscellaneous 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 550,000 95 737 494,265 90% 45 48% 365 50% 525,000 32 Projection $ Variance 174,263 33% li 147 459% I 525,000 100% 510 999% 478; A TOTAL RESOURCES 550,832 494,676 90% ; 525,032 174,410 33% ; , 525,510 100% ; 478; REQUIREMENTS Budget Actuals Budget Actuals % Projection % $ Variance Personnel Services 577,209 541,792 94% : 569,648 191,212 34% : 569,648 100% Materials and Services 158,933 149,011 94% 1 161,535 55,146 34% ; 1 161,535 100% o 1 I 1 TOTAL REQUIREMENTS 736,142 690,802 94% ; 731,183 246,359 34% 731,183 100% TRANSFERS Transfers In - TRT TOTAL TRANSFERS Resources over Requirements Net Transfers - In (Out) TOTAL Budget Actuals OA Budget Actuals Projection % $ Variance 240,956 196,126 81% 263,217 87,736 33% 263,217 100% 1 1 1 1 240,956 196,126 81% 263,217 87,736 33% 263,217 100% (185,310) (196,126) (206,151) (71,949) (205,673) 478 240,956 196,126 263,217 87,736 263,217 I 1 1 I $ 55,646 - 0% $ 57,066 $ 15,787 28% $ 57,544 101% ; $478; A Investment Income projected to come in higher than budget g One time yearly software maintenance fee paid in July for entire fiscal year B Budget to Actuals Report Sheriffs Office - Fund 255 FY23 YTD October 31, 2022 (unaudited) RESOURCES 33.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals Budget Actuals Projection % $ Variance LED #1 Property Tax Current 28,448,529 28,828,746 101% 30,282,049 2,670,849 9% : : 30,239,651 100% (42,398): A LED #2 Property Tax Current 11,813,562 11,962,302 101% 13,400,541 1,172,784 9% ; ; 13,313,046 99% 1 (87,495); B Sheriff's Office Revenues 3,993,964 4,407,029 110% 4,520,630 2,912,980 64% 4,530,374 100% 9,744 C LED #1 Property Tax Prior 330,000 288,862 88% 330,000 124,277 38% 330,000 100% LED #2 Property Tax Prior 145,000 118,145 81% 145,000 51,228 35% ; 145,000 100% LED #1 Interest 147,416 96,152 65% 89,119 29,706 33% : 98,170 110% ; 9,051' C LED #2 Interest 69,274 24,356 35% 22,716 (1,285) -6% : 2,950 13% I (19,766); D 1 � 1 LED #2 Foreclosed Properties 15,070 -' 1 1 1 1 1 1 LED #1 Foreclosed Properties 36,317 ' ' -' 1 i 1 1 8 1 TOTAL RESOURCES 44,947,745 45,776,980 102% ; 48,790,055 6,960,539 14% ; , 48,659,191 100% ; (130,864): REQUIREMENTS Digital Forensics Concealed Handgun Licenses Rickard Ranch Sheriff's 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 TRANSFERS Budget Actuals Budget Actuals 0/0 4,002,499 4,208,992 105% 1,154,204 1,112,473 96% 3,576,342 3,738,777 105% 3,029,130 3,013,632 99% 14,015,461 13,440,565 96% 1,025,023 735,218 72% 21,033,697 18,807,184 89% 444,617 431,758 97% 789,912 543,303 69% 1,775,588 2,053,196 116% 1,626,207 1,786,439 110% 1,389,684 1,510,926 109% 299,998 - 0% 808,610 238,513 29% 335,044 76,836 23% 264,871 82,350 31% 5,863,885 1,667,754 28% 1,168,300 400,388 34% 4,005,888 1,145,267 29% 3,383,825 1,373,044 41% 14,640,315 5,030,596 34% 944,493 230,883 24% 22,182,320 6,573,307 30% 424,769 173,173 41% 829,997 181,852 22% 2,047,792 712,105 35% 1,907,588 568,273 30% 820,836 316,266 39% - 0% 54,162,360 51,382,461 95% 59,628,533 18,770,605 31% Projection % $ Variance 625,202 77% : 183,408: 176,605 53% ; 158,439 264,871 100% 4,989,543 85% 874,342 1,188,864 102% (20,564)! 3,949,728 99% ' 56,160. 4,182,537 124% ! (798,712)! 14,905,448 102% ' (265,133) 729,720 77% 214,773 21,108,399 95% 1,073,921 526,856 124% ' (102,087 )' 605,106 73% ' 224,892 2,369,495 116% (321,703)1 2,118,448 111% (210,860); 1,114,753 136% 1 (293,917); - 100% . -' 58,855,575 99% 772,958; Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,651,787 3,651,787 100% : 3,651,787 1,217,260 33% : : 3,651,787 100% Transfer In - General Fund 121,950 121,950 100% ' 70,000 23,332 33% ; ' 70,000 100% Transfers Out - Debt Service (273,000) (272,491) 100% i (273,200) - 0% ! ; (273,200) 100% 7 I / TOTAL TRANSFERS 3,500,737 3,501,246 100% ; 3,448,587 1,240,592 36% ; , 3,448,587 100% ; FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) A B c D E TOTAL FUND BALANCE Budget Actuals 0/0 Budget Actuals 0/0 Projection % $ Variance 17,874,511 17,266,520 97% : 14,414,541 15,910,275 110% : : 15,910,275 110% : 1,495,734: E (9,214,615) (5,605,481) (10,838,478) (11,810,066) (10,196,384) 642,094 3,500,737 3,501,246 3,448,587 1,240,592 ' ' 3,448,587 ' 1 1 1 1 ; $ 12,160,633 $ 15,162,285 125% ; $ 7,024,650 $ 5,340,801 76% ; : $ 9,162,478 130% : $2,137,828; Note: Vacant positions are driving projected department savings, with other fluctuations causing projected budget overages Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 4.79% over FY21-22 vs. 5.45% budgeted Investment Income projected to come in higher than budget Investment Income projected to come in lower than budget Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Health Services - Fund 274 FY23 YTD October 31, 2022 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous OHP Fee for Service Local Grants Federal 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 REQUIREMENTS Administration Allocation Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers In- General Fund Transfers In- OHP Mental Health Transfers In - TRT Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 17,641,302 8,947,837 4,129,465 3,627,151 1,936,838 4,303,483 1,086,019 884,036 843,050 468,415 1,014,100 172,200 280,000 157,000 173,030 127,000 152,634 156,549 2,627,291 16,634,837 94% 11,776,144 132% 3,518,729 85% 4,032,343 111% 3,350,227 173% 4,090,251 95% 1,213,172 112% 866,362 98% 777,348 92% 538,392 115% 750,524 74% 194,470 113% 342,960 122% 199,100 127% 178,331 103% 127,000 100% 118,228 101,438 65% 38,587 1% 77% 21,828,364 12,882,624 8,901,719 3,232,620 2,252,031 2,215,634 1,238,499 1,021,722 807,530 615,644 430,863 337,614 300,000 177,574 173,030 127,000 125,000 97,750 10,933,881 50% 4,367,325 34% 1,220,928 14% 950,330 29% 1,411,446 63% 728,042 33% 87,254 7% 265,564 26% 390,146 48% 206,939 34% 214,938 50% 74,662 22% 86,169 29% 19,068 63,178 37% 0% 59,755 48% 74,834 11% 77% 48,727,400 48,848,440 100% 56,765,218 21,154,461 37% Budget Actuals Budget Actuals 43,994,358 14,721,284 157,000 - 999% I 39,393,426 90% 12,243,043 83% 82,128 52% 50,709,720 19,372,707 164,643 16,740,507 3,831,681 22,752 33°/u 20% 14% Projection % $ Variance 23,173,697 12,035,059 8,699,743 4,842,482 2,417,300 2,738,408 1,238,623 1,032,153 1,113,507 609,160 644,815 220,490 315,713 177,574 63,178 127,000 179,265 202,030 106% = 1,345,333: 1 I 93% a (847,565); 98% ; (201,976); 150% ; 1,609,862. 107% ! I 165,269! 124% ! 522,774; ! I 100% 124; 101% = 10,431 138% 1 305,977 99% ; (6,484); 150% 213,952. 65% (117,124) 105% 15,713 100% ! 1 37% a (109,852); 100% - i 143% I 1 54,265. 207% ! 104,280! 59,830,197 105% ; 3,064,979: Projection % $ Variance 1 1 II 58,872,642 51,718,597 88% ; 70,247,070 20,594,940 29% Budget Actuals Budget Actuals 5,909,168 444,417 (230,755) 6,122,830 5,909,168 100% 444,417 100% (230,755) 100% 6,122,830 100% 46,121,930 19,876,267 269,027 66,267,224 4,587,7901 (503,560) (104,384); a 3,979,846: Projection % $ Variance 6,608,245 2,202,712 33% 6,608,245 100% 1,473,586 368,382 25% 1 1 510,322 35% ; (963,264)11 418,417 139,472 33% 1 1 418,417 100% (241,596) (80,528) 33% : : (523,596) 217% (282,000) a i a i 8,258,652 2,630,038 32% : : 7,013,388 85% : (1,245,264): Budget Actuals Budget Actuals 10,033,946 (10,145,242) 6,122,830 10,689,975 107% 11 11,228,719 (2,870,157) i (13,481,852) 6,122,830 ; 8,258,652 Projection % $ Variance 14,000,324 125% 13,942,601 124% : 2,713,882: 559,520 ; ; (6,437,027) ; 7,044,825; 2,630,038 7,013,388 (1,245,264) I I I 1 $ 6,011,534 $ 13,942,649 232% ; $ 6,005,519 $ 17,189,883 286% ; ; $ 14,518,962 242% ; $8,513,443: Budget to Actuals Report Health Services - Admin - Fund 274 FY23 YTD October 31, 2022 (unaudited) RESOURCES State Grant OHP Capitation Interest on Investments Federal Grants Other CCBHC Grant Patient Fees 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals % 769,319 156,549 1,438,843 9,200 486,804 493,270 64% 436,443 101,438 65% 1,183,981 82% 12,146 132% 6,938 1% 1,124 379,180 367,074 97,750 54,405 12,900 241,371 64% 133,925 36% 74,834 40,977 5,986 46% 77% 75% TOTAL RESOURCES 2,860,715 2,235,340 78% 911,309 497,092 55% Projection % $ Variance 502,275 132% 367,074 100% 202,030 207% 683,977 999% 12,900 100% ; 123,095: 104,280. 629,572! A 1,768,256 194% 856,947: REQUIREMENTS Budget Personnel Services Materials and Services Administration Allocation Actuals % Budget Actuals OA 6,904,224 6,580,649 (10,188,902) TOTAL REQUIREMENTS ; 3,295,971 5,832,219 84% 6,134,705 93% (10,188,901) 100% 1,778,023 54% 6,513,820 6,652,163 (11,192,921) 1,973,061 1,940,398 30% 2,197,677 33% - 0% 1 4,138,075 210% Projection % $ Variance 6,026,626 93% : 487,194: B 7,050,095 106% (397,932); C ; (11,192,921) 100% 9 9 1,883,800 95% ; 89,262: TRANSFERS Budget Transfers In- OHP Mental Health Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Actuals % Budget Actuals % (219,794) (219,794) (219,794) 100% (219,794) 100% 80,771 (230,635) (149,864) Projection % $ Variance 20,190 25% (76,876) 33% (56,686) 38% dgat Activajc - 0% (230,635) 100% (230,635) 154% (80,771): D (80,771): Budget Actuals % Projection °/ $ Variance 3,552,000 (435,256) (219,794) 3,769,942 106% 457,318 (219,794) 3,884,332 4,007,465 103% (1,061,752) (3,640,983) (149,864) (56,686) $ 2,896,950 $ 4,007,465 138% 4,007,465 103% (115,544) (230,635) 123,133: E 946,209 (80,771); $ 2,672,716 $ 309,797 12% ; ; $ 3,661,287 137% ; $988,571: A Projection includes increase in FEMA expenditures for vaccine clinics and outreach, which is going to the Board on November 7th g Personnel projections based on year to date vacancy savings and assume 3% moving forward c Expenditures over budget related to expenses supporting COVID-19 vaccine distribution. D Transfers In from OHP Mental Health Reserves will occur at end of year. No funds are currently projected to be transferred to Admin Services E The stated amount is an estimate. Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Health Services - Behavioral Health - Fund 274 FY23 YTD October 31, 2022 (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 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 11,907,014 12,160,202 102% : 15,718,843 8,039,655 51% 8,947,837 11,339,701 127% : 12,515,550 4,233,400 34% 1,934,643 1,712,171 89% ! 8,027,373 1,164, 368 15% 3,627,151 4,009,351 111% : 3,214,360 938,671 29% 2,725,623 2,781,433 102% 2,017,169 651,892 32% 1,093,055 1,378,335 126% 1,475,139 719,454 49% 682,180 668,038 98% 719,670 242,740 34% 372,115 431,526 116% 519,344 157,500 30% 1,014,100 750,524 74% 430,863 214,938 50% 172,200 194,470 113% 337,614 74,662 22% 157,000 199,100 127% 177,574 19,068 11% 173,030 178,331 103% 173,030 63,178 37% 127,000 127,000 100% 127,000 - 0% 2,140,487 31,649 1% . - Projection % $ Variance 11 16,835,345 107% :1,116,502: A 11,667,985 93% a (847,565); B 7,897,260 98% ; (130,113) 4,808,679 150% 0 1,594,319; B 1,908,855 95% a (108,314) 1,537,053 104% ; 61,914. 723,308 101% ! 3,638: 464,408 89% o (54,936) 644,815 150% ; 213,952. 220,490 65% (117,124) 177,574 100% 63,178 37% o (109,852); C I 127,000 100% ; 1 TOTAL RESOURCES 35,073,435 35,961,830 103% ; 45,453,529 16,519,525 36% ; , 47,075,950 104% : 1,622,421: REQUIREMENTS Administration Allocation Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Budget Actuals 0/0 Budget Actuals % Projection % $ Variance 7,523,855 7,523,855 100% : 8,265,132 - 0% : : 8,265,132 100% a 26,606,065 24,513,386 92% . 32,583,031 11,508,325 35% ! ! 29,751,653 91% ° 2,831,378: D 4,882,963 3,690,305 76% 10,344,612 1,152,527 11% : ; 10,307,615 100% 36,996; E 80,000 54,752 68% 153,443 22,752 15% 195,827 128% (42,384) 9 1 1 a 1 39,092,883 35,782,298 92% : 51,346,218 12,683,604 25% : : 48,520,227 94% : 2,825,991: Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 2,278,087 2,278,087 100% : 2,231,439 743,796 33% : a 2,231,439 100% Transfers In- OHP Mental Health . - I 1,392,815 348,192 25% . . 510,322 37% . (882,493)' F Transfers Out I (10,961) (10,961) 100% : (10,961) (3,652) 33% :(152,961) 999% :(142,000)i G i a l a TOTAL TRANSFERS 2,267,126 2,267,126 100% : 3,613,293 1,088,336 30% : : 2,588,800 72% : (1,024,493); FUND BALANCE Budget Actuals Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,612,014 3,870,664 107% : 4,788,795 6,372,638 133% : 6,318,489 132% : 1,529,694: H Resources over Requirements (4,019,448) 179,532 (5,892,689) 3,835,920 (1,444,277) 4,448,412 Net Transfers - In (Out) 2,267,126 2,267,126 3,613,293 1,088,336 2,588,800 (1,024,493) I 1 1 1 I I TOTAL FUND BALANCE $ 1,859,692 $ 6,317,322 340% ; $ 2,509,399 $ 11,296,894 450% ; ; $ 7,463,012 297% ; $4,953,613: A Increase of $715K related to new funds for Aid & Assist ($431 K), a cost of living adjustment ($358K), and carryforward revenue from FY22 ($455k) g A new System of Care wraparound payment was budgeted as part of OHP Capitation, but is coming in as OHP Fee for Service. c Mediation Program will no longer be managed within Health Services, so funds are transferred out of Health Services D Personnel projections based on year to date vacancy savings and assume 10% moving forward. E Increase in expenditures related to temporary staff being used instead of oncall staff F 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. G Transfers Out are increased to cover the additional construction costs proportional to Health Services' use of the 244 and 236 Kingwood buildings in North County H The stated amount is an estimate. Final Beginning Fund Balance will be determined after the final close of FY22. VIES ▪ Health Services - Public Health - Fund 274 FY23 YTD October 31, 2022 (unaudited) Budget to Actuals Report RESOURCES State Grant Environmental Health Fees State Miscellaneous State - Medicaid/Medicare Local Grants Vital Records Other Federal Grants State Shared- Family Planning Patient Fees OHP Fee for Service 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 4,964,969 3,981,365 80% 1,086,019 1,213,172 112% 2,194,822 1,806,557 82% 843,050 777,348 92% 843,783 1,971,892 234% 280,000 342,960 122% 192,656 186,177 97% 139,017 124,837 90% 152,634 118,228 96,300 105,742 110% 22,993 77% 5,730,341 1,238,499 874,346 807,530 776,892 300,000 289,152 144,060 125,000 96,300 18,260 2,652,855 87,254 56,561 390,146 691,992 86,169 16,839 35,174 59,755 49,439 11,660 46% 7% 6% 48% 89% 29% 6% 24% 48% 51% 64% TOTAL RESOURCES 10,793,250 10,651,270 99% ; 10,400,380 4,137,844 40% REQUIREMENTS Budget Actuals Budget Actuals Projection % $ Variance 5,836,077 1,238,623 802,483 1,113,507 880,247 315,713 295,945 145,576 179,265 144,752 33,803 10,985,991 102% 100% 92% 138% 113% 105% 102% 101% 143% 150% 185% 106% ; 105,736: A 124 (71,863); B 305,977; D 1 103,355; C 15,713 6,793 1,516; 54,265 1 48,452; 15,543 a 585,611: • Projection % $ Variance Administration Allocation 2,665,047 2,665,046 100% : 2,927,789 Personnel Services 1 10,484,069 9,047,822 86% : 11,612,869 Materials and Services I 3,257,672 2,418,033 74% 1 2,375,933 Capital Outlay ' 77,000 27,376 36% ; 11,200 TOTAL REQUIREMENTS ; 16,483,788 14,158,277 86% ; 16,927,791 TRANSFERS Transfers In- General Fund Transfers In - TRT Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 3,291,784 481,477 0% 28,y01 2,927,789 100% 10,343,651 89% 2,518,557 106% 73,200 654% 5 1,269,218; E (142,624) (62,000); 3,773,261 22% ; , 15,863,197 94% ; 1,064,594: Budget Actuals Budget Actuals 3,631,081 444,417 3,631,081 100% : 4,376,806 444,417 100% ! 418,417 Projection % $ Variance 1,458,916 33% 1 � 139,472 33% I 1 4,075,498 4,075,498 100% ; 4,795,223 4,376,806 100% 418,417 100% e (140,000) 999% (140,000): F 1,598,388 33% ; , 4,655,223 97% ; (140,000); Budget Actuals Budget Actuals • Projection % $ Variance 2,869,932 (5,690,538) 4,075,498 3,049,370 106% (3,507,006) 4,075,498 2,555,592 (6,527,411) 4,795,223 3,620,221 142% 1 1 364,583 ; 1,598,388 1 1 $ 1,254,892 $ 3,617,861 288% ; $ 823,404 3,616,647 142% (4,877,206) 4,655,223 1,061,055: G 1,650,205 (140,000); 1 $ 5,583,192 678% ; ; $ 3,394,664 412% ; $2,571,260: A Carryforward of unbudgeted funds are related to vacancies in COVID Team and Public Health Modernization. B Decrease of $71 K primarily related to reclassifying $60K of funding from Jefferson County from category of State Misc to Local Grants c Carryforward from FY22 of appx. $40K for Living Well and Diabetes Prevention Programs, as well as reclassifying $60K from Jefferson County for disease investigation D Medicaid revenue trending more than budgeted for the Family Support Services - Nurse Home Visiting Programs E Personnel projections based on year to date vacancy savings and assume 6% moving forward. F Transfers Out are increased to cover the additional construction costs proportional to Health Services' use of the 244 and 236 Kingwood buildings in North County G The stated amount is an estimate. Final Beginning Fund Balance will be determined after the final close of FY22. Budget to Actuals Report Community Development - Fund 295 FY23 YTD October 31, 2022 (unaudited) RESOURCES Admin - Operations Code Compliance Building Safety Electrical Onsite Wastewater Current Planning Long Range Planning TOTAL RESOURCES REQUIREMENTS Admin - Operations Code Compliance Building Safety Electrical Onsite Wastewater Current Planning Long Range Planning TOTAL REQUIREMENTS TRANSFERS Transfers In - General Fund Transfers In - CDD Electrical Reserve Transfers Out Transfers Out - CDD Reserve TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE A B C D E F 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals OA Budget Actuals OA 138,716 842,906 3,819,940 914,750 1,056,678 1,980,521 826,806 153,688 111% 995,865 118% 4,325,818 113% 979,129 107% 983,462 93% 2,223,570 112% 880,902 107% 153,445 1,171,592 4,821,160 1,022,005 1,017,678 2,425,334 1,064,305 44,602 321,311 1,563,743 286,841 260,264 653,456 313,670 29% 27% 32% 28% 26% 27% 29% 9,580,316 10,542,434 110% ; 11,675,519 3,443,886 29% Budget Actuals % Budget Actuals 3,137,795 617,012 2,284,444 556,531 765,935 1,769,333 847,839 9,978,889 2,960,981 94% 618,343 100% 2,022,820 89% 553,223 99% 643,079 84% 1,589,882 90% 575,615 68% 8,963,943 90% 3,432,980 805,614 2,538,721 641,837 753,369 2,062,044 998,739 11,233,304 1,006,977 232,890 644,006 182,707 238,567 483,863 268,558 3,057, 569 Projection % $ Variance 149,845 906,467 4,661,160 823,505 853,678 2,011,184 881,978 10,287,817 98% : (3,600): 77% (265,125); A 97% (160,000); A 81% ; (198,500); A 84% (164,000); A 83% (414,150); A 83% (182,327); A 88% ; (1,387,702); Projection % $ Variance 29% 29% 25% ° 28% 32% ° 23% 27% of 27% Budget Actuals % Budget Actuals 290,000 170,661 59% : 160,000 (99,360) (99,360) 100% : (112,619) (461,262) (1,230,508) 267% (958,966) (270,622) (1,159,207) 428% ; (911,585) 44,620 28% (37,528) (443,021) (435,929) 33% 46% 48% Budget Actuals % Budget Actuals % 1,432,367 (398,573) (270,622) 1,749,673 122% 1,578,491 (1,159,207) 2,096,504 442,215 (911,585) $ 763,172 $ 2,168,956 284% ; $ 1,627,134 3,089,125 90% : 343,855: B 740,336 92% 65,278; B 1,983,175 78% 555,546; B 550,345 86% 91,492, B 748,369 99% 5,000 1,594,384 77% 467,660; B 998,739 100% 9,704,473 86% ; 1,528,831: Projection % $ Variance 160,000 100%73,933 (112,619) 100% (1,395,737) 146% (1,274,423) 140% -° C 73,933: D (436,771): E (362,838): Projection % $ Variance 2,168,956 103% 386,316 ii (435,929) $ 2,119,344 130% ; ; $ 1,477,877 91% ; ($149,257); YTD revenue collection is lower than anticipated due to application volume decrease Projections reflect unfilled positions $40K to Current Planning will be transferred as needed Transfer in from reserves anticipated due to revenue collection less than anticipated Transfer out projection increased due to reduced expenditures related to unfilled FTE Final Beginning Fund Balance will be determined after the final close of FY22 2,168,956 103% : 72,452: F 583,344 141,129 (1,274,423) ; (362,838) s ; )TES Budget to Actuals Report Road - Fund 325 FY23 YTD October 31, 2022 (unaudited) RESOURCES Motor Vehicle Revenue Federal - PILT Payment Other Inter -fund Services Forest Receipts Sale of Equip & Material Cities-Bend/Red/Sis/La Pine Miscellaneous Interest on Investments Mineral Lease Royalties Assessment Payments (P&I) State Miscellaneous 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals 17,485,000 2,096,751 1,221,632 627,207 449,150 560,000 67,340 59,109 60,000 3,460 19,740,504 2,195,918 1,254,413 792,420 341,833 155,269 68,747 55,083 148,267 16,052 113% 105% 103% 126% 76% 28% 102% 93% 247% 464% 19,483,147 2,200,000 1,311,901 882,502 426,000 403,731 77,610 54,172 50,000 6,791,102 2,239,616 93,063 103,496 266,129 24,220 15,007 1,427 2,766 35% 102% 7% 0% 24% 66% 31% 28% 3% Projection % $ Variance 19,483,147 2,239,616 1,311,901 882,502 426,000 403,731 77,610 40,470 50,000 10,000 100% 102% 100% 100% 100% ; 100% I 100% o 75% o 100% 1 39,616: A (13,702); B 10,000; C TOTAL RESOURCES 22,629,649 24,768,506 109% ; 24,889,063 9,536,825 38% ; , 24,924,977 100% ; 35,914: REQUIREMENTS Budget Actuals 0/0 Budget Actuals % Projection % $ Variance Personnel Services 6,916,229 6,751,810 98% : 7,802,271 2,357,700 30% : : 7,581,974 97% :1 220,297: D Materials and Services 7,843,400 6,877,560 88% ; 8,315,339 2,124,066 26% . . 8,315,339 100% Capital Outlay o 264,500 141,754 54% ; 71,386 34,922 49% ; ; 71,386 100% 1 1 1 1 1 1 TOTAL REQUIREMENTS : 15,024,128 13,771,124 92% : 16,188,996 4,516,688 28% : : 15,968,699 99% : 220,297: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out :1 (11,757,547) (11,757,547) 100% (12,330,136) (7,440,775) 60% (12,330,136) 100% a -' 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: E Resources over Requirements 7,605,521 10,997,382 8,700,067 5,020,137 ; ; 8,956,278 256,211 Net Transfers - In (Out) (11,757,547) (11,757,547) (12,330,136) (7,440,775) (12,330,136) 1 ! 1 1 1 1 TOTAL FUND BALANCE $ 2,231,806 $ 7,806,356 350% ; $ 2,262,898 $ 5,385,718 238% ; ; $ 4,432,499 196% ; $2,169,601: A Actual payment higher than budget g Investment Income projected to come in lower than budget c Updated based on YTD actuals trending higher than budgeted D Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.1 % E Final Beginning Fund Balance will be determined after the final close of FY22 2„ Budget to Actuals Report Adult P&P - Fund 355 FY23 YTD October 31, 2022 (unaudited) RESOURCES DOC Grant in Aid SB 1145 CJC Justice Reinvestment DOC Measure 57 State Miscellaneous Interfund- Sheriff Gen Fund/Crime Prevention Oregon BOPPPS Interest on Investments Electronic Monitoring Fee Miscellaneous DOC-Family Sentence Alt Probation Work Crew Fees Probation Supervision Fees TOTAL RESOURCES REQUIREMENTS 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Ok Budget Actuals 4,202,885 781,597 255,545 138,000 50,000 50,000 24,281 45,193 2,500 500 118,250 1,500 170,000 4,734,453 113% 892,038 114% 244,606 96% 96,068 70% 55,000 110% 50,000 100% 20,318 19,125 42% 280 11% 3,904 781% 58,958 50% 3,606 2% 84% 0% 4,734,453 892,038 244,606 123,453 50,000 50,000 20,318 18,151 500 500 2,367,226 50% 446,019 50% 271,606 111% 10,837 9% 16,667 14,205 268 54% 72 14% 33% 0% 0% 78% 5,840,250 6,178,356 106% ; 6,134,018 Projection % $ Variance 4,734,453 892,038 271,606 70,000 50,000 50,000 20,318 39,140 500 500 100% 100% 111% 57% 100% 100% i 100% 216% 100% 100% 27,000. A (53,453)i B 20,989! C 3,126,900 51% ; , 6,128,554 100% ; (5,464): Budget Actuals Budget Actuals % Personnel Services 5,379,503 4,864,354 90% : 5,683,822 Materials and Services 1,700,412 1,528,224 90% ; 1,883,614 Capital Outlay - 8,475 TOTAL REQUIREMENTS ; 7,079,915 6,392,578 90% ; 7,575,910 TRANSFERS Transfers In- General Funds Transfer to Vehicle Maint TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 1,651,607 29% 523,441 28% 598 7% Projection % $ Variance 5,070,293 89% 1,762,626 94% 8,475 100% 613,529: D 120,988; E 2,175,645 29% ; , 6,841,393 90% ; 734,517: Budget Actuals Budget Actuals 662,046 (190,974) 471,072 662,045 100% (190,974) 100% 471,071 100% 536,369 (69,277) 467,092 Projection % $ Variance 178,784 33% (23,092) 33% 155,692 33% 536,369 100% (69,277) 100% 467,092 100% Budget Actuals Budget Actuals % 2,739,775 (1,239,665) 471,072 2,982,055 (214,221) 471,071 109% 3,100,000 (1,441,892) 467,092 3,238,905 951,254 155,692 104% $ 1,971,182 $ 3,238,905 164% $ 2,125,200 $ 4,345,851 204% Projection % $ Variance 3,238,905 104% (712,839) 467,092 $ 2,993,158 141% 138,904: F 729,053; $867,958: A DOC has increased funds for M57. Deschutes County received an additional $27K for housing and curriculum training. g Close out of Adult Treatment Court. No longer accepting new clients. c Investment Income projected to come in higher than budget D Projected Personnel savings based on FY22/FY23 average vacancy rate of 11% E Adult Treatment Court Closure and based on other expense trends. F Final Beginning Fund Balance will be determined after the final close of FY22 0-(ES� 2� Budget to Actuals Report L� �G Road CIP - Fund 465 FY23 YTD October 31, 2022 (unaudited) RESOURCES State Miscellaneous Interest on Investments TOTAL RESOURCES REQUIREMENTS 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals Projection % $ Variance 2,191,461 1,000,000 46% : 1,818,500 - 0% : : 818,500 45% ; (1,000,000): A 279,729 124,832 45% 124,563 85,266 68% I 255,560 205% ; a a 130,997; B , a , 2,471,190 1,124,832 46% ; 1,943,063 85,266 4% ; , 1,074,060 55% ; (869,003): Budget Actuals Budget Actuals % Projection % $ Variance Materials and Services 109,870 109,870 100% : 127,640 42,547 33% : : 127,640 100% : Capital Outlay 1 29,612,821 7,996,247 27% : 28,259,526 12,519,853 44% ,a a 27,291,683 97% 967,843 , , TOTAL REQUIREMENTS : 29,722,691 8,106,117 27% : 28,387,166 12,562,399 44% : : 27,419,323 97% : 967,843: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 12,193,917 10,672,113 88% : 14,230,313 4,889,361 34% : : 14,230,313 100% TOTAL TRANSFERS 12,193,917 10,672,113 88% ; 14,230,313 4,889,361 34% ; , 14,230,313 100% FUND BALANCE Budget Actuals Budget Actuals OA 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: C Resources over Requirements ; (27,251,501) (6,981,285) (26,444,103) (12,477,134) (26,345,263) 98,840 Net Transfers - In (Out) a , , a 12,193,917 10,672,113 14,230,313 4,889,361 14,230,313 , 1 , TOTAL FUND BALANCE $ 5,316,460 $ 27,223,832 512% ; $ 12,334,484 $ 19,636,059 159% ; ; $ 15,108,882 122% ; $2,774,398: A GIM was budgeted in FY21but received in FY22 g Investment Income projected to come in higher than budget c Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Road CIP (Fund 465) - Capital Outlay Summary by Project FY23 YTD October 31, 2022 (unaudited) Terrebonne Refinement Plan US 20 at Tumalo Tumalo Road / Tumalo Place Old Bend Rdm/Tumalo Rd Inter NE Negus and 17TH Hunnel Rd: Loco Rd to Tumalo Rd Transportation System Plan Update Gabbling Rd Bridge Terrebonne Wastewater Feasibility St. Rickard Rd: Groff Rd to US 20 Paving Powell Butte Hwy Smith Rock Way Bridge Replace Deschutes Mkt Rd/Hamehook Round Paving Cottonwood: Us 97 To BSNF RR Paving Desch Mkt Rd: Yeoman Hamehoo Paving Alfalfa Mkt Rd: Mp 4 Dodds Paving Of Hamby Rd: Us 20 To Butler Powell Butte Hwy/Butler Market RB Wilcox Ave Bridge #2171-03 Replacem US 20: Tumalo Multi -Use Path Crossing Highway Warning Systems 2021 Tumalo Wastewater Feasibility Study Paving Tumalo Rd/Deschutes Mkt Rd Slurry Seal 2022 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 Seal 2023 Terrebonne Wastewater System Phase 1 Tumalo Resevoir Rd: OB Riley to Sisemore Rd Local Road Pavement Preservation FY 22 Guardrail Improvements FY 23 Guardrail Imrovements Redmond District Local Roads Bend District Local Roads Sidewalk Ramp Improvements Signage Improvements TOTAL CAPITAL OUTLAY 33.3% Year Completed Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals Projection % $ Variance $ 10,000,000 $ 6,700,000 $ 7,319,310 $ 2,200,000 30% 6,700,000 6,700,000 100% 67,998 16,907 2,363,532 2,142,875 91% 2,168,940 637,975 29% 4,265,216 83,874 2% 108,510 86,081 79% 12,936 279,575 1,110 0% 818,500 7,529 1% 35,130 1,716,142 1,391,051 81% 931,140 1,319,374 142% 505,000 1,869 0% 985,000 4,480 0% 671,000 208,367 31% 1,663,000 40,107 2% 618,144 499,075 81% 310,838 - 0% 443,000 - 0% 265,000 2,638 1% 1,200,000 1,788,826 149% 200,000 1,912 1% 333,000 999,285 300% 150,000 38,562 26% 785,000 33,115 4% 100,000 - 01 160,000 0% 1,250,000 1,200,000 96% 69,536 219 1,640 246,000 32,693 13% 1,148 - 337,183 380,000 - 0% 150,000 0% 96,500 0% 100,000 0% 815,000 0% 300,000 0% 1,000,000 - 0% 100,000 0% 200,000 0% 100,000 114,378 114% 150,000 0% 500,000 - 0% - 500,000 - 0% - 75,000 156,557 209% 50,000 182,670 365% 100,000 1,843 2% 97,156 $ 7,319,310 100% 6,700,000 100% 4,820,216 113% 40,000 418,500 51% 485,000 49% 1,663,000 100% 0% 1,788,826 149% 999,286 300% 335,000 43% 160,000 100% 32,692 13% 337,183 380,000 100% 0% 40,000 41 % 100,000 100% 815,000 100% 300,000 100% 0% 100,000 100% 200,000 100% 75,000 50 % 182,670 365% (555,000) (40,000) 400,000 500,000 443,000 (588,826) (666,286) 450,000 213,308 (337,183) 150,000 56,500 1,000,000 75,000 (132,670) $ 29,612,821 $ 7,996,247 27 % $ 28,259,526 12,519,853 44% $ 27,291,683 97% $ 967,843 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 Budget to Actuals Report Solid Waste - Fund 610 FY23 YTD October 31, 2022 (unaudited) RESOURCES Franchise Disposal Fees Private Disposal Fees Commercial Disp. Fee Franchise 3% Fees Yard Debris Miscellaneous Interest on Investments Special Waste Recyclables Leases 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals OA Budget Actuals 7,124,000 2,827,000 2,686,000 290,000 300,000 55,000 41,599 15,000 12,000 1 6,891,500 3,191,189 3,075,123 337,878 268,060 88,470 27,916 37,718 12,980 1 97% 113% 114% 117% 89% 161% 67% 251% 108% 100% 7,210,000 3,337,000 3,234,000 305,000 290,000 70,000 30,498 15,000 12,000 1 2,404,126 33% 1,282,348 1,194,901 93,432 31% 128,858 44% 52,308 75% 12,736 42% 15,694 105% 3,250 27% - 0% 38% 37% Projection $ Variance 1 I TOTAL RESOURCES 13,350,600 13,930,834 104% ; 14,503,499 REQUIREMENTS Personnel Services Materials and Services Capital Outlay Debt Service TOTAL REQUIREMENTS TRANSFERS SW Capital & Equipment Reserve RC.7C1 V C TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 7,210,000 3,337,000 3,234,000 305,000 290,000 70,000 38,490 20,000 12,000 1 100% 100% 100% 100% 100% ' 100% 126% 133% . I 100% . 100% A A A B 7,992! C 5,000 5,187,652 36% 14,516,491 100% ; 12,992: Budget Actuals % Budget Actuals 2,754,132 5,651,103 53,141 1,251,615 9,709,991 2,694,834 98% 5,192,786 92% 76,304 144% 828,197 66% 8,792,122 91% 3,277,684 982,200 6,473,358 1,535,070 264,000 1,739,630 204,993 11,754,672 2,722,262 Projection % $ Variance 30% 24% 0% 12% ' ' 1 I 23% Budget Actuals Budget Actuals Ok 3,277,684 100% 6,473,358 100% t 264,000 100% 1,739,630 100% 11,754,672 100% -' D Projection % $ Variance (6,029,323) (6,029,323) 100% (5,299,665) (2,644,652) 50% (5,299,665) 100% (6,029,323) (6,029,323) 100% ; (5,299,665) (2,644,652) 50% ; ; (5,299,665) 100% Budget Actuals Budget Actuals % 2,972,234 3,640,609 (6,029,323) 3,957,273 133% 5,138,712 (6,029,323) 3,107,198 2,748,827 (5,299,665) Projection % $ Variance 3,097,007 100% 1 1 2,465,390 1 I (2,644,652) 3,097,007 100% o (10,191):I E 2,761,819 ' 12,992; (5,299,665) 1 $ 583,520 $ 3,066,662 526% ; $ 556,359 $ 2,917,745 524% $ 559,161 101% ; $2,801: A Total disposal fee projections reflect managements best estimate of revenues to be collected; disposal tons are typically higher in the summer with reductions in winter. YTD volumes are running 5% higher than last year-to-date. g Annual fees due April 15, 2023; received year-to-date monthly installments from Republic c Investment Income projected to come in higher than budget D Revenue source is unpredictable and dependent on special clean-up projects of contaminated soil and asbestos E Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Fair & Expo - Fund 615 FY23 YTD October 31, 2022 (unaudited) RESOURCES Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Camping Fee Interest on Investments Miscellaneous Interfund Payment TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals OA 578,000 513,500 105,000 77,500 71,500 19,500 474 250 30,000 786,724 136% 792,639 154% 38,192 36% 46,525 60% 66,636 93% 11,675 60% 5,301 999% 2,032 813% 30,000 100% 745,759 415,000 105,000 65,000 49,000 20,000 5,221 3,554 1,395,724 1,779,723 128% 1,408,534 Projection % $ Variance 293,371 39% :1 745,759 100% 1 I 249,269 60% ' 415,000 100% 1 1 35,400 34% ; 105,000 100% 1 � 1 - 0% . a 65,000 100% I 1 1 38,020 78% i 49,000 100% e 3,475 17% . 20,000 100% I � I 3,695 71% : 10,200 195% 1 I I 1,222 34% : 3,554 100% I e - 1 1 - _i _i 4,979: A 1 624,451 44% ; , 1,413,513 100% ; 4,979; REQUIREMENTS Budget Actuals Budget Actuals Personnel Services Personnel Services - F&B Materials and Services Materials and Services - F&B Debt Service TOTAL REQUIREMENTS Projection % $ Variance 1,118,980 1,129,821 101% 1,256,902 390,740 31% : : 1,072,283 85% 181,593 200,062 110% 170,247 20,466 12% : 139,709 82% ° 818,804 852,050 104% 965,684 269,456 28% : 965,684 100% 282,500 342,748 121% 273,950 71,435 26% . 273,950 100% e 103,000 101,799 99% 101,270 - 0% ' 101,270 100% e 1 1 2,504,877 2,626,480 105% ; 2,768,054 752,097 27% ; , 2,552,897 92% ; 215,157: TRANSFERS Budget Transfers In - Room Tax Transfers In - Park Fund Transfers In - County Fair Transfers Out TOTAL TRANSFERS Actuals Budget Actuals 1,093,513 30,000 150,000 (310,777) 962,736 1,049,581 96% 30,000 100% 150,000 100% (310,777) 100% 918,804 95% 184,619: B 30,538; C _I Projection % $ Variance 1,101,342 367,112 33% 1 � 30,000 10,000 33% ; 1 (427,215) (142,404) 33% i i 704,127 234,708 33% FUND BALANCE Budget Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Actuals Budget Actuals OA 750,673 (1,109,153) 962,736 923,473 123% (846,757) 918,804 971,352 (1,359,520) 704,127 1,130,277 103% 30,000 100% 1 (427,215) 100% 733,062 104% 28,935: D 28,935: Projection % $ Variance 996,420 103% 1 I (127,646) ; ; 234,708 I 1 996,420 103% (1,139,384) 733,062 25,068: E 220,136 28,935 $ 604,256 $ 995,519 165% ; $ 315,960 $ 1,103,482 349% ; ; $ 590,098 187% ; $274,139: A Investment Income projected to come in higher than budget g Projected Personnel savings based on FY22/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 E Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report Annual County Fair - Fund 616 FY23 YTD October 31, 2022 (unaudited) RESOURCES Gate Receipts Concessions and Catering Carnival Commercial Exhibitors Fair Sponsorship State Grant Rodeo RN Camping/Horse Stall Rental Livestock Entry Fees Merchandise Sales Interest on Investments TOTAL RESOURCES REQUIREMENTS Personnel Services Materials and Services TOTAL REQUIREMENTS TRANSFERS Transfer In - TRT 1% Transfer Out - Fair & Expo Transfers Out 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals OA 550,000 385,000 330,000 110,000 83,500 52,000 20,000 25,500 4,500 738,029 134% 526,737 137% 415,716 126% 86,200 78% 51,035 61% 53,167 102% 24,050 120% 19,815 78% 0% 5,239 2,683 710,000 505,000 385,000 80,000 61,000 53,167 24,000 20,000 5,000 3,500 2,713 782,364 815,458 433,682 117,100 101,370 53,167 30,970 17,520 1,925 3,245 3,220 110% 161% 113% 146% 166% 100% 129% 88% 39% 93% 119% 1,560,500 1,922,671 123% 1,849,380 2,360,021 128% Projection $ Variance 782,424 110% ; 815,461 161% 433,682 113% 117,100 146% 109,370 179% 53,167 100% 30,970 129% 17,520 88% 2,169 43% i 3,245 93% s 7,890 291% 2,372,997 128% 72,424: 310,461! 48,682 37,100 48,370 6,9701 (2,480) (2,831) (255) 5,177; A 523,617: Budget Actuals Budget Actuals 155,959 1,312,172 1,468,131 36,681 24% 1,316,102 100% 1,352,783 92% 169,445 1,682,585 1,852,030 Projection % $ Variance 64,771 38% 1,608,299 96% 1,673,069 90% 169,445 100% 1,682,585 100% 1,852,030 100% Budget Actuals Budget Actuals 75,000 75,000 100% : 75,000 (150,000) (150,000) 100% (23i,706) 25,000 33% (77,232) 33% TOTAL TRANSFERS (75,000) (75,000) 100% ; (156,706) FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Projection % $ Variance 75,000 100% e (231,706) 100% (52,232) 33% ; ; (156,706) 100% Budget Actuals Budget Actuals % 92,369 (75,000) (109,033) 999% 569,888 (75,000) 384,715 (2,650) (156,706) 385,854 100% e s $ 1,020,574 453% 686,952 (52,232) $ 17,369 $ 385,854 999% ; $ 225,358 Projection % $ Variance 385,854 100% 520,967 (156,706) 1,139: B 523,617 $ 750,115 333% ; $524,757: A Investment Income projected to come in higher than budget g Final Beginning Fund Balance will be determined after the final close of FY22 0TES Budget to Actuals Report Annual County Fair - Fund 616 RESOURCES Gate Receipts Carnival Commercial Exhibitors Livestock Entry Fees RN Camping/Horse Stall Rental Merchandise Sales Concessions and Catering Fair Sponsorship TOTAL FAIR REVENUES OTHER RESOURCES State Grant Interest Miscellaneous TOTAL RESOURCES REQUIREMENTS Personnel Materials & Services TOTAL REQUIREMENTS TRANSFERS Transfer In - TRT 1% Transfer Out - F&E Reserve Transfer Out - Fair & Expo TOTAL TRANSFERS Net Fair Beginning Fund Balance on Jan 1 Ending Balance Fair 2021 Fair 2022 Actuals to Date 2022 Projection $ 738,029 415,716 315,719 19,944 5,239 295,093 81,125 $ 1,870,865 53,167 1,194 $ 1,925,226 103,199 1,249,932 $ 1,353,131 74,750 (150, 000) $ (75,250) $ 496,845 $ (48,694) $ 448,151 782,364 433,682 436,292 1,925 17,392 3,245 497,366 126,300 $ 2,298,566 $ 782,364 433,682 436,292 1,925 17,392 3,245 497,366 126,300 $ 2,298,566 53,167 53,167 4,502 5,252 2,356,234 $ 2,356,984 88,203 118,691 1,680,236 1,689,402 $ 1,768,438 $ 1,808,092 62,500 75,000 (77,232) (115,848) (14,732) $ (40,848) 573,064 $ 508,044 448,151 $ 448,151 $ 1,021,215 $ 956,195 Budget to Actuals Report Fair & Expo Capital Reserve - Fund 617 FY23 YTD October 31, 2022 (unaudited) RESOURCES Interest on Investments TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 8,544 8,012 94% 8,544 8,012 94% 7,414 Projection % $ Variance 7,350 99% : 19,950 269% : 12,536: A a l a I 7,414 7,350 99% ; , 19,950 269% 12,536: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 180,000 8,564 5% : 220,000 92 0% : : 220,000 100% Capital Outlay 1 388,000 (894) 0% . 650,000 - 0% ! ! 650,000 100% ; B I a l 1 a TOTAL REQUIREMENTS : 568,000 7,670 1% : 870,000 92 0% : : 870,000 100% ; TRANSFERS Budget Actuals OA Budget Actuals Projection % $ Variance Transfers In - TRT 1% 498,901 479,502 96% : 501,683 167,224 33% : : 514,086 102% : 12,403: C Transfers In - Fair & Expo 300,000 300,000 100% ; 416,437 138,812 33% ! : 416,437 100% Transfers In -Annual County Fair. - 231,706 77,232 33% 231,706 100% I 1 1 1 a a TOTAL TRANSFERS 798,901 779,502 98% : 1,149,827 383,268 33% : : 1,162,230 101% : 12,403: 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,49& D Resources over Requirements I (559,456) 342 (862,586) 7,259 1 1 (850,050) 12,536� Net Transfers - In (Out) 798,901 779,502 1,149,827 383,268 , = 1,162,230 12,403 1 I 1 1 a I TOTAL FUND BALANCE : $ 1,341,108 $ 1,809,440 135% ; $ 1,587,183 $ 2,199,967 139% : : $ 2,121,620 134% ; $534,437: A B C D Investment Income projected to come in higher than budget Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction Transfers expected to be higher than budget due to increased Room Tax revenue Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report RV Park - Fund 618 FY23 YTD October 31, 2022 (unaudited) RESOURCES 33.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals 0/0 Budget Actuals Projection % $ Variance RV Park Fees < 31 Days 495,000 551,683 111% 605,000 222,359 37% : 605,000 100% Cancellation Fees 15,725 14,000 5,604 40% : 14,000 100% RV Park Fees > 30 Days 10,500 8,499 81% 13,000 0% : 13,000 100% Washer / Dryer 5,000 3,476 70% 4,200 2,971 71% : 4,200 100% Miscellaneous 2,500 3,731 149% 3,750 1,142 30% : 3,750 100% Vending Machines 2,500 1,021 41% ! 1,750 936 53% ! 1,750 100% Interest on Investments 2,024 578 29% : 552 618 112% ! 1,660 301% TOTAL RESOURCES REQUIREMENTS 1,108. A 517,524 584,713 113% ; 642,252 233,629 36% ; 643,360 100% ; 1,108: Budget Actuals 0/0 Budget Actuals 0/0 Projection % $ Variance Personnel Services 19,456 1,643 8% : 111,153 27,198 24% : 104,640 94% : 6,513: B Materials and Services 310,805 242,863 78% ! 259,755 96,986 37% 259,755 100% Debt Service 221,927 221,629 100% ! 223,273 - 0% I 223,273 100% 1 I 1 1 8 1 TOTAL REQUIREMENTS ; 552,188 466,135 84% ; 594,181 124,184 21% ; , 587,668 99% ; 6,513: TRANSFERS Budget Actuals Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 1 160,000 - 0% 160,000 100% : C Transfers In - TRT Fund 1 20,000 20,000 100% ! 20,000 6,664 33% : ! 20,000 100% Transfer Out - RV Reserve (132,042) (132,042) 100% : (261,566) (87,188) 33% � (261,566) 100% I 1 1 1 TOTAL TRANSFERS 47,958 47,958 100% : (81,566) (80,524) 99% : : (81,566) 100% ; , FUND BALANCE Budget Actuals Budget Actuals Projection % $ Variance Beginning Fund Balance 116,415 166,536 143% : : 166,536 143% ; 50,121: D Resources over Requirements : (34,664) 118,578 48,071 109,446 55,692 7,621 1 I 1 1 1 1 Net Transfers - In (Out) a 47,958 47,958 (81,566) (80,524) ' (81,566) . -; TOTAL FUND BALANCE ; $ 13,294 $ 166,536 999% ; $ 82,920 $ 195,458 236% ; ; $ 140,662 170% ; $57,742: A Investment Income projected to come in higher than budget B Projected Personnel based on vacancy savings to date C Transfer booked in November D Final Beginning Fund Balance will be determined after the final close of FY22 Budget to Actuals Report RV Park Reserve - Fund 619 FY23 YTD October 31, 2022 (unaudited) RESOURCES Interest on Investments 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Ok Budget Actuals Projection % $ Variance 7,546 6,354 84% : 6,298 4,477 71% : ; 12,400 197% : 6,102; A 1 1 1 1 TOTAL RESOURCES 7,546 6,354 84% ; 6,298 4,477 71% ; : 12,400 197% : 6,102; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfer In - RV Park Ops TOTAL TRANSFERS 100,000 100,000 885 1% : 100,000 885 1% ; 100,000 4,490 4% : 100,000 100% 12 4,490 4% ; , 100,000 100% Budget Actuals OA Budget Actuals % Projection % $ Variance 132,042 132,042 100% : 261,750 87,188 33% : : 261,566 100% : (184); 11 1 , 132,042 132,042 100% ; 261,750 87,188 33% ; , 261,566 100% ; (184); B 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: C Resources over Requirements (92,454) 5,469 (93,702) (13) (87,600) 6,102 Net Transfers - In (Out) 132,042 132,042 261,750 87,188 . . 261,566 (184); TOTAL FUND BALANCE : $ 824,054 $ 1,191,937 145% ; $ 1,340,766 $ 1,279,112 95% : ; $ 1,365,903 102% ; $25,137: A Investment Income projected to come in higher than budget g Capital Outlay appropriations are a placeholder c Final Beginning egIn_i_j Fund Balance will be determined after the final close of FY22 1, Budget to Actuals Report Risk Management - Fund 670 FY23 YTD October 31, 2022 (unaudited) RESOURCES 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals OA Budget Actuals Projection % $ Variance Workers' Compensation 1,120,766 1,164,543 104% 1,234,761 408,212 33% :: 1,234,761 100% General Liability 944,278 940,773 100% 892,681 297,560 33% : 892,681 100% Unemployment 323,572 334,147 103% 430,179 295,562 69% 1 430,179 100% Property Damage 393,546 409,593 104% 419,566 139,855 33% 1 419,566 100% Vehicle 227,700 227,700 100% 248,764 82,921 33% . 248,764 100% , Interest on Investments 101,111 50,142 50% 49,346 32,850 67% : 92,120 187% ° 42,774; B Claims Reimbursement 25,000 1,280,876 999% 25,000 1,110 4% ; 25,000 100% : 1 Skid Car Training 10,000 0% 10,000 - 0% . 100 1% Process Fee- Events/ Parades 1,000 1,485 149% 1,000 405 41% 1,000 100% I I I 1 Miscellaneous 180 180 - 0% : 180 100% I 1 1 1 1 TOTAL RESOURCES 3,146,973 4,409,440 140% : 3,311,477 1,258,475 38% ; , 3,344,351 101% : 32,874: REQUIREMENTS General Liability Workers' Compensation Insurance Administration Property Damage Vehicle Unemployment TOTAL REQUIREMENTS TRANSFERS Transfers Out - Vehicle Replacement TOTAL TRANSFERS FUND BALANCE (9,900); C Budget Actuals Budget Actuals % Projection % $ Variance A 3,600,000 2,706,359 75% : 3,000,000 394,800 13% : : 2,500,000 83% : 500,000: D 1,580,000 953,365 60% 1,580,000 558,128 35% 2,000,000 127% o (420,000); E 547,047 491,393 90% 607,558 192,384 32% ; ; 607,558 100% 300,245 604,926 201% 300,248 51,632 17% ; . 280,000 93% :20,248: F 200,000 137,356 69% 200,000 83,563 42% . 1 250,000 125% . (50,000); E 1 1 1 200,000 89,053 45% . 200,000 - 0% : :1 1 1 200,000 100% , a aa a 6,427,292 4,982,451 78% ; 5,887,806 1,280,507 22% ; , 5,837,558 99% ; 50,248 Budget Actuals % Budget Actuals OA (3,500) (3,500) 100% (3,500) (1,164) 33% (3,500) (3,500) 100% (3,500) (1,164) 33% Projection % $ Variance (3,500) 100% (3,500) 100% 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: G Resources over Requirements (3,280,319) (573,012) (2,576,329) (22,032) ; (2,493,207) 83,122 I 1 1 1 Net Transfers - In (Out) (3,500) (3,500) (3,500) (1,164) 1 (3,500) -; $ 5,045,296 $ 8,944,938 177% ; $ 5,107,351 $ 8,921,742 175% : : $ 6,448,231 126% ; $1,340,880; TOTAL FUND BALANCE 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; but only for employees, revenue on this line item is from the public D Trending lower than budget E Trending higher than budget F FY22 had abnormally high property damage; anticipating less in FY23 G Final Beginning Fund Balance will be determined after the final close of FY22 `�u1ES Budget to Actuals Report -.� Health Benefits - Fund 675 FY23 YTD October 31, 2022 (unaudited) RESOURCES Internal Premium Charges COIC Premiums Employee Co -Pay Retiree / COBRA Premiums Prescription Rebates Interest on Investments Claims Reimbursement & Other TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 18,767,900 1,589,000 1,200,000 1,060,000 128,000 200,277 82,000 19,164,548 102% 1,255,305 79% 1,238,034 103% 1,438,217 136% 396,119 309% 90,816 45% 1,487,600 999% 19,908,221 1,547,778 1,282,015 595,000 175,000 95,686 55,000 Projection % $ Variance 6,485,270 33% : 19,908,221 100% 577,894 414,192 32% 178,120 30% 143,340 82% ! io 46,011 48% 5,764 10% 37% 23,027,177 25,070,639 109% ; 23,658,700 1,547,778 100% 1,282,015 100% 595,000 100% e 175,000 100% 131,380 137% 55,000 100% A 35,694; B 7,850,592 33% 23,694,394 100% ; 35,694: REQUIREMENTS Budget Health Benefits Deschutes On -Site Pharmacy Deschutes On -Site Clinic Wellness Actuals Budget Actuals OA 25,140,847 2,970,575 1,141,829 171,142 TOTAL REQUIREMENTS ; 29,424,393 24,583,764 98% 3,381,197 114% 1,190,855 104% 138,211 81% 29,294,027 100% 21,597,563 3,779,608 1,212,497 179,549 5,301,214 819,341 286,277 39,898 25% 22% 24% 22% Projection % $ Variance 21,597,563 100% 3,779,608 100% 1,212,497 100% 179,549 100% 26,769,217 6,446,730 24% ; 26,769,217 100% C C C 2C FUND BALANCE Budget Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Actuals Oh Budget Actuals % 14,772,618 (6,397,216) 15,527,580 105% (4,223,389) 11,925,656 (3,110,517) 11,304,191 1,403,862 95% Projection % $ Variance ;e ie $ 8,375,402 $ 11,304,191 135% ; 11,304,191 (3,074,823) 95% i (621,465)' D 35,694; -i $ 8,815,139 $ 12,708,052 144% ; ; $ 8,229,368 93% ; ($585,771); A Budget estimate is based on claims which are difficult to predict g Investment Income projected to come in higher than budget c Amounts are paid 1 month in arrears D Final Beginning Fund Balance will be determined after the final close of FY22 01 ES Budget to Actuals Report 911 - Fund 705 and 710 FY23 YTD October 31, 2022 (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 REQUIREMENTS 33.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 0/0 9,803,579 9,931,743 101% 1,106,750 1,815,283 164% 60,000 123,282 205% 236,576 237,221 100% 147,956 157,552 106% 233,576 140,986 60% 162,000 244,799 151% 115,000 92,601 81% 96,867 69,988 72% 38,344 37,525 98% 18,658 45,553 244% 12, 019, 306 12, 896, 533 107% 10,402,834 1,668,000 810,000 237,221 153,292 140,445 120,874 80,000 67,515 39,497 25,000 13,744,678 920,416 15,000 18,870 4,313 26,024 40,771 39,548 322 13,045 1,078,309 9% 0% 2% 0% 12% 3% 22% 51% 59% 1% 52% 8% Projection % $ Variance 10,421,062 1,668,000 810,000 237,221 153,292 140,445 120,874 80,000 116,280 39,497 25,000 100% 100% 100% 100% 100% I 100% 100% 100% 172% 100% 100% 18,228: A -B C D I 48,765 E 13,811,671 100% ; 66,993: Budget Actuals 0/0 Budget Actuals 0/0 Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 8,005,795 3,582,212 2,975,000 14,563,007 7,462,327 2,915,749 518,824 10,896,900 93% 81% 17% 75% 8,606,196 4,088,201 5,075,000 17,769,397 2,563,383 30% i 836,140 20% 246,232 3,645,756 5% I , , 1 21% Projection % $ Variance 7,563,412 88% a 1,042,784: F 4,088,201 100% 5,075,000 100% I o I i 16,726,613 94% ; 1,042,784; Budget Actuals Budget Actuals 11,850,783 (2,543,701) 10,709,072 90% 1,999,633 12,950,799 (4,024,719) $ 9,307,082 $ 12,708,705 137% $ 8,926,080 Projection % $ Variance 12,708,705 98% ; it (2,567,447) II $ 10,141,258 114% 12,708,705 (2,914,942) 98% (242,094). 1,109,777; I -i $ 9,793,763 110% ; $867,683: 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 c D E F G Telephone tax payments are received quarterly State GIS reimbursements are received quarterly Invoices are mailed in the Spring Investment Income projected to come in higher than budget Projected Personnel savings based on FY22/FY23 average vacancy rate of 13.5% Final Beginning Fund Balance will be determined after the final close of FY22 OREGON COALITION OF LOCAL HEALTH OFFICIALS Representing the collective interests of Oregon's 33 local public health authorities to improve the health of all Oregonians. oregonclho.org December 2, 2022 Governor -Elect Tina Kotek PO Box 42307 Portland, OR 97242 SENT VIA ELECTRONIC MAIL ONLY Dear Governor -Elect Kotek: First of all, congratulations on your election! We are excited to work with you in this new role. As you fine-tune your vision for Oregon, we sincerely hope that investments in public health will be top of mind — Oregon's front-line response and key to achieving health equity. We believe that all Oregonians deserve to be healthy, regardless of where they live. Ten years ago, Rep. Mitch Greenlick had a vision for what public health should and could become, if properly resourced. And we know that when all systems are fully operational, local public health is preventing the spread of disease, helping new parents and babies get off to healthy starts, providing safety -net reproductive health services, working at all levels to turn the tide on chronic diseases, ensuring our drinking water is clean and our restaurants are following food safety protocols, and, as we know from the last few years preparing for and responding to public health emergencies like the rolling effects of climate change, and more. These prevention efforts keep Oregonians out of the hospital, living healthier lives, make good on our commitments to health equity, and work to drive down burgeoning health care costs for families across the state. Along with the recommendation from the Rede Group, who recently released a report on the public health response to COVID-19 , we request your support for the full Public Health Modernization policy option package put forward by the Oregon Health Authority in your upcoming Governor's Recommended Budget. Of the $286 million requested in package #406, $110 million goes directly to local public health authorities who do critical work in health equity, climate adaptation, emergency preparedness and more. Local public health departments across the state are the conveners and coordinators responding to various threats to community health and wellness, and when chronic diseases are at play, emergencies are even more complex and difficult to manage. Local Public Health agencies are the experts who bring together various government entities with community -based organizations to get things done and keep Oregonians safe and healthy. While public health has been front and center during the Covid-19 pandemic and ongoing recovery, local health officials continue to respond to additional health threats, including the monkeypox virus and respiratory syncytial virus (RSV) state of emergency, just within this calendar year. And with climate conditions worsening, there will be no shortage of public health emergencies in the years to come. Now is the time to double down and fully invest in Oregon's public health infrastructure. Please support the full $286 million for Public Health Modernization, so that local public health officials can continue protecting Oregonians. We look forward to working with you on ensuring necessary investments in Oregon's public health infrastructure. Sincerely, The Oregon Coalition of Local Health Officials & Partners: Jamie Pang South, Oregon Environmental Council ASSOCIATION OF OREGON COUNTIES CC LANE' COUNTY OREGON Oregon Primary Care Association COALITION OF COMMUNITY HEALTH CLINICS Action OREGON FOOD BANK urn {RICAN IAYIIY IICUSa1C 'iAl111 ARC6 0111.9 OREGON PUBLIC HEALTH INSTITUTE nrPginn Pl Ihhr Health Association OREGON ACADEMY OF FAMILY PHYSICIANS MAKING HEALTH PRIMARY AR For more information, contact Sarah Lochner, Executive Director sarah@oregonclho.org 1503-507-7786. 211info * ( i ALZHEIMER'S° 1 VA IATI SSOC ON OREGON Q°inLuA I nnnn gi iiinu .)rirou. 4Uww iiuJuii i CONNECTION Public Health Prevent. Promote. Prnceet.