2023-61-Minutes for Meeting January 23,2023 Recorded 2/27/2023BOARD OF
COMMISSIONERS
1300 NW Wall Street, Bend, Oregon
(541) 388-6570
Recorded in Deschutes County
CJ2023-61
Steve Dennison, County Clerk
Commissioners' Journal 02/27/2023 9:38:25 AM
,\x\: fJ �C(� II' I I l'III'll II I'l I' II I'I'II
a fi 2023-61
FOR RECORDING STAMP ONLY
BOCC MEETING MINUTES
1:00 PM
MONDAY January 23, 2023
Barnes Sawyer Rooms
Live Streamed Video
Present were Commissioners Anthony DeBone, Patti Adair, and Phil Chang. Also present were Nick
Lelack, County Administrator; Kim Riley, Assistant County Counsel; and Brenda Fritsvold, BOCC Executive
Assistant.
This meeting was audio and video recorded and can be accessed at the Deschutes County
Meeting Portal website www.deschutes.org/meetings.
CALL TO ORDER: Chair DeBone called the meeting to order at 1:00 p.m.
PLEDGE OF ALLEGIANCE
CITIZEN INPUT: None
Commissioner Chang advocated allowing public comment on items that are on the current
meeting agenda, saying that it would make sense to permit timely input.
Commissioner DeBone said he appreciates hearing from constituents, and people are
welcome to call or email the Commissioners at any time or set up an in -person meeting. He
spoke to the potential effects of many people wishing to comment at a meeting on matters
unrelated to a public hearing.
CONSENT AGENDA: None
BOCC MEETING
JANUARY 23, 2023 PAGE 1 OF 5
ACTION ITEMS:
1. ARPA Grant Status Update: Neighborimpact Childcare Expansion Program
Laura Skundrick, Management Analyst, reminded that in October of 2021, the
Board approved several ARPA grants to Neighborlmpact to expand childcare in
the County. She introduced Karin Prow, Neighborlmpact Child Care Resources
Director, who provided an update on its Work Force Fast Track Teacher Training
project which recruits, trains and supports early childhood educators. Prow
spoke to the great need for early childhood teachers and shared information on
the partnerships built with childcare centers across the county.
Prow further reported on the small capacity grants which will be distributed by
Neighborlmpact, saying that all childcare providers in the county were contacted
to determine their interest in participating. She concluded that the Pathways
project continues to recruit and support early childhood educators in
partnership with other organizations such as WorkSource Oregon.
2. Economic Development Loan to Tiny Watts Solar
Jen Patterson, Strategic Initiatives Manager, explained the request from Tiny
Watts Solar for an economic development loan in the amount of $12,000. Loans
made from the County's Economic Development Loan Program are conditioned
upon the business creating a specified number of new jobs within 12 months,
then maintaining those new jobs for a consecutive 12-month period.
Patterson introduced Steve Curley, REDI Director (EDCO) and Bruce Barrett, who
serves on EDCO's Due Diligence Committee. Curley described Tiny Watts Solar as
a Redmond -based company that provides off -grid solar power solutions. They
specialize in lithium battery solar power kits for conversion van vehicles, the
marine industry, and other off -grid applications. The company sells 90% of its
products outside of Central Oregon.
Barrett shared how EDCO has coordinated with Tiny Watts Solar to achieve
efficiencies and increase marketing of their products.
CHANG: Move Board approval of the request from Tiny Watts Solar for an
economic development loan in the amount of $12,000
ADAIR: Second
VOTE: ADAIR: Yes
CHANG: Yes
DEBONE: Chair votes yes. Motion Carried
BOCC MEETING JANUARY 23, 2023 PAGE 2 OF 5
3. Treasury and Finance Reports for December 2022
Robert Tintle, Chief Financial Officer, introduced Bill Kuhn, County Treasurer.
Tintle presented the treasury and finance reports for December, 2022.
At 2:09, the meeting was recessed until 3:00 to accommodate the attendance of
Commissioners DeBone and Adair at another meeting.
The meeting was reconvened at 3:07 pm.
4. Preparation for a Public Hearing: Commercial Activity in Conjunction with
Farm Use (Meadery on Highway 20 near Sisters)
Nathaniel Miller, Associate Planner, provided background information in
advance of the upcoming public hearing involving commercial activity in
conjunction with farm use. The applicant seeks to obtain a conditional use
permit to establish a meadery (honey winery) with associated uses in the
Exclusive Farm Use Zone. The location of the proposed meadery is 68540
Highway 20 on land owned by the applicant.
Responding to Commissioner Chang, Miller said some regulations in Oregon
state law which apply to uses that involve growing grapes to make wine do not
apply to uses that involve keeping bees to produce honey to make wine.
In response to Commissioner Adair, Miller said the owner uses the rest of the
property for hay production. Miller emphasized the Hearings Examiner found
that the applicant had not satisfactorily demonstrated that the meadery use will
be incidental and subordinate to the property's farm use.
Commissioner Chang asked to know how much honey is needed to make any
amount of mead, and in turn, how many bees or hives are needed to make that
much honey.
Chair DeBone noted the consensus of the Board to allow 30 minutes during the
public hearing for the applicant/appellant, and three minutes to other parties
who wish to testify.
S. Deschutes County Outdoor Lighting Ordinance
Tarik Rawlings, Associate Planner, sought direction from the Board on next steps
to take with respect to the County's Outdoor Lighting Ordinance. Rawlings
reviewed that last year, the Board directed staff to pursue dark skies best
BOCC MEETING JANUARY 23, 2023 PAGE 3 OF 5
practices and policies as rt of (he County 2040 CoT,prehensive Flan
Update process. The Bc;rd subsequently expressed support tor revisiting DCC
Chapter 15.10 as a standalone work item, emphasizing educational outreach
efforts rather than code enforcement responses.
Commissioner DeBone expressed his support for education and outreach
efforts and asked how the County can best share information and engage
people on this topic.
Commissioner Chang agreed that education and outreach are important. He
suggested partnering with Visit Central Oregon and using social media, TV and
radio advertising in addition to targeting group gatherings such as homeowner
associations, block parties and the Fair.
Commissioner Adair noted her appreciation for some of the restrictions adopted
in 1994—for example, the limited time that motion sensors can remain on once
activated. Commissioner Chang said some updates may be needed to address
technology advances since 1994.
Will Groves, Planning Manager, advised assembling a stakeholder panel to
explore different ways of approaching this subject at various levels of regulation.
Commissioner Chang said in addition to involving the tourism industry, the
County should incentivize change -outs of outdoor lighting with discounts or
rebates.
County Administrator Nick Lelack suggested possibly using the Futures Fund
program for outreach, education and incentives.
Commissioner Adair noted the existence of valid reasons to have some lighting
at night —to illuminate flags and home addresses, for example.
Chair DeBone noted the consensus of the Board to direct staff to convene a
panel to gather input and develop draft updates to the Code.
OTHER ITEMS:
• County Administrator Nick Lelack reported the request for a Commissioner
to speak at the statewide tourism conference in April; the Board concurred to
appoint Commissioner Chang to this role.
• Chief Financial Officer Robert Tintle said an item on the Board's upcoming
consent agenda will ask for authorization to establish a checking account for
the Sheriffs Office. Tintle explained this is being sought in response to an
BOCC MEETING
JANUARY 23, 2023 PAGE 4 OF 5
internal audit and will enable transactions to be tracked electronically rather
than manually.
• Commissioner Adair reported on the Eastern Oregon Counties Association
meeting this afternoon.
• Commissioner DeBone said he will participate in a phone call tomorrow
morning with Senator Findley and others.
• Commissioner DeBone noted interviews will be held tomorrow for the
position of IT director.
At 3:54 pm, a brief break was announced. The meeting reconvened at 3:58 to recess into
Executive Session.
EXECUTIVE SESSIONS:
At 3:58 p.m., the Board went into Executive Session under ORS 192.660 (2) (e) Real Property
Negotiations. The Board moved out of executive session at 4:34 p.m. to direct staff to proceed
as discussed.
At 4:34 p.m., the Board went into Executive Session under ORS 192.660 (2) (h) Litigation. The
Board moved out of executive session at 5:04 p.m. to direct staff to proceed as discussed.
ADJOURN:
Being no further items to come before the Board, the meeting was adjourned at 5:04 p.m.
Q..rr�.
DATED this t! Day of
ATTEST:
RECORDING SECRETARY
2023 for the Deschutes County Board of Commissioners.
ANTHONY DEBONE, CHAIR
PATTI ADAIR, VICE CHAIR
PHIL CHANG, COMMISSIONER
BOCC MEETING JANUARY 23, 2023 PAGE 5 OF 5
BOARD OF
COMMISSIONERS
AGENDA REQUEST & STAFF REPORT
MEETING DATE: January 23, 2023
SUBJECT: ARPA Grant Status Update: Neighborlmpact Childcare Expansion Programs
RECOMMENDED MOTION:
Informational item
BACKGROUND AND POLICY IMPLICATIONS:
In FY21, Deschutes County was awarded approximately $38.4 million in American Rescue
Plan Act (ARPA) funds through the Federal government. On October 20, 2021, the Board of
Commissioners approved several ARPA grants to Neighborlmpact for the purpose of
expanding childcare in Deschutes County. The Board of Commissioners has since
requested updates on childcare projects that received ARPA funding, and this will be the
fourth in the series of childcare project updates.
During the January 23 meeting, Neighborlmpact will provide the Board with updates on the
childcare expansion projects that received ARPA funding. The written update is attached to
this memo.
BUDGET IMPACTS:
None
ATTENDANCE:
Karen Prow, Neighborlmpact Child Care Resources Director
Laura Skundrick, Deschutes County Management Analyst
Deschutes County Early Care and Education Work Force Update
December 27, 2022
Karen Prow
Work Force Fast Track Teacher Training (WFFT)
Cohort 2
Timeline: Start Date: 10/26/22, End Date: 04/18/23
Participant Data (Infant/Toddler Track)
Provider
Provider Location
Number of Candidates
Bright Adventures
Bend
1
Boulden-Rogen
Bend/Redmond
8
TOTALS: 2 Providers
9 Candidates
Participant Data (Preschool Track)
Provider
Provider Location
Number of Candidates
Bend Preschool
Bend
1
Bright Adventures
Redmond
1
ReVillage
Bend
3
The Cottage
Bend
2
TOTALS: 4 Providers
? Candidates
Work Force Fast Track Participant Feedback
"I'm happy and grateful for the opportunity, the fast track offers a very good resource to help
our community and the teachers are very involved teaching and very helpful. Thank you to all
the teachers for be there." - (candidate) This Teacher Candidate joined the Work force fast Track in the
SOW, Her Central Background Registry took /anger than typical and she didn't have a placement site. Because of that
small bump, we had to put her on our list far fall. Once she was cleared, she joined the team at Relge in cohort2 She
migrated from Mexico when she was a teen, worked in fields and farmlands for some time and then at McDonald's for a
gaff dstretch. l want to say 10-15years. She shared that her children are grown, and she is at a stage of life that she
wants to try new things The Pathways Navigator led her to the WFFT. She is thriving and an her way to a new career path.
"First of all, every person who I have been in touch with regarding this program has been
excellent; you, Mary, Ty, Dina, etc. Really professional, resourceful, kind, supportive and, in
general, amazing! My two candidates did not have a lot of confidence when they started this
program, but I see now that they are gaining it through your personal attention and
the resources. I see them growing and changing; I see they are more empathetic with the kids;
I see that they realize that each child has a backstory and every family needs support of
different types. I think their perspective of the kids has changed and that they just have
more understanding of how a child's early years affect their entire lives. Due to that, I think
they feel that their jobs are more important than ever and that the work they (and we) are
doing is important and beneficial. I think also that whatever I have tried to teach them, you
have filled in the gaps with completely different perspectives and resources." (Director)
"1 am enjoying the program so far! I appreciate how involved the instructors are with us and
the program. Some things that are helpful in this program are the guest instructors because
they have a lot of information such as ACES which really brought in the perspective of how
we shouldn't punish a "troubled" child. We are not aware of what is going on at home and
how they are mentally. I'm hoping to learn more in these next months." (candidate)
"So far my schools experience with the fast track program has been exhilarating! Not only are
my teacher Candidates growing and becoming amazing teachers, but their confidence is also
boosting from the trainers/coaches. The trainers (coaches) coming to our program has been a
blessing, and I see a difference in our classes already with the suggestions from our trainers
(coaches). I absolutely love the directors track as well and feel like I have grown as a supervisor
and leader." (Director)
"I am really enjoying this program! I love how simple the trainings are, yet I still feel like I'm
learning a lot from them. Also love that I get credit just by coming to work!" (candidate)
"I really like the WFFT Project. I am able to review issues with the WFFT (Fast Track) Coaches
and feel supported. If our programs have questions on a variety of topics, I like that we can
problem solve together with the WFFT Team and come up with some action plans. I like that
the Teacher Coach and the Teacher Candidates (TC's) have a mentorship whereby the TC's can
come to the coach and share their growing questions in the profession, and we can have a team
meeting as needed." (Director)
"This program means so much to me. The most important thing is the continued support that I
can run my issues by and get professional advice. I really like the book work and I personalize it
with Diane to ask questions that pertain to my program. Mary is great and getting together
with other directors is very helpful. I am so grateful for the WFFT Project" (Director)
Small Capacity Grants ($500,000)
Received by NI 12/6/22
Current work:
• Request for Interest sent to all providers in Deschutes County
• 35 completed interest forms submitted
• Requests include expansion within these 35 programs of 743 capacity (which is beyond
our finances, so we will narrow down our application pool)
Next steps:
• Reviewing all applicants for feasibility of project
• Look for greatest impact on expansion per dollar cost
• Look for projects within interest to ensure impact across county
• Invite applications for funding within our $500,000 limit
• Identify barriers to success for each program and support/connect with solutions
Continued work after funding:
• Ensure each funded program receives sufficient business coaching for success
• Ensure each funded program has access to the Work Force Fast Track if needed
• Ensure each funded program is offered access to Shared Services and Continuous
Quality Improvement team and ongoing professional development
Pathways Project
Our Pathways Navigator has continued the work of recruiting and supporting early educators.
• Recruited 10 students for College Pathways. AAOT, BA/BS
• Supported recruitment for NI/SBDC training
• Supported recruitment for Fast Track Teacher Candidates
• Recruitment at local events and community meetings
• Continued work with LCA
• Continued work with local high school programs
• Continued work with WorkSource Oregon
• Planning for larger recruitment campaign in January 2023, including advertising and
media
BOARD OF
COMMISSIONERS
AGENDA REQUEST & STAFF REPORT
MEETING DATE: January 23, 2023
SUBJECT: Economic Development Loan to Tiny Watts Solar
RECOMMENDED MOTION:
Motion to approve the request for an economic development loan in the amount of
4t;0'Ori to Tiny Watts Solar.
BACKGROUND AND POLICY IMPLICATIONS:
The Deschutes County Economic Development Loan Program was initiated to encourage
and assist companies seeking to relocate to and/or create newjobs within Deschutes
County.
Loans are conditioned upon the business creating a specified number of newjobs within
1 2 months, then maintaining the new jnhc for a ronceri im tive 12-onth period If these
� �
terms are met, the loan may be converted to a grant that does not require repayment. If
these terms are not met, all or a portion of the funds must be repaid with interest of 5%
per annum.
Tiny Watts Solar is a Redmond -based company that provides off -grid solar power solutions.
They specialize in lithium battery solar power kits for conversion van vehicles, the marine
industry, and other off -grid applications. Tiny Watts Solar currently has four employees and
is planning to expand. As described in the attached briefing paper, Tiny Watts Solar will
agree to create five newjobs with an average wage of $76,960 per year in return for a loan
of $10,000.
BUDGET IMPACTS:
Loans are made from the Economic Development Loan Fund which currently has a balance
of $282,600. Tiny Watts Solar is requesting a loan from that fund in the amount of $10,000.
ATTENDANCE:
Jen Patterson, Deschutes County, Strategic Initiatives Manager
Steve Curley, REDI Director, EDCO
Bruce Barrett, EDCO, Due Diligence Committee
BRIEFING PAPER
Tiny Watts Solar
Request for Deschutes County Economic Development Fund (DCEDF)
Company Request: $10,000
EDCO Recommendation: $10,000
Application Date: April 17`h, 2022
Proposed Job Creation within 24 months of application date: 5 new employees
Average Pay for New Employees (all positions, excluding commissions): $76,960
Industry: Outdoor Products - Off grid solar kits for vans
Website: https://tinywattssolar.com
Company Background:
Tiny Watts Power Solutions was born from the desire to make solar power easier for anyone
wanting to power their system off grid. They personally test all their products and design
them to use the components most effectively, so their system is safe and easy to install to get
off grid faster. All of their products are backed by ABYC certification, and come with a five-
year product guarantee.
Tiny Watts provides off grid solar power solutions. They specialize in lithium battery based
solar power kits for the recreational conversion van vehicles, the marine industry and other
off grid applications. They want to make the transition to off grid solar power for mobile
applications easier and safer. By pre -wiring their power centers, they remove 80% of the
work making it an easy install for a DIYer or a quick install for and OEM solution. In
addition to building the kits, they support their clients with installation videos, tech support
and a five-year warranty. They are based in Redmond, Oregon, but have customers
throughout the US. Central Oregon is an outdoor adventure mecca, has a high concentration
of conversion vans per capita and is a great location to service their primary west coast
clientele. They manufacture,assemble and ship their kits from their facility in Redmond but
also offer local sales,will call and installation of their products.
Tiny Watts is currently located at 375 NE 11 th Street, suite 300, Redmond, OR 97756 in a
1000 SF leased space and is owned by Wes and Savana Watts. EDCO has been working with
Wes and Savana since the Spring of 2022 when they opened their shop in Redmond. We
have provided access to incentives and financing, pitch coaching, mentoring an have been
featured on our PubTalk stage. In addition, several introductions have been made to local
companies helping them establish an efficient supply chain.
EDCO Recommendation
The Redmond DCEDF due diligence committee had an opportunity to meet with Wes and
Savana twice this year. The first meeting occurred in April with the due diligence committee
including Bruce Barrett, Real Estate Broker with Windermere and a business mentor with
SCORE; Craig Hunt, VP, SBA Lending Specialist with First Interstate Bank and owner of
the Polar Bear Shell Gas & Wash; Rick Bailey, CFO at Avion Water Company and Steve
Curley, EDCO's Director for Redmond Economic Development, Inc. The company
provided an overview of the business, their products and history of how the business got
started. The committee was given the opportunity to review current financial statements and
determined that Tiny Watts needed more time to create and implement a marketing plan to
increase revenue and stabilize their financials.
A second meeting took place in November with the committee, which reviewed the
financials again. The committee was pleased with the progress made and is recommending
along with EDCO an award of $10,000, or $2,000 per job, to be created by April 17", 2024
(24 months following the application date).
Conditions include:
• Company employs 5 FTE in Deschutes County by April 17', 2024 and maintains
that employment for any 12-month period before April 17`'', 2025.
• Company provides quarterly employment reports and the ability to inspect complete
financial statements from award date through termination of the yet -to -be executed
agreement with Deschutes County.
Failure to meet the above provisions would result in partial or full repayment of the loan,
with interest.
0SES
0
BOARD OF
COMMISSIONERS
AGENDA REQUEST & STAFF REPORT
MEETING DATE: January 23, 2023
SUBJECT: Treasury and Finance Reports for December 2022
ATTEN DANCE:
Robert Tintle, Chief Financial Officer
Bill Kuhn, County Treasurer
DATE:
TO:
FROM:
SUBJECT:
MEMORANDUM
January 18, 2023
Board of County Commissioners
Robert Tintle, Chief Financial Officer and Bill Kuhn, County Treasurer
Treasury and Finance Report for December 2022
Following is the unaudited monthly finance report for fiscal year to date December 30, 2022.
Treasury and Investments
• The portfolio balance at the end of December was $328.3 million, a decrease of $26.5 million from November and
an increase of $39.6 million from last year (December 2021).
• Net investment income for the month is $563,222 approximately $80K more than last month and $451K more
than December 2021. YTD earnings of $1,987,685 are $1.2 million more than the YTD earnings last year.
• All portfolio category balances are within policy limits.
• The LGIP interest rate increased from 2.85% to 3.10% on 12/8. Benchmark returns for 24-month treasuries are
down from the prior month by 10 basis points and 36-month treasuries are down from the prior month by 4 basis
points.
• Average portfolio yield is 2.13% which is higher than the prior month's average of 2.12%.
• The t lio's weighted time to maturityt1.37 compared to 1.33 in November.
pvrtivtiv � average is ar. years
Portfolio
Municipal Debt
Corporate Notes
Time Certificates
U.S. Treasuries
Federal Agencies
LGIP
First Interstate Bank
Total Investments
Pa
Value by Investment Type
47,965,000
56,372,000
1,245,000
72.000,000
115,965,000
22,886,387
11,824,430
$ 328,257,817
14.6%
17.2%
0.4%
21.9%
35.3%
7.0%
3.6%
100.0%
Total Portfolio: By Investment Types
First Interstate
Bank
3.6%
Municipal Debt
14.6%
$120
g $100
5s0
560
640
$20
$-
$11.5
DA
Davdson
Portfolio 6y Broker
533.4
Robert W
Baird & Co
549.0 S49.4 $49.7
Moreton
Capital
Markets
5100.4
Piper Great Castle Oak
Sandier Pacific
Securities
Investment Inca
Total Investment Income
Less Fee: $5,000 per month
Investment Income - Net
Prior Year Comparison
Dec-21
Dec-22
568,222
(5,000)
563,222
111,956
Y-T-D
2.017,685
(30,000)
1,987,685
764,741
Category Maximums:
U.S. Treasuries
LGIP ($56,763,000)
Federal Agencies
Banker's Acceptances
Time Certificates
Municipal Debt
Corporate Debt
100%
100%
100%
25%
50%
25%
25%
Maturity:(Ye
Max
3.874
Weighted Average
1.37
FIB! LGIP
Investments
Average
Yield Percentages
Current Month
3.10%
1.77%
2.13%
Prior Month
2.85%
1.73%
2.12%
enchmarks
24 Month Treasury
LGIP Rate
36 Month Treasury
4.41%
3.10%
4.22%
Minimum
0 to 30 Days
Under 1 Year
Under 5 Years
10%
25%
100%
13.3%
38.8%
100.0%
Othei
roll
Actual
Corp Issuer
Callable
Credit W/A
5%
25%
AA2
3.0%
16.3%
AA1
nvestmentActivity
Purchases in Month
$ 4,395,000
Sales/Redemptions in Month $ 4,930,000
24 Month Historic Investment Returns
5.50%
5.00%
4.50%
4.00%
3.50%
3.00%
2.50%
2.00%
1.50%
1.00%
0.50%
0.00%
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Three Year Portfolio Balance
400,000,000
350,000,000
300,000,000
250,000,000
200,000,000
150,000,000
100,000,000
50,000,000
,°' ti0 ti0 10 10 1° 10 1b tiY titi ti~ titi titi titi 1L titi .1 - 1L titi
De''' PQ` ��� P�� p� O6"«tee QQc ��o P�� O�� Qe� 4�� PQc ,Jo PJoo OQ,`
20,000,000
18,000,000
16,000,000
14,000,000
12,000,000
10,000,000
8,000,000
6,000,000
4,000,000
2,000,000
Five Year Maturity Distribution Schedule
Dec-22 Apr-23 Aug-23 Dec-23 Apr-24 Aug-24 Dec-24 Apr-25 Aug-25 Dec-25 Apr-26 Aug-26 Dec-26
- II 1--
r
2
0
(0
.0
a'
0)
0
N r 0)
CO
0
O 0))
d.
N r
0LO
oo' ri
O o
N N
CO
0)
CO
d
N
0 O) CO rn N O 0!I m:0 0
NI
0'0 r CO CO(� CO ICO O cm
co co CO 0�_ D7 O N O 0m Ln O
m 0 0 m,,- N rn N N m N M
() rn 0 rn rn rn'rn co o;m i- r rn W co-
I- m
N 0) O) Nlrn rn rn d_ 00 rn 0
N- r N r ` r rl lr
r , I
O 0 0 O O O!0 0 0 070 0 0 0 OI010 O
0 0,0 0 0 0 0 0 0 0,o O O o 0 0lo O
0 0 oIo 0l0 0 0 0 010 o O o 0 0 0l0
rn 0 0 ,N 0 0 0 0 0 0 0 0 0 0 00100
() 0 0lr 0 010 O O 1,O O 0 O O$0 010
NIO O I- 0 0 0 0 0 NIO 0 010 0:I010I0
N N r1N NIN r Ni ''N M NIr N N N!N
I I
r j 1 I:__
0')1d' 0 10) rn ;(10 0') (0 Njl0 10!rn 0 OIrn
(0 O OIIN N OI(0 m CO 0;(O O N 7 1 O m 1N-
0 C0 MI(0 rn 0I
O 0 N 0,m .<0 <0 O W 0 m 0) o1M O CO IIm
O 0 0 0) 01 .m N 0i(0 m d' 0 O
N h (0:co "m O t0 d' co (0 M 0iIn MI0
(OIrIN O1lci OIN d' rn M 0) d' NIO I�,M
O N OIOIO NI,M d'(�Irn M IN d O.O
0M Id'IN M 1I
I M j N -. ..._
(0) M,t0,t0 O 1m O rn 0) m co(0 olr- t0 N
rn M M N;., I' Ir N (00) O N I�I',N r C)
Old' M d'rnN ON N M M
N16,6181 M O CIO
(0 Im I
I M
d.
1
m0
00 M
0
O O
N N
a
0
a
0
Q I_Q
a
m
M M M
N NIIN
(00)
(0
a
0
M
O
O
N
r 0) r 0 r
N NIN N N
O O l0 O O 0
N N N N N N
O (0 0- 0)
r
p J LU
J J ~3J
w((0 I(n1:a10cco
0I0 o_IU <0 02',0
CO'N
m 0 (0. mimic--
coCOI co rn O'., r M
"I w1
0 u)
D
0(
is w U
0
C
0 0
T E N l I O.
p . cOI
M,M M M
O OIO 0
N_ONN N
'N N:
IN NI
TWI NN NN N
N N N N N ;N N
0,0 O 0 01010
NIN N N NIN N
W,r r1N al(0 C)
7IrnIN
O r10 r
(0
(0
a,
0 <0
M CONI M,M M1,N N
0 0 0 0 0 0 0
N•N''.N N N N N
n O O miM O
M 3N•M'
N N: N N N IN•N
0 0 000!0 O
N N:N NIN':IN N
rn O'. O) M rn M
0 0 O OI'I� rn
jW
(01 �
0la 0
11
a N Y Yj
N N 0
a a;U o) m 01 miv
a
0 o'w aIc
U Ui1r 2 'I UQI I pI(0
010'o °1E > 0KI=il0 2i E1,°l 3I2
Y a a;.,, go1ZIw'' a) ro ro L I O)(i a1°i a'm a). E
m10I- 7,I�IoH r0r''rl-15 mI-I-
(n l Fa! 1 m m 0 vi , co l vi F l v).1 u) v).1 .1 0 "0.
w0)=c,rn0Q11MZ1::<-M�8cco
c
7 m m a a w _� U> w1
V l rn i rn O o) O t0 co 10 X
aS 0 0 rn olZ (}011lcooIIO 011,4z (a11(o ccoo YIIY c U
0 0 O.,I� M M rnlrn rn t0 rn rn rn M (0 N N
M t0 t0 r t0 00 ('4 (0
� IL N r 0 I 0 rn aft d' M M rn 0 h I0 d
COICO
M O O D MIM N N N m;N N N MM M O
r m rn a) N _
O 010 d r m
rn
O N N CO0 M M N 0
3co
IW
J
a;O
a
as
(0
io CO CO
N N N
0 0 0
N N N
0 `.0
IQ
t0 N r M co(� coM h (0 i0 Ln O r N d (0 t0 d 0 0)
N 0) OlN1N r'. NIO MiN N M VIA N d N I^
0 O
11
cola a,a�aa a
a
(0 0) (0 O 0 tLc)O M 0
COrn rn OD: O 0 M 7
r N NINININ N N
CO CO:CO M M
N N N N N
0 0 0 O .0
N N N NIN
(O O (0 d
CID
N
N
0
M
N
O
N
N
O
N
(0-
CO
1
o o 0 0 0 '0 0 0 0 0 O O i0 0 10
O O 01001o10 O 010 0 O OIO10
o'o, coo 0 0 0 o 0 0 o old
000000oolosn04I000
N O 010 Olio O 0 0,N 0 000 0 0
N N N NIN NI(0IN1 N[N N;N
I I
caIrchcalca co
<<<ca << j<
N rn 0)
(0 co .0
N N:N N N N'.NM
II L
M M M M M ,M COM M M M
N N N N N .N N N N N N N
010,010101010
O o 0 0 0
N N N N N N N N N N N N
d'.Vld'rnr 01� 0 N rn O
N-N N.N 0) N M
0 r",,I) OW'.i 0Iml0 rn 0
r r 0 N.01N r 0 0 N r
rn
N N 0 NIN N N N N N
0 0 0 0 0 '1 0 0 0 0 :O O O
N;NININ IIN NIN N N N
rn d';M 0 m M.O rn r
0 NNN 01N p) N rM N
'1 1`,N rn r
r'NIm O n O
�I I
Z
I- U DIH IHII I- K
ma co m m
a s{a alcolco alv) 0 0 a
U 00 U a_Ia_ U a aIaU2
h,J �' Z =1-illy
1000o '0;0IUIiZ IOIOIlOIU
10 U UO O 0I
U UU U1<'IU0IK ¢ w�¢Iar �Iaa1a � Oa
0) 'IV M m 0) OfN- od 00 0I` O ar(O
N- N (0 o- O V0 rn10 Vrn N o10 rn O 0010
0Iti o0 olmmrnlrn (om cpmrnl)I< m rn ooloorn m
OooOo'Oo 0 000010 1
' o O
Z Z Z Z
,>22
(0 0 0 0)
M M O C0
m m 0- m
o'o oo
W
J
al0)
a a
1
>' 1
W v) I 0 I-
m W 0 F pK i
0 W 'Z (n
a'a Z u) 1 ! 1 a s lU U O
lalZ cc Z o cl I� c,c oIm'•
UY'Nlc =I0 !'m1c1
O
0
M
(0
CO-
0)
I1 I � I i jl-11-L
CO t0;0 h 0mO
O) N10 O 0Irn10
t01:0(O.0010,4110
N I) 0) O o0 OINIr
010) NIO rnirn'
r r M
II
0 CO 0) O' M, 1 010 00 CO CO OD cO
0) 0 M 0 OIM N 0) 4 0 N COO) N CO1 CO 0) COI 0 0) 00 N. 0) m 0
CO 0 m r N (0 0IOI0 N) (0 (010'(O
O O O CO 0) 101o 0) 10 0N.) O O 10)
rn O) O N o-:
0:rn rn m t0 rnIrn
r(0 1-
0!
CD;
N
CO
co
M
rn
I0`N-10 f"- CO O t0 0
N , 0 d' O II O
O 4 (� O I� rn CO 0 rn
co c4. coo M O N 00)'! c0O d' 00))
0) O) tf) o O co d t0 O)
r N r of lr N r
rn
d'
0)co
V
(0)
CO
N
d
0,0 0 0,0,0 0;0 0 0,0 0 0 0I 0,0 CD 0,0
0 0[0 0:0 0 0 0 0 0 0I0 OIO 0,0 00,0
0 0 0 0101010 0,010 0j0 0 0 0,0 0 0 0
(0(0 0 0,0 0 010,0 0010,0 0 0[0 01010
mN-
0 0;0 O O 010 O O;0 010 O 00
O O'O OIN OI 3-0 <0 010 10101(0 010 O 011(0
N N N M j N ;r r N N I N r 0) r N
•
O
(n
rn
N
r
CO
0)
V N'10
O CO O
CO 0
O N 0
0 0
00)) O
O�0
0 0
oo
N ri
0
N
N
N
N
CO
N
N
010 O O O 0
010 0 0 0 CO
O 0) O o N !�
0 0 0, O'. W m
O O) OI O co 0)
010100 rn 0)
0• NIN rl7
m�0 O) N
( 010'I-
t0 MI(O0
(OIM 0,010
0 M m rn N
rn rnl0 rnj0
0
M
m
V
(0) 0
W O
N N
(0
N
O
(0
m
IS M O IL COIN CO
0 OD 0) CO '0)
M '0) V'M rn CO N
N ' N '0) CON O)
N!00 O) m
0) 00 0) I� rn d) rn
• NIr,
N N r10 to m 0) N O(0 t0 rn O CO i N (0 CO 0) COIN ; 3-10
N (0 N rn N rn 11 0 0100[N,0) M 10) d' () m i) d m: M
M 0,0 m 0 00 0'04,014(0 CO m 0Irn N (0 010
C0 rn 0 O r:O <0 MI10 o 0 O NIO ml(0 (- 0 M O
m o to 011(" o d 0 (010 0 o O v OIr ('-O co o
0 0-Irn 01 (o'0 N N CO r M tO M m O10 N M 4 rn
m M M'(� 0'O r o, CO r 0 dN N CO CO CO d V r
Oi0'IO , 0 MN M1.,M 0')lN O O O �i0 (0 0 010
0101 I d0'OIN-lr N t00NI I� O O M;M (Ml
M
RI
as
O
OIN
N N
010
N N
M10
O
w J J J''IJ J
W 0) I -II CO 0) 0
cn00I00
O a alala a
U U U1,U U
I ca Aim
I< m O m E mlm >IIm 0 a!w c91= m1m; W1...
IU h n U151 ,a�Im � 1@ 0 m zlmw m m1U , ,gy m
pIJICi I o c:12I� J1¢ �1_ 01=!0 U JI -'
�1a° E.�lz Ei0 E�U EIJo€ EIE 3iE
l0 1 (n o (0 m 0 !. E O O -' (0 co](0 (0 O(0 O
gZ1;all''' (walla M 2 z 2 > wia = (0 wl2 (= o
Zm m;%Ft'mlo 0g `OZ0
ctI21p a c pIN Y, plc p'O Y �!Z �I
('O M
CD
N
010
N
N
O
N
N
0
W
J
I-
Ujd
N
N
O
N
N
0
111
M
(0
a
M
al
4,4
M M
M 0 0
M M MM M M!,
0 0 0 'N N 0 0 N N
0 O 0.O O'. G
N N NN•N N N NN
,d'' ImIN N..
O 3-IN N NIN'N 'IM
r
r r' r
1r.N I '--
N ON N N N N'N NIIN
O O 0 0 0 010 0 0
N N!N;N NININ NIIN
O r N'. .V'� � `.N
r{ 1M r 0
r
(n m11- �PI-
U 010 a': K jla10
UIU cols L1a13) 01L (o a�iwa ppWl
aWOlmlwiw�m,wmW WOwm
j3133EKSN7
Q R 0<1<a
(nrnoo W WILL
wl-0--
wI-
M m rn (ON rnIM m
O
rn rn 0 m
0000001100
= M rn } QQ� > �111I^ 01w10° Q ZlI>ilO'NI(o
C0,0 0 NIIN N ZILLIW d 00 F"Im M-J 0 0 Z Z U¢ O7
N O 0 W N 001W 1M1W m N Q (0 W a N W a N W l0
N N <0[M cICOIN O,CO t00 M( 0 C0 0 jI MI<01MIM,rn M V
co (0 O'M 0 uo (0 0 (0 M COO 0 V M O
M M N M
rn�N MIM rn M M O M M,O C0,014,0
IZ D,IZZ-
0II¢i1a''I2LL DI0 < (II<'I t¢i F
N rn rn'm (0 M O rn d 01N-r (-
M 0 0 0 (0 O M
oo000000wo,00rn00
0 0 oo0 0 0 0 0 0 0 0 0
11111
00r>m1,>
O1O O X O O
(0 0') 4;X (91U
01M ON N
M 0 O :N 1(0 0
0 (' I CO 0 O N
I100
0 N
V
M O rn
a
a
U'
r
<'U > j a UIU K
0I� 0) 0 0
d,N rn (0I(010IM O
W C 0 11 W 100) 00)
o 0 0 0 0 0 0-0
N NII
0,0
IN N
01N
N
SIC 01 1 (OIo C'D N t0:r
C N I -I co O,N (0 r t- (0
r (0 C (OIO.. f- 0 (0
N .(n .o10) 0 CO 0) 0
CO "I'C (O i0) l0) 0 0 0
O 0 O 010 110l0).0) O WIO
--'
-0)
CO 0k0 0) 0 !0
(0 O)t0) 010 1 0 1 0)
CO NIN 0 (0 0 M
n 0 N N O 10
10 (0 0 0.0
0 0) I 0 (0 0
1,11
M
2
}
0
O.I N
O:re
0I
r
u
ILL
enN
I0
0
2
FIB
T
Oj2
2
oIo O O O o.01010
o'.o O o 0 0 0 oio 0',O
olo 0 0 0 0 010 0 oao
o00000�'000,00
o o O Oi0 r O O O'Olo
0 0 sic 0 0Io O O OIO
N N'- N N'- N N NIN N
•
M C IS 0 I0 0) 0- N 1 M N
O h 010 0 N 0 0 0 O
N CO
00 N O) N 0 O r N CD 0
(0 M.( 00 N OIN 1- CO 0,0
, 0). 0 0 010) N 0,0
;4d:0 (O1I0 0 0 N1N- 4I�
0I,M
1:OI0 O;O C CIM
(0 0 I (0 (0 1 M 0 1(0 to i 0 (0 1 (0
01NIN- N N1C
N °J00 Old v 0 0,mi
101M1
%
1_IL�
(0m m (a COI I CO
<<<<4(6 COI
IQ
(n 0 0 0 C co!
N O) O)
0 0 010 O N M m M 0
M MIM C C
C C C.d C C
0 0 0 0,0 0
N N N-N N;N
(n 0); (0 :0 'IW (n
N N.N NIM'
N N N N, N
00000
N N N N'; N
0-
Z11 I
0
Y
0. (n @
UQ Im
tr
I g(0
vO m 1J U
aI� o m E 4!'I�1��
}UcO .O N O Ni(nIO
N y
0) IIz oim LL_2 cullmlz
1-m
fa.Hb
>_0 M >!w ll� S.S lL
0 C M
w Q LL
IIOICC CC
>10 > > 0 D( 7 CO m J
0 UIIS 0 M o_;2 H''U 0 U
N N (0 U( W NIN Q
0 0.N 0 00 cO O 0, 07 0
N N;0 M N--!co MIM N!N M
O)lO�lM OI (0 (0I010 M
1111, I
N
O
N
M
N
0
0
NIN
N,N
co
M
0:0
O (D
� h
U
0_
W
J
1-
U
0)
N
0
N
C
i(76
N (0 h Nf0, 01 In N� 00
(o 0r 0) I NO, (0 0,co
N
I, O' COLOC 0 N 0- O
O c} l - 00 M:C N C,O
0 0 0 0 0 C C,010
0 000ILO V)10010I0
N N
I
IN N'
00.
N N
; 10
0 0 0 0 010 0.0 N- CO 0
M 0 0 D O O O O 0- CO O) CO
(0 0 0 0 0 O 010 o I(0 r C
O M 0 0 0 O'0 0 .� 0 0 Ol0 0 0 M M M
O O o,0 0) C 0!V' CSC O 0
(0 CO 0 010 C Ln O 0 0 N 0 j N N O 0) (0 N
N , N, N
I_
•
C:N� 00 N 0 CO .1. C C'-i (0 0) 0 O 0 0 0 (0 0 CI (M CO CO M10 00) 00 N N 0 01010) 0 1- 0)
0) C (0 CO C' 0 0 0) CO (0 0 (0 Cr I CO 0 CO CO CO N CO 1 CO C 0) N
01C 0) N 0- co10) 0) O 0)l o 0- N- 0 o O N t0 0 (010 Nam' 0 C 0- 0;(0 0 0- 0',01 N N CO
0) 0 M 0 C� (0 C (0I(0 0 05.5 co, MIM co 0 M M M M (01C C1M N{MIMI0 M
C ._ 0 0) r r C C C r r 00 : 0) ' 0) 0 0) C C0 M CO 0 M M N N- M 0) N I (010') M (0
0 1. 0) N 100 C C 0) 0) 0 i 0) 'I C N CO 10) r C C 0) . N II O N O. N N 0 0) C II 1- Cr _ 7,1
N N 10/1 0)
N
L 1
01I0 0 0,0 010 0 0l00110 010 0 010 0 0 0,0 0 01000,0 0 0'10 0 0 010110,0'10 0
0 0 o10 o,o10 oloo0 0 01010 0,0,0 0 Op 0 010,010 0 0 0 0 0 0,0 0 0I0 0
o:o Old 0 0 0 0 0,010 0 oIo 0 0 0 0 0l(0 0 oS o oiloi 0 o 10 (n o 0 o.oi 0) 0 0lo
0 0 to 0 0 oIo 0 0 0l0 0 (n;o:o 0) oi0) o' o C o C�v O O 0,1n o o Ol( (tq0 0 (0
O O co 00 010 O 010 (0 co 0- 0 0 C 0 oI0 O N O'iN N O O (01N- (0 N N'N N,O 0 1-
NIN N cV SIN Ni Nil. - I Ni �1� ,-'1 NI N',IN N': N1�
�110I0IU0Uye UUU,UU
HIH LLI� (0 LLI0.1- (QL
0 M M N N C r 0 0 0)
N 0.co 0 I0.M 0 (0 0
0 a). co oo M 0 I co !co 0 0I010
0010o O oio O o,0 0
(Dim
O (0
00 (0)) 0) 0- 0 0 '- � ,- N (CO M,�1MIM lO o O'OI,O 010 0- 0 01r 01
h 0)!I MI l0 0�I10 O)10 M (0 I(0 0 0 N C '0 0
M N� N N, 0leo 0 0;(0 0 0 0
r 0I0 NINo Not o:o NIo N M 0 M MI(O O N 0 CO OIN (0 C 0
MAN �(010 O (n 010 O-0 O N10 O O O O O M M I O r 0 0 01 OI 0 0 N �-
N; I C COCO0 0 :0 C N
O 01M 0 I�I0I0 0 O 0.0 O CI0N 0.,1010 0I0IC - (*Ito C;0 o)co0.. 1 • co 0• IC
Ml0IO C O,oi( C M1010 o{OlO OIOIO 0 0 0 I 0 • •d' Ol0 O O I 'C 0,0
1
1.__ 1
I
0)
N
0 I0 0 0 OIh 0)10 1100 CO (01,N O (0'C 0 M 0
C OI0 NIM I- M N'- 01N; C Oil- (n 1- 00 O 0 0
L
(10 to g(q 212210 a1Q-D
I- Y o)1- 0 1-III. Y QYUQ 1U' H (0
J 0 U Ito (61(,)I2 Q
C 0) (n N
0 O
N mI0 010 all > > mIU U o
IMIN UIM OIWIO C 6 E1
00! In
WI0-NILO ) owOooI10o
U 0,> U 0) Slur col° 0 M m l-Ico
N INN 0 (O SIN NIN 010 i0
0 0 O 0,O N CO 0 7-
O (ni3O
N O O N 0 0 N N N:0100 010
0:(0 1010 0 f� N M
010i0 0 0 C10 0I0O ,-I0{r
I
U�z z.
U 0 U +UUIU
1"11101CCIWIIY
OIO N N n
0 W 0 0 0
0 00 0,0
0 N M C 0 00 O' M C M O
1 I 1 1
Z Z Z;Z1Z Z:Z 1ZIZ
(O;N vo 2ro O01(000 00
C0 (0100 N o r tf) 0 0 0 (0 co N
l0 r 00 I- (n 0
0I0 0 0 01r 1 CO m, 0 0 0 0 0• 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
II�
• 01C (0 N 0`0 (0 (0 0 MiM M N:NI(O 10 0)}0IM N N 0 0 0 C 0 0 0 M 0~
NI 0 0 0 N N N N NII 0'I 1r 0 r 0'0 0 ( M 0 (0 r M;r,r dio 0
(01M 1�10;0 0 (0 0 (n 010 0 IO :ON
. O .�O OO O OItO, O, O OI
N
1N O.O (") 1 '010 'O O) O ON1N, IN '-,N=M
(0 (y. N NIN m (y @ (O (al NIN (6 (0 (0 (0
QQa QIQ. I<<<<<<QQQ_Q, 1 1<
(0 0 `(O 0 0 I 0 0 0 0 0 0 0 (0 0
(0 (010 i"0 O) O O' M M 0 M M M M M.0 C10 0 0
C I C 11 C C C C ILO (n (0 0 1n !won N 0 0 1 0 I (n (n 10 An (0
I I
C C,C C C C C C1C C C C C C''I d' C C CrC C C
N N :N N N N N IN N N N N N N I.N N N N N N N
O 0I0 O O O 0,0 O O 010 0 0 0 0 0 0,0 0 0
N NIN N N N NIN N N N:N N NIN N N NIN N N
(n 11n M'd' (0 I0. (n:(f) N ()1ln 0 0 tn- O) N N, N'I0 00')
(n I(n 11n 1(o!CO IO i(o 111N 0,(O (O10 CO I r; h r I` NH1;, N, r l:
: ____ _ L __-
N N'r C4 N N1N,01 O OIC7 OIOIO O O � O (- 0 (- N
N N N N ,N N N N N ';N N N N N N N N N N N N N N N N N N
O O O O O O O o O O O O O .O O O O O O 010 0i0.00 0 0
N N,N N N N NIN NIIN N N NN N N N N N NN N N N11N NIN
N ,CO O N 0 O OI 0I� M O;l- n 0 (0I� (16)1 N WIO O) O
N � � N M N r IN _. .1N co so,:.___� N. (` ("VIM
(O 0: ON O
ate- O N 'i O
� N N
� � O 01
N 0 O I1 W 0 l O I� N� (� I:I_...
1
N
COCO
C
0
CO
0 0 0 0 0
N N N N N
0 0 0 0 0
N NIN N'N
I';N
NNN0 0
N
10
n
Poll
10,
M(�
O'O10 0 CO CO 0
01010.1. N CO 0
CI0 0{M C 0'0
CO
CO
r-:1 ail 00 � o 0 O
N:C C1(nM1C O O
N N N 0):0 00 ;o
I,- M
OI0
0 c0)
0•
0)
N
0)
N
0 0
00
o (on
N
0 0-
O;(0
0
(61� N (DIM
01m C6m;m
Q,Q1Q Q;,Q
N Cr, NIM 10) 0- 0-
CO 0 0) 0 0
(0 (0(0 (0 0 0',1E1110
o o 0
N N N
0 N;T
010'W
.4.
N N : N
0100,0 N N N
10 0 0
01,
N O O
N NIN N N
0 0'IO O O
N N ,N N N
0 10 C
0 M N
m�1NN
L
N N
010
N N
011'-
611N
w, w w
Q UlH iQ m 1 m 1I(IUIQ1U 0 0 C0C0 m U U H 01W H H
¢CL1QcnQ WIWW'W' ILO ldaa(na1�(n(n0.10Q.¢01�¢�W
010,0_ 0.10:0CI - a 0.. 0IQ 0. 0 0 0 0 010 a U( CC C C) did (7 0 O'0,K�,0
•
F IHIIH m
U 0I0
0 6 w1w 1�' yl
z
�� �'m1 o j w w of ml LLI`oa
0 .'IIO 0 D'=I S'I �1 =1' zm
O ��} } (u m m JI I! 'Ill
w!.
Ur 0H.
-Wa :oo) m Obit Q 'o - 0)
C= j U 01 0 0 Z Q O 0';J
(n O (4 0 U J J J _N 0 U O i O)
(1)
CIO} �2 O E w E a a 0 0 0 z m7 Ed E
Q H o `0 010 : m. Q `0 Z a'n f0 (75 m' 0 � o
w O olU O 0 LL W QI �165165 QIQ QIZ W 0 �1S
wZ,1 1I-I O �OlwllIQ 1m1- o 0 00opmiOw m
-JIOZImK 0_i0w,O°)IQImO�mu? d m a�OOOml.,OF0 d
C (n ~ } H¢lz O! (n tn,w: J 0 O Q,u_1-
(n01 OOI�IW (nu.0m»0000__(_n0Ou_ X2 W
1 0 N
N W >Ir (o ''� X K,1� 0 N,d'I00- 0 CO 0_
0IW Y0 0 ul XIm 2 } N fi, , m Q
rn N f tt co I2 �'Q S.colhl0 0 wlrn 2 0 ZIO 1- 0
0-IN O MIM co Au In W O)10 0) N 0I0 0010)10 (0 0 W CIU 0
CO COI M M 0 0 �- , 0 0 CO -. 10 CO'
C C
Ln M r M 10
(0 0 01, 0 0 (01M �1M!co o 0 0 0 0 0.r 0 M C
0 0 (0 (0 0 C , M C m C
N C
0 O M;CO 0 01 M1N
0 !co0 M
U oQ ol� U z zIz z1z 0 m U,'- '' z0 '- 1
N ao m r 00 1- (n ,,= __ 0 0 0 Q U 01Q U
m (0 ro'.ro1ro m rn oo ,-I( (!(0 m z,(i (0 0 (4I0
U 0
NICi�O O C 0 OI(O O
C C N CIC (0C OI I0,0 C (0 0)j-I-IM
0 0 0:0) 0 C0 0i0 0 0 0
0 0 0 oI0 o1ol010 0 0'0 0 o O'O O O O
(CREDIT SUISSE
0 N
01C00
010
011
Position Control Summary
Position Control Summary FY23
Org
Jul
Aug
Sep
Oct
Nov
Dec Jan Feb Mar April May June
July -June
Percent
Unfilled
Assessor
Filled
33.26
31.00
32.00
31.00
31,00
33.26
Unfilled
2.00
4.26
3.26
4.26
4.26
2.00
9.47%
Clerk
Filled
9.48
9.48
10.48
10.48
10.48
10.48
Unfilled
1.00
1.00
3,18%
BOPTA
Filled
0.52
0.52.
0.52
0.52 "
0.52
0.52
Unfilled
-
0.00%
DA
Filled
57.40
58.40
59.20
61.20 -
61.20
59.80
Unfilled
3.20
2.20
1.40
0.40
0.40
1.30
2.43%
Tax
Filled "
5.50
5.50
6.50
" 6.50
6.50
6,50
Unfilled
1.00
1.00
-
-
-
5.13%
Veterans'
Filled
5.00
5.00
5.00
4.00
4.00
4.00
Unfilled
-
-
-
1.00
1,00
1.00
10.00%
PropertyMngt
Filled
2,00
2.00
2.00
2.00
2.00
2,00
Unfilled
1.00
1.00
1,00
1.00
1.00
1.00
33.33%
Total General Fund
Filled
113,16
111.90
115.70
115.70
115.70
116.56 - - - - - -
Unfilled
8.20
9.46
5.66
6.66
6.66
5.30 - - - - -
5.74%
Justice Court
Filled
4.60
4.60
4.60
4.60
4.60
4.60
Unfilled
-
-
-
-
-
-
0.00%
Community Justice
Filled
45.20
45.20
45.90
44.90
44.90
45.90
Unfilled
2.70
2.70
2.00
3.00
3.00
2.00
5.36%
Sheriff
Filled
218.25
232.25
230.25
230.25
231.75
229.75
Unfilled
44.75
30.75
32.75
32.75
31.25
33.25
13.02%
Houseless Effort
Filled
-
-
1.00
1.00
1.00
1.00
Unfilled
2.00
2.00
1.00
1.00
1.00
1.00
66.67%
Health Srvcs
Filled
355.80
357.50
368.30
371.30
374.55
380.20
Unfilled
49.55
47.85
48.25
46.25
44.25
39.60
11,10%
CDO
Filled
59.80
58.80
59.80
58.80
59.80
57.80
Unfilled
12.20
13.20
12.20
13.20
12.20
14.20
17.87%
Road
Filled
55.00
55.00
58.00
57,00
58.00
58.00
Unfilled
6.00
6.00
3.00
4.00
3.00
3.00
6.83%
Adult P&P
Filled
35.55
35.55
35.85
34.85
34.85
34.85
Unfilled
5.30
5.30
5.00
6.00
6.00
6.00
13.71%
Solid Waste
Filled
27.00
26.00
28.00
26.00
27,00
28,00
Unfilled
3.00
4.00
2.00
4.00
3.00
2.00
10.00%
Victims Assistance
Filled
8.00
8.00
8.00
8.50
8.50
8.50
Unfilled
-
-
-
-
-
-
0.00%
GIS Dedicated
Filled
2.30
2.30
2.30
2.30
2.30
2.30
Unfilled
-
-
-
-
-
-
0.00%
Fair & Expo
Filled
9.75
9.75
9.75
10.75
10.75
10.75
Unfilled
3.75
3.75
3.75
2.75
2.75
2.75
24.07%
Natural Resource
Filled
1.00
-
-
-
2.00
2.00
Unfilled
1.00
2.00
2.00
2.00
-
-
58.33%
ISF-Facilities
Filled
20.75
21.75
20.75
21.75
21.75
19.75
Unfilled
4.25
3.25
4.25
3.25
3.25
5.25
15.67%
ISF - Adman
Filled
8.75
8.75
9.75
10.75
10.75
10.75
Unfilled
2.00
2.00
1.00
-
-
-
7.7S%
ISF - BOCC
Filled
3.00
3.00
3.00
3.00
3.00
3.00
Unfilled
-
-
-
-
-
0.00%
ISF - Finance
Filled
10.00
8.00
10.00
10.00
10.00
12.00
Unfilled
1.00
3.00
1.00
1.00
1.00
10.45%
ISF - Legal
Filled
7.00
7.00
7.00
7.00
7.00
7.00
Unfilled
-
-
-
-
-
0.00%
ISF - HR
Filled
9.00
9.00
9.00
9.00
9,00
9.00
Unfilled
1.00
1.00
1.00
1.00
1.00
1.00
10.00%
ISF - IT
Filled
16.70
16.70
16.70
16.70
16.70
15.70
Unfilled
-
-
-
-
-
1.00
1.00%
ISF - Risk
Filled
2.25
2.25
2.25.
2.25
2.25
2.25
Unfilled
-
-
-
-
0.00%
911
Filled
52.00
51.00
49.57
50.57
51.57
52.10
Unfilled
8.00
9.00
10.43
9.43
8.43
7.91
14.78%
Total:
Filled
Unfilled
1,064.86
154.70
1,074.30
145.26
1,095.47
135.29
1,096.97
136.29
1,107.72
126.79
1,111.76 - - - - -
124.26 - - - - - -
Total
1,219.56
1,219.56
1,230.76
1,233.26
1,234.51
1,236.01 A - - - - - -
%Unfilled
12.68%
11.91%
10.99%
11.05%
10.27%
10.05%
11.16%
A 1.5 increase in FTE. DA -.5, Health Services+1, Finance+1
Budget to Actuals Report
General Fund
Revenue YTD in the General Fund is $37.1M or 84.8% of budget. By comparison, last year revenue YTD was $34.9M
and 85.7% of budget.
Expenses YTD are $21.7M and 47.8% of budget. By comparison, last year expenses YTD was $20.4M and 47% of
budget.
Beginning Fund Balance is $13.8M or 106.7% of the budgeted $12.9M beginning fund balance.
County Wide Financial Dashboard
Fund
Select all
(Blank)
• 001 - General Fund
010 - Assmt-C1erk...
020 - Code Abate...
030 - Community ...
040 - Court Techn...
050 - Economic D...
060 - General Co...
070 - General Co_.
090 - Project Dev...
120 - Law Library
130 - Park Acquisi...
132 - Park Develo...
Monthly GL Per...
a
6
$11.4M
(Blank)
All Major Funds
SO Gs,.
Requirements
$21.7M
47.8%
Resources
84.8%
001 - General Fund
Budget to Actuals
Beginning Working Capital Budget to Actuals by Category
0n1a.r s • s._aget 40 Prejeot,cn
50.0%
6 Year Complete
rAonthly Expenditures ,.r,:,--a7.t% _ �,
% of last year budaet
$ Last Year Actu$s •Current Year Actuals
. Monthly Revenues 85.
0 Lest Year Actu_ts Qt`vrre nt Yeor Actual:
% of last veer budget
106.7%
Projected Ending Working Capital
•Budget
Approved FTE
121.86
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 December 31, 2022.
Budget to Actuals - Countywide Summary
All Departments
FY23 YTD December 31, 2022 (unaudited)
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
RESOURCES Budget
001 - General Fund
030 -Juvenile
160/170 -TRT
200 - American Rescue
Fund
220 - Justice Court
255 - Sheriffs Office
Actuals
OA
Budget
Actuals
40,504,168 40,047,506 99%
901,143 1,007,843 112%
12,578,435 13, 029, 089 104%
19,000,000 14,281,402 75%
550,832 494,676 90%
44,947,745 45,776,980 102%
274 - Health Services 48,727,400 48,848,440 100%
295 - CDD 9,580,316 10,542,434 110%
325 - Road 22,629,649 24,768,506 109%
355 - Adult P&P 5,840,250 6,178,356 106%
465 - Road CIP 2,471,190 1,124,832 46%
610 - Solid Waste 13,350,600 13,930,834 104%
615 - Fair & Expo 1,395,724 1,779,723 128%
616 - Annual County Fair 1,560,500 1,922,671 123%
617 - Fair & Expo Capital 8,544 8,012 94%
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
675 - Health Benefits
705-911
999 - Other
43,472,708 36,950,002 85%
1,010,203 289,806 29%
13,631,282 8,482,698 62%
105,186 26,636,671 999%
525,032 285,923 54%
48,790,055 44,876,367 92%
57,392,813 32,450,504 57%
11,675,519 4,639,440 40%
24,889,063 13,456,274 54%
6,134,018 3,147,360 51%
1,943,063 143,877 7%
14,503,499 6,624,142 46%
1,408,534 847,785 60%
1,849,380 2,362,835 128%
7,414 69,897 943%
517,524 584,713 113% ; 642,252 281,383 44%
7,546 6,354 84% ; 6,298 8,382 133%
3,146,973 4,409,440 140% ; 3,311,477 1,778,749 54%
23,027,177 25,070,639 109% ; 23,658,700 11,927,309 50%
12,019,306 12,896,533 107% ; 13,744,678 10,577,828 77%
50,071,869 34,055,652 68% 57,508,737 40,794,427 71%
Projection
42,836,156 99%
1,059,796 105%
13,804,165 101%
29,118,051 999%
525,490 100% ;
48,860,711 100%
60,655,445 106%
9,869,117 85%
25,546,482 103%
6,138,805 100%
1,122,350 58%
14,579,571 101%
1,693,090 120%
2,379,267 129%
88,605 999%
507,541 79%
18,950 301%
3,386,241 102%
23,895,674 101%
13,905,001 101
59,326,870 103%
•
TOTAL RESOURCES ; 312,836,891 300,764,634 96% ; 326,209,912 246,631,658 76% ; ; 359,317,379 110%
Fiscal Year 2022 1 Fiscal Year 2023
REQUIREMENTS Budget
001 - General Fund
030 - Juvenile
160/170 - TRT
200 - American Rescue
Fund
220 - Justice Court
Actuals
OA
Budget
Actuals
OA
21,298,809 19,383,248 91% 24,206,083 11,324,482 47%
7,496,355 6,674,328 89% 7,928,538 3,509,673 44%
4,010,388 3,826,539 95% , 13,113,218 8,661,152 66%
38,000,000 14,187,441 37% ; 23,129,361 9,075,368 39%
736,142 690,802 94% ; 731,183
Projection
23,241,795 96%
7,430,974 94%
13,138,565 100%
23,129,361 100%
364,996 50% 732,845 100%
jBudget to Actuals - Countywide Summary
All Departments
FY23 YTD December 31, 2022 (unaudited)
255 - Sheriffs Office
274 - Health Services
295 - CDD
325 - Road
355 - Adult P&P
465 - Road CIP
610 - Solid Waste
615 - Fair & Expo
616 - Annual County Fair
617 - Fair & Expo Capital
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
675 - Health Benefits
705 - 911
999 - Other
TOTAL REQUIREMENTS
54,162,360 51,382,461 95%
58,872,642 51,718,597 88%
9,978,889 8,963,943 90%
15,024,128 13,771,124 92%
7,079,915 6,392,578 90%
29,722,691 8,106,117 27%
9,709,991 8,792,122 91%
2,504,877 2,626,480 105%
1,468,131 1,352,783 92%
568,000 7,670 1%
552,188 466,135 84%
100,000 885 1
6,427,292 4,982,451 78%
29,424,393 29,294,027 100%
14, 563, 007 10, 896, 900
86,872,890 41,149,853 47%
75%
59,628,533 27,823,315 47%
70,874,665 31,054,228 44%
11,233,304 4,558,603 41%
16,188,996 6,349,502 39%
7,575,910 3,161,005 42%
28,387,166 12,794,787 45%
11,754,672 4,774,142 41%
2,768,054 1,380,001 50%
1,852,030 1,829,156 99%
870,000 423 0%
594,181 323,969 55%
100,000 4,837 5%
5,887,806 1,652,807 28%
26,769,217 10,810,502 40%
17,769,397 6,151,601 35%
106,860,564 24,828,889 23%
398,573,088 284,666,484 71%
438,222,878 170,433,436 39%
50.0%
Year Complete
58,911,942 99%
65,955,189 93%
9,577,938 85%
15,870,257 98%
6,833,821 90%
27,516,480 97%
11,754,672 100%
2,652,839 96%
1,915,759 103%
870,000 100%
540,563 91%
100,000 100%
5,836,497 99%
26,769,217 100%
16,693,714 94%
106,751,207 100%
426,223,635 97%
\5TES`°G2< Budget to Actuals - Countywide Summary
All Departments
FY23 YTD December 31, 2022 (unaudited)
TRANSFERS
001 - General Fund
030 - Juvenile
160/170 - TRT
220 - Justice Court
255 - Sheriffs Office
274 - Health Services
50.0%
Year Complete
Fiscal Year 2022 1 Fiscal Year 2023
Budget
Actuals
0/0
Budget
Actuals
295 - CDD
325 - Road ; (11,757,547)
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
(21,952,604) (21,807,006) 99% (20,867,706) (10,214,900) 49%
6,223,387 6,223,387 100% ; 6,452,997 3,226,494 50%
(6,024,574) (5,916,413) 98% ; (6,031,446) (3,015,702)
240,956 196,126 81% ; 263,217 131,604
3,500,737 3,501,246 100% ; 3,448,587 1,795,799
6,122,830 6,122,830 100% ; 8,258,652 3,760,866
(270,622) (1,159,207) 428% ; (911,585) (402,158)
(11,757,547) 100% ; (12,330,136) (7,440,775)
471,072 471,071 100% ; 467,092 233,538
12,193,917 10,672,113 88% ; 14,230,313 4,889,361
(6,029,323) (6,029,323) 100% ; (5,299,665) (3,966,978)
962,736 918,804 95% ; 704,127 352,062
(75,000) (75,000) 100% ; (156,706) (78,348)
798,901 779,502 98% ; 1,149,827 574,902
47,958 47,958 100% ; (81,566)
132,042 132,042 100% ; 261,750
(3,500) (3,500) 100% ; (3,500)
0%
15,418,726 17,682,916 115% ; 10,445,493
50%
50%
52%
46%
44%
60%
50%
34%
75%
50%
50%
50%
39,214 -48% ;
130,782 50%
(1,746) 50%
9,985,986 96%
Projection
°Ao
(19,694,862) 94%
6,452,997 100%
(6,046,768) 100%
263,217 100%
3,448,587 100%
5,847,710 71%
(1,066,835)
(12,330,136)
467,092
14,230,313
117%
100%
100%
100%
(5,299,665) 100%
714,851 102%
(156,706) 100%
1,154,425 100%
(81,566) 100% ;
261,566 100%
(3,500) 100%
11,839,280 113%
TOTAL TRANSFERS 91 - 0 ; (255) 0 - 0%
uTES��G2 Budget to Actuals - Countywide Summary
AU Departments
FY23 YTD December 31, 2022 (unaudited)
ENDING FUND BALANCE
001 - General Fund
030 - Juvenile
160/170 - TRT
200 - American Rescue
Fund
220 - Justice Court
255 - Sheriffs Office
274 - Health Services
295 - CDD
325 - Road
355 - Adult P&P
465 - Road CIP
610 - Solid Waste
615 - Fair & Expo
616 - Annual County Fair
617 - Fair & Expo Capital
Reserve
618 - RV Park
619 - RV Park Reserve
670 - Risk Management
675 - Health Benefits
705 - 911
999 - Other
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
10,723,375
596,681
8,433,816
55,646
12,160,633
6,011,534
763,172
2,231,806
1,971,182
5,316,460
583,520
604,256
17,369
1,341,108
13,294
824,054
5,045,296
8,375,402
9,307,082
55,322,038
13,847,827 129%
1,522,125 255%
9,475,532 112%
108,098 999%
15,162,285
13,942,649
2,168,956
7,806,356
3,238,905
27,223,832
3,066,662
995,519
385,854
1,809,440
166,536
1,191,937
8,944,938
11,304,191
12,708,705
95,096,396
0%
125%
232%
284%
350%
164%
512%
526%
165%
999%
135%
999%
145%
177%
135%
137%
172%
11,374,637
634,663
4,000,000
57,066
7,024,650
6,005,519
1,627,134
2,262,898
2,125,200
12,334,484
556,359
315,960
225,358
1,587,183
82,920
1,340,766
5,107,351
8,815,139
8,926,080
56,813,544
29,258,448
1,528,752
6,281,376
17,669,401
52,532
34,011,136
19,099,791
1,847,636
7,472,354
3,458,797
19,462,283
949,684
815,365
841,185
2,453,816
163,164
1,326,263
9,069,134
12,420,998
17,134,932
122,899,946
TOTAL FUND BALANCE 129,697,724 230,166,744 177% ; 131,216,911 308,216,991
Projection
13,747,327 121%
1,603,945 253%
4,094,364 102%
6,096,788 999%
55,862 98%
8,559,641 122%
14,490,614 241 %
1,393,300 86%
5,152,445 228%
3,010,980 142%
15,060,015 122%
591,896 106%
750,622 238%
692,656 307%
2,182,470 138% ;
51,948
1,372,453
6,491,182
8,430,648
9,919,992
63,361,081
63%
102%
127%
96%
111%
167,110,229 127%
y \1ES ` Z Budget to Actuals Report
General Fund - Fund 001
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
Projection
% $ Variance
Property Taxes - Current 32,410,716 32,791,880 101% : 34,467,173 32,364,664 94% : 34,378,087 100% : (89,086)' A
Property Taxes - Prior 460,000 337,612 73% , 301,000 213,188 71% , 301,000 100%-;
Other General Revenues 2,689,926 2,880,344 107% 0 3,591,874 2,804,428 78% a 3,744,408 104% : 152,534; B
Assessor 987,411 886,514 90% e 964,246 209,437 22% ; 964,246 100% e
Clerk 2,741,215 2,225,591 81% : 2,298,566 649,854 28% : 1,598,566 70% ; (700,000): C
BOPTA 14,588 13,216 91% ; 14,588 3,072 21% ; 14,588 100%
District Attorney 448,201 258,776 58% 1,183,942 562,558 48% 1,183,942 100% , a D
Tax Office 341,004 321,554 94% 0 221,483 62,238 28% , 221,483 100%
Veterans 259,107 182,018 70% , 214,836 45,505 21% : 214,836 100% ! : E
Property Management 152,000 150,000 99% : 215,000 35,058 16% : 215,000 100% o F
i 7 1 1 i
TOTAL RESOURCES 40,504,168 40,047,506 99% : 43,472,708 36,950,002 85% : , 42,836,156 99% : (636,552):
REQUIREMENTS
Budget Actuals
Budget Actuals
OA
Assessor 5,454,784 5,157,534 95% : 5,910,478 2,665,143 45%
Clerk 2,080,739 1,735,214 83% 2,432,710 1,072,398 44%
BOPTA 82,911 77,147 93% 87,177 42,063 48%
District Attorney 9,715,707 8,677,696 89% 10,979,839 4,957,278 45%
Medical Examiner 242,652 241,582 100% 438,702 105,052 24%
Tax Office 932,570 886,019 95% 905,262 458,781 51%
Veterans 795,189 762,328 96% 813,100 354,286 44%
Property Management 380,061 360,274 95% ' 508,359 181,316 36%
Non -Departmental 1,614,196 1,485,453 92% 0 2,130,456 1,488,164 70%
TOTAL REQUIREMENTS ; 21,298,809 19,383,248 91% ; 24,206,083 11,324,482 47%
TRANSFERS
Projection % $ Variance
5,443,924 92% ' 466,554: G
2,362,964 97% 69,746: H
95,578 110% (8,401);
10,617,050 97% 362,789; 1
I
438,702 100% i -'
884,605 98% . 20,657, H
808,721 99% ! 4,379! H
459,795 90% ! 48,564; H
2,130,456 100% e J
23,241,795 96% : 964,288:
Budget Actuals % Budget Actuals % Projection % $ Variance
Transfers In 260,000 260,000 100% , 260,000 130,218 50% ; 260,439 100% 439, K
Transfers Out . , ; (22,212,604) (22,067,006) 99% , (21,127,706) (10,345,118) 49% _ _ (19,955,301) 94% . 1,172,405
s ; l s
TOTAL TRANSFERS ; (21,952,604) (21,807,006) 99% (20,867,706) (10,214,900) 49% ; (19,694,862) 94%; 1,172,844;
FUND BALANCE
Budget Actuals
Budget Actuals % Projection % $ Variance
Beginning Fund Balance 13,470,620 14,990,575 111% : 12,975,718 13,847,828 107% : : 13,847,828 107% i 872,110:
Resources over Requirements 19,205,359 20,664,258 19,266,625 25,625,520 ' ; 19,594,361 327,736'
Net Transfers - In (Out) (21,952,604) (21,807,006) (20,867,706) (10,214,900) (19,694,862) . 1,172,844
1 I I 1 I
TOTAL FUND BALANCE
$ 10,723,375 $ 13,847,828 129% ; $ 11,374,637 $ 29,258,448 257% ; ; $ 13,747,327 121% ; $2,372,690:
A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted
g PILT payment of $500,000 received in July 2022; includes -$585K for a State Grant that will be passed through to Neighborlmpact for domestic
well assistance
c Recording fees expected to be lower than budget due to decreased loan origination volume from rising interest rates
D Recent budget adjustment to increase State grant funding which is expected to come in later this fiscal year
E Oregon Dept. of Veteran's Affairs grant reimbursed quarterly
F Interfund land -sale management revenue recorded at year-end
G Projected Personnel savings based on FY22/FY23 average vacancy rate of 7.9%
H Projected Personnel based on vacancy savings to date
I Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.2%
j Includes $100K loan to Alfalfa Fire District
K Repayment to General Fund from Finance Reserves for ERP Implementation
jj Budget to Actuals Report
Juvenile - Fund 030
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
OYA Basic & Diversion
ODE Juvenile Crime Prev
Gen Fund -Crime Prevention
Leases
Inmate/Prisoner Housing
DOC Unif Crime Fee/HB2712
Miscellaneous
OJD Court Fac/Sec SB 1065
Food Subsidy
Contract Payments
Interest on Investments
TOTAL RESOURCES
REQUIREMENTS
Personnel Services
Materials and Services
Capital Outlay
TOTAL REQUIREMENTS
TRANSFERS
Transfers In- General Funds
Transfers Out-Veh Reserve
TOTAL TRANSFERS
FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
Projection
% $ Variance
432,044 500,765 116% : 525,049 97,007 18% a 525,049 100% e
100,517 117,184 117% i 123,000 26,360 21% . 123,000 100%
89,500 89,500 100% 89,500 - 0% : 89,500 100%
88,000 89,154 101% 86,000 45,114 52% 0 90,228 105%
80,000 92,400 116% 1 55,000 71,400 130% a 90,000 164%
49,339 50,462 102% . 49,339 12,655 26% a 49,339 100%
7,500 29,113 388% : 42,500 9,903 23% ! 37,000 87%
20,000 10,291 51% ; 15,000 7,065 47% 15,000 100%
12,000 11,380 95% ; 10,000 6,291 63%! 10,000 100%
�
8,000 9,947 124% . 8,000 2,327 29% o : 5,000 63% ! 14,243 7,647 54% 6,815 11,683 171% a 25,680 377%
4,228. A
35,000! B
(5,500)
0
(3,000)! C
18,865; D
901,143 1,007,843 112% ; 1,010,203 289,806 29% : , 1,059,796 105% ; 49,593:
Budget Actuals
OA
Budget Actuals % Projection % $ Variance
6,082,895 5,411,118 89% = 6,332,160 2,857,540 45% : : 5,867,033 93% 465,127: E
1,363,409 1,249,983 92% 1,527,992 644,533 42% 1,495,555 98% 32,437; F
50,051 13,226 26% ! 68,386 7,600 11% ! ; 68,386 100% ;
7,496,355 6,674,328 89% ; 7,928,538 3,509,673 44% ; , 7,430,974 94% ; 497,564:
Budget Actuals % Budget Actuals % Projection % $ Variance
6,304,397 6,304,397 100% : 6,529,064 3,264,522 50% : : 6,529,064 100%
(81,010) (81,010) 100% . (76,067) (38,028) 50% . . (76,067) 100% s
6,223,387 6,223,387 100% ; 6,452,997 3,226,494 50% ; , 6,452,997 100%
Budget Actuals % Budget Actuals
0/0
Projection % $ Variance
Beginning Fund Balance 968,506 965,223 100% . 1,100,001 1,522,125 138% . . 1,522,125 138% : 422,125:
Resources over Requirements (6,595,212) (5,666,485) (6,918,335) (3,219,867) a (6,371,178) 547,157
Net Transfers - In (Out) a 6,223,387 6,223,387 6,452,997 3,226,494 { 6,452,997
TOTAL FUND BALANCE
$ 596,681 $ 1,522,125 255% ; $ 634,663 $ 1,528,752 241% ; ; $ 1,603,945 253% ; $969,282:
A New lease payment for JBarJ
g Savings based on current expense trends for materials and services.
c Out of county utilization for last two months is higher than anticipated based on original projection. Can shift daily based on intake activity.
D Investment Income projected to come in higher than budget
E Projected Personnel savings based on FY22/FY23 average vacancy rate of 6.3%
F Savings based on current expense trends for materials and services.
Budget to Actuals Report
TRT - Fund 160/170
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Room Taxes
Interest on Investments
Miscellaneous
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
12,519,987
58,448
12,977,205 104% 0 13,580,874
51,884 89% . 50,408
Projection % $ Variance
8,436,673 62%
si
45,863 91% .
161
TOTAL RESOURCES , 12,578,435 13,029,089 104% ; 13,631,282
REQUIREMENTS
Grants & Contributions
COVA
Interfund Charges
Administrative
Software
TOTAL REQUIREMENTS
TRANSFERS
Transfer Out - RV Park
Transfer Out - Annual Fair
Transfer Out - Justice Court
Transfer Out - Health
Transfer Out - F&E Reserve
Transfer Out - F&E
Transfer Out - Sheriff
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
13,702,624 101
101,380 201%
161
121,750: A
50,972; B
161
8,482,698 62% ; , 13,804,165 101% ; 172,883:
Budget Actuals
Budget
Actuals
OA
3,660,659
239,526
15,203
95,000
3,512,891 96% o
239,526 100%
9,365 62%
64,758 68%
5,600,000
3,675,886
3,574,573
215,508
47,251
4,600,000 82%
2,155,546 59%
1,787,287 50%
92,069 43%
26,250 56%
4,010,388 3,826,539 95% ; 13,113,218
Projection % $ Variance
5,600,000 100%
3,701,233 101%
3,574,573 100%
215,508 100%
47,251 100%
C
(25,347): D
-E
8,661,152 66% ; , 13,138,565 100% ; (25,347):
Budget Actuals
Budget
Actuals
(20,000)
(75,000)
(240,956)
(444,417)
(498,901)
(1,093,513)
(3,651,787)
(6,024,574)
(20,000) 100% : (20,000)
(75,000) 100% ! (75,000)
(196,126) 81% ! (263,217)
(444,417) 100% (418,417)
(479,502) 96% (501,683)
(1,049,581) 96% (1,101,342)
(3,651,787) 100% (3,651,787)
(5,916,413) 98% ; (6,031,446)
Projection % $ Variance
(9,996) 50% :
(37,500) 50%
(131,604) 50%
(209,208) 50%
(250,836) 50%
(550,668) 50%
(1,825,890) 50% °
(3,015,702) 50%
9 1
(20,000) 100% e
(75,000) 100%
(263,217) 100%
(418,417) 100%
(506,281) 101%
(1,112,066) 101%
(3,651,787) 100% s
(6,046,768) 100%
(4,598): F
(10,724); G
(15,322);
Budget Actuals
Budget
Actuals
5,890,343
8,568,047
(6,024,574)
6,189,395 105%
9,202,550
(5,916,413)
9,513,382
518,064
(6,031,446)
9,475,532 100%
(178,454)
(3,015,702)
$ 8,433,816
$ 9,475,532 112% ; $ 4,000,000
$ 6,281,376 157%
Projection % $ Variance
9,475,532
665,600
(6,046,768)
$ 4,094,364
100% (37,850):
147,536;
(15,322)
i
102% ; $94,364:
A Room Tax collections up 5.6% over last year versus 5% budget assumption
g Investment Income projected to come in higher than budget
c Includes contributions of $4M to Sunriver Service District, $600K to Deschutes Trail Coalition and $1 M to Mt. Bachelor
D Payments to COVA based on a percent of TRT collections
E Includes -$3.5M for Interfund Payments to the General County Reserve Fund
F The balance of the 1 % F&E TRT is transferred to F&E reserves
G Transfer projected to be higher based on increased Room Taxes
;v(ES COG�� Budget to Actuals Report
ARPA — Fund 200
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Interest on Investments
Local Assistance & Tribal
Consistency
State & Local Coronavirus Fiscal
Recovery Funds
TOTAL RESOURCES
REQUIREMENTS
Services to Disproportionately
Impacted Communities
Administrative
Infrastructure
Negative Economic Impacts
Public Health
TOTAL REQUIREMENTS
FUND BALANCE
Beginning Fund Balance
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
93,961
19, 000,000 14,187,441 75%
105,186 145,823 139%
- 2,311,073
- 24,179,776
19,000,000 14,281,402 75%
105,186 26,636,671 999%
Budget Actuals
OA
Budget Actuals
OA
20,650,098 5,242,251 25%
15,394,824 7,289,916 47%
5,281,005 143,079 3% 4,317,328 90,012 2%
2,050,000 527,275 26% 1,634,710 462,857 28%
6,285,840 5,488,685 87% 899,577 438,494 49%
3,733,057 2,786,152 75% 882,922 794,089 90%
8 9
38,000,000 14,187,441 37% , 23,129,361 9,075,368 39% ;
Projection
% $ Variance
316,130 301%
4,622,145
24,179,776
210,944i A
4,622,145B
24,179,776 C
29,118,051 999% 29,012,865
Projection % $ Variance
15,394,824 100%
4,317,328 100%
1,634,710 100%
899,577 100%
882,922 100%
23,129,361 100%
-E
- F
G
H
8
Budget Actuals
Budget Actuals % Projection % $ Variance
19,000,000 14,137 0%
Resources over Requirements (19,000,000) 93,961
Net Transfers - In (Out)
TOTAL FUND BALANCE
23,024,175 108,098 0%
(23,024,175)
17,561,303
108,098 0%
5,988,690
(22,916,077)
29,012,865
$ 108,098 999% ; - $ 17,669,401 999% ; ; $ 6,096,788 999% ; $6,096,788;
A Investment Income projected to come in higher than budget
g A budget adjustment for additional Local Assistance & Tribal Consistency funds is forthcoming
c The revenue received in FY22, but unspent at 06.30.22, was recorded as Deferred Revenue and recognized in FY23
D Includes $6.77M in childcare/early education funding, $6.9M in housing support for unhoused persons and over $7.3M in affordable housing projects
E Administration holds the balance of the ARPA funds, as well as an approved Management Analyst for ARPA reporting and administration
F Consists of modernization of irrigation systems, Terrebonne wastewater system, and a regional broadband infrastructure needs and assessment
G Majority of funding is for food programs, $2.5 million in small business assistance and additional funding for Ronald McDonald House and an
Apprenticeship jobs program
H Approved ARPA funding consists of Isolation Motel Liability Insurance, COVID-19 testing done by Dr. Young, UV sanitizer for the jail to prevent
COVID-19 in congregate settings and various Health Services expenses such as temporary staffing costs to support the COVID-19 response
ANI ES
Budget to Actuals Report
Justice Court - Fund 220
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Court Fines & Fees
Interest on Investments
Miscellaneous
TOTAL RESOURCES
REQUIREMENTS
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
%
550,000
95
737
494,265 90%
45 48%
365 50%
Projection
$ Variance
525,000 285,674 54%
32 249 779% , o
550,832
525,000 100%
490 999%
458; A
494,676 90% : 525,032 285,923 54% ; , 525,490 100%
Budget Actuals
Budget Actuals
%
Personnel Services
Materials and Services
TOTAL REQUIREMENTS
TRANSFERS
Transfers In -TRT
TOTAL TRANSFERS
Resources over Requirements
Net Transfers - In (Out)
TOTAL '.
577,209 541,792 94%
158,933 149,011 94%
569,648 286,488 50%
161,535 78,507 49%
736,142 690,802 94%
458:
Projection % $ Variance
571,310 100%
161,535 100%
(1,662).
731,183 364,996 50% : : 732,845 100% ; (1,662);
Budget Actuals
Budget Actuals
240,956 196,126 81%
Projection % $ Variance
263,217 131,604 50% 263,217 100%
as
240,956 196,126 81% ; 263,217 131,604 50% ; , 263,217 100%
(185,310) (196,126)
240,956 196,126
(206,151) (79,072)
263,217 131,604
(207,355)
263,217
(1,204)
$ 55,646 - 0% $ 57,066 $ 52,532 92% ; , $ 55,862 98% ; ($1,204):
A Investment Income projected to come in higher than budget
One time yearly software maintenance fee paid in July for entire fiscal year
B
..` Sheriff's Office - Fund 255
FY23 YTD December 31, 2022 (unaudited)
Budget to Actuals Report
RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
%
Budget
Actuals
Projection
% $ Variance
LED #1 Property Tax Current 28,448,529 28,828,746 101% : 30,282,049 28,505,060 94% 30,239,651 100% ; (42,398); A
LED #2 Property Tax Current 11,813,562 11,962,302 101% : 13,400,541 12,546,330 94% !13,313,046 99% (87,495): B
Sheriffs Office Revenues 3,993,964 4,407,029 110% ; 4,520,630 3,385,841 75% ' ' 4,545,024 101% . 24,394. C
1 ' 330,000 178,074 54% 330 000 100%
LED #1 Property Tax Prior 330,000 288,862 88 /°
LED #2 Property Tax Prior 145,000 118,145 81% 145,000 73,505 51% 145,000 100%;
LED #1 Interest 147,416 96,152 65% 89,119 103,671 116% ' ' 240,230 270% = 1 151,111: C
1 1 1 I
Revenue Not Assigned - ' ' '
LED #2 Interest 69,274 24,356 35% 22,716 19,594 86% 47,760 210% 25,044' D
1 1 1 . 1
Revenues Not Assigned - 3,538 - -
I
CG DNE - Error 60,754 1 1 -,
LED #2 Foreclosed Properties 15,070 - '
1 1
LED #1 Foreclosed Properties 36,317 -
1 1 7 1 0 i
TOTAL RESOURCES 44,947,745 45,776,980 102% : 48,790,055 44,876,367 92% : : 48,860,711 100% : 70,656:
REQUIREMENTS
Digital Forensics
Concealed Handgun Licenses
Rickard Ranch
Sheriffs Services
Civil/Special Units
Automotive/Communications
Detective
Patrol
Records
Adult Jail
Court Security
Emergency Services
Special Services
Training
Other Law Enforcement
Non - Departmental
TOTAL REQUIREMENTS
TRANSFERS
Transfer In - TRT
Transfer In - General Fund
Transfers Out - Debt Service
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
Budget Actuals
Budget Actuals % Projection % $ Variance
808,610 381,564 47% : : 738,946 91% : 69,664;
335,044 138,600 41% 283,511 85% . 51,533
- -264,871 93,052 35% 264,871 100%
4,002,499 4,208,992 105% ' 5,863,885 2,514,214 43% 0 5,058,102 86% 805,783'
1,154,204 1,112,473 96% 1,168,300 629,828 54% a 1,143,065 98% 25,235'
3,576,342 3,738,777 105% 4,005,888 1,691,833 42% ' 3,921,934 98% 83,954'
3,029,130 3,013,632 99% ' 3,383,825 1,916,260 57% . 3,987,261 118% (603,436)
14,015,461 13,440,565 96% ' 14,640,315 7,301,542 50% _ 14,921,742 102% (281,427)
1,025,023 735,218 72% 0 944,493 330,102 35% 694,703 74% 249,790'
21,033,697 18,807,184 89% 22,182,320 9,898,802 45% 21,158,994 95% ' 1,023,326!
444,617 431,758 97% 424,769 258,689 61% 523,844 123% . (99,075)
789,912 543,303 69% 829,997 270,283 33% 624,718 75% 205,279;
1,775,588 2,053,196 116% 2,047,792 1,151,625 56% _ ' 2,498,847 122% a (451,055);
1,626,207 1,786,439 110% . 1,907,588 803,837 42% . 2,001,434 105% . (93,846)
1,389,684 1,510,925 109% ' 820,836 443,083 54% . a 1,089,970 133% . (269,134)
299,998 - 0% . - - 0% ; ' - 100% ,
54,162,360 51,382,461 95% ; 59,628,533 27,823,315 47% ; , 58,911,942 99% ; 716,591:
Budget Actuals % Budget Actuals % Projection % $ Variance
3,651,787 3,651,787 100% : 3,651,787 1,825,890 50% :: 3,651,787 100%
121,950 121,950 100% : 70,000 34,998 50% : : 70,000 100%
(273,000) (272,491) 100% e ; (273,200) (65,089) 24% o (273,200) 100%
1 1 7
3,500,737 3,501,246 100% : 3,448,587 1,795,799 52% : : 3,448,587 100% ;
Budget Actuals % Budget Actuals % Projection % $ Variance
17,874,511 17,266,520 97% : 14,414,541 15,162,285 105% : : 15,162,285 105% : 747,744:
(9,214,615) (5,605,481) (10,838,478) 17,053,052 (10,051,231) 787,247
3,500,737 3,501,246 3,448,587 1,795,799 1 3,448,587 ,
1 1 1
$ 12,160,633 $ 15,162,285 125% ; $ 7,024,650 $ 34,011,136 484% ; ; $ 8,559,641 122% ; $1,534,991:
Note: Vacant positions are driving projected department savings, with other fluctuations causing projected budget overages
A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted
g Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 4.79% over FY21-22 vs. 5.45% budgeted
c Investment Income projected to come in higher than budget
D Investment Income projected to come in lower than budget
Budget to Actuals Report
Health Services - Fund 274
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
State Grant
OHP Capitation
State Miscellaneous
OHP Fee for Service
Federal Grants
Local Grants
Environmental Health Fees
Other
State - Medicaid/Medicare
Patient Fees
Medicaid
State - Medicare
Vital Records
Liquor Revenue
Divorce Filing Fees
Revenue Not Assigned
Interfund Contract- Gen Fund
State Shared- Family Planning
Interest on Investments
CCBHC Grant
TOTAL RESOURCES
RElQI nREMENTS
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
OA
17,641,302
8,947,837
4,129,465
3,627,151
4,303,483
1,936,838
1,086,019
884,036
843,050
468,415
1,014,100
172,200
280,000
157,000
173,030
127,000
152,634
156,549
2,627,291
16,634,837
11,776,144
3,518,729
4,032,343
4,090,251
3,350,227
1,213,172
866,362
777,348
538,392
750,524
194,470
342,960
199,100
178,331
127,000
118,228
101,438
38,587
94%
132%
85%
111%
95%
173%
112%
98%
92%
115%
74%
113%
122%
127%
103%
100%
77%
65%
1%
21,828,364
12,882,624
8,901,719
3,232,620
2,615,634
2,332,031
1,238,499
1,021,722
807,530
615,644
430,863
337,614
300,000
177,574
173,030
147,595
127,000
125,000
97,750
13,299,191
6,538,753
5,013,195
2,008,361
743,987
1,627,137
856,648
450,148
565,492
324,167
320,097
108,988
127,770
44,101
63,178
127,000
82,919
149,372
61%
51%
56%
62%
28%
70%
69%
44%
70%
53%
74%
32%
43%
25%
37%
0%
100%
66%
153%
48,727,400 48,848,440 100% ; 57,392,813 32,450,504
57%
Budget Actuals O% Budget
Projection
% $ Variance
23,765,646
12,115,681
8,706,496
4,889,911
2,593,235
2,497,934
1,258,100
1,037,916
1,129,380
632,387
640,195
214,044
293,830
177,574
63,178
127,000
165,838
347,100
109%
94%
98%
151%
I
99% ;
107% '
I
102% '
i
102% '
I
140%
103%
149% ;
63% '
98%
I
100% '
37%
1
0% '
I
100% '
133%
355%
1,937,282:
(766,943)
(195,223);
1,657,291;
(22,399);
165,903;
19,601
I
16,194:
321,850
16,743:
209,332;
(123,570)
(6,170)
(109,852);
(147,595);
40,838:
249,350
60,655,445 106% ; 3,262,632:
Actuals °% Projection % $ Variance
Expenditures
Administration Allocation
Personnel Services
Materials and Services
Capital Outlay
TOTAL REQUIREMENTS
TRANSFERS
Transfers In- General Fund
Transfers In- OHP Mental Health
Transfers In - TRT
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
43,994,358
14,721,284
157,000
- 999%
39,393,426 90%
12,243,043 83% '
I
82,128 52%
30,955
50,850,720
19,612,347
380,643
24,163,934
6,769,994
120,300
0%
I
'
i
48% '
35%
I
32%
27,860 90%
- 0%
45,860,541 90%
19,692,145 100%
I
374,643 98%
3,095:
4,990,179:
(79,798);
6,000'
58,872,642 51,718,597 88% ; 70,874,665 31,054,228 44% 65,955,189 93% ; 4,919,476:
Budget Actuals
Budget Actuals
5,909,168
444,417
(230,755)
6,122,830
5,909,168 100% o
444,417 100%
(230,755) 100%
6,122,830 100%
Projection % $ Variance
6,608,245 3,304,068 50% : : 5,435,840 82% : (1,172,405):
1,473,586 368,382 25% ! ! 485,800 33% ; (987,786);
418,417 209,208 50% ' ! 418,417 100%
(241,596) (120,792) 50% : : (492,347) 204%; (250,751);
I I I i
8,258,652 3,760,866 46% : : 5,847,710 71% : (2,410,942):
Budget Actuals
Budget Actuals
Projection % $ Variance
10,033,946 10,689,975 107% : 11,228,719 13,942,649 124% : : 13,942,649 124% : 2,713,929:
(10,145,242) (2,870,157) ; (13,481,852) 1,396,276 ! (5,299,744) ; 8,182,108
I 6,122,830 6,122,830 8,258,652 3,760,866 5,847,710 ; (2,410,942);
f I I i
$ 6,011,534 $ 13,942,649 232% ; $ 6,005,519 $ 19,099,791 318% ; ; $ 14,490,614 241% ; $8,485,095;
Budget to Actuals Report
Health Services - Admin - Fund 274
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Federal Grants
State Grant
OHP Capitation
Revenue Not Assigned
Interest on Investments
Other
CCBHC Grant
Patient Fees
TOTAL RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
%
Budget
Actuals
1,438,843
769,319
156,549
9,200
486,804
1,183,981 82%
493,270 64%
436,443
101,438
12,146
6,938
1,124
65%
132%
1%
454,405
379,180
367,074
147,595
97,750
12,900
Projection
% $ Variance
40,977 9%
258,597 68% I ,
I 1
202,157 55%
0%
149,372 153%
7,301 57%
I 1
2,860,715
2,235,340 78%
683,977 151%
420,583 111%
367,074 100%
0%
347,100 355%
11,100 86%
229,572: A
41,403
I
(147,595)!
249,350;
I
(1,800);
1,458,904 658,404 45% ; , 1,829,834 125% ; 370,930:
REQUIREMENTS Budget
Actuals
Budget Actuals
Expenditures -
1
Personnel Services 6,904,224
Materials and Services 6,580,649
I
Administration Allocation ! (10,188,902)
TOTAL REQUIREMENTS ; 3,295,971
3,095
I
5,832,219 84% ! 6,738,820
6,134,705 93% ! I 6,971,663
(10,188,901) 100% ; (11,192,921)
1,778,023 54% ; 2,520,656
Projection % $ Variance
- 0% 0% :I 3,095:
I I
2,956,514 44% ; 0 5,967,281 89% ; 771,539; B
3,303,354 47% ° 1 6,707,260 96% ° 264,403
1 � I 1
(2,735,859) 24% ! !I (11,192,921) 100%
9 1
3,524,009 140% ; ; 1,481,620 59% ; 1,039,037:
TRANSFERS Budget
Actuals
Budget Actuals
Ok
Transfers In- OHP Mental Health
Transfers Out
TOTAL TRANSFERS
(219,794)
(219,794)
(219,794) 100%
(219,794) 100%
80,771
(230,635)
(149,864)
Projection % $ Variance
20,190 25%
(115,314) 50%
I 1
(95,124) 63%
FUND BALANCE Budget
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
Actuals
Budget Actuals
3,552,000
(435,256)
(219,794)
3,769,942 106%
457,317
(219,794)
3,884,332
(1,061,752)
(149,864)
4,007,465 103%
(2,865,605)
(95,124)
$ 2,896,950
$ 4,007,465 138% ; $ 2,672,716 $ 1,046,736 39%
0%
(230,635) 100%
(230,635) 154%
(80,771) C
(80,771);
Projection % $ Variance
4,007,465 103% : 123,133:
1 1
348,214 1,409,967; 1
(230,635) (80,771);
$ 4,125,045 154% ; $1,452,329:
A Projection includes unbudgeted FEMA carryforward from FY22 for vaccine clinics and outreach
g Personnel projections based on year to date vacancy savings and assume 3% moving forward
c Transfers In from OHP Mental Health Reserves will occur at end of year. No funds are currently projected to be transferred to Admin Services
Budget to Actuals Report
Health Services - Behavioral Health - Fund 274
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
State Grant
OHP Capitation
State Miscellaneous
OHP Fee for Service
Federal Grants
Local Grants
Other
Patient Fees
Medicaid
State - Medicare
Liquor Revenue
Divorce Filing Fees
Interfund Contract- Gen Fund
CCBHC Grant
TOTAL RESOURCES
REQUIREMENTS
Administration Allocation
Personnel Services
Materials and Services
Capital Outlay
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
%
11,907,014 12,160,202
8,947,837 11,339,701
1,934,643 1,712,171
3,627,151 4,009,351
2,725,623 2,781,433
1,093,055 1,378,335
682,180 668,038
372,115 431,526
1,014,100 750,524
172,200 194,470
157,000 199,100
173,030 178,331
127,000 127,000
2,140,487 31,649
35,073,435 35,961,830
102%
127%
89%
111%
102%
126%
98%
116%
74%
113%
127%
103%
100%
1%
103% ; 45,453,529
15,718,843
12,515,550
8,027,373
3,214,360
2,017,169
1,475,139
719,670
519,344
430,863
337,614
177,574
173,030
127,000
10,051,141
6,336,596
4,804,441
1,992,554
667,836
814,911
362,482
250,735
320,097
108,988
44,101
63,178
127,000
25,944,060
64%
51%
60%
62%
33%
55%
50%
48%
74%
32%
25%
37%
100%
57%
Budget Actuals
Projection
% $ Variance
16,835,345
11,748,607
7,782,663
4,857,532
1,759,984
1,537,053
721,543
487,397
640,195
214,044
177,574
63,178
127,000
107% : 1,116,502: A
94% . (766,943)a B
1
97% (244,710); C
151% 1,643,172;I B
1
87% (257,185);
104% 61,914.
I I
100% ! 1,873!
I a
94% (31,947);
149% 209,332;
1 1
63% (123,570);
100% -
I
37% (109,852); D
1
100% ,
1
46,952,115
103% : 1,498,586:
Budget Actuals % Projection
TOTAL REQUIREMENTS
TRANSFERS
Transfers In- General Fund
Transfers In- OHP Mental Health
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
7,523,855
26,606,065
4,882,963
80,000
39,092,883
7,523,855 100%
24,513,386 92%
3,690,305 76%
54,752 68%
s
35,782,298 92%
8,265,132
32,563,031
10,292,612
225,443
51,346,218
2,021,250
16,163,937
2,652,017
109,100
20,946,303
$ Variance
24%
� o
50% ! ,
26% !
1
48% ,
a
41%
8,265,132
29,516,982
9,929,357
219,443
100% ;
91%
96% ;I
97%
3,046,049: E
363,254
6,000
47,930,914
93% : 3,415,304:
Budget Actuals
Ok
Budget
Actuals
2,278,087
(10,961)
2,267,126
2,278,087 100%
(10,961) 100%
2,267,126 100%
2,231,439
1,392,815
(10,961)
3,613,293
1,115,694
348,192
(5,478)
1,458,408
Projection
% $ Variance
50%
a a
25%
50% I ,
a
40%
1,227,695 55% s (1,003,744): F
485,800 35% _ (907,015); G
(152,961) 999% _ (142,000)9 H
9
1,560,534 43% ; (2,052,759):
Budget Actuals
Budget Actuals
3,612,014
(4,019,448)
2,267,126
3,870,664 107%
179,532
2,267,126
4,788,795
(5,892,689)
3,613,293
Projection
% $ Variance
6,317,144 132%
4,997,756 I 1
1,458,408
I B
1,560,534 ; (2,052,759);
� ! I I
$ 1,859,692
6,317,144 132% : 1,528,349:
(978,799) ; 4,913,890
I
$ 6,317,322 340% ; $ 2,509,399 $ 12,773,308 509%
$ 6,898,878 275% ; $4,389,479:
A Increase of $715K related to new funds for Aid & Assist ($431K), a cost of living adjustment ($358K), and carryforward revenue from FY22 ($455k)
B A new System of Care wraparound payment was budgeted as part of OHP Capitation, but is coming in as OHP Fee for Service.
c Vacancies in I/DD are estimated to result in lower State Miscellaneous revenue than budgeted
D Mediation Program will no longer be managed within Health Services, so funds are transferred out of Health Services
E Personnel projections based on year to date vacancy savings and assume 10% moving forward.
F Estimating Behavioral Health will return approximately $1 M return of County General Funds in FY23.
G Transfers In from OHP Mental Health Reserves will occur at end of year. Fewer funds are currently projected to be transferred to Behavioral Health
than budgeted.
H Transfers Out are increased to cover the additional construction costs proportional to Health Services' use of the 244 and 236 Kingwood buildings in
North County
Budget to Actuals Report
Health Services - Public Health - Fund 274
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
State Grant
Environmental Health Fees
State Miscellaneous
Local Grants
State - Medicaid/Medicare
Vital Records
Other
Federal Grants
State Shared- Family Planning
Patient Fees
OHP Fee for Service
TOTAL RESOURCES
REQUIREMENTS
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Ok
Budget
Actuals
OA
4,964,969
1,086,019
2,194,822
843,783
843,050
280,000
192,656
139,017
152,634
96,300
3,981,365
1,213,172
1,806,557
1,971,892
777,348
342,960
186,177
124,837
118,228
105,742
22,993
80%
112%
82%
234%
92%
122%
97%
90%
77%
110%
5,730,341
1,238,499
874,346
856,892
807,530
300,000
289,152
144,060
125,000
96,300
18,260
2,989,454
856,648
208,754
812,226
565,492
127,770
80,365
35,174
82,919
73,431
15,808
52%
69%
24%
95%
70%
I
43%
28%
24%
66%
76%
87%
Projection
% $ Variance
6,509,718 114%
1,258,100 102%
923,833 106%
960,881 112%
1,129,380 140%
293,830 98%
305,273 106%
149,274 104%
165,838 133%
144,990 151%
32,379 177%
779,377. A
19,601
49,487
103,989: B
1
321,850: C
(6,170)
16,121.
5,214
40,838,
48,690:
14,119
10,793,250 10,651,270 99% ; 10,480,380 5,848,041 56% ; 11,873,496 113% ; 1,393,116:
Budget Actuals
Budget Actuals % Projection % $ Variance
Administration Allocation 2,665,047 2,665,046 100% : 2,927,789
Expenditures - 27,860
Personnel Services 10,484,069 9,047,822 86% . 11,548,869
Materials and Services 1 3,257,672 2,418,033 74% ! 2,348,073
Capital Outlay I 77,000 27,376 36% . 155,200
TOTAL REQUIREMENTS 16,483,788 14,158,277 86% ; 17,007,791
TRANSFERS
Transfers In- General Fund
Transfers In - TRT
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
A
B
c
D
E
F
G
TOTAL FUND BALANCE
714,609 24%
1 I
-
0%
5,043,484 44%
814,623 35% Ii
11,200 7% :
7 1
6,583,916 39%
2,927,789 100%
27,860 100%
10,376,278 90%
3,055,528 130% i
155,200 100%
16,542,655 97%
1,172,591: D
(707,455)! E
465,136:
GIUUUCL
Actuals
B fidget
Actuals % Projection
3,631,081
444,417
3,631,081 100%
444,417 100%
4,376,806
418,417
4,075,498 4,075,498 100% ; 4,795,223
% $ Variance
2,188,374 50% 4,208,145 96% ; (168,661). F
209,208 50% 418,417 100%
I I (108,751) 999% (108,751); G
I I I
2,397,582 50% ; , 4,517,811 94% ; (277,412):
Budget Actuals
Budget Actuals
0/0
2,869,932
(5,690,538)
4,075,498
3,049,370 106%
(3,507,006)
4,075,498
2,555,592
(6,527,411)
4,795,223
3,618,039 142%
(735,875)
2,397,582
$ 1,254,892
$ 3,617,861 288% ; $ 823,404 $ 5,279,746 641%
Projection % $ Variance
3,618, 039 142% : 1,062,447:
(4,669,159) 1,858,252
4,517,811 ; (277,412);
$ 3,466,691 421% ; $2,643,287:
Carryforward of unbudgeted funds are related to vacancies in COVID Team and Public Health Modernization; Includes additional funds for Tobacco
Prevention and Problem Gambling
Carryforward from FY22 of appx. $40K for Living Well and Diabetes Prevention Programs, as well as reclassifying $60K from Jefferson County for
disease investigation
Medicaid revenue trending more than budgeted for the Family Support Services - Nurse Home Visiting Programs
Personnel projections based on year to date vacancy savings and assume 6% moving forward.
Increase in expenditures related to additional funds in Prevention Services, including Tobacco Prevention, Diabetes Prevention, and Alcohol and
Drug Prevention
Due to Health Officer vacancy, anticipate returning associated County General Fund ($168K).
Transfers Out are increased to cover the additional construction costs proportional to Health Services' use of the 244 and 236 Kingwood buildings in
North County
Budget to Actuals Report
Community Development - Fund 295
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Admin - Operations
Code Compliance
Building Safety
Electrical
Onsite Wastewater
Current Planning
Long Range Planning
TOTAL RESOURCES
REQUIREMENTS
Admin - Operations
Code Compliance
Building Safety
Electrical
Onsite Wastewater
Current Planning
Long Range Planning
TOTAL REQUIREMENTS
TRANSFERS
Transfers In - General Fund
Transfers In - CDD Electrical
Reserve
Transfers Out
Transfers Out - CDD Reserve
TOTAL TRANSFERS
FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
0/0
Budget
Actuals
138,716
842,906
3,819,940
914,750
1,056,678
1,980,521
826,806
153,688 111% a
995,865 118%
4,325,818 113%
979,129 107%
983,462 93%
2,223,570 112% ;
880,902 107%
Projection % $ Variance
153,445 72,452 47% : : 145,645 95% : (7,800)i
1,171,592 450,554 38% ! ! 896,467 77% _ (275,125); A
4,821,160 2,030,659 42% ! 4,417,160 92% (404,000) A
1,022,005 394,303 39% ! ! 803,505 79% (218,500) A
1,017,678 341,988 34% ! ! 801,178 79% ! (216,500) A
2,425,334 907,378 37% . 1,911,184 79% (514,150). A
1,064,305 442,107 42% ! ! 893,978 84% (170,327)0 A
s c A
9,580,316 10,542,434 110% ; 11,675,519
4,639,440 40% ; , 9,869,117 85% ; (1,806,402);
Budget Actuals
Budget
Actuals
3,137,795
617,012
2,284,444
556,531
765,935
1,769,333
847,839
9,978,889
2,960,981 94%
618,343 100%
2,022,820 89%
553,223 99%
643,079 84%
1,589,882 90%
575,615 68%
8,963,943 90%
3,432,980
805,614
2,538,721
641,837
753,369
2,062,044
998,739
11,233,304
Projection % $ Variance
1,484,125 43%
350,317 43%
951,196 37%
271,342 42%
358,942 48%
729,315 35%
413,365 41%
4,558,603 41%
3,018,365 88% : 414,615: B
728,486 90% ! 77,128; B
1,970,675 78% ! 568,046 B
545,770 85% ! 96,067 B
741,369 98% ! 12,000
1,577,434 76% ! 484,610; B
995,839 100% ; 2,900
o
9,577,938 85% ; 1,655,366:
Budget Actuals
Budget
Actuals
290,000
170,661 59% : 160,000
(99,360) (99,360) 100%
(461,262) (1,230,508) 267%
(270,622) (1,159,207) 428%
(112,619)
(958,966)
(911, 585)
70,558 44%
(56,292) 50%
(416,424) 43%
8
(402,158) 44%
Projection % $ Variance
160,000 100% : ; C
82,436 82,436: D
(112,619) 100%
(1,196,652) 125%; (237,686): E
8 I
(1,066,835) 117% : (155,250);
Budget Actuals
Budget
Actuals
Beginning Fund Balance 1,432,367 1,749,673 122% : 2,168,956 103%
Resources over Requirements (398,573) 1,578,491 80,837 ,
Net Transfers - In (Out) (270,622) (1,159,207) (402,158)
$ 1,847,636 114% : : $ 1,393,300 86% : ($233,834):
Projection % $ Variance
2,168,956 103%
291,179
(1,066,835)
72,452:
(151,036)
(155,250);
TOTAL FUND BALANCE
$ 763,172 $ 2,168,956 284%
2,096,504
442,215
(911,585)
$ 1,627,134
A YTD revenue collection is lower than anticipated due to application volume decrease
g Projections reflect unfilled positions
c $40K to Current Planning will be transferred as needed
D Transfer in from reserves anticipated due to revenue collection less than anticipated
E Transfer out projection increased due to reduced expenditures related to unfilled FTE
,01ES
0
Budget to Actuals Report
Road - Fund 325
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Motor Vehicle Revenue
Federal - PILT Payment
Other Inter -fund Services
Forest Receipts
Sale of Equip & Material
Cities-Bend/Red/Sis/La Pine
Miscellaneous
Interest on Investments
Mineral Lease Royalties
State Miscellaneous
Assessment Payments (P&I)
TOTAL RESOURCES
REQUIREMENTS
Personnel Services
Materials and Services
Capital Outlay
TOTAL REQUIREMENTS
TRANSFERS
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
17,485,000 19,740,504 113%
2,096,751 2,195,918 105%
1,221,632 1,254,413 103%
627,207 792,420 126%
449,150 341,833 76%
560,000 155,269 28%
67,340 68,747 102%
59,109 55,083 93%
60,000 148,267 247% ;
3,460 16,052 464%
19,483,147
2,200,000
1,311,901
882,502
426,000
403,731
77,610
54,172
50,000
10,405,144
2,239,616
168,989
269,717
266,129
37,754
34,061
11,497
20,000
3,367
53%
102%
13%
0%
63%
66%
49%
63%
23%
22,629,649 24,768,506 109% ; 24,889,063 13,456,274 54%
Projection
% $ Variance
20,103,788 103%
2,239,616 102%
1,311,901 100%
792,322 90%
455,563 107%
403,731 100%
77,610 100%
81,950 151%
50,000 100%
20,000
10,000
620,641: A
39,616; B
I
(90,180):
1
29,563;
I
27,778! C
20,000!
10,000. D
25,546,482 103% : 657,418:
Budget Actuals
0/0
Budget Actuals
6,916,229
7,843,400
264,500
6,751,810 98%
6,877,560 88% a
141,754 54%
15,024,128 13,771,124 92%
7,802,271
8,265,356
121,369
Projection % $ Variance
3,528,742 45% : 7,483,552 96%
{ � I
2,780,012 34% 8,265,336 100%
40,748 34% ! I 121,369 100%
I f ,
16,188,996 6,349,502 39% ; , 15,870,257 98%
Budget Actuals
Budget Actuals
318,719: E
20; I
318,739:
Projection % $ Variance
(11,757,547) (11,757,547) 100% : (12,330,136) (7,440,775) 60% : : (12,330,136) 100%
(11,757,547) (11,757,547) 100% ; (12,330,136) (7,440,775) 60% ; ; (12,330,136) 100%
Budget Actuals
Budget Actuals
6,383,832
e 7,605,521
(11,757,547)
8,566,521 134% : 5,892,967
10,997,382 1 8,700,067
1
(11,757,547) , (12,330,136)
Projection % $ Variance
7,806,356 132% : : 7,806,356 132% : 1,913,390:
7,106,773 °9,676,225 976,157
1 i
(7,440,775) . ! (12,330,136)
$ 2,231,806 $ 7,806,356 350% ; $ 2,262,898
.11
$ 7,472,354 330% ; ; $ 5,152,445 228% ; $2,889,547:
A Updated fall projection per AOC/CRP
B Actual payment higher than budget
c Investment Income projected to come in lower than budget
D Updated based on YTD actuals trending higher than budgeted
E Projected Personnel savings based on FY22/FY23 average vacancy rate of 4.1 %
Budget to Actuals Report
Adult P&P - Fund 355
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
DOC Grant in Aid SB 1145
CJC Justice Reinvestment
DOC Measure 57
State Miscellaneous
Interfund- Sheriff
Gen Fund/Crime Prevention
Oregon BOPPPS
Interest on Investments
Miscellaneous
Electronic Monitoring Fee
DOC-Family Sentence Alt
Probation Work Crew Fees
Probation Supervision Fees
TOTAL RESOURCES 5,840,250 6,178,356 106% ; 6,134,018 3,147,360 51% ; , 6,138,805 100% ; 4,787:
50.0%
Year Complete
Fiscal Year 2022 1 Fiscal Year 2023
Budget
Actuals
Budget
Actuals
0/0
4,202,885
781,597
255,545
138,000
50,000
50,000
24,281
45,193
500
2,500
118,250
1,500
170,000
4,734,453 113%
892,038 114%
244,606 96%
96,068 70%
55,000 110%
50,000 100%
20,318 84%
19,125 42%
3,904 781%
280 11%
58,958 50%
- 0%
3,606 2%
4,734,453
892,038
244,606
123,453
50,000
50,000
20,318
18,151
500
500
2,367,226
446,019
271,606
10,837
25,000
26,320
72
279
9%
50%
0%
0%
145%
14%
56%
Projection
% $ Variance
4,734,453
892,038
271,606
60,000
50,000
50,000
20,318
59,390
500
500
100%
100% '
100%
327%
100%
100%
27,000! A
(63,453)1 B
41,239; C
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services 5,379,503 4,864,354 90% : 5,683,822 2,462,440 43% : : 5,023,933 88% : 659,889: D
Materials and Services 1 1,700,412 1,528,224 90% ' 1,883,614 697,967 37% _ ; 1,801,414 96% ' 82,200' E
i
Capital Outlay - 8,475 598 7% ! 0 8,475 100%
1 a 1 a a
TOTAL REQUIREMENTS : 7,079,915 6,392,578 90% : 7,575,910 3,161,005 42% : : 6,833,821 90% : 742,089:
TRANSFERS
ODUUC.
Actuals % Budget Actuals °/ Projection °/ $ Variance
tl
Transfers In- General Funds 662,046 662,045 100% : 536,369 268,176 50% : 536,369 100%
Transfer to Vehicle Maint (190,974) (190,974) 100% o1 a i (69,277) (34,638) 50% ! ! (69,277) 100%
[
TOTAL TRANSFERS 471,072 471,071 100% ; 467,092 233,538 50% ; , 467,092 100%
FUND BALANCE
Budget Actuals % Budget Actuals
Projection % $ Variance
Beginning Fund Balance 2,739,775 2,982,055 109% : 3,100,000 3,238,905 104% : e 3,238,905 104% : 138,904:
Resources over Requirements a 1 (1,239,665) (214,221) (1,441,892) (13,646) . . (695,016) 746,876
Net Transfers - In (Out) 471,072 471,071 467,092 233,538 ' ' 467,092 '
1 1 1 1 I
TOTAL FUND BALANCE : $ 1,971,182 $ 3,238,905 164% ; $ 2,125,200 $ 3,458,797 163% : $ 3,010,980 142% ; $885,780:
A DOC has increased funds for M57. Deschutes County received an additional $27K for housing and curriculum training.
g Close out of Adult Treatment Court. No longer accepting new clients.
c Investment Income projected to come in higher than budget
D Projected Personnel savings based on FY22/FY23 average vacancy rate of 11%
E Adult Treatment Court Closure and based on other expense trends.
Budget to Actuals Report
Road CIP - Fund 465
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
•
Projection
% $ Variance
State Miscellaneous 2,191,461 1,000,000 46% 1,818,500 - 0% : 818,500 45% : (1,000,000):A
a s a a
Interest on Investments 279,729 124,832 45% 124,563 143,877 116% ; ; 303,850 244% ; 179,287; B
TOTAL RESOURCES 2,471,190 1,124,832 46% ; 1,943,063 143,877 7% ; : 1,122,350 58% (820,713):
REQUIREMENTS
Budget Actuals % Budget Actuals % Projection % $ Variance
Materials and Services 109,870 109,870 100% a 127,640 63,820 50% a 127,640 100%
Capital Outlay 29,612,821 7,996,247 27% a
28,259,526 12,730,967 45% ; 27,388,840 97% 870,686!
s a a
TOTAL REQUIREMENTS ; 29,722,691 8,106,117 27% ; 28,387,166 12,794,787 45% : , 27,516,480 97% ; 870,686:
TRANSFERS
Budget Actuals % Budget Actuals
Projection % $ Variance
Transfers In 12,193,917 10,672,113 88% : 14,230,313 4,889,361 34% 14,230,313 100%
a a a a
TOTAL TRANSFERS 12,193,917 10,672,113 88% : 14,230,313 4,889,361 34% : , 14,230,313 100%
FUND BALANCE
Budget Actuals % Budget Actuals
Projection % $ Variance
Beginning Fund Balance 20,374,044 23,533,004 116% 24,548,274 27,223,832 111% 27,223,832 111% 2,675,558:
Resources over Requirements (27,251,501) (6,981,285) (26,444,103) (12,650,910) ; ; (26,394,130) !a 49,973;
a I I I
Net Transfers - In (Out) 12,193,917 10,672,113 14,230,313 4,889,361 14,230,313 1 a
TOTAL FUND BALANCE
$ 5,316,460 $ 27,223,832 512% ; $ 12,334,484 $ 19,462,283 158% : ; $ 15,060,015 122% ; $2,725,531:
A $1M was budgeted in FY23, but received in FY22
g Investment Income projected to come in higher than budget
Budget to Actuals Report
Road CIP (Fund 465) - Capital Outlay Summary by Project
FY23 YTD December 31, 2022 (unaudited)
50.0%
Year Completed
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
Projection % $ Variance
Terrebonne Refinement Plan
US 20 at Tumalo
Tumalo Road / Tumalo Place
Old Bend Rdm/Tumalo Rd Inter
NE Negus and 17TH
Hunnel Rd: Loco Rd to Tumalo Rd
Transportation System Plan Update
Gribbling Rd Bridge
Terrebonne Wastewater Feasibility St.
Rickard Rd: Groff Rd to US 20
Paving Powell Butte Hwy
Smith Rock Way Bridge Replace
Deschutes Mkt Rd/Hamehook Round
Paving Cottonwood: Us 97 To BSNF RR
Paving Desch Mkt Rd: Yeoman Hamehoo
Paving Alfalfa Mkt Rd: Mp 4 Dodds
Paving Of Hamby Rd: Us 20 To Butler
Powell Butte Hwy/Butler Market RB
Wilcox Ave Bridge #2171-03 Replacem
US 20: Tumalo Multi -Use Path Crossing
Highway Warning Systems 2021
Tumalo Wastewater Feasibility Study
Paving Tumalo Rd/Deschutes Mkt Rd
Slurry Seal 2022
Paving of Rosland Rd: US 20 to Draf
Intersection Safety Improvements
Hamehook Rd Bridge #16181 Rehabilitation
NW Lower Bridge Way: 43rd St to Holmes Rd
Northwest Way: NW Coyner Ave to NW Altmeter Wy
Slurry Seal 2023
Terrebonne Wastewater System Phase 1
Tumalo Resevoir Rd: OB Riley to Sisemore Rd
Local Road Pavement Preservation
FY 22 Guardrail Improvements
FY 23 Guardrail Imrovements
Redmond District Local Roads
Bend District Local Roads
Sidewalk Ramp Improvements
Signage Improvements
TOTAL CAPITAL OUTLAY
$ 10,000,000 $
6,700,000
$ 7,319,310 $ 2,200,000 30% $ 7,319,310 100% $
- 6,700,000 6,700,000 100% 6,700,000 100% A
67,998
16,907
2,363,532 2,142,875 91%
2,168,940 637,975 29% 4,265,216 91,218 2% 4,820,216 113% (555,000)
108,510 86,081 79% 12,936 40,000 (40,000)
279,575 1,110 0% 818,500 44,635 5% 418,500 51% 400,000
35,130 -
1,716,142 1,391,051 81% -
931,140 1,319,374 142%
505,000 1,869 0% 985,000 43,525 4% 485,000 49% 500,000
671,000 208,367 31% 1,663,000 139,931 8% 1,663,000 100%
618,144 499,075 81%
310,838 0% 443,000 - 0% 0% 443,000
265,000 2,638 1% 1,200,000 1,788,826 149% 1,788,826 149% (588,826)
200,000 1,912 1% 333,000 999,285 300% 999,286 300% (666,286)
150,000 38,562 26% 785,000 60,755 8% 335,000 43% 450,000
100,000 - 0% 160,000 - 0% 160,000 100%
1,250,000 1,200,000 96%
69,536 -
219
1,640 246,000 32,693 13% 32,693 13% 213,308
• 1,148 337,183 337,183 (337,183)
380,000 0% 380,000 100%
150,000 0% 0% 150,000
96,500 0% 40,000 41% 56,500
100,000 155 0% 100,000 100% -
815,000 0% 815,000 100%
300,000 0% 300,000 100% -
1,000,000 0% - 0% 1,000,000 B
100,000 0% 100,000 100%
200,000 0% 200,000 100% C
100,000 114,378 114% -
150,000 0 % 75,000 50 % 75,000
500,000 - 0% - C
500,000 - 0% - C
75,000 156,557 209% 50,000 182,670 365% 182,670 365% (132,670)
100,000 1,843 2% 97,156 97,156 (97,156)
$ 29,612,821 $ 7,996,247 275 $ 28,259,5261 12,730,967 45 % $ 27,388,840 971/4 $ 870,687
A Budgeted in FY 22 in project US 20: Cook Ave/OB Riley Rd (Tumalo)
B This project will be moved to FY 24
C These projects were re -named to Local Road Pavement Preservation
\TES
Budget to Actuals Report
Solid Waste - Fund 610
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Franchise Disposal Fees
Private Disposal Fees
Commercial Disp. Fee
Franchise 3% Fees
Yard Debris
Miscellaneous
Interest on Investments
Special Waste
Recyclables
Leases
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
7,124,000
2,827,000
2,686,000
290,000
300,000
55,000
41,599
15,000
12,000
1
6,891,500
3,191,189
3,075,123
337,878
268,060
88,470
27,916
37,718
12,980
1
97% ;
113% e
114% !
117% 1 o
891
%
161% ,
67%
251% ,
108%
100%
7,210,000
3,337,000
3,234,000
305,000
290,000
70,000
30,498
15,000
12,000
1
2,964,850
1,616,864
1,609,741
138,549
161,422
67,148
18,273
42,856
4,438
41%
48%
50%
45%
56%
96%
60%
286%
37%
100%
TOTAL RESOURCES 13,350,600 13,930,834 104% ; 14,503,499
REQUIREMENTS
Personnel Services
Materials and Services
Capital Outlay
Debt Service
TOTAL REQUIREMENTS
TRANSFERS
SW Capital & Equipment
Reserve
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
6,624,142 46%
Projection
% $ Variance
7,210,000 100%
3,337,000 100%
3,234,000 100%
305,000 100% e
1
290,000 100% .
1
111,000 159%
35,570 117%
45,000 300% 1
12,000 100%
1 100%
a
A
A
-vI
B
-'1 C
41,000, D
5,072! E
I
30,000; F
I
14,579,571 101% : 76,072:
Budget Actuals % Budget
Actuals
%
2,754,132
5,651,103
53,141
1,251,615
2,694,834 98%
5,192,786 92%
1
76,304 144%
828,197 66%
3,277,684
6,473,358
264,000
1,739,630
9,709,991 8,792,122 91% ; 11,754,672
Projection % $ Variance
1,477,759 45% ;
2,440,827 38%
109,970 42% I
745,586 43% !
1 1
4,774,142 41%
3,277,684 100%
6,473,358 100%
I
264,000 100%
1,739,630 100%
11,754,672 100%
Budget Actuals
• Budget
Actuals
OA
(6,029,323) (6,029,323) 100% ; (5,299,665) (3,966,978) 75%
(6,029,323) (6,029,323) 100% ; (5,299,665) (3,966,978) 75%
Projection % $ Variance
(5,299,665) 100%
(5,299,665) 100%
Budget Actuals
• Budget Actuals
Projection % $ Variance
2,972,234 3,957,273 133% : 3,107,198 3,066,662 99% : : 3,066,662 99% _ (40,535):
1 3,640,609 5,138,712 2,748,827 1,850,000 2,824,899 76,072
1 (6,029,323) (6,029,323) I I (5,299,665) (3,966,978) ! _ (5,299,665) 1
1 1 I 1
$ 583,520 $ 3,066,662 526% ; $ 556,359 $ 949,684 171% : : $ 591,896 106% ; $35,537:
A Total disposal fee projections reflect management's best estimate of revenues to be collected; disposal tons are typically higher in the summer with
reductions in winter. YTD volumes are running 2% less than last year-to-date. Franchise disposal fee payments of $426K were not received from
Republic Services (Bend Garbage, High Country, Wilderness) by closing.
g Annual fees due April 15, 2023; received year-to-date monthly installments from Republic
c Revenue is seasonal with higher utilization in summer months
D Proceeds from cell 9 rock excavation have positively impacted miscellaneous revenue
E Investment Income projected to come in higher than budget
F Revenue source is unpredictable and dependent on special clean-up projects of contaminated soil and asbestos (i.e. gas station remediation)
uTES
Budget to Actuals Report
Fair & Expo - Fund 615
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Events Revenue
Food & Beverage
Rights & Signage
Storage
Horse Stall Rental
Camping Fee
Interest on Investments
Miscellaneous
Interfund Payment
TOTAL RESOURCES
REQUIREMENTS
Personnel Services
Personnel Services - F&B
Materials and Services
Materials and Services - F&B
Debt Service
TOTAL REQUIREMENTS
TRANSFERS
Transfers In - Room Tax
Transfers In - Park Fund
Transfers In - County Fair
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
578,000
513,500
105,000
77,500
71,500
19,500
474
250
30,000
786,724 136%
792,639 154% o
38,192 36%
46,525 60%
66,636 93%
0
11,675 60% i
5,301 999%
2,032 813%
30,000 100%
745,759
415,000
105,000
65,000
49,000
20,000
5,221
3,554
399,268
343,566
35,400
25,126
32,980
3,475
6,596
1,374
54%
83%
34%
39%
67%
17%
126%
39%
1,395,724 1,779,723 128%
Projection
% $ Variance
799,000
619,000
74,000
64,000
98,000
23,000
14,690
1,400
107%
149%
70%
98%
200% o
115%
281%
39%
i
53,241
204,000
(31,000);
(1,000);
49,000
3,000:
9,469; A
(2,154);
1,408,534 847,785 60% ; 1,693,090 120% ; 284,556:
Budget Actuals
Budget Actuals
1,118,980
181,593
818,804
282,500
103,000
2,504,877
1,129,821 101%
200,062 110%
852,050 104%
342,748 121%
101,799 99%
2,626,480 105%
Projection % $ Variance
1,256,902 591,166 47% 1 1,100,463 88% 1 156,439: B
170,247 36,906 22% 133,105 78% : 37,142: C
965,684 493,122 51% 972,000 101% : (6,316)
273,950 201,756 74% 346,000 126% : (72,050);
101,270 57,050 56% 101,270 100%
e o i
2,768,054 1,380,001 50% ; : 2,652,839 96% : 115,215:
Budget Actuals
Budget Actuals
1,093,513
30,000
150,000
(310,777)
962,736
1,049,581 96%
30,000 100%
150,000 100%
(310,777) 100% 0
918,804 95%
Projection % $ Variance
1,101,342 550,668 50%
30,000 15,000 50%
.
(427,215) (213,606) 50%
704,127 352,062 50%
1,112,066 101%
30,000 100%
(427,215) 100%
10,724: D
� 8
714,851 102% ; 10,724:
Budget Actuals
OA
Budget Actuals
Beginning Fund Balance
Resources over Requirements o
Net Transfers - In (Out)
TOTAL FUND BALANCE
750,673
(1,109,153)
962,736
923,473 123%
(846,757)
918,804
971,352
(1,359,520) (532,216)
704,127
352,062
995,519 102% i
$ 604,256 $ 995,519 165% ; $ 315,960
$ 815,365 258%
A Investment Income projected to come in higher than budget
8 Projected Personnel savings based on FY22/FY23 average vacancy rate of 20%
c Projected Personnel based on vacancy savings to date
D Transfers expected to be higher than budget due to increased Room Tax revenue
Projection % $ Variance
995,519 102% 1 24,167:
(959,749) 399,771;
714,851 10,724;
$ 750,622 238% ; $434,662:
‘1 ES Budget to Actuals Report
Annual County Fair - Fund 616
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Gate Receipts
Concessions and Catering
Carnival
Commercial Exhibitors
Fair Sponsorship
State Grant
Rodeo
RN Camping/Horse Stall Rental
Livestock Entry Fees
Merchandise Sales
Interest on Investments
TOTAL RESOURCES
REQUIREMENTS
Personnel Services
Materials and Services
TOTAL REQUIREMENTS
TRANSFERS
Transfer In - TRT 11/0
Transfer Out - Fair & Expo
Transfers Out
TOTAL TRANSFERS
FUND BALANCE
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
OA
550,000
385,000
330,000
110,000
83,500
52,000
20,000
25,500
4,500
738,029
526,737
415,716
86,200
51,035
53,167
24,050
19,815
5,239
2,683
134% o
137% o
126% I
78%
61% I
102% 1
120%
78%
0%
1
710,000
505,000
385,000
80,000
61,000
53,167
24,000
20,000
5,000
3,500
2,713
782,364
815,458
433,682
117,100
101,370
53,167
30,970
17,520
1,925
3,245
6,034
110%
1
161%=
113% 1
146%
166%
100% o
129%
88%
I
39%
93%
222%
Projection
% $ Variance
782,424 110%
815,461 161% I
433,682 113% I
117,100 146% e
109,370 179% 1
53,167 100%
30,970 129%
17,520 88%
2,169 43%
3,245 93%
14,160 522%
72,424:
310,461;
I
48,682.
37,100;
1
48,370;
6,970
(2,480):
(2,831);
(255)
11,447. A
1,560,500 1,922,671 123% ; 1,849,380 2,362,835 128% ; : 2,379,267 129% ; 529,887:
Budget Actuals
OA
Budget Actuals
155,959
1,312,172
1,468,131
36,681 24%
1,316,102 100%
1,352,783 92%
169,445
1,682,585
1,852,030
Projection % $ Variance
93,848 55% : 178,174 105%
1,735,308 103%;
' 1,737,585 103% I
1 1 1
1,829,156 99% ; , 1,915,759 103%
(8,729):
(55,000);
(63,729):
Budget Actuals
Budget Actuals
%
75,000 75,000 100% ;
(150,000) (150,000) 100%
(75,000)
(75,000) 100%
75,000 37,500 50%
(231,706) (115,848) 50% a
(156,706) (78,348) 50% ;
Budget Actuals
Budget Actuals
0/0
92,369
(75,000)
(109,033) 999%
569,888
(75,000)
384,715
(2,650)
(156,706)
385,854 100%
533,679
(78,348)
$ 17,369 $ 385,854 999% ; $ 225,358
$ 841,185 373%
A Investment Income projected to come in higher than budget
Projection % $ Variance
75,000 100%
(231,706) 100%
(156,706) 100%
Projection % $ Variance
385,854 100% : 1,139:
463,508 466,158
1 I
(156,706) -y
$ 692,656 307% ; $467,298:
Budget to Actuals Report
Annual County Fair - Fund 616
RESOURCES
Gate Receipts
Carnival
Commercial Exhibitors
Livestock Entry Fees
RN Camping/Horse Stall Rental
Merchandise Sales
Concessions and Catering
Fair Sponsorship
TOTAL FAIR REVENUES
OTHER RESOURCES
State Grant
Interest
Miscellaneous
TOTAL RESOURCES
REQUIREMENTS
Personnel
Materials & Services
TOTAL REQUIREMENTS
TRANSFERS
Transfer In - TRT 1
Transfer Out - F&E Reserve
Transfer Out - Fair & Expo
TOTAL TRANSFERS
Net Fair
Beginning Fund Balance on Jan 1
Ending Balance
19,944
5,239
295,093
81,125
782,364
433,682
436,292
1,925
17,392
3,245
497,366
126,300
1,870,865 $ 2,298,566
53,167
1,194
Fair 2021
Fair 2022
Actuals to
Date
2022
Projection
$ 738,029
415,716
315,719
$
$ 782,364
433,682
436,292
1,925
17,392
3,245
497,366
126,300
$ 2,298,566
53,167 53,167
5,794 5,794
$ 2,357,526 $ 2,357,526
103,199 102,763 102,763
1,249,932 ;.` 1,722,703 1,722,703
$ 1,353,131 $ 1,825,466 $ 1,825,466
74,750
(150,000)
$ (75,250)
$ 496,845
$ (48,694)
68,750
(96,540)
68,750
(96,540)
(27,790) $ (27,790)
504,270 $ 504,270
448,151 $ 448,151
952,421 $ 952,421
ES
® Budget to Actuals Report
` Fair & Expo Capital Reserve - Fund 617
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Interest on Investments
Local Government Payments
TOTAL RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
8,544 8,012 94%
7,414
Projection
% $ Variance
14,342 193% : : 33,050 446% : 25,636; A
55,555 55,555 55,555
1 I B 1
8,544 8,012 94% ; 7,414 69,897 943% : 88,605 999% ; 81,191:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Materials and Services 180,000 8,564 5% ; 220,000 423 0% :: 220,000 100%
Capital Outlay 388,000 (894) 0% = 650,000 - 0% ! 650,000 100% ! B
I 1
TOTAL REQUIREMENTS : 568,000 7,670 1% : 870,000 423 0% : , 870,000 100% : ,
TRANSFERS
Budget Actuals
OA
Budget Actuals
Projection % $ Variance
Transfers In -TRT 1% 498,901 479,502 96% : 501,683 250,836 50% : 506,281 101% : 4,598: C
Transfers In - Fair & Expo 300,000 300,000 100% ! 416,437 208,218 50% : 416,437 100%
Transfers In -Annual County Fair. - 231,706 115,848 50% o a 1 231,706 100%
1 1 1 1 1
TOTAL TRANSFERS 798,901 779,502 98% : 1,149,827 574,902 50% : , 1,154,425 100% : 4,598:
FUND BALANCE
Budget Actuals
Budget Actuals
Projection % $ Variance
Beginning Fund Balance 1,101,663 1,029,596 93% a 1,299,942 1,809,440 139% ; e 1,809,440 139% : 509,498:
Resources over Requirements : (559,456) 342 (862,586) 69,473 (781,395) 81,191
Net Transfers - In (Out) 798,901 779,502 1,149,827 574,902 1,154,425 a 4,598;
I
$ 1,341,108 $ 1,809,440 135% : $ 1,587,183 $ 2,453,816 155% : : $ 2,182,470 138% ; $595,287:
TOTAL FUND BALANCE
A Investment Income projected to come in higher than budget
g Capital Outlay appropriations are a placeholder should viable projects be recommended and approved for construction
c Transfers expected to be higher than budget due to increased Room Tax revenue
Budget to Actuals Report
RV Park - Fund 618
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
RV Park Fees < 31 Days
Cancellation Fees
RV Park Fees > 30 Days
Washer / Dryer
Miscellaneous
Vending Machines
Interest on Investments
TOTAL RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
Budget
Actuals
495,000 551,683 111% '
15,725
10,500 8,499 81% 1
5,000 3,476 70% ‘
2,500 3,731 149%
2,500 1,021 41%
2,024 578 29%
517,524
584,713 113% ;
605,000
14,000
13,000
4,200
3,750
1,750
552
260,884 43%
5,590 40%
8,156 63%
3,402 81%
1,211 32%
978 56%
1,163 211%
a
642,252 281,383 44% ;
REQUIREMENTS Budget
Actuals
Budget Actuals
Personnel Services
Materials and Services
Debt Service
TOTAL REQUIREMENTS ;
19,456
310,805
221,927
552,188
1,643 8%
242,863 78%
221,629 100%
466,135 84% ;
111,153
259,755
223,273
Projection
% $ Variance
473,994 78%' (131,006)' A
9,607 69% ; (4,393);
11,923 92% ; (1,077); B
5,302 126% 1,102
2,557 68% (1,193);
1,498 86% ; (252);
2,660 482% 2,108; C
; 3
507,541 79% : (134,711):
Projection % $ Variance
39,373 35%
119,064 46% a ,
165,533 74% :
97,451 88%
219,839 85%
223,273 100%
13,702: D
39,916
594,181 323,969 55% ; , 540,563 91% ; 53,618;
TRANSFERS Budget
Transfers In - Park Fund
Transfers In - TRT Fund
Transfer Out - RV Reserve
TOTAL TRANSFERS
Actuals
Budget Actuals
160,000
20,000
(132,042)
47,958
160,000 100%
20,000 100%
(132,042) 100%
Y
47,958 100% ;
160,000
20,000
(261,566)
(81,566)
Projection % $ Variance
160,000 100%
9,996 50%
as
(130,782) 50%
a a
39,214 -48%
160,000 100%
20,000 100%
(261,566) 100%
(81,566) 100%
FUND BALANCE Budget
Beginning Fund Balance
Resources over Requirements
Net Transfers - In (Out)
TOTAL FUND BALANCE
Actuals
Budget Actuals
(34,664) 118,578
47,958 47,958
116,415
48,071
(81,566)
Projection % $ Variance
166,536 143% a
as
(42,586)
39,214
a 1
•
166,536 143% : 50,121:
(33,022) (81,093)
a
(81,566)
$ 13,294 $ 166,536 999% ; $ 82,920 $ 163,164 197% ; ; $ 51,948 63% ($30,972):
A Expecting less volume due to higher fuel prices and economic concerns
g Expecting less volume due to new RV park in Redmond offering stays longer than 45 days
c Investment Income projected to come in higher than budget
D Projected Personnel based on vacancy savings to date
Budget to Actuals Report
RV Park Reserve - Fund 619
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
Projection
% $ Variance
Interest on Investments 7,546 6,354 84% e 6,298 8,382 133% ; : 18,950 301%
TOTAL RESOURCES 7,546 6,354 84% : 6,298 8,382 133% : : 18,950 301% ;
REQUIREMENTS
Budget Actuals
OA
12,652; A
0
12,652:
Budget Actuals % Projection % $ Variance
Capital Outlay 100,000 885 1% : 100,000 4,837 5%
TOTAL REQUIREMENTS ; 100,000
TRANSFERS
Transfer In - RV Park Ops
TOTAL TRANSFERS
FUND BALANCE
885 1% ; 100,000
100,000 100%
4,837 5% ; 100,000 100%
Budget Actuals % Budget Actuals
Projection % $ Variance
132,042 132,042 100% 261,750 130,782 50% : = 261,566 100% : (184):
a � o ,
132,042 132,042 100% ; 261,750 130,782 50% ; , 261,566 100% ; (184);
Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 784,466 1,054,426 134% . 1,172,718 1,191,937 102% : 1,191,937 102% : 19,219:
Resources over Requirements (92,454) 5,469 (93,702) 3,544 (81,050) 12,652;
Net Transfers - In (Out) 132,042 132,042 261,750 130,782 261,566 (184);
TOTAL FUND BALANCE
$ 824,054 $ 1,191,937 145% ; $ 1,340,766 $ 1,326,263 99% ; ; $ 1,372,453 102% ; $31,687:
A Investment Income projected to come in higher than budget
g Capital Outlay appropriations are a placeholder
x‘NIES c
Budget to Actuals Report
Risk Management - Fund 670
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Workers' Compensation
General Liability
Unemployment
Property Damage
Vehicle
Interest on Investments
Claims Reimbursement
Skid Car Training
Process Fee- Events/ Parades
Miscellaneous
TOTAL RESOURCES
REQUIREMENTS
General Liability
Workers' Compensation
Insurance Administration
Property Damage
Vehicle
Unemployment
TOTAL REQUIREMENTS
TRANSFERS
Transfers Out - Vehicle
Replacement
TOTAL TRANSFERS
FUND BALANCE
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
1,120,766
944,278
323,572
393,546
227,700
101,111
25,000
10,000
1,000
1,164,543
940,773
334,147
409,593
227,700
50,142
1,280,876
1,485
180
104%
100%
103%
104%
100%
50%
999%
0%
149%
1,234,761
892,681
430,179
419,566
248,764
49,346
25,000
10,000
1,000
180
612,697
446,340
320,494
209,783
124,382
60,025
4,766
(144)
405
50%
50%
75%
50%
50%
122%
19%
-1 %
41%
0%
3,146,973 4,409,440 140% ; 3,311,477
1,778,749 54%
Projection
% $ Variance
1,234,761
892,681
430,179
419,566
248,764
134,010
25,000
100
1,000
180
3,386,241
100%
100%
100%
100%
100% ,
272%
100%
1%
100%
100%
102%
84,664 B
(9,900); C
74,764;
Budget Actuals % Budget
Actuals
OA
3,600,000
1,580,000
547,047
300,245
200,000
200,000
2,706,359 75% ; 3,000,000
953,365 60% 1,580,000
491,393 90% 607,558
604,926 201% 300,248
137,356 69% 200,000
89,053 45% ! 200,000
405,943
784,456
280,382
73,768
108,257
Projection % $ Variance
14%
50%
I 1
46%
25%
I �
54%
0%
6,427,292 4,982,451 78% ; 5,887,806
2,500,000 83%
2,000,000 127%
606,497 100%
280,000 93%
250,000 125%
200,000 100%
500,000: D
(420,000): E
1,061
20,248. F
(50,000): E
1,652,807 28%
5,836,497 99% ; 51,309:
Budget Actuals % Budget
Actuals
0/0
(3,500)
(3,500) 100%
(3,500) (1,746) 50%
(3,500)
(3,500) 100%
(3,500) (1,746) 50% ;
Budget Actuals % Budget
Actuals
Projection % $ Variance
(3,500) 100%
(3,500) 100%
Projection % $ Variance
Beginning Fund Balance 8,329,115 9,521,450 114% ; 7,687,180 8,944,938 116% : = 8,944,938 116% : 1,257,758'
Resources over Requirements (3,280,319) (573,012) (2,576,329) 125,942 (2,450,256) 126,073;
Net Transfers - In (Out) (3,500) (3,500) . (3,500) (1,746) (3,500)
$ 5,045,296 $ 8,944,938 177% ; $ 5,107,351 $ 9,069,134 178% : : $ 6,491,182 127% : $1,383,831:
TOTAL FUND BALANCE
A Unemployment collected on first $25K of employee's salary in fiscal year
g Investment Income projected to come in higher than budget
C Skid Car training resuming; but only for employees, revenue on this line item is from the public
D Trending lower than budget
E Trending higher than budget
F FY22 had abnormally high property damage; anticipating less in FY23
Budget to Actuals Report
Health Benefits - Fund 675
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
50.0%
Year Complete
Fiscal Year 2022 1 Fiscal Year 2023
Budget
Actuals
Budget
Actuals
%
Internal Premium Charges 18,767,900 19,164,548 102% 19,908,221 9,757,058 49%
COIC Premiums 1,589,000 1,255,305 79% 1,547,778 871,934 56%
Employee Co -Pay 1,200,000 1,238,034 103% 1,282,015 615,885 48%
Retiree / COBRA Premiums 1,060,000 1,438,217 136% 595,000 259,032 44%
Prescription Rebates 128,000 396,119 309% 175,000 280,620 160%
Interest on Investments 200,277 90,816 45% ; 95,686 81,118 85%
Claims Reimbursement & Other 82,000 1,487,600 999% . 55,000 61,662 112%
a
TOTAL RESOURCES 23,027,177 25,070,639 109% : 23,658,700 11,927,309 50% e
REQUIREMENTS
Budget Actuals % Budget Actuals
OA
Projection
% $ Variance
19,908,221 100% ' -i
1,547,778 100% ,
1,282,015 100%
I 1
595,000 100%
320,000 183% : 145,000! A
o i
177,660 186% 0 81,974; B
65,000 118% ; 10,000;
23,895,674 101% : 236,974:
Projection % $ Variance
Health Benefits 25,140,847 24,583,764 98% 0 21,597,563 9,490,400 44% : : 21,597,563 100% : ; C
Deschutes On -Site Pharmacy 2,970,575 3,381,197 114% . 3,779,608 869,711 23% ; � 3,779,608 100% ; = C
Deschutes On -Site Clinic 1,141,829 1,190,855 104% ; 1,212,497 395,619 33% ; ! 1,212,497 100% ; C
Wellness 171,142 138,211 81% ; 179,549 54,771 31% ; 179,549 100% ' ; C
TOTAL REQUIREMENTS : 29,424,393 29,294,027 100% : 26,769,217 10,810,502 40% : , 26,769,217 100% : ,
FUND BALANCE
Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 14,772,618 15,527,580 105% ; 11,925,656 11,304,191 95% ; ; 11,304,191 95% ; (621,465);
Resources over Requirements (6,397,216) (4,223,389) (3,110,517) 1,116,807 (2,873,543) 236,974
Net Transfers - In (Out) °
e1 o
TOTAL FUND BALANCE ; $ 8,375,402 $ 11,304,191 135% ; $ 8,815,139 $ 12,420,998 141% ; ; $ 8,430,648 96% ($384,491):
A Budget estimate is based on claims which are difficult to predict
B Investment Income projected to come in higher than budget
C Amounts are paid 1 month in arrears
Budget to Actuals Report
911 - Fund 705 and 710
FY23 YTD December 31, 2022 (unaudited)
RESOURCES
Property Taxes - Current Yr
Telephone User Tax
State Reimbursement
Police RMS User Fees
Contract Payments
User Fee
Data Network Reimbursement
Property Taxes - Prior Yr
Interest on Investments
Property Taxes - Jefferson Co.
Miscellaneous
TOTAL RESOURCES
REQUIREMENTS
50.0%
Year Complete
Fiscal Year 2022
Fiscal Year 2023
Budget
Actuals
OA
Budget
Actuals
Ok
9,803,579 9,931,743 101% a 10,402,834 9,823,261 94%
1,106,750 1,815,283 164% 1,668,000 459,654 28%
60,000 123,282 205% 810,000 30,000 4%
236,576 237,221 100% a 237,221 0%
147,956 157,552 106% 153,292 22,870 15%
233,576 140,986 60% 140,445 4,313 3%
162,000 244,799 151% 120,874 38,786 32%
115,000 92,601 81% 80,000 58,454 73%
96,867 69,988 72% 67,515 90,992 135%
I I
38,344 37,525 98% 39,497 35,493 90%
18,658 45,553 244% 25,000 14,005 56%
12,019,306 12,896,533 107%
13,744,678 10,577,828 77%
Budget Actuals % Budget Actuals
%
Projection
0/0
$ Variance
10,421,062 100%
1,668,000 100%
810,000 100%
237,221 100%
153,292 100%
I
140,445 100%
120,874 100%
80,000 100% I
209,610 310%
39,497 100%
25,000 100%
18,228: A
B
aC
D
142,095! E
13,905,001 101% ; 160,323:
Projection % $ Variance
Expenditures - 64,754 0% : : - 0% : 64,754:
Personnel Services 8,005,795 7,462,327 93% ; 8,606,196 3,796,511 44% ; 7,530,513 88% . 1,075,683. F
Materials and Services 3,582,212 2,915,749 81% ; 4,088,201 1,547,138 38% . . 4,088,201 100%
Capital Outlay 2,975,000 518,824 17% 5,010,246 807,952 16% ! ! 5,075,000 101% a (64,754)!
I 8 O I I i
TOTAL REQUIREMENTS , 14,563,007 10,896,900 75% : 17,769,397 6,151,601 35% : , 16,693,714 94% : 1,075,683:
FUND BALANCE
Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 11,850,783 10,709,072 90% e 12,950,799 12,708,705 98% _ : 12,708,705 98% : (242,094)=
Resources over Requirements 1 (2,543,701) 1,999,633 . (4,024,719) 4,426,227 I I (2,788,713) . 1,236,006;
1 : I
Net Transfers - In (Out) ' -
I I I ;
TOTAL FUND BALANCE : $ 9,307,082 $ 12,708,705 137% ; $ 8,926,080 $ 17,134,932 192% : : $ 9,919,992 111% ; $993,912;
A Current year taxes received primarily in November, February and May; actual FY22-23 TAV is 5.50% over FY21-22 vs. 5.55% budgeted
g Telephone tax payments are received quarterly
c State GIS reimbursements are received quarterly
D Invoices are mailed in the Spring
E Investment Income projected to come in higher than budget
F Projected Personnel savings based on FY22/FY23 average vacancy rate of 13.5%
olEs
BOARD OF
COMMISSIONERS
AGENDA REQUEST & STAFF REPORT
MEETING DATE: January 23, 2023
SUBJECT: Preparation for a Public Hearing: Commercial Activity in Conjunction with Farm
Use (Meadery on Highway 20 near Sisters)
RECOMMENDED MOTION:
NA; work session in preparation for a public hearing on January 25, 2023.
BACKGROUND AND POLICY IMPLICATIONS:
Staff will provide background and discuss issues for the Board of County Commissioners to
consider regarding the proposed commercial activities in conjunction with farm use (file
nos. 247-22-000024-CU, 22-025-SP, 22-757-A, 22-914-A).
BUDGET IMPACTS:
None
ATTENDANCE:
Nathaniel Miller, Associate Planner
Jacob Ripper, Principal Planner
DES
COMMU ITV DEVELOPMENT
MEMORANDUM
TO: Deschutes County Board of County Commissioners
FROM: Nathaniel Miller, AICP, Associate Planner
DATE: January 23, 2023
RE: Work Session: A Commercial Activity in Conjunction with Farm Use (Meadery) in the
Exclusive Farm Use Zone.
The Board of County Commissioners (Board) will conduct a Work Session on January 23, 2023, in
preparation for a Public Hearing on January 25, 2023, to consider a request for a commercial activity
in conjunction with farm use to establish a Meadery. The applications and appeals are identified as
file nos. 247-22-000024-CU, 22-025-SP, 22-757-A, 22-914-A. The subject property is located
approximately 0.5 miles southeast of the city limits of Sisters along Highway 20 which borders the
property to the southwest. The property is addressed at 68540 Highway 20, Sisters, and is further
identified on County Assessor's Map 15-10-10 as tax lot 700. A location map is included as
Attachment A.
I. BACKGROUND
The Applicant, John Herman, has requested a Conditional Use Permit for commercial activities in
conjunction with farm use to establish a Meadery (Honey Winery) with associated uses in the
Exclusive Farm Use Zone (EFU), and within the Airport Safety (AS), Surface Mining Impact Area (SMIA)
and Landscape Management (LM) Combining Zones. The request also includes a Site Plan Review
for the Meadery and associated uses. The proposed Meadery would be situated on the southern
portion of the property along Highway 20 and within the existing developed building, lawn, and road
network. The Meadery Production and Meadery Operations (processing & tasting room) would be
centralized in an existing farm structure (Winery Building) with the Winery Related Events and
parking areas around this location.
On September 7, 2022, the Deschutes County Planning Division administratively approved a
conditional use permit and site plan request (file nos. 247-22-000024-CU, 247-22-000025-SP) for the
proposed Meadery. An appeal was filed on September 19, 2022 by Central Oregon LandWatch (file
no. 247-22-000757-A) to that decision requesting a Public Hearing. The initial Public Hearing before
117 NW Lafayette Avenue, Bend, Oregon 97703 P.O. Box 6005, Bend, OR 97708-6005
(541) 388-6575 @ cdd@deschutes .org www.deschutes.org/cd
the Hearings Officer was on Wednesday, October 26th, 2022. The Hearings Officer issued a decision
on November 18th, 2022 which denied the proposal. On November 29, 2022, the applicant filed an
appeal to the Hearing Officer decision (file no. 247-22-000914-A) requesting a limited de novo review
from the Board. In a Consideration to Hear on December 21, 2022, the Board agreed to hear the
appeal de novo in a Public Hearing.
II. PUBLIC COMMENT
• Central Oregon LandWatch contacted the Planning Division on January 28, 2022 with
concerns of the proposal meeting the applicable criteria. As noted above, Central Oregon
LandWatch filed a timely appeal (file no. 247-22-000757-A) on September 19, 2022 to the
staff decision. The Notice of Appeal from Central Oregon LandWatch includes six (6) main
points of objection.
• Neighbor, Matt Cohen contacted the Planning Division on February 14, 2022 with concerns
about the how access points on Highway 20 can accommodate increased traffic volumes.
III. HEARINGS OFFICER DECISION
The Deschutes County Hearings Officer rendered a final decision denying the Applicant's request
for a Conditional Use Permit for the Meadery on the grounds that:
• The applicant has not satisfied the standard for a Commercial Activity in Conjunction with
Farm Use demonstrating that the Meadery use will be incidental and subordinate to the farm
use on the property. These standards are outlined in DCC 18.16.030(E) with the incorporation
of relevant case law Friends of Yamhill County v. Yamhill County, 255 Or App 636, 298 P3d 586
(2013)1.
• The applicant did not adequately address impacts to farm uses in the area pursuant to
Deschutes County Code (DCC) 18.16.040(A)(1) and (2).2 The corresponding Oregon Revised
Statute (ORS) is ORS 215.296(1), which is also known as the "Farm Impacts Test".
1 The Oregon Court of Appeals has developed a test for evaluating commercial activities in conjunction with farm use.
Friends of Yamhill County v. Yamhill County, 255 Or App 636, 298 P3d 586 (2013). It requires four findings:
1. The use relates to a farm use occurring on the subject property; and
2. Any commercial activity beyond processing and selling farm products must be incidental and subordinate to
the farm use (frequency and intensity when compared to the farm use on site, spatially, operating hours); and
3. The use enhances the quality of the agricultural enterprise; and
4. The use promotes the policy of preserving farm land for farm use
2 1. Will not force a significant change in accepted farm or forest practices as defined in ORS 215.203(2)(c) on surrounding
lands devoted to farm or forest uses; and 2. Will not significantly increase the cost of accepted farm or forest practices on
surrounding lands devoted to farm or forest use; [...1
247-22-000024-CU, 22-025-SP, 22-757-A, 22-914-A Page 2 of 3
IV. APPEAL FROM APPLICANT (247-22-000914-A)
The Applicant (John Herman) submitted a timely appeal of the Hearings Officer's decision on
November 29, 2022. The Applicant requested the Board conduct a Public Hearing to review the
following issues:
• Whether the Hearings Officer erred in finding the Applicant did not demonstrate that the
Meadery use will be incidental and subordinate to the farm use on the property and fulfill
the requirements of DCC 18.16.030(E).
• Whether the Hearings Officer erred in finding that the Applicant did not fully satisfy the
requirements of DCC 18.16.040 (A) (1) and (2), being the Farm Impacts Test.
• Whether the applicant and subject property is currently engaged in farm activities with the
intent to make a profit in money.
V. RECORD
The record for file nos. 247-22-000024-CU, 247-22-000025-SP (appeal file nos. 247-22-000757-A and
247-22-000914-A) is as presented at the following Deschutes County Community Development
Department website:
https://www.deschutes.org/cd/page/247-22-000024-cu-and-247-22-000025-sp-conditional-use-
and=site-plan-review-meadery
VI. NEXT STEPS
Based on the feedback received from the Board at the Work Session, Staff will prepare for the
upcoming Public Hearing.
ATTACHMENT(S):
Attachment A - 2023-01-23 BOCC Location Map 22-024-CU, 22-025-SP, 22-757-A, 22-914-A
247-22-000024-CU, 22-025-SP, 22-757-A, 22-914-A Page 3 of 3
File: 247-22-000024-CU, 025-513, 22-757-A, 22-914-A
68540 Highway 20
CAN TER C''SS� q
AV
E CASCAGEEC
E TIMBER PINE DR •
IZCi
ri
RIATA CT RIATA R
N
A
0 625 1,250 2,500
ft
1 inch= 1,505feet
0
Sources: Esri, USGS, NOAA
Cate: 12/8/2022
BOARD OF
COMMISSIONERS
AGENDA REQUEST & STAFF REPORT
MEETING DATE: January 23, 2023
SUBJECT: Deschutes County Outdoor Lighting Ordinance
RECOMMENDED MOTION:
Staff seeks direction from the Board on the next steps for revisiting the County's Outdoor
Lighting Control Ordinance. Options that are available include:
1. Initiating amendments to Deschutes County Code (DCC) Chapter 15.10, Outdoor
Lighting Control
2. Disseminating education materials (downward shielding focus)
3. Reconvening a panel to discuss amending DCC Chapter 15.10
4. Other
BACKGROUND AND POLICY IMPLICATIONS:
Since November 2021, the Board has expressed support for revisiting DCC Chapter 15.10.
In January 2022, the Deschutes County Planning Commission reviewed outdoor lighting -
related information and directed staff to assemble an 8-person panel reflecting varying
perspectives on dark skies and outdoor lighting. A panel was convened in February 2022
and the Planning Commission made a motion to the Board to: 1) Update DCC Chapter
15.10; and 2) Explore an educational campaign related to dark skies best practices. In April
2022, the Board directed staff to pursue dark skies best practices and policies as part of the
Deschutes County 2040 Comprehensive Plan Update process. In October 2022, the Board
expressed support for revisiting DCC Chapter 15.10 as a standalone work item,
emphasizing educational outreach efforts rather than code enforcement responses.
BUDGET IMPACTS:
None
ATTENDANCE:
Tarik Rawlings, Associate Planner
COMMUNITY DEVELOPMENT
MEMORANDUM
TO: Deschutes County Board of Commissioners
FROM: Tarik Rawlings, Associate Planner
Will Groves, Planning Manager
DATE: January 23, 2023
SUBJECT: Deschutes County Outdoor Lighting Ordinance / Direction
I. DIRECTION
Staff is seeking direction from the Board of County Commissioners (Board) on the next steps for revisiting
the County's Outdoor Lighting Control Ordinance. Options that are available include:
1. Initiating amendments to Deschutes County Code (DCC) Chapter 15.10, Outdoor Lighting Control
2. Disseminating education materials (downward shielding focus)
3. Reconvening a panel to discuss amending DCC Chapter 15.10
4. Other
II. COORDINATION EFFORTS TO DATE
Since November 2021, both the Board and Planning Commission have expressed support for revisiting
DCC Chapter 15.10 (Attachment 1)1. In January 2022, the Planning Commission reviewed information
related to this section of code and directed staff to assemble an 8-person panel reflecting varying
perspectives related to dark skies and outdoor lighting. One month later, a panel was convened and
discussed the importance of dark sky best practices and the increases of light pollution in the region from
approximately 2012-2020 (Attachment2)2. Later in February, the Planning Commission made a motion
to the Board to:
1. Update DCC Chapter 15.10; and
2. Explore an educational campaign related to dark skies best practices.
In April, the Board directed staff to pursue dark skies best practices and potential goals and policies as
part of the Deschutes County 2040 Comprehensive Plan Update process. In October, during a CDD FY
2022-23 Planning Division Work Plan Update, the Board expressed support for revisiting DCC Chapter
1 The Community Development Department (CDD) FY 2021-2022 and 2022-2023 Work Plans identify updating the Deschutes
County Outdoor Lighting Control Ordinance.
2 https://www.deschutes.org/bc-pc/page/planning-commission-9
15.10 as a standalone work item, emphasizing educational outreach efforts rather than code
enforcement responses.
III. CHAPTER 15.10, OUTDOOR LIGHTING CONTROL
DCC Chapter 15.10 was adopted in 1994 and continues to receive recognition today especially as
advocates build support behind dark skies best practices.3 The code requires:
• All private and commercial outdoor lighting fixtures installed after August 10, 1994 or replacing a
fixture installed before that date 120 or brighter watt incandescent bulb (1,800 lumens) located in
the unincorporated areas must be shielded by design or modification that directs light downward,
and must limit direct line -of -sight of the fixture's lamp to the property on which the fixture is
installed.
It offers examples of compliant shielding and fixture designs and specifies that shielding apply to all
permanent fixtures. DCC Chapter 15.10 also provides exemptions for:
• Airport and aircraft operations
• Correctional Institutions
• Holiday lighting not to exceed 45 days
• Temporary lighting for carnivals and fairs
• Public safety at historical sights
• Motion -sensitive lights which shine for
IV. LIMITATIONS OF AMENDING DCC CHAPTER 15.10
Building Safety Capacity
not longer than 20 minutes.
• Top -mounted lighting of US flags
• Internally lit advertising signs
• Television or film productions
• Customary agricultural practices
• Construction for an allowed use
The Building Safety Division administers and implements state building codes. Plans examiners and
building inspectors do not have the capacity to review or inspect outdoor lighting fixtures through a
separate application for lighting review. Their priorities focus on structural, mechanical, plumbing and
electrical requirements and corresponding permits. Currently, every building permit reviewed by the
Building Safety Division Plan is stamped with a notation that exterior lighting must comply with Deschutes
County's lighting regulations. At final inspection, however, not everything noted or stamped on a building
plan is inspected. Nonetheless, if the expectations are to create such review through the Building Safety
Division, this level of review will require hiring additional plans examiners and building inspectors, raising
fees, likely delaying the issuance of building permits and the final inspection process. These actions could
lead to unintended consequences related to increasing housing costs, among others.
Code Compliance Capacity
The Board has established the following priorities for code violations:
3 Ordinance 94-024. https://s3-us-west-2.amazonaws.com/municipalcodeonline.com-
new/deschutescounty/ordinances/documents/1620317553 1994-34738-Ordinance%20No.%2094-
024%20Recorded%209 1 1994.pdf
-2-
1. Violations that present an imminent threat to public life, health and safety;
2. Violations which impact rivers, streams, floodplains, and wetlands;
3. Solid waste, onsite wastewater, and building code violations consisting of non -permitted
construction or failure to obtain permits; and
4. Land use violations.4
As detailed above, outdoor lighting -related code enforcement violations are not a top priority. Currently,
outdoor lighting -related complaints constitute approximately 2% of the total received annually. Code
compliance specialists typically send educational materials to violators to encourage them to change
and/or shield their lighting fixtures. Similar to Building Safety, if expectations are to establish a robust
compliance program for outdoor lighting violators, CDD will need to reprioritize complaints and/or look
to additional resources to hire more Code Compliance staff.
V. EDUCATIONAL MATERIALS AND INFORMATION
The Board previously expressed interest in pursuing an educational campaign around dark skies best
practices. Based on this direction, staff reviewed a series of dark skies educational campaign materials
produced by the International Dark -Sky Association (IDA). These materials are currently available through
the IDA website and emphasize the importance of mitigating light pollution and promoting compliant
fixtures among other related topics.'
In July 2022, CDD began to include IDA educational materials and information in the automated lobby
displays (Attachment 3). These displays are designed to provide customers and other members of the
public with helpful information. In addition to the informational displays, staff has engaged
representatives from Travel Oregon and their regional office, Visit Central Oregon. As of January of 2023,
staff notes that IDA has expressed an interest in producing educational brochures outlining compliant
fixture design, light trespass prohibitions, and dark skies benefits to residents and neighbors through a
Future Fund grant application with Visit Central Oregon.
Staff continues to explore additional methods with which to distribute dark skies information as an
educational campaign. One such method would potentially involve informational releases through the
County's website and social media platforms, ideally managed by the County's Digital Communications
Coordinator. These releases could coincide with IDA's International Dark Sky Week, a promotional event
held each year around April -May to encourage dark skies best practices.6
VI. RECONVENING OUTDOOR LIGHTING PANEL
Another option for obtaining community feedback related to DCC Chapter 15.10 is for the Board to
reconvene a Dark Skies Panel to gauge community concerns, feedback, and recommendations for
amending DCC Chapter 15.10. Panelists could include representatives from partner agencies, CDD
4 https://www.deschutes.org/sites/default/files/fileattachments/community development/page/11842/code compliance policy and procedures manual.pdf.
Page 5.
5 https://www.darksky.org/our-work/grassroots-advocacy/resources/public-outreach-materials/
6 https://idsw.darksky.org/
-3-
divisions, dark skies experts from nonprofit or similar groups, as well as members of the agricultural
community and construction industry. A tentative list of suggested panelists is included below.
1. International Dark Sky Association (IDA)
2. Astronomer
3. Wildlife Expert (ODFW / USFWS / Other)
4. Central Oregon Builders Association (COBA) representative
5. CDD Code Compliance
6. Farmer / Rancher
7. Construction Industry representative
8. COAR - local realtor representative
CDD could facilitate a panel discussion for approximately 3-5 meetings spanning a 2-4 month period. The
following is a series of questions that could be addressed by the panelists:
1. Have you personally experienced light pollution/light trespass in a way that affected the
residential use of your property?
2. What specific language changes would you recommend to DCC Chapter 15.10?
3. What exemptions, if any, should DCC Chapter 15.10 contain?
4. How do you envision the resolution process for bringing non -compliant lighting fixtures back into
compliance?
Attachments
1. Benefits of Dark Skies Ordinances
2. Public Input
3. Best Management Practices
-4-
Attachment 1
Benefits of Dark Skies Ordinances
Many local governments in the United States have enacted dark sky ordinances. Support for dark sky
legislation has been expressed by policymakers, designers, public safety professionals, wildlife biologists,
and land use planning entities across the country. The IDA currently lists over 50 US jurisdictions that
have been designated as Dark Sky communities, parks, or reserves as of 2020.7 Most dark skies -related
principles require that outdoor lighting be directed towards the ground in an effort to reduce lighting
pollution and avoid light trespassing onto surrounding properties. Light pollution can have detrimental
effects on astronomical observations, tourism, enjoyment of the night sky, and public safety. Light
pollution can also be disrupting to wildlife habitat and natural circadian cycles common to both human
and wildlife populations. s
Central Oregon is characterized by some of the most notable dark skies within the contiguous 48 states
and is commonly referred to as the "Oregon Outback" by dark sky proponents and Astro-tourists. These
unique dark sky resources are located primarily within Deschutes, Klamath, Lake, Harney, and Malheur
Counties9. Below is an example of how Central Oregon's night sky quality (and specifically Deschutes
County) is viewed as a valuable resource to stargazers and other visitors to the region:
Several elements combine to make Central Oregon attractive for stargazers. East of the Cascade
Mountains the lack of any large metropolitan cities makes for a darker night sky. Even with
nearby Bend, Oregon's rapid growth, outdoor lighting standards are helping to keep light
pollution and associated sky glow minimized. Deschutes County adopted an outdoor lighting
ordinance which limits the types of lighting that can be used in order to help keep the rural skies
sparkling with stars and the Milky Way. Locals know that they're lucky to live in an area with
community support that will help to keep these dark night skies unspoiled. Even from their own
backyards they are able to view thousands of stars. 10
7 https://www.darksky.org/our-work/conservation/idsp/communities/
8 DesignLights Consortium Whitepaper Non -white Light Sources for Nighttime Environments. May 2022
https://www.designlights.org/resources/reports/whitepaper-non-white-light-sources-for-outdoor-environments/
9 https://www.southernoregon.org/industry/oregon-outback-dark-sky-network/#
10 https://www.darkskydefenders.org/blog/sunriver-designated-first-international-dark-sky-place-in-oregon.
Attachment 2
Public Input
Throughout 2022, County staff received public comments related to dark skies and outdoor lighting.
These comments can be generally categorized into concerns related to residential use, wildlife,
recreational activities, and local industry related to dark skies.
Residential Use
Most public comments focused on the importance of prohibiting Tight trespass onto neighboring
residential properties and mitigating such trespass through corrective shielding being added to
potentially non -compliant light fixtures. Some comments suggest that the exemptions for motion -sensor
lights on a timer are too broad and allow for unshielded lighting to persist for prolonged periods of time.
Many of the comments emphasized sleep interruptions, and disruption of residential uses as some of
the impacts from light trespass and timed motion light exemptions. The public comments related to
residential use typically focused on a single property or small group of properties.
Wildlife
Public comments related to wildlife focused primarily on impacts to bird species, and large-scale effects
on other migratory wildlife species. Wildlife -related comments emphasized the importance of
implementing dark skies best practices to better preserve wildlife populations and their established
feeding areas and migration patterns. Wildlife -related comments tended to focus on county -wide
regional scale in terms of wildlife impacts and migration corridors.
Recreational Activities
Several public comments focused on the importance of preserving dark skies for the purpose of
promoting recreational activities related to the night sky such as astronomy, photography, wildlife
viewing, and amateur stargazing. These comments promote dark skies best practices as economic
development opportunities capable of promoting the tourism economy within Deschutes County and
the Central Oregon region. Tourism activities related to the night sky are often called "Astro-Tourism".
Local Industry
The County has also heard from several property owners who are currently engaged in large-scale
agricultural uses and hobby farms. These commenters expressed concern with their ability to use
outdoor lighting for agricultural operations (i.e. night harvests, animal births, pest control, etc.) and
recommended that any outdoor lighting Ordinance allow an exemption for these types of agricultural
activities.
Similarly, the County has heard from representatives of the local building and construction industries.
These representatives expressed concern with the potential increase in construction costs that may
result from design review processes, lighting inspections, and the cost of enhanced fixture designs.
February 2022 Panel Discussion
In addition to the public comments outlined above, the Planning Commission convened a panel of
outdoor lighting -related community members and experts on February 10, 2022 to gather feedback
related to dark skies best practices and DCC Chapter 15.10. Participants emphasized the importance of
dark skies best practices to:
• Preserve circadian rhythms and natural processes for both humans and wildlife
• Increase public safety
• Enhance experiences and outdoor recreational activities related to dark skies including astronomy
and other astro-tourism activities.
Several panelists recommended incorporating IDA's "Five Principles for Responsible Outdoor Lighting"
into any revisions to DCC Chapter 15.10 and establishing a proactive code enforcement process. The
panel also unanimously recommended that any revision also include a description of LED lighting as a
potential source of Tight pollution.
-7-
Attachment 3
Best Management Practices
IDA outlines in Figure 1, below, the following mitigation measures as being the most responsive and
effective against the negative impacts of light pollution11:
Figure 1 - Outdoor Lighting Mitigation Measures
LIGHT TO PROTECT THE NIGHT
Five Principles for Responsible Outdoor Lighting
USEFUL
LOW LIGHT
LEVELS
COLOR
ALL LIGHT SHOULD HAVE A CLEAR PURPOSE
Before installing or replacing a light, determine if light is needed. Consider how the
use of light will impact the area, including wildlife and the environment. Consider
using reflective paints or self -luminous markers for signs, curbs, and steps to reduce
the need for permanently installed outdoor lighting.
LIGHT SHOULD BE NO BRIGHTER THAN NECESSARY
Use the lowest light level required. Be mindful of surface conditions as some
surfaces may reflect more light into the night sky than intended.
USE WARMER COLOR LIGHTS WHERE POSSIBLE
Limit the amount of shorter wavelength (blue -violet) light to the least amount
needed.
Currently, Deschutes County does not require an application for outdoor lighting review nor any
requirement for applicants to submit separate outdoor lighting plans in association with development
proposals and application materials.
Examples from Other Jurisdictions
There are several jurisdictions within Oregon, and more throughout the country, that currently support
dark sky programs. Table 1, below, provides a summary. In addition to design -specific shielding
requirements and brightness limitations, most outdoor lighting utilize outreach to promote dark sky -
supportive outdoor lighting fixtures, tips for working independently with neighbors to resolve outdoor
lighting issues, and a summary of dark sky benefits as related to local resources.
11 https://www.darksky.org/wp-content/uploads/2022/07/5-Lighting-Principles-6x8.5-HQP-07-2022.pdf
Table 1 - Other Dark Sky Ordinances
Jurisdiction
Program Emphasis
Resources
Multnomah County
Downward Shielding/Separate
Application Review
Applies only to new and replacement
lighting fixtures or bulbs
Sisters
Downward Shielding
Educational materials include quick-
reference guide for acceptable
lighting fixtures
Troutdale
Downward Shielding/Separate
Application Review/Light Level
Ratings/Fixture Dimensions
Existing ordinance assigns shielding
requirements based on lamp type
and wattage
Redmond, WA
Separate Application Review/Light
Trespass ProhibitionNegetation
Standards/Motion Sensors, Timers,
Dimmers
Regulations generally focus on
prescribing specific design and
trespass standards based on
conflicting zoning districts and
surrounding uses
Bainbridge Island, WA
Downward Shielding/Light Trespass
Prohibition/No Illumination of Public
Water Bodies/Vegetation Standards
Existing ordinance includes
reference guide for acceptable
fixtures and light trespass
compliance related to topographic
variations, vegetation, and other
terrain characteristics
Black Diamond, WA
Downward Shielding/Separate
Application Review/Light Trespass
Prohibition/IESNA
Standards/Curfew/Light Level
RatingsNegetation Standards
Applies only to new and replacement
lighting fixtures or bulbs
Flagstaff, AZ
Downward Shielding/Wattage
Restrictions
World's first "Dark -Sky Community"
(2001). Educational information is
available through the local Flagstaff
Dark Skies Coalition non-profit group
in collaboration with the City
Malibu, CA
Downward Shielding/Light Trespass
Prohibition/Curfew/Motion Sensors,
Timers, Dimmers/Color
Temperature/Fixture Dimensions
Recently approved, the City Council
has directed staff to include a robust
educational campaign to emphasize
the importance of outdoor lighting
best practices and aid with
compliance.
Ketchum, ID
Downward Shielding/Light Trespass
Prohibition/Color Temperature/IESNA
Standards/Fixture Dimensions
Educational materials include quick -
reference guide for acceptable
lighting fixtures
-9-
0 BOARD OF
COMMISSIONERS
BOARD OF COUNTY COMMISSIONERS MEETING
1:00 PM, MONDAY, JANUARY 23, 2023
Barnes Sawyer Rooms - Deschutes Services Building - 1300 NW Wall St - Bend
(541) 388-6570 I www.deschutes.org
AGENDA
MEETING FORMAT: In accordance with Oregon state law, this meeting is open to the public and
can be accessed and attended in person or remotely, with the exception of any executive session.
Members of the public may view the meeting in real time via the public meeting portal at
www.deschutes.org/meetings. To view the meeting via Zoom, see below.
Citizen Input: The public may comment on any meeting topic that is not on the current agenda. To
provide citizen input, submit an email to citizeninput@deschutes.org or leave a voice message at
541-385-1734. Citizen input received by noon on Tuesday will be included in the meeting record for
topics that are not on the Wednesday agenda.
If in -person comment from the public is allowed at the meeting, public comment will also be allowed
via computer, phone or other virtual means.
Zoom Meeting Information: This meeting may be accessed via Zoom using a phone or computer.
• To join the meeting from a computer, copy and paste this link: bit.ly/3h3ogdD.
• To join by phone, call 253-215-8782 and enter webinar ID # 899 4635 9970 followed by the
passcode 013510.
• If joining by a browser, use the raise hand icon to indicate you would like to provide public
comment, if and when allowed. If using a phone, press *6 to indicate you would like to speak and
*9 to unmute yourself when you are called on.
Deschutes County encourages persons with disabilities to participate in all
programs and activities. This event/location is accessible to people with disabilities.
If you need accommodations to make participation possible, call (541) 388-6572 or
email brenda.fritsvold@deschutes.org.
CALL TO ORDER
PLEDGE OF ALLEGIANCE
CITIZEN INPUT: Citizen Input may be provided as comment on any topic that is not on the
agenda.
Note: In addition to the option of providing in -person comments at the meeting, citizen input comments
may be emailed to citizeninput@deschutes.org or you may leave a brief voicemail at 541.385.1734. To be
timely, citizen input must be received by noon on Tuesday in order to be included in the meeting record.
CONSENT AGENDA
ACTION ITEMS
1. 1:00 PM ARPA Grant Status Update: Neighborlmpact Childcare Expansion Program
2. 1:15 PM Economic Development Loan to Tiny Watts Solar
3. 1:30 PM Treasury and Finance Reports for December 2022
RECESS FROM 2:00 - 3:00
4. 3:00 PM Preparation for a Public Hearing: Commercial Activity in Conjunction with
Farm Use (Meadery on Highway 20 near Sisters)
5. 3:20 PM Deschutes County Outdoor Lighting Ordinance
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.
6. Executive Sessions under ORS 192.660 (2) (h) Litigation and ORS 192.660 (2) (e) Real
Property Negotiations
ADJOURN
January 23, 2023
BOARD OF COUNTY COMMISSIONERS MEETING Page 2 of 2