HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
March 29, 2010
(1) Monthly Investment Report
(2) February 2010 Financials
eschutes ount A
otal Invest -nt Port olio +l
Investment Income
Fiscal Year 2009-10 I
Q)
c,-)
122,395 1,181,319
(6,120) (59,066)
M
N
❑
co
N
Ffi
bi
1
C .
N.
N
O
(N
(.
1
N
1-
I
1-
N.
-13d
LL
c�
Total Investment Income
Less Fee: 5% of Invest. Income
Investment Income - Net
Investments By County Function
General $ 148,498,145
Total Investments $ 148,498,145
O 0 G o o 0
o cc o 0
• 00 T O N G
co co
co
N
,r CO co
co
U N
CO 4) N 4)
0_ 0 O 'C 4)
` 4) t Q
E 0 °
E o_mc (1)
o o . 0
U Uf—DLL
LGIP
I1
d
O
0)
cO
d'
Total
o a
•• Tr +t -
O Y
N
L
0
co
Q
E
0
U
r M N
O O O
Average Maturity in Days
S.
0 0 0 0 0 0
O O In K) In 0 0
0 0 f- N N N
Total Portfolio: By Investment Types
0
N
z°
U
U.
Z
F
Market Value
0
0
0
0
0
'0 41
0) tp
G 7,5
O �
U
J G)
0
y
O
0 0 0 To
0 0 0>
U U U' U U U U U. U' U U' c.x U U U U•U U N NIU U U U 10) U U U&'U c f0 U' cp U 4j 0',
Z Z Z Z Z Z Z Z Z Z Z Z Z,Z Z Z'Z Z o o Z Z Z ZIo ZiZ' c c z,.E o Z Z '�
0 0
•
N 4) (O r • V NI 0'0 0 CO 0 O 4).r 0''V:0',0 cp r N.O.0 V N 0 0''0'(O r 'r .O O • ▪ 00 4)
4) O (O • 01, (O N' O' 4) O ,- 4)I OI r 0 OI O 0' O • r' 0 0, N 4), 0: V NI O O O' (O CO ,-' 0I Nc0! N • O O. 4) 0 (O
• CC). 0 N' Cr) CO 01 01 O. 0 r. 0 N r 0'1 0 4) • 0: 4)' 0 r 0' 0' 0' N r 1 0 V', r 0 0 0 N) 0 ,- 0 ' N '' O O ' 0 066
0, N 0:1•-• r CO 4) ,1•0 CO' 0 CO c0 4) CO, c0 4)' r', 0 0 r c0•0•0 V 0 V' V 0.0•0•0.(0,,-,0 0) 0 0 0 N 0 0
N.. N, (O c?' .- (JD r NICO• ,-! V_ 0'. O, r O. ,- N c01, VO r, .- G0 O O' 4)' 0.. O'. N', 0 C.1 c0'. LC)!LC)!CO. O r CO O r'.0 0_
O' 4)' (O O O 0:, N W 0, M. r' (O CO_ O
' ! 0 1 (O• a) V'. V
NI W, N NI O' 00' 0 c0'. co ,, CO: t0 0 • 6,43
CO' 0 0 c+) 0 CO.N. O. 0 V 0 C') 0', COI CO 0, Q! L 0.. COr1 O N OI co;CO'i 0 0 CO! O)'� V N' CO'CO• V. 4) 0 a0
,_-0 ,- 0:,-0.0,-00,-,-,-60,-00:,--,-•0.,-,000:000,-,0:00!60:0: 0.`-0
N
•,__!,_,_.0.,-0,
', V N V N:, ,-. 0 0 0 ,-• ' 0 N N N 0'. 0, 0 N N1 O N N, N N 0I N. N N. N N, N ‘-v:A-.5
r v 0
•
' 0 0 V' m' f•)' f•)' V, O O 0'1. O O O O 0 (') N', 0, 0 0, CO O 4) 0.- N 0,Q:0060100000. 4)
V N
•0 01 c')' 1'.- c') c')•, 7'. 0. 0', 0 0, 0 O'' 0 4)" 9) 0. N', 0.. O, 0 0'- N 0 r O' .- N 1 01 ' 0 0 01 01, 0 0 0 0 0' I ,-0,0
O co V N CO MV 4):1 O'1 0 v: 0'' co, 01 4) a0' O r LO 0'' 0 0 0 CO'. 0 041 co' p 0', O O 01 c[)1 01 O co. 0 N 0 •0
0 N y pp 0. N, GO- c0 0 (0 c0' 4)' r O' N : N O', O N I O'. r'' 0 O' N N O O' 0': N N r 1 O'' N N, 0' W•06
• 0 D7 '1 0o'. N•C'). 0, c0' r" 4) (0 N r 0' 4) N' CO 931 c') O O N1: r1 N c') N 0I CO (0'1 4) N Ni, 0 (') N N (') ,-'' N ' 4)'N ',N
N V 1 cD- a0 cD O1 0' V c0 O'. ,- a0' V- cD' O a0 N C O O' r cD O a0 COI V O! N V O 0! 7 0. N c0 cD
0 O N r- V' N 0 (0 0' ' M r' 0 N p 0 0 r N 0 0; 01 0 0 0', 0 0. V' 0.01 0•0, 0 0 0 NOM
OD
0 ,- 0 01: 01.06,-0600,-.60,-i0,0,:060,70,0600.0,,-00,-1060).0: (O O C')
,N V, N V! N, •V,- 0.10N,- ,NN NN C. N' N N N N'1 N N N N N N N' N! N N' ' 0> V (')
•
' 1 1 1
'
O O c') 0O' 0 0•0'', 0' 0 0 0 00 0o 0' 0 0o 0 0' 0. 0 0 01x0' 0 0 0. 0: 0 01 0. 0 0' 0. 0 c') 0 00' 0: ('40 4)
0 0 x0 p00 0 0 1 0 1 0 0 0: p 0•X 0 0 0. 0 0 0: 0 0 00 0 0-4,0!-I',0,0!0.010'4'0,0
' 0 0 0 0 0: 0 0, 0 0 0 0', pp 0' 94 0 0 0 0• c0 0 ,1 ')
1 0
G•',1,0,,,N•
0 0 (VD' 0, •0000.0.0)0:c0,0•00
0, 01 0' 0 0 0 V CO') 0' (0 O x•N:660'0,1 0' 0 (O V 4) 0' 0 01 O 0 (0 0, C'')) N cD x00,' 0, N:i 01 0: E:15 � N
0 O._ O: O p O V 0 0' 0 (') r 0 m 01 0 0 0 0 (') 0 0 0 0!, O 0: r O cp O r.-:; O' V O O' O (D
' V 0 9, 0 0 0 0,, 0. O N 0 . (0 ,7 (, 0 0 0 0 0 0 O' ,7 0) 0 0 01 0 01 01 0 4)1 01 0 � 0' 0 0, 0 NOM
'0,-0.000, ' 0) ,- d)
N' ,,N:94,1:9,1! V 99:94•,0 ,- NN 194:94,04 N ,- •N'IN N'N',-'N,N N N',N'1 N., N.N cV 0 m,9)
'•� 0 0 0.0 60:0,0 <0 o 0 0.0',0.0.0'01 o 0 0''0 CO CO 0'0 0:0:.0 o(„) 0'0 °V in 0'0 010',0 '0 O''O 4)'
0 CO 0I 0 CO 0 O, co N. V 0 0 LO LO ' c0 0 0 0' V' ,n 0 01. (0 0 ' 0 N V CO, 0 4) r a 0, 0 (0 O N N
(31,0:0•V..40 (0', 9. 0 O 4), 00 0 0'' '• 01 0,- 0. ,- N N: 0 0 0 ,-, CO CO CO N. --:V.•,- G0'1 c01 0 0' 94 o•o, 0 co O' V V 4) m. O. ' 4'
*- 0.0 N N C') (O (O r N N N O r• O O ,-!,I, „ p p r O O.- . 0,
i9
0
ul
csi
V
o O (n')n o • ...:0000. 0'o"0'.4) o'o'N,o 0 0 0 '.�
N. O r r O 0 00'00006 O 4) 0'. r 4) O' N', 0. 0!
0 O, y, •
CO N (O CD' (D O' O' (1 4) M C') N 1 0 r O' c0 N (O `- 0., O V'. y C
(') .- (') V V N N 4) 4)' O O O O 4) O .•c
'l
'0.
E' •
a.
;a$5 •,,
c'E a 0 :° o
o m
O > rOV,r.N1(O(0O,a0O-,000,0,9.0r O',(D,0!rrlr:0,(Dlr ICO(0.4)000O0>2
O• G (v') ^ ° 9')) 4� L. ,n ^•
4 v CI 9 v'0,ro 0o0 0n'� 41 r v 400',,9 �)'''(L LO (Vn 40 • 0 • '40) (0 CO 0 • 01 CO• N N ii' E'c >
0:0 01 _O 0 0 0: 0 0 0! 0 0 0 _0 0 0 (V 01 > •O 0
in r' N 4 0- �' V r. (D. O'. 0) 0 0 01I 4) (0 N (O(")' ,l) N'.
m c0
F`-2.-'7 N 001000'0'-NM N'NM{
,
-)Vary O0O'-0-0CcG4) ic0O'O.>
OoO.O.0 0•0!000 0 0 000 00000.000100 0 QO00
. F -m
` r
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0! 0 0 0 0- 0 0 0 0' 0 0 0•
O'
O 0' 0 0 0 0 0 0 0 0 0. 0 0 0 0. 0, 0 0:00 ' o 01 01 O O o 0 0 0 �: 0 o O
'an N.03r-.-'4)0. -'��inc,!o'-0,00 0!000010,0 ..-10, c,c in. N'..
1 O ` 0 4 0 0 `- 9 94 N: O O M O (! (0 N N COI ` ` O �) N` r
V 0 0, ,0100'0 0 (D 0- N 0 r 1� c0.c)!.- 0 �'o (� N N' - N
O O O' �', O O•O'.. O' O O O O' O' O � � O' 0 0' O' O' - 01 --' O �''. O' O � O O I
2-
g 7 Q
2
4)
G)
L mal
1-2 cm
7
Q
¢ V CO u. CO m -, CO Z >IF -,Q. u. Q'. Q'ZQ CI
CO CO V 1C J Q CC N,N'',7 9 V U LL F- F-
ad.(1 Uf o. 11 0 1- 1- - -' - 1¢L. 1-, u u- o LLIi 1- U- 1' 1. u- l¢'L UU U- 1U- (9--! 1 ILII I¢L' l¢- 0 U. l¢L, U LL 1¢L LL. (¢.•
'.I a.o m m m m'm m cc i 3 o)� ct m cc'm i aloi �IuZi of >!cn u~) Y,a (Zii ala cn c1z z cn,cn:
N' ' r) . 0. c0 N O'� 0 C'). CO p 0 N 4),1 N',, r•, V N, O r r U N•
o. rOi, r• x• i M rxi �I r) ^'' 1, rn CO rnl �, �' cp. 'X '•-• I(LLO rx) N'c0'',rn • a), ax)',
N'. c0' c0' CO 0`, CO' (O c•')! O N. 0 (O N • c'O.j �! (O , c0 c0 0', (O (O c0', (O
7 , N (/) c')• c')' c') COO c')1 (7 c'), C')11 0 (00. C'). CO1 1 7,1 c'OI c'),, c')'' c0. m c') c') '
O _.
Y 200 21 ❑ c
v m D 0 Q• o U c p (21'-'e Z m
CO Z. U• U. CO VIZ - 1
o. m' m o1U' m Z!..
1!U m43 m o'' o e 7' m U 1,Y Y •
m V m, rn1p U'
p o,.>_,U 451 t c U m' 01 �, o c c', m o,=! 0 , r 1.-,U U'•
o
oEEmoc1E, o, o,LT, m. mo U93) o m Y
r0�O0O1�00.:O 'LL N' 7U 7 LL -50'94 >U O11(p m'' 941
� c cic clic oi-tmjE'�m-J cU'I°'�,o.'E2 °.cm o,•� �mmiUm,�'�m om;¢mm-,
>.UIZ U Jam, --
o mo- m 1J_ 0l2 2', o LL E 21, E' oIZ,Z' f0 0 2 0!2 n a)AL.q..1=1 Z12 o LL Z LL 2
'F- U m mmm J, m1, LL W LL'�''.LL 7'LL 7 2. LL'LL i'U lL'. InILL In ELL.'. V,. LL, 7'LLLLF LL LL LL LL
investment Description
Memorandum
Date:
To:
From:
RE:
March 15, 2010
Board of County Commissioners
Dave Kanner, County Administrator
Marty Wynne, Finance Director
Monthly Financial Reports
Attached please find February 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) and Health Benefits
Trust (675).
The projected information has been reviewed and updated, where appropriate, by
the respective departments.
Cc: All Department Heads
GENERAL FUND
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll,
RESOURCES:
Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% $6,050,000 $6,775,995 $ 725,995
Revenues
Property Taxes 13,215,231 19,514,776 6,299,545 67% 98% a) 19,822,847 20,674,385 851,538
Gen. Rev. - excl. Taxes 1,947,641 2,240,806 293,165 67% 77% b) 2,921,462 2,921,462
Assessor 547,136 641,227 94,091 67% 78% c) 820,704 820,704
County Clerk 695,447 1,010,975 315,528 67% 97% d) 1,043,171 1,477,971 434,800
BOPTA 9,194 11,441 2,247 67% 83% c) 13,791 13,791
District Attorney 221,867 125,425 (96,442) 67% 38% 332,800 381,603 48,803
Finance/Tax 124,699 150,374 25,675 67% 80% c) 187,049 197,827 10,778
Veterans 46,795 52,045 5,250 67% 74% 70,192 70,192
Property Management 57,632 58,632 1,000 67% 68% 86,450 86,450
Grant Projects 1,335 1,336 1 67% 67% 2,000 2,000
Total Revenues 16,866,977 23,807,038 6,940,061 67% 94% 25,300,466 26,646,385 1,345,919
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
22,916,977 30,583,033 7,666,056 67% 98% 31,350,466 33,422,380 2.071,914
Exp.
2,193,754 2,042,435 151,319 67% 62% 3,290,631 3,290,631 -
973,803 835,633 138,170 67% 57% 1,460,704 1,450,704 10,000
39,805 33,491 6,314 67% 56% 59,708 63,614 (3,906)
3,058,175 3,029,077 29,098 67% 66% 4,587,263 4,563,140 24,123
497,647 505,367 (7,720) 67% 68% e) 746,471 703,061 43,410
150,467 155,170 (4,703) 67% 69% 225,701 225,701
159,790 157,977 1,813 67% 66% 239,685 239,685 -
70,449 68,593 1,856 67% 65% 105,673 105,673 -
1,075,337 544,443 530,894 67% 34% 1,613,006 1,493,006 120,000
4,063,142 4,063,142 67% 0% 6,094,713 6,')94,713
12,282,369 7,372,185 4,910,184 67% 40% 18,423,555 12,135,215 6,288,340
8,617,941 8,390,857 227,084 67% 65% 12,926,911 12,926,911
TOTAL REQUIREMENTS 20,900,310 15,763,042 5,137,268 67% 50% 31,350,466 25,062,126 6,288,340
NET (Resources - Requirements) 2,016,667 14,819,990 12,803,323 - 8,360,254 8,360,254
Beginning NWC per Requested Budget 8,300,000
a) Projection based on actual collections through November 30, 2009.
b) Year to date includes annual PILT payment of $467,230.
c) Includes 3 quarters of A & T Grant: Assessor -$578,561, Tax -$136,261 and BOPTA -$11,441.
d) Significant foreclosure and refinancing recordings.
e) Year to date includes expenditures paid annually.
Year End
$
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% $6,050,000 $6,775,995 $ 725,995
Revenues
Property Taxes 13,215,231 19,514,776 6,299,545 67% 98% a) 19,822,847 20,674,385 851,538
Gen. Rev. - excl. Taxes 1,947,641 2,240,806 293,165 67% 77% b) 2,921,462 2,921,462
Assessor 547,136 641,227 94,091 67% 78% c) 820,704 820,704
County Clerk 695,447 1,010,975 315,528 67% 97% d) 1,043,171 1,477,971 434,800
BOPTA 9,194 11,441 2,247 67% 83% c) 13,791 13,791
District Attorney 221,867 125,425 (96,442) 67% 38% 332,800 381,603 48,803
Finance/Tax 124,699 150,374 25,675 67% 80% c) 187,049 197,827 10,778
Veterans 46,795 52,045 5,250 67% 74% 70,192 70,192
Property Management 57,632 58,632 1,000 67% 68% 86,450 86,450
Grant Projects 1,335 1,336 1 67% 67% 2,000 2,000
Total Revenues 16,866,977 23,807,038 6,940,061 67% 94% 25,300,466 26,646,385 1,345,919
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
22,916,977 30,583,033 7,666,056 67% 98% 31,350,466 33,422,380 2.071,914
Exp.
2,193,754 2,042,435 151,319 67% 62% 3,290,631 3,290,631 -
973,803 835,633 138,170 67% 57% 1,460,704 1,450,704 10,000
39,805 33,491 6,314 67% 56% 59,708 63,614 (3,906)
3,058,175 3,029,077 29,098 67% 66% 4,587,263 4,563,140 24,123
497,647 505,367 (7,720) 67% 68% e) 746,471 703,061 43,410
150,467 155,170 (4,703) 67% 69% 225,701 225,701
159,790 157,977 1,813 67% 66% 239,685 239,685 -
70,449 68,593 1,856 67% 65% 105,673 105,673 -
1,075,337 544,443 530,894 67% 34% 1,613,006 1,493,006 120,000
4,063,142 4,063,142 67% 0% 6,094,713 6,')94,713
12,282,369 7,372,185 4,910,184 67% 40% 18,423,555 12,135,215 6,288,340
8,617,941 8,390,857 227,084 67% 65% 12,926,911 12,926,911
TOTAL REQUIREMENTS 20,900,310 15,763,042 5,137,268 67% 50% 31,350,466 25,062,126 6,288,340
NET (Resources - Requirements) 2,016,667 14,819,990 12,803,323 - 8,360,254 8,360,254
Beginning NWC per Requested Budget 8,300,000
a) Projection based on actual collections through November 30, 2009.
b) Year to date includes annual PILT payment of $467,230.
c) Includes 3 quarters of A & T Grant: Assessor -$578,561, Tax -$136,261 and BOPTA -$11,441.
d) Significant foreclosure and refinancing recordings.
e) Year to date includes expenditures paid annually.
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
Revenues
Federal Grants 21,183 21,145 (38) 67% 67% a) 31,775 52,994 21,219
SB #1065 -Court Assess. 40,000 33,201 (6,799) 67% 55% 60,000 55,000 (5,000)
Discovery Fee 10,667 9,683 (984) 67% 61% 16,000 12,000 (4,000)
Food Subsidy 20,000 15,557 (4,443) 67% 52% b) 30,000 38,000 8,000
OYA Basic & Diversion 221,633 138,137 (83,496) 67% 42% c) 332,450 340,076 7,626
Inmate/Prisoner Housing 40,000 69,900 29,900 67% 117% d) 60,000 120,000 60,000
Inmate Commissary Fees 533 207 (326) 67% 26% 800 400 (400)
Contract Payments 138,761 47,826 (90,935) 67% 23% e) 208,141 82,500 (125,641)
Miscellaneous 200 147 (53) 67% 49% 300 300
MIP Diversion Fees 667 225 (442) 67% 23% 1,000 500 (500)
Interest on Investments 8,667 11,787 3,120 67% 91% 13,000 16,000 3,000
Leases 1,632 1,600 (32) 67% 65% 2,448 2,400 (48)
Grants - Private 635 635 67% n/a 635 635
Health & Human Svcs Chg 1,245 1,245 67% n/a 2,000 2,000
CCF Interfund Grant 45,333 31,148 (14,185) 67% 46% f) 68,000 54,495 (13,505)
Crime Pry Svcs Interfnd Grnt 13,333 10,521 (2,812) 67% 53% f) 20,000 20,000
Total Revenues 562,609 392,964 (169,645) 67% 47% 843,914 797,300 (46,614)
Transfers In -General Fund 3,695,457 3,695,456 (1) 67% 67% 5,543,186 5,543,186
TOTAL RESOURCES 5,343,066 5,288,461 (54,605) 67% 71% 7,472,100 7,540,527 68,427
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
1,886,768 1,871,953 14,815 67% 66% 2,830,152 2,884,000 (53,848)
Materials and Services 881,398 725,520 155,878 67% 55% g) 1,322,097 1,148,000 174,097
Capital Outlay 67 67 67% 0% 100 100
Juvenile Resource Center
Personal Services 1,688,103 1,537,225 150,878 67% 61% 2,532,154 2,342,000 190,154
Materials and Services 123,269 122,799 470 67% 66% 184,903 183,000 1,903
Capital Outlay 67 67 67% 0% 100 100
Contingency 401,729 401,729 67% n/a 602,594 602,594
TOTAL REQUIREMENTS 4,981,401 4,257,497 723,904 67% 57% 7,472,100 6,557,100 915,000
NET (Resources - Requirements) 361,665 1,030,964 669,299 983,427 983,427
Beginning NWC per Requested Budget 987,000
a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly.
b) Food Subsidy receipts reflect payments for July -December.
c) OYA Basic and Diversion second quarter payment received in February. Payments are based on reimbursement requests
for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year.
d) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
e) YTD BRS revenue for July -January. Projection reduced to reflect actual youth count at less than half of original estimate.
f) Second quarter payments received in February.
g) Positive variance a result of accruals during July of June expenses, BRS contract payments being lower than anticipated due
to low youth count in the program and a decrease in Maplestar contract for youth services.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
Revenues
Federal Grants 21,183 21,145 (38) 67% 67% a) 31,775 52,994 21,219
SB #1065 -Court Assess. 40,000 33,201 (6,799) 67% 55% 60,000 55,000 (5,000)
Discovery Fee 10,667 9,683 (984) 67% 61% 16,000 12,000 (4,000)
Food Subsidy 20,000 15,557 (4,443) 67% 52% b) 30,000 38,000 8,000
OYA Basic & Diversion 221,633 138,137 (83,496) 67% 42% c) 332,450 340,076 7,626
Inmate/Prisoner Housing 40,000 69,900 29,900 67% 117% d) 60,000 120,000 60,000
Inmate Commissary Fees 533 207 (326) 67% 26% 800 400 (400)
Contract Payments 138,761 47,826 (90,935) 67% 23% e) 208,141 82,500 (125,641)
Miscellaneous 200 147 (53) 67% 49% 300 300
MIP Diversion Fees 667 225 (442) 67% 23% 1,000 500 (500)
Interest on Investments 8,667 11,787 3,120 67% 91% 13,000 16,000 3,000
Leases 1,632 1,600 (32) 67% 65% 2,448 2,400 (48)
Grants - Private 635 635 67% n/a 635 635
Health & Human Svcs Chg 1,245 1,245 67% n/a 2,000 2,000
CCF Interfund Grant 45,333 31,148 (14,185) 67% 46% f) 68,000 54,495 (13,505)
Crime Pry Svcs Interfnd Grnt 13,333 10,521 (2,812) 67% 53% f) 20,000 20,000
Total Revenues 562,609 392,964 (169,645) 67% 47% 843,914 797,300 (46,614)
Transfers In -General Fund 3,695,457 3,695,456 (1) 67% 67% 5,543,186 5,543,186
TOTAL RESOURCES 5,343,066 5,288,461 (54,605) 67% 71% 7,472,100 7,540,527 68,427
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
1,886,768 1,871,953 14,815 67% 66% 2,830,152 2,884,000 (53,848)
Materials and Services 881,398 725,520 155,878 67% 55% g) 1,322,097 1,148,000 174,097
Capital Outlay 67 67 67% 0% 100 100
Juvenile Resource Center
Personal Services 1,688,103 1,537,225 150,878 67% 61% 2,532,154 2,342,000 190,154
Materials and Services 123,269 122,799 470 67% 66% 184,903 183,000 1,903
Capital Outlay 67 67 67% 0% 100 100
Contingency 401,729 401,729 67% n/a 602,594 602,594
TOTAL REQUIREMENTS 4,981,401 4,257,497 723,904 67% 57% 7,472,100 6,557,100 915,000
NET (Resources - Requirements) 361,665 1,030,964 669,299 983,427 983,427
Beginning NWC per Requested Budget 987,000
a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly.
b) Food Subsidy receipts reflect payments for July -December.
c) OYA Basic and Diversion second quarter payment received in February. Payments are based on reimbursement requests
for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year.
d) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
e) YTD BRS revenue for July -January. Projection reduced to reflect actual youth count at less than half of original estimate.
f) Second quarter payments received in February.
g) Positive variance a result of accruals during July of June expenses, BRS contract payments being lower than anticipated due
to low youth count in the program and a decrease in Maplestar contract for youth services.
SHERIFF - Fund 255
Statement of Financial Operating Data
Eight Months Ended February 28, 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
13,495,291
8,478,215
$ 183,677
11,611,695
7,737,343
17,863
$ 183,677 100%
21,973,506 19,366,901
TOTAL RESOURCES 21,973,506 19,550,578
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriff's Division
Civil
Automotive/Communications
Investigations/Evidence
Patrol/Civil/Comm Supp
Records
Adult Jail
Court Security
Emergency Services
Special Services Division
Regional Work Center
Training Division
Other Law Enforcement Svcs
Non -Departmental
Contingency
1,436,925
491,641
931,923
1,121,551
4,977,311
428,242
6,103,274
143,939
125,714
772,460
1,825,228
266,702
351,801
308,696
2,361,433
1,372,388
487,912
894,498
996,490
4,885,672
393,723
5,413,299
127,558
127,888
734,184
1,551,487
216,652
369,538
442,032
Transfers Out 326,667 245,000
n/a
Budget
Year End
Projection
Variance
$ 183,677
$ 183,677
(1,883,596) 67% 57% a) 20,242,936 17,359,242 0,883,694)
(740,872) 67% 61% a) 12,717,322 11,098,867 (111,618,455)
17,863 67% n/a 35,000 35,000
(2,606,605) 67% 59% 32,960,258 28,493,109 (4,467,149)
(2,422,928) 67% 59% 32,960,258 28,676,786 (4,283,472)
Exp.
64,537 67% 64% 2,155,388 2,155,388
3,729 67% 66% 737,461 737,461
37,425 67% 64% 1,397,884 1,397,884
125,061 67% 59% b) 1,682,327 1,593,327 89,000
91,639 67% 65% c) 7,465,967 7,259,967 206,000
34,519 67% 61% 642,363 642,363 -
689,975 67% 59% c) 9,154,909 8,853,909 301,000
16,381 67% 59% 215,908 215,908
(2,174) 67% 68% 188,571 188,571
38,276 67% 63% 1,158,690 1,158,690 -
273,741 67% 57% c) 2,737,842 2,423,842 314,000
50,050 67% 54% 400,053 400,053 -
(17,737) 67% 70% 527,702 527,702
(133,336) 67% 95% 463,044 463,044 -
2,361,433 67% n/a 3,542,149 - 3 542,149
81,667 67% 50% 490,000 490,000
TOTAL REQUIREMENTS 21,973,507 18,258,321
3,715,186 67% 55% 32,960,258 28,508,109 4,452,149
NET (Resources - Requirements) (1) 1,292,257
1,292,258
Beginning NWC per Requested Budget
168,677 168,677
a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 2nd quarter actual.
b) Delay of employee retirement expenses to next year.
c) Personnel expenditures less than budgeted due to unfilled positions and less than planned Materials & Services.
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current 9,879,802
Tax Revenues - Prior 333,333
Federal Grants 23,333
State Grant 30,104
Transp. of State Wards 3,333
SB 1145 1,147,461
Des. Cty Video Lottery Grant 3,333
Des Cty Court Security 86,000
Des Cty Juvenile Contract 2,000
Title III Reimbursement 100,000
Transport 1,333
DC Fair & Expo Center
Inmate Commissary Fees 40,000
Work Center Work Crews 28,300
Concealed Handgun Classes 4,000
Soc Sec Incentive -Fed 3,333
Miscellaneous 2,667
Oregon Mentors 3,333
Medical Services Reimb 8,000
Restitution 700
Sheriff Fees 106,667
Interest 18,889
Interest on Unsegregated 2,355
Rentals 19,999
Donations
SHERIFF 701
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
$ 2,470,519 $ 3,343,461 $ 872,942 67%
Total Revenues
TOTAL RESOURCES
14,142,578
683,126
122,411
53,616
1,480,995
5,000
85,700
5,456
47,259
2,479
2,100
29,534
19,590
4,500
7,800
7,541
1,902
6,514
1,109
138,474
34,470
2,943
60,030
50
4,262,776 67%
349,793 67%
99,078 67%
23,512 67%
(3,333) 67%
333,534 67%
1,667 67%
(300) 67%
3,456 67%
(52,741) 67%
1,146 67%
2,100 67%
(10,466) 67%
(8,710) 67%
500 67%
4,467 67%
4,874 67%
(1,431) 67%
(1,486) 67%
409 67%
31,807 67%
15,581 67%
588 67%
40,031 67%
50 67%
11,848,275 16, 945,177
5,096,902 67%
nla $ 2,470,519 $ 3,343,461 $ 872,942
95% a)
137% a)
350% b)
119% c)
86% d)
n/a
66%
182%
n/a
n/a
n/a
49%
46%
75%
156%
189%
n/a
54%
106%
87%
122%
83%
200% e)
n/a
95%
14,819, 703
500,000
35,000
45,156
5,000
1,721,192
5,000
129,000
3,000
150,000
2,000
60,000
42,450
6,000
5,000
4,000
5,000
12,000
1,050
160,000
28,333
3,533
30,000
14,981,411
727,128
122,411
71,488
5,000
1,935,336
5,000
129,000
8,000
150,000
4,000
3,000
60,000
42,450
6,000
10,000
10,000
5,000
12,000
1,200
160,000
46,877
3,533
67,236
50
161,708
227,128
87,411
26,332
214,144
5,000
2,000
3,000
5,000
6,000
150
18,544
37,236
50
17,772,417
18,566,120 793,703
14,318,794 20,288,638 5,969,844 67% 100% 20,242,936 21,909,581 1,666,645
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 13,495,292
11,611,695
1,883,597 67%
Exp.
57% f) 20,242,936 17,359,242 2,883,694
TOTAL REQUIREMENTS 13,495,292 11,611,695 1,883,597 67% 57% 20,242,936 17,359,242 2,883,694
NET (Resources - Requirements)
823,502 8,676,943 7,853,441 - 4,550,338 4,550,338
Beginning NWC per Requested Budget 4,722,862
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG Grant received.
c) Timing of Emergency Planning grant reimbursements.
d) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
e) FBI relocation from Sheriff's Office has been delayed resulting in 6 months of additional rental revenue.
f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual.
Year End
Budget
Projection
Variance
nla $ 2,470,519 $ 3,343,461 $ 872,942
95% a)
137% a)
350% b)
119% c)
86% d)
n/a
66%
182%
n/a
n/a
n/a
49%
46%
75%
156%
189%
n/a
54%
106%
87%
122%
83%
200% e)
n/a
95%
14,819, 703
500,000
35,000
45,156
5,000
1,721,192
5,000
129,000
3,000
150,000
2,000
60,000
42,450
6,000
5,000
4,000
5,000
12,000
1,050
160,000
28,333
3,533
30,000
14,981,411
727,128
122,411
71,488
5,000
1,935,336
5,000
129,000
8,000
150,000
4,000
3,000
60,000
42,450
6,000
10,000
10,000
5,000
12,000
1,200
160,000
46,877
3,533
67,236
50
161,708
227,128
87,411
26,332
214,144
5,000
2,000
3,000
5,000
6,000
150
18,544
37,236
50
17,772,417
18,566,120 793,703
14,318,794 20,288,638 5,969,844 67% 100% 20,242,936 21,909,581 1,666,645
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 13,495,292
11,611,695
1,883,597 67%
Exp.
57% f) 20,242,936 17,359,242 2,883,694
TOTAL REQUIREMENTS 13,495,292 11,611,695 1,883,597 67% 57% 20,242,936 17,359,242 2,883,694
NET (Resources - Requirements)
823,502 8,676,943 7,853,441 - 4,550,338 4,550,338
Beginning NWC per Requested Budget 4,722,862
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG Grant received.
c) Timing of Emergency Planning grant reimbursements.
d) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
e) FBI relocation from Sheriff's Office has been delayed resulting in 6 months of additional rental revenue.
f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual.
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants
US Forest Service
State Grant
SB #1065 Court Assessment
Marine Board License Fee
Des Cty General Fund Grnt
Des Cty Transient Room Tax
City of Sisters
Des Cty Tax/Fin Contract
Des Cty CDD Contract
Des Cty Solid Waste Contr
Des Cty Clerk/Election
School Districts
Security & Traffic Reimb
Seat Belt Program
Miscellaneous
Sheriff Fees
Court Fines & Fees
Impound Fees
Restitution - Street Crimes
Seizure/Forfeiture
Interest
Interest on Unsegregated
Sale of Reportable Assets
Sale of Equip & Material
Total Revenues
TOTAL RESOURCES
SHERIFF 702
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$1,287,473 $ 1,433,708 $ 146,235
4,826,467
159,333
1,333
51,000
125,089
44,667
82,979
575,442
1,191,225
280,010
667
18,122
54,365
1,333
66,667
8,667
4,000
6,667
3,333
56,667
50,000
6,667
1,200
4,000
6,928,674
347,902
60,606
51,000
121,962
33,201
78,500
10,000
1,191,225
277,343
1,405
18,122
54,364
1,263
34,252
7,871
5,925
7,315
8,403
78,755
8,800
500
1,122
9,991
1,442
6,779
11,508
2,102,207
188,569
59,273
(3,127)
(11,466)
(4,479)
(565,442)
67% n/a $ 1,287,473 $1,433,708 $ 146,235
67%
67%
67%
67%
67%
67%
67%
67%
67%
(2,667) 67%
738 67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
(1)
(70)
(32,415)
(796)
1,925
648
5,070
22,088
(41,200)
500
1,122
3,324
242
6,779
7,508
7,619,900 9,358,230 1,738,330 67%
8,907,373 10,791,938 1,884, 565 67%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 8,478,215
7,737,343 740,872 67%
96% a)
146% a)
3030% b)
67%
65%
50%
63%
1%
67%
66% c)
141%
67%
67%
63%
n/a d)
61%
99%
73%
168%
93%
12% e)
n/a
n/a
100%
80%
n/a
192%
82%
7,239,702
239,000
2,000
76,500
187,633
67,000
124,468
863,163
1,786,837
420,015
1,000
27,183
81,548
2,000
100,000
13,000
6,000
10,000
5,000
85,000
75,000
10,000
1,800
6,000
7,339,633
370,961
60,606
76,500
187,633
67,000
124,468
863,163
1,786,837
416,016
1,405
27,183
81,548
2,000
100,000
13,000
6,000
10,000
10,000
85,000
13,371
500
2,500
12,833
1,800
10,000
12,000
99,931
131,961
58,606
(3,999)
405
5,000
(61,629)
500
2,500
2,833
10,000
6,000
11,429,849
11,681,957 252,108
85% 12,717,322 13,115,665 398,343
Exp.
61% f) 12,717,322 11,098,867 1 618,455
TOTAL REQUIREMENTS 8,478,215 7,737,343 740,872 67% 61% 12,717,322 11,098,867 1,618,455
NET (Resources - Requirements)
429,158 3,054,595 2,625,437 - 2,016,798 2,016,798
Beginning NWC per Requested Budget 1,905,939
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG grant received and higher than planned HIDTA reimbursements.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) YTD variance due to timing of revenue and expenses.
e) Change in law resulting in less impound fee revenue.
f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual.
Year End
Budget
Projection
Variance
67% n/a $ 1,287,473 $1,433,708 $ 146,235
67%
67%
67%
67%
67%
67%
67%
67%
67%
(2,667) 67%
738 67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
(1)
(70)
(32,415)
(796)
1,925
648
5,070
22,088
(41,200)
500
1,122
3,324
242
6,779
7,508
7,619,900 9,358,230 1,738,330 67%
8,907,373 10,791,938 1,884, 565 67%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 8,478,215
7,737,343 740,872 67%
96% a)
146% a)
3030% b)
67%
65%
50%
63%
1%
67%
66% c)
141%
67%
67%
63%
n/a d)
61%
99%
73%
168%
93%
12% e)
n/a
n/a
100%
80%
n/a
192%
82%
7,239,702
239,000
2,000
76,500
187,633
67,000
124,468
863,163
1,786,837
420,015
1,000
27,183
81,548
2,000
100,000
13,000
6,000
10,000
5,000
85,000
75,000
10,000
1,800
6,000
7,339,633
370,961
60,606
76,500
187,633
67,000
124,468
863,163
1,786,837
416,016
1,405
27,183
81,548
2,000
100,000
13,000
6,000
10,000
10,000
85,000
13,371
500
2,500
12,833
1,800
10,000
12,000
99,931
131,961
58,606
(3,999)
405
5,000
(61,629)
500
2,500
2,833
10,000
6,000
11,429,849
11,681,957 252,108
85% 12,717,322 13,115,665 398,343
Exp.
61% f) 12,717,322 11,098,867 1 618,455
TOTAL REQUIREMENTS 8,478,215 7,737,343 740,872 67% 61% 12,717,322 11,098,867 1,618,455
NET (Resources - Requirements)
429,158 3,054,595 2,625,437 - 2,016,798 2,016,798
Beginning NWC per Requested Budget 1,905,939
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG grant received and higher than planned HIDTA reimbursements.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) YTD variance due to timing of revenue and expenses.
e) Change in law resulting in less impound fee revenue.
f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual.
RESOURCES:
Beg. Net Working Capital
Revenues
Medicare Reimbursement
State Grant
Child Dev & Rehab Center
State Miscellaneous
OMAP
Family Planning Exp Proj
Grants
FY 2008-2009
Miscellaneous
Patient Insurance Fees
Health Dept/Patient Fees
Vital Records -Birth
Vital Records -Death
Interest on Investments
Donations
Interfund Contract
Administrative Fee
Drug Court Byrne
Total Revenues
Transfers In -Reserve Fund
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
PUBLIC HEALTH
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll.
Revised
Budget
Year End
Projection
Variance
$ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355
2,667 50 (2,617) 67% 1% 4,000
1,648,864 1,383,641 (265,223) 67% 56% a) 2,473,296
23,158 15,379 (7,779) 67% 44% 34,737
142,160 115,880 (26,280) 67% 54% 213,240
202,000 333,530 131,530 67% 110% 303,000
316,667 325,004 8,337 67% 68% 475,000
42,715 42,715 67% n/a b)
4,568 4,568 67% n/a
2,430 2,430 67% n/a
89,200 106,421 17,221 67%
101,433 84,309 (17,124) 67% 55%
24,000 20,005 (3,995) 67% 56%
65,333 63,435 (1,898) 67% 65%
25,333 10,971 (14,362) 67% 29%
5,867 34,304 28,437 67% 390%
87,849 42,075 (45,774) 67% 32% c)
18,000 18,000 - 67% 67%
1,647 1,647 67% n/a
2,752,531 2,604,364 (148,167) 67% 63% 4,128,797 4,488,749 359,952
80%
133,800
152,150
36,000
98,000
38,000
8,800
131,774
27,000
4,000
2,701,113 227,817
30,759 (3,978)
227,646 14,406
360,000 57,000
475,000
42,715 42,715
4,568 4,568
2,430 2,430
156,119 22,319
124,000 (28,150)
30,000 (6,000)
95,150 (2,850)
16,180 (21,820)
34,304 25,504
127,704 (4,070)
27,000 -
30,061 30,061
16,667 -
1,545,177 1,545,176
5,214,375 5,269,895
(16,667) 67%
(1) 67%
72,187 67%
0% 25,000 25,000
67% 2,317,765 2,317,765
71% 7,371,562 7,951,869 580,307
Exp. %
3,003,841 2,794,865 208,976 67% 62% a) 4,505,762 4,539,942
1,179,230 947,744 231,486 67% 54% a) 1,768,845 2,064,915
24,601 24,601 67% 0% 36,902 36,902
100,000 75,000 25,000 67% 50% 150,000 150,000
606,702 606,702 67% n/a 910,053
(34,180)
(296,070)
910,053
4,914,374 3,817,609 1,096,765 67% 52% 7,371,562 6,791,759 579,803
300,001 1,452,286 1,168,952 - 1,160,110 1,160,110
Beginning NWC per Requested Budget
1,100,000
a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 6. Grant appropriation for revisions in process.
b) Grants for HIV and Chronic Care were not included in FY 2010 budget.
c) Public Health Nurse II for Juvenile, reduced to .60 FTE from .75 FTE. Contract is for actual expenditure.
RESOURCES:
Beg. Net Working Capital $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004)
Revenues
Marriage Licenses 3,667 3,395 (272) 67% 62% 5,500 5,500
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Revised
Year to Date
Budget
Actual Variance
FY % Coll. %
Revised
Year End
Budget
Projection
Variance
Divorce Filing Fees 83,333 84,061 728 67% 67% 125,000 125,000
Domestic Partnership Fee 1,333 90 (1,243) 67% 5% 2,000 200 (1,800)
Federal Grants 66,546 75,168 8,622 67% 75% a) 99,819 99,819
State Grants 3,518,057 3,684,115 166,058 67% 70% b) 5,277,086 5,351,224 74,138
State Miscellaneous 123,144 100,083 (23,061) 67% 54% 184,716 184,716
Title 19 200,470 66,714 (133,756) 67% 22% c) 300,705 200,000 (100,705)
Liquor Revenue 70,667 77,560 6,893 67% 73% 106,000 130,000 24,000
School Districts 46,667 54,300 7,633 67% 78% 70,000 78,900 8,900
Miscellaneous 27,200 47,061 19,861 67% 115% 40,800 50,000 9,200
Patient Insurance Fees 165,000 80,209 (84,791) 67% 32% 247,500 150,000 (97,500)
Patient Fees 7,667 2,271 (5,396) 67% 20% 11,500 5,000 (6,500)
Seizure/Forfeiture 13,129 13,129 67% n/a 13,129 13,129
Interest on Investments 21,333 28,160 6,827 67% 88% 32,000 45,000 13,000
Rentals 11,000 6,375 (4,625) 67% 39% 16,500 16,500 -
Donations 2,000 7,000 5,000 67% 233% 3,000 7,000 4,000
Interfund Contract 2,080 (2,080) 67% 0% 3,120 (3,120)
Administrative Fee 2,023,303 2,004,638 (18,665) 67% 66% 3,034,954 3,031,954 (3,000)
Comm. on Children & Fam 14,667 (14,667) 67% 0% 22,000 (22,000)
Crime Prevention Services 84,667 72,364 (12,303) 67% 57% a) 127,000 127,000 -
Total Revenues
6,472,801 6,406,693 (66,108) 67% 66% 9,709,200 9,620,942 (88,258)
Transfers In -General Fund 877,439
Transfers In -Other 170,424
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
865,778 (11,661) 67% 66% 1,316,158 1,316,158
253,750 83,326 67% 99% 255,636 363,129 107,493
10,245,664 10,116,217 (129,447) 67% 72% 14,005,994 13,890,225 (115,769)
Exp. %
5,270,453 4,820,230 450,223 67% 61% d) 7,905,680 7,470,661 435,019
2,702,343 2,176,611 525,732 67% 54% 4,053,514 3,653,514 400,000
53,333 53,333 67% 0% 80,000 80,000
100,000 75,000 25,000 67% 50% 150,000 150,000 -
1,211,200 1,211,200 67% n/a 1,816,800 1.816,800
TOTAL REQUIREMENTS 9,337,329 7,071,841 2,265,488 67% 50% 14,005,994 11,274,175 2 731,819
NET (Resources - Requirements) 908,335 3,044,376 2,136,041 - 2,616,050 2 616,050
Beginning NWC per Requested Budget 2,616,050
a) Grant billing received quarterly, in arrears.
b) Department of Human Services Grant projected at amended contract amount for FY 2010.
c) Delay in payment due to problems with the State MMIS software system.
d) 10% reduction in hours through 12/31/09.
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. °A,
RESOURCES:
Beg. Net Working Capital $ 413,471
Revenues
Admin -Operations 2,433
Admin -GIS 1,383
Admin -Code Enforcement 126,300
Building Safety 649,850
Electrical 187,000
Contract Services 170,333
Env Health -On Site Prog 195,233
Env Health-Lic Facilities 460,317
Env Health - Drinking H2O 63,541
Planning -Current 656,100
Planning -Long Range 285,933
Total Revenues
Trans In -GF
Trans In -GF for Lng Rng Ping
Trans In -Other
TOTAL RESOURCES
Revised
Year End
Budget
Projection
Variance
629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188
11,391
21,707
113,618
615,686
169,896
72,920
140,076
637,564
58,592
413,197
234,541
8,958
20,324
(12,682)
(34,164)
(17,104)
(97,413)
(55,158)
177,247
(4,949)
(242,903)
(51,392)
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
67%
312% a)
1046% b)
60% c)
63% c)
61% c)
29% d)
48% c)
92% e)
61% f)
42% g)
55% c)
3,650
2,075
189,450
974,775
280,500
255,500
292,850
690,475
95,311
984,150
428,900
16,850
39,925
157,750
921,625
244,950
119,200
221,200
685,430
95,300
677,070
327,600
13,200
37,850
(31,700)
(53,150)
(35,550)
(136,300)
(71,650)
(5,045)
(11)
(307,080)
(101,300)
2,798,423 2,489,186 (309,237) 67% 59% 4,197,636 3,506,900 (690,736)
811,085
200,000
77,199
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Pgm
Env Health-Lic Facilities
Env Health - Drinking H2O
Planning -Current
Planning -Long Range
Transfers Out (D/S Fund)
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
4,300,178
1,138, 741
143,737
120,646
483,430
137,813
176,521
160,458
330,631
53,732
539,855
367,885
118,440
390,466
811,085 0% n/a 1,216,627 1,216,627
200,000 0% n/a 300,000 300,000
(77,199) 0% 0% 115,799 114,734 (1,065)
4,129,930 (170,248) 67% 66% 6,243,533 5,767,920 (475,613)
1,108,474
135,547
115,408
468,412
129,864
171,854
154,031
330,011
55,079
518,852
296,848
162,418
30,267 67%
8,190 67%
5,238 67%
15,018 67%
7,949 67%
4,667 67%
6,427 67%
620 67%
(1,347) 67%
21,003 67%
71,037 67%
(43,978) 0%
390,466 67%
Exp. %
65% h)
63%
64% h)
65% h)
63% h)
65% h)
64%
67% i)
68% i)
64% h)
54%
91 %
n/a
1,708,112
215,606
180,969
725,145
206,719
264,781
240,687
495,946
80,598
809,783
551,828
177,660
585,699
1,640,551
210,420
156,688
613,244
187,846
245,643
233,730
496,146
82,069
793,139
457,503
177,660
67,561
5,186
24,281
111,901
18,873
19,138
6,957
(200)
(1,471)
16,644
94,325
585,699
4,162,355 3,646,796 515,559 67% 58% 6,243,533 5,294,639 948,894
137,823 483,134
345,311
Beginning NWC per Requested Budget
Revenues
Expenditures
Net from Operations
2,489,186
3,646,796
(1,157,610)
473,281 473,281
474,246
3,506,900
5,294,639
(1,787,739)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance. -
b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer.
c) Projections are below budget due to recent volume downturns.
d) Significant drop-off in City of Redmond work.
e) Revenue is received primarily in December through February following mailing of license renewal statements.
f) Payments from State DHS are received irregularly.
g) Significant slowdown in land use applications.
h) Projection reflects layoffs/hour reductions effective in February and the Building Official retirement in November.
i) Due to classification changes and salary adjustments, it is expected that total budget will be slightly exceeded.
ROAD
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget _
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
Revenues
Federal Reimbursements 326,667 (326,667) 67% 0% 490,000 12,154 (4'7,846)
System Development Chrg - 462 462 67% n/a 462 462
Mineral Lease Royalties 6,667 31,462 24,795 67% 315% 10,000 31,462 ."1,462
Forest Receipts 1,654,667 2,482,350 827,683 67% 100% a) 2,482,000 2,482,350 350
State Grant 276,985 (276,985) 67% 0% 415,477 (4' 5,477)
State Miscellaneous 54,322 54,322 67% n/a - 54,322 r 4,322
Motor Vehicle Revenue 5,333,333 5,212,123 (121,210) 67% 65% 8,000,000 8,000,000 -
City of Bend 150,000 279,019 129,019 67% 124% b) 225,000 281,000 (6,000
City of Redmond 166,667 316,603 149,936 67% 127% b) 250,000 316,603 (.6,603
City of Sisters 6,667 (6,667) 67% 0% b) 10,000 10,000 -
City of La Pine 6,667 (6,667) 67% n/a b) 10,000 10,000 -
Admin Recovery (SDC) 333 982 649 67% n/a 500 1,200 700
Miscellaneous 86,667 18,550 (68,117) 67% 14% 130,000 156,075 26,075
Road Vacations 667 500 (167) 67% 50% 1,000 1,000 -
Interest on Investments 33,333 32,521 (812) 67% 65% 50,000 40,000 (13,000)
Other Bank/LGIP Interest 1,482 1,482 67% n/a 1,600 1,600
Parking Fees - 150 150 67% n/a - 375 375
Interfund Contract 466,667 (466,667) 67% 0% c) 700,000 730,000 3),000
Equipment Repairs 183,333 172,204 (11,129) 67% 63% 275,000 245,000 (30,000)
Vehicle Repairs 60,000 (60,000) 67% 0% c) 90,000 90,000 -
Vegetation Management 23,333 (23,333) 67% 0% c) 35,000 20,000 (1.3,000)
Inter -fund: Forester 14,667 - (14,667) 67% 0% c) 22,000 22,000 -
Car Washes 1,667 1,982 315 67% 79% 2,500 3,300 800
Car Rental 406 406 67% n/a 500 500
Sale of Eqp & Material 533,333 452,593 (80,740) 67% 57% 800,000568,175 23' ,825)
Total Revenues 9,332,320 9,057,711 (274,609) 67% 65% 13,998,477 13,077,578 (920,899)
Trans In - CDD 12,127 - (12,127) 67% 0% 18,190 18,190
Trans In - Solid Waste 472,378 354,284 (118,094) 67% 50% d) 708,567 708,567
Trans In - Transp SDC 50,000 37,500 (12,500) 67% 50% d) 75,000 75,000
Trans In -Road Imp Res 6,667 - (6,667) 67% 0% c) 10,000 10,000
TOTAL RESOURCES 14,695,157 14,341,144 (391,513) 67% 75% 19,681,899 18,780,984 (90C',915)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
Exp. %
3,776,915 3,503,707 273,208 67% 62% 5,665,373 5,311,065 354,308
6,088,807 5,311,677 777,130 67% 58% e) 9,133,210 8,354,124 775,086
1,800,000 1,209,639 590,361 67% 45% 2,700,000 1,283,914 1,41(,086
266,667 - 266,667 67% 0% 400,000 400,000
1,188,877 1,188,877 67% n/a 1,783,316 1,783316
TOTAL REQUIREMENTS 13,121,266 10,025,023 3,096,243 67% 51% 19,681,899 15,349,103 4,332 796
NET (Resources - Requirements) 1,573,891 4,316,121 2,704,730 3,431,881 3,431 881
Beginning NWC per Requested Budget 3,430,429
a) Annual payment, $2,482,350, received January 15, 2010.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Transfer made quarterly.
e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
Revenues
Federal Reimbursements 326,667 (326,667) 67% 0% 490,000 12,154 (4'7,846)
System Development Chrg - 462 462 67% n/a 462 462
Mineral Lease Royalties 6,667 31,462 24,795 67% 315% 10,000 31,462 ."1,462
Forest Receipts 1,654,667 2,482,350 827,683 67% 100% a) 2,482,000 2,482,350 350
State Grant 276,985 (276,985) 67% 0% 415,477 (4' 5,477)
State Miscellaneous 54,322 54,322 67% n/a - 54,322 r 4,322
Motor Vehicle Revenue 5,333,333 5,212,123 (121,210) 67% 65% 8,000,000 8,000,000 -
City of Bend 150,000 279,019 129,019 67% 124% b) 225,000 281,000 (6,000
City of Redmond 166,667 316,603 149,936 67% 127% b) 250,000 316,603 (.6,603
City of Sisters 6,667 (6,667) 67% 0% b) 10,000 10,000 -
City of La Pine 6,667 (6,667) 67% n/a b) 10,000 10,000 -
Admin Recovery (SDC) 333 982 649 67% n/a 500 1,200 700
Miscellaneous 86,667 18,550 (68,117) 67% 14% 130,000 156,075 26,075
Road Vacations 667 500 (167) 67% 50% 1,000 1,000 -
Interest on Investments 33,333 32,521 (812) 67% 65% 50,000 40,000 (13,000)
Other Bank/LGIP Interest 1,482 1,482 67% n/a 1,600 1,600
Parking Fees - 150 150 67% n/a - 375 375
Interfund Contract 466,667 (466,667) 67% 0% c) 700,000 730,000 3),000
Equipment Repairs 183,333 172,204 (11,129) 67% 63% 275,000 245,000 (30,000)
Vehicle Repairs 60,000 (60,000) 67% 0% c) 90,000 90,000 -
Vegetation Management 23,333 (23,333) 67% 0% c) 35,000 20,000 (1.3,000)
Inter -fund: Forester 14,667 - (14,667) 67% 0% c) 22,000 22,000 -
Car Washes 1,667 1,982 315 67% 79% 2,500 3,300 800
Car Rental 406 406 67% n/a 500 500
Sale of Eqp & Material 533,333 452,593 (80,740) 67% 57% 800,000568,175 23' ,825)
Total Revenues 9,332,320 9,057,711 (274,609) 67% 65% 13,998,477 13,077,578 (920,899)
Trans In - CDD 12,127 - (12,127) 67% 0% 18,190 18,190
Trans In - Solid Waste 472,378 354,284 (118,094) 67% 50% d) 708,567 708,567
Trans In - Transp SDC 50,000 37,500 (12,500) 67% 50% d) 75,000 75,000
Trans In -Road Imp Res 6,667 - (6,667) 67% 0% c) 10,000 10,000
TOTAL RESOURCES 14,695,157 14,341,144 (391,513) 67% 75% 19,681,899 18,780,984 (90C',915)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
Exp. %
3,776,915 3,503,707 273,208 67% 62% 5,665,373 5,311,065 354,308
6,088,807 5,311,677 777,130 67% 58% e) 9,133,210 8,354,124 775,086
1,800,000 1,209,639 590,361 67% 45% 2,700,000 1,283,914 1,41(,086
266,667 - 266,667 67% 0% 400,000 400,000
1,188,877 1,188,877 67% n/a 1,783,316 1,783316
TOTAL REQUIREMENTS 13,121,266 10,025,023 3,096,243 67% 51% 19,681,899 15,349,103 4,332 796
NET (Resources - Requirements) 1,573,891 4,316,121 2,704,730 3,431,881 3,431 881
Beginning NWC per Requested Budget 3,430,429
a) Annual payment, $2,482,350, received January 15, 2010.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Transfer made quarterly.
e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY%
Coll.
Revised
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782
Revenues
DOC Measure 57 144,870 217,350 72,480 67% 100% a) 217,305 217,350 45
State Miscellaneous 5,333 4,301 (1,032) 67% 54% 8,000 4,301 (3,699)
Alternate Incarceration 30,918 30,918 67% n/a b) 30,918 30,918
State Subsidy 19,667 9,980 (9,687) 67% 34% b) 29,500 13,306 (16,194)
SB 1145 1,893,283 2,221,492 328,209 67% 78% c) 2,839,925 2,961,990 122,065
Probation Work Crew Fees 26,667 23,610 (3,057) 67% 59% 40,000 36,000 (4,000)
Miscellaneous 2,000 3,190 1,190 67% 106% 3,000 5,000 2,000
Electronic Monitoring Fee 106,667 119,129 12,462 67% 74% d) 160,000 175,000 15,000
Probation Superv. Fees 146,667 150,911 4,244 67% 69% 220,000 220,000
Interest on Investments 6,000 8,534 2,534 67% 95% 9,000 9,000
Interfund - Sheriff 33,333 37,500 4,167 67% 75% 50,000 50,000
Crime Prevention Services 33,333 25,000 (8,333) 67% 50% e) 50,000 50,000
Total Revenues 2,417,820 2,851,915 434,095 67% 79% 3,626,730 3,772,865 146,135
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
76,686 76,687
1 67% 67% 115,029 115,029
2,962,398 3,416,276 453,878 67% 81% 4,209,651 4,375,568 165,917
Exp.
1,992,053 1,862,308 129,745 67% 62% 2,988,079 2,925,079 63,000
528,049 478,681 49,368 67% 60% 792,073 792,073
67 67 67% 0% 100 40,000 (39,900)
286,266 286,266 67% n/a 429,399 429,399
TOTAL REQUIREMENTS 2,806,435 2,340,989 465,446 67% 56% 4,209,651 3,757,152 452,499
NET (Resources - Requirements) 155,963 1,075,287 919,324
618,416 618,416
Beginning NWC per Requested Budget 616,371
a) New grant appropriated for drug addicted offenders.
b) Revenue recorded as alternate incarceration and state subsidy; budgeted as state subsidy.
c) Offender population is greater this biennium and DOC revenues higher than estimated.
d) Increase in electronic monitoring use by the courts.
e) Payments made quarterly.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 245,200 162,341 (82,859) 67% 44% d) 367,800 367,600 (200)
Title IV - Family Sup/Pres 25,101 12,545 (12,556) 67% 33% a) 37,652 14,907 (22,745)
HealthyStart Medicaid 63,333 25,585 (37,748) 67% 27% 95,000 95,000
Child Care Block Grant 54,183 (54,183) 67% 0% a) 81,275 (81,275)
Level 7 Services 116,795 167,078 50,283 67% 95% a) 175,193 257,982 82,789
HealthyStart /R -S -G 205,051 231,693 26,642 67% 75% a) 307,577 308,924 1,347
OCCF Grant 409,368 379,433 (29,935) 67% 62% a) 614,052 507,183 (106,869)
Local Government Grants 7,849 7,849 67% n/a e) 7,849 7,849
Charges for Svcs-Misc 5,333 1,861 (3,472) 67% 23% 8,000 8,000
Court Fines & Fees 50,000 50,436 436 67% 67% c) 75,000 70,000 (5,000)
Interest on Investments 20,000 6,176 (13,824) 67% 21% 30,000 30,000
Grants -Private 1,333 (1,333) 67% 0% 2,000 2,000
Interfund Grants 125,000 103,750 (21,250) 67% 55% 187,500 187,500
Crime Prevention Services 49,567 30,041 (19,526) 67% 40% 74,350 74,350
Total Revenues 1,370,264 1,178,788 (191,476) 67% 57% 2,055,399 1,931,295 (124,104)
Trans from General Fund
Total Transfers In
189,555 189,555
- 67% 67%
189,555 189,555
- 67% 67%
284,333 284,333
284,333 284,333
TOTAL RESOURCES 2,184,362 2,036,969 (147,393) 67% 69% 2,964,275 2,884,254 (80,021)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
359,985 350,399 9,586 67% 65% b) 539,978 526,639 13,339
1,278,562 856,438 422,124 67% 45% a,d,e) 1,917,843 1,794,853 122,990
67 67 67% 0% 100 100
337,569 337,569 67% n/a 506,354 506,354
TOTAL REQUIREMENTS 1,976,183 1,206,837 769,346 67% 41% 2,964,275 2,321,492 642,783
NET (Resources - Requirements)
208,179 830,132 621,953
Beginning NWC per Requested Budget
562,762 562,762
a) Revenue projections based on final legislative allocations. Casey mini -grant of $8,800 added.
b) Personnel projection reduced due to two positions open in 1st quarter.
c) Court fees reduced for FY 2010.
d) New federal grant for the Family Access Network awarded.
e) Regional project contributions from Crook & Jefferson counties.
543,926
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 245,200 162,341 (82,859) 67% 44% d) 367,800 367,600 (200)
Title IV - Family Sup/Pres 25,101 12,545 (12,556) 67% 33% a) 37,652 14,907 (22,745)
HealthyStart Medicaid 63,333 25,585 (37,748) 67% 27% 95,000 95,000
Child Care Block Grant 54,183 (54,183) 67% 0% a) 81,275 (81,275)
Level 7 Services 116,795 167,078 50,283 67% 95% a) 175,193 257,982 82,789
HealthyStart /R -S -G 205,051 231,693 26,642 67% 75% a) 307,577 308,924 1,347
OCCF Grant 409,368 379,433 (29,935) 67% 62% a) 614,052 507,183 (106,869)
Local Government Grants 7,849 7,849 67% n/a e) 7,849 7,849
Charges for Svcs-Misc 5,333 1,861 (3,472) 67% 23% 8,000 8,000
Court Fines & Fees 50,000 50,436 436 67% 67% c) 75,000 70,000 (5,000)
Interest on Investments 20,000 6,176 (13,824) 67% 21% 30,000 30,000
Grants -Private 1,333 (1,333) 67% 0% 2,000 2,000
Interfund Grants 125,000 103,750 (21,250) 67% 55% 187,500 187,500
Crime Prevention Services 49,567 30,041 (19,526) 67% 40% 74,350 74,350
Total Revenues 1,370,264 1,178,788 (191,476) 67% 57% 2,055,399 1,931,295 (124,104)
Trans from General Fund
Total Transfers In
189,555 189,555
- 67% 67%
189,555 189,555
- 67% 67%
284,333 284,333
284,333 284,333
TOTAL RESOURCES 2,184,362 2,036,969 (147,393) 67% 69% 2,964,275 2,884,254 (80,021)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
359,985 350,399 9,586 67% 65% b) 539,978 526,639 13,339
1,278,562 856,438 422,124 67% 45% a,d,e) 1,917,843 1,794,853 122,990
67 67 67% 0% 100 100
337,569 337,569 67% n/a 506,354 506,354
TOTAL REQUIREMENTS 1,976,183 1,206,837 769,346 67% 41% 2,964,275 2,321,492 642,783
NET (Resources - Requirements)
208,179 830,132 621,953
Beginning NWC per Requested Budget
562,762 562,762
a) Revenue projections based on final legislative allocations. Casey mini -grant of $8,800 added.
b) Personnel projection reduced due to two positions open in 1st quarter.
c) Court fees reduced for FY 2010.
d) New federal grant for the Family Access Network awarded.
e) Regional project contributions from Crook & Jefferson counties.
543,926
SOLID WASTE
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714
Revenues
State Grant 37,850 37,850 67% n/a a) 37,850 37,850
Miscellaneous 20,000 17,108 (2,892) 67% 57% 30,000 26,210 (3,790)
Franchise 3% Fees 133,333 85,449 (47,884) 67% 43% b) 200,000 200,000
Commercial Disp. Fees 930,933 570,546 (360,387) 67% 41% c) 1,396,400 892,739 (503,661)
Private Disposal Fees 1,027,533 901,816 (125,717) 67% 59% 1,541,300 1,385,323 (155,977)
Franchise Disposal Fees 3,162,333 2,575,956 (586,377) 67% 54% d) 4,743,500 3,856,124 (887,376)
Yard Debris 50,000 44,056 (5,944) 67% 59% 75,000 71,642 (3,358)
Special Waste 20,000 14,486 (5,514) 67% 48% 30,000 24,433 (5,567)
Interest 9,333 9,301 (32) 67% 66% 14,000 12,500 (1,500)
Sale of Carbon Credits - 67% n/a 100,000 100,000
Sale of Equip & Material 23,333 20,041 (3,292) 67% 57% 35,000 23,480 (11,520)
Total Revenues 5,376,798 4,276,609 (1,100,189) 67% 53% 8,065,200 6,630,301 (1,434,899)
TOTAL RESOURCES 5,715,409 4,742,934 (972,475) 67% 56% 8,403,811 7,096,626 (1,307,185)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,175,719 1,127,340 48,379 67% 64% 1,763,578 1,706,334 57,244
2,498,836 2,018,486 480,350 67% 54% e) 3,748,254 3,266,991 481,263
645,843 405,019 240,824 67% 42% 968,765 968,765
99,333 38,051 61,282 67% 26% f) 149,000 53,460 95,540
959,845 354,284 605,561 67% 25% 1,439,767 708,567 731,200
222,965 222,965 67% n/a 334,447 334,447
TOTAL REQUIREMENTS 5,602,541 3,943,180 1,659,361 67% 47% 8,403,811 6,704,117 1,699,694
NET (Resources - Requirements) 112,868 799,754 686,886 392,509 392,509
Beginning NWC per Requested Budget 392,509
a) Was due last fiscal year but received in FY 2010.
b) Due April 15, 2010.
c) This is largely construction waste and has not picked back up as yet.
d) Rate increase went into effect January 1, 2010.
e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year.
f) Capital item purchases are spread out throughout the fiscal year.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714
Revenues
State Grant 37,850 37,850 67% n/a a) 37,850 37,850
Miscellaneous 20,000 17,108 (2,892) 67% 57% 30,000 26,210 (3,790)
Franchise 3% Fees 133,333 85,449 (47,884) 67% 43% b) 200,000 200,000
Commercial Disp. Fees 930,933 570,546 (360,387) 67% 41% c) 1,396,400 892,739 (503,661)
Private Disposal Fees 1,027,533 901,816 (125,717) 67% 59% 1,541,300 1,385,323 (155,977)
Franchise Disposal Fees 3,162,333 2,575,956 (586,377) 67% 54% d) 4,743,500 3,856,124 (887,376)
Yard Debris 50,000 44,056 (5,944) 67% 59% 75,000 71,642 (3,358)
Special Waste 20,000 14,486 (5,514) 67% 48% 30,000 24,433 (5,567)
Interest 9,333 9,301 (32) 67% 66% 14,000 12,500 (1,500)
Sale of Carbon Credits - 67% n/a 100,000 100,000
Sale of Equip & Material 23,333 20,041 (3,292) 67% 57% 35,000 23,480 (11,520)
Total Revenues 5,376,798 4,276,609 (1,100,189) 67% 53% 8,065,200 6,630,301 (1,434,899)
TOTAL RESOURCES 5,715,409 4,742,934 (972,475) 67% 56% 8,403,811 7,096,626 (1,307,185)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,175,719 1,127,340 48,379 67% 64% 1,763,578 1,706,334 57,244
2,498,836 2,018,486 480,350 67% 54% e) 3,748,254 3,266,991 481,263
645,843 405,019 240,824 67% 42% 968,765 968,765
99,333 38,051 61,282 67% 26% f) 149,000 53,460 95,540
959,845 354,284 605,561 67% 25% 1,439,767 708,567 731,200
222,965 222,965 67% n/a 334,447 334,447
TOTAL REQUIREMENTS 5,602,541 3,943,180 1,659,361 67% 47% 8,403,811 6,704,117 1,699,694
NET (Resources - Requirements) 112,868 799,754 686,886 392,509 392,509
Beginning NWC per Requested Budget 392,509
a) Was due last fiscal year but received in FY 2010.
b) Due April 15, 2010.
c) This is largely construction waste and has not picked back up as yet.
d) Rate increase went into effect January 1, 2010.
e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year.
f) Capital item purchases are spread out throughout the fiscal year.
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
RISK MANAGEMENT
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
$2,491,977 $2,669,291 $177,314 100%
107% $2,491,977 $2,669,291 $177,314
General Liability 304,643 304,628 (15) 67% 67% 456,964 456,964
Property Damage 190,863 190,736 (127) 67% 67% 286,294 286,294
Vehicle 122,797 122,796 (1) 67% 67% 184,195 184,195
Workers' Compensation 570,569 570,560 (9) 67% 67% 855,854 855,854
Unemployment 106,794 106,802 8 67% 67% 160,191 160,191
Claims Reimb-Workers' Compensation 16,667 (16,667) 67% 0% 25,000 25,000
Claims Reimb-Gen Liab/Property 6,667 121,376 114,709 67% 1214% 10,000 125,000 115,0)0
Process Fee-Events/Parades 600 595 (5) 67% 66% 900 900
Miscellaneous 2,667 (22) (2,689) 67% -1% 4,000 4,000
Skid Car Training 14,667 10,570 (4,097) 67% 48% 22,000 22,000
Interest on Investments 20,000 24,263 4,263 67% 81% 30,000 30,000 -
TOTAL REVENUES 1,356,932 1,452,304 95,372 67% 71% 2,035,398 2,150,398 115,0)0
Transfers In -PERS Reserve 67 267) 67% 0% 100 (1 )0)
TOTAL RESOURCES 3,848,976 4,121,595 272,619 67% 91% 4,527,475 4,819,689 292,214
Appropriations/Expenditure s
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
% Exp.
59,284
974
307
144,381 a)
25
4,192
243,408 209,162 34,246 67% 57% 365,112 350,000 15,112
Insurance 135,996 a)
Repair / Replacement 121,684 b)
Total Property Damage 200,000 257,680 (57,680) 67% 86% 300,000 340,000 (40,000)
VEHICLE
Professional Service 1,095
Insurance 411
Loss Prevention 11,678
Repair / Replacement 78,717
Total Vehicle 80,000 91,900 (11,900) 67% 77% 120,000 110,000 10,000
WORKERS' COMPENSATION
Settlement / Benefit 460,288
Insurance 81,028
Loss Prevention 22,862
Miscellaneous 21,624
Total Workers' Compensation 413,333 585,802 (172,469) 67% 94% 620,000 800,000 (180,01/0)
UNEMPLOYMENT - Settlement/Benefits 93,333 170,808 (77,475) 67% 122% c) 140,000 200,000 (60,0110)
Total Direct Insurance Costs 1,030,075 1,315,352 (285,278) 67% 85% 1,545,112 1,800,000 (254,888)
Insurance Administration:
Personal Services 182,689 178,752 3,937 67% 65% 274,034 274,034
Materials & Service 164,329 123,046 41,283 67% 50% 246,493 246,493 -
Capital Outlay 67 67 67% 0% 100 - 100
Total Insurance Administration 347,085 301,798 45,287 67% 58% 520,627 520,527 100
Contingency 1,641,157 - 1,641,157 67% n/a 2,461,736 - 2,461,7;,6
TOTAL REQUIREMENTS 3,018,317 1,617,150 1,401,167 67% 36% 4,527,475 2,320,527 2,206,9' 8
NET 830,659 2,504,445 1,673,786 - 2,499,162 2,499,102
NWC per Requested Budget 2,500,000
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October.
b) Expenditures in property damage is offset by claims reimbursement revenue.
c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and
Health Services.
Year End
Budget
Projection
Varian ;e
107% $2,491,977 $2,669,291 $177,314
General Liability 304,643 304,628 (15) 67% 67% 456,964 456,964
Property Damage 190,863 190,736 (127) 67% 67% 286,294 286,294
Vehicle 122,797 122,796 (1) 67% 67% 184,195 184,195
Workers' Compensation 570,569 570,560 (9) 67% 67% 855,854 855,854
Unemployment 106,794 106,802 8 67% 67% 160,191 160,191
Claims Reimb-Workers' Compensation 16,667 (16,667) 67% 0% 25,000 25,000
Claims Reimb-Gen Liab/Property 6,667 121,376 114,709 67% 1214% 10,000 125,000 115,0)0
Process Fee-Events/Parades 600 595 (5) 67% 66% 900 900
Miscellaneous 2,667 (22) (2,689) 67% -1% 4,000 4,000
Skid Car Training 14,667 10,570 (4,097) 67% 48% 22,000 22,000
Interest on Investments 20,000 24,263 4,263 67% 81% 30,000 30,000 -
TOTAL REVENUES 1,356,932 1,452,304 95,372 67% 71% 2,035,398 2,150,398 115,0)0
Transfers In -PERS Reserve 67 267) 67% 0% 100 (1 )0)
TOTAL RESOURCES 3,848,976 4,121,595 272,619 67% 91% 4,527,475 4,819,689 292,214
Appropriations/Expenditure s
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
% Exp.
59,284
974
307
144,381 a)
25
4,192
243,408 209,162 34,246 67% 57% 365,112 350,000 15,112
Insurance 135,996 a)
Repair / Replacement 121,684 b)
Total Property Damage 200,000 257,680 (57,680) 67% 86% 300,000 340,000 (40,000)
VEHICLE
Professional Service 1,095
Insurance 411
Loss Prevention 11,678
Repair / Replacement 78,717
Total Vehicle 80,000 91,900 (11,900) 67% 77% 120,000 110,000 10,000
WORKERS' COMPENSATION
Settlement / Benefit 460,288
Insurance 81,028
Loss Prevention 22,862
Miscellaneous 21,624
Total Workers' Compensation 413,333 585,802 (172,469) 67% 94% 620,000 800,000 (180,01/0)
UNEMPLOYMENT - Settlement/Benefits 93,333 170,808 (77,475) 67% 122% c) 140,000 200,000 (60,0110)
Total Direct Insurance Costs 1,030,075 1,315,352 (285,278) 67% 85% 1,545,112 1,800,000 (254,888)
Insurance Administration:
Personal Services 182,689 178,752 3,937 67% 65% 274,034 274,034
Materials & Service 164,329 123,046 41,283 67% 50% 246,493 246,493 -
Capital Outlay 67 67 67% 0% 100 - 100
Total Insurance Administration 347,085 301,798 45,287 67% 58% 520,627 520,527 100
Contingency 1,641,157 - 1,641,157 67% n/a 2,461,736 - 2,461,7;,6
TOTAL REQUIREMENTS 3,018,317 1,617,150 1,401,167 67% 36% 4,527,475 2,320,527 2,206,9' 8
NET 830,659 2,504,445 1,673,786 - 2,499,162 2,499,102
NWC per Requested Budget 2,500,000
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October.
b) Expenditures in property damage is offset by claims reimbursement revenue.
c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and
Health Services.
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $5,137,000 $ 5,611,168 $ 474,168 100% 109% $5,137,000 $5,611,168 $ 474,168
Revenues
Property Taxes - Current 4,087,188 5,860,612 1,773,424 67% 96% a) 6,130,782
Property Taxes - Prior 66,667 246,254 179,587 67% 246% a) 100,000
State Reimbursement 16,333 4,048 (12,285) 67% 17% b) 24,500
Telephone User Tax 357,333 418,350 61,017 67% 78% 536,000
Data Network Reimb. 22,667 26,032 3,365 67% 77% c) 34,000
Jefferson County 18,667 37,215 18,548 67% 133% 28,000
User Fee 40,333 51,388 11,055 67% 85% d) 60,500
Contract Payments 46,667 25,574 (21,093) 67% 37% e) 70,000
Miscellaneous 5,667 5,854 187 67% 69% 8,500
Interest 24,000 59,552 35,552 67% 165% 36,000
Interest on Unsegregated Tax 2,500 1,219 (1,281) 67% 33% 3,750
Total Revenues 4,688,022 6,736,098 2,048,076 67% 96%
Transfers In -Other 67
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
6,208,795 78,013
270,275 170,275
6,000 (18,500)
536,000
27,880 (6,120)
37,215 9,215
60,500
26,000 (44,000)
8,500
75,000 39,000
3,750
7,032,032
7,259,915 227,883
(67) 67% 0% 100 (100)
9,825,022 12,347,266 2,522,244 67% 101% 12,169,132 12,871,083 701,951
% Exp.
2,544,191 2,315,784 228,407 67% 61% 3,816,287 3,606,287 210,000
859,681 622,184 237,497 67% 48% 1,289,522 1,289,522
116,667 13,830 102,837 67% 8% 175,000 175,000
1,292,626 1,292,626 67% 0% 1,938,939 1,938,939
3,299,589 3,299,589 67% n/a 4,949,384 4,949,384
TOTAL REQUIREMENTS 8,112,754 2,951,798 5,160,956 67% 24% 12,169,132 7,009,748 5,159,384
NET (Resources - Requirements) 1,712,268 9,395,468 7,683,200 5,861,335 5,861,335
Beginning NWC per Requested Budget 5,861,335
a) Projection based on actual collections through November 30, 2009.
b) Less activity being performed.
c) Annual billings.
d) 12% of collections came from an unanticipated/temporary COIDC contract: 4/1/09-11/30/09
e) Less contract activity with law enforcement agencies.
Health Benefits Trust
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Budget *
Year End
Projection Variance
RESOURCES
Beg. Net Working Capital $ 17,894,797 $ 17,894,797 $ (0) 100% 100% $17,894,797 $ 17,894,797 $ (0)
Revenues:
Internal Premium Charges 6,986,667 6,989,180 2,513 67% 67% a) 10,480,000 10,480,000
P/T Emp - Add'I Prem 36,667 30,338 (6,329) 67% 55% 55,000 55,000
Employee Prem Contribution 220,000 226,765 6,765 67% 69% 330,000 330,000
COIC 666,667 734,424 67,757 67% 73% 1,000,000 1,070,000 70,000
Retiree / COBRA Co -Pay 333,333 403,366 70,032 67% 81% 500,000 565,000 65,000
Prescription Rebates 12,389 12,389 67% n/a 12,389 12,389
Interest 150,000 154,369 4,369 67% 69% 225,000 225,000
Total Revenues 8,393,333 8,550,831 157,497 67% 68% 12,590,000 12,737,389 147,389
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Conferences and Seminars
Claims Paid-Medical/Rx
Claims Paid-Dental/Vision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Printing
Program Supplies
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
26,288,130 26,445,627 157,497 92% 87% 30,484,797 30,632,186 147,389
72,865 69,165
Exp. %
3,700 67% 63%
109,297 109,297
2,000 530 1,470 67% 18% 3,000 3,000
9,498,384 7,686,423 1,811,961 67% 54% b) 14,247,576 11,419,829 2,827,747
1,214,667 1,145,605 69,062 67% 63% b) 1,822,000 1,702,042 119,958
(60,834) 60,834 67% n/a (60,834) 60,834
248,360 248,443 (83) 67% 67% 372,540 372,540
7,667 68,989 (61,322) 67% n/a c) 11,500 11,500 -
195,176 260,804 (65,628) 67% 89% 292,764 292,764
54,432 25,046 29,386 67% 31% 81,648 81,648 -
33,048 33,120 (72) 67% 67% 49,572 49,572
6,667 2,047 4,620 67% 20% 10,000 10,000
66,667 1,239 65,428 67% 1% 100,000 100,000
19,373 18,435 938 67% 63% 29,059 29,059
11,346,439 9,429,846 1,916,593 67% 55% 17,019,659 14,011,119 3,008,540
- 67% 0% 100 100
8,903,827 8,903,827 67% 0% 13,355,741 3,355,741
20,323,131 9,499,011 10,824,120 67% 31% 30,484,797 14,120,416 16,364,381
5,964,999 16,946,616 10,981,617 16,511,770 '16,511,770
*Proposed revisions to FY 2010 original budget
Beginning NWC per Requested Budget
16,400,000
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Projection based on annualizing 35 weeks of claims paid. YTD actual is $250,606 per week.
c) Zurich to reimburse County $57,490 (5/6ths) of the $68,989 payment made in July for the July through December assessment.
O_
O CM
CVN O
Y
U-
m
0
0
c- O CD Ps O''A. (7'O) (O 'O �'O N O O O 0� —N r'. r N N
Ps 0 0 0 O, N:CO N O. O 'O r' O CO O O N Is O)'()'1
N c0",O m CD .00 O'er, ' M CO O,r t0 r r (A M V''. ' ' "V 7 (D 7 O 7
Ul v- C' V v V M'. (N<) N M .r. • r (0 V 7 r
r- �� V V r- O �N N
•
�N
'O 0 •0 0 0 O 0:0 O O O 0)',7 O M M O O' ' O a0 0) 'A'O, N'
_N N N
'CD 'CD O O O O'.0'O O O''O' CO'O 0'r- r' O N 'O O r- (D'O CV N N Ul
O •N O O O'O O''M O O''0 r OIs 7' 0) O 7' O' 0).r o'a a'O) 0) Cr).
Or- Tr NI 03 .r: iA Lc N NI <c 0) •.,-,_ c0 (0 O N c0 c0' r - N O'N c0 co
'O O a'N .01 7 00)) co M. cy .C1 41 V', r a0, O) N c0 CO v.)N N N
•
0) O M O' 'f) r 0)'O. 7 0) N e0 N O O,' CO.
N O M 0 (0 r (D O N '0 .7) O' tD M 0 0 c0 (D:O'O O ��pp•
N.
N. c0 ".0 O .•'7 O 01.41 • r' 00' ' (O O N O M 'A 0) x 0 0 0 )A •
,-.1:),-, .C, • 'N'(f)'0 00 7'O) '7, (O N M'M c0 •r N,0.0 O M r-
03 7 C N• 7 COT. Or (0 N, c 7 01'N:,N'o]0 r N
.- N CO
0),'f) O:O'O N to
0
0
O
0
7.3
0
0
a v v
o co (o
N N N
'
C
N
O O O0 (1) O' N', 0 *- v. (O' 'O N 0): N' M r
O O O O N. N 0): CO 0 t<) M O. r (f)'0) N CO
O M ' ' ' 'O O N ' M CO ' - M O. M O ' Tr c0, '1 t+), 0)
O. r.� O c0.7 t<) N O 0) U) 0.
N': N r CO Tr CO: V CO
'7
I -
(02
Q
0
2
O
O -0-3
d <
Y
0 0''0 O
Ul N o� O r '
O N I--
r
N OCO
' M r'
0)
O N: :O, CO cc)
N O)
'M 0' CO 'Cr O O CO: N
r CO O' N O' ' T'' N
07 'M 'r 0 �M C4 0.
O, 7': r : 7 Tr N
O 0 O O O O (O co
O O O O'N'M. M' 0 t+)' O (0
O ' ' 'CO CO O'. ' O'M7 r.01 Co V
0)m v
7 'V N (0. V'.
O N
CO r
O O OO O U)' O N N M' c0 O r O r O
«) O:. 'O. O O r C) C4 CO O, M: 0). (O 0 CO O N 0
Ps 01 4 O ' O O (n ' ti CO 'r M O', N ' ' 'O a) 'O M' O
V � N -O o' c0 Ti t<)' n 0) 'L) 0 N N
CO V N' CO V V (f) N (O
r. N
Cr)'. CO (1) 0) 0) 0) O) N. c0 t<) 7 N O O' cO Ul C) C4 C) C) Cl
N '00 Ul U) (O' 03 r c0 0) M O O (t) M c0 CO O O CO, IIs
s
' C rs V M' cO N r c0' ' 7 - N'O M r- O 0) 01 CD CD ' .(O N
M M - p)' c0 c0' 0 N M M 4) c0 '..— O o N O1
N. (n v' O O Ns r v v Ps 0) CO '00 CO (0
N 0 M O ([) N N
0
-LL
c0
co
co
d
E
0
O
C‘I CO 03
c0 cc-) nv V7 Tr
N' ' 0 ' r- M' O
.1. r CO- N
m Ul 0 OD
V ' co N
CO- 0i 'ri
CO M CO r
0 CO (OO
O O
O CO (L) N c0' O O (L) V) N O' O
Q' r-0) O N r: 7O N'. N 0
M N r r an N ' 0 .-.
0) 7', O
N O 7 0 CO
O 0 41.
O CO CO
•
O O M
0 N, O
(0 �:
'0 M M 0) 0' N 00
�'. r 'O 0)' V' ')
' w ' ' O ' ' (O O CO
Mm Tr
'c)
7'3
0
O' O O O O O O Is
7 Ns O CO) N' 7'(00 ' O M'
'n O co
O M r- 00 Co c0 CO,
UD: 0) rm 'CO 7
ao : r
CO ,M O
V
O 00 03 Is c0,0)'..
O O' 00 0) c0 0),.-
7 ' O. ' ' `Cr ' ' a' CO O M
'c0 0)' r-- N N 7 NS
(o co v
N
E
d
N
>'
0)
N
r' O
t<)
O
�'.
o.. r- CO
o ': «4)
o -moo
(0 n
N N 0I
(0cr
CO M 7 0) N r 'M 0 (0
N 'Cr (0.ct'O)
N ' ' ' ( ' ! r'.N ''O (O: ''. 0 t0
N CO
N CO 7 . O aMO
c0: O O
Cl r d'
N
r
O O., (00:
7'
O'M O'
O 0
O 0)' O
co 0
71�'': O:
O CO, CO' CO N O 4-
('4'O 0 O M 0 C0'
r N '.O: O N O 4'
cup O', CON1 V: Tr
CA
O'
E CM C1 c d' N o, 0, m,
> 'N t.9 ›' 0 O. U' 0111.,..
0
�, 7: N N �' C. (D �, Ct H 0,: W K N v: �I Oi 21°- -u' 1
o.
y d. 7 N'. 7. N.. d'L C 0) C 0 c,', ', >., C' W ; N �,� 7 C'.>`:+ �'L:
U, y'. > )) `j� — 0 O U' al
NI t`' K U N1 j '' '4C13 v' o LL N N' 0 )i' J >.'
k wcc � L �' o' a v d m <-50, all
o �''9 0 LL co F! i5 c N•
d E $!' w -c ox
W '"' .... 0 t°-
".2
2 2'l y (g 4 H'.w1-`21'5,- l I 15,
(:)..E.--„, ''. N in °-) a, °o °) c y :0
6. a) W>,I- I- CD U 1 U',>, -C.!21,2 m d'2:U o r Ili y:d ;LI t9
�,Q�! mI r c,
CL F- C c �' , '.Z'. 'U
LLO, 0 f- OmCC0 Oi 1 Z
RESOURCES:
Beg. Net Working Capital
Receipts:
Security & Traffic Reimb
Miscellaneous
Vending Machines
Telephone Fees - Events
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession % - Food
Rights (Signage, etc.)
Donations
Interfund Contract
Total Receipts
Deschutes County - Fair and Expo Center
YTD -Budget Basis
Statement of Financial Operating Data
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
Year End
Budget
Projection
Variance
$ 75,000 $ 42,232 $ (32,768) 100% 56% $ 75,000 $ 42,232 $ (32,768i
12,000 - (12,000) 67% 0% 12,000
2,338 3,659 1,321 67% 91% 4,000 5,321 1,321
1,150 1,319 169 67% 57% 2,300 2,469 169
600 (600) 67% 0% 1,200 600 (600
303,200 170,229 (132,971) 67% 32% 540,000 382,729 (157,271
1,330 (155) (1,485) 67% -8% 2,000 514 (1,486
44,000 13,418 (30,582) 67% 23% 58,000 42,033 (15,967
2,000 - (2,000) 67% 0% 7,000 5,000 (2,000,
2,000 1,185 (815) 67% 3% 45,000 44,185 (815
133,000 51,459 (81,541) 67% 22% 235,000 121,177 (113,823''
16,420 43,000 26,580 67% 50% 86,420 113,000 26,580
3,300 3,300 67% n/a 3,300 3,300
- 67% 0% 45,000 45,000 -
518,038 287,414 (230,624) 67% 28% 1,037,920 765,328 (272,592)
Transfers In
General Fund 99,000 98,960 (40) 67% 50% 197,919 197,919
Transient Room Tax 11,383 11,382 (1) 67% 50% 22,765 22,765
Welcome Center 80,000 80,000 - 67% 100% 80,000 80,000 -
County Fair (619) 197,421 80,000 (117,421) 67% 41% a) 197,421 80,000 (117,421;
F & E Reserve (617) 67% n/a c) - 250,000 250,000
Total Transfers In 387,804 270,342 (117,462) 498,105 630,684 132,579
TOTAL RESOURCES 980,842 599,987 (380,855) 67% 37% 1,611,025 1,438,244 (172,781)
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfer to Reserve Fund (617)
Contingency
Exp. %
549,792 509,787 40,005 67% 62% 824,769 784,709 40,060
354,216 306,676 47,540 67% 58% b) 531,604 509,892 21,712
79,393 73,035 6,358 67% 63% 116,188 116,188
- 67% 0% 100 - 100
67% 0% c) 16,412 16,412
- 67% n/a 121,952 121,952
TOTAL REQUIREMENTS 983,401 889,498 93,903 67% 55% 1,611,025 1,410,789 200,236
NET (Resources - Requirements) (2,559) (289,511) (286,952)
27,455 27,455
a) Transfer from Annual County Fair fund will be $112,303 less than budgeted.
b) It is likely that M & S will be less than what is currently projected.
c) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund.
Accrued Revenue (Accounts Receivable):
Current Month Events 12,577
Prior Months 10,267
Total Accounts Receivable 22,843
Deposits Received for Future Events:
2010:
March 14,977
April 6,375
May 5,965
June 1,540
FY 2011
July 32,370
August 180
September 1,200
October 1,800
November 4,550
December 275
February 300
March 250
April 1,000
May 600
FY 2012 & beyond 6,550
TOTAL 77,932
PROJECTION
U
C)
Q
(I) N
O C
CV
N E
0
E
s-
0
c
W 05
Received and
O
0
C
0
0
X
W
RESOURCES:
0) '
f- O
4 co)
O) co)
4 co- N
N r M
O CD
O O O
O co) O
O O O
co 4 C1
N r M
O CO
fs M e-
• c0 CO
1:
to r CO
N r M
O C
co e-
CY) CO CO
rf N h
N r M
O CD'
cn
O
U
U
N
0
O
O
C
vi 8
C)
O O
U O
N
O y
CE 75 ce
`? fC
0 002
CD) ' o
N.: Ln
d
r-4
°r0 0
r,
O co co O r 4 co) r o0 r--
co
`00 co 0 0 I` CO M O ti O C)
cl' 0 0 O r 0 co f- 1.0 N
cP V L[) O LC) 00 r
C
Li)
CO i• f0) o Ns 0 0
O ' 00) ' OO
O 4 O U) O r
co co c- co co)
O
O
N
• ct M N a0 r" M r 00 I`
00 co O O r CO co co) Imo- O O)
ct O O 4 co r 0 r lam- Ln N
ct I` to O O ti r 00
M r M f�
Ln r
71- V CO N CO r M r CO N`
N M C) O r 00 M O N- O O)
CO O O 71- M r O r= UI
✓ N- O O O- ti r o r
00 r M N-
�
O
O
M
d'
01
M
M
O
co
CO
CO
0)
Co
O
N
Co
1)
N 0
V
N 0 0
M COO O
CO N 4
M71- N
N
a)
N
O
O
N
M
M
O
O
ti
O
O
O
O
O
0)
M
co'
O
M
10
Ln
Ln
rn
N
C0
M
e—
C0
ti
N
N
717N
N
03
d' COO CO
CO O h
O Q) 00
1.0 CO h
N-
r...) .-. >
i
(� Z O V) C LC
C Q U a) �+
0 7
cu QN) 0T > Cn c a)O
Vi ' O ▪ O m 7 f4 O >
W i m v co w 0- C U ▪ -0 0 c
• a O L E O U C CD °) a'Q,
cts N _ f3
i" ajs V in O) 0 U O 'u) i O CO a) O V
Q Cn y O O C C C CA U O.
Z .� L ,C .0 a j N .� AO U N C
Ill
U C� in (U O> C y ALO. C
X coQLUi-E G. cu_<o.. WO 2ZO�O
W Z U
Total Expenditures
0
Z
Amount Paid
C
0
0.
U
0
CO CO
Ci) 1.0
C') Cn CO
CO CO N
� � r
LO
CO
O
N I.
co O co
0) O 0)
r C7
CO �
LCA Architects
LCA Architects
Total Architect
Cn '
CO
CO
C'•)
O N N 0 N N N. LO N N 0 CO N 0 In N O
O Imo- co N O co LO CO 0) Cr)
CO O CO I. CD CO 0) I. 0) LC) 0) LC) O O
O N N d' Cn - O O CO CO Cr)
N CO N N CO CO N N
O
Industrial Control Panel for pump station (66% of $22,500)
Powers of Automation
0)
coCfl to
coco
10
in ER_ p
ti N
QO p O o
cp co co
ON-• Cr
O
Cn o co
o Co N .1.:4"..):1-
t (U
co
moo a^N^
O Ooc ,2O OCOrCOi C
tri
N ,,) � o o p o
0) O CO U% ` E ' N 0) o - o
Cr) O to 08 2 E O ER O
O co 15
COO 0_ Q TC
ea ,CO
O \ea O Cn o
NEfO v) C C Cn O CO
SU �� cN CO p 5 0 4O U
45 ,5•.' COC
p
�7 o CO >+ C C U co C\ N CD co O
OO co O= O O `p 0 •2 co (0 p N U
U N co O cn 4-
Ui ,c.:., V N C) c C O
p CT «- C O Y
COO as ` N N O O L v`-
a c ��QQQ=21i�OcnO��Q
E 0) co e-- N Cr)O Cp 1...."0) O T- N Cr) In
Tomco Electric
Engineered Structures Inc
co
O
O
O
O
co
Total Change Orders
O
O
O
N
CO
Total Engineered Structures, Inc.
O
0)
O
CO
co
Total Encumbrances & Commitments
PROJECTION
Encumbrances
& Commitments
Received and
0
C
a)
a
X
W
RESOURCES:
CO CO 0) 0
r` N CO 0
N. d' 00 O
CO- 0) CO LO
-
Lc) 0) N CO
N CO '7t'
M N
O CO 0) 0
O N CO 0
0 O
O 0) a0 O
O 0) N CO
N CO [t
CO- N
Transfer In -911 Fund 705 / 710
N
`)
a)
co
M
O
f0
O
N
O
N
1•
N
Total Resources
EXPENDITURES:
� O
A- N
N r
Ln
O
N
O CO CO 0 N. '1' 0 0 d CV O 0
001030c01.000 u) O 00
O d O r r N 0 N O 0
N.- r CO- N O N r r 71'7 ‘-
CO
O O N 0) O
N r`
O N-
O A-N
O 0
0 0
0 0
O O
O O
CO N CO 0 0 d• 0 CO d' N L)
0) r- 00 r CO LC) 0 CO LC) CO Cr
A- 0) [f 0) CO r N 0 [f N L()
A-
N. M O N A-
N
N ' '
N
0) N (5:3 0 0 Cr 0 CO 'Cr NLn
co <- CO r co LC) 0 O 1.0 O '7t'
01 0) [t 0) (9 r N l() d• N O
M r: M O N r C1
t- 0)
N
N O
1.0 O
CO
O
N
CO
M
0)
0)
M
0)
N
NA-
N:
N
0)
CO
O
N
CO
Total Materials & Services
CO
0 0 0 0 0 0
0 0 0 0 0 0
• O O O O
O r` O 16 O O
CO 0 CO CO CN d'
N N r N CO.
N r
N. 0 O O
N. ' 0 O O
O
0) CO N d•
O N CO.
CO- r
O
O
O
CO
N
N
CO
CO
O
O
O
eiii
tett
CD O
CO
CO
d'
r`
O
O
O
O
ti)
O
O
d
ti)
CO
N
N
CO
CO
CD -
LO O
A-
CO CO
O
CO
N
•D
t7
co
49 O
h O
C N-
C,
N
N
PROJECTION
O
1-
Encumbrances
& Commitments
Received and
RESOURCES:
CO
C')
CO N O CO
CO O Co)
N --C\100
C") N
N CO O 01
C" ) M
CDC -VON
O CO O CO
O N O N
O N Lr ti
In I-- CO co
N CO 0)
C* ) Co;
CO CO M
' O N -
cc) COC)
Co)
C7 Co;
Total Resources
EXPENDITURES:
Materials & Services
COCL00 �`CO
Ln
' �t ' ' f (NI ' •t N '
M NCr
O co CO O r O O N O
O0) c0 c000O BOO
O c N O
c) N O N
N U) N 0)
O O) O co O O O
O .:t ' O—' O O ' ' O
N N O O �
CO U) N U)
N
co N O O0) co_ O �t O a0 �t N U)
co) to CO
0) CO *- OCN ('410N C10
N- M CO N Ct
O)
N
I
O N CO co O C O co �t N in
CO op M In O CO U) CO �t
O 0) v CA CO N ct N 1n
C7 ti C7 CO N �t
N
10
(-t
N
�t
�t
co
CO
N
O)
M
co
C'')
0)
O)
M
O)
N
N
N
N
▪ O O
▪ O O
▪ �t O
r CO
lf) O co)
M N
N
CO
CO
�t
O
N
N
O
CO
O
N
a) 0)
O
N
to a)
O U
U .� E
y c) L
(o O Z 4) V) y co
C Q a5 C
• to O - > u)0 Q
O 4) O) Cis 7 % R CU 7.4
co• Q.
i L O y �+ •
LL. -p OL Q
t-- C CV 0 O E y V cc N 5 CV O- co
U CV C/) O) U O •,-,-, O - j 0 U- U
O C� C C C CL j; O) U
_ C 7 2 i.. C 'r. L s O U CV CV R
L i• n C t 7 0> c v 0 0 - •(o O
Q WI-�S CIi<0_WO~ cuZ0O~
U
CO
CO
CO
O
f`
0
ti
0
Total Expenditures
11
Z
Amount Paid
W Y
E C
O
E E
O <
U
O
a)
0) CI) O
U) N O
M CO N O
N N U)
I` O)
CO
U) c- O
N. U) N-
N
N N
°O O CO O
O '— O
O O O O
N N 0) O
U) r- CO U)
N N
Professional Services
LCA Architects
Reimb Exp (not to exceed)
LCA Architects
Total Architect
Interior modular walls
Herman Miller
O CO U) O N. CO O — O N. Cfl CO O N
U) C) C) Cfl M C) O) — O CO O) I` ti N
CO t O) M M d' O) O U) O O U) CO
I` e0 ,- N CO CO °O ,- d• O
I` Cl r- l— I—
CD
co Er
CO
O
O - U)
to c) co
N 0 1.6
t33 ti N O
O (0 p (n o
co zr
N N
N c -
U) O
Nd'
- c)
in
c) N.
0) CO
N M
N N.
N O)
Ul 01
°O N CO
M M c)
I` O U)
O Cfl O
U)
N N
o c ,r d' v
M a) M O_ N a)
C 6qv O ~ N O
O 0 0 O U
°O O C O °O 4-
c:;)
CO C
as
N r O a) U) O O O O
c) d' E N Cr; )- o L.
��
a co- o ,. o vM a
E co O CO O O N C
0) 69 Q— O ° E O
C1 O) 0 a) ,r-`- 4 a) O C U
O o ca .• N cA ° d' C «.'
ch
CO CA 0
C Q M .a U .. O C' c vI c O- Q)
a. o )
as M 7 U a) V 0 u) '� O)
O v V O c `•- w O a) C.- L 0
.�. (II cn a) al CO 10 0 O O O O
OC C _c 0 0 2 U .7 4) 0)
O c 13 CZ/ (AU 2 E 2 T ET_ c
T.-3 E c mzQDLLO0)0 Nc) TS
Powers of Automation
Tomco Electric
Engineered Structures Inc
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
C
a)
U
a)
O
CD CD
Cr)(
N4 O N
D CO
U U N
O O 0
a
o u -
U —
O
Cll CO 0)O
C
F.
co
F --
a)
3
a)
cn
PROJECTION
co
C
LL
-J
U
Encumbrances
& Commitments
Received and
a)
0_
X
W
RESOURCES:
0 0 0 co
O co O O
co O co O
M O (NO
LO LC)
LO
co a
u)
O
U
a)
U
cn
co
cn
O
ui
O
a)
U
O
0_
C
co
O
J
o cD
O ' (D
O L)
t1)
o
o ' O
O to
Loti
State Grant
O
O
O
LC)
N
O
N
N
0
a) u)
D CD
C ti
a) ‘i•
C 4) 0
CC
4
C io
O
C
EXPENDITURES:
Materials & Services
CO 0 0 (3)
CO v 0
to (O0 ti
O CO CO.
ot)
O O)
0 N
O
(0000)(f) - Q ACO
M O CD O O to 0 O
ID CD O N- Cr) N O CA O O
N O (70 Cil O O N N
N N
r r
0 0 0 M r 0 0 (0
00 0 ' CM N 0 0 O
N. O) N (C) O cD N
O O 0 0) N N- (A — N O) O
CO ' O — CD M (C) U) co O)
to co O i- co T r CA r CP
N r- CO co" I.) CO (A N
CO N N
CO 0 CP N f� O) N O) O
M CD CO to to CO — CA
LO CO ' cam- co v r CA r O
U) CO CA N
CO N N
to
lf)
tis
Cr)
Cr)
0
to
)
U)
CA
(0
N
O
N
0 0
0 0
O
x-
tox -
co
O
co
O
To be determined
Total Capital Outlay
Transfer Out
o
o
O
0)
co
O
O
M
rn
CT
O
O)
co
co
N
CA
a) _
E v
a
U
a)
Q j
u
u) u)
co a)
2
a)cn
O
E )
f >,
a
ti 0
N O
,j) U
6 0
CD-
cn �.'
co 7
N c6
0 C1
U II
CCo 1cn
.=
a) C
Co
0 (I) 7
Co N
E aa) a)
(-8
O O
cn
D O
O U
O O
LO 1.5 0
N- C N
a) (fl
E
E ' 0
a) U
0. 0. •5
O O
O
O Q
¢
N
to 2 Q
N
�2 0
10_fl
c0 a
Amount Paid
O
C
N
O O
CD 0
O O
O 1` -
ti
O
co
0
ti
. O O O
OOO
CO O O LO
COCO O N-
N
M
O co co co co
LC) co co co co
co ix) 0 O t!)
M LO Cfl O N
N N CO
CD
O
0
X
CD
0
0
C
cn
co co to +0
CU C
U
Q ` O C
O Cn ) ) U
cm O O C
O c C 5, O
‘-3 ` 0 — (/) '-r—,
a)U N as N 2
.0 E C
��cu0c
QCK WJcn<U
Pinnacle Architecture
Pinnacle Architecture
Pinnacle Architecture
Pinnacle Architecture
O_
O
1_
HSW Builders
Deschutes County
Bethlehem Inn (Fund 128)
Eight Months Ended February 28, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% a) $ (2,666,469) $ (2,689,172) $ (22,703)
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
TOTAL REQUIREMENTS
2,766,469
2,766,469
- (2,766,469) 67% 0% 2,766,469 - (2,766,469)
- (2,766,469) 67% 0% 2,766,469 - (2,766,469)
100,000 (2,689,172) (2,789,172) 67% -2689% 100,000 (2,689,172) (2,789,172)
Exp. %
100,000 24,355 75,645 67% 24% b) 100,000 35,000 65,000
100,000 24,355 75,645 67% 24% 100,000 35,000 65,000
NET (Resources - Requirements) - (2,713,526) (2,713,526)
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) February interest expense was $2,220.82.
- (2,724,172) (2,724,172)
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% a) $ (2,666,469) $ (2,689,172) $ (22,703)
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
TOTAL REQUIREMENTS
2,766,469
2,766,469
- (2,766,469) 67% 0% 2,766,469 - (2,766,469)
- (2,766,469) 67% 0% 2,766,469 - (2,766,469)
100,000 (2,689,172) (2,789,172) 67% -2689% 100,000 (2,689,172) (2,789,172)
Exp. %
100,000 24,355 75,645 67% 24% b) 100,000 35,000 65,000
100,000 24,355 75,645 67% 24% 100,000 35,000 65,000
NET (Resources - Requirements) - (2,713,526) (2,713,526)
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) February interest expense was $2,220.82.
- (2,724,172) (2,724,172)
Deschutes County
Genera\GupportGerviceo-BODC
Confepenue/Seminar, Education/Training and Related Travel Expenditures
FY 2010
2/2G/2OiU
|
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
YTD
Total
Tammy Baney
-
Conf/Sem & Educ/Training -
- -
350
-
| - -
350
Travel Meals -
-
-
-
15
20
90 -
20
145
Accommodations -
-
595
-
- -
77
072
Airfare -
- -
-
-
' - -
-
'
Mileage reimbursement -
256 86
573
299
396 68
1 386
2.062
GroundTronoport/Porking ! __�__
- � -
45
__�__
| __�__ -
�
| 45
Total Baney
256 86
1,578
319
486 66
_____
483
3,273
Dennis Luke
�
1
Conf/Sem & Educ/Training -
- -
350
-
220 -
-
! 570
TravelMeals � ---
25 �
� 25
� 113
25
� 57
� '4G
^
Accommodations -
� 77 | -
452
. 116
! 77 ! -
154
875
Airfare-
- -
-
-
- -
-
.
Mileage reimbursement -
329 ! 85
257
. 485
210 -
| 361
-1.T28
Ground Tra�� -
----_
� - -
----_�
34
-
- -
� -
34
TotalLuke 1 -
432 85
1.1187
714
----_
507 -
572
3,453
°wmnUw _nm�r
'Unger
�
---
Conf/Sem & Educ/Training -
- -
350
-
1 - -
-
;:t50
Travel Meals
-
-
-
- 50
-
50
Accommodations -
- -
624
-
651 -
-
1,276
Airfare -
- -
-
-
- -
-
Mileage reimbursement -
- -
-
1 -
' 978 -
-
978
Ground Transport/Parking -
- -
� 56
� -
� - -
-
� 56
----------'
�
TotalUnger '
� - -
----_|
I 1,031
------.
1 -
-----
| 1,630 50
-
----
2,711
Other -- - --� '�-
1
Conf/Sem & Educ/Training | -
- -
-
' -
| ' i -
300
| ;00
TotalOther -
' '(
-
-
| - '
300
:.00
Am
Total- BOCC Department '
1
Conf/Sem & Educ/Training -
| - -
700
-
! 220 -
300
1.570
TravelMeals -'
! 25
� 40
133
90 76
i��
77
� 442
~
Auuommodot no | -
r 77 -
._
1. O4O
116
' 77 -
� 231
2,E,232,E,23.
Airfare -
' '
-
-
- -
1 -
Mileage Reimbursement
L
-
| 585 172
- -
831
79
784
� -
806 66
- -
747
/ -
4.768
135
Ground Transport
Total - BOCC Department -
687 � 172
_�_
� 2,696
1,034
993
� 142
| 1,385
| 9,738��
FY 2010 Budget
22,750
�
1
!
[
�
�
��
PercentExpended
1
1
1 1
42 8%
!
�
|
1
| .
2/2G/2OiU