2011-2983-Minutes for Meeting July 25,2011 Recorded 8/15/2011COUNTY
NANCYUBLANKENSHIP,F000NTY CLERKS 1~d ~0~~-983
COMMISSIONERS' JOURNAL 08/15/201108:34:49 AM
111111111111111 IN I III 111111111
2011-2083
Do not remove this page from original document.
Deschutes County Clerk
Certificate Page
i
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, JULY 259 2011
Present were Commissioners Tammy Baney, Alan Unger and Anthony DeBone.
Also present were Dave Kanner, County Administrator; and, for a portion of the
meeting, Marty Wynne, Finance; David Inbody, Assistant to the Administrator;
Anna Johnson, Communications; media representative Hillary Borrud of The
Bulletin; and two other citizens.
Chair Baney opened the meeting at 1:30 p.m.
1. Tax/Finance Update.
Marty Wynne explained that the "big 12" budget figures for Fiscal Year 2010-
11 show expenditures that adjust daily. The numbers should not change much
in the next couple of months, however.
Some departments and expenditures came in under budget for the year. A few
were over budget, but not by a huge margin. Some of this can be attributed to
when grant income is received. Due to event cancelations, Fair & Expo costs
were significantly higher than budgeted, but there are future events that will
help make up the difference.
A copy of the finance report is attached for reference.
2. Discussion of Request from Project Connect for Grant Funding.
Dave Inbody said that the Project Connect group missed the deadline for filing
for community grant funds. He reviewed the grants awarded this year; many
got 50% or less of what was requested.
Chair Baney indicated that Project Homeless Connect and Mobile Connect are
doing a lot of good work, including necessary dental care and clothing. Project
Connect funding is used entirely within Deschutes County.
Minutes of Board of Commissioners' Work Session Wednesday, July 25, 2011
Page 1 of 5 Pages
Commissioner Unger stated this is part of the Partnership to End Poverty, and
needs to have support to transition over time. Commissioners Unger and Baney
want to support this work.
The Commissioners agreed to provide $12,000 in funding, with $5,000 for
Homeless Connect and the remainder for Mobile Connect.
3. Discretionary Grants & Grant Application Suggested Changes.
Sunriver Music Festival (Marketing) - $2,500 - each Commissioner granted
$500.
Redmond-Sisters Hospice (Festival of Trees) - $4,000 - Chair Baney said
this is a request for the use of the Expo Center. Dave Inbody said the Board
decided to have each organization ask directly for this kind of funding. Each
Commissioner granted $1,000.
Icon City (Text Initiative) - $5,000 - Mr. Inbody said the Board had asked
for further information on how they are working with other groups, but he
has not received anything in writing. The Commissioners are unclear on
how this process works and want more specifics. Commissioner DeBone
said it is primarily to buy the appropriate software; plus there would be
ongoing expenses for leasing and texting. The Commissioners are
supportive of the concept, but asked for further clarification.
• Nature of Words - $35500 - each Commissioner granted $500.
Humane Society of Redmond (HVAC) - $4,500 - each Commissioner
granted $500.
Deschutes Economic Alliance - $55,000 - Commissioner DeBone said this is
different from the Economic Forecast project. Launae Hunter and Dave
Lewis were invited to speak, at which time they gave an overview of the
work of the group. They have had a lot of community commitment and
there are good things happening. They brought handouts. There have been
ten strategies developed. Mr. Lewis went into great detail regarding the
project and its plans for the future. This will help to bring an individual in as
a trainer and guest speaker.
Minutes of Board of Commissioners' Work Session Wednesday, July 25, 2011
Page 2 of 5 Pages
Commissioner Unger likes the idea of thinking bigger, so change can
happen. He does not want to pay for past work, but for things moving
forward to help bring about economic improvement and jobs. Mr. Lewis
said it is difficult to find good leadership and keep things moving.
Commissioner Unger would like to think this through a big longer.
Commissioner DeBone feels this is the right time for this kind of project.
Chair Baney wants to invest more in the action piece. Commissioner Unger
said much of what was discussed today is not in the application, and he
wants to be able to see more accountability. This will be addressed at a
future meeting.
• Healthy Beginnings (Early Childhood Screenings) - $2,400 - Dave Inbody
said this group has received community grant funds for the past four years,
for about half of their request. The Commissioners granted $500 each.
• Community Support Services (Fair Tickets) - $450 - the Commissioners
will split this amount equally ($150 each).
• Revised Grant Application Form - Mr. Inbody presented a revised form
giving more specifics on the request, and requiring how to measure
outcomes. Commissioner DeBone wants to make sure there is an economic
development side of the request. He wondered why these have to be made
to a nonprofit. Commissioner Unger said it is much harder to maintain
oversight if the funds do not go to a nonprofit. This is public money and
most new companies are not successful. Chair Baney would like these
allocations to be at the discretion of the Board.
4. Update of Commissioners' Meetings and Schedules.
Commissioner Unger said that ONDA (Oregon Natural Desert Association) is
using, in litigation, the language from the Oregon Fish & Wildlife reference
guide. ODF&W said this language was not to be used in litigation. He is
unsure whether this should be referenced in the Comprehensive Plan. Chair
Baney said she was told this is advisory and not for other purposes.
Commissioner Unger stated that he would like to see ODF&W come forward
with a statement that it is for reference and not regulatory in nature, and is not
to be used for litigation purposes.
Minutes of Board of Commissioners' Work Session Wednesday, July 25, 2011
Page 3 of 5 Pages
5. Other Items.
Mr. Kanner said there is technically a vacancy on EBAC. The Sheriff would
like to appoint Marc Mills as a management representative, but wanted to know
if the Board has another preference. There are five management seats in
addition to Risk Management and Personnel.
UNGER: Move that Marc Mills be appointed to EBAC.
DEBONE: Second.
VOTE: LINGER:
DEBONE:
BANEY:
Yes.
Yes.
Chair votes yes.
Mr. Kanner asked if his evaluation would be addressed on August 10 as
planned. The Board said they have been busy with other things so it will be on
August 15 instead.
On July 27, the Board will review the template to be used to gather information,
as previously discussed.
The meeting adjourned at 3:40 p.m., at which time the Board went into
executive session under ORS 192.660(2)(d), labor negotiations; and 660(2)(h),
litigation.
After executive session, the Board indicated they would not hear a certain
appeal but instead have it go to a Hearings Officer; and they are not in a
position to go forward with a building permit without going through the normal
process.
UNGER: Move that the Board deny calling up the application to hear this
case.
DEBONE: Second.
VOTE: UNGER: Yes.
DEBONE: Yes.
BANEY: Chair votes yes.
Minutes of Board of Commissioners' Work Session Wednesday, July 25, 2011
Page 4 of 5 Pages
DEBONE: Move denial of approval of building permit outside of the normal
process set forth by State law.
UNGER: Second.
VOTE: UNGER: Yes.
DEBONE: Yes.
BANEY: Chair votes yes.
Being no further discussion, the meeting adjourned 4:45 p.m.
DATED this l U i Da of 2011 for the
Y
Deschutes County Board of Commissioners.
Tammy Bane y, Chair To'
Anthony DeBone, Vice Chair
ATTEST: 9-&1 U-4- ~
Alan Unger, Commissioner
Recording Secretary
Minutes of Board of Commissioners' Work Session Wednesday, July 25, 2011
Page 5 of 5 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., MONDAY, JULY 25, 2011
1. Tax/Finance Update - Marty Wynne
2. Discussion of Request from Project Connect for Grant Funding
3. Discretionary Grants & Grant Application Suggested Changes - Dave Inbody
• Sunriver Music Festival(Marketing) - $2,500
• Redmond-Sisters Hospice (Festival of Trees) - $4,000
• Icon City (Text Imitative) - $5,000
• Nature of Words - $35,500
Humane Society of Redmond (HVAC) - $4,500
• Deschutes Economic Alliance - $55,000
• Healthy Beginnings (Early Childhood Screenings) - $2,400
• Community Support Services (Fair Tickets) - $450
• Revised Grant Application Form
4. Update of Commissioners' Meetings and Schedules
5. Other Items
• Executive Sessions:
Under ORS 192.660(2)(h), pending or threatened litigation
Under ORS 192.660(2)(d, labor relations
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(2Xd), 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-6572.
Deschutes County meeting locations are wheelchair accessible.
Deschutes County provides reasonable accommodations for persons with disabilities.
For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY.
Please call (541) 388-6571 regarding alternative formats or for further information.
,J 1 4
N
N
N
N
L
v
1I
J
N
E
c
~
J
44
V
Vf
N
L
~r-
•J
Q
~
1 V
u
Q
N,
ai
C
O
~n
M
w
Z
Q
!
CIL
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
July 25, 2011
(1) Monthly Investment Report
(2) June 2011 Financials
A
r
r N
O
' ~
, '
E
IV CV)
P
1
CO
CO
O
o
~
V
s
o
N
~
S.
E
(A
d
0
r
0
r
C
l~
U.
0
0 '
CO
CA
V-
CO
CV
w
U.)
LO
C
3
7
CA
fA
CD
~ r1t
0
P V-
00
O) O
E
LO
r r
0
C
P P
C
d
LL
649,
4 z
A
0
v N
O
_
t»
C C
o
3
c
O
y O U
U
E C
0
m
m
C
«
~ a
i
C
C
O
LL t~A
O to C
0
y
~
C
C
N
` O
c F-
N
U
}I
"I
I 'T M C*
O00Cq 00
i
c; .d CS W) C:;
CID
P
~ I
M M CO
LO
LO CO Cl)
M
Y
CEO N M U')
V
(3) M lA r
CF)
N O) C Si
~
r
Ce; ~
fA
~
Ce j
to
O
Si
C
° ti N N «
~N
C
.1
apm'- gym
U
y
Ca zc
- U)
OU
S
H
4) 'E (0 Q
<
9
6 m L L p
C
E O 0~ W m
E n a> Cj .o c o_
E
O O
0 cO U'
A
O
UUH
LL COJ
0
M
N
CO
FU
C)
C
N
Document Reproduces Poorly
(Archived)
a o 0 0 0 0 0
ooo~n o00
O O I~ N NNP
r r
N N
N
U
3 N N CO a)
i N u ~n ~ m a:
(a C ca a. 0
7 N C1 crV N z
Ca Q Q i
p U N N
y~
N p.
C/j N O E
M N CO O O
U=i J LL CO P U U
_ N
m ~
CL
M M
T
~ Q
F
C
d
N
C
E
a+
N U
o
E
_ h-- CO
>
U
C
T
m
~
O
~ y
o m o
o
ao~
0z^
O
IL
O
~
m
LO
av
J
I
'I
I
I
W
V O
I
U U U
1
U U
I I I I I I
1
U UIU UI UI UIU U'U,U U U U'U U'U n'ca U U
I
m
I N I
7 U, UU O U O
c
'
W
d U d U
m
m
W
o
°
x: p
z'
•2
Z Z
Z12
Z 2 2;2 z Z. Z'Z 2 Z.2 212 2 z zs! Z
Z
O
m
7
~
Z Z
Z v Z
0. 7
z".
2
7X 7~1
la=
OI P
o
o
f.0
O
~ O
C
M.
$
'
I
I
I I I i i
N I
~
I
I
, I,
S M SIS b
S,
818
N N O
N Q O Q
I S'0
t^D, t^O O tOjS Onf CIS <O M
S O
O. O'S.. m,, S.(nO. SIS OIO
U),
OIN
C'I
N
I
l~
N. O
i
ObD W
I
O m g
p fn
In S W
N M LL71 N' 1`
m m
CS
O1
O N
O
O co
(V 01 O O
N n O ~p
t- Ol t0 N
1 01
Q M
1~1 (O
m. I Q N t0 0 ~(pp m
co W Q. N' O , Z;
N ICI Q' N 1~
0 Q N O
o O
S S
01 Oi
0I O7 MI t0
O 8
O00 IO, f~ OND Q b SIN
O, f~
O S
R ,t~
ODD
SO
Q
O
W
h
. N
I W
o~ 071
O
O O
Ql
C2 P
~
tV m Q' O' to
Of M
n n
O
N 0
N I
~p O O b
M v MM
N.
N
.
Q N m' n N f~
I Q NIN I M OD
N b
N N
O' Q tp 0. (4I b O
; ^ O M I M
Q, 0
N N
I
l
g
QI
fn
c
>
G
t V C4 N N N
r
I N, N
O C
N I N
O
N
N O
NI O O OI O X 0
i N N N I C14 cli
O O
N N
O O 000000 Q7 O
Ncq f N N
~ 13
Q I h
o
W
to
Ml 10
W! Q'
m
W
N'
!
I
40
N
O10
O
O OI88
'O
8 O
OHO
OIO
O O' ~Of
OIO
O'
O S
f~O ((pp O O OO
S tO S OO00000
O10
00
O: OI Ojh MAO O'
O M
000f M'OO S O'M
0
O
N
O N
'
I
011 pp
c°R
N
N
!
1
1
O
.
I p. OIL 0
O
S N' S
N
1010
~p
N S
.
OIO
Q m
0 (M
C, N
b
O,G
M
O.. fO
co p 0 0 0 110 0 0 0
tp `I, N ~p ~p O OD ~p
N Ols 0 1w V
co
~
0 0
pp' N
T Q
,
O.O O'(V r O 'C C f"1
O 00 cD' N N o N N Q O
O!I~IM (O. C
Nl~
OD
I
M
fV
O t.
I~
O
I
I
QQ ((pq
1Q
L
A
N
1
>
O
1 0 m C6, f`
' O O O O
I O O' N'S
f+1
810
C71 N
S O
n O
0i b
Q M
S O
Oi
Q:~
N O
I~~
pp
n r O Q S N W O
QOM-
O
iS S
O O
O O S' < O O N
O
O
O
O O
'
N
S
,
1
O
S S b
a O
!
X
A
'NIN N (V N
NIN
(VIN
•
N C4-
c
~
N
O O O O
fV~-NI tV ~tV N NIN
O O
lV[V
O OD
O N
O 1 0
, (V /VIN fVl~ (V,fV'
Ol O
.-N
i0 Cn
Q 1~
pt
Q
!
1
O O 810'0
O
O
O' O
O!O S
• N
O
O
S' SI S101 0'
O O
OI O'i O AS S S
8
O OSS SIS 811 1
S O
O O H O
O O
co
Qi Q
N
1
W
U
~
p
tR O
O
app~pp ~tpp
O Of O
D
,
00
ppop
N O
S S N
IO O
app(pp pp
p
-i
7.
.
,
T~pp pp po pp pp paS
pp
91
8;
.0
.0 N $IO OHO O'
C
O OO
r np~
00
_
C S O O O
O
0o Q
O O O'
,O
O 8 OQOObM, OR
.N
O
^
pp' O O
IN O
Of~0 O tD tD
'f`N O
O g
S O S S
I
0
1u~.
0
O
tO10 O SS O f~ tt~ODD O o
8IS O
Q(~ -0, QW O
O .01 O' 00 W N O' O 1
W I(O
Oi tO fV
Of Of b
tr Of
RI
P'I
1
p
fV N N N
(V N (V NI
tV~
N
N'
tV
tVIN iN N N
: fV N N tV N N Nip 'N N,C41
tV Q n
(D ;V
P'
y
(
'
I
`
coo
'
0
,
l
I
~
U m
"
H1
~
0
pp O O
t'7' N• S~ S.pp
~l
O • O O O 0:0 ' p p O O
0p O OI Imo; ~ ~3. t. S b
US W
1
~ o;~ F
o aE ~
~
b M. W O M N
N to tO M M. pp, g
~,a41~ ~I aQ a41 o'e O o 'a°
po ~f 7 0 0 0 O O' f D O O p W O C-
p b
b N' O N'. b N t0' S OI S 5 ' OO
a°! 1
N
co
mZ
. 2 i y
i
o>'I c
a
a.
m
>
_
N'
4
CD ~ O tO
'o ~•o
tD OR r O m b S O n' b ~ n
'o o!o o'c o!o 10
1;
f0 bI ~I CO to b O' O
0 0 0 0'0 oI~ X
.
b, f0 b' f0 N 10 00 ICI i~1 (O' 00 M' (O v b co
0.0 0 0.. 0'0 0!0010 o of oo d
1
t0
c
N WIN l0
E;
_ y
c
m
a
0'' o' EU)
•
~i w
(7 0
2
I
00 I F' 7
U. m
J 1
O
O+
O C
p~ o
~On S pOp
n M th t0
0'(6 01 '.O
'
R 2R'X ;e' a o e e e op'
p~ o e o ~ ~ o~ p~ aR
[O ~O N N O' nM O Ni0 O'LL"/ ~[1iO S. N O N10
(O 8 9 jS 5. IO I,
c0 1~ 1~ O O t0 O 1 m t0 I~ N ~O b 8 t0I
0, o:C'LOI~ N O.~ •O O.Q b oIGIO O'OODV OIN O O' O~ j .M
1
U
b
I
a
C. 0
I I I; I ~ I 1 I !i !gala
I ~
I'
m
_
'
O
W
2
?
m
O n W' W M M n W fD 00 R b Of W SOD S- MI W n cp O N M' cb M OO b'
(D 'l
lAM R%'nui tn toniti n n n' NO;n n ~ n 1 K r-
n t°oI CD
~ _ I ~ I ! ,
I C N I to ~
cL' li
!f >5
n r~ 40 E
1>.
1mrIC
I
«
` N' N N NOl C4 I ClJ N N N' .N- N 1 N M _M M' M
rn
~
W
M M N C U' ILL 1
!
-i- ~-e-
°
n
g
3
O O N O O
~a ai
o o oloi
r` ~ m ai ,a a3
nl as as A 3 s~ vl o~'rn a
O O 1 0 ~V O O N O O O N LV' O 0 0 0 1 0. O ~l l O ~V
: a .;~~a~ a Oflpal~~
o'o'~ o ol~ o 0!0 !ol o',~i' o a o olo
V
al
N LV'
0 0 ¢'o'o O
N O
OO OOO
~
OOO OIO O'O OO O
0 n al l ` r~l~
O OIO
o rnI~ n a
O.O 0'0
as, 5 a,
00
rn (51 Ea a p~ a
I^
rn'
CL
0 c
0 0 510 0
O '.O O O O
aa
oJ
g
o
o o o
O N O
a 'a 'a a
0 0 0 0 ~1
0
O O O
O
01
O a 5,
~
r- c olo oo
p
N
¢ Q
¢
U
m'-
m
- IL
z'>
L!¢
-
dL z
,
i
.
1
f
.
.
m'm U
i,
.
v xYo1az
,
m'wlrn'°
in
0: Cl t¢L 1.-
lI
< 'ziz o'al
W U'UIF- LL
a a a'z a n
LL LLI LL U LLIF
o 0 o'a
H H L- LL
viola aia o!a a
1-IF- LL LL ILL H W W
z' z'
UI UI
a a
IL LL
a a'z ojo.a a;aa•ol
LL LL'0 LL', W; LL LL I F-,!
alo
LL H
j
'
~uegi
ZI LL LL.CL
ma.~olal
Z Z;LL mIm d' d Ul
viw,3:TITUOm
d Z,
o'U)I
d Z Z 2 LL a 2
alov~rntnXco(n
LL LL
~
Z a
tnm
Za'LL d'aI ZaZ >
aUiUxUUm:Um'cn
2 H''
tntnl
1
1
(
1 1
p
~m t01 b
JI
Z
~tpp
u'i tr r u7~
F a a, ZI
~m Nd
M
N'
D
Y
- IW .r M. '
w.} C7 'rn
iI1X C7
W•'OD
p,Y
aIM
n
QO
m.>
too b
a
O O Q bICO'M', U.
a Z U LL -x Y
~ C90 I mI
LL
m
1
l
~
z
V
Qi
f` M 'f l O' OQ~Qf I • M
InO W
' X' f`
'f Opi
(
j.
M
N t+Mj i S I W
P7. tyhl M1
31
X
tM+I
M
X' ~ cc
M UQ ' M
W
S M
`tai M_: M
!`')Mlth M lI
I N
M
pp ~Otppf
t°Qi c0
a6 a
D
01'. O
M 1 M
(7'p1
M
M M j ~~Om~((pppppf m O] t+Mj
;n !`'1
M C7
m
MI.
y.,
,
i t
12 UI.
_
U U U a
U
V N C
ca
~
~I tp
' m
C
cl
.
U
I ~I ;U U
Q« InUll W IUI
•U
~
j m
I?
~Im y
I~
Q4
dIV d'
W
U
r Y
C V li N
d ml 0I V
O
1UIV IU C N C'
t0 I x
l
C
N
m
E
I
ImNU 00
N
'
NIN
y, m
t71Y
U)' C
N
: U
00
U
d O' C d
z! N
9 ac
C
m
zv
U
IY Om l9
ml
`m.t~_
,
U y 0I m m
. w
';9cUc y:c
m N. N NIW N
~a mtm m, v
to ~.I N1m~~.m N
0 umm ti' ro
'.m
Y c m t _aallll
yV vi 0 1
d N N CO: h
v x.
I~w W N.A .
'W A
Im
c
m
to
I
a
o
y
C
NI
co
$Io~
LL
o
Y~EN
Imo E
.
C N
wo.o
m m UU~2
Cm'3'o
N N
m
m E
~N N U
N cm
Yaa~
;A ~
a7 7
i cy
i5 yi°1
N o E
rn'rnmo
Z,
~
h
N
Y
w c
~ m m
a
wma~ilm
m Ui N
E0I
E°'N'N~-
o
i1ElU)
o U'ULLF-
o
-
W
m LLI 7.
m 14 am
V1
U
V
~
~
Q" N. U ~I
m, m~ilm O ysC am m.m 2
J' OJJ U J EII
T
U J U
LL.
;N
ml mlt
m N m m N 4) E
a aI Hn
I U :1 C
! J
C' E 3
I
7
C
`I
F
z y
w ~G
'
,
>
C
I
N .
LL j E-LL
C
i
LL I= LL I OZ O E' N
E =I d E= ILL S 012 LL j OI N
> -
I
'.U
U U
LL LLNO OLL 'OS
'
zz
'
U
G
.
LLZ) U.
LL LL LL U D m
LL
D LL CL U. LL LL 2U. w U
LL LL C7 S U LL CL LL LL
N
,
U
'
J
m
Memorandum
Date: July 20, 2011
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find June 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
GENERALFUND
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll.
%
RESOURCES:
Beg. Net Working Capital
$ 8,300,000
$ 9,677,699
$ 1,377,699
100%
117%
Revenues
Property Taxes
20,566,000
21,419,761
853,761
100%
104%
Gen. Rev. - excl. Taxes
2,397,138
2,491,745
94,607
100%
104%
Assessor
795,690
826,610
30,920
100%
104%
County Clerk
1,220,714
1,507,272
286,558
100%
123%
BOPTA
12,398
13,077
679
100%
105%
District Attorney
314,100
209,868
(104,232)
100%
67%
Finance/Tax
180,200
198,257
18,057
100%
110%
Veterans
67,866
67,544
(322)
100%
100%
Property Management
91,132
96,146
5,014
100%
106%
Grant Projects
2,000
2,000
-
100%
100%
Total Revenues
25,647,238
26,832,280
1,185,042
100%
105%
TOTAL RESOURCES
33,947,238
36,509,979
2,562,741
100%
108%
REQUIREMENTS: Exp.
Expenditures
Assessor
3,382,219
3,244,647
137,572
100%
96%
County Clerk
1,484,127
1,313,225
170,902
100%
88%
BOPTA
75,403
66,610
8,793
100%
88%
District Attorney
4,882,127
4,773,245
108,882
100%
98%
Finance/Tax
856,910
815,991
40,919
100%
95%
Veterans
274,837
265,442
9,395
100%
97%
Property Management
261,227
254,471
6,756
100%
97%
Grant Projects
117,203
114,967
2,236
100%
98%
Non-Departmental
2,293,337
1,836,466
456,871
100%
80%
Contingency
1,252,046
-
1,252,046
100%
n/a
14,879,436
12,685,066
2,194,370
100%
85%
Transfers Out
15,737,164
15,727,164
10,000
100%
100%
TOTAL REQUIREMENTS
30,616,600
28,412,230
2,204,370
100%
93%
NET (Resources - Requirements)
3,330,638
8,097,750
4,767,112
a)
Beginning NWC per Adopted
Budget
7,300,000
a) Appropriation transferred to Fund 575 - $610,000, to Fund 601 - $14,000, Fund 150 $300,000,
Fund 458 $580,138, Fund 142 $1,500,000, Funds 160/170 $326,500,
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ 987,000
$ 1,039,997
$ 52,997
100%
105%
Revenues
Federal Grants
15,527
12,135
(3,392)
100%
78%
a)
SB #1065-Court Assess.
60,000
53,697
(6,303)
100%
89%
b)
Discovery Fee
16,000
12,441
(3,559)
100%
78%
b)
Food Subsidy
38,000
27,583
(10,417)
100%
73%
b)
OYA Basic & Diversion
340,006
182,135
(157,871)
100%
54%
c)
Inmate/Prisoner Housing
100,000
75,300
(24,700)
100%
75%
d)
Inmate Commissary Fees
100
154
54
100%
154%
Contract Payments
88,490
88,350
(140)
100%
100%
Miscellaneous
300
70
(230)
100%
23%
MIP Diversion Fees
1,000
295
(705)
100%
30%
b)
Interest on Investments
17,000
8,009
(8,991)
100%
47%
Leases
2,400
2,400
-
100%
100%
Grants - Private
500
1,697
1,197
100%
339%
Behavioral Health
6,000
3,319
(2,681)
100%
55%
b)
CCF Interfund Grant
60,495
72,375
11,880
100%
120%
e)
Gen Fund Grant-Crime Prev.
20,000
15,000
(5,000)
100%
75%
Total Revenues
765,818
554,961
(210,857)
100%
72%
Transfers In-General Fund
5,543,186
5,543,186
-
100%
100%
TOTAL RESOURCES
7,296,004
7,138,144
(157,860)
100%
98%
REQUIREMENTS:
Exp.
Expenditures
Community Justice-Juvenile
Personal Services
2,963,956
2,746,604
217,352
100%
93%
f)
Materials and Services
1,199,886
1,077,777
122,109
100%
90%
g)
Capital Outlay
100
-
100
100%
0%
Juvenile Resource Center
Personal Services
2,315,104
2,147,293
167,811
100%
93%
h)
Materials and Services
175,494
175,880
(386)
100%
100%
Contingency
641,464
-
641,464
100%
n/a
TOTAL REQUIREMENTS
7,296,004
6,147,554
1,148,450
100%
84%
NET (Resources - Requirements)
-
990,590
990,590
Beginning NWC per Adopted
Budget
1,101,374
a) Fourth quarter Federal Grant reimbursement of $3,000 is expected in June
b) Revenues trending less than projected due to reduction in use of services and lower juvenile populations
c) OYA monies collected in Nov, Feb, May, and June - New reduction due to under-utilization of Maplestar treatment foster care -
(population of kids in Maplestar less than anticipated in the original budget). Approximately $75,000 payment anticipated in June
d) Revenue is generated when non-Deschutes juveniles utilize facility - less utilization than anticipated to date
e) Additional funding from CCF allocated for Juvenile programs
f) Personnel savings due to approximately 3.00 FTE unfilled
g) DHS/BRS match payments and Maplestar contract payments are less than originally budgeted due to reduction
in youth using the program
h) Personnel savings due to less on-call and overtime for the detention facility
SHERIFF - Fund 255
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY % Coll. %
RESOURCES:
Beg. Net Working Capital
$ -
$ -
$ -
100% n/a
Revenues
Law Enf Dist Countywide
22,829,457
18,138,940
(4,690,517)
100% 79%
i
_Law Enf Dist Rural
13,665,939
11,428,545
(2,237,394)
100% 84%
Total Revenues
36,495,396
29,567,485
(6,927,911)
100% 81%
TOTAL RESOURCES
36,495,396
29,567,485
(6,927,911)
100%
81%
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFERS
Sheriffs Division
3,077,051
2,959,895
117,156
100%
96%
a)
Civil
822,436
780,646
41,790
100%
95%
b)
Automotive/Communications
1,653,036
1,514,404
138,632
100%
92%
c)
Investigations/Evidence
1,650,792
1,482,795
167,997
100%
90%
b)
Patrol/Civil/Comm Supp
8,015,651
7,729,134
286,517
100%
96%
b)
Records
660,386
622,378
38,008
100%
94%
b)
Adult Jail
9,854,864
8,882,472
972,392
100%
90%
d)
Court Security
280,851
272,025
8,826
100%
97%
Emergency Services
179,441
169,801
9,640
100%
95%
Special Services Division
1,298,604
1,154,169
144,435
100%
89%
Regional Work Center
2,892,242
2,660,758
231,484
100%
92%
e)
Training Division
330,000
261,945
68,055
100%
79%
f)
Other Law Enforcement Svcs
611,917
594,044
17,873
100%
97%
Non-Departmental
283,018
283,018
-
100%
100%
Contingency
4,685,107
-
4,685,107
100%
n/a
Transfer Out - Jail Remodel
100,000
100,000
-
100%
n/a
Transfers Out - D/S Fund
100,000
100,000
-
100%
100%
TOTAL REQUIREMENTS 36,495,396 29,567,485 6,927,911 100% 81%
NET (Resources - Requirements) _ _ -
Beginning NWC per Adopted Budget -
a) Less than planned M&S expenses for the year
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Expenditures grant funded consulting contract will be made in FY 2012
d) Unfilled budgeted positions and no planned jail bed rental. $350,000 for JMS software
will be expended in FY 2012
e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
f) Personnel expenses will be lower than planned due to employee transfers
Fund 701 LED-Countywide
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 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
Rentals
Donations
Sale of Reportable Assets
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Department
Sheriffs Services
Civil
Auto/Comm
Adult Jail
Court Security
Emer Svcs
Special Services
Work Center
Training
Other (CODE, Forensic)
Internal Services
Transfer to Debt Service
Transfer to Jail Remodel
Transfer for Reserve Fund
Contingency
TOTAL REQUIRMENTS
Budget Actual Variance FY % Coll.
$4,722,862 $ 5,609,156 $ 886,294
14, 853, 594 15, 003,874 150,280
100%
100%
100%
100%
100%
100%
100'%
100'%
100'%
100%
100"/0
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
100%
119%
101%
124%
139%
150%
66%
94%
100%
100%
n/a
103%
12%
n/a
157%
199%
69%
156%
144%
n/a
159%
411%
161%
177%
52%
n/a
nla
n/a
102%
642,000
795,339
153,339
35,000
48,563
13,563
48,475
72,573
24,098
5,000
3,321
(1,679)
1,974,660
1,854,463
(120,197)
5,000
5,000
-
95,000
94,855
(145)
-
4,994
4,994
150,000
154,996
4,996
4,000
487
(3,513)
-
5,280
5,280
48,000
75,217
27,217
25,000
49,725
24,725
6,000
4,125
(1,875)
5,000
7,800
2,800
5,000
7,187
2,187
-
14,750
14,750
12,000
19,094
7,094
1,000
4,114
3,114
160,000
257,255
97,255
28,333
50,285
21,952
3,533
1,837
(1,696)
-
2,500
2,500
-
200
200
-
1,257
1,257
18,106,595
18,544,506
437,911
22,829,457 24,153,662 1,324,205
2,910,890
2,800,061
110,830
822,436
780,646
41,790
595,093
545,186
49,907
9,854,864
8,882,472
972,392
280,851
272,025
8,826
179,441
169,801
9,640
1,049,272
932,569
116,703
2,892,242
2,660,758
231,484
201,300
159,787
41,513
611,917
594,044
17,873
41,592
141,792
(100,200)
100,000
100,000
-
100,000
100,000
-
100,000
-
100,000
3,089,559
-
3,089,559
22,829,457 18,139,140 4,690,316
Net - 6,014,522 6,014,522
Beginning NWC per Adopted Budget 5,108,671
a) Timing of reimbursements for the Emergency Planning Grant
b) Funding reduction from Dept of Corrections
c) Higher than planned inmate telephone use and commissary purchases
d) Work Crew revenue from USFS was not planned
e) Unplanned revenue for the "Children of Incarcerated Parents" program
f) Revenue for concealed weapons permits and civil papers will exceed budget
100% 106%
E
xp.
F _77
100% 96%
100% 95%
100% 92%
100% 90%
100% 97%
100% 95%
100% 89%
100% 92%
100% 79%
100% 97%
100% 341%
100% 100%
100% 100%
100% 0%
100% 0%
79%
Fund 702 LED Rural
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$1,905,939
$ 2,498,487
$ 592,548
100%
131%
Revenues
Tax Revenues - Current
7,508,247
7,555,396
47,149
100%
101%
Tax Revenues - Prior
314,000
394,765
80,765
100%
126%
Federal Grants
2,000
13,326
11,326
100%
666%
Federal Grants-BLM
-
9,597
9,597
100%
n/a
US Forest Service
76,500
64,125
(12,375)
100%
84%
State Grant
187,633
89,238
(98,395)
100%
48%
SB #1065 Court Assessm(
67,000
53,697
(13,303)
100%
80%
Marine Board License Fee
142,433
49,842
(92,591)
100%
35%
Des Cty General Fund Grz
702,358
514,358
(188,000)
100%
73%
Des Cty Transient Room T
1,947,642
2,135,642
188,000
100%
110%
City of Sisters
432,655
432,655
-
100%
100%
Des Cty Tax/Fin Contract
1,000
-
(1,000)
100%
0%
Des Cty CDD Contract
54,366
54,366
-
100%
100%
Des Cty Solid Waste Cont,
54,366
54,366
-
100%
100%
Des Cry Clerk/Election
2,000
1,249
(751)
100%
62%
School Districts
100,000
41,549
(58,451)
100%
42%
Claims Reimbursement
-
8,472
8,472
100%
n/a
Security & Traffic Reimb
13,000
5,961
(7,039)
100%
46%
Seat Belt Program
6,000
7,025
1,025
100%
117%
Miscellaneous
10,000
9,671
(329)
100%
97%
Restitution
500
1,058
558
100%
212%
Sheriff Fees
10,000
10,048
48
100%
100%
Court Fines & Fees
85,000
131,817
46,817
100%
155%
Impound Fees
15,000
6,000
(9,000)
100%
40%
Restitution - Street Crimes
500
-
(500)
100%
0%
Interest
10,000
20,201
10,201
100%
202%
Interest on Unsegregated
1,800
924
(876)
100%
51%
Donations
-
12,250
12,250
100%
n/a
Sale of Reportable Assets
10,000
32,762
22,762
100%
328%
Sale of Equip & Material
6,000
3,570
(2,430)
100%
60%
Total Revenues
11,760,000
11,713,932
(46,068)
50%
100%
TOTAL RESOURCES
13,665,939
14,212,419
546,480
50%
104%
REQUIREMENTS:
Exp.
Department
Sheriffs Services
166,161
159,834
6,326
100%
96%
Auto/Comm
1,057,943
969,219
88,724
100%
92%
Investigations
1,650,792
1,482,795
167,997
100%
90%
Patrol
8,015,651
7,729,134
286,517
100%
96%
Records
660,386
622,378
38,008
100%
94%
Special Services
249,332
221,601
27,731
100%
89%
Training
128,700
102,159
26,541
100%
79%
Internal Services
41,426
141,226
-
100%
341%
Transfer for Reserve Fund
100,000
-
100,000
100%
0%
Contingency
1,595,548
-
1,595,548
100%
0%
[TOTAL-REQIJIRMENTS 13;665,939 11;428,345 ' 2,237594 84%
Net - 2,784,074 2,784,074
Beginning NWC per Adopted Budget 2,936,523
a) Detective overtime reimbursements from HIDTA
b) Contract increased for purchase of new boat. Payments will be received in Qtr 4
c) Grant will be received in June 2011
d) Less than planned revenue due to lower billing rates and hours worked
e) Revenue from traffic fines will exceed budget
f) Animal Rescue Facility donations
g) Proceeds from sale of used patrol vehicles were higher than estimated
PUBLIC HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual I
Variance I
FY % I
Coll.
RESOURCES:
Beg. Net Working Capital
$1,100,000
$ 1,615,306
$ 515,306
100%
147%
Revenues
Medicare Reimbursement
8,000
147
(7,853)
100%
2%
State Grant
2,512,977
2,427,905
(85,072)
100%
97%
Child Dev & Rehab Center
30,759
30,759
(0)
100%
100%
State Miscellaneous
219,896
250,248
30,352
100%
114%
OMAP
477,800
628,876
151,076
100%
132%
Title 19
-
927
927
100%
n/a
Family Planning Exp Proj
495,000
467,649
(27,351)
100%
94%
Local Grants
65,000
115,839
50,839
100%
178%
Water Program-Base Fee
42,000
37,544
(4,456)
100%
89%
Water Program-Field Work
55,817
49,840
(5,977)
100%
89%
H2O Sys Insp-Priv Wells
200
-
(200)
100%
0%
Miscellaneous
-
386
386
100%
n/a
Patient Insurance Fees
190,260
131,128
(59,132)
100%
69%
Health Dept/Patient Fees
148,975
111,975
(37,000)
100%
75%
Vital Records-Birth
36,000
33,425
(2,575)
100%
93%
Vital Records-Death
98,000
104,725
6,725
100%
107%
Environmental Health
687,350
738,893
51,543
100%
107%
Interest on Investments
16,900
11,213
(5,687)
100%
66%
Donations
6,000
32,582
26,582
100%
543%
Interfund Contract
189,378
72,661
(116,717)
100%
38%
Administrative Fee
27,000
27,000
-
100%
100%
Drug Court Byrne
-
4,157
4,157
100%
n/a
Total Revenues
5,307,312
5,277,878
(29,434)
100%
99%
Transfers In-General Fund
2,317,765
2,317,765
- 100%
100%
Transfers In-PH Res Fund
67,123
67,123
- 100%
100%
Transfers In-Gen. Fund Other
67,812
67,812
- 100%
100%
TOTAL RESOURCES
8,860,012
9,345,885
485,873 100%
105%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
Exp.
5,857,162
5,778,024
79,138
100%
99%
2,037,387
2,064,780
(27,393)
100%
103%
25,000
5,432
19,568
100%
22%
150,000
150,000
-
100%
100%
790,463
-
790,463
100%
n/a
8,860,012 7,998,237 861,775 100% 90%
a)
b)
C)
C)
d)
NET (Resources - Requirements) - 1,347,647 1,347,647
Beginning NWC per Adopted Budget 1,596,918
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
ABHA
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Seizure/Forfeiture
Interest on Investments
Rentals
Interfund Contract-Gen. Fund
Comm. on Children & Fam
Administrative Fee
Total Revenues
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Year to Date
Budget Actual Variance FY % Coll.
$ 2,616,050 $ 2,651,262 $ 35,212 100% 101%
5,500
5,245
(255)
100%
95%
130,000
143,501
13,501
100%
110%
1,000
45
(955)
100%
5%
96,969
232,483
135,514
100%
240%
a)
6,567,212
6,491,699
(75,513)
100%
99%
b)
148,173
113,787
(34,386)
100%
77%
-
99,685
99,685
100%
n/a
300,925
206,789
(94,136)
100%
69%
105,400
114,531
9,131
100%
109%
70,000
81,540
11,540
100%
116%
16,900
37,254
20,354
100%
220%
154,000
85,392
(68,608)
100%
55%
13,000
2,252
(10,748)
100%
17%
-
14,841
14,841
100%
n/a
43,585
22,703
(20,882)
100%
52%
13,100
16,500
3,400
100%
126%
127,000
118,217
(8,783)
100%
93%
a)
24,000
-
(24,000)
100%
0%
c)
4,211,457
4,207,255
(4,202)
100%
100%
12,028,221
11,993,717
(34,505)
100%
100%
Transfers In-General Fund
1,316,158
1,316,158
- 100%
100%
Transfers In-OHP-CDO
100,000
100,000
- 100%
100%
Transfers In-Acute Care Svcs
365,657
365,657
- 100%
100%
Transfers In-ABHA
668,252
668,252
- 100%
100%
TOTAL RESOURCES 17,094,338 17,095,046 708 100% 100%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp.
9,337,153
8,974,295
362,858
100%
96% d)
5,276,251
4,699,487
576,764
100%
89%
766,000
215,540
550,460
100%
28%
157,164
150,000
7,164
100%
95%
1,557,770
-
1,557,770
100%
n/a
17,094,338 14,039,321 3,055,017 100% 82%
3,055,724 3,055,724
Beginning NWC per Adopted Budget 3,268,759
a) Received quarterly, in arrears
b) Department of Human Services Grant projected at amended contract amount for FY 11
c) Child and Family prevention program eliminated
d) Personnel expenditure projected to be less than budgeted due to unfilled positions
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Admin-Operations
Admir-GIS
Admin-Code Enforcement
Building Safety
Electrical
Contract Services
Env Health-On Site Prog
Planning-Current
Planning-Long Range
Budget Actual Variance FY % Coll.
$ 686,081 613,031 $ (73,050) 100% 89%
16,500
17,442
942
100%
106%
2,750
4,384
1,634
100%
159%
161,718
170,597
8,879
100%
105%
1,081,217
984,748
(96,469)
100%
91%
266,652
253,420
(13,232)
100%
95%
184,000
147,811
(36,189)
100%
80%
283,830
274,473
(9,357)
100%
97%
776,962
709,269
(67,693)
100%
91%
353,771
343,501
(10,270)
100%
97%
Total Revenues
3,127,400
2,905,645
(221,755) 100%
93%
Trans In-GF
253,387
253,387
- 100%
100%
Trans In-GF for Lng Rng Ping
516,000
516,000
- 100%
100%
TOTAL RESOURCES
4,582,868
4,288,063
(294,805) 100%
94%
REQUIREMENTS: Exp.
EXPENDITURES & TRANSFERS
Admin-Operations
1,402,396
1,381,821
20,575
100%
99%
Admin-GIS
216,135
171,230
44,905
100%
79%
Admin-Code Enforcement
184,732
185,538
(806)
100%
100%
Building Safety
500,330
492,560
7,770
100%
98%
Electrical
187,606
180,632
6,974
100%
96%
Contract Services
244,251
223,681
20,570
100%
92%
Env Health-On Site Pgm
232,006
211,617
20,389
100%
91%
Planning-Current
690,290
637,696
52,594
100%
92%
Planning-Long Range
492,427
497,630
(5,203)
100%
101%
Transfers Out (D/S Fund)
173,310
173,310
-
100%
100%
Contingency
259,385
-
259,385
100%
n/a
TOTAL REQUIREMENTS
4,582,868
4,155,715
427,153
100%
91%
NET (Resources - Requirements) - 132,348 132,348
Beginning NWC per Adopted Budget 229,822
Revenues 2,905,645
Expenditures 4,155,715
Net from Operations (1,250,070)
a)
b)
C)
d)
e)
f)
g)
g)
h)
i)
D
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) Projections reduced, as at least one major project (La Pine Biomass plant) has been delayed,
but is expected to occur in FY 2012.
c) City of Redmond receipts lag one month behind
d) YTD business volume/revenue projected to be less than estimated
e) Grant payments received irregularly
f) Savings due to resignation of CDD webmaster, who will not be replaced
g) Savings due to retirement of Building Inspector in January, who will not be replaced
h) Savings due to retirement of EH Director, who will be replaced by an EH Specialist III
i) Savings due to lower expenses associated with Hearings Officer, mailings, etc.
j) Consultant expenditure higher than budgeted associated with timing of grant revenue received in FY 2010
ROAD
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
C o I 1.
RESOURCES:
Beg. Net Working Capital
$ 3,430,429
$ 3,419,603
$ (10,826)
1oo%
1oo%
Revenues
Mineral Lease Royalties
20,000
153,454
133,454
100%
767%
Forest Receipts
2,237,000
2,237,091
91
100%
100%
a)
State Miscellaneous
96,984
-
(96,984)
100%
0%
b)
Motor Vehicle Revenue
10,000,000
9,043,509
(956,491)
100%
90%
c)
City of Bend
275,000
322,324
47,324
100%
117%
d)
City of Redmond
350,000
250,458
(99,542)
100%
72%
d)
City of Sisters
10,000
-
(10,000)
100%
0%
d)
City of La Pine
10,000
-
(10,000)
100%
0%
d)
Admin Recovery (SDC)
-
2,810
2,810
100%
n/a
Miscellaneous
90,000
31,695
(58,305)
100%
35%
Road Vacations
1,000
1,000
-
100%
100%
Interest on Investments
40,000
22,699
(17,301)
100%
57%
Other Bank/LGIP Interest
-
61
61
1oo%
n/a
Parking Fees
900
-
(900)
100%
0%
Grants-Private
-
2,434
2,434
100%
n/a
Interfund Contract
750,000
(750,000)
100%
0%
e)
Equipment Repairs
250,000
235,980
(14,020)
100%
94%
Vehicle Repairs
90,000
72,180
(17,820)
100%
80%
LID Construction
10,000
-
(10,000)
100%
0%
e)
Vegetation Management
35,000
-
(35,000)
100%
0%
e)
Forester
25,000
-
(25,000)
100%
0%
e)
Car Washes
3,000
4,496
1,496
100%
150%
Car Rental
500
948
448
100%
190%
Sale of Equip, Mat & Svcs
202,500
216,215
13,715
100%
107%
Interfund Fuel, etc.
401,000
549,736
148,736
100%
137%
Total Revenues
14,897,884
13,147,089
(1,750,795)
1oo%
88%
Trans In - Solid Waste
291,740
291,740 - 100% 100%
Trans In - Transp SDC
200,000
200,000 - 100% 100%
Trans In-Road Imp Res
12,040
- (12,040) 100% 0%
TOTAL RESOURCES
18,832,093
17,058,432 (1,773,661) 100% 100%
REQUIREMENTS:
Exp.
Expenditures
Personal Services
5,752,967
5,571,742
181,225
1oo%
97%
Materials and Services
9,471,023
8,498,939
972,084
100%
9o%
Capital Outlay
1,171,691
91,180
1,080,511
100%
8% f)
Transfers Out
400,000
400,000
-
100%
100%
Contingency
2,036,412
-
2,036,412
100%
n/a
TOTAL REQUIREMENTS
18,832,093
14,561,860
4,270,233
100%
77%
NET (Resources - Requirements)
-
2,496,572
2,496,572
Beginning NWC per Adopted
Budget
2,834,720
a) Annual payment-January 2011
b) Received in June 2010
c) Even though gas taxes increased by 25% ($.06/gal.) effective January 2011 (revised State estimate);
gas tax receipts will be less than estimated
d) Billed upon completion of work
e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
f) Budget includes $1,076,691 for 19th Street construction. Will be expended in future years
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ 616,371
$ 728,649
$ 112,278
100%
118%
Revenues
DOC Measure 57
217,305
217,350
45
100%
100%
State Miscellaneous
4,301
4,301
-
100%
100%
Alternate Incarceration
30,918
30,918
-
100%
100%
State Subsidy
13,000
13,306
306
100%
102%
SB 1145
2,961,990
2,781,694
(180,296)
100%
94%
Probation Work Crew Fees
38,000
24,792
(13,209)
100%
65%
a)
Miscellaneous
3,000
4,321
1,321
100%
144%
b)
Electronic Monitoring Fee
170,000
158,186
(11,814)
100%
93%
Probation Superv. Fees
210,000
203,591
(6,409)
100%
97%
Interest on Investments
9,000
8,314
(686)
100%
92%
Interfund - Sheriff
50,000
50,000
-
100%
100%
Crime Prevention Grant
50,000
37,500
(12,500)
100%
75%
c)
CFC-Domestic Violence
-
37,416
37,416
100%
n/a
d)
Total Revenues
3,757,514
3,571,689
(185,825)
100%
95%
Transfers In-General Fund 115,029 115,029 - 100% 100%
TOTAL RESOURCES 4,488,914 4,415,367 (73,547) 100% 98%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Exp.
3,173,257 2,973,970
199,287 100% 94% e)
894,274 834,424
59,850 100% 93% f)
100 -
100 100% 0%
421,283 -
421,283 100% n/a
4,488,914 3,808,393 680,521 100% 85%
NET (Resources - Requirements) - 606,974 606,974
Beginning NWC per Adopted Budget 560,000
a) Increase in fee waivers from court due to economic conditions
b) Larger number of offenders doing out of state and county transfers
c) Payments received quarterly (Sept, Dec, Mar and June)
d) Intensive Supervision DV grant (Federal grant)
e) Personnel expenditure projected to be less than budgeted due to unfilled positions
f) M57 treatment funds have been used less based on current population
COMM ON CHILDREN & FAMILIES
Stateme
nt of Financial Operating Data
Year Ended June 30, 2011
Prel
iminary as of J
uly 15, 2011
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ 562,762
$ 635,340
$ 72,578
100%
113%
Revenues
Federal Grants
400,167
355,788
(44,379)
100%
89%
a)
Title IV - Family Sup/Pres
63,750
61,870
(1,880)
100%
97%
HealthyStart Medicaid
95,000
71,972
(23,028)
100%
76%
Level 7 Services
257,984
239,237
(18,747)
100%
93%
State Prevention Funds
14,500
7,532
(6,968)
100%
52%
b)
HealthyStart /R-S-G
308,924
263,596
(45,328)
100%
85%
c)
OCCF Grant
604,323
542,003
(62,320)
100%
90%
c)
Charges for Svcs-Misc
8,000
3,597
(4,403)
100%
45%
d)
Court Fines & Fees
75,000
86,101
11,101
100%
115%
e)
Interest on Investments
20,000
5,044
(14,956)
100%
25%
f)
Grants-Private
5,000
-
(5,000)
100%
0%
g)
Donations
-
4,357
4,357
100%
n/a
d)
Video Lottery
-
2,500
2,500
100%
n/a
d)
Miscellaneous
258,554
124,850
(133,704)
100%
48%
h)
Total Revenues
2,111,202
1,768,447
(342,755)
100%
84%
Trans from General Fund
284,333
284,333
-
100%
100%
Trans from GF-Other
25,000
25,000
-
100%
100%
Total Transfers In
309,333
309,333
-
100%
100%
TOTAL RESOURCES
2,983,297
2,713,120
(270,177)
100%
91%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Exp.
599,559 544,038
55,521
100% 91% i)
1,975,084 1,469,934
505,150
100% 74% c)
100 -
100
100% 0%
408,554 -
408,554
100% n/a
2,983,297 2,013,972 969,325 100% 68%
NET (Resources - Requirements) - 699,148 699,148
Beginning NWC per Adopted Budget 467,111
a) Federal grants adjusted to projected actual
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $9,924 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Community donations received for "Week of the Young Child" & building partner reimbursements adjusted to actual
e) Mary's Place court fines greater than projected
f) Interest revenue projected to be less than budgeted
g) Youth conference donations will not be received
h) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
i) Personnel costs will be less than budgeted due to open positions-increased due to .50 FTE working additional hours
SOLID WASTE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
I Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital
$ 392,509 $
318,001
$ (74,508)
100%
81%
Revenues
Miscellaneous
28,000
22,269
(5,731)
100%
80%
Refunds/Reimbursements
-
15
15
100%
n/a
Franchise 3% Fees
200,000
209,430
9,430
100%
105%
Commercial Disp. Fees
840,000
859,359
19,359
100%
102%
Private Disposal Fees
1,314,000
1,321,254
7,254
100%
101%
Franchise Disposal Fees
3,659,000
3,891,476
232,476
100%
106%
Yard Debris
73,000
85,014
12,014
100%
116%
Special Waste
25,000
41,919
16,919
100%
168%
a)
Interest
12,500
8,668
(3,832)
100%
69%
Leases
-
1
1
100%
n/a
Sale of Carbon Credits
80,000
-
(80,000)
100%
0%
b)
Donations
-
3,240
3,240
100%
n/a
Sale of Equip & Material
-
100
100
100%
n/a
c)
Recyclables
20,000
51,992
31,992
100%
260%
d)
Total Revenues
6,251,500
6,494,736
243,236
100%
104%
TOTAL RESOURCES
6,644,009
6,812,737
168,728
100%
103%
REQUIREMENTS
Exp.
Expenditures
Personal Services
1,634,618
1,626,788
7,830
100%
100%
Materials and Services
2,865,829
2,606,625
259,204
100%
91% e)
Debt Service
970,066
970,066
0
100%
100%
Capital Outlay
148,000
127,332
20,668
100%
86% f)
Transfers Out-Road
291,740
291,740
-
100%
100%
Contingency
733,756
-
733,756
100%
n/a
TOTAL REQUIREMENTS
6,644,009
5,622,551
1,021,458
100%
85%
NET (Resources -Requirements) - 1,190,186 1,190,186
Beginning NWC per Adopted Budget 1,092,508
a) Bonneville Power did large clean-up of contaminated soil-unexpected revenue
b) No market at this time. Not expected to market this fiscal year
c) Minor revenue for sale of gate remotes
d) Markets for recyclables varies throughout the year - usually declines during Winter
e) Larger expenditures (i.e. grinding at $75,000) will be made in Spring
f) Software purchase in process; also, $30,000 from contingency needed for
safety covers for Knott Transfer Trailer Bays
RISK MANAGEMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 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
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
Professional Service
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Budget Actual Variance % of FY % Coll.
$2,500,000 $2,374,541 ($125,460)
335,833 335,833
294,019 294,019
182,710 182,710
906,361
905,974
(387)
170,437
172,348
1,911
30,000
-
(30,000)
20,000
28,481
8,481
1,500
2,115
615
2,000
-
(2,000)
22,000
15,818
(6,182)
30,000
15,685
(14,315)
1,994,860
1,952,983
(41,877)
4,494,860 4,327,523 (167,337)
62,818
104,314
7,935
155,221
726
250
400,000 331,264 68,736
150,075
14,790
300,000 164,865 135,135
1,964
390
15,244
81,860
120,000 99,457 20,543
100% 95%
100% 100%
100% 100%
100% 100%
100% 100%
100% 101%
100% 0%
100% 142%
100% 141%
100% 0%
100% 72%
100% 52%
100% 98%
100% 96%
Exp.
100% 83%
100% 55%
100% 83%
632,866
6,250
112,172
57,803
44,275
650,000 853,366 (203,366) 100% 131%
350,000 267,377 82,623
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Contingency
TOTAL REQUIREMENTS
NET
1,820,000 1,716,329 103,671
291,953 291,027
926
228,834 186,635
42,199
100 -
100
520,887 477,663
43,224
2,153,973 - 2,153,973
4,494,860 2,193,992 2,300,868
- 2,133,531 2,133,531
100% 76%
100% 94%
100% 100%
100% 82%
100% 0%
100% 92%
100% n/a
100% 49%
Beginning NWC per Adopted Budget 2,100,000
DESCHUTES COUNTY 911
Statement of Financial Operating Data -
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget Actual Variance % of FY % Coll.
RESOURCES:
Beg. Net Working Capital
$ 5,861,335 $
6,691,945 $
830,610
100%
114%
Revenues
Property Taxes - Current
6,357,621
6,272,640
(84,981)
100%
99%
Property Taxes - Prior
138,000
293,583
155,583
100%
213%
Federal Grants
474,000
265,193
(208,807)
100%
56%
a)
State Reimbursement
10,000
22,193
12,193
100%
222%
b)
Telephone User Tax
550,000
642,765
92,765
100%
117%
c)
Data Network Reimb.
12,000
26,672
14,672
100%
222%
d)
Jefferson County
31,000
41,292
10,292
100%
133%
User Fee
50,000
52,338
2,338
100%
105%
e)
COPS Reimbursements
30,000
-
(30,000)
100%
0%
f)
Contract Payments
70,000
32,134
(37,866)
100%
46%
g)
Miscellaneous
8,500
14,070
5,570
100%
166%
Interest
40,000
49,558
9,558
100%
124%
Interest on Unsegregated Tax
2,000
768
(1,232)
100%
38%
Total Revenues
7,773,121
7,713,206
(59,915)
100%
99%
TOTAL RESOURCES 13,634,456 14,405,151 770,695 100% 106%
REQUIREMENTS: % Exp.
Expenditures
Personal Services
4,008,798
3,589,464
419,334
100%
90%
Materials and Services
1,524,144
1,448,224
75,920
100%
95%
Capital Outlay
1,763,000
1,146,628
616,372
100%
65%
Transfers Out
1,014,061
942,836
71,225
100%
93%
Contingency
5,324,453
-
5,324,453
100%
n/a
TOTAL REQUIREMENTS
13,634,456
7,127,151
6,507,305
100%
52%
NET (Resources - Requirements)
-
7,278,000
7,278,000
Beginning NWC per Adopted Budget 6,400,000
a) CAD-to-CAD budgeted $314,000 of which $265,193 has been received. Expect to receive $39,485
more by June 30 ODOT project budgeted $160,000 which will not occur this fiscal year
b) GIS/Mapping revenue underbudgeted
c) Received quarterly (Nov, Feb, May and Aug) for fiscal year
d) Annual billings to agencies underbudgeted. All payments have been received
e) Crooked River Ranch paid annual fee of $45,869
f) Revenue not expected this fiscal year
g) All payments have been received
Health Benefits Trust
Statement of Financial Operating Data
Twelve Months Ended June 30, 2011
PRELIMINARY (July 20, 2011)
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
P/T Emp - Add9 Prem
Employee Prem Contribution
COIC
Retiree / COBRA Co-Pay
Federal Payments
Prescription Rebates
Interest
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Claims Paid-Medical/Rx
Claims Paid-Dental/Vision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Deschutes Onsite Clinic:
Healthstat
Equipment
Remodel
Miscellaneous
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Revised Year End
Budget Actual Variance FY % Coll. % L Budget Projection Variance
$ 16,400,000 $ 16,988,140 $ 588,140 100% 104%
11,246,000
11,407,042
161,042
100%
101%
50,000
45,695
(4,305)
100%
91%
500,000
488,710
(11,290)
100%
98%
975,000
1,418,895
443,895
100%
146%
450,000
732,526
282,526
100%
163%
-
93,496
93,496
100%
n/a
-
94,970
94,970
100%
n/a
100,000
109,027
9,027
100%
109%
13,321,000
14,390,360
1,069,360
100%
108%
$16,400,000 $ 16,988,140 588,140
11,246,000
11,407,042
161,042
50,000
45,695
(4,305)
500,000
488,710
(11,290)
975,000
1,418,895
443,895
450,000
732,526
282,526
-
93,496
93,496
-
94,970
94,970
100,000
109,027
9,027
13,321,000
14, 390,360
1,069,360
29,721,000 31,378,500 1,657,500 92% 106%
Exp.
29,721,000 31,378,500 1,657,500
129,280
127,664
1,616
100%
99%
129,280
127,664
1,616
12,450,194
12,306,832.23
143,362
100%
99% a)
12,450,194
12,306,832
143,362
1,871,377
1,785,072.26
86,305
100%
95% a)
1,871,377
1,785,072
86,305
-
(88,567)
88,567
100%
n/a
-
(88,567)
88,567
330,000
335,724
(5,724)
100%
102%
330,000
335,724
(5,724)
75,000
124,832
(49,832)
100%
166%
75,000
124,832
(49,832)
300,000
302,510
(2,510)
100%
101%
300,000
302,510
(2,510)
40,000
43,738
(3,738)
100%
109%
40,000
43,738
(3,738)
51,000
51,472
(472)
100%
101%
51,000
51,472
(472)
229,520
220,633
8,887
100%
96%
14,500
32,368
(17,868)
100%
223%
121,600
123,907
(2,307)
100%
102%
61,900
53,195
8,705
100%
86%
151,141
51,982
99,159
100%
34%
15,696,232
15,343,699
352,533
100%
98%
100
-
100
100%
0%
13,895,388
-
13,895,388
100%
0%
229,520
220,633
8,887
14,500
32,368
(17,868)
121,600
123,907
(2,307)
61,900
53,195
8,705
151,141
51,982
99,159
15,696,232
15,343,699
352,533
100
-
100
13,895,388
-
13,895,388
29,721,000 15,471,363 14,249,638 100% 52%
29,721,000 15,471,363 14,249,638
NET (Resources - Requirements) - 15,907,138 15,907,138 - 15,907,138 15,907,138
Beginning NWC per Adopted Budget 15,500,000
a) Actual is an average of $269,294 per week.
Deschutes County - Fair and Expo Center
YTD-Budget Basis Commissioners
Statement of Financial Operating Data
Year Ended June 30, 2011
PRELIMINARY (July 20, 2011)
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ 2,809
$ 6,590
$ 3,7811
100%
235%
Receipts:
Special Events Revenues
677,742
589,683
(88,059)
100%
87%
Interest
2,000
746
(1,254)
100%
37%
Storage
51,000
45,992
(5,009)
100%
90%
Camping at F & E
9,000
1,391
(7,609)
100%
15%
Horse Stall Rental
42,000
31,855
(10,145)
100%
76%
Concession % - Food
211,000
170,164
(40,836)
100%
81%
Rights (Signage, etc.)
93,000
117,738
24,738
100%
127%
Interfund Contract
45,000
45,000
-
100%
100%
Miscellaneous
4,414
28,059
23,645
100%
n/a
Total Receipts
1,135,156
1,030,628
(104,529)
100%
91%
Transfers In
General Fund (001)
197,919
197,919
-
100%
100%
Room Tax (160)
24,873
24,873
-
100%
100%
Welcome Center (170)
80,000
80,000
-
100%
100%
Annual County Fair (619)
231,232
166,000
(65,232)
100%
72%
Reserve Fund (617)
100
-
(100)
100%
0%
Total Transfers In
534,124
468,792
(65,332)
TOTAL RESOURCES
1,672,089
1,506,010
(166,079)
100%
90%
REQUIREMENTS:
Exp.
Expenditures:
Personal Services
931,893
862,123
69,770
100%
93%
Materials and Services
576,685
578,626
(1,941)
100%
100%
Debt Service
115,563
115,561
2
100%
100%
Capital Outlay
100
-
100
100%
0%
Total Expenditures
1,624,241
1,556,310
67,931
Transfers Out - Reserve Fund
10,000
-
10,000
100%
0%
Contingency
37,848
-
37,848
100%
n/a
TOTAL REQUIREMENTS
1,672,089
1,556,310
115,779
100%
93%
NET (Resources - Requirements)
-
(50,300)
(50,300)
Beginning NWC per Adopted Budget
75,000
Deschutes County
Bethlehem Inn (Fund 128)
Year Ended June 30, 2011
I Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ (2,725,000) $
(2,722,510)
$ 2,490
100%
100%
Revenues
Grants - Private
2,861,000
-
(2,861,000)
100%
0%
Lease Payments
-
24,408
24,408
100%
N/A
Total Revenues
2,861,000
24,408
(2,861,000)
100%
1%
TOTAL RESOURCES
136,000
(2,698,102)
(2,858,510)
100% -1984%
REQUIREMENTS:
Exp.
Expenditures
Debt Service:
Interest Expense
36,000
18,479
17,521
100% 51% a)
Interest Payment
100,000
-
100,000
100% 0%
TOTAL REQUIREMENTS
136,000
18,479
117,521
100% 14%
NET (Resources - Requirements)
-
(2,716,581)
(2,740,989)
b)
a) Interest on June 2011 negative cash balance: $1,297.42
b) Inception through June 30, 2011
Revenues - Lease Payments
$ 24,408
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
223,076
Total expended
2,740,989
Net $ (2,716,581)
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of June 30, 2011
PRELIMINARY (July 20, 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, 2010
July 1, 2010 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 Ieachate)
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, 2010
July 1, 2010 through June 30, 2011
Balance Due
Total of Engineering and Construction Contracts:
Original Contracts
Change Orders and Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through June 30, 2011
Balance Due
"Area A"
"Cell Y
api a
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
254,413.44
153,904.42
408,317.86
62,927.56
62,042.58
124,970.14
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
1,707,132.00 2,054,537.51 3,761,669.51
373,720.63
1,743,978.95
2,117,699.58
341,522.11
131,481.76
473,003.86
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
1,961,545.44
2,208,441.93
4,169,987.37
436,648.19
1,806,021.53
2,242,669.72
341,522.11
131,481.75
473,003.86
Note: There will not likely be additional payments to M A DeAtley until Spring. The additional services are for landscaping and other weather sensitive
activities.
C)
N
O
N
N
C
N
CL
X
W
I U >
m
N
N
U
m _
Cl
C O
-
114
~ v ~
W N
a~ m
-o
N co O N }
of
t 0 0
O
Y LL Q
CL ca
_Z
p U o
O
U
m W
W
U
a
N c
(
j
C7 E
O
N
co
N
U
C
N
w
O
U
I N'(D 0 m V' v
#
O ,o
IT C).M
' r
' d' LL7'W N
'
'
ft
'
19
I
'
V
V
O
'V',
o ~ O
0
.04 CD 04 C6
N OD,
N
v
4t
u) co r- M (D
co M :N
cj:
A
-7 c-i
N
-C. 1`
.
N
1
M co u7 1,
e-
~I
O i u7 M V• d• I V'
!
I O
ITT
-a-~- i
T.- N~-
oo 0o I o
ao (n tc)
p
V' c\1 IT
_
f-
INI
I
V
LO m
m.
, I' I I
I I
I
04
N
I
'
d i m
M
i i
N
In
(D,
0
0
Mc
0
N
M
N
o c,4 ,q r-
0) 1- w
co (N
1,
'o CN
m
co
co
N ' r V',
u7
.(p M
1
m
NI
1
r- (D 001 -
'
_N{•
ViC`) Ln -
ACV
-
M, r_ r
0)
1` Cl) m
O
N
W N
C\!
I
i I
'
Tf(D N r
m
_
-
.r IN ~I
t0
d,
7' i
I
0..
X
t
i
y W
,
m
Oi
m'
I
Cc,
E
O
`
a)
(l/ O
m
d to
c
i C
aEi
C E.
m
aEi °
C
N o
o Q'
U)
a., 'O' o'
W
US
aa
c o
a ° 7 d
W
U)
c o
0 7 d
CA
c n c
'O ° 7 N'U O
5 o:U
a QIV m
~N'
o
to
a
v m (00•
C C'
, m to
N O C
m m
'D
W N C O
f
. w m ~l . E c
-0
W W N
u ots E t V °rs m,~l
i
E,C Q -o }
'
m m ° LL
EI ~'ni
,
O' c; E a) o'
to
U'op a~ : E
F CO ,
o o ;
~
d
Y E a) o
° a~ ~ E
of H ~
I
E
m
o
~
o E ° O' U E ° °
m a~ E p a)E
m o'
o
~
°
O, o, o;~
C) m' c: c'
U
(A E MC
.
V
°
t N'
' C N
°
J~ E me
C>° N
O
O
o ,
rn
e
c-•~,EI- m
C>
N p
O
m E m mU iEl
C
°
N >'o C
~ ro
m'c o' (DI
6 0O OI N' U
-
v
V UZ '
(
j
O F
-
E
U o
p
vf-Q'Q~O
E
.
F
-
c• o m o -
Uf`¢~C9
L)
F
-
o Co t
RO
a~o
(
j
o, U ~ o E ~I
c
2
'
w 0
m
~
t
a
UQ
C~
H<<2(D LL D_
°
pn 02
m~
o
Q
r
m
N
u)' to lr lr m co
O
u). tolM min
co
'(D 0 co co O) m
co
co m I
N
AM0
) O (o
O
(DNN(D~
v
com V- MON
t0
M.N'
co
1
O H M
O
co N u) O
r
V- N ('M O
t0
u) V O
0)
p
co a- co
N
'N r N
co
}
-
~
-
C
'IO O M
~ 1.-
O
1
~1~
N
'
:M
M
m cD
to m
N
N
I
M
' (D 0
,t0
CO
to
M
,
-
r
'
to (O
I
N
' (N
I
N
N
N
to W I
CD
(D
N
(O ' I
i I'
1
I
O u') c'M , V' , O v
t0
I O -
O
O R
V'
O.
(DI(D LO co m u)
'
N
: O -
10
O O
N
Q
. N 7 a)
V
It
' '
' '
N
N
to o)
'T
cD n
v
N
(D M
u) N
LL
N
^
y
O to 7
r O t0
O N N_ (o'-
to
N (D
~
u) u) N
MM M
1-
7• V•
co
'
I
'
'I~
1
M
N
t- O N c0
M V' M
O N
p
co t0
>
' ' ' '
' N M
' . ' '
co ' M
O
Z
tf) M u)
M
u) u) CD O
t0
(o co d• N M
f`
0
t0
N
w
O N O m
c4
O,m 1~ N
(h
M
U
O
M V'M
M
' u)
u)
O
-
N
Mrr
O)
N
N
(D r- cj r-
c4
m
N r 7
M
~
u) 1` W
M
7
N
Cl)
I
' 'N
. . .
Q
,
Cl)
M
_
Memorandum
Date: July 20, 2011
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find June 2011 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
GENERALFUND
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital
$ 8,300,000 $
9,677,699
$ 1,377,699
100%
117%
Revenues
Property Taxes
20,566,000
21,419,761
853,761
100%
104%
Gen. Rev. - excl. Taxes
2,397,138
2,491,745
94,607
100%
104%
Assessor
795,690
826,610
30,920
100%
104%
County Clerk
1,220,714
1,507,272
286,558
100%
123%
BOPTA
12,398
13,077
679
100%
105%
District Attorney
314,100
209,868
(104,232)
100%
67%
Finance/Tax
180,200
198,257
18,057
100%
110%
Veterans
67,866
67,544
(322)
100%
100%
Property Management
91,132
96,146
5,014
100%
106%
Grant Projects
2,000
2,000
-
100%
100%
Total Revenues
25,647,238
26,832,280
1,185,042
100%
105%
TOTAL RESOURCES
33,947,238
36,509,979
2,562,741
100%
108%
REQUIREMENTS: Exp.
Expenditures
Assessor
3,382,219
3,244,647
137,572
100%
96%
County Clerk
1,484,127
1,313,225
170,902
100%
88%
BOPTA
75,403
66,610
8,793
100%
88%
District Attorney
4,882,127
4,773,245
108,882
100%
98%
Finance/Tax
856,910
815,991
40,919
100%
95%
Veterans
274,837
265,442
9,395
100%
97%
Property Management
261,227
254,471
6,756
100%
97%
Grant Projects
117,203
114,967
2,236
100%
98%
Non-Departmental
2,293,337
1,836,466
456,871
100%
80%
Contingency
4,582,684
-
4,582,684
100%
n/a
18,210,074
12,685,066
5,525,008
100%
85%
Transfers Out
15,737,164
15,727,164
10,000
100%
100%
TOTAL REQUIREMENTS
33,947,238
28,412,230
5,535,008
100%
93%
NET (Resources - Requirements)
-
8,097,750
8,097,750
a)
Beginning NWC per Adopted Budget 7,300,000
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY % Coll.
RESOURCES:
Beg. Net Working Capital
$ 987,000
$1,039,997
$ 52,997
100%
1o5%
Revenues
Federal Grants
15,527
12,135
(3,392)
100%
78%
a)
SB #1065-Court Assess.
60,000
53,697
(6,303)
100%
89%
b)
Discovery Fee
16,000
12,441
(3,559)
100%
78%
b)
Food Subsidy
38,000
27,583
(10,417)
100%
73%
b)
OYA Basic & Diversion
340,006
182,135
(157,871)
100%
54%
c)
Inmate/Prisoner Housing
100,000
75,300
(24,700)
100%
75%
d)
Inmate Commissary Fees
100
154
54
100%
154%
Contract Payments
88,490
88,350
(140)
100%
100%
Miscellaneous
300
70
(230)
100%
23%
MIP Diversion Fees
1,000
295
(705)
100%
30%
b)
Interest on Investments
17,000
8,009
(8,991)
100%
47%
Leases
2,400
2,400
-
100%
100%
Grants - Private
500
1,697
1,197
100%
339%
Behavioral Health
6,000
3,319
(2,681)
100%
55%
b)
CCF Interfund Grant
60,495
72,375
11,880
100%
120%
e)
Gen Fund Grant-Crime Prev.
20,000
15,000
(5,000)
100%
75%
Total Revenues
765,818
554,961
(210,857)
100%
72%
Transfers In-General Fund
5,543,186
5,543,186
-
100%
100%
TOTAL RESOURCES
7,296,004
7,138,144
(157,860)
100%
98%
REQUIREMENTS:
Exp.
Expenditures
Community Justice-Juvenile
Personal Services
2,963,956
2,746,604
217,352
100%
93% f)
Materials and Services
1,199,886
1,077,777
122,109
100%
90% g)
Capital Outlay
100
-
100
100%
0%
Juvenile Resource Center
Personal Services
2,315,104
2,147,293
167,811
100%
93% h)
Materials and Services
175,494
175,880
(386)
100%
100%
Contingency
641,464
-
641,464
100%
n/a
TOTAL REQUIREMENTS
7,296,004
6,147,554
1,148,450
100%
84%
NET (Resources - Requirements)
-
990,590
990,590
Beginning NWC per Adopted Budget
1,101,374
a) Fourth quarter Federal Grant reimbursement of $3,000 is expected in June
b) Revenues trending less than projected due to reduction in use of services and lower juvenile populations
c) OYA monies collected in Nov, Feb, May, and June - New reduction due to under-utilization of Maplestar treatment foster care -
(population of kids in Maplestar less than anticipated in the original budget). Approximately $75,000 payment anticipated in June
d) Revenue is generated when non-Deschutes juveniles utilize facility - less utilization than anticipated to date
e) Additional funding from CCF allocated for Juvenile programs
f) Personnel savings due to approximately 3.00 FTE unfilled
g) DHS/BRS match payments and Maplestar contract payments are less than originally budgeted due to reduction
in youth using the program
h) Personnel savings, due to less on-call and overtime for the detention facility
SHERIFF - Fund 255
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Law Enf Dist Countywide
I Law Enf Dist Rural
Total Revenues
Budget Actual Variance FY % Coll.
22,829,457 18,138,940 (4,690,517)
13,665,939 11,428,545- (2;237,394)
36,495,396 29,567,485 (6,927,911)
100% n/a
TOTAL RESOURCES 36,495,396 29,567,485 (6,927,911)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division
3,077,051
2,959,895
117,156
Civil
822,436
780,646
41,790
Automotive/Communications
1,653,036
1,514,404
138,632
Investigations/Evidence
1,650,792
1,482,795
167,997
Patrol/Civil/Comm Supp
8,015,651
7,729,134
286,517
Records
660,386
622,378
38,008
Adult Jail
9,854,864
8,882,472
972,392
Court Security
280,851
272,025
8,826
Emergency Services
179,441
169,801
9,640
Special Services Division
1,298,604
1,154,169
144,435
Regional Work Center
2,892,242
2,660,758
231,484
Training Division
330,000
261,945
68,055
Other Law Enforcement Svcs
611,917
594,044
17,873
Non-Departmental
283,018
283,018
-
Contingency
4,685,107
-
4,685,107
Transfer Out - Jail Remodel
100,000
100,000
-
Transfers Out - D/S Fund
100,000
100,000
-
TOTAL REQUIREMENTS 36,495,396 29,567,485 6,927,911
NET (Resources - Requirements)
Beginning NWC per Adopted Budget
100% 79%
100% 84%
100% 81%
100% 81%
Exp.
100%
96%
a)
100%
95%
b)
100%
92%
C)
100%
90%
b)
100%
96%
b)
100%
94%
b)
100%
90%
d)
100%
97%
100%
95%
100%
89%
100%
92%
e)
100%
79%
f)
100%
97%
100%
100%
100%
n/a
100%
n/a
100%
100%
100% 81%
a) Less than planned M&S expenses for the year
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Expenditures grant funded consulting contract will be made in FY 2012
d) Unfilled budgeted positions and no planned jail bed rental. $350,000 for JMS software
will be expended in FY 2012
e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011
f) Personnel expenses will be lower than planned due to employee transfers
Fund 701 LED-Countywide
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY % Coll.
RESOURCES:
Beg. Net Working Capital
$4,722,862
$ 5,609,156
$ 886,294
100%
119%
Tax Revenues - Current
14,853,594
15,003,874
150,280
100%
101%
Tax Revenues - Prior
642,000
795,339
153,339
100%
124%
Federal Grants
35,000
48,563
13,563
100%
139%
State Grant
48,475
72,573
24,098
100%
150%
Transp. of State Wards
5,000
3,321
(1,679)
100%
66%
SB 1145
1,974,660
1,854,463
(120,197)
100"/°
94%
Des. Cty Video Lottery Grant
5,000
5,000
-
100%
100%
Des Cty Court Security
95,000
94,855
(145)
100%
100%
Des Cty Juvenile Contract
-
4,994
4,994
100%
n/a
Title III Reimbursement
150,000
154,996
4,996
100%
103%
Transport
4,000
487
(3,513)
100%
12%
DC Fair & Expo Center
-
5,280
5,280
100%
n/a
Inmate Commissary Fees
48,000
75,217
27,217
100%
157%
Work Center Work Crews
25,000
49,725
24,725
100%
199%
Concealed Handgun Classes
6,000
4,125
(1,875)
100%
69%
Soc Sec Incentive-Fed
5,000
7,800
2,800
100%
156%
Miscellaneous
5,000
7,187
2,187
100%
144%
Oregon Mentors
-
14,750
14,750
100%
n/a
Medical Services Reimb
12,000
19,094
7,094
100%
159%
Restitution
1,000
4,114
3,114
100%
411%
Sheriff Fees
160,000
257,255
97,255
100%
161%
Interest
28,333
50,285
21,952
100%
177%
Interest on Unsegregated
3,533
1,837
(1,696)
100%
52%
Rentals
-
2,500
2,500
100%
n/a
Donations
-
200
200
100%
n/a
Sale of Reportable Assets
-
1,257
1,257
100%
n/a
Total Revenues
18,106,595
18,544,506
437,911
100%
102%
TOTAL RESOURCES
22,829,457
24,153,662
1,324,205
100%
106%
REQUIREMENTS:
Exp.
Department
Sheriffs Services
2,910,890
2,800,061
110,830
100%
96%
Civil
822,436
780,646
41,790
100%
95%
Auto/Comm
595,093
545,186
49,907
100%
92%
Adult Jail
9,854,864
8,882,472
972,392
100%
90%
Court Security
280,851
272,025
8,826
100%
97%
Emer Svcs
179,441
169,801
9,640
100%
95%
Special Services
1,049,272
932,569
116,703
100%
89%
Work Center
2,892,242
2,660,758
231,484
100%
92%
Training
201,300
159,787
41,513
100%
79%
Other (CODE, Forensic)
611,917
594,044
17,873
100%
97%
Internal Services
41,592
141,792
(100,200)
100%
341%
Transfer to Debt Service
100,000
100,000
-
100%
100%
Transfer to Jail Remodel
100,000
100,000
-
100%
100%
Transfer for Reserve Fund
100,000
-
100,000
100%
0%
Contingency
3,089,559
-
3,089,559
100%
0%
TOTAL REQUIRMENTS 22,829,457 18,139,140 4,690,316 79%
Net - 6,014,522 6,014,522
Beginning NWC per Adopted Budget 5,108,671
a) Timing of reimbursements for the Emergency Planning Grant
b) Funding reduction from Dept of Corrections
c) Higher than planned inmate telephone use and commissary purchases
d) Work Crew revenue from USFS was not planned
e) Unplanned revenue for the "Children of Incarcerated Parents" program
f) Revenue for concealed weapons permits and civil papers will exceed budget
Fund 702 LED Rural
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital
$1,905,939
$ 2,498,487
$ 592,548
100%
131%
Revenues
Tax Revenues - Current
7,508,247
7,555,396
47,149
100%
101%
Tax Revenues - Prior
314,000
394,765
80,765
100%
126%
Federal Grants
2,000
13,326
11,326
100%
666%
Federal Grants-BLM
-
9,597
9,597
100%
n/a
US Forest Service
76,500
64,125
(12,375)
100%
84%
State Grant
187,633
89,238
(98,395)
100%
48%
SB #1065 Court Assessmf
67,000
53,697
(13,303)
100%
80%
Marine Board License Fee
142,433
49,842
(92,591)
100%
35%
Des Cty General Fund Grr
702,358
514,358
(188,000)
100%
73%
Des Cty Transient Room 1
1,947,642
2,135,642
188,000
100%
110%
City of Sisters
432,655
432,655
-
100%
100%
Des Cty Tax/Fin Contract
1,000
-
(1,000)
100%
0%
Des Cty CDD Contract
54,366
54,366
-
100%
100%
Des Cty Solid Waste Cont
54,366
54,366
-
100%
100%
Des Cty Clerk/Election
2,000
1,249
(751)
100%
62%
School Districts
100,000
41,549
(58,451)
100%
42%
Claims Reimbursement
-
8,472
8,472
100%
n/a
Security & Traffic Reimb
13,000
5,961
(7,039)
100%
46%
Seat Belt Program
6,000
7,025
1,025
100%
117%
Miscellaneous
10,000
9,671
(329)
100%
97%
Restitution
500
1,058
558
100%
212%
Sheriff Fees
10,000
10,048
48
100%
100%
Court Fines & Fees
85,000
131,817
46,817
100%
155%
Impound Fees
15,000
6,000
(9,000)
100%
40%
Restitution - Street Crimes
500
-
(500)
100%
0%
Interest
10,000
20,201
10,201
100%
202%
Interest on Unsegregated
1,800
924
(876)
100%
51%
Donations
-
12,250
12,250
100%
n/a
Sale of Reportable Assets
10,000
32,762
22,762
100%
328%
Sale of Equip & Material
6,000
3,570
(2,430)
100%
60%
Total Revenues
11,760,000
11,713,932
(46,068)
50%
100%
TOTAL RESOURCES
13,665,939
14,212,419
546,480
50%
104%
REQUIREMENTS:
Exp. Rio
Department
Sheriffs Services
166,161
159,834
6,326
100%
96%
Auto/Comm
1,057,943
969,219
88,724
100%
92%
Investigations
1,650,792
1,482,795
167,997
100%
90%
Patrol
8,015,651
7,729,134
286,517
100%
96%
Records
660,386
622,378
38,008
100%
94%
Special Services
249,332
221,601
27,731
100%
89%
Training
128,700
102,159
26,541
100%
79%
Internal Services
41,426
141,226
-
100%
341%
Transfer for Reserve Fund
100,000
-
100,000
100%
0%
Contingency
1,595,548
-
1,595,548
100%
0%
TOTAL REQUIRMENTS
13,665,939
11,428,345
2,237,594
84%
Net
-
2,784,074
2,784,074
Beginning NWC per Adopted Budget 2,936,523
a) Detective overtime reimbursements from HIDTA
b) Contract increased for purchase of new boat. Payments will be received in Qtr 4
c) Grant will be received in June 2011
d) Less than planned revenue due to lower billing rates and hours worked
e) Revenue from traffic fines will exceed budget
f) Animal Rescue Facility donations
g) Proceeds from sale of used patrol vehicles were higher than estimated
PUBLIC HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget Actual Variance FY % coll. %
RESOURCES:
Beg. Net Working Capital
$1,100,000
$ 1,615,306 $
515,306
100%
147%
Revenues
Medicare Reimbursement
8,000
147
(7,853)
100%
2%
State Grant
2,512,977
2,427,905
(85,072)
100%
97%
a)
Child Dev & Rehab Center
30,759
30,759
(0)
100%
100%
State Miscellaneous
219,896
250,248
30,352
100%
114%
OMAP
477,800
628,876
151,076
100%
132%
Title 19
-
927
927
100%
n/a
Family Planning Exp Proj
495,000
467,649
(27,351)
100%
94%
Local Grants
65,000
115,839
50,839
100%
178%
b)
Water Program-Base Fee
42,000
37,544
(4,456)
100%
89%
Water Program-Field Work
55,817
49,840
(5,977)
100%
89%
H2O Sys Insp-Priv Wells
200
-
(200)
100%
0%
Miscellaneous
-
386
386
100%
n/a
Patient Insurance Fees
190,260
131,128
(59,132)
100%
69%
c)
Health Dept/Patient Fees
148,975
111,975
(37,000)
100%
75%
c)
Vital Records-Birth
36,000
33,425
(2,575)
100%
93%
Vital Records-Death
98,000
104,725
6,725
100%
107%
Environmental Health
687,350
738,893
51,543
100%
107%
Interest on Investments
16,900
11,213
(5,687)
100%
66%
Donations
6,000
32,582
26,582
100%
543%
d)
Interfund Contract
189,378
72,661
(116,717)
100%
38%
Administrative Fee
27,000
27,000
-
100%
100%
Drug Court Byrne
-
4,157
4,157
100%
n/a
Total Revenues
5,307,312
5,277,878
(29,434)
100%
99%
Transfers In-General Fund
2,317,765
2,317,765 - 100% 100%
Transfers In-PH Res Fund
67,123
67,123 - 100% 100%
Transfers In-Gen. Fund Other
67,812
67,812 - 100% 100%
TOTAL RESOURCES
8,860,012
9,345,885 485,873 100% 105%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
Exp.
5,857,162
5,778,024
79,138
100%
99%
2,037,387
2,064,780
(27,393)
100%
103%
25,000
5,432
19,568
100%
22%
150,000
150,000
-
100%
100%
790,463
-
790,463
100%
n/a
8,860,012 7,998,237 861,775 100% 90%
NET (Resources - Requirements) - 1,347,647 1,347,647
Beginning NWC per Adopted Budget 1,596,918
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
ABHA
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Seizure/Forfeiture
Interest on Investments
Rentals
Interfund Contract-Gen. Fund
Comm. on Children & Fam
Administrative Fee
Total Revenues
$ 2,616,050 $ 2,651,262 $ 35,212 100% 101%
5,500
5,245
(255)
100%
95%
130,000
143,501
13,501
100%
110%
1,000
45
(955)
100%
5%
96,969
232,483
135,514
100%
240%
a)
6,567,212
6,491,699
(75,513)
100%
99%
b)
148,173
113,787
(34,386)
100%
77%
-
99,685
99,685
100%
n/a
300,925
206,789
(94,136)
100%
69%
105,400
114,531
9,131
100%
109%
70,000
81,540
11,540
100%
116%
16,900
37,254
20,354
100%
220%
154,000
85,392
(68,608)
100%
55%
13,000
2,252
(10,748)
100%
17%
-
14,841
14,841
100%
n/a
43,585
22,703
(20,882)
100%
52%
13,100
16,500
3,400
100%
126%
127,000
118,217
(8,783)
100%
93%
a)
24,000
-
(24,000)
100%
0%
c)
4,211,457
4,207,255
(4,202)
100%
100%
12,028,221
11,993,717
(34,505)
100%
100%
Transfers In-General Fund
1,316,158
1,316,158
- 100%
100%
Transfers In-OHP-CDO
100,000
100,000
- 100%
100%
Transfers In-Acute Care Svcs
365,657
365,657
- 100%
100%
Transfers In-ABHA
668,252
668,252
- 100%
100%
TOTAL RESOURCES 17,094,338 17,095,046 708 100% 100%
REQUIREMENTS: Exp.
Expenditures
Personal Services
9,337,153
8,974,295
362,858
100%
96% d)
Materials and Services
5,276,251
4,699,487
576,764
100%
89%
Capital Outlay
766,000
215,540
550,460
100%
28%
Transfers Out
157,164
150,000
7,164
100%
95%
Contingency
1,557,770
-
1,557,770
100%
n/a
TOTAL REQUIREMENTS
17,094,338
14,039,321
3,055,017
100%
82%
NET (Resources - Requirements)
-
3,055,724
3,055,724
Beginning NWC per Adopted Budget 3,268,759
a) Received quarterly, in arrears
b) Department of Human Services Grant projected at amended contract amount for FY 11
c) Child and Family prevention program eliminated
d) Personnel expenditure projected to be less than budgeted due to unfilled positions
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Year to Date
Budget Actual Variance FY % Coll. %
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $
686,081
613,031
$ (73,050)
100%
89%
Revenues
Admin-Operations
16,500
17,442
942
100%
106%
Admin-GIS
2,750
4,384
1,634
100%
159%
a)
Admin-Code Enforcement
161,718
170,597
8,879
100%
105%
Building Safety
1,081,217
984,748
(96,469)
100%
91%
b)
Electrical
266,652
253,420
(13,232)
100%
95%
Contract Services
184,000
147,811
(36,189)
100%
80%
c)
Env Health-On Site Prog
283,830
274,473
(9,357)
100%
97%
Planning-Current
776,962
709,269
(67,693)
100%
91%
d)
Planning-Long Range
353,771
343,501
(10,270)
100%
97%
e)
Total Revenues
3,127,400
2,905,645
(221,755)
100%
93%
Trans In-GF
253,387
253,387
-
100%
100%
Trans In-GF for Lng Rng Ping
516,000
516,000
-
100%
100%
TOTAL RESOURCES
4,582,868
4,288,063
(294,805)
100%
94%
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFERS
Admin-Operations
1,402,396
1,381,821
20,575
100%
99%
Admin-GIS
216,135
171,230
44,905
100%
79%
f)
Admin-Code Enforcement
184,732
185,538
(806)
100%
100%
Building Safety
500,330
492,560
7,770
100%
98%
g)
Electrical
187,606
180,632
6,974
100%
96%
Contract Services
244,251
223,681
20,570
100%
92%
g)
Env Health-On Site Pgm
232,006
211,617
20,389
100%
91%
h)
Planning-Current
690,290
637,696
52,594
100%
92%
i)
Planning-Long Range
492,427
497,630
(5,203)
100%
101%
j)
Transfers Out (D/S Fund)
173,310
173,310
-
100%
100%
Contingency
259,385
-
259,385
100%
n/a
TOTAL REQUIREMENTS 4,582,868 4,155,715 427,153 100% 91%
NET (Resources - Requirements) - 132,348 132,348
Beginning NWC per Adopted Budget 229,822
Revenues 2,905,645
Expenditures 4,155,715
Net from Operations (1,250,070)
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) Projections reduced, as at least one major project (La Pine Biomass plant) has been delayed,
but is expected to occur in FY 2012.
c) City of Redmond receipts lag one month behind
d) YTD business volume/revenue projected to be less than estimated
e) Grant payments received irregularly
f) Savings due to resignation of CDD webmaster, who will not be replaced
g) Savings due to retirement of Building Inspector in January, who will not be replaced
h) Savings due to retirement of EH Director, who will be replaced by an EH Specialist III
i) Savings due to lower expenses associated with Hearings Officer, mailings, etc.
j) Consultant expenditure higher than budgeted associated with timing of grant revenue received in FY 2010
ROAD
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
IF
%
Coll.
RESOURCES:
Beg. Net Working Capital
$ 3,430,429 $
3,419,603
$ (10,826)
100%
1o0%
Revenues
Mineral Lease Royalties
20,000
153,454
133,454
100%
767%
Forest Receipts
2,237,000
2,237,091
91
100%
100%
a)
State Miscellaneous
96,984
-
(96,984)
100%
0%
b)
Motor Vehicle Revenue
10,000,000
9,043,509
(956,491)
100%
90%
c)
City of Bend
275,000
322,324
47,324
100%
117%
d)
City of Redmond
350,000
250,458
(99,542)
100%
72%
d)
City of Sisters
10,000
-
(10,000)
100%
0%
d)
City of La Pine
10,000
-
(10,000)
100%
0%
d)
Admin Recovery (SDC)
-
2,810
2,810
100%
n/a
Miscellaneous
90,000
31,695
(58,305)
100%
35%
Road Vacations
1,000
1,000
-
100%
100%
Interest on Investments
40,000
22,699
(17,301)
100%
57%
Other Bank/LGIP Interest
-
61
61
100%
n/a
Parking Fees
900
-
(900)
100%
0%
Grants-Private
-
2,434
2,434
1oo%
n/a
Interfund Contract
750,000
(750,000)
1oo%
0%
e)
Equipment Repairs
250,000
235,980
(14,020)
100%
94%
Vehicle Repairs
90,000
72,180
(17,820)
100%
80%
LID Construction
10,000
-
(10,000)
100%
0%
e)
Vegetation Management
35,000
(35,000)
100%
0%
e)
Forester
25,000
(25,000)
100%
0%
e)
Car Washes
3,000
4,496
1,496
100%
150%
Car Rental
500
948
448
100%
190%
Sale of Equip, Mat & Svcs
202,500
216,215
13,715
100%
107%
Interfund Fuel, etc.
401,000
549,736
148,736
100%
137%
Total Revenues
14,897,884
13,147,089
(1,750,795)
100%
88%
Trans In - Solid Waste
291,740
291,740 - 100% 100%
Trans In - Transp SDC
200,000
200,000 - 100% 100%
Trans In-Road Imp Res
12,040
(12,040) 100% 0%
TOTAL RESOURCES
18,832,093
17,058,432 (1,773,661) 100% 100%
REQUIREMENTS:
Exp.
Expenditures
Personal Services
5,752,967
5,571,742
181,225
100%
97%
Materials and Services
9,471,023
8,498,939
972,084
100%
9o%
Capital Outlay
1,171,691
91,180
1,080,511
100%
8% f)
Transfers Out
400,000
400,000
-
100%
100%
Contingency
2,036,412
-
2,036,412
100%
n/a
TOTAL REQUIREMENTS
18,832,093
14,561,860
4,270,233
100%
77%
NET (Resources - Requirements) - 2,496,572 2,496,572
Beginning NWC per Adopted Budget 2,834,720
a) Annual payment-January 2011
b) Received in June 2010
c) Even though gas taxes increased by 25% ($.06/gal.) effective January 2011 (revised State estimate);
gas tax receipts will be less than estimated
d) Billed upon completion of work
e) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
f) Budget includes $1,076,691 for 19th Street construction. Will be expended in future years
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital
$ 616,371
$ 728,649
$ 112,278
100%
118%
Revenues
DOC Measure 57
217,305
217,350
45
100%
100%
State Miscellaneous
4,301
4,301
-
100%
100%
Alternate Incarceration
30,918
30,918
-
100%
100%
State Subsidy
13,000
13,306
306
100%
102%
S61145
2,961,990
2,781,694
(180,296)
100%
94%
Probation Work Crew Fees
38,000
24,792
(13,209)
100%
65%
a)
Miscellaneous
3,000
4,321
1,321
100%
144%
b)
Electronic Monitoring Fee
170,000
158,186
(11,814)
100%
93%
Probation Superv. Fees
210,000
203,591
(6,409)
100%
97%
Interest on Investments
9,000
8,314
(686)
100%
92%
Interfund - Sheriff
50,000
50,000
-
100%
100%
Crime Prevention Grant
50,000
37,500
(12,500)
100%
75%
c)
CFC-Domestic Violence
-
37,416
37,416
100%
n/a
d)
Total Revenues
3,757,514
3,571,689
(185,825)
100%
95%
Transfers In-General Fund
115,029
115,029
-
100%
100%
TOTAL RESOURCES
4,488,914
4,415,367
(73,547)
100%
98%
REQUIREMENTS:
Exp.
Expenditures
Personal Services
3,173,257
2,973,970
199,287
100%
94% e)
Materials and Services
894,274
834,424
59,850
100%
93% f)
Capital Outlay
100
-
100
100%
0%
Contingency
421,283
-
421,283
100%
n/a
TOTAL REQUIREMENTS
4,488,914
3,808,393
680,521
100%
85%
NET (Resources - Requirements) - 606,974 606,974
Beginning NWC per Adopted Budget 560,000
a) Increase in fee waivers from court due to economic conditions
b) Larger number of offenders doing out of state and county transfers
c) Payments received quarterly (Sept, Dec, Mar and June)
d) Intensive Supervision DV grant (Federal grant)
e) Personnel expenditure projected to be less than budgeted due to unfilled positions
f) M57 treatment funds have been used less based on current population
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
Grants-Private
Donations
Video Lottery
Miscellaneous
Total Revenues
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget Actual Variance FY % Coll.
$ 562,762 $ 635,340 $ 72,578 100% 113%
400,167
355,788
(44,379)
100%
63,750
61,870
(1,880)
100%
95,000
71,972
(23,028)
100%
257,984
239,237
(18,747)
100%
14,500
7,532
(6,968)
100%
308,924
263,596
(45,328)
100%
604,323
542,003
(62,320)
100%
8,000
3,597
(4,403)
100%
75,000
86,101
11,101
100%
20,000
5,044
(14,956)
100%
5,000
-
(5,000)
100%
-
4,357
4,357
100%
-
2,500
2,500
100%
258,554
124,850
(133,704)
100%
2,111,202
1,768,447
(342,755)
100%
Trans from General Fund
284,333
284,333
- 100%
100%
Trans from GF-Other
25,000
25,000
- 100%
100%
Total Transfers In
309,333
309,333
- 100%
100%
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
2,983,297 2,713,120 (270,177) 100% 91%
89% a)
97%
76%
93%
52% b)
85% c)
90% c)
45% d)
115% e)
25% f)
0% g)
n/a d)
n/a d)
48% h)
84%
Exp.
599,559 544,038
55,521
100%
91% i)
1,975,084 1,469,934
505,150
100%
74% c)
100 -
100
100%
0%
408,554 -
408,554
100%
n/a
TOTAL REQUIREMENTS 2,983,297 2,013,972 969,325 100% 68%
NET (Resources - Requirements) - 699,148 699,148
Beginning NWC per Adopted Budget 467,111
a) Federal grants adjusted to projected actual
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $9,924 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Community donations received for "Week of the Young Child" & building partner reimbursements adjusted to actual
e) Mary's Place court fines greater than projected
f) Interest revenue projected to be less than budgeted
g) Youth conference donations will not be received
h) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
i) Personnel costs will be less than budgeted due to open positions-increased due to .50 FTE working additional hours
SOLID WASTE
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital
$ 392,509 $
318,001
$ (74,508)
100%
81%
Revenues
Miscellaneous
28,000
22,269
(5,731)
100%
80%
Refunds/Reimbursements
-
15
15
100%
n/a
Franchise 3% Fees
200,000
209,430
9,430
100%
105%
Commercial Disp. Fees
840,000
859,359
19,359
100%
102%
Private Disposal Fees
1,314,000
1,321,254
7,254
100%
101%
Franchise Disposal Fees
3,659,000
3,891,476
232,476
100%
106%
Yard Debris
73,000
85,014
12,014
100%
116%
Special Waste
25,000
41,919
16,919
100%
168%
a)
Interest
12,500
8,668
(3,832)
100%
69%
Leases
-
1
1
100%
n/a
Sale of Carbon Credits
80,000
-
(80,000)
100%
0%
b)
Donations
-
3,240
3,240
100%
n/a
Sale of Equip & Material
-
100
100
100%
n/a
c)
Recyclables
20,000
51,992
31,992
100%
260%
d)
Total Revenues
6,251,500
6,494,736
243,236
100%
104%
TOTAL RESOURCES
6,644,009
6,812,737
168,728
100%
103%
REQUIREMENTS
Exp.
Expenditures
Personal Services
1,634,618
1,626,788
7,830
100%
100%
Materials and Services
2,865,829
2,606,625
259,204
100%
91% e)
Debt Service
970,066
970,066
0
100%
100%
Capital Outlay
148,000
127,332
20,668
100%
86% f)
Transfers Out-Road
291,740
291,740
-
100%
100%
Contingency
733,756
-
733,756
100%
n/a
TOTAL REQUIREMENTS
6,644,009
5,622,551
1,021,458
100%
85%
NET (Resources - Requirements) - 1,190,186 1,190,186
Beginning NWC per Adopted Budget 1,092,508
a) Bonneville Power did large clean-up of contaminated soil-unexpected revenue
b) No market at this time. Not expected to market this fiscal year
c) Minor revenue for sale of gate remotes
d) Markets for recyclables varies throughout the year - usually declines during Winter
e) Larger expenditures (i.e. grinding at $75,000) will be made in Spring
f) Software purchase in process; also, $30,000 from contingency needed for
safety covers for Knott Transfer Trailer Bays
RISK MANAGEMENT
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 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
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
Budget Actual Variance % of FY % Coll.
$2,500,000 $2,374,541 ($125,460)
335,833 335,833
294,019 294,019
182,710 182,710
906,361
905,974
(387)
170,437
172,348
1,911
30,000
-
(30,000)
20,000
28,481
8,481
1,500
2,115
615
2,000
-
(2,000)
22,000
15,818
(6,182)
30,000
15,685
(14,315)
1,994,860
1,952,983
(41,877)
4,494,860 4,327,523 (167,337)
62,818
104,314
7,935
155,221
726
250
400,000 331,264 68,736
150,075
14,790
300,000 164,865 135,135
1,964
390
15,244
81,860
120,000 99,457 20,543
WORKERS' COMPENSATION
Settlement / Benefit
Professional Service
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Contingency
TOTAL REQUIREMENTS
NET
100% 95%
100% 100%
100% 100%
100% 100%
100% 100%
100% 101%
100% 0%
100% 142%
100% 141%
100% 0%
100% 72%
100% 52%
100% 98%
100% 96%
Exp.
100% 83%
100% 55%
100% 83%
632,866
6,250
112,172
57,803
44,275
650,000 853,366 (203,366) 100% 131%
350,000 267,377 82,623
1,820,000 1,716,329 103,671
100% 76%
100% 94%
291,953 291,027 926
228,834 186,635 42,199
100 - 100
520,887 477,663 43,224
2,153,973 - 2,153,973
4,494,860 2,193,992 2,300,868
- 2,133,531 2,133,531
100%
100%
100%
100%
100%
100%
100%
82%
0%
92%
n/a
49%
Beginning NWC per Adopted Budget 2,100,000
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Year Ended June 30, 2011
Preliminary as of July 15, 2011
Budget
Actual
Variance
% of FY
% Coll.
RESOURCES:
Beg. Net Working Capital
$ 5,861,335 $
6,691,945
$ 830,610
100%
114%
Revenues
Property Taxes - Current
6,357,621
6,272,640
(84,981)
100%
99%
Property Taxes - Prior
138,000
293,583
155,583
100%
213%
Federal Grants
474,000
265,193
(208,807)
100%
56%
a)
State Reimbursement
10,000
22,193
12,193
100%
222%
b)
Telephone User Tax
550,000
642,765
92,765
100%
117%
c)
Data Network Reimb.
12,000
26,672
14,672
100%
222%
d)
Jefferson County
31,000
41,292
10,292
100%
133%
User Fee
50,000
52,338
2,338
100%
105%
e)
COPS Reimbursements
30,000
-
(30,000)
100%
0%
f)
Contract Payments
70,000
32,134
(37,866)
100%
46%
g)
Miscellaneous
8,500
14,070
5,570
100%
166%
Interest
40,000
49,558
9,558
100%
124%
Interest on Unsegregated Tax
2,000
768
(1,232)
100%
38%
Total Revenues
7,773,121
7,713,206
(59,915)
100%
99%
TOTAL RESOURCES
13,634,456
14,405,151
770,695
100%
106%
REQUIREMENTS:
% Exp.
Expenditures
Personal Services
4,008,798
3,589,464
419,334
100%
90%
Materials and Services
1,524,144
1,448,224
75,920
100%
95%
Capital Outlay
1,763,000
1,146,628
616,372
100%
65%
Transfers Out
1,014,061
942,836
71,225
100%
93%
Contingency
5,324,453
-
5,324,453
100%
n/a
TOTAL REQUIREMENTS
13,634,456
7,127,151
6,507,305
100%
52%
NET (Resources - Requirements) - 7,278,000 7,278,000
Beginning NWC per Adopted Budget 6,400,000
a) CAD-to-CAD budgeted $314,000 of which $265,193 has been received. Expect to receive $39,485
more by June 30 ODOT project budgeted $160,000 which will not occur this fiscal year
b) GIS/Mapping revenue underbudgeted
c) Received quarterly (Nov, Feb, May and Aug) for fiscal year
d) Annual billings to agencies underbudgeted. All payments have been received
e) Crooked River Ranch paid annual fee of $45,869
f) Revenue not expected this fiscal year
g) All payments have been received
Health Benefits Trust
Statement of Financial Operating Data
Twelve Months Ended June 30, 2011
PRELIMINARY (July 20, 2011)
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
PfF Emp - Add'I Prem
Employee Prem Contribution
COIC
Retiree / COBRA Co-Pay
Federal Payments
Prescription Rebates
Interest
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Claims Paid-Medical/Rx
Claims Paid-DentalNision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Deschutes Onsite Clinic:
Healthstat
Equipment
Remodel
Miscellaneous
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Revised Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 16,400,000 $ 16,988,140 $ 588,140 100% 104%
11,246,000
11,407,042
161,042
100%
101%
50,000
45,695
(4,305)
100%
91%
500,000
488,710
(11,290)
100%
98%
975,000
1,418,895
443,895
loo%
146%
450,000
732,526
282,526
100%
163%
-
93,496
93,496
100%
n/a
-
94,970
94,970
100%
n/a
100,000
109,027
9,027
loo%
1og%
13,321,000
14,390,360
1,069,360
loo%
108%
$16,400,000 $ 16,988,140 588,140
11,246,000
11,407,042
161,042
50,000
45,695
(4,305)
500,000
488,710
(11,290)
975,000
1,418,895
443,895
450,000
732,526
282,526
-
93,496
93,496
-
94,970
94,970
100,000
109,027
9,027
13,321,000
14,390,360
1,069,360
29,721,000 31,378,500 1,657,500 92% 106%
Exp.
29,721,000 31,378,500 1,657,500
129,280
127,664
1,616
100%
99%
129,280
127,664
1,616
12,450,194
12,306,832.23
143,362
100%
99% a)
12,450,194
12,306,832
143,362
1,871,377
1,785,072.26
86,305
1oo%
95% a)
1,871,377
1,785,072
86,305
-
(88,567)
88,567
100%
n/a
-
(88,567)
88,567
330,000
335,724
(5,724)
100%
102%
330,000
335,724
(5,724)
75,000
124,832
(49,832)
100%
166%
75,000
124,832
(49,832)
300,000
302,510
(2,510)
100%
101%
300,000
302,510
(2,510)
40,000
43,738
(3,738)
100%
109%
40,000
43,738
(3,738)
51,000
51,472
(472)
100%
101%
51,000
51,472
(472)
229,520
220,633
8,887
loo%
96%
14,500
32,368
(17,868)
100%
223%
121,600
123,907
(2,307)
100%
102%
61,900
53,195
8,705
100%
86%
151,141
51,982
99,159
100%
34%
15,696,232
15,343,699
352,533
100%
98%
100
-
100
100%
0%
13,895,388
-
13,895,388
100%
0%
229,520
220,633
8,887
14,500
32,368
(17,868)
121,600
123,907
(2,307)
61,900
53,195
8,705
151,141
51,982
99,159
15,696,232
15,343,699
352,533
100
-
100
13,895,388
-
13,895,388
29,721,000 15,471,363 14,249,638 100% 52%
NET (Resources - Requirements) - 15,907,138 15,907,138
Beginning NWC per Adopted Budget
29,721,000 15,471,363 14,249,638
15,907,138 15,907,138
15,500,000
a) Actual is an average of $269,294 per week.
Deschutes County - Fair and Expo Center
YTD-Budget Basis Commissioners
Statement of Financial Operating Data
Year Ended June 30, 2011
PRELIMINARY (July 20, 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
I I Actual Variance FY % Coll.
Budget
$ 2,809 $ 6,590 $ 3,781 100% 235%
677,742
589,683
(88,059)
100%
87%
2,000
746
(1,254)
100%
37%
51,000
45,992
(5,009)
100%
90%
9,000
1,391
(7,609)
100%
15%
42,000
31,855
(10,145)
100%
76%
211,000
170,164
(40,836)
100%
81%
93,000
117,738
24,738
100%
127%
45,000
45,000
-
100%
100%
4,414
28,059
23,645
100%
n/a
1,135,156
1,030,628
(104,529)
100%
91%
197,919
197,919
-
100%
100%
24,873
24,873
-
100%
100%
80,000
80,000
-
100%
100%
231,232
166,000
(65,232)
100%
72%
100
-
(100)
100%
0%
534,124
468,792
(65,332)
1,672,089 1,506,010 (166,079) 100% 90%
Exp.
931,893 862,123
576,685 578,626
115,563 115,561
100 -
1,624,241 1,556,310
69,770 100% 93%
(1,941) 100% 100%
2 100% 100%
100 100% 0%
67,931
10,000
- 10,000
100%
0%
37,848
- 37,848
100%
n/a
1,672,089 1,556,310 115,779 100% 93%
NET (Resources - Requirements) - (50,300) (50,300)
Beginning NWC per Adopted Budget 75,000
FY 2012 Community Grant Review Form
Requested Received
Healthy Families
$
36,769
$
36,500
Central Oregon Teen Challenge
$
36,000
$
5,000
Family Resource Center
$
32,282
$
32,000
Bethlehem Inn
$
30,000
$
15,000
Boys & Girls Club
$
30,000
$
30,000
Grandma's House
$
25,000
$
5,000
Saving Grace
$
25,000
$
15,000
Volunteers in Medicine
$
24,375
$
15,000
Deschutes County 4-H Leaders' Association
$
22,000
$
5,000
Neighborlmpact
$
22,000
$
15,000
Healthy Beginnings
$
20,000
$
9,000
MountainStar Family Relief Nursery
$
16,500
$
13,000
Family Kitchen
$
15,000
$
5,000
KIDS Center
$
15,000
$
10,000
La Pine Park & Recreation District
$
15,000
$
7,500
Pot of Gold
$
15,000
$
6,500
Interfaith Volunteer Caregivers
$
14,949
$
5,000
Bend's Community Center
$
14,872
$
10,000
Latino Community Association
$
13,930
$
10,000
Family Access Network
$
12,500
$
10,000
Assistance League of Bend
$
10,000
$
10,000
Cascade Youth & Family Center
$
10,000
$
13,000
Families Forward
$
10,000
$
5,000
La Pine Community Kitchen
$
10,000
$
10,000
Advantage Smiles for Kids
$
9,000
$
5,000
Together for Children
$
7,793
$
5,000
Backpacks in Bend
$
7,500
$
5,000
Jericho Road
$
7,500
$
7,500
Adventist Community Services
$
5,000
$
5,000
JCP
JCP
JCP
512,970 $ 325,000