HomeMy WebLinkAboutFinance ReportMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
November 30, 2009
(1) Monthly Investment Report
(2) October 2009 Financials
Investment Income
Fiscal Year 2009-10 J
0
}
$ 138,057 $ 643,804
138,057 643,804
(6,903) (32,190)
Investment Income - Net I $ 131,154 $ 611,614 I
GI
9
U
0
II Investments By County Function
General $ 122,653,491
Total Investments $ 122,653,491
a
F-
auximaitawkidualluluL
=In
' eschutes ount4
0/31 201
r • - - i1 - . ' 77! • _lT7ii
0
0 0'
ooFEo
6 0
O CO O N O cri 0
CO C3) -
C'> CO . CC) . s --
o5
C) (O M .
7.
(.0 O L() N
'ct N r 00
05 O 0) U)
r- N CO
Ef3
a)
Q
o @
(6 Z
U
.` Q) t
O 2 a)
E o 0
E n E
O O
0 0 F-
U. S. Treasuries
O
0
( CC4
a) n
U
C
O
Q
(9 'a-)
a) Y
C
CL)
LL
LGIP/BOTC
122,653,491
69
Total Investments
t
c
0
2
c
0
L
U
d Q P
CO O O
C"7O C[)
T N T
• o
CO Cl
T T T
N
0
ca
1a1
a
E
0
U
O O O
1.0
Co Cr)N
O O O
Average Maturity in Days
u,
�n
0 0 0 0 0 0
o 0 LC) o u) CO 0
O O N N N N T
T l"'
Time Certificates
a)
Q cn
(9 a)
CL O
RS Z
m • �
E o
E Q -
o U 0
Total Portfolio: By Investment Types
U 3
k na
N 0
z
E
F
Market Value
O _O: O O' O O >.. O
_U U _U'._UI_U U _U U )U U U _U'. U'',U''._U U U U U U _U U U O
i m �' N N I M' In � U: m
Z Z.--2:-.21-2 Z'Z Z Z.Z Z'Z ZZ'Z Z Z Z'Z Z Z Z Z Z O X10 C)C' O g. Z N
1 O O OI O N E, E' 0
1
(0 N V' 0 N. '
00 Le) V C) N. V N' 0 0' 0 00 0 0 (0 ' 0 OV 0 0 0 00 �':0 0 0:0-'0:
N' C) V V O U)':1- LO .. O V CO U) C)1, N' O U) I O . co O O OO co O O , O: O O' co O
�'. V O U) Ti O (O U) (O'' (l O C) U): c0'',, of O: N. O N N O 00 O U) (O O O O N. 0: O O CD, O
U), O' ' CO 0, V N N: 0 N. N. (0 U)! cr 0 CO (O CO CO: (n CO (n N. 0, 0' 0 0' N. CO 0 0 O' 0
' U)'. U), U) -co N CO N CO CO 1- (O', I N OD 1-'V O'. (0 N co N CO V 0 0 O N. co O' O
0 C) N O N' O'. c U)'', co O O O, 0 d' N'I 1.0 co C) 1Z co:co. O. O O O V U) O. C) co
O 01 O. O V' O C) OI N 05 O, U): N': O O V O' C) O: co c'7. V U)'. O 00 c0 0 NI N co OI (O
•,-,,-, . O .— O.— O' 0 °I ,— O O'.— .—, O c3..- 0 0 0 O'I 0, O O �' O
N N N N V, N V N' V.- 0. 0. 0.,_ N N N N N N N N N N N
' c0 C)' N OI O O 0. 0' V V (`')'. O' CO' C) en O1 O. O 0: 0: 0 O, (O c0 O. O' O, OI O'. O, O CO 0
CIO V O': O . O O I C " U) V . co c., co cv c`') c) O' O c) c, c:, O U) N c) Q I O c) 0 0 0 co O
N R 0 0 0 0 O 00 '. O O C) O CO'. (n C) 0', V' O O. O N. O. O N O O', O O' 0, O O (O O I
O' co. C) O' O O' VI 00' C) (OI O. en C) .- OI O. 0' N' co en O'. 00 00 (OI O. (0(0(0(0 (0 V
V 1 N CO c, co U) �. c, O co O, —' ,t r-. OI N ', O,(O (0 f� , ',- (nc01(n'00 00I N C)'. N O 'fs-
0 C) N O N N O CI' ( Co, (n C) O CO- C) U) 0, U) (n CO (� ' .- O 0 1� U) 0' 0 0) 0 () (0-
0 OI 0 .- N 0''. 00 U)I CO. N O. d'' N' 0' .- U) �- O' N' .- 0 Oil 0: 0 0'.0) O
� O'', O. O 0 X 1 0 O O: O. CY O' .- ' C) O O O I O O,- O O. O OI OI O, O O O
N N N N ' V Cl' V Cl : d' N'' N N .-- N N N! N' Cl'': NI N ,- N N- N
0 0 0 0 0 0'. 0 0', C) 0 0 0. 0,010 : O O• c0'. O O O" O O O: O O O O I O O O c0 O
N co O O O' O O O O' co O O O O O O: O c,'. O O O O O O'. O O O O O O. O O O
O 0 0 0' O' O 0'' 0 0, co 0 0 c): 0 0' 0 0' N' O (0 O 0 0 0' 0 0 0 0 O. O: 0:N- O'
U 0: 0 O' CO CO CO' V 01 V O O C)C)I O 1 0' O O CO ((pp- N O N O' 0, 0 0 0 0: 0 O, O U)- O
O O. O N CO CV: c0 0'. (0 O_ O 011 C) O: O O' O' V (")'. 0) (O: c0 OI O' O O O 0' O' O. O V O
A 1 0 0' 0 (n, U) (0 O O' O O O OO O1 0 CO N. c0 01 0 0. O O O, O': O' O C)1
C O O! 0''. Tr, V co' V O' N O O O 01 O O 01 O O (OO O O O. O: O O' 01 o 0 V 1 OI
W 1� OI O. O' Or 00001. 00!x. O O C.)!0': 00 O' 0� 0 O 0'I O' O 0!. O,
N N N TF o4 V N TF �: N N NN N N1 N'. N: N;N1N N0
,(V'N
9 a)
_d A
c
0
0.
O
U
w
tti
O A
u re
0
O, 10
O A
Z'
Il0
ea �z.
W
ta67: a)
.5
3: Q
71.
LL'.
ro e e l e' e• e' e 0', 8' 0'
O • O' CD! CD: 0 O' C) O O OI OI 0 O''.O
O U) r -
U)': ': O O'. O. O OI cnI Opi O' O': V
• U) U)'. 001 U) U) U) U)1 ,t1 U) 0' In O
'C) N: C)IN N NII ���:N N C)
O',e e'l
0'o 0
O U) O• U) (0
' '
N. NI N,
U) C) V V •
e''ere e e 0 (0 e
o:(OI,o:O O O O!(o O
(1) N.. V' O. N O', C U)
U), CD! cr' N' O O: N 0-
U) 0 U) (n O 0
N. co N N co co
C) N C) co U)
' C) C) Ti Ti r-
e'', e'' e e 1' e e
OR eco
0 0110,0o'o1O O'm'O
C) O. O OI V'. co coO'. V OI
N 1 O', O O CO CO C) co' r--
0,1
N � N N N:'O O
OR o 0 \'.. e. o 0 0. e
o o 0 01010 O O 0
0 0 Tr U) O O''.O
O O O, CO' CO O U)' �
• N N N O.0 (1)I
d'.
• ' O C)
O (0 U) e') : 0
oi U) N c
O : O O 0L
E
x,00 U) �' :L
ear
N
e e e e L1
CD o 0 0 (I
ONO t` O N
O N of
N',
J
0
O E1
C �I
C c IwI m'.
a) 0 1 >' �I
I dlo m
' - a c E F
I(0• 10, 10 0) ' 01N- 0 N. N co' co. O O' N. 10 0. co V O, co. O O O, O' O' 00I N. N. N. -. O , N 0)> 2
V ((0p co N O'I co V C) (0co: V V V C) 1, 10 co V ON O Tr I in C) C) C): N 1 C) V V' O C) 11
N
In 0), C) N. (0': N C) N. C)11 (")I U) U) U) �'. U)', V 01 U) V U) 0-.U) to U) f-' fes' fes: I's! In to to In f. '1111 E C
010)0'' • 0 O OI O O O O O O 01i 0' O O O O O, O_ O 0I> 0
O 111' ,_ 00 (n', (n I �' N N OI O O V O. 41 fY: 0 O. N N C) (n O: m la I C (7
CV! C) 0— 0 — 01 O:— 0 0 N .— N. CI' O O O CO O N O.0 NIO N N'.N V
• �' N N N 01 COI r V N. N. N. c0. 00 00))1 O) O 0': O N', NI C) r) i',5'.4 V' - (O ' > 14.. (�.) O I
N,—• O. O', O O I O O O O'I O': O O O O I o''., o o C)! O. O, O' C)! O O O' O', Q I,. 0 0 m' 1'
O CO1 0 N. O' 0)' O' c0 0) CO OI 01. O 00 0 O OI OI O O O 0) 0) O! O 0) 0) 0) CD O 0) I O' O
O o10 O, OI O'Ol0 O O O 01.0'0!0 0 • U) f01V',- 0 O O O C) C' 00 0 0:01 0 O O10O'
�l.('7'Vl co N 1�:N O (O 0 N. U)1 0 0. 0' O 0) 1 0,0) �N. .N V, N: (n ', 0) O)
N O C) r- N N O N, O N O O CI N. N. N, ,. N N N O C) O N O 01 C) O N N. N
(n N N N .......
I V V (`h V V.- O N (O- m V (0 10 . (O 11: 11: N N CO CO 0' 0 0' 0 (0'.
0 x':0'.0 0 01.000 00l0l00 0 0 0 0 1- 0 00 0 0 0 0 0 0
t
C' ❑I'ala1zlz 01,0 0'0 0 0'010'.20 Q Q Z'Q"Q 01.0 ccccQ Q Q cc cc Zla'''
F- F- 1 LL LL U U F- F- F- F- F- F- F-' I- LL H LL LL U LL LL H H LL LL LL LL LL: LL LL c) LL
CO 0_ 'm a U I 0 a a 0_ UIm Q,m LL LLIZ LL caleaO u- ;I 2! .2 2! 2! 7,?Z Z Z1
J 7 LL' m'3 - ''0_'UIm m m 711 mJ m'0_ 23(n13,LL1LL7 0 u)10 0-v)I ci 0 ci(1) (1),
stment Descri
10 N C) O C) N (0 coI U) co C) C)'' V (0 V: O U)
F- ❑:' 0_100 Z'. F- o co 31 (n QQ J J CO'. (n LL. of v
Y F-''.-, Q1I F- 2 U ;:l
Y: ml 'O Q > > N:31
U :DI
N
O, z oI N, LL - U) O F-' Q: 1 co 2 Q Q O' '. >' 'I O
01
X X V CO
X X' X N X LL O O, X. X
CV
01 01 1. '' C) 1, C) C) C)- (O c) F— 00. (O O O C )'. ) C). 1 01
01 01
c7,8
co co N. co m' COCD M ) M ) C) M c7, c7, MMM M
cc
❑ 0 01
z 0 U1:I 0 1 U
0 0
0
tee: 0 v C -0 U U, 0-0p 0 . i0 0:
c10 0 o m o ''U �U ❑I ' m z Ulm
N N
0 C) ' 010 0) m .3 3,� ciP v m U te._
>h se 11 c U a) a) c U Y a) f° c LL o
a) cl(a CO o $ 15 �Io E E (°a)clE o a) m > a)
> cr m m coo m j c: o o Q o 1 m¢ E m m ac`s 0 2 I, n EM <1<l< 1<< 0 0 m c 2
mm m 127,31:2':g
(o m QQ 01 (0 v CO
O T O {LLrco
1 7 --_t
cL 1 E, Y c 1 c l— c ami c —I E J J
0-0 E 22,>: o: o o coco E. co -a co21, 0 2 2 o'LLI2I, E' o21 Z'Z'Z LLI LL12' oil- 11
V) J 7 LL I1 LL.>I F-; U1 m, CO m171 m'J': m LLL 2 LL LL 0 LL LL' 710 LL LL LL LL LL' LL. U O'I LLi
O
z
O
w
J
1LL03,-mz1>r00.LI <LLZa0
'.. m m'',U:2 JLL'LL' NI n 71:7'3'[0 U U'LL
wI
rn'. n. _ Q�
(0 :;'
ml N. "(;'11. ir-
d to to
< • -.F. co i m (C (C Z I To -- 1 O ,, N c9 a N. 0
0 0 -,0 w1 m (c.0,
-la i s E E' c:.,- i2 L' a N e E EL 6 a) F-
N x10 0.014m1aa)) 01 E,N U O O E(n
{--?_ .773 ]UULL1H7
m m''U 2J'LL N N
0
C •
m:
1'
Memorandum
Date: November 13, 2009
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find October 2009 financial reports for the following funds: General
(001), Community Justice—Juvenile (230), Sheriffs (255, 701, 702), Public Health
(259), Behavioral Health (275), Community Development (295), Road (325),
Community Justice — Adult (355), Commission on Children & Families (370-399),
Solid Waste (610), Insurance Fund (670), 9-1-1 (705) 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
Four Months Ended October 31, 2009
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 6,607,616 2,631,068 (3,976,548) 33% 13% a) 19,822,847 19,822,847
Gen. Rev. - excl. Taxes 973,821 1,569,227 595,406 33% 54% b) 2,921,462 2,921,462
Assessor 273,568 423,103 149,535 33% 52% c) 820,704 820,704
County Clerk 347,724 480,640 132,916 33% 46% d) 1,043,171 1,193,171 150,000
BOPTA 4,597 8,208 3,611 33% 60% c) 13,791 13,791
District Attorney 110,933 89,105 (21,828) 33% 27% 332,800 332,800
Finance/Tax 62,350 108,969 46,619 33% 58% c) 187,049 187,049
Veterans 23,397 (23,397) 33% 0% e) 70,192 70,192
Property Management 28,817 28,817 - 33% 33% 86,450 86,450
Grant Projects 667 667 33% 33% 2,000 2,000
Total Revenues 8,433,490 5,339,804 (3,093,686) 33% 21% 25,300,466 25,450,466 150,000
TOTAL RESOURCES 14,483,490 12,115,799 (2,367,691) 33% 39% 31,350,466 32,226,461 875,995
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Exp.
1,096,877 1,021,502 75,375 33% 31% 3,290,631 3,290,631
486,901 415,125 71,776 33% 28% 1,460,704 1,460,704
19,903 17,917 1,986 33% 30% 59,708 59,708
1,529,088 1,453,556 75,532 33% 32% 4,587,263 4,587,263 -
248,824 258,639 (9,815) 33% 35% f) 746,471 746,471
75,234 71,554 3,680 33% 32% 225,701 225,701
79,895 77,126 2,769 33% 32% 239,685 239,685
35,224 33,806 1,418 33% 32% 105,673 105,673
537,669 246,551 291,118 33% 15% 1,613,006 1,493,006 120,000
2,031,571 2,031,571 33% 0% 6,094,713 6,094,713
6,141,186 3,595,776 2,545,410 33% 20% 18,423,555 12,208,842 6,214,713
Transfers Out 4,308,970 4,127,630 181,340 33% 32% 12,926,911 12,926,911
TOTAL REQUIREMENTS 10,450,156 7,723,406 2,726,750 33% 25% 31,350,466 25,135,753 6,214,713
NET (Resources - Requirements) 4,033,334 4,392,393 359,059 - 7,090,708 7,090,708
a) Approximately 85% of the property taxes are collected in October and November
b) Includes annual PILT payment of $467,230.
c) Includes 2 quarters of A & T Grant: Assessor -$415,093, Tax -$97,761 and BOPTA -$8,208.
d) Significant foreclosure and refinancing recordings.
e) 1st quarter payment ($15,827) received in November. 2nd quarter will be received in Nov or Dec.
f) 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 6,607,616 2,631,068 (3,976,548) 33% 13% a) 19,822,847 19,822,847
Gen. Rev. - excl. Taxes 973,821 1,569,227 595,406 33% 54% b) 2,921,462 2,921,462
Assessor 273,568 423,103 149,535 33% 52% c) 820,704 820,704
County Clerk 347,724 480,640 132,916 33% 46% d) 1,043,171 1,193,171 150,000
BOPTA 4,597 8,208 3,611 33% 60% c) 13,791 13,791
District Attorney 110,933 89,105 (21,828) 33% 27% 332,800 332,800
Finance/Tax 62,350 108,969 46,619 33% 58% c) 187,049 187,049
Veterans 23,397 (23,397) 33% 0% e) 70,192 70,192
Property Management 28,817 28,817 - 33% 33% 86,450 86,450
Grant Projects 667 667 33% 33% 2,000 2,000
Total Revenues 8,433,490 5,339,804 (3,093,686) 33% 21% 25,300,466 25,450,466 150,000
TOTAL RESOURCES 14,483,490 12,115,799 (2,367,691) 33% 39% 31,350,466 32,226,461 875,995
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Exp.
1,096,877 1,021,502 75,375 33% 31% 3,290,631 3,290,631
486,901 415,125 71,776 33% 28% 1,460,704 1,460,704
19,903 17,917 1,986 33% 30% 59,708 59,708
1,529,088 1,453,556 75,532 33% 32% 4,587,263 4,587,263 -
248,824 258,639 (9,815) 33% 35% f) 746,471 746,471
75,234 71,554 3,680 33% 32% 225,701 225,701
79,895 77,126 2,769 33% 32% 239,685 239,685
35,224 33,806 1,418 33% 32% 105,673 105,673
537,669 246,551 291,118 33% 15% 1,613,006 1,493,006 120,000
2,031,571 2,031,571 33% 0% 6,094,713 6,094,713
6,141,186 3,595,776 2,545,410 33% 20% 18,423,555 12,208,842 6,214,713
Transfers Out 4,308,970 4,127,630 181,340 33% 32% 12,926,911 12,926,911
TOTAL REQUIREMENTS 10,450,156 7,723,406 2,726,750 33% 25% 31,350,466 25,135,753 6,214,713
NET (Resources - Requirements) 4,033,334 4,392,393 359,059 - 7,090,708 7,090,708
a) Approximately 85% of the property taxes are collected in October and November
b) Includes annual PILT payment of $467,230.
c) Includes 2 quarters of A & T Grant: Assessor -$415,093, Tax -$97,761 and BOPTA -$8,208.
d) Significant foreclosure and refinancing recordings.
e) 1st quarter payment ($15,827) received in November. 2nd quarter will be received in Nov or Dec.
f) Year to date includes expenditures paid annually.
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
SB #1065 -Court Assess.
Discovery Fee
Food Subsidy
OYA Basic & Diversion
Inmate/Prisoner Housing
Inmate Commissary Fees
Contract Payments
Miscellaneous
MIP Diversion Fees
Interest on Investments
Leases
Grants - Private
CCF Interfund Grant
Crime Pry Svcs Interfnd Grnt
Total Revenues
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY%
-
CoII. %
$ 1,085,000
10,592
20,000
5,333
10,000
110,817
20,000
267
69,380
100
333
4,333
816
22,667
6,667
$ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
17,002
6,176
5,090
42,450
16,791
20
125
7,371
800
449
(10, 592)
(2,998)
843
(4,910)
(110,817)
22,450
(267)
(52,589)
(80)
(208)
3,038
(16)
449
(22,667)
(6,667)
281,305
Transfers In -General Fund 1,847,729
TOTAL RESOURCES 3,214,034
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Materials and Services
Capital Outlay
Juvenile Resource Center
Personal Services
Materials and Services
Capital Outlay
Contingency
96,274 (185,031)
1,847,728 (1)
3,144,043 (69,991)
33% 0% a) 31,775 47,995 16,220
33% 28% 60,000 60,000
39% 16,000 16,000
33% 17% b) 30,000 30,000
33% 0% c) 332,450 340,076 7,626
71% d) 60,000 120,000 60,000
33% 0% 800 800
33% 8% e) 208,141 104,000 (104,141)
33% 7% 300 300
33% 13% 1,000 1,000
13,000 18,000 5,000
33% 33% 2,448 2,448
n/a 449 449
33% n/a f) 68,000 68,000
33% 0% f) 20,000 20,000
33% 11% 843,914 829,068 (14,846)
33%
33%
33%
57%
33%
33%
33%
33% 5,543,186
42% 7,472,100
Exp. %
5,543,186
7,572,295 100,195
943,384 925,734 17,650 33% 33% 2,830,152 2,830,152
440,699 319,791 120,908 33% 24% g) 1,322,097 1,322,097
33 33 33% 0% 100 100
844,051
61,634
33
200,865
764,181
75,112
79,870 33%
(13,478) 33%
33 33%
200,865 33%
30% 2,532,154
41% h) 184,903
0% 100
n/a 602,594
2,532,154
184,903
100
602,594
TOTAL REQUIREMENTS 2,490,699 2,084,818 405,881 33% 28% 7,472,100 6,869,406 602,694
NET (Resources - Requirements) 723,335 1,059,225 335,890 - 702,889 702,889
a) Federal Grant projection increased for funds not spent in prior fiscal year. First quarter reimbursement expected in November.
b) Food Subsidy receipts are for July and August. September and October payments expected to be received in November.
c) OYA Basic and Diversion reimbursement delayed due to unavailability of reimbursement forms. Anticipate payment late November.
d) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
e) Actual BRS revenue received covers July -September. Projection reduced to reflect actual youth count at half of original estimate.
f) First quarter payments received in November.
g) Positive variance a result of accruals during July of June expenses for utilities, supplies, and contract payments.
h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention.
Year End
Budget
Projection
Variance
$ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
17,002
6,176
5,090
42,450
16,791
20
125
7,371
800
449
(10, 592)
(2,998)
843
(4,910)
(110,817)
22,450
(267)
(52,589)
(80)
(208)
3,038
(16)
449
(22,667)
(6,667)
281,305
Transfers In -General Fund 1,847,729
TOTAL RESOURCES 3,214,034
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Materials and Services
Capital Outlay
Juvenile Resource Center
Personal Services
Materials and Services
Capital Outlay
Contingency
96,274 (185,031)
1,847,728 (1)
3,144,043 (69,991)
33% 0% a) 31,775 47,995 16,220
33% 28% 60,000 60,000
39% 16,000 16,000
33% 17% b) 30,000 30,000
33% 0% c) 332,450 340,076 7,626
71% d) 60,000 120,000 60,000
33% 0% 800 800
33% 8% e) 208,141 104,000 (104,141)
33% 7% 300 300
33% 13% 1,000 1,000
13,000 18,000 5,000
33% 33% 2,448 2,448
n/a 449 449
33% n/a f) 68,000 68,000
33% 0% f) 20,000 20,000
33% 11% 843,914 829,068 (14,846)
33%
33%
33%
57%
33%
33%
33%
33% 5,543,186
42% 7,472,100
Exp. %
5,543,186
7,572,295 100,195
943,384 925,734 17,650 33% 33% 2,830,152 2,830,152
440,699 319,791 120,908 33% 24% g) 1,322,097 1,322,097
33 33 33% 0% 100 100
844,051
61,634
33
200,865
764,181
75,112
79,870 33%
(13,478) 33%
33 33%
200,865 33%
30% 2,532,154
41% h) 184,903
0% 100
n/a 602,594
2,532,154
184,903
100
602,594
TOTAL REQUIREMENTS 2,490,699 2,084,818 405,881 33% 28% 7,472,100 6,869,406 602,694
NET (Resources - Requirements) 723,335 1,059,225 335,890 - 702,889 702,889
a) Federal Grant projection increased for funds not spent in prior fiscal year. First quarter reimbursement expected in November.
b) Food Subsidy receipts are for July and August. September and October payments expected to be received in November.
c) OYA Basic and Diversion reimbursement delayed due to unavailability of reimbursement forms. Anticipate payment late November.
d) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
e) Actual BRS revenue received covers July -September. Projection reduced to reflect actual youth count at half of original estimate.
f) First quarter payments received in November.
g) Positive variance a result of accruals during July of June expenses for utilities, supplies, and contract payments.
h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention.
SHERIFF - Fund 255
Statement of Financial Operating Data
Four Months Ended October 31, 2009
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
6,747,645
4,239,107
$ 183,677 $ 183,677 100%
5,661,953
3,724,972
11,738
(1,085,692)
(514,135)
11,738
n/a $
$ 183,677 $ 183,677
33% 28% a) 20,242,936 17,263,761 (2,979,175)
33% 29% a) 12,717,322 11,295,156 1.1,422,166)
33% n/a - 35,000 35,000
10,986,752
TOTAL RESOURCES 10,986,752
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriff's Division 653,729
Civil 242,320
Automotive/Communications 465,961
Investigations/Evidence 560,776
Patrol/Civil/Comm Supp 2,524,192
Records 214,121
Adult Jail 3,014,971
Court Security 71,969
Emergency Services 62,690
Special Services Division 369,563
Regional Work Center 912,614
Training Division 100,018
Other Law Enforcement Svcs 175,901
Non -Departmental 154,348
Contingency 1,283,580
Transfers Out
9,398,663 (1,588,089) 33% 29% 32,960,258 28,593,917 (4,366,341)
9,582,340 (1,404,412) 33% 29% 32,960,258 28,777,594 (4,182,664)
679,126
231,647
544,455
504,120
2,370,398
195,220
2,620,533
62,816
54,498
393,584
764,503
93,559
188,390
21,016
(25,397) 33%
10,673 33%
(78,494) 33%
56,656 33%
153,794 33%
18,901 33%
394,438 33%
9,153 33%
8,192 33%
(24,021) 33%
148,111 33%
6,459 33%
(12,489) 33%
133,332
1,283,580 33%
33%
Exp. %
35%
32%
39% b)
30%
31% c)
30%
29% c)
29%
29%
35%
28% c)
31%
36%
5%
n/a
180,000 122,500 57,500 33% 23%
TOTAL REQUIREMENTS 10,986,753
NET (Resources - Requirements)
1,961,188
726,961
1,397,884
1,682,327
7,572,575
642,363
9,044,909
215,908
188,071
1,108,690
2,737,842
300,053
527,702
463,044
3,850,741
1,961,088 100
726,961
1,397,884
1,682,327
7,472,575 100,000
642,263 100
8,744,909 300,000
215,808 100
188,071
1,108,690
2,587,742 150,100
299,953 100
527,602 100
463,044
- 3,850,741
540,000 540,000
8,846,365 2,140,388 33% 27% 32,960,258 28,558,917 4,401,341
(1) 735,975 735,976
218,677 218,677
a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual.
b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System.
c) Unfilled open positions resulting in less than planned personnel expenses.
Year End
Budget
Projection
Jariance
n/a $
$ 183,677 $ 183,677
33% 28% a) 20,242,936 17,263,761 (2,979,175)
33% 29% a) 12,717,322 11,295,156 1.1,422,166)
33% n/a - 35,000 35,000
10,986,752
TOTAL RESOURCES 10,986,752
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriff's Division 653,729
Civil 242,320
Automotive/Communications 465,961
Investigations/Evidence 560,776
Patrol/Civil/Comm Supp 2,524,192
Records 214,121
Adult Jail 3,014,971
Court Security 71,969
Emergency Services 62,690
Special Services Division 369,563
Regional Work Center 912,614
Training Division 100,018
Other Law Enforcement Svcs 175,901
Non -Departmental 154,348
Contingency 1,283,580
Transfers Out
9,398,663 (1,588,089) 33% 29% 32,960,258 28,593,917 (4,366,341)
9,582,340 (1,404,412) 33% 29% 32,960,258 28,777,594 (4,182,664)
679,126
231,647
544,455
504,120
2,370,398
195,220
2,620,533
62,816
54,498
393,584
764,503
93,559
188,390
21,016
(25,397) 33%
10,673 33%
(78,494) 33%
56,656 33%
153,794 33%
18,901 33%
394,438 33%
9,153 33%
8,192 33%
(24,021) 33%
148,111 33%
6,459 33%
(12,489) 33%
133,332
1,283,580 33%
33%
Exp. %
35%
32%
39% b)
30%
31% c)
30%
29% c)
29%
29%
35%
28% c)
31%
36%
5%
n/a
180,000 122,500 57,500 33% 23%
TOTAL REQUIREMENTS 10,986,753
NET (Resources - Requirements)
1,961,188
726,961
1,397,884
1,682,327
7,572,575
642,363
9,044,909
215,908
188,071
1,108,690
2,737,842
300,053
527,702
463,044
3,850,741
1,961,088 100
726,961
1,397,884
1,682,327
7,472,575 100,000
642,263 100
8,744,909 300,000
215,808 100
188,071
1,108,690
2,587,742 150,100
299,953 100
527,602 100
463,044
- 3,850,741
540,000 540,000
8,846,365 2,140,388 33% 27% 32,960,258 28,558,917 4,401,341
(1) 735,975 735,976
218,677 218,677
a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual.
b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System.
c) Unfilled open positions resulting in less than planned personnel expenses.
SHERIFF 701
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII.
RESOURCES:
Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 33% n/a
Revenues
Tax Revenues - Current 4,939,901 1,503,048 (3,436,853) 33% 10% a) 14,819,703 14,819,703
Tax Revenues - Prior 166,667 459,153 292,486 33% 92% 500,000 500,000
Federal Grants 11,667 600 (11,067) 33% 2% 35,000 35,000
State Grant 15,052 18,563 3,511 33% 41% 45,156 45,156
Transp. of State Wards 1,667 (1,667) 33% 0% 5,000 5,000 -
SB 1145 573,731 987,330 413,599 33% 57% b) 1,721,192 1,935,336 214,144
Des. Cty Video Lottery Grant 1,667 (1,667) 33% n/a 5,000 5,000
Des Cty Court Security 43,000 42,850 (150) 33% 33% 129,000 129,000
Des Cty Juvenile Contract 1,000 (1,000) 33% 0% 3,000 3,000 -
Title III Reimbursement 50,000 - (50,000) 33% n/a 150,000 150,000 -
Transport 667 2,122 1,455 33% n/a 2,000 4,000 2,000
DC Fair & Expo Center 2,100 2,100 33% n/a 3,000 3,000
Inmate Commissary Fees 20,000 10,391 (9,609) 33% 17% 60,000 60,000 -
Work Center Work Crews 14,150 17,970 3,820 33% 42% 42,450 42,450
Concealed Handgun Classes 2,000 2,050 50 33% 34% 6,000 6,000
Soc Sec Incentive -Fed 1,667 3,800 2,133 33% 76% 5,000 5,000 -
Miscellaneous 1,333 808 (525) 33% 20% 4,000 4,000
Oregon Mentors 1,667 1,902 235 33% n/a 5,000 5,000
Medical Services Reimb 4,000 2,668 (1,332) 33% 22% 12,000 12,000
Restitution 350 604 254 33% 58% 1,050 1,050
Sheriff Fees 53,333 70,377 17,044 33% 44% 160,000 160,000 -
Interest 9,444 4,805 (4,639) 33% 17% 28,333 28,333 -
Interest on Unsegregated 1,178 733 (445) 33% 21% 3,533 3,533 -
Rentals 9,999 46,839 36,840 33% 156% c) 30,000 51,236 21,236
Donations - 50 50 33% n/a 50 50
Budget
Year End
Projection
Variance 1
$ 2,470,519 $ 3,343,461 $ 872,942
Total Revenues 5,924,140 3,178,763 (2,745,377) 33% 18% 17,772,417 18,012,847 240,430
TOTAL RESOURCES
8,394,659 6,522,224 (1,872,435) 33% 32% 20,242,936 21,356,308 1,113,372
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 6,747,646
Exp.
5,661,953 1,085,693 33% 28% d) 20,242,936 17,263,761 2,979,175
TOTAL REQUIREMENTS 6,747,646 5,661,953 1,085,693 33% 28% 20,242,936 17,263,761 2,979,175
NET (Resources - Requirements) 1,647,013 860,271 (786,742) - 4,092,547 4,092,547
a) Approximately 85% of the property taxes are collected in October and November.
b) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
c) FBI relocation from Sheriff's Office has been delayed resulting in 4 months of additional rental revenue.
d) Payment to Sheriff's Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual.
SHERIFF 702
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $1,287,473 $ 1,433,708 $ 146,235
Revenues
Tax Revenues - Current 2,413,233 736,367
Tax Revenues - Prior 79,667 233,474
Federal Grants 667 6,712
US Forest Service 25,500 12,750
State Grant 62,544 12,212
SB #1065 Court Assessment 22,333 17,002
Marine Board License Fee 41,489 -
Des Cty General Fund Grnt 287,721 10,000
Des Cty Transient Room Tax 595,612 595,612
City of Sisters 140,005 138,672
Des Cty Tax/Fin Contract 333 -
Des Cty CDD Contract 9,061 9,061
Des Cty Solid Waste Contr 27,183 27,182
Des Cty Clerk/Election 667 54
School Districts 33,333
Security & Traffic Reimb 4,333 2,871
Seat Belt Program 2,000 2,925
Miscellaneous 3,333 4,745
Sheriff Fees 1,667 4,070
Court Fines & Fees 28,333 38,833
Impound Fees 25,000 6,200
Restitution - Street Crimes 500
Seizure/Forfeiture 1,122
Interest 3,333 (908)
Interest on Unsegregated 600 359
Sale of Reportable Assets 6,779
Sale of Equip & Material 2,000
(1,676,866)
153,807
6,045
(12,750)
(50,332)
(5,331)
(41,489)
(277,721)
(1,333)
(333)
(1)
(613)
(33,333)
(1,462)
925
1,412
2,403
10,500
(18,800)
500
1,122
(4,241)
(241)
6,779
(2,000)
Total Revenues 3,809,947 1,866,594 (1,943,353)
TOTAL RESOURCES
5,097,420 3,300,302 (1,797,118)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 4,239,107
33% n/a
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
10% a)
98%
336% b)
17%
7%
25%
0%
1%
33%
33%
0%
33%
33%
3%
n/a
22%
49%
47%
81%
46%
8%
n/a
n/a
-9%
20%
n/a
0%
16%
c)
$ 1,287,473
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
$1,433,708 $ 146,235
7,239,702
239,000
10,000 8,000
76,500
187,633
67,000
124,468
863,163
1,786,837
416,016 (3,999)
1,000
27,183
81,548
2,000
100,000
13,000
6,000
10,000
5,000
85,000
75,000
500 500
2,500 2,500
10,000
1,800
10,000 10,000
6,000
11,429,849 11,446,850 17,001
33% 26% 12,717,322 12,880,558 163,236
Exp.
3,724,972 514,135 33% 29% d) 12,717,322 11,295,156 1,422,166
TOTAL REQUIREMENTS 4,239,107 3,724,972 514,135 33% 29% 12,717,322 11,295,156 1,422,166
NET (Resources - Requirements) 858,313 (424,670) (1,282,983)
- 1,585,402 1,585,402
a) Approximately 85% of the property taxes are collected in October and November.
b) HIDTA grant for drug enforcement overtime reimbursement will exceed plan for the year.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) Payment to Sheriff's Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual.
Year End
Budget
Projection
Variance
$ 1,287,473
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
$1,433,708 $ 146,235
7,239,702
239,000
10,000 8,000
76,500
187,633
67,000
124,468
863,163
1,786,837
416,016 (3,999)
1,000
27,183
81,548
2,000
100,000
13,000
6,000
10,000
5,000
85,000
75,000
500 500
2,500 2,500
10,000
1,800
10,000 10,000
6,000
11,429,849 11,446,850 17,001
33% 26% 12,717,322 12,880,558 163,236
Exp.
3,724,972 514,135 33% 29% d) 12,717,322 11,295,156 1,422,166
TOTAL REQUIREMENTS 4,239,107 3,724,972 514,135 33% 29% 12,717,322 11,295,156 1,422,166
NET (Resources - Requirements) 858,313 (424,670) (1,282,983)
- 1,585,402 1,585,402
a) Approximately 85% of the property taxes are collected in October and November.
b) HIDTA grant for drug enforcement overtime reimbursement will exceed plan for the year.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) Payment to Sheriff's Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual.
PUBLIC HEALTH
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll.
RESOURCES:
Beg. Net Working Capital $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355
Revenues
Medicare Reimbursement 1,333 (1,333) 33% 0% 4,000 4,000 -
State Grant 809,976 558,537 (251,439) 33% 23% a) 2,429,928 2,571,114 141,186
Child Dev & Rehab Center 11,579 - (11,579) 33% 0% 34,737 34,737
State Miscellaneous 71,080 77,821 6,741 33% 36% 213,240 213,240
OMAP 101,000 135,938 34,938 33% 45% 303,000 303,000
Family Planning Exp Proj 158,333 141,678 (16,655) 33% 30% b) 475,000 475,000
Grants 22,254 22,254 33% n/a c) 22,254 22,254
Patient Insurance Fees 44,600 43,107 (1,493) 33% 32% 133,800 133,800 -
Health Dept/Patient Fees 50,717 45,583 (5,134) 33% 30% 152,150 152,150 -
Vital Records -Birth 12,000 10,785 (1,215) 33% 30% 36,000 36,000
Vital Records -Death 32,667 32,975 308 33% 34% 98,000 98,000
Interest on Investments 12,667 6,410 (6,257) 33% 17% 38,000 38,000
Donations 2,933 2,394 (539) 33% 27% 8,800 8,800
Interfund Contract 43,925 (43,925) 33% 0% 131,774 131,774
Administrative Fee 9,000 9,000 - 33% 33% 27,000 27,000
Total Revenues 1,361,810 1,086,482 (275,328) 33% 27% 4,085,429 4,248,869 163,440
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)
8,333 - (8,333) 33% 0% 25,000 25,000
772,588 772,588 - 33% 33% 2,317,765 2,317,765
3,042,731 2,979,425 (54,973) 33% 41% 7,328,194 7,711,989 383,795
Exp. %
1,486,092 1,376,668 109,424 33% 31% a) 4,458,276 4,509,942 (51,666)
588,177 413,277 174,900 33% 23% a) 1,764,531 1,824,915 (60,384)
12,301 12,301 33% 0% 36,902 36,902
50,000 37,500 12,500 33% 25% 150,000 150,000
306,162 306,162 33% nla 918,485 918,485
2,442,732 1,827,445 615,287 33% 25% 7,328,194 6,521,759 806,435
599,999 1,151,980 560,314 - 1,190,230 1,190,230
a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 & 2. Grant appropriation for revisions in process.
b) Payments are received one month in arrears.
c) Grants for HIV and Chronic Care were not included in FY 2010 budget.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355
Revenues
Medicare Reimbursement 1,333 (1,333) 33% 0% 4,000 4,000 -
State Grant 809,976 558,537 (251,439) 33% 23% a) 2,429,928 2,571,114 141,186
Child Dev & Rehab Center 11,579 - (11,579) 33% 0% 34,737 34,737
State Miscellaneous 71,080 77,821 6,741 33% 36% 213,240 213,240
OMAP 101,000 135,938 34,938 33% 45% 303,000 303,000
Family Planning Exp Proj 158,333 141,678 (16,655) 33% 30% b) 475,000 475,000
Grants 22,254 22,254 33% n/a c) 22,254 22,254
Patient Insurance Fees 44,600 43,107 (1,493) 33% 32% 133,800 133,800 -
Health Dept/Patient Fees 50,717 45,583 (5,134) 33% 30% 152,150 152,150 -
Vital Records -Birth 12,000 10,785 (1,215) 33% 30% 36,000 36,000
Vital Records -Death 32,667 32,975 308 33% 34% 98,000 98,000
Interest on Investments 12,667 6,410 (6,257) 33% 17% 38,000 38,000
Donations 2,933 2,394 (539) 33% 27% 8,800 8,800
Interfund Contract 43,925 (43,925) 33% 0% 131,774 131,774
Administrative Fee 9,000 9,000 - 33% 33% 27,000 27,000
Total Revenues 1,361,810 1,086,482 (275,328) 33% 27% 4,085,429 4,248,869 163,440
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)
8,333 - (8,333) 33% 0% 25,000 25,000
772,588 772,588 - 33% 33% 2,317,765 2,317,765
3,042,731 2,979,425 (54,973) 33% 41% 7,328,194 7,711,989 383,795
Exp. %
1,486,092 1,376,668 109,424 33% 31% a) 4,458,276 4,509,942 (51,666)
588,177 413,277 174,900 33% 23% a) 1,764,531 1,824,915 (60,384)
12,301 12,301 33% 0% 36,902 36,902
50,000 37,500 12,500 33% 25% 150,000 150,000
306,162 306,162 33% nla 918,485 918,485
2,442,732 1,827,445 615,287 33% 25% 7,328,194 6,521,759 806,435
599,999 1,151,980 560,314 - 1,190,230 1,190,230
a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 & 2. Grant appropriation for revisions in process.
b) Payments are received one month in arrears.
c) Grants for HIV and Chronic Care were not included in FY 2010 budget.
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
Seizure/Forfeiture
Interest on Investments
Rentals
Donations
Interfund Contract
Administrative Fee
Comm. on Children & Fam
Crime Prevention Services
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Four Months Ended October 31, 2009
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004)
1,833
41,667
667
33,273
1,759,029
61,572
100,235
35,333
23,333
13,600
82,500
3,833
10,667
5,500
1,000
1,040
1,011,651
7,333
42,333
2,440
43,371
55
25,253
1,779,849
5,326
42,069
26,700
4,486
46,520
1,521
13,129
16,846
2,875
7,000.
981,652
607
1,704
(612)
(8,020)
20,820
(56,246)
(100,235)
6,736
3,367
(9,114)
(35,980)
(2,312)
13,129
6,179
(2,625)
6,000
(1,040)
(29,999)
(7,333)
(42,333)
Total Revenues 3,236,399
Transfers In -General Fund 438,719
Transfers In -Other 85,212
33% 44% 5,500 5,500
33% 35% 125,000 125,000
33% 3% 2,000 2,000
33% 25% a) 99,819 99,819
b) 5,277,086 5,351,224 74,138
33% 3% 184,716 184,716
0% c) 300,705 300,705
40% 106,000 106,000
33% 38% 70,000 88,800 18,800
11% 40,800 40,800
33% 19% 247,500 247,500
13% 11,500 11,500 -
33% n/a 13,129 13,129
33% 53% 32,000 45,000 13,000
33% 17% 16,500 16,500 -
233% 3,000 7,000 4,000
0% 3,120 3,120
33% 32% 3,034,954 3,031,954 (3,000)
0% 22,000 - (22,000)
0% a) 127,000 127,000
33%
34%
33%
33%
33%
33%
33%
33%
33%
33%
2,999,092 (237,307) 33% 31% 9,709,200 9,807,267 98,067
432,889 (5,830)
126,875 41,663
TOTAL RESOURCES 6,485,330
REQUIREMENTS:
Expenditures
Personal Services 2,635,227
Materials and Services 1,351,171
Capital Outlay 26,667
Transfers Out 50,000
Contingency 605,600
33%
33% 50%
33%
1,316,158
255,636
1,316,158
363,129 107,493
6,148,852 (336,478) 33% 44% 14,005,994 14,076,550 70,556
2,355,858
1,037,714
279,369
313,457
26,667
37,500 12,500
605,600
TOTAL REQUIREMENTS 4,668,665
NET (Resources - Requirements) 1,816,665
Exp. %
33% 30%
26%
33% 0%
33% 25%
n/a
33%
33%
7,905,680
4,053,514
80,000
150,000
1,816,800
7,890,661 15,019
4,053,514
80,000
150,000
1,816,800
3,431,072 1,237,593 33% 24% 14,005,994 12,174,175 1,831,819
2,717,780 901,115 - 1,902,375 1,902,375
a) Grant billing received quarterly, in arrears.
b) Dept 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.
Year to Date
Budget
Actual Variance
FY % Coll. %
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004)
1,833
41,667
667
33,273
1,759,029
61,572
100,235
35,333
23,333
13,600
82,500
3,833
10,667
5,500
1,000
1,040
1,011,651
7,333
42,333
2,440
43,371
55
25,253
1,779,849
5,326
42,069
26,700
4,486
46,520
1,521
13,129
16,846
2,875
7,000.
981,652
607
1,704
(612)
(8,020)
20,820
(56,246)
(100,235)
6,736
3,367
(9,114)
(35,980)
(2,312)
13,129
6,179
(2,625)
6,000
(1,040)
(29,999)
(7,333)
(42,333)
Total Revenues 3,236,399
Transfers In -General Fund 438,719
Transfers In -Other 85,212
33% 44% 5,500 5,500
33% 35% 125,000 125,000
33% 3% 2,000 2,000
33% 25% a) 99,819 99,819
b) 5,277,086 5,351,224 74,138
33% 3% 184,716 184,716
0% c) 300,705 300,705
40% 106,000 106,000
33% 38% 70,000 88,800 18,800
11% 40,800 40,800
33% 19% 247,500 247,500
13% 11,500 11,500 -
33% n/a 13,129 13,129
33% 53% 32,000 45,000 13,000
33% 17% 16,500 16,500 -
233% 3,000 7,000 4,000
0% 3,120 3,120
33% 32% 3,034,954 3,031,954 (3,000)
0% 22,000 - (22,000)
0% a) 127,000 127,000
33%
34%
33%
33%
33%
33%
33%
33%
33%
33%
2,999,092 (237,307) 33% 31% 9,709,200 9,807,267 98,067
432,889 (5,830)
126,875 41,663
TOTAL RESOURCES 6,485,330
REQUIREMENTS:
Expenditures
Personal Services 2,635,227
Materials and Services 1,351,171
Capital Outlay 26,667
Transfers Out 50,000
Contingency 605,600
33%
33% 50%
33%
1,316,158
255,636
1,316,158
363,129 107,493
6,148,852 (336,478) 33% 44% 14,005,994 14,076,550 70,556
2,355,858
1,037,714
279,369
313,457
26,667
37,500 12,500
605,600
TOTAL REQUIREMENTS 4,668,665
NET (Resources - Requirements) 1,816,665
Exp. %
33% 30%
26%
33% 0%
33% 25%
n/a
33%
33%
7,905,680
4,053,514
80,000
150,000
1,816,800
7,890,661 15,019
4,053,514
80,000
150,000
1,816,800
3,431,072 1,237,593 33% 24% 14,005,994 12,174,175 1,831,819
2,717,780 901,115 - 1,902,375 1,902,375
a) Grant billing received quarterly, in arrears.
b) Dept 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.
Year End
Budget
Projection
Variance
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004)
1,833
41,667
667
33,273
1,759,029
61,572
100,235
35,333
23,333
13,600
82,500
3,833
10,667
5,500
1,000
1,040
1,011,651
7,333
42,333
2,440
43,371
55
25,253
1,779,849
5,326
42,069
26,700
4,486
46,520
1,521
13,129
16,846
2,875
7,000.
981,652
607
1,704
(612)
(8,020)
20,820
(56,246)
(100,235)
6,736
3,367
(9,114)
(35,980)
(2,312)
13,129
6,179
(2,625)
6,000
(1,040)
(29,999)
(7,333)
(42,333)
Total Revenues 3,236,399
Transfers In -General Fund 438,719
Transfers In -Other 85,212
33% 44% 5,500 5,500
33% 35% 125,000 125,000
33% 3% 2,000 2,000
33% 25% a) 99,819 99,819
b) 5,277,086 5,351,224 74,138
33% 3% 184,716 184,716
0% c) 300,705 300,705
40% 106,000 106,000
33% 38% 70,000 88,800 18,800
11% 40,800 40,800
33% 19% 247,500 247,500
13% 11,500 11,500 -
33% n/a 13,129 13,129
33% 53% 32,000 45,000 13,000
33% 17% 16,500 16,500 -
233% 3,000 7,000 4,000
0% 3,120 3,120
33% 32% 3,034,954 3,031,954 (3,000)
0% 22,000 - (22,000)
0% a) 127,000 127,000
33%
34%
33%
33%
33%
33%
33%
33%
33%
33%
2,999,092 (237,307) 33% 31% 9,709,200 9,807,267 98,067
432,889 (5,830)
126,875 41,663
TOTAL RESOURCES 6,485,330
REQUIREMENTS:
Expenditures
Personal Services 2,635,227
Materials and Services 1,351,171
Capital Outlay 26,667
Transfers Out 50,000
Contingency 605,600
33%
33% 50%
33%
1,316,158
255,636
1,316,158
363,129 107,493
6,148,852 (336,478) 33% 44% 14,005,994 14,076,550 70,556
2,355,858
1,037,714
279,369
313,457
26,667
37,500 12,500
605,600
TOTAL REQUIREMENTS 4,668,665
NET (Resources - Requirements) 1,816,665
Exp. %
33% 30%
26%
33% 0%
33% 25%
n/a
33%
33%
7,905,680
4,053,514
80,000
150,000
1,816,800
7,890,661 15,019
4,053,514
80,000
150,000
1,816,800
3,431,072 1,237,593 33% 24% 14,005,994 12,174,175 1,831,819
2,717,780 901,115 - 1,902,375 1,902,375
a) Grant billing received quarterly, in arrears.
b) Dept 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.
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $ 413,471 $ 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188
Revenues
Admin -Operations 1,217 7,250 6,033 33% 199% a) 3,650 17,000 13,350
Admin -GIS 692 4,535 3,843 33% 219% b) 2,075 38,900 36,825
Admin -Code Enforcement 63,150 57,855 (5,295) 33% 31% c) 189,450 175,500 (13,950)
Building Safety 324,925 314,879 (10,046) 33% 32% d) 974,775 992,400 17,625
Electrical 93,500 96,912 3,412 33% 35% d) 280,500 297,900 17,400
Contract Services 85,167 26,217 (58,950) 33% 10% e) 255,500 99,600 (155,900)
Env Health -On Site Prog 97,617 78,895 (18,722) 33% 27% c) 292,850 241,500 (51,350)
Env Health-Lic Facilities 230,158 64,452 (165,706) 33% 9% f) 690,475 690,475
Env Health - Drinking H2O 31,770 29,186 (2,584) 33% 31% g) 95,311 95,311
Planning -Current 328,050 254,766 (73,284) 33% 26% h) 984,150 689,900 (294,250)
Planning -Long Range 142,967 158,406 15,439 33% 37% c) 428,900 418,200 (10,700)
Total Revenues
Trans In -GF
Trans In -GF for Lng Rng Ping
Trans In -Other
TOTAL RESOURCES
1,399,213 1,093,352 (305,862) 33% 26% 4,197,636 3,756,686 (440,950)
405,542 405,543 1
100,000 75,000 (25,000)
33 (33)
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
2,318,259 2,203,553 (114,706)
0°/U
n/a 1,216,627 1,216,627
0% n/a 300,000 300,000
0% 0% 100 (100)
36% 6,127,834 5,902,972 (224,862)
33%
Exp. %
569,371 556,386 12,985 33% 33% 1,708,112 1,708,112
71,869 67,711 4,158 33% 31% 215,606 215,606
60,323 58,714 1,609 33% 32% 180,969 180,969 -
241,715 233,700 8,015 33% 32% i) 725,145 698,080 27,065
68,906 67,357 1,549 33% 33% i) 206,719 193,187 13,532
88,260 84,524 3,736 33% 32% i) 264,781 260,270 4,511
80,229 76,280 3,949 33% 32% 240,687 240,687 -
165,315 164,630 685 33% 33% 495,946 495,946
26,866 28,949 (2,083) 33% 36% 80,598 80,598
269,928 262,028 7,900 33% 32% 809,783 809,783 -
183,943 139,859 44,084 33% 25% 551,828 551,828
59,220 59,220 - 0% 33% 177,660 177,660
156,667 156,667 33% n/a 470,000 470,000
TOTAL REQUIREMENTS 2,042,612 1,799,359 243,253 33% 29% 6,127,834 5,612,726 515,108
NET (Resources - Requirements)
275,647 404,195 128,548 290,246 290,246
Revenues 1,093,352 3,756,686
Expenditures 1,799,359 5,612,726
Net from Operations (706,007) (1,856,040)
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 slightly below budget. On -Site work volume has slowed significantly.
d) Business volume and revenue have thus far exceeded expectations.
e) Significant drop-off in City of Redmond work.
f) Revenue is received primarily in December through February following mailing of license renewal statements.
g) Payments from State DHS are received irregularly.
h) Significant slowdown in land use applications.
i) Reflects the retirement of the Building Safety Director in November.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 413,471 $ 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188
Revenues
Admin -Operations 1,217 7,250 6,033 33% 199% a) 3,650 17,000 13,350
Admin -GIS 692 4,535 3,843 33% 219% b) 2,075 38,900 36,825
Admin -Code Enforcement 63,150 57,855 (5,295) 33% 31% c) 189,450 175,500 (13,950)
Building Safety 324,925 314,879 (10,046) 33% 32% d) 974,775 992,400 17,625
Electrical 93,500 96,912 3,412 33% 35% d) 280,500 297,900 17,400
Contract Services 85,167 26,217 (58,950) 33% 10% e) 255,500 99,600 (155,900)
Env Health -On Site Prog 97,617 78,895 (18,722) 33% 27% c) 292,850 241,500 (51,350)
Env Health-Lic Facilities 230,158 64,452 (165,706) 33% 9% f) 690,475 690,475
Env Health - Drinking H2O 31,770 29,186 (2,584) 33% 31% g) 95,311 95,311
Planning -Current 328,050 254,766 (73,284) 33% 26% h) 984,150 689,900 (294,250)
Planning -Long Range 142,967 158,406 15,439 33% 37% c) 428,900 418,200 (10,700)
Total Revenues
Trans In -GF
Trans In -GF for Lng Rng Ping
Trans In -Other
TOTAL RESOURCES
1,399,213 1,093,352 (305,862) 33% 26% 4,197,636 3,756,686 (440,950)
405,542 405,543 1
100,000 75,000 (25,000)
33 (33)
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
2,318,259 2,203,553 (114,706)
0°/U
n/a 1,216,627 1,216,627
0% n/a 300,000 300,000
0% 0% 100 (100)
36% 6,127,834 5,902,972 (224,862)
33%
Exp. %
569,371 556,386 12,985 33% 33% 1,708,112 1,708,112
71,869 67,711 4,158 33% 31% 215,606 215,606
60,323 58,714 1,609 33% 32% 180,969 180,969 -
241,715 233,700 8,015 33% 32% i) 725,145 698,080 27,065
68,906 67,357 1,549 33% 33% i) 206,719 193,187 13,532
88,260 84,524 3,736 33% 32% i) 264,781 260,270 4,511
80,229 76,280 3,949 33% 32% 240,687 240,687 -
165,315 164,630 685 33% 33% 495,946 495,946
26,866 28,949 (2,083) 33% 36% 80,598 80,598
269,928 262,028 7,900 33% 32% 809,783 809,783 -
183,943 139,859 44,084 33% 25% 551,828 551,828
59,220 59,220 - 0% 33% 177,660 177,660
156,667 156,667 33% n/a 470,000 470,000
TOTAL REQUIREMENTS 2,042,612 1,799,359 243,253 33% 29% 6,127,834 5,612,726 515,108
NET (Resources - Requirements)
275,647 404,195 128,548 290,246 290,246
Revenues 1,093,352 3,756,686
Expenditures 1,799,359 5,612,726
Net from Operations (706,007) (1,856,040)
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 slightly below budget. On -Site work volume has slowed significantly.
d) Business volume and revenue have thus far exceeded expectations.
e) Significant drop-off in City of Redmond work.
f) Revenue is received primarily in December through February following mailing of license renewal statements.
g) Payments from State DHS are received irregularly.
h) Significant slowdown in land use applications.
i) Reflects the retirement of the Building Safety Director in November.
ROAD
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 4,871,665
Revenues
Federal Reimbursements 163,333
System Development Chrg
Mineral Lease Royalties 3,333
Forest Receipts 827,333
State Grant 138,492
Motor Vehicle Revenue 2,666,667
City of Bend 75,000
City of Redmond 83,333
City of Sisters 3,333
City of La Pine 3,333
Admin Recovery (SDC) 167
Miscellaneous 43,333
Road Vacations 333
Interest on Investments 16,667
Other Bank/LGIP Interest
Interfund Contract 233,333
Equipment Repairs 91,667
Vehicle Repairs 30,000
Vegetation Management 11,667
Inter -fund: Forester 7,333
Car Washes 833
Car Rental
Sale of Eqp & Material 266,667
$ 4,891,649
$ 19,984 100%
(163,333)
231 231
10,478 7,145
(827,333)
(138,492)
2,362,827 (303,840)
- (75,000)
(83,333)
(3,333)
(3,333)
585 418
7,081 (36,252)
(333)
22,581 5,914
642 642
- (233,333)
57,012 (34,655)
(30,000)
(11,667)
(7,333)
1,342 509
356 356
193,216 (73,451)
Total Revenues 4,666,157
Trans In - CDD
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
6,063
236,189
25,000
3,333
2,656,351 (2,009,806)
177,142
18,750
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
100% $ 4,871,665 $ 4,891,649 $ 19,984
0%
n/a
105%
0%
0%
30%
0%
0%
0%
n/a
33% n/a
33% 5%
33% 0%
45%
33% n/a
33% 0% c)
21%
0% c)
0% c)
0% c)
54%
n/a
24%
19%
33%
a)
b)
b)
b)
b)
33%
33%
33%
33%
33%
33%
33%
33%
(6,063) 33%
(59,047) 33%
(6,250) 33%
(3,333) 33%
TOTAL RESOURCES 9,783,407
REQUIREMENTS:
Expenditures
Personal Services 1,888,458
Materials and Services 3,044,403
Capital Outlay 900,000
Transfers Out 133,333
Contingency 594,439
7,743,892 (2,058,265) 33%
1,751,102
4,297,165
424,963
137,356
(1,252,762)
475,037
133,333
594,439
TOTAL REQUIREMENTS 6,560,633
33%
33%
33%
490,000 490,000
925
25,000
2,482,000
415,477
8,000,000
225,000
250,000
10,000
10,000
1,500
130,000
1,000
50,000
1,500
700,000 700,000
275,000 275,000
90,000 90,000
35,000 35,000
22,000 22,000
2,500 2,500
1,000
800,000 800,000
10,000
2,482,000
415,477
8,000,000
225,000
250,000
10,000
10,000
500
130,000
1,000
50,000
925
15,000
1,000
1,500
1,000
13,998,477 14,017,902 19,425
0% 18,190 18,190
25% d) 708,567 708,567
25% d) 75,000 75,000
0% c) 10,000 10,000
50% 19,681,899 19,721,308 39,409
Exp. %
31%
47%
16%
33% 0%
33% n/a
6,473,230 87,403 33%
NET (Resources - Requirements) 3,222,774
1,270,662 (1,970,862)
a) Annual payment anticipated to be received in December 09.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Payment received quarterly from Solid Waste.
5,665,373
9,133,210
2,700,000
400,000
1,783,316
5,665,373
9,133,210
2,700,000
400,000
1,783,316
33% 19,681,899 17,898,583 1,783,316
1,822,725 1,822,725
Year End
Budget
Projection
Variance
100% $ 4,871,665 $ 4,891,649 $ 19,984
0%
n/a
105%
0%
0%
30%
0%
0%
0%
n/a
33% n/a
33% 5%
33% 0%
45%
33% n/a
33% 0% c)
21%
0% c)
0% c)
0% c)
54%
n/a
24%
19%
33%
a)
b)
b)
b)
b)
33%
33%
33%
33%
33%
33%
33%
33%
(6,063) 33%
(59,047) 33%
(6,250) 33%
(3,333) 33%
TOTAL RESOURCES 9,783,407
REQUIREMENTS:
Expenditures
Personal Services 1,888,458
Materials and Services 3,044,403
Capital Outlay 900,000
Transfers Out 133,333
Contingency 594,439
7,743,892 (2,058,265) 33%
1,751,102
4,297,165
424,963
137,356
(1,252,762)
475,037
133,333
594,439
TOTAL REQUIREMENTS 6,560,633
33%
33%
33%
490,000 490,000
925
25,000
2,482,000
415,477
8,000,000
225,000
250,000
10,000
10,000
1,500
130,000
1,000
50,000
1,500
700,000 700,000
275,000 275,000
90,000 90,000
35,000 35,000
22,000 22,000
2,500 2,500
1,000
800,000 800,000
10,000
2,482,000
415,477
8,000,000
225,000
250,000
10,000
10,000
500
130,000
1,000
50,000
925
15,000
1,000
1,500
1,000
13,998,477 14,017,902 19,425
0% 18,190 18,190
25% d) 708,567 708,567
25% d) 75,000 75,000
0% c) 10,000 10,000
50% 19,681,899 19,721,308 39,409
Exp. %
31%
47%
16%
33% 0%
33% n/a
6,473,230 87,403 33%
NET (Resources - Requirements) 3,222,774
1,270,662 (1,970,862)
a) Annual payment anticipated to be received in December 09.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Payment received quarterly from Solid Waste.
5,665,373
9,133,210
2,700,000
400,000
1,783,316
5,665,373
9,133,210
2,700,000
400,000
1,783,316
33% 19,681,899 17,898,583 1,783,316
1,822,725 1,822,725
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782
Revenues
State Miscellaneous 2,667 (2,667) 33% 0% a) 8,000 4,301 (3,699)
State Subsidy 9,833 6,653 (3,180) 33% 23% b) 29,500 29,500
SB 1145 946,642 1,480,995 534,353 33% 52% c) 2,839,925 2,839,925
Probation Work Crew Fees 13,333 11,837 (1,496) 33% 30% d) 40,000 40,000
Miscellaneous 1,000 1,595 595 33% 53% 3,000 3,000
Electronic Monitoring Fee 53,333 58,535 5,202 33% 37% 160,000 160,000
Probation Superv. Fees 73,333 75,696 2,363 33% 34% 220,000 220,000
Interest on Investments 3,000 4,654 1,654 33% 52% 9,000 9,000
Crime Prevention Services 16,667 (16,667) 33% 0% 50,000 50,000
Total Revenues 1,119,808 1,639,965 520,157 33% 49% 3,359,425 3,355,726 (3,699)
Transfers In -General Fund 38,343 38,344 1 33% 33% 115,029 115,029
Transfers In -Sheriff 16,667 - (16,667) 33% 0% 50,000 50,000
TOTAL RESOURCES 1,642,710 2,165,983 523,273 33% 54% 3,992,346 4,008,429 16,083
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
952,909 920,570 32,339 33% 32% 2,858,726 2,858,726
234,707 230,271 4,436 33% 33% 704,121 704,121
33 33 33% 0% 100
143,133 143,133 33% n/a 429,399
TOTAL REQUIREMENTS 1,330,782 1,150,841 179,941
NET (Resources - Requirements)
33%
100
429,399
29% 3,992,346 3,562,847 429,499
311,928 1,015,142 703,214 445,582 445,582
a) 1st quarter hearings officer revenue not yet received. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301.
b) Contract is being finalized for AIP funds.
c) Received second quarter funds for periods Oct -Dec.
d) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients.
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
State Miscellaneous 2,667 (2,667) 33% 0% a) 8,000 4,301 (3,699)
State Subsidy 9,833 6,653 (3,180) 33% 23% b) 29,500 29,500
SB 1145 946,642 1,480,995 534,353 33% 52% c) 2,839,925 2,839,925
Probation Work Crew Fees 13,333 11,837 (1,496) 33% 30% d) 40,000 40,000
Miscellaneous 1,000 1,595 595 33% 53% 3,000 3,000
Electronic Monitoring Fee 53,333 58,535 5,202 33% 37% 160,000 160,000
Probation Superv. Fees 73,333 75,696 2,363 33% 34% 220,000 220,000
Interest on Investments 3,000 4,654 1,654 33% 52% 9,000 9,000
Crime Prevention Services 16,667 (16,667) 33% 0% 50,000 50,000
Total Revenues 1,119,808 1,639,965 520,157 33% 49% 3,359,425 3,355,726 (3,699)
Transfers In -General Fund 38,343 38,344 1 33% 33% 115,029 115,029
Transfers In -Sheriff 16,667 - (16,667) 33% 0% 50,000 50,000
TOTAL RESOURCES 1,642,710 2,165,983 523,273 33% 54% 3,992,346 4,008,429 16,083
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
952,909 920,570 32,339 33% 32% 2,858,726 2,858,726
234,707 230,271 4,436 33% 33% 704,121 704,121
33 33 33% 0% 100
143,133 143,133 33% n/a 429,399
TOTAL REQUIREMENTS 1,330,782 1,150,841 179,941
NET (Resources - Requirements)
33%
100
429,399
29% 3,992,346 3,562,847 429,499
311,928 1,015,142 703,214 445,582 445,582
a) 1st quarter hearings officer revenue not yet received. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301.
b) Contract is being finalized for AIP funds.
c) Received second quarter funds for periods Oct -Dec.
d) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients.
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
Title IV - Family Sup/Pres
HealthyStart Medicaid
Child Care Block Grant
Level 7 Services
HealthyStart /R -S -G
OCCF Grant
Miscellaneous
Court Fines & Fees
Interest on Investments
Grants -Private
Miscellaneous
Crime Prevention Services
Total Revenues
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ 624,543
75,000
12,551
31,667
27,092
58,398
102,526
204,684
2,667
25,000
10,000
667
62,500
24,783
$ 668,626 $ 44,083
32,304 (42,696)
(12,551)
(31,667)
(27,092)
(58,398)
(25,706)
48,643
(1,610)
1,023
(6,188)
(667)
20,000 (42,500)
(24,783)
76,820
253,327
1,057
26,023
3,812
637,535
Trans from General Fund 94,778
413,343 (224,192)
100% 107% $ 624,543 $ 668,626 $ 44,083
33% 14% d) 225,000
33% 0% a) 37,652
33% 0% 95,000
33% 0% a) 81,275
33% 0% a) 175,193
33% 25% a) 307,577
33% 41% a) 614,052
33% 13% 8,000
33% 35% c) 75,000
33% 13% 30,000
33% 0% 2,000
33% 11% 187,500
0% 74,350
33%
367,600
39,328
95,000
257,982
308,924
492,383
8,000
70,000
30,000
2,000
187,500
74,350
142,600
1,676
(81,275)
82,789
1,347
(121,669)
(5,000)
33% 22% 1,912,599 1,933,067 20,468
94,777 (1) 33% 33%
Total Transfers In 94,778
94,777 (1) 33%
TOTAL RESOURCES 1,356,856
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
179,993
591,681
33
168,785
1,176,746 (180,110) 33%
165,829
377,043
33%
284,333 284,333
284,333 284,333
42% 2,821,475 2,886,026 64,551
Exp. %
14,164 33% 31% b)
214,638
33 33% 0%
168,785 33% n/a
33%
21%
TOTAL REQUIREMENTS 940,492 542,872 397,620 33%
NET (Resources - Requirements)
416,364 633,874 217,510
a) Revenue projections reflect from final legislative allocations.
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 received.
539,978
1,775,043
100
506,354
494,522
1,770,461
45,456
4,582
100
506,354
19% 2,821,475 2,264,983 556,492
621,043 621,043
Year End
Budget
Projection
Variance
100% 107% $ 624,543 $ 668,626 $ 44,083
33% 14% d) 225,000
33% 0% a) 37,652
33% 0% 95,000
33% 0% a) 81,275
33% 0% a) 175,193
33% 25% a) 307,577
33% 41% a) 614,052
33% 13% 8,000
33% 35% c) 75,000
33% 13% 30,000
33% 0% 2,000
33% 11% 187,500
0% 74,350
33%
367,600
39,328
95,000
257,982
308,924
492,383
8,000
70,000
30,000
2,000
187,500
74,350
142,600
1,676
(81,275)
82,789
1,347
(121,669)
(5,000)
33% 22% 1,912,599 1,933,067 20,468
94,777 (1) 33% 33%
Total Transfers In 94,778
94,777 (1) 33%
TOTAL RESOURCES 1,356,856
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
179,993
591,681
33
168,785
1,176,746 (180,110) 33%
165,829
377,043
33%
284,333 284,333
284,333 284,333
42% 2,821,475 2,886,026 64,551
Exp. %
14,164 33% 31% b)
214,638
33 33% 0%
168,785 33% n/a
33%
21%
TOTAL REQUIREMENTS 940,492 542,872 397,620 33%
NET (Resources - Requirements)
416,364 633,874 217,510
a) Revenue projections reflect from final legislative allocations.
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 received.
539,978
1,775,043
100
506,354
494,522
1,770,461
45,456
4,582
100
506,354
19% 2,821,475 2,264,983 556,492
621,043 621,043
SOLID WASTE
Statement of Financial Operating Data
Four Months Ended October 31, 2009
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 33% n/a a) 37,850 37,850
Miscellaneous 10,000 8,992 (1,008) 33% 30% 30,000 30,000
Franchise 3% Fees 66,667 11,131 (55,536) 33% 6% b) 200,000 200,000
Commercial Disp. Fees 465,467 338,988 (126,479) 33% 24% 1,396,400 1,396,400
Private Disposal Fees 513,767 542,877 29,110 33% 35% 1,541,300 1,541,300
Franchise Disposal Fees 1,581,167 1,437,346 (143,821) 33% 30% 4,743,500 4,743,500
Yard Debris 25,000 33,027 8,027 33% 44% 75,000 75,000
Special Waste 10,000 12,636 2,636 33% 42% c) 30,000 30,000
Interest 4,667 6,057 1,390 33% 43% 14,000 14,000
Sale of Equip & Material 11,667 12,547 880 33% 36% 35,000 35,000
Total Revenues 2,688,402 2,441,451 (246,951) 33% 30% 8,065,200 8,103,050 37,850
TOTAL RESOURCES 3,027,013 2,907,776 (119,237) 33% 35% 8,403,811 8,569,375 165,564
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
587,859 560,948 26,911 33% 32% 1,763,578 1,763,578
1,249,418 992,061 257,357 33% 26% d) 3,748,254 3,748,254
322,922 322,922 33% 0% e) 968,765 968,765
49,667 25,850 23,817 33% 17% f) 149,000 149,000
479,922 177,142 302,780 33% 12% 1,439,767 1,439,767
111,482 - 111,482 33% n/a 334,447
334,447
TOTAL REQUIREMENTS 2,801,270 1,756,001 1,045,269 33% 21% 8,403,811 8,069,364 334,447
NET (Resources - Requirements) 225,743 1,151,775 926,032 500,011 500,011
a) Was due last fiscal year but received in 09-10.
b) Due April 15, 2010.
c) Contaminated soil and asbestos loads are intermittent.
d) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY.
e) Payments are scheduled for Nov and May.
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 33% n/a a) 37,850 37,850
Miscellaneous 10,000 8,992 (1,008) 33% 30% 30,000 30,000
Franchise 3% Fees 66,667 11,131 (55,536) 33% 6% b) 200,000 200,000
Commercial Disp. Fees 465,467 338,988 (126,479) 33% 24% 1,396,400 1,396,400
Private Disposal Fees 513,767 542,877 29,110 33% 35% 1,541,300 1,541,300
Franchise Disposal Fees 1,581,167 1,437,346 (143,821) 33% 30% 4,743,500 4,743,500
Yard Debris 25,000 33,027 8,027 33% 44% 75,000 75,000
Special Waste 10,000 12,636 2,636 33% 42% c) 30,000 30,000
Interest 4,667 6,057 1,390 33% 43% 14,000 14,000
Sale of Equip & Material 11,667 12,547 880 33% 36% 35,000 35,000
Total Revenues 2,688,402 2,441,451 (246,951) 33% 30% 8,065,200 8,103,050 37,850
TOTAL RESOURCES 3,027,013 2,907,776 (119,237) 33% 35% 8,403,811 8,569,375 165,564
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
587,859 560,948 26,911 33% 32% 1,763,578 1,763,578
1,249,418 992,061 257,357 33% 26% d) 3,748,254 3,748,254
322,922 322,922 33% 0% e) 968,765 968,765
49,667 25,850 23,817 33% 17% f) 149,000 149,000
479,922 177,142 302,780 33% 12% 1,439,767 1,439,767
111,482 - 111,482 33% n/a 334,447
334,447
TOTAL REQUIREMENTS 2,801,270 1,756,001 1,045,269 33% 21% 8,403,811 8,069,364 334,447
NET (Resources - Requirements) 225,743 1,151,775 926,032 500,011 500,011
a) Was due last fiscal year but received in 09-10.
b) Due April 15, 2010.
c) Contaminated soil and asbestos loads are intermittent.
d) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY.
e) Payments are scheduled for Nov and May.
f) Capital item purchases are spread out throughout the fiscal year.
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
General Liability
Property Damage
Vehicle
Workers' Compensation
Unemployment
Claims Reimb-Workers' Compensation
Claims Reimb-Gen Liab/Property
Process Fee-Events/Parades
Miscellaneous
Skid Car Training
Interest on Investments
TOTAL REVENUES
Transfers In -PERS Reserve
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Insurance
Repair / Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement / Benefit
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
RISK MANAGEMENT
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
% of FY
% CoII.
$2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314
152,321
95,431
61,398
285,285
53,397
8,333
3,333
300
1,333
7,333
10,000
152,314
95,368
61,398
285,280
53,401
72,483
455
(23)
1,960
15,166
(7) 33%
(63) 33%
(0) 33%
(5) 33%
4 33%
(8,333) 33%
69,150 33%
155 33%
(1,356) 33%
(5,373) 33%
5,166 33%
678,466 737,802
33
59,336 33%
(33) 33%
3,170,476 3,407,093
30,193
974
139,418
13
299
121,704 170,896
100,000
236,617 33%
33% 456,964 456,964
33% 286,294 286,294
33% 184,195 184,195
33% 855,854 855,854
33% 160,191 160,191
0% 25,000 25,000
725% 10,000 75,000 6f ,000
51% 900 900
-1% 4,000 4,000
9% 22,000 22,000
51% 30,000 30,000
36% 2,035,398 2,100,398 e,000
0% 100 (100)
75% 4,527,475 4,769,689 242,214
% Exp.
(49,192) 33% 47%
135,996
105,984
241,980 (141,980) 33%
883
411
1,801
25,322
40,000 28,417
206,667
UNEMPLOYMENT - Settlement/Benefits 46,667
173,820
72,921
1,445
10,678
258,863
a)
365,112 360,000 '1,112
a)
b)
81% 300,000 350,000 (50,000)
11,583 33% 24%
120,000 115,000 5,000
(52,196) 33% 42% 620,000 630,000 (10,000)
46,667 33% 0% c) 140,000 200,000 (60,000)
Total Direct Insurance Costs 515,037
Insurance Administration:
Personal Services 91,345
Materials & Service 82,164
Capital Outlay 33
700,156 (185,118) 33% 45% 1,545,112 1,655,000 (109,888)
89,962
60,931
Total Insurance Administration 173,542
Contingency 820,579
TOTAL REQUIREMENTS 1,509,158
NET 1,661,318
150,893
851,049
2,556,044
1,383 33%
21,233 33%
33 33%
22,649 33%
820,579 33%
658,109 33%
894,726
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen
b) Expenditures in property damage is offset by claims reimbursement
c) Expenditure for the quarter ended 9/30/09, paid in November, is $10
Health Services.
33% 274,034
25% 246,493
0% 100
29% 520,627
n/a 2,461,736
274,034
246,493
100
520,527 100
2,4k 1,736
19% 4,527,475 2,175,527 2,3f 1,948
2,594,162 2,514,162
Liab and $135,996 for Property Damage, expended in October.
revenue.
1,687. Unemployment payments required due to layoffs in CDD ani
Year End
Budget
Projection
Variance
$2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314
152,321
95,431
61,398
285,285
53,397
8,333
3,333
300
1,333
7,333
10,000
152,314
95,368
61,398
285,280
53,401
72,483
455
(23)
1,960
15,166
(7) 33%
(63) 33%
(0) 33%
(5) 33%
4 33%
(8,333) 33%
69,150 33%
155 33%
(1,356) 33%
(5,373) 33%
5,166 33%
678,466 737,802
33
59,336 33%
(33) 33%
3,170,476 3,407,093
30,193
974
139,418
13
299
121,704 170,896
100,000
236,617 33%
33% 456,964 456,964
33% 286,294 286,294
33% 184,195 184,195
33% 855,854 855,854
33% 160,191 160,191
0% 25,000 25,000
725% 10,000 75,000 6f ,000
51% 900 900
-1% 4,000 4,000
9% 22,000 22,000
51% 30,000 30,000
36% 2,035,398 2,100,398 e,000
0% 100 (100)
75% 4,527,475 4,769,689 242,214
% Exp.
(49,192) 33% 47%
135,996
105,984
241,980 (141,980) 33%
883
411
1,801
25,322
40,000 28,417
206,667
UNEMPLOYMENT - Settlement/Benefits 46,667
173,820
72,921
1,445
10,678
258,863
a)
365,112 360,000 '1,112
a)
b)
81% 300,000 350,000 (50,000)
11,583 33% 24%
120,000 115,000 5,000
(52,196) 33% 42% 620,000 630,000 (10,000)
46,667 33% 0% c) 140,000 200,000 (60,000)
Total Direct Insurance Costs 515,037
Insurance Administration:
Personal Services 91,345
Materials & Service 82,164
Capital Outlay 33
700,156 (185,118) 33% 45% 1,545,112 1,655,000 (109,888)
89,962
60,931
Total Insurance Administration 173,542
Contingency 820,579
TOTAL REQUIREMENTS 1,509,158
NET 1,661,318
150,893
851,049
2,556,044
1,383 33%
21,233 33%
33 33%
22,649 33%
820,579 33%
658,109 33%
894,726
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen
b) Expenditures in property damage is offset by claims reimbursement
c) Expenditure for the quarter ended 9/30/09, paid in November, is $10
Health Services.
33% 274,034
25% 246,493
0% 100
29% 520,627
n/a 2,461,736
274,034
246,493
100
520,527 100
2,4k 1,736
19% 4,527,475 2,175,527 2,3f 1,948
2,594,162 2,514,162
Liab and $135,996 for Property Damage, expended in October.
revenue.
1,687. Unemployment payments required due to layoffs in CDD ani
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Four Months Ended October 31, 2009
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 2,043,594 622,913 (1,420,681) 33% 10% a) 6,130,782 6,130,782
Property Taxes - Prior 33,333 167,509 134,176 33% 168% 100,000 167,509 67,509
State Reimbursement 8,167 2,148 (6,019) 33% 9% b) 24,500 6,000 (18,500)
Telephone User Tax 178,667 70,569 (108,098) 33% 13% 536,000 536,000
Data Network Reimb. 11,333 22,402 11,069 33% 66% c) 34,000 27,880 (6,120)
Jefferson County 9,333 4,744 (4,589) 33% 17% 28,000 28,000
User Fee 20,167 46,605 26,438 33% 77% d) 60,500 60,500
Contract Payments 23,333 23,978 645 33% 34% e) 70,000 26,000 (44,000)
Miscellaneous 2,833 3,309 476 33% 39% 8,500 8,500
Interest 12,000 27,944 15,944 33% 78% 36,000 36,000 -
Interest on Unsegregated Tax 1,250 303 (947) 33% 8% 3,750 3,750
Total Revenues 2,344,010 992,424 (1,351,586) 33% 14% 7,032,032 7,030,921 (1,111)
Transfers In -Other
33 (33) 33% 0%
100 - (100)
TOTAL RESOURCES 7,481,010 6,603,592 (877,418) 33% 54% 12,169,132 12,642,089 472,957
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
% Exp.
1,272,096 1,141,055 131,041 33% 30% 3,816,287 3,816,287
429,841 280,172 149,669 33% 22% 1,289,522 1,289,522
58,333 13,830 44,503 33% 8% 175,000 175,000
646,313 646,313 33% 0% 1,938,939 1,938,939
1,649,795 1,649,795 33% n!a 4,949,384 4,949,384
TOTAL REQUIREMENTS 4,056,378 1,435,057 2,621,321 33% 12% 12,169,132 7,219,748 4,949,384
NET (Resources - Requirements) 3,424,632 5,168,535 1,743,903 - 5,422,341 5,422,341
a) Approximately 85% of the property taxes are collected in October and November.
b) Less activity being performed.
c) Annual billings.
d) Quarterly billing.
e) Less contract activity with law enforcement agencies.
Health Benefits Trust
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES
Beg. Net Working Capital $17,894,797 $ 17,894,797 $
Revenues:
Internal Premium Charges 3,493,333 3,489,762
PIT Emp - Add'I Prem 18,333 15,015
Employee Prem Contribution 110,000 113,190
COIC 333,333 361,354
Retiree / COBRA Co -Pay 166,667 192,222
Prescription Rebates 5,544
Interest 75,000 94,468
(0) 100% 100%
(3,571)
(3,319)
3,190
28,021
25,555
5,544
19,468
Total Revenues 4,196,667 4,271,555 74,888
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Conferences and Seminars
Claims Paid-Medical/Rx
Claims Paid-DentalNision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Printing
Program Supplies
Other
Total Materials & Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
22,091,464 22,166,351
36,432 34,582
33%
33%
33%
33%
33%
33%
33%
33%
Revised
Budget *
Year End L
Projection If
Variance
$17,894,797 $ 17,894,797 $ (0)
33% a) 10,480,000 10,440,425 (39,575)
27% 55,000 55,000
34% 330,000 330,000
36% 1,000,000 1,000,000
500,000 500,000
5,544 5,544
225,000 225,000
38%
n/a
42%
34%
12,590,000 12,555,969 (34,031)
74,888 92% 73% 30,484,797 30,450,766
Exp. %
1,850 33% 32% 109,297 109,297
1,000 505 495
4,749,192 3,931,084 818,108
607,333 528,610 78,723
- (21,587) 21,587
124,180 123,878 302
3,833 68,989 (65,155)
97,588 96,060 1,528
27,216 12,391 14,825
16,524 16,545 (21)
3,333 393 2,940
33,333 1,239 32,094
9,686 12,528 (2,842)
5,673,220 4,770,636
4,451,914
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
902,584 33%
- 33%
4,451,914
10,161,566 4,805,218
33%
17%
28% b)
29% b)
n/a
33%
n/a c)
33%
15%
33%
4%
1%
43%
28%
0%
0%
3,000 3,000
14,247,576 11,356,466
1,822,000 1,527,097
(21,587)
372,540 372,540
11,500 11,500
292,764 292,764
81,648 81,648
49,572 49,572
10,000 10,000
100,000 100,000
29,059 29,059
(34,031)
;',891,110
294,903
21,587
17,019,659
100
13,355,741
13,812,059 3,207,600
100
13 355,741
5,356,348 33% 16% 30,484,797 13,921,356 16 563,441
NET(Resources- Requirements) ' 11,929,898 17,361,133 5,431,235
- 16,529,410 16 529,410
* Proposed revisions to FY 2010 original budget
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Projection based on annualizing 18 weeks of claims paid. YTD actual is $246,562 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.
0
Ocll
CO
N 0
Ym
LL
O 0 0
N 7 0)
y O
0)
Q0
n
0
7
.0
LL
.0
E
0
0)
E
Z
(0
0
2 0) m
} ❑ Q
0)
.0
O
0
0
0)
E
d
0)
ro'0000--
(D
C).C)
On0 Ul
V
- N N
0
N N n N O OI (O
02
U2
.
• O (0 V Or MN
N M (0 (0 V M O
co N (V
0 0 0 0 0 0 CCD 0 0 0 :O (D O
O N .O O C) C) 0 M 0 O N n (D
• s-NWn V M N ul ,F cn .' N
I..r> co
01) N 0 co h
co O
co O
co 0
cocci
V
Cr) O
e- 0
01) CO
V
O,O 0'e. 0) O N P-
CD C) e- (D 000 0 O
00 10 0 0') (0 (O 't()
'0 V 7 co
N O
O O.0
,0 on
O O h
n V
N,e-
0'1-
N
M O
O
O a
6
M
O C) CO
CD 000
Ul et
N
N N O (0
' N co_ 0 r
M ONE N
M', O O O W 0 (0'0 N'(0 N N
N. O N 23
.00 (0 O N '(V O (O
CO; O'V O' 0 n O - 1 o O)'0
(O h (D N''(D n N O n_0 00
�O N. 00 0 N 000 1N
�'.
P:..
yr'
O - ' O O
0 (0 (O
N N N,
O.�
M'0
n M
(WO V
O
M N
O. M
M'
0 0 0 - N •- O
O 000 N r' MO M �'
(0 O O '' ''.(Dv n M O
'
(O
0 (o v
r I,
N O O O O' O N OM O M
N • ' ' O 10'0'0 ' O 0) O n M' O O
O 0') V (0 0 V •
P- o O' o O n
04 o ' O'' 00 0
coNN V
O 0 00
N 0 00
• 0 i O 0 '
(0 M 01 e -
NI ('1)
0 MN)
CO
0Ul
M e
(0
n M
(O
N O
M N
O W
Met -
0 0 O (0
n'M O 1 f'
WD V M N
o
o0
0
O 0 10
O Or
O ' ', O 0
cf
0') r
M N
N
0 M CO
' ' O ' V) O
N O M
V
M O M U1'
P. M ' O r
O V 0') M
O V 03
CO 0
r CO
CO V
CO 0
0
M
0 N
O n
CD 0'e -
t+),
0 CD 04
0 CO UP
0 1- `-
v v
0 00) O N N 0.
(D O 0) O
0)n O v
n N O (0 (0 n O
0'N CO W 0 0-
3
3
0)
0)
,h OD
O
O
co'
N
N N
W (0
0
10 O
O CO
COCD N
0) v
01
(D (0 r
3
(0
O.0
CVO)
O
O'
O
o'o)
O "(0
cri
0 to
(0 M 0 N
CO N N CO
(0 (n 'm
O
(0 ('1)
(D
05
0')
01 r
(
10 oi 00
CO
CO
N N aD
0 up
V M
0 (D
O .- 0
CO CO' ' O.,V V W 00 0 CO N N O 0')' O e- O
W V n �'.N. 00) n N M OCD 00 0O
0'. V' �0� ' (270' e- P. ' CO O N O N'.' ' V�(DO '
M' O M a0 00'V N' ‘r 04 .- 0 h O
O', �^ O (0 a O 0 V, V 00
O (O 00: 00 N 00 0 r on
o ▪ ' ' V , ' V. ' V coMO M a (00
0 00. n' ' N ,i V n. (0
V co (0 V a
ul
V
N.'
N'
N N
0) et
I-- N
N
N
(0
M
N
O .-.
to o
n O
▪ O
)n, O
01 CO
N
M M
cD
O 0
' CD CO
00 N
W 0
(0D (N+) 0 0 0 0
0
eD V (D O
M W 0) O
O' V 00
co n (0 co'', n co 0'n '(D n n, 00 (D O
' ' ' N r N'..�. a (0
O 0'Vr O
O. N
0 0)
LL u) 0
0Eo
_ CD c y' c
u> Ill Ce
01 j �y ‘5I _I C 0 C 7i C' C OV NSI C'
0 ii 9
a., 0.. ce 0 e(j co I To N 0 C 0 I a' co C (0 O a'
w'S c'n0 0a 01) a) c'�Im.0 c ociro0
�, an d a) g E y c c t N, io Q) _
It m
.� o0.wl...I '.(ouzO>CI 2't G a20ill
1—
u.0 0
N0P-
0' M 0 CO
O. N O
co V
N
M'.
0 M.
N N"
0
yr
3
O.
M, (▪ 0D
0
O N
v
O.j N
O:LL ;
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.)
Interfund Contract
Total Receipts
Transfers In
TOTAL RESOURCES
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfer to Reserve Fund (617)
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Deschutes County - Fair and Expo Center
YTD -Budget Basis
Statement of Financial Operating Data
Four Months Ended October 31, 2009
Year to Date
Budget _
Actual
Variance
FY %
Co II. %
$ 75,000 $ 42,232 $ (32,768) 100%
12,000
1,002
575
300
134,700
666
22,000
2,000
33,000
3,420
3,513
124
83,984
263
8,446
1,170
11,611
11,000
(12,000)
2,511
(451)
(300)
(50,716)
(403)
(13,554)
(2,000)
1,170
(21,389)
7,580
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
33%
Year End
Budget
Projection
Variance
56% $ 75,000
0%
88%
5%
0%
16%
13%
15%
0%
3%
5%
13%
0%
12,000
4,000
2,300
1,200
540,000
2,000
58,000
7,000
45,000
235,000
86,420
45,000
$ 42,232 $ (32,768)
6,512
1,849
900
488,833
1,597
58,000
5,000
46,170
213,611
99,000
45,000
(12,000)
2,512
(451)
(300)
(51,167)
(403)
(2,000)
1,170
(21,389)
12,580
209,663 120,111 (89,552) 33% 12% 1,037,920
135,171 135,171 - 33% 27% a) 498,105
419,834 297,514 (122,320) 33% 18% 1,611,025
274,896 258,158 16,738
177,108 144,715 32,393
452,004 402,873
33%
Exp. %
31%
33% 27% b)
0%
0%
33% 0% c)
n/a
33%
33%
33%
824,769
531,604
116,188
100
16,412
121,952
966,472
386,876
1,395, 580
(71,448)
(111,229)
(215,445)
808,002 16,767
525,132 6,472
116,188
100
16,412
121,952
49,131 33% 25% 1,611,025 1,465,734 145,291
(32,170) (105,359) (73,189)
a) Transfer from Annual County Fair fund projected to be $111,000 less than budgeted.
b) It is possible that M & S will be less than what is currently projected.
c) The transfer will be made to the Reserve Fund only if there are sufficient funds.
Accrued Revenue (Accounts Receivable):
Current Month Events
Prior Months
Total Accounts Receivable
11,244
565
11,809
- (70,154) (70,154)
Deposits Received for Future Events:
2010:
November
December
January
February
March
April
May
June
FY 2011
FY 2012 & Beyond
TOTAL
8,723
1,205
100
2,270
490
4,875
3,260
1,000
36,090
5,450
63,463
REVENUES
Gate Receipts 400,000 284,806
Carnival 154,000 127,997
Commercial Exhibitors:
Outside 70,000 84,395
Inside 38,000 42,700
Food 12,000 13,900
Livestock Entry Fees 4,000 4,951
R/V Camping/Horse Stall Rental 17,000 18,102
Concessions:
Food 146,850 112,931 112,931
Fair Sponsorship:
Rodeo 23,000 19,350 19,350 84% (3,650)
On -ground Stages 13,000 8,000 8,000 62% (5,000)
Day 8,000 5,000 5,000 63% (3,000)
Golf Carts 2,500 4,125 4,125 165% 1,E,25
Food Court 3,000 3,000 3,000 100%
Concert (a) 30,000 10,000 20,000 30,000 100%
Presenting Sponsors 12,000 12,000 12,000 100%
Barn Sponsors 6,000 3,400 3,400 57% (2,E:00)
Parade Sponsors 4,800 4,800 N/A 4,E'00
Transfer In -General Fund 5,000 5,000 - 5,000 100%
T -Shirts 3,500 3,725 - 3,725 106% 225
Donations 1,229 - 1,229 N/A 1,229
State Grant (b) 25,000 - 41,963 41,963 168% 16,963
Interest 2,000 655 150 805 40% (1,1 9)
Deschutes County Fair - Fund 619
Revenues and Expenses
FAIR 2009 - July 29 to August 1, 2009
Fiscal Year 2010
284,806
71%
127,997
83%
(115, 194)
(26, )03)
84,395
42,700
13,900
4,951
18,102
121%
112%
116%
124%
106%
77%
14,395
4, '00
1,100
!)51
1 02
(33,4)19)
TOTAL REVENUES 974,850 770,066 62,113 832,179 85% (142,671)
EXPENSES
Personnel 178,128 152,715 29,507 182,222 102% (4,094)
Materials and Services 623,444 575,942 13,114 589,056 94% 34,388
Contingency 31,157 - - 0% 31,157
TOTAL EXPENSES 832,729 728,657 42,621 771,278 93% 61,451
Net Fair - 2009 142,121 41,409 19,492 60,901 (81,220)
Transfer to Fund 618 197,421 - 86,192 86,192 111,229
Retained in Annual Fair Fund (55,300) 41,409 (66,700) (25,291) 30,009
Beg Net Working Capital
Ending Balance
55,300 25,291 25,291
.11
66,700 66,700 0.00 0
(a) Combined Communications payment due on or before December 31, 2009.
(b) Per Oregon Fairs Association
Actual -
Through
FY 2010
Budget
October 31,
2009
Additional
Estimated
Projected
Total
% of
Budget
Varia=ice
284,806
71%
127,997
83%
(115, 194)
(26, )03)
84,395
42,700
13,900
4,951
18,102
121%
112%
116%
124%
106%
77%
14,395
4, '00
1,100
!)51
1 02
(33,4)19)
TOTAL REVENUES 974,850 770,066 62,113 832,179 85% (142,671)
EXPENSES
Personnel 178,128 152,715 29,507 182,222 102% (4,094)
Materials and Services 623,444 575,942 13,114 589,056 94% 34,388
Contingency 31,157 - - 0% 31,157
TOTAL EXPENSES 832,729 728,657 42,621 771,278 93% 61,451
Net Fair - 2009 142,121 41,409 19,492 60,901 (81,220)
Transfer to Fund 618 197,421 - 86,192 86,192 111,229
Retained in Annual Fair Fund (55,300) 41,409 (66,700) (25,291) 30,009
Beg Net Working Capital
Ending Balance
55,300 25,291 25,291
.11
66,700 66,700 0.00 0
(a) Combined Communications payment due on or before December 31, 2009.
(b) Per Oregon Fairs Association
PROJECTION
0
O
N
0
a)
U
(0
0
E
U
W
c
a)
E
E
E
0
0
Received and
a)
0
a)
X
W
RESOURCES:
1
1.0
O 1t)
0) 0 0)
4 O O
1n 0) I )
N M
co. 6
cn
0
U
CD
U
C
(0
U
U
O
4)
to
N d
V
N2o
U
• a
o o
00 c
EXPENDITURES:
O 1� LC" 0
CV CO CO
' ' ' N ' (
c) N vO
05
cc) -1- Er) 000
co 1l) 00 O N co O O co) O
N ch 0) O d1 I� 1l) O N
C( Cl4 CV O O 4 O 00 r
Er) r M I�
O
03 M (OC) 0 N- 0 0 0
c4) ' O 0) ' O L) '
O t O U) O v-
03
03 1n M O
• N I" N N In M O (0)
O O CO (S) (.0 CO 0) 0 0) (O
N d7 CO I- 0 0
00 d1 N (f) N 4 O— c
O
O ti N.. N N x O M O 0)
OOCOLOCO CO 0) 00)(r)
• Imo- 0) co I- CO co)
(6tom- to 4 4 O— c0
✓ N I�
� r
O
ce)
M
00
.rte
co
O
C0
O
co
O
O
co
0)
00
co
d•
LC)
(l)
O
ti
o co
▪ O
0) O
c6
co ▪ N
r v
N
M O
00 r �
O N
M
M
O
co
ti
1n
1n
O
N
ti
c`)
O
d•
0)
1l)
M
N
0)
M
M
N
0)
M
O
O
N
W
CA
a) V
U Z
(n Oa) v) CA R
C 0 0 _- °6 r
C
ccs • co
0 U a cn d r
(0
R. Cr) a) 0 a)co) U (gyp ` ,0 `0. R
05 .� � V) O) -p U Zr) •� 0 2 O U E U
co
To 0 7
z O U c a) ( a) > c L H o I—
- Qwi-a cu_<a`_0 • -.E.:5. co
U
C
a)
0)
c
0
0
co
0)
N
03
03
M
O
O
w
C`5
co
0
0)
0)
Total Expenditures
d
Z
co
O u)
Z
C lLl
LL 2
rn
O 2 N
a_ O M
c0 N
Q 0
U
0) ) WO
- 0 -c
a Z 3
0
N
, H
c U
a) W
0
Classification
Amount Paid
0
0_
(1)0
a)
0
CO O
N O
ti r
CO
N
O
Capital Outlay
O O
O O '71-
(0 r
r D7 C" J
LO O)
CO
C")
r O N
COO 1 0
0)
dr
10 N
O
tea)
0 a)
0(5 X 17)
0 C (/)
0
a.) -4-,e,- Cl)
0
0 0
To v O
c a Q 8
to UJ O
(o (0 •- 2
N 0 a0) o
LCA Architects
LCA Architects
Total Architect
0
0)
0
7
``Y^^
V/
0)
Oc ^^^^,,
r 0 C
(5)
Ci)
^) c
U V/ LU
co
a)
O
11)
co
a)
0)
0)
N
O
O
O
Total Encumbrances & Commitments
PROJECTION
a)
U
co
O
H
Encumbrances
& Commitments
Received and
a)
c
a)
0
W
RESOURCES:
CD M O
I� N CO 0
I � CO 0
M O 00 O
t) O N CD
N CO
M N
0 CO O 0
0 N M 0
O : CO O
O O co O
to O N CO
N CO
M N
CO
O
t0
CD
N
CD
N
M
CD
CD
co co Tr
O CO
00
M O
Total Resources
EXPENDITURES:
Materials & Services
0) LOCO
Cr) O CO
r' N N-
O CO 0) 0 N- O O (V 0 0
O O CO 0 a0 LC) a0 0 1 0 0
0 LC) O'—'— Cr) 0- 0 0
O r- CV O N CV O • LO
N I�
0 (0
O d-
n -
O
N
00 00 0 0 0 0
' O ' 0 0 ' 0 0
N O O '- '- O
N to O
r-
• 0 0 0 CD - O 00 N,—
• r M CO O CO CD — N-
CO CO 0 0 0 O CC) 01)
CO • r ' N c0
N
▪ N-
CO
N
1.0
I I 1 1 1 1
N 0 0 CO O CO CV
0 0 CO CO O 00 CO r`
• O O 0 0 0 O co
O
r r 00
(NJ
U)
2
V) X
a) ii
U
...=. U C
cn o z a)
ao ) (n c a •�
> c
a) V) m
a) a)O)
O U N U) L.L.
L ' a)
3 °c) a) 0 o E CT 0 U
tia)C
N 0,o O c)'cc▪ CC7CO 'Ec
UON c w6a(13 (Da)
L C
4HFLS5i¢a_02
ti
ti
CO
00
LC)
00
CD
N
d'
r
N
ti
c0
co
0 0
N 0
0 0 0 0 0
01 0 0 0 0
O O O O O
N CO It) CD Cn
to M M
N CD (0
N
r— 0 0 0
N- 0 0 0
▪ ' O O O
O CO O
Cr) CO N
O N CO
M
c
O
co
0)
O
O
O
O
O
10
N
O
CV-
0
O
O
CO
C co
o (0 )n
N 0 O
Tr. e-
00 0 N
N- M
O 0) t)
N I() 0
LL) r
U
a)
O
U
RA
CO
Cr
CC
CC
CO
to
N
M
'4)
<V
Total Expenditures
N'
PROJECTION
O
H
J
1-
0
0
c
o 0
d
Encumbrances
& Commitments
Received and
c
O
Q
X
W
RESOURCES:
O
ti
M
CO
ti
M
CO N O CO
N- CO O CO
I� N O O
C N O T
LO
N CO O 0))
M M
O N O N
O CO O CO
CDNON
O N O 1�
O N- CO CO
N CO 0)
M M
CO CO d'
N. O 03
N. ' CO
Lr)N O M
M Ch
I 1 I
M
Total Resources
EXPENDITURES:
Materials & Services
0)
CO
LO
CO CO
Lo
N
O CO O) O N t O O N O
O O CO O O O 0 0'- 0
O d O O v- O O d O
v- N O (\ N
N O N CO
O0) OCO CCOO OO O
O d ' O .- ' 0
N. r- N O O .- .-
CO co N 10
N
d O O) O CO d O CO N
I- CO c- CO O CO CO c- I-
OCOOOO.--a) Od co
T N d03
N
'1"
COCV
.1- co' ' '
N
O
NOOOd• Lt) ON
00-r-
100)-COcocoO) co .1- co
co- N N d
.-- CO
N
ti
N-
06 O
CO
O
03
CO
N
O)
CO
co
N
O
r --
r --
co M
O
M
co
O
03
O
dw
O
N
M
d• O CO N
d• LO
CO ti N CO
M N O O
r T T
COLO O CO 0 0) N
O O O
N CO O N- CO
co co co
.- c- N N 0 C
N N N T
O
co
O
N
O
0)
N_
03
O)
r -
ti
O
d
0)
O
O
M
O
N
O
N
d
U V
U —E
U
c0 U °o 7
. rA co > N
° co 7 2 is ° TtjO
0 V co n d •. .` >
> t y c O >s
c 0 E m U co m° a c
U U�O O U CV • O Tj U E V U
d c 75 O •) to coc
>Oa
U.cONU c(0 O NC c c u) O c
Qw1-n c Li.O Q'p aOI- cO I- 0
0O 0
0
N
CO
N
ti
03
M
03
O
N
M
u7
N
03
Total Expenditures
N
O
ti
0
0
03
N
a�
z
Amount Paid
C
O
0
U
N
a)
❑
Cf) I� NC) 0 O d) 1-
co COCD00
CO
Lri (fl O O� LO O C)co
d) co
N
d) CO Nd) ' ' CO CO
CO ,- O C) O 0
-
. N 1- to 1- CO
O O O �- 0) CA
O .- .- CO N-
C N N. C)
CC000
Cf) I�
N
a)
a)
N
U X
N
O
°) o
� C
c
C
OW
N
2 .5
CL CC
' - • �- O O CO d)
CO CO O d) N.
N N OO'— f—
co N C) O `zt
Total Architect
cn
E
N
C (/) (B
0
• N CT
• a)
U
CQ 0
E
O
Q
(/) C
Herman Miller
0
U
co
O
0
Engineered Structures Inc
Total Encumbrances & Commitments
cD
O O
c O
L
>,LLN
c • >�
M
O 43
O.5
a - o
d
A
U = L
a) N 0)
a Li -
2
- F—
Z
rn
PROJECTION
J
h
a)
U
c
co
1
O
1—
Encumbrances
& Commitments
Received and
0
a)
0
c
a)
0.
w
RESOURCES:
O
O
O
t0
1()
co
N
Q) O x-
01
CD O CO 0
01 Q) r '
co a)
f� N 1.0
CO f- N CD
o
O�
00
LLLL
Transfer In -911
Transfer In -911
Federal Grants
2
a)
c
Total Resources
O
O
O
O
Ln
O
O
O
O
LCD
t`
O
O
O
O
ti
O
O
O
O
LCD
ti
I
O O O O 0 0 0 0 0 0
O O O O 0 0 0 0 0 0
O
co ,- O ,- O co co co
N N r r
X-
O O O O 0 0 0 0 0 0
O O O O 0 0 0 0 0 0
L6 Lf) O r LCD O Lti O Lf) O
co — O — O co N- M co
CN N r r
x—
O
OO
O
O
O
a)
O
O
O
Y_
E
a) LL c
x V o 0
i.
i.".
0
06 m ac) O
a) v) 0) • Co E w co
°� `�E o 0 > m
7.77
U` y
ca
o NUO0 N
, ct O ° E 1) aN
>N
ci)
oW LL Hv)U la 1p a)cO0• N co
C.)
otL) E. w 0 a) aU a) Nw
p;0; 0 c aco.o .c o c.n,c z a
)
a v ff o OW 8 U1- Oc�vOL�Zm L a • c
ti a_
wX a3 �2 U0 LL I— 0
Total Ewnenditures
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
Deschutes County
Bethlehem Inn (Fund 128)
Four Months Ended October 31, 2009
Year to Date
Budget
Actual
Variance
FY
Coll. %
$(2,666,469) $(2,689,172) $ (22,703) 100% 101% a) $(2,666,469) $(2,689,172) $ (22,703)
2,766,469
2,766,469
- (2,766,469) 33% 0% 2,766,469 - (2,766,4,a
- (2,766,469) 33% 0% 2,766,469 • (2,766,469)
100,000 (2,689,172) (2,789,172) 33% -2689% 100,000 (2,689,172) (2,789,1 '2)
Exp. %
100,000 14,73585,265 33% 15% b) 100,000 45,000 55,0(i0
TOTAL REQUIREMENTS 100,000 14,735 85,265 33% 15% 100,000 45,000 55,010
NET (Resources - Requirements) - (2,703,907) (2,703,907)
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) October interest expense was $3,196.
- (2,734,172) (2,734,178
Year End
Budget
Projection
Variance
$(2,666,469) $(2,689,172) $ (22,703) 100% 101% a) $(2,666,469) $(2,689,172) $ (22,703)
2,766,469
2,766,469
- (2,766,469) 33% 0% 2,766,469 - (2,766,4,a
- (2,766,469) 33% 0% 2,766,469 • (2,766,469)
100,000 (2,689,172) (2,789,172) 33% -2689% 100,000 (2,689,172) (2,789,1 '2)
Exp. %
100,000 14,73585,265 33% 15% b) 100,000 45,000 55,0(i0
TOTAL REQUIREMENTS 100,000 14,735 85,265 33% 15% 100,000 45,000 55,010
NET (Resources - Requirements) - (2,703,907) (2,703,907)
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) October interest expense was $3,196.
- (2,734,172) (2,734,178
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2010
Jul
Aug
Sep
Oct
YTD Total
Tammy Baney
Conf/Sem & Educ/Training - 350 350
Travel Meals 15 15
Accommodations - 595 595
Airfare - - - -
Mileage reimbursement 256 86 5.73 915
Ground Transport/Parking 45 45
Total Baney 256 86 1,578 1,920
Dennis Luke
Conf/Sem & Educ/Training - 350 350
Travel Meals 25 - 25 50
Accommodations - 77 - 452 529__
Airfare - -
Mileage reimbursement 329 85 257 672
Ground Transport/Parking - 34 34
Total Luke - 432 85 1,118 1,635
Alan Unger
Conf/Sem & Educ/Training 350 350
Travel Meals
Accommodations 624 624
Airfare
Mileage reimbursement -
Ground Transport/Parking 56 56
Total Unger - 1,031 1,031
Total - BOCC Department
Conf/Sem & Educ/Training - 700 1,050
Travel Meals 25 - 40 65
Accommodations 77 - 1,046 1,748
Airfare - -
Mileage Reimbursement 585 172 831 1,587
Ground Transport 79 135
Total - BOCC Department 687 172 2,696 4,585
FY 2010 Budget 22,750
Percent Expended 20.2%
11/2/2109