2020-231-Minutes for Meeting May 18,2020 Recorded 7/10/2020c-o
BCC OF
COMMISSIONERS
1300 NW Wall Street, Bend, Oregon
(541) 388-6570
10:00 AM
Recorded in Deschutes County
Nancy Blankenship, County Clerk CJ2020-231
Commissioners' Journal 07/10/2020 10:17:23 AM
2020-231
FOR RECORDING STAMP ONLY
��. `�•,az` � xs `�.� °s. {*', ,�3n � � Y i"w�. 5 � % 're i .'NHS 'er.� 4tr,.�
BARNES & SAWYER ROOMS
Virtual Meeting Platform
Present were Commissioners Patti Adair, Anthony DeBone, and Phil Henderson. Also present were Tom
Anderson, County Administrator; Erik Kropp, Deputy County Administrator (present via Zoom
conference call at 1 1:59 a.m,); David Doyle, County Counsel (present via Zoom conference call at 11:42
a.m.) Amy Heverly, Assistant County Counsel (present via Zoom conference call); and Sharon Keith,
BOCC Executive Assistant. No identified representatives of the media were in attendance. Attendance
was limited in response to Governor's orders.
CALL TO ORDER: Chair Adair called the meeting to order at 10:00 a.m.
PLEDGE OF ALLEGIANCE
ACTION ITEMS:
1. Continued Discussion of COVID-19 Relief Grant Program
County Administrator Anderson gave a brief report of the grant program.
Internal Auditor David Givans and Scott Aycock, Central Oregon
Intergovernmental Council (COIC) were present via conference call and
presented the proposed grant agreement which is available to provide
emergency grants to small businesses and non -profits.
BOCC MEETING MAY 18, 2020 PAGE 1 OF 5
The Board is supportive if there is a designated funding source from the
County. County Administrator Anderson suggested the general fund or
unallocated transient room tax could be the source for these emergency
funds. The Board supported unallocated transient room tax reserves to be
used as the funding source. The County has been requested to match
$100,000 with COIC. The Board made recommendations for language
changes to the request for proposals document.
DEBONE: Move approval of designating $100,000 from the
unallocated transient room tax as funding source for the
COVID-19 Emergency Business Assistance Match Fund
HENDERSON: Second
Discussion held on forming a review committee.
VOTE: DEBONE: Yes
HENDERSON: Yes
ADAIR: Chair votes yes. Motion Carried
CONVENE AS THE GOVERNING BODY OF DESCHUTES COUNTY 911 SERVICE
DISTRICT
2. 911 Capital Alternatives Discussion
911 Operations Director Sara Crosswhite presented the Trott Report that has
been received outlining an enhancement plan for long term radio system.
Critical Impact Solutions Consultant, Will Mullins presented the executive
summary and his recommendations to proceed.
County Administrator Anderson explained there is an available capital
budget that could be utilized to enhance radio coverage. This is an
anticipated expense beginning in fiscal year 2022. This report will be
presented at the 911 User Board meeting that is scheduled May 19.
RECONVENE AS THE GOVERNING BODY OF DESCHUTES COUNTY
BOCC MEETING MAY 18, 2020 PAGE 2 OF 5
3. Treasurer and Finance Report
Chief Financial Officer Greg Munn was present via conference call and
reported on Deschutes County treasury and investments. Countywide
department summaries were reviewed for fiscal year to April 30, 2020.
LUNCH RECESS: At the time of 12:07 p.m. the Board went into recess and
reconvened the meeting at 1:02 p.m.
OTHER ITEMS:
Commissioner Henderson commented on his concerns with the terms of the
agreement with Neighborlmpact for the Budget Inn shelter agreement for
homeless individuals with COVID-19. Commissioner Henderson noted his
concerns with language of the agreement. Deputy County Administrator
Erik Kropp reported on the cost of liability insurance to cover property
damage. County Counsel Doyle reported Neighborlmpact was reviewing the
most current draft; Doyle will route the contract to the Commissioners for
review additional review.
• Commissioner Henderson commented on the COVID19 Executive Leadership
Board meeting Friday afternoon. Commissioner Henderson asked the Board
if they would consider a letter to the Governor regarding the use of personal
protective equipment. Commissioner DeBone supports our legislative
process and does not support a letter at this time until further data is
compiled. Commissioner Adair supports a letter at this time to take a
proactive stand for funding. Commissioner Henderson will draft a letter.
• Commissioner Henderson commented on the Stillwater Crossing resolution
for property tax exemption. The City of Bend has approved the
development's requested tax deferral. The property is adjacent to Highway
97 on the south end of Bend. Commissioner DeBone would like information
on traffic and transportation analysis relative to the development.
BOCC MEETING MAY 18, 2020 PAGE 3 OF 5
COMMISSIONER UPDATES:
• Commissioner DeBone attended the Association of Oregon Counties finance
quarterly meeting on line last week. Leadership Bend had a Zoom meeting
last week. He has an annual meeting for East Cascades Works on June 5.
Commissioner DeBone is participating in the interview process for the OSU
Extension Forester position. Commissioner DeBone is participating in an air
quality monitoring program.
• Commissioner Adair commented on the phase 1 reopening and the amount
of citizens venturing out and encourages people to be mindful. judge in
Baker County declared the Governor's emergency public health orders
(including those regarding church attendance) as null and void due to
procedural errors. Commissioner Adair feels that churches should be open if
restaurants are open. Commissioner Henderson expressed the same
concern. Commissioner Adair spoke of a letter received from the Catholic
Diocese Bishop. Commissioner DeBone acknowledged that the Governor
now allows Phase 1 counties have gatherings of 25 people; Phase 2 will allow
even larger gatherings so our goal needs to be to proceed to Phase 2 as soon
as possible.
• Commissioner Adair is now the new chair of Central Oregon Area
Commission on Transportation. She had a meeting with Nick Lelack
regarding the Sisters Visioning plan. She met with Dr. Les Hudson and Nick
Lelack regarding Planning Commission membership. She attended the
Sisters EDCO meeting.
Commissioner Henderson attended the airport commission meeting. He
attended the Deschutes Collaborative Forest Project meeting last week and
expressed concern of the forest projects, policy, and funding. Commissioner
DeBone suggested a letter asking for the goals as the world is different since
the formation. Commissioner DeBone recommended a discussion at a BOCC
meeting to discuss the history and process of the projects.
Commissioner Adair attended the conference call with the St. Charles
Hospital Authority meeting.
BOCC MEETING MAY 18, 2020 PAGE 4 OF 5
EXECUTIVE SESSION:
At the time of 2:09 p.m. the Board went into Executive Session ORS 192.660 (2) (e)
Real Property Negotiations. The Board came out of Executive Session 2:23 p.m. to
direct staff to proceed as discussed.
At the time of 2:23 p.m. the Board went into Executive Session ORS 192.660 (2) (e)
Real Property Negotiations. The Board came out of Executive Session 2:48 p.m.
At the time of 2:51 p.m. the Board went into Executive Session ORS 192.660 (2) (d)
Labor Negotiations. The Board came out of Executive Session 3:56 p.m.
At the time of 4:00 p.m. the Board went into Executive Session ORS 192.660 (2) (i)
Employee Evaluation. The Board came out of Executive Session 5:05 p.m.
Being no further items to come before the Board, the meeting was adjourned at 5:05 p.m.
DATED this Days _ 2020 for the Deschutes County Board of
Commissioners.
TTI ADAIR, CHAIR
1 Atli • I U
BOCC MEETING MAY 18, 2020 PAGE 5 OF 5
Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 — www.deschutes.org
BOCC MEETING AGENDA
DESCHUTES COUNTY BOARD OF COMMISSIONERS
10:00 AM, MONDAY, MAY 18, 2020
Live Streamed Video - 1300 NW Wall Street - - Bend
This meeting is open to the public, usually streamed live online and video recorded. To watch it online, visit
www. deschutes. org/meetins.
Pursuant to ORS 192.640, this agenda includes a list of the main topics that are anticipated to be considered or
discussed. This notice does not limit the Board's ability to address other topics.
Item start times are estimated and subject to change without notice.
CALL TO ORDER
MEETING FORMAT
In response to the COVID-19 public health emergency, Oregon Governor Kate Brown issued Executive Order
20-16 directing government entities to utilize virtual meetings whenever possible and to take necessary
measures to facilitate public participation in these virtual meetings.
Beginning on May 4, 2020, meetings and hearings of the Deschutes County Board of Commissioners will be
conducted in a virtual format. Attendance/Participation options include:
Live Stream Video: Members of the public may still view the BOCC meetings/hearings in real time via the
Public Meeting Portal at www.deschutes.org/meetings.
Citizen Input: Citizen Input is invited in order to provide the public with an opportunity to comment on any
meeting topic that is not on the current agenda. Citizen Input is provided by submitting an email to:
citizen inputPdeschutes.org or by leaving a voice message at 541-385-1734. Citizen input received before
the start of the meeting will be included in the meeting record.
Zoom Meeting Information: Staff and citizens that are presenting agenda items to the Board for
consideration or who are planning to testify in a scheduled public hearing may participate via Zoom
meeting. The Zoom meeting id and password will be included in either the public hearing materials or
through a meeting invite once your agenda item has been included on the agenda. Upon entering the
Zoom meeting, you will automatically be placed on hold and in the waiting room. Once you are ready to
Board of Commissioners BOCC Meeting Agenda Monday, May 18, 2020 Page 1 of 3
present your agenda item, you will be unmuted and placed in the spotlight for your presentation. If you are
providing testimony during a hearing, you will be placed in the waiting room until the time of testimony,
staff will announce your name and unmute your connection to be invited for testimony. Detailed
instructions will be included in the public hearing materials and will be announced at the outset of the
public hearing.
PLEDGE OF ALLEGIANCE
ACTION ITEMS
10:00 AM Continued Discussion of COVID-19 Relief Grant Program -Tom
Anderson, County Administrator
CONVENE AS THE GOVERNING BODY OF DESCHUTES COUNTY 911 SERVICE
DISTRICT
2. 10:30 AM 911 Capital Alternatives Discussion - Sara Crosswhite, 9-1-1 Operations
Director
RECONVENE AS THE GOVERNING BODY OF DESCHUTES COUNTY
3. 11:00 AM Treasurer and Finance Report -Greg Munn, Chief Financial Officer
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.
COMMISSIONER UPDATES
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.
Board of Commissioners BOCC Meeting Agenda Monday, May 18, 2020 Page 2 of 3
Executive Sessions under ORS 192.660 (2) (e) Real Property, ORS 192.660 (2) (d) Labor
Negotiations, and ORS 192.660 (2) (i) Employee Evaluation
ADJOURN
Deschutes County encourages persons with disabilities to participate in all programs and
activities. This event/location is accessible to people with disabilities. If you need
accommodations to make participation possible, please call (541) 617-474Z
FUTURE MEETINGS:
Additional meeting dates available at www.deschutes.or /g meetingcalendor
Meeting dates and times are subject to change. If you have questions, please call (541) 388-6572.
Board of Commissioners BOCC Meeting Agenda Monday, May 18, 2020 Page 3 of 3
UT ES c�G
Y=
Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/
AGENDA REQUEST & STAFF REPORT
For Board of Commissioners BOCC Monday Meeting of May 18, 2020
DATE: May 15, 2020
FROM: Tom Anderson, Administrative Services, 541-388-6565
TITLE OF AGENDA ITEM:
Continued Discussion of COVID-19 Relief Grant Program
4'� t ��' � �.�[: y4 is�� ��'t2 t..i �.j .�r�tir ��� •�C E�tF 1 ea v't �... ..��{
Central Oregon Intergovernmental Council (COIC) Response to: �1; �r`�?� F>►
Business Oregon: State of Oregon COVID-19 Emergency Business Assistance
Matching Fund RFP
On behalf of community partners within Crook, Deschutes, and Jefferson counties, Oregon
May 18, 2020
1. Amount of Award Requested and Source of Local Funds
COIC is working with a group of partners across Central Oregon (Crook, Deschutes, and Jefferson
Counties and the Confederated Tribes of Warm Springs) to combine existing and new small business
grant funding to leverage additional state funds through this RFP. Eligible businesses within Crook,
Deschutes, and Jefferson counties and the Confederated Tribes of Warm Springs, excluding Bend, will be
eligible to apply. COIC requests [$] to be matched 1:1 with [$] in secured local funding for a Central
Oregon Small Business Assistance Grant Program. The sources of local match are as follows:
Source of local match
$ Amount of
Geography covered
Notes
local match
Deschutes County
[$ TBD]
La Pine, Redmond, Sisters,
The City of Bend is submitting a
and unincorporated areas
separate application for that
community.
City of Madras
$25,000
Inside Madras city limits
Jefferson County
$18,250
Jefferson County outside
This is the amount of previously -
Madras
awarded funding that is consistent
with this RFP.
Warm Springs Community
[$ TBD]
Businesses within the
Action Team
Confederated Tribes of
Warm Springs
Crook County
$10,000
All of Crook County
Unfortunately, the previous
program is fully allocated and there
is no way to gather the needed
information.
Subtotal Local Match:
$53,250 +
All of Crook, Deschutes
Deschutes Co.
and Jefferson counties
contribution +
with the exception of
WSCATl
Bend.
Requested Business OR
$53,250 +
All of Crook, Deschutes,
contribution
Deschutes Co.
and Jefferson counties
contribution +
with the exception of
WSCAT
Bend.
The match funds described in the table above are only those which conform to this nrr.
1 Note: COIC has already helped start up small business grant programs across Central Oregon, including $25,000
each in La Pine and Sisters, $25,000 for clientele of the Latino Community Association, and $35,000 for businesses
in Jefferson County outside the city of Madras. Prineville/Crook County and Madras/Madras Urban Renewal have
also established and administered larger grant programs in those communities--$300,000 in the Madras area
and—$200,000 in Prineville/Crook County. All of these efforts have established local task forces and COIC serves on
each of them. Unfortunately, much of that local funding has already been allocated and there is no way to ensure
that existing recipients will conform to the guidelines for this RFP, with the exception of the Jefferson County
program, $18,250 of which can be made to conform to this program, and the Warm Springs Community Action
Team, XX of which can be made to conform to this program.
COIC Response to State of Oregon COVID-19 Emergency Business Assistance Matching Fund RFP
2. Description of Small Business Support Program
Program Values
The program values mirror those in the RFP:
o Ensure that historically disadvantaged individuals that own businesses have access to these funds.
o Ensure these funds are supporting the small businesses unable to access or apply for federal funds.
o Ensure that these funds are reaching every corner of Oregon.
o Ensure that these funds are keeping businesses operational
Program Administration
COIC will serve as the overall project manager and fiscal administrator for this program. COIC has been
coordinating a regional team since late March focused on the development of small business grant and
loan programs. This work has led a wide and deep network of regional organizations that will participate
in this program. COIL will leverage existing relationships and task forces to develop the application,
conduct outreach, and score and select successful applications. For funds awarded in Deschutes County,
county staff will also serve on the existing task forces. In some cases COIC will provide lump sum
payments via existing MOUs (with the La Pine, Madras, and Sisters Chambers of Commerce) for those
partners to cut individual checks to successful business applicants, and in others COIC will cut the checks
to businesses directly.
Fllndinn PrinritiOc
This program will make a one -time -only award to businesses that meet all of the following criteria:
• Businesses that have been adversely affected economically in one of the following two
categories:
o Those for -profit and non-profit (limited to 501(c)(3) corporations) businesses that were
prohibited from operation as directed by Executive Order 20-12.
o Those eligible for -profit businesses that can demonstrate a one month decline in
revenue greater than 50% in the month of March 2020 or April 2020 as compared
against sales in the month ofJanuary2020 or February 2020. Those non-profit
businesses (limited to 501tc1, 1 rornnrntlnnO that Pan r141mr%n Ctr=tn n rj v linn
greater than 50% across the months of March 2020 and April 2020 as compared against
`2v 7. "T C. Other communities have focused on for -profit
the Sarre period of time in
businesses to this point — what does the County want to do?
a Businesses with 20 or fewer employees.
® Businesses that have been unable to access federal CARES Act funds including:
o Small Business Administration's Paycheck Protection Program (PPP);
o Economic Injury Disaster Loan Emergency Advance program (EIDL); or
o Other federal programs to date for emergency pandemic funding.
Under this program, COIC and our partners will not make grants to:
Passive real estate holding companies and others holding passive investments.
2
COI: Response to State of Oregon COVID-19 Emergency Business Assistance Matching Fund RFP
• Non-profit entities that do not have federal 501(c)(3) status.
• Businesses that are delinquent on federal, state, or local taxes that were due before April 1,
2020.
• Businesses that do not comply with all federal, state, and local laws and regulations. Businesses
not headquartered and with principal operations in Oregon.
• Business not registered to do business in Oregon (SOS Business Registry verification) if such
registration is required.
Program Design
Successful businesses will be awarded an amount not greater than the following thresholds, based on
documentation provided by the applicants:
0-10 employees
o $2,500, or
0 60-day fixed expenses up to a maximum of $5,000
11-20 employees
o $5,000, or
0 60-day fixed expenses up to a maximum of $10,000
[NOTE: THESE ARE SOMEWHAT LOWER THAN THE THRESHOLDS IN THE RFP. ALSO, WE ARE PROPOSING
TO CAP AT 20 EMPLOYEES RATHER THAN 25. It will be very hard to hit the 50% sole proprietorship
number if we go above this size limit - plus the larger the awards, the less businesses we can support.]
COIC and our partners have established a firm limit of no less than 50% of the funds being deployed to
sole proprietor businesses. 100% of the funds will be deployed to businesses located in rural
communities as defined in the RFP.
As already noted, this application rests on the deployment of a variety of existing and new local funding.
ALL of the funding will conform to the above program guidelines.
3. Marketing Approach — Historically Disadvantaged Populations and Other Business Owners
Historically -disadvantaged Populations: Initial Marketing
Reflecting the values of this program, COIC will work with our network of existing partners to ensure
that historically disadvantaged populations have full and equitable access. Our partners have already
been working with the local business community to define needs and direct businesses to resources.
Three business days before the formal grant announcement is made, we will work with our current
partners to deliver a targeted email announcement and follow-up phone calls to businesses owned by
women and racial and ethnic minorities as well as sole proprietor business owners. The initial outreach
will include materials in both English and Spanish, and will include an offer of assistance in preparing
applications. (We would prefer to conduct this outreach for a longer period of time than 3 business
COIC Response to State of Oregon COVID-19 Emergency Business Assistance Matching Fund RFP
days, but the requirement that the program be fully deployed by May 30 seemingly makes that
impossible.) Our current partners include:
• La Pine, Sunriver, Sisters, Redmond, Prineville -Crook County, and Madras Area Chambers of
Commerce
• Latino Community Association
• Central Oregon Small Business Development Center
• All Central Oregon cities and counties
• Warm Springs Community Action Team
• Additional members of the La Pine, Sisters, Prineville/Crook County, Redmond, and
Madras/Jefferson County task forces.
• EDCO local offices in Sisters, Redmond, and Prineville.
We have noted that the FAQ for this RFP process states that Business Oregon will provide the names of
additional organizations through which COIL and our partners may communicate the small grant
program, and we look forward to working with these organizations.
4. Grant Announcement and Application Process
Upon execution of the phase 1 targeted outreach, a second more global announcement will be made via
Press Releases in each community as well as through the regular email lists of all project partners. This
announcement will be made at least 2 business clays rnri-r to opening applications for the grant
p ograr►l. All announcements wiii inciude the basic eligibility criteria as well as statements regarding
geographic eligibility and target businesses.
The application will be developed in Google Forms, in English and Spanish, and will include a minimum
of the following basic information:
• Name of company
• Employer Identification Number (EIN)
• Oregon Business Identification Number (BIN)
• Business Owner(s) Social Security Number
® Aridrprs of rmmnnny
• Industry/NAICS (if unknown, we can assign an industry code)
m Legal business structure
• # of employees as of February 29, 2020
Further, the application will request the following information:
• Amount requested
• A statement of how the business has been affected by the COVID-19 pandemic (general
statement)
2 Note: the LCA has expressed concerns about some of the information required to be provided by businesses for
this grant program. We will discuss this concern with LCA and see if there is a way to conduct outreach to
members of their clientele that are less concerned about privacy issues.
4
r-nir Dec-v��v.ri. +.. C+..+....F ....-., .- r
...�. 1.coNvilac tu notc vi v1rgull a %JV iD-19 Emergency Business Assistance Matching Fund RFP
A brief statement on whether or not the business is currently planning to reopen, what the
reopen plan is, and how the grant funds will be used to support reopening.
And the following self -certifications and other information:
• A self -certification that they have not received CARES Act PPP or SBA EIDL assistance
• A self -certification that they were either:
o Prohibited from operation as directed by Executive Order 20-12 (with a link to said
Order); or
o That they had a sales or revenue decrease of 50% or more in the month of March or
April as compared to sales revenues of January or February 2020, or as compared
against the same period in 2019. If a business uses this justification, we will either
request financial statements demonstrating such, or will work with Business Oregon to
determine the proper means of demonstrating this impact.
Self -certification they are not subject to any of the ineligibility criteria.
Self -certification that the business and its operations are, and will, remain compliant with all
local, state and federal laws.
Necessary business, financial and ownership information necessary to determine and verify
eligibility.
Individual local task forces may elect to ask additional information.
5. Grant Review and Award Process
Grant applications will be reviewed and awarded by local teams, as per the table below. In all cases,
COIC staff will also serve on the teams. COIC will work with each team to devise a scoring matrix that a)
includes the guidelines of this program and b) any additional desired local review criteria.
Applications from Businesses in:
Will be reviewed by:
Notes
La Pine
La Pine Task Force + Deschutes
Already developed. COIC will
County representative
provide one check to the La Pine
Chamber of Commerce for
disbursement to successful La
Pine -area businesses
Sisters
Sisters Task Force + Deschutes
Already developed. COIC will
County representative
provide one check to the Sisters
Chamber of Commerce for
disbursement to successful
Sisters -area businesses
Redmond
Redmond Task Force +
Already developed. Check
Deschutes County representative
administration is TBD.
Unincorporated Deschutes
COIC staff+ Deschutes County
Task force is to be developed.
County
representative
COIC will cut individual checks to
successful applicants.
Crook County
Prineville/Crook County Task
Already developed. COIC will
Force
provide one check to the
Prineville Chamber of Commerce
for disbursement to successful
COIC Response to State of Oregon COVID-19 Emergency Business Assistance Matching Fund RFP
Prineville and Crook County
businesses.
Jefferson County, including
Madras/Jefferson County Task
Already developed. COIC will
Confederated Tribes of Warm
Springs
Force + Warm Springs
provide one check each to the
Community Action Team
[Viarirac Chamber of Commerce
representative
and the WS CAT (tribal
businesses) for disbursement to
successful business applicants.
Proposed Timeline
- Pre -award: reach out to all partners — secure interest and match amounts (DONE)
- Begin developing base application — under way
- Date of award (TBD by Business Oregon)
- Hold orientation conference call with all partners — award + 2 business days or less
- Finalize application form on Google Forms in English and Spanish — award + 3 business days
- Finalize scoring matrix for each local team.
- Begin targeted outreach to historically disadvantaged populations and sole proprietor
businesses — award + 3 business days for a period of 3 business days (award + 6 business days)
- Global announcement of program (award + 7 business days)
- Applications open — award + 9 business days or by May 30, whichever is sooner. If the Business
OR announcement is too late to meet this May 30 target, COIC will shrink the other periods to
nrhlol/o tho A,4/n/ 2n finr/vo4
- Applications close— application opening + 5 business days
- Applications scored by local teams — application closing + 3 business days
- Successful applicants announced; checks cut — application closing + 10 business days
- Outcomes/evaluation data gathering and evaluation — ongoing and final report by July 15, 2020,
6. Allocations:
As noted above, 100% of the funds used in this program will be provided to businesses in rural areas, as
rural communities are defined by this RFP. Further, we will ensure that a minimum of 50% of the funds
are provided t^, SOIe ,^,r/JP.rietor bUsiisesseS.
7. Admini$trativa Ta=M Overv:e:A -
• Scott Aycock, Janel Ruehl, Michelle Williams - COIC
• Note all the other local Task Force Members.
• Audit/oversight measures (?-
Scott Aycock, COIC Community and Economic Development Manager, will serve as the lead contact for
this proposal:
Scott Aycock, CED Manager
scotta@coic.ort;
6
Response to State of Oregon CO iD-19 Emergency Business Assistance Matching Fund RFP
541-390-4653 (cell)
334 NE Hawthorne Ave., Bend, OR 97701
8. Final Report to Business Oregon — by July 15, 2020 - Incomplete
• Contents (see RFP
7
COIC Response to State of Oregon COVID-19 Emergency Business Assistance Matching Fund RFP
Notes - COIC Grant group
Date: 5/12/20
Oregon is releasing an RFP for public entities (cities, counties, economic development
districts, council of governments) that have or will develop a community business
assistance program (grants) in response to the COVID-19 crisis and are able to meet the
parameters of this program. Initial phase is $2.5M and have total funds of $10M in grant
matching.
• Grant funds for profit / non-profit businesses
>50% decline in business
o Profit: Those eligible for -profit businesses that can demonstrate a one
month decline in revenue greater than 50% in the month of March 2020 or
April 2020 as compared against sales in the month of January 2020 or
February 2020.
o Non-profit businesses: (limited to 501(c)(3) corporations) that can
demonstrate a decline in revenue greater than 50% across the months of
March 2020 and April 2020 as compared against the same period of time in
2019.
<25 employees
Unable to access monies from CARES, PPP, and EIDL.
• Principal operations in Oregon
Grants no loans. Amounts
• 0-5 employees o $2,500, or
• 60-day fixed expenses up to a maximum of $5,000.
• 6-10 employees o $5,000, or
• 60-day fixed expenses up to a maximum of $10,000.
• 11-15 employees o $7,500, or
60-day fixed expenses up to a maximum of $15,000.
16-20 employees o $10,000, or
60-day fixed expenses up to a maximum of $20,000.
• 20-25 employees o $12,500, or
• 60-day fixed expenses up to a maximum of $25,000.
Proposals for this round of funding are due May 18, 2020 by 5:00 PM
business
ore • •
State of Oregon COVED-19
Emergency Business Assistance Matching Fund
Request for Proposals
ANNOUNCEMENT
The Oregon Legislature, in partnership with the Governor, allocated $5 million from the State
General Fund, which will be combined with $5 million redirected from existing programs at the
Oregon Business Development Department (Business Oregon), for the purpose of providing
financial assistance to small businesses adversely affected by economic conditions associated
with the COVID-19 pandemic that have not received federal emergency assistance under the
federal CARES Act or other federal program for emergency pandemic funding.
Many small businesses in Oregon face cash flow shortfalls due to the economic conditions arising
from efforts to reduce the number and severity of COVID-19 infections. Some businesses have been
closed by executive emergency orders, while others have voluntarily closed or reduced operations
to address health and economic concerns.
Many communities throughout Oregon are providing local assistance to small businesses, and this
announcement provides up to a 1:1 match to augment these community -level assistance programs.
To fill gaps not reached by other programs, these state funds are directed to adversely affected
businesses with 25 or fewer employees, and only those that have been unable to receive federal
CARES Act funding, including the Small Business Administration's Paycheck Protection Program,
Economic Injury Disaster Loan Emergency Advance program, or other federal programs for
emergency pandemic funding to date. Businesses may use the proceeds for any business related
operating expenses, particularly to support businesses that were closed as they move into the first
phase of statewide reopening.
This announcement is for the first of three rounds of funding tied to this program, this round
consists of $2,500,000, available up to a 1:1 match to funds in community programs to provide
emergency economic assistance to local small businesses. Awards will be made to public entities
(cities, counties, economic development districts, council of governments) that have or will develop
a community business assistance program in response to the COVID-19 crisis and are able to meet
the parameters of this program.
Program awards made to public entities will be structured as forgivable loans. Forgiveness will be
based upon a recipient's ability to meet the program values and priorities outlined below and in
contract. Public entities will be required to make sub -awards from this program to eligible
individual businesses as grants.
Awards for this round of funds will be based on a community program's ability to achieve the
parameters, values, and goals of the program. If you have such a program that meets the State's
program parameters, please submit a funding proposal.
Proposals for this round of funding are due Monday, May 18, 2020 by 5:00 PM.
Program Values
■ Ensure that historically disadvantaged individuals that own businesses have access to these
funds.
■ Ensure these funds are supporting the small businesses unable to access or apply for federal
funds.
• Ensure that these funds are reaching every corner of Oregon.
■ Ensure that these funds are keeping businesses operational.
Eligible Applicants
Public entities (cities, counties, economic development districts, council of governments) that have
or will develop a local business assistance loan or grant fund and are able to meet the parameters of
this program as described below. Priority will be given to those public entities that were not
allocated direct funding through the CARES Act.
Local Program Funding Priorities
Local assistance programs are expected to make one -time -only awards to businesses as follows:
■ Businesses that have been adversely affected economically in one of the following two
categories:
o Those for -profit and non-profit (limited to 501(c)(3) corporations) businesses that were
prohibited from operation as directed by Executive Order 20-12.
o Those eligible for -profit businesses that can demonstrate a one month decline in
revenue greater than 50% in the month of March 2020 or April 2020 as compared against
sales in the month of January 2020 or February 2020. Those non-profit businesses
(limited to 501(c)(3) corporations) that can demonstrate a decline in revenue greater
than 50% across the months of March 2020 and April 2020 as compared against the
same period of time in 2019.
■ Businesses with 25 or fewer employees.
■ Businesses that have been unable to access federal CARES Act funds including:
o Small Business Administration's Paycheck Protection Program (PPP);
o Economic Injury Disaster Loan Emergency Advance program (EIDL); or
o Other federal programs to date for emergency pandemic funding.
Ineligibility Factors
• Passive real estate holding companies and others holding passive investments.
■ Non-profit entities that do not have federal 501(c)(3) status.
■ Businesses that are delinquent on federal, state or local taxes that were due before April 1, 2020.
■ Businesses that do not comply with all federal, state and local laws and regulations. Businesses
not headquartered and with principal operations in Oregon.
■ Businesses not registered to do business in Oregon (Secretary of State Business Registry
verification) if such registration is required.
Program Design
Awards to eligible businesses will be made as a grant. The amount of the grant will be the greater of
two figures based on an applicant's ability and desire to submit support documentation: the first
based on the number of employees before the COVID-19 crisis (as of February 29, 2020); or the
second based on the documented amount of fixed operating expenses for the 60 day period of
January 1 through February 29, 2020:
■ 0-5 employees
o $2,500, or
0 60-day fixed expenses up to a maximum of $5,000.
■ 6-10 employees
o $5,000, or
0 60-day fixed expenses up to a maximum of $10,000.
■ 11-15 employees
o $7,500, or
0 60-day fixed expenses up to a maximum of $15,000.
■ 16-20 employees
o $10,000, or
0 60-day fixed expenses up to a maximum of $20,000.
■ 20-25 employees
o $12,500, or
0 60-day fixed expenses up to a maximum of $25,000.
Program Award Targets
The State will make awards to various local assistance programs designed to achieve geographical
delivery across the state, with a target of at least 60% of awards reaching those in rural areas
outside of the largest urban growth areas (see Award Process below). The State has set a target of
50% of these funds to be awarded to sole proprietors, where possible, by the local assistance
program. The State will encourage outreach to historically disadvantaged population groups. The
funds must be rapidly deployed to meet immediate business needs and applicants will be required
to fully deploy the proceeds within 45 days of receipt.
Business Applications and Support Documentation
■ Businesses must:
■ Self -certify they have not received CARES Act PPP or SBA EIDL assistance as of the date of
application.
■ Demonstrate:
o That they were prohibited from operation as directed by Executive Order 20-12; or
o That they had a sales or revenue decrease of 50% or more in the month of March or April
2020, as compared against the sales or revenues of January or February 2020, or as
compared against the same period in 2019.
■ Demonstrate they are headquartered and with principal operations in Oregon.
■ Self -certify they are not subject to any of the ineligibility criteria.
■ Self -certify that the business and its operations are, and will, remain compliant with all local,
state and federal laws.
■ Provide business, financial and ownership information necessary to determine and verify
eligibility.
Other program details and next steps
Local entities administering COVID-19 business assistance programs (loan or grant programs, new
or existing) may apply to receive an award under this announcement. If approved, the applicant
will enter into a contract with Business Oregon in short order. During the contract process,
Business Oregon will consult on the detailed operational steps proposed by the local assistance
programs, and the basic reporting needed by the State.
Program Access
It is intended that these state funds are equally accessible to all Oreqonians, so a robust marketinq
program that reaches out locally to businesses owned by members of historically disadvantaged
population groups (Asian, Black, Hispanic, Native American, and Women Owned Businesses) is a
requirement of this program. Only those applicants that can demonstrate such a marketing
program and fair access procedures will be considered for funding. Local community program
awardees will be required to:
■ Have program marketing materials available in languages that are representative of the local
population.
■ Develop a stepped marketing program that reaches out and markets to members of historically
disadvantaged population groups in advance of marketing to the general public.
■ Deploy the awarded funds to eligible businesses within 45 days of the receipt of funds.
■ Demonstrate, for loan forgiveness, that all agreed Program Access activities as described in the
application and agreed upon in contract have been fulfilled.
Application Process
Local assistance programs should submit a written Proposal that describes the following:
■ Amount of award requested to match new or existing local funds (state funds up to, but will not
exceed, local funds).
■ Description of your established or proposed small business support program responding to the
COVID-19 crisis.
o For matching funds being requested for a new program, describe how the program will
be operational no later than May 30, 2020, and how the local assistance program
eligibility requirements comply with the requirements in this State of Oregon COVID-19
Emergency Business Assistance announcement.
o For matching funds for an established program, describe when the program was formed
and how the local assistance program eligibility requirements comply with the
requirements of the State of Oregon COVID-19 Emergency Business Assistance.
o For either, describe amount and source(s) of capitalization, the eligible applicants, the
type(s) of awards made, award ranges, number of awards, amount deployed to date, and
the amount remaining to be deployed.
■ Describe marketing activities and outreach to encourage participation of businesses owned by
members of historically disadvantaged populations groups in the applicant's jurisdiction(s).
Describe any procedures to ensure equitable awards are made to those businesses owned by
members of historically disadvantaged populations groups. (See Program Access above.)
• Describe the plans to market the grant program, including partnerships and marketing
strategies with chambers, business associations, Small Business Development Centers, etc.
■ Description of your grant/loan announcement and application process.
■ Description of your grant/loan review and award process.
■ Estimate geographic distribution of awards (list all municipalities and/or counties served):
o The percent of allocation awarded to urban (cities with populations greater than 30,000)
businesses, and
o The percent of allocation awarded to rural (cities with populations of 30,000 or less, or
unincorporated areas) businesses.
■ Estimate the percent of allocation awarded to sole proprietors.
■ Briefly describe the background of the executive in charge of the program, and description of
any other key team members if desired, and description of any audit or oversight measures if
desired. Provide contact information for a designated lead contact.
There is no minimum or maximum page limit for Proposals or other format requirements, except
that the Proposal must be delivered electronically in a Microsoft Office compatible file type, less
than 20 megabytes.
Proposals for this round of funding are due May 18, 2020 by 5:00 PM.
Please deliver your Proposal by email to:
Melisa Drugge, Regional Development Manager
melisa.druage0oregon.gov
(503) 508-3147 for any questions
A GoToMeeting teleconference for questions and answers regarding this
announcement will be held Monday, May 11 from 3:00-4:30 PM.
From your computer, tablet or smartphone: httDs://alobal.gotomeeting.com/join/`441110725
From dialing in with your phone:: +l (872)2240-3412 Access Code: 441-110-725
New to GoToMeeting? Get the app now and be ready when your first meeting starts:
https:/J lg obal.gotomeeting.com/install/441110725
Award Process
Business Oregon will coordinate an expeditious review process and may contact any proposer for
further clarification or negotiation. Decisions will be made in the State's sole discretion,
endeavoring to meet the objectives and targets described above and below:
■ No less than 50% of the awards to be made to Sole Proprietors.
■ No less than 60% of awards to be deployed in rural communities with population fewer than
30,000 per the last decennial census (2010) data including all areas outside of the following
urban growth boundaries:
o Albany
• Bend
o Corvallis
Eugene/Springfield
o Grants Pass
o McMinnville
o Medford
o Portland Metro (City of Portland, Multnomah and Washington County and communities
in Clackamas County with populations of 30,000 or more)
o Salem/Keizer
To the extent possible, evenly balanced allocations to the following regions:
o Central Region
• Crook, Deschutes, Hood, Jefferson, Sherman and Wasco County
o Coastal Region
• Clatsop, Coos, Curry, Lincoln and Tillamook County, Lane and Douglas County
west of Coastal Range
o Eastern Oregon Region
• Baker, Gilliam, Grant, Harney, Malheur, Morrow, Umatilla, Union, Wallowa, and
Wheeler County
o Metro Region
• Multnomah, Clackamas, and Washington County
o Southern Oregon Region
• Jackson, Josephine, Klamath and Lake County and Douglas County east of
Coastal Range
o Valley Region
• Benton, Clackamas, Columbia, Linn, Marion, Polk and Yamhill County and Lane
County east of the Coastal Range
Grant fund deployment deadlines and reporting requirements
A final report is due the sooner of:
■ 30 days from when the capital is deployed by the local assistance program to eligible
businesses, or
■ July 15, 2020.
Any proceeds not deployed by June 30, 2020 are to be repaid to Business Oregon on or before July 1,
2020, unless waived in writing by the department.
In the final report, the local assistance program will be required to report program and recipient
information on a form prescribed by Business Oregon, including but not limited to:
■ Number of applications received
■ Number of awards made
o Awards as #, $ and % of allocation by voluntary reported demographic information
o Award as #, $, and % of allocation by region
o Award as #, $, and % of allocation by company size
o Award as #, $ and % of allocation to sole proprietors
■ Sub recipient data
o Name of company
o Employer Identification Number (EIN)
o Oregon Business Identification Number (BIN)
o Business Owner(s) Social Security Number
o Address of company
o Industry/NAICS
o Amount of award
o Legal business structure
o # of employees as of February 29, 2020
AGENDA REQUEST & STAFF REPORT
For Board of Commissioners BOCC Monday Meeting of May 18, 2020
DATE: May 14, 2020
FROM: Sara Crosswhite, 9-1-1 Operations, 541-322-6111
TITLE OF AGENDA ITEM:
911 Capital Alternatives Discussion
%C0 R ITI CALTM PACT
SOLUTIONS
Long-term Coverage
Enhancement Effort
�-� E S
May 01, 2020
CRITICAL(�IMPACT
Deschutes County 911
Long-term LMR Coverage Enhancement Plan
Table of Contents
1. Executive Summary
2. Coverage Evaluation Process
3. Enhancement Options
4. Recommended Priorities
APPENDIX: Trott Coverage Evaluation Report
I
CRITICAL )MPACT
1.0 Executive Summary
To establish a strategic long-term radio improvement initiative, DC911 conducted
an audit of DAQ (Delivered Audio Quality) and BER (Bit Error Rate) testing data, as
well as radio tickets captured over the past year. With that data, DC911 was able to
identify areas of strong portable in -building coverage and areas that need
enhancement. Through this evaluation, the need for potential enhancement options
were identified.
On November 25th 2019, DC911 entered into an agreement with Trott
Communications to conduct an evaluation of the coverage provided by the existing
DC911 sites in conjunction with a list of candidate sites. Trott evaluated 39 sites
within the Deschutes County Jurisdictional area for coverage enhancement
feasibility.
The following were the key goals of engaging Trott to evaluate the County coverage
options:
• Feasibility of simulcasting more population dense areas of the County
o Maximizing the simulcast area within the County improves the
spectrum efficiency of the system as well as improves roaming issues
between various subscriber manufacturers as was identified within the
audit of the previous year's user tickets.
• Identifying in -building coverage improvements within key population densities
o This focus was in the cities of Bend and Redmond
• Identifying improvement options for portable radios within the rural areas
o This includes NW County and South County
• Identifying complementary coverage to provide redundancy
o DC911 recognizes that a loss of stand-alone sites, not part of the
simulcast, could significantly impact operations.
The radio propagation analysis provided by Trott, outlines the coverage evaluation
methodology used as well as the baseline provided by the existing DC911 site
infrastructure and the delta enhancement generated by select site additions.
The Trott analysis is designed to be an additional data point for DC911 to utilize in
cultivating a coverage enhancement plan. It does not include the complementary
coverage provided through DC911's partnership with the State, nor does it account
for the availability or access to the sites evaluated. The analysis was focused on
DC911 sites only so that we would understand where our coverage baseline is
without reliance on any partnerships. It is understood that we will achieve
complementary coverage from the State sites which will produce actual coverage
greater than the percentages represented here.
CRITICAL (�)MPACT
The following sections of this report will walk through the methodology used for the
analysis as well as the coverage enhancement options and the recommended
priorities as identified by Critical Impact Solutions.
2.0 Coverage Evaluation Process
The Statement of Work (SoW) provided to Trott identified 3 primary goals for them to
work toward:
Increase reliable coverage to in -building portable radios within the City of
Bend.
Increase reliable coverage to in -building portable radios within the City of
Redmond.
Increase reliable coverage to outdoor portable radios within the entire
geographic area of Deschutes County.
To establish a baseline to design from, Trott took the data gathered through the BER
testing conducted in 2019 to tune their propagation model for the existing coverage
environment. With this information, Trott was able to produce a projected coverage
percentage across geographic boundaries within the County, as provided by the
existing DC911 sites only. This information is presented in Table 1.
Existing
Outbound Coverage Level
Bend 15Db In -Building
85.3%
Redmond 15Db In -Building
78.0%
Portable Radio Outdoors
24.5%
Mobile Radio
34.1 %
TABLE 1
After evaluating multiple simulcast site clusters, Trott identified an optimal Simulcast
Cell to maximize the bounded coverage across the County. This cluster is comprised of
13 sites, of which 5 are existing sites and the remaining 8 are potential candidates. The
information is captured in Table 2 below:
Awbrey Butte, Overturf Butte, St. Charles -Bend,
Hoodoo Mountain, Cline Butte, Mount Bachelor Pine
Marten, Henkle, Glacier Road, Bearwallow, Scale
House, Lookout Mountain, Pine Mountain West,
Hampton
Outbound Coverage Level
Bend 15Db In -Building
92.9%
Redmond 15Db In -Building
93.7%
CRITICAL(TMPACT
Portable Radio Outdoors 78.7%
Mobile Radio 89.0%
TABLE 2
Each site added into the Simulcast Cell was analyzed based on the increase of
coverage provided as well as the simulcast delay spread (SDS) that was created. The
SDS was minimized to areas of minimal population density. The increase in coverage
identified does not account for the impact of SDS in the percentages. Further design
use of directional antennas and timing offset will minimize SDS impact. The increase in
coverage over the existing sites was detailed in the Trott report and can be seen here in
Table 3.
Outdoor Portable Radio Coverage Increase
Lookout Mountain
+19.2%
Pine Mountain West
+19.2%
Hampton Butte
+14.4%
Bearwal low
+2.2%
Henkle
+4.2%
Scale House Microwave Cell Site
+0.3%
Glacier Road
+0.2%
TABLE 3
3.0 Enhancement Options
The Trott analysis laid out a recommended site cluster to maximize coverage
percentages. This is a data point to be added into the overall consideration for setting
an evolution plan for the agencies comprising DC911. Maximizing the user's
effectiveness is the intent and coverage percentages only play a small factor in that
effort. We must first take into consideration the level of effort associated with the
location of coverage increase as well as the amount of coverage increase. Note that 4
of the sites proposed in Table 3, above, only provide approximately 7% land mass
coverage over the County Boundary. We must also consider the complementary
coverage gained through our partnership with the State.
Evaluating the Candidate Sites proposed in the Trott analysis for site readiness or
accessibility, DC911 conducted a preliminary review. Table 4 shows the findings.
Candidate Site Readiness
Lookout Mountain
DC911 does not have any existing relationship
with the site and would need to conduct a full
site survey to determine feasibility.
Pine Mountain
Day Wireless owned site with good power,
HVAC, and Tower. Discussion with Day
Wireless will be required to identify feasibility
CRITICAL(MPACT
and cost for adding the P25 equipment to
DC911's existing lease.
Hampton Butte
BLM owned land with existing communications
site used by the power company. DC911 will
need to add a tower and shelter to this space,
assuming approved access lease.
Bearwallow
Day Wireless owned site with only solar power
and 110' Rohn 45 tower. The site would need
to be enhanced with commercial power to
support the P25 Phase 2 radio equipment.
Discussion with Day Wireless will be required
to identify feasibility and cost for access.
Henkle
Fire Lookout site with no existing
environmental systems. 60' Rohn 25 tower is
present. A site survey to determine feasibility
of environmental systems addition and status
of the tower will be required.
Scale House
American Tower owned site with a 100'
Microwave Cell Site
monopole tower. The site has commercial
power available. Discussion with ATC will be
required to determine feasibility and cost for
access.
Glacier Road
US Cellular owned site. DC911 will be
required to provide a shelter at the site as well
as a site inspection and engineering study.
Discussion with US Cellular will be required to
determine feasibility and cost for access.
USFS Redmond Site
USFS owned site with 99' tower and in -
building communications room. Discussion
with COIDC and USFS will be required to
determine feasibility and cost for access.
TABLE 4
The sites evaluated, range in ownership from partner owned sites to privately owned
sites, some with tower and shelter availability to some with full greenfield build
requirements. This makes estimating a cost difficult. An expectation of cost to add the
required equipment and licensing for a partner site with availability on existing
infrastructure will be around $450,000.00 unless existing equipment is able to be
reused. For a full greenfield build, the cost could be in excess of $750,000.00.
4.0 Recommended Priorities
CRITICALMPACT
In identifying the recommended priorities for the Radio System enhancements, we
must refer to the primary goals that DC911 wants to accomplish:
• Feasibility of simulcasting larger areas of the County
• Identifying in -building coverage improvements within key population densities
• Identifying improvement options for portable radios within the rural areas
• Identifying complementary coverage to provide redundancy
Considering these goals and weighing the operational benefits with the potential costs,
Critical Impact Solution provides the following recommendations with rough order of
magnitude pricing for each option:
Incorporate Cline Butte into the existing Bend Simulcast Cell. ($100,000.00)
• This will minimize site roaming with portable radios as user's transverse
between Bend and Redmond and areas toward Sisters where coverage
converges between the Bend Simulcast Cell and Cline Butte.
• This incorporation of a single simulcast cell will also create an increase of
constructive interference which will improve in -building penetration.
• This will also improve the spectral efficiency of the DC911 system.
2. Deploy a second site in Redmond. The USFS site at COIDC is a partner site with
existing infrastructure which will minimize the cost of addition. ($250,000.00)
• This will minimize the impact of a potential loss of Cline Butte.
• The secondary northern site being added into the simulcast cell will
provide increased in -building penetration for the City of Redmond.
• The addition of this site will add coverage within the Airport terminal which
is currently experiencing low reception.
3. Identify a multicast candidate site in NW County ($450,000.00)
• The Trott analysis provided simulcasting options for NW County. Because
of the SDS introduced in the area of converged signals on Hwy 20
between Sisters and Bend, the use of a multicast site is recommended.
• The spectral efficiency gained by simulcast the Redmond sites will allow
for frequency reuse in the NW County where coverage is required but
densification is not.
4. Deploy Simulcast sites in South County ($1,000,000.00)
• This will increase coverage in South County where La Pine is
experiencing population growth
• This will improve on -street coverage along cascade lakes HWY where
seasonal traffic drives an increase of usage.
As Deschutes County continues to expand the geographic footprint for additional
residents migrating in, the long-term plan will need to remain fluid to account for
changes in demand and focus. This plan should be used as a baseline to budget and
CRITICAL )MPACT
target improvements to maximize the effectiveness of the DC911 radio system and
offering to the DC911 partners.
0
04TROTT
COMMUNICATIONS GROUP
1303 West Walnut Hill Lane, Suite 300
Irving, TX 75038
Radio Propagation Analysis
Deschutes County, Oregon
March 20, 2020
Deschutes County, Oregon
Coverage Predictions Report
Table of Contents
1.0 Introduction.........................................................
2.0 Coverage Analysis Methodology ...................
3.0 Current System Coverage ................................
4.0 Coverage Analysis Results ..............................
5.0 Summary..............................................................
APPENDIX - Coverage Maps
n
........................................... 1
........................................... 1
........................................... 1
........................................... 3
........................................... 5
Deschutes County, Oregon
Coverage Predictions Report
Deschutes County, Oregon
Coverage Predictions Report
1.0 INTRODUCTION
March 20, 2020
Trott Communications Group, Inc. ("Trott") was retained by Deschutes County, Oregon
("County") to assess the County's current coverage performance of its 800 MHz P25 trunked
public safety radio communications system. The County currently employs a combination of six
communication sites; Hoodoo Mountain, Cline Butte, Awbrey Butte, St. Charles Hospital — Bend,
Overturf Butte, and Mt. Bachelor — Pine Marten. Three of these sites, Awbrey Butte, Overturf
Butte, and St. Charles Hospital — Bend, are simulcast on the same frequencies to provide composite
coverage to the City of Bend. The remaining three sites are multicast on differing frequencies to
provide coverage to the City of Redmond and the remaining areas within the County. Finally, Trott
was tasked to analyze the effects of simulcasting all sites within the County and implementing
additional communication sites to achieve 95% In -Building portable radio coverage within the
Cities of Bend and Redmond and to achieve 95% outdoor portable radio coverage county -wide.
2.0 COVERAGE ANALYSIS METHODOLOGY
The following is a summary of the coverage analysis methodology. The resulting coverage maps
are provided in the Appendix.
SignalProTM propagation software package from EDX Wireless, Inc. was used by Trott to perform
propagation studies and to generate the propagation (i.e. coverage) maps of the existing radio
system and various potential site configurations for a system upgrade. SignalProTM provides a
comprehensive suite of terrain -based propagation models and design tools. United States
Geological Survey (USGS) I arc -second terrain data was acquired for the area and utilized in the
modeling process to increase accuracy.
Equipment and configuration data for the existing sites was provided by the County. Relevant
modeling data for candidate site locations was also provided by the County.
Trott Communications Group, Inc. 1
Deschutes County, Oregon
Coverage Predictions Report March 20, 2020
To further improve the accuracy of the coverage model, the County had collected coverage data
from the existing City of Bend simulcast cell and from an additional non -County site. This actual
signal propagation data provided by the County was then used for model validation and parameter
calibration. Once calibrated and fine-tuned, the EDX propagation software was used to model the
performance of both the existing systems and various hypothetical system configurations for the
additional coverage options.
All coverage presented herein is based upon the outbound (base -to -mobile) signal path. Outbound
is typically the limiting path in the 800 MHz band due to available gain and signal-to-noise
performance of the receiver antenna systems. Therefore, it is assumed that the outbound and
inbound performance is generally balanced.
Performance thresholds displayed on the coverage maps represent reliable radio coverage and were
developed utilizing performance standards and methods published in TIA/EIA TSB-88. All
thresholds are based upon the recommended public safety performance of DAQ 3.4 audio quality
and 95% signal level reliability. All coverage maps include thresholds for mobile radios, outdoor
portable radios, and portable radios inside of high -density buildings. On each map, DAQ 3.4 and
95% signal level reliability coverage for in -building portable radios is represented by areas shaded
in yellow, outdoor portable radio coverage is represented by areas shaded in red and yellow, and
mobile radio coverage is represented by areas shaded in red, yellow, and blue. The indoor coverage
is modeled using a building attenuation margin of 15 dB to represent high -density buildings. This
margin is presented globally and does not identify where buildings actually exist. Locations with
light or medium density buildings, such as residential structures, will perform better than indicated.
Likewise, higher density buildings with greater than 15 dB attenuation may perform worse than
indicated. Site noise and interference vary considerably from site -to -site. For coverage mapping
purposes, typical site noise was assumed. As noted in §3, simulcast interference (i.e. SDS) was
also analyzed and provided with the coverage maps, see Appendix Exhibits 7-9.
Trott Communications Group, Inc. 2
Deschutes County, Oregon
Coverage Predictions Report
3.0 CURRENT SYSTEM COVERAGE
March 20, 2020
As noted in §1, the County currently employs a combination of six communication sites; Hoodoo
Mountain, Cline Butte, Awbrey Butte, St. Charles Hospital — Bend, Overturf Butte, and Mt.
Bachelor — Pine Marten. Three of these sites, Awbrey Butte, Overturf Butte, and St. Charles
Hospital — Bend, are simulcast on the same frequencies to provide composite coverage to the City
of Bend. The remaining three sites are multicast on differing frequencies to provide coverage to
the City of Redmond and the remaining areas within the County. Appendix Exhibits 1 - 3 show
the current coverage provided by these six sites. Exhibit 1 is a county -wide map, Exhibit 2 is a
zoomed -in map showing coverage within the City of Bend, and Exhibit 3 is a zoomed -in map
showing coverage to the Cities of Redmond and Sisters. The geographic percentage of the County
and City coverages are presented in Table 1.
Existing
Outbound Coverage Level
Bend 15dB In -Building
85.3%
Redmond 15dB In -Building
78.0%
Portable Radio Outdoors
24.5%
Mobile Radio
34.1 %
Table 1
As described in §1, the County has three primary coverage goals. These goals are to increase
reliable coverage to in -building portable radios within the geographic areas of the Cities of Bend
and Redmond and to increase reliable coverage to outdoor portable radios within the entire
geographic area of Deschutes County. This updated County system would also be fully simulcast.
Therefore, it is necessary to analyze the effects of Simulcast Delay Spread (SDS) interference. The
parameters for the existence of SDS are locations where two or more signals received at a point
with 60 microsecond delay or greater and signal strengths within 12dB of each other. If the best
server is 12dB or greater than any other site, the mobile (or portable) radio receiver will fully
capture that signal, and other signals (from other sites) will not degrade audio performance or
cause interfere.
Trott Communications Group, Inc. I
Deschutes County, Oregon
Coverage Predictions Report March 20, 2020
While SDS was observed in the various simulcast configurations, Trott believes that it can be
ignored due to its non -impact on the County's coverage goals. The predictions show SDS to mainly
occur in areas of mobile only coverage, where the signal received from a distant high elevation
site has significant delay. SDS was predicted to occur over 0.5% of the geographic area of the
County, 0.02% of the geographic area of the City of Bend, and 0% of the geographic area of the
City of Redmond. SDS cannot be eliminated but it can be moved by introducing transmission
timing alterations to the various sites to adjust SDS to an area of low concern. Since the coverage
goals of this study all involved portable radio coverage and the SDS only impacted mobile
coverage, the presence of SDS while not ideal is of minimal impact.
The County provided a list of candidate sites to be analyzed in this study along with available
antenna heights. The list of existing and candidate sites is shown in Table 2. For each candidate
site, Trott utilized a nominal 9 dB omnidirectional antenna with 3° of electrical downtilt. The
electrical downtilt was employed to help reduce signal from traveling outside of the intended
coverage area of a site and thus minimize the chances of SDS occurring. The transmitter output
was set at 100 Watts; 5 dB of filter / combiner losses was added, and cable lengths were set at the
antenna height plus 50 feet.
Radio Site Name
Tower Type
Latitude
Longitude
Awbrey Butte USFS Tower
Steel / 3 Leg
44-04-38.06 N
121-19-55.1 W
St. Charles Hosp Bend
Top of Penthouse - Parapet
Antenna.
44-04-04.56 N
121-16-09.6 W
Cline Butte
Steel Guyed
44-15-30 N
121-17-51 W
Mt. Bachelor Pine Marten
Parapet wall- Above Roofline
43-59-26.4 N
121-41-12 W
Hoodoo
Steel / 4 Leg
44-24-07 N
121-52-56 W
Overturf Butte
Wood Telephone Pole
44-03-13 N
121-20-31 W
911 Center
Self Supported Lattice
44-05-51.0 N
121-18-22.0 W
Backup 911 Center/Bend Fire E
Self Supported
44-04-03 N
121-14-33.5 W
Black Butte
Lookout Tower
44-23-59.6 N
121-38-05.7 W
Wampus Butte
Steel/ 4 Leg Self Supported
43-41-59.04 N
121-37-18.96 W
Sugar Pine Butte
Steel/ 4 Leg Self Supported
43-49-43.8 N
121-21-07.11 W
Antelope Butte East
Self Supported
43-48-42.0 N
120-52-27.6 W
Five Mile Butte Verizon Bldg
Steel / 4 Leg
44-21-04.26 N
121-41-28.68 W
Gray Butte
Steel / 3 Leg
44-25-00.66 N
121-06-04.02 W
Henkle
Rohn 25 non -guyed
44-20-08.0 N
121-29-09.0 W
Pine Mountain West
Steel / 3 Leg
43-47-28.63 N
120-56-52.12 W
Powell But
Steel Tower - Loaded.
44-11-51.3 N
120-58-40.7 W
Hampton Butte
Power Pole
43-46-25.5 N
120-16-54.1 W
Trott Communications Group, Inc. 2
Deschutes County, Oregon
Coverage Predictions Report
March 20, 2020
Five Mile Butte Bldg 2
Guyed Tower
44-21-04.26 N
121-41-28.68 W
Mt. Bachelor NW Express
Pole attached to roof of Ski
Lift Shack.
43-59-03.7 N
1214141.4 W
Long Butte
Steel Tower
44-10-25.95 N
121-16-36.77 W
Awbrey Butte SO Tower
Steel / 3 Leg
44-04-38.70 N
121-19-55.02 W
Bearwallow
Rohn 25 Guyed
44-04-42.7 N
121-33-07.2 W
Central Oregon Training and
Education Facility (COTEF)
Steel
44-01-27 N
121-07-43 W
DCSO Jail
None
44-06-02.15 N
121-18-21.3 W
DCSO Lapine Substation
Steel / 3 Leg
43-39-54.58 N
121-30-24.48 W
DCS Old OSP Radio Tower
3 Legged Steel Tower.
44-05-57.4 N
121-18-21.9 W
Finley Butte
??
44-39-00 N
121-25-46 W
Jackpine Ridge
Steel Guyed
44-02-48.75 N
121-31-54.39 W
Lookout Mountain
Guyed Rohn Tower
43-48-07.8 N
121-41-46.7 W
River Woods Water Tank
Water Tank
43-58-44 N
121-21-53 W
Scale House Microwave Cell Site
(2) Steel Monopole with Cell
Equip.
43-58-53 N
121-20-05 W
Skyliners Water Tower Site
Concrete / Steel Water Tower
44-03-11 N
121-23-37 W
Springriver Butte
Steel / 3 Leg
43-52-25.92 N
121-30-16.80 W
St. Charles Hosp Redmond
Top of Penthouse - Parapet
Antenna.
44-17-20 N
121-10-10.35 W
Deschutes County Fair & Expo
Wooden Building
44-14-06.78 N
121-11-18.93 W
Cinder Butte
Wood Telephone Pole
44-19.1-90 N
121-10.26-71 W
Glacier Road
Steel tower - Self Supported
44-16-06.77 N
121-10-02.12 W
Cinder Butte Site 2
Steel Mono -pole
44-19-19 N
1 121-10-24 W
TABLE 2
4.0 COVERAGE ANALYSIS RESULTS
The most improved coverage to the southern areas of the County required the addition of Lookout
Mountain in the southwest, the addition of either Antelope Butte East or Pine Mountain West in
the south-central area, and the addition of Hampton Butte in the southeast. This combination of
three additional sites provides the best coverage to the southern parts of the County. Antelope
Butte East provides better coverage than Pine Mountain West to the northeast of the two sites
along Highway 20 and to the community of Brothers while Pine Mountain West to the southwest
of both sites. See Appendix Exhibit 4.
The most improved in -building portable radio coverage to the City of Bend required the additions
of Bearwallow and Scale House Microwave Cell Site to the existing trio of Awbrey Butte, Overturf
Butte, and St. Charles Hospital - Bend. If the County is limited to adding only one site to improve
Trott Communications Group, Inc. 3
Deschutes County, Oregon
Coverage Predictions Report March 20, 2020
in -building portable radio coverage to the City of Bend, then the addition of Bearwallow or
Jackpine Ridge best improve Bend's coverage while also increasing overall outdoor portable radio
coverage County -wide. See Appendix Exhibit 5.
The most improved in -building portable radio coverage to the City of Redmond required an
additional site added immediately within the Redmond area as very little signal from any of the
sites exterior to the City improved coverage within the City of Redmond. The Glacier Road site
provided the most improvement and was selected for this exercise though St. Charles Hospital —
Redmond or Deschutes County Fairgrounds would also work in this instance. See Appendix
Exhibit 6.
The most improved coverage to the northwest areas of the County and the City of Sisters was
provided by the Henkle site. The Black Butte site provided more geographic coverage to the
County but a majority of that coverage is to the west and southwest of the Black Butte site which
is low population density and towards Hoodoo Mountain. See Appendix Exhibit 6.
Appendix Exhibits 4 - 6 show the theoretically improved coverage provided by the candidate sites
discussed above. Exhibit 4 is a county -wide map, Exhibit 5 is a zoomed -in map showing coverage
within the City of Bend, and Exhibit 6 is a zoomed -in map showing coverage to the Cities of
Redmond and Sisters. The geographic percentage of the County and City coverages are presented
in Table 3.
Awbrey Butte, Overturf Butte, St. Charles -Bend, Hoodoo Mountain, Cline
Butte, Mount Bachelor Pine Marten, Henkle, Glacier Road, Bearwallow,
Scale House, Lookout Mountain, Pine Mountain West, Hampton
Outbound Coverage Level
Bend 15dB In -Building
92.9%
Redmond 15dB In -Building
93.7%
Portable Radio Outdoors
78.7%
Mobile Radio
89.0%
1II\.1QDWI
Trott Communications Group, Inc. 4
Deschutes County, Oregon
Coverage Predictions Report
5.0 SUMMARY
March 20, 2020
Terrain and the County's asymmetrical geographic shape provide challenges to maximizing
coverage while minimizing communication site counts. The predicted coverage maps in Appendix
Exhibits 4-6 provide the County a visual guide of the coverage provided by each of the candidate
sites and can assign priorities to the additions of each candidate site if a phased approach of site
additions is required. Trott also analyzed the incremental County -wide geographic coverage
increase provided to outdoor portable radios by each of the candidate sites. Table 4 shows these
increases.
Outdoor Portable Radio Coverage Increase
Lookout Mountain
+19.2%
Pine Mountain West
+19.2%
Hampton Butte
+14.4%
Bearwallow
+2.2%
Henkle
+4.2%
Scale House Microwave Cell Site
+0.3%
Glacier Road
+0.2%
TABLE 4
As can be seen from the propagation maps and from Table 4, Lookout Mountain and Pine
Mountain West best boost outdoor portable radio coverage county -wide. Lookout Mountain has
the added benefit of providing coverage to the Cities of Sunriver and La Pine. Henkle's benefit,
while not significant, does fill in the coverage gaps to the north-northwest of the County and to the
City of Sisters. Bearwallow, Glacier Road, and Scale House are included to boost in -building
coverage to their respective cities but are included in Table 4 for comparison purposes.
One final observation noted by Trott during this study was the seemingly minimal coverage to the
County by the existing sites of Hoodoo Mountain and Mount Bachelor Pine Marten. Trott ran
coverage of all the sites included in Table 3 but removed these two sites. The resultant coverage
percentages provided by this configuration are presented in Table 5 for informational purposes.
Trott Communications Group, Inc. 5
Deschutes County, Oregon
Coverage Predictions Report
March 20, 2020
Removal of Mount Bachelor Pine Marten and Hoodoo Mountain
Outbound Coverage Level
Bend 15dB In -Building
92.9%
Redmond 15dB In -Building
93.7%
Portable Radio Outdoors
76.1%
Mobile Radio
86.5%
TABLE 5
It should be noted that the results and implied recommendations presented herein are based solely
upon the propagation analysis performed. There may be other factors or considerations including
site availability, priority coverage areas, etc. Additional analysis may be required to incorporate
these factors.
Trott Communications Group, Inc.
APPENDIX
Exhibit 1 — Existing 800 MHz Deschutes County Coverage
Exhibit 2 — Existing 800 MHz City of Bend Coverage
Exhibit 3 — Existing 800 MHz Cities of Redmond and Sisters Coverage
Exhibit 4 — Supplemented 800 MHz Deschutes County Coverage
Exhibit 5 — Supplemented 800 MHz City of Bend Coverage
Exhibit 6 — Supplemented 800 MHz Cities of Redmond and Sisters Coverage
Exhibit 7 — Supplemented 800 MHz Deschutes County SDS
Exhibit 8 — Supplemented 800 MHz City of Bend SDS
Exhibit 9 — Supplemented 800 MHz Cities of Redmond and Sisters SDS
H
m
pia
n
doU
m
o
�
gay 3
v
3 � muV
mm
w
U o
N rn
'O, o
Doa N0
d
y
mm 'Nm
3w,3dd�
L W
a`
t
c«Ec
m
coi
�co
in
o
aPrnoo
' �«coi
w
c
n v nXQX o,
pKS
c
a
d
U
_
O
n
•
E
S
N
N
L
O
m
C
b
Ia
4
`'rt`• Pv'we✓y
pOp �
lit
{!
!2f
/!
Eat
fE
Ewa 2
|,
\
\
OKI
;$
2
! kaak�/d
k
§
■�� !
m
RI
o
8M
EOM
q E
.6 0
89
L)
E
CIL
4.
41
m
v3
aka
ra'
a�O
C
oEdE
C
chi
0 w
a
E
5
as 606
Oo
2
N m
y
M m 0.6
t
No
�e E E 12
3
�a
o�
000O
O moo �co
ri
Q
oo v XX •y
r
Y z W
v
h a�•7.
y
f
r f '
�
pad ;a
•,
i
{
p i
i
fS
l; A
Y ,L'f
z� 6
�
r
4
..f
n
I�
4
I �
m
N
N.r.N
N L
aC
e r
a
m
goy
3
c
0 w
�
a
9ua
p
U
mm
oo �Fc
j$
E E 2 o
moon 22
N a
—
o�'Q
03 0000 ��a
O �rno� �cn
yxa m
mg2
r
Ll
a
5
m o-
g E
E S
0
m �
T y
C w`
to
6
R
0 a.
O 7
N oHQ
Cc)
N
N
V 66 EM
X
ri v o.Qa
r
C
U
N
A
m
6
X
W
E e
v ow >> g~4
N o
oo �co
E ri v Sx¢x�'
N pK=
UoUo N
N
a
0
N
l
y
w
o'
=
3
�
m �
c'
�
m
m
O
e
� m
COTES CO
o Deschutes County Board of Commissioners
1300 NW Wall St, Bend, OR 97703
(541) 388-6570 - Fax (541) 385-3202 - https://www.deschutes.org/
AGENDA REQUEST & STAFF REPORT
For Board of Commissioners BOCC Monday Meeting of May 18, 2020
DATE: May 14, 2020
FROM: Greg Munn, Finance, 541-388-6559
TITLE OF AGENDA ITEM:
Treasurer and Finance Report
MEMORANDUM
DATE: May 20, 2020
TO: Board of County Commissioners
FROM: Greg Munn, Acting County Treasurer and Chief Financial Officer
SUBJECT: Treasury and Finance Report
Following is the unaudited monthly finance report for fiscal year to date April 30, 2020.
Treasury and Investments
• The portfolio balance at the end of April was $229M, an increase of $3.5 million from last month but an increase
of $28M (14%) from a year ago.
• Net investment income for the month is $332,533, $23,384 less than last month and $70,342 less than April 2019.
While the year to date net interest income is 6% more than the prior year, this difference is expected to narrow as
the average portfolio return continues to decline (9% last month and 13% and 17% the prior months).
• All portfolio category balances are within limits with the exception of corporate notes and LGIP. Corporates are at
25.6% of the portfolio (on a 25% policy) but down from 26.6% last month and the LGIP balance is $52.7M on
$50.4M limit. The PERS deposit and tax payments in May will reduce the LGIP under the limit but will cause the
ratio of corporates to increase to approximately 27% of the portfolio. We will work on walking back the corporate
percentage to within policy limits as new investments are purchased.
• Average portfolio yield continues to decline. Yield average for the month is 2.01% which is down from last
month's 2.06% reflecting lower return opportunities in the securities market.
• The Local Government Investment Pool rate was reduced from 2.00%to 1.75% on April 2. The rate was further
reduced to 1.3% on May 14.
• The weighted average time to maturity is at 0.7 years which reflects continued investments in short term options
due to the lack of longer term yield opportunities.
Portfollo Breakdown: Par Value by Investment Type
Invesbittient Income '
Municipal Debt
$ 14,730,0D0
6.4%
Apr-20
Y-T-D
Corporate Notes
58,590,000
26.6%
Total Investment Income
350,035
3,892,541
Time Certificates
-
0.0%
Less Fee: 5% of Invest. Income
(17,502)
194,627
U. S. Treasuries
14,000,000
6.1%
Investment Income - Net
332,633
3,697,914
Federal Agencies
78,465,000
34.3%
LGIP
52,742,697
23.0%
Prior Year Comparison Apr-19
402,876
3,479,727
First Interstate Bands
10,505,486
4.6%
Total Investments
$ 229,033,183
100.0%
Category Maximums: Yield Pementa es
Total Portfolio: By Investment T s U.S. Treasuries 100% Current Month Prfor Month
First Interstate LGIP ($50,400,000) 100% FIB/ LGIP 1.75%
Banc Municipal Debt Federal Agencies 100% Investments 2.17%
4.6% 6.4% I Banker's Acceptances 26% Average 2.01%
Time Certificates 60%
Municipal Debt 26%
Benchmarks=1.7
Corporate Notes
25.6%LGIP
Co orate Debt 26%
24 Month Trees.
Rato
Wel hted Ave Matu
36 Month Treasu
Max 3.64 Years 0.88
Term
Mlnknum
Actual
Time
0 to 30 Days
10%
31.6%
Certificates
Under 1 Year
26%
$2.1%
0.0 %
Under 5 Years
100%
100.0%
Other Policy Actual
Federal u. s. T easu es Corp Issuer 6% 4.4%
Agencies 6.1%
34.3% Callable 25% 17.0%
Credit W/A AA2 AA1
4.50%
4.00%
3.50%
3.00%
2.50%
2.00%
1.50%
1.00%
0.50%
0.00%
300, 000, 000
250, 000, 000
200,000,000
150, 000, 000
100, 000, 000
50,000,000
24 Month Historic Investment Returns
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
-County Rate 2 Year Treasury Rate Corporate Bond Rate =-- LGIP Rate
m own a o O m r�o r`c o. G a�i m aai o v v m a
d ,n O z p d d ✓i p d d in O z p d
Deschutes County Investments Purchases made in April 2019
Portfolio Management Purchases made in April 2020
Portfolio Details - Investments
April 30, 2020
Purchase
Maturity
Days To
Ratings
Coupon
Par
Market
Book
Inv #. "
Inv Typ `
CUSIP !. ' Security '
• Broke '
Date - `
Date "i
Maturi_'_Mood SBPIFit `
Raq.-, YTM 3I `
Value
Value -;.'..
Value "
10688
MCI
037833BE9 Apple Inc
CASTLE
1/15/2019
5/6/2020
5 Aal
AA+
2.2046 2.40792
2,000,000
1,999,980
2,000,048
10746
TRC
912833KZ2 U.S. Treasury
CASTLE
1/24/2020
5/15/2020
14 Aaa
AA+
1.5643 1.57183
4,000,000
3,999,880
3,997,600
10597
FAC
3134GBNK4 Federal Home Loan Mtg Corp
CASTLE
7/13/2017
5/29/2020
28 Aaa
AA+
1.625 1.67124
3,000,000
3,003,330
3,000,000
10664
MUN
736688LD2 Portland Community College
Pi
11/27/2018
6/1/2020
31 Aal
AA+
3.126 3.126
515,000
615,834
515,000
10690
MCI
740189AL9 Precision Castparts Corp
CASTLE
2/19/2019
6/15/2020
45 A2
AA-
2.25 2.80011
1,000,000
1,000,470
999,343
10479
MUN
686053DH9 Oregon School Boards Assoc
DA DAV
11/2/2015
6/30/2020
60 Aa2
AA
5.373 2.05005
875,000
880,661
879,522
10523
MUN
686053DH9 Oregon School Boards Assoc
CASTLE
6/24/2016
6/30/2020
60 Aa2
AA
5.373 1.57009
500,000
503,235
503,009
10580
ACB
686053CK3 Oregon School Boards Assoc
CASTLE
3/15/2017
6/30/2020
60 Aa2
A+
2.0626 2.14874
1,000,000
998,020
996,609
10599
MUN
569203MA7 Salem-Keizer School District
CASTLE
7/26/2017
6/30/2020
60 Aa2
2.107 1.77835
2,310,000
2,313,881
2,311,200
10715
AFD
76116FAD9 RFSCP STRIP PRIN
MORETN
10/3/2019
7/15/2020
75 Aaa
1.8011 1.85283
3,000,000
2,997,720
2,957,075
10572
MCI
94974BGM6 Wells Fargo Corporate Note
Pi
1/19/2017
7/22/2020
82 A2
A-
2.6 2.35002
1,000,000
1,003,480
1,000,537
10691
MCI
94974BGM6 Wells Fargo Corporate Note
CASTLE
2/22/2019
7/22/2020
82 A2
A-
2.6 2.9402
1,000,000
1,003,480
999,254
10676
MCI
90331 HNW9 U S Bank - Corp Note
CASTLE
12/18/2018
7/24/2020
84 Al
AA-
2.0509 2.6509
1,500,000
1,498,965
1,499,487
10680
FAC
3130A5Z77 Federal Home Loan Bank
MORETN
12/21/2018
7/29/2020
89 Aaa
AA+
1.83 2.69091
2,000,000
2,006,680
1,995,905
10717
TRC
912803AU7 U.S. Treasury
CASTLE
10/18/2019
8/15/2020
106 Aaa
- AA+
1.6379 1.68377
4,000,000
3,999,000
3,945,040
10742
MCI
89236TFK6 Toyota Mtr Cred - Corp N
CASTLE
12/17/2019
8/21/2020
112 Aa3
AA-
2.0446 1.92219
3,000,000
2,992,440
3,001,109
10656
TRC
9128284Y3 U.S. Treasury
MORETN
9/28/2018
8/31/2020
122 Aaa
AA+
2.625 2.81769
2,000,000
2,016,720
1,998,753
10633
MCI
053015AD5 AUTOMATIC DATA
CASTLE
2/26/2018
9/16/2020
137 Aa3
AA
2.25 2.57022
2,710,000
2,722,358
2,706,890
10653
TRC
9128281-65 U.S. Treasury
CASTLE
9/17/2018
9/30/2020
152 Aaa
AA+
1.375 2.76127
2,000,000
2,010,780
1,988,947
10573
MUN
940093R25 Washington Univ Higher Ed
Pi
1/19/2017
10/1/2020
153 Aa3
A+
5.93 1.97016
400,000
407,488
406,333
10629
MCI
45905U7J7 International Bonds for Recons
CASTLE
2/9/2018
10/5/2020
157 Aaa
AAA
2 2.47077
2,000,000
2,016,240
1,994,716
10659
MCI
45905U7J7 International Bonds for Recons
CASTLE
10/26/2018
10/5/2020
157 Aaa
AAA
2 3.07153
820,000
826,248
816,089
10703
MCI
45905U7J7 International Bonds for Recons
CASTLE
6/26/2019
10/5/2020
157 Aaa
AAA
2 1.99991
750,000
755,716
750,000
10657
AFD
76116FAE7 RFSCP STRIP PRIN
CASTLE
10/4/2018
10/15/2020
167 Aaa
2.764 2.95083
2,445,000
2,441,406
2,413,650
10714
MCI
46625HHU7 JPMorgan Chase - Corporate N
CASTLE
9/20/2019
10/15/2020
167 A2
A-
4.25 2.05949
3,000,000
3,043,380
3,029,443
10747
AFD
76116FAE7 RFSCP STRIP PRIN
CASTLE
1/29/2020
10/15/2020
167 Aaa
1.6269 1.68812
5,000,000
4,992,650
4,962,264
10548
MUN
492244DV7 Kern Community College
CASTLE
11/15/2016
11/1/2020
184
AA-
2.893 1,80006
500,000
503,990
502,626
10689
MUN
544587C30 LOS ANGELES MUNI IMP
CASTLE
2/11/2019
11/1/2020
184
AA-
3.146 2.87227
2,310,000
2,325,154
2,313,045
10617
FAC
3134GBX56 Federal Home Loan Mtg Corp
CASTLE
12/13/2017
11/24/2020
207 Aaa
AA+
2.25 2.17233
3,000,000
3,033,390
3,000,000
10719
MCI
06051GEE5 Bank of America Corp
CASTLE
10/22/2019
1/5/2021
249 A2
A-
5.875 1.8832
2,000,000
2,062,960
2,053,218
10758
MCI
89233P4S2 Toyota Mir Cred - Corp N
Pi
3/25/2020
1/11/2021
255 Aa
AA
4.25 2.79599
2,000,000
2,039,020
2,019,773
10745
MCI
94988J5M5 Wells Fargo Corporate Note
CASTLE
1/9/2020
1/15/2021
259 Aa2
A+
2.1413 1.9249
3,000,000
2,994,030
3,005,222
10725
MUN
73209MAC1 POMONA CALIF REDEV AGY
Pi
11/22/2019
2/1/2021
276
A+
3.406 1.80021
1,300,000
1,309,971
1,315,406
10735
MCI
90331 HPA5 US Bancorp
Pi
12/6/2019
2/4/2021
279 Al
AA-
3 1.85045
2,000,000
2,025,600
2,017,151
10722
FAC
880591 EL2 Tennessee Valley Authority
CASTLE
11/5/2019
2/15/2021
290 Aaa
AA+
3.875 1.64993
2,000,000
2,053,840
2,034,674
10739
TRC
912833LC2 U.S. Treasury
CASTLE
12/11/2019
2/15/2021
290 Aaa
AA+
1.6476 1.69748
3,000,000
2,994,780
2,940,690
10740
TRC
912833LC2 U.S. Treasury
CASTLE
12/13/2019
2/15/2021
290 Aaa
AA+
1.6476 1.69757
2,000,000
1,996,520
1,960,640
10687
VR2
89236TEV3 Toyota MtrCred- Corp N
CASTLE
1/9/2019
4/13/2021
347 Aa3
AA-
1.5914 2.51526
2,000,000
1,989,320
1,994,816
10702
VR2
06051GFV6 Bank of America Corp
CASTLE
5/31/2019
4/19/2021
353 Aaa
A-
4.0115 3.53654
1,050,000
1,055,576
1,061,259
10706
MUN
801577NR4 SANTA CLARA CNTY CALIF FING .CASTLE
7/2/2019
5/1/2021
365
AA+
2.05 2.26338
1,095,000
1,101,482
1,094,821
10700
MCI
06051GEH8 Bank of America Corp
CASTLE
5/9/2019
5/13/2021
377 A2
A-
5 2.70027
1,560,000
1,622,431
1,595,845
10757
MCI
09247XAF14 Federal Home Loan Mtg Corp
CASTLE
3/25/2020
5/24/2021
388 Aa3
AA-
4.25 2.65767
2,000,000
2,075,940
2,033,090
10741
TRC
9128286V7 U.S. Treasury
CASTLE
12/13/2019
5/31/2021
395 Aaa
AA+
2.125 1.70172
5,000,000
5,106,250
5,022,496
10728
MCI
46625HRT9 JPMorgan Chase - Corporate N
CASTLE
11/29/2019
6/7/2021
402 A2
A-
2.400 1.920
3,000,000
3,034,800
3,014,698
10738
MCI
46625HRT9 JPMorgan Chase - Corporate N
DA DAV
12/10/2019
6/7/2021
402 A2
A-
2.4 1.95567
2,000,000
2,023,200
2,009,687
10667
MCI
695114CM8 Pacific Corp
CASTLE
11/29/2018
6/15/2021
410 Al
A+
3.85 3.35022
1,170,000
1,199,952
1,176,234
10672
MCI
695114CM8 Pacific Corp
CASTLE
12/6/2018
6/15/2021
410 Al
A+
3.85 3.35091
830,000
851,248
834,419
10692
MCI
695114CM8 Pacific Corp
CASTLE
2/22/2019
6/15/2021
410 Al
A+
3.85 2.85033
2,000,000
2,051,200
2,019,303
10708
FAC
3133EKVC7 Federal Farm Credit Bank
CASTLE
7/29/2019
7/19/2021
444 Aaa
AA+
1.875 1.87488
3,000,000
3,056,700
3,000,000
10721
TRC
91282871`1 U.S. Treasury
CASTLE
10/31/2019
7/31/2021
456 Aaa
AA+
1.75 1.63127
6,000,000
5,098,850
5,007,248
10705
MUN
797398DK7 SAN DIEGO CN Y CALIF PENSIOICASTLE
7/1/2019
8/15/2021
471 AA2
AAA
5.835 2.00045
2,000,000
2,113,920
2,096,274
10737
FAC
3130A94N8 Federal Home Loan Bank
CASTLE
12/9/2019
8/25/2021
481 Aaa
AA+
1.7 1.71436
5,000,000
5,004,100
4,999,038
10696 '
AFD
88059E4M3'Tennessee Valley Authority
CASTLE
4/18/2019
` 9/15/2021
502 Aaa
AA+
2.3733 2.53553
1,020,000
1,004,731
` 986,243
10648
MCI
45905UC36 International Bonds for Recons
CASTLE
7/16/2018
9/28/2021
515 Aaa
AAA
2 2.96688
2,000,000
1,941,400
1,974,210
10731
MCI
94988J5TO Wells Fargo Corporate Note
CASTLE
12/5/2019
10/22/2021
539 Aa2
A+
3.625 1.94977
2,000,000
2,066,760
2,048,268
10724
FAC
3130AFUYO Federal Home Loan Bank
CASTLE
11/8/2019
11/19/2021
567 Aaa
AA+
1.625 1.71093
3,000,000
3,062,730
2,996,084
10744
FAC
3130AHSR5 Federal Home Loan Bank
CASTLE
12/20/2019
12/20/2021
598 Aaa
AA+
1.625 1.68014
3,000,000
3,066,870
2,997,350
10732
MCI
46625WD3 JPMorgan Chase - Corporate N
PJ
12/6/2019
44585
633 A2
A-
4.5 2.01005
2,000,000
2.111,400
2,083.910
10654
MCI
695114CPI Pacific Corp
CASTLE
9/25/2018
2/1/2022
641 Al
A+
2.95 3.32016
700,000
722,568
695,733
10726
FAC
3133EKCYO Federal Farm Credit Bank
CASTLE
11/21/2019
3/14/2022
682 Aaa
AA+
1.95 1.84902
5,000,000
5,005,660
5,007,979
10730
FAC
3133EKCYO Federal Farm Credit Bank
CASTLE
11/29/2019
3/14/2022
682 Aaa
AA+
1.95 1.83828
5,000,000
5,005,650
5,008,833
10720
MCI
90520EAH4 MUFG Union Bank
CASTLE
10/25/2019
4/1/2022
700 Aaa
A
3.15 2.03755
2,000,000
2,058,780
2,041,384
10750
MCI
90520EAH4 MUFG Union Bank
CASTLE
2/5/2020
4/1/2022
700 Aaa
A
3.15 1.81145
1,000,000
1,029,390
1,025,037
10749
FAC
3133ELLW2 Federal Farm Credit Bank
DA DAV
2/5/2020
5/5/2022
734 Aaa
AA-
1.61 1.62173
1,000,000
1,000,020
999,777
10759
MCI
037833CP3 Apple Inc
CASTLE
3/27/2020
5/11/2022
740 Aal
AA+
2.0809 3.16241
1,000,000
995,760
978,864
10733
MCI
084664BT7 Berkshire Hathaway Inc
MORETN
12/6/2019
5/15/2022
744 Aa2
AA
3 1.74
2,000,000
2,099,960
2,050,080
10736
FAC
3133ELCH5 Federal Farm Credit Bank
Pi
12/5/2019
6/2/2022
762 Aaa
AA+
1.7 1.71644
2,000,000
2,001,660
1,999,330
10652
MUN
686053BOl Oregon School Boards Assoc
MORETN
9/14/2018
6/30/2022
790 Aa2
AA
5.48 3.12
925,000
1,005,808
969,195
10748
FAC
3133EKJ56 Federal Farm Credit Bank
CASTLE
1/31/2020
8/30/2022
851 Aaa
AA+
1.9 1.30349
3,000,000
3,009,900
3,011,735
10727
MCI
06051GEU9 Bank of America Corp
CASTLE
11/25/2019
1/11/2023
985 A2
A-1
3.3 2.12008
2,000,000
2,096,180
2,061,181
10751
FAC
3130AJ5Q8 Federal Home Loan Bank
DA DAV
2/18/2020
2/14/2023
1019 Aaa
AA+
1.75 1.74997
2,000,000
2,000,600
2,000,000
10753
FAC
3135GOX99 Federal National Mtg Assn
CASTLE
2/24/2020
2/14/2023
1019 Aaa
AA+
1.7 1.69993
4,000,000
4,013,480
4,000,000
10709
MUN
29270CNU5 Bonneville Power Administratio
CASTLE
7/30/2019
7/1/2023
1166 Aal
AA-
5.803 2.12492
1,000,000
1,124,100
1,111,172
10713
MCI
361582AD1 Berkshire Hathaway Inc
CASTLE
9/9/2019
7/15/2023
1170 Aa3
AA
7.35 2.03065
500,000
589,005
581,596
10754
FAC
3134GVEG9 Federal Home Loan Mtg Corp
R W B
2/28/2020
2/28/2024
1398 Aaa
AA+
1.626 1.625
4,000,000
4,007,960
4,000,000
10755
FAC
3133ELQV9 Federal Farm Credit Bank
Pi
3/3/2020
9/3/2024
1586 Aaa
AA+
1.7 1.7
2,000,000
2,001,280
2,000,000
10752
FAC
3135GOY23 Federal National Mtg Assn
CASTLE
2/18/2020
2/18/2025
1754 Aaa
AA+
1.9 1.9
2,000,000
2,006,000
2,000,000
10078
RRP
SYS10078 Local Govt Investment Pool
7/1/2006
- -
1
1.75 1.76
52,742,697
52,742,697
52,742,697
10084
RR2
SYS10084 First Interstate
7/1/2006
- -
1
2.75 2.75
10,505 486
10 505,486
10,505,486
229,033 183
230,949,090
229,665,436
Budget to Actuals Report
Revenue YTD in the General Fund is 97.9% of budget (up from 95.9% last month) at $35.3 million, an increase of $2.5
million (8%) from last year which was at 95.9% of budget for the same time period. Expenses YTD are 78.9% of budget
at $29.7 million compared to $28.2 million and 78.6% of budget last year. Expenses YTD are $1.5 million (5%) more
than the same time period last year.
cour
Fund
All
nC:_.cnerd
070
DIQ t D"".
M-th!,v 6l Period
0
to
$9.6M
(Blank)
Monthly Expenditmes 78.61
'M of last vear budaet
Monthly Revenuer.
[& of last Veat budoet
FY20 Projected Ending Working Capital Approved FIT
109.66
Si `-
f
f
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 April 30, 2020.
Position Control Summary
July - June
Percent
Org
Sep
Oct
Nov
Dec
Jan
Feb
Mar
April
Unfilled
Assessor
Filled
34.26
34.26
34.26
34.26
34.26
33.26
33.26
33.26
Unfilled
1.00
1.00
1.00
1.00
1.00
2.00
2.00
2.00
3.69%
Clerk
Filled
8.48
8.48
8.48
8.48
8.48
8.48
8.48
8.48
Unfilled
-
-
-
-
-
1.00
1.17%
BOPTA
Filled
0.52
0.52
0.52
0.52
0.52
0.52
0.52
0.52
Unfilled
-
-
-
-
-
-
0.00%
DA
Filled
49.95
51.95
50.95
51.75
51.75
50.60
51.60
51.60
Unfilled
2.00
-
1.00
1.00
1.45
2.50
1.50
1.50
2.85%
Tax
Filled
4.50
4.50
4.50
4.50
4.50
4.50
4.50
4.50
Unfilled
-
-
-
-
-
-
0•00%
Veterans'
Filled
4.00
4.00
4.00
4.00
4.00
4.00
4.00
4.00
Unfilled
-
-
-
-
-
0.00%
Property Mngt
Filled
1.80
1.80
1.80
1.80
1.80
0.80
1.80
1.80
Unfilled
-
-
-
-
-
1.00
-
-
5.561/.
Total General Fund
Filled
103.51
105.51
104.51
105.31
105.31
102.16
104.16
104.16
Unfilled
3.00
1.00
2.00
2.00
2.45
5.50
3.50
4.50
2.79%
Justice Court
Filled
4.60
4.60
3.60
3.60
4.60
4.60
4.60
4.60
Unfilled
-
-
1.00
1.00
-
-
4.35%
Community Justice
Filled
47.20
47.90
47.90
47.90
47.90
47.90
46.90
47.90
Unfilled
0.70
-
-
-
-
1.00
-
0.71%
Sheriff
Filled
224.75
220.75
223.75
224.75
223.75
218.75
226.75
225.75
Unfilled
15.75
19.75
16.75
15.75
16.75
21.75
13.75
14.75
7.17%
Health Srvcs
Filled
291.20
293.95
291.95
293.30
294.10
293.35
293.35
294.45
Unfilled
18.70
16.95
18.75
17.40
17.05
17.80
17.80
16.70
5.80%
CDO
Filled
54.00
56.00
55.00
55.00
56.00
55.00
55.00
55.00
Unfilled
2.00
2.00
3.00
3.00
2.00
3.00
3.00
3.00
4.53%
Road
Filled
56.00
55.00
54.00
55.00
55.00
54.00
55.00
55.00
Unfilled
-
1.00
2.00
1.00
1.00
2.00
1.00
1.00
1.96%
Adult P&P
Filled
39.55
38.85
38.85
39.85
39.85
39.60
39.60
39.60
Unfilled
0.30
1.00
1.00
-
-
0.25
0.25
0.25
1.59%
Solid Waste
Filled
24.00
23.00
23.00
23.00
23.00
23.00
23.00
23.00
Unfilled
0.50
1.50
1.50
1.50
1.50
1.50
1.50
1.50
4.90%
9.1-1
Filled
56.53
56.53
56.53
55.53
53.00
53.00
53.00
53.00
Unfilled
3.48
3.48
3.48
4.48
7.00
7.00
7.00
7.00
8.98%
Victims Assistance
Filled
7.00
8.00
8.00
8.00
8.00
8.00
8.00
8.00
Unfilled
1.00
-
-
3.75%
GIS Dedicated
Filled
1.30
2.30
2.30
2.30
2.30
2.30
2.30
2.30
Unfilled
1.00
-
-
-
-
-
13.04%
Fair & Expo
Filled
11.00
11.00
11.00
11.00
11.00
12.00
11.00
11.00
Unfilled
1.00
1.00
1.00
1.00
1.00
-
1.00
1.00
6.67%
Natural Resource
Filled
1.00
1.00
1.00
1.00
2.00
2.00
2.00
2.00
Unfilled
-
1.00
1.00
1.00
-
-
17.65%
ISF - Facilities
Filled
19.00
19.00
19.00
20.00
20.00
20.00
20.00
20.00
Unfilled
6.00
6.00
6.00
5.00
5.00
5.00
5.00
5.00
22.00%
ISF - Adman
Filled
5.75
6.75
6.75
6.75
7.75
7.75
7.75
7.75
Unfilled
2.00
1.00
1.00
1.00
-
-
9.27%
ISF - SOCC
Filled
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
Unfilled
-
-
-
-
-
0•00%
ISF - Finance
Filled
10.00
10.00
10.00
10.00
9.00
10.00
10.00
10.00
Unfilled
-
-
-
-
1.00
-
1.00%
ISF - Legal
Filled
7.00
7.00
7.00
7.00
7.00
7.00
7.00
7.00
Unfilled
-
-
-
-
-
2.86%
ISF - HR
Filled
8.00
8.00
8.00
8.00
8.00
8.00
8.00
8.00
Unfilled
-
-
-
-
-
-
0.00%
ISF - IT
Filled
14.70
14.70
15.70
15.70
15.70
15.70
15.70
15.70
Unfilled
1.00
1.00
-
-
-
-
2.55%
ISF - Risk
Filled
2.25
2.25
2.25
2.25
2.25
2.25
2.25
2.25
Unfilled
-
-
-
-
-
-
-
-
8.16%
Total.
Filled
991.34
995.09
993.09
998.24
998.51
989.36
998.36
999.46
Unfilled
56.43
56.68
58.48
54.13
54.75
63.80
54.80
54.70
% Unfilled
5.39%
5.39%
5.56%
5.14%
5.20%
6.06%
5.20%
5.19%
5.57%
�-�Es`0
Budget to Actuals - Countywide Summary
All Departments 83.3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
Fiscal Year 2019
Fiscal Year 2020
RESOURCES
Budget
Actuals
%
Budget
Actuals
%
Projection
%
001 - General Fund
33,938,668
34,900,450
103% ;
35,797,833
35,113,788
98%
37,192,306
104% ;
030 - Juvenile
786,286
842,485
107% ;
856,930
520,306
61%
808,339
94% ;
160/170 - TRT
7,282,600
7,682,623
105% ;
7,732,000
7,348,812
95%
7,465,178
97% ;
220 - Justice Court
552,000
608,275
110% ;
578,000
475,571
82% ;
556,132
96% ;
255 - Sheriffs Office
39,225,869
40,517,859
103% ;
41,581,807
41,166,585
99% ;
42,593,805
102% ;
274 - Health Services
35,444,454
37,595,739
106% ;
36,132,298
27,891,281
77%
35,174,148
97% ;
295 - CDD
8,153,746
7,755,886
95% `,
8,468,820
6,601,057
78% ;
7,943,281
94% ;
325 - Road
22,876,423
23,035,209
101% ;
22,785,827
18,690,205
82%
21,709,757
95% ;
355 - Adult P&P
6,360,818
6,463,769
102% ;
5,775,278
6,529,578
113% ;
6,572,505
114% ;
465 - Road CIP
959,104
261,131
27%
2,142,893
1,483,442
69% ;
2,248,612
105% ;
610 - Solid Waste
11,868,613
11,504,244
97% ;
11,724,869
9,794,442
84%
11,922,020
102%:
615 - Fair & Expo
1,499,100
1,589,820
106% ;
1,561,500
865,050
55%
1,000,788
64% ;
618 - RV Park
358,600
488,620
136% ;
437,700
352,558
81%
393,648
90% ;
670 - Risk Management
3,569,944
3,477,056
97% ;
3,495,039
33396,359
97% ;
3,893,739
111% ;
675 - Health Benefits
21,411,563
22,699,675
106% ;
22,318,433
18,110,313
81%
21,786,085
98% ;
705 - 911
10,260,013
10,514,313
102% ;
10,563,350
9,894,508
94%
10,835,506
103%:
999 - Other
36,330,641
38,687,048
106% ;
31,222,790
30,871,373
99%
31,421,450
101% ;
TOTAL RESOURCES
; 240,878,442
248,624,202
103% ;
243,175,367
219,105,226
90% ;
243,517,299
100% ;
Fiscal Year 2019
Fiscal Year 2020
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
001 - General Fund
17,486,029
16,406,076
94%
18,300,987
14,260,637
78%
17,955,853
98% ;
030 - Juvenile
7,040,903
6,638,892
94%
7,127,337
5,770,647
81% ;
6,984,707
98% ;
160/170 - TRT
2,335,678
2,233,953
96% ;
2,212,140
2,065,423
93%
2,139,803
97% ;
220 - Justice Court
658,081
652,039
99% ;
678,141
563,845
83% ;
665,059
98% ;
255 - Sheriffs Office
42,853,022
41,553,897
97% ;
44,685,809
37,037,656
83% ;
45,044,429
101% ;
274 - Health Services
44,974,364
42,441,390
94% ;
473589,309
34,448,396
72%
44,817,067
94% ;
295 - CDD
7,726,157
7,331,793
95% ;
7,905,639
6,220,005
79%
7,438,705
94% ;
325 - Road
14,689,753
12,158,904
83%
14,573,336
9,685,273
66%
13,829,094
95% ;
355 - Adult P&P
6,505,128
6,208,673
95%
6,589,491
5,285,371
80%
6,535,198
99% ;
465 - Road CIP
8,309,501
5,484,366
66%
13,835,913
4,579,097
33% ;
7,246,847
52% ;
ES`��� 0
C�
Budget to Actuals - Countywide
Summary
o�
All Departments
83 3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
610 - Solid Waste 8,310,720 7,643,635
92% ;
8,384,039
5,275,076
63%
8,105,837
97% ;
615 - Fair & Expo 2,688,885 2,789,095
104% ;
2,464,787
2,025,379
82% ;
2,338,769
95% ;
618 - RV Park 521,971 499,108
96% ;
540,373
384,191
71%
494,976
92% ;
670 - Risk Management 3,858,097 2,862,764
74% ;
4,132,295
2,068,819
50% ;
3,271,598
79% ;
675 - Health Benefits 23,144,255 21,211,086
92%
22,115,011
17,770,306
80%
23,679,826
107% ;
705 - 911 13,379,064 10,570,113
79%
12,250,336
8,798,170
72% ;
11,734,860
96% ;
999 - Other 46,792,062 35,262,851
75%
60,808,382
30,567,029
50%
60,568,085
100% ;
TOTAL REQUIREMENTS 251,273,671 221,948,635
88%
274,193,325
186,805,320
68% ;
; 262,850,714
96% ;
Fiscal Year 2019
Fiscal Year 2020
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
001 - General Fund
(18,077,559)
(18,091,539)
100% ;
(19,023,310)
(15,215,688)
80%
(19,023,310)
100% ;
030 - Juvenile
5,744,015
5,744,015
100% ;
5,874,465
4,902,630
83% ;
5,874,465
100% ;
160/170 - TRT
(4,649,866)
(4,449,866)
96% ;
(4,133,128)
(3,364,624)
81% ;
(4,070,557)
98% ;
220 - Justice Court
30,000
30,000
100%-
255 - Sheriffs Office
2,981,253
2,981,254
100% ;
3,119,936
2,752,447
88%
3,119,936
100% ;
274 - Health Services
6,177,535
6,179,204
100% ;
6,102,365
4,644,231
76% ;
6,285,920
103% ;
295 - CDD
; (1,152,624)
(1,170,172)
102% ;
(1,448,081)
(1,063,667)
73% ;
(1,089,146)
75% ;
325 - Road
(14,464,308)
(14,464,308)
100% ;
(11,910,575)
(6,612,088)
56% ;
(11,910,575)
100%:
355 - Adult P&P
165,189
165,189
100% ;
223,189
191,150
86%
223,189
100%:
465 - Road CIP
13,811,725
13,393,963
97% ;
12,014,914
5,298,487
44%
11,893,453
99% ;
610 - Solid Waste
(4,688,023)
(5,000,029)
107% ;
(3,296,192)
(1,624,273)
49% ;
(3,296,192)
100% ;
615 - Fair & Expo
1,220,994
1,164,996
95%
1,022,863
739,700
72%
826,348
81% ;
618 - RV Park
160,000
160,000
100% ;
(307,000)
(64,750)
21%
(307,000)
100% ;
670 - Risk Management
(3,168)
(3,168)
100%:
(6,918)
(5,187)
75% ; ;
(6,918)
100% ;
705 - 911
-
-
-
-
999% ;
-
999 - Other
12,744,837
13,360,461
105% ;
11,767,472
9,421,632
80%
11,480,387
98% ;
TOTALTRANSFERS
E `0
Budget to Actuals - Countywide Summary
All Departments
83 3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
Fiscal Year 2019
Fiscal Year 2020
ENDING FUND BALANCE
Budget
Actuals
%
Budget
Actuals
Projection
%
001 - General Fund
9,265,080
12,349,379
133% ;
9,563,536
17,986,843 ;
12,562,522
131% ;
030 - Juvenile
689,399
1,296,490
188% ;
694,058
948,779
994,587
143% ;
160/170 - TRT
2,261,401
2,565,255
113% ;
3,686,732
4,484,020
3,820,073
104% ;
220 - Justice Court
67,919
144,227
212% ;
64,859
55,952
35,300
54% ;
255 - Sheriffs Office
13,191,907
16,818,660
127% ;
14,732,933
23,700,035
17,487,972
119% ;
274 - Health Services
3,850,339
10,638,105
276% ;
4,766,157
8,725,221
7,281,106
153% ;
295 - CDD
1,478,676
1,783,536
121% ;
1,097,104
1,100,921 ; ;
1,198,965
109% ;
325 - Road
2,416,014
6,726,840
278% ;
2,303,905
9,119,684
2,696,928
117% ;
355 - Adult P&P
2,220,879
2,754,005
124% ;
1,998,976
4,189,362
3,014,501
151% ;
465 - Road CIP
14,148,365
17,759,555
126% ;
15,938,430
19,962,387
24,654,773
155% ;
610 - Solid Waste
600,000
799,570
133% ;
644,638
3,694,663
1,319,561
205% ;
615 - Fair & Expo
31,209
(94,564)
-303% ;
199,576
(515,194)
(606,197)
-304% ;
618 - RV Park
315,629
592,992
188% ;
150,327
496,610
184,664
123% ;
670 - Risk Management
5,308,679
7,193,407
136% ;
5,455,826
8,515,761
7,808,630
143% ;
675 - Health Benefits
14,318,894
16,563,905
116% ;
16,309,716
16,903,912
14,670,164
90% ;
705 - 911
5,505,949
8,604,816
156% ;
6,066,720
9,701,153
7,705,462
127% ;
999 - Other
58,869,933
75,223,189
128% ;
55,033,130
84,949,165
57,556,940
105% ;
TOTAL FUND BALANCE
134,540,271
181,719,367
135% ;
138,706,623
214,019,274
162,385,952
117% ;
�-�ES Budget to Actuals Report
General Fund - Fund 001
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019 1
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Property Taxes - Current
27,318,385
27,774,133 102%
29,046,840
28,378,976 98%
29,256,769 101%
209,929� A
Property Taxes - Prior
389,000
433,798 112%,
391,000
902,899 231%
950,000 243%
559,000, B
Other General Revenues
2,685,500
3,272,354 122%
3,020,400
2,505,828 83%
3,161,400 105% ,
141,000, C
Assessor
870,658
823,127 95%
837,283
916,061 109%
920,000 110%
82,71T D
Clerk
1,787,270
1,702,762 95%
1,615,280
1,801,184 112%
1,911,780 118%
296,500; E
BOPTA
12,700
12,119 95%
12,220
13,659 112%
15,000 123%
2,78& D
District Attorney
389,782
386,919 99%
383,806
240,124 63%
421,743 110%
37,93T F
Tax Office
198,950
206,292 104%
195,390
246,778 126%
260,000 133%
64,610; D
Veterans
166,423
168,945 102%
175,614
89,307 51%
175,614 100%!
-� G
Property Management
120,000
120,000 100%
120,000
18,972 16% t
120,000 100%
- H
TOTAL RESOURCES
33,938,668
34,900,450 103% ;
35,797,833
35,113,788 98%
37,192,306 104% ;
1,394,473:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Assessor
4,802,452
4,530,558
94%
4,993,290
3,920,058
79%
4,824,863
97%
168,427,1
Clerk
1,854,397
1,598,764
86%
2,049,501
1,290,902
63%
1,948,790
95%
100,711! 1
BOPTA
73,125
69,565
95%
77,950
61,580
79%
77,007
99%
943!
District Attorney
7,372,932
6,993,244
95%
7,873,159
6,308,657
80%
7,700,653
98%
172,506! 1
Medical Examiner
173,129
160,296
93%
235,542
167,516
71%
235,542
100%!
-
Tax Office
872,020
779,330
89%
846,307
727,005
86%
855,934
101%
(9,627)�
Veterans
572,287
539,026
94%
589,551
438,619
74%
587,091
100%
2,460
Property Management
287,858
278,966
97%
281,985
255,020
90%
299,271
106%
(17,286); J
Non -Departmental
1,477,829
1,456,326
99%
1,353,702
1,091,281
81% f
1,426,702 105%
(73,000)
TOTAL REQUIREMENTS
17,486,029
16,406,076
94%
18,300,987
14,260,637
78% ;
17,955,853
98%
345,134:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
Transfers In
326,122
289,065
89%
260,000
195,000
75%
260,000 100% K
Transfers Out
(18,403,681)
(18,380,604)
100%
(19,283,310)
(15,410,688)
80%
(19,283,310) 100%
TOTALTRANSFERS
(18,077,559)
(18,091,539)
100%
(19,023,310)
(15,215,688)
80%
(19,023,310) 100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 10,890,000 11,946,544 110% 11,090,000 12,349,379 111% 12,349,379 111% 1,259,379�
Resources over Requirements 16,452,639 18,494,374 17,496,846 20,853,151 19,236,453 1,739,607;
Net Transfers - In (Out) (18,077,559) (18,091,539) (19,023,310) (15,215,688) (19,023,310)
TOTAL FUND BALANCE $ 9,265,080 $ 12,349,379 133% ; $ 9,563,536 $ 17,986,843 188% ; ; $ 12,562,522 131% ; $2,998,986:
A Current year taxes received primarily in November, February and May; actual 19-20 TAV is a 5.36% increase compared to FY 18-19 vs. 5.5%
budgeted; however, collection rate is projected to be 95.8% versus 95% budgeted.
B TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment
C PILT payment of $500,000 received in July. Includes $112,566 of Marijuana tax YTD; interest projection based on current investment rate and
anticipated cash balances
D A & T Grant received quarterly. Q1 - July; Q2 - October; Q3 - January; Q4 - April.
E Recording fees are up 44% YTD compared to the prior year
F YTD collections are low because Discovery Fees have been delayed due to administrative transitions; revenues expected to be collected in full by
the end of the fiscal year
G Oregon Dept. of Veteran's Affairs grant reimbursed quarterly.
H Interfund land -sale management revenue recorded at year-end.
I Savings related to FTE vacancies YTD and forecasted vacancy rates consistent with YTD experience.
J Retirement payout not anticipated when the budget was developed
K Repayment to General Fund from Finance Reserves for ERP Implementation
E S`�� Budget to Actuals Report
Juvenile - Fund 030
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
OYA Basic & Diversion
407,113
413,320 102%
442,601
189,167
43%
390,000
88%
(52,601); A
ODE Juvenile Crime Prev
r 91,379
92,492 101%
91,379
42,120
46%
80,000
88%
(11,379) A
Leases
85,000
87,311 103%
86,400
74,555
86%
95,000
110% !
8,600; B
Inmate/Prisoner Housing
70,000
97,200 139%
80,000
85,200
107%
94,000
118% !
14,00& C
DOC Unif Crime Fee/HB2712
r 35,000
43,681 125%
35,000
49,339
141%
49,339
141%
14,339 D
Interest on Investments
r 25,000
31,318 125%
31,000
23,473
76%
29,000
94%
(2,000); E
OJD Court Fac/Sec SB 1065
17,000
27,158 160% t
26,000
18,549
71%
22,000
85%
(4,000)
Gen Fund -Crime Prevention
r 20,000
20,000 100%
20,000
15,000
75%
20,000
100%!
-; A
Food Subsidy
18,744
12,052 64%
16,000
11,589
72%
14,500
91%
(1,500); F
Miscellaneous
r 2,050
4,603 225%
14,050
3,222
23%
4,000
28%
(10,050); G
Contract Payments
8,000
7,269 91 %
8,000
4,206
53% _
5,500
69%
(2,500); H
Case Supervision Fee
r 7,000
6,081 87%
6,500
3,886
60%
5,000
77%
(1,500)� 1
TOTALRESOURCES
786,286
842,485 107% ;
856,930
520,306
61% ;
808,339
94%
(48,591);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
5,705,245
5,412,349
95% 5,797,927 4,707,698 81% t t 5,668,211 98% 129,71& J
Materials and Services
1,327,658
1,218,976
92% 1,329,410 1,062,949 80% 1,316,496 99% 12,914, K
r
Capital Outlay r
8,000
7,566
95% - -
r
TOTAL REQUIREMENTS
7,040,903
6,638,892
94% 7,127,337 5,770,647 81% ; 6,984,707 98% 142,630:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
Transfers In- General Funds
5,831,015
5,831,015
100%
5,961,465
4,967,880
83%
5,961,465 100% -
Transfers Out-Veh Reserve
r (87,000)
(87,000)
100%
(87,000)
(65,250)
75%
(87,000) 100%
TOTALTRANSFERS
5,744,015
5,744,015
100% ;
5,874,465
4,902,630
83% ;
5,874,465 100%
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Beginning Fund Balance
1,200,000
1,348,881 112%
1,090,000
1,296,490 119%
1,296,490 119%
206,49&
Resources over Requirements
(6,254,617)
(5,796,407)
(6,270,407)
(5,250,341)
(6,176,368)
94,039;
Net Transfers - In (Out)
5,744,015
5,744,015
5,874,465
4,902,630
5,874,465
TOTAL FUND BALANCE
$ 689,399
$ 1,296,490 188% ;
$ 694,058
$ 948,779 137% ;
$ 994,587 143% ;
$300,529:
A Quarterly Reimbursement based on actual expenses; COVID impacted lowered projection
B Projection based on YTD actuals. Leased a second office to J Bar J Youth Service.
C Out of county juvenile detention housing. Fluctuates in accordance with other county policy/usage. Current YTD trend higher than budgeted.
D Annual payment received from State Dept. of Corrections based on new state formula higher than budgeted
E Interest projection based on current investment rate and anticipated cash balances
F Projection based on YTD actuals. Less than anticipated qualifying juvenile detention meals.
G Anticipated grant revenue from youth substance abuse research study lower than budgeted due to project start-up delays.
H Payments for community service crew projects. Fluctuates depending on community need/request. Covid impact lowered projection.
I Projection based on YTD actuals. COVID impact lowered projection further.
J Projected Personnel savings based on YTD average vacancy rate of 0.7%
K Projected based on YTD actuals. COVID impact lowered many staff and youth expense projections.
Co
Budget to Actuals Report
h
TRT - Fund 160/170
83.3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
Fiscal Year2019
Fiscal Year2020
RESOURCES
Budget Actuals %
Budget
Actuals %
Projection % $ Variance
Room Taxes
7,260,000 7,618,179 105%
7,670,000
7,270,420 95%
7,375,475 96% (294,525); A
Interest
22,600 64,444 285%
62,000
78,391 126%
89,703 145% 27,703, B
TOTALRESOURCES
7,282,600 7,682,623 105% ;
7,732,000
7,348,812 95%
7,465,178 97% (266,822);
REQUIREMENTS Budget Actuals % Budget Actuals %
COVA
1,946,668
2,067,761
106%
2,064,221
1,947,322
94%
Interfund Contract
59,121
59,121
100%
79,160
65,967
83%
Interfund Charges
39,087
39,087
100%
37,309
31,091
83% !
Auditing Services
12,501
10,800
86%
14,500
4,200
29%
Software
60,000
51,533
86%
10,350
5,600
54%
Office Supplies
4,000
1,589
40%
3,000
559
19%
Printing
2,200
209
9%
2,000
642
32% E
Public Notices
3,101
1,834
59%
1,600
1,386
87%
Refunds & Adjustments
-
-
-
8,657
999%
Sunriver Service Dist
200,000
-
0%
Temporary Help
9,000
2,020
22%
TOTAL REQUIREMENTS
2,335,678
2,233,953
96%
2,212,140
2,065,423
93% ;
TRANSFERS Budget Actuals % Budget Actuals %
Transfer Out - RV Park
(35,000)
(26,250)
75%
Transfer Out - Annual Fair
(150,000)
(150,000)
100%
(250,000)
(187,500)
75%
Transfer Out - F&E Reserve
(830,083)
(630,083)
76%
(286,687)
(215,013)
75%
Transfer Out - F&E
(517,996)
(517,996)
100%
(409,654)
(309,381)
76%
Transfer Out - Sheriff
(3,151,787)
(3,151,787)
100%
(3,151,787)
(2,626,480)
83%
TOTALTRANSFERS
(4,649,866)
(4,449,866)
96%
(4,133,128)
(3,364,624)
81% ;
FUND BALANCE Budget Actuals % Budget Actuals %
Beginning Fund Balance
1,964,345
1,566,452 80%
2,300,000
2,565,255 112%
Resources over Requirements
4,946,922
5,448,669
5,519,860
5,283,388
Net Transfers - In (Out)
(4,649,866)
(4,449,866) 4
(4,133,128)
(3,364,624) t
TOTAL FUND BALANCE
$ 2,261,401
$ 2,565,255 113% ;
$ 3,686,732
$ 4,484,020 122% ;
Projection %
$ Variance
1,983,227 96%
80,994, C
79,160 100%!
D
37,309 100%
14,500 100%
�
r
10,350 100%:
3,000 100%,
2,000 100%
1,600 100%
8,657 999%
t i
(8,657); �
72,337:
2,139,803 97% ;
Projection % $ Variance
(35,000) 100%
(250,000) 100%,
(275,631) 96% 11,056,
(358,139) 87% 51,515!
(3,151,787) 100%,
(4,070,557) 98% 62,571:
Projection %
$ Variance
2,565,255 112%
I
265,255:
!
3
5,325,375
i
(194,485);
r
i
(4,070,557)
i i
62,571,
e
$ 3,820,073 104% ;
$133,341:
A Prior year collections YTD was 92% of budget, compared to current year collections YTD of 95%; remaining FY20 revenue assumed to be minimal
due to COVID.
B Includes interest payments from delinquent tax collections.
C COVA is estimated to receive less TRT revenue than budgeted due to COVID
D Contracted services with the Finance Department for operating TRT program
CO
>? Budget to Actuals Report
Justice Court - Fund 220
83.3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
Fiscal Year 2019
Fiscal Year 2020
RESOURCES Budget Actuals %
Budget
Actuals % Projection
% $ Variance
Court Fines & Fees 550,000 605,344 110%
575,000
473,968 82% 553,967
E
96% (21,033); A
Interest on Investments E 2,000 2,931 147%
3,000
1,603 53% 2,165
72% (835)
TOTALRESOURCES 552,000 608,275 110%;
578,000
475,571 82% 556,132
96% (21,868);
REQUIREMENTS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Personnel Services
508,650
508,098 100%
516,868
443,786
86%
523,786 101%
(6,918), B
Materials and Services (
149,431
143,941 96%
I
161,273
120,059
74%
141,273 88%
20,000 C
TOTAL REQUIREMENTS
658,081
652,039 99% ;
678,141
563,845
83% ;
665,059 98%
13,082;
TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance
Transfers In- General Fund 30,000 30,000 100% - -
I
TOTALTRANSFERS 30,000 30,000 100%
FUND BALANCE Budget Actuals % Budget Actuals %
Projection
% $ Variance
Beginning Fund Balance 144,000 157,990 110% 165,000 144,227 87%
144,227
87% (20,774);
Resources over Requirements (106,081) (43,764) (100,141) (88,275)
E t E I
(108,927)
(8,786)
( I
Net Transfers - In (Out) 30,000 30,000
t
-
TOTAL FUND BALANCE $ 67,919 $ 144,227 212% ; $ 64,859 $ 55,952 86%
$ 35,300
54% ($29,560);
A Loss of revenue is a result of not accepting small claims filings in March, April & May due to COVID 19
B Projected Personnel overage attributed to payout for terminated employee; however, overage reduced from March's projections because temporary
help have been laid off due to COVID 19
C Projection based on actuals to date and estimated spending through June 30, 2020
�IES`� Budget to Actuals Report
Sheriffs Office - Fund 255
FY20 YTD April 30, 2020 (unaudited)
RESOURCES
LED #1 Property Tax Current
LED #2 Property Tax Current
Sheriff's Office Revenues
LED #1 Property Tax Prior
LED #2 Property Tax Prior
LED #1 Interest
LED #2 Interest
LED #1 Foreclosed Properties
LED #2 Foreclosed Properties
TOTALRESOURCES
REQUIREMENTS
Sheriffs Services
Civil/Special Units
Automotive/Communications
Detective
Patrol
Records
Adult Jail
Court Security
Emergency Services
Special Services
Training
Crisis Stabilization Center
Other Law Enforcement
Non - Departmental
TOTAL REQUIREMENTS
83.3%
Year Complete
Fiscal Year2019 Fiscal Year2020
Budget Actuals % Budget Actuals % Projection % $ Variance
24,780,245 25,153,487 102% 26,293,470 25,665,976 98% 26,432,672 101% 139,202, A
10,027,098 10,171,051 101% 10,632,014 10,361,297 97% ! r 10,670,810 100%, 38,796, A
3,675,026 4,153,450 113% 3,922,323 3,738,411 95% 4,007,323 102% 85,000! B
312,000 326,275 105% 312,000 702,534 225% 728,000 233% 416,000! C
166,500 157,143 94% 148,000 305,726 207% 320,000 216% 172,000! C
145,000 288,269 199% 138,000 251,078 182% 274,000 199% 136,000! D
t 120,000 193,301 161% 136,000 141,563 104% ! 161,000 118% 25,000! D
� r I, I ,
53,322
21,561
39,225,869 40,517,859 103% ; 41,581,807 41,166,585 99% 42,593,805 102% ; 1,011,998:
Budget Actuals % Budget Actuals %
2,997,984
�
3,068,683 102%
i
3,105,057
2,516,967
81%
I
1,181,695
1,149,677 97%
1,232,158
1,016,458
82%
t 2,644,785
2,532,545 96%
2,858,337
2,358,033
82%
2,033,077
2,044,686 101%
2,303,072
1,853,266
80%
I
10,003,952
i
10,040,921 100%
10,592,002
9,528,623
t
90%
881,182
892,837 101%
1,004,600
694,652
69%
18,357,098
�
17,364,464 95%
18,379,998
14,914,049
81%
551,494
i
531,409 96%
556,740
375,687
I
67%
328,581
341,586 104%
402,734
409,572
102%
t 1,520,623
1,451,124 95%
1,601,871
1,415,063
88%
667,647
874,923 131%
t
743,334
761,772
102%
I
,
559,308
82,308 15%
571,267
70,223
12%
t
i
1,017,266
i
1,070,404 105%
1,330,214
1,018,112
77%
4
I
108,329
i
108,329 100%
4,425
105,180 999%
42,853,022
41,553,897 97%
44,685,809
37,037,656
83% ;
Projection % $ Variance
3,111,072 100%;
(6,015); E
1,213,428 98%
18,730,
2,920,488 102%
f
(62,151)!
1
2,233,037 97%
70,035!,
r
t ,
11,237,773 106%
(645,771); F
873,981 87%
�
130,113%
18,372,513 100%! !
r
7,485!I G
I
I
457,438 82%
�
99,302
I
471,980 117%
I
(69,246);
! 1,651,557 103%
(49,686)
889,734 120%
�
(146,400)
t
I
246,201 43%
325,066,
1,259,310 95%
I
70,904;
,
,
105,917 999%
(101,492);
45,044,429 101% ;
(358,620);
TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance
Transfer In - TRT
3,151,787
3,151,787 100%
3,151,787
2,626,480
83%
3,151,787 100%
Transfer In - General Fund
103,132
103,132 100%
240,249
200,200
83%
240,249 100%
Transfers Out - Debt Service
I (273,666)
(273,666) 100% _
(272,100)
(74,233)
27%
(272,100) 100%
TOTALTRANSFERS
2,981,253
2,981,254 100% ;
3,119,936
2,752,447
88%
3,119,936 100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance
13,837,807
14,873,445 107% 14,716,999
16,818,660 114% <
16,818,660 114% 2,101,661;
Resources over Requirements
(3,627,153)
t
(1,036,039) (3,104,002)
i
4,128,929
I I
(2,450,624) 653,378;
E I
Net Transfers - In (Out)
2,981,253
r
2,981,254 3,119,936
p
2,752,447
E t
3,119,936
t E
TOTAL FUND BALANCE
$ 13,191,907
$ 16,818,660 127% , $ 14,732,933
$ 23,700,035 161% ; $
17,487,972 119% ; $2,755,039:
A While 19-20 TAV was 0.14% lower vs budget, the collection rate is estimated at 95.8% vs. 95.0% in the budget
B Projected to exceed budget due to additional SB 395 Prisoner Housing funds in Adult Jail
C TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment
D Interest projection based on current investment rate and anticipated cash balances
E Variances in most Divisions are from projections based on YTD personnel and positions that are unfilled or over -filled; includes projection for an
interfund payment to Fair & Expo for 1.00 FTE in May and June.
F Variance due to over hiring for open and soon -to -be open positions; up to 18-months of lead time is necessary for background and training. Though
temporary, the forecast assumes the trend continues for the remainder of the year.
G In addition to variance described in Footnote E, projection includes estimated one-time medical expenses
Budget to Actuals Report
Health Services -Fund 274
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019 1
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
State Grant
13,262,344
13,053,849 98%
14,080,644
11,013,772
78%
13,003,372 92%
(1,077,272);
OHP Capitation
8,652,200
8,142,094 94%
7,242,430
5,852,348
81%
7,887,425 109% =
644,995
Title 19
1,345,100
3,069,162 228%
4,8629726
3,315,801
68%
4,000,821 82%
(861,905)
Federal Grants
990,189
1,311,567 132%
3,277,616
2,164,433
66%
2,733,525 83%
(544,091)l
Local Grants
1,208,623
1,025,508 85%
1,567,331
1,416,054
90%
1,849,901 118%
282,570
Environmental Health Fees
1,169,600
1,076,036 92%
1,058,206
1,042,579
99%
1,082,798 102%
24,592
State Miscellaneous
899,734
1,808,299 201%
1,040,153
428,459
41% !
1,506,501 145%
466,348
State - OMAP
1,147,168
1,108,622 97%
991,900
719,251
73% f
856,902 86%
(134,998)!
Patient Fees
236,500
637,910 270%
564,750
528,852
94%
614,253 109%
49,503
Other
422,593
477,834 113%
484,712
416,478
86% !
542,345 112%
57,633!
Vital Records
212,000
241,727 114%
220,000
211,837
96%
250,036 114%
30,036
Divorce Filing Fees
157,603
157,603 100%
173,030
173,030
100%!
173,030 100%
Interest on Investments
135,000
218,767 162%
171,000
203,169
119%
243,803 143%
72,803
Liquor Revenue
151,000
166,372 110%
150,800
110,392
73%
127,292 84%
(23,508)
Interfund Contract- Gen Fund
127,000
127,000 100%
127,000
127,000
100%
127,000 100%
State Shared- Family Planning
-
168,007
120,000
167,826
140%
175,144 146% ,
55,144
CCBHC Grant
5,327,800
4,805,382 90%
-
-`
TOTALRESOURCES
35,444,454
37,595,739 106% ;
36,132,298
27,891,281
77% ;
35,174,148 97% ;
(958,150)
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Administration Allocation
'
Personnel Services
31,702,065
29,780,257
94%
33,186,830
26,584,313
80%
32,343,164 97%
843,666,
Materials and Services
13,033,299
12,455,102
96%
13,707,479
7,864,083
57%
11,526,533 84%
2,180,946
Capital Outlay
239,000
206,031
86%
695,000
-
0% t
947,370 136%
(252,370)
TOTAL REQUIREMENTS ;
44,974,364
42,441,390
94%
47,589,309
34,448,396
72%
44,817,067 94% ;
2,772,242:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Transfers In- General Fund
6,366,223
6,367,892
100%
5,747,090
4,789,224
83%
5,747,090 100%
-
Transfers In- OHP Mental Health
548,601
-
0%
732,156 133% =
183,555
Transfers Out
(188,688)
(188,688) 100%
(193,326)
(144,993)
75%
(193,326) 100%
TOTALTRANSFERS
6,177,535
6,179,204 100%:
6,102,365
4,644,231
76%
6,285,920 103% ;
183,555:
FUND BALANCE
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Beginning Fund Balance
7,202,714
9,304,552
129%
10,120,803
10,638,105
105%
10,638,105 105% :
517,302:
Resources over Requirements
(9,529,910)
(4,845,651)
(11,457,011)
(69557,116)
(9,642,919)
1,814,092;
Net Transfers - In (Out)
t
6,177,535
6,179,204
�
6,102,365
4,644,231
�E
6,285,920
F
183,555�
i
TOTAL FUND BALANCE
$ 3,850,339
$ 10,638,105
276% ;
$ 4,766,157
$ 8,725,221
183% ;
$ 7,281,106 153% ;
$2,514,949;
o� , `
31 �E SBudget to Actuals Report
LC-
Health Services - Admin - Fund 274
FY20 YTD April 30, 2020 (unaudited)
83.3 %
Year Complete
Fiscal Year 2019
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Federal Grants
108,940
303,065 278%
726,655
592,762 82%
711,314 98%
(15,341); A
Interest on Investments
135,000
218,767 162%
171,000
203,169 119%
243,803 143%
72,803, B
Other
9,000
16,192 180%
9,000
8,546 95%
10,255 114%
1,255
CCBHC Grant
946,400
876,190 93%
-
-
TOTALRESOURCES
1,199,340
1,414,215 118% ;
906,655
804,477 89% ;
965,372 106% ;
58,717;
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
5,067,132
4,946,052 98%
5,241,264
4,045,259
77%
4,939,190
94%
302,074, C
Materials and Services
4,600,091
4,688,516 102%
4,971,179
3,934,886
79%
4,929,385
99%
41,794 D
Capital Outlay
5,000
- 0%
5,000
-
0%
0%
5,000
Administration Allocation
(8,327,487)
(8,295,196) 100% _
(9,308,295)
(7,755,000)
83%
(9,317,873)
100%;
91578
TOTAL REQUIREMENTS
1,344,736
1,339,372 100% ;
909,148
225,144
25% ;
550,702
61% ;
358,446;
TRANSFERS
Budget Actuals % Budget
Actuals
%
Projection % $ Variance
Transfers In- General Fund
40,000
33,328
83%
40,000 100%
Transfers Out
(188,688) (188,688) 100% f (193,326)
(144,993)
75%
(193,326) 100%
TOTALTRANSFERS
(188,688) (188,688) 100% ; (153,326)
(111,665)
73%
(153,326) 100% ;
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Beginning Fund Balance
2,642,514
2,862,108 108%
2,660,832
2,748,263 103%
2,748,263 103%
87,431
Resources over Requirements
(145,396)
74,843
(2,493)
579,333
414,670
417,163
Net Transfers - In (Out)
(188,688)
(188,688)
(153,326)
(111,665)
(153,326)
TOTAL FUND BALANCE
$ 2,308,430
$ 2,748,263 119% ;
$ 2,505,013
$ 3,215,931 128% ;
$ 3,009,607 120% ;
$504,594:
A Federal grants are reimbursed on a quarterly basis
B Interest projection based on current investment rate and anticipated cash balances
C Projected Personnel savings based on YTD Personnel expenditures
D $86K projected to be expended on Crisis Stabilization Center costs over budget as well as $9K for May & June operating costs
�IES`v.� Budget to Actuals Report
Health Services - Behavioral Health - Fund 274
83.3%
FY20 YTD April 30, 2020 (unaudited)
Year Complete
Fiscal Year 2019 Fiscal Year 2020
RESOURCES Budget Actuals % Budget Actuals % Projection % $ Variance
State Grant
10,187,361
9,796,391 96%
11,203,914
8,548,195
7U%
%728,551 W% (1,4/5,3b3); A
OHP Capitation
8,652,200
8,142,094 94%
7,242,430
5,852,348
81%
7,887,425 109%
644,995 B
Title 19
1,345,100
3,069,162 228%
4,862,726
3,315,801
68%
4,000,821 82%
(861,905); C
Federal Grants E
499,249
639,680 128%
2,168,961
1,333,272
61%
1,570,262 72%
(598,699); D
Local Grants E
412,987
424,012 103%
994,331
419,053
42%
852,687 86%
(141,644); G
Patient Fees E
236,500
515,196 218%
443,450
410,390
93%
488,666 110% t
45,216 E
State Miscellaneous !
351,200
995,622 283%
437,100
904
0%
774,057 177%
336,957! F
Other !
334,545
346,812 104%
395,352
303,909
77%
416,466 105%
21,114
Divorce Filing Fees
157,603
157,603 100%
173,030
173,030
100%
173,030 100%
Liquor Revenue
151,000
166,372 110%
150,800
110,392
73%
127,292 84%
(23,508);
State - OMAP E
131,900
270,591 205%
131,900
153,629
116%
183,759 139%
51,8%
Interfund Contract- Gen Fund !
127,000
127,000 100%
127,000
127,000
100%
127,000 100%
CCBHC Grant
4,381,400
3,929,191 90%
-
-
-
TOTALRESOURCES
26,968,045
28,579,727 106% ;
28,330,994
20,747,923
73%
26,330,016 93% ; (2,000,978);
REQUIREMENTS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Administration Allocation
6,253,121
6,248,556 100% ;
6,978,412
5,814,100
83%
6,981,611 100% ;
(3,199);
Personnel Services
19,172,838
17,819,840 93%
20,174,804
16,233,338
80%
19,911,386 99%
263,418, H
Materials and Services
6,509,514
5,549,421 85%
6,889,404
2,569,612
37%
4,527,965 66%
2,361,439! 1
Capital Outlay
234,000
199,979 85%
690,000
-
0%
947,370 137%
(257,370) J
TOTAL REQUIREMENTS
32,169,473
29,817,796 93% ;
34,732,620
24,617,050
71% ;
32,368,332 93% ;
2,364,288:
TRANSFERS
Budget Actuals %
Budget
Actuals %
Projection % $ Variance
Transfers In- General Fund
2,282,708 2,282,580 100%
1,734,107
1,445,075 83%
1,734,107 100% -
Transfers In- OHP Mental Health
-
548,601
0%
732,156 133% 183,555! K
TOTALTRANSFERS
2,282,708 2,282,580 100% ;
2,282,708
1,445,075 63% ;
2,466,263 108% ; 183,555:
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Beginning Fund Balance
3,976,398
5,628,746 142%
6,122,347
6,673,256 109%
6,673,256 109%
550,909:
Resources over Requirements
(5,201,428)
(1,238,069)
(6,401,626)
(3,869,127)
(6,038,316)
363,310!
Net Transfers - In (Out)
!
2,282,708
2,282,580
E
2,282,708
1,445,075 !
f l
2,466,263
t
183,555
4
TOTAL FUND BALANCE
$ 1,057,678
$ 6,673,256 631% ;
$ 2,003,429
$ 4,249,205 212% ;
$ 3,101,203 155% ; $1,097,774:
A Budgeted funds was a pass -through from the Behavioral Health State IGA for residential treatment provides, which will be paid directly during an 18
-month contract.
B The calendar year 2020 PacificSource contract went into effect February 1, 2020, and an estimated additional $255,000 is expected to be received
during FY20
C There is less in Title 19 fees collected relative to budgeted expectations.
D CCBHC Expansion was originally budgeted in the "CCBHC funding line; however, the grant through the US Department of Health and Human
Services is a traditional grant and more appropriately placed in the "Federal Grants" line. A revised budget corrects this amount. Any continuation of
CCBHC through the state will come through as a "CCBHC Grant' line item.
E There is an uptick in patient insurance fees collected relative to budgeted expectations.
F Projection increased to be reflective of estimated Intellectual and Developmental Disabilities (I/DD) FY20 match amounts; actuals occur at year end
G Central Oregon Health Council awarded DCHS $581,431 in one-time funds to expand hours at the Stabilization Center. The Stabilization Center has
experienced a delay in opening due to COVID-19, and the funds will be awarded as of July 1, 2020. Funds are budgeted in FY20, yet have been
removed from the projections. Local Grants also includes an early release of quality improvement measure funds through COHC.
H Projected Personnel savings based on YTD Personnel expenditures
I Reduction in Materials and Services primarily related to footnote A
i Projected expenditures include DCHS contribution of $500,000 toward a North County Facility
K Transfer of Mental Health Reserve funds include transfer to offset service element funds as part of participation in CCBHC Continuation through the
State.
\31 ES`� Budget to Actuals Report
{ Health Services - Public Health - Fund 274
FY20 YTD April 30, 2020 (unaudited)
RESOURCES
State Grant
Environmental Health Fees
State - OMAP
State Miscellaneous
Local Grants
Federal Grants
Vital Records
Patient Fees
State Shared- Family Planning
Other
TOTALRESOURCES
83.3%
Year Complete
Fiscal Year 2019
Fiscal Year 2020
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
3,074,983
3,257,457 106%
2,876,730
2,465,577
86%
3,274,821 114%,
398,091 A
1,169,600
1,076,036 92%
1,058,206
1,042,579
99%
1,082,798 102%
24,592! B
1,015,268
838,031 83%
860,000
565,622
66%
673,143 78%
(186,857)
E 548,534
812,677 148%
603,053
427,555
71%
732,444 121% ,
129,391� C
795,636
601,497 76%
573,000
997,000
174%
997,214 174%
424,214 D
382,000
368,821 97%
382,000
238,398
62%
451,949 118%
69,949!
212,000
241,727 114%
220,000
211,837
96%
250,036 114%
30,036!
-
122,714
121,300
118,462
98%
125,587 104%
4,287
168,007
120,000
167,826
140%
175,144 146%
55,144!
79,048
114,830 145%
80,360
104,023 129%
115,624 144% !
35,264!
7,2772069
7,601,797 104% ;
6,894,649
6,338,880
92% ;
7,878,760 114% ;
984,111:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Administration Allocation
2,074,366
2,046,640
99%
2,329,883
1,940,900
83%
2,336,262 100%
(6,379);
Personnel Services
7,462,095
7,014,365
94%
7,770,762
6,305,717
81%
7,492,588 96%
278,174 E
Materials and Services I
i
1,923,694
2,217,165
115%
1,846,896
1,359,585
74%
I(
2,069,183 112% t
I
(222,287)� F
t
Capital Outlay
-
6,051
I
999%
-
-
TOTAL REQUIREMENTS ;
11,460,155
11,284,222
98% ;
11,947,541
9,606,202
80% ; ;
11,898,033 100% ;
49,508;
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers In- General Fund
4,083,515
4,085,312 100%
3,972,983
3,3109821
83%
3,972,983 100%
TOTALTRANSFERS
4,083,515
4,085,312 100% ;
3,972,983
3,310,821
83% ;
3,972,983 100% ;
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
Beginning Fund Balance
583,802
813,698 139%
1,337,624
1,216,586 91%
1,216,586 91%
(121,038);
Resources over Requirements
(4,183,086)
(3,682,425)
i
(5,052,892)
(3,267,322)
f l
(4,019,273)
t
1,033,619
I
1
Net Transfers - In (Out)
4,083,515
4,085,312
3,972,983
3,310,821
3,972,983
TOTAL FUND BALANCE
$ 484,231
$ 1,216,586 251% ;
$ 257,715
$ 1,260,085 489% ;
$ 1,170,296 454% ;
$912,581:
A Public Health State IGA increased funds for Regional and Local Public Health Modernization, as well as increased funds in Communicable Disease
and Emergency Preparedness to assist with COVID-19 community response.
B Fees were budgeted at an increase of 3%, but were adopted at an 8.5% rate increase
C Payments are reimbursed on a quarterly basis, and include the Medicaid Administrative Claims payment for which is currently outstanding
D Funds include the Diabetes Prevention Program, which was awarded for the calendar year 2020 as well as an early release of quality improvement
measure funds through COHC.
E Projected Personnel savings based on YTD Personnel expenditures
F Additional expenditures are related to notes A and D.
S Budget to Actuals Report
50- Community Development - Fund 295
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year2019
1
Fiscal Year 2020
RESOURCES
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Admin - Operations
114,500
152,827
133%
162,000
110,806
68%
138,000
85%
(24,000); A
Code Enforcement
! 664,291
635,453
96%
693,960
540,506
78%
656,310
95%
(37,650); B
Building Safety
3,312,714
3,075,409
93%
3,433,780
2,618,606
76%
3,219,292
94%
(214,488), B
Electrical
! 804,849
738,580
92%
809,500
639,725
79%
726,401
90%
(83,099)1 B
Environmental On -Site
782,984
819,608
105% ;
877,400
748,088
85%
891,100
102%
13,700
Current Planning
1,795,453
1,701,840
95%
1,807,176
1,400,106
77%
1,647,796
91%
(159,380); C
Long Range Planning
! 678,955
632,170
93%
685,004
543,219
79%
664,382
97%
(20,622) D
TOTALRESOURCES
8,153,746
7,755,886
95%
8,468,820
6,601,057
78%
7,943,281
94% ;
(525,539);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Admin - Operations
2,477,738
2,386,276
96%
2,492,316
2,104,102
84%
2,460,143
99%
32,173, E
Code Enforcement
456,162
445,254
98%
535,590
385,806
72% !
463,535
87%
72,055! E
Building Safety
1,676,037
1,565,140
93%
1,743,298
1,309,777
75%
1,605,951
92%
137,348! F
Electrical
445,433
439,104
99%
462,183
373,477
81%
450,387
97%
11,796 F
Environmental On -Site
612,596
547,203
89%
616,279
472,638
77%
558,922
91%
57,357! F
Current Planning
1,554,847
1,456,128
94%
1,501,588
1,185,846
79%
1,434,835
96%
66,753! F
Long Range Planning
503,344
492,687
98%
554,385
388,357
70%
464,933
84%
89,452, G
TOTAL REQUIREMENTS ;
7,726,157
7,331,793
95% ;
7,905,639
6,220,005
79%
7,438,705
94%
466,934:
TRANSFERS Budget Actuals % Budget Actuals % Projection % $ Variance
Transfers In - General Fund
300,000
289,193
96%
100,000
75,000
75%
100,000 100%
Transfers Out
E (79,945)
(79,945)
100%
(85,695)
(64,266)
75%
(85,696) 100% (1)
Transfers Out - CDD Reserve
E (1,372,679)
(1,379,420)
100%
(1,462,386)
(1,074,401)
73%
(1,103,450) 75% 358,93&
TOTALTRANSFERS
; (1,152,624)
(1,170,172)
102% ;
(1,448,081)
(1,063,667)
73% ;
(1,089,146) 75% 358,935:
FUND BALANCE
Budget
Actuals %
Budget
Actuais %
Projection %
$ Variance
Beginning Fund Balance
2,203,711
2,529,615 115%
1,982,004
1,783,536 90%
1,783,536 90%
(198,468):
Resources over Requirements
427,589
424,093
563,181
381,052 4
504,576
(58,605);
Net Transfers - In (Out)
(
(1,152,624)
(1,170,172)
t
(1,448,081)
(1,063,667)
! k
(1,089,146)
1
358,935;
E
TOTALFUND BALANCE
$ 1,478,676
$ 1,783,536 121% ;
$ 1,097,104
$ 1,100,921 100% ; ;
$ 1,198,965 109% ;
$101,861:
Note: Requirements projection decreased across divisions to reflect credits from the PERS Reserve Fund
A Interest projection based on current investment rate and anticipated cash balances
B Projection revised to reflect 10% reduction in permit activity and building valuation April - June 2020 due to COVID
C Change in accounting procedure for hearing officer deposits, which are held as a liability instead of recognized as revenue. Projection revised to
reflect 30% reduction in application activity April - June 2020 due to COVID.
D Projection revised to reflect 10% reduction in building valuation April - June 2020 due to COVID
E Projection reflects unfilled FTEs and reduced Materials and Services and increased to include unbudgeted health benefits trust
F Projection reflects unfilled FTEs and reduced Materials and Services
G Projection increased due to time management leave payout; also reflects unfilled FTEs and reduced Materials and Services
w� �I ES Budget to Actuals Report
Road - Fund 325
FY20 YTD April 30, 2020 (unaudited)
RESOURCES
Motor Vehicle Revenue
Federal - PILT Payment
Other Inter -fund Services
Forest Receipts
Cities-Bend/Red/Sis/La Pine
Sale of Equip & Material
Interest on Investments
Federal Reimbursements
Mineral Lease Royalties
Miscellaneous
State Miscellaneous
Assessment Payments (P&I)
TOTALRESOURCES
83.3%
Year Complete
Fiscal Year 2019
Fiscal Year 2020
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
16,234,849
16,726,428
103%
17,609,539
14,335,525
81%
16,046,756 91%
(1,562,783): A
1,900,000
2,153,308
113%
1,510,450
2,310,002
153% .
2,310,002 153% ,
799,552, B
1,044,353
1,096,023
105%
1,156,581
250,870
22%
1,095,581 95%
(61,000): C
963,410
801,125
83%
915,000
768,191
84%
768,191 84%
(146,809)1 D
635,000
400,849
63%
660,000
153,780
23%
404,553 61%
(255,447); E
365,000
327,920
90%
358,000
217,317
61%
349,835 98%
(8,165)
150,000
220,062
147% ,
246,000
154,304
63%
187,000 76%
(59,000); F
544,000
363,910
67%
181,757
363,514
200%
363,514 200%
181,757, G
175,000
69,422
40%
60,000
51,925
87%
60,000 100%!
-
45,000
118,699
264%
57,500
67,401
117%
79,000 137%
21,500! H
739,811
735,114
99%
20,000
9,844
49%
34,325 172%
14,325! 1
80,000
22,350
28%
11,000
7,531
68%
11,000 100%
22,876,423
23,035,209 101% ;
22,785,827
18,690,205
82%
21,709,757 95% ; (1,076,070);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
6,595,561 6,246,351 95%
6,447,671
5,225,933
81%
6,278,748
97%
168,921 J
Materials and Services
8,094,192 5,912,553 73%
8,092,165
4,431,633
55%
7,517,930
93%
574,235! K
Capital Outlay
- -
33,500
27,706
83%
32,416
97%
1,084: L
TOTAL REQUIREMENTS ;
14,689,753 12,158,904 83%
14,573,336
9,685,273
66% ;
13,829,094
95%
744,242:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers Out
(14,464,308)
(14,464,308) 100%
(11,910,575)
(6,612,088)
56%
(11,910,575) 100%
TOTALTRANSFERS
; (14,464,308)
(14,464,308) 100% ;
(11,910,575)
(6,612,088)
56%
(11,910,575) 100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance
8,693,653
10,314,842 119%
6,001,989
6,726,840 112% <
6,726,840 112% 724,851
Resources over Requirements
8,186,670
10,876,306
8,212,491
9,004,932
7,880,663 (331,828);
Net Transfers - In (Out)
(14,464,308)
F
(14,464,308)
t
(11,910,575)
(6,612,088)
F 6
(11,910,575)
! 4
TOTAL FUND BALANCE
$ 2,416,014
$ 6,726,840 278% ;
$ 2,303,905
$ 9,119,684 396% ; ;
$ 2,696,928 117% ; $393,023:
A Preliminary projections based on COVID
B PILT payment received in July. Exceeded amounts as budgeted due to a decrease in Timber revenue.
C Decrease in vehicle repair revenue due to new vehicles in the fleet
D Revised projection based on federal legislation and projections from AOC
E Contracted work for City of Redmond will be completed in FY 21 instead of FY 20
F Interest projection based on current investment rate and anticipated cash balances
G A two-year federal project was completed in one year, so full amount of reimbursement was requested in year one.
H Restitution receipts are higher than anticipated
I Updated based on actual receipts
j Projected Personnel savings based on YTD average vacancy rate of 2.0%
K Contracted road services and on -call engineering anticipated to be less than budgeted due to lack of snow and emergency work. Aggregate &
Asphalt anticipated to be less than budgeted due to City of Redmond work being pushed to FY 21. Includes projection for an interfund payment to
Fair & Expo for 5.0 FTE for May and June.
L Updated based on revised estimate
o TES ` 2� Budget to Actuals Report
Adult P&P - Fund 355
FY20 YTD April 30, 2020 (unaudited)
RESOURCES
DOC Grant in Aid SB 1145
CJC Justice Reinvestment
DOC Measure 57
Probation Supervision Fees
DOC-Family Sentence Alt
Interest on Investments
Interfund- Sheriff
Gen Fund/Crime Prevention
State Subsidy
Probation Work Crew Fees
Electronic Monitoring Fee
Miscellaneous
Oregon BOPPPS
State Miscellaneous
TOTALRESOURCES
83.3 %
Year Complete
Fiscal Year 2019 1
Fiscal Year 2020
Budget
Actuals %
Budget
Actuals %
Projection %
$ Variance
4,781,604
4,781,604 100%,
4,353,626
4,621,782 106%
4,621,782 106%,
268,156: A
t 844,831
853,831 101%
712,530
1,061,670 149% _
1,061,670 149% ,
349,140, B
t 233,900
233,900 100% ;
236,142
239,005 101% <
239,005 101%
2,863. A
t 210,000
191,536 91%
160,000
152,165 95%
165,000 103% ,
5,000� C
114,683
114,683 100% ;
114,682
223,746 195%
223,746 195%
109,064, D
t 40,000
77,778 194%
77,500
55,383 71%
67,150 87%
(10,350)l E
t 50,000
51,034 102%
50,000
45,833 92% E
50,000 100%
t 50,000
50,000 100%
50,000
37,500 75%
50,000 100%
t 17,000
16,337 96%
16,298
16,703 102%
16,703 102%
405!
4,000
2,800 70%
2,000
1,843 92%
2,000 100%
10,000
84,165 842% '
2,000
19,500 975% ,
21,000 999% '
19,000, F
t 500
6,102 999%
500
13,515 999% E
13,515 999%:
13,016 G
-
-
40,933
40,934
40,934 H
4,300
- 0%
-
-
6,360,818
6,463,769 102% ;
5,775,278
6,529,578 113% ; ;
6,572,505 114% ;
797,227:
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Personnel Services
4,656,363
4,522,266
97%
4,809,644
3,949,544
82%
4,769,078
99%
40,566: 1
Materials and Services
1,828,765
1,686,408
92%
1,764,847
1,325,827
75%
1,756,120
100% -
8,727, J
Capital Outlay
20,000
-
0%
15,000
10,000
67%
10,000
67% '
5,000� K
TOTAL REQUIREMENTS
6,505,128
6,208,673
95%
6,589,491
5,285,371
80% ; ;
6,535,198
99%
54,293:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Transfers In- General Funds
285,189
285,189 100%
285,189
237,650
83%
285,189 100% -'
Transfer to Vehicle Maint
(120,000)
(120,000) 100%
(62,000)
(46,500)
75% '
(62,000) 100%
TOTALTRANSFERS
165,189
165,189 100% ;
223,189
191,150
86% ;
223,189 100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance
2,200,000
2,333,720 106%
2,590,000
2,754,005 106% '
2,754,005 106% ' 164,005'
Resources over Requirements
(144,310)
255,096
(814,213)
1,244,207
37,307 851,520
Net Transfers - In (Out)
165,189
165,189
223,189
191,150
223,189
t
(
E €
! E
TOTAL FUND BALANCE
$ 2,220,879
$ 2,754,005 124% ;
$ 1,998,976
$ 4,189,362 210% ; ;
$ 3,014,501 151% ; $1,015,525:
A State Dept. of Corrections and Criminal Justice Commission received more funding for dispersal than anticipated at time of budgeting
B State Criminal Justice Commission received more funding for dispersal than anticipated at time of budgeting incl. supplemental grant funding
C Projection based on YTD actuals and anticipated COVID related impact on client ability to pay fees
D State Dept. of Corrections under allocated resources at the time of budgeting
E Interest projection based on current investment rate and anticipated cash balances
F Revenue from prior pretrial EM clients more than anticipated at time of budgeting due to account close-out offer in June -Aug 2019 and Dept.
Revenue fees from closed/previous accounts.
G Revenue includes miscellaneous refunds, staff uniform overage fees and payment from participants attending a Nov 2019/March 2020 training
event hosted by Adult P&P
H State makes one payment per biennium to conduct hearings for sanctioned offenders. Received both FY19 and FY21 biennial payments in FY20.
I Projected Personnel savings based on YTD average vacancy rate of 1.6% less anticipated retirement vacation payouts
J Projection based on YTD actuals. Higher than anticipated pass -through grant contributions (JRI), and emergency and transitional housing costs
including COVID related impacts.
K Projection based on YTD actuals. DCSO auction vehicle was less expensive than budgeted.
TES` 2{ Oe,
Budget to Actuals Report
Road CIP - Fund 465
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019
1
Fiscal Year 2020
RESOURCES
Budget Actuals
%
Budget
Actuals %
Projection %
$ Variance
State Miscellaneous
853,104
0%
1,944,893
1,058,217 54%
1,777,052 91%
(167,841); A
Interest on Investments
106,000 261,131
246%
198,000
313,665 158%
360,000 182%
162,000, B
Interfund Payment
- -
111,560
111,560
111,560 C
TOTALRESOURCES
959,104 261,131
27%
2,142,893
1,483,442 69%
2,248,612 105% ;
105,719;
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Materials and Services
73,153
73,153
100%
71,748
59,790
83%
71,748
100%
Capital Outlay
8,236,348
5,411,213
66%
13,764,165
4,519,307
33%
7,175,099
52%
6,589,066! D
TOTAL REQUIREMENTS
8,309,501
5,484,366
66% ;
13,835,913
4,579,097
33% ;
7,246,847
52%
6,589,066:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
Transfers In
13,811,725
13,393,963
97%
12,014,914
5,298,487
44%
11,893,453
99%
(121,461), E
TOTALTRANSFERS
13,811,725
13,393,963
97%
12,0142914
5,298,487
44%
11,893,453
99%
(121,461),
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection
% $ Variance
Beginning Fund Balance
7,687,037
9,588,827 125%
15,616,536
17,759,555 114%
17,759,555
114% 2,143,0%
Resources over Requirements
(7,350,397)
(5,223,236)
(11,693,020)
(3,095,655)
(4,998,235)
6,694,785
Net Transfers - In (Out)
13,811,725
13,393,963
12,014,914
5,298,487
112893,453
(121,461)
E
TOTAL FUND BALANCE
$ 14,148,365
$ 17,759,555 126% ; $ 15,938,430
$ 19,962,387 125% ; $ 24,654,773
155% ; $8,716,343:
A Updated based on reimbursable projects planned to be completed this fiscal year
B Interest projection based on current investment rate and anticipated cash balances
C Unbudgeted revenue to offset expenses for Spring River Road Improvements
D Variance due to unanticipated project delays projected to advance FY 20 budgeted CIP project costs into FY 21, including $5M for US 97 Bend
North Corridor project
E Revised estimate based on SDC eligible projects anticipated to be completed in fiscal year
Budget to Actuals Report
Road CIP (Fund 465) - Capital Outlay Summary by Project 83.3%
FY20 YTD April 30, 2020 (unaudited) Year Completed
Fiscal Year 2019
1
Fiscal Year 2020
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
Burgess Road Day Road Inter. i
900,106
658,203
73%
Deschutes Market Dale Road Inter.
1,500,000
1,285,822
86%
Erickson Road Paving
468,544
Old Bend Redmond Highway Phase 11
3rd Street Drainage Extension
300,000
112,655
38%
US 20 at Tumalo
300,000
1,100,000
367%4
300,000
0%
0%
300,000
Paving Knott Rd
850,286
495,978
58%
S. Canal Helmholtz Way
714,937
141,751
20%
800,000
717,683
90%
642,226 80%
157,774-
S. Canal - "Six" Corners
798,699
537,724
67% i
900,000
1,007,258
112%-
I 1,007,432 112%:
(107,432)'
Six Corners Irrigation
Tumalo Road / Tumalo Place
406,879
49,123
12% 1
769,521
104,236
14%
389,788 51%
379,733;
Quail Road Improvements
100,000
100,000
100%!
La Pine Guardrail Repair
40,099
C Avenue: Hwy 97 to 6th St Impry
180,746
35,351
20% 1
300,000
369,705
123% 1
1 369,705 123%1
(69,705)
Solar Drive Bridge
1 60,000
70,334
44%
Old Bend Rdm/Tumalo Rd Inter i
346,426
50,355
15% 1
625,642
97,163
16% 1
772,150 123% 1
(146,508)-
Sisemore Bridge
220,000
100,596
46% i
632,174
106,042
17%
675,503 107%
(439329)-
Spring River Bridge Parking Imp
163,776
12,122
12,122
(12,122)t
NE Negus and 17TH
360,000
221
0% 1
1,025,472
31,176
3%
180,000 18% 1
845,472
Paving Ward Road
339,810
681
0%
598,269
715,504
120%!;
715,504 120%!
(117,235)
Hunnel Rd: Loco Rd to Tumalo Rd
275,000
33,918
12%
75,000 27%
200,000
Cascade Lakes Hwy Bike Facilities
39,856
11,856
30%
11,856 30%
28,000,
Fyrear Rd US 20 to Stevens
300,000
-
0% c
!
300,000 100%
Alfalfa Mkt Rd: Powell Butte Hwy
300,000
809,018
270% 1
450,000 150%1
(150,000).
Bend District Local Roads
558,459
0%
City of LaPine Local Roads
500,000
0%
0%
500,000-
US 97 Bend North Corridor
5,000,000
0%
0%
5,000,000_
Tumalo Res Rd: OB Riley to Bailey Rd
247,342
0%
0% 1
Z
247,342
US 20 Ward Rd to Hamby
500,000
500,000
100%1
500,000 100% 1
Transportation System Plan Update
250,000
253
0%
80,000 32% 1
170,000-
Gribbling Rd Bridge
60,000
0%
30,000 50%
30,000
Slurry Seal 2020
675
300,000
(300,000)
Paving of S. Century Dr
2,265
484,813
(484,813)-
Sisemore Rd Canal Piping
Terrebonne Wastewater Feasibility St.
217
50,000
(50,000)s
Signage Improvements
100,000
0%
60,144
0%
28,000 47% 1
32,1144
Guardrail Improvements
100,000
0% 1
100,000
0%
100,000 100%!
ARTS Project
180,746
0%
0%
180,74& -
Rickard Rd: Groff Rd to US 20
217
1,000
(1,000)=
TOTAL CAPITAL OUTLAY
$8,236,348
$ 5,411,213
66%1
$ 13,764,165
4,519,307
33%i
1 $7,175, 99 52%1 $ 6,590,066€
o� Budget to Actuals Report
E , o�
Solid Waste - Fund 610
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019
1
Fiscal Year 2020
RESOURCES
Budget
Actuals
%
Budget
Actuals %
Projection %
$ Variance
Franchise Disposal Fees
6,497,676
6,356,636
98%
6,437,500
5,099,571 79%
6,437,500 100%
A
Private Disposal Fees
2,709,370
2,379,061
88%
2,419,046
1,981,604 82%
2,419,046 100%
Commercial Disp. Fee
2,042,050
2,060,523
101%
2,252,225
1,962,321 87%
2,252,225 100%
Franchise 3% Fees
265,000
291,340
110%
265,000
288,328 109% ,
296,328 112%
31,328! B
Yard Debris
216,761
268,830
124%
216,761
231,630 107%
271,780 125% ,
55,0% C
Interest
44,000
58,235
132%
59,000
39,653 67%
47,000 80%
(12,000)l D
Miscellaneous
49,955
57,067
114%
48,336
157,688 326%
161,140 333% ,
112,804 E
Special Waste
15,000
21,487
143%
15,000
24,125 161%
25,000 167% ,
10,000, F
Recyclables
18,000
11,063
61%
12,000
9,522 79%
12,000 100%
Leases
i
10,801
1
0%
1
- 0%
1 100%
TOTALRESOURCES
11,868,613
11,504,244
97%
11,724,869
9,794,442 84%
11,922,020 102% ;
197,151:
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
2,504,623
2,331,135
93%
2,538,776
1,973,855
78%
2,389,303
94%
149,473, G
Materials and Services
4,772,159
4,341,881
91%
4,927,163
2,979,902
60%
4,842,710
98%
84,453, H
Capital Outlay
173,000
109,681
63%
56,000
11,724
21%
11,724
21%
44,276! 1
Debt Service
860,938
860,937 100% ;
862,100
309,595
36%
862,100 100%
J
TOTAL REQUIREMENTS
8,310,720
7,643,635
92% ;
8,384,039
5,275,076
63%
8,105,837
97%
278,202;
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
SW Capital & Equipment
(4,688,023)
(5,000,029)
107%
(3,296,192)
(1,624,273)
49%
(3,296,192)
100%:
K
Reserve
TOTALTRANSFERS
(4,688,023)
(5,000,029)
107% ;
(3,296,192)
(1,624,273)
49% ;
(3,296,192)
100% ;
FUND BALANCE Budget Actuals % Budget Actuals % Projection % $ Variance
Beginning Fund Balance 1,730,130 1,938,991 112% 600,000 799,570 133% 799,570 133% 199,570:
i
Resources over Requirements 3,557,893 3,860,608 3,340,830 4,519,366 3,816,183 475,353!
Net Transfers - In (Out) (4,688,023) (5,000,029) f (3,296,192) (1,624,273) E (3,296,192) r
TOTAL FUND BALANCE $ 600,000 $ 799,570 133% ; $ 644,638 $ 3,694,663 573% ; ; $ 1,319,561 205% ; $674,923;
A Payment of $325K Republic Services (Bend Garbage & Recycling and High Country Disposal) for the month of April was not received by month -end
close
B Received the annual fees due April 15, 2020; projecting the remaining Wilderness Garbage in monthly installments
C Revenue is seasonal with higher utilization in the summer months; historically high month in April anticipated to be offset by extended Fire Free
event in May
D Interest projection based on current investment rate and anticipated cash balances
E Includes an unbudgeted sale of loader 7-279 for $95K, CEC LED light incentive and Taylor NW royalty payments
F Revenue source is unpredictable and dependent on special clean-up projects; April had large contaminated soil and asbestos projects
G Projected Personnel savings based on YTD average vacancy rate of 4.9%
H Projecting to be slightly less than budget; the waste characterization study and seasonal items such as mulching from the Fire Free events and bird
control are anticipated later this fiscal year
I FY19 extended the life of an existing vehicle and did not purchase a second pick-up; FY20 purchased the budgeted gas monitoring equipment and
moved the fencing project to FY21
j Principal and interest payments due in Nov and May
K Quarterly reserve transfer on hold to evaluate potential economic changes
o ` �j Budget to Actuals Report
o
Fair & Expo - Fund 615
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019 1
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
Events Revenue
655,000
615,300 94%
687,000
369,222
54%
370,000
54%
(317,000): A
Food & Beverage
540,000
629,875 117%
568,000
282,071
50%
283,000
50%
(285,000); B
Rights & Signage
105,000
115,650 110%
120,000
84,100
70%
87,000
73%
(33,000)�
Storage
83,100
76,735 92%
71,000
53,938
76%
68,000
96%
(3,000); C
Horse Stall Rental
57,000
71,855 126%
62,000
37,296
60%
37,296
60%
(24,704)
Interfund Payment
30,000
54,573 182%
30,000
34,279
114%
149,192 497% ,
119,192 D
Camping Fee
18,200
19,975 110%
18,000
5,600
31%
6,000
33%
(12,000)
Miscellaneous
k 8,400
6,374 76%
3,500
2,236
64%
4,500 129%
1,000
Interest
2,400
(518) -22%
r
2,000
(3,694) -185%
(4,200) -210%
(6,200)
TOTALRESOURCES
1,499,100
1,589,820 106% ;
1,561,500
865,050
55% ;
1,000,788
64%
(560,712);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Personnel Services
1,248,512
1,259,337
101%
1,176,169
946,940
81%
1,123,396 96% �
52,773, E
Personnel Services - F&B k
149,296
149,947
100%
157,430
132,774
84%
157,430 100%!
F
Materials and Services k
967,441
912,724
94%
795,788
673,905
85%
740,143 93%
55,645 G
Materials and Services - F&B k
222,500
365,951
164%
234,600
216,471
92%
217,000 92%
17,6W B
Debt Service
101,136
101,136
100%
100,800
55,290
55%
100,800 100%
e
TOTAL REQUIREMENTS ;
2,688,885
2,789,095
104% ;
2,464,787
2,025,379
82%
2,338,769 95% ;
126,018;
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Transfers In - Room Tax
517,996
517,996 100%
409,654
309,381
76%
358,139 87%
(51,515); H
i
Transfers In - County Fair
472,998
417,000 88%
395,000
250,000
63%
250,000 63%
(145,000); 1
Transfers In - General Fund k
200,000
200,000 100%
200,000
166,660
83%
200,000 100%
Transfers In - Park Fund
30,000
30,000 100%
30,000
22,500
75%
30,000 100%
Transfers Out
-
-
(11,791)
(8,841)
75%
(11,791) 100%
TOTALTRANSFERS
1,220,994
1,164,996 95%
1,022,863
739,700
72% ;
826,348 81%
(196,515);
FUND BALANCE
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Beginning Fund Balance
-
(60,285) 999%
80,000
(94,564)
-118%;
(94,564) -118%;
(174,564); J
Resources over Requirements
(1,189,785)
(1,199,275)
(903,287)
(1,160,330)
(1,337,981)
(434,694)
Net Transfers - In (Out)
k
1,220,994
1,164,996
k
1,022,863
739,700
I k
826,348
i
(196,515)
E
TOTAL FUND BALANCE
$ 31,209
($ 94,564) -303%;
$ 199,576
($ 515,194) -258%;
($ 606,197) -304%;
($805,773);
A Current year receipts are 54% of budget YTD; prior year receipts were 73% of budget at this point last year. All March, April and May events
cancelled due to COVID. June events impacted.
B Net earnings from F&B activities YTD are $(67,175). Monthly fixed costs have a greater impact on earnings during off-season months. All March,
April and most May events cancelled due to COVID. June events impacted.
c Allowing storage to continue additional months due to event cancellations.
D Reimbursement from RV Park for personnel expenditures recorded in F&E. Includes interfund payment for 7.0 FTE whose cost is being absorbed
by Roads (5.0 FTE), Sheriffs Office (1.0 FTE) and BOCC (1.00 FTE).
E Projected Personnel savings based on YTD average vacancy rate of 6.6% and reduction in some staff hours
F Net earnings from F&B activities YTD are $(67,175). Monthly fixed costs have a greater impact on earnings during off-season months.
G Projected to be lower than budget based on April -June event cancellations.
H Projected to be lower than budget based on COVA's estimates for TRT revenue for the remainder of FY20
I Net proceeds from the County Fair are recorded in a separate fund and transferred in at year-end (Final estimate of $250k)
j Prior year losses, relative to budget, are compounded into the beginning working capital to start the fiscal year.
p� �'VES� Budget to Actuals Report
RV Park - Fund 618
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019
1
Fiscal Year 2020
RESOURCES
Budget
Actuals
%
Budget
Actuals
%
Projection %
$ Variance
RV Park Fees < 31 Days
340,200
458,331
135%
405,200
323,572
80%
358,652 89%
(46,548); A
Interest on Investments
4,400
12,255
279%
12,000
9,713
81%
13,000 108%
1,000� B
Cancellation Fees
4,000
12,497
312%
5,000
4,891
98%
5,781 116% ,
781
RV Park Fees > 30 Days
5,000
11,600
232%
5,000
13,050
261%
13,050 261% !
8,050!
Washer/Dryer
3,500
4,650
133%
4,000
4,642
116%
5,447 136%
1,447
Vending Machines
1,500
1,716
114%
3,000
1,653
55%
2,059 69%
(941)
Miscellaneous
2,231
2,000
1,796
90%
2,417 121% ,
417
Good Sam Membership Fee
2,561
1,500
351
23%
351 23%
(1,149); C
Good Sam Discounts
,
(17,220)
999%
t
-
(7,109)
999%
(7,109) 999% :
(7,109); C
TOTALRESOURCES
358,600
488,620
136% ;
437,700
352,558
81%
393,648 90%
(44,052);
REQUIREMENTS Budget Actuals % Budget Actuals % Projection % $ Variance
Materials and Services
298,870
276,007
92%
318,273
222,663
70%
272,876 86% 45,397;
Debt Service
223,101
223,101
100%
222,100
161,528
73%
222,100 100%
TOTAL REQUIREMENTS ;
521,971
499,108
96% ;
540,373
384,191
71% ;
494,976 92% 45,397:
TRANSFERS
Budget
Actuals
%
Budget
Actuals
%
Projection % $ Variance
Transfers In - Park Fund
160,000
160,000
100%
160,000
160,000
100%
160,000 100%
Transfers In - TRT Fund
35,000
26,250
75%
35,000 100%
Transfer Out - RV Reserve
F
(502,000)
(251,000)
50%
(502,000) 100%
TOTALTRANSFERS
160,000
160,000 100% ;
(307,000)
(64,750)
21% ;
(307,000) 100%
FUND BALANCE Budget Actuals %
Budget
Actuals %
Projection %
$ Variance
Beginning Fund Balance 319,000 443,480 139%
560,000
592,992 106%
592,992 106%
32,992:
Resources over Requirements (163,371) (10,488)
(102,673)
(31,632)
(101,328)
1,345,
Net Transfers - In (Out) 160,000 160,000
E
(307,000)
(64,750)
(307,000)
TOTAL FUND BALANCE $ 315,629 $ 592,992 188% ;
$ 150,327
$ 496,610 330% ; ;
$ 184,664 123% ;
$34,337:
A 9,618 RV spaces, 29.85% utilization YTD. Prior year comparable was
9,416 RV spaces, 29.22% utilization YTD; projection decreased due to
COVID.
B Interest projection based on current investment rate and anticipated cash balances
C The Good Sam incentive program was discontinued during Fall 2019.
usE s` Budget to Actuals Report
Risk Management - Fund 670
FY20 YTD April 30, 2020 (unaudited)
83.3%
Year Complete
Fiscal Year 2019 1
Fiscal Year 2020
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Workers' Compensation
1,247,279
1,273,816 102%
1,255,108
1,092,940
87%
1,255,108 100%,
General Liability
1,063,675
1,063,675 100% ;
1,072,326
879,572
82%
1,072,326 100%
Property Damage
394,291
394,291 100% ;
392,923
329,934
84%
392,923 100%
Unemployment
280,921
297,540 106%
323,572
299,142
92%
323,572 100%!
A
Vehicle
195,250
195,250 100% ;
195,580
1699171
86%
195,580 100%
Interest on Investments
85,000
148,890 175%
137,000
128,895
94%
157,000 115% !
20,000� B
Claims Reimbursement
269,198
57,073 21%
82,000
460,881
562%
461,000 562% ,
379,000, C
Skid Car Training
32,000
44,910 140%
34,000
34,740
102%
35,000 103%
1,000
Process Fee- Events/ Parades
1,800
1,575 88%
2,000
1,080
54%
1,100 55%
(900)
Miscellaneous
500
5 1%
500
5
1%
100 20%
(400);
Loss Prevention
30
30 100%,
30
0%
30 100%
-
TOTALRESOURCES
3,569,944
3,477,056 97% ;
3,495,039
3,396,359
97% ;
3,893,739 111%;
398,700:
REQUIREMENTS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Workers' Compensation
1,360,000
1,013,256 75%
1,460,000
604,103
41%
900,000 62%
560,00&
General Liability
900,000
633,248 70%
1,400,000
242,227
17%
600,000 43%
800,000! D
Insurance Administration
599,459
529,833 88%
592,059
394,020
67%
531,598 90%
60,461� E
Property Damage
728,638
548,796 75%
400,236
696,261
174%
900,000 225%
(499,764)! F
Vehicle
120,000
100,150 83%
150,000
106,596
71%
250,000 167%
(100,000),
Unemployment
1503000
37,481 25%
130,000
25,612
20%
90,000 69%
40,000, G
TOTAL REQUIREMENTS ;
3,858,097
2,862,764 74%
4,132,295
2,068,819
50% ;
3,271,598 79%
860,697:
TRANSFERS
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Transfers Out - Vehicle Replace
(3,168)
(3,168) 100%
(6,918)
(5,187)
75%
(6,918) 100%
TOTALTRANSFERS
(3,168)
(3,168) 100% ;
(6,918)
(5,187)
75% ;
(6,918) 100%:
FUND BALANCE
Budget
Actuals %
Budget
Actuals
%
Projection %
$ Variance
Beginning Fund Balance
5,600,000
6,582,283 118%
6,100,000
7,193,407
118%
73193,407 118%
1,093,407,
Resources over Requirements
(288,153)
614,292
(637,256)
1,327,541
622,141
1,259,39T
Net Transfers - In (Out)
d
(3,168)
(3,168)
I
(6,918)
(5,187)
k
f!
(6,918)
6
F
TOTAL FUND BALANCE
$ 5,308,679
$ 7,193,407 136% ;
$ 5,455,826
$ 8,515,761
156% ; ;
$ 7,808,630 143% ;
$2,352,804:
A Unemployment collected on first $25K of employee's salary in fiscal year
B Interest projection based on current investment
rate and anticipated cash balances
C Payment associated to repair of the Fair and Expo roof. Payment was expected last
fiscal year, but
received in
this fiscal year.
D Claims are difficult to project, but General Liability
claims are trending less than budget
E Part of projected Personnel savings based on
1.00 vacant FTE in July and August, which has been transferred to Administrative Services
F Majority of Fair/Expo roof replacement costs were expected in FY19,
but significant portion incurred in FY20.
G Fewer unemployment claims than anticipated.
,��lES Budget to Actuals Report
(�G
Health Benefits - Fund 675
FY20 YTD April 30, 2020 (unaudited)
83.3 %
Year Complete
Fiscal Year2019
Fiscal Year2020
RESOURCES
Budget
Actuals %
Budget
Actuals
%
Projection
%
$ Variance
Internal Premium Charges
17,054,563
18,051,440 106%
17,411,292
14,816,452
85%
17,816,452
102%
405,160�
COIC Premiums
11834,000
1,794,789 98%
1,967,021
1,267,225
64%
1,527,225
78%
(439,796)' A
Retiree / COBRA Premiums
1,280,000
1,144,088 89%
1,433,000
723,960
51%
868,752
61%
(564,248); B
Employee Co -Pay
963,000
1,016,748 106%
1,041,120
870,656
84%
1,054,656
101% ,
131536
Interest
220,000
366,207 166%
346,000
293,694
85%
364,000
105%
18,000
Prescription Rebates
60,000
148,847 248%
75,000
131,394
175% k
135,000
180% ,
60,000
Claims Reimbursement & Other
177,557
45,000
6,932
15%
20,000
44%
(25,000)
TOTAL RESOURCES
21,411,563
22,699,675 106% ;
22,318,433
18,110,313
81% ;
21,786,085
98% ;
(532,348);
REQUIREMENTS Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Health Benefits 19,559,777
17,493,075 89%
18,550,836
14,611,130
79%
19,779,403 107% (1,228,567), C
Deschutes On -Site Pharmacy 2,284,744
2,514,038 110%
2,242,104
2,168,080
97% !
2,578,352 115% (336,248), C
Deschutes On -Site Clinic 1,114,864
1,045,588 94%
1,141,691
853,264
75%
1,141,691 100% C
Wellness 184,870
158,384 86%
180,380
137,832
76%
180,380 100% C
TOTAL REQUIREMENTS 23,144,255
21,211,086 92% ;
22,115,011
17,770,306
80% ;
23,679,826 107%; (1,564,815);
FUND BALANCE Budget
Actuals %
Budget
Actuals
%
Projection % $ Variance
Beginning Fund Balance 16,051,586
15,075,316 94%
16,106,294
16,563,905
103%
16,563,905 103% 457,611
Resources over Requirements (1,732,692)
1,488,590
203,422
340,007
(1,893,741) (2,097,163);
Net Transfers - In (Out) -
d
-
-
TOTAL FUND BALANCE $ 14,318,894
$ 16,563,905 116% $
16,309,716
$ 16,903,912 104%
$ 14,670,164 90% : ($1,639,552);
A Prior year monthly average was $149K, whereas YTD monthly average is—$130K; COIC rates reduced by 5% at start of fiscal year
B Prior year monthly average was $95K, whereas YTD monthly average
is $72K
C Amounts are paid 1 month in arrears; projection compared to historical
costs for reasonableness
Budget to Actuals Report
911 - Fund 705
FY20 YTD April 30, 2020 (unaudited)
RESOURCES
Property Taxes - Current Yr
Telephone User Tax
Police RMS User Fees
Interest
State Reimbursement
Property Taxes - Prior Yr
Data Network Reimbursement
Contract Payments
User Fee
Property Taxes - Jefferson Co.
Miscellaneous
TOTALRESOURCES
83.3 %
Year Complete
Fiscal Year 2019
1
Fiscal Year 2020
Budget
Actuals
%
Budget
Actuals
%
Projection
%
$ Variance
8,311,833
8,426,089
101%
8,809,419
8,598,848
98%
8,856,617
101%
47,19& A
890,000
955,187
°
107 /o i
900,000
474,581
53%
�
900,000
100% ,
�
B
�
' 300,680
335,192
111% '
250,000
167,192
67%
250,000
100% '
-C
200,000
205,570
103% 4
157,000
160,589
102%
193,000
123% '
36,000! D
125,000
i
162,900
130% '
125,000
101,881
82%
125,000
100%!
-' E
110,000
i
1082419
99% �
100,000
242,627
243% � �
255,000
255% '
155,000- F
50,000
106,592
213% �
55,000
19,819
36% �
55,000
100%!
-t
51,300
175
0% �
51,300
16,083
31% '
75,000
146%'
23,700,C
180,000
i
141,980
79%
73,680
63,967
87% '
73,680
100%!
' C
30,000
33,453
112% �
30,000
33,637
112% � �
33,637
112% �
3,637!
11,200
38,757
346% '
11,951
15,284
128% '
18,572
155% '
6,621
10,260,013
10,514,313
102% ;
10,563,350
9,894,508
94%
10,835,506
103% ;
272,157:
REQUIREMENTS
Budget
Actuals
%
Budget
Actuals
%
Projection
% $ Variance
Personnel Services
i
7,646,307
6,743,116
88%
7,462,575
5,846,016
78%
6,947,099
93% 515,476: G
Materials and Services
3,370,357
3,297,619
98%
3,387,761
2,598,342
77%
3,387,761
100%
Capital Outlay
2,362,400
529,377
22%
1,400,000
353,813
25%
,
1,400,000 100% '
t
TOTAL REQUIREMENTS
13,379,064
10,570,113
79%
12,250,336
8,798,170
72%
11,734,860
96% 515,476:
FUND BALANCE
Budget
Actuals %
Budget
Actuals %
Projection % $ Variance
Beginning Fund Balance
8,625,000
8,660,615 100%
7,753,706
8,604,816 111% <
8,604,816 111%' 851,109:
i
Resources over Requirements
(3,119,051)
(55,800)
(1,686,986)
1,096,338
(899,354) 787,633'
Net Transfers - In (Out)
-
TOTAL FUND BALANCE
$ 5,505,949
$ 8,604,816 156% ;
$ 6,066,720
$ 9,701,153 160%
$ 7,705,462 127% ; $1,638,742;
A Actual 19-20 TAV is a 5.36% increase compared to FY 18-19 vs. 5.5% budgeted; however collection rate is projected to be 95.8% versus 95%
B Telephone maintenance reimbursements are received in a lump sum by early spring
C Majority of billings sent at the end of March, revenue expected at the end of May
D Interest projection based on current investment rate and anticipated cash balances
E State GIS reimbursements are received quarterly
F TDS Baja deferred billing credits per ORS 305.286 in addition to settlement payment
G Projected Personnel savings based on YTD average vacancy rate of 8.3%