HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
October 5, 2009
(1) Monthly Investment Report
(2) August 2009 Financials
eschutes Count
o .1 lnve men Port olio A s 0
Mmoi i - TT
- akdown: Ft=
0
e e c e° O
O Co .-
O N c) O M O 0 0
O T- N O N O O
O
r
co U7 10
C) CIC) co N
(')CO 6 O
CA O C!') N
O N CD
N `7 CCS O
T- N N (!)
U. S. Treasuries
CO
co
O
ri
O)
N
Total Investments
•
Current Month
1111A AL AL
CL
C
0 0)
J
0 a >
Ca E
Average Maturity in Days
0
0
c
0
0
O 0 u) an OOO
0 0 h N N N r
r r
Cn cn
E U
K c U a 0 co N
(6 U
C9 •c C U Cd o
• 7 a) U (6 z
` '65< t •` U..
0 2 co
H '- t
O) a)E o
0) 0-N -c U Q
_I ii m H U U
O D
l
Total Portfolio: By Investment Types
0
a) 0
z
1
(
E
1-
Market Value
Original Cost
a ry
N' A
i
c'
• 15
O, CZ
Ui
O • 0
o
re
G ,
OI T
o `0
• o
TI
W
O
2'I
N
CO 0
`'
a'
I0I0 0 0 0
U U U 0IU(-) 0 U UU-U U UIU U UIU U(-) 0 U U,UU UIIUIU U 01Uan _.N'(y c
IZ ZZ ZIZ ZZ Z',ZI.Z!z Z,ZZ.Z Z,Z Z Z..Z:Z Z Z Z Z Z'Z Z Z,ZI N N MM (ND
o O 1 0 0 1 0
I M I NN 01,1- r• -:,-,u,,- • Cl V 01 N- O (n . V M h' V N O) OD O I O'' (n 0 O' , 0 0 0 a0 �' 0 (0 M O OD
co co o, M• N• (D (O N M V V OI co .- N O' V I M SO M NH 01 0 1n O f-- O O: O) O O O h 0 0 (n O a
IN (0 0 M IR' 0. (n V O' (O (0 (O N'� 0 M'O'O M O'N N n 0 (0 co,0 (0 O O co n O 0'(n CO
V co :. n' M (n 0 0 (n' 0: co,,,- V O' • V N N' O N r co (() V 100 O0 co (n'I co (n n 0 • 0 0 O. n O (0 O) N W
co ',O N10 O''. NIO (0(n V (n NI OD N C•1NI_ (D!f- N 0D: 0) (Dl ( (D N M V O 0 O - 0 0)I r.....0)
N T
(O (0: V 01 0 (n" V M c• 0 N N 0 (n (`'1. O O O V N O 01 M I"- M M' O O O 0I O0 M V (n M 1
- co' O', O N co (() O O O 0 0 co O' N M co co N co 0 V co 0 ,MIM (n O' - co co n co (O V. h h
O) O: N .-- ,- O .- .- •O.- o O o I 0 O 0 0 O O O 0! co M M N 01,1
•NN M ci N, 1N N 4' �I V,'N •V o VI �)N,' NIN .IN C 'N1N NI N'(V N'0)
1 I 1 li O N N r ,,z.:),
4 "'
0 0 N (D MI0 0 0 M 00�0 O IO IS NI TCO V' 0 0I 0 0 0 0 0 N� 0I 0 O 01' 0� 0)' M 0) -I I0)
O O, N In V, M O. f� U) co 0 0 co. 0 O, In O co N, (O CO. V 1 0 O I O O (n O O' C do O.. co. o1
V (n O
OO'h O NO O V'1(V O O O'.O O V'O co N,O 0 4'O',O OI OI ,r)! co O''4 O O O''O'O 0 o (DI "+'
O I O co h V 1 O' O fes co a): co co co O co 0. N N N V N 0' (D' O N O: N I O (0 0' CO CO O (D 1 O 0 0) N LL0
0' 01 0 N' N 17 1 0 CO1 O O N M' CO 0 O 0; 0' V N 0 O0 0 0 0 7 Sn' M I M' N N' In. O h n 1 M .-' (- N N
01 N, C�) 0 (nI )001(7 N •- (O V, 010 ci 4.-14 co, OI h: co, O In co O0'N «)' O.,, O .- ODI OIO N V In (ail Ii)
0. 0, 0 V A N (0 I S 0 0 0; 04 N ' N 0 (0 V N. N O) ' M' (V .- (D (O 0) N 0. 0,,- '- 0 0. V f- M, I r
' O O N- f� O'0 ,-I,- 0 010,0 ..0''O'O OI 0 0 0 0 0 O O O 710 O'0I0 Co M M N T'1 0)
N N 7 M N N :N N1N N V N'V N V,- N NI(- .-,N I N N N N N N 0 10) O''.
I 1 1 I (O I N N 7 L
1 I 1 ! N
O
O O O O O. o'r V 0
0 1 0' 0 0 0,o O' M 0 0 0,0 0 0 O (001 0 O 01 0 O 0 0 0 O O M' M' O) in
! O O O I N O O V O 0 01 0 0 0, 0 0 0 0 0 O, O 0 O' 0.- 0• 0• 0• 0• 0 01 0 O O.: 0 O h (() O M >
0' 0I 0 O I O 0 co' O OI O O' old O O M, O O O O O O O N O (o 0 0 0 0 0 0 0 1 O1 0.•
1 0 U) SOI O)
N V I O 001 01 0 V 0 0 POD OD I OD . V 0 V' 010 0. 0 0. 0 0) CO (O 0110 N 0' 0 0 0 0,010 . CO N M L
- CO' 0 (0 01 0 0 0' 0 OICN OD N. OD 0; O1 0'0 0 0 0'. 0 0 V M 1 0 (0 O0 colo O 0 O O I O' 0' N h N N U
N V 1 O V O O I co- O 0 0I In N (n'. 0 O 1 O O O! O V I O 0 .I (7' O co• I O 1 O'. O O! O co V V 1 l() L
co V co (n O. O' In O O O V V M' V O'' N' G O O N CO1 O N O O: V f- O'' O' O O O O' O O' N{ V I n
O O 7 ':. CO O', O ! 7 7' 0. 0 0 O 7 O O O -. 01 O O O' O' O 0 1 O' 0 7 0. 0 O 0:01 N: M N
N N 7 M CV N N c N."NIV (V V N V,- N NIN 7IN N N N N N 041
{ 0N) N OI{ e
- H
O
I- r t Jr I - 1-, 1 JN
ele , la o e,e e 8e'e e e'.e ''o o e Io 8eele o e e e le,8 0 o e o o pie e 1 e e e e
O 0 o do O o V',O1M o O: O 010 O' O o coo: of do coo o' 000'o' O OOP 0
In .- Oi r N
In 0110'01 M: 10,0110-u): Or0)0 (DSO; OW. -0 O. V1(O N O'0 '.- 0 ,- 1n -M In 0 OI0'O 7 010
0, 0 h N r - N 04'1 : In 0 co. In 1 ^'' O 01 to l V O' O (n' O0 1n l O N O` O N f� :,, N h O O O f� N OD O 00 1 +
N 1 M M V N M M' (') MI N' M N 7 7 N'N 7 7 04 1 (V MI7 7 7 M M 7 7IN 7 N N N 7 N:O N• a)
1 LL
e' 82! el o 0 0'0 e e eCe1e o o e eI'8 e 0'
(n O' 0 0. - 0 0'' O' 0 In 0 0' 101 0 0 ' 0' 0 0'' 0 0 J
04 '1 0 I h. 0' 0 0' 0 1 : A I In 4 .. 1,10101 ' 10 010 O: O 0
7'04, MI. N O N N CD NI M'O 7110 :N- 010 0IC E
V(n', 0. 0. 1 1n M. VI V.. : 1 N)r MI!V. VI �. �:, N N N'1� aN.. !.
•ci ry
c 0_ 1-
I I ) M V coco0) V coI o (( CO0 (Nilo In a, 0 0 0 4 0 c> Y C_ m
c 1-
I-- O0 cola) co o (n O 0) V ! N 1� O. 0. 0I N co co co O (O V O O O T > �C
▪ MI W O n', O' 01 04 01 O' V coM. O, O V V V co V 1 f� V In co M M N M a
(n (n: M' V 10 M' M f� 01 N M n, M' M In ln, In V (n V ln, h 1ff E T'',
t c
1 c 0 rn l rn 0 d a) 0) 0)' 0) 0) 00 01 0 0 oro 0 o' O o' o 0 0 0 o, a> 0 c'
000'00o'O00I0o 7 co c0 i
• r In co co In co O 4 ,' coI 10110 4 N N CO. r-! 0)' co V O. R h 0) .- 0.- N N 0 2 V
c .-- r- 04, 7 04 0 0 7 0 7 7 (V 0. 7' 0 0, (N N- N 04' 0 0 0 CC.1I 0 7 0 0'1 N a) R 9
• O) 0 O) 0 o) 01 0 (V N (V \ C) M1 V'' V Is- Is f-- Or Q�1 0) 0 0 0 I N N C) C9 (D > U
0 0 0 0 0 0'� ' O'o oi0 o o O o' 0, O' O, 0 � '1010 o:O o o Olo < 0 0 0
(04'-0 0 (0 0 0!00110 4- (00) ar0'ia)!a'a) rnI(0rn) 0)' 0) 0) 0 0) 0, 0:0) cm rn 0 rn
O 0, o 0 0 O' 0 1 0 Oto 0 0 O' o- O', O I plod 0'.. 0', o, o f 0l 0 0 0 0 0 01 01 O t o 0 0 O. O
N MIS.. O) 0 -6',,a01,- , ID' N- M V 1 OD Ni 4'- ((1 0 (D 001 4' ; 01 0 V -- (4'.10' 0 0) 01 0) .- N V' W
O �--1 N N N ON O O r 1'04 O N O 7 O OI N'. N r r r 7 NI7 O CD o 7 O O N
✓ N CO V N 0) ((0 (n (V j N (V N• v V co V V ': 0' N (D V (D In ,- (D n n: N N C) C)I (0
01.-0 0 0 0'10 0'7 0 0 0 0 0 010,0 0,0 0 0 0 0 0 7 0,0 0 0 0 0 0110
I L T r+ r
addl : 6, tQL 19 1- 1- 6 6 19 12 1'- 44- ' 12 U 6: 19
1191,9 0 1- 1 4- ❑_a --
'j
�T- ti- ( U LL LIr11 1 LL LL LL 41- f LL
Ue z1z IL'''m (n u) LL >'m a CO < LL M'CL U < ¢ LL 0 co <ICO LL Z LL'm CO a LL Z ¢ �Z1,Z
l 8 0 M 0'. CL3 D (O J 7 Q_ m 'I � LL U , (I m CO 7 I m 1 J 1 m, 2 V) 2 2 7 :. 0 ,, 0 CO 11-
u) u)
} -1-
1 H
O co 0) co N (D O 0 co co M,, 0 I
I co Z H O0 ca m 5 : u) QQQ J J VI- I .,
CLI-0011-< 0 O1H m O0 M < < OD'
Q
IM mien m CM71n a0 (D CD MIN
r O CljM
1-131) CN
M
IM MIM M'M M M M M!M M
O ❑ U`
e e e 7 \Ie eCc
e„...
,N (OD MIC .,
O� N O N'0 �� O
CO m00 J1d K WU)771"rim UIUu.1-1-
E
z
0.
U
OD O0 N (D :: H N I '
Q I Q
17 OMD J } 0, -, Q,
0 iNX m,
c •
v h • ° Z N
O1 coM 0 0
MIM N- co!
M
N V
U1 ZoU 10
❑I U 1
C Z 0 Y yi❑ ❑ N'' ❑�I C1
m'U IZ Y ❑: a m �IU U❑ �, •U 1011 1
U mI m �? c ❑IUI Z V•210:1 01 0 m U u1❑i ' ZI U'm'
t-2 0❑❑ m m 0'0,
'Y 0 0 ry m.2'1,121°,1 U Y
o LL ry U U ?vY' c o> U: o o c 0,,cl d u! C LL
ry w E S ry iml02 ry'IE E° ryc E ryl m'>'
Lu
c 'C 'c 0. `° m 1 m. m� r, Q m� m. Q W, 1 ' E' i
z' m m o> LL'w00 01110 o 01 0, 010121�'0 U
ry m' EY � �1 UCp CII: (n I E Y Y Y Q'Y'�-Y1 m C!]m ry m� o- E �'2 Q'2
c JI E! m m y 7 ry dJ _,J.- T c. c C d c ry c'J J'J c'0 J Q E _112•2!...!_,
r6'
' 012 01 co u) CO m o a E'SSI ry o o m' m col E om;a m 2 2 2 00 Li_ S El oI1 Z Z'Z 2
10,u_!0[0:1 > > ce 0) Jin[LL X13 I-i0iaa[ : m m�_1,miLL�LLILL O',LLILL,7,00
LLLL(t�,LLLL
.0
0
a)
m
E
a)
..
•
cO
(4 m. {L ! D.:.
!a)
�I N ry', 'U
•
• U 1.. • U (�7?1 c I,(_a y' N''
C 0 15 I S I SU'I m I ,e 'ill ai N '5 21 V)
, 0',> LLY T a)()',� c UaIOc Very
z la,'�`�
ma,00 oi''lpLvoU
•(oEma)E
c cop 0 .-1,-6:)(077 mUULLH71o oE amy'o O E> mo odEn
w! Y aIy
01c.4I
(01ca , 1 I F I •
Memorandum
Date: September 11, 2009
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find August 2009 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
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES:
Beg. Net Working Capital $ 6,050,000 $ 6,775,995
Revenues
Property Taxes 3,303,808 327,914
Gen. Rev. - excl. Taxes 486,910 735,607
Assessor 136,784 200,034
County Clerk 173,862 258,558
BOPTA 2,299 3,906
District Attorney 55,467 43,845
Finance/Tax 31,175 54,467
Veterans 11,699
Property Management 14,408 14,408
Grant Projects 333 334
$ 725,995
100% 112% $ 6,050,000 $ 6,775,995 $ 725,995
(2,975,894) 17%
248,697 17%
63,250 17%
84,696 17%
1,607 17%
(11,622) 17%
23,292 17%
(11,699) 17%
17%
1 17%
Total Revenues 4,216,745 1,639,073 (2,577,672) 17%
TOTAL RESOURCES 10,266,745 8,415,068 (1,851,677) 17%
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS 5,225,079 3,681,084 1,543,995 17%
NET (Resources - Requirements)
548,439 511,769 36,670 17%
243,451 179,142 64,309 17%
9,951 10,800 (849) 17%
764,544 715,032 49,512 17%
124,412 107,405 17,007 17%
37,617 35,134 2,483 17%
39,948 37,389 2,559 17%
17,612 16,902 710 17%
268,834 124,533 144,301 17%
1,015,786 1,015,786 17%
3,070,594 1,738,106 1,332,488 17%
2,154,485 1,942,978 211,507 17%
5,041,666 4,733,984 (307,682)
2%
25%
24%
25%
28%
13%
29%
0%
17%
17%
6%
a) 19,822,847
b) 2,921,462
c) 820,704
d) 1,043,171
c) 13,791
332,800
c) 187,049
70,192
86,450
2,000
19,822,847
2,921,462
820,704
1,043,171
13,791
332,800
187,049
70,192
86,450
2,000
25,300,466 25,300,466
27% 31,350,466 32,076,461 725,995
Exp. %
16%
12%
18%
16%
14%
16%
16%
16%
8%
0%
9%
15%
12%
a) Approximately 85% of the property taxes are collected in October and November
b) Includes annual PILT payment of $467,230.
c) Includes 1st Quarter A & T Grant: Assessor -$197,517, Tax -$46,518 and BOPTA -$3,906.
d) Significant foreclosure and refinancing recordings.
3,290,631
1,460,704
59,708
4,587,263
746,471
225,701
239,685
105,673
1,613,006
6,094,713
18,423,555
12, 926, 911
31,350,466
3,290,631
1,460,704
59,708
4,587,263
746,471
225,701
239,685
105,673
1,613,006
6,094,713
12,328,842 6,094,713
12,926,911
25,255,753 6,094,713
6,820,708 6,820,708
Year End
$
Budget
Projection
Variance
100% 112% $ 6,050,000 $ 6,775,995 $ 725,995
(2,975,894) 17%
248,697 17%
63,250 17%
84,696 17%
1,607 17%
(11,622) 17%
23,292 17%
(11,699) 17%
17%
1 17%
Total Revenues 4,216,745 1,639,073 (2,577,672) 17%
TOTAL RESOURCES 10,266,745 8,415,068 (1,851,677) 17%
REQUIREMENTS:
Expenditures
Assessor
County Clerk
BOPTA
District Attorney
Finance/Tax
Veterans
Property Management
Grant Projects
Non -Departmental
Contingency
Transfers Out
TOTAL REQUIREMENTS 5,225,079 3,681,084 1,543,995 17%
NET (Resources - Requirements)
548,439 511,769 36,670 17%
243,451 179,142 64,309 17%
9,951 10,800 (849) 17%
764,544 715,032 49,512 17%
124,412 107,405 17,007 17%
37,617 35,134 2,483 17%
39,948 37,389 2,559 17%
17,612 16,902 710 17%
268,834 124,533 144,301 17%
1,015,786 1,015,786 17%
3,070,594 1,738,106 1,332,488 17%
2,154,485 1,942,978 211,507 17%
5,041,666 4,733,984 (307,682)
2%
25%
24%
25%
28%
13%
29%
0%
17%
17%
6%
a) 19,822,847
b) 2,921,462
c) 820,704
d) 1,043,171
c) 13,791
332,800
c) 187,049
70,192
86,450
2,000
19,822,847
2,921,462
820,704
1,043,171
13,791
332,800
187,049
70,192
86,450
2,000
25,300,466 25,300,466
27% 31,350,466 32,076,461 725,995
Exp. %
16%
12%
18%
16%
14%
16%
16%
16%
8%
0%
9%
15%
12%
a) Approximately 85% of the property taxes are collected in October and November
b) Includes annual PILT payment of $467,230.
c) Includes 1st Quarter A & T Grant: Assessor -$197,517, Tax -$46,518 and BOPTA -$3,906.
d) Significant foreclosure and refinancing recordings.
3,290,631
1,460,704
59,708
4,587,263
746,471
225,701
239,685
105,673
1,613,006
6,094,713
18,423,555
12, 926, 911
31,350,466
3,290,631
1,460,704
59,708
4,587,263
746,471
225,701
239,685
105,673
1,613,006
6,094,713
12,328,842 6,094,713
12,926,911
25,255,753 6,094,713
6,820,708 6,820,708
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Two Months Ended August 31, 2009
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 5,296 (5,296) 17% 0% a) 31,775 31,775
SB #1065 -Court Assess. 10,000 7,800 (2,200) 17% 13% 60,000 60,000
Discovery Fee 2,667 1,938 (729) 17% 12% 16,000 16,000
Food Subsidy 5,000 2,322 (2,678) 17% 8% 30,000 30,000
OYA Basic & Diversion 55,408 (55,408) 17% 0% a) 332,450 332,450
Inmate/Prisoner Housing 10,000 21,750 11,750 17% 36% b) 60,000 80,000 20,000
Inmate Commissary Fees 133 - (133) 17% 0% 800 800
Contract Payments 34,690 717 (33,973) 17% 0% 208,141 208,141
Miscellaneous 50 (50) 17% 0% 300 300
MIP Diversion Fees 167 125 (42) 17% 13% 1,000 1,000
Interest on Investments 2,167 4,129 1,962 17% 32% 13,000 13,000
Leases 408 300 (108) 17% 12% 2,448 2,448
Grants - Private 110 110 17% n/a 110 110
Level 7 11,333 (11,333) 17% n/a a) 68,000 68,000
Crime Prevention Services 3,333 (3,333) 17% 0% a) 20,000 20,000
Total Revenues 140,652 39,191 (101,461) 17% 5% 843,914 864,024 20,110
Transfers In -General Fund 923,864 923,864 - 17% 17% 5,543,186 5,543,186
TOTAL RESOURCES 2,149,516 2,163,096 13,580 17% 29% 7,472,100 7,607,251 135,151
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
471,692 463,437 8,255 17% 16% 2,830,152 2,830,152
Materials and Services 220,350 141,603 78,747 17% 11% 1,322,097 1,322,097
Capital Outlay 17 17 17% 0% 100 100
Juvenile Resource Center
Personal Services 422,026 376,399 45,627 17% 15% 2,532,154 2,532,154
Materials and Services 30,817 42,942 (12,125) 17% 23% c) 184,903 184,903
Capital Outlay 17 17 17% 0% 100 100
Contingency 100,432 100,432 17% n/a 602,594
602,594
TOTAL REQUIREMENTS 1,245,351 1,024,381 220,970 17% 14% 7,472,100 6,869,506 602,594
NET (Resources - Requirements) 904,165 1,138,715 234,550
737,745 737,745
a) Reimbursements received quarterly.
b) Utilization of housing for juveniles by Crook County exceeding original estimations.
c) Negative variance due to an annual subscription payment and appliance purchase early in the fiscal year.
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 5,296 (5,296) 17% 0% a) 31,775 31,775
SB #1065 -Court Assess. 10,000 7,800 (2,200) 17% 13% 60,000 60,000
Discovery Fee 2,667 1,938 (729) 17% 12% 16,000 16,000
Food Subsidy 5,000 2,322 (2,678) 17% 8% 30,000 30,000
OYA Basic & Diversion 55,408 (55,408) 17% 0% a) 332,450 332,450
Inmate/Prisoner Housing 10,000 21,750 11,750 17% 36% b) 60,000 80,000 20,000
Inmate Commissary Fees 133 - (133) 17% 0% 800 800
Contract Payments 34,690 717 (33,973) 17% 0% 208,141 208,141
Miscellaneous 50 (50) 17% 0% 300 300
MIP Diversion Fees 167 125 (42) 17% 13% 1,000 1,000
Interest on Investments 2,167 4,129 1,962 17% 32% 13,000 13,000
Leases 408 300 (108) 17% 12% 2,448 2,448
Grants - Private 110 110 17% n/a 110 110
Level 7 11,333 (11,333) 17% n/a a) 68,000 68,000
Crime Prevention Services 3,333 (3,333) 17% 0% a) 20,000 20,000
Total Revenues 140,652 39,191 (101,461) 17% 5% 843,914 864,024 20,110
Transfers In -General Fund 923,864 923,864 - 17% 17% 5,543,186 5,543,186
TOTAL RESOURCES 2,149,516 2,163,096 13,580 17% 29% 7,472,100 7,607,251 135,151
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services
Exp. %
471,692 463,437 8,255 17% 16% 2,830,152 2,830,152
Materials and Services 220,350 141,603 78,747 17% 11% 1,322,097 1,322,097
Capital Outlay 17 17 17% 0% 100 100
Juvenile Resource Center
Personal Services 422,026 376,399 45,627 17% 15% 2,532,154 2,532,154
Materials and Services 30,817 42,942 (12,125) 17% 23% c) 184,903 184,903
Capital Outlay 17 17 17% 0% 100 100
Contingency 100,432 100,432 17% n/a 602,594
602,594
TOTAL REQUIREMENTS 1,245,351 1,024,381 220,970 17% 14% 7,472,100 6,869,506 602,594
NET (Resources - Requirements) 904,165 1,138,715 234,550
737,745 737,745
a) Reimbursements received quarterly.
b) Utilization of housing for juveniles by Crook County exceeding original estimations.
c) Negative variance due to an annual subscription payment and appliance purchase early in the fiscal year.
SHERIFF - Fund 255
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY °A)
CoII.
RESOURCES:
Beg. Net Working Capital $
Revenues
$ 183,677 $ 183,677 100%
n/a
$ - $ 183,677 p;, 183,677
Law Enf Dist Countywide 3,373,823 3,373,823 - 17% 17% 20,242,936 20,242,936
Law Enf Dist Rural 2,119,554 2,119,554 - 17% 17% 12,717,322 12,717,322
Interest 6,874 6,874 17% n/a 6,874 6,874
Total Revenues 5,493,377 5,500,251 6,874 17% 17% 32,960,258 32,967,132 6,874
TOTAL RESOURCES
5,493,377 5,683,928 190,551 17% 17% 32,960,258 33,150,809 190,551
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 326,865 356,785 (29,920) 17% 18% 1,961,188 1,961,088 100
Civil 121,160 129,210 (8,050) 17% 18% 726,961 726,961
Automotive/Communications 232,981 376,283 (143,302) 17% 27% a) 1,397,884 1,397,884
Investigations/Evidence 280,388 262,953 17,435 17% 16% 1,682,327 1,682,327
Patrol/Civil/Comm Supp 1,262,096 1,147,239 114,857 17% 15% b) 7,572,575 7,572,575
Records 107,061 101,751 5,310 17% 16% 642,363 642,263 100
Adult Jail 1,507,486 1,288,622 218,864 17% 14% b) 9,044,909 9,044,909
Court Security 35,985 32,325 3,660 17% 15% 215,908 215,808 100
Emergency Services 31,345 28,929 2,416 17% 15% 188,071 188,071
Special Services Division 184,782 180,293 4,489 17% 16% 1,108,690 1,108,690
Regional Work Center 456,307 377,282 79,025 17% 14% b) 2,737,842 2,737,742 100
Training Division 50,009 56,707 (6,698) 17% 19% 300,053 299,953 100
Other Law Enforcement Svcs 87,950 81,509 6,441 17% 15% 527,702 527,602 100
Non -Departmental 77,174 10,508 66,666 17% 2% 463,044 463,044
Contingency 641,790 641,790 17% n/a 3,850,741 - 3,850,741
Exp. %
Transfers Out 90,000 90,000 17% 0% 540,000 540,000
TOTAL REQUIREMENTS 5,493,379 4,430,396 1,062,983 17% 13% 32,960,258 29,108,917 3,851,341
NET (Resources - Requirements) (2) 1,253,532 1,253,534 - 4,041,892 4,041,892
a) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System.
b) Unfilled open positions resulting in Tess than planned personnel expenses.
Year End
Budget
Projection
Variance
$ - $ 183,677 p;, 183,677
Law Enf Dist Countywide 3,373,823 3,373,823 - 17% 17% 20,242,936 20,242,936
Law Enf Dist Rural 2,119,554 2,119,554 - 17% 17% 12,717,322 12,717,322
Interest 6,874 6,874 17% n/a 6,874 6,874
Total Revenues 5,493,377 5,500,251 6,874 17% 17% 32,960,258 32,967,132 6,874
TOTAL RESOURCES
5,493,377 5,683,928 190,551 17% 17% 32,960,258 33,150,809 190,551
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 326,865 356,785 (29,920) 17% 18% 1,961,188 1,961,088 100
Civil 121,160 129,210 (8,050) 17% 18% 726,961 726,961
Automotive/Communications 232,981 376,283 (143,302) 17% 27% a) 1,397,884 1,397,884
Investigations/Evidence 280,388 262,953 17,435 17% 16% 1,682,327 1,682,327
Patrol/Civil/Comm Supp 1,262,096 1,147,239 114,857 17% 15% b) 7,572,575 7,572,575
Records 107,061 101,751 5,310 17% 16% 642,363 642,263 100
Adult Jail 1,507,486 1,288,622 218,864 17% 14% b) 9,044,909 9,044,909
Court Security 35,985 32,325 3,660 17% 15% 215,908 215,808 100
Emergency Services 31,345 28,929 2,416 17% 15% 188,071 188,071
Special Services Division 184,782 180,293 4,489 17% 16% 1,108,690 1,108,690
Regional Work Center 456,307 377,282 79,025 17% 14% b) 2,737,842 2,737,742 100
Training Division 50,009 56,707 (6,698) 17% 19% 300,053 299,953 100
Other Law Enforcement Svcs 87,950 81,509 6,441 17% 15% 527,702 527,602 100
Non -Departmental 77,174 10,508 66,666 17% 2% 463,044 463,044
Contingency 641,790 641,790 17% n/a 3,850,741 - 3,850,741
Exp. %
Transfers Out 90,000 90,000 17% 0% 540,000 540,000
TOTAL REQUIREMENTS 5,493,379 4,430,396 1,062,983 17% 13% 32,960,258 29,108,917 3,851,341
NET (Resources - Requirements) (2) 1,253,532 1,253,534 - 4,041,892 4,041,892
a) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System.
b) Unfilled open positions resulting in Tess than planned personnel expenses.
RESOURCES:
Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 17% Na $ 2,470,519 $ 3,343,461 $ 872,942
Revenues
Tax Revenues - Current 2,469,951 - (2,469,951) 17% 0% a) 14,819,703 14,819,703
Tax Revenues - Prior 83,333 235,243 151,910 17% 47% 500,000 500,000
Federal Grants 5,833 600 (5,233) 17% 2% 35,000 35,000
State Grant 7,526 18,563 11,037 17% 41% 45,156 45,156
Transp. of State Wards 833 (833) 17% 0% 5,000 5,000
SB 1145 286,865 483,834 196,969 17% 28% b) 1,721,192 1,935,336 214,144
Des. Cty Video Lottery Grant 833 - (833) 17% n/a 5,000 5,000
Des Cty Court Security 21,500 21,425 (75) 17% 17% 129,000 129,000
Des Cty Juvenile Contract 500 (500) 17% 0% 3,000 3,000
Title III Reimbursement 25,000 (25,000) 17% n/a 150,000 150,000
Transport 333 1,318 985 17% n/a 2,000 2,000
DC Fair & Expo Center 1,695 1,695 17% n/a - 1,695 1,695
Inmate Commissary Fees 10,000 5,197 (4,803) 17% 9% 60,000 60,000
Work Center Work Crews 7,075 6,960 (115) 17% 16% 42,450 42,450
Concealed Handgun Classes 1,000 1,425 425 17% 24% 6,000 6,000
Soc Sec Incentive -Fed 833 2,000 1,167 17% 40% 5,000 5,000
Miscellaneous 667 305 (362) 17% 8% 4,000 4,000
Oregon Mentors 833 1,902 1,069 17% n/a 5,000 5,000
Medical Services Reimb 2,000 1,490 (510) 17% 12% 12,000 12,000
Restitution 175 324 149 17% 31% 1,050 1,050
Sheriff Fees 26,667 40,275 13,608 17% 25% 160,000 160,000
Interest 4,722 5,029 307 17% 18% 28,333 28,333
Interest on Unsegregated 589 181 (408) 17% 5% 3,533 3,533
Rentals 4,999 38,044 33,045 17% 127% c) 30,000 51,236 21,236
Donations 50 50 17% n/a 50 50
Total Revenues 2,962,067 865,860 (2,096,207) 17% 5% 17,772,417 18,009,542 237,125
SHERIFF 701
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY
Coll. %
TOTAL RESOURCES 5,432,586 4,209,321 (1,223,265)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,373,824 3,373,823
17%
21% 20,242,936 21,353,003 1,110,067
Exp. %
1 17% 17% 20,242,936 20,242,936
TOTAL REQUIREMENTS 3,373,824 3,373,823 1 17%
NET (Resources - Requirements)
17%
20,242,936 20,242,936
2,058,762 835,498 (1,223,264) - 1,110,067 1,110,067
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.
Year End
Budget ,
Projection
Variance
TOTAL RESOURCES 5,432,586 4,209,321 (1,223,265)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,373,824 3,373,823
17%
21% 20,242,936 21,353,003 1,110,067
Exp. %
1 17% 17% 20,242,936 20,242,936
TOTAL REQUIREMENTS 3,373,824 3,373,823 1 17%
NET (Resources - Requirements)
17%
20,242,936 20,242,936
2,058,762 835,498 (1,223,264) - 1,110,067 1,110,067
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.
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
Interest
Interest on Unsegregated
Grants - Private
Sale of Equip & Material
Total Revenues
TOTAL RESOURCES
SHERIFF 702
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual 1 Variance
FY %
Coll. %
$1,287,473 $ 1,433,708 $ 146,235
1,206,616 -
39,833 121,895
333 5,212
12,750
31,272 9,307
11,167 7,800
20,745
143,861 10,000
297,806 297,806
70,003 69,336
167
4,531 4,530
13,591 13,591
333
16,667
2,167 1,386
1,000 1,775
1,667 1,449
833 2,385
14,167 21,617
12,500 5,800
500
1,667 799
300 89
1,000
5,436
(1,206,616)
82,062
4,879
(12,750)
(21,965)
(3,367)
(20,745)
(133,861)
(667)
(167)
(1)
(333)
(16,667)
(781)
775
(218)
1,552
7,450
(6,700)
500
(868)
(211)
4,436
1,904,976 580,713 (1,324,263)
3,192,449 2,014,421 (1,178,028)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 2,119,554
2,119,554
TOTAL REQUIREMENTS 2,119,554 2,119,554
NET (Resources - Requirements)
17% n/a $ 1,287,473 $ 1,433,708 $ 146,235
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
0%
51%
261%
0%
5%
12%
0%
1%
17%
17%
0%
17%
17%
0%
n/a
11%
30%
14%
48%
25%
8%
n/a
8%
5%
n/a
91%
5%
a) 7,239,702
239,000
2,000
76,500
187,633
67,000
124,468
863,163
1,786,837
b) 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
7,239,702
239,000
5,212 3,212
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
10,000
1,800
6,000 6,000
11,429,849 11,429,562
(287)
17% 16% 12,717,322 12,863,270 145,948
- 17%
1,072,895 (105,133) (1,178,028)
Exp. %
17% 12,717,322 12,717,322
17% 17% 12,717,322 12,717,322
145,948 145,948
a) Approximately 85% of the property taxes are collected in October and November.
b) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
Year End
Budget
Projection
Variance
17% n/a $ 1,287,473 $ 1,433,708 $ 146,235
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
0%
51%
261%
0%
5%
12%
0%
1%
17%
17%
0%
17%
17%
0%
n/a
11%
30%
14%
48%
25%
8%
n/a
8%
5%
n/a
91%
5%
a) 7,239,702
239,000
2,000
76,500
187,633
67,000
124,468
863,163
1,786,837
b) 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
7,239,702
239,000
5,212 3,212
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
10,000
1,800
6,000 6,000
11,429,849 11,429,562
(287)
17% 16% 12,717,322 12,863,270 145,948
- 17%
1,072,895 (105,133) (1,178,028)
Exp. %
17% 12,717,322 12,717,322
17% 17% 12,717,322 12,717,322
145,948 145,948
a) Approximately 85% of the property taxes are collected in October and November.
b) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
RESOURCES:
Beg. Net Working Capital
Revenues
Medicare Reimbursement
State Grant
Child Dev & Rehab Center
State Miscellaneous
OMAP
Family Planning Exp Proj
Grants
Patient Insurance Fees
Health Dept/Patient Fees
Vital Records -Birth
Vital Records -Death
Interest on Investments
Donations
Interfund Contract
Administrative Fee
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
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355
667 - (667) 17% 0% 4,000 4,000
303,707 278,767 (24,940) 17% 15% a) 1,822,242 1,724,753 (97,489)
5,790 - (5,790) 17% 0% 34,737 34,737
35,540 10,152 (25,388) 17% 5% 213,240 213,240
50,500 39,234 (11,266) 17% 13% 303,000 303,000
79,167 54,168 (24,999) 17% 11% b) 475,000 475,000
21,833 21,833 17% n/a c) 21,833 21,833
22,300 18,743 (3,557) 17% 14% 133,800 133,800
25,358 23,912 (1,446) 17% 16% 152,150 152,150
6,000 5,990 (10) 17% 17% 36,000 36,000
16,333 19,360 3,027 17% 20% 98,000 98,000
6,333 3,399 (2,934) 17% 9% 38,000 38,000
1,467 1,518 51 17% 17% 8,800 8,800
21,962 (21,962) 17% 0% 131,774 131,774
4,500 4,500 17% 17% 27,000 27,000
579,624 481,576 (98,048) 17% 14% 3,477,743 3,402,087 (75,656)
4,167 (4,167) 17% 0% 25,000 25,000
386,294 386,294 17% 17% 2,317,765 2,317,765
1,870,085 1,988,225 122,307 17% 30% 6,720,508 6,865,207 144,699
Exp. %
737,922 679,223 58,699 17% 15% d) 4,427,529 4,227,991 199,538
238,062 201,626 36,436 17% 14% 1,428,371 1,428,371
2,817 2,817 17% 0% 16,902 16,902
25,000 25,000 17% 0% 150,000 150,000
116,284 116,284 17% n/a 697,706 697,706
1,120,085 880,849 239,236 17%
13%
6,720,508 5,823,264 897,244
750,000 1,107,376 361,543 - 1,041,943 1,041,943
a) State Grant projection adjusted to actual FY 2010 contract.
b) Payments are received one month in arrears.
c) Grants for HIV and Chronic Care were not included in FY 2010 budget.
d) Projection based on currently unfilled positions and anticipated reduction in budgeted FTE.
Year End
Budget
Projection
Variance
$ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355
667 - (667) 17% 0% 4,000 4,000
303,707 278,767 (24,940) 17% 15% a) 1,822,242 1,724,753 (97,489)
5,790 - (5,790) 17% 0% 34,737 34,737
35,540 10,152 (25,388) 17% 5% 213,240 213,240
50,500 39,234 (11,266) 17% 13% 303,000 303,000
79,167 54,168 (24,999) 17% 11% b) 475,000 475,000
21,833 21,833 17% n/a c) 21,833 21,833
22,300 18,743 (3,557) 17% 14% 133,800 133,800
25,358 23,912 (1,446) 17% 16% 152,150 152,150
6,000 5,990 (10) 17% 17% 36,000 36,000
16,333 19,360 3,027 17% 20% 98,000 98,000
6,333 3,399 (2,934) 17% 9% 38,000 38,000
1,467 1,518 51 17% 17% 8,800 8,800
21,962 (21,962) 17% 0% 131,774 131,774
4,500 4,500 17% 17% 27,000 27,000
579,624 481,576 (98,048) 17% 14% 3,477,743 3,402,087 (75,656)
4,167 (4,167) 17% 0% 25,000 25,000
386,294 386,294 17% 17% 2,317,765 2,317,765
1,870,085 1,988,225 122,307 17% 30% 6,720,508 6,865,207 144,699
Exp. %
737,922 679,223 58,699 17% 15% d) 4,427,529 4,227,991 199,538
238,062 201,626 36,436 17% 14% 1,428,371 1,428,371
2,817 2,817 17% 0% 16,902 16,902
25,000 25,000 17% 0% 150,000 150,000
116,284 116,284 17% n/a 697,706 697,706
1,120,085 880,849 239,236 17%
13%
6,720,508 5,823,264 897,244
750,000 1,107,376 361,543 - 1,041,943 1,041,943
a) State Grant projection adjusted to actual FY 2010 contract.
b) Payments are received one month in arrears.
c) Grants for HIV and Chronic Care were not included in FY 2010 budget.
d) Projection based on currently unfilled positions and anticipated reduction in budgeted FTE.
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Interest on Investments
Rentals
Donations
Interfund Contract
Administrative Fee
Comm. on Children & Fam
Crime Prevention Services
Total Revenues
Transfers In -General Fund
Transfers In -Other
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95%
917
20,833
333
16,637
768,540
30,786
50,118
17,667
11,667
6,800
41,250
1,917
5,333
2,750
500
520
505,826
3,667
21,167
1,670 753
22,172 1,339
10 (323)
(16,637)
302,846
(30,786)
(50,118)
- (17,667)
9,900 (1,767)
3,888 (2,912)
16,510 (24,740)
730 (1,187)
8,872 3,539
1,125 (1,625)
7,000 6,500
(520)
490,826 (15,000)
(3,667)
- (21,167)
1,071,386
1,507,228
219,360
42,606
1,634,089 126,861
219,360 -
60,522 17,916
4,494,194 4,503,967
1,191,542
675,586
13,333
25,000
317,897
1,155,716
366,565
9,773
$ 2,725,000 $ 2,589,996 $ (135,004)
17% 30% 5,500
17% 18% 125,000
17% 1% 2,000
17% 0% 99,819
17% 23% a) 4,611,239
17% 0% 184,716
17% 0% 300,705
17% 0% 106,000
17% 14% 70,000
17% 10% 40,800
17% 7% 247,500
17% 6% 11,500
17% 28% 32,000
17% 7% 16,500
17% 233% 3,000
17% 0% 3,120
17% 16% 3,034,954
17% 0% 22,000
17% 0% 127,000
5,500
125,000
2,000
99,819
5,351,224 739,985
184,716
300,705
106,000
70,000
40,800
247,500
11,500
32,000
16,500
7,000 4,000
3,120
3,031,954 (3,000)
22,000
127,000
17% 18% 9,043,353
17% 17% 1,316,158
17% 24% 255,636
17%
9,784,338 740,985
1,316,158
363,129 107,493
34% 13,340,147 14,053,621 713,474
Exp. %
35,826 17% 16% 7,149,249 7,149,249
309,021 17% 9% 4,053,514 4,053,514
13,333 17% 0% 80,000 80,000
25,000 17% 0% 150,000 150,000
317,897 17% n/a 1,907,384 1,907,384
2,223,358
1,522,281 701,077
2,270,836 2,981,686 710,850
a) Dept of Human Services Grant projected at amended contract for FY 2010.
17% 11% 13,340,147 11,432,763 1,907,384
- 2,620,858 2,620,858
Year End
Budget
Projection
Variance
$ 2,725,000 $ 2,589,996 $ (135,004)
17% 30% 5,500
17% 18% 125,000
17% 1% 2,000
17% 0% 99,819
17% 23% a) 4,611,239
17% 0% 184,716
17% 0% 300,705
17% 0% 106,000
17% 14% 70,000
17% 10% 40,800
17% 7% 247,500
17% 6% 11,500
17% 28% 32,000
17% 7% 16,500
17% 233% 3,000
17% 0% 3,120
17% 16% 3,034,954
17% 0% 22,000
17% 0% 127,000
5,500
125,000
2,000
99,819
5,351,224 739,985
184,716
300,705
106,000
70,000
40,800
247,500
11,500
32,000
16,500
7,000 4,000
3,120
3,031,954 (3,000)
22,000
127,000
17% 18% 9,043,353
17% 17% 1,316,158
17% 24% 255,636
17%
9,784,338 740,985
1,316,158
363,129 107,493
34% 13,340,147 14,053,621 713,474
Exp. %
35,826 17% 16% 7,149,249 7,149,249
309,021 17% 9% 4,053,514 4,053,514
13,333 17% 0% 80,000 80,000
25,000 17% 0% 150,000 150,000
317,897 17% n/a 1,907,384 1,907,384
2,223,358
1,522,281 701,077
2,270,836 2,981,686 710,850
a) Dept of Human Services Grant projected at amended contract for FY 2010.
17% 11% 13,340,147 11,432,763 1,907,384
- 2,620,858 2,620,858
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 413,471 $ 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188
Revenues
Admin -Operations 608 4,261 3,653 17% 117% a) 3,650 13,000 9,350
Admin -GIS 346 60 (286) 17% 3% b) 2,075 500 (1,575)
Admin -Code Enforcement 31,575 28,411 (3,165) 17% 15% c) 189,450 178,000 (11,450)
Building Safety 162,463 152,205 (10,258) 17% 16% c) 974,775 941,000 (33,775)
Electrical 46,750 50,847 4,097 17% 18% d) 280,500 301,600 21,100
Contract Services 42,583 14,277 (28,306) 17% 6% e) 255,500 178,300 (77,200)
Env Health -On Site Prog 48,808 39,400 (9,408) 17% 13% c) 292,850 271,600 (21,250)
Env Health-Lic Facilities 115,079 44,385 (70,694) 17% 6% f) 690,475 690,475
Env Health - Drinking H2O 15,885 (15,885) 17% 0% g) 95,311 95,311
Planning -Current 164,025 167,948 3,923 17% 17% d) 984,150 1,161,100 176,950
Planning -Long Range 71,483 38,467 (33,016) 17% 9% 428,900 423,000 (5,900)
Total Revenues
699,605 540,261 (159,344) 17% 13% 4,197,636 4,253,886 56,250
Trans In -GF 202,771 202,772 1 0% n/a 1,216,627 1,216,627
Trans In -GF for Lng Rng Ping 50,000 (50,000) 0% n/a 300,000 300,000
Trans In -Other 17 (17) 0% 0% 100 (100)
TOTAL RESOURCES 1,365,864 1,372,691 6,827 17% 22% 6,127,834 6,400,172 272,338
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations 284,685 280,451 4,234 17% 16% 1,708,112 1,708,112 -
Admin -GIS 35,934 33,619 2,315 17% 16% h) 215,606 178,431 37,175
Admin -Code Enforcement 30,162 29,043 1,119 17% 16% 180,969 180,969 -
Building Safety 120,858 116,845 4,013 17% 16% 725,145 725,145
Electrical 34,453 32,627 1,826 17% 16% 206,719 206,719
Contract Services 44,130 42,100 2,030 17% 16% 264,781 264,781
Env Health -On Site Pgm 40,115 38,110 2,005 17% 16% 240,687 240,687
Env Health-Lic Facilities 82,658 82,072 586 17% 17% 495,946 495,946
Env Health - Drinking H2O 13,433 12,963 470 17% 16% 80,598 80,598
Planning -Current 134,964 117,636 17,328 17% 15% 809,783 809,783
Planning -Long Range 91,971 67,876 24,095 17% 12% 551,828 551,828
Transfers Out (D/S Fund) 29,610 29,610 0% 0% 177,660 177,660
Contingency 78,333 78,333 17% n/a 470,000 470,000
Exp. %
TOTAL REQUIREMENTS 1,021,306 853,342 167,964 17% 14% 6,127,834 5,620,659 507,175
NET (Resources - Requirements)
344,558 519,349 174,791 779,513 779,513
Revenues 540,261 4,253,886
Expenditures 853,342 5,620,659
Net from Operations (313,081) (1,366,773)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance.
b) Payments for custom GIS work are received as work is requested.
c) June 2009 revenue was lower than expected, affecting Y -T -D figures.
d) Business volume and revenue have thus far exceeded expectations.
e) Revenue is received as clients are billed, usually lagging 1-2 months behind.
f) Revenue is received primarily in December through February after license renewal statements are mailed out.
g) Payments from State DHS have not yet been received.
h) From 9/1/09 on, Sr. Web Applications Programmer will work half time for IT and half time for CDD.
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 608 4,261 3,653 17% 117% a) 3,650 13,000 9,350
Admin -GIS 346 60 (286) 17% 3% b) 2,075 500 (1,575)
Admin -Code Enforcement 31,575 28,411 (3,165) 17% 15% c) 189,450 178,000 (11,450)
Building Safety 162,463 152,205 (10,258) 17% 16% c) 974,775 941,000 (33,775)
Electrical 46,750 50,847 4,097 17% 18% d) 280,500 301,600 21,100
Contract Services 42,583 14,277 (28,306) 17% 6% e) 255,500 178,300 (77,200)
Env Health -On Site Prog 48,808 39,400 (9,408) 17% 13% c) 292,850 271,600 (21,250)
Env Health-Lic Facilities 115,079 44,385 (70,694) 17% 6% f) 690,475 690,475
Env Health - Drinking H2O 15,885 (15,885) 17% 0% g) 95,311 95,311
Planning -Current 164,025 167,948 3,923 17% 17% d) 984,150 1,161,100 176,950
Planning -Long Range 71,483 38,467 (33,016) 17% 9% 428,900 423,000 (5,900)
Total Revenues
699,605 540,261 (159,344) 17% 13% 4,197,636 4,253,886 56,250
Trans In -GF 202,771 202,772 1 0% n/a 1,216,627 1,216,627
Trans In -GF for Lng Rng Ping 50,000 (50,000) 0% n/a 300,000 300,000
Trans In -Other 17 (17) 0% 0% 100 (100)
TOTAL RESOURCES 1,365,864 1,372,691 6,827 17% 22% 6,127,834 6,400,172 272,338
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations 284,685 280,451 4,234 17% 16% 1,708,112 1,708,112 -
Admin -GIS 35,934 33,619 2,315 17% 16% h) 215,606 178,431 37,175
Admin -Code Enforcement 30,162 29,043 1,119 17% 16% 180,969 180,969 -
Building Safety 120,858 116,845 4,013 17% 16% 725,145 725,145
Electrical 34,453 32,627 1,826 17% 16% 206,719 206,719
Contract Services 44,130 42,100 2,030 17% 16% 264,781 264,781
Env Health -On Site Pgm 40,115 38,110 2,005 17% 16% 240,687 240,687
Env Health-Lic Facilities 82,658 82,072 586 17% 17% 495,946 495,946
Env Health - Drinking H2O 13,433 12,963 470 17% 16% 80,598 80,598
Planning -Current 134,964 117,636 17,328 17% 15% 809,783 809,783
Planning -Long Range 91,971 67,876 24,095 17% 12% 551,828 551,828
Transfers Out (D/S Fund) 29,610 29,610 0% 0% 177,660 177,660
Contingency 78,333 78,333 17% n/a 470,000 470,000
Exp. %
TOTAL REQUIREMENTS 1,021,306 853,342 167,964 17% 14% 6,127,834 5,620,659 507,175
NET (Resources - Requirements)
344,558 519,349 174,791 779,513 779,513
Revenues 540,261 4,253,886
Expenditures 853,342 5,620,659
Net from Operations (313,081) (1,366,773)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance.
b) Payments for custom GIS work are received as work is requested.
c) June 2009 revenue was lower than expected, affecting Y -T -D figures.
d) Business volume and revenue have thus far exceeded expectations.
e) Revenue is received as clients are billed, usually lagging 1-2 months behind.
f) Revenue is received primarily in December through February after license renewal statements are mailed out.
g) Payments from State DHS have not yet been received.
h) From 9/1/09 on, Sr. Web Applications Programmer will work half time for IT and half time for CDD.
ROAD
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 4,871,665
Revenues
Federal Reimbursements 81,667
Mineral Lease Royalties 1,667
Forest Receipts 413,667
State Grant 69,246
Motor Vehicle Revenue 1,333,333
City of Bend 37,500
City of Redmond 41,667
City of Sisters 1,667
City of La Pine 1,667
Admin Recovery (SDC) 83
Miscellaneous 21,667
Road Vacations 167
Interest on Investments 8,333
Other Bank/LGIP Interest
Interfund Contract 116,667
Equipment Repairs 45,833
Vehicle Repairs 15,000
Vegetation Management 5,833
Inter -fund: Forester 3,667
Car Washes 417
Sale of Eqp & Material 133,333
$ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
- (81,667)
2,973 1,306
(413,667)
(69,246)
(232,943)
(37,500)
(41,667)
(1,667)
- (1,667)
249 166
9,385 (12,282)
(167)
6,500
129 129
- (116,667)
(29,675)
(15,000)
(5,833)
- (3,667)
(417)
(94,943)
1,100,390
14,833
16,158
38,390
Total Revenues 2,333,081
Trans In - CDD
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
3,032
118,095
12,500
1,667
1,182,507 (1,150,574)
(3,032)
(118,095)
(12,500)
(1,667)
TOTAL RESOURCES 7,327,540
REQUIREMENTS:
Expenditures
Personal Services 944,229
Materials and Services 1,522,202
Capital Outlay 450,000
Transfers Out 66,667
Contingency 297,219
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
0%
30%
0% a)
0%
14%
0% b)
0% b)
0% b)
n/a b)
n/a
7%
0%
30%
n/a
0% c)
6%
0% c)
0% c)
0% c)
0%
5%
490,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
700,000
275,000
90,000
35,000
22,000
2,500
800,000
490,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
129
700,000
275,000
90,000
35,000
22,000
2,500
800,000
129
8% 13,998,477 13,998,606
18,190
708,567
75,000
10,000
18,190
708,567
75,000
10,000
129
6,074,156 (1,253,384) 17% 37% 19,681,899 19,702,012 20,113
882,883
1,074,094
34,502
61,346
448,108
415,498
66,667
297,219
Exp. %
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
TOTAL REQUIREMENTS 3,280,317 1,991,479 1,288,838 17% 10% 19,681,899 17,898,583 1,783,316
NET (Resources - Requirements) 4,047,223 4,082,677 35,454
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, 430 .
d) Payment received quarterly from Solid Waste.
1,803,429 1,803,429
Year End
Budget
Projection
Variance
$ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
- (81,667)
2,973 1,306
(413,667)
(69,246)
(232,943)
(37,500)
(41,667)
(1,667)
- (1,667)
249 166
9,385 (12,282)
(167)
6,500
129 129
- (116,667)
(29,675)
(15,000)
(5,833)
- (3,667)
(417)
(94,943)
1,100,390
14,833
16,158
38,390
Total Revenues 2,333,081
Trans In - CDD
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
3,032
118,095
12,500
1,667
1,182,507 (1,150,574)
(3,032)
(118,095)
(12,500)
(1,667)
TOTAL RESOURCES 7,327,540
REQUIREMENTS:
Expenditures
Personal Services 944,229
Materials and Services 1,522,202
Capital Outlay 450,000
Transfers Out 66,667
Contingency 297,219
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
17%
0%
30%
0% a)
0%
14%
0% b)
0% b)
0% b)
n/a b)
n/a
7%
0%
30%
n/a
0% c)
6%
0% c)
0% c)
0% c)
0%
5%
490,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
700,000
275,000
90,000
35,000
22,000
2,500
800,000
490,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
129
700,000
275,000
90,000
35,000
22,000
2,500
800,000
129
8% 13,998,477 13,998,606
18,190
708,567
75,000
10,000
18,190
708,567
75,000
10,000
129
6,074,156 (1,253,384) 17% 37% 19,681,899 19,702,012 20,113
882,883
1,074,094
34,502
61,346
448,108
415,498
66,667
297,219
Exp. %
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
TOTAL REQUIREMENTS 3,280,317 1,991,479 1,288,838 17% 10% 19,681,899 17,898,583 1,783,316
NET (Resources - Requirements) 4,047,223 4,082,677 35,454
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, 430 .
d) Payment received quarterly from Solid Waste.
1,803,429 1,803,429
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Two Months Ended August 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 1,333 (1,333) 17% 0% a) 8,000 4,301 (3,699)
State Subsidy 4,917 3,327 (1,590) 17% n/a 29,500 29,500
SB 1145 473,321 725,750 252,429 17% 26% b) 2,839,925 2,839,925
Probation Work Crew Fees 6,667 4,511 (2,156) 17% 11% c) 40,000 40,000
Miscellaneous 500 1,596 1,096 17% 53% d) 3,000 3,000
Electronic Monitoring Fee 26,667 23,468 (3,199) 17% 15% 160,000 160,000
Probation Superv. Fees 36,667 38,609 1,942 17% 18% 220,000 220,000
Interest on Investments 1,500 2,602 1,102 17% 29% 9,000 9,000
Crime Prevention Services 8,333 (8,333) 17% n/a 50,000 50,000
Total Revenues 559,905 799,863 239,958 17% 24% 3,359,425 3,355,726 (3,699)
Transfers In -General Fund 19,172 19,172 - 17% 17% 115,029 115,029
Transfers In -Sheriff 8,333 (8,333) 17% 0% 50,000 50,000
TOTAL RESOURCES 1,055,302 1,306,709 251,407 17% 33% 3,992,346 4,008,429 16,083
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
476,454 456,691 19,763 17% 16% 2,858,726 2,858,726
117,354 98,865 18,489 17% 14% 704,121 704,121
17 17 17% 0% 100 100
71,567 71,567 17% n/a 429,399
429,399
TOTAL REQUIREMENTS 665,392 555,556 109,836 17% 14% 3,992,346 3,562,947 429,399
NET (Resources - Requirements)
389,910 751,153 361,243
445,482 445,482
a) Have not received the hearings officer funds for this quarter. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301.
b) 1145 money has been received for the quarter.
c) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients.
d) Increase in DMV Letters and transfer collections.
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 1,333 (1,333) 17% 0% a) 8,000 4,301 (3,699)
State Subsidy 4,917 3,327 (1,590) 17% n/a 29,500 29,500
SB 1145 473,321 725,750 252,429 17% 26% b) 2,839,925 2,839,925
Probation Work Crew Fees 6,667 4,511 (2,156) 17% 11% c) 40,000 40,000
Miscellaneous 500 1,596 1,096 17% 53% d) 3,000 3,000
Electronic Monitoring Fee 26,667 23,468 (3,199) 17% 15% 160,000 160,000
Probation Superv. Fees 36,667 38,609 1,942 17% 18% 220,000 220,000
Interest on Investments 1,500 2,602 1,102 17% 29% 9,000 9,000
Crime Prevention Services 8,333 (8,333) 17% n/a 50,000 50,000
Total Revenues 559,905 799,863 239,958 17% 24% 3,359,425 3,355,726 (3,699)
Transfers In -General Fund 19,172 19,172 - 17% 17% 115,029 115,029
Transfers In -Sheriff 8,333 (8,333) 17% 0% 50,000 50,000
TOTAL RESOURCES 1,055,302 1,306,709 251,407 17% 33% 3,992,346 4,008,429 16,083
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
476,454 456,691 19,763 17% 16% 2,858,726 2,858,726
117,354 98,865 18,489 17% 14% 704,121 704,121
17 17 17% 0% 100 100
71,567 71,567 17% n/a 429,399
429,399
TOTAL REQUIREMENTS 665,392 555,556 109,836 17% 14% 3,992,346 3,562,947 429,399
NET (Resources - Requirements)
389,910 751,153 361,243
445,482 445,482
a) Have not received the hearings officer funds for this quarter. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301.
b) 1145 money has been received for the quarter.
c) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients.
d) Increase in DMV Letters and transfer collections.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 37,500 (37,500) 17% 0% 225,000 225,000
Title IV- Family Sup/Pres 6,275 (6,275) 17% 0% a) 37,652 36,179 (1,473)
HealthyStart Medicaid 15,833 (15,833) 17% 0% 95,000 95,000
Child Care Block Grant 13,546 - (13,546) 17% 0% a) 81,275 (81,275)
Level 7 Services 29,199 (29,199) 17% 0% a) 175,193 202,098 26,905
HealthyStart /R -S -G 51,263 (51,263) 17% 0% a) 307,577 371,338 63,761
OCCF Grant 102,342 (102,342) 17% 0% a) 614,052 513,499 (100,553)
Miscellaneous1,333 482 (851) 17% 6% 8,000 8,000
Court Fines & Fees
12,500 13,303 803 17% 18% 75,000 75,000
Interest on Investments5,000 1,949 (3,051) 17% 6% 30,000 30,000
Grants -Private 333(333) 17% 0% 2,000 2,000
Miscellaneous 31,250 20,000 (11,250) 17% n/a 187,500 187,500
Crime Prevention Services12,392 (12,392) 17% 0% 74,350 74,350
Total Revenues 318,766 35,734 (283,032) 17% 2% 1,912,599 1,819,964 (92,635)
Trans from General Fund 47,389 47,388 (1) 17% 17% 284,333 284,333
Total Transfers In
47,389 47,388 (1) 17% 17% 284,333 284,333
TOTAL RESOURCES 990,698 751,748 (238,950) 17% 27% 2,821,475 2,772,923 (48,552)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
89,996 78,782 11,214 17% 15% b) 539,978 494,522 45,456
295,841 49,349 246,492 17% 3% 1,775,043 1,775,043
17 17 17% 0% 100 100
84,392 84,392 17% n/a 506,354 506,354
TOTAL REQUIREMENTS 470,246 128,131 342,115 17% 5% 2,821,475 2,269,665 551,810
NET (Resources - Requirements) 520,452 623,617 103,165 503,258 503,258
a) Revenue projections adjusted to actual resulting from final legislative allocations.
b) Personnel projection reduced due to two positions open in 1st quarter.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 37,500 (37,500) 17% 0% 225,000 225,000
Title IV- Family Sup/Pres 6,275 (6,275) 17% 0% a) 37,652 36,179 (1,473)
HealthyStart Medicaid 15,833 (15,833) 17% 0% 95,000 95,000
Child Care Block Grant 13,546 - (13,546) 17% 0% a) 81,275 (81,275)
Level 7 Services 29,199 (29,199) 17% 0% a) 175,193 202,098 26,905
HealthyStart /R -S -G 51,263 (51,263) 17% 0% a) 307,577 371,338 63,761
OCCF Grant 102,342 (102,342) 17% 0% a) 614,052 513,499 (100,553)
Miscellaneous1,333 482 (851) 17% 6% 8,000 8,000
Court Fines & Fees
12,500 13,303 803 17% 18% 75,000 75,000
Interest on Investments5,000 1,949 (3,051) 17% 6% 30,000 30,000
Grants -Private 333(333) 17% 0% 2,000 2,000
Miscellaneous 31,250 20,000 (11,250) 17% n/a 187,500 187,500
Crime Prevention Services12,392 (12,392) 17% 0% 74,350 74,350
Total Revenues 318,766 35,734 (283,032) 17% 2% 1,912,599 1,819,964 (92,635)
Trans from General Fund 47,389 47,388 (1) 17% 17% 284,333 284,333
Total Transfers In
47,389 47,388 (1) 17% 17% 284,333 284,333
TOTAL RESOURCES 990,698 751,748 (238,950) 17% 27% 2,821,475 2,772,923 (48,552)
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
89,996 78,782 11,214 17% 15% b) 539,978 494,522 45,456
295,841 49,349 246,492 17% 3% 1,775,043 1,775,043
17 17 17% 0% 100 100
84,392 84,392 17% n/a 506,354 506,354
TOTAL REQUIREMENTS 470,246 128,131 342,115 17% 5% 2,821,475 2,269,665 551,810
NET (Resources - Requirements) 520,452 623,617 103,165 503,258 503,258
a) Revenue projections adjusted to actual resulting from final legislative allocations.
b) Personnel projection reduced due to two positions open in 1st quarter.
SOLID WASTE
Statement of Financial Operating Data
Two Months Ended August 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
Miscellaneous 5,000 4,967 (33) 17% 17% 30,000 30,000
Franchise 3% Fees 33,333 5,532 (27,801) 17% 3% a) 200,000 200,000
Commercial Disp. Fees 232,733 170,288 (62,445) 17% 12% 1,396,400 1,396,400
Private Disposal Fees 256,883 294,340 37,457 17% 19% 1,541,300 1,541,300
Franchise Disposal Fees 790,583 771,165 (19,418) 17% 16% 4,743,500 4,743,500 -
Yard Debris 12,500 16,287 3,787 17% 22% 75,000 75,000
Special Waste 5,000 102 (4,898) 17% 0% b) 30,000 30,000
Interest 2,333 3,085 752 17% 22% 14,000 14,000
Recyclables 2,525 2,525 17% n/a c) 35,000 35,000
Sale of Equip & Material 5,833 (5,833) 17% 0% d) 35,000 (35,000)
Total Revenues 1,344,198 1,268,291 (75,907) 17% 16% 8,065,200 8,065,200
TOTAL RESOURCES 1,682,809 1,734,616 51,807 17% 21% 8,403,811 8,531,525 127,714
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
293,930 275,055 18,875 17% 16% 1,763,578 1,763,578
624,709 394,525 230,184 17% 11% e) 3,748,254 3,748,254
161,461 161,461 17% 0% f) 968,765 968,765
24,833 24,833 17% 0% g) 149,000 149,000
239,961 239,961 17% 0% 1,439,767 1,439,767
55,741 55,741 17% n/a 334,447 - 334,447
TOTAL REQUIREMENTS 1,400,635 669,580 731,055 17% 8% 8,403,811 8,069,364 334,447
NET (Resources - Requirements) 282,174 1,065,036 782,862 462,161 462,161
a) Due April 15, 2010.
b) Contaminated soil and asbestos loads are intermittent.
c) Recycling market prices are low at this time.
d) Budgeted dollars reflected recycling revenue. We do not expect any asset sales this year.
e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY.
f) Payments are scheduled for Nov and May.
g) 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
Miscellaneous 5,000 4,967 (33) 17% 17% 30,000 30,000
Franchise 3% Fees 33,333 5,532 (27,801) 17% 3% a) 200,000 200,000
Commercial Disp. Fees 232,733 170,288 (62,445) 17% 12% 1,396,400 1,396,400
Private Disposal Fees 256,883 294,340 37,457 17% 19% 1,541,300 1,541,300
Franchise Disposal Fees 790,583 771,165 (19,418) 17% 16% 4,743,500 4,743,500 -
Yard Debris 12,500 16,287 3,787 17% 22% 75,000 75,000
Special Waste 5,000 102 (4,898) 17% 0% b) 30,000 30,000
Interest 2,333 3,085 752 17% 22% 14,000 14,000
Recyclables 2,525 2,525 17% n/a c) 35,000 35,000
Sale of Equip & Material 5,833 (5,833) 17% 0% d) 35,000 (35,000)
Total Revenues 1,344,198 1,268,291 (75,907) 17% 16% 8,065,200 8,065,200
TOTAL RESOURCES 1,682,809 1,734,616 51,807 17% 21% 8,403,811 8,531,525 127,714
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
293,930 275,055 18,875 17% 16% 1,763,578 1,763,578
624,709 394,525 230,184 17% 11% e) 3,748,254 3,748,254
161,461 161,461 17% 0% f) 968,765 968,765
24,833 24,833 17% 0% g) 149,000 149,000
239,961 239,961 17% 0% 1,439,767 1,439,767
55,741 55,741 17% n/a 334,447 - 334,447
TOTAL REQUIREMENTS 1,400,635 669,580 731,055 17% 8% 8,403,811 8,069,364 334,447
NET (Resources - Requirements) 282,174 1,065,036 782,862 462,161 462,161
a) Due April 15, 2010.
b) Contaminated soil and asbestos loads are intermittent.
c) Recycling market prices are low at this time.
d) Budgeted dollars reflected recycling revenue. We do not expect any asset sales this year.
e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY.
f) Payments are scheduled for Nov and May.
g) 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
RISK MANAGEMENT
Statement of Financial Operating Data
Two Months Ended August 31, 2009
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
76,161 76,157 (4) 17% 17% 456,964 456,964
47,716 47,684 (32) 17% 17% 286,294 286,294
30,699 30,699 (0) 17% 17% 184,195 184,195
142,642 142,640 (2) 17% 17% 855,854 855,854
26,699 26,701 3 17% 17% 160,191 160,191
4,167 (4,167) 17% 0% 25,000 25,000
1,667 1,270 (397) 17% 13% 10,000 10,000
150 245 95 17% 27% 900 900
667 12 (655) 17% 0% 4,000 4,000
3,667 490 (3,177) 17% 2% 22,000 22,000
5,000 8,334 3,334 17% 28% 30,000 30,000
339,233 334,232 (5,001) 17% 16% 2,035,398 2,035,398
Transfers In -PERS Reserve 17 (17) 17% 0% 100 (100)
TOTAL RESOURCES 2,831,227 3,003,523 172,296 17% 66% 4,527,475 4,704,689 177,214
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit 4,183
Defense 974
Miscellaneous
Professional Service -
Insurance 1,418
Loss Prevention 13
Repair / Replacement 299
Total General Liability 60,852 6,887 60,852 17% 2% 365,112 365,112
PROPERTY DAMAGE
Insurance
Professional Service
Repair / Replacement 15,103
Total Property Damage 50,000 15,103 50,000 17% 5% 300,000 290,000 10,000
VEHICLE
Professional Service 240
Insurance 411
Loss Prevention 184
Repair / Replacement 2,474
Total Vehicle 20,000 3,309 20,000 17% 3% 120,000 115,000 5,000
WORKERS' COMPENSATION
Settlement / Benefit 83,494
Professional Service
Insurance 61,773
Loss Prevention 636
Miscellaneous -
Workers' Comp Losses -
Total Workers' Compensation 103,333 145,903 103,333 17% 24% 620,000 630,000 (10,000)
UNEMPLOYMENT - Settlement / Benefits 23,333 - 23,333 17% 0% 140,000 145,000 (5,000)
Total Direct Insurance Costs 257,519 171,201 257,519 17% 11% 1,545,112 1,545,112
Insurance Administration:
Personal Services 45,672 44,996 676 17% 16% 274,034 274,034
Materials & Service 41,082 31,026 10,056 17% 13% 246,493 246,493
Capital Outlay 17 17 17% 0% 100 100
Total Insurance Administration 86,771 76,022 10,749 17% 15% 520,627 520,527 100
1 % Exp.
Contingency 410,289 - 410,289 17% n/a 2,461,736 - 2,461,736
TOTAL APPROPRIATIONS/EXPENDITURES 754,579 247,223 678,557 17% 5% 4,527,475 2,065,639 2,461,836
NET 2,076,648 2,756,300 850,854 2,639,050 2,639,050
Year End
Budget
Projection
Variance
$2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314
76,161 76,157 (4) 17% 17% 456,964 456,964
47,716 47,684 (32) 17% 17% 286,294 286,294
30,699 30,699 (0) 17% 17% 184,195 184,195
142,642 142,640 (2) 17% 17% 855,854 855,854
26,699 26,701 3 17% 17% 160,191 160,191
4,167 (4,167) 17% 0% 25,000 25,000
1,667 1,270 (397) 17% 13% 10,000 10,000
150 245 95 17% 27% 900 900
667 12 (655) 17% 0% 4,000 4,000
3,667 490 (3,177) 17% 2% 22,000 22,000
5,000 8,334 3,334 17% 28% 30,000 30,000
339,233 334,232 (5,001) 17% 16% 2,035,398 2,035,398
Transfers In -PERS Reserve 17 (17) 17% 0% 100 (100)
TOTAL RESOURCES 2,831,227 3,003,523 172,296 17% 66% 4,527,475 4,704,689 177,214
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit 4,183
Defense 974
Miscellaneous
Professional Service -
Insurance 1,418
Loss Prevention 13
Repair / Replacement 299
Total General Liability 60,852 6,887 60,852 17% 2% 365,112 365,112
PROPERTY DAMAGE
Insurance
Professional Service
Repair / Replacement 15,103
Total Property Damage 50,000 15,103 50,000 17% 5% 300,000 290,000 10,000
VEHICLE
Professional Service 240
Insurance 411
Loss Prevention 184
Repair / Replacement 2,474
Total Vehicle 20,000 3,309 20,000 17% 3% 120,000 115,000 5,000
WORKERS' COMPENSATION
Settlement / Benefit 83,494
Professional Service
Insurance 61,773
Loss Prevention 636
Miscellaneous -
Workers' Comp Losses -
Total Workers' Compensation 103,333 145,903 103,333 17% 24% 620,000 630,000 (10,000)
UNEMPLOYMENT - Settlement / Benefits 23,333 - 23,333 17% 0% 140,000 145,000 (5,000)
Total Direct Insurance Costs 257,519 171,201 257,519 17% 11% 1,545,112 1,545,112
Insurance Administration:
Personal Services 45,672 44,996 676 17% 16% 274,034 274,034
Materials & Service 41,082 31,026 10,056 17% 13% 246,493 246,493
Capital Outlay 17 17 17% 0% 100 100
Total Insurance Administration 86,771 76,022 10,749 17% 15% 520,627 520,527 100
1 % Exp.
Contingency 410,289 - 410,289 17% n/a 2,461,736 - 2,461,736
TOTAL APPROPRIATIONS/EXPENDITURES 754,579 247,223 678,557 17% 5% 4,527,475 2,065,639 2,461,836
NET 2,076,648 2,756,300 850,854 2,639,050 2,639,050
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Two Months Ended August 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 1,021,797 - (1,021,797) 17%
Property Taxes - Prior 16,667 86,656 69,989 17%
State Reimbursement 4,083 1,167 (2,916) 17%
Telephone User Tax 89,333 (89,333) 17%
Data Network Reimb. 5,667 20,240 14,573 17%
Jefferson County 4,667 4,496 (171) 17%
User Fee 10,083 875 (9,208) 17%
Contract Payments 11,667 23,978 12,311 17%
Miscellaneous 1,417 1,220 (197) 17%
Interest 6,000 15,793 9,793 17%
Interest on Unsegregated Tax 625 75 (550) 17%
Total Revenues 1,172,006 154,500 (1,017,506) 17%
Transfers In -Other 17 (17) 17%
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
0% a) 6,130,782 6,130,782
87% 100,000 100,000
5% b) 24,500 24,500
0% 536,000 536,000
60% c) 34,000 27,880 (6,120)
16% 28,000 28,000
1% d) 60,500 60,500
34% c) 70,000 70,000
14% 8,500 8,500
44% 36,000 36,000
2% 3,750 3,750
2% 7,032,032 7,025,912 (6,120)
0% 100 (100)
6,309,006 5,765,668 (543,338) 17% 47% 12,169,132 12,637,080 467,948
% Exp.
636,048 586,703 49,345 17% 15% 3,816,287 3,816,287
214,920 133,078 81,842 17% 10% 1,289,522 1,289,522
29,167 13,830 15,337 17% 8% 175,000 175,000
323,157 323,157 17% 0% 1,938,939 1,938,939
824,897 824,897 17% n/a 4,949,384 4,949,384
TOTAL REQUIREMENTS 2,028,189 733,611 1,294,578 17% 6% 12,169,132 7,219,748 4,949,384
NET (Resources - Requirements) 4,280,817 5,032,057 751,240 - 5,417,332 5,417,332
a) Approximately 85% of the property taxes are collected in October and November.
b) August payment (MSAG) is pending.
c) All agencies are billed at the beginning of the fiscal year.
d) U.S. Forest Service (quarterly) -payments are current. Crooked River Ranch annual fee received 9/3/09.
COIDC (monthly Apr -Sept) -payments are current.
Health Benefits Trust
Statement of Financial Operating Data
Two Months Ended August 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
P/T Emp - Add'I Prem
Employee Prem Contribution
COIL
Retiree / COBRA Co -Pay
Interest
Total Revenues
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
$ 17,894,797 $ 17,894,797 $
1,746,667
9,167
55,000
166,667
83,333
37,500
1,745,316
7,610
56,595
179,913
94,590
51,714
Revised
Budget*
Year End
Projection Variance
(0) 100% 100% $17,894,797 $17,894,797 1
(1,351)
(1,557)
1,595
13,246
11,256
14,214
2,098,333 2,135,737
19,993,130 20,030,534
18,216 17,291
500
2,374,596
303,667
505
1,896,559
266,064
(9,203)
62,090 61,656
1,917 68,989
48,794 23,183
13,608 2,919
8,262 4,135
1,667
16,667
4,843 3,923
37,404
17% 17% a)
14%
17% 17%
17% 18%
17% 19%
17% 23%
17%
17%
17%
10,480,000
55,000
330,000
1,000,000
500,000
225,000
(0)
10,471,895 (8,105)
55,000
330,000
1,000, 000
500,000
225,000
12,590,000
12,581,895 (8,105)
37,404 92% 66% 30,484,797 30,476,692 (8,105)
Exp. %
925 17% 16%
109,297 109,297
(5) 17% 17% 3,000
478,037 17% 13% b) 14,247,576
37,602 17% 15% b) 1,822,000
9,203 17% n/a
434 17% 17% 372,540
(67,072) 17% n/a c) 11,500
25,611 17% 8% 292,764
10,689 17% 4% 81,648
4,127 17% 8% 49,572
1,667 17% 0% 10,000
16,667 17% 0% 100,000
920 17% 13% 29,059
2,836,610
2,225,957
2,318,730 517,880 17% 14%
17% 0%
2,225,957 17% 0%
5,080,783 2,336,021 2,744,762 17%
NET (Resources - Requirements) 14,912,348 17,694,513 2,782,166
8%
3,000
10,957,895
1,537,260
(9,203)
372,540
11,500
292,764
81,648
49,572
10,000
100,000
29,059
3,289,681
284,740
9,203
17,019,659
100
13, 355, 741
13,436,034 3,583,625
100
13,355, 741
30,484,797 13,545,331 16,939,466
- 16,931,360 16,931,360
* Proposed revisions to FY 2010 original budget
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Based on annualizing 9 weeks of claims paid. $240,325 per week.
c) Zurich to reimburse County $57,490 (5/6ths) of the $68,989 payment made in July for the July through December assessme it.
NC) o 001 r m': 1M o a;`rfi ' m
01 0; O n. o, (010' A ,- O w1 •
C N'I '01 'N' `..41 'A,O F- N 'N
M
O
O 0)
N 0
> m
LL
0000000000Q: I :0).4:10 M' IM IO',O 0� O) ln'O N'(nI N:.N
1,0,0„010,01.0'010' 0"0,0I (DIO O A IA I0 NIO CO.. (D'O1,N 'NI ,H)'u)
'O 040 0100 O M O,OI(n', r'(D Ir �� IO) ':0',V O'..-: 0) A.0.V V O) I O)'0)
1 0.=1oi m A ,c),, i loc ,n lv,0):-4-1,-1 �1(0p :co:I (0(001(0 F- 04 0 A cn co
1 Vj -1� V'. M V Qi NTMI a') OI 'A'01 0)101010 N NIN
)f) 'NI 0)l N':([) MI v - h N. r
+
N 0 N
} U O
0
0
U
10 O' '0)0 O 0IO O (') a0 O).001 N'O (f)'..W, IO) (0C) N 1.4
'MIO O OIA O O OIM'QI 0) 0) 00 Q CO N A IDI (0101N,-1,,,'.00
01 '0'0 O M 00)',A' 'N'V A" O I('4 o7 0) A O,V V OI 0)1 ,O :[O N CO MIN 1(') MIQ ',A .-I 00 'Q 'I 04 (0 (D'I N. N OIA OI(D ISI
IM '�(fl (VIM VI IN N MI 'V'a0 0) N CO 10) -' 0), ' CO
'v), ' ' NI 0)II ao (f) M IQ 1 ISI v1.71
.,,,.-'7
^ . '0 ...
O O O O,
1(0 0 (0 1.(O 1.
O O AN
�O'10 O h!. 0 I;co 'O N O) N '1(D:
:010 OO A N0) 0) 0 M M O AI 0) O0 {�
!o[co' 10 O'. (f) IMI A M 0' '00 1 10 V (0 ' N !Q
'':N A Vi Q'. 'OD '7' M1 'COI O 0101 : (4.1 '(0
V N 10 (0 V ,I IN 0) 1V' - 001 W
•1-
,a; 0olo'o: Il 0 o 10 (0 N� soy, 0)
�'I o0 I,(o OO IOI• 010M IMO M IO'aJI(n.I 1001 I�'
I� I-NiAI-I co 0:� r Q ISI Imo` (�j h•
�0 1 , 0' 0 I 0I 0 ,010 O 1� I(0 (D' fA
, 10: '1 ' 10I(of) 0101 OIMIW: it MI ' O. 0. 1 1011 ' ' 1- 'I0)
T
.10,...,
.
1 N IMlIx'
'0 O. 10 10 c0,1".- on
IN CO, ' 'O ' O 01,f) A1M!I A,MI ' O IM Oo (n: IM A
,0 O h' 'O,00 0 O0nM'0M1Q nip,
O) 1 V 0) 'IA - ;N 1 N' 011 ' 'M () 11qIDO
V I 1 In -. i O)'
O 1 I0 0 V Q 0 0 O ((pp (O!co:O
.O! ',O OI M M IM,o M 0) .,(0 0I M
I(0 ' 1 ' '0 0 IMI00 ':0. C') ' o ' I ' o
'VO, Nl�',.,. ,0) oo'V M MI mo: I ,M
V ; M M
101 O v ' 'o (: 0 (0 .. (pI
'0 SiM M1 co 0 M IO -01 CO li V'10 IN
O) ' O ' IM (Np Io- o) o (�App
:co:IN' 1(0)1 '((00I� M ,g1 1'� 1• 0 h 1
17, v
i 1 r
0,0 0 10 (f) V O)1 IOI N (D:MI O1 (V N' IN
oof o 00. MIo r)o'''
M � N CO N 1 I (40) (0 0- ', O
'(DIM; ' :0 ' 101(n ' Map IA'M O,co ! !-,(01 I0'm: ' : !A1 'v.
4 vI _
OI 'O }O': co co �M1'0' M O ,t0•.-+
(f)1 ' ' O ' I ' -O '0)10'. In M', ' 0 00. 1.,_,,,..i ' ' N!
IA, IV. I0I (D V: ,co v, �'J 11.
l 0 1 '10 1 [ 10 V Q 10 O I OI.*,I- 11 0 �I : r n
0, 0 '.01 MIM IMO M O (D' ,N _co,_
�I ' _ I . 1) . I � O0pp
10 I'I(A' M'.MI :A,M',' O IMI 'I�� IVI .(n'
'.0' I I 1
N 01 ell-(0'IV', M '01 IA. A: 1,Ml
'.Op '.N '�N ISI !(0 7 N !co:co! [N
10 O 'I 0 I(f), VII 0)I NI !cm"IM I co', 0:.- 0� In) ,'Q
Iola! 0'A MIO M.O:i M.1
O MI ' ' 1 ' lI(n(n ' Mj� AIM ' O :('''t - (0 (010 M'. 10 '1
0) '' N N a0 V M O , 0) 11(0) 10 1n'., 11f)
iN. '(DIV 0) I V' 'm: ('o; Q
Iv
m I I 0 I r.;117 �rMIMI (o '., N 0 0) o�
''M f0. (00- 0)10- (D 0) MOO 111
IM ' 04,1,.....
O)' Q Itp'1 N'OIN ' ' IN'
IA- ' j '',CO O) N N M 0I^I IM 11 ,p.
00 0' Alla' IM.A o lh NI
IM A' (D n 'MIDI co co,
• IO,,M, O ''00 ice,
�o (0 CO I (C 1 N 010- 1 i 0) j' 0-
(V COI O :O' 'C',11
0110'' .. 0) 0
IA N O O 1 N ��,
I , '0� 100 100lcci co os ;oil
IV " f : NI :7,
Hi 1
le,' leil
SII
t'
o1 I a) p,.
�y o 'Iy A
),.4,:1.0: 0 '-,
0, Io c o �'
0
Ic N' at N � �. C
> d m U at V I: 0 0 NI
c.�y, W'� a)I(n far y ill
K a (L.2m' iol
'lar c' "): 1 1c41,..,14) a ,o a d W 'a< lin 0 1'0 opal LLI
C c a) a) 01 a)IL � .iC c yl°) To IW 1_,I�d '1H �I C, L'
ia)I> C'u_ U d' d U C 7' df 0 oI c ((d DU a I` -'IG a)Ic c y1
.Vl,at d1' az -1.10 0 0,� mo c 1. ' ��>j rn IEIo U,8.2i 01 I
> a) (n 1 0 U a) >< / co . Z,SI
I O I (L x 1 c
o_,K y rn �o LN ar W d w O ar L Z o d m d U 0
K Eacel D a) c (ni ml m c m a Em ils D, ltt. to rn o).0),;-6))1_:E;_:91.6,,-Ec'I , c1
WIC a� mla a),._ � y0 c D. m0 I(a �(n 1� a) E $!01yL a)',
(006)7=.EEatj C1� 'fat., 'd V.0 NINw•o 1CN IC.
� . > a) 72 2E'
)t1 02:1 a) `�-)� � 0 mm � �� c �'I��w ar,oldc a)�
�I a' W'rH.In10 2 U:> c �: o at a��U o Lc 'o, -c v �I c1C7i� �I¢ tYI m,j,_.,.-§
a IF- 1a rn. y m
ti 0' 0 n ,5mIirI5.0�',rl 1 1 Z' ;1101
W
0
a)
0
co
2
0
2
(0
0
u-
(0
0
.D
U
0
a
0
0
co
rn
00
'
d
N
0)
O N c0
Ti
0 U
Q
N
0
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
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Deschutes County - Fair
YTD -Budget
Statement of Financial
Two Months Ended A
and Expo Center
Basis
Operating Data
ugust 31, 2009
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ 75,000 $ 42,232 $ (32,768)
12,000
334 267
- 17,338
334 209
27,200
2,000
1,170
2,000
3,420 11,000
Year End
Budget
Projection
Variance
100% 56% $ 75,000 $ 42,232
(12,000) 17%
(67) 17%
17,338 17%
17%
(27,200) 17%
(125) 17%
17%
(2,000) 17%
1,170 17%
(2,000) 17%
7,580 17%
- 17%
(17,304) 17%
47,288 29,984
•
0% 12,000
7% 4,000
754% 2,300
0% 1,200
0% 540,000
10% 2,000
0% 58,000
0% 7,000
45,000
0% 235,000
13% 86,420
0% 45,000
3%
3%
3,933
2,300
1,200
530,138 (9,862)
1,875 (125)
58,000
5,000 (2,000)
46,170 1,170
233,000 (2,000)
86,420
45,000
$ (32,768)
(12,000)
(67)
1,037,920 1,013,036 (24,884)
- 17% 0% 498,105 498,105
122,288 72,215 (50,073) 17% 4% 1,611,025 1,553,373 (57,652)
137,448 129,993
88,554 52,473
7,455
36,081
226,002 182,466
17%
17%
17%
17%
17%
17%
Exp. %
16%
10%
0%
0%
0%
Na
824,769
531,604
116,188
100
16,412
121,952
817,298 7,471
521,491 10,113
116,188
100
#REF! #REF!
121,952
43,536 17% 11% 1,611,025 #REF! #REF!
(103,714) (110,251)
(6,537)
Accrued Revenue (Accounts Receivable):
Current Month Events
Prior Months
Total Accounts Receivable
565
565
#REF!
#REF!
Deposits Received for Future Events:
2010:
September
October
November
December
January
February
March
April
May
June
FY 2011
FY 2012 & Beyond
TOTAL
5,447
5,290
4,550
1,205
100
420
250
4,300
2,900
1,000
35,210
5,250
65,922
REVENUES
Gate Receipts
Carnival
Commercial Exhibitors:
Deschutes County Fair - Fund 619
Revenues and Expenses
FAIR 2009 - July 29 to August 1, 2009
Fiscal Year 2010
400,000
154,000
284,818
127,997
Outside 70,000 84,395
Inside 38,000 42,700
Food 12,000 13,900
Livestock Entry Fees 4,000 4,538
RN Camping/Horse Stall Rental 17,000 17,600
Concessions:
Food 146,850 63,709 50,000 113,709
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 625
Food Court 3,000 3,000 3,000 100%
Concert 30,000 - 30,000 30,000 100%
Presenting Sponsors 12,000 12,000 - 12,000 100%
Barn Sponsors 6,000 3,400 3,400 57% (2 600)
Parade Sponsors 4,800 - 4,800 N/A 4 800
Transfer In -General Fund 5,000 5,000 - 5,000 100% -
T -Shirts 3,500 3,725 - 3,725 106% 225
Donations - 13 13 N/A 13
State Grant 25,000 42,200 42,200 169% 17 200
Interest 2,000 444 700 1,144 57% 856)
284,818
127,997
84,395
42,700
13,900
4,538
17,600
71% (115.182)
83% (26 003)
121%
112%
116%
113%
104%
77%
14 395
4 700
1 900
538
600
(33 141)
TOTAL REVENUES 974,850 708,515 122,900 831,415 85% (143 435)
EXPENSES
Personnel 178,128 123,536 59,669 183,205 103% (5 077)
Materials and Services 623,444 524,145 66,828 590,973 95% 32 471
Contingency 31,157 - - - 0% 31157
TOTAL EXPENSES 832,729 647,681 126,497 774,178 93% 58,551
Net Fair - 2009 142,121 60,834 (3,597) 57,237 (84,884)
Transfer to Fund 618 197,421 - 82,528 82,528 114.893
Retained in Annual Fair Fund (55,300) 60,834 (86,125) (25,291) 30 009
Beg Net Working Capital 55,300 25,291 25,291
Ending Balance
86,125 (86,125) (0.00
Actual -
Through
FY 2010
Budget
August 31,
2009
Additional
Estimated
Projected
Total
% of
Budget
Varia ice
400,000
154,000
284,818
127,997
Outside 70,000 84,395
Inside 38,000 42,700
Food 12,000 13,900
Livestock Entry Fees 4,000 4,538
RN Camping/Horse Stall Rental 17,000 17,600
Concessions:
Food 146,850 63,709 50,000 113,709
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 625
Food Court 3,000 3,000 3,000 100%
Concert 30,000 - 30,000 30,000 100%
Presenting Sponsors 12,000 12,000 - 12,000 100%
Barn Sponsors 6,000 3,400 3,400 57% (2 600)
Parade Sponsors 4,800 - 4,800 N/A 4 800
Transfer In -General Fund 5,000 5,000 - 5,000 100% -
T -Shirts 3,500 3,725 - 3,725 106% 225
Donations - 13 13 N/A 13
State Grant 25,000 42,200 42,200 169% 17 200
Interest 2,000 444 700 1,144 57% 856)
284,818
127,997
84,395
42,700
13,900
4,538
17,600
71% (115.182)
83% (26 003)
121%
112%
116%
113%
104%
77%
14 395
4 700
1 900
538
600
(33 141)
TOTAL REVENUES 974,850 708,515 122,900 831,415 85% (143 435)
EXPENSES
Personnel 178,128 123,536 59,669 183,205 103% (5 077)
Materials and Services 623,444 524,145 66,828 590,973 95% 32 471
Contingency 31,157 - - - 0% 31157
TOTAL EXPENSES 832,729 647,681 126,497 774,178 93% 58,551
Net Fair - 2009 142,121 60,834 (3,597) 57,237 (84,884)
Transfer to Fund 618 197,421 - 82,528 82,528 114.893
Retained in Annual Fair Fund (55,300) 60,834 (86,125) (25,291) 30 009
Beg Net Working Capital 55,300 25,291 25,291
Ending Balance
86,125 (86,125) (0.00
Deschutes Cou
PROJECTION
0
U)
N Ip
o 0
a
Encumbrances
& Commitments
Received and
RESOURCES:
CO
N
In CO
N
O
co
O
ti
c0
v7
11)
0
0
N
0
IU
N
N
O
C N
V)
V
N 3
U
a Ncco
EXPENDITURES:
N CO O N
f� ' ' O ' In '
cO O
1'001'- 00LO0
CO In O I- CO O O N
N�00-0111IwN
CO 1 O CO
M
In COO
O
CO IOn O N O O O
In 0 0) ' O In ' N
o
CO if)
In N 1- CO M LO
OfsInMCONON�
N CO x -
CO O If) O
a a N
In
I0COMI)C7)
NO InMCONON�
c- O 1' CO � �- I!) In
N to In f- A- A- O
O N
� r
N
co
O
O
N
O)
CO
CO
co
O)
a
CO
1
O)
co
N
M O
O N
N
co
co
O
o
In
O
O
O
N
O
cn
w
a) V
U-
'' U
v) O a) N R
C 0 0 - C4 C r
CO cr)V N O > u)
') N 2) «S 7 co
Lo m Vin- >• ;�
up L- c V E o) ca) a) • m o n
L
°i5 V O 0) -o U N .� o • 5 E C.i ▪ 0
u, a) C .0 c c a ` 42 Ca .- • m ‘-
1.- R O -&)
L• ca a
.co
�.
L--.:
• 2 c) m. N aa)) -o> .L L 0 m o 1 --
co Q w d c u_Q a 0 q 0 O o
0
CO0 Ill
N h
In u)
N N
N• 111
IA
• 1'
co M)
U ▪ )
co
O
co
O
0)
co
O
coco co
O
O
• u
0) 0)
O 0)
co M
co co
T
Total Expenditures
m
Z
Classification
Amount Paid
c
O
Q
U
0
O
c
Materials & Services
Materials & Services
CO N
MIs -
C()
0 N
O C
M C()
CO N
N-
CO
M
CO 0
N 0
I� M
M
0
co
O
C3)
M
CO
N
N
O
- 0 0 0
a0 O O
CO 'I' I` 0
rn cri M
In In CO
Q) a—
C7
N O
0 0
N C'7
00 N
CO CO
- O N 0)
O 0) 0 N
✓ 0 ,— CO
0 C0()
V
E
a)
71)>,
cC/)
O
U to
O
D 0
U
c Q
U
To- C6
U 7 +r
CD U c
o_ O O
U) U)
U
c
cn
U
7
0,
O) -0
c
• O CD
~ CD •0 c6
�
COw H
PROJECTION
a)
0
azi
I-
O
p)
O a
CL CO
0
U
o
0
Encumbrances
& Commitments
a
a
(0 N
a
a)
> Q
U x
W
RESOURCES:
CO
M
co
CO N O CO
I� CO O M
I� N O O
M N
NCCOO O0))
M M
O N O N
O CO O CO
O N O N
O N t�
l!) I� CO CO
N O 0)
M Co;
CO '
N.N. 000 c00
N t0
Cf) O)
N
c1) c�i
IN- co
' 0
M N
L!) '71-
M
u)
y
0
0
0
4)
C
a C
N
OCA
a�
0 a)
m u_
a)
a�
c
Total Resources
EXPENDITURES:
IJ)o 0)
' O ' N
N N CO
O co O r co 0 r O
O 0) O co Cf) co O O O
O co'-'- co co N O
N O N N M
N Cf) N CO
O 00) O CO 0 O O
O ' 0 0 ' O
1� N O O
CO Cf) N Cf)
N
"t Cf) O N CO I.- co
co0) 0 Cf) O co 0) co
co 0) N x- LO N
N Cf) N I, Cr;
CO C!)
N
I 1 1 I
Cf) M O N CO O
M CO Cf) O Co O) CD
00)0) N- f Cf)N
M N
O Cf)
N
Cf)
c
CD
CO
O
co
Cf)
co
CD
N
0)
CO
CO
CD
0)
M
CO
N
CO
N
0
0 0
N
LO
CO 0
Cf) O
if) M
N
Cf)
Cf)
0
co
N
N
0)
c0
O
f`
0
c0
N
0)
N
I~
CO
C!) ' (NI
O) 0) 00
Cf) If) 0)
M cM
c(0
0)
3
O
c0
0)
3
O
M M O) CO LO
Cf) in r
N N c0 O
in Cl) O) 0
N-- et O
M M to
I- ti 0)
.- 1`
T.
N N N
co
Cf)
M
H
V) d
a) C1
U
U
Z a� d a
rn U) CO
C 0 0'o C r
a) CT a) (n j5 N H O
3
.` O a w R ;
N U C� U c Cd O 0 R U
°a R a� m a c0) a) •6 o - 5 ? c (.i a)
C 'C .a a C) ` r ra b r C
O -E—.5C..... a) Q) > C= L O 0 O
a) c -)
c ctiQa0 U00 0
M
O
0)
c0
r
M
Total Expenditures
0
0)
0)
m
Z
C/)
H
Z
W
H C)
CD 'tN
"0 O
U ch
O
Z
Q O
w cn Q
O W
U
aZ =
O
Fs)
U
Z
W
Classification
a)
c a)
D
N 0
Amount Paid
c
0
0.
U
U
a)
0
O
c
O
• 0)
a) a)
U
O a)
C/) C/)
06 05
U N
(a CO
O a)
N c0
r- N O)
• CO CCOO
N I- O
r- CO tO
O o
CD O
M O M
O) O
o
co O
tri
ti
N �
U
0
U")
(0
c
0
.FT)
U
O
a`
U
0
O
W
0
E
N O O - 'f)
- O O ID O)
CO O N
N O O CO- C)
CO SO CY) I-
O%-
N-
%_ r CD
CO CS)
Sfi Ca.
M CO
't N O O SO
't O OC) O )
CO CD OO) I -
CND N M
N O
N N
U U
0 0
U U
a) a) 0)
E 1E c c
` ` O
< < N H a)
J J H L.L (/)
Herman Miller
Engineered Structures Inc
Deschutes County
Bethlehem Inn (Fund 128)
Two Months Ended August 31, 2009
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 2,766,469
Total Revenues 2,766,469
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
- (2,766,469) 8% 0% 2,766,469
- (2,766,469) 8% 0% 2,766,469
- (2,766,4¢i9a
- (2,766,40;9)
100,000 (2,689,172) (2,789,172) 8% -2689% 100,000 (2,689,172) (2,789,172)
Exp.
100,000 8,031 91,969 8% 8% b) 100,000 45,000 55,0( 0
TOTAL REQUIREMENTS 100,000 8,031 91,969 8% 8% 100,000 45,000 55,0( 0
NET (Resources - Requirements)
- (2,697,203) (2,697,203) - (2,734,172) (2,734,17a
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) August interest expense was $3,957.
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 2,766,469
Total Revenues 2,766,469
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
- (2,766,469) 8% 0% 2,766,469
- (2,766,469) 8% 0% 2,766,469
- (2,766,4¢i9a
- (2,766,40;9)
100,000 (2,689,172) (2,789,172) 8% -2689% 100,000 (2,689,172) (2,789,172)
Exp.
100,000 8,031 91,969 8% 8% b) 100,000 45,000 55,0( 0
TOTAL REQUIREMENTS 100,000 8,031 91,969 8% 8% 100,000 45,000 55,0( 0
NET (Resources - Requirements)
- (2,697,203) (2,697,203) - (2,734,172) (2,734,17a
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) August interest expense was $3,957.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2010
Jul
Aug
YTD Total
Tammy Baney
Conf/Sem & Educ/Training -
Travel Meals -
Accommodations - - Airfare -
Mileage reimbursement - 256 ji 256
Ground Transport - -
Total Baney 256 256
Dennis Luke
Conf/Sem & Educ/Training - -
Travel Meals 25 25
Accommodations - 77 77
Airfare
Mileage reimbursement - 329 329
Ground Transport
Total Luke
432 432
Alan Unger
Conf/Sem & Educ/Training
Travel Meals -
Accommodations -
Airfare -
Mileage reimbursement
Ground Transport
Total Unger
Total - BOCC Department
Conf/Sem & Educ/Training - -
Travel Meals - 25 25
Accommodations - 77 77
Airfare - - -
i_
Mileage Reimbursement 585 585
Ground Transport
Total - BOCC Department - 687 687
FY 2010 Budget
Percent Expended
22,750
3.0%
10/1/2 )09