2022-284-Minutes for Meeting July 11,2022 Recorded 8/2/2022cu�G�vT ES COG2�
k BOARD OF
COMMISSIONERS
1300 NW Wall Street, Bend, Oregon
(541) 388-6570
•
Recorded in Deschutes County C J2022-284
Steve Dennison, County Clerk
Commissioners' Journal 08/02/2022 10:25:35 AM
iFSCd'{ II'IIIIIII'IIIIIII�IIII�II) I'I�
2022-284
MONDAY July 11, 2022
FUR Kt(-UKUINU >IAlvlr UNLT
Barnes Sawyer Rooms
Live Streamed Video
Present were Commissioners Patti Adair, Anthony DeBone, and Phil Chang. Also present were Whitney
Hale, Deputy 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 Adair called the meeting to order at 1:00 p.m.
PLEDGE OF ALLEGIANCE
ACTION ITEMS:
CONVENE AS THE GOVERNING BODY OF 9-1-1 COUNTY SERVICE DISTRICT
1. Consideration of Board Signature of Document No. 2022-639, L3 Harris
proposal for Deschutes County's three additional radio sites
9-1-1 Operations Director Sara Crosswhite and 911 Technical Systems
Managerjonathan Spring presented the document for consideration for the
BOCC MEETING JULY 11, 2022 PAGE 1 OF 4
enhancement project to add hardware for three radio sites. The cost of the
project was included in the current budget.
DEBONE: Move approval of Document No. 2022-639
CHANG: Second
VOTE: DEBONE: Yes
CHANG: Yes
ADAIR: Chair votes yes. Motion Carried
2. Consideration of Board Signature of Document No. 2022-638, Statement
of work for RACOM site expansion
9-1-1 Operations Director Sara Crosswhite and 911 Technical Systems
Managerjonathan Spring presented the document for consideration of
project management/labor for the three additional radio sites.
CHANG: Move approval of Document No. 2022-638
DEBONE: Second
VOTE: CHANG: Yes
DEBONE: Yes
ADAIR: Chair votes yes. Motion Carried
RECONVENE AS THE GOVERNING BODY OF DESCHUTES COUNTY
3. Treasury and Finance Report for May 2022
Interim Finance Director Wayne Lowry presented the report including
investments and financials from the period ending May 31, 2022.
BOCC MEETING JULY 11, 2022 PAGE 2 OF 4
4. Envision Bend FY23 Special Funding Request: Follow-up
Administrative Analyst Laura Skundrick and Budget Manager Dan Emerson
presented a funding request of $50,000 from Envision Bend. Funding could
come from video lottery fund or general fund. Commissioner Chang is
supportive of the request. Envision Bend intends to request additional
funding from the City of Bend.
CHANG: Move allocation of $25,000 of video lottery funding for the
Envision Bend
ADAIR: Second
VOTE: CHANG: Yes
DEBONE: No
ADAIR: Chair votes yes. Motion Carried
Commissioner DeBone explained his vote is due to the project only focusing
on Bend and not representing Deschutes County as a whole.
5. FY2023 Q1 Discretionary Grant Review
Ms. Skundrick presented the first quarter discretionary grant applications.
The Board offered levels of support for each.
OTHER ITEMS:
• Commissioner DeBone reported on a few interviews on psilocybin and
clarified the discussion on Wednesday is regarding land use.
• Commissioner DeBone attended the La Pine Senior Center annual picnic on
ThursdayJuly 7.
• Commissioner Adair will attend the Fair Association meeting this evening.
• Commissioner Adair noted the Commissioner meeting on WednesdayJuly 13
will begin at 1:00 p.m.
BOCC MEETING JULY 11, 2022 PAGE 3 OF 4
EXECUTIVE SESSION: None Scheduled
ADJOURN
Being no further items to come before the Board, the meeting was adjourned at 2:19 p.m.
DATED this Day of 2022 for the Deschutes County Board of
Commissioners.
PATTI ADAIR, CHAIR
ANTHONYDEBONE,
WA' i �bgr
BOCC MEETING JULY 11, 2022 PAGE 4 OF 4
vT E S
BOARD OF
COMMISSIONERS
BOARD OF COUNTY COMMISSIONERS MEETING
1:00 PM, MONDAY, DULY 11, 2022
Barnes Sawyer Rooms - Deschutes Services Bldg - 1300 NW Wall St - Bend
(541) 388-6570 1 www.deschutes.org
AGENDA
MEETING FORMAT: The Oregon legislature passed House Bill (HB) 2560, which requires that
public meetings be accessible remotely, effective on January 1, 2022, with the exception of
executive sessions. Public bodies must provide the public an opportunity to access and attend
public meetings by phone, video, or other virtual means. Additionally, when in -person testimony,
either oral or written is allowed at the meeting, then testimony must also be allowed electronically
via, phone, video, email, or other electronic/virtual means.
Attendance/Participation options are described above. Members of the public may still view the
BOCC meetings/hearings in real time via the Public Meeting Portal at
www.deschutes.org/meetings
Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to
comment on any meeting topic that is not on the current agenda. Citizen Input is provided by
submitting an email to: citizeninput@deschutes.org or by leaving a voice message at 541-385-
1734. Citizen input received by noon on Tuesday will be included in the Citizen Input meeting
record for topics that are not included on the Wednesday agenda.
Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for
consideration or who are planning to testify in a scheduled public hearing may participate via
Zoom meeting. The Zoom meeting id and password will be included in either the public hearing
materials or through a meeting invite once your agenda item has been included on the
agenda. Upon entering the Zoom meeting, you will automatically be placed on hold and in the
waiting room. Once you are ready to present your agenda item, you will be unmuted and placed
in the spotlight for your presentation. If you are providing testimony during a hearing, you will be
placed in the waiting room until the time of testimony, staff will announce your name and unmute
your connection to be invited for testimony. Detailed instructions will be included in the public
hearing materials and will be announced at the outset of the public hearing.
For Public Hearings, the link to the Zoom meeting will be posted in the Public Hearing Notice as
well as posted on the Deschutes County website at https://www.deschutes.org/bcc/page/public-
hearing-notices.
CALL TO ORDER
PLEDGE OF ALLEGIANCE
ACTION ITEMS
1:00 PM Consideration of Board Signature of Document No. 2022-639, L3 Harris
proposal for Deschutes County's three additional radio sites
2. 1:20 PM Consideration of Board Signature of Document No. 2022-638, Statement of
Work for RACOM Site Expansion
3. 1:40 PM Treasury and Finance Report for May 2022
4. 2:00 PM Envision Bend FY23 Special Funding Request: Follow up
5. 2:20 PM FY 2023 Q1 Discretionary Grant Review
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.
ADJOURN
Deschutes County encourages persons with disabilities to participate in all programs
and activities. This event/location is accessible to people with disabilities. If you need
accommodations to make participation possible, please call (541) 617-4747.
July 11, 2022 BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 2
MEETING DATE: Monday, July 11, 2022
SUBJECT: Treasury and Finance Report for May 2022
ATTENDANCE:
Wayne Lowry, Interim Chief Financial Officer
MEMORANDUM
DATE: June 15, 2022
TO: Board of County Commissioners
FROM: Wayne Lowry, Interim Chief Financial Officer
SUBJECT: Treasury and Finance Report for May 2022
Following is the unaudited monthly finance report for fiscal year to date May 31, 2022.
Treasury and Investments
• The portfolio balance at the end of May was $271.7 million, an increase of —$2.6 million from April and an increase
of $16.5 million from last year (May 2021).
• Net investment income for the month is $123,819 approximately $3K less than last month and $57K less than May
2021. YTD earnings of $1,415,832 are $835K less than the YTD earnings last year.
• All portfolio category balances are within policy limits.
• The LGIP interest rate increased 35 basis points from 65 to 90 effective May 27, 2022. Benchmark returns for 24
month treasuries are up from the prior month by 9 basis points and 36 month treasuries are down from the prior
month by 16 basis points.
• Average portfolio yield is 0.57% which is slightly lower than the prior month's average of 0.58%.
• The portfolio's weighted average time to maturity is at 1.40 years compared to 1.48 in April.
Portfolio Breakdown: Par Value W investment T
Municipal Debt
$ 49,475,000
18.2%
Corporate Notes
58,102,000
21.4%
Time Certificates
1,245,000
0.5%
U.S_ Treasuries
17,000,000
6.3%
Federal Agencies
74,490,000
27.4%
LGIP
52,016,818
19.1%
First Interstate Bank
19,377,248
7.1%
Total Investments
$ 271,706,065
100.0%
Portfolio by broker
N $80
$71.8
e
$60
$53.6
$40
$24 8 $30.2
$20
$7.8
$12.2
$-
DA
Moreton Robert VV Piper
Great Castle Oak
Davidson
Capital Baird & Co Sandler
Pacific
Markets
Securities
May-22 Y-T-I)
Total Investment Income 128,819 1,470,832
Less Fee: $5,000 per month (5,000) (55,000)
Investment Income - Net 123,819 1,415,832
Prior Year Comparison May-21 180,943 2,251,098
Ca O MOXImums:
U.S. Treasuries
100%
LGIP ($52,713,000)
100%
Federal Agencies
100%
Bankers Acceptances
25%
Time Certificates
506
Municipal Debt
25°/n
Corporate Debt
25%
Mat
rity;Years
Max
4.46
Weighted Average
1.40
Yield Percenta . es
Current Month
Prior Month
FIB/ LGIP 0.90%
0.65%
Investments 0.47%
0.47%
Average 0.57%
0.57%
Benchmarks
24 Month Treasury 2.53%
LGIP Rate 0.90%
36 Month Treasury 2.71%
11 Term ,
Minimum
Actual
0 to 30 Days
10%
29.4%
Under 1 Year
25%
45.0%
Under 5 Years
100%
100.0%
Other ,.
policyActual
Corp Issuer
5% 3.3%
Callable
25% 18.8%
Credit W/A
AA2 AA1
lnvesbttent Activity
Purchases in Month $
Sales/Redemptions in Month $
Three Year Portfolio Balance
Five Year Maturity Distribution Schedule
Deschutes county Investments Pu7chases t11ad91Y1 May 242!
Porttello M... g.inent F cbhases:litade to May Yb,�'�
Portfe/lo D-11. - In-eh-nts
May 31, 2022
Purchase
Maturity Days
To Ratings
Coupon
Per
Market
Book
- 1
II0677 ,38I22NA44
_
_
Broke
Date
Ma[
�A&P/F' -'
Rate 2
YTM 36 -
Value
Value �0
Value 0
MUN
GOLDEN ST TOBACCO SECURD I.
GPAC
12/8/2021
611t/2022
O A.3tl
0.502
0.2
0
1,000 000
1,000,000
t,000,000
10887 FAC
3133ELE75
Federal Farm Credit Bank
CASTLE'
12/29/2021
6/2/2022
1 A-AA+
0.25
0.18238
1,505.000
1,504,977
1,505,003
10078 RRP
SYS10078
Local GOvt htvostment Pool
7/1/2006
- -
1
0.55
0.55
52,016,818
52,016,818
52,016,818
10084 RR2
SYS10064
First Interstate
7/1/2006
- -
t
0.55
0.55
19.377,248
19.377.248
19.377,248
10888 FAC
3133ELN26
Federal Fan, Credit Bank
CASTLE
12/29/2021
6/22/2022
21 Aaa
AA,
0.26
OTS21
630.000
629,845
630,029
10889 TRC
912828XW5
U.S. Troasury
GPAC
12/30/2021
6/30/2022
29 Aaa
I.75
0.17
3.000,000
3,002.037
3,003.791
10652 MUN
686053BQ1
Oregon School Boards Assoc
MORE TN
9/14/2018
6/30/2022
29 Aa2
AA
5.48
3,12
925.000
927,923
926.645
10885 MUN
8013151FU4
SANTA BARBARA CA UNIF SCH CGPAC
12/23/2021
6/30/2022
29
AA
0.26
0.2015796
1,500,000
1.498,710
1,500,058
10881 AM
892331AG16
TOYOTA MOTOR CREDIT
DA DAV
12/9/2021
7/1/2022
30 P-1
A-1
0.28
0
2,000.000
1.9.7,963
1,999,533
10833 MUN
757889BRO
REDWOOD CITY CA SCH DIST
DA DAV
2/24/2021
8/1/2022
61
AA
5
0.8062226
125,000
125,798
125,087
10748 FAC
3133EKJ56
Federal Fan, Credit Bank
CASTLE
1/31/2020
8/30/2022
90 Aaa
AA+
1.15
0.4505989
3.000.000
3,002,387
3,001.243
10890 TRC
912828L24
U.S. Treasury
GPAG
12/30/2021
8/31/2022
91 A1.875
0.2
3.000,000
3,005.226
3,012.456
10883 FAG
313363WD9
Fetleral Home Loan Bank
GPAC
12/13/2021
9/9/2022
100 Aaa
AA,
3.125
0,1900014
1.645,000
1,653.787
1.658,127
I0891 TRC
912828L57
U.S. Treasury
GPAC
12/30/2021
9/30/2022
121 Aaa
1.75
0.23
3,000,000
3,003,867
3,015,059
t 0882 FAC
3133EMDA7
Foderal Farm Credit Bank
GPAC
12/13/2021
10/13/2022
134 Aaa
AA,
0.16
0.2308967
1,140,000
1,134,423
1,139,704
10692 TRC
91282SYKO
U,S. Treasury
GPAC
2/7/2022
10/15/2022
136 Aaa
I.375
0.57
2,000,000
1,999,688
2,005,950
I0790 MUN
014365DQ0
ALDERWOOD WA WTR & WSTW
R W B
11/12/2020
12/1/2022
183 Aa2
AA,
1
0.5003903
200,000
1.0,246
200,496
10884 MCI
90520EAK7
MUFG Union Bank
CASTLE
12/14/2021
12/9/2022
191 A2
A
2.1
0,6120448
1,730.000
1.728,756
1,743,382
t 0879 MCI
90331HPF4
US Bank
CASTLE
12/10/2021
1/9/2023
222 At
AA-
1.95
0.6160653
2,279,000
2,273,371
2.297,317
10727 MCI
06051GEU9
Bank of America Gorp
CASTLE
11/25/2019
1/11/2023
224 A2
A-
3.3
2. 1200764
2,000,000
2,013,727
2.013,876
10854 MC
06051 GEU9
Bank of America Corp
PS
8/16/2021
1/11/2023
224 A2
A-
3.3
0.2702416
1,000,000
1, 006, 863
1.018,467
10813 MCI
740189AGO
Precision Castparts Corp
CASTLE
12/17/2020
1/15/2023
228 A2
AA-
2.5
0.5547661
2,772,000
2,774.044
2,805,311
10878 FAC
3135GOT94
Federal National Mtg Assn
R W B
12/9/2021
I/I9/2023
232 Aaa
AA,
2.375
0.3868429
1.000,000
1,003.544
1,012.551
10869 FAG
3133ENDQO
Fetloral Farm Credit Sank
GPAC
11/18/2021
2/10/2023
254 Aaa
AA,
0,16
0.29
2,000,000
1,978.798
1,998.206
10893 TRC
91282CBNO
U.S. Treasury
GPAC
2/7/2022
2/28/2023
272 Aaa
O.I25
0.85
2,000,000
t,9]3,438
1, 265
10857 MUN
55877oDT7
CITY OF MADRAS OR
DA DAV
10/12/2021
WI/2023
273
AA
0.451
0.4510338
210.000
207,278
210,000
210,000
10880 MCi
78015K7G3
Royal Bank of Canada
PS
12/10/2021
4/17/2023
320 A2
A
1.6
0.640545
2,000.000
1,985,240
2,016,741
10859 MCI
466251-IRLG
JPMorgan Chase - Corporate N
CASTLE
10/29/2021
5/18/2023
351 A2
A-
2.7
0.7306116
2.000.000
2,003096
2,037,680
10867 FAC
3133ENEW6
FeeraI Farm Credit Bank
d
GPAC
11/23/2021
6/23/2023
356
0.375
0.3708179
2,000,000
1'9135:374
2.000,000
10666 TRC
.1282CC DI
U.S. Treasury
MORE TN
1I/17/2021
5/31/2023
364
0, 125
0.3701352
2,000,000
11960,546
1.995,125
10835 MUN
010831 DOG
ALAMEDA CNTY CA JT PWRS AUCASTLE
2/24/2021
6/1/2023
365 A,l
AA,
3.095
03959011
3,080,000
,3,105,287
3,165, 501
10838 MUN
73473RDW2
MORROW PORT TRANS FAC
R W 8
4/1/2021
6/I/2023
365
A-
0.7
0:7000625
215.000
210.988
215,000
10760 MUN
736746XU7
PORTLAND OR URBAN RENEWAL
PS
7/14/2020
6/16/2023
379 Aa1
4.023
2.895
830, 000
830.656
839,264
10839 MUN
984674JZ5
MCMINNVILLE SCHOOL DIST YANPS
6/15/2021
6/15/2023
379 Aa1
0.28
0.28
170:000
166,479
170,000
10709 MUN
292]OC NU5
Bonneville Po Adr,mistratio
CASTLE
7/30/2019
7/1/2023
395 Aa2
AA-
5.803
2.1249156
1,000,000
1, 035,410
I, 028.566
10713 MCI
361582AD1
Berkshire Hathaway Inc
CASTLE
9/9/2019
7/15/2023
409 Aa3
AA
].35
2.0306495
500,000
524,519
528,566
10868 FAC
3133ENEY2
Federal Farm Credit Bank
GPAC
11/24/2021
7/24/2023
418
0.45
0.4500338
2.000.000
t,'62.424
2,000,000
10832 MCI
06053FAA7
Bank of America Gorp
DA DAV
2/23/2021
7/24/2023
418 A2
A-
4.1
0.2302692
1.000,000
1.020,432
1.044,245
10769 FAG
3137EAEV7
Fedora) Home Lean Mig Corp
CASTLE
8/21/2020
6/24/2023
449 Aaa
AA*
0.25
0.2840745
5.000,000
4, 881.329
4.997,914
10768 MUN
67232TBM6
OAKLAND CA REDEV SUCCE-SSC PS
8/21/2020
9/1/2023
457
AA-
3.t25
0.6015189
2,500,000
2,605550
2.578,028
10843 MUN
09, 19MM3
BONNEVILLE & BINGHAM CNTYS
PS
7/28/2021
9/15/2023
471 Aaa
4
0.4307542
1.000,000
1,015:980
1,045.747
10780 MUN
47-53GRO
JEROME IDAHO SCHOOL DIS'1'RRPS
10/13/2020
9/15/2023
471 Aaa
5
0.4793681
200.000
206.090
211,559
10819 MCI
3133EMI-EO
Fetleral Fan, Credit Bank
PS
12/30/2020
9/22/2023
478 Aaa
AA+
0.19
0.1900035
2,o0O,000
1.145,909
2,000, OOO
10860 TRC
91282CDA6
U.S. Treasury
MORETN
11/1/2021
9/30/2023
486
0.25
0.4554048
2,000,000
1,947,968
1,994,560
10794 FAC
3137 EAEZ8
Foderal Homo Loan Mtg Corp
CASTLE
11/5/2020
1 t/6/2023
523
AA+
0.25
0.2801193
6,000.000
4.853,573
4,997,856
10802 MCI
459058JM6
Intornalional Bonds for R...-
CASTLE
11/24/2020
11/24/2023
541 Aaa
AAA
0.25
0.3204397
2,000,000
1.936, 320
1,997,878
10789 MUN
014365DR8
ALDERWOOD WA WTR & WSTW
R W e
1I/1212020
12/1/2023
546 Aa2
AA.
1
0.56 114
270,000
266:82
2']t,804
10837 MUN
73473RDH5
MORROW PORT TRANS FAC
R W B
4/1/2021
12/1/2023
548
A-
0.7
0,7000516
1,000,000
968,320
1.000,000
10836 MCI
31422XBV3
Fed cral Agriculture ML9 Corp
GPAC
3/16/2021
12/15/2023
562
0,22
0.2148764
2,000, 000
1, 936, 022
2.000,000
10923 MCI
0605IGFB0
Bank of Amorica Corp
CASTLE
1/12/2021
1/22/2024
600 A2
A-
4.125
0.5217482
2:000:000
2:037,553
2,1 t7,224
10873 MCI
46625HJTB
JPMorg.,, Chase - Corporato N
CASTLE
12/2/2021
2/1/2024
610 A2
A-
3.875
0.9289607
1,000,000
1,016,067
1, 048, 491
10872 FAC
3135GOV34
Fortes) National Mtg Assn
GPAC
12/1/2021
2/5/2024
6I4 Aaa
AA +
2.5
0.5902165
2,000,000
1.998.7.0
2,063.574
10862 MCi
037833CG3
Apple Inc
GPAC
11/17/2021
2/9/2024
618 A.1
AA,
3
0.9122019
2,000,000
2,016.690
2,069.-0
10861 FAG
3130APUV5
Foderal Home Loan Bank
DA DAV
11/23/2021
2/23/2024
632 Aaa
AA,
0,65
0:6500583
1,670,000
1,625,349
1,670, 000
10634 MCI
3133Elvl 7
Federal Farm Credit Bank
CASTLE
2/26/2021
2/26/2024
635 Aaa
AA-
0.25
0.2620651
2.000.000
t,926,564
1,
10851 MCI
06051 GFFI
8 nnk of Amorica Corp
CASTLE
W121021
4/1/2024
6']0 A2
A-
4
0.6062599
2,000.000
2,.39, 702
123,293
2,123,293
10829 MUN
68607VP3
Oregon Stale Lottery
PS
1/2.2021
4/1/2024
670 Aa2
AAA
2.505
0.3901753
2,350.000
2,33i,764
2,440,459
10874 MUN
68609TWOS
0rc Sint, Lottery
R W B
12/2/2021
5/1/2024
700 Aa1
AA,
0.795
0.7300606
500,000
482'895
500,615
10864 MCI
46625HJX9
JPMorg,,, Chase- Corp orato N
CASTLE
11/18/2021
5/13/2024
712 A2
A-
3.625
0.9770205
1,500,000
1,518,160
1.576,335
10846 MCI
06051 GJY6
Bank of America Corp
CASTLE
7/27/2021
6/14/2024
744 A2
A-
0.523
0,5210523
1.000,000
971.314
1,000.039
10777 MUN
179093KQI
CLACKAMAS SCHOOL DISTRICT
PS
10/1/2020
6/15/2024
745 A
0.613
0,6130311
500,000
477.675
500,000
10807 MUN
179198J F4
CLACKAMAS SCHOOL DISTRICT
DA DAV
12/3/2020
6/16/2024
745 Aa1
0..3
0.480219
300,000
288,000
302,119
10815 MUN
625617MG9
MULTNOMAH COUNTY OR SCITOC R W B
12/30/2020
6/15/2024
745 Aa1
AA+
2
OA052718
2,750,000
2,694, 643
2, 838, 992
I0809 MUN
]36688MD1
Portland Community College
PS
12/17/2020
6/15/2024
745 Aat
0.572
0.5720012
t,000,000
957,600
I,000,000
10776 MUN
568571CZ4
SILVER FALLS SD
PS
9/17/2020
6/15/2024
745 Aat
0.55
0,6500254
1,900,000
1,813,550
1,900,000
10779 MUN
906429EE1
UNION CTY OR SCHOOL DISTRIG
PS
IOIW2020
6/15/2024
745 Aat
0.675
0.6750364
490,000
468,906
490,000
10785 MUN
939307KV5
Washington County SD Municipal
PS
10/28/2020
6/15/2024
745 Aa,
0,59
0.5840838
1,500,000
1.432,.20
1,500,000
10771 MCI
68583RCT]
OR ST GOMMUNITY COLLEGE DI:
R W B
6/27/2020
6/30/2024
760 Aa1
A
5.66
0,6000375
90.000
04, 696
99.352
10853 MUN
68583RCY6
OR ST COMMUNITY COLLEGE DI:
PS
8/31/2021
6/30/2024
760
AA
0.583
0.5830334
t,000,000
949.760
TO 0.000
10782 MUN
584288ER1
MEDFORD OR REVENUE
R W B
10/14/2020
7/16/2024
775
AA-
2
0.6503538
815,000
80t, 031
838,026
10-2 FAC
3133EMi51
Fetloral Farm Credit Bank
R W B
7/19/2021
7/19/2024
779 Aaa
AA+
0.42
0,4283959
1,000,090
954.381
999,822
10848 BCD
795451AAt
SALLIE MAE
GPAC
7/21/2021
7 22/2024
782
0.55
0.66
249.000
236,497
249,000
10828 MCI
3133EMNK4
Federal Farm Credit Bank
DA DAV
1/22/2021
7/22/2024
782 Aaa
AA,
0.31
0.31
2,000,000
1,908:368
2,000.000
10847 BCD
38149MXG3
GOLOMAN SACHS
GPAC
7/28/2021
7/29/2024
789
0.55
0.55
249,OOO
236.894
249,000
10844 BCD
05580A678
BMW
GPAC
7/30/2021
7/30/2024
7.0
0.56
0.55
249,000
236,876
249,000
10856 M01
91159HHXt
US Bank
PS
10/29/2021
7/30/2024
790 A2
A+
2.4
0.8420282
2,000,000
1,976.407
2,066, 602
10805 MUN
66609TZR2
Oregon State Lottery
R W B
12/1/2020
8/1/2024
792 Aa1
AA+
0.638
0.4148774
505.000
483,159
507:420
10811 MUN
68608USW7
Oregon Stale Lottery
R W B
12/117/2020
8/1/2024
792 Ant
AA+
2.677
0.9386601
755,000
754,479
782.891
10812 MUN
68608USD9
Oregon State Lottery
R W B
12/17/2020
8/1/2024
792 Aa1
AA+
2.677
0.9386585
500,000
502,305
516.471
10784 MUN
732098P -2
POMONA CALI UNI SCH DIST TAX PS
10/20/2020
8/1/2024
792 A.3
0.77
0.6001765
1,200.000
1,146,048
1,204,360
10786 MUN
835569GR9
SONOMA COD
PS
10/21/2020
8/1/2024
792 Aa2
AA
2.061
0.600206
1,200.000
1,179,036
1, 237,4.5
10849 BCD
89235MLF6
TOY TA FINANCIAL SGS BANK
GPAC
8/5/2021
8/5/2024
796
0.55
0.55
249,000
236,769
249,000
10850 NCB
90348J R85
UBS BANK USA
GPAC
8/11/2021
8/12/2024
803
0.55
0.536254
24.'000
236,587
249,000
10816 MCI
3023I GBG5
XTO Energy Inc
GPAC
12/2t 12020
8/16/2024
807 Ant
AA
2,01.
0.5432498
2,000,000
1,969,932
2,064,446
10810 MUN
73474TAB6
MORROW PORT TRANS FAC
R W B
12/14/2020
9/1/2024
823 Aa2
3.221
0.4201896
1.750, 000
1, 756,843
I,859,308
10775 FAC
3134 GW F84
Federal Homo Loan MLg Corp
CASTLE
9/9/2020
9/9/2024
831 Aaa
0.48
0,48
1,000,000
95t,551
1,000,000
10830 MCI
22546QAP2
CREDIT SUISSE NY
CASTLE
2/1/2021
9/9/2024
831 Aa3
3.625
0.57179
2,950,000
2,944.063
3,152.269
10776 MUN
4511527CO
IDAHO ST BOND BANK AUTH REV
PS
10/8/2020
9/15/2024
837 Aa1
5
0.6103486
1,000,000
1,048,420
1,099,130
10781 MUN
476453GS8
JEROME IDAHO SCHOOL DISTRKPS
10/13/2020
9/15/2024
837 Aaa
5
0.7253469
220,000
229,445
241,185
10808 MUN
13034AL57
CALIFORNIA NFRASTRUC'H RE
BGPAC
12/17/2020
10/1/2024
853
AAA
0.645
0.6450337
I, 000,000
947,250
1,.00,000
10783 FAC
3133EMCM
Federal Farm Credit Bank
CASTLE
10/16/2020
10/15/2024
867 Aaa
AA,
0.4
0.4401721
2.000.000
1,894,160
1,998, 113
10791 FAC
U,,GW3W4Fetloral
Home Loan Mig Corp
CASTLE
10/30/2020
10/28/2024
880 Aaa
0.41
0A163167
2,000,000
1.892,949
1:999,699
10797 MCI
822582CC4
ROYAL DUTCH SHELL PLC
GPAG
11/13/2020
11/7/2024
890 Aa2
AA-
2
0.7055457
3:000:000
2,946,808
3,093,017
10823 MCI
822582CC4
ROYAL DUTCH SHELL PLC
CASTLE
1/7/2021
t1/7/2024
890 Aa2
AA-
2
0.542930t
1,708,000
1,677,716
1,767, 848
107.9 FAC
3134GW 7F7
Federal Home Loan MEG Corp
CASTLE
11/18/2020
11/18/2024
901 Aaa
0.375
0,375
2.000.000
1,891,877
2,000.000
10788 MUN
014365 DS6
ALDERWOOD WA WTR & WS UN R W B
11/12/2020
12/1/2024
914 Aa2
AA,
1
0.0501532
935,000
893,280
-3,057
10814 MCI
931142DV2
WALMART
GPAC
12/17/2020
12/15/2024
928 Aa2
AA
2,65
0.570465
2,000,000
1,997, 507
2.104,252
10820 MCI
3133E MLP5
Federal Farm Credit Bank
PS
12/30/2020
12/23/2024
936 Aaa
AA+
0.32
0.31.9988
2.000,000
1,875,98
2,000,001
10806 MCI
037833DF4
Apple Inc
GPAG
12/3/2020
1/13/2025
957 Aa1
AA,
2.75
0.63892.2
2.000,000
1,995,283
2,108,865
10821 MCI
3134GXKK9
Fetloral Home Loan Mig Corp
R W B
1/15/2021
1/15/2025
959 Aaa
0.35
0
2.000,000
I, 881, 733
2,000,000
10817 MCI
46625HKC3
JPMorgan Chase- Corporate N
CASTLE
12/22/2020
1/23/2025
967 A2
A-
3.I 25
0.8061136
2,000,000
1,998.079
2,I20,401
10826 MCI
466'25HKC3
JPMorgan Chaso - Corporate N
CASTLE
1/11/2021
1/23/2025
967 A2
A-
3.125
0.82]2497
2,000,000
I,998,079
2,119.275
10792 FAC
3134GW5Q5
Federal Home Lean Mtg Corp
CASTLE
10/30/2020
1/29/2025
973 Aaa
0.45
0.4523943
2,500,000
2,353,364
2,499,843
10762 FAC
3136G4E74
Fetleral National Mtg Assn
CASTLE
]/3I/2020
t/29/2025
973 Aaa
AA+
0.57
0,569999
1, 400,000
1, 322, 307
1,400,000
10822 MCI
12672QAG0
CME GROUP
GPAC
1/4/2021
W15/2025
1018 Aa3
AA-
3
0.6490818
2,000,000
1,993,814
2,129,145
10801 MCI
3023IGBH4
XTO Energy Inc
GPAC
11/19/2020
3/19/2025
1022 Aa1
AA
2.992
0.813]84
2,000,000
I,999:004
2:119,607
10800 MUN
98459LAA1
YALE UNIVERSITY
GPAC
11/18/2020
4/15/2025
1049 A AAA
0.873
0.5784436
2,000,000
11885672
2016,682
IOSIS MCI
166]64BW9
Chevron Corp
GPAC
t2/28/2020
5/11/2025
I075 Aa2
AA
t.554
0.64762
1,663,000
t,600,04.
1,701,111
10824 MCI
I66764BW9
Chevron Gorp
CASTLE
1/7/2021
5/I I/2025
1075 Aa2
AA
1.554
0.6175284
2,000,000
1,924,292
2,054,328
10825 MUN
625506PX2
MULTNOMAH CO-REF-TXBL
GPAC
1/21/2021
6/t/2025
1096 Aaa
AAA
1
0.5000954
2,165,000
2,054,693
2,I97,080
10840 MUN
498368EBI
KLAMATH CNTY OR SCH DIST
PS
711 /2021
6/15/2025
I1I0
AA,
0.86
0.8600I 91
400,000
375,920
400,000
10798 MUN
938429V61
Washington County SD Municipal
PS
11/17/2020
6/15/2025
1110 A.
0.912
0.6448704
350,000
328,969
352,795
1084I MUN
625517NE3
MULTNOMAH COUNTY OR SCHOC CASTLE
7/15/2021
6/30/2025
1125 Aa2
AA
0.95
0.6870868
1.255,000
1.168,267
1.265, 01I
10831 MUN
7990550U5
SAN MATEO CA FOSTER CITY SC
DA DAV
2/16/2021
8/1/2025
1157 Aaa
AA+
I.597
0.4700929
500,000
479,585
517,636
10787 MUN
88675A5 S4
TIGARD OR WTR SYS REVENUE
PS
11/3/2020
8/1/2025
1157 Aa3
AA
2
0.8504149
350.000
335,839
362,463
10763 FAC
3133EL3P7
Federal Fan, Credit Bank
R W B
8/12/2020
8/12/2025
1168 Aaa
AA,
0.53
0.53
3,000,000
2787,569
3,000,000
10764 FAC
,,EIEL3H5
Fetloral Farm Credit Bank
MORETN
8/12/2020
8/12/2025
1168 A-AA+
0.57
0.57
t'000,000
2:788.615
3,000,000
10766 FAC
3134 GW ND4 Federal Home Loan Mtg Corp
CASTLE
8/141 020
8/12/2025
1166 A-0.6
0.6101786
2,000,000
1,870,142
1,999,360
10767 FAC
3136G4 L84
Federal National Mtg Assn
CASTLE
8/18/2020
8/18/2025
1174 All
AA-
0.57
0.5901227
2,000.000
1,866,039
1,998,727
10765 FAC
3136G4N74
Fetloral National Mig Assn
MORETN
8/21/2020
8121,12025
1177 Aaa
AA.
0.56
0.56
3,000,000
2.797,632
3,000:000
10772 FAC
3t 36G4 N74
Fedora) National Mig Assn
R W B
6/271 020
8/2 t/2025
1177 Aaa
AA +
0.56
0,5650922
1,000.000
932,56I
999,838
10774 FAC
3136G4 N74
Federal National Mid Assn
R W B
9/3/2020
8/21/2025
1177 Aaa
AA+
0.56
0.5599961
2.000.000
1,865, 121
2,000,000
10770 FAC
3136G4 X24
Federal National Mtg Assn
PS
8/28/2020
8/29/2025
1185 Aaa
AA+
0.6
0.6000006
1,000.000
933,243
1.000,000
10773 FAC
3136G4X24
Fed oral National Mtg Assn
CASTLE
8/28/2020
8/29/2025
1185 Aaa
AA,
0,6
0.6000006
1.000.000
133,243
1,000.000
t 0793 FAG
3135GA2N0
Fetloral National Mtg Assn
RW B
11/4/2020
1t/4/2025
I252 Aaa
AA,
0.55
0.55
2,000,009
1,854,571
2,000,000
10796 FAC
3135.06G3
Federal National Mtg Assn
CASTLE
11/12/2020
11/7/2025
1255 Aaa
AA,
0.5
0.5729346
2.000,000
1, 851,201
1,995,070
1087I MUN
250325UL9
DESCHUTES CTY SCH DIST ff1
R W B
12/7/2021
6/15/2026
1475 Aat
1.4
1.2301048
2,000,000
1,877,140
2,013.307
10870 MUN
669280EX4
Solom-Keizer School District
PS
12/7/2021
6/15/2026
1475 Aa1
t.438
1.2900016
2, 000,000
1, 870.560
2,01I 576
10845 MUN
73668OMFO
Portland Community College
MORETN
7/23/2021
6/16/2026
1475 Aa1
0."'
0.8000224
1:250,000
1,147.788
1,254,889
10875 MUN
68587FAW4
OR EDU GISTS FF&C PENSION
O R W B
12/8/2021
6/30/2026
1490 Aaa
AA
1.104
1.3861517
250,000
227,776
247.220
10863 MUN
68583RCV2
OR ST COMMUNITY COLLEGE DI:
GPAC
11/18/2021
6/30/2026
1490 AaI
AA,
5.68
1.4000014
210,000
226, 340
245,303
10865 MCI
037833DN7
Applo Inc
GPAC
11/18/2021
9/11/2026
1563 Aa1
AA+
2.05
1,4551529
2, 000,000
1.915:766
2'048.964
I0876 MUN
6860]DVC6
ODOT HWY USER TAX REV
R W B
I2/8/2021
11/15/2026
1628 AIT
AAA
0.934
1.3661066
260,000
232,383
255,175
Position Control Summary
Org
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
April
May
Assessor
Filled
33.26
33.26
33.26
33.26
33.26
33.26
33.26
32.63
33.00
33.00
32.00
Unfilled
2.00
2.00
2.00
2.00
2.00
2.00
+ 2,00
2.63'
2.26
2.26
3.26
Clerk
Filled
8.58
8.48
8,48
9.48
9.48
9.48
10.48
' 9.48
10.48
10.48
9.48
Unfilled
0,90
100
1.00
-
-
1.00
1.00
BOPTA
Filled
0.42
0.52
0.52
0.52
0.52
0,52
0.52
0.52
0.52
0.52
0.52
Unfilled
0,10
-
-
DA
Filled
51.70
5450
S6.50
55.50
55.60
54.60
; 56.60
55.60
55.40
56.40
56.40
Unfilled
6.30
3.50
1.50
2.50
1.50
2,50
! 1,00
2.90
3.20
2.20
2.20 i
Tax
Filled
5.50
550
5.50
5.50
5.50
5.50
! 5.50
5.50
5.50
5.50
5.50'
Unfilled
-
Veterans'
filled
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
Unfilled '
-
-
Property Mngt
Filled
2.00
200
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
Unfilled
-
-
Total General Fund
'filled
106.46
109.26
111.26
111.26
111.36
110.36
113.36
: 110.73'
111.90
112,90
110.90 '
Unfilled
9.30
6.50
4.50
4.50
3.50
4.50
:` 3.00
6.53
5.46
4.`46
6.46:
Justice Court
Filled
4.60
4.60
4.60
4.60
4.60
4.60
4.60 <
4.60
4.60
4.60
4.60
Unfilled
-
-
-
Community Justice
Filled
45.90
45.90
45.90
44.90
44.90
44.90
44.90
42.90
41.90
41.90
43.20
Unfilled
2.00
2.00
2.00
3.00
3.00
3.00
3.00
5.00
6.00
6.00
4.70
Sheriff
Filled
229.75
235.75
232.75
238.75
235.25
234.25
232.25
221.25'
231.75
231.75
230.75'
Unfilled
27.25
2125
24.25
18.25
21.75
24.75
26.75
37.75
27.25
27.25
28,25
Health Srvcs
Filled
320.33
319.85
320.40
331.20
331.50
339.50
344.20
344.30
344.80
351.50
349.85
Unfilled
55.47
57.95
64.90
54.50
55.20
50.30
46.10
53.00
53.50
47.80
49.45
CDD
filled
61.00
61.00
56.80
56.80
58.80
58.80
57.80
59.80
61.80
61.80
59.80
Unfilled
4,00
6100
11.20
11.20
9.20
9.20
11.20
9.20
8.20
&20
10.20
Road
Filled
57,00
57.00
57.00
56.00
56.00
56.00
56.00
57.00
57.00
57.00
57.00
Unfilled
-
-
-
1.00
1.00
1.00
1.00
-
-
-
-
Adult P&P':
Filled
37.60
37.60
37.60
36.85
36.85
35.85
36.85 `
36.85'
36.85
37.85
37.55'
Unfilled
3.25
3.25
3.25
4.00
4.00
5.00
4.00
4.00:
4.00
3.00_
3.30
Solid Waste
Filled
23.00
24.00
24.00
27.00
26.00
26.00
26.00
26.00
26.00
26,00
26.00
Unfilled
2.00
4.00
4.00
1.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
Victims Assistance
Filled
8.00
8.00
8.00
8.00
8.00
7-00
8,00
8.00
8.00
&00
8.00 -
Unfilled
-
-
1,00
GIS Dedicated
Filled
2.30
2.30
2.30
2.30
2.30
2.30
2.30
2.30
2.30
2.30
2.30
Unfilled
-
-
-
-
-
-
-
-
-
-
-
Fair & Expo
filled
9,00
9.00
9.00
9.00
9.00
8.00
9.00
9.00
9,00
9.75
9.00'
Unfilled
3,50
3.50
3.50
3.50
3.50
4.50
3.50
3.50'
3.50
2.75
3.50
Natural Resource
Filled
2.00
2.00
2.00
2.00
2,00
2.00
2.00
2,00
2.00
2.00
1,00
Unfilled
-
-
-
-
-
-
-
-
-
-
1.00
ISF-Facilities
Filled
2160
19.60
21.60
21.60
20.60
21.60
20.60
20.75
21.75
21.75
21.75
Unfilled
2.40
3.40
2.40
2.40
3.40
2.40
3.40
3.25
3.25
3.25
3.25
ISF -Admin
Filled
7.75
7.75
6.75
8.75
7.75
7.75
7.75
8.35
8.35
8.35
8.35
Unfilled
1.00
1.00
2.00
1.00
2.00
2.00
2.00
1.40
1.40
1.40
1.40
ISF - BOCC':
Filled
3.00
100
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
Unfilled
-
-
-
-
-
-
-
-
ISF - Finance
Filled
9.00
9.00
9.00
8.00
10.00
10.00
10.00
10.00
9.00
7.00
8.00
Unfilled
2.00
2.00
2.00
3.00
1.00
-
-
-
1.00
3.00
3.00
ISF - Legal
Filled
7,00
7.00
7.00
6.00
6.00
6.00
6.00 >
6.00;
6.00
5.00
5.00
Unfilled
-
1.00
1.00
1.00
1.00
1,00
1.00
2.00
2,00
ISF - HR
Filled
8.00
8.00
8.00
8.00
8.00
8.00
8.00
9.00
9.00
9.00
9.00
Unfilled
1.00
1.00
1.00
1.00
1.00
1.00
1.00
-
-
ISF-IT
Filled
15.70
15.70
15.70
15.70
15.70
16.70
< 16.70
16.70/
16.70
16.70
16.70 P
Unfilled !
-
-
-
ISF - Risk
Filled
2.25
2.25
2.25
2.25
2.25
2.25
2.25
2.25
2.25
2.25
2.25
Unfilled
-
-
-
-
-
-
-
-
-
-
911
Filled
57.00
54.00
54.00
52.00
53.00
53.00
53.00
52.00'
5200
5000
51.00
Unfilled
3.00
6,00
6.00
8.00
7.00
7.00
7.00
! &00':
8.00
10.00
9.00
Total:
Filled
1,038.24
1,042.56
1,038.91
1,053.96
1,052.86
1,057.86
1,064.56
1,052.78
1,065.95
1,070.40
1,065.00
Unfilled
116.17
117.85
131.00
117.35
118.55
11&65
114.95
134.63
124.56
121.11
127.51
Unfilled
10.06%
10.16%
11.20%
10.02%
10.12%
10.08%
9,75%
11.34%
10.46%
10.16%
10.69%
Budget to Actuals Report
General Fund
Revenue YTD in the General Fund is $39.4 million or 96.6% of budget, a $1.2 million increase from the prior month. By
comparison, last year revenue YTD was $46.4 million and 123.8% of budget. This year's YTD revenue collections would
be greater except for one-time, unbudgeted CARES Act funds received last year in the General Fund.
Expenses YTD are $38.0 million and 87.8% of budget compared to $42.1 million and 105.8% of budget last year.
Overall expenses are lower this year and represent a smaller portion of the budget this year due to unbudgeted CARES
Act expenditures last year offset by an increase in the approved budget transfers this year which are made on a
regular monthly basis.
Beginning Fund Balance is $15M or 111.3% of the budgeted $13.51M beginning fund balance. Projected ending fund
balance is $13.OM, an increase of $400K from April.
County Wide Financial Dashboa
Fund
Select all
(Blank)
001 - General Fund
010 - A,_mt-Clerk...
020 - Code Abate...
030 - Community ...
040 - Court Techn..,
050 - Economic D...
060 - General Cou...
070 - General Cou..,
090 - Project Dev...
120 - Law Library
130 - Park Acquisi...
132 - Park Develo...
Monthly GL Per._ ,-
0
it
$11.0M
..:.ginP n:!J r,r_Y
(Blank)
All Maior Funds
001 - General Fund 91.7%
1 Year Complete
Budget to Actuals
Monthly Expenditures 105.8%
% of last year budget
ff
Ssra
Sold on 11
0 2 4 6 a to 12
*Last Year Actuals *Current Year Actuals
Monthly Revenues 123.8%
% of last vear budget
3NM
$()M
0 2 A 6 a 10 12
* Last Year Actuals *Current Year Actuals
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 May 31, 2022.
ESC,06" Budget to Actuals - Countywide Summary
All Departments 91 7%
FY22 YTD May 31, 2022 (unaudited)
Year Complete
Fiscal Year 2021
Fiscal Year 2022
RESOURCES
Budget
Actuals
%
Budget
Actuals
%
Projection
%
001 - General Fund
45,149,632
47,633,001
106% ;
40,504,168
39,122,997
97%
39,987,105
99% ;
030 - Juvenile
975,090
975,868
100% ;
901,143
761,237
84%
855,745
95% ;
160/170 - TRT
10,6695865
11,229,510
105% ;
11,659,435
12,249,314
105% ;
13,550,040
116% ;
200 - American Rescue
19,000,000
46,273
0%
19,000,000
19,251,687
101% ;
38,500,363
203% ;
Fund
220 - Justice Court
489,850
501,563
102% ;
550,832
455,965
83%
502,642
91% ;
255 - Sheriff's Office
43,449,298
44,938,851
103% ;
44,947,745
45,242,294
101% ;
45,453,053
101% ;
274 - Health Services
43,207,563
45,921,554
106% ;
48,727,400
42,848,711
88%
46,863,448
96% ;
295 - CDD
8,251,726
9,687,451
117% ;
9,580,316
9,522,997
99%
10,422,775
109% ;
325 - Road
20,681,110
23,538,925
114% ;
22,629,649
22,166,427
98%
24,513,655
108% ;
355 - Adult P&P
5,995,287
6,040,170
101% ;
5,840,250
6,125,810
105% ;
6,168,932
106% ;
465 - Road CIP
2,467,800
2,942,827
119% ;
2,471,190
1,112,938
45%
1,123,510
45% ;
610 - Solid Waste
12,077,592
13,463,285
111% ;
13,350,600
12,622,313
95%
14,000,331
105% ;
615 - Fair & Expo
1,466,050
1,791,835
122% ;
1,395,724
1,599,633
115% ;
1,714,307
123% ;
616 - Annual County Fair
52,000
53,038
102% ;
1,560,500
1,927,948
124% ;
19930,309
124% ;
617 - Fair & Expo Capital
14,000
8,532
61% ;
8,544
7,183
84% ;
7,490
88% ;
Reserve
618 - RV Park
436,050
654,204
150% ;
497,524
505,176
102% ;
602,188
121% ;
619 - RV Park Reserve
1,100
7,787
708% ;
7,546
5,793
77%
6,250
83% ;
670 - Risk Management
3,263,646
3,239,580
99%
3,146,973
49222,479
134% ;
4,367,100
139% ;
675 - Health Benefits
21,884,538
22,761,820
104% ;
23,027,177
22,893,040
99%
24,412,115
106% ;
705 - 911
11,064,698
12,080,426
109% ;
12,019,306
12,369,784
103% ;
12,501,569
104% ;
999 - Other
34,434,902
36,750,860
107% ;
50,071,869
31,190,409
62%
48,423,771
97% ;
TOTAL RESOURCES
285,031,797
284,267,359
100% ;
311,897,891
286,204,137
92%
335,906,699
108% ;
Fiscal Year 2021
Fiscal Year 2022
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
001 - General Fund
27,262,513
26,227,705
96%
21,094,809
17,719,341
84%
20,132,979
95% ;
030 - Juvenile
7,390,349
7,038,218
95%
7,496,355
6,071,073
81%
6,736,691
90% ;
160/170 - TRT
3,619,872
3,566,960
99%
3,358,388
3,266,729
97%
3,982,541
119% ;
200 - American Rescue
19,000,000
32,136
0%
38,000,000
11,613,375
31%
15,650,992
41% ;
Fund
220 - Justice Court
683,508
650,926
95%
701,142
634,678
91%
693,571
99% ;
'rEs`0 Budget to Actuals - Countywide Summary
All Departments
FY22 YTD May 31, 2022 (unaudited)
255 - Sheriff's Office
274 - Health Services
295 - CDD
325 - Road
355 - Adult P&P
465 - Road CIP
610 - Solid Waste
615 - Fair & Expo
616 - Annual County Fair
617 - Fair & Expo Capital
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
675 - Health Benefits
705 - 911
999 - Other
51,263,220
52,285,174
8,474,142
14,513,205
7,081,268
20,036,050
8,853,213
2,070,371
127,000
401,940
54,162,360
58,872,642
9,978,889
15,024,128
7,079,915
29,722,691
9,709,991
2,504,877
1,468,131
568,000
496,188
100,000
6,427,292
23,924,393
14,563,007
86,322,366
TOTAL REQUIREMENTS 322,815,803 255,839,328 79% 391,575,564 248,362,519 63% ;
543,902
100,000
3,794,344
23,620,173
12,576,839
59,118,720
49,625,248 97% ;
49,994,157 96% ;
8,086,137 95% ;
12,506,257 86% ;
6,365,601 90% ;
11,742,022 59% ;
8,107,298 92% ;
2,011,440 97% ;
189,611 149% ;
90,523 23% ;
5125967 94% ;
0%
2,391,380 63% ;
23,336,074 99% ;
10,534,248 84% ;
32,830,422 56% ;
46,230,185 85% ;
46,500,489 79% ;
8,174,596 82% ;
11,645,425 78% ;
5,731,855 81% ;
7,504,855 25% ;
7,533,330 78% ;
2,401,827 96% ;
1,334,830 91% ;
4,607 1 % ;
453,537 91% ;
- 0%
4,327,776 67% ;
22,433,198 94% ;
10,020,964 69% ;
34,759,850 40% ;
91.7%
Year Complete
52,822,795 98% ;
52,139,159 89% ;
9,151,472 92% ;
14,828,074 99% ;
6,427,753 91% ;
10,202,154 34%
8,829,880 91%
2,598,352 104%
1,348,960 92%
9,106 2%
490,250 99%
-
0%
4,901,274
76% ;
29,074,393
122% ;
11,637,498
80% ;
84,822,725
98% ;
336,480,620 86% ;
�'�ES� 2' Budget to Actuals - Countywide Summary
L� �G
All Departments
FY22 YTD May 31, 2022 (unaudited)
TRANSFERS
001 - General Fund
030 - Juvenile
160/170 - TRT
220 - Justice Court
255 - Sheriff's Office
274 - Health Services
295 - CDD
325 - Road
355 - Adult P&P
465 - Road CIP
610 - Solid Waste
615 - Fair & Expo
616 - Annual County Fair
617 - Fair & Expo Capital
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
705 - 911
999 - Other
TOTAL TRANSFERS
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals
%
Budget
Actuals
%
Projection
%
(20,308,890)
(19,944,234)
98%
(21,927,604)
(20,027,013)
91%
(21,847,604)
100% ;
5,957,854
5,957,854
100% ;
6,223,387
5,704,758
92%
6,223,387
100% ;
(5,278,036)
(4,963,905)
94%
(5,757,574)
(5,277,734)
92%
(5,986,414)
104% ;
107,235
111,521
104% ;
205,956
188,793
92%
205,956
100% ;
3,119,077
3,119,949
100% ;
3,500,737
3,186,756
91%
3,500,737
100% ;
8,026,313
6,945,413
87%
6,122,830
5,612,557
92%
6,122,830
100% ;
(55,480)
(1,104,998)
999% ;
(270,622)
(856,413)
316% ;
(991,854)
367% ;
(6,683,218)
(6,6835218)
100% ;
(11,757,547)
(6,985,536)
59%
; (11,757,547)
100% ;
187,496
187,496
100% ;
471,072
431,813
92%
471,072
100% ;
7,517,657
6,819,612
91%
12,1935917
4,772,011
39%
10,926,861
90% ;
(3,6845280)
(3,684,280)
100% ;
(6,029,323)
(4,521,793)
75%
(6,029,323)
100% ;
894,967
1,144,277
128% ;
800,736
746,497
93%
960,924
120% ;
75,000
75,000
100% ;
(75,000)
(81,250)
108% ;
(75,000)
100% ;
453,158
385,418
85%
728,901
668,151
92% ;
797,553
109% ;
(436,628)
(369,173)
85%
47,958
57,293
119% ;
47,958
100% ;
621,628
549,173
88%
132,042
121,033
92%
132,042
100% ;
(3,500)
(3,500)
100% ;
(3,500)
(3,201)
91%
(3,500)
100% ;
0%
9,078,924 11,341,195 125% ; 15,393,726 16,263,278 106% ;
(410,723) (116,400) 91
- 100% ;
17,301,922 112% ;
oy`,��3TESC,,0 Budget to Actuals - Countywide Summary
All Departments
FY22 YTD May 31, 2022 (unaudited)
ENDING FUND BALANCE
001 - General Fund
030 - Juvenile
160/170 - TRT
200 - American Rescue
Fund
220 - Justice Court
255 - Sheriff's Office
274 - Health Services
295 - CDD
325 - Road
355 - Adult P&P
465 - Road CIP
610 - Solid Waste
615 - Fair & Expo
616 - Annual County Fair
617 - Fair & Expo Capital
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
675 - Health Benefits
705 - 911
Q99 - Other
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals
%
Budget
Actuals
Projection
%
9,678,629
14,990,575
155% ;
10,952,375
16,367,219
12,997,097
119% ;
616,595
965,223
157% ;
596,681
1,360,145
1,307,664
219% ;
5,484,351
6,189,395
113% ;
8,433,816
9,894,247
9,770,480
116% ;
-
14,137
999% ;
-
7,652,449
22,863,508
999% ;
57,804
-
0%
55,646
10,080
15,027
27% ;
13,981,322
17,266,520
123% ;
12,160,633
19,465,385 ;
13,397,515
110% ;
5,727,266
10,689,975
187% ;
6,011,534
12,650,754
11,537,095
192% ;
734,798
1,749,673
238% ;
763,172
2,241,661
2,029,122
266% ;
2,180,473
8,566,521
393% ;
2,231,806
12,101,987
6,494,555
291% ;
1,816,329
2,982,055
164% ;
1,971,182
3,807,823
3,194,305
162% ;
13,103,814 23,533,004 180%
719,918 3,957,273 550%
655,550 923,473 141%
- (109,033)
1,208,442 1,029,596 85%
5,316,460
583,520
442,256
17,369
1,271,108
49,294
21,913,098
4,524,463
867,776
402,835
1,700,323
108,932
1,181,252
9,412,952
15,987,422
13,057,891
97,119,018
TOTAL FUND BALANCE 134,027,792 214,035,094 160% ; 135,756,248 251,827,713
43,512 - 0%
1,012,728 1,054,426 104%
6,465,802 9,521,450 147%
13,588,094 15, 527, 580 114%
6,829,277 10,709,072 157%
50 123 088 84 474 181 169%
824,054
5,045,296
13,875,402
9,307,082
55,847,562
25,381,221 477% ;
3,098,401 531% ;
1,000,352 226% ;
397,316 999% ;
1,825,534 144%
159,897 324% ;
1,192,718 145% ;
8,983,776 178% ;
10,865,302 78% ;
11,573,143 124% ;
58,966,600 106% ;
207,050,627 153% ;
-`, -[ESC,0G2< Budget to Actuals Report
General Fund - Fund 001
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Property Taxes - Current
Property Taxes - Prior
Other General Revenues
Assessor
Clerk
BOPTA
District Attorney
Tax Office
Veterans
Property Management
TOTALRESOURCES
REQUIREMENTS
Assessor
Clerk
BOPTA
District Attorney
Medical Examiner
Tax Office
Veterans
Property Management
Non -Departmental
TOTAL REQUIREMENTS
TRANSFERS
Transfers In
Transfers Out
TOTALTRANSFERS
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
30,105,307
30,896,789 103%
32,410,716
32,715,637
101%
32,738,055
101% :
327,339; A
358,000
683,563 191%
460,000
306,503
67%
315,075
68%
(144,925)
10,450,871
10,355,769 99%
2,689,926
2,690,272
100%
2,751,650
102%
61,724, B
1 836,713
1,291,220 154%
987,411
663,860
67%
903,977
92% a
(83,434); C
I
2,153,741
�
I
3,168,198 147%
2,741,215
2,087,482
I I
76%
2,241,215
I
82%
1
(500,000); D
1
12,220
I
19,236 157%
14,588
9,933
I I
68%
14,588
I
100%
-
1 467,138
426,613 91%
448,201
199,742
45% 1
364,924
81%
(83,277); E
I
1
419,927
1
510,878 122%
341,004
267,223
I I
78%
323,621
1
95%
(17,383);C
1 223,715
�
158,931 71%
259,107
136,514
53% 1
1
182,000
70%
(77,107); F
I
122,000
I
121,804 100%
152,000
45,833
1
30%
152,000
I
100%
G
45,149,632
47,633,001 106% ;
40,504,168
39,122,997
97% ;
39,987,105
99%
(517,063);
Budget Actuals % Budget Actuals %
5,237,507
4,897,531
94%
5,454,784
4,694,956
86%
2,051,015
1,882,622
92%
2,080,739
1,602,138
77%
1 79,945
76,042
95%
82,911
71,674
86%
8,234,075
8,157,354
99%
9,715,707
7,914,614
81%
1 236,358
220,618
93%
242,652
215,189
89%
1,016,608
989,386
97%
932,570
816,944
88%
1 687,678
610,692
89%
795,189
676,603
85%
1 332,533
312,615
94%
376,061
329,639
88%
1 9,386,794
9,080,846
97%
1,414,196
1,397,584
99%
27,262,513
26,227,705
96%
21,094,809
17,719,341
84% ;
Projection
%
$ Variance
5,197,307
�
95%
257,477- H
I
2,0289781
�
I
98%
I
51,958- H
1
82,911
�
100%
I
8,891,478
�
I
92%
824,229: H
242,652
�
I
100% o
I
932,570
�
I
100%
I
I
778,300
�
I
98%
16,889, H
378,980
I
101%
1
(2,919); 1
I I
1,600,000 113% 1
I
(185,804), J
20,132,979
95%
961,830:
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
260,000
260,000
100%
260,000
238,326
92%
260,000 100% - - K
(20,568,890)
(20,204,234)
98%
(22,187,604)
(20,265,339)
91%
(22,107,604) 100% 80,000: L
(20,308,890)
(19,944,234)
98% ;
(21,927,604)
(20,027,013)
91% ; ;
(21,847,604) 100% ; 80,000:
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance
I
12,100,400
13,529,514 112% 13,470,620
14,990,575
111% 14,990,575 111% 1,519,955.
Resources over Requirements
17,887,119
21,405,296
19,409,359
21,403,656
19,854,126 444,767-
Net Transfers - In (Out)
(20,308,890)
(19,944,234)
(21,927,604)
(20,027,013)
(21,847,604) 80,000�
TOTAL FUND BALANCE
$ 9,678,629
$ 14,990,575 155%
; $ 10,952,375
$ 16,367,219
149% ; $ 12,997,097 119% ; $2,044,722:
A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted
B PILT payment of $500,000 received in July 2021; Interest earnings expected to lower than budget; -$40K of Marijuana revenue from HB 3295 is
expected in this fiscal year
C Anticipated revenue for the Assessment and Taxation Grant expected to be lower than budget
D FY22 Recording Fees are trending less than budget
E Revenue projected to be lower than budgeted due to the reduction of two State Grants. Projection increased because Discovery Fees will be
allowed to be collected for the full fiscal year
F Oregon Dept. of Veteran's Affairs grant reimbursed quarterly
G Interfund land -sale management revenue recorded at year-end
H Projected Personnel savings based on YTD spending plus estimate for June
I Projected Personnel overage based on YTD spending plus estimate for June
J Various unbudgeted items will require a year-end budget adjustment
K Repayment to General Fund from Finance Reserves for ERP Implementation
L Current Planning will not require a transfer due to revenue collections coming in higher than anticipated and savings from unfilled positions; Victim's
Assistance will need an additional $20K in transfers
oy ,� o�1ES` 2' Budget to Actuals Report
c.G
.�, Juvenile - Fund 030
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
OYA Basic & Diversion
ODE Juvenile Crime Prev
Gen Fund -Crime Prevention
Leases
Inmate/Prisoner Housing
DOC Unif Crime Fee/HB2712
OJD Court Fac/Sec SB 1065
Interest on Investments
Food Subsidy
Contract Payments
Miscellaneous
Case Supervision Fee
TOTAL RESOURCES
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
472,401
497,387 105%
432,044
355,219
82%
402,044
93% _
(30,000); A
1
109,000
I
118,909 109%
100,517
85,796
1 1
85%
100,517
I
100%
1
89,500
89,500 100%
89,500
89,500
100%
89,500
100%
88,000
82,522 94%
88,000
81,819
93%
88,000
100%
90,000
64,350 72%
80,000
70,200
88%
81,000
101%
1,000.
49,339
49,339 100%
49,339
37,847
77%
49,339
100%
- B
26,000
�
13,503 52%
20,000
9,428
47%
1
12,000
60%
(8,000); C
17,300
1
13,796 80%
14,243
6,806
1
48%
6,990
1
49%
1
(7,253)�
I
12,000
�
1
13,028 109%
12,000
8,855
I I
74%
I
8,855
1
74%
I
(3,145); D
8,000
1
2,795 35%
8,000
8,557
I
107%
10,000
I
125%
1
2,000, E
7,550
�
28,312 375%
7,500
7,211
96%
7,500
100%
-
6,000
2,427 40%
-
-
-
975,090
975,868 100% ;
901,143
761,237
84%
855,745
95% ;
(45,398);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
5,970,797
5,762,391
97%
6,082,895
4,959,207
82%
5,453,754
90%
629,141. F
Materials and Services
1,372,016
1,233,835
90%
1,363,409
1,098,640
81%
1,260,711
92%
I
102,698: G
Capital Outlay
47,536
41,992
88%
50,051
13,226
26%
22,226
44%
27,825- H
TOTAL REQUIREMENTS
7,390,349
7,038,218
95%
7,496,355
6,071,073
81% ; ,
6,736,691
90%
759,664,
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers In- General Funds
6,034,966
6,034,966 100%
6,304,397
5,779,015
92%
6,304,397 100%
Transfers Out-Veh Reserve
1
(77,112)
i
(77,112) 100%
(81,010)
(74,258)
i
92%
i i
(81,010) 100%
TOTAL TRANSFERS
5,957,854
5,957,854 100% ;
6,223,387
5,704,758
92%
6,223,387 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
1
(6,415,259)
(6,062,350)
(6,595,212)
(5,309,836)
(5,880,946) 714,26&
1 1
Net Transfers - In (Out)
5,957,854
5,957,854
6,223,387
5,704,758
6,223,387
TOTAL FUND BALANCE
$ 616,595
$ 965,223 157% ;
$ 596,681
$ 1,360,145 228% ;
$ 1,307,664 219% ; $710,983,
A Quarterly reimbursement of biennial award based on actuals
B Quarterly payment from Department of Corrections
C Projected lower revenue due to less than budgeted state court fee program revenue
D Dept. of Education subsidies for detention meals lower due to smaller population than projected at time of budgeting
E Projected higher revenue due to more than budgeted community service fee -for -service projects
F Projected Personnel savings based on YTD spending plus estimate for June
G Projected underspending based on FY22 trends
H Security Detention upgrade delayed - some costs will be moved into FY23; fence project will be completed in FY22
� ooy 3'(ES` G z'� Budget to Actuals Report
L
TRT - Fund 160/170
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
RESOURCES
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Room Taxes
10,615,965
11,068,364
104%
11,600,987
12,201,927
105%
13,500,000 116%
1,899,013- A
Interest
539900
61,146
113%
58,448
47,387
81%
50,040 86%
(8,408)'
State Miscellaneous
-
100,000
-
-
-
-
TOTAL RESOURCES
10,669,865
11,229,510 105% ;
11,659,435
12,249,314
105% ; ;
13,550,040 116% ;
1,890,605:
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
COVA
3,038,805
2,998,091
99%
3,136,659
3,044,792
97%
3,660,487 117%
(523,828); B
Interfund Contract
114,481
114,481
100%
121,817
111,666
92%
121,817 100% e
C
Software
11,500
-
0%
45,000
64,758
144%
66,200 147%
(21,200); D
Interfund Charges
35,861
35,861
100%
39,709
36,400
92%
39,709 100%
Administrative
15,225
4,526
30%
15,203
9,114
60%
94,328 620% _
(79,125); E
Grants & Contributions
404,000
414,000
102% -
-
-
-
TOTAL REQUIREMENTS
3,619,872
3,566,960
99% ;
3,358,388
3,266,729
97%
3,982,541 119% ;
(624,153);
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Transfer Out - RV Park
(20,000)
(20,000)
100%
(20,000)
(18,326)
92%
(20,000)
100%
-
Transfer Out - Annual Fair
(75,000)
(75,000)
100%
(75,000)
(68,750)
92%
(75,000)
100%
-
Transfer Out - Justice Court
-
-
(205,956)
(188,793)
92%
(205,956)
100%
F
Transfer Out - F&E Reserve
(453,158)
(385,418)
85%
(428,901)
(393,151)
92%
(497,553)
116%
(68,652); G
Transfer Out - Health
(406,646)
(406,646)
100%
(444,417)
(407,374)
92%
(444,417)
100%
-
Transfer Out - F&E
(1,171,445)
(925,054)
79%
(931,513)
(853,875)
92%
(1,091,701)
117%
(160,188)
Transfer Out - Sheriff
(3,151,787)
(3,151,787)
100%
(3,651,787)
(3,347,465)
92%
(3,651,787)
100%
-�
TOTAL TRANSFERS
(5,278,036)
(4,963,905)
94%
(5,757,574)
(5,277,734)
92%
(5,986,414)
104% ;
(228,840);
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%
69189,395 105%
299,052,
Resources over Requirements
7,049,993
7,662,551
8,301,047
8,982,586
9,567,499
1,266,452!
Net Transfers - In (Out)
(5,278,036)
(4,963,905) ;
(5,757,574)
(5,277,734)
(5,986,414)
(228,840)!
TOTAL FUND BALANCE .
$ 5,484,351
$ 6,189,395 113% ;
$ 8,433,816
$ 9,894,247 117% ;
$ 9,770,480 116% ; $1,336,664:
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 A year-end budget adjustment will be required for MuniRevs software costs that exceeded budget
E At year-end there will be a budget adjustment to reimburse the Natural Resources Fund -$78K for the FEMA Hazard Mitigation Grant (Deschutes
County's match)
F An increased transfer to Justice Court may be required if revenue or expenses come in lower or higher than currently projected
G The balance of the 1 % F&E TRT is transferred to F&E reserves
TES`c
z� Budget to Actuals Report
L� lG
ARPA — Fund 200
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021 1 Fiscal Year 2022
RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance
Interest - 14,137 - 84,147 101,010 101,010-
State & Local Coronavirus Fiscal 19,000,000 32,136 0% 19,000,000 19,167,541 101% 38,399,353 202% 19,399,353- A
Recovery Funds
TOTAL RESOURCES 19,000,000 46,273 0% 19,000,000 19,251,687 101% ; 38,500,363 203% ; 19,500,363:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Services to Disproportionately -
- 20,650,098
3,164,971
15% =
5,255,274
25% 15,394,824- B
Impacted Communities
Negative Economic Impacts -
- 6,035,840
5,464,103
91%
5,464,263
91% 571,577: C
Administrative 19,000,000
- 0% 5,981,005
130,613
2%
2,004,398
34% 3,976,607! D
Public Health -
32,136 999% 3,283,057
2,385,999
73%
2,458,767
75% 824,290! E
Infrastructure -
- 2,050,000
467,689
23%
468,290
23% 1,581,710! F
TOTAL REQUIREMENTS 19,000,000
32,136 0% 38,000,000
11,613,375
31%
15,650,992
41% 22,349,008:
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance - 19,000,000 14,137 0% 14,137 0% (18,985,863);
Resources over Requirements - 14,137 (19,000,000) 7,638,312 22,849,371 41,849,371-
Net Transfers - In (Out) - - - -
a
TOTAL FUND BALANCE _ $ 14,137 999%: - $ 7,652,449 999% ; ; $ 22,863,508 999% ;$22,863,508;
A The revenue received in FY21, but unspent at 06.30.21, was recorded as Deferred Revenue and recognized in FY22
B Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects
C Majority of funding is for food programs, $2.5 million in small business assistance and additional funding for Ronald McDonald House and an
Apprenticeship jobs program
D Administration holds the balance of the ARPA funds, as well as an approved budget analyst for ARPA reporting and administration
E Approved ARPA funding consists of Isolation Motel Liability Insurance, COVID-19 testing done by Dr. Young, UV sanitizer for the jail to prevent
COVID-19 in congregate settings and various Health Services expenses such as temporary staffing costs to support the COVID-19 response
F Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment
(E$COGZ< Budget to Actuals Report
Justice Court -Fund 220
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021 1
Fiscal Year 2022
RESOURCES
Budget
Actuals %
Budget
Actuals %
Projection
%
$ Variance
Court Fines & Fees
488,750
500,818 102%
550,000
455,930 83%
501,860
91%
(48,140);
Miscellaneous
1
-
I
736
737
1 1
- 0%
737
I
100%
1
Interest on Investments
1,100
9 1%
95
36 38%
45
47%
(50).
TOTAL RESOURCES
489,850
501,563 102% ;
550,832
455,965 83%
502,642
91% ;
(48,190);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
531,006
519,650
98%
542,209
496,637
92%
542,209 100% -
�
Materials and Services
152,502
131,276
86%
158,933
138,041
87%
151,362 95% 7,571, A
TOTAL REQUIREMENTS
683,508
650,926
95% ;
701,142
634,678
91%
693,571 99% ; 7,571,
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
Transfers In - TRT
-
-
205,956
188,793
92%
205,956 100% - B
Transfers In- General Fund
107,235
111,521
104%
-
-
TOTAL TRANSFERS
107,235
111,521
104% ;
205,956
188,793
92%
205,956 100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 144,227 37,842 26% - - - 1 01
Resources over Requirements (193,658) (149,363) (150,310) (178,713) (190,929) (40,619);
Net Transfers - In (Out) 107,235 111,521 205,956 188,793 205,956
I I i t 1 I
TOTAL FUND BALANCE $ 57,804 - 0% $ 55,646 $ 10,080 18% $ 15,027 27% ($40,619);
A One time yearly software maintenance fee paid in July for entire fiscal year
B An increased transfer from TRT may be required if revenue or expenses come in lower or higher than currently projected
IPV'TES coG2� Budget to Actuals Report
Sheriff's Office - Fund 255
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
RESOURCES
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
LED #1 Property Tax Current
27,476,763
27,912,029 102%
28,448,529
28,762,639 101%
28,817,681 101% ;
369,152- A
LED #2 Property Tax Current
11,092,307
11,269,119 102%
11,813,562
11,934,870 101%
11,959,026 101% =
145,464- A
Sheriffs Office Revenues
4,259,128
4,693,854 110%
3,993,964
4,064,328 102%
4,086,066 102%
92,102
LED #1 Property Tax Prior
280,000
579,513 207%
330,000
261,890 79%
330,000 100%
LED #1 Interest
101,100
170,066 168%
147,416
88,569 60%
91,920 62%
(55,496)[
LED #2 Property Tax Prior
120,000
194,726 162%
145,000
107,239 74%
145,000 100%
LED #2 Interest
120,000
72,488 60%
69,274
22,759 33%
23,360 34% a
(45,914)
LED #2 Foreclosed Properties
-
13,534
-
-
-°
LED #1 Foreclosed Properties
-
33,522
-
-
-
TOTAL RESOURCES
43,449,298
44,938,851 103% ;
44,947,745
45,242,294 101% ; 1
45,453,053 101% ;
505,308;
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Sheriffs Services
3,864,843
4,435,626
115%
4,002,499
3,898,901
97%
4,187,632
105%
(185,133);
Civil/Special Units
11232,618
1,083,411
88%
1,154,204
1,006,199
87%
1,145,665
99%
8,539
Automotive/Communications
3,312,477
3,184,547
96%
3,576,342
3,214,476
90%
3,480,775
97%
95,567!
Detective
2,515,536
2,546,467
101%
3,029,130
2,819,351
93%
3,101,081
102%
(71,951)
Patrol
13,284,465
13,388,793
101%
14,015,461
11,876,197
85%
13,689,869
98%
325,592
Records
1,038,130
954,506
92%
1,025,023
683,928
67%
769,727
75%
255,296:
Adult Jail
20,347,342
18,424,567
91%
21,033,697
17,177,665
82%
19,702,390
94%
1,331,307!
Court Security
490,401
413,143
84%
444,617
389,215
88%
427,603
96%
17,014!
Emergency Services
543,565
886,331
163%
789,912
511,207
65%
705,913
89%
839999!
Special Services
2,052,586
1,787,984
87%
1,775,588
1,856,713
105%
2,077,461
117%
(301,873)
Training
1,156,993
1,186,921
103%
1,626,207
1,427,859
88%
19690,797
104%
(64,590)
Other Law Enforcement i
1,328,675
1,331,363
100%
1,389,684
1,368,474
98%
1,543,885
111%
(154,202)
Non - Departmental
95,589
1,589
2%
299,998
-
0%
299,998 100%
-i
TOTAL REQUIREMENTS ;
51,263,220
49,625,248
97%
54,162,360
46,230,185
85% ;
52,822,795
98%
1,339,565:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Transfer In - TRT
3,151,787
3,151,787
100%
3,651,787
3,347,465
92%
3,651,787
100%
-
Transfer In - General Fund
240,290
240,290
100%
121,950
111,782
92%
121,950
100%
-�
Transfers Out - Debt Service
(273,000)
(272,128)
100%
(273,000)
(272,491)
100%
(273,000) 100%
-�
TOTAL TRANSFERS
3,119,077
3,119,949 100% ;
3,500,737
3,186,756
91%
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,214,615)
(987,891)
(7,369,742)
1,844,873-
Net Transfers - In (Out) 3,119,077
3,119,949 3,500,737
3,186,756
3,500,737
c i
TOTAL FUND BALANCE . $ 13,981,322
$ 17,266,520 123% ; $ 12,160,633
$ 19,465,385
160% ; ; $ 13,397,515
110% ; $1,236,882,
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
-`AESC,,o Budget to Actuals Report
Health Services - Fund 274
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021 1
Fiscal Year 2022
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
State Grant
15,156,802
14,869,697 98%
17,641,302
16,349,731
93%
16,776,761
95%
(864,541);
OHP Capitation
8,279,406
8,403,083 101%
8,947,837
10,896,387
122%
11,615,128
130%
2,667,291
Federal Grants
4,833,096
5,641,391 117%
4,303,483
2,640,038
61%
4,028,738
94%
(274,745)!
State Miscellaneous
2,850,731
3,493,477 123%
4,129,465
2,705,450
66%
3,592,273
87% a
(537,192)[
OHP Fee for Service
3,265,627
3,877,425 119%
3,627,151
3,161,680
87%
3,626,866
100%
(285)
CCBHC Grant
-
2,627,291
38,587
1%
38,587
1%
(2,588,704)
Local Grants
3,639,059
3,829,781 105%
1,936,838
2,145,778
111%
1,762,359
91% _
(174,479)
Environmental Health Fees
1,091,652
1,106,707 101%
1,086,019
1,140,637
105%
1,191,432
110%
105,413
Medicaid
350,491
933,393 266%
1,014,100
717,480
71%
770,094
76%
(244,006)
Other
965,971
1,106,718 115%
884,036
698,881
79%
871,981
99%
(12,055)
Patient Fees
672,995
483,754 72%
468,415
498,550
106%
533,608
114%
65,193
Vital Records
237,296
317,189 134%
280,000
288,944
103%
338,500
121%
58,500!
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
184,049
107%
197,723
115%
25,523!
Liquor Revenue
99,500
158,977 160%
157,000
151,646
97%
199,025
127%
42,025!
Interest on Investments
147,400
153,426 104%
156,549
91,430
58%
98,040
63%
(58,509)!
State Shared- Family Planning
155,000
146,074 94%
152,634
1189228
77%
128,976
85%
(23,658)-
Interfund Contract- Gen Fund
127,000
127,000 100%
1279000
127,000
100%
127,000
100%
State - Medicaid/Medicare
952,220
882,600 93%
843,050
715,888
85%
788,026
93%
(55,024)
TOTAL RESOURCES
43,207,563
45,921,554 106% ;
48,727,400
42,848,711
88%
46,863,448
96%
(1,863,952);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Administration Allocation
-
- 999%
-
-
-
-
Personnel Services
37,622,192
35,975,598 96%
43,994,358
36,007,743
82%
39,441,046 90%
4,553,312-
Materials and Services
14,523,515
13,886,895 96%
14,721,284
10,410,619
71%
12,544,306 85%
2,176,978!
Capital Outlay
139,467
131,664 94%
157,000
82,128
52%
153,807 98%
3,193
TOTAL REQUIREMENTS
52,285,174
49,994,157 96%
58,872,642
46,500,489
79%
52,139,159 89%
6,733,483:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Transfers In- General Fund
5,472,710
5,472,710 100%
5,909,168
5,416,675
92%
5,909,168 100%
Transfers In - TRT
406,646
406,646 100%
444,417
407,374
92%
444,417 100%
Transfers In- OHP Mental Health
2,379,865
1,298,965 55%
-
-
-
-
Transfers Out
(232,908)
(232,908) 100%
(230,755)
(211,493)
92%
(230,755) 100%
TOTAL TRANSFERS
8,026,313
6,945,413 87%
6,122,830
5,612,557
92%
6,122,830 100% ;
FUND BALANCE
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Beginning Fund Balance
6,778,564
7,817,166 115%
10,033,946
10,689,975
107%
10,689,976 107%
656,030-
Resources over Requirements
(9,077,611)
(4,072,603)
(10,145,242)
(3,651,778)
(5,275,711)
4,869,531!
Net Transfers - In (Out)
8,026,313
6,945,413
6,122,830
5,612,557
6,122,830
e
s
�s
s
TOTAL FUND BALANCE
$ 5,727,266
$ 10,689,975 187% ;
$ 6,011,534
$ 12,650,754
210% ;
$ 11,537,095 192% ;
$5,525,561:
01Es°°G2{ Budget to Actuals Report
Health Services - Admin - Fund 274
FY22 YTD May 31, 2022 (unaudited)
91.7%
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%
1,438,843
463,826
32%
1,140,806
79%
(298,037); A
State Grant
-
-'
769,319
759,406
99%
512,065
67%
(257,254); B
CCBHC Grant
486,804
6,938
1%
6,938
1%
(479,866); C
Interest on Investments
147,400
153,426 104%
156,549
91,430
58%
98,040
63%
(58,509)
Other
14,391
12,622 88%
9,200
11,895
129%
13,831
150%
4,631-
OHP Capitation
-
-
-
404,933
436,443
436,443- C
Patient Fees
-
-
State Miscellaneous
-
347,105
TOTAL RESOURCES
1,399,036
3,149,311 225% ;
2,860,715
1,738,428
61%
2,208,123
77%
(652,592);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
5,914,729
5,679,486
96%
6,904,224
5,299,295 77%
5,856,790 85% 1,047,434- D
Materials and Services
4,991,353
6,435,511
129%
6,580,649
5,524,756 84%
6,173,293 94% 407,356
Administration Allocation
(9,645,743)
(9,645,743)
100%
(10,188,902)
(5,028,475) 49%
(1fl,188,902)' 100%
TOTAL REQUIREMENTS
1,260,339
2,469,254
196% ;
3,295,971
5,795,576 176% ;
1,841,181 56% ; 1,454,790:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
Transfers Out
(232,908)
(232,908)
100%
(219,794)
(201,447)
92%
(219,794) 100%
TOTAL TRANSFERS
(232,908)
(232,908)
100% ;
(219,794)
(201,447)
92% ; ;
(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% 3,769,942 106% 217,942.
Resources over Requirements 138,696 680,056 (435,256) (4,057,148) 366,942 802,198!
Net Transfers - In (Out) (232,908) (232,908) (219,794) (201,447) (219,794)
TOTAL FUND BALANCE $ 2,678,628 $ 3,769,942 141% ; $ 2,896,950 ($ 488,653) -17% ; $ 3,917,090 135% ; $1,020,140:
A Federal grants are reimbursed on a quarterly basis.
B Actuals include revenue for which will be spent in future fiscal years whereas the projection amount reflects the department's anticipated State Grant
funds to be used in FY22
C Increased OHP enrollment is resulting in higher than budgeted OHP Capitation payments and less than budgeted CCBHC State Grant revenues
D Personnel projections based on year to date vacancy savings and assume 3% moving forward
oy �1ES` G 2� Budget to Actuals Report
L� G
Health Services - Behavioral Health - Fund 274
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
State Grant
OHP Capitation
OHP Fee for Service
Federal Grants
CCBHC Grant
State Miscellaneous
Local Grants
Medicaid
Other
Patient Fees
Divorce Filing Fees
State - Medicare
Liquor Revenue
Interfund Contract- Gen Fund
TOTAL RESOURCES
91.7%
Year Complete
Fiscal Year 2021 1
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
10,348,047
9,920,554 96%
11,907,014
11,393,504
96%
12,245,891 103%
338,877- A
8,279,406
8,403,083 101%
8,947,837
10,491,453
117%
11,178,685 125%
2,230,848! B
3,265,627
3,877,425 119%
3,627,151
3,141,834
87%
3,604,730 99% !
(22,421)
3,298,243
2,715,411 82%
2,725,623
2,072,289
76%
2,763,583 101% -
37,960, C
2,140,487
31,649
1%
31,649 1%
(2,108,838) B
1,544,455
1,285,829 83%
1,934,643
1,174,079
61%
1,734,330 90%
(200,313); D
1,897,762
1,717,173 90%
1,093,055
1,274,833
117%
834,189 76%
(258,866); E
350,491
933,393 266%
1,014,100
717,480
71%
770,094 76%
(244,006); F
927,605
1,076,144 116%
682,180
612,365
90%
667,543 98%
(14,637)
522,300
382,906 73%
372,115
400,564
108%
428,746 115%
56,631
173,030
173,030 100%
173,030
1789331
103%
178,331 103%
5,301!
210,287
217,833 104%
172,200
184,049
107%
197,723 115%
25,523!
99,500
158,977 160%
157,000
151,646
97%
199,025 127%
42,025!
127,000
127,000 100%
127,000
127,000 100%
127,000 100%
-�
31,043,753
30,988,758 100% ;
35,073,435
31,951,076
91%
34,961,519 100% ;
(111,916);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Administration Allocation 7,434,938 7,434,938 100% 7,523,855 3,734,328 50% 7,523,855 100%
Personnel Services
23,060,066
22,131,010
96%
26,606,065
22,408,281
84%
24,536,895 92%
2,069,170. G
Materials and Services
5,998,817
4,097,273
68%
4,882,963
2,889,231
59%
3,957,266 81%
925,697!
Capital Outlay
125,267
106,122
85%
80,000
54,752
68%
79,875 100%
125!
TOTAL REQUIREMENTS
36,619,088
33,769,343
92%
39,092,883
29,086,592
74%
36,097,891 92% ;
2,994,992:
TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance
Transfers In- General Fund 2,036,117 2,036,117 100% 2,278,087 2,088,207 92% 2,278,087 100%
Transfers In- OHP Mental Health 2,298,179 1,217,279 53% - -
Transfers Out - - 0% (10,961) (10,046) 92% (10,961) 100%
TOTAL TRANSFERS 4,334,296 3,253,396 75% 2,267,126 2,078,162 92% ; 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,864,484
(1,136,372) 2,883,076
Net Transfers - In (Out)
4,334,296
3,253,396
2,267,126
2,078,162
2,267,126
TOTAL FUND BALANCE
$ 1,767,666
$ 3,870,664 219% ;
$ 1,859,692
$ 8,813,309 474% ;
$ 5,001,418 269% ; $3,141,726:
A Actuals include additional funds for Aid & Assist ($285K) and Parent Child Interactive Therapy ($78K), and also includes revenue for which will be
spent in future fiscal years. The projection amount reflects the department's anticipated State Grant funds to be used in FY22
B Increased OHP enrollment is resulting in higher than budgeted OHP Capitation payments and less than budgeted CCBHC State Grant revenues.
CCBHC Grant is reimbursed on a quarterly basis. 2022 PacificSource contract effective April 2022, which increases projected revenue by $240,000.
C Projections include an extension of unspent funds for the Crisis Program's Bureau of Justice Assistance and SAMHSA CCBHC Expansion grants
D Reduction in projected revenue associated with the I/DD local match program
E Carryforward of unspent FY21 COHC Crisis Services Grant and Choice Model funds. Also includes unbudgeted 2020 Q1 COHC Covid QIM funds.
Actuals include revenue for which will be spent in future fiscal years whereas the projection amount reflects the department's anticipated Local Grant
funds to be used in FY22.
F Medicaid services tracking lower than budget
G Personnel projections based on year to date vacancy savings and assume 6% moving forward
Q`�07ES`0& Budget to Actuals Report
Health Services - Public Health - Fund 274
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
State Grant
State Miscellaneous
Environmental Health Fees
Local Grants
Vital Records
Other
State Shared- Family Planning
Federal Grants
Patient Fees
OHP Fee for Service
State - Medicaid/Medicare
TOTALRESOURCES
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
4,808,755
4,949,143 103%
4,964,969
4,196,821
85%
4,018,805
81%
(946,164); A
1 1,306,276
1,860,543 142%
2,194,822
1,531,370
70%
1,857,943
85%
(336,879); B
1 1,091,652
1,106,707 101%
1,086,019
1,140,637
105%
1,191,432
110%
105,413, C
1,741,297
i
2,112,608 121%
843,783
870,945
103%
928,170
110% 0
84,387: D
237,296
317,189 134%
280,000
288,944
103%
338,500
121%
58,500!
23,975
17,952 75%
192,656
74,622
39%
190,607
99%
(2,049)!
1 155,000
146,074 94%
152,634
118,228
77%
128,976
85%
(23,658)
1 297,609
289,822 97%
139,017
103,923
75%
124,349
89%
(14,668)
1 150,695
100,848 67 /o ° I
96,300
97,985
102%
104,862
109%
8,562-
_
1
-
19,845
I 1
22,136
�
22,136,
1 952,220
882,600 93%
843,050
715,888
85% I
7889026
93%
(55,024) E
10,764,775
11,783,485 109% ;
10,793,250
9,159,207
85%
9,693,806
90% ;
(1,099,444);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Administration Allocation
2,210,805
2,210,805 100%
2,665,047
1,294,147
49%
2,665,047 100%
Personnel Services I
8,647,397
8,165,103 94%
10,484,069
8,300,166
79%
9,047,361
86%
1,436,708, F
Materials and Services 1
3,533,345
3,354,111 95%
3,257,672
1,996,632
61%
I
2,413,747
74%
843,925!
Capital Outlay 1
14,200
25,542 180%
77,000
27,376
36%
73,932
96%
3,068!
TOTAL REQUIREMENTS
14,405,747
13,755,560 95%
16,483,788
11,618,321
70% 1
14,200,087
86%
2,283,701;
TRANSFERS
Budget Actuals % Budget Actuals
Transfers In- General Fund 3,436,593
Transfers In - TRT 406,646
Transfers In- OHP Mental Health 81,686
r--
TOTAL TRANSFERS 3,924,925
FUND BALANCE Budget
3,436,593 100% 3,631,081 3,328,468
406,646 100% 444,417 407,374
81,686 100% - -
3,924,925 100% ; 4,075,498 3,735,842
% Projection % $ Variance
92% 3,631,081 100%
92% 444,417 100%
1 1 I I
92% 4,075,498 100% ;
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,690,538)
(2,459,114)
(4,506,281) 1,184,257!
Net Transfers - In (Out)
1
3,924,925
3,924,925
I
4,075,498
3,735,842
I I
4,075,498
1 I
TOTAL FUND BALANCE
$ 1,280,972
$ 3,049,370 238% ;
$ 1,254,892
$ 4,326,097 345% ;
$ 2,618,587 209% ; $1,363,695:
A While actuals do include additional funds for several program elements, it also includes revenue for which will be spent in future fiscal years. The
projection reflects the department's anticipated State Grant funds to be used in FY22.
B EISO projections under budget due to vacancies and staffing adjustments. COVID Equity Funds ended 12/31/21 and were $223k underspent.
C Environmental Health Fee projections updated based on actuals received to date
D Includes unbudgeted 2020 Q1 COHC Covid QIM funds ($210K)
E Medicaid/Medicare services tracking lower than budgeted
F Personnel projections based on year to date vacancy savings and assume 3% moving forward
oh �-TES C,
2� 0G Budget to Actuals Report
L�
Community Development - Fund 295 91 7%
FY22 YTD May 31, 2022 (unaudited)
Year Complete
Fiscal Year 2021 Fiscal Year 2022
RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance
Admin - Operations
137,450
152,710 111%
138,716
142,362 103%
147,716 106% a
9,000:
Code Compliance
722,028
783,094 108%
842,906
898,286 107%
988,906 117%
146,000! A
Building Safety
3,362,450
3,921,591 117%
3,819,940
3,852,224 101%
4,266,940 112% a
447,000! B
Electrical
720,600
915,357 127%
914,750
890,401 97%
983,600 108%
68,850! B
Environmental On -Site
867,700
1,118,994 129%
1,056,678
891,266 84%
972,778 92%
(83,900)!
Current Planning
1,738,304
2,054,192 118%
1,980,521
2,021,964 102%
2,148,161 108% a
167,640! B
Long Range Planning
703,194
741,514 105%
826,806
826,495 100%
914,675 111%
87,869! A
TOTAL RESOURCES
8,251,726
9,687,451 117% ;
9,580,316
9,522,997 99% ;
10,422,775 109% ;
842,459:
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Admin - Operations
2,818,748
2,740,077
97%
3,137,795
2,715,325
87%
3,043,963
97%
93,832- C
Code Compliance
568,320
539,584
95%
617,012
548,792
89%
620,443
101% o
(3,431)
Building Safety
1,867,662
1,768,376
95%
2,284,444
1,854,266
81%
2,061,602
90% a
222,842! C
Electrical
5249979
487,253
93%
556,531
506,987
91%
549,881
99%
6,650, C
Environmental On -Site
634,452
639,025
101%
765,935
581,685
76%
637,068
83%
128,867: C
Current Planning
1,479,294
1,465,772
99%
1,769,333
1,458,548
82%
1,636,476
92%
132,857! C
Long Range Planning
580,687
446,049
77%
847,839
508,993
60%
602,039
71%
245,800- C
TOTAL REQUIREMENTS
8,474,142
8,086,137
95%
9,978,889
8,174,596
82%
9,151,472
92%
827,417:
TRANSFERS
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Transfers In - General Fund
100,000
0%
290,000
152,441 53%
190,000 66%
(100,000); D
Transfers In - CDD Electrical
93,264
- 0%
-
-
Reserve
Transfers Out
(100,518)
(100,518) 100%
(99,360)
(91,047) 92%
(99,360) 100%
-�
Transfers Out - CDD Reserve
(148,226)
(1,004,480) 678%
(461,262)
(917,807) 199%
(1,082,494) 235% ,
(621,232)� E
TOTAL TRANSFERS
(55,480)
(1,104,998) 999% ;
(270,622)
(856,413) 316% ;
(991,854) 367% ;
(721,232);
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,306-
Resources over Requirements
(222,416)
1,601,315
(398,573)
1,348,401
1,271,303 1,669,876
Net Transfers - In (Out)
(55,480)
(1,104,998)
(270,622)
(8569413)
(991,854) I (721,232);
TOTAL FUND BALANCE
$ 734,798
$ 1,749,673 238% ;
$ 763,172
$ 2,241,661 294% ; ;
$ 2,029,122 266% ; $1,265,950:
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 Reduction of General Fund transfers to Current Planning
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
Qy`�ATEs`°G2� Budget to Actuals Report
Road - Fund 325
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Motor Vehicle Revenue
Federal - PILT Payment
Other Inter -fund Services
Forest Receipts
Cities-Bend/Red/Sis/La Pine
Sale of Equip & Material
Miscellaneous
Mineral Lease Royalties
Interest on Investments
Assessment Payments (P&I)
Federal Reimbursements
State Miscellaneous
91.7%
Year Complete,
Fiscal Year 2021 1
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
14,810,507
17,342,054 117%
17,485,000
18,000,249
103%
19,400,000 111%
1,915,000, A
1,690,574
2,061,977 122%
2,096,751
2,195,918
105%
2,195,918 105%
99,167: B
1,114,070
1,198,004 108%
1,221,632
458,048
37%
1,181,132 97%
(40,500)l C
723,085
660,298 91%
627,207
792,420
126%
792,420 126%
165,213, B
385,000
627,694 163%
560,000
155,269
28%
176,269 31% _
(383,731): D
396,000
333,109 84%
449,150
285,004
63%
477,340 106%
28,190! A
54,000
73,562 136%
67,340
64,351
96%
70,556 105%
3,216: E
60,000
51,642 86%
60,000
148,267
247%
150,000 250%
90,000: C
114,000
65,094 57%
59,109
51,072
86%
53,920 91%
(5,189): C
8,000
24,578 307%
3,460
15,827
457%
16,100 465%
12,640- C
1,325,874
1,093,866 83%
-
-
7,048
-
-
TOTAL RESOURCES 20,681,110 23,538,925 114% ; 22,629,649 22,166,427 98% 24,513,655 108% ; 1,884,006:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services 6,709,180 6,422,847 96% 6,916,229 6,153,319 89% 6,764,981 98% 151,248- F
Materials and Services 7,753,525 6,065,466 78% 7,843,400 5,367,703 68% 7,802,979 99% 40,420- C
Capital Outlay 50,500 17,944 36% 264,500 124,403 47% 260,115 98% 4,386: C
TOTAL REQUIREMENTS ; 14,513,205 12,506,257 86% ; 15,024,128 11,645,425 78% 14,828,074 99% ; 196,054:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Transfers Out
(6,683,218)
(6,683,218) 100%
(11,757,547)
(6,985,536)
59%
(11,757,547) 100%
TOTAL TRANSFERS
(6,683,218)
(6,683,218) 100% ;
(11,757,547)
(6,985,536)
59%
(11,757,547) 100% ;
FUND BALANCE
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Beginning Fund Balance
2,695,786
4,217,071 156%
6,383,832
8,566,521
134%
8,566,521 134% =
2,182,690,
Resources over Requirements
6,167,905
11,032,669
7,605,521
10,521,002
9,685,581
2,080,060!
Net Transfers - In (Out)
(6,683,218)
(6,683,218)
(11,757,547)
(6,985,536)
(11,757,547)
-
TOTAL FUND BALANCE
$ 2,180,473
$ 8,566,521 393% ;
$ 2,231,806
$ 12,101,987
542% ; ;
$ 6,494,555 291% ;
$4,262,749:
A Updated based on YTD actuals trending higher than budgeted
B Actual payment higher than budget
C Updated based on YTD actuals
D City of Bend work will not happen this FY
E Parking Fees for Judicial Trailer increased over budget
F Projected Personnel savings based on YTD spending plus estimate for June
oh VIES � 2� Budget to Actuals Report
L� �G
Adult P&P - Fund 355
FY22 YTD May 31, 2022 (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
TOTALRESOURCES
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals %
Projection
%
$ Variance
4,621,780
4,621,782 100%
4,202,885
4,734,453 113%
4,734,453
113%
531,568, A
797,504
793,044 99%
781,597
892,038 114%
893,000
114%
I
111,403! A
239,005
�
264,005 110%
255,545
244,606 96%
I
244,606
96%
(10,939): B
170,000
I
189,458 111%
170,000
I
3,606 2%
3,607
!
2% _
I
(166,393): C
-
�
18,453
138,000
73,533 53%
90,000
65%
(48,000); D
-
I
-
118,250
1 1
58,958 50%
58,958
1
50%
I
(59,292); B
�
50,000
55,000 110%
50,000
50,417 101%
55,000
110%
I
5,000- E
50,000
50,000 100% -
50,000
50,000 100% -
50,000
100%
I
37,700
I
43,276 115%
45,193
I I
17,371 38%
18,130
B
40%
I
(27,063):
I
-
�
1
-
24,281
I I
- 0%
20,318
B
84% _
I
(3,963): F
10,000
�
3,973 40%
2,500
269 11%
I
300
12%
(2,200):I G
2,000
�
1
600 30%
1,500
I
- 0%
I
-
1
0%
(1,500):I C
1,000
i
1
579 58%
500
I
560 112%
560
1
112%
60- H
16,298
I
- 0%
-
I I
-
I
I
5,995,287
6,040,170 101% ;
5,840,250
6,125,810 105% ;
6,168,932
106% ;
328,682:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services 5,157,473 4,950,715 96% 5,379,503 4,440,580 83% 4,853,153 90% 526,350- 1
Materials and Services 1,923,795 1,414,886 74% 1,700,412 1,291,275 76% 1,574,600 93% 125,812!1
J
TOTAL REQUIREMENTS 7,081,268 6,365,601 90% 7,079,915 5,731,855 81% 6,427,753 91% 652,162:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers In- General Funds
285,189
285,189 100%
662,046
606,870
92%
662,046 100%
Transfer to Vehicle Maint
(97,693)
(97,693) 100%
(190,974)
(175,057)
92%
(190,974) 100%
TOTAL TRANSFERS
187,496
187,496 100% ;
471,072
431,813
92%
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) 393,955 (258,821) 980,844;
Net Transfers - In (Out) 187,496 187,496 471,072 431,813 471,072
I I I I 1 1
TOTAL FUND BALANCE $ 1,816,329 $ 2,982,055 164% ; $ 1,971,182 $ 3,807,823 193% ; $ 3,194,305 162% ; $1,223,123:
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 711121 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 $50K did not include additional Sheriff support of ATC and use of EM
F Received new agreement from BOPPPS, volume expectations less than previous years. Payment expected by the end of FY.
G 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
H Received unexpected revenue including refund for brass ammunition shells
I Projected Personnel savings based on YTD spending plus estimate for June
j Projected underspending based on FY22 trends
�tEs` 0
L�
2{ Budget to Actuals Report
Q
Road CIP -Fund 465
..`®.
91 7%
FY22 YTD May 31, 2022 (unaudited)
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
1,000,000 46% 1,000,000
46% ; (1,191,461); A
Interest on Investments 209,700 271,831 130%
279,729
112,938 40% 123,510
44% o (156,219)- B
TOTAL RESOURCES 2,467,800 2,942,827 119% ;
2,471,190
1,112,938 45% 1,123,510
45% (1,347,680);
REQUIREMENTS Budget
Actuals %
Budget
Actuals %
Projection
% $ Variance
Materials and Services 158,465
158,465 100%
109,870
100,714 92%
109,870
100% - -
Capital Outlay ! 19,877,585
11,583,557 58%
29,612,821
7,404,140 25%
10,092,284
34% 19,520,537� C
TOTAL REQUIREMENTS 20,036,050
11,742,022 59%
29,722,691
7,504,855 25% ;
10,202,154
34% ; 19,520,537:
TRANSFERS Budget
Actuals %
Budget
Actuals %
Projection
% $ Variance
Transfers In 7,517,657
6,819,612 91%
12,193,917
4,772,011 39%
10,926,861
90% 1 (1,267,056)-
TOTAL TRANSFERS 7,517,657
6,819,612 91%
12,193,917
4,772,011 39%
10,926,861
90% ; (1,267,056);
FUND BALANCE Budget
Actuals %
Budget
Actuals %
Projection
% $ Variance
Beginning Fund Balance 23,154,407
25,5129586 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)
(6,391,917)
(9,078,644)
18,172,857-
Net Transfers - In (Out) 7,517,657
6,819,612
12,193,917
4,772,011
10,926,861
(1,267,056)
e
i
et
� i
TOTAL FUND BALANCE $ 13,103,814
$ 23,533,004 180% ;
$ 5,316,460
$ 21,9139098 412% ; $ 25,381,221
477% ;$20,064,761;
A Revised ODOT funding agreement reduces revenue and offsetting expense
for Terrebonne Refinement Plan
by $1.7 million.
COVID 19 relief
funding budgeted in FY 22 was received in FY 21. Reimbursable work will be reduced to $50k with remainder being pushed
to FY 23. $1 M
budgeted in FY 23 was received in FY22.
B Updated based on YTD actuals
C Updated based on anticipated completion of
projects in FY22 coming in under budget
or delayed to FY23
C,\JIES Budget to Actuals Report
° Road CIP (Fund 465) - Capital Outlay Summary by Project
FY22 YTD May 31, 2022 (unaudited)
Terrebonne Refinement Plan
Tumalo Road / Tumalo Place
Old Bend Rdm/Tumalo Rd Inter
NE Negus and 17TH
Hunnel Rd: Loco Rd to Tumalo Rd
Transportation System Plan Update
Gribbling Rd Bridge
Terrebonne Wastewater Feasibility St.
Rickard Rd: Groff Rd to US 20
Paving Powell Butte Hwy
Smith Rock Way Bridge Replace
Deschutes Mkt Rd/Hamehook Round
Paving Cottonwood: Us 97 To BSNF RR
Paving Desch Mkt Rd: Yeoman Hamehoo
Paving Alfalfa Mkt Rd: Mp 4 Dodds
Paving Of Hamby Rd: Us 20 To Butler
Powell Butte Hwy/Butler Market RB
Wilcox Ave Bridge #2171-03 Replacem
US 20: Cook Ave/OB Riley Rd (Tumalo
US 20: Tumalo Multi -Use Path Crossing
Highway Warning Systems 2021
Tumalo Wastewater Feasibility Study
Paving Tumalo Rd/Deschutes Mkt Rd
Slurry Seal 2022
FY 22 Guardrail Improvements
Redmond District Local Roads
Bend District Local Roads
Sidewalk Ramp Improvements
Signage Improvements
TOTAL
91.7%
Year Completed
Fiscal Year 2021 Fiscal Year 2022
Rudaef Actuals % Budaet Actuals % Projection % $ Variance
5,000,000
$
10,000,000
0% $
0% 1 $
10,000,000
1,517,345
1,092,426
72% i
-
67,998
74,870
(74,870)
1,350,782
1,200,636
89%
-
16,907
16,907
(16,907)E
788,684
339,647
43 %
2,363,532
2,134,966
90 %
2,144,966
91 %
218,566
794,229
240,723
30 % !
2,168,940
214,502
10 % ':
945,537
44 % E
1,223,403:
170,000
82,053
48% €
108,510
79,310
73% 1
165,318
152% €
(56,808):
222,000
-
0%
279,575
0% E
50,000
18% E
229,575:
50,000
63,646
127%
-
31,642
36,091
(36,091)
605,300
497,920
82 %
1,716,142
1,391,051
81 %
1,391,051
81 % E
325,091:
651,000
38,085
6%
931,140
1,319,374
142%
1,319,374
142%
(388,234):
85,000
-
0%
505,000
253
0% E
50,000
10%
455,000E
150,000
10,277
7% 1
671,000
371,925
55%
564,000
84%
107,000
-
-
618,144
499,075
81 %
499,075
81 %
119,069;
-
-
310,838
-
0%
0%
310,838
-
-
265,000
890
0% E
265,000
100 % E
-
-
200,000
641
0% E
410,000
205 % €
(210,000)i
-
-
150,000
411
0%
60,000
40 %
90,000;
-
-
100,000
-
0%
0%
100,000:
-
-
6,700,000
0% E
0% E
6,700,000':
-
-
1,250,000
1,200,000
1,200,000
96% i
50,000:
69,536
69,536
(69,536)
-
-
-
219
219
(219):
_
-
-
1,640
2,440
(2,440):
-
_
-
822
300,000
(300,000)
100,000
83,367
83%
100,000
981
1% i
117,450
117%
(17,450):
-
-
500,000
-
0% ?
500,000:
500,000
-
0%
500,000
0% i
-
0% E
500,000:;
75,000
0%
75,000
404
1 % E
300,000
400 % E
(225,000)
100,000
-
0%
100,000
1,593
2%
110,450
110% [
(10,450)';
$ 12,159,340
$ 3,648,779
30%:
$ 29,612,821E
7,404,140
25W
$ 10,092,284
34%E
$ 19,520,537
uTESCcl2� Budget to Actuals Report
G
.`®. Solid Waste - Fund 610
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Franchise Disposal Fees
Private Disposal Fees
Commercial Disp. Fee
Yard Debris
Franchise 3% Fees
Miscellaneous
Interest
Special Waste
Recyclables
Leases
Equip & Material
TOTAL RESOURCES
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget
Actuals %
Budget
Actuals %
Projection
%
$ Variance
6,630,625
6,764,888 102%
7,124,000
6,303,973 88%
6,900,000
97% a
(224,000): A
2,491,617
2,985,124 120%
2,827,000
2,858,615 101%
3,203,000
113%
376,000! A
2,319,792
2,830,984 122%
2,686,000
2,764,257 103%
3,140,000
117%
454,000! A
216,761
301,824 139%
300,000
238,290 79%
270,000
90%
(30,000)! B
280,000
389,402 139%
290,000
318,324 110%
339,000
117% =
49,000! C
88,096
102,595 116%
55,000
63,879 116%
68,860
125%
13,860!D
23,700
42,794 181%
41,599
26,310 63%
29,470
71% _
(12,129)!
15,000
34,292 229%
15,000
37,028 247%
38,000
253% =
23,000! E
12,000
11,180 93%
12,000
11,635 97%
12,000
100%
-
1
1 100%
1
1 100%
1
100% ,
-
-
200
-
12,077,592 13,463,285 111% ; 13,350,600 12,622,313 95% ; 14,000,331 105% ; 649,731:
REQUIREMENTS Budget Actuals % Budget Actuals %
Personnel Services
2,518,594
2,510,986 100%
2,754,132
2,410,447
88%
Materials and Services
5,227,119
4,705,435
90%
5,651,103
4,248,727
75%
Capital Outlay
162,500
29,523
18%
53,141
76,304
144%
Debt Service
945,000
861,354
91%
1,251,615
797,852
64%
TOTAL REQUIREMENTS ;
8,853,213
8,107,298
92%
9,709,991
7,533,330
78% ;
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
SW Capital & Equipment
(3,684,280)
(3,684,280)
100%
(6,029,323)
(4,521,793)
75%
Reserve
TOTAL TRANSFERS
(3,684,280)
(3,684,280)
100% ;
(6,029,323)
(4,521,793)
75% ;
FUND BALANCE Budget Actuals % Budget Actuals %
Beginning Fund Balance
1,179,819
2,285,566 194%
2,972,234
3,957,273 133%
Resources over Requirements
3,224,379
5,355,987
3,640,609
5,088,983
Net Transfers - In (Out)
(3,684,280)
(3,684,280)
(6,029,323)
(4,521,793)
TOTAL FUND BALANCE
$ 719,918
$ 3,957,273 550% ;
$ 583,520
$ 4,524,463 775% ;
Projection
%
$ Variance
2,685,318
98%
68,814- F
5,254,257
i
93% 0
396,846! G
91,305
e
172%
i
(38,164): H
799,000
64%
452,615- 1
8,829,880
91% ;
880,111:
Projection % $ Variance
(6,029,323) 100%
(6,029,323) 100% ;
Projection % $ Variance
3,957,273 133% 985,039,
5,170,451 1,529,842�
a
(6,029,323)
$ 3,098,401 531% ; $2,514,881:
A Total disposal fee projections reflect management's best estimate of revenues to be collected. YTD volumes are running 5% higher than last year-
to-date; franchise growth is just below the budgeted amount and is offset by larger than anticipated increases seen in private and commercial
disposal.
B Revenue is seasonal with higher utilization in summer months; there is a 12% reduction when comparing this fiscal YTD to the abnormally high
volumes of last year-to-date
C Annual fees due April 15, 2022; received year-to-date monthly installments from Republic and the annual payment from Cascade Disposal
D FY22 projection includes the unbudgeted sale of a utility terrain vehicle and electricity capital credits; miscellaneous tire and appliance revenue is
slightly exceeding budget
E Revenue source is unpredictable and dependent on special clean-up projects; recent large contaminated soil projects from remediation of a gas
station, traffic incidents and illegal dumping site
F Personnel savings based on FY22 YTD average vacancy rate of 8.2% with factors for the additional 3 FTE Site Attendants and new incoming
Director
G Projecting to spend less than anticipated with the postponement of the waste characterization study, timing for mulch grinding, adding 3 FTE Site
Attendants versus using temporary labor, environmental and general repair and maintenance costs
H The new 1 ton service truck and service box ordered in FY21 was rolled into FY22 due to delayed availability
I Principal and interest payments due in Nov and May for existing debt; projection reflects adjustments for partial refunding of existing debt with
improved interest and the postponement of the Negus Transfer Station construction funding to next fiscal year
- �G
\)TESC 2{ Budget to Actuals Report
C.
Fair & Expo - Fund 615
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021
1
Fiscal Year 2022
RESOURCES
Budget
Actuals
%
Budget
Actuals %
Projection %
$ Variance
Events Revenue
625,000
1,194,701
191%
578,000
702,759 122%
747,000 129%
169,000- A
Food & Beverage
548,500
209,297
38%
513,500
731,885 143%
758,000 148%
244,500! A
Rights & Signage
125,000
62,500
50%
105,000
25,392 24%
65,000 62%
(40,000)!
Storage
75,000
77,897
104%
77,500
46,539 60%
47,000 61%
(30,500)[
Horse Stall Rental
52,000
11,378
22%
71,500
54,016 76%
55,000 77%
(16,500)
Interfund Payment
30,000
226,786
756%
30,000
27,500 92%
30,000 100% -
-
Camping Fee
12,500
5,630
45%
19,500
4,700 24%
5,000 26%
(14,500)
Interest
(2,200)
1,051
-48%
474
4,846 999%
5,190 999%
4,71&
Miscellaneous
250
2,596 999%
250
1,997 799%
2,117 847%
1,867
TOTAL RESOURCES
1,466,050
1,791,835
122% ;
1,395,724
1,599,633 115% ;
1,714,307 123% ;
318,583;
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Personnel Services
840,704
1,031,160
123%
1,118,980
1,033,245
92%
1,126,494 101% -
(7,514);
Personnel Services - F&B
165,518
165,801
100%
181,593
162,455
89%
175,959 97%
5,634-
Materials and Services
702,149
576,528
82%
818,804
779,913
95%
852,000 104%
(33,196)!
Materials and Services - F&B
257,600
134,431
52%
282,500
325,314
115%
343,000 121%
(60,500)!
Debt Service
104,400
103,519
99%
103,000
100,899
98%
100,899 98%
2,101
TOTAL REQUIREMENTS
2,070,371
2,011,440
97%
2,504,877
2,401,827
96%
2,598,352 104%:
(93,475),
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers In - Room Tax
650,000
899,310 138%
905,769
830,280
92%
1,065,957 118% 160,188, B
Transfers In - County Fair
-
-
150,000
150,000
100%
150,000 100%
Transfers In - Park Fund
30,000
30,000 100%
30,000
27,500
92%
30,000 100% -
Transfers In - Room Tax (as
25,744
25,744 100%
25,744
23,595
92%
25,744 100% -�
needed)
;
Transfers In - General Fund
200,000
200,000 100%
-
-
Transfers Out
(10,777)
(10,777) 100%
(310,777)
(284,878)
92%
(310,777) 100% -�
TOTAL TRANSFERS
894,967
1,144,277 128% ;
800,736
746,497
93%
960,924 120% ; 160,188;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance
364,904
(1,199) 0%
750,673
923,473 123%
923,473 123%
172,800,
Resources over Requirements
(604,321)
(219,605)
(1,109,153)
(802,194)
(884,045)
225,108;
Net Transfers - In (Out)
894,967
1,144,277
800,736
746,497
960,924
160,188
;
�
i
e s
o
TOTAL FUND BALANCE
$ 655,550
$ 923,473 141% ;
$ 442,256
$ 867,776 196% ;
$ 1,000,352 226% ;
$558,096:
A Events continue to be impacted by Covid19, and is currently experiencing abnormal revenue fluctuations. F&E continues to be fluid in adapting to
changing event requirements and concerns to maximize revenue opportunities safely and responsibly.
B Room tax revenue projected to be higher than budget
,)I ES C0G� Budget to Actuals Report
` Annual County Fair - Fund 616
CY22 YTD May 31, 2022 (unaudited)
RESOURCES
Gate Receipts
Carnival
Commercial Exhibitors
Livestock Entry Fees
R/V Camping/Horse Stall Rental
Merchandise Sales
Concessions and Catering
Fair Sponsorship
TOTAL FAIR REVENUES
OTHER RESOURCES
State Grant
Interest
Miscellaneous
TOTAL RESOURCES
REQUIREMENTS
Personnel
Materials & Services
TOTAL REQUIREMENTS
Fair 2022
Actuals to
2022
Fair 2021
Date
Projection
$ 738,029 $
- $ 700,000
415,716
- 385,000
315,719
325,000
s
19,944 (-
- 19,500
5,239 j, v
- 3,500
295,093(;'
- 265,000
81,125 i
460 84,960
$ 1,870,865 ,<< $
460 $ 1,782,960
53,167 , - 53,167
1,194 1,030 2,473
$ 1,925,226 $ 1,490 $ 1,838,600
103,199 ;. 19,979 97,595
1,249,932 57,400 1,543,045
$ 1,353,131 $ 77,380 $ 1,640,640
>,
TRANSFERS
Transfer In - TRT 1 %
74,750
31,250
75,000
Transfer Out - Fair & Expo
(150,000)
-
(150,000)
TOTAL TRANSFERS
$ (75,250)
!` ,.,$
31,250
$
(75,000)
Net Fair
$ 496,845
` $
(44,639)
$
122,960
Beginning Fund Balance on Jan 1
$ (48,694)
r'
$
448,151
$
448,151
z;a
Ending Balance
$ 448,151
$
403,512
$
571,111
A Assumes Fair Coordinator is hired on July 1, 2022
TESC06 Budget to Actuals Report
Annual County Fair - Fund 616
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Gate Receipts
Concessions and Catering
Carnival
Commercial Exhibitors
Fair Sponsorship
State Grant
RN Camping/Horse Stall Rental
Rodeo
Livestock Entry Fees
Merchandise Sales
Interest on Investments
TOTAL RESOURCES
REQUIREMENTS
Personnel Services
Materials and Services
TOTAL REQUIREMENTS
TRANSFERS
Transfer In - TRT 1 %
Transfer Out - Fair & Expo
TOTAL TRANSFERS
FUND BALANCE
91.7%
Year Complete
Fiscal Year 2021
Fiscal Year 2022
Budget Actuals %
Budget
Actuals %
Projection
%
$ Variance
-
550,000
738,029 134%
738,029
134% ;
188,029,
385,000
526,737 137%
526,919
137% ;
141,919!
330,000
415,716 126%
415,717
126%
85,717!
110,000
85,100 77% I
85,100
77%
(24,900)'
1 - - 1
83,500
57,335 69% I
58,935
71% _
(24,565)
52,000 53,167 102%
52,000
53,167 102%
53,167
102%
1,167-
- - I
25,500
19,944 78% I
19,944
78%
(5,556)
- I
20,000
24,250 121%
24,600
123%
4,600
4,500
- 0% I
-
0% ;
(4,500)'
- - I
-
5,239 I
5,239
5,239
- (129) 999%
-
2,431 I
2,660
I
2,660!
52,000 53,038 102% ;
1,560,500
1,927,948 124% ;
1,930,309
124% ;
369,809:
Budget Actuals % Budget Actuals %
110,000 163,282 148% 155,959 33,276 21%
17,000 26,328 155% 1,312,172 1,301,554 99%
127,000 189,611 149% ; 1,468,131 1,334,830 91% ;
Budget Actuals % Budget Actuals %
75,000 75,000 100% 75,000 68,750 92%
1 - - 1 (150,000) (150,000) 100%
75,000 75,000 100% ; (75,000) (81,250) 108% ;
Budget Actuals % Budget Actuals %
Beginning Fund Balance - (47,461) 999% - (109,033)
I I 1
Resources over Requirements (75,000) (136,573) 92,369 593,118
Net Transfers - In (Out) 75,000 75,000 (75,000) (81,250)
I I 1
TOTAL FUND BALANCE - ($ 109,033) $ 17,369 $ 402,835 999% ;
A Projection reflects vacancy savings -- assumes Fair Coordinator is hired in July
Projection % $ Variance
36,788 24% 119,171, A
� 1 I
1,312,172 100%
1,348,960 92% ; 119,171:
Projection % $ Variance
75,000 100%
1 (150,000) 100%
(75,000) 100% ;
Projection % $ Variance
(109,033) a (109,033);
581,349 488,980;
� 1 I
(75,000)
1 B I
$ 397,316 999% ; $379,947:
oy uTESC 0G �{ Budget to Actuals Report
tA'c.�
-��W Fair &Expo Capital Reserve -Fund 617
FY22 YTD May 31, 2022 (unaudited)
91.7%
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
7,183
84%
7,490
88% 1
(1,054).
TOTAL RESOURCES
14,000
8,532
61%
8,544
7,183
84%
7,490
88%
(1,054);
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Materials and Services
235,000
16,910
7%
180,000
5,501
3%
10,000
6%
170,000: A
I
Capital Outlay
166,940
73,613
I
44%
388,000
(894)
I I
0%
(894)
E
0%
1
388,894, B
TOTAL REQUIREMENTS
401,940
90,523
23%
568,000
4,607
1%
9,106
2% ;
558,894.
TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance
Transfers In - TRT 1%
453,158
385,418
85%
428,901
393,151
92%
497,553 116%
68,652,
Transfers In - Fair & Expo
-
-
300,000
275,000
92%
300,000 100%
-
TOTAL TRANSFERS
453,158
385,418
85%
728,901
668,151
92%
797,553 109% ;
68,652:
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);
1
Resources over Requirements
(387,940)
(81,991)
(559,456)
2,576
(1,616) i
557,840.
Net Transfers - In (Out)
453,158
385,418
728,901
668,151
797,553
68,652:
I
1
I I
I
I
TOTAL FUND BALANCE
$ 1,208,442
$ 1,029,596
85%
$ 1,271,108
$ 1,700,323
134% ;
$ 1,825,534 144% ;
$554,426:
A The full M&S budget will not be spent this fiscal year
B Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction; received refund from a
purchase made in FY21
TES` 0G 2� Budget to Actuals Report
C.�
RV Park - Fund 618
FY22 YTD May 31, 2022 (unaudited)
91.7%
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%
475,000
475,698 100%
567,198
119%
92,198:
RV Park Fees > 30 Days
12,000
13,886 116%
10,500
8,499 81%
8,499
81%
(2,001)
Washer / Dryer
4,000
5,295 132%
5,000
2,861 57%
3,861
77%
(1,139)
Vending Machines
3,000
1,229 41%
2,500
959 38%
1,410
56%
(1,090)
Miscellaneous
2,250
2,679 119%
2,500
3,245 130%
3,625
145%
1,125�
Interest on Investments
7,600
1,636 22%
2,024
518 26%
540
27%
(1,484)
Cancellation Fees
5,500
8,825 160%
-
13,396
17,055
17,055
Good Sam Membership Fee
1,500
- 0%
-
-
-
-1
TOTAL RESOURCES
436,050
654,204 150% ;
497,524
505,176 102% ;
602,188
121% ;
104,664;
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Personnel Services
-
-
19,456
92
0%
100
1%
19,356, A
Materials and Services
321,402
291,093
91%
310,805
231,816
75%
268,520
86%
42,285!
Debt Service
222,500
221,874
100%
165,927
221,629
134%
221,630
134%
(55,703)] B
TOTAL REQUIREMENTS
543,902
512,967
94%
496,188
453,537
91%
490,250
99%
5,938;
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Transfers In - Park Fund
160,000
160,000
100%
160,000
160,000
100%
160,000
100%
Transfers In - TRT Fund
25,000
20,000
80%
20,000
18,326
92%
20,000
100%
Transfer Out - RV Reserve
(621,628)
(549,173)
88%
(132,042)
(121,033)
92%
(132,042) 100%
TOTAL TRANSFERS
(436,628)
(369,173)
85%
47,958
57,293
119% ;
47,958
100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 587,992 227,936 39%
Resources over Requirements (107,852) 141,237 1,336 51,639
Net Transfers - In (Out) (436,628) (369,173) 47,958 57,293
r i �
TOTAL FUND BALANCE $ 43,512 - 0% $ 49,294 $ 108,932 221% ;
A New FTE added to the FY22 budget, which has not been filled
0:
111,939 110,603-
m
47,958 i s
$ 159,897 324% ; $110,603.
A year-end budget adjustment will be required for P&I payments on Series 2016, which was inadvertently not included in Debt Service
appropriations
Q TES` 2{ pG Budget to Actuals Report
L�
.��®. RV Park Reserve - Fund 619
FY22 YTD May 31, 2022 (unaudited)
91.7%
Year Complete
Fiscal Year 2021 1 Fiscal Year 2022
RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance
Interest on Investments 1,100 7,787 708% 7,546 5,793 77% 6,250 83% _ (1,296)-
TOTAL RESOURCES 1,100 7,787 708% ; 7,546 5,793 77% 6,250 83% ; (1,296);
REQUIREMENTS
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Capital Outlay
100,000
- 0%
100,000
- 0%
0%
100,000, A
TOTAL REQUIREMENTS
100,000
- 0%
100,000
- 0%
- 0%
100,000:
TRANSFERS
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Transfer In - RV Park Ops
621,628
549,173 88%
132,042
121,033 92%
132,042 100%
-
TOTAL TRANSFERS
621,628
549,173 88%
132,042
121,033 92%
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
(98,900)
7,787
(92,454)
5,793
6,250
98,704!
Net Transfers - In (Out)
621,628
549,173
132,042
121,033
132,042
-
TOTAL FUND BALANCE
$ 1,012,728
$ 1,054,426 104% ;
$ 824,054
$ 1,181,252 143% ;
$ 1,192,718 145% ;
$368,664;
A Capital Outlay appropriations are a placeholder
and the full budgeted
amount is not expected to be spent this
year
Q`\\V'(ES(,,o Budget to Actuals Report
Risk Management - Fund 670
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Workers' Compensation
General Liability
Property Damage
Unemployment
Vehicle
Interest on Investments
Claims Reimbursement
Skid Car Training
Process Fee- Events/ Parades
Miscellaneous
Loss Prevention
91.7%
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
1,118,197 100%
1,120,766 100%
990,628
963,201
97%
944,278
862,376 91%
944,278 100% !
-
373,698
373,548
100%
393,546
375,460 95%
393,546 100%
-
323,572
315,619
98%
323,572
329,690 102%
330,000 102%
6,428, A
218,185
222,266
102%
227,700
208,725 92%
227,700 100% o
-�
87,200
100,030
115%
101,111
45,625 45%
49,060 49%
(52,051)'
50,000
39,428
79%
25,000
1,280,876 999%
1,300,000 999%
1,275,000, B
30,000
270
1%
10,000
- 0%
- 0%
(10,000); C
1,500
810
54%
1,000
1,350 135%
1,500 150%
500-
5
-
0%
-
180
250 a
250!
10
-
0%
-
-
-
TOTAL RESOURCES 3,263,646 3,239,580 99% 3,146,973 4,222,479 134% ; 4,367,100 139% ; 1,220,127:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
General Liability
1,100,000
466,547
42%
3,600,000
2,697,212
75%
2,800,000 78%
800,000, D
Workers' Compensation
1,560,000
912,395
58%
1,580,000
721,437
46%
900,000 57%
680,000-
Insurance Administration
584,104
408,666
70%
547,047
451,811
83%
561,274 103%
(14,227)! E
Property Damage
200,240
330,869
165%
300,245
290,765
97%
350,000 117%
(49,755); F
Unemployment
200,000
98,978
49%
200,000
62,071
31%
90,000 45% 0
110,000
Vehicle
150,000
173,925
116%
200,000
104,480
52%
200,000 100%
TOTAL REQUIREMENTS
3,794,344
2,391,380
63%
6,427,292
4,327,776
67%
4,901,274 76%
1,526,018:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Transfers Out - Vehicle
(3,500)
(3,500) 100%
(3,500)
(3,201)
91%
(3,500) 100%
-
Replacement
TOTAL TRANSFERS
(3,500)
(3,500) 100% ;
(3,500)
(3,201)
91%
(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
(3,280,319)
(105,297)
(534,174)
2,746,145�
Net Transfers - In (Out)
(3,500)
(3,500)
(3,500)
(3,201)
;
(3,500)
TOTAL FUND BALANCE
$ 6,465,802
$ 9,521,450 147% ;
$ 5,045,296
$ 9,412,952
187% ;
$ 8,983,776 178% ; $3,938,480;
A Unemployment collected on first $25K of employee's salary in fiscal year
B Reimbursement from excess carrier for Kozoswki lawsuit payout
C Skid Car training on hold due to COVID
D General Liability claims paid includes the Kozoswki lawsuit payout -- part will be reimbursed by excess carrier
E Projected Personnel overage based on YTD spending plus estimate for June
F Projection is based on YTD actuals which are high due to several vehicle crashes
Q`�J'(ES C0& Budget to Actuals Report
Health Benefits - Fund 675
FY22 YTD May 31, 2022 (unaudited)
91.7%
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
17,532,531 93%
18,767,900 100%
COIC Premiums I
1,600,000
1,642,789 103%
1,589,000
1,255,305 79%
1,527,305 96%
(61,695)'
Employee Co -Pay
1,031,400
1,205,713 117%
1,200,000
1,134,395 95%
1,135,000 95% o
(65,000)
Retiree / COBRA Premiums I
1,035,000
958,664 93%
1,060,000
1,113,525 105%
1,114,000 105%
54,000-
Interest I
216,200
193,598 90%
200,277
84,106 42%
93,310 47%
(106,967)!
Prescription Rebates
90,000
179,184 199%
128,000
285,579 223%
286,000 223%
158,000! A
Claims Reimbursement & Other
80,000
1,073 1%
82,000
1,487,600 999%
1,488,600 999%
1,4069600! B
TOTAL RESOURCES
21,884,538
22,761,820 104% ;
23,027,177
22,893,040 99%
24,412,115 106% ;
1,384,938;
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Health Benefits
19,937,274
19,126,362
96%
19,640,847
18,796,433
96%
24,271,305 124%
(4,630,458), C
Deschutes On -Site Pharmacy
2,417,092
2,972,758
123%
2,970,575
2,562,460
86%
3,403,572 115%
(432,997); D
Deschutes On -Site Clinic
1,101,467
1,087,809
99%
1,141,829
970,985
85%
1,228,374 108%
(86,545)- D
Wellness
164,340
149,145
91%
171,142
103,320
60% I
171,142 100%
- D
TOTAL REQUIREMENTS
23,620,173
23,336,074
99%
23,924,393
22,433,198
94%
29,074,393 122% ;
(5,150,000);
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)
459,843
(4,662,278)
1 1
(3,765,062);
1 �
Net Transfers - In (Out)
I !
6 I
!
TOTAL FUND BALANCE $ 13,588,094
!
$ 15,527,580 114% $
13,875,402
$ 15,987,422
115% $ 10,865,302
78% ($3,010,100
A Projection based on YTD collections
B Stop Loss insurance reimbursements for high dollar claims; invoices are trending up due to high dollar claims, but the expected amount is unknown
C Amounts are paid 1 month in arrears; County consultant anticipates claims will exceed budget due to delayed care because of COVID; year-end
budget adjustment will be required
D Amounts are paid 1 month in arrears; some expenditure line items expected to exceed budget based on YTD spending
oy`�uIESC�GZ� Budget to Actuals Report
911 - Fund 705 and 710
FY22 YTD May 31, 2022 (unaudited)
RESOURCES
Property Taxes - Current Yr
Telephone User Tax
Police RMS User Fees
User Fee
Data Network Reimbursement
Contract Payments
Property Taxes - Prior Yr
Interest
State Reimbursement
Property Taxes - Jefferson Co
Miscellaneous
TOTALRESOURCES
91.7%
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
9,909,198 101%
9,909,198 101%
105,619: A
` 1,106,750
1,441,364 130%
1,106,750
1,358,587 123%
1,358,587 123%
251,837: B
` 250,000
390,879 156%
236,576
237,221 100%
237,221 100%
645� C
` 73,000
110,978 152%
233,576
140,986 60%
233,576 100%
-
i
55,000
96,896 176%
162,000
236,946 146%
238,250 147%
76,250-
` 157,252
136,638 87%
147,956
151,302 102%
�
158,516 107%
10,560!
` 90,000
152,893 170 /o ° `
115,000
84,262 73% �
100,000 87%
(15,000)l
90,400
110,233 122%
96,867
63,889 66% � �_
`
66,720 69%
(30,147)�
83,000
° `
131,881 159 /0
60,000
°
123,282 205 /o
132,000 220%
72,000, D
33,637
36,598 109% �
38,344
379016 97%
38,344 100%
` 12,200
° `
121,920 999 /0
18,658
27,095 145 /o ` `
29,155 156%
10,497!
11,064,698
12,080,426 109% ;
12,019,306
12,369,784 103% ;
12,501,569 104% ;
482,263:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
7,620,458
7,190,545
94%
8,005,795
6,855,286
86%
7,480,286
93%
525,509- E
Materials and Services
3,476,381
2,912,246
84%
3,582,212
2,775,095
77%
3,557,212
99%
25,000!
Capital Outlay
1,480,000
431,457
29%
2,975,000
390,583
13%
600,000
20%
2,375,000! F
TOTAL REQUIREMENTS ;
12,576,839
10,534,248
84%
14,563,007
10,020,964
69%
11,637,498
80%
2,925,509:
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 8,341,418 9,162,894 110% 11,850,783 10,709,072 90% 10,709,072 90% (1,141,710);
Resources over Requirements (1,512,141) 1,546,177 (2,543,701) 2,348,819 864,070 3,407,771
Net Transfers - In (Out) - - -
s se i e
TOTAL FUND BALANCE $ 6,829,277 $ 10,709,072 157% ; $ 9,307,082 $ 13,057,891 140% ; ; $ 11,573,143 124% ; $2,266,061:
A Current year taxes received primarily in November, February and May; actual FY21-22 TAV is 5.58% over FY20-21 vs. 5.40% budgeted
B Telephone tax increased last year and payments are received quarterly; taxes collected are trending higher than budget
C Invoices are mailed in the Spring
D State GIS reimbursements are received quarterly; additionally the State approved a final reimbursement for the 9-1-1 phone system
E Projected Personnel savings based on YTD spending plus estimate for June
F A large portion of Capital Outlay spending will be pushed into FY23 because of land use permitting for radio sites as well as delays on necessary
equipment for the sites
v'(E S CO
�G2-A
BARD OF
COMMISSIONERS
MEETING DATE: July 11, 2022
SUBJECT: Envision Bend FY23 Special Funding Request: Follow up
BACKGROUND AND POLICY IMPLICATIONS:
At the June 6th, 2022 Board meeting, the Board of Commissioners reviewed several external
funding requests. One of those requests was from Envision Bend for $50,000 for the Bend
Vision project. During that meeting, the Board had additional questions, which have since
been answered by Envision Bend Executive Director Laura Fritz. The Board requested that
this item return to an upcoming Board meeting.
For further background, Ms. Fritz had presented to the Board of Commissioners at the
March 16, 2022 meeting, and materials from that meeting are attached to this memo. She
also provided a supplemental document, also attached, outlining how the project supports
economic development.
If the Board chooses to support funding this project or a portion of this project, staff would
recommend the use of video lottery dollars (in support of economic development
objectives), the general fund, or a combination of both.
ATTENDANCE:
Dan Emerson, Budget Manager
Laura Skundrick, Deschutes County Administration
April 13, 2022
To: Deschutes County Commission
From: Envision Bend
Re: Request for Funding to Support Bend Vision Project
Thank you for the opportunity on April 16 to make a presentation to the Deschutes County Commission
about the Bend Vision Project for the greater Bend area. This written document serves as Envision
Bend's formal written request for funding support of $50,000 from Deschutes County for this important
community initiative. The final result of this 16+ month project spanning December 2021-March 2023
will be a collaborative, forward -looking and exciting shared vision for the future of the greater Bend
area.
The Bend Vision Project will be a "whole -of -community," nonpartisan conversation emphasizing dialogue,
visionary thinking, inclusion and consensus -building. The target audience for our outreach and community
engagement is defined as the greater Bend area, including residents of the city of Bend, adjacent outlying
areas and unincorporated communities, and county residents who relate to or participate in the life of the
city on a regular basis.
Most plans are conducted by a single entity with a particular objective that benefits their organization or
furthers their own planning needs. The Bend Vision Project is a community -owned plan with no special -
interest agenda except to find agreement on a long-term vision for our community (10, 20, 25 years into
the future) and near -term actions to move us in that direction. The project is managed by Envision Bend,
an independent nonprofit organization that brings diverse stakeholders together to educate, engage and
empower all members of the Bend community to have a voice in our city's future. Once completed, the
plan will be implemented by project partners across the whole community, including government, civic
institutions, private businesses, civic organizations, nonprofits and residents. It will truly be a plan
created and owned by the community.
The project is unfolding in five phases encompassing research, outreach, dialogue (incorporating diverse
forms of engagement including interviews, listening sessions/focus groups, workshops, community
meetings and a survey), action planning, and plan development (see Envision Bend "Process Map" on
subsequent page).
The final major outcomes from this project include:
o Core Community Values statement
o Long-term ("generational") community Vision Statement
o Near -term (five-year) Vision Action Plan including specific actions, several "signature projects,"
identified plan partners, success measures (community indicators), and ideas for personal action
In addition to the larger 5-year Action Plan that will be developed to further the final vision and major
community initiatives, Envision Bend will create a "personal" action plan that will be available at the end
of the project. This plan will incorporate ideas that came out of the visioning process that individuals can
take on or incorporate into their own lives to help further the goals of the community vision.
Please refer to the next section, "Community Visioning Project Overview," for details about additional
project activities and outcomes.
Envision Bend's equitable engagement approach is a collaboration between our nonprofit organization,
local community partners that serve marginalized, hard -to -reach or under -represented communities,
and Oregon's Kitchen Table (OKT), a program of the College of Urban and Public Affairs at Portland State
University. OKT has deep experience in community engagement across the state. Their purpose is to
empower Oregonians from every corner of the state to contribute feedback, ideas, and resources to
decision -makers, public projects, and initiatives. Local experts and volunteers will be used in partnership
with OKT in our engagement process to ensure we reach traditionally marginalized communities, rural
irnirac and nannla %Aihn nftlan rhnnca not to ancya:i a in rnmrniinity nrniartc
The Bend Vision Project is a broad community conversation focused on high-level community
aspirations. Our project will be coordinated to align with, inform and support City and County planning
efforts. It is not a replacement for a comprehensive lard use plan or community plan. Our intent is not
to repeat, replicate or compete with other important planning initiatives or projects already in the
works. Rather, the Bend Vision Project will complement and accentuate information that can inform
policy -making and other planning efforts. We believe that the information we gather from interviews,
focus groups, a community -wide survey and other engagement efforts will be very useful to the County.
To -date Envision Bend has held several meetings with County staff to communicate about this project
and the County's Comprehensive Plan update, and we look forward to collaborating to ensure the
success of all our efforts.
When the Bend Vision Project is completed Envision Bend will take on a number of activities to help
ensure our community's vision is achieved over time. First and foremost, we will serve as a facilitator
and convenor to help ensure project implementation by lead partners who agree to take on initiatives
identified in the vision — partners such as local governmental entities, businesses and community
groups. We also plan to establish and monitor a set of "community indicators" in the plan which are
generalized measures of progress that will tell us if and how our community is changing for the better.
Finally, we will continue to serve as an ongoing voice and platform for community members to discuss
and take action on topics of vital interest to our future. Once significant progress has been made on the
first 5-year action plan Envision Bend will work with the community to update the next action plan for
the vision.
The total cost of the project is approximately $300,000. Envision Bend is raising all the funds for this
important community initiative. We have commitments from a wide variety of local business,
foundations, and institutions, as well as support from the City of Bend.
BEND
a
k
ON
PROJECT SHAPING OUR FUTURE
COMMUNITY VISIONING PROJECT OVERVIEW
Project Description, Activities/Outcomes, Key Features
Project Description
• A 16-month community visioning process with an overall focus on the future of greater Bend. (Greater Bend
defined as city of Bend, adjacent outlying areas and unincorporated communities, and county residents who
relate to or participate in the life of the city on a regular basis.)
• A "whole -of -community" conversation emphasizing dialogue, visionary thinking, consensus -building
• Five project phases encompassing research, outreach, dialogue (incorporating diverse forms of engagement),
action planning, and plan development (see Envision Bend "Process Map")
• Major outcomes include:
o Core Community Values statement
o Long-term ("generational") community Vision Statement
o Near -term (five-year) Vision Action Plan including specific actions, several "signature projects," identified plan
partners, success measures (community indicators), and ideas for personal action
Specific Activities & Outcomes
• Community Leader/Connector interviews (virtual)
• Summary of major community plans/policies most relevant to the visioning process
• Summary of key trends and potential strategic issues for greater Bend
• Robust outreach guided by PSU Hatfield School of Government 'Oregon's Kitchen' Table team
• Community listening sessions (virtual or in person, pandemic permitting)
• Online vision input survey (targeting >2,500 respondents)
• Community Input Report (summarizing all engagement to date)
• Community -wide visioning workshops including outlying areas (virtual or in person, pandemic permitting)
• Community vision summit event (in person, pandemic permitting)
• Online vision validation survey (targeting >1,000 respondents)
• Vision Action Plan publication(s)
Key Project Features
• Community -led and owned project
• Nonpartisan, independent of any single entity or interest group
• Reaching out to engage traditionally under -represented and unengaged groups
• Building consensus from many voices and perspectives
• Investing in the well-being of the entire community
• Broader focus than land -use and transportation issues ("whole -of -community")
• Designed to inform and supplement local government plans and policies
• Nontechnical presentation targeted at local residents and laypeople
• Linking and connecting the work of the City, County and other key community institutions
W;N
c c
cc is m
O �
'ed at
C Y C C C ro
O a 0 0 0 al
> d. > Q > ce
= O H C C
3
1
E V w m c W
m m p C
,.; a c c m a m 0 � -c
E 3 o E a®
O O 3 N fa m
N
04
f6 ro
V ro d N
C m
O
v v E
v u O C W'
E� �O
7
Ec
®1 C
E
C E° L
E
0- U
U®
• 0 0
U 1-. vi
® a
U>
0 0
i
Q
�
Q
J:
O
®
>,
;-'
O
E
O
E
C
nn
O
®
Ln
C
E
N
t
®
-0
w
u
®
-0
O
cv
LJ
.
4-0
O
ca
Ln
O
4--J
co
0
0
L
A
r
cog
n
' -J
coy
O
0
co
®
O
4
._
U
_
=
.®
,®
tlo
C
W
en
.0
O
®
4-J
ca
Lm
:3
>
-0r�
O
l
r
•
m
0
0
11
5
R2
�
�
�
�
�
§
�
�# )
�
}\\
/}
■_
2� \
MI
w
01-1.
w
2
Im
�� ��
�\
�\. � .�
� . �
« .� 3 —
\\ \ � . \ .: . \ . �
�� \ r .y..
+ < y� � �
� � 2 /
x � � » � � # � \
< f � ƒ ~ < ` $
� l � 7 � #
�� � : v y . . f i � ..a / r�
4 �\ } / \ �
. \ � � > j � � � \ � � *
� . \ � �� :
. � \ � § ~ \ �* � \ ~
« .: �
� . f � » �
.� � � � � ��
^ .» � * �
»
KAM
1
✓-'�.� �EFJD
PROJECT 'SWPat : O f triUU
ECONOMIC IMPACT OF THE BEND VISION PROJECT
Per the request of Deschutes County staff, Envision Bend is providing a broad overview of the economic
impact of the Bend Vision Project on Deschutes County. We are providing this information at a very high
level but have referenced a few resources and shared links to detailed reports that offer more analysis of
economic impact data relevant to this community -wide initiative.
Project Outcome: Community Vision Statement & First Five -Year Action Plan
Envision Bend is gathering community input and data in a variety of ways to create the community vision
statement and action plan. From the input and data already collected for this project we know that at
least one of roughly five or six focus/priority areas in the vision statement will focus specifically on the
economy, jobs and economic development. The first five-year action plan that will accompany the vision
statement will include strategies, projects and programs for this economic focus area that the
community would like to see in our future.
In fact, the economy likely will serve as a cross -cutting theme throughout the other focus areas of the
vision since it interacts and impacts other priority areas, and therefore must be addressed in conjunction
with those topics (e.g. transportation system, affordable housing, homelessness, etc.) Many of the other
focus areas in the Action Plan will have ties to the economy and to sustainable growth, including ideas
and efforts to make the greater Bend area a more resilient and healthy place to live, which has positive
economic impacts on the region. There also likely will be a focus area that incorporates education and
innovation that addresses emerging sectors of the economy, as well as environment/recreation which
plays a huge role in the economy in our county.
Impact of 2005/06 Vision Project
These vision projects have a strong history of having positive economic impacts on the region. Many of
the ideas and projects identified in the last vision project undertaken for Bend back in 2005/06 came to
fruition through the efforts of many community partners, resulting in tremendously positive economic
impacts on both the city and county. Some examples of ideas and projects put forward in the last
visioning plan that were realized include the development of a four-year university campus; creation of a
regional transit system; targeted industry development to diversity the economy; creation of locally
beneficial tourism activities; and creating new links between higher education, innovation and enterprise
through the OSU-Cascades' Innovation Co -Lab.
This goes to show that timely visioning is needed to identify the next set of community priorities to keep
a thriving and sustainable economy moving forward.
Economic Development Partnerships & Support
Envision Bend has lined up strong support from a very diverse group of entities for the Bend Vision
Project because they all believe that this kind of planning and consensus building will help our
community thrive as a vibrant place for people to live, work, shop and play. It should be noted that
several entities that are drivers of the Central Oregon economy signed up to be key partners for this
project. They include the Bend Chamber of Commerce; EDCO; St. Charles Health System & Foundation;
and Central Oregon Intergovernmental Council (COIC). These organizations see the direct benefit of
having an up-to-date community vision that can both support and guide their own initiatives and
strategic planning work for the future.
Intertwined Economic Impacts
Economic impacts are naturally intertwined with other factors such as community amenities, educational
opportunities, housing affordability and other quality of life factors. The purpose of the vision project is to
plan for the future of our community so that we can protect and improve the quality of life for Bend and
veschutes County residents..^Je expect that many of the topics that are intertwined with the economy
will become key parts of the vision statement and action plan as well.
One specific example of such topics is housing affordability. If low- and moderate- income households
cannot afford to live in our region, we cannot attract or retain the workforce that drives our economy.
This is why the Bend Chamber of Commerce recently decided to take on the issue of middle -market
housing affordability as their number one priority for our region. These and other topics ranging from
transportation, community infrastructure, workforce development, and more, will be part of the
community conversation to envision our future.
Summary
Central Oregon is one of the fastest growing populations in the nation. It also has some of the fastest job
growth in the US, as well as an economy that continues to expand and diversify. It's vital that our
community come together now, through the Bend Vision Project, to define the economic future we want
for our community, and then drive toward that future.
ADDITIONAL RESOURCES:
The Economic impact of Travel in Oregon (attached)
2021 Central Oregon Economic Profile by EDCO
https:Hedcoinfo.com/wp-content/uploads/2021/02/2021-Central-Oregon-Profiles 020421.pdf
Bend Vision Project Key Partner List (attached)
The Economic Value of COCC
https://www.cocc.edu/departments/institutional-effectiveness/more-facts/files/emsi-cocc-
executive-summary-2020.pdf
In 2021, the Oregon travel economy recovered much
of what was lost in 2020. Strong demand for overnight
accommodations and increased commodity prices
led to large gains in visitor spending. Based on the
U.S. Travel estimated impacts, Oregon is faring better
than the U.S. recovering to 85% of 2019 travel spend
compared to 78% for the U.S. (U.S. Travel).
Key Takeaways
• 64.8% Increase in Travel Spending
Travel spending in Oregon increased 64.8% from
$6.6 billion in 2020 to $10.9 billion in 2021.
• 6,900 Jobs Gained
Direct travel -generated employment experienced a
gain of approximately 6,900 jobs, a 7.3% increase in
travel -generated employment compared to 2020.
• 13.2% Growth in Travel Earnings
Direct travel -generated earnings experienced again
of $408 million, a 13.2% increase compared to 2020.
• 25.2% Increase in Tax Revenue
Tax receipts generated by travel spending are up
25.2% compared to 2020. State and local taxes both
experienced a strong recovery in 2021, growing
41.2% and 26.5% respectively.
• Residents of Oregon accounted for 38% of visitor
spending in Oregon in 2021.
U.S. residents of states other than Oregon accounted
for approximately 60% while international visitors
accounted for 2% of travel spending in the state.
Out -of -State visitors were approximately 64% of
travel spending prior to the COVID-19 pandemic.
In 2020 this share dropped to 42%.
• The largest region in terms of travel impacts is
the Portland Region.
In 2021 travel spending was $3.8 billion, contrib-
uting 35% of the state total. Prior to 2020 the Port-
land Region accounted for 44% of travel spending
in the state.
Tourism Regions Direct Spending in 2021
and % Change Compared to 2020
Access the executive summary and full report at:
industry. traveloregon.coml202lEcImpactReport
TRAVEL R�
LD OREGON
These preliminary estimates for Oregon are subject to revision Dean Runyan Associates
as more complete source data become available.
Our Bend Vision Project Partners are key organizations that broadly serve the greater Bend
area. They publicly support the importance of a shared community vision and work with us on
communications and engagement throughout the project.
Bend Bulletin
Bend Chamber
Bend LaPine School District
Bend Police Department
City Club of Central Oregon
Central Oregon Council on Aging
Central Oregon Disability Support Network
CO Intergovernmental Council (COIC)
ft�
EMPOWERING OUR COMMUNITY
0 CITY OF BEND
��no
CITY CLUB
Of .A 3ON
Deschutes County
Deschutes County Libraries
Economic Development of C.O. (EDCO)
Environmental Center
High Desert Food and Farm Alliance
Latino Community Association
Neighborhood Leadership Alliance
Neighborlmpact
St. Charles Health System & Foundation
B I I. I a
B E N D % A P 1 N E
3 C It 0 0 1 S
E DDO ATIN0 TN IIV IN CITI III.$
I
DESCHUTES PUBLIC
t'
LIRDA_D_V
HIGH DESERT
MOVE 75the FOOD
START environmental
FnCn A-101-0,e� crAI%JLA
= �=
center
COMMUNITY ASSOCIATION
Neighborimpact
St.rCharles
HEALTH SYSTEM
N�vT E S COG�a
I BOAR® OF
COMMISSIONERS
E
MEETING DATE: July 11, 2022
SUBJECT: FY 2023 Q1 Discretionary Grant Review
RECOMMENDED MOTION:
N/A
BACKGROUND AND POLICY IMPLICATIONS:
Each quarter, the Board of Commissioners reviews applications submitted to the Deschutes
County Discretionary Grant Program and makes awards accordingly. On July 13, 202Z the Board
will consider requests made for activities to take place beginning or about the first quarter of
2022-23.
BUDGET IMPACTS:
Discretionary Grants are made available through the Video Lottery Fund, which is supported by
state lottery proceeds. Discretionary Grant funds available during the first quarter were
budgeted for FV 2022-23.
ATTENDANCE:
Laura Skundrick, Administrative Analyst
DC
D
Ul