HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
June 28, 2010
(1) Monthly Investment Report
(2) May 2010 Financials
• eschutes ount
0
T
CNIO
C'7
Ili
otal Investment Por folio As •
Investment Income
Fiscal Year 2009-10 I
May -10 Y -T -D
$ 116,965 $ 1,531,616
C)
M
O
1n
N
Tr
r
Total Investment Income 116,965
Less Fee: 5% of Invest. Income (5,848)
Investment Income - Net $ 111,116 $
Investments By County Function
General $ 135,421,354
Total Investments $ 135,421,354
e at Maturit b nvestme
O
0.
0 ov o
0 0 o o '
O In O n 0
O Cr) O O
O f: O N O co O
r
co NI-
• szr
N A—
- (5 (5
O O
fs- N
O
- N
69
1n
a)
U
4) Uo
(1 O as C U
isZ,w2
U a) C
ca <<
m a) in 0
E O0H �'CB 12°
E o_ a)-61) Y �_
O O .E • ▪ N co 0
u,
In
16
M
ffA
Total Investments
O
Ln
O
0.
a
CO N
O r r
o a o
c0 c0• M
O
.
c
RS CD
H U
s
w
O C
O 2 O
2ND
( ) r M
Average Maturity in Days
0 - 0 0 0 0 -
O O 1i9 In 1/) O O
N N N I-
r r
U)
E
7
U a)
.X a) .0
co cr)
• N Q
d • ~ d (6
a)
C) D J ii
Time Certificates
Total Portfolio: By Investment Types
U
d
G
Market Value
a
O
U
To
0(
0
40 IA 1
UU O O O O O 0 U 01 0 0,, 0, O 0 01 0{ 0' 01 0 0 0
N UU UU O UU Uu1 N O 0 0CV 0 Ct'z z z z z z Z z z zlz Z'zIz zz2,212z zzz 'zz z z'z'IS z'mzu o a,
o Io o 6 E '1
o ori_ '
M F- N 7 0' N 0 O O O O O. i0, f` O O C: CO N f`' co, O O C co,- 0 0) 0 0 0 A O 0 O t` 0 N 0 0 0 LO 0 0 V
CO CO N CO' I` N 66, O 1 0 0, rl 0 0 O Off' i0 0, 40 N N 0 7 N 0 CO 0 O CO Oi 0 c- O 0 (0.0 N. O O O 0 0 0 0)
M O 0-I 6'' 7 0)I O 0- O N 0- O O' O O i0 O' O N O' N I` O' 7 0- O M 0 O, a0 OI O.- O uO O 04 0 O O M M 0)
(0D O'1 0- 0'- N OD V 00f [00 r N CO N CO 0 1- m .- CON0 0 O N CMO 0 .- 0 0 N 0 00 0 0 r 0 r' 0 (00 N(0 N t09_
O CO O N'' V N CO 0 CO. t` CO CO.' O M M N OO N N O O 0 (: r. N OI N O M O O' .- M O 6
O I O CO N .' 0 0 7I 0 CO 0 CO CO O 7 i0 0 7 O O N 0 O 7 N N 0 CO O I N 7 N N- CO CO CO''V 7 i0 O 0) N N
� o .- 0 0.- 0'10 ,- 0 0' .- 0,- 0 0 0 0.- 0 0 0 0 0 0.- 0 0 0.0 0 0 0) 0 a
7'IN 7 V 040404. N N N D N N. N N N N N N N N NIN N N N N N N'NfN N N'I- L() O
IM N M
{ nN1
I,- O O+1— (0: 7. .I- Co 0 0 0 0. 0 N o r 0. 0 M V' O )0 O a0! 0 O O as 0� 0 0 0 0 0 0 0 0 0 0 0 CIO 0)
O O OO N, C. x 7 0 0 0 0 0' O N O U) N O M C o r O- o o 0 01 0 0 0 0 0 0 0 0 OI 0 0 0 0{O a) 01
O. ui O'. 01 0 O N 0 0 0, N N O i0 O i0 O O P') OI Imo. a0 0 O O 0'' 0 0 0 0 0 0 0 0 0 0 0 N M t0 N'1
0 i0 i0' I,. MIM CO O )0 O co N O O C 0 0'. CO O CO O N N I`', M O CO CO CO'' O 7 co" N1 0 0 0 O O O co O u') O
M i0 a0 co' 0. i0 0 I` 0 N M 0- 0 N Q I� O. O. O N r. 0'. O 10 N CO CO i0 i0 M (D' V 0 N (0' 0 0 0 1 L,./:),(0 N M
0 0 0 0 0 0 0 a0 r C Imo''. I,- O N (O O O O .-I 0 04 7 i0 0 01, N- n< O' O O r O O O V M
0'. u0. co 04 ,' O O O' O 0 N 04 CO O M O i0 0 0 0,0 O 0 0 1- C310, 0 I, 0 0 01010 . 0 010 0 0 0- O N 0) 1
0 0.— .- 0 0.- 0' 0 0'. 0.- 0 0 1, O r o 01 ,- 010 � 0 0.— 0' 01, 010 0 0. 0 1 0 0 0 0 0 0 0 i0 V O 0 1
p N C C.— N N. N', . N N N N N (4(4(4(4(4(404(4(4(4(4(4(4(904(4 . M N N
00030010100003,000 '. ' '. 0 0 0' 0 O' O 0 0 0 0 O' O O O O O 0. O O O O1 M 0 0 0'' 0 0 0 r 070 I
0'1 0 CO 0 0 O 0 0 0'..- 0 0''. 0 0 0 0 0' 0 0 0 0 0 0 0, 0 0 0 0 O I O'. O O O O, N O. O O'1 0 0 0 1- 0 u
0 I 0 0 0 0 00 00 0.10 (01 0 0 0 0 0. 0 0 0- 0 0 0 0 0 0 0 0 01 0 0.. 0 0 O', 0 0 0 01 0 0 0 O M t0 Q
co co.' 000000,000 '.. M. O co N 0 O C co i0 4 O o 0 0' 7 co 0 0 0 0 0 0 O'1 O O O N O 0 0 O O IVO
0 0.- 0 O O I O O" O 7 M 0', O O O 0 0(0 0 C O 0 0 O'1 0'1 0 0) 0 0 0 0 0 0 01 O0 0 O r` 0 7 0 O(0 N
0 0 M, 01 N C � 0 0 01 o) 0- .- 0 OO 0 0 0 0 e) 0 O 0 0 0'. r 0 O 01 O. M 0 r 0' .- 0' 0 C' 0 0 O 0 V
00 N N 1 1 01 O N O. O O <' 0- 0 0 0 0 0 0 C 0 0 0 0 0 0 0 O 0' 0'. O0 0 0 0'. < 0. 0 01 0 0 0 N 0 N V
0 0 0 O.— O O O OI .— 0 0.-.-.- 0 0.- 0 0 0 m.— 0 0'. 0 0 0 0 0.— 0 0 0 0 0 0 L0 7 0 0
4- N 411 C.— NNIN'..— NN N N.— N1NN.— 0N' N O'NNNNN N N 04NNN .-MN
I
I 1-
-e- -. el -2 e o -.2.1-2 ms° -2 -msmsa a oe o o -I o no� . ,...,le
10-.- -2-2- 0 0 0 0 0 0 e a ae
O 01 O OOIOO(0O O 1 a O O O 0 O 0 0 0 CO O 0 O 0 O OO OOO01 O 101 O O 0 0 0 0 0 0
CO O O OO 41 co N a ON O O O_O M 0 M d'_O 0 01 0I M N O OO O 0 O O O OO t` V M t` N 0 0 M
OO70101 O10 O1O N,O 7.O 7,N <- N • 0 OO 0 M `1 V •.0 N O O.O O -n1 OI` O 0 O OO N N N 10 O
N..NNCO 4,- 41-1 �,�M'M.- N 4,- Co O 14 C4 4,- 000Co r"O O,�Or4,-..I-
hO
o
., q
57- IX
O N O 00 0 0
Orn or-or
(p
O O
O
0
0)
00)
0
CO171
c
7, m
A G
m
0)
4
U o
7 A
0.
o 0 o
LO
0 0-
M N M
M r M
o,o
0- o
7 7
e o o 0 0 0 0 0 0 0 0' o '' -, 0_ o o 0 0 0 0
0 o O O o' o O O O o'. O O o o o in O O O
o O co O 0 O O O 0- o OO' 0, O O O O N i0 O: o
(n 0) 0 i0 co M .- f` M O O O. 00-) 0 M' 0 0s O O
O O O O.- .- 6,6 .- 616 M O.- O O O
0
0 01
o O
N N
�''.
0
0•zcU
0 d fa
E o 1
,00E 0E°'�
E(n
w
cl
m'1
S
O
�1 Ir Y
E O cj •
E c L0 C
N • jp I
CEY r!
N O': N CO O 0''', 0 N O CO 7 0 CO CO 0 O O O I` N CO O; I` f-. O N- 0 0) MI I` 0 M co co i0 0 0 0 0 (. 0)m i
3'o'Le7'12.!:51a 0 00-0,000 0000000000la.232322A2�010- ra E-
0 O O O: co. O O O 0 0,0 0 0 O'.,- __ ,-,-_ ,- ,- 04 N d ! O
a c W
''.N o NI�Ij�� rn o'7 v o F- v rn In rn m o o rn 'a.-:0 in.� r rnla (n 5 5 iD.o Cao M n ()
0 0 '.041041.- .- .- N N 0 0 0 0 CO .- N N O N N N. C110 0 0 0';O O 4- N O N N1- N,- O 1-
000110'.01'10 010 0 0 0 0 N 0000000000101 000', 0. 00000oo0� �(� 00 a 0Jm 11,
00'. 0 0•0 O 0 0 010 0 0 0 0 0 0 0 0 0 0 0 0 0,..0101 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 0
I O, O,.— 0 . 00 00 0 0 0 0 0 0 0 00 0 00.0:010,- \1- O ---- O
1 00,- n n.- in o.- a ..- `n u) r o rn o o m m o o o) as, 0 l 0.- .-1 n (c . _ a 0 a n a o (4 va a `n
N 0
a V7 0
0 .- 0 0
1 01 0 0 N N. N,- ,- 1- n-•- N 0 0 CO N I N 1- 1- N N N 1 0411- ,- 0 1- N 0)) 0 O N N
7 0 0J N a 0 V a a .- N a 0 0r-..-, M m .- -, f0 041 N, 0 0 0)1 a 0 M a N 0
O, 0 0 0 0 0 0 0 0 0 0 0 .- .- 0 0 0 .-, O O .- O .-1.-100 O O'. O O O O.- N O• 0
11 f
, T
edR'dOOOIO 0 0LLr� <LLLLI-LLI-O I-LL�LL1-LLILLLLLLLLLLLLZ LL LLLl.0UU;II IU-,0
°os 1' �!'1 m m, m m cc x co CCCI M D 2 3 (M co cz)Il (>nisi (Zis co, uzi a D''10- cn cn co cd 3 cc c ; cc ai co
d
L M 0 M N (p O 0 0 N', O t` O O' i0 O 0 O A r O O O O
COCC
z H O CO 3 O 71 J I H. H C. O 0 �, Q U N Z (a0 N U)
E I x O m Y m a 3 01 1 Q ''> z m
0 H (n i0 ,- M (0 > 1.. Oo M 1 Q. 0 7. O' M ;.-:'
Y Q (7 > i
Z X X X N O N )( Xi t� X X X .M X O X LL
d M M M OOi M N 0 m CMOI ' N' (Mn O M M M N CMJ _MI co (M+) M (0�) mc M C0J
0 O
0 M M. M M M M 0 M 0, M CO 0 M M !+) M CO M I D CO CO CO M CO 7,
U
Q V 0! LL
m m U
m t -a Lc- alz Q01
Y Q.a,OE cnc cn m UV U LL,HIF
0.
0
0)
0
0
E
0 0 01
0001 0
U
0 m m ail 0
Upa-t,-o U Y
o (J y' y 10 h @ 000
dl, c U,U U.Y o
E1E n..cQ 10
m
'o,o
C,- c c c (U c m E
(0 E col (0 (ala (o 2 0
m17'm'.m'mIJ CO LL
m
2
0
0
U U
c
as co co W m m 0
mL (3U g o
E
m Nc U 0 0q1 m U
2 dLL E2. E0 0
LL(.9LL DU. DII5
0
Z
Y
U mUp°p,Z
m a d U
c m o
0' 1. 1', N N C cn 1' 0
0 • lc)
(0 Rt(Q) m N J N m I'' a, y Oj
-- C,V > m N,m �C 00_ 0'� 0 ,is
m Z, -U N E °� �� (o`c2 A�ml'n "Qu�Ia'�H
CO 2U U.c U o o EaLLim'1t]dre°lo a�'iEomUq�,d
� om)0 ol�U 0 (0 J� J� z m (iz°IY�a�nnm�l1031040o8i_�
W Y c 0 E'
m os to 2 tL H'
E t m CO • o,m m m 2 m m;"m m o m m a W w
O N S 0 2= wLL •I EILLI,LL 2 2 2 LLI OILL 2 Z LL S Z W m - 1 '�r
010 LL m LL (n Y u- Du- LL LL LL LL LL �H LL LL LL LL LL LL J m 'H,
Memorandum
Date: June 17, 2010
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find May 2010 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
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll.
Revised
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 18,170,943 20,941,626 2,770,683 92% 106% a) 19,822,847 21,116,939 1,294,092
Gen. Rev. - excl. Taxes 2,678,007 2,755,409 77,402 92% 94% b) 2,921,462 2,921,462
Assessor 752,312 822,005 69,693 92% 100% c) 820,704 848,204 27,500
County Clerk 956,240 1,354,133 397,893 92% 130% d) 1,043,171 1,552,066 508,895
BOPTA 12,642 14,432 1,790 92% 105% c) 13,791 14,432 641
District Attorney 305,067 255,890 (49,177) 92% 77% 332,800 384,185 51,385
Finance/Tax 171,462 195,829 24,367 92% 105% c) 187,049 197,827 10,778
Veterans 64,343 70,154 5,811 92% 100% e) 70,192 63,871 (6,321)
Property Management 79,245 91,164 11,919 92% 105% 86,450 86,450
Grant Projects 1,836 1,837 1 92% 92% 2,000 2,000
Total Revenues 23,192,097 26,502,479 3,310,382 92% 105% 25,300,466 27,187,437 1,886,971
TOTAL RESOURCES 29,242,097 33,278,474 4,036,377 92% 106% 31,350,466 33,963,432 2,612,966
REQUIREMENTS:
Expenditures
Assessor 3,016,412 2,824,473 191,939 92% 86% 3,290,631 3,157,631 133,000
County Clerk 1,338,979 1,189,039 149,940 92% 81% 1,460,704 1,293,000 167,704
BOPTA 54,732 56,287 (1,555) 92% 94% 59,708 59,714 (6)
District Attorney 4,204,991 4,184,966 20,025 92% 91% 4,587,263 4,587,263 (1,197)
Finance/Tax 692,973 689,946 3,027 92% 91% f) 755,971 755,971
Veterans 206,893 212,816 (5,923) 92% 94% 225,701 233,701 (8,000)
Property Management 219,711 217,506 2,205 92% 91% 239,685 239,685
Grant Projects 96,867 94,882 1,985 92% 90% 105,673 105,673
Non -Departmental 1,478,589 719,982 758,607 92% 45% 1,613,006 1,483,006 130,000
Contingency 5,440,612 5,440,612 92% 0% 5,935,213 5,935,213
Exp. %
16,750,759 10,189,897 6,560,862 92% 56% 18,273,555 11,915,644 6,356,714
Transfers Out 11,959,668 11,704,266 255,402 92% 90% 13,046,911 13,046,911
TOTAL REQUIREMENTS 28,710,427 21,894,164 6,816,263 92% 70% 31,320,466 24,962,555 6,356,714
NET (Resources - Requirements) 531,670 11,384,311 10,852,641 30,000 9,000,877 8,969,680
Beginning NWC per Approved Budget
a) Projection based on actual collections through November 30, 2009.
b) Year to date includes annual PILT payment of $467,230.
c) Includes 4 quarters of A & T Grant: Assessor -$729,836, Tax -$171,888 and BOPTA -$14,432.
d) Significant foreclosure and refinancing recordings.
e) Unexpended VET grant repaid to ODVA.
f) Year to date includes expenditures paid annually.
8,300,000
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
Health & Human Svcs Chg
CCF Interfund Grant
Crime Pry Svcs Interfnd Grnt
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
$ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
29,127
55,000
14,667
27,500
304,746
55,000
733
190,796
275
917
11,917
2,244
62,333
18,333
49,786 20,659 92% 157% a)
49,749 (5,251) 92% 83%
14,988 321 92% 94%
19,257 (8,243) 92% 64% b)
225,712 (79,034) 92% 68% c)
104,357 49,357 92% 174% d)
231 (502) 92% 29%
67,954 (122,842) 92% 33% e)
106 (169) 92% 35%
400 (517) 92% 40%
14,769 2,852 92% 114%
2,200 (44) 92% 90%
1,652 1,652 92% n/a
1,660 1,660 92% n/a
46,272 (16,061) 92% 68%
15,521 (2,812) 92% 78%
614,614 (158,974) 92% 73%
Total Revenues 773,588
Transfers In -General Fund 5,081,254
5,081,254
TOTAL RESOURCES 6,939,842 6,895,909
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services 2,594,306
Materials and Services 1,211,922
Capital Outlay 92
Juvenile Resource Center
Personal Services 2,321,141
Materials and Services 169,494
Capital Outlay 92
Contingency 552,378
2,564,896
1,013,995
2,123, 930
163,418
f)
f)
31,775
60,000
16,000
30,000
332,450
60,000
800
208,141
300
1,000
13,000
2,448
68,000
20,000
53,491
57,700
16,000
27,000
336,700
119,500
231
93,770
150
475
16,000
2,400
1,700
1,660
54,495
20,000
21,716
(2,300)
(3,000)
4,250
59,500
(569)
(114,371)
(150)
(525)
3,000
(48)
1,700
1,660
(13,505)
843,914 801,272 (42,642)
92% 92% 5,543,186 5,543,186
(43,933) 92% 92% 7,472,100 7,544,499 72,399
29,410
197,927
92
92%
92%
92%
197,211 92%
6,076 92%
92 92%
552,378 92%
Exp. %
91 %
77% g)
0%
2,830,152 2,845,000 (14,848)
1,322,097 1,155,000 167,097
100 100
84% h) 2,532,154
88% 184,903
0% 100
n/a 602,594
2,305,200
180,000
226,954
4,903
100
602,594
TOTAL REQUIREMENTS 6,849,425 5,866,239 983,186 92% 79% 7,472,100 6,485,200 986,900
NET (Resources - Requirements) 90,417 1,029,670 939,253 - 1,059,299 1,059,299
Beginning NWC per Approved Budget
987,000
a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly.
b) Food Subsidy receipts reflect payments for July -February. Projected revenue anticipated to be received in full.
c) OYA Basic and Diversion third quarter payment received in May. Payments are based on reimbursement requests
for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year.
d) Utilization of housing for juveniles by Crook County continues to exceed original estimates.
e) YTD BRS revenue for July -March. Projection reduced to reflect actual youth count at less than half of original estimate.
f) Third quarter payments received in April.
g) Positive variance a result of BRS contract payments being lower than anticipated due to low youth count in the program and
a decrease in Maplestar contract for youth services.
h) Positive variance a result of decreased use of on call staff in detention center.
Year End
Budget _
Projection
Variance
$ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041
29,127
55,000
14,667
27,500
304,746
55,000
733
190,796
275
917
11,917
2,244
62,333
18,333
49,786 20,659 92% 157% a)
49,749 (5,251) 92% 83%
14,988 321 92% 94%
19,257 (8,243) 92% 64% b)
225,712 (79,034) 92% 68% c)
104,357 49,357 92% 174% d)
231 (502) 92% 29%
67,954 (122,842) 92% 33% e)
106 (169) 92% 35%
400 (517) 92% 40%
14,769 2,852 92% 114%
2,200 (44) 92% 90%
1,652 1,652 92% n/a
1,660 1,660 92% n/a
46,272 (16,061) 92% 68%
15,521 (2,812) 92% 78%
614,614 (158,974) 92% 73%
Total Revenues 773,588
Transfers In -General Fund 5,081,254
5,081,254
TOTAL RESOURCES 6,939,842 6,895,909
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
Personal Services 2,594,306
Materials and Services 1,211,922
Capital Outlay 92
Juvenile Resource Center
Personal Services 2,321,141
Materials and Services 169,494
Capital Outlay 92
Contingency 552,378
2,564,896
1,013,995
2,123, 930
163,418
f)
f)
31,775
60,000
16,000
30,000
332,450
60,000
800
208,141
300
1,000
13,000
2,448
68,000
20,000
53,491
57,700
16,000
27,000
336,700
119,500
231
93,770
150
475
16,000
2,400
1,700
1,660
54,495
20,000
21,716
(2,300)
(3,000)
4,250
59,500
(569)
(114,371)
(150)
(525)
3,000
(48)
1,700
1,660
(13,505)
843,914 801,272 (42,642)
92% 92% 5,543,186 5,543,186
(43,933) 92% 92% 7,472,100 7,544,499 72,399
29,410
197,927
92
92%
92%
92%
197,211 92%
6,076 92%
92 92%
552,378 92%
Exp. %
91 %
77% g)
0%
2,830,152 2,845,000 (14,848)
1,322,097 1,155,000 167,097
100 100
84% h) 2,532,154
88% 184,903
0% 100
n/a 602,594
2,305,200
180,000
226,954
4,903
100
602,594
TOTAL REQUIREMENTS 6,849,425 5,866,239 983,186 92% 79% 7,472,100 6,485,200 986,900
NET (Resources - Requirements) 90,417 1,029,670 939,253 - 1,059,299 1,059,299
Beginning NWC per Approved Budget
987,000
a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly.
b) Food Subsidy receipts reflect payments for July -February. Projected revenue anticipated to be received in full.
c) OYA Basic and Diversion third quarter payment received in May. Payments are based on reimbursement requests
for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year.
d) Utilization of housing for juveniles by Crook County continues to exceed original estimates.
e) YTD BRS revenue for July -March. Projection reduced to reflect actual youth count at less than half of original estimate.
f) Third quarter payments received in April.
g) Positive variance a result of BRS contract payments being lower than anticipated due to low youth count in the program and
a decrease in Maplestar contract for youth services.
h) Positive variance a result of decreased use of on call staff in detention center.
SHERIFF - Fund 255
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $
Revenues
$ 183,677
$ 183,677
100%
n/a $
$ 183,677 : 183,677
Law Enf Dist Countywide 18,556,025 15,667,565 (2,888,460) 92% 77% a) 20,242,936 17,217,280 ;3,025,656)
Law Enf Dist Rural 11,657,545 10,307,237 (1,350,308) 92% 81% a) 12,717,322 11,087,596 :1,629,726)
Interest 22,283 22,283 92% n/a 35,000 35,000
Total Revenues 30,213,570 25,997,085 (4,216,485) 92% 79% 32,960,258 28,339,876 ;4,620,382)
TOTAL RESOURCES 30,213,570 26,180,762 (4,032,808) 92% 79% 32,960,258 28,523,553 (4,436,705)
REQUIREMENTS:
EXPENDITURES 8 TRANSFERS
Sheriffs Division 2,007,856 1,941,051 66,805 92% 89% 2,190,388 2,130,388 60,000
Civil 676,006 666,423 9,583 92% 90% 737,461 723,249 14,212
Automotive/Communications 1,281,394 1,230,914 50,480 92% 88% 1,397,884 1,369,745 28,139
Investigations/Evidence 1,555,883 1,412,312 143,571 92% 83% b) 1,697,327 1,529,931 167,396
Patrol/Civil/Comm Supp 6,953,803 6,633,540 320,263 92% 87% c) 7,585,967 7,271,832 314,135
Records 588,833 543,441 45,392 92% 85% 642,363 614,363 28,000
Adult Jail 8,392,000 7,603,517 788,483 92% 83% c) 9,154,909 8,669,084 485,825
Court Security 197,916 179,782 18,134 92% 83% 215,908 198,908 17,000
Emergency Services 176,065 169,066 6,999 92% 88% 192,071 181,859 10,212
Special Services Division 1,094,216 990,363 103,853 92% 83% 1,193,690 1,147,104 46,586
Regional Work Center 2,509,689 2,161,160 348,529 92% 79% c) 2,737,842 2,423,842 314,000
Training Division 421,715 365,413 56,302 92% 79% 460,053 436,388 23,665
Other Law Enforcement Svcs 538,727 507,504 31,223 92% 86% 587,702 551,702 36,000
Non -Departmental 424,457 457,794 (33,337) 92% 99% 463,044 463,044
Contingency 2,945,843 2,945,843 92% n/a 3,213,649 - 3,213,649
Exp. %
Transfers Out 449,167 367,500 81,667 92% 75% 490,000 490,000
TOTAL REQUIREMENTS 30,213,570 25,229,780 4,983,790 92% 77% 32,960,258 28,201,439 4,758,819
NET (Resources - Requirements) 950,982 950,982 322,114 322,114
Beginning NWC per Approved Budget
a) Revenue from LED's based on actual expenditure and adjusted quarterly.
b) Delay of employee retirement expenses to next year.
c) Personnel expenditures Tess than budgeted due to unfilled positions and less than planned Materials & Services.
Year End
Budget
Projection
Variance
n/a $
$ 183,677 : 183,677
Law Enf Dist Countywide 18,556,025 15,667,565 (2,888,460) 92% 77% a) 20,242,936 17,217,280 ;3,025,656)
Law Enf Dist Rural 11,657,545 10,307,237 (1,350,308) 92% 81% a) 12,717,322 11,087,596 :1,629,726)
Interest 22,283 22,283 92% n/a 35,000 35,000
Total Revenues 30,213,570 25,997,085 (4,216,485) 92% 79% 32,960,258 28,339,876 ;4,620,382)
TOTAL RESOURCES 30,213,570 26,180,762 (4,032,808) 92% 79% 32,960,258 28,523,553 (4,436,705)
REQUIREMENTS:
EXPENDITURES 8 TRANSFERS
Sheriffs Division 2,007,856 1,941,051 66,805 92% 89% 2,190,388 2,130,388 60,000
Civil 676,006 666,423 9,583 92% 90% 737,461 723,249 14,212
Automotive/Communications 1,281,394 1,230,914 50,480 92% 88% 1,397,884 1,369,745 28,139
Investigations/Evidence 1,555,883 1,412,312 143,571 92% 83% b) 1,697,327 1,529,931 167,396
Patrol/Civil/Comm Supp 6,953,803 6,633,540 320,263 92% 87% c) 7,585,967 7,271,832 314,135
Records 588,833 543,441 45,392 92% 85% 642,363 614,363 28,000
Adult Jail 8,392,000 7,603,517 788,483 92% 83% c) 9,154,909 8,669,084 485,825
Court Security 197,916 179,782 18,134 92% 83% 215,908 198,908 17,000
Emergency Services 176,065 169,066 6,999 92% 88% 192,071 181,859 10,212
Special Services Division 1,094,216 990,363 103,853 92% 83% 1,193,690 1,147,104 46,586
Regional Work Center 2,509,689 2,161,160 348,529 92% 79% c) 2,737,842 2,423,842 314,000
Training Division 421,715 365,413 56,302 92% 79% 460,053 436,388 23,665
Other Law Enforcement Svcs 538,727 507,504 31,223 92% 86% 587,702 551,702 36,000
Non -Departmental 424,457 457,794 (33,337) 92% 99% 463,044 463,044
Contingency 2,945,843 2,945,843 92% n/a 3,213,649 - 3,213,649
Exp. %
Transfers Out 449,167 367,500 81,667 92% 75% 490,000 490,000
TOTAL REQUIREMENTS 30,213,570 25,229,780 4,983,790 92% 77% 32,960,258 28,201,439 4,758,819
NET (Resources - Requirements) 950,982 950,982 322,114 322,114
Beginning NWC per Approved Budget
a) Revenue from LED's based on actual expenditure and adjusted quarterly.
b) Delay of employee retirement expenses to next year.
c) Personnel expenditures Tess than budgeted due to unfilled positions and less than planned Materials & Services.
RESOURCES:
Beg. Net Working Capital
Revenues
Tax Revenues - Current
Tax Revenues - Prior
Federal Grants
State Grant
Transp. of State Wards
SB 1145
Des. Cty Video Lottery Grant
Des Cty Court Security
Des Cty Juvenile Contract
Title III Reimbursement
Transport
Other
Claims Reimbursement
DC Fair & Expo Center
Inmate Commissary Fees
Work Center Work Crews
Concealed Handgun Classes
Soc Sec Incentive -Fed
Miscellaneous
Oregon Mentors
Medical Services Reimb
Restitution
Sheriff Fees
Interest
Interest on Unsegregated
Rentals
Donations
Total Revenues
TOTAL RESOURCES
SHERIFF 701
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY
Coll. %
$ 2,470,519 $ 3,343,461 $ 872,942 92% n/a
13,584,728
458,333
32,083
41,393
4,583
1,577,759
4,583
118,250
2,750
137,500
1,833
55,000
38,913
5,500
4,583
3,667
4,583
11,000
963
146,667
25,972
3,239
27,499
15,111,385
777,906
122,411
71,283
6,102
1,974,660
5,000
117,838
5,456
47,259
2,837
1,320
37,528
2,100
55,667
19,590
6,550
11,000
9,179
2,136
14,475
1,449
192,299
52,568
3,393
77,619
50
$ 2,470,519
$ 3,343,461 $ 872,942
1,526,657 92% 102% a) 14,819,703 15,111,385
319,573 92% 156% a) 500,000 777,906
90,328 92% 350% b) 35,000 122,411
29,890 92% 158% c) 45,156 71,488
1,519 92% 122% 5,000 6,102
396,901 92% 115% d) 1,721,192 1,974,660
417 92% n/a 5,000 5,000
(412) 92% 91% 129,000 129,000
2,706 92% 182% 3,000 8,000 5,000
(90,241) 92% n/a e) 150,000 75,000 (75,000)
1,004 92% n/a 2,000 4,000 2,000
1,320 92% n/a - 1,320 1,320
37,528 92% n/a f) 37,528 37,528
2,100 92% n/a - 3,000 3,000
667 92% 93% 60,000 60,000
(19,323) 92% 46% 42,450 42,450
1,050 92% 109% 6,000 8,000 2,000
6,417 92% 220% 5,000 11,000 6,000
5,512 92% 229% 4,000 10,000 6,000
(2,447) 92% n/a 5,000 5,000 -
3,475 92% 121% 12,000 15,000 3,000
486 92% 138% 1,050 1,500 450
45,632 92% 120% g) 160,000 200,000 40,000
26,596 92% 186% 28,333 55,000 26,667
154 92% 96% 3,533 3,533
50,120 92% 259% h) 30,000 77,619 47,619
50 92% n/a 50 50
2,437,679 92% 105% 17,772,417 18,815,952 1,043,535
16,291,381
18,729,060
291,682
277,906
87,411
26,332
1,102
253,468
18,761,900 22,072,521 3,310,621 92% 109% 20,242,936 22,159,413 1,916,477
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 18,556,026
Exp. %
15,667,565 2,888,461 92% 77% i) 20,242,936 17,217,280 3,025,656
TOTAL REQUIREMENTS 18,556,026 15,667,565 2,888,461 92% 77% 20,242,936 17,217,280 3,025,656
NET (Resources - Requirements) 205,874 6,404,956 6,199,082
Beginning NWC per Approved Budget
- 4,942,133 4,942,133
a) Projection based on actual collections through May 31, 2010.
b) Unplanned JAG Grant received.
c) Timing of Emergency Planning grant reimbursements.
d) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
e) Less than planned reimbursement for training missions and equipment.
f) Insurance reimbursement damaged vehicle offset by replacement expense.
g) Reflects ORS increase in Civil fees effective January 2010.
h) FBI relocation from Sheriffs Office has been delayed resulting in 9 months of additional rental revenue.
i) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
4,722,862
Year End
Budget
Projection
Variance
$ 2,470,519
$ 3,343,461 $ 872,942
1,526,657 92% 102% a) 14,819,703 15,111,385
319,573 92% 156% a) 500,000 777,906
90,328 92% 350% b) 35,000 122,411
29,890 92% 158% c) 45,156 71,488
1,519 92% 122% 5,000 6,102
396,901 92% 115% d) 1,721,192 1,974,660
417 92% n/a 5,000 5,000
(412) 92% 91% 129,000 129,000
2,706 92% 182% 3,000 8,000 5,000
(90,241) 92% n/a e) 150,000 75,000 (75,000)
1,004 92% n/a 2,000 4,000 2,000
1,320 92% n/a - 1,320 1,320
37,528 92% n/a f) 37,528 37,528
2,100 92% n/a - 3,000 3,000
667 92% 93% 60,000 60,000
(19,323) 92% 46% 42,450 42,450
1,050 92% 109% 6,000 8,000 2,000
6,417 92% 220% 5,000 11,000 6,000
5,512 92% 229% 4,000 10,000 6,000
(2,447) 92% n/a 5,000 5,000 -
3,475 92% 121% 12,000 15,000 3,000
486 92% 138% 1,050 1,500 450
45,632 92% 120% g) 160,000 200,000 40,000
26,596 92% 186% 28,333 55,000 26,667
154 92% 96% 3,533 3,533
50,120 92% 259% h) 30,000 77,619 47,619
50 92% n/a 50 50
2,437,679 92% 105% 17,772,417 18,815,952 1,043,535
16,291,381
18,729,060
291,682
277,906
87,411
26,332
1,102
253,468
18,761,900 22,072,521 3,310,621 92% 109% 20,242,936 22,159,413 1,916,477
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 18,556,026
Exp. %
15,667,565 2,888,461 92% 77% i) 20,242,936 17,217,280 3,025,656
TOTAL REQUIREMENTS 18,556,026 15,667,565 2,888,461 92% 77% 20,242,936 17,217,280 3,025,656
NET (Resources - Requirements) 205,874 6,404,956 6,199,082
Beginning NWC per Approved Budget
- 4,942,133 4,942,133
a) Projection based on actual collections through May 31, 2010.
b) Unplanned JAG Grant received.
c) Timing of Emergency Planning grant reimbursements.
d) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
e) Less than planned reimbursement for training missions and equipment.
f) Insurance reimbursement damaged vehicle offset by replacement expense.
g) Reflects ORS increase in Civil fees effective January 2010.
h) FBI relocation from Sheriffs Office has been delayed resulting in 9 months of additional rental revenue.
i) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
4,722,862
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
Grants
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
Claims Reimbursement
Security & Traffic Reimb
Seat Belt Program
Miscellaneous
Sheriff Fees
Court Fines & Fees
Impound Fees
Restitution - Street Crimes
Seizure/Forfeiture
Interest
Interest on Unsegregated
Sale of Reportable Assets
Sale of Equip & Material
Total Revenues
TOTAL RESOURCES
SHERIFF 702
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
CoII. %
$ 1,287,473 $ 1,433,708 $ 146,235 92%
6,636,393
219,083
1,833
70,125
171,997
61,417
114,096
791,233
1,637,934
385,014
917
24,918
74,752
1,833
91,667
11,917
5,500
9,167
4,583
77,917
68,750
9,167
1,650
5,500
7,403,308
399,447
65,784
57,375
139,487
49,749
78,500
3,468
10,000
1,637,934
381,347
1,405
24,917
74,751
2,084
57,745
36,232
7,871
8,500
8,872
11,093
123,353
11,300
1,074
1,122
15,609
1,662
6,779
12,559
766,915
180,364
63,951
(12,750)
(32,510)
(11,668)
(35,596)
3,468
(781,233)
(3,667)
488
(1)
(1)
251
(33,922)
36,232
(4,046)
3,000
(295)
6,510
45,436
(57,450)
1,074
1,122
6,442
12
6,779
7,059
10,477,363 10,633,327
11,764,836 12,067, 035
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 11,657,545
TOTAL REQUIREMENTS
155,964
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
92%
302,199 92%
n/a $ 1,287,473
102% a) 7,239,702
167% a) 239,000
3289% b) 2,000
75% 76,500
74% 187,633
74% 67,000
63% 124,468
n/a
1% 863,163
92% 1,786,837
91% c) 420,015
141% 1,000
92% 27,183
92% 81,548
104% 2,000
n/a d) 100,000
n/a e)
61% 13,000
142% 6,000
89% 10,000
222% 5,000
145% 85,000
15% f) 75,000
n/a
n/a -
156% 10,000
92% 1,800
n/a -
209% 6,000
$1,433,708 $ 146,235
7,403,308
399,447
65,784
76,500
187,633
67,000
124,468
3,468
863,163
1,786,837
416,016
1,405
27,183
81,548
2,084
80,000
36,232
13,000
9,000
10,000
12,000
135,000
13,371
1,074
2,500
20,000
1,800
8,000
13,000
163,606
160,447
63,784
3,468
(3,999)
405
84
(20,000)
36,232
3,000
7,000
50,000
(61,629)
1,074
2,500
10,000
8,000
7,000
93% 11,429,849
11,860,821 430,972
95% 12,717,322 13,294,529 577,207
Exp. %
10,307,237 1,350,308 92% 81% g) 12,717,322 11,087,596 1,629,726
11,657,545 10,307,237 1,350,308 92% 81% 12,717,322 11,087,596 1,629,726
NET (Resources - Requirements) 107,291 1,759,798 1,652,507
Beginning NWC per Approved Budget
- 2,206,933 2,206,933
a) Projection based on actual collections through May 31, 2010.
b) Unplanned JAG grant received and higher than planned HIDTA reimbursements.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) Variance due to timing of revenue and expenses.
e) Insurance reimbursement damaged vehicle offset by replacement expense.
f) Change in law resulting in less impound fee revenue.
g) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
1,905,939
Year End
Budget
Projection
Variance
n/a $ 1,287,473
102% a) 7,239,702
167% a) 239,000
3289% b) 2,000
75% 76,500
74% 187,633
74% 67,000
63% 124,468
n/a
1% 863,163
92% 1,786,837
91% c) 420,015
141% 1,000
92% 27,183
92% 81,548
104% 2,000
n/a d) 100,000
n/a e)
61% 13,000
142% 6,000
89% 10,000
222% 5,000
145% 85,000
15% f) 75,000
n/a
n/a -
156% 10,000
92% 1,800
n/a -
209% 6,000
$1,433,708 $ 146,235
7,403,308
399,447
65,784
76,500
187,633
67,000
124,468
3,468
863,163
1,786,837
416,016
1,405
27,183
81,548
2,084
80,000
36,232
13,000
9,000
10,000
12,000
135,000
13,371
1,074
2,500
20,000
1,800
8,000
13,000
163,606
160,447
63,784
3,468
(3,999)
405
84
(20,000)
36,232
3,000
7,000
50,000
(61,629)
1,074
2,500
10,000
8,000
7,000
93% 11,429,849
11,860,821 430,972
95% 12,717,322 13,294,529 577,207
Exp. %
10,307,237 1,350,308 92% 81% g) 12,717,322 11,087,596 1,629,726
11,657,545 10,307,237 1,350,308 92% 81% 12,717,322 11,087,596 1,629,726
NET (Resources - Requirements) 107,291 1,759,798 1,652,507
Beginning NWC per Approved Budget
- 2,206,933 2,206,933
a) Projection based on actual collections through May 31, 2010.
b) Unplanned JAG grant received and higher than planned HIDTA reimbursements.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) Variance due to timing of revenue and expenses.
e) Insurance reimbursement damaged vehicle offset by replacement expense.
f) Change in law resulting in less impound fee revenue.
g) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
1,905,939
RESOURCES:
Beg. Net Working Capital
Revenues
PUBLIC HEALTH
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ 900,000 $ 1,120,355 $ 220,355 100% 124%
Medicare Reimbursement 3,667
State Grant 2,483,919
Child Dev & Rehab Center 31,842
State Miscellaneous 195,470
OMAP 277,750
Family Planning Exp Proj 435,417
Grants
FY 2008-2009
Miscellaneous -
Patient Insurance Fees 122,650
Health Dept/Patient Fees 139,471
Vital Records -Birth 33,000
Vital Records -Death 89,833
Interest on Investments 34,833
Donations 8,067
Interfund Contract 84,051
Administrative Fee 24,750
Drug Court Byrne 36,742
Revised
Year End
Budget
Projection
Variance
$ 900,000 $ 1,120,355 $ 220,355
346 (3,321) 92% 9% 4,000
2,095,576 (388,343) 92% 77% 2,709,730
23,069 (8,773) 92% 66% 34,737
187,510 (7,960) 92% 88% 213,240
466,425 188,675 92% 154% 303,000
454,613 19,196 92% 96% 475,000
48,291 48,291 92% n/a a)
4,568 4,568 92% n/a
2,440 2,440 92% n/a -
141,548 18,898 92% 106% 133,800
115,741 (23,730) 92% 76% 152,150
30,250 (2,750) 92% 84% 36,000
87,400 (2,433) 92% 89% 98,000
14,918 (19,915) 92% 39% 38,000
42,381 34,314 92% 482% 8,800
60,381 (23,670) 92% 66% b) 91,692
24,750 92% 92% 27,000
11,733 (25,009) 92% n/a 40,082
Total Revenues 4,001,462
Transfers In -Reserve Fund 22,917
Transfers In -General Fund 2,124,618
TOTAL RESOURCES 7,048,997
REQUIREMENTS:
Expenditures
Personal Services 4,169,298
Materials and Services 1,753,323
Capital Outlay 79,660
Transfers Out 137,500
Contingency 834,215
TOTAL REQUIREMENTS
NET (Resources - Requirements)
570 (3,430)
2,504,873 (204,857)
30,759 (3,978)
227,646 14,406
511,827 208,827
510,530 35,530
48,291 48,291
4,568 4,568
2,440 2,440
155,416 21,616
126,000 (26,150)
32,000 (4,000)
90,000 (8,000)
16,180 (21,820)
42,381 33,581
75,887 (15,805)
27,000
30,061 (10,021)
3,811,940 (189,522) 92% 87% 4,365,231 4,436,429 71,198
25,000 2,083 92% 100% 25,000 25,000
2,124,618 92% 92% 2,317,765 2,317,765
7,081,913 30,833 92% 93% 7,607,996 7,899,549 291,553
3,879,210
1,509,898
26,414
112,500
290,088
243,425
53,246
25,000
834,215
Exp. (Y0
92% 85%
92% 79%
92% 30%
92%
92% n/a
75%
6,973,996 5,528,022 1,445,974 92% 73%
75,001 1,553,891 1,476,807
Beginning NWC per Approved Budget
4,548,325
1,912,716
86,902
150,000
910,053
4,471,914
1,792,346
86,902
150,000
76,411
120,370
910,053
7,607,996 6,501,162 1,106,834
- 1,398,387 1,398,387
a) Grants for HIV and Chronic Care were not included in FY 2010 budget.
b) Public Health Nurse II for Juvenile, reduced to .60 FTE from .75 FTE. Contract is for actual expenditure.
1,100,000
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
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
Eleven Months Ended May 31, 2010
Revised
Year to Date
Budget
Actual Variance
FY % Coll. %
Revised
Year End
Budget
Projection
Variance
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004)
5,042
114,583
1,833
91,501
4,837,329
169,323
275,646
97,167
64,167
37,400
226,875
10,542
29,333
15,125
2,750
2,860
2,782,041
20,167
116,417
4,545
119,574
90
95,346
5,071,692
158,451
114,682
108,219
83,000
31,724
104,355
2,704
13,129
36,377
11,750
7,000
2,756,292
36,488
116,031
(497)
4,991
(1,743)
3,845
234,363
(10,872)
(160,964)
11,052
18,833
(5,676)
(122,520)
(7,838)
13,129
7,044
(3,375)
4,250
(2,860)
(25,749)
16,321
(386)
92% 83% 5,500
92% 96% 125,000
92% 5% 2,000
92% 96% a) 99,819
92% 96% b) 5,277,086
92% 86% 184,716
92% 38% 300,705
92% 102% 106,000
92% 119% 70,000
92% 78% 40,800
92% 42% 247,500
92% 24% 11,500
92% n/a
92% 114% 32,000
92% 71% 16,500
92% 233% 3,000
92% 0% 3,120
92% 91% 3,034,954
92% 166% 22,000
92% 91% a) 127,000
8,900,101 8,871,449 (28,652) 92% 91%
1,206,479
234,333
1,206,479
332,870
92% 92%
98,537 92% 130%
5,500
125,000
120
115,400
5,351,224
184,716
200,000
130,000
83,000
36,000
115,000
3,500
13,129
40,000
16,500
7,000
3,031,954
47,000
127,000
(1,880)
15,581
74,138
(100,705)
24,000
13,000
(4,800)
(132,500)
(8,000)
13,129
8,000
4,000
(3,120)
(3,000)
25,000
9,709,200
1,316,158
255,636
9,632,043 (77,157)
1,316,158
363,129 107,493
13,065,913 13,000,794 (65,119) 92% 93% 14,005,994 13,901,326 (104,668)
7,397,725
3,715,721
73,333
137,500
1,514,549
6,811,352
3,198,283
112,500
586,373
517,438
73,333
25,000
1,514,549
92%
92%
92%
92%
92%
Exp. %
84% c)
79%
0%
75%
n/a
8,070,245
4,053,514
80,000
150,000
1,652,235
7,470,661
3,653,514
599,584
400,000
80,000
150,000
- 1,652,235
12,838,828 10,122,135 2,716,693 92% 72% 14,005,994 11,274,175 2,731,819
227,085 2,878,659 2,651,574
Beginning NWC per Approved Budget
a) Grant billing received quarterly, in arrears.
b) Department of Human Services Grant projected at amended contract amount for FY 2010.
c) 10% reduction in hours through 12/31/09.
- 2,627,151 2,627,151
2,616,050
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
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 3,346 15,130 11,784 92% 415% a) 3,650 16,400 12,750
Admin -GIS 1,902 30,729 28,827 92% 1481% b) 2,075 39,900 37,825
Admin -Code Enforcement 173,663 157,895 (15,768) 92% 83% c) 189,450 172,650 (16,800)
Building Safety 893,544 880,033 (13,511) 92% 90% 974,775 951,450 (23,325)
Electrical 257,125 238,849 (18,276) 92% 85% c) 280,500 261,800 (18,700)
Contract Services 234,208 117,117 (117,091) 92% 46% d) 255,500 136,700 (118,800)
Env Health -On Site Prog 268,446 218,541 (49,906) 92% 75% c) 292,850 244,650 (48,200)
Env Health-Lic Facilities 632,935 689,379 56,444 92% 100% e) 690,475 706,650 16,175
Env Health - Drinking H2O 87,368 77,278 (10,090) 92% 81% f) 95,311 95,300 (11)
Planning -Current 902,138 606,098 (296,040) 92% 62% c) 984,150 685,350 (298,800)
Planning -Long Range 393,158 294,476 (98,682) 92% 69% c) 428,900 349,100 (79,800)
Total Revenues 3,847,833 3,325,526 (522,307) 92%
79%
4,197,636 3,659,950 (537,686)
Trans In -GF 1,115,242 1,115,242 92% 92% 1,216,627 1,216,627
Trans In -GF for Lng Rng Ping 275,000 275,000 - 92% 92% 300,000 300,000
Trans In -Other 106,149 114,734 8,585 92% 99% 115,799 114,734 (1,065)
TOTAL RESOURCES 5,757,695 5,460,161 (297,534) 92% 87% 6,243,533 5,920,970 (322,563)
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
Exp. %
1,565,769 1,478,972 86,797 92% 87% g) 1,708,112 1,640,551 67,561
197,639 189,326 8,313 92% 88% 215,606 210,420 5,186
165,888 150,509 15,379 92% 83% g) 180,969 156,688 24,281
664,716 590,399 74,317 92% 81% g) 725,145 613,244 111,901
189,492 172,808 16,684 92% 84% g) 206,719 187,846 18,873
242,716 229,372 13,344 92% 87% g) 264,781 245,643 19,138
220,630 217,415 3,215 92% 90% 240,687 233,730 6,957
454,617 473,788 (19,171) 92% 96% h) 495,946 496,146 (200)
73,882 76,353 (2,471) 92% 95% h) 80,598 82,069 (1,471)
742,301 716,168 26,133 92% 88% g,i) 809,783 793,139 16,644
505,842 409,722 96,120 92% 74% 551,828 457,503 94,325
162,855 177,660 (14,805) 92% 100% 177,660 177,660
536,891 536,891 92% n/a 585,699 585,699
TOTAL REQUIREMENTS 5,723,238 4,882,490 840,748 92% 78% 6,243,533 5,294,639 948,894
NET (Resources - Requirements)
34,457 577,671 543,214 626,331 626,331
Beginning NWC per Approved Budget 686,081
Revenues 3,325,526 3,659,950
Expenditures 4,882,490 5,294,639
Net from Operations (1,556,964) (1,634,689)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance.
b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer.
c) Projections are below budget due to recent volume downturns in the fall and winter.
d) Significant drop-off in City of Redmond work.
e) Revenue is received primarily in December through February following mailing of license renewal statements.
f) Payments from State DHS are received irregularly.
g) Projection reflects layoffs/hour reductions effective in February and the Building Official retirement in November.
h) Due to classification changes and salary adjustments, it is expected that total budget will be slightly exceeded.
i) Savings from retired Associate Planner are not included as they approximately equal pay out of vacation leave.
ROAD
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
Revenues
Federal Reimbursements 449,167 - (449,167) 92% 0% 490,000 12,154 (47',846)
System Development Chrg - 462 462 92% n/a - 462 462
Mineral Lease Royalties 9,167 115,306 106,139 92% 1153% 10,000 115,306 10'1,306
Forest Receipts 2,275,167 2,482,310 207,143 92% 100% a) 2,482,000 2,482,350 350
State Grant 380,854 (380,854) 92% 0% 415,477 (41' 1,477)
State Miscellaneous 54,322 54,322 92% n/a 54,322 5.,322
Motor Vehicle Revenue 7,333,333 7,075,973 (257,360) 92% 88% 8,000,000 7,800,000 (201 1,000)
City of Bend 206,250 281,666 75,416 92% 125% b) 225,000 281,666 51,666
City of Redmond 229,167 316,603 87,436 92% 127% b) 250,000 316,603 66,603
City of Sisters 9,167 - (9,167) 92% 0% b) 10,000 800 (0,200)
City of La Pine 9,167 - (9,167) 92% n/a b) 10,000 (1(1,000)
Admin Recovery (SDC) 458 1,304 846 92% n/a 500 1,304 804
Miscellaneous 119,167 154,961 35,794 92% 119% 130,000 156,075 25,075
Road Vacations 917 500 (417) 92% 50% 1,000 500 (500)
Interest on Investments 45,833 43,852 (1,981) 92% 88% 50,000 47,852 (1,148)
Other Bank/LGIP Interest 1,676 1,676 92% n/a 1,700 ,700
Parking Fees 300 300 92% n/a 375 375
Interfund Contract 641,667 (641,667) 92% 0% c) 700,000 730,000 30,000
Equipment Repairs 252,083 220,477 (31,606) 92% 80% 275,000 245,000 (30,000)
Vehicle Repairs 82,500 - (82,500) 92% 0% c) 90,000 90,000 -
Vegetation Management 32,083 - (32,083) 92% 0% c) 35,000 20,000 (15,000)
Inter -fund: Forester 20,167 12,153 (8,014) 92% 55% c) 22,000 22,000
Car Washes 2,292 2,880 588 92% 115% 2,500 3,300 800
Car Rental 406 406 92% n/a 500 500
Forester - - 92% n/a 12,153 11,153
Sale of Eqp & Material 733,333 641,867 (91,466) 92% 80% 800,000 665,559 (134,441)
Total Revenues 12,831,939 11,407,018 (1,424,921) 92% 81% 13,998,477 13,059,981 (938,496)
Trans In - CDD
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
16,674 18,190 1,516 92% 100% 18,190 18,190
649,521 531,426 (118,095) 92% 75% d) 708,567 708,567
68,750 56,250 (12,500) 92% 75% d) 75,000 75,000
9,167 (9,167) 92% 0% c) 10,000 10,000
18,378,966 16,904,533 (1,530,683) 92% 93% 19,681,899 18,763,387 (91)3,512)
Exp. %
5,193,259 4,870,086 323,173 92% 86% 5,665,373 5,311,065 354,308
8,372,109 6,263,388 2,108,721 92% 69% e) 9,133,210 8,399,489 735,721
2,475,000 1,302,528 1,172,472 92% 48% 2,700,000 1,312,528 1,387,472
366,667 400,000 (33,333) 92% 100% 400,000 400,000 -
1,634,706 1,634,706 92% n/a 1,783,316 1,785,316
TOTAL REQUIREMENTS 18,041,741 12,836,002 5,205,739 92% 65% 19,681,899 15,423,082 4,25 1,817
NET (Resources - Requirements)
337,225 4,068,531 3,675,056 3,340,305 3,341,305
Beginning NWC per Approved Budget 3,430,429
a) Annual payment, $2,482,350, received January 15, 2010.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Transfer made quarterly.
e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984
Revenues
Federal Reimbursements 449,167 - (449,167) 92% 0% 490,000 12,154 (47',846)
System Development Chrg - 462 462 92% n/a - 462 462
Mineral Lease Royalties 9,167 115,306 106,139 92% 1153% 10,000 115,306 10'1,306
Forest Receipts 2,275,167 2,482,310 207,143 92% 100% a) 2,482,000 2,482,350 350
State Grant 380,854 (380,854) 92% 0% 415,477 (41' 1,477)
State Miscellaneous 54,322 54,322 92% n/a 54,322 5.,322
Motor Vehicle Revenue 7,333,333 7,075,973 (257,360) 92% 88% 8,000,000 7,800,000 (201 1,000)
City of Bend 206,250 281,666 75,416 92% 125% b) 225,000 281,666 51,666
City of Redmond 229,167 316,603 87,436 92% 127% b) 250,000 316,603 66,603
City of Sisters 9,167 - (9,167) 92% 0% b) 10,000 800 (0,200)
City of La Pine 9,167 - (9,167) 92% n/a b) 10,000 (1(1,000)
Admin Recovery (SDC) 458 1,304 846 92% n/a 500 1,304 804
Miscellaneous 119,167 154,961 35,794 92% 119% 130,000 156,075 25,075
Road Vacations 917 500 (417) 92% 50% 1,000 500 (500)
Interest on Investments 45,833 43,852 (1,981) 92% 88% 50,000 47,852 (1,148)
Other Bank/LGIP Interest 1,676 1,676 92% n/a 1,700 ,700
Parking Fees 300 300 92% n/a 375 375
Interfund Contract 641,667 (641,667) 92% 0% c) 700,000 730,000 30,000
Equipment Repairs 252,083 220,477 (31,606) 92% 80% 275,000 245,000 (30,000)
Vehicle Repairs 82,500 - (82,500) 92% 0% c) 90,000 90,000 -
Vegetation Management 32,083 - (32,083) 92% 0% c) 35,000 20,000 (15,000)
Inter -fund: Forester 20,167 12,153 (8,014) 92% 55% c) 22,000 22,000
Car Washes 2,292 2,880 588 92% 115% 2,500 3,300 800
Car Rental 406 406 92% n/a 500 500
Forester - - 92% n/a 12,153 11,153
Sale of Eqp & Material 733,333 641,867 (91,466) 92% 80% 800,000 665,559 (134,441)
Total Revenues 12,831,939 11,407,018 (1,424,921) 92% 81% 13,998,477 13,059,981 (938,496)
Trans In - CDD
Trans In - Solid Waste
Trans In - Transp SDC
Trans In -Road Imp Res
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
16,674 18,190 1,516 92% 100% 18,190 18,190
649,521 531,426 (118,095) 92% 75% d) 708,567 708,567
68,750 56,250 (12,500) 92% 75% d) 75,000 75,000
9,167 (9,167) 92% 0% c) 10,000 10,000
18,378,966 16,904,533 (1,530,683) 92% 93% 19,681,899 18,763,387 (91)3,512)
Exp. %
5,193,259 4,870,086 323,173 92% 86% 5,665,373 5,311,065 354,308
8,372,109 6,263,388 2,108,721 92% 69% e) 9,133,210 8,399,489 735,721
2,475,000 1,302,528 1,172,472 92% 48% 2,700,000 1,312,528 1,387,472
366,667 400,000 (33,333) 92% 100% 400,000 400,000 -
1,634,706 1,634,706 92% n/a 1,783,316 1,785,316
TOTAL REQUIREMENTS 18,041,741 12,836,002 5,205,739 92% 65% 19,681,899 15,423,082 4,25 1,817
NET (Resources - Requirements)
337,225 4,068,531 3,675,056 3,340,305 3,341,305
Beginning NWC per Approved Budget 3,430,429
a) Annual payment, $2,482,350, received January 15, 2010.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Transfer made quarterly.
e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782
Revenues
DOC Measure 57 199,196 217,350 18,154 92% 100% a) 217,305 217,350 45
State Miscellaneous 7,333 4,301 (3,032) 92% 54% b) 8,000 4,301 (3,699)
Alternate Incarceration 30,918 30,918 92% n/a c) 30,918 30,918
State Subsidy 27,042 13,306 (13,736) 92% 45% c) 29,500 13,306 (16,194)
SB 1145 2,603,265 2,961,989 358,724 92% 104% d) 2,839,925 2,961,990 122,065
Probation Work Crew Fees 36,667 30,535 (6,132) 92% 76% 40,000 35,000 (5,000)
Miscellaneous 2,750 4,235 1,485 92% 141% 3,000 5,000 2,000
Electronic Monitoring Fee 146,667 175,826 29,159 92% 110% e) 160,000 190,000 30,000
Probation Superv. Fees 201,667 214,376 12,709 92% 97% 220,000 220,000
Interest on Investments 8,250 11,550 3,300 92% 128% 9,000 12,564 3,564
Interfund - Sheriff 45,833 37,500 (8,333) 92% 75% 50,000 50,000
Crime Prevention Services 45,833 37,500 (8,333) 92% 75% f) 50,000 50,000
Total Revenues 3,324,503 3,739,386 414,883 92% 103% 3,626,730 3,790,429 163,699
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
105,444 105,444
- 92% 92%
115,029 115,029
3,897,839 4,332,504 434,665 92% 103% 4,209,651 4,393,132 183,481
Exp. %
2,739,072 2,605,758 133,314 92% 87% 2,988,079 2,925,079 63,000
726,067 676,033 50,034 92% 85% 792,073 792,073
36,758 14,148 22,610 92% 35% 40,100 40,000 100
356,949 356,949 92% n/a 389,399 389,399
TOTAL REQUIREMENTS 3,858,846 3,295,939 562,907 92% 78% 4,209,651 3,757,152 452,499
NET (Resources - Requirements)
38,993 1,036,565 997,572 635,980 635,980
Beginning NWC per Approved Budget 616,371
a) New grant, appropriated for drug addicted offenders, received January 2010.
b) Error in budget. $8,000 is the estimated amount to be received for the biennium ended June 30, 2011.
c) AIP Fund and Subsidy Fund were split in the budget year.
d) Offender population was larger than anticipated, greater portion of the state fund.
e) Electronic monitoring usage is higher from the courts.
f) Receipt of payment at the end of each quarter.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 337,150 265,337 (71,813) 92% 72% d) 367,800 367,800
Title IV - Family Sup/Pres 34,514 12,545 (21,969) 92% 33% a) 37,652 14,907 (22,745)
HealthyStart Medicaid 87,083 53,460 (33,623) 92% 56% 95,000 79,223 (15,777)
Child Care Block Grant 74,502 (74,502) 92% 0% a) 81,275 (81,275)
Level 7 Services 160,594 210,673 50,079 92% 120% a) 175,193 257,982 82,789
HealthyStart /R -S -G 281,946 308,924 26,978 92% 100% a) 307,577 308,924 1,347
OCCF Grant 562,881 501,959 (60,922) 92% 82% a) 614,052 507,183 (106,869)
Local Government Grants 7,849 7,849 92% n/a e) 7,849 7,849
Charges for Svcs-Misc 7,333 2,966 (4,367) 92% 37% 8,000 4,000 (4,000)
Court Fines & Fees 68,750 71,745 2,995 92% 96% c) 75,000 75,000
Interest on Investments 27,500 8,338 (19,162) 92% 28% f) 30,000 10,000 (20,000)
Grants -Private 1,833 (1,833) 92% 0% 2,000 (2,000)
Donations 4,000 4,000 92% n/a 4,000 4,000
Video Lottery 2,000 2,000 92% n/a g) 2,000 2,000
Interfund Grants 171,875 167,500 (4,375) 92% 89% 187,500 187,500
Crime Prevention Services 68,154 49,565 (18,589) 92% 67% 74,350 74,350
Total Revenues 1,884,115 1,666,861 (217,254) 92% 81% 2,055,399 1,900,718 (154,681)
Trans from General Fund 260,639 260,639
Total Transfers In
- 92% 92% 284,333 284,333
260,639 260,639 - 92% 92% 284,333 284,333
•
TOTAL RESOURCES 2,769,297 2,596,126 (173,171) 92% 88% 2,964,275 2,853,677 (110,598)
REQUIREMENTS:
Expenditures
Personal Services 494,980 488,742 6,238 92% 91% b) 539,978 526,639 13,339
Materials and Services 1,758,023 1,301,274 456,749 92% 68% a,d,e) 1,917,843 1,695,072 222,771
Capital Outlay 92 92 92% 0% 100 100
Contingency 464,158 464,158 92% n/a 506,354 - 506,354
Exp. %
TOTAL REQUIREMENTS 2,717,253 1,790,016 927,237 92% 60% 2,964,275 2,221,711 742,564
NET (Resources - Requirements)
52,044 806,110 754,066
631,966 631,966
Beginning NWC per Approved Budget 562,762
a) Revenue projections based on final legislative allocations. Casey mini -grant of $8,800 added.
b) Personnel projection reduced due to two positions open in 1st quarter.
c) Court fees reduced for FY 2010.
d) New federal grant for the Family Access Network awarded. Some project expenses deferred to FY 2011.
e) Regional project contributions from Crook & Jefferson counties.
f) Interest revenue lower than projected.
g) BOCC video lottery grants received instead of private grants.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083
Revenues
Federal Grants 337,150 265,337 (71,813) 92% 72% d) 367,800 367,800
Title IV - Family Sup/Pres 34,514 12,545 (21,969) 92% 33% a) 37,652 14,907 (22,745)
HealthyStart Medicaid 87,083 53,460 (33,623) 92% 56% 95,000 79,223 (15,777)
Child Care Block Grant 74,502 (74,502) 92% 0% a) 81,275 (81,275)
Level 7 Services 160,594 210,673 50,079 92% 120% a) 175,193 257,982 82,789
HealthyStart /R -S -G 281,946 308,924 26,978 92% 100% a) 307,577 308,924 1,347
OCCF Grant 562,881 501,959 (60,922) 92% 82% a) 614,052 507,183 (106,869)
Local Government Grants 7,849 7,849 92% n/a e) 7,849 7,849
Charges for Svcs-Misc 7,333 2,966 (4,367) 92% 37% 8,000 4,000 (4,000)
Court Fines & Fees 68,750 71,745 2,995 92% 96% c) 75,000 75,000
Interest on Investments 27,500 8,338 (19,162) 92% 28% f) 30,000 10,000 (20,000)
Grants -Private 1,833 (1,833) 92% 0% 2,000 (2,000)
Donations 4,000 4,000 92% n/a 4,000 4,000
Video Lottery 2,000 2,000 92% n/a g) 2,000 2,000
Interfund Grants 171,875 167,500 (4,375) 92% 89% 187,500 187,500
Crime Prevention Services 68,154 49,565 (18,589) 92% 67% 74,350 74,350
Total Revenues 1,884,115 1,666,861 (217,254) 92% 81% 2,055,399 1,900,718 (154,681)
Trans from General Fund 260,639 260,639
Total Transfers In
- 92% 92% 284,333 284,333
260,639 260,639 - 92% 92% 284,333 284,333
•
TOTAL RESOURCES 2,769,297 2,596,126 (173,171) 92% 88% 2,964,275 2,853,677 (110,598)
REQUIREMENTS:
Expenditures
Personal Services 494,980 488,742 6,238 92% 91% b) 539,978 526,639 13,339
Materials and Services 1,758,023 1,301,274 456,749 92% 68% a,d,e) 1,917,843 1,695,072 222,771
Capital Outlay 92 92 92% 0% 100 100
Contingency 464,158 464,158 92% n/a 506,354 - 506,354
Exp. %
TOTAL REQUIREMENTS 2,717,253 1,790,016 927,237 92% 60% 2,964,275 2,221,711 742,564
NET (Resources - Requirements)
52,044 806,110 754,066
631,966 631,966
Beginning NWC per Approved Budget 562,762
a) Revenue projections based on final legislative allocations. Casey mini -grant of $8,800 added.
b) Personnel projection reduced due to two positions open in 1st quarter.
c) Court fees reduced for FY 2010.
d) New federal grant for the Family Access Network awarded. Some project expenses deferred to FY 2011.
e) Regional project contributions from Crook & Jefferson counties.
f) Interest revenue lower than projected.
g) BOCC video lottery grants received instead of private grants.
SOLID WASTE
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714
Revenues
State Grant 37,850 37,850 92% n/a a) 37,850 37,850
Miscellaneous 27,500 24,076 (3,424) 92% 80% 30,000 26,300 (3,700)
Franchise 3% Fees 183,333 207,138 23,805 92% 104% 200,000 209,638 9,638
Commercial Disp. Fees 1,280,033 770,563 (509,470) 92% 55% b) 1,396,400 835,000 (561,400)
Private Disposal Fees 1,412,858 1,260,474 (152,384) 92% 82% 1,541,300 1,372,474 (168,826)
Franchise Disposal Fees 4,348,208 3,486,586 (861,622) 92% 74% c) 4,743,500 3,827,651 (915,849)
Yard Debris 68,750 64,857 (3,893) 92% 86% 75,000 71,642 (3,358)
Special Waste 27,500 34,181 6,681 92% 114% d) 30,000 35,000 5,000
Interest 12,833 11,760 (1,073) 92% 84% 14,000 12,600 (1,400)
Leases 241 241 92% n/a 241 241
Interfund-Miscellaneous 5,952 5,952 92% n/a e) 5,952 5,952
Sale of Equip & Material 32,083 29,061 (3,022) 92% 83% 35,000 33,000 (2,0001
Total Revenues 7,393,098 5,932,739 (1,460,359) 92% 74% 8,065,200 6,467,348 (1,597,852)
TOTAL RESOURCES 7,731,709 6,399,064 (1,332,645) 92% 76% 8,403,811 6,933,673 (1,470,138)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,616,613 1,554,787 61,826 92% 88% 1,763,578 1,706,334 57,244
3,435,900 2,690,050 745,850 92% 72% f) 3,748,254 3,296,847 451,407
888,035 968,765 (80,730) 92% 100% 968,765 968,765
136,583 52,897 83,686 92% 36% g) 149,000 53,460 95,540
1,319,786 531,426 788,360 92% 37% h) 1,439,767 708,567 731,200
306,576 306,576 92% n/a 334,447 334,447
TOTAL REQUIREMENTS 7,703,493 5,797,925 1,905,568 92% 69% 8,403,811 6,733,973 1,669,838
NET (Resources - Requirements)
28,216 601,139 572,923 199,700 199,700
Beginning NWC per Approved Budget
392,509
a) Was due last fiscal year but received in FY 2010.
b) This is largely construction waste and has not picked back up as yet.
c) Rate increase went into effect January 1, 2010.
d) Unexpected revenue from a City of Bend clean-up.
e) Unexpected advertising reimbursement from funds Anna Johnson had available.
f) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year.
g) Capital item purchases have been suspended due to revenue shortfalls.
h) Will not be doing all transfers due to revenue shortfalls.
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 92% n/a a) 37,850 37,850
Miscellaneous 27,500 24,076 (3,424) 92% 80% 30,000 26,300 (3,700)
Franchise 3% Fees 183,333 207,138 23,805 92% 104% 200,000 209,638 9,638
Commercial Disp. Fees 1,280,033 770,563 (509,470) 92% 55% b) 1,396,400 835,000 (561,400)
Private Disposal Fees 1,412,858 1,260,474 (152,384) 92% 82% 1,541,300 1,372,474 (168,826)
Franchise Disposal Fees 4,348,208 3,486,586 (861,622) 92% 74% c) 4,743,500 3,827,651 (915,849)
Yard Debris 68,750 64,857 (3,893) 92% 86% 75,000 71,642 (3,358)
Special Waste 27,500 34,181 6,681 92% 114% d) 30,000 35,000 5,000
Interest 12,833 11,760 (1,073) 92% 84% 14,000 12,600 (1,400)
Leases 241 241 92% n/a 241 241
Interfund-Miscellaneous 5,952 5,952 92% n/a e) 5,952 5,952
Sale of Equip & Material 32,083 29,061 (3,022) 92% 83% 35,000 33,000 (2,0001
Total Revenues 7,393,098 5,932,739 (1,460,359) 92% 74% 8,065,200 6,467,348 (1,597,852)
TOTAL RESOURCES 7,731,709 6,399,064 (1,332,645) 92% 76% 8,403,811 6,933,673 (1,470,138)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,616,613 1,554,787 61,826 92% 88% 1,763,578 1,706,334 57,244
3,435,900 2,690,050 745,850 92% 72% f) 3,748,254 3,296,847 451,407
888,035 968,765 (80,730) 92% 100% 968,765 968,765
136,583 52,897 83,686 92% 36% g) 149,000 53,460 95,540
1,319,786 531,426 788,360 92% 37% h) 1,439,767 708,567 731,200
306,576 306,576 92% n/a 334,447 334,447
TOTAL REQUIREMENTS 7,703,493 5,797,925 1,905,568 92% 69% 8,403,811 6,733,973 1,669,838
NET (Resources - Requirements)
28,216 601,139 572,923 199,700 199,700
Beginning NWC per Approved Budget
392,509
a) Was due last fiscal year but received in FY 2010.
b) This is largely construction waste and has not picked back up as yet.
c) Rate increase went into effect January 1, 2010.
d) Unexpected revenue from a City of Bend clean-up.
e) Unexpected advertising reimbursement from funds Anna Johnson had available.
f) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year.
g) Capital item purchases have been suspended due to revenue shortfalls.
h) Will not be doing all transfers due to revenue shortfalls.
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
RISK MANAGEMENT
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
of FY
% Coll.
$2,491,977 $2,669,291 $177,314
100% 107% $2,491,977 $2,669,291 $177,314
General Liability 418,884 418,864 (20) 92% 92% 456,964 456,964
Property Damage 262,436 262,262 (174) 92% 92% 286,294 286,294
Vehicle 168,845 168,845 (0) 92% 92% 184,195 184,195
Workers' Compensation 784,533 784,520 (13) 92% 92% 855,854 855,854
Unemployment 146,842 146,853 11 92% 92% 160,191 160,191
Claims Reimb-Workers' Compensation 22,917 (22,917) 92% 0% 25,000 25,000
Claims Reimb-Gen Liab/Property 9,167 121,641 112,474 92% 1216% 10,000 125,000 115,0)0
Process Fee-Events/Parades 825 1,450 625 92% 161% 900 1,600 7 )0
Miscellaneous 3,667 (22) (3,689) 92% -1% 4,000 4,000
Skid Car Training 20,167 11,410 (8,757) 92% 52% 22,000 22,000
Interest on Investments 27,500 30,504 3,004 92% 102% 30,000 33,000 3,000
TOTAL REVENUES 1,865,782 1,946,327 80,546 92% 96% 2,035,398 2,154,098 118,700
Transfers In -PERS Reserve 92 (92) 92% 0% 100 (100
TOTAL RESOURCES 4,357,850 4,615,618 257,768 92% 102% 4,527,475 4,823,389 295,914
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
% Exp.
73,551
1,704
310
153,953 a)
25
4,542
334,686 234,084 100,602 92% 64% 365,112 260,000 105,112
Insurance 136,185 a)
Repair / Replacement 128,521 b)
Total Property Damage 311,667 264,706 46,961 92% 78% 340,000 275,000 65,000
VEHICLE
Professional Service 3,080
Insurance 411
Loss Prevention 15,383
Repair / Replacement 166,028
Total Vehicle 183,333 184,902 (1,568) 92% 92% c) 200,000 200,000
WORKERS' COMPENSATION
Settlement / Benefit 634,824
Insurance 102,386
Loss Prevention 35,115
Miscellaneous 32,594
Total Workers' Compensation 733,333 804,919 (71,586) 92% 101% 800,000 868,000 (68,000)
UNEMPLOYMENT - Settlement/Benefits 201,667 236,784 (35,117) 92% 108% d) 220,000 236,784 (16,7x34
Total Direct Insurance Costs 1,764,686 1,725,394 39,292 92% 90% 1,925,112 1,839,784 85,: 28
Insurance Administration:
Personal Services 251,198 249,002 2,196 92% 91% 274,034 274,034
Materials & Service 225,952 167,152 58,800 92% 68% 246,493 246,493
Capital Outlay 92 - 92 92% 0% 100 `00
Total Insurance Administration 477,241 416,154 61,088 92% 80% 520,627 520,527 '00
Contingency 1,908,258 - 1,908,258 92% n/a 2,081,736 - 2,081,"'36
TOTAL REQUIREMENTS 4,150,185 2,141,548 2,008,637 92% 47% 4,527,475 2,360,311 2,167, 64
NET 207,665 2,474,070 2,266,405 2,463,078 2,463,3 78
NWC per Approved Budget 2,500,000
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October.
b) Expenditures in property damage is offset by claims reimbursement revenue.
c) Vehicle settlement is higher than expected due to 2 total vehicle losses in the Sheriffs Office.
d) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and
Health Services.
Year End
Budget
Projection
Varian e
100% 107% $2,491,977 $2,669,291 $177,314
General Liability 418,884 418,864 (20) 92% 92% 456,964 456,964
Property Damage 262,436 262,262 (174) 92% 92% 286,294 286,294
Vehicle 168,845 168,845 (0) 92% 92% 184,195 184,195
Workers' Compensation 784,533 784,520 (13) 92% 92% 855,854 855,854
Unemployment 146,842 146,853 11 92% 92% 160,191 160,191
Claims Reimb-Workers' Compensation 22,917 (22,917) 92% 0% 25,000 25,000
Claims Reimb-Gen Liab/Property 9,167 121,641 112,474 92% 1216% 10,000 125,000 115,0)0
Process Fee-Events/Parades 825 1,450 625 92% 161% 900 1,600 7 )0
Miscellaneous 3,667 (22) (3,689) 92% -1% 4,000 4,000
Skid Car Training 20,167 11,410 (8,757) 92% 52% 22,000 22,000
Interest on Investments 27,500 30,504 3,004 92% 102% 30,000 33,000 3,000
TOTAL REVENUES 1,865,782 1,946,327 80,546 92% 96% 2,035,398 2,154,098 118,700
Transfers In -PERS Reserve 92 (92) 92% 0% 100 (100
TOTAL RESOURCES 4,357,850 4,615,618 257,768 92% 102% 4,527,475 4,823,389 295,914
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
% Exp.
73,551
1,704
310
153,953 a)
25
4,542
334,686 234,084 100,602 92% 64% 365,112 260,000 105,112
Insurance 136,185 a)
Repair / Replacement 128,521 b)
Total Property Damage 311,667 264,706 46,961 92% 78% 340,000 275,000 65,000
VEHICLE
Professional Service 3,080
Insurance 411
Loss Prevention 15,383
Repair / Replacement 166,028
Total Vehicle 183,333 184,902 (1,568) 92% 92% c) 200,000 200,000
WORKERS' COMPENSATION
Settlement / Benefit 634,824
Insurance 102,386
Loss Prevention 35,115
Miscellaneous 32,594
Total Workers' Compensation 733,333 804,919 (71,586) 92% 101% 800,000 868,000 (68,000)
UNEMPLOYMENT - Settlement/Benefits 201,667 236,784 (35,117) 92% 108% d) 220,000 236,784 (16,7x34
Total Direct Insurance Costs 1,764,686 1,725,394 39,292 92% 90% 1,925,112 1,839,784 85,: 28
Insurance Administration:
Personal Services 251,198 249,002 2,196 92% 91% 274,034 274,034
Materials & Service 225,952 167,152 58,800 92% 68% 246,493 246,493
Capital Outlay 92 - 92 92% 0% 100 `00
Total Insurance Administration 477,241 416,154 61,088 92% 80% 520,627 520,527 '00
Contingency 1,908,258 - 1,908,258 92% n/a 2,081,736 - 2,081,"'36
TOTAL REQUIREMENTS 4,150,185 2,141,548 2,008,637 92% 47% 4,527,475 2,360,311 2,167, 64
NET 207,665 2,474,070 2,266,405 2,463,078 2,463,3 78
NWC per Approved Budget 2,500,000
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October.
b) Expenditures in property damage is offset by claims reimbursement revenue.
c) Vehicle settlement is higher than expected due to 2 total vehicle losses in the Sheriffs Office.
d) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and
Health Services.
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
of FY
Coll.
Budget
Year End
Projection
Variance
RESOURCES:
Beg. Net Working Capital $5,137,000 $ 5,611,168 $ 474,168 100% 109% $5,137,000 $5,611,168 $ 474,168
Revenues
Property Taxes - Current 5,619,884 6,261,261 641,377 92% 102% a) 6,130,782 6,261,261 130,479
Property Taxes - Prior 91,667 280,639 188,972 92% 281% a) 100,000 280,639 180,639
State Reimbursement 22,458 5,700 (16,758) 92% 23% b) 24,500 6,000 (18,500)
Telephone User Tax 491,333 653,956 162,623 92% 122% 536,000 653,956 117,956
Data Network Reimb. 31,167 26,032 (5,135) 92% 77% c) 34,000 27,880 (6,120)
Jefferson County 25,667 43,516 17,849 92% 155% 28,000 43,516 15,516
User Fee 55,458 55,706 248 92% 92% 60,500 60,500
Contract Payments 64,167 25,574 (38,593) 92% 37% d) 70,000 26,000 (44,000)
Miscellaneous 7,792 8,408 616 92% 99% 8,500 8,500
Interest 33,000 78,071 45,071 92% 217% 36,000 78,071 42,071
Interest on Unsegregated Tax 3,438 1,406 (2,032) 92% 37% 3,750 3,750
Total Revenues 6,446,031 7,440,269 994,238 92% 106% 7,032,032 7,450,073 418,041
Transfers In -Other 92 (92) 92% 0%
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
100 (100)
11,583,031 13,051,437 1,468,406 92% 107% 12,169,132 13,061,241 892,109
% Exp.
3,498,263 3,203,094 295,169 92% 84% 3,816,287 3,606,287 210,000
1,182,062 1,038,931 143,131 92% 81% 1,289,522 1,250,000 39,522
160,417 13,830 146,587 92% 8% 175,000 175,000
1,777,361 1,938,939 (161,578) 92% 100% 1,938,939 1,938,939
4,536,935 4,536,935 92% n/a 4,949,384 4,949,384
TOTAL REQUIREMENTS 11,155,038 6,194,794 4,960,244 92% 51% 12,169,132 6,970,226 5,198,906
NET (Resources - Requirements)
427,993 6,856,643 6,428,650 - 6,091,015 6,091,015
Beginning NWC per Approved Budget 5,861,335
a) Projection based on actual collections through November 30, 2009.
b) Less activity being performed.
c) Annual billings.
d) Less contract activity with law enforcement agencies.
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
Prr Emp - Add'I Prem
Employee Prem Contribution
COIL
Retiree / COBRA Co -Pay
Prescription Rebates
Interest
Total Revenues
TOTAL RESOURCES
Health Benefits Trust
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$17,894,797 $17,894,797 $
Revised
Budget *
Year End
Projection
Variance
TFY 2011
Approved Budget
16,400,000
11,246,000
50,000
500,000
975,000
450,000
100% 100% $17,894,797 $17,894,797 $
9,606,667 9,598,960 (7,706) 92% 92% a)
50,417 40,622 (9,795) 92% 74%
302,500 312,913 10,413 92% 95%
916,667 1,036,583 119,917 92% 104%
458,333 545,924 87,591 92% 109%
42,066 42,066 92% n/a
206,250 195,253 (10,997) 92% 87%
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Conferences and Seminars
Claims Paid-Medical/Rx
Claims Paid-DentaWision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Printing
Program Supplies
Workplace Clinic
Other
Total Materials & Services
Capital Outlay
Contingency
10, 480, 000 10, 480, 000
55,000 43,922 (11,078)
330,000 340,913 10,913
1,000,000 1,136,583 136,583
500,000 595,924 95,924
42,066 42,066
225,000 208,253 (16,747) 100,000
11,540,833 11,772,321 231,488 92% 94% 12,590,000 12,847,661 257,661 13,321,000
29,435,630 29,667,118 231,488 92% 97% 30,484,797 30,742,457 257,661 29,721,000
Exp. %
100,189 95,102 5,087 92% 87%
109,297 104,210 5,087 129,280
2,750 749 2,001 92% 25% 3,000 749 2,251 3,000
13,060,278 10,507,506 2,552,773 92% 74% b) 14,247,576 11,383,131 2,864,445 13,572,000
1,670,167 1,588,034 82,133 92% 87% b) 1,822,000 1,720,370 101,630 2,028,000
(89,609) 89,609 92% n/a (89,609) 89,609
341,495 342,730 (1,235) 92% 92% 372,540 374,230 (1,690)
10,542 1,039 9,503 92% n/a c) 11,500 11,500 75,000
268,367 334,118 (65,751) 92% 114% 292,764 358,618 (65,854) 290,000
74,844 34,630 40,214 92% 42% 81,648 37,830 43,818 60,000
45,441 45,666 (225) 92% 92% 49,572 49,866 (294) 50,000
9,167 3,925 5,242 92% 39% 10,000 5,000 5,000 10,000
91,667 1,239 90,428 92% 1% 100,000 2,000 98,000 100,000
409 (409) 92% n/a d) 409 (409)
26,637 22,965 3,672 92% 79% 29,059 29,059 - 438,141
15,601,354 12,793,400 2,807,954 92% 75% 17,019,659 13,883,153 3,136,506 16,626,141
- 92% 0% 100 100 100
12,242,763 12,242,763 92% 0% 13,355,741 13,355,741 12,965,479
TOTAL REQUIREMENTS 27,944,306 12,888,503 15,055,803 92% 42% 30,484,797 13,987,363 16,497,434 29,721,000
NET (Resources - Requirements) 1,491,324 16,778,615 15,287,291 (0) 16,755,094 16,755,094
* Proposed revisions to FY 2010 original budget
Beginning NWC per Approved Budget _ 16,400,000
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Projection based on annualizing 48 weeks of claims paid. YTD actual is $250,124 per week.
c) In May, County received a $67,945 reimbursement of the State Assessment from Zurich
d) Workplace Clinic Department expenditures.
O
O 0)
N a
i 7
LL m
000(-00r O -I M Oa 1- 0-30 0 ^N 01. (0Na
CO 0 OMI, (0 CO. N'. 0 .N (0 0 0 b' 0 (O.c0 0' 0. .N 01! co 1f) O!
00 r O (0:1M, C) 00CO, (0 M r O) 00. r1LL7 C) O ' I "'V <1. N O)
• (N ' ' O 0) O C) r ' I- (0 CO' 0) N
In r'O' '0 VCV C' N 03 CV r (0 N. 04 a
0.0 0 010 0 o 0 0 0 0) V 0 M 'M 0 0 ' 0 (i 1011(0'�0'r N U N N
000.0, 000' 0.000 (0 0 1�' 1�� O N ,0 00 (0 8..,411;N' (0 (0
0 N 0 0O 0 0'M.O O )f1 F- (0 r 0). O V O r: SIIF- O) 0) 0)
O r N'a0 ''r Lo- (O Nlln 0) V (D LO (0 N (0. I- N 0.x',(0'00.C71 C71
r,(O' V N ',V ISI NO ',(0 C) p�I 1.- co �j Irn N x001`_',0 r r
V O co 0 1 (0 0)' V O 0) 01' c0 0) O CV 0 0' (0 00 ', 0) (0 0'. O O st. _-
C) V' (0 '.. (0 C) r', 0) 0 I, ';O 0M, C)'. 0 O 0) CO C010' 0 0 NI '0)
r 0 ' 'V'M (0 Is- a0'0 0) (D N M ' N CO N'0 C)'r - 0) F- 0 0 0 N C)
(O r C)')- V 0'r. (0 C) 00 1.-',V'' gii V. (0 C) (0 'I�'N'0 O 0')0� N
'a0 '.V 01 C•1 V I� f�'.O CO M'. r 0)'. CV'00 (O,L_D F a
, M ' (D N. 0 N (D r N , (D
v r
V V V f ! , st
('1 N N' CO CD Ca (4
C
O O 0 O'0 0 O 'CD CD.
)OI�I ''I O OII�'' N'0). M'O 'M 'M
'
00(0C)C6 MCD. 'I',M� ' O M
"CO Is: .S.- O! c0'V, ,e N
1, N ('1 rs (0 V ' V ''..
I
v O IMI (O 0 0) 0 O 0
)� ) V. CO ',(0' O• N 0IO COC0 00 0 0'O 0SI C) M''.
M V 1(0(0 M r, rI 0 (0 0). x01x0 n CO co 0'O 00'00'. p CD
(0 I� ' IV ( 0 r' C),0 (0 CO'. V'' 0) ' < a N 0I C) ' V O 0!, 010' O! V
1.-: 1 IM R NI.- r 01. vi r....: c0'MI IN' N'(O'M '(0 (0 )- 00 0 0) N'
(4) V _ :Nr 1s O' M.. IS I V it V: r '00 O 1i),� (D
C7 I N r V
CV 0 ! M C'1 (D 1' M'.
Imo' 0 V'1 0)''.0)' 00' In
V 'I CV. 0 11`I 00'h I(D 01
IS
SII 0)I (0 Cp, ! CD. 0!..
!1� '00 (0 V 0_ ()
0 I�'00 VI r� V 0' 0) 0 0
co V co IN O 011
0) (0'I-' enImo, '0.
(0 I . 0� C) 0 (O C).O N. OI
N ,.,O V �' (00, r.C' N ! N''
t
N 00 0 0 I V 10 'Cr (0 (D 00 1
O '1--1'4.1411'''', IO V V' 00' N..
C ' 10), CO ( 0 OI ' 10: ' ' V'V (0 101.
N (0,-011 (O CO. C.4 .I- (+f CO
C)', V1 N, (0 '', co co CD
N M I• -•'V CD CO
I (0' . M'. � 0)'. V 01'.
c' ' O, Imo 'N'
V 10I •v'.
N'.
c0
U
(C
O 7
Q
0 d
3
0
0 • O 0) .0 •
00.0 CO st
r - ' ',V (0,' N 1 0)
• 0) 0', ' ' (4) N
0
0'
CN
000
r11ce1
� I
L
a-
(0
7
.0
LL
a -
C
1)
.0
E
.0
>
z
'I
f
LO NI 0.
V 0.(00
IO' '1
_
OI l0 ! cil (l)' 0)
V C4 el 4.).)CD ''
N.' 1 10. '
M, 01 IMN' (D' I(0
�.. I V' 0
co
:co O'. 0 N 0 OI. 00, O', N,
C0 00' N,
'n t
l0 I M; C) 0)'O' N. 001 10 '0
<� r p0 ,O)! V 0i 0
1 ' 001 (0 'OI OC) 1v r:
'� �I 1 11 IC) 461 V N''. (D Oi
o V' o v1
,
,0IMI 0) Ico co '' (0(0''1.4.v"::
V (O
I(O „O O) r!� C0) r' �I NI
(0 1 NSI co:I 1...i: ' V 44) 0 M
V' I(DI (O C)', ' 01 ::••-•""
,
0„0) co:
40 (ND
O
O '0 yy
O.O N 0o 0)''., O (0 CD.
O M r I V (0 ' O MI
05 05 W 0 0 (0 (D !
V M1 0'
0 n a
i'11 laj
0. � 0 i ! 0 1 M',
(0 'n(o' 0'',
a
0
( 00 00 c0 0) A
�. ' O' ' �� ' X11 ' V M' O c')'' V 01
1 1 (0, ' 0) , f� N N1 V.'IA co'
, (0I (O •,J. <i
E
0.
(0
(1 '
0'
N!
oo
C)
O
1
N i 'NI 01
(0I
vl.
C) V' 0) N M O I OD N O I O M yf1D
,(0 V '01; 'M c0 0)I0 o pO
Le
(0'0 ' N l
N N V
•
(V' (0'V'', Oi a0 0',W M )f),
'
N' f- 00 tD•0.1
V
OD ((00'Cool O Ivy'
1 0011
N (0 lI O OO.
' • 1r N''. 'O'' I
! ,1c0 I . OI
0) CI
M' (D
I(MD NI
O
r
-o
o� HI
O
CI
)LL LL
F 7' I
a
C LL11m C C q
7 7 C
tZlc IN12�m1a�i VI C) SII
(Dalrn°) ZLLIF-ig
C
Im
fn0 CNE1g7N 1 l0
U, CIN O m:yl� ylg (U.0 y0 C;,
5, O INIP z, 1W:O'
6I:,21E of=ole, z1�1
RESOURCES:
Beg. Net Working Capital
Receipts:
Security & Traffic Reimb
Miscellaneous
Vending Machines
Telephone Fees - Events
Special Events Revenues
Interest
Storage
Camping at F & E
Horse Stall Rental
Concession % - Food
Rights (Signage, etc.)
Donations
Interfund Contract
Total Receipts
Deschutes County - Fair and Expo Center
YTD -Budget Basis
Statement of Financial Operating Data
Eleven Months Ended May 31, 2010
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Year End
Budget
Projection
Varianr:e 1
$ 75,000 $ 42,232 $ (32,768) 100% 56% $ 75,000 $ 42,232 $ (32,768)
12,000
3,680
1,725
900
498,000
1,828
58,000
7,000
18,000
221,000
56,420
45,000
3,659
1,319
740
357,634
87
43,463
7,365
7,635
111,179
115,000
3,300
45,000
(12,000)
(21)
(406)
(160)
(140,366)
(1,741)
(14, 537)
365
(10,365)
(109,821)
58,580
3,300
923,553
696,381
Transfers In
General Fund 148,500 148,440
Transient Room Tax 17,074 17,074
Welcome Center 80,000 80,000
County Fair (619) 197,421 80,000
F & E Reserve (617) 250,000
(227,172)
(61)
(1)
(117,421)
250,000
Total Transfers In 442,995 575,513
TOTAL RESOURCES 1,441,548 1,314,125
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfer to Reserve Fund (617)
Contingency
755,964
487,047
116,188
708,487
433,987
116,188
132,518
92% 0% 12,000 -
92% 91% 4,000 3,979
92% 57% 2,300 1,894
92% 62% 1,200 1,040
92% 66% 540,000 386,134
92% 4% 2,000 196
92% 75% 58,000 43,463
92% 105% 7,000 7,365
92% 17% 45,000 34,635
92% 47% 235,000 125,179
92% 133% 86,420 115,000
92% n/a - 3,300
92% 100% 45,000 45,000
92% 67% 1,037,920 767,185 (270,7:15)
(12,0)0)
(11)
(406)
(160)
(153,866)
(1,804)
(14,5)7)
365
(10,3(;5)
(109,8:1)
28,500
3,300
92% 75%
92% 75%
92% 100%
92% 41% a)
92% n/a c)
(127,423) 92% 82%
47,477
53,060
0
92%
92%
92%
92%
92%
92%
Exp. %
86%
82% b)
100%
0%
0% c)
n/a
197,919
22,765
80,000
197,421
197,919
22,765
80,000
80,000
250,000
(117,421)
250,000
498,105 630,684 132,579
1,611,025 1,440,101 (170,924)
824,769
531,604
116,188
100
16,412
121,952
777,218 47,5`,1
504,301 27,303
116,188 -
100
16,4-2
121,9`'2
TOTAL REQUIREMENTS 1,359,199 1,258,662 100,537 92% 78% 1,611,025 1,397,707 213,318
NET (Resources - Requirements) 82,349 55,463 (26,886) 42,394 42,394
Beginning NWC per Approved Budget
a) Transfer from Annual County Fair fund will be $117,421 less than budgeted.
b) It is likely that M & S will be less than what is currently projected.
c) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund.
Accrued Revenue (Accounts Receivable):
Current Month Events 17,376
Prior Months 31,438
Total Accounts Receivable 48,815
2,809
Deposits Received for Future Events:
2010:
June
FY 2011
July
August
September
October
November
December
January
February
March
April
May
June
FY 2012 & beyond
TOTAL
8,6E 1
43,1!:0
1F.0
3,3f
2,6( 0
4,5: 0
2' 5
1( 0
5( 0
5( 0
1,8( 0
6( 0
3( 0
6,5: 0
73,116
Deschutes County Fair - Fund 619
Revenues and Expenses
FAIR 2010 - July 28 to August 1, 2010
Fiscal Year 2011
REVENUES
Gate Receipts
Carnival
Commercial Exhibitors:
FY 2011
Budget
Actual -
Through May
31, 2010
420,000
160,000
Outside 85,000 34,850
Inside 43,000 32,550
Food 14,000 13,100
Livestock Entry Fees 5,000 -
RN Camping/Horse Stall Rental 18,000 13,310
Concessions: -
Food 174,200
Fair Sponsorship:
Rodeo 20,000 7,350
On -ground Stages 8,000 3,000
Day 5,000 -
Golf Carts 4,500 600
Food Court 3,000 -
Concert 40,000 10,000
Presenting Sponsors 12,000
Building Sponsors 4,000
First Aid Sponsor - 2,500
Parade Sponsors 2,500 -
Transfer In -General Fund 5,000
Transfer In -Reserve Fund 48,000 -
T -Shirts -
Telephone Fees - 140
Donations 338
State Grant 35,000 -
Interest 1,386 (63)
TOTAL REVENUES 1,107,586 117,675
EXPENSES
Personnel 113,902 74,803
Materials and Services 675,154 71,512
Contingency 87,298
TOTAL EXPENSES 876,354 146,315
Net Fair - 2009
Transfer to Fund 618
Retained in Annual Fair Fund
Beg NWC at January 1, 2010
231,232 (28,640)
231,232
(28,640)
5,118
Ending Balance - (23,522)
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service:
Negative Interest Revenue
Deschutes County
Bethlehem Inn (Fund 128)
Eleven Months Ended May 31, 2010
Budget
Year to Date
Actual
Variance FY
$ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% $ (2,666,469) $ (2,689,172) S (22,703)
2,766,469
2,766,469
- (2,766,469) 92% 0% 2,766,469
- (2,766,469) 92% 0% 2,766,469
100,000 (2,689,172) (2,789,172) 92% -2689%
Exp. %
- ,,2,766,469)
- (2,766,469)
100,000 (2,689,172) 2,789,172)
100,000 31,117 68,883 92% 31% a) 100,000 33,500 66,500
TOTAL REQUIREMENTS 100,000
31,117
68,883 92% 31%
NET (Resources - Requirements) - (2,720,288) (2,720,288)
Beginning NWC per Approved Budget
a) May 2010 interest expense - $2,277.40.
b) Recap of expenditures - inception through
Land/Building (Amertitle) - July 2007
Hickman Williams
City of Bend - May 2008
KN EX CO
Kleinfelder
Total expended on facility
Interest on Negative Cash Balance
Total expended
May 31, 2010
$ 2,241,313
17,578
250,000
5,289
3,732
2,517,913
202,376
$ 2,720,288
b)
100,000 33,500 66,500
- (2,722,672) 12,722,672
(2,725,000)
Year End
Budget
Projection
Variance
$ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% $ (2,666,469) $ (2,689,172) S (22,703)
2,766,469
2,766,469
- (2,766,469) 92% 0% 2,766,469
- (2,766,469) 92% 0% 2,766,469
100,000 (2,689,172) (2,789,172) 92% -2689%
Exp. %
- ,,2,766,469)
- (2,766,469)
100,000 (2,689,172) 2,789,172)
100,000 31,117 68,883 92% 31% a) 100,000 33,500 66,500
TOTAL REQUIREMENTS 100,000
31,117
68,883 92% 31%
NET (Resources - Requirements) - (2,720,288) (2,720,288)
Beginning NWC per Approved Budget
a) May 2010 interest expense - $2,277.40.
b) Recap of expenditures - inception through
Land/Building (Amertitle) - July 2007
Hickman Williams
City of Bend - May 2008
KN EX CO
Kleinfelder
Total expended on facility
Interest on Negative Cash Balance
Total expended
May 31, 2010
$ 2,241,313
17,578
250,000
5,289
3,732
2,517,913
202,376
$ 2,720,288
b)
100,000 33,500 66,500
- (2,722,672) 12,722,672
(2,725,000)
O Lc C'J 0 Lf)
O co cc co Lr)
0 Ln I� Ln
N
0
7
>, O
CD 1 1 1 1
0
O
L O O ,L- CO 0)
0N CO CO
' OCO
to —
a) O 0
= 5 M , .co
-a 2 1 i
C
a
x O'N (0'' co
W a) ' N l'..CO7'''IV
a) LL
>
F-- CO ICO
U a c 1 ' 1 O CO
O c
DO TD
i ct
L Z • • cd 0 0
a) m
C
to C N O 0) W
e.
L O Ei Z ' N ' N' 'M
U
a
U) • C
a) a O ,
• * + O Ln L0 co 1 Lc co
U LC)0) r- J ti
a) o M Ln Ln tt
T.C
O W j
0 L a
CO (0 ICO
' ' ' co 1 CO
E
a) to
v) I Ln u')
UQ 1 1 1 N 1 N
C i
n2
W 1 1 1 1 i 1 I 1
O
0
•La
c
a) al
JilL '.
Ccc E ' ) O •L
w N 0 �': c r
458` 0
H:OF-<a;CD
O Lp 0)
Lf) N,N'NI
W M O m
� N
O',Q) I- O N
Ln C) N. CO it)
N M '
LC) O CO W CO
O LC) Ln
I� N 0)
(0
(0
0
� M
N 1 ' N
O
co C7
N
I~
Iti
M
CO
co)
0''0
MIM
LC) 0 00 CO LC)
M''1'LC) Ln
LC) 'O ' O)
N M Lf)
L[) I Y9
1 1 Iti
0 IM
LO LC) (0 ti
Cr) ' I 1 C)
Ln
0I O h
N I� N- 0
N' ' N' ' ICI
T L
CO O Lf) 'Cr
CO
1 1 1 1
O
▪ 1 1
1 1 1 1 1
cc co N I---zr O
Ln N LC) LC) T1 r
CO N r
r L!) tC)
l i 00 • CO
•
•
h 1
0
'1)
I CD
MIM
0
ILOO IN L0 M
M ' CO ' O
e-
a) 0)
•c c
• c
11:3
di
,,
otS w ca
E
cE O H In
a) 2 E a) a .
a
O'(7 1` CO
O ' '(r) '
0
O
N
MI'O CO
• N'L!7 CO
N Lf)
r N•
IN
0
N CO CO
co'-
00)N-. r••••
0) Co N- co
N ' sT
O O 1 (0 M
N'OI-- 0 0)I,
N'
T
r(.1I
1 it 1
co 1-. LC)
N I` i
' ' IO,
1 1
m'':
C
, c,
•
d .c' a)
E E
d'= Cj 7 0
;C)1111 j O', L u)
O ' E a) O
a)'2 E''.
CO c1' -I i -
C
p0,HQ',Q�'C7
c0,
co
0
O II..
0
• 'O
T.. IO
O '.N
1— }
ILL
0
CO•
O
O
IN
}
LL
O
CD
1
a)
ia
CO
10
L.1
U O_
CC O
N
• Q.
U c")
a
7 U
U
N L
N• 0 O)
Q O O
C4 F-
0)
0
0)
0)
0
z
0
U
W
O
d
F—
N p)
0 V
0_ m
O
U N
N (V
O a
0
• w• )
C
0•
• N
E
L E
c U
W co
RESOURCES:
r- M
N-
o) l
O
O N
N
CO
N. M
C7) LL)
N
CO
O
CO
EXPENDITURES:
CO M u) N CO 1— N
CO ' C")' M N ' CO et. N
O CO vu) O O
co
O Ch O 03 N CO O O N
CO LO CIO't CI" CVO Cf)
N
M �t O Cs, N In CO [t
ui 4. CO O CO u) O co'
M U) M co
O
Mu0•) et O OO O
O ' O 0) ' 0 U) ' ' N
COQ 00 O�
O O CO 0
e—
eteMNCDNCOCf) �C7)N
COMC'7tnCOMNOMd-
C'f)Oel- etONCO
0 1� CO L u) O
iM M co
1 1 1 I
M N O N CO M r O N
M O CO M N O M
COO•:f •zrONCO "1:.
N N. CO lL) 1.6co-.- CO r r -
N M CO
CO
co
C7)
(L)
M
In
C7)
co
O
CO
co
C7)
O
CO
C7)
M
LriO
O
CO O O
0) CO O
C• N
M ,t CO
coOO O
M co O
f- N
r- co CO
M d N
elr
O
O
I
M
co
M
CO
O
co
C7)
CO
Q)
C'7
co
M
O
O
C7)
CO
M
M
C7)
O
O
O
co
U a)
N C1
O --... E
0 y 0,
CD 0
0 Z N N C R
CU =
°'m0) C
V >N
0O N V ° 2 O >
co
a O CO
CU o) ....,(-)
L .• air C' Q
w •C O U N • U CO '= E CO
°� U N co CT 'O U N y o 2 • O• c U O U
0) O C C co 0: 0) 0,_ CO O U 'y CO
c. L m 'y c 't L5 rn N w. O p in 3 N C p
0` C O Cq N N> C= L L D O I-
0.
_co
W tiri c cu_<0-D0 UZO
Total Expenditures
m
z
0
Ln �
v1_
Z
c cw
.r
U 2
as
00
d 0
7
U Q
U 15 Zw
0
CB Cfl
c
U
m w
O
O_
O
M
m
2
O
cn
Amount Paid
c
O
0.
U
N
a)
0
O O
LC)
N O
N
LC)
0) 0
O M
M
CD
CD
N
a) N
U
` O
� O
c a-
0
0 X
w
m_o
E
CC
O
O
N
CO
LO
0)
LY)
LC)
N
LO 0)
O
CO
r r
LC) 00)) 00)) .r- oo-0 -N 0OLC)M0)4c)r-c%)N
CO 0) CO I� O M O I� O LO O LO O t LC) r
CO NN44 LC)COI-00000C7Nco' co -
CO N N M CO r N N "-
CD O
0
O
LC)
N
di
O
CO
CO
0
N
O_
co_
c
CB
d
O
0O
0
c
Powers of Automation
Tomco Electric
0
CO �0. Oo
Com.) Lc)
LC) ^
N
ai LC)
LC) ER _ p O M U
I cd O CO \'o ML
.- ( cp (0 0 >
0 N co od
0
ERoo 0 0 �rs�ira))a�'i°3
co O � O N O O 6R O (0 U 0) o 0
R.r c:,
O CO 4- C0 C CO
r� i r 4 00"-' p LOCO.c_
a) O CO "" O E ' - � � c , � Cr° � U cn
csi O N•`) E't6 coco coM co 49 - aO)
o 4 E 2 J 7 U r° (Ni to C� O c CU C • C
Cfl 6R a) y 2e N 5, r\ ca O (n O E N U
ER O to c c L m 0 CO ,F N, N 0 U a) U 7
'Lf) o w �� co O O C 4 O
o 'Zip > O O V 1 c o c - O a N O
c0 -..= cn 0 O U U a) u)
L
N N C7 as
p) U N c O) C) O L C N O)
65;t:1,_,. a.)
),( L`o co U O a) t U w O C w m
w. c 7 7 L,_ O 2 L U 7 c O a) L
o ° 1 u) a) cU 0 mg �E ��Y HU
UO c°) w -Ft'
''= =0 duyi°
�, fn O
73 � � U U U +.. N
cocr N M¢ LC) ti O r N C LC) I- co 0)
Engineered Structures Inc
0) co
co
Or --
L.6
M
O O
0) O
f- O
0) N
O O
r
M LC)O
c1)
O O 00)
N cd
O
M M 0)
a)
0
0
a)
0)
m
L
U
O
H
Total Engineered Structures, Inc.
Total Encumbrances & Commitments
PROJECTION
CO
O
CO
0
(0
a) 0
a�
oO
cd
U c C)
a)
u)
'a
m
'a 2
U d p)
N -
Q c O
_
(O H
a)
U
a)
O
d
To
a
U
0)
Encumbrances
& Commitments
Received and
a)
a)
0.
X
W
RESOURCES:
CO (0
I� N
M I�
CD
N
N
0
N
CO.
CO a- 0) N
I� (0 M O
1- CO N
M N CO co
Ln co N CO
N CO ch
CO. N
O CO 0) O
O N M O
O Cr CO O
O 0) oO Ln
0) N CO
N CO Cr
M
N-
CO 0) N_
0)
In N.co
CO
N CO.
M
co
ti
N
co
N
(.0
N
(0
CO 0) N 1-
r- M N
I� ' O) CO O
M a0 c6 O)
In N- CO O)
N CO Of
c, v
r- N- OO) CO(0CO CO 1.0 N
' a- ' v(0 0 ' ch C.
N 4
O co O N COO) O Ln N O O
O O) I,- O CO O) CO O CO CO O O
O a- 0 CO (0 0 0 Cr N- 0 0
c N O N N. a-
N Cn N O)
O CO
O
(0 Ln
N
O f`
O o
N O
N
O O
' O O
O O
' ' O O
O '- '- O
r -
N I-- O M co O) co Ln N O
CO f` I- 0 CA CO CO 00 CO N
CO O) any O) M_ CO0 LC)
r V Q) N_ C- V
I- 0)
N
CD
O
cc;
N I. O M(0 a)OLnN 0
o O- CT a- O CO co co o CONCO
co N
In I-: 0) N CO a- 0)
N
CD
CD
O)
O
CO
CO
N
0
N
Ln
CO
CO
N
O
(0
CA
N
U to
a) a)
U O = s
c a) x 1,.)
U U � d p o O
.h. U z a) m co
4O
C 0) 07 N U Ti; av al
N 7 ° .y Cn a) > c U
C LL N !A a) a) m oes = 2 O t0
y d w a 0 wa u_ r.
a) 0 rn 3 m °c) m U E o c°_)) D as
`- o i- co ='C(n p)v cO) C z.eE_2
o C9 m G m ao) 0) c C C d (n v) 'Q O
d cO 0 Z .0 C c c 3 (n t C Is ,.. ,.. r
`) y N W L cLi .5) 'V) c a)= aa)) > c 0 L c O
O 0 C L- co d 4? c C a) U) a) -O 'C a) w. .- H
o ate) (L'° 2 o x mQwHdS 0LLQ0_w02
mLLHSit WZ
MOco 0 O
0
CO Cr O
I� t` CD
O) O CO
N N
- 0 0 0 0 0
- 0 0 0 0 0
a)OOOO
c0 1.- (0 O (0
N O M M N
N N N co_
N
I,- O O O
N.
L() ' O O O
L() CD Ln
0) CO N Cr
N co
co-
0)
Q)
0)
N
N
0
Ln
N
(0
CO
CO
CO
0)
0)
CO
Ln
N
(0
CO
N
LO
0)
co
C0
Ln
r -
Ln
O
O
Ln
Ln
N
CO.CO
0)
N
M
0
CO
O
Ln
N
tV
N
+)0 co
In CO ,D Il)
OI (0 N 1�
M a
CO M O * tOA
N V N
N
c
a)
w E c
CO y > 3
C E3=a0
U ; ( x E �a
o ii
w c a) a °.5 D)) ((
lik
3 c (=. E 4-) m o oo 3
0ua)a)awc�o
N C 04
z O j 5 H
ccti- O111-
U
1 otai txpencItures
m
Z
O
't O
>' c r
CLL
3 N
o
O
U
r) Cr)
OG
U d t
N . O
Q a o
UL
rn
PROJECTION
r
O
U Q)
a) iB
o
a`
Encumbrances
& Commitments
RESOURCES:
CO O 0
N.
N. O O
CM
tri
N 0 CO
M
O N 0
0 CO 0
O N O
N-
CV O
CO 0
C6 Cr;
U) O
N
M
coo o
Ns'
C) CO -
1.1") CO
Cn
y
0
0
a)
0
C
(a
O
CC)
y
O
G)
C
<
c
a) al
m
0 (-9
0 te°�
a)
coLi-c
O
ti
CO
O)
M
co
CO
CO
O
M
M
Total Resources
EXPENDITURES:
)-N. U) O 0) N N
coCO CO CO
O '
N
O CO Is O N CO O O O N O
O 0) Is O O 0) CO O CO O CO
O tt O CO CO O O I I- O
1� CV O N N ct
N O N Q)
00)) 0CO CO N. 00
0 0
I� r N O O
co In N O
N
O
O
'
CO N CO CO) 0 0 CO LO N O
CO N- 0 0) O O CO CO CV
CO. O 0) CO CO O D d O
I- O N N •of
N
I� O M co O) CO O N CO
O 0 0 CO CO CO CO N
CA
0)M000) N-CO
CO ti O N r ct
N
CO
CO
CA
CO
CO
N
LO
O
CO
co
N
Q)
CO
O_
cc
coCO CD cp rs O N coco
I` N O r
N N 0) CO CMC
- 0 0 - ONE C
CA cr O CO CC O
C70) O M 0N) M
N N '- O 0 CC
N N
ti
ti
O
Q)
O
M
O
tri
N
O
r --
La O
Q)
O
CO
ti
CO
O)
M
O O �
Yl. CJ) N.
co M
Cp r
O O O N
.1— . N
CA
0
co a) U
U.-. E
y O O V) c) 0
U - o c
co co a) •- y > H C N
- N co 0) ots 7 2 raa O E �
0 U ea to d w' .` U > r
O'� 0 7 O O Q.
C a) 0 E 0) c0) R•m N O Q CO
0
c E `t) '
` t -� n C a) O al 0 C= L 0 6 y y O
O UwCpc0_ 1— "va) c l—
as Q�a cu<0_00 z00
Total Expenditures
m
z
a)
U
C a)
RS 7
To m°
Amount Paid
C
C
E
E
O
0
U
0
r �
O) (N
Ui
O Ln Lo
CO Lf) c )
cci O cei
co
N N
CO O CO 0
0'- 0
O O O) 0
N I- O O
LC) - Co L0
N N
U U
a) X
U a)
O
OO
co
c a
O X
W
E
co co
0 0
U U
O a)
L L
U U
Q Q
Q Q
00
Total Architect
Interior modular walls
Herman Miller
0 CO
LO O)
Co d•
N CD
co Co Lo O n- Co O- 0 1- 0 0 0 N 0 0 co
L0 O) Co Co co Co O) - co Co O) I'- r.- N 0 O) co
CO 4 O) c) co 4 Oma) O Lo co.. co In '- c O N
r--- O
N Cfl a
1 s 4 6- 4.- O 4 n
117 -co .- .- 4
.-
co
N
c) C)
co co 4Lo
o _
1.0 co co c
N O Ln Ln
Vi
EA Lo O _ N
69
O co O , cocd oON
O
o O o 4 coo
co co 0 N w O o
C 69 c) •-0N ,_ 00
to 6y 0 to u '45 O
O O c 0 0 0 45 O\ v�
N o a) o O U o co
4 E N co c • ` 0 to f`0
O _ C7 O .M.� cp. , L(i M M o� �O p) a)
E O 0p E 7 Co O O N 69 v' C` C E
= coCL 0 6(0 O t�A O o 0 00 co O 3 U U
`p o >,0 1 j O No C3) (1) .2 -au
N p c u) ... 0.j N o 3 C ... H a)
ib -
69 0 ]+ (� 69 C C o CO C) N O co �-
co
O "•_ CO jT. C0.5LO pg aV 3 U c0
p -E -8 1coU mEm >- EU ,E
O ,
To "CI
v ���U�Q•C cnc�Q��O��f
y a 0%-04coL0COCO0
7 •� L**** CO ** *S: It It 1* 4t 4t 4t
CI_ O U
Powers of Automation
Tomco Electric
Engineered Structures Inc
c)
Cfl
CD
CD
Ln
Total Change Orders
Cfl
Ln
Lo
co
Total Engineered Structures, Inc.
rn
Lo
c)
CO
Lo
Cfl
N
Ln
c)
O)
Cfl
CD
Cfl
co
Lo
N
Total Encumbrances & Commitments
PROJECTION
La-)
a)
U
a)
O
U
a)
Q_' O_
a) O
C j N
L
a-
(-) ()cal cUn
a)
N
j 2
c .w
= rn
cn •c3
0 ( o
C 1—
a)
E
(0
EL'
1—
`)
U
0)
a)
U
(0
co
N
LL
.) 15
CI)
O D
0_ 7
m
0
U
m c
0
0_
co
a)
>
0)
U
0)
a)
C
0)
a
X
W
RESOURCES:
M M O
' r 0
0) O N
00
(N..
O M 0 0
CO 0 (.1 0 0
CO O a- O O
M O N (V O
NLO N
O O O O
O O O O
O O O O
M O N O
In In r
Lc) N-
x—
(o .
h O M O co
CO O M O CO
OOO - 0 0
MON N N.
CO LO
h
�
co
N
O
O
O
4
O
N
O
O
O
(l9
N
(00
O
1)
O
N
00
CO 0 0 CO N
N0 000C
LO O ' O 0 ([f
N O N h: {G
N N•
N
Total Resources
EXPENDITURES:
Materials & Services
CO (CO 0 a-
LO d' 0
O 0) • 00
^O d'
000 0
CO
N N N
0) 00
O O)
CO 0 O) C) N 0 0 0)
M CO 0 CO 0) a- 0) O N O)
In 0 h (.1 O CO 0) O O a-
00
h (O 00 In co- co- N N Lf)
N N x— Cr)
x-
000 (MO0)0 O O)
O O O ' M N OO'
h O) N ([) O (D
h � M
N
0 0 O) N 0) In N O)
CO CO 0 a- CO N CO 0) CO N 0)
LO O h M 00 in 0) O
N 00 co 00 0) 0) N
00 N (3)
([)�LC) 0)N0)L()szi-N(3)�
N CO 0 1- CO N CO 0) M N 0)
L (.1 M 00 U) 0) '— O
O N N 00 LO 0) o N In
O
N
(O
00
O
O
O
00
M
L
x—
(0
[) 0
N 0
O O
LC) v
0
0 0
0 0
O O
LC) a-
x-
0
LON
O
00
O
N
0
41
(NI
O
O
O
O
O
O
N
O
00
O
N
1� co co
r r r
00 O) 0)
O) O)
0)
N co � LC)
r r
co 41
00) 00)
N
00
0)
M
N
co
cu
cn 0) U
U
co
O i)
Z r
ce N 0 0ea
N _ O 7 l0
0 (o 0- cn 'L
E rn m +. 2 2
wC C C Q. O.N U'
C O 'E 7 C r 'C .�+
L •C .> C 't N :r O) U> 0
0) (0
<ww�O.. u.a.QW H~
To be determined
1
Total Capital Outlay
O
O
O
M
0)
U
a)
O
O.
O
a)
(0
co >
M
N
(O
in a)
U
a) O
0 0_
N
U
-o
O C
LI -
a7
� N
U o
a) 2
C N
CO N
N
N
-(0 j
o O
U
O
O
N cis
M'5
— O
a
0) o
o
9 3
o 0)
a)U
O C
(0
> t=
.y
Q- o
0) U
U O
C U
f0 O
7
tnCf)
r M
o N Cn
0 6R N
O N t
C
w 0 N.
to U O
.`n'
N(O
v) c N
!IC
0)0!0
`O Q
ao(O
c 0) N
m 0
CO
0)
LC )
0
N Z
UW
> I—
o
U g
a)O
cn U
N 0
7Z
L Q
a)Ci)
W
U
Z
g
Um
asD
c U
OZ
E
i0
a)
1-
a)
U
a)
C/)
0
CB
0)
7
O
Amount Paid
C
a)
E
E
E
O Q
0
C
O
0.
U
V)
a)
0
0 CO
N N
1-• 0)
M
O N.
CO N.
O
tri CO CO'
0 0
0 O
O N.
CO
cc
CO
0
O
O
' N Cf) O
0 0 0
1�0
M M O
N
O CO In
CO CO N
M N N
N
LCA CCOO 0 0 O CO a) CO
M l[) 0 0 In 0) 0)
M l[) CO O r N
N a) N
ui
Ca
N
Y
U TsC
a)
a) a) 3 c
O C N U - _
a) C U
N I al 3 -D N
a) C 0)Q
O U C 7
U V N O CT
ZX .Z o -E a)
a) a) 4l O U w, U
cA a) v E U c Co ti= u)
N-79 C7I C7) Q c U 7'6 O
c C_ cn O cn O c
o ` •C fl C w U C .0 E CO
L C cn .0 cn a) C'`o C U
_ _>.
L E C7) C a) O C C as L
Qx W J(i)Q UILD UD
0.
=
D `) Q `) O`
7 = = = 0 CV
L LL L .0 c12
I_ N O O
Q Q Q Q i- = a) a)
a) a) a) a) C 7 p) p)
as ccBCO
as O y co CO
C C C C- O L L
Ca cA U U
as EL" ET_ 0Q i
Change Order #3
1
Total HSW Builders
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As ofMay 31,2010
"Area A"
"Cell 5"
Landfill
Closure Fund
611
SW Capital
Projects Fund
613
Total
Engineering Contract
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a)
Total
Paid through May 31, 2010
Balance
Construction Contract
M A DeAtley Construction Inc
Original Contract
Change Orders:
Change Order #1
Change Order #2
Change Order #3
Total
Paid through May 31, 2010
Balance
241, 869.00
19,656.00
261,525.00
206,667.27
54, 857.73
182, 516.00
182, 516.00
127,658.27
54,857.73
424,385.00
19,656.00
444,041.00
334,325.54
109, 715.46
2,097,140.50 3,290,779.98 5,387,920.48
2,097,140.50
640,609.39
1,456, 531.11
Total of Engineering & Construction Contracts
Original Contracts
Change Orders
Total
Paid through May 31, 2010
Balance
2,339,009.50
19,656.00
2,358,665.50
847,276.66
1,511,388.84
45,094.00
14,302.54
24,885.69
3,375,062.21
552,768.10
2,822,294.11
3,473,295.98
84,282.23
3,557,578.21
680,426.37
2,877,151.84
45,094.00
14,302.54
24,885.69
5,472,202.71
1,193, 377.49
4,278,825.22
5,812,305.48
103,938.23
5,916,243.71
1,527,703.03
4,388,540.68
Notes:
a) Additional landfill gas investigation per DEQ as part of a requirement
to address offsite landfill gas migration.
b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678
has been expended and reported as "Construction in Progress" on the County's
CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction,
Taylor NW, KN EX Co, Jack Robinson & Sons.
c) To date in FY 2010, payment has been made to Central Electric Co-op:
$13,311 for the Closure of Area A and $20,822 for Cell 5.