HomeMy WebLinkAboutFinance Update (2)Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
November 1, 2010
(1) Monthly Investment Report
(2) September 2010 Financials
esc utes aunt
Q
0
Cr)
I • . estment 'ortf•!io A
Investment Income
Fiscal Year 2010-11 I
9
17
)-
0
$ 73,774 $ 249,654
r3,774 249,654
(3,689) (12,483)
Investment Income - Net $ 70,085 $ 237,171 I
Q
a)
cn
Investments By County Function
General $ 105,281,833
Total Investments $ 105,281,833
\ \ o \ e \ o
0 o e o 0 o O
O N N O NM O
(Ni cSO � O N . oiO
CO CO
O
L1)O
co CO
O P
b9
a)
a(n '
C a) a)
o_ o (a
U
•
i 0''
m is a)
E o
E °E
0 0 1—
U. S. Treasuries
M
O
N
O
e-
tft
Total Investments
r
c
CO
O
Om
a)
cac
a)
0
1
a)
a
Oeco co e
N.
co
O r O
o a
co
a)
C9 a
;tai
O y ca
Ha)'("D-
0 > >
O O O
c0 c0 M
• N N
O
Average Maturity in Days
a)
0 0 0 0 0 0
0 0 (n %t u') 0 0
N N N
1
1
Total Portfolio: By Investment Types
Next Call
Date
TO
U U U U U U U U U U U U U U U U U U U U U U U U U U U U t N U TZp N O N N O N O co
Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z' Z Z Z Z Z Z Z Z Z j°. Z N G N •B •0! •!•
O
0
Q
e c z-
O E O
(u(6
>>2
C
O O O W N O O O V W N N N O V N' O M O'. O O M N O W N O W O N. N O
O W O N O) O O O M W m W N W V N O M O O 10 W W O W N O V O N W O
O O W (0 O 10 O W O N W N 4 h O M O O (0 W (D O M N O O O N W O
O W m c0 o 10 N- O O W V 0)' N V V ! 10 co m O O W O O N • O 000 N O
10 10 W M N. O
W W N 10 ,- N M O V m. - W O W O? N M M 110p0 .- 0) M W CPP
M M M _M O V W O' O V O O N O el c6 cs.i V CMS' N M N O.- O N N M M M (O0 'Zi
O M
0 0 N- 0 0 0.- ,- O.- 0 0 0,- 0 0 0,- 0 0 0 00,-0
(V (V (V - N N N (V (V N N N N N N' N, N N. N N N N N NN N
N-�
IDMWM
(D S
00 ('J
O W. -
W W -
N.- W
CL( (D
)0 of
n
M
)
CO
M
N
(f)
0
IA
NN MOON
.- V O O W M
66 4 O (O c4
NO N M
MN M O 0) M
W cc, W O 0) a0
MN W O 0) N
N O N- N.- H
,- N M O
M
0
O
Tp
>
O
0
Y
(p
2
0000 V O W O N' O O c0 O 10 C` M O O D 0) 0 0 0 0 0 0 W W O O' O O
O O O O 0) O N O N O M V O N W M 0 0 0 W O O O O' O O N M O O'. M O
O O O NO N o O O O O W M' O O O W' O O O O O O O O' N, O•
N- N N_ W W M W M V W V O W W M W V W W W W W N O O n W W O V W
W. - m W M W W W W W V W (0 ,- V W , N N N W N N N. - W O h O W O O C-
O M C) M O W M W N W O W N = C- W W W. - W W M W N M'� V 0 O' O M
O O O (0 O O V 0) O M W O O ou O 0) W. - O O W O W .' O M O O. O' O
O' 0 0 0.- 0 0 0) .- O.- 0) O. - O, O O O O', 0 0 0 0 0 0 O' O 00.- 0
N' N N- N N- N ,(.,i N N N N N' N N N, N N N N N N N N
NNWN
t- 0) W')
6).4-.-
,-ONV
Ih W
.- W W
T - n
N CO
oisticassi
10 stO
M
O
>
N
O
C
•�
O
•
W' O O O O O O W O O O W O O O, 0 0 0 0 0 0 O, O M O O O O O O O
.-. O O O O O O e- 0 0 0 0 0 0 O,O O O O j m O O O O N O 0 0 0 0 0 0
N' O W m O O O N- O O O h 0 0 0 0 0 0 O'' O' O O O O 0) 0 0 0 0 0 0 0--
(0(0 M O O N O (0 O V O 0 `7 O O O V (C0p W O O O W O W N O 0 0 O. O 0
o M m W O W O O O': W O V so O O' O W M r - O O O m O W h m 0 0 m' O W
M ', N. Oc0 O M O 0) C) M' 0) 0 0 0 ` W rrr O O O C") O 7' O. 0 O 0) O N
O W V - 0 0 0 0) O O O V m O O O' 0) (0 O)'' O O O W O V O O M 0 0) 0 0
O O O O O O m,--- O 0) .- O O 0) - O O O O O O- O O O0)-0
0.1c404.- N N,- N CV ‘- (Si N,- N N N (Si CV (Si (Si CV N (Si CV ,-N
r-�
N W W
f- O N
M W-
66 LL)
W h
M co
CV(C) 0
(n v
,.
O
0)
N•
01
U)
M
a
O o
2
C)
C
c0
>
C
• N
• • 0
d o m 0 C Q E
'O O
N, W
0 000000000 0 0 0 0 0 000000000'00 0 0 00 000 0 a
O O, O O O _W O N O O O W W O O' 0 C) 0 O' 0 0 0 Q)' O O O O O O M O M ,Nap 0 M C')
O N 0 O M 0 M O M V M O ((00 cM� N O''� O W W O (0 O N O (0 h M (0 M CD 1(') O h N
N' O, - O. - N N. - m W W M V t - W N �' O W W W O W O O N W W r (() ap a0 +
('7 ('7 r C N'• C O � O 0 0 (3 0 C 0 O O O O O
2
T
n.
`
m
O
-
-E.9-a"-4"V:1-T°.
"EvC_;9
E
aUUHm11m��
V
m Z go,a~d
y H a O>
f0 _ w m
a) (` , O. O C
E0°.%-!%-0--
N H a)
0 ccE(n d 05 O
O
0. N
O NQ
O fY
0.
00'000 0 00 0 000 000000 0 0 0
O W N- O O O O O O O 47 O O O O O O O Nov0 O J
W�( O O C0 mom W n O'. W W o M N O NO ,�
N M W.- M CO M W M r - M M' W W r - r -.- O N W' W N E
.- M, V V - U) 66.- '666 O O (•) O (0 .- .-6. .0 C coE
0 d
E
c
=
N
Co
CO
o
o co
m m
r S c
a)
dg co
ED- 0 C a
2 C O. I-
^,
—
>
C
_
0
Q
m
O j,,, CO W Cr 0) 1�0p • W 0) W O O (L(p0p r- N W f- f- O f� Cn Cn' co co f- co W O m m W, r 0) 01 CO Ce) apl >
O 0- V )N rO M sa U (M0 CO co so ( CO s0 in U 0 (s0 u V (LO LO CO V U (0 W CCD (L0 (L0 r n' N' N E C>
Z W O
CD
Q)
C4
V
>j
k. ,0,0.,0,0,0 N N (V N, N • N N 0
OCU
O V QLLQWWOQQM W QMLLf�f�f+Oti
.2W_NNOOOO ICONNNO.ON000O.ONNON___N>wUOA
OOO-N oOOo.7,(010WW,NWW0)00)O)OOO 00)0).0
E 0OOOOOOOOOOOOO1'-,'-oOO.o OQ
as J m
0
•
0 0) 0) 0) W 0) 0) 0) O 0) 0) O 0) 0) 0) 0) O O_ O_' O O O O?O _O O O O _O O; _O O_
O O O O O' 0 0.- O' O. - O o 0 0 0
L r V- 10 0 N O 0) 0) p O 0) W O O 0) 0) -- Cm' N- (D (0 n N n N m C+7.H...7.....7:.
'. ti
` Q ,-,-.- N O. - O. - m N N.- `. N N N\ N O' .- N M' O N N O N N .. - N
N 000, 0000.- o o,- r,- 00000000000'0000''0
n
4 U'OCU.m
m m OXY-mteZivmt073mtaOmi—r
9"1 1¢1 1¢L (Zj 1¢i O m le m O U f2 6112 i O m U 6',12.1.,1_ LL' LL U m1_ 1 LL fO'. m
81 3 CZ/)' 3 0 D r4 D m m 3 U VZ) CZ/) U1) � Y'. (Z 0 3 ., D 0 CZC) (Z 0. 2''',, m, m 5 _' m
d>
.0
Z
VM
0) CO N W W m N ...--
, X N
Z H -W CO 303 7 _sec-) W1,0L0:9.0)—..-4ifsl
X X' (V uj C O N X >' `( ,-,-X 0. :,-,c003: 11
(M') (M') CD (M') MI s W M M co M M M' M m Q)' ,,,co co
M d N Q) M .-6‘4- M, W M,
M M M ' N:) m M M C')0)0) M M M N:7 CO C')
O
O.
`Q 0 0
m0 U Z U Q
Y U U Q ' U ' U'
C U Y , cn ,
Q' °M102 -g133 m Q• Q C,
Z U U' m, m Z U U'' N8 m
U , (6 m U ca. cD m (/) Z Z ( co m
)) o :g o 03 2. 0 0 c o c' U (73
o c ...c(7,,.- 0„_o
O. m• m a) 0 co o a) > ' m' CO CO a) ' a)'
w m m Q m' (0 Cp w m In Y O) m 0 m' _C "0
Li- '�,
C ca)• L4 :Q
a) a) •
U C d= m O
Vco
V 7 C m @ al N 20
U u) CO 0 V C6 (A Cl. CO m d
m U > co 6 N Y� >,. co U)m'g', c' c0)0. O'C NOj o
m Z • rn o
.` a),Q C y
E a) tC„0 c m m a)' @' 0, 0) V -0;2—
Q L 06 y Y (6 C Z N (/) m C6 -f,
c2
°e °: E o m m'', �� o— 8 Y' E, o- U d
c c D, E• >, m d U 0 3,=I a'_' c E a' , a) F
CO m o o a) -0 CI. CO m 0.2I E m o'l o E co
Zm m'.U'=YJn. '.0.'U)U)'U)m,�mUIU 11HD
C
•V
m
N
C
a>
E+
0
(0 7'U 7 13 f`p, % O)(CO mom', jl 7��
m m' m m g v a) r E m' _c E colco y crap m, m co— c. ¢ v ¢ m• N¢
EI eL0E J >,' 2, O' E'Z—
io ul •
C
-J J C U E J E C N O C J' O .`O. >yU U) U CO Z Ui
LL U
_,_' m 0. E= E co O, O m 2' O ou_. E;11 LL•='.1L' O Zi E'. co Z 11'' OIZ
u_11 U 11.0 0.'O m.=',5. U 0 0_ 0 0,YIl1 O 5'O u_ u_ u_AL'- LLIQ'm u_ u_�,2'u.
(7 d.
{V m F,
J
>
C
Memorandum
Date: October 14, 2010
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find September 2010 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
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
5,141,500
599,285
198,923
305,179
3,100
78,525
45,050
16,967
22,783
500
377,019 (4,764,481)
1,289,304 690,019
211,621 12,698
398,800 93,621
378 (2,722)
17,607 (60,918)
55,172 10,122
(16,967)
22,540 (243)
500 0
6,411,812 2,372,941 (4,038,871)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
2%
54%
27%
33%
3%
6%
31%
0%
25%
25%
a) 20,566,000
b) 2,397,138
c) 795,690
1,220,714
12,398
314,100
c) 180,200
67,866
91,132
2,000
20,566,000
2,397,138
795,690
1,220,714
12,398
314,100
180,200
67,866
91,132
2,000
9% 25,647,238 25,647,238
14,711,812 12,050,641 (2,661,171) 25% 35% 33,947,238 35,324,937 1,377,699
845,555
371,032
18,851
1,220,532
211,728
65,549
63,307
28,051
547,972
1,870,694
5,243,271
3,243,541
8,486,812
6,225,000
771,729
286,936
15,458
1,147,684
194,186
64,706
63,145
26,851
346,333
2,917,027
3,521,804
6,438,831
5,611,810
73,826
84,096
3,393
72,848
17,542
843
162
1,200
201,639
1,870,694
2,326,244
(278,263)
2,047,981
(613,190)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp. %
23%
19%
21%
24%
23%
25%
25%
24%
16%
n/a
14%
27%
19%
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
20,973,074
12,974,164
33,947,238
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
13,490,300 7,482,774
12,974,164
26,464,464 7,482,774
8,860,473 8,860,473
a) Approximately 85% of the property taxes are collected in October and November
b) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
c) YTD Actual includes A&T grant received quarterly in advance
Year End
$
Budget
Projection
Variance
$ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699
5,141,500
599,285
198,923
305,179
3,100
78,525
45,050
16,967
22,783
500
377,019 (4,764,481)
1,289,304 690,019
211,621 12,698
398,800 93,621
378 (2,722)
17,607 (60,918)
55,172 10,122
(16,967)
22,540 (243)
500 0
6,411,812 2,372,941 (4,038,871)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
2%
54%
27%
33%
3%
6%
31%
0%
25%
25%
a) 20,566,000
b) 2,397,138
c) 795,690
1,220,714
12,398
314,100
c) 180,200
67,866
91,132
2,000
20,566,000
2,397,138
795,690
1,220,714
12,398
314,100
180,200
67,866
91,132
2,000
9% 25,647,238 25,647,238
14,711,812 12,050,641 (2,661,171) 25% 35% 33,947,238 35,324,937 1,377,699
845,555
371,032
18,851
1,220,532
211,728
65,549
63,307
28,051
547,972
1,870,694
5,243,271
3,243,541
8,486,812
6,225,000
771,729
286,936
15,458
1,147,684
194,186
64,706
63,145
26,851
346,333
2,917,027
3,521,804
6,438,831
5,611,810
73,826
84,096
3,393
72,848
17,542
843
162
1,200
201,639
1,870,694
2,326,244
(278,263)
2,047,981
(613,190)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp. %
23%
19%
21%
24%
23%
25%
25%
24%
16%
n/a
14%
27%
19%
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
20,973,074
12,974,164
33,947,238
3,382,219
1,484,127
75,403
4,882,127
846,910
262,197
253,227
112,203
2,191,887
7,482,774
13,490,300 7,482,774
12,974,164
26,464,464 7,482,774
8,860,473 8,860,473
a) Approximately 85% of the property taxes are collected in October and November
b) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452.
c) YTD Actual includes A&T grant received quarterly in advance
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997
Revenues
Federal Grants 3,882 (3,882) 25% 0% a) 15,527 15,527
SB #1065 -Court Assess. 15,000 11,582 (3,418) 25% 19% 60,000 60,000
Discovery Fee 4,000 1,675 (2,325) 25% 10% 16,000 16,000
Food Subsidy 9,500 6,098 (3,402) 25% 16% d) 38,000 38,000
OYA Basic & Diversion 85,002 (85,002) 25% 0% a) 340,006 340,006
Inmate/Prisoner Housing 25,000 13,500 (11,500) 25% 14% 100,000 100,000
Inmate Commissary Fees 25 54 29 25% 54% 100 100
Contract Payments 22,123 15,124 (6,999) 25% 17% 88,490 88,490
Miscellaneous 75 20 (55) 25% 7% 300 300
MIP Diversion Fees 250 50 (200) 25% 5% 1,000 1,000
Interest on Investments 4,250 2,491 (1,759) 25% 15% 17,000 17,000
Leases 600 600 25% 25% 2,400 2,400
Grants - Private 125 219 94 25% 44% 500 500
Health & Human Svcs Chg 1,500 (1,500) 25% 0% d) 6,000 6,000
CCF Interfund Grant 15,124 (15,124) 25% 0% a)b) 60,495 96,500 36,005
Gen Fund Grant -Crime Prev. 5,000 (5,000) 25% 0% a) 20,000 20,000
Total Revenues 191,456 51,413 (140,043) 25% 7% 765,818 801,823 36,005
Transfers In -General Fund 1,385,797 1,385,796 (1) 25% 25% 5,543,186 5,543,186
TOTAL RESOURCES 2,564,253 2,477,206 (87,047) 25% 34% 7,296,004 7,385,006 89,002
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
740,989 676,161 64,828 25% 23% 2,963,956 2,963,956
Materials and Services 299,972 227,674 72,298 25% 19% 1,199,886 1,199,886
Capital Outlay 25 25 25% 0% 100
Juvenile Resource Center
Personal Services 583,866 549,441 34,425 25% 24% 2,335,462 2,335,462
Materials and Services 43,874 44,402 (528) 25% 25% c) 175,494 175,494
Contingency 155,277 155,277 25% n/a 621,106
100
621,106
TOTAL REQUIREMENTS 1,824,003 1,497,678 326,325 25% 21% 7,296,004 6,674,798 621,206
NET (Resources - Requirements) 740,250 979,528 239,278 - 710,208 710,208
a) Reimbursements received quarterly in arrears
b) Additional funding from CCF allocated for Juvenile programs
c) Negative variance due to a $10,000 annual subscription expended in July
d) Awaiting reimbursements from current billings
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 987,000 $ 1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997
Revenues
Federal Grants 3,882 (3,882) 25% 0% a) 15,527 15,527
SB #1065 -Court Assess. 15,000 11,582 (3,418) 25% 19% 60,000 60,000
Discovery Fee 4,000 1,675 (2,325) 25% 10% 16,000 16,000
Food Subsidy 9,500 6,098 (3,402) 25% 16% d) 38,000 38,000
OYA Basic & Diversion 85,002 (85,002) 25% 0% a) 340,006 340,006
Inmate/Prisoner Housing 25,000 13,500 (11,500) 25% 14% 100,000 100,000
Inmate Commissary Fees 25 54 29 25% 54% 100 100
Contract Payments 22,123 15,124 (6,999) 25% 17% 88,490 88,490
Miscellaneous 75 20 (55) 25% 7% 300 300
MIP Diversion Fees 250 50 (200) 25% 5% 1,000 1,000
Interest on Investments 4,250 2,491 (1,759) 25% 15% 17,000 17,000
Leases 600 600 25% 25% 2,400 2,400
Grants - Private 125 219 94 25% 44% 500 500
Health & Human Svcs Chg 1,500 (1,500) 25% 0% d) 6,000 6,000
CCF Interfund Grant 15,124 (15,124) 25% 0% a)b) 60,495 96,500 36,005
Gen Fund Grant -Crime Prev. 5,000 (5,000) 25% 0% a) 20,000 20,000
Total Revenues 191,456 51,413 (140,043) 25% 7% 765,818 801,823 36,005
Transfers In -General Fund 1,385,797 1,385,796 (1) 25% 25% 5,543,186 5,543,186
TOTAL RESOURCES 2,564,253 2,477,206 (87,047) 25% 34% 7,296,004 7,385,006 89,002
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
740,989 676,161 64,828 25% 23% 2,963,956 2,963,956
Materials and Services 299,972 227,674 72,298 25% 19% 1,199,886 1,199,886
Capital Outlay 25 25 25% 0% 100
Juvenile Resource Center
Personal Services 583,866 549,441 34,425 25% 24% 2,335,462 2,335,462
Materials and Services 43,874 44,402 (528) 25% 25% c) 175,494 175,494
Contingency 155,277 155,277 25% n/a 621,106
100
621,106
TOTAL REQUIREMENTS 1,824,003 1,497,678 326,325 25% 21% 7,296,004 6,674,798 621,206
NET (Resources - Requirements) 740,250 979,528 239,278 - 710,208 710,208
a) Reimbursements received quarterly in arrears
b) Additional funding from CCF allocated for Juvenile programs
c) Negative variance due to a $10,000 annual subscription expended in July
d) Awaiting reimbursements from current billings
SHERIFF - Fund 255
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll. %
RESOURCES:
Beg. Net Working Capital $
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
Total Revenues
$ 207,689 $ 207,689 100%
5,707,364
3,416,485
9,123,849
TOTAL RESOURCES 9,123,849
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 701,417
Civil 199,609
Automotive/Communications 363,259
Investigations/Evidence 412,698
Patrol/Civil/Comm Supp 1,957,163
Records 165,097
Adult Jail 2,488,424
Court Security 60,213
Emergency Services 43,610
Special Services Division 284,351
Regional Work Center 692,353
Training Division 82,500
Other Law Enforcement Svcs 144,229
Non -Departmental 70,755
Contingency 1,408,172
Transfers Out - DIS Fund 50,000
nla
$
- $ 207,689
$ 207,689
4,241,618 (1,465,746) 25% 19% 22,829,457 21,363,711 (1,465,746)
2,859,266 (557,219) 25% 21% 13,665,939 13,108,720 (557,219)
4,521 4,521 25% n/a 4,521 4,521
7,105,405 (2,018,444) 25% 19% 36,495,396 34,476,952 (2,018,444)
7,313,094 (1,810,755) 25% 20% 36,495,396 34,684,641 (1,810,755)
627,747
206,866
547,389
389,862
1,837,957
150,310
2,040,837
66,349
42,922
300,137
623,988
69,054
134,877
20,755
73,670
(7,257)
(184,130)
22,836
119,206
14,787
447,587
(6,136)
688
(15,786)
68,365
13,446
9,352
50,000
1,408,172
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp. %
22%
26%
38% a)
24%
23%
23%
21% b)
28%
25%
26%
23%
21%
23%
7%
n/a
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
5,632,690
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
- 5,632,690
50,000 25% 0% 200,000 200,000
TOTAL REQUIREMENTS 9,123,850
NET (Resources - Requirements)
7,059,050 2,064,800 25% 19% 36,495,396 30,862,706 5,632,690
254,044 254,044
a) Annual expenditure for Interagency Communications System was made in July
b) Variance due to hiring delays and timing of jail bed rental
- 3,821,935 3,821,935
Year End
Budget
Projection
Variance
$
- $ 207,689
$ 207,689
4,241,618 (1,465,746) 25% 19% 22,829,457 21,363,711 (1,465,746)
2,859,266 (557,219) 25% 21% 13,665,939 13,108,720 (557,219)
4,521 4,521 25% n/a 4,521 4,521
7,105,405 (2,018,444) 25% 19% 36,495,396 34,476,952 (2,018,444)
7,313,094 (1,810,755) 25% 20% 36,495,396 34,684,641 (1,810,755)
627,747
206,866
547,389
389,862
1,837,957
150,310
2,040,837
66,349
42,922
300,137
623,988
69,054
134,877
20,755
73,670
(7,257)
(184,130)
22,836
119,206
14,787
447,587
(6,136)
688
(15,786)
68,365
13,446
9,352
50,000
1,408,172
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp. %
22%
26%
38% a)
24%
23%
23%
21% b)
28%
25%
26%
23%
21%
23%
7%
n/a
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
5,632,690
2,805,668
798,436
1,453,036
1,650,792
7,828,651
660,386
9,953,695
240,851
174,441
1,137,404
2,769,411
330,000
576,917
283,018
- 5,632,690
50,000 25% 0% 200,000 200,000
TOTAL REQUIREMENTS 9,123,850
NET (Resources - Requirements)
7,059,050 2,064,800 25% 19% 36,495,396 30,862,706 5,632,690
254,044 254,044
a) Annual expenditure for Interagency Communications System was made in July
b) Variance due to hiring delays and timing of jail bed rental
- 3,821,935 3,821,935
SHERIFF 701
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 4,722,862 $ 5,478,092 $ 755,230 100%
Revenues
Tax Revenues - Current 3,713,399 - (3,713,399) 25%
Tax Revenues - Prior 160,500 274,019 113,519 25%
Federal Grants 8,750 (8,750) 25%
State Grant 12,119 18,162 6,043 25%
Transp. of State Wards 1,250 (1,250) 25%
SB 1145 493,665 493,665 25%
Des. Cty Video Lottery Grant 1,250 (1,250) 25%
Des Cty Court Security 23,750 23,714 (36) 25%
Title 111 Reimbursement 37,500 - (37,500) 25%
Transport 1,000 83 (917) 25%
DC Fair & Expo Center 3,825 3,825 25%
Inmate Commissary Fees 12,000 19,280 7,280 25%
Work Center Work Crews 6,250 14,820 8,570 25%
Concealed Handgun Classes 1,500 1,050 (450) 25%
Soc Sec Incentive -Fed 1,250 1,800 550 25%
Miscellaneous 1,250 2,753 1,503 25%
Oregon Mentors - 3,120 3,120 25%
Medical Services Reimb 3,000 4,984 1,984 25%
Restitution 250 2,795 2,545 25%
Sheriff Fees 40,000 74,014 34,014 25%
Interest 7,083 6,990 (93) 25%
Interest on Unsegregated 883 100 (783) 25%
Donations 200 200 25%
Total Revenues 4,526,648 945,374 (3,581,274) 25%
TOTAL RESOURCES
116% $ 4,722,862 $ 5,478,092 $ 755,230
0%
43%
0%
37%
0%
25%
0%
25%
0%
2%
n/a
40%
59%
18%
36%
55%
n/a
42%
280%
46%
25%
3%
n/a
5%
a) 14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
48,000
25,000
6,000
5,000
5,000
12,000
1,000
160,000
28,333
3,533
14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
3,825
48,000
25,000
6,000
5,000
5,000
5,000
12,000
5,000
160,000
28,333
3,533
200
3,825
5,000
4,000
200
18,106,595 18,119, 620 13,025
9,249,510 6,423,466 (2,826,045) 25% 28% 22,829,457 23,597,712 768,255
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 5,707,364
TOTAL REQUIREMENTS
Exp. %
4,241,618 1,465,746 25% 19% b) 22,829,457 21,363,711 1,465,746
5,707,364 4,241,618 1,465,746 25% 19% 22,829,457 21,363,711 1,465,746
NET (Resources - Requirements) 3,542,146 2,181,848 (1,360,299)
a) Approximately 85% of the property taxes are collected in October and November
b) Payment to Sheriffs Office adjusted to actual quarterly
- 2,234,001 2,234,001
Year End
Budget
Projection
Variance
116% $ 4,722,862 $ 5,478,092 $ 755,230
0%
43%
0%
37%
0%
25%
0%
25%
0%
2%
n/a
40%
59%
18%
36%
55%
n/a
42%
280%
46%
25%
3%
n/a
5%
a) 14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
48,000
25,000
6,000
5,000
5,000
12,000
1,000
160,000
28,333
3,533
14,853,594
642,000
35,000
48,475
5,000
1,974,660
5,000
95,000
150,000
4,000
3,825
48,000
25,000
6,000
5,000
5,000
5,000
12,000
5,000
160,000
28,333
3,533
200
3,825
5,000
4,000
200
18,106,595 18,119, 620 13,025
9,249,510 6,423,466 (2,826,045) 25% 28% 22,829,457 23,597,712 768,255
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 5,707,364
TOTAL REQUIREMENTS
Exp. %
4,241,618 1,465,746 25% 19% b) 22,829,457 21,363,711 1,465,746
5,707,364 4,241,618 1,465,746 25% 19% 22,829,457 21,363,711 1,465,746
NET (Resources - Requirements) 3,542,146 2,181,848 (1,360,299)
a) Approximately 85% of the property taxes are collected in October and November
b) Payment to Sheriffs Office adjusted to actual quarterly
- 2,234,001 2,234,001
RESOURCES:
Beg. Net Working Capital $1,905,939 $ 2,421,863 $ 515,924 100%
Revenues
Tax Revenues - Current 1,877,061 (1,877,061) 25%
Tax Revenues - Prior 78,500 138,666 60,166 25%
Federal Grants 500 (500) 25%
Federal Grants 2,982 2,982 25%
US Forest Service 19,125 12,750 (6,375) 25%
State Grant 46,908 13,508 (33,400) 25%
SB #1065 Court Assessment 16,750 11,582 (5,168) 25%
Marine Board License Fee 35,608 (35,608) 25%
Des Cty General Fund Grant 175,590 (175,590) 25%
Des Cty Transient Room Tax 486,911 486,911 - 25%
City of Sisters 108,164 108,164 25%
Des Cty Tax/Fin Contract 250 (250) 25%
Des Cty CDD Contract 13,592 13,592 - 25%
Des Cty Solid Waste Contr 13,592 13,592 - 25%
Des Cty Clerk/Election 500 (500) 25%
School Districts 25,000 (25,000) 25%
Security & Traffic Reimb 3,250 1,081 (2,169) 25%
Seat Belt Program 1,500 1,975 475 25%
Miscellaneous 2,500 5,148 2,648 25%
Restitution 125 (125) 25%
Sheriff Fees 2,500 2,476 (24) 25%
Court Fines & Fees 21,250 32,678 11,428 25%
Impound Fees 3,750 1,800 (1,950) 25%
Restitution - Street Crimes 125 (125) 25%
Interest 2,500 2,236 (264) 25%
Interest on Unsegregated 450 49 (401) 25%
Sale of Reportable Assets 2,500 14,904 12,404 25%
Sale of Equip & Material 1,500 976 (524) 25%
Total Revenues 2,940,001 865,070 (2,074,931) 25%
SHERIFF 702
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll. %
TOTAL RESOURCES
127% $ 1,905,939
0%
44%
0%
ilia
17%
7%
17%
0%
0%
25%
25%
0%
25%
25%
0%
0%
8%
33%
51%
0%
25%
38%
12%
0%
22%
3%
149%
16%
7%
a) 7,508,247
314,000
2,000
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
b) 10,000
6,000
$ 2,421,863 $ 515,924
7,508,247
314,000
2,000
2,982 2,982
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
20,000 10,000
6,000
11,760,000
11,772,982 12,982
4,845,940 3,286,933 (1,559,007) 25% 24% 13,665,939 14,194,845 528,906
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,416,485
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
2,859,266 557,219 25% 21% c) 13,665,939 13,108,720 557,219
3,416,485 2,859,266 557,219 25% 21% 13,665,939 13,108,720 557,219
1,429,455 427,667 (1,001,788)
a) Approximately 85% of the property taxes are collected in October and November
b) Proceeds from sale of used patrol vehicles were higher than anticipated
c) Payment to Sheriffs Office adjusted to actual quarterly
- 1,086,125 1,086,125
Year End
Budget
Projection
Variance
127% $ 1,905,939
0%
44%
0%
ilia
17%
7%
17%
0%
0%
25%
25%
0%
25%
25%
0%
0%
8%
33%
51%
0%
25%
38%
12%
0%
22%
3%
149%
16%
7%
a) 7,508,247
314,000
2,000
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
b) 10,000
6,000
$ 2,421,863 $ 515,924
7,508,247
314,000
2,000
2,982 2,982
76,500
187,633
67,000
142,433
702,358
1,947,642
432,655
1,000
54,366
54,366
2,000
100,000
13,000
6,000
10,000
500
10,000
85,000
15,000
500
10,000
1,800
20,000 10,000
6,000
11,760,000
11,772,982 12,982
4,845,940 3,286,933 (1,559,007) 25% 24% 13,665,939 14,194,845 528,906
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,416,485
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
2,859,266 557,219 25% 21% c) 13,665,939 13,108,720 557,219
3,416,485 2,859,266 557,219 25% 21% 13,665,939 13,108,720 557,219
1,429,455 427,667 (1,001,788)
a) Approximately 85% of the property taxes are collected in October and November
b) Proceeds from sale of used patrol vehicles were higher than anticipated
c) Payment to Sheriffs Office adjusted to actual quarterly
- 1,086,125 1,086,125
PUBLIC HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Revised
Year to Date
Budget
Budget
Actual I Variance
FY %
Coll. %
Revised
Year End
Budget
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 2,000 (2,000) 25% 0% 8,000 8,000
State Grant 623,744 637,675 13,931 25% 26% a) 2,494,977 2,552,757 57,780
Child Dev & Rehab Center 7,690 (7,690) 25% 0% 30,759 30,759
State Miscellaneous 54,974 40,243 (14,731) 25% 18% 219,896 219,896
OMAP 119,450 110,306 (9,144) 25% 23% 477,800 477,800
Family Planning Exp Proj 123,750 94,221 (29,529) 25% 19% 495,000 495,000
Grants 16,250 48,773 32,523 25% 75% b) 65,000 113,773 48,773
Water Program -Base Fee 10,500 9,386 (1,114) 25% 22% 42,000 42,000
Water Program -Field Work 13,954 14,840 886 25% 27% 55,817 55,817
H2O Sys Insp-Priv Wells 50 (50) 25% 0% 200 200
Miscellaneous - 201 201 25% n/a 201 201
Patient Insurance Fees 47,565 24,722 (22,843) 25% 13% 190,260 190,260
Health Dept/Patient Fees 37,244 24,239 (13,005) 25% 16% 148,975 148,975
Vital Records -Birth 9,000 7,970 (1,030) 25% 22% 36,000 36,000
Vital Records -Death 24,500 26,660 2,160 25% 27% 98,000 98,000
Environmental Health 171,838 42,789 (129,049) 25% 6% 687,350 687,350
Interest on Investments 4,225 3,073 (1,152) 25% 18% 16,900 16,900
Donations 1,500 30,315 28,815 25% 505% c) 6,000 31,880 25,880
Interfund Contract 47,345 (47,345) 25% 0% 189,378 189,378
Administrative Fee 6,750 6,750 25% 25% 27,000 27,000
Total Revenues 1,322,329 1,122,163 (200,166) 25% 21% 5,289,312 5,421,946 132,634
Transfers In -General Fund 579,441 579,441 - 25% 25% 2,317,765 2,317,765
Transfers In -PH Res Fund 16,781 (16,781) 25% 0% 67,123 67,123
Transfers In -Gen. Fund Other 16,953 16,953 25% 25% 67,812 67,812
TOTAL RESOURCES 3,035,504 3,333,863 298,359 25% 38% 8,842,012 9,489,952 647,940
REQUIREMENTS:
Expenditures
Personal Services 1,482,394
Materials and Services 499,691
Capital Outlay 6,250
Transfers Out 37,500
Contingency 184,668
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
1,378,189 104,205 25% 23% 5,929,577 5,929,577
450,364 49,327 25% 23% 1,998,763 1,998,763
6,250 25% 0% 25,000 25,000
37,500 - 25% 25% 150,000 150,000
184,668 25% n/a 738,672
738,672
2,210,503 1,866,053 344,450 25% 21% 8,842,012 8,103,340 738,672
825,001 1,467,810 642,809 - 1,386,612 1,386,612
a) Department of Human Services Grant projected at amended contract amount for FY 11
b) Health Matters -local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July
c) My Future My Choice donation carry over from FY10, in the amount of $25,880
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Interest on Investments
Rentals
Interfund Contract -Gen. Fund
Comm. on Children & Fam
Administrative Fee
Total Revenues
Transfers In -General Fund
Transfers In-OHP-CDO
Transfers In -Acute Care Svcs
Transfers In-ABHA
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
$ 2,616,050 $
1,375
32,500
250
24,242
1,323,466
37,043
75,231
26,350
17,500
4,225
38,500
3,250
10,896
3,275
31,750
6,000
990,287
2,651,262 $ 35,212 100% 101%
1,975 600
33,407 907
15 (235)
(24,242)
(119,863)
(21,175)
(56,888)
(12,274)
(10,860)
484
(25,166)
(2,822)
(4,374)
(400)
(31,750)
- (6,000)
969,036 (21,251)
1,203,603
15,868
18,343
14,076
6,640
4,709
13,334
428
6,522
2,875
2,626,140
329,040
24,999
91,413
167,063
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
36%
26%
2%
0% a)
23% b)
11%
6%
13%
9%
28%
9%
3%
15%
22%
0% a)
0%
24%
Revised
Year End
Budget
Projection
Variance
$ 2,616,050 $ 2,651,262 $ 35,212
5,500
130,000
1,000
96,969
5,293,862
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
127,000
24,000
3,961,146
5,500
130,000
1,000
96,969
5,020,888 (272,974)
148,173
300,925
105,400
70,000
16,900
154,000
13,000
43,585
13,100
127,000
24,000
3,961,146
2,290,831 (335,309) 25% 22% 10,504,560 10,231,586 (272,974)
329,040
24,999
91,413
167,063
5,854,705
2,307,477
1,000,725
185,000
39,291
360,176
25% 25% 1,316,158
25% 25% 100,000
25% 25% 365,657
25% 25% 668,252
1,316,158
100,000
365,657
668,252
5,554,608 (300,097) 25% 36% 15,570,677 15,332,915 (237,762)
2,154,147
733,064
153,330
267,661
185,000
37,500 1,791
360,176
3,892,669
2,924,711 967,958
1,962,036
2,629,897 667,861
Exp. %
25% 23%
25% 18%
25% 0%
25% 24%
25% n/a
9,229,909
4,002,901
740,000
157,164
1,440,703
9,229,909
4,002,901
740,000
157,164
1,440,703
25% 19% 15,570,677 14,129,974 1,440,703
a) Grant billing received quarterly, in arrears
b) Department of Human Services Grant projected at amended contract amount for FY 11
- 1,202,941 1,202,941
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
CoII.
RESOURCES:
Beg. Net Working Capital $ 686,081
Revenues
Admin -Operations 4,125
Admin -GIS 688
Admin -Code Enforcement 40,430
Building Safety 270,304
Electrical 66,663
Contract Services 46,000
Env Health -On Site Prog 70,958
Planning -Current 194,241
Planning -Long Range 88,443
613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
5,093
915
39,886
242,644
71,836
40,212
80,406
219,306
59,008
968
227
(544)
(27,660)
5,173
(5,788)
9,448
25,065
(29,435)
Total Revenues 781,852
Trans In -GF
Trans In -GF for Lng Rng Ping
TOTAL RESOURCES
25%
25%
25%
25%
25%
25%
25%
25%
25%
31%
33% a)
25%
22% b)
27%
22% c)
28%
28%
17% d)
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
16,500
2,500 (250)
161,718
1,081,217
266,652
175,000 (9,000)
283,830
776,962
353,771
759,306 (22,546) 25% 24% 3,127,400 3,118,150 (9,250)
63,348 63,348
129,000 129,000
- 25% 25% 253,387 253,387
- 25% 25% 516,000 516,000
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Pgm
Planning -Current
Planning -Long Range
Transfers Out (D/S Fund)
Contingency
1,660,281 1,564,685
350,599
54,034
46,183
125,083
46,902
61,063
58,002
172,573
123,107
43,328
64,846
341,517
50,917
45,380
119,890
43,512
59,249
99,200
128,789
160,698
(95,596) 25% 34% 4,582,868 4,500,568 (82,300)
9,082
3,117
803
5,193
3,390
1,814
(41,198)
43,784
(37,591)
43,328
64,846
TOTAL REQUIREMENTS 1,145,720 1,049,152
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp.
24%
24%
25%
24%
23%
24%
43% e)
19%
33% f)
0%
n/a
1,402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
1,402,396
216,135
184,732
500,330
187,606
244,251
220,000
690,290
492,427
173,310
12,006
259,385
96,568 25% 23% 4,582,868 4,311,477 271,391
NET (Resources - Requirements) 514,561
Revenues
Expenditures
Net from Operations
515,533 972 189,091 189,091
759,306
1,049,152
(289,846)
3,127,400 3,118,150 (9,250)
4,582,868 4,311,477 271,391
(1,455,468) (1,193,327) 262,141
a) Custom GIS work revenue sporadic
b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, as several Targe projects are expected
to generate significant revenue later in the fiscal year
c) City of Redmond receipts lag one month behind
d) Grant payments received irregularly
e) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled
f) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue
Year End
Budget
Projection
Variance
613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050)
5,093
915
39,886
242,644
71,836
40,212
80,406
219,306
59,008
968
227
(544)
(27,660)
5,173
(5,788)
9,448
25,065
(29,435)
Total Revenues 781,852
Trans In -GF
Trans In -GF for Lng Rng Ping
TOTAL RESOURCES
25%
25%
25%
25%
25%
25%
25%
25%
25%
31%
33% a)
25%
22% b)
27%
22% c)
28%
28%
17% d)
16,500
2,750
161,718
1,081,217
266,652
184,000
283,830
776,962
353,771
16,500
2,500 (250)
161,718
1,081,217
266,652
175,000 (9,000)
283,830
776,962
353,771
759,306 (22,546) 25% 24% 3,127,400 3,118,150 (9,250)
63,348 63,348
129,000 129,000
- 25% 25% 253,387 253,387
- 25% 25% 516,000 516,000
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Pgm
Planning -Current
Planning -Long Range
Transfers Out (D/S Fund)
Contingency
1,660,281 1,564,685
350,599
54,034
46,183
125,083
46,902
61,063
58,002
172,573
123,107
43,328
64,846
341,517
50,917
45,380
119,890
43,512
59,249
99,200
128,789
160,698
(95,596) 25% 34% 4,582,868 4,500,568 (82,300)
9,082
3,117
803
5,193
3,390
1,814
(41,198)
43,784
(37,591)
43,328
64,846
TOTAL REQUIREMENTS 1,145,720 1,049,152
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Exp.
24%
24%
25%
24%
23%
24%
43% e)
19%
33% f)
0%
n/a
1,402,396
216,135
184,732
500,330
187,606
244,251
232,006
690,290
492,427
173,310
259,385
1,402,396
216,135
184,732
500,330
187,606
244,251
220,000
690,290
492,427
173,310
12,006
259,385
96,568 25% 23% 4,582,868 4,311,477 271,391
NET (Resources - Requirements) 514,561
Revenues
Expenditures
Net from Operations
515,533 972 189,091 189,091
759,306
1,049,152
(289,846)
3,127,400 3,118,150 (9,250)
4,582,868 4,311,477 271,391
(1,455,468) (1,193,327) 262,141
a) Custom GIS work revenue sporadic
b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, as several Targe projects are expected
to generate significant revenue later in the fiscal year
c) City of Redmond receipts lag one month behind
d) Grant payments received irregularly
e) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled
f) Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue
ROAD
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100%
Revenues
Mineral Lease Royalties 5,000 5,108 108 25% 26% 20,000 20,000
Forest Receipts 559,250 (559,250) 25% 0% a) 2,237,000 2,237,000
State Miscellaneous 24,246 (24,246) 25% 0% 96,984 96,984
Motor Vehicle Revenue 2,500,000 2,024,516 (475,484) 25% 20% b) 10,000,000 10,000,000
City of Bend 68,750 (68,750) 25% 0% c) 275,000 275,000
City of Redmond 87,500 (87,500) 25% 0% c) 350,000 350,000
City of Sisters 2,500 (2,500) 25% 0% c) 10,000 10,000
City of La Pine 2,500 - (2,500) 25% 0% c) 10,000 10,000
Admin Recovery (SDC) - 507 507 25% n/a 1,000 1,000
Miscellaneous 5,000 8,134 3,134 25% 41% 20,000 20,000
Road Vacations 250 500 250 25% 50% 1,000 1,000
Interest on Investments 10,000 7,664 (2,336) 25% 19% 40,000 40,000
Other Bank/LGIP Interest - 61 61 25% n/a - 100 100
Parking Fees 225 - (225) 25% 0% 900 900
Interfund Contract 187,500 234 (187,266) 25% 0% d) 750,000 750,000
Equipment Repairs 62,500 33,759 (28,741) 25% 14% 250,000 250,000
Vehicle Repairs 22,500 (22,500) 25% 0% 90,000 90,000
LID Construction 2,500 (2,500) 25% 0% d) 10,000 10,000
Vegetation Management 8,750 (8,750) 25% 0% d) 35,000 35,000
Forester 6,250 (6,250) 25% 0% d) 25,000 25,000
Car Washes 750 (750) 25% 0% 3,000 3,000
Car Rental 125 - (125) 25% 0% 500 500
Sale of Equip & Material 150,875 78,573 (72,302) 25% 13% 603,500 603,500
$ 3,430,429 $ 3,419,603 $ (10,826)
Total Revenues 3,706,971 2,159,056 (1,547,915) 25% 15% 14,827,884 14,828,984 1,100
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
72,935
50,000
3,010
72,935
50,000
25% 25%
25% 25%
(3,010) 25% 0%
291,740
200,000
12,040
291,740
200,000
12,040
7,263,345 5,701,594 (1,561,751) 25% 39% 18,762,093 18,752,367 (9,726)
REQUIREMENTS:
Expenditures
Personal Services 1,438,242
Materials and Services 2,350,256
Capital Outlay 292,923
Transfers Out 100,000
Contingency 509,103
Exp.
1,328,404 109,838 25% 23% 5,752,967 5,752,967
2,353,269 (3,013) 25% 25% 9,401,023 9,401,023
292,923 25% 0% 1,171,691 1,171,691
- 100,000 25% 0% 400,000 400,000 -
509,103 25% n/a 2,036,412 2,036,412
TOTAL REQUIREMENTS 4,690,524 3,681,673 1,008,851 25% 20% 18,762,093 16,725,681 2,036,412
NET (Resources - Requirements)
2,572,821 2,019,921 (552,900) 2,026,686 2,026,686
a) Annual payment -January 2011
b) Gas tax will increase by 25% ($.06/gal.) effective January 2011
c) Billed upon completion of work
d) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
Year End
Budget
Projection
Variance
$ 3,430,429 $ 3,419,603 $ (10,826)
Total Revenues 3,706,971 2,159,056 (1,547,915) 25% 15% 14,827,884 14,828,984 1,100
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
72,935
50,000
3,010
72,935
50,000
25% 25%
25% 25%
(3,010) 25% 0%
291,740
200,000
12,040
291,740
200,000
12,040
7,263,345 5,701,594 (1,561,751) 25% 39% 18,762,093 18,752,367 (9,726)
REQUIREMENTS:
Expenditures
Personal Services 1,438,242
Materials and Services 2,350,256
Capital Outlay 292,923
Transfers Out 100,000
Contingency 509,103
Exp.
1,328,404 109,838 25% 23% 5,752,967 5,752,967
2,353,269 (3,013) 25% 25% 9,401,023 9,401,023
292,923 25% 0% 1,171,691 1,171,691
- 100,000 25% 0% 400,000 400,000 -
509,103 25% n/a 2,036,412 2,036,412
TOTAL REQUIREMENTS 4,690,524 3,681,673 1,008,851 25% 20% 18,762,093 16,725,681 2,036,412
NET (Resources - Requirements)
2,572,821 2,019,921 (552,900) 2,026,686 2,026,686
a) Annual payment -January 2011
b) Gas tax will increase by 25% ($.06/gal.) effective January 2011
c) Billed upon completion of work
d) Payment to be received in June 2011 from Funds 326, 328, 329, & 340
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278
Revenues
DOC Measure 57 54,326 217,350 163,024 25% 100% a) 217,305 217,350 45
State Miscellaneous 1,075 (1,075) 25% 0% b) 4,301 4,301
Alternate Incarceration 7,730 30,918 23,188 25% 100% a) 30,918 30,918
State Subsidy 3,250 3,327 77 25% 26% 13,000 13,000
SB 1145 740,498 740,497 (1) 25% 25% 2,961,990 2,961,990
Probation Work Crew Fees 9,500 5,395 (4,105) 25% 14% c) 38,000 38,000
Miscellaneous 750 1,260 510 25% 42% 3,000 3,000
Electronic Monitoring Fee 42,500 37,354 (5,146) 25% 22% 170,000 170,000
Probation Superv. Fees 52,500 55,276 2,776 25% 26% 210,000 210,000
Interest on Investments 2,250 2,847 597 25% 32% 9,000 9,000
Interfund - Sheriff 12,500 12,500 - 25% 25% 50,000 50,000
Crime Prevention Grant 12,500 12,500 25% 25% 50,000 50,000
Total Revenues 939,379 1,119,224 179,845 25% 30% 3,757,514 3,757,559 45
Transfers In -General Fund
TOTAL RESOURCES
28,758 28,758
- 25% 25% 115,029 115,029
1,584,508 1,876,631 292,123 25% 42% 4,488,914 4,601,237 112,323
REQUIREMENTS:
Expenditures
Personal Services 788,225
Materials and Services 223,569
Capital Outlay 25
Contingency 110,410
Exp. %
743,504 44,721 25% 24% 3,152,899 3,152,899
178,619 44,950 25% 20% 894,274 894,274
25 25% 0% 100
110,410 25% n/a 441,641
100
441,641
TOTAL REQUIREMENTS 1,122,229 922,123 200,106 25% 21% 4,488,914 4,047,173 441,741
NET (Resources - Requirements)
462,279 954,508 492,229 554,064 554,064
a) Annual payment received in July
b) Payment from Parole Board for hearings not yet received
c) Increase in fee waivers from court due to economic conditions
Year End
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 54,326 217,350 163,024 25% 100% a) 217,305 217,350 45
State Miscellaneous 1,075 (1,075) 25% 0% b) 4,301 4,301
Alternate Incarceration 7,730 30,918 23,188 25% 100% a) 30,918 30,918
State Subsidy 3,250 3,327 77 25% 26% 13,000 13,000
SB 1145 740,498 740,497 (1) 25% 25% 2,961,990 2,961,990
Probation Work Crew Fees 9,500 5,395 (4,105) 25% 14% c) 38,000 38,000
Miscellaneous 750 1,260 510 25% 42% 3,000 3,000
Electronic Monitoring Fee 42,500 37,354 (5,146) 25% 22% 170,000 170,000
Probation Superv. Fees 52,500 55,276 2,776 25% 26% 210,000 210,000
Interest on Investments 2,250 2,847 597 25% 32% 9,000 9,000
Interfund - Sheriff 12,500 12,500 - 25% 25% 50,000 50,000
Crime Prevention Grant 12,500 12,500 25% 25% 50,000 50,000
Total Revenues 939,379 1,119,224 179,845 25% 30% 3,757,514 3,757,559 45
Transfers In -General Fund
TOTAL RESOURCES
28,758 28,758
- 25% 25% 115,029 115,029
1,584,508 1,876,631 292,123 25% 42% 4,488,914 4,601,237 112,323
REQUIREMENTS:
Expenditures
Personal Services 788,225
Materials and Services 223,569
Capital Outlay 25
Contingency 110,410
Exp. %
743,504 44,721 25% 24% 3,152,899 3,152,899
178,619 44,950 25% 20% 894,274 894,274
25 25% 0% 100
110,410 25% n/a 441,641
100
441,641
TOTAL REQUIREMENTS 1,122,229 922,123 200,106 25% 21% 4,488,914 4,047,173 441,741
NET (Resources - Requirements)
462,279 954,508 492,229 554,064 554,064
a) Annual payment received in July
b) Payment from Parole Board for hearings not yet received
c) Increase in fee waivers from court due to economic conditions
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll. %
RESOURCES:
Beg. Net Working Capital $ 562,762
Revenues
Federal Grants 56,613
Title IV - Family Sup/Pres 15,938
HealthyStart Medicaid 23,750
Level 7 Services 64,496
State Prevention Funds 3,625
HealthyStart /R -S -G 77,231
OCCF Grant 151,081
Charges for Svcs-Misc 2,000
Court Fines & Fees 18,750
Interest on Investments 5,000
Grants -Private 1,250
Donations
Miscellaneous 64,639
$ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578
Total Revenues 484,373
(56,613) 25% 0%
(15,938) 25% 0%
(23,750) 25% 0%
(64,496) 25% 0%
(3,625) 25% 0%
70,409 (6,822) 25% 23%
142,043 (9,038) 25% 24%
310 (1,690) 25% 4%
20,044 1,294 25% 27%
1,606 (3,394) 25% 8%
(1,250) 25% 0%
157 157 25% n/a
28,475 (36,164) 25% 11%
263,044 (221,329) 25% 14%
Trans from General Fund 71,082 71,082
Trans from GF -Other 6,250 6,250
- 25%
- 25%
Total Transfers In 77,332 77,332
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
- 25%
1,124,467
149,890
450,342
25
102,139
975,716 (148,751) 25%
123,470
56,727
26,420
393,615
25
102,139
25%
25%
25%
25%
25%
25%
25%
226,450
63,750
95,000
257,984
a) 14,500
b) 308,924
b) 604,323
8,000
75,000
c) 20,000
5,000
d) 258,554
$ 226,450
$ 63,750
$ 95,000
$ 257,984
$ 17,000 2,500
$ 263,596 (45,328)
$ 544,501 (59,822)
$ 8,000
$ 78,000 3,000
$ 8,000 (12,000)
$ 5,000
$ 157 157
$ 118,500 (140,054)
1,937,485 1,685,938 (251,547)
284,333 284,333
25,000 25,000
309,333 309,333
35% 2,809,580 2,630,611
Exp.
21% e)
3% b)
0%
n/a
599,559
1,801,367
100
408,554
543,424
1,657,922
(178,969)
56,135
143,445
100
408,554
TOTAL REQUIREMENTS 702,396 180,197 522,199 25% 6% 2,809,580 2,201,346 608,234
NET (Resources - Requirements) 422,071 795,519 373,448
a) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500
b) Governor's mandated State General Fund reductions in July & Sept 2010. Additional
c) Interest revenue projected to be Tess than budgeted
d) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will
e) Personnel costs will be Tess than budgeted due to open positions
429,265 429,265
grant received
$19,900 grant received
not be received
Year End
Budget
Projection
Variance
$ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578
Total Revenues 484,373
(56,613) 25% 0%
(15,938) 25% 0%
(23,750) 25% 0%
(64,496) 25% 0%
(3,625) 25% 0%
70,409 (6,822) 25% 23%
142,043 (9,038) 25% 24%
310 (1,690) 25% 4%
20,044 1,294 25% 27%
1,606 (3,394) 25% 8%
(1,250) 25% 0%
157 157 25% n/a
28,475 (36,164) 25% 11%
263,044 (221,329) 25% 14%
Trans from General Fund 71,082 71,082
Trans from GF -Other 6,250 6,250
- 25%
- 25%
Total Transfers In 77,332 77,332
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
- 25%
1,124,467
149,890
450,342
25
102,139
975,716 (148,751) 25%
123,470
56,727
26,420
393,615
25
102,139
25%
25%
25%
25%
25%
25%
25%
226,450
63,750
95,000
257,984
a) 14,500
b) 308,924
b) 604,323
8,000
75,000
c) 20,000
5,000
d) 258,554
$ 226,450
$ 63,750
$ 95,000
$ 257,984
$ 17,000 2,500
$ 263,596 (45,328)
$ 544,501 (59,822)
$ 8,000
$ 78,000 3,000
$ 8,000 (12,000)
$ 5,000
$ 157 157
$ 118,500 (140,054)
1,937,485 1,685,938 (251,547)
284,333 284,333
25,000 25,000
309,333 309,333
35% 2,809,580 2,630,611
Exp.
21% e)
3% b)
0%
n/a
599,559
1,801,367
100
408,554
543,424
1,657,922
(178,969)
56,135
143,445
100
408,554
TOTAL REQUIREMENTS 702,396 180,197 522,199 25% 6% 2,809,580 2,201,346 608,234
NET (Resources - Requirements) 422,071 795,519 373,448
a) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500
b) Governor's mandated State General Fund reductions in July & Sept 2010. Additional
c) Interest revenue projected to be Tess than budgeted
d) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will
e) Personnel costs will be Tess than budgeted due to open positions
429,265 429,265
grant received
$19,900 grant received
not be received
SOLID WASTE
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508)
Revenues
Miscellaneous 7,000 6,574 (426) 25% 23% 28,000 28,000
Franchise 3% Fees 50,000 8,406 (41,594) 25% 4% a) 200,000 200,000
Commercial Disp. Fees 210,000 237,116 27,116 25% 28% 840,000 840,000
Private Disposal Fees 328,500 407,149 78,649 25% 31% 1,314,000 1,314,000
Franchise Disposal Fees 914,750 1,083,069 168,319 25% 30% 3,659,000 3,659,000
Yard Debris 18,250 30,870 12,620 25% 42% b) 73,000 73,000
Special Waste 6,250 3,445 (2,805) 25% 14% 25,000 25,000
Interest 3,125 2,045 (1,080) 25% 16% 12,500 12,500
Sale of Carbon Credits 20,000 (20,000) 25% 0% c) 80,000 80,000
Recyclables 5,000 11,637 6,637 25% 58% d) 20,000 20,000
Total Revenues 1,562,875 1,790,311 227,436 25% 29% 6,251,500 6,251,500
TOTAL RESOURCES 1,955,384 2,108,312 152,928 25% 32% 6,644,009 6,569,501 (74,508)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out -Road
Contingency
Exp. %
400,030 404,384 (4,354) 25% 25% 1,600,118 1,600,118
716,457 446,071 270,386 25% 16% e) 2,865,829 2,865,829
242,517 242,517 25% 0% f) 970,066 970,066
29,500 29,500 25% 0% g) 118,000 118,000
72,935 72,935 - 25% 25% h) 291,740 291,740
199,564 199,564 25% n/a 798,256
798,256
TOTAL REQUIREMENTS 1,661,003 923,390 737,613 25% 14% 6,644,009 5,845,753 798,256
NET (Resources- Requirements) 294,381 1,184,922 890,541 723,748 723,748
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) No market at this time
d) Markets for recyclables varies throughout the year - usually declines in the winter
e) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
f) Expended in November ($367,098) and May ($602,968)
g) Will be expended by December 31, 2010
h) Transfers made quarterly
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508)
Revenues
Miscellaneous 7,000 6,574 (426) 25% 23% 28,000 28,000
Franchise 3% Fees 50,000 8,406 (41,594) 25% 4% a) 200,000 200,000
Commercial Disp. Fees 210,000 237,116 27,116 25% 28% 840,000 840,000
Private Disposal Fees 328,500 407,149 78,649 25% 31% 1,314,000 1,314,000
Franchise Disposal Fees 914,750 1,083,069 168,319 25% 30% 3,659,000 3,659,000
Yard Debris 18,250 30,870 12,620 25% 42% b) 73,000 73,000
Special Waste 6,250 3,445 (2,805) 25% 14% 25,000 25,000
Interest 3,125 2,045 (1,080) 25% 16% 12,500 12,500
Sale of Carbon Credits 20,000 (20,000) 25% 0% c) 80,000 80,000
Recyclables 5,000 11,637 6,637 25% 58% d) 20,000 20,000
Total Revenues 1,562,875 1,790,311 227,436 25% 29% 6,251,500 6,251,500
TOTAL RESOURCES 1,955,384 2,108,312 152,928 25% 32% 6,644,009 6,569,501 (74,508)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out -Road
Contingency
Exp. %
400,030 404,384 (4,354) 25% 25% 1,600,118 1,600,118
716,457 446,071 270,386 25% 16% e) 2,865,829 2,865,829
242,517 242,517 25% 0% f) 970,066 970,066
29,500 29,500 25% 0% g) 118,000 118,000
72,935 72,935 - 25% 25% h) 291,740 291,740
199,564 199,564 25% n/a 798,256
798,256
TOTAL REQUIREMENTS 1,661,003 923,390 737,613 25% 14% 6,644,009 5,845,753 798,256
NET (Resources- Requirements) 294,381 1,184,922 890,541 723,748 723,748
a) Franchise fees are received in April. Wilderness Garbage pays monthly
b) Seasonal material - revenue will decrease in winter
c) No market at this time
d) Markets for recyclables varies throughout the year - usually declines in the winter
e) Larger expenditures (i.e. grinding at $75,000) made intermittently during year
f) Expended in November ($367,098) and May ($602,968)
g) Will be expended by December 31, 2010
h) Transfers made quarterly
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
RISK MANAGEMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
% of FY _
% Coll.
$2,500,000 $2,374,541 ($125,460) 100%
95% $2,500,000 $2,374,541 ($125,460)
General Liability 83,958 83,958 (0) 25% 25% 335,833 335,833
Property Damage 73,505 73,505 0 25% 25% 294,019 294,019
Vehicle 45,678 45,678 - 25% 25% 182,710 182,710
Workers' Compensation 226,590 225,127 (1,463) 25% 25% 906,361 906,361
Unemployment 42,609 42,508 (101) 25% 25% 170,437 170,437
Claims Reimb-Workers' Compensation 7,500 (7,500) 25% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 5,000 10,110 5,110 25% 51% 20,000 20,000
Process Fee-Events/Parades 375 630 255 25% 42% 1,500 1,500
Miscellaneous 500 - (500) 25% 0% 2,000 2,000
Skid Car Training 5,500 1,120 (4,380) 25% 5% 22,000 22,000
Interest on Investments 7,500 5,291 (2,209) 25% 18% 30,000 30,000
TOTAL REVENUES 498,715 487,927 (10,789) 25% 24% 1,994,860 1,994,860
TOTAL RESOURCES 2,998,715 2,862,468 (136,248) 25% 64% 4,494,860 4,369,401 (125,460)
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Insurance 1,255
Repair / Replacement 5,194
Total Property Damage 75,000 6,449 68,551 25% 2% 300,000 280,000 20,000
VEHICLE
Professional Service 1,250
Insurance 390
Loss Prevention 529
Repair / Replacement 5,902
Total Vehicle 30,000 8,071 21,929 25% 7% 120,000 115,000 5,000
WORKERS' COMPENSATION
Settlement / Benefit 159,623
Insurance 46,424
Loss Prevention 7,814
Total Workers' Compensation 162,500 213,861 (51,361) 25% 33% 650,000 680,000 (30,000)
UNEMPLOYMENT - Settlement/Benefits 40,000 40,000 25% 0% 160,000 160,000
% Exp.
45,660
1,010
1,418
366
100
100,000 48,553 51,447 25% 12% 400,000 400,000
Total Direct Insurance Costs 407,500 276,934 130,566 25% 17% 1,630,000 1,635,000 (5,000)
Insurance Administration:
Personal Services 72,363 71,183 1,180 25% 25% 289,453 289,453
Materials & Service 57,209 41,810 15,399 25% 18% 228,834 228,834
Capital Outlay 25 - 25 25% 0% 100 - 100
Total Insurance Administration 129,597 112,993 16,604 25% 22% 518,387 518,287 100
Contingency 586,618 586,618 25% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 1,123,715 389,927 733,788 25% 9% 4,494,860 2,153,287 2,341,573
NET 1,875,000 2,472,541 597,540 - 2,216,114 2,216,114
Year End
Budget
Projection
Variance
95% $2,500,000 $2,374,541 ($125,460)
General Liability 83,958 83,958 (0) 25% 25% 335,833 335,833
Property Damage 73,505 73,505 0 25% 25% 294,019 294,019
Vehicle 45,678 45,678 - 25% 25% 182,710 182,710
Workers' Compensation 226,590 225,127 (1,463) 25% 25% 906,361 906,361
Unemployment 42,609 42,508 (101) 25% 25% 170,437 170,437
Claims Reimb-Workers' Compensation 7,500 (7,500) 25% 0% 30,000 30,000
Claims Reimb-Gen Liab/Property 5,000 10,110 5,110 25% 51% 20,000 20,000
Process Fee-Events/Parades 375 630 255 25% 42% 1,500 1,500
Miscellaneous 500 - (500) 25% 0% 2,000 2,000
Skid Car Training 5,500 1,120 (4,380) 25% 5% 22,000 22,000
Interest on Investments 7,500 5,291 (2,209) 25% 18% 30,000 30,000
TOTAL REVENUES 498,715 487,927 (10,789) 25% 24% 1,994,860 1,994,860
TOTAL RESOURCES 2,998,715 2,862,468 (136,248) 25% 64% 4,494,860 4,369,401 (125,460)
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Insurance 1,255
Repair / Replacement 5,194
Total Property Damage 75,000 6,449 68,551 25% 2% 300,000 280,000 20,000
VEHICLE
Professional Service 1,250
Insurance 390
Loss Prevention 529
Repair / Replacement 5,902
Total Vehicle 30,000 8,071 21,929 25% 7% 120,000 115,000 5,000
WORKERS' COMPENSATION
Settlement / Benefit 159,623
Insurance 46,424
Loss Prevention 7,814
Total Workers' Compensation 162,500 213,861 (51,361) 25% 33% 650,000 680,000 (30,000)
UNEMPLOYMENT - Settlement/Benefits 40,000 40,000 25% 0% 160,000 160,000
% Exp.
45,660
1,010
1,418
366
100
100,000 48,553 51,447 25% 12% 400,000 400,000
Total Direct Insurance Costs 407,500 276,934 130,566 25% 17% 1,630,000 1,635,000 (5,000)
Insurance Administration:
Personal Services 72,363 71,183 1,180 25% 25% 289,453 289,453
Materials & Service 57,209 41,810 15,399 25% 18% 228,834 228,834
Capital Outlay 25 - 25 25% 0% 100 - 100
Total Insurance Administration 129,597 112,993 16,604 25% 22% 518,387 518,287 100
Contingency 586,618 586,618 25% n/a 2,346,473 2,346,473
TOTAL REQUIREMENTS 1,123,715 389,927 733,788 25% 9% 4,494,860 2,153,287 2,341,573
NET 1,875,000 2,472,541 597,540 - 2,216,114 2,216,114
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes - Current
Property Taxes - Prior
Federal Grants
State Reimbursement
Telephone User Tax
Data Network Reimb.
Jefferson County
User Fee
COPS Reimbursements
Contract Payments
Miscellaneous
Interest
Interest on Unsegregated Tax
Total Revenues
TOTAL RESOURCES
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
$5,861,335 $
1,589,405
34,500
118,500
2,500
137,500
3,000
7,750
12,500
7,500
17,500
2,125
10,000
500
Budget
Year End
Projection
Variance
6,691,945 $ 830,610 100% 114% $5,861,335 $6,691,945 $ 830,610
(1,589,405) 25%
106,321 71,821 25%
(118,500) 25%
1,518 (982) 25%
(137,500) 25%
1,528 (1,472) 25%
490 (7,260) 25%
45,869 33,369 25%
(7,500) 25%
(17,500) 25%
2,150 25 25%
13,069 3,069 25%
41 (459) 25%
1,943,280
0% a) 6,357,621
77% 138,000
0% b) 474,000
15% 10,000
0% c) 550,000
13% d) 12,000
2% 31,000
92% e) 50,000
0% 30,000
0% d) 70,000
25% 8,500
33% 40,000
2% 2,000
6,357,621
138,000
474,000
10,000
550,000
12,000
31,000
50,000
30,000
70,000
8,500
40,000
2,000
170,986 (1,772,294) 25% 2% 7,773,121 7,773,121
7,804,615 6,862,931 (941,684) 25% 50% 13,634,456 14,465,066 830,610
REQUIREMENTS:
Expenditures
Personal Services 1,002,200
Materials and Services 381,036
Capital Outlay 140,750
Transfers Out 253,515
Contingency 1,631,113
% Exp.
895,044 107,156 25% 22% 4,008,798
329,500 51,536 25% 22% 1,524,144
140,750 25% 0% 563,000
754,061 (500,546) 25% 74% f) 1,014,061
1,631,113 25% n/a 6,524,453
TOTAL REQUIREMENTS 3,408,614
NET (Resources - Requirements)
4,008,798
1,524,144
563,000
1,014,061
- 6,524,453
1,978,605 1,430,009 25% 15% 13,634,456 7,110,003 6,524,453
4,396,001 4,884,326 488,325 - 7,355,063 7,355,063
a) Approximately 85% of the property taxes are collected in October and November
b) Grants - Billings will be sent to OEM (Oregon Emergency Mgmt) this month
c) Received quarterly
d) Yearly agency billings will be mailed out next month
e) Crooked River Ranch paid annual fee
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 3rd Qtr
Health Benefits Trust
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll.
Budget
Year End
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 2,811,500 2,851,412 39,912 25% 25% a) 11,246,000 11,403,534 157,534
P/T Emp - Add'I Prem 12,500 9,643 (2,857) 25% 19% 50,000 50,000
Employee Prem Contribution 125,000 120,645 (4,355) 25% 24% 500,000 500,000
COIC 243,750 343,962 100,212 25% 35% 975,000 975,000
Retiree / COBRA Co -Pay 112,500 176,538 64,038 25% 39% 450,000 450,000
Prescription Rebates 23,543 23,543 25% n/a 23,543 23,543
Interest 25,000 34,800 9,800 25% 35% 100,000 100,000 -
Total Revenues 3,330,250 3,560,542 230,292 25% 27% 13,321,000 13,502,077 181,077
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services 32,320 30,456 1,864 25% 24% 129,280 129,280
Materials & Services
Claims Paid-Medical/Rx 3,390,311 2,919,124 471,186 25% 22% b) 13,561,242 11,676,497 1,884,745
Claims Paid-DentalNision 509,595 405,804 103,790 25% 20% b) 2,038,378 1,623,217 415,161
Refunds (21,128) 21,128 25% n/a (21,128) 21,128
Insurance Expense 82,500 85,782 (3,282) 25% 26% 330,000 330,000
State Assessments 18,750 62,429 (43,679) 25% n/a 75,000 75,000
Administration Fee 75,000 73,942 1,058 25% 25% 300,000 300,000
PPO Fee 10,000 9,816 184 25% 25% 40,000 40,000
Health Impact 12,750 12,618 132 25% 25% 51,000 51,000
Workplace Clinic
Healthstat 31,490 (31,490) 25% n/a 31,490 (31,490)
Equipment - 25% n/a
Remodel 9,688 (9,688) 25% n/a 9,688 (9,688)
Miscellaneous 295 (295) 25% n/a 295 (295)
Other 37,785 9,716 28,070 25% 6% 151,141 151,141
Total Materials & Services 4,136,690 3,599,576 537,115 25% 22% 16,546,761 14,267,199 2,279,562
Capital Outlay 100.00 100 25% 0% 100 100
Contingency 3,261,215 3,261,215 25% 0% 13,044,859 13,044,859
19,730,250 20,548,682 818,432 92% 69% 29,721,000 30,490,217 769,217
Exp. %
TOTAL REQUIREMENTS 7,430,325 3,630,032 3,800,293 25% 12% 29,721,000 14,396,479 15,324,521
NET (Resources - Requirements)
12,299,925 16,918,650 4,618,725 - 16,093,737 16,093,737
a) Year End Projection is amount appropriated in operating departments' budgets.
b) Projection based on annualizing 13 weeks of claims paid. YTD actual is $254,139 per week.
Deschutes County - Fair and Expo Center
YTD -Budget Basis Commissioners
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 2,809 $ 6,590 $ 3,781 100% 235% $ 2,809 $ 6,590 $ 3,781
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
169,436 280,734 111,298 25% 41% a) 677,742 766,475 88,733
500 374 (126) 25% 19% 2,000 1,875 (125)
12,750 - (12,750) 25% 0% b) 51,000 51,000 -
2,250 440 (1,810) 25% 5% 9,000 9,440 440
10,500 255 (10,245) 25% 1% 42,000 42,255 255
52,750 72,930 20,180 25% 35% a) 211,000 206,930 (4,070)
23,250 14,000 (9,250) 25% 15% 93,000 94,000 1,000
11,250 (11,250) 25% 0% c) 45,000 45,000
1,104 9,363 8,260 25% n/a 4,414 14,040 9,626
283,789 378,096 94,307 25% 33% 1,135,156 1,231,015 95,859
49,480 49,480 - 25% 25% 197,919 197,919
6,218 6,218 25% 25% 24,873 24,873
20,000 20,000 25% 25% 80,000 80,000
57,808 (57,808) 25% 0% d) 231,232 175,000 (56,232)
25 (25) 25% 0% 100 100
133,531 75,698 (57,833) 534,124 477,892 (56,232)
420,129 460,384 40,255 25% 28% 1,672,089 1,715,497 43,408
Exp. %
232,973 229,210 3,763 25% 25% 931,893 928,130 3,763
119,171 155,385 (36,214) 25% 33% e) 476,685 526,899 (50,214)
28,891 - 28,891 25% 0% 115,563 115,563 -
25 25 25% 0% 100 - 100
381,060 384,595 (3,535) 1,524,241 1,570,592 (46,351)
Transfers Out - Reserve Fund 2,500 - 2,500 25% 0% 10,000 10,000
Contingency 34,462 34,462 25% n/a 137,848 137,848
TOTAL REQUIREMENTS 418,022 384,595 33,427 25% 23% 1,672,089 1,580,592 91,497
NET (Resources - Requirements) 2,107 75,788 73,682 134,905 134,905
a) Revenue unusually high in July and August due to BMW and FMCA events.
b) Most storage activity begins in October.
c) Interfund contract revenue is for park maintenance, from Fund 130
d) Cash flow from Fair 2010 is projected to be $57,000 Tess than budgeted
e) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs.
00
O�
• •
Secure Treatment Facility
•
Bethlehem Inn
•
O
yr
O
c
ci 0
� r
O
CD N
Z O C)
j d
O — a)
w'aE
a) co 0
t U 0
y U co
a) p t
0 a 0)
a) O
`) _c
c
O
O)
O
PROJECTION
c
0
CD 4a.
0
E
0 E
c0
W o
RESOURCES:
Total Resources
EXPENDITURES:
Materials & Services
O CO
CO") I. CO CO CO COO
1 C) ' CONGO ' OMrco
O CO O 0) CC) r- co-
-
ti co
C) CO C) O C) N co O r co O co
OCh0 yr coyr0CY)C)COyr
yr o co N c0 c0
COOCOOC)Or
co ) O
co r Cr
COOc0 CO
00 0
LO Yr ' O C) ' O C0 ' ' ' N
CO y O O O r r
co Cn r Cr) 0
a-�CCO0OMN0'1'
� O
1yr NMN COO r CO CO r CO
r Cr) co
1 1 I
1 1 1
NC)NOM —(0c))
r C) Lf) C) Yr O M 0) CO
C) N O r O M r CO.
rOCOcOCO- OC)r01sCC; N—
CO r Cr) O
(0
0)
a)
0
UZ
c0 U
0) 0) a) a
0 U 2) co o d
' c-
�ca`) 0 Ern
U O CTO U O .N
-coP ai
O) N I N O N> c
-. c O Its •— 0) 0 - .` --
QwI—n.. a <Q :
Minor Office Furniture
co
O
CO
N
cNO
CO
ti
(N
C)
co
O
(0
CO
C)
co
CO
N
N
CO
10)
O
N
N
CO
1cF)
co
0 00
O CO 0
O N
0 yr N
N
C)
(f)
O
O
O
CO CO
0
C)
C)
O
r
I
N
O
Yr
ti
CO
r
O
N
()
()
O
O
ti
Cn
co
co
O
O
Cn
yr -
CO CO
0
C)
C)
0
r
0
CO
CO
O
0)
O
0)
O
0)
O
0)
O
0)
O
N
M
N
o
O
0
0)
0)
0
C) - coco
co 0)(NT co -
0 yr co
Ch N
CC) r
rn
C CO
E 3
Q
8 To
� a Q
F E
a0i a)
aY 1
00
H
Total Expenditures
w
Z
N CDNNI-- CC) NN 0Cf) NOU)1-000d' d'N (0(0 CON d'O1`'-
a) d• N. c0-0 N-N0c0U)Ma)d-MtiMN fs CO—MCO—NC70N
0) CO I` O M a) f— a) LO d' a) LO O d' Ind' ,— d' CO CO CC) N- c0 d- 1� L0 O
‘- N N d' d' c, tri r- CO (1. O cci CO M N cO co' N M M c0 0 d 1. C10 1.
N CO N N Cr) CO v,— N N ,.— N. r
0
V:
O
co
vc Z
• W
v2
H O (n
ti
0 O c0
•5' 2N O
aO 0c") O
CD CLQD E130
•aZ 4- 0
(4 Q E r-, 0
U ( a) N 0 CJ)
a) 0
�U 0 csi OO(0oti
O Z u) O
(L q CO b9 2 Y
Q) LC y b9 O M c
CO CO Q O c y CD
o • (0O ,+>' O
CA• Z CD
7 U N
0 2 W ` () � 7
T. i'-' C
La a' -8y ,a,
U O 0 m y
a) — 0
Ta- 0
c m 2 Q Q
o (9 .- N M
O U *k *k
Engineered Structures Inc
#4 Acid neutralization tank -Labor - 1000/o
\'
co O a) O
O ti a)
Cr)4 to
Com') v7 d -
N = 0)
-cr4 4c•I a) ti 4
6/1)._ O O MT.) o N M
O r- CO o o� M F CV tC) 0
CO
O O O N > O Efi d'
CO O CO s 067,ot- 4- d. p
co N '
p Efi 0 - (0 O O 8.• 02 ~OaN -
ea
p
cis) O
a)O6OC
00 400
OUL C Ova)
co Co
aE E��OCOa: M�HOO�UaO O :E- :5, aO U• O>'p WCO E N a_
csi
N
• O
= N C p ccaN oCO 0(C) c� N > U • °- CT C U -8
U)
�OflO�`VoV��No O CO vt Q 7ca O9.3)_OYO �
_C c otS oC-0p O LC= t aU, VEOU Nc T O �5 OO c. ( -:(2m -0.0:.;::
U N O N
-CT
, c c OE 'YQ.)Op C0U p:_0 a)
L C_7 $ HN-Oco•N ONNnNN O O
wcoa)-DfnD25QO2l.-2 2zUW Ha
D2LLDO‘-NCe) d'CAtiOa) , CAtiOa),NMd'
CO N- NCNNNNMMCOM
M
N
CO
M
Total Change Orders
0 0
o o
a) a)
a) ai
o 0
CO
N
M CO
O d'
d' M
M a)
d- d'
co co
N Cr)
c0 M
In Cr)
•ct O
d' iti
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
PROJECTION
0)
0
U
(0
(0
N 0)
.O 0
CLm
to (n
O C
a)
(O E
E E
O
WU
orS
a)
C
a)
0.
w
RESOURCES:
O
0
O N 0 0
O CO 0 0
0 N 0 0
N M (()
M 0
N CO MI
M N
0
M O -
OCflOO
co- 00 M
l() M M 1-
v M
M
v�0'-
M 0 ..Zr
0 0 O O
ri
in co M 1-.
N
N
rn
0
U
a)
U
co
(0
N
0
0)
to w
a)
a) C
0) N �
O
O c0
c O 0)
m w
Transfer In -911 Fund 705 / 710
Total Resources
EXPENDITURES:
Materials & Services
coo co
co I- 0) O
N ' ' 'Cr CO CO '
0 4 N
r ..
co Tr
Tr co
(n
I
M
Tr -
0
00000ON(0 -0(f) -00C')
M 0) M 0 0 0) 0 0 CO 0 0 T-
N Tr. Tr 0 CO CO CO 0 Tt CO 0 0 N-
0. T N O N 0
00 (n N
O I- O
O 00 O O
O ' O O
N O O
N (0
O O O
' ' O O O
(O r O
0
0 0 CO 0 N 0 N- CO 0 C')
M 0) M 0 0) 0 CO CO 0 CO I.
N 0) CO 0 CO 0 •rl- CO CO M N.
(f)0 ON 1. r-
CO N 0) M 0
N (0
717
' M
C
0 (0 CO 0 N CO — CO 0 M N. CO
M 0) M r- 0 0) 0 CO CO rr 0 CO co
N 0) CO CO CO 0 CO CO M V'
(!) 0 O N h 0 0)
CO N M
N 0)
r
0
0
co
0
0
M
r
N
(1)
00
0
N
0)
O
0
0)
co
co
O
co
co -
Total Materials & Services
0) O O
0 0
CO I: CO-
O) 0 M
0)
CO 0 0 0 0 0
CO 0 0 0 0 0
0'1'000 0
O) O M M I- N
In N M U)
N
0 0 O
l() ' ' O O O
0) M M
M CO_
0 N 00
0 ' CO
00 C' 0)
M
N r
(0
I
l() N CO
rt CO
c6 oi
(C) M N
C r
N
0)
0
M
(0
(O
co
Tr -
co
0
co
M
N
0
C
0)
rn E co
0)) y W �.
0) CO 0) 0
O E j 0.O
N
o `- I >. 0.
0 in a) 0. 0) (o
c !'E E w w o U
0 O U a?�. C
U aPiceo
� L ..
00)) C 0 j 0) F-
c0Z000(LF-
U
O
Tr -
(O
(0
co
(NA
0
co
0
0)
N
(O
Total Expenditures
00
(0
N
V
CO
(O
N
0
3
O)
O
O
N
Z
PROJECTION
J
1-
a)
U
C
ca
ca
Encumbrances
& Commitments
Received and
0
a)
0
C
a)
O.
X
w
RESOURCES:
N
'c
CMO 0 M
CM � CD
N d0' CO
CM
O N 0
O CO O
O N ll)
I- CD
N CD
d
CO CCD
c6 ai
N
cri
M
CD
CD
CCOOCDDCI
co M co0
N
Total Resources
EXPENDITURES:
O 00 L() CD L!)) d' M
N ' dM ' d CD 00-0 ' dM' co I�
co d vN Nco
0 CO CO O N CD — O U) d CO O
M 0) M 0 CO 0) 0 0 00 'c v-
N d d' O CO CO CO O d 00 I� O
cris ‘-d NON ti r- d Cf)
N in N O) CD
O a) O co O O O
O d: ' O - ' 0 0 ' ' ' O
r- N O O r- x-
CDO N L)
N
OL)000NCO COLOd M r-
C') a)M‘-Coa)OCO00vcr co -
N -0)CDCDCOLt) "1' CO f- M
co 00 d N N 0))
N
I 1 1 1 1 1 1 '
co'
0 141 CO O N CD CO L vcrN N-
CI 0)Mx-000)OCDCO'c N -CO
N N- d 0) CO CO 00 L) m - co M M
O
ai N N d COGo
N
CD
CD
co_
U')
CO
CD
N
0)
CO
1.0N
CD
0)
M
Oo
0)
0 0 0
0) 0 M
0
0) N
CO 0
CO 0 0
0 'I' O
00
• N
N
2,553,452.63
0)
O
CM
CO
co
.41
CD
a)
N
CO
CD
O
00
0)
N
M
00
Cn
O)
Go
C0
Cn
O)
Co
cn
y d
a) V
U
U
v>, 2 a) 2)U) co
C Q U .D C +''
0)CO m Cn = O • a) 7
V a) a) O) °r3 -9 3 c` R • E O
i V N N a LL .� •i U j Y
O
Cn N O CD C) E o) U_ U co N in a) O- R
°� U a) ct) 0) "O 0 a) '_ 0 j C•V
O Co .0 c C 0-` O to O R 0 0 a") a) co
z L a) o c `� c ° a) C 3 a v) o
m C2C y m 4? N N _a> t H a) C F-
�Qw�a55iLQaD 2O UZDO
Total Expenditures
0)
c0
csi
u'
z
m
H
Z
W
-02o
c 2 N
0
Uro)
U ▪ O 4)
O < E
- W o_
4U a)
Z
U o
— Q
rn• 5
U
Z
W
Amount Paid
C
a)
E C
E O
E
O Q
U
C
0
0.
U
to
a)
0
O
O
O
Interior modular walls
Herman Miller
141 O h- CO O r- O I- CO Co O N O O 00 00 r- N O r- o r- r- 147 CO I's O
C') o C') C') 0) - O Co 0) I- ti N O 0) 00 N C') 0) rr rr O ti 147 N I -rt
0) CO_M rrCDOU')000r-000r- N41MOoorra0—tM5-O O
N CO 00 00 .1 O 4 O ti CO CO N to N- N 00 c6 I- co I-
I� C') 1- 1- .- d' 000 N LO
O
N
Co In rn
O.ct in r
co co
_�
Lo
O
in M _CieE3 O N N Ei3
CO O ONOCO vicf-)
p\O • O
Oc�c oQ
Lo-
69V tiCD 0� O • CO ,OC , c oOOOMca) C p O
ER
O)CN a)
rno _moo 4oM�v�v0)E *.=ve c'9'.:1 -a � .0 o
Ea iz.'.
E0
>, 0 C C o vi N O y .,- ` 7 =0 cCn1 O vsU 7 O Cc
U
• 'Cp'o y U O t7 pOOyL N �Y
co �Vaa)o�'rcoCDt>oEcot>o,�ai2o`�nc�ca)�CD Uc4) o
O � O(c O CU pO e a) toO
C 05 LvO` 7 UNNca7 (0 OU7�m?c7) U OwoCa �E U EUU c E , )yU >
O` ' E �'
U O Ucn >, UO— toUa 0E 20i p E U yU .Qc �aO
j0_ OcnO<C) <1-00145 2dH W LI — a)
C c• a) iQ DLLO DO, Nc,„0000O,NMd'CncoI,No) c�chCCj
O)to '-NCnI- 00 Ca NNNNNNN(\J
'C L 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t 4t
O 0
Engineered Structures Inc
Total Change Orders
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
CO
O
~ O
C 0
7 N
>' O
C w M
O a..a
O
a) d a)
7
.0 O
C) = Cn
N
CU N L
Q LL
O
a) �
Z
H
1
Q)
PROJECTION
-J
1-
0
a)
0
O
H
O
(1)
O (4
O Q
0
Encumbrances
& Commitments
RESOURCES:
0 0
Cr) M
'
Is.
.47
0 0 0 0
O O M M
001,- ti
C7 O ti
CO N (M0
N N
0 0 0
O O ' O
CO M O M
N CMO
N N
0 0 0
O ' (-0 ti
M
et
N N
O CO M
O '
Transfer In -911 Fund 705
Federal Grants
c
Total Resources
CO LOCo0
M O
LO
0 CO
CO 0
� M
CO O
Q)
(0
O
N.
co
trs
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 0 0 0 0 0 L() L() 0 0
OC() tri N- Occ; OOco. 00r) M
co co .— ti co .— .—C) M
c7 N N— 0 CO
N
0 0 0 0 0 0 0 0 0 0
0 O co O 0 co co 0 0 0
tri tri coN A- 0000000
coc
N. CO N-
CO N
A-
cis
a)
7 CA
X 0
v
23 LL
E 2 rn
0) c N 3
W U 'C
Ili ca
H °!S ca 2 j a)
o, a)� �v o n
c• O E
0 G) a c H 0
XM22 0
Furniture & Fixtures
1 ---to
co
i s i i i i i
cto
cc)
N
1
O
O
O
c�)
co
Q)
1
H
Total Expenditures
N
c0 Z
ow
li
0 M
Q0
a. < E
>-.N
-wfl
0 CD
(� Z
LL
q O
Z m Q
1c7)U
Z
W
a)
U
c a)
(6
(6 0
m
Amount Paid
a)
E
O
E
O Q
0
' CO '
V
O
' M
co
co
CD
Q)
O)
Radio Dispatch System
U
O
1
N
co
Q
a)
C
a)
U
a)
O
U
• O
O
N N
> (1) O
C7 M
07 O
U Cn a
N°'E
a) -
7
• a)
(I)
a) mL
O LL
C O`
a)
E H
1
U
a)
4-
PROJECTION
1-
U
y
O
O -
d
m
Encumbrances
& Commitments
Received and
RESOURCES:
O M O L()
co M O O
O ' •- O U)
I� O N -
O3 O
• O M 0 L()
M 0 M 0 0
001-00
CC) ONNO
CO (n N
N I�
• 0 M 0 U)
M 0 M 0 0
O O 1- O to
to O N N O
co it) N
N
O
O
O
N
M
N
co
Of
Tr
O
N
CO 0 O)
C) COO.
U) O r-
O O) v W
CO 0 0) M N 1- 0) 0 '4)
C) CO 0 .-- CO O) CO - O r- r O
Cn O I- M O- 0 0 c)) CO. N
t: CO CO O U) r) to M N U)
N N N
r r
000 CO O)0 0
000 ' M N O' O'
I- ) 0,1 L0 (O N
I. r
co
0 0 0) N '4) O) N (1) •C
CO CO 0 r (O O) CO 1- O
(l') O I. M O CO O 1- M CO. N
c (O 00 (l) O N c r lA .-
O N 1- O
01 In
CO N
(l) N
U) 0) N U) O) N
O r co O co- M r .- O
N r- M O) O c.) co.. N
co- a0 c'7 W (f) O N M— LA r
t` N O
N
CO
0
(Li
N
co
0
(()
to
00
N
O
O
N
00
y
u)
U
N
C c C .c15V
N _ U a) ce Z
N y C.) Z O. 0) EOpp (/) (C
"O ` C 0 U j (0 0 ar
FP
C 4,7m WZ0 m as d R. •` •1
tea) W a) = 7-,- c a) U L_ rn ° a m° (a
• c c y y I- °a -Rd *c E rn�a y 0f -.5 jt)
O @ •: CCC I O 0 a, a) c c c CA u) U R 0; is
c a) • u) m ) re W .� U •rn •> ° t -.'7"1)--'''°>0 .E.D. ° c O
C C r 4. 0 C C a) _ a) C EH O H
pyo m OY p X co W_Id u_ CL — co
_1(nH0 SH W Z U
0
147
O
O
O
O
0
(l)
O
00
O
N-
a)
(l)
O
(O
M
c'7
O
O
O
O
0
141N
O
co
O
N
0
O
(1)
(l)
r-
r-
M
N N
r r
Transfer Out
O
0
0
c'7
0
0
0
O
M
0
Debt Service Fund
O
O
to
N
M
N
C)1, N
v
Tr
N
coT
Total Expenditures
N
O)
N
O
0)
N
O
O)
N
O
Tr
Lc)
O
W
tll
C
H
U w
20
O 2 N
rx0cc
U
a)p�
7Z E
U Q w
0
W
� U
Z L
y C)
a O
CCI
� 2
c 0
a)Z
EW
co
1-
7
U
a)
Cr)
Amount Paid
O
a)
LOLO LO
CO O)
O) .47
CO
0 0
0 0
I-
N-
O
O
O
' O) NsCO 0
CCO
N N Cn
M
M M
LOCO N- COC'cr
M N CO CO
N N M U7 (.6
0000 0 00 O CO O o0 C) N-
I CO 0 0 0 N- Q) c) CO 0 (0 I
M W) 0 0 in 0) O CO O CO CO LO
M L CO C7 N- N et O C)
N N 0) — N x— N N N
vi
a
co3
a)
a) Toc
o)
aa)i a) 3 m c
O oc c0 U Y w +;' C
C
v `a
7 �.. N L
0 i a)-0oTo
cn u)i ca 3 co •c)
N j V) O •`—
a) C a) c� O O_ C 7 C
a) C) L a) O Q
X > O 0 O C+0
in a) a`) E Uoccvc��
a) cr) m m o m
�� v)�o n o !llE w
w L C u) —7, O co C , 74"
V
LE ��a) C���y�Q
QR' W JU)< 0U -D °��2
Pinnacle Architecture
Pinnacle Architecture
Thermal barrier
0-
0
CD
N CPo
c0 >
vi =
cc O
z
c2 "0
c ca
L
E c0
7
Q. CI
0-
7
(2.
:C o ` IP "2 P P
m a) -00 000000
C CO m C) C) C) C) C) C) C) C)
C �j L L L L L CO CO CO
co 2 ci 00 000000
0< 2
Total HSW Builders
Deschutes County
Bethlehem Inn (Fund 128)
Threee Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
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
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Interest Payment
2,861,000
2,861,000
- (2,861,000) 8%
- (2,861,000) 8%
0%
0%
2,861,000
2,861,000
- (2,861,000)
- (2,861,000)
136,000 (2,722,510) (2,858,510) 8% -2002% 136,000 (2,722,510) (2,858,510)
Exp. %
36,000 5,843 30,157 8% 16% 36,000 36,000
100,000 100,000 8% 0% a) 100,000 100,000
TOTAL REQUIREMENTS 136,000 5,843 130,157 8% 4% 136,000 100,000
NET (Resources - Requirements) - (2,728,353) (2,728,353) b) - (2,722,510) (2,758,510)
a) September 2010 interest expense - $1,805.31
b) Recap of expenditures - inception through September, 2010
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 210,440
Total expended $ 2,728,353
Year End
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
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Interest Payment
2,861,000
2,861,000
- (2,861,000) 8%
- (2,861,000) 8%
0%
0%
2,861,000
2,861,000
- (2,861,000)
- (2,861,000)
136,000 (2,722,510) (2,858,510) 8% -2002% 136,000 (2,722,510) (2,858,510)
Exp. %
36,000 5,843 30,157 8% 16% 36,000 36,000
100,000 100,000 8% 0% a) 100,000 100,000
TOTAL REQUIREMENTS 136,000 5,843 130,157 8% 4% 136,000 100,000
NET (Resources - Requirements) - (2,728,353) (2,728,353) b) - (2,722,510) (2,758,510)
a) September 2010 interest expense - $1,805.31
b) Recap of expenditures - inception through September, 2010
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 210,440
Total expended $ 2,728,353
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of September 30, 2010
"Area A"
"Cell 5"
Landfill
Closure Fund
611
SW Capital
Projects Fund
613
Total
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a)
Total
Paid through September 30, 2010
Balance
Construction Contract
M A DeAtley Construction Inc
Original Contract
Change Orders:
Change Order #1
Change Order #2
Change Order #3
Change Order #4
Change Order #5
Change Order #6
Change Order #7 (not likely to occur)
Change Order #8
Change Order #9
Change Order #10
Change Order #11
Change Order #12
Change Order #13
Total
Paid through September 30, 2010
Balance
241,869.00
19,656.00
261,525.00
255,317.56
6,207.44
2,097,140.50
14,302.54
24,885.69
152,500.00
1,332.00
2,486.98
26,000.00
2,318,647.71
1,983,230.82
335,416.89
Total of Engineering & Construction Contracts
Original Contracts
Change Orders
Total
Paid through September 30, 2010
Balance
2,339,009.50
215,163.21
2,554,172.71
2,238,548.38
315,624.33
182,516.00
182, 516.00
176,308.57
6,207.43
424,385.00
19,656.00
444,041.00
431,626.13
12,414.87
3,290,779.98 5,387,920.48
45,095.00 45,095.00
14,302.54
24,885.69
305,000.00
148,958.89
1,332.00
152,500.00
148,958.89
225,000.00
5,167.76
3,200.00
6,354.75
3,877,056.38
3,202,139.17
674,917.21
3,473,295.98
579,921.65
4,053,217.63
3,378,447.74
674,769.89
225,000.00
2,486.98
5,167.76
3,200.00
6,354.75
26,000.00
6,195,704.09
5,185,369.99
1,010,334.10
5,812,305.48
795,084.86
6,607,390.34
5,616,996.12
990,394.22
Notes:
a) Additional landfill gas investigation per DEQ as part of a requirement
to address offsite landfill gas migration.
b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678
has been expended and reported as "Construction in Progress" on the County's
CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction,
Taylor NW, KN EX Co, Jack Robinson & Sons.
c) To date in FY 2010, payment has been made to Central Electric Co-op:
$13,311 for the Closure of Area A and $20,822 for Cell 5.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Travel Expenditures
and
BOCC - County College Expenditures
FY 2011
9/24/2010
BOCC Conference & Travel
Jul
Aug
Sep
YTD Total
Tammy Baney
Travel Meals
-
20
-
20
Accommodations
-
77
-
77
Mileage reimbursement
-
240
-
240
Ground Transport/Parking
-
-
-
-
Total Baney
-
337 ;
-
337
Dennis Luke
Travel Meals
-
56
37
93
Accommodations
-
77
76
153
Mileage reimbursement
-
282
178
460
Ground Transport/Parking
-
17
-
17
Total Luke
-
432 j
292
723
Alan Unger
Airfare
1,133
-
-
1,133
Ground Transport/Parking
-
-
-
-
Total Unger
1,133
-
-
1,133
Total - BOCC Department
Travel Meals
-
76
37
113
Accommodations-
154
76
230
Airfare
-
-
-
1,133
Mileage Reimbursement
522
178
700
Ground Transport
-
17
-
17
Total - BOCC Department
-
769
292
2,193
FY 2011 Budget
19,600
Percent of FY 2011 Budget Expended
11.2%
BOCC County College
Public Information-
-
1,874
1,874
Office/Copier Supplies
-
- j
33
33
Meeting Supplies
-
-
295
295
-
-
2,202
2,202
9/24/2010
Building Services - 620
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 310,000 $ 371,047 $ 61,047 100% nia
Revenues
Cleaning/Maintenance 22,503 15,325 (7,178) 25% 17%
Utility Reimbursement 2,075 5,913 3,838 25% 71%
Facilities Charge to State 44,499 29,170 (15,329) 25% 16%
Miscellaneous 677 677 25% n/a
Interest on Investments 1,750 955 (795) 25% 14%
Building Svcs Indirect Chgs 497,810 497,807 - 25% 25%
Total Revenues 568,637 549,847 (18,787) 25% 24%
Transfers In 19,481 19,481 0 25% 25%
TOTAL RESOURCES 898,118 940,375 42,260 25% 35%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
Budget
Year End
Projection
Variance
$ 310,000 $ 371,047 $ 61,047
90,012
8,300
177,996
7,000
1,991,229
90,012
8,300
177,996
7,000
1,991,229
2,274,537 2,274,537
77,925 77,925
2,662,462 2,723,509
415,051 407,554 7,497 25% 25% 1,660,202 1,660,202
196,644 173,370 23,275 25% 22% 786,577 786,577
1,500 1,500 25% 0% 6,000 6,000
52,421 52,421 25% 0% 209,683
61,047
209,683
665,616 580,924 84,692 25% 22% 2,662,462 2,452,779
232,503
359,452
126,952
209,683
270,730
270,730
Admin Services - 625
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual _
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 120,000 $ 70,480 $ (49,520) 100% n/a $ 120,000 $ 70,480 $ (49,520)
Revenues
Miscellaneous 10 10 25% n/a 10 10
Interest on Investments 193 230 37 25% 30% 770 770
Admin Dept Indirect Chgs 220,435 220,706 271 25% 25% 881,738 881,738
Total Revenues 220,627 220,946 319 25% 25% 882,508 882,518 10
Transfers In -General Fund 10,000 10,000 - 25% 25% 40,000 40,000
TOTAL RESOURCES 350,627 301,425 (49,202) 25% 29% 1,042,508 992,998 (49,510)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
211,447 205,193 6,254 25% 24% 845,787 845,787
28,998 12,542 16,456 25% 11% 115,993 115,993
25 25 25% 0% 100
20,157 20,157 25% 0% 80,628
100
80,628
TOTAL REQUIREMENTS 260,627 217,735 42,892 25% 21% 1,042,508 961,780 80,728
NET (Resources - Requirements) 90,000 83,690 (6,310) - 31,218 31,218
BOCC - 628
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 100,000 $ 95,210 $ (4,790) 100% n/a $ 100,000 $ 95,210 $ (4,790)
Revenues
Sale Map Photo or Copies 38 25 (13) 25% n/a 150 150
Interest on Investments 175 223 48 25% n/a 700 700
Admin Dept Indirect Chgs 90,205 90,316 111 25% 25% 360,820 360,820
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
190,418 185,774 (4,643) 25% 40% 461,670 456,880 (4,790)
Exp. %
84,386 83,513 873 25% 25% 337,544 337,544
24,224 29,268 (5,044) 25% 30% 96,897 96,897
25 25 25% 0% 100 100
6,782 6,782 25% 0% 27,129 27,129
TOTAL REQUIREMENTS 115,417 112,781 2,636 25% 24% 461,670 434,441 27,229
NET (Resources - Requirements) 75,001 72,993 (2,007) 22,439 22,439
Finance - 630
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 500,000 $ 573,333 $ 73,333 100% nla $ 500,000 $ 573,333 $ 73,333
Revenues
Investment Fee 20,000 12,484 (7,516) 25% 16% 80,000 80,000
COLES/CODE Contract 1,362 (1,362) 25% n/a 5,446 5,446
Interestonlnvestments 3,000 1,184 (1,816) 25% 10% 12,000 12,000
Interfund Contracts 5,000 5,000 - 25% 25% 20,000 20,000
Administrative Fee 3,000 3,000 - 25% 25% 12,000 12,000
Finance Dept Indirect Chgs 206,969 207,223 255 25% 25% 827,874 827,874
Total Revenues 239,330 228,892 (10,438) 25% 24% 957,320 957,320
TOTAL RESOURCES 739,330 802,224 62,894 25% 55% 1,457,320 1,530,653 73,333
REQUIREMENTS:
Expenditures
Personal Services 216,698 206,288 10,409 25% 24% 866,790 866,790
Materials and Services 68,011 90,868 (22,857) 25% 33% 272,044 272,044
Capital Outlay 2,500 2,500 25% 0% 10,000 10,000
Contingency 77,122 77,122 25% 0% 308,486 308,486
Exp. %
TOTAL REQUIREMENTS 364,330 297,156 67,174 25% 20% 1,457,320 1,138,834 318,486
NET (Resources - Requirements) 375,000 505,068 130,068 - 391,819 391,819
a) Will be paid in June 2011.
Legal - 640
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 90,000 $ 128,128 $ 38,128 100% nia $ 90,000 $ 128,128 $ 38,128
Revenues
Sale Map Photo or Copies 75 140 65 25% 47% 300 300
Miscellaneous 750 (750) 25% 0% 3,000 3,000
Interest on Investments 375 344 (31) 25% 23% 1,500 1,500
Interfund Contract 3,750 (3,750) 25% 0% 15,000 15,000
Legal Counsel Indirect Chgs 188,658 188,658 0 25% 25% 754,632 754,632
Total Revenues 193,608 189,142 (4,466) 774,432 774,432
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services 187,089 176,420 10,670 25% 24% 748,357 748,357
Materials and Services 12,119 6,916 5,203 25% 14% 48,475 48,475
Capital Outlay 25 25 25% 0% 100 100
Contingency 16,875 16,875 25% 0% 67,500 67,500
283,608 317,270 33,662 25% 37% 864,432 902,560 38,128
Exp. %
TOTAL REQUIREMENTS 216,108 183,335 32,773 25% 21% 864,432 796,832 67,600
NET (Resources - Requirements) 67,500 133,935 66,435 - 105,728 105,728
Personnel - 650
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 290,000 $ 351,450 $ 61,450 100% nla $ 290,000 $ 351,450 $ 61,450
Revenues
Miscellaneous 250 13,722 13,472 25% 1372% a) 1,000 13,722 12,722
Interest on Investments 1,500 831 (669) 25% 14% 6,000 6,000
Personnel Indirect Chgs 181,333 181,333 0 25% 25% 725,330 725,330
Total Revenues 183,083 195,886 12,803 25% 27% 732,330 745,052 12,722
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
473,083 547,336 74,254 1,022,330 1,096,502 74,172
Exp. %
150,269 144,919 5,349 25% 24% 601,074 601,074
85,039 28,025 57,014 25% 8% 340,156 340,156
25 25 25% 0% 100 100
20,250 20,250 25% 0% 81,000 81,000
TOTAL REQUIREMENTS 255,583 172,945 82,638 25% 17% 1,022,330 941,230 81,100
NET (Resources - Requirements)
a) Manley Services Payment
217,500 374,391 156,891 155,272 155,272
Information Tech - 660
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 435,000 $ 480,723 $ 45,723 100% n/a $ 435,000 $ 480,723 $ 45,723
Revenues
City of Redmond - 25% n/a
Miscellaneous 250 (250) 25% 0% 1,000 1,000
Interest on Investments 1,500 1,119 (381) 25% 19% 6,000 6,000
Leases 5,250 7,048 1,798 25% n/a 21,000 21,000
I T Indirect Chgs 505,811 505,811 - 25% 25% 2,023,245 2,023,245
Total Revenue 512,811 513,978 1,167 25% 25% 2,051,245 2,051,245
Transfers In -General Fund 16,500 16,500 - 25% 25% 66,000 66,000
TOTAL RESOURCES 964,311 1,011,202 46,891 25% 40% 2,552,245 2,597,968 45,723
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
456,439 452,592 3,847 25% 25% 1,825,757 1,825,757
130,719 120,072 10,647 25% 23% 522,877 522,877
25 25 25% 0% 100 100
50,878 50,878 25% 0% 203,511 203,511
TOTAL REQUIREMENTS 638,061 572,665 65,397 25% 22% 2,552,245 2,348,634 203,611
NET (Resources - Requirements)
326,250 438,537 112,287
249,334 249,334
IT Reserve - 661
Statement of Financial Operating Data
Three Months Ended September 30, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 161,896 $ 212,360 $ 50,464 100% n/a $ 161,896 $ 212,360 $ 50,464
Revenues
Interest 500 464 (36) 25% 23% 2,000 2,000
Interfund Contract 3,400 3,400 25% n/a a) 3,400 3,400
IT Reserve Charges 58,500 58,500 - 25% 25% 234,000 234,000
Total Revenue
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Materials and Services
Capital Outlay
Res for Future Expenditure
59,000 62,364 3,364 25% 26% 236,000 239,400 3,400
220,896 274,724 53,828 25% 69% 397,896 451,760 53,864
Exp. %
18,500 - 18,500 25% 0% b) 74,000 74,000
31,000 39,771 (8,771) 25% 32% b) 124,000 124,000
49,974 49,974 25% 0% 199,896 199,896
TOTAL REQUIREMENTS 99,474 39,771 59,703 25% 10% 397,896 198,000 199,896
NET (Resources - Requirements)
a) From Solid Waste
121,422 234,953 113,531 253,760 253,760