The URL can be used to link to this page

2022-424-Minutes for Meeting October 26,2022 Recorded 11/16/2022 w. j Recorded in Deschutes County CJ2022-424 : Steve Dennison, County Clerk Commissioners'Journal 11/16/2022 2:14:46 PM ,c,•V-S ,9(., 11111111111111111111 I III gi ��ES �oGi)1� q { IIIIIII ' BOARD OF 2022424 COMMISSIONERS '=` 1300 NW Wall Street, Bend, Oregon (541) 388-6570 FOR RECORDING STAMP ONLY BOCC MEETING MINUTES 9:00 AM WEDNESDAY, October.26,2022 Barnes Sawyer& VIRTUAL MEETING PLATFORM Present:were Commissioners Patti Adair,Tony DeBone, and Phil Chang.Also present were Nick Lelack, County Administrator; Kim Riley, County Assistant.Legal Counsel;and Brenda Fritsvold, Board Executive Assistant This meeting was audio.and video recorded and can be accessed at the Deschutes County Meeting Portal website www.deschutes.org/meetings CALL TO ORDER: Chair Adair called the meeting to:order at 9:00 AM; PLEDGE OF ALLEGIANCE CITIZEN.INPUT: • Ron "-Rondo" Boozell expressed appreciation to the BOCC for being transparent and remaining open to citizen attendance and participation during the panderiic. He shared a hand-drawn map which depicted his solution for addressing homelessness in Bend.. • A:voicemail was received from a resident of Sisters supporting the lighting: ordinance discussed by Will:Groves at the October 12th BOCC meeting. • An email was received from Kathy Dammarell, a retired nurse, objecting to the BOCC action to continue to exclude health benefit coverage for abortions except in BOCC MEETING OCTOBER 26,2022 PAGE 1.OF 7 . certain cases. Further Discussion: Commissioner DeBone reminded that in 2006, voters rejected the idea of changing to a home rule charter form of government.;Regarding the map shared by Rondo, Commissioner DeBone said the message is that opportunity zones exist at Bend's outskirts. Commissioner Chang thanked Rondo for emphasizing transparency. CONSENT AGENDA:.Before the Board was Consideration of the Consent Agenda. CHANG: Move Board.approval of Consent Agenda DEBONE: Second VOTE: CHANG: Yes. DEB.ONE: Yes ADAIR: Chair votes yes. Motion Carried 1. Consideration of Resolution No. 2022-070 Increasing Appropriations and FTE within the Health Services Fund and 2022-23 Deschutes County Budget 2. Consideration.of:Board Approval of Order No. 2022-059, an Order Authorizing the ORS 311.392 Advance of Taxes,Assessments and Charges to Small Tax Districts 3. Approval of the Minutes of the October 12, 2022.BOCC Meeting 4. Approval of the Minutes of the October 14, 2022 BOCC Legislative Update -. Further Discussion::Commissioner Chang expressed appreciation to the City of Bend for its contributions to the crisis services program. ACTION ITEMS: • 5. Consideration of Board Signature of Document No. 2022-716, Iris Telehealth for the Crisis Stabilization Center • Chandra Mola, Manager of the Behavioral Health Program, and.Holly Harris, Deputy .. • Director of Health Services, explained the proposal to contract with Iris Telehealth for virtual psychiatric treatment for individuals seeking services at the Deschutes County Health Services Stabilization Center. Iris Telehealth is a Licensed Medical Provider (LMP) and will supply licensed Psychiatric Nurse Practitioners for these services. BOCC MEETING OCTOBER 26,2022 PAGE 2 OF 7 Harris spoke to the benefits of expanding this offering, saying that telehealth can work well and serve as a bridge to long-term treatment. She added that clients will have the opportunity to be supported with a case manager in the telehealth setting. DEBONE: Move Board approval of Board Signature of Document No.2022-716, Iris Telehealth for the Crisis Stabilization Center CHANG: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 6. Presentation on the Sisters.Cold Weather Shelter Laura Skundrick, Management Analyst,.introduced Nancy Connolly, Council President of the City of Sisters City Council; Molly Jones, Board Chair, Sisters Cold Weather. Shelter; Kerry Prosser, City Recorder&Assistant to the City Manager, City of Sisters; and Joe O'Neill, Finance Director and Interim City Manager, City of Sisters. Molly Jones said the purpose of the Sisters Cold Weather Shelter program is to. provide shelter, sustenance, and social connections. She reported that although the program is experiencing staffing issues and was unable to secure a location for the duration of the upcoming winter, it still desires and intends to provide necessities. Saying the temperature outdoors can drop to as low as 29 below zero in very hard winters, Commissioner Adair suggested acquiring a trailer to serve as shelter.Jones replied that the community will need to come together to determine an emergency contingency plan. Commissioner Adair raised the idea of a safe parking site. Kerry Prosser said the City has not yet been approached with a proposal for this type of program, although it may be open to exploring it. She indicated that many persons who live in the forest may resist being:pulled inside the city limits. Commissioner Chang suggested considering the Creekside Campground for this use,.if prohibitive deed restrictions can be lifted. He offered to help in this effort if the City is interested. Prosser responded that the.City is open to examining all proposals. Concurring that a great deal of unauthorized camping is occurring on public lands, Commissioner Chang said although some people want that, others desire different kinds of shelter. He encouraged Sisters to think about what it can do in terms of offering a warming space or a safe parking site for those who would appreciate and BOCC MEETING OCTOBER 26,2022 PAGE 3 OF 7 take advantage of these, and expressed interest in exploring if ARPA funds can be utilized for such efforts. Commissioner Adair asked if any of the hotels in Sisters would be amenable to sheltering homeless persons this winter.Jones said the program is looking into this and developing a best practices plan. Commissioner DeBone supported exploring the placement of a market rate campground on federal land close to downtown with access to services such as water, a pump station and electricity, adding such stays could be sponsored. He agreed it was important to consider all possibilities now. 7. FY 2023 Q2 Discretionary Grant Review . Administrative Analyst Stephanie Robinson presented the discretionary grant review for the second quarter.The Board made allocations of levels of support. Commissioner Adair inquired how much remains in unallocated lottery dollars. Ms. Robinson replied that the remaining balance is $540,000. 8. Consideration of Board.Signature on Document No. 2022-851 and approval:of-Document No.2022-852, Alfalfa Fire.District Loan/Pledge Agreement and Promissory Note to assist in the expansion and improvement of the District's facilities and operations Robert Tintle, Chief Financial Officer, explained the proposal to loan the Alfalfa Fire District $100,000 to enhance its fire protection services by expanding and improving its existing facilities and operations. Chad Lavallee, Alfalfa Fire District Chief, said the funds would be used to install a well, install a backup generator, and pave parking areas. Commissioner Adair reported efforts she is making to secure funding through the State so the District can repay this loan faster. Commissioner Chang expressed appreciation for the chance to support these infrastructure investments. CHANG Move Board approval of Board Signature on.Document No. . 2022-851 Alfalfa Fire District Loan/Pledge Agreement DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried. • BOCC MEETING OCTOBER 26,2022 PAGE 4 OF 7 DEBONE: Move Board approval of Document No. 2022-852, Alfalfa Fire District Promissory Note CHANG: Second VOTE: CHANG: - Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried 9. Treasury and Finance Reports for September 2022 Chief Financial Officer Robert Tintle presented the financial and investment reports for-September 2022, including portfolio balances and budget to actual numbers for the General Fund. 10.Consideration of Chair signature on Document No. 2022-858, a Notice of f Intent to Award Contract to Alliant Systems Geoff Hinds, Fair Director, explained the necessity of replacing the HVAC controls system at the:Fairgrounds. Five contractors submitted proposals for this project, with the low, responsive bid submitted by Alliant Systems.. Kim Riley,Assistant Legal Counsel, advised that before the Chair signs the document,the notice must be modified to reflect the correct protest period end date of November 2nd CHANG: Move Board approval of Chair signature on Document No. 2022-858, a Notice.of Intent to Award Contract to Alliant Systems,with:the Correct protest period end date of November 2, 2022 DEBONE: Second VOTE: CHANG: Yes DEBONE: Yes ADAIR: Chair votes yes. Motion Carried OTHER ITEMS: • Commissioner Adair attended the Sisters Country Vision's Vision Implementation Team meeting. • Commissioner DeBone attended the open house on the County's 2040 visioning plan in Sunriver. • Commissioner Chang attended the 2040 visioning plan open house in Bend. • Commissioner Chang announced that this Friday, the Oregon Conservation Corps (OCC)will offer a tour of a.project site in south Deschutes County. BOCC MEETING ,OCTOBER 26, 2022 PAGE 5 OF 7 • Commissioner.DeBone will participate in the OCC tour on Friday._ • Commissioner DeBone announced a meeting hosted by Redmond Economic Development, Inc. later today. Commissioner Chang reported on a recent incident in Grant County where the sheriffs office arrested a forest service employee at a planned burn.Saying this sends a potentially chilling message to those who are trying to protect communities from wildfire,,Commissioner Chang wished to be involved if any discussions on this subject are planned with State legislators or others. EXECUTIVE SESSION: At the time of 11:10 a.m., the Board went into Executive Session under ORS 192.660 (2)(e) Real Property Negotiations. The Board came out of Executive Session at 11:47 a.m. to direct staff to proceed as discussed. At the time of 11:47 a.m. the Board went back into Executive Session under ORS 192.660 (2) (h) Litigation. The Board came out of Executive Session at 11:54 a.m. to direct staff to. proceed as discussed. ADJOURN .. Being no further business brought before the Commissioners,the meeting was adjourned at 11:54 a.m. DATED this.. Day of I Y 2022 for the Deschutes County Board of Commissioners: PATTI ADAIR, CHAIR ANTHONY DEBONE; VICE:CHAIR ;:.ATTEST: 7 Y PHIL CHANG, COMMISSIONER BOCC MEETING OCTOBER 26,2022 PAGE 6 OF 7 RECORDING SECRETARY BOCC MEETING OCTOBER 26,2022 PAGE 7 OF 7 wTES:CO Gti .. .:: .. .. . BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS. MEETING 9:00 AM,WEDNESDAY, OCTOBER 26, 2022 Barnes Sawyer Rooms - Deschutes Services Bldg- 1300 NW Wall.St.=:Bend . . (541) 388-6570 I www.deschutes.org. AGENDA MEETING FORMAT: The Oregon legislature passed House Bill (HB)2560,which requires that public meetings _be accessible remotely, effective on January::1, 2022, with the exception of executive sessions: Public bodies must provide the public an opportunity to access and attend public :. meetings by phone, video, or other:virtual means: Additionally, when in-person testimony, either oral or written is allowed.at the meeting, then testimony must. also be allowed electronically via,_. phone;_video, email, or other electronic/virtual means. Attendance/Participation options are described above:: Members of the public may still view the BOCC meetings/hear:ings in real time via the Public Meeting`Portal at www:deschutes.org/meetings: CitizenInput: 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 bynoon:on Tuesday will be:iincluded inthe 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:onhold 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 theoutset of the public hearing. : For Public Hearings, the:link to the Zoom meeting will:be-posted in the Public Hearing Notice as: :well as posted on:the Deschutes County website at https://www.deschutes.org/bcc/page/public- hearing-notices. CALL TO ORDER : - . PLEDGE OF ALLEGIANCE - :: CITIZEN INPUT:. Citizen Input:may:be provided as comment on any topic that is not on the agenda..: Note:In addition to the option of providing in-person comments at the meeting, citizen input comments may be emailed to citizeninput@deschutes.org or you may leave a brief voicemail at 54:1.385.1734. To be.. timely, citizen input must be received by noon on Tuesday in order-to be included in the meeting record. CONSENT AGENDA 1. Consideration of Resolution No. 2022-070 Increasing Appropriations and FIE Within the - Health Services Fund and 2022-23 Deschutes County Budget.. 2. Consideration of Board Approval of Order No. 2022-059, an Order Authorizing.the ORS 3:11.392 Advance of Taxes,Assessments:and Charges to Small Tax Districts 3. Approval of the Minutes of the October 12, 2022 BOCC Meeting - 4. Approval of the Minutes of the October 14, 2022 BOCC Legislative Update ACTION ITEMS 5.. : 9:05 AM Consideration of Board Signature of Document No. 2022-716, Iris Telehealth for the Crisis Stabilization Center 6. . .9:15 AM Presentation on the Sisters Cold Weather.Shelter 7. 9:40AM FY 2023 Q2 Discretionary Grant Review 8.: 10:10 AM ',Consideration of Board Signature on Document No. 2022-851 and approval : - of Document:No. 2022-852, Alfalfa Fire District Loan/Pledge Agreement and Promissory Note to assist"'in:the.expansion and improvement of-the District's facilities and operations 9. 1.0:20 AM Treasury and Finance Reports for September 2022 10.. 10:40 AM Consideration of Chair signature of Document No. 2022-858, a Notice of :: . Intent to Award.a Contract to Alliant Systems 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 October 26, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 3 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. 11. Executive Session under ORS.192.660 (2)(h) Litigation 12. Executive Session under ORS 192.660 (2) (e) Real Property Negotiations ADJOURN Deschutes County encourages persons with disabilities to participate in all programs and:activities.This event/location is accessible to people with disabilities.If you need accommodations to make participation possible, please. call (541) 617-4747. October 26, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 3 of 3 LI G G BOARD OF COMMISSIONERS' MEETING o / REQUEST TO SPEAK • Citizen Input can be given regarding any topic that is NOT on the agenda • Public Testimony can be given during Public Hearings only Topic of Input or Testimony: ' /-1`7 10 ( 4`C`ID cJ F- Is this topic an item on today's ag nda? U 1��5 rn p.-er Yes (please seizdescription of Citizen Input above) No Name kJ Date: ZI--' AddressTi-e,11!_-) C)(1., Phone #s E-mail address THIS FORM IS TURNED IN TO RECORDING SECRETARY BEFORE MEETING BEGINS Are you submitting written documents as part of testimony? Yes No If so,please give a copy to the Recording Secretary for the record. Angie Powers To: Do Not Reply; citizeninput Subject: RE: Mitel voice message from CHARLES CARROLL, +15414081389 for mailbox 1734 Citizen input voicemail: "Hi, my name is Lynn Carroll and I am in favor of lighting ordinances in Deschutes County because I like the night skies real strongly, and we do get some fantastic displays of aurora borealis which I've taken by my house near Sisters, and with the continuing growth of population in the area the night skies,the dark skies are diminishing.And I would like to make sure that we have an ordinance where the lighting is shielded properly so that we continue with the dark skies that we have. My address is 67111 Fryrear Road, Bend, Oregon 97703, and I would like to attend the meeting about the ordinances but I have to work tonight so I can't make tonight's meeting, but I would like to drop off at the county office some pictures that I've taken from my backyard of the aurora borealis,the northern lights,that we get here, and also of other celestial objects such as comets and things like that.Thank you. Original Message From: Do Not Reply<DoNotReply@deschutes.org> Sent:Thursday, October 20, 2022 11:20 AM To: citizeninput<citizeninput@deschutes.org> Subject: Mitel voice message from CHARLES CARROLL,+15414081389 for mailbox 1734 You have received a voice mail message from CHARLES CARROLL,+15414081389 for mailbox 1734. Message length is 00:01:30. Message size is 708 KB. 1 Angie Powers From: Monte Dammarell <kmriverhaus@gmail.com> Sent: Sunday, October 23, 2022 5:06 PM To: citizeninput; Board Subject: Adair and Debone vote against comprehensive health care [EXTERNAL EMAIL] As a Registered Nurse for many years, and a retired Deschutes County Public Health Nurse after 12 years of employment, I am appalled and angry that Commissioners Adair and Debone voted to continue to exclude what is truly a medical emergency---an unwanted pregnancy---from the County's healthcare coverage. Debone and Adair pointedly ignore the needs of the women of their constituency, indeed, the needs of all women. Debone and Adair are completely out of step with other local employers, and refused to follow recommendations from the County's own employee advisory body. It is very obvious that partisan politics and the personal beliefs of these two commissioners take precedence over their sworn duty to the women and men of Deschutes County. Be ashamed Kathy Dammarell, RNBS, CPHQ (retired) i EtSC"/G2� BOARD OF e COMMISSIONERS. AGENDA REQUEST & STAFF REPORT MEETING DATE: October 26, 2022 SUBJECT: Presentation on the Sisters Cold Weather Shelter BACKGROUND AND POLICY IMPLICATIONS: On October 12,2022, the Deschutes County Board of Commissioners requested a status update regarding cold weather shelters in the city of Sisters. During the October 26 meeting, Molly Jonesand Kerry Prosser will provide information to the Board and be available for questions. ATTENDANCE: Molly Jones, Board Chair, Sisters Cold Weather Shelter . Kerry Prosser, City Recorder&Assistant to the City Manager; City of Sisters Laura Skundrick, Management Analyst sx‘y(ES 42 041)1 BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: October 26,2022 SUBJECT: FY 2023 Q2 Discretionary Grant Review RECOMMENDED MOTION: N/A BACKGROUND AND POLICY IMPLICATIONS: Each quarter, the Board d of Commissioners reviews applications submitted to the Deschutes County Discretionary Grant Program and makes awards accordingly. On October 26, 2022, the Board will consider requests made for activities to take place beginning or about the second quarter of 2022-23. BUDGET IMPACTS: Discretionary Grants are made available through the Video Lottery Fund, which is supported by state lottery proceeds. Discretionary Grant funds available during the second quarter were budgeted for:FY 2022-23. ATTENDANCE:: Stephanie Robinson,Administrative Analyst 'DES . 0 81, O BOARD OF COMMISSIONERS 1 DISCRETIONARY GRANT PROGRAM Q2 SUMMARY Organization : Request Project Assistance League Bend $2;500 Operation School Beal . BendNEXT(program of Bend Chamber) • $1,800 Leadership Bend: leadership development program Council on Aging(Service Partner) $2,260: Senior mental stimulation activities packet Education Foundation for Bend - La:Pine Schools $3,000 Art &wellness classroom grants Ember's WildflowerAnimal Sanctuary&Bunny Rescue ::. $1,500 W.ebsite update Financial Beginnings-Oregon $2,000 Financial education for low-income residents Habitat for Humanity of La Pine Sunriver $2,500 Critical home repairs In Our Backyard: $2,000 K-5 curriculum development to fight human trafficking JMJFire Protection.Foundation Inc. $2,500. 22nd century, wildfire solutions La Pine Community Kitchen $2,500: General operations Leadership:Redmond:(program of Redmond Chamber) $1,200 Day sponsor&scholarship: Parousia $2,500 SriPonya monthly movie.night Rimrock Trails Treatment Services. $2,400 Outpatient training fund for clinicians. : The Father's Group $2;500 Ujima Youth Program Q2 Total Requested Amount (Projects) $31,160 Organization I Request Fundraiser Family Access Network(FAN) Foundation (Service $2,500 2023 FANraiser event Partner) :Heart of Oregon Corps $3;000 Peer to'Peer fundraising.campaign Latino Community Association (Service Partner) $2,500 Empowering Families Luncheon Q2 Total Requested Amount (Fundraisers) $8,000 oCES c0 � N BOARD OF COMMISSIONERS DISCRETIONARY GRANT PROGRAM Q2 STATUS Commissioner Commissioner Commissioner Fundraising Adair DeBone Chang 2022-2023 Allocation $20,000 $20,000 $20,000 . $15,000 Q1 Contribution. $3,732. : -$4,150 . -$3,600 -8,000 Funds Available $16,268 $15,850 $16,400 $7,000 øo e,� ,o BOARD OF COMMISSIONERS AGENDA REQUEST & STAFF REPORT MEETING DATE: October 26, 2022 SUBJECT: Treasury and Finance Reports for September 2022 ATTENDANCE: Robert Tintle, Chief Financial Officer 5 wT ES Co: w�(' q G2a o Wr MEMORANDUM DATE: October 12,2022 TO: Board of County Commissioners FROM: Robert Tintle, Chief Financial Officer SUBJECT: Treasury and Finance Report for September 2022 Following is the unaudited monthly finance report for fiscal year to date September 30, 2022. Treasury and Investments • The portfolio balance at the end of September was$265.3 million, a decrease of^'$6.1 million from August and an increase of$37 million from last year(September 2021). • Net investment income for the month is$240,952 approximately$31K more than last month and$119K more than September 2021. YTD earnings of$648,202 are$252K more than the YTD earnings last year. • All portfolio category balances are within policy limits. • The LGIP interest rate increased from 1.65%to 1.90%on 9/8. Benchmark returns for 24 month treasuries are up from the prior month by 77 basis points and 36 month treasuries are up from the prior month by 79 basis points: • Average portfolio yield is 1.22%which is higher than the prior month's average of 0.78%. • The portfolio's weighted average time to maturity is at 1.36 years compared to 1.34 in,August. Portfolio Breakdown:Par Value by investment Type Investment Income Municipal Debt. S 43,710,000 16.6% Sep-22 Y-T-D Corporate Holes 58,102,000 21.9% Total Investment Income 245,952 663,202 Tune Certificates 1,245,000 0.5% Less Fee:$5,000 per month (5,000) (15,000) U.S.Treasuries 26.000,000 9.8% Investment Income-Net 240,952 648,202 Federal Agencies 89,710,000 33.8% LGIP 34,935,862 13.2% Prior Year Comparison Sep-21 121,296 395,899 First Interstate Bank 11.552.048 4A% Total Investments S ,265,254.911 100.0% I Total Portfolio:By Investment Types Category Maximums: Yield Percentages. . First Interstate U.S.Treasuries 100% Current Month Prior Month Municipal Debt e rya 16.5% LGIP(552.713,000) 100% FIB/LGIP 1.90% 1.65% LGIP - - - Federal Agencies 100% Investments r 1.26% 1.06% 132% `\ Banker's Acceptances 25% Average .. . .1.22% .0.78% :.. TimeCertCkates 50% Corporate Notes Municipal Debt 25%. Benchmarks 21.9% Federal \---,..., ,,,.. Corporate Debt 25% 24 Month Treasury 4.22% Agencies r Time Certificates LGIP Rate 1.90% 33.6%. 9.5%-,. Maturity(Years)•: . 36 Month Treasury :.. . .. 4.25% U.S.Treasuries i Max Weighted Average 9.8% .. 4.126 .: . 1.36 Term Minimum.. Actual 0 to 30 Days 10% 18.7% Portfolio by Broker Under 1 Year 25% 44.5% Under 5 Years 100% 100.0% H S120 $96.2 `o S100 Other Policy Actual a no Corp Issuer 5% 3.4% 560 ' : 532.4 AM Callable 25% 19.6% S40' $24.8 $20 $57 513.3 Credit WIA AA2 A s- - —.-=—. ■. -- II DA Moreton RobertWN Piper. Great Caste Oak ... Investment Activity Davidson . Capital Baird 8 Co Sander Pacific. • . • Purchases in Month ' • .S 17,000,000 Markets Securities Sales/Redemptions in Month 5 6,645,000 5.00% -- 24 Month Historic Investment Returns 4.50% — 3.I " 3. — —. Oct Jan Apr Jul Oct Jan Apr July County Rate :: 2 Year Treasury Rate Corporate Bond Rate LGIP.Rate Three Year Portfolio Balance 350,000,000 300,000,0E 150,000,000 100,000,000 - 50,000,000 r r I yoi yoi LO '0 y0 y0 'O LO 1> titi titi Jotiti. ti I> Ptiti sc' `§ &,„ ev de v qc O Oede O O POOee tiff tiff >Jc PJ¢o Five Year Maturity Distribution Schedule 20,000,000: - 18,000,000 _ 16,000,000 14,000,000 12,000,000 10,000,000 i - - - -.-- - - 8,000,000. - - — — - 6,000;000 r . 4,000,000 %-- ' :iii: I :: -.� 2,000,000 - _' Oct-22 Feb-23 Jun-23"Oct-23 Feb-24 Jun-24 Oct-24 Feb-25 Jun-25 Oct-25 Feb-26 Jun-26 Oct-26 s .11z. me o o s loo _ _ot_o _ _ � loi�''�8e02m �I�m8 ;�9__",_oT' i'1 moE°1° T.�°�7m alm, mIm , mm'i I� s�Ir1 � ice;azlo S'lo °'I' 8 m looIsIs�I^Imilm8! l ° I,88lnlH o! o>i l IB �! � lo m� `° 1 ,mmrlm8 W8! lmH07 2,8 $8 ' 19 • �jmJ�I�i I col"k l�B'81ml .sNope8lEwma181 ml,8u mE gmlg �1m aw ',m I. kaiQi I$I Im 1 � hou, pipNI Pr 18>1 '1 1-1 H0+,41ol : 1 ; ' iN' I& :., 1 . ,1 ,7, 1 1 I � , { lw m1 , . :" I � . i , Im , , 1 ,: I 3,°SO... I 1 I _�J , I I I I I 1 I I I 1 . 1 I ' l i . rI-I I I 1 1 i i 1� 1, i t I I . ! I 1 I 111 I I I I , I I ' I l i i I . i I I 1, I I , I Jg1m�1 IR3gZ IDDTfi DDDDlpD gggglgg -Tr'nn1�� ;IDt;rZ 1D nD �mIn' I l -I'o mIpD 1 I i I , �I0I . o D. HTI z > �r,F2.�DITl IaD 5 ID oI D;I. irD A D� kiji pDDo?g!..!� . _ I I ` ,ia .� I I l o � ,I s�q: oI , � i �� I I I I I i I I I. • NIN '�yV�1 • 1 -:' I r• 1 ,1 tJ w�'u .!wj 10' ...-,. , to- ^I ta1��1 Jlotm a alt.m+m++ ��ca�IJ ,m coil 7 I S1. .. ��{ IEIS,SIw,S•N'��,,,'r,,-I-L 0 N1 m 'IN.N,,&• w131 I� �,..I�,N f3, gg ;�11:;°1I,im'I�.w�B g,81,8. m 8'�°ig�8,� ig14 E 2I§la',f: ^1g14 w"!N$ S,I !NI o� 4 18 NIw w$�Ig g eil `� ' I u 3 mN�� SSm1�HS:mmlmmlmim�ElE�gS�1E ��^'w9',B,S; �IS:"�'�IN1$''N'I $1W°'E$1 $1$I�SS�Iw 881gin�>,Ej$,ENIS !wl$ ! Sm°ImmEBSN o,�S, ENmN ,.,Iw,oI�E18w $1$0�,�'��EImNIEi ItlmIm8S�81m1gE1S'8^lE� 8�wN1�N��E�lB� !',n' I, I o I2 L��n @@ m E) m°IEIm a 12; m m 8 T,'m '9. I if mlml 'Eta m + m N S1m lm a r m EIE,m g N,�'$m m N NIF m ti 81m °' EIm1 c 1 I °o n mma1> a �nA t U�'U G'a JI8m"el mm °m 'ml SI of Ivo !�II�I3' 1 !E J:Q: Irl�.�l '°9 yN m �Ic1. m nl 8!mI� I'nIm ICI �' lg.o• z o'� i8I I� SIC x o n n I$3. o m m' o Smn3! 1�!w IQ 71;53331$ .0 I W'Im 41 114.;8,EIROTa'SS.-,Hr to9,,141�ITI� I 6, 1Pligee 1 A y rol �el,g mlr, oS o: 1 tog I$ 1s1m a 15 .5'1 1 1N con F RI ! P mw,�l I'QX�g Iln G, � So�'v DPI I I I d oT .1 I I I I `G IIII N� ��" , -L I ily ��!��'I>,�mE�` TR�1 I I5�'m� �, � 8 I {N1 I SN �i�y 8 1 ! Im � LI III-) 1�1 I 1", IIm1 I� 81:8 a, m �b, Nl$ al Q , I 1 . ,-fig I I ,�1� '� � g�', 8,mmmsQ, �" B�Sama ' I��" IT'.m'o T T ill T;T'T T T r TITt�m.3 FI ' ln n<cl oiT'T ,�T F, 1 1 p;n1T NTi4'4 4 clm ,Tm T.�o' F' m!T, ,o : 1'IQ A cITITIn' T ' I�;3' T c':T '--^glcio�T c � c T'c gcic.T T v mac c T y. giI m I I 1 .1 , Ig, I TIT g, '1� 1, pp '�,01 ' 'k� N : ,11F;I I g ml,TI I g m'8$'8$81T rn a� 1�� '18 i q1$I$ �8 '�'8 $ m�al8 111, 1 N IIIIP! IiTi'H $lqN NI$8z_1 ! ! N Ns ! : °1$m'83888�8��88'� I u �A8 a 81 '8 81�1E'1SI t 1 '�a� coo I �1 , �I �S�. ° ICI ' ° � _ �m � �� a I Q ^� ' 5 m to I 1. o.II.xmo--"' j : EI' it i8 - 11 g, ifi �y I mOFlal mQ¢¢ °m °,:IT--�gaggg r.,. 1� °ly sliis,Ey1+,,..1 l:5o �I� I 'xlr �' -+"I° lgE I �i i :;5, oom , m�� ' Ic vlxl leP.111 eeeeelelee��I m !�� I;" d,�mm a-,el 1 je��..e�!o�l�l � � � 15a1a>�I em'e, niol 11T!8 IC I- e,ele�el�ml el �:oi@@I'1e� m e�elome�gl ' i �19r m:�,�"I°�� . " e : I I.I 'I� -n �i,Tl �.2 im O' _ N•N N 1T T ° ID T T_ $ 5 2 ".� jlmaill� 1��d�� @ � !;� la � I €€�I�I I � � I p ,e IyN 1r ! era n�lp ° Ig !� I�ee I I� gjo� @� p �' T I� la"K � � � � �» Q�"T I 1q � 33�p n Id lA � I=� !31 II lgl�0gF3°gt.2.117 R8 BBBI I3 3' I$E33 , ,, I?BB11 IA In-IRIS Ql,gq_ Z 3iOm n1r ?,cod r' T 3 3 £ F^ m 3 1 i iail� �° Y' o: I IVlor n1 gFm �` �sj �6 1 r� tl nnla n 11° 1� 1 rx nz, .' I P1-566 on' N. pft 65g not l n, n! m n Ai g q and nd Q I �� `�� l° alo'„� I �° �I� � i I �51 IT ��;m1 �. �� I- -�'1 z1 �$ I I � dm�IF o CI'�m 5�(C ) @ m �� I' '6 QQ x FI. .I Q �T p I F°m ml a .$ _ Ic� N m�I°�no1 1 5$ �1 - I ' I ��&° 1 _ I 1' f z '�If..:f1 I1ieg'gg1g' -8.18N ?0}p� 1•,* ' ' ,1 i•,': {8, IDS I °°e '-INIm, I •z :°lo Ell ;8_j 1 '¢no xn� 1,1 .a Iyn. dal 8y_�lo ; ,8� n$ `8: m$ .8. °m In $ ' 1.1 = n cmiln! ItNi: 1 I 1 Imm K `�!N'y11. 1 : aa� , .ml.'F ai 'm m i' II -.NIz.Z Z to, lm m;nln'm� QI coo �'d, d a,,m,! 'a: I,a I ;SIF'.,, Imf'llv i.czi o�,,m'd' 'm_I�.�I Q 5 II mh' d Im 1�1 .,ml as,'d m , F m�, l: .T p I,x,n Pn,§ig�1.141.5''91�,m,:0In' rI '. 11; QQt. m,,, ;N .8, �� o, •a X .°. yi , ,2, ,.,F ,0 31 2,°• 1 "• coy! ` I { 1"ltd x .0 1z1 8 Fm1Ig10O 511 =1 x,F A x, l 3.&,I o ° }''L laT R x1-rm� 13 , si22ol �, ,xii, 5� of cl x1 1 8 1 31= , to S � I o$ a o�T�• T m I* - "a' 'a . nl.�g°ml 'a ,3 : lm °'°'a , , ° �In Im m' ml I^° NNIN , Th Fla; ,n iiig,a I I° -y n �. 1 1 1 I I' o 'I� 'al T 1 r d�!6d �• l q n yg w °�' 6 nl F I�2 a- h N1n B, 1 ZIZ m N X y 1111� dl o.� I jZi I. z N" ya 'Nm'� l °1 j �n I ' ° N .. . 1 I 1Ng I 11. , I A is 1 I I Cn 9I-IY dm INm! i. q D I ' N for 1 ' I I .I:1 .1 I ! ''Ipl 1 I'm �1 1 (. yy y 1 om. w 4 I I ill j .. 1 .I'-1 I I 1 1 1 1 !.1 1 ° - ;I 1 N1 1 1 Ito i Iz y l 1'I I , I z 1 o 11 Dr. -_ .LI- 1- An Ag pS' m;olo ro°n 9'TF tn '' i n�pc A N,T.n'A n�rkn . , T.S . 'A' V kT'V1A PIA 9iQ ,,H9;m,A OjAIT'V V VIA-m T '.�tnn.A,VQ n:n'�O�t ', A:A n' ,V,-T N.T'�T'(�m nln n nl TIT A'n gi(�1 I99 _1°7N-r N T1 T• V n'D Nl - ' A�ITAI01.11> QNp1A1 y.DD1 INDIDNIN,>y,p ›,„,,0' ,TNT' I�yytt�: �'R!NIN��i ��N'iN NI•�'DT INI 1NIN1NiN DNDVID 1N1Q�'>>>>D,V� �iQ T. D .N NIN 'NINN D�, : „ 1�NIN DTID : N IDTR1T !�NRTN ITV F DID�I81 FI�n,F GIG. F.F NNj IFI °NI.•..DINT IDI DD,m1m fn,(n''F,DJ IDIF, ' ID' ;n N' N'NFID DD FF, DD 18 , IF, �NDINII .ND N,N1oDDto D INIDI�. '0'0, 1� : Dgignl °n , FIN ,NIDg 4j 8E`"' N ggl'n Dnm i. I I I ' o,'mg Im p y m m 1p1O m1 'a101 In n 0,a p y yip m,n, n1.1p' In •p n•y1 p!p m n o n1 Imilm!m'.o n10 n'm m- m• I' ° o p ml. o y n nlp n o m mlp 7!P m °n• 1 PgI '�,�°a 1 ml 1 YI 11 m m I ImI I I !m m'm' 1 , 1 I 1 M mlml 1 I< I I I , 1 I I< .1 m! Im Im minl m ImI 1 1 I< 1p y1m m°� I Y Ip m 'm 4. pI p p I J.: I ,m'm F <m J 1 ml 1 -m m m l i I I I' <I 1 1 ,m1m mi m olio m Im inI °' dlntn IIv.,21]§1,31,g I n inln m In in mlm nl_ Ji I • _ I_I.I- 1- TH I 1 I', I I-I I-i- lY I i:�-' 'i''I^- �ICI�w'°I@I@- NININI�i-.1 @I�1-I^@ @ C1C'' C @ F^'m N III @ N.' I@.: @ @` 1g @ 2 I�;'N @ N e N N 12 I 1 I 1 ,1NIi2,IN1� I, NmNH1I,11-1 ,gN112�AI-4IN��2d�31u. I,51N�1;N1,131'15EeNU@2IE. 1@IN.r.!-.Irr§.1§1:7,l gl §112Iwwlw1MjwN Ero. N,aa' coilr3 i. 1»-t1-. 1C! CIA l°S@,ro H:i' @w4t§ ar�111r� II .EI' . I�°.=1'@@ 15�''1aN@cI,�LI@IaI I �..I..A�'I 1NIe1�lE @'l+.E',�'N: �i ! y:@@^@� 1C Clop�� je@I�'Cmla�� I� ' ICI�i�1 @N@Iei@' .,. INejCal@�C ��I ,�Y�I IE:@"CE I C^£(vC , '� EMI � �l'k'3 !.!A I ',SIgI I..'.!. 1.! ,8IS!S ..1,-,o1A1o' ,,,,,IgIo'ooSo NBle l88''g6oNg18o8g'8A1g 8'0'100 8'88'�o1o8 161gli NA,B I6,NNN3Nq,81o'0gi2 881N88 .kggigl , 08 ""oeol8I8.18B' 81aol; .,g;w Io!1 I glg,,1,IN1,1,,"01mNIgi. 1g!�o'md ,RI„"go1o881,818,8, 08,8 'olo88088,888,,888818s'1-,I,I,1,18,818!8088 NI,I,SISIGGI,, J S;,,Io881N-1g08.1L3ud_L81---433 Nla.P31s8�I,1,t,1,13I13I�8ti,;8�e-,N-01N113._1 1_, 1 , i;@ee@eel ^e@@ @@@11e@I@ @'eel leel1e1z1@',;;!'e;NN�I,,,"e,l@ ,i I@@III �Imlm,exe!eelellieele' @'ENN ,1N ,,1,eNiNl@N1@mm@'@„a!a, I " I, f1 ^I'C N,1,,I� ,1_ @w,2!,1e z'1'1-1'1'1e.m "I'' '1N'101�§Ile L.L1roIE'm1..z:@@@1 ' @,uu� L... i8 @elewlNlN N0 •5 1�NN�_,w,� ,,1� 12 NN:5,11�811,e'a@Iu u2Nlu£A 11. NN C CICC&�NNN2ev IS 222i2S1 aE„1,:'r2S!SANA•NN'3ii:12.1g1I'A IRS'N, 1@„2.1a1a18, a1 81N1a2Ia'�S2�IZ115 1; 1'-,-lala2B 222•212I2SIS2' NN NS§E,A,„e�me,AE:Se§1 §SASNINN�6,IS§aSig8I SEgIBNA8°A §18ggg 88 e@Cem o mlo' oio 81 "'18;8 o m.o o,o o,oio!o 0 01010101°;0'°ololm•m'8; ie m1m1°Im °I°lo 8I8 e 8,0 ob o, 010 0;8 O,O o 8,8181N NsIEksIt IN 810 N m NIE, RIs °s.ti1N s1v N S° - •- N:�slN ,NIN•N N:N.N !N N N�N , N�,NIN,N N�,N,N N.N's!s s'sls° ° a s's sl°IN' Nlsls slti � I I Is Hlm • y!8 1 r -imF 1-8_ I- G B.w N 1 I'- al 1- ,a a >>1>T»i>�Ia ala1ala,a,<>, ;1 A>Idl I j'' g� 1 _ . ; , �,w,w: -7." Lam;; I+,8_wI ; w wrw J;i°,w tl_1, sr i 1 _ _r_:_11 � � ' II mJm ml 1 --; 1 1 1 1 1 1 i I.I I lI 1 ; i ! 1 mlm^ i I I 1 !. E:i 1 Or:5 •• 1 ^I ml Im • 1 I .mi.Im,.,. 1 N 1 a al 1 1 N1N!N : 1 ! .I -i-�I ,10 1 rR gI x igL1IN1§E116& 'E81s 1 @,I s1 1� 's1 Im I �Iag�1s,l lil l 9 91 s m°'I INI E1 $1 01p181i m 18ielasl' I ''g1H 10410 1t PA1515 Icl sl g mi ,Isaoskis8S8SeiN •1_'� ��liv,��I��E EIN�W g�_�m�Ia�•�.,��1�ImI I��I' �1g1�� Isl�;�_ Im.m m m.s � .a�i°lol°o��_�i�l�_�L,��I��NIw s��I�,s m�I�I��Iw� __1_I_ I I_��. I - 1-� _ -� gI L 8 E7 I$ p yip it E pI it i IylgTp-rp p11p teat y�i�' tl 1r glplplri :pill !yI IL p!-p18!T 21 It p 1818 f 8 81$12�1 1y.'?$1p1p,T Iy.� pI$p(C ,?�I Ip1 ! I 'ett y I Iply�. p, I I y'' tit !eI ! Iz' �"'�I I �igig D z' i,j I I P ,1-.�� G'G6G1G G K�.G I�I��,W"-.I C1C'+K+GG�1G°G �I�G1K��ulu�u G;G G:.I ,5 �6�� 45GI G1 G 1�.. 15 „K, I�.G��G^5: � ��5 1�1G,G�m G�1 G5f 1G I�I�G Imo, I� �� I � , ,. � 1 I �� - 1111 I 1 ' .I I 1 - 1I - - • 1j1 I , , j ! , 1IIl1 I_:,.-PH ' -Iy -I , y - I iy- - i4 , ; ?lt i yyj 1 I >1 "$'i$$$$ i I Igi-4.I-?; I?' I$I$�$$$con ?l�D$ I$ 14 , i$1 ;P. '$ I$$ 1 'lr I;1ni$f$1.$$ » JDI$ $ i; I ;.. DI ,$ I I$$I I$$'$g'.1D g➢$$$ IgD$P D$I$. ,$ ,$$G$g $I ! I�:D, I g 1 gr g,+ig ,I I 1 1 I.,,1, ,. I I .II, I., I I''�I 1 '' D 1. 1 'I 1 DI D !' 1� I I. I i.i� I. L, :.I. L, I I+ { I 1 ,-I I 'I I., 1 ' 1 1 1 ' .[ 11 1 I I♦ 1 ! , ' ! 1 '' I I 1 . f 1 11 1 1I 1 1 I _1 � • , L__• 11 III - I 1_ _. __ - .. . _ .- _ .. - - I t) r. Ala I II ^OINm�01-I..01OIo 0o OI0 o 0000N. ^PNN;w o;owuoN o,Nl o!ol?INIm'.uowN,o oN opIp o. I !000N o INoolololO lco O Nlw NI wNw Ola,O,ol-L:oo a Oda O ma wwiw'op 01.,PIoIN.INI , o1we o NN.11,Nip pIw O N NwYY YY N. . B 1 - E8E8IS68SoSSSS81'SSS91��IE80Im1_mIoBSA,__: .0°9Io�1.1S1� S'81E88I..!-11.,.11s_I; -.:,H_.,.__S$o.ol-.1EIN18SISI,4i;,_ 9181E-1NISE l8 118L11 I ic�1o188181c88 181SE�,1&l8 m ,v1�9S1E_�or I- -18SINNJBmSS,o.1�B1EoI8Sw I1 1 1 1.; 1 ! 1 1 ,I r rrt 1 1 'T 1 : i 1 1.11 1 1 1 .1.I.1 1 1 1 1 1 T I 1f11 �I 1 1 1 11 ! i I i{ I II 1 I 1 r Olo olO-°alo'o?. .I.', Olo o o o!o 010 0l I 1 0l l ,01. OIO A O!w cool ' O10'O I NIO w 1°lolw N:OIw NIm1 1 1 I Ili • m,Hw >'wm me0#,ml INI w a1m ,m..o opi8oam i>I� 8"ivI',> o'a!'(mluoerol�mo'°°,1NmmNmog. N,a'm^'aI '1'1' I..,'o slaw. N 'al moml�m wml . I I 0101 �,mlmiol8l8 9 m 8jolo,lE,r:B m1� & 1 $I 8"IN;a,8 8 S' Io Ej 8$ 1v1mj81SC N,$,.,8 ,l,&.N E$ S $,$',$i S ,w 818;:8;Slg 5 Ig Nlm m 8 m,Nl_mIw N,N ojw N m wIm m•m m o 818 88Jw cn,E � 8leo _,7-4 m r ml$la E , mid 3,Nlw�d 1 9I8 _-- 1.1 1 I.1i 11 11 ! 11 II I ' col , 1 ' ' I I IIII I lI 11 11 11 I j11 I ' 111I11 ' i111 11 I <I I'. I:.1 N' e1NNN1NrN-`LiNr.l,NNw,w 1 ;NINI�1NNI.NIN,IN. ,_NIN{NN N ▪ N_N ',NI�-N NI �N, 1;1 1-I - I.LIN �NI1�' N : ININI,NN.NNI. ', Nu1NNNlN N,�Iml,p' ,.ININr...I wN, NNINI,w1 IN-.N:'NI'NN,'NI^ NI^2 CT' .. iEl°' I_IN,Nr8 8•g 0 8I 881 o m! 18 a m o1m °igi8 1 m I mlg' °p,o 1 'SIN1S!8 g 11 o ojolo 0 8 SIS 81 : )' g,.i 1°' olol 8118 8 '. 1'° j 1 .: N!>n!��1mis�wpm_m�l��I§sIB.s:o!sl°!'S°INS°��I�$�.°1.8s §:§�:§'s_>ns o °§:§°§�§_:s,§ �s� wee:s!mg�a:°oo1°°_sl��tl�_��§1§!§so��,�_§§losssa_s1°omo_mo��_�,��s�alm��l§s�l�ss�l8i°Im.m �°��I�� °�g�:s I I , I 0101° 'mlm o 8I8i8 o',o 0 0, S'8 8�51 '°I°°°b' 1 1 it�f§1§s1§1g'S!8�'�I§'818ISologSlg§l�§i8,8,8I�1"§'§I§ss°tiV§81s'golal Igo "§,000'§188888gSSsEEEEIsolo'So1olEIEE'E;�E18g1EE'E18888881EEE.EE8s_8IEE.EialogloEI°so� ; 1Eg,8�°BSSofE'rg!a8I81gj8sag!o•J°1 EIEjEIEEIE°8_gIs'81sso., 1 ' I 1 { 11 IIl1 ! il ; .. 1 ' 1 � IIII • I ' �1 1 ' I li - - 11i111 , 1 ; I , <, I . ,1$ �1 1 �I 1 1N!N ..I _l 1 _ NI �I �I1. I 1 N.I. _i I_ I I TINI _INLIa1 ! OI l �l_I I� N mI mN r° rg ,' _L(mm..m..I wm1 ', mi,NN lmmrml • 'I I NI ,1�• 1 ,.i_a�a,,, 1 Im! ml aal g>I I m mlm ' E �isI EI m-.iNI meEEm, lmmogl',N.1E$I$m1em.-1�$N9m� �s Na�N' wpm 1 : • • Elsa! H�sIEEm1y1E1$I$''i esglsLs!�slNlm!,Iom1 E.mmlm'4..5e.Elar 188�0q �8,182'•'81 u$I I''i'ill2g�$IN_8 I.1 IN�Im_g1 _�1.I !N1a>:1`1!E161I ;1,l ,g. _iw:_§l�4111.0 1`.4, , N_El,80t.E,2EpI�: E,El'AIf,!s1°IIN2g222,2g lm°I^ I N 1Ns, o81' ;, a- .VI 1 -Im' : m, I mm, vl cow ,m1 'm o, I 1 I^, 1 i' •glsl2lg i old 8'iIS ggmi�l 18I 'H•El col i•l ie 81 1z11 z o ' E!a ' a §1�$10 g E E 1I m_912 2i2 s m A�!§Iip l 'H E�,p,1>lm E1 .. E N1_8 g1, I ; !gI$',8,g!mlm m _e E m§E; 1s NI _le E18 r,„.s1,1o1§'v gile.1£go lg,t1s3 m 8 m N4.0,:.I.• I I ' 11 .l Hill : 111 .!I 'II 11 I. 1 1I1 i I , 1 111 1 I 1 I;',4 _rni,N._N_1__IN .I.-I-iw' I ' INIpI^INI+loINI,'NN'NNNN.N: I . _I,'I 1_wL�1 INI II�N1 �eI� INI I- N._ N�,.iN ' I- 1e INI I I.. INI_a^N ,-,I, 1 IweI-Np NN YN I^I I...�N,.IN,N N_o<,m S p °'E 8 8 ! E e 8 Slo e$ of ! $8 Nlo m 81° 8 '!8$I° a.818,y S E>$ mI° S S lNl'9 S e E $ 9 8 Ei9 g 8 8 S $IBIS y NI S', mIB m 8I8 8 E w c 8 Il;lI 1m f 1m°l;lm§ irgr °e1°s I H OOAIwlml_la E1�10 glwI R§ll°Im gls Elslm m1$�1m1w'$�Im.-w Nlm P mim ml�tlE§91g i al>Islolol_Iw§<Iglm?11 I. Im �E§ 112§ I�B:miE:mO ,of° I:Al m°o e g11;10FJ a o 0%;1 m;Y k,m UN. -_ lN. .10. _ ,. _m., min I'o �'1' � m�a,o' j lm '.,m o;m �. a L I I 'm m i a o10 In•Nlw o to o�o aw , : Im! rgi li!m E o1$8 E-o m°i!N o B m;'imlg gill :wl log"'>i{3 SI A S H fIla nisi,moll^ g. . . gj: 1 g §1,1 1°4t)121V,PA o m !m E 01g, INi�m S�$,gl�a S m,.,l_I8t1E1 81, j$W wl 8 m,m,m l$ g $1m m:° N m��N1�mIOI I,_�Is''�!Elslm,�lalml,m m m°1m,m�,-��_i� ��I��°��N-mlol_o$mloL m�!��1��1��1�o�$�'gi�l°��1 LPL�W ml�m-1L��:��;�1�1w�m�m s°mlm m°�:�m�l_m•a,m°,m,� �L mlm�m°I$,�JmI°:°NI^1�al�.�m NI°:�� Position Control Summary' - July-June - Percent Org Jul Aug Sep Oct Nov Dec Jan Feb Mar April May June Unfilled . Assessor Filled 33.26 - • 31.00 32.00 - Unfilled 2.00 4.26 3.26 • _ 9.00% . Clerk Filled 9.48 9.48 10.48 Unfilled 1.00 1.00 - 6.36% BOPTA Filled 0.52 0.52 0.52 Unfilled - "- - - 0.00% DA Filled 57.40 58.40 59.20 - Unfilled 3.20 2.20 1.40 • - - 3.74% • Tax ,Filled 5.50 5.50 6.50 - • - • Unfilled 1.00 1.00 - 10.26% Veterans' Filled 5.00 -: 5.00 5.00 - ' Unfilled - - - - 0.00% ,Property Mngt Filled 2.00 - 2.00 2.00 • Unfilled 1.00 1.00 1.00 - - - - - 33.33% Total General Fund Filled- •. 113.16 111.90 115.70 ..' - - - - - •Unfilled 8.20 9.46 5.66 - - - - - - - 6.41% -Justice Court Filled 4.60 • 4.60 4.60 . Unfilled - - 0.00% Community Justice Filled - - 45.20 45.20 45.90- . Unfilled - 2.70 2.70' 2.00 5.15% Sheriff Filled 218.25 '232.25 230.25 Unfilled 44.75 30.75 32.75 - - 13.72% Houseless Effort Filled - - - 1.00 Unfilled. 2.00 2.00 • 1.00 • 83.33% . Health Srvcs Filled" - 355.80 357.50 368.30' " Unfilled 49.55 47.85 48.25 11.87% CDD • . . Filled 59.80 -58.80 59.80 Unfilled 12.20 13.20 12.20 17.41% . Road Filled 55.00 55.00. .58.00. . . ' ' . ' Unfilled ' . 6.00 6.00 3.00. : . . 8.20% Adult P&P Filled 35.55 35.55 35.85 Unfilled •5.30 --5.30 5.00 . " .. . .12.73% Solid Waste Filled 27.00. •26.00 28.00 - Unfilled 3.00 - 4.00 2.00 - - _ 10.00% Victims Assistance Filled - 8.00 8.00 - 8.00 ' - _ - Unfilled - 0.00% GIS Dedicated Filled 2.30 - 2.30 2.30 Unfilled - - - - - 0.00% Fair&Expo Filled 9.75 - : 9.75 9.75 - Unfilled • 3.75 3.75' 3.75 - 27.78% ' Natural Resource Filled- 1.00 - - Unfilled" 1.00 2.00 2.00 • 83.33% 1SF-Facilities Filled 20.75 -21.75 20.75 " .. - Unfilled 4.25 . 3.25 4.25 - . 15.67% ISF-Admin Filled 8.75 8.75 9.75 - Unfilled 2.00 2.00. . 1.00 .. - 15.50% ISF-BOCC Filled 3.00 3.00 3.00 ' . Unfilled " - _ - - . . 0.00% ISF-Finance"- " Filled 10.00 -8.00 10.00 • • Unfilled .1:00 . 3.00 1.00' , - . 15.15% ISF-Legal :Filled 7.00 7.00 7.00' . . • _Unfilled_'::._ - - - - ..,, 0.00% ISF-HR Filled -- 9.00 9.00 - 9.00 Unfilled •1.00 • 1.00 1.00 - - 10.00% ISF-IT Filled 16.70 16.70 16.70 .. - Unfilled • - - - - - -- - - 0.00% ISF-Risk Filled: ' 2.25 2.25 2.25 Unfilled 0.00% '911' Filled 52.00 '51.00 49.57 " ' " • Unfilled 8.00 " 9.00 10.43 - 15.24% • Total: Filled 1,064.86 1,074.30 1,095.47 _ - - - - - - - - - Unfilled 154.70 145.26 135.29 - - - - - - - - - • %Unfilled 12.68% .12.91% 10.99% - - • - 11.86% Budget to Actuals Report General Fund Revenue YTD in the General Fund is$3.1M or 7.2%'of budget. By comparison, last year revenue YTD was$2.5M and 6.1%of budget. Expenses YTD are$10.9M and 24.7%of budget. By comparison, last year expenses YTD was$10.1M.and 23.4%of budget: Beginning Fund Balance is$13.8M or 106.7%of the budgeted $12.9M beginning fund balance. Final beginning fund balance will be determined after the final close of FY22. 01ES co .. oIlt:uCAPr,oc: .�:.25.0% 0` County Financial Dashboard . "aom -General Fund 3 Year Complete Fund ... ... - ... ". .. ,.. 5erecta8 Budget to Actuals - L,(Blank/ — — : ■OM-General Fum�. Requirements Resources Beginning Working Capital Budget to Actuals by Category TiF olo-Aunt-clerk.. I 020 Abair SActuals•Budget•Prajection -C .:." 030-Community— L!040-Court Tedm_ .. .... .. .. .... I_)050-Economic D_: apt .. - . $2041 - 1060-Genera!Cou-. f I O70-GeneratCm— $10.9M . . - $3.1 M $13.8M Den— [J 120-Law library mint � wail watt titHtl :Drat sttmt JI MIN -.-. f 1130-Park Acguua_ 24.7% 7,2% 106.7% fora Li 132-Par&Medico- Transfers Out {towel MaWiah& Capital _-- -_-- Spent Collected Of Budget "Services Services only Monthly GL Per od Monthly Expenditures 23.1% Projected Ending Working Capital Approved.FEE ... Sara . - ._ %of last year budget 3 tfla �� 121.36 0 2 - 4 6 8 10 12 •Last Year Actuals•current Year Actual: VACANT .. - .. .. .. . 611511 " •Budget 44791 Monthly Revenues 6.0% •a jectian S11.5M - - -----. - %oflastvar but7 b11.1 Sow Ma ~-95.5345 a. z a 6: B" 10 tt fiesemes •Last Yew Annals•Current Year Actuals All Major Funds On the attached pages you will find the Budget to Actuals Report for the County's major funds with actual revenue and expense data compared to budget through September 30,"2022. • ycES c • h6�q °:S Budget to Actuals.- Countywide Summary All Departments o FY23 YTD September 30;2022 (unaudited) 25.0/o Year Complete Fiscal Year 2022 • .. • Fiscal Year 2023 • RESOURCES Budget Actuals % Budget Actuals % Projection % 001 -General Fund 40,504,168 40,047,506 99% 42,503,893 .2,996,573 7% 42,503,893 100% ; 030 -Juvenile . 901,143 . 1,007,843 112% ;-.- 1,010,203 51,920 5% 1,026,366 102% ; 160/170 -TRT ; 12,578,435 13,029,089 104% ; 13,631,282 . .6,243,912 46% ; ; 13,981,003 103% ; 200 -American Rescue ; 19,000,000 14,281,402 75% ; 105,186 24,240,444 999% ; ; 24,422,446 999% ; Fund I I . 220. Justice Court 550,832 494,676 90% ; 525,032 129,101 25% ; 525;510 1001Y0 ; 255-Sheriffs Office ; 44,947,745 45,776,980 102% : 48,790,055 : • 1,837,599 4% ; ; 48,789,084.. 8,789,084 100% 274-Health Services ; 48,727,400 . 48,848,440 100% ; 52,699,747 11,643,849 22% ; ; .54,963,051 104% ; 295-COD 9,580,316 10,542,434 110% ; 11,675;519 2,780,417 24% : 11,290,919 97% ; 325-Road 22,629,649 24,768,506 109% ; 24,889,063 7,095,722 29% 24,924,977 100% 355-Adult P&P • 5,840,250 6,178,356 106%; 6,134,018 1,896,831 31% ; 6,182,007 101% ; 465-Road CIP 2,471,190 1,124,832 46% ; 1,943,063 _ 63,889 3% ; 1,074,060' 55% 610 -Solid Waste 13,350,600 13,930,834 104% ; 14,503,499 4,369,489_ 30% ; .14,511,491 100% ; 615-Fair& Expo 1,395,724 '1,779,723 128% ; 1,408,534 365,912 26% 1,413;513 100% ; 616-Annual County Fair 1,560,500 1,922,671 123% ; 1,849,380 - .2,355,773 127% ; 2,372,997' 128% 617 -Fair&Expo Capital 8,544 8,012 94% ; 7,414 4,988 67% ; 19,950 269% ; Reserve I I • 618 -RV Park 517,524 584,713 113% ; 642,252 .. 197,038 31%i; ; 643,360: 100% 619 -RV Park Reserve 7,546 6,354 84% ; 6,298 3,100 49% ; 12,400 197% ; 670 -Ris.k Management 3,146,973 4,409,440 140% 3,311,477 '981,293 30% 3,349,251. 101% ; 675-Health Benefits ; 23,027,177 25,070,639 109% ; 23,658,700. :•-• 5,877,165 25% ; ; 23,694,394 100% ; 705-911 ; 12,019,306 12,896,533 107%; 13,744,678 140,651 1% ; ; :13,793,443 100% ; 999 -Other ; 50,071,869 34,055,652 .68% ; 57,508,737 . 31,376,210 55% ; ; 59,326,870 103% ; TOTAL RESOURCES ; 312,836,891 300,764,634 96% ; 320,548,031 104,651,877 33% ; ; 348,820,987 109% Fiscal Year 2022 - I Fiscal Year 2023 • REQUIREMENTS - Budget - Actuals % . Budget Actuals % .Projection % 001 -General Fund 21,298,809 19,383,248 91% 23,246,615 5,789,408 25% 22,437,090 97% 030 -Juvenile 7,496,355 6,674,328 89% ; 7,928,538 1,711,649. 22% :7,509,201 95% 160/170 -TRT 4,010,388 3,826,539 95% 13,113,218 6,138,677 47% 13,204,157 101% 200 -American Rescue 38,090,000 14,107,441.. 37% 23,129,361 • • 1,417,244 6% ; • ; 23,129,361; 100%.; Fund 220 -Justice Court 735,142 . .690,802 94% 731,183 188,362 26% ; 731;183 100% ; 31ES C oy`� 2 Budget to Actuals.- Countywide Summary • All Departments o FY23 YTD September 30, 2022 (unaudited) 25A 0 Year Complete Fiscal Year 2022 I . Fiscal Year 2023 Budget Actuals %- • Budget Actuals % Projection % 255-Sheriff's Office 54,162,360 51,382,461 95% ; 59,628,533 13,809,978 23% 59,031,817 99% 274 Health Services 58,872;642 51,692,689 88% ; 66,857,702 15,726,138 24% 63,556,675 95% ; 295-CDD 9,978,889 8,963,943 90% ; 11,233,304 2,278,216 20% ; 9,827,823. 87% ; 325-Road 15,024,128 13,771,124 92% ; 16,188,996 3,591,141 . 22% .15,968,699 99% ; 355-Adult P&P 7,079,915 6,392,578 90% : 7,575,910 1,543,452: 20% ; 6;962,381 92% 465-Road CIP • ; 29;722,691 8,106,117: 27% 28,387,166: • 12,035,488 42% 27,378,661 96% .; 610-Solid Waste 9,709;991 •8,761,777 90% 11,754,672 1,893,184 16% 11,754,672 100% 615-Fair&Expo • 2,504;877 2,625,580: 105% ; 2,768,054 552,222 20% 2,552,897. 92% ; 616-Annual County Fair 1,468,131 1,352,783 92% : 1,852,030' 1,334,908 72% 1,852,030 100% 617-Fair&Expo Capital 568,000 • 7,670 1% 870,000 . 92• 0% ; • 870,000 100% Reserve .. . • 618 -RV Park 552,188 466,135 • 84% ; 594;181 . 101,381 17% 587,668 99% • 619.-RV Park Reserve 100;000 885. 1% ; 100,000 - 0% • 100,000 100% 670-Risk Management 6,427,292 4,982,451. 78% 5,887,806 847,208 14% ; 5,727,558 97% 675-Health Benefits . 29;424,393 29,294,027 100% ; 26,769,217 4,453,094 17% 26,769,217 100% ; 705-911 ; 14,563,007 -1.0;896,900 75% -17,769,397 2,843,599 16% ; 16,726,613 94% ; 999-Other ; 86;872,890 41,181;099 47% 106,686,217: 8,420,586 8% ; ; 106,686,217 .100%; • TOTAL REQUIREMENTS ; 398,573,088 . 284,640,575 71% 433,072,100 84,676,026 . 20% ; ; 423,363,920 98% ; �y�,J� `o:s, Budget to Actuals - Countywide Summary All Departments 0 FY23 YTD September 30,2022 (unaudited) 25.0%. Year Complete Fiscal Year 2022 • Fiscal Year 2023 TRANSFERS Budget Actuals % Budget Actuals % Projection % 001 -General Fund (21,952,604) (21,807,006) 99% ; (20,758,359) (5,060,185) 24% (20,757,920) 100% 030-Juvenile 6,223,387 6,223,387 100% ; 6,452,997 1,613,247 25% ; ; 6,452,997 100% ; 160/170 -TRT ; (6,024,574) (5,916,413) 98% (6,031,446) (1,507,851) 25% (6,072,784) 101% 220-Justice Court 240,956 .- ' 196,126 81% ; - 263,217 .65,802 25% ; 263,217 100% ; 255-Sheriffs Office 3,500,737 3,501,246 100% ; 3,448,587 930,444 27% 3,448,587 100% ; 274-Health Services 6,122,830 6,122,830 100% 8,258,652 2,064,624 25% ; 8,258,652 100% ; 295-CDD (270,622) (1,159,207) 428% ; (911,585) (358,261) 39% ; ; (1,665,448). 183% ; 325-Road ; (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% ; (12,330,136) 100% ; 355-Adult P&P 471,072 471,071 100%; 467,092 116,769 25% ; 467,092 100% ; 465-Road.C!P . 12,193,917 10,672,113 88% ; 14,230,313. 4,889,361 34% 14,230,313 100%0 610 -Solid Waste ; (6,029,323) (6,029,323) 100% ; (5,299,665) (1,323,489) 25% ; ; (5,299,665) 100% ; 615-Fair&Expo 962,736 918,804 95% 704,127 176,031 25% 733,062 104% 616-Annual County Fair (75,000) (75,000).100% ; (156,706) (39,174) 25% ; ; . (156,706) 100% 617-Fair&Expo Capital 798,901 779,502 98% ; 1,149,827 287,451 25% 1,162,230 101% Reserve I 618-RV Park • 47,958 47,958 100% ; (81,566) (60,393) 74% (81,566): 100% ; 619-RV Park Reserve 132,042. 132,042 100% ; 261,750 65,391 •25% ; 261,566 100% ; 670 Risk Management ; (3,500) (3,500) 100% ; (3,500) (873) 25% ; ; (3,500) 100% ; 705-911 - - . 0% - - 999-Other ; 15,418,726 17,682,916 115% 10,336,146 5,581,882 . 54% ; ; 11,090,009 107% ; TOTAL.TRANSFERS 91 0 ; (255) - 0. :; 0% .; oy �sEs� , Budget to Actuals - Countywide Summary ` All Departments 25.0%0. FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal.Year 2022 Fiscal Year 2023 ENDING FUND BALANCE Budget Actuals % Budget . Actuals Projection % 001 -General Fund : . 10,723,375 13,847,828 129% 11,474,637 5,994,807 13,156,711 115% 030-Juvenile 596,681 1,522,125-.255% : 634,663 : 1,330,099 1,346,742 212% : 160/170 -TRT 8,433,816 9,475,532 112% ; 4,000,000 8,072,915 4,179,594 104% ; 200 -American Rescue - 108,098 999%; - 22,931,298 1,401,183 999% ; Fund - 220 -Justice Court 55,646 - 0% ; 57,066_ 6,541 57,544. 101% ; 255 Sheriff's Office 12,160,633 15,162,285 125% 7,024,650 4,868,340;. 9;116,130 130% ; 274-Health Services 6,011,534 13,968,557 232% ; 5,329,416 11,982,659 13,665,352' 256% ; 295-CDD 763,172 2,168,956 284% ; 1,627,134 2,312,897• 1,966,604 121% ; 325-Road 2,231,806 7,806,356 350% ; 2,262,898 3,870,162 4,432,499 196% ; 355-Adult P&P 1,971,182 3,238,905 164% ; 2,125,200 ` 3,709,053 2,925,623. 138% ; 465-Road CIP 5,316,460 27,223,832 512%; 12,334,484 20,141,594- ; 15,149,544 123% ; 610 -Solid Waste 583,520 3,097,007 531% 556,359 4,249,823 554,161 100% ; 615-Fair&Expo 604,256 996,420 165% ; 315,960 986,141 590,098 187% ; 616-Annual County Fair i 17,369 385,854 999% ; 225,358 1,367,546 750,115 333% ; 617-Fair&Expo Capital - 1,341,108 1,809,440 135% ; 1,587,183 - 2,101,787 2,121,620 134% ; Reserve I I I 618-RV Park - 13,294.. 166,536 999%; 82,920 201,801 - 140;662 170% ; 619-RV Park Reserve 824,054 1,191,937 145% ; 1,340,766 . 1,260,427 1,365,903' 102% ; 670 -Risk Management 5,045,296 8,944,938 177% ; 5,107,351 9,078,150 6,563,131 129% ; 675-Health Benefits 8,375,402 . 11,304,191 135% ; . 8,815,139 12,728,262 8,229,368 93% ; 705-911 9,.307,082 12,768,705 137% ; 8,926,080 10,005,757 9,775,535 110% ; 999-Other 55,322,038 95,065,151 172% ; 56,813,544 124,462,248 63,064,332 111% • TOTAL FUND BALANCE ; 129,697,724 230,192,653 177% ; 130,640,808 251,662,306 ; 160,552,450 123% USESc 6° °G Budget to Actuals Report `eilik"` General Fund - Fund 001 25.0% NO FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 I Fiscal Year 2023 - - RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Property Taxes-Current 32,410,716 32,791,880 101% : 34,467,173 144,006 0% . 34,467,173 100% : -;A Property Taxes-Prior 460,000 337,612 73% . 301,000 122,116 41% ! . 301,000 100% . - Other General Revenues 2,689,926 2,880,344 107% • 3,591,874 .2,266;197 63% ! 3,591,874 100% . B Assessor 987,411 886,514 90% 96.4,246 9,165 1% ! 964,246 100% Clerk 2,741,215 2,225,591 81% ! 2,238,566 378,348 16% : 2,298,566 100% . - BOPTA 14,588 13,216 91% ! 14,588 - 0% . 14,588 100% District Attorney 448,201 258,776 58% . 247,963 .44,415 18% . 247,963 100% . -� Tax Office 341,004 321,554 94% : 221,483 14,768 7% ! 221,483 100% Veterans 259,107 182,018 70% . . • 182,000 - 0% ; 182,000 100% ; C Property Management 152,000 . 150,000 99% : .215,000 17,558 8% ; 215,000 100% ; D TOTAL RESOURCES 40,504,168 40,047,506 99% : 42,503,893 2,996;573 7% : , 42,503,893 100% : , REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Assessor 5,454,784 5,157,534 95% 5,910,478 1,453,569 25% : 5,521,101 93% : 389,377:E I I Clerk 2,080,739 . 1,735,214 83% • 2,432,710 448,404 18% . 2,393,305 98% ! 39,405!F i I I BOPTA 82,911 .77,147 93% 87,177 23,842 27% • 87,177 100% ' - -- - I I I I District Attorney 9,715,707 8,677,696. 89% 10,153,207 2,374,636 23% • 9,814,335 97% ' 338,872.G ii II Medical Examiner 242,652 241,582 100% . 438,702 .21,925 5% ' 438,702 100% . i ii I i Tax Office 932,570 886,019 95% 905,262 254,659 28% ! 892,184 99% . 13,078.F . 1 1 1 I Veterans 795,189 762,328 96% ' 780,264 200,019 26% . 780,264 100% ! - i II i Property Management 380,061 360,274 95% 508,359 91,635 18% ; ; 479,566 94% ; 28,793.F Non-Departmental 1,614,196 1,485,453 92% ' 2,030,456 920,719 45% ! . 2,030,456 100% - - _ - 1 _ ; TOTAL REQUIREMENTS : 21,298,809 19,383,248 91% ; 23,246,615 5,789,408. 25% ; , 22,437,090 97% ; 809,525: TRANSFERS .Budget Actuals. %. Budget Actuals % Projection % $Variance. Transfers In 260,000 260,000 100% : 260,000 65,109 25% : 260,439 100% . 439:-J Transfers Out (22,212,604) (22;067,006) 99% . .(21,018,359) (5,125,294) 24% . (21,018,359) 100% TOTAL TRANSFERS ; (21,952,604) (21,807,006) 99% : (20,758,359) (5,060,185) 24% : ; (20,757,920) 100% : 439: • FUND.BALANCE . Budget Actuals % . Budget Actuals i .% Projection % $Variance Beginning Fund Balance 13,470,620 14;990,575 111% : 12,975,718 13,847,828 107% : 13,847,828 107% : 872,110:K Resources over Requirements ; 19,205,359 20,664,258' 19,257,278' (2,792,836) ; ; ' 20;066;803 809,525• Net Transfers-In(Out) (21,952;604) (21,807,006) . (20,758,359) (5,060,185) , •(20;757,920) 439; TOTAL FUND BALANCE , $10,723,375 $13,847,828 129% ; $11,474,637 $5,994,807 52% ; $13,156,711 115% ; $1,682,074; A Current year taxes received primarily in November,February and May g PILT payment of$500,000 received in July 2022;includes-$585K for a State Grant that will be passed through to Neighborlmpact for domestic well assistance c Oregon Dept.of Veteran's Affairs grant reimbursed quarterly D Interfund land-sale management revenue recorded at year-end E _ Projected Personnel savings based on FY22/FY23 average vacancy rate of 7.9% F Projected Personnel based on vacancy savings to date .• • G Projected Personnel savings based on.FY22/FY23 average vacancy rate of 4.2% j Repayment to General Fund from Finance Reserves for ERP Implementation K Final Beginning Fund Balance will be determined after the final close of FY22 o uTES C L Budget to Actuals Report.. . W�' Juvenile -Fund 030 • FY23 YTD September 30, 2022 (unaudited) 25.OI Year Complete Fiscal Year 2022 Fiscal Year_2023 RESOURCES Budget Actuals % Budget . Actuals % Projection % $Variance ' , OYA Basic&Diversion 432,044 500,765 116% : 525,049 - 0% : 525,049 100% : -• ' ODE Juvenile Crime Prev 100,517 117,184 117% • 123,000_ . - 0% • 123,000 100% Gen Fund-Crime Prevention 89,500 89,500 100% ! 89,500 - 0% • 89,500 100% • Leases 88,000 89,154 101% 86,000 22,557 26% : 90,228 105%• .• 4,228.A Inmate/Prisoner Housing. 80,000 92,400 116% ; 55,000 18,450 34% • 55,000 100% i DOC Unif Crime Fee/HB2712 49,339 50,462 102% • 49,339 0% • • 49,339 100% • , ' Miscellaneous . 7,500 29,113 388% : 42,500 . 151 0% • - 42• ,500 100% OJD Court Fac/Sec SB 1065 • 20,000 10,291 51% • 15,000 3,670 24% • 15,000 100% I Food Subsidy 12,000 • 11,380 95% • 10,000 1,610. '16% • 10,000 100% • - Contract Payments • 8,000 9,947 124% : " 8,000 797 10% • 8,000, 100% I I - I . 1 . Interest on Investments 14,243 7,647' 54%0 • 6,815. _ _ • 4;686 69% • 18,750 275% • 11,935.B 1 I t 4 _4 TOTAL RESOURCES 901,143 1,007,843 112% ; 1,010,203 • . 51,920 5% ; : 1,026,366 102% ; 16,163: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance . Personnel Services 6,082,895 5,411,118 89% • 0,332,160 1,423,127 22% 5,912,823 93% : 419,337:C Materials and Services. -. 1,363,409 1,249,983 92% • .1,527,992 288,522 19% .• • 1,527,992 100% • - i II I i Capital Outlay - . .50,051 13,226 26% • 68,386 - 0% • 68,386 100% • 1 I I 1 TOTAL REQUIREMENTS ; •7,496,355 6,674,328 89% : 7,928,538 1,71,1,649 22% : : 7;509,201 95% : 419,337: i TRANSFERS Budget Actuals % Budget Actuals % Projection %. $Variance Transfers In-General Funds 0;304,397 6,304,397 100% : 6,529,064 1,632,261 25% : 6,529,064 100% : - Transfers Out-Veh Reserve (81,010) . . _(81,010) 100% : .. ,(76,067) (19,0141 25%_ : (76,067),100% 1 -; TOTAL TRANSFERS 6,223,387 6,223,387 100% : 6;452,997 1,613,247. 25% ; : 6,452,997 100%-; . • - FUND BALANCE Budget Actuals . % Budget - Actuals % Projection % $Variance • ; Beginning Fund Balance 968,506 • 965,223 100% : 1,100,001 1,376,580 125% 1,376,580 125% 276,579 1 1 1 Resources over Requirements ; (6,595,212) (5,666,485) ; (6,918,335) (1,659,728) (6,482,835) • 435,500. Net Transfers-In(Out) 6,223,387 6,223,387 • 6,452,997 . • 1,613,247 6,452;997 .. . . .1 I I I ;. 1 .TOTAL FUND BALANCE . $596,681 :$1;522,125 255% : $634,663 $1,330,099 210% .., $1,346,742.212% ; $712,079: A New lease payment for JBarJ , B Investment Income projected to cone:in higher than budget . c .-Projected Personnel savings based on FY22/FY23 average vacancy rate•of 6.3% • . D - -Final Beginning Fund,Balance will be determined after the final close of FY22 . • ES c • o`�J 2< Budget to Actuals Report. TRT - Fund 160/170 FY23 YTD September 30,2022 (unaudited) 25.0% . Year Complete L Fiscal Year 2022 _ -_ I Fiscal Year_2023 RESOURCES Budget Actuals . % Budget . Actuals % Projection % $Variance Room Taxes 12,519,987 12,977,205 104% 1 13,580,874 6,226,295 46% 13,911,563 102% : 330,689:A Interest .58,448 51,884 89% 1 50,408. 17,617 35% 69,440 138% ! ,19,032:B TOTAL RESOURCES -12,578,435 13,029,089 104% ; 13,631,282 6,243,912 46% : : 13,981,003 103% : 349,721: REQUIREMENTS Budget Actuals % Budget . Actuals % • .Projection • % $Variance Grants&Contributions - - 5,600,000 4,060,000 73% : • 5;600;000 100% :I ;C COVA 3,660,659 3,512,891 96% 3,675,886 1,124,107 31% . 3,766,825 102% . (90,939)•D - i I ii i i Interfund Charges 239,526_ _• 239,526 100% 3,574;573 893,643 25%.:+.. 3,574,573 100% .- E I Administrative 15,203 9,365 62% • 215,508 . 45,927 21% . • 215,508 100% I I . I I Software 95,000 64,758 68% • 47,251 15,000 32% . 47,251 100% . - I 1 TOTAL REQUIREMENTS ; 4,010,388 3,826,539 95% ; 13,113;218 6,138,677 47% :; ; 13,204,157 101% ; (90,939): TRANSFERS i Budget Actuals % Budget Actuals % Projection % $Variance. Transfer Out-RV Park : • (20,000) - (20,000) 100% :1 . (20,000) (4,998) 25% : (20,000) 100% :1, -. Transfer Out-Annual Fair (75,000) (75,000) 100% • ' (75,000) (18,750) '25% ; . (75,000) 100% ; -• Transfer Out-Justice Court (240,956) (196,126) 81% ; (263,217) (65,802) 25% ; ; (263,217) 100% Transfer Out-Health . . (444,417) (444,417).100% ; (418,417). (104,604) 25% • (418,417) 100% . Transfer Out-'F&E Reserve (498,901) (479,502) 96% ; (501,683) • (125,418) 25%. , . (514,086) 102% ; (12,403)F Transfer Out-F&E ; (1,093,513) (1,049,581) 96% ; (1,101,342) (275,334) 25% . (1,130,277) 103% ; (28,935);G Transfer Out-Sheriff ; (3,651,787) (3,651,787) 100% ; (3,651;787). (912,945) 25% ; • (3,651,787) 100% TOTAL TRANSFERS (6,024,574) (5,916,413) 98% ; (6,031,446) (1,507,851) 25% : : (6,072,784) 101% : (41,338): FUND BALANCE Budget . Actuals % Budget Actuals . % Projection '% $Variance Beginning Fund Balance 5;890,343 6,189,395 105% : 9,513,382 . 9,475;532 100% . • 9,475,532 100% : (37,850):H . Resources over Requirements 8,568,047 9,202,550 518,064 • 105,234 776,846 _ 258,782. Net Transfers-In(Out)_ (6,024,574) (5,916,413) . (6,031,446) (1,507,851) 1• (6,072,784) . (41,338); TOTAL FUND BALANCE . $8,433,816 $9,475,532 112% ; $4,000,000 • $8,072,915 202% ; $4,179,594 104% ; $179,594: -A Room Tax collections up 7.2%over last year versus 5%budget assumption g • Investment Income projected to come in higher than budget c Includes$4M payment to Sunriver Service District • D Payments to COVA based on a percent of TRT collections E Includes-$3.5M for Interfund Payments to the General County Reserve Fund F The balance of the 1%F&E TRT is transferred to F&E reserves G Transfer projected to be higher based on increased Room Taxes H Final Beginning Fund Balance will be determined after the final close of FY22 0-Es c 0`� < Budget to Actuals.Report ARPA — Fund 200 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 . . I - Fiscal Year 2023 RESOURCES Budget Actuals %• Budget .'Actuals % •Projection % $Variance Interest - 93,961 105,186 60,668 58% • 242,670 231% . 137,484.A State&Local Coronavirus Fiscal 19,000,000 14,187,441 75% . 24,179,776 24,179,776 24,179,776.B Recovery Funds TOTAL RESOURCES 19,000,000 14,281,402 75% 105,186 24,240,444 999% 24,422,446 999% 24,317,260 REQUIREMENTS Budget Actuals % Budget Actuals % 'Projection % $Variance Services to Disproportionately 20,650,098 5,242,251 25% 15,394,824 608,593 4% 15,394,824 100% - C Impacted Communities - Administrative 5,281,005 143,079 3% 4,317,328 49,811 1% 4,317,328 100% - D Infrastructure • 2,050,000 527,275 26% • 1,634,710 .88,794 5% . 1,634,710 100% I •E Negative Economic Impacts 6,285,840 5,488,685 87% 899,577 32,141 4% . 899,577 100% 'F Public Health 3,733,057 2,786,152 75% 882,922 637,904 72% 882,922 100% ,G E TOTAL REQUIREMENTS ; 38,000,000 14,187,441 37% ; 23,129,361 1,417,244 6% ; , 23,129,361 100% ; -: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance . Beginning Fund Balance 19,000,000 14,137 0% 23,024,175 108,098 0% ; 108,098 0% (22,916,077:H ); Resources over Requirements (19,000,000) 93,961 (23,024,175) 22,823,200 1,293,085 24,317,260. 1 1 1 Net Transfers-In(Out) - - - - - I .. . i -. .. - i 1 TOTAL FUND BALANCE - $108,098 999% ; - $22,931,298 999% ; ; $1,401,183-999% ; $1,401,183; A Investment Income projected to come in higher than budget g The revenue received in FY22,but unspent at 06.30.22,was recorded as Deferred Revenue and recognized in FY23 c Includes$6.77M in childcare/early education funding,$6.9M in housing support for unhoused persons and over$7.3M in affordable housing projects - D Administration holds the balance of the ARPA funds;as well as an approved Management Analyst for ARPA reporting and administration E Consists of modernization of irrigation systems,Terrebonne wastewater system,and a regional broadband infrastructure needs and assessment F Majority of funding is for food programs,$2.5 million in small business assistance and additional funding for Ronald McDonald House and an Apprenticeship jobs program G 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 H Final Beginning Fund Balance will be determined after the final close of FY22 , USES C z� Budget .to Actuals Report . � ` Justice Court - Fund 220 0 FY23 YTD September 30,2022 (unaudited) - 25.0% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Court Fines&Fees 550,000 494,265 90% 525;000 128,973 25% 525,000 100% -� Interest on Investments 95 45 48% • 32. 129 402% • • 510 999% • 478•A Miscellaneous 737 365 50% - - - TOTAL RESOURCES 550,832 494,676 90% ; 525,032 129,101 25% ; ; 525,510 100% ; 478: • REQUIREMENTS Budget Actuals % Budget Actuals % "Projection % $Variance Personnel Services 577,209 541,792 94% : 569,648 143,631 25% : 569,648 100% : - Materials and Services 158,933 • 149,011 94% • 161,535 44,732 28% i• 161,535 100% • -•B • I 1 f TOTAL REQUIREMENTS ; 736,142 690,802 .94% 731,183. . .188;362 26% ; , 731,183 100% ; • TRANSFERS Budget Actuals % Budget Actuals % Projection . % $Variance Transfers In-•TRT 240,956 196,126 81%.: 263,217 :65,802 25% : 263,217 100% 1 f I 1 f TOTAL TRANSFERS 240,956 196,126 81% 263,217 '65,802 25% ; _ 263,217 100% Resources over Requirements (185,310) (166,126) (206,151) (59,261) (205,673) 478' Net Transfers-In(Out) 240,956 196,126 263,217' . - 65,802 • • - 263,217 i . i � i TOTAL❑ $55,646 - - 0% ; .- .$57,066 $6,541. 11% ; -$57,544 101% ; $478; • A Investment Income projected to come in higher than budget g One time yearly software maintenance fee paid in July for entire fiscal year ��Es` Budget to Actuals Report ` Sheriffs Office - Fund 255 1W FY23 YTD September 30, 2022 (unaudited) 25.0% Year Complete Fiscal Year 2022 I Fiscal Year 2023 _ RESOURCES Budget Actuals °A, Budget Actuals % Projection % $Variance LED#1 Property Tax Current 28,448,529 28,828,746 101% ! 30,282,049 121,055 0% : : 30,282,049 100% �A LED#2 Property Tax Current 11,813,562 11,962,302 101% • 13,400,541 50,234 0% ! . 13,400,541 100% . ; Sheriffs Office Revenues 3,993,964 4,407,029 110%.. 4,520,630 1,493,334 33% ! 4,530,374 100% - 9,744!B LED#1 Property Tax Prior 330,000 288,862 88% 330,000 '104,527 32% ! 330,000, 100% LED#2 Property Tax Prior 145,000 118,145 81% 145,000 43,093 30% . 145,000 100% LED#1 Interest 147,416 96,152 65% • - 89,119 24,596 28% 98,170 110% • 9,051!B LED#2 Interest 69,274 24,356 35% 22,716 760 3% . ! 2,950 13% ! (19,766);C LED#2 Foreclosed Properties - 15,070 - - - - LED#1 Foreclosed Properties - - 36,317 - - - - - - f 1 1 1 1 TOTAL RESOURCES 44,947,745 45,776,980 102% ; 48,790,055 1,837,599 4% ; , 48,789,084 100% ; (971); REQUIREMENTS Budget Actuals % Budget Actuals _ % Projection % $Variance Digital Forensics - - 808,610 182,767 23% : : 808,610 100% 1 Concealed Handgun Licenses - - 335,044 54,104 16% . ! 220,506 66% . 114,538. Rickard Ranch - - 264,871 78,471 30% . . 264,871 100% Sheriffs Services 4,002,499 4,208,992 105% ' 5,863,885 1,155,580 20% . ' 4,999,611 85% . 864,274. Civil/Special Units 1,154,204 1,112,473 96% 1,168,300 316,786 27% ! 1,213,198 104% ! (44,898); Automotive/Communications 3,576,342 3,738,777 105% . 4,005,888 699,465 17% • 3,944,423 98% ' 61,465 Detective 3,029,130 3,013,632 99% ! _ 3,383,825 1,015,736 30% ! ! 4,254,630 126% . (870,805) Patrol 14,015,461 13,440,565 96% ! 14,640,315 3,770,895 26% 14,949,428 102% : (309,113); Records • 1,025,023 735,218 72% • 944,493 175,020 19% • 944,493 100% . , Adult Jail 21,033,697 18,807,184 89% 22,182,320 4,862,479 22% ! 20,926,240 94% ! 1,256,080. Court Security 444,617 431,758 97% 424,769. 131,755 31% - 424,769 100% Emergency Services 789,912 543,303 69% 829,997 101,326 12% ! ! 579,243 70%.! 250,754 Special Services 1,775,588 2,053,196 116% ; 2,047,792 557,772 27% • ; 2,464,374 120% ; (416,582); Training 1,626,207 1,786,439 110% • 1,907,588 448,165 23% • ' • 2,216,585 116% • (308,997). Other Law Enforcement • 1,389,684 1,510,925 109% . 820,836 • 259,656 32% . . 820,836 100% Non-Departmental - 299,998 - 0% I - 0% - 100% i s � I. o TOTAL REQUIREMENTS ; 54,162,360 51,382,461 95% ; 59,628,533 13,809,978 23% ; 59,031,817 99% ; 596,717; TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfer In-TRT 3,651,787 3,651,787 100% ! 3,651,787 912,945. 25% . 3,651,787' 100% Transfer In General Fund 121,950 121,950 100% . 70,000. 17,499 25% ! 70,000 100% Transfers Out-Debt Service ! (273,000) (272,491) 100% . (273,200) - 0% ! (273,200) 100% TOTAL TRANSFERS 3,500,737 3,501,246 100% ; . 3,448,587 930,444 27% ; , 3,448,587 100% ; -: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance 17,874,511 17,266,520 97% . 14,414,541 15,910,275 110% 15,910,275 110% : 1,495,734:D Resources over Requirements • (9,214,615) (5,605,481) • (10,838,478) (11,972,379). ; (10,242,733) 595,745 Net Transfers-In(Out) - 3,500,737 3,501,246 3,448,587 930,444 - ' - 3,448,587 I 1 • TOTAL FUND BALANCE $12,160,633 $15,162,285 125% ; $7,024,650 $4,868,340 69% ; ; $9,116,130 130% ; $2,091,480; Note:Vacant positions are driving projected department savings,with other fluctuations causing projected budget overages A Current year taxes received primarily in November,February and May g Investment Income projected to come in higher than budget c Investment Income projected to come in lower than budget D Final Beginning Fund Balance will be determined after the final close of FY22 - uTES c if& Budget to Actuals Report ` ` Health Services - Fund 274 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 . . RESOURCES Budget Actuals % Budget . Actuals % Projection % $Variance r State Grant 17,641,302 • 16,634,837 94% : 17,926,893 5,312,431 30% 19,177,310 107% : 1,250,417: OHP Capitation 8,947,837 11;776,144 132% ! 12,882,624 3,208,255 25% ! ! 11,868,624 92% ! (1,014,000)• State Miscellaneous 4,129,465 3,518,729 85% • 8,901,719 '223,860 3% • 8,735,207 98% • (166,512). OHP Fee for Service 3,627,151 4,032,343 111% ! 3,232,620 • 728,995 23% . . 4,468,236 138% . 1,235,616. Federal Grants 4,303,483 4,090,251 95% . 2,215,634 - 0% • • 2,596,563 117% • 380,929. I I I I I Local Grants 1,936,838 3,350,227 173% • 2,088,031 1,073,080 51% . 2,257,300 108% • 169,269. Environmental Health Fees 1,086,019 1,213,172 112% ; 1,238,499 . . :73,600 6% : ! 1,238,623 100% : 124! Other 884,036 866,362 98% •I 1,021,722 197,129 19% 1,026,047 100% . 4,325• State-Medicaid/Medicare 843,050 777,348 92% • 807,530 277,135 34% 1,108,540 137% • 301,010• 1 1 I I Patient Fees 468,415 538,392 115% . 615,644 147,638 24% . • 580,876 94% . (34,768)• Medicaid 1,014,100 750,524 74% • 430,863 • .169,855 39% • • .624,363 145% • 193,500• State-Medicare .172,200 194,470 113% • 337,614 55,238 16% • 220,953 65% • (116,661)• Vital Records 280,000 342,960 122% • 300,000 63,114 21% . 339,034 113% • 39,034.I ILiquor Revenue 157,000 199,100 127% ' 177,574 19,068 11% 177,574 100% Divorce Filing Fees . . 173,030 178,331 103% I 173,030 • • - 0% . 39;000 23% • (134,030). Interfund Contract-Gen Fund 127,000 127,000 100% • 127,000 - 0% • • • 127;000 100% State Shared-Family Planning 152,634 . 118,228 77% ! 125,000 43,943 35% ! ! 175,771 141% ; 50,771. Interest on Investments 156,549 101,438 65% . 97,750 50,508 52% . • 202,030 207% . 104,280. I ii I1 CCBHC Grant . 2,627,291 38,587 1% . - - • - - - TOTAL RESOURCES 48,727,400 48,848,440 100% : 52,699,747 11,643;849 22% : , 54,963,051 104% ; 2,263,304: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance • • Administration Allocation - . - 999% • - - - Personnel Services 43,994,358 39,393,426 90% ! 50,672,588 13,089,21 26% !3 46,783,260 92% ! 3,889,328 Materials and Services 14,721,284 12,217,134 83% . 16,105,114 2,636,925 16% . . 16,558,388 103% ; (453,274); Capital Outlay 157,000 82,128 52% • 80,000 - 0% • . 215,027 269% • (135,027)• TOTAL REQUIREMENTS ; 58,872,642 51,692,689 88% ; 66,857,702 15,725,138 24% ; : 63,556,575. 95% : 3,301,027: TRANSFERS Budget Actuals. % Budget . Actuals % Projection % $Variance • Transfers In-General Fund 5,909,168 5,909,168 100% : 6,608,245 1;652,034 25% 6;608,245 100% .I - Transfers In-OHP Mental Health ' - - 1,473,586 368,382 25% . . 1,473,586 100% Transfers In-TRT 444,417 • .. 444,417 100% . 418,417 104,604. 25% : : 418,417 100% Transfers Out . .(230,755) (230,755) 100% ! (241,596) : (60,396) 25% ; ; . .(241,596) 100% ; -; TOTAL TRANSFERS 6,122,830 6,122,830 100% : 8,258,652 2,054,624 25% ; : 8;258,652 100% ; -: FUND BALANCE Budget Actuals % Budget . Actuals % Projection % $Variance Beginning Fund Balance 10,033,946 10,689,975 107% . 11,228,719 14,000,324 125% : : 14;000,324 125% : 2,771,605: Resources over Requirements ; (10,145,242) . .(2,8,44,248) ; (14,157,955) (4,082,289) • . (8,593,624) . 5,564,331. Net Transfers-In(Out) 6,122,830 6,122,830 • 8,258,652 2,064,624 • . • 8,258,652 . • 1 I I I I TOTAL FUND BALANCE $6,011,534 $13,968,557 232% ; $5,329,416 $.11,982,659 225% ; ; '$13;665;352 256% ; $8,335,936: u1ES C ;;C °°2 Budget to Actuals. Report. ,CIA►► • Health Services -Admin - Fund 274 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete • Fiscal Year 2022 . .. Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance State Grant 769,319 i 49.3,270 64% 379,180 206. ,918 55% : 379,180, I i 180 100% : - i i OHP Capitation - 436,443 367,074 91,862 25% ' 367,074 100% ! - � i Interest on Investments !156,549 101,438 65% 97,750 50,508 52% 202;030 207% ! 104,280! ri t 1 Federal Grants 1,438,843 1,183,981 82% 54,405 - 0%_ : 528,802, 972% . 474,397.A I Other 9,200 12,146 132% • 12;900 5,358 42% 12,900 100% .�. I 1 CCBHC Grant 486,804 - 6,938 1% . - - - - i. i i i . I - - .1. Patient Fees - 1,124 - - - - - i I I TOTAL RESOURCES 2,860,715 2,235,340 78% , 911,309 • •'354,646 39% , : 1,489,986 163% : 578,677: REQUIREMENTS Budget Actuals . % Budget Actuals % Projection % $Variance Personnel Services 6,904,224 5,832,219 84% : 6,513,820 1,435,809 22% : 6,0.23,794. 92%.: 490,026:C I 1 1 1 Materials and Services 6,580,649 6,134,705 93% ! 6,622,895 1,613,828 24%. . 6,848,270 103% . (225,375):B Administration Allocation ! (10;188,902) (10,188,901) 100% ' (11,163,653)- - 0% . . .(11,163,653) 100% 1 1 - -- - - - I -.1 TOTAL REQUIREMENTS : 3,295,971 1,778,023 54% : 1,973,061 3,049,638 155% : : 1;708,411 87% : 264,651: TRANSFERS Budget Actuals % Budget Actuals % Projection % . $Variance Transfers In-OHP Mental Health ; - - 80,771 :20,190 25% 80,771 100% : - 1 i ii i i Transfers Out i (219,794) (219,794) 100% i . (230,635) (57,657) 25% . i (230,635) 100% i -i TOTAL TRANSFERS (219,794) (219,794) 100% ; (149,864) (37,467) 25% ; ; (149,864) 100% : -: FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance ' 3,552,000. 3,769,942 106% . 3,884;332 4,007,465 103% . . 4,007,465 103% . 123,133.D Resources over Requirements i (435,256) 457,318 i (1,061,752) (2,694,991) i i (218,425) i 843,328: Net Transfers-In(Out) i (219,794) (219,794) . i (149,864) (37,467) i i (149,864) i • -i TOTAL FUND BALANCE $2,896,950 . $4,007,465 138% : . $2,672,716 $1,275,007 48% ; ; $3,639,177 136% ; $966,461: A Projection includes unbudgeted.increase in FEMA expenditures for vaccine clinics. g Expenditures over budget related to'expenses supporting COVID-19 vaccine distribution. c Personnel projections based on year to date vacancy savings and assume 3%.moving forward :D The stated amount is an estimate.Final Beginning Fund Balance will be determined after the final close of FY22. JCS co 2 Budget to Actuals Report ,,c� Health Services - Behavioral Health -Fund 274 25.0% FY23 YTD September 30,2022 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance OHP Capitation 8,947,837 11,339,701 127% . 12,515,550 3,116,394 25% : : 11,501,550 92% : (1,014,000):A State Grant 1 11,907,014 12,160,202 102% I 11,817,372 3,144,981 27% 12,933,874 109% : 1,116,502:B � 1 1 State Miscellaneous 1,934,643 1,712,171 89% 1• 8,027,373 193,830 2% • • 7,932,724 99% 1• (94,649): 1 1 1 1 1 1 OHP Fee for Service 3,627,151 4,009,351 111% • 3,214,360 720,277 22% • 4,433,105 138% • 1,218,745•A 1 1 1 1 1 Federal Grants 2,725,623 2,781,433 102% • 2,017,169 - 0% • 1,922,185 95% ; (94,984)• 1 1 Local Grants 1,093,055 1,378,335 126% . 1,311,139 401,838 31% • 1,377,053 105% • 65,914. Other 682,180 668,038 98% ! 719,670 180,296 25% : 722,570 100% : 2,900 1 1 1 1 Patient Fees 372,115 431,526 116% • 519,344 118,354 23% . 469,214 90% . (50,130)• I 1 1 I Medicaid 1,014,100 : 750,524 74% . 430,863 169,855 39% . 624,363 145% • 193,500. I 1 I :1 1 State-Medicare 172,200 194,470 113% • 337,614 55,238 16% • 220,953 65% (116,661)• 1 1 1 Liquor Revenue 157,000 199,100 127% • 177,574 19,068 11% . • 177,574 100% • -• Divorce Filing Fees 173,030 178,331 103% . 173,030 - 0% . 39,000 23% . (134,030);C 1 1 1 1 Interfund Contract-Gen Fund 127,000 127,000 100% • 127,000 - 0% . 127,000 100% • - CCBH 1 C Grant 2,140,487 31,649 1% . - - . . - 1 i 1 1 TOTAL RESOURCES 35,073,435 35,961,830 103% : 41,388,058 8,120,132 20% : : 42,481,165 103% : 1,093,107: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Administration Allocation .7,523,855 7,523,855 100% . 8,235,864 - 0% 8,235,864 100% : - i 1 1 1 I Personnel Services 26,606,065 24,513,386 92% 32,545,900 9,216,897 •. 28% 30,355,897 93% • 2,190,003•D 1 I 1 Materials and Services 4,882,963 3,664,647 75% • 7,095,087 714,776 10% • • 7,194,653 101% • (99,567)•E Capital Outlay 80,000 54,752 68% • 80,000 - 0% • • 203,827 255% • (123,827); 1 1 TOTAL REQUIREMENTS ; 39,092,883 35,756,639 91% ; 47,956,850 9,931,673 21% ; : 45,990,241 96% : 1,966,609: TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfers In-General Fund 2,278,087 2,278,087 100% : 2,231,439 557,847 25% : 2,231,439 100% .. .. 1 1 1 1 Transfers In-OHP Mental Health • - - 1,392,815 348,192 25% • 1,392,815 100% • - 1 1 1 1 1 Transfers Out ! (10,961) (10,961) 100% : (10,961) (2,739) .25 ! (10,961) 100% ! -: TOTAL TRANSFERS 2,267,126 2,267,126 100% : 3,613,293 903,300 25% ; , 3,613,293 100% ; -: FUND BALANCE Budget Actuals % Budget Actuals %. Projection % $Variance Beginning Fund Balance 3,612,014 3,870,664 107% : 4,788,795 6,372,638 133% 6,372,638 133% : 1,583,843:F 1 1 1 1 1 Resources over Requirements (4,019,448) 205,191 • (6,568,792) (1,811,541) • ; (3,509,076) ; 3,059,716. Net Transfers-In(Out) 2,267,126 2,267,126 3,613,293 903,300 • • 3,613,293 • 1 1 . . .. 1 1 I . 1 TOTAL FUND BALANCE . $1,859,692 $6,342,980 341% ; $1,833,296 $5,464,397 298% ; : $6,476,855 353% : $4,643,559: A A new System of Care wraparound payment was budgeted as part of OHP Capitation,but is coming in as OHP Fee for Service. g Increase of$715K related to new funds for Aid&Assist($431 K), a cost of living adjustment($358K),and carryforward revenue from FY22($455k) G Mediation Program will no longer be managed within Health Services,so funds are transferred out of Health Services D Personnel projections based on year to date vacancy savings and assume 10%moving forward. E Increase in expenditures related to temporary staff being used instead of oncall staff F The stated amount is an estimate.Final Beginning Fund Balance will be determined after the final close of FY22. u1EsC �6's o Budget to Actuals Report.. 14107 Health Services - Public Health - Fund 274 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 I Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance State Grant 4,964,969. .3,981,365 80% : 5,730,341 1,960,532 34% : 5,864,256 102% : 133,915:A Environmental Health Fees 1,086,019 1,213,172 112% 1,238,499 73,600 6% ! _ 1,238,623 100% ! 124 State Miscellaneous 2,194,822 1,806,557 82% ! 874,346 30,029 3% ! 802,483 92% ! (71,863):B 1 1 1 State-Medicaid/Medicare 843,050 777,348 92% I I 807,530 277,135 34% . 1,108,540 137% • 301,010; 11 1 1 Local Grants 843,783 1,971,892 234% . 776,892 671,242 86% 880,247 113% . 103,355.C Vital Records 280,000 342,960 122% . 300,000 63,114 21% . 339,034 113% , 39,034; Other 192,656 186,177 97% . 289,152 1 .1.1,475 4% ' 290,577 100% . 1,425.1.I 1 Federal Grants 139,017 124,837 90% . 144,060 - 0% ; 145,576 101% . 1,516. State Shared-Family Planning 152,634 118,228 77% ! 125,000 43,943 35% . 175,771: 141% : 50,771: Patient Fees 96,300 105,742 110% . 96,300 29,283 30% : 111,662 116% . 15,362; i � i I i OHP Fee for Service - 22,993 18,260 8,718 48% . . 35,131 192% . 16,871 r 1 1 1 1 TOTAL RESOURCES 10,793,250 10,651,270 99% ; 10,400,380 3,169,071 30% ; , 10,991,900 106% ; 591,520; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Administration Allocation 2,665,047 2,665,046 100% : 2,927,789 - 0% : : 2,927,789. 100% I . 1 1 1 1 Personnel Services i 10,484,069 9,047,822 86% , 11,612,869 2,436,506 21% . 10,403,569 90% . 1,209,300.D I II I I Materials and Services 3,257,672 2,417,783 74% , 2,387,133. .308,321 13% . • 2,515,465 105% . (128,332); Capital Outlay 77,000 27,376 36% : - . - ! ! .11,200 999% ! (11,200); TOTAL REQUIREMENTS ; 16,483,788 14,158,027 86% : - 16,927,791 2,744,827 16% ; : 15,858,023: 94% : 1,069,768: TRANSFERS Budget Actuals . % Budget . Actuals % Projection % $Variance Transfers In-General Fund 3,631,081 3,631,081 100% : 4,376,806 .1,094,187 25% : . 4,376,806 100% I Transfers In-TRT 444,417 444,417 100% ! 418,417 104,604 25% . . 418,417 100%. i I . e TOTAL TRANSFERS 4,075,498 4,075,498 100% ; 4,795,223 1,198,791 25% ; , 4,795,223 100% ; -: FUND BALANCE Budget Actuals % Budget Actuals , %; _ Projection : % $Variance Beginning Fund Balance 2,869,932 3,049,370 106% : 2,555,592 3,620,221 142% : 3,620,221 142% . 1,064,629.E . Resources over Requirements .; (5,690,538) (3,506,756) - ; (6,527,411) 424,244 • ; (4,866,123) , 1,661,288, Net Transfers-In(Out) 4,075,498 4,075,498 4,795,223 1,198,791 . . 4,795,223 III TOTAL FUND BALANCE . $1,254,892 $3,618,111 288% ; $823,404 $5,243,255 637% ; ; $3,549,320 431% ; $2,725,916: A Carryforward of unbudgeted funds are related to vacancies in COVID Team and Public Health Modernization. g Decrease of$71 K.primarily related to reclassifying$60K of funding from Jefferson County from category of State Misc to Local Grants C Carryforward from FY22 of appx.$40K for Living Well Diabetes Prevention Programs,as well as reclassifying$60K from Jefferson County for disease investigation . . D Personnel projections based on year to date vacancy savings and assume 6%moving forward. - E The stated amount is an estimate.Final Beginning Fund Balance will be determined after the final close of FY22. . . USES C •�y�� 2' Budget to Actuals Report . ` Community Development - Fund 295 FY23 YTD September 30,2022 (unaudited) 25.0% Year Complete I Fiscal Year 2022 . I Fiscal Year2023 I RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Admin-Operations - 138,716 153,688 111% . 153,445 30,199 20% : 149,845 98% (3,600 Code Compliance 842,906 995,865 118% . 1,171,592 . 254,704 22% . • 1,071,592 91% (100,000);A • Building Safety • • 3,819,940 4,325,818 113% • 4,821,160 . 1,296;243 27% • 5,021,660 104% • 200,500. Electrical 914,750. 979,129 107% • 1,022,005 223,809 22% • • 952,005 93% • (70,000)•A Onsite Wastewater 1,056,678 '983,462 93% • 1,017,678 214,346 21% • • 954,178 94% (63,500)•A i II i i Current Planning 1,980,521 2,223,570 112% . 2,425,334 508,757 21% • 2,127,334 88% • (298,000).A Long Range Planning 826,806 880,902 107% • 1,064,305 252,359 24% • 1,014,305 95% (50,000)•A TOTAL RESOURCES 9,580,316 10,542,434 110% : 11,675,519 2,780,417. 24% : , 11,290,919 97% ; (384,600): • REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Admin-Operations 3,137,795 2,960,981 94% : 3,432,980 759,599 22% . 3,105,625 90% : 327,3551 B i I II Code Compliance 617,012 618,343 100% • .805;614 173,506 22% . 747,136 93% . 58,478.B I I II Building Safety 2,284,444 2,022,820 89% • 2,538,721 • , 485,770 19% • 2,050,175 81% . 488,546.B Electrical 556,531 553,223 99% ! 641,837 137,814 21% ! ! 564,695 88% ! 77,142:B I Onsite Wastewater 765,935 643,079 84% . 753,369 178,360 24% I . . 753,369 100% 1 1 I I Current Planning . 1,769,333 1,589,882 90% . 2,062,044 361,687 18% ' 1,608,084 78% . 453,960.B Long Range Planning 847,839 575,615 68% 998,739 181,481 18% : 998,739 100% . -; TOTAL REQUIREMENTS ; ' 9,978,889 8,963,9.43 90% ; 11,233,304 2,278,216 20% : 9,827,823 87% : 1,405,481: TRANSFERS Budget Actuals % Budget Actuals % Projection . % $Variance Transfers In-General Fund 290,000 170,661 59% : 160,000 34,621 22% 160;000 100% : :C I Transfers Out (99,360) (99,360) 100% (112,619) . (28,146), 25% . . (112,619) 100% Transfers Out-CDD Reserve • (461,262) (1,230,508) 267% ; (958;966) (364,736) 38% ;•. (1,712,829) 179% ; (753,863) TOTAL TRANSFERS (270,622) (1,159,207) 428% ; (911;585) (358,261) 39% : : -. (1,665,448) 183% : (753,863): • FUND BALANCE Budget Actuals % Budget Actuals % _ Projection • % $Variance Beginning Fund Balance 1,432,367 1,749,673 122% 2,096,504 2,168,956 103% . . 2,168,956'103% . 72,452.D Resources over Requirements •(398,573) 1,578,491 442,215 502,201 • • 1,463,096 • 1,020,881• Net Transfers-In(Out) (270,622) (1,159,207) • (911,585) (358,261) : ; (1,665,448) . (753,863); • TOTAL FUND BALANCE $763,172 $2;168,956 284% ; $1,627;134 $2,312,897 142% ; : $1,966,604 121% : $339,470: A YTD revenue collection is lower than anticipated due to application volume decrease . B Projections reflectunfilled positions $40K to Current Planning will be transferred as needed D Final Beginning Fund Balance will be determined after the final close of FY22 „Esc., �y-�k uc Budget to Actuals. Report Road -Fund 325 25.0% FY23 YTD September 30, 2022 (unaudited) . . Year Complete Fiscal Year 2022 I Fiscal Year 2023 - RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Motor Vehicle Revenue 17,485,000. .19,740,504 113% : 19,483,147 4,797,051 . 25%.! 19,483,147 100% ! . I Federal-PILT Payment 2,096,751 2,195,918.105% . 2,200,000 2,239,616 102% . 2,239,616 102% . 39,616.A Other Inter-fund Services 1,221,632 1,254,413.103% . 1,311,901 23,577 2% • 1,311,901 100% Forest Receipts 627,207 792,420 126% I 882,502 0% • 882,502 100% • Sale of Equip&Material 449,150 : 341,833 76% 1 426,000 2,161 1% 426,000 100% Cities-Bend/Red/Sis/La Pine 560,000 155,269 28% • 403,731 - 0% • • 403,731. 100% Miscellaneous. . 67,340 68,747 102% • 77,610: 19,951 26% • 77,610 100% i ; Interest on Investments 59,109 55,083 93% ! 54,172 10,118 19% ! 40,470 75% ! (13,702) B Mineral Lease Royalties 60,000 -148,267 247% • 50,000 707. 1% 50,000 100% Assessment Payments(P&I) 3,460 . 16,052 464% 1 - 2,541 • 10,000 10,000 C 1 I I i 1 TOTAL RESOURCES .22,629,649 24,768,506 109%.; 24,889,063 7,095,722 29% ; , 24,924,977 100% ; 35,914; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Personnel Services 6,916,229 6,751,810: 98% 7,802,271 1,772,245 23% 7,581 974 97% • 220,297.D IMaterials and Services 7,843,400 6,877,560 88% 8,315,339 1,787,619 21% 8,315,339 100%•• Capital Outlay 264,500 141,754 54% 71,386 31,277. 44% 71,386 100% 1 TOTAL REQUIREMENTS 15,024,128 13,771,124 92% ; 16,188,996 3,591,141 22% ; , 15,968,699 99% ; 220,297; TRANSFERS Budget Actuals % Budget Actuals . . % Projection % $Variance Transfers Out . -(11,757,547) (11,757,547).100% 1 (12,330,136) (7,440,775) 60% o (12,330,136) 100% -; TOTAL TRANSFERS ; (11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% ; ; (12,330,136) 100% ; , FUND BALANCE Budget Actuals % Budget Actuals % Projection % . $Variance Beginning Fund Balance 6,383,832 8,566,521.1.34% • 5,892,967 7,806,356. 132% • 7,806,356 132% • 1,913,390.:E Resources over Requirements _ 7,605,521 10,997,382 1 8,700,067 .3,504,581_ 1 8,956,278_ 1 256,211! .. 1 1 I 1 :I 1 Net Transfers-In(Out) (11,757,547) (11,757,547) • (12,330,136) (7,440,775) • (12,330,136) • -; TOTAL FUND BALANCE $2,231,806 $7,806,356.350%.; $2,262,898.: $3,870,162 171% ; ; $4,432,499 196% ; $2,169,601; A Actual payment higher than budget g . Investment Income projected to come in lower than budget c Updated based on YTD actuals trending higher than budgeted D Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.1% E Final Beginning Fund Balance will be determined after the final close of FY22 47°'R `°°2{ Budget to Actuals Report: ' ' Adult P&P - Fund 355 . 25.0%iiiie FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 Fiscal Year2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance DOC Grantin Aid SB 1145 4,202,885 4,734,453 113% 4,734,453 1,183,613 25% 1 : 4,734,453 100% i CJC Justice Reinvestment 781,597 892,038 114% 892,038 446,019 50% . 892,038 100% Measure 57 255,545 244,606 96% 244,606 244,606 100% . 271,606 111% . 27,000.A iState Miscellaneous 138,000 96,068 70% 123,453 - 0% . • 123,453 100% Interfund-Sheriff • 50,000 55,000 110% ' 50,000 12,500 25% 50,000 100%-; -, Gen Fund/Crime Prevention • 50,000 50,000 100% . 50,000 - 0% 50,000 100% ; Oregon BOPPPS 24,281 20,318 84% : 20,318 . - 0% • . 20,318 100% Interest on Investments 45,193 19,125 42% ! 18,151 9,786 54% • . 39,140 216% . 20,989.B II Miscellaneous 500 3,904 781% • 500 72 14% • • 500 100% Electronic Monitoring Fee 2,500 280 11% : 500 235 47% 500 100% ; DOC-Family Sentence Alt 118,250 58,958 50% ' - - • . - I 1 Probation Work Crew Fees 1,500 - 0% - - - - . I I Probation Supervision Fees - 170,000 3,606 2% - - - - - - - -- 1 I 1 1 I I TOTAL RESOURCES 5,840,250 6,178,356 106% : 6,134;018 1,896,831 31% ; , 6,182,007 101% ; 47,989: REQUIREMENTS Budget Actuals % . Budget Actuals % Projection % $Variance Personnel Services 5,379,503 4,864,354 90% : 5,683,822 1,246,365 22% : 5,070,293 89% : 613,529:C Materials and Services 1,700,412 1,528,224 90% 1,883,614 296,489 16% : 1,883,614 100% Capital Outlay - 8,475 598. 7% • 8,475 100% ; -� TOTAL REQUIREMENTS ; 7,079,915 6,392,578 90% ; 7,575,910 1,543,452 20% ; , 6,962,381 92% ; 613,529: TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfers In-General Funds . . 662,046 - 662,045 100% 1 _ - 536,369 134,088 -25% 536,369 100% Transfer to Vehicle Maint (190,974) (190,974) 100% ! (69,277) (17,319) 25% (69,277) 100% ; TOTAL TRANSFERS 471,072 471,071 100% : 467,092 116,769 25% ; , 467,092 100% : FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance 2,739,775 2,982,055 109% . 3,100,000 3,238,905 104% 3,238,905 104% . 138,904.D Resources over Requirements ' (1,239,665) (214,221) (1,441,892) 353,379 ; ; (780,374) 661,518. Net Transfers-In(Out) - 471,072 471,071 - 467,092 116,769 - - 467,092 - . - I - -� TOTAL FUND BALANCE : $1,971,182 $3,238,905 164% ; $2,125,200 $3,709,053 175% ; ; $2,925,623 138% ; $800,423: A DOC has increased funds for M57.Deschutes County received an additional$27K for housing and curriculum training. g Investment Income projected to come in higher than budget c Projected Personnel savings based on FY22/FY23 average vacancy rate of 11% D Final Beginning Fund Balance will be determined after the final close of FY22 uSEs c ° Budget to Actuals. Report : Road CIP - Fund 465 Nef0 FY23 YTD September 30, 2022 (unaudited) 25.0/o Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance State Miscellaneous 2,191,461 . 1,000,000 46% : 1,818,500 - 0% 1 : 818,500 45% : (1,000,000)i A Interest on Investments 279,729 124,832- 45% . 124,563. . 63,889 51% 255,560 205% 130,997.B I I 11 I I TOTAL RESOURCES 2,471,190 1,124,832 46% 1,943,063 .63,889 3% ; , 1,074,060 55% ; (869,003): REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Materials and Services 109,870 109,870 100% : 127,640 . 31,910 25% : : 127,640 100% Capital Outlay . 29,612,821 7,996,247 27% '28,259,526 12,003,578 42% 27,251,021, 96% . 1,008,505 TOTAL REQUIREMENTS ; 29,722,691 8,106,117 27% ; 28,387,166 12,035,488 42% ; 27,378,661 96% ; 1,008,505: TRANSFERS Budget Actuals - % Budget Actuals % Projection % $Variance Transfers In 12,193,917 10,672,113 88% 14,230,313 4,889,361. 34% : : 14,230,313 100% I I l i 1 I TOTAL TRANSFERS 12,193,917 10,672,113 88% ; 14,230,313 4,889,361 34% ; , '14,230,313 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection . % $Variance Beginning Fund Balance 20,374,044 23,533,004 116% 24,548,274 27,223,832 111% . 27,223,832 111% 2,675,558.C Resources over Requirements ; (27,251,501) (6,981,285) ; (26,444,103) (11,97'1,599) . (26,304,601) . 139,502. Net Transfers-In(Out) 12,193,917 10,672,113 14,230,313 4,889,361 14,230,313 TOTAL FUND BALANCE $5,316,460 $27,223,832 512% ; $12,334,484 $20,141,594 163% ; $15,149,544 123% ; $2,815,060: A $1 M was budgeted in FY23,but received in FY22 g Investment Income projected to come in higher than budget c Final Beginning Fund Balance will be determined after the final close of FY22 Wye �.,, `ia Budget to Actuals Report ° '' °` Road CIP.(Fund 465)-Capital Outlay:Summary by-Project 25.0% .W. FY23 YTb September 30,2022.(unaudited) ' . Year Completed . . Fiscal Year 2022.'.' Fiscal Year 2023' . Budget - . 'Actuals I %' .Budget ; , Actuals . J- :% ' Projection ,:'.% $Variance Terrebonne Refinement Plan • $ 10,000,000 $ $ 7,319,310,:$ : 2,200,000' 30% -$ : - -7,319,310, 100% $ - - - US 20 at Tumalo -; •6,700,000 6,700,000 6,700,000 100% 6,700,000 100% - -A •Tumalo Road/Tumalo Place - 67,998 . . '` - ,. - •Old Bend dm/Tumalo Rd Inter • 16,90T • - R_ - • NE Negus and 17TH 2,363,532' "- 2,142,875 91% - - Hunnel Rd:Loco Rd to Tumalo Rd 2,168,940 ' •637,975 29% 4,265,216 • .. 55,660 1% • .4,826,216' 113% (555,006) Transportation System Plan'Update • 108,510 _ 86,081.-79% - 3,242 :.'40,000-. (40;000) Gribbling Rd Bridge .. 279,575 1,110 0%• 818,500 - 1,814 - 0%• 418,500: 51%- 400,000 • Terrebonne Wastewater Feasibility St.. 35,130 -..I. Rickard Rd:Groff Rd to US 20• . . 1,716,142: .1,391,051 81% - . . - • , - Paving Powell Butte Hwy" 931,140 '1,319,374 142% - ' ' - Smith_Rock Way Bridge Replace_ _ - • 505,000 1,869. 0% 985,000 1,163 0% - 485,000 49% .500,000 Deschutes Mkt Rd/Hamehook Round 671;000. -i ' 208,367 31% 1,663,000 0% 1,663,000 100%- - • Paving Cottonwood:Us 97 To BSNF RR -618,144: _ 499,075 81% - - "" - - Paving Desch Mkt Rd:Yeoman Hamehoo 310,838, .- ' 0% 443,000 . "- - , 0% - 0% 443,000 • Paving Alfalfa Mkt Rd:Mp 4 Dodds - 265,000 " 2,638 1% 1,200,0,00 . 1,471,578 123% .-• '1,748,164 146% (548,164) Paving Of Hamby Rd:Us 20 To Butler .200,000 - 1,912- 1% 333,000 ' 999,285. ,300% -999,286 300% (666,286) Powell Butte Hwy/Butler Market RB'. - 150,000' • 38,562 26% 785,000 ' .18,290 i •2/, 335,000 "43% 450,000 • Wilcox Ave Bridge#2171-03 Replacem .100,000- , - 0% . 160,000 0% 160,060 100%. - US 20:Tomalo.Multi-Use Path Crossing -• ' 1,250,000 :1,200,000 96% - - - - • Highway Warning Systems 2021 - • 69,536, - - - - Tumalo Wastewater Feasibility Study - 219 - - - . Paving:Tumalo Rd/Deschutes Mkt Rd. 1,640 246,000 .32,693' 13% 32,692. 13% • 213,308 Slurry Seal - - - 1,148 - 337,183. • _ . . 337,183 ' (337,183) Paving of Rosland Rd:US 20 to Draf - _ - - 380,000 - 0% - '380,000 100% Intersection Safety Improvements - '• 150,000 , • 0% - - 0% 150,000 Hamehook Rd Bridge#16181 Rehabilitation - • : 96,500 " - . 0% 40,000 '41% - 56,500 NW Lower Bridge Way:43rd St to Holmes Rd- .. '. - 100,000 ,; 0% 100,000: 100% - • Northwest Way: NW Coyner Ave to NW Attmeter:Wy ' - ,. 815,000:: • - 0% -' :-815,000 100% • Slurry Seal 2023 - . - 300,060 i :-• - 0% -300,000 100% - - Terrebonne Wastewater System Phase 1 ' 1,000,000 0% 0% 1,000,000 B. Tumalo Resevoir Rd:OB Riley to Sisemore Rd -:100,000 •• .•"0%; 100,000 100% _ - • - Local Road Pavement Preservation - - - • 200,000 0% 260,000 100% -C FY 22 Guardrail Improvements 100,000 114,378 .114% - - - - - • FY 23 Guardrail lmrovements - • _ 150,000 - 0% ' ' 75,000. 50% 75,000 ' Redmond District Local Roads: 500;000." . 0% - -C: ' Bend District Local Roads - - "500,000:"- : ' - 0% - -- - - ' -C - : Sidewalk Ramp Improvements 75,000 - -156,557 209% 50,000.; - 182,670 365% : • " 182,670 365% - -(132,670) • Signage Improvements -• : : - 100,000 .1,843 2% -.- . :. - - - .. TOTAL CAPITAL OUTLAY. $29,612,821 " $7,996,247 27% $28,259,526 12,003,578 42% $27,251,021 96% $1,008,505 - A Budgeted in FY 22 in project US 20:Cook Ave/OB Riley Rd(Tumalo) _ . B This project will be moved to FY 23 - - "- C These projects were re-named to Local Road Pavement Preservation - - . ' - . : o Jks` 2� Budget to Actuals Report L� �G Solid Waste - Fund 610 W. FY23 YTD September 30, 2022 (unaudited) 25.0% Year Complete Fiscal Year 2022 Fiscal Year 2023 RESOURCES Budget Actuals % Budget . Actuals % Projection % $Variance Franchise Disposal Fees 7,124,000 6,891,500 97% . 7,210,000 2,228,732 3.1% : : 7,210,000 100% 'A I Private Disposal Fees 2,827,000 3,191,189 113% • 3,337,000 959,123 29% • • 3,337,000 100% 'A Commercial Disp.Fee 2,686,000 3,075,123 114% ! 3,234,000 965,822 30% • • 3,234,000 100% !I ,A Franchise 3%Fees 290,000 337,878 117% ' 305,000 70,319 23% 305,000 100% -. B Yard Debris • 300,000 268,060 89% • 290,000 95,152 33% • ' 290,000 100% Miscellaneous • 55,000 88,470 161% ; 70,000 28,661 41% • • 70,000 100% I Interest on Investments 41,599 27,916 67% • 30,498 9,622 32% 38,490 126% . 7,992.C ISpecial Waste 15,000 37,718 251% ' 15,000 10,049 67% . • 15,000 100% Recyclables 12,000 12,980 108% I 12,000 2,009 17% • • 12,000 100% Leases 1 1 100% I 1 - 0% . • 1 -100% I I I 1 TOTAL RESOURCES 13,350,600 13,930,834 104% : 14,503,499 4,369,489 30% : , 14,511,491 100% : 7,992: REQUIREMENTS Budget 'Actuals % Budget Actuals . .% Projection % $Variance Personnel Services 2,754,132 2,694,834 98% : 3,277,684 726,398 22% : : 3,277,684 100% Materials and Services 5,651,103 5,192,786 92% : 6,473,358 961,793 15% : : 6,473,358 100% Capital Outlay 53,141 . 76,304 144% • 264,000 - 0% ; ; 264,000 100% Debt Service 1,251,615 797,852 64% • 1,739,630. 204,993 12% ' • 1,739,630 100% ,D TOTAL REQUIREMENTS 9,709,991 8,761,777 90% : 11,754,672 -1,893,184 16% ; : 11,754,672 100% : -: TRANSFERS Budget •Actuals % Budget Actuals . % Projection % $Variance SW Capital&Equipment (6,029,323) (6,029,323) 100% (5,299,665) (1,323,489) 25% (5,299,665) 100% - Reserve TOTAL TRANSFERS (6,029,323) (6,029,323) 100% (5,299,665) (1,323,489), 25% (5,299,665) 100% - FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance 2,972,234 3,957,273 133% : 3,107,198 3,097,007 100% 3,097,007 100% . (10,191);E Resources over Requirements • 3,640,609 5,169,057 2,748,827 2,476,305 . • • 2,756,819 7,992 Net Transfers-In(Out) (6,029,323) (6,029,323) . . (5,299,665) .(1,323,489) • i . (5,299,665) • -. TOTAL FUND BALANCE $583,520 $3,097,007 531% : $556,359 $4,249,823 764% : ; $554,161 100% : ($2,199): A Total disposal fee projections reflect management's best estimate of revenues to be collected;disposal tons are typically higher in the summer with reductions in winter.YTD volumes are running 9%higher than last year-to-date.Franchise disposal fee payments of$407K were overpaid by Republic Services(Bend Garbage,High Country&Wilderness)and will be applied to the next month. g Annual fees due April.15,2023;received year-to-date monthly installments from Republic c Investment Income projected to come in higher than budget D Final FFC.2022 funding includes issuance costs and a full year.of interest due by June 2023,while the budget reflects 1/2 year estimated interest.A budget adjustment to increase appropriations was preserited and approved by the BOCC in September. E Final Beginning Fund Balance will be determined after the final close of FY22 , c �� Budget to Actuals Report _ C.� �G . Fair & Expo - Fund 615. 25.0% 0 FY23 YTD September 30, 2022 (unaudited) Year.Complete Fiscal Year 2022 • I ,: Fiscal Year.2023 _ • I RESOURCES Budget Actuals•. % Budget Actuals % Projection % $Variance Events Revenue 578,000 786,724 136% ' 745,759 166,698 22% , 745,759 100% Food&Beverage 513,500 • 792,639 154% 415,000 157,445 38% ; • 415,000 100% Rights&Signage 105,000 38,192 36%° • 105,000 .35,400 34% • ' 105,000 100% Storage 77,500 __ 46,525 60% 65,000 - 0% . 65,000 100% ; Horse Stall Rental ' 71,500 66,636 93% . 49,000 - 0% • 49,000 100% Camping Fee 19,500 11,675 60% 20,000 2,750 14% 20,000 100% Interest 474 5,301 999% 5,221 .2,551 49% • • 10,200 195% . 4,979.A Miscellaneous 250 2,032' 813% ! 3,554 1,068 30% !I ! 3,554 100% Interfund Payment 30,000 • 30,000 100% . - - -� 1 1 I I TOTAL RESOURCES 1,395,724 1,779,723 128% : 1,408,534 365,912 26% : , 1,413,513 100% : 4,979; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Personnel Services 1,118,980 1;129,821 .101% : 1,256,902 294,705 23% : 1,072,283 85% : 184,619.B Personnel Services-F&B 181,593 200,062 110% i 170,247 13,165 8% ! 139,709 82% ! 30,538;C Materials and Services 818,804 852,050 104% : 965,684 '181,870 19% ! 965,684 100% Materials and Services-F&B 282,500 342,748 121% . 273,950 62,482 23% . 273,950 100% ; Debt Service 103,000 100,899 98% ! 101,270 - 0% . ! 101,270 100% 1 1 1 i 1 TOTAL REQUIREMENTS ; 2,504,877 2,625,580 105% : 2,768,054 552,222 20% : : 2,552,897 92% ; 215,157: TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfers In-Room Tax 1,093,513 1,049,581' 96% : 1,101,342 275,334 25% 1,130,277 103% ; 28,935;D Transfers In-Park Fund • 30,000 30,000 100% ! 30,000 7,500 25% 30,000 100% - Transfers In-County Fair 150,000 • 150,000 100% - - - - Transfers Out (310,777) (310,777) 100% (427,215) (106,803) 25% (427,215) 100% . -; TOTAL TRANSFERS 902,736 918,804 95%0 ; 704,127 . 176,031 25% ; : .733,062 104% : 28,935: FUND BALANCE Budget Actuals % Budget Actuals '%- Projection % $Variance Beginning Fund Balance 750,673 923,473. 123% ; 971,352 996,420 103% ; • 996,420 103% : 25,068i E Resources over Requirements (1,109,153) (845,857) ! (1,359,520) (186,310) ; (1,139,384) ! 220,136; Net Transfers-In(Out) 962,736 - 918,804 704,127 176,031 i 733,062 . 28,935; i i ii TOTAL FUND BALANCE : $604,256 $996,420 165%.; $315,960 $986,141 312% ; $590,098 187% ; $274,139; A Investment Income projected to come in higher than budget . g Projected Personnel savings based on FY22/FY23 average vacancy rate of 20% . C Projected•Personnel based on vacancy savings to date D Transfers expected to be higher than budget due to increased Room Tax revenue .E Final Beginning Fund Balance will be determined after the final close of FY22 • • • V'(ES C . . �y`� °°tip •Budget to Actuals Report . `'' ''` Annual County Fair - Fund 616 . 25.0% 0 1%1107FY23 YTD September 30,2022 (unaudited) Year Complete Fiscal Year 2022 . '..__ . Fiscal Year 2023 : , RESOURCES Budget Actuals % Budget • Actuals % Projection % $Variance Gate Receipts 550,000. •.73'8,029 134% 1 710,000 782,364 1.10% . 782,424 110% : 72,424: Concessions and,Catering 385,00'0 526,737 137% ! 505,000 .815,458 161% . 815,461 161% . 310,461! Carnival 330,000 415,716 126% . 385,000 , 433;682 113%. . 433;682 113% . 48,682i; Commercial Exhibitors 110,000 86,200 78% ! 80,000 117,100 146% ! 117,100 146% . 37,100. Fair Sponsorship - ! 83,500 51,035 61% • 61,000 98,370 161% ! 109,370 179% . 48,370. State Grant 52,000 53,167 102% • 53,167 53,167 100%. 53,167 100% Rodeo 20,000 24,050 120% • 24,000 30,970 129% • 30,970 129% • 6,970. RN Camping/Horse Stall Rental 25,500 19,815 78% • 20,000 17,520 88% ! ! 17,520 88% : (2,480): Livestock Entry Fees 4,500 - 0% ; 5,000 1,925. .39% • ; 2,169 43% (2,831): Merchandise Sales - . 5,239 • 3,500 3,245 93% ; ; 3,245 93% ; (255): Interest on Investments - 2,683 2,713 1,972 73% • 7;890 291% • 5,177 A I I I 1 TOTAL RESOURCES 1,560,500 1,922,671 123% : 1,849,380 •2,355,773 127% : : 2,372,997 128% : 523,617: REQUIREMENTS Budget Actuals % Budget Actuals % •Projection, % $Variance Personnel Services 155,959 36,681 24% : 169,445 50,339 30% • : 169,445 100% ' Materials and Services • 1,312,172. 1,316,102 100% • 1,682,585 1,284,569 76% 1,682,585 100% TOTAL REQUIREMENTS ; 1,468,131 1,352,783 92% : 1,852,030 1,334,908 72% ; 1,852,030 100% ; -: TRANSFERS Budget Actuals % Budget Actuals %° Projection : % $Variance Transfer In-TRT 1% 75,000 75,000 100% : 75,000, 18,750 25% • 75,000 100% • - 1 1 1 . 1 1 Transfer Out-Fair&Expo (150,000) (150,000) 100% • - . - - •Transfers Out - •• . (231,706) • (57,924) 25% • -• (231,706).100% TOTAL TRANSFERS (75,000) .(75,000) 100% ; -(156;706) (39,174) 25%. : ; (156,706) 100% ; -: FUND BALANCE Budget Actuals % Budget Actuals % •Projection % $Variance Beginning Fund Balance - (109,033) 999% 384,715 385,854 100% • : 385,854 100% : 1,139:B Resources over Requirements ; 92,369 5.69,888 • : (2,650) 1,020,865 • ! 520,967 • 523,617. Net Transfers-In(Out) (75,000) (75,000) (156,706)- (39,174) • (156,706) � TOTAL FUND BALANCE $17,369 $385,854 999% ; - $225,358 $1,367,546 607% ; ; $750,115 333% ; $524,757: • A Investment Income projected to come in higher than budget. g Final Beginning Fund Balance will be determined after the final close of FY22 �y`�uTES biA Budget to Actuals Report Annual County Fair - Fund 616 11110 CY22 YTD September 30, 2022 (unaudited) Fair 2022 Actuals to 2022 Fair 2021 Date Projection RESOURCES Gate Receipts $ 738,029 $ 782,364 $ 782,364 Carnival 415,716 433,682 433,682 Commercial Exhibitors 315,719 - 436,292 436,292 Livestock Entry Fees - 1,925 1,925 RN Camping/Horse Stall Rental 19,944 17,392 17,392 Merchandise Sales 5,239 3,245 3,245 Concessions and Catering 295,093 r. 497,366 497,366 Fair Sponsorship 8.1,125 'A 123,300. 123,300 TOTAL FAIR REVENUES $ 1,870;865 "_A $ 2,295,566 $ 2,295,566 OTHER RESOURCES State Grant 53,167 53,167 53,167 Interest 1,194 2,030 3,155 Miscellaneous - - - TOTAL RESOURCES $ 1,925,226 $ 2,350,762 $ 2,351,887 REQUIREMENTS Personnel 103,199 73,771 119,504 Materials&Services 1,249,932 1,357,063 1,684,658 TOTAL REQUIREMENTS $ 1,353,131 $ 1,430,834 $ 1,804,162 TRANSFERS Transfer In-TRT 1% 74,750 56,250 75,000 Transfer Out-F&E Reserve - (57,924) (115,848) Transfer Out-Fair&Expo (150,000) TOTAL TRANSFERS $ (75,250) $ (1,674) $ (40,848) Net Fair $ 496,845 $ 918,254 $ 506,878 Beginning Fund Balance on Jan 1 $ (48,694) $ 448,151 $ 448,151 Ending Balance $ 448,151 $ 1,366,405 $ 955,029 ‘yrES`°°z, Budget to Actuals Report Fair & Expo Capital Reserve - Fund 617 FY23 YTD September 30,2022 (unaudited) .. 25.0%Year Complete Fiscal Year 2022 . ,_: I Fiscal Year,2023 RESOURCES Budget Actuals . % Budget Actuals % Projection % $Variance Interest on Investments 1 8,544 •.. 8,012 94% :1 7,414 4,988 67% :1 1 19,950 269% . 12,536:1 A I TOTAL RESOURCES 8,544 8,012 94% ; 7,414 4,988 67% ; , 19,950 269% ; 12,536; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Materials and Services 180,000 8,564 5% 220,000 92 0% : 1 220,000 100% Capital Outlay 388,000 (894) 0% 650,000 - 0% • • 650,000 100% • B TOTAL REQUIREMENTS ; 568,000 . 7,670 1% ; 870,000 92 0% ; , 870,000 100% ; , TRANSFERS Budget Actuals. % Budget Actuals % Projection % $Variance Transfers In-TRT 1% 498,901 -. 479,502 96% : 501,683 125,418 25% 514,086 102% • 12,403.C Transfers In-Fair&Expo 300,000 300,000 100% 416,437 104,109 25% :+ 416,437 100% • Transfers In-Annual County Fair - 231,706 - :57,924 25% • . 231,706 100% • 1 1 1 1 1 TOTAL TRANSFERS 798,901 779,502 98% ; 1,149,827 287,451 25% ; , 1,162,230 101% ; 12,403; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance 1,101,663 1,029,596 93% 1,299,942. 1,809,440 139% : 1,809,440 139% 509,498:.D Resources over Requirements I (559,456) 342 • (862;586) 4,896 • • (850,050) • 12,536• Net Transfers-In(Out) 798,901 779,502 1;149,827 287,451 1,162,230 12,403- 1 1 1 TOTAL FUND BALANCE $1,341,108 $1,809,440 135% ; $1,587,183 $2,101,787 132% ; ; $2,121,620 134% ; $534,437; A Investment Income projected to come in higher than budget g Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction c Transfers expected to be higher than budget due to increased Room Tax revenue D Final Beginning Fund Balance will be determined after the final close of FY22 Q _Jc �G s` 2orirk� Budget to Act uals tuals. Report C.� RV Park - Fund618 Iftif FY23 YTD September 30, 2022 (unaudited) 25-�% Year Complete .: Fiscal Year 2022 I Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance RV Park Fees<31 Days 495,000 551,683 111% ; 605,000 188,106 31% 605,000 100% I Cancellation Fees - 15,725 14,000 4,067 29% • • 14,000 100% RV Park Fees>30 Days 10,500 8,499 81% 13,000 • - 0% 13,000 100% Washer/Dryer 5,000 3,476 70% • 4,200 2,568 61% • 4,200,100% • I Miscellaneous 2,500 • • 3,731 149% I 3,750 987 26% • • 3,750 100% • Vending Machines 2,500 1,021 41% I 1,750 896 51% • . 1,750 100% • Interest on Investments 2,024 578 '29% •I 552 414 75% !I • 1,660 301% ! 1,108• .A f I- - TOTAL RESOURCES 517,524 584,713 113% : 642,252 197,038 31% : , 643,360 100% : 1,108: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Personnel Services 19,456 1,643 8% : 111,153 21,275 19% • • 104,640 94% • 6,513.B Materials and Services 310,805 •242,863 78% 259,755 80,106 31% ; • 259,755 100% ; Debt Service 221,927 221,629 100% • 223,273 - 0% • • 223,273 100% 1 1 1 I TOTAL REQUIREMENTS 552,188 466,135 84% ; 594,181 . 101,381 17% ; 587,668 99% : 6,513; TRANSFERS Budget Actuals % Budget Actuals % Projection % $Variance Transfers In-Park Fund 160,000 160,000 100% ; 160,000 - 0% • 160,000 100% : :C Transfers In-TRT Fund 20,000 20,000 100% ! 20,000 4,998 25% ! 20,000 100% • - Transfer Out-RV Reserve . (132,042) (132,042) 100% : (261,566) (65,391) 25% (261,566). 100% : -! TOTAL TRANSFERS 47,958 47,958 100% : (81,566) (60,393) 74% ; ; . (81,566) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % . $Variance Beginning Fund Balance - - • 116,415 166,536 143% • : . 166,536 143% : 50,121.D Resources over Requirements (34,664) 118,578 • 48,071 95,657 55,692 7,621. Net Transfers-In(Out) 47,958 47,958 • (81,566) (60,393). • (81,566) • -. TOTAL FUND BALANCE $13,294 $166,536 999% ; $82,920 $201,801 243% ; ; $140,662 170% ; $57,742: A Investment Income projected to come in higher than budget g -. Projected Personnel based on vacancy savings to date C Transfer booked in November D Final Beginning Fund Balance will be determined after the final close of FY22 '(Es . 4-0 Budget to Actuals Report.. . RV Park Reserve - Fund 619 0 W FY23 YTD September 30, 2022 (unaudited) 25.0% Year Complete Fiscal Year 2022 Fiscal Year 2023 • RESOURCES • Budget Actuals • ."/% Budget Actuals % •Projection % $Variance Interest on Investments 7,546. . 6,354 84% 6.298 3,100. 49% 12,400 197% : 6,102:A . 1 TOTAL RESOURCES • 7,546 6,354 84% ; 6,298 3,100 49% ; ; .. . 12,400 197% ; 6,102: REQUIREMENTS Budget . Actuals % Budget Actuals % Projection - • % $Variance Capital Outlay 100,000 885• 1% : 100,000 • .. • - 0% : : 100,000 100% . -B I 1 l i 1 I TOTAL-REQUIREMENTS ; 100;000 885 1% ; 100,000 - 0% ; , 100,000 100% ; , TRANSFERS Budget Actuals % Budget Actuals. % Projection % $Variance Transfer In-RV Park Ops 132,042 132,042 100% : 261,750 65,391 25% : : 261,566 100% : (184); I. i i TOTAL TRANSFERS 132,042 : 132,042 100% ; -261,750 65,391 25% ; , 261,566 100% ; (184); FUND BALANCE Budget_ Actuals •,. %.. Budget • Actuals % Projection, % $Variance Beginning Fund Balance 784,466 - 1,054,426 134% - 1,172,718 1,191,937 102% : 1,191,937 102% : • 19,219:C Resources over Requirements (92,454) 5,469 (93,702) 3,100 (87,600) 6,102; Net Transfers-In(Out) 132,042 132,042 261,750 • . 65,391 • 261,566 (184); TOTAL FUND BALANCE $824,054 $1,191,937 145% ; $1,340,766 $1;260,427 94% ; ; . $1,365,903 102% ; $25,137; A Investment Income projected to come in higher than budget g Capital Outlay appropriations are a placeholder c Final Beginning Fund Balance will be determined after the final close of FY22 VCESC 2G� .0 6 Budget to Actuals. Report . Risk Management - Fund 670 25.0% FY23 YTD September 30,2022 (unaudited) . . Year Complete Fiscal Year 2022 . - Fiscal Year 2023 RESOURCES Budget Actuals % Budget . Actuals % Projection % $Variance Workers'Compensation 1,120,766 1,164,543 104% : 1,234;761 306,045 25% 1,234,761 100% General Liability 944,278 940,773 100% ! 892,681 223,170 25% • • 892,681 100% Unemployment 323,572 334,147 103% . 430,179 26.0,540 61% • 430,179 100% 'A Property Damage 393,546 409,593 104% : 419,566 104,892 25% • 419,566 100% Vehicle 227,700 227,700 100% . 248,764 62,191 25% 248,764' 100% Interest on Investments 101,111 50,142 50% ; 49,346 23,031 47% 92,120 187% . 42,774 B Claims Reimbursement .25,000 1,280,876 999% 25,000 1,110 4% 25,000 100% Skid Car Training 10,000 - 0% . 10,000 - 0% 5,000 50% . (5,000);C Process Fee-Events/Parades 1,000 1,485 149% ! 1,000 315 32% • 1,000 100% II Miscellaneous - 180 • 180 0% . • 180 100% I • I I I 1 TOTAL RESOURCES 3,146,973 4,409,440 140% : 3,311,477 981,293 30% : , 3,349,251 101% : 37,774: REQUIREMENTS - Budget Actuals % Budget Actuals % Projection % $Variance General Liability 3,600,000 2,706,359 75% 3,000,000 180,757 6% 2,700,000 90% : 300,000.D Workers'Compensation 1,580,000 953,365 60% ! 1,580,000 462,223 29% ! 1,700,000 108% ! (120,000);E Insurance Administration 547,047 491,393 90% • 607,558 148,447 24% • • ,607,558 100% Property Damage 300,245 604,926 201% ! 300,248 (3,661) -1% ! ! . 280,000 93% ! 20,248.F Vehicle 200,000 137,356 69% • 200,000 59,442 30% • • 240,000 120% • (40,000).E Unemployment 200,000 89,053 45% ! 200,000 , 0% . ! 200,000 100% TOTAL REQUIREMENTS ; 6,427,292 4,982,451 78% ; 5,887,806 847,208 14% : , 5,727,558 97% ; 160,248: • TRANSFERS Budget Actuals •% Budget Actuals % Projection % $Variance Transfers Out-Vehicle (3,500) (3,500) 100% (3,500) (873) 25% (3,500) 100% - Replacement TOTAL TRANSFERS (3,500) (3,500) 100% (3,500) (873) 25% (3,500) 100% • FUND BALANCE Budget Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance . 8,329,115 9,521,450 114% . 7,687,180 8,944,938 116% 8,944,938 116% : 1,257,758.G Resources over Requirements . (3,280,319) (573,012) (2,576,329) 134,085 • • (2,378,307) 198,022. Net Transfers-In(Out) _ . (3,500) (3,500) • (3,500) (873) .! (3,500) -, TOTAL FUND BALANCE $5,045,296 $8,944,938 177% : $5,107,351 $9,078,150 178% ; $6,563,131 129% : $1,455,780: A Unemployment collected on first$25K of employee's salary in fiscal year g ,Investment Income projected to come in higher than budget • C Skid Car training on hold due.to COVID D Trending lower than budget E Trending higher than budget F . FY22 had abnormally high property damage;anticipating less in FY23 • G Final Beginning Fund Balance will be determined after the final close of FY22 y J • S` 2 Budget to Actuals Report . 144141` ` Health'Benefits - Fund 675 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete • Fiscal Year 2022 , : • Fiscal Year 2023 RESOURCES Budget Actuals % Budget Actuals % Projection % $Variance Internal Premium Charges 18,767,900 19,164,548 102% ; 19,908,221 4,826,650 24%. • 19,908,221 100%.. I COIC Premiums 1,589,000 1;255,305 79% 1,547,778 428,912 28% 1,547,778 100% Employee Co-Pay 1,200,000 1,238,034 103% ; 1,282,015 305,354 24% . 1,282,015 100% ; Retiree I COBRA Premiums 1,060,000. 1,438,217 136% 595,000 134,300 23% 595,000 100% Prescription Rebates 128,000 396,119 309% • 175,000 143,340 82% ; 175,000 100% I Interest 200,277 90,816 45% • 95,686 32,846 34% • . 131,380 137% . 35,694.A I I Claims Reimbursement&Other 82,000 1,487,600 999% 55,000 5,764 10% 55,000 100% I I I TOTAL RESOURCES 23,027,177 25,070,639 109% : , 23,658,700 5,877,165 25% : , 23,694,394 100% ; 35,694: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $Variance Health Benefits 25,140,847 24,583,764 98% : 21,597,563 3,680,500 17% : 1 21,597,563 100% : ;B Deschutes On-Site Pharmacy 2,970,575 3,381,197 114% • 3,779,608 550,860 15% 3,779,608 100% : ,B Deschutes On-Site Clinic 1,141,829 1,190,855 104% I 1,212,497 191,721 16% 1,212,497 100% . I B I I • Wellness 171,142 138,211 "81%. 179,549 30,012 17% 179,549 100% I II I TOTAL REQUIREMENTS ; 29,424,393 29,294,027 100% : 26,769,217 4,453,094 17% ; : 26,769,217 100% ; -: FUND BALANCE Budget 'Actuals % Budget Actuals % Projection % $Variance Beginning Fund Balance 14,772,618 15,527,580 105% ; 11,925,656:• 11,304,191 95% ; ; 11,304,191 95% ; (621,465);C Resources over Requirements . (6,397,216) (4,223,389) (3,110,517) 1,424,072 ; ; (3,074,823) 35,694; Net Transfers-In(Out) - - - - TOTAL FUND BALANCE : $8,375,402 $11,304,191 135% ; $8,815,139 $12,728,262 144% ; : $8,229,368 93% ; ($585,771); A Investment Income projected to come in higher than budget g Amounts are paid 1 month in arrears c Final Beginning Fund Balance will be determined after the final close of FY22 '9''kS C°G2 Budget to Actuals. Report 911 - Fund 705 and 710 ' 25.0% FY23 YTD September 30, 2022 (unaudited) Year Complete Fiscal Year 2022 , I Fiscal Year 2023 RESOURCES Budget Actuals .% Budget Actuals % Projection % $Variance Property Taxes-Current Yr 9,803,579 9,931,743 101% : 10,402,834 41,717.. 0% : 10,402,834 100% ;A Telephone User Tax 1,106,750 1,815,283 164% . 1,668,000 - 0% . 1,668,000 100% .B State Reimbursement 60,000 123,282 205% ! 810,000 - 0% : 810,000 100% ;C Police RMS User Fees 236,576 237,221 100% ! 237,221 0% . 237,221 100% . 2 D I Contract Payments 147,956 157,552 106% . 153,292 10,620 7% . ' 153,292 100% I I User Fee 233,576 140,986 60% 140,445 _ 2,156 2% • 140,445 100% Data Network Reimbursement 162,000 244,799 15.1% 120,874 19,662 16% ; 120,874 100% Property Taxes-Prior Yr 115,000 92,601 81% 80,000 34,285 43% 80,000 100% Interest 96,867 69,988 72% • 67;515 28,714, 43% • 116,280 172% . 48,765 E Property Taxes-Jefferson Co. 38,344 • 37,525 98% 39,497 252 1% ! 39,497•100% : Miscellaneous •18,658 45,553 244% 25,000 3,245 13% . 25,000 100% 1 I • I • 1 TOTAL RESOURCES 12;019,306 12,896,533 107% ; 13,744,678 140,651 1% : : 13,793,443 100% ; 48,765: REQUIREMENTS Budget Actuals • %° Budget . Actuals % Projection_ % $Variance Personnel Services 8,005,795 7,462,327 93% : 8,606,196 1,940,334 23% : : 7,563,412 88% : 1,042,784:F I Materials and Services 1 3,582,212 2,915,749 81% 4,088,201 705,129 17% 4,088,201 100% Capital Outlay 2,975,000 518,824. 17% 5,075,000. 198,137 4% 5,075,000 100% i 1 1 1 1 TOTAL REQUIREMENTS : 14,563,007 10,896,900 75% : 17,769,397, 2,843,599 16% : , 16,726,613 94% : 1,042,784: FUND BALANCE Budget Actuals % Budget Actuals % Projection . % $Variance Beginning Fund Balance- 11,850,783 10,709,072 90% : 12,950,799 12,708,705 98% : : 12,708,705 98% : (242,094): Resources over Requirements (2;543,701) 1,999,633 (4,024,719)- (2,702,948) (2,933,170) 1,091,549: 1 :I :I :1 1 Net Transfers-In(Out) - - . - • I - I TOTAL FUND BALANCE $9,307,082 $12,708,705 137% ; $8,926,080 $10,005,757 112% ; ; $9,775,535 110% ;. $849,455: A Current year taxes received primarily in November,February and May . .• g Telephone tax payments are received quarterly c State GIS reimbursements are received quarterly . D Invoices are mailed in the Spring E Investment Income projected to come in higher than budget . . F Projected Personnel savings based on FY22/FY23 average vacancy rate of 13.5% G: Final Beginning Fund Balance will be determined after the final close of FY22