2011-3083-Minutes for Meeting October 26,2011 Recorded 11/15/2011COUNTY OFFICIAL
NANCYUBLANKENSHIP, COUNTY CLERKDS CJ 7011'3083
COMMISSIONERS' JOURNAL 11/15/201108:09:27 AM
IIIIIII IIIIIIIIII~III VIII II III
2011-3083
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 SESION
DESCHUTES COUNTY BOARD OF COMMISSIONERS
WEDNESDAY, OCTOBER 26, 2011
Present were Commissioners Tammy Baney, Alan Unger and Anthony DeBone.
Also present were Erik Kropp, Interim County Administrator; Marty Wynne,
Finance; Tom Anderson, Nick Lelack and Peter Gutowsky, Community
Development; Laurie Craghead, County Counsel; Hillary Borrud of The Bulletin
and three other citizens.
Chair Baney opened the meeting at 1: 50 p. m.
1. Tax/Finance Update.
Marty Wynne said there is now an average ;yield of 0.66, which is about where
it has been for a while. Rates are low and continue to drop. He was offered a
two-year CD at just 0.20.
It is too early to project for the fiscal year. The general fund forecast for
property values will probably be adjusted somewhat. The Clerk's revenue will
be adjusted as well, due to new programs for refinancing properties whose
owners may not otherwise qualify for a loan, as this may generate additional
recording revenue.
He is not optimistic about increases in revenue. Some entities are making
investments in ways to keep from losing revenue even if they generate nothing.
Commissioner Unger noted that the saying now is, "the new normal is flat".
Year-end working capital for all groups is going down this year, but this was
anticipated and planned.
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 1 of 6 Pages
2. Discussion of Regional Economic Opportunity Analysis - Preparation for
October 31 Hearing.
Peter Gutowsky gave an overview of the ongoing work on the analysis. All of
the potential partners and collaborators have been contacted and are providing
input.
Mr. Gutowsky reviewed an updated analysis document and went over the new
findings. There are three fundamental questions, which are interrelated.
Is a regional report to address an unmet need for industrial sites necessary and
worth pursuing? If so, the Board can exercise its statutory authority, which can
allow this regional, unmet need, and compel other entities to focus on
specialized, unmet needs for large site industrial sites. There are potentially six
sites in the Central Oregon region. This establishes a framework through
policies for a regional coordination authority. This would involve Jefferson and
Crook County, who would have to adopt identical policies and findings.
Is there an adequate factual basis to pursue this? The document is 60 pages
with 83 footnotes, to provide the evidence supporting this approach. It sites
written testimony from experts in the region and state. All of 1,000 Friends of
Oregon's concerns and questions are answered at the beginning.
Is this regional approach consistent with the Oregon land use planning system?
They do not require perfect information; however, they need to provide the best
available evidence. The Board would be weighing all the evidence in the
record to determine whether it supports this idea. The findings have to be there
and must meld with the requirements of the state.
This program is structured to be an economic development program that
supports the need? Oregon land use is somewhat prescriptive and has trouble
adapting as needed. What the County has to do is demonstrate that this
approach complies with Oregon land use. An economic development
opportunity analysis must identify short-term need; also long-term needs over
20 or more years. Short-term needs are six sites in three jurisdictions. Some
are fifty acres, some are 100 acres and one would be 200 acres.
The focus in on the short-term vision and this program is meant to do so. If
replenishment can be used effectively, they will have six appropriate sites
available.
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 2 of 6 Pages
Business Oregon will be here to testify on Monday. Representatives of DLCD
will also attend, and EDCO will also provide input.
The seventeen sites do not really mean a lot unless the six sites are successful.
Only a total of six sites would be available at the beginning.
The responses should be very thorough. He feels this report does it in a much
better way. It may seem simplistic but it was meant to be a beginning.
Commissioner Unger asked about the Deschutes Junction area.
Commissioner Unger said that cities have not always wanted to cooperate.
Nick Lelack said there should be some cooperation in the Deschutes Junction
area anyway, since it is of concern to a variety of entities.
Chair Baney asked if there is an explanation why the region should do this, and
whether large employers can be better than small. Mr. Gutowsky said that the
concerns have helped to develop a good analysis.
Laurie Craghead stated that the program is not designed to force cities to take
on industrial, but that would be a good starting point since they have the
infrastructure. There are provisions in the new Code addressing this concern.
These are urban type uses.
Mr. Gutowsky said this would help cities that are willing and interested in
doing this. Commissioner Unger stated the County is trying to clear the way for
them to do this.
Commissioner DeBone asked if the Board would be able to take action on this
anytime soon. Mr. Gutowsky stated the regional advisory committee and the
media will receive the packet for the hearing. This provides five days for them
to review the information prior to the hearing on Monday.
He is hopeful that perhaps just the written record could be left open after the
hearing. Then the Board could consider the first reading in early November and
adoption by the end of November.
Commissioner Unger asked what happens after this is done. Mr. Gutowsky
said that it a local policy decision. If challenged, it would go to LUBA. There
would be 21 days for this to happen. The record needs to be as complete as
possible. The statutory coordination authority could be like what happened
with Metro, when the cities relinquished their authority. The County could
become the authority if the cities prefer.
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 3 of 6 Pages
Mr. Lelack said the coordination piece has been in the findings, and is meant to
coordinate local cooperation. This is a model approach that other regions in the
state might find beneficial. Most counties do not exercise this authority even if
they could.
Commissioner Unger asked if there is further information needed. Mr.
Gutowsky replied all information is before the Board now but there are past
discussions in the Planning Commission meetings that reference this work. The
analysis includes the appendices and they refer to most of this information.
3. Other Items.
Erik Kropp said that they are trying to schedule budget discussions in May
2012. At this point, it could be the week of May 7 or towards the end of the
month. The Board indicated the week of May 21 is preferred. Chair Baney
would like to schedule a half-day on that Friday also, in case it is needed.
Juvenile Detention Center must be toured by a Commissioner as a State
requirement. The Commissioners indicated they would all like to do this, so it
could be in lieu of a work session.
The Board received a letter regarding the Harper Bridge Boat Facility Study.
When talking to CDD and Legal, some items can be addressed but others
require legal analysis that the County cannot or should not provide.
Chair Baney stated that she thought they were going to talk to the community
and come up with recommendations. They were not asked to come forward
with a property and involving attorneys and property owners. She is grateful
for their work. Commissioner DeBone asked what the goal is since Sunriver
can do whatever they want. Chair Baney said they are siting safety issues along
the road. Crosswater was to provide public access but what they did is felt to be
inadequate at this time, even though it met requirements at the time. The
charge was to come up with recommendations on how to enhance that access,
but it has gone far beyond access and parking.
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 4 of 6 Pages
Mid-Oregon Federal Credit Union asked if the County would support the idea
of legislation meant to help credit unions be allowed to loan billions of dollars
to businesses. Other financial institutions that are larger do not necessarily
want this. Chair Baney wants to free up money for small businesses, but it is
unclear how this relates to the legislation.
Commissioner Unger would like the whole picture of the bill and its potential
impacts. Mr. Kropp will try to find out more.
The Heart of Oregon Corps has asked for a letter of support to be the recipient
of funding from the Gala at the Riverhouse for 2012. Commissioner DeBone
gave an overview of their activities and hopes for the future. Chair Baney is
concerned because they have already received funds in a previous year and
there are a lot of worthy nonprofits. The Board, can, however, support more
than one if requested.
DEBONE: Move signature of a letter of support.
UNGER: Second.
VOTE: DEBONE: Yes.
UNGER: Yes.
BANEY: Chair votes yes.
Discussion occurred regarding changes to the north Highway 97 project and the
Parkway. Current proposed ODOT plans are not being wholeheartedly
endorsed, and they may have to start out with something different to come to
any kind of long-term resolution to the problems presented by the current
configuration and uses.
Being no further discussion, the meeting adjourned, and the Board went
into executive session at 3: 40 p. m.
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 5 of 6 Pages
DATED this Day of &vxh&~ 2011 for the
Deschutes County Board of Commissioners.
ATTEST:
Recording Secretary
(izl--
Tammy B ey, Chair
Anthony DeBone, Vice Chair
a&,.- U,-t~
Alan Unger, Commissioner
Minutes of Board of Commissioners' Work Session Wednesday, October 26, 2011
Page 6 of 6 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, OCTOBER 26, 2011
Tax/Finance Update - Marty Wynne
2. Discussion of Regional Economic Opportunity Analysis - Preparation for
October 31 Hearing - Peter Gutowsky, Community Development
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., Bench unless otherwise indicated. If you 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 deal; 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.
rr-
N
H
p
E
°
U
L
~
s
C9
cr
CDr
V~
U
L
c~~
N
s
t
V
C
~
S
CO
c
a
N
91
S
U
j to
z
~
o
O
~I i
r
~
CL
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
October 26, 2011
(1) Monthly Investment Report
(2) September 2011 Financials
r-
ti 3
24
O '
coo
N
C
N
o
~
Ifs
e
G
P
P
P
!
r
}
C
o
N
40
C
1.
Ca
ff!
N
m
}
C
G
CO
N
m
00
CO v
M
LL
O '
at vi
CO
C
T7
V
I* 40 N
v
a
m
EA
1
4
((00 COO
V
C
o
Ln M)
m
E
0 o
O
° V-
EA N
E
z
t
O ,
C
C c E
7
O
C - O
Ott
m
r
m
~
L
m ~ m
C
m
c m
LL
C
m
CA (
5
1
0 J C
>
O
C
m e~
~
a
C)
0 o e~ oC ° o~° ° O
0CCOONO~00
6 6 6 dC14 0c0i O
r
0, L"
LO
O
(0 (O
N
(
O
O
r
N U')
CO
U')
Ot
(0 O
-
h
to
CO M
C1
It
Go O
O
CO)
O
N tOl O
P
619, 140
rn
L=
CA Ca
CL C
mmmu,ata m
a o c S
'a z 00 0
U m ~Q H m
m m¢ oo
E oUF- -m
E0& E uj o ,g 3
o0E
0 0 ~m mI (aU 10
F- ~ -
O w
C
m
m
c
m
C7
Document Reproduces Poorly
(Archived)
UP v r r n n
y
E N
m n CL 10
x m
N m
a «
co
y
w m z
Z' CO
Q N 2 4:
) m to
O
M
L
E0
~a
~ c 4)
O Z5
V j-1
U- M F- U U
m ~
N
C
C
CL
LL 0) N
Q
H
a+
C
N
G
N
fW
d m
E ~ o
C
Q)
U
m
~
Q
N N
`O e
O
O
aorn
U Z
IL
O
O
m
H
d~
J
I
~
I I
U
U
U
U
U
U
U
U
U
U
U
U
U
U
U
U U
U
O
U
o
U U
U
O
O U
N
N
U N
O
N
t
O
O
O
M
O
0
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z
_
Z Z
_
Z
7
_
Z
_
_
Z Z
_
Z
j
_
Z
_
(0'I
O
t0
o
N
O
O
N
O
2
N
V
7
7
t7'
i
7
Q
7I
tSl
II
C
t1D
01
O
N
O
O
O
I
Q
O
O
m
N
N
N
V
O
O
c0
V
O
O
V
O
r
cD
r
o
V
V
m
D)
W
O
O
n
W
'I r
(D
M
M
0
O
0
o
0
0
Q)
o
M
u.)
O
N
n
(D
0
O
(o
O
c> V
O R
O
O
N, o1
NI O,
u)
t°
V
m
o
co
rn
O
t°
V
n
N
M
o
V'
O
m
O
O
C
d
O
O
O
N
O
O
W
W
N
N
r
Q)
n
a)
G
O
0
O
O
O
CD
O
O
O
V
r
N
M
(O
W
co
N
V
o
r
N
"T
d'
V
0
o
V
O
n
ro
CO
M
O
O
N
N
LO
N
r
W
N
(M
03
0
n
O
O
0
N
o
O
0
to
0
O
O
V
o
tX)
W
7
M
co
O
(D
W
r
co
N
O
N
m
qi
(f)
O
--I
O p
Olr
O N
O
0
-o j
WI OI
MI (D'~
of
v
a
0)
'r
lop
i
d'
co
O
Di
O
O
of
o
r
O
CD
v
N
O
R
7
!0
>
y 0
N
C
n
1
M
O
V
M
O
M
V
N
a
O
V N
N O
N O
O
M
O
O
O
W
O
N
N
O
N
O
N
o
W
o
V
O
M
O
O
N
m
Co
N
O
N I O
MO
C N
V
N
C
o O
N N
OI OI
V
Oo
N
M
N
'O
O
c
OI
to
V
'
N
p
p
o
O
M
m
M
U)
n
m
N
It
C
N
C
4
01
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N N
-
Ip
-
0
O
N
)
m
O
~
-
0
wl
'o
4)
O
0
O
0
O
0
n
M
(D
O
M
w
O
q
O
O
r
p
0
q
0
O
0
O
0
O
0
O
M
O
o
O
0
O
0
O
0
o
o
0
O
u)
n
N
N
O
O
o
o
0
0
o
0
o
n
O
0
V O.
O'
M V
o1'D>
O
(D
r
i
O
O
O
o
0
to
M
o
ca
N
O
o
0
0
o
V'
0
0
0
0
0
o
rn
N
O
O
O
O
r
0
R I o
C) Io)
V
N
jp
co
O
O
O
N
O
W
(O
O
M
V
W
V
N
o
m
0
O
0
V
o
W
co
D)
o
C
I o
o1
o
W
o
O
V
a
O
(q
o
N
I
N
V
O
W)
V
O
O
V
O
co
V
(b
p
D)
O
cM
Q1I
n n.
O r
V C
V
N
d
O
V
N
o
t°
t°
ul
N
M
w)
N
O
,
O
O
O
-
V
O
o
V
Lo
o
O
o
0
m o
ro M
o
O
O
V
N
Co
7
0
0
8
o
S,
o
0
0
M
V
0
0
O
0
0
0
O
O O!
r N
N
t
u)
tit
'
Y
0
0
0
O
N
O
N
O
O
O
O
O
O
O
O
q
I O
O
O
O
O
O
N
o
0 0I
M q)
N
O
(p
N
N
N
N
N
N
N
N
N
N
N
N
(V
N
N
N
-
N
N
N
N N
ID O
1
N
M
V
7
r
OI
N
o
O
M
N
O
0
o
0
0
0
o
0
la
0
0
0
0
0
0 co
0 0 0
~
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0 0
0
0
f
0
0
0 0 l
0 0
V O
co
o
O)
O
O
m
a
O
O
O
O
I0
I
0
0 o
O
O
O
O
O
O
O
O
O
V
O
O
O
v
o o
o
I
O
of of
n,o)
e}'
a
U
O
O
m
w
N
n
O
0
O
0
o
0
o
O
0
V
N
O
O
O OI O
O V W
p
O
O
O
O
I C)
O
t7
m
LO
o
O
O
O
O
O
LO
O
O
O
O
f
0
N
O
r
o 0
o 0
0
0
O
0
O' of
O ' o
o r
c Flo
v
r
1
(D
o
O
V
v
O
o
7
o
0
M
-6
N
o
V
0
O O
v
o
O
o
O
V
ri
(D
o
o
o
0
f o
0
r)
O
V o
o O
O v
nW
n W o 0
0 0
00
of
0 0'
0 1
co ce)
c
O
O
of
M
O
O
O
4
O
N
O' 0 0
0
0
0
0
0
0
O
W
11 C
N
O
O! O
CD 10
N
cc
•
N
N
N
I
N
N
NIA N
N
N
N
N
N
N
N
N
N
~I N
'
N
N N.
co a
N
T
Q
V V
w
O
-
n
f0
y
N
y
«
y
t6
d
C
d
IL
o
y
V
E
0
0
0
0
0
0
0
o
1
0
0 o o
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
0
0
0 0 o 'o
0
fa
Z
o
o
v
I--
•O
0
t°
0
o
0
n
0
W
0
o
0
t°
0
o
0
n
O
0
O aD' M
O N Lo
a)
V'
0
O
0
O
0
C,
0
O
0
LO
O
N
o
N
0
0
O
0
I co
(D
N
o
' O
0
0
0
0
0
0
0 0 O'O
0 V' t0 O
10
tn
e►
(D
`
u,)
7
Ol
Q
a
O
O
N
«
r
O
0
co
O
0
O
o
o
n
O
u)
o
r I O' 0
ci O O
0
o
o
t%1
o
0
0
0
O
0
O
(D
O
N
O
O
W
. O
r
o
r
0
O tp
0 0
M
CD
O
CD (D r to
O O O O
s
O
O
(D
O
N
E
(0
o
0
U
c6,
`1
N
y
N
m
C
C
a
«
•
O
U
O
U
E
F-
U
7
°
ti
m
~
F°-
j
C
0
O
0
to
0
o
0
t°
0 0
otn
0
o
0
o
0
0
0
o
0
0
0
0
o
o
0
o
0 0
oo
0
o
o
'o
O «
O.
t°
r
N
o
0
n
M
O N
o to
o
O
O
r
O
N
O
to
N
N
O
7
to
O O
o
It I
!
p
0
o
co
op
~cq
O
r O
O
CD
I
U
0
N o
v
t°
O
C)
O
N
I
O
M
O O
O
O
L
'
a+
d
I
I
I
~
'
j
I
o
£
m
N
to
I
t
al
c
c
rn
I y
E
d
O
l
~i
~
F
°
o
y
co
cD
O
to
a)
rn
eo
M
ao
r
oo
o
(p
`7
M
r
p
V
V
'V'
O
r
V
O
N
n
D
p
M
r
O
N
(h
M
M
N
M
c+1
M
m
ao
Mo~
M
M I
('7
M
M
M
d
Q
G
O
O
O
M
O
O
O
O
O
O
O
O
O
M
r
O
r
n
n
n
O
r
n
O
r
r n
r
n
n n
t0
C
E
Z
~r
C
-1
-
-
N
N
N
N
N
N
N
^
N
N_
N_
N
N_
N
N
M
_M
M
M
M
M
M
M
M
M
M
l y
I
W
j 0
o
O
to
to I
(h
n
W
(O
O
o
M
O
ch
M
W
O'
V
tl)
m
O)
O
W
N
S
l
❑
O
N
N
O
O
N
O
O
o
N
O
O
O
o
O
I
M
O
N
O
N
N
N
U
4
l0
O
O I
L
N
o
o
n
n
r
Co
cO
Q1
O
O
-
-
N
o
o
M
c,
Z
oI
o
O
p
I
o
>
«
1
51
0
~
o
8
o
0
0
0
0
0
c
0
-
o
o
o
o
o
o
o
o;
l
Q
l
o
ll
o
m
I
~
H
1
F J
O
O_
_O
O_
0
0
0
0
0
_O
_O
0
0
O_
O
_O
L «
` 0
I!)
o
I~
N
N
N
O
O
~
N
n
O
M
0
t0
O
O
`
N
M
O
O
M
V
O
N
O
O
M
o0
N
O
M
N
oD
N
to
N
a)
O
O N
W
N
m
N
N
O
N
f~
r
N
N
N
M
N
O1
O
ems'-
N
V
l
M
to
V
V
)
O
(O
(D
f~
IL
o
0
c)
~
O I
o
0
0
0
0
o
O
i
0
0
o
0
o
0
0
0
0
Q
U
Q I
K
LL.
CO
IM
Z
>
F
d
LL
Q
CL
Z
Q
p
IM
m
U
U
m
x
m
m
w
w
w
w
5
3
m
u
U
LL
I.-
H
adRL
ILL
(Zj
LL
F
F-
F-
O
LL
F-
F-
LL
lai
<
LL
C
~
c
U
U
LL
UQ
1¢i
U
OF
U-
LL
U-
CI
O
F
Q
LL
❑
a
Q
LL
HUeB
1 LL
m
m
CL
L)
co
IL
Z
fn
CL
a
CL
7
Z
(n
(4
ZI
(n
CL
m
m
2
~
3
N
m
U
U
=
U
U
Z
U!n
a
a
E
L
n
0
W
d
co
-IT
o
p
=
LL
o
J Y
D
LL
'
7
H
~
~
I
r
C7
Q
Q
~
~
Y
O
X~
N
Z
M
co
co
X
X
U
N
co
co
N
O
C71r
r
I
.y
co
M
M
M
M
M
W
M
M
M
Oo
M
N
M
M
U
M
❑
co
M
co
co
M
co
M
M
M
('7
con
I
M
r
m co
M
(+1
'y l
C
Z
❑
❑
(
)
I
❑
Z
U
U
U
❑
❑
❑
U
d
y
C
Y
C
Y
L
U)
N
C
m
u)
(D
C
a)
❑
O
~
a
U
U
„
❑
U
1
N
N
U
V
❑
(p
N
-
f0
m
N
U
7
Y
C
O
y
y
•L
C1
Y
C
❑
O
❑
V
❑
❑
~c
0
-
c,
cc
'n
(6
Y
~
y
C
C
U
Y
(6
U
°
(0
U
7
U
N
(n
«
Y
m
m
T
m
7
N
N
(n
0
m
y
C
C
d
f6
a
-
d
o
r-
N
U
pyj
d
m
U
U
C
U
U
(6I
C
U
1
U
l0.
ca
m
c
7
C
m
E
Y
Y
O
U
N
tU
2
3
N
CO
o
Q
(0
Z
O
7
i
D
U
«
Y
y
O
Y
cc
co
Y
Y
m
LL
`
`
m
«
u-
co
co
y
Q
O
O
N
U
ca
N
LL
~c
r
C
0
Z
N
>
U
7
i
`
a/
d
Q
t
y
N
C
C
GI
O
«
C
(6
U
C
(0
y
C
(6
C
co
lU
y
N
U N
-
U
N
N
«
U
°
N
>
I
Y
C
Y
C
-
N
E
7
N
E
m
a
E
N
U
N
L~
/0
«
7
C
-
O'
Q
y
a1
Y
C
E
E
0
N
N
V
U
lU
H
E
m
CO
m
Y
Z
m
m
3
CO
co
Co
co
U l
~
?i
W
W
0
x
w
m
m
❑
m
m
m
m
m
U
o
U
o
x
r
Y
a
s
co
m
d
(n
o
(n
E
5
~
m
m
o
U
o
U
o
LL
. E _
H
m
❑
u) U
m
o
Q
7
p
7
m
N
'
7
m
m
U
7
LL
ro
I
C
@
N
LL
:
E
co
m
C)
w
y
Y
C
J
E
J
U
J
E
~
C
i
ffi
C
E
U
J
m
J
L
m
J
J
I
,
e
'
C
LL
LL
O
A
Z
u
O
U
E
❑
m
E
❑ I
=
LL
O
E
7
u
LL
LL
LL
=
tL
E
O
m
-
O
0
N
C7
z
N
0
O
2
o
U
LL
>
LL
2
2
7
O
2
«
2
W
(p
H
-
I
LL
LL
LL
U)
LL
U)
LL
J
m
I
Memorandum
Date: October 13, 2011
To: Board of County Commissioners
Erik Kropp, Interim County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find September 2011 financial reports for the following funds: General
(001), Community Justice - Juvenile (230), Sheriffs (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
GENERAL FUND
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
$
Budget
Actual
Variance
FY %
Co1I %
Budget
Projection
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
5,025,242
389,590
(4,635,652)
25%
2%
a)
20,100,967
20,550,967
450,000
Gen. Rev. - excl. Taxes
595,580
1,200,165
604,585
25%
50%
b)
2,382,321
2,382,321
-
Assessor
197,749
212,455
14,706
25%
27%
c)
790,996
790,996
-
County Clerk
367,177
343,754
(23,423)
25%
23%
1,468,707
1,468,707
-
BOPTA
3,100
4,081
981
25%
33%
c)
12,398
12,398
-
District Attorney
74,667
23,039
(51,628)
25%
8%
d)
298,669
298,669
-
Finance/Tax
48,475
68,824
20,349
25%
35%
c)
193,900
193,900
-
Veterans
15,335
225
(15,110)
25%
0%
61,341
61,341
-
Property Management
24,050
27,550
3,500
25%
29%
96,200
96,200
-
Grant Projects
500
500
0
25%
25%
2,000
2,000
-
Total Revenues
6,351,875
2,270,183
(4,081,692)
25%
9%
25,407,499
25,857,499
450,000
TOTAL RESOURCES
8,176,876
10,515,908
2,339,032
25%
32%
32,707,499
34,103,224
1,395,725
REQUIREMENTS:
-
Exp.
Expenditures
Assessor
851,325
821,754
29,571
25%
24%
3,405,300
3,405,300
-
County Clerk
355,991
268,561
87,430
25%
19%
1,423,965
1,423,965
-
BOPTA
18,101
14,937
3,164
25%
21%
72,402
72,402
-
District Attorney
1,219,824
1,067,302
152,522
25%
22%
4,879,296
4,879,296
-
Finance/Tax
203,412
188,557
14,855
25%
23%
813,648
813,648
-
Veterans
65,529
61,244
4,285
25%
23%
262,115
262,115
-
Property Management
64,416
62,460
1,956
25%
24%
257,664
257,664
-
Grant Projects
29,679
28,988
692
25%
24%
118,715
118,715
-
Non-Departmental
454,241
221,112
233,129
25%
12%
1,816,962
1,816,962
-
Contingency
1,681,681
1,681,681
25%
n/a
6,726,722
-
6,726,722
4,944,199
2,734,914
2,209,285
25%
14%
19,776,789
13,050,067
6,726,722
Transfers Out
3,232,678
3,303,444
(70,766)
25%
26%
12,930,710
12,930,710
-
TOTAL REQUIREMENTS
8,176,877
6,038,358
2,138,519
25%
18%
32,707,499
25,980,777
6,726,722
NET (Resources - Requirements)
-
4,477,550
4,477,551
_
8,122,447
8,122,447
a) Current year property taxes will be collected beginning in October
b) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823
c) A & T Grant received quarterly
d) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD
actual includes two months of receipts)
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,101,374
$1,099,010
$ (2,364)
100%
100%
$1,101,374
$1,099,010
$ (2,364)
Revenues
Federal Grants
2,500
-
(2,500)
25%
0%
10,000
10,000
-
SB #1065-Court Assess.
12,500
11,194
(1,306)
25%
22%
50,000
50,000
-
Discovery Fee
3,750
2,101
(1,649)
25%
14%
15,000
15,000
-
Food Subsidy
6,250
4,284
(1,966)
25%
17%
25,000
25,000
-
OYA Basic & Diversion
54,375
-
(54,375)
25%
0%
a)
217,498
355,730
138,232
Inmate/Prisoner Housing
22,123
9,000
(13,123)
25%
10%
b)
88,490
88,490
-
Inmate Commissary Fees
25
-
(25)
25%
0%
100
100
-
Contract Payments
17,500
8,931
(8,569)
25%
13%
c)
70,000
70,000
-
Miscellaneous
15
103
88
25%
172%
d)
60
200
140
Program Fees
10
-
(10)
25%
n/a
40
40
-
MIP Diversion Fees
75
420
345
25%
140%
d)
300
825
525
Interest on Investments
1,875
1,648
(227)
25%
22%
7,500
7,500
-
Leases
600
300
(300)
25%
13%
e)
2,400
1,200
(1,200)
Grants - Private
125
300
175
25%
60%
500
500
-
Behavioral Health
1,500
138
(1,362)
25%
2%
6,000
6,000
-
CFC Interfund Grant
38,532
-
(38,532)
25%
0%
f)g)
154,128
134,620
(19,508)
Gen Fund Grant-Crime Prev
5,000
-
(5,000)
25%
0%
g)
20,000
20,000
-
Total Revenues
166,755
38,419
(128,336)
25%
6%
667,016
785,205
118,189
Transfers In-General Fund 1,330,365 1,330,365 - 25%
TOTAL RESOURCES 2,598,494 2,467,794 (130,700) 25%
REQUIREMENTS:
Expenditures
Community Justice-Juvenile
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
25% 5,321,459 5,321,459 -
35% 7,089,849 7,205,674 115,825
Exp.
1,277,267
1,221,792
55,475
25%
24% h)
5,109,069
5,054,069
55,000
298,933
250,419
48,514
25%
21% a)f)
1,195,733
1,182,725
13,008
25
-
25
25%
0%
100
-
100
12,600
12,600
-
25%
25%
50,400
50,400
-
183,637
-
183,637
25%
n/a
734,547
-
734,547
1,772,462
1,484,811
287,651
25%
21%
7,089,849
6,287,194
802,655
826,032
982,983
156,951
-
918,480
918,480
a) OYA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted
accordingly. Payments received quarterly
b) Billings outstanding - $10,800
c) Contract payments reimbursement requests submitted monthly . Received 1-2 months in arrears
d) Revenues trending greater than anticipated - dependent on use of programs or services (MIP Diversion Fees, photocopies, etc)
e) Citizen Review Board vacated. Revenue projected adjusted accordingly
f) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly
g) Grants paid quarterly
h) Actual for the year projected to be less than budgeted due to vacant positions
SHERIFF - Fund 255
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
C011. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$
$ -
$ -
100%
n/a
$ -
$ -
$ -
Revenues
Law Enf Dist Countywide
5,521,205
4,288,823
(1,232,382)
25%
19% *
22,084,821
19,603,961
(2,480,860)
25%
19%
Total Revenues
9,133,379
7,055,796
(2,077,583)
25%
19%
36,533,516
31,587,765
(4,945,751)
TOTAL RESOURCES
9,133,379
7,055,796
(2,077,583)
25%
19%
36,533,516
31,587,765
(4,945,751)
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFERS
Sheriff's Division
624,125
617,381
6,744
25%
25% a)
2,496,498
2,583,942
(87,444)
Civil
206,024
178,530
27,494
25%
22%
824,095
824,095
-
Automotive/Communications
405,552
223,503
182,049
25%
14% b)
1,622,207
1,622,207
-
Investigations/Evidence
433,555
393,494
40,061
25%
23% c)
1,734,218
1,685,549
48,669
Patrol/Civil/Comm Supp
1,977,926
1,915,888
62,038
25%
24% c)
7,911,704
7,841,716
69,988
Records
180,178
149,559
30,619
25%
21%
720,710
720,710
-
Adult Jail
2,610,948
2,217,808
393,140
25%
21% c)
10,443,790
10,333,479
110,311
Court Security
71,651
69,664
1,987
25%
24%
286,602
286,602
-
Emergency Services
46,406
43,835
2,571
25%
24%
185,625
185,625
-
Special Services Division
326,093
300,924
25,169
25%
23%
1,304,370
1,304,370
-
Regional Work Center
754,617
694,068
60,549
25%
23% c)
3,018,466
2,969,718
48,748
Training Division
81,066
74,516
6,550
25%
23%
324,265
324,265
-
Other Law Enforcement Svcs
158,064
158,320
(256)
25%
25%
632,256
632,256
-
Non-Departmental
18,308
18,308
-
25%
25%
73,231
73,231
-
Contingency
1,188,870
-
1,188,870
25%
n/a
4,755,479
-
4,755,479
Transfers Out - D/S Fund
50,000
-
50,000
25%
0%
200,000
200,000
-
TOTAL REQUIREMENTS
9,133,383
7,055,798
2,077,585
25%
19%
36,533,516
31,587,765
4,945,751
NET (Resources - Requirements)
-
-
-
-
* Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures
a) Reclassification of open Personnel Assistant position to Operations Capta
in positi
on at a higher salary
b) Year to date variance due to timing of transfer payment to Fund 245 for Communi
cations System user fee
c) Year to date variance due to open positions which will be fi
lled based on funding and operational needs
Fund 701 LED-Countywide
Statement of Financial Operating Data
Three Months Ended September 30, 2011
RESOURCES:
Beg. Net Working Capital
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants
State Grant
Transp. of State Wards
SB 1145
Des. Cty Video Lottery Grant
Des Cty Court Security
Des Cty Juvenile Contract
Title III Reimbursement
Transport
DC Fair & Expo Center
Inmate Commissary Fees
Work Center Work Crews
Concealed Handgun Classes
Soc Sec Incentive-Fed
Miscellaneous
Oregon Mentors
Medical Services Reimb
Restitution
Sheriff Fees
Interest
Interest on Unsegregated
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
To: Fund 255 Departments
Sheriffs Services
Civil
Auto/Comm
Adult Jail
Court Security
Emergency Services
Special Services
Work Center
Training
Other (CODE, Forensic)
Internal Services
Transfer to Debt Service
Contingency
Total to Fund 255
Transfer to Reserve Fund (703)
Total Requirements
I Year to Date Year End
Budget Actual Variance FY % Coll. % [:Bud et Projection Variance
$ 5,108,671 $ 6,090,734 $ 982,063
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%
119%
0% a)
57%
0%
0%
0%
14% b)
0%
25%
0%
0%
0%
0%
35%
13%
30%
40%
28%
15%
20%
33%
25%
24%
2%
n/a
4%
$ 5,108,671
$ 6,090,734
$ 982,063
14,306,841
14,627,128
320,287
501,000
501,000
-
35,200
35,200
-
48,475
48,475
-
5,000
5,000
-
1,537,663
1,479,991
(57,672)
5,000
5,000
-
91,000
91,000
-
4,180
4,180
-
150,000
150,000
-
1,000
1,000
-
3,825
3,825
-
6,600
6,600
-
50,000
50,000
-
3,500
3,500
-
5,000
5,000
-
5,000
5,000
-
15,000
15,000
-
16,000
16,000
-
5,000
5,000
-
200,000
200,000
-
28,333
28,333
-
3,533
3,533
-
1,000
2,000
1,000
17,076,150
17,339,765
263,615
3,576,710
-
(3,576,710)
125,250
286,159
160,909
8,800
-
(8,800)
12,119
-
(12,119)
1,250
-
(1,250)
384,416
215,978
(168,438)
1,250
-
(1,250)
22,750
22,435
(315)
1,045
-
(1,045)
37,500
-
(37,500)
250
-
(250)
956
-
(956)
1,650
2,319
669
12,500
6,675
(5,825)
875
1,050
175
1,250
2,000
750
1,250
1,399
149
3,750
2,300
(1,450)
4,000
3,187
(813)
1,250
1,639
389
50,000
50,124
124
7,083
6,851
(232)
883
56
(827)
250
1,553
1,303
4,269,037
620,013
(3,649,024)
9,377,708 6,710,747 (2,666,961)
25% 30%
Exp.
22,184,821 23,430,499 1,245,678
585,423
579,097
6,325
25%
25%
2,341,690
2,423,712
(82,022)
206,024
178,530
27,494
25%
22%
824,095
824,095
-
151,753
83,633
68,121
25%
14%
607,014
607,014
-
2,610,948
2,217,808
393,140
25%
21%
10,443,790
10,333,479
110,311
71,651
69,664
1,987
25%
24%
286,602
286,602
-
46,406
43,835
2,571
25%
24%
185,625
185,625
-
226,703
209,205
17,497
25%
23%
906,811
906,811
-
754,617
694,068
60,549
25%
23%
3,018,466
2,969,718
48,748
49,490
45,491
3,999
25%
23%
197,961
197,961
-
158,064
158,320
(256)
25%
25%
632,256
632,256
-
9,172
9,172
(0)
25%
25%
36,689
36,689
-
50,000
-
50,000
25%
0%
200,000
200,000
-
600,956
-
600,956
25%
0%
2,403,823
-
2,403,823
5,521,205
4,288,824
1,232,382
*
22,084,821
19,603,961
2,480,860
25,000
100,000
(75,000)
25%
100%
100,000
100,000
-
11,067,411
4,388,824
6,678,586
20%
22,184,821
19,703,961
2,480,860
Net (1,689,703) 2,321,923 4,011,626 - 3,726,538 3,726,538
* Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #1
a) Current year property taxes will be collected beginning in October
b) Reduction in State Community Corrections funding for custody of SB 1145 inmates
Fund 702 LED Rural
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
I
I
Budget
Projection
I
I Variance
RESOURCES:
Beg. Net Working Capital
$ 2,936,523
$ 3,004,533
$ 68,010
100%
102%
$ 2,936,523
$ 3,004,533
$ 68,010
Revenues
Tax Revenues - Current
1,837,030
-
(1,837,030)
25%
0%a)
7,348,125
7,512,627
164,502
Tax Revenues - Prior
64,250
142,740
78,490
25%
56%
257,000
257,000
-
Federal Grants
3,000
2,319
(681)
25%
19%
12,000
12,000
-
Federal Grants-BLM
6,250
3,377
(2,873)
25%
n/a
25,000
25,000
-
US Forest Service
19,688
-
(19,688)
25%
0%
78,750
78,750
-
State Grant
50,243
-
(50,243)
25%
0%
200,972
200,972
-
SB #1065 Court Assessment
15,000
11,194
(3,806)
25%
19%
60,000
60,000
-
Marine Board License Fee
35,583
-
(35,583)
25%
0%
142,332
142,332
-
Des Cty General Fund Grant
144,036
-
(144,036)
25%
0%
576,144
576,144
-
Des Cty Transient Room Tax
518,464
518,464
-
25%
25%
2,073,856
2,073,856
-
City of Sisters
112,490
112,490
-
25%
25%
449,961
449,961
-
Des Cty CDD Contract
13,592
13,592
-
25%
25%
54,366
54,366
-
Des Cty Solid Waste Contr
13,592
13,592
-
25%
25%
54,366
54,366
-
Des Cty Clerk/Election
500
-
(500)
25%
0%
2,000
2,000
-
School Districts
20,000
-
(20,000)
25%
0% b)
80,000
40,000
(40,000)
Security & Traffic Reimb
1,250
680
(570)
25%
14%
5,000
5,000
-
Seat Belt Program
3,000
2,155
(845)
25%
18%
12,000
12,000
-
Miscellaneous
2,500
1,472
(1,028)
25%
15%
10,000
10,000
-
Restitution
-
2,004
2,004
25%
n/a
-
2,004
2,004
Sheriff Fees
2,500
2,244
(256)
25%
22%
10,000
10,000
-
Court Fines & Fees
28,750
26,101
(2,649)
25%
23%
115,000
115,000
-
Impound Fees
1,750
1,200
(550)
25%
17%
7,000
7,000
-
Restitution - Street Crimes
125
-
(125)
25%
0%
500
500
-
Seizure/Forfeiture
-
1,324
1,324
25%
n/a
-
1,324
1,324
Interest
2,500
3,222
722
25%
32%
10,000
10,000
-
Interest on Unsegregated
450
28
(422)
25%
2%
1,800
1,800
-
Donations
-
2,515
2,515
25%
n/a
-
2,515
2,515
Sale of Reportable Assets
1,500
2,305
805
25%
38%
6,000
6,000
-
Sale of Equip & Material
5,000
6,916
1,916
25%
35%
20,000
20,000
-
Total Revenues
2,903,043
869,934
(2,033,109)
50%
7%
11,612,172
11,742,517
130,345
TOTAL RESOURCES
5,839,566
3,874,467
(1,965,099)
50%
27%
14,548,695
14,747,050
198,355
REQUIREMENTS: Exp.
To: Fund 255 Departments
Sheriffs Services
38,702
38,284
418
25%
25%
154,808
160,230
(5,422)
Auto/Comm
253,798
139,870
113,928
25%
14%
1,015,193
1,015,193
-
Investigations
433,555
393,494
40,061
25%
23%
1,734,218
1,685,549
48,669
Patrol
1,977,926
1,915,888
62,038
25%
24%
7,911,704
7,841,716
69,988
Records
180,178
149,559
30,619
25%
21%
720,710
720,710
-
Special Services
99,390
91,719
7,671
25%
23%
397,559
397,559
-
Training
31,576
29,025
2,551
25%
23%
126,304
126,304
-
Internal Services
9,136
9,136
-
25%
25%
36,542
36,542
-
Contingency
587,914
-
587,914
25%
0%
2,351,656
-
2,351,656
Transfer to Reserve Fund (704) 25,000 100,000 (75,000) 25% 100% 100,000 100,000 -
Total Requirements 7,224,348 2,866,974 4,357,373 20% 14,548,695 12,083,804 2,464,891
Net (1,384,782) 1,007,493 2,392,275 - 2,663,246 2,663,246
* Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to LED #2
a) Current year property taxes will be collected beginning in October
b) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District
PUBLIC HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,596,918
$ 1,702,129
$ 105,211
100%
107%
$1,596,918
$1,702,129
$ 105,211
Revenues
Medicare Reimbursement
150
70
(80)
25%
12%
600
600
-
State Grant
646,806
451,815
(194,991)
25%
17% a)
2,587,224
2,587,224
-
Child Dev & Rehab Center
6,152
-
(6,152)
25%
0%
24,607
24,607
-
State Miscellaneous
56,207
3,163
(53,044)
25%
1%
224,829
224,829
-
OMAP
130,963
174,798
43,835
25%
33%
523,850
523,850
-
Family Planning Exp Proj
130,000
82,328
(47,672)
25%
16%
520,000
520,000
-
Local Grants
11,250
12,483
1,233
25%
28%
45,000
45,000
-
Water Program-Base Fee
10,500
9,386
(1,114)
25%
22%
42,000
42,000
-
Contract Payments
-
25,000
25,000
25%
n/a
-
25,000
25,000
Water Program-Field Work
13,954
1,680
(12,274)
25%
3%
55,817
55,817
-
H20 Sys Insp-Priv Wells
50
-
(50)
25%
0%
200
200
-
Miscellaneous
-
3,284
3,284
25%
n/a
-
7,000
7,000
Patient Insurance Fees
33,845
27,594
(6,251)
25%
20%
135,380
135,380
-
Health Dept/Patient Fees
29,693
24,241
(5,452)
25%
20%
118,770
118,770
-
Vital Records-Birth
7,650
10,635
2,985
25%
35%
30,600
30,600
-
Vital Records-Death
25,000
24,740
(260)
25%
25%
100,000
100,000
-
Environmental Health
176,088
57,334
(118,754)
25%
8% b)
704,350
704,350
-
Interest on Investments
3,000
2,084
(916)
25%
17%
12,000
12,000
-
Donations
6,508
8,384
1,876
25%
32%
26,030
26,030
-
Interfund Contract
49,597
-
(49,597)
25%
0%
198,387
198,387
-
Administrative Fee
3,764
3,764
-
25%
25%
15,056
15,056
-
Total Revenues
1,341,177
922,783
(418,394)
25%
17%
5,364,700
5,396,700
32,000
Transfers In-General Fund
579,441
579,441
-
25%
25%
2,317,765
2,317,765
-
Transfers In-PH Res Fund
7,500
-
(7,500)
25%
0%
30,000
30,000
-
Transfers In-Gen. Fund Other
16,275
16,275
-
25%
25%
65,100
65,100
-
TOTAL RESOURCES
3,541,311
3,220,628
(320,683)
25%
34%
9,374,483
9,511,694
137,211
REQUIREMENTS: Exp.
Expenditures
Personal Services
1,535,082
1,480,423
54,659
25%
24%
6,140,327
6,140,327 -
Materials and Services
466,595
463,102
3,493
25%
25%
1,866,381
1,866,381 -
Capital Outlay
50,000
-
50,000
25%
0%
200,000
200,000 -
Transfers Out
71,500
71,500
-
25%
25%
286,000
286,000 -
Contingency
220,444
220,444
25%
n/a
881,775
- 881,775
TOTAL REQUIREMENTS
2,343,621
2,015,025
328,596
25%
21%
9,374,483
8,492,708 881,775
NET (Resources - Requirements)
1,197,690
1,205,603
7,913
-
1,018,986 1,018,986
a) Monthly payments for some grants not yet processed by DHS. Anticipate receipts for these awards in October
b) Line includes 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Budget=$110,000). These are due
annually and collected in December and January
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
L Budget
Projection
Variance
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
1,375
2,355
980
25%
43%
5,500
5,500
-
Divorce Filing Fees
33,250
45,808
12,558
25%
34%
133,000
133,000
-
Domestic Partnership Fee
25
20
(5)
25%
20%
100
100
-
Federal Grants
6,075
-
(6,075)
25%
0%
24,298
24,298
-
State Grants
1,327,586
1,999,174
671,588
25%
38% a)
5,310,343
6,878,686
1,568,343
State Miscellaneous
31,043
5,155
(25,888)
25%
4%
124,173
124,173
-
ABHA
-
905
905
25%
n/a b)
-
20,000
20,000
Title 19
35,574
27,470
(8,104)
25%
19%
142,297
142,297
-
Liquor Revenue
26,250
25,024
(1,226)
25%
24%
105,000
105,000
-
School Districts
18,900
10,100
(8,800)
25%
13%
75,600
75,600
-
Miscellaneous
43,838
572
(43,266)
25%
0%
175,352
175,352
-
Patient Insurance Fees
28,425
23,111
(5,314)
25%
20%
113,700
113,700
-
Patient Fees
452
121
(331)
25%
7%
1,807
1,807
-
Interest on Investments
6,250
4,955
(1,295)
25%
20%
25,000
25,000
-
Rentals
3,275
2,250
(1,025)
25%
17%
13,100
13,100
-
Administrative Fee
1,107,422
1,077,422
(30,000)
25%
24%
4,429,689
4,429,689
-
Sheriff
5,000
-
(5,000)
25%
0% c)
20,000
(20,000)
Interfund Contract-Gen Fund
31,750
-
(31,750)
25%
o%
127,000
127,000
-
Total Revenues
2,706,490
3,224,442
517,952
25%
30%
10,825,959
12,394,302
1,568,343
Transfers In-General Fund
315,879
315,879
-
25%
25%
1,263,515
1,263,515
-
Transfers In-OHP-CDO
67,851
67,851
-
25%
25%
271,402
271,402
-
Transfers In-Acute Care Svcs
63,129
63,129
-
25%
25%
252,515
252,515
-
Transfers In-ABHA
75,216
75,216
-
25%
25%
300,863
300,863
-
TOTAL RESOURCES
6,497,324
6,854,680
357,356
25%
42%
16,183,013
17,590,760
1,407,747
REQUIREMENTS:
Exp.
Expenditures
Personal Services
2,385,682
2,297,827
87,855
25%
24%
9,542,729
9,542,729
-
Materials and Services
1,027,301
869,715
157,586
25%
21%
4,109,205
4,383,668
(274,463)
Capital Outlay
100,000
18,814
81,186
25%
5%
400,000
400,000
-
Transfers Out
71,500
71,500
-
25%
25%
286,000
286,000
-
Contingency
461,270
-
461,270
25%
n/a
1,845,079
-
1
845
079
,
,
TOTAL REQUIREMENTS
4,045,753
3,257,856
787,897
250/6
20%
16,183,013
14,612,397
1,570,616
N
ET (Resources - Requirements)
2,451,571
3,596,824
1,145,253
-
2,978,363
2,978,363
a) Department of Human Services Grant projected at amended contract amount. Additional grant resources will be expended for
Personnel and Materials & Services. Projection for Personnel has not yet been updated, pending BOCC approval to add positions.
b) Revenue for Adult Mental Health Initiative clients, not included in original budget
c) Funding for Mental Health Court from the Sheriffs Department eliminated
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 229,822
131,776
$ (98,046)
100%
57%
$
229,822
$ 131,776
(98,046)
Revenues
Admin-Operations
6,088
8,920
2,832
25%
37%
a)
24,350
26,000
1,650
Admin-GIS
250
977
727
25%
98%
b),
1,000
1,500
500
Admin-Code Enforcement
41,675
50,497
8,822
25%
30%
a)
166,700
166,700
-
Building Safety
300,220
283,839
(16,381)
25%
24%,
a)
1,200,880
1,200,880
-
Electrical
64,788
68,228
3,440
25%
26%
a)
259,150
259,150
-
Contract Services
40,050
39,608
(442)
25%
25%i
c)
160,200
160,200
-
Env Health-On Site Prog
70,100
91,143
21,043
25%
33%;
a)
280,400
290,000
9,600
Planning-Current
168,725
187,800
19,075
25%
28%;
a) ;
674,900
674,900
-
Planning-Long Range
63,432
70,447
7,015
25%
28%,
a)
253,726
253,726
-
Total Revenues
755,328
801,459
46,131
25%
27%
3,021,306
3,033,056
11,750
Trans In-GF
157,407
157,407
-
25%
25%
629,625
629,625
-
Trans In-GF for Lng Rng Ping
123,840
123,840
-
25%
25%S
495,360
495,360
-
Trans In-Other
25
-
(25)
25%
0%'
100
-
(100)
TOTAL RESOURCES
1,266,422
1,214,482
(51,940)
25%
28%','
4,376,213
4,289,817
(86,396)
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFERS
Admin-Operations
352,955
352,394
561
25%
25%%
1,411,818
1,411,818
-
Admin-GIS
31,939
29,687
2,252
25%
23%
127,755
127,755
-
Admin-Code Enforcement
51,143
51,030
113
25%
25%!
204,570
204,570
-
Building Safety
140,508
134,783
5,725
25%
24%
562,032
562,032
-
Electrical
59,355
63,124
(3,769)
25%
27%
d)
237,420
237,420
-
Contract Services
41,422
45,536
(4,114)
25%
27%
d)
165,689
165,689
-
Env Health-On Site Pgm
35,777
39,741
(3,964)
25%
28%i
e)
143,108
143,108
-
Planning-Current
154,751
136,599
18,152
25%
22%
619,002
619,002
-
Planning-Long Range
119,702
109,502
10,200
25%
23%
478,806
478,806
-
Transfers Out (D/S Fund)
43,471
43,471
25%
0%
173,885
173,885
-
Contingency
63,032
63,032
25%
n/a f
252,128
-
252,128
TOTAL REQUIREMENTS 1,094,055 962,396 131,659 25% 22%4,376,213 4,124,085 252,128
NET (Resources - Requirements) 172,367 252,086 79,719 - 165,732 165,732
Revenues 801,459 3,021,306 3,033,056 11,750
Expenditures 962,396 4,376,213 4,124,085 252,128
Net from Operations (160,938) (1,354,907) (1,091,029) 263,878
a) Activity is seasonal
b) GIS revenue is sporadic based on the frequency of customer requests
c) Contract payments from Redmond and other jurisdictions typically lag one month behind service delivery
d) Year to date actual includes payout to retired employee
e) Extra Help expenses concentrated in the summer months
ROAD
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
1
I
Year End
Budget
Actual
Variance
FY %
Coll. %1
L Budget
I
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
-
693
693
25%
n/a
-
2,000
2,000
Federal Reimbursements
150,000
-
(150,000)
25%
0%
a)
600,000
600,000
-
Federal Grant
5,000
-
(5,000)
25%
n/a
20,000
20,000
-
Mineral Lease Royalties
10,000
3,924
(6,076)
25%
10%
40,000
40,000
-
Forest Receipts
327,791
-
(327,791)
25%
0%
b)
1,311,162
1,311,162
-
State Miscellaneous
125,010
500,041
375,031
25%
100%
c)
500,041
500,041
-
Motor Vehicle Revenue
2,835,000
2,490,417
(344,583)
25%
22%
d)
11,340,000
10,440,000
(900,000)
City of Bend
68,750
-
(68,750)
25%
0%
e)
275,000
275,000
-
City of Redmond
87,500
-
(87,500)
25%
0%
e)
350,000
350,000
-
City of Sisters
2,500
-
(2,500)
25%
0%
e)
10,000
10,000
-
City of La Pine
2,500
-
(2,500)
25%
0%
e)
10,000
10,000
-
Admin Recovery (SDC)
250
893
643
25%
89%
1,000
1,000
-
Miscellaneous
5,000
6,125
1,125
25%
31%
20,000
20,000
-
Road Vacations
250
500
250
25%
50%
1,000
1,000
-
Interest on Investments
5,000
3,958
(1,042)
25%
20%
20,000
20,000
-
Parking Fees
36
-
(36)
25%
0%
144
144
-
Interfund Contract
182,500
-
(182,500)
25%
0%
f)
730,000
730,000
-
Equipment Repairs
50,000
45,483
(4,517)
25%
23%
200,000
200,000
-
Vehicle Repairs
22,500
-
(22,500)
25%
0%
90,000
90,000
-
LID Construction
2,500
-
(2,500)
25%
0%
f)
10,000
10,000
-
Vegetation Management
17,875
-
(17,875)
25%
0%
f)
71,500
71,500
-
Forester
6,250
-
(6,250)
25%
0%
f)
25,000
25,000
-
Car Washes
875
-
(875)
25%
0%
3,500
3,500
-
Sale of Equip & Material
158,250
116,607
(41,643)
25%
18%
633,000
633,000
-
Total Revenues
4,065,337
3,168,641
(896,696)
25%
19%
16,261,347
15,363,347
(898,000)
Trans In - Solid Waste
71,443
71,443
-
25%
25%
285,773
285,773
-
Trans In - Transp SDC
62,500
62,500
-
25%
25%
250,000
250,000
-
Trans In-Road Imp Res
3,000
-
(3,000)
25%
0%
12,000
12,000
-
TOTAL RESOURCES
7,037,000
6,719,742
(317,258)
25%
36%
19,643,840
19,328,278
(315,562)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
1,403,831
1,363,770
40,061
25%
24%
5,615,323
5,615,323
-
Materials and Services
2,543,169
4,682,168
(2,138,999)
25%
46%
g)
10,172,674
10,172,674
-
Capital Outlay
309,173
21,936
287,237
25%
2%
1,236,691
1,236,691
-
Transfers Out
150,000
-
150,000
25%
0%
600,000
600,000
-
Contingency
504,788
-
504,788
25%
n/a
2,019,152
-
2,019,152
TOTAL REQUIREMENTS
4,910,961
6,067,874
(1,156,913)
25%
31%
19,643,840
17,624,688
2,019,152
NET (Resources - Requirements)
2,126,039
651,868
(1,474,171)
-
1,703,590
1,703,590
a) Revenue will be received following completion of Cascade Lakes chip seal (October 2011)
b) Received annually in January
c) Annual payment received in August
d) Revenues trending less than estimates provided by ODOT
e) Billed upon completion of work
f) Payments to be received in June 2012 from other Road Department funds
g) Expenditures are seasonal and higher during summer. YTD includes $2.3 million paid to Knife River on the Full Depth Reclamation Project
in South County
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Three Months Ended September 30, 2011
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 Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 560,000 $ 634,125 $ 74,125 100%
54,338
-
(54,338)
25%
1,075
-
(1,075)
25%
7,730
-
(7,730)
25%
3,250
1,663
(1,587)
25%
713,914
401,103
(312,811)
25%
6,000
7,563
1,563
25%
1,025
452
(573)
25%
42,500
32,190
(10,310)
25%
50,000
44,676
(5,324)
25%
2,250
1,052
(1,198)
25%
12,500
12,500
-
25%
12,500
-
(12,500)
25%
18,708
-
(18,708)
25%
925,790
501,199
(424,591)
25%
84,573
84,573
-
25%
1,570,363
1,219,897
(350,466)
25%
792,172
731,454 60,718
25%
23%
3,168,688
221,723
168,424 53,299
25%
19%'
886,890
25
- 25
25%
0%
100
7,200
7,200 -
25%
25%'
28,800
129,244
- 129,244
25%
n/a'' `
516,974
;1 11 1 _1
113%' : $ 560,000 $ 634,125 $ 74,125
0%! a) `
217,350
219,240
1,890
0%' b)
4,301
4,301
-
0% c)
30,918
25,000
(5,918)
13% d)
13,000
13,000
-
14%" d)
2,855,659
2,748,953
(106,706)
32%
24,000
24,000
-
11%
4,100
4,100
-
19%
170,000
170,000
-
22%
200,000
200,000
-
12%`
9,000
9,000
-
25%
50,000
50,000
-
0%; e)
50,000
50,000
-
0% e)
74,832
74,832
-
14%
3,703,160
3,592,426
(110,734)
25%
338,292
338,292
-
27%
4,601,452
4,564,843
(36,609)
Exp.
1,150,364 907,078 243,286 25%
NET (Resources - Requirements) 419,999 312,819 (107,180)
3,168,688 -
886,890 -
- 100
28,800 -
- 516.974
20%! 4,601,452 4,084,378 517,074
- 480,465 480,465
a) Annual allocation expected in October
b) Annual allocation normally received in February
c) State invoiced monthly. Payment from State expected in October
d) Payments received quarterly; due to lower population and cost savings, revenue will be less than budgeted
e) Interfund grant received quarterly. Payment expected in October
CHILDREN & FAMILIES COMMISSION
Statement of Financial Operating Data
Three Months Ended September 30, 2011
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
Charges for Svcs-Misc
Court Fines & Fees
Interest on Investments
Donations
Interfund Grants
Total Revenues
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 467,111 $ 556,143 $ 89,032 100% 119% $ 467,111 $ 556,143 $ 89,032
74,872
-
(74,872)
9,832
-
(9,832)
23,750
-
(23,750)
64,496
-
(64,496)
6,125
24,136
18,011
77,960
-
(77,960)
136,301
-
(136,301)
2,000
86
(1,914)
19,500
27,223
7,723
1,250
814
(436)
-
5
5
30,219
22,969
(7,250)
446,305
75,233
(371,072)
25%
0% a)
299,488
299,488
-
25%
0% a)b)
39,329
39,534
205
25%
0% a)c)
95,000
85,000
(10,000)
25%
0% a)b)
257,982
196,898
(61,084)
25%
99% d)
24,500
77,622
53,122
25%
0% a)b)
311,838
258,203
(53,635)
25%
0% a)b)
545,203
502,290
(42,913)
25%
1%
8,000
8,000
-
25%
35% e)
78,000
85,000
7,000
25%
16%
5,000
5,000
-
25%
n/a
-
5
5
25%
19% f)
120,875
355,875
235,000
25%
4%
1,785,215
1,912,915
127,700
Trans from General Fund
68,240
68,241
- 25%
25%
272,960
272,960 -
Total Transfers In
68,240
68,241
- 25%
25%
272,960
272,960 -
TOTAL RESOURCES
981,656
699,617
(282,040) 25%
28%
2,525,286
2,742,018 216,732
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Exp.
151,280
142,022 9,258
25%
23% 605,119 605,119 -
421,745
85,099 336,646
25%
5% g) 1,686,979 1,722,729 (35,750)
25
- 25
25%
0% 100 100 -
58,272
- 58,272
25%
n/a 233,088 233,088
631,322 227,121 404,201 25% 9%
NET (Resources - Requirements) 350,334 472,496 122,161
2,525,286 2,327,948 197,338
- 414,070 414,070
a) Grant payments received normally within 60 days after the end of each quarter
b) FY 12 and FY 13 Intergovernmental Agreement finalized funding levels from OCCF. Community Schools grant included in year-
end projection at $9,484
c) Medicaid revenues reduced due to lower projections
d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from DHS not budgeted for $48,122
e) Court fees projected to be higher than estimated in the original budget
f) Two additional grants of $55,000 & $180,000 awarded
g) Sub-grant expenditures paid quarterly
SOLID WASTE
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$1,092,508 $
1,141,691
$ 49,183
100%
Revenues
Miscellaneous
5,500
5,523
23
25%
Franchise 3% Fees
50,000
8,098
(41,902)
25%
Commercial Disp. Fees
215,000
257,673
42,673
25%
Private Disposal Fees
328,500
408,245
79,745
25%
Franchise Disposal Fees
1,000,000
1,058,052
58,052
25%
Yard Debris
18,250
33,474
15,224
25%
Special Waste
6,250
1,081
(5,169)
25%
Interest
1,875
2,369
494
25%
Leases
-
2,293
2,293
25%
Recyclables
7,500
26,760
19,260
25%
Total Revenues
1,632,875
1,803,568
170,693
25%
TOTAL RESOURCES
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out-Road
Contingency
TOTAL REQUIREMENTS
2,725,383 2,945,259 219,876 25%
417,900
398,068
19,832
25%
723,263
480,489
242,774
25%
242,808
-
242,808
25%
43,000
58,370
(15,370)
25%
339,943
527,443
(187,500)
25%
139,088
-
139,088
25%
1,906,002 1,464,370 441,632 25%
NET (Resources - Requirements) 819,381 1,480,889 661,508
a) Due April 15, 2012
b) Seasonal item-Fall 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) Recycling markets are higher than expected. Often it can be seasonal
f) To be expended in November ($398,827) and May ($572,406)
g) Transfers made quarterly
105%
$1,092,508
$ 1,141,691 $
49,183
25%;
22,000
22,000
-
4%
a)
200,000
200,000
-
30%'
860,000
860,000
-
31%
1,314,000
1,314,000
-
26%
4,000,000
4,000,000
-
46%
b) ;
73,000
73,000
-
4%
c)
25,000
25,000
-
32%;
7,500
7,500
-
n/a
d)'
1
10,394
10,393
89%
e) ;
30,000
30,000
-
28°k"
6,531,501
6,541,894
10,393
39%
7,624,009
7,683,585
59,576
Exp.
24%`
1,671,598
1,671,598
-
17%
2,893,052
2,893,052
-
0%
f)
971,233
971,233
-
34%
172,000
172,000
-
39%
g)
1,359,773
1,359,773
-
n/a'
556,353
556,353
19% I
7,624,009
7,067,656
556,353
615,929 615,929
RISK MANAGEMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2011
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
Interest on Investments
Other Interest
TOTAL REVENUES
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
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
Defense
Professional Service
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Year to Date
YBudget Actual I Variance % of FY % Coll. Budget Variance
$2,100,000 $2,039,937 ($60,063)
100% 97% $2,100,000 $2,039,937 ($60,063)
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Transfers Out
TOTAL REQUIREMENTS
NET
62,714
62,714
0
25%
25%i; E
250,855
250,855 -
77,908
77,908
(0)
25%
25% `
311,633
311,633 -
44,578
44,578
0
25%
25%'
178,310
178,310 -
368,486
368,486
-
25%
25%
1,473,944
1,473,944 -
63,108
63,189
81
25%
25%
252,433
252,433 -
1,250
-
(1,250)
25%
0%'
5,000
5,000 -
5,000
9,054
4,054
25%
45%,
20,000
20,000 -
375
595
220
25%
40%'
1,500
1,500 -
13
-
(13)
25%
0%
50
50 -
4,500
770
(3,730)
25%
4%-'
18,000
18,000 -
3,750
3,094
(656)
25%
21%
15,000
15,000 -
13
-
(13)
25%
0%
50
50 -
631,694
630,388
(1,306)
25%
25%
2,526,775
2,526,775 -
2,731,694
2,670,325
(61,369)
25%
58%
4,626,775
4,566,712 (60,063)
EX .
10,304
44,105
196
100
29,838
611
100,000
85,153
14,847
25%
21%
400,000
400,000 -
87,292
7,494
75,056
94,786
(19,730)
25%
32% '
300,223
280,000 20,223
376
2,773
15,592
25,371
18,741
6,630
25%
18%'' "
101,485
98,000 3,485
228,662
134
54,720
8,714
14
200,000 292,243 (92,243)
62,500 62,500
462,927 490,924 (27,997)
73,589
69,393
4,196
41,929
34,097
7,832
25
-
25
115,544
103,490
12,054
1,800
1,800
-
580,271
596,214
(15,943)
2,151,423
2,074,111
(77,313)
25%
37%
800,000
820,000
(20,000)
25%
0%
250,000
250,000
-
25%
27%
1,851,708
1,848,000
3,708
25%
24%
294,357
294,357
-
25%
20%'
167,717
167,717
-
25%
0%
100
-
100
25%
22%
462,174
462,074
100
25%
25%-
7,200
7,200
-
25%
26%
2,321,082
2,317,274
3,808
2,305,693
2,249,438
(56,255)
Contingency is $2,305,693.
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date Year End
Budget Actual Variance % of FY % Coll. Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$6,400,000 $
7,559,639
$ 1,159,639
Revenues
Property Taxes - Current
1,495,943
-
(1,495,943)
Property Taxes - Prior
50,000
109,595
59,595
State Reimbursement
13,500
-
(13,500)
Telephone User Tax
187,500
-
(187,500)
Data Network Reimb.
6,800
-
(6,800)
Jefferson County
8,750
751
(7,999)
User Fee
13,000
-
(13,000)
Police RMS User Fees
49,750
-
(49,750)
Contract Payments
8,000
-
(8,000)
Miscellaneous
2,250
1,845
(405)
Interest
8,750
9,557
807
Interest on Unsegregated Tax
200
24
(176)
Total Revenues
1,844,443
121,772
(1,722,671)
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
100% 118% $ 6,400,000 $ 7,559,639 $ 1,159,639
25%
0%
a)
5,983,773
6,117,731 133,958
25%
55%
200,000
200,000 -
25%
0%
b)
54,000
54,000 -
25%
0%
750,000
750,000 -
25%
0%
c)
27,200
27,200 -
25%
2%
35,000
35,000 -
25%
0%
d)
52,000
52,000 -
25%
0%
e)
199,000
199,000 -
25%
0%
c)
32,000
32,000 -
25%
21%
9,000
9,000 -
25%
27%
35,000
35,000 -
25%
3%
800
800 -
25%
2%
7,377,773
7,511,731 133,958
8,244,443 7,681,411 (563,032) 25% 56% 13,777,773 15,071,370 1,293,597
Exp.
1,060,209
951,480
108,729
25%
22%
4,240,834
4,240,834 -
489,339
429,354
59,985
25%
22%
1,957,356
1,957,356 -
218,250
94,731
123,519
25%
11%
873,000
873,000 -
125,000
500,000
(375,000)
25%
100% f)
500,000
500,000 -
1,551,646
-
1,551,646
25%
n/a
6,206,583
- 6,206,583
3,444,444
1,975,565
1,468,879
25%
14%
13,777,773
7,571,190 6,206,583
4,799,999
5,705,846
905,847
-
7,500,180 7,500,180
a) Current year property taxes will be collected beginning in October
b) GIS/MSAG monthly billings to Oregon Emergency Management; July and August payments not yet received
c) Invoiced annually; invoices being mailed to User Agencies in October
d) US Forest Service invoiced $2156.25 quarterly. Payment expected in November. Crooked River Ranch invoiced annually June 30th.
Payment will not be received from Crooked River Ranch until FY 13
e) Fees expected to be billed out December or January
f) Entire amount budgeted transferred to reserve fund in September
Health Benefits Trust
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
I Budget I
Projection
Variance
RESOURCES
Beg. Net Working Capital
$15,500,000
$ 15,829,888 $
329,888
100%
0
$15,500,000
$ 15,829,888
329,888
Revenues:
Internal Premium Charges
3,003,928
2,998,087
(5,841)
25%
25%
12,015,711
12,015,711
-
P/T Emp - Add'I Prem
12,500
7,549
(4,951)
25%
15%
50,000
50,000
Employee Prem Contribution
157,500
157,415
(85)
25%
25%
630,000
630,000
-
COIC
315,000
315,419
419
25%
25%
1,260,000
1,260,000
Retiree / COBRA Co-Pay
125,000
236,305
111,305
25%
47%
500,000
500,000
-
Fees for Clinic Services
-
200
200
25%
n/a
-
200
200
Federal Payment *
-
_ 150,431
150,431
25%
n/a
150,431
150,431
Prescription Rebates
-
27,975
27,975
25%
n/a
27,975
27,975
Interest
20,000
21,677
1,677
25%
27%
80,000
80,000
-
Total Revenues
3,633,928
3,915,059
281,132
25%
27%
14,535,711
14,714,318
178,607
TOTAL RESOURCES
19,133,928
19,744,948
611,020
92%
103%
30,035,711
30,544,206
508,495
REQUIREMENTS
Exp.
Expenditures:
Personal Services
32,516
31,247
1,268
25%
24%
130,062
130,062
-
Materials & Services
Claims Paid-Medical/Rx
3,118,571
2,745,425
373,146
25%
22% a)
12,474,284
9,601,901
2,872,384
Claims Paid-DentalNision
465,993
453,622
12,371
25%
24% a)
1,863,974
1,509,166
354,808
Refunds
0
(11,445)
11,445
25%
n/a
-
(11,445)
11,445
Insurance Expense
87,500
87,543
(43)
25%
25%
350,000
350,000
-
State Assessments
37,500
70,788
(33,288)
25%
47%
150,000
150,000
Administration Fee
80,000
78,916
1,084
25%
25%
320,000
320,000
PPO Fee
12,500
12,156
344
25%
24%
50,000
50,000
-
Health Impact
13,750
12,946
805
25%
24%
55,000
55,000
Other
40,580
44,359
(3,780)
25%
27%
162,318
162,318
-
Total HBT - Dept 31
3,888,910
3,525,557
363,352
23%
15,555,638
12,317,002
3,238,636
Deschutes On-site Clinic
Healthstat
239,300
124,316
114,984
25%
13%
957,200
957,200
-
Medications/Drugs
81,250
34,565
46,685
25%
11%
325,000
325,000
Equipment
1,000
-
1,000
25%
0%
4,000
4,000
Miscellaneous
2,113
5,919
(3,806)
25%
70%
8,450
8,450
Total DOC
323,663
164,800
158,862
1,294,650
1,294,650
-
Capital Outlay
50
-
50
25%
n/a
200
-
200
Contingency
3,296,306
-
3,296,306
25%
n/a
13,185,223
-
13,185
223
,
TOTAL EXPEND/REQUIREMNTS
7,508,928
3,690,357
3,818,570
25%
12%
30,035,711
13,611,652
16,424,059
NET (Resources - Requirements) 11,625,000 16,054,590 4,429,590 - 16,932,554 16,932,554
* 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 14 weeks of claims paid. YTD actual is $227,686 per week.
10/12/2011
Deschutes County - Fair and Expo Center
YTD-Budget Basis Commissioners
Statement of Financial Operating Data
Three Months Ended September 30, 2011
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
Total Expenditures
Transfers Out - Reserve Fund
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 75,000 $ (40,601) $ (115,601) 100% -54%
$ 75,000 $ (40,601) $ (115,601)
151,250
209,825
58,575
25%
35%
605,000
584,825
(20,175)
375
125
(250)
25%
8%
1,500
1,250
(250)
14,500
-
(14,500)
25%
0%
58,000
58,000
-
1,500
-
(1,500)
25%
0%
6,000
6,000
-
7,500
4,186
(3,314)
25%
14%
30,000
34,186
4,186
55,000
38,738
(16,262)
25%
18%
220,000
211,738
(8,262)
28,000
16,000
(12,000)
25%
14%
112,000
122,000
10,000
11,750
-
(11,750)
25%
0%
47,000
47,000
-
1,702
4,514
2,812
25%
n/a
6,807
9,020
2,213
271,577
273,388
1,811
25%
25%
1,086,307
1,074,019
(12,288)
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
-
55,000
-
(55,000)
25%
0%
220,000
220,000
-
25
-
(25)
25%
0%
100
-
(100)
124,661
69,636
(55,025)
498,644
498,544
(100)
471,238
302,423
(168,815)
25%
18%
1,659,951
1,531,962
(127,989)
Exp.
216,505 214,848
1,657
25% 25%
866,018
864,385
1,633
120,265 119,500
765
25% 25%
481,060
494,577
(13,517)
28,767 -
28,767
25% 0%
115,068
115,068
-
25 -
25
25% 0%
100
-
100
365,562 334,348
31,214
1,462,246
1,474,030
(11,784)
2,500
46,926
2,500 25% 0% 10,000 10,000 -
46,926 25% n/a 187,705 - 187,705
414,988 334,348 80,640 25% 20% 1,659,951 1,484,030 175,921
56,250 (31,925) (88,175) - 47,932 47,932
H
w
ti
0
x
a
a
H
a.
U
U
0
0
z
a~
a~
74
O
O N
C
=p O
M
co L
c
:3 aa)iE
O U 0
U '5; Q
(D m
U) U)
O a L
CAA
N O O
a) O L
0 U
O
O 'Q
Z C
U
C
co
w
U
D
O
N
w
w
rn rn
O o
O Cl) O O O
N
O r- O O O
N
O O O O ~
ti
O C \f O
ti
O O N O
N
O O
O
N r
qq
O M O O
M
O O O
r
0 0 0 C '
O
O N LO O
h
O O N O
N
O 'ct CO
Cl
N -
CO
M O O m
N
r- O O O
N
' O O O ti
ti
N LO O
ti
O N O
N
'7 co
o
1-
N
i I i i I
I
C)
O O
Cl) O O
M
M f` O
M
C)
O O
(D C) Cl
CO
- M LO
V-
C) O
' w O O '
0
O CM C'M
' O
66
S O C \f
cV 1- M
O -
CO
r-
O LO LO
N
r
V 00
O
r C \f
O O
M O O
CO
M fl- O
M
O O
CO O O
co
M to
r
O O
' Cp O O '
Cfl
O CM M
' O
'
C) CD
ON
M
N - M
f,-
C)
co
f-
O LO LO
N
cr co
O
~NM
er
2 c;
O
co CO
N
M O
M
O
O N
N
O
N
N
Cn
LO
O
O
It
~
~
1-
O
C)
U')
N
0
0
O '
Ln
N
i
Cl) O O D
N
O CO CO
N
M O
M
C) 0 0
N
C)
' O O O ti
n
O
O N
N
O
O
N
O
N
N
N
N
N
O
O
Nr CO
O
d
r
N
r
cn
N
O
U
a)
U
c
cu
U) ~ ~
O O C
LL U- U)
vS E E = m
-0 0 0 c V
0 4 > 3
O V 0 L d
CL L ` w ; a/
7 7
C cn N C
N
CB
f CC w H H
N
d
E
•7 2
U N m
f0
N 7
v '(A a) o N _c 0
w o N N
N O U
CL
E N M m
F- ~zs Y 'L rn ~ a) 2 2 ~ -0 m
Z cu U c c cu `c °
rn C O_> O
w E O
X m<wa- CLL~F-~ mJ
w U
et
w
' M
ch
r
0
0
'o
N
It
co
' M
O
N
r
fn
L
U C
C m
a) a
rn
c= x
w
O !0
U 0
N
ti
M
M
d'
Ln
0
0
0
L
N
M
M
C)
C)
Ln
d
Z
Cl)
O
N
O
d' N
r ~
6R ~
~ C
LL
a) v
N
tY ~
LL
.a
a) Cl)
~ U
a)
C 0
ca a
C
a) c
E
0 O
U
> m
p c
m
U (7
m
O O
a` 4-
E En
m
U
W. L
cn :3
a) 0
` O
7 L
O L
U)
~ r
•3 O
N
r }
O LL
N C
LL U
C_ (D
a)
~ co
co a)
~ Y
U
Q O
U
c6 a
CT cn
c m
C)
O
a) L
L
F- CA
m
00 0
N 0
U O O
d N N
m
N U)
O P
It z
-0 W
N
C p
i5 O CY)
- U
m ~ .n
cn Z E
U Q ~
Cn C1
N
U
U) Z L
O)
C 0
O
m
U
~U
`o Z
Z u.i
O O
O O
a Ln In
.r N N
C
O
Q
C O O
E C O O
E 0 LO LO
E Q
U
U
N N
N N
~ U
a~
U
N
L
U
L
Q
` U
6
C L
N
~ Q
J
CO
ti
Deschutes County
Bethlehem Inn (Fund 128)
Three Months Ended September 30, 2011
Budget
Actual
Variance
FY %
Coll. %
I
Budget I
Projection I
Variance
RESOURCES:
Beg. Net Working Capital
$ (2,711,235) $
(2,716,581)
$ (5,346)
100%
100%
$ (2,711,235)
$ (2,716,581)
$ (5,346)
Revenues
Grants - Private
700,457
-
(700,457)
25%
0%
2,801,827
-
(2,801,827)
Lease Payments
6,102
8,136
2,034
25%
33%
24,408
24,408
-
Total Revenues
706,559
8,136
(698,423)
25%
0%
2,826,235
24,408
(2,801,827)
TOTAL RESOURCES
(2,004,676)
(2,708,445)
(703,769)
25%
-2355%
115,000
(2,692,173)
(2,807,173)
REQUIREMENTS: Exp.
Expenditures
Debt Service:
Interest Expense 3,750 3,806 (56) 25% 25% a) 15,000 15,000 -
Interest Payment 25,000 - 25,000 25% 0% 100,000 - 100,000
TOTAL REQUIREMENTS 28,750 3,806 24,944 25% 3% 115,000 15,000 100,000
NET (Resources - Requirements) (2,033,426)
(2,712,251) (678,825)
* October lease payment received Septembe
r 29.
a) Interest on September 2011 negative cas
h balance: $1,188.90.
b) Inception through September 30, 2011
Revenues - Lease Payments
$ 32,544
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
226,883
Total expended
2,744,795
Net
$ (2,712,251)
b) - (2,707,173) (2,707,173)
~i
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of September 30, 2011
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a) DEQ requirement for gas detection
Change Order #2 LFG well field management SOPs
Change Order #3 Storm sewer realignment, drainage, Area A thickness
Total Contract
Amount Paid
Through June 30, 2011 (Final payment made December 2010)
Balance Due
Construction Contract
M A DeAtley Construction Inc
Original Contract - @ estimated cu.yd.
Amended Contract - @ revised cu.yd. and damages
Change Orders:
Change Order #1
Meet CEC requirements, increase to electrical panel,
Change Order #2
Storm sewer realignment due to refuse encountered
Change Order #3
Revise valve vaults for improved efficiencies
Change Order #4
Add'I cover material from what will be Cell 6
Change Order #5
Environmental controls building, pump station bulkheads
Change Order #6
Adjustment to pipe alignment to increase slope
Change Order #7 (not likely to occur)
Change Order #8
Additional rock to be set aside for future needs
Change Order #9
Manhole covers below grade to meet Road Dept requirements
Change Order #10
Modular Block Wall instead of MSE Wall
Change Order #11
Upgrade of cables (pump and leachate)
Change Order #12
Leachate Line connection from Cell 5 to Cells 3 & 4
Change Order #13
Additional cover material due to settling
Change Order #14
Well modification, flow meter less LFG vaults
Damages
Total Contract
Amount Paid
Through June 30, 2011
July 1, 2011 through July 31, 2011
Balance Due
Total of Engineering and Construction Contracts:
Original Contracts k
Change Orders and Damages
Total Contract v'
Amount Paid
Through September 30, 2011
Vd K .
Balance Due
"Area A"
"Cell 5"
capital
Landfill Closure
Projects Fund
Fund 611
613
Total
241,869.00 182,516.00 424,385.00
19,656.00
- 19,656.00
21,500.00
- 21,500.00
34,316.00
33,431.00 67,747.00
317,341.00
215,947.00 533,288.00
317,341.00 215,947.00 533,288.00
2,097,140.50 3,290,779.98 5,387,920.48
2,284,885.13 3,552,521.82 5,837,406.94
-
45,095.00
45,095.00
14,302.54
-
14,302.54
24,885.69
-
24,885.69
32,690.70
-
32,690.70
-
148,958.89
148,958.89
1,332.00
-
1,332.00
-
204,700.00
204,700.00
2,486.98
-
2,486.98
-
5,167.76
5,167.76
-
2,200.00
2,200.00
-
6,354.75
6,354.75
55,853.20
-
55,853.20
5,938.50
-
5,938.50
-
(35,000.00)
(35,000.00)
2,422,374.74
3,929,998.22
6,352,372.95
2,343,073.99 3,798,516.46 6,141,590.45
79,300.75 131,481.76 210,782.50
2,526,754.13 3,735,037.82 6,261,791.94
212,961.61 410,907.40 623,869.01
2,739,715.74 4,145,945.22 6,885,660.95
2,660,414.99 4,014,463.46 6,674,878.45
79,300.75 131,481.76 210,782.50
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2012
1
BOCC Conference & Travel
Jul
Aug
Sep
YTD Total
Tammy Baney
j
Conf/Sem & Educ/Training
665
-
-
665
Travel Meals
220 !
220
Accommodations
996
211
1,207
Airfare
i
Mileage reimbursement
-
-
794
794
Ground Transport/Parking
-
-
150
150
Total Baney
1,661 ;
-
1,375
3,036
Alan Unger
j
Conf/Sem & Educ/Training
665 !
-
-
665
Travel Meals
-
-
-
-
Accommodations
1,131
-
-
1,131
Airfare
-
-
-
-
_ Mileage reimbursement
-
-
-
-
Ground Transport/Parking
-
-
-
-
Total Unger
1,796
-
-
1,796
Tony DeBone
_Conf/Sem & Educ/Training
665
-
-
665
Travel Meals _
Accommodations
-
908
-
-
_ -
-
-
908
Airfare
-
-
-
-
Mileage reimbursement
-
300 j
-
300
Ground Transport
-
54 1
- Tj
54
Total Other
1,573
354
-
1,927
Total - BOCC Department
Conf/Sem & Educ/Training
1,330
-
-
1,995
Travel Meals
- 1
-
220 !
220
Accommodations
1,904
-
211
3245
Airfare
-
-
-
-
Mileage Reimbursement
300
794
1,094
Ground Transport
-
54
150
204
Total - BOCC Department
3,234
354
11375 6,759
FY 2012 Budget
j
14,750
Percent of FY 2012 Budget Expended
j
45.8%
I
BOCC County College j
1
Public Information
-
-
Office/Copier Supplies
-
- -
120
120
Meeting Supplies
-
-
556.
556
I
-
-
675 j
675
9/30/2011
RV Park (Fund 601)
Statement of Financial Operating Data
Three Months Ended September 30, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
RV Park Fees < 31 Days
RV Park Fees > 30 Days
Tent Space Rental
Washer / Dryer
Vending Machines
City of Redmond
Room Tax Collection Fee
Interest on Investments
Cancellation Fees
Total Revenues
Transfers In-Fund 130
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Materials & Services
Debt Service
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Year to Date Year End
Budget Actual Variance IF % Coll. % Budget Projection Variance
$10,000 $
(28,100)
$ (38,100)
100%
n/a
$10,000
$ (28,100)
$ (38,100)
44,625
84,949
40,324
25%
48% a)
178,500
178,500
-
1,850
1,300
(550)
25%
18% a)
7,400
7,400
-
200
-
(200)
25%
0%
800
800
-
398
708
310
25%
44%
1,593
1,593
-
300
298
(2)
25%
25%
1,200
1,200
-
1,000
-
(1,000)
25%
0%
4,000
4,000
-
-
-
-
25%
n/a
-
-
-
-
37
37
25%
n/a
-
37
37
-
1,060
1,060
25%
n/a
-
1,060
1,060
48,373
88,351
39,978
25%
46%
193,493
194,590
1,097
35,000
-
(35,000)
25%
0%
140,000
140,000
-
93,373
60,252
(33,121)
25%
18%
343,493
306,490
(37,003)
Exp.
21,431
29,774
(8,343)
25%
35%
85,722
85,722
-
-
-
-
25%
0%
242,829
242,829
-
3,736
-
3,736
25%
n/a
14,942
-
14,942
25,167
29,774
(4,607)
25%
9%
343,493
328,551
14,942
68,206
30,477
(37,729)
-
(22,061)
(22,061)
a) 2,695 RV spaces rented
V
o 0 0 0
C:
C14 cl)
fl_ M
Q
o
N
li ~
U
c
N
U
O
N
p
(n O
O) M Co LO
N
P
O
U
cu
_
CL N
a)
";3 00 "T
to
L
L
~
>
N
O co
(p N
IL (U
~ O O N
> LL
(6(6
- O
'IT N
DD
U
0 0 0 0 0 0\° -0-0 0\° 0 0
C
0
0 0
M I- N O) O m c,4 V O) i- O m m
(Q
co N - ti O (0 M O co IT IT M
o O
00 N (D O Cl) O 1 N O IT N N N
U
CO
r r r
U
O
r
(n
Y
Cfl M N c- M M M O) T O M I- N
C)
a)
U
M
r-
Lo CD m 1~.
O O O
O
~
CN
0
.
.
a (n N
-
cl C
M f.
M LO .
LL
K>
(n ot~
LL
N
LL
Y
N N M m m Cfl 'IT m m It ct Cfl N
U
CD
N
V
w
O r- ti
c
0
a
O
w ~t O
O CO
N
m
O
U
> LL
V' ti Ui Cl c-
C7 d' '-T c- Cl O r r to
O
ten O
(
C)
C
-
N
\°O
o 0 0 0
0 0 0 0 0 0 0 0
Cn
O)
U
C
C
CO O O N O ti O O co
f.
I- M 00 qT 00
Y
O
U
N
0
N N - O O) O Co
O
-0,
° O_
- O 00 O N O N N m O CD O CO
L
~ N
U
N
N
7
U
LL
O
U O
w
C
O C
C)
(n -0
Y (CV
O m O M O I- "T "T O CO m co M
O
"0 O
O
w,
N
N EA
O M~ m r- w O O N M O
Cl) N M N N N Cfl Cl)
`
cu
ca
0
C
m
a)
a
> cn
m
~ E
LL
U)
~
0
t
0
a) 0
c
m
U
U
U
Y
CO 'f 't 'T 00 'qT 00 00 qT N N 00 N
00 r- O co
-
(0
C
U
Co N I
O (D O) ~ O co
'
*
aj
(1)
00
4
MO00NM0LO ~MCO N
II N
~
V
> a)
N =000N NNOOtiNO
NN O
C
> ~
O
N
-.0- \0 0 .10- ° \0 0 0 ° -00,
0 0
f n CC O U
}
LL
~
O 00 ~ ~ 0 0 0p M O c- N "T M
(0 00 O M CO ~ O
-
a) O m
In Q
cu
N O I
(D O
U
C6 0
c O.
0000.-OOO ICON I.
0
Q
N
(n r- a)
U
O
~ rn
O)
O
O
N-0
y
000rnqt Orn - OO
C
c
C
co
N
0
V
a(n N
'IT M N M O c- N N E fN.
(0
R
LL
Q~
> ~M
N
w o
O
fn
U-
0o UM
CO
M
O)
N
CU
to
N~ O qT N O O M O V" N O N
II
, r-
o)
U) oo
>
(B
CL (D
O V O) qT M - O N (fl V, O M M
M O O d (O CO G O O
,
•N co
Ca
(D
> LL
O O) CO r- ti M 1.
N 00
N ~
O (6 00
CO
` 00
M (D U O
u) E
-
r
Q) :3
C
.
E (n Q
~
+
C)
om
.O
ca C)
(6
>
Q
N O O
w
(0
U >
O
m
a) m
G) (D
03
ai N
Q- 00 U)
~Ea)EE~c~
o
co
~
tm
a)
°
`
69- ca
O v
U
~
0
oaca
)M~(
i00 a
5
a
0
a
~Qcn0z0 )LL~Q~~>-
r=
Building Services - 620
Statement of Financial Operating Data
Three Months Ended September 30, 2011
RESOURCES:
Beg. Net Working Capital
$ 424,000
$ 529,500
$ 105,500
100%
Revenues
Cleaning/Maintenance
40,845
21,690
(19,156)
25%
Insurance Reimbursement
-
9,331
9,331
25%
Utility Reimbursement
1,000
683
(317)
25%
Facilities Charge to State
47,004
29,374
(17,630)
25%
Miscellaneous
-
6
6
25%
Interest on Investments
750
801
51
25%
Interfund contract
2,500
2,500
(0)
25%
Building Svcs Indirect Chgs
497,810
497,807
-
25%
Total Revenues
589,909
562,191
(27,715)
25%
TOTAL RESOURCES
1,013,909
1,091,692
77,785
25%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Transfer to Veh Reserve
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
nla
$ 424,000
$ 529,500 $
105,500
13%
163,380
163,380
-
n/a
-
-
-
17%
4,000
4,000
-
16%
188,016
188,016
-
n/a
-
-
-
27%
3,000
7,000
4,000
25%
10,000
10,000
-
25%
1,991,229
1,991,229
-
24%
2,359,625
2,363,625
4,000
39%
2,783,625
2,893,125
109,500
Exp.
420,171 418,801
1,370
25%
25%
1,680,685
1,680,685 -
190,640 165,657
24,982
25%
22%
762,558
762,558 -
9,900 9,900
-
25%
25%
39,600
39,600 -
25 -
25
25%
0%
100
100 -
75,171 -
75,171
25%
0%
300,682
- 300,682
695,906 594,358 101,548 25% 21%
2,783,625 2,482,943 300,682
NET(Resources - Requirements) 318,003 497,334 179,334 - 410,182 410,182
Admin Services - 625
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$ 183,000
$ 158,276 $
(24,724)
100%
Revenues
Miscellaneous
-
20
20
25%
Interest on Investments
-
240
240
25%
Admin Dept Indirect Chgs
220,435
220,434
(0)
25%
Total Revenues
220,435
220,694
260
25%
Transfers In-General Fund
10,000
10,000
-
25%
TOTAL RESOURCES
413,435
388,970
(24,464)
25%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Transfer to Veh Reserve
Capital Outlay
Contingency
TOTAL REQUIREMENTS
n/a
$ 183,000
$ 158,276 $
(24,724)
n/a
-
20
20
n/a
-
240
240
25%
881,738
881,738
-
25%
881,738
881,998
260
25%
40,000
40,000
-
35%
1,104,738
1,080,274
(24,464)
Exp.
215,317 372,805
(157,487)
25%
43%
861,269
861,269 -
27,162 20,880
6,282
25%
19%
108,648
108,648 -
900 900
-
25%
25%
3,600
3,600 -
25 -
25
25%
0%
100
100 -
32,780 -
32,780
25%
0%
131,121
- 131.121
276,185 394,585 (118,400) 25% 36%
1,104,738 973,617 131,121
NET (Resources - Requirements) 137,250 (5,614) (142,864) - 106,657 106,657
BOCC - 628
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$ 115,000
$ 114,142 $
(858)
100%
n/a
Revenues
Sale Map Photo or Copies
-
6
6
25%
n/a
Interest on Investments
125
168
43
25%
n/a
Admin Dept Indirect Chgs
90,205
90,205
1
25%
25%
TOTAL RESOURCES
205,330
204,521
(809)
25%
43%
REQUIREMENTS:
Exp.
Expenditures
Personal Services
84,416
84,374
42
25%
25%
Materials and Services
22,390
20,459
1,931
25%
23%
Capital Outlay
25
-
25
25%
0%
Contingency
12,249
-
12,249
25%
0%
TOTAL REQUIREMENTS
119,080
104,833
14,247 25% 22%
NET (Resources - Requirements)
86,250
99,688
13,438
$ 115,000 $ 114,142 $ (858)
500 500 -
360,820 360,820 -
476,320 475,462 (858)
337,664 337,664 -
89,561 89,561 -
100 - 100
48,995 - 48,995
476,320 427,225 49,095
48,237 48,237
Finance - 630
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 603,000
$ 788,522
$ 185,522
100%
n/a
$ 603,000
$ 788,522
$ 185,522
Revenues
Investment Fee
10,000
7,855
(2,145)
25%
20%
40,000
40,000
-
Photo copies
38
95
57
25%
63%
150
95
(56)
IGA Contracts
3,862
-
(3,862)
25%
0%
15,446
15,446
-
Interest on Investments
1,000
1,067
67
25%
27%
4,000
4,000
-
Interfund Contracts
3,000
3,000
-
25%
25%
12,000
12,000
-
Finance Dept Indirect Chgs
206,969
206,968
(0)
25%
25%
827,874
827,874
-
Total Revenues
224,868
218,985
(5,883)
25%
24%
899,470
899,415
(56)
TOTAL RESOURCES
827,868
1,007,507
179,639
25%
67%
1,502,470
1,687,936
185,466
REQUIREMENTS:
Exp.
Expenditures
Personal Services
226,283
212,282
14,001
25%
23%
905,131
905,131
-
Materials and Services
68,726
100,575
(31,850)
25%
37%
274,902
274,902
-
Capital Outlay
2,500
-
2,500
25%
0%
10,000
-
10,000
Contingency
78,109
-
78,109
25%
0%
312,437
-
312,437
TOTAL REQUIREMENTS
375,618
312,857
62,760
25%
21%
1,502,470
1,180,033
322,437
NET (Resources - Requirements) 452,250 694,650 242,400 - 507,903 507,903
a) Will be paid in June 2011.
Legal-640
Statement of Financial Operating Data
Three Months Ended September 30, 2011
RESOURCES:
Beg. Net Working Capital
$ 148,500
$ 154,921 $
6,421
100%
n/a
Revenues
Sale Map Photo or Copies
75
123
48
25%
41%
Miscellaneous
250
-
(250)
25%
0%
Interest on Investments
375
264
(111)
25%
18%
Interfund Contract
2,375
-
(2,375)
25%
0%
Legal Counsel Indirect Chgs
188,658
188,658
0
25%
25%
Total Revenues
191,733
189,044
(2,689)
TOTAL RESOURCES 340,233 343,966 3,733 25% 38%
REQUIREMENTS: Exp.
Expenditures
Personal Services
187,880
166,520
21,360
25%
22%
Materials and Services
11,161
6,165
4,995
25%
14%
Capital Outlay
25
-
25
25%
0%
Contingency
29,793
-
29,793
25%
0%
TOTAL REQUIREMENTS
228,858
172,685
56,173
25%
19%
NET (Resources - Requirements)
111,375
171,281
59,906
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 148,500 $ 154,921 $ 6,421
300
300 -
1,000
1,000 -
1,500
1,500 -
9,500
9,500 -
754,632
754,632 -
766,932 766,932
915,432 921,853 6,421
751,519 751,519 -
44,642 44,642 -
100 - 100
119,171 - 119,171
915,432 796,161 119,271
125,692 125,692
Personnel - 650
Statement of Financial Operating Data
Three Months Ended September 30, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Miscellaneous
Interest on Investments
Personnel Indirect Chgs
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
a) Manley Services Payment
Year to Date
-
Year End
Budget
Actual
Variance
FY
1
Coll. %
Budget
Projection
Variance
$ 305,500
$ 360,650 $
55,150
100%
nla
250
115
(135)
25%
11% a)
750
548
(202)
25%
18%
181,333
181,333
0
25%
25%
182,333
181,995
(338)
25%
25%
$ 305,500 $ 360,650 $ 55,150
1,000
115 (885)
3,000
3,000 -
725,330
725,330 -
729,330
728,445 (885)
487,833 542,644 54,812
1,034,830 1,089,094 54,264
Exp.
152,646
148,325
4,321
25%
24%
76,852
35,055
41,797
25%
11%
25
-
25
25%
0%
29,184
-
29,184
25%
0%
258,708
183,380
75,327
25%
18%
229,125
359,264
130,139
610,584
610,584
-
307,409
307,409
-
100
-
100
116,737
-
116,737
1,034,830
917,993
116,837
-
171,101
171,101
Information Tech - 660
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 513,000 $
650,653
$ 137,653
100%
nla
$ 513,000
$ 650,653
$ 137,653
Revenues
Miscellaneous
-
50
50
25%
n/a
-
50
50
Interest on Investments
1,000
983
(17)
25%
25%
4,000
4,000
-
Leases
5,250
8,201
2,951
25%
39%
21,000
21,000
-
I T Indirect Chgs
505,811
505,811
-
25%
25%
2,023,245
2,023,245
-
Total Revenue
512,061
515,045
2,984
25%
25%
2,048,245
2,048,295
50
Transfers In-General Fund
16,500
16,500
-
25%
25%
66,000
66,000
-
TOTAL RESOURCES
1,041,561
1,182,198
140,637
25%
45%
2,627,245
2,764,948
137,703
REQUIREMENTS:
Exp.
Expenditures
Personal Services
457,041
428,929
28,111
25%
23%
1,828,162
1,828,162
-
Materials and Services
129,521
102,908
26,613
25%
20%
518,085
518,085
-
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
70,225
-
70,225
25%
0%
280,898
-
280,898
TOTAL REQUIREMENTS
656,811
531,837
124,974
25%
20%
2,627,245
2,346,247
280,998
NET (Resources - Requirements) 384,750 650,361 265,611
418,701 418,701
J
IT Reserve - 661
Statement of Financial Operating Data
Three Months Ended September 30, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
$ 304,896 $
340,594 $
35,698
100%
n/a
$ 304,896
$ 340,594 $ 35,698
375
532
157
25%
35%
1,500
1,500 -
58,500
58,500
0
25%
25%
234,000
234,000 -
58,875
59,032
157
25%
25%
235,500
235,500 -
363,771
399,626
35,855
25%
74%
540,396
576,094 35,698
RESOURCES:
Beg. Net Working Capital
Revenues
Interest
IT Reserve Charges
Total Revenue
TOTAL RESOURCES
REQUIREMENTS: Exp.
Expenditures
Materials and Services 27,875 - 27,875 25% 0% b)
Capital Outlay 24,750 - 24,750 25% 0% b)
Res for Future Expenditure 82,474 - 82,474 25% 0%
TOTAL REQUIREMENTS 135,099 - 135,099 25% 0%
NET (Resources - Requirements) 228,672 399,626 170,954
111,500
111,500 -
99,000
99,000 -
329,896
- 329,896
540,396
210,500 329,896
-
365,594 365,594
a) From Solid Waste