HomeMy WebLinkAbout2012-03-07 Work Session MinutesDeschutes County Board of Commissioners
1300 NW Wall St., Suite 200, Bend, OR 97701-1960
(541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org
MINUTES OF WORK SESSION
DESCHUTES COUNTY BOARD OF COMMISSIONERS
WEDNESDAY, MARCH 7, 2012
Present were COmmissioners Anthony DeBone and Alan Unger; Commissioner
Tammy Baney was out ofthe office. Also present were Erik Kropp, Interim County
Administrator; Tanner Wark, Parole & Probation; Marty Wynne and Chris
Edelston, Finance; Sarah Peterson, Children & Families' Commission; Tom
Kuhn, Environmental Health; and media representative Hillary Borrud ofThe
Bulletin. Chair DeBone opened the meeting at 1: 3 0 p. m.
1. Economic Development Loan Fund Request. -Roger Lee, EDCO
This item was delayed to an unspecified future date.
2. Finance/Tax Update.
Mr. Wynne indicated that overall figures are still better than budgeted. The
County is able to sell some old bonds now, and this will save the County at least
$100,000. (He referred to the Finance Update document.)
Commissioner Unger asked why the County has so much money being held in
reserves. Mr. Wynne explained that the Health Benefits Trust is close to $50
million, PERS is a big part, there is working capital as required in all 90 funds,
and the Solid Waste closure fund. The general fund has about $8 million. It is
not money that can be spent easily; there is very little discretion. There is a
section in the budget summary that gives the overall picture.
PERS estimates that rates will go up within the next two years, perhaps as much
as 5%. The percentage of payroll now is about 8%. Statewide, most agencies
are already at 12%. Therefore, they may have to use some of the PERS
reserves in the future. The State is involved in what is being called 'collaring',
which means some expenses have been deferred but eventually need to be
covered.
Minutes of Board of Commissioners' Work Session Wednesday, March 7, 2012
Page 1 of 4 Pages
Minutes of Board of Commissioners’ Work Session Wednesday, March 7, 2012
Page 2 of 4 Pages
Community Development will have a lower net beginning capital. The year-to-
date projection indicates that revenues will be over $1 million less than
expenditures. This will put some pressure on the general fund.
Mr. Kropp said he has been meeting with the department head to review
options. There needs to be a general fund transfer and/or service level
reductions. Staffing is about as low as it can be without decreasing services.
Already $1 million has been transferred in.
Mr. Wynne indicated that the discussion has been, after having $5 million in
reserves previously, whether that is adequate to build towards in the future.
Regarding Parole and Probation, funding is down and this will show itself
during the budget process.
Solid Waste revenue is down but they have more flexibility with transfers. Mr.
Schimke has indicated that he is going to request a rise in tipping fees in two
years.
Commissioner Unger asked about the Fair & Expo fund. Mr. Wynne said they
would be transferring funds out of capital reserves.
In regard to the North County Campus, what transpires the next few months
regarding the budget and bond issue will relate to the State’s decision on the
lease. So much is not known at this time.
3. Discussion and Approval of Grant Application – Children & Families’
Commission.
Sarah Peterson of the Children & Families’ Commission and Tanner Wark of
Parole & Probation said they are asking for authorization of Interim County
Administrator to sign grant applications once the applications are generated. It
would be around $300,000. Commissioner Unger stated that these are ongoing
programs. Stated that they got a grant for 2010 -12, but this is a new program.
(See the attached information for details.)
Much has to do with domestic violence and supporting the victim. Training
was completed, so this will support ongoing
Mr. Wark said this enables curfew checks, working with Saving Grace, and the
success rate has been around 96%. The violation numbers are up but that is
because they are stopping things before they escalate. This helps greatly with
domestic violence cases.
Minutes of Board of Commissioners’ Work Session Wednesday, March 7, 2012
Page 3 of 4 Pages
Ms. Peterson added that law enforcement and Saving Grace are providing
follow-up to victims, many of which may have never connected with these
services. This is a federal grant through the Department of Justice.
Commissioner Unger stated that this is a potentially dangerous situation and it
makes sense to deal with it at this level.
Ms. Peterson said that with the combination of training and the participation of
Parole and Probation, it has been successful.
UNGER: Move approval of Chair and Interim County Administrator
signatures of the MOU and other grant documents.
DEBONE: Second.
VOTE: UNGER: Yes.
DEBONE: Chair votes yes.
4. Discussion of Implementation of HB 2868, Environmental Health
Temporary Restaurant License Fees.
Chris Edelston and Tom Kuhn explained that historically there have been issues
with incensing temporary restaurants at events. Mr. Kuhn said this will reduce
staff time, and they can provide an operational review that will help with public
health controls and give the owners the ability to stay within these controls.
There will be a significant savings to the restaurant owners.
For instance, a food vendor at a farmer’s market for 90 days would pay $210,
with one inspection. Before it could have been up to $960 with inspections
every week for 12 weeks. The operational review is more comprehensive.
There are a lot of benefits and a whole lot fewer inspections required.
Because these are new fees, they can be adapted administratively. If fees were
going to be revised, this could only be done through a budget supplement. Mr.
Kuhn said that the numbers quoted are those that the State has determined are
appropriate.
UNGER: Mover approval of the implementation of HB 2868.
DEBONE: Second.
VOTE: UNGER: Yes.
DEBONE: Chair votes yes.
5. Request to Apply for Grants to Fund the Community Wildfire Protection
Plan.
Mr. Kropp stated the County Forester wishes to apply for two grants up to
$100,000 each for wildfire protection plans. The grant applications are due by
March 9 this year.
UNGER: Move approval of applications for the grants.
DEBONE: Second.
VOTE: UNGER: Yes.
DEBONE: Chair votes yes.
Mr. Kropp said that the Audit Committee is working on a policy regarding
grant applications, to make sure the proper process is being followed.
6. Other Items.
None were offered.
Being no further discussion, the meeting ended at 2:25 p.m.
DATED this ~Day of ~UU 2012 for the
Deschutes County Board of Commissioners.
/k-oU/~
Anthony DeBone, Chair
Alan Unger, Vice Chair
ATTEST: Tam~iSSioner ~~
Recording Secretary
Minutes of Board of Commissioners' Work Session Wednesday, March 7, 2012
Page 4 of 4 Pages
Deschutes County Board of Commissioners
1300 NW Wall St., Suite 200, Bend, OR 97701-1960
(541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org
WORK SESSION AGENDA
DESCHUTES COUNTY BOARD OF COMMISSIONERS
1:30 P.M., WEDNESDAY, MARCH 7, 2012
1. Economic Development Loan Fund Request -Roger Lee, EDCO
2. Finance/Tax Update -Marty Wynne
3. Discussion and Approval of Grant Application Children & Families'
Commission -Hillary Saraceno
4. Discussion of Implementation ofHB 2868, Environmental Health Temporary
Restaurant License Fees -Health Services Department
5. Request to Apply for Grants to Fund the Community Wildfire Protection Plan
Erik Kropp
6. Other Items
PLEASE NOTE: At any time during this 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 I 92.660(2)(d), labor negotiations; or ORS 192.660(2) (b), personnel issues.
Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board o/Commissioners' meeting rooms at
J300 NW Wall St.. Bend. unless otherwise indicated. Jfyou have questions regarding a meeting. please call 388·6572.
Deschutes County meeting locations are wheelchair accessible.
Deschutes County provides reasonable accommodations for persons with disabilities.
For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TIT.
Please call (541) 388·6571 regarding alternative formats or for further information.
Work Session
(Please Print) -1---~ --
Name ______ Agency Mailing Address
11~6JPU/5t!-l:~h P.t'/cr$,y)_ V€c-/-Ialrl h1P'n
-r:...... ~V" yJ~_~_ ~c-TJ~ _ (.."33'0 ~r;-!~ ~l-
~~t}~ ~~~ --
Wed.• March 7. 2012
~-
_ City ZiDI I -:hon~ # e-mail address
~~ r;z I~:~:::/ ~~::::'r'(j
._~.:LL{{?.--_.. _--I chn~tk-"';L hLJ.'~IClfI
1 1t1?I'Yv<J~r0.--t
Il I -
---+----------t------t--------1 .~
--1
t
I ___ _
t ----==-=----
\-----1-I -1-I
I
Pa2e # of Pa2es
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
March 7, 2012
(1) Monthly Investment Report
(2) January 2012 Financials
Investmenw By County Function
General $ 132,749,306 $
Investment Income
Fiscal Vear 2011-12
Jan-12 II V·T-D
70,832 $ 511,750 ,
--
Total Investments $ 132,748,306
Total Investment Income
Less Fee: 5% of Invest. Income
Investment Income -Net 1$
70,832
p,542~
67,281
I
511,750
{25,588~,
$ 481,163~
Commercial Paper
Corporate Notes
Time Certificates
U. S. Treasuries
Federal Agencies
Bankers' Acceptances
LG IP/BOTC
$
12,963,439
9,255,254
17,139,166
Total Portfolio: By Investment Types
Corporate Time
Notes Certificates
10% 7%
Federal
Agencies
13%
LGIP/BOTC
70%
0.00%
1.77Y
••17%
0.00%
12.11%
0.00%
Category lIaxlmum.:
U.S. Treasuries 100%
LGIP 100%
Federal Agencies 75%
Banker's Acceptances 25%
Time Certificates 21%
Commercial Paper 20%
Coroorate Notes 10%
omparators
3 Month Treas ~ 006 G/~
12 Monti) TrL'J~ . ~ 0 12 ~~
3 Montll C P ~ 0 13 "/u
Average Maturity In D~
General ---625
.,
aturity
Memorandum
Date: February 15, 2012
To: Board of County Commissioners IIErik Kropp, Interim County Administrator
E
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find January 2012 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-399),
Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675),
and Fair & Expo Center (618),
The projected information has been reviewed and updated, where appropriate, by the
respective departments.
Cc: All Department Heads
I
r
I
t
I
I
GENERAL FUND
Statement of Financial Operating Data
Seven Months Ended January 31.2012
Year to Date $
Actual Variance Variance
RESOURCES:
Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725
Revenues
Property Taxes 11.725.564 18.888.201 7,162,637 58% 94% 20,100.967 20,800.967 700.000
Gen. Rev. -excl. Taxes 1,389.687 1,709,524 319,837 58% 72% a) 2,382,321 2,382,321
Assessor 461,414 588,620 127,206 58% 74% b) 790,996 790,996
County Clerk 856,746 797,850 (58,896) 58% 54% 1,468,707 1,412,207 (56,500)
BOPTA 7,232 11,773 4,541 58% 95% b) 12,398 12,398
District Attorney 174,224 118,292 (55,932) 58% 40% c) 298,669 325,676 27.007
FinancefTax 113,108 168,600 55,492 58% 87% b) 193,900 193,900
Veterans 35,782 17,694 (18,089) 58% 29% 61,341 64,351 3,010
Property Management 56,117 57,617 1,500 58% 60% 96,200 96,200
Grant Projects 1,167 1,167 {O~ 58% 58% 2,000 2,000
Total Revenues 14,821,041 22,359,336 7,538,295 58% 88% 25,407,499 26,081,016 673,517
TOTAL RESOURCES 22,121,041 30,605,081 8,484,020 58% 94% 32,707,499 34,326,741 1,619,242
REQUIREMENTS: I Exp·%1
Expenditures
Assessor 1,986,425 1,891,346 95,079 58% 56% 3,405,300 3,305,300 100,000
County Clerk 830,646 595,003 235,643 58% 42% 1,423,965 1,223,965 200,000
BOPTA 42,235 31,144 11,091 58% 43% 72,402 72,402
District Attorney 2,846,256 2,589,516 256,740 58% 53% 4,879,296 4,511,771 367,525
FinancefTax 474,628 464,236 10,392 58% 570/0 813,648 813,648
Veterans 152,900 146,787 6,113 58% 56% 262,115 260,100 2,015
Property Management 150,304 148.293 2,011 58% 58% 257,664 257,664
Grant Projects 69,250 66,982 2,268 58% 56% 118,715 118,715
Non-Departmental 1,059.895 547,415 512,480 58% 30% d) 1,816,962 1,816,962
Contingency 3,923,921 3,923.921 58% n/a 6,726,722 6,726,722
11,536,460 6,480,722 5,055,738 58% 33"1. 19,776,789 12,380,527 7,396,262
Transfers Out 7,542,914 7,464,933 77,981 58% 58% 12,930,710 12.930,710
TOTAL REQUIREMENTS 19,079,374 13,945,655 5,133,719 58% 43% 32,707,499 25,311,237 7,396,262
NET (Resources -Requirements) 3,041,668 16,659,406 13,617,739 9,015,504 9,015,504
a) Includes annual payments: Tax on Electric Co-ops $489,027, PIL T $471,823
b) A & T Grant received quarterly-July. October, January & April
c) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD
actual includes three months of receipts)
d) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June
Page 1
COMM JUSTICE..JUVENILE
Statement of Financial Operating Data
Seven Months Ended January 31,2012
Year to Date
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
SB #1 065-Court Assess.
Discovery Fee
Food Subsidy
OVA Basic & Diversion
Inmate/Prisoner Housing
Inmate Commissary Fees
Contract Payments
Miscellaneous
Program Fees
MIP Diversion Fees
Interest on Investments
Leases
Grants -Private
Behavioral Health
CFC Interfund Grant
Gen Fund Grant-Crime Prev
Budget I
$1,101,374
5,833
29.167
8,750
14.583
126,874
51,619
58
40,833
35
23
175
4,375
1,400
292
3.500
89,908
11,667
Actual I Variance IFY % I Coli. %
$1,099,010 $ (2,364) 100% 100%
2,100 (3,733) 58% 21% a)
28.799 (368) 58% 58%
7,729 (1.021) 58% 52%
12,196 (2.387) 58% 49% b)
181,704 54,830 58% 84% c)
30,100 (21,519) 58% 34% d)
(58) 58% '0%
41,785 952 58% 60% e)
301 266 58% 502% f)
(23) 58% n/a
715 540 58% 238% f)
5,048 673 58% 67%
800 (600) 58% 33% g)
300 8 58% 60%
138 (3,362) 58% 2% h)
71,434 (18,474) 58% 46% OJ)
10,000 !1,667l 58% 50% j)
Budget
Year End
Projection Variance
$1,101,374 $1,099,010 $ (2,364)
10,000 10,000
50,000 50,000
15,000 15,000
25,000 25,000
217,498 355,730 138,232
88,490 60,000 (28,490)
100 100
70,000 100,000 30,000
60 500 440
40 40
300 825 525
7.500 7.500
2,400 1.200 (1.200)
500 500
6,000 331 (5.669)
154,128 134.620 (19,508)
20,000 20,000
Total Revenues 389,092 393,149 4,057 58% 59% 667,016 781,346 114,330
Transfers In-General Fund 3,104,185 3,104,185 58% 58% 5,321,459 5.321,459
TOTAl. RESOURCES 4,594,651 4,596,344 1,693 58% 65% 7,089,849 7,201,815 111,966
REQUIREMENTS: I Exp. %1
Expenditures
Community Justice..Juvenile
Personal Services 2,980,290 2,869,169 111,121 58% 56% k) 5.109,069 4,975.000 134.069
Materials and Services 697.511 613.347 84.164 58% 51% c)i) 1.195.733 1.100.000 95.733
Capital Outlay 58 58 58% 0% 100 100
Transfers Out 29.400 25.200 4,200 58% 50% 50,400 50,400
Contingency 428,486 428,486 58% n/a 734,547 734,547
TOTAl. REQUIREMENTS 4,135,745 3,507,716 628,029 58% 49% 7,089,849 6,125,400 964,449
NET (Resources -Requirements) 458,906 1,088,628 629,722 1,076,415 1,076,415
a) Outstanding $2.167 Federal Grant billing, reimbursed quarterly in arrears
b) $1,727 billing outstanding
c) OVA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted
accordingly. Payments received quarterly, $91.000 billing outstanding
d) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated
Billings outstanding -$5.550
e) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears, trending higher than anticipated
f) Revenues trending greater than antiCipated -dependent on use of programs or services (MIP Diversion Fees, photocopies. etc)
g) Citizen Review Board vacated. Revenue prOjected adjusted accordingly
h) Due to change in practice, Behavioral Health's referrals for functional family therapy have decreased. Anticipated as permanent
i) CCF (JCP) funding less than antiCipated. Projections of revenue and expenditures adjusted accordingly
Page 2 j) Grants paid quarterly-$5,000 outstanding payment for General Fund Grant-Crime Prevention
k) Actual for the year prOjected to be less than budgeted due to vacant positions
SHERIFF -Fund 255
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
Revised YearEnd
Budget Projection Variance
Year to Date
Budget J Actual I Variance J FY % J Call. %
RESOURCES:
Beg. Net Working Capital $ $ $ 100% n/a $ $ $
Total Revenues 21,311,217
TOTAL RESOURCES 21,311,217
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriff's Division
Civil
Automotive/Communications
Investigations/Evidence
Patrol/Civil/Comm Supp
Records
Adult Jail
Court Security
Emergency Services
Special Services Division
Regional Work Center
Training Division
Other Law Enforcement Svcs
Non-Departmental
Contingency
Transfers Out -DIS Fund
TOTAL REQUIREMENTS
NET (Resources -Requirements)
2 10,449,235 58% 47%" 22,084,82 1 18,925,250 (3,159 ,57 1)
58% 47%"
21,311,218 17,202,715 4,108,503 58% 47% 36,533,516 30,798,654 5,734,862
1,507,299
480,722
946,287
1,011,627
4,615,161
420,414
6,128,807
167,185
108,281
778,844
1,760,772
189,155
368,816
42,718
2,668,463
116,667
17,202,715 (4,108,502) 58% 47% 36,533,516 30,798,654 (5,734,862)
17,202,715 (4,108,502) 58% 47% 36,533,516 30,798,654 (5,734,862)
Exp. 0/01
1,414,889
436,384
959,512
858,563
4,559,611
366,570
5,389,586
163,940
100,101
663,288
1,639,352
146,456
361,745
42,718
100,000
92,410
44,338
(13,225)
153,064
55,550
53,844
739,221
3,245
8,180
115,556
121,420
42,699
7,071
2,668,463
16,667
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
55% a)
53% b)
59% c)
50% b)
58% b)
51%
51% d)
57%
54%
50%
54% b)
45%
57%
58%
nfa
50% e)
2,583,941
824,095
1,622,207
1,734,218
7,911,704
720,710
10,506,527
286,602
185,625
1,335,161
3,018,466
324,265
632,256
73,231
4,574,508
200,000
2,535,941
770,995
1,672,107
1,546,664
7,848,704
704,610
9,836,527
286,502
185,525
1,335,161
2,846,366
324,165
632,156
73,231
200,000
48,000
53,100
(49,900)
187,554
63,000
16,100
670,000
100
100
172,100
100
100
4,574,508
.. Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures
a) Less than planned software maintenance expenditures
b) Less than planned personnel expenditures due to open positions which may not be filled
c) Fuel expenses will be above plan for the year
d) Less than planned personnel expenditures due to open positions, jail bed rental expenses, and jail management software costs
e) Semi-annual transfer in November and May
Page 3
Fund 701 LED-Countywide
Statement of Financial Operating Data
Seven Months Ended January 31,2012
RESOURCES:
Beg. Net Working Capital $ 5,108,671 $ 6,090,734 $ 982,063 100% 119% $ 5,108,671 $ 6,090,734 $ 982,063
Tax Revenues -Current 8,345,657 13,396,849 5,051,192 58% 94% 14,306,841 14,627,128 320,287
Tax Revenues -Prior 292,250 516,106 223,856 58% 103% 501,000 516,106 15,106
Federal Grants & Reimb 20,533 30,784 10,251 58% 87% 35 ,200 35,200
State Grant 28,277 19,257 (9,020) 58% 40% 48,475 48,475
Transp. of State Wards 2,917 4,686 1,769 58% 94% 5,000 5 ,000
S81145 896 ,970 1,109,994 213,024 58% 72% a) 1,537 ,663 1,479,991 (57,672)
Prisoner Housing 26,492 26,492 58% nfa b) 78 ,087 78,087
Des . Cty Video Lottery Grant 2 ,917 5 ,000 2,083 58% 100% 5 ,000 5 ,000
Des Cty Court Security 53,083 52,348 (735) 58% 58% 91 ,000 91 ,000
Des Cty Juvenile Contract 2,438 3,224 786 58% 77% 4,180 4,180
Title III Reimbursement 87,500 (87,500) 58% 0% c) 150,000 150,000
Transport
Other
583 255
3,570
(328)
3 ,570
58%
58%
26%
nfa
1,000 1,000
3,570 3,570
DC Fair & Expo Center 2,231 (2 ,231) 58% 0% 3,825 3,825
Inmate Commissary Fees 3,850 7,065 3 ,215 58% 107% 6,600 10,000 3,400
Work Center Work Crews 29,167 25,665 (3,502) 58% 51% 50,000 50,000
Concealed Handgun Classes 2,042 2,250 208 58% 64% 3 ,500 3,500
Inmate Telephone Fee 28,000 49,391 21,391 58% 103% d) 48 ,000 84 ,000 36 ,000
Soc Sec Incentive-Fed 2,917 4,600 1,683 58% 92% 5,000 5 ,000
Miscellaneous 2,917 5,107 2 ,190 58% 102% 5 ,000 7,000 2 ,000
Oregon Mentors 8,750 4,300 (4,450) 58% 29% 15,000 15 ,000
Debit Card Fee 100 100 58% nfa 100 100
Medical Services Reimb 9,333 9,197 (136) 58% 57% 16,000 16 ,000
Restitution 2,917 1,727 (1,190) 58% 35% 5,000 5,000
Sheriff Fees 116,667 127,111 10,444 58% 64% 200,000 200 ,000
Interest 16,528 27,445 10,917 58% 97% 28,333 42 ,000 13,667
Interest on Unsegregated 2,061 1,057 (1,004) 58% 30% 3 ,533 3,533
Donations -"Shop with a Cop" 11,972 11,972 58% nfa e) 11 ,972 11,972
Sale of Reportable Assets 583 5 ,817 5,234 58% nfa 1,000 5 ,817 4,817
Total Revenues 9,961,088 15,451,369 5,490,281 58% 90% 17 1076,150 17 1507,484 431,334
TOTAL RESOURCES 15,069,759 21,542,103 6,472,344 58% 97'Y. 22,184,821 23,598,218 1,413,397
REQUIREMENTS:
Fund 255 Departments :
Sheriffs Services
Civil
AutofComm
Adult Jail
Court Security
Emergency Services
Special Services
Work Center
Training
Other (CODE , Forensic)
Non Dept -ISF Charges
Non Dept -Jamison DfS
Contingency
Total to Fund 255
1,413,831
480,722
354,091
6,128,807
167,185
108 ,281
541,460
1,760,772
115,477
368,816
21,402
116,667
1,305,301
12,882,812
1,327,152
436,384
359,040
5,389,586
163,940
100,101
461,124
1,639,352
89,410
361,745
21,402
100,000
10,449,236
86,680
44,338
(4,949)
739,221
3 ,245
8 ,180
80 ,336
121 ,420
26,067
7,071
0
16,667
1,305,301
2,433,577
1 Exp. %1
58% 55%
58% 53%
58% 59%
58% 51%
58% 57%
58% 54%
58% 50%
58% 54%
58% 45%
58% 57%
58% 58%
58% 50%
58% 0%
2,423,711
824,095
607,014
10,506,527
286 ,602
185 ,625
928,217
3 ,018,466
197,961
632 ,256
36 ,689
200 ,000
2,237,659
22,084,821
2,378,687
770,995
625,686
9,836,527
286 ,502
185,525
928 ,217
2 ,846,366
197,899
632,156
36 ,689
200,000
18 ,925,250
45,024
53,100
(18 ,672)
670,000
100
100
172,100
61
100
21 237 ,659
3,159,571
Transfer to Reserve Fund (703) 58 ,333 100,000 (41,667) 58% 100% 100,000 100,000
Total Requirements 12,941,146 10,549,236 2,391,909 58% 48% 22,184 ,821 19 ,025 ,250 3 ,159,571
Net 2,128,613 10,992,867 8 ,864,254 4,572,969 4,572 ,969
• Payment to Sheriffs Fund adjusted monthly to equal actual expend itures attributable to countywide services.
a) Reduction in State Community Corrections funding for custody of S9 1145 inmates
b) Prisoner housing reimbursement S9 395
c) Reimbursement requested semiannually in January and June
d) Change to new vendor resulting in revenue increase
e) Accounting change for Shop with a Cop donations
Page 4
Fund 702 LED Rural
Statement of Financial Operating Data
Seven Months Ended January 31,2012
RESOURCES:
8eg. Net Working Capital $2,936,523 $3,004,533 $ 68,010 100"10 102% $2,936,523 $3,004,533 $ 68,010
Revenues
Tax Revenues -Current 4,286,406 6,762 ,236 2,475 ,830 58"10 92% 7,348,125 7,512,627 164,502
Tax Revenues -Prior 149,917 257,743 107 ,826 58 % 100% 257 ,000 257,743 743
Federal Grants & Reimb 7,000 11,377 4 ,377 58"10 95% 12 ,000 12,000
Federal Grants-BlM 14,583 8 ,873 (5,710) 58% n/a 25 ,000 25,000
US Forest Service 45 ,938 39,375 (6 ,563) 58 % 50"10 78 ,750 78,750
State Grant 117,234 74,437 (42,797) 58 % 37% 200,972 200 ,972
SB #1065 Court Assessment 35 ,000 28,799 (6 ,201 ) 58 "10 48% 60 ,000 60 ,000
Marine Board license Fee 83,027 (83,027) 58 % 0% a) 142,332 142 ,332
Bureau of Reclamation 4 ,189 4,189 58% n/a b ) 20,000 20 ,000
Des Cty General Fund Grant 336 ,084 (336 ,084) 58% 0% c) 576 ,144 576,144
Des Cty Transient Room Tax 1,209 ,749 1,209,749 58% 58 % 2,073 ,856 2,073,856
Des Cty Tax/Fin Contract 540 540 58% 540 540
City of Sisters 262,477 262,477 58% 58% 449,961 449,961
Des Cty COD Contract 31,714 31 ,714 58% 58% 54,366 54,366
Des Cty Solid Waste Contr 31 ,714 31,714 58% 58% 54,366 54,366
Des Cty Clerk/Election 1,167 (1 ,167) 58% 0% 2,000 2,000
School Districts 46,667 3,457 (43,210) 58% 4% d) 80,000 40 ,000 (40 ,000)
Claims Reimbursement 2,750 2,750 58 % nla 2 ,750 2,750
Security & Traffic Reimb 2,917 680 (2 ,237) 58 % 14% 5 ,000 5,000
Seat Belt Program 7,000 5,215 (1 ,785) 58% 43% 12,000 12 ,000
Miscellaneous 4,667 2 ,015 (2,652) 58% 25% 8,000 8,000
False Alarm Fees 1,167 1,300 133 58 % 65% 2,000 2,000
Restitution 2 ,069 2,069 58% n/a 5,000 5,000
Sheriff Fees 5,833 5 ,187 (646) 58% 52% 10 ,000 10,000
Court Fines & Fees 67,083 70,063 2 ,980 58% 61% 115,000 115,000
Impound Fees 4,083 2,200 (1 ,883) 58"10 31% 7 ,000 7,000
Restitution -Street Crimes 292 (292) 58% 0% 500 500
Seizure/Forfeiture 1,324 1,3 24 58% nla 1,324 1,324
Interest 5,833 12,358 6,525 58% 124% 10,000 20 ,000 10 ,000
Interest on Unsegregated 1,050 533 (517) 58% 30% 1,800 1,000 (800)
Grants-Private 7 ,000 7 ,000 58 % nla 7,000 7 ,000
Donations 6 ,555 6 ,555 58% n/a 6,555 6 ,555
Sale of Equip & Material 3,500 11 ,354 7 ,854 58 % 189% 6,000 15 ,000 9 ,000
Sale of Reportable Assets 11,667 42 ,177 30 ,510 58% 211% e) 20,000 50,000 30 ,000
Total Revenues 6,773,769 8,899,460 2 ,125,691 50% 77% 11,612,172 11 1828,786 216,614
TOTAL RESOURCES 9,710,292 11,903,993 2,193,701 50"10 82% 14,548,695 14,833,319 284,624
REQUIREMENTS: 1 Exp. %1
Fund 255 Departments:
Sheriffs Services 93,468 87,737 5,730 58% 55% 160 ,230 157,254 2 ,976
Auto/Comm 592,196 600,472 (8,276) 58 % 59% 1,015 ,193 1,046,421 (31 ,228)
Investigations 1,011 ,627 858,56 3 153 ,064 58% 50% 1,734,218 1,546,664 187,554
Patrol 4 ,615 ,161 4 ,559,611 55 ,550 58 % 58% 7,911 ,704 7 ,848,704 63,000
Reco rds 420,414 366,570 53,844 58% 51% 720,710 704,610 16,100
Special Services 237,384 202 ,164 35 ,220 58% 50% 406 ,944 406,944
Training 73 ,678 57,046 16,632 58% 45% 126,304 126,266 39
Non Dept -ISF Charges 21,316 21 ,316 58% 58% 36 ,542 36 ,542
Transfer to Reserve Fund (704) 58,333 100,000 (41,667) 58% 100% 100 ,000 100 ,000
Total Requirements __8~,~48~6~, ~73~9~~6~,8~5~3,~4~79~__1~,6~3~3~, 2~5~9~ 58% 47% 14,548 ,695 11 ,973.404 2,575,291
Net 1,223,553 5,050 ,514 3,826 ,960 2 ,859,915 2 ,859 ,915
• Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services .
a) Reimbursement requested semiannually in January and June
b) BUR patrol contract signed atter budget adopted
c) Received annually in June Page 5
d) Rei mbursement tor SRU deputies will be less than planned tram the Bend La Pine School District
e) Proceeds tor sale ot used patrol vehicles higher than planned
Con ti n genc 1,363 ,162 1,363,162 58% 0% 2 ,3 36 ,849 2,336,849
PUBLIC HEALTH
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
Year to Date
Actual Variance Variance
RESOURCES:
Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 101% $1,596,918 $1,702,129 $ 105,211
Revenues
Medicare Reimbursement 350 461 111 58% 77% 600 600
State Grant 1,580,917 1,351,875 (229,042) 58% 50% 2,710,144 2,729,165 19,021
Child Dev & Rehab Center 14,354 15,379 1,025 58% 62% 24,607 30,759 6,152
State Miscellaneous 131,150 64,074 (67,076) 58% 28% alb) 224,829 127,000 (97,829)
OMAP 305,579 336,922 31,343 58% 64% 523,850 523,850
Title 19 352 352 58% nfa 500
Family Planning Exp Proj 303,333 277,911 (25,422) 58% 53% 520,000 520,000
Local Grants 26,250 50,627 24,377 58% 113% 45,000 53,000 8,000
Water Program-Base Fee 24,500 18,772 (5,728) 58% 45% a) 42,000 42,000
Contract Payments 25,000 25,000 58% n/a 25,000 25,000
Water Program-Field Work 32,560 23,675 (8,885) 58% 42% a) 55,817 55,817
H20 Sys Insp-Priv Wells 117 (117) 58% 0% 200 200
Miscellaneous 3,740 3,740 58% nfa 7,000 7,000
Patient Insurance Fees 78,972 97,309 18,337 58% 72% 135,380 135,380
Health DepUPatient Fees 69,283 55,061 (14,222) 58% 46% 118,770 118,770
Vital Records-Birth 17,850 23,925 6,075 58% 78% 30,600 30,600
Vital Records-Death 58,333 54,365 (3,968) 58% 54% 100,000 100,000
Environmental Health 410,871 639,784 228,913 58% 91% c) 704,350 704,350
Interest on Investments 7,000 6,205 (795) 58% 52% 12,000 12,000
Donations 15,184 9,102 (6,082) 58% 35% 26,030 15,000 (11,030)
Interfund Contract 115,726 36,706 (79,020) 58% 19% a) 198,387 153,200 (45,187)
Administrative Fee 8,783 8,783 58% 58% 15,056 15,056
Total Revenues 3,201,112 3,100,028 (101,084) 58% 56% 5,487,620 5,399,247 (88,373)
Transfers In-General Fund
Transfers In-PH Res Fund
Transfers In-Gen. Fund Other
TOTAL RESOURCES
1,352,029 1,352,029
17,500 15,000
__.=..37:....:,..::.9.:...75=--__3=2:.!.,5::...:5:...:0~_
6,205,534 6,201,736
(2,500)
___"(..:.5.!...,4:..=2:.;;;..L5)
(3,798)
58%
58%
58%
58%
58%
50%
50%
65%
2,317,765
30,000
65,100
9,497,403
2,317,765
30,000
65,100
9,514,241 16,838
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
3,630,948
1,112,238
116,667
3,502,191
1,019,532
128,757
92,706
116,667
166,833 143,000 23,833
513,465 513,465 --~~~~------------~~~
1 Exp. %1
58% 56%
58% 53%
58% 0%
58% 50%
58% nfa
6,224,483
1,906,694
200,000
286,000
880,226
6,100,000
1,800,000
100,000
286,000
124,483
106,694
100,000
880,226
TOTAL REQUIREMENTS 5,540,151 4,664,723 875,428 58% 49% 9,497,403 8,286,000 1,211,403
NET (Resources -Requirements) 665,383 1,537,013 871,630 1,228,241 1,228,241
a) Received quarterly, in arrears
b) Elimination of the State self sufficiency program
c) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012
Budget=$110,000). These are due annually and collected primarily in December and January Page 6
500
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
Actual Variance Variance
Year to Date
RESOURCES:
Beg. Net Working Capital $3,268,759 $ 3,108,163 $ (160,596) 100% 95% $3,268,759 $ 3,108,163 $ (160,596)
Revenues
Marriage Licenses 3,208 3,500 292 58% 64% 5,500 8,000 2,500
Divorce Filing Fees 77,583 90,354 12,771 58% 68% 133,000 150,000 17,000
Domestic Partnership Fee 58 55 (3) 58% 55% 100 100
Federal Grants 161,377 99,202 (62,175) 58% 36% 276,647 276,647
State Grants 4,062,451 4,428,314 365,863 58% 64% a) 6,964,202 7,566,736 602,534
State Miscellaneous 72,434 10,310 (62,124) 58% 8% b)c) 124,173 61,860 (62,313)
ABHA 163,569 163,569 58% n/a d) 170,000 170,000
Title 19 164,673 87,596 (77,077) 58% 31% 282,297 200,000 (82,297)
Liquor Revenue 61,250 82,505 21,255 58% 79% 105,000 141,500 36,500
School Districts 44,100 45,200 1,100 58% 60% 75,600 75,600
Miscellaneous 8,167 8,059 (108) 58% 58% 14,000 14,000
Patient Insurance Fees 66,325 53,016 (13,309) 58% 47% 113,700 100,000 (13,700)
Patient Fees 1,054 657 (397) 58% 36% 1,807 1,150 (657)
Interest on Investments 14,583 15,521 938 58% 62% 25,000 26,700 1,700
Rentals 7,642 5,625 (2,017) 58% 43% b) 13,100 13,100
Donations 108 108 58% n/a 200 200
Administrative Fee 2,583,985 2,558,271 (25,714) 58% 58% 4.429,689 4.429,689
Sheriff 11,667 (11,667) 58% 0% e) 20,000 (20,000)
Interfund Contract-Gen Fund 74,083 37,287 (36,796) 58% 29% b) 127,000 127,000
Comm. on Children & Fam 725 725 58% n/a 725 725
Total Revenues 7,414,640 7,689,874 275,234 51% 60% 12,710,815 13,363,007 652,192
Transfers In-General Fund 737,051 737,051 58% 58% 1,263,515 1,263,515
Transfers In-OHP-CDO 158,318 158,319 58% 58% 271,402 396,077 124,675
Transfers In-Acute Care Svcs 147,301 147,301 58% 58% 252,515 252,515
Transfers In-ABHA 175,503 150,432 {25,071! 58% 50% f) 300,863 387,473 86,610
TOTAL RESOURCES 11,901,572 11,991,140 89,567 58% 66% 18,067,869 18,770,750 702,881
REQUIREMENTS: I Exp. %1
Expenditures
Personal Services 5,771,611 5.411,615 359,996 58% 55% 9,894,191 9,483,681 410,510
Materials and Services 3,302,104 3,071,297 230,807 58% 54% 5,660,749 5,265,100 395,649
Capital Outlay 242,083 63,199 178,884 58% 15% 415,000 415,000
Transfers Out 166,833 143,000 23,833 58% 50% 286,000 286,000
Contingency 1,056,959 1,056,959 58% nJa 1,811,929 1,811,929
TOTAL REQUIREMENTS 10,539,590 8,689,111 1,850,479 58% 48% 18,067,869 15,449,781 2,618,088
NET (Resources -Requirements) 1,361,982 3,302,029 1,940,046 3,320,969 3,320,969
a) Department of Human Services Grant projected at amended contract amount
b) Received quarterly, in arrears
c) Elimination of State contract for Temporary Assistance for Needy Families (TANF) program
d) Revenue for Adult Mental Health Initiative Clients, not included in original budget
e) Funding for Mental Health Court from the Sheriffs Department eliminated
f) Transfer made quarterly
Page 7
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Seven Months Ended January 31,2012
Vearto Date
Budget I Actual J Variance I FY%J Coli. %
RESOURCES:
Beg. Net Working Capital $ 229,822
Revenues
Admin-Operations 14,204
Admin-GIS 583
Admin-Code Enforcement 97,242
Building Safety 700,513
Electrical 151,171
Contract Services 93,450
Env Health-On Site Prog 163,567
Planning-Current 393,692
Planning-Long Range 148,007
131,776 $ (98,046) 100%
16,612 2,408 58%
1,207 624 58%
97,286 44 58%
551,738 (148,775) 58%
130,226 (20,945) 58%
54,374 (39,076) 58%
164,759 1,192 58%
351,290 (42,402) 58%
134,589 (13,418) 58%
Total Revenues 1,762,429 1,502,080 (260,349) 58%
Trans In·GF 367,283 367,283 58%
Trans In-GF for Lng Rng Ping 288,960 288,960 58%
Trans In-other 58 !58} 58%
TOTAL RESOURCES 2,648,552
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin-Operations 823,561
Admin-GIS 74,524
Admin-Code Enforcement 119,333
Building Safety 327,852
Electrical 138,495
Contract Services 96,652
Env Health-On Site Pgm 83,480
Planning-Current 361,085
Planning-Long Range 279,304
Transfers Out (DIS Fund) 101,433
Contingency 147,075
2,290,100 (358,452) 58%
814,272 9,289 58%
70,301 4,223 58%
121,262 (1,929) 58%
324,394 3,458 58%
131,000 7,495 58%
103,084 (6,432) 58%
88,997 (5,517) 58%
347,641 13,444 58%
256,671 22,633 58%
160,242 (58,809) 58%
147,075 58%
TOTAL REQUIREMENTS 2,552,794 2,417,864 134,930 58%
570/0
68%
121%
58%
46%
50%
34%
59%
52%
53%
a)
b)
b)
c)
b)
d)
50%
58%
58%
0%
52%
Exp. %1
58%
55%
59%
58%
55%
62% e)
62% f)
56%
54% d)
92% g)
nJa
55%
Budget
Year End
Projection Variance
$ 229,822 $ 131,776 (98,046)
24,350 24,790 440
1,000 1,850 850
166,700 166,200 (500)
1,200,880 1,090,575 (110,305)
259,150 225,800 (33,350)
160,200 130,200 (30,000)
280,400 298,700 18,300
674,900 625,550 (49,350)
253,726 234,800 (18,926)
3,021,306 2,798,465 (222,841)
629,625 629,625
495,360 495,360
100 !100!
4,376,213 4,055,226 (320,987)
1,411,818 1,411,818
127,755 127,000 755
204,570 204,570
562,032 545,000 17,032
237,420 230,000 7,420
165,689 167,000 (1,311)
143,108 144,000 (892)
619,002 600,000 19,002
478,806 443,500 35,306
173,885 173,885
252,128 252,128
4,376,213 4,046,773 329,440
NET (Resources -Requirements) 95,758 (127,765) (223,523)
Revenues
Expenditures
Net from Operations
1,502,080
2,417,864
!915,784)
a) GIS revenue is sporadic based on the frequency of customer requests
b) Fall activity less than anticipated
c) Contract payments from Redmond are currently on hold pending finalization of a new contract
d) As Tumalo area wetland inventory grant will not be received, budgeted expenses will not occur
e) Year to date actual includes payout to retired employee
f) Extra Help expenditures occur primarily in the summer months
g) Transfers made November ($160,242) & May ($13,643)
8,453 8,453
3,021,306 2,798,465 (222,841)
4,376,213 4,046,773 329,440
{ 1,354,907} p,248,308} 106,599
Page 8
ROAD
Statement of Financial Operating Data
Seven Months Ended January 31,2012
Vearto Date
Budget I Actual I Variance IFY % I Coli. % Budget
YearEnd
Projection Variance
RESOURCES:
Beg. Net Working Capital $2,834,720 $ 3,417,158 $ 582,438 100% 121% $ 2,834,720 $ 3,417,158 $ 582,438
Revenues
System Development Charge 924 924 58% nJa 924 924
Federal Reimbursements 350,000 600,000 250,000 58% 100% a) 600,000 600,000
Federal Grant (ARRA) 11,667 20,000 8,333 58% 100% b) 20,000 20,000
Mineral Lease Royalties 23,333 23,589 256 58% 59% 40,000 40,000
Forest Receipts 764,845 1,322,661 557,816 58% 101% c) 1,311,162 1,322,661 11,499
State Miscellaneous 291,691 500,041 208,350 58% 100% d) 500,041 500,041
Motor Vehicle Revenue 6,615,000 6,224,049 (390,951) 58% 55% e) 11,340,000 10,810,307 (529,693)
City of Bend 160,417 29,941 (130,476) 58% 11% f) 275,000 275,000
City of Redmond 204,167 4,248 (199,919) 58% 1% f) 350,000 350,000
City of Sisters 5,833 (5,833) 58% 0% f) 10,000 (10,000)
City of La Pine 5,833 (5,833) 58% 0% f) 10,000 (10,000)
Admin Recovery (SOC) 583 1,527 944 58% 153% 1,000 2,000 1,000
Miscellaneous 11,667 20,453 8,786 58% 102% 20,000 25,000 5,000
Road Vacations 583 500 (83) 58% 50% 1,000 1,000
Interest on Investments 11,667 10,514 (1,153) 58% 53% 20,000 17,000 (3,000)
Parking Fees 84 (84) 58% 0% 144 144
Interfund Contract 425,833 (425,833) 58% 0% g) 730,000 730,000
Equipment Repairs 116,667 137,946 21,279 58% 69"10 200,000 220,000 20,000
Vehicle Repairs 52,500 (52,500) 58% 0% 90,000 78,800 (11,200)
LID Construction 5,833 (5,833) 58% 0% g) 10,000 (10,000)
Vegetation Management 41,708 (41,708) 58% 0% g) 71,500 71,500
Forester 14,583 (14,583) 58% 0% g) 25,000 25,000
car Washes 2,042 3,030 988 58% 87% 3,500 3,500
car Rental 758 758 58% nJa 1,000 1,000
Sale of Equip & Material 369,250 529,997 160,747 58% 84% 633,000 718,306 85,306
Total Revenues 9,485,786 9,430,178 (55,608) !58% 58% 16,261,347 15,812,183 (449,164)
Trans In • Solid Waste 166,701 142,887 (23,814) 58% 50% 285,773 285,773
Trans In • Transp SOC 145,833 125,000 (20,833) 58% 50% 250,000 250,000
Trans In-Road Imp Res 7,000 (7,000) 58% 0% 12,000 12,000
TOTAL RESOURCES 12,640,040 13,115,223 496,016 58% 64". 19,643,840 19,777,114 133,274
REQUIREMENTS: I Exp.o/.I
Expenditures
Personal Services 3,275,605 3,109,715 165,890 58% 55% 5,615,323 5,351,169 264,154
Materials and Services 5,934,060 6,002,594 (68,534) 58% 59"k h) 10,172,674 10,036,129 136,545
Capital Outlay 721,403 25,288 696,115 58% 2% i) 1,236,691 90,936 1,145,755
Transfers Out 350,000 600,000 (250,000) 58% 100% 600,000 600,000
Contingency 1,177,839 1,177,839 58% nJa 2,019,152 2,019,152
TOTAL REQUIREMENTS 11,458,907 9,737,597 1,721,310 58% 50% 19,643,840 16,078,234 3,565,606
NET (Resources· Requirements) 1,181,133 3,377,626 2,217,326 3,698,880 3,698,880
a) Revenue received in November at completion of the Cascade Lakes chip seal project
b) Payment received in December
c) Received annually in January
d) Annual payment received in August
e) Revenues trending less than estimates provided by OooT
f) Billed upon completion of work
g) Payments to be received in June 2012 from other Road Department funds I
I Page 9 h) Expenditures are seasonal and higher during summer. YTD includes $2.5 million paid to Knife River on the
Full Depth Reclamation Project in South County
i) Budget includes $1,096,691 for 19th Street Extension. This will not be expened in FY 2012.
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
RESOURCES:
Beg. Net Working Capital
Revenues
DOC Measure 57
State Miscellaneous
Alternate Incarceration
State Subsidy
SB 1145
Probation Work Crew Fees
Miscellaneous
Electronic Monitoring Fee
Probation Superv. Fees
Interest on Investments
Interfund -Sheriff
Crime Prevention Grant
CFC-Domestic Violence
Total Revenues
Transfers In-General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
Year to Date
Budget I Actual I Variance
$ 560,000 $ 634,125 $ 74,125
126,788 219,240 92,452
2,509 4,301 1,792
18,036 (18,036)
7,583 10,370 2,787
1,665,800 2,061,417 395,617
14,000 13.150 (850)
2,392 1,830 (562)
99,167 75,200 (23,967)
116,667 103,544 (13,123)
5,250 3,495 (1,755)
29,167 29,167
29,167 12,500 (16,667)
43,652 18,708 (24,944)
2,160,178 2,552,922 392,744
197,337 197,337
2,917,515 3,384,384 466,869
1,848,401 1,766,456 81,945
517,353 412,616 104,737
58 58
16,800 14,400 2,400
301,568 301,568
IFY % I Coli. %
100% 113%
58% 101%
58% 100%
58% 0%
58% 80%
58% 72%
58% 55%
58% 45%
58% 44%
58% 52%
58% 39%
58% 58%
58% 25%
58% 25%
58% 69%
58% 58%
58% 74%
I Exp. %\
58% 56%
58% 47%
58% 0%
58% 50%
58% n/a
2,684,180 2,193,472 490,708 58% 48%
a)
a)
b)
c)
c)
d)
d)
Budget
Year End
Projection Variance
$ 560,000 $ 634,125 $ 74,125
217,350 219,240 1,890
4,301 4,301
30,918 21,000 (9,918)
13,000 13,000
2,855,659 2,748,953 (106,706)
24,000 24,000
4,100 2,100 (2,000)
170,000 170,000
200,000 200,000
9,000 9,000
50,000 50,000
50,000 50,000
74,832 74,832
3,703,160 3,586,426 (116,734)
338,292 338.292
4,601,452 4,558,843 (42,609)
3,168,688
886,890
100
28,800
516,974
3,168.688
886,890
28.800
100
516,974
4,601,452 4,084,378 517,074
NET (Resources -Requirements) 233,335 1,190,912 957,577 474.465 474,465
a) Annual allocation received in January
b) State invoiced quarterly. Payment from State pending
c) State invoiced quarterly. Payments received from State at beginning of quarter
d) Interfund grant received quarterly. Payments have been requested
Page 10
CHILDREN & FAMILIES COMMISSION
Statement of Financial Operating Data
Seven Months Ended January 31,2012
Vearto Date
Budget I Actual I Variance IFY % I Coil. % Budget
Year End
Projection Variance
RESOURCES:
Beg. Net Working Capital $ 467,111 $ 556,143 $ 89,032 100·;0 119% $ 467,111 $ 556,143 $ 89,032
Revenues
Federal Grants 174,701 192,200 17,499 58% 64% a) 299,488 305,416 5,928
Title IV -Family Sup/Pres 22,942 30,155 7,213 58% 77% a)b) 39,329 39,534 205
HealthyStart Medicaid 55,417 19,205 (36,212) 58% 20% a)c) 95,000 85,000 (10,OOO)
Level 7 Services 150,490 154,986 4,496 58% 60% alb) 257,982 196,898 (61,084)
State Prevention Funds 14,292 58,017 43,725 58% 237% d) 24,500 77,622 53,122
HealthyStart /R-S-G 181,906 193,653 11,747 58% 62% alb) 311,838 258,203 (53,635)
OCCFGrant 318,035 383,499 65,464 58% 70% a)b) 545.203 509.579 (35.624)
Program Fees 2,710 2.710 58% n/a e) 3,500 3,500
Charges for Svcs-Misc 4.667 1.161 (3,506) 58% 15% 8,000 8,000
Court Fines & Fees 45,500 54,213 8,713 58% 70% f) 78,000 85,000 7.000
Interest on Investments 2,917 2,435 (482) 58% 49% 5,000 5.000
Donations 71 71 58% n/a e) 300 300
Interfund Grants 70,510 150,437 79,927 58% 124% g) 120,875 320.875 200,000
Total Revenues 1,041,377 1,242,742 201,365 580/. 70% 1,785,215 1,894,927 109,712
Trans from General Fund 159.229 159.229 58% 58% 272,960 272,960
Total Transfers In 159,229 159,229 58·/. 58% 272,960 272,960
TOTAL RESOURCES 1,667,717 1,958,114 290,397 580/. 78% 2,525,286 2,724,030 198,744
REQUIREMENTS: I Exp. %1
Expenditures
Personal Services 352,986 343,456 9,530 58% 57% h) 605,119 579,945 25,174
Materials and Services 984,071 785,707 198,364 58% 47% i) 1,686,979 1,766,175 (79,196)
Capital Outlay 58 58 58% 0% 100 100
Contingency 135,968 135,968 58% n/a 233,088 233,088
TOTAL REQUIREMENTS 1,473,083 1,129,163 343,920 580/. 45% 2,525,286 2,346,220 179.066
NET (Resources -Requirements) 194,634 828,951 634,317 377,810 377,810
a) Grant payments received normally within 60 days after the end of each quarter
b) FY 12 and FY 131ntergovemmental Agreement finalized funding levels from OCCF. Community Schools grant included in year-
I
end projection at $9,484. Additional Casey Foundation grant of $11 ,214 received
c) Medicaid revenues reduced due to lower projections
d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from OHS not budgeted for $48,122
e) Youth Suicide Prevention training donations & fees expected to be received
f) Court fees projected to be higher than estimated in the Original budget
g) Two additional grants of $55,000 & $180,000 awarded. $55,000 received in last fiscal year, $20,000 grant from OHP expected
h) Personnel costs lower due to part-time Early Childhood Specialist
i) Sub-grant expenditures paid quarterly. Federal grant amount increased and SPF-SIG grant expenditures added
$21,214 in expenditures added, remaining $10,000 for staff expenses Page 11 I
SOLID WASTE
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
Year to Date
Buqget I Actual I Variance J FY %j Coli. % Bu~get
Year End
Projection Variance
RESOURCES:
Beg. Net Working Capital $1,092,508 $ 1,141,691 $ 49,183 1000;0 105% $1,092,508 $ 1,141,691 $ 49,183
Revenues
Miscellaneous 12,833 11,313 (1,520) 58% 51% 22,000 22,000
Franchise 3% Fees 116,667 83,057 (33,610) 58% 42% a) 200,000 200,000
Commercial Disp. Fees 501,667 510,841 9,174 58% 59% 860,000 860,000
Private Disposal Fees 766,500 778,993 12,493 58% 59% 1,314,000 1,314,000
Franchise Disposal Fees 2,333,333 2,330,928 (2,405) 58% 58% 4,000,000 4,000,000
Yard Debris 42,583 55,893 13,310 58% 77% b) 73,000 80,000 7,000
Special Waste 14,583 3,007 (11,576) 58% 12% c) 25,000 10,000 (15,000)
Interest 4,375 6,620 2,245 58% 88% 7,500 9,500 2,000
Leases 1 5,893 5,892 58% n/a d) 1 10,394 10,393
Donations 2,880 2,880 58% n/a e) 2,880 2,880
Sale of Reportable Assets 15,100 15,100 58% nla f) 15,100 15,100
Recyclables 17,500 49,462 31,962 58% 165% g) 301000 70,000 40,000
Total Revenues 3,810,042 3,853,987 43,945 58% 59% 6,531,501 6,593,874 62,373
TOTAL RESOURCES 4.902,550 4.995.678 93,128 58% 66% 7.624,009 7.735,565 111,556
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out·Road
Trans Out-Post Closure
Trans Out-Equip Reserve
Trans Out-Capital Res
Contingency
975,099
1,687,614
566,553
100,333
166,701
233,333
145,833
247,333
324,539
931,349
1,502,700
398,826
111,030
142,887
200,000
250,000
212,000
43,750
184,914
167,727
(10,697)
23,815
33,333
(104,167)
35,333
324,539
58%
58%
58%
58%
58%
58%
58%
58%
58%
Exp. %1
56%
52%
41% h)
65%
50%
50%
100% i)
50%
n/a
1,671,598
2,893,052
971,233
172,000
285,773
400,000
250,000
424,000
556,353
1,614,765
3,006,522
971,233
183,930
285,773
400,000
250,000
424,000
56,833
(113,470)
(11,930)
556,353
TOTAL REQUIREMENTS 4,447.338 3,748,792 698,547 58% 49% 7,624,009 7,136,223 487,786
NET (Resources -Requirements) 455,212 1,246,887 791,675
a) Due April 15, 2012
b) Seasonal item-F a/l and Spring
c) Dependent on special clean-ups such as asbestos and contaminated soil
d) Revenue from rent on Rickard Road property, not included in original budget
e) Incentive for energy efficient lighting upgrade in Knott Transfer Station building
f) Sold glass crusher at auction
g) Recycling markets are higher than expected. Often it can be seasonal
h) To be expended in November ($398,827) and May ($572,406)
i) Budgeted amount transferred in September.
599,342 599,342
Page 12
RISK MANAGEMENT
Statement of Financial Operating Data"
Seven Months Ended January 31, 2012
RESOURCES:
Beginning Net Working Capital
Revenues
Inter-fund Charges:
General Liability
Property Damage
Vehicle
Workers' Compensation
Unemployment
Claims Reimb-Workers' Compensation
Claims Reimb-Gen Uab/Property
Process Fee-Events/Parades
Miscellaneous
Skid Car Training
Interest on Investments
Other Interest
TOTAL REVENUES
TOTAL RESOURCES
AppropriationslExpenditures
Direct Insurance Costs:
GENERAl LIABILITY
Settlement I Benefit
Defense
Professional Service
Insurance
Repair I Replacement
Total General Liability
PROPERTY DAMAGE
Insurance
Repair I Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair I Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement I Benefit
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT -Settlement/Benefits
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Transfers Out
TOTAL REQUIREMENTS
NET
* Contingency is $2,305,693.
Year to Date
Budget I Actual I Variance I % of FY I % Coil.
$2,100,000 $2,039,937 ($60,063) 100"_ 97%
146,332 146,332 (0) 58% 58%
181.786 181,786 0 58% 58%
104,014 104,014 (0) 58% 58%
859.801 859,801 0 58% 58%
147,253 147,441 188 58% 58%
2,917 224 (2,693) 58% 4%
11,667 64,439 52.772 58% 322%
875 700 (175) 58% 47%
29 (29) 58% 0%
10,500 9,170 (1,330) 58% 51%
8,750 8,742 (8) 58% 58%
29 ~29l 58% 0%
1,473,952 1,522,649 48,697 58"_ 60%
3,573,952 3,562,586 (11,367) 58% 77%
I % Ex!:!. I
233,333
110,162
156,719
196
109,664
5,517
382.258 (148,924) 58% 96%
175,130
116,097
67,043
183,140 (8,010) 58% 61%
59,200
376
10,276
34,207
44,859 14,340 58"_ 44%
466,667
526,989
74,782
37,347
21,772
660,889 (194,222) 58% 83%
145,833 53,465 92,368 58% 21%
1,080,163 1,324,611 (244,448) 58% 72%
171,708 153,402 18,306 58% 52%
97,835 82,561 15,274 58% 49%
58 58 58% 0%
269,602 235,963 33,639 58% 51%
4.200 3,600 600 58% 50%
1.353.965 1.564,174 l210,210! 58% 67%
2,219.988 1,998,412 '221,576~
Budget
Year End
Projection Variance
$2,100,000 $2,039,937 ($60,063)
250,855 250,855
311,633 311,633
178.310 178,310
1,473,944 1,473,944
252,433 252,433
5.000 5,000
20,000 75,000 55.000
1,500 1,500
50 50
18,000 18,000
15,000 15,000
50 50
2,526,775
4.626.775
2,581,775 55,000
4.621,712 (5,063)
400,000 475,000 (75.000)
300.223 278,000 22,223
101.485 80,000 21,485
*
800,000
250,000
1,851,708
294,357
167.717
100
462.174
7.200
2,321,082
2,305,693
980,000 (180,000)
250,000
2,063.000 (211,292)
294,357
167.717
100
462.074 100
7,200
2,532,274 (211,192)
2,089,438 (216,255)
Page 13
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Seven Months Ended January 31,2012
Year to Date
Actual Variance Variance
RESOURCES:
Beg. Net Working Capital $6,400,000 5 7,559,639 $ 1,159,639 100% 118% 56,400,000 57,559,639 $ 1,159,639
Revenues
Property Taxes -Current 3,490,534 5,560,748 2,070,214 58% 93% 5,983,773 6,117,731 133,958
Property Taxes -Prior 116,667 199,650 82,983 58% 100% 200,000 200,000
Federal Grants 184,578 184,578 58% n/a 203,958 203,958
State Reimbursement 31,500 10,836 (20,664) 58% 20% a) 54,000 27,000 (27,000)
Telephone User Tax 437,500 381,366 (56,134) 58% 51% 750,000 750,000
Data Network Reimb. 15,867 34,698 18,831 58% 128% b) 27,200 34,698 7,498
Jefferson County 20,417 26,381 5,964 58% 75% 35,000 35,000
User Fee 30,333 2,156 (28,177) 58% 4% c) 52,000 52,000
Police RMS User Fees 116,083 (116,083) 58% 0% d) 199,000 199,000
Contract Payments 18,667 33,061 14,394 58% 103% b) 32,000 33,061 1,061
Miscellaneous 5,250 7,073 1,823 58% 79% 9,000 9,000
Interest 20,417 31,864 11,447 58% 91% 35,000 35,000
Interest on Unsegregated Tax 467 439 (28) 58% 55% 800 800
Donations 750 750 58% n/a 750 750
Total Revenues 4,303,702 6,473,600 2,169,898 58% 88% 7,377,773 7,697,998 320,225
TOTAL RESOURCES
REQUIREM ENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
10,703,702
2,473,820
1.124,291
661,862
291,667
3,485,395
14,033,239
2,202,926
1,049,560
353,657
500,000
3,329,537
270,894
74.731
308.205
(208.333)
3,485,395
58%
58%
58%
58%
58%
58%
102%
% Exp·1
52%
54%
31%
100%
n/a
e)
13,777,773
4,240,834
1.927,356
1,134,620
500,000
5,974,963
15,257,637
4,040,834
1,927.356
1,134,620
500.000
1,479,864
200,000
5,974,963
TOTAL REQUIREMENTS 8,037,035 4,106,143 3,930,892 58% 30% 13,777,773 7,602,810 6,174,963
NET (Resources -Requirements) 2,666,667 9,927,096 7,260,429 7,654,827 7,654,827
a) GIS/MSAG monthly billings to Oregon Emergency Management-projected revenue overestimated. Projection revised to $27,000
b) Invoiced annually; all expected revenues received
c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch inVOiced annually June 30th. Payment will not be received
from Crooked River Ranch until FY 13
d) Fees expected to be billed in March
e) Entire amount budgeted transferred to reserve fund in September
Page 14
Health Benefits Trust
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
VeartoDate
BUdQ!!t Actual I Variance FY% ICoII.%\
RESOURCES
Beg. Net Working capital
Revenues:
$15,500,000 $ 15,829,888 $ 329,888 100% 0 $15,500,000 $15,829,888 329,888
Internal Premium Charges
prr Emp -Add' Prem
Employee Prem Contribution
COIC
Retiree / COBRA Co-Pay
Fees for Clinic Services
Federal Payment (ERRP)
Prescription Rebates
Interest
Total Revenues
7,009.165
29,167
367,500
735,000
291,667
46,667
8,479,115
7.026,222
17,372
366,845
754,045
506,974
200
150,431
81,117
64,743
8,967,949
17.058
(11.795)
(655)
19,045
215,307
200
150,431
81,117
18,076
488,784
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
35%
58%
60%
101%
nla
nla·
nla
81%
62%
12.015.711
50.000
630,000
1,260,000
500,000
80,000
14,535,711
12,015,711
30,000
630,000
1,260,000
750,000
200
150,431
81,117
90,000
15,007,459
(20.000)
250,000
200
150,431
81,117
10.000
471,748
TOTAL RESOURCES 23,979,165 24,797,837 818,172 92% 103% 30,035,711 30,837,348 801,137
REQUIREMENTS
expenditures:
Persona' Services
Materials & Services
Claims Paid-MedicallRx
Claims Paid-DentallVision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPOFee
Health Impact
Other
88,211
7.276,666
1.087,318
204,167
87,500
186,667
29,167
32.083
82,345
78,702
6.873,151
1.105,776
(50,753)
205,307
155,263
185,344
28,320
29,946
78.223
9,508
403,515
(18,458)
50,753
(1,140)
(67,763)
1,323
847
2,138
4,121
I Exp.%1
58% 52 0;"
58% 55% a)
58% 59% a)
58% nla
58% 59%
58% 104%
58% 58%
58% 57%
58% 54%
58% 55%
151,218
12,474.284
1,863.974
350,000
150,000
320,000
50,000
55,000
141,162
151.218
11,529,252
1,854,850
(50,753)
350,000
155,263
320,000
50,000
55,000
141,162
945,032
9,124
50,753
(5,263)
Total HBT • Dept 31 9,074,122 8,689,278 384,844 56% 15,555,138 14,555,992 999,141
Deschutes On-site Clinic
Healthstat 558,367 361,773 196,594 58% 38% b) 957,200 957,200
Medications/Drugs 189.583 81,413 108,171 58% 25% 325,000 325,000
Medical Supplies 1,750 18,878 (17,128) 58% 629% 3,000 30,000 (27,000)
Equipment 2,333 150 2,183 58% 4% 4,000 4,000
Miscellaneous 3,179 7,250 !4,071 l 58% 133% c) 5,450 10,000 l4,550}
Total DOC 755,213 419,413 285,749 1,294,650 1,321,200 (31,550)
Deschutes On-site Pharmacy
Remodeling Costs 13,870 40,000
Total Pharmacy
Capita' Outlay
Contingency
117
7,691,380
13,870 (13,870)
117
7,691,380
58%
58%
58%
nla
nla
nla
200
13,185.223
40,000
-
(40,000)
200
13,185,223
TOTAl EXPEND/REQUIREMNTS 17,520,831 9,172,111 8,348,220 58% 31% 30,035,711 15,922,192 14,113,519
NET (Resources -Requiremenls) 1,458,333 15,125,226 9,111,893 14,915,156 14,915,156
• Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible.
a) Projection based on annualizing 31 weeks of dams paid. YTD actual is $255,748 per week.
Page 15
I
RESOURCES:
Beg-Net Working Capital
Receipts:
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession % -Food
Rights (Signage, etc.)
Interfund Contract
Miscellaneous
Total Receipts
Transfers In
General Fund (001)
Room Tax (160)
Welcome Center (170)
Annual County Fair (619)
Reserve Fund (617)
Total Transfers In
TOTAL RESOURCES
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Deschutes County ~ Fair and Expo Center
YTD~Budget Basis Commissioners
Statement of Financial Operating Data
Seven Months Ended January 31, 2012
Year to Date
Budget (7/12 ofl
annual) I Actual I Variance IFY % IColi. %
$ 75,000 $ (40,601) $ (115,601) 100% ·54%
352,917
875
33,833
3,500
17,500
128,333
65,333
27,417
3,971
633,679
307,399
195
13,112
4,186
75,549
31,000
7,986
439,426
(45,518)
(680)
(20,722)
(3,500)
(13,314)
(52,784)
(34,333)
(27,417)
4,015
(194,253)
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
51%
13%
23%
0%
14%
34%
28%
0%
nfa
40%
99,167
15,017
48,300
128,333
58
290,876
99,169
15,015
48,300
220,000
382,484
91,667
(58)
91,608
58%
58%
58%
58%
58%
58%
58%
58%
100%
0%
999,555 781,309 (218,246) 58% 47%
1 Exp. %1
505,177
280,618
67,123
58
485,176
370,202
71,266
20,001
(89,584)
(4,143)
58
58%
58%
58%
58%
56%
77%
62%
0%
Budaet
$ 75,000
605,000
1,500
58,000
6,000
30,000
220,000
112,000
47,000
6,807
YearEnd
Projection
$ (40,601)
551,399
878
36,112
6,000
34,186
173,549
114,000
47,000
9,608
1,086,307 972,732 (113,575)
170,000 170,000
25,744 25,744
82,800 82,800
220,000 220,000
100 ~100~
498,644 498,544 (100)
1,659,951 1,430,675 (229,276)
866,018 846,074 19,944
481,060 563,365 (82,305)
115,068 115,068
100 100
Variance
$ (115,601)
(53,601)
(622)
(21,888)
4,186
(46,451 )
2,000
2,801
Total Expenditures 852,977 926,644 (73,668) 1,462,246 1,524,507 (62,261)
Transfers Out ~ Reserve Fund 5,833 10,000 (4,167) 58% 100% 10,000 10,000
Contingency 109,495 109,495 58% nla 187,705 187,705
TOTAL REQUIREMENTS 968,305 936,644 31,660 58% 56% 1,659,951 1.534,507 125.444
NET (Resources Requirements) 31,250 (155,335) (186,585) ~103,832~ {103,832}
Page 16
00.
u ~
~
0
~
~
~
~
<
~
~
~
<
U
r.Il
a ::s
c!j
U
» ...... c::s
0
U
'€
0
Z
•
c c-
a
lU ..s:::
lU...... ..s:::......
lU
Il:l
•
RESOURCES:
loan Proceeds, net of issuance costs
Resources from Fund 140
Resources from Fund 142
Transfer in
Interest Revenue
Total Resources
EXPENDITURES:
Materials & Services
Architecture/Design
Engineering
Planning
Interfund Charges
Fees, Permits & SDCs
Utilities
Travel -Meals/Mileage Reimb
Total Materials & Services
Capital Outlay
Land and Building
Remodel
Total Capital Outlay
Contingency
Total Expenditures
Net
Deschutes County
North County Services Building
Inception through January 31,2012
ACTUAL
Received and Encumbrances Project to
Expended & Commitments Date
1,402,013 1,402,013 a)
25,000 25,000 b)
600,000 600,000
2,313 2,313
2,029,326 2,029,326
29,045 20,955 50,000 b)
970 970
5,153 5,153
3 3
35,171 20,955 56,126
1,402,013 1,402,013 a)
230 230
1,402,24L __ ___ _ 1,40?,243
1,437,414 20,955 1,458,369
591,912 (20,955) 570,957
PROJECTION
Project
Budget I I Proiected I I Variance
2,000,000
1,402,013
25,000
600,000
4,027,013
100,000
10,000
1,663
60,000
2,000
173,663
1,402,013
2,451,337
3,853,350
4,027,013
3,400,000
1,402,013
25,000
600,000
2,313
5,429,326
100,000
10,000
1,663
60,000
2,000
3
173,666
1,402,013
3,851,337
5,2~,35()
5;427,016
2,310
1,400,000
2,313
1,402,313
{3~
{3)
p,400,OOO}
(1,400,000)
(1,400,003)
2,310
a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve -$1,402,013
b) $25,000 was paid to the architect in FY 2011 with resources from General County Projects Fund (Fund 142)
North County Services Building -Fund 462
ENCUMBRANCES AND COMMITMENTS
Through January 31, 2012
Commitment Balance
Amount Paid Description Amount DueVendor
BLRB/GGL Architects Architectural Services 50,000 29,045 20,955
50,000 29,045 20,955
I
Deschutes County
Bethlehem Inn (Fund 128)
Seven Months Ended January 31, 2012
Budget Actual Variance 1Fy%1 cou.%1
RESOURCES:
Beg. Net Working Capital $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100%
Revenues
Grants -Private 1,634,399 -(1,634,399) 58% 0%
Lease Payments 14,238 14,238 58% 58%
Total Revenues 1,648,637 14,238 (1,634,399) 58% 1%
TOTAL RESOURCES (1,062,598) (2,702,343) (1,639,745) 58% ·2350%
REQUIREMENTS: Exp. %1
Expenditures
Debt Service:
Interest Expense 8,750 11,365 (2,615) 58% 76%
Interest Payment 58,333 58,333 58% 0%
TOTAL REQUIREMENTS 67,083 11,365 55,719 58% 100/0
NET (Resources -Requirements) (1,129,681) (2,713,708) (1,584,026)
a) Interest on January 2012 negative cash balance: $1,371.89.
b) Inception through January 31,2012
Revenues -Lease Payments $ 38,646
Expenditures:
Land/Building (Amertitle) -July 2007 2,241,313
Hickman Williams 17,578
City of Bend -May 2008 250,000
KN EX CO 5,289
Kleinfelder 3,732
Total expended on facility 2,517,913
Interest on Negative Cash Balance 234,441
Total expended 2,752,354
Net $ (2,713,708)
Budget I Projection I Variance
$(2,711,235) $(2,716,581) $ (5,346)
2,801,827 -(2,801,827)
24,408 24,408
2,826,235 24,408 (2,801,827)
115,000 (2,692,173) (2,807,173)
a) 15,000 17,000 (2,000)
100,000 100,000
115,000 17,000 100,000
b)==========(_2=,7=09=,1=7~3)==(2=,7=0=7=,1=73~)
I
J
l i
I
I
t
I
I
Deschutes County
General Support Services -BOCC
Conference/Seminar, Educationrrraining and Travel Expenditures
and
BOCC -County College Expenditures
FY 2012
lfqcc Conferenc~~& T!av~f~ I Jul Aug Sep Oct Nov I' Dec Jan I.. YTD Total I,,'
Tammy Baney , :;""Conf/Sem& Educrtraining~'"'''~---'''''''665 -.. --...-..... ~-.--305~-..15~~-......--....·~-=75~i·..... 1 O~
~el Meals-----~__-~_~ ~._ ..."~~_···_·~.. ___ ..._··~_=_=·_-~~-·---~-2-26-~",_ .... ~-=_30_-=_--_-~_9_0_t--------=_~~:===:~'~-'!QJ::-i
~fr:modati~n-s---.... ----996 211 I 429_:_ ...~..... __ ~__ },21_8..,1__3,1_54_i
~ife-a-g-e-re-im-b-u-rs--e-m-e'-nt--~--'---"'--'-----~7-9-4-"~~----'----S7Y--309 i----=5=2-=-9----·-2,-30-9'
GrOuIldTrirlsPortlParidr19 ... -... ····~:~~-------150 I =~:=:=-: =~~~...~.~-·...-....·:::-=~.~=~1~5~0::..j
Total Baney : 1,661! 1,375 ! 734 : 722 399; 2,123: 7,013
Alan Unger ___.....__--=--:=-....J.........._--;-;;;:-----....;.---=-:=-'---;-;--.--c-I
Conf/Sem & EducfTraining 665 305 45 -: 75 1,090
-:... ....--~..... ....---..-...--i----...~--'-...
Travel Meals .. --, - - - -I
..... AccommOdations' .---~.....-~;--1~----:--:"~---"""':-322--"'~--"~-'--::-+----~'-----:-1,-.45=-=2-1
~rfare ......~---.-..... .~_...~.........~___ '.==-___~~..... _~~.. __ .~..__ ~_._~~..~
...
Mileage reimbursement '.
-- ..-~---....---~-.-.... t .... -~~·~-.... ------~--~~·----....~-~--....·
Ground Transport/Parking
-Total Unge-r---....·-~--·.... -=1:=,7==9::=:6:::-.....::==;-===---6-2-7", ---"45-': ---. --75-":-=2~,54===2::..j
=--.... ._..... .... . ====..... ===------...----.....--...------...-~ Tony DeBone
~...-.... --.... _=_=:_:__= ..-~-.~....~--_::_::_c::__'_-....--.....--~~~_=_=__=__--.~--.-....-..--...---~~
. C0r::'..f/Sem & EducfTraining ...~._6_6_5_.___... 305 .....__45_·.... - : 535 1,550
Travel Meals • • •. - ....._~___.....__~.....__~_..... .....____..... ......____..._....._ ..~_..l-_~__.... ___=
Accommodations . 908 . 429 . -. -! - . 1,3377irfare .. -.....~..----~,--.......--~--~---~-~-.....~.~~-.-.--~-.----I 573. ... 57l...
~Mileage reimbur~ement _~_~~~-3OQ.._~ :=~~-146~~....~--~~163~-138 '~__ ~
..._G_ro_u_nd Transpo~____......__~..... -54 _. - --! ==:-=:-:=_c:=:::=54~
Total Other 1,573 354 : 880 : 45 • 163 I 1,246 4,261
Total • BOCC Department ----..,-...---.....---.:-~-I
Conf/~em & Educrrraining 1,330_~~ --,---~-::-c:-610~:~...~9_,_ i 610 3,700
Travel Meals ,-220 : 30 90 -I 340
~ommodatiOriS----==-_:_1,904 • 211 I 857 • 1,518 : 5,943
Airfare i -- ,..-----: 573 • "'573
Mileage Reimbursement ' . 300 : 794! 146 • 677 . 472 ! 668 i 3,056r------.::---..... ..._'---:-:-r----,.~---....~---.~---·-~I----.. ....;
Ground Transport I 54 , 150 ! -: -; -i -204
-T~ota~I~.B-OC-C-Departm-ent.. 3,234 ' 354: 1,375 I 1,613 : 767 . 562: 3,369; 13,816
~....--....---...~---..... --...-.-: -~~-~~~-~--.-;~----~.~~-=:····-~i-:::::-..~
FY 2012 Budget !:. ' '14,750= ..... ........._...-.-,--~.~--... --.-=--=::i=-===::-==-==-==-==-==-==::::-_=.~~
oPercent of FY 2012 E?udget Expended ....._ ..._ .. ___.. _ ..' .....__..._~.___ ----+--__~~~3_.7_/<l.
.
eocc County College : : ----=....~---..... ..... -~-..... --.-... ----.-i--~-"-~~""""'-~~-' ---.... --.-....
Public Information i --,
Office/Copier Supplies -----... -~-~-~-____:r20:--~~ 59 . 11·····~i--12 .. ----201
t--,'... .... -l-.~ ..=-c-
Meeting S~p_p_lie_s_..... ___ _+ 556 : 829 • 788 : ~ ----J:._-c::::::::::'2~,1.;..:.7...;;;.2
f-----------..--....--~-.---.~--~_+--.~r---~-.. ------=--:-~=----:~·---=--==-:.--l675 829 i 847 , 11 : 12 : 2,373-----..----.------.....---,..-...---+...~.. ==!!-...===""---""=""""".... I I ~ir--: r-~
1/30/2012
MEMORANDUM
Date: March 7, 2012
To: Board of County Commissioners
From: Finance Department
Subject: Proposed Emergency Fee Additions to FY 2012 Fee Schedule
Background:
Over the past few years, there has been growth in the number of temporary restaurants at
locations such as farmers markets and amateur sporting events. A restaurant booth that is
located at a farmers market often operates in more than one market per week. Current statute
requires the owner to obtain a temporary license and get inspected every time they operate.
The passage of House Bill 2868, which provides for licensing of intermittent temporary
restaurants and seasonal temporary restaurants, brings about the need to approve and add
four new fees to the FY 2012 Fee Schedule. The measure establishes a licensing system for two
new types of temporary restaurants: [1] seasonal temporary restaurant license -good for 90
days (same event, same location and same menu) e.g. farmers market, little league
concessions; and [2] intermittent temporary restaurant license -good for 30 days (different
events, same location, same menu) e.g. Les Schwab Amphitheater having several different
events in a 30 day period.
Note: Single events, such as The Bite of Bend will use fees that are currently included in the FY
2012 Fee Schedule.
Discussion:
Under current law, there is only one type of temporary restaurant license valid for 30 days or
until a temporary food vendor ceases operation. HB 2868 differentiates three categories of
temporary restaurants by the Oregon Health Authority:
1. Intermittent temporary restaurant category -allows an establishment operating at
the same location over several days at events sponsored by different organizations
to apply for an intermittent temporary license that is valid for 30 days. Under
existing law, these restaurants are required to obtain a license and be inspected
every time they operate.
I
1
f
I
I
!
t
2. Seasonal temporary restaurants -allows an establishment operating periodically at
the same location and with the same oversight group (e.g. vendors at weekly
farmers markets) to apply for a seasonal temporary license valid for 90 days. Under
existing law these temporary restaurants are required to obtain a license and be
inspected every time they operate.
3. Single-event temporary restaurants -allows establishments operating in one
location in connection with a single event to apply for a Single-event temporary
license valid for 30 days or until the operation ceases.
HB 2868 also requires an "Operational Review" plus fee for Seasonal and Intermittent TRLs.
IMPACT: HB 2868 should have a minimal fiscal impact on Deschutes County. There will be a
reduction in licensing applications, and therefore a reduction in revenue; however, there
should be a corresponding reduction in workload due to a decrease in licensing and inspection
activities.
Emergency Fees to be added to FY 2012 Fee Schedule:
Intermittent Temporary Restaurant License
Seven days or more before event start date
Less than seven days before event start date
125.00
150.00
Seasonal Temporary Restaurant License
Seven days or more before event start date
Less than seven days before event start date
125.00
150.00
Operational Review 85.00
Re-check fee for Temporary Restaurant 85.00
Requested Action: Discussion regarding and approval of addition of emergency fees to FY 2012
Fee Schedule.
I
l
\
Information regarding the new fees for Environmental Health that go into effect
on March 1.
Pursuant to House Bill 2868, starting March 1S
\ 2012, all county EH programs in
Oregon must offer 3 types of Temporary Restaurant Licenses (TRL's):
1) Single Event TRL (which we've always had)
2) Seasonal TRL -good for 90 days (same event, same location, same menu
e.g. farmers market, little league concessions)
3) Intermittent TRL -good for 30 days (different events, same location, same
menu-e.g. Les Schwab Amphitheater having several different events in a 30
day period)
Both 2 and 3 above will require what's being called an Operational
Review. Because of when the Governor signed the bill, March 1 is when the laws
(DRS's) go into effect.
3 new fees on March 1st:
1) Seasonal TRL: $125
2) Intermittent TRL: $125
3} Operational Review: $85
The Oregon Health Authority may require a new fee called a Re-check Fee for
these new TRL's but nothing in place yet.
I have calculated how I arrived at those above fees if anybody needs them. Also,
all our existing Single Event TRL's fees will stay the same. I will meet with Diana
Jackson (IT) and Sandy to get these rolling in Accuterm and our fee schedule. I
know EH is going away from Accuterm starting July 1 as we will transition to the
state electronic inspection system (called the acronym EHLlS) but Accuterm will
still need to be used for TRL's until around 2013 since I'm told EHLlS does not
support TRL's at this time.
Let me know if you need more information or have questions. Thanks to
everybody for your help with this.
Eric Mone, REHS
Environmental Health Supervisor
Deschutes County Environmental Health
541-388-6566