2010-2625-Minutes for Meeting May 03,2010 Recorded 6/8/2010DESCHUTES COUNTY OFFICIAL RECORDS ~1+~010~~~~~
NANCY BLANKENSHIP, COUNTY CLERK y `
COMMISSIONERS' JOURNAL 46/48/2414 4$;34;13 AM
II 111-26 I III
2 10S
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 at the request of
[give reason]
previously recorded in Book _
or as Fee Number
to correct
and Page
%TFs
r~A
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, MAY 3, 2010
Present were Commissioners Dennis R. Luke and Alan Unger; Commissioner
Tammy Baney was out of the office. Also present were Dave Kanner, County
Administrator; Erik Kropp, Deputy County Administrator; Marty Wynne and
Cheryl Circle, Finance; Peter Russell, Community Development; David Givans,
Internal Auditor; Tom Blust, Road Department; Rick Root and Nick Arnis, City of
Bend; Bob Bryant and Joel McCarroll, ODOT; Hillary Borrud of the Bulletin and
a representative of a local television station; plus two other citizens.
Chair Luke opened the meeting at 1:3 Op. m.
1. Finance Update.
Regarding investments, Marty Wynne said that this is holding at about 1%. The
Investment Advisory Council uses the ladder approach, taking into account tax
flow needs. They do not play the market, but allow funds to rise and fall with
the average market rates. They go out about 18 months, as a longer-term lock is
too uncertain. He added that he gets e-mails every day from banks and
investment firms and compares the rates. The ratings system is being
overhauled and the results are not yet known.
In regard to the General Fund, they are on target for year-end. Community
Development had a decent month in March. Medical claims are up 18% this
year. The good news for Building Services is that the year-end projects are
coming in a little better than budgeted. Large projects are coming in under
budget and on schedule.
Indirects may bounce up a bit since the beginning amount will not be as high.
There are different methodologies used, depending on a variety of factors.
A copy of Mr. Wynne's financial report is attached for reference.
Minutes of Board of Commissioners' Work Session
Page 1 of 5 Pages
Monday, May 3, 2010
2. Discussion of Draft Policy regarding Payment Card Security.
David Givans said that payment card security was reviewed. The County is a
processor through banks, and the merchant agreement has some responsibilities
on how these are handled.
Cheryl Circle added that the industry requires certain things and so does the
County. There is no known problem at this time, but it makes sense to have a
policy in place in the event of an unforeseen situation.
UNGER: Move approval of Policy F-12.
LUKE: Second.
VOTE: UNGER: Yes.
LUKE: Chair votes yes.
3. Discussion of Issues relating to the Intersection of Highway 97 (Parkway)
. and Lafayette Avenue.
Commissioner Luke said that the County sent a letter regarding signage on the
Parkway that blocks line of sight from the intersection of Lafayette and the
Parkway. He asked about the track record of incidents or accidents on the
Parkway at that location. He noted that if people would move to the left when
going through, it would simplify access.
Commissioner Unger stated that it is important for the County and City as well.
He would like to see this handled in a proactive way, with solutions and impacts
considered.
Bob Bryant said they looked at sight distance and other options. Joel McCarroll
stated that within the crash and safety rating systems, they consider specific
crash types, with property damage only and where there were injuries involved.
He gave an overview of accidents occurring over the past five years.
Commissioner Luke feels that the head-on collision listed could have happened
regardless of the intersection.
Mr. McCarroll said that all the information combined makes up the safety
priority index. Lafayette is in the bottom five percent, with Hawthorne in the
bottom thirty percent. The numbers vary year-to-year. The worst intersection
is at Truman, as the accidents are more severe.
Minutes of Board of Commissioners' Work Session Monday, May 3, 2010
Page 2 of 5 Pages
Mr. Bryant stated that thirty years ago, when the Parkway was considered as an
access control facility through Bend, the focus was to be on primary
intersections for long-term access. Traffic volumes were low at that time, so it
was decided these access points could be accommodated. Lafayette and
Hawthorne originally were considered for allowing left turns from the
northbound lanes. What he is hearing is that they are becoming more and more
hazardous.
Commissioner Unger stated that is better to look for long-term solutions before
there is a crisis.
Mr. Bryant said that there are actually two signs. One possible approach is
replacing them with smaller signs. It has been suggested that signs indicating
"through traffic stay left" or "merging traffic" might help. Speed is also an
issue.
Mr. Bryant stated that if there is a real concern about speed, there should be
involvement on a legislative basis.
Commissioner Luke noted that the parking lot was moved back from Wall
Street to keep too much traffic off of it. Mr. McCarroll said that as
jurisdictions, thought has to be given on how to manage the traffic. The
agreement never defined what a problem or being problematic might mean. No
one seems to know the threshold. From this point forward, conversations
should come up with some guidance or measures to determine when a situation
is serious.
Commissioner Luke said that any closure of access to the Parkway would have
serious ramifications to traffic on City streets and neighborhoods.
Martin Hansen, an attorney with offices on Hill Street, said he has used
Lafayette Avenue many times a day since it opened. He said that a "merging
traffic" sign would help. Rush hour lasts only about twenty minutes. If through
traffic kept to the left, it would allow Hawthorne traffic to come out. A traffic
count might show how many people are traveling through or turning. A closure
of any of the road would negatively affect downtown traffic in a big way.
He added that the County building casts a shadow on the turn lane and the sun
never melts the ice on the roadway in winter. A mindful job of keeping that
area ice-free would help.
Minutes of Board of Commissioners' Work Session Monday, May 3, 2010
Page 3 of 5 Pages
Commissioner Unger said that the reroute in Redmond had similar problems. It
is not just an ODOT or Bend issue. What needs to be considered is addressing
future congestion problems now.
Mr. Bryant stated that Bend made an investment in major intersections long-
term. Redmond did not.
Commissioner Luke asked if a reader board could be used short-term to direct
traffic to use the left lane and see if it helps. Mr. Bryant said that the
Transportation Committee does not believe that local traffic should use the
Parkway; they prefer it for through traffic. That is why it is a limited access
road.
Tom Blust stated that he feels it is inevitable that they will close it someday.
The City will have to figure out how to mitigate the resulting congestion.
Short-term they should do what can be done to be able to postpone closures.
Rick Root asked about the threshold, and what can be done so as to not leave
anyone unprepared. Mr. Bryant added that they also must be sensitive to the
stakeholders and users. Agreements and promises were made when the
Parkway was being planned, which is why Truman access and other points are
there.
4. Update of Commissioners' Meetings and Schedules.
None were discussed.
5. Other Items.
Dave Kanner indicated that he is not sure of his role in the hearing taking place
tomorrow morning regarding the dismissal of Becky McDonald from the 911
County Service District.
Commissioner Luke asked Mark Pilliod how the hearing should be handled.
Mr. Pilliod said that it might be confusing for the County Administrator to be
directly involved at the hearing. He has not spoken with Andy Jordan, the
interim Director, who will be in attendance.
Minutes of Board of Commissioners' Work Session Monday, May 3, 2010
Page 4 of 5 Pages
Mr. Pilliod said that he expects to be available, but will face the Board and not
the audience. It will be in open session and not executive session, although an
executive session can be called in certain circumstances. The employee does
not have the right to call for executive session.
The executive board of 911 will be present to ask for clarification if desired.
Mr. Kanner said that it should be handled the same as a couple of step 4
grievances were last year. There should be no reason to rehash all of the record
up to this point. Chair Luke asked if additional information could be presented.
Mr. Pilliod said there is an intergovernmental agreement that addresses this, and
if something was not already considered, the question as to why it was not
considered by the E-board can be asked. It does not indicate that the record is
closed.
Commissioner Unger asked how or if the DPSD policies apply. Mr. Pilliod
added that it depends on whether all the information was already included and
how it relates to existing documents. During the due process hearing, an
agency policy was referenced.
Being no further items addressed or action taken, the meeting adjourned at
3:10 p. m.
DATED this 3rd Day of May 2010 for the Deschutes County Board of
Commissioners.
C4. ' ~~....11Z
Dennis R. Luke, Chair
Alan Unger, Vice Chair
ATTEST:
Recording Secretary
Tammy Brney, Comlrfissioner
Minutes of Board of Commissioners' Work Session
Page 5 of 5 Pages
Monday, May 3, 2010
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
1:30 P.M., MONDAY, MAY 3, 2010
1. Finance Update - Marty Wynne
2. Discussion of Draft Policy regarding Payment Card Security - David Givans,
Cheryl Circle
3. Discussion of Issues relating to the Intersection of Highway 97 (Parkway) and
Lafayette Avenue
4. Update of Commissioners' Meetings and Schedules
5. Other Items
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.
If you 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.
o
N
d
\
G~'~
4
C7
cam
J
'
~
I
a~
d3
0
a
M
~
M
.L
N
O
~
~
~
I
i
~I
{
N
c(~~
I
Q
c
~
3
Z
3
3
3~
II
I
a
v
,
I
v
C
•
l
1
•C
,
\
~ I
a
co
a
~
Vl,
a
E
~
I
LAJ'
L
z
J
~
a
Monthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
(1) Monthly Investment Report
(2) March 2010 Financials
O
O N
co
O
C
CD
M
CD Lo
M Cfl
G
O
T
T
N
r
O
O
N
r
C
~
H-T
ER
d
~
c
G
~
N
y
N
N
Lo
ti
U-
_
r O)
T
=
O
r
rn
~
rn Uf)
r
M
r
`
m
T
r
r
EA
!f!
r
r
cc O
O
N N
E
a+
Cl)
O
U
us,
E Z
O
_T
U >
C
E
3
C 0 V
O
V
y
E- 5
m
N
d Qj d
r
C
E
C U
-
N
E
~
0~ C
Vl
>
d
~
C
~p l6
H
c
a)
C7
0
0 0 0 0 0 O
CD co
O O O O O O O T OO ,0 O
O
O 1. 00 6 N O o O
T
CO Cl)
LO
fl
T
CO
O
N
r
r N
In
~
O O
(D
T
r-- N
CO
v
N
O Un
N
r-
w
N
Cl)
CO
Cl)
T
(a 161).
U
U
~ C
N co
~ a
cu m
)
w
a
a)
U
m
(aZw ~UU
V N N Q Q H
y
d
~ 1~ Un 0
>
c
E oU~ M aim
E C:
t-
UU DUim-'
H
04
w
C ~
5-
m
C
a)
CD
0 0 0 0 0 0 0
O O LO 0 1A O O
O O t.- N N N r
T T
E U
7 C L
X N
O O
U
C O (6 d p
O O Q L) N Z
N ¢ O O CO
U
a~i ~ n E
Cu Y a) n
-0 c: E
cUD -j llm 00 1-00
N
d
Q
T
I r
C
~ E
y
, N
d
I C
T
m
O_
.O
O
a
ICI
~ H
o
~ U o
( v
,D (D
N
LL L Q
N CO
o
E
w co
U
N
m ~
O o
Q O
.0
o Z
U
U
H
m
o
d
(7
N
O O O O 'O T a o e p a e a '.o
U r U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ U_ V_ U_ U_ U_ U_ U U_ U_ U_ M U_ (p U C O O N O N.O o
j( p Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z N Z Z Z m z Z Z Z N Z N Z- f0 m.W C O ml0
a) W O QJ m O C O O N O ~,0
Z O Q O O O O CT
W w N O O o n N m I~
V m I V N O O O N O O t0 l o o V W N I~ N O O V N O. O. O. t0. I~ O
Q O~ M m m N O (n 0 (0 0 I~ m O O m to m (D N (n O a N O O m O lU W O< (O (D N O O ~C? m O M f~ Ih
N m m W m M O I~ O N I~ O m (O O (Il (D O N m N I~ O 7 n O O m 0 LL~ W O m N O O m m r W M (O (D
O C r O r m (O V O m W m m ([J W m (O cn O m V m N(D O V (O O M O m O O O N O O m W c0 W O N
~ O (n m m N O m N fl m (O (O N O il m O W I~ ~ m N r m m W
O M M W r N W ~ v m NM 'r ~ m co O
E! m o O O 7 N m m m I M m ~ O m m N m N V N 0 W O O~ N W W m m W O m N O
N M O W N O m O M m M M 0 7 (f1 O V O O N O (D 7 m N m m m O N V I: m m v (O N aJ a m O W O
io of R O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 W O M N i~ N W V N
> j N N V N N N N N N N N N N N N N N N N N N N N N N N N N O N O N [N'J (^D (O
C
60
I!'l m 0 m m m N 0 0 0 0 0 0 (D O V O (O N 0 0 0 I~ M O O O N 0 0 0 0 0 0 0 0 0 N O I~ d,
al O W O I~ V 7 N 0 0 0 0 0 (O M O m O I~ 0 0 0 m M O O O N O O O O O O O O O (D W M M
N m 0 I~ r M N O m 0 0 0 I~ O I~ O r O O m O M O O O N O O O O O O O O O I~ m (D
O O W O n W m N (O O (D m m W m V W N O W m m N V M N (V N N m N N W O N W O N M W (O t0
> M A O I- O O N r m I~ W M fD m O W W (U O V I~ 7 W m N W m (D. I- N N co W m co O co (O 1-
M M V m O m O M o m N O V i0 N O f~ m O m m O O m m m m w m 0 (m O 7 W I~ O
N N N m 7 N m I~ O O M f~ O N O I~ o N 0 0 0 00 0 0 N 0 m m m O 0 0 0 m 0 N m V -e
Y 0 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O M O m 0 0 0 m 0 (D O CO O
(p ~ N 7 N ~ ~ N N N ~ N N N N N N N N N N N. N O N N N N N ~ N I~ O ti m
~ W ~ N M
_ m 0 0 0 0 0 0 0 0 W O O O O O O O O O W O O O O O O O O O O O O O M 0 O o O N Ole m
W 0 0 0 0 0 O' O O ~ O O O O O O O O O O O O O O O O O O O O O O O N O 0 0 0 M W M O
N m 0 0 0 0 0 O O O O N O W m O 0 0 00 0 1 O O O O O O O O O O O o O m O o 0 0 I m m O
7 0 0 0 0 0 0 m a m (D m a O N O O V O m V O c o o V 0 (O 0 0 (D O O W O N O O N aJ (O ID
U W 0 0 0 C 0 0 0 0 V m m (D O W O O W O"t (n o 0 0 0 W O M O o m O m m 0 f~ O O t` r (D
n ~ o 0 0 o v o m o m r ~ o W o o m o m m o 0 0 01 o W o o m o ~ o v o o ~ m n o
C N O O O N m O N O O W ~t I~ O O O O O O m O 0 0 0 m 0 ID O O W O O V 0 0 0 0 O W N
.m O O O O O o 0 0 0 0 0 0 C m 0 0 0 m o C 0 0 0 0 0 0 0 v O m m N N.
V N V N N N N N N N N N N N N N N N N N N.N N N N N I~ O r V C a)
D V N
o. n N. N c
N_
F
81~ -I 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0 0 0 o v e a o'Z j .U
W 0 0 0 0 O 0 0 0 O) O (O 0 0 0 0 0 aQ
0 0 O (D c0' p' O N O>
O O O O O o 0 co O O O O O O m O 0 0 0 m o
y O m m 0 0 7 W N V O N (O O (O (O M c0 m y IU 0 0 (O M O N o m 0 (O W O (O f~ C O O (O O N N
N (O O W O ~O co (O O <F N o O N Il N m W W M f~ m O N O W co Il O O m m 0 V t0 cD O + E U N m .N. m C
E O o ~ -
N ~ ~ N N m ~ e- ~ M M ~ ~ ~ N ~ O ~ O ~ O ~ ~ 0 0 0 ~ 0 0 ~ ~ X 0 0
r f6 . O 0.9 U) a)' m (7. 0
LL.- U U F- D LT J F-
_ C 0 0 0 0 0 o o~~ _o o _ ..o o 0 0 0 0 0 0_ o o o o
(A O m m O O 0 0 0 0 0 0 O O m 0 0 0 0 0 (O O O O O J
O d I~ m r O O m M O O m 0 N O f~ O W m m O N (O O O
a M N m m (n m m (n W M r o m o W I~ r` M m o o v N
o ri ri v v ui o (ri o o co o ri o (ri o
U O ~
a)
w E
dl m
O
o E a0 O > m
o ~ c U
R E O
w c o ~
N a7 O m
O O j~ V I~ N m m O O f~ N W m v m (O m m 0 0 W r N W O f~ r O (D f~ m m I~ m M (D (O O O O N N>
Q o o rmi~nvNn°rO nv~ na 1~n~r ~r °non~ n n~(D(DmD D~~ u~ Ey a~
_ _ N C
O O O
7 10 ~ N N W f~ ~ m O ~ V O ~ a' r r m m Z-0 (O O a-) T T (A. i0 a3 B iB (D C7 N -
O O O N N N 0 0 0 0 N N O N N N Q O 7 0 0 0 O N N N N 7 7- 76 m E 6 p v v I r r W co m O O O ems- N CJ th v (O (D (D Imo' r m O O N > V~
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o Q F0 0 m
m
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~ 0 0 0 0 0 0 ~ ~ ~ O ~ ~ ~ O
N O (D w LL~ O LL~ LL~ r 0 0 0 O m~ O O m f \ n (n O) r m N2 N
` 0 O_ O O N N..... N O_ O M N N N N N N z O M O N N N- c-
0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 o o o o o o. o 0 0 0 o 0 0 o Q U 0: LL m m fnlZ > F- d LL Q.a Z Q.p.
1 m m U 2 Y J O. R' fA t/1 fA ~.3 m..U U I .F- 1-
O
Bd y
0 a
LL
❑
~
❑
F
L LL U LL LL LL LL U LL LL LL LL
LL LL LL U LL
~ U U
F
F
LL
M~e9 co m m❑ m m m of 2 (n TD of 3 0 0 0 0 0 w Y (n d d D d (n 0D~ w w x (n (n
N m m M N. (O WW O m N LL~ f~ (U W m W f~ I~ to U N
Z F m m > m 7 J J v W. m Q Y Z m w
E .0
7 2 U (n Y co co ❑ M Q LL Z Of K (J N (n =
(D > X m m m ❑ m Q
F- (n (D F- Q m
(7
W
o
(X> rXi rxi (h m W M M M m rxi (h m M X
m
o
.
M M M m M M m N M M M M N M N M M M
W
7 M M M M M M m M M M M M mm-z) M m M m
O
C
O CU O❑ Q U Z
a
N C L Y ED C O
Q• U U U ❑ U
(n p p N.
U
l9 tU/1 m N a)
U m N O. d N 0
d o
i m
m
m
Y
~UU
U
❑
Y O
- m
N
om
0- -6 E m
Z
~
w °
f
~
Ua.Q.
m z U
Um UmZ C m U N
m_
~
c
E m O
ol'Q
,3:
Q
Q f0 m
U
U U U N U V m U O~ a m U m N Z
m. Y m ~1 Y co U Y U
L) CU
m. o c c t6 0 0 0 cU
m m. y
. C m ~.Z O
N a1
nLL (0'. >,m pm> ~O w o mU N
O O E
Emr L a
°
Y
c N E E (6 m c. E N. lLl m m m N 00 m m > m
O Y co 0
N ' co v - m m - =
L M
W
m
-c
c c E a~ U m 5 E °-oo ~
m m o o a» a m 0 o E m m o `o o. E a7
.
U)Y c
m
L Q Q
Q 0) m.
m
m
E
a
._.->UO)m co j U
~U ~LL
LL
m ULLF-D
_ m USY.JLLK(n.(n (OU~. m o
Z
N
cD
p
O O O O
O.
m
N YYY cr V -m Oco co Nm 0-~ Qa)r E ~mY~ CCO COm or M O ¢ m
co m
Y
C C C O. C m C' J E -i c U cL a E N C J 7 J > U J' Uj O' U
> U 2 U
2
m
'
N
U
C O
.E m.n mZ o22 dLL E2 E o o m2.02 (L)LL = ELL 22
oLLZLL
c m m m
co co co D co J m' LL 2 LL LL (DLL Z:) LL Z) S U CD LL (n LL fn Y LL LL :D 7 LL LL LL LL F- LL LL LL LL
m
w
J M F-
Memorandum
Date: April 13, 2010
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find March 2010 financial reports for the following funds: General
(001), Community Justice - Juvenile (230), Sheriff's (255, 701, 702), Public Health
(259), Behavioral Health (275), Community Development (295), Road (325),
Community Justice - Adult (355), Commission on Children & Families (370-399),
Solid Waste (610), Insurance Fund (670), 9-1-1 (705) and Health Benefits Trust
(675).
The projected information has been reviewed and updated, where appropriate, by the
respective departments.
Cc: All Department Heads
GENERALFUND
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Year End
$
Budget
Actual
Variance
FY %
Coll. %
L 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
14,867,135
19,514,776
4,647,641
75%
98%
a)
19,822,847
20,674,385
851,538
Gen. Rev. - excl. Taxes
2,191,097
2,644,425
453,328
75%
91%
b)
2,921,462
2,921,462
-
Assessor
615,528
643,651
28,123
75%
78%
c)
820,704
820,704
-
County Clerk
782,378
1,125,907
343,529
75%
108%
d)
1,043,171
1,477,971
434,800
BOPTA
10,343
11,441
1,098
75%
83%
c)
13,791
13,791
-
District Attorney
249,600
168,358
(81,242)
75%
51%
332,800
381,603
48,803
Finance/Tax
140,287
158,536
18,249
75%
85%
c)
187,049
197,827
10,778
Veterans
52,644
45,725
(6,919)
75%
65%
e)
70,192
63,871
(6,321)
Property Management
64,837
71,740
6,903
75%
83%
86,450
86,450
-
Grant Projects
1,503
1,503
-
75%
75%
2,000
2,000
-
Total Revenues
18,975,352
24,386,063
5,410,711
75%
96%
25,300,466
26,640,064
1,339,598
TOTAL RESOURCES
25,025,352
31,162,058
6,136,706
75%
99%
31,350,466
33,416,059
2,065,593
REQUIREMENTS: Exp.
Expenditures
Assessor
2,467,973
2,297,415
170,558
75%
70%
3,290,631
3,220,631
70,000
County Clerk
1,095,528
923,984
171,544
75%
63%
1,460,704
1,450,704
10,000
BOPTA
44,781
40,736
4,045
75%
68%
59,708
63,614
(3,906)
District Attorney
3,440,447
3,405,759
34,688
75%
74%
4,587,263
4,563,140
24,123
Finance/Tax
559,853
576,867
(17,014)
75%
77% f)
746,471
703,061
43,410
Veterans
169,276
167,165
2,111
75%
74%
225,701
225,701
-
Property Management
179,764
177,592
2,172
75%
74%
239,685
239,685
-
Grant Projects
79,255
77,366
1,889
75%
73%
105,673
105,673
-
Non-Departmental
1,209,755
1,602,610
(392,855)
75%
99%
1,613,006
1,493,006
120,000
Contingency
4,458,535
-
4,458,535
75%
0%
5,944,713
5,944,713
13,705,167
9,269,494
4,435,673
75%
51%
18,273,555
12,065,215
6,208,340
Transfers Out
9,785,183
8,575,449
1,209,734
75%
66%
13,046,911
13,046,911
-
TOTAL REQUIREMENTS
23,490,350
17,844,943
5,645,407
75%
57%
31,320,466
25,112,126
6,208,340
NET (Resources - Requirements)
1,535,002
13,317,115
11,782,113
30,000
8,303,933
8,273,933
Beginning NWC per Requested Budget
8,300,000
a) Projection based on actual collections through November 30, 2009.
b) Year to date includes annual PILT payment of $467,230.
c) Includes 3 quarters of A & T Grant: Assessor-$578,561, Tax-$136,261 and BOPTA-$11,441.
d) Significant foreclosure and refinancing recordings.
e) Unexpended VET grant repaid to ODVA.
f) Year to date includes expenditures paid annually.
COMM JUSTICE-JUVENILE
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,085,000
$ 1,200,041
$ 115,041
100%
111%
$ 1,085,000
$ 1,200,041
$ 115,041
Revenues
Federal Grants
23,831
49,786
25,955
75%
157%
a)
31,775
53,490
21,715
SB #1065-Court Assess.
45,000
38,357
(6,643)
75%
64%
60,000
55,000
(5,000)
Discovery Fee
12,000
10,917
(1,083)
75%
68%
16,000
13,500
(2,500)
Food Subsidy
22,500
19,257
(3,243)
75%
64%
b)
30,000
27,000
(3,000)
OYA Basic & Diversion
249,338
138,137
(111,201)
75%
42%
c)
332,450
340,076
7,626
Inmate/Prisoner Housing
45,000
87,257
42,257
75%
145%
d)
60,000
120,000
60,000
Inmate Commissary Fees
600
230
(370)
75%
29%
800
400
(400)
Contract Payments
156,106
54,988
(101,118)
75%
26%
e)
208,141
82,500
(125,641)
Miscellaneous
225
97
(128)
75%
32%
300
100
(200)
MIP Diversion Fees
750
225
(525)
75%
23%
1,000
400
(600)
Interest on Investments
9,750
12,821
3,071
75%
99%
13,000
16,000
3,000
Leases
1,836
1,800
(36)
75%
74%
2,448
2,400
(48)
Grants - Private
-
795
795
75%
n/a
-
795
795
Health & Human Svcs Chg
-
1,245
1,245
75%
n/a
-
2,000
2,000
CCF Interfund Grant
51,000
31,148
(19,852)
75%
46%
f)
68,000
54,495
(13,505)
Crime Prv Svcs Interfnd Grnt
15,000
10,521
(4,479)
75%
53%
f)
20,000
20,000
-
Total Revenues
632,936
457,581
(175,355)
75%
54%
843,914
788,156
(55,758)
Transfers In-General Fund
4,157,390
4,157,389
(1)
75%
75%
5,543,186
5,543,186
-
TOTAL RESOURCES
5,875,326
5,815,011
(60,315)
75%
78%
7,472,100
7,531,383
59,283
REQUIREMENTS:
Exp.
Expenditures
Community Justice-Juvenile
Personal Services
2,122,614
2,110,653
11,961
75%
75%
2,830,152
2,835,000
(4,848)
Materials and Services
991,573
815,379
176,194
75%
62%
g)
1,322,097
1,156,000
166,097
Capital Outlay
75
-
75
75%
0%
100
100
-
Juvenile Resource Center
Personal Services
1,899,116
1,732,286
166,830
75%
68%
2,532,154
2,330,000
202,154
Materials and Services
138,677
135,256
3,421
75%
73%
184,903
182,000
2,903
Capital Outlay
75
-
75
75%
0%
100
-
100
Contingency
451,946
-
451,946
75%
n/a
602,594
602,594
TOTAL REQUIREMENTS
5,604,076
4,793,574
810,502
75%
64%
7,472,100
6,503,100
969,000
NET (Resources - Requirements)
271,250
1,021,437
750,187
-
1,028,283
1,028,283
Beginning NWC per Requested Budget
987,000
a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly.
b) Food Subsidy receipts reflect payments for July-February.
c) OYA Basic and Diversion second quarter payment received in February. Payments are based on reimbursement requests
for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year.
d) Utilization of housing for juveniles by Crook County projected to exceed original estimates.
e) YTD SRS revenue for July-February. Projection reduced to reflect actual youth count at less than half of original estimate.
f) Second quarter payments received in February.
g) Positive variance a result of accruals during July of June expenses, BRS contract payments being lower than anticipated due
to low youth count in the program and a decrease in Maplestar contract for youth services.
SHERIFF - Fund 255
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
Total Revenues
TOTALRESOURCES
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
$ - $ 183,677 $ 183,677 100%
15,182,202 12,293,742 (2,888,460) 75%
9,537,992 8,187,683 (1,350,309) 75%
- 19,946 19,946 75%
24,720,194 20,501,372 (4,218,822) 75%
24,720,194 20,685,048 (4,035,146) 75%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
n/a $ - $ 183,677 $ 183,677
61% a) 20,242,936 17,259,242 (2,983,694)
64% a) 12,717,322 11,123,867 (1,593,455)
n/a - 35,000 35,000
62% 32,960,258 28,418,109 (4,542,149)
63% 32,960,258 28,601,786 (4,358,472)
Exp.
Sheriffs Division
1,616,541
1,546,690
69,851
75%
72%
2,155,388
2,155,388
-
Civil
553,096
542,887
10,209
75%
74%
737,461
737,461
-
Automotive/Communications
1,048,413
966,366
82,047
75%
69%
1,397,884
1,397,884
-
Investigations/Evidence
1,261,745
1,106,523
155,222
75%
66%
b)
1,682,327
1,593,327
89,000
Patrol/Civil/Comm Supp
5,599,475
5,467,775
131,700
75%
73%
c)
7,465,967
7,284,967
181,000
Records
481,772
441,674
40,098
75%
69%
642,363
642,363
-
Adult Jail
6,866,183
6,099,238
766,945
75%
67%
c)
9,154,909
8,753,909
401,000
Court Security
161,931
143,180
18,751
75%
66%
215,908
215,908
-
Emergency Services
141,428
140,688
740
75%
75%
188,571
188,571
-
Special Services Division
869,018
810,771
58,247
75%
70%
1,158,690
1,158,690
-
Regional Work Center
2,053,382
1,737,638
315,744
75%
63%
c)
2,737,842
2,423,842
314,000
Training Division
300,040
243,989
56,051
75%
61%
400,053
400,053
-
Other Law Enforcement Svcs
395,777
419,220
(23,443)
75%
79%
527,702
527,702
-
Non-Departmental
347,283
447,286
(100,003)
75%
97%
463,044
463,044
-
Contingency
2,656,612
-
2,656,612
75%
n/a
3,542,149
-
3,542,149
Transfers Out
367,500
367,500
-
75%
75%
490,000
490,000
-
TOTAL REQUIREMENTS 24,720,196 20,481,426 4,238,770 75% 62% 32,960,258 28,433,109 4,527,149
NET (Resources - Requirements) (2) 203,623 203,625 - 168,677 168,677
Beginning NWC per Requested Budget
a) Revenue from LED's based on actual expenditure and adjusted quarterly.
b) Delay of employee retirement expenses to next year.
c) Personnel expenditures less than budgeted due to unfilled positions and less than planned Materials & Services.
SHERIFF 701
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Year End
Budget
Actual
Variance
FY 7/.l
Coll. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 2,470,519
$ 3,343,461
$ 872,942
75%
n/a
$ 2,470,519
$ 3,343,461
$ 872,942
Revenues
Tax Revenues - Current
11,114,777
14,256,115
3,141,338
75%
96% a)
14,819,703
14,981,411
161,708
Tax Revenues - Prior
375,000
721,268
346,268
75%
144% a)
500,000
727,128
227,128
Federal Grants
26,250
122,411
96,161
75%
350% b)
35,000
122,411
87,411
State Grant
33,867
53,616
19,749
75%
119% c)
45,156
71,488
26,332
Transp. of State Wards
3,750
-
(3,750)
75%
0%
5,000
5,000
-
SB 1145
1,290,894
1,480,995
190,101
75%
86% d)
1,721,192
1,935,336
214,144
Des. Cty Video Lottery Grant
3,750
5,000
1,250
75%
n/a
5,000
5,000
-
Des Cty Court Security
96,750
96,413
(337)
75%
75%
129,000
129,000
-
Des Cty Juvenile Contract
2,250
5,456
3,206
75%
182%
3,000
8,000
5,000
Title III Reimbursement
112,500
47,259
(65,241)
75%
n/a
150,000
150,000
-
Transport
1,500
2,585
1,085
75%
n/a
2,000
4,000
2,000
Other
-
1,320
1,320
75%
n/a
-
1,320
1,320
Claims Reimbursement
-
37,528
37,528
75%
n/a e)
-
37,528
37,528
DC Fair & Expo Center
-
2,100
2,100
75%
n/a
-
3,000
3,000
Inmate Commissary Fees
45,000
43,186
(1,814)
75%
72%
60,000
60,000
-
Work Center Work Crews
31,838
19,590
(12,248)
75%
46%
42,450
42,450
-
Concealed Handgun Classes
4,500
5,250
750
75%
88%
6,000
6,000
-
Soc Sec Incentive-Fed
3,750
9,200
5,450
75%
184%
5,000
10,000
5,000
Miscellaneous
3,000
8,312
5,312
75%
208%
4,000
10,000
6,000
Oregon Mentors
3,750
1,902
(1,848)
75%
n/a
5,000
5,000
-
Medical Services Reimb
9,000
11,594
2,594
75%
97%
12,000
12,000
-
Restitution
788
1,403
615
75%
134%
1,050
1,500
450
Sheriff Fees
120,000
157,141
37,141
75%
98%
160,000
160,000
-
Interest
21,250
40,934
19,684
75%
144%
28,333
46,877
18,544
Interest on Unsegregated
2,650
3,014
364
75%
85%
3,533
3,533
-
Rentals
22,499
60,030
37,531
75%
200% f)
30,000
67,236
37,236
Donations
-
50
50
75%
n/a
-
50
50
Total Revenues
13,329,313
17,193,672
3,864,359
75%
97%
17,772,417
18,605,268
832,851
TOTAL RESOURCES 15,799,832 20,537,133 4,737,301 75%
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 15,182,203 12,293,742 2,888,461 75%
TOTAL REQUIREMENTS 15,182,203 12,293,742 2,888,461 75%
NET (Resources - Requirements) 617,629 8,243,391 7,625,762
Beginning NWC per Requested Budget
101% 20,242,936 21,948,729 1,705,793
-Ex P. 9/61
61% g) 20,242,936 17,259,242 2,983,694
61% 20,242,936 17,259,242 2,983,694
- 4,689,486 4,689,486
4,722,862
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG Grant received.
c) Timing of Emergency Planning grant reimbursements.
d) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget.
e) Insurance reimbursement damaged vehicle offset by replacement expense.
f) FBI relocation from Sheriffs Office has been delayed resulting in 6 months of additional rental revenue.
g) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
SHERIFF 702
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
I
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$1,287,473
$ 1,433,708
$ 146,235
75%
n/a
$1,287,473
$1,433,708
$ 146,235
Revenues
Tax Revenues - Current
5,429,776
6,984,298
1,554,522
75%
96% a)
7,239,702
7,339,633
99,931
Tax Revenues - Prior
179,250
368,104
188,854
75%
154% a)
239,000
370,961
131,961
Federal Grants
1,500
64,258
62,758
75%
3213% b)
2,000
64,258
62,258
US Forest Service
57,375
51,000
(6,375)
75%
67%
76,500
76,500
-
State Grant
140,725
121,962
(18,763)
75%
65%
187,633
187,633
-
SB #1065 Court Assessment
50,250
38,357
(11,893)
75%
57%
67,000
67,000
-
Marine Board License Fee
93,351
78,500
(14,851)
75%
63%
124,468
124,468
-
Grants
-
3,468
3,468
75%
n/a
-
3,468
3,468
Des Cty General Fund Grnt
647,372
10,000
(637,372)
75%
1%
863,163
863,163
-
Des Cty Transient Room Tax
1,340,128
1,340,128
-
75%
75%
1,786,837
1,786,837
-
City of Sisters
315,011
312,011
(3,000)
75%
74% c)
420,015
416,016
(3,999)
Des Cty Tax/Fin Contract
750
1,405
655
75%
141%
1,000
1,405
405
Des Cty CDD Contract
20,387
20,387
-
75%
75%
27,183
27,183
-
Des Cty Solid Waste Contr
61,161
61,160
(1)
75%
75%
81,548
81,548
-
Des Cty Clerk/Election
1,500
1,428
(72)
75%
71%
2,000
2,000
-
School Districts
75,000
34,252
(40,748)
75%
n/a d)
100,000
100,000
-
Claims Reimbursement
-
36,232
36,232
75%
n/a e)
36,232
36,232
Security & Traffic Reimb
9,750
7,871
(1,879)
75%
61%
13,000
13,000
-
Seat Belt Program
4,500
6,575
2,075
75%
110%
6,000
7,500
1,500
Miscellaneous
7,500
7,680
180
75%
77%
10,000
10,000
-
Sheriff Fees
3,750
9,388
5,638
75%
188%
5,000
10,000
5,000
Court Fines & Fees
63,750
91,919
28,169
75%
108%
85,000
110,000
25,000
Impound Fees
56,250
9,100
(47,150)
75%
12% f)
75,000
13,371
(61,629)
Restitution - Street Crimes
-
500
500
75%
n/a
-
500
500
Seizure/Forfeiture
-
1,122
1,122
75%
n/a
-
2,500
2,500
Interest
7,500
12,139
4,639
75%
121%
10,000
12,833
2,833
Interest on Unsegregated
1,350
1,476
126
75%
82%
1,800
1,800
-
Sale of Reportable Assets
-
6,779
6,779
75%
n/a
-
8,000
8,000
Sale of Equip & Material
4,500
11,657
7,157
75%
194%
6,000
12,000
6,000
Total Revenues
8,572,386
9,693,156
1,120,770
75%
85%
11,429,849
11,749,809
319,960
TOTAL RESOURCES
9,859,859
11,126,864
1,267,005
75%
87%
12,717,322
13,183,517
466,195
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 9,537,992 8,187,683 1,350,309 75%
TOTAL REQUIREMENTS 9,537,992 8,187,683 1,350,309 75%
NET (Resources - Requirements) 321,867 2,939,180 2,617,313
Beginning NWC per Requested Budget
Exp. 9/61
64% g) 12,717,322 11,123,867 1,593,455
64% 12,717,322 11,123,867 1,593,455
- 2,059,650 2,059,650
1,905,939
a) Projection based on actual collections through November 30, 2009.
b) Unplanned JAG grant received and higher than planned HIDTA reimbursements.
c) Actual escalation increase to Sisters law enforcement contract will be less than estimated for the budget.
d) YTD variance due to timing of revenue and expenses.
e) Insurance reimbursement damaged vehicle offset by replacement expense.
f) Change in law resulting in less impound fee revenue.
g) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly.
PUBLIC HEALTH
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Medicare Reimbursement
State Grant
Child Dev & Rehab Center
State Miscellaneous
OMAP
Family Planning Exp Proj
Grants
FY 2008-2009
Miscellaneous
Patient Insurance Fees
Health Dept/Patient Fees
Vital Records-Birth
Vital Records-Death
Interest on Investments
Donations
Interfund Contract
Administrative Fee
Drug Court Byrne
Total Revenues
Year to Date
I Budget
Actual
Variance
FY %
Coll. %
$ 900,000 $ 1,120,355 $ 220,355 100% 124%
Revised Year End
Budget Projection Variance
$ 900,000 $ 1,120,355 $ 220,355
Transfers In-Reserve Fund
Transfers In-General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
3,000
50
(2,950)
75%
1%
4,000
4,000
-
1,854,972
1,697,782
(157,190)
75%
69%
a)
2,473,296
2,478,349
5,053
26,053
15,379
(10,674)
75%
44%
34,737
30,759
(3,978)
159,930
149,057
(10,873)
75%
70%
213,240
227,646
14,406
227,250
386,480
159,230
75%
128%
303,000
495,000
192,000
356,250
365,180
8,930
75%
77%
475,000
475,000
-
-
45,520
45,520
75%
n/a
b)
-
45,520
45,520
-
4,568
4,568
75%
n/a
-
4,568
4,568
-
2,440
2,440
75%
n/a
-
2,440
2,440
100,350
124,418
24,068
75%
93%
133,800
156,119
22,319
114,113
95,784
(18,329)
75%
63%
152,150
124,000
(28,150)
27,000
22,565
(4,435)
75%
63%
36,000
30,000
(6,000)
73,500
71,005
(2,495)
75%
72%
98,000
95,150
(2,850)
28,500
12,288
(16,212)
75%
32%
38,000
16,180
(21,820)
6,600
41,809
35,209
75%
475%
8,800
42,000
33,200
98,831
42,075
(56,756)
75%
32%
c)
131,774
75,887
(55,887)
20,250
20,250
-
75%
75%
27,000
27,000
-
-
11,733
11,733
75%
n/a
-
30,061
30,061
3,096,599
3,108,383
11,784
75%
75%
4,128,797
4,359,679
230,882
18,750
25,000
6,250
75%
100%
25,000
25,000
-
1,738,323
1,738,323
-
75%
75%
2,317,765
2,317,765
-
5,753,672
5,992,061
232,139
75%
81%
7,371,562
7,822,799
451,237
Exp.
3,379,322
3,150,026
229,296
75%
70% a)
4,505,762
4,300,000
205,762
1,326,634
1,097,750
228,884
75%
62% a)
1,768,845
1,842,151
(73,306)
27,677
-
27,677
75%
0%
36,902
36,902
-
112,500
112,500
-
75%
75%
150,000
150,000
-
682,540
-
682,540
75%
n/a
910,053
-
910,053
5,528,673
4,360,276
1,168,397
75%
59%
7,371,562
6,329,053
1,042,509
224,999
1,631,785
1,400,536
-
1,493,746
1,493,746
Beginning NWC per Requested Budget
1,100,000
a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 6. Grant appropriation for revisions in process.
b) Grants for HIV and Chronic Care were not included in FY 2010 budget.
c) Public Health Nurse 11 for Juvenile, reduced to .60 FTE from .75 FTE. Contract is for actual expenditure.
BEHAVIORAL HEALTH
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Marriage Licenses
Divorce Filing Fees
Domestic Partnership Fee
Federal Grants
State Grants
State Miscellaneous
Title 19
Liquor Revenue
School Districts
Miscellaneous
Patient Insurance Fees
Patient Fees
Seizure/Forfeiture
Interest on Investments
Rentals
Donations
Interfund Contract
Administrative Fee
Comm. on Children & Fam
Crime Prevention Services
Year to Date
Budget
Actual
Variance
FY % Coll. %
$ 2,725,000 $ 2,589,996 $ (135,004) 100% 95%
4,125
3,675
(450)
93,750
93,976
226
1,500
90
(1,410)
74,864
75,168
304
3,957,815
4,162,558
204,743
138,537
105,276
(33,261)
225,529
77,680
(147,849)
79,500
77,560
(1,940)
52,500
56,967
4,467
30,600
47,706
17,106
185,625
89,772
(95,853)
8,625
2,323
(6,302)
-
13,129
13,129
24,000
30,945
6,945
12,375
10,625
(1,750)
2,250
7,000
4,750
2,340
-
(2,340)
2,276,216
2,250,051
(26,165)
16,500
-
(16,500)
95,250
72,364
(22,886)
R
L evised Year End
Budget Projection Variance
$ 2,725,000 $ 2,589,996 $ (135,004)
75%
67%
5,500
5,500
-
75%
75%
125,000
125,000
-
75%
5%
2,000
200
(1,800)
75%
75%
a)
99,819
99,819
-
75%
79%
b)
5,277,086
5,351,224
74,138
75%
57%
184,716
184,716
-
75%
26%
c)
300,705
200,000
(100,705)
75%
73%
106,000
130,000
24,000
75%
81%
70,000
78,900
8,900
75%
117%
40,800
50,000
9,200
75%
36%
247,500
150,000
(97,500)
75%
20%
11,500
5,000
(6,500)
75%
n/a
-
13,129
13,129
75%
97%
32,000
45,000
13,000
75%
64%
16,500
16,500
-
75%
233%
3,000
7,000
4,000
75%
0%
3,120
(3,120)
75%
74%
3,034,954
3,031,954
(3,000)
75%
0%
22,000
-
(22,000)
75%
57%
a)
127,000
127,000
-
Total Revenues
7,281,901
7,176,865
(105,036)
75%
74%
9,709,200
9,620,942
(88,258)
Transfers In-General Fund
987,119
975,458
(11,661)
75%
74%
1,316,158
1,316,158
-
Transfers In-Other
191,727
284,011
92,284
75%
111%
255,636
363,129
107,493
TOTAL RESOURCES
11,185,747
11,026,330
(159,417)
75%
79%
14,005,994
13,890,225
(115,769)
REQUIREMENTS:
Exp.
Expenditures
Personal Services
5,980,484
5,488,424
492,060
75%
69% d)
7,973,979
7,470,661
503,318
Materials and Services
3,040,136
2,560,616
479,520
75%
63%
4,053,514
3,653,514
400,000
Capital Outlay
60,000
-
60,000
75%
0%
80,000
-
80,000
Transfers Out
112,500
112,500
-
75%
75%
150,000
150,000
-
Contingency
1,311,376
-
1,311,376
75%
n/a
1,748,501
-
1,748,501
TOTAL REQUIREMENTS
10,504,496
8,161,540
2,342,956
75%
58%
14,005,994
11,274,175
2,731,819
NET (Resources - Requirements)
681,251
2,864,790
2,183,539
-
2,616,050
2,616,050
Beginning NWC per Requested
Budget
2,616,050
a) Grant billing received quarterly, in arrears.
b) Department of Human Services Grant projected at amended contract amount for FY 2010.
c) Delay in payment due to problems with the State MMIS software system.
d) 10% reduction in hours through 12/31/09.
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
I
I
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
2,738
13,143
10,405
75%
360%
a)
3,650
17,500
13,850
Admin-GIS
1,556
22,585
21,029
75%
1088%
b)
2,075
38,150
36,075
Admin-Code Enforcement
142,088
124,204
(17,884)
75%
66%
c)
189,450
168,250
(21,200)
Building Safety
731,081
675,789
(55,292)
75%
69%
c)
974,775
926,400
(48,375)
Electrical
210,375
192,448
(17,927)
75%
69%
c)
280,500
255,950
(24,550)
Contract Services
191,625
98,161
(93,464)
75%
38%
d)
255,500
163,700
(91,800)
Env Health-On Site Prog
219,638
167,931
(51,708)
75%
57%
c)
292,850
222,400
(70,450)
Env Health-Lic Facilities
517,856
652,753
134,897
75%
95%
e)
690,475
698,300
7,825
Env Health - Drinking H2O
71,483
73,508
2,025
75%
77%
f)
95,311
95,300
(11)
Planning-Current
738,113
477,096
(261,017)
75%
48%
c)
984,150
654,300
(329,850)
Planning-Long Range
321,675
247,757
(73,918)
75%
58%
c)
428,900
340,650
(88,250)
Total Revenues
3,148,228
2,745,375
(402,853)
75%
65%
4,197,636
3,580,900
(616,736)
Trans In-GF
912,470
1,027,205
114,735
0%
n/a
1,216,627
1,216,627
-
Trans In-GF for Lng Rng Ping
225,000
225,000
-
0%
n/a
300,000
300,000
-
Trans In-Other
86,849
-
(86,849)
0%
0%
115,799
114,734
(1,065)
TOTAL RESOURCES
4,786,018
4,627,238
(158,780)
75%
74%
6,243,533
5,841,920
(401,613)
REQUIREMENTS:
Exp.
EXPENDITURES & TRANSFERS
Admin-Operations
1,281,084
1,232,611
48,473
75%
72%
g)
1,708,112
1,640,551
67,561
Admin-GIS
161,705
152,531
9,174
75%
71%
215,606
210,420
5,186
Admin-Code Enforcement
135,727
127,083
8,644
75%
70%
g)
180,969
156,688
24,281
Building Safety
543,859
507,270
36,589
75%
70%
g)
725,145
613,244
111,901
Electrical
155,039
144,835
10,204
75%
70%
g)
206,719
187,846
18,873
Contract Services
198,586
190,575
8,011
75%
72%
g)
264,781
245,643
19,138
Env Health-On Site Pgm
180,515
173,054
7,461
75%
72%
240,687
233,730
6,957
Env Health-Lic Facilities
371,960
378,080
(6,120)
75%
76%
h)
495,946
496,146
(200)
Env Health - Drinking H2O
60,449
61,757
(1,308)
75%
77%
h)
80,598
82,069
(1,471)
Planning-Current
607,337
580,957
26,380
75%
72%
g)
809,783
793,139
16,644
Planning-Long Range
413,871
325,941
87,930
75%
59%
551,828
457,503
94,325
Transfers Out (D/S Fund)
133,245
162,418
(29,173)
0%
91%
177,660
177,660
-
Contingency
439,274
-
439,274
75%
n/a
585,699
-
585,699
TOTAL REQUIREMENTS
4,682,651
4,037,111
645,540
75%
65%
6,243,533
5,294,639
948,894
NET (Resources - Requirements)
103,367
590,127
486,760
-
547,281
547,281
Beginning NWC per Requested Budget
474,246
Revenues
Expenditures
Net from Operations
2,745,375
4,037,111
(1,291,737)
3,580,900
5,294,639
(1,713,739)
a) Revenues are higher than budgeted due to interest earnings on positive fund balance.
b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT-Web Programmer.
c) Projections are below budget due to recent volume downturns in the fall and winter.
d) Significant drop-off in City of Redmond work.
e) Revenue is received primarily in December through February following mailing of license renewal statements.
f) Payments from State DHS are received irregularly.
g) Projection reflects layoffs/hour reductions effective in February and the Building Official retirement in November..
h) Due to classification changes and salary adjustments, it is expected that total budget will be slightly exceeded.
ROAD
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Reimbursements
System Development Chrg
Mineral Lease Royalties
Forest Receipts
State Grant
State Miscellaneous
Motor Vehicle Revenue
City of Bend
City of Redmond
City of Sisters
City of La Pine
Admin Recovery (SDC)
Miscellaneous
Road Vacations
Interest on Investments
Other Bank/LGIP Interest
Parking Fees
Interfund Contract
Equipment Repairs
Vehicle Repairs
Vegetation Management
Inter-fund: Forester
Car Washes
Car Rental
Sale of Eqp & Material
Total Revenues
Year to Date Year End
Budget Actual Variance FY % Coll. % Bud et Pro'ection Variance
$4,871,665 $ 4,891,649 $ 19,984 100% 100%
367,500
-
(367,500)
75%
0%
-
462
462
75%
n/a
7,500
31,462
23,962
75%
315%
1,861,500
2,482,350
620,850
75%
100%
a)
311,608
-
(311,608)
75%
0%
-
54,322
54,322
75%
n/a
6,000,000
5,644,200
(355,800)
75%
71%
168,750
279,019
110,269
75%
124%
b)
187,500
316,603
129,103
75%
127%
b)
7,500
-
(7,500)
75%
0%
b)
7,500
-
(7,500)
75%
n/a
b)
375
1,121
746
75%
n/a
97,500
20,957
(76,543)
75%
16%
750
500
(250)
75%
50%
37,500
36,475
(1,025)
75%
73%
-
1,555
1,555
75%
n/a
-
225
225
75%
n/a
525,000
-
(525,000)
75%
0%
c)
206,250
177,623
(28,627)
75%
65%
67,500
-
(67,500)
75%
0%
c)
26,250
-
(26,250)
75%
0%
c)
16,500
-
(16,500)
75%
0%
c)
1,875
2,000
125
75%
80%
-
406
406
75%
n/a
600,000
491,830
(108,170)
75%
61%
10,498,858
9,541,110
(957,748)
75%
68%
$ 4,871,665 $ 4,891,649 $ 19,984
490,000
12,154
(477,846)
-
462
462
10,000
31,462
21,462
2,482,000
2,482,350
350
415,477
-
(415,477)
-
54,322
54,322
8,000,000
8,000,000
-
225,000
281,000
56,000
250,000
316,603
66,603
10,000
10,000
-
10,000
10,000
-
500
1,200
700
130,000
156,075
26,075
1,000
1,000
-
50,000
40,000
(10,000)
-
1,600
1,600
-
375
375
700,000
730,000
30,000
275,000
245,000
(30,000)
90,000
90,000
-
35,000
20,000
(15,000)
22,000
22,000
-
2,500
3,300
800
-
500
500
800,000
568,175
(231,825)
13,998,477
13,077,578
(920,899)
Trans in - CDD
13,643
- (13,643) 75% 0%
18,190
18,190 -
Trans In - Solid Waste
531,426
531,426 - 75% 75% d)
708,567
708,567 -
Trans In - Transp SDC
56,250
56,250 - 75% 75% d)
75,000
75,000 -
Trans In-Road Imp Res
7,500
- (7,500) 75% 0% c)
10,000
10,000 -
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
15,923,092 15,020,435 (958,907) 75% 81% 19,681,899 18,780,984 (900,915)
Exp.
4,249,030
3,936,156 312,874
75%
69%
5,665,373
5,311,065
354,308
6,849,908
5,339,681 1,510,227
75%
58% e)
9,133,210
8,354,124
779,086
2,025,000
1,270,703 754,297
75%
47%
2,700,000
1,283,914
1,416,086
300,000
- 300,000
75%
0%
400,000
400,000
-
1,337,487
- 1,337,487
75%
n/a
1,783,316
-
1,783,316
14,761,425 10,546,540 4,214,885 75% 54%
NET (Resources - Requirements) 1,161,667 4,473,895 3,255,978
Beginning NWC per Requested Budget
a) Annual payment, $2,482,350, received January 15, 2010.
b) Billed upon completion of work.
c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430.
d) Transfer made quarterly.
e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays
19,681,899 15,349,103 4,332,796
- 3,431,881 3,431,881
3,430,429
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 467,892
$ 487,674
$ 19,782
100%
104%
$ 467,892
$ 487,674
$ 19,782
Revenues
DOC Measure 57
162,979
217,350
54,371
75%
100%
a)
217,305
217,350
45
State Miscellaneous
6,000
4,301
(1,699)
75%
54%
b)
8,000
4,301
(3,699)
Alternate Incarceration
-
30,918
30,918
75%
n/a
c)
-
30,918
30,918
State Subsidy
22,125
9,980
(12,145)
75%
34%
c)
29,500
13,306
(16,194)
SB 1145
2,129,944
2,221,492
91,548
75%
78%
d)
2,839,925
2,961,990
122,065
Probation Work Crew Fees
30,000
26,300
(3,700)
75%
66%
40,000
35,000
(5,000)
Miscellaneous
2,250
4,620
2,370
75%
154%
3,000
5,000
2,000
Electronic Monitoring Fee
120,000
143,939
23,939
75%
90%
e)
160,000
175,000
15,000
Probation Superv. Fees
165,000
177,680
12,680
75%
81%
220,000
220,000
-
Interest on Investments
6,750
9,423
2,673
75%
105%
9,000
12,564
3,564
Interfund - Sheriff
37,500
37,500
-
75%
75%
50,000
50,000
-
Crime Prevention Services
37,500
25,000
(12,500)
75%
50%
f)
50,000
50,000
-
Total Revenues
2,720,048
2,908,503
188,455
75%
80%
3,626,730
3,775,429
148,699
Transfers In-General Fund
86,273
86,273
-
75%
75%
115,029
115,029
-
TOTAL RESOURCES
3,274,213
3,482,450
208,237
75%
83%
4,209,651
4,378,132
168,481
REQUIREMENTS:
Exp.
Expenditures
Personal Services
2,241,059
2,106,135
134,924
75%
70%
2,988,079
2,925,079
63,000
Materials and Services
594,055
534,548
59,507
75%
67%
792,073
792,073
-
Capital Outlay
30,075
-
30,075
75%
0%
40,100
40,000
100
Contingency
292,049
-
292,049
75%
n/a
389,399
389,399
TOTAL REQUIREMENTS
3,157,238
2,640,683
516,555
75%
63%
4,209,651
3,757,152
452,499
NET (Resources - Requirements)
116,975
841,767
724,792
-
620,980
620,980
Beginning NWC per Requested Budget
616,371
a) New grant, appropriated for drug addicted offenders, received January 2010.
b) Error in budget. $8,000 is the estimated amount to be received for the biennium ended June 30, 2011.
c) AIP Fund and Subsidy Fund were split in the budget year.
d) Offender population was larger than anticipated, greater portion of the state fund.
e) Electronic monitoring usage is higher from the courts.
f) Receipt of payment at the end of each quarter.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital
Revenues
Federal Grants
Title IV - Family Sup/Pres
HealthyStart Medicaid
Child Care Block Grant
Level 7 Services
HealthyStart /R-S-G
OCCF Grant
Local Government Grants
Charges for Svcs-Misc
Court Fines & Fees
Interest on Investments
Grants-Private
Video Lottery
Interfund Grants
Crime Prevention Services
Total Revenues
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ 624,543 $ 668,626 $ 44,083 100% 107%
275,850
162,341
(113,509)
75%
44%
28,239
12,545
(15,694)
75%
33%
71,250
25,585
(45,665)
75%
27%
60,956
-
(60,956)
75%
0%
131,395
167,078
35,683
75%
95%
230,683
231,693
1,010
75%
75%
460,539
379,433
(81,106)
75%
62%
-
7,849
7,849
75%
n/a
6,000
3,431
(2,569)
75%
43%
56,250
56,386
136
75%
75%
22,500
6,867
(15,633)
75%
23%
1,500
-
(1,500)
75%
0%
-
2,000
2,000
75%
n/a
140,625
103,750
(36,875)
75%
55%
55,763
30,041
(25,722)
75%
40%
1,541,550
1,188,999
(352,551)
75%
58%
$ 624,543 $ 668,626 $ 44,083
Trans from General Fund 213,250 213,250 - 75% 75%
Total Transfers in 213,250 213,250 - 75% 75%
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
2,379,343 2,070,875 (308,468) 75% 70%
Exp.
Year End
Budget Pro'ection Variance
d)
367,800
367,800
-
a)
37,652
14,907
(22,745)
95,000
95,000
-
a)
81,275
-
(81,275)
a)
175,193
257,982
82,789
a)
307,577
308,924
1,347
a)
614,052
507,183
(106,869)
e)
-
7,849
7,849
8,000
8,000
-
C)
75,000
70,000
(5,000)
f)
30,000
12,000
(18,000)
2,000
(2,000)
g)
-
2,000
2,000
187,500
187,500
-
74,350
74,350
-
2,055,399
1,913,495
(141,904)
284,333
284,333
-
284,333
284,333
-
2,964,275
2,866,454
(97,821)
404,984
396,610 8,374
75%
73% b)
539,978 526,639
13,339
1,438,382
887,816 550,566
75%
46% a,d,e)
1,917,843 1,781,413
136,430
75
- 75
75%
0%
100 -
100
379,766
- 379,766
75%
n/a
506,354 -
506,354
TOTAL REQUIREMENTS 2,223,207 1,284,426 938,781 75% 43% 2,964,275 2,308,052 656,223
NET (Resources - Requirements) 156,136 786,449 630,313 - 558,402 558,402
Beginning NWC per Requested Budget 562,762
a) Revenue projections based on final legislative allocations. Casey mini-grant of $8,800 added.
b) Personnel projection reduced due to two positions open in 1st quarter.
c) Court fees reduced for FY 2010.
d) New federal grant for the Family Access Network awarded. Some project expenses deferred to 10/11.
e) Regional project contributions from Crook & Jefferson counties.
f) Interest income lower than projected.
g) BOCC video lottery grants received instead of private grants.
SOLID WASTE
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 338,611
$ 466,325
$ 127,714
100%
138%
$ 338,611
$ 466,325
$ 127,714
Revenues
State Grant
-
37,850
37,850
75%
n/a
a)
-
37,850
37,850
Miscellaneous
22,500
19,251
(3,249)
75%
64%
30,000
26,210
(3,790)
Franchise 3% Fees
150,000
87,800
(62,200)
75%
44%
b)
200,000
200,000
-
Commercial Disp. Fees
1,047,300
634,895
(412,405)
75%
45%
c)
1,396,400
892,739
(503,661)
Private Disposal Fees
1,155,975
1,013,441
(142,534)
75%
66%
1,541,300
1,385,323
(155,977)
Franchise Disposal Fees
3,557,625
2,895,391
(662,234)
75%
61%
d)
4,743,500
3,856,124
(887,376)
Yard Debris
56,250
49,954
(6,296)
75%
67%
75,000
71,642
(3,358)
Special Waste
22,500
34,130
11,630
75%
114%
e)
30,000
37,000
7,000
Interest
10,500
10,048
(452)
75%
72%
14,000
12,500
(1,500)
Leases
-
241
241
75%
n/a
-
241
241
Sale of Carbon Credits
-
-
-
75%
n/a
-
100,000
100,000
Sale of Equip & Material
26,250
21,428
(4,822)
75%
61%
35,000
23,480
(11,520)
Total Revenues
6,048,900
4,804,429
(1,244,471)
75%
60%
8,065,200
6,643,109
(1,422,091)
TOTAL RESOURCES
6,387,511
5,270,754
(1,116,757)
75%
63%
8,403,811
7,109,434
(1,294,377)
REQUIREMENTS
Exp.
Expenditures
Personal Services
1,322,684
1,268,169
54,515
75%
72%
1,763,578
1,706,334
57,244
Materials and Services
2,811,191
2,226,685
584,506
75%
59%
f)
3,748,254
3,266,991
481,263
Debt Service
726,574
405,019
321,555
75%
42%
968,765
968,765
-
Capital Outlay
111,750
38,051
73,699
75%
26%
g)
149,000
53,460
95,540
Transfers Out
1,079,825
531,426
548,399
75%
37%
1,439,767
708,567
731,200
Contingency
250,835
-
250,835
75%
n/a
334,447
-
334,447
TOTAL REQUIREMENTS
6,302,859
4,469,350
1,833,509
75%
53%
8,403,811
6,704,117
1,699,694
NET (Resources - Requirements)
84,652
801,404
716,752
-
405,317
405,317
Beginning NWC per Requested Budget
392,509
a) Was due last fiscal year but received in FY 2010.
b) Due April 15, 2010.
c) This is largely construction waste and has not picked back up as yet.
d) Rate increase went into effect January 1, 2010.
e) Unexpected revenue from a City of Bend clean-up.
f) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year.
g) Capital item purchases are spread out throughout the fiscal year.
RISK MANAGEMENT
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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
TOTALRESOURCES
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
Settlement / Benefit
Defense
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total General Liability
PROPERTY DAMAGE
Insurance
Repair / Replacement
Total Property Damage
VEHICLE
Professional Service
Insurance
Loss Prevention
Repair / Replacement
Total Vehicle
WORKERS' COMPENSATION
Settlement / Benefit
Insurance
Loss Prevention
Miscellaneous
Total Workers' Compensation
UNEMPLOYMENT - Settlement/Benefits
Total Direct Insurance Costs
Insurance Administration:
Personal Services
Materials & Service
Capital Outlay
Total Insurance Administration
Contingency
TOTAL REQUIREMENTS
NET
NWC per Requested Budget
Year to Date
Year End
Budget Actual Variance % of Y T-1- Coll. L Budget Projection Variance
$2,491,977 $2,669,291 $177,314 100% 107%
342,723
342,707
(16)
75%
75%
214,721
214,578
(143)
75%
75%
138,146
138,146
(0)
75%
75%
641,891
641,880
(11)
75%
75%
120,143
120,152
9
75%
75%
18,750
-
(18,750)
75%
0%
7,500
121,463
113,963
75%
1215%
675
1,000
325
75%
111%
3,000
(22)
(3,022)
75%
-1%
16,500
10,920
(5,580)
75%
50%
22,500
26,355
3,855
75%
88%
1,526,549
1,617,179
90,631
75%
79%
75
-
(75)
75%
0%
4,018,601
4,286,470
267,870
75%
95%
Exp.
$2,491,977 $2,669,291 $177,314
456,964
456,964
-
286,294
286,294
-
184,195
184,195
-
855,854
855,854
-
160,191
160,191
-
25,000
25,000
-
10,000
125,000
115,000
900
1,400
500
4,000
4,000
-
22,000
22,000
-
30,000
30,000
-
2,035,398
2,150,898
115,500
100
-
(100)
4,527,475 4,820,189 292,714
61,938
1,650
307
144,381 a)
25
4,542
273,834 212,843 60,991 75% 58% 365,112 350,000 15,112
136,329 a)
121,768 b)
225,000 258,097 (33,097) 75% 86% 300,000 340,000 (40,000)
1,390
411
15,123
155,224
90,000 172,148 (82,148) 75% 143% c) 120,000 200,000 (80,000)
526,876
81,028
22,883
21,624
465,000 652,410 (187,410) 75% 105% 620,000 800,000 (180,000)
105,000 170,808 (65,808) 75% 122% d) 140,000 220,000 (80,000)
1,158,834 1,466,306 (307,472) 75% 95% 1,545,112 1,910,000 (364,888)
205,526
201,376
4,150
75%
184,870
137,813
47,056
75%
75
-
75
75%
390,470
339,189
51,281
75%
1,846,302
-
1,846,302
75%
3,395,606
1,805,495
1,590,111
75%
622,994
2,480,975
1,857,981
73%
274,034
274,034
-
56%
246,493
246,493
-
0%
100
-
100
65%
520,627
520,527
100
n/a
2,461,736
-
2,461,736
40%
4,527,475
2,430,527
2,096,948
-
2,389,662
2,389,662
2,500,000
a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October.
b) Expenditures in property damage is offset by claims reimbursement revenue.
c) Vehicle settlement is higher than expected due to 2 total vehicle losses in the Sheriffs Office.
d) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD and
Health Services.
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date Year End
Budget Actual Variance % of FY % Coll. L Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$5,137,000
$ 5,611,168
$ 474,168
100%
109%
$5,137,000
$5,611,168 $
474,168
Revenues
Property Taxes - Current
4,598,087
5,907,374
1,309,287
75%
96%
a)
6,130,782
6,208,795
78,013
Property Taxes - Prior
75,000
260,406
185,406
75%
260%
a)
100,000
270,275
170,275
State Reimbursement
18,375
4,846
(13,529)
75%
20%
b)
24,500
6,000
(18,500)
Telephone User Tax
402,000
418,350
16,350
75%
78%
536,000
536,000
-
Data Network Reimb.
25,500
26,032
532
75%
77%
c)
34,000
27,880
(6,120)
Jefferson County
21,000
38,343
17,343
75%
137%
28,000
38,343
10,343
User Fee
45,375
53,550
8,175
75%
89%
d)
60,500
60,500
-
Contract Payments
52,500
25,574
(26,926)
75%
37%
e)
70,000
26,000
(44,000)
Miscellaneous
6,375
6,586
211
75%
77%
8,500
8,500
-
Interest
27,000
66,429
39,429
75%
185%
36,000
75,000
39,000
Interest on Unsegregated Tax
2,813
1,249
(1,564)
75%
33%
3,750
3,750
-
Total Revenues
5,274,025
6,808,739
1,534,714
75%
97%
7,032,032
7,261,043
229,011
Transfers In-Other
75
-
(75)
75%
0%
100
-
(100)
TOTAL RESOURCES
10,411,025
12,419,907
2,008,882
75%
102%
12,169,132
12,872,211
703,079
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp.
2,862,215
2,603,954
258,261
75%
68%
3,816,287
3,606,287
210,000
967,142
692,078
275,064
75%
54%
1,289,522
1,289,522
-
131,250
13,830
117,420
75%
8%
175,000
175,000
-
1,454,204
1,938,939
(484,735)
75%
100%
1,938,939
1,938,939
-
3,712,038
-
3,712,038
75%
n/a
4,949,384
-
4,949,384
9,126,849
5,248,801
3,878,048
75%
43%
12,169,132
7,009,748
5,159,384
1,284,176
7,171,106
5,886,930
-
5,862,463
5,862,463
Beginning NWC per Requested Budget
a) Projection based on actual collections through November 30, 2009.
b) Less activity being performed.
c) Annual billings.
d) 12% of collections came from an unanticipated/temporary COIDC contract: 4/1/09-11/30/09
e) Less contract activity with law enforcement agencies.
5,861,335
Health Benefits Trust
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Bud et'
Projection
Variance
RESOURCES
Beg. Net Working Capital
$17,894,797
$ 17,894,797
$ (0)
100%
100%
$17,894,797
$17,894,797
$ (0)
Revenues:
Internal Premium Charges
7,860,000
7,872,801
12,801
75%
75%
a)
10,480,000
10,486,092
6,092
P/T Emp - Add'I Prem
41,250
33,937
(7,313)
75%
62%
55,000
55,000
-
Employee Prem Contribution
247,500
256,213
8,713
75%
78%
330,000
330,000
-
COIC
750,000
831,953
81,953
75%
83%
1,000,000
1,070,000
70,000
Retiree / COBRA Co-Pay
375,000
449,133
74,133
75%
90%
500,000
565,000
65,000
Prescription Rebates
-
12,389
12,389
75%
n/a
-
12,389
12,389
Interest
168,750
168,031
(719)
75%
75%
225,000
225,000
-
Total Revenues
9,442,500
9,624,459
181,959
75%
76%
12,590,000
12,743,481
153,481
TOTAL RESOURCES
27,337,297
27,519,255
181,958
92%
90%
30,484,797
30,638,278
153,481
REQUIREMENTS
Exp.
Expenditures:
Personal Services
81,973
77,810
4,162
75%
71%
109,297
109,297
-
Materials & Services
Conferences and Seminars
2,250
530
1,720
75%
18%
3,000
3,000
-
Claims Paid-Medical/Rx
10,685,682
8,421,791
2,263,891
75%
59%
b)
14,247,576
11,229,055
3,018,521
Claims Paid-Dental/Vision
1,366,500
1,295,123
71,377
75%
71%
b)
1,822,000
1,726,831
95,169
Refunds
-
(75,161)
75,161
75%
n/a
-
(75,161)
75,161
Insurance Expense
279,405
279,776
(371)
75%
75%
372,540
372,540
-
State Assessments
8,625
68,989
(60,364)
75%
n/a
c)
11,500
11,500
-
Administration Fee
219,573
285,096
(65,523)
75%
97%
292,764
292,764
-
PPO Fee
61,236
28,231
33,005
75%
35%
81,648
81,648
-
Health Impact
37,179
37,290
(111)
75%
75%
49,572
49,572
-
Printing
7,500
3,479
4,021
75%
35%
10,000
10,000
-
Program Supplies
75,000
1,239
73,761
75%
1%
100,000
100,000
-
Other
21,794
20,265
1,530
75%
70%
29,059
29,059
-
Total Materials & Services
12,764,744
10,366,648
2,398,097
75%
61%
17,019,659
13,830,808
3,188,851
Capital Outlay
-
-
-
75%
0%
100
-
100
Contingency
10,016,806
-
10,016,806
75%
0%
13,355,741
-
13,355,741
TOTAL REQUIREMENTS
22,863,523
10,444,458
12,419,065
75%
34%
30,484,797
13,940,105
16,544,692
NET (Resources - Requirements) 4,473,774 17,074,797 12,601,023 - 16,698,173 16,698,173
* Proposed revisions to FY 2010 original budget
Beginning NWC per Requested Budget 16,400,000
a) Amount budgeted to be transferred from operating funds for FY 2010.
b) Projection based on annualizing 39 weeks of claims paid. YTD actual is $247,224 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
L O
y
U°(o4
d L N M
0 c
0
M
CO C L
x
w p
O
C .~-O)L.
(0 'O 7
C O O
ILL L-' O
X O N
> w O r
7 ~ N
n
U C aQ
a1 O~U
7 K Z
L o~0
Q « F U
m
OQ0
T a
2
V ^
N N
c
C C
N ~
>
O
O ~
N 7
LL
m
0+
O 6 f
N 7 f
LL Q
C
is
U
Q
c
Q
m
O w
Q
} v
0
L
7
LL
r
7
d
E
0
z
O
O
m
7
Q
'':(P OO OO O M O.
O NOO
7
OOOO'.
N A
O O co O N O
:
W'O CA.~ ON 7'
N
'.N
A:O
co o u7 O
Lo O
O a0 '.O M
A.(O'fM (O'., '
v tO
'd'.V'Q.
CA N OT W
Z O
w
'o v
V co c
vi
cm (o 'M r
m N
'A t0'I
co
O O O O'.O O 010 O O O'.
0) 7I0 M
M'
O O ' 01W
(n N O'I~ N N
1
e q:
O O
O O'IO O O O CIO pp
to,O A
A.
O N O'. 00
'
O C3
C N
'.)O O
:O N
'
O O.O O O.M O O w
'
'
'
-
A1O.i ~
7
CA
'
O.7
. 1O"-
0) A.O 7 7 O)
010
O
7
. 0(~
.A M 0 N
N
'.O 7 0f
'
O'
7M 7
V
NM1
t0
O
CO
CD
O (o' N O
A00 -
r N 01"A to 10
0)NaD Of N
NIN
1
C41
00: LO I
~
O
O Cn A 7.,O O
'
M N'.
O
FA
N O'.O -
0) to O O O N
sl
t0
;CdO
'N )
7 co) (3) ON tn'
0'. 10 00c0,0 OlO.
NMI
V,O., '
O
It
O
a
MO:OCoa0,
N O,M M
(0O'101O
(7 A 0100 M
0)
CO,
:O
O
A(0 C`7 (O, Lo 7.
MIt N'
7
00'A,
AIO
(O'
O'.
N M M O'
A:N 101O D M'.
I
NI
O LO
(O
,
,
A
N
7 ~
~
v
aD
CA
A
r
04
C4
cm
0 O
:O O
O O O O O
O O A
O
O
MI
-
~ 0 is N
'
c) N M
1
a
A-_-
(OM
. N
' 00 O.' M(O:
O
rM''
M
O
M
M
O
. A
O".'
CO
O
7O M
O
O
N
1
N
'
7''
'
(+f
N
c TI
'
'
0) O Cl1
trj
r
. A
(017
7
C
M
7 co
V-
0
00 CC) ch
:0: (D cl)
'
-N
O
O
M n
M
C
N
' Co
~
W
N
1
O
' C
O
A 1'
N A (O! , N
007,'
M
A1.
O 1 Cni
I
N
I
A
O)
O 7
'
7
I
N I
I
1
I
O
O
O'O O O
t0I
'
0 0 0 04: M
O.O',
M'
O
M
!
co
0
OD
O
.
!
' (O 'O O O'I ' I ' M O'.
:0,
1A M'.
O
M
y)',
O
t0
V
0)
(o N f~
M
O M O O O M
A
M
CA
I vi
O.
N 010 O O.
7 M':.
O 7 OI,O O O
7 A10,0 O A
CD
'YY
N
1 O O,
0
, p
'
N
'
'
04 q M 110
'
v
h
7
010 00 GO
O p
O
(OI
I
j
r
N
,c- N 10 M O)
,
'N'. O' 171 01
M'
N aD
.
A M..
:
O
.
N M
M
f
l
7 C. A'.
O
OD 1
~
7 ~'I OD CO (O O).
O
C
.
A'.
.
O M
N
. C-41
CO 0 0 0 1 O O'
,
I
7
A
N
'
t0
a l
1
- t0
O N O t0
I
O
'
'M
,O A
' O
f'0
0 , 01
'IO ' A',
7 7
.
7
co
GO
00
OI,
O O) O
GO
7 O ' O r
.A,
'.0..
N
to:.-- r O',i L0_; PI
N
M
MI,
rn OII ~ O .n~
ta'.
'
1
_
A-N-_
n
-
N
.
1 1
1
A
N
'M
M A 7
O coj
M'.. A O)''. 7 OI
C
A p
M
(
M.
0
O M
co
tD
t0
N
1
,
CO.
f
M
1
U
:
!
ac
'I
O
N
00
O M'
o
O
)
.
O
V
O
co
D U) N O.. O'I
'
O O
L9)
Yf'.
OI O:
O O.
CO
co
M
7 0);O
' N AI.
'~M " A,7 ' M NI.
7 00
A. A'.'
N
'CO'
O'.
g
O O~
p ' O,
t0
:M
M
CA 4
N
A
co
CM
O CV
O'..
N
O IT
0
W .
L. O to
IC4
,
-
O
M
M O O
'
N O
'
O
O
O
A
Co CA
(O
7
A
'.M
N
7 (0 O
M
OI
1
7 7
w
O
O M
t
W N O O
:
I
II
O
G
O
M
CA
I,,.
r
1
1
H
_
.
.
I'
1
.
'O
M. A 0
D0
0 rn r OI
O
O
(0171
71
co
NI
O
'
r
1~
CV
AGO
'.<n
1
GO',
of ' 0
O
,
MAI '
7
N'
M
U
IQ'I,
,
co
p
IMI
C
O
(
o
M
O
'e
q
,
,
O
A
OD I tO I
O
7
O" a07
' cc
1
O'I O 1,
03
(OI
1 of 1
C14! W:
1:
I
d'
I I. '
I
II O I
,
-
'
-
~
M V'
N
N
r N
N
N,
N.
.
co
O
W A
M
,
I
,
)NO i,
A
1
I
I i0''I
W O A
O ~
M I
N
I N 1
N
N
O
to n
1
1
tCl
to 't
A M- 10
IGO
104 .
O 0:
M
o
0.07D ' (A
1 M
0 7( OO O, '
N
Yf
7
V O
M
0
IO
0
(
.
0
0
R
c n,
_
r
es'
M
R
W
N
O.
'1
7
0
co .0O'
1
O M'. O
a0
GO
~I
O
t0
Cp 1`
N O A I
I
O)
' P
c
N O' O
A NI ' O
O'.
M
O O
N
' 1
1 '
OlI
M
O'!
I
I
M 1
ao', c 4I
OCO
O
-
IO
C-4 11
C)i
O
,Cp
a0
I
1
I,I
7,~ I'I
'N
01
11 'A
rn
(D
1
r
-
.6
ro.
1
>
' c
$
y Q. y y m
w
4V .T. N U ID U W.
m l
d '
C
O I CD
t0 .
m Z Iii
jp1 N w
C C N
I
C i
41>rQ)0 ,(L~~c~°
coa~c
ola. > N CA O 3..'U
(1)
lY O 1G.3
2
cp
ac ~1LlwQ rna a) m.~~ a)10..
I
~
" 0
a of 1
06: (V
E G'.E y c c;
°
d y '
11
y ~ln-
a
5
,o
w r Itn
U x U''> ~12 F1
a 2'I0 F
l
LL
1
O
1
1
1 I
2
C
U ,I
p
'I 1,
O' _
04 O l j
O
)G
LL ~
10
y17.r 'OI CINLL LL
G
`
LL cI y11O LL1 ml oIo LL U
>n':,
LL;
!!t
t Z i1~ 01(im4-E'Ula).
A
'
-
0
0'.
0
Z'
C 1
4
) E
.21 =1 a)
O
C 00
y
V CIiiy O y CD1a) O
o'
d
l
c
c
IL -~L 01 a) a
I
l c U n' ~Q d' m
IF c
a)' m o 1 m 0)'1 E2 z
OCIO !X05o:F
w O
z~'
Deschutes County - Fair and Expo Center
YTD-Budget Basis
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
k
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 75,000
$ 42,232
$ (32,768)
100%
56%
$ 75,000
$ 42,232
$ (32,768)
Receipts:
Security & Traffic Reimb
12,000
-
(12,000)
75%
0%
12,000
-
(12,000)
Miscellaneous
3,038
3,659
621
75%
91%
4,000
4,621
621
Vending Machines
1,725
1,319
(406)
75%
57%
2,300
1,894
(406)
Telephone Fees - Events
900
-
(900)
75%
0%
1,200
300
(900)
Special Events Revenues
401,000
242,531
(158,469)
75%
45%
540,000
390,281
(149,719)
Interest
1,496
(140)
(1,636)
75%
-7%
2,000
364
(1,636)
Storage
58,000
20,396
(37,604)
75%
35%
58,000
37,011
(20,989)
Camping at F & E
2,000
1,840
(160)
75%
26%
7,000
6,840
(160)
Horse Stall Rental
4,000
2,835
(1,165)
75%
6%
45,000
43,835
(1,165)
Concession% - Food
173,000
81,459
(91,541)
75%
35%
235,000
125,177
(109,823)
Rights (Signage, etc.)
16,420
43,000
26,580
75%
50%
86,420
113,000
26,580
Donations
-
3,300
3,300
75%
n/a
-
3,300
3,300
Interfund Contract
45,000
45,000
-
75%
100%
45,000
45,000
-
Total Receipts
718,579
445,199
(273,380)
75%
43%
1,037,920
771,623
-
(266,297)
Transfers In
General Fund
148,500
148,440
(61)
75%
75%
197,919
197,919
-
Transient Room Tax
17,074
17,074
-
75%
75%
22,765
22,765
-
Welcome Center
80,000
80,000
-
75%
100%
80,000
80,000
-
County Fair (619)
197,421
80,000
(117,421)
75%
41%
a)
197,421
80,000
(117,421)
F & E Reserve (617)
-
250,000
250,000
75%
n/a
c)
-
250,000
250,000
Total Transfers In
442,995
575,514
132,519
498,105
630,684
132,579
TOTAL RESOURCES
1,236,574
1,062,944
(173,630)
75%
66%
1,611,025
1,444,538
(166,487)
REQUIREMENTS:
Exp. 9/6
Expenditures:
Personal Services
618,516
572,232
46,284
75%
69%
824,769
778,423
46,346
Materials and Services
398,493
338,117
60,376
75%
64%
b)
531,604
497,032
34,572
Debt Service
79,393
73,035
6,358
75%
63%
116,188
116,188
-
Capital Outlay
-
-
-
75%
0%
100
-
100
Transfer to Reserve Fund (617)
-
-
-
75%
0%
c)
16,412
-
16,412
Contingency
-
-
-
75%
n/a
121,952
-
121,952
TOTAL REQUIREMENTS
1,096,402
983,384
113,018
75%
61%
1,611,025
1,391,643
219,382
NET (Resources - Requirements)
140,172
79,560
(60,613)
-
52,895
52,895
Beginning NWC per Requested B
udget
2,809
a) Transfer from Annual County Fair fund will be $117,421 less than budgeted.
b) It is likely that M & S will be less than what is currently projected.
c) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund
Accrued Revenue (Accounts Receivable):
Current Month Events 30,000
Prior Months 3,731
Total Accounts Receivable 33,731
Deposits Received for Future Events:
2010:
April
24,150
May
8,965
June
2,040
FY 2011
July
32,370
August
180
September
3,350
October
2,300
November
4,550
December
275
January
100
February
300
March
250
April
1,000
May
600
FY 2012 & beyond
6,550
TOTAL
86,980
N
ti
rti
CO f~ ~M ~O~i'
M
I~ OO
t~
r
U
rt
d'
~ co co N Il- M d-
CD
00 00
00
N
P.
CA '
0~
00 ' tl c- M ' I~ ti
~
M CO O
Il
O
C1
CO
~
d'
co V q ti 00
O
N V
~
0
Cl)
C) CO
-
C14
r
M
CD
O
UD
~Oti0~ AMC) C)
O 00
O
O
r
'T 0
V
00 0 CO O f,- o0 N 0 1- M It
M
C 0 0
IT
I~
ti
N
CiC
C~
M~f N-00-MOI'f-CM
~
O 000
0
O
0
0
'•CD
11
V) It OOOIt r'--00 1
O
00 N'
O
O
M
OI:T
0
M O CO I-
M
C0 O CO
M
I-
N
C "L
O
00
M E N
O
00
to
Cfl
w
I-f
O
to
00
0
co co OIq 00 0
00
N
N
O
U
0 0
0
M O O f~ 0 0 O
CO
M
M
O
O C;)
OO
O
O't ' OO ' 00 N
CO
M ' '
M
O
'
p p
OO
O
COd OO OI
CA
O
O
O
O
CD
00 O r M O
co
O
O
C)
Q. Co
C \j
q
r
CO
I--
ti
M
CO
CD
O
O
Cfl
O f- r- to d It I- N N c M M- O 'IT N O O 00 ~
0p ~ ~ CO co M CO O M w N O I- M It N ~ 19T CO Cf
L U N 0 CA co M O I` 'It p- c M ~ I.- ti M W CD CA I- O
O CE I: O O O PI O O e-- ~ pl - 00 - 06 00 00 fl C 0-0 -f
r I` M M I-_ 00 CO C0 O T -
c N r- M O r Il- M M N
a O tD I~i O T-
U O
r
E
O M J m E M M ( ( L W
U;aL Q
U) Q: E O 0 Cs
r r r r
LVm 0 c(j
CT W
a p
~F- I-_ Il- tA OI- I-NN~MM~O,I- I- co co O to
ca ~ p T to I~M00MMNOfl- M~~ O O I1- 0
a) 0000 ooal.- ~tl.- M~r.-~MM ' t ti O
"0 ~ P L C; Ld P.: V) L6 I- N: C ~ 0 N N Ci
O (1) c O~-~ 0r co I- r CO O
m > 00. N r M r r-- N
O U X CO tD N N M M
a)
cn
U
O
U
a) N
U N
C V
U ^
N O CU N C M
O c
m > N! c E .0 CD j N m v> 06 :3 C`C lC O > O
U) w
vi 4) W i U co N d ` U 0 m N
2 a-
C -C C.
w a> > >c)" ca) 0 E & _U M mb .0 M _0
o ayi C~a"iaim._ccca~'rn'u~ po Q(
CL N Z s •c a c 't ui m~ ` r U rn ;Q x
0 "O W i O rn CD c O~ o> c 0 0 coo 3 42 c 0 O W
c ca a L c 0 0) y-0 •c TRH a)- -
w m0 0 Wm¢w~a ~ ~wQaw0 Uz0 o m
z
O O
LO
ce)
00
U
0 co
M
LO
LOO
0)
d
CA
d
CU
:3
Q
M
M
(
LO
L
a)
m
r
~
d
N O
N
0
(714
co
Cc
NT -
LO
LO
0)
to
O
N
r
r
m
0)
E
N
N
Q
C
(D
00 O
L0 0
00
l0
O
l0
N
O
N
O
O N N h LO N N O M N O LO r~ 0 O It
't r- W - O I- N O CO 0 m Mp J' M f- M
N
-
M
O
~t
Co
c
0)O
O
00
IT
O
(OtiOMOtiOLnIt 0) U) C) 't In-'T ~
°
CO
V)
Q
0
OM
M
0)
M
-
Co
r-
N
NNNi'i L .=co -tiOCocoMNCO
CDNNMO`-'~N N r
LO
r
r~
E
0
Q
0)
LO
O
M
M
o0
O
U
d
~f
04
LO rn
_0 ~
°O
a
~r
c
w
:0
LO
M M
~
U-
N
00
~ . Lo v-
O
6g
LO O
o N
NCO
r
0
0
o
co O T7 co ~ OM
O o O o N
N
a
U
O
_
00
O~~o~
~ O It
V)
°
~
~ M
fl
~.NIT O Cn 0
CD
0
0% CD 0 04 ti N~ N O o
CO Q U
Q
O
i\
L
O C:) CO
00 O O O wCo CD + ° Q ~ (D
U
CC;
N
o LOd 000 O cO
-
CD c)
a) w
U
U
Q
0)
M
co E 04 0) -
u)
64 "T a3 - 6< "
CD10od
0 N E
69
0)
Z N
j
~
O
~
-
Lo
2 C
~ E J '3 N O N (o Co 69 Cv 0 c N
-
0-
Q
LLLCCC
0
Q
O
CO
cu
0
4-- 0) 1 Y 1~ 0 64 cow c
L
O a)
N
co
L
't
N
69
O
O to c C L f/~
(fl
o N o
+
U
\ N C C O 3 CD c) N p
U
U) U
6
9
og
C O O V O 4- O co c N U L "Q
E 7
O
X
Cu
d
\
-
_
= N w O S O O L Q
•
~
p
C N
j U N N U U)
U
N W
L
0
C
>
a)
~
y
(
N O
C
CO
N
ti Co - 'o O a " N C N C_ a) m
C
atS j L O
_ C
f0
C
O
O C
L V C U
C U c: T
t~
m
Q
O X
U
g
00
t
C
U U p p ~U - 00 - p U) U
-
(B
s
w
A
C
(A
O
0
U U U= CO N ~Q0~
U
0.0
N
Q
Cm
c
2
Q Q Q 2 LL Z) O N M ~t LO 1~
M
m
c
3
E
0
k *k k *k *k *k t *k *k *k *k *k *k *k
O
F-
W'
-
O U
E
C
E
E
~
(n
~
O
U
c
06
c
O
N
`
Cn
U
L
O
ca
w
+
-
U)
c
C
U
E
U
U
_
N
fB
>
=
_
`
f/1
N
E
N U
L
U
Q
U
N
C
U
L
U
Q
O
W
W
L
G.
co
O
a)
w
75
UU
o
o
c)
~
J J
a
F-
w
~
°
CO
O
ti
C
CO
O
O
N
C
3
LL.
O
~ r
a) O
C1. N
O
n- N
U Z'
C m
a) cO
a) n
O O a)
U a LL
a) C L
Q f6 ~
~ O
1
U
a)
O
0
(0
n
(tf
U
r
0
co w
v
d o co co
- O O
to
T
ti
M
LO 't to
f- co
N 0 O
N
Lo
m
1 1 I
1 1 oc1 1
L
r M ' V CO
0) V O
' ' ' LO
Cl)
T
M Ch
M
N d v N
V h co
r
a
M
••V
r O Cl)
ti
r
N
M N r
O
Q)
0!
CD MOOco
OMtt01-
d CO OIt OOOr
WOO
OOOCO
c0
r
ti N co O M
0 0 M O M
LO 't O m Il- O O LO
LC) 0 0
0 0 0 to
O
M
I- co O O
O d' M O r
~ CM 0 It M 0 0 M
o d O
O O O O
m
V
M 0 CO L() f.
tl 1 CM N O
N O r d r O d
0 P. (fl
Ln (D Ln 0
M
M
LO O N co It
O LO N
0 LO (D
r- O M
M N T N
N
N
N CO "T w
N
ti r
CN N r
N CO LO
ti
M
co N t0
N
r
O
OMOON
OCO 0fl-
00 OOLO
f*_
0001-
N
0 N C f) 0 0
O 0 O co
0 0 O O co
h
O O O r-
w
0 [hco0N
Oq ' 0.--
' 00 0000
to '
00CD LO
N
'
000Ocnc')
NO
C5 •-ON
V
L COLIC
M
V) O N Co v
CD LO N
LO U') 't
O
M N It O
IV
N co 't 0
N
t` r
0
N 0 LA
w
M N O
M
L6
(0
w w N
M N d' O r
T M CO - O O O
CO
CO
W)
ti
ti O O
CO M r N
LO 'It O LO r- Co r
U)
)n
t0
V
t- Co m
O O M 0 LO
r M LO q~t M LO M
0 1
1 1 1 CO
m
t}
M Oqli
r r~: M t-
N ~ V-:
0
0
O
M
LC) CO r
t-
0 O
I-
fl-
co
Cl)
N M
N
d
N
N
w
0
M M
N
N
N
r
d'
It
to
to
M
M
p
O
M
1 1 1 1 .
1 I I 1
C
1 1 1 1 1 1
1
I 1 1
C
0
0
I
Ir
N
N
co
to
co
co
O
_
r
O
T
O
T
V
O 0 N
NNd O
It CO CO d CO0 CO
N
N
O
N
t` O co
r CO r N
LO ~ 0 LC) t- Co LO
LO
LO
T-
I-
~ ' ' Cfl M
M 0 M 0 LO
- CO CC7 t M CCU ' CD
CO
O
t0
t-
M O 'e
r I- CO N
N r d O
CO
CO
0;
l
V-
N O
V)
0
C
N
co
N
N_
w
P.-
m co
r
r
O
U
cn
N
a)
U O
`
.O+ d
ca
N X V
L
L
N
7
.
(n
O
U) O w d
U
a)
E
_
)
Y
m
O
'
c
C
Q) O N
'
Q U _
U) a)
C
C a)
U> it
m 0 O
O
to
a) =3
c U- d
in O a)
0)
` E
:3 m
°d d
O E
a)
3 n
'D
L
'~Y~_ v
w Q
.2
cu
w w 'L
U)
1 m
>
o
X E
mLL
r
w
a) c 0 3
c m U
E to _0
CO ~ m O
06 0) w
C
V
Co o
_
O O
H BLS f/)
)
F
o a) w
0
-
c w E
a) o o U
d
O H
= U a
0) C C
_
0
N
C n_ CT U 0 0
~
O j
U
a
CL m Q? n
z m S c
vi a
i o o
a
w
N
° N c 4 R
-0 4)
a m i c aa)) m
y aa) ) ~ r w
N c
0 3 N H
R
w
o a) ca c
X mQw1--a5
5u.¢aw02
Qz~O
ULL.H
c
d
CoLL.HSH
w~
0
t-
Z
O
O_
-0 O
C
C 7 N
OLLr-
O " cM
U .O U
O CO
-C
U c
U) O
co p
U~
r. F-
C)
y
W
V
O
N
w
w
cD
co
v v c6 v Co
M Lo 11' Lo fl-
cc
co
, o o
N O O
,
N
to
to
M
ti
M' ' M' d M'
O ~t O
to
M
M
C'7
Cl) N d
'
N
d' ti CO
(7)
M
am
O M
~
N
M N
r
O
CD
M
CD NO
1-- CO O
co
CO)
000~T OI-V 000 It COO
O CA M O 00 O Itt O CC7 1-- O
~
LID
co OO
In O O
CD
CC)
co
O
M
IlNO
O
= dq 000--c-MO V M0
00
co cT0
CD
01
T-
M N Cn
O
r
f~ r Cl) N O N r ~ It
O N O
O N CD
e)
M
h
of
NCO
0)
N
~
NN C
CD
O
ON!
co
C
N
N
C4
O N O
O CD O
N
CO
O 00 O N- cc 0
O C) O 00 co O
0
co
t-
1\
I-
I-
N
to
ONO
N
O";t ' O- ' C O
CO
Ln '
O
N
'
O N Lo
O
ti
I` - N O O r r
N O N O
N
-
m
1-
Go
N CD
CD
M
Lo
Lo
0
co
M
v
M
V
CO CO N
M N ~ O. d' M M E CD O O
Co co
Cn
ti
I- O
co
0 r M c N 0 ~t CO 0 ti CO
T-
O
Lo
CO
~
I~ ' CD
M
CD CAOctMo-M0'-tM0
M
CD
co
01
t
co CD
~
CO r-N
r-
O
T-:
O
cr
O
M
Cl
M
N
CD
N
N
COG
CMO
M
M
N
N
N
M
d
't
La
CA
M
O
O
M
M
CT
V-:
1-:
TZ
Ir:
N
N
O
O
co
r
r
r
O
r
CD co
1`
N
N N~ O 'It M M ~t CO M
'
M
N
N
O
N
O
'
co
. ~ M ~ N Lo It CO U
) 1l- co
Lo
Cn
to
e-
~
~
(
M
c e! 00 M In ~ M Cn 4- M Lo
O
CD
CD
co
t -
co (
IV
~ r- L CO N
0
00
00
01
d
N
M
N
0
0
co
N
N
w
ti
M
M
r
rn
U
O
U
O
N
C
ca
N V
a)
U
N-
4
UZ uU)
-
m M
O
U
~ c 06
O
to U)
3 c
O
O
d
i
N j N N od
W U
0
E
O
r
u
v
O
-
c6 rn
U
U > ~
,
CL
>D
7
O
(D (a
N
U O
F- X25 v fn O a U N 'N Y 0 22
O
5 0 w E U
O U'
m
O-~2 m 0 (D cm
c c c
m
v-
Q
.r
d U)
•
Z Co c c E c`a c y +o
L
c
0
U N~
N •
k
W
tV 0
c a a w
W L
0
0= 0> c 0
CT w
a c O •-US a) -0 c S H
M<WF-n
SS
WO
U) O
3:
Cu c 4 F-
M
m
O N O
.
Ii<[L
X
Z:D O
o
d
m LL - F-
w Z
U
H
Z
CO CO - O
U 000 ~ M O C) C
0 0) C~
N In 00
m O O
O N It CO ' O O CO 00
d o LO (.0 LO c LO (0 v
~ N
C co ;t
O
0 N N N Ict
E
Q
C co 0 co O O co LO o r- co Co - 0 CO CO O N O O 0 o M
N -0 - O LO O M CO CO CO O O (0 O 1- 1- N O 0 fl il-
E c00 m O o d' rn CO MVrn0LO 00LO ~000V- LO LO cA 6 t-: 0 L~ C.0 LO a0 r-CNOCOv0000~ ~O~~O~ Ct1~ C6 C6
' l
E E N N O N Ln
0 Q N N N
U
0 0
I- LO
0
Z
co co
_ W 00 U~
N
O m N _ ~ -,r 45 M
OHO O 06 O po OM
00 Cfl CD N
7 O o O o q* o co
O N 't L
~U- v rnv o N oow.
U O M c 69 p cN r- N O W.
OZL O o y n O ~Oc- U~\
6e. 0
~(n 0 N 00 0 00 O ~
0 ~ Op p 0
O
O. N O O E N O o o U 0 to
w c:)
U U d O N V o V) M M cF O ~
aZ O N E M O E 3Op ON-6"'M C C
M co 00 6o:). ce) 4- -
U Q Q 0) b04 ~O n a) cr N O 0 0) N O N 0 (D
U
m O N M p O o CA (L)
O C7
co (1)
0) U 4- L) 6N9 C C\ N .~M. cC0 O W N U)
O X C 0 o M v- O O~ C L d C 7
Z U O m M o ~ cn V O U CU 0 0 C) O~ CU d
O 7 o U m C O C N
• V Y O 75 It o (L) C N
w D O fCS co L C y (0 ~ -0 'O O Co
C C C QJ O o2S L O L U O U CA
v 0 0 C-o rnU 0) Eg E c
0 x U M U O v N v v w= `p - M E vii mc
W m- w U. c -C o
U
5 2 <
o Q FU ID~Q~iiO~o~NMtt~COaO M c
0.E O 7 E .0) M Lol`00 rr~ ~rrr 0 N
a~ 0 a OUt~t***tt*ttttttt E
c ~
E
vi 0
U
3 06
c N rn
0 N L
O N (A C
U
m
L
N U) cn n~ o U
U U CU Cn N E
- Q U -O O O
c L 0 C
c y O C w
i Q w
Q Q O E O U c w cYa
0 3 E 'rn 0
C
CU
U
CU
O
U
CU
Of O
O
C N
7
U U M
U =
co D
(D ~ c0
U .C
U 'U Cl)
I] LPL O
c L
E
co
N
H
N
3
U
a)
Cn
6
w
O
U)
w
Ix
O
O
0 0 0 0 0 O d (A
f
O
O
O
M
M
O
O
Mlzr C) O O
O
LO
LO
0
IV
It
O
Ln (fl O ~ O O) ' O)
'
O
N
N
O
I
It
f~
Il-
O 00 ~t 00 d N ~T
m
O
O
M
0
N
CO
w
Ln - ` - 0 -
00
r
O
N
r
N
N
LO
LO
M
OOOO
CD
co OOO)C'M~O~tO0)
CD
ti
0
0
C)
ti
Cl)
0 0 0 0
0
CO "t 0 ~ CO 0) O M O r
M
Ln
O
O
O
O
V
O O O O
O
Ln CO O Il C'M N O CA O CA
Ltd
O
O
O
'
O
d'
CO O N O
W
r- ~ co m 000 N N It
O
O
O
O
O
N
00
~
Ln
04 N
N
O
M
L[
I-
O
r-
N
r
r
N
OOOO
O
OOO M-0 O
CO
O
O
O
O
O
0000
0
000 COOO O
O
LO
LO
LO
0
0
O O C O
O
O C O' CM C NI O'
I~
N
N
O
O
'
M O N O
LA
I- O N Ln 0 CO N
O
0
0)
LO LO r-
N
I- r - M
Lo
00
00
N
Ln N
M
-
O
Cl
M
C %i
N
N
c0
O
r'
O O O O) N ~ Cl) It N 0
(0
CO
O
O
O
O
O M
co
CO IT C) CO O Co M M.
M
00
O
O
co
LA
LZ7 Cfl O M CA 7 O) O)
;
Ln
Ld•)
O
00
O CO
CO
N N CO CC) LO M N N d•
LO
ti
ti
N
CO
LO
In
CO N O
to
m
N
d•
r
d
r
CO
r
m
C)
0
0
C)
C)
M
M
i i
0 i
0
0
0
LO
LO
'
M CO
0
I`
~
1-
ti
M
M
r
r
r
r
O
N O M N Cl) N O)
CO
CO
'
CO)
ti
O CO M
CO ct r- CO O CO CA M ~
0) CA
01
M
' O ' r- r
CO CO ' I, C f! e- O) 7 O
L
O
O
OO
O
00 LO 00 m N ~t
O
LO
0
L) L
[
A
CO N
N
N
M
r-
N
N
O
N
U)
O
U
U
d
C
U
V
U Z
U
R
U
06
rr
c
N m 06
O
w 0)
to
3
:3
w 0 N
N'~
C m
a) r
N a) 7
ca
r- E
C
m
O)
0
C a) (
0
N C
O
N to
C
C D 0
c )
_
I-~tl L E rn'o a~ U
Q~~ d
11N
2
U O C C C ZT.N
a)
'
-a
o
3
L X
CL
Z cu c a)
2 -E C6 S
a)
Q-) w
C w N-
C cv
CD - d° 2 c c N mot a) -E: ~
w
~
o
0
R
c p
o:° w o
w~~ ~I~aQw
X ca¢
i--
roU
I-
o
d
J cn H C l-
w
U
i-
Z
O
O
O
N
d)
N
N
N
U -o
~ C
O 3
O
O N
c0 N
O
N
C
N O
,n U
0
"T O O
O w
Y co
U) N
U 1- a
64 N
N 11 ~
U
LCa ai .3
" Co
d) C,) 3
O a) N
U O
O OL
N O. p
Co "D U
C
O O
O O O
N_
N (;a
16
=3 cn
' O
E
N N U
0.° n
0 N
O N 0 ":i Q
N U IX
LO a
U N O
aaO
m m
~
r-
N00CD
M
)
M
0
'ITC
U')
OOD
C
7
CO~t
O
MOOti
N O
M
M
r
r
0
Ln
~t
C
7
LL.
U)
C ~--U W
CD_
020
4] N
Q
cq Cl)
C) C
Z L
U Q LO
V) U)
W
0 U rn
co
LL j
~U
U z
~ W
LB
N
U
a)
U)
0)
01)
C)
C
(0
0)
LA
r
0)
(
O
N
N
O
N
00
O
to
t
CD000
00
0
CO LO 00L1.)
cr
OIL
C6 L6 O
NO
N
co
Ln
-I 71
N
N
U
N
O
.r
O
C
N
U C
N
Q
U) N
N
N Co
7 ~
U ~
N ~
L E
Q ~
O N
O
U U
a) CU
N U
N (a
` C C
O O
C)
'6 E
CO
O) Q C
~0-C:U) U
a) Co
5 c CU U C
W -i c)QU
CL
O
N O O
w =
(D Q) 0)
C -C 7 to
Q Q O )
Q) CD C
CO LUQ O y m
N
C C (C6 O U)
a.dUQ=
U U
O O
C C
C C
CL d
Deschutes County - Solid Waste
Area A Closure and Cell 5 Construction
As of April 15, 2010
G. Friesen Associates, Inc.
Original Contract
Change Orders:
Change Order #1 (Note a)
Total
Paid through April 15, 2010
Balance
Construction Contract
M A DeAtley Construction Inc
Original Contract
Change Orders
Total
Paid through April 15, 2010
Balance
"Area A" I "Cell 5"
Closure Fund Projects Fund
611 613 Total
241, 869.00 182, 516.00 424, 385.00
19,656.00
- 19,656.00
261,525.00
182,516.00 444,041.00
192,775.78
113,766.79 306,542.57
68, 749.22
68, 749.21 137,498.43
2,097,140.50 3,290,779.98 5,387,920.48
2,097,140.50 3,290,779.98 5,387,920.48
2,097,14050 3,290,779.98 5,387,920.48
Total of Engineering & Construction contracts
Original Contracts 2,339,009.50
Change Orders 19,656.00
Total 2,358,665.50
Paid through April 15, 2010 192,775.78
Balance 2,165,889.72
3,473,295.98
5,812,305.48
-
19,656.00
3,473,295.98
5,831,961.48
113,766.79
306,542.57
3,359,529.19
5,525,418.91
Notes:
a) Additional landfill gas investigation per DEQ as part of a requirement
to address offsite landfill gas migration.
b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678
has been expended and reported as "Construction in Progress" on the County's
CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction,
Taylor NW, KN EX Co, Jack Robinson & Sons.
c) To date in FY 2010, payment has been made to Central Electric Co-op:
$13,311 for the Closure of Area A and $20,822 for Cell 5.
Deschutes County
Bethlehem Inn (Fund 128)
Nine Months Ended March 31, 2010
Year to Date
Year End
Budget
Actual
Variance
FY %
coil. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ (2,666,469)
$ (2,689,172)
$ (22,703)
100% 101%
$ (2,666,469)
$ (2,689,172)
$ (22,703)
Revenues
Grants - Private
2,766,469
-
(2,766,469)
67% 0%
2,766,469
-
(2,766,469)
Total Revenues
2,766,469
-
(2,766,469)
67% 0%
2,766,469
-
(2,766,469)
TOTAL RESOURCES
100,000
(2,689,172)
(2,789,172)
67% -2689%
100,000
(2,689,172)
(2,789,172)
REQUIREMENTS:
Exp.
Expenditures
Debt Service (Negative Int Rev)
100,000
26,604
73,396
67% 27% a)
100,000
34,000
66,000
TOTAL REQUIREMENTS 100,000 26,604 73,396 67% 27%
NET (Resources - Requirements) - (2,715,776) (2,715,776)
Beginning NWC per Requested Budget
a) March 2010 interest expense - $2,249.56.
b) Recap of expenditures - inception through March 31, 2010
Land/Building (Amertitle) - July 2007 $ 2,241,313
Hickman Williams
17,578
City of Bend - May 2008
250,000
KN EX CO
5,289
Kleinfelder
3,732
Total expended on facility
2,517,913
Interest on Negative Cash Balance
197,863
Total expended
$ 2,715,776
100,000 34,000 66,000
b) - (2,723,172) (2,723,172)
(2,725,000)
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2010
Jul
- -
Au
Sep
Oct
Nov
Dec
Jan
Feb
Mar
YTD Total
Tammy Baney
Conf/Sem & Educ/Traming
-
350
-
-
-
30
3
380
0
Travel Meals_
- - -
15
20
90
20
145
modations
Accommodations
595
77
-
672
Airfare
Mileaga reimbursement
-
256
-
86
573
299
T _
- - 396
- -
66
386
-
- -
2,062
Ground Transport/Parkin
- - - -
-
45
-
-
-
45
otal Bane
g
Y_-
-
56
{
86
,578
319
-
- 486
- -
66
-
483
-
30
-
3,303
Dennis Luke
Conf/Sem &
Educ/Trainin
-
9
-
50
--220
-
-
30
00
Travel
Meals -
25
-
25
113
25
57
39
286
ccommodations
-
-
77
1541
77
952
Airfare
Mileage reimbursement
-
-
329
85
257
485
210
-
361
237
1 9-6---
5
n
G rolu
d Trans Port/Parking
-
- -
-
34
-
-
-
-
-
-
34
otal Luke -
- - - - -
432
85
1 118
714 -
-
507
i
-
57 72
-3-8-3---
!
3,837
Alan Unger
Conf/Sem
& Educ/Tramm
- - -9 - -
- -
-
350
_
- -
-
- _ - f
- 30
380
Travel Meals
-
50
50
ccommo ations -
-
624
-
651
-
-
-
-
1,276
Airfare
-
i eage reimbursement
- -
-
-
-
9
78.
Ground Transport/Parking -
- -
-
-
-
-
5--6--
-
-
-
-
-
-
-
56
Total
Unger -
-
1,031
-
1,630
50
-
30
2,741
Other
~
-
onf/Sem & Educ/Traming -
~
-
-
-
-
-
- -
i
300
-
300
Total Other
-
-
-
300
-
300
Total
B000 Department--
Conf/Sem & Educ/Traming
-
-
-
700
220
-
-
300
90
1,660
Travel Meals
_ - - -
25
- -
- - -
- - -
-90
-
76
77
'
-
39
481
Accommodations -
~
77
'
1 046
- 1--16
- -
77
231
- -
77
-
2,900
Airfare
- -
Mileage Reimbursement _
585
172
831
784
606
66
747
2
37
5
005
Ground Transport
- - -
-
79
-
-
-
-
-
_
.
-
'
135
Total - BOCC Department -
687
172
-1
-
2,696
1,034
993
-
2
-142_-
_
1,355 ~
_
4 443 43
~
10'181
- -
FY 2010
Budget - - - -
-
- -
-
-
- ----i
.
22,750
Percent Expended
- -
-
-
44
8%
.
4/7/2010
RV Park (Fund 601)
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
I Year End
Budget
Actual
Variance
FY %
Coll. %
L Budget
Projection
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
118,935
61,980
(56,955)
75%
39% a)
158,580
98,580
(60,000)
RV Park Fees > 30 Days
-
9,410
9,410
75%
n/a a)
-
9,410
9,410
Restitution
-
3,611
3,611
75%
n/a
-
3,611
3,611
Washer / Dryer
600
785
185
75%
98%
800
800
-
Vending Machines
-
290
290
75%
n/a
-
290
290
City of Redmond
-
500
500
75%
n/a
-
500
500
Interest on Investments
225
284
59
75%
95%
300
300
-
Cancellation Fees
-
1,055
1,055
75%
n/a
-
1,055
1,055
Total Revenues
119,760
77,915
(41,845)
75%
49%
159,680
114,546
(45,134)
Transfers In-Fund 130
160,000
160,000
-
75%
84%
190,000
190,000
-
TOTAL RESOURCES
329,760
240,346
(89,414)
75%
60%
399,680
306,977
(92,703)
REQUIREMENTS:
Exp.
Expenditures
Materials & Services
51,570
53,351
(1,781)
75%
78%
68,760
68,760
-
Debt Service
181,928
157,883
24,045
75%
65%
242,571
242
571
-
Contingency
66,262
-
66,262
75%
n/a
88,349
,
-
88,349
TOTAL REQUIREMENTS
299,760
211,234
88,526
75%
53%
399,680
311,331
88,349
NET (Resources - Requirements)
30,000
29,112
(888)
-
(4,354)
(4,354)
Beg NWC per Requested Budget
15,000
a) Approximately 2,231 space rentals. ( $61,980+ $9,410) / $32 = 2,231)
o -0-0 o 0!~ o oll~ o lop- 10-0
o
U
C
(D Lo N -
r-
C1
0
(3) 0
0•9t 000V
4
c
0
cl
~0000N6 NN0
ti
U
N r
U
0
to
a
^
"
LC) 0 d'
) 00 0 ti CO E ~
M
~
Co m
E!T
~ M N M N
N
0 C
d
N
O of
N
tt
U-
co
co
1- LO 0
N r-
0 0
0
0
LO 0
0)
U
mIc O0MNMOLo
0'7
L
N~OpON NN CA
r
> LL
N ~ ~
~
>
\0 0 e \0 0 ° \o \o0\° \
o
\e
0
oc
0 0 0
0
0 0 0
0 O'~1.OO00CO Ln~NI-T Cl
CO 00 C) 00 CO d: LO r N Ln f` CO O
OL
.4 O 00 L6 r- O O O 4~ CO N ti
0)
U
N
O
U
0
0
N
0
r LL
C) (1)
CO U
cn
0)
N
N
OoO19T N~MOICT 0 M e C00
`
N
CV
~
00 LOMML[)~~- 'q CONNN
I~t MN~ ~NN~ti
(00
LL -
C/)
a
Q
O
LL
N
O
N
to
L
L
6E
C
c
0
N
*k
U
LL
a
U-
- (a
$
> C
N 'T CO V N CO 00 00 00 V N 00 N
C
L() V 0) V M O N CO It CO M M
U
N
M q 0 CD IT CD IT (0000
C=0 U)
4
Ld a~ 0 1- ~ 04 00
^
:3 *0 CU
> LL
0
0
Q)
V c° E
co 7
(p c
CU
0 o
e
o 0 0 00 0 00 00 00 00 0
0 0 0 0
cr~ c:
N
0
0 0
0
N CO t- V' I'- M CO O O t` M LL) 0)
Qj V CU
>
r o r r r O~ O Ln ~ M r 0A
II LCf
U)
3
CV)C14 o6 04 OO - NO~C~A1
0
c6
M
r
U
> 64
°
0
Co N
OR
a) 00
LL
U Ln O.
U)
YN
000001- LO MN~04M(0
M
C.00 D
O U"O `M
L9 N N 64
N00N~M ~MOCmCMCO00~0
N`- O
6
-
N c
9
Fa
:3
N
O
C
U-
0
L
~
*k L
N
,
O
~
U)
O~M00N000NT Od 0O
0) N o
O N-
MMr-d OM0ptt7NM~00M
00 Uo0O
O0MN~- ~C)0COtoNr O
Cl) Cts CA
Y
M0000N~ ~NCA~Oq
MN
II CL CO
-N
~
N v~00
~
Q'
E9
L~ ~Uf)
M N U O
N = C6
d
V
_CD
U QO
>
Q
cn o O
Lp 00 >
ca u
0
y CCf
CL CO
E a`) O
- 0)
R
U)
0 a E E m m
C.)
69 U N
CD
V
U)
5= S. U O
C
`
O m
Q
o CL
Q m 0 c
--j <U)0z0~LL ~Q~~~
r=
Building Services - 620
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date Year End
Budget Actual Variance FY % Coll. % Budget Projection Variance
RESOURCES:
Beg. Net Working Capital
$ 272,938
$ 439,838
$ 166,900
Revenues
Cleaning/Maintenance
64,106
46,111
(17,995)
Utility Reimbursement
6,750
5,423
(1,327)
Facilities Charge to State
102,348
108,000
5,652
Miscellaneous
-
24
24
Interest on Investments
7,500
4,888
(2,612)
Building Svcs Indirect Chgs
1,308,959
1,308,967
-
Total Revenues
1,489,664
1,473,412
(16,259)
Transfers In
167,133
140,133
(27,000)
TOTAL RESOURCES
1,929,735
2,053,383
123,641
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
100%
nla
$ 272,938
$ 439,838 $
166,900
75%
54%
85,475
85,475
75%
60%
9,000
9,000
-
75%
79%
136,464
136,464
-
75%
n/a
-
-
-
75%
49%
10,000
7,000
(3,000)
75%
75%
1,745,275
1,745,275
-
75%
74%
1,986,214
1,983,214
(3,000)
75%
63% a)
222,844
222,844
-
75%
83%
2,481,996
2,645,896
163,900
Exp.
1,165,736 1,123,068
42,668
75%
72%
1,554,315 1,554,315 -
524,761 551,435
(26,674)
75%
79%
699,681 699,681 -
27,000 -
27,000
75%
0% a)
36,000 36,000 -
144,000 -
144,000
75%
0%
192,000 - 192,000
TOTAL REQUIREMENTS 1,861,497 1,674,503 186,994 75% 67% 2,481,996 2,289,996 192,000
NET (Resources - Requirements) 68,238 378,880 310,635 - 355,900 355,900
Beginning NWC per Requested Budget 310,000
a) None of the $36,000 budgeted transfer from the General Fund has been made. The transfer is for the Capital Outlay expenditures
budgeted as: $6,000 for floors at Historic Museum and $30,000 for Phase I of roof on Juvenile building.
Admin Services - 625
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
RESOURCES:
Beg. Net Working Capital $ 120,000 $ 117,586 $ (2,414) 100% n/a
Revenues
Miscellaneous
-
71
71
Interest on Investments
3,000
1,410
(1,590)
Admin Dept Indirect Chgs
519,221
519,160
(62)
Total Revenues
522,221
520,641
(1,580)
Transfers In-General Fund
30,000
30,000
-
TOTAL RESOURCES
672,221
668,227
(3,994)
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
$ 120,000 $ 117,586 $ (2,414)
75%
n/a
-
- -
75%
35%
4,000
2,000 (2,000)
75%
75%
692,295
692,295 -
75%
75%
696,295
694,295 (2,000)
75%
75%
40,000
40,000 -
75%
78%
856,295
851,881 (4,414)
Exp.
479,277 474,441
4,836
75%
74%
639,036 639,036 -
112,457 92,043
20,414
75%
61%
149,943 149,943 -
75 -
75
75%
0%
100 - 100
50,412 -
50,412
75%
0%
67,216 - 67,216
642,221 566,485 75,737 75% 66%
NET (Resources - Requirements) 30,000 101,742 71,742
Beginning NWC per Requested Budget
856,295 788,979 67,316
62,902 62,902
120,000
a) Beg NWC must have been projected based on M&S actual expenditures at less than budget.
BOCC - 628
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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. %
Budget
Projection
Variance
$ 50,000
$ 68,511 $
18,511
100%
n/a
$ 50,000
$ 68,511 $ 18,511
75
52
(23)
75%
n/a
100
100 -
375
982
607
75%
n/a
500
1,000 500
430,063
429,994
(69)
75%
75%
573,417
573,417 -
480,513
499,539
19,026
75%
80%
624,017
643,028 19,011
Exp.
367,617 366,007
1,610
75%
75%
490,156 490,156 -
55,685 44,157
11,528
75%
59% a)
74,247 74,247 -
75 -
75
75%
0%
100 - 100
44,636 -
44,636
75%
0%
59,514 - 59,514
468,013 410,164
57,849
75%
66%
624,017 564,403 59,614
NET (Resources - Requirements) 12,500 89,374 76,875 - 78,625 78,625
Beginning NWC per Requested Budget 100,000
a) Beg NWC must have been projected based on M&S actual expenditures at less than budget.
Finance - 630
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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
71,250
65,028
(6,222)
75%
68% a)
95,000
85,000
(10,000)
Photo copies
-
47
47
75%
n/a
-
47
47
Interest on Investments
13,500
6,759
(6,741)
75%
38% a)
18,000
9,000
(9,000)
Interfund Contracts
21,000
21,006
6
75%
75%
28,000
28,000
-
Administrative Fee
9,000
9,000
-
75%
75%
12,000
12,000
-
Finance Dept Indirect Chgs
537,317
537,239
(78)
75%
75%
716,422
716,422
-
Total Revenues
652,067
639,079
(12,988)
75%
74%
869,422
850,469
(18,953)
TOTAL RESOURCES
1,392,067
1,416,771
24,704
75%
88%
1,609,422
1,628,161
18,739
REQUIREMENTS:
Exp.
Expenditures
Personal Services
616,808
612,452
4,356
75%
74%
822,411
822,411
-
Materials and Services
265,865
202,606
63,259
75%
57% b)
354,486
297,486
57,000
Capital Outlay
60,000
-
60,000
75%
0%
80,000
-
80,000
Contingency
264,394
-
264,394
75%
0%
352,525
-
352,525
TOTAL REQUIREMENTS 1,207,067 815,058 392,009 75% 51%
NET (Resources - Requirements) 185,000 601,713 416,713
Beginning NWC per Requested Budget
1,609,422 1,119,897 489,525
508,264 508,264
500,000
a) Projection based on annualizing nine months actual.
b) Interfund Building Rent (budgeted at $57,000) will not be expended.
Legal-640
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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%
nla
Revenues
Sale Map Photo or Copies
225
44
(181)
75%
15%
Miscellaneous
2,250
3,538
1,288
75%
118%
Interest on Investments
1,125
1,302
177
75%
87%
Interfund Contract
1,500
7,334
5,834
75%
367%
Legal Counsel Indirect Chgs
524,931
524,932
1
75%
75%
Total Revenues
530,031
537,149
7,118
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
TOTAL REQUIREMENTS
$ 87,000 $ 102,125 $ 15,125
300
300 -
3,000
3,538 538
1,500
1,500 -
2,000
7,334 5,334
699,907
699,907 -
706,707
712,578 5,871
617,031 639,274 22,243 75% 81% 793,707 814,703 20,996
Exp.
506,276 501,396
4,880
75%
74%
675,034 675,034 -
40,689 31,207
9,482
75%
58% a)
54,252 54,252 -
75 -
75
75%
0%
100 - 100
48,241 -
48,241
75%
0%
64,321 - 64,321
595,280 532,602
62,678
75%
67%
793,707 729,286 64,421
NET (Resources - Requirements) 21,751 106,672 84,921 - 85,417 85,417
Beginning NWC per Requested Budget 90,000
a) Beg NWC must have been projected based on M&S actual expenditures at less than budget.
Personnel - 650
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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
375
1,009
634
75%
202%
500
1,009
509
Interest on Investments
3,000
4,242
1,242
75%
106% a)
4,000
5,600
1,600
Personnel Indirect Chgs
474,706
474,095
(611)
75%
75% b)
632,941
631,241
(1,700)
Total Revenues
478,081
479,345
1,264
75%
75%
637,441
637,850
409
TOTAL RESOURCES
838,606
902,907
64,301
997,966
1,061,412
63,446
REQUIREMENTS: Exp. %
Expenditures
Personal Services
437,894
422,243
15,651
75%
72%
583,859
583,859
-
Materials and Services
252,005
113,772
138,234
75%
34% c)
336,007
336,007
-
Capital Outlay
75
-
75
75%
0%
100
-
100
Contingency
58,500
-
58,500
75%
0%
78,000
-
78,000
TOTAL REQUIREMENTS
748,475
536,015
212,460
75%
54%
997,966
919,866
78,100
NET (Resources - Requirements)
90,131
366,892
276,761
-
141,546
141,546
Beginning NWC per Requested Budget
290,000
a) Projected based on 9 months actual
b) Adjustment for CDD ISF charges.
c) Beg NWC must have been projected based on M&S actual expenditures at less than budget.
Information Tech - 660
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
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
-
14,310
14,310
75%
n/a
-
14,310
14,310
Miscellaneous
750
189
(561)
75%
19%
1,000
1,000
-
Interest on Investments
9,000
5,737
(3,263)
75%
48%
12,000
7,500
(4,500)
Leases
-
6,536
6,536
75%
n/a
-
6,536
6,536
1 T Indirect Chgs
1,432,557
1,432,548
(9)
75%
75%
1,910,076
1,910,076
-
Total Revenue
1,442,307
1,459,320
17,013
75%
76%
1,923,076
1,939,422
16,346
Transfers In-General Fund
48,751
48,751
(1)
75%
75%
65,001
65,001
-
TOTAL RESOURCES
1,928,272
2,046,225
117,953
75%
84%
2,425,291
2,542,578
117,287
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
1,297,185 1,273,410 23,775 75%
376,670 230,600 146,071 75%
75 - 75 75%
145,038 - 145,038 75%
Exp.
74% 1,729,580 1,729,580 -
46% a) 502,227 502,227 -
0% 100 - 100
0% 193,384 - 193,384
TOTAL REQUIREMENTS 1,818,968 1,504,010 314,959 75% 62%
NET (Resources - Requirements) 109,304 542,215 432,911
Beginning NWC per Requested Budget
2,425, 291 2,231,807 193,484
310,771 310,771
435,000
a) Beg NWC must have been projected based on M&S actual expenditures at less than budget.
IT Reserve - 661
Statement of Financial Operating Data
Nine Months Ended March 31, 2010
Year to Date
Revised
Year End
Budget
Actual
Variance
FY %
Coll. %
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital
$ 350,938 $
373,691
$ 22,753
100%
n/a
$ 350,938
$ 373,691
$ 22,753
Revenues
Interest
1,500
4,323
2,823
75%
216%
2,000
5,600
3,600
IT Reserve Charges
175,500
175,507
7
75%
75%
234,000
234,000
-
Transfer In-General Fund
-
-
-
75%
0% a)
90,000
90,000
-
Total Revenue
177,000
179,830
2,830
75%
55%
326,000
329,600
3,600
TOTAL RESOURCES
527,938
553,520
25,582
75%
82%
676,938
703,291
26,353
REQUIREMENTS:
Exp.
Expenditures
Materials and Services
367,493
47,026
320,467 75%
10% b)
489,990
489,990 -
Capital Outlay
79,500
37,202
42,298 75%
35% b)
106,000
106,000 -
Contingency
60,711
-
60,711 75%
0%
80,948
- 80,948
TOTAL REQUIREMENTS
507,704
84,228
423,476 75%
12%
676,938
595,990 80,948
NET (Resources - Requirements)
20,235
469,293
449,058
-
107,301 107,301
Beginning NWC per Requested Budget
161,896
a) Supplemental Budget - Transfer In from General Fund to be expended for Sharepoint Software. Transfer will be made April 15.
b) Beg NWC must have been projected based on M&S and Capital Outlay actual expenditures at less than budget.
U'd 33 ViNVS N83HiHON NOlJNI uns
co
M
C
OZ
m~f
- - - - - - - - - - - - - - - - - - - - - - -
~ 0 q c0D Yvoe
~eCO ca 0 g =°s
C6 w co C:
° LO w d $
o°C;
(D0 ca (D 0 a) a) ui
V
Er a_ QQ '7 CO Ir N0 a: N%.6 Q
m
W °o
N
a
W
F-a
P
LLJ Q N
a° T
3
JQ ~
U a
7
O7
M
^ Q
V I ~
2
w
Q
LLB
a
g
1S -nlH
W
Z
Y
a)
U
T V)
C O
O
N
(D C:
00 O
Oa
Z
E Ucr
01.
Q jm U)
TL4- O U
}cL70U C
L ~CC-p 3
Q) " C:- C) *o
p,•--r- iiCr 0 OL
W a).6O O
O O>cxn n p
w 0 a) 0
Q M AA"I Board of Countw Commissioners
1300 NW Wall St, Suite 200 • Bend, OR 97701-1960
(541) 3BB-6570 • Fax (541) 3B5-3202
www.co.deschutes.or.us
board @ co. deschutes. or. us
Tammy Baney
Dennis R. Luke
March 8, 2010 Alan Unger
Mr. Robert Bryant
Region Manager
ODOT Region 4
63055 N. Highway 97
Bend, OR 97701
Dear Bob:
We are asking ODOT to address a long-standing traffic safety issue at NW Lafayette Ave. and
the Parkway. The large sign north of Lafayette Ave. ("Lafayette Ave, State/County Offices"
exit sign on the west side of the Parkway) restricts sight distance for vehicles entering the
Parkway from Lafayette Ave. The marginal sight-distance at this intersection has become more
of an issue as the traffic volume and vehicle speed on the Parkway has increased. To accelerate
from a stop at Lafayette Ave. onto the Parkway, one must be able to judge the gaps in the flow of
traffic. The large sign which obstructs the driver's sight-distance makes it much more difficult to
anticipate these ever smaller gaps. Members of the public have mentioned this lack of sight
distance in conversations with at least one of the Board members.
The Lafayette Ave. access to the Parkway is one of the major accesses to Deschutes County and
State services. This issue is of critical importance to the County - we ask that you please look
into this issue. We look forward to meeting with you to discuss possible solutions to this public
safety concern.
Sincerely,
The Des tes County Board of Commissioners
De nis R. Luke, air
Alan Unger, Vice Chair
Tammy azicy, ComYfxissioner
Enhancing the Lives of Citizens by Delivering Quality Services in a Cost-Effective Manner
Department of Transportation
4D OinDn Robert W. Bryant
Region 4 Manager
63055 N. Hwy 97
Ted Kubnwdc Gmemor Bend, OR 97701
(541) 388-6180
FAX: (541) 388-6231
April 7, 2010
FILE CODE:
Board of County Commissioners
1300 NW Wall St, Suite 200
Bend, OR 97701-1960
Dear Commissioners:
This is in response to your letter of March 8, 2010, regarding the safety concern and
sight distance at the intersection of US 97 (Bend Parkway) and Lafayette Avenue.
My Region Traffic Manager has reviewed this location and in the last five years, found
that there have been nine crashes in the area of the intersection. None of the crashes
were angle crashes which would typically be attributable to a lack of sight distance at
the intersection. Several of the crashes were rear-end crashes on Lafayette Avenue
itself. This type of crash could be attributed to motorists believing that the driver in front
was going to accept a gap when in fact they did not and the second vehicle in line
moves forward striking the leading vehicle. There were also some rear-end crashes on
the main line of the Parkway itself. This may be caused by turning vehicles slowing
down before entering the deceleration lane, or vehicles slowing down in the travel lane
because a vehicle from the side street selected too small of a gap in traffic which
impeded the flow. Of the nine crashes, eight were property damage only and one crash
resulted in a minor injury.
We also reviewed the sight distance at the intersection. In a passenger car, the driver
actually can look beneath the sign and have limited sight distance. A driver in a light
truck, SUV or larger truck looks into the sign and for a short time loses sight of the
vehicles southbound on the Parkway. In order to gain adequate sight distance, the
driver must pull forward into the crosswalk. This is a common maneuver in urban areas.
At many intersections buildings, landscaping, parked cars or many other obstacles
block sight distance. In these situations, the driver stops at the crosswalk and yields to
any pedestrians and then pulls forward so that he/she has adequate sight distance.
I believe the sight distance concern is exacerbated by the lack of available gaps on the
Parkway, particularly at peak periods. As you note the speeds and volumes on the
Parkway are relatively high. It is becoming more difficult to find a safe gap in traffic.
Some potential solutions that we would like to explore with City and County staff are:
• Encouraging County staff and customers to use an alternate route to access US 97.
Entering US 97 at the Revere or Colorado Interchanges would likely be safer than
Board of County Commissioners
April 7, 2010
Page 2 of 2
attempting to turn at a 'T' intersection. This could be accomplished through
education and outreach or more infrastructure that could be put in place to
discourage lefts from the County driveway.
Removing the sign and replacing it with a smaller one. Originally the signing at the
intersection only directed motorists to Lafayette Avenue. The County asked us to
install a new sign for the County building when it opened. This new sign is
significantly larger than the old one. We would have more flexibility in locating a
smaller sign. However, we believe that the lack of gaps at the intersection is of
larger concern than the available sight distance.
Relocating the existing sign. Relocating the existing sign would be expensive and
somewhat limited due to significant utility conflicts in the area. The footings on this
size of sign are very large and the steel supports are costly. The costs of new
supports and footings could easily exceed $10,000 and as mentioned above, we
don't believe this will solve the underlying problem.
Restricting turning movements at the intersection of US 97 and Lafayette. The
Intergovernmental Agreement (IGA) regarding the construction and operation of the
Bend Parkway section of US 97 between ODOT and the City of Bend calls for the
closure of at-grade intersections on US 97 if a safety problem develops. The IGA
doesn't define what a safety problem is. It is up to the City and ODOT to come to
agree on when the safety concerns at these intersections warrants further
restrictions or closure. As volumes grow, finding gaps on US 97 becomes more
difficult. If the alternate routes are viable for the primary user, perhaps we are at
that point where we should explore closing some or all of the movements at the
intersection.
My recommendation will be that we consider the option of restricting the turning
movement from Lafayette onto the Parkway southbound. I will schedule a time we can
meet at your convenience to discuss this and other options to improve safety for this
section of the Bend Parkway.
erely,
Robert. W. Bry~ nt, PE
Region Manager ,
61 1
Pro osed Amendment to Bend Area General Plan
Draft - June 30, 1992
STREETS AFFECTING PARKWAY
Several City streets segments will be critical to the efficient
functioning of the Parkway. Careful review of development
proposals and regulation of access along these streets is essential
to ensuring that traffic does not adversely impact the Parkway. In
general, direct access to these streets should not be allowed where
alternative access exists or can be provided. These streets are
identified in Table 1, below:
: t; h::~•i i+.: :tr.{}•} i:'4:~i.f~..; [.J}'r ..:[x';.:+ya 4vw %.sYi~.r _ -.:\••j
et:Y:S.e Brits.>.cr~:tica3 ~..to<rtfie;[=,>,.,.:<;
i i.
•y,
tioni'n of <hthe YParkway;? `>4 `
ef fici:ent:func
::i. -t..,•:♦4:r n:.. :•:.::•v:.,'.:.s::: •:T:'.•N:,.} :~t.v }'•.Jir': ~~k. - - +'.}S
•
moire Blvd. between 3rd
!
Pinebrook Blvd between the
Street and Anderson Road
Parkway and 3rd
•
Hill Street between Revere
•
Colorado between Harriman
and Wall
and Hill
•
Wilson Ave between Pelton
•
Arthur Avenue between the
Road and 3rd
Parkway and 3rd
•
Reed Road between the
Powers Rd between Blakeley
Parkway and 3rd
and 3rd
•
Butler Market Rd. from 3rd
•
Badger Rd. between the
Street east to the Parkway
Parkway and 3rd
•
Irving Ave* between the
•
Hawthorne Ave* between the
Parkway and Hill
Parkway and Hill
•
Greeley Ave* between the
•
Lafa ette Ave* between the
Parkway and Hill
Parkway and Hill St.
•
Hill St* between Kearney
!
Kearney Ave* between the
and Irving
Parkway and Hill
*
Street segment of special co
ncern.
See discussion following
list
EXHIBIT D
AREA OF SPECIAL CONCERN
The street segments highlighted with an asterisk in Table 1
constitute an area of special concern. This area is bounded by
Lafayette Avenue on the north, the Parkway to the east, Hill Street
on the west, and Greeley to the south. (See Figure 2).,
This area is currently predominately residential, but the majority
of the area is zoned commercial. Given this zoning, the proximity
to the Parkway, and the existence of several local streets with
direct access to the Parkway, there will be strong redevelopment
pressures on the parcels in this area. As commercial redevelopment
occurs in this area, direct access to the streets highlighted in
Table 1 should not be allowed. For parcels should Lafayette,
Kearney, Irving, Hawthorne, and Greeley,
from -the "alley", If it is not feasible for the development to
take access off of the alley, any direct access onto the street
segments should be conditional on dedicating right of way for the
future development of a street along the existing alley alignment.
At such time as this street is built, the development would close
their access onto the'street of special, concern and take their
exclusive access from the former alley alignment.
If traffic on any of these streets adversely affects the safety or
function of the Parkway, the connection of these streets with the
Parkway may be restricted or eliminated by the Oregon Department of
Transportation.
a=nd.bgp
rY.
Y
m
C
O
m
N ~3
cd O
sue., U
~--i 03
i
O co
cn Cd
O
O '
U ~
lV o
Q~d
o a~i -d
00
O
N
4
O
O
c
a~
cd
`3 U a
a
0
cri
a 3 o O 1>
cLOi En
r.
f7 a > . O a~
Cl o U V)
O
a aj O
0 ~ a 3 ~3
N o Cd P-4 (D C14 M O
CL v p, M Cd Q p cn
a a~ ) rL O N
-0 N T cd O ~i O~ O N C/] p U
YU) 7:1 N U~3 N N O
O ,
06 'c _j O N 00 N Q _0 r.
N
cu aN cc i N t8 V i 5 N C Q >
--4 Cn ~t C;3
03 v 03 C-) =
0 .x cn E a) = ~ C° iii C's a u 1~ >1
0 1
rA C,3
O(1) cd
' N 4-+ F 4- O
4-1 a)
d a~ O u Q
03
03 j)
4
-0 "o
a)
O ~
Cd
E
o3 O
o
U
Q
O
U
O U
cn °
U
co
~
•
C~
O
c
y
4-4
O
~
sue., ~ N
>
'd
En
c,3
t4-4
O
En
V)
U
O ~
~
3
0
0
.E
~
•Cd
C,3
Cc3 a
•
n
m
O
~
3
O
C)
a -0 3
°
C4
o
o $:l
US o 1
4
03
0
o
U
C~
cn
~
~
z
M
tp~
Q:
)
V
3
O
O
O
r,
'd
3
+C~
Uj
'4-
U
p
N
cn
U)
U
0
~
, V]
Cd
00
-
x
En
rn
,
N
U
C •
N
N bb
~
p
E 11
O
M
2
O
N
= ~s
'
.
v~ U7/1
QI U
~
A.,
On
E-+z
d
kn
n4
Page 1 of 1
Bonnie Baker
From: Kevin Keillor [kevin@keillorhill.com]
Sent: Wednesday, April 28, 2010 9:34 AM
To: Board
Subject: Parkway and Lafayette
Commissioners:
The main obstacle to turning right onto the Parkway from Lafayette is that the majority of vehicles use the right lane.
ODOT should considered signs along the Parkway that advise through traffic to use the left lane and local traffic to use
the right lane. This could have the added benefit of slowing speeders in the left lane. Respectfully,
Kevin J. Keillor
4/28/2010