Loading...
2023-107-Minutes for Meeting February 22,2023 Recorded 3/30/2023Recorded in Deschutes County CJ2023-1 07 Steve Dennison, County Clerk Commissioners' Journal 03/30/2023 2:33:54 PM iuimiiinuiiuuuiiu loll Do not remove this page from original document. Deschutes County Clerk Certificate Page BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS MEETING 9:00 AM, WEDNESDAY, FEBRUARY 22, 2023 Barnes Sawyer Rooms - Deschutes Services Building - 1300 NW Wall St - Bend (541) 388-6570 I www.deschutes.org AGENDA MEETING FORMAT: In accordance with Oregon state law, this meeting is open to the public and can be accessed and attended in person or remotely, with the exception of any executive session. Members of the public may view the meeting in real time via the public meeting portal at www.deschutes.org/meetings. To view the meeting via Zoom, see below. Citizen Input: The public may comment on any meeting topic that is not on the current agenda. To provide citizen input, submit an email to citizeninput@deschutes.org or leave a voice message at 541-385-1734. Citizen input received by noon on Tuesday will be included in the meeting record for topics that are not on the Wednesday agenda. If in -person comment from the public is allowed at the meeting, public comment will also be allowed via computer, phone or other virtual means. Zoom Meeting Information: This meeting may be accessed via Zoom using a phone or computer. • To join the meeting from a computer, copy and paste this link: bit.ly/3h3ogdD. • To join by phone, call 253-215-8782 and enter webinar ID # 899 4635 9970 followed by the passcode 013510. • If joining by a browser, use the raise hand icon to indicate you would like to provide public comment, if and when allowed. If using a phone, press *6 to indicate you would like to speak and *9 to unmute yourself when you are called on. Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need accommodations to make participation possible, call (541) 388-6572 or email brenda.fritsvold@deschutes.org. CALL TO ORDER 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 Board Signature on letters reappointing Patti Gentiluomo and Ariel Cowan to the Deschutes County Project Wildfire Steering Committee 2. Consideration of Board Signature on letters reappointing Mary Meier to the Extension/4- H Advisory Council/Budget Committee and thanking Pat Kolling for her service on the Extension/4-H Advisory Council 3. Approval of minutes of the February 10, 2023 Legislative Update meeting 4. Approval of the minutes of the January 18 and 20, 2023 BOCC annual retreat ACTION ITEMS 5. 9:10 AM Document No. 2023-180, a Notice of Intent to Award Contract for the Supply and Delivery of Asphalt Oil for Chip Seal 2023 6. 9:20 AM Resolution No. 2023-012, declaring a countywide State of Emergency and requesting a State Declaration of Drought Emergency within all of Deschutes County 7. 9:35 AM Resolution 2023-033, accepting grant funds and increasing limited duration FTE and appropriations within the FY22-23 Deschutes County Budget to assist victims of domestic violence and sexual assault 8. 9:45 AM Treasury Report for January 2023 9. 10:05 AM Finance Report for January 2023 10. 10:25 AM Congressionally Directed Spending -- Discussion of Possible 2023 Requests February 22, 2023 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 3 OTHER ITEMS These can be any items not included on the agenda that the Comrnissicncrs wish to discuss as part of the meeting, pursuant to ORS 192.640. EXECUTIVE SESSION At any time during the meeting, an executive session could be called to address issues relating to ORS 192.660(2)(e), real property negotiations; ORS 192.660(2)(h), litigation; ORS 192.660(2)(d), labor negotiations; ORS 192.660(2)(b), personnel issues; or other executive session categories. Executive sessions are closed to the public; however, with few exceptions and under specific guidelines, are open to the media. ADJOURN February 22, 2023 BOARD OF COUNTY COMMISSIONERS MEETING Page 3 of 3 1300 NW Wal BOARD OF COMMISSIONERS I Street, Bend, Oregon (541) 388-6570 FOR RECORDING STAMP ONLY BOCC MEETING MINUTES 9:00 AM WEDNESDAY February 22, 2023 Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Anthony DeBone, Patti Adair and Phil Chang. Also present were Nick Lelack, County Administrator; Kim Riley, Assistant 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 DeBone called the meeting to order at 9:00 a.m. PLEDGE OF ALLEGIANCE CITIZEN INPUT: Chair DeBone acknowledged the receipt of citizen input emails from Nunzie Gould, Elisa Chang, Jackie Keogh, Denise LaBuda, Beth Jacobi, Mark McConnell and Nate Wyeth; and also from Jaime Eder representing Visit Central Oregon and Visit Bend. CONSENT AGENDA: Before the Board was Consideration of the Consent Agenda. ADAIR: Move Board approval of Consent Agenda CHANG: Second VOTE: ADAIR: Yes CHANG: Yes BOCC MEETING FEBRUARY 22, 2023 PAGE 1 OF 10 DEBONE: Chair votes yes. Motion Carried 1. Consideration of Board Signature on letters reappointing Patti Gentiluomo and Ariel Cowan to the Deschutes County Project Wildfire Steering Committee 2. Consideration of Board Signature on letters reappointing Mary Meier to the Extension/4-H Advisory Council/Budget Committee and thanking Pat Kolling for her service on the Extension/4-H Advisory Council 3. Approval of minutes of the February 10, 2023 Legislative Update meeting 4. Approval of the minutes of the January 18 and 20, 2023 BOCC annual retreat ACTION ITEMS: 5. Document No. 2023-180, a Notice of Intent to Award Contract for the Supply and Delivery of Asphalt Oil for Chip Seal 2023 Cody Smith, County Engineer, said one bid was received in response to the advertisement. Commissioner Adair noted the bid amount is below the engineer's estimate. Commissioner DeBone asked how the oil will be transported. Smith said the company has a facility in Madras and the oil will be delivered by tanker truck. CHANG: Move Chair signature of Document No. 2023-180, a Notice of Intent to Award a contract for the supply and delivery of asphalt oil for the 2023 chip seal project ADAIR: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried 6. Resolution No. 2023-012, declaring a countywide State of Emergency and requesting a State Declaration of Drought Emergency within all of Deschutes County Sergeant Nathan Garibay said this is the fourth year in a row the County is issuing a drought declaration. BOCC MEETING FEBRUARY 22, 2023 PAGE 2 OF 10 Commissioner Chang noted the reservoirs are very low, and the snowpack is currently about average. He asked how the reservoirs would be impacted if snowpack and precipitation remains average. Jeremy Griffin, Deschutes Basin Watermaster, said in that case, 2023 would still be one of the lowest years as far as reservoir levels. This is because flows on the Deschutes River are the lowest natural flows ever seen, due to several years in a row of below -average precipitation. Griffin said it is likely that service to the Arnold Irrigation District will be halted early for the fourth year in a row —in contrast, that had only happened once in the 100 preceding years. Commissioner Chang asked if the amount of precipitation received in snow or rain makes a difference. He also asked about the effect on water supply availability in the summer months. Griffin explained that all of the precipitation goes into the aquifer. When it comes to snow or rain, the county would be better off receiving snow because of the runoff. He added that the natural spring flow at Fall River is the lowest documented in 90 years. Responding to Commissioner Adair, Griffin said because the Deschutes River is spring -fed, it's extremely easy to reliably forecast its flows. This is not the case for the Little Deschutes, IULCJ, I Iuvvever . Commissioner DeBone shared that Crook County issued its drought declaration last month. He spoke to the effects of drought over continued years and said the Wickiup reservoir won't fill the same way it once did. Griffin agreed this is unlikely. Commissioner DeBone referred to the piping projects in Tumalo and other areas and looked forward to the efficiencies and energy savings realized from these investments. Commissioner Adair added that pipes create sediment and corrosion in irrigation systems. Commissioner Chang said COID's Smith Rock project is estimated to save 10,000 AF of water per year. Griffin shared his concern about the drop in groundwater levels of about 1.5 to 2 feet per year. While the basin is continually monitoring these levels and trying to address leakage where it can, the biggest reason for the decline is the reduction of precipitation in the Cascades. BOCC MEETING FEBRUARY 22, 2023 PAGE 3 OF 10 Commissioner Chang summarized that the deep recharge of groundwater happens in the mountains, and commented that the decline in groundwater is variable across the county with the largest declines happening in the northeast. ADAIR: Move approval of Resolution No. 2023-012, declaring a countywide State of Emergency and requesting a State Declaration of Drought Emergency within all of Deschutes County CHANG: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried Commissioner Chang spoke to what the drought declaration does and does not do, noting one benefit is to offer some flexibility and relief for farmers. 7. Resolution 2023-003, accepting grant funds and increasing limited duration FTE and appropriations within the FY22-23 Deschutes County Budget to assist victims of domestic violence and sexual assault Ashley Beatty, Victims' Assistance Program Manager, described the grant sources and how the funds will be used. Budget Manager Dan Emerson recognized the Roundhouse Foundation pledge of matching funds in additionto a grant from United Way and federal funds from the Stop Violence Against Women Act (VAWA). Responding to Commissioner Chang, Beatty said these funds will be used to co - locate a domestic violence victims' advocate halftime in Redmond and halftime in La Pine. This expansion of services will enable the provision of pre -conviction services to victims and offer critical support during investigations as those proceed. ADAIR: Move approval of Resolution 2023-003, accepting grant funds and increasing limited duration FTE and appropriations within the FY22-23 Deschutes County Budget to assist victims of domestic violence and sexual assault CHANG: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried BOCC MEETING FEBRUARY 22, 2023 PAGE 4 OF 10 8. Treasury Report for January 2023 Bill Kuhn, County Treasurer, presented the Treasury Report for January 2023 including a high-level overview of the current economic market. Responding to Commissioner Chang, Kuhn said the County incurs roughly $10 million in operating expenses each month and strives to keep three months' worth of projected operating expenses perpetually on hand. 9. Finance Report for January 2023 Robert Tintle, Chief Financial Officer, presented the Finance Report for January 2023. In response to Commissioner Chang, Tintle agreed if the County were to borrow funds, it would be better to pay interest to itself if that could be managed. Tintle added in the case of a construction bond for a project such as the courthouse expansion, this would depend on how much money could be tied up for 20 years. The Commissioners asked about and received answers to questions about position level changes in Community Development, Administration and Risk Management. 10. Congressionally Directed Spending -- Discussion of Possible 2023 Requests Whitney Hale, Deputy County Administrator referred to an email from the Association of Oregon Counties regarding the process for Congressionally Directed Spending requests, which are due next week. Commissioner Chang noted successful efforts last year to secure $3.09 million for the expansion of the La Pine Community Health Clinic and $700,000 for the Forest Road 4606 alternate route. He said the highest priority need is the extreme shortage of behavioral health treatment beds and respite facilities and reported on a concept developed by St. Charles for support and stabilization opportunities for youth experiencing mental health crises; another concept is an in -patient psychiatric unit with six or eight beds to treat people who are potentially violent. While important, he doubted that these ideas are ready to submit for funding requests and suggested the County consider working towards developing a proposal of this kind for submittal next year. Commissioner Adair reported that all of the County's seven legislators along with Judge Ashby support the $25 million request from the State for the courthouse expansion project. She agreed that it would be beneficial if the Deer Ridge facility was open and actively helping persons with substance use disorder or BOCC MEETING FEBRUARY 22, 2023 PAGE 5 OF 10 mental illness. She expressed concern about the growing federal debt and deficit and said citizens are experiencing the effects of inflation which has made it harder for them to make ends meet. Commissioner Chang said it is not wrong to ask for allocations to fund valuable investments in the community, and CDS is an extremely small portion of the federal budget. Hale offered to reach out to the cities and ask if any CDS requests are planned and return with a summary of those, if any. OTHER ITEMS: • Commissioner Chang suggested that the County sponsor a table at REDI's annual luncheon on March 21 st. Chair DeBone noted the consensus of the Board to approve this sponsorship. • Commissioner Chang reported his efforts to determine if any suitable federally -owned land could be used for partially siting the County's next landfill. He said at least three potential locations have been identified for a possible federal land conveyance for this purpose and added that under the Recreation and Public Purpose Act, requests for up to six hundred acres are much more streamlined than larger requests. Commissioner DeBone supported these efforts and advised involving SWAC and Parametrix in this work. • Commissioner Adair attended a recent FireFree meeting where the Bend Fire Department gave an outstanding presentation on ways to prevent in -home fires. • Commissioner Adair reported on the possibility of including federal court operations in the County's expanded courthouse. • Commissioner DeBone attended the recent City Club meeting where workforce recruiting was discussed; the Sunriver/La Pine Chamber meeting; a meeting of the Redmond Airport Advisory committee; a La Pine High School site committee meeting; the REDI's Government Affairs Committee meeting; and a ribbon -cutting event for the Stepping Stone shelter. • Commissioner DeBone toured the Tumalo Irrigation District canal. • Commissioner DeBone reported on his participation in the Coffee with a Commissioner program in La Pine and said this resulted in great discussions with residents. • Deputy County Administrator Erik Kropp shared a request from Wild Mike's Pizza to extend its Enterprise Zone Agreement, which is due to expire on March 26t", for nine months. Commissioners DeBone and Adair were BOCC MEETING FEBRUARY 22, 2023 PAGE 6 OF 10 supportive of bringing this matter to the Board before it continues to the City of Sisters for action. • County Administrator Nick Lelack spoke to the issue of homelessness and reminded the Board that last fall, it discussed directing a surge of resources to combat this problem in three specific areas: Hunnell Road, the Redmond Airport zone, and County -owned property offered to the State in exchange for a different property (aka the DSL land swap in Redmond). He said staff has been working to coordinate these activities with the cities of Bend and Redmond, with Hunnell Road identified for possible first steps. Deputy County Administrator Erik Kropp described the City of Bend's request to join with the County to coordinate the clearing of encampments on Hunnell Road and the establishment of a separate supportive camp for some persons displaced from that area. Kropp outlined four options for proceeding, as follows: Option 1 - 1. Use City land located in the City or City land located in the County 2. County hire contractor/non-profit using reallocated ARPA funds to provide basic needs (trash collection, porta-potties, maybe water) a. County can require contractor to purchase insurance, name County and City as additional insureds 3. 1-year pilot pr ogr atI I� with options to renew Iew Option 2 - 1. Use County land 2. County hire contractor/non-profit using reallocated ARPA funds (unless no services will be provided) Option 3 - 1. Use private party land under County jurisdiction Option 4 - 1. Decline the City's request 2. Respond to the City about the upcoming County road project in the area of Hunnell Road Cheyenne Purrington, Director of Houseless Strategies and Solutions, said this proposal represents an attempt to break the cycle of shifting cleared encampments from one area to another. She believed the County should provide minimum critical support services to address public health needs as well as access to case management services, and supported an approach that would intervene in a time -limited and funds -limited manner that could BOCC MEETING FEBRUARY 22, 2023 PAGE 7 OF 10 be scaled. She expected to have state and federal funding available to address shelter and housing needs in about nine months, and recommended offering an unsheltered, supported camp in the meantime to reduce morbidity and mortality. Purrington concluded that well over 80% of the homeless population in Deschutes County is unsheltered. In response to Commissioner Chang, Purrington said any funding received as a result of the Governor's initiative will not be able to be used on unsheltered programs. The Commissioners commented on possible benefits and drawbacks of the proposal. Commissioner Adair noted negative effects on businesses and the community in the area of the Hunnell Road encampment and agreed that more affordable housing is needed. Kropp shared that the City of Bend has identified a one -acre City -owned parcel it is willing to offer for a supportive camp. The City has asked for an answer from the County by the end of this month. Commissioner Chang said there is currently no authorized, managed outdoor shelter in all of Deschutes County. He viewed this as an opportunity to offer a camp that is well -managed and has accountability. Responding to Commissioner Chang, Purrington said a one -acre site could accommodate 20 to 25 people. She added that more than one location might be needed since it would be challenging to manage a large encampment. She said the County knows of many engaged providers who could be involved. Commissioner DeBone noted the potential problem of disregarding the County's own land use codes and restrictions, and said campers might not want to move to a managed site. Discussion continued regarding embarking on a pilot project; meeting with the City of Bend; partnering with the State on this proposal; the idea of siting a camp on resource land; the $1.5 million in ARPA funds allocated by the County to the City of Bend to address homelessness; whether the clearing of the Hunnell Road encampment can be delayed for six or nine months; and possibly issuing an emergency order to allow the use rural or EFU land for a supportive camp. Commissioner Adair noted the Hunnell Road encampment has up to 110 persons and wondered if more than 20 to 25 people could be accommodated on a one -acre site. BOCC MEETING FEBRUARY 22, 2023 PAGE 8 OF 10 The Board was in consensus to bring this matter back for further discussion at its Monday meeting. • Strategic Initiatives Manager Jen Patterson distributed a draft letter in support of extending sunsets for the Oregon Enterprise Zone Tax Abatement program. CHANG: Move approval of Board signature of the letter supporting extending sunsets for the Oregon Enterprise Zone Tax Abatement program ADAIR: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried The meeting was recessed at 12:21 pm, and reconvened at 1:00 pm. EXECUTIVE SESSIONS: At 1:00 p.m., the Board went into Executive Session under ORS 192.660 (2) (h) Litigation. rhn �.. -. r•rl m ,n rd ni �f of rnc-c-i nn nf 9 .q 9 n m Fr, f-lin thn fnllntniirsrr -. r•4inn IC UIJQI U 11 IUVcu %JUI V1 cncl.uuvc .7C.7.71V11 Ql I. 1 1 N.I 11. Lk) lQPPC LI IC IlJ11lJVVII IS QLUVl 1. ADAIR: Move Board signature of Document No. 2023-209, a letter authorizing County Counsel Dave Doyle to sign the national opioid settlement documents regarding settlements reached with Teva, Allergan, CVS, Walgreens, and Walmart CHANG: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried At 1:12 p.m., the Board went into Executive Session under ORS 192.660 (2) (e) Real Property. The Board moved out of executive session at 1:16 p.m. with no action taken. ADJOURN: Being no further items to come before the Board, the meeting was adjourned at 1:16 p.m. 7.1 DATED this 401Day of d 2023 for the Deschutes County Board of Commissioners. BOCC MEETING FEBRUARY 22, 2023 PAGE 9 OF 10 ATTEST: '�er�wAc�'�fy,r(ct RECORDING SECRETARY BOCC MEETING ANTHONY DEBONE, CHAIR PATTI ADAIR, VICE CHAIR PHIL CHANG, COMMISSIONER FEBRUARY 22, 2023 PAGE 10 OF 10 Angie Powers From: nunzie@pacifier.com Sent: Tuesday, February 21, 2023 11:59 AM To: citizeninput Subject: drought declaration item 6 2-22-2023 [EXTERNAL EMAIL] Hello Commissioners Public comment re item 6 BOCC 2-22-2023 Drought Declaration The waters of Oregon belong to us all. As such I would like to identify that this drought declaration needs improvements specifically to provide our ODFW and USFW agencies oversight to their mandates and to grant OWRD proper stewarding of our public water in their full water rights review. Please replace Section 4 of your draft declaration to read: Section 4: Request: The Honorable Tina Kotek, Governor of Oregon, declare a Drought Emergency for all of Deschutes County under the provisions of ORS Chapter 401 due to severe and continuing drought conditions beginning at this time and continuing to December 31, 2023; direct the Oregon Department of Water Resources to allow Temporary Transfers of Irrigation District Agricultural Water Rights within Deschutes County to North Unit Irrigation District and request federal and state drought assistance for farmer in Deschutes County as needed." Thank you Nunzie Gould 1 Angie Powers From: Elisa Cheng <elisac@bendbikes.org> Sent Monday, February 13, 2023 7:10 PM To: citizeninput Subject Workforce Housing Proposal [EXTERNAL EMAIL] Deschutes County Commissioners, This comment pertains to item # 1 1 Workforce Housing Proposal on your agenda. I urge you to move forward with creating a Housing Trust Fund from the unallocated Transient Room Tax revenues. Deschutes County is in dire need of affordable housing. Creating communities where everyone can afford to live is critical to the health of our county. Thank you, Elisa Cheng President Pronouns: she/her/hers BEND BIKES Advocating for the safety of people who ride bikes Angie Powers From: Sent: To: Cc: Subject: Attachments: [EXTERNAL EMAIL] Hello, Jackie Keogh <jackie@korlandtrust.org> Monday, February 13, 2023 8:09 PM citizeninput Phil Chang Public Testimony 2/15: TRT Proposal Commentary TRT LOS.pdf As the Executive Director of Kor Community Land Trust, I respectfully submit the attached written testimony in support of the TRT Policy Proposal set to be discussed at the 2/15 Deschutes County Commissioner meeting. Thank you, Jackie Jackie Keogh (she/her/hers) Executive Director Kor Community Land Trust korlandtrust.orq (541) 247-1244 Book a meeting with me In partnership, ~Jackie Keogh, February 13, 2023 Deschutes County Commissioners Deschutes Services Building 1300 NW Wall Street, 2nd Floor' Bend, OR 97703 RE: Deschutes County Housing Trust Fund Policy Proposal Dear Whom It May Concern, As the Executive Director or Kor Community Land Trust, I seek to provide written testimony in regards to the Deschutes County Housing Trust Fund Policy Proposal. Kor Community Land Trust is committed to providing workforce housing solutions for Deschutes County by developing deed -restricted affordable homeownership communities, with preference given to our local workforce through employer partnerships. Kor supports other efforts that advance funding and developers' commitment in developing workforce housing solutions. The Deschutes County Housing Trust Fund Policy Proposal is a step in the right direction to create government supported but community led housing for our workforce. The collective impact of housing our workforce will better support our local economy and stability of our growing County. As a developer of workforce housing, Kor Community Land Trust works to balance cost to build with what homeowners can afford for a mortgage. Based on Kor's pricing methodology, which takes into account Area Median Income and interest rate fluctuation, a household of three at 120% AMI can afford a home averaging $450,000. An investment of $30,000 in workforce housing is a step in the right direction that would still require additional private and public investment to ensure developers build workforce housing in our community. Typical federal, state, and city funds limit household income at 80% AMI, which deters housing development for workforce housing: For example, Kor has 40 units being developed at 19755 Simpson Ave that would be able to serve households earning as much as 120% AMI, but the current public_ funding limitations will likely limit the income cap to 80% AMI. In short, while this program is a step in the right direction, it needs to be supplemented with policy change across the public sector to realize a broader impact. The proposed program requirements of the Deschutes County Housing Trust Fund Policy are well thought out in both their simplicity and functionality. As a non-profit organization serving the community, Kor would also advocate for a community steering committee or other oversight to evaluate housing development projects that seek to use these proposed funds. This will ensure long-term success of what could be a strong pilot fund that creates more workforce housing in Deschutes County. In partnership, Jackie Keogh, Executive Director Kor Community Land Trust Angie Powers From: denise labuda <dmlabuda@gmail.com> Sent: Tuesday, February 14, 2023 2:01 PM To: citizeninput Subject: Workforce Housing Proposal Sortie people who received this message don't often get email from dmlabuda@gmail.com. Learn why this is important [EXTERNAL EMAIL] Dear County Commissioners I am writing today to express my support for a new proposal to establish a Housing Trust Fund to provide 66 workforce homes per year, partially funded by unallocated Transient Room Tax (TRT) revenues. It is my. understanding that the homes would remain affordable to qualified employees for 30 years by deed restriction and that the preliminary budget impact would be $2 million from unallocated TRT Revenues. We need this type of housing in our communities n Deschutes County. Please say yes! Cheers, Denise LaBuda Bend resident and homeowner "As you grow older, you will discover that you have two hands one for helping yourself, the other for helping others."— Audrey Hepburn Angie Powers. From: Sent: Cc: Subject: Attachments: Nick Lelack Tuesday, February 14, 2023 9:41 AM Brenda Fritsvold; Angie Powers; Julia Theisen; Jaime Eder; Robert Tintle FW: Letter of support for 2/15 BOC meeting BOC - workforce housing letter of support 2.15.23.pdf Commissioners: Please see below and attached. I have seen a number of similar comments on this matter sent to the Board via email. Nick Lelack, AICP I County Administrator (He/Him) DESCHUTES COUNTY ADMINISTRATION Tel: (541) 388-6565 Mobile: (541) 640-6911 From: Jaime Eder <jaime@visitcentraloregon.com> Sent: Tuesday, February 14, 2023 9:37 AM To: Nick Lelack <Nick.Lelack@deschutes.org> Cc: Julia Theisen <julia@visitcentraloregon.com> Subject: Letter of support for 2/15 BOC meeting [EXTERNAL EMAIL] Hi Nick, Visit Central Oregon and Visit Bend would like to submit a letter of support (attached) for the workforce housing proposal that is on the agenda for tomorrow's BOC meeting. I see on the website that the citizen input email is for comments for items not on the current agenda, so I wasn't sure the best route to take. Are you able to help get the attached letter submitted to be included in the meeting record? Appreciate any help you can provide. Best, Jaime Jaime Eder 1 Director, Workforce Development and Community Engagement She/Her Visit Central Oregon Visit Bend 425-268-5479 (mobile) CENTRAL OREGON VISIT BEND 1 VISIT BEND February 15, 2023 Deschutes County Board of Commissioners 1300 NW Wall Street, 2nd Floor Bend OR 97703 Commissioners Chang, Debone and Adair: CENTRAL E On behalf of Visit Central Oregon and Visit Bend, it is our pleasure to voice support of a proposal to use unrestricted transient room tax (TRT) funds to support workforce housing. In August 2022, Visit Central Oregon and Visit Bend became the state's first destination management organizations to collaborate on a shared position that focuses on workforce development. The intention of the Director of Workforce Development and Community Engagement role was largely to develop short and Tong -term strategies to support Central Oregon's tourism and hospitality staff. In the seven months since the role's inception, there have been as many conversations as possible with regional stakeholders to learn more about their challenges in attracting and retaining workforce. Resoundingly, without fail, the first answer? Lack of affordable and/or workforce housing. Visit Central Oregon and Visit Bend are prohibited by state law to use the restricted TRT that funds them on anything other than tourism promotion and tourism related facilities. We can be part of the conversation, have seats at the table, and even devise possible solutions that support our region's housing needs — but ultimately are unable to provide financial support. However, unrestricted TRT is a resource that has much more flexibility. It has been encouraging to see the momentum of local organizations — as well as city and county governments — coming together to help envision ways to support Central Oregon's housing crisis. We are excited to hear that the Board of Commissioners is engaged in conversations that present strategic solutions to continue supporting this area of need. Thank you for your consideration. Please let us know if we can be of further assistance. Sincerely, Julia Theisen President/CEO Kevney Dugan President/CEO cJ<P- Jaime Eder Director of Workforce Development Angie Powers From: Beth Jacobi <beth.a Jacobi@gmail.com> Sent Tuesday; February 14, 2023 9:40 PM Tor citizeninput Subject: Item #11„Workforce Housing Proposal Some people who received this message don't often get email from beth.a jacobi@gmail,com. Learn why this is important [EXTERNAL EMAIL] To Commissioners Adair, Chang, and DeBone, Thank you for the work you have done to support the creation of housing that is affordable to local workers and families. I encourage you to support the Workforce Housing Proposal presented by Cheri Helt. By utilizing $2 million of Transient Room Tax revenue to provide grants of $30,000 per unit for deed restricted workforce housing, many local workers who earn between 80 and 120% of Area Median Income could have the opportunity to own their own homes: With a housing market that is influenced more by outside wealth instead of local incomes, many of our key community members have been displaced or locked out of owning a home. Public investments are needed to ensure that community members who depend on local wages are able to gain the stability and dignity that comes through homeownership, These local dollars will also help leverage state, federal and private funding. These investments will contribute to making our communities stronger for generations to come: Thank you for your consideration and for your service. Sincerely, Beth Jacobi 541-350-7945 Tumalo, OR Angie Powers From: Sent: To: Subject: Board of Commissioners, McConnell <mcconn@bendbroadband.com> Tuesday, February 14, 2023 4:34 PM citizeninput Agenda Item #11- Workforce Housing Proposal I am writing in support of the Workforce Housing Proposal on your agenda this week. Providing grants of $30,000 per unit to build deed restricted workforce housing for purchase, and made available to local workers at lower incomes is a good way to ensure long term solutions to the housing crisis. Deed restrictions are the key to keeping the housing accessible to the workforce. There is also a long term benefit to the County since the taxes on these homes will be collected year after year. Thanks for your consideration. Mark McConnell Sunriver, Oregon ************************************** Mark and Cindy McConnell. 18160 Cottonwood Road #132 Sunriver, OR 97707 mcconnAbendbroadband.com Mark : 541-270-1313 Cindy: 541-270-9784 #3 Tamarack Lane ************************************* Angie Powers From: Sent: To: Subject: Nate Wyeth <natewyeth@gmail.com> Wednesday, February 15, 2023 11:48 AM citizeninput Workforce Housing Proposal Support Some people who received this message don't often get email from natewyeth@gmail.com. Learn why this is important [EXTERNAL EMAIL] God morning, County Commissioners, I'm a Deschutes County resident who is passionate about finding solutions to our housing crisis. I have spent the past decade working within the hospitality industry. I like many others, was recently priced out of the housing market in Bend where I work and now have to commute to work daily a nearly 70 mile roundtrip commute. While I recognize my privilege of being able to afford this burden, the average wage of folks in the hospitality industry often means that those living in outlying bedroom communities see nearly half of their wages going to commuting costs, or find creative solutions in order to remain living nearby their place of employment. I'm here to voice my support of the workforce housing proposal before the Deschutes County Board of Commissioners. As you know, the county receives the lions share of room tax generated by visitors to our region, which last year totaled nearly thirteen million dollars. While I understand the the workforce stretches far beyond the hospitality industry, it only snakes sense that a portion of this money,_ generated through our hospitality industry, is reinvested to support workers within the industry which provides over one billion dollars of economic impact in Central Oregon. I encourage the Board to use its unrestricted dollars from the county's portion of the transient room tax to create real solutions to the problem of workforce housing in our county. I urge the Board to think creatively and take bold action to ensure that our county can provide safe and affordable housing for our workforce. Thank you. Nate Wyeth (he/him/his) **Please note: I recognize that each of us work in different ways, and I want to respect your time. While I have sent this email in a time that works for me, I do not expect that you will read, respond, or take action on this outside your normal work hours. BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: February 22, 2023 SUBJECT: Treasury Report for January 2023 ATTENDANCE: Bill Kuhn, County Treasurer DATE: TO: FROM: SUBJECT: February 8, 2023 Board of County Commissioners Bill Kuhn, Treasurer Treasury Report for January 2023 MEMORANDUM Following is the unaudited monthly treasury report for fiscal year to date (YTD) as of January 31, 2023. Treasury and Investments • The portfolio balance at the end of January was $318.3 million, a decrease of $10 million from December and an increase of $32.5 million from last year (January 2022). • Net investment income for January was $561,437 approximately $2K more than last month and $431K more than January 2022. YTD earnings of $2,547,178 are $1.6 million more than the YTD earnings last year. • All portfolio category balances are within policy limits. • The LGIP interest rate increased from 3.10% to 3.35% on 1/6 and from 3.35% to 3.75% on 1/27. Benchmark returns for 24-month treasuries are down from the prior month by 20 basis points and 36-month treasuries are down from the prior month by 32 basis points. • Average portfolio yield is 2.23% which is higher than the prior month's average of 2.13%. The portfolio weighted average time to maturity is 134 years compared to 137 in December. Portfolio Breakdown: Par Val to i nvestment Type Municipal Debt Corporate Notes Time Certificates U.S. Treasuries Federal Agencies LGIP First Interstate Bank Total Investments $ 47,965,000 48,321,000 1,245,000 72,000,000 114,965,000 21,864,349 11,912,924 S 318,273,273 15.1% 15.2% 0.4% 22.6% 36.1% 6.9% 3.7% 100.0% Total Portfolio: By Investment Type First Interstate Bank 3.7% Municipal Debt 15.1% $100 N $80 g $60 $40 $20 $- Portfolio by Broker $32.4 $11.5 DA Robert W Davidson Baird & Co $48.4 $49.0 $49.7 Piper Sandler Moreton Capital Markets $93.4 Great Castle Oak Pacific Securities nvestmentIn Total Investment Income Less Fee: $5,000 per month Investment Income - Net Prior Year Comparison Jan-23 $ 566,437 (5,000) $ 561,437 S 2,547,178 Y-T-D Jan-22 $ 130,216 2,582,178 (35,000) 917,190 Category Maximums• U.S. Treasuries LGIP ($56,763,000) Federal Agencies Bankers Acceptances Time Certificates Municipal Debt Corporate Debt 100% 100% 100% 25% 50% 25% 25% Maturity {Years) Max Weighted Average 3.79 1.34 Yield Percentages FIB/ LGIP Investments Average Current Month 3.75% 1.77% 2.23% Prior Month 3.10% 1.77% 2.13% nchmarks 24 Month Treasury LGIP Rate 36 Month Treasury 4.21% 3.75% 3.90% Term Minimum Actual 0 to 30 Days Under 1 Year Under 5 Years 10% 25% 100% 12.8% 39.7% 100.0% Policy tual Corp Issuer Callable Credit W/A 5% 25% AA2 3.1% 16.8% AA1 Invest rent Activity Purchases in Month Sales/Redemptions in Month $ $ 9,051,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% 400,000,000 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 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan County Rate 2 Year Treasury Rate Corporate Bond Rate LGIP Rate Three Year Portfolio Balance '19 19 ;19 y0 '10 -19 1> 1> 't'v .y'> yy 1> yL `1'L �ti �L `0' `1'1' 03 `Sad \ yeQ °, •ac lac aa �J\ 2 \_\0 lac 4,1 2, • yeQ o, lac 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 Five Year Maturity Distribution Schedule Jan-23 May-23 Sep-23 Jan-24 May-24 Sep-24 Jan-25 May-25 Sep-25 Jan-26 May-26 Sep-26 Jan-27 N O (O LC) r- ,r 0 r C) up r- (O O. 6). O) O (O 6 0 O N-.0 M v-: CO CJ CD N CO O CO NT CO CO'. 40 (O 0 CD CD M O O 0) (O M (V O V' O O 0t. 0 O (O CO CD O M CO r. (C) <c) O O a0 N CO N d'rn O CO O O O (O. C (O CV CD 6) CD 0) OM d' d' (O CO CO O O O O O N (O CO CD (O O N O r, 0) N O d' 6) CO 0 6) 0 (f) CD 0) CO CD07 d' . (D CD CV (4 CV (4) CD 0-0 N NCO 4) V) 6) ([) CD(O CD CD '0 CD CD 4) O CD CO CD 0 (f) CO 00 CD CD. N- CD CD CO' 0) CD CD. M N 0 r co CD 0) (b O CO O) N- CO 0 N.,.. r O 00 co co (O n 0 0 d N. ' d CD v-O ,r:.0 03 0) 0 CO(O 6) co(O O N- 0 co (0 O co 0 rn o0 (O O 6) 6 N O rn 6) rn rn rn 00 W CO . CD CD CD OD r- CDP....: CO CDN. r OD6) CO CO 0 rn' n CO CO N O O CD OD CD CD NT 0) rn r- CD CD CD VD 4) 4) N N 00 Nr N. CA rn 0) 00 OD CV rn a, al v O CD cn CD O CD a> ,- N.CO.•- rn rn c) o O) rn.(n CD CD O N.CD CD N O CD 0) CD CD CD OD 0) N CD CO CD al al a) O.O O:(D rn .-: NI,- .- N N.'-.. N N a r CO- Cv '»' d' a- N .-.. N.. N: '.. N N �V v-. - N N ('-1 ,- N N:� - O d' d' (O (n O M 0- rn N 0) NT 'V CO CO:40 M CD NT 00 CO O COCOO I- r (D r c. 0) 00 (O '00 CO OD 6) °) 0) 0 00 CO CO 0) CO 0) rn 0) rn N 0) 0) 0) O CO 0) 0 M (0 (0 0) N n O (O CNN. M rn N- CO N- CD 0 rn 0) V N 0 Cl � ': rn (O 0- Nt ('4 rn:0 (0 04N (0 CD, - CO :n UO CON-O)O N- rn:rnONCO CO_rn O':rn M 0) CO 0 (O 0) rn(nrnr- (n CD N f O CO N. N- CD:10 rn r (O 0 0) 0) 0) rn CD 4) rn 0). OD d' d' CO 0) O O O 0 :O O O O 0 0 0 0 O O O O O O O :. 0 0 0 0 O O O O O O O O O 0 :O O O O 0 0 O O O :.0 0 0 O '.O 0 0 0 0 O O 0 0 0 0 0 0 O O O O O 0 0 O O O O O 0 0 0 0 0'O O O. OO O 0 0 0 O: O. O O O O O O CD CD CD O:O CD O'. CD CD O O O O:O O O 0: 0 0 0 0 0 0 O' O O 10 6O O O O.O O O O O O O O O CD CD O O O 0 ,. 0 O O .O O O CD CD O O O 00 :N O O O 'O O O O :O CD CD O O O:O O O 0 O'. N. O O. O: (O 0 O O:O CD CD O O N: CO r- 0 0 0 O O 0 (n. O O:. O (O LC) CD CD r-:. N CVCO.: N':v- 0.N. N N NI- NI- N M NI r c N N f- ':N V. U) V. (Nj N N CO:((O N CO MO N NCO d'',M CO a- CO CO N Nam :. .- LC) CT) 4) (0 0)'. N N .- N (O CO d' N': (0 : 0- (O r (D N 0 (O (0 n 04 10 N O) N 0) .- (O (0 (0 CD 10 CO (O CD CO 00 CD(O CO '.0 CO (0 CO 00 CO 00 OD CO CD (0 CO 0)'. rn O N v- O rn CO (O CO CO d' d' O O CO O CO O 0 NT CO d' C (0 :M (0 (O N..M r O. N. OD O N. CO N:N CD CO 0)'. d' O N CD r- co W:.M co r (D O .-:.O d' � 0( M C d' O O d' O O O M N M O) N 0) (O (O CO (O N- (O N (O (O N- (0:W N- (O co N-: (O O) (D N, 4- CV N- co N 0) N N N- N 0 CO. N CD rn N.N.N N.r- N M.CO O ° 0 0 (D W.N a- 7' M' co (O CD (O CO N (0 CO 0)) CO CV CO N. 6) CO 0) 0CO. r d' d' M V M W N- r- N 41 0O (O O N 000 () -r- M 0 0 0 O V: CD (O ,- CO (O CO 0) 0 0 N : C) (O - O :d' N CV (D :(D d' 6 O O CD CD 00 O 00 (O NT (O . (O N d' CCV CCV O M M ) d' CO (O N. d' CV O N O'. CO CV N N, N O:N O N':N (O CD (O O rn rn 0) d" N (0 10 NT CO 0) CO) N CD0 rn rn 0) 0) CO '.rn N 0)'. CO O O (0 O d' N'n N (O r- d' 'O °). Co CDM M (0 : d' a)f-d':0 (n d' (D 0- d' O 0- (O.(b O) N O N (O N 0) (0 CO 0) 0 rn rn rn:rn rn rn rn rn.� rn 0 0 CD CD O O O O O O O'. O O O O'. 0 O O. O: O O O 0 00 O: O O O O:: O Co O': 0 000. 0 O O. O O O O 0 0 0 O: O O O O' O O O O O O 0: 0 0 0 O O: O O O O 0 '. 0 0 0 O .O O d o' O O O .O 0 0 0: 0 0: 0 O 0 0 0 O: O O O O' O n O d' 0 0 O' O O CD 'O O O N 0 O O: O O O 00 N O: CO 000. 00 CD O. O COO N N:N'N N N (O N N N N N:N N N:0 ,- N r- (O O) 00 (0 (O (O M'. N. d' CO (D d' N N- CO V' r (O W CO (0 Cr U) O 0) CDCO CO CO 0) 0 CDO. CO(O 0 CO O CO : (O (O r : CO (O CO 1` d' 100)40 N CO '.O (O (O 00 CD N.(0 r:d' CD coa0N-0 .00N CNN CD CD 0, CD NT CO CD CD (O CD .I- d' O' co 00.0'N O N N- rn CO (0: r- N CO' CV (O O: CT,N CV 40 r N CD r- (O CO d' W ,t N N M 0 Imo ': N- N (O O:(O rn (O:rn co N O O M O V:O O 0'd' O CD CO d' CD CD 0:0 O N 0) (O N (O (O (O O N CV N. r O V O d''V 0 (0:(O .- r. to N (O : V) N N O N- N N N- O O M 0 ...7 '. ° o. (O l0.LC) (OCO (O (O N f-.1-V 'CO N (V MO aOO M. d CO (O N (6 N N CO CO CO CO CO CO CO CO CO N CO N CO N N N CO CO N CO N CO CO' CO CO 0 : N N CO (O CO CO CO CO (O CO CO CO CO CO N CO CO as as as aaa aaa aaaa'a aaaaaa a as a aa' a N- . M )0 00 CO CO , CO 0) O O 0- 0 (O 0) O d' M 0 d' M M 0 CD N N. CO (O CO O r CO M N 00 CO CO CO O N- (O V . NT 0 (O CO f- CO CO CD � r.'- N N M C) d' d' (7:U7 (D (O.0 f- Ns CD CD N'N CO 0 V: (O (0 r- a, O O (O CO CO (0 T:N NN NN N NN N N N.N: N N M (0 MO0M 00M CO M CO M(0 CO M (0 (0 M (000 C0 MM M M M M MM N N N :N N N N N N N :N N N N N N N .N N N 0 0 O .O O O O 0 0 0 :O 0 0 0 :O 0 0 0 O :O SV 04 CV SV CV CV CV CV CV CV CV CV CV CV co M 0:.- MO(Or 6.66 MZ3 (O:(n0 Na-N N ':M N N M d. ` MM 4 Tr M M O O(0(0 N CV CV N N �'CD N 00 W lv r 6 N N N 0 10 7 A 7 d O m N: CV CV N (44 CV CV c- �:N:� O O CV CA O :O O:CA O O O O O .O N N N N N CV N N N. 04CV CO CO a'a(0< U'0LU 0» 0 z"..., C 0 N b C c. ° U 2 Ucl, U E==>IQ==='- = (O N 0 N (/) N 0 N G N LL d d d.W d 4-)(0 Li- NCO CO NN (n(O :.F (n(n(O 3 OC( dCYaMZH rCO 0U''..J Ocr z 0) co~0 .. o 0) co=co}. Y Y '. cc. 'I. 0 ((0 N. I,-CO(0':. � N. r °f`) CCOO .M-'I CON M N N N.CD N N N.M ON (O CO (aLa 01 CD CD,d 00lv O OZ O al-'�<Q N- r 0) CO CO CD CO 00'.000 0 0 U 0 CC a (L �I— N '- O!d' 0)C) (0 C 0) 0000 Z (/) < (/) aU 002010 N N 0 0 N N z m E. C O Y'' U m v N 0 a E ZL o =0 0 W N rn@o p '0-d°m 7 d IT.'lJL NX.LL1J(.9 U=Z0 N (O W.0 COCOM (NO CO '.CO rn d (0 0 U U O a1,a CO O) i- 'W 00 CO:0 ) CO CD o 0 CD 0 Mco M M M M M M:M M MMM M M M M M.M.M',0 MM MGM M d' V. Tr d' N N N N CV N N (V N N N N N N N N :N N N N :N N N N N N N .N N N O 00 O O'.O O O 00 O 0:0 0 00 00 O 0:0 0 0.00 O OO'O 0 O.�-.(� V 0 V V d' 6 (O (00 N606: CO d' iE (DN ^ .- �-- .N N N N rn 6 r N NM 5r- N M N N NN N MM M 0 0 6) O) O) 0 O) O O 0 W W It CO o_0 U a' F:J .23 Q'2 >- W a WIQ2 W CO Z Q O jN ANY W U O J E z>ct 0<z pis 000� N Z ❑ X 0 (0 co .4- W r t` co co CD M CO 000 '- 0) CO 2':2) CO M CO0 CO N- 0 0 10839 MUN a Q Q Q Q CO : r- CO CO N CO CII CO CO a a a a a (O 0) CO N- O CO (O N. CO O) M M M M M V V V V d' N N N N N O O O O O ,-.N O COCO N N CV N N N 0) CV CV ('4 :O N CD N c-'. CD CD(V. :N N N.O CD CD (V N N N N N N 0 N N N :N N N .N N N N :N N N .N N :N :N N N N N N: N N N :0 :N N N o O O O :.O O 0 0 :0 0 0 O 'O O O O .O O O O :O O .O O O O OO O O O :O 0 0 N N CV N :N N N N N N N .N N N .N N N CV CV N N N N N N N :N N N CV CV N N 0 r- 6) (O : 0) -4 M 6) W: (0 O O) �:0 r M. ((0 d' N .-:0 0 N O N O N r. f-: 6 (O M. 0 0) (0 N N: N 6 N 6 N 0 co N N N O: N ' \ ( . N N co N. N C N N r- 0 rNO 0 f�'.O N CD -60 T- a - MT- 0:0� r- CV W W CO 0 U N' N Y C CO Em Q,c 43 0 d 0» E N >Im ~ c m Ili (O co z 0 z O N U,CD < CO N M' rn N M a O U U.0 C9 O U.a a U a 3133EMS37 N QQ^ r N Q w a W a m J m N W W M W co N a c0:0) CO (O N-IM M 0 N. C0 O MM N M O O CD COM OCOCOCOM a CC z':'a a K'.0 0 U a...OLL z:..a W f �:.LL u_ F- LL LL'a LL M (0 CD DN 6). CO CO N. O)': O). CO M CO 0) O O,-rn c-O CO CO co (O CD CO r CD OD (0 N. CO CO N-'rn N-: 0) o O O. 0 O 0,0 O O CD CD CD CD ce 1 CO co al co 5,P-gc2 O at CO M 10843 MUN 10780' MUN OL CO 0 -J W OD et et CY) co O 2 d Y ct E 0 a> (O (0 222 } c a m o U' o co F p T io:C d s 0 m r.) M V cC [V N N (V 0 0 O 0 (\ N N <0 0 (0 cd :h r M M cr '0 (V D. :V N O N.. N O Ncj O V� N N N' 0 N N N N 0 V , V r 00 CO O V 0) (0 CO- r M O (0 CC O CO V 0 0 0 O 0) 0 CO CO O C O O "T O (0 6: 00 O) c0 O O V O 0 a 0- (0. M O CO M N DO N 0 6 r'r O CO O CO CO M N (0 M (O (0 CO (0 r O Ma, O N N O N 0< 0. 0 .0 0 (0 O CP 0- 0 CD 0 O -^ O r 0 CO (0 O 0 M CD (V O N .0 c CD O V 6 CO CO 10 O O (0 r O N O: C' O. W Ovr V' M CD V (0 (0 C N (O (0 e- CD 0 V' CO O. 0 0 0 M 0 ( r: 0 0 CD CD O. O ch CD C) r CD 0) 0 CJ V' 6 0) O 0) ( N CCO O. CO 0) 0- (0 V O 6 CD. COO (- 0. 0 N00 . • C) : c4 N CO r CV CD O. r (O (0 O .O ('- 0) 0 0 0 0 (D O .O 6 .6 O 0) CD CO CO <U V N CO U) O) CA - V <0 O N. O 4) 6 O CO c0 0) . r O O O O O O O 6 6 6v 0 O CO r.O O O V) V' V' co O'. O O O'. O C 0) O O) O CO 6 V' O V' V' V' O r O N V' V'. cD V CV O 6 r CO 0) 0 6 0) 6 (D (0 0 V CO r O CO CD 0) CO 6 6 :6). 0) 0 6 O.cr 6 tOV) 6 6 6 O'(0.M a) CD 6 V' N CD W.(A0 CD N CV CD 6 0'.r. (0 (V N N .J 0.0 CO.0 O O CV CD 0 CO OD0):O I,0 OD CO CD CD CD O'.0 O',V N N - 04 - N N (-.N .- (-.M �-.. �,M y- N `-',N N N 01 CV 000 cf. vr 00 0 06 0) N0 0 C c 0) � 6 V CO M V M 6 V CO N (0 V' CO 0 6 6 0) M N 6 (0 (O N N (0 : N c0 00 0 (0 CO O N O C0 <0 6 M V' CO 6 (O (0 O N V' O 0-- CO 6 V' O cD co O (0 (0 M..r r OD.r V' N'O N. (D M N N <V CC) CD CO <0 ch CO (0 CO CV Ch CV CD 6 V' T: O M 0) 0 O.c0 • O CO'. V - N CO O (0 M N r N'r ((> 6 CO om: 0) (O T- (-(0 (0 (0 v-. 6. 0 CO r CO N (0 6 0'. 00 r'.6 O 6 c 0 (0 l0 10 (0 6 (0 r (0 r O M (O (0 V' co co 6 c0 V' r 0): V co V' co 0 co 6 O r N V .4.V co r 00 (O (C> 6 (O N 0)(0 0O V ('00-' M M 0) N r M 6 CO (O C) M <O N: N M 0 0 N 6 V 6 (0 V' 6 O) 6 0) V 04 CO 6 r (0 V '. 6 r 0) N CO N N :. 6 6 V , r V H (- N N 6 6_ N. 6 CO 0. N 6 6 • (-,�- N O CD CD O. O OO O O 00 O O''. O O'. 0 0 0 0 0 0 O c) O co co .O O O O 0 .0 0 O O. O O O 60 0 0 OO 0 0. 0 0 0 O. CO 0 0 CD CD O 0000 O. M O (0 (00 N N:. N:N N N- O O O O O O 0 O O CD CD 0 0 0 0 0 0 0 0 0 0 O 0 O O O .O O O '.0 0 0 0.0 0 0 O 'O O O .O 0 0 CD CD O O O O 'O 0 ,.0 0 0 O .0 0 0 O. O' O O O O :O O 0 ..0 0 000000000000 (00. 606600 (0 (() O O O CD CD O (0: 0 0 6 CD a, 0 O V O V' (0 O O O (!) O 0 O O (0 M 0- 0 0 V' (0 O 00 O N O N N'O O 0 N. (0 r N' co N:r 6M CO (0 C0 6. CO C) O 0)r O CO 6 C0 r 0 O.M r N.N 04 0) N (D O (0 � (O (O N r 0-CO r N r 6 M N (0 O O (0 CO 6 0 r00 400. 6(00000- CS) CD 6 N O 6 V 0 0) N CO r M r 00'N r 4 r. M O 6 M (O r 6. CC, CO 0 (O V' . V' M M O. O V O O V 4 06 O l0 U) (0 (0 (0 V (0 (0 (0 CO0 C0 (0 (O.M r N N (0 04 O M �,..o N N (c j.. (O V O O M N O O'..M 00 6 CO N V V' CO 1 ) V CO 0) (0 y- (0 (0 N (0 (0 (0 (0 M r CO CO (0 4) M 40 (0 CO N. 0 CO N r 0 N M W M M 10 6 0 0 0 0 N 10 r CO O O N O O O O M M O r al 0 M CO0 N V 0 (0 N 0 M O CO N M V,W ch 0'r (0 r co 00(O N' 4.(- M O O 4 (0 (O O (O (O CO (O cr: CO CO V 6 O. 000000000 .0 V O'.O CO N N (0 (0 0) CO CO N N (0 >- (0 (0 V (0 CO r CO. r (0 r (0'.<D CO V 00)0) O Nr Mr O co OD 0 O 00 CD UP O OO O O.O �O '.N (CO 0 CO CO N CO @ N CO N @ < QQQQ QQ QQQQ • 00 00 V' (() (() 6 (0 r �.6 0) 10 0) 0 O O CD CD N N N'N M (0 CO CD CO 0 6 0 O V' V V' V' V' V c0 : V N N N N N N N N C] O:O O 0 O. CD CD N0) N N N N. N N (D CO (- (-. t0 • N M 0 <CO CO CO CO CO <aa<< 00000,4)00 0 0 0 0 0' (- M (O (0 (O (0 (0 (O N (D N N N N N N N N N N N O p o 0.0.0 O 0.o CD N N N N N N N N'.N N N (0 V (n 40 (n (D (0 (0 N N N N N(0 CV N CA (- N N N ('4 O CD CD CD CD N N N N N N .N N N N N N N N N N N N N O :.O .O O O O :O O O .O O O O O O O 0 .0 O N CV N N N.N N CV N N NN NN N CV CV N • CO 0 OD W N (O o CV O o o (00 ' co 'o r 0- 6co CA <- N Nv 9 CO CV CV O N M.<- 0 Y (0 CO a CO CO D.. m a�i U J J @ O 0 () Z Z` t 2(i m y t 2 2' 2• u) O g N O N E@ N m U N 0 y E Q _���0og�gm���o8 I-F �F- D> . 0 pl-I H y U "O co u)'o0 c: Eu) a)2 ui ui0 cg (i 2'2 u.''.0 m 0 0 0- 00 0 m U 0) a • w n0• a<'co0 a00U'a2 DC 2000a_a QOQa0u,Q O CO H (- CO N N c0 6 (0 090U J W 0N HU.U (7.0- 0 Sco < 0 N'N O N r N 0 (O,N OO CO0 MON CO N N0 M .N 'CO N CO (O.N (O CO H CO CO CO 0) 0) CO 6 CD CO 6 CO V''.6 U Ua or.0 U U cc a or V z.0 C0 or • CO O O (0: N N O 0 '. 0 C 6 00 ! CO 0 CD CD CD CD CD Co CD CD 0 10 0 COQD O 4- F- 6 O 00 0 0 n0 0 I C.)U <n l0 CO <p - 6 (- V W (0 0 0 <> c 0,c U W W'.(<) 0 H.6 (n.c00LO N N 0 0 6 (O (0 CO '.O r 0 N....M CO a)a)0� CD'.r LC) 10 V V (0 (0 N N N N O O O 0 N'N N N Lo 0 0 (n C") M < Q (MO LC) ((0 O O O N N N ,- N N ('rr N .- O O'O O O O'. 0 0 0 O O O O O O 0 0 0 O O O O O CD CD CD CD 0.6 6 6 O: O' O O.O O O V' V' O O CO O (0 N N N N O O.r 0 6 N.� CO 66 CO CO V 0) 7 (0 V N (0 r W 6M) W O O O O CD CD O CD CD 0 O. O O O O O O O .O O O O O O O O. O O O N O O O 0 O O N 0 0 0 O O N N N',N (0 (0 (0 0)'0 (X). CO CO 0) CDC 6 6 r.<- N r r (0 N M(O 0 0 0 cD: r.M N CD CD Up O C:0 V' r CO CO V' M N CO.(0 O r CO OD CO 00 6 M 6.V 0 r N O N (0 (0 p 00 '7 V' M r 0 V M CO (0 CD V' 6 N - (0 6 CO <-0CD al N r CO MN O(-CO M (00)0 <-6066 (- NM CO CD CD CO V' M CD (0 CD up V' (0 O.N (O (0 CV O N N. 6 W CD r.N M O (O (0 (0 N ,-4 N (0 .4-' (0 :O V (0 0) (0 M CD CV (0 6 (D:d 0 CO 00 '0 (D'r N (D V' r y r (0 O M.O M CD CO CO V O O '.7 0 0 :0 0 V.O:O'.4 c) O 0 O'V" O O IO O'.O r r (0 (0 (0 co 6 (0 W (0 C0 N (0 ( .( N N N (0 (- v- () N (0 (0'. (0 . (0 . (0 • r'.(0 (0 (O M.ON < >o N ,r 0 (D.V' r CO M 0- CO CV N'V • O O O O N N r M (O CO CO (D CO CO cc CD 0 0 0 O'. O O O CO CD O O 0 0 0 0 0 O 000000 O O O O O 0 0 0 0 0 O O O co- O (00.0000. 000 0 0 0 CO CD O O O 0:0 O O O r 0 0 0'.O 0 0 0.0 O'.(0 • N N N NN':N N @' CO N Q QQ:QQ :Q Q Q:000QQQ QQQ,QQ V' (O : N CO wr�yh crc}} Vr�h rrc-� Vr�h (- (0 (- N : CO O CO N N M 00 N V: (O (0 (0 CO CO OD CD 0'O N N M.V V' (0 (O.(0 (0 CO (0 (D CO (D (O (O co co QQ' CO • CO CO Q5 CO N N QQ QQQ<<Q< (00 CO CO (-. CV V N N: CO co ct) (O (• cOO'.(MDO (D r r r r'.r V' : V' V' V . V V' V' V V' V' V' V' . V' : V (It V . V' :'7 V . V' (0 (0 (0 (0 V )7 ,r N N N N N N N N N N N N CV N N N N O ON N0NNN0V N N 0.0Oo.0 OO 0.0 oOV V \0\0(V0(V N Es„ N0 V 0OO (D (D (O,((0rco C0-CO D V `� 0)0> N N- WWODWWW0 N0IV m CA25 V' (0 U) (0 10 (0 N N N 'N N N O O O 0 o 0 CV CV CV CV CV CA M M N'CM M O) N N N N H O O.O O V- N O O O O O N O O 0 (- O .O N O O N O O O O .N O O 0. N N N N N N N N N N :N N N N N N N N O N N N N N N N N :.N N N N N N CV CV N N N N 'N O 0.0 0 0 0 O O O O '.O O O O O O O O O O O O O O 0 O O O O O O .O O O O :O O O O .O N N 'N N N N N N N N N N N .N N N .N N N N N N N N N N N :N N N N N N N N N N N N .N 0O CO '.. 0- (0 0) yy N 0) 0. 0) O v-.. 0- r O D (- 0 :V 0) <- CO M (D I-. (O O O M \ 0 N 0)):r O (0 (0 • N N M N N N CO CV MN (- v- N NW M.N:v 0 N O (- N (- (- N M V <� N•- • 0.0 46 O t�:t r h0 (- N N O:O. W �N:N (- O O.N O O CD(- �'.N N.�, a'0 CO 00 m CC 0CCC u) o 00 CO 13 C9 C9 o cJJ _J .J J DC O Q..� O Z @ @ dO Qa EL 0) 0000a CO 0000II 0 I--IJ- '.. (4(!)n1.(Qif- �<Qu)'u) a maa000U00UUa0 F 2 S u) W CO 00 U 0 co cz Z (u m I V,D OU220U U00 JJJ O E w E co 2 a u m Q Q a0 y0 y0 U oOUOUaa�a Q Y @(n(n1>Q z F F O W 2 03 c 2 C 0 c 0 O N. (n (n a0 N J N J m~ Oi 0 O). cG z @ a a w co 05002u.0)1000) 00iii00.a 0 ▪ ('0 co 0) W'. (0 W 0) 0.6 N 6 co W 6 CO: (0 00 W V ('0'.00 O7 N M. V M V W'.0 W O O O O (0 (0 V' M M r 0) (0 (0 V CO (0 M (0 " N (0 c0 O N (O N CO M N V M C0 O00 00 W c0 CO W CO M M.6O H O M 0) CO CO Ln Mr M '.6 6 (O.(D CO r CO CO 6 co M'.r z Z z Z Z z,- 2 22 2 2 2'2 O '- Orr w 0 0. 0 0 o CD CD Z 00 co co CO 0 z 0,0 - 0 a '- U Z..Z Z 2! 2! N N CO 00 r V' CO 6 (0 (- N V' cD 00 V' N 0) (0c)O 0 CO 00 r COCO. CO 00 CO CO '.CO 0 OD OD 00 r r 1 000.0Q02'.= Zaw22',2 O V' c0 0 (0 O 00 Ln (c) r (0 0- W W 0 co'. co r 00 rlN- O oOoOo0CD J ,J J J J m w. a QaQ <QaQQ 0LL)a 0 0 0 0 0 0 0 U 0 2.C9 a 0 0 a I- Federal Farm Credit Bank CALIFORNIA INFRASTRUCTURE & EC 6 r r(O J z W a M M M U LL (O O 1 1 1 m a O NN 0 (- 0 _J _J QQ U'U (C) . 0 CO M ii 2oX22> W M0.(O(00 co c0 V N N V r CO CO CO M M 0 OD V',M 2 2 2 NOo (0 W O o O'0 0 1 00 o U U u. N ON) o''0 co ^) M C N CJ M M NN N M N CVl O 0 0 C.) C 0 J N iV N N N N N 65 H6>rn N N N N(V N NN (VN CC,c0) M C) N N N CV N 0 0 0 O N N N N .(0 i i i Gc3 r , L0 O 0'M N d' CO 0) CO O 0) 0 N CO CO V r V N O N 0) ` N co 0) 0 O O M - 0 N C O O r 0) CO F CO N M O F. O r <C N d' O 0) r O). d' O O r N V '. N(0 '. COCO U) N' CD l) 0) ) 0 CO. V 00 O Cr) N CO O O C CO 0 �. CD O O r N CO A U) O N 0' co N r co 0 0ri.) 0cv ) CD CO O) O N N.r CO CO 7 r O.N O CD rt O)'N r.0 .- CO N rf U) r 0 N O O r. 0) O OD CD 0 O O 00 0 0/ C0 CD a- 0 O O r VD O N CD co op op C) O N 'o co l0 N - O ca co (0 ca N CO C): fr. O N N V N N M 0'0 O 0) N O 0) 0 O 0 co )- r O co 0 V O CO O r. o> �., r 0 (O o!.V O O CO N CO 6): 0 CO :0) M CO 0 f.r N CO N M O CO CO N `?. V r •- U) 0) 0 0 0) 0 6): 0 O O ... 0 - (D LC).. 0 6) O 0 U) 4 M V 0 00 V'. N'N CO N O U Cn CD CO CO V.CD C CO CO r a, cn ' co N 0 0) 6) CO LO.01 CD CD CD OD O CO 0 O O r CO CO 0) 0) CO CO 0 0) 0 0 0 N.N N O CV CO CA .- ni CA ni..- .- N.�..- N.r r. T- .- .-.)-. M M c- v- M CV r ,- •-- 1- r .- V.V.VT N r:N:N N r- CV • • • • U 00 O 0 M 0) CO (co D CO. O: CD CO r N; (O O LD O d N C Nr COr N LO (0 N r(0 V V N CO M CO N CO V' V 0) O) :0) 0 0 (0 V M L0 V V' (0 CO CO CO CO N CO N CO 0 0: C) 6) N N CO d' LO CO 6) 00 O CO F N N r. O'r 0000000OOCDCOCD O000 O O O O O O .O O O O O O O O O O 00 O O OO O O. O. O O C) 00 O O'. O O O O'. O O CD CD D O CO CD CD V r'O O O O'. O O O O.0 v) (0 CD CD r N N N NN N N'NN rN N. 0) 0- N r TT CO VI.. (O CO CO CO CO 00) ,- N 0:0 N:Fr V' V'. (0 03 c- 0) CV CV N U) O M d' V.M N CO O. V' O O 6) O N 0): r U) CO O 0) V' ( CO N r N O U1 LO M'.N 0 6 O U) V' N 4 44 V' O. M 0:(0 4 CO 'Tr LO N N.'N 0 r 00) ((DN 0 0' CO rr c0 CO CO 0 Oa)' m N c- •- CD U) CO V V (0 r O.r CO. N U) CO (0 V. CD CV 0 r 0) 0 rn (- 0) M r r.M V,c0 cO V 0 O 0 CD r V M 7000 r N:CO N M r ,t OV r r l7 0) (D V (0 r 00 CO N CO Lf) CO' (!)'N r M(0 M N N M N' M 0) r 0 CO 0 00 V' M r r CO CO r 0 CO 0) N '.N r r:N 0 O O O O 0 .0 0 O .O: O O O O .O O 'O O 0 O O O O O O O O O 0 O O O O .O O D 0 O O O O O O .O 0 0 O .O O O '.O O U)'.O 0O L0 O O O'.O O O'..O O D o.0 0 O O O (O:O O':LO Ln O O CD O U) O O O 0 CD CD O.O O r .O V CO N O O O O L0 CO 0 0 0 0 0 0 0 :0 NN N N rNN N'.N MM N NM:v-'.N O O 0 0 O O O O O O O 0 0 Lod 0)))) TT CI. .NN 0 U) N 0 0 0 (0 (0 0 NCP r(D 0- CO CD Fr (0O O CO O CO O O V' N O O O V' r CO d' CO O O O CO O.LO N N V'N N U) 0 r U) N (0 CO N CO GO CO V N.CV M 7 CO N <f O V .4OO:O V V 400 0 r U U) LO U) C7 N U) M U1 U) LO 7 at r U1 r U) L0 N N U) CO U10- • 'r 0)NN- N r- O) u) u) N. rrN :0 r :O) N CO CD M CO U1 u) e5 :N Np 0 e. N.N 0. 0.0 O rr. : N N 1 CI N CV CU 0 0 (0 (6 as (0 CO (6 (0 CO (6 QQ QQ¢QQ Q¢QQ CO 7 L0 (0 CO M r V V r 6) O CD c, U) O V :V v r r '.r 0 0 N co co .M L0 (O LC) U) U) U) (O 10 U) N CV CV N N CV N N O O O O O CD CD O N (V (\ VCV IN 04 IN 0 V'U) U) 0) U7 6) (0 N CN Nl( (0 M.V' O CV N N N CD CV CV N N N N N CV N 0 CD CD CD CD O:O O N CV N N N N :N N LOLOO 4 V 6) CO NN r r r CD CD W -J CO U CC CC CC 000 ¢ U) LO CO CO N N CO M Q:Q U) U) U) O U) CD (D N'N O) co N co op co U) 0) L0 L0 U) U) L0 N Ln U) U) U) U) if) N N N 'N N N N N N CV N N N N N N 0 0 0 0 0 .0 0 O 0 .0 O O O O O U) N:O H > N .(n(0 U)0:OU) N M r H. H. MNr :M 44 OOO,n c0,c0c0(O(00) 0 N N N 0 r N N r N N N NNNNN N 0 0:0 0 00 0 00 N N N N NNN:N N N:O M r co `.O (0 r_.co 0 N N rM ON W U U W 0 CO et c) C) of .CD(02C9 YLL r r 0 0 - W CD C) CD w Z p 0 w Q o C7 W'N N N Nd 0 N M co N N r M N N N( O N01010)60)a- W J CL0Q 0 0 U z W Win. c) U'IL 0- 0 N ('. O. Ur) 00 N ( Fr 0C) N M M O V O.O . 0) 0 (0 0) CO 0 0 r c0 60):0 6)'0 10 O O M M r N'. CO N CO N: (NO:LO CO O:O O co. O CO CO M . CO CO (0 CO N 0 0 CO CO CO CO CO CO CO MI C6 CO CO CO Q¢QQQQQQQQQ (0 11) N N:M M M0) N N N O 0 0 0 N N N N M M M V N:N:W.0:0 CO 0) 0) 0)CO 0) 0) 0 LO L() LO 10 . (n U) 0) 0 Ln LC) . U) LD U) N N N N N N N N N :N N N N CD CD O O CD CD O O. 0 O O CD CD CV C4 04 04 34 CO 04 04 04 04 LO U). ( N N -63 N N r N N N N rr r co co O O co co co O N N.N ON N N.N 0 O O O: 0 0 0 N N N N N N ..N V O r r t) V N N r .0 O O O CD CD :O .O O N N N N N N N CV CV N N .N O :O O O O O O 0) O O O .O N N N .N N N N N N N N N 0 O O M.N N 00 00: r M.O M M r r r r H. N N O :N r N r O: O 0 O 00 O O FWW < mW rC (0p CC (n¢00 nQ¢(n0 d 0 2 2 LL U 0 d 2 V O Qa U) J 0) 0) N N D r .0 CD U J 0' CO 0- CO CO(/co ((0 00 coo rn � N 0 0 N C) (0 N¢) N O N N N N M N U) up O r r,0 CO (0 N N CO V U) CO N V' CO N (O N N.M N LO. N N N CO U) O r CO r--. r CO (0 N.r r N r r C) M.N CO CO C) c0 0) (0 r TT CO 0) CO 0 0 V CO : N U U U U c)0 z U U 0 M V N. d' O NCO N d' M CV O O O L004 0) CO 0) NIN O CO 6).0) C7DOo:O0CD0'.CD 10950 MUN 3 (0 d 0 0 N N C 0) 0 S (CO) 4 1 Z 0U> CL _se .)) C C 2 0)W } m m LL 12 U U E E E 2aQ i)L a Z ¢ `) cD • rn Z Z Z Z 2'0u¢. �'F�-F22200 cc �QL Nd'r r (00) 0 O CO T-(O (D CO l0 N 7 N N M U) (0 0(0 M d' U) (0 COIN 0 0 CO. 0) 6) 0 0. CO 0) O) 0'.6) 0 0 0 0 0 0 0 0 0 0 0 O O'.O z (o 0 00 m L¢f) r (1) z co 0 3133EL3P7 z W cn 00 0 0 2 CO CO CLY (0 LL 0 mmm 0 0 0 a0) 0)) 0) 0 4)) 077 0) LL U.U. LL LL LL LL 2 Z (00 0 0 4 cocyy >> J Z Z Z X W O000000 M(0 (0(D(O CO M (0 O)M M M M 0) M M M M M 0 0 0 U U 0 0. LL LL LL LL '.LL LL LL U) N V' (0 CO CO O.CD r r rr r rr rr o o 0 0 0 0 0 Q LL 0 N 0) CO0 0 0) r LO N CO • (V r : 00 CO (0 V N V' r O O .O : CO (0 0 N 0) 00 M CO 00 N: (0 CO 0). V O O.M r C) 0) V.N F N CO CD: CO (O N M:r O. r:. V (0 r (O 01:0 006) N 0 r:r r M 0 0 V.(000 N 0 ciN 0) V (0 O 0).- NN NMN 0006) N 00 CO N CD 00 N N'.N N NNN O) N v- • CD 0 0 O. O'. O O O. O: CD CD CD O.O O O CD O CD O O O U) O O O O O Li: O:O O 0) 0 0 0 (D O Ln 0 0 O CO O O O O O N O O r r N N .N N N .r :N N CO N O 00)) O 0) M ON CO CO N O d d co V U) O CO 0 0 Q Q O0) 00) O O O O 0 0 O O O) : 0 CCCCCCr ( 0 0 0'.O O O O O'. 4 0 O c, c, up up O CO (O O :0.ON N N O NNO) N ca N > . N 0 N r.LD U) (O O).N Ul 10 00 U) M CO O U0 at 6)'.0 N O VT CD OD 6 0) N O O N O M 0 O N O O O O N CO O :.O O Nr-O N O: LU0 ON N V V 10 M.Ln 0.(0:r r VO r:CO V CO N.�• LC) LO •CO CO CO _ O U) O N 0 CO CO CO MI cc cc cc cc cc N 4 r 4 6) CO :LC) U) N LO O N O M.CO O r O O N O LC) CO O N 0 L0 CO CO CO V V CD r r r r O) V CO (0 00 L0 L0 0 D (O O CO r:r N.r- LC1 N 0 M:M (o m r (0 r r Q < Q.000 Q Q.Q. CO (0 N M V 6) r V:CO r r 0 0 0 0 00) CO CO C O L0 L0: L0 O O O O O 0) 0 O O N CV • CO () 00 r CO aa--. N. N � 0) 0) 10LC)) (0(0N N CO VD N CO N N 04 N N N N N :N N N N N N O O O Co O ('4 O.D O CD CD O N.r d' r CO (0 11) O O r.Lnt N N v_ r N COM r\ O O.r r OD OD CO (0 O O).r O N N N N N N N .O O N CO CO N N CV N:N 04 N N N N 0 N N N N N CV N O:O O O O O '.O O O .O O O O CD CD 0 0 0 O O D O N N N N .N N N N N N N CV N N N N N CV N N CO r Op OD: CO CO CO 0, 0 N O : r. M CO CO CO 0 r >-- N N r N r. N .- r M N N N N T CO W co 00 00 z W 0 0 z W 0 0 J >ICJ CO J d Q ¢ Q CD0000 z W'03 CC 0 ct z WmUc,m U) CL CL co cn 0p zw O U 00 U 0 p) Z J 00 11.1 O Y 00 - W X O m o) c.Q Q m2.5 O.LL OU Q d 2 A U U' o,, < o o! 1: oF'_'cLLZ w ii01>,LL0)000 UEH>mE3ZEE EwNo m S'., e S 2 Z Z 2 S,, Y .o pO c:>". 0 d IT?. It F- m m. m m m U' E m p f- C_'. c(n 0 Dill oaa)Na -w(n_teD Q O) m au. u( o o 0 0 a p `~N- w U LL LL'LL LL LL0(na000 J LL d' O N M.O N N O 07 7 C) 7 N V N r (0 N -) W X U Y >j LO cZNZ C.7 0- J X LL �j C) Z U N V' vnYQO>�Fz-¢o>1o�'LQ_Kco0Oo C2' Q W N N(9 Q CD CD CD N CO CO r 0) 0) 00 c) N O r N V V 0 U) U) V co N co co co N O M N M 0,)N O 0) CO CO M CO CD 0) N:U) U) r co 0 U) r r r r r r r r r M r 0_, M.O r co co op M M N'.t0 r co co 0 co (n.(n LL M 0 p Q Q 2 p Q¢¢ Q Q p LL LL F- LL LL.(L LL u_ r V LO0 L0 CV M (O6) U) CO d'.0 M O CO 6) 0 M.r 0) 6) CD CD 0) 6) 6) r r CO: N O O CD CD o 0 CD CD O CD CD 10870 MUN 1 BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: February 22, 2023 SUBJECT: Finance Report for January 2023 ATTENDANCE: Robert Tintle, Chief Financial Officer DATE: TO: FROM: SUBJECT: MEMORANDUM February 22, 2023 Board of County Commissioners Robert Tintle, Chief Financial Officer Finance Report for January 2023 Following is the unaudited monthly finance report for fiscal year to date (YTD) as of January 31, 2023. Budget to Actuals Report General Fund • Revenue YTD in the General Fund is $38.7M or 88.4% of budget. By comparison, last year revenue YTD was $35.7M and 87.5% of budget. • Expenses YTD are $25.2M and 55.7% of budget. By comparison, last year expenses YTD were $23.8M and 55% of budget. • Beginning Fund Balance is $13.8M or 106.7% of the budgeted $12.9M beginning fund balance. 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 Library 130 - Park Acquisi... 132 - Park Develo... Monthly GL Period 0 7 $11.4M Contingency (Blank) Re3elves All Major Funds Requirements $25.2M SO OM 55.7% Spout 54M S2M SOM 2 52010 SO OM Resources 88.4% Collected Monthly Expenditures 4 6 0 Last Year Actuals •Current Year Actuals Monthly Revenues 50M 0 2 4 6 8 • Last Year Actuals •Current Year Actuals 001 - General Fund Budget to Actuals Beginning Working Capital 0043M S0011 55.1% of last year budget 12 87.7% of last year budget 12 106.7% of 3; a _jel: 20M 50M 7 58.3% Year Complete Budget to Actuals by Category 7 a: •Actuals • Budget 0 Projection Transfers Out Personnel Materials$ Capital Setvices Services Outlay Projected Ending Working Capital ®Budget 9 Projection Approved FTE 121.86 93.9196 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 January 31, 2023. Position Control Summary Position Control Summary FY23 July -June Percent Org Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Unfilled Assessor -: :Filled 33.26 ': 31.00 < 32.00 '' 31.00 31.00 33.26 ` 32.26 Unfilled 2.00 4.26 = 3.26 :. 4.26 4.26 2.00 3.00 : 9.33% Clerk Filled 9.48 9.48 10.48 f 10.48 ° 10.48 " 1D 48 10.48 Unfilled 1.00 1.00 ' 2.73% BOPTA Filled 0.52 0.52 0.52 0,52 0.52 0.52 0.52'. Unfilled - - - - 0.00% OA Filled 57.40 58.40 59.20 'r 61.20 61.20 59.80 58.30 Unfilled 3.20 2.20 1.40 0.40 0 40 1.30 2.80 : 2.74% Tax Filled 5.50 5.50 :. 6.50 6.50 6.50 1 6.50 6.50 Unfilled 1.00 1.00 - . 4 40% Veterans'.'. Filled 5.00 : 5.00 " 5.00 4.00 4.00 4.00 5.001 Unfilled 1.00 : 100 - 1.00 8.57% PropertyMgmt Filled 2.00 2.00 2.00 2.00 2,00 2.00 200' Unfilled 1.00 1.00 1.00 1.00 :. 1.00 1.00 1.00 `33.33% Total General Fund Filled 113.16 ' 111.90 = 115.70 '. 115.70 115.70 116.56: 115.06 - - - Unfilled 8.20 '' 9.46 5.66 ` 6.66 6.66 5.30 6.80 5.72% Justice Court Filled 4.60 4,60 4.60 4.60 ' 4.60. -. 4.60 4.60 Unfilled 0.00% Community Justice Filled 45.20 45.20 45.90 44.90 44.90 45.90 45.90 Unfilled 2.70 2.70 2.00 3.00 3.00 2.00 2.00 5.19% Sheriff (Fi8ed 218.25 232.25. 230.25 230.25 231.75 229.75 228.75. Unfilled 44.75 30.75 32.75 32.75 31.25 ' 33.25 36.25 13.12% Houseless Effort Filled - - 1.00 1.00 1.00 1.00 1.00 Unfilled 2.00 2.00 1.00 1.00 1.00 1.00 1.00 64.29% Health Srvcs Filled 355.80 357.50:'- 36830-. 371.30... 374.55 380,20 380.10, Unfilled 49.55 : 47.85 48.25 46.25'. 44.25 39.60 39.70 - 10.87% CDD Filled 59.80 58.80 59.80 58.80 59.80 57.80 57.80 Unfilled 12.20 13.20 12.20 13.20 12.20 14.20 6.20 16.81% Road ::Filled 55.00 `. 55.00'. 58.00 57.00 58.00 58.00 57.00 Unfilled 6.00 6.00 3.00 '. 4.00 3.00 3.00 400: 6.79% Adult P&P Filled 35.55 35.55 35.85 34.85 34.85 34.85 34 85 Unfilled 5.30 5.30 5.00 6.00 6.00 6.00 6.00 13.85% Solid Waste :Filled 27.00 26.00 28.00 '< 26.00 :: 27.00 : 28.00 27.00 Unfilled 3.00 s 4.00 : 2.00 4.00 : 3.00 2.00 3.00'. '.10.00% Victims Assistance Filled 8.00 8.00 8.00 8.50 8.50 8.50 7.50 Unfilled - - - - - - 1.00 1.72% GIS Dedicated :Filled 2.30 '. 2.30 ': 2.30 .' 2.30 2.30.`. 2.30 2.30 Unfilled - - - - - -. 0.00% Fair & Expo Filled 9.75 9.75 9.75 10.75 10.75 10.75 10.75 Unfilled 3.75 3.75 3.75 2.75 2.75 2.75 2.75 23.54% Natural Resource Filled 1.00 '.: - 2.00 - 2.00 2.00. Unfilled - 1.00 2.00 2.00 2.00 - - - 50.00% ISF - Facilities Filled 20.75 21.75 20.75 21.75 21.75 19.75 19.75 Unfilled 4.25 3.25 4.25 3.25 3.25 5.25 5.25 16.43% ISF -Admin ` Filled 8.75 .: 8.75 9.75. - : 10.75 10.75 10.75 - 9.75 Unfilled 2.00 2.00 1.00 - - - 6.73% ISF - BOCC Filled 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Unfilled - - - - - - - 0.00% ISF-Finance Filled 10.00 '. 8.00.'. 10,00:` 10.00. 10.00: .12.00. 12.00 Unfilled 1.00 3.00 1.00 1.00 1.00 - - 8.86% ISF - Legal Filled 7.00 7.00 7.00 7.00 7.00 7.00 7.00 Unfilled - - - - - - - 0.00% ISF - HR ': .Filled 9.00 :: 9.00 9.00.:. 9.00 ': 9.00 9.00 9.00. Unfilled 1.00 1.00 1.00 1.00 1.00 - 1.00 1.00 ' 10.00% ISF - IT Filled 16.70 16.70 16.70 16.70 16.70 15.70 15.70 Unfilled - - - - - 1.00 1.00 1.71% ISF - Risk Filled 2.25 < 2.25 " 2.25 2.25 2.25 2.25 3.25 Unfilled 0.00% 911 Filled 52.00 51.00 49.57 50.57 51.57 52.10 50.10 Unfilled 8.00 9.00 10.43 9.43 8.43 7.91 9.91 15.02% Total: Filled 1,064.86 1,074.30 1,095.47 1,096.97 1,107.72 1,111.76 1,104.16 - - - - Unfilled Total % Unfilled 154.70 1,219.56 12.68% 145.26 135.29 136.29 1,219.56 1,230.76 1,233.26 11.91% 10.99% 11.05% 126.79 1,234.51 10.27% 124.26 1,236.01 10.05% 125.86 1,230.01 A 10.23% - - - - - - - - 11.02% A 6.0 decrease in FIE. 50 +2, CDD -8, Admin -1, Risk+1 \\uTES _, Budget to Actuals - Countywide Summary - { All Departments FY23 YTD January 31, 2023 (unaudited) RESOURCES 001 - General Fund 030 - Juvenile 160/170 -TRT 200 - American Rescue Fund 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 675 - Health Benefits 705 - 911 999 - Other TOTAL RESOURCES REQUIREMENTS 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 220 - Justice Court 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals % 40, 504,168 901,143 12,578,435 19,000,000 550,832 44,947,745 48,727,400 9,580,316 22,629,649 5,840,250 2,471,190 13,350,600 1,395,724 1,560, 500 8,544 517,524 7,546 3,146,973 23,027,177 12,019,306 50,071,869 40,047,506 99% 1,007,843 112% 13,029,089 104% 14,281,402 75% 494,676 45,776,980 48,848,440 10,542,434 24,768,506 6,178,356 1,124,832 13,930,834 1,779, 723 1,922,671 8,012 584,713 6,354 4,409,440 25,070,639 12,896,533 34,055,652 90% 102% 100% 110% 109% 106% 46% 104% 128% 123% 94% 113% ; 84% 140% 109% 107% ; 68% ; 43,472,708 1,010,203 13,631,282 105,186 525,032 48,877,055 57,787,985 11,675,519 24,889,063 6,134,018 1,943,063 14,503,499 1,408,534 1,849,380 7,414 642,252 6,298 3,311,477 23,658,700 13,744,678 57,723,737 38,526,362 89% 313,156 31% 9,252,745 68% 26,667,067 999% 293,341 46,251,296 37,754,980 5,839,673 15,201,745 4,365,997 177,707 7,681,834 995,693 2,364,275 74,326 313,662 10,733 2,034,274 13,984,978 10,739,393 43,240,664 56% 95% 65% 50% 61% 71% 9% 53% 71% 128% 999% 49% 170% 61% 59% 78% 75% Projection % 42,946,156 99% 1,044,516 103% 13,640,651 100% 29,118,051 999% 525,490 100% 49,260,711 101% 60,761,396 105% 10,203,917 87% 25,546,482 103% 6,209,920 101% 1,122,350 58% 14,076,571 97% 1,738,090 123% 2,379,267 129% 310,827 999% 526,384 82% 18,950 301% 3,388,141 102% 23,980,674 101 13,905,001 101 59,326,870 103% 312,836,891 300,764,634 96% 326,907,084 266,083,902 81% : : 360,030,416 110% ; Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuals % 21,298,809 7,496,355 4,010,388 38,000,000 736,142 19,383,248 6,674,328 3,826,539 14,187,441 91% 89% 95% 37% 24,202,373 7,928,538 13,113,218 23,129,361 690,802 94% ; 731,183 13,186,780 4,130,180 9,111,412 9,494,863 54% 52% 69% 41% Projection 0/0 23,241,795 96% 7,429,006 94% ; 13,093,599 100% 23,129,361 100% 428,061 59% 734,987 101% ; { Budget to Actua!s - Countywide Summary F-� All Departments FY23'Y'TD January 31, 2023 (unaudited) 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 675 - Health Benefits 705-911 999 - Other 54,162,360 58,872,642 9,978,889 15,024,128 7,079,915 29,722,691 9,709,991 2,504,877 1,468,131 568,000 552,188 100,000 6,427,292 29,424,393 14,563,007 86,872,890 51,382,461 51,718,597 8,963,943 13,771,124 6,392,578 8,106,117 8,792,122 2,626,480 1,352,783 7,670 95% 88% 90% 92% 90% 27% 91% 105% 92% 1% 466,135 84% 885 1% 4,982,451 78% 29,294,027 100% 10,896,900 75% 41,149,853 47% 59,715,533 71,019,127 11,233,304 16,188,996 7,575,910 28, 387,166 11,754,672 2,768,054 1,852,030 870,000 594,181 100,000 5,887,806 26,769,217 17,709,497 107,593,824 32,511,147 54% 35,680,822 50% 5,349,214 48% 7,287,108 45% 3,713,922 49% 12,938,780 46% 5,390,668 46% 1,621,544 1,884,231 102% 29,352 340,273 5,048 1,796,392 13,712,467 7,440,327 42% 29,963,785 28% 59% 3% 57% 5% 31% 51% 58.3% Year Complete 58,483,138 98% 66,754,151 94% 9,550,938 85% 15,705,636 97% 6,699,509 88% 27,108,146 95% 11,754,672 100% 2,669,739 96% 1,956,939 106% 870,000 100% 534,175 90% 100,000 100% 5,325,841 90% 26,769,217 100% 16,636,918 94% 106,751,207 99% TOTAL REQUIREMENTS 398,573,088 284,666,484 71% 439,123,990 196,016,376 45% ; 425,298,974 97% TES Budget to Actuals - Countywide Summary All Departments FY23 YTD January 31, 2023 (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-RVPark 619 - RV Park Reserve 670 - Risk Management 705 - 911 999 - Other 58.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals % Budget Actuals % Projection (21,952,604) (21,807,006) 99% (20,871,416) (11,903,797) 57% 6,223,387 6,223,387 100% ; 6,452,997 3,764,243 58% (6,024,574) (5,916,413) 98% (6,031,446) (3,518,319) 58% 240,956 196,126 81% 263,217 153,538 58% 3,500,737 3,501,246 100% ; 3,448,587 2,105,947 61% 6,122,830 6,122,830 100% ; 8,007,942 4,075,570 51% (270,622) (1,159,207) 428% ; (911,585) (426,540) 47% (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% 471,072 471,071 100% ; 267,532 72,901 27% 12,193,917 10,672,113 88% 14,230,313 4,889,361 34% (6,029,323) (6,029,323) 100% ; (5,299,665) (2,648,141) 50% 962,736 918,804 95% 704,127 410,739 58% (75,000) (75,000) 100% ; (156,706) (91,406) 58% 798,901 779,502 98% 1,149,827 670,719 58% 47,958 47,958 100% ; (81,566) 19,083 -23% 132,042 132,042 100% ; 261,750 152,579 58% (3,500) (3,500) 100% ; (3,500) (2,037) 58% 0% (59,900) (59,900) 100% 15,418,726 17,682,916 115% ; 10,959,373 9,776,236 89% (19,698,572) 94% 6,452,997 (6,028,659) 263,217 3,448,587 5,922,021 (1,183,335) (12,330,136) 267,532 14,230,313 (5,299,665) 702,175 (156,706) 1,148,992 100% 100% 100% ; 100% ; 74% 130% 100% 100% 100% 100% 100% ; 100% 100% (81,566) 100% 261,566 100% (3,500) 100% (59,900) 100% ; 12,144,639 111% TOTAL TRANSFERS 91 - 0 (255) 0 - 0% , Budget to Actua s CountyvvIde Summary AU Departments FY23 YTD January 31, 2023 (unaudited) ENDING FUND BALANCE 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 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 675 - Health Benefits 705 - 911 999 - Other 58.3% Year Complete Fiscal Year 2022 — —� Fiscal Year 2023 Budget Actuals !° Budget Actuals 10,723,375 596,681 8,433,816 55,646 12,160,633 6,011,534 763,172 2,231,806 1,971,182 5,316,460 583,520 604,256 17,369 1,341,108 13,294 824,054 5,045,296 8,375,402 9,307,082 55,322,038 13,847,827 129% 1,522,125 255% 9,475,532 112% 108,098 999% 15,162,285 13,942,649 2,168,956 7,806,356 3,238,905 27,223,832 3,066,662 995,519 385,854 1,809,440 166,536 1,191,937 8,944,938 11,304,191 12,708,705 95,096,396 0% 125% 232% 284% 350% 164% 512% 526% 165% 999% 135% 999% 145% 177% 135% 137% 172% 11,374,637 634,663 4,000,000 57,066 7,024,650 6,005,519 1,627,134 2,262,898 1,925,640 12,334,484 556,359 315,960 225,358 1,587,183 82,920 1,340,766 5,107,351 8,815,139 8,926,080 56,809,164 27,283,612 1,469,345 6,098,545 17,280,302 18,819 31,008,381 20,092,376 2,232,875 8,280,218 3,963,881 19,352,119 2,709,687 780,408 774,493 2,525,133 159,008 1,350,201 9,180,783 11,576,702 15,947,871 120,326,932 Projection OA 13,853,617 122% 1,590,633 251% 3,993,925 100% 6,096,788 999% 53,720 9,388,445 13,871,914 1,638,600 5,317,066 3,016,848 15,468,349 88,896 766,046 651,476 2,399,259 77,179 1,372,453 7,003,738 8,515,648 9,916,888 63,666,440 94% 134% 231% 101% 235% 157% 125% 16% 242% 289% 151% 93% TOTAL FUND BALANCE ; 129,697,724 230,166,744 177% ; 131,012,971 302,411,692 168,747,928 129% V'(ESiOGZ Budget to Actuals Report f General Fund - Fund 001 FY23 YTD January 31, 2023 (unaudited) RESOURCES Property Taxes - Current Property Taxes - Prior Other General Revenues Assessor Clerk BOPTA District Attorney Tax Office Veterans Property Management TOTAL RESOURCES REQUIREMENTS Assessor Clerk BOPTA District Attorney Medical Examiner Tax Office Veterans Property Management Non -Departmental TOTAL REQUIREMENTS TRANSFERS Transfers In Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 32,410,716 460,000 2,689,926 987,411 2,741,215 14,588 448,201 341,004 259,107 152,000 32,791,880 337,612 2,880,344 886,514 2,225,591 13,216 258,776 321,554 182,018 150,000 101% 73% 107% 90% 81% 91% 58% 94% 70% 99% I 34,467,173 301,000 3,591,874 964,246 2,298,566 14,588 1,183,942 221,483 214,836 215,000 32,502,376 222,266 3,155,345 347,279 783,904 5,261 1,289,033 88,998 91,009 40,891 94% 74% 88% 36% 34% 36% 109% 40% 42% 19% 40,504,168 40,047,506 99% 43,472,708 38,526,362 89% Projection % $ Variance 9 I Budget Actuals Budget Actuals 5,454,784 2,080,739 82,911 9,715,707 242,652 932,570 795,189 380,061 1,614,196 21,298,809 5,157,534 1,735,214 77,147 8,677,696 241,582 886,019 762,328 360,274 1,485,453 19,383,248 95% 83% 93% 89% 100% 95% 96% 95% 92% 91% 5,910,478 2,432,710 87,177 10,979,839 438,702 905,262 809,390 508,359 2,130,456 24, 202, 373 3,088,619 1,209,999 48,671 5,989,620 136,763 515,729 408,867 211,069 1,577,442 13,186,780 52% 50% 56% 55% 31% 57% 51% 42% 74% 54% 34,378,087 301,000 3,744,408 964,246 1,598,566 14,588 1,293,942 221,483 214,836 215,000 100% 100% 104% 100% 70% 100% 109% 100% 100% 100% (89,086) A 152,534; B (700,000); C 110,000: D E I F 42,946,156 99% (526,552): Projection % $ Variance 1 1 1 1 Budget Actuals Budget Actuals 5,443,924 2,362,964 95,578 10,617,050 438,702 884,605 808,721 459,795 2,130,456 92% 97% 110% 97% 100% 98% 100% 90% 100% 466,554: G 69,746: H (8,401) 362,789; I 20,657. H 669! H 48,564; H 1 J 23,241,795 96% 960,578: Projection % $ Variance 260,000 260,000 100% : 260,000 151,921 58% 260,439 100% a 439: K i i I i (22,212,604) (22,067,006) 99% . (21,131,416) (12,055,718) 57% . . (19,959,011) 94% . 1,172,405. (21,952,604) (21,807,006) 99% ; (20,871,416) (11,903,797) 57% ; ; (19,698,572) 94% ; 1,172,844; Budget Actuals Budget Actuals Net Transfers - In (Out) A B c D E F G H J K 13,470,620 14,990, 575 19,205,359 20,664,258 (21,952,604) (21,807,006) TOTAL FUND BALANCE : $ 10,723,375 $ 13,847,828 Projection % $ Variance 111% : 12,975,718 13,847,828 107% .: 13,847,828 107% : 872,110: 19,270,335 25,339,582 . 1 19,704,361 1 434,026; 1 1 1 1 I (20,871,416) (11,903,797) . . (19,698,572) ; 1,172,844; 129% ; $ 11,374,637 $ 27,283,612 240% : : $ 13,853,617 122% ; $2,478,980: Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted 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 Recording fees expected to be lower than budget due to decreased loan origination volume from rising interest rates Recent budget adjustment to increase State grant funding which is expected to come in later this fiscal year Oregon Dept. of Veteran's Affairs grant reimbursed quarterly Interfund land -sale management revenue recorded at year-end Projected Personnel savings based on FY22/FY23 average vacancy rate of 7.9% Projected Personnel based on vacancy savings to date Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.2% Includes $100K loan to Alfalfa Fire District Repayment to General Fund from Finance Reserves for ERP Implementation TES � Budget to Actuals Report `.= Juvenile - Fund 030 FY23 YTD January 31, 2023 (unaudited) RESOURCES OYA Basic & Diversion ODE Juvenile Crime Prev Gen Fund -Crime Prevention Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 Miscellaneous OJD Court Fac/Sec SB 1065 Food Subsidy Contract Payments Interest on Investments TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2022 Fiscal Yc-a 2023 Budget Actuals Budget Actuals '/° Projection % $ Variance 432,044 100,517 89,500 88,000 80,000 49,339 7,500 20,000 12,000 8,000 14,243 500,765 117,184 89,500 89,154 92,400 50,462 29,113 10,291 11,380 9,947 7,647 116% 117% 100% 101% 116% 102% 388% 51% 95% 124% 54% 525,049 123,000 89,500 86,000 55,000 49,339 42,500 15,000 10,000 8,000 6,815 901,143 1,007,843 112% ; 1,010,203 97,007 18% 26,360 21% 0% 52,633 61% 72,300 131% 12,655 26% 19,798 47% 8,374 56% 6,612 66% 2,327 29% 15,089 221% 313,156 31% Budget Actuals Budget Actuals Personnel Services 6,082,895 5,411,118 89% : 6,332,160 Materials and Services I 1,363,409 1,249,983 92% ; 1,527,992 i Capital Outlay 50,051 13,226 26% , 68,386 r TOTAL REQUIREMENTS ; 7,496,355 6,674,328 89% ; 7,928,538 TRANSFERS 3,355,238 53% 767,342 50% 7,600 11% 525,049 100% 107,720 88% 89,500 100% 90,228 105% 90,000 164% 49,339 100% I 37,000 87% 15,000 100% 10,000 100% 5,000 63% ; 25,680 377% 1,044,516 103% (15,280); I 4,228; A 35,000: B (5,500); I (3,000); C 18,865 D 34,313: Projection % $ Variance 5,884,136 93% 1,476,484 97% 68,386 100% 448,024: E 51,508 F 4,130,180 52% ; 7,429,006 94% ; 499,532: Budget Actuals Budget Actuals Transfers In- General Funds 6,304,397 Transfers Out-Veh Reserve (81,010) TOTAL TRANSFERS 6,223,387 FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 6,304,397 100% (81,010) 100% 6,223,387 100% 6,529,064 (76,067) 6,452,997 Projection % $ Variance 3,808,609 58% 6,529,064 100% r � I (44,366) 58% ; ; (76,067) 100% ; 3,764,243 58% ; , 6,452,997 100% Budget Actuals Budget Actuals 968,506 (6,595,212) 6,223,387 965,223 100% (5,666,485) 6,223,387 1,100,001 (6,918,335) 6,452,997 Projection % $ Variance 1,522,125 138% r r (3,817,024) ; ; 3,764,243 I I $ 596,681 $ 1,522,125 255% ; $ 634,663 1,522,125 138% (6,384,490) 6,452,997 r i 422,125: 533,845 I $ 1,469,345 232% ; ; $ 1,590,633 251% ; $955,970: A New lease payment for JBarJ B Savings based on current expense trends for materials and services. c Out of county utilization for last two months is higher than anticipated based on original projection. Can shift daily based on intake activity. D Investment Income projected to come in higher than budget E Projected Personnel savings based on FY23 average vacancy rate of 5.2% F Savings based on current expense trends for materials and services. Budget to Actuals Report TRT - Fund 160/170 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2622 Fiscal Year 2023 Budget Actuals Budget Actuals • Projection % $ Variance Room Taxes 12,519,987 12,977,205 104% : 13,580,874 9,196,342 68% 13,539,110 100% : (41,764): A 1 E I I Interest on Investments P 58,448 51,884 89% ; 50,408 56,241 112% _ 101,380 201% ! 50,972. B Miscellaneous - - - 161 1 . 161 161! 1 i TOTAL RESOURCES 12,578,435 13,029,089 104% : 13,631,282 9,252,745 68% ; , 13,640,651 100% : 9,369; REQUIREMENTS 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 Budget Actuals Budget Actuals % 3,660,659 239,526 15,203 95,000 3,512,891 239,526 9,365 64,758 96% 100% 62% 68% 5,600,000 3,675,886 3,574,573 215,508 47,251 4,600,000 82% 2,288,696 62% 2,085,168 58% 107,548 50% 30,000 63% 4,010,388 3,826,539 95% ; 13,113,218 Projection % $ Variance 5,600,000 100% 3,656,267 99% 3,574,573 100% 215,508 100% 47,251 100% - C 19,619; D E I -i 9,111,412 69% ; , 13,093,599 100% ; 19,619: 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% 100% 81% 100% 96% 96% 100% 98% (20,000) (75,000) (263,217) (418,417) (501,683) (1,101,342) (3,651,787) (6,031,446) (11,662) (43,750) (153,538) (244,076) (292,642) (642,446) (2,130,205) (3,518,319) 58% 58% 58% 58% 58% 58% 58% 58% Projection % $ Variance 1 P I E I i o i (6,028,659) 100% ; 2,787: Budget Actuals Budget Actuals (20,000) 100% (75,000) 100% (263,217) 100% (418,417) 100% , (500,848) 100% 1 (1,099,390) 100% (3,651,787) 100% 0 835; F I 1,952; G I • Projection % $ Variance 5,890,343 8,568,047 (6,024,574) 6,189,395 9,202,550 (5,916,413) 105% 9,513,382 518,064 (6,031,446) 9,475,532 100% 141,333 1 (3,518,319) 9,475,532 100% (37,850): 547,052 28,988; 1 1 (6,028,659) 2,787 1 1 1 $ 8,433,816 $ 9,475,532 112% ; $ 4,000,000 $ 6,098,545 152% ; ; $ 3,993,925 100% ; ($6,075): A Room Tax collections up 4.3% over last year versus 5.0% budget assumption g Investment Income projected to come in higher than budget C Includes contributions of $4M to Sunriver Service District, $600K to Deschutes Trail Coalition and $1M to Mt. Bachelor D Payments to COVA based on a percent of TRT collections E Includes -$3.5M for Interfund Payments to the General County Reserve Fund F The balance of the 1 % F&E TRT is transferred to F&E reserves G Transfer projected to be lower based on decreased Room Tax revenue Budget to Actuals Report ARPA - Fund 200 FY23 YTD January 31, 2023 (unaudited) RESOURCES Interest on Investments Local Assistance & Tribal Consistency State & Local Coronavirus Fiscal Recovery Funds TOTAL RESOURCES REQUIREMENTS Fiscal Year 2022 58.3% Year Complete Fisca! 'tear 2023 I Budget Actuals % uuc;get Actuals % Projection % $ Variance 93,961 105,186 19,000, 000 14,187,441 75% 176,219 168% 2,311,073 24,179,776 19,000,000 14,281,402 75% 105,186 26,667,067 999% ; Budget Actuals Budget Actuals Services to Disproportionately 20,650,098 5,242,251 25% Impacted Communities Administrative 5,281,005 143,079 3% Infrastructure 2,050,000 527,275 26% Negative Economic Impacts 6,285,840 5,488,685 87% Public Health 3,733,057 2,786,152 75% 15,394,824 7,551,739 49% 4,317,328 103,122 2% 1,634,710 484,146 30% 899,577 538,494 60% 882,922 817,362 93% 316,130 301% 4,622,145 24,179,776 210,944: A 4,622,1451 B 24,179,776 29,118,051 999% 29,012,865; Projection % $ Variance 15,394,824 100% 4,317,328 100% - E 1,634,710 100% F 899,577 100% _ G 882,922 100% H TOTAL REQUIREMENTS ; 38,000,000 14,187,441 37% ; 23,129,361 9,494,863 41% ; , 23,129,361 100% FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Budget Actuals Budget Actuals % Projection % $ Variance 19,000,000 14,137 0% (19,000,000) 93,961 23,024,175 108,098 0% (23,024,175) 17,172,204 108,098 0% 5,988,690 (22,916,077) 29,012,865 - $ 108,098 999% ; - $ 17,280,302 999% ; ; $ 6,096,788 999% ; $6,096,788; A Investment Income projected to come in higher than budget B A budget adjustment for additional Local Assistance & Tribal Consistency funds is forthcoming c The revenue received in FY22, but unspent at 06.30.22, was recorded as Deferred Revenue and recognized in FY23 D Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects E Administration holds the balance of the ARPA funds, as well as an approved Management Analyst for ARPA reporting and administration F Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment G Majority of funding is for food programs, $2.5 million in small business assistance and additional funding for Ronald McDonald House and an Apprenticeship jobs program H Approved ARPA funding consists of Isolation Motel Liability Insurance, COVID-19 testing done by Dr. Young, UV sanitizer for the jail to prevent COVID-19 in congregate settings and various Health Services expenses such as temporary staffing costs to support the COVID-19 response `\V(ES�OG� Budget to Actuals Report Justice Court - Fund 220 FY23 YTD January 31, 2023 (unaudited) RESOURCES Court Fines & Fees Interest on Investments Miscellaneous 58.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 293,044 56% 32 297 929% Projection $ Variance 525,000 100% 490 999% 458! A TOTAL RESOURCES 550,832 494,676 90% ; 525,032 293,341 56% ; , 525,490 100% ; 458: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 577,209 541,792 94% e 569,648 336,098 59% :: 573,452 101% : (3,804): Materials and Services 158,933 149,011 94% e 161,535 91,963 57% : a 161,535 100% ; B TOTAL REQUIREMENTS ; 736,142 690,802 94% ; 731,183 428,061 59% ; , 734,987 101% ; (3,804); TRANSFERS Transfers In - TRT Budget Actuals 0/0 Budget Actuals % Projection % $ Variance 240,956 196,126 81% : 263,217 153,538 58% 263,217 100% TOTAL TRANSFERS 240,956 196,126 81% ; 263,217 153,538 58% ; ; 263,217 100% ; Resources over Requirements Net Transfers - In (Out) TOTAL (185,310) (196,126) a (206,151) (134,719) 240,956 196,126 263,217 153,538 $ 55,646 - 0% ; (209,497) 263,217 (3,346): i $ 57,066 $ 18,819 33% ; , $ 53,720 94% ($3,346); A Investment Income projected to come in higher than budget g One time yearly software maintenance fee paid in July for entire fiscal year Budget to Actuals Report Sheriff's Office - Fund 255 FY23 YTD January 31, 2023 (unaudited) RESOURCES LED #1 Property Tax Current LED #2 Property Tax Current Sheriffs Office Revenues LED #1 Property Tax Prior LED #2 Property Tax Prior LED #1 Interest LED #2 Interest LED #2 Foreclosed Properties LED #1 Foreclosed Properties TOTAL RESOURCES REQUIREMENTS Digital Forensics Concealed Handgun Licenses Rickard Ranch Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS TRANSFERS Transfer In - TRT Transfer In - General Fund Transfers Out - Debt Service TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals 28,448,529 11,813,562 3,993,964 330,000 145,000 147,416 69,274 28,828,746 11,962,302 4,407,029 288,862 118,145 96,152 24,356 15,070 36,317 101% 101% 110% 88% 81% 65% 35% 30,282,049 13,400,541 4,607,630 330,000 145,000 89,119 22,716 28,624,636 95% 12,598,973 94% 4,585,528 100% 185,635 56% 76,620 53% 146,735 165% 33,169 146% 1 44,947,745 45,776,980 102% 48,877,055 46,251,296 95% Projection $ Variance 30,239,651 100% 13,313,046 99% 4,945,024 107% 330,000 100% 145,000 100% 240,230 270% i 47,760 210% , (42,398)A (87,495); B 337,394; C 1 151,111: C 25,044; D 49,260,711 101% ; 383,656: Budget Actuals Budget Actuals 4,002,499 1,154,204 3,576,342 3,029,130 14,015,461 1,025,023 21,033,697 444,617 789,912 1,775,588 1,626,207 1,389,684 299,998 4,208,992 1,112,473 3,738,777 3,013,632 13,440,565 735,218 18,807,184 431,758 543,303 2,053,196 1,786,439 1,510,925 105% 96% 105% 99% 96% 72% 89% 97% 69% 116% 110% 109% 0% 808,610 335,044 264,871 5,863,885 1,168,300 4,005,888 3,383,825 14,640,315 944,493 22,269,320 424,769 829,997 2,047,792 1,907,588 820,836 448,440 173,261 128,823 2,912,135 705,110 1,988,229 2,200,919 8,341,837 382,712 11,771,469 305,107 311,013 1,383,912 899,131 559,050 55% 52% 49% 50% 60% 50% 65% 57% 41% 53% 72% 37% 68% 47% 68% 0% 54,162,360 51,382,461 95% ; 59,715,533 32,511,147 54% Budget Actuals Budget Actuals Projection % $ Variance 768,346 308,849 264,871 5,125,790 1,109,983 3,909,285 3,933,754 14,776,858 685,062 20,991,450 530,499 635,501 2,468,297 1,912, 594 1,061,999 95% 40,264: 92% 26,195 100% 87% 738,095 58,317 98% 96,603; 116% (549,929); I 101% (136,543); 73% ' 259,431; 94% 1,277,870 1 125% i (105,730); 77% ; 194,496. 121% ; (420,505)! i i 100% ; (5,006); 129% ; (241,163); 100% 95% 58,483,138 98% ; 1,232,395: • Projection % $ Variance 3,651,787 121,950 (273,000) 3,500,737 3,651,787 100% 121,950 100% (272,491) 100% 3,501,246 100% 3,651,787 70,000 (273,200) 3,448,587 2,130,205 58% 40,831 58% . (65,089) 24% 1 I 2,105,947 61% Budget Actuals Budget Actuals 3,651,787 100% 70,000 100% (273,200) 100% 3,448,587 100% • Projection % $ Variance 17,874,511 (9,214,615) 3,500,737 17,266,520 97% : 14,414,541 (5,605,481) ; (10,838,478) 3,501,246 ; 3,448,587 15,162,285 105% : : 15,162, 285 105% : 747,744: 13,740,149 i i (9,222,427) 1,616,051; 2,105,947 3,448,587 , , I • $ 12,160,633 $ 15,162,285 125% ; $ 7,024,650 $ 31,008,381 441% ; ; $ 9,388,445 134% ; $2,363,795: Note: Vacant positions are driving projected department savings, with other fluctuations causing projected budget overages A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted g Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 4.79% over FY21-22 vs. 5.45% budgeted c Investment Income projected to come in higher than budget D Investment Income projected to come in lower than budget E Savings due to vacant positions 0Tes `OG2 Budget to Actuals Report Health Services - Fund 274 FY23 YTD January 31, 2023 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous OHP Fee for Service Federal Grants Local Grants Environmental Health Fees Other State - Medicaid/Medicare Patient Fees Medicaid State - Medicare Vital Records Liquor Revenue Divorce Filing Fees Interfund Contract- Gen Fund State Shared- Family Planning Interest on Investments CCBHC Grant TOTAL RESOURCES REQUIREMENTS Expenditures 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 58.3% Year Complete Fiscal "Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuais 17,641,302 8,947,837 4,129,465 3,627,151 4,303,483 1,936,838 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 11,776,144 3,518,729 4,032,343 4,090,251 3,350,227 1,213,172 866,362 777,348 538,392 750,524 194,470 342,960 199,100 178,331 127,000 118,228 101,438 38,587 94% 22,223,536 132% 12,882,624 85% 8,901,719 111% 3,232,620 95% 2,615,634 173% 2,332,031 112% 1,238,499 98% 1,169,317 92% 807,530 115% 615,644 74% 430,863 113% 337,614 122% 300,000 127% 177,574 103% 173,030 100% 127,000 77% 125,000 65% 97,750 1% 14,500,771 7,663,361 5,832,900 2,265,038 1,329,260 1,672,738 1,089,764 1,155,534 664,834 374,656 367,780 120,647 179,726 71,415 63,178 127,000 82,919 193,461 65% 59% 66% 70% 51% 72% 88% 99% 82% 61% 85% 36% 60% 40% 37% 100% 66% i 198% Projection % $ Variance 23,813,079 12,115,681 8,414, 578 4,909,696 2,691,308 2,525,159 1,258,100 1,186,058 1,139, 526 642,200 630,480 206,824 348,017 177,574 63,178 127,000 165,838 347,100 107% , 94% 95% 152% 103% 108% 102% 101% 141% 104% 146% 61% 116% 100% 37% 100% 133% 355% 1,589,543; (766,943) (487,141) 1,677,076. 75,674 193,128 19,6010 16,741 331,996; 26,556 199,617; (130,790); 48,017 i (109,852) 40,838. 249,350 ; 48,727,400 48,848,440 100% ; 57,787,985 37,754,980 65% ; , 60,761,396 105% ; 2,973,411; Budget Actuals Budget Actuals 43,994,358 14,721,284 157,000 58,872,642 - 999% 39,393,426 90% 12,243,043 83% 82,128 52% 51,718,597 88% ; 40,027 50,678,752 19,919,705 380,643 71,019,127 27,890,689 7,669,834 120,300 35,680,822 0% 0% 55% 39% 32% 50% 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% 6,608,245 1,473,586 418,417 (492,306) 8,007,942 3,854,746 58% 368,382 25% 244,076 58% (391,634) 80% 4,075,570 51% ; , Projection % $ Variance 40,027 100% ' -, - 0% 46,223,581 91% 4,455,171. 20,115,900 101% (196,195)�. 374,643 98% 6,000; 66,754,151 94% ; 4,264,976; Projection % $ Variance 5,435,840 82% : (1,172,405): 560,070 38% ; (913,516); 418,417 100% (492,306) 100% 5,922,021 74% ; (2,085,921); Budget Actuals Budget Actuals 10,033,946 (10,145,242) 6,122,830 10,689,975 107% : 11,228,719 (2,870,157) ; (13,231,142) 6,122,830 ; 8,007,942 13,942,649 124% 2,074,157 ; 4,075,570 ; $ 6,011,534 $ 13,942,649 232% ; $ 6,005,519 Projection % $ Variance 13,942,649 124% : 2,713,929: (5,992,755) 7,238,387 5,922,021 ; (2,085,921); $ 20,092,376 335% ; ; $ 13,871,914 231% ; $7,866,395; Budget to Actuals Report Health Services - Admin - Fund'274 FY23 YTD January 31, 2023 (unaudited) RESOURCES Federal Grants State Grant OHP Capitation Other Interest on Investments CCBHC Grant Patient Fees TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 20 2 F?sc :.! Year 2023 Budget Actuals Budget Actuals 1,438,843 769,319 9,200 156,549 486,804 1,183,981 82% 493,270 64% 436,443 12,146 132% 101,438 65% 6,938 1% 1,124 454,405 379,180 367,074 160,495 97,750 251,931 313,969 238,322 155,154 193,461 198% 55% 83% 65% 97% 2,860,715 2,235,340 78% 1,458,904 1,152,836 79% Projection % $ Variance 747,892 165% 340,782 90% 367,074 100% 158,695 99% 347,100 355% 293,487: A (38,398); 0 (1,800). a 249,350! 1,961,543 134% ; 502,639: Budget Actuals Budget Actuals Expenditures - Personnel Services 6,904,224 Materials and Services 6,580,649 Administration Allocation (10,188,902) TOTAL REQUIREMENTS : 3,295,971 5,832,219 6,134,705 (10,188,901) 1,778,023 • 84% 93% 100% 54% 3,095 6,738,820 7,007,588 (11,228,846) 2,520,656 0% 3,436,990 51% 3,833,603 55% (2,735,859) 24% . 4,534,735 180% TRANSFERS Transfers In- OHP Mental Health Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Budget Actuals Budget Actuals (219,794) (219,794) (219,794) 100% (219,794) 100% 80,771 (230,635) (149,864) Projection % $ Variance 3,095 100% 5,947,709 88% 6,900,579 98% (11,228,846) 100% 1,622,537 64% 791,111! B 107,009; 898,120: Projection % $ Variance 20,190 25% (134,533) 58% (114,343) 76% - 0% (230,635) 100% (230,635) 154% (80,771): C (80,771); Budget Actuals Budget Actuals 0/0 3,552,000 (435,256) (219,794) 3,769,942 457,318 (219,794) 106% 3,884,332 (1,061,752) (149,864) Projection % $ Variance 4,007,465 103% i e (3,381,898) s a (114,343) $ 2,896,950 4,007,465 103% : 123,133: 339,006 a 1,400,759; (230,635) (80,771); $ 4,007,465 138% ; $ 2,672,716 $ 511,224 19% ; $ 4,115,837 154% ; $1,443,121: A Projection includes unbudgeted FEMA carryforward from FY22 for vaccine clinics and outreach. B Personnel projections based on year to date vacancy savings and assume 3% moving forward. c Transfers In from OHP Mental Health Reserves will occur at end of year. No funds are currently projected to be transferred to Admin Services. ‘TES Budget to Actuals Report Health Services - Behavioral Health - Fund 274 FY23 YTD January 31, 2023 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous OHP Fee for Service Federal Grants Local Grants Other Patient Fees Medicaid State - Medicare Liquor Revenue Divorce Filing Fees Interfund Contract- Gen Fund CCBHC Grant TOTAL RESOURCES 58.3% Year Complete Fiscal Year 2022 Budget Actuals % Budget k;tuals Fiscal Year 2023 Projection % $ Variance 11,907,014 8,947,837 1,934,643 3,627,151 2,725,623 1,093,055 682,180 372,115 1,014,100 172,200 157,000 173,030 127,000 2,140,487 12,160,202 11,339,701 1,712,171 4,009,351 2,781,433 1,378,335 668,038 431,526 750,524 194,470 199,100 178,331 127,000 31,649 102% , 127% 89% 111% 102% 126% 98% 116% 74% 113% 127% 103% 100% 1% 15,718,843 12,515,550 8,027,373 3,214,360 2,017,169 1,475,139 719,670 519,344 430,863 337,614 177,574 173,030 127,000 10,490,182 7,425,039 5,573,664 2,246,922 1,005,729 840,395 422,414 290,042 367,780 120,647 71,415 63,178 127,000 67% 59% 69% 70% 50% 57% 59% 56% 85% 36% 40% 37% 100% 35,073,435 35,961,830 103% 45,453,529 29,044,406 64% REQUIREMENTS Budget Actuals Budget Actuals Administration Allocation 7,523,855 Personnel Services 26,606,065 Materials and Services 4,882,963 Capital Outlay 80,000 TOTAL REQUIREMENTS ; 39,092,883 7,523,855 24,513,386 3,690,305 54,752 100% 92% 76% 68% 35,782,298 92% 8,265,132 2,021,250 24% 32,453,031 18,504,785 57% 10,260,652 2,963,286 29% 225,443 109,100 48% P 51,204,258 23,598,420 46% 16,883,785 11,748,607 7,490, 745 4,877,317 1,780,729 1,537,053 722,058 497,215 630,480 206,824 177,574 63,178 127,000 107% 94% 93% 152% 88% 104% 100% 96% 146% 61% 100% 37% 100% 1,164,942: A (766,943); B (536,628); C 1,662,957; B (236,440); 61,914. 2,388! (22,129); 199,617. (130,790)=I P (109,852); D 1 46,742,565 103% 1,289,036: Projection % $ Variance 8,265,132 100% : 1 � 29,814,766 92% . 2,638,265. E 10,219,022 100% ! 41,629! 219,443 97% ! 6,000' 48,518,363 95% ; 2,685,895: TRANSFERS Budget Actuals Budget Actuals Transfers In- General Fund Transfers In- OHP Mental Health Transfers Out P TOTAL TRANSFERS 2,278,087 (10,961) 2,267,126 2,278,087 100% (10,961) 100% 1 2,267,126 100% 2,231,439 1,392,815 (152,921) 3,471,333 1,301,643 58% 348,192 25% (148,351) 97% 1,501,484 43% Projection % $ Variance 1 1 i 1 1,227,695 55% : (1,003,744) F 560,070 40% , (832,745); G (152,921) 100% P 1,634,844 47% ; (1,836,489); FUND BALANCE Budget Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Actuals Budget Actuals 3,612,014 (4,019,448) 2,267,126 3,870,664 107% 179,532 2,267,126 • 4,788,795 (5,750,729) 3,471,333 6,317,144 132% : 5,445,986 1,501,484 Projection % $ Variance 6,317,144 132% : 1,528,349: (1,775,798) 3,974,931; 1,634,844 ' (1,836,489)' $ 1,859,692 $ 6,317,322 340% ; $ 2,509,399 $ 13,264,614 529% ; ; $ 6,176,189 246% ; $3,666,790: A Increase of $1.1 M related to new funds for Aid & Assist ($431 K), a cost of living adjustment ($358K), and carryforward revenue from FY22 ($455k). B A new System of Care wraparound payment was budgeted as part of OHP Capitation, but is coming in as OHP Fee for Service. c Vacancies in I/DD are estimated to result in lower State Miscellaneous revenue than budgeted. D Mediation Program will no longer be managed within Health Services, so funds are transferred out of Health Services E Personnel projections based on year to date vacancy savings and assume 10% moving forward. F Estimating Behavioral Health will return approximately $1 M return of County General Funds in FY23. G Transfers In from OHP Mental Health Reserves will occur at end of year. Fewer funds are currently projected to be transferred to Behavioral Health than budgeted. Budget to Actuals Report Health Services - Public Health - Fund 274 FY23 YTD January 31, 2023 (unaudited) RESOURCES State Grant Environmental Health Fees State Miscellaneous Local Grants State - Medicaid/Medicare Vital Records Other Federal Grants State Shared- Family Planning Patient Fees OHP Fee for Service TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2..022 l'; cal Year 2023 Budget Actuais % Budget Actuals % Projection 4,964,969 1,086,019 2,194,822 843,783 843,050 280,000 192,656 139,017 152,634 96,300 3,981,365 1,213,172 1,806,557 1,971,892 777,348 342,960 186,177 124,837 118,228 105,742 22,993 80% 112% 82% 234% 92% 122% 97% 90% 77% I 110% I 6,125,513 1,238,499 874,346 856,892 807,530 300,000 289,152 144,060 125,000 96,300 18,260 3,696,620 60% 1,089,764 88% 259,236 30% 832,342 97% 664,834 82% 179,726 60% 577,966 200% 71,600 50% 82,919 66% 84,614 88% 18,116 99% 10,793,250 10,651,270 99% 10,875,552 7,557,737 69% Budget Actuals % $ Variance 6,588,512 1,258,100 923,833 988,106 1,139,526 348,017 305,305 162,687 165,838 144,985 32,379 108% 102% 106% 115% 141% 116% 106% 113% 133% 151% 177% 462,999 A 19,601 49,487 131,214: B 331,996: C 48,017 16,153 18,627 40,838 48,685 14,119 12,057,288 111% ; 1,181,736: • Budget Actuals % Projection % $ Variance Administration Allocation Expenditures Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS 2,665,047 10,484,069 3,257,672 77,000 16,483,788 2,665,046 100% 9,047,822 86% 2,418,033 74% 27,376 36% I 14,158,277 86% 2,963,714 36,932 11,486,901 2,651,466 155,200 17,294,213 714,609 24% 0% 5,948,914 52% 872,945 33% 11,200 7% 7,547,668 44% I I i o I I 2,963,714 100% 36,932 100% I 10,461,106 91% 2,996,299 113% 155,200 100% a 16,613,251 96% 1,025,795• D (344,833): E 680,962: Budget Actuals • Budget Actuals Transfers In- General Fund 3,631,081 Transfers In - TRT 444,417 Transfers Out - TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) 3,631,081 100% 444,417 100% 4,376,806 418,417 (108,750) Projection % $ Variance 2,553,103 58% 244,076 58% (108,750) 100% a I 4,208,145 96% 418,417 100% (108,750) 100% (168,661): F 4,075,498 4,075,498 100% ; 4,686,473 2,688,429 57% ; 4,517,812 96% ; (168,661); Budget Actuals Budget Actuals 2,869,932 (5,690,538) 4,075,498 3,049,370 (3,507,006) 4,075,498 106% 2,555,592 (6,418,661) 4,686,473 Projection % $ Variance 3,618,039 142% 1 f 10,069 I I 2,688,429 1 I TOTAL FUND BALANCE ; $ 1,254,892 $ 3,617,861 288% 3,618,039 142% : 1,062,447: (4,555,963) • 1,862,698• 4,517,812 ; (168,661); $ 823,404 $ 6,316,538 767% ; ; $ 3,579,888 435% ; $2,756,484: A Carryforward of unbudgeted funds are related to vacancies in COVID Team and Public Health Modernization; Includes additional funds for Problem Gambling g Carryforward from FY22 of appx. $40K for Living Well and Diabetes Prevention Programs, as well as reclassifying $60K from Jefferson County for disease investigation c Medicaid revenue trending more than budgeted for the Family Support Services - Nurse Home Visiting Programs D Personnel projections based on year to date vacancy savings and assume 6% moving forward. E Increase in expenditures related to additional funds in Prevention Services, including Tobacco Prevention, Diabetes Prevention, and Alcohol and Drug Prevention. Also includes estimated isolation motel expenses and increase MAC/TCM match amounts. F Due to Health Officer vacancy, anticipate returning associated County General Fund ($168K). Budget to Actu&s Report Community Development - Fund 295 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2022 1 Fiscal Year 2023 Budget Actuals % Budget Actuals Projection % $ Variance Admin - Operations 138,716 153,688 111% 153,445 86,136 56% 145,645 95% : (7,800): Code Compliance 842,906 995,865 118% 1,171,592 593,608 51% 994,467 85% (177,125); A Building Safety 3,819,940 4,325,818 113% 4,821,160 2,541,113 53% 4,549,660 94% (271,500); A Electrical 914,750 979,129 107% 1,022,005 449,745 44% _ 785,505 77% (236,500); A Onsite Wastewater 1,056,678 983,462 93% 1,017,678 442,125 43% a 814,478 80% (203,200); A Current Planning 1,980,521 2,223,570 112% 2,425,334 1,122,282 46% 2,020,184 83% (405,150) A Long Range Planning 826,806 880,902 107% 1,064,305 604,663 57% ' 893,978 84% (170,327) A TOTAL RESOURCES 9,580,316 10,542,434 110% ; 11,675,519 5,839,673 50% ; , 10,203,917 87% ; (1,471,602): REQUIREMENTS Budget Actuals % Budget Actuals 0/0 Projection % $ Variance Admin - Operations 3,137,795 2,960,981 94% : 3,432,980 1,747,827 51% :: 3,018,365 88% : 414,615: B Code Compliance 617,012 618,343 100% 805,614 418,149 52% ' 728,486 90% ' 77,128; B Building Safety 2,284,444 2,022,820 89% 2,538,721 1,093,058 43% 1,970,675 78% 568,046; B Electrical 556,531 553,223 99% 641,837 311,899 49% 543,770 85% 98,067, B Onsite Wastewater 765,935 643,079 84% 753,369 418,913 56% 738,269 98% 15,100 Current Planning 1,769,333 1,589,882 90% 2,062,044 864,333 42% 1,553,934 75% 508,110; B Long Range Planning 847,839 575,615 68% . 998,739 495,035 50% 997,439 100% : 1,300; TOTAL REQUIREMENTS : 9,978,889 8,963,943 90% : 11,233,304 5,349,214 48% : : 9,550,938 85% : 1,682,366: 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 Budget Actuals Budget Actuals % Projection % $ Variance 290,000 170,661 59% : 160,000 80,557 50% < : 160,000 100% : ; C - - 98,436 98,436: D (99,360) (99,360) 100% ; (112,619) (65,674) 58% : : (112,619) 100% (461,262) (1,230,508) 267% ; i (958,966) (441,423) 46% : a (1,329,152) 139% o (370,186): E 0 1 i (270,622) (1,159,207) 428% : (911,585) (426,540) 47% : : (1,183,335) 130% : (271,750): Budget Actuals 0/0 Budget Actuals OA Projection % $ Variance 1,432,367 1,749,673 122% : 2,096,504 2,168,956 103% ; ; 2,168,956 103% : 72,452: (398,573) 1,578,491 442,215 490,459 . ' 652,979 210,764; (270,622) (1,159,207) (911,585) (426,540) ; ; (1,183,335) (271,750) $ 763,172 $ 2,168,956 284% ; $ 1,627,134 $ 2,232,875 137% ; ; $ 1,638,600 101% ; $11,466: A YTD revenue collection is lower than anticipated due to application volume decrease g Projections reflect unfilled positions c $40K to Current Planning will be transferred as needed D Transfer in from reserves anticipated due to revenue collection less than anticipated E Transfer out projection increased due to reduced expenditures related to unfilled FTE ViES Budget to Actuals Report Road - Fund 325 FY23 YTD January 31, 2023 (unaudited) d) 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 State Miscellaneous Assessment Payments (P&I) TOTAL RESOURCES 58.3% Year Complete Fiscal Yr_ar2022 fiscal ar 2023 Budget Actuals Budget Actuals 17,485,000 19, 740,504 2,096,751 2,195,918 1,221,632 1,254,413 627,207 792,420 449,150 341,833 560,000 155,269 67,340 68,747 59,109 55,083 60,000 148,267 113% 105% 103% 126% 76% 28% 102% 93% 247% 3,460 16,052 464% 19,483,147 2,200,000 1,311,901 882,502 426,000 403,731 77,610 54,172 50,000 12,094,134 2,239,616 188,079 278,732 266,129 47,076 46,795 17,484 20,000 3,702 62% 102% 14% 0% 65% < 66% 0 61% 86% 35% Projection % $ Variance 20,103,788 2,239,616 1,311,901 792,322 455,563 403,731 77,610 81,950 50,000 20,000 10,000 103% s 102% 100% 90% s 107% 100% 0 100% 151% 100% e 620,641: A 0 39,616! B (90,180) 29,563 27,778; C 20,000! 10,000. D 22,629,649 24,768,506 109% ; 24,889,063 15,201,745 61% ; , 25,546,482 103% ; 657,418: REQUIREMENTS Budget Actuals Budget Actuals Personnel Services 6,916,229 Materials and Services ! 7,843,400 i Capital Outlay 264,500 1 TOTAL REQUIREMENTS ; 15,024,128 TRANSFERS Transfers Out TOTAL TRANSFERS 6,751,810 98% 6,877,560 88% 141,754 54% 7,802,271 8,246,700 140,025 4,120,010 53% 3,079,284 37% 87,814 63% 13,771,124 92% 16,188,996 Projection % $ Variance 1 1 7,318,931 94% 8,246,680 100% 140,025 100% 483,340; E 20 7,287,108 45% ; ; 15,705,636 97% ; 483,360: Budget Actuals % Budget Actuals Projection % $ Variance (11,757,547) (11,757,547) 100% (12,330,136) (7,440,775) 60% (12,330,136) 100% (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% ; ; (12,330,136) 100% FUND BALANCE Budget Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) Actuals Ok Budget Actuals 6,383,832 7,605,521 (11,757,547) 8,566,521 134% : 5,892,967 10,997,382 ! 8,700,067 (11,757,547) I (12,330,136) 7,806,356 132% 7,914,637 (7,440,775) Projection % $ Variance 9,840,846 (12,330,136) , 1 1 1 ; $ 5,317,066 235% : $3,054,168: TOTAL FUND BALANCE ; $ 2,231,806 $ 7,806,356 350% ; $ 2,262,898 $ 8,280,218 366% 1,913,390: 1,140,778 A Updated fall projection per AOC/CRP g Actual payment higher than budget c Investment Income projected to come in lower than budget D Updated based on YTD actuals trending higher than budgeted E Projected Personnel savings based on FY23 average vacancy rate of 6.8% ESC�G�� Budget to Actuals Report Adult P&P - Fund 355 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budt,et Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,202,885 4,734,453 113% a 4,734,453 3,550,840 750/0 ; 4,734,453 100% CJC Justice Reinvestment 781,597 892,038 114% 892,038 446,019 50% . 943,171 106% 51,133. A DOC Measure 57 255,545 244,606 96% 0 244,606 271,606 111% ; 271,606 111% 27,000: B State Miscellaneous 138,000 96,068 70% 123,453 34,345 28% 0 100,000 81% ! (23,453)! C Interfund-Sheriff 50,000 55,000 110% 50,000 29,167 58% a 50,000 100% 1 Gen Fund/Crime Prevention 50,000 50,000 100% 50,000 0% ' 50,000 100% Oregon BOPPPS 24,281 20,318 84% 20,318 0% . 0% (20,318)! D Interest on Investments 45,193 19,125 42% ' 18,151 33,346 184% . 59,390 327% 41,239; E Miscellaneous 500 3,904 781% 500 74 15% . 500 100% Electronic Monitoring Fee 2,500 280 11% 500 601 120% . 800 160% 300; F DOC-Family Sentence Alt 118,250 58,958 50% - - , Probation Work Crew Fees 1,500 0% , , Probation Supervision Fees 170,000 3,606 2% 1 1 TOTAL RESOURCES 5,840,250 6,178,356 106% ; 6,134,018 4,365,997 71% ; , 6,209,920 101% : 75,902; REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfers In- General Funds Transfer to Vehicle Maint Transfers Out TOTAL TRANSFERS FUND BALANCE Budget Actuals % Budget Actuals Projection % $ Variance 5,379,503 4,864,354 90% = 5,683,822 2,865,966 50% : : 4,888,952 86% : 794,870: G 1,700,412 1,528,224 90% i 1,883,614 847,359 45% ' a 1,802,082 96% ' 81,532; H - 1 8,475 598 7% ; 7 1 8,475 100% . , 7,079,915 6,392,578 90% ; 7,575,910 3,713,922 49% ; , 6,699,509 88% ; 876,402: Budget Actuals "/° Budget Actuals 0/0 Projection % $ Variance 662,046 662,045 100% : 536,369 312,872 58% : : 536,369 100% (190,974) (190,974) 100% (69,277) (40,411) 58% ! (69,277) 100% (199,560) (199,560) 100% ; ; (199,560) 100% 1 1 1 471,072 471,071 100% ; 267,532 72,901 27% ; , 267,532 100% ; _i Budget Actuals % Budget Actuals 0/0 Projection % $ Variance Beginning Fund Balance 2,739,775 2,982,055 109% : 3,100,000 3,238,905 104% : : 3,238,905 104% : 138,904: Resources over Requirements . (1,239,665) (214,221) (1,441,892) 652,075 . . (489,588) 952,304 Net Transfers - In (Out) ' 471,072 471,071 267,532 72,901 ' . 267,532 1 1 1 1 1 I TOTAL FUND BALANCE : $ 1,971,182 $ 3,238,905 164% ; $ 1,925,640 $ 3,963,881 206% ; ; $ 3,016,848 157% ; $1,091,208; A Received additional JRI funding for training, equity plan, and community engagement. g DOC has increased funds for M57. Deschutes County received an additional $27K for housing and curriculum training. C Close out of Adult Treatment Court. No longer accepting new clients. D Hearings officer agreement with board of supervision is payment in even year. Payment will come next year. E Investment Income projected to come in higher than budget F Received additional electronic monitoring restitution payments. G Projected Personnel savings based on FY23 average vacancy rate of 13.9% H Adult Treatment Court Closure and based on other expense trends. Budget to Actual Report Road CIP - Fund 465 FY23 YTD January 31, 2023 (una.idived) RESOURCES 58.3% Year Complete Fiscal Year 2022 Budget Actuals t"iscai Year 2023 % Budget Actuals % Projection $ Variance State Miscellaneous 2,191,461 1,000,000 46% 1,818,500 - 0% ; ; 818,500 45% (1,000,000); A Interest on Investments 279,729 124,832 45% 124,563 177,707 143% ; ; 303,850 244% ; 179,287I B { I I TOTAL RESOURCES 2,471,190 1,124,832 46% ; 1,943,063 177,707 9% ; 1,122,350 58% ; (820,713): REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 109,870 109,870 100% : 127,640 74,457 58% : : 127,640 100% , Capital Outlay 29,612,821 7,996,247 27% ` 28,259,526 12,864,323 46% ! ! 26,980,506 95% ! 1,279,020! 1 I I 9 TOTAL REQUIREMENTS : 29,722,691 8,106,117 27% : 28,387,166 12,938,780 46% : : 27,108,146 95% : 1,279,020: 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% I , I TOTAL TRANSFERS 12,193,917 10,672,113 88% ; 14,230,313 4,889,361 34% ; , 14,230,313 100% FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE Budget Actuals % Budget Actuals Projection % $ Variance 20,374,044 23,533,004 116% : 24,548,274 27,223,832 111% : : 27,223,832 111% : 2,675,558: (27,251,501) (6,981,285) (26,444,103) (12,761,073) (25,985,796) 458,307; I � I I � I ; i 12,193,917 10,672,113 14,230,313 4,889,361 14,230,313 1 1 I I $ 5,316,460 $ 27,223,832 512% ; $ 12,334,484 $ 19,352,119 157% ; ; $ 15,468,349 125% ; $3,133,865: A @I M was budgeted in FY23, but received in FY22 g Investment Income projected to come in higher than budget Budget to Actuals Report Road CiP (Fund 465) - Capital Outlay Summary by Project FY23 YTD January 31, 2023 (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 Gribbling 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 Replacement 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 Reservoir Rd: OB Riley to Sisemore Rd Local Road Pavement Preservation FY 22 Guardrail Improvements FY 23 Guardrail Improvements Redmond District Local Roads Bend District Local Roads Sidewalk Ramp Improvements Signage Improvements TOTAL CAPITAL OUTLAY 58.3% Year Completed Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actual:: Projection % $ Variance $ 10,000,000 $ 6,700,000 67,998 16,907 2,363,532 2,142,875 91% 2,168,940 637,975 29% 108,510 86,081 79% 279,575 1,110 0% 35,130 1,716,142 1,391,051 81% 931,140 1,319,374 142% 505,000 1,869 0% 671,000 208,367 31 % 618,144 499,075 81% 310,838 - 0% 265,000 2,638 1% 200,000 1,912 1 % 150,000 38,562 26% 100,000 - 0% 1,250,000 1,200,000 96% 69,536 219 1,640 1,148 100,000 114,378 114% 500,000 - 0% 500,000 • 0% 75,000 156,557 209% 100,000 1,843 2% $ 7,319,310 $ 2,200,000 30% 6,700,000 6,700,000 100% 4,265,216 818,500 985,000 1,663,000 132,792 3% 31,153 44,635 5% 43,525 4% 189,564 11% 443,000 - 0% 1,200,000 1,788,826 149% 333,000 999,285 300% 785,000 84,687 11% 160,000 - 0% 246,000 32,693 13% 337,183 380,000 - 0% 150,000 - 0% 96,500 - 0% 100,000 155 0% 815,000 - 0% 300,000 - 0% 1,000,000 0% 100,000 0% 200,000 0% 150,000 0% 50,000 182,670 365% 97,156 $ 7,319,310 100% 6,700,000 100% 3,928,335 92% 77,100 418,500 51% 485,000 49% 2,305,294 139% 0% 1,788,826 149 % 999,286 300% 391,153 50% 0% 32,693 13% 337,183 393,000 103 % 0% 40,000 41% 60,000 60% 815,000 100% 300,000 100% 0% 35,000 35 % 200,000 100% 75,000 50% 182,670 365% 97,156 336,881 (77,100) 400,000 500,000 (642,294) 443,000 (588,826) (666,286) 393,847 160,000 213,308 (337,183) (13,000) 150,000 56,500 40,000 1,000,000 65,000 75,000 (132,670) (97,156) $ 29,612,821 $ 7,996,247 27 % $ 28,259,526 12,864,323 46% $ 26,980,506 95% $ 1,279,021 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 January 31, 2023 (unaudited) RESOURCES Franchise Disposal Fees Private Disposal Fees Commercial Disp. Fee Franchise 3% Fees Yard Debris Miscellaneous Interest on Investments Special Waste Recyclables Leases TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals Budget Actuals • Projection % $ Variance 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 3,598,449 1,804,083 1,798,616 159,457 176,168 77,909 18,360 44,281 4,509 1 13,350,600 13,930,834 104% ; 14,503,499 7,681,834 50% 54% 56% 52% 61% 111% 60% 295% 38% 100% 53% 6,910,000 96% : (300,000)9 A 3,080,000 92% (257,000); A 1 3,234,000 100% ' A i 340,000 111% = 35,000. B 290,000 100% C 9 P 128,000 183% ' 58,000; D 35,570 117% ' 5,072. E 50,000 333% 35,000! F 9,000 75% (3,000)! G 1 100% 14,076,571 97% ; (426,928); Budget Actuals Budget Actuals Personnel Services Materials and Services Capital Outlay Debt Service TOTAL REQUIREMENTS TRANSFERS SW Capital & Equipment Reserve TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 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 6,473,358 264,000 1,739,630 11,754,672 1,717,157 2,817,955 109,970 745,586 5,390,668 52% 44% 42% 43% 46% Budget Actuals Budget Actuals Projection % $ Variance 3,277,684 100% 6,473,358 100% 264,000 100% ' 1,739,630 100% 11,754,672 100% • Projection % $ Variance (6,029,323) (6,029,323) 100% (5,299,665) (2,648,141) 50% (5,299,665) 100% • (6,029,323) (6,029,323) 100% (5,299,665) (2,648,141) 50% ; ; (5,299,665) 100% Budget Actuals Budget Actuals • Projection % $ Variance 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) 3,066,662 99% ie 2,291,166 ' 0 0 (2,648,141) 3,066,662 2,321,899 (5,299,665) 99% ; (40,535) (426,928); $ 583,520 $ 3,066,662 526% ; $ 556,359 $ 2,709,687 487% $ 88,896 16% ($467,463): A Total disposal fee projections reflect management's best estimate of revenues to be collected. Although YTD total disposal volumes slightly exceed last year-to-date by 0.3%, they are less than budgeted. Franchise disposal fee payments of $523K were not received from Republic Services (Bend Garbage, High Country) and Cascade Disposal by closing. g Annual fees due April 15, 2023; received year-to-date monthly installments from Republic c Revenue is seasonal with higher utilization in summer months D Proceeds from cell 9 rock excavation have positively impacted miscellaneous revenue E Investment Income projected to come in higher than budget F Revenue source is unpredictable and dependent on special clean-up projects of contaminated soil and asbestos (i.e. gas station remediation) G Recycling material values have dropped VSES Budget to Actuals Report Fair & Expo - Fund 615 FY23 YTD January 31, 2023 (unaudited) RESOURCES Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Camping Fee Interest on Investments Miscellaneous Interfund Payment TOTAL RESOURCES REQUIREMENTS Personnel Services Personnel Services - F&B Materials and Services Materials and Services - F&B Debt Service 58.3% Year Complete Fiscal Year 2622 Fiscal Year 2023 Budget Actuais Budget Actuals 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 Projection % $ Variance 463,400 62% 407,357 98% ae 39,400 38% 27,845 43% se 44,625 91% 3,475 17% ! s 8,218 157% 1,374 39% 16 1,395,724 1,779,723 128% 799,000 680,000 74,000 54,000 92,000 23,000 14,690 1,400 107% 164% 70% 83% 188% 115% 281% 39% 53,241: 265,000! (31,000); (11,000) 43,000 3,000 9,469; A (2,154) 1,408,534 995,693 71% ; : 1,738,090 123% ; 329,556: Budget Actuals % Budget Actuals TOTAL REQUIREMENTS TRANSFERS Transfers In - Room Tax Transfers In - Park Fund Transfers In - County Fair Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 1,118,980 181,593 818,804 282,500 103,000 1,129,821 101% 200,062 110% 852,050 104% 342,748 121% 101,799 99% Projection % $ Variance 1,256,902 689,720 55% 1,126,030 90% : 130,872: B 170,247 43,502 26% . 114,438 67% ; 55,809! C 965,684 596,271 62% ! 982,000 102% ; (16,316); 273,950 235,001 86% ' ' 346,000 126% . (72,050); 101,270 57,050 56% 101,270 100% i 2,504,877 2,626,480 105% ; 2,768,054 1,621,544 59% : ; 2,669,739 96% ; 98,315: Budget Actuals % Budget Actuals 1,093,513 30,000 150,000 (310,777) 962,736 1,049,581 96% : 1,101,342 30,000 100% ' 30,000 150,000 100% (310,777) 100% s (427,215) 918,804 95% : 704,127 642,446 58% 17,500 58% (249,207) 58% 410,739 58% Projection % $ Variance 1,099,390 100% i 30,000 100% (427,215) 100% 702,175 100% (1,952)= D (1,952): Budget Actuals % Budget Actuals Projection % $ Variance 750,673 923,473 123% , 971,352 995,519 102% (1,109,153) (846,757) :I (1,359,520) (625,850) 962,736 918,804 704,127 410,739 , , $ 604,256 $ 995,519 165% : $ 315,960 $ 780,408 247% ; ; A Investment Income projected to come in higher than budget g Projected Personnel savings based on FY23 average vacancy rate of 20% c Projected Personnel based on vacancy savings to date D Transfers expected to be higher than budget due to increased Room Tax revenue 995,519 102% : 24,167: (931,649) 427,871 702,175 , (1,952) $ 766,046 242% ; $450,086: Budget to Actuals Report Annual County Fair Fund 616 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2022 -1 Fiscal Year 2023 Budget Actuals %- Budget Actuals % Projection % $ Variance Gate Receipts 550,000 738,029 134% : 710,000 782,364 110%:: 782,424 110% :72,424: Concessions and Catering 385,000 526,737 137% ! 505,000 815,458 161% a 815,461 161% a 310,461. Carnival 330,000 415,716 126% , 385,000 433,682 113% ! 433,682 113% . 48,682! Commercial Exhibitors 110,000 86,200 78% ! 80,000 117,100 146% a 117,100 146% a 37,100. Fair Sponsorship 83,500 51,035 61% . 61,000 101,370 166% . ` 109,370 179% ; 48,370! State Grant 52,000 53,167 102% 53,167 53,167 100% 53,167 100% Rodeo 20,000 24,050 120% , 24,000 30,970 129% , 30,970 129% ; 6,970 RN Camping/Horse Stall Rental 25,500 19,815 78% ! 20,000 17,520 88% ; 17,520 88% ; (2,480) Livestock Entry Fees 4,500 - 0% ! 5,000 1,925 39% ; 2,169 43% , (2,831) Merchandise Sales - 5,239 3,500 3,245 93% ! 3,245 93% : (255); I I 1 Interest on Investments 2,683 2,713 7,474 276% , 14,160 522% , 11,447, A TOTAL RESOURCES 1,560,500 1,922,671 123% : 1,849,380 2,364,275 128% : : 2,379,267 129% : 529,887: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 155,959 36,681 24% :169,445 108,752 64% : 179,354 106% :(9,909) 1 1 f l I i Materials and Services 1,312,172 1,316,102 100% ; 1,682,585 1,775,479 106% ; ; 1,777,585 106% ; (95,000); r i t TOTAL REQUIREMENTS : 1,468,131 1,352,783 92% : 1,852,030 1,884,231 102% : : 1,956,939 106% : (104,909): TRANSFERS Budget Actuals % Budget Actuals Projection % $ Variance Transfer In - TRT 1% 75,000 75,000 100% : 75,000 43,750 58% 75,000 100% I 1 I I 1 ' Transfer Out - Fair & Expo (150,000) (150,000) 100% ; - - Transfers Out - (231,706) (135,156) 58% , ' (231,706) 100% e TOTAL TRANSFERS (75,000) (75,000) 100% : (156,706) (9T,406) 58% : ; (156,706) 100% : -: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance (109,033) 999% : 384,715 385,854 100% : a 385,854 100% : 1,139: Resources over Requirements 1 92,369 569,888 (2,650) 480,045 . . 422,328 424,978 1 1 1 1 1 1 Net Transfers - In (Out) (75,000) (75,000) . (156,706) (91,406) ; , (156,706) , -, TOTAL FUND BALANCE $ 17,369 $ 385,854 999% ; $ 225,358 $ 774,493 344% ; ; $ 651,476 289% ; $426,118: A Investment Income projected to come in higher than budget 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 % 68,750 ` 6,250 75,000 Transfer Out - F&E Reserve (96,540) (19,308) (231,696) Transfer Out - Fair & Expo - TOTAL TRANSFERS $ (27,790) $ (13,058) $ (156,696) Net Fair $ 504,270 $ (62,978) $ 329,888 Fair 2022 Fair 2023 Actuals to Date 2023 Projection $ 782,364 433,682 436,292 1,925 17,392 3,245 497,366 126,300 $ 2,298,566 $ 821,482 455,366 458,107 2,021 18,261 3,407 522,234 125,000 $ 2,405,879 53,167 53,167 5,794 1,440 18,726 1,440 $ 2,477,772 102,763 ;) 14,904 182,350 1,722,703 36,456 1,808,839 $ 1,825,466 «,.,, $ 51,360 $ 1,991,188 Beginning Fund Balance on Jan 1 $ 448,151 $ 952,421 $ 952,421 Ending Balance $ 952,421 $ 889,444 $ 1,282,309 �uSES Budget to Actuals Report Fair & Expo Capital Reserve - Fund 617 FY23 YTD January 31, 2023 (cnraudited) RESOURCES Interest on Investments Local Government Payments TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2022 i igr,al Year 2023 Budget Actuals Budget Actuals 8,544 8,012 94% 7,414 8,544 8,012 94% ; 7,414 Projection % $ Variance 18,771 253% I ! 55,555 ! P 74,326 999% ; ; 33,050 446% : 25,636: A I I 277,777 277,777. B 310,827 999% ; 303,413; Budget Actuals Budget Actuals Materials and Services Capital Outlay TOTAL REQUIREMENTS ; TRANSFERS 180,000 388,000 568,000 8,564 5% (894) 0% 7,670 1 % ; Projection % $ Variance 220,000 29,352 13% i 650,000 - 0% ' 220,000 100% 650,000 100% P -= C 870,000 29,352 3% ; , 870,000 100% ; , Budget Actuals Budget Actuals Transfers In - TRT 1% 498,901 Transfers In - Fair & Expo 300,000 Transfers In -Annual County Fair TOTAL TRANSFERS ; FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 479,502 96% 300,000 100% 798,901 779,502 98% ; 501,683 416,437 231,706 Projection % $ Variance 292,642 58% 242,921 58% Pi 135,156 58% IP 1,149,827 670,719 58% ; , Budget Actuals Budget Actuals 1,101,663 (559,456) 798,901 1,029,596 342 779,502 93% 1,299,942 (862,586) 1,149,827 1,809,440 44,973 670,719 139% $ 1,341,108 $ 11109440 1350/0 $ 1,587,183 500,848 100% 416,437 100% 231,706 100% (835)= D 1,148,992 100% ; (835): Projection % $ Variance I I $ 2,525,133 159% 1,809,440 139% ' ! (559,173) 1,148,992 $ 2.399.259 1$1°/ 509,498: 303,413; (835) P $812.076' A Investment Income projected to come in higher than budget g Awarded a grant for 278k which will help offset the budgeted HVAC replacement expenses c Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction D Transfers expected to be higher than budget due to increased Room Tax revenue C (uTES Budget to Actu s Report RV Park Fund 618 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2022 �`iserl Y ar 023 I Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 495,000 551,683 111% : 605,000 292,633 48% Cancellation Fees 15,725 14,000 5,457 39% RV Park Fees > 30 Days 10,500 8,499 81% 13,000 8,156 63% Washer / Dryer 5,000 3,476 70% ; 4,200 3,638 87% Miscellaneous 2,500 3,731 149% 3,750 1,370 37% Vending Machines 2,500 1,021 41% 1,750 978 56% Interest on Investments 2,024 578 29% ; 552 1,430 259% 1 TOTAL RESOURCES 517,524 584,713 113% : 642,252 313,662 49% ; REQUIREMENTS Budget Actuals % Budget Actuals 490,000 81% ; (115,000); A 1 1 13,916 99% . (84); 10,451 80% , (2,549); B 1 5,302 126% , 1 1 1,102; 2,557 68% ! (1,193); 1,498 86% . (252); 2,660 482% ! 2,108. C 526,384 82% (115,868); Projection % $ Variance Personnel Services 19,456 1,643 8% a 111,153 44,750 40% 91,063 82% : 20,090: D Materials and Services 310,805 242,863 78% . 259,755 129,990 50% 219,839 85% 39,916! Debt Service 221,927 221,629 100% ! 223,273 165,533 74% 1 223,273 100% 1 1 1 1 f TOTAL REQUIREMENTS ; 552,188 466,135 84% ; 594,181 340,273 57% 534,175 90% ; 60,006: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% : 160,000 160,000 100% Transfers In -TRT Fund 20,000 20,000 100% ! 20,000 11,662 58% Transfer Out - RV Reserve (132,042) (132,042) 100% ; (261,566) (152,579) 58% TOTAL TRANSFERS 47,958 47,958 100% : (81,566) 19,083 -23% ; FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 160,000 100% 20,000 100% e (261,566) 100% (81,566) 100% Budget Actuals Budget Actuals (34,664) 118,578 47,958 47,958 Projection % $ Variance 116,415 166,536 143% : : 166,536 143% : 50,121: 48,071 (26,611) (7,791) (55,862); 1 1 1 (81,566) 19,083 (81,566) 1 1 i $ 13,294 $ 166,536 999% ; $ 82,920 $ 159,008 192% ; , $ 77,179 93% ; ($5,741): A Expecting less volume due to higher fuel prices and economic concerns B Expecting less volume due to new RV park in Redmond offering stays longer than 45 days C Investment Income projected to come in higher than budget D Projected Personnel based on vacancy savings to date es��G2� Budget to Actuals Report RV Park Reserve - Fund 619 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 20isca! Yt3ar 2.323 Budget Actuals- % Budget Actuals % Projection % $ Variance Interest on Investments 7,546 6,354 84% : 6,298 10,733 170% = 18,950 301% : 12,652: A TOTAL RESOURCES 7,546 6,354 84% 6,298 10,733 170% ; ; 18,950 301% ; 12,652: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Capital Outlay TOTAL REQUIREMENTS TRANSFERS Transfer In - RV Park Ops TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 100,000 885 1% : 100,000 5,048 5% : e 100,000 100% : B 100,000 885 1% ; 100,000 5,048 5% ; 100,000 100% Budget Actuals % Budget Actuals % Projection % $ Variance 132,042 132,042 100% : 261,750 152,579 58% : : 261,566 100% : (184); a 132,042 132,042 100% ; 261,750 152,579 58% ; , 261,566 100% ; (184); Budget Actuals % Budget Actuals % Projection % $ Variance 784,466 1,054,426 134% : 1,172,718 1,191,937 102% : : 1,191,937 102% : 19,219: (92,454) 5,469 (93,702) 5,686 , , (81,050) 12,652 132,042 132,042 261,750 152,579 , . 261,566 (184); $ 824,054 $ 1,191,937 145% ; $ 1,340,766 $ 1,350,201 101% ; ; $ 1,372,453 102% ; $31,687: A Investment Income projected to come in higher than budget B Capital Outlay appropriations are a placeholder Budget to Actuals Report Flask Management - Fund 670 FY23 YTD January 31, 2023 (unaudited) RESOURCES Workers' Compensation General Liability Unemployment Property Damage Vehicle Interest on Investments Claims Reimbursement Skid Car Training Process Fee- Events/ Parades Miscellaneous TOTAL RESOURCES REQUIREMENTS General Liability Workers' Compensation Insurance Administration Property Damage Vehicle Unemployment TOTAL REQUIREMENTS TRANSFERS Transfers Out - Vehicle Replacement TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 58.3% Year Complete Fiscal Year 2022 Budget Actuals 1 Budget Actuals .ca+. Year 2923 • Projection % $ Variance 1,120,766 944,278 323,572 393,546 227,700 101,111 25,000 10,000 1,000 1,164,543 104% 940,773 100% 334,147 103% 409,593 104% 227,700 100% 50,142 50% 1,280,876 999% 0% 1,485 149% 180 1,234,761 892,681 430,179 419,566 248,764 49,346 25,000 10,000 1,000 180 3,146,973 4,409,440 140% ; 3,311,477 714,852 58% 1,234,761 100% : 520,731 58% 892,681 100% 326,242 76% 430,179 100% i A 244,747 58% 419,566 100% I ; 145,112 58% 248,764 100% I 76,165 154% 134,010 272% 84,664! B 5,983 24% 25,000 100% - (144) -1% 2,000 20% (8,000): C I 585 59% 1,000 100% - 0% 180 100% I I i 2,034,274 61% ; , 3,388,141 102% ; 76,664; Budget Actuals % Budget Actuals • Projection % $ Variance 3,600,000 1,580,000 547,047 300,245 200,000 200,000 2,706,359 953,365 491,393 604,926 137,356 89,053 75% 60% 90% 201% 69% 45% 3,000,000 1,580,000 607,558 300,248 200,000 200,000 412,090 858,096 324,324 77,176 124,706 14% 54% I I 53% ii 26% 62% I i 0% 6,427,292 4,982,451 78% ; 5,887,806 2,100,000 2,000,000 605,841 200,000 220,000 200,000 70% : 900,000 D 127% (420,000); E 100% 1,717 67% 100,248: F 110% 1 I 1 (20,000); E 100% , 1,796,392 31% ; , 5,325,841 90% ; 561,965: Budget Actuals % Budget Actuals • Projection % $ Variance (3,500) (3,500) 100% (3,500) (2,037) 58% (3,500) (3,500) 100% (3,500) (2,037) 58% (3,500) 100% (3,500) 100% Budget Actuals Budget Actuals • Projection % $ Variance 8,329,115 (3,280,319) (3,500) 9,521,450 114% (573,012) (3,500) 7,687,180 (2,576,329) (3,500) 8,944,938 116% II 237,882 ; (2,037) $ 5,045,296 $ 8,944,938 177% $ 5,107,351 8,944,938 116% : 1,257,758: (1,937,700) 638,629; (3,500) $ 9,180,783 180% ; ; $ 7,003,738 137% ; $1,896,387: A Unemployment collected on first $25K of employee's salary in fiscal year g Investment Income projected to come in higher than budget c Skid Car training resuming; there will be revenue from public participation D Trending lower than budget E Trending higher than budget F FY22 had abnormally high property damage; anticipating less in FY23 -k Budget to Actuals Report ,�.• Health Benefits - Fund 675 FY23 YTD January 31, 2023 unaukiite' ) RESOURCES Internal Premium Charges COIC Premiums Employee Co -Pay Retiree / COBRA Premiums Prescription Rebates Interest on Investments Claims Reimbursement & Other TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2022 Fiscal Year 2023 Budget Actuals % Budget Actuais 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 11,438,034 57% 1,021,338 66% o 723,183 56% 311,387 52% P 280,620 160% 101,198 106% 109,217 199% 23,027,177 25,070,639 109% ; Projection % $ Variance 23,658,700 13,984,978 59% ; Budget Actuals 19,908,221 100% 1,547,778 100% 1,282,015 100% 595,000 100% 320,000 183% 177,660 186% o 150,000 273% 23,980,674 101% ; _a _i 145,000! A 81,974; B 95,000 P 321,974; Budget Actuals % Projection % $ Variance Health Benefits Deschutes On -Site Pharmacy Deschutes On -Site Clinic Wellness TOTAL REQUIREMENTS ; FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) TOTAL FUND BALANCE 25,140,847 2,970,575 1,141,829 171,142 24,583,764 98% 3,381,197 114% 1,190,855 104% 138,211 81% 21,597,563 3,779,608 1,212,497 179,549 11,746,695 54% : i i 21,597,563 100% 1,374,089 36% 3,779,608 100% 513,578 42% ' ! 1,212,497 100% � 78,105 44% 1 ' ! 179,549 100% 1 29,424,393 29,294,027 100% ; C -C �C 2C 26,769,217 13,712,467 51% ; , 26,769,217 100% ; Budget Actuals Budget Actuals 14,772,618 (6,397,216) 15,527,580 105% (4,223,389) Projection % $ Variance 11,925,656 11,304,191 95% ; ! P (3,110,517) 272,511 ; ri P i $ 8,375,402 $ 11,304,191 135% ; 11,304,191 (2,788,543) 95% ; (621,465)` 321,974; ! $ 8,815,139 $ 11,576,702 131% ; ; $ 8,515,648 97% ; ($299,491): 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 (?-C S coG2� Budget to Actuals Report 911- Fund 705 and 710 FY23 YTD January 31, 2023 (unaudited) RESOURCES 58.3% Year Complete Fiscal Year 2022 ' Fiscal Year 2023 I Budget Actuals Budget Actuals Property Taxes - Current Yr 9,803,579 9,931,743 101% = 10,402,834 9,864,376 95% Telephone User Tax 1,106,750 1,815,283 164% ! 1,668,000 459,654 28% State Reimbursement 60,000 123,282 205% . 810,000 30,000 4% Police RMS User Fees 236,576 237,221 100% ! 237,221 - 0% I i Contract Payments 147,956 157,552 106% , 153,292 31,120 20% User Fee 233,576 140,986 60% 140,445 72,183 51% Data Network Reimbursement 162,000 244,799 151% 120,874 44,828 37% Property Taxes - Prior Yr 115,000 92,601 81% 80,000 60,911 76% Interest on Investments 96,867 69,988 72% ' 67,515 120,559 179% Property Taxes -Jefferson Co. 38,344 37,525 98% 39,497 35,954 91% Miscellaneous 18,658 45,553 244% 25,000 19,809 79% I f TOTAL RESOURCES 12,019,306 12,896,533 107% ; 13,744,678 10,739,393 78% REQUIREMENTS Projection $ Variance ! 1 10,421,062 100% ; 18,228: A I 1,668,000 100% : - B I I 810,000 100% ! C I 237,221 100% ! -1 D 153,292 100% ; - ! 140,445 100% o 120,874 100% 80,000 100% I 209,610 310% ; 142,095! E 39,497 100% I i 25,000 100% : -' 13,905,001 101% 160,323: Budget Actuals Budget Actuals % Projection % $ Variance Expenditures - - 64,754 0% : : - 0% : 64,754: Personnel Services 1 8,005,795 7,462,327 93% . 8,606,196 4,447,446 52% I 7,473,717 87% ; 1,132,479! F Materials and Services 1 3,582,212 2,915,749 81% ! 4,088,201 2,166,539 53% = i 4,088,201 100% Capital Outlay 2,975,000 518,824 17% ; 4,950,346 826,342 17% i 5,075,000 103% i (124,654) i i I i TOTAL REQUIREMENTS : 14,563,007 10,896,900 75% : 17,709,497 7,440,327 42% 16,636,918 94% : 1,072,579: TRANSFERS Budget Actuals Budget Actuals % Projection % $ Variance Transfers in 4,804,813 4,804,813 100% ; 1,750,000 1,750,000 100%:: 1,750,000 100% Transfers Out i (4,804,813) (4,804,813) 100% a (1,809,900) (1,809,900) 100% ! ! (1,809,900) 100% 1 1 1 TOTAL TRANSFERS - 0% : (59,900) (59,900) 100% ; : (59,900) 100% ; FUND BALANCE Budget Actuals % Budget Actuals Projection % $ Variance Beginning Fund Balance 11,850,783 10,709,072 90% : 12,950,799 12,708,705 98% : : 12,708,705 98% : (242,094)1 Resources over Requirements ! (2,543,701) 1,999,633 (3,964,819) 3,299,066 1 ! (2,731,917) 1,232,902 i i i 1 I Net Transfers - In (Out) - (59,900) (59,900) (59,900) , 1 i i 1 I I TOTAL FUND BALANCE : $ 9,307,082 $ 12,708,705 137% ; $ 8,926,080 $ 15,947,871 179% ; $ 9,916,888 111% ; $990,808: A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted g Telephone tax payments are received quarterly c State GIS reimbursements are received quarterly D Invoices are mailed in the Spring E Investment Income projected to come in higher than budget F Projected Personnel savings based on FY23 average vacancy rate of 15% BOARD OF COUNTY COMMISSIONERS February 22, 2023 To: Oregon State Legislature Re: Support for Extending Sunsets for Oregon Enterprise Zone Tax Abatement Program Dear Members of the Oregon Legislature, We are writing to encourage strong support for critical bills which provide tools and encourage investments in traded sector businesses and industrial lands. Specifically, bills associated with extending the sunset date on the Enterprise Zone program and the Oregon Industrial Site Readiness program (presently SB 134, SB 135, HB 2060, HB 2061, and HB 2199). Enterprise Zones are one of the best tools Oregon, particularly rural areas in Oregon, have for attracting traded sector investments and increasing our job base by offering limited duration property tax abatements on new capital investment. The program has a demonstrated ability to create jobs, expand wealth, and enhance long-term property tax revenue. Extending the Enterprise Zone sunset Ante now also allows Creating Helpful Incentives to prod.lro LALCI R.lII 1.11C Enterprise I.JI IJC Zone J1111J1.1 lAUtl. now also idly vv.J Creating IS I I\.Irll ul Incentives Iu v�..a Semiconductors for America (CHIPS) Act applicants to include the program in applications, which increases Oregon's competitiveness in the semiconductor space. We strongly urge you to support legislation extending the sunset date for Enterprise Zones. Thank you for your consideration, The Deschutes County Board of Commissioners Anthony DeBone Chair Patti Adair Vice Chair Phil Chang Commissioner CC: Senators Lynn Findley, Tim Knopp, and Dennis Linthicum Representatives Vikki Breese Iverson, Jason Kropf, Emerson Levy, and E. Werner Reschke 1300 NW Wall Street Bend, Oregon 97703 e (541) 388-6572 board@deschutes.org (awww.deschutes.org Hunnell Road Options Feb 22, 2023 Discussion with Commissioners Option 1 - 1. Use City land located in the City or City land located in the County 2. County hire contractor/non-profit using reallocated ARPA funds to provide basic needs (trash collection, porta-potties, maybe water). a. County can require contractor to purchase insurance, name County and City as additional insureds 3. 1-year pilot with options to renew Option 2 - 1. Use County land 2. County hire contractor/non-profit using reallocated ARPA funds (unless no services will be provided) 1. Use private party land under County jurisdiction Option 4 - 1. Decline City's request 2. Respond to City about Road Dept project