HomeMy WebLinkAboutFinance-Tax Staff Report - UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
September 15, 2014
(1) Tax Payments collected by Local Banks
(2) Financial Policies
(3) Monthly Investment Report -August 2014
(4) August 2014 Financials
DESCHUTES COUNTY
l~inancc 1)cpartll1cnt
MEMORANDUM
Date: September 8, 2014
To: Board of County Commissioners
Tom Anderson, County Administrator
From: Wayne Lowry, Finance DirectorfTreasurer
Re: Tax payments collected by Local Banks
Background
For many years, branches of ten or so local banks have accepted property tax
payments due on November 15th on our behalf. Bank customers are able to go
into their bank and make their property tax payment by writing a check and giving
the tax coupon to the teller. The teller deposits the check in a County bank
account and puts the tax coupon in an envelope for the County to pick up. Every
couple of days during the high volume tax collection period, someone from
Finance goes to each participating branch and picks up the coupons that have
been collected by the bank and brings them back to the office for processing.
Years ago when the only options for paying property taxes were by U.S. mail or
coming to the county tax office, this was a convenient alternative for our
taxpayers and in the interest of customer service, it made sense. However, with
the evolution of technology and the additional options now available to our
taxpayers, the bank option has become more burdensome to the tax office and
less customer-friendly for the taxpayers.
Recommendation
I propose that we discontinue the option of allowing taxpayers to pay property
taxes at the local banks.
Analysis
Lender payments account for nearly 29% of our transactions and those are
handled electronically. The remaining 71 % of tax payments are made directly by
citizens through one of the payment methods shown in the table below for last
years first trimester tax collection period.
I
Payment Method Transactions Amount
Collected
% of Citizen
Transactions
% of Levy
Collected
LockboxlELockbo
x
37,147 $91,045,625 51.93% 56.44%
Credit Cards 1,181 $2,021,633 1.65% 1.25% I
!
Banks 4,491 $9,802,396 6.28% 6.08%
Other Methods 28,708 $58,452,542 40.14% 36.23%
Total 71,527 $161,322,196 100.00% 100.00%
ELockbox is when citizens make their tax payments through their banks online
payment feature directly from their account. For this discussion, we have
included them in the Lockbox category as we receive these types of payments
electronically. "Other Methods" includes paying here at the County building
either in person, through the drop box or by mailing payments here.
As you can see, citizens making payments at banks accounts for just 6.28% of
all payments made directly by citizens. There are a number of reasons why we
recommend the elimination of this payment method.
1. Our cost of collecting each account through the lockbox is about $1.34 per
transaction. The cost of collecting accounts through the banks is
estimated to be $2.83 per transaction due to the manual nature of
processing the payments.
2. In addition to mailing their payment or coming to the tax office, taxpayers
have several additional convenient options that were not available when
we started the bank payment option including paying online through their
bank or the County's website and through credit card transactions either by
phone or online.
3. Posting the payments made at the local banks can be delayed by up to 10
business days or more resulting in many phone calls from citizens
wondering why their payments have not been posted to the County's
payments records.
4. Payments made by citizens at banks must be manually posted to the
accounts requiring extra staff time that could be eliminated if the payments
were mailed to the lockbox or paid via phone or internet. We currently use
temporary help to perform this task.
5. When payments are made through the banks, we do not get electronic
images of the checks making it more difficult to answer customer
questions and to determine who overpaid when duplicate payments are
made.
6. Based our conversations last year, we put the following statement in with
our tax statements last year. "Please note: Next year the pay-at-the-bank
option may be modified significantly. Information will be included with your
tax statement next year".
Summary
We believe it would be more cost effective and efficient to eliminate this option
for tax payments. We could decrease our temporary help by one person during
tax season, eliminate the phone calls inquiring about why the taxpayer's bank
payment hasn't yet been posted to the tax account, and if an overpayment
occurs, we won't have to "guess" who should receive the refund. While we may
expect some negative feedback from a few taxpayers, we believe explaining our
reasoning for doing so and pointing out the other options available will minimize
their concerns. The alternative method of payment by those who previously
chose to pay at the banks is difficult to predict, but any other method they
choose will result in a more efficient and timely posting of their payment.
2013-2014 PROPERTY TAX PAYMENT INFORMATION
1300 NW Wall St, Suite 203 OFFICE HOURS -8am -5pm; Monday-Friday*
"Closed Monday, November 11 th in observance Bend OR 97701
of Veterans' Day. (Closed on all other majorPhone: (541) 388-6540 holidays as well.)
Website: www.Deschutes.org/Dial
Payment of Property Taxes via u.s. Mail
Mail your payments in the envelope provided or to
Deschutes County Tax Collector, PO Box 7559, Bend OR 97708-7559
pavment$mq~~pgQlrARmr.pr~pi!1Il)ft;lll~~f1M'6~_r:t~,:Fri!!fti'llQftml&r·15th
in order to be elrgib1Ef~iliseoUfit ~nc;f to avoid tate Pinalt~'to8S·30s~l2Oj·ORS911.S(5).
Important Information about Postmarks
With the consolidation of Post Office locations and closing of Post Office Sorting Facilities, please be aware that
mail deposited at some local postal facilities can take 2 to 4 DAYS to be postmarked.
Deschutes County is not responsible for postmark delays.
We strongly recommend any payments made on or after November 12th be taken to the inside counter at the
Post Office and the postmark to be hand stamped on the envelope to avoid any postmark delays.
Other Options for Making Your Payment
• On the website: Make your payment via the website at www.Deschutes.org/Dial;. Access your account,
dick on the blue {(Pay Your Property Taxes" link and go the "Online" section. Visa, MasterCard,
American Express and Discover credit cards, Visa debit cards and electronic checks are accepted.
NOTE: Payments via the website are processed by a third party which charges a convenience fee for
using this service. See the back of this sheet for convenience fee details. Deschutes County does not
collect or retain any portion of the convenience fee.
• By phone: Make your payment by calling 1-877-309-3933, 24 hours a day, 7 days a week using a credit
or debit card or electronic check. The same fees apply as payments made via the website, as described
on the back of this sheet.
• At the bank: Through November 15, 2013, take your payment to any Deschutes County branch of the
banks listed on the back of this sheet.
• In person: Make your payment in person at one of the Tax Office windows at 1300 NW Wall St, Suite
203 or use the convenient drop box located near the east entrance of the County Offices (available 24
hours a day).
Online Bill Payments: Payments made through online banking services often take 2-3 days to be processed by
the bank and arrive with These payments are posted to r account with the date the funds are
Escrowed Property Taxes
It is the Property Owner's responsibility to know if the lender will be paying the taxes
Generally, if you received a yellow statement from the County, this indicates that a lender has requested
•your information and will be making payment. If you received a green statement, no lender has requested your
information. If in doubt,
3
Debit/Credit Card & eCheck Convenience Fees *
Debit Cards: Payments via Visa debit cards will be charged a flat fee of $3.95 per transaction. For all other debit
cards a convenience fee of 2.50% of the payment amount will be charged. There is a minimum fee of $3.95 per
transaction.
Credit cards: A convenience fee of 2.50% of the payment amount will be charged. There is a minimum fee of
$3.95 per transaction.
eChecks: A convenience fee of $2.00 per transaction will be charged on payments up to $10,000. eCheck
payments greater than $10,000 will incur a fee of $15.00 per transaction.
*Payments are processed bV a third party processor, Official Payments Corporation.
Deschutes County does not collect or retain any portion ofthe convenience fee.
Bank Locations for 2013 Tax Pa ments
DESCHUTES COUNTY BRANCHES ONLY -Accepting payments through November 15th. 2013
Bank of America (all County branches) Umpqua Bank (all County branches)
Bank of the Cascades (all County branches) U. S. Bank (all County branches)
Columbia Bank (Bend and Redmond) Washington Federal (all County branches)
Home Federal Bank (all County branches) Wells Fargo Bank (all County branches)
Sterling Bank (Bend and Redmond)
When making payment at bank locations, please take your check and the entire property tax
statement with you. The bank will retain the remittance portion. located at the bottom of your
statement, and will date stamp the upper portion, which you should keep for your records.
Payments will be posted with the date on your receipt.
Please allow up to 10 days for the payment to be posted to your property tax account.
Please note: Next year the pay-at-the-bank option may be modified significantly. Information will be included
with the tax statement next year.
Address Changes
All address change requests must be made in writing. Address changes can be noted on the remittance
portion of your property tax statement or made online at www.Deschutes.orglDial. If using the online option,
access your account and click the blue "Change of Mailing Address Form" link. You may also call the Tax Office
for other options at (541) 388-6540.
The back of your Tax Statement contains additional important information about Payment
Instructions, Delinquent Taxes and Liens, Foreclosure, and Property Value Appeal Rights
V£e.w your accou.ntOf\.Une,.atwww.Deschutes.org/Dial
4
DESCHUTES COUNTY
Finance 1)eparrll1cnr
lVIEMORANDUM
Date: September 8, 2014
To: Board of County Commissioners
Tom Anderson, County Administrator
\U'v(From: Wayne Lowry, Finance Directorrrreasurer
Re: Financial Policies
During the 2015 Budget Committee process, an updated set of Financial Policies
were included in the proposed budget document with the understanding that those
updated policies would be reviewed with the Board of County Commissioners and
presented for approval.
At the September 15,2014 work. session, the Board will have the opportunity to
review and discuss the draft financial policies that were included in the proposed
budget. The draft policies are attached with additions to the policies indicated by
shading. As we move forward, the updated financial policies will be included on a
consent agenda for approval.
If you have any questions on the poliCies prior to the 15th , please give me a call.
Deschutes County Financial Policies
Introductory Comments
Deschutes County has an important responsibility to its citizens to carefully account for public funds, manage
municipal finances wisely, manage growth, and plan adequate funding of services desired by the public,
including the provision and maintenance of public facilities. Deschutes County insures that it is capable of
adequately funding and providing County services needed by the community on a sustainable basis.
The following Financial Policies are designed to establish guidelines for the fiscal stability ofthe County. The
scope of these policies generally spans, among other issues, accounting, auditing, financial reporting, internal
controls, operating and capital budgeting, revenue management, expenditure control, asset management, cash
and investment management, and planning concepts, in order to:
• Demonstrate to the citizens of Deschutes County, the investment community, and the bond rating
agencies that the County is committed to strong fiscal operations and to the preservation of its ability to
provide the financial stability to navigate through economic downturns and respond to the changing
needs of the community;
• Provide an adequate financial base to sustain a sufficient level of County services to the community
delivered in a cost effective and efficient manner;
• Present fairly and with full disclosure the financial position and results of financial operations of the
County in conformity to Generally Accepted Accounting Principles (GAAP); and
• Determine and demonstrate compliance with finance-related legal and contractual issues in accordance
with provisions of the Oregon Revised Statutes and other pertinent legal documents and mandates.
These financial policies are recommended to enable Deschutes County to meet the priorities of the Board of
County Commissioners and maintain its financial condition so that it can continue to provide the appropriate
high level of service to its citizens.
Financial Planning Policies
Budget Process
The County budget process will conform to existing state and local regulations including local budget law.
The process will be coordinated so that major policy issues and Board goals and objectives are identified and
inco~orated into the budget_
Balanced Budget
Deschutes County's accounting and budgeting systems are organized and operated on a fund basis. The
budget for each fund is balanced, meaning total resources, consisting of beginning net working capital, current
year revenues and transfers-in, are equal to total requirements and transfers out, contingencies,
unappropriated ending fund balances, and reserves for future expenditures.
Budget Adjustments
All requests for budget changes after adoption will be submitted to the Finance Director for analysis. The
Finance Director will determine the need for. the adjustment and the process to be followed to seek approval
for the requested change. All resolutions proposing adjustments to the adopted budget will be prepared by t he
Finance Department and will be placed on the Board's agenda by Finance for Board approval to ensure
comj>liance with budget laws.
GFOA Awards Program
The County participates in the GFOA Award for Distinguished Budget Presentation program and will
continue to submit its annual budget to the program.
Financial Reporting Policy
The County's accounting systems and financial reports will be in conformance with all state and federal laws,
generally accepted accounting principles (GAAP) and standards of the Governmental Accounting Standards
Board (GASB) and the Government Finance Officers Association (GFOA). An annual audit will be performed
by an independent public accounting firm, licensed as a municipal auditor, with an audit opinion to be
included with the County's published Comprehensive Annual Financial Report (CAFR). The County's CAFR
will be submitted to the GFOA Certification of Achievement for Excellence in Financial Reporting Program.
The financial report should be in conformity with GAAP, demonstrate compliance with finance related legal
and contractual provisions, thoroughly disclose sufficient detail, and minimize ambiguities and potentials for
misleading inference. The County's CAFR will also be provided to the Municipal Securities Rulemaking Board
via electronic submission to the Electronic Municipal Rulemaking Board (EM:MA), a continuing disclosure
requirement, to enable investors to make informed decisions. Financial systems will maintain internal
controls to monitor revenues, expenditures, and program performance on an ongoing basis.
Budgeting for Operating Working Capital and Contingencies
Operating Funds
In order to maintain a prudent level of financial resources to protect against the need to reduce service levels
or raise taxes (ie. voter-approved local option levy) and fees due to temporary revenue shortfalls or
unforeseeable one-time expenditures, the County will establish and maintain certain working capital
balances. The County will strive to maintain a working capital level in each operating fund, other than the
General Fund, of 8.3 % (l/12th) of that fund's operating budget. The County will establish operational working
capital within the General Fund of approximately four months of estimated annual property tax collections.
Other funds that rely heavily on property taxes, which are not received until the month of November each
year, should have an operating working capital level at or near the level of the General Fund, and include the
Sheriffs Funds, 9-1-1, Extensionl4-H, and the Sunriver and Black Butte Ranch county service districts. he
Finance Director shall have the authority to allow exceptions to this policy for those funds with significant
reserves and those that can demonstrate sufficient cash flow to avoi d inter-fund borrowingJ!rior to the receillt
of tax revenues.
Reserve and Insurance Funds
The following funds, due to their specific purposes, require reserve working capital balances above 8.3%:
PERS Reserve Fund
Insurance (general liability, workers' compensation, unemployment, and property damage)
Health Benefits (medical, pharmacy, dental and vision)
Various Community Development Reserve Funds, when applicable
GIS Dedicated Fund
Road Building and Equipment Reserve Fund
Vehicle Maintenance and Replacement Fund
Public Health Department Reserve Fund
Sheriffs Capital Reserve Funds
General Capital Reserve Fund
General County Projects Fund
Project Development Fund
County Clerk Records Fund
Solid Waste Reserve Funds
FairlExpo Center Capital Reserve Fund
County Service District Reserve Funds
Working capital balances for these funds will be deteonined each year by the Finance Director and the
Department Head given th uru!lue n d o(each fund and the anti~ated u e f such funds in future
years.
Long Range Planning
Each year, the County will update resource and requirement forecasts for major operating funds for the next
five years and annually develop a five-year Capital Improvement Program (CIP) for major projects related to
the acquisition, expansion or rehabilitation of the County's buildings, equipment, parks, streets and other
public infrastructure . These estimates will be presented to the Budget Committee in a format which is
intended to facilitate budget decis ions and strategic planning, based on a multi-year perspective.
Revenue Policies
Revenue Diversification
Revenues estimates will be established each year in a realistic and prudent manner using objective and
analytical approaches. Revenue forecasts will ass ess the full spectrum of resources that can be allocated for
public services. To the greatest extent possible, the County's revenue system will be diversified as protection
from s hort-run fluctuations in anyone r evenue source.
Fees and Charges
User fees and charges will be established for services that benefit specific individuals or organizations. The
County will annually review all fees, licenses, permits, fines and other miscellaneous charges in conjunction
with the budget process. U s er charges and fee s will be established based at a le vel related to the full cost of
providing the service, unless otherwise provided by statute or regulation. Full cost incorporates direct and
indirect costs, including operations and maintenance, overhead, and charges for the use of capital facilities.
Other factors for fee or charge adjustments may also include the impact of inflation, other cost increases and
CUlTent competitive rates.
Use of One-Time Revenues
One-time revenues or res ources shall not be used to fund ongoing operations, unless in the context of a multi
year financial plan to balance expenditures and reserves. One-time revenues should not support ongoing
personnel and operating costs. Use of one· time revenues is appropriate for non-reculTing capital outlay, debt
retirement, contribution to capital reserve, and othe r non-recurring expenses.
U s e of Unpredictable Revenues
Revenues of a limited or undefined term will generally be used for capital projects or one-time operating
expenditures to ensure that no ongoing service programs are lost when such revenues are reduced or
discontinued.
Grants
Grants are generally contributions from one government to another, usually for a specific purpose. Grants
can be recorded in any type of fund and should be recorded in an existing fund whenever possible. Grants
s ometimes come with matching fund requirements. It is important that matching requirements be well
understood before grants are accepted by the County to ensure that services being provided through grant
funding are sustainable. It is also essential any s taff hired to carry out grant funded services are hired
subject to the amount and continuation of the grant funding .
Revenue Management
fl'he County will n ot respond to long term revenue s hortfalls with deficit funding or borrowing to sup p ort
ongoing operations. Once w or king capital balances have rea ched policy levels, expen ses· d uced to
conform to long t e rm revenue fo recasts and/or revenue increases will be considered.
Expenditure Policies
Debt Capacity, Issuance and Management
• The Finance Director is responsible to structure all debt issuances and oversees the on-going
management of all County deb t including general obligations , l ease purchase agre e ments, reven ue
bonds, full fai th a nd cre dit bonds, special assessmen t bo nds, promissory n otes, equipment fin ancing
agreements and any other contractual arrangements that obligate t he County to make ture princi pal
and interest payments.
• No debt will be issued for which the County is not confident that a sufficient specifically identified
revenue source is available for repayment. The Financ Director hall p~pare an anal~sis of the
source of repa en rior to issuance of any debt
• When issuing long term. debt, the County will ensure that debt is only incw:red when necessary fo
capital improvements too large to be financed from current resources, the useful life of a finan
Un provement will exceed the life of the related debt, the benefits of financing exceed the cost of....-:-:--=c
borrowing, and ensure that o~' related to C8J)ital im rovements are ad ately onsidered
:he re
• The County will manage and administer its long·term debt in compliance with the restrictions and
limitations of State law with regard to bonded indebtedness for counties as outlined in the Oregon
Revised Statutes. These statutory restrictions establish legal limitations on the level of limited tax and
general obligation bonded debt which can be issued by the County (1 % and 2% of the real market value
of all taxable property, respectively). The statutes outline the processes for public hearings, public
notice and bond elections, as well as provisions for the issuance and sale of bonds and restrictions on
the use of those bond proceeds.
• The County will not use long-term. debt to fund current operations, to balance the budget, or to fund
projects that can be funded from current resources. The-County may use short-term. debt or inter-fund
loans as permitted by law to cover temporary cash flow needs resulting from a delay in grant proceedS
or other revenues and delay in the issuance of long term debt. All bond issuances and romissorY. notes
will be au orize by res ution of the Board of County Commissi ners.
• The County will. through prudent financial management and budgeting practices, strive to maintain or
enhance its Moody's ere . ratings hich are currJLntly' A for full faith and credit ebt and=="",
genera obligatio debt.
• The County will ensure that adequate procedures are in place to meet the post issuance obligations of
borrowers to report periodic financial information and to disclose certain events ofintere to bond
holders in a timely manner.
Operating/Capital Expenditure Accountability
The County will maintain an accounting system which provides internal budgetary controls. The County's
budget documents shall be presented in a format that provides for logical comparison with prior fiscal periods
wherever possible. Reports comparing actual revenues and expenditures to budget for the County's major
operating funds shall be prepared monthly which will be distributed to the Board of County Commissioners,
County Administrator, Department HeadslDirectors and any interested parties.
The County will strive to fund minor capital improvements on a pay-as-you-go basis to enhance its financial
condition and bond rating. The County shall annually contribute to certain capital reserve funds to the extent
possible given cash flow limitations and projected capital improvements.
Internal Service Funds
Internal service funds are used to account for services provided by one department to other departments on a
cost-reimbursement basis. The goal of an internal service fund is to measure the full cost of providing services
for the purpose of fully recovering that cost through fees or charges to user departments. Deschutes County
internal service funds are as follows: Building Services. Administrative Services, Board of County
Commissioners, Finance, Legal Counsel, Personnel, Information Technology, Information Technology Reserve,
Insurance Reserve and Health Benefits Trust.
Cash Management Policies
Investments
County funds will be invested in a prudent and diligent manner with emphasis on safety, liquidity and yield,
in that order. The County will conform to all state and local statutes governing the investment of public funds
and to the County's investment policy. The County's investment policy shall be approved by the State of
Oregon Short-Term Fund Board and adopted by the Board of County Commissioners at least annually.
Additionally, the County will have an Investment Advisory Committee to review the County's investment
policy, its investments, and its investment strategy and philosophy. The Investment Advisory Committee will
consist of financial experts who are citizens of Deschutes County, and will meet twice each year.
Banking Services
The County will seek competitive bids for its banking services. Requests for proposals will be comprehensive,
covering all aspects of the County's banking requirements. The award to the successful bidder will be for a
five-year period with two one year extensions.
Annual Validation of County Bank Accounts
Each year a letter is to be mailed to all banking institutions operating within Deschutes County to validate
that the only Deschutes County accounts, listing Deschutes County or a Deschutes County department as the
owner ofthe account and utilizing the County's federal identification number, are those accounts that have
been approved by the Board of County Commissioners. The letter will state which bank accounts have been
approved by the Board of Commissioners and request that each bank notify the County of any accounts in
operation within their financial ins titution that are not on the approved list.
The Finan ce Dire ctorfI'reas urer is a u t h orized to estab lish all bank a ccoun ts, determine and aut horize
signatories to those b ank accounts, set u p credit cards for County staff as needed and to m~e all bankin
and investmen t related services for t he County.
Internal Controls and Performance Auditing Policies
Employees in the public sector are responsible to the taxpayers for how public resources are used and must
perform their duties in compliance with law, policy, and established procedures. The following County
activities are essential and are consistent with providing citizens with an objective and independent appraisal
of County government.
• Maintain an independent internal audit program to evaluate and report on the financial condition,
the accuracy of financial record keeping, compliance with applicable laws, policie s , guidelines and
procedures, and efficiency and effectiveness of operations.
• Maintain a County Audit Committee comprised mostly of public citizens to oversee audit services,
both external and internal.
• In coordination with the Audit Committee, the County Internal Auditor and the County's external
auditors shall periodically review internal controls in County departments and report findings to
the Audit Committee regarding these reviews.
• At the direction of the Audit Committee, the County Internal Auditor shall conduct performance
audits to ensure departments and agencies funded by the County are operating in an efficient and
cost-effective manner.
Purchasing
All purchases of good and services must comp ly with the Co unty's p urchasing p olicies, purchas ing rules and
p r oced ures in accord ance with state l aws and regulations. Before the County p urchases any major asset or
undertakes any operating or capital 8.1Taogements tha t create fix ed costs or ongoing operational e ~ense8
the imRlicatio of s uch P. h . fully: de~rmined for the current and future years.
Approved by the Deschutes County Board of Conunissioners on September XX, 2014.
Deschutes County
I Municipal
Debt
3.8%
air
'''BOT ,,,
0 %
Federal
Agencies
29 .0 %
Corporate
Notes
24.4 %
Time
Certificates
4 .0%
U. S .
Treasuries
5 .7%
Investments By County Function
General $ 122,360,007 $
Investment Income
Fiscal Year 2014-15
Aug-14 I I Y-T-D
69,993 $ 73,742
--
Total Investments $ 122,360,007
Total Investment Income
Less Fee: 5% of Invest. Income
Investment Income -Net
69,993 143 ,735
(3,500) (7,187)
$ 66 ,493 _i
-136,548
Yield Percentages
Municipal Debt $ 4,670,000
Corporate Notes 29,874,000
Time Certificates 4 ,920 ,000
U. S . Treasuries 7,000,000
Federal Agencies 35,497,000
LGIP/BOTC 40,399 ,007
Total Investments $ 122,360.007
1-Total PortfoliO: By Investment Types
3.82%
24 .41%
4.02%
5.72%
29 .01%
33.02%
100.00%
Category Maximums:
U.S . Treasuries 100%
LGIP 100%
Federal Agencies 75%
Banker's Acceptances 25%
Time Certificates 50%
Municipal Debt 25%
CorQorate Debt 25%
Term Minimums
0-30 days 10%
Under 1 Year 25%
Under 5 Years 100%
_E!ImmImiI.~
BOTC I LGIP . 0.54% 0.54%
Investments . 0.80% 0.79%
Average • 0.73% 0.72%
Months to Maturity
o to 30 Days 33.10%
Under 1 Year 42.10%
Under 5 Years 100.00%
--
----
---
---
-----
- -
--
- -
--
- -
- -
- -
--
---
- -
-------
Deschutes County Investments I I ~Man<'9_ement
Portfolio Details· Investments --I . ,
I I
August 30, 2014
IcUsii> ; Security Broker
---+
Purchase
Date
Maturity
Date
Days To
Maturity
Ratings
Moodys !S&P
Coupo,,_____
Rate YTM 365
Par
Val u e
Market
Value
Book
Value
Call
Date
SYS10321 ; Home Federal Bank CO
~
9/~9/2013 , 9/~ 18 ' 0.130 0.132-.--"---100,000 1 100 ,000 100,000
4001174329 ' Columbia State Bank CD 121 5/2013 1215/2014 95 0.210 0.213 140,000 140,000 140,000
8941748454 : Stening Savings Bank CD 7/1/2013 1/1/2015 122 0.200 0.203 2,000,000 2,000,000 2,000,000
HFBCO 'Home Federal Bank CD 21 1/2013 1131/2015 152 0.200 0.203 140 ,000 14 0,000 140,000
91159HGU8 US Bancorp CASTLE 1/22/2014 3/412015 184 A+ Al 3.150 OAOl l 500,000 507,140 506,963 1
4001154309
273-150017·5
,Columbia State.~ank CD
ISouth Valley Bank CD
4/1/2013
5/20/2013
3/30/20 15
5/20/2015
210
261
O.l SO
0.748
0.152
0.758
100 ,000
200,000
100,000
200 ,000
100,000 1
200,000
UMP972002570 , Umpqua Bank 617/2014 617 /2015 279 OAOO ' OA06 1 240,000 240,000 240,000 I
3692G5F7 i General Electric -Corporate N CASTLE 9/17/2013 6/30/2015 302 AA+ AI 2.375 086sf 1,400,000 1,423,926 1,417,382
36962G5F7
SYS10316
1 Genera l Electric -Corporate N
IUmpqua Bank
CASTLE 1/101 20 14
7/9/2013
6/3012015
7/9/2015
302 AA+
311
A l 2.375
0.500
.£;.5~l t
0.507
545 ,000
2,000,000
554 ,314
2,000,000
553 ,44 3
2,000,000
94985H5F7 ; Wells Fargo Corporate Note CASTLE 91301 20 13 7/20/2015 322 ,AAAA3 0. 75 0 0.541 1,000,000 1,003,680 1,001,840 I
91159HGX2 .US Bancorp CASTLE 4/2/2014 7/27/2015 329 A+ AI 2A50 0.501 1,180,000 1,202,361 1,200,732 -
91159H GX2 U S Bank - Corp Note -CASTLE 3/26/2014 7/27/2015 329 A+ AI 2.450 0.500 1,57 3,000 1,602,808 1,600,644
3135GOPR8 Federal Nationa l Mtg Assn CASTLE 10/9/2013 10/9/2015 403 AA+ Aaa OA80 OA50 1,000,000 1,000,300 1,000,332 10/9/2014
064159BA3 Bank of Nova Scotia CASTLE 4/31 2014 10/9/2015 403 A+ -I Aa2 0 .750 0 .62 1 ._-540 ,000 541,998 540,768 --
3134G4HZ4 Federal Home Loan Mtg Corp CASTLE 10/2812013 10/28/2015 422 AA+ Aaa 0.500 0.500 2,000,000 2,001,140 2,000,000 10/28/2014
36962G4T8 General Electric -Corpo~ate N CASTLE 7/24/2014 11/912015 434 AA+ AI 2.250 0.500 2,000,000 2,039,920 2,041,418 -
7427180S5 ' Procter & Gamble CASTLE 1216/2013 11115/2015 440 AAAA3 1.800 OA30 1,000,000 1,017,050 1,016,429 -
SYS10368 : Royal Bank of Canada VIN IS P 3/27/2014 12/15/2015 470 AAAa3 2.625 0.600 1,500,000 1,540,020 1,538,885
532457AN8 : Eli Lilly & Co. CASTLE 3/24/2014 1/112016 487 AAA2 6.570 0.500 1,408 ,000 1,517 ,627 1,521 ,291
084670BG2 ' Be rks hire Hathaway Inc CASTLE 3/3/2014 2111/2016 ~~:'''-~J_ 0.800 0.500 1,000,000 1 ,003,700 1,004,306
17275RAC6 : Cisco Systems Inc CASTLE 2/27/2014 212212016 539 AA-Al 5.500 0.550 1,874,000 2,010,427 2,009,889
06406HCG20 Bank of New York Mellon Corp CASTLE 4/4/2014 3/4/2016 550 A+ Al 0.700 0.68 1 1,000,000 1,001,530 1,000,283 2/3/2016
3133734F6 Federal Home Loan Bank CASTLE 51212014 4115/2016 592 AA+ Aa a 0.772 0.600 650,000 650,397 651,804 -
~60AYO , Johnson & Johnson CASTLE 1171201 4 5/1 5/2016 622,AAA Aaa 2.150 0.620 1,529,000 1,571,552 1,568,544
949746QU8
686053CF4
We lls Fargo Corporate Note
Oregon School Boa r~Assoc
VINISP 2120/2014
CASTLE t 3/7/2014
611 5120 16
613012016
653.A+
668 A+
A2
Aa2
3.676
0000
0.750
0 .999
1,000 ,000
3,000,000
1,051,460
2,935 ,OSO
1,051 ,790
2,945,944 -
912828QXl U.S. Treasury MBS 6119/201 4 7/31/2016 699 AA-Aaa 1.500 0.548 1,000,000 1,019,220 1,018,085
3134G56B6 I Federal Home Loan Mtg Core MBS 7/7/2014 8/26/2016 7 25 AA+ Aaa 0.580 0.629 2,000,000 1 995,100 1,998,047 11/26/2014
912828RF9 U.S. Treasury CASTLE 12127/2013 8/31/2016 730.AA+ Aaa 1.000 0.646 1,000,000 1,009,610 1,006,998
31359YLS4 'Federal National Mtg Assn PJ 3/5/201 4 9/15/2016 745 AA+ Aaa 0778 0.812 672,000 661,927 661,175 -
3133EAZ76 : Federal Farm Cred~ Bank CASTL E 5/23/20 14 9/26/2016 756 AA+ A aa 0.690 0 .686 3,000,000 3,000,000 3,000,265
3131A1C08 · Federal Home Loan Bank CASTLE 7/17/2014 9/28 /20 16 758 AA+ Aaa 1.125 0.728 2 ,000 ,000 2,015 ,940 2,015,516 9/28/2015
3134G4HK7 Federal Home Lo an Mill Core CASTLE 3127/2014 1012 4/2016 784 i AA+ Aaa 0 .500 1.119 3.015 ,000 3,016 ,116 3,015,772 10/24/2014 ~;RM 4
3134G4K98
: U.S . TreasLJry
: Federal Home Loan Mtg Core
CAST LE
CASTLE
1212 7/2013
2/20/2014
10/3 1/20 16
111712016
791AA+
798 AA+
Aaa
Aaa
1.000
0.800
0-127
0.800
1,000,000
2,000,000
1,008,440
2,000,280
1,005,829
2,000,000
-
11/7/2014
IQsOsOTLRl ,Bank of America -Corporate CASTLE 5/1312014 11/14/2016 805 A A2 1.125 1.050 1,900,000 1902,204 1,903,077 -.
3133ECWV2 · Federal Farm Credit Ba n k CASTLE 12117/2013 1217/2016 828 AA+ Aaa 0 .875 0.722 2,100,000 2 ,110,038 2,107,511
0641590Al 'Bank of Nova Scotia CASTLE 61912014 121 13/2016 834,A+ Aa2 1.100 0.910 1,800,000 1,806,012 1,807,693
3136G1XP9 ·Fe deral National MtQ Assn PJ 316/2014 121 19/2016 840 i AA+ Aaa 0.800 0.788 2,000,000 1,997,440 2,000,561 11/19/2014
06406HCA5 Bank of New York Mel lon Corp CA Sn E 4/23/2014 1/17/2017 869 A+ Al 2.400 1.067 2,000 ,000 2,061,480 2,062,286 121 18/2016
912828SC5 'U.S. Treasury CAS TLE 1/16/201 4 1/31/2017 883 AA+ Aaa 0.875 0 _844 2 ,000,000 2,008 ,120 2,001,490
0641590Z6 Bank of Nova Scotia CASTLE 5/1/2014 3/1772017 928 A+ Aa2 0.800 0 .906 1,000,000 999,330 997,347 3117120 16
912828SS0 U.S. Treasury WF 1/17/2014 4/30/2017 972AAA Aaa 0 .875 0.950 2,000,000 2,002,500 1,996,073 -
037833AM2
89236TBH 7
A[>e le Inc
To~ota Mtr Cred -Core 1Ii --
CASTLE
CASTLE
6/24/2014
7/29/2014
5/512017
5/16/201 7
977'AA+
988 AA-
Aal
AA3
1.050
1.125
1.057
1.150
2,000,000
2,125,000
2,002 ,160
2,123,661
1,999,626
2,123 ,560
-.
3136FPYB 7 Federal National Mtg Assn VINISP 217/2014 5123/2017 995AA+ Aaa 2.050 0.885 1,460,000 1,499 ,186 1,505 ,611 -
31359MEL3 Federal National Mtg Assn CASTLE 12/2312013 61 1/2017 1,004 AA+ Aaa 1061 1.115 1,000,000 971 ,160 970,400
31359MEL37 Federal National Mtg Assn CASTLE 1124/2014 6/1/2017 1,004 AA-Aaa 1.08 1 1.136 1,050,000 1,019,718 1,018,340
29270CYZ2 Bonneville Power Adminislratio CASTLE 4/24/2014 7/112017 1,034 'AA-Aa l 1.197 1.17 1 670,000 671,018 670,495
84247PHS3 Southern CA Public Power Autho CASTLE 6/17/2014 7/112017 1,034 AA1.145 1.180 1,000,000 996,680 999,021
3134G5FK6 Federal Home Loan Mtg Corp CASTLE 8/21/2014 8/2112017 1,085 AA+ Aaa 1.250 1250 2,000,000 2,000,380 2,000,000 11/21/2014
313383JB8 ,Federal Home Loan Bank VINISP 12126/2013 9/27/2017 1,122 AA+ Aaa 1000 1.250 1,000,000 997,270 992,518
3136GOC74
3130A1ZK7
IFederal National Mtg Assn
Federal Home Loan Bank
VINISP
MBS
1 2/3/2014
5/28/2014
9/27/2017
11/28/2017
1,122 AA+
1,184 AA+
Aaa
,Aaa
1.000
0.750
0.943
0750
1,050,000
1,000,000
1,054,841
998 ,930
1,051,803
1,000,000 I
9/27/2015
31 300N71 Federal Home Loan Bank VINISP 4/2/2014 1/30/2018 1,24 7 AA+ Aaa 2.000 1.710 1,500,000 1,507,950 1,514,315 1 1130/2015
3136G1AU3 Federal National Mtg Assn VINISP J 12/23/2013 113012018 1,247 AA+ 0.700 1.420 1,000,000 984 ,810 988 ,892 10i 30/20M
3135GOVU4 Federal National Mtg Assn VINISP 1/24/2014 4/312018 1,310 1AA+ Aaa 1.125 1.540 I 1,000,000 993,470 985,616 1 4/3/2015
313OA25R3 Federal Home Loan Bank MBS 6119/2014 6/19/2018 1,387 AA+ Aaa 1.000 1.026 2,000,000 1,999,920 1,998,100 1 9/19/2014
3136G16BO Federal National Mtg Assn VINISP 1/21(20 14 12/27/2018 1,578 AA+ Aaa 0. 7SO 1.820 1,000,000 986,570 974,400 9127/2014
SYS10078
SYs10084
· Local Govl Investment Pool
: Bank of the Cascades I
-
0.540
0.540
0.540
0.540
35,893,297
4 ,505,712
122360,009
35,893,297
4,505,712
122 ,916 .889
35,893,297
4,505,712
122,882 ,113
~ -
Memorandum
Date: September 8,2014
To: Board of County Commissioners
Tom Anderson, County Administrator
From: Wayne Lowry, Finance Director
RE: Monthly Financial Reports
Attached please find August 2014 financial reports for the following funds: General
(001), Community Justice -Juvenile (230), Sheriff's (255, 701, 702), Public Health
(259), Behavioral Health (275). Community Development (295). Road (325),
Community Justice -Adult (355), Commission on Children & Families (370), Solid
Waste (610), Insurance Fund (670),9-1-1 (705). Health Benefits Trust (675), Fair &
Expo Center (618), and Justice Court (123).
The projected information has been reviewed and updated, where appropriate, by the
respective departments.
Cc: All Department Heads
GENERAL FUND
Statement of Financial Operating Data
Through August 31,2014
FY 2015 -Year to
Date (16.7% of Year)FY2014 I %of
Actual Actual Budget
FY 2015
Budget I Projection I $ Variance
Revenues
Property Taxes -Current
Property Taxes -Prior
Other General Revenues
Assessor
County Clerk
BOPTA
District Attorney
Tax Office
Veterans
Property Management
Grant Projects
Total Revenues
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Tax Office
Veterans
Property Management
Grant Projects
Non-Departmental
Total Expenditures
Transfers Out
Total Exp & Transfers
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
10,371,843 8,381,199
$ 8,381,199 $ 4,582,809
a) Current year taxes received beginning in October
b) PILT received in July -$500,941
0% a)
29%
27% b)
24%
19%
23%
10%
27%
0%
16%
nla
5%
16%
12%
19%
15%
12%
15%
16%
nla
11%
15%
22%
18%
109%
$
21,906,239
704,120
2,116,386
875,381
1,276,019
16,097
226,973
236,278
80,787
91,900
2,000
27,532,179
3,559,750
1,293,531
59,895
5,382,874
796,232
292,672
248,054
130,054
1,432,177
13,195,239
16,327,584
29,522,823
(1,990,644)
-
167,867
601,982
210,509
225,452
3,712
18,395
60,312
-
4,000
-
1,292,228
616,922
178,771
13,183
862,913
107,417
52,355
41,915
-
122,361
1,995,839
3,094,780
5,090,619
(3,798,390)
22,736,401
576,500
2,247,299
876,137
1,181,190
16,117
182,612
222,199
101,986
25,000
28,165,441 28,165,441
3,793,770 3,793,770
1,536,210 1,536,210
70,777 70,777
5,712,168 5,712,168
877,907 877,907
354,989 354,989
258,569 258,569
1,139,696 1,139,696
13,744,086 13,744,086
14,076,394 14,076,394
27,820,480 27,820,480
22,736,401
576,500
2,247,299
876,137
1,181,190
16,117
182,612
222,199
101,986
25,000
344,961 344,961
7,692,433 8,381,199 688,766
8,037,394 $ 8,726,160 $ 688,766
Page 1
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Through August 31,2014
FY 2014
Actual
Revenues
OVA Basic & Diversion 322,574
State Grant
Inmate/Prisoner Housing 47,550
Jail Funding HB #2712 36,311
Food Subsidy 23,988
Interfund Grant -Gen Fund 20,000
Interest on Investments 7,611
Leases 5,200
SB #1 065-Court Assess. 17,335
Contract Payments 7,415
Discovery Fee 1,870
Case Supervision Fee
Federal Grants 9,434
CFC Interfund Grant 125,429
Miscellaneous 909
Total Revenues 625,626
Expend itures
Personnel Services 4,887,572
Materials and Services 1,035,701
Capital Outlay
Transfers Out 3,660
Total Expenditures 5,926,933
Revenues less Expenditures (5,301,306)
Transfers In-General Fund 5,368,346
Change in Fund Balance 67,040
Beginning Fund Balance 1,177,566
Ending Fund Balance $ 1,244,605
a) Payments received quarterly
FY 2015 -Year to Date
(16.7% of Year)
I % of
Actual Budget
-0% a)
-0% a)
25,800 65% b)
9,057 25% a)
-0% c)
-0% a)
1,420 20% d)
1,800 nfa e)
3,974 66% f)
1,033 23%
-0% g)
782 nfa h)
-nfa
-nfa
-0%
FY 2015
Budget I Projection I $ Variance
359,149 359,149
91,379 91,379
40,000 50,000 10,000
36,568 36,568
24,000 24,000
20,000 20,000
7,000 8,000 1,000
7,200 7,200
6,000 20,000 14,000
4,500 4,500
3,800 (3,800)
4,500 4,500
1,025 1,025
$
b) Increase in projection due to out-of-County detention revenue
c) Payment received within 60 days of service rendered
d) Projection based on annualizing year to date
e) Sub-lease of space to Rimrock not included in FY 2015 budget
f) State payment will exceed the amount estimated for FY 2015 budget
g) Agreement with District Attorney's Office no longer in effect
43,866 7% 593,421 267,172 32,900
835,053
154,664
-
-
16%
15%
0%
0%
5,146,491
1,021,392
1,100
3,660
5,146,491
1,021,392
3,660
1,100
989,717 16% 6,172,643 6,171,543 1,100
(945,851) (5,579,222) (5,904,371) 34,000
894,724 17% 5,368,346 5,368,346
(51,127) (210,876) (536,025) 34,000
1,244,605 100% 1,250,000 1,244,605 (5,395!
1,193,479 $1,039,124 $ 708,580 $ 28,605
h) Policy, requiring supervison fees, not anticipated at the time the FY 2015 budget was prepared. Projection
based on annualizing year to date
Page 2
SHERIFF -Consolidated
Statement of Financial Operating Data
Through August 31,2014
Revenues (Funds 701 & 702)
Law Enf Dist Countywide 20,635,256
Law Enf Dist Rural 12,526,331
T otat Revenues 33,161,587
Expenditures (Fund 255)
Sheriffs Services 2,308,182
Civil/Special Units 1,132,029
Automotive/Communications 1,701,586
Investigations/Evidence 1,418,744
Patrol 8,247,222
Records 761,260
Adult Jail 14,277,113
Court Security 294,563
Emergency Services 194,888
Special Services 1,352,528
Training 506,938
Other Law Enforcement Svcs 801,895
Non-Departmental 81,701
Total Expenditures 33,078,650
Revenues tess Expenditures 82,937
DC Comm Syst Reserve 200,000
Transfer to Reserve Funds 200,000
Change in Fund Balance (317,063)
Beginning Fund Balance 9,553,793
Ending Fund Balance $ 9,236,730
FY2015
Actual
FY 2015 -Year to
FY2014 Date (16.7% of Year)
Actual I Budget Budget I Projection I $ Variance
372,408 2% 20,365,842 20,365,842
546,744 4% 12,751,766 12,758,796 7,030
919,151 3% 33,117,608 33,124,638 7,030
426,739 17% 2,467,673 2,467,673
196,350 16% 1,192,980 1,192,880 100
410,966 22% 1,886,365 1,886,265 100
281,655 17% 1,627,803 1,627,703 100
1,351,220 16% 8,705,700 8,705,700
115,040 14% 798,805 798,705 100
2,428,106 16% 15,144,157 15,144,157
53,253 18% 302,867 302,767 100
26,854 15% 177,852 177,752 100
221,792 13% 1,655,424 1,655,424
69,463 13% 551,318 551,218 100
135,552 17% 806,044 806,044
12,134 17% 72,813 72,813
5,729,121
$
16% 35,389,801 35,389,101 700
(4,809,970) (2,272,193) (2,264,463) 7,730
-
-0% 200,000 200,000
0% 200,000 200,000
(4,809,970) (2,672,193) (2,664,463) 7,730
9,236,730 121% 7,658,937 9,236,730 1,577,793
4,426,760 $4,986,744 $6,572,267 $1,585,523
Page 3-A
SHERIFF -Fund 255
Statement of Financial Operating Data
Through August 31, 2014
Revenues (Fund 255)
Law Enf Dist Countywide
Law Enf Dist Rural
Total Revenues
Expenditures (Fund 255)
Sheriff's Services
Civil/Special Units
Automotive/Communications
Investigations/Evidence
Patrol
Records
Adult Jail
Court Security
Emergency Services
Special Services
Training
Other Law Enforcement Svcs
Non-Departmental
Total Expenditures
Revenues less Expenditures
FY 2015 -Year to Date
FY2014 (16.7% of Year)
Actual Actual I Budget
20,817,324 3,601,208 14%
12.278,716 2,127,913 14%
33,096,040 5,729,121 14%
2,308,182 426,739 17%
1,132,029 196,350 16%
1,701,586 410,966 22% a)
1,418,744 281,655 17%
8,247,222 1,351,220 16%
761,260 115,040 14%
14,277,113 2,428,106 16%
294,563 53,253 18%
194,888 26,854 15%
1,352,528 221,792 13%
506,938 69,463 13%
801,895 135,552 17%
81,701 12,134 17%
33,078,650 5,729,121 16%
$ 17,390 -
35,389,801 35,389,101 700
$4,986,744 $ $ (4,986,744}
FY 2015
Budget I Projection I $ Variance
25,428,019 22,287,066
14,948,526 13,102,035
40,376,545 35,389,101
2,467,673 2,467,673
1,192,980 1,192,880
1,886,365 1,886,265
1,627,803 1,627,703
8,705,700 8,705,700
798,805 798,705
15,144,157 15,144,157
302,867 302,767
177,852 177,752
1,655,424 1,655,424
551,318 551,218
806,044 806,044
72,813 72,813
(3,140,953)
p,846,491 )
(4,987,444)
100
100
100
100
100
100
100
a) Annual payment for Deschutes County Communication System, $292,126, expended in July 2014
Page 3-B
SHERIFF -Expenditure Detail
Statement of Financial Operating Data
Through August 31 , 2014
FY 2014
Actual
Expenditures
Sheriff's Services
Personnel 1,342,795
Materials & Services 965,387
Capital Outlay -
Total Sheriffs Services 2,308,182
Civil/Special Units
Personnel 1,027,640
Materials & Services 104,389
Capital Outlay -
Total Civil/Special Units 1,132,029
Automotive/Communications
Personnel 400,169
Materials & Services 1,265,667
Capital Outlay 35,750
Total Automotive/Communications 1,701,586
Investigations/Evidence
Personnel 1,277,983
Materials & Services 140,761
Capital Outlay -
TotallnvestigationsJEvidence 1,418,744
Patrol
Personnel 7,450,178
Materials & Services 547,770
Capital Outlay 249,274
Total Patrol 8,247,222
Records
Personnel 659,297
Materials & Services 101,963
Capital Outlay -
Total Records 761,260
Adult Jail
Personnel 11,899,534
Materials & Services 2,069,651
Capital Outlay 63,176
Transfer Out -Jail (D/S & Cap Proj) 244,752
Total Adult Jail 14,277,113
Court Security
Personnel 284,173
Materials & Services 10,390
Capital Outlay -
Total Court Security 294,563
Emergency Services
Personnel 169,170
Materials & Services 25,718
Capital Outlay -
Total Emergency Services 194,888
Special Services
Personnel 1,152,258
Materials & Services 183,769
Capital Outlay 16,500
Total Special Services 1,352,528
Training
Personnel 385,634
Materials & Services 121,303
Capital Outlay -
Total Training 506,938
Other Law Enforcement Services
Personnel 731,122
Materials & Services 70,773
Capital Outlay -
Total Other Law Enforcement SVC5 801,895
Non-Departmental
Materials & Services 81,701
Total Non-Departmental 81,701
Total Expenditures $ 33,078,650
FY 2015 -Year to
Date (16.7% of Year)
Actual I Budget
$ 5,729,121
223,315
203,424
-
426,739
183,484
12,865
-
196,350
65,781
345,185
-
410,966
236,548
45,106
-
281,655
1,225,839
110,316
15,065
1,351,220
109,023
6,017
-
115,040
2,043,341
248,765
-
136,000
2,428,106
49,288
3,965
-
53,253
23,757
3,097
-
26,854
208,976
12,816
-
221,792
66,172
3,290
-
69,463
106,428
22,275
6,849
135,552
12,134
12,134
16%
20%
0%
17%
17%
11%
0%
16%
16%
23%
0%
22%
16%
29%
0%
17%
16%
17%
4%
16%
16%
6%
0%
14%
16%
12%
0%
33%
16%
17%
39%
0%
18%
16%
10%
0%
15%
16%
6%
0%
13%
16%
2%
0%
13%
15%
27%
96%
17%
17%
17%
Budget
1,431,828
1,020,745
15,100
2,467,673
1,073,870
119,010
100
1,192,980
399,334
1,486,931
100
1,886,365
1,470,106
157,597
100
1,627,803
7,728,332
636,868
340,500
8,705,700
692,244
106,461
100
798,805
12,675,178
2,039,314
20,900
408,765
15,144,157
292,715
10,052
100
302,867
147,942
29,810
100
177,852
1,273,721
223,703
158,000
1,655,424
416,955
134,263
100
551,318
717,594
81,310
7,140
806,044
72,813
72,813
FY 2015
T Projection I $ Variance
1,431,828
1,020,745
15,100
2,467,673
1,073,870
119,010
100
1,192,880 100
399,334
1,486,931
100
1,886,265 100
1,470,106
157,597
100
1,627,703 100
7,728,332
636,868
340,500
8,705,700
692,244
106,461
100
798,705 100
12,675,178
2,039,314
20,900
408,765
15,144,157
292,715
10,052
100
302,767 100
147,942
29,810
100
177,752 100
1,273,721
223,703
158,000
1,655,424
416,955
134,263
100
551,218 100
717,594
81,310
7,140
806,044
72,813
72,813
16% $ 35,389,801 $ 35,389,101 $ 7~0age 4
LED #1 • Countywide
Statement of Financial Operating Data
Through August 31, 2014
Revenues
Tax Revenues -Current
Tax Revenues -Prior
SB 1145
Sheriff Fees
Concealed Handgun License
Jail Funding HB 3194
Jail Funding HB 2712
State Grant
Prisoner Housing
Inmate Telephone Fee
Federal Grants
Work Center Work Crews
Contracts with Des County
Inmate Commissary Fees
Interest
Donations-"Shop with a Cop"
Miscellaneous
Total Operating Revenues
EXPENDITURES & TRANSFE
DC Sheriff's Office
DC Comm Systems Reserve
Transfer to Reserve Fund
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
FY 2015 -Year to Date
FY2014 (16.7% of Year)
Actual Actual I Budget
16,698,208 -0% a)
532,040 120,592 33%
1,630,823 -0%
365,577 58,016 28%
-25,581 17%
107,806 107,805 100%
36,311 9,057 20%
85,781 -0%
329,918 -0%
83,297 4,418 6%
32,071 -0%
69,723 5,793 12%
475,815 388 1%
32,480 2,445 10%
50,563 5,265 13%
38,361 29,968 46%
66,441 3,081 5%
20,635,256 372,408 2%
RS
20,817,324 3,601,208 14%
80,000 -0%
100,000 -0%
20,997,283 3,601,208 14%
(362,027) (3,228,800)
6,507,110 6,145,083 117%
$ 6,145,083 $ 2,916,283
a) Current year taxes received beginning in October
FY2015
Budget I Projection I $ Variance
17,292,244 17,292,244
360,700 360,700
1,628,947 1,628,947
210,000 210,000
150,000 150,000
107,806 107,806
46,143 46,143
85,370 85,370
80,000 80,000
80,000 80,000
20,000 20,000
50,000 50,000
60,632 60,632
25,000 25,000
40,000 40,000
65,000 65,000
64,000 64,000
20,365,842 20,365,842
25,428,019
80,000
100,000
22,287,066
80,000
100,000
3,140,953
25,608,019 22,467,066 3,140,953
(5,242,177) (2,101,224) 3,140,953
5,242,177 6,145,083 902,906
$ $ 4,043,859 $4,043,859
Page 5
lED #2 -Rural 702
Statement of Financial Operating Data
Through August 31,2014
FY 2015 -Year to Date
FY2014 (16.7% of Year)
I BudgetActual Actual
Revenues
Tax Revenues -Current
Tax Revenues -Prior
Des CtyTransient Room Tax
City of Sisters
Marine Board License Fee
State Grant
Court Fines &Fees
Contracts with Des County
US Forest Service
School Districts
Federal Grants
Bureau of Reclamation
Interest
SB #1065 Court Assessment
Federal Grants-BlM
Donations & Grants -Private
Miscellaneous
Total Revenues
EXPENDITURES & TRANSFERS
DC Sheriffs Office
DC Comm Systems Reserve
Transfer to Reserve Fund
7,988,657 -0% a)
262,227 58,565 35%
338,546 12%2,838,797
486,678 87,168 17%
155,221 -0%
124,246 -0%
135,023 22,220 17%
20,025 16%119,984
-0%101,375
65,088 -0%
84,285 2,132 5%
24,023 -0%
21,715 2,824 13%
3,974 26%17,435
-0%16,213
12,030 7,030 n/a
73,333 4,259 6%
12,526,331 546,744 4%
12,278,716 2,127,913 14%
120,000 -0%
100,000 -0%
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance $
12.498,716
27,614
3,046,683
3,074,297
2,127,913
(1,581,170)
3,074,297
$ 1,493,128
14%
127%
a) Current year taxes received beginning in October
FY 2015
Budget I Projection I $ Variance
8,272,852 8,272,852
169,000 169,000
2,920,654 2,920,654
523,010 523,010
169,000 169,000
130,600 130,600
130,000 130,000
121,650 121,650
76,500 76,500
55,000 55,000
42,000 42,000
27,000 27,000
21,000 21,000
15,000 15,000
10,000 10,000
7,030 7,030
68,500 68,500
12,751,766 12,758,796 7,030
14,948,526
120,000
100,000
13,102,035
120,000
100,000
1,846,491
15,168,526 13,322,035 1,846,491
(2,416,760) (563,239) 1,853,521
2,416,760 3,074,297 657,537
$ $ 2,511,059 $2,511,059
Page 6
PUBLIC HEALTH
Statement of Financial Operating Data
Through August 31,2014
FY 2014
FY 2015 -Year to
Date (16.7% of Year)
Actual Actual
I %of Budget
2,878,140 166,420 5%
767,248 39,382 5%
812,441 115,019 18%
400,900 29,662 5%
95,011 260,206 210%
139,171 6,496 3%
232,968 25,814 13%
229,520 -0%
161,576 61,406 60%
100,535 30,095 30%
80,653 8,186 10%
92,637 3,438 5%
36,655 5,565 14%
52,433 -0%
9,077 2,144 36%
38,192 49,507 3300%
10,135
6,137,293
6,457,193
2,043,710
-
157,320
8,658,223
(2,520,930)
20 1%
803,360 13%
1,125,227 16%
260,731 13%
-0%
-0%
1,385,958 15%
(582,597)
2,701,475 450,246 17%
33,000 -nfa
65,100
2,799,575
278,645
-0%
450,246 16°fc,
(132,351 )
$
1,273,934
1,552,578
1,552,578 99%
$ 1,420,227
FY 2015
Budget I Projection I$ Variance
Revenues
State Grant a)
Environmental Health-Lic Fac
OMAP
Family Planning Exp Proj
Interfund Grants & Contract
Grants (lntergvt, Pvt, & Local)
Patient Insurance Fees
State Miscellaneous
Federal Payments
Vital Records-Death
Health Dept/Patient Fees
Contract Payments
Vital Records-Birth
Child Dev & Rehab Center
Interest on Investments
Grants & Donations
Miscellaneous
Total Revenues
Expenditures
Personnel Services b)
Materials and Services c)
Capital Outlay
Transfers Out
Total Expenditures 9,359,556 9,430,160 (70,604)
Revenues less Expenditures
Transfers In-General Fund
Transfers In-PH Res Fund
Transfers In-Gen. Fund Other
3,156,998
779,450
655,250
550,000
123,618
240,000
196,400
120,336
101,585
100,000
80,216
69,291
41,000
39,609
6,000
1,500
2,800
6,264,053
7,166,528
2,028,288
100
164,640
3,049,902 (107,096)
779,450
625,250 (30,000)
550,000
363,024 239,406
210,279 (29,721)
196,400
120,336
162,991 61,406
100,000
80,216
3,438 (65,853)
41,000
39,609
6,000
49,507 48,007
2,800
6,380,202 116,149
6,945,515 221,013
2,320,005 (291,717)
100
164,640
(3,095,503)
2,701,475
(3,049,958)
2,701,475
45,545
65,100 65,100
Total Transfers In 2,766,575 2,766,575
Change in Fund Balance (328,928) (283,383) 45,545
Beginning Fund Balance 1,570,821 1,552,578 ~18,243}
Ending Fund Balance $ 1,241,893 $ 1,269,195 $ 27,302
a) Oregon Health Authority grant projected at amended contract amount
b) Personnel projected to decrease in FTE -appropriation transfers pending
c) M & S increased to reflect amended grants and contracts
Page 7
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Through August 31,2014
Actual
Revenues
FY 2015 -Year to
FY2014 Date (16.7% of Year)
Administrative Fee 8,260,932
State Grants 7,801,239
OHP Capitation 469,069
Federal Grants 184,980
Patient Fees 219,846
Title 19 246,484
Liquor Revenue 142,665
Divorce Filing Fees 129,788
Interfund Contract-Gen Fund 127,000
School Districts 6,952
Federal Grant (ARRA) 63,750
Interest on Investments 21,190
Rentals 16,000
Marriage Licenses 6,540
Local Grants 52,891
Claims Reimbursment 12,918
State Miscellaneous 31,820
Justice Reinvestment HB3194 120,000
Miscellaneous 28,157
Total Revenues 17,942,221
Expenditures
Personnel Services 12,415,866
Materials and Services 6,738,744
Capital Outlay
Transfers Out 204,900
Total Expenditures 19.359.510
Revenues less Expenditures (1,417,289)
Transfers In-General Fund 1,377,302
Transfers In-Acute Care Svcs 293,593
Total Transfers In 1,670,895 260.816
Change in Fund Balance 253,606
Beginning Fund Balance 2,671,137
Ending Fund Balance $2,924.742
I %of
Actual Budget
1,848,462
1,426,546
-
-
35,280
48,941
-
21,413
-
-
-
5,083
500
2,090
329,450
-
5,100
-
1,430
16%
19% a)
0%
0%
17%
27%
0%
15%
0%
0%
0%
26%
3%
32%
n/a
n/a
n/a
n/a
27%
FY 2015
Budget I Projection I $ Variance
11,210,767 11,210,767
7,499,586 9,216,197 1,716,611
390,000 390,000
204,849 204,849
201,610 201,610
180,300 180,300
151,000 151,000
140,600 140,600
127,000 127,000
65,000 50,000 (15,000)
34,000 34,000
19,500 19,500
18,800 18,800
6,500 6,500
329,450 329,450
5,100 5,100
5,318 5,318
3.724,294 17% 20,254,830 22,290,991 2,036,161
2,273,396 15% 14,762,595 14,762,595
831,021 12% b) 6,989,403 8,548,208 (1,558,805)
-0% 100
-0% 204,900 204,900
3.104.417 14% 21,956,998 23,515,703 (1,558,705)
619.877 (1,702,168) (1.224,712) 477,456
229,550 17% 1,377,302 1,377,302
31,266 17% 187,594 187,594
17% 1,564.896 1,564,896
880,693 (137,272) 340,184 477,456
2,924,742 88% 3,313,248 2,924,742 {388,506~
$3,805,436 $3,175,976 $3,264.926 $ 88,950
a) Oregon Health Authority grant projected at amended contract amount
b) M &S increase related to Oregon Health Authority amended contract
Page 8
100
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Through August 31,2014
FY 2015 -Year to
FY 2014 Date (16.7% of Year)
I %of
Actual
Revenues
Admin-Operations 40,102
Admin-GIS 2,944
Admin-Code Enforcement 261,188
Building Safety 1,748,911
Electrical 408,194
Contract Services 229,039
Env Health-On Site Prog 448,367
Planning-Current 917,674
Planning-Long Range 440,222
Total Revenues 4,496,641
Expenditures
Admin-Operations 1,587,119
Admin-GIS 123,751
Admin-Code Enforcement 275,521
Building Safety 688,035
Electrical 217,271
Contract Services 220,779
Env Health-On Site pgm 181,831
Planning-Current 666,180
Planning-Long Range 425,323
Transfers Out (DIS Fund) 179,035
Total Expenditures 4,564,845
Revenues less Expenditures (68,204)
Transfers In/Out
In: General Fund -LlR Planning 495,360
Out: CDD Reserve Funds 3,660
Total Transfers In/Out 491,700
Change in Fund Balance 423,496
Beginning Fund Balance 1,578,705
Ending Fund Balance $2,002,201
Actual Budget
8,829
60
57,645
401,722
82,466
42,000
78,407
253,557
90,728
1,015,414
358,462
21,890
45,756
114,470
35,239
45,795
36,332
143,648
62,720
-
864,313
151,101
27,795
-
17%
2%
21%
25%
20%
20%
18%
28%
16%
23%
25%
17%
15%
14%
15%
16%
13%
20%
11%
0%
18%
17%
0%
FY 2015
Budget I Projection I $ Variance
51,225 51,225
2,500 2,500
273,000 273,000
1,616,713 1,616,713
418,506 418,506
211,500 211,500
437,358 437,358
902,876 902,876
560,658 560,658
4,474,336
1,416,868
129,011
297,852
822,664
234,152
281,699
274,228
706,730
553,993
173,673
4,474,336
1,416,868
129,011
297,852
822,664
234,152
281,699
274,228
706,730
553,993
173,673
4,890,870 4,890,870
(416,534) (416,534)
166,770 166,770
(861,143) (861,143)
27,795 (694,373) (694,373)
178,896 (1,110,907) (1,110,907)
2,002,201 126% 1,589,113 2,002,201 413,088
$2,181,097 $ 478,206 $ 891,294 $ 413,088
Page 9
ROAD
Statement of Financial Operating Data
Through August 31,2014
Actual
Revenues
Motor Vehicle Revenue 11,300,058
Forest Receipts 1,259,367
Federal -PIL T Payment 1,064,365
Other Inter-fund Services 850,395
Cities-Bend/Redmond/Sisters 1,097,444
State Miscellaneous 588,197
Sale of Equip & Material 230,017
Assessment Payments (P&I) 15,058
Mineral Lease Royalties 206,097
Interest on Investments 49,562
Miscellaneous 117,069
Total Revenues 16,777,629
Expenditures
Personnel Services 5,313,126
Materials and Services 8,051,744
Debt Service
Capital Outlay 121,455
Transfers Out 450,000
Total Expenditures 13,936,325
Revenues less Expenditures 2,841,304
Trans In -Solid Waste 282,148
Trans In -Transp SDC
Trans In-Road Imp Res
Total Transfers In 282,148
Change in Fund Balance 3,123,452
Beginning Fund Balance 6,846,576
Ending Fund Balance $ 9,970,028
a) Payment received annually in February
b) PILT payment received July 2014
c) Inter-fund service billed at year end
FY 2014
FY 2015 -Year to
Date (16.7% of Year)
I
$ 9,699,228
FY 2015
'fa ot
Actual Budget Budget I Projection I $ Variance
1,727,398 15% 11,220,000 11,220,000
130 0% a) 1,140,950 1,140,950
1,250,809 123% b) 1,020,000 1,250,809 230,809
-0% c) 971,700 971,700
-0% 804,200 804,200
7,606 1% 602,629 602,629
45,866 17% 271,000 271,000
24,893 11% 225,840 225,840
6,251 4% 140,000 140,000
11,883 37% 32,000 32,000
7,182 28% 25,500 25,500
3,082,020 19% 16,453,819 16,684,628 230,809
920,510 17% 5,555,695 5,555,695
1,397,721 13% 10,622,604 10,622,604
106,578 91% d) 117,000 106,578 10,422
928,010 10% 8,875,507 8,875,507
-0% 600,000 600,000
3,352,819 13% 25,770,806 25,760,384 10,422
(270,800) (9,316,987) (9,075,756) 241,231
-0% e) 298,156 298,156
-0% 2,000,000 2,000,000
-0% 1,000 {1,OOOl . 0% 2,299,156 2,298,156 (1,000)
(270,800) (7,017,831) (6,777,600) 240,231
9,970,028 111% 8,954,332 9,970,028 1,015,696
$ 1,936,501 $3,192,428 $1,255,927
d) Final payments of two LID loans made in July 2014
e) Transfers made quarterly
Page 10
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Through August 31,2014
FY 2014
Actual
Revenues
SB 1145 3,028,672
DOC Measure 57 220,788
Electronic Monitoring Fee 235,642
Probation Superv. Fees 208,461
Interfund -Sheriff 50,000
Crime Prevention Grant 50,000
CFC-Domestic Violence 70,242
State Subsidy 14,677
Alternate Incarceration 17,725
Interest on Investments 7,807
Probation Work Crew Fees 9,137
State Miscellaneous 4,142
Leases 1,323
Claims Reimbursement 6,997
Justice Reinvest HB3194 458,143
Miscellaneous 671
Total Revenues 4,384,428
Expenditures
Personnel Services 3,343,789
Materials and Services 1,107,365
Capital Outlay
Total Expenditures 4,451,154
Revenues less Expenditures (66,726)
Transfers In-General Fund 451,189
Change in Fund Balance 384,463
Beginning Fund Balance 747,520
Ending Fund Balance $ 1,131,982
FY 2015 -Year to
Date (16.7% of Year) FY 2015I%of
Budget I PrOjection I $ VarianceActual Budget
-0% a) 3,025,187 3,025,187
217,845 99% b) 220,788 217,845 (2,943)
38,771 18% 220,000 220,000
33,584 18% 190,000 190,000
8,334 17% 50,000 50,000
-0% c) 50,000 50,000
-0% c) 47,996 47,996
-0% a) 15,158 15,158
-0% d) 15,000 15,000
1,260 20% 6,150 6,150
2,135 43% 4,950 4,950
-0% e) 4,301 4,301
-0% 1,500 1,500
-n/a
-n/a
168 34% 500 500
302,097 8% 3,851,530 3,848,587 (2,943)
583,167 16% 3,623,526 3,623,526
110,978 10% 1,148,766 1,148,766
-0% 100 100
694,145 15% 4,772,392 4,772,292 100
(392,048) (920,862) (923,705) (2,843)
75,198 17% 451,189 451,189
(316,850) (469,673) (472,516) (2,843)
1,131,982 110% 1,030,824 1,131,982 101,158
815,132 $ 561,151 $ 659,466 $ 98,315$
a) Contract with Dept of Corrections. Payment expected in September includes State Subsidy
b) Annual payment received in July
c) Payment received quarterly
d) Invoiced quarterly
e) Annual payment expected in February
Page 11
EARLY LEARNING HUB
Statement of Financial Operating Data
Through August 31,2014
Revenues
Federal Grants
Title IV -Family Sup/Pres
HealthyStart Medicaid
Youth Investment
State Grant
HealthyStart /R-S-G
OCCF Grant
Charges for Svcs-M isc
Program Fees
Miscellaneous
Court Fines &Fees
Interest on Investments
Donations
Private Grant
Sale of Assets
Interfund Grants
Total Revenues
Expenditures
Personnel Services
Materials and Services
Total Expenditures
Revenues less Expenditures
Transfers In
General Fund
General Fund -Other
Total Transfers In
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
FY 2015 -Year to
Date (16.7% of Year)FY 2014
I %of
Actual BudgetActual
258,463
21,994
60,561
124,493
55,185
249,125
132,326
4,138
4,710
77,873
2,868
50
130
450
329,624
-
-
-
-
-
-
-
-
-
-
12,848
461
-
-
-
-
0%
0%
0%
nfa
nfa
0%
0%
nfa
nfa
0%
17%
18%
nfa
nfa
nfa
0%
1,321,991 13,308 2%
501,770 42,259 16%
1,402,021 20,363 3%
1,903,791 62,622 6%
(581,800) (49,314)
278,739 42,048 17%
89,350 -0%
FY 2015
Budget I Projection I $ Variance
a) 157,390
21,994
60,000
a) 254,623
a) 39,499
2,000
77,086
2,500
7,260
157,390
21,994
60,000
254,623
39,499
2,000
77,086
2,500
7,260
622,352 622,352
258,410 258,410
766,142 766,142
1,024,552 1,024,552
(402,200) (402,200)
252,288
89,350
252,288
89,350
42,048 12% 341,638 341,638368,089
(213,711) (7,266) (60,562) (60,562)
548,572 334,861 105% 318,121 334,861 16,740
$ 334,861 $ 327,596 *' $ 257,559 $ 274,299 $ 16,740
Page 12
SOLID WASTE
Statement of Financial Operating Data
Through August 31, 2014
3% a)
5% b)
0% c)
0% d)
0% d}
Operating Revenues
Franchise Disposal Fees
Private Disposal Fees
Commercial Disp. Fees
Franchise 3% Fees
Yard Debris
Recyclables
Special Waste
Interest
Leases
Miscellaneous
Total Operating Revenues
Operating Expenditures
Personnel Services
Materials and Services
Debt Service
Capital Outlay
Total Operating Expenditures
Operating Rev less Exp
Transfers Out
Road
SW Capital Reserve
Total Transfers Out
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
a} Payments due April 15th
b} Unpredictable revenue
c} Payments made November and May
d) Transfers will be made quarterly
FY2014
FY 2015 -Year to
Date (16.7% of Year)
Actual Actual
I %of
Budget
4,209,029 827,915 19%
1,518,056 321,566 21%
1,076,538 230,804 21%
210,053 6,097
98,410 25,812 28%
33,345 10,067 22%
40,873 1,250
11,028 2,554 26%
10,801 1,800 17%
21,508
7,229,641
4,748 24%
1,432,612 19%
1,777,663 304,079 16%
3,214,375 282,203 8%
930,157 -
25,895
5,948,091
1,281,550
282,148
-0%
586,282 9%
846,330
-
545,000
827,148
454,402
-
-0%
846,330
$
1,224,767
1,679,169
1,679,169 118%
$2,525,499
FY2015
Budget 1Projection I $ Variance
4,413,809 4,413,809
1,550,430 1,550,430
1,082,144 1,082,144
210,000 210,000
92,000 92,000
45,000 45,000
25,000 25,000
10,000 10,000
10,801 10.801
20,000 20,000
7,459,184 7,459,184
1,891,970
3,435,926
929.794
227,000
6,484,690
974,494
1,891,970
3,435,926
929,794
227.000
6,484,690
974,494
298,156 298,156
1,525,000 1,525,000
1,823,156 1,823,156
{848,662} {848,662}
1,428,003 1.679,169 251.166
$ 579,341 $ 830,507 $ 251,166
Page 13
RISK MANAGEMENT
Statement of Financial Operating Data
Through August 31, 2014
Revenues
Inter-fund Charges:
General Liability
FY 2014
FY 2015 -Year to Date
(16.7% of Year)
Actual Actual I %ofBudget
272,823 63,298 17%
326,526 65,384 17%
164,150 29,592 17%
1,520,352 260,290 17%
318,566 53,668 17%
139,123 6,712 34%
1,400 305 23%
14 -0%
27,540 2,610 11%
15,567
2,786,061
3,250 22%
485,109 17%
268,561 33,118
49,872 638
33,139 168
161,994 156,747
4,659 125
5,619 -
4,531
528,374
166,668
211,158
377,826
875
3,584
194,379 49%
178,556
830
179,386 72%
-
205 19
22,021 528
69,276
92,377
478,204
10,374
10,920 9%
71,912
5,000 -
155,474 103,790
44,261 8,476
52,488
735,427
102,324
1,836,329
324,005
146,109
2,306,443
-
184,178 31%
-0%
568,864 36%
50,081 15%
20,864 10%
639,810 30%
479,618 (154,701)
2,631,057 3,110,676 101%
$3,110,676 $2,955,975
379,793 379,793
392,304 392,304Property Damage
177,550 177,550Vehicle
1,561,804 1,561,804Workers' Compensation
317,000 317,000Unemployment
20,000 20,000Claims Reimb-Gen Liab/Property
1,300 1,300Process Fee-Events/Parades
Miscellaneous 110 110
24,000 24,000Skid Car Training
15,050 15,050Interest on Investments
2,888,911 2,888,911TOTAL REVENUES
Direct Insurance Costs:
GENERAL LIABILITY
Settlement I Benefit
Defense
Professional Service
Insurance
a)
Loss Prevention
Miscellaneous
Repair I Replacement
Total General Liability 400,000 400,000
PROPERTY DAMAGE
Insurance a)
Repair I Replacement
Total Property Damage
250,000 250,000
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair I Replacement
Total Vehicle 120,000 120,000
WORKERS' COMPENSATION
Settlement I Benefit
Professional Service
Insurance a)
Loss Prevention
Miscellaneous
Total Workers' Compensation 600,000 600,000
200,000 180,000 20,000UNEMPLOYMENT -Settlement/Benefits
1,570,000 1,550,000 20,000Total Direct Insurance Costs
Insurance Administration:
Personnel Services 330,406 330,406
199,140 199,140Materials & Srvc, Capital Out. & Tranfs.
2,099,546 2,079,546 20,000Total Expenditures
789,365 809,365 20,000Change in Fund Balance
3,074,957 3,110,676 35,719Beginning Fund Balance .. $ 3,864,322 $ 3,920,041 $ 55,719Ending Fund Balance
FY2015
Budget 1 Projection I $ Variance
a) Annual premiums paid in July
Page 14
DESCHUTES COUNTY 9-1-1
Statement of Financial Operating Data
Through August 31, 2014
FY 2014
Actual
Revenues
Property Taxes -Current 6,258,760
Property Taxes -Prior 203,163
Federal Grants 46,514
State Reimbursement 41,813
Telephone User Tax 756,775
Data Network Reimb. 43,943
Jefferson County 29,758
User Fee 53,229
Police RMS User Fees 236,717
Contract Payments 39,075
Miscellaneous 45,553
Claims Reimbursement 29,857
Interest 40,303
Total Revenues 7,825,460
Expenditures
Personnel Services 4,420,333
Materials and Services 1,996,805
Capital Outlay 66,498
Total Expenditures 6,483,636
Revenues less Expenditures 1,341,824
Transfers Out -Reserve Fund 7,800,000
Change in Fund Balance (6,458,176)
Beginning Fund Balance 10,398,030
Ending Fund Balance $ 3,939,854
FY 2015 -Year to Date
(16.7% of Year) FY2015
Actual
I %ot
Budget Budget I Projection I$ Variance
-0% a) 6,482,015 6,482,015
45,252 33% 138,000 138,000
-0% 150,000 150.000
5,369 15% 36,000 36,000
-0% 750.000 750,000
-0% 30,000 30,000
304 1% 30,000 30,000
-0% 45,000 45,000
5,191 2% 295,788 295,788
-0% 11,000 11,000
3,621 40% 9,000 9,000
-nla
3,714 12% 30,600 30,600
63.451 1% 8.007,403 8,007,403
781,811 14% 5,521,419 5,521,419
425,476 20% 2,077,868 2,077,868
-0% 350,000 350.000
1,207,287 15% 7,949,287 7,949,287
(1,143,835) 58,116 58,116
-nla
(1,143,835) 58,116 58,116
3,939,854 116% 3,410,000 3,939,854 529.854
2,796,018 $ 3,468,116 $3,997,970 $ 529,854$
a) Current year taxes received beginning in October
Page 15
Revenues:
Internal Premium Charges
Part-Time Employee Premium
Employee Monthly Co-Pay
COIC
Retiree f COBRA Co-Pay
Prescription Rebates
Claims Reimbursements
Miscellaneous
Interest
Total Revenues
Expenditures:
Personnel Services (all depts)
Materials & Services
Admin &Wellness
Claims Paid-Medical
Claims Paid-Prescription
Claims Paid-DentallVision
Claims RefundS
Stop Loss Insurance Premium
State Assessments
Administration Fee (EMBS)
Preferred Provider Fee
Health Impact
Other -Administration
Other -Wellness
Admin & Wellness
Deschutes On-site Clinic
Contracted Services
Medical Supplies
Other
Total DOC
Deschutes On-site Pharmacy
Contracted Services
Medication and Drugs
Other
Total Pharmacy
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Health Benefits Trust
Statement of Financial Operating Data
FY 2015
Two Months Ended August 31, 2014
FY2014 FY2015
Actual
Year to Date
Actual (1 •.7% ~
of Year)
Budget Projection $ Variance
$ 14,485,502
16.955
813.125
1.595,847
1,061,986
154,981
1.675
744
67,057
$ 2.639.935 17% a) $15.517,000
5,473 27% b) 20.000
142.670 18% b) 810.000
296,025 18% b) 1.670,000
179,614 14% b) 1.260,000
-0% 110,000
-0% 50,000
-nfa -
13,403 19% 72,000
$15.848,484 $ 331,484
32,838 12,838
856,020 46.020
1,776,148 106,148
1.077,683 (182,317)
110.000 -
SO,OOO -
--
72,000 -
18,197,871 3,277,120 17% 19,509,000 19,823,173 314,173
129,509 21,049 15% 144.917 144,917
117.775 32,929 17% 195,970
14,726,294 2,300,201 14% 16,385,812
850,209 110.681 12% 943,500
54,806 7,415 21% 35,000
27,016 2,655 10% 26,777
932,031 120,750 12% 1,005,277
314,801 18.590 6% 306,000
1,588,726 -0% 1,696,000
13,250 2,079 16% 13.321
12,552,108
709,494
1,868,398
(24,842) 24,842
400,000
215.000
343,000
57,200
4,500 -
40,142 -
195,970 -
16,360,970 24,842
943,500 -
35,000 -
26.777 -
11,633,134
657,550
1,731.608
(182,448)
275.052
67,753
333,188
49.712
4,327
38,643
1,753,273 14% 12,552,108
104,226 15% 709,494
299,257 16% 1.868,398
-
(24.842) nfa
50,235 130/0 400,000
0% 215,000
61,443 18% 343,000
7,425 13% 57,200
0% 4,500
16,255 40% 40,142
-
1,005,277 -
306.000 -
1.696.000 -
13.321 -
1,916,777
17,704.610
493,261
11,967,822
20,670
2,462.671
814,449
$ 12,461,082
1%
13%
108%
2,015,321
19.551.327
(42,327)
11.585,710
2,015!321
19.526.485
296.688
12,461.082
-
24,842
339.015
875,372
$ 12,461,082 $ 13,275,531 $11,543,383 $12,757,770 $1,214,387
I % Of Exp covered by Revenues 102.8% 133.1% 99.8%1 101.5%
a) Projection is amount budgeted as HealthiDentallnsurance expenditure.
b) Year to Date annualized. Page 16
FAIR AND EXPO CENTER
Statement of Financial Operating Data
Through August 31,2014
FY 2015 -Year to Date
(16.7% of Year FY2015FY 2014
Actual % of Budget Budget I Projection I $ Variance Actual
Operating Revenues
Events Revenues
Storage
Camping at F & E
Horse Stall Rental
Concession % -Food
Annual County Fair (net)
Miscellaneous
Total Operating Revenues
$ 458,147
35,590
22,866
52,084
97,917
205,000
6,648
878,251
Operating Expenditures:
Personnel Services
Materials and Services
Total Operating Expenditures
895,582
657,882
1,553,464
Results of Operations (675,213)
Non-Operating Revenues
Transfer-General Fund
Transfer-Room Tax -(Fund 160)
Transfer-Fair & Expo Reserve
Interest
Grants
Rights & Signage
Total Non-Operating Revenues
374,186
262,900
100,000
409
176,289
72,000
985,784
Non-Operating Expenditures
Debt Service
Capital Outlay
Total Non-Operating Expenditures
112,974
176,289
289,263
TRT - 1 % for Marketing
Revenues (Fund 170)
Less: Expenditures
Net TRT 1% for Marketing
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
$ 140,297 22.4% $ 625,000 $ 625,000 $
0.0% 45,000 45,000
140 0.9% 16,000 16,000
15 0.0% 52,769 52,769
11,411 6.5% 175,000 175,000
0.0% a) 200,000 200,000
2,791 35.3% 7,900 7,900
154,654 13.8% 1,121,669 1,121,669
154,165 16.6% 926,183 926,183
77,264 15.2% 508,386 508,386
231,429 16.1% 1,434,569 1,434,569
(76,776) (312,900) (312,900)
60,834
20,316
72
17,600
16.7%
18.7%
n/a
n/a
n/a
22.0%
365,000
108,544
80,000
365,000
108,544
72
80,000
98,821 17.9% 553,544 553,616
0.0% 112,213 112,213
0.0% 100 100
0.0% 112,313 112,213 100
0.0% 292,333 292,333
1.1% 288,850 288,850
3,483 3,483
131,814 131,986 100
-0.4% 87,000 ~345l {87,345}
$ 218,814 $ 131,640 $ (87,245)
a) Revenues and Expenses for the annual fair recorded in a separate fund and the available
net income is transferred to the Fair & Expo Center Fund
Page 17
JUSTICE COURT
Statement of Financial Operating Data
Through August 31,2014
FY 2014
Actual
Revenues
Court Fines & Fees 425,632
State Miscellaneous
Interest on Investments 653
Total Revenues 426,285
Expenditures
Personnel Services 407,456
Materials and Services 183,148
Total Expenditures 590,605
Revenues less Expenditures (164,319)
Transfers In-General Fund 140,819
Change in Fund Balance (23,500)
Beginning Fund Balance 153,818
Ending Fund Balance $ 130,317
FY 2015 -Year to
Date (16.7% of Year)
I % of
Actual Budget
FY2015
Budget I Projection I $ Variance
35,923 8% 450,000 443,838 (6,162)
-0% 600 600
103 13% 815 815
36,026 8% 451,415 445,253 (6,162)
66,417 16% 416,045 416,045
44,196 27% a) 166,093 140,177 25,916
110,613 19% 582,138 556,222 25,916
(74,586) (130,723) (110,969) 19,754
12,400 17% 74,398 74,398
(62,186) (56,325) (36,571) 19,754
130,317 121% 107,621 130,317 22,696
$ 68,131 $ 51,296 $ 93,746 $ 42,450
a) $25,000 in software maintenance paid out in July
Page 18
-
CAPITAL PROJECTS
• Campus Improvement
• Jail Project
• North County Campus
• Sisters Health Clinic
~~, ::.4;;;.,.4,,*,( 'Wi JC¥ 4if'N. ;;PC*,,,,,",!,!'b;:<-''f'" ""WjIiWiI:,;:; J, (ii".jf., ,i~Hii. J,t V"'I'!¢III'fl'}lAM41
-Deschutes County
Campus Improvement (Fund 463)
Inception through August 31. 2014
Completed Projects
JRF 91512014
4# Y,"",Q4i"IIi$,-If*1fIl(lI, *\'"\ 4 ;,$*41'.;;;; Z zt,.$¥i$(,W:; 1-1..%.# ..#,;4.»414 \E~ ii4e Id '.;;-'*;:;<9 jaw "" "F
Deschutes County
Jail Project (Fund 456) -Phase II-Beginning July 1, 2012 Through August 31, 2014
Project Budget
(Note 1)
Actual
(Through
August 31,
2014)
Committed Projected
Total (Actual
+ Committed
+ Projected}
Variance
Resources
Interest
Transfers In:
General County Projects (142)
General Capital Reserve (143)
General Fund (001)
Sheriff's Office (FY 2015)
Jamison Acq &Remodel (457) (Note 2)
Bond Issuance, net
Total Resources
Expenditures
Architect (Note 2)
Engineering
Environmental
Surveying
Consulting
Building &Grounds
Fees & Permits, SDCs (water & sewer)
Insurance
Internal Service Fund Charges
Miscellaneous Administrative
FF & E -Security System
FF &E -Storage System
Construction -Expansion & Remodel (3)
Construction Contingency
Total Expenditures
Net
$ 26,157 $ 41,344 $ $ 500 $ 41,844 15,687
100,000 240,000
1,250,000 1,250,000
750,000 750,000
136,000
540,939 540,939
8,400,000 8,403,481
240,000 140,000
1,250,000
7SO,OOO
136,000 136,000
540,939
8,403,481 3,481
11,067,096 11,361,764 500 11,362,264 295,168
820,000
35,000
310,000
40,000
33,700
30,000
25,000
9,473,396
300,000
11,067,096
926,465
37,272
593
500
6,051
9,127
337,189
7,938
41,744
9,881
75,117
8,944,132
10,396,009
11,355
907,868
919,223
$ $ 965,756 $ (919,223)
937,819 (117,819)
5,388 42,660 (42,660)
593 (593)
SOO (500)
7,254 13,305 21,695
9,127 (9,127)
337,189 (27,189)
7,938 32,062
41,744 (8,044)
9,391 19,272 10,728
75,117 (75,117)
25,000 25,000
9,852,000 (378,604)
300,000
47,033 11,362,264 (295,168)
(46,533) 0 o
Note 1: The project includes the Jail expansion and a remodel for the Medical Unit
Note 2: Steele: Jail-$699,000, Other-$115,400. KMD: Medical-$86,000, Housing Study-$21 ,000. Plus expenses.
Note 3: Original contract with KNCC-$9,593,276. Change Order #1-$143,482 (Generator-$32,019, Water Closet
controls-$91 ,496 & Bunk Bed Reconfiguation-$19,967) Change Order #2-$115,242 (Addenda 5 & 6-$29,514,
Rated Glazing Assemblies-$75,274, Conduit to Expansion-$10,454)
JRF 9/5/2014
Deschutes County
North County -Design Center (Hwy 97), Antler and Unger
Inception through August 31,2014
...
JRF 9/5/2014
Deschutes County
Sisters Health Clinic (Fund 464)
Inception through August 31,2014
ACTUAL
Received/Accrued
and Expended
Encumbrances
& Commitments
Project to
Date
RESOURCES:
Beginning Net Working Capital
Federal Grants
Donations (St, Charles & OR Comm Dental)
Resources from Fund 142
Transfer in (Fund 142)
Transfer in (Fund 270)
Interest Revenue
Total Resources
40,000
23,261
50,381
255,000
50,000
982
419,625
460,000
460,000
500,000
23,261
50,381
255,000
50,000
982
879,625
a)
b)
c)
d)
500,000
50,381
255,000
50,000
982
856,364
EXPENDITURES:
Materials & Services
Architecture/Design
Engineering
Planning
Surveying
Interfund Charges
Fees, Permits. Insurance & SDCs
Miscellaneous Project Costs
Miscellaneous Admin Costs
Total Materials & Services
66,691
3,325
2,029
3.677
68,321
13,972
35
158,050
10,000
5,000
2,000
1.120
3,752
21,872
76,691
5,000
3.325
4,029
3.677
69,441
17,724
35
179.921
b) 76.691
5,000
3,325
4,029
3,677
69,441
17,724
35
179.921
Capital Outlay
New Construction -CS Construction
Total Capital Outlay
483,404
483,404
193,038
193,038
676,442
676,442
e) 676,442
676,442
Total Expenditures 641,454 214,910 856,364 856,364
Net $ {221,828} $ 245,090 $ 23,261
a) The County was awarded a $500,000 Federal Grant. To date, $40,000 has been received and
the balance of $460,000 has been requested. Project completion date has been extended to September 30, 2014.
b) $50,381 paid in FY 2012 with resources from General County Projects Fund (Fund 142)
c) FY 2013 -$100,000; FY 2014 -$155,000 (Resolution No. 2014-023 Feb 26, 2014)
d) FY 2014 -$50,000 (Resolution No. 2014-024 Feb 26, 2014)
e) Original contract -$552,730, Change Order #1 -$123,712
•
JRF 9/512014