2012-1861-Minutes for Meeting November 05,2012 Recorded 11/26/2012DESCHUTES COUNTY OFFICIAL
NANCY BLANKENSHIP, COUNTY
CONNISSIONERS' JOURNAL
1111111111111111111111111111111
2 1x-3861
CLERKDS
11/26/2012 03;08:26 PM
Do not remove this page from original document.
Deschutes County Clerk
Certificate Page
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
MINUTES OF WORK SESSION
DESCHUTES COUNTY BOARD OF COMMISSIONERS
MONDAY, NOVEMBER 5, 2012
Present were Commissioner Anthony DeBone, Alan Unger and Tammy Baney.
Also present were Tom Anderson, Interim County Administrator; Erik Kropp,
Deputy County Administrator; and, for a portion of the meeting, Nick Lelack,
Community Development; and Mark Pilliod, County Counsel. No representatives
of the media were in attendance.
Chair DeBone opened the meeting at 1:30 p.m.
1. Finance/Tax Update.
Marty Wynne reviewed the investment portfolio. The average investment is
0.64, the same as last month. The County has beaten the estimate for the
budget year, which was 0.4. The pool has not secured as much, and has been at
0.6 for a long time. Some interest has been lost on the BOTC pool; however,
all customers were advised this would be reduced.
The treasury rates show the County far ahead of the norm. Washington's was
0.18 and Idaho was 0.20; Oregon is the third highest LGIP in the country. It is
still not a lot of earnings, but better than most others are getting. Other places
can go out beyond two years and the County can't; they play by different rules.
The pool's risk is low, and no principal would be lost in any case.
Most departments are on the same track, and projections won't be too detailed
until after the first of the year after most taxes have been paid. Tax revenue will
be less than budgeted, though. The general fund shows the Clerk's revenue
above budget; and the TILT payment was $400,000 that was not projected.
Some departments might be $200,000 less than budget due to additional
transient room tax revenue.
Minutes of Board of Commissioners' Work Session Monday, November 5, 2012
Page 1 of 5
The health benefits trust fund budget is done a long way in advance, but the
fiscal 2013 projection shows that if the current trend continues, the County will
have a beginning net of $12,316,000 compared with over $14,000,000. This
was discussed during the budget process. Revenues are $2.2 million less than
expenditures. If this is raised, the imbalance will continue. Departmental
charges would have to be higher than the difference.
The DOC and pharmacy costs are a factor and are meant to save money, but it
has not happened yet. There are 3,000 covered lives, and any number of
problems can arise, so it is hard to know why there is no decrease. The
pharmacy's costs at $1.3 million are to a great extent estimated and some
contracts have not yet come in or been paid.
Mark Pilliod stated that it could be because there is a subsidiary of Walgreens
involved, with two corporations, and there could be a delay on how they work
through this process. He has seen this in other areas of contracting. It may
account for part of the delay.
Commissioner Baney would like to see a cost-benefit analysis for the DOC and
pharmacy. She was hoping they would it be more balanced. Erik Kropp said
that this information is presented to EBAC at every meeting. They analyze
what things would cost if the DOC is used and if it is not used. What is shown
in the finance report is just expenses, and not what it would cost if the DOC
were not being used to cover the same services.
Mr. Wynne said there could be an increase to departments if this trend
continues. Claims are up 11 % from the previous year. However, some big
claims can distort the total. By February, the increase could go the other way.
He is concerned about being at $12 million at this time.
Commissioner Unger stated that in past years they tried to keep the reserves
lower to help with negotiations with the unions. They need to determine what
the best number is. Mr. Wynne said that there is an unwritten policy that they
should not go below twelve months of claims. They are below that point now.
He feels that there should be more concern about the departments and not the
unions. The rates this year are about what they were four years ago. They drew
down reserves to help the departments.
Minutes of Board of Commissioners' Work Session Monday, November 5, 2012
Page 2 of 5
Part of the problem is the continuing bad economy. They may need to be more
conservative, especially in view of an increase in PERS that was unexpected.
In the budget process, if they hold the rates constant based on current
information, they'd have to draw down $4.4 million. This is too low. They
would have to charge departments more than is comfortable.
Once the Budget Committee approves the budget, the Board cannot increase it
more than 10%. If a department has funds in contingency, it is not going to be a
problem to move funds around legally. The law pertains to the approved
budget. The Board can approve more than 10% through a supplemental budget
adjustment, but it has to go through the whole process.
It will be interesting to learn what helps with the health benefits trust plan and
watch the claims for the next couple of months.
Mr. Kropp stated that there is a Board policy of having twelve months' worth of
claims being held. Mr. Wynne added that there are other requirements if the
County went from self=insured to a carrier. He is not worried about that it this
point, but wants to keep the reserves higher. They want to keep rates down
when times are tough and keep things manageable.
2. Executive Session, called under ORS 192.660(2)(h), pending or threatened
litigation.
After executive session, the Board took the following action.
BANEY: Move that staff prepare a letter to Attorney Ed Fitch as discussed in
executive session
UNGER: Second.
VOTE: BANEY: Yes.
UNGER: Yes.
DEBONE: Chair votes yes.
Minutes of Board of Commissioners' Work Session Monday, November 5, 2012
Page 3 of 5
3. Other Items.
Mr. Kropp said that United Way is hiring an auditing firm to review the Bend
Community Center information. They have asked for the County to grant
$1,000 for this purpose. In any case, this is politically sensitive.
He is not sure what they hope to find for the money. It will probably show that
the organization could not sustain itself. Their thrift store was a drain. They
would allow themselves to get into a deficit position and then they'd try to
replenish this with a fundraiser.
The expectation might be that the County should be involved in the next steps
of what they want to become. Money for this would come out of a Commission
on Families and Children fund, held aside to cover unforeseen issues.
The Commissioners felt that the CFC board should make this decision.
Chair DeBone stated that he has an Investment Advisory Board meeting
tomorrow, as well as the County College graduation ceremony tomorrow night.
He attended an EDCO strategy session last week, and they seem to be on track.
Commissioner Baney said she is presenting at a conference on Wellness in the
Workplace, and they will be discussing tobacco-free policies.
On Thursday, she will attend a retreat for the Health Council that oversees the
CCO's, and they will be picking initiatives based on mandates.
Commissioner Unger is attending a field trip in the Sisters area to view the
aftermath of this summer's wildfire in that area. Chair DeBone indicated he
would like to attend as well.
Being no further items discussed, the meeting adjourned at 3: 00 p.m.
Minutes of Board of Commissioners' Work Session Monday, November 5, 2012
Page 4 of 5
DATED this
Deschutes County
ATTEST:
0
-Qirv~ _ 2012 for the
C cl- Day of
Board of Commissioners.
Recording Secretary
Anthony DeBone, Chair
j~r,~ YA4-
Alan Unger, Vice Chair
Tammy Baney, Comhdissioner
Minutes of Board of Commissioners' Work Session
Page 5 of 5
Monday, November 5, 2012
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., MONDAY, NOVEMBER 5, 2012
1. Finance/Tax Update - Marty Wynne
2. Executive Session, called under ORS 192.660(2)(h), pending or threatened
litigation
3. 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 192.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 of Commissioners' meeting rooms at
1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6577.
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 TTY.
Please call (541) 388-6571 regarding alternative formats or for further information.
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
November 5, 2012
(1) Monthly Investment Report
(2) September 2012 Financials
E
C
r.
E~
.n
V
o
N
a
.
w
n
y
w no
M
~
M
YN„
r-
in N
1A
M
f/1
M
C
0
M M
Ti
.0
$ a
f7
y{c
C
fa N
C
J.
p
u o
V -6
V
p
ads
~
w
W
N
$11491 s
Ci 40r;C;
Cq M
Irv CO
11
w
r! I M
0
. C
UUt-
i3
N
m
Document Reproduces Poorly
(Archived)
N N r
r
a FA
a
t U E
a L Y
a~i~(ry o
c] -j U. H U
N
N U
Q
C
T
C ~
U-
E
y
E e
7
~
C
T
m
~
O
° ° C4
Oz-
O
me
O
an
a
0
U
K
b
D
U
z
U
z
U I
z'
U••
U
Z
U
Z
U:
Z'
U'i
z
U
z
U
Z
U cJ
Z Z
Z
U I U I
Z Z
c
co
U
Z
V
Z
ax
O
N
Y!
t
a°
0
e a el'
010 co c%l
M
Q
O
0
41
Q
O
I
~
r
0
O
4
A
I
n
M
0
00
M
0
O!
'
N
co
!
O
r
OI
4
OI
4
'
!n
n n n
o
co
000
co
to
M
co
C.
CD
M
Op
f~
O
00
M
O
!
,
7
co
N,
N
ui
r
M
00
N
M
to
N!
co
0
n
M
N
(o
to
i
O
Q
C
N ;O
M •
V7
t0
M
d
0
M
1D
!
j
G
m •
0
N
Q
co
OD
OD
O
N
fD
M!
OD
n
0
'
00
OD
N
N
0
cl
co
r 0
lq
r
M
M
N
00l
O
* f
W
0
N
0
~ 1
'.OD
0
0
U'!
7
aD
M
3
4
El w
Op
N
O
I
O
N
I
O
Lo
N
Co
LL7
Lo
O
fD
N
In
O
O
O
V
R1
<D
r
N
V
'Ia0
R
O
n
A'
M
m
1D
(o
M
u7
1=
M
•I
7
U l0
Qf
r
N;
N
N
O
N
r
N
,
r
r
0
r
r
N
N
O
N
O N
N N
r
r-
O
N
O
N.
N
N
r ILp
1
r I
G
'1
1
0
N
N I
nl
0
M
C6
r
4
,
,
,
Nh
i
I
i
I
d
O
¢
o
O
Op
t
O
00
m
0
q:
0
C?
r
d 0 7
Q
O
Q
O
co '
co
M
O
p
M
M
O
pl
'
!
dn
(o
n
00
M
d
I
I
3
jp
►
O
O
O
p
N
R
61,
00;
1P
O
1D
r
N
Q
m
0
00
0
u)
Q
O
r
1D
r
p
001
00
M
0
co
d
Lo
d
d
O
u7
u7
MI
M
oI
CD
O
0
(D
Mj
00
~t
M
Ir
to
N 10)
0!(A ~
0i
1:
M
M
•
J
O
R
N
0
l
,
N 1
0
M
Q
1•
CO
Q
O
M'
N
O j
0
1
OD O
A
;
"y
Y
O
O
CD
Q
_
Q
N
O
r-
r
M
oc
n
O
Q
N
O
O
C7
N
a0
C
O
r
r
Q
O
O
O
Q
N
Nr
N
N In
04 TO
!
N i
i
,
N
N
N
N
r
N
N
N
N
N
M
ID :d
N l n
v
¢
j
-
O
ap
Q
O
Q
,
0
0
0
,
Q
O
8
Q
O
O
O
O
0 tD
r
'
I
-
w
V1
C
p
CD
r~
0
O
V
O
Q
O
O
O
!
Q
O
C
d
p
O.
d
O.
O
O
Q
Q
Q
I
,
Q
4
Q
d
CD
O
O
d
d
d
O
l
f~ M
00I0
OD
CD
I,
,
U
CD
Iq:
00 .
L
to
r
R
M
O
C
O
O
C, I
I~
p
d
n]
O!
O
p
O I
O
C.
R
O
O
O l
o
d
O
d
'n
d
O
d
d 1
FI '10
0 CO dJ
r
01
I'I
td
u7
cO
n'
d
O
1'-
I j
p l
d
0;
00
O
o
c
is
Q
Q
.
n 00 I (o
In
0
N
M
'
C
<O
r
U)
0
01
Q l
~
r
d
r
0
0-
N1
r •
0
, N
Q
O
Q
Qi
O
r
Q
r
V
r
O
d
a~
0
N
V
N
;r
r- I m
P
y
N
N
•
N!
N
r
'N
'i
N
s
N'
N
N
!r
M:10 -~i
M
N1
C
a
1
1
a l
O~
C
42
E
o
0
0 0
0
0
o
e
o
e
o
e
~
8
-
l
•
0
o
a
g
!
3°
0
0
O
_
z
W
•
0)!
•
N
j
Q)
0
¢
F
Q
y
m
N
O
O
d d
4
d
O
d
M
Cl
M
0
fD
0
to
Q
O
O
O
d
Q
d
V7I
O
0
O O
n
M
C *41
O
Q
O
i
tD
a
;
p '.10
W
ID
a
~
y
Im
¢
-U)
Im
C
_
O
r
O N
r
r
O
r
lA
o
00
Q
n
o
r
w
M
r
1D
o,
O
o
rI
~
r
IO
to
o'o
~rj
o
o
co
0
0
N
0',0
0
E O
0
U
0
Im
E2
o
U)
,e
a
-
I
I
E
o
(J U
E
_
H
cn
o
Ili
c
m
n1
-i
H
C
o
0
e e
0 l o
a
O
a
O
o
p
c
O
c
d
!il
0
r0+
u7
u7 O
H]
I
LID
! O
O
0
Of
R
Lo N
J l4
M
i M
U7
d
i
I
U
I
I i
I
d
I
, i
'
I
I
I
~
~
H
~
,
I
f
I
04
c
I
Q
rO
I
•
Q
Q
M
v
h
10
~
I
'I
I
'
,
=
~ C
y
I
I.
I
I
0
O
I
1
I
d
CIE
O
I
i
_
d
~
+
~
o
g
o
~
f
n
O
r
. N
N
7
O
r
M
M
0
r
-
N
M
M
n
~
u?
M
O
~
o
M
0
M
o
Mr`
a
t-
g
a
i
!
I
I
I
I
o
cn
n
v
r~
r~
n
~n
n
n
lu~
cn
M
n
u~
c
G
,
C
_
t
~
7
I ~
N
eN-'
r
M
m
r
m
r
m
r
I
!M
C4
rl r
r
r
r
~
i0
C 'C7
j
I
w
r
~
~
O
m I ~
r' p
~
r
~
M
O
M
47
r
~
O
O
N
~
N
I ~
0
' ~
I, O
~ I tf] I m
r I Q I p
~
r
n
Q
fD
4
~
' _ Ir-
l~ I`~" ~
i
I
'
E
A
CI
O
O
M
In
to
I ti
0~
N
p
f~i
.
Q
I
`
m
r,O
O
O
D
O
O
O
j Q
IQ
~,d
d:r.
0
O
O
a
I,I03 CIS
U)
- ~
C
2
r
r
r~Nl
r
r
r
N
i 11
t
r
S
_
,
I
0
r
CD
r
r
O
Ir
O
61. 0 I 0
O I
A I M E
O I O
R
n
0
~
O
'
'
j
I
`
a
G
r
T
N
N N
ov
r d
O
e
r
M
o
Q,
M
o
NR
o
C`1
r
r
~li N
C)
N
N
lc3l 6
C) Col
r I
; , z
d;r
d
r
c%>
p
`
o
O
Z
o
I
a
IU
i
Ia
Ij
'l LL !IM
I
1
m
Z
7
~
a
I
LL
a
a
z
i
~a
p
j
,
co
ca
0
U;2Y
a
a
0:
vh
r»
U)
M
U
U
'LL
H
F
.
4
`
-
-
eaR
1
z
zz
z
❑
❑
II Q
L
z
a ❑ I
L
❑
H
❑
❑
H H
¢
LL
❑
H
Hy!
I
U
U Q
U
H
11--
L
:
0
F-
, h f-.
I.
-
LL
LL
LL
LL
d
W
z
d
fue
7
U
7'
~
U
(j) '
U
tA
rn 1
;
_
S
Z)
U
(j)
D
d!
E
0)
I~t
Y
M
N
W
D
V
IM
M
m
I
fD
I
1
j
II
.
r¢-
c7
INt
U'!U
U
~
I
aD
Z
a
e~
0Irn
0
c`na
N
0
I
0
n
M
I
ao
cD'
m M
to
M
n
cq
O)
cl)
z
U•~
z
•U
C
IO:
!
U)
I'O
N
c. !
co
Y
d
•C
! C
O
'
m
a.+
IC
U
~
r
I
y
U ~C
U
!
(p
U
U
,
l
m m
m
m
7
Z~
Y
cca
ml
M
0
T
t7.
N
a
co
I y
y
o
.
'L
O
U
d d
(6 (6
I
CL
(6
Y
Y
`
C 'C
IC: C
I
C f`
(C
Y!C01
Y
Y
C O
I
Q
.
-
N
CJ
N
N
-
N
~
I
a
(0~
N
m
C Y'
C
~ E 0
c~
a
O
c
.
.
y
m
N
C
U
U
U U
•
'
U
U
cc
m
m
3
LL
~i
U'. d
f6 y
II
1C
m
U
!I co,
~
I
U
Y
as
I"
O~~,
co N
1U I
J
z
tC
CD
co
L
I, Q
I a
-
~ 0)
rn
a
y
O
V
LL
~
Ci
U; U
76
~
f6;
O
Z
U
m C
Y,V
C'
IY
w6i C
Y
C
0
O
O
N
~
N'
EI OJM
'
~
N
❑
N
L..
0. 7
l
C: Q y
n
O
Y
E
O
n
N
(j
N
W
F
C
4)
0)
W W
W
CL
W
x
'
co
a) : c
- co
1
V) co
~
I
U)
co
I
co
is
m
r-
m
U)
fa
U
i E
O N
IC~ z!x
a
a
4
U
m
N
u)
U)
o
~I
m
U
'U
j
C
(o
LL
co
,
ILL
f°
ti
co
(C
O
Z
-
M
c
I
D1
E
~
E
t
r C7
d
E
co
E
J
w
0
C
a)
C
a)
C
a)
0
-
0
7
-
i
Z:
U)
w
c
to
c
C7
C9
0
0
0
a
~
c°
in
z
U
Z
:
D
a
J
ap'
I
H
Memorandum
Date: October 15, 2012
To: Board of County Commissioners
Erik Kropp, Interim County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find September 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
RESOURCES:
Beg. Net Working Capital
Revenues
Current & Prior Taxes
Gen. Rev. - excl. Taxes
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Total Revenues
TOTALRESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non-Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS
NET (Resources - Requirements)
GENERALFUND
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Budget___ Actual Variance FY % Coll. %
FY 2013 Year End $
Bud et Pro'ection Variance
$ 8,700,000
$ 9,059,394
$ 359,394
100%
104%
$ 8,700,000
$ 9,059,394 $ 359,394
5,219,290
573,212
(4,646,078)
25%
3%
a)
20,877,160
20,877,160 -
595,433
1,435,249
839,816
25%
60%
b)
2,381,731
2,381,731 -
187,157
207,167
20,010
25%
28%
C)
748,626
748,626 -
345,006
404,354
59,348
25%
29%
1,380,023
1,380,023 -
3,100
4,117
1,017
25%
33%
c)
12,398
12,398 -
46,174
24,228
(21,946)
25%
13%
184,694
184,694 -
49,725
82,321
32,596
25%
41%
c)
198,900
198,900 -
17,100
225
(16,875)
25%
0%
d)
68,400
68,400 -
24,811
23,561
(1,250)
25%
24%
99,244
99,244 -
500
500
0
25%
25%
2,000
2,000 -
6,488,296
2,754,935
(3,733,361)
25%
11%
25,953,176
25,953,176 -
15,188,296
11,814,329
(3,373,967)
25%
34%
34,653,176
35,012,570 359,394
Exp.
885,307
823,380
61,927
366,910
302,317
64,593
18,096
15,717
2,379
1,318,667
1,218,065
100,602
208,466
213,370
(4,904)
65,248
58,597
6,651
68,007
66,280
1,727
30,587
29,393
1,194
406,168
209,718
196,450
1,941,676
1,941,676
5,309,132
2,936,837
2,372,295
3,264,163
3,302,949
38,786
8,573,295
6,239,786
2,333,509
6,615,002
5,574,543
(1,040,458)
25%
23%
3,541,227
3,541,227
-
25%
21%
1,467,638
1,467,638'
-
25%
22%
72,385
72,385
-
25%
23%
5,274,667
5,274,667
-
25%
26%
833,865
833,865
-
25%
22%
260,992
260,992
-
25%
24%
272,027
272,027
-
25%
24%
122,349
122,349
-
25%
13% e)
1,624,671
1,624,671
-
25%
n/a
7,766,703
-
7,766,703
25%
14%
21,236,524
13,469,821
7,766,703
25%
25%
13,056,652
13,056,652
-
25%
18%
34,293,176
26,526,473
7,766,703
f)
360,000
8,486,097
8,126,097
a) Current year taxes not due until November
b) Includes annual payments: PILT $730,983
c) A & T Grant received quarterly-July, October, January & April
d) State payment received quarterly
e) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013
f) Appropriation Transfers (authority to expend): County School Fund $360,000
Page 1
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
FY 2013
L
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,010,415
$ 995,051
$ (15,364)
100%
98%
$1,010,415
$ 995,051
$ (15,364)
Revenues
Federal Grants
1,500
-
(1,500)
25%
0%
a)
6,000
6,000
-
SB #1065-Court Assess.
12,500
5,335
(7,165)
25%
11%
50,000
50,000
-
Discovery Fee
3,250
1,810
(1,440)
25%
14%
13,000
13,000
-
Food Subsidy
5,250
4,086
(1,164)
25%
19%
21,000
21,000
-
OYA Basic & Diversion
93,837
-
(93,837)
25%
0%
b)
375,347
375,347
-
Inmate/Prisoner Housing
15,000
23,400
8,400
25%
39%
c)
60,000
85,000
25,000
Inmate Commissary Fees
25
-
(25)
25%
0%
100
100
-
Contract Payments
30,500
4,607
(25,894)
25%
4%
d)
122,000
122,000
-
Miscellaneous
50
-
(50)
25%
0%
200
200
-
Program Fees
13
-
(13)
25%
0%
50
50
-
MIP Diversion Fees
250
225
(25)
25%
23%
1,000
1,000
-
Interest on Investments
2,000
1,696
(304)
25%
21%
8,000
8,000
-
Leases
300
300
-
25%
25%
1,200
1,200
-
Grants - Private
125
719
594
25%
144%
c)
500
1,100
600
CFC Interfund Grant
31,415
-
(31,415)
25%
0%
a)
125,661
125,661
-
Interfund Grant - Gen Fund
5,000
-
(5,000)
25%
0%
a)
20,000
20,000
-
Total Revenues
201,015
42,177
(158,838)
25%
5%
804,058
829,658
25,600
Transfers In-General Fund
1,336,131
1,336,131
-
25%
25%
5,344,523
5,344,523
-
TOTAL RESOURCES
2,547,561
2,373,359
(174,202)
25%
33%
7,158,996
7,169,232
10,236
REQUIREMENTS: Exp.
Expenditures
Community Justice-Juvenile
Personnel Services
1,268,754
1,241,174
27,580
25%
24%
5,075,017
5,075,017 -
Materials and Services
298,490
243,416
55,074
25%
20%
1,193,960
1,193,960 -
Capital Outlay
25
-
25
25%
0%
100
100 -
Transfers Out
12,600
12,600
-
25%
25%
50,400
50,400 -
Contingency
209,880
-
209,880
25%
n/a
839,519
- 839,519
TOTAL REQUIREMENTS
1,789,749
1,497,190
292,559
25%
21%
7,158,996
6,319,477 839,519
NET (Resources - Requirements)
757,812
876,169
118,357
-
849,755 849,755
a) Grants received quarterly
b) Payments received quarterly
c) Revenues trending higher than anticipated
d) Contract payment reimbursement requests submitted monthly, receive 1-2 months in arrears
Page 2
SHERIFF - Fund 255
Statement of Financial Operating Data
Three Months Ended September 30, 2012
I Year to Date FY 2013 Year End
Budget Actual Variance FY % Coll. % ,,Budget_ Pro'ction Variance
RESOURCES:
Beg. Net Working Capital $ - $ - $ -
Revenues
Law Enf Dist Countywide 5,640,407 4,586,238 (1,054,169)
R~ .;:6160,423
Total Revenues 9,250,830 7,618,037 (1,632,793)
TOTAL RESOURCES
9,250,830
7,618,037
(1,632,793)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division
565,908
596,267
(30,359)
Civil
199,747
164,180
35,567
Automotive/Communications
450,156
621,047
(170,891)
Investigations/Evidence
377,045
367,734
9,311
Patrol/Civil/Comm Supp
2,067,340
1,929,814
137,526
Records
179,404
147,333
32,071
Adult Jail
2,585,518
2,416,248
169,270
Court Security
75,750
76,072
(322)
Emergency Services
48,633
46,778
1,855
Special Services Division
336,509
341,746
(5,237)
Regional Work Center
665,770
628,446
37,324
Training Division
126,238
101,260
24,978
Other Law Enforcement Svcs
160,876
159,800
1,076
Non-Departmental
21,313
21,313
(0)
Contingency
1,390,623
_
1,390,623
TOTAL REQUIREMENTS
9,250,830
7,618,037
1,632,793
100% n/a $ - $ - $ -
25% 20% 22,561,626 18,956,193 ((3,605,433)
25% 21% ry 4 ;i H74 ~ i.' S t 1~ -:lF0 )
25% 21% 37,003,318 31,344,452 (5,658,866)
25% 21% 37,003,318 31,344,452 (5,658,866)
Exp.%
25%
26%
2,263,630
2,263,530
100
25%
21%
798,989
798,889
100
25%
34% a)
1,800,625
1,805,150
(4,525)
25%
24%
1,508,180
1,508,080
100
25%
23% b)
8,269,358
8,219,358
50,000
25%
21%
717,617
717,517
100
25%
23% b)
10,342,072
10,292,072
50,000
25%
25%
303,001
302,901
100
25%
24%
194,533
194,433
100
25%
25%
1,346,037
1,346,037
-
25%
24%
2,663,078
2,662,978
100
25%
20%
504,950
504,850
100
25%
25%
643,504
643,404
100
25%
25%
85,253
85,253
-
25%
n/a
5,562,491
-
5,562,491
25%
21%
37,003,318
31,344,452
5,658,866
NET (Resources - Requirements) - - - - -
" Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures
a) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund expended in July 2012
b) Projected variance due to delays in filling open positions
Page 3
Fund 701 LED-Countywide
Statement of Financial Operating Data
Three Months Ended September 30, 2012
RESOURCES:
Beg. Net Working Capital
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants & Reimb
State Grant
Transp. of State Wards
SIB 1145
Prisoner Housing
Des. Cty Video Lottery Grant
Des Cty Court Security
Des Cty Juvenile Contract
Title III Reimbursement
Transport
Other
DC Fair & Expo Center
Inmate Commissary Fees
Work Center Work Crews
Concealed Handgun Classes
Inmate Telephone Fee
Soc Sec Incentive-Fed
Miscellaneous
Oregon Mentors
Debit Card Fee
Medical Services Reimb
Restitution
Sheriff Fees
Interest
Interest on Unsegregated
Donations - "Shop with a Cop"
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Fund 255 Departments.
Sheriff's Services
Civil
Auto/Comm
Adult Jail
Court Security
Emergency Services
Special Services
Work Center
Training
Other (CODE, Forensic)
Non Dept - ISF Charges
Contingency
Total to Fund 255
I Year to Date FY 2013 Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$4,507,352
$ 5,883,963
$ 1,376,611
3,846,435
-
(3,846,435)
110,000
420,234
310,234
7,500
-
(7,500)
18,500
9,019
(9,481)
1,250
-
(1,250)
369,998
369,998
(0)
12,500
-
(12,500)
1,250
5,000
3,750
60,250
60,028
(222)
1,045
-
(1,045)
125
486
361
875
6,500
5,625
1,000
756
(244)
2,500
1,518
(982)
12,500
6,965
(5,535)
875
1,650
775
20,000
5,710
(14,290)
1,250
4,000
2,750
1,250
1,745
495
250
-
(250)
25
109
84
3,250
259
(2,991)
1,250
-
(1,250)
62,500
58,382
(4,118)
7,083
7,095
12
883
106
(777)
12,974
11,288
(1,686)
1,250
-
(1,250)
4,558,568
970,848
(3,587,720)
100%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
131%
0% a)
96%
0%
12%
0%
25%
0%
100%
25%
0%
n/a b)
97%
186%
19%
15%
14%
47%
7%
80%
35%
0%
109%
2%
0%
23%
25%
3%
22%
0%
5%
$ 4,507,352
$5,883,963
$ 1,376,611
15,385,740
15,385,740
-
440,000
440,000
30,000
30,000
74,000
74,000
-
5,000
5,000
1,479,991
1,479,991
50,000
50,000
-
5,000
5,000
-
241,000
241,000
-
4,180
4,180
-
-
39,916
39,916
500
500
-
3,500
6,500
3,000
4,000
4,000
-
10,000
10,000
50,000
50,000
3,500
3,500
80,000
80,000
-
5,000
5,000
-
5,000
5,000
-
1,000
1,000
-
100
200
100
13,000
13,000
-
5,000
5,000
250,000
250,000
28,333
28,333
3,533
3,533
51,897
51,897
5,000
5,000
-
18,234,274
18,277,290
43,016
9,065,920 6,854,810 (2,211,110)
25% 30%
EXp.
22,741,626 24,161,253 1,419,627
528,314
556,657
(28,343)
25%
26%
2,113,257
199,747
164,180
35,567
25%
21%
798,989
165,995
229,011
(63,016)
25%
34%
663,980
2,585,518
2,416,248
169,270
25%
23%
10,342,072
75,750
76,072
(322)
25%
25%
303,001
48,633
46,778
1,855
25%
24%
194,533
232,844
236,467
(3,623)
25%
25%
931,377
665,770
628,446
37,324
25%
24%
2,663,078
77,169
61,900
15,269
25%
20%
308,676
160,876
159,800
1,076
25%
25%
643,504
10,678
10,678
(0)
25%
25%
42,712
889,112
-
889,112
25%
n/a
3,556,447
5,640,407
4,586,238
1,054,169
22,561,626
Transfer to Reserve Fund (703) 25,000 - 25,000 25% 0%
Non Dept - Comm System Res 20,000 - 20,000 25% 0%
Total Requirements 5,685,407 4,586,238 1,099,168 25% 20%
Net 3,380,514 2,268,573 (1,111,941)
a) Current year taxes not due until November
b) Approved carryover of prior year Title III funds
100,000
80,000
22.741.626
2,113,164
93
798,889
100
665,649
(1,669)
10,292,072
50,000
302,901
100
194,433
100
931,377
-
2,662,978
100
308,615
61
643,404
100
42,712
-
-
3,556,447
18,956,193 3,605,433
100,000
80,000 -
19,136,193 3,605,433
5,025,059 5,025,059
Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. Page 4
Fund 702 LED Rural
Statement of Financial Operating Data
Three Months Ended September 30, 2012
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants & Reimb
Federal Grants-BLM
US Forest Service
Bureau of Reclamation
State Grant
SB #1065 Court Assessment
Marine Board License Fee
Des Cty General Fund Grant
Des Cty Transient Room Tax
Des Cty Tax Office Contract
City of Sisters
Des Cty CDD Contract
Des Cty Solid Waste Contr
Des Cty Clerk/Election
School Districts
Security & Traffic Reimb
Seat Belt Program
Miscellaneous
False Alarm Fees
Restitution
Sheriff Fees
Court Fines & Fees
Impound Fees
Restitution - Street Crimes
Seizure/Forfeiture
Interest
Interest on Unsegregated
Grants-Private
Donations
Sale of Equip & Material
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Fund 255 Departments:
Sheriffs Services
Auto/Comm
Investigations
Patrol
Records
Special Services
Training
Non Dept - ISF Charges
T1`~!'Futtt~ 6
Year to Date FY 2013 Year End
Budget Actual Variance FY % Coll. % Bud et Projection Variance
I Contingency
$ 2,859,915 $ 3,244,571 $ 384,656 100% 113% $ 2,859,915 $ 3,244,571 $ 384,656
1,887,500
-
(1,887,500)
25%
0% a)
7,550,000
7,550,000
57,500
207,659
150,159
25%
90%
230,000
230,000
3,750
-
(3,750)
25%
0%
15,000
15,000
6,500
(6,500)
25%
0%
26,000
26,000
18,750
(18,750)
25%
0%
75,000
75,000
6,500
(6,500)
25%
0%
26,000
26,000
47,299
24,751
(22,548)
25%
13%
189,194
189,194
13,750
5,335
(8,415)
25%
10%
55,000
55,000
35,523
-
(35,523)
25%
0%
142,091
142,091
144,184
-
(144,184)
25%
0%
576,735
576,735
518,316
518,316
0
25%
25%
2,073,265
2,073,265
125
-
(125)
25%
0%
500
500
116,990
116,990
0
25%
25%
467,960
467,960
13,592
13,592
-
25%
25%
54,366
54,366
13,592
13,592
-
25%
25%
54,366
54,366
-
250
-
(250)
25%
0%
1,000
1,000
10,000
(10,000)
25%
0%
40,000
40,000
1,250
-
(1,250)
25%
0%
5,000
5,000
2,500
1,330
(1,170)
25%
13%
10,000
10,000
1,500
3,577
2,077
25%
60%
6,000
6,000
500
1,200
700
25%
60%
2,000
2,000
1,250
45
(1,205)
25%
1%
5,000
5,000
2,500
3,068
568
25%
31%
10,000
10,000
30,000
28,258
(1,742)
25%
24°%
120,000
120,000
-
1,000
1,800
800
25%
45%
4,000
4,000
125
-
(125)
25%
0%
500
500
-
250
-
(250)
25%
0%
1,000
1,000
-
2,500
3,281
781
25%
33%
10,000
10,000
-
450
53
(397)
25%
3%
1,800
1,800
-
-
1,500
1,500
25%
n/a
-
1,500
1,500
-
2,500
2,500
25%
n/a
-
2,500
2,500
2,500
432
(2,068)
25%
4%
10,000
10,000
-
10,000
-
(10,000)
25%
0%
40,000
40,000
-
2,950,446
947,278
2,003,167
50%
8%
11,801,777
11805,777
4,000
5,810,361
4,191,848
(1,618,512)
50%
29%
14,661,692
15,050,348
388,656
EXp.
37,593
39,610
(2,017)
25%
26%
150,373
150,366
7
284,161
392,036
(107,875)
25%
34%
1,136,645
1,139,501
(2,856)
377,045
367,734
9,311
25%
24%
1,508,180
1,508,080
100
2,067,340
1,929,814
137,526
25%
23%
8,269,358
8,219,358
50,000
179,404
147,333
32,071
25%
21%
717,617
717,517
100
103,665
105,278
(1,613)
25°%
25%
414,660
414,660
-
49,069
39,360
9,709
25%
20%
196,274
196,235
39
10,635
10,635
(0)
25%
25%
42,541
42,541
-
501,511
-
501,511
25%
n/a
2,006,044
-
2,006,044
3,615;W
3,031,800
14,4 1,692.
12, ;x259
2,053,433
Transfer to Reserve Fund (704)
25,000
25,000 25% 0%
100,000 100,000
Non Dept - Comm System Res
30,000 -
30,000 25% 0%
120,000 120,000 -
Total Requirements
3,665,423 3,031,800
633,623 25% 21%
14,661,692 12,608,259 2,053,433
Net
2,144,938 1,160,049
(984,889)
- 2,442,089 2,442,089
a) Current year taxes not due until November
Payment to Sheriff's Fund adjusted monthly to equal actual expenditures attributable to rural services. Page 6
PUBLIC HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date FY 2013 Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$1,336,051
$ 1,327,199
$ (8,852)
100%
99%
$1,336,051
$1,327,199
$ (8,852)
Revenues
Medicare Reimbursement
250
-
(250)
25%,
0%
1,000
1,000
-
Federal Grant
-
5,000
5,000
25%
n/a
-
5,000
5,000
Federal Grant (ARRA)
50,000
-
(50,000)
25%
0%
200,000
200,000
-
State Grant
704,142
-
(704,142)
25%
0%,
a)
2,816,567
2,934,303
117,736
Child Dev & Rehab Center
9,902
-
(9,902)
25%
0%a
b)
39,609
39,609
-
State Miscellaneous
33,685
7,298
(26,387)
25%
5%
b)
134,740
134,740
-
OMAP
156,897
76,512
(80,385)
25%
'12%
627,588
627,588
-
Title 19
88
-
(88)
25%
n/a
352
352
-
Family Planning Exp Proj
137,500
30,481
(107,019)
25%
6%
550,000
550,000
-
Local Grants
37,953
-
(37,953)
25%
0%
b)
151,810
161,810
10,000
Environmental Health-Water
23,050
10,856
(12,194)
25%
12%
92,200
92,200
-
Contract Payments
-
10,644
10,644
25%
n/a
-
15,000
15,000
Miscellaneous
-
1,539
1,539
25%
n/a
-
3,000
3,000
Patient Insurance Fees
48,300
27,341
(20,959)
25%
14%
193,200
193,200
-
Health Dept/Patient Fees
25,775
20,038
(5,737)
25%
19%
103,100
103,100
-
Vital Records-Birth
10,250
9,750
(500)
25%
24%
41,000
41,000
-
Vital Records-Death
25,000
26,775
1,775
25%
27%r,
100,000
100,000
-
Environmental Health-Lic Fac
180,013
70,331
(109,682)
25%
10%
c)
720,050
720,050
-
Interest on Investments
3,000
1,378
(1,622)
25-%
11%
12,000
12,000
-
Donations
1,325
17,416
16,091
25%
329%
5,300
22,277
16,977
Interfund Contract
39,657
-
(39,657)
25%
0%
158,629
158,629
-
Administrative Fee
200
200
0
25%
25%
800
800
-
Total Revenues
1,486,987
315,560
(1,171,427)
25%
5%
5,947,945
6,115,658
167,713
Transfers In-General Fund
587,340
587,340
-
25%
25%
2,349,357
2,349,357
-
Transfers In-PH Res Fund
15,034
15,034
-
25%
25%
60,136
60,136
-
Transfers In-Gen. Fund Other
16,275
16,275
-
25%
25%
65,100
65,100
-
TOTAL RESOURCES
3,441,687
2,261,408
(1,180,279)
25%
23%
9,758,589
9,917,450
158,861
REQUIREMENTS:
Exp. °io
Expenditures
Personnel Services
1,599,006
1,519,540
79,466
25%
24%
6,396,024
6,396,024
-
Materials and Services
517,864
454,162
63,702
25%
22%
d)
2,071,456
2,136,883
(65,427)
Capital Outlay
16,250
-
16,250
25%
0%
e)
65,000
-
65,000
Transfers Out
39,300
39,300
-
25%
25%
157,200
157,200
-
Contingency
267,227
-
267,227
25%
n/a
1,068,909
-
1,068,909
TOTAL REQUIREMENTS
2,439,647
2,013,001
426,646
25%
21%
9,758,589
8,690,107
1,068,482
NET (Resources • Requirements)
1,002,040
248,406
(753,634
-
1,227,343
1,227,343
a) State grant for July will be received in October.
Payment is pending until after the g
rant award is
executed
b) Received quarterly in arrears
c) Restaurant and Pool/Spa fees are due annually and received
in Dec/Jan
d) Projection includes grant related expenditures.
Appropriation will be increase
d
e) OCHIN System expenditure ma
de in FY 2012
Page 6
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
Federal Grant (ARRA)
State Grants
State Miscellaneous
Adult Mental Health Initiative
Title 19
Liquor Revenue
School Districts
Contract Payments
Miscellaneous
Patient Insurance Fees
Patient Fees
Interest on Investments
Rentals
Administrative Fee
Interfund Contract-Gen Fund
Total Revenues
Transfers In-General Fund
Transfers In-OHP-CDO
Transfers In-Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personnel Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Budget
Actual Variance
FY %
Coll. %
FY 2013 Year End
Budget Projection Variance
$ 3,320,968 $ 3,113,095 $ (207,873) 100% 94% $ 3,320,968 $ 3,113,095 $ (207,873)
1,625
2,395
770
25%
37%
6,500
6,500
-
40,000
31,068
(8,933)
25%
19%
160,000
125,056
(34,944)
11
35
24
25%
78%
45
100
55
63,087
-
(63,087)
25%
0%
a)
252,349
252,349
-
15,938
-
(15,938)
25%
0%
63,750
63,750
-
1,932,650
2,094,466
161,816
25%
27%
b)
7,730,599
7,863,477
152,878
15,465
10,841
(4,624)
25%
18%
61,860
61,860
-
50,000
-
(50,000)
25%
0%
200,000
200,000
-
67,362
29,011
(38,351)
25%
11%
269,446
269,446
-
35,375
23,854
(11,521)
25%
17%
141,500
141,500
-
17,250
-
(17,250)
25%
0%
69,000
69,000
-
-
34
34
25%
n/a
-
1,000
1,000
-
3,631
3,631
25%
n/a
-
5,000
5,000
21,883
32,502
10,619
25%
37%
87,532
87,532
-
238
355
117
25%
37%
950
950
-
6,250
5,286
(964)
25%
21%
25,000
25,000
-
4,625
2,500
(2,125)
25%
14%
18,500
18,500
-
1,323,132
1,293,132
(30,000)
25%
24%
5,292,527
5,292,527
-
31,750
-
(31,750)
25%
0%
a)
127,000
127,000
-
3,626,641
3,529,110
(97,531)
25%
24%
14,506,558
14,630,547
123,989
326,947
326,947
-
25%
25%
1,307,787
1,307,787
-
121,124
121,124
-
25%
25%
484,494
484,494
-
66,159
66,159
-
25%
25%
264,631
264,631
-
131,010
131,010
-
25%
25%
524,039
524,039
-
7,592,848
7,287,444
(305,404)
25%
36%
20,408,477
20,324,593
(83,884)
Exp.
2,811,872
2,700,629
111,243
25%
24%
c)
11,247,487
11,266,327
(18,840)
1,648,559
1,089,881
558,678
25%
17%
6,594,235
6,594,235
-
25
-
25
25%
0%
100
-
100
51,000
51,000
-
25%
25%
204,000
204,000
-
590,664
-
590,664
25%
n/a
2,362,655
-
2,362,655
5,102,120
3,841,510
1,260,610
25%
19%
20,408,477
18,064,562
2,343,915
2,490,728
3,445,934
955,205
-
2,260,031
2,260,031
a) Received quarterly, in arrears
b) Oregon Health Authority grant projected at amended contract amount
c) "On-Call" forecasted to exceed amount budgeted. Appropriation will be increased
Page 7
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2012
RESOURCES:
Beg. Net Working Capital
Revenues
Admin-Operations
Admin-GIS
Admin-Code Enforcement
Building Safety
Electrical
Contract Services
Env Health-On Site Prog
Planning-Current
Planning-Long Range
Total Revenues
Transfers In
General Fund - Gen Ops
General Fund - L/R Planning
A&T Reserve (D/S assistance)
Other
TOTAL RESOURCES
REQUIREMENTS:
EXPENDITURES & TRANSFERS
22,090
22,090 -
1,250
1,250 -
166,200
166,200 -
1,273,575
1,273,575 -
256,000
256,000 -
111,600
111,600 -
312,971
312,971 -
637,350
637,350 -
226,421
226,421 -
751,866
866,090
114,224
25%
29%
3,007,457
3,007,457
213,717
213,717
-
25%
25%
854,872
854,872
123,840
123,840
-
25%
25%
495,360
495,360
22,394
-
(22,394)
25%
0%
89,577
89,577
25
-
(25)
25%
0%
100
-
1,121,842
1,396,129
274,287
25%
31%
4,457,366
4,639,748
Admin-Operations
338,297
337,876
421
25%
Admin-GIS
29,445
28,932
513
25%
Admin-Code Enforcement
57,231
53,947
3,284
25%
Building Safety
155,272
151,409
3,863
25%
Electrical
50,808
47,732
3,076
25%
Contract Services
35,436
34,647
789
25%
Env Health-On Site Pgm
39,909
38,031
1,878
25%
Planning-Current
160,579
143,642
16,937
25%
Planning-Long Range
115,850
120,616
(4,766)
25%
Transfers Out (0/S Fund)
44,789
-
44,789
25%
Contingency
86,726
-
86,726
25%
Exp.
(100
182,382
25%
1,353,189
1,353,189 -
25%
117,778
117,778 -
24%
228,925
228,925 -
24%
621,087
621,087 -
23%
203,231
203,231 -
24%
141,745
141,745 -
24%
159,636
159,636 -
22%
642,315
642,315 -
26% C)
463,401
390,000 73,401
0%
179,155
179,155 -
n/a
346,904
- 346,904
TOTAL REQUIREMENTS 1,114,342 956,832 157,510 25% 21% 4,457,366 4,037,061 420,305
NET (Resources - Requirements) 7,500 439,298 431,798 - 602,687 602,687
Revenues 866,090 3,007,457 3,007,457 -
Expenditures 956,832 4,457,366 4,037,061 420,305
Net from Operations (90,742) (1,449,909) (1,029,604) 420,305
a) Revenue is sporadic throughout the year as GIS services are requested
b) Revenue typically lags 1-2 months behind due to billing cycles
c) YTD Personnel expenditures exceeds budget to date due to payout of retired employee; however, year end projection will be less
than anticipated as position will not be filled
Year to Date FY 2013 Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482
5,523
9,017
3,494
25%
41%
313
290
(23)
25%
23% a)
41,550
56,376
14,826
25%
34%
318,394
359,253
40,859
25%
28%
64,000
90,130
26,130
25%
35%
27,900
22,617
(5,283)
25%
20% b)
78,243
77,671
(572)
25%
25%
159,338
173,611
14,273
25%
27%
56,605
77,124
20,519
25%
34%
Page 8
ROAD
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
FY 2013
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$4,719,551 $
4,723,852
$ 4,301
100%
100%
$ 4,719,551
$ 4,723,852
$ 4,301
Revenues
System Development Charge
-
924
924
25%
n/a
-
1,200
1,200
Federal Grant (ARRA)
1,750
-
(1,750)
25%
0%
7,000
7,000
-
Mineral Lease Royalties
10,000
5,726
(4,274)
25%
14%
40,000
40,000
-
Forest Receipts
99,207
-
(99,207)
25%
0%
a)
396,826
396,826
-
State Miscellaneous
135,573
-
(135,573)
25%
0%
b)
542,290
542,290
-
Motor Vehicle Revenue
2,697,511
2,509,537
(187,974)
25%
23%
10,790,043
10,790,043
-
City of Bend
6,250
-
(6,250)
25%
0%
c)
25,000
25,000
-
City of Redmond
87,500
10,807
(76,693)
25%
3%
c)
350,000
350,000
-
City of Sisters
2,500
-
(2,500)
25%
0%
c)
10,000
10,000
-
City of La Pine
2,500
-
(2,500)
25%
0%
c)
10,000
10,000
-
Admin Recovery (SDC)
-
838
838
25%
n/a
-
1,000
1,000
Miscellaneous
5,000
3,654
(1,346)
25%
18%
20,000
20,000
-
Road Vacations
250
-
(250)
25%
0%
1,000
1,000
-
Interest on Investments
3,750
7,455
3,705
25%
50%
15,000
15,000
-
Interfund Contract
172,500
-
(172,500)
25%
0%
d)
690,000
690,000
-
Equipment Repairs
55,000
41,599
(13,401)
25%
19%
220,000
220,000
-
Vehicle Repairs
22,500
-
(22,500)
25%
0%
d)
90,000
90,000
-
LID Construction
2,500
-
(2,500)
25%
0%
d)
10,000
10,000
-
Vegetation Management
6,250
-
(6,250)
25%
0%
d)
25,000
25,000
-
Forester
6,250
-
(6,250)
25%
0%
d)
25,000
25,000
-
Car Washes
1,000
-
(1,000)
25%
0%
4,000
4,000
-
Car Rental
250
-
(250)
25%
0%
1,000
1,000
-
Sale of Equip & Material
180,900
157,301
(23,599)
25%
22%
723,600
723,600
-
Total Revenues
3,498,941
2,737,842
(761,099)
25%
20%
13,995,759
13,997,959
2,200
Trans In - Solid Waste
69,068
69,068
-
25%
25%
e)
276,272
276,272
-
Trans In - Transp SDC
62,500
62,500
-
25%
25%
e)
250,000
250,000
-
Trans In-Road Imp Res
3,000
-
(3,000)
25%
0%
d)
12,000
12,000
-
TOTAL RESOURCES
8,353,060
7,593,262
(759,798)
25%
43%
19,253,582
19,260,083
6,501
REQUIREMENTS: Exp.
Expenditures
Personnel Services
11341,301
1,329,420
11,881
25%
25%
5,365,202
5,365,202 -
Materials and Services
2,359,666
2,459,042
(99,376)
25%
26% f)
9,438,662
9,438,662 -
Capital Outlay
509,325
6,684
502,641
25%
0%
2,037,300
2,037,300 -
Transfers Out
68,750
-
68,750
25%
0%
275,000
275,000 -
Contingency
534,355
-
534,355
25%
n/a
2,137,418
- 2,137,418
TOTAL REQUIREMENTS
4,813,397
3,795,146
1,018,251
25%
20%
19,253,582
17,116,164 2,137,418
NET (Resources - Requirements) 3,539,663 3,798,116 258,453
a) Payment received annually in January
b) Payment expected in November
c) Billed upon completion of work
d) Payments to be received in June 2013 from other Road Department funds
e) Payments made quarterly
f) Expenditures are seasonal and higher during summer months
- 2,143,919 2,143,919
Page 9
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
FY 2013
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 570,000
$ 630,226
$ 60,226
100%
111%
$ 570,000
$ 630,226
$ 60,226
Revenues
DOC Measure 57
54,810
219,240
164,430
25%
100%
a)
219,240
219,240
-
State Miscellaneous
1,075
-
(1,075)
25%
0%
b)
4,301
4,301
-
Alternate Incarceration
3,750
-
(3,750)
25%
0%
c)
15,000
15,000
-
State Subsidy
3,457
3,457
(0)
25%
25%
13,826
13,826
-
SB 1145
687,139
687,139
(0)
25%
25%
2,748,556
2,748,556
-
Probation Work Crew Fees
5,625
3,908
(1,718)
25%
17%
22,500
22,500
-
Miscellaneous
1,125
591
(534)
25%
13%
4,500
4,500
-
Electronic Monitoring Fee
32,500
37,368
4,868
25%
29%
130,000
130,000
-
Probation Superv. Fees
47,500
43,756
(3,744)
25%
23%
190,000
190,000
-
Interest on Investments
2,250
1,223
(1,027)
25%
14%
9,000
9,000
-
Interfund - Sheriff
12,500
12,500
0
25%
25%
50,000
50,000
-
Crime Prevention Grant
12,500
-
(12,500)
25%
0%
c)
50,000
50,000
-
CFC-Domestic Violence
18,708
-
f18,708)
25%
0%
c)
74,832
74,832
-
Total Revenues
882,939
1,009,181
126,242
25%
29%
3,531,755
3,531,755
-
Transfers In-General Fund
108,831
108,831
-
25%
25%
435,328
435,328
-
TOTAL RESOURCES
1,561,770
1,748,238
186,468
25%
39%
4,537,083
4,597,309
60,226
REQUIREMENTS:
Exp.
Expenditures
Personnel Services
772,823
729,978
42,846
25%
24%
3,091,291
3,091,291
-
Materials and Services
222,422
177,671
44,751
25%
20%
889,687
889,687
-
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
139,001
-
139,001
25%
n/a
556,005
-
556,005
TOTAL REQUIREMENTS 1,134,271 907,649 226,622 25% 20%
NET (Resources - Requirements) 427,499 840,589 413,090
a) Payment received annually in September
b) Annual allocation normally received by end of calendar year
c) State/County invoiced quarterly
4,537,083 3,980,978 556,105
- 616,331 616,331
Page 10
CHILDREN & FAMILIES COMMISSION
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date FY 13 Year End
Budget Actual Variance FY % Coll. % Budget Pro'ection Variance
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
Title IV - Family Sup/Pres
HealthyStart Medicaid
Level 7 Services
State Prevention Funds
HealthyStart /R-S-G
OCCF Grant
Program Fees
Charges for Svcs-Mist
Court Fines & Fees
Interest on Investments
Grants, Private
Interfund Grants
Total Revenues
$ 511,994 $ 574,985 $ 62,991 100% 112% $ 511,994 $ 574,985 $ 62,991
49,860
-
(49,860)
9,883
-
(9,883)
21,250
21,456
206
49,225
-
(49,225)
12,031
12,031
(0)
54,988
54,987
(1)
104,949
97,985
(6,964)
-
2,112
2,112
2,000
50
(1,950)
19,871
18,817
(1,054)
250
990
740
500
-
(500)
80,219
45,000
35,2
405,026
253,427
(151,599)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Trans from General Fund 69,000 69,000 - 25%
Total Transfers In 69,000 69,000 - 25%
0%
a)
199,441
259,168
59,727
0%
39,533
39,533
-
25%
8)
85,000
60,000
(25,000)
0%
196,898
196,898
-
25%
b)
48,122
58,022
9,900
25%
219,951
219,951
-
23%
a)
419,796
391,940
(27,856)
n/a
-
3,500
3,500
1 %
8,000
4,000
(4,000)
24%
c)
79,485
75,034
(4,451)
99%
1,000
5,000
4,000
n/a
2,000
-
(2,000)
14%
d)
320,874
350,374
29,500
16%
1,620,100
1,663,420
43,320
25%
275,984
275,984
-
25%
275,984
275,984
-
TOTAL RESOURCES 986,020 897,413 (88,607) 25% 37% 2,408,078 2,514,389 106,311
REQUIREMENTS: Exp. °i°
Expenditures
Personnel Services
161,869
150,187
11,682
25%
23% e)
647,474
601,397
46,077
Materials and Services
368,999
48,100
320,899
25%
3% f)
1,475,997
1,545,250
(69,253)
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
71,127
-
71,127
25%
n/a
284,507
284,507
TOTAL REQUIREMENTS
602,020
198,287
403,733
25%
8%
2,408,078
2,146,647
261,431
NET (Resources - Requirements)
384,000
699,125
315,125
-
367,742
367,742
a) New Federal grants of $112,427 was awarded while $50,000 STOP grant denied
b) Additional GLS grant funds of $3,500 awarded
c) State reduced the Circuit Court fees
d) Additional grant funds of $17,500 - A & D 70 and $12,000 EUDL projected to be received
e) Personnel expenditures projected to be less than appropriated. Open position, due to retirement, will not be filled
f) M & S projected to be greater than originally budgeted due to new Federal grant awarded. Appropriation transfer will be requested
Page 11
SOLID WASTE
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date !B:u 2013 Year End
Budget Actual Variance FY % Coll. % d e t Proiection Variance
RESOURCES:
Beg. Net Working Capital
$ 700,513 $
Revenues
Miscellaneous
5,500
Franchise 3% Fees
50,000
Commercial Disp. Fees
215,000
Private Disposal Fees
328,500
Franchise Disposal Fees
1,000,000
Yard Debris
18,250
Special Waste
6,250
Interest
1,875
Leases
2,700
Recyclables
11,250
Total Revenues
1,639,325
TOTAL RESOURCES
REQUIREMENTS
Expenditures
Personnel Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out-Road
Trans Out-Capital Res
Contingency
807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957
5,236
(264)
25%
24%
22,000
22,000 -
8,556
(41,444)
25%
4%
a)
200,000
200,000 -
257,263
42,263
25%
30%
860,000
860,000 -
409,154
80,654
25%
31%
1,314,000
1,314,000 -
1,086,591
86,591
25%
27%
4,000,000
4,000,000 -
38,103
19,853
25%
52%
b)
73,000
73,000 -
4,453
(1,797)
25%
18%
c)
25,000
25,000 -
2,170
295
25%
29%
7,500
7,500 -
3,600
900
25%
33%
10,801
10,801 -
15,128
3,878
25%
34%
45,000
45,000 -
1,830,255
190,930
25%
28%
6,557,301
6,557,301 -
2,339,838 2,637,725 297,887 25% 36%
433,330
414,013
19,317
25%
747,328
490,685
256,643
25%
236,678
-
236,678
25%
20,750
-
20,750
25%
69,068
69,068
-
25%
157,500
315,000
(157,500)
25%
149,799
-
149,799
25%
Exp.
7,257,814 7,364,771 106,957
24%
1,733,321
1,733,321 -
16%
d)
2,989,313
2,989,313 -
0%
e)
946,713
946,713 -
0%
f)
83,000
83,000 -
25%
9)
276,272
276,272 -
50%
h)
630,000
630,000 -
n/a
599,195
599,195
TOTAL REQUIREMENTS 1,814,453 1,288,766 525,687 25% 18% 7,257,814 6,658,619 599,195
NET (Resources - Requirements) 525,385 1,348,959 823,574
706,152 706,152
a) Due April 15, 2013
b) Seasonal item-Fall and Spring
c) Dependent on special clean-ups such as asbestos and contaminated soil
d) Purchasing will pick up as year progresses
e) Semi-Annual: November and May
f) In the process of contacting bidders
g) Quarterly
h) One half of appropriation transferred in September. Balance will be transferred by June 30, 2013
Page 12
RISK MANAGEMENT
Statement of Financial Operating Data
Three Months Ended September 30, 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 Liab/Property
Process Fee-Events/Parades
Miscellaneous
Skid Car Training
NSF Fee
Interest on Investments
Other Interest
TOTAL REVENUES
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Miscellaneous
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Insurance
Repair / Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement / Benefit
Professional Service
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Year to Date
Year End
Budget Actual Variance % of FY F-1. Coll. Budget Projection Variance
$2,000,000 $2,240,791 $240,791
65,583
65,583
0
78,370
78,370
0
43,409
43,409
(0)
360,044
360,044
0
62,500
62,538
38
125
-
(125)
15,000
923
(14,077)
500
145
(355)
13
35
23
4,000
960
(3,040)
-
30
30
3,750
3,253
(497)
13
-
(13)
633,306
615,290
(18,016)
2,633,306 2,856,081 222,775
349,080
19,933
2,604
135,600
5,439
45
75,000 512,702 (437,702)
100% 112% $2,000,000 $2,240,791 $240,791
Total Direct Insurance Costs
Insurance Administration:
Personnel Services
Materials & Service
Capital Outlay
Total Insurance Administration
Transfers Out
TOTAL REQUIREMENTS
NET
a) Annual premium paid in July 2012
25%
25%
262,333
262,333 -
25%
25%
313,480
313,480
25%
25%
173,635
173,635 -
25%
25%
1,440,176
1,440,176 -
25%
25%
250,000
250,000 -
25%
0%
500
500 -
25%
2%
60,000
60,000 -
25%
7%
2,000
2,000 -
25%
70%
50
50 -
25%
6%
16,000
16,000 -
25%
n/a
-
30 30
25%
22%
15,000
15,000 -
25%
0%
50
50 -
25%
24%
2,533,224
2,533,254 30
25% 63% 4,533,224 4,774,045 240,821
Ex .
a)
25% 171% 300,000 800,000 (500,000)
158,508 a)
5,315
62,500 163,823 (101,323) 25% 66% 250,000 250,000 -
366
668
2,917
25,000 3,952 21,048 25% 4% 100,000 100,000 -
72,058
69,009
16,248
250,000 157,315 92,685
62,500 62,500
475,000 837,792 (362,792)
76,974
70,106
6,868
42,248
30,093
12,155
25
-
25
119,247
100,199
19,048
1,800
1,800
-
596,047
939,791
(343,744)
2,037,260
1,916,290
120,969
a)
25% 16% 1,000,000 1,000,000 -
25% 0% 250,000 240,000 10,000
25% 44% 1,900,000 2,390,000 (490,000)
25%
23%
307,896
307,896
-
25%
18%
168,990
168,990
-
25%
0%
100
-
100
25%
21%
476,986
476,886
100
25%
25%
7,200
7,200
-
25%
39%
2,384,186
2,874,086
(489,900)
2,149,038
1,899,959
(249,079)
Page 13
" Contingency is $2,149,038.
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Y 13
Year End
Budget
Actual
Variance
% of FY
% Coll.
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$8,000,000 $
8,883,086
$ 883,086
100%
111%
$8,000,000
$8,883,086
$ 883,086
Revenues
Property Taxes - Current
1,636,922
-
(1,636,922)
25%
0%
a)
6,547,687
6,547,687
-
Property Taxes - Prior
46,250
164,600
118,350
25%
89%
185,000
185,000
-
Federal Grants
60,000
-
(60,000)
25%
0%
b)
240,000
240,000
-
State Reimbursement
9,000
-
(9,000)
25%
0%
c)
36,000
36,000
-
Telephone User Tax
187,500
-
(187,500)
25%
0%
750,000
750,000
-
Data Network Reimb.
7,500
-
(7,500)
25%
0%
d)
30,000
30,000
-
Jefferson County
7,500
526
(6,974)
25%
2%
30,000
30,000
-
UserFee
11,000
-
(11,000)
25%
0%
e)
44,000
44,000
-
Police RMS User Fees
69,738
-
(69,738)
25%
0%
d)
278,950
278,950
-
Contract Payments
7,750
-
(7,750)
25%
0%
d)
31,000
31,000
-
Miscellaneous
2,250
1,970
(280)
25%
22%
9,000
9,000
-
Interest
10,000
12,493
2,493
25%
31%
40,000
40,000
-
Interest on Unsegregated Tax
150
44
106
25%
7%
600
600
-
Total Revenues
2,055,560
179,634
(1,875,926)
25%
2%
8,222,237
8,222,237
-
TOTAL RESOURCES
10,055,560
9,062,719
(992,841)
25%
56%
16,222,237
17,105,323
883,086
REQUIREMENTS:
~~o Exp.
Expenditures
Personnel Services
1,085,123
993,296
91,827
25%
23%
4,340,490
3,800,000
540,490
Materials and Services
512,551
475,554
36,997
25%
23%
2,050,202
2,050,202
-
Capital Outlay
140,500
-
140,500
25%
0%
562,000
562,000
-
Transfers Out-Reserve Fund
125,000
500,000
(375,000)
25%
100%
f)
500,000
500,000
-
Contingency
2,192,386
-
2,192,386
25%
n/a
8,769,545
-
8,769,545
TOTAL REQUIREMENTS
4,055,560
1,968,850
2,086,710
25%
12%
16,222,237
6,912,202
9,310,035
NET (Resources - Requirements)
6,000,000
7,093,869
1,093,869
-
10,193,121
10,193,121
a) Current year taxes not due until November
b) ODOT Project-reimbursements expected to be received over the next 3-4 months
c) July & August bills have been mailed; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance
d) Annual billings to Police/Fire agencies to be mailed in December
e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June
f) Amount appropriated was transferred September 15, 2012
Page 14
Health Benefits Trust
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
FY 2013
Bud et
Actual
Variance
FY %
Cou. %
Bud et
Projection
Variance
RESOURCES
Beg. Net Working Capital
$13,800,000
$14,551,028
$ 751,028
100%
105%
$ 13,800,000
$14,551,028
751,028
Revenues:
Internal Premium Charges
3,198,750
3,200,520
1,770
25%
25%
12,795,000
12,795,000
-
PIT Emp - Addl Prem
12,500
8,343
(4,157)
25%
17%
50,000
50,000
Employee Prem Contribution
157,500
158,210
710
25%
25%
630,000
630,000
COIC
325,000
345,094
20,094
25%
27%
1,300,000
1,300,000
Retiree / COBRA Co-Pay
187,500
241,469
53,969
25%
32%
750,000
750,000
-
Medical Services Reimb
-
323
323
25%
n/a
-
323
323
Federal Payment (ERRP)
-
-
25%
n/a "
Prescription Rebates
-
n/a
Claims Reimbursements
58,757
58,757
25%
n/a
58,757
58,757
Vending Machines (Wellness Rebate)
-
-
-
25%
n/a
-
-
-
Interest
20,000
21,099
1,099
25%
26%
80,000
80,000
-
Total Revenues
3,901,250
4,033,815
132,565
25%
26%
15,605,000
15,664,081
59,081
TOTAL RESOURCES
17,701,250
18,584,842
883,592
92%
105%
29,405,000
30,215,108
810,108
REQUIREMENTS
Expenditures:
Personnel Services (all depts)
Materials & Services
Claims Paid-Medical
Claims Paid-Prescription
Claims Paid-Dental/Vision
Claims Refunds
Insurance Premiums
State Assessments
Administration Fee
Preferred Provider Fee
Health Impact
Refund - ERRP
Other - Administration
Other - Wellness
Admin & Wellness
Deschutes On-site Clinic
Healthstat
Medical Supplies
Equipment
Other
Total DOC
Deschutes On-site Pharmacy
Contracted Services
Medication and Drugs
Start Up Costs-Take Care
Other
Total Pharmacy
Capital Outlay
Contingency
EE 9
50,193
48,341
1,852
25%
24%
200,772
200,772
2,507,550
2,851,119
(343,569)
25%
28% a)
10,030,200
11,404,475
(1,374,275)
480,900
338,593
142,307
25%
18% a)
1,923,600
1,354,373
569,227
446,550
416,305
30,245
25%
23% 3)
1,786,200
1,665,218
120,982
-
(11,309)
11,309
25%
n/a
-
(11,309)
11,309
87,500
85,288
2,212
25%
24%
350,000
350,000
-
40,000
89,329
(49,329)
25%
56%
160,000
160,000
80,000
81,910
(1,910)
25%
26%
320,000
320,000
12,500
12,541
(41)
25%
25%
50,000
50,000
13,750
12,963
788
25%
24%
55,000
55,000
-
58,552
(58,552)
25%
n/a b)
-
58,552
(58,552)
16,338
6,882
9,457
25%
11%
65,353
65,353
26,250
5,088
21,162
25%
5%
105,000
105,000
3,711,338
3,947,258
(235,920)
25%
27%
14,845,353
15,576,661
(731,308)
171,000
160,841
10,159
25%
24% C)
684,000
684,000
7,500
4,529
2,971
25%
15%
30,000
30,000
250
-
250
25%
0%
1,000
1,000
5,358
18,304
(12,946)
25%
85%
21,433
21,433
184,108
183,674
434
25%
25%
736,433
736,433
77,072
79,934
(2,862)
25%
26% c)
308,287
308,287
250,000
296,316
(46,316)
25%
30% C)
1,000,000
1,000,000
-
59,898
59,898
25%
n/a c)
-
59,898
(59,898)
4,140
4,249
(109)
25"/
We
16,559
16,559
331,212
440,397
(109,185)
25%
n/a
1,324,846
1,384,744
(59,898)
25
-
25
25%
n/a
100
-
100
3,074,374
-
3,074,374
25%
n/a
12,297,496
-
12,297,496
TOTAL EXPEND/REQUIREMNTS 7,020,039 4,619,670 2,731,580 25% 16% 29,405,000 17,898,610 11,506,390
NET (Resources - Requirements) 10,681,212 13,965,172 3,615,172 - 12,316,498 12,316,498
Revenues less Expenditures (585,856) (2,234,529)
a) Projection based on annualizing 13 weeks of claims paid. YTD actual is $250,470 per week
b) Disallowance of Early Retiree Reinsurance Program items (Reported as revenue in FY 2012)
c) YTD Actual include estimates: September Healthstat, July through September Take Care Admin, August through September
"ingredient" costs and Start up costs (prior year). These items had not been paid as of September 30, 2012 Page 15
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)
Total Transfers In
TOTAL RESOURCES
REQUIREMENTS:
Expenditures:
Personnel Services
Materials and Services
Debt Service
Capital Outlay
Total Expenditures
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Deschutes County - Fair and Expo Center
YTD-Budget Basis Commissioners
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Budget (3/12 of
annual)
I Actual
Variance
FY %
7Coll
Year End
FY 2013
Budget Projection Variance
$ 46,373
$ 35,055
$ (11,318)
100%
76%
$ 46,373
$ 35,055
$ (11,318)
151,895
68,253
(83,642)
25%
11%
607,578
580,831
(26,747)
375
84
(291)
25%
6%
1,500
1,210
(290)
14,360
-
(14,360)
25%
0%
57,441
57,441
-
1,500
-
(1,500)
25%
0%
6,000
6,000
-
7,500
16,262
8,762
25%
54%
30,000
46,262
16,262
47,500
20,500
(27,000)
25%
11%
190,000
197,500
7,500
23,750
16,000
(7,750)
25%
17%
95,000
95,000
-
5,000
600
(4,400)
25%
3%
20,000
20,000
-
_ 1,700
121
(1,579)
25%
n/a
6,800
6,221
(579)
253,580
121,820
(131,759)
25%
12%
_
1,014,319
1,010,464
(3,855)
42,500
42,501
-
25%
25%
170,000
170,000
-
6,436
6,435
-
25%
25%
25,744
25,744
-
20,700
20,700
-
25%
25%
82,800
82,800
-
66,065
150,000
83,935
25%
57%
264,259
264,259
-
135,701
219,636
83,935
542,803
542,803
-
435,654
376,511
(59,142)
25%
23%
1,603,495
1,588,322
(15,173)
Exp.
207,971
203,828
4,143
25%
25%
831,882
827,756
4,126
126,556
115,987
10,569
25%
23%
506,223
516,785
(10,562)
28,530
-
28,530
25%
0%
114,119
114,119
-
3,565
9,000
(5,435)
25%
63%
14,259
14,259
-
366,621
328,815
37,806
1,466,483
1,472,919
(6,436)
34,253
-
34,253
25%
n/a
137,012
-
137,012
400,874
328,815
72,059
25%
21%
1,603,495
1,472,919
130,576
34,780 47,696 12,916
- 115,403 115,403
Page 16
H
v
w
ti
0
a
a
a
H
a
cl
U
0
0
z
a~
as
_N
a
co N
~ M
7 ~
c
U
U) U)
❑
7 ~
U C ~
ayioo
OVt
~ c
t: o
o a
z m
U
c
y
M
M
M
co
O
1 1 1 1
.
1 1 1 1 1
1 1
1
T
M
t" I
r
M
r
M
a CMddO
t+1
CD C) Gaa
m
m
MO
M
to
r-
0 r a CD 'T
in
aaLO CD t)
W)
ra
r
0
cc
t't~Qaf-
I 't
r
aO
Q
1
r
a
a [V U) tO M
C
10 a M UJ a
CD
N C7
N
O
0
CD CD
N¢r
tiTf+N
V-
V*
C"7
m
K7
QM
Q
N
<h
CO T
to
r tr1
~
t!1
aMaCD CD co
CD CD CD CD a
a
Math
cri40
IN-
CD rO0Ig
aaaCI-
w
lr
CD aIL?CD CD
0 CD (D0
'
V)
r
rp
aa
r
a
T
to
1+
to
t~
o
aNY5aM
0C)N0r
4]47M16 a
CM r- V- hN
GD
0
NQ
t't'
N
a
C6
r
V
N
ti
r
ce)
LO
QM
h
M
ao
cri V-:
1-: C6
Ili
9;
to ~o
.0
l'
MatUQ
1►
a LCIQT
M
M
M0
M
to
N
Taaa
r
r cnMco
W
rM
Q
Cl
r-
' O O O tQ
tp
C ' in u7 m
tp
a N
N
'
to
n
Q
O
C4 Q
Na
t7
ao
O
O
q
rf co
a
IT
et
y
j
r
N
r
T
w
CD
a
Cl
0
1 1 1 1 1
.
C 1 1 1 1
1
O
1 1
1
1
Q
0
N
N
N
N
CV) CD CD
a
!
c
M
M
Q
M
0
N
Tan
'
M
OD
~
~pp
+7
rt
N
a t7 t' co
co
co ' w to to
tD
a N
'
a
ti
NWaIV
r
1~ Q t7
t)
N
N
to
9)
N
T
q
co
O_
Q
e
to
N
T
T
T
to
O
_
U
tl ~
~ m
m
41
co U)
y r
N
r
C
U
rn W
ttt
p-0 v
c ❑
tom
a ~ ~
c LL Li m
m•N a ~
U oLi
= 0
cm
c
m
R
m m
M- m cm N
to
-o
co x mw 0
(D
c
co a
j
U
V m 4) H 0 c m
h- v o
a
j U
C
C v v tp
G 1 m 4) c H
O m a
.
O!
~a 0 U)
a.2 s.G v;
c
ma
w
WC °°c ;g
amic' y
r
am44)H
o0
w m p m m p
x roQW_LL~
F
m~~
V o
w
~ m -i F-
w Z
U
1-
z
co
tU Y"`
OI O
"O N
O `aV N
m ~ T
O c
.O tU
M LL
m V)
N
U.
LL WS
0
C 'O
w a`
ow c
c
CL U
S co
c
p
c Q
o a` °
m °
row
3 co
to
u a~'i
T N Ld
N r
T
LL O
_ N
r LL
O a
m ~
4 LL U
0 c
to
c
U
Utnm
m 41)
J=
U o
0 1°
- C.
.0 C m
4) " a
Nt C-'
HH
* mm
N U)
Cp ~
~z
LLI
N
LL I- t-
N
O O
• U
m O :o
r!i Z E
U Q
U Q
O
U U U)
Z O)
~ m o
U j H
L U
Z W
1 ~ 1 1 1 1 1 O
U
0 O
O
n
(p
0
N N
m
0 C) 0 611
LO
O
O LO NICT ti a co
N
v
a 1- N 1- LO M 0
Ln
0.
L C C c6 fz
N Q
C
7
O
E
Q
C
a a o
(D
0 0 In Ln
C
00f-- ti
_
cei
N N
0
r
-
E
Q
O
U
a)
15
E
W
O
E N
.2-
N
lA
w
u) rn
L
ca
N
o
c E¢ ca -o
a
c
O p
x
Lu
E 0 8 a •
E
N -0
(D
fn m (D 0~
to
C r ~ 1
N
0. 4) 0. 0 0) y
rnrn c LL
E'E
=3
-0
c
E
c~
~
OULU00COELH
4 N 2 U) I
`
O
N N N aa)
N
L L L L L L L
L
nc
W
4 L L L V L L
L
V " V V V V 0
C)
0
0
0_
0
_
00
(D
_
_ M
_ M
M
M
M
W
W
W
W
W W
W
W
N
ry
/
/ N
M
M M
~ M N ~ N N N
M
N
J J J J J J ..J
J
co m m m co co co
co
Q
O
O
N
O
r
tp
ti
't!
N
V
L
a
D
d
7.
R
CL
~a
O
F-
Deschutes County
Bethlehem Inn (Fund 128)
Three Months Ended September 30, 2012
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Lease Payments
Total Revenues
Transfers In:
Project Development (140)
Gen Capital Res (143)
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Interest Expense
Interest Payment
TOTAL REQUIREMENTS
NET (Resources - Requirements)
I Budget Actual Variance FY % Coil. % I Budget I Projection l Variance T
$(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173)
25,148 -
(25,148)
25%
0%
100,592
- (100,592)
6,102 6,102
-
25%
25%
24,408
24,408 -
31,250 6,102
(25,148)
25%
5%
125,000
24,408 (100,592)
412,500 -
(412,500)
25%
0%
1,650,000
- (1,650,000)
265,000 -
(265,000)
25%
0%
1,060,000
- 1,060,000
(2,001,250) (2,704,071)
(702,821)
25%
-2163%
125,000
(2,685,765) (100,765)
Exp.
6,250 4,115 2,135 25% 16% a) 25,000 16,500 8,500
25,000 - 25,000 25% 0% 100,000 - 100,000
31,250 4,115 27,135 25% 3% 125,000 16,500 100,000
(Z_0321500)_ (2,708,186)_ (675,686) b) - 2,702,265 765
a) Interest on September 2012 negative cash balance: $1,350.49.
b) Inception through September 30, 2012
Revenues - Lease Payments
$ 54,918
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
245,192
Total expended
2,763,104
Net $ 2,708 186
BOCC Conference & Travel Jul I Aug I Sep I YTD Total
Tammy Baney
Conf/Sem & Educ/Training 301,
-
Travel Meals 20
Accommodations 127
Airfare
Mileage reimbursement
Ground Transport/Parking
Total Baney
Alan Unger
Con-VS_e_m_& E_d_u_c/Tra_ining_
Travel Meals
Accommodations
Airfare
384
- 35 _
30
566 -
30
20
127
384
Oyo i
- -
65 65
--------1
Mileage reimbursement
112
-
112
Ground Transport/Parking
-
-
-
-
Total Unger
65
112
177
Tony DeBone
Conf/Sem & Educ/Training
30
-
15
45
Travel Meals
Accommodations
-
-
-
-
Airfare
-
-
w
-
Mileage reimbursement
-
-
-
Ground Transport
Total Other
30
-
15
45
Total BOCC Department
Conf/Sem & Educ/Training
125
15
140
Travel Meals _
-
20
-
20
Accommodations
-
-
127
-
127
Airfare
-
Milea a Reimbursement
g
-
496
-
496
Ground Transport - -
-
35
-
35
Total - BOCC Department
125
678
15
818
FY 2013 Budget - -
15,250
Percent of FY 2013 Budget Expended
o
5.4%
BOCC County College
OfficelCo ier Su lies
r-.
86
-
85
Meeting Supplies
-
-
761
761
Total BOCC County College
-
-
$46
846
NOTE: Above amounts include only those expenditures processed for payment.
Additional conference and travel costs may have been incurred, but not
et paid.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2013
10/1/2012
Building Services - 620
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 415,000
$ 455,993
$ 40,993
100%
nla
$ 415,000
$ 455,993
$ 40,993
Revenues
Cleaning/Maintenance
49,393
30,447
(18,946)
25%
15%
197,570
197,570
-
Insurance Reimbursement
-
9,331
9,331
25%
n/a
-
9,331
9,331
Utility Reimbursement
750
858
108
25%
29%
3,000
3,000
-
Facilities Charge to State
47,484
29,584
(17,900)
25%
16%
189,934
189,934
-
Miscellaneous
-
7
7
25%
n/a
-
-
-
Interest on Investments
750
772
22
25%
26%
3,000
3,000
-
Interfund contract
2,500
2,500
-
25%
25%
10,000
10,000
-
Misc Bldg Svcs
-
50
50
25%
n/a
-
50
50
ISF Charges
537,034
537,030
-
25%
25%
2,148,122
2,148,122
-
Total Revenues
637,910
610,579
(27,328
25%
24%
2,551,626
2,561,007
50
TOTAL RESOURCES
1,052,910
1,066,572
13,666
25%
36%
2,966,626
3,017,000
41,043
REQUIREMENTS:
Exp.
Expenditures
Personal Services
457,138
452,696
4,442
25%
25%
1,828,551
1,828,551
-
Materials and Services
192,050
206,117
(14,067)
25%
27%
768,200
768,200
-
Transfer to Veh Reserve
9,900
9,900
-
25%
25%
39,600
39,600
-
Capital Outlay
25
-
25
25%
0%
100
100
-
Contingency
82,544
-
82,544
25%
0%
330,175
-
330,175
TOTAL REQUIREMENTS 741,657 668,713 72,944 25% 23%
NET (Resources - Requirements) 311,253 397,860 86,610
2,966,626 2,636,451 330,175
- 380,549 371,218
Admin Services - 625
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date Year End
Budget Actual Variance FY % Coll. % _Budget Projection Variance
RESOURCES:
Beg. Net Working Capital $ 140,000 $ 207,208 $ 67,208 100% n/a $ 140,000 $ 207,208 $ 67,208
Revenues
Sale of Photo Copies
-
398
398
25%
n/a
Miscellaneous
-
6
6
25%
n/a
Interest on Investments
125
401
276
25%
n/a
ISF Charges
232,471
232,471
-
25%
25%
Total Revenues
232,596
233,275
679
25%
25%
Transfers In-General Fund
10,000
10,000
-
25%
25%
TOTAL RESOURCES
382,596
450,483
67,887
25%
41%
REQUIREMENTS:
EXp.
Expenditures
Personal Services
215,453
172,641
42,812
25%
20%
Materials and Services
27,651
19,594
8,057
25%
18%
Transfer to Veh Reserve
900
900
-
25%
25%
Capital Outlay
25
-
25
25%
0%
Contingency
33,568
-
33,568
25%
0%
TOTAL REQUIREMENTS
277,596
193,135
84,461
25%
17%
NET (Resources - Requirements)
105,000
257,348
152,348
-
398
398
-
6
6
500
1,500
1,000
929,885
929,885
-
930,385
931,788
1,403
40,000
40,000
-
1,110,385
1,178,996
68,611
861,810
861,810 -
110,604
110,604 -
3,600
3,600 -
100
100 -
134,271
- 134,271
1,110,385 976,114 134,271
- 202,882 202,882
BOCC - 628
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital $ 60,000 $ 37,907 $ (22,093) 100% n/a $ 60,000 $ 37,907 $ (22,093)
Revenues
Sale Map Photo or Copies
- 5
5 25%
n/a
Interest on Investments
125 86
(39) 25%
n/a
ISF Charges
107,970 107,970
- 25%
25%
TOTAL RESOURCES
168,095 145,968
(22,127) 25%
30%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp.
5 5
500 350 (150)
431,879 431,879 -
492,379 470,141 (22,238)
86,030
86,055 (25)
25% 25%
344,119 344,119 -
22,317
19,499 2,818
25% 22%
89,268 89,268 -
25
- 25
25% 0%
100 - 100
14,723
- 14,723
25% 0%
58,892 - 58,892
TOTAL REQUIREMENTS 123,095 105,554 17,541 25% 21%
NET (Resources - Requirements) 45,000 40,414 (4,586)
492,379 433,387 58,992
36,754 36,754
Finance - 630
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital $ 540,000 $ 583,527 $ 43,527 100% n/a $ 540,000 $ 583,527 $ 43,527
Revenues
Investment Fee
8,000
8,764
764
25%
27%
IGA Contracts
3,862
5,446
1,585
25%
35%
Interest on Investments
1,000
873
(127)
25%
22%
Interfund Contracts
3,000
3,000
-
25%
25%
ISF Charges
240,608
240,608
-
25%
25%
Total Revenues
256,469
258,691
2,221
25%
25%
32,000
32,000 -
15,446
15,446 -
4,000
4,000 -
12,000
12,000 -
962,431
962,431 -
1,025,877 1,025,877
TOTAL RESOURCES 796,469 842,218 45,748 25% 54% 1,565,877 1,609,404 43,527
REQUIREMENTS: Exp. °i°
Expenditures
Personal Services
263,198 230,437
32,761
25%
22%
1,052,792
1,052,792
-
Materials and Services
64,840 83,823
(18,983)
25%
32% a)
259,358
259,358
-
Capital Outlay
750 -
750
25%
0%
3,000
-
3,000
Contingency
62,682 -
62,682
25%
0%
250,727
-
250,727
TOTAL REQUIREMENTS
391,469 314,260
77,209
25%
20%
1,565,877
1,312,150
253,727
NET (Resources - Requirements)
405,000 527,958
122,958
-
297,254
297,29-
a) Includes payment of annual
contract $52,762
Legal-640
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital $ 150,000 $ 188,093 $ 38,093 100% n/a $ 150,000 $ 188,093 $ 38,093
Revenues
Sale Map Photo or Copies
75
71
(5)
25%
24%
Miscellaneous
250
-
(250)
25%
0%
Interest on Investments
250
328
78
25%
33%
Interfund Contract
1,000
-
(1,000)
25%
0%
ISF Charges
192,260
192,260
-
25%
25%
Total Revenues
193,835
192,658
(1,176)
TOTAL RESOURCES
343,835
380,751
36,917
25%
41%
REQUIREMENTS: Exp.
Expenditures
Personal Services
197,383
190,696
6,686
25%
24%
Materials and Services
9,301
8,207
1,094
25%
22%
Capital Outlay
25
-
25
25%
0%
Contingency
24,626
-
24,626
25%
0%
TOTAL REQUIREMENTS
231,335
198,903
32,431
25%
21%
NET (Resources - Requirements)
112,500
181,848
69,348
300
300 -
1,000
1,000 -
1,000
1,000 -
4,000
4,000 -
769,038
769,038 -
775,338 775,338
925,338 963,431 38,093
-
789,531 789,531
37,203 37,203 -
100 - 100
98,504 - 98,504
925,338 826,734 98,604
136,697 136,697
Personnel - 650
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Pro'ection
Variance
RESOURCES:
Beg. Net Working Capital
$ 290,000
$ 327,178
$ 37,178
100%
nla
$ 290,000
$ 327,178
$ 37,178
Revenues
Miscellaneous
250
35
(215)
25%
4% a)
1,000
35
(965)
Interest on Investments
750
535
(215)
25%
18%
3,000
2,100
(900)
ISF Charges
200,157
200,157
-
25%
25%
800,626
800,626
-
Total Revenues
201,157
200,727
(430)
25%
25%
804,626
802,761
(1,865)
TOTAL RESOURCES
491,157
527,905
36,748
1,094,626
1,129,939
35,313
REQUIREMENTS:
Exp.
Expenditures
Personal Services
170,161
155,618
14,543
25%
23%
680,644
680,644
-
Materials and Services
75,592
59,890
15,702
25%
20%
302,369
302,369
-
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
27,878
-
27,878
25%
0%
111,513
-
111,513
TOTAL REQUIREMENTS
273,657
215,508
58,149
25%
20%
1,094,626
983,013
111,613
NET (Resources - Requirements)
217,500
312,397
94,897
-
146,926
146,926
a) Manley Services Payment
f
Information Tech - 660
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to Date Year End
-Budget Actual Variance FY % Coll. % Budget Projection Variance
Interest on Investments
1,000
1,149
149
25%
29%
Inter/Ether/Date/Phone
6,750
10,106
3,356
25%
37%
ISF Charges
523,211
523,211
-
25%
25%
Total Revenue
530,961
534,466
3,505
25%
25%
Transfers In-General Fund
16,500
16,500
-
25%
25%
TOTAL RESOURCES
1,116,011
1,282,296
166,285
25%
46%
REQUIREMENTS:
Exp. pro
Expenditures
Personal Services
484,210
474,378
9,832
25%
24%
Materials and Services
130,789
138,707
(7,918)
25%
27%
Capital Outlay
25
-
25
25%
0%
Contingency
74,574
-
74,574
25%
0%
TOTAL REQUIREMENTS
689,599
613,086
76,513
25%
22%
RESOURCES:
Beg. Net Working Capital $ 568,550 $ 731,330 $ 162,780 100% n/a $ 568,550 $ 731,330 $ 162,780
Revenues
NET (Resources - Requirements) 426,413 669,210 242,798
4,000
4,000 -
27,000
27,000 -
2,092,844
2,092,844 -
2,123,844
2,123,844 -
66,000
66,000 -
2,758,394 2,921,174 162,780
1,936,841
1,936,841
-
523,156
523,156
-
100
-
100
298,297
-
298,297
2,758,394
2,459,997
298,397
-
461,177
461,177
IT Reserve - 661
Statement of Financial Operating Data
Three Months Ended September 30, 2012
Year to. Date
FY 2013
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 365,593 $
480,196
$ 114,603
100%
nla
$ 365,593
$ 480,196
$ 114,603
Revenues
Interest
375
723
348
25%
48%
1,500
2,800
1,300
ISF Charges
58,500
58,500
-
25%
25%
234,000
234,000
-
Total Revenue
58,875
59,223
348
25%
25%
235,500
236,800
1,300
TOTAL RESOURCES
424,468
539,419
114,951
25%
90%
601,093
716,996
115,903
REQUIREMENTS:
Exp.
Expenditures
Materials and Services
19,150
8,597
10,553
25%
11% b)
76,600
76,600
-
Capital Outlay
36,250
93,276
(57,026)
25%
64% b)
145,000
145,000
-
Res for Future Expenditure
94,873
-
94,873
25%
0%
379,493
-
379,493
TOTAL REQUIREMENTS
150,273
101,873
48,400
25%
17%
601,093
221,600
379,493
NET (Resources - Requirements)
274,195
437,546
163,351
-
495,396
495,396
a) From Solid Waste