The URL can be used to link to this page

2022-95-Minutes for Meeting March 15,2022 Recorded 3/15/2022vYES C0 G2-A BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 1:00 PM Recorded in Deschutes County C.12r022-9.r3 Steve Dennison, County Clerk Commissioners' Journal 03/15/2022 8:16:57 AM I S;(-o(� �I�II�I'II"I�"III'I��IIIII 2022-95 MONDAY February 28, 2022 FOR RECORDING STAMP ONLY Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Patti Adair, Anthony DeBone, and Phil Chang. Also present were Nick Lelack, County Administrator; David Doyle, County Counsel; and Sharon Keith, BOCC Executive Assistant (via Zoom conference call). This meeting was audio and video recorded and can be accessed at the Deschutes County Meeting Portal website www.deschutes.org/meeting_s CALL TO ORDER: Chair Adair called the meeting to order at 1:00 p.m. PLEDGE OF ALLEGIANCE ACTION ITEMS: 1. Deliberations for Fee and Service Changes in Cascade Disposal's Franchise Service Area in Deschutes County Solid Waste Director Chad Centola and Senior Advisor Timm Schimke presented an overview of the process and results of the testimony received at the public hearing on January 31 2022. Mr. Schmike reported on recycling services to the rural areas. Representative from Cascade Disposal commented on the universal program of service in Sunriver. Items to consider for adoption of a Board Order BOCC MEETING FEBRUARY 28, 2022 PAGE 1 OF 7 was discussed. Commissioner DeBone supports a mix of subscription services especially for yard debris. Commissioner Chang would support yard debris as subscription and glass and comingle in the universal program. Mr. Centola will draft the Order for universal service for Sunriver and will review options for glass and yard debris for subscription services. 2. Presentation: Young Audiences Administrative Analyst Laura Skundrick reported that this presentation is the result of a request from an application received from Young Audiences during the last Arts and Culture grant program. Christi Zorrilla, Program Manager, presented via Zoom conference call. Presentation is attached to the record. The Board requested a list of connections in the school community during the next application opportunity. 3. Grant Acceptance of Oregon Department of Forestry Grant for fuels reduction County Forester Ed Keith presented via Zoom conference call and reported on the grant award. Mr. Keith presented the request to apply for the grant in December for the Landscape Resiliency program through ODF. The grant award was announced to cover $6.25 million for funding for fuels reduction projects for both Deschutes County owned lands and properties of private landowners. Of that amount $109,200 will be awarded to Deschutes County for the identified fuels reduction projects on County owned land. This Deschutes County parcel was identified at the time of the application as ready for a fuels reduction project. The funds need to be expended by the end of June 2023. A match for the grant award was included for work done through Firewise Communities and fuels reduction projects on Drafter Road in La Pine. The remainder of the funds requested will be provided directly to landowners through agreements with ODF. DEBONE: Move approval of Document No. 2022-223 CHANG: Second BOCC MEETING FEBRUARY 28, 2022 PAGE 2 OF 7 Discussion: Commissioner Chang inquired on the location of the 91 acres. Commissioner Chang thanked Mr. Keith and Mr. Zimmerlee for their efforts in working with landowners to accomplish the level of this fuels reduction project. The Deschutes County parcel is in the Aspen Lakes area off Hurtley Ranch Road. Discussion held on the projects and contractor capacity for completion. Commissioner Adair thanked Mr. Keith for his work done on this application. Commissioner DeBone commented on careers available in the forest and the logging industry. VOTE: DEBONE: Yes CHANG: Yes ADAIR: Chair votes yes. Motion Carried 4. Consideration of County Administrator's signature of Document No. 2022- 101, Accepting OHA Grant Behavioral Health Director Janice Garceau and Program Manager Barrett Flesh presented the item via Zoom conference to announce the grant award received in the amount of $95,961 to provide Veterans peer support services to the community. Commissioner Chang inquired on the services provided by our Veterans Services Department vs that of the services that are provided through Behavioral Health. Ms. Garceau explained the focus at Health is to treat substance abuse and mental illness. A resolution is scheduled for Wednesday, March 2 for consideration of moving a position from limited duration to regular. The Board asked to have that Resolution pulled from the agenda until further review can occur. CHANG: Move approval of Document No. 2022-101 DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried BOCC MEETING FEBRUARY 28, 2022 PAGE 3 OF 7 5. Consideration of Board approval and Chair signature of Document No. 2022-166, Oregon Health Authority agreement #155921-4 Program Manager Dr. Rita Bacho and Public Health Supervisor Kathy Christensen presented via Zoom conference call requesting approval for an agreement with OHA that will increase funding by $431,784 to support HIV early intervention and outreach services. DEBONE: Move approval of Document No. 2022-166 CHANG: Second VOTE: DEBONE: Yes CHANG: Yes ADAIR: Chair votes yes. Motion Carried 6. Consideration of Board approval and Board signature of Document No. 2022-209, Amendment #2 to the 2021 Pacific5ource Coordinated Care Organization contract. Behavioral Health Director Janice Garceau presented the document via Zoom conference call explaining services provided through this contract. Ms. Garceau noted the time sensitivity of the agreement. This contract involves multiple partners through the coordinated care organization. DEBONE: Move approval of Document No. 2022-209 CHANG: Second VOTE: DEBONE: Yes CHANG: Yes ADAIR: Chair votes yes. Motion Carried BOCC MEETING FEBRUARY 28, 2022 PAGE 4 OF 7 7. County Treasurer and Finance Report as of January 31, 2022 Chief Financial Officer Greg Munn presented the monthly finance update. The Investment Advisory Committee meeting was held last Thursday and Mr. Munn noted the Investments policy will be updated and brought to the Board for consideration. 8. Consideration: Deschutes River Mitigation and Enhancement Committee/Appointments Associate Planner Tarik Rawlings presented for Board consideration membership appointments for the Deschutes River Mitigation and Enhancement Committee. CDD Director Peter Gutowsky reported on the funds that are directed by the committee for restoration projects in the Upper Deschutes River Basin. Commissioner DeBone asked for a copy of the bylaws for the committee to review membership. Commissioner Chang supported to move forward. Commissioner Adair supports moving forward with the membership appointments. CHANG: Move approval of committee appointments as recommended by staff DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried OTHER ITEMS: Commissioner DeBone noted a Legislative Call is scheduled tomorrow morning with Senator Findley's office. • Commissioner DeBone reported on a property clean-up project that may need environmental cleanup. BOCC MEETING FEBRUARY 28, 2022 PAGE 5 OF 7 • A request was submitted for the CORE3 Project for a letter of support of House Bill 5202. Property Manager Kristie Bollinger distributed a draft letter for the Commissioners. DEBONE: Move approval of letter of support CHANG: Second VOTE: DEBONE: Yes CHANG: Yes ADAIR: Chair votes yes. Motion Carried • Commissioner DeBone called for an opportunity to start an outreach effort to reduce the impact of the homeless population and provide coordinated services. • Commissioner Chang announced his discussions with the Forest Service and members of Congress about the concerns on the lack of access through the 4606 Road. His proposal is to create a new access point. Commissioner Adair reported on a conversation on a psychiatrist hospital opportunity as well as community needs that could be addressed. EXECUTIVE SESSION: At the time of 3:56 p.m. the Board went into Executive Session under ORS 192.660 (2) (h) Litigation. The Board came out of Executive Session at 4:22 p.m. to direct staff to proceed as discussed and to authorize County Administrator's signing authority. At the time of 4:23 p.m. the Board went into Executive Session under ORS 192.660 (2) (e) Real Property Negotiations. At the time of 4:40 p.m., the Board came out of Executive Session to proceed as discussed and authorize Property Manager for signing authority. BOCC MEETING FEBRUARY 28, 2022 PAGE 6 OF 7 Being no further items to come before the Board, the meeting was adjourned at 4:40 p.m. DATED this Day of A--c 022 for the Deschutes County Board of Commissioners. PATTI ADAIR, CHAIR PHIL CHIANG, COMMISSIONER RECORDING BOCC MEETING FEBRUARY 28, 2022 PAGE 7 OF 7 01 E S Co G A [ BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS MEETING 1:00 PM, MONDAY, FEBRUARY 28, 2022 Barnes Sawyer Rooms - Deschutes Services Bldg - 1300 NW Wall St - Bend (541) 388-6570 1 www.deschutes.org AGENDA MEETING FORMAT: The Oregon legislature passed House Bill (HB) 2560, which requires that public meetings be accessible remotely, effective on January 1, 2022, with the exception of executive sessions. Public bodies must provide the public an opportunity to access and attend public meetings by phone, video, or other virtual means. Additionally, when in -person testimony, either oral or written is allowed at the meeting, then testimony must also be allowed electronically via, phone, video, email, or other electronic/virtual means. Attendance/Participation options are described above. Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at www.deschutes.org/meetings Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to: citizeninput@deschutes.org or by leaving a voice message at 541-385- 1734. Citizen input received by noon on Tuesday will be included in the Citizen Input meeting record for topics that are not included on the Wednesday agenda. Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for consideration or who are planning to testify in a scheduled public hearing may participate via Zoom meeting. The Zoom meeting id and password will be included in either the public hearing materials or through a meeting invite once your agenda item has been included on the agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are providing testimony during a hearing, you will be placed in the waiting room until the time of testimony, staff will announce your name and unmute your connection to be invited for testimony. Detailed instructions will be included in the public hearing materials and will be announced at the outset of the public hearing. For Public Hearings, the link to the Zoom meeting will be posted in the Public Hearing Notice as well as posted on the Deschutes County website at https://www.deschutes.org/bcc/page/public- hearing-notices. CALL TO ORDER PLEDGE OF ALLEGIANCE ACTION ITEMS 1. 1:00 PM Deliberations for Fee and Service Changes in Cascade Disposal's Franchise Service Area in Deschutes County 2. 1:45 PM Presentation: Young Audiences 3. 2:15 PM Grant Acceptance of Oregon Department of Forestry Grant for fuel reduction 4. 2:25 PM Consideration of County Administrator signature of Document number 2022- 101, accepting OHA grant. 5. 2:35 PM Consideration of Board approval and Chair signature of Document #2022-166, Oregon Health Authority agreement #155921-4. 6. 2:45 PM Consideration of Board approval and Board signature of Document #2022- 209, Amendment #2 to the 2021 PacificSource Coordinated Care Organization contract. 7. 3:00 PM County Treasurer and Finance Report as of January 31, 2022. 8. 3:20 PM Consideration: Deschutes River Mitigation and Enhancement Committee / Appointments OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. EXECUTIVE SESSION At any time during the meeting, an executive session could be called to address issues relating to ORS 192.660(2)(e), real property negotiations, ORS 192.660(2)(h), litigation; ORS 192.660(2)(d), labor negotiations; ORS 192.660(2)(b), personnel issues, or other executive session categories. Executive sessions are closed to the public, however, with few exceptions and under specific guidelines, are open to the media. 9. Executive Session under ORS 192.660 (2) (h) Litigation 10. Executive Session under ORS 192.660 (2) (e) Real Property Negotiations ADJOURN February 28, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 3 Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need accommodations to make participation possible, please call (541) 617-4747. February 28, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 3 of 3 01 E S coG2� I l BOARD OF COMMISSIONERS MEETING DATE: February 28, 2022 SUBJECT: Deliberations for Fee and Service Changes in Cascade Disposal's Franchise Service Area in Deschutes County RECOMMENDED MOTION: Direct staff to prepare a Board Order to include the recycling service options selected by the Board with the deliberations that are undertaken with this agenda item. BACKGROUND AND POLICY IMPLICATIONS: Over the past 1 �/2 years, the Solid Waste Department has been working with Cascade Disposal on improvements to residential recycling collection services in their County franchise district. This effort has been motivated by recommendations in the 2019 Solid Waste Management Plan to expand residential recycling collection, a request from Sunriver Homeowners Association for assistance in finding solutions to the maintenance and operation challenges with the Sunriver Recycling Depot, and requests to provide curbside yard debris collection services to help residents develop and maintain defensible spaces for wildfire mitigation. On January 24, 2022, staff participated in a Work Session with the Board to review the history and status of recycling collection services in Deschutes County and a proposal from Cascade Disposal to expand residential recycling collection services in their franchise district as a universal service. On January 31, 2022, the Board held a public hearing to discuss and receive public testimony on the proposal from Cascade Disposal for expansion of services. The proposal includes the following elements: • Add collection of comingle and glass recycling collection in Sunriver as a weekly universal side -yard service with a rate increase of $14 per month. • Add glass and yard debris recycling collection in Cascade Disposal's Rural Service Zone as a bi-weekly universal curbside service with a rate increase of $10/month. Add comingle, glass and yard debris recycling collection in Cascade Disposal's Distant Rural Service Zone as a bi-weekly universal curbside service with a rate increase of $14/month. Seven citizens provided verbal testimony at the Public Hearing and an additional 69 written and verbal comments were received during the open record period, which closed at midnight on Monday, February 14, 2022. Written comments received during the comment period are available on the Solid Waste Department website at https•//www deschutes org/solidwaste/page/cascade-disposal-proposal-expand- residential-recyclables-collection. Testimony provided at the public hearing, written comments submitted by email and verbal comments received by phone during the open record period are summarized as follows: Sunriver Number of comments received: 44 Comments in full support of proposal: 30 Comments in opposition of proposal: 13 Specific comments regarding opposition to the proposal include: o Would support the proposal as a subscription service: 9 Rural Service Zone: • Number of comments received: 17 Respondents in full support of proposal: 5 Respondents opposing proposal: 12 Specific comments regarding opposition to the proposal include: o Would support the proposal as a subscription service: 9 o Oppose biweekly yard debris collection: 6 o Oppose biweekly glass collection: 4 Distant Rural Service Zone No comments received Outside Cascade Disposal Service District Due to misinformation that was posted on social media outside the County's control, 15 comments in full support of the service and fee proposal were received from residents in subdivisions immediately outside Cascade Disposal's franchise district south of Sunriver. Respondents were contacted to thank them for their submittal and advise them that they were outside the service district where the proposal was being considered. The Board has several options for action considering Cascade Disposal's proposal and the comments that were received: Sunriver Service Zone • No action. Side -yard waste collection service will continue as currently provided with no residential recycling collection. Residents will continue to rely on the Sunriver Recycling Depot and the County's recycling facilities for their recycling needs. • Approve services as proposed as a universal service with weekly side -yard comingle and glass collection added at an additional cost of $14/month for those residents that sign up for service. • Approve services as proposed as a subscription service where residents can select and pay for only those side -yard services they would like to receive (trash, comingle and glass collection). At this time, no subscription service fee structure has been proposed and Cascade Disposal will need to conduct an analysis to develop a proposal for subscription services. Rural Service Zone • No action. Universal service with comingle recycling collection continues as currently provided. • Approve services as proposed as a universal service with biweekly glass and yard debris collection added as part of the existing universal service program at an additional cost of $10/month for those residents that sign up for service. • Approve services as proposed as a subscription service where residents can select and pay for only those services they would like to receive (trash, comingle, glass and yard debris collection). At this time, no subscription service fee structure has been proposed and Cascade Disposal will need to conduct an analysis to develop a proposal for subscription services. Distant Rural Service Zone • No action. Waste collection services with no recycling collection continues as currently provided. • Approve services as proposed as a universal service with comingle, glass and yard debris collection added at an additional cost of $14/month for those residents that sign up for service. • Approve services as proposed as a subscription service where residents can select and pay for only those services they would like to receive (trash, comingle, glass and yard debris collection). At this time, no subscription service fee structure has been proposed and Cascade Disposal will need to conduct an analysis to develop a proposal for subscription services. Staff will return with a Board Order consistent with the Board's decision at an upcoming meeting. As noted above, no fee structure has been developed by Cascade Disposal for subscription services at this time. If the Board selects subscription service for specific zones, staff will work with Cascade Disposal to develop the appropriate fee structure for Board consideration. BUDGET IMPACTS: None. ATTENDANCE: Chad Centola, Director of Solid Waste Timm Schimke, Senior Advisor • BOARD COMMISSIONERS MEETING DATE: Monday, February 28, 2021 SUBJECT: Presentation: Young Audiences RECOMMENDED MOTION: N/A - Informational item BACKGROUND AND POLICY IMPLICATIONS: During the December 15 2021 Board of Commissioners meeting, the Board reviewed 2022 Arts & Culture Grant applications and determined awards. During that review, the Board indicated interest in having one of the applicants, Young Audiences, present to the Board during a future meeting to learn more about the organization. Young Audiences Central Oregon Program Manager Christi Zorrilla Soto will attend the Board's February 28 meeting to share information about the organization. BUDGET IMPACTS: N/A ATTENDANCE: Christi Zorrilla Soto, Central Oregon Program Manager, Young Audiences of Oregon & SW Washington Laura Skundrick, Administrative Analyst I I I H u I I IN I qq I I I im Is in ■ z 0 0 UA Ix 0 .j 94 z uj u z z 0 u V) Q@ con c Ulm am u 0 0 MGM" con 0 u E S COG�.a n c i BOARD OF As ' MEETING DATE: February 28, 2022 SUBJECT: County Treasurer and Finance Report as of January 31, 2022. RECOMMENDED MOTION: N/A. BACKGROUND AND POLICY IMPLICATIONS: See attached Treasury and Finance Report. BUDGET IMPACTS: N/A. ATTENDANCE: Greg Munn, Treasurer and Chief Financial Officer MEMORANDUM DATE: February 28, 2022 TO: Board of County Commissioners FROM: Greg Munn, Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report for January 2022 Following is the unaudited monthly finance report for fiscal year to date January 31, 2022. Treasury and Investments • The portfolio balance at the end of January was $286 million, a decrease of $3 million from December but an increase of $39 million from last year (January 2021) — most of the increase due to the receipt of $19 million in ARPA funds in May 2021. • Net investment income for the month is $130,216, approximately $28,000 more than last month and $57,000 less than January 2021. YTD earnings of $917,190 are $604,000 less than the YTD earnings last year. • All portfolio category balances are within policy limits with the exception of the LGIP due to cash for February operating needs that were not transferred to our checking account until after the end of the month. • No change in the LGIP interest rate. Benchmark returns for 24 and 36 month treasuries are up again from the prior month by 45 and 42 basis points, respectively. • Average portfolio yield is 0.60% down from 0.61% last month, • The portfolio's weighted average time to maturity is at 1.56 years (compared to 1.61 last month). pot#fotio Steaktlolitm: Pat Yatue investment Municipal Debt $ 49,590,000 1T.4°h Corporate Notes 64,102,000 22.4% Time Certificates 1,245,000 0.4% U.S. Treasuries 13,000,000 4.5% Federal Agencies 85,490,000 29.9% LGIP 60,357,322 21.1% First Interstate Bank 11,974,567 4.2% Total investments $ 285,758,889 100.0% Pot# olio by Broker $100 $86.8 C o 680 2 $60 $49.6 $30.0 S40 $24.8 S20 $7.9 $142 $ DA Moreton Robert W Piper Great Castle Oak Davidson Capital Baird &Co Sandier Pacific Markets securities Total Investment Income Less Fee: $5,000 per month Investment Income - Net Prior Year Comparison Ca"o Maximumsc U.S. Treasuries 100% LGIP ($52,713,000) 100% Federal Agencies 100% Banker's Acceptances 25% Time Certificates 50% Municipal Debt 25% Corporate Debt 25% 135,216 952,1901 (51000) (35,0091 130,216 917,190 Jan -21 187, 086 1,521,842 Yield percentages Current Month Prior Month FIB/ LGIP 0.45% 0.45% Investments ° 0.47% 0.47% Average 0.60% 0.61% �Benchniarks � .—... 24 Month Treasury 1.18% 0 45% LGIP Rate lrfty rs)36 Month Treasury 1.39% Max Weighted Average 4.789 1.56 T•tn1 Minimum Adual 0 to 30 Days 10% 25.3% Under 1 Year 251/6 43.011. Under 5 Years 100% 100.0% pate Policy _ Actual Corp Issuer 5% 3.1% Callable 25Yt° 17.9% Credit W/A AA2 AA1 #nxesdn.nt Activity Purchases in Month S - Sales/Redemptions in Month $ 2,000,000 24 Month Historic Investment Returns 3.50% 3.00% 2.50% 2.00% 1.50% 1.00% 0.50% 0.00% Feb Mar Apr May June July Aug Sept 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 350,000,000 300,000,000 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 c.{ c-I ci a —I ci c-I N N N N N N N N N N N > bO9N N T N ON > oO NU —CM> N o O _0 z a < z a g aQ NoZ . o Five Year Maturity DistributionSchedule 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 Deschutes County Investments Putcha�az anE q.1n January 2021 Portfolio ManagamenC P}lrohasfle n1&151e 10 JartOpry 2022 _ Porttolio Details - Investments January 31, 2022 Purchase Maturity Days To Ratings Coupon Par Market Book ' Broke - Data Data �t'� Maturi " Mood " a&P/FI ' Rate YTM 361 -'i Value Value Value Inv a - T, ' CUSIP Seouri[ DA DAV t0/12/202t 3/t/2022 28 AA 0.3211 a.3209934 115.000 t14,986 115,000 10856 MUN 10730 FAC 558770DS9 CITY OF MADRAS OR 3133EKCY0 Fetleral Farm Credit Bank CASTLE 11/29/2019 3/14/2022 41 All AA+ O 45 0.65949447 5,000.000 5,002,314 5,002,314 5,000,613 5,000,554 10726 FAC 3133EKCV0 Federal Farm Credit Bank CASTLE 11/21/2019 3/1 4/2022 41 All AA, 0.45 0.66643231 5,000,000 1,000,000 1,002,254 1,00200 ,1]7 10750 MCI 90520EAH4 MUFG Union Bank CASTLE 2/5/2020 4/1/2022 59 A3 A 3.15 3.t5 1.8114496 2.0375478 2,000,000 2,004.578 599 2.997,174 10720 MCI 90520EAH4 MUFG Union Bank CASTLE 10/25/2019 4/t /2022 59 A3 A AA+ 0.4995 1.72452016 1,000.000 1, 000,8]0 97,174 997, 174 10759 MCI 037833CP3 Apple Inc CASTLE 3/27/2020 5/11/2022 99 All Aa2 AA 3 1.74 2,000.000 2,Ot3.379 2, 10733 MC1 084664BT] Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 103 AA, 0.16 0.1612573 1.000.000 999.030 999 996 999,996 10886 FAC 3133ELZN7 Federal Farm Credit Bank CASTLE 12/28/2021 5/18/2022 106 Aaa A+ 0.502 0.2 1.000,000 999,580 1.000,999 10877 MUN 381 2NA44 GOLDEN ST TOBACCO SECURITI GPAC 12/8/2021 6/1/2022 120 Aa3 AA 0.25 0.18238 1,505,000 i.504.571 1,505.342 t0887 FAC 3133ELE76 Fetleral Farm Credit Bank CASTLE 12/29/2021 6/2/2022 t21 Aaa 14t All AA- 0.26 0.1821 630,000 629,]55 630,192 10888 FAC 3133ELN26 Federal Farm Credit Bank CASTLE 12/29/2021 6/22/2022 1 75 0.17 3,000,000 3,016,641 3,01950 ,476 10889 TRC 9I2828XWG U.S. Treasury GPAC 12/30/2021 6/30/2022 149 Aaa 149 AA 0.25 0.20I5796 1,500,000 1,943,741 1,933.453 10299 885 MUN 801315LU4 SAWA BARBARA CA UNIF SCH DIGPAC 12/23/2021 6/30/2022 AA 5.48 3.12 925,000 943,741 933,453 t0652 MUN 686053641 Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 149 Aa2 A-1 0.28 O 2.000,000 1, 995,439 1,997,667 1088t ATD 89233HG16 TOYOTA MOTOR CREDIT DA DAV 12/9/2021 ]/1/2022 150 P-1 AA 5 0.8062226 125, 000 I27,85M1 127,96t 10881 MUN 757889BR0 REDWOOD CITY GA SCH DIST DA DAV 2/24/2021 8/1/2022 181 0.4 0.37831926 3,000, 000 3,005,57t 3,002,900 10748 FAC 3133EKJ56 Federal Farm Credit Bank CASTLE 1/31/2020 8/30/2022 210 Aaa AA+ 1.875 0.2 3.000.000 3,023,202 3,028,887 10890 TRC 912828L24 U.S. Treasury GPAC 12/30/2021 8/31/2022 211 Aaa Aaa AA, 3.125 0.1900074 1,645,000 1,670, 288 200 10683 FAG 313383WD9 Federal Home Loan Bank GPAC 12/13/2021 9/9/2022 220 241 Aaa 1.75 0.23 3,000,000 3,023,6]3 3:029,994 10891 TRC 912828L57 U.S. Treasury GPAC 12/30/2021 9/30/2022 254 All AA+ 0.16 0.2308967 t, t40, 000 1,t36,321 1,139.435 t.139.435 10882 FAC 3133EMDA7 Federal Farm Credit Bank GPAC 12/13/2021 10/13/2022 303 Aa2 AA+ 1 0.5003903 200,000 200,210 200,827 10%90 MUN 014365D00 ALDERWOOD WA WTR & WSTWTR W B 11/12/2020 12/1/2022 311 A2 A 2.t 0.6120448 t,730,000 1,745,626 923 t,751,400 10884 M01 90520EAK7 MUFG Union Bank CASTLE 12/14/2021 12/9/2022 342 Al AA- 1.95 0.6160653 2.279,000 2.300, 149 2.307,400 10879 MO 90331HPF4 US Bank CASTLE 12/10/2021 1/9/2023 344 A2 A- 3.3 0.2702416 1,000,000 t, 021,307 1,028.540 10854 MC 06051 GE-U9 Bank of America Gorp PS e/t 6/2021 t/t 1/2023 A2 A- 3.3 2. 1200764 2,000.000 2.042,614 2.021.445 10727 MCI 06051GEU9 Bank of America Corp GAS LE 11/25/2019 1/11/2023 344 AA- 2.5 0.5547661 2,772.000 2,802, 164 2.823,156 10813 MG1 740189AGO Precision Castparts Gorp CASTLE 12/17/2020 1/15/2023 348 A2 352 A. AA+ 2.375 0.3868429 1,000,000 1,Ot5:084 1,019,157 10678 FAC 3t 35GOT94 Fetleral National Mtg Assn R W B 12/9/2021 1/19/2023 AA 0.16 0.29 2,000,000 1,990,039 1,21 10869 FAC 3133ENDQO Fetleral Farm Credit Bank GPAC 11/18/2021 2/10/2023 374 Aaa AA 0 451 0.4510338 210,000 208,492 2t 0,000 .0 0 10857 MUN 5587]ODT7 CITY OF MADRAS OR DA DAV 10/12/2021 3/l/2023 393 1.6 0.640545 2,000.000 2,011,0]8 2,023,098 10880 MCI 78015K7 G3 Royal Bank of Canada PS 12/10/2021 4/17/2023 440 A2 A 2.7 0.7306116 2,000,000 2.033,955 2,050,710 10650 MC1 46625HRL6 JPMorgan Chase - Corporate N CASTLE 10/29/2021 5/18/2023 471 A2 A- 0.375 0.3708179 2,000.000 1,984,416 2,000,000 1086] FAC 3I33ENEW6 Federal Farm Credit Bank GPAC 11/23/202t 5/23/2023 476 0.125 0.3701352 2,000,000 1.978.360 1,993,518 10866 TRC 91282CCD1 U.S. Treasury MORE 1 t/17/2021 5/31/2023 484 A- 0.7 0.7000625 215,000 212,899 2t 5,000 10838 MUN 73473RDW2 MORROW PORT TRANS FAC R W B 4/1/2021 6/1/2023 485 3.095 0.3959011 3,080,000 3,16t, 158 3,194, 001 10835 MUN 01083ID05 ALAM EDA GNTY CA JT PW RS AU CASTLE 2/24/2021 6/1/2023 485 All AA 0.28 0.28 170.000 168,428 170.000 10839 MUN 984674JZ5 MCMINNVILLE SCHOOL DIST YAk PS 6/15/2021 6/15/2023 499 Aat 4,023 2.895 830,000 831,220 842,223 10760 MUN '736746XU7 PORTLAND OR URBAN RENEWAL PS 7/14/2020 6/15/2023 499 A 5.803 2.t24649. 7.500:000 1.065.518 1,049,735 10709 MUN 29270CNU5 Bonneville Power Administrata CASTLE 7/30/2019 7/1/2023 515 Aa2 AA- 7.35 2.0306495 500,000 542,198 537.OSt 10713 MCI 361582AD1 Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 529 Aa3 AA 0.45 0.4500338 2,000,000 1,983,G26 2, 057 10868 FAC 3133ENEY2 Fedora) Farm Credit Bank GPAC t1/24/2021 7/24/2023 538 4.1 0.2302892 1,000,000 1,04 t.969 100 7,057.t00 10832 MCI 06053FAA] Bank of America Corp DA DAV 2/23/2021 7/24/2023 538 A2 Aaa A- AA+ 0.25 0.60 5,000,000 4, 997, 10769 FAG 3137EAEW Federal Home Loan Mtg Corp CASTLE 8/21/2020 8/24/2023 569 AA- 3,125 5189 0.6015789 2.500.000 2,560.5235 2,560,525 835 2,598,835 10768 MUN 6]232TBM6 OAKLAND GA REDEV SUCCES50 PS 8/21/2020 9/t/2023 577 4 0.4307542 1,000,000 1 044,540 t,057,578 t0843 MUN 0984t9MM3 BONNEVILLE & BING HAM CNTVS PS 7/28/2021 9/15/2023 591 Aaa 5 0.4793681 200,000 211.904 2t4.548 10780 MUN 476463GRO JEROME IDAHO SCHOOL DISTRII PS 10/13/2020 9/15/2023 59t All AA, 0.19 0. 1900035 2, 000, 000 t,978.246 2,000.000 10819 MCI 3133EMLEO Federal Farm Credit Bank PS 12/30/2020 9/22/2023 598 Aaa 0.25 0.4554048 2,000.000 51 7 10860 TRC 91282CDA6 U.S. Treasury MORETN 11/1/2021 9/30/2023 606 AA, 0.25 0.2801193 5,000.000 4,973:993 4.993.3 4.99],357 10794 FAG 3137EAEZ8 Federal Home Loan Mtg Corp CASTLE 11/5/2020 11/6/2023 643 AAA 0.25 0.3204397 2.000,000 1,923,993 1,967,643 1.997.400 10802 MCI 459058JM6 International Bonds for Recall CASTLE 11/24/2020 11/24/2023 661 Aaa 0.7 0.7000516 1.000,000 9863, 300 1, t0837 MUN ]3473RDH5 MORROW PORT TRANS FAG R W B 4/1/2021 12/1/2023 668 Aa2 A- AA+ t O.SSOt14 270,000 268.445 272,206 272.000 10789 MUN 014365DR8 ALDERWOOD WA WTR & WSTWI R W B 11/12/2020 12/1/2023 668 0.22 0.2148764 2.000,000 1,967.814 2.000.000 10836 MCI 31422XBV3 Federal Ag ullure Mtg Corp GPAC 3/15/2021 12/15/2023 682 A- 4.I25 O.S2t7482 2.000,000 2,10I.453 2,14t,026 10923 MC1 06051 GFBO Bank of Am rice Corp 'CASTLE 1/12/2021 1/22/2024 720 A2 A- 3.8.5 0.590 1,000,000 1,048,328 07 .190 10873 MC1 46625HJT8 JPMorgan Chase - Corporate N CASTLE 12/2/2021 2/1/2024 730 A2 AA+ 2.5 167 0.5902165 2,000,000 2.053.286 2,076.205 2 10872 FAC 3135GOV34 Federal National Mtg Assn GPAC 12/1/2021 2/5/2024 734 Aaa All AA. 3 0:9122019 2,000,000 2,059,462 2,083,384 I0862 MC1 037833CG3 Apple Inc GPAC 11/17/2021 2/9/2024 738 Aaa AA. 0.65 0.6500583 1,670.000 1,656.00 1.999,503 10867 FAC 3130APUV5 Federal Home Loan Bank DA DAV 11/23/2021 2/23/2024 752 AA 0.25 0.2620551 2,000,000 1,962,009 t,999,503 10834 MCI 3I33EMRZ7 Federal Farm Credit Bank CASTLE 2/26/2021 2/26/2024 755 Aaa 4 0.6052590 2.000,000 2.100,376 2.145,710 1085t M. 06051GFF1 Bank of Amer ca Gorp CASTLE 8/12/2021 4/1/2024 790 A2 A- AAA 2.505 0.3901753 2, 350,000 2.407,223 2, 906 10829 MUN 68607VZ73 Oregon State Lottery PS :1/26/2021 4/1/2024 790 Aa2 820 -1 AA. 0.795 0:7300606 500.000 494,325 556:722 500,]22 10874 MUN 68609TWC8 Oregon Slate Lottery R W B 12/2/2021 5/1/2024 A- 3.625 0.9770205 1,600,000 1,568,310 1,589,384 10864 MCI 46625HJX9 JPMorgan Chase - Corporate N GASTLE 11/18/2021 5/13/2024 832 A2 0.523 0.52107 t,000,000 986,709 t,000,042 t 0846 MCI 06051 GJY6 Bank of America Corp CASTLE ]/27/2021 6/14/2024 864 A2 A- 2 8 0.4052718 2,750.000 2,785,255 2,853,542 10815 MUN 625517MG9 MULTNO MAH COUNTY OR SCHOI R W B t2/30/2020 6/15/2024 865 Aa1 AA+ 1,000,000 982,660 1,000.000 10809 MUN 736688MD1 Portland Community College PS 12/17/2020 6/15/2024 865 A 0.572 0.83 0.5720012 0.480219 300,000 302, 465 10807 MUN 179198JF4 CLACKAMAS SCHOOL DISTRICT DA DAV 12/3/2020 6/t 5/2024 865 Aa1 0.G9 0.5840838 1.500,000 1 468,425 468.425 1.500,000 10785 MUN 939307KV5 Washington County SD Municipal PS 10/28/2020 5/15/2024 865 A. 0.675 0.6750364 490,000 481,327 10779 MUN 906429EE1 UNION CTY OR SCHOOL DISTRIC PS 10/8/2020 6/15/2024 865 All 0,613 0.6130311 500.000 491.120 500,000 500.000 10777 MUN 179093KQ1 CLACKAMAS SCHOOL DISTRICT PS 10/1/2020 6/15/2024 865 All 0.55 0.5500254 1,900,000 1.858.238 1,900,000 10776 MUN 568571CZ4 SILVER FALLS SD PS 9/17/2020 6/15/2024 865 All 0.583 0.5830334 1.000.000 980,780 1,000.000 10853 MUN 68583RCY6 OR ST COMMUNITY COLLEGE DI PS 8/31/2021 6/30/2024 880 AA 0.6000375 90.000 99.043 100.850 10771 MCI 68583RCT7 OR ST COMMUNITY COLLEGE DI R W B 8/27/2020 6/30/2024 880 -1 AA+ 5.66 822,992 64I,643 10782 MUN 584288ERI ME FORD OR REVENUE R W B 10/14/2020 7/15/2024 895 AA- 2 0.428396 0.4283.55 000,000 1,000, 000 9,000 10842 FAC 3133EMT51 Federal Farm Credit Bank R W S 7/t 9/2021 7/19/2024 899 Aaa AA+ 0.55 0.55 0.65 249,000 244,992 244,992 2 249,000 10848 BCD 795451AA1 SALLIE MAE GPAC 7 21/2021 7/22/2024 902 0.31 0.31 2, 000 :000 1,954,542 2,000,000 10828 MCI 3133EMNK4 Federal Farm Credit Bank DA DAV 1/22/2021 7/22/2024 902 Aaa AA+ 0.55 0.55 249,000 245,577 .000 10847 BCD 38149MXG3 GOLDMAN SACHS GPAC 7/28/2021 7/29/2024 909 A+ 2.4 0.8420282 2.000,000 2,038.255 2,0]6.746 07 .746 10858 MCI 91159HHXt US Bank PS 10/29/2021 7/30/2024 910 A2 0.55 0.55 249,000 245.564 249.000 10844 BCD 05580A678 BMW GPAC 7/30/202t 7/30/2024 9t0 912 All AA+ 2.677 0.9386601 755,000 ]711799 787,182 10811 MUN 68608USW] Oregon Stale Lottery R W B t2/17/2020 8/t/2024 9t2 A. AA+ 2.67] 0.9386565 500,000 511,870 521,313 t08t2 MUN 68608USD9 Oregon Slate Lottery R W B t2/1 ]/2020 8/1/2024 AA 0.638 0.4148774 505.000 495.183 507,792 10805 MUN 68609TZR2 Oregon State Lottery R W B 12/1/2020 8/1 /2024 912 All 2,061 0.600206 1.200.000 1,218,708 1.243,264 10786 MUN 835569GR9 SO NOMA CCD PS 10/21/2020 8/t /2024 912 Aa2 AA 0.56 0.6001 1,249:000 1,245.522 1,24.,031 10784 MUN 732098PE2 POMONA CALI UNI SCH DIST TAX PS 10/20/2020 8/1/2024 9t2 Aa3 0.55 0.55 249,000 245,522 249,000 t0849 BCD 89235MLF6 TOYOTA FINANCIAL SGS BANK GPAC 8/5/2021 8/5/2024 916 0.55 .55 0.536214 249,000 245.46I 10850 BCD 90348JR85 UBS BANK USA GPAC 8/11/2021 8/12/2024 923 2.019 0.5432498 2,000.000 2,022,027 074.170 2.074,174 10816 MC1 30231GBC5 XTO Energy Inc GPAC t2/21/2020 8/t 6/2024 927 Aa1 AA 0.4201896 1,750.000 1 1,875,501 10810 MUN 734]4TAB6 MORROW PORT TRANS FAC R W B 12/14/2020 9/t/2024 943 Aa2 3.221 0.57179 2,950,000 ,824,620 3.082,069 3,181,942 10830 MC1 22546QAP2 CREDIT SUISSE NY CASTLE 2/1/2021 9/9/2024 95t Aaa 3.625 0.48 1.000,000 980,942 1, 000,000 t270 0]75 FAC 3t34GWF84 Federal Home Loan M[g Corp CASTLE 9/9/2020 9/9/2024 951 As. 0.48 5 0.7253469 220,000 238.2300�3 244, 10781 MUN 476453GS8 JEROME IDAHO SCHOOL DISTRIC PS 10/13/2020 9/15/2024 957 Aaa 5 0.6103486 7,000,000 1,087,230 566 t,113,566 10778 MUN 4511527CO IDAHO ST BOND BANK AUTH REV PS 10/8/2020 9/15/2024 957 Aa1 0,645 0.6450337 1,000,000 977,400 1,000,000 10808 MUN 13034AL57 CALIFORNIA INFRASTRUCTURE 8GPAC 12/17/2020 10/1/2024 973 AAA 0,4401721 2,000.000 1,949, 836 1,997,848 10783 FAC 3133EMCNO Federal Farm Credit Bank CASTLE 10/16/2020 10/15/2024 987 Aaa AA. 0.4 2,000.000 1,945.047 1,999,657 10791 FAC 3134GW3W4 Federal Home Loan Mtg Corp CASTLE 10/30/2020 10/28/2024 1000 Aaa 0.41 2 0.4t63167 0.5429301 1,708,000 1,724,508 I,776,047 I0823 MCI 822582CC4 ROYAL DUTCH SHELL PLC : CASTLE 1/7/2021 11/7/2024 1010 As AA- 2 0.7055457 3.000,000 3,028,995 3.105,759 10797 MCI 822582CC4 ROYAL DUTCH SHELL PLC GPAC I1/1 W2020 11/7/2024 1010 Aa2 AA- 2,000,000 1,948,407 2,000.000 10799 FAC 3134GW7F7 Federal Home Loan Mtg Corp CASTLE 11/18/2020 1I/18/2024 1021 Aaa 0.375 0,375 920,536 944,132 10788 MUN 014365OS6 ALDERWOOD WA WTR & WSTWI R W B 11/12/2020 12/1/2024 1034 Aa2 AA + 1 0.6601532 0.570485 935.000 2,000,000 2, 062,666 939 2,000.000 108t4 MCI 931142DV2 WALMART GPAC 12/17/2020 12/15/2024 1048 Aa2 AA 2.65 0.31.9988 2,000.000 1,940.706 2,000,000 1081 Mc 3133EM LPS Federal Farm Credit Bank PS 12/30/2020 12/23/2024 1056 Aaa AA. 0.32 2.75 0:6389292 2.000,000 2, 063:446 2.122.733 10820 MCI 037833DF4 Apple Inc GPAC I2/3/2020 I/13/2025 1077 All AA, 0 2,000.000 1,949.22I :2,000.000 10821 MCI 3134GXKK9 Federal Home Loan Mtg Corp R W B 1/15/2021. 1/15/2025 1087 All A2 A- 3.I25 0.8272497 2.000,000 2.07I,247 2.134.310 10826 MC 46625HKC3 JPMorgan Chase - Corporate N CASTLE 1/11/2021 1/23/2025 1087 A- .125 3.125 0.8061136 2,000,000 2,071,241 2,135.578 10817 MCI 46625HKC3 JPMorgan Chase -Corporate N CASTLE t2/22/2020 1/23/2025 I087 A2 0.45 04523943 2,500.0.0 2,424.074 2,499.824 10792 FAC 3134CiW5Q5 Federal Homo Loan Mtg Corp GASTLE 10/30/2020 1/29/2025 1093 Aaa AA+ 0.57 0.569999 1,400,000 �79568 1,400.580 10762 FAG 3136G4E74 Federal National Mtg Assn CASTLE 7/31/2020 1/29/2025 ' 1093 An 1138 A. AA- 3 0.6490818 2,000.000 2 074 2,074.568 2.744.580 10822 MCI 12572QAG0 CME GROUP GPAC 1/4/2021 3/15/2025 1142 All AA 2.992 0.8t3784 2,000, 000 2,064, 2,t 33,846 10801 MG 3023tGBH4 XTO Energy Inc GPAC 11/19/2020 3/19/2025 1169 Aaa AAA 0.873 0.5784436 2.000.000 337 t,952.337 18618 2.O60.479 10801 MUN 98459LAAt VALE UNIVERSITY GPAC 11/18/2020 4/15/2025 1195 Aa2 'AA 1.554 0.61752" 2,000.000 1.987,279 '. 2,060.4]9 10824 MCI :1667646W9 Chevron CIIP ' .CASTLE 1/7/2021 5/t 112025 1t95 Aa2 AA 1.554 0.6470298 1,663,000 1,152,422 1.711,666 10818 MCI t66764BW9 Chevron Corp GPAC 12/28/2020 5/11/2025 ' 1216 Aaa AAA 1 0.8600191 2,400:000 2.125,618 2, I0825 MUN 626506 PX2 MULTNOMAH CO-REF-TXSL GPAC 1/21/2021 6/1/2025 1230 AA, 0.86 0.8600791 400,000 389.968 400.000 400,000 10840 MUN 498368E81 KLAMATH CNTY OR SCH DIST PS 7/t /2021 6/15/2025 0.912 0.6448704 350, 000 342,720 353, 102 t 0798 MUN 938429V6t Washington County SD Municipal PS 11/17/2020 6/15/2025 1230 All 0.95 0.6870868 t,255,000 1,224,215 1,266,094 10841 MUN 625517NE3 MILLTNOMAH COUNTY OR SCHO'CASTLE 7/t 5/2021 6/30/2025 1245 Aa2 AA 1.597 0.4700929 500.000 498, 337 1083I MUN 799055QU5 SAN MATEO GA FOSTER GIN SC DA DAV 2/t 6/202i 8/1/2025 1277 All AA 2 0.8504149 350,000 354,337 363,493 775 363,775 10787 MUN 88675ABS4 TIGARD OR WTR SYS REVENUE PS Il/8/1312020 8/1/2025 1277 Aa3 AA 0.6 0.6t01]86 2,000,000 1,933.t01 t,999,293 10766 FAC 3134GWND4 Federal Home Loan Mtq Corp CASTLE 8/t 412020 8/12/2025 1288 Aaa AA. 0,53 0.53 3,000.000 2,894,870 3,000,000 10763 FAC 3133EL3P7 Federal Farm Credit Bank R W B 8/12/2020 8/12/2025 1288 All AA+ 0.57 0.5] 3,000,000 2, 900.490 3,000,000 10764 FAC 3133EL3H5 Federal Farm Credit Bank MORETN 8/12/2020 8/12/2025 1288 All AA + 0.57 0.5901227 2,000.000 1.947,208 1.998,595 10767 FAC 3136G4L8M1 Fetleral National M[g Assn National Mfg Assn CASTLE R W B 8/18/2020 9/3/2020 8/18/2025 8/211202G t294 Aaa 129] Aaa AA+ 0.56 0.5599951 2,000,000 1,93t,980 2, 10774 FAC 3I36G4N74 F000.000 ederal Mtg Assn R W B 8/27/2020 8/21/2025 129] Aaa AA+ 0.56 0.5650922 t,000.000 90 997 970 999.822 t 0772 FAC 10765 FAG 3136G4N74 3136G4N74 Federal National Fetleral National Mig Assn MORETN 8/21/2020 8/21/2025 t297 Aaa AA. 0.56 0.56 3.000,000 1,000,000 2,897,970 3,000.000 0 0.000 1,000,000 10770 FAC 3136G4X24 Fetleral National M[g Assn PS e/28/2020 8/29/2025 1305 Aaa AA+ 0.6 0.6 0.600'006 0.6000006 1,000.000 '67.750 967.%50 1,000,000 10773 FAC 3136G4X24 Federal National M[g Assn CASTLE 8/26/2020 8/29/2025 1305 Aaa AA+ 00 5 0,55 2.,000,000 t,931,996 000,000 10793 FAC 3135GA2N0 Federal National Mtg Assn R W B t 1/4/2020 1 t/4/2025 1372 Aaa AA+ 0.5 0.5729346 2.000,000 1,925, 722 1 591 1,014,40 I0796 PAC 3135GO6G3 Federal National Mtg Assn CASTLE t1/1212020 11/7/2025 t375 Aaa AA- 1.4 1.2301048 2,000.000 1,980,480 2,012,530 t OB71 MUN 250325UL9 DESCHUTES CTY SCH DIST #1 R W B 12/7/2021 6/15/2026 6/15/2026 1595 All 1595 Aa1 1.438 t.2900015 2, 000, 000 1,976, 160 2,012.530 10870 MUN 569280EX4 Salem-Kot- School District Community College PS MORETN 12/7/2021 7/23/2021 6/15/2026 1596 All 0.899 0.8000224 1.250,000 1,2I3,038 1.255, 293 10845 MUN 736688MF6 P.mmltl EDU DISTS FF&C PENSION OI R W B 12/8/2021 6/30/2026 1610 Aaa AA 1.104 1.3861517 250,000 243,523 246,993 248,284 10875 MUN 10863 MUN 68587FAW4 68583RCV2 OR OR ST COMMUNITY COLLEGE DI GPAC 111182021 6/30/2026 1610 AaI AA+ 5.68 1,4000014 210.000 244,530 2,009,897 2,052.779 10865 MCI 037833DN7 Apple Inc GPAC 11/18/2021 9/11/2026 1683 All AA. 2.05 1.4551529 2,000,000 260.000 249,457 254.814 10876 MUN 68607DVC6 COOT -IWY USER TAX REV R W B 12/8/2021 t t/15/2026 1748 All AAA 0.934 1.366t066 0.55 60.357,322 60,357,322 60.3-,- 10078 RRP SYS10078 Local GON Investment Pool 7/1/2006 - - 1 0.55 0.55 0.55 11,974,567 11.974,567 11,974,567 1 0084 RR2 SYS10084 First l nterstate 7/l/2006 - - 1 285 758 889 285 804 558 289,438,283 Position Control Summary July - June Percent Org Jul Aug Sep Oct Nov Dec Jan Unfilled Assessor Filled 33.26 33.26 33.26 33.26: 33.26 33:26 33.26 Unfilled 2.00 2.00 2.00 2.00 2.00 2`.00 2.00 5,67% Clerk Filled 8.58 8.48 8.48 9.48 9.48 948 10.48 Unfilled 0.90 1.00 1.00 - - 4.31% BOPTA Filled 0.42 0.52 0.52 0.52 0.52 0,52 0.52 - - - 2,75% Unfilled 0,10 - - - DA Filled S1.70 54.50 5&50 55.50 55.60 54.60 56.60 Unfilled 6.30 3.50 1.50 2.50 1.50 2.50 1.00 4i669/c Tax Filled 5.50 5.50 5.50 5.50 5,50 5.50 5.50 - - - 0.00% Unfilled - - Veterans' Filled 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00% Unfilled -' - - - Property Mngt Filled 2.00 2.00 2.00 2.00 2.00 2.00 2.00 - 0,00% Total General Fund Unfilled Filled 106.46 - 109.26 - 111.26 111.26 - 111,36 110.36 113.36 Unfilled 9.30 &50 4.50 4.50 3.50 4.50 3.00 4.42%p Filled 4.60 4.60 4.60 4.60 4.60 4.60 4.60 0.00% Unfilled - Fiusticeourt nity Justice Filled E45.90 45.90 45.90 44.90 44.90 44.90 44.90 Unfilled 2:00 2.00 2.00 3:00 300 3.00 3.00 5.37% Sheriff Filled 229.75 235.75 232.75 238.75 235.25 234.25 232.25 Unfilled 27.25 21,25 24.25 18.25 21.75 24.75 26.75 9.11% Health Srvcs Filled 320.33 319.85 320.40 331.20 331.50 339.50 344.20 Unfilled 55.47 57.95 64.90 54.50 55.20 50.30 46,10 14.28% CDD Filled 61.00 61.00 56.80 56.80 58.80 58.80 57.80 Unfilled 4.00 6.00 11.20 11.20 9.20 9.20 11.20 13.11% Road filled 57.00 57.00 57.00 56.00 56.00 56.00 56.00 Unfilled - - - 1.00 1,00 1.00 1.00 1.00% Adult P&P Filled 37.60 37.60 37.60 36.85 36.85 35.85 36.85 Unfilled 3.25 3.25 3.25 4.00 4.00 5.00 4,00 9.35% Solid Waste Filled 23.00 24.00 24.00 27,00 26.00 26.00 26.00 Unfilled 2.00 4.00 4.00 1.00 2.00 2.00 2.00 8.81% Victims Assistance Filled 8.00 8.00 8,00 8.00 8.00 7.00 8.00 - - 1.00 1.79% Unfilled - - GIs Dedicated filled 2.30 2.30 2.30 2.30 2.30 2.30 2.30 _ - - 0.00% Unfilled _ - - _ Filled 9.00 9.00 9.00 9.00 9.00 8.00 9.00 Unfilled 3.50 3.50 3.50 3.50 3.50 4.50 3.50 29.14% F&Expo rce 'Filled 2.00 2.00 2.00 2.00 2.00 2.00 2.00Unfilled 0.00% Filled 21.60 19.60 21.60 21.60 20.60 21.60 20.60 Unfilled 2.40 3.40 2.40 2.40 3.40 2.40 3,40 11.86% ISF -Admin Filled 7.75 7.75 6.75 8.75 7.75 7.75 7.75 Unfilled 1.00 1.00 2.00 1.00 2.00 2.00 2.00 16.86% ISF BOCC Filled 3.00 3.00 3.00 3.00 3.00 3.00 3.00 - _ - 0.00% Unfilled - - ISF - Finance Filled 9.00 9.00 9.00 8.00 10.00 10.00 10.00 Unfilled .` 2.00 2.00 2.00 3.00 1.00 13.33% ISF - Legal Filled 7.00 7.00 7.00 6.00 6.00 . 6. 00 6.00 Unfilled - - - 1.00 1.00 1.00 1.00 8.16% ISF - HR Filled 8.00 8.00 8.00 8.00 8.00 8.00 8.00 Unfilled': 1.00 1.00 : 1.00 1.00 1.00 1.00 1.00_ 11.11% ISF - IT Filled 15.70 15.70 15,70 15.70 15.70 16.70 16.70 - - 0.00% Unfilled ISF - Risk Filled 2.25 2.25 2.25 2.25 2.25 2.25 2.2S - 0.00% Unfilled' - - - - Total: Filled 981.24 988.56 984.91 1,001.96 999.86 1,004.86 1,011.56 Unfilled 113.17 111.85 125.00 109.35 111.55 111.65 107.95 % Unfilled 10.34% 10.16% 11.26% 9.84% 10.04% 10.00% 9.64% 10.18% Budget to Actuals Report General Fund Revenue YTD in the General Fund is $35.7 million or 88% of budget, a $800,000 increase from the prior month. By comparison, last year revenue YTD was $40.5 million and 108% of budget. This year's YTD revenue collections would be greater except for one-time, unbudgeted CARES Act funds received last year in the General Fund. Expenses YTD are $23.8 million and 55% of budget compared to $28.8 million and 72% of budget last year. Overall expenses are lower this year and represent a smaller portion of the budget this year due to unbudgeted CARES Act expenditures last year offset by an increase in the approved budget transfers this year which are made on a regular monthly basis. Beginning Fund Balance is $15M or 111.3% of the budgeted $13.51VI beginning fund balance. ss.3°r° County Wide Financial Dashboard 001 - General Fund 7 Year Complete Fund `:elect all (Blank) 001 -General Fund 010 - Assmt-Clerk... 020 - Code Abate... 030 - Community ... 040 - Court Techn... 050- Economic D... 060 - General Cot 070 - General C c tt— oqo - Project Dev... 120 Law Library 130 - Park ACquki... 132 - Park [hvelo_. Monthly GL Per... - 0 7 $11.0M (Blank) All Maior Funds -------------- Budget to Actuals; Requirements Resources Beginning Working Capital Budget to Actuals by Category GActuals *Budyet PProjecn( f$35.7M $23.8M $15.0M so cl+ sis;e Aws m:t,a ss osu sr?_._u 55.0% 87.5% 111.3% ors u . Monthly Expenditures 722% Projected Ending Working Capital Approved FTE % of last vear budoet ,e,m Sjtif.1 ann s u *Last Year AtlueK JCL-ItYear Actuals Monthly Revenues 108.2% % of last vear budoet � Last v�=ar nctuals rD�urre„t year P.ctuals SI I.OM Budget vs I 1 6.3 V VACANT 3 99% V_'.D 96,01111/� 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, 2022. Co Budget to Actuals - Countywide Summary All Departments FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % 001 - General Fund 45,149,632 47,633,001 106% ; 40,504,168 35,532,837 88% ; 40,116,674 99% ; 030 -Juvenile 975,090 975,868 100% ; 901,143 364,075 40% 826,610 92% ; 160/170 -TRT 10,669,865 11,229,510 105% ; 11,659,435 8,844,803 76% ; 14,440,248 124% ; 200 - American Rescue 19,000,000 46,273 0% 19,000,000 19,231,147 101% ; 38,109,180 201% ; Fund 220 -Justice Court ° 489,850 501,563 102% ; 550,832 280,789 51% ; 550,767 ° 100% ; 255 - Sheriffs Office 43,449,298 44,938,851 103% ; 44,947,745 41,226,254 92% 44,941,083 100% ; 274 - Health Services 43,207,563 45,921,554 106% ; 47,513,115 29,687,241 62% ; 48,946,484 103% ; 295 - CDD 8,251,726 9,687,451 117% ; 9,580,316 6,022,231 63% ; 10,580,825 110% ; 325 - Road 20,681,110 23,538,925 114% ; 22,629,649 14,530,220 64% ; 24,016,392 106% ; 355 -Adult P&P 5,995,287 6,040,170 101% ; 5,840,250 4,431,601 76% 6,179,212 106% ; 465 - Road CIP 2,467,800 2,942,827 119% ; 2,471,190 73,504 3% 173,450 7% 610 - Solid Waste 12,077,592 13,463,285 111% ; 13,350,600 8,116,308 61% 13,403,661 100% ; 615 - Fair & Expo 1,466,050 1,791,835 122% ; 1,395,724 733,346 53% 19412,894 101% ; 616 - Annual County Fair 52,000 53,038 102% ; 1,560,500 1,913,185 123% ; 1,914,539 123% ; a 617 - Fair & Expo Capital 14,000 8,532 61% 8,544 4,302 50% ; 7,090 o 83/0 , Reserve 618 - RV Park ° 436,050 654,204 150 o ; 497,524 n 297,6.,9 o s 60 /° 639,906 129% ' ; 619 - RV Park Reserve 1,100 7,787 708% ; 7,546 3,715 49% 6,250 83% ; 670 - Risk Management 3,263,646 3,239,580 99% ; 3,146,973 1,984,799 63% ; 4,261,562 135% ; 675 - Health Benefits 21,884,538 22,761,820 104% ; 23,027,177 14,529,833 63% 23,894,030 104% ; 705 - 911 11,064,698 12,080,426 109% ; 12,019,306 10,110,643 84% 12,283,550 102% ; 999 - Other 34,434,902 36,750,860 107% ; 50,071,869 19,436,289 39% 48,237,786 96% ; TOTAL RESOURCES 285,031,797 284,267,359 100%: 310,683,606 217,354,731 70% 334,9429193 108% ; Fiscal Year 2021 Fiscal Year 2022 REQUIREMENTS Budget Actuals % Budget Actuals % Projection 001 - General Fund 27,262,513 26,227,705 96% ; 21,094,809 11,074,648 52% 20,334,699 96% ; 030 - Juvenile 7,390,349 79038,218 95% ; 7,522,365 3,881,297 52% 6,906,672 92% ; 160/170 -TRT 3,619,872 3,566,960 99% 3,358,388 2,314,734 69% 4,127,858 123% ; 200 - American Rescue 19,000,000 32,136 0% ; 38,000,000 2,315,328 6% 38,000,000 100% ; Fund 220 -Justice Court 683,508 650,926 95% a 701,142 402,657 57% 0 701,142 100% A Budget to Actuals - Countywide Summary All Departments 58.3% FY22 YTD January 31, 2022 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % 255 -Sheriff's Office 51,263,220 49,625,248 97% ; 54,162,360 29,105,318 54% 52,663,620 97% ; 274 - Health Services 52,285,174 49,994,157 96% ; 57,785,284 29,157,134 50% ; ; 54,288,666 94% ; 295 - CDD 8,474,142 8,086,137 95% ; 9,978,889 5,103,684 51% ; 9,302,223 93% ; 325 - Road 14,513,205 12,506,257 86% ; 15,024,128 7,453,516 50% ; 14,865,900 99% ; 355 - Adult P&P 7,081,268 6,365,601 90% 7,079,915 3,547,754 50% 6,492,241 92% ; 465 - Road CIP 20,036,050 11,742,022 59% ; 29,722,691 5,684,955 19% ; 25,865,989 87% ; 610 - Solid Waste 8,853,213 8,107,298 92% ; 9,709,991 4,350,829 45% 9,748,155 100% ; 615 - Fair & Expo 2,070,371 2,011,440 97% 2,504,877 1,392,342 56% 2,429,296 97% ; 616 - Annual County Fair 127,000 189,611 149% ; 1,468,131 1,265,866 86% 1,371,088 93% ; 617 - Fair & Expo Capital 401,940 90,523 23% 568,000 188 0% ; 568,000 100% ; Reserve m 618 - RV Park 543,902 512,967 94% 496,188 330,649 67% 481,209 97% ; 619 - RV Park Reserve 100,000 - 0% ; 100,000 - 0% 20,000 20% ; 670 - Risk Management 3,794,344 2,391,380 63% 4,027,292 3,802,944 94% 6,097,047 151% ; 675 - Health Benefits 23,620,173 23,336,074 99% 23,924,393 14,242,460 60% ; 23,924,393 100% ; 705 - 911 12,576,839 10,534,248 84% ; 14,563,007 6,567,292 45% 13,806,798 95% ; 999 -Other 59,118,720 32,830,422 56% ; 86,322,366 21,764,617 25% 85,665,653 99% ; TOTAL REQUIREMENTS 322,815,803 255,839,328 79% ; 388,114,216 153,758,214 40% 377,660,649 97% ; oy`��cEs`L Budget to Actuals - Countywide Summary All Departments FY22 YTD January 31, 2022 (unaudited) TRANSFERS 001 - General Fund 030 - Juvenile 160/170 - TRT 220 - Justice Court 255 -Sheriff's Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 705 - 911 999 - Other TOTAL TRANSFERS 58.3% Year Complete Fiscal Year 2021 I Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % (20,308,890) (19,944,234) 98% ; (21,927,604) (12,588,959) 57% ; 5,957,854 5,957,854 100% ; 6,249,397 3,645,474 58% ; (5,278,036) (4,963,905) 94% ; (5,757,574) (3,358,558) 58% ; 107,235 111,521 104% ; 205,956 120,141 58% ; 3,119,077 3,119,949 100% ; 3,500,737 2,133,844 61% ; 8,026,313 6,945,413 87% 6,122,830 3,571,637 58% ; (55,480) (1,104,998) 999% ; (270,622) (514,006) 190% ; (6,683,218) (6,683,218) 100% ; (11,757,547) (6,985,536) 59% ; 187,496 187,496 100% ; 471,072 274,789 58% ; 7,517,657 6,819,612 91% ; 12,193,917 4,772,011 39% ; (3,684,280) (3,684,280) 100% ; (6,029,323) (3,014,141) 50% ; 894,967 1,144,277 128% ; 800,736 529,589 66% ; 75,000 75,000 100% ; (75,000) (106,250) 142% ; 453,158 385,418 85% 728,901 425,187 58% ; (436,628) (369,173) 85% 47,958 94,641 197% ; 621,628 549,173 88% ; 132,042 77,021 58% ; (3,500) (3,500) 100% ; (3,500) (2,037) 58% ; - 0% 9,078,924 11,341,195 125% ; 15,393,726 10,925,154 71% ; (410,723) (116,400) 26,101 - (21,927,604) 100% ; 6,249,397 100% ; (6,098,758) 106% ; 205,956 100% ; 3,500,737 100% ; 6,122,830 100% ; (1,026,399) 379% ; (11,757,547) 100% ; 471,072 100% ; 12,193,917 100% ; (6,029,323) 100% ; 1,039,565 130% ; (75,000) 100% ; 831,256 114% ; 47,958 100% ; 132,042 100% ; (3,500) 100% ; - 100% ; 16,123,402 105% ; Q��TEs`°G�� Budget to Actuals - Countywide Summary All Departments FY22 YTD January 31, 2022 (unaudited) ENDING FUND BALANCE 001 - General Fund 030 -Juvenile 1601170 - 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 FUND BALANCE 58.3% Year Complete Fiscal Year 2021 1Fiscal Year 2022 Budget Actuals % Budget Actuals Projection % 9,678,629 14,990,575 155% ; 10,952,375 26,859,805 12,844,946 117% ; 616,595 965,223 157% ; 596,681 1,093,475 1,134,558 190% ; 5,484,351 6,189,395 113% ; 8,433,816 9,360,905 10,403,028 123% ; - 14,137 999% ; - 16,929,956 123,317 999% ; 57,804 - 0% 55,646 (1,728) 55,581 100% ; 13,981,322 17,266,520 123% ; 12,160,633 31,521,299 13,044,720 107% ; 5,727,266 10,689,975 187% ; 5,884,607 14,791,719 11,470,624 195% 734,798 1,749,673 238% ; 763,172 2,154,074 2,001,876 262% 2,180,473 8,566,521 393% ; 2,231,806 8,657,690 5,959,467 267% 1,816,329 2,982,055 164% ; 1,971,182 4,140,691 13,103,814 23,533,004 180% ; 5,316,460 22,693,564 719,918 3,957,273 550% ; 583,520 4,708,612 655,550 923,473 141% ; 442,256 794,065 - (109,033) 17,369 432,035 1,208,442 1,0299596 85% 1,271,108 1,458,898 43,512 - 0% ; 49,294 61,601 1,012,728 1,054,426 104% ; 824,054 !J35,162 6,465,802 9,521,450 147% ; 7,445,296 7,701,267 13,588,094 15,527,580 114% ; 13,875,402 15,814,952 6,829,277 10,709,072 157% ; 9,307,082 14,252,423 50,123,088 84,474,181 169% ; 55,847,562 93,093,507 134,027,792 214,035,094 160% ; 138,029,321 277,653,972 3,140,098 159% ; ' 10,034,382 189% ; 1,583,456 271% ; 946,636 214% ; 359,418 999% ; 1,299,942 102% ; I 206,655 419%� ; 1,172,718 142% ' 7,682,465 103% ; 15,497,217 112% ; 9,185,824 99% ; 56,387,022 101 % ; 164,533,948 119% ; Q�1�v(ES CpG2< Budget to Actuals Report General Fund - Fund 001 58.3% FY22 YTD January 31, 2022 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current 30,105,307 30,896,789 103% ; 32,410,716 30,913,586 95% 32,464,815 100% 54,099: A Property Taxes - Prior 358,000 683,563 191 % ! 460,000 218,867 48% 460,000 100% Other General Revenues 10,450,871 10,355,769 99% 2,689,926 2,102,831 78% 2,592,810 96% (97,116); B Assessor 836,713 1,291,220 154% 987,411 466,571 47% a 987,411 100% o Clerk 2,153,741 3,168,198 147% 2,741,215 1,441,884 53% 2,541,215 93% (200,000); C BOPTA � 12,220 19,236 157% = 14,588 7,087 49% 14,588 100% -� ' District Attorney 467,138 426,613 91% 448,201 120,205 27% 303,724 68% (144,477); D Tax Office 419,927 510,878 122% a 341,004 187,135 55% 341,004 100% Veterans 223,715 158,931 71% 259,107 45,505 18% 259,107 100% - E Property Management 122,000 121,804 100% 152,000 29,167 19% _ 152,000 100% F TOTAL RESOURCES 45,149,632 47,633,001 106% ; 40,504,168 35,532,837 88% 40,116,674 99% (387,494); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Assessor 5,237,507 4,897,531 94% 5,454,784 2,993,767 55% 5,454,784 100% - G Clerk 2,051,015 1,882,622 92% 2,080,739 871,955 42% 2,080,739 100% H BOPTA 79,945 76,042 95% 82,911 47,232 57% 82,911 100% District Attorney 8,234,075 8,157,354 99% 9,715,707 4,906,639 51% 8,960,798 92% 754,909!1 Medical Examiner 236,358 220,618 93% 242,652 100,147 41% 242,652 100% Tax Office 1,016,608 989,386 97% 932,570 557,713 60% 932,570 100% Veterans 687,678 610,692 89% 795,189 404,425 51% 788,849 99% 6,340, J Property Management 332,533 312,615 94% 376,061 211,569 56% 377,200 100% (1,139). K Non -Departmental 9,386,794 9,080,846 97% 1,414,196 981,202 69% 1,414,196 100% TOTAL REQUIREMENTS ; 27,262,513 26,227,705 96% 21,094,809 11,074,648 52% ; 20,334,699 96% ; 760,110, TRANSFERS Transfers In Transfers Out TOTAL TRANSFERS FUND BALANCE Beginning Fund Balance Resources over Requirements Net Transfers - In (Out) Budget Actuals % Budaet Actuals % Projection % $ Variance 260,000 260,000 100% a 260,000 151,662 58% 260,000 100% o a L (20,568,890) (20,204,234) 98% (22,187,604) (12,740,621) 57% (22,187,604) 100% (20,308,890) (19,944,234) 98% ; (21,927,604) (12,588,959) 57% ; ; (21,927,604) 100% ; Budget Actuals % Budget 12,100,400 13,529,514 112% 13,470,620 17,887,119 21,405,296 19,409,359 (20,308,890) (19,944,234) (21,927,604) TOTAL FUND BALANCE ; $ 9,678,629 $ 14,990,575 155% ; $ 10,952,375 Actuals % Projection % $ Variance 14,990,575 111% 14,990,575 111% a 1,519,955, 24,458,189 19,781,975 372,616! (12,588,959) (21,927,604) $ 26,859,805 245% ; $ 12,844,946 117% ; $1,892,571, A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted B PILT payment of $500,000 received in July 2021; Interest earnings expected to lower than budget C FY22 Recording Fees are trending less than budget D Revenue projected to be lower than budgeted due to the reduction of two State Grants along with the termination of Discovery Fee payments per the Office of Public Defense Services E Oregon Dept. of Veteran's Affairs grant reimbursed quarterly F Interfund land -sale management revenue recorded at year-end G FY22 average vacancy rate is 5.7%; however, savings are not expected at this time due to several retirements and overfills H FY22 average vacancy rate is 4.31 %; however, savings are not expected at this time due to an added FTE and a backfilled position I Projected Personnel savings based on FY22 average vacancy rate of 4.7% j Projected Personnel savings based on FY22 savings to date K Projected Personnel based on FY22 overage to date L Repayment to General Fund from Finance Reserves for ERP Implementation o vTES C 2� Budget to Actuals Report Juvenile - Fund 030 FY22 YTD January 31, 2022 (unaudited) RESOURCES OYA Basic & Diversion ODE Juvenile Crime Prev Gen Fund -Crime Prevention Leases Inmate/Prisoner Housing DOC Unif Crime Fee/HB2712 OJD Court Fac/Sec SB 1065 Interest on Investments Food Subsidy Contract Payments Miscellaneous Case Supervision Fee TOTAL RESOURCES 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 472,401 497,387 105% 432,044 127,320 29% 402,044 93% _ (30,000)a A 109,000 118,909 109% ! 100,517 31,184 31% a 100,517 100% ; 89,500 89,500 100% , 89,500 89,500 100% 0 89,500 100% 88,000 82,522 94% 88,000 52,479 60% 88,000 100% 90,000 64,350 72% 80,000 25,800 32% a 50,000 63% (30,000) B 49,339 49,339 100% , 49,339 12,616 26% 49,339 100% e C 26,000 13,503 52% 20,000 6,276 31% _ 15,000 75% (5,000); D 17,300 13,796 80% 14,243 3,871 27% 6,210 44% (8,033) 12,000 13,028 109% 12,000 4,220 35% _ 8,500 71% (3,500); E 8,000 2,795 35% 8,000 7,824 98% 10,000 125% 2,0W F 7,550 28,312 375% 7,500 2,987 40% a 7,500 100% I 6,000 2,427 I 40% - - I I I I 975,090 975,868 100% ; 901,143 364,075 40% 826,610 92% ; (74,533); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,970,797 5,762,391 97% 6,108,905 3,175,366 52% 5,563,212 91% 545,693. G Materials and Services I 1,372,016 1,233,835 90% 1,363,409 692,705 51% I 1,293,409 95% 70,000- H Capital Outlay 47,536 41 992 + 88% 50,051 13,226 26% 50,051 100% TOTAL REQUIREMENTS 7,390,349 7,038,218 95% ; 7,522,365 3,881,297 52% ; 6,906,672 92% 615,693; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 6,034,966 6,034,966 100% 6,304,397 3,677,555 58% 6,304,397 100% Transfers Out-Veh Reserve I (77,112) (77,112) 100% (55,000) (32,081) 58% I (55,000) 100% - TOTAL TRANSFERS 5,957,854 5,957,854 100% ; 6,249,397 3,645,474 58% ; 6,249,397 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,074,000 1,069,720 100% 968,506 965,223 100% 965,223 100% (3,283); I Resources over Requirements (6,415,259) (6,062,350) (6,621,222) (3,517,222) (6,080,062) 541,160� Net Transfers - In (Out) 5,957,854 5,957,854 6,249,397 3,645,474 I i 6,249,397 I I TOTAL FUND BALANCE $ 616,595 $ 965,223 157% ; $ 596,681 $ 1,093,475 183% ; $ 1,134,558 190% ; $537,877: A Quarterly reimbursement of biennial award based on actuals B Out of County Juvenile department usage of detention facility trending lower than projected at time of budgeting C Quarterly payment from Department of Corrections D Projected lower revenue due to less than budgeted state court fee program revenue E Dept. of Education subsidies for detention meals lower due to smaller population than projected at time of budgeting F Projected higher revenue due to more than budgeted community service fee -for -service projects G Projected Personnel savings based on FY22 average vacancy rate of 5.2% H Projected underspending based on FY22 trends Q 31ES ` �{ Budget to Actuals Report TRT - Fund 160/170 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Room Taxes 10,615,965 11,068,364 104% a 11,600,987 8,814,672 76% 14,390,068 124% 2,789,081, A Interest 53,900 61,146 113% 58,448 30,130 52% a 50,180 86% , (8,268); I � State Miscellaneous - 100,000 I TOTAL RESOURCES 10,669,865 11,229,510 105% ; 11,659,435 8,844,803 76% 14,440,248 124% ; 2,780,813: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance COVA 3,038,805 2,998,091 99% 3,136,659 2,167,392 69% a 3,903,621 124%, (766,962); B Interfund Contract 114,481 114,481 100% 121,817 71,060 58% 121,817 100% - C ' Software � 11,500 - 0% 45,000 46,008 102% 46,008 102% (1,008) ' Interfund Charges 35,861 35,861 I 100% 39,709 23,164 58% 39,709 100% o Administrative 15,225 4,526 30% I 15,203 7,111 47% 9 f 16,703 110% I (1,500) I Grants & Contributions I 404,000 414,000 102% - - - TOTAL REQUIREMENTS 3,619,872 3,566,960 99% 3,358,388 2,314,734 69% 4,127,858 123% ; (769,470); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer Out - RV Park (20,000) (20,000) 100% (20,000) (11,662) 58% (20,000) 100% Transfer Out - Annual Fair (75,000) (75,000) 100% (75,000) (43,750) 58% _ a (75,000) 100% Transfers Out - - (205,956) (120,141) 58% (205,956) 100% Transfer Out - F&E Reserve (453,158) (385,418) 85% (428,901) (250,187) 58% ; (531,256) 124% (102,355); D Transfer Out - Health (406,646) (406,646) o 100% (444,417) (259,238) 58 °/o (444,417) 100% -° Transfer Out - F&E � 1,171,445 ( ) 925,,,,342 054 ( ) 79% 0 (931,513) (543375 ) 58% I 1170 ( ) 126% 238,829 ( ) ! I Transfer Out - Sheriff (3,151,787) (3,151,787) I 100% , (3,651,787) (2,130,205) 58% (3,651,787) 100% TOTAL TRANSFERS ; (5,278,036) (4,963,905) 94% ; (5,757,574) (3,358,558) 58% ; ; (6,098,758) 106% ; (341,184); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,712,394 3,490,749 94% 5,890,343 6,189,395 105% 6,189,395 105% 299,052, Resources over Requirements 7,049,993 7,662,551 8,301,047 6,530,068 10,312,391 2,011,344; Net Transfers - In (Out) m (5,278,036) (4,963,905) f (5,757,574) (3,358,558) o (6,098,758) (341,184) TOTAL FUND BALANCE $ 5,484,351 $ 6,189,395 113% ; $ 8,433,816 $ 9,360,905 111% ; $ 10,403,028 123% ; $1,969,212: A Collections coming in higher than budgeted B Payments to COVA based on a percent of TRT collections C Contracted services with the Finance Department for operating TRT program D The balance of the 1 % F&E TRT is transferred to F&E reserves Q`'�3 '(ESC01" Budget to Actuals Report ARPA — Fund 200 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest - 14,137 a - 63,607 109,180 a 109,180: State & Local Coronavirus Fiscal! 19,000,000 32,136 0% 19,000,000 19,167,541 101% 38,000,000 200% 19,000,000! A Recovery Funds TOTAL RESOURCES 19,000,000 46,273 0% ; 19,000,000 19,231,147 101% ; ; 38,109,180 201% ; 19,109,180: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Services to Disproportionately - 19,444,050 102,276 1% ; 19,444,050 100% ° B Impacted Communities 19,000,000 - 0% 11,290,766 41,866 0% 11,290,766 100% _ -° C Administrative ' - 3,050,000 - 0% a 3,050,000 100% D Negative Economic Impacts � - � 32,136 999% 2,165,184 1,796,187 83% 2,165,184 100% ° E Public Health - ' 2,050,000 375,000 18% 2,050,000 100% F Infrastructure TOTAL REQUIREMENTS 19,000,000 32,136 0% 38,000,000 2,315,328 6% 38,000,000 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance - - 19,000,000 14,137 0% 14,137 0% =(18,985,863): Resources over Requirements 14,137 (19,000,000) 16,915,819 e ! 109,180 19,109,180; Net Transfers - In (Out) - TOTAL FUND BALANCE - $ 14,137 999% ; - $ 16,929,956 999% ; ; $ 123,317 999% ; $123,317: A The revenue received in FY21, but unspent at 06.30.21, was recorded as Deferred Revenue and recognized in FY22 B Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects C Administration holds the balance of the ARPA funds, as well as an approved budget analyst for ARPA reporting and administration D Majority of funding is for food programs and $100K in support of the Ronald McDonald House E 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 F Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment oy��\)IES c0&' Budget to Actuals Report Justice Court - Fund 220 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines &Fees 488,750 500,818 102% 550,000 280,767 51% 550,000 100% s Miscellaneous - 736 737 - 0% a 737 100% Interest on Investments I 1,100 9 1% 95 22 23% 30 32% _ (65), TOTAL RESOURCES 489,850 501,563 102% ; 550,832 280,789 51% ; 550,767 100% ; (65); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 531,006 519,650 98% 542,209 316,184 58% I 542,209 100% ° Materials and Services I 152,502 131,276 86% 158,933 86,473 54% 158,933 100% A TOTAL REQUIREMENTS 683,508 650,926 95% ; 701,142 402,657 57% 701,142 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - TRT - - 205,956 120,141 58% 205,956 100% I I I I I Transfers In -General Fund I 107,235 111,521 104% - - TOTAL TRANSFERS 107,235 111,521 104% ; 205,956 120,141 58% ; 205,956 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance I 144,227 37,842 26% , - - I I (150,375) 0' I 1 (65); Resources over Requirements (193,658) (149,363) i (150,310) (121,869) Net Transfers - In (Out) 107,235 111,521 ! 205,956 120,141 s 205,956 I TOTAL FUND BALANCE a $ 57,804 - 0% $ 55,646 ($ 1,728) -3% $ 55,581 100% ; ($65), A One time yearly software maintenance fee paid in July for entire fiscal year Qy`'�v'(ES CpG�< Budget to Actuals Report Sheriff's Office - Fund 255 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance LED #1 Property Tax Current 27,476,763 27,912,029 102% 28,448,529 27,200,638 96% 28,467,681 100% 19,152, A LED #2 Property Tax Current 11,092,307 11,269,119 102% a 11,813,562 11,286,675 96% 11,824,026 100% ; ; 10,464 A Sheriffs Office Revenues 4,259,128 4,693,854 110% 6 3,993,964 2,411,337 60% 4,084,166 102% 90,202, LED #1 Property Tax Prior 280,000 579,513 207% = 330,000 185,294 56% I 330,000 100% -� LED #1 Interest 1 101,100 170,066 168% ; 147,416 52,616 36% 73,350 50% (74,066); LED #2 Property Tax Prior 120,000 I 194,726 162% 145,000 76,103 52% 145,000 100% -° LED #2 Interest 120,000 72,488 60% I 69,274 13,591 20% , I 16,860 24% 1 (52,414) I LED #1 Foreclosed Properties - I 33,522 - - - LED #2 Foreclosed Properties - 13,534 - - TOTAL RESOURCES 43,449,298 44,938,851 103% ; 44,947,745 41,226,254 92% 44,941,083 100% ; (6,662); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Sheriffs Services 3,864,843 4,435,626 115% 4,002,499 2,394,864 60% a 4,072,144 102% (69,645)= Civil/Special Units 1,232,618 1,083,411 88% 1,154,204 643,151 56% 1,135,791 98% 18,413 I Automotive/Communications 3,312,477 3,184,547 , 96% 3,576,342 1,729,158 48% I 3,481,098 97% 95,2441 1 I Detective 2,515,536 2,546,467 I 101% 3,029,130 1,854,661 61% 3,124,175 103% (95,045) Patrol' 13,284,465 13,388,793 101% 14,015,461 7,507,203 54% 13,377,975 95% 637,48& Records ' 1,038,130 954,506 92% 1,025,023 446,908 44% 804,196 78% 220,827! Adult Jail I 20,347,342 18,424,567 91% 21,033,697 10,861,722 52% 19,812,947 94% 1,220,750! Court Security 490,401 413,143 84% 444,617 247,574 56% 430,409 97% 14,208 Emergency Services � 543,565 886,331 163% � 789,912 380,552 48% I 723,035 92% 66,877 Special Services ' 2,052,586 1,787,984 87% a 1,775,588 1,215,956 68% 2,122,159 120% ° (346,571) Training ' 1,156,993 1,186,921 103% = 1,626,207 928,207 57% 1,696,014 104% (69,807) Other Law Enforcement 1,328,675 1,331,363 I 100% ; 1,389,684 895,361 64% ' I 1,583,681 114% (193,997); I Non - Departmental 95,589 1,589 2% 299,998 - 0% 299,998 100% TOTAL REQUIREMENTS 51,263,220 49,625,248 97% 54,162,360 29,105,318 54% ; 52,663,620 97% ; 1,498,740: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In -TRT 3,151,787 3,151,787 100% 3,651,787 2,130,205 58% 0 3,651,787 100% -� Transfer In - General Fund 240,290 1 240,290 100% 121,950 71,134 58% I 121,950 100% Transfers Out - Debt Service I (273,000) (272,128) 100% (273,000) (67,495) 25% (273,000) 100% o TOTAL TRANSFERS 3,119,077 3,119,949 100% ; 3,500,737 2,133,844 61% 3,500,737 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 18,676,167 18,832,967 101% 17,874,511 17,266,520 97% 17,266,520 97% (607,991); I Resources over Requirements (7,813,922) (4,686,396) (9,214,615) 12,120,936 I I (7,722,537) 1,492,078 I I 1 Net Transfers - In (Out) I 3,119,077 3,119,949 3,500,737 2,133,844 3,500,737 .1 TOTAL FUND BALANCE ; $ 13,981,322 $ 17,266,520 123% ; $ 12,160,633 $ 31,521,299 259% ; $ 13,044,720 107% ; $884,087: Note: Vacant positions are driving projected department savings, with OT and other fluctuations causing projected budget overages A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted TES ` Budget to Actuals Report ----WoeHealthServices - Fund 274 FY22 YTD January 31, 2022 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous Federal Grants OHP Fee for Service CCBHC Grant Local Grants Environmental Health Fees Medicaid Other Patient Fees Vital Records Divorce Filing Fees State - Medicare Liquor Revenue Interest on Investments State Shared- Family Planning Interfund Contract. Gen Fund State - Medicaid/Medicare TOTAL RESOURCES 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 15,156,802 14,869,697 98% 17,097,017 11,867,841 69% o s 18,597,887 109% 1,500,870< 8,279,406 8,403,083 101% 8,947,837 6,866,603 77% ° 11,375,128 127% 2,427,291' 2,850,731 3,493,477 123% ° 4,129,465 2,320,215 56% 3,805,385 92% (324,080) 4,833,096 5,641,391 117% 3,633,483 1,796,869 49% a 42% 4,503,293 124% 2,676,724 74% 869,8% (950,427) 3,265,627 3,877,425 119% 3,627,151 1,514,886 ' 2,627,291 - 0% 200,000 8% (2,427,291); 3,639,059 3,829,781 105% 1,936,838 1,968,310 102% a 2,539,901 131% 603,063e 1,091,652 1,106,707 101% = 1,086,019 926,648 85% ` 1,172,109 108% ; 86,090 350,491 933,393 266% 1,014,100 469,297 46% 804,509 79% 6 (209,591) 965,971 1,106,718 115% 884,036 426,692 48% 0 835,452 95% _ (48,584); 672,995 483,754 72% 468,415 322,334 69% a 548,212 117% = 79,797 237,296 317,189 134% 280,000 183,503 66% 351,395 125% 71,395� 1 173,030 173,030 100% 173,030 178,331 103% _ 178,331 103% 5,301 210,287 217,833 104% 172,200 126,184 73% a 215,863 125% 43,663, 99,500 158,977 160% 157,000 96,561 62% � 177,575 113% : 20,575° 147,400 153,426 104% 156,549 56,763 36% ! 93,450 60% ; (63,099) 155,000 14.6,074 94% 152,634 63,294 41% 0 99,852 65% (52,782); 127,000 127,000 100% 127,000 127,000 100% a ' 127>000 100% 952,220 882,600 93% 843,050 375,911 45% � 644,418 76% � (198,632) 43,207,563 45,921,554 106% ; 47,513,115 29,687,241 62% ; 48,946,484 103% ; 1,433,369: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation Personnel Services - 37,622,192 - 35,975,598 96% 43,690,850 22,402,365 51% 39,928,524 91% 3,762,326a i Materials and Services 14,523,515 13,886,895 96% 13,963,434 6,727,394 48% 14,230,834 102% (267,400)i Capital Outlay 139,467 131,664 94% i31,000 0 2,,376 2 0 1 / 129,308°/ 99•0 1,692' TOTAL REQUIREMENTS ; 52,285,174 49,994,157 96% 57,785,284 29,157,134 50% 54,288,666 94% ; 3,496,618: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 5,472,710 5,472,710 100% 5,909,168 3,446,975 58% 5,909,168 100% -° Transfers In - TRT � 406,646 406,646 100% , 444,417 259,238 58% � o 444,417 100% Transfers In-OHP Mental Health 2,379,865 1,298,965 55% 58% 100% - Transfers Out (232,908) (232,908) 100% (230,755) (134,577) (230,755) TOTAL TRANSFERS 8,026,313 6,945,413 87% 6,122,830 3,571,637 58% ; 6,122,830 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 6,778,564 7,817,166 115% 10,033,946 10,689,975 107% _ 10,689,976 107% ; 656,030I Resources over Requirements (9,077,611) (4,072,603) (10,272,169) 530,107 (5,342,182) 4,929,987° Net Transfers - In (Out) 8,026,313 6,945,413 6,122,830 3,571,637 a 6,122,830 B TOTAL FUND BALANCE _ $ 5,727,266 $ 10,689,975 187% ; $ 5,884,607 $ 14,791,719 251% ; ; $ 11,470,624 195% ; $5,586,017; \31ES C-0 Budget to Actuals Report Health Services - Admin - Fund 274 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 1,237,245 2,636,157 213% 768,843 348,441 45% 1,340,510 174% ; 571,6671 A 637,740 710,308 111% 824,532 129% 186,792- B State Grant ' - ; 486,804 - ' E 0% a 35,961 7% � (450,843)' C CCBHC Grant Interest on Investments 147,400 153,426 104% 156,549 56,763 36% 93,450 60% (63,09 Other 14,391 12,622 , 88% 9,200 10,348 112% _ 12,768 139% : 3,568- 74,884 436,443 436,443! C OHP Capitation a E ' State Miscellaneous ° - 347,105 - - - TOTAL RESOURCES 1,399,036 3,149,311 225% ; 2,059,136 1,200,745 58% 2,743,664 133% ; 684,528; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,914,729 5,679,486 96% 6,784,607 3,274,583 48% 5,836,201 86% : 948,406 D Materials and Services 4,991,353 6,435,511 129% ; 5,872,706 3,320,492 57% ! 6,644,581 113% ! (771,875)! E Administration Allocation (9,645,743) (9,645,743) 100% , (10,162,921) (5,028,475) 49% (10,188,901) 100% 25,980! TOTAL REQUIREMENTS ; 1,260,339 2,469,254 196% ; 2,494,392 1,566,601 63% 2,291,881 92% ; 202,511; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (232,908) (232,908) 100% ; (219,794) (128,183) 58% (219,794) 100% TOTAL TRANSFERS (232,908) (232,908) 100% ; (219,794) (128,183) 58% ; (219,794) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance ' 2,772,840 3,322,793 120% a 3,552,000 3,769,942 106% ; 3,769,942 106% 217,942: Resources over Requirements ! 138,696 680,056 i (435,256) (365,856) ' 451,783 887,039!e Net Transfers - In (Out) (232,908) (232,908) ! (219,794) (128,183) (219,794) -, TOTAL FUND BALANCE $ 2,678,628 $ 3,769,942 141% ; $ 2,896,950 $ 3,275,903 113% ; ; $ 4,001,931 138% ; $1,104,981: A Federal grants are reimbursed on a quarterly basis and increase in projection over budget is due to an increase in FEMA funds to support COVID response. B Projections over budget include Public Health Modernization funds approved by the Board in January 2022 C Increased OHP enrollment is resulting in higher than budgeted OHP Capitation payments and less than budgeted CCBHC State Grant revenues D Personnel projections based on year to date vacancy savings and assume 3% moving forward E Expenditures projected over budget due are related to contracts for vaccine rollout under FEMA funds, which were budgeted in Personnel Q��0TES c0& Budget to Actuals Report Health Services - Behavioral Health - Fund 274 FY22 YTD January 31, 2022 (unaudited) RESOURCES State Grant OHP Capitation OHP Fee for Service Federal Grants CCBHC Grant State Miscellaneous Local Grants Medicaid Other Patient Fees Divorce Filing Fees State - Medicare Liquor Revenue Interfund Contract- Gen Fund TOTAL RESOURCES REQUIREMENTS Administration Allocation Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 10,348,047 9,920,554 96% 11,907,014 7,579,016 64% 12,402,404 104% ° 495,390, A 8,279,406 8,403,083 101% a 8,947,837 6,791,719 76% 10,938,685 122% 1,990,84& B 3,265,627 3,877,425 119% a 3,627151 1,507,868 42% _ 2,664,694 73% a (962,457); C 3,298,243 2,715,411 82% 2,725,623 1,372,399 50% 3,047,986 112% 322,363, D 2,140,487 - 0% 164,039 8% (1,976,448)' B 1,544,455 1,285,829 83% 1,934,643 882,221 46% 1,758,933 91% ' (175,710): E 1,897,762 1,717,173 90% 1,093,055 1,098,495 100% 1,382,062 126% = 289,007, F 350,491 933,393 266% E 1,014,100 469,297 46% _ 804,509 79% (209,591) G 927,605 1,076,144 116% a 682,180 392,163 57% 668,310 98% (13,870); '522,300 382,906 ° 73% , 372,115 257,692 69% a a 438,462 118% 66,347- 173,030 173,030 100% 173,030 178,331 103% 178,331 103% 5,301! 210,287 217,833 104% ; 172,200 126,184 73% o 215,863 125% a 43,663! 99,500 158,977 160% 157,000 96,561 62% 177,575 113% 20,575! 127,000 127,000 100% ; 127,000 127,000 100% 127,000 100% 31,043,753 30,988,758 100% ; 35,073,435 20,878,945 60% ; 34,968,853 100% ; (104,582); Budget Actuals % Budget Actuals % Projection % $ Variance 7,434,938 7,434,938 100% a 7,523,855 3,734,328 50% � 1 23,060,066 22,131,010 96% 26,632,065 13,837,486 52% � I 5,998,817 4,097,273 68% 4,882,963 1,896,648 39% o i1 125,267 106,122 85% 54,000 27,376 51% 36,619,088 33,769,343 92% 39,092,883 19,495,837 50% ; 7,523,855 100% 1 24,504,004 92% 2,128,061! H 1 4,568,177 94% B 1 314,786, 1 55,376 103% a 0,374 36,651,412 94% ; 2,441,471: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 2,036,117 2,036,117 100% ° 2,278,087 11,328,859 58% 2,278,087 100% 1 1 1 1 Transfers In- OHP Mental Health 2,298,179 1,217,279 53% Transfers Out 1 - - 0% (10,961) (6,394) 58% 1 (10,961) 100% 1 TOTAL TRANSFERS 4,334,296 3,253,396 75% 2,267,126 1,322,466 58% 2,267,126 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,008,705 3,397,853 113% 3,612,014 3,870,664 107% 3,870,664 107% 258,650= i Resources over Requirements (5,575,335) (2,780,585) (4,019,448) 1,383,108 (1,682,559) 2,336,889, Net Transfers - In (Out) 4,334,296 3,253,396 2,267,126 1,322,466 2,267,126 TOTAL FUND BALANCE $ 1,767,666 $ 3,870,664 219% ; $ 1,859,692 $ 6,576,237 354% ; ; $ 4,455,231 240% ; $2,595,539, A Additional funds received for Aid & Assist ($285K), Parent Child Interactive Therapy ($78K) and School Based Health Centers ($22K) B Increased OHP enrollment is resulting in higher than budgeted OHP Capitation payments and less than budgeted CCBHC State Grant revenues. CCBHC Grant is reimbursed on a quarterly basis. C A high vacancy rate and reduction in services is leading to less than budgeted fee for services D Projections include an extension of unspent funds for the Crisis Program's Bureau of Justice Assistance and SAMHSA CCBHC Expansion grants E Reduction in projected revenue associated with the I/DD local match program F Carryforward of unspent FY21 COHC Crisis Services Grant and Choice Model funds. Also includes unbudgeted 2020 Q1 COHC Covid QIM funds. G Medicaid services tracking lower than budget H Personnel projections based on year to date vacancy savings and assume 6% moving forward -(ES C-0& Budget to Actuals, Report Health Services - Public Health - Fund 274 FY22 YTD January 31, 2022 (unaudited) RESOURCES State Grant State Miscellaneous Environmental Health Fees Local Grants Vital Records Other State Shared- Family Planning Federal Grants Patient Fees OHP Fee for Service State - Medicaid/Medicare TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 4,808,755 i 4,949,143 103% 4,552,263 3,578,517 79% ; 5,370,951 118% 818,688, A 1,306,276 1,860,543 a 142% 2,194,822 1,437,994 66% 2,046,452 93% (148,370)! 1,091,652 1,106,707 101% ! 1,086,019 926,648 85% ! 1,172,109 108% ! 86,090! B 1,741,297 2,112,608 121% ! 843,783 869,815 103% ! ! 1,157,839 137% ! 314,056! C 237,296 317,189 134% ! 280,000 183,503 66% ! ! 351,395 125% ! 71,395: 23,975 17,952 75% ! 192,656 24,181 13% ! ! 154,374 80% ! (38,282)� 155,000 146,074 94% ! 152,634 63,294 41% ! ! 99,852 65% ! (52,782)= 297,609 289,822 97% ! 139,017 76,029 55% ! ! 114,797 83% ! (24,220)! 150,695 100,848 67% ! 96,300 64,642 67% ! ! 109,750 114% ! 13,450, - 7,018 ' 12,030 ! 12,030! ; 952,220 882,600 a 93% 843,050 375,911 45% ! 644,418 76% ! (198,632)! D 10,764,775 11,783,485 109% ; 10,380,544 7,607,551 73% ; 11,233,967 108% ; 853,423: Budget Actuals % Budget Actuals % Administration Allocation 2,210,805 2,210,805 100% 2,639,066 1,294,147 49% Personnel Services 8,647,397 8,165,103 94% ! 10,274,178 5,290,296 51% Materials and Services 3,533,345 3,354,111 95% ! 3,207,765 1,510,254 47% Capital Outlay 14,200 25,542 180% ! 77,000 - 0% ; TOTAL REQUIREMENTS ; 14,405,747 13,755,560 95% 16,198,009 8,094,696 50% ; Projection % $ Variance 2,665,046 101% (25,980): 9,588,319 93% 685,8% E 3,018,076 94% ! 189,689! 73,932 96% ! a 3,068, 15,345,373 95% ; 852,636: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 3,436,593 3,436,593 100% a 3,631,081 2,118,116 58% 3,631,081 100% e Transfers In -TRT 406,646 406,646 100% 444,417 259,238 58% ! ! 444,417 100% Transfers In- OHP Mental Health ! 81,686 81,686 100% ! - - 8 TOTAL TRANSFERS 3,924,925 3,924,925 100% ; 4,075,498 2,377,354 58% ; 4,075,498 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 997,019 1,096,520 110% 2,869,932 3,049,370 106% a i 3,049,370 106% 179,438- a Resources over Requirements (3,640,972) (1,972,075) (5,817,465) (487,145) ! ! (4,111,406) ! 1,706,059, Net Transfers - In (Out) ! 3,924,925 3,924,925 ! 4,075,498 2,377,354 ! ! � � a s 4,075,498 ° a a TOTAL FUND BALANCE ; $ 1,280,972 $ 3,049,370 238% ; $ 1,127,965 $ 4,939,578 438% ; $ 3,013,462 267% ; $1,885,497: Revenue over budget primarily due to additional state funds in Tobacco Prevention ($61 K), Oregon Mothers Care ($75K) and WIC ($92K), Public A Health Modernization ($544K), COVID Vaccine Delivery ($120k), and reduction in School Based Health Center funds ($73K). B Environmental Health Fee projections updated based on 2022 prepared billing statements C Includes unbudgeted 2020 Q1 COHC Covid QIM funds ($210K) D Medicaid/Medicare services tracking lower than budgeted E Personnel projections based on year to date vacancy savings and assume 3% moving forward -(ES C-0Gz' Budget to Actuals Report Community Development - Fund 295 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin -Operations 137,450 152,710 111% = c 138,716 80,174 58% ' 144,716 104% 6,0001 196,000° A Code Compliance 722,028 783,094 108% 842,906 601,438 71% 1,038,906 123% 447,000, B Building Safety 3,362,450 3,921,591 117% = 3,819,940 2,484,418 65% a 4,266,940 112% B Electrical 720,600 915,357 127% ! 914,750 564,918 62% 987,600 108% 72,850� Environmental On -Site � 867,700 1,118,994 129% 1,056,678 523,998 50% E 1,031,178 98% (25,500)° 164,290, B Current Planning 1 1,738,304 2,054,192 118% ; 1,980,521 1,209,040 61% ° 2,144,811 108% 117% 139,869! A Long Range Planning 703,194 741,514 105% 826,806 558,245 68% 966,675 TOTAL RESOURCES 8,251,726 9,687,451 117% ; 9,580,316 6,022,231 63% ; 10,580,825 110% ; 1,000,509: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,818,748 2,740,077 97% a 3,137,795 1,742,243 56% ! 3,005,254 96% ; 132,5411 C , 568,320 539,584 a 95% 617,012 316,666 51% 641,218 104% (24,206)= Code Compliance � 1,867,662 1,768,376 95% 2,284,444 1,177,446 52% ° 2,120,437 93% e 164,007! C Building Safety 524,979 487,253 93% 556,531 319,161 57% 549,631 99% 6,9W C Electrical i 634,452 639,025 101% ' 765,935 344,220 45% � � 637,068 83% 128,867! C Environmental On -Site 1,479,294 1,4659772 a 99% 1,769,333 904,836 51% 1,646,476 93% ! 122,857! C Current Planning 580,687 446,049 77% ` 847,839 299,112 35% 702,139 83% 145,700 C Long Range Planning TOTAL REQUIREMENTS 8,474,142 8,086,137 95% 9,978,889 5,103,684 51% 9,302,223 93% 676,666: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 100,000 - 0% 290,000 157,992 54% a 290,000 100% Transfers In - CDD Electrical 93,264 - 0% - Reserve Transfers Out (100,518) (1009518) 100% (99,360) (57,939) 58% i (99,360) 100% ; Transfers Out -CDD Reserve (148,226) (1,004,480) 678°1° ° (461,262) (614;059) 133% � � (1,217,039) 264% (755,777)� D TOTAL TRANSFERS (55,480) (1,104,998) 999% ; (270,622) (514,006) 190% ; ; (1,026,399) 379% ; (755,777); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance 1,432,367 1,749,533 122% Beginning Fund Balance 1,012,694 1,253,356 124% s , i 1,749,673 122% 317,30& , e 1,278,602 1,677, ° Resources over Requirements (222,416) 1,601,315 6 (398,573) 918,547 (270,622) (514,006) (1,026,399) (755,777) Net Transfers - In (Out) ' (55,480) (1,104,998) a TOTAL FUND BALANCE $ 734,798 $ 1,749,673 238% ; $ 763,172 $ 2,154,074 282% ; ; $ 2,001,876 262% ; $1,238,704: A YTD revenue collection is higher than anticipated due to increased building valuations YTD collection is higher than anticipated due to permitting volume and increased building valuations B revenue C Projections reflect unfilled FTE increased as Building Safety and Electrical revenues are anticipated to be higher than budget as well as underspending due D Transfer out projection to unfilled positions OTES c0G�< Budget to Actuals Report Road - Fund 325 FY22 YTD January 31, 2022 (unaudited) RESOURCES Motor Vehicle Revenue Federal - PILT Payment Other Inter -fund Services Forest Receipts Cities-Bend/Red/Sis/La Pine Sale of Equip & Material Miscellaneous Mineral Lease Royalties Interest on Investments Assessment Payments (P&I) State Miscellaneous Federal Reimbursements TOTAL RESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay TOTAL REQUIREMENTS TRANSFERS 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 14,810,507 17,342,054 117% 17,485,000 11,569,923 66% ; 19,000,000 109% ; 1,515,000, A 1,690,574 2,061,977 122% 2,096,751 2,195,918 105% 2,195,918 105% 99,167- B 1,114,070 1,198,004 108% 1,221,632 260,934 21% a 1,221,632 100% 723,085 660,298 91% 627,207 - 0% 640,441 102% a 13,234- C 85,000 627,694 163% 560,000 170,789 30% 310,0003 55%a (250,000)B D i 396,000 333,109 84% ' 449,150 246,156 55% 449,150 100% a 54,000 73,562 136% ; 67,340 43,646 65% 67,546 100% ; 20& E 60,000 51,642 86% a 60,000 7,414 12% 50,000 83% (101000)! C 114,000 65,094 57% 59,109 32,333 55% 56,310 95% (2,799); F 8,000 24,578 307% 3,460 3,107 90% 5,395 156% 11935 F - 7,048 9 - - 20,000 20,000a1 G 1,325,874 1,093,866 83% - - 20,681,110 23,538,925 114% ; 22,629,649 14,530,220 64% ; 24,016,392 106% ; 1,386,743: Budget Actuals % Budget Actuals % Projection % $ Variance 6,709,180 6,422,847 96% 6,916,229 3,865,518 56% 6,716,773 97% 199,456, H 7,753,525 6,065,466 78% 7,843,400 3,506,722 45% 7,892,013 101% (48,613)! 1 50,500 17,944 36% 264,500 81,276 31% 257,115 97% 7,386 F 14,513,205 12,506,257 86% 15,024,128 7,453,516 50% 14,865,900 99% 158,228: Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (6,683,218) (6,683,218) 100% (11,757,547) (6,985,536) 59% _ (11,757,547) 100% - TOTAL TRANSFERS (6,683,218) (6,683,218) 100% ; (11,757,547) (6,985,536) 59% ; ; (11,757,547) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,695,786 4,217,071 156% a 6,383,832 8,566,521 134% 8,566,521 134% ! 2,182,690. Resources over Requirements 6,167,905 11,032,669 7,605,521 7,076,704 9,150,492 1,544,971! Net Transfers - In (Out) (6,683,218) (6,683,218) (11,757,547) (6,985,536) (11,757,547) TOTAL FUND BALANCE ; $ 2,180,473 $ 8,566,521 393% ; $ 2,231,806 $ 8,657,690 388% ; $ 5,959,467 267% ; $3,727,661, A Updated based on YTD actuals trending higher than budgeted B Actual payment higher than budget C Based on revised projections from State D City of Bend work will not happen this FY E Parking Fees for Judicial Trailer increased over budget F Updated based on YTD actuals G New grant for Terrebonne WW Feasibility Study H Projected Personnel savings based on FY22 savings to date I Fuel costs trending higher than budgeted due to price increases o vTES C 0G �{ Budget to Actuals Report `l Adult P&P - Fund 355 58.3% FY22 YTD January 31, 2022 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance DOC Grant in Aid SB 1145 4,621,780 4,621,782 100% a 4,202,885 3,550,840 84% 4,734,453 113% = 531,568 A e CJC Justice Reinvestment 797,504 793,044 99% 781,597 446,019 57% , 871,753 112% 90,156I A DOC Measure 57 239,005 264,005 110% 255,545 244,606 96% 244,606 96% (10,939); B Probation Supervision Fees 170,000 189,458 111% ; 170,000 3,606 2% 3,607 2% _ (166,393); C State Miscellaneous - 18,453 138,000 34,559 25% 123,453 89% (14,547); D DOC-Family Sentence Alt - - a 118,250 58,958 50% ! 59,250 50% (59,000); B Gen Fund/Crime Prevention 50,000 50,000 100% a 50,000 50,000 100% 50,000 100% Interfund-Sheriff ° 50,000 55,000 110% ° 50,000 32,083 64% a I 50,000 100% Interest on Investments 37,700 43,276 115% 45,193 10,389 23% 17,010 38% (28,183). Oregon BOPPPS - - 24,281 - 0% a 24,281 100% - Electronic Monitoring Fee 10,000 3,973 40% 2,500 236 9% 300 12% (2,200)! E Probation Work Crew Fees 2,000 600 30% ' 1,500 - ° 0 /0 - 0% 1,500 , C ( )i Miscellaneous 1,000 579 58% 500 305 61% 500 100% -° State Subsidy 16,298 - 0% - - TOTAL RESOURCES 5,995,287 6,040,170 101% ; 5,840,250 4,431,601 76% 6,179,212 106% ; 338,962: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,157,473 4,950,715 96% ' 5,379,503 2,807,982 52% ' 4,809,004 89% 570,499. F Materials and Services 1,923,795 1,414,886 74% 1,700,412 739,772 44% 1,683,237 99% 17,175. G TOTAL REQUIREMENTS ; 7,081,268 6,365,601 90% ; 7,079,915 3,547,754 50% 6,492,241 92% 587,674: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% = 662,046 386,190 58% _ E 662,046 100% Transfer to Vehicle Maint (97,693) (97,693) 100% _ (190,974) (111,401) 58% (190,974) 100% TOTAL TRANSFERS 187,496 187,496 100% ; 471,072 274,789 58% ; 471,072 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,714,814 3,119,990 115% 2,739,775 2,982,055 109% 0 2,982,055 109% 0 242,280, Resources over Requirements (1,085,981) (325,431) (1,239,665) 883,847 (313,029) 926,636, Net Transfers - In (Out) 187,496 187,496 ; 471,072 274,789 471,072 a TOTAL FUND BALANCE $ 1,816,329 $ 29982,055 164% ; $ 1,971,182 $ 4,140,691 210% ; $ 3,140,098 159% ; $1,168,916: A State Dept. of Corrections and related allocations were approved at higher levels than budgeted B State Dept. of Corrections and related allocations were approved at lower levels than budgeted C State law terminates probation supervision related fees as of 1/1/22. The department ceased collection on 7/1/21 and Dept of Revenue has closed any preexisting garnished accounts. D Criminal Justice Commission Adult Treatment Court final grant award was less than budgeted E Final payments from electronic monitoring clients prior to when the division shifted to a contract program received and Dept of Revenue has closed any garnished accounts F Projected Personnel savings based on FY22 average vacancy rate of 9.3% G Projected underspending based on FY22 trends \)DES C-0G% Budget to Actuals Report Road CIP - Fund 465 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 F Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Miscellaneous 2,258,100 2,670,996 118% 2,191,461 - 0% 50,000 2% (2,141,461); A Interest on Investments 209,700 271,831 130% 279,729 73,505 26% 123,450 44% (156,279) B TOTAL RESOURCES 2,467,800 2,942,827 119% ; 2,471,190 73,504 3% ; 173,450 7% (2,297,740); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 158,465 158,465 100% a 109,870 64,091 58% 109,870 100% ' ° ' 0 25,756 119 87% 3,856,702 C Capital Outlay � 19,877,585 11,583,557 58% � 29,612,821 5,620,864 19 /° , � TOTAL REQUIREMENTS 20,036,050 11,742,022 59% ; 29,722,691 5,684,955 19%° ; 25,865,989 87% 3,856,702: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 7,517,657 6,819,612 91% 12,193,917 4,772,011 39% 12,193,917 100% - TOTAL TRANSFERS 7,517,657 6,819,612 91% ; 12,193,917 4,772,011 39% 12,193,917 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 23,154,407 25,512,586 110% 20,374,044 23,533,004 116% 0 23,533,004 116% 3,158,960. Resources over Requirements (17,568,250) (8,799,195) (27,251,501) (5,611,451) (25,692,539) 1,558,962- i Net Transfers - In (Out) 7,517,657 6,819,612 12,193,917 4,772,011 12,193,917 - TOTAL FUND BALANCE ; $ 13,103,814 $ 23,533,004 180% ; $ 5,316,460 $ 22,693,564 427% ; $ 10,034,382 189% ; $4,717,922: A Revised ODOT funding agreement reduces revenue and offsetting expense for Terrebonne Refinement Plan by $1.7 million. COVID 19 relief funding budgeted in FY 22 was received in FY 21. Reimbursable work will be reduced to $50k with remainder being pushed to FY 22. B Updated based on YTD actuals C Updated based on anticipated completion of projects in FY22 coming in under budget or delayed to FY23 gC,�vlEs COG�< Budget to Actuals Report Road CIP (Fund 465) - Capital Outlay Summary by Project 58.3% FY22 YTD January 31, 2021 (unaudited) Year Completed Fiscal Year 2022 Budget Actuals % Projection % $ Variance $ 10,000,000 $ - 0% $ 8,346,405 83% $ 1,653,595 Terrebonne Refinement Plan 67,998 74,870 - (74,870) Tumalo Road / Tumalo Place - - 16,907 16,907 (16,907) Old Bend Rdm/Tumalo Rd Inter 2,363,532 2,134,966 90% = 2,144,966 91% = 218,566 NE Negus and 17TH 2,168,940 14,396 1% 918,137 42% 1,250,803` Hunnel Rd: Loco Rd to Tumalo Rd = 108,510 64,899 60% 165,318 152% _ (56,808) Transportation System Plan Update 279,575 - 0% 50,000 18% 229,575` Gribbling Rd Bridge _ 30,462 111,092 = (111,092)s Terrebonne Wastewater Feasibility St. 1,716,142 1,391,051 81% _ 1,391,051 81% 325,091 Rickard Rd: Groff Rd to US 20 931,140 1,319,374 142% 1,319,612 142% (388,472) Paving Powell Butte Hwy 505,000 253 0% 50,000 10% 455,000 Smith Rock Way Bridge Replace 671,000 60,998 9% 564,000 84% 107,000 Deschutes Mkt Rd/Hamehook Round Paving Cottonwood: Us 97 To BSNF RR _ 618,144 499,075 81% 499,075 81% 119,069 Paving Desch Mkt Rd: Yeoman Hamehoo 310,838 - 0% - 0% = 310,838 Paving Alfalfa Mkt Rd: Mp 4 Dodds 265,000 - 0% = 265,000 100% - 200,000 - 0% 410,000 205% _ (210,000) Paving Of Hamby Rd: Us 20 To Butler Powell Butte Hwy/Butler Market RB 150,000 248 0% 60,000 40% 90,000 Wilcox Ave Bridge #2171-03 Replacem 100,000 - 0% - 0% 100,000 US 20: Cook Ave/OB Riley Rd (Tumalo 6,700,000 - 0% 6,700,000 100% - 1,250,000 - 1,200,000 96% 50,000' US 20: Tumalo Multi -Use Path Crossing _ 20,018 € 69,286 (69,286) Highway Warning Systems 2021 _ 219 = 50,000 _ (50,000), Tumalo Wastewater Feasibility Study 100,000 - 0% _ 120,400 120% _ (20,400)' FY 22 Guardrail Improvements 500,000 - = 500,000 100% ' Redmond District Local Roads 500,000 - 0% 500,000 100% - Bend District Local Roads 75,000 - 0% 120,000 160% _ (45,000) Sidewalk Ramp Improvements - 100,000 - 0% 110,000 110% (10,000) Signage Improvements TOTAL CAPITAL $ 29,612,821= $ 5,620,864 19%_ $ 25,756,119 87% $ 3,856,702 �'eVSES C,0 Budget to Actuals Report Solid Waste - Fund 610 FY22 YTD January 31, 2022 (unaudited) RESOURCES Franchise Disposal Fees Private Disposal Fees Commercial Disp. Fee Yard Debris Franchise 3% Fees Miscellaneous Interest Special Waste Recyclables Leases Equip & Material TOTAL RESOURCES 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 6,630,625 6,764,888 102% 7,124,000 4,114,978 58% 7,124,000 100% ; A 2,491,617 2,985,124 120% 2,827,000 1,874,616 66% 2,827,000 100% A 2,319,792 2,830,984 122% ° 2,686,000 1,712,758 64% 2,686,000 100% -° A 216,761 301,824 139% 300,000 162,802 54% 284,000 95% (16,000) B 280,000 389,402 I 139% = 290,000 148,161 51% a 334,000 115% 44,000: C 88,096 102,595 116% a 55,000 43,590 79% 70,200 128% 15,200- D 23,700 42,794 181% 41,599 18,160 44% 31,460 76% (10,139)' 15,000 34,292 229% 15,000 32,818 219% 0 35,000 233% a 20,000� E 12,000 11,180 93% 12,000 8,426 70% 12,000 100% a ' ' 1 1 100% 1 - 0% ° 1 100% ° - 200 - 12,077,592 13,463,285 111% ; 13,350,600 8,116,308 61% 13,403,661 100% ; 53,061: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 2,518,594 2,510,986 100% 2,754,132 1,487,594 54% a 2,754,132 100% -� Materials and Services 5,227,119 4,705,435 90% 5,651,103 2,526,257 45% 5,651,103 100% Capital Outlay 162,500 29,523 18% I 53,141 65,708 124% I I 91,305 172% (38,164)i F Debt Service 945,000 861,354 91% 1,251,615 271,269 22% 1,251,615 100% ° G TOTAL REQUIREMENTS 8,8539213 8,107,298 92% 9,709,991 4,3509829 45% ; 9,748,155 100% ; (38,164); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance SW Capital & Equipment (3,684,280) (3,684,280) 100% (6,029,323) (3,014,141) 50% (6,029,323) 100% Reserve TOTAL TRANSFERS ; (3,684,280) (3,684,280) 100% ; (6,029,323) (3,014,141) 50% ; (6,0129,323) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,179,819 2,285,566 194% 2,972,234 3,957,273 133% 3,957,273 133% 985,039 _ ! I Resources over Requirements 3,224,379 5,355,987 3,640,609 3,765,480 3,655,506 s 14,897� Net Transfers - In (Out) (3,684,280) (3,684,280) (6,029,323) (3,014,141) ; (6,029,323) -� TOTAL FUND BALANCE $ 719,918 $ 3,957,273 550% ; $ 583,520 $ 4,708,612 807% ; $ 1,583,456 271% ; $999,936, A Fiscal YTD disposal tons are typically higher in the summer with reductions in winter. YTD volumes are running over 9% higher than last year-to- date B Revenue is seasonal with higher utilization in summer months; there is a 10% reduction when comparing this fiscal YTD to the abnormally high volumes of last year-to-date C Annual fees due April 15, 2022; received year-to-date monthly installments from Republic D FY22 projection includes the unbudgeted sale of a utility terrain vehicle and electricity capital credits; miscellaneous tire and appliance revenue is slightly exceeding budget E Revenue source is unpredictable and dependent on special clean-up projects; recent large contaminated soil projects from remediation of a gas station and illegal dumping site F The new 1 ton service truck and service box ordered in FY21 was rolled into FY22 due to delayed availability G Principal and interest payments due in Nov and May for existing debt; budget includes an interest estimate for funding the Negus Transfer Station o(X\vSEs C,0G1 Budget to Actuals Report Fair &Expo -Fund 615 58.3% FY22 YTD January 31, 2022 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue Food & Beverage Rights & Signage Storage Horse Stall Rental Interfund Payment Camping Fee Interest Miscellaneous TOTAL RESOURCES REQUIREMENTS Personnel Services Personnel Services - F&B Materials and Services Materials and Services - F&B Debt Service TOTAL REQUIREMENTS 625,000 1,194,701 191% = 578,000 371,588 64% 658,000 114% 80,000: A 548,500 209,297 38% 513,500 257,754 50% 525,000 102% 11,500: A 125,000 62,500 50% 105,000 7,000 7% a 61,000 58% (44,000)� 75,000 77,897 104% = 77,500 25,175 32% 65,000 84% (12,500); 52,000 11,378 22% 71,500 48,827 68% 60,000 84% (11,500)a 30,000 226,786 756% 30,000 17,500 58% a 30,000 100% e 12,500 5,630 45% 19,500 575 3% 6,000 31% a (13,500) (2,200) 1,051 -48% 474 3,098 654% 5,340 999% a 41866 250 2,596 999% 250 1,829 732% 2,554 999% : 2,304- 1,466,050 1,791,835 122% ; 1,395,724 733,346 53% ; 1,412,894 101% ; 17,170: Budget Actuals % Budget Actuals % 840,704 1,031,160 123% 1,118,980 654,346 58% 165,518 165,801 100% 181,593 94,816 52% 702,149 576,528 82% 818,804 468,817 57% 257,600 134,431 52% 282,500 117,440 42% 104,400 103,519 99% 103,000 56,923 55% r 2,070,371 2,011,440 97% 2,504,877 1,392,342 56% ; Projection % $ Variance 1,118,980 100% 162,316 89% a 19,277- B 805,000 98% 13,804! 240,000 85% 42,500! 103,000 100% 2,429,296 97% ; 75,581, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 650,000 899,310 138% 905,769 528,360 58% 1,144,598 126% = 238,829, C Transfers In - County Fair - - a 150,000 150,000 100% 150,000 100% Transfers In - Park Fund 30,000 30,000 100% 30,000 17,500 58% a 30,000 100% Transfers In - Room Tax (as 25,744 25,744 100% 25,744 15,015 58% s 25,744 100% needed) Transfers In - General Fund 200,000 200,000 100% Transfers Out (10,777) (10,777) 100% (310,777) (181,286) 58% _ (310,777) 100% TOTAL TRANSFERS 894,967 1,144,277 128% ; 800,736 529,589 66% 1,039,565 130% ; 238,829: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 364,904 (1,199) 0% 750,673 923,473 123% 923,473 123% 172,800: Resources over Requirements (604,321) (219,605) (1,109,153) (658,997) a (1,016,402) 0 92,751 Net Transfers - In (Out) 894,967 1,144,277 800,736 529,589 1,039,565 238,829 TOTAL FUND BALANCE $ 655,550 $ 923,473 141% ; $ 442,256 $ 794,065 180% ; $ 946,636 214% ; $504,380: A Events continue to be impacted by Covid19, and is currently experiencing abnormal revenue fluctuations. F&E continues to be fluid in adapting to changing event requirements and concerns to maximize revenue opportunities safely and responsibly. g Projected Personnel based on savings to date C Room tax revenue projected to be higher than budget 0zES C OG Budget to Actuals Report L� Annual County Fair - Fund 616 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Gate Receipts - - 550,000 738,029 134% - ; 738,029 134% 188,029; ' Concessions and Catering � - - ` 385,000 526,737 137% 526,919 137% 141,919- ' Carnival - ` 330,000 415,716 126% 415,717 126% 85,7171 Commercial Exhibitors 110,000 85,100 7 7% (24,900) ' Fair Sponsorship � - 83,500 43,025 52% o 43,025 52% a (40,475); � State Grant � 52,000 53,167 102% � 52,000 53,167 102% e e 53,167 102% = � 1,167- , RIV Camping/Horse Stall Rental - - 25,500 19,944 78% 19,944 78% (5,556)° Rodeo - - 20,000 24,600 123% a 24,600 123% 4,600 Livestock Entry Fees - - !4,500, Merchandise Sales - - - 5,239 5,239 5,239 ' Interest on Investments - 129 999% ( ) - 1,628 2,800 2,800a TOTAL RESOURCES 52,000 53,038 102% ; 1,560,500 1,913,185 123% ; 1,914,539 123% ; 354,039: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 110,000 163,282 148% 155,959 18,277 12% 58,916 38% 97,043- A Materials and Services 17,000 26,328 ° 155% � 1,312,172 1,247,589 ° 95/° � 1,312,172 100% - TOTAL REQUIREMENTS 127,000 189,611 149% ; 1,468,131 1,265,866 86% 1,371,088 93% ; 97,043. TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 1 % 75,000 75,000 100% a 75,000 43,750 58% 75,000 100% Transfer Out -Fair &Expo ' - - 150,000 ( ) 150,000 ( ) 100% 150000 ( ) , 100% TOTAL TRANSFERS 75,000 75,000 100% ; (75,000) (106,250) 142% ; ; (75,000) 100% ; FUND BALANCE Budget Actuals 4! Budget Act'sals % Projection % $ Variance Beginning Fund Balance - (47,461) 999% - (109,033) (109,033) o (109,033), Resources over Requirements (75,000) (136,573) 92,369 647,319 543,451 451,082; Net Transfers - In (Out) 75,000 75,000 (75,000) (106,250) (75,000) TOTAL FUND BALANCE - ($ 109,033) $ 17,369 $ 432,035 999% ; ; $ 359,418 999% ; $342,049: A Projection reflects vacancy savings o� uTES C 0 �{ Budget to Actuals Report C,� G .�,�. Fair & Expo Capital Reserve - Fund 617 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 14,000 8,532 61% 8,544 4,302 50% a 7,090 83% (1,454). TOTAL RESOURCES 14,000 8,532 61% 8,544 4,302 50% ; 7,090 83% ; (1,454); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 235,000 16,910 7% 180,000 188 0% 180,000 100% Capital Outlay 166,940 73,613 44% 388,000 - 0% 388,000 100% A TOTAL REQUIREMENTS 401,940 90,523 23% ; 568,000 188 0% ; 568,000 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -TRT 1% 453,158 385,418 85% 428,901 250,187 58% 531,256 124% 102,355: Transfers In - Fair & Expo - - 300,000 175,000 58% ' 300,000 100% TOTAL TRANSFERS 453,158 385,418 85% 728,901 425,187 58% ; 831,256 114% ; 102,355; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,143,224 726,169 64% 1,101,663 1,029,596 93% 1,029,596 93% (72,067); Resources over Requirements a (387,940) (81,991) (559,456) 4,114 _ (560,910) (1,454) � Net Transfers - In (Out) 453,158 o 385,418 728,901 425,187 831,256 102,355; TOTAL FUND BALANCE $ 1,208,442 $ 1,029,596 85% ; $ 1,271,108 $ 1,458,898 115% ; ; $ 1,299,942 102% ; $28,834: A Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction X01ES C,0 Budget to Actuals Report RV Park - Fund 618 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 400,200 620,655 155% a 475,000 277,814 58% m 603,525 127% 128,525 RV Park Fees > 30 Days ' � 12,000 13,886 ! 116% , 10,500 6,057 58% a 12,854 122% 2,354, Washer /Dryer' 4,000 5,295 132% 5,000 2,167 43% 4,200 84% (800)! Miscellaneous 2,250 2,679 119% ! 2,500 2,207 88% 3,395 136% a 895' Vending Machines 3,000 1,229 41% 2,500 876 35% 1,502 60% (998)' Interest on Investments 7,600 1,636 22% , 2,024 336 17% 610 30% (1,414); 13,820, Cancellation Fees 5,500 8,825 160% , 152 8,, � 1 13820 i Good Sam Membership Fee 1,500 - 0% TOTAL RESOURCES 436,050 654,204 150% ; 497,524 297,609 60% ; 639,906 129% ; 142,382: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance - 113,956 58 0% _ 38,051 33% 75,9051 A Personnel Services - 321,402 291,093 91% 216,305 168,017 78% 277,231 128% (60,926); B Materials and Services 222,500 221,874 100% ° 165,927 162,573 98% 165,927 100% ° Debt Service TOTAL REQUIREMENTS 543,902 512,967 94% 496,188 330,649 67% ; 481,209 97% 14,979: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% 160,000 160,000 100% ; 160,000 100% 1 Transfers In - TRT Fund 25,000 20,000 80% 20,000 11,662 58% 20,000 100% ' Transfer Out - RV Reserve (621,628) (549,173) 880% o (132,042) (77,021) 58% a (132,042) 100% ° - TOTAL TRANSFERS (436,628) (369,173) 85% ; 47,958 94,641 197% ; ; 47,958 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance ' 587,992 227,936 39% - 1,336 (33,040) 1 , - 158,697 , 0: 1 157,361 Resources over Requirements (107,852) 141,237 Net Transfers - In (Out) (436,628) (369,173) , 47,958 94,641 1 1 47,958 1 TOTAL FUND BALANCE $ 43,512 - 0% ; $ 49,294 $ 61,601 125% ; $ 206,655 419% ; $157,361; New FTE added to the FY22 budget, which has not been filled; projection assumes position is filled in March A to budget because of the temporary help needed until FTE is filled B M&S projected exceed \31ESC-0 Budget to Actuals Report RV Park Reserve - Fund 619 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Interest on Investments 1,100 7,787 708% a 7,546 3,715 49% 6,250 83% (1,296), TOTAL RESOURCES 1,100 7,787 708% ; 7,546 3,715 49% 6,250 83% ; (1,296); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance 100,000 - 0% 100,000 - 0% 20,000 20% 80,000: A Capital Outlay TOTAL REQUIREMENTS ; 100,000 - 0% ; 100,000 - 0% 20,000 20% ; 80,000; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - RV Park Ops 621,628 549,173 88% 132,042 77,021 58% 132,042 100% TOTAL TRANSFERS 621,628 549,173 88% ; 132,042 77,021 58% 132,042 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 490,000 497,466 102% a 784,466 1,054,426 134% ; 1,054,426 134% 269,960 Resources over Requirements (98,900) 7,787 92,454 ( ) 3,715 (13,750) 78,704! Net Transfers - In (Out) 621,628 549,173 132,042 77,021 132,042 TOTAL FUND BALANCE ; $ 1,012,728 $ 1,054,426 104% ; $ 824,054 $ 1,135,162 138% ; ; $ 1,172,718 142% ; $348,664: A Capital Outlay appropriations are a placeholder and the full budgeted amount is not expected to be spent this year v(ES C-0 Budget to Actuals Report Risk Management - Fund 670 FY22 YTD January 31, 2022 (unaudited) RESOURCES Workers' Compensation General Liability Property Damage Unemployment Vehicle Interest on Investments Claims Reimbursement Skid Car Training Process Fee- Events/ Parades Miscellaneous Loss Prevention 58.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 1,188,848 1,224,408 103% 1,120,766 712,707 64% 1,120,766 100% -� i 990,628 963,201 o 97% a 944,278 548,785 58% � ' 944,278 100% .. 373,698 373,548 100% ; 393,546 238,929 61% _ 393,546 100% 323,572 315,619 98% 323,572 308,404 95% 323,572 100%! ° A 218,185 222,266 102% 227,700 132,825 58% 227,700 100% i 87,200 100,030 115% � 101,111 29,465 29% 50,450 50% � (50,661)� 50,000 39,428 79% 25,000 12,919 52% 1,200,000 999% 1,175,000- B 30,000 270 1% a 10,000 - 0% a 50 1% (9,950)! C 1,500 810 i- 54% 1,000 585 59% 1,000 100% 5 - 0% - 180 200 200� , a a � TOTAL RESOURCES 3,263,646 3,239,580 99% ; 3,146,973 1,984,799 63% 4,261,562 135% ; 1,114,589: REQUIREMENTS Budget Actuals % Budget Actuals % Workers' Compensation 1,560,000 912,395 58% 1,580,000 408,906 26% General Liability 1,100,000 466,547 42% 1,200,000 2,673,929 223% Insurance Administration 584,104 408,666 70% 547,047 286,897 52% a Property Damage 200,240 330,869 165% 300,245 285,864 95% Unemployment 200,000 98,978 49% 200,000 62,071 31% Vehicle 150,000 173,925 116% 200,000 85,277 43% TOTAL REQUIREMENTS 3,794,344 2,391,380 63% ; 4,027,292 3,802,944 94% ; Projection % $ Variance 1,400,000 89% 180,0001 3,200,000 267% (2,000,000); D 547,047 100% 550,000 183% (249,755)� E 200,000 100% 200,000 100% 6 6,097,047 151% ; (2,069,755); TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out -Vehicle Replace (3,500) (3,500) 100% _ (3,500) (2,037) 58% _ (3,500) 100% - TOTAL TRANSFERS (3,500) (3,500) 100% ; (3,500) (2,037) 58% ; ; (3,500) 100°l0 FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,000,000 8,676,750 124% ; 8,329,115 9,521,450 114% 9,521,450 114% 1,192,335: Resources over Requirements (530,698) 848,200 (880,319) (1,818,146) (1,835,485) (955,166); Net Transfers - In (Out) (3,500) (3,500) (3,500) (2,037) ; (3,500) -� TOTAL FUND BALANCE ; $ 6,465,802 $ 9,521,450 147% ; $ 7,445,296 $ 7,701,267 103% ; ; $ 7,682,465 103% ; $237,169, A Unemployment collected on first $25K of employee's salary in fiscal year B Reimbursement from excess carrier for Kozoswki lawsuit payout C Skid Car training on hold due to COVID D General Liability claims paid includes the Kozoswki lawsuit payout -- part will be reimbursed by excess carrier E Projection is based on YTD actuals which are high due to several vehicle crashes TES ` OG 2 Budget to Actuals Report . Health Benefits - Fund 675 .00 FY22 YTD January 31, 2022 (unaudited) 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,831,938 18,580,799 104% a 18,767,900 11,014,708 59% 0 18,767,900 100% 1 COIC Premiums 1,600,000 1,642,789 103% 1,589,000 843,466 53% 1,589,000 100% a ' Employee Co -Pay 1,031,400 1,205,713 117% ° 1,200,000 715,537 60% 34% a 1,200,000 610,700 100% ° 58% (449,300); A Retiree 1 COBRA Premiums 1,035,000 958,664 93% 1,060,000 356,244 57,564 29% a 98,430 49% ' (101,847)� Interest 216,200 90,000 193,598 179,184 90% 199% ° 200,277 128,000 55,779 44% 128,000 100% Prescription Rebates 80,000 1,073 1% 82,000 1,486,535 999% 1,500,000 999% 1,418,000, B Claims Reimbursement &Other 22,761,820 104% ; 23,027,177 14,529,833 63% ; 23,894,030 104% ; 866,853: TOTAL RESOURCES 21,884,538 REQUIREMENTS Health Benefits Deschutes On -Site Pharmacy Deschutes On -Site Clinic Wellness TOTAL REQUIREMENTS ; Budget Actuals % Budget 19,937,274 19,126,362 96% 19,640,847 2,417,092 2,972,758 123% ; 2,970,575 1,101,467 1,087,809 99% 1,141,829 164,340 149,145 91% 171,142 23,620,173 23,336,074 99% 23,924,393 Actuals % 12,124,381 62% 1 1 1,463,752 49% ; a 573,887 50% ° I 80,441 47% ° 14,242,460 60% ; Projection % $ Variance 19,640,847 100% C 2,970,575 i 100% 1 1 -° C 1 1,141,829 100% C 171,142 100% -° C 23,924,393 9 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 15,323,729 16,101,833 105% 14,772,618 15,527,580 105% 15,527,580 105% 754,962 866,853! Resources over Requirements ; (1,735,635) (574,254) i (897,216) ,287373 ' (30,363) _ 1 1 Net Transfers - In (Out) - 6 TOTAL FUND BALANCE $ 13,588,094 $ 15,527,580 114% ; $ 13,875,402 $ 15,814,952 114% ; ; $ 15,497,217 112% ; $1,621,815: A Experiencing a lower collection rate as some retirees have continued on the active plan as they are working in an on -call status B Stop Loss insurance reimbursements for high dollar claims; invoices are trending up due to high dollar claims, but the expected amount is unknown C Amounts are paid 1 month in arrears oy 01ES C, 2� 0 Budget to Actuals Report C� 911 -Fund 705 and 710 FY22 YTD January 31, 2022 (unaudited) RESOURCES Property Taxes - Current Yr Telephone User Tax Police RMS User Fees User Fee Data Network Reimbursement Contract Payments Property Taxes - Prior Yr Interest State Reimbursement Property Taxes - Jefferson Co. Miscellaneous TOTAL RESOURCES REQUIREMENTS 58.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 9,113,459 9,350,147 103% a 9,803,579 9,371,936 96% 9,809,150 100% 5,571� A 1,106,750 1,441,364 130% 1,106,750 454,281 41% 1,330,000 120% ° 223,2501 B 250,000 390,879 156% ° 236,576 - 0% 236,576 100% C 73,000 110,978 152% ; 233,576 7,009 3% 233,576 100% a I 55,000 96,896 176% 162,000 87,331 54% 162,000 100% 157,252 136,638 87% 147,956 26,500 18% _ 147,956 100% '90,000 152,893 170% 115,000 59,833 52% 115,000 100% ° 90,400 110,233 122% 96,867 38,927 40% 60,290 62% (36,577); 83,000 131,881 159% � 60,000 15,000 ' ` 25% � 132,000 220% ` 72,000. D 33,637 36,598 109% ° 38,344 35,153 92% 38,344 100% 12,200 121,920 999% 18,658 14,674 79% I 18,658 100% 11,064,698 12,080,426 109% ; 12,019,306 10,110,643 84% ; 12,283,550 102% ; 264,244: Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,620,458 7,190,545 94% 8,005,795 4,291,912 54% _ 7,249,586 91% 756,209: E Materials and Services � 3,476,381 2,912,246 84% 3,557,212 1,994,653 56% 3,557,212 100% Capital Outlay 1,480,000 431,457 I 29% 3,000,000 280,728 9% 3,000,000 100% TOTAL REQUIREMENTS 12,576,839 10,534,248 84% ; 14,563,007 6,567,292 45% 13,806,798 95% ; 756,209: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance �8,341,418 9,162,894 110% 11,850,783 10,709,072 90% 10,709,072 90% (1,141,710)e I Resources over Requirements (1,512,141) 1,546,177 (2,543,701) 3,543,351 (1,523,248) 1,020,453- I g I I 1 I _Net Transfers - In (Out) 1 TOTAL FUND BALANCE $ 6,829,277 $ 10,709,072 157% ; $ 9,307,082 $ 14,252,423 153% ; $ 9,185,824 99% ; ($121,258); A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted B Telephone tax increased last year and payments are received quarterly; taxes collected are trending higher than budget C Invoices are mailed in the Spring D State GIS reimbursements are received quarterly; additionally the State approved a final reimbursement for the 9-1-1 phone system E Projected Personnel savings based on FY22 average vacancy rate of 10.3% c0 MEETING DATE: February 28, 2022 SUBJECT: Consideration: Deschutes River Mitigation and Enhancement Committee / Appointments RECOMMENDED MOTION: Move approval of the Deschutes River Mitigation and Enhancement Committee -recommended member appointments as detailed in the staff memo. BACKGROUND AND POLICY IMPLICATIONS: The Deschutes River Mitigation & Enhancement (M&E) Committee has seven voting members appointed to three-year terms by the Deschutes County Board of Counry Commissioners. Four members with expired terms recently expressed interest in reappointment. The M&E Committee also nominates Ted Wise to serve on the committee as an ecological expert from Oregon Department of Fish and Wildlife (ODFW). BUDGET IMPACTS: None ATTENDANCE: Tarik Rawlings, Associate Planner MEMORANDUM TO: Deschutes County Board of County Commissioners (Board) FROM: Tarik Rawlings, Associate Planner Will Groves, Planning Manager DATE: February 22, 2022 SUBJECT: Deschutes River Mitigation and Enhancement Committee / Appointments The Deschutes River Mitigation & Enhancement (M & E) Committee has seven voting members appointed to three-year terms by the Deschutes County Board of Commissioners. Four (4) members with expired terms, Kris Knight, Patrick Griffiths, Shaun Pigott, and Craig Horrell recently expressed a desire to be reappointed. Additionally, the M & E Committee nominated Ted Wise, an ecology expert from Oregon Department of Fish and Wildlife, to fill a vacant position designated for ecology expertise. I. BACKGROUND In order to mitigate for its siphon hydropower project located upstream from Bill Healy Bridge in Bend, the Central Oregon Irrigation District (COID) signed an agreement with the Oregon Department of Fish and Wildlife (ODFW) on !!March 81, 1987, The agreement was a requirement of a County conditional use permit (CU-87-2). The goal of the agreement is to ensure that no net loss of fish, wildlife, habitats, or recreational opportunities result from construction and operation of the hydropower project. To help accomplish the goal of the agreement, managers created the Deschutes River M & E Program. The program sets general priorities for habitat mitigation and enhancement activities based on location within the upper Deschutes River. These priorities have been further refined to target key fish spawning and rearing areas and adult fish holding areas. Other program goals are described in the M & E Program Plan. The Program is consistent with other regional and statewide plans, such as the ODFW Upper Deschutes Subbasin Fish Management Plan and the Oregon Conservation Strategy. COID is required to use a portion of the revenues generated by the power plant for enhancing river habitat and water conservation improvements in the upper Deschutes basin. The M & E Committee reviews plans developed and submitted by ODFW. The program has funded and built over 60 separate fish habitat and bank stabilization projects in the upper Deschutes River basin since 1989, in addition to several feasibility studies and monitoring projects. The M & E Committee is made up of representative stakeholders, including: conservation organizations, ecology and fishery experts, members at large and COID. They oversee approximately $90,000/year of funding. 1 1 7 NW Lafayette Avenue, Bend, Oregon 97703 1 P.O. Box 6005, Bend, OR 97708-6005 Q, (541) 388-6575 @ cdd@deschutes .org ® www.deschutes.org/cd Ill. COMMITTEE MEMBERSHIP The following tables describe the current and proposed membership of the M&E Committee. As noted above, Staff recommends the Board reappoint Kris Knight, Patrick Griffiths, and Shaun Pigott each to a three-year term (February 28, 2025), reappoint Craig Horrell to a three-year term retroactive to February 28, 2020 (February 28, 2023), and appoint Ted Wise to a three-year term (February 28, 2025). Voting Members Kate Fitzpatrick - Chair Member at Large - Deschutes River Conservancy Term ends: February 28, 2023 Patrick Griffiths Member at Large - City of Bend Utility Department Water Resources Manager Reappointment requested Craig Horrell COID - District Manager Reappointment requested Ted Wise Ecology Expertise - ODFW Requested for appointment Shaun Pigott Fisheries Expertise -Trout Unlimited Reappointment requested William Seitz Fisheries Expertise - Retired fish and wildlife biologist Term ends: February28, 2023 Kris Knight Conservation Organization - Upper Deschutes Watershed Council Reappointment requested pp q Non -voting Members Jackson Morgan Department of State Lands Sam Vanlaningham Oregon Water Resources Department Jason Gritzner U.S. Forest Service Tarik Rawlings Deschutes County - CDD Oregon Department of Fish and Wildlife Member Jerry George ODFW M & E Coordinator III. STAFF RECCOMENDATION Staff recommends the Board reappoint Kris Knight, Patrick Griffiths, and Shaun Pigott each to a three- year term (February 28, 2025), reappoint Craig Horrell to a three-year term retroactive to February 28, 2020 (February 28, 2023), and appoint Ted Wise to a three-year term (February 28, 2025). Page 2 of 2