2011-2773-Minutes for Meeting March 28,2011 Recorded 5/5/2011DESCHUTES COUNTY OFFICIAL
NANCY BLANKENSHIP, COUNTY
COMMISSIONERS' JOURNAL
Y~~1~1~Y~III~I~IUI
CLERKS w 1011'1113
05/05/201108:22:21 AM
Do not remove this page from original document.
Deschutes County Clerk
Certificate Page
-r C r~
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, MARCH 28, 2011
Present were Commissioners Tammy Baney and Tony DeBone; Commissioner
Alan Unger was out of the office. Also present were Dave Kanner, County
Administrator; Erik Kropp, Deputy County Administrator; and Marty Wynne,
Finance Director. No representatives of the media or other citizens were present.
Chair Baney opened the meeting at 1:30 p.m.
1. Tax/Finance Update.
Financial circumstances have not changed much in the last month. Investment
rates are still very low. The average is below 0.7, which is what is being
budgeted by the departments. The investment pool is at 0.5, which will hold for
about 18 months.
He went over general fund numbers relating to the Clerk's revenue. Other
departments are not yet projecting figures. Community Development is getting
some revenue from the Sunriver aquatic park project.
In regard to health care costs, claims may be about 7% higher by the end of the
year. This is better than in most situations. Dave Kanner said that the increase
in costs does not have to do with covering more individuals, but medical costs
in general. The costs of the new clinic are tracked separately, and those include
one-time costs of establishing the clinic and getting it supplied. The annual cost
of running the clinic will be about $500,000. A savings of more than that is
anticipated. Prescription costs may be a big part of future savings, as
prescription drugs cost about $2 million a year. There will be an RFP for the
prescription drug program since HealthStat cannot handle this. The County
would pay costs plus an administration fee, which will equal a huge savings to
the County and the employee.
Minutes of Board of Commissioners' Work Session Monday, March 28, 2011
Page 1 of 2 Pages
Regarding capital projects funds, the OSP project shows a significant amount
under budget. The savings can be used for debt service or another capital
project. It is proposed that these funds would be used to expand space for the
District Attorney and the Circuit Court. A square footage needs analysis will be
done soon. Chair Baney said she would like to see some of this money go to
the jail remodel project. She feels that the D.A. and Courts may ask for more
than they really need. Mr. Kanner stated that it is obvious that the D.A.'s
Office needs more space. A study would include what is actually needed now
and consideration given to what might be needed in the future. The fund will
be named the campus improvement fund.
There should be some funds remaining from the 9-1-1 project as well. Those
funds will be used for debt service on that project.
Chair Baney asked that during the budget process, some thought be given to
repaying the Solid Waste fund as well.
2. Other Items.
None were offered.
Being no further discussion, the meeting adjourned at 2:25 p.m.
DATED this Day of 2011 for the
Deschutes County Board of Commissioners.
a
Tammy Baney, Chair
ATTEST:
Recording Secretary
Anthony DeBone, Vice Chair
gj,a, Alan Unger, CoLkv~,
mmissioner
Minutes of Board of Commissioners' Work Session
Page 2 of 2 Pages
Monday, March 28, 2011
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 PM, MONDAY, MARCH 28, 2011
1. Tax/Finance Update - Marty Wynne
2. Other Items
PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real
property negotiations; ORS 192.660(2) (h), litigation; ORS 192.660(2)(d), labor negotiations; or ORS 192.660(2) (b), personnel issues.
Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at
1300 NW Wall St., Bend, unless otherwise indicated. lfyou 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.
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
March 28, 2011
(1) Monthly Investment Report
(2) February 2011 Financials
CO)
t l(
go
'
-
ti
M
to
~
°
GO
E
4
to
v
o
s
N
M
0
P-
R
to
M
m
}
y
t0
9
(O
to 0)
O
>
{i
O) '
at M
O
CO
P~ (v)
tp
1W
49
Fi
H
M
C
N N
N
n
0
N N
§
c
C
~ ~
m
m
LL
N 40
E Z
0
C
C C E
-
O
ar
m o U
U
EE
e
~
to
(D
C
0
L
0 4>1
0
J C
~
C
G F~
a~
U
seesO $ G
O R C 0"t0 0 O
C0tI0t9-00 S
r r-
It
U
.
o
p
O
' Q (O '
ti
'
b
A
N
C6
v;
r-
C
7
00
N
M
(D
C)
r
In
O
N
to 1 M
yNy
~ U
H t0
Call 4) N y V Q m
aZ_N48
U
y Q ¢ ~
EoUl=m(D sr
O O O N d
UUF- ~timJ h
o
C
11 U"?
W
(D
C
m
0
Document Reproduces Poorly
(Archived)
g\ s e g\ s
co
O O
wman 0
P N N N
C
0
t0
L m
c M a o
> >
N w. Z
C13
m
Q Q
N U y m
4
0
~
(j a
"0 r a
i
y
W
C e
Q.
Bch
LL
~
Q
H
C
d
N
a)
E
a) M
v
(
/1
d
1- C CO
C
m
0
N N
02.
00
a0
0z~
U
~
U
H
F-
m o
tL ~
J
L
a
M
i 1
p
z
'
z
z
Z
z
z
z
z
z
v
Z
1
z
Q
z
V
z
c~
2=
z
z
m
Z
z
N
>
a
m
~
z
N
>
_
3
N
>
_
3
t~
2'
~
c
8
z
Z
a
as
_
e
L
W
e
z
g
+
•
•
$
$
g
g
~
w
~e
S
i
~
$
~
~
~
0
0
oQ
3
~
'
0
~
e
r
e
~
e
~
'
l
a
8
N
1~ tD
NN
O
10
.
O
O
Q
Q
N
N
S
M
.
S
O
WD
O
a
s
N
O
O
O
S
g
.
.
.
.
8
8
N
V
C?
O
~
D
O
M
~
S
S
O
S
~
9
O
9
3
~
r
EOD
~
b
0
.
V
~
O
~
p N
Of
~
N
m
!
O
O
t0
♦ O
~[I
IA
Of
O
N
l'
M
O
N
pp
~
N
N
m
~
m
OI
O
~
O
m
N
n
W
O^i
0
~
0
~
0
n
tM0
O
~
aD
N
r
Q
O
G
O
O
~
CCpC
t'
tV
M
Oi
Q
u'9
^
O
tOpD
P
N
C
O
t7
O
pO
O
G
O
S
O
O
pp
aOD
~tph
Yf
CWD
~
N
~
•
~
V
t0
f
n
t~0
.
•
•
'
O
0
M
0
M
NO
N
O
O
O
N
3
l"p)
0
N
0
S
N
~
f09
O
O
O
O
N
O
~
{pp
Nl
O
0
o09
O
M
O
N
_
'
3
N
0
R
N
N
0
N
0
06
0
0
~
M
0
N
0
0
O
.
M
0
N
0
M
N
0
O
N
N
O
N
0
N
0
N
0
N
0
Q
r
M
M
W
p
3
p
^
M
IQ
m
C?
N
7
y
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
fV
N
N
N
~
N
N
N
N
~
N
N
N
N
N
N
N
N
N
N
^
~
N
~
N
~
V
O
N
M
N
O
O
C
co
M
C
N
N
N
O
O
O
LLY
I~
O
O
h
r
.
~p
~[f
o
O
O
0
O
O
C
O
O
p
OD
f~
P.
0
O
O
0
O
0
S
C
S
G
pp
O
S
pp
O
8
D
m
p
O
G
O
O
O
p
tlf
t7
l+Ml
M
M
pp
0
O
O
pp
0
O
O
oo
0
O
O
0
O
0
O
pp
0
p
0
W
oo
0
0
0
0
0
0
0 0
C G
0
G
0
C
pp
0
C
0
O
0
O
0
N
~p
O
aD
O
N
V
Y
IV
aa
fh
l+f
O
O
C^D
S
~
Y
OI
N
O
O
n
O
M
O
O
N
C'1
M
O
m
f~
^
N
O
pNi
t7
O
O
p
OD
OD
O
fD
t-
1~
N
G
N
O
Q
Q
3
O
Q
P
3
O
N
P
ttpp
M
O
ED
O
O
O
(O
N)
U'1
O
W
Oi
O
O
M
N
O
P
f0
h
O
N
N
O
M
N
Q
G
P
N
co
O~
N
O
p
~O
Oi
001
N
t0 C
Q
N
10
O tV
O
O
aD
O2
O
~
S I
O!
~l•
W
O!
aD
fV
O
'
O
C
O
a
p
O
O
OO
N
O
O
e
00
y
t 1
tp
00)~
y
O~
aND
W
aND
W
O
Q
OWi
tOV
to
S
-
OWl
y
Of
W
~p
O
O
n
O
~O
i
W
b
r
w
r
fV
fV
fV
N
N
fV
N
N
V
f
N
iV
N
N
(V
fV
N
N
fV
fV
fV
N
-71lV
Oi
o
u)
O
O
O
M
S
S
O
S
S
S
p
O
O
p
O
S
S
O
O
p
O
p
O
p
O
N
S
S
S
S
O
p
O
S
O
S
p
O
S
S
O
S
S
S
p O
p O
p O
p O'
?
0
0
8
p 0
0
8
Y
O
~
•
V
0
S
O
.e
P
Q
N
pp
O
p
p
0
O
p
0
O
0
O
0
0
S
t00
O
O
S
O
S
O
~ 0p
Ol
pp
O
tWO
m
N
1"
0
O
0
O
0
O
0
O
°P
N
O
O
p
S
O
S S 6
O
9
P
9
O
o
S
~ 0p
O
S
~O
p
0
O
0
tO
.
t0
8
P
p
.
OO
fl N
O
O
O
O
O
O
O
O
S
O
O
O
~
p
OD
2
tN0
N
w"
n
!1
W
O
S
t+l
3
W
0
O
pppp
0
SS
0
I~
0
^
O
O
S
O
0
88
0
Mm
0
S
0
pp
O
O
O
O
uY
M
O
N
O
O
pppp
O
O
N
8
O
W
O
S
O
pp
O
Q
O
W
T
Oi
W
N
S
O
O
_
papa ~O
d~
pOp
0
pppp
0
pCp
0
p Cp
0
pppp
0
C
W
el
W
m
p Q
3
h
N
N
N
N
-
N
N
N
N
fN
N
N
N
N
N
N
N
N
-
-
lV
N
N
N
N
N N
lV
fV
fV
N
tV
0
~
O
N
a
l
p
W
0
0
~
ae
~
~
ae
~
~
~
aR
~
~
-
o~
ae
~
X
~
K
K
•
i
~X
j
M
W
p
p
OD
N
M
N
f7
S
P
Y
f
S
m
N
N
O
O
tW0
tW0
m
1~
0
M^
tWO,
O
q
r
h
m
O'
^
w
t0
a
p
off
tM0
~
W
r
m
p
O
tWD
Y0f
tNO,
YMf
v
O
~
.
E
O
`
U
~
~
N
m
S
>
0
0
0
0
0
0
0
0
0
.
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
O
•
•
m
~
F'
m
Y
•
U
U
'
~
~i
m
U.~
,
,
,
X
~
X
S
S
r0
w
°m
~Oo
~
b
_
g
n
-
N
pqo
~pp?
8
N
N
8
9
o
S
~
o
~
"
V
G
G
m
O
G
C
M
O
J
iff
~
.
C
N
O
O
C
G
G
O
f
G
N
C
O
O
O
O
C
G
j
1
•
4
•
IS
O
N
^
N
t0
1~
^
O
^
W
W
M
M
f~
W
w
O
r^o
N
c`i
W
s
W
s
m
s
m
.
co
uZ
m
u^i
^
~
m
~
^
~
W
~
N
^
ao
n
P
m
~
n
M
°
1~
~
n
n
N
~
~
n
n
n
r
n
N
•
S
a+
3
4
n
u
~
n
m
~
^
~
~
^
~
a"
~
a
^
~
a
~
a
;
~
~
~
~
~
PS
^
F
'
.
.
^
F
N
F
N
N
'
N
^
N
N
"
^
'
N
N
^
N
`
N
N
`
N
M
•
>
`a
c
c
g
~
o
e
e
e
e
e
c
c
~
e
c
o
0
O
O
~
c
W
c
W
~
a
a
a
12
_
~
a
e
~
>
o
3
0
0
0
~
o
o
o
°
°
~
.
S
S
o
O
O
~
~
$
W
O
W
WWQ
O'
W
W
O'
O~
G
O'
O~
C
O'
C_
O^
O^
G_
.12
O'
.12
O
c
01
t3
p
a
~
c
n
e
c
c
;
,
t+~
c
e
'
'
e
e
A
c
N
c
l+Z
~
n
e
A
c
n
A
e
N
c
a
N
N
r
t~
a
t~
c
e
t+Z
Z
1~
~~VV
t~
e
~
W
c
e
W
e
W
e
m
~
e
~
0
1
0
N
N
N
~
0
0
(p
0
M
0
t
7
0
0
M
0
0
0
0
a
0
I~
0
-
N
N
^
O
O
O
~
N
0
W
0
0
O
0
OZ
0
N
0
a
0
~
O
~
N
~
O
~
Y
r
n
r
z
~
~c
~
~
~
.l
a
F•
w
~
z
3
~
L
c~
=
v
t
~
D
f-
r
NRl
U
U
LL
O
O
LL
U
U
LL
LL
LL
V
LL
Or
Or
LL
LL
LL
LL
LL
LL
LL
LL
LL
LL
U
LL
U
LL
taL
lal
LL
LL
LL
3
m
U
2
to
2
N
m
N
M
m
Y
2
m
a
LL
a
o.
Z
v1
2
w
LL
3
m
m
m
m
C
U
1
m
U
m
a
2
m
a
3
a
a
z
v1
z
v1
z
u1
z
w
LL
3
-i
0.
LL
x
2
fn
LL
2
N
LL
3
~
0-
2
M
~
O.
Z
m
LL
x
m
h
N
^
f0
tz
•[I
m
a-
I~
M
N
W
N@
♦Q
Z
jQ(
M
fP
U
M
(O
MQ
f
m
;
NOQQ
>
tU
~
M
>
♦
^
M
Q
3
X
N
n
N
,~Q,
q
a
Q
M
t
y
W
N
t
M
i
O
M
M
tM+l
M
W
M
M
tg
l
M
M
lW+f
M
r
M
t
p
S
M
M
M
N
M
S
lh
M
M
M
M
M
M
r
M
M
M
M
M
M
M
M
m
M
M
S
M
M
M
M
M
O
O
V
0
0
C
O
V
G
V
V
z
U
V
z
U
O
m
mW
Y~j~
GU
N
N
`
N
N
[m]
N
'
Z
U
U
U
V
U
m
U
'
U
U
V
9
0
@
m
m
N
a
m
A
W
m
N
s
c
o
~
a
a
o
z
m
~
'
m
U
m
z
z
m
c
S
f
m
~
€
Z
v1
m
I
m
I
U
y
vii
.
.
m
»
m
>
m
O
V
W
U
V
3
co
3
m
m
m
U
m
m
ro
u.
y
'G
7,~5
w
i
O
c
m
m
O
c
m
m
E
3
o
c>
LL
m
x
N
m
m
x
'
a
E
g
a
U
m
s
0
m
v)
5
o
m
.L$
3
vi
j
E
~
u*
m
3
O
m
m
m
E
o
U
A
o
U
N
a
m
LL
m
E
~
m
7
m
m
m
U
m
UI
LL
~
m
U
m
U
m
J
m
U
.
33
~
m
J
~
J
m
J
m
J
m
J
~
J
m
U
m
U
m
U
m
U
m
U
i
•
L
.
.S
.
~
U
S
LL
)
O
m
~
V1
m
Y
LL
LL
~
~
.
LL
LL
LL
LL
2
LL
LL
LL
0
2
LL
O
U
~
m
~
L
L
d
~
=
LL
=
LL
=
LL
=
LL
LL
LL
LL
LL
2
LL
LL
LL
Z
u.
q~
Z
u.
Z
LE
LL
LL
C
O
_
Memorandum
Date: March 15, 2011
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find February 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
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes
Gen. Rev. - excl. Taxes
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non-Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS
NET (Resources - Requirements)
GENERAL FUND
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date Revised Year End $
Budget Actual Variance FY % C011. % Budget Projection Variance
$ 8,300,000
$ 9,677,699 $
1,377,699
100%
117%
$8,300,000
$9,677,699
$ 1,377,699
13,710,667
19,883,396
6,172,729
67%
97%
20,566,000
20,996,770
430,770
1,598,092
1,913,493
315,401
67%
80% a)
2,397,138
2,397,138
-
530,460
643,935
113,475
67%
81% b)
795,690
795,690
-
813,809
1,006,396
192,587
67%
82%
1,220,714
1,220,714
-
8,265
1,213
(7,052)
67%
10%
12,398
12,398
-
209,400
117,650
(91,750)
67%
37%
314,100
270,300
(43,800)
120,133
162,880
42,747
67%
90% b)
180,200
180,200
-
45,244
33,772
(11,472)
67%
50%
67,866
67,866
-
60,755
66,102
5,347
67%
73%
91,132
91,132
-
1,333
1,333
0
67%
67%
2,000
2,000
-
17,098,158
23,830,171
6,732,013
67%
93%
25,647,238
26,034,208
386,970
25,398,158
33,507,870
8,109,712
67%
99%
33,947,238
35,711,907
1,764,669
Exp.
2,254,813
2,112,459
142,354
989,418
865,893
123,525
50,269
37,466
12,803
3,254,751
3,183,478
71,273
564,607
562,379
2,228
174,798
173,478
1,320
168,818
167,897
921
74,802
73,345
1,457
1,479,591
833,771
645,820
3,363,516
-
3,363,516
12,375,383
8,010,165
4,365,218
9,849,443
10,273,302
(423,859)
22,224,826
18,283,467
3,941,359
3,173,332
15,224,403
12,051,071
Beginning NWC per Requested Budget
67%
62%
3,382,219
3,382,219
-
67%
58%
1,484,127
1,484,127
-
67%
50%
75,403
75,403
-
67%
65%
4,882,127
4,748,714
133,413
67%
66%
846,910
846,910
-
67%
66%
262,197
262,197
-
67%
66%
253,227
253,227
-
67%
65%
112,203
112,203
-
67%
38%
2,219,387
2,219,387
-
67%
n/a
5,045,274
-
5,045,274
67%
43%
18,563,074
13,384,387
5,178,687
67%
70% c)
14,774,164
14,774,164
-
67%
55%
33,337,238
28,158,551
5,178,687
d)
610,000
7,553,356
6,943,356
7,300,000
a) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
b) YTD Actual includes A&T grant received quarterly in advance
c) Revised Budget and Year End Projection include $1.8 million transfer of "one time resources".
d) Appropriation transferred to Fund 575 - $610,000
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Budget Actual Variance FY % Coll. %
RESOURCES:
Beg. Net Working Capital $
987,000
$1,039,997 $
52,997
Revenues
Federal Grants
10,351
3,882
(6,469)
SB #1065-Court Assess.
40,000
32,758
(7,242)
Discovery Fee
10,667
9,441
(1,226)
Food Subsidy
25,333
15,675
(9,658)
OYA Basic & Diversion
226,671
48,917
(177,754)
Inmate/Prisoner Housing
66,667
46,500
(20,167)
Inmate Commissary Fees
67
92
25
Contract Payments
58,993
39,448
(19,545)
Miscellaneous
200
61
(139)
MIP Diversion Fees
667
150
(517)
Interest on Investments
11,333
5,637
(5,696)
Leases
1,600
1,600
-
Grants - Private
333
327
(6)
Health & Human Svcs Chg
4,000
3,319
(681)
CCF Interfund Grant
40,330
48,250
7,920
Gen Fund Grant-Crime Prev.
13,333
10,000
(3,333)
Total Revenues
510,545
266,057
(244,488)
100% 105%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
Transfers In-General Fund 3,695,457 3,695,457 - 67%
TOTAL RESOURCES 5,193,002 5,001,511 (191,491) 67%
REQUIREMENTS:
Expenditures
Community Justice-Juvenile
Personal Services
Materials and Services
Capital Outlay
Juvenile Resource Center
Personal Services
Materials and Services
Contingency
67%
69%
Exp.
Revised Year End
Budget Projection Variance
25% a)
55%
59%
41% b)
14% C)
47% d)
92%
45%
20%
15%
33%
67%
65%
55%
80% b)e)
50%
35%
$ 987,000 $1,039,997 $ 52,997
15,527
15,527
-
60,000
57,500
(2,500)
16,000
16,000
-
38,000
37,000
(1,000)
340,006
266,358
(73,648)
100,000
80,000
(20,000)
100
100
-
88,490
70,000
(18,490)
300
100
(200)
1,000
300
(700)
17,000
9,000
(8,000)
2,400
2,400
-
500
500
-
6,000
6,000
-
60,495
96,500
36,005
20,000
20,000
-
765,818
677,285
(88,533)
5,543,186 5,543,186 -
7,296,004 7,260,468 (35,536)
1,975,971
1,818,292
157,679
67%
61% f)
2,963,956
2,725,000
238,956
799,924
672,151
127,773
67%
56% 9)
1,199,886
1,100,000
99,886
67
-
67
67%
0%
100
-
100
1,543,403
1,419,498
123,905
67%
61% h)
2,315,104
2,200,000
115,104
116,996
109,306
7,690
67%
62%
175,494
167,000
8,494
427,643
-
427,643
67%
n/a
641,464
-
641,464
TOTAL REQUIREMENTS 4,864,004 4,019,247 844,757 67% 55% 7,296,004 6,192,000 1,104,004
NET (Resources - Requirements) 328,998 982,264 653,266 - 1,068,468 1,068,468
Beginning NWC per Requested Budget 1,101,374
a) Second quarter Federal Grant anticipated in March ($7,000 request for reimbursement recently submitted)
b) Reimbursements for food subsidy received approximately one month after monthly billings, CCF billed quarterly
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)
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) Salary 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) Salary savings due to less on-call and overtime for the detention facility
SHERIFF - Fund 255
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ -
$ -
$ -
100%
n/a
$ -
$ -
$ -
Revenues
Law Enf Dist Countywide
15,219,638
12,025,594
(3,194,044)
67%
53%
22,829,457
18,778,182
(4,051,275)
67%
55%
Total Revenues
24,330,264
19,535,735
(4,794,529)
67%
54%
36,495,396
30,240,631
(6,254,765)
TOTAL RESOURCES
24,330,264
19,535,735
(4,794,529)
67%
54%
36,495,396
30,240,631
(6,254,765)
REQUIREMENTS:
-Exp.
EXPENDITURES & TRANSFERS
Sheriffs Division
1,924,445
2,174,950
(250,505)
67%
75% a)
2,886,668
2,953,668
(67,000)
Civil
548,291
539,827
8,464
67%
66% b)
822,436
773,336
49,100
Automotive/Communications
968,691
1,074,152
(105,461)
67%
74% b)
1,453,036
1,417,016
36,020
Investigations/Evidence
1,100,528
996,209
104,319
67%
60% b)
1,650,792
1,535,737
115,055
Patrol/Civil/Comm Supp
5,320,434
5,079,838
240,596
67%
64% b)
7,980,651
7,724,351
256,300
Records
440,257
403,493
36,764
67%
61% b)
660,386
637,286
23,100
Adult Jail
6,569,909
5,753,604
816,305
67%
58% c)
9,854,864
9,433,364
421,500
Court Security
187,234
178,828
8,406
67%
64%
280,851
273,751
7,100
Emergency Services
116,294
110,792
5,502
67%
64%
174,441
169,341
5,100
Special Services Division
778,269
705,307
72,962
67%
60% d)
1,167,404
1,241,404
(74,000)
Regional Work Center
1,928,161
1,749,096
179,065
67%
60% e)
2,892,242
2,701,142
191,100
Training Division
220,000
160,665
59,335
67%
49% f)
330,000
304,900
25,100
Other Law Enforcement Svcs
397,945
393,089
4,856
67%
66%
596,917
592,317
4,600
Non-Departmental
188,679
55,345
133,334
67%
20%
283,018
283,018
-
Contingency
3,507,793
-
3,507,793
67%
n/a
5,261,690
-
5,261,690
Transfer Out - Jail Remodel
66,667
100,000
(33,333)
67%
n/a
100,000
100,000
Transfers Out - D/S Fund
66,667
60,539
6,128
67%
61%
100,000
100,000
-
TOTAL REQUIREMENTS
NET (Resources - Requirements)
24,330,264 19,535,735 4,794,529 67% 54% 36,495,396 30,240,631 6,254,766
Beginning NWC per Requested Budget
a) Higher than budgeted employee vacation sell back and legal labor expenses
b) Delay in filling open positions will result in lower personnel expenditures for FY 2011
c) Unfilled budgeted positions and less than planned jail bed rental. Forecast includes $146,000
for jail bed rental and $350,000 for JMS software in Qtr 3 & Qtr 4
d) Purchase of new marine patrol boat will be reimbursed by State and higher personnel expenses due to promotions
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
Eight Months Ended February 28, 2011
Year to Date Year End
Budget Actual Variance FY % Coll. % Bud et Projection Variance
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
$4,722,862
$ 5,609,156
$ 886,294
9,902,396
14,052,826
4,150,430
428,000
606,484
178,484
23,333
46,415
23,082
32,317
54,332
22,015
3,333
-
(3,333)
1,316,440
1,480,995
164,555
3,333
-
(3,333)
63,333
63,237
(96)
-
3,454
3,454
100,000
154,996
54,996
2,667
424
(2,243)
-
4,185
4,185
32,000
44,992
12,992
16,667
42,810
26,143
4,000
2,700
(1,300)
3,333
5,200
1,867
3,333
4,200
867
-
9,520
9,520
8,000
13,142
5,142
667
3,390
2,723
106,667
162,146
55,479
18,889
33,075
14,186
2,355
1,546
(809)
-
2,500
2,500
-
200
200
-
1,257
1,257
12,071,063
16,794,028
4,722,965
100%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
119%
95%
94%
133% a)
112%
0%
75% a)
0%
67%
n/a
103% a)
11%
n/a
94%
171 % b)
45%
104%
84%
n/a
110%
339%
101 % C)
117%
44%
n/a
n/a
n/a
93%
$ 4,722,862
$ 5,609,156
$ 886,294
14,853,594
14,853,594
-
642,000
727,000
85,000
35,000
46,415
11,415
48,475
71,627
23,152
5,000
5,000
-
1,974,660
1,854,660
(120,000)
5,000
5,000
-
95,000
95,000
-
-
3,454
3,454
150,000
154,996
4,996
4,000
4,000
-
-
4,185
4,185
48,000
68,000
20,000
25,000
50,000
25,000
6,000
6,000
-
5,000
5,200
200
5,000
5,000
-
-
15,000
15,000
12,000
18,000
6,000
1,000
5,000
4,000
160,000
220,000
60,000
28,333
53,075
24,742
3,533
3,533
-
-
2,500
2,500
-
200
200
-
1,257
1,257
18,106, 595
18, 277, 697
171,102
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 Requirements
16,793,925 22,403,184 5,609,259
67% 98%
FE 22,829,457 23,886,853 1,057,396
1,820,525
2,057,502
(236,977)
67%
75%
2,730,788
2,794,170
(63,382)
548,291
539,827
8,464
67%
66%
822,436
773,336
49,100
348,729
386,695
(37,966)
67%
74%
523,093
510,126
12,967
6,569,909
5,753,604
816,306
67%
58%
9,854,864
9,433,364
421,500
187,234
178,828
8,406
67%
64%
280,851
273,751
7,100
116,294
110,792
5,502
67%
64%
174,441
169,341
5,100
628,842
569,888
58,953
67%
60%
943,262
1,003,054
(59,792)
1,928,161
1,749,096
179,065
67%
60%
2,892,242
2,701,142
191,100
134,200
98,006
36,194
67%
49%
201,300
185,989
15,311
397,945
393,089
4,856
67%
66%
596,917
592,317
4,600
27,728
27,728
(0)
67%
67%
41,592
41,592
-
66,667
60,539
6,128
67%
61%
100,000
100,000
-
66,667
100,000
(33,333)
67%
100%
100,000
100,000
-
66,667
-
66,667
67%
0%
100,000
100,000
-
2,311,780
-
2,311,780
67%
0%
3,467,671
-
3,467,671
15,219,638
12,025,594
3,194,043
53%
22,829,457
18,778,182
4,051,275
Net 1,574,287 10,377,590 8,803,303
Beginning NWC per Requested Budget
a) Anticipated funding reduction from Dept. of Corrections
b) Contract revenue from USFS is higher than anticipated
c) Actual revenue for concealed weapons permits and civil papers will exceed budget
5,108,671 5,108,671
5,108,671
Fund 702 LED Rural
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
I
Coll. %
I
Budget
Projection
I I
Variance
RESOURCES:
Beg. Net Working Capital
$1,905,939
$ 2,498,487
$ 592,548
100%
131%
$1,905,939
$ 2,498,487
$ 592,548
Revenues
Tax Revenues - Current
5,005,497
7,078,436
2,072,939
67%
94%
7,508,247
7,508,247
-
Tax Revenues - Prior
209,333
302,156
92,823
67%
96%
314,000
371,000
57,000
Federal Grants
1,333
7,162
5,829
67%
358%a)
2,000
10,000
8,000
Federal Grants-BLM
-
7,608
7,608
67%
n/a
-
10,000
10,000
US Forest Service
51,000
64,125
13,125
67%
84%
76,500
78,750
2,250
State Grant
125,089
73,926
(51,163)
67%
39%
187,633
187,633
-
SB #1065 Court Assessm(
44,667
32,758
(11,909)
67%
49%
67,000
50,000
(17,000)
Marine Board License Fee
94,955
-
(94,955)
67%
0%b)
142,433
187,433
45,000
Des Cry General Fund Gra
468,239
-
(468,239)
67%
0% c)
702,358
702,358
-
Des Cty Transient Room 1
1,298,428
1,298,428
-
67%
67%
1,947,642
1,947,642
-
City of Sisters
288,437
288,437
(0)
67%
67%
432,655
432,655
-
Des Cty Tax/Fin Contract
667
-
(667)
67%
0%
1,000
1,000
-
Des Cty CDD Contract
36,244
36,244
-
67%
67%
54,366
54,366
-
Des Cty Solid Waste Cont
36,244
36,244
-
67%
67%
54,366
54,366
-
Des Cty Clerk/Election
1,333
675
(658)
67%
34%
2,000
2,000
-
School Districts
66,667
32,725
(33,942)
67%
33%d)
100,000
50,000
(50,000)
Claims Reimbursement
-
8,472
8,472
67%
n/a
-
8,472
8,472
Security & Traffic Reimb
8,667
1,081
(7,586)
67%
8%
13,000
13,000
-
Seat Belt Program
4,000
4,175
175
67%
70%
6,000
6,000
-
Miscellaneous
6,667
8,100
1,433
67%
81%
10,000
10,000
-
Restitution
333
-
(333)
67%
0%
500
500
-
Sheriff Fees
6,667
6,440
(227)
67%
64%
10,000
10,000
-
Court Fines & Fees
56,667
81,523
24,856
67%
96%e)
85,000
120,000
35,000
Impound Fees
10,000
4,300
(5,700)
67%
29%
15,000
15,000
-
Restitution - Street Crimes
333
-
(333)
67%
0%
500
500
-
Interest
6,667
13,500
6,833
67%
135%
10,000
20,000
10,000
Interest on Unsegregated
1,200
777
(423)
67%
43%
1,800
1,800
-
Donations
-
4,090
4,090
67%
n/a
-
5,000
55,000
Sale of Reportable Assets
6,667
32,762
26,095
67%
328% f)
10,000
32,762
22,762
Sale of Equip & Material
4,000
3,275
(725)
67%
55%
6,000
10,000
4,000
Total Revenues
7,840,001
9,427,420
1,587,419
50%
80%
11,760,000
11,900,484
140,484
TOTAL RESOURCES
9,745,940
11,925,907
2,179,967
50%
87%
13,665,939
14,398,971
733,032
REQUIREMENTS:
EXp.
Department
Sheriffs Services
103,920
117,447
(13,527)
67%
75%
155,880
159,498
(3,618)
Auto/Comm
619,962
687,457
(67,495)
67%
74%
929,943
906,890
23,053
Investigations
1,100,528
996,209
104,319
67%
60%
1,650,792
1,535,737
115,055
Patrol
5,320,434
5,079,838
240,596
67%
64%
7,980,651
7,724,351
256,300
Records
440,257
403,493
36,764
67%
61%
660,386
637,286
23,100
Special Services
149,428
135,419
14,009
67%
60%
224,142
238,350
(14,208)
Training
85,800
62,660
23,140
67%
49%
128,700
118,911
9,789
Internal Services
27,617
27,617
-
67%
67%
41,426
41,426
-
Transfer for Reserve Fund
66,667
-
66,667
67%
0%
100,000
100,000
-
Contingency
1,196,013
-
1,196,013
67%
0%
1,794,019
-
1,794,019
55%
Net
635,314
4,415,766
3,780,452
-
2,936,523
2,936,523
Beginning NWC per Requested Budget 2,936,523
a) Actual HIDTA overtime reimbursement higher than budgeted
b) Payments are received in Feb & June
c) Grant will be received in June 2011
d) Most of this revenue is received in Quarters 3 & 4
e) Revenue from traffic fines will exceed budget
f) Proceeds from sale of used patrol vehicles were higher than estimated
PUBLIC HEALTH
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
I
I
Budget
I
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,100,000
$ 1,615,306
$ 515,306
100%
147%
$1,100,000
$1,615,306
$ 515,306
Revenues
Medicare Reimbursement
5,333
147
(5,186)
67%
2%
8,000
200
(7,800)
State Grant
1,675,318
1,515,680
(159,638)
67%
60%
a)
2,512,977
2,613,704
100,727
Child Dev & Rehab Center
20,506
7,690
(12,816)
67%
25%
30,759
30,759
-
State Miscellaneous
146,597
149,615
3,018
67%
68%
219,896
269,334
49,438
OMAP
318,533
382,572
64,039
67%
80%
477,800
520,000
42,200
Family Planning Exp Proj
330,000
314,976
(15,024)
67%
64%
495,000
520,000
25,000
Grants
43,333
75,350
32,017
67%
116%
b)
65,000
113,773
48,773
Water Program-Base Fee
28,000
18,772
(9,228)
67%
45%
42,000
42,000
-
Water Program-Field Work
37,211
33,880
(3,331)
67%
61%
55,817
55,817
-
H20 Sys Insp-Priv Wells
133
-
(133)
67%
0%
200
200
-
Miscellaneous
-
83
83
67%
n/a
-
201
201
Patient Insurance Fees
126,840
93,927
(32,913)
67%
49%
c)
190,260
135,000
(55,260)
Health Dept/Patient Fees
99,317
72,477
(26,840)
67%
49%
c)
148,975
103,500
(45,475)
Vital Records-Birth
24,000
20,205
(3,795)
67%
56%
36,000
30,000
(6,000)
Vital Records-Death
65,333
66,645
1,312
67%
68%
98,000
96,000
(2,000)
Environmental Health
458,233
650,294
192,061
67%
95%
d)
687,350
687,350
-
Interest on Investments
11,267
7,522
(3,745)
67%
45%
16,900
11,200
(5,700)
Donations
4,000
31,602
27,602
67%
527%
e)
6,000
35,430
29,430
Interfind Contract
126,252
20,480
(105,772)
67%
11%
189,378
162,513
(26,865)
Administrative Fee
18,000
18,000
-
67%
67%
27,000
27,000
-
Drug Court Byrne
-
4,157
4,157
67%
n/a
-
4,157
4,157
Total Revenues
3,538,206
3,484,074
(54,132)
67%
66%
5,307,312
5,458,138
150,826
Transfers In-General Fund
1,545,178
1,545,178
-
67%
67%
2,317,765
2,317,765
-
Transfers In-PH Res Fund
44,749
33,562
(11,187)
67%
50%
67,123
67,123
-
Transfers In-Gen. Fund Other
45,208
33,906
(11,302)
67%
50%
67,812
67,812
-
TOTAL RESOURCES
6,273,341
6,712,026
438,685
67%
76%
8,860,012
9,526,144
666,132
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
FEXP,
3,904,775
3,796,573
108,202
67%
65%
5,857,162
5,784,000
73,162
1,336,925
1,312,138
24,787
67%
65%
2,005,387
1,970,226
35,161
16,667
5,432
11,235
67%
22%
25,000
25,000
-
100,000
75,000
25,000
67%
50%
150,000
150,000
-
548,309
-
548,309
67%
n/a
822,463
-
822,463
5,906,676
5,189,143
717,533
67%
59%
8,860,012
7,929,226
930,786
366,665
1,522,883
1,156,218
-
1,596,918
1,596,918
Beginning NWC per Requested Budget
1,596,918
a) State grant through Revision #4, supplemental grant appropriation to be submitted
b) Health Matters-local grant for Chronic Care Program is $17,000 & $21,000. Biotenorism NACCHO grant $10,000 received in July
c) Projection reflects fewer patients covered under private insurance and self pay reflects current economics
d) Environmental Health fees are due and collected primarily in January
e) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3550 HIV sponsorship donation
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 2,616,050 $
2,651,262
$ 35,212
100%
101%
$ 2,616,050
$ 2,651,262
$ 35,212
Revenues
Marriage Licenses
3,667
3,470
(197)
67%
63%
5,500
5,500
-
Divorce Filing Fees
86,667
90,765
4,098
67%
70%
130,000
130,000
-
Domestic Partnership Fee
667
35
(632)
67%
4%
1,000
100
(900)
Federal Grants
64,646
44,741
(19,905)
67%
46%
a)
96,969
96,969
-
State Grants
4,032,995
3,951,033
(81,962)
67%
65%
b)
6,049,493
5,893,958
(155,535)
State Miscellaneous
98,782
56,921
(41,861)
67%
38%
148,173
148,173
-
ABHA
-
26,417
26,417
67%
n/a
-
160,938
160,938
Title 19
200,617
73,912
(126,705)
67%
25%
300,925
125,000
(175,925)
Liquor Revenue
70,267
75,487
5,220
67%
72%
105,400
105,400
-
School Districts
46,667
41,140
(5,527)
67%
59%
70,000
70,000
-
Miscellaneous
11,267
29,656
18,389
67%
175%
16,900
34,000
17,100
Patient Insurance Fees
102,667
46,077
(56,590)
67%
30%
154,000
75,000
(79,000)
Patient Fees
8,667
1,375
(7,292)
67%
11%
13,000
3,000
(10,000)
Interest on Investments
29,057
15,524
(13,533)
67%
36%
43,585
25,000
(18,585)
Rentals
8,733
11,875
3,142
67%
91%
13,100
13,100
-
InterFund Contract-Gen. Fund
84,667
79,542
(5,125)
67%
63%
a)
127,000
127,000
-
Comm. on Children & Fam
16,000
-
(16,000)
67%
0%
c)
24,000
-
(24,000)
Administrative Fee
2,807,638
2,819,223
11,585
67%
67%
4,211,457
4,211,457
-
Total Revenues
7,673,671
7,367,193
(306,478)
67%
64%
11,510,502
11,224,595
(285,907)
Transfers In-General Fund
877,439
877,439
-
67%
67%
1,316,158
1,316,158
-
Transfers In-OHP-CDO
66,666
66,666
-
67%
67%
100,000
100,000
-
Transfers In-Acute Care Svcs
243,772
243,772
-
67%
67%
365,657
365,657
-
Transfers In-ABHA
445,501
334,126
(111,375)
67%
50%
668,252
668,252
-
TOTAL RESOURCES
11,923,099
11,540,458
(382,641)
67%
70%
16,576,619
16,325,924
(250,695)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
6,263,086
5,883,573
379,513
67%
63%
d)
9,394,629
8,850,000
544,629
Materials and Services
3,172,355
2,396,051
776,304
67%
50%
4,758,532
3,600,000
1,158,532
Capital Outlay
510,667
159,403
351,264
67%
21%
766,000
450,000
316,000
Transfers Out
104,776
75,000
29,776
67%
48%
157,164
157,164
-
Contingency
1,000,196
-
1,000,196
67%
n/a
1,500,294
-
1,500,294
TOTAL REQUIREMENTS
11,051,080
8,514,027
2,537,053
67%
51%
16,576,619
13,057,164
3,519,455
NET (Resources - Requirements)
872,019
3,026,431
2,154,412
-
3,268,760
3,268,760
Beginning NWC per Requested Budget 3,268,759
a) Grant billing 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
Eight Months Ended February 28, 2011
RESOURCES:
Beg. Net Working Capital
Revenues
Admin-Operations
Admin-GIS
Admin-Code Enforcement
Building Safety
Electrical
Contract Services
Env Health-On Site Prog
Planning-Current
Planning-Long Range
Total Revenues
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 686,081
613,031
$ (73,050)
100%
89%
$ 686,081
$ 613,031
(73,050)
11,000
11,196
196
67%
68%
16,500
15,650
(850)
1,833
4,194
2,361
67%
152%
a)
2,750
4,376
1,626
107,812
98,758
(9,054)
67%
61%
161,718
164,200
2,482
720,811
572,125
(148,686)
67%
53%
b)
1,081,217
1,000,550
(80,667)
177,768
155,707
(22,061)
67%
58%
266,652
259,150
(7,502)
122,667
131,990
9,323
67%
72%
c)
184,000
235,200
51,200
189,220
167,140
(22,080)
67%
59%
283,830
280,400
(3,430)
517,975
448,676
(69,299)
67%
58%
d)
776,962
683,400
(93,562)
235,847
157,079
(78,768)
67%
44%
e)
353,771
337,612
(16,159)
2,084,933
1,746,864
(338,069)
67%
56%
3,127,400
2,980,538
(146,862)
Trans In-GF 168,924 168,925 0 67% 67% 253,387 253,387 -
Trans In-GF for Lng Rng Ping 344,000 344,000 - 67% 67% 516,000 516,000 -
TOTAL RESOURCES 3,283,938 2,872,820 (411,119) 67% 63% 4,582,868 4,362,956 (219,912)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin-Operations
934,931
923,592
11,339
Admin-GIS
144,090
122,446
21,644
Admin-Code Enforcement
123,155
122,718
437
Building Safety
333,553
336,063
(2,510)
Electrical
125,071
117,336
7,735
Contract Services
162,834
156,181
6,653
Env Health-On Site Pgm
154,671
154,895
(224)
Planning-Current
460,193
408,895
51,298
Planning-Long Range
328,285
352,501
(24,216)
Transfers Out (D/S Fund)
115,540
145,000
(29,460)
Contingency
172,923
-
172,923
Exp.
67%
66%
1,402,396
1,391,651
10,745
67%
57%
f)
216,135
158,312
57,823
67%
66%
184,732
182,607
2,125
67%
67%
g)
500,330
479,817
20,513
67%
63%
187,606
183,756
3,850
67%
64%
g)
244,251
225,066
19,185
67%
67%
h)
232,006
183,725
48,281
67%
59%
i)
690,290
631,208
59,082
67%
72%
j)
492,427
523,682
(31,255)
67%
84%
173,310
173,310
-
67%
n/a
259,385
-
259,385
TOTAL REQUIREMENTS 3,055,246 2,839,627 215,619 67% 62%
NET (Resources - Requirements) 228,692 33,192 (195,500)
Beginning NWC per Requested Budget
Revenues 1,746,864
Expenditures 2,839,627
Net from Operations (1,092,764)
4,582,868 4,133,134 449,734
229,822 229,822
229,822
3,127,400 2,980,538 (146,862)
4,582,868 4,133,134 449,734
(1,455,468) (1,152,596) 302,872
a) Custom GIS work revenue sporadic. Includes webmaster work for Health Dept
b) YTD revenue is low in relation to budget, it is expected that final revenue will be closer to budget projections, as several large projects
are expected to generate significant revenue later in the fiscal year ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant)
c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue and DNF project
d) YTD business volume/revenue less than expected
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 expense higher than budgeted associated with timing of grant revenue received in FY 2010
ROAD
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
I
Year End
Budget
Actual
Variance
FY %
Coll. %
I
L Budget
Projection
I
Variance
RESOURCES:
Beg. Net Working Capital
$ 3,430,429
$ 3,419,603
$ (10,826)
100%
100%
$ 3,430,429
$ 3,419,603
$ (10,826)
Revenues
Mineral Lease Royalties
13,333
34,077
20,744
67%
170%
20,000
40,000
20,000
Forest Receipts
1,491,333
2,237,091
745,758
67%
100%
a)
2,237,000
2,237,091
91
State Miscellaneous
64,656
-
(64,656)
67%
0%
b)
96,984
-
(96,984)
Motor Vehicle Revenue
6,666,667
5,838,650
(828,017)
67%
58%
c)
10,000,000
9,400,000
(600,000)
City of Bend
183,333
215,049
31,716
67%
78%
d)
275,000
275,000
-
City of Redmond
233,333
250,458
17,125
67%
72%
d)
350,000
350,000
-
City of Sisters
6,667
-
(6,667)
67%
0%
d)
10,000
10,000
-
City of La Pine
6,667
-
(6,667)
67%
0%
d)
10,000
10,000
-
Admin Recovery (SDC)
-
951
951
67%
n/a
-
1,000
1,000
Miscellaneous
60,000
19,778
(40,222)
67%
22%
90,000
90,000
-
Road Vacations
667
500
(167)
67%
50%
1,000
500
(500)
Interest on Investments
26,667
14,390
(12,277)
67%
36%
40,000
20,000
(20,000)
Other Bank/LGIP Interest
-
61
61
67%
n/a
-
62
62
Parking Fees
600
-
(600)
67%
0%
900
-
(900)
Grants-Private
-
2,434
2,434
67%
n/a
-
2,434
2,434
Interfund Contract
500,000
234
(499,766)
67%
0%
e)
750,000
700,000
(50,000)
Equipment Repairs
166,667
120,113
(46,554)
67%
48%
250,000
190,000
(60,000)
Vehicle Repairs
60,000
-
(60,000)
67%
0%
90,000
90,000
-
LID Construction
6,667
-
(6,667)
67%
0%
e)
10,000
-
(10,000)
Vegetation Management
23,333
-
(23,333)
67%
0%
e)
35,000
35,000
-
Forester
16,667
-
(16,667)
67%
0%
e)
25,000
25,000
-
Car Washes
2,000
2,366
366
67%
79%
3,000
3,500
500
Car Rental
333
-
(333)
67%
0%
500
-
(500)
Sale of Equip & Material
402,333
416,357
14,024
67%
69%
603,500
639,850
36,350
Total Revenues
9,931,923
9,152,509
(779,414)
67%
61%
14,897,884
14,119,437
(778,447)
Trans In - Solid Waste
194,493
145,870
(48,623)
67%
50%
291,740
291,740
-
Trans In - Transp SDC
133,333
100,000
(33,333)
67%
50%
200,000
200,000
-
Trans In-Road Imp Res
8,027
-
(8,027)
67%
0%
12,040
-
(12,040)
TOTAL RESOURCES
13,698,205
12,817,982
(846,890)
67%
73%
18,832,093
18,030,780
(801,313)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
3,835,311
3,603,828
231,483
67%
63%
5,752,967
5,611,278
141,689
Materials and Services
6,314,015
5,099,601
1,214,414
67%
54%
9,471,023
9,089,689
381,334
Capital Outlay
781,127
16,362
764,765
67%
1%
f)
1,171,691
95,000
1,076,691
Transfers Out
266,667
-
266,667
67%
0%
400,000
400,000
-
Contingency
1,357,608
-
1,357,608
67%
n/a
2,036,412
-
2,036,412
TOTAL REQUIREMENTS
12,554,728
8,719,791
3,834,937
67%
46%
18,832,093
15,195,967
3,636,126
NET (Resources - Requirements)
1,143,477
4,098,191
2,988,047
-
2,834,813
2,834,813
Beginning NWC per Requested Budget
2,834,720
a) Annual payment-January 2011
b) Received in June 2010
c) Gas tax increased by 25% ($.06/gal.) effective January 2011 (revised State estimate)
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
Eight Months Ended February 28, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 616,371
$ 728,649
$ 112,278
100%
118%
$ 616,371
$ 728,649
$ 112,278
Revenues
DOC Measure 57
144,870
217,350
72,480
67%
100%
a)
217,305
217,350
45
State Miscellaneous
2,867
4,301
1,434
67%
100%
4,301
4,301
-
Alternate Incarceration
20,612
30,918
10,306
67%
100%
a)
30,918
30,918
-
State Subsidy
8,667
9,980
1,313
67%
77%
13,000
13,000
-
SB 1145
1,974,660
2,221,492
246,832
67%
75%
b)
2,961,990
2,781,990
(180,000)
Probation Work Crew Fees
25,333
16,145
(9,188)
67%
42%
c)
38,000
20,613
(17,387)
Miscellaneous
2,000
2,890
890
67%
96%
3,000
3,000
-
Electronic Monitoring Fee
113,333
110,894
(2,439)
67%
65%
170,000
166,000
(4,000)
Probation Superv. Fees
140,000
132,792
(7,208)
67%
63%
210,000
199,000
(11,000)
Interest on Investments
6,000
6,226
226
67%
69%
9,000
9,000
-
Interfund - Sheriff
33,333
33,333
-
67%
67%
50,000
50,000
-
Crime Prevention Grant
33,333
25,000
(8,333)
67%
50%
d)
50,000
50,000
-
CFC-Domestic Violence
-
18,708
18,708
67%
n/a
e)
-
56,124
56,124
Total Revenues
2,505,008
2,830,029
325,021
67%
75%
3,757,514
3,601,296
(156,218)
Transfers In-General Fund
76,686
76,686
-
67%
67%
115,029
115,029
-
TOTAL RESOURCES
3,198,065
3,635,364
437,299
67%
81%
4,488,914
4,444,974
(43,940)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
2,115,505
1,970,292
145,213
67%
62%
f)
3,173,257
2,966,580
206,677
Materials and Services
596,183
528,338
67,845
67%
59%
894,274
894,274
-
Capital Outlay
67
-
67
67%
0%
100
-
100
Contingency
280,855
-
280,855
67%
n/a
421,283
-
421,283
TOTAL REQUIREMENTS
2,992,610
2,498,630
493,980
67%
56%
4,488,914
3,860,854
628,060
NET (Resources - Requirements)
205,455
1,136,734
931,279
-
584,120
584,120
Beginning NWC per Requested Budget
560,000
a) Annual payment received in July
b) Anticipated funding cuts from Dept. of Corrections. Money above opt out
c) Increase in fee waivers from court due to economic conditions
d) Payments received quarterly (Sept, Dec, Mar and June)
e) Intensive Supervision DV grant (Federal grant)
0 Personnel expenditure projected to be less than budgeted due to unfilled positions
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 562,762
$ 635,340
$ 72,578
100%
113%
$ 562,762
$ 635,340
$ 72,578
Revenues
Federal Grants
266,778
273,176
6,398
67%
68%
a)
400,167
413,268
13,101
Title IV - Family Sup/Pres
42,500
37,556
(4,944)
67%
59%
63,750
63,750
-
HealthyStart Medicaid
63,333
26,212
(37,121)
67%
28%
95,000
95,000
-
Level 7 Services
171,989
112,094
(59,895)
67%
43%
257,984
257,984
-
State Prevention Funds
9,667
6,756
(2,911)
67%
47%
b)
14,500
17,000
2,500
HealthyStart /R-S-G
205,949
134,805
(71,144)
67%
44%
c)
308,924
263,596
(45,328)
OCCF Grant
402,882
290,050
(112,832)
67%
48%
c)
604,323
549,044
(55,279)
Charges for Svcs-Misc
5,333
1,907
(3,426)
67%
24%
8,000
8,000
-
Court Fines & Fees
50,000
54,459
4,459
67%
73%
75,000
78,000
3,000
Interest on Investments
13,333
3,634
(9,699)
67%
18%
d)
20,000
8,000
(12,000)
Grants-Private
3,333
-
(3,333)
67%
0%
e)
5,000
-
(5,000)
Donations
-
857
857
67%
n/a
-
857
857
Miscellaneous
172,369
85,058
(87,311)
67%
33%
f)
258,554
118,500
(140,054)
Total Revenues
1,407,466
1,026,564
(380,902)
67%
49%
2,111,202
1,872,999
(238,203)
Trans from General Fund
189,556
189,556
-
67%
67%
284,333
284,333
-
Trans from GF-Other
16,667
12,500
(4,167)
67%
50%
25,000
25,000
-
Total Transfers In
206,223
202,056
(4,167)
67%
65%
309,333
309,333
-
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
2,176,451 1,863,960 (312,491) 67% 62%
Exp.
2,983,297 2,817,672 (165,625)
399,706
358,658 41,048
67%
60% g) 599,559 528,466
71,093
1,316,723
960,426 356,297
67%
49% c) 1,975,084 1,822,095
152,989
67
- 67
67%
0% 100 -
100
272,369
- 272,369
67%
n/a 408,554 -
408,554
1,988,865 1,319,084 669,781 67% 44%
NET (Resources - Requirements) 187,586 544,876 357,290
Beginning NWC per Requested Budget
a) Federal grants adjusted to projected actual
b) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500 grant received
c) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received
d) Interest revenue projected to be less than budgeted
e) Youth conference donations will not be received
f) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received
g) Personnel costs will be less than budgeted due to open positions
2,983,297 2,350,561 632,736
- 467,111 467,111
467,111
SOLID WASTE
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 392,509 $
318,001
$ (74,508)
100%
81%
$ 392,509
$ 318,001
$ (74,508)
Revenues
Miscellaneous
18,667
14,365
(4,302)
67%
51%
28,000
22,000
(6,000)
Franchise 3% Fees
133,333
85,457
(47,876)
67%
43%
a)
200,000
200,000
-
Commercial Disp. Fees
560,000
561,414
1,414
67%
67%
840,000
860,000
20,000
Private Disposal Fees
876,000
849,132
(26,868)
67%
65%
1,314,000
1,314,000
-
Franchise Disposal Fees
2,439,333
2,693,783
254,450
67%
74%
3,659,000
4,000,000
341,000
Yard Debris
48,667
51,345
2,678
67%
70%
b)
73,000
73,000
-
Special Waste
16,667
41,251
24,584
67%
165%
c)
25,000
50,000
25,000
Interest
8,333
5,505
(2,828)
67%
44%
12,500
7,500
(5,000)
Leases
-
1
1
67%
n/a
-
1
1
Sale of Carbon Credits
53,333
-
(53,333)
67%
0%
d)
80,000
-
(80,000)
Sale of Equip & Material
-
100
100
67%
n/a
e)
-
100
100
Recyclables
13,333
30,506
17,173
67%
153%
f)
20,000
40,000
20,000
Total Revenues
4,167,666
4,332,859
165,193
67%
69%
6,251,500
6,566,601
315,101
TOTAL RESOURCES
4,560,175
4,650,860
90,685
67%
70%
6,644,009
6,884,602
240,593
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out-Road
Contingency
TOTAL REQUIREMENTS
Exp.
1,066,745
1,079,202
(12,457)
67%
67% g)
1,600,118
1,631,569
(31,451)
1,910,553
1,578,743
331,810
67%
55% h)
2,865,829
2,783,058
82,771
646,711
401,732
244,979
67%
41%
970,066
970,066
-
78,667
48,311
30,356
67%
41% i)
118,000
115,661
2,339
194,493
145,870
48,623
67%
50%
291,740
291,740
-
532,171
-
532,171
67%
n/a
798,256
-
798,256
4,429,340 3,253,858 1,175,482 67% 49%
NET (Resources - Requirements) 130,835 1,397,002 1,266,167
Beginning NWC per Requested Budget
6,644,009 5,792,094 851,915
1,092,508 1,092,508
1,092,508
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue decreases during Winter
c) Bonneville Power did large clean-up of contaminated soil-unexpected revenue
d) No market at this time. Not expected to market this fiscal year
e) Minor revenue for sale of gate remotes
f) Markets for recyclables varies throughout the year - usually declines in the winter
g) Due to layoffs, more overtime incurred than expected. Appropriation transfer from contingency will be made prior to fiscal year end
h) Larger expenditures (i.e. grinding at $75,000) will be made in Spring
i) One item remaining-software being researched
RISK MANAGEMENT
Statement of Financial Operating Data
Eight Months Ended February 28, 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
TOTALRESOURCES
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
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Contingency
TOTAL REQUIREMENTS
NET
Year to Date
Year End
Budget Actual Variance % of FY % Coll. L Budget Projection Variance
$2,500,000 $2,374,541 ($125,460) 100% 95%
223,889
223,889
0
67%
67%
196,013
196,013
0
67%
67%
121,807
121,807
0
67%
67%
604,241
600,339
(3,902)
67%
66%
113,625
113,355
(270)
67%
67%
20,000
-
(20,000)
67%
0%
13,333
27,219
13,886
67%
136%
1,000
840
(160)
67%
56%
1,333
-
(1,333)
67%
0%
14,667
13,858
(809)
67%
63%
20,000
11,301
(8,699)
67%
38%
1,329,907
1,308,621
(21,286)
67%
66%
3,829,907 3,683,162 (146,745) 67% 82%
Ex .
$2,500,000 $2,374,541 ($125,460)
335,833 335,833
294,019 294,019
182,710 182,710
906,361 906,361
170,437 170,437
30,000 30,000 -
20,000 30,000 10,000
1,500 1,500 -
2,000 2,000
22,000 22,000
30,000 30,000 -
1,994,860 2,004,860 10,000
4,494,860 4,379,401 (115,460)
46,861
2,775
6,435
136,168
716
250
266,667 193,205 73,462 67% 48% 400,000 320,000 80,000
153,414
11,326
200,000 164,740 35,260 67% 55%
1,739
390
10,656
44,326
80,000 57,111 22,889 67% 48%
431,200
6,250
71,441
31,118
21,987
433,333 561,997 (128,664)
106,667 187,888 (81,221)
1,086,667 1,164,940 (78,274)
192,969 190,959 2,010
152,556 110,008 42,548
67 - 67
345,591 300,967 44,625
1,564,315 - 1,564,315
2,996,573 1,465,907 1,530,666
833,333 2,217,255 1,383,921
300,000 250,000 50,000
120,000 100,000 20,000
67%
86%
650,000
780,000
(130,000)
67%
117%
160,000
320,000
(160,000)
67%
71%
1,630,000
1,770,000
(140,000)
67%
66%
289,453
289,453
-
67%
48%
228,834
228,834
-
67%
0%
100
-
100
67%
58%
518,387
518,287
100
67%
n/a
2,346,473
-
2,346,473
67%
33%
4,494,860
2,288,287
2,206,573
-
2,091,114
2,091,114
Beginning NWC per Requested Budget 2,100,000
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Eight Months Ended February 28, 2011
Year to Date
Year End
Bud et
Actual
Variance
% of FY
% Coll.
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$5,861,335 $
6,691,945
$ 830,610
100%
114%
$5,861,335
$6,691,945
$ 830,610
Revenues
Property Taxes - Current
4,238,414
5,876,997
1,638,583
67%
92%
6,357,621
6,357,621
-
Property Taxes - Prior
92,000
231,054
139,054
67%
167%
138,000
231,054
93,054
Federal Grants
316,000
-
(316,000)
67%
0%
a)
474,000
474,000
-
State Reimbursement
6,667
11,163
4,496
67%
112%
10,000
20,921
10,921
Telephone User Tax
366,667
428,527
61,860
67%
78%
b)
550,000
550,000
-
Data Network Reimb.
8,000
25,620
17,620
67%
214%
c)
12,000
25,883
13,883
Jefferson County
20,667
34,226
13,559
67%
110%
31,000
34,226
3,226
User Fee
33,333
50,182
16,849
67%
100%
d)
50,000
52,340
2,340
COPS Reimbursements
20,000
-
(20,000)
67%
0%
e)
30,000
-
(30,000)
Contract Payments
46,667
32,134
(14,533)
67%
46%
70,000
32,134
(37,866)
Miscellaneous
5,667
7,681
2,014
67%
90%
8,500
9,000
500
Interest
26,667
33,964
7,297
67%
85%
40,000
40,000
-
Interest on Unsegregated Tax
1,333
646
(687)
67%
32%
2,000
2,000
-
Total Revenues
5,182,082
6,732,194
1,550,112
67%
87%
7,773,121
7,829,179
56,058
TOTAL RESOURCES
11,043,417
13,424,140
2,380,723
67%
98%
13,634,456
14,521,125
886,669
REQUIREMENTS:
% Exp.
Expenditures
Personal Services
2,672,532
2,425,718
246,814
67%
61%
4,008,798
3,758,798
250,000
Materials and Services
1,016,096
818,163
197,934
67%
54%
1,524,144
1,524,144
-
Capital Outlay
1,175,333
909,198
266,136
67%
52%
a)
1,763,000
1,763,000
-
Transfers Out
676,041
754,061
(78,020)
67%
74%
f)
1,014,061
1,014,061
-
Contingency
549,635
3
-
3,549,635
67%
n/a
5,324,453
-
5,324,453
,
TOTAL REQUIREMENTS
9,089,637
4,907,139
4,182,498
67%
36%
13,634,456
8,060,003
5,574,453
NET (Resources - Requirements)
1,953,780
8,517,000
6,563,220
-
6,461,122
6,461,122
Beginning NWC per Requested Budget
6,400,000
a) Federal Grant DHS/ODOT CAD Project $474K.
Capital Outlay: Software $35K, CAD Project (funded by Fed Grant) $474K, Network Upgrade $24K, CAD Mapping Project $30K
Records Management System $1.2 million.
b) Received quarterly (Nov, Feb, May and Aug) for fiscal year
c) Annual billings to agencies underbudgeted. One more payment is expected
d) Crooked River Ranch paid annual fee of $45,869. Expect two more US Forest Service payments of $2,156 each
e) Revenue not expected this fiscal year
f) Transfers made as requested. Transfer to New Facility Property Fund, $754,061, made 9/15/10 & Transfer to Reserve Fund, $260,000,
will be made in March.
Health Benefits Trust
Statement of Financial Operating
Data
Eight Months E
nded February 28, 2011
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES
Beg. Net Working Capital $
16,400,000
$ 16,988,140
$ 588,140
100%
104%
$16,400,000
$16,988,140
588,140
Revenues:
Internal Premium Charges
7,497,333
7,608,035
110,702
67%
68%
a)
11,246,000
11,403,534
157,534
P/T Emp - Add'I Prem
33,333
30,036
(3,298)
67%
60%
50,000
40,000
(10,000)
Employee Prem Contribution
333,333
325,170
(8,163)
67%
65%
500,000
485,000
(15,000)
COIC
650,000
956,592
306,592
67%
98%
975,000
1,275,000
300,000
Retiree / COBRA Co-Pay
300,000
496,922
196,922
67%
110%
450,000
650,000
200,000
Prescription Rebates
-
69,944
69,944
67%
n/a
-
69,944
69,944
Interest
66,667
78,300
11,633
67%
78%
100,000
120,000
20,000
Total Revenues
8,880,667
9,565,000
684,333
67%
72%
13,321,000
14,043,478
722,478
TOTAL RESOURCES
25,280,667
26,553,139
1,272,473
92%
89%
29,721,000
31,031,618
1,310,618
REQUIREMENTS
Exp.
Expenditures:
Personal Services
86,187
82,132
4,055
67%
64%
129,280
129,280
-
Materials & Services
Claims Paid-Medical/Rx
8,300,129
7,998,846.05
301,283
67%
64%
b)
12,450,194
11,884,000
566,194
Claims Paid-Dental/Vision
1,247,585
1,153,401.85
94,183
67%
62%
b)
1,871,377
1,713,626
157,751
Refunds
-
(48,199)
48,199
67%
n/a
-
(48,199)
48,199
Insurance Expense
220,000
224,313
(4,313)
67%
68%
330,000
330,000
-
State Assessments
50,000
124,832
(74,832)
67%
166%
75,000
124,832
(49,832)
Administration Fee
200,000
199,583
418
67%
67%
300,000
300,000
-
PPO Fee
26,667
27,877
(1,210)
67%
70%
40,000
40,000
-
Health Impact
34,000
34,153
(153)
67%
67%
51,000
51,000
-
Deschutes Onsite Clinic:
Healthstat
153,013
64,513
88,500
67%
28%
229,520
229,520
-
Equipment
9,667
23,985
(14,319)
67%
165%
14,500
23,985
(9,485)
Remodel
75,667
104,859
(29,192)
67%
92%
113,500
113,500
-
Miscellaneous
41,267
9,569
31,698
67%
15%
61,900
61,900
-
Other
100,761
27,945
72,816
67%
18%
151,141
151,141
-
Total Materials & Services
10,458,755
9,945,678
513,077
67%
63%
15,688,132
14,975,304
712,828
Capital Outlay
100
-
100
67%
0%
100
-
100
Contingency
9,268,992
-
9,268,992
67%
0%
13,903,488
-
13,903,488
TOTAL REQUIREMENTS
19,814,033
10,027,810
9,786,224
67%
34%
29,721,000
15,104,584
14,616,416
NET (Resources - Requirements) 5,466,633 16,525,329 11,058,696 - 15,927,033 15,927,033
Beginning NWC per Requested Budget 15,500,000
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 35 weeks of claims paid. YTD actual is an average of $260,156 per week.
Deschutes County - Fair and Expo Center
YTD-Budget Basis Commissioners
Statement of Financial Operating Data
Eight Months Ended February 28, 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
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 2,809
$ 6,590
$ 3,781
100%
235%
$ 2,809
$ 6,590
$ 3,781
451,828
413,835
(37,993)
67%
61%
677,742
629,835
(47,907)
1,333
614
(719)
67%
31%
2,000
1,281
(719)
34,000
15,371
(18,630)
67%
30%
51,000
32,371
(18,629)
6,000
3,312
(2,688)
67%
37%
9,000
12,312
3,312
28,000
2,010
(25,990)
67%
5%
42,000
38,010
(3,990)
140,667
128,263
(12,404)
67%
61%
211,000
192,262
(18,738)
62,000
41,738
(20,263)
67%
45%
93,000
116,738
23,738
30,000
-
(30,000)
67%
0%
a) 45,000
45,000
-
2,943
25,485
22,543
67%
n/a
4,414
27,623
23,209
756,771
630,627
(126,144)
67%
56%
1,135,156
1,095,432
(39,724)
131,946
131,946
-
67%
67%
197,919
197,919
-
16,582
16,582
-
67%
67%
24,873
24,873
-
53,334
53,334
-
67%
67%
80,000
80,000
-
154,155
166,000
11,845
67%
72%
b) 231,232
166,000
(65,232)
67
-
(67)
67%
0%
100
100
-
356,083
367,861
11,779
534,124
468,892
(65,232)
1,115,663
1,005,078
(110,585)
67%
60%
1,672,089
1,570,914
(101,175)
Exp. 0/61
621,262
567,031
54,231
67%
61%
931,893
862,462
69,431
317,790
362,622
(44,832)
67%
76% c)
476,685
535,517
(58,832)
77,042
72,061
4,982
67%
62%
115,563
115,563
-
67
-
67
67%
0%
100
-
100
1,016,161
1,001,713
14,447
1,524,241
1,513,542
10,699
6,667
10,000
(3,333)
67%
100%
10,000
10,000
-
Contingency 91,899 - 91,899 67% n/a 137,848 - 137,848
TOTAL REQUIREMENTS 1,114,726 1,011,713 103,013 67% 61% 1,672,089 1,523,542 148,547
NET (Resources - Requirements) 937 (6,635) (7,572) - 47,372 47,372
Beginning Net Working Capital per Requested Budget 75,000
a) Interfund contract revenue is for park maintenance, from Fund 130 and will be received by year end.
b) Cash flow from Fair 2010 was $65,000 less than budgeted
c) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. An increase
to the Materials & Services category will be made via resolution, when required.
H
U
W
ti
O
a
PO
a
H
PLO
-0~
(40)
A
as
4-4
cts
a~
H
Po
U
O
rn
~
a.>
G4
^r~
0001~01~(ONrM~O(^OM
~O
MOst~
C
Q»
LA tO
(AOCDrOMr00NrI~Opr
(n h N r r 0O (fl V r 0 0 Lo W
00
r N
U')00qT
V 0 0 U)
m
Z
r Cp
r
(n (O (D (O r Ili L6 co v 0 v
M M
C- N
v
d' O 43 (O
O
CO)
(a
O
(LO
v N
v v
U
r
O
W
M
2
O
1,0(O
OOWhrP- 0 N M M 0,0 0r
000
M011 (D
7
a (p
ItOto
a) LO V
NstOW(`MrrNr(-ww
rr- N001,- 00CO0-COco^v
NO
NN
LO O0)to
vOOIT
'
(1
E
p
V COM
L
N(-(D(MV'd•trirOppl: Or V
M N
V 00(M
O
U
H
O N CO
N r M
N r M r 0
In r
M r
r
r- r 0 00
M Nr-- M
m
CO (O
(p
t
000
00 co 0qT 00 000
N
O
L
U
N II
00 Cl
O O O
M LO or,- O O o co
L() th ' O C ' O (n C \l
M
M
O
O
'
(0
(D
p 6
OOO
co V OLO 0r rM
O
O
w
aM
Cli v CD
v~ rM O (00
r-
M
c
O tD
O
(O
O
N
N
^
O
~Ot0
0000~r~0N O M V 0COr
00
O
^
O O
m
'
0 to
N IT CO 00 1,- Cl) r r N r h 00 00
N
O
r
)
U N
O(nef
rI- N001`00(O0-(0CO r V
N
' '
P
O
N N
ll~i 00 M
N h (D M v1-i L r 00 h C7 r1-i
M
C~
L
N
C
O~
N - 04 (CO
(Nr M
O
00
O
to
P)
O)
T LL
C
LL
a
co (o
v
v
r
o v
r
r
U p
M (o
> ^N
N C
O)(~M~N 0~~~001~0~
00
f
00
a
N
C ~00
7aN
M a) (6
Z~
Mr(Q1.- 1-0CD00004 00 CD
rMCv(nInMM~-'vCO~`-~O
M
00
CD
00
O
f
OD
O
a N
U ~
(a
Q U N
v (O
Nq
O
LO
U)
LL
LL L
U
O C- 3
`
.
v
`7
a}'
i 0 7
0) M
.
~-o=a
w
o vo
•
U
O
Q
m
r
(D
c
a) L
vm
Q C O
c(D v~
U) C r
0) 78
3 LL 0
U
a.
E }
a
CD w
(0 LO CD N O N CO M r M I,- (0
(D
O
cn
01 O` W
v
v Cl w
to co M LO V co Cl O M IV 00 co v
CD
O
le
0) LO V
N00It M N 0 WNrM0
O
CO
co
'O O C O
C
a) ~
V OO M
04
~ d k (d vi & 06 06 -:06
r M CA r In
~
00
N
C;
N
C *0 N
O
O
y
> O
C
N
M
tD
LO
00
(n
v
m
a r E
r _
X
W
t0
M
CO 0) U) Mt:
(1
0
N
O b
C
O
O
o
U
0 co
w
0mCL ""0
l0 a
m
U
-
a~
m'~
a
U
c
U
o co O co
a)
(n
E O Z , 4)
c
m
m m
a) U
E CO
O °
rn
H
to 0 (D
O O Q
O
'
a)
O
C L
a)
C
D)
D U 0~
O
O C
N
to
N N co N .0 C> U)
c
its CA N LL
C U)
to V a) N V) ca 7 D" (a
^ Cn
U V U
d
W Zo 2a a
^
° Ca L N z
a~
E
W
v
t tim
E
C
Z
v
7
`
w
O co M
•
EV
N O
U
N 7
U O
a)
a
i U
O
v
:3 FE m CA (r 'O U 0) C
CO
C Y
3 CO) CO
C
m 0) w, d
w
o 4N)
p a°i aoi rn c c c a (n a)
V) 0°i -
r
p O O
v v v (L)
C
c ai m
m
a in
- c a) s
Z m= c c p m
*1
V
>
C L
~
U
x
y 3 7 7
N
L
U)
-O N-
C 4
W V to
0
) d y N
-
.
a C 0) - N C7 C . ~
0
N
W
C LL LL LL
f6 N
O
t ~ LL U
I-
W
)
o.. o
x CO<LU -a ~SLL¢a~~0
mzU)
((s m
0)
m5H
W
U
F= 0
Z
m n oa
CO
CO
'0 O
N
C
7
N
U
y
.0. O ~
Un ll
L
W w L
N t7)
U O
O
r •C
r F
0
W
V
d'
0
N
W
It
vr000
~ NOrhN0000M~~00
COO
000
MIT I- cm
(q OON
OON000~0f~~0MCON0
CONOvOONMr00OIl-
COO
r00
MN
MN
M 0 N
04
Cvv - -CC,4 .0...~0 r
v O
LO ^
M
r co
000
y
v r
r
CCU
N
O U
[<1•r0~
MNIl- M
r(Ope-~N(ONM000~
OtiO)00MO1~O0M00OO
r0
C)
0 V
MM
w
'O'
a
AD
D
CO Vi 00
ONC V O Or00vv
IT co
MO
'
co co MO
w 0 0 N N M N O n o V
r N
0 I.
r M
o
a .3
N-V 00
'7
h
M
r CLO
O
0)0 00
U
CC')d
(
C
M
M
N
r 0
U
N I~
w
N O
_
L
CO
CO
O N O N
O CO O co
O co O I- 00 O O
Cl 0 O co O O 0 co
I,-
f~
N
CO
`
N
-
0 ~p
ONON
Oef ' Or ' 00 ' OCO
O
N
O
C C
O N LO
tn t- co
I~ r N O 0- r N
O N O
IT
n
w
4
N co (D
N
M
LO
m Go
r_
O
~ •0
M M
M
Ch
O
^ N
C)
r.
(D
N
~ CC6
m
L
~r0et
M N h M
rCOOrVNCONM000~f
00 r-- 0 CO M 0 I- LO M CO CO CO 00
r
r
CD
M
(D IT 00
CC NCD V NOCV CD r0CD It IT
IT
00
r
y
M r h M
coco
06 O O C %i M N O I% CO 'R
Nr N
0
M
CA
91
C 0
O
0
N
C
O v
O O
CO O
co
r
e
O
.
-
M M
cy
M
IT
M
y
j
C
y
01~MrNfO~ V 0001~Or
co
t6
C
'
0-
M rOl~n 0OONrMto
M
M
0)
(D
CL
M 0 O O M M I` 0 O O
co
co
co
U)
~ 0
C %j r r r Ili
'
d
l
l
O
C N
r CO
d
M
W) W)
W) W
o
O O
CO
C N
co
O
3
Co
M
r
0)
r
LL
V r0 V
C'MNhM
N 0) 000 N CO N 000r M 0 M
V O M r CO 00O W 00r I- O N
M
r-
(O
CA
O
M
0
•O
~L
O CA
CC) IT 00
00v0co 0000LO IT vIT CMv
O
CA
O
C
>
>
CpOcoO
000CC)~t NNm ~'(O11 000
COO
I06 V
Cif)
e-
a
f
N `O
cs! co
N
CO
r
t0
-
-
r
°
)
w
05
M
co
N
M
O
,
-O
N
O
O 0
'
Cl)
0)
y
N
C
y
O
O
) CO
E
U
C a
m
O U)
0) 7
O
to
E O
C
y 0)
E o
t0
ca
N U
•
O
O C
7
U
~
w CO
o 7
y
y p U y
U Z 0 U)
O O
O O
t E
O
N
U
h cm
U)
O•
C
c
O
Co
~
C CA
y y N
m C 9 N
`
N U O N CA 0~ 7 Co
O
`
CtS 0
U C
O Co
w
d
to y v
W 0 C? N w a LL •rr
N U
N
U
V w
:p
_
(O U
E
•N
C
N 3
O
U E CT
C
_
O U R
~
O ch
C t
w
C Y O
CO
d
C
O
y
O
a0
,
H KS
CA •O U 0)
m rnc c c a y rny O 0
„
~ o o O
v 0.
y
c 4)
O
o
D. f
6
= O N
W - t
C
O
W
y
N
`
c v a~
y
N O N> C
a c m -Co c c m v c
3
a) c
L`
U
r-
0)
H
U
C7 .5
i
O
¢ W F-tLLLQd~~O
W
mZCA C
G
CD
cl
ml
~
U I-
H
Z
(o
U
N
C
N
U
N
0
a' r
O
N
C 3 a0
7 L N
O U
U aNi ~
M Q 7
L w N
U - LL
Q LL 7
O
C L
m~
E
co
N
N
7
U
a~
N
W
U
O
N
W
It
m M O N
e-
a -T C-D a-^, ;;F
CD
CO cMO -
'
N
r W - C) 0 M0 0
1-
a))
0
0
O
~
c0
O)
- 0cn
W
r•ui r- ' 00 -00(0
~
M
0
4D
O
~
N
r-: O N r-
.1i
0 N N C6 C4 O M d
P-
N
N
M
a
4
co
ti
v - co
r-
M
M
0
v
w
N
-
d
v
m
OMON
OI
O V (I- OMN V Nt00
0
M
M
MOM0-
t-
1`a00~000t00MON
t0
I~
v
IV
r
cc
o 0 ~ 0 M
le
I- O - I- cM O ~ r- (0 M
N
V
i-
fl
'
N
N
tt)ONN~
O
c0~=Nra6 tneliOM.--00
00
te
r.'
to
NtiN ~
O
N
M ~
co
a*
co
e
-
M
w
c
o
0
N
000 0
0
000 M • O O
c o
o
O O
O O
000 O
O
000 0000 O
0
O
0
0
O
O
000 0
0
0 0 0' M N O' 0'
I-
N
N
O
O
'
MON 0
49
f-• 0N 00 C0 N
v-
0
0
M
L
O O
N
n r r• M
V)
co
co
0
to
M
O
O
M
C %i
N
N
N ~
cv O cM O N
O)
N~ I- 0 N N M d N c0 0 CO
c0
M O M O
t~
O ap 0 cD 0 0 M O N CO
ti
OO-OeM
'
0OI-1~MOO~ ~COMN
M
4
t 00tOMM
M~00
COLO0
LO
O
co M
ti
N Il-
O
N
N
v O Cl) O N
O)
N I~ 0 N N M d N t0 0 CO
CO
MOMO.-
tom
Oa00rO0[f OMONCO
h
OO-OM
It
000"I,.Lggq ~cOMN
M
O N N
V aC1 0 M
M 0 0
W tt
to
O M
O
F--
04 ih
O
N
~
N
to
w
to
O
U
N
U
C
m
7
rn
y y
O
H
c m
N O O U
C C
>
c(D) C S rn y 0
O N C W
a. 0 (D .2 IX
C O N
m
3 c
cl I.-
co ce)
IT v
COIcoI
co M
M M
O O
v r
O O
0 0
CD
O O
r r
L
M E m
U N
Q Z 7 N y
y p_) N U) •V tT N 7
U N N ajf L N N O
O
CY)
Lu a.
c,) (D CM C E 0 CL
H Ki C a A2 N U O V
a? m o a c
Z R) f0 C `C to N L 0
O m c 0
rn
W e > CM C N N c>_ > -
x mQW W-i a SLLa.< t- ~U
WZ U
~ r
OI
Of
r
O
Cl)
CC
n
M
' N
ti
V.a
C U)
3
LL
U
c) N m
co a
x
ra W
C 0
20 FO-
m
47
M
M
r
cD
M
t70
tD
Q)
o)
ti
r
Z
O
Cl)
w
N
T-i
O
O U
6f! N
~ O
y U O.
U 0
C
7 m
N
to >
a m
C fn
M a
O N
0 a)
M
ao a
v
~ N
'0'a
r_ c
O O
L LL
C
O N
C U
7
O O
U to
N N
'p ~
O w
O C
O
0 0
N U
M
Eff ~
a
o p
a
O V
O C
7 ~
> N
` N
m w
a O
N 0
U O
C U
O O
3
tp M
U) Cl)
M
O N ~
O N
U m +
.LO O M
to co
to
N y co
y a) N
a Q
O O
U O
Q O
a o co
C N N
M 0 va
m L
i i
M M
O co
N ~
ON
N
OOP- ti 00
N
N
~
M
I
00
O
N
M
~
0
O O
co
Ce) LO IT
0
V)
0
0 to
N
co
O
V7 Cn
CO
ti
N r
r
0
CCU
C
3
Cl
L
U)
C F-
U W
U N
X000
U N
N 0 m
3 Z 3
ai U ~i
W
O
U CO
L
U- ~
c ~
d) U
E W
m
F-
N
7
U
a)
U)
O0
rn
OOtiti 000 m omwmr-NNr'O0
ct
LO
Oti
r-
LO C.0M~ Or- rnMCfl~OmLO 11,omm
ti
to
O-
-
ML Ito CC)O It 000C~ 0000CnOO00O
Lc
ti
O ~
~
Ch In -4t O) ~ ~ N ~ O M IT r- ~ 0 IT r- CA
CA
IT
I-
ti
N 00 m
r' N ~ CN N N N
M
m
LO
~
N ~
r
r
a)
m
U
X
a)
O
0
C
N
m
co U)
U a)
CL
a) a)
~ O
m
3 (n
U j
w .O
Z E
01-
Q =
N N
w ~
U U
_
t L
Q
a) m
m m
C C
c c
as
O
y
U C
` O
m
t5 E
C
~•C y T
C CL C~
a) Cc
C ~ N
CT C O U
C O C2 U
W JfnQ
Q.
3
O
U
U U
W ~ ~ L
L t w U
L L N
QQID cn
a) a) c
a a CO O
O O N C
C C O
a a U Q
rn
c
m
Y N N O
~o c fl. r ~ w
C
a) 0
U C O a) U CO E
ca cm U a) U
E rn a) a) m 0
CD Cc
L 3 L CA !F V >
-OD -co
a) U Co Q UU) 0
U N O • a)
~ C!)
m a) cii
Q C 3 - = a) 7
0 CT a)
C a) N O N O O
O U 0 V a) L O N
c U= L L a v M
OC •C J) O CY) :3 CO T N
U ~ E c (J) - C L
ca Q C- 5- O= C1.C -ffi Co 0 0)
:3 CU (D
O N _C to V v rr a) a)
C c CT II U Q L E CO U a)
M M
O O C1 m: .N § :3 N •T - 3 3
Uti~ 0 2=~ao*2cncncn
N M LO CO r- 00 0 ~N-
L L L L L L L L ^L, L L L
72 -0 -0 M
L L L L L L L L L L L L L M
w00 0000000000
3 0CT C3OCTCTCTC3~~CTCT~
M C C C C C C C C C C C C=
CO N N m m w m m m m m N
L= L L L L L L L L L L (p
U)UU 0000000000-0
= F-
Deschutes County
Bethlehem Inn (Fund 128)
Eight Months Ended February 28, 2011
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ (2,725,000)
$ (2,722,510) $ 2,490
100%
100%
$ (2,725,000)
$ (2,722,510)
$ 2,490
Revenues
Grants - Private
1,907,333
- (1,907,333)
67%
0%
2,861,000
-
(2,861,000)
Total Revenues
1,907,333
- (1,907,333)
67%
0%
2,861,000
-
(2,861,000)
TOTAL RESOURCES
(817,667)
(2,722,510) (1,904,843)
67%
-2002%
136,000
(2,722,510)
(2,858,510)
REQUIREMENTS: Exp.
Expenditures
Debt Service:
Interest Expense 24,000 13,133 10,867 67% 36% a) 36,000 20,000 16,000
Interest Payment 66,667 - 66,667 67% 0% 100,000 - 100,000
TOTAL REQUIREMENTS 90,667 13,133 77,534 67% 10% 136,000 - 100,000
NET (Resources - Requirements) (908,333)
(2,735,643) (1,827,309)
a) Interest on February 2011 negative cash balance ( $2,732,974.83) = $1,285.04.
b) Recap of expenditures - inception through February, 2011
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
217,730
Total expended
$ 2,735,643
b) - (2,722,510) (2,758,510)
Deschutes County
Summary - Expenditures Compared to FY 2011 Budget
FY 2011 Appropriations - M&S and Capital Outlay
Expended to date in FY 2011
Remaining Appropriation
Balance Due on Contracts
Remaining Appropriation after contracts paid in full
FY 2011 Expenditures for other activities (a)
Remaining Appropriation after Contracts/Other
"Area A"
"Cell 5"
Landfill
SW Capital
Closure
Projects Fund
Fund 611
613
Total
81 /,Zlu 2,538,638 3,355,848
436,648 106,022 2;242,670;
380,562 732,616 1,113,178
341,522 131482473;004
39,040 601,135 640,174
32,210 339,174 371,384
6,830 261,961 268,790
Additional Appropriation in
Contingency and Reserve for Future Expenditures 274,011 551,196 825,207
a) Fund 611 FY 2011 Expenditures for other activities through February 28, 2011 are
interfund loans totalling $32,210 for the Humane Society of Redmond. In March,
an additional $20,000 will be loaned. An appropriation transfer will be made prior to the
end of the fiscal year.
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of February 28, 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 February 28, 2011 (Final payment made December 2010)
Balance Due
Construction Contract
M A DeAtley Construction Inc
Original Contract - @ estimated cu.yd.
Amended Contract - @ revised cu.yd. and damages
Change Orders:
Change Order #1
Meet CEC requirements, increase to electrical panel,
Change Order #2
Storm sewer realignment due to refuse encountered
Change Order #3
Revise valve vaults for improved efficiencies
Change Order #4
Add'I cover material from what will be Cell 6
Change Order #5
Environmental controls building, pump station bulkheads
Change Order #6
Adjustment to pipe alignment to increase slope
Change Order #7 (not likely to occur)
Change Order #8
Additional rock to be set aside for future needs
Change Order #9
Manhole covers below grade to meet Road Dept requirements
Change Order #10
Modular Block Wall instead of MSE Wall
Change Order #11
Upgrade of cables (pump and leachate)
Change Order #12
Leachate Line connection from Cell 5 to Cells 3 & 4
Change Order #13
Additional cover material due to settling
Change Order #14
Well modification, flow meter less LFG vaults
Damages
Total Contract
Amount Paid
Through June 30, 2010
July 1, 2010 through February 28, 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 February 28, 2011
Balance Due
"Area A"
"Cell 5"
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.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2011
I
I
I I I
I
I
I
BOCC Conference & Travel
Jul
Aug
Sep Oct Nov
Dec Jan
Feb
YTD Total
Tammy Baney j
Conf/Sera & Educ/Training
-
-
305 45
75 j
150
465
1,040
Travel Meals
-
20
- - -
150 1
55
-
225
Accommodations
-
77
- 429 -
1271
254
1,699
2
586
Mileage reimbursement
-
240
255 - 1
306
297
-
,
1,098
Ground Transport/Parking
-
-
-
- -
27
60
-
87
Total Baney
- j
337 j
-
989 45 1
685
816
2,164
5,036
Dennis Luke
1
Conf/Sera & Educ/Training
-
-
-
305
-
-
-
-
305
Travel Meals
-
56
37
25
74
32
-
-
225
Accommodations
-
77
76
506
85
(214)
-
- 1 529
Mileage reimbursement
-
282
178
190
211
148
61
- 1,069
Ground Transport/Parking
-
17
- I
-
-
-
-
- j 17
Total Luke
-
432
292
1,025
370
(34)
-
- 2,146
Alan Unger
1
Conf/Sera & Educ/Training
-
-
-
305
45
-
30
- I
380
Travel Meals
-
- !
198
-
-
32
-
230
Accommodations
-
-
-
1,414
-
-
362
-
1,776
Airfare
1,133
-
-
-
-
-
-
1,133
Mileage reimbursement
-
-
372
-
-
575 -
947
Ground Transport/Parking
- j
-
-
29
-
-
- -
29
Total Unger !
1,133
-
-
2,317
45
-
998 j - 4,494
Tony DeBone
Conf/Sera & Educ/Training
-
-
-
-
350
-
45 -
395
Accommodations
-
-
-
5361
-
(107)
-
429
Mileage reimbursement
-
-
-
-
-
122
-
154
275
Total Other
-
-
-
536
350
14
451
1541
1,099
Total - BOCC Department 1
1
1
Conf/Sem & Educ/Training
-
-
-
610
395
75
225
465
2,120
Travel Meals
-
76
37
25
74
182
87
-
680
Accommodations 1
-
154
_ 76 1
1,470
85
(195)
616
1,699
5,320
Airfare
-
-
-
-
-
-
-
-
1,133
Mileage Reimbursement
522
178
445
211
454
933
154
3,389
Ground Transport
-
17
- (
-
-
27
60
-
133
Total - BOCC Department
-
769
292
2,550
765
544
1,921
2,318
12,774
FY 2011 Budget
19,600
Percent of FY 2011 Budget Expended
1
65.2%
BOCC County College
j
Public Information
-
-
1,874
-
-
-
-
1,874
Office/Copier Supplies
j -
-
33
65
52
-
-
150
Meeting Supplies
-
-
295
930
1 828
-
-
2,053
-
-
2,202
995
880
-
-
4,077
I
~
I
3/1/2011