Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2021-475-Minutes for Meeting November 22,2021 Recorded 12/8/2021
1�vIES CO BOARD OF COMMISSIONERS 1300 NW Wall Street, Bend, Oregon (541) 388-6570 1:00 PM • Recorded in Deschutes County CJ2021-475 Steve Dennison, County Clerk Commissioners' ,journal 12/08/2021 10:40:36 AM 4c,`;r Fs � oG�� II � I I III I I'II II I I IIIIII I II' I ICI ` 2021-475 FOR RECORDING STAMP ONLY MONDAY November 22, 2021 Barnes Sawyer Rooms Live Streamed Video Present were Commissioners Patti Adair, Anthony DeBone, and Phil Chang. Also present were Nick Lelack, County Administrator; David Doyle, County Counsel; and Sharon Keith, BOCC Executive Assistant (via Zoom conference call). This meeting was audio and video recorded and can be accessed at the Deschutes County Meeting Portal website www.deschutes.org/meetings CALL TO ORDER: Chair DeBone called the meeting to order at 1:00 p.m. PLEDGE OF ALLEGIANCE ACTION ITEMS: 1. Consideration of Chair Signature of Document No. 2021-933, a Notice of intent to Award Contract to Pinnacle Architecture Facilities Director Lee Randall presented the document for consideration and explained the necessary design services for the remodel project at 244 NW Kingwood, Redmond. Mr. Randall briefly noted other planned projects. CHANG: Move approval of Document No. 2021-933 ADAIR: Second BOCC MEETING NOVEMBER 22, 2021 PAGE 1 OF 5 VOTE: CHANG: ADAIR: DEBONE: Yes Yes Chair votes yes Motion Carried 2. Consideration of Board approval and Chair signature of Document No. 2021-883, Amendment to Intergovernmental Agreement with Oregon Health Authority Health Services staff Nahad Sadr-Azodi, Tom Kuhn, Cheryl Smallman and Rita Bacho presented the document for consideration via Zoom conference call. Cheryl Smallman reviewed the program elements that are included in this agreement. ADAIR: Move approval of Document No. 2021-883 CHANG: Second VOTE: ADAI R: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried 3. Consideration of Board Signature of Document No. 2021-919, a First Amendment to a Lease with J Bar J Youth Services Property Manager Kristie Bollinger and Deevy Holcomb, Community Justice presented the document for consideration. Ms. Holcomb explained the space usage by J Bar J Youth Services. ADAIR: Move approval of Document No. 2021-919 CHANG: Second VOTE: ADAIR: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried BOCC MEETING NOVEMBER 22, 2021 PAGE 2 OF 5 4. Consideration of Board Signature of Order No. 2021-081, Authorizing the Deschutes County Property Manager to Execute the Lease and Associated Documents with Flexforce Medical Staffing LLC and Arrow Appraisal, LLC to Lease Space Located at 703 N Larch Street, Suite "B", Sisters OR 97759 Property Manager Kristie Bollinger presented the document for consideration. Discussion held on space usage at the building. ADAIR: Move approval of Order No. 2021-081 CHANG: Second VOTE: ADAI R: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried 5. Transient Room Tax Update Chief Financial Officer Greg Munn presented the update and background of transient room tax. Presentation is attached to the record. The use of unallocated transient room tax funds is discretionary. Discussion held on potential uses and investments with the tourism funds. 6. County Treasurer and Finance Report as of October 31, 2021 Chief Financial Officer Greg Munn presented the recent report. Presentation is attached to the record. BOCC MEETING NOVEMBER 22, 2021 PAGE 3 OF 5 7. Report of October 18 internet outage Kevin Furlong, Information Technology Department reported on the Deschutes County provider internet and phone outage on October 18 resulting from a severed internet cable located near a bridge in Tacoma Washington. Mr. Furlong reported on future plans of the department for resilience of internet connectivity including having two data providers rather than a single provider. OTHER ITEMS: • Commissioner DeBone reported the Commissioners attended the Association of Oregon Counties annual conference last week. • Commissioner DeBone visited the Multnomah County staff and also the Speaker of the House on Friday. • Commissioner DeBone participated in the meeting with the County chairs throughout the state and Governor Brown. • Commissioner Chang commented on the last COVID update and pediatric cases and reported the families bringing children into the emergency department for COVID concerns are those that are concerns with the symptoms or exposure. EXECUTIVE SESSION: At the time of 2:50 p.m. the Board went into Executive Sessions under ORS 192.660 (2) (d) Labor Negotiations. The Board came out of Executive Session at 4:08 p.m. to make the following motion: ADAIR: Move approval of Document for County Administrator signature of Document Numbers: • 2021-896, MOU regarding Mobile Crisis Assessment Team • 2021-897, MOU regarding Internal On -Call Crisis Pool • 2021-898, MOU regarding Stabilization Center CHANG: Second BOCC MEETING NOVEMBER 22, 2021 PAGE 4 OF 5 4 VOTE: ADAI R: Yes CHANG: Yes DEBONE: Chair votes yes. Motion Carried At the time of 4:10 p.m., the Board went into Executive Session under ORS 192.660 (2) (a) consideration of employment. The Board came out of Executive Session at 4:17 p.m. Being no further items to come before the Board, the meeting was adjourned at 4:17 p.m. DATED this > Day of � �� "' "�� 2021 for the Deschutes County Board of Commissioners. ANTHONY DERONE, CHAIR PHIL CHANG, VICE CHAIR PATTI ADAIR, COMMISSIONER RECORDING BOCC MEETING NOVEMBER 22, 2021 PAGE 5 OF 5 AvT E 5 CO C, G ! 2� BOARD OF COMMISSIONERS BOARD OF COUNTY COMMISSIONERS MEETING 1:00 PM, MONDAY, NOVEMBER 22, 2021 Barnes Sawyer Rooms - Deschutes Services Bldg - 1300 NW Wall St - Bend (541) 388-6570 1 www.deschutes.org AGENDA MEETING FORMAT In response to the COVID-19 public health emergency, Oregon Governor Kate Brown issued Executive Order 20-16 (later enacted as part of HB 4212) directing government entities to utilize virtual meetings whenever possible and to take necessary measures to facilitate public participation in these virtual meetings. Since May 4, 2020, meetings and hearings of the Deschutes County Board of Commissioners have been conducted primarily in a virtual format. Effective June 30, 2021, COVID-based restrictions have been discontinued. Attendance/Participation options include: A) In Person Attendance and B) Live Stream Video: Members of the public may still view the BOCC meetings/hearings in real time via the Public Meeting Portal at www,deschutes.org/meetings. Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to: citizeninput@deschutes.org or by leaving a voice message at 541-385-1734. Citizen input received by 8:00 a.m. before the start of the meeting will be included in the meeting record. Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for consideration or who are planning to testify in a scheduled public hearing may participate via Zoom meeting. The Zoom meeting id and password will be included in either the public hearing materials or through a meeting invite once your agenda item has been included on the agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are providing testimony during a hearing, you will be placed in the waiting room until the time of testimony, staff will announce your name and unmute your connection to be invited for testimony. Detailed instructions will be included in the public hearing materials and will be announced at the outset of the public hearing. For Public Hearings, the link to the Zoom meeting will be posted in the Public Hearing Notice as well as posted on the Deschutes County website at https://www.deschutes.org/bcc/page/public- ,hearing-notices. CALL TO ORDER PLEDGE OF ALLEGIANCE ACTION ITEMS 1. 1:00 PM Consideration of Chair Signature of Document No. 2021-933, Notice of Intent to Award Contract to Pinnacle Architecture 2. 1:05 PM Consideration of Board approval and Chair signature of Document No. 2021- 883, Amendment to Intergovernmental Agreement with the Oregon Health Authority 3. 1:10 PM Consideration of Board Signature of Document Number 2021-919, a First Amendment to a Lease with j Bar J Youth Services. 4. 1:15 PM Consideration of Board Signature of Order No. 2021-081, Authorizing the Deschutes County Property Manager to Execute the Lease and Associated Documents with Flexforce Medical Staffing, LLC and Arrow Appraisal, LLC to Lease Space Located at 703 N Larch Street, Suite "B", Sisters, OR 97759. 5. 1:20 PM Transient Room Tax Update 6. 1:40 PM County Treasurer and Finance Report as of October 31, 2021. 7. 2:00 PM Report on October 18 internet outage. OTHER ITEMS These can be any items not included on the agenda that the Commissioners wish to discuss as part of the meeting, pursuant to ORS 192.640. EXECUTIVE SESSION At any time during the meeting, an executive session could be called to address issues relating to ORS 192.660(2)(e), real property negotiations, ORS 192.660(2)(h), litigation, ORS 192.660(2)(d), labor negotiations, ORS 192.660(2)(b), personnel issues, or other executive session categories. Executive sessions are closed to the public, however, with few exceptions and under specific guidelines, are open to the media. 8. Executive Session under ORS 192.660 (2) (d) Labor Negotiations ADJOURN November 22, 2021 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 3 Deschutes County encourages persons with disabilities to participate in all programs and activities. This event/location is accessible to people with disabilities. If you need accommodations to make participation possible, please call (541) 617-4747. November 22, 2021 BOARD OF COUNTY COMMISSIONERS MEETING Page 3 of 3 -TES CoG BOARD OF COMMISSIONERS MEETING DATE: November 22, 2021 SUBJECT: Transient Room Tax Update RECOMMENDED MOTION: None. This is an informational update. BACKGROUND AND POLICY IMPLICATIONS: The original Deschutes County Transient Room Tax (TRT) Ordinance was voter -approved and adopted by the Board of County Commissioners in 1975. The ordinance levied a 5% tax on rents collected for the short-term (30 days or less) use of space in lodging establishments located in the unincorporated area of the county. Since then, the rate has been increased three times with the last 1 % increase occurring in 2014. The current rate in the unincorporated are of Deschutes County is 8%. With the recent and unanticipated increase in TRT collections following the onset of the pandemic there has been renewed interest in the history of the program and eligible uses of the funds. At the work session, staff will present the history and regulations of the county and state TRT programs, comparisons to other city and county TRT programs and permitted uses of the funds. BUDGET IMPACTS: None. ATTENDANCE: Greg Munn, Treasurer and Chief Financial Officer r L_J 0 0 0 c u W O V` O u 0 0 r•� U 0 8 a O CL E O x m a ca �.O aX •N � O sSZ. 4a a �_ �a 4a •V ® O .� O a V 4-J a 4-J ram-+ IAa O � i Z� 0 a s F n< c pp •i O 01 00 ui c M N to Ol m 0100 O O O N \ W ram{ M rvry o obi 00 M N H kD O N 0) H �0 n Ln 00 � ui o N u Y � cn C N O O a)> � a a c p o u 3 a o i v v `�° 0 a o o c � O C � U O 7 v 4 N O u IA C.0 0. u-U Qj p O ~ O U v a) i> rz O O>> O p Nw V) O Q� H H H H (7 x O -J » e V W L. EKE i Vf (A �.0 a r ® n ® V) ® •_ 0 ®fw A ® P �.J •� IA i CD A' W i ® S. u Ltw W m 0 0 �' N l0 � 000• Owl 0000 i� n M N N Ian V N I, n Ln COp ONO pp� Oa0 N N M t�D L.O Ln is r-I pppp 44� N Ln ti T N (gyp 00 n N tin ��•^ Ol en 1p ^ M <h ^ M M p9 to 4 �'} G1 en O N Qry� Ln On m L.0 {gyp `f�iq Vi Ol M Ol M lD M l0 �-•1 c-I �p 1-4 I�DO LND i\-1 M 1-1 U 00 Ol O M M N tD 00 lip ^ O C O 0000 O ,M1 ;.'b11 fr1 N N U Y N N S N c0 G 0� O o > ° o COL c c .v o a vL O _ 0 E - N v E a v L° a 0 Lj Li E? ti' U C A' E a E g o a. = .� u o ID u > �0 0� 0 IA • • • • • • • 0 0 LU _,a • • ui cam > . 01. •.. OR • • G L H N 1� tD 00 00 1-1 aa O O N I, m t- Ql 1- n n n - :.:.. N lD a1 O fn Ln 1l N 1--1 00 00 N d O . -1 O N N N ' t LD n Ln `.-1D 00 O I:t I:t 00 1-1 o m —i O m d' of LD M M ri 1, , W m: 00 r-1 Ln r i d' N Ln ri N 00 c-I L u > > > cu a Q) CD cu c v o y r v L v C m .1CC "Qf 1- CO E U O mO V U O m V O U = c0 w ca w p) io w Qj Z) co � '� D LL m V r� ,Y Fa�0 C : L0 � 6 00 N fit Q0 fD 00 PNFi N � ' ' O� r-I � r^ LD 00 ONO F W 1� r1 Ln W m O1 rn LD N 1- (n w 1, N Ln N N ->_ C. O LD 00 I, M N 1:* f- Ln -s h cn O 00 00 Ln Ln N lD r-I N M 0) N i-1 w .D N r-I Ln m r+ L cri d Di a ri 00 Lf) rm-I N w Il N N O e-1 a+: 01 lD Ln ri it m N O Ol 00 l0 LS M -I O r4 Ln 00 r� O m N t0 Ln Ln N w N m a 7 O ri O ri <D lD N d' - CF CO. L•rj a --I fv) N ri L 0 (n Ln— a) .? o 4 O tA uJ > U1 of v c Q > 0 0 L d cu fl. 0 •L O d O VI O � U- c E _ U c :3 s3 Lv ca U Q v �+ v N D L- E w 3 i U D i o E a E o °� QL `° w t ° u a u > `^ L m a v v E fu w a o U o - IL o Q a vt C O a Q c06 M o Q 0~C � H H N rl rl r4 e-1 e O O C O O s-i O N h i-i O N tD O N tl' N M N N rq O N rq N rq 0 N 0) O O N ++ u 00 O N o N V I— o O N I O O N b' O O N d i/i d in M M N N V/ in i^ 4Z ri V/ O in 4A 40" rya 0 d' e N _ a a o 00 ol 1L ol 2 i V ol CL ® iC L) Y O c ® V J � %e 0 ® v+ w �✓ N c ® Zu yr tv /0 i Fe a 6 (A W ,u � � � IA � 4-J � � 0 u e I # 6 � »< � �— •; ~• � ' � . ¥. � � <: • � y� \\ '� °� ,. •. � � � . .� :. � • 2� ? • �: � � © • �• c, °\2 . • • . N L M i L � .Q Qi L N u � �_+ 0 E 0 m u m u Z i 3 E _� ,�.� LAm 0 Y O m i 0 N •� N J Q L _ �m L v O E N m � 4a u O V ® � �ryry G1 O L C ++ �F- dA N 0 :F+ > 0 1 > L 4- 0 o E 4-a a, 0_ M L .L co 3 L aJ 0 cn N Q V m �.m CC Z y- � OC Z OC t0 cn OC � w m ® N � M M N •— X M -0 L m •� v� i i Wm N QJ �,w r ._ L 0 o � -0 s a�vo=ice � (cc %-.. toaN4-0 cn •_ E '- E E- i •f6 N N .Q s � � t N u0 0= m3m9sw0�3 z a Luw �a. CJcn L I= CL 3:Z MEETING DATE: November 22, 2021 SUBJECT: County Treasurer and Finance Report as of October 31, 2021. RECOMMENDED MOTION: N/A. BACKGROUND AND POLICY IMPLICATIONS: See attached Treasury and Finance Report, BUDGET IMPACTS: N/A. ATTENDANCE: Greg Munn, Treasurer and Chief Financial Officer ES co 4? 0 n� 1A. A.. MEMORANDUM DATE: November 22, 2021 TO: Board of County Commissioners FROM: Greg Munn, Treasurer and Chief Financial Officer SUBJECT: Treasury and Finance Report for October 2021 Following is the unaudited monthly finance report for fiscal year to date October 31, 2021. Treasury and Investments • The portfolio balance at the end of October was $258 million, an increase of $30 million from September and an increase of $29 million from last year (October 2020) - most of the increase due to the receipt of $19 million in ARPA funds in May. For comparison purposes, the October 2020 balance is $2 million more than the October 2019 balance. • Net investment income for the month is $115,185, approximately $6,000 less than last month and $72,000 less than October 2020. YTD earnings of $511,038 are $429,000 less than the YTD earnings last year. • All portfolio category balances are within policy limits. • The LGIP interest rate was reduced from 0.55% to 0.45% on October 13. Benchmark returns for 24 and 36 month treasuries are up from last month by 20 and 22 basis points, respectively. • Average portfolio yield is 0.65% down from 0.66% last month. • The portfolio's weighted average time to maturity is at 1.60 years (compared to 1.85 last month). Porito�o t3realttiolmt: Par Valte. htvestni T' Municipal Debt S 41,870,000 16.2% Corporate Notes 53,481,000 20.7% Time Certificates 1,245.000 0.5% U.S. Treasuries - 0.01k Federal Agencies 74,900,000 29.1% LGIP 50,299,389 19.5°t1 First Interstate Bank 35,975,001 14.0°/< Total Investments $ 257,770,390 100.0% Total Portfolio: By Investment Types F,,,�stIrate state M.nicwl Debt @ank 16.2% e.1 LGIP iiiiiir i.��� �� Corporate 19.5% l4 � Notes 20.7° -- - CEwlw U. S. WF Treasuries 0.0% [Portfolio bj roker $100 $86.3 o $80 $60 $40 $19 8 S22 8 $28.2 $20 S4.3 $10.2 $- OA Moreton Rot,,nW Great Piper Castle0ak Datidson Caprdl da^d &Co Pacific Sandler Markets Securities vesima+It Inc1e . Oct-21 Y-T-D Total Investment Income 120,185 531,038 Less Fee: S5,000 per month (5,000) (20,000) Investment Income - Net 115,185 511 038 Prior Year Comparison Oct-20 987,965 939 717 71 Category Maxitttums Y1W Permt"es U.S. Treasuries 100% Current Month Prior Month LGIP ($52,713,000) 1001% FIIV LGIP 0.455° 0.55% Federal Agencies 100% tnvestments ° 0.63% 0.63% Banker'sAcceptance<. 26% Average 0.651k 0.66% Time Certificates 50% Municipal Debt 25% _ Bent bmarks Corporate Debt 25% 24 Month Treasury 0.48% LGIP Rate 0.45°4 J%turl {Year$) 36 Month Treasury 0.751% Max I Weighted Average 4,622 1,60 Term Minirrttnil AGUIat 0 to 30 Days 10% 34.6% Under 1 Year 251% 44.7% Under 5 Years 100% 100.0% Hitler Policy Acfuel, Corp Issuer 5% 3.5% Callable 261% 17.2 Credit WtA AA2 AAt htvssiment ACtivity Purchases in Month $ 4,325,000 SateslRedemptions in Month $ 2,465,000 3.50% 3.00 % 2.50% 2.00% 1.50% 1.00% 0.50% 0.00 % 24 Month Historic Investment Returns Sep Dec Mar June Sept Dec Mar County Rate 2 Year Treasury Rate -< Corporate Bond Rate Three Year Portfolio Balance 300,000,000 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 June September LGIP Rate 00 0o m m rn m rn rn rn rn m m rn m 0 0 0 0 0 0 0 0 0 0 0 0- -1 i-i c-1 .-i c-I c-I a-1 1- .-I c-I a-i N N f V N N N N N N N N N u N N N N N N N N C -6 0_ > > U C 9UC - O N oO O N N M bA NNONo Z 0 V z a'A o z 0 u 2 a 2 a Five Year Maturity Distribution Schedule 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 Deschutes County Investments Portfolio Management Portfolio Details -Investments October 31, 2021 Purchase Maturity Days To Ratings Coupon Par Market Book I 1 vT! - CUSIP Security - Broke - Date Date -1 i Maturi - j Mood " S&P/R Rate - j YTM 365" Value "j Value " 10724 FAC 3130AHJYO Federal Home Loan Bank CASTLE 11/8/2019 11/19/2021 18 Aaa AA+ 1.625 1.71 3,000.006 3,002,329' 2,999 874 10744 FAC 3130AHSR5 Federal Home Loan Bank CASTLE 12/20/2019 12/20/2021 49 Aaa AA- 1.625 1.68 3,000,000 3,006,336 2,999,780 10732 MCI 46626HJD3 JPMorgan Chase - Corporate N Pi 12/6/2019 1/24/2022 84 A2 A- 4.5 2.01 2,000,000 2,018,599 2,011,179 10654 MCI 695114CP1 Pacific Corp CASTLE 9/25/2018 2/l/2022 92 Al A+ 2.95 3.32 700,000 700,000 699.390 I0s56 MUN 558770DS9 CPY OF MADRAS OR DA DAV 1011212023 31112022; 120 AA 0,321 0,32 .145;000 ' 114,993 j15,00D 16726 FAC 3133EKCYO Federal Farm Credit Bank CASTLE 11/21/2019 3/14/2022 133 Aaa AA- 0.45 0.67 5.000,000 5,007,135 5,001.796 10730 FAG 3133EKCYO Federal Farm Credit Bank CASTLE 11/29/2019 3/14/2022 133 Aaa AA + 0.45 0.66 5,000.000 5,007,135 5.001,989 10720 MCI 90520EAH4 MUFG Union Bank CASTLE 10/25/2019 4/l/2022 151 A3 A 3.15 2.04 2,000,000 2,018,984 2,008,997 10760 MCI 90520EAH4 MUFG Union Bank CASTLE 2/5/2020 4/l/2022 151 A3 A 3.15 1.81 1,000,000 1,009.492 1, , 4 10759 MCI 037833CP3 Apple Inc CASTLE 3/27/2020 5/11/2022 191 Aal AA+ 0.47725 1.72 1,000,000 1,001,940 994, 548 994 10733 MCI 084664BT7 Berkshire Hathaway Inc MORETN 12/6/2019 5/15/2022 195 Aa2 AA 3 1.74 2,000,000 2,028.891 2,013,236 10652 MUN 686053BQ1 Oregon School Boards Assoc MORETN 9/14/2018 6/30/2022 241 Aa2 AA 5.48 3.12 925,000 957,125 938,669 10833 MUN 757889BR0 REDWOOD CITY CA SCH DIST DA DAV 2/24/2021 8/1/2022 273 AA 5 0.81 125,000 129,.524 129,442 10748 FAC 3133EKJ56 Federal Fenn Credit Bank CASTLE 1/31/2020 8/30/2022 302 Aaa AA- 0.4 0.38 3,000.000 3.008,050 3, 10790 MUN 014365DQO ALDERWOOD WA WTR & WSTIAR W B 11/12/2020 12/1/2022 395 Aa2 AA+ 1 0.50 200,000 201,462 204,I76 , 10855 MCI 822582AV4 ROYAL DUTCH SHELL PLC CASTLE 8/27/2021 1/6/2023 431 Aa2 A+ 2.25 0.24 1,188,000 1,212,561 1,216,126 10727 M01 06051GEU9 Bank of America Corp CASTLE 11/25/2019 1/11/2023 436 A2 A- 3.3 2.12 2,000,000 2,066.691 2.027,121 10854 MCI 06051 GEU9 Bank of America Corp PS 8/16/2021 1/11/2023 436 A2 A- 3.3 0.27 1,000,000 1,033.345 1,036,094 10813 MC1 740189AGO Precision Castparts Corp CASTLE 12/17/2020 1/15/2023 440 A2 AA- 2 5 0.55 2,772,900 2 823,274 2,836 540 lo657 MUN 558770IDT7 e, CITY OF MADRAS OR DA DAV 10/121202I, 311/2023 485 AA '. :0.451 0,45 210,000 � 209.735 210,000 10¢59 MC i 46825HRL6 JPMorgan Chase-Cor_p"orate N ` CASTLE 10/29/2021 5118/2023,: 563 i ' 2.7 0,73 2,040,000 : 2,058 703 2,4?60,483`+ 10835 MUN 010831DQ5 ALAMEDA CNTY CA JT PWRS At CASTLE 2/24/2021 6/l/2023 577 Aa1 AA+ 3,095 0.40 3,080,000 3,203,292 3,215,377 10838 MUN 73473RDW2 MORROW PORT TRANS FAG R W B 4/1/2021 6/l/2023 577 A- 0.7 0.70 215.000 214,501 215.000 10760 MUN 736746XU7 PORTLAND OR URBAN RENEWP PS 7/14/2020 6/15/2023 591 Ant 4.023 2.90 830,000 831,328 844,449 10839 MUN 984674JZ5 MCMINNVILLE SCHOOL DIST YA PS 6/15/2021 6/15/2023 591 Ant 0.28 0.28 170,000 169,471 170,000 10709 MUN 2927OCNU5 BonneHlle Power Administralio CASTLE 7/30/2019 7/l/2023 607 Aa2 AA- 5.803 2.12 1,000,000 1,087,250 1,058,512 10713 M01 361582AD1 Berkshire Hathaway Inc CASTLE 9/9/2019 7/15/2023 621 Aa3 AA 7.35 2.03 500,000 556,989 543,414 10832 MCI 06053FAA7 Bank of America Corp DA DAV 2/23/2021 7/24/2023 630 A2 A- 4.1 0.23 1,000,000 1,061,335 1.066,742 10769 FAC 3137EAEV7 Federal Home Loan Mtg Corp CASTLE 8/21/2020 8/24/2023 661 Aaa AA- 0.25 0.28 5.000.000 4,979,965 4,996,925 10768 MUN 67232TBM6 OAKLAND CA REDEV SUCCESS PS 8/21/2020 9/l/2023 669 AA- 3.125 0.60 2.500.000 2,597,900 2.614,440 10780 MUN 476453GRO JEROME IDAHO SCHOOL DISTRI PS 10/13/2020 9/15/2023 683 Aaa 5 0.48 200,000 216,038 216.790 10843 MUN 098419MM3 BONNEVILLE & BINGHAM CNN: PS 7/28/2021 9/15/2023 683 Aaa 4 0.43 1,000,000 1,062,990 1,066,451 10819 MCI 3133EMLEO Federal Farm Credit Bank PS 12/30/2020 9/22/2023 690 Aaa AA+ 0.19 0.19 2,000,000 1,993.567 2,000,000 10794 FAC 3137EAEZ8 Federal Home Loan Mtg Corp CASTLE 11/5/2020 11/6/2023 735 AA, 0.25 0.28 5,000,000 4.973.192 4,996,982 101102 MCI 459058J M6 International Bonds for Recons CASTLE 11/24/2020 11/24/2023 753 Ass AAA 0.25 0.32 2.000,000 1.985,980 1,997.042 10789 MUN 014365DR8 ALDERWOOD WA WTR & WSTA R W B 11/12/2020 12/1/2023 760 Aa2 AA+ 1 0.55 270,000 271,634 10837 MUN 73473RDH5 MORROW PORT TRANS FAC R W 8 4/1/2021 12/l/2023 760 A- 0.7 0.70 1.000.000 993,300 000,000 1,000.000 10836 MCI 31422XBV3 Federal Agriculture Mtg Corp GPAC 3/15/2021 12/15/2023 774 0.22 0.21 2,000,000 1,986,517 2,000,000 10923 MCI 06051GFBO Bank of America Corp CASTLE 1/12/2021 1/22/2024 812 A2 A- 4.125 0.52 2,000,000 2,142,968 10834 MC1 3133EMRZ7 Federal Farm Credit Bank CASTLE 2/26/2021 2/26/2024 847 Aaa AA+ 0.25 0.26 2,000,000 1,986,234 1,999,877 443 1,999,443 10829 MUN 68607VZ73 Oregon State Lottery PS 1/26/2021 4/1/2024 882 Aa2 AAA 2.505 0.39 2,350,000 2,444.635 2,162.522 10851 MCI 06051GFFI Bank of America Corp CASTLE 8/12/2021 4/1/2024 882 A2 A- 4 0.61 2,000,000 2.145,829 2,162,522 I'M6 MCI 06051GJV6 Bank of America Corp CASTLE 7/27/2021 6/14/2024 956 A2 A- 0 .523 0.52 1,000,000 111.211 1,011.110 10776 MUN 568571 CZ4 SILVER FALLS SO PS 9/17/2020 6/15/2024 957 Aal 0.55 0.55 1, 900,000 1, 882,691 1,900,000 10777 MUN 179093KQ1 CLACKAMAS SCHOOL DISTRICT PS 10/1/2020 6/15/2024 957 Aa1 0.613 0.61 500.000 497,805 500,000 10779 MUN 906429EE1 UNION CTY OR SCHOOL DISTRIC PS 10/8/2020 6/15/2024 957 Aal 0.675 0.68 490.000 488,383 490.000 10785 MUN 939$07KVS Washington Couny SR Municipal PS 510/2012020 61151; .024 957'Aa1 0.69 0.58 1,500,00D 1,487 880 1,500,000 f 10807 MUN 179198JF4 CLACKAMAS SCHOOL DISTRICT DA DAV 12/3/2020 6/15/2024 957 Aal 0.83 0.48 300:000 300.678 302:725 10809 MUN 736688MD1 Portland Community College PS 12/17/2020 6/15/2024 957 Aa1 0.572 0.57 1,000,000 995.320 1,000,000 10815 MUN 625517MG9 MULTNOMAH COUNTY OR SCHC R W B 12/30/2020 6/15/2024 957 Ael AA- 2 0.41 2,750,000 2,832,995 2,864.453 10771 MCI 68583RCT7 OR ST COMMUNITY COLLEGE D R W B 8/27/2020 6/30/2024 972 Aal AA- 5.66 0.60 90,000 101,459 101,974 10853 MUN 68583RCY6 OR ST COMMUNITY COLLEGE D PS 8/31/2021 6/30/2024 972 AA 0.583 0.58 1,000,000 993,950 1,000,000 10782 MUN 684288ER1 MEDFORD OR REVENUE R W B 10/14/2020 7/15/2024 987 AA- 2 0.65 815,000 836,689 844,355 10842 FAC 3133EMT51 Federal Farm Credit Bank CASTLE 7/19/2021 71 9/2024 991 Aaa AA- 0.42 0.43 1,000,000 995,251 999,774 10828 MCI 3133EMNK4 Federal Farm Credit Bank DA DAV 1/22/2021 7/22/2024 994 Aaa AA+ 0.31 0.31 2.000,000 1,984,630 2.000,000 10848 BCD 795451AAl SALLIE MAE GPAC 7/21/2021 7/22/2024 994 0.55 0.55 249,000 247,434 249,000 10847 BCD 38149MXG3 GOLDMAN SACHS GPAC 7/28/2021 7/29/2024 1001 0.55 0.55 249,000 248.098 249,000 10844 BCD 05580AB78 BMW GPAC 7/30/2021 7/30/2024 1002 0.55 0.55 249,000 248,092 249.000 1 9868 MCI 91159HHXI , US Bank - 1�S 10/29/2021 7/30/2024 1002 A2 A+ - 2.4 0.84 � 2,000,000: 2,078,420 2,Q84,429 167" MUN 1732098PE2s POMONA,QALJ UNI SCH DISTTA;PS 11012012020 _ 8/1/2024 1004 Aa3 9,77 0.60 1,200,000' 1,193,464 1;205,534 10786 MUN 835169GR94 SONOMAECCD iPS �10/21/2090 ; 81112o. 1604 Aa2 AA i 2,1361 0.60 % 1,2DO,000- 1,239,$04 1/247,690 10805 MUN 68609TZR2 Oregon State Lottery R W B 12/1/2020 8/l/2024 1004 Aal AA- 0.638 0.41 505,000 503,530 508,072 10811 MUN 68608USW7 Oregon Slate Lottery R W B 12/17/2020 8/l/2024 1004 Aal AA+ 2.677 0.94 755.000 782,414 790.401 10812 MUN 68608USD9 Oregon State Lottery R W B 12/17/2020 8/1/2024 1004 Aal AA+ 2.677 0.94 500,000 519.175 523,44 10849 BCD 89235MLF6 TOYOTA FINANCIAL SGS BANK GPAC 8/5/2021 8/5/2024 1008 0.55 0.55 249.000 248,057 249,000 249,000 10850 BCD 90348JR115 UBS BANK USA CASTLE 8/11/2021 8/12/2024 1015 0.55 0,54 249,000 248.016 249,000 10816 MCI 30231GBC5 XFO Energy Inc GPAC 12/21/2020 8/16/2024 1019 Aal AA 2.019 0.54 2,000.000 2,062,869 2,081,470 10810 MUN 73474TAB6 MORROW PORT TRANS FAC R W B 12/14/2020 9/1/2024 1035 Aa2 3.221 0.42 1,750,000 1,865,973 1,887.647 10775 FAC 3134GWFI14 Federal Home Loan Mtg Corp CASTLE 9/9/2020 9/9/2024 1043 Aaa 0.48 0.48 1,000,000 993,275 1,000,000 10830 MCI 22546QAP2 CREDIT SUISSE NY CASTLE 2/1/2021 9/9/2024 1043 Aa3 3.625 0.57 2,950,000 3,153,859 3,204,196 10778 MUN 4511527CO IDAHO ST BOND BANK AUTH RE PS 10/8/2020 9/15/2024 1049 Aal 5 0.61 1.000.000 1.119,000 1, 124,394 10781 MUN 476453GS8 JEROME IDAHO SCHOOL DISTRI PS 10/13/2020 9/15/2024 1049 Aaa 5 0.73 220.000 244,453 246,584 10808 MUN 13034AL57 CALIFORNIA INFRASTRUCTURE -GPAC 12/17/2020 10/1/2024 1065 AAA 0.645 0.65 1,000,000 993,060 1,000,000 10783 FAG 3133EMCNO Federal Farm Credit Bank CASTLE 10/16/2020 10/15/2024 1079 Aaa AA+ 0 4 0.44 2.000.000 1:112.112 1,117 11 1Q791 FAC *3I34GW3W4Faderai Home Loan N14g Corp -OASILH i1013012020 10/28/2024 1092 Aaa 0.41 0.42 2,000 000' 1,985f728 1,999,620 =' 10797 MCI 822582CC4 ROYAL DUTCH SHELL PLC GPAC 11/13/2020 11/7/2024 1102 Aa2 AA- 2 0.71 3,000,000 3, 088:950 3:115*316 10823 MCI 822582CC4 ROYAL DUTCH SHELL PLC CASTLE 1/7/2021 11/7/2024 1102 Aa2 AA- 2 0.54 1,708,000 1,758.642 1,782,196 10799 FAC 3134GW7F7 Federal Home Loan Mtg Corp CASTLE 11/18/2020 11/18/2024 1113 Aaa 0.375 0.38 2,000.000 1,983,416 2,000,000 10788 MUN 014365DS6 ALDERWOOD WA WTR & WSTIA R W B 11/12/2020 12/1/2024 1126 As AA+ 1 0.65 935,000 935,065 944,937 10814 MCI 9311420V2 WALMART GPAC 12/17/2020 12/15/2024 1140 Aa2 AA 2.65 0.57 2,000,000 2,105,817 2.000,000 10820 MCI 3133EMLP5 Federal Farm Credit Bank PS 12/30/2020 12/23/2024 1148 Aaa AA- 0.32 0.32 2,000,000 1.976,661 2,133,134 10806 MCI 037833DF4 Apple Inc GPAC 12/3/2020 1/13/2025 1169 Aa1 AA+ 2.75 0.64 2,000.000 2,101,548 2,000.000 10821 MCI 3134GXKK9 Federal Home Loan Mtg Corp R W B 1/15/2021 1/15/2025 1171 Aaa 0.35 0.00 2,000,000 1,977,094 2,146,960 10817 MC 46625HKC3 JPMorgan Chase - Corporate N CASTLE 12/22/2020 1/23/2025 1179 A2 A- 3.125 0.81 2,000,000 2.109,580 2,145.586 10826 MCI 46625HKC3 JPMorgan Chase - CorporateN CASTLE 1/11/2021 1/23/2025 If 79 A2 A- 3,125 0.83 2,000.000 2,109,580 10762 FAC 3136G4E74 Federal National Mtg Assn CASTLE 7/31/2020 1/29/2025 1185 Ass AA+ 0.57 0.57 1,400 000 1,390,844 1,400,000 7,409 000 10792 FAC '3134GW5Q5 Federal Home Loan Mt9 Carp iCASTI-E e10130/2020: 1129/202S 1185 A- 0.45 0.46 2,600,000 2,464 895 2499,a 9 } 10822 M01 125720AGO CME GROUP GPAC 1/4/2021 3/15/2025 1230 Aa3 AA- 3 0,65 2,000,000 2,110,449 2, 166, 157 10801 MCI 30231 GBH4 Xi0 Energy Inc GPAC 11/19/2020 3/19/2025 1234 Aal AA 2.992 0.81 2,000,000 2.114,417 2,144,525 10800 MUN 98459LAA1 YALE UNIVERSITY GPAC 11/18/2020 4/15/2025 1261 Aaa AAA 0.873 0.58 2,000,000 1,990,193 2.020,070 10818 M01 166764BW9 .Chevron Corp GPAC 12/28/2020 5/11/2025 1287 Aa2 AA 1.554 0.65 1,663,000 1.687,812 1,0 5,377 10824 MCI 166764BW9 Chewon Corp CASTLE 1/7/2021 5/11/2025 1287 Aa2 AA 1,554 0.62 2,000.000 2,029,840 2,, 092 10825 MUN 625506PX2 MULTNOMAH CO-REF-TXBL GPAC 1/21/2021 6/l/2025 1308 Aaa AAA 1 0.50 2,165,000 2,162,337 2,20303,317 17 10798 MUN 938429V61 Washington County SD Municipal PS 11/17/2020 6/15/2025 1322 Aal 0.912 0.64 350.000 348,730 353,332 10840 MUN 498368EB1 KLAMATH CNN OR SCH DIST PS 7/1/2021 6/15/2025 1322 AA- 0.86 0.86 400.000 396,400 10841 MUN 625517NE3 MULTNOMAH COUNTY OR SCHC CASTLE 7/15/2021 6/30/2025 1337 Aa2 AA 0.95 0.69 1,255,000 1,247.646 266,907 1,266,907 10787 MUN 88675A654 TIGARD OR WTR SYS REVENUE PS 11/3/2020 8/l/2025 1369 Aa3 AA 2 0.85 350,000 359,800 364,759 10831 MUN 799055QU5 SAN MATEO CA FOSTER CITY S DA DAV 2/16/2021 8/1/2025 1369 Aaa AA. 1.597 0.47 500,000 507.565 885 10763 FAC 3133EL3P7 Federal Farm Credit Bank R W B 8/12/2020 8/12/2025 1380 Aaa AA+ 0.53 0.53 3,000,000 2,946,759 000,000 3.000,000 10764 FAC 3133EL3H5 Federal Farm Credit Bank MORETN 8/12/2020 8/12/2025 1380 Aaa AA+ 0.57 0.57 3,000,000 2,959,770 000,000 10766 FAC 3134GWND4 Federal Home Loan Mtg Corp CASTLE 8/14/2020 8/12/2025 1380 Aaa 0.6 0.61 2,000,000 1.981,725 1,999.243 1,998,496 10767 FAC 3136G4L84 Federal National Mtg Assn CASTLE 8/18/2020 8/18/2025 1386 Aaa AA, 0.57 0.59 2,000,000 1,976,204 1,998,496 10765 FAC 3136G4N74 Federal National MID Assn MORETN 8/21/2020 8/21/2025 1389 Aaa AA+ 0.56 0.56 3,000.000 2,952,507 3, 10772 FAC 3136G4N74 Federal National Mtg Assn R W B 8/27/2020 8/21/2025 1389 Aaa AA+ 0.56 0.57 1,000.000 984.169 999,809 10774 FAC 3136G4N74 Federal National Mtg Assn R W B 9/3/2020 8/21/2025 1389 Aaa AA+ 0.56 0.56 2,000,000 1,968.338 000,000 10770 FAC 3136G4X24 Federal National Mtg Assn PS 8/28/2020 8/29/2025 1397 Aaa AA+ 0.6 0.60 1.000.000 984,428 1,000,000 1.000,000 10773 FAC 3136G4J(24 Federal National Mtg Assn CASTLE 8/28/2020 8/29/2025 1397 Aaa AA+ 0.6 0.60 1,000,000 984,428 1,000.000 10793 FAC 3135GA2NO Federal National Mtg Assn R W B 11/4/2020 11/4/2025 1464 Aaa AA+ 0.55 0.55 2.000,000 1,970,883 000 10796 FAC 3135G06G3 Federal National Mtg Assn CASTLE 11/12/2020 11/7/2025 1467 Aaa AA+ 0.5 0.57. 2.000,000 1.959,692 1,994,232 1,255.595 10845 MUN 736688MF6 .Portland Community College MORETN 7/23/2021 6/15/2026 1687. Aa1 0.899 0.80 1,250,000 1,230,550 1,299,389 10078 RRP SYS10078 Local Go,1 Investment Pool 7/1/2006 - - 1 0.55 0.55 50,299,389 50,299,389 50,299,389 10084 RR2 SYS10084 First Interstate 7/l/2006 - - I 0.55 0.55 35,975,001 35,975,001 35,975,001 257,770,390 260,001,209 261,253,250 Position Control Summary July - June Percent Org Jul Aug Sep Oct Unfilled Assessor Filled 33.26 33.26 33.26 33.26 Unfilled 2.00 2.00 2,00 2.00 567% Clerk Filled 8.58' 8.48 8.48 9,48 Unfilled 0.90 1.00 1.00 76S% BOPTA Filled 0.42 0,52 0.52 0.52 Unfilled 0.10' - 4.81% DA Filled 51,70! 54.50 56,50 55.50 Unfilled 6.30 3.50 1.50 2.50 5.95% Tax Filled 5.50 5.50 5.50 5.50 Unfilled - - - - 0,00% Veterans' Filled 5.00 5 00 5.00 5,00 Unfilled - 0.00% Property Mngt Filled 2.00 2.00 2.00 2,00 Unfilled - - - - 0.00% Total General Fund Filled 106.46 10926 111.26 111.26 Unfilled 9.30 6.50 4.50 4.50 5 36% Justice Court Filled 4.60 4.60 4.60 4.60 Unfilled - - - - 0.00% Community Justice 'Filled 45.90 45.90 45.90 44.90 Unfilled 2.00 200 2.00 3.00 4.70% Sheriff Filled 229.75 235.75 232.75 238.75 Unfilled 27.2S 21.2S 24.2S 18.25 8.85% Health Srvcs' filled 320.33 319.85 320.40 331.20 ; Unfilled 55.47 57.95 64.90 54.50 15.27% CDD Filled 61.00 61.00 56.80 56.80 Unfilled 4.00 6.00 11.20 11.20 12.09% Road Filled 57.00 57.00 57.00 56.00 r Unfilled - - - 1,00 ` 0.44% Adult P&P Filled 37.60 37.60 37.60 36.85 Unfilled 3.25 3.25 3.25 4.00 8.41% Solid Waste Filled 23.00 24.00 24.00 27.00 Unfilled 2.00 4.00 4.00 1,00 10.09% Victims Assistance Filled 8.00 8.00 8.00 8.00 Unfilled - - - - 0.00% GIS Dedicated Filled 2.30 2.30 2.30 2.30 Unfilled 0.00% Fair & Expo Filled 9.00 9.00 9.00 9.00 Unfilled 3.50 3.50 3.50 3.S0 28.00% Natural Resource Filled 2.00 2.00 2.00 2,00 Unfilled - - - - 0.00% ISF - Facilities Filled 21.60 19.60 21.60 21.60 Unfilled 2.40 3.40 2.40 2.40 11.16% ISF -Admin Filled 7.75 7.75 6.75 8.75 Unfilled - 1.00 1`.00 2,00 1.00 13.89% ISF - BOCC Filled 3.00 3.00 3.00 3.00 Unfilled - - - - 0.00% ISF - Finance Filled 9.00 9.00 9.00 8.00 ' Unfilled 2.00 2.00 2.00 3.00 ' 20.45% ISF - Legal Filled 7.00 7.00 7.00 6.00 Unfilled - - - 1.00 3.57% ISF - HR Filled 8.00 8.00 8.00 8.00 Unfilled 1.00 1.00 1.00 1.00 f 11.11% ISF - IT Filled 15.70 15.70 15.70 15.70 Unfilled - - - - 0.00% ISF - Risk Filled 2.25 2.25 2.25 2.25 ' Unfilled 0,00% Total., Filled 981.24 988.56 984.91 1,001.96 Unfilled 113.17 111,85 125.00 109.35 %Unfilled 10.34% 10.16% 11.26% 9.84% 10.40% Budget to Actuals Report r,onaral Flinn Revenue YTD in the General Fund is $6.8 million or 16.7% of budget. Last year revenue YTD was $9.5 million and 25.5% of budget. The difference is due to unbudgeted CARES Act funds received last year, the timing of revenue received in the Assessor's office (earlier last year), a slight reduction in revenue received in the Clerk's office (less recordings) and less revenue in the Tax Office (staffing expenses are recouped through a direct charged instead of funds transfer). Expenses YTD are $13.4 million and 31.0% of budget compared to $14.4 million and 36.2% of budget last year. Overall expenses are lower this year and represent a smaller portion of the budget this year due to unbudgeted CARES Act expenditures last year offset by an increase in the approved budget transfers this year which are made on a regular monthly basis. Projected Beginning Fund Balance is $15M or 111.3% of the $13.5M budget. While this number is preliminary and won't be finalized until the financials have been fully audited, it represents a normal and expected fund balance carry forward amount from the prior year as compared to budget. 33.3% County Wide Financial Dashboard 001 - General Fund 4 Year Complete fund Sete,I all (Blank) 001 Ge.aatal Fund 010 - Assmt-Clerk... 020 Code Abate... 030 - Corrnrwnity ... 040 - Court Tc(hn . 050 - Economic D- 060 - General Cou... 070 - General Cou... 040 - Project Oev..- 120 - Um Lib,z ly 130 - Park Acgtu-- 112 - Park Develn Monthly GL P... 0 (Blank) All Maior Funds Budget to Actuals Requirements Resources Beginning Working Capital Budget to Actuals by Category @ActuA, •Budget *Nr j t-1 xacsn l��% $13AM $6.8M $15.OM SEr Oet i421P1 c(��iM11 31.0% 16.7% 111.3°/g ou -- T--rersOul P—');; ,l M—ii't LY 0tat ,"_. 01it q Monthly Expenditures 36.2% Projected Ending Working Capital Approved FTE % of last Year budget Wli Al 11 115.86 OM 0 _ a r. il 10 t 2 @La.t Year Attu.fls®C -- tY—At,al; Monthly ftevenuPs�.,�r.�,ux�<.� 25.5%�,,�� % of last Year budget toKIM I'h M Last Year Actuals OCu—M \war Actuals 511.OM Bidpt 41in a ePr.yo on s..,. slam VACANT 3.f16°b -IILEr) 96,94 % On the attached pages you will find the Budget to Actuals Report for the County's major funds with actual revenue and expense data compared to budget through October 31, 2021. le�3TtSC,0Gz< Budget to Actuals - Countywide Summary All Departments FY22 YTD October 31, 2021 (unaudited) RESOURCES 001 - General Fund 030 - Juvenile 160/170 - TRT 200 - American Rescue Fund 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 - Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 675 - Health Benefits 705 - 911 999 - Other TOTAL RESOURCES REQUIREMENTS 001 - General Fund 030 - Juvenile 1601170 - TRT 200 - American Rescue Fund 220 - Justice Court 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % 45,149,632 47,632,688 105% ; 40,490,188 6,722,794 17% ; 40,544,287 100% ; 975,090 975,868 100% ; 901,143 54,810 6% 868,950 96% ; 10,669,865 11,229,510 105% ; 11,659,435 6,857,766 59% ; 14,444,358 124% ; ' 19,000,000 46,273 0% 19,000,000 19,208,028 101% ; 38,125,980 201% ; 489,850 501,563 102% ; 550,832 174,273 32% ; 550,767 100% ; 43,449,298 44,938,851 103% ; 44,724,355 6,128,821 14% 44,620,353 100% ; 43,207,563 45,921,554 106% ; 47,513,115 16,963,948 36% 48,029,010 101% ; 8,251,726 9,687,451 117% ; 9,580,316 3,694,872 39% 10,300,325 108% ; 20,681,110 23,538,925 114% ; 22,629,649 9,113,334 40% 22,728,427 100% ; 5,995,287 6,040,170 101% ; 5,840,250 1,1843560 20% 6,184,652 106% ; 2,467,800 2,942,827 119% ; 2,471,190 47,183 2% 2,340,721 95% ; 12,077,592 13,463,285 111% ; 13,350,600 4,728,323 35% 13,371,941 100% ; 1,466,050 1,791,835 122% ; 1,395,724 396,646 28% 1,423,239 102% ; 52,000 53,038 102% ; 1,560,500 1,856,974 119% : 1,911,642 123% ' 14,000 8,532 61% ; 8,544 2,485 29% 7,480 88% ; 436,050 654,204 150% ; 497,524 235,818 47% ; 639,895 129% ; 1,100 7,787 708% ; 7,546 2,258 30% 6,910 92% ; 3,263,646 3,239,580 99% ; 3,146,973 1,229,087 39% 4,273,362 136% ; 21,884,538 22,761,820 104% ; 23,027,177 7,330,975 32% 22,782,180 99% ; 11,064,698 12,080,426 109% ; 12,019,306 1,828,113 15% ; 11,988,510 100% ; 34,434,902 36,062,790 105% ; 50,071,869 10,570,988 21% 50,071,852 100% ; 285,031,797 283,578,976 99% ; 310,446,236 98,332,054 32% 335,214,841 108% ; Fiscal Year 2021 1Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % 27,262,513 26,227,705 96% 21,080,829 6,198,540 29% 20,387,388 97% ; 7,390,349 7,038,218 95% 7,522,365 2,180,214 29% 7,080,141 94% ; 3,619,872 3,566,960 99% ; 3,358,388 1,678,636 50% 4,126,850 123% ; 19,000,000 32,136 0% 38,000,000 833,263 2% ; 38,000,000 100% ; 683,508 650,926 95% ; 701,142 235,769 34% ; 701,142 100% ; IEs`°G2� Budget to Actuals - Countywide Summary All Departments FY22 YTD October 31, 2021 (unaudited) 255 -Sheriff's Office 51,263,220 49,625,248 97% ; 54,162,360 274 - Health Services 52,285,174 49,994,157 96% ; 57,785,284 295 - CDD 8,474,142 8,086,137 95% 9,978,889 325 - Road 14,513,205 12,506,257 86% ; 15,024,128 355 - Adult P&P 7,081,268 6,365,601 90% ; 7,079,915 465 - Road CIP 20,036,050 11,742,022 59% 29,722,691 610 - Solid Waste 8,853,213 8,107,298 92% ; 9,709,991 615 - Fair & Expo 2,070,371 2,011,440 97% ; 2,504,877 616 - Annual County Fair 127,000 189,611 149% ; 1,468,131 617 - Fair & Expo Capital 401,940 90,523 23% ; 568,000 Reserve 618 - RV Park 543,902 512,967 94% 496,188 619 - RV Park Reserve 100,000 - 0% 100,000 670 - Risk Management 3,794,344 2,391,380 63% ; 4,027,292 675 - Health Benefits 23,620,173 23,336,074 99% 23,924,393 705 - 911 12,576,839 10,534,248 84% ; 14,563,007 999 - Other 59,118,720 32,830,422 56% ; 86,322,366 TOTAL_ REQUIREMENTS 322815,803 255,839,328 79% ; 388,100,236 17,121,639 32% 15,760,661 27% ; 2,917,318 29% ; 4,862,980 32% ; 2,012,297 28% ; 3,975,778 13% ; 2,316,724 24% ; 687,737 27% ; 1,223,080 83% ; 188 0% ; 84,446 17% ; - 0% 2,815,348 70% ; 6,393,581 27% ; 3,291,337 23% ; 13,256,562 15% ; 87,846,098 23% 33.3% Year Complete 53,025,228 98% ; 54,089,843 94% ; 9,600,098 96% ; 14,942,470 99% ; 6,597,285 93% ; 27,987,890 94% ; 9,748,155 100% ; 2,215,488 88% ; 1,416,780 97% ; 568,000 100% ; o 482,055 97% ; 100,000 100% ; 5,977,047 148% ; 23,924,393 100% ; 13,821,773 95% ; 86,294,153 100% ; 381,086,180 98% \)I Es C-0G" Budget to Actuals - Countywide Summary All Departments 33.3% FY22 YTD October 31, 2021 (unaudited) V r 1e+n TRANSFERS 001 - General Fund 030 - Juvenile 160/170 - TRT 220 - Justice Court 255 - Sheriffs Office 274 - Health Services 295 - CDD 325 - Road 355 - Adult P&P 465 - Road CIP 610 - Solid Waste 615 - Fair & Expo 616 = Annual County Fair 617 - Fair & Expo Capital Reserve 618 - RV Park 619 - RV Park Reserve 670 - Risk Management 705-911 999- Other TOTAL TRANSFERS ear omp Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % (20,308,890) (19,944,234) 98% (21,927,604) (7,133,616) 33% (21,927,604) 100% 5,957,854 5,957,854 100% 6,249,397 2,083,128 33% 6,249,397 100% (5,278,036) (4,963,905) 94% (5,757,574) (1,919,176) 33% (6,098,758) 106% 107,235 111,521 104% 205,956 68,652 33% 205,956 100% 3,119,077 3,119,949 100% 3,500,737 1,257,908 36% 3,500,737 100% 8,026,313 6,945,413 87% 6,122,830 2,040,920 33% 6,122,830 100% (55,480) (1,104,998) 999% (270,622) (214,724) 79% (731,023) 270% (6,683,218) (6,683,218) 100% (11,757,547) (2,213,525) 19% (11,757,547) 100% 187,496 187,496 100% 471,072 159,948 34% 471,072 100% 7,517,657 6,819,612 91% 12,193,917 - 0% 12,193,917 100% (3,684,280) (3,684,280) 100% (6,029,323) (1,507,652) 25% (6,029,323) 100% 894,967 1,144,277 128% 800,736 366,908 46% 1,039,565 130% 75,000 75,000 100% (75,000) (125,000) 167% (75,000) 100% 453,158 385,418 85% 728,901 242,964 33% 831,256 114% (436,628) (369,173) 85% 47,958 (37,348) -78% 47,958 100% 621,628 549,173 88% 132,042 44,012 33% 132,042 100% (3,500) (3,500) 100% (3,500) (1,164) 33% (3,500) 100% - - 0% - 100% 9,078,924 11,341,195 125% 15,393,726 6,887,765 45% 15,828,026 103% 0 0% (410,723) (116,400) 0 26,101 h S C- 0 Budget to Actuals - Countywide Summary All Departments 33.3% FY22 YTD October 31, 2021 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 ENDING FUND BALANCE Budget Actuals % Budget Actuals Projection % 001 - General Fund 9,678,629 14,990,262 155% 10,952,375 8,380,900 13,219,557 121% 030 - Juvenile 616,595 965,223 157% 596,681 922,947 1,003,429 168% 1601170 - TRT 5,484,351 6,189,395 113% 8,433,816 9,449,349 10,408,145 123% 200 - American Rescue 14,137 999% 18,388,901 140,117 999% Fund 220 - Justice Court 57,804 - 0% 55,646 7,156 55,581 100% 255 -Sheriffs Office 13,981,322 17,266,520 123% 11,937,243 7,531,610 12,362,382 104% 274 - Health Services 5,727,266 10,689,975 187% 5,884,607 13,934,182 10,751,973 183% 295 - CDD 734,798 1,749,673 238% 763,172 2,312,503 1,718,877 225% 325 - Road 2,180,473 8,566,521 393% 2,231,806 10,603,351 4,594,932 206% 355 - Adult P&P 1,816,329 2,982,055 164% 1,971,182 2,314,266 3,040,494 154% 465 - Road CIP 13,103,814 23,533,004 180% 5,316,460 19,604,409 10,079,752 190% 610 - Solid Waste 719,918 3,957,273 550% 583,520 4,861,220 1,551,736 266% 615 - Fair & Expo 655,550 923,473 141% 442,256 999,289 1,170,789 265% 616 - Annual County Fair - (109,033) 17,369 399,861 310,829 999% 617 - Fair & Expo Capital 1,208,442 1,029,596 85% 1,271,108 1,274,858 1,300,332 102% Reserve 618 - RV Park 43,512 - 0% 49,294 114,024 205,798 417% 619 - RV Park Reserve 1,012,728 1,054,426 104% 8245054 1,100,697 1,093,378 133% 670 - Risk Management 6,465,802 9,521,450 147% 7,445,296 7,934,025 7,814,265 105% 675 - Health Benefits 13,588,094 15,527,580 114% 13,875,402 16,464,973 14,385,367 104% 705-911 6,829,277 10,709,072 157% 9,307,082 9,245,847 8,875,809 95% 999- Other 50,123,088 83,786,111 167% 55,847,562 88,010,802 56,187,794 101% TOTAL FUND BALANCE 134,027,792 213,346,712 159% 137,805,931 223,855,169 160,271,335 116% ES coG�< Budget to Actuals Report General Fund -Fund 001 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Property Taxes - Current 30,105,307 30,896,789 103% 32,410,716 3,663,330 11% 32,464,815 100% 54,099, A Property Taxes - Prior 358,000 683,563 191 % 460,000 116,531 25% 460,000 100% Other General Revenues 10,450,871 10,355,456 99% 2,689,926 1,619,749 60% 2,689,926 100% B Assessor 836,713 1,291,220 154% 987,411 256,312 26% 987,411 100% Clerk 2,153,741 3,168,198 147% 2,741,215 884,121 32% 2,741,215 100% o BOPTA 12,220 19,236 157% 14,588 3,888 27% 14,588 100% District Attorney 467,138 426,613 91% 434,221 48,781 11% 434,221 100% Tax Office 419,927 510,878 122% 341,004 113,417 33% 341,004 100% Veterans 223,715 158,931 71% 259,107 - 0% 259,107 100% C Property Management 122,000 121,804 100% 152,000 16,667 11% 152,000 100% D TOTAL RESOURCES 45,149,632 47,632,688 105% ; 40,490,188 6,722,794 17% 40,544,287 100% ; 54,099: REQUIREMENTS Budget Actuals % Budget Actuals % Assessor 5,237,507 4,897,531 94% 5,454,784 1,734,194 32% Clerk 2,051,015 1,882,622 92% 2,080,739 466,997 22% BOPTA 79,945 76,042 95% 82,911 29,210 35% District Attorney 8,234,075 8,157,354 99% 9,701,727 2,795,502 29% Medical Examiner 236,358 220,618 93% 242,652 54,657 23% Tax Office 1,016,608 989,386 97% 932,570 331,821 36% Veterans 687,678 610,692 89% 795,189 235,766 30% Property Management 332,533 312,615 94% 376,061 114,386 30% Non -Departmental 9,386,794 9,080,846 97% 1,414,196 436,008 31% e TOTAL REQUIREMENTS ; 27,262,513 26,227,705 96% 21,080,829 6,198,540 29% ; Projection % $ Variance 5,454,784 100% E 1,974,312 95% 106,427: F 82,911 100% 9,114,713 94% 587,014! G 242,652 100% 932,570 100% 795,189 100% 376,061 100% 1,414,196 100% 20,387,388 97% 693,441: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 260,000 260,000 100% 260,000 86,664 33% 260,000 100% H Transfers Out (20,568,890) (20,204,234) 98% (22,187,604) (7,220,280) 33% (22,187,604) 100% TOTAL TRANSFERS (20,308,890) (19,944,234) 98% ; (21,927,604) (7,133,616) 33% ; (21,927,604) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 12,100,400 13,529,514 112% 13,470,620 14,990,262 111% 14,990,262 111% = 1,519,642- Resources over Requirements 17,887,119 21,404,982 19,409,359 524,254 20,156,899 747,540= Net Transfers - In (Out) (20,308,890) (19,944,234) (21,927,604) (7,133,616) (21,927,604) TOTAL FUND BALANCE ; $ 9,678,629 $ 14,990,262 155% ; $ 10,952,375 $ 8,380,900 77% $ 13,219,557 121% ; $2,267,182: A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted B PILT payment of $500,000 received in July 2021 C Oregon Dept. of Veteran's Affairs grant reimbursed quarterly D Interfund land -sale management revenue recorded at year-end E FY22 average vacancy rate is 5.7%; however, savings are not expected at this time due to several retirements and overfills p Projected Personnel savings based on FY22 average vacancy rate of 7.7% G Projected Personnel savings based on FY22 average vacancy rate of 4.8% H Repayment to General Fund from Finance Reserves for ERP Implementation v"(ES C-0' Budget to Actuals Report Juvenile - Fund 030 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance OYA Basic & Diversion 472,401 497,387 105% 432,044 - 0% a 432,044 100% A ODE Juvenile Crime Prev 109,000 118,909 109% 100,517 - 0% 100,517 100% Gen Fund -Crime Prevention 89,500 89,500 100% 89,500 - 0% 89,500 100% Leases 88,000 82,522 94% a 88,000 30,307 34% 88,000 100%! Inmate/Prisoner Housing 90,000 64,350 72% 80,000 9,300 12% 60,000 75% (20,000)! B DOC Unif Crime Fee/HB2712 49,339 49,339 100% 49,339 - 0% 49,339 100% A OJD Court Fac/Sec SB 1065 26,000 13,503 52% 20,000 3,948 20% 20,000 5,550 100% 39% Interest on Investments 17,300 13,796 80% 14,243 2,027 14% (8,693)! Food Subsidy 12,000 13,028 109% 12,000 1,509 13% 8,500 71% (3,500)! C Contract Payments 8,000 2,795 35% 8,000 5,158 64% 8,000 100% Miscellaneous 7,550 28,312 375% 7,500 2,561 34% 7,500 100% Case Supervision Fee 6,000 2,427 40% - - - TOTAL RESOURCES 975,090 975,868 100% ; 901,143 54,810 6% ; 868,950 96% (32,193); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,970,797 5,762,391 97% 6,108,905 1,796,749 29% 5,666,681 93% 442,224, D Materials and Services 1,372,016 1,233,835 90% 1,363,409 383,464 28% 1,363,409 100% Capital Outlay 47,536 41,992 88% 50,051 - 0% 50,051 100% TOTAL REQUIREMENTS ; 7,390,349 7,038,218 95% ; 7,522,365 2,180,214 29% 7,080,141 94% 442,224: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Funds 6,034,966 6,034,966 100% 6,304,397 2,101,460 33% 6,304,397 100% Transfers Out-Veh Reserve (77,112) (77,112) 100% (55,000) (18,332) 33% (55,000) 100% -� TOTAL TRANSFERS 5,957,854 5,957,854 100% ; 6,249,397 2,083,128 33% ; 6,249,397 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,074,000 1,069,720 100% ® 968,506 965,223 100% 965,223 100% (3,283); Resources over Requirements (6,415,259) (6,062,350) (6,621,222) (2,125,404) o (6,211,191) 410,031- Net Transfers - In (Out) 5,957,854 5,957,854 6,249,397 2,083,128 6,249,397 � i of TOTAL FUND BALANCE $ 616,595 $ 965,223 157% ; $ 596,681 $ 922,947 155% ; ; $ 1,003,429 168% ; $406,748: A Quarterly reimbursement of biennial award based on actuals g Out of County Juvenile department usage of detention facility trending lower than projected at time of budgeting C Dept. of Education subsidies for detention meals lower due to smaller population than projected at time of budgeting D Projected Personnel savings based on FY22 average vacancy rate of 4.7% �IES 2< 0 Budget to Actuals Report i " TRT - Fund 160/170 FY22 YTD October 31, 2021 (unaudited) RESOURCES Room Taxes Interest State Miscellaneous TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 10,615,965 11,068,364 104% 11,600,987 6,839,554 59% a 14,390,068 124% 2,789,081,A 53,900 61,146 113% 58,448 18,212 31% 54,290 93% (4,158) I I - I 100,000 1 6 1 10,669,865 11,229,510 105% ; 11,659,435 6,857,766 59% 14,444,358 124% ; 2,784,923: REQUIREMENTS Budget Actuals % Budget Actuals % COVA 3,038,805 2,998,091 99% 3,136,659 1,580,648 50% Interfund Contract I 114,481 114,481 100% 121,817 40,606 33% Software I 11,500 - 0% 45,000 38,508 86% Interfund Charges 35,861 35,861 100% 39,709 13,236 33% o Administrative I 15,225 4,526 30% 15,203 5,639 37% Grants & Contributions I 404,000 414,000 102% - - TOTAL REQUIREMENTS ; 3,619,872 3,566,960 99% 3,358,388 1,678,636 50% ; TRANSFERS Budget Actuals % Budget Actuals % Transfer Out - RV Park (20,000) (20,000) 100% (20,000) (6,664) 33% Transfer Out - Annual Fair I (75,000) (75,000) 100% (75,000) (25,000) 33% Transfers Out - - (205,956) (68,652) 33% Transfer Out - F&E Reserve (453,158) (385,418) 85% (428,901) (142,964) 33% Transfer Out - Health I (406,646) (406,646) 100% (444,417) (148,136) 33% Transfer Out - F&E (1,171,445) (925,0541 79% (931,513) (310,500) 33% Transfer Out - Sheriff I (3,151,787) (3,151,787) 100% (3,651,787) (1,217,260) 33% TOTAL TRANSFERS (5,278,036) (4,963,905) 94% (5,757,574) (1,919,176) 33% ; Projection % $ Variance 3,903,621 124% (766,962); B I 121,817 100% C f 45,000 I 100% I - 39,709 100% 16,703 I 110% I (1,500)! 1 4,126,850 123% ; (768,462); Projection % $ Variance (20,000) 100% (75,000) 100% (205,956) 100% (531,256) 124% (102,355); D (444,417) 100% (1,170,342) 126% (238,829)- (3,651,787) 100% (6,098,758) 106% ; (341,184). FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,712,394 3,490,749 94% 5,890,343 6,189,395 105% 6,189,395 105% 299,052 Resources over Requirements 7,049,993 7,662,551 8,301,047 5,179,130 10,317,508 2,016,461 Net Transfers - In (Out) (5,278,036) (4,963,905) (5,757,574) (1,919,176) (6,098,758) (341,184) TOTAL FUND BALANCE $ 5,484,351 $ 6,189,395 113% ; $ 8,433,816 $ 9,449,349 112% ; $ 10,408,145 123% ; $1,974,329: A Collections coming in higher than budgeted B Payments to COVA based on a percent of TRT collections C Contracted services with the Finance Department for operating TRT program D The balance of the 1 % F&E TRT is transferred to F&E reserves o TES ` �� Budget to Actuals Report <� 0 QARPA — Fund 200 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest - 14,137 - 40,487 125,980 125,980, State & Local Coronavirus Fiscal, 19,000,000 32,136 0% 19,000,000 19,167,541 101% 38,000,000 200% 19,000,000! A Recovery Funds TOTAL RESOURCES 19,000,000 46,273 0% 19,000,000 19,208,028 101% ; ; 38,125,980 201% ; 19,125,980, REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administrative 19,000,000 - 0% 19,309,816 12,577 0% 19,309,816 100% B Services to Disproportionately ! - - ! 11,425,000 - 0% 1 11,425,000 100% C Impacted Communities Negative Economic Impacts - - 3,050,000 - 0% 3,050,000 100% t D Public Health P - 32,136 999% 2,165,184 820,686 38% 2,165,184 100% F Infrastructure I - - ! 2,050,000 - 0% P 2,050,000 100% E TOTAL REQUIREMENTS 19,000,000 32,136 0% 38,000,000 833,263 2% 38,000,000 100% ; TOTAL FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance - - 199000,000 14,137 0% 14,137 0% : (18,985,8631 Resources over Requirements I - 14,137 I (19,000,000) 18,374,765 I I 125,980 19,125,980, 1 1 Net Transfers - In (Out) ! P 1 I TOTAL FUND BALANCE _ $ 14,137 999% ; - $ 18,388,901 999% ; ; $ 140,117 999% ; $140,117, A The revenue received in FY21, but unspent at 06.30.21, was recorded as Deferred Revenue and recognized in FY22 B Administration holds the balance of the ARPA funds, as well as an approved budget analyst for ARPA reporting and administration C Includes $7.675M in childcare/early education funding and $3.75M in housing support for unhoused persons D Majority of funding is for food programs and $100K in support of the Ronald McDonald House E Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment F 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, a mobile morgue and various Health Services expenses such as temporary staffing costs to support the COVID- 19 response o� uTES C0 2{ Budget to Actuals Report Justice Court - Fund 220 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Court Fines & Fees 488,750 500,818 102% = 550,000 174,262 32% 550,000 100% Miscellaneous I - 736 737 - 0% I 737 100% Interest on Investments I 1,100 9 1% 95 11 12% 30 32% (65)= TOTAL RESOURCES 489,850 501,563 102% ; 550,832 174,273 32% 550,767 100% ; (65); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 531,006 519,650 98% 542,209 180,536 33% I 542,209 100% Materials and Services I 152,502 131,276 86% 158,933 55,233 35% 158,933 100% A TOTAL REQUIREMENTS 683,508 650,926 95% ; 701,142 235,769 34% ; 701,142 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -Justice Court - - 205,956 68,652 33% 205,956 100% - Transfers In- General Fund I 107,235 111,521 104% TOTAL TRANSFERS 107,235 111,521 104% ; 205,956 68,652 33% ; 205,956 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 144,227 37,842 26% - - - 0° Resources over Requirements (193,658) (149,363) ! (150,310) (61,496) (150,375) (65) Net Transfers - In (Out) I 107,235 111,521 I 205,956 68,652 a I I 205,956 I 1 TOTAL FUND BALANCE $ 57,804 - 0% $ 55,646 $ 7,156 13% ; $ 55,581 100% ; ($65); A One time yearly software maintenance fee paid in July for entire fiscal year Q 1� uTES C 0 �< Budget to Actuals Report C - Sheriff's Office - Fund 255 FY22 YTD October 31, 2021 (unaudited) RESOURCES LED #1 Property Tax Current LED #2 Property Tax Current Sheriffs Office Revenues LED #1 Property Tax Prior LED #1 Interest LED #2 Property Tax Prior LED #2 Interest LED #2 Foreclosed Properties LED #1 Foreclosed Properties TOTAL RESOURCES REQUIREMENTS Sheriffs Services Civil/Special Units Automotive/Communications Detective Patrol Records Adult Jail Court Security Emergency Services Special Services Training Other Law Enforcement Non - Departmental TOTAL REQUIREMENTS 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 27,476,763 27,912,029 102% 28,448,529 3,570,294 13% 28,467,681 100% 19,152: A 11,092,307 11,269,119 102% 11,813,562 1,480,626 13% 0 11,824,026 100% 10,464: A 4,259,128 4,693,854 110% 3,770,574 914,353 24% 3,764,776 100% (5,798)a 280,000 579,513 207% 330,000 97,817 30% 330,000 100% 101,100 170,066 168% 147,416 21,025 14% 72,470 49% (74,946)! 120,000 194,726 162% 145,000 40,659 28% 145,000 100% 120,000 72,488 60% 69,274 4,048 6% 16,400 24% (52,874) - 13,534 - - - -' - 33,522 - - - - 43,449,298 44,938,851 103% ; 44,724,355 6,128,821 14% 44,620,353 100% ; (104,002); Budget Actuals % Budget Actuals % 3,864,843 4,435,626 115% 4,002,499 1,319,263 33% 1,232,618 1,083,411 88% 1,154,204 349,769 30% 3,312,477 3,184,547 96% 3,576,342 981,570 27% 2,515,536 2,546,467 101% 3,029,130 1,208,989 40% 13,284,465 13,388,793 101% 14,015,461 4,444,692 32% 1,038,130 954,506 92% 1,025,023 289,069 28% 20,347,342 18,424,567 91% 21,033,697 6,198,742 29% 490,401 413,143 84% 444,617 129,121 29% 543,565 886,331 163% 789,912 256,887 33% 2,052,586 1,787,984 87% 1,775,588 763,982 43% 1,156,993 1,186,921 103% 1,626,207 610,433 38% 1,328,675 1,331,363 100% 1,389,684 569,122 41% 95,589 1,589 2% 299,998 - 0% 51,263,220 49,625,248 97% 54,162,360 17,121,639 32% ; Projection % $ Variance 3,965,387 99% 37,112, 1,169,304 101% (15,100) 3,487,792 98% 88,550- 3,271,408 108% (242,278) 13,030,767 93% a 984,694a 909,344 89% 115,679 20,049,355 95% 984,3420 390,770 88% 0 53,847 715,549 91% 0 74,363 2,254,225 127% (478,637)! 1,867,652 115% (241,445) 1,613,679 116% (223,995) 299,998 100% 53,025,228 98% ; 1,137,132: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - TRT 3,151,787 3,151,787 100% 3,651,787 1,217,260 33% 3,651,787 100% Transfer In - General Fund 240,290 240,290 100% 121,950 40,648 33% 121,950 100% Transfers Out - Debt Service (273,000) (272,128) 100% (273,000) - 0% (273,000) 100% TOTAL TRANSFERS 3,119,077 3,119,949 100% ; 3,500,737 1,257,908 36% 3,500,737 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 18,676,167 18,832,967 101% 17,874,511 17,266,520 97% 17,266,520 97% (607,991); Resources over Requirements (7,813,922) (4,686,396) (9,438,005) (10,992,817) (8,404,875) 1,033,130- Net Transfers - In (Out) 3,119,077 3,119,949 3,500,737 1,257,908 a 3,500,737 TOTAL FUND BALANCE $ 13,981,322 $ 17,266,520 123% ; $ 11,937,243 $ 7,531,610 63% $ 12,362,382 104% ; $425,139, Note: Vacant positions are driving projected department savings, with OT and other fluctuations causing projected budget overages A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted 0TE5C0G2� Budget to Actuals Report Health Services -Fund 274 FY22 YTD October 31, 2021 (unaudited) RESOURCES State Grant OHP Capitation State Miscellaneous Federal Grants OHP Fee for Service CCBHC Grant Local Grants Environmental Health Fees Medicaid Other Patient Fees Vital Records Divorce Filing Fees State - Medicare Liquor Revenue Interest on Investments State Shared- Family Planning Interfund Contract- Gen Fund State - Medicaid/Medicare TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 15,156,802 14,869,697 98% 17,097,017 5,972,835 35% ; 17,810,277 104% - 713,260� 8,279,406 8,403,083 101% 8,947,837 3,955,907 44% 0 8,947,837 100% - 2,850,731 3,493,477 123% 4,129,465 1,830,790 44% 4,011,411 97% (118,054) 4,833,096 5,641,391 117% 3,633,483 868,280 24% 3,664,558 101% 31,075- 3,265,627 3,877,425 119% 3,627,151 1,017,689 28% 3,230,973 89% (396,178) - - 2,627,291 - 0% 2,627,291 100% a 3,639,059 3,829,781 105% 1,936,838 1,869,145 97% _ 2,509,350 130% - 572,512, 1,091,652 1,106,707 101% 1,086,019 65,034 6% _ 1,096,566 101% 10,547! 350,491 933,393 266% 1,014,100 259,088 26% 777,263 77% (236,837) 965,971 1,106,718 115% 884,036 249,479 28% 854,265 97% (29,771) 672,995 483,754 72% 468,415 190,705 41% 572,117 122% 103,702 237,296 317,189 134% 280,000 88,425 32% 336,165 120% 56,165! 173,030 173,030 100% 173,030 178,331 103% 178,331 103% 5,301! 210,287 217,833 104% 172,200 78,780 46% 236,340 137% 64,140! 99,500 158,977 160% 157,000 53,344 34% 191,824 122% 34,824, 147,400 153,426 104% 156,549 32,022 20% 0 95,160 61% (61,389)! 155,000 146,074 94% 152,634 36,039 24% 108,118 71% (44,516) 127,000 127,000 100% 127,000 - 0% _ 127,000 100% 952,220 882,600 93% 843,050 218,055 26% _ 654,164 78% (188,886) 43,207,563 45,921,554 106% ; 47,513,115 16,963,948 36% ; 48,029,010 101% ; 515,895; REQUIREMENTS Budget Actuals % Budget Actuals % Personnel Services 37,622,192 35,975,598 96% 43,716,878 12,517,750 29% , Materials and Services 14,523,515 13,886,895 96% 13,964,434 3,215,535 23% a Capital Outlay 139,467 131,664 94% 130,000 27,376 21% Administration Allocation - - (26,028) - 0% TOTAL REQUIREMENTS ; 52,285,174 49,994,157 96% 57,785,284 15,760,661 27% ; TRANSFERS Budget Actuals % Budget Actuals % Transfers In- General Fund 5,472,710 5,472,710 100% 5,909,168 1,969,700 33% , Transfers In - TRT 406,646 406,646 100% 444,417 148,136 33% o Transfers In-OHP Mental Health 2,379,865 1,298,965 55% - - Transfers Out (232,908) (232,908) 100% (230,755) (76,916) 33% TOTAL TRANSFERS 8,026,313 6,945,413 87% 6,122,830 2,040,920 33% ; FUND BALANCE Budget Actuals % Budget Actuals % Beginning Fund Balance 6,778,564 7,817,166 115% 10,033,946 10,689,975 107% Resources over Requirements o (9,077,611) (4,072,603) (10,272,169) 1,203,287 Net Transfers - In (Out) 8,026,313 6,945,413 6,122,830 2,040,920 TOTAL FUND BALANCE ; $ 5,727,266 $ 10,689,975 187% ; $ 5,884,607 $ 13,934,182 237% ; Projection % $ Variance 40,100,995 92% 0 3,615,883- 13,859,472 99% 104,962 129,376 100% 624- - 0% (26,028)� 54,089,843 94% 3,695,441: Projection % $ Variance 5,909,168 100% - 444,417 100% (230,755) 100% - 6,122,830 100% ; Projection % $ Variance 10,689,976 107% 656,030, (6,060,833) 4,211,336, o a i a 6,122,830 $ 10,751,973 183% ; $4,867,366: uTES COG�< Budget to Actuals Report Health Services - Admin - Fund 274 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Federal Grants 1,237,245 2,636,157 213% 768,843 138,966 18% _ 619,148 81% (149,695); A State Grant - - a 637,740 - 0% 529,936 83% (107,804); B CCBHC Grant - - 486,804 - 0% € 472,404 97% (14,400); Interest on Investments 147,400 153,426 104% 156,549 32,022 20% 95,160 61% (61,389)- Other i 14,391 12,622 88% 9,200 7,756 84% a 12,768 139% a 3,568 i State Miscellaneous - 347,105 s - - o f - - TOTAL RESOURCES 1,399,036 3,149,311 225% ; 2,059,136 178,744 9% ; 1,729,416 84% (329,720); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,914,729 5,679,486 96% 6,810,635 1,908,139 28% 0 5,871,120 86% 939,515. C Materials and Services 4,991,353 6,435,511 129% 5,872,706 1,823,167 31% 6,152,532 105% (279,826)! D Administration Allocation (9,645,743) (9,645,743) 100% _ (10,188,949) (2,492,616) 24% (10,162,921) 100% (26,028)� TOTAL REQUIREMENTS ; 1,260,339 2,469,254 196% ; 2,494,392 1,238,690 50% 1,860,731 75% 633,661: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (232,908) (232,908) 100% (219,794) (76,916) 35% (219,794) 100% - TOTAL TRANSFERS (232,908) (232,908) 100% ; (219,794) (76,916) 35% ; ; (219,794) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,772,840 3,322,793 120% 3,552,000 3,769,942 106% 35769,942 106% 217,942. Resources over Requirements ' 138,696 680,056 (435,256) (1,059,945) (131,315) 303,941- Net Transfers - In (Out) (232,908) (232,908) (219,794) (76,916) (219,794) TOTAL FUND BALANCE $ 2,678,628 $ 3,769,942 141% ; $ 2,896,950 $ 2,633,081 91% ; $ 3,418,833 118% ; $521,883: A Federal grants are reimbursed on a quarterly basis B Reimbursement less than budgeted due to vacancies C Personnel projections based on year to date vacancy savings and assume 3% moving forward D Expenditures projected over budget due are related to contracts for vaccine rollout under FEMA funds, which were budgeted in Personnel -VES coG1< Budget to Actuals Report Health Services - Behavioral Health -Fund 274 33.3% FY22 YTD October 31, 2021 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 10,348,047 9,920,554 96% 11,907,014 5,085,041 43% 12,056,242 101% = 149,228: A OHP Capitation 8,279,406 8,403,083 101% 8,947,837 3,955,907 44% 8,947,837 100% OHP Fee for Service 3,265,627 3,877,425 119% 3,627,151 1,017,337 28% 3,222,011 89% (405,140); B Federal Grants 3,298,243 2,715,411 82% 2,725,623 687,754 25% 2,908,247 107% 182,624. C CCBHC Grant - - 2,140,487 - 0% 2,154,887 101% 14,400! State Miscellaneous 1,544,455 1,285,829 83% 1,934,643 588,922 30% 1,850,873 96% (83,770)a Local Grants 1,897,762 1,717,173 90% 1,093,055 1,017,497 93% 1,416,302 130% a 323,247! D Medicaid 350,491 933,393 266% 1,014,100 259,088 26% 777,263 77% (236,837); E Other 927,605 1,076,144 116% 682,180 224,936 33% 671,222 98% (10,958) Patient Fees 522,300 382,906 73% 372,115 156,029 42% 468,088 126% 95,973- Divorce Filing Fees 173,030 173,030 100% 173,030 178,331 103% 178,331 103% 5,301! State - Medicare 210,287 217,833 104% 172,200 78,780 46% _ 236,340 137% ° 64,140, F Liquor Revenue 99,500 158,977 160% 157,000 53,344 34% 191,824 122% 34,824! Interfund Contract- Gen Fund 127,000 127,000 100% 127,000 - 0% 127,000 100% TOTAL RESOURCES 31,043,753 30,988,758 100% ; 35,073,435 13,302,965 38% 35,206,467 100% ; 133,032: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 7,434,938 7,434,938 100% 7,523,855 1,892,181 25% 7,523,855 100% a Personnel Services 23,060,066 22,131,010 96% 26,632,065 7,677,254 29% 24,412,187 92% 2,219,878, G Materials and Services 5,998,817 4,097,273 68% 4,882,963 709,565 15% 4,559,046 93% 323,917! Capital Outlay 125,267 106,122 85% 54,000 27,376 51% 53,376 99% 624! TOTAL REQUIREMENTS 36,619,088 33,769,343 92% 39,092,883 10,306,376 26% 36;548,464 93% ; 2,544,419; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 2,036,117 2,036,117 100% 2,278,087 759,348 33% 2,278,087 100% Transfers In- OHP Mental Health 2,298,179 1,217,279 53% - - - Transfers Out - - 0% (10,961) - 0% (10,961) 100% TOTAL TRANSFERS 4,334,296 3,253,396 75% 2,267,126 759,348 33% ; 2,267,126 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 3,008,705 3,397,853 113% 3,612,014 3,870,664 107% 3,870,664 107% 258,650- Resources over Requirements (5,575,335) (2,780,585) (4,019,448) 2,996,589 (1,341,997) 2,677,451 Net Transfers - In (Out) 4,334,296 3,253,396 2,267,126 759,348 2,267,126 TOTAL FUND BALANCE . $ 1,767,666 $ 3,870,664 219% ; $ 1,859,692 $ 7,626,601 410% ; ; $ 4,795,793 258% ; $2,936,101: A Additional funds received for Aid & Assist ($167K). Other small fluctuations in service element dollars B Fees tracking lower than budget C Projections include an extension of unspent funds for the Crisis Program's Bureau of Justice Assistance and SAMHSA CCBHC Expansion grants D Carryforward of unspent FY21 COHC Crisis Services Grant and Choice Model funds. Also includes unbudgeted 2020 Q1 COHC Covid QIM funds. E Medicaid services tracking lower than budget F Medicare services tracking higher than budgeted G Personnel projections based on year to date vacancy savings and assume 6% moving forward '(ES COGz< Budget to Actuals Report Health Services - Public Health - Fund 274 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Grant 4,808,755 4,949,143 103% 4,552,263 887,794 20% 0 5,224,099 115% 671,836, A State Miscellaneous 1,306,276 1,860,543 142% 2,194,822 1,241,868 57% 2,160,538 98% a (34,284) Environmental Health Fees 1,091,652 1,106,707 101% 1,086,019 65,034 6% 1,096,566 101% 10,547! Local Grants 1,741,297 2,112,608 121% 843,783 851,648 101% 1,093,048 130% 249,265: B Vital Records 237,296 317,189 134% a 280,000 88,425 32% 336,165 120% 56,165! Other 23,975 17,952 75% 192,656 16,787 9% _ 170,275 88% (22,381); State Shared- Family Planning 155,000 146,074 94% 152,634 36,039 24% _ 108,118 71% (44,516)a Federal Grants 297,609 289,822 97% 139,017 41,560 30% 137,163 99% (1,854) Patient Fees 150,695 100,848 67% 96,300 34,676 36% 104,029 108% 7,729- OHP Fee for Service - - - 353 8,962 8,962! State - Medicaid/Medicare 952,220 882,600 93% 843,050 218,055 26% 654,164 78% (188,886)' C TOTAL RESOURCES 10,764,775 11,783,485 109% ; 10,380,544 3,482,239 34% 11,093,127 107% ; 712,583: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Administration Allocation 2,210,805 2,210,805 100% 2,639,066 600,435 23% 2,639,066 100% Personnel Services 8,647,397 8,165,103 94% a 10,274,178 2,932,357 29% 9,817,688 96% 456,490- D Materials and Services 3,533,345 3,354,111 95% 3,208,765 682,803 21% a 3,147,894 98% 60,871! Capital Outlay 14,200 25,542 180% = 76,000 - 0% 76,000 100% TOTAL REQUIREMENTS ; 14,405,747 13,755,560 95% ; 16,198,009 4,215,596 26% ; 15,680,648 97% ; 517,361, TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In- General Fund 3,436,593 3,436,593 100% 3,631,081 1,210,352 33% 3,631,081 100% Transfers In - TRT 406,646 406,646 100% 444,417 148,136 33% 444,417 100% a Transfers In- OHP Mental Health 81,686 81,686 100% - TOTAL TRANSFERS 3,924,925 3,924,925 100% ; 4,075,498 1,358,488 33% ; 4,075,498 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 997,019 1,096,520 110% 2,869,932 3,049,370 106% 3,049,370 106% 179,438, Resources over Requirements (3,640,972) (1,972,075) (5,817,465) (733,357) (4,587,521) 1,229,944! Net Transfers - In (Out) 3,924,925 3,924,925 4,075,498 1,358,488 4,075,498 - TOTAL FUND BALANCE ; $ 1,280,972 $ 3,049,370 238% ; $ 1,127,965 $ 3,674,501 326% ; ; $ 2,537,347 225% ; $1,409,382: A Revenue over budget primarily due to additional state funds in Tobacco Prevention ($117K), Oregon Mothers Care ($86K) and WIC ($63K), as well as carryforward of unspent funds from Emergency Preparedness ($36K) B Includes unbudgeted 2020 Q1 COHC Covid QIM funds ($210K) C Medicare services tracking lower than budgeted D Personnel projections based on year to date vacancy savings and assume 3% moving forward o`XuTES COG�< Budget to Actuals Report Community Development - Fund 295 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Admin-Operations 137,450 152,710 111% 138,716 49,110 35% 144,716 104% 6,000, Code Compliance 722,028 783,094 108% 0 842,906 366,014 43% _ 980,906 116% 138,000: A Building Safety 3,362,450 3,921,591 117% 3,819,940 1,564,760 41% a 4,103,940 107% 284,000- B Electrical 720,600 915,357 127% 914,750 353,889 39% , 952,600 104% 37,850! B Environmental On -Site 867,700 1,118,994 129% ; 1,056,678 302,458 29% 1,056,678 100% Current Planning 1,738,304 2,054,192 118% 1,900,521 704,845 36% 2,144,811 108% 164,290! B Long Range Planning 703,194 741,514 105% 826,806 353,795 43% 916,675 111% 89,869! A TOTAL RESOURCES 8,251,726 9,687,451 117% ; 9,580,316 3,694,872 39% ; 10,300,325 108% ; 720,009; REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Admin - Operations 2,818,748 2,740,077 97% 3,137,795 968,642 31% 3,101,954 99% 35,841- C Code Compliance 568,320 539,584 95% 617,012 190,333 31% 602,418 98% 14,594! C Building Safety 1,867,662 1,768,376 95% 2,284,444 685,076 30% 2,161,437 95% 123,007! C Electrical 524,979 487,253 93% 556,531 181,925 33% 549,631 99% 6,900! C Environmental On -Site 634,452 639,025 101% 765,935 186,376 24% 716,743 94% 49,192! C Current Planning 1,479,294 1,465,772 99% 1,769,333 528,785 30% 1,731,076 98% 38,257! C Long Range Planning 580,687 446,049 77% 847,839 176,181 21% 736,839 87% 111,000! D TOTAL REQUIREMENTS ; 8,474,142 8,086,137 95% ; 9,978,889 2,917,318 29% 9,600,098 96% 378,791: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - General Fund 100.000 - 0% 290,000 87,132 30% 290,000 100% Transfers In - CDD Electrical 93,264 - 0% - - - Reserve Transfers Out (100,518) (100,518) 100% (99,360) (33,108) 33% ; _ (99,360) 100% Transfers Out - CDD Reserve (148,226) (1,004,480) 678% (461,262) (268,748) 58% f (921,663) 200% a (460,401)c E TOTAL TRANSFERS (55,480) (1,104,998) 999% ; (270,622) (214,724) 79% (731,023) 270% ; (460,401); FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,012,694 1,253,356 124% 1,432,367 1,749,673 122% 1,749,673 122% 317,30& Resources over Requirements (222,416) 1,601,315 (398,573) 777,554 700,227 1,098,800! Net Transfers - In (Out) (55,480) (1,104,998) (270,622) (214,724) ; o (731,023) (460,401): TOTAL FUND BALANCE $ 734,798 $ 1,749,673 238% ; $ 763,172 $ 2,312,503 303% ; ; $ 1,718,877 225% ; $955,705: A YTD revenue collection is higher than anticipated due to increased building valuations B YTD revenue collection is higher than anticipated due to permitting volume and increased building valuations C Projections reflect unfilled FTE D Expenditures are anticipated to be higher than budgeted E Transfer out projection increased as Building Safety and Electrical revenues are anticipated to be higher than budget as well as underspending due to unfilled positions CES COG2< Budget to Actuals Report Road - Fund 325 FY22 YTD October 31, 2021 (unaudited) RESOURCES Motor Vehicle Revenue Federal - PILT Payment Other Inter -fund Services Forest Receipts Cities-Bend/Red/Sis/La Pine Sale of Equip & Material Miscellaneous Mineral Lease Royalties Interest on Investments Assessment Payments (P&I) Federal Reimbursements State Miscellaneous TOTAL RESOURCES REQUIREMENTS 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 14,810,507 17,342,054 117% 17,485,000 6,545,122 37% 17,485,000 100% 1,690,574 2,061,977 122% 2,096,751 2,195,918 105% 2,195,918 105% 99,167- A 1,114,070 1,198,004 108% 1,221,632 112,517 9% 1,221,632 100% a 723,085 660,298 91% ' 627,207 - 0% 627,207 100% 385,000 627,694 163% 560,000 161,329 29% 0 560,000 100% 396,000 333,109 84% 449,150 58,999 13% 449,150 100% _ - 54,000 73,562 136% 67,340 16,919 25% 67,340 100% i 60,000 51,642 86% 60,000 1,427 2% 60,000 100% 114,000 65,094 57% 59,109 19,451 33% 58,720 99% (389)! 8,000 24,578 307% 3,460 1,652 48% 3,460 100% t 1,325,874 1,093,866 83% - - - •° - 7,048----------------- - - - 20,681,110 23,538,925 114% ; 22,629,649 9,113,334 40% 22,728,427 100% ; 98,778: Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 6,709,180 6,422,847 96% 6,916,229 2,219,752 32% 6,830,571 99% 85,65& B Materials and Services 7,753,525 6,065,466 78% 7,843,400 2,618,356 33% 7,847,400 ; 100% (4,000)C Capital Outlay 50,500 17,944 36% 264,500 24,872 9% 264,500 100% TOTAL REQUIREMENTS 14,513,205 12,506,257 86% ; 15,024,128 4,862,980 32% 14,942,470 99% 81,658: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out (6,683,218) (6,683,218) 100% (11,757,547) (2,213,525) 19% (11,757,547) 100% TOTAL TRANSFERS (6,683,218) (6,683,218) 100% ; (11,757,547) (2,213,525) 19% ; (11,757,547) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,695,786 4,217,071 156% 6,383,832 8,566,521 134% ; 8,566,521 134% 2,182,69& Resources over Requirements 6,167,905 11,032,669 7,605,521 4,250,354 7,785,957 180,436! Net Transfers - In (Out) (6,683,218) (6,683,218) (11,757,547) (2,213,525) (11,757,547) TOTAL FUND BALANCE $ 2,180,473 $ 8,566,521 393% ; $ 2,231,806 $ 10,603,351 475% ; ; $ 4,594,932 206% ; $2,363,126: A Actual payment higher than budget B Projected Personnel savings based on FY22 savings to date C Purchase of chairs for conference room exceeded estimate \3"(ESC0G�� Budget to Actuals Report Adult P&P - Fund 355 FY22 YTD October 31, 2021 (unaudited) RESOURCES DOC Grant in Aid SB 1145 CJC Justice Reinvestment DOC Measure 57 Probation Supervision Fees State Miscellaneous DOC-Family Sentence Alt Interfund- Sheriff Gen Fund/Crime Prevention Interest on Investments Oregon BOPPPS Electronic Monitoring Fee Probation Work Crew Fees Miscellaneous State Subsidy TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 4,621,780 4,621,782 100% 4,202,885 1,155,445 27% a 4,734,453 113% 531,568. A 797,504 793,044 99% 781,597 - 0% 871,753 112% < 90,156! A 239,005 264,005 110% 255,545 - 0% 244,606 96% (10,939)a B 170,000 189,458 111% = 170,000 3,606 2% 3,607 2% (166,393); C - 17,988 I 138,000 - 0% 123,453 89% (14,547); D I - - I 118,250 - 00% 59,250 50% (59,000)� B 50,000 55,000 110% ! 50,000 18,333 37% 50,000 100% 50,000 50,000 100% ; 50,000 . 0% 50,000 100% 37,700 43,276 115% 45,193 6,914 15% 22,450 50% (22,743); - - ' 24,281 - 0% o I 24,281 100% i 10,000 3,973 40% 2,500 236 9% 300 12% (2,200); E 2,000 600 30% 1,500 - 0% - 0% (1,500); C 1,000 � 1,044 104% 500 25 5% 500 100% a I 16,298 - I 0% - - I I - I - 5,995,287 6,040,170 101% ; 5,840,250 1,184,560 20% 6,184,652 106% ; 344,402, REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 5,157,473 4,950,715 96% 5,379,503 1,6269191 30% 0 4,896,873 91% 482,630, F Materials and Services I 1,923,795 1,414,886 74% 1,700,412 386,106 23% I 1,700,412 100% •I TOTAL REQUIREMENTS 7,081,268 6,365,601 90% 7,079,915 2,012,297 28% ; 6,597,285 93% ; 482,630: TRANSFERS Budget Actuals % Budget Actuais % Projection % $ Variance Transfers In- General Funds 285,189 285,189 100% 662,046 220,680 33% 0 662,046 100% a Transfer to Vehicle Maint I (97,693) (97,693) 100% I (190,974) (60,732) 32% I (190,974) 100% TOTAL TRANSFERS 187,496 187,496 100% ; 471,072 159,948 34% 471,072 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 2,714,814 3,119,990 115% 2,739,775 2,982,055 109% 2,982,055 109% 242,280� Resources over Requirements (1,085,981) (325,431) (1,239,665) (827,737) (412,633) 827,032= Net Transfers - In (Out) 187,496 187,496 471,072 159,948 471,072 I I I I I I TOTAL FUND BALANCE o $ 1,816,329 $ 2,982,055 164% ; $ 1,971,182 $ 2,314,266 117% ; $ 3,040,494 154% ; $1,069,312; A State Dept. of Corrections and related allocations were approved at higher levels than budgeted B State Dept. of Corrections and related allocations were approved at lower levels than budgeted C State law terminates probation supervision related fees as of 1/1/22. The department ceased collection on 7/1/21 and Dept of Revenue has closed any preexisting garnished accounts. D Criminal Justice Commission Adult Treatment Court final grant award was less than budgeted E Final payments from electronic monitoring clients prior to when the division shifted to a contract program received and Dept of Revenue has closed any garnished accounts F Projected Personnel savings based on FY22 average vacancy rate of 8.4% o� 0 0 �1Es ` �< Budget to Actuals Report `2 Road CIP - Fund 465 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance State Miscellaneous 2,258,100 2,670,996 118% 2,191,461 - 0% 2,191,461 100% Interest on Investments 209,700 271,831 130% 279,729 47,183 17% 149,260 53% (130,469) TOTAL RESOURCES 2,467,800 2,942,827 119% ; 2,471,190 47,183 2% ; 2,340,721 95% ; (130,469); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 158,465 158,465 100% 109,870 36,623 33% 109,870 100% Capital Outlay 19,877,585 11,583,557 58% 29,612,821 3,939,155 13% 27,878,020 94% 1,734,801, A TOTAL REQUIREMENTS 20,036,050 11,742,022 59% 29,722,691 3,975,778 13% ; 27,987,890 94% 1,734,801: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In 7,517,657 6,819,612 91% 12,193,917 - 0% a 12,193,917 100% - TOTAL TRANSFERS 7,517,657 6,819,612 91% ; 12,193,917 - 0% ; 12,193,917 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 23,154,407 25,512,586 110% 20,374,044 23,533,004 116% 23,533,004 116% 3,158,960; Resources over Requirements (17,568,250) (8,799,195) (27,251,501) (3,928,595) (25,647,169) 1,604,332i Net Transfers - In (Out) 7,517,657 6,819,612 12,193,917 - 12,193,917 TOTAL FUND BALANCE a $ 13,103,814 $ 23,533,004 180% ; $ 5,316,460 $ 19,604,409 369% $ 10,079,752 190% ; $4,763,292: A Updated based on anticipated completion of projects in FY22 coming in under budget or delayed to FY23 COGZ< Budget to Actuals Report q`wtES %--Wool Road CIP (Fund 465) - Capital Outlay Summary by Project 33.3% FY22 YTD October 31, 2021 (unaudited) Year Completed Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance Tumalo Res Rd: OB Riley to Bailey Rd Skyliers Road (58,232) Sisemore Bridge 404,245 598,081 148% 's ARTS Project (66,618) Terrebonne Refinement Plan 5,000,000 10,000,000 0% 10,000,000 100% S. Canal / Helmholtz Way 7,376 Tumalo Road / Tumalo Place 1,517,345 1,092,426 72% € 67,998 74,265 (74,265) Old Bend Rdm/Tumalo Rd Inter 1,350,782 1,200,636 89% i 16,907 16,907 (16,907): NE Negus and 17TH 788,684 339,647 43% 2,363,532 649,075 27% i 2,274,311 96% 1 89,221 Hunnel Rd: Loco Rd to Tumalo Rd 794,229 240,723 30% 's 2,168,940 5,829 0 % i 964,710 44% 1,204,230 Cascade Lakes Hwy Bike Facilities 32,740 Transportation System Plan Update 170,000 82,053 48 % 108,510 32,908 30% 159,515 147 % (51,005) US 97 Bend North Corridor 5,000,000 5,000,000 100% Gribbling Rd Bridge 222,000 - 0% 279,575 0% i 151,200 54% i 128,375 Paving Fyrear Rd 1,564,000 1,621,324 97% i Paving of S. Century Dr 100,000 447,416 447% Terrebonne Wastewater Feasibility St. 50,000 63,646 127% 19,184 19,184 (19,184) Rickard Rd: Groff Rd to US 20 605,300 497,920 82 % 1,716,142 1,347,936 79% 1,483,692 86 % 232,450: 651,000 38,085 6% 931,140 1,319,374 142% 1,319,612 142% (388,472) Paving Powell Butte Hwy Smith Rock Way Bridge Replace 85,000 0% 505,000 253 0% ': 185,000 37% € 320,000 Deschutes Mkt Rd/Hamehook Round 150,000 10,277 7% 671,000 30,279 5 % 371,000 55% i 300,000 US 97: S. Century Dr to USFS Boundry 70,090 Johnson Rd Curve Warning Signs 100,000 59,710 60% Speed Feedback Sign Installation 50,000 76,314 153% Paving Cottonwood: Us 97 To BSNF RP. 618,144 449,412 73% 527,786 85 % 90,358 Paving Desch Mkt Rd: Yeoman Hamehoo 310,838 0% 310,838 100 265,000 0% 265,000 100% € Paving Alfalfa Mkt Rd: Mp 4 Dodds Paving Of Hamby Rd: Us 20 To Butler 200,000 0% 200,000 100% Powell Butte Hwy/Butler Market RB 150,000 0% 150,000 100% 100,000 0% 100,000 100% Wilcox Ave Bridge #2171-03 Replacem US 20: Cook Ave/OB Riley Rd (Tumalo 6,700,000 0% € 6,700,000 100 Slurry Seal 2021 246,628 US 20: Tumalo Multi -Use Path Crossing 1,250,000 1,250,000 100% 50,000 (50,000) Highway Warning Systems 2021 Guardrail Improvements 100,000 83,367 83 % ? 100,000 0°/ 100,000 100% Redmond District Local Roads 500,000 500,000 100% Bend District Local Roads 500,000 0% 500,000 0% 500,000 100% City of LaPine Local Roads 500,000 0 Sidewalk Ramp Improvements 75,000 0% 75,000 0% 75,000 100% 100,000 0% 100,000 0% 130,000 130% (30,000) Signage Improvements TOTAL CAPITAL $ 19,877,585 $ 11,583,607 58%` $ 29,612,821 $ 3,939,155 13%: $ 27,878,020 94V $ 1,734,801 1E5 C,0 Budget to Actuals Report Solid Waste - Fund 610 FY22 YTD October 31, 2021 (unaudited) RESOURCES Franchise Disposal Fees Private Disposal Fees Commercial Disp. Fee Yard Debris Franchise 3% Fees Miscellaneous Interest Special Waste Recyclables Leases Equip & Material TOTAL RESOURCES REQUIREMENTS Personnel Services Materials and Services Capital Outlay Debt Service TOTAL REQUIREMENTS TRANSFERS SW Capital & Equipment Reserve TOTAL TRANSFERS 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 6,630,625 6,764,888 102% 7,124,000 2,193,598 31% 7,124,000 100% A 2,491,617 2,985,124 120% 2,827,000 1,226,377 43% 2,827,000 100% A 2,319,792 2,830,984 122% 2,686,000 1,032,303 38% 2,686,000 100% A 216,761 301,824 139% 300,000 115,240 38% a 300,000 100% B 280,000 389,402 139% 290,000 85,117 29% 290,000 100% 88,096 102,595 116% ; 55,000 26,360 48% 55,000 100% 23,700 42,794 181% 41,599 11,918 29% 37,940 91% (3,659) 15,000 34,292 229% 15,000 31,663 211% 40,000 267% 25,000- C 12,000 11,180 93% 12,000 5,747 48% 12,000 100% 1 1 100% 1 - 0% 1 100% - 200 - - - - 12,077,592 13,463,285 111% ; 13,350,600 4,728,323 35% ; 13,371,941 100% ; 21,341: Budget Actuals % Budget Actuals % Projection % $ Variance 2,518,594 2,510,986 100% 2,754,132 846,113 31% 2,754,132 100% - 5,227,119 4,705,435 90% 5,651,103 1,433,043 25% 5,651,103 100% 162,500 29,523 18% 53,141 37,567 71% a 91,305 172% (38,164); D 945,000 861,354 91% 1,251,615 - 0% _ ' 1,251,615 100% 8,853,213 8,107,298 92% ; 9,709,991 2,316,724 24% ; 9,748,155 100% ; (389164); Budget Actuals % Budget Actuals % Projection % $ Variance (3,684,280) (3,684,280) 100% _ (6,029,323) (1,507,652) 25% (6,029,323) 100% - ; (3,684,280) (3,684,280) 100% ; (6,029,323) (1,507,652) 25% ; ; (6,029,323) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,179,819 2,285,566 194% 2,972,234 3,957,273 133% 3,957,273 133% 985,039, Resources over Requirements 3,224,379 5,355,987 3,640,609 2,411,599 3,623,786 (16,823) Net Transfers - In (Out) a (3,684,280) (3,684,280) (6,029,323) (1,507,652) (6,029,323) a TOTAL FUND BALANCE $ 719,918 $ 3,957,273 550% ; $ 583,520 $ 4,861,220 833% ; $ 1,551,736 266% ; $968,216: A Disposal tons are typically higher in summer with reductions in winter; fiscal YTD volumes are running over 9% higher than last year-to-date. Franchise disposal fee payments of $215K were not received from Republic Services (Bend Garbage and Wilderness Disposal) by closing. B Revenue is seasonal with higher utilization in summer months C Revenue source is unpredictable and dependent on special clean-up projects; recent large contaminated soil projects from remediation of a gas station and illegal dumping site D The new 1 ton service truck and service box ordered in FY21 was rolled into FY22 due to delayed availability TES c0G�< Budget to Actuals Report Fair &Expo - Fund 615 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Events Revenue 625,000 1,194,701 191% = 578,000 195,865 34% 613,000 106% ; 35,0W A Food & Beverage 548,500 209,297 38% 513,500 152,770 30% 578,000 113% 64,500= A Rights & Signage 125,000 62,500 50% 105,000 - 0% 71,000 68% a (34,000) Storage 75,000 77,897 104% ; 77,500 - 0% 71,000 92% (6,500); B Horse Stall Rental i 52,000 11,378 22% 71,500 34,520 48% 45,000 63% (26,500); Interfund Payment 30,000 226,786 756% ; 30,000 10,000 33% 30,000 100% Camping Fee 12,500 5,630 45% 19,500 - 0% 6,000 31% ! (13,500) Interest i (2,200) 1,051 -48% a 474 1,927 407% 5,730 999% ; 5,256 Miscellaneous 250 2,596 999% 250 1,564 625% 3,509 999% 3,2% TOTAL RESOURCES 1,466,050 1,791,835 122% ; 1,395,724 396,646 28% ; 1,423,239 102% ; 27,515: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 840,704 1,031,160 123% 1,118,980 357,903 32% 1,079,145 96% 39,835, C Personnel Services - F&B 165,518 165,801 100% 181,593 54,303 30% 162,343 89% 19,2% D Materials and Services 702,149 576,528 82% 818,804 222,537 27% 694,000 85% 124,804 Materials and Services - F&B i 257,600 134,431 52% 282,500 52,994 19% a 177,000 63% 105,500! Debt Service 104,400 103,519 99% 103,000 - 0% 103,000 100% a TOTAL REQUIREMENTS ; 2,070,371 2,011,440 97% ; 2,504,877 687,737 27% 2,215,488 88% ; 289,389: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Room Tax 650,000 899,310 138% 905,769 301,920 33% 1,144,598 126% 238,829; E Transfers In -County Fair - - ° 150,000 150,000 100% 150,000 100% i Transfers In - Park Fund 30,000 30,000 100% 30,000 10,000 33% 30,000 100% - Transfers In - Room Tax (as 25,744 25,744 100% a 25,744 8,580 33% 25,744 100% ° needed) Transfers In - General Fund 200,000 200,000 100% Transfers Out 10,777 ( ) 10,777 ( ) 100% 310,777 ( ) 103,592 ( ) 33% 310,777 ( ) 100% ' TOTAL TRANSFERS 894,967 1,144,277 128% ; 800,736 366,908 46% ; 1,039,565 130% ; 238,829, FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 364,904 (1,199) 0% 750,673 923,473 123% 923,473 123% 172,8W Resources over Requirements (604,321) (219,605) (1,109,153) (291,092) (792,249) 316,904 Net Transfers - In (Out) 894,967 1,144,277 800,736 366,908 1,039,565 238,829 TOTAL FUND BALANCE $ 655,550 $ 923,473 141% ; $ 442,256 $ 999,289 226% ; $ 1,170,789 265% ; $728,533: A Increased event revenue due to increased/new events due to rescheduled events and possible pent up market demand B Storage estimates reduced due to later start dates and fewer available spaces, due to increased events C Projection reflects vacancy savings D Projected Personnel based on savings to date E Room tax revenue projected to be higher than budget Qh`�vTESCpG, Budget to Actuals Report Annual County Fair - Fund 616 FY22 YTD October 31, 2021 (unaudited) RESOURCES Gate Receipts Concessions and Catering Carnival Commercial Exhibitors Fair Sponsorship State Grant R/V Camping/Horse Stall Rental Rodeo Livestock Entry Fees Merchandise Sales Interest on Investments TOTAL RESOURCES REQUIREMENTS Personnel Services Materials and Services TOTAL REQUIREMENTS TRANSFERS 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance - 550,000 738,029 134% ; 738,029 134% 188,029; i - - e 385,000 526,737 137% 526,919 137% 141,919� i - � 330,000 415,716 126% 415,717 126% 85,717: 110,000 85,100 77% 85,100 77% (24,900)a - - 6 83,500 40,525 49% 40,525 49% (42,975)� 52,000 53,167 102% a 52,000 - 0% 52,000 100% - 25,500 19,944 78/° ° 19,944 78% (5,556); 20,000 24,600 123% 24,600 123% 4,600a 4,500 - 0% - 0% (4,500)a B - 5,239 � � 5,239 a 5,239! i - (129) 999% P - 1,083 3,570 3,570 52,000 53,038 102% ; 1,560,500 1,856,974 119% ; 1,911,642 123% ; 351,142: Budget Actuals % Budget Actuals % Projection % $ Variance 110,000 163,282 148% 155,959 8,876 6% 104,608 67% 51,351 A 17,000 26,328 155% 1,312,172 1,214,203 93% 1,312,172 100% 127,000 189,611 149% ; 1,468,131 1,223,080 83% 1,416,780 97% 51,351: Budget Actuals %, Budget Actuals % Projection % $ Variance Transfer In - TRT 1 % 75,000 75,000 100% 75,000 25,000 33% 75,000 100% Transfer Out _ Fair & Expo - - (150,000) (150,000) 100% (150,000) 100% TOTAL TRANSFERS 75,000 75,000 100% ; (75,000) (125,000) 167% ; (75,000) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance - (47,461) 999% i - (109,033) (109,033) ' (109,033);' Resources over Requirements (75,000) (136,573) 92,369 633,894 494,862 402,493; Net Transfers - In (Out) 75,000 75,000 (75,000) (125,000) (75,000) TOTAL FUND BALANCE _ ($ 109,033) $ 17,369 $ 399,861 999% ; $ 310,829 999% ; $293,460: A Projection reflects vacancy savings 0-� E S C, 0 Budget to Actuals Report Annual County Fair - Fund 616 CY21 YTID October 31, 2021 (unaudited) Fair 2021 Actuals to 2021 Fair 2020 = Date Projection RESOURCES Gate Receipts $ ,gg�ql $ g-,Igg 738,029 $ 738,029 Carnival , 415,716 415,716 Commercial Exhibitors (5,800) 11 10, 315,719 315,719 Livestock Entry Fees R/V Camping/Horse Stall Rental 19,944 19,944 Merchandise Sales 5,239 5,239 Concessions and Catering 295,093 295,093 Fair Sponsorship (22,250),",5,01, " 65,125 65,125 TOTAL FAIR REVENUES $ (28,050 $ 1,854,865 $ 1,854,865 OTHER RESOURCES State Grant 53,167 53,167 Interest 11 1,035 1,553 Miscellaneous - TOTAL RESOURCES $ 25,127 4,,y $ ....... ... . 1 `1 5 1,855,901 $ 11,909,5086 REQUIREMENTS MW Personnel 154,640 98,778 103,031 Materials & Services 85,216 n 1,222,793 1,228,793 TOTAL REQUIREMENTS $ 239,856 $ 1,321,571 $ 1,331,824 TRANSFERS Transfer In - TRT 1 % 162,750 i 62250 75,000 Transfer Out - Fair & Expo ............ (150,000) (150,000 TOTAL TRANSFERS $ 162,750 $ (87,750) $ (75,000 Net Fair $ (511,979),"E"Iffl, $ 446,580 $ 502,762 Beginning Fund Balance on Jan 1 $ 3,285 $ (48,694) $ (48,694 Ending Balance $ (48,694) $ 397,886 $ 454,068 A Projection reflects vacancy savings o(�uTES C0 Budget to Actuals Report Fair & Expo Capital Reserve -Fund 617 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 14,000 8,532 61% ; 8,544 2,485 29% 7,480 88% (1,064)� TOTAL RESOURCES 14,000 8,532 61% 8,544 2,485 29% ; 7,480 88% ; (1,064); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Materials and Services 235,000 16,910 7% 180,000 188 0% 180,000 100% Capital Outlay 166,940 73,613 44% 388,000 - 0% a 388,000 100% TOTAL REQUIREMENTS ; 401,940 90,523 23% 568,000 188 0% ; 568,000 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In -TRT 1% 453,158 385,418 85% 428,901 142,964 33% _ 531,256 124% 102,355. Transfers In - Fair & Expo - - 300,000 100,000 33% 6 300,000 100% TOTAL TRANSFERS 453,158 385,418 85% 728,901 242,964 33% 831,256 114% ; 102,355; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 1,143,224 726,169 64% 1,101,663 1,029,596 93% _ 1,029,596 93% (72,067); Resources over Requirements ' (387,940) (81,991) (559,456) 2,297 (560,520) (1,064); Net Transfers - In (Out) k 453,158 385,418 I 728,901 242,964 i t 831,256 102,355 I 1 TOTAL FUND BALANCE e $ 1,208,442 $ 1,029,596 85% ; $ 1,271,108 $ 1,274,858 100% ; ; $ 1,300,332 102% ; $29,224: uTES COGZ< Budget to Actuals Report RV Park - Fund 618 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance RV Park Fees < 31 Days 400,200 620,655 155% a 475,000 223,450 47% 601,134 127% 126,134, RV Park Fees > 30 Days I 12,000 13,886 116% a 10,500 7 0% 15,116 144% 4,616 Washer / Dryer 4,000 5,295 132% 5,000 2,080 42% 4,545 91% (455) Miscellaneous I 2,250 2,679 119% s 2,500 984 39% I 2,869 115% 369! Vending Machines I 3,000 1,229 41% 2,500 799 32% 1,461 58% (1,039)0 Interest on Investments I 7,600 1,636 22% 2,024 172 9% I 500 25% (1,524)! Cancellation Fees I 5,500 8,825 160% ; - 8,326 I I 14,270 I 14,270s I Good Sam Membership Fee 1,500 - I 0% - - I I 1 - I - TOTAL RESOURCES 436,050 654,204 150% ; 497,524 235,818 47% ; 639,895 129% ; 142,371: REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services - - 113,956 33 0% 57,027 50% 56,929s A Materials and Services I 321,402 291,093 91% 216,305 84,413 39% I 259,101 120% (42,796)< Debt Service 222,500 221,874 100% 165,927 - 0% 165,927 100% - TOTAL REQUIREMENTS 543,902 512,967 94% 496,188 84,446 17% ; 482,055 97% ; 14,133: TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfers In - Park Fund 160,000 160,000 100% = 160,000 - 0% 160,000 100% _ B Transfers In - TRT Fund I 25,000 20,000 80% 20,000 6,664 33% I 20,000 100% Transfer Out - RV Reserve I (621,628) (549,173) 88% (132,042) (44,012) 33% I (132,042) 100% TOTAL TRANSFERS 1436,628) (369,173) 85% ; 47,958 (37,348) -78% ; ; 47,958 100% FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 587,992 227,936 39% - - - 0. Resources over Requirements I (107,852) 141,237 I 1,336 151,372 I I 157,840 I 156,504- I I Net Transfers - In (Out) (436,628) (369,173) 47,958 (37,348) 47,958 - I TOTAL FUND BALANCE $ 43,512 - 0% $ 49,294 $ 114,024 231% $ 205,798 417% ; $156,504. A New FTE added to the FY22 budget, which has not been filled B Transfer occurs in November o� TES 0 2{ Budget to Actuals Report �1 RV Park Reserve -Fund 619 33.3% FY22 YTD October 31, 2021 (unaudited) Year Complete Fiscal Year 2021 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Interest on Investments 1,100 7,787 708% 7,546 2,258 30% 6,910 92% (636), TOTAL RESOURCES 1,100 7,787 708% ; 7,546 2,258 30% ; 6,910 92% ; (636); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Capital Outlay 100,000 - 0% 100,000 - 0% 100,000 100% - TOTAL REQUIREMENTS ; 100,000 - 0% 100,000 - 0% 100,000 100% ; TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance Transfer In - RV Park Ops 621,628 549,173 88% 132,042 44,012 33% 132,042 100% - TOTAL TRANSFERS 621,628 549,173 88% 132,042 44,012 33% ; 132,042 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 490,000 497,466 102% 784,466 1,054,426 134% 1,054,426 134% 269,960, Resources over Requirements 1 (98,900) 7,787 (92,454) 2,258 (93,090) (636)! Net Transfers - In (Out) 621,628 549,173 132,042 44,012 132,042 TOTAL FUND BALANCE a $ 1,012,728 $ 1,054,426 104% ; $ 824,054 $ 1,100,697 134% ; $ 1,093,378 133% ; $269,324, E5c0' Budget to Actuals Report Risk Management - Fund 670 FY22 YTD October 31, 2021 (unaudited) RESOURCES Workers' Compensation General Liability Property Damage Unemployment Vehicle Interest on Investments Claims Reimbursement Skid Car Training Process Fee- Events/ Parades Miscellaneous Loss Prevention 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 1,188,848 1,224,408 103% 1,120,766 407,490 36% _ 1,120,766 100% •' 990,628 963,201 97% 944,278 313,591 33% _ 944,278 100% 373,698 373,548 100% a 393,546 136,531 35% 393,546 100% a 323,572 315,619 98% 323,572 269,049 83% a 323,572 100% a A 218,185 222,266 102% 227,700 75,900 33% 227,700 100% 87,200 100,030 115% 101,111 18,938 19% 60,300 60% (40,811) 50,000 39,428 79% 25,000 6,913 28% 1,200,000 999% 1,175,000, B 30,000 270 1% 10,000 - 0% 2,000 20% (8,000)! 1,500 810 54% 1,000 495 50% E I 1,000 100% I 5 - 0% - 180 I 200 200! 10 - 0% - - - TOTAL RESOURCES 3,263,646 3,239,580 99% ; 3,146,973 1,229,087 39% ; 4,273,362 136% ; 1,126,389: REQUIREMENTS Workers' Compensation General Liability Insurance Administration Property Damage I Unemployment I Vehicle r TOTAL REQUIREMENTS TRANSFERS Budget Actuals % Budget 1,560,000 1,100,000 584,104 9-00,240 200,000 150,000 3,794,344 912,395 58% 1,580,000 466,547 42% 1,200,000 408,666 70% 547,047 330,869 165% 300,245 98,978 49% 200,000 173,925 1 116% ' 200,000 Actuals % 220,715 14% 1 i 2,050,334 171% 170,040 31% i 268,292 l 89% ' 41,379 21% I I I 64,589 32% ' 2,391,380 63% ; 4,027,292 2,815,348 70% ; , Projection % $ Variance 1,580,000 100% 3,000,000 250% (1,800,000); C 547,047 100%: 450,000 150% (149,755); D 200,000 100% I � 200,000 100% ' I--o 5,977,047 148% ; (1,949,755); Budget Actuals % Budget Actuals % Projection % $ Variance Transfers Out -Vehicle Replace (3,500) (3,500) 100% (3,500) (1,164) 33% (3,500) 100% TOTAL TRANSFERS (3,500) (3,500) 100% ; (3,500) (1,164) 33% ; ; (3,500) 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance Beginning Fund Balance 7,000,000 8,676,750 124% 8,329,115 9,521,450 114% 9,521,450 114% ' 1,192,335' Resources over Requirements (530,698) 848,200 (880,319) (1,586,261) (1,703,685) (823,366) Net Transfers - In (Out) I (3,500) (3,500) I (3,500) (1,164) _ I I (3,500) I I TOTAL FUND BALANCE $ 6,465,802 $ 9,521,450 147% ; $ 7,445,296 $ 7,934,025 107% ; $ 7,814,265 105% ; $368,969: A Unemployment collected on first $25K of employee's salary in fiscal year B Reimbursement from excess carrier for Kozoswki lawsuit payout C General Liability claims paid includes the Kozoswki lawsuit payout -- part will be reimbursed by excess carrier D Projection is based on YTD actuals which are high due to several vehicle crashes oh vTES C, 2{ 0 Budget to Actuals Report Health Benefits - Fund 675 FY22 YTD October 31, 2021 (unaudited) 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance Internal Premium Charges 17,831,938 18,580,799 104% 18,767,900 6,269,446 33% 18,767,900 100% COIC Premiums ! 1,600,000 1,642,789 103% 1,589,000 418,479 26% a 1,589,000 100% Employee Co -Pay 1,031,400 1,205,713 117% = 1,200,000 407,327 34% 1,200,000 100% Retiree I COBRA Premiums I 1,035,000 958,664 93% 1,060,000 198,921 19% _ 900,000 85% (160,000), Interest ! 216,200 193,598 90% 200,277 36,801 18% e e 115,280 58% a (84,997)! Prescription Rebates 90,000 179,184 199% 128,000 - 0% 128,000 100% Claims Reimbursement & Other 80,000 1,073 1% 82,000 - 0% ! 82,000 100% TOTAL RESOURCES 21,884,538 22,761,820 104% ; 23,027,177 7,330,975 32% 22,782,180 99% ; (244,997); REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Health Benefits 19,937,274 19,126,362 96% 0 19,640,847 5,161,394 26% 19,640,847 100% o A Deschutes On -Site Pharmacy I 2,417,092 2,972,758 123% 2,970,575 839,917 28% 2,970,575 100% a A Deschutes On -Site Clinic ! 1,101,467 1,087,809 99% 1,141,829 330,330 29% 1,141,829 100% ° A Wellness ! 164,340 149,145 91% 171,142 61,941 36% I 171,142 100% a A TOTAL REQUIREMENTS ; 23,620,173 23,336,074 99% ; 23,924,393 6,393,581 27% 23,924,393 100% ; FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ variance Beginning Fund Balance 15,323,729 16,101,833 105% = 14,772,618 15,527,580 105% 15,527,580 105% 754,962, Resources over Requirements ! (1,735,635) (574,254) (897,216) 937,393 (1,142,213) _ (244,997) 1 I Net Transfers - In (Out) - I - - - ! ! - I I I I I 9 1 TOTAL FUND BALANCE $ 13,588,094 $ 15,527,580 114% ; $ 13,875,402 $ 16,464,973 119% ; $ 14,385,367 104% ; $509,965: A Amounts are paid 1 month in arrears o� TES 0 ,� Budget to Actuals Report . ,`l 911 - Fund 705 and 710 FY22 YTD October 31, 2021 (unaudited) RESOURCES Property Taxes - Current Yr Telephone User Tax Police RMS User Fees User Fee Data Network Reimbursement Contract Payments Property Taxes - Prior Yr Interest State Reimbursement Property Taxes - Jefferson Co. Miscellaneous TOTAL RESOURCES 33.3% Year Complete Fiscal Year 2021 1 Fiscal Year 2022 Budget Actuals % Budget Actuals % Projection % $ Variance 9,113,459 9,350,147 103% 9,803,579 1,229,058 13% 9,809,150 100% = 5,571 A 1 1,106,750 1,441,364 130% 1,106,750 454,281 41% a o 1,106,750 100% B 1 250,000 390,879 156% 236,576 - 0% a 236,576 100% _ C 1 73,000 110,978 152% 233,576 4,853 2% 0 233,576 100% 1 55,000 96,896 176% 162,000 64,947 40% _ 162,000 100% 1 157,252 136,638 87% 147,956 14,250 10% E 147,956 100% 1 90,000 152,893 170% 115,000 31,610 27% 115,000 100% 90,400 110,233 122% 96,867 19,275 20% 60,500 62% (36,367)� 1 83,000 131,881 159% 60,000 - 0% 60,000 100% D 1 33,637 36,598 109% 38,344 544 1% a 38,344 100% 1 12,200 ° 1 121,920 999 /0 18,658 9,296 ° , 1 50 /o 18,658 100% ! 1 - 11,064,698 12,080,426 109% ; 12,019,306 1,828,113 15% ; 11,988,510 100% ; (30,796), REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance Personnel Services 7,620,458 7,190,545 94% 8,005,795 2,458,769 31% 7,264,561 91% 7411234- E Materials and Services 1 3,476,381 2,912,246 84% 3,557,212 808,825 23% 3,557,212 100% Capital Outlay 1 1,480,000 431,457 29% 3,000,000 23,743 1% 1 3,000,000 100% TOTAL REQUIREMENTS ; 12,576,839 10,534,248 84% 14,563,007 3,291,337 23% ; 13,821,773 95% 741,234, FUND BALANCE Budget rwa%tialS o Budget Actuals % Projection % $ Variance Beginning Fund Balance 8,341,418 9,162,894 110% 11,850,783 10,709,072 90% 10,709,072 90% (1,141,710): Resources over Requirements (1,512,141) 1,546,177 (2,543,701) (1,463,224) (1,833,263) ! 710,438- 6 1 I t ! 1 Net Transfers - In (Out) - - - - - 1 1 1 1 1 I TOTAL FUND BALANCE $ 6,829,277 $ 10,709,072 157% ; $ 9,307,082 $ 9,245,847 99% $ 8,875,809 95% ; ($431,273); A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted g Telephone maintenance reimbursements are received in a lump sum by early spring C Invoices are mailed in the Spring D State GIS reimbursements are received quarterly E Projected Personnel savings based on FY22 average vacancy rate of 9.6% -� Es roG�� o � MEETING DATE: 11/22/2021 SUBJECT: Report on October 18 internet outage. RECOMMENDED MOTION: None. BACKGROUND AND POLICY IMPLICATIONS: On. October 181", 2021 the County's connection to the internet suffered a daytime outage lasting almost 10.5 hours. The Information Technology Department will deliver a verbal report on the cause and what actions are being taken to mitigate the impacts of future outages. BUDGET IMPACTS: None. ATTENDANCE: Kevin Furlong, Technology Division Manager Joe Sodony, IT Director �01 ES CO 4 -< INFORMATION TECHNOLOGY March 51h, 2021 From: Kevin Furlong, IT Operation Manager To: Board of County Commissioners Re: Report - Internet Outage on 10/18/2022 The Incident: Monday October 18th, 2021, at 10:15AM the county's internet services went down. We were notified by our provider that somewhere between Bend and Seattle a fiber optic cable had been severed. Several customers between Bend and Seattle lost internet communication services. We were informed the cause was a damaged cable located on a bridge near or in Tacoma, WA. With the location of the cable break identified, our internet traffic was temporarily rerouted to an alternate path. Our services were restored at approximately 8:45PM. Impact of Outage on County Operations: Within minutes, a network monitoring tool in IT showed an alarm status for internet service. IT helpdesk staff began receiving reports of internet dependent services going off-line. IT network operations staff quickly determined the outage sourced from beyond the connection to the internet service provider. Approximately half of county departments are dependent on the internet for line -of -business applications. When cut- off from the internet these department's operations are severely impacted. As part of the update of the county's phone system, two of four connections to the public telephone system network failed. This resulted in several departments not able to receive and make calls outside the county. The Sheriff's Office and 9-1-1 telecommunications were not impacted. Approximately 350 county employees had been migrated to the Microsoft 365 cloud service. This meant these employees were not able to access their email from the county network. County employees working remotely were not able to access county services. Incident Response: Contact to the internet services provider was made and maintained throughout the outage. The IT Department was kept up to date with critical information as the service provider learn of the cause and as their response progressed. 1300 NW Wall Street Bend, Oregon 97703 A� (541)388-6530 @ joe.sadony@Desch utesCounty 0 www.DeschutesCounty.gov The county's connection to the internet is reliant on a single internet service provider. There were no actions for the IT Department to take to restore internet connectivity. As part of the phone systems upgrade, the Sheriff's Office updated their telecommunications to use the internet, but with a separate connection to the internet. The Sheriff's outgoing and incoming telecommunications services were not impacted. However, the Sheriff uses the same telecommunications provider as the IT Department. This allowed IT and the Sheriff to coordinate with the telecommunications services provider to move all incoming and outgoing calls to the Sheriff's functioning telecommunications service. This allowed for incoming and outgoing calls to be restored to all county departments during the outage. As part of long-range planning the IT Department had planned to implement stronger resilience in internet communications. In reaction to this incident, the IT Department has moved up the implementation schedule of a redesign of our connection to the internet. The redesign incorporates the services of two separate internet service providers and two independent connections to the internet with redundant equipment. This redesign is not simple and certainly not inexpensive. However, the IT Department sees this incident as justification for early implementation. Lessons Learned: Progress in the development of business software systems and business communications have moved services to the internet. This is called the "Software as a Service" delivery model. This change in how these services are delivered have over time made connectivity to the internet a critical aspect of our business systems. Unplanned internet outages of this duration are rare. In fact, the IT Department can only recall the outage that was caused by a traffic accident cutting off all of Central Oregon from the internet and telecommunications. This was many years ago and Central Oregon's connectivity to the outside has been vastly improved. However, technology is not foolproof and there's no end in sight to our increasing dependency. Hindsight says the redesign of the county internet connection is overdue. The incident does bring to light the need for departments to look at how their operations and dependency on the internet. A department should have contingency plans to address internet outages. Cc: Nick Lelack, County Administrator Whitney Hale, Deputy County Administrator Erik Kropp, Deputy County Administrator 1300 NW Wall Street Bend, Oregon 97703 (541)388-6530 @ joe.sadony@Desch utesCounty @ www.DeschutesCounty.gov