2009-1531-Minutes for Meeting November 02,2009 Recorded 11/25/2009DESCHUTES COUNTY OFFICIAL RECORDS CJ 7449'1531
NANCY BLANKENSHIP, COUNTY CLERK
COMMISSIONERS' JOURNAL 11/25/2009 08;25;15 AM
I I III IIIII~IIIII III II III
-3 3
Do not remove this page from original document.
Deschutes County Clerk
Certificate Page
If this instrument is being re-recorded, please complete the following
statement, in accordance with ORS 205.244:
Re-recorded to correct [give reason]
previously recorded in Book
or as Fee Number
and Page
4
Deschutes County Board of Commissioners
1300 NW Wall St., Suite 200, Bend, OR 97701-1960
(541) 388-6570 - Fax (541) 385-3202 - www.deschutes.ora
MINUTES OF WORK SESSION
DESCHUTES COUNTY BOARD OF COMMISSIONERS
MONDAY, NOVEMBER 2, 2009
Present were Commissioners Tammy Baney, Dennis R. Luke and Alan Unger.
Also present were Dave Kanner, County Administrator; Erik Kropp, Deputy
County Administrator; Marty Wynne, Finance; and Hillary Borrud of The Bulletin.
No other citizens were present.
Chair Baney opened the meeting at 2:15 p.m.
1. Monthly Finance Update.
Marty Wynne share some information from Moody's Investors Services, listing
stress points for local government ratings. He pointed out the four factors that I
are used to determine the strength of an agency. Deschutes County is still rated
as AAA-3, one of the best in the state.
The LGIP numbers dropped again, down to .070. The average yield percentage
was 1.5%, with the prior month 1.82%; but the budget instructions recommended
the departments use 1.2%. He does not feel that it will drop that low.
In the general fund, tax collections are significantly higher than in recent years,
but unfortunately, the numbers relate directly to foreclosures, at which time
taxes are paid. The Commissioners wondered how many taxes are in arrears.
Mr. Wynne said it is difficult to know how many homes are currently involved
the foreclosure process, which may not directly relate to unpaid taxes.
Some departments continue to lose revenue, especially Community
Development. The Fair & Expo Center will experience a shortfall in the
Annual Fair fund, but some of this loss might be caught up during the year.
The Oregon State Police/911 building project numbers have come in under
budget thus far, but the project is not completed yet.
Due to time constraints, the Commissioners will review the finance report
separately.
Minutes of Board of Commissioners' Work Session Monday, November 2, 2009
Page 1 of 3 Pages
2. Board Approval of Deschutes County Equal Employment Opportunity
Plan.
Erik Kropp explained that since the County gets grants from the federal
government for amounts over $25,000, an official plan is required. Part of this
is putting job categories in certain groups so that they can be compared to that
of other entities and private employers. Commissioner Luke feels that there
should not be lists, that everyone should be lumped together without any
delineation.
Mr. Kropp said the County is underrepresented in a few areas, mostly women
technicians. A two-year plan has been adopted, and Chair Baney thinks that
there is even less diversity now than there was a few years ago.
Mr. Kropp said that the areas that can be improved upon are applications and
advertisements. The County generally hires the best person for the position.
Under objectives, some are not only being continued but are also being
enhanced.
They are to pick the top eight candidates to interview, and more if needed.
Commissioner Unger stated that the criteria is there and will help the County
stay on track.
A change was identified, as the first objective, an increase in job categories.
UNGER: Move acceptance as amended, subject to legal review.
LUKE: Second.
VOTE: LUKE: Yes.
UNGER: Yes.
BANEY: Chair votes yes.
3. Update of Commissioners' Meetings and Schedules.
There will be a meeting with the Jefferson County Commissioners and ODOT
on November 12 at 8:30 a.m., at the Fairgrounds location. There will be
fourteen questions to be addressed, taking approximately an hour.
Minutes of Board of Commissioners' Work Session Monday, November 2, 2009
Page 2 of 3 Pages
4. Other Items.
Executive Session, under ORS 192.660(2)(h), pending or threatened litigation.
The Board went into executive session at 2:55 p. m., ending at 3:25 p. m.
The Board addressed a lease agreement, Document No. 2009-638, with the
Federal Bureau of Investigation, who has offices within the Sheriff's Office.
LUKE: Move approval of this agreement.
UNGER: Second.
VOTE: LUKE: Yes.
LINGER: Yes.
BANEY: Chair votes yes.
Being no further items addressed, the meeting adjourned at 3:30 p.m.
DATED this 2"d Day of November 2009 for the Deschutes County Board
of Commissioners.
ATTEST:
6wtc;--42%-~
Recording Secretary
Tammy Baney, Chair
Dennis R. Luke, Vice Chair
Alan Unger, Commissioner
Minutes of Board of Commissioners' Work Session
Page 3 of 3 Pages
Monday, November 2, 2009
Deschutes County Board of Commissioners
1300 NW Wall St., Suite 200, Bend, OR 97701-1960
(541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org
WORK SESSION AGENDA
DESCHUTES COUNTY BOARD OF COMMISSIONERS
2:15 P.M., MONDAY, NOVEMBER 2, 2009
NOTE LATER TIME!
1. Monthly Finance Update - Marty Wynne
2. Board Approval of Deschutes County Equal Opportunity Plan - Erik Kropp
3. Update of Commissioners' Meetings and Schedules
4. Other Items
5. Executive Session, under ORS 192.660(2)(h), pending or threatened litigation
PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real
property negotiations; ORS 192.660(2) (h), pending or threatened litigation; or ORS 192.660(2) (b), personnel issues
Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at
1300 NW Wall St., Bend, unless otherwise indicated.
Ifyou have questions regarding a meeting, please call 388-6572.
Deschutes County meeting locations are wheelchair accessible.
Deschutes County provides reasonable accommodations for persons with disabilities.
For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY.
Please call (541) 388-6571 regarding alternative formats or for further information.
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
November 2, 2009
(1) Monthly Investment Report
(2) September 2009 Financials
P-
P-
CD
N
~
Cl
N
v
V
O
O
C
N
r
C
~
y
c»
rss
d
~
N
O
IV C)
It
>
LL
t '
It N
C
O
O
a)[,-
P
Q.
P
P
P
1
O
O Q
O
l
E
V
Cli
C
O O
U
C
r r
N C
es3 6,%
)
E Z
LL
O
C > N
C
E
3
C O
O
m
V
E o
T
N C
m
y
d Qj d
w
C
U E
C
d
-
N
E
J
N
;
.
d
~
C
~p N
H
c
a~
C7
'
o o °
o ° 11
°
0
O
O N P O P O 0
0
N
O P O O j
O
O
P
M
'CID
Ch (C'
N O co
M
M
f~ N O M
M
-
O 0) CV)
L
;
_
N
P
6-~ 169
@;
N
~
~ C
d ti y y O~
M
C
(D
~
Z
E
>
U
~ to m
m
'U Co Q Q H
U)
d
m
~
C
L'
N ~C d
E O_ N
!6
O O E . N c6 U~
O
UUF=DtiCOJ
t-
C♦I LO
C O
21
za
C
V
o o ~ o o
O O
0
CD
P P
Ln in 1n O O
f~ N N N P
y
E
~
v
7
w ca 'n m
CL
N
N
N
N d
d
C
p
c~i w c6 Z
cc
C
::c Q `
CD
~
U
E
Q_
d
»
N
i
t
-i
1
m C) C)
N
V1
N U)
N C o
~
Q
N N
Q
N
C
~ c~ o
N
E w. ~
'r
N
U
C
m
O
~ y
r
,
O c
ycv
W
O & O
>
0 Z
O
CL
R
H
F-
0
c
a o
J
1
V, UiU'U!CTU U U U U,U U U_ U U U U U U U U U_iU_IU'_U _U o C) a 0) N N'U rnl -eI~O'°
K O Z Z Z I Z I Z Z Z Z Z Z! Z Z Z Z' Z Z Z Z Z Z' Z Z Z Z Z o 0 o I Z N O N O O O
orao°fo°'
a r, N. VIO r~~µ W~lo V.M r V'N O O O CD O O 10 O O V;O O O t'01r O h N O Tp ! N.o,l WO
(O N M V V O fD to, O V CO O M N O 10 0 M O r O O O) O O O r O O w w O
V~ m 61 V O' c0 CO col O M CO W co O r, a N r O; c0 0 CO co O O O r (D O m V m V O,
e U) O C O(O COm' l0 O C) V N N 0 r r O LO V co O O m M to 00 0 r O' 0 0 0 r m O LO N CD M M V O
N' d •C N ( lO. NI 00 N Co M r O r Cl
co V. m o P -L N Cl V O O O r r O M V C N! co
CO V (0 O
7 E 7 It M N 0)N LO O LO M O O O V N 00 a )l M r Cl) Cr) 0 0 0 m Co 00 o V O Ln O Co M V N
o O O O m V m M, O N m O (O N. O CD V O M' O cM M V LO Oj r 00.00 rI O (O o v O M N o r, M M
m N CC) N O r C r- O o O 0 0 0 0 0 Oc 0 0 C V o M' r N O MM
;NI NIN N 04 NVN V~ NNN~N'. N' NNNNNN MMI('M O c) (Ml MI rO
LO V r C41 LO r
I
I Co ('M O, O O I o' O V
' M I.- O W V O O O OO, O oI r ' to O~ O ) O O' CO' O cO O
+ 00 aa m I
d OO' m U-) M N 0 0 0 O o m m O U? N O 01 Cl! o, O O
' I ~ Cl (O, N O o 0 oI t0 o
' N W M O O
O O' m. 00 O; 01 C) O' O' N M O to OI n O O'. O'. O O O O ID o o' C) O O 0) O V V O O 1]
V m 7 N t0 N (O aD 00 1~ o N LO W N h (O 00' CO (O (O o N (O O) (O O N N' (O CO i V N 00 O
> N m ~ r r
' ' c V V C to O' -I, C N! O r P 'l r N M O' O- - - o 1 00. V N V LL
r:- V' V N N c0j c0 toI Co. M' N V. Co 0) C) W' A O O M w N m CD O m O C0 C C01
Y • 01 0 O O : N- Ol fem. to N N, m c`7 N O O (O 00 N O O o ' o o' M I pp I V M N
0 0 0 0 C 0 0 C O O - 0 0 0 0 C C o o 0 0 C) V
0 M O A I L
m N N N! N N•
1 V
N V N V N N N~ N N. N N N N N N M! M to )
ii
p L -
CO zr
+ I 7 O 7.,c=,,'a O' O O M O. O O O O O O. O c0 O' O j 0 O O O O O O o 00' 01 M O 00
w V'O', O, O'O 0100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OO O 0.0,01 101c0 M P N
O m! o, 0 0 0 0 0 0 OI M O' 0 0. 0 0 o O O N 01 (0 (A O o 0 0 0I 0 o r O! P- V 1 m >
V O O O W W 00' V O V O O O O O O m' O W O co o N O O' 0 0, 0 O: U7 O, N N r 0
O O O O N W N CO O' 11Z O', O O. O O O O O V M. m O W O O O o l o O; V O r V N M V U.
m 00 O O O 0 to CO m 0 0 o O O V o ml o, ml r 00' 0 0 0 0 0 0 MI O LO V 10 O,
C tO OAO' O V V M V O' N o' O O N m O N, 0 O Co V r O O O o' of 0. O V OI M V m r, L -
'O) C- O O O O O O O O O O' 0 0 0 0 0 0 O c i 0 O' O: O M V a0 to. 3 y
NI Ni N, N,N V'. N. V.N V N NNI~ N'N N NI N'N N 04, -.MA c) pI U
O N _ 1 c MU)
+ .5 0 CC,
IR OR C)11
1 0, a ; • °fQ
°
0 0 0 0 o M o 0 0 o 0000000 w °~o. coo,o~oto (~°ly ~U~m
oo+o0w0'000
Y Lo O to CO 0 0 0 00 o m CO O, Q V 00 N V O N tO O to M U) O o O IT o I m, COI O o) N CA Q O>
N '7 to uo CO, to r O CO: CO V (O o to 00 m O v N o o r N r O O O O r
N C
N . Q) r
- O' + N N N M
co M M N M'N NN NN M M M N. N N N O N . E a OIF ~ Y a
^
m E
'UU~:3 LLmJI-
' 0
L 2
eoo!o o~~`oo m o o
C oI o o O'' o, CO o to to. 0 0 o Ol o 0 ' 0 0 I
to otnoLO r Cnrro0 too,oo00
N O: r N N M N' M M r to r q O OI M r'' C
V m, LO M' V V' M; r M V' V r r C4 04 C4: U) N
7F) to 'm
c CL
4, .5 o
co
t- C S O j~ CO 100 to to o) V N r 'o -q- r N co co o o r CO (o o V m (o' m o I 0 0, p r O C' j
m V (O CO N m
' (O V' M cO c0 V V V M V lO CO a m N O f_ V CO M M (h 004 CO M I d
1 Q O G Vito M M r O N I A r.'- M M t0 to t0 t- - CO V M LO V to t- to to CO I tl- t_ t~ tom' t0 (o E C A
mIm m,mm o oo oIo o-o 0 0 0+0 0 0 0 0 0'0-t+_ d~>O
l.°~. r m to O Lo r W I t(y Lo t~ N N co f~ m O^ O d' t~ m N N m:
v N 0 0 O O N N N O 2101
O M O O O N N d R
O N N N CM Z--) V 4 n n t` W W m m 0 0 0 r- N N M M V (O 9 a L,1 ~
to C) O C) C) o O o 0 0 0 o O 0 0 0.0 0lo o O o Q O O Oj
'ol(ocolcorn-commwm'm'mmmMmm,mmm0)COmm+m mm mm m0)
-
OI Oi ol0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
t' to W. 'D f: M VIm N t- D (D 00 r to O V ~.ID tD O m O m N V OD.0)
R ® o 0 0 r'I •-I O C40 ' O O N \ O O..- 0 0. \
O to' N N N: N V d' M V ~V CO N to, 0) V (D O r CO' CfO r r N C M M m CO
0. O' O I ~ ~I o' O 0 O, 0 0 0 0 0 o o o 010 C) O O O O O O OI O O' I Q ,I U'~ LL M M m'Z > N d LL Q d z Q p
co m'U 2 J a R' U) U)>_>~mUULLFF
I adRl. V,O;O O L¢ < Z'Z_O O O'O'O O O+O+Q O'Q Q'Z'Q Q,O'O Q~Q'Q Q z Q!'.
U U F F F: F F F F F LL F U- LL U LL LL F F LL LL LL LL U LL
- - -±~-1_+ - +
~ -i + + t_
6 LL' > m
co d ' Q LL' M S U Q Q LL U co Q co, LL LL Z LL m m a.: LL + z Q{ Z Z Z'
+ ue _ (j) co CL U) U) w
41 .O M JL M m ~ + Ui m + m co 5 co i+J m + a {~t lnt Of { 7 U 10. MGM co m tO y i...~..+ -+-1 + + + + + +
'gI ~ O a- I co Z:~ (NO m 3: Ln QQ -1 (n
QI F MQ F"' SIU (oY m' U'a> (nII
r. U' Z. CD N 2'i F y U' F Ia0~2,Q QI(g c0
. i z r X' X m X X X N X LL 00 00 C4
Q N. M. m m N co M' M CO M r ! co (p m m i CO 00'
i~ V I M M co 0 co M N A" 2 M i- 'N I
7 r M M! m.. W U) co M M M M ch m M co M Cl) M y
U 0;
w7 cL-
I 010 O I ~ O I I I ~ 4di O:
A OI Z'U U UI 0 U ! °u! c s - m. c o'
U,7 C .f0.'0 y y
EL U. IU', O U CU Q
U w~,~ n' O Y. yl~m yUm m
4) 00
v Y O o, CO U C) ,0, U CCU O m m U m'Y > m o CCLU CD
Z o '?Ic
W V c O U Z E m U. L~'O m Z, U m1 ZI E 00) Q fO m._ o
D m' U', U U N N' U m U' U' Q m o m, 'Z Co m Q 0) m
ICIY, Em 1 m IY 0-~LLL TI'OO 7' LL NU mU'.N
a+ co
- A,Y C IU CIU'YI N U' C LL U , Y Y E N L m c y N E O
N I l i C I `I N C n
m' 01 d N C NI N co N O f c Y cL 4) a)'F
o EE_ E A I c'c-Ea~~U;D0 cE
d Im, t7a' o' m V m -
al=.' m L I~ mI 'W Wi m m o o a; n,opm o,m Em co o o E to
it 4) m,mi m' cp g' ~ +'!QIQ m co Q 0 m c I co mU=0 wyU)D? m' U ULihD
co o m 0 0 0 0 o z I-
a) njm m w1 0 c c1 c g c' a~i~'' c~ml E,m' m a. EI~< cg t+ W
> •(a 0:a1E'==I°>' o o Lo LolL41E,m n1 m1=10== a) =iE'oImZ'ZZ,°)I='1 w Cc
w fnl J Z'LL LL >'F U m'm mid ca :0 m'LLI='LL U- LL LL 7'0'LL u- LL u- CD, LLI J m
Memorandum
Date: October 26, 2009
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find September 2009 financial reports for the following funds: General
(001), Community Justice - Juvenile (230), Sheriffs (255, 701, 702), Public Health
(259), Behavioral Health (275), Community Development (295), Road (325),
Community Justice - Adult (355), Commission on Children & Families (370-399),
Solid Waste (610), Insurance Fund (670), 9-1-1 (705) and Health Benefits Trust
(675).
The projected information has been reviewed and updated, where appropriate, by the
respective departments.
Cc: All Department Heads
GENERAL FUND
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
$
Budget
Actual
Variance
FY %
Coll. %
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
4,955,712
533,313
(4,422,399)
25%
3%
a)
19,822,847
19,822,847
-
Gen. Rev. - excl. Taxes
730,366
1,465,400
735,034
25%
50%
b)
2,921,462
2,921,462
-
Assessor
205,176
202,128
(3,048)
25%
25%
c)
820,704
820,704
-
County Clerk
260,793
370,452
109,659
25%
36%
d)
1,043,171
1,043,171
-
BOPTA
3,448
3,906
458
25%
28%
c)
13,791
13,791
-
District Attorney
83,200
87,424
4,224
25%
26%
332,800
332,800
-
Finance/Tax
46,762
56,506
9,744
25%
30%
c)
187,049
187,049
-
Veterans
17,548
-
(17,548)
25%
0%
70,192
70,192
-
Property Management
21,613
21,612
(1)
25%
25%
86,450
86,450
-
Grant Projects
500
501
1
25%
25%
2,000
2,000
-
Total Revenues
6,325,118
2,741,242
(3,583,876)
25%
11%
25,300,466
25,300,466
-
TOTAL RESOURCES
12,375,118
9,517,237
(2,857,881)
25%
30%
31,350,466
32,076,461
725,995
REQUIREMENTS:
Exp.
Expenditures
Assessor
822,658
766,319
56,339
25%
23%
3,290,631
3,290,631
-
County Clerk
365,176
284,080
81,096
25%
19%
1,460,704
1,460,704
-
BOPTA
14,927
14,332
595
25%
24%
59,708
59,708
-
District Attorney
1,146,816
1,068,968
77,848
25%
23%
4,587,263
4,587,263
-
Finance/Tax
186,618
193,824
(7,206)
25%
26%
746,471
746,471
-
Veterans
56,425
53,530
2,895
25%
24%
225,701
225,701
-
Property Management
59,921
57,094
2,827
25%
24%
239,685
239,685
-
Grant Projects
26,418
25,352
1,066
25%
24%
105,673
105,673
-
Non-Departmental
403,252
182,987
220,265
25%
11%
1,613,006
1,613,006
-
Contingency
1,523,678
-
1,523,678
25%
0%
6,094,713
6,094,713
4,605,889
2,646,486
1,959,403
25%
14%
18,423,555
12,328,842
6,094,713
Transfers Out
3,231,728
3,158,643
73,085
25%
24%
12,926,911
12,926,911
-
TOTAL REQUIREMENTS
7,837,617
5,805,129
2,032,488
25%
19%
31,350,466
25,255,753
6,094,713
NET (Resources - Requirements)
4,537,501
3,712,108
(825,393)
-
6,820,708
6,820,708
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.
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Three Months Ended September 30, 2009
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
Level 7
Crime Prevention Services
Total Revenues
S
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$1,085,000 $1,200,041 $ 115,041 100% 111% $1,085,000 $1,200,041 $ 115,041
7,944
-
(7,944)
15,000
12,434
(2,566)
4,000
4,281
281
7,500
5,090
(2,410)
83,113
-
(83,113)
15,000
21,900
6,900
200
-
(200)
52,035
7,877
(44,158)
75
20
(55)
250
125
(125)
3,250
5,856
2,606
612
600
(12)
-
195
195
17,000
-
(17,000)
5,000
-
(5,000)
210,979
58,378
(152,601)
0%
a)
31,775
31,775
-
21%
60,000
60,000
-
27%
16,000
16,000
-
17%
30,000
30,000
-
0%
a)
332,450
340,076
7,626
37%
b)
60,000
80,000
20,000
0%
800
800
-
4%
c)
208,141
104,000
(104,141)
7%
300
300
-
13%
1,000
1,000
-
45%
13,000
16,000
3,000
25%
2,448
2,448
-
n/a
-
195
195
n/a
a)
68,000
68,000
-
0%
a)
20,000
20,000
-
7%
843,914
770,594
(73,320)
25%
5,543,186
5,543,186
-
35%
7,472,100
7,513,821
41,721
Exp.
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Transfers In-General Fund 1,385,797 1,385,796 (1) 25%
TOTAL RESOURCES 2,681,776 2,644,215 (37,561) 25%
REQUIREMENTS:
Expenditures
Community Justice-Juvenile
Personal Services
Materials and Services
Capital Outlay
Juvenile Resource Center
Personal Services
Materials and Services
Capital Outlay
Contingency
707,538
693,023
14,515
25%
24%
2,830,152
2,830,152 -
330,524
234,274
96,250
25%
18%
1,322,097
1,322,097 -
25
-
25
25%
0%
100
100 -
633,039
569,106
63,933
25%
22%
2,532,154
2,532,154 -
46,226
56,075
(9,849)
25%
30% d)
184,903
184,903 -
25
-
25
25%
0%
100
- 100
150,649
-
150,649
25%
n/a
602,594
602,594
TOTAL REQUIREMENTS 1,868,026 1,552,478 315,548 25% 21% 7,472,100 6,869,406 602,694
NET (Resources- Requirements) 813,750 1,091,737 277,987 - 644,415 644,415
a) Reimbursements requested quarterly.
b) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
c) Actual BRS revenue received for the month of July. Projection reduced to reflect actual youth count at half of original estimate.
d) Negative variance due to an annual subscription payment and appliance purchase early in the fiscal year.
SHERIFF - Fund 255
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
Total Revenues
Year to Date Year End
Budget Actual Variance FY % Coil. % Bud et Proiection Variance
$ - $ 183,677 $ 183,677 100%
5,060,734 3,975,041
(1,085,693) 25%
3,179,331 2,665,196
(514,135) 25%
- 10,050
10,050 25%
8,240,065 6,650,287
(1,589,778) 25%
n/a $ - $ 183,677 $ 183,677
20% a) 20,242,936 19,157,243 (1,085,693)
21% a) 12,717,322 12,203,188 (514,135)
n/a - 10,050 10,050
20% 32,960,258 31,370,481 (1,589,778)
TOTAL RESOURCES
8,240,065
6,833,964
(1,406,101)
25%
21%
32,960,258
31,554,157
(1,406,101)
REQUIREMENTS:
Exp. 9/61
EXPENDITURES & TRANSFERS
Sherifrs Division
490,297
516,178
(25,881)
25%
26%
1,961,188
1,961,088
100
Civil
181,740
192,875
(11,135)
25%
27%
726,961
726,961
-
Automotive/Communications
349,471
454,490
(105,019)
25%
33% b)
1,397,884
1,397,884
-
Investigations/Evidence
420,582
384,735
35,847
25%
23%
1,682,327
1,682,327
-
Patrol/Civil/Comm Supp
1,893,144
1,728,424
164,720
25%
23% c)
7,572,575
7,472,575
100,000
Records
160,591
148,084
12,507
25%
23%
642,363
642,263
100
Adult Jail
2,261,228
1,943,916
317,312
25%
21% c)
9,044,909
8,944,909
100,000
Court Security
53,977
47,280
6,697
25%
22%
215,908
215,808
100
Emergency Services
47,018
41,743
5,275
25%
22%
188,071
188,071
-
Special Services Division
277,173
276,787
386
25%
25%
1,108,690
1,108,690
-
Regional Work Center
684,461
570,095
114,366
25%
21% c)
2,737,842
2,637,742
100,100
Training Division
75,013
76,836
(1,823)
25%
26%
300,053
299,953
100
Other Law Enforcement Svcs
131,926
120,533
11,393
25%
23%
527,702
527,602
100
Non-Departmental
115,761
15,762
99,999
25%
3%
463,044
463,044
-
Contingency
962,685
-
962,685
25%
n/a
3,850,741
-
3,850,741
Transfers Out
135,000
122,500
12,500
25%
23%
540,000
540
000
-
,
TOTAL REQUIREMENTS
8,240,067
6,640,238
1,599,829
25%
20%
32,960,258
28,808,917
4,151,341
NET (Resources - Requirements)
(2)
193,726
193,728
-
2,745,240
2,745,240
a) Revenue from LED's based on actua
l expendiuture and adjus
ted q
uarterly. Projection is based on 1st quarter act
b) Year to date actual includ
es annual amount ($260,
405) of transfer to Fund 245 Communications System
c) Unfilled open positions resulting in les
s than planned personne
l expenses.
SHERIFF 701
Statement of Financial Operating Data
Three Months Ended September 30, 2009
I
Year to Date
Year End
d et
B
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
u
RESOURCES:
Beg. Net Working Capital
$ 2,470,519
$ 3,343,461 $
872,942
25%
nla
$ 2,470,519
$ 3,343,461
$ 872,942
Revenues
Tax Revenues - Current
3,704,926
-
(3,704,926)
25%
0% a)
14,819,703
14,819,703
-
Tax Revenues - Prior
125,000
387,241
262,241
25%
77%
500,000
500,000
-
Federal Grants
8,750
600
(8,150)
25%
2%
35,000
35,000
-
State Grant
11,289
18,563
7,274
25%
41%
45,156
45,156
-
Transp. of State Wards
1,250
-
(1,250)
25%
0%
5,000
5,000
-
SB 1145
430,298
483,834
53,536
25%
28% b)
1,721,192
1,935,336
214,144
Des. Cty Video Lottery Grant
1,250
-
(1,250)
25%
n/a
5,000
5,000
-
Des Cty Court Security
32,250
32,138
(112)
25%
25%
129,000
129,000
-
Des Cty Juvenile Contract
750
-
(750)
25%
0%
3,000
3,000
-
Title III Reimbursement
37,500
-
(37,500)
25%
n/a
150,000
150,000
-
Transport
500
1,318
818
25%
n/a
2,000
2,000
-
DC Fair & Expo Center
-
2,100
2,100
25%
n/a
-
3,000
3,000
Inmate Commissary Fees
15,000
5,982
(9,018)
25%
10%
60,000
60,000
-
Work Center Work Crews
10,613
9,390
(1,223)
25%
22%
42,450
42,450
-
Concealed Handgun Classes
1,500
2,050
550
25%
34%
6,000
6,000
-
Soc Sec Incentive-Fed
1,250
3,400
2,150
25%
68%
5,000
5,000
-
Miscellaneous
1,000
608
(392)
25%
15%
4,000
4,000
-
Oregon Mentors
1,250
1,902
652
25%
n/a
5,000
5,000
-
Medical Services Reimb
3,000
2,668
(332)
25%
22%
12,000
12,000
-
Restitution
263
424
161
25%
40%
1,050
1,050
-
Sheriff Fees
40,000
54,472
14,472
25%
34%
160,000
160,000
-
Interest
7,083
5,021
(2,062)
25%
18%
28,333
28,333
-
Interest on Unsegregated
883
263
(620)
25%
7%
3,533
3,533
-
Rentals
7,499
42,442
34,943
25%
141% c)
30,000
51,236
21,236
Donations
-
50
50
25%
n/a
-
50
50
Total Revenues
4,443,104
1,054,466
(3,388,638)
25%
6%
17,772,417
18,010,847
238,430
TOTAL RESOURCES
6,913,623
4,397,927
(2,515,696)
25%
22%
20,242,936
21,354,308
1,111,372
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFE
RS
Materials and Services
5,060,735
3,975,041
1,085,694
25%
20% d)
20,242,936
19,157,243
1,085,693
TOTAL REQUIREMENTS
5,060,735
3,975,041
1,085,694
25%
20%
20,242,936
19,157,243
1,085,693
NET (Resources - Requirements)
888
1
852
422,886
(1,430,002)
-
2,197,065
2,197,065
,
,
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 Sheriffs Office has been delayed resulting in 4 months of additional rental revenue.
d) Payment to Sheriffs Office based on actual expendiuture and adjusted quarterly. Projection is based on 1 st quarter actual.
SHERIFF 702
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,287,473
$ 1,433,708
$ 146,235
25%
n/a
$1,287,473
$1,433,708
$ 146,235
Revenues
Tax Revenues - Current
1,809,925
-
(1,809,925)
25%
0% a)
7,239,702
7,239,702
-
Tax Revenues - Prior
59,750
197,422
137,672
25%
83%
239,000
239,000
-
Federal Grants
500
5,212
4,712
25%
261%
2,000
5,212
3,212
US Forest Service
19,125
12,750
(6,375)
25%
17%
76,500
76,500
-
State Grant
46,908
12,212
(34,696)
25%
7%
187,633
187,633
-
SB #1065 Court Assessment
16,750
12,434
(4,316)
25%
19%
67,000
67,000
-
Marine Board License Fee
31,117
-
(31,117)
25%
0%
124,468
124,468
-
Des Cty General Fund Grnt
215,791
10,000
(205,791)
25%
1%
863,163
863,163
-
Des Cty Transient Room Tax
446,709
446,709
-
25%
25%
1,786,837
1,786,837
-
City of Sisters
105,004
104,004
(1,000)
25%
25% b)
420,015
416,016
(3,999)
Des Cty Tax/Fin Contract
250
-
(250)
25%
0%
1,000
1,000
-
Des Cty CDD Contract
6,796
6,796
-
25%
25%
27,183
27,183
-
Des Cty Solid Waste Contr
20,387
20,387
-
25%
25%
81,548
81,548
-
Des Cty Clerk/Election
500
54
(446)
25%
3%
2,000
2,000
-
School Districts
25,000
-
(25,000)
25%
n/a
100,000
100,000
-
Security & Traffic Reimb
3,250
1,386
(1,864)
25%
11%
13,000
13,000
-
Seat Belt Program
1,500
2,500
1,000
25%
42%
6,000
6,000
-
Miscellaneous
2,500
3,172
672
25%
32%
10,000
10,000
-
Sheriff Fees
1,250
3,228
1,978
25%
65%
5,000
5,000
-
Court Fines & Fees
21,250
29,429
8,179
25%
35%
85,000
85,000
-
Impound Fees
18,750
6,100
(12,650)
25%
8%
75,000
75,000
-
Restitution - Street Crimes
-
500
500
25%
n/a
-
500
500
Seizure/Forfeiture
-
1,122
1,122
25%
n/a
-
2,500
2,500
Interest
2,500
92
(2,408)
25%
1%
10,000
10,000
-
Interest on Unsegregated
450
128
(322)
25%
7%
1,800
1,800
-
Sale of Reportable Assets
-
7,254
7,254
25%
n/a
-
10,000
10,000
Sale of Equip & Material
1,500
-
(1,500)
25%
0%
6,000
6,000
-
Total Revenues
2,857,462
882,891
(1,974,571)
25%
8%
11,429,849
11,442,062
12,213
TOTAL RESOURCES 4,144,935 2,316,599 (1,828,336) 25%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 3,179,331 2,665,196 514,135 25%
TOTAL REQUIREMENTS 3,179,331 2,665,196 514,135 25%
18%
Exp. 0/61
12,717,322 12,875,770 158,448
21% c) 12,717,322 12,203,188 514,135
21% 12,717,322 12,203,188 514,135
NET (Resources - Requirements) 965,604 (348,597) (1,314,201) - 672,582 672,582
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.
c) Payment to Sheriffs Office based on actual expendiuture and adjusted quarterly. Projection is based on 1st quarter actual.
PUBLIC HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
I
-F
Year End
I
Budget
Actual
Variance
F; %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 900,000
$ 1,120,355
$ 220,355
100%
124%
$ 900,000
$1,120,355
$ 220,355
Revenues
Medicare Reimbursement
1,000
-
(1,000)
25%
0%
4,000
4,000
-
State Grant
455,561
416,112
(39,449)
25%
23%a),e)
1,822,242
2,332,439
510,197
Child Dev & Rehab Center
8,684
-
(8,684)
25%
0%
34,737
34,737
-
State Miscellaneous
53,310
54,578
1,268
25%
26%
213,240
213,240
-
OMAP
75,750
93,811
18,061
25%
31%
303,000
303,000
-
Family Planning Exp Proj
118,750
94,903
(23,847)
25%
20% b)
475,000
475,000
-
Grants
-
22,254
22,254
25%
n/a c)
-
22,254
22,254
Patient Insurance Fees
33,450
32,875
(575)
25%
25%
133,800
133,800
-
Health Dept/Patient Fees
38,038
36,149
(1,889)
25%
24%
152,150
152,150
-
Vital Records-Birth
9,000
8,320
(680)
25%
23%
36,000
36,000
-
Vital Records-Death
24,500
26,450
1,950
25%
27%
98,000
98,000
-
Interest on Investments
9,500
4,974
(4,526)
25%
13%
38,000
38,000
-
Donations
2,200
1,918
(282)
25%
22%
8,800
8,800
-
Interfund Contract
32,944
-
(32,944)
25%
0%
131,774
131,774
-
Administrative Fee
6,750
6,750
-
25%
25%
27,000
27,000
-
Total Revenues
869,437
799,094
(70,343)
25%
23%
3,477,743
4,010,194
532,451
Transfers In-Reserve Fund
6,250
-
(6,250)
25%
0%
25,000
25,000
-
Transfers In-General Fund
579,441
579,441
-
25%
25%
2,317,765
2,317,765
-
TOTAL RESOURCES
2,355,128
2,498,890
150,012
25%
37%
6,720,508
7,473,314
752,806
REQUIREMENTS: Exp•
Expenditures
Personal Services
1,053,796
1,023,767
30,029
25%
24% d),e)
4,215,182
4,584,151
(368,969)
Materials and Services
357,093
298,635
58,458
25%
21%
1,428,371
1,784,531
(356,160)
Capital Outlay
4,226
-
4,226
25%
0%
16,902
16,902
-
Transfers Out
37,500
37,500
-
25%
25%
150,000
150,000
-
Contingency
227,513
-
227,513
25%
n/a
910,053
-
910,053
TOTAL REQUIREMENTS
1,680,128
1,359,902
320,226
25%
20%
6,720,508
6,535,584
184,924
NET (Resources - Requirements)
675,000
1,138,988
470,238
-
937,730
937,730
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.
e) Projection increases due to LAUNCH grant award totaling $607,686.
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Three Months Ended September 30, 2009
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
Year to Date
Budget
Actual
Variance
FY %
Coll. %Vl.
$ 2,725,000 $ 2,589,996 $ (135,004) 100%
1,375
2,185
810
31,250
31,689
439
500
30
(470)
24,955
-
(24,955)
1,152,810
1,540,071
387,261
46,179
5,155
(41,024)
75,176
-
(75,176)
26,500
14,320
(12,180)
17,500
26,700
9,200
10,200
4,342
(5,858)
61,875
35,748
(26,127)
2,875
1,176
(1,699)
8,000
13,099
5,099
4,125
1,750
(2,375)
750
7,000
6,250
780
-
(780)
758,739
736,239
(22,500)
5,500
-
(5,500)
31,750
-
(31,750)
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
Year End
Bud Budget Proiection Variance
E I
95% $ 2,725,000 $ 2,589,996 $ (135,004)
40%
5,500
5,500
-
25%
125,000
125,000
-
2%
2,000
2,000
-
0%
a)
99,819
99,819
-
33%
b)
4,611,239
5,351,224
739,985
3%
184,716
184,716
-
0%
c)
300,705
300,705
-
14%
106,000
106,000
-
38%
70,000
88,800
18,800
11%
40,800
40,800
-
14%
247,500
247,500
-
10%
11,500
11,500
-
41%
32,000
32,000
-
11%
16,500
16,500
-
233%
3,000
7,000
4,000
0%
3,120
3,120
-
24%
3,034,954
3,031,954
(3,000)
0%
22,000
-
(22,000)
0%
a)
127,000
127,000
-
2,260,839 2,419,504 158,665 25% 27% 9,043,353 9,781,138 737,785
Transfers In-General Fund 329,040 329,040 - 25%
Transfers In-Other 63,909 90,783 26,874 25%
TOTAL RESOURCES 5,378,788 5,429,323 50,535 25%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
25% 1,316,158 1,316,158 -
36% 255,636 363,129 107,493
41% 13,340,147 14,050,421 710,274
Exp.
1,787,312
1,733,110
54,202
25%
24%
7,149,249
7,890,661
(741,412)
1,013,379
574,283
439,096
25%
14%
4,053,514
4,053,514
-
20,000
-
20,000
25%
0%
80,000
80,000
-
37,500
37,500
-
25%
25%
150,000
150,000
-
476,846
-
476,846
25%
n/a
1,907,384
-
1,907,384
3,335,037
2,344,893
990,144
25%
18%
13,340,147
12,174,175
1,165,972
2,043,751
3,084,430
1,040,679
-
1,876,246
1,876,246
a) Grant billing received quarterly, in arrears.
b) Dept of Human Services Grant projected at amended contract amount for FY 2010.
c) Delay in payment due to problems with the State MMIS software system.
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Bud et
Actual
Variance
FY %
Coll. %
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
913
5,819
4,906
25%
159%
a)
3,650
23,000
19,350
Admin-GIS
519
275
(244)
25%
13%
b)
2,075
38,275
36,200
Admin-Code Enforcement
47,363
44,523
(2,840)
25%
24%
c)
189,450
178,000
(11,450)
Building Safety
243,694
243,147
(547)
25%
25%
c)
974,775
972,500
(2,275)
Electrical
70,125
75,586
5,461
25%
27%
d)
280,500
302,300
21,800
Contract Services
63,875
14,514
(49,361)
25%
6%
e)
255,500
84,100
(171,400)
Env Health-On Site Prog
73,213
58,070
(15,143)
25%
20%
c)
292,850
232,200
(60,650)
Env Health-Lic Facilities
172,619
58,675
(113,944)
25%
8%
f)
690,475
690,475
-
Env Health - Drinking H2O
23,828
23,176
(652)
25%
24%
g)
95,311
95,311
-
Planning-Current
246,038
214,759
(31,279)
25%
22%
h)
984,150
859,000
(125,150)
Planning-Long Range
107,225
60,603
(46,622)
25%
14%
428,900
422,400
(6,500)
Total Revenues
1,049,412
799,147
(250,265)
25%
19%
4,197,636
3,897,561
(300,075)
Trans In-GF
304,157
304,158
1
0%
n/a
1,216,627
1,216,627
-
Trans In-GF for Lng Rng Ping
75,000
75,000
-
0%
n/a
300,000
300,000
-
Trans In-Other
25
-
(25)
0%
0%
100
-
(100)
TOTAL RESOURCES
1,842,065
1,807,964
(34,101)
25%
30%
6,127,834
6,043,847
(83,987)
REQUIREMENTS: F EX p. 0/61
EXPENDITURES & TRANSFERS
Admin-Operations
427,028
418,214
8,814
25%
24%
1,708,112
1,708,112 -
Admin-GIS
53,902
50,763
3,139
25%
24%
215,606
215,606 -
Admin-Code Enforcement
45,242
43,741
1,501
25%
24%
180,969
180,969 -
Building Safety
181,286
175,047
6,239
25%
24%
725,145
725,145 -
Electrical
51,680
49,444
2,236
25%
24%
206,719
206,719 -
Contract Services
66,195
63,278
2,917
25%
24%
264,781
264,781 -
Env Health-On Site Pgm
60,172
57,134
3,038
25%
24%
240,687
240,687 -
Env Health-Lic Facilities
123,987
122,731
1,256
25%
25%
495,946
495,946 -
Env Health - Drinking H2O
20,150
19,513
637
25%
24%
80,598
80,598 -
Planning-Current
202,446
193,788
8,658
25%
24%
809,783
809,783 -
Planning-Long Range
137,957
105,114
32,843
25%
19%
551,828
551,828 -
Transfers Out (D/S Fund)
44,415
44,415
-
0%
25%
177,660
177,660 -
Contingency
117,500
-
117,500
25%
n/a
470,000
- 470,000
TOTAL REQUIREMENTS
1,531,960
1,343,182
188,778
25%
22%
6,127,834
5,657,834 470,000
NET (Resources - Requirements)
310,105
464,782
154,677
-
386,013 386,013
Revenues
799,147
3,897,561
Expenditures
1,343,182
5,657,834
Net from Operations
(544,035)
(1,760,273)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance.
b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT-Web Programmer.
c) Projections are slightly below budget. On-Site work volume has slowed significantly.
d) Business volume and revenue have thus far exceeded expectations.
e) Significant drop-off in City of Redmond work.
f) Revenue is received primarily in December through February following mailing of license renewal statements.
g) Payments from State DHS are received irregularly.
h) Significant slowdown in land use applications.
ROAD
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date Year End
Budget Actual Variance FY % Coll. % Bud et 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
122,500
-
(122,500)
25%
0%
490,000
490,000
-
System Development Chrg
-
231
231
25%
n/a
-
925
925
Mineral Lease Royalties
2,500
6,514
4,014
25%
65%
10,000
10,000
-
Forest Receipts
620,500
-
(620,500)
25%
0%
a)
2,482,000
2,482,000
-
State Grant
103,869
-
(103,869)
25%
0%
415,477
415,477
-
Motor Vehicle Revenue
2,000,000
1,649,388
(350,612)
25%
21%
8,000,000
8,000,000
-
City of Bend
56,250
-
(56,250)
25%
0%
b)
225,000
225,000
-
City of Redmond
62,500
-
(62,500)
25%
0%
b)
250,000
250,000
-
City of Sisters
2,500
-
(2,500)
25%
0%
b)
10,000
10,000
-
City of La Pine
2,500
-
(2,500)
25%
n/a
b)
10,000
10,000
-
Admin Recovery (SDC)
125
447
322
25%
n/a
500
500
-
Miscellaneous
32,500
11,376
(21,124)
25%
9%
130,000
130,000
-
Road Vacations
250
-
(250)
25%
0%
1,000
1,000
-
Interest on Investments
12,500
19,304
6,804
25%
39%
50,000
50,000
-
Other Bank/LGIP Interest
-
386
386
25%
n/a
-
1,500
1,500
Interfund Contract
175,000
-
(175,000)
25%
0%
c)
700,000
700,000
-
Equipment Repairs
68,750
37,728
(31,022)
25%
14%
275,000
275,000
-
Vehicle Repairs
22,500
-
(22,500)
25%
0%
c)
90,000
90,000
-
Vegetation Management
8,750
-
(8,750)
25%
0%
c)
35,000
35,000
-
Inter-fund: Forester
5,500
-
(5,500)
25%
0%
c)
22,000
22,000
-
Car Washes
625
-
(625)
25%
0%
2,500
2,500
-
Car Rental
-
356
356
25%
n/a
-
1,000
1,000
Other Income
-
79,920
79,920
25%
n/a
-
79,920
79,920
Sale of Eqp & Material
200,000
1,691
(198,309)
25%
0%
800,000
800,000
-
Total Revenues
3,499,619
1,807,341
(1,692,278)
25%
13%
13,998,477
14,081,822
83,345
Trans In - CDD
4,548
-
(4,548)
25%
0%
18,190
18,190
-
Trans In - Solid Waste
177,142
177,142
-
25%
25%
d)
708,567
708,567
-
Trans In - Transp SDC
18,750
18,750
-
25%
25%
75,000
75,000
-
Trans In-Road Imp Res
2,500
-
(2,500)
25%
0%
c)
10,000
10,000
-
TOTAL RESOURCES
8,555,474
6,894,882
(1,679,342)
25%
43%
19,681,899
19,785,228
103,329
REQUIREMENTS:
Exp.
Expenditures
Personal Services
1,416,343
1,317,641
98,702
25%
23%
5,665,373
5,665,373
-
Materials and Services
2,283,303
2,533,288
(249,985)
25%
28%
9,133,210
9,133,210
-
Capital Outlay
675,000
309,273
365,727
25%
11%
2,700,000
2,700,000
-
Transfers Out
100,000
-
100,000
25%
0%
400,000
400,000
-
Contingency
445,829
-
445,829
25%
n/a
1,783,316
-
1,783
316
,
TOTAL REQUIREMENTS
4,920,475
4,160,202
760,273
25%
21%
19,681,899
17,898,583
1,783,316
NET (Resources - Requirements)
3,634,999
2,734,680
(919,069)
-
1,886,645
1,886,645
a) Annual payment anticipated to be received in December 09.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430
d) Payment received quarterly from Solid Waste.
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
State Miscellaneous
State Subsidy
SB 1145
Probation Work Crew Fees
Miscellaneous
Electronic Monitoring Fee
Probation Superv. Fees
Interest on Investments
Crime Prevention Services
Total Revenues
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ 467,892 $
487,674 $
19,782
100%
104%
$ 467,892
$ 487,674 $ 19,782
2,000
-
(2,000)
25%
0% a)
8,000
4,301 (3,699)
7,375
3,327
(4,048)
25%
n/a b)
29,500
29,500 -
709,981
725,750
15,769
25%
26%
2,839,925
2,839,925 -
10,000
7,515
(2,485)
25%
19% c)
40,000
40,000 -
750
805
55
25%
27%
3,000
3,000 -
40,000
39,696
(304)
25%
25%
160,000
160,000 -
55,000
56,382
1,382
25%
26%
220,000
220,000 -
2,250
3,564
1,314
25%
40%
9,000
9,000 -
12,500
-
(12,500)
25%
n/a
50,000
50,000 -
839,856
837,039
(2,817)
25%
25%
3,359,425
3,355,726 (3,699)
Transfers In-General Fund
28,757 28,758
1
25%
25%
115,029
115,029 -
Transfers In-Sheriff
12,500 -
(12,500)
25%
0%
50,000
50,000 -
TOTAL RESOURCES
1,349,005 1,353,471
4,466
25%
34%
3,992,346
4,008,429 16,083
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp.
714,682
689,045
25,637
25%
24%
2,858,726
2,858,726
-
176,030
157,616
18,414
25%
22%
704,121
704,121
-
25
-
25
25%
0%
100
-
100
107,350
-
107,350
25%
n/a
429,399
-
429,399
998,087
846,661
151,426
25%
21%
3,992,346
3,562,847
429,499
350,918
506,810
155,892
-
445,582
445,582
a) 1 st quarter hearings officer revenue not yet received. The $8,000 is for the biennium. Actual for FY 2010 will be $4,301.
b) Contract is being finalized for AIP funds.
c) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget et
Actual
Variance
FY %
Coll. %
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
56,250
-
(56,250)
25%
0%
225,000
225,000
-
Title IV - Family Sup/Pres
9,413
-
(9,413)
25%
0%
a)
37,652
39,328
1,676
HealthyStart Medicaid
23,750
-
(23,750)
25%
0%
95,000
95,000
-
Child Care Block Grant
20,319
-
(20,319)
25%
0%
a)
81,275
-
(81,275)
Level 7 Services
43,798
-
(43,798)
25%
0%
a)
175,193
257,982
82,789
HealthyStart /R-S-G
76,894
76,820
(74)
25%
25%
a)
307,577
308,924
1,347
OCCF Grant
153,513
253,327
99,814
25%
41%
a)
614,052
492,383
(121,669)
Miscellaneous
2,000
482
(1,518)
25%
6%
8,000
8,000
-
Court Fines & Fees
18,750
19,014
264
25%
25%
c)
75,000
70,000
(5,000)
Interest on Investments
7,500
2,782
(4,718)
25%
9%
30,000
30,000
-
Grants-Private
500
-
(500)
25%
0%
2,000
2,000
-
Miscellaneous
46,875
20,000
(26,875)
25%
n/a
187,500
187,500
-
Crime Prevention Services
18,588
-
(18,588)
25%
0%
74,350
74,350
-
Total Revenues
478,150
372,425
(105,725)
25%
19%
1,912,599
1,790,467
(122,132)
Trans from General Fund
71,083
71,083
-
25%
25%
284,333
284,333
-
Total Transfers In
71,083
71,083
-
25%
25%
284,333
284,333
-
TOTAL RESOURCES
1,173,776
1,112,134
(61,642)
25%
39%
2,821,475
2,743,426
(78,049)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
134,995
119,536
15,459
25%
22%
b)
539,978
494,522
45,456
Materials and Services
443,761
107,929
335,832
25%
6%
1,775,043
1,627,861
147,182
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
126,589
-
126,589
25%
n/a
506,354
-
506,354
TOTAL REQUIREMENTS
705,370
227,465
477,905
25%
8%
2,821,475
2,122,383
699,092
NET (Resources - Requirements) 468,406 884,669 416,263 - 621,043 621,043
a) Revenue projections reflect from final legislative allocations.
b) Personnel projection reduced due to two positions open in 1 st quarter.
c) Court fees reduced for FY 2010.
SOLID WASTE
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
Miscellaneous
Franchise 3% Fees
Commercial Disp. Fees
Private Disposal Fees
Franchise Disposal Fees
Yard Debris
Special Waste
Interest
Recyclables
Sale of Equip & Material
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Year to Date Year End
Budget Actual Variance FY % Coll. % Bud et Proiection Variance
$ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714
7,500
7,022
(478)
25%
23%
30,000
30,000 -
50,000
8,349
(41,651)
25%
4%
a)
200,000
200,000 -
349,100
251,871
(97,229)
25%
18%
1,396,400
1,396,400 -
385,325
418,515
33,190
25%
27%
1,541,300
1,541,300 -
1,185,875
1,113,514
(72,361)
25%
23%
4,743,500
4,743,500 -
18,750
23,775
5,025
25%
32%
75,000
75,000 -
7,500
12,544
5,044
25%
42%
b)
30,000
30,000 -
3,500
4,579
1,079
25%
33%
14,000
14,000 -
-
7,417
7,417
25%
n/a
c)
-
35,000 35,000
8,750
-
(8,750)
25%
0%
d)
35,000
- (35,000)
2,016,300
1,847,586
(168,714)
25%
23%
8,065,200
8,065,200 -
2,354,911
2,313,911
(41,000)
25%
28%
8,403,811
8,531,525 127,714
Exp.
440,895
417,990
22,905
25%
937,064
633,251
303,813
25%
242,191
-
242,191
25%
37,250
23,971
13,279
25%
359,942
177,142
182,800
25%
83,612
-
83,612
25%
24%
17% e)
0% f)
16% g)
12%
n/a
1,763,578
1,763,578 -
3,748,254
3,748,254 -
968,765
968,765 -
149,000
149,000 -
1,439,767
1,439,767 -
334,447
- 334,447
TOTAL REQUIREMENTS 2,100,954 1,252,354 848,600 25% 15%
NET (Resources - Requirements) 253,957 1,061,557 807,600
8,403,811 8,069,364 334,447
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.
D Payments are scheduled for Nov and May.
g) Capital item purchases are spread out throughout the fiscal year.
RISK MANAGEMENT
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beginning Net Working Capital
Revenues
Inter-fund Charges:
General Liability
Property Damage
Vehicle
Workers' Compensation
Unemployment
Claims Reimb-Workers' Compensation
Claims Reimb-Gen Liab/Property
Process Fee-Events/Parades
Miscellaneous
Skid Car Training
Interest on Investments
TOTAL REVENUES
Transfers In-PERS Reserve
TOTAL RESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Repair / Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement / Benefit
Insurance
Loss Prevention
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Contingency
TOTAL REQUIREMENTS
NET
Year to Date
Budget
I
Actual
Variance
% of FY
Z Coll.
Budget
Year End
Projection
Variance
$2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314
114,241
114,236
(5)
71,574
71,526
(48)
46,049
46,049
0
213,964
213,960
(4)
40,048
40,051
3
6,250
-
(6,250)
2,500
1,396
(1,104)
225
455
230
1,000
12
(988)
5,500
1,050
(4,450)
7,500
11,973
4,473
508,850
500,708
(8,142)
25
-
(25)
3,000,852 3,169,999 169,148
25% 25%
25% 25%
25% 25%
25% 25%
25% 25%
25% 0%
25% 14%
25% 51%
25% 0%
25% 5%
25% 40%
25% 25%
25% 0%
25% 70%
Ex .
456,964
286,294
184,195
855,854
160,191
25,000
10,000
900
4,000
22,000
30,000
2,035,398
100
4,527,475
456,964 -
286,294 -
184,195 -
855,854 -
160,191 -
25,000 -
10,000 -
900 -
4,000 -
22,000 -
30,000 -
2,035,398 -
- (100
4,704,689 177,214
6,349
974
1,418
13
299
91,278 9,052 82,226 25% 2% 365,112 360,000 5,112
87,591
75,000 87,591 (12,591) 25% 29% 300,000 300,000 -
883
411
284
21,149
30,000 22,726 7,274 25% 19% 120,000 115,000 5,000
108,387
61,773
956
155,000 171,117 (16,117) 25%
35,000 - 35,000 25%
386,278 290,486 95,792 25%
68,509
67,479
1,030
61,623
45,850
15,774
25
-
25
130,157
113,329
16,828
615,434
-
615,434
1,131,869
403,815
728,054
1,868,983
2,766,184
897,201
28% 620,000 630,000 (10,000)
0% 140,000 145,000 (5,000)
19% 1,545,112 1,550,000 (4,888)
25%
25%
274,034
274,034
-
25%
19%
246,493
246,493
-
25%
0%
100
-
100
25%
22%
520,627
520,527
100
25%
n/a
2,461,736
-
2,461,736
25%
9%
4,527,475
2,070,527
2,456,948
-
2,634,162
2,634,162
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date Year End
Budget Actual Variance % of FY % Coll. Bud et Pro'ection Variance
RESOURCES:
Beg. Net Working Capital
$5,137,000
$ 5,611,168
$ 474,168
Revenues
Property Taxes - Current
1,532,696
-
(1,532,696)
Property Taxes - Prior
25,000
142,082
117,082
State Reimbursement
6,125
1,553
(4,572)
Telephone User Tax
134,000
-
(134,000)
Data Network Reimb.
8,500
20,240
11,740
Jefferson County
7,000
4,657
(2,343)
User Fee
15,125
44,855
29,730
Contract Payments
17,500
23,978
6,478
Miscellaneous
2,125
2,412
287
Interest
9,000
22,325
13,325
Interest on Unsegregated Tax
938
109
(829)
Total Revenues
1,758,009
262,211
(1,495,798)
Transfers In-Other
TOTALRESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
100% 109%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
25%
0% a)
142%
6% b)
0%
60% c)
17%
74% d)
34% c)
28%
62%
3%
4%
25 - (25) 25% 0%
6,895,009 5,873,379 (1,021,630) 25% 48%
Exp.
$5,137,000 $5,611,168 $ 474,168
6,130,782
6,130,782 -
100,000
142,082 42,082
24,500
24,500 -
536,000
536,000 -
34,000
27,880 (6,120)
28,000
28,000 -
60,500
60,500 -
70,000
70,000 -
8,500
8,500 -
36,000
36,000 -
3,750
3,750 -
7,032,032
7,067,994 35,962
100 - (100)
12,169,132 12,679,162 510,030
954,072
863,697
90,375
25%
23%
3,816,287
3,816,287 -
322,381
209,334
113,047
25%
16%
1,289,522
1,289,522 -
43,750
13,830
29,920
25%
8%
175,000
175,000 -
484,735
-
484,735
25%
0%
1,938,939
1,938,939 -
1,237,346
-
1,237,346
25%
n/a
4,949,384
- 4,949,384
3,042,284
1,086,861
1,955,423
25%
9%
12,169,132
7,219,748 4,949,384
3,852,725
4,786,518
933,793
-
5,459,414 5,459,414
a) Approximately 85% of the property taxes are collected in October and November.
b) September 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
Three Months Ended September 30, 2009
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget *
Pro'ection
Variance
RESOURCES
Beg. Net Working Capital
$17,894,797
$ 17,894,797
$ (0)
100%
100%
$17,894,797
$17,894,797
$ (0)
Revenues:
Internal Premium Charges
2,620,000
2,610,106
(9,894)
25%
25%
a)
10,480,000
10,440,425
(39,575)
P/T Emp -Add'I Prem
13,750
11,312
(2,438)
25%
21%
55,000
55,000
-
Employee Prem Contribution
82,500
84,840
2,340
25%
26%
330,000
330,000
-
COIC
250,000
269,869
19,869
25%
27%
1,000,000
1,000,000
-
Retiree / COBRA Co-Pay
125,000
147,235
22,235
25%
29%
500,000
500,000
-
Prescription Rebates
-
5,544
5,544
25%
n/a
-
5,544
5,544
Interest
56,250
74,193
17,943
25%
33%
225,000
225,000
-
Total Revenues
3,147,500
3,203,099
55,599
25%
25%
12,590,000
12,555,969
(34,031)
TOTAL RESOURCES
21,042,297
21,097,896
55,599
92%
69%
30,484,797
30,450,766
(34,031)
REQUIREMENTS
Exp.
Expenditures:
Personal Services
27,324
25,937
1,387
25%
24%
109,297
109,297
-
Materials & Services
Conferences and Seminars
750
505
245
25%
17%
3,000
3,000
-
Claims Paid-Medical/Rx
3,561,894
2,632,065
929,829
25%
18%
b)
14,247,576
10,528,262
3,719,314
Claims Paid-Dental/Vision
455,500
393,649
61,851
25%
22%
b)
1,822,000
1,574,598
247,402
Refunds
-
(13,432)
13,432
25%
n/a
-
(13,432)
13,432
Insurance Expense
93,135
92,926
209
25%
25%
372,540
372,540
-
State Assessments
2,875
68,989
(66,114)
25%
n/a
c)
11,500
11,500
-
Administration Fee
73,191
71,901
1,290
25%
25%
292,764
292,764
-
PPO Fee
20,412
9,232
11,180
25%
11%
81,648
81,648
-
Health Impact
12,393
12,406
(13)
25%
25%
49,572
49,572
-
Printing
2,500
344
2,156
25%
3%
10,000
10,000
-
Program Supplies
25,000
-
25,000
25%
0%
100,000
100,000
-
Other
7,265
6,000
1,265
25%
21%
29,059
29,059
-
Total Materials & Services
4,254,915
3,274,584
980,330
25%
19%
17,019,659
13,039,511
3,980,148
Capital Outlay
-
-
-
25%
0%
100
-
100
Contingency
3,338,935
-
3,338,935
25%
0%
13,355,741
-
13,355,741
TOTAL REQUIREMENTS
7,621,174
3,300,521
4,320,653
25%
11%
30,484,797
13,148,808
17,335,989
NET (Resources - Requirements)
13,421,123
17,797,375
4,376,252
-
17,301,958
17,301,958
* Proposed revisions to FY 2010 original budget
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Based on annualizing 13 weeks of claims paid. $231,714 per week.
c) Zurich to reimburse County $57,490 (5/6ths) of the $68,989 payment made in July for the July through December assessment.
3
O
LL
o
N
O
U N M
m m O m
U a a L
%mm-1
W n O
.o m $
C r M
3 L
C j~
O
tL k O N
y W
O d
7 N O O
0 C N U
m-0
j 7 Z
m .0
O p Q U
Ltj
o u-
UO
Q 0:
L a
0
2
N
f~
0
0
O
0
r
O
°
h
'
OO
I O
O
n
tO
ca
0
0i
V
(O
N
V
0
(0
(°+1
°0
o°
n
v
rl
vi
~
o
v
o
ao
A
r
tO
N
o
o
r
m
aND
Q) N
00
N
N
.
N
N
0
N
$D
M
M
0 C
v
v
v
_
N
Iv
~
V
V
N
Y
N
~
V
>
~
I
i
I
I
0
0
0
0
0
0
0
0
0
0
0
0
O
V
O
M
M
I
0
0
0
O D
O
t O
CD
N
N
N
N
0
O
0
N
0
0
0
O
0
O
0
0
0
0
0
ce)
0
a
0
a
pp
co
r
O
co
O
r
V
A
O
NV
O
~
m
n
O
V
~
5
O0i
N
N
N
h
M
Cq
C3;
CO
tp
tO
0
N
fO
r
N
O
r
(O
W
_
?
m
to
h
"o
N
Oaf
ccoo
~
M
v
r
0
Q1
N
o
rn
v
N
N
N
r
I
O+O
M
0 0
O
0
O
O
C>
O
r
O
V
O
O
p0pp
V
p
t
VI
M
M
M
r
t O
~I
N
M
O
N
V
a0
0 0
O
O
10
O
r
N
~
O
1
Q
Y
O N U
co
O
'
O
O
-
M
OD
O
M
0
OI
CD
O
'
(D
r
N
V
r
41
x
0
0
V
V
w
N
ao
N 7 m
M
~
~
V
M
~
V
•'i
CO-
N
N
r
N
0
0
r
N
O
t-
to
LO
N
ON1
ao
tN
O
<
co
D7
N
cO
a0
v
M
N
tL Q a
I
I
I
I
~
VI
I
~
(O
U
N
'0
N
w
NI
N
i
0
0~
0
0
O
CD
O
tO
O
N
01
N
iO
(D
O
M
'
0
0
1]
'
M
~
~
M
'
M
O
M
co
O
O
r
V
D1
0
'
O
N
7
N
r
V
I
M
V
M
ao
O
m
tri
tri
M
N
co
ID
It
N
M
V
co
N
O
O
O
i
O
(
0
0
0
O
O
'
0
M
0
C.
0
O
'
N
M
N
00
M
r
O
M
'
M
O
N
0
D
C
(
0
'
co
O1
N
r
t;
M'
00
V
M
O1
O
N
N
6O
0
`
v
C
v
V
t
0
0
0
0
0
0
0
0
0
0
to
r
O
O
'
0
0
0
0
0
0
0
0
'
O
O
N
M
N
OD
M
P-
O
M
'
M
O
O1
r
CO
(O
tO
O f
t1
Q
O
(0
V
N
r
M
In
V
T
O
00
M
OD
V
t(pp
O
CD
O
O
O
0
0
0
O
t0
N
M
0
O
r
O
U
O
OR
O
M
'
O
0
'
O
0
co
r
0
'
O
r
r
M
M
r
O
cM
'
M
O
V
M
CD
O
t0
T
C0
'
tO
M
O
r
co
r-
04
N
7
N
0
7
M
7
0
n
O
CO
o1
Z.
O
O
O
V
V
O
O
O
0
co
t0
O
a
O
O
tO
'
O
0
O
0
'
M
M
M
OD
M
r
O
M '
M
O
^
C O
t D
M
m
`
(O
N
C"
co
M'
M
M'
0.
U-
I
Z`
O
O
O
O
V
M
V
M
M
O
A
01
0
0
r
N
M
tD
m
D)
'
'
'
O
M
N
r
O
M '
M
O
r
N.
V
(O
.
'
V
C
O
O
O
N
M
N
0
0
M
0
0
r
M
M
c
+7
t
O
(
0
1
A
O
o
f
O
`y
a
O
O
O
O
'
O
O
'
O
O
O
r
'
d'
M
O/
O
O
M
O
'
M
I
N
N
I
0
CO
07
N
O
N
N'
O
'
tO
U,
I
n
tD
E
0
L0
CO
O
N
O
tO
M
OD
to
r
CO
n
V
O
M
N
A
0
O
to
of
0
tO
A
to
U
N
co
V
OD I
M
V
A
m
I
y
o
0
0
V
It
'
o
^
M
m
co
t:
E
a
o
N
)
'
o
O
'
o
0
'
M
M
M
OD
(
r
o
M '
M
O
o
00
m
V
'
a
N
m
N
r
0
V
N
(00
M
r
M
v
N
v
Z
I
0
0
o
v
v
o
0
0
<
m
m
o
N
O
°
M
co
M
M
a
a
Co
N
t
n
00
'
o
O1
-
0
'
MO
M
O
O
00
N
I
N
M
I
W
N
I
I
N
M
O
O
V
0
M
O
0
(O
I
M
I
N
O
O
O
Of
O V 3
0
O
r
a-
O
0i
N
'
O
W
(O
CO
O
'I
r
M
w
t0
O
V
'
00
V
41
(0
0
0
,
M
O
m co
y O
r
co
~
M
~
M
V
O
t`
q1' II
N
I
N
N
I
N
V
:
M
V
(j
O
co
ao
Go
Of
N
Q
'
r
I
N
U)
O
V
O
OO
r
M
O
N
N
O
O
M
r
a
V
O
N
V
CO
V'i
Of
M
co
a;
o
O
E
N
00
C
r
m
O
o
Of
to
v
0
O
N
Cl
N
M
N
a
I
0
M
p_
CD
co
a
co
N
`0
O
m
U)
Q
7
0
M
O
r
r
N
b
r--
M
r
i
0
w
to
co
N
V
a
e~
i
'
C
N
CO_
1
'
'
tO
Q
c-I
I
I
w
co
OO
N
0
O
O
N
0
•
'
'
r
0
0
Cl
'
O
O
I
C
M
N
O
O
CO
'
0
1
M
O
C O
7
M
ao
N
N
N
~
M
co
I
tD
co
I
OD
V
t0
N
I
OI
`
O
LL
w
w
m
O
r
N
E
c
w
C
m
N
c
>
LLl
4)
d
m
m
m
m
O
w
O
m
w
7
'
CR'
d
E
w
C
W
N
w
Z
m
x
W
M
>
_
O
C
7
LL
lL
c
w
N
_
c
m
a
W
O
.
+
W
w
;
v
~
L
®
y
>
7
C
(y
7
U
Q'
L
U
m
C
O
w
7
C
m~
'
O
U
~
m
C
•
Cd
O
U
m
rn
E
~
c
tl
m
U
C
C
w
m
V
o
m
m
m
to
c
O
A
x
W
m
~
~
.
`
U.
0)
E
7
X
m
m
o
U
(i
V
4
m
o
06
m
e
to
y
w
a
c
c
J.
m
4
c
m
0
m
a
m
LL
t
w
z
c
rn
LL
m
t-
E
Q)
m
U
c
W
c
a
o
rn
'a
m
y
c
7
a1
0
5
0
'
~
°
O
,
m
V
c
v~
Z
w
m
E
(
01
ali
t
rn
>
m
°
o
E
c
c
d
N
m
-
2
c
c
w
ti
<q
w
y
°o
_
m
c
m
O
m
W
m
t
r-
U)
m
o
X
o
L)
n
>
-
5
-
M
o
m
m
a
2
m
U
o
r
.
L
a
c
C9
~
~
a
~
m
F-
c
LL
O
1-
0
~
O
m
w
5
0
t-
Z
Z
10
U
Deschutes County - Fair and Expo Center
YTD-Budget Basis
Statement of Financial Operating Data
Three Months Ended September 30, 2009
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)
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
$ 75,000 $ 42,232 $ (32,768) 100% 56% $ 75,000 $ 42,232 $ (32,768)
12,000
-
(12,000)
25%
0%
12,000
-
(12,000)
668
1,015
347
25%
25%
4,000
4,348
348
575
124
(451)
25%
5%
2,300
1,849
(451)
300
-
(300)
25%
0%
1,200
900
(300)
46,200
37,583
(8,617)
25%
7%
540,000
531,383
(8,617)
500
241
(259)
25%
12%
2,000
1,741
(259)
-
-
-
25%
0%
58,000
58,000
-
2,000
-
(2,000)
25%
0%
7,000
5,000
(2,000)
-
1,170
1,170
25%
3%
45,000
46,170
1,170
4,500
3,800
(700)
25%
2%
235,000
234,300
(700)
3,420
11,000
7,580
25%
13%
86,420
86,420
-
-
-
-
25%
0%
45,000
45,000
-
70,163
54,934
(15,229)
25%
5%
1,037,920
1,015,111
(22,809)
135,171
135,171
-
25%
27%
498,105
388,101
(110,004)
280,334
232,337
(47,997)
25%
14%
1,611,025
1,445,444
(165,581)
Exp.
206,172 194,060 12,112 25%
132,831 97,316 35,515 25%
- - - 25%
- 25%
- 25%
- 25%
339,003 291,376 47,627 25%
(58,669) (59,039) (370)
Accrued Revenue (Accounts Receivable):
Current Month Events 3,800
Prior Months 565
Total Accounts Receivable 4,365
24%
824,769
812,634
12,135
18%
531,604
522,033
9,571
0%
116,188
116,188
-
0%
100
-
100
0%
16,412
16,412
-
n/a
121,952
-
121,952
18%
1,611,025
1,467,267
143,758
-
(21,824)
(21,824)
Deposits Received for Future Events:
2010:
October
28,970
November
4,450
December
1,205
January
100
February
420
March
490
April
4,300
May
3,260
June
1,000
FY 2011
36,090
FY 2012 & Beyond
5,450
TOTAL
85,735
_ Deschutes County Fair - Fund 619
Revenues and Expenses
FAIR 2009 - July 29 to August 1 2009
Fiscal Year 2010
REVENUES
Gate Receipts
Carnival
Commercial Exhibitors:
Outside
Inside
Food
Livestock Entry Fees
RN Camping/Horse Stall Rental
Concessions:
Food
Fair Sponsorship:
Rodeo
On-ground Stages
Day
Golf Carts
Food Court
Concert (a)
Presenting Sponsors
Barn Sponsors
Parade Sponsors
Transfer In-General Fund
T-Shirts
Donations
State Grant (b)
Interest
TOTAL REVENUES
EXPENSES
Personnel
Materials and Services
Contingency
TOTAL EXPENSES
Net Fair - 2009
Transfer to Fund 618
Retained in Annual Fair Fund
Beg Net Working Capital
Ending Balance
Actual -
Through
FY 2010
September
Additional
Projected
% of
Budget
30, 2009
Estimated
Total
Budget
Variance
400,000 284,806 - 284,806 71% (115,194)
154,000 127,997 - 127,997 83% (26,003)
70,000
84,395
- 84,395
121%
38,000
42,700
- 42,700
112%
12,000
13,900
- 13,900
116%
4,000
4,951 -
4,951
124%
17,000
18,102 -
18,102
106%
146,850
112,931 -
112,931
77%
23,000
19,350
-
19,350
13,000
8,000
-
8,000
8,000
5,000
-
5,000
2,500
4,125
-
4,125
3,000
3,000
-
3,000
30,000
5,000
25,000
30,000
12,000
12,000
-
12,000
6,000
3,400
-
3,400
-
4,800
-
4,800
5,000
5,000
-
5,000
3,500
3,725
-
3,725
-
1,229
-
1,229
25,000
-
42,200
42,200
2,000
570
700
1,270
974,850
764,981
67,900
832,881
14,395
4,700
1,900
951
1,102
(33,919)
84%
(3,650)
62%
(5,000)
63%
(3,000)
165%
1,625
100%
-
100%
-
100%
-
57%
(2,600)
N/A
4,800
100%
-
106%
225
N/A
1,229
169%
17,200
63%
730
85%
141,969
178,128
138,125
44,424
182,549
102%
(4,421)
623,444
558,324
29,882
588,206
94%
35,238
31,157
-
-
-
0%
31,157
832,729
696,449
74,306
770,755
93%
61,974
142,121
68,532
(6,406)
62,126
(79,995)
197,421
-
87,417
87,417
110,004
(55,300)
68,532
(93,823)
(25,291)
30,009
55,300
25,291
-
25,291
-
-
93,823
93,823
0.00
(0)
(a) Combined Communications payment due on or before December 31, 2009.
(b) Per Oregon Fairs Association
O
O
d'
Ll rn
v O
U O
N
w O O
O d M
U ca m
au)i m aEi
~U a
Q) O
a ~
a) O
w.
U
O
O
a)
0
N
W
U
0
N
w
w
d~
N d co
O CO
M
d' O
V*
O
O
LO
O
O)
1~ M c- O ' Cfl '
C l!
O
O
to
O
Cf
Oo SO
v
O
00
E
q
q
*
O
C)
C
C
~
O
L
o
U
1
~
CO N
Cl)
d'
N
N
d' O
.
It COMOd -OOMOO
N ON
O
N
O
a) O
V
C)
CO lA ~tO r-m O O w O
N A M O O O O CO N
O
CO
O O
M O
O
Cl)
O
CO
a)
O
In
C)
~ IT
I 0)
C T-: CO r
C O
~
r a
t
C SF
d'
N
M
~ LO
r M
O
r-
co N
M
0
ce)
N
d
CO
CO
In
r
OO
OO
O
O
co (D CD '41 OO CD
MO OIl- 00 Co
co
(D
N
M
N
M
O
O
O(::
O
Ollz ' Oa) ' OO ' N
CO
M
M
O
'
CD O
~
O
M
(D NT C) LO O~ r
O M O
a)
co
O
O
O
O
O
N
M
^
co co W
O
In
(fl
I-- 0)
CO
'rt N CM N CO CO M CO O
N N
r
In
rt O
O
CO M It O qt CO r- O CO v
N
a)
O
N
M
O O
V
N O M"tt Nr IrCO a)
I,-
M
co
r
m
.~i C
'R
CO O O M ~ CD CO
O
r
co
N
M
N V)
O
m
M
O
O
O
co
M
LA
CO
CO
d
O M
CO
r
r
O
CO
CO
L
a)
a)
v
v
co
co
O
O
cai
Cri
a
I- O
CO
V d' M N CO i- M M Cfl
-
r
't O
O
a)O~O't wNOmd'
N
0)
a)
r
00
14
OCD M'R Nc t - CM
N
N
N
O
C)
O
V)
O O O
ctLO r Cb
O
(n
N:
Cd
C
O
N
M
N
~f
CO
cn
O
CO
to
M
Cfl
co
Ls
N
N
O
U
a)
U
N
(0
_
~
U
U
•
O
~
N
N O d
(1) fn
N M
O
= O U ' Ojf
O
= w
7
N M > M
a)
E
=
(n j N N m 06 7 jp
(n
L
CT t a~+
cn
`
_ O -
Q
D
a)
3
a)
0
= a) U E o) U ~p
ID C: -
06
g
'
.
a
m O
E V
C:
ayi
c c CL
C N N rn c
o
c
c 4) :3
d a3 ` m m cu a()) -a Z -C
o F-°
w
0
x M<UJF-a5 ~w¢d0
00
m ~
0
U
z
U) to
U U
i
a) a)
(n U)
06 06
A U
(Q (C
M cu
Z> 2
co
O
O
CB
.Q
C6
U
CD t
00 o ,
0)
C
~
O
M
O
c
o
O
d
M
N
O
LO
O
00
O
MI -IT
00
Cn (1)
Z
c w
LL2m
: t 00
N
a U co
'EL Z E
ca Q a)
U U) a
~
U a Cn
Z r
00
CL g
W 0
Co
au
0) Z
a) W
O
O CO
CO
CO ' r
O
It -
LO
M
(
ooc N
O
N
D
(
N Cfl
O
N
1-
CO ~
0)
0)
M
co
COO
Cfl
- ON
O
NO
N
(
N
C
O~
N
r- M
LO
N
,qT
Cn
O
U')
m
U
ti X
U a)
O
(D
O
U) 0
C O-
O X
4 w
a) ~
0 4)
aw
y N
U U
a) 0
U
Q Q
U U
J J
U
O
L
Q
FO-•
'IT I It
E
n >
r ,
C (n
O
cn
Q U
U
G Q O
U
"J m
C `
a) U c
ncU
U
C
N
a)
7
U
7
U)
0) C a
`
W N c~
LL Cn W
O
C
a)
E
E
E
0
U
06
N
a)
U
C
E
7
U
C
W
FO-
ti
co OO
O
-a N
c
O
OUM
O
O N
d n
Cc 0)
U 0
L
rLL
0)
N
W
U
O
N
W
O Ln O co M It O 't O O ti
r- -O ' "T I r~ OOO It 01 CO
M M CNF v v M (M o O in tMo
V-- V N O O
r r v ~ r
co NCD co OOoP- Oti'IT OOco O'IT LO CD LO O 0) Ol
1(0 O M O O ti O O CO O O O O N M O co O w ti
t*- N O O O I r O c ~ 0 0 qt 0 LO 0 LO I'll M co
C'') C \F I: 1 C NT C NF ~ ty' ~ 1- C \f 00 r_ r~: M
N O CO 0 N Ill N 00 M In m 00 O N CO
N N 0 O
M M N N N r
ONON 000 Orl_ OO OLO t` r- N
O CO O CO O O O co O O O co ~ P- Co
O N O N OI;t ' C) 0 0 ' O CO IO ' CO N
LO rl- COCOco Ntn NN tn- ACA m 0) 0~0
N
M LO LO
M M C7 M M
to CO N It O r- O In NT O CO 00 'I 00 LO LO M Ol
r 0)
d COf` - r- Ind (000 CD M M
r-t`I O-1 -M~ - COCnd'M -T LO LO ' 00 LO
co co 40 (N U) C\F 'i ~ (0 ~Nco ~ ~ LO N P-
r LO ti
NM M M M N N N
0) LO In co co
r
ca M O ti ti
N C IL d' ~ o 0
N
O M M
lO Ill to r T-
O O ~ T-
N N N N
CO CON It co M fl- OlO't 00000It co m m
r` c as I- Mr- r- I'- COvCOOCOO U') CO co NM
~ ' r`I In CA IM- -CO LO *MO O O ' Ill
co (o Q to N ~M NN ~Nco 0 ci O O O Q O
M CA (A O co
cYS M N IV co
rn
N
O
U
CU N
N N V
U
U Z N N to CO
0 0) rn fn 'U CU O N
O -0 > w
c U) N j N N 06 3 fLC ~ N O d
(D co E
CU 3 c a) U O U 0 O CL U
(D C
d
o(D d D od C:
Q
ai rnClc cd `n 0)o- 03 V CD
75 in Z n c c C 3 m c L :4 N c W
0-
FO
0 0 O x m<W Ind C CL L QdO- QO FO - O :a
ca U- cl- W UUO U 0 Gl
1- Z
z
w
v ~ 00
C
O Ce)
L
Z E
o Q
CL U) C
-F
.a z
cu 9 0)
:3
U M 0
W L
U
z
w
c
O
,U U
U
`
O N
Ca
U
N N
cu m
L
L
m CD
yr
m
C6
c
C
G C
N 00
O
LO O O C0
U
co
00
04
0
000
0)
CU
:3
1'-
E
N
ti
r
LO
L
A
C LO
0]
r.
C
N
r-
r.- O
M
72
ca
rl-
r- 00
LO
LO
r O
ce)
CO
CL
CA
O
C
O
N
0)
O
M
O
O
E
a
C
~t O
00
)
"T
N 0 0 L
_
°
rn
~
E
c
0
0C
cOO
~L
oO
O
L6 P-
N
NOOK
ti
E
NS
co
O
MA
0
Q
~t
N
N
U
o
N
Q
(D
E
U
N X
O
~ N
U
N (p
0
N L
O
j N t0
O O O
Q U
U
0 X
C Q 0 O
U
L
N
O E
U 7
c
° m
n. 00) - 0
E
CL w
U) U) S U
E
E
O
U
U
c
06
N
m
N
a>
O
L
U
C=
CU
N N
U
,L+
>
U U
:E-
N
a) a)
C
O) - C7
U
-C C
L
C C
C
L
Q
N O
c N
w
Q Q
N
N b (v N
E
~
c
ca
O
N
'
O
J J
F-
~
U- (n 2 w
Deschutes County
Bethlehem Inn (Fund 128)
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et
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
-
(2,766,469)
8%
0%
2,766,469
-
(2,766,469)
Total Revenues
2,766,469
-
(2,766,469)
8%
0%
2,766,469
.
(2,766,469)
TOTAL RESOURCES
100,000
(2,689,172)
(2,789,172)
8%
-2689%
100,000
(2,689,172)
(2,789,172)
REQUIREMENTS:
Exp.
Expenditures
Debt Service (Negative Int Rev)
100,000
11,539
88,461
8%
12%
b) 100,000
43,000
57,000
TOTAL REQUIREMENTS
100,000
11,539
88,461
8%
12%
100,000
43,000
57,000
NET (Resources - Requirements)
-
(2,700,711)
(2,700,711
(2,732,172)
(2,732,172)
a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget.
b) September interest expense was $3,508.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2010
I I
I
Jul Aug
Sep YTD Total
Tammy Baney
Conf/Sem & Educ/Training - -
- -
Travel Meals
Accommodations
Airfare
I
-
Mileage reimbursement -
256 86
342
Ground Transport
Total Baney
256 86
342
Dennis Luke
Conf/Sem & Educ/Training
Travel Meals -
25
-
25
Accommodations -
77
_
77
Airfare _
-
Mileage reimbursement -
329
85
415
Ground Transport
Total Luke - 432
85 5517
Alan Unger
Conf/Sem & Educ/Training
Travel Meals
Accommodations
Airfare
Mileage reimbursement
Ground Transport
Total Unger - j
-
-
-
Total - BOCC Department
Conf/Sem & Educ/Training
Travel Meals -
25
-
25
Accommodations -
77
-
77
Airfare -
-
-
-
Mileage Reimbursement
585
172
757
Ground Transport
-
-
-
-
Total - BOCC Department
687
172
859
FY 2010 Budget !
22,750
I
~
Percent Expended
3.8%
10/1/2009
RV Park (Fund 601)
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection II
Variance
RESOURCES
:
Beg. Net Working Capital
$ 50,000
$ 2,431
$ (47,569)
100%
n/a
$ 50,000
$ 2,431
$ (47,569)
Revenues
RV Park Fees < 31 Days
39,645
38,764
(881)
25%
24% a)
158,580
158,580
-
RV Park Fees > 30 Days
-
4,550
4,550
25%
n/a a)
-
4,550
4,550
Washer / Dryer
200
533
333
25%
67%
800
800
-
Vending Machines
75
266
191
25%
89%
300
300
-
Interest on Investments
-
88
88
25%
n/a
-
250
250
Cancellation Fees
-
602
602
25%
n/a
-
602
602
Total Revenues
39,920
44,804
4,884
25%
28%
159,680
165,082
5,402
Transfers In-Fund 130
47,500
-
(47,500)
25%
0%
190,000
190,000
-
TOTAL RESOURCES
137,420
47,235
(90,185)
25%
12%
399,680
357,513
(42,167)
REQUIREMENTS:
Exp.
Expenditures
Materials & Services
17,190
23,793
(6,603)
25%
35%
68,760
68,760
-
Debt Service
60,643
-
60,643
25%
0%
242,571
242,571
-
Contingency
22,087
-
22,087
25%
n/a
88,349
-
88,349
TOTAL REQUIREMENTS
99,920
23,793
76,127
25%
6%
399,680
311,331
88,349
NET (Resources - Requirements)
37,500
23,442
(14,058)
-
46,182
46,182
a) Approximately 1,354 space rentals. ( $38,764+ $4,550) / $32 = 1,354)
U
P- 0 0
C
co
C)
co
(a
CA Co
co
CL
0 0o
ri
N
r
U
U
0
N
^
~ N
~~0p0
t~
V O
CU a)
M
Cc
t- MN
M
0
it
LL
covert
v
`
r- LO
O
(
a N
o0 'IT O
M
L O
N C O
M
> LL
d
0 0 0 0 0 0 0
U
O
0 0 0 0 0 0
0 a0ICT qT oO00 MU')~CV d M
ca
(0 00 0) 00 (0 ~t LO) N LO P- (O O
CL
d'OOOLci~OOOVr,: CONr,.:
N
O
U
N
}
o
r
O
LL
N
^
C
0
0
U-
0) U)
O 0)
N
O 00 It N c- Cl) O 'q 0 0) 0 0
C:
.
.
ca
`
N CO Ucam
00U) 000) Lf) ~MNNN
vMN~ ~-NN[I-r~
7
m 00
CL C d r
N
U) O
LL
a)
Y
N
O
(La
C
LL
LL
CL
O
>
O O
NIt CO IT N(0000000qt N00N
'
Ln'~T 0) TC
M-CD NC0It CD MM
U C
N N
(D
MIt OT- CD It CO r- TCOOOO
0
d
L6 C6 (d 1 ~ ~ t- c$ I.
C
:3
0
> U-
r r N 00
O
U
C
(a E
CD 7
cn
0 0
C
U
U
0 0 0 \0 \0 0 0 0 0 0 0 0 0 0 0
CO
C
O
O
N0N--'tiMCOOOtiMCn01
aj~t
L
N r
O
~C 0'I 0LO gMr-0
:
II (a
U
y
OL
I~tOOOC c1-
6 N 61-:66
~
N 0
O
CI)
a)
W
CD
O
MN e-~
_C
M
-
0
U
0
U9,
U
ca
N
o
o
U) O U
O
LL
O.
U O
rn
le
O
C0 O O t* r to M N r- N 0) CO
m 06
C.~ U
-
O U P C7
N 00 N~ M r M 00 M M C0O co ~
U
0 a ~a~_
M
N~ a)
N> U
c a) j
LL 0
(a a -0
*k LL
p Cl)
CA
O ~ M 00 (fl N O C0 d' C0 It CO 0)
0 N o
CO a)
MME t00CO 00LO 04CO ~00M
00 U00
LL
O O M N r- It O Co co 0) It O
M Q nj 0)
O 00 00 N ~ 1 C \i 1- C6I
II U ~ co
M N N
~r-
06
N
p
cc
LC)
CO
U)
Q.
d4
Ln
~ ~
M U CA
N
N E C
a) =3 m
a)
r
E N 7
j
Q
U
U)
O
4)
U 00 'a 0 ca
>
to
d 0 O Ca
U)
-0.0
0 0
Lf)
rn (D
r U
U
(a
in
co
v
0 0 C m Co am C:
3 =
om
w
Q
a)i
-5 QwOZ0~LLMQ2-,>-
Building Services - 620
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
$ 272,938
$ 439,838
$ 166,900
Revenues
Cleaning/Maintenance
17,769
17,011
(758)
Utility Reimbursement
2,250
895
(1,355)
Facilities Charge to State
34,116
27,000
(7,116)
Miscellaneous
-
16
16
Interest on Investments
2,500
2,241
(259)
Interfund Contract
3,600
-
(3,600)
Building Svcs Indirect Chgs
436,322
436,322
-
Total Revenues
496,557
483,484
(13,073)
Transfers In
55,711
46,711
(9,000)
TOTAL RESOURCES
825,206
970,033
144,827
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
100%
n/a
$ 272,938
$ 439,838 $ 166,900
25%
24%
71,075
71,075
25%
10%
9,000
9,000 -
25%
20%
136,464
136,464 -
25%
n/a
-
- -
25%
22%
10,000
10,000 -
25%
n/a
14,400
14,400 -
25%
25%
1,745,275
1,745,275 -
25%
24%
1,986,214
1,986,214 -
25%
21%
222,844
222,844 -
25%
39%
2,481,996
2,648,896 166,900
Exp.
388,579 366,874
21,705
25%
24%
1,554,315 1,554,315 -
174,920 126,430
48,490
25%
18%
699,681 699,681 -
9,000 -
9,000
25%
0%
36,000 36,000 -
48,000 -
48,000
25%
0%
192,000 - 192,000
620,499 493,304 127,195 25% 20%
2,481,996 2,289,996 192,000
NET (Resources - Requirements) 204,707 476,729 272,022 - 358,900 358,900
Admin Services - 625
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
$ 120,000
$ 117,586 $
(2,414)
100%
Revenues
Miscellaneous
-
12
12
25%
Interest on Investments
1,000
634
(366)
25%
Admin Dept Indirect Chgs
173,074
173,081
8
25%
Total Revenues
174,074
173,728
(346)
25%
Transfers In-General Fund
10,000
10,000
-
25%
TOTAL RESOURCES
304,074
301,314
(2,760)
25%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
n/a
$ 120,000
$ 117,586 $ (2,414)
n/a
-
- -
16%
4,000
4,000 -
25%
692,295
692,295 -
25%
696,295
696,295 -
25%
40,000
40,000 -
35%
856,295
853,881 (2,414)
Exp.
159,759 157,635
2,124
25%
25%
639,036 639,036 -
37,486 22,642
14,844
25%
15%
149,943 149,943 -
25 -
25
25%
0%
100 - 100
16,804 -
16,804
25%
0%
67,216 - 67,216
214,074 180,277
33,797
25%
21%
856,295 788,979 67,316
NET (Resources - Requirements) 90,000 121,037 31,037 - 64,902 64,902
BOCC - 628
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
Sale Map Photo or Copies
Interest on Investments
Admin Dept Indirect Chgs
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
Year to Date Year End
Budget Actual Variance FY % Coll. % Budge t Projection Variance
$ 50,000 $ 68,511 $ 18,511 100% n/a
25
20
(5)
25%
n/a
125
411
286
25%
n/a
143,354
143,354
0
25%
25%
193,504
212,296
18,792
25%
34%
$ 50,000 $ 68,511 $ 18,511
100 100 -
500 500 -
573,417 573,417 -
624,017 642,528 18,511
Exp.
122,539 121,978
561
25%
25%
490,156 490,156 -
18,562 11,520
7,042
25%
16%
74,247 74,247 -
25 -
25
25%
0%
100 - 100
14,879 -
14,879
25%
0%
59,514 - 59,514
156,005 133,497 22,508 25% 21%
624,017 564,403 59,614
NET (Resources - Requirements) 37,499 78,798 41,299
78,125 78,125
Finance - 630
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 740,000
$ 777,692
$ 37,692
100%
n/a
$ 740,000
$ 777,692
$ 37,692
Revenues
Investment Fee
23,750
25,289
1,539
25%
27%
95,000
95,000
-
Interest on Investments
4,500
3,160
(1,340)
25%
18%
18,000
18,000
-
Interfund Contracts
7,000
7,002
2
25%
25%
28,000
28,000
-
Administrative Fee
3,000
3,000
-
25%
25%
12,000
12,000
-
Finance Dept Indirect Chgs
179,106
179,109
4
25%
25%
716,422
716,422
-
Total Revenues
217,356
217,560
205
25%
25%
869,422
869,422
-
TOTAL RESOURCES
957,356
995,252
37,897
25%
62%
1,609,422
1,647,114
37,692
REQUIREMENTS:
Exp.
Expenditures
Personal Services
205,603
210,693
(5,091)
25%
26%
822,411
822,411
-
Materials and Services
88,622
103,843
(15,221)
25%
29%
354,486
354,486
-
Capital Outlay
20,000
-
20,000
25%
0%
80,000
-
80,000
Contingency
88,131
-
88,131
25%
0%
352,525
-
352,525
TOTAL REQUIREMENTS 402,356 314,536 87,819 25% 20%
NET (Resources - Requirements) 555,000 680,716 125,716
1,609,422 1,176,897 432,525
- 470,217 470,217
Legal-640
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$ 87,000
$ 102,125 $
15,125
100%
n/a
Revenues
Sale Map Photo or Copies
75
-
(75)
25%
0%
Miscellaneous
750
-
(750)
25%
0%
Interest on Investments
375
571
196
25%
38%
Interfund Contract
500
-
(500)
25%
0%
Legal Counsel Indirect Chgs
174,977
174,977
1
25%
25%
Total Revenues
176,677
175,548
(1,128)
TOTAL RESOURCES
263,677 277,674
13,997 25% 35%
Exp.
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
168,759 164,649
4,110
25%
24%
13,563 6,058
7,505
25%
11%
25 -
25
25%
0%
16,080 -
16,080
25%
0%
198,427 170,706 27,720 25% 22%
NET (Resources - Requirements) 65,250 106,967 41,717
$ 87,000 $ 102,125 $ 15,125
300
300 -
3,000
3,000 -
1,500
1,500 -
2,000
2,000 -
699,907
699,907 -
706,707 706,707
793,707 808,832 15,125
675,034 675,034 -
54,252 54,252 -
100 - 100
64,321 - 64,321
793,707 729,286 64,421
79,546 79,546
Personnel - 650
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 360,525
$ 423,562
$ 63,037
100%
nla
$ 360,525
$ 423,562
$ 63,037
Revenues
Miscellaneous
125
786
661
25%
157%
500
786
286
Interest on Investments
1,000
1,912
912
25%
48%
4,000
4,000
-
Personnel Indirect Chgs
158,235
158,240
4
25%
25%
632,941
632,941
-
Total Revenues
159,360
160,938
1,578
25%
25%
637,441
637,727
286
TOTAL RESOURCES
519,885 584,500 64,615
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
997,966 1,061,289 63,323
Exp.
145,965
139,671
6,293
25%
24%
84,002
32,264
51,737
25%
10%
25
-
25
25%
0%
19,500
-
19,500
25%
0%
249,492
171,936
77,556
25%
17%
270,394
412,564
142,171
583,859
583,859
-
336,007
336,007
-
100
-
100
78,000
-
78,000
997,966
919,866
78,100
-
141,423
141,423
Information Tech - 660
Statement of Financial Operating Data
Three Months Ended September 30, 2009
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 437,214 $
538,155
$ 100,941
100%
n/a
$ 437,214
$ 538,155
$ 100,941
Revenues
City of Redmond
-
-
-
25%
n/a
-
-
-
Miscellaneous
250
-
(250)
25%
0%
1,000
1,000
-
Interest on Investments
3,000
2,487
(513)
25%
21%
12,000
12,000
-
I T Indirect Chgs
477,519
477,516
(3)
25%
25%
1,910,076
1,910,076
-
Total Revenue
480,769
480,003
(766)
25%
25%
1,923,076
1,923,076
-
Transfers In-General Fund
16,250
16,250
-
25%
25%
65,001
65,001
-
TOTAL RESOURCES
934,233
1,034,408
100,175
25%
43%
2,425,291
2,526,232
100,941
REQUIREMENTS:
Exp.
Expenditures
Personal Services
432,395
427,417
4,978
25%
25%
1,729,580
1,729,580
-
Materials and Services
125,557
79,906
45,651
25%
16%
502,227
502,227
-
Capital Outlay
25
-
25
25%
0%
100
-
100
Contingency
48,346
-
48,346
25%
0%
193,384
-
193,384
TOTAL REQUIREMENTS 606,323 507,323 99,000 25% 21%
NET (Resources - Requirements) 327,910 527,085 199,175
2,425,291 2,231,807 193,484
294,425 294,425
IT Reserve - 661
Statement of Financial Operating Data
Three Months Ended September 30, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
Interest
IT Reserve Charges
Total Revenue
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
586,938 609,691 22,753
$ 350,938 $
373,691 $
22,753
100% n/a
$ 350,938
$ 373,691 $ 22,753
500
1,737
1,237
25% 87%
2,000
2,000 -
58,500
58,502
2
25% 25%
234,000
234,000 -
59,000
60,239
1,239
25% 26%
236,000
236,000 -
409,938 433,930 23,992 25% 74%
Exp.
Materials and Services
94,998
- 94,998
25%
0%
Capital Outlay
31,500
- 31,500
25%
0%
Contingency
20,237
- 20,237
25%
0%
TOTAL REQUIREMENTS
146,735
- 146,735
25%
0%
NET (Resources - Requirements)
263,204
433,930 170,726
379,990
379,990 -
126,000
126,000 -
80,948
- 80,948
586,938
505,990 80,948
-
103,701 103,701
MOODY'S
INVESTORS SERVICE
Stress Points for Local Government Ratings
2009 NWGFI Conference
Matt Jones, Sr. Vice President October 27, 2009
Outline
1. Highlights of Moody's Local Government Sector Outlook
2. Determining Local Government Ratings: The Four Factors
3. Rating Stress: Key Triggers and How Oregon LGs Measures Up
4. Some Comments on Global Scale Ratings
MIM'e
INVESTORS SERVICE NWOFI=0011 2
Local Government Sector Outlook
MOODY $ NWGF12009 3
INVESTORS SERVICE
April 2009 - Negative Outlook Assigned to Local
Government Sector
Reflects significant fiscal challenges local governments face as a result of:
» Housing market collapse
» Dislocations in financial markets
» Recession that is broader and deeper than any recent downturn
» Job losses
» Contracting consumer spending
» Tight credit conditions
MOODY 'S NWGFI 2000 4
INVESTORS SERVICE
2
Determining General Credit Ratings for Local
Governments: The Four Factors
MWDVS
INVESTORS SERVICE NWOF12009 5
The Four Factors
➢Economy/Tax Base
Size, diversity, concentration
r Wealth measures
➢ Jobs, unemployment
➢Finances
r Reserve levels, composition
'r Revenue structure
Y Spending flexibility
)=Management
Policies, adherence to policies
'r Track record
>Debt
Level, structure, borrowing plans
Exposure to variable rate, swaps
MOODY's
INVESTORS SERVICE NWOF12009 6
3
Rating Stress Factors: Key Triggers
MOODY'S NWGF12009 7
INVESTORS SERVICE
Overview of Triggers
>Economic Vulnerability
>Revenue Volatility
>Lack of Expenditure Flexibility
>Strength of Management
>Exposure to Credit Market Volatility
MOODY'S NWOF12002 8
INVESTORS SERVICE
Economic Vulnerability
>Taxpayer, industry or employer concentration
> Metrics: % of AV, % of labor force
➢ Strong: less than 5%
Weak: more than 15%
,-Rising unemployment
> Metric: YOY change in rate
> Strong: stable rate below state and nation
> Weak: rising faster than state and nation
>Declining tax base
'v Metric: YOY change in RMV
> Strong: still growing, albeit slower
> Weak: dramatic declines, prolonged downturn
MOODY'S NWGFI 2009 9
INVESTORS SERVICE
Revenue Volatility
>Exposure to economically-sensitive revenues
> Metric: % of operating revenues
'r Strong: less than 25%
> Weak: more than 50%
>Urnited property tax flexibility
> Strong: unlimited operating levy (rate, amount)
> Weak: capped rate and subject to declining AV
>Increasing property tax delinquencies
Strong: current collections exceed 95% of levy
^r Weak: below 85%
;=Vulnerability to state aid cuts
i- Metric: % of operating revenues
> Strong: state aid less that 25% of revenues
> Weak: above 50%
MWTD
INVESTORS SERVICE NWGFI 2009 10
5
Lack of Expenditure Flexibility
>Budget includes substantial level of mandated and/or fixed expenditures
> Metric: % of operating expenditures
Strong: Mandated/fixed expenditures (legally mandated services, debt service,
personnel costs covered by collective bargaining agreements, etc.) less than 50% of
expenditures
> Weak: more than 75% of expenditures
> Mitigant: reserves to fund over-expenditure; ability to pass along state cuts (no level of
service mandate)
MOODY'S NWGF12009 11
INVESTORS SERVICE
Strength of Management
>Unwillingness/inability to make mid-year budget adjustments
> Strong: timely adjustments; contingency plans; history of budget balancing efforts;
modest use of reserves with rapid replenishment in subsequent years
> Weak: non-responsive on budget adjustments; reliance on reserves or other one-time
solutions
>Conservative budgeting of economically-sensitive revenues
> Strong: projections in line with economic forecast; regular monitoring
> Weak: aggressive assumptions that rely on near-term economic improvement not
supported by forecasts
>Weak understanding of credit market risks
> Strong: frequent monitoring of VRDO/swap exposure; conservative debt service
budgeting
> Weak: lack of understanding of variable rate debt portfolio; narrow budgeting of debt
service
MOODY'S NWGFI 2009 12
INVESTORS SERVICE
6
Exposure to Credit Market Volatility
➢Substantial VRDO exposure
Strong: VRDOs less than 25% of total debt; reasonable term-out scenario depletes little reserves
Weak: VRDOs more than 40% of total debt; term-out depletes large share of liquid resources
sLarge and/or complex swap portfolio
r Strong: notional amount of swaps less than total VRDO debt; termination manageable
v Weak: notional amount of swaps greater than VRDO debt; termination depletes liquidity
➢Reliance on market access for cash flow borrowing
>Reliance on market access for deficit financing
>Exposure to market volatility that may disrupt BAN takeout
MOODY'S NWGFI2009 13
INVESTORS SERVICE
Global Scale Ratings
MOODY'S
INVESTORS SERVICE NWGFI2009 14
7
Significant Changes in Municipal Market over Past Year and a Half
>Downgrades of Bond Insurers
Increased market demand for underlying ratings
>Market Disruption Creates Ongoing Uncertainty
`r Market access has been impaired
Failed Public Bond/Note Sales
Variable Rate Demand Obligations purchased by banks due to lack of buyers
Y Higher cost of borrowing
➢Severe Economic Downturn
State and local budgets will continue to be strained
MOODY'S NWGFI 2999 15
INVESTORS SERVICE
Moody's Responses to Changes
>Intensify surveillance of Public Finance ratings to ensure they capture impact of
current credit and liquidity risks
>Take rating actions when appropriate
>Publish research in each sector on the impact of the municipal credit
environment
➢Recalibration of municipal ratings to the global scale paused in light of market
disruption
MOODY 'S NWOFI2009 16
INVESTORS SERVICE
8
Municipal Bonds Have Been Calibrated on a Different Scale Since
the Early 1900's
"vThe municipal scale has historically been well understood by the market
➢In the late 1990's a number of "cross-over" investors became more active in the
municipal market
➢For nearly a decade, Moody's has been surveying the market to understand if
recalibrating the municipal scale to the global scale would be beneficial to the
market
>Until 2008, market surveys supported the maintenance of the municipal scale
MOODY'S NWGFI 2009 17
INVESTORS SERVICE
Changes in Market Conditions Shifted Market Sentiment Toward
Recalibration in Early 2008
>Market events in 2008 and a shift in market sentiment prompted a
reconsideration of the use of a differently calibrated rating scale for municipals
➢Moody's proposed recalibration of the municipal scale to the global scale for
municipals in the Spring of 2008
>Market survey conducted to determine how best to meet the needs of the
market and feedback was generally consistent:
current market conditions have resulted in a greater need for rating
comparability between muni and non-muni securities
a single scale is preferable to a dual scale system
transitioning municipal ratings to the global scale would provide useful
information
MOODY'S NWGFI 2009 18
INVESTORS SERVICE
9
Before the Pause: Overview of the Recalibration Plan
➢Recalibration of approximately 20,000+ outstanding public finance credits
-20,000 distinct issuer security pledges, over 70,000 individual sales and
approximately one million CUSIPS
➢AII public finance sectors to be considered in the recalibration
Governments, higher ed, infrastructure, health care, housing
:Result will be comparability of Moody's municipal ratings with ratings in other
sectors such as sovereign, sub-sovereign, corporate and financial institutions
MOODY 'S NWGF12009 19
INVESTORS SERVICE
Current Status of Moody's Municipal Rating Recalibration
>Moody's remains committed to the goal of recalibrating US public finance
ratings so that they are comparable to ratings in other sectors
>Pause in planned migration prompted by stressed conditions in the credit
markets
>Public announcement will be made when a determination has been made
about when to begin the recalibration
MOODY 'S NWGFI2009 20
INVESTORS SERVICE
10
Surveillance of Public Finance Ratings
>Surveillance of issuers continues to be a priority
> Further assurance of currency of ratings in a dynamic credit environment
incorporating current critical credit and liquidity issues- market access,
counterparty risk, VRDO risk, declining revenues
>Significant analyst time and additional tools have been dedicated to
surveillance
MOODY'S NWGFI 2009 21
INVESTORS SERVICE
Current Ratings Assigned on Municipal Scale
>Until recalibration is complete, we will continue to utilize the municipal scale to
analyze US PFG credits and take rating actions
>Expectation of some weakness in municipal credits due to economic downturn
and market uncertainty
>Likelihood of downgrades higher than in past recessions due to severity of
credit conditions
>Most municipalities are expected to manage the challenges successfully
MOODY'S NWGFI 2009 22
INVESTORS SERVICE
11
Enhance Market Communications through Research on Municipal
Credit Environment
>Develop analytic frameworks by sector which identify potential triggers for
rating changes
> Provide transparency about our future actions by publishing frameworks
>Keep market participants informed of developments on credit and liquidity
issues and impact on ratings
MOODY'S NWGF12009 23
INVESTORS SERVICE
MOODY'S moodys.com
INVESTORS SERVICE
MattJones
Senior Vice President
Moody's Investors Service
One Front Street, Suite 1900
San Francisco, CA 94111
415.274.1735 tat
mafthow.jones@moodys.com
12
2(Y.tg Moody. I-sors S-i- Ix. an- as 1-ensors and affiliates (oGleGt:ety. -MOODY S'j An rights resetsred. ALL INFORMATION CONTAINED HEREIN IS PROTECTED
BY COPYRIGHT I.AW AND NONE OF SUCH INFORMATION MAYBE COPIED OR OTHERWISE REPRODUCED. REPACKAGED, FURTHER TRANSMITTED. TRANSFERRED,
DISSEMINATED. REDISTRIBUTED OR RESOLD, OR STORED FOR SUBSEQUENT USE FOR ANY SUCH PURPOSE. IN WHOLE OR IN PART, IN ANY FORM OR MANNER OR
BY ANY MEANS WHATSOEVER. BY ANY PERSON WITHOU T MOODY'5 PRIOR Wa1i EN CON5ENT. All mfcrmafan contained hereto rv obtened by MOODYS faun sou
halkvad by A to be accurate aW re:,ble. Because of the posslbi ty of human or mechanical toot ae well as ocher fac!aa, tmwever, au infafmatior =ftload baron is pro, ded AS
IS' without wananty of any ldrd Under ro circumstances shat bIOCCY'S have any fa01'Gy to any Person or entity for (a) any lose or damage in A-. or in part caused by, resulting
loin. ar relaling to. any error (rregOgent or pti:etwlse) w other circumstanoe a cantmgency ".thin or oulslds the corttrM of MOODY' S or any or %duectars. oIf e'nployees or
connection wvth the pr--ant, cptMC:lan, contp;labon, analysis, Irlarpretat-, c>mmunrcation, ploh-lo, G do[, sly of any such 1fonnaban. a (b) any direct, Indire^_I,
special, consequential, compansatary G i -ot,l damages .:haYOe'rer IimlWirg tvhh0ut Iimttation, lost Frof:sj. seen If MOODY'S is aWised in advance of the p-L,ley of such
dansges, muly ng hom the use of or "Pllty to ose, any such Information The ratings. fir-sal reporting anzlysa, Projections, artd Ghat observations, if any, u- Wlbng part of
the In!onna"oo contained herein are, and must be coxtrued -y as, statements al opinion and not statements cl fact of r on-ndabona tp purchase, all or hold any securities
NO'AVARRANTY, EXPRESS OR IMPLIED. AS TO THE ACCURACY, TRI.ELINESS, COMPLETENESS, MERCHANTABILITY OR FITNESS FOR ANY'rARTIrULAR PURPOSE OF
ANY SUCH RATING OR OTHER OPINION OR INFORA TION IS GIVEN OR MADE BY MOODY S IN ANY FORM OR MANNER WHATSOEVER. Each ratlog or other opinion must
be weighed solely as one fac'ar In anY Inves';tnent Cx.^iswn made W c: on 6eha:} of any usaf of :hx infarmaban containetl hzrem, and each such user must aecertlnply make:k own
sLLitly an0 evaluation of each seariry znd of each issuer and gw.•an.or oF, and each proidar of creiit wppoR fG. taco sacurihy that tl may wnskla purchasing, ho:dinp pr seNing.
Maody's In'reNere 5errce, ix ('M15'1, a wMltyoH ed credit rating agency sutlsiC:ary a( fJxwtlye Capctatian f'MCOi. hereby discicses Ihm most issuers of de:^,t securities
lincit ling cerycrse and rnuniclpai bonds, dalxntures, notes and --cat paper) and preferred sock rated oy MIS hs:e, prior 0 asaanment .1 any ravh%; agreed to pay In MIS
appraisal antl faring aerv ice
a rarderod by d fees ranging tom St 530 to appraytmalety 92,SDJ,ODg. NCO and MIS a's0 mantain patties and p-edures to address the
rtWependance of MI"'a rmtop and 2fng processes. Informatron agzrtng ..,d afli':atians that may eval. between dirstats of!ACO and rated snbfas. and between ..Alas vAW
bent rafngs fan MIS and have .1. publicly reported to the SEC an ownership intares In MCO of mare roan 5%, is pasted annually et www.moodvs.com under the heading
Sharsrolder Relations - Corporate Geyer.^.ance - Daactor and Sharaho'de, Affiliation Poli.y'
MOODY'S NWGFI 2009 25
INVESTORS SERVICE
13
O
r
rn
O
O
N
O
O
Y'
O
O
N
=
A
O
■
L
T
M O
W
(D
A
1
O
O
V)
O
N
~
L
O
CO
L
Q~
O
N
L
CO
'L
O
L6
O
L
~
O
N
V
LO
O
O
d'
O
O
N
L
W
O
O
75
N
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
O
00
r-
(
L
'
M
N
su0i
4301103 JBGA aoiad
Date: October 29, 2009
To: Board of County Commissioners
From: Erik Kropp, Deputy County Administrator I
Re: Deschutes County Equal Employment Opportunity Plan
Many federal grants require recipients to adopt an Equal Employment Opportunity Plan (EEOP).
An EEOP includes a policy statement that the organization will provide equal employment
opportunity for all persons and prohibits discrimination in employment based on a protected
class.
The plan also compares the organization's workforce with the community labor statistics to
identify underutilization of females and minorities. The EEOP includes steps to address
underutilization of any identified categories.
Attached is Deschutes County's updated EEOP. Staff recommends Board approval of the
updated plan.
c: Dave Kanner, County Administrator
Debbie Legg, Personnel Services Manager
Deschutes County Equal Employment Opportunity Plan
Grant Title:
Grant Number:
Grantee Name:
Award Amount:
Address:
Deschutes County Contact Person:
Telephone Number:
Date and effective duration of EEOP:
Multiple Grants
Multiple Grants
Deschutes County
Multiple Award Amounts
1300 NW Wall Street, Suite 201
Bend, OR 97701
Debbie Legg, Personnel Services Manager
541-385-3208
October 1, 2009 - September 30, 2011
Equal Employment Opportunity Policy Statement:
It is the policy of Deschutes County to provide equal employment opportunities in County
government for all persons; to prohibit discrimination in employment on the basis of race, color,
national origin, sex, religion, age, marital status, family relationship, sexual orientation, physical
or mental disability, political affiliation, or any other classification protected by Oregon or
federal law, and with proper regard for the privacy and constitutional rights of applicants and
employees. Deschutes County will follow this policy in recruitment, hiring, promotion into all
classifications, compensation, benefits, transfers, assignments, tours of duty, shifts, layoffs,
returns from layoff, demotions, terminations, training, educational leave and use of County
facilities.
The County Administrator for Deschutes County is designated as the Equal Employment
Opportunity (EEO) Officer. The EEO Officer has full authority to administer and promote an
active program of equal employment opportunity. All members of the County's staff who are
authorized to hire, supervise, promote, and terminate employees or who recommend or are
substantially involved in such action will be made fully cognizant of and will implement the
County's equal employment opportunity policy.
Utilization Analysis Narrative:
A comparison of the Deschutes County employee workforce to the community labor statistics
indicates that the County has underutilization of females in the job categories of technician,
service maintenance, and sworn protective services. Women comprise 33.33% of the County
employees in the job category of technician, while the community workforce for that category
contains 60.75% women. Women comprise 9.17% of the County employees in the sworn
protective services category, while the community workforce for that category contains 18.49%.
Similarly, the County employs 20% women in the job category of service maintenance, though
women comprise 42.33% of the community workforce for this job category.
The underutilization variance between available community workforce statistics and County
employees for all minorities in all job categories is 0.17% or less. The available community
workforce includes the following minority representation: 0.17% Black males, 0.01% Black
Page 1 of 3
females, 1.91 % Hispanic males, 1.78% Hispanic females, 0.14% Asian/Pacific Islander males,
0.30% Asian/Pacific Islander females, 0.46% American Indian/Alaska Native males, and 0.31%
American Indian/Alaska Native females. Deschutes County is committed to continue hiring and
employment practices that maintain or improve minority opportunities for employment with the
County.
Objectives:
Deschutes County is committed to maintaining workforce profiles that closely reflect the
available labor force minority statistics and improving the profiles for female representation in
the relevant job categories. Based upon the results of the underutilization analysis, Deschutes
County has established the following objectives:
• Increase female representation in the job categories of technicians, service maintenance
and sworn protective services by recruiting qualified female applicants for these
positions.
• Maintain or improve minority representation in all job categories by continuing to recruit
qualified minority applicants for all job category positions.
Steps to Achieve Objectives:
The following steps will be implemented to address the under-utilization of females in the
relevant job categories and to maintain or improve minority representation in all job categories.
The County will:
• Attend trainings on diversity recruiting strategies;
• Provide training opportunities for employees in all job classifications to upgrade their
skills and improve their career development opportunities;
• Continue to send announcement of job openings to the state employment department;
• Review recruitment and retention efforts and apply information derived from exit
interviews to enhance these efforts;
• Explore new methods to recruit employees;
• Review and update the County's recruitment methods, practices and policies to promote
equal employment opportunity through recruitment efforts;
• Monitor recruitment efforts, policies and procedures to ensure that the County will meet
and maintain gender and minority employment objectives;
• Continue to increase attendance at job fairs which target women and minorities;
Page 2 of 3
• Continue to provide EEO training to supervisors and department directors on EEO
policies, processes, documentation, interview processes and employment requirements;
Continue to offer bilingual premium pay and tuition reimbursements for secondary
language skills;
• Continue to offer employees County-sponsored trainings on diversity.
Dissemination:
A representative from the Personnel Department will be designated to implement the Equal
Employment Opportunity Plan for Deschutes County.
External
• Continue to include the statement "We are an equal opportunity employer" on all job
announcements, "Deschutes County is an Equal Opportunity Employer" on all recorded
job listings, and "EEO" on all employment ads.
• Continue to include the statement "Equal Opportunity Employer. Women, Minorities,
and the Disabled are Encouraged to Apply" on jobs posted on the county's website.
• Post the EEO plan on the County's website.
Internal
• Post the EEO policy on bulletin boards throughout the County.
• Post he EEO plan on the County's intranet site.
• Annually meet with the County's department directors to distribute the EEO plan and
ensure they are familiar with the objectives of the EEO plan.
DATED this day of
County Board of Commissioners.
2009 for the Deschutes
Tammy Baney, Chair
Dennis Luke, Commissioner
Alan Unger, Commissioner
ATTEST:
Recording Secretary
Page 3 of 3
i
C
O ~
~C C
L C
s
O
U c
N
d
W
a6e4uaOaad
o
o
o
0
0
0
0
o
s
o
e
.
0
0
o
e
o
o
e
o
e
o
Q
aOJopjoM
O
O
O
co
N
O
co
N
O
r
N
N
M
V
Q7
N
co
r
C
h
O
O
O
O
O
O
M
M
O
O
M
M
D
m
Q
^
O
O
O
O
O
O
O
O
o
N
M
M
q
N
O
0
0
O
O
O
(M
O
(h
O
O
O
O
O
O
Q
E
O
O
O
d
m
~
M
M
O
O
O
r
-
a o
o
N
~m
°
nm
0
°
o
~o
M
m
'0
0
0
°
o
o
¢
Q
E U
.m
m
m
m
m
a
a6e;uao~ad
v
e
m
e
~e
o
0
0
o
e
o
0
0
0
0
~e
o
e
o
e
o
e
_
-
a:)JOJN OM
O
O
m
N
N
M
n
N
h
O
O
O
m
m
r
O
O
O
O
O
O
O
0
O
0
O
0
O
O
m
m
O
O
O
O
O
O
O
O
O
V
O
V
N
.o
_
O
Q
o
0
0
0
o
Q
0
0
0
0
0
0
0
0
0
0
0
0
0
0
E
o
o
o
a
m
d
~
~
p
Of
~
o
% c
3
3
a
r
p
M
p
0
w U
0
N
n
N
o
°
-
°m
o
o
o
0
2
o
N
3
-
°m
o
o
o
S
a
Q
~
m
a6e;ua:)Jad
o
o
e
v
e
e
s
o
~e
o
-
o
o
e
o
a
e
o
e
e
o
e
a~
aOaoA loM
Ci
c'
O
O
O
O
V
O
M
0
N
0
N
m
co
.0
m
r
O
O
m
V
CO
V
O
0
O
0
O
0
O
M
O
m
O
n
m
h
co
N
m
o
O
m
r
y
`
f0
C
O
c6
O
O
Q
O
O
O
O
N
O
O
N
N
o
\
/
E
Q
m
O
00
M
N
L5
M
N
J
2
0 15
o
>
1
>
m
>
o
m
(n
m
>
m
>
(n
3
=
N
O
0 0
m
O
N
m
rn
O
N
V
N
O
O
V
O
O
C
m
(O
O
O
N
O
O
M
O
E U
m
m
D
M
co
N
V
D
(
abelua:)aad
o
e
o
o
e
o
o
a
;e
e
s
o
0
0
0
0
0
0
o
e
e
o
e
I~
/
aOaOaOM
O
O
0
O
O
O
O
O
O
0
0
0
0
O
O
O
O
O
O
O
O
O
O
O
O
0
O
0
O
°
O
VV
(O
M
O
(A
O
O
O
O
O
O
O
O
O
O
O
O
g
Y
o
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
o
w
o
a
c
e
N
C
m
(D
c
O
'
m
>
O
O
C
-
a
0
0
0
2
o
o
T
o
o
h
o
o
o
0
2
v
o
n
0
0
o
o
m
E v
m
abe;ua:)Jad
e
o
e
s
o
o
o
-
o
e
e
e
o
e
-
o
v
e
e
e
C
m
m
0
m
O
m
m
m
n
uM"i
O
R
O
O
O
(MO
V
co
M
a~
m
9
r
n
•
~
w
aOaoJNJOM
w
M
(O
M
N
(O
(O
S(p
N
o
N
M
r
0
V
N
m
OD
Oj
0
(O
0
0
.
,
N
N
R7
(h
tri
N
o
N
m
~
Nm
o
+ •
L
•
V
m
m
N
N
M
E
m
LO
N
M
°
M
>
(
0
o
m
3
3
°
m
>
M
o
m
°
m
0
3
M
a
C
n o
c
o
,
c
n
N
^
~
m
N
n
o
(
O
0)
m
n
V
O
E U
co
m
ui
m
a
m
co
ao
m
`r
m
(o
.m
Z
'
a6eluaoJad
o
o
e
o
v
o
o
e
o
o
e
o
e
e
o
0
0
a
o
i
a
O
O
V
V
N
M
V
O
m
N
C~
m
1~
a
(h
O
o
V
O
I~
O
O
0
O
O
O
0
0
V
m
1~
O
N
m
a
aaJ0~y a0
YI M
O
O
Q
O
0
0
O
O
(M
O
O
O
O
V
r
(O
O
M
m
m
N
O
O
O
O
Q
N
r
r
o
O) S
O
O
O
I `
c
0
o
m
a
m
a
F
m
%
3
m
m
m
222
v
10
°
m
m
>
O
O
d
`
_9
~
n 0
E U
w
O
V
N
n
V
m
~
d
m
V
04
a
m
O
O
Z
O
m
a
N
m
m
N
N
O
m
I
abeluaOaad
o
e
e
e
~e
o
~e
o
a
o
e
e
e
e
o
v
a
o
o
o
e
1
_
o
0
o
h
m
N
M
v
m
o
O
o
O
O
O
m
f~
o
O
m
l
0
0
0
o
M
M
O
o
0
0
N
0
01
0
-
a:).lo Jo
3~ M
o
0
0
0
0
0
0
0
0
I
0
O
0
O
0
O
0
0
0
O
N
0
°
~
0
0
q
0
o
Q
0
o
Q
-
'
o
o\°
e
1
~
(n
v
r-
a
a
(n
V
'
o
°
o>
0
>
°
i
m
>
3
3
3 Q
0
0
0
U
O
0
M
M
0
O
O
o
0
o
O
C
O
V
O
O
M
I
a"
,
l
a6e~uaOlad
~e
o
e
o
e
o
e
o
o
D
o
e
o
o
e
o
e
e
o
(
U
M
O
N
M
N
r
N
m
~O
m
m
V
^
r
m
O
O
n
m
O
O
M
M
9
M
~O
o
O
V
m
a~ao3~M aO
o
0
0
0
0
0
o
v
0
c
(
6
0
co
0
o
0
Q
M
(d
m
ri
m
v
O
vi
ri
N
m
o\°
c
e
fo
a
N
I
(
0
Q o
m
o
M
N
ID
°
0
m
n
a
°
m
°
o 2
N
O
O
$
V
N
o
o
o
m
m
E U
Lij
m
m
m
m
a
N
m
m
a6e4ua:)aad
o
O
e
m
m
e
o
o
o
=
m
o
v
a
e
o
o
0
0
o
0
0
0
I
O
N
O
o
o
I~
N
N
O
O
m
I0
O
O
O
O
O
O
M
M
O
O
M
M
O
0
,
0
^
O
O
O
0
m
Y
aOJOINJOM
o
O
o
o
Q
o
o
Q
o
0
0
m
o
M
o
o
Q
0
o
0
0
0
0
O
o
O
Q
m
p
0
o
O
_
f6
I
o
F
e
~
10
O
co
m
m
O j
O
O
O
m
O
O
O
V
0
N
O
N
N
n
O
O
O
O
m
C
O
c
C
O
O
O
o
0
N
o
N
0
E
n
c
(
a6quawad
e
a
s
o
e
o
e
o
0
0
0
0
o
e
=
o
o
e
o
0
(m0
N
IT
N
V
m
m
m
('\O
O
_
N
O
N
n
aDJOINJOM
I-~
(O
C3,
(O
N
m
M
V
m
(O
Cl)
N
N
m
aD
i~
V
m
o
M
N
o
O
O
V
N
CD
O
O
(
Cl)
d
o
0
0
O
M
m
M
n
co
m
N
M
CO
m
0
m
n
o
v
rn
o
N
°
o
o
>
N
>
3
u>
3
N
3
m
>
(O
. p
o
V
M
m
m
N
(O
I~
V
O
d
O
0
m
O
a
O
M
O
a,
O
O
m
n
(n
m
m
O
M
O
v
O
E U
vi
n
M
a
m
m
n
v
a
(o
a
m
w
2
E
o
D
o
D
o
y
o
o
o
°
o
w
N
,
i`
E
m
E
m
.
m
m
m
i
.
E
m
E
m
m
Z`
3
E
3
E
3
E
E
3
E
E
3
E
E
E
3
E
3
E
E
a
U
U
o
0
ci
o
U
U
o
U
U
o
U
U
o
U
U
o
U
U
o
U
U
`m
u~
a
~
w
U
N N
is
C
N
3
Z 3
-
3
E
o
:
w
y
0
o
0
Z :
~
c
Z
o
v
c
L
a
i
O E
2
saOinJag anljO93aid
Y
m
¢
O_
¢
to
d
L
4-
y
L
c
3
}
c
V
Q
S
L
a
C
00
N
O.
E
O
U
O
0
03
v
o)
0
0
N
0
Y
O
C
0
U
U)
7
U
u1
0)
0
0
C
f6
a
O
W
W
O
d
a
v
d
m
CO
01
O.
N
E
m
L o L
W
O
AN
W
L
O
C
CL
E
N
y
c
O
3
O
c
>
y
y
m
o
m
tD
Z c
c
v
y
0
c
>
CD
> p
Q
U
0 Cc
Z
c
y
3
c
v
i
a
(D
0
p
U
U
N N
(n
f
C
d
~
o
`
°
°
Q
a
a
.
O
U
U
U
U
Q
.U
Y
Y
O
O
O
-O
w
O
y
`
Y
Y
Y
Y
Y
N
0
O
p
O
N
U
O
>
N
O
'
N
U
O
'
N
O
>
N
O
'
N
O
>
N
O
O
O
O
O
w
O
w
C
C
Y
C
1C
C
Y
C
Y
C
Y
C
Y
C
Y
O
~
o
O
o
7
O
0
~
o
7
O
0
o
7
O
0
o
0
O
0
o
O
O
O
o
O
O
O
o
U
c
U
2:
c
U
c
U
>
c
U
c
U
c
)
c
U
>
c
(n
(D
.
.
C
O
to
w
N
E
O
cn
y
N
.
.
'
O
N
y
N
.
.
O
N
N
O
y
w
'
0
to
2:
O
y
.
.
O
O
3
(0
O
p
f0
O
C
O
f0
O
C
p
f6
>
C
>
N
N
N
7
E
p
!n
(6
N
7
c
O
y
f6
N
7
E
3
N
(6
=
v
E
a
L
E
a
E
CL
t
E
a
=
E
a
L
E
a
s
E
a
E
a
u
,
E
E
in
E
E
0
co i
E
E
'S
E
E
uvi
E
E
E
E
of
E
E
ai
E
E
N
D
O
U
O
U
N
0
O
0
O
N
O
O
D
O
U
N
ID
O
U
O
U
N
D
O
U
O
U
N
C
O
IO
O
U
N
0
O
U
O
U
N
D
O
U
O
U
o
s
o
o
R
a
o
o
o
o
0
o
s
o
0
0
0
0
D
o
e
°
°
'
alewad le4ol
N
Oo
C
^D
M
n
c
Cl)
Q
Cl)
O
M
O
r
^
N
O
M
Cl)
m
°Q
co
(D
N
M
m
(D
N
10
M
co
O
N
°Q
M
N
N
Di
ID
~
V
N
N
~
L
o
e
o
o
o
o
q
v
a
o
o
o
q
o
(
D
C
D
0
0
t
-
aleW leqol
Q
n
O
o
(p
^
(o
M
M
N
O
n
(D
(o
N
M
P
n
Q
o
n
(D
O
O
M
M
O
N
P
ci
M
N
O
P
ry
O
O
n
(O
M
M
N
(O
M
Q
(OD
M
N
Of
m
M
Q
(Op
(o
m
N
m
m
Y
M
N
N
a6e4ua:)Jad
o
o
o
e
o
o
e
o
v
e
o
e
e
o
e
e
o
a
v
e
o
e
o
O
co
co N
N
M
m
N
A
O
O
O
M
O
p
V
Q
O
O
O
O
M
aJJopJoM
o
o
q
N
o
o
o
0
0
0
a
o
ci
(
o
o
0
0
0
0
M
4
abeluaJJad
o
a
e
o
o
e
e
W
e
o
o
e
e
o
e
e
R
e
o
o
e
e
O
co
~
O
N
N
n
u>
O
co
W
O
O
O
O
O
O
O
N
O
O
O
O
O
QQ
Q
a~JO Jo
~I M
O
o
N
o
q
M
o
N
0
O
0
O
0
n
c
r
q
O
o
o
o
o
0
a
0
O
o
o
0
O
o
-
o
~
q
O
o
O
0
o
0
O
o
N
o
q
co
a6e4uaaJad
o
0
0
o
e
o
e
e
v
e
o
e
o
o
e
e
o
e
o
o
e
E
aoJO VJO
O
M
O
O
O
M
Q
D7
M
O
N
O)
N
(D
of
N
m
n
O
O
co
Q
O
Q
O
O
O
O
O
O
O
M
O
(D
O
n
m
M
co
N
M
O
O
y
n
co
n
LL
~'I M
O
O
16
r
ni
O
O
q
O
O
O
Q
N
O
O
(V
N
a6e1ua:)Jad
o
O
a
O
e
O
o
O
e
c
e
0
o
O
v
O
a
O
J
a
O
e
O
e
O
o
O
e
O
e
O
o
P
e
M
o
D
O
o
e
;e
a
e
aDJO JO
d~ M
O
0
O
0
O
0
O
0
O
0
O
0
O
0
O
O
O
0
O
0
O
0
O
0
O
O
o
O
n
O
O
O
O
O
O
O
O
O
O
O
o
0
0
0
0
0
0
6
0
0
0
0
abeluaaJad
a
o
e
o
o
a
o
a
N
o
o
e
o
o
e
o
o
e
o
o
m
m
m
o
°
M
°o
n
N
o
v
°o
°o
°o
co
v
r°
m
(1
m
~
^
^
aJJozNJoM
w
M
D
M
(D
(o
(O
(o
O
N
M
r
(o
Q
N
O
N
Oi
o
o
Q
O
n
OJ
ID
(V
N
m
N
N
co
co
a6e4uaoJad
~e
o
V
o
o
e
o
o
e
o
e
e
o
o
e
o
o
o
0
0
o
a
o
v
I
m o
~
W
N
co
A
~
0
0
0
0
0
0
0
~
~
o
~
m
aaJOJNJOM
o
0
°i
6
0
0
p
0
c+i
N
0
0
0
0
6
O
q
N
°
-
O
6
a6e4uaaJad
~e
J
e
a
o
e
o
o
e
a
o
e
o
0
0
o
o
a
o
a
e
o
aJJO;~JOM
M
O
o
(`O'),
o
M
o
co y
O
O
o
O
0
O
0
0
O
0
O
O
O
O
O
°
O
N
N
O
W
o
D)
9
o
0
0
0
0
o
Q
o
o
Q
o
abeluaaJad
e
e
e
e
e
e
v
a
e
e
e
e
e
e
e
v
e
o
e
o
o
e
o
co
a~JO JO
M
o
M
(o
O
(o
N
n
O)
N
N
(o
n
N
UJ
n
Q
M
(o
(D
co
Q
n
n
(D
O
O
I
(D
O
O
M
n
M
n
M
M
(o
co
O
(D
o
O
Q
n
(D
N
G
.~I
0
0
0
0
0
0
Q
o
Q
(o
o
(6
o
o
q
abe;ua:)Jad
=
v
o
e
~e
e
e
o
e
~e
e
e
e
v
e
o
e
O
co
O
N
O
n
n
N
°
c0
m
O
O
O
M
O
M
O
n
n
O
°
O
O
(D
O
a~JOdelJOM
O
o
N
o
q
O
o
N
o
q
O
o
n
o
r
q
O
0
O
0
O
o
M
r
O
0
M
n
O
o
O
o
o
q
O
o
O
0
O
0
O
o
o
q
a6e4ua:)Jad
e
o
o
o
a
o
e
o
o
o
a
o
e
a
o
e
e
'
c
Q
N
y
(o
n
co
M
O)
Q
Lo
m
n
o
M
M
N
'o
co
O
O
Q
aJJOJNJOM
n
o
(O
(y
N
d
Q
N
u
P
ad
m
co
N
D]
(D
co
Q
(D
cD
O
0
M
vi
O
o
P
o
P
m
N
°
O
N
6
n
1:
(o
(o
M
Q
(o
M
N
co
I
M
(D
N
M
N
^
ro
m
D
C
N
O
E
e
~
b
o
'
N
o
«
E
y
a
o
'
N
O
3
E
E
N
n
E
Y
3
O
E
E
l0
n
E
C
E
E
E
N
n
E
'L
C
E
E
N
n
E
'2
3
E
E
-
(0
n
E
'6
3
C
n
E
E
N
o.
E
3
E
o.
E
a
o
U
U
o
U
U
o U
U
L) U
U
o
o
U
o
U
U
o
E
U
E
U
o
E
U
E
U
m
c~
2
to
y
E
o
E
p
y
C..1
y m
c
C
m
3
0
Z 3
N
U
a> c
f6
O
•V
y
y
O
U m
0
_
C
w
U
O
d
N C
o
saDIAJ9S and;Oa;°Jd
E CO
Y
N 'm
Q
a
Q
cn
U
10
C
O
C
O
?
co
E
m
LL
f6
E
E
O
U
L I~
N
U
U
V
N
L
U
m O
C y
'
o'
A y
F
A
s,
R
d R
LO co
CV N
O N
M
M
O ap
r r`
p
O
LO
co
O
O M
O
co
l
r
. z
c 'Y°
aMaz
O
O
O
O
O
O
= Q
E
a o`
c !E C
0
LO oo
\0
LA ti
0
0 00
\o
LO ao
LO °v
C)
a a
R M R
N N
N N
r~
Q
O
N
O
00
M
o
Qaw
o
0
0
o
C
)
Gl
v_
a>
t0
E
C
a
o
00j o
0
o
0
N CO
o
v
O
LO o
LO 'o
o
o co
Lo o
M ~o
M
C
o
ti
$
E
P
CO
L
L
=
O
N
O
N
r
r
x
0
U.
V
O
O
~
y
~
R
O
O
O
O
O
qr 0
0
O oo
A
to
O
O
O
C
m
L
+w'
CO Lo
M LO
O o
p o
p °
0 0
co
0
0 C
a
o
C
t
M 0)
V-- o
M ri
fl
LO o
~
o
N
M
N
t
3
M con
Ln uo')
- i
`
°p
°v
00 c`oo
Cfl Cl)i
N
3
Z
V
L
O
V C Y >
0
0
0
0
0
0
0
R ~
°
z
i rp to,
O 7
1
,
v
0 co
O o
O
LO 0
l!7
O N
.
.
i
E a z
1
o
o
r0
N N
Lo o
00 -
In o
M
N
3 N
A
a ~
G
d
a
~ O
L
u
O
i
O
°
a
"
V=
R
R R
O
N
M M
O o
O
0
O
h
O
LO
r N
O o>
M
CA
r..
.
~
v
o A
a a w
0
0
0
0
0
U
m
m
a
0
LO LO
OR
C) 04
0
0
00
0
' co
d
O
0
C) 0
O
0
0
co
0
c)
0
cy)
e
$
T
0 0
CV N
0
r-
0
0
^
o
m
N ri
LO
Cl)
p
r:
x
Y
Ln O
LO
O 00
O
O
0
O n
O
LO co 0-0
Ln
ti
m
N cy
N ry
n
0
o
N
Cn
m
o
0
0
0
y
O OR
O
!Z
R
Lo
U-)
Lo
CD
Z
M n
000 I--
C) a°'o
LL( (IR
O oo
M
o
O 00 v
O co
'IT
n
CD
3
3
Ln_
_
M V'
c oi
O co r
co
_
M
Cfl 0CY) 0
00 ~
N
r
LA
C
~m' 0) 0
LO CV o
U') o
I,- o
M o
0 0
o
Lc) OR
~
o
O
D O
0 0
N C)
N o
M o
LO o
o
(0 o
o
p
Lr)
EU
w
L
d
O
d
0
N
O
Z
o
W
CL
m
CL
c
c
U
CO
O
L
Cn
a~
a>
E
V
o
Co
c
0
=
cu
ca
L-
cu
O
fn
cn
U)
> (n
-
4-
U)
0
_
D
t
N U
C
U
U ,
-a
"
N
" m
-0
;C
a)
H
1
0 Q
a
H
a U)
Q
_a
C
E
E
0
0
R
v
CD
O
O
N
w
Y
>O
O
U
U
N
N
0
`m
a
0
w
a~
c
00
a
v
L
0
L Q
0 0
N
U)
Y
U)
0
N U
a)
t 0
U) U
d NA,
W
i
,VA
N
a o
0
LU
L11
L L.
0
V C
O
O
O
O
O
R
w z
T1p
O
~ R
N
r N
_
M
('e)
(O
~
N
M
c
3
E c Q
Z
N
q
o`
L V
_
C
ae
(p
m t0
N
M
r
r
r
cm
o m
a a M
'
L
o
M
0
0
0
M
0
N
M
ea
E
d
H
(o
M
IL
Z
N
F.
U.
Y
0
0
~
IQ
r ~
r
r
A
m
.L
LG
O
C
0
e4
0
0
(0
0
0
0
Cl)
0
,
O
C
Z
3
M rn
M
rn
N (o
o
Cp co
r
CO M
6
o
11
M
1Cf
t
3
U')
M
ao
w
0
N
P.
Z
C L
y.
0
0
0
0
0
m
w =
'y m R M
M
04
r-
7
N ~
N O
CD
CD
'S N
L
E C Q Z
O
M
N
°
w m
Q
Q ~
EE
Q O
L L
O V G7
c !E
0
O
O 0
0
0
\
q y
10 R R
C?
M rn
00
La
o` A
as
°
°
o
2
a~
M
0
0
0
0
0
0
0
0
~
a~
m
CL
C:)
co
I'-
CV)
CN
(0 LO
co
N r-
co
M
co
C)
C)
o
v
co
ao
(ri
N
x
U
°
Y
f0
r M
M
r
r
co
M
r
m
C
0
0
N
0
N a
0
O rn
0
m
0
N-
0
cM °
O
co
r
3
co
LO
oo
N
co
°
'
ul
a;
o
ui
q
q
3
O
M
O
OD
M
,
~
r-
(0
N
d
ea d
p
0
°
0) o
°
o
0
°
0) 0
°
o
(p o
N C,
0
C)
°
N
o
0
d
U
o
0
M
0
0
o
o
o
o
f~ o
o
N
p
E
w
=
0
0
cO
c
CO
0
0
Z
U
C
1
Q-
U
d
m
a
c
a
O
U
CO
c
7a
O
L
0
>
co
C
E
7
0
L-
L
W
~
\
n
A c
~
v
0
-
L-
L-
U
-
0
_
(B C
N
C
I
U
N
=
a)
U
H
E
4-
4-
0
0
0 Q
a
CL cn
Q
(A
cA
C
O
U
m
v`
d)
O
O
N
0
Y
O
0
U
a~
L
U
N
N
m
a
0
w
w
a~
0
O
a
v