HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners
Finance Director/Treasurer
AGENDA
February 23, 2009
(1) Monthly Investment Report
(2) January Financials
(3) Bond Issue Update
r esc utes Count A
o -1 lnves ent ortfolio As 0
Investment Income
Fiscal Year 2008-09
O
N
}
$ 296,319 $ 2,140,197
Total Investment Income 296,319 2,140,197
Less Fee: 5% of Invest. Income (14,816) (107,010)
Investment Income - Net $ 281,503 $ 2,033,187
rn
O
c
1a
7
Investments By County Function
General $139,988,704
Total Investments $139,988,704
- i o to Brea i t
o e
O co co 'is e p
O O O O
O) O CO O v. G
O
ffl
0
m a)
CL U
�a Z
• Q1 7e
a) U
2 a)
• Q 0
0 0 E
c.) 1 -=
U. S. Treasuries
CO
O
O
0)
Cl
CO
O
0)
0)ti
CD
0
U
C
vim°
U a
C N
o 0
a) <
Q "u)O
a) Y d
CD • CO LL CO J
O
1
10
1)
O
O)
69
Total Investments
0)
0 -8°
N L N
4 N
Average Maturi y in Days
CO
121
00 0 0 0 0 0
O O 1n 1n In 0 O
O 0 1- N N N e-
Time Certificates
0
Q
RI m
O
• Z
cp
o
E o
E E-
o U 0
Total Portfolio: By Investment Types
gz c"
0
I 1 r 11 I i I I I(, 1 , I I I I j 1 jI
0:1 mo °)' of I o l eevheleec
�l w QI�j� �1�1�'� olQlQl�;Q �1� �Ioi �I� UIo �1 Q r rn S o o! j vI9v v a, ololo�ryl �T4:'
x zz,zzlzzIzzzzlzzzzzzzzzzzz'z z'zR oz�I�;zlz�z 'zz,I OL O� $
col o 1 ,1 � I � I l l v of v o o� o �o m `"� olc°°i1c 14�0
QI10 O O Ofaot rl -(0 al r) i0 04i CO �. OI + I 1 o1 ao' N ao* �o off wilt 704 Ln OI r- m14 -�-_ y. ~I4 - -II I- r - -i 4
�-�--�
r[7 c -ID. N NI).- N I � _ _ 110 IVB _�.�
aojo;o gIloir-1Ln <alo ell §7 roi olo La ccooIolC�i Cr"! � so Np al Div�} o iN•' 0 ccly 0 0 0 oolrg'i 0 ‘.0,-+ 0.1 M IO 8 u"i co c1i v ole 1'- rna
OIL A. N O I O I S O N a) r) 0 CJ pp O sig ID NIM u, a) 0 O �Gnp V O 041 N N S N t0 10 0 V O O 0I r) 04 0 Io 1 N 10 0
. 0 O N 10 o SI 0 r) 04 0 toI O O c01 S O N O O N t0 O InI L0 N to Or. N (O O t0 [0 N N In 10 CO t0 t0 1s Op e{ f7 N
E 7 a)I N 10 OI of oI qI ri Ni ai cc M I O O ri IV p� N to ai .0 N 8 o OI _1 O O r) N a) n C 11,.....o.':
04 - 10- lai 1
�p I cof r) O 10 N O Q O cv a,. O f10 N 010 0 0 01 O) 4 O_ W O O N O fp 10. N O c N CO O V 00 $ M 'a) I
0) 04 01 O - 0.01.- I N v -J.- -1 0) f- O N- O e- o,',-.5 - O' o 1� N a1 N 1,-.r) 1011 I0) 0
>1g E IN N'' -N NI 0.11 (VIN NI NINI IV IN N N NI 1.- CiI 1V N N N N (V N N N NI,F.N V7 _• NI N 04 O Oi N No I,ol 100)
j.c L l 1 � jt_ r L- i 1- + N 10 I� ' b w j
Oi SIO O S O C erg O 1 0p 0 '99 S O fp`M('010 ci p�) M�S� fNO ppO go N� ��tQQOppfI O O 0r(7.10. ol O p0 0 O t'M') 10 (jr- no Opp) 10 O O 1100 a00 .�-- 10{ ni C. I I
V 0 Or
N1S 041 NIm.N NiN 010 0 1IN W r'I .1 r- C09 10 X110 0310 O 0I01co . O N tNOI� 011[ O SIN co,O(c0. 0 10 0) D
0) 0)1 03.0103 c0 04 r) O 10 N a) Ci 0 04 r) ti N O O 0 1 r) N N 10 10 V N O 0 t0 04 0 N 1- M
O 0 N ININ SI oIa) 0 0 100104 N N O) OIS SIN t0 O OIO O O o o o o N 0 O) O 1 N 0 O I�
$.9119 9)010 o 010 olrn.��w 9. a 9.l.- 04 0 9. 0 ..-I o o 0 00 O 0 070 9. O Ioryrn N N O E
�- i N-rN 011 � f 01 01 04 N N � N i i t ri 04 1 I N CJ N N I N 04 N N I a{ N V I` 10- I CO CO0Is. CIS
rI g? y
1,---1--
-[0.11
OI OI +O r f r 0 0 0 S+0 O O �I 'OS O 8,8 SS �S O O O $ O O O L�SI� p��S z *-T� I-- r r __*.;_44-4-
r,
.
, 10 0 8 O I O S 8/818,418 p• 8 tp O I O 81 N pO 8 7 p 8 1 8 olg 8 qp p8 o
V 1SIOIIOOIpOpIO 0p OV 0)1 IDNI riSwOlc, N� OI.0oOOOSON 0100, O S100_O SOO.00WO 0V)ID 10 20 I I
O O N S 10 10 .7 I
i0 e� 01 O1.d1 O O O rf 10' Cr;0I p O V N N p O pp 0o C p O 10 10 op O' O O 01 0 0 0 ` p 0 04 04 :f
I
'� I O O .01010 cv �O O� N 0 0 9.e o O �� o��� O S 00i, � O Obi, O o S S N� N 6 C) 0 7 a0
C 01040 No 004-10 SICP r, 0OO c00 O OC 004 N 0) 'O I
O I C‘" --
i NI NI�10N ��t N• �v M N L7-17.
"rc� t Nlv "lv L NtJ�lr�i roi �tti a �, '0, 0 a I
F _T 1_ _1 _ 1 1 a a a d €
Cer-Ro e e*eea1*417+*er'-eo 0 9. **!-e.o�o *o a s 0 0 0 -reel 9. a aoro *� e a e Ef mci�zlri&I8r9--I�
p0)000I IO 00.r)N0)pp {I{nnnl10 o 000011`0001§o0)ppa01nInOj°°00Qpo�0l00 mo v0i p04 �1 0PP=',e1+QQOI>
V 1 co t`rn S l °- 100 O N 9.3 CI O Cal O O VIS 0 CO N r N N 10 1!I co(k9. N CO to IND N 8;w
10 O u`�i In co O N O 10 cc! 01 O �0 O m e
r)1V V (V1 r) N V CO CO COl CO V1r)_IVIN 17 r) - V N MI r) rilr) N r)1N c7 N ri N N CO NI4- NIN N r)I0, - to r N %. E'..16'.,_ II.Im�I_
a ao.{._l.9._ **11-� eei\o __.*. is -i �� o0o eIno 1ol0 + ml a°ci l um-'~ II
, _, o + p 7 j�ta 9. o o vI e r -+--t -,of
sur
0I0 o Op 0 O 0I t0 0 i0 0 10 11 0 O
31 t IND,Ir- 0 SI rl 1100 I- OI coNcol' 0 INS), ` N CD) 4 10 0 co IND N 10i I. N YI OI
V 1_-4 _.L- -- ---t- _.�v eiv ui ai II, ,-r- r-�-�771�T --{--_i..cv--r----1-�- c �_ - - -. O9. -i-�IL L <._ �-�__
M r), V I r) t0 co r) M 0I
Z--. i• +-I---F d-� 1
'o a • 1 I 11 1 1 I I E a ° 11 I
c � « e do-mt -r It. �I_ =
It m I 3
41
fi+ 1 j T app p y7 i�pf r �n �V c �p pL E. E� �rdL
O1 a vl o N 0.11 nI 40 V r) 0{ � � A�M � N M O) O f0-�fO S V0V 10 IiOD N�01 t0 N�00i ht0') Io) VN N 1P0}I}D 0V t'0 O N� 0� d C r 1 r j r--
--1-
- Y_
ZI O 0)I 10 1l')I� 1V N') V K) N 04104 N 0 1010 r) t0 )0� 0111 YJI r) r) N10i 10 04 v N N 04 tL) ci 10 10 O N NIN 1e E
T 1- 4 �. I -1- h I I- } m> p r L� } L 1 1 +
a)! 0) 0) 0) co rn 0) 01 a) 0) O) O) O) O) 0) aI 0) rn1 rn a) 0) a) 0) 0 0 0 0 0 0 0 0 0 0 0 9.1 o 9.I Q a) > o I 1
0Q0000 0 9. Qlo o Q Q oIQ Q10 0 Q Q 0 c 0
O O V 04 II' 0 Z � VIQ Q r)� e- 1& ) r) Il) OltO N In 5 0 04 a 0 a a a N Y o
olc� Q 9.V .Q- v. iii -'- "IQ Q o g �I� N � N;o O Q Q N _9. 9. o - m A
O O C L O i 0 i 0� 0 O, O O, O O i 0 O O +O , O O 0-,-f-,-,-,........ II N I N NIS N N M V 10 01 0 O� c0 Q'� J m F 1 1 '
W I-- li 1 L -L 0
E `
°'r -i
co' 04 N 0 tp 10 7� 04 colon 10 O a0. W 04 0 O0 10110 a9. W 0 no w 10 00 a9. ao a9. rn 0) rn a0 0) I J f
oroolooloQ0OQooQ0oIQoQQoQQ0QQQ.Q00000�oo0Q0Q 111
LI a IaIiO N I�IN O c0 0 0 IO,o 33117-4�N r) &II0 Nlm .-10 N r) V N O N 0 0 to �IN N 0 V 1 j 1
` N. N N OI CS"'" -l''' N N Q') - O_ 1`" N 1Q .°....1 N O O Q N `�] N O - 9. O � N z Q -7.
O�VI �I�
O OI O Q N O? O O� O O p N O 04 01n .-- - -. N. ..- . 0- '8 75 '6 2' � I I ILL
a,�I o of o ole o of o r o o 0 0 0 0 0 o ¢ v ma m �mz > ur a <la z Qlp
1 t } I - L 4_ i- m m c,�, a4z.H H »,31mry oIar-H
t-- Zlaaaa�0¢Iz(¢a<OZ<IZH<)0Z0OZ0ooalaa<<0<<<00000<< i '
eaRl 0(L. a LLI�1r U.!U)LL LL LL I- c.) L.L. v O-. I- U I -I Oil- 0 I- r- LL O.) U- LL i- a LL U.. I-- 0 I- I-II- a LL
��Qa mrzz'+ � �Z10 i Tcnu) x01010 > CO 1 ���mr3a�v¢�nm I<I co 00m�y + �� i 1 � ; j ,l 1
_4-r }4 a
1.
1
•
ZZ
m -)!ZiO al
E 01' 0)1 i t0 10411 �.-101 1' 04 0 0o col N • 0 144 r I Inl ' .-I N r) ID� r)1 1 I cD co 1 I I I +-T.-+-
. I l
Z d I- 0 - 41t5 Q. J 2 'a OI -.i O LL X I
�lO v oiu,� z wlc� x a �,l�zl ' ¢ �¢ �IH w i w vii i� m1 rOi' � 1 I
Z N XX� c.)2 cg
O�I(gO In N (7.Za<(cD OW 09 1 0
Filo r) r)1 g m cWD M m N XIX Xla9. X +� LL LLI 1 LL I
0 L Y� � � fi-r Jr F -f -�� CO M��L.-1----t-1^--�- Ecol fIh cn "') .-- I- -Eco r)1- L y I iJ 04 IFL I !�
_N 01 0 CO N
o 11 1 0 I jcOi coil m X1 li = IyJ°
x' Y 0 I 1 w y (51)10 I13,)dasi
c Z a Z 0 Y OI ami d c o d lit
IY a'il 0 01I�1 w
O j m0 150 Z ' I0 c IUpva U>LL fraa6T ��al vi?)
IZ m Z .m U y �a. E v�2.'� m moo mz,F c
Z Y �oc� CO � � �a n, c� I�Imi�a
.c � �_ c�i mU CO `� U d £m1�m�RZm �° �mQlova
Z 10 OO d. C�,YIco m a> > alba @ m
LL N m Y. O O g 0) 0)I a)
c." '0 ry E j d u. U 0 o m m �IU 0 c c? `�V m 5 ol�� m E 4 10�)=
_ v cm m NOo2.aimyo EI Iti000 tr)
,; 2I� U m mI c co,I 'a-, co co m E c c m E c 03 05 c 0_I J J a J E did c 7I c c1 U <1 W T-'-�c 11-1t
13 �U tali-I�
�a _ Y w w m m �wwlm olm mc�Io )asv)Ivs�
o¢ 4-4 T o °mlm. ' o
�, 0 CO a)Amy m m m r2' E Y Y Y 1 y 1 1_
H - C nUluZ. LL I=L LL D LLjU LL l=LjI=L U Oil. f7 LL Ulm LL' NjJ LLILL L=L �LL 1=L UILL IZL IZL. QI _DIM mI ILL:. IZL J CO� 1 I 1 1 , I It -
I I 1 1
Market Value
'01,11
Jai q
y
Memorandum
Date: February 17, 2009
To: Board of County Commissioners
Dave Kanner, County Administrator
From: Marty Wynne, Finance Director
RE: Monthly Financial Reports
Attached please find January 2009 financial reports for the following funds:
General (001), Community Justice — Juvenile (230), Sheriff's (255, 701, 702),
Health (259), Mental Health (275), Community Development (295), Road (325),
Community Justice — Adult (355), Commission on Children & Families (370-399),
Solid Waste (610), Insurance Fund (670), Health Benefits Trust Fund (675) and
9-1-1 (705).
The projected information has been reviewed and updated, where appropriate, by
the respective departments.
Cc: All Department Heads
GENERAL FUND
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Year End
$
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 6,050,000 $ 6,461,433 $ 411,433 100% 107% * $ 6,050,000 $ 6,461,433 $ 411,433
Revenues
Property Taxes 11,329,208 17,269,233 5,940,025 58% 89% a) 19,421,500 19,338,500 (83,000)
Gen. Rev. - excl. Taxes 1,530,777 1,793,104 262,327 58% 68% b) 2,624,189 2,824,189 200,000
Assessor 502,419 757,796 255,377 58% 88% c) 861,290 1,011,290 150,000
County Clerk 1,000,774 702,669 (298,105) 58% 41% d) 1,715,612 1,265,945 (449,667)
BOPTA 7,641 12,866 5,225 58% 98% c) 13,098 15,598 2,500
District Attorney 207,943 170,004 (37,939) 58% 48% 356,474 356,474
Finance/Tax 116,285 167,431 51,146 58% 84% c) 199,346 229,346 30,000
Veterans 40,833 53,591 12,758 58% 77% 70,000 70,000
Property Management 59,547 59,554 7 58% 58% 102,080 102,080
Grant Projects 1,167 1,162 (5) 58% 58% 2,000 2,000
Total Revenues 14,796,594 20,987,410 6,190,816 58% 83% 25,365,589 25,215,422 (150,167)
TOTAL RESOURCES 20,846,594 27,448,843 6,602,249 58% 87% 31,415,589 31,676,855 261,266
REQUIREMENTS:
Expenditures
Assessor 2,131,554 1,926,246 205,308 58% 53% e) 3,654,092 3,454,092 200,000
County Clerk 903,776 861,262 42,514 58% 56% 1,549,330 1,492,390 56,940
BOPTA 36,063 30,203 5,860 58% 49% 61,823 61,823
District Attorney 2,808,903 2,635,117 173,786 58% 55% e) 4,815,262 4,603,902 211,360
Finance/Tax 460,273 452,995 7,278 58% 57% 789,040 757,750 31,290
Veterans 138,230 135,396 2,834 58% 57% 236,965 236,965
Property Management 148,418 143,635 4,783 58% 56% 254,431 254,431
Grant Projects 62,291 60,278 2,013 58% 56% 106,784 106,784
Non -Departmental 675,046 510,747 164,299 58% 44% 1,157,222 1,414,499 (257,277)
Contingency 3,176,300 3,176,300 58% n/a f) 5,445,086 5,445,086
10,540,854 6,755,879 3,784,975 58% 37% 18,070,035 12,382,636 5,687,399
Transfers Out 7,710,551 7,770,690 (60,139) 58% 59% 13,218,088 13,218,088
TOTAL REQUIREMENTS 18,251,405 14,526,569 3,724,836 58% 46% 31,288,123 25,600,724 5,687,399
NET (Resources - Requirements) 2,595,189 12,922,274 10,327,085 ** 127,466 6,076,131 5,948,665
Exp. %
* Beginning net working capital includes $3,160,000 due from Fund 457. Will be repaid with a FF&C debt issue.
a) Approx. 85% of property taxes are historically collected through Nov. Projections indicate an $83,000 negative variance from budget.
b) Additional PILT receipt from Federal government, liquor revenue exceeds estimate.
c) A & T Grant (received quarterly) will exceed the amount budgeted.
d) Clerk's Office revenues are projected to be less than budgeted, based on seven months of actual activity.
e) Expenditures will be less than budget due to open positions
f) The Contingency in the Original Budget was $5,905,383. The $460,297 net decrease is due to an appropriation transfer of
(1) $10,615 to Personnel in Assessor ($4,818), Clerk ($5,217) and BOPTA ($580) Departments, (2) $127,466 to Transfers t )ut
for Crime Prevention (Fund 115), (3) $127,466 of appropriation transferred to Fund 115, (4) $200,000 to Transfers Out for C DD,
(5) $15,328 Transfer In from Fund 170 and (6) $10,078 to Clerk's Capital Outlay.
** The net of $127,466 is due to transferring $127,466 of appropriation to the Crime Prevention Fund.
COMM JUSTICE -JUVENILE
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget 1 Actual 1 Variance IFY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 1,090,000 $ 1,161,149
Revenues
$ 71,149 100% 107% $ 1,090,000 $ 1,161,149 $ 71,149
Federal Grants 107,960 89,357 (18,603) 58% 48% a)c) 185,075 164,518 (20,557)
State Miscellaneous 8,524 8,524 58% n/a a) 53,714 53,714
SB #1065 -Court Assess. 37,333 32,085 (5,248) 58% 50% 64,000 64,000
Discovery Fee 9,333 9,409 76 58% 59% 16,000 20,000 4,000
Food Subsidy 22,750 14,723 (8,027) 58% 38% b) 39,000 39,000
Juvenile Crime Prevention 212,433 165,404 (47,029) 58% 45% c) 364,171 377,770 13,599
Inmate/Prisoner Housing 35,000 38,430 3,430 58% 64% 60,000 60,000
Inmate Commissary Fees 292 504 212 58% 101% 500 800 300
Contract Payments 200,489 152,641 (47,848) 58% 44% d) 343,696 248,000 (95,696)
Miscellaneous 175 354 179 58% 118% 300 354 54
MIP Diversion Fees 933 440 (493) 58% 28% 1,600 1,000 (600)
Interest on Investments 17,500 23,433 5,933 56% 78% 30,000 36,000 6,000
Leases 7,350 3,501 (3,849) 58% 28% e) 12,600 5,050 (7,550)
Grants - Private 70 70 58% n/a 70 70
Crime Prevention Services - 2,148 2,148 58% n/a 19,700 19,700
Level 7 52,500 20,000 (32,500) 58% 22% c)f) 90,000 60,000 (30,000)
Total Revenues 704,048 561,023 (143,025) 58% 46% 1,206,942 1,149,976 (56,966)
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
3,504,573 3,504,573
5,298,621 5,226,746 (71,875)
58%
58%
58% 6,007,840 6,007,840
63% 8,304,782 8,318,966 14,184
Exp. %
Personal Services 1,708,300 1,695,582 12,718 58% 58% g) 2,928,514 2,916,000 12,514
Materials and Services 958,919 832,950 125,969 58% 51% 1,643,861 1,515,000 128,861
Capital Outlay 58 58 58% 0% 100 100
Juvenile Resource Center
Personal Services 1,688,385 1,458,024 230,361 58% 50% g) 2,894,375 2,615,000 279,375
Materials and Services 121,084 117,280 3,804 58% 57% 207,573 188,000 19,573
Capital Outlay 58 58 58% 0% 100 100
Contingency 367,651 367,651 58% n/a 630,259 630,259
TOTAL REQUIREMENTS 4,844,455 4,103,836 740,619 58% 49% 8,304,782 7,234,000 1,070,782
NET (Resources - Requirements) 454,166 1,122,910 668,744 - 1,084,966 1,084,966
a) Projection of Federal Grants reduced for budgeted amount to be recorded in State Miscellaneous and increased for Federal
Grant revenue for FY 07-08 requests paid in FY 08-09.
b) Billing submitted monthly for reimbursement. Payments received to date cover July to November.
c) Reimbursements requested quarterly. Juvenile Crime Prevention adjusted for increased amount of award.
d) CEOJJC has placed the Administrative Analyst position on its payroll and assumed 100% responsibility for this position
as of October 1st. Projection reduced by $34,000 due to the ending of reimbursements from CEOJJC to partially
fund this position.
DHS payments expected to be lower than budgeted due to a decrease in number of youth in program. DHS began using
a new disbursement system in December delaying processing of payments.
e) Lease revenue less than estimated in budget due to Rimrock and Interfaith moving out mid year.
f) Budget for Level 7 revenues overestimated by $10,000.
g) Personnel Services projection reduced due to unfilled budgeted positions.
Year End
Budget
Projection
Variance
$ 71,149 100% 107% $ 1,090,000 $ 1,161,149 $ 71,149
Federal Grants 107,960 89,357 (18,603) 58% 48% a)c) 185,075 164,518 (20,557)
State Miscellaneous 8,524 8,524 58% n/a a) 53,714 53,714
SB #1065 -Court Assess. 37,333 32,085 (5,248) 58% 50% 64,000 64,000
Discovery Fee 9,333 9,409 76 58% 59% 16,000 20,000 4,000
Food Subsidy 22,750 14,723 (8,027) 58% 38% b) 39,000 39,000
Juvenile Crime Prevention 212,433 165,404 (47,029) 58% 45% c) 364,171 377,770 13,599
Inmate/Prisoner Housing 35,000 38,430 3,430 58% 64% 60,000 60,000
Inmate Commissary Fees 292 504 212 58% 101% 500 800 300
Contract Payments 200,489 152,641 (47,848) 58% 44% d) 343,696 248,000 (95,696)
Miscellaneous 175 354 179 58% 118% 300 354 54
MIP Diversion Fees 933 440 (493) 58% 28% 1,600 1,000 (600)
Interest on Investments 17,500 23,433 5,933 56% 78% 30,000 36,000 6,000
Leases 7,350 3,501 (3,849) 58% 28% e) 12,600 5,050 (7,550)
Grants - Private 70 70 58% n/a 70 70
Crime Prevention Services - 2,148 2,148 58% n/a 19,700 19,700
Level 7 52,500 20,000 (32,500) 58% 22% c)f) 90,000 60,000 (30,000)
Total Revenues 704,048 561,023 (143,025) 58% 46% 1,206,942 1,149,976 (56,966)
Transfers In -General Fund
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Community Justice -Juvenile
3,504,573 3,504,573
5,298,621 5,226,746 (71,875)
58%
58%
58% 6,007,840 6,007,840
63% 8,304,782 8,318,966 14,184
Exp. %
Personal Services 1,708,300 1,695,582 12,718 58% 58% g) 2,928,514 2,916,000 12,514
Materials and Services 958,919 832,950 125,969 58% 51% 1,643,861 1,515,000 128,861
Capital Outlay 58 58 58% 0% 100 100
Juvenile Resource Center
Personal Services 1,688,385 1,458,024 230,361 58% 50% g) 2,894,375 2,615,000 279,375
Materials and Services 121,084 117,280 3,804 58% 57% 207,573 188,000 19,573
Capital Outlay 58 58 58% 0% 100 100
Contingency 367,651 367,651 58% n/a 630,259 630,259
TOTAL REQUIREMENTS 4,844,455 4,103,836 740,619 58% 49% 8,304,782 7,234,000 1,070,782
NET (Resources - Requirements) 454,166 1,122,910 668,744 - 1,084,966 1,084,966
a) Projection of Federal Grants reduced for budgeted amount to be recorded in State Miscellaneous and increased for Federal
Grant revenue for FY 07-08 requests paid in FY 08-09.
b) Billing submitted monthly for reimbursement. Payments received to date cover July to November.
c) Reimbursements requested quarterly. Juvenile Crime Prevention adjusted for increased amount of award.
d) CEOJJC has placed the Administrative Analyst position on its payroll and assumed 100% responsibility for this position
as of October 1st. Projection reduced by $34,000 due to the ending of reimbursements from CEOJJC to partially
fund this position.
DHS payments expected to be lower than budgeted due to a decrease in number of youth in program. DHS began using
a new disbursement system in December delaying processing of payments.
e) Lease revenue less than estimated in budget due to Rimrock and Interfaith moving out mid year.
f) Budget for Level 7 revenues overestimated by $10,000.
g) Personnel Services projection reduced due to unfilled budgeted positions.
Sheriff - Fund 255
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital $
Revenues
Law Enf Dist Countywide
Law Enf Dist Rural
Interest
Total Revenues
11,679,209
7,214,562
$ 138,600
9,995,933
6,669,914
30,118
$ 138,600 100%
nla $
- $ 138,600 $ 138,600
(1,683,276) 58% 50% a) 20,021,501
(544,648) 58% 54% a) 12,367,820
30,118 58% n/a -
18,893,771
TOTAL RESOURCES 18,893,771
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 1,307,429
Civil 691,093
Automotive/Communications 762,688
Investigations/Evidence 997,967
Patrol/Civil/Comm Supp 4,548,802
Records 388,328
Adult Jail 5,753,129
Court Security 125,495
Emergency Services 102,331
Special Services Division 744,121
Regional Work Center 1,550,966
Training Division 141,622
Non -Departmental 25,506
Contingency 1,725,130
16,695,965
16,834,565
1,157,799
629,042
799,899
951,531
4,415,717
393,448
5,259,706
116,447
97,239
833,431
1,460,947
127,014
31,406
Transfers Out 29,167 25,000
17,383,582
11,080,347
30,118
;2,637,919)
(1,287,473)
30,118
(2,197,806) 58% 52% 32,389,321 28,494,047 (3,895,274)
(2,059,206) 58% 52% 32,389,321 28,632,647 (3,756,674)
149,630
62,051
(37,211)
46,436
133,085
(5,120)
493,423
9,048
5,092
(89,310)
90,019
14,608
(5,900)
1,725,130
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
Exp. %
52%
53%
61%
56%
57%
59%
53%
54%
55%
65%
55% h)
52%
72%
n/a
b)
c)
d)
e)
f)
g)
4,167 58% 50%
TOTAL REQUIREMENTS 18,893,774 16,298,626
2,241,306
1,184,729
1,307,464
1,710,801
7,797,946
665,705
9,862,507
215,135
175,424
1,275,636
2,658,798
242,780
43,725
2,957,365
2,196,306
1,144,729
1,277,364
1,656,801
7,547,946
665,605
9,312,507
215,035
175,324
1,277,109
2,658,798
242,680
43,725
50,000 50,000
45,000
40,000
30,100
54,000
250,000
100
550,000
100
100
(1,473)
100
2,957,365
2,595,148 58% 50% 32,389,321 28,463,929 3,925,392
NET (Resources - Requirements) (3) 535,939 535,942 168,718 168,718
Year End
Budget
Projection
Variance
nla $
- $ 138,600 $ 138,600
(1,683,276) 58% 50% a) 20,021,501
(544,648) 58% 54% a) 12,367,820
30,118 58% n/a -
18,893,771
TOTAL RESOURCES 18,893,771
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Sheriffs Division 1,307,429
Civil 691,093
Automotive/Communications 762,688
Investigations/Evidence 997,967
Patrol/Civil/Comm Supp 4,548,802
Records 388,328
Adult Jail 5,753,129
Court Security 125,495
Emergency Services 102,331
Special Services Division 744,121
Regional Work Center 1,550,966
Training Division 141,622
Non -Departmental 25,506
Contingency 1,725,130
16,695,965
16,834,565
1,157,799
629,042
799,899
951,531
4,415,717
393,448
5,259,706
116,447
97,239
833,431
1,460,947
127,014
31,406
Transfers Out 29,167 25,000
17,383,582
11,080,347
30,118
;2,637,919)
(1,287,473)
30,118
(2,197,806) 58% 52% 32,389,321 28,494,047 (3,895,274)
(2,059,206) 58% 52% 32,389,321 28,632,647 (3,756,674)
149,630
62,051
(37,211)
46,436
133,085
(5,120)
493,423
9,048
5,092
(89,310)
90,019
14,608
(5,900)
1,725,130
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
Exp. %
52%
53%
61%
56%
57%
59%
53%
54%
55%
65%
55% h)
52%
72%
n/a
b)
c)
d)
e)
f)
g)
4,167 58% 50%
TOTAL REQUIREMENTS 18,893,774 16,298,626
2,241,306
1,184,729
1,307,464
1,710,801
7,797,946
665,705
9,862,507
215,135
175,424
1,275,636
2,658,798
242,780
43,725
2,957,365
2,196,306
1,144,729
1,277,364
1,656,801
7,547,946
665,605
9,312,507
215,035
175,324
1,277,109
2,658,798
242,680
43,725
50,000 50,000
45,000
40,000
30,100
54,000
250,000
100
550,000
100
100
(1,473)
100
2,957,365
2,595,148 58% 50% 32,389,321 28,463,929 3,925,392
NET (Resources - Requirements) (3) 535,939 535,942 168,718 168,718
RESOURCES:
Beg. Net Working Capital
Total Revenues
SHERIFF -Expenditure Detail
Statement of Financial Operating Data
Seven Months Ended
January 31. 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
Revised
Year End
Budget
Projection
Variance
$ - $ 138,600 $ 138,600 100% n/a $ - $ 138,600 $ 138,600
18,893,771 16,695,965 (2,197,806) 58% 52% 32,389,321 28,494,047 (3,895,274)
TOTAL RESOURCES 18,893,771 16,834,565 (2,059,206) 58% 52% 32,389,321 28,632,647 (3,756,674)
REQUIREMENTS:
Sheriffs Services
Personnel 668,574 651,583 16,991 58% 57% 1,146,126 1,126,126 20,000
Materials B Services 479,897 479,754 143 58% 58% 822,680 822,680 -
Capital Outlay 158,958 26,462 132,496 58% 10% 272,500 247,500 25,000
Total Sheriffs Services 1,307,429 1,157,799 149,630 2,241,306 2,196,306 45,000
Civil
Personnel 635,144 598,399 36,745 58% 55% 1,088,818 1,048,818 40,000
Materials B Services 37,438 30,643 6,795 58% 48% 64,179 64,179
Capital Outlay 18,510 18,510 58% 0% 31,732 31,732
Total Civil 691,092 629,042 62,050 1,184,729 1,144,729 40,000
Automotive/Communications
Personnel 224,845 192,964 31,881 58% 50% 385,449 355,449 30,000
Materials BServices 537,784 606,935 (69,151) 58% 66% 921,915 921,915
Capital Outlay 58 58 58% 0% 100 100
Total AutomotivelCommunications 762,687 799,899 (37,212) 1,307,464 1,277,364 30,100
I nvestigations/Evidence
Personnel 835,053 803,005 32,048 58% 56% 1,431,519 1,431,519
Materials B Services 148,915 125,216 23,699 58% 49% 255,282 201,282 54,000
Capital Outlay 14,000 23,310 (9,310) 58% 97% 24,000 24,000
Total Investigations/Evidence 997,968 951,531 46,437 1,710,801 1,656,801 54,000
Patrol/Civil/Comm Support
Personnel 4,034,658 3,755,698 278,960 58% 54% 6,916,557 6,666,557 250,000
Materials & Services 315,764 342,804 (27,040) 58% 63% 541,309 541,309
Capital Outlay 198,380 317,215 (118,835) 58% 93% 340,080 340,080 -
Total Patrol/Civil/Comm Supp 4,548,802 4,415,717 133,085 7,797,946 7,547,946 250,000
Records
Personnel 339,644 339,482 162 58% 58% 582,246 582,246
Materials & Services 48,626 53,966 (5,340) 58% 65% 83,359 83,359
Capital Outlay 58 58 58% 0% 100 - 100
Total Records 388,328 393,448 (5,120) 665,705 665,605 100
Adult Jail
Personnel 4,384,561 4,031,266 353,295 58% 54% 7,516,390 7,166,390 350,000
Materials & Services 796,318 731,989 64,329 58% 54% 1,365,117 1,365,117
Capital Outlay 572,250 496,451 75,799 58% 51% 981,000 781,000 200,000
Total Adult Jail 5,753,129 5,259,706 493,423 9,862,507 9,312,507 550,000
Court Security
Personnel 116,379 113,018 3,361 58% 57% 199,506 199,506
Materials & Services 9,059 3,429 5,630 58% 22% 15,529 15,529
Capital Outlay 58 58 58% 0% 100 - 100
Total Transport/Court Security 125,496 116,447 9,049 215,135 215,035 100
Emergency Services
Personnel 92,477 91,069 1,408 58% 57% 158,532 158,532
Materials B Services 9,795 6,170 3,625 58% 37% 16,792 16,792
Capital Outlay 58 - 58 58% 0% 100 - 100
Total Emergency Services 102,330 97,239 5,091 175,424 175,324 100
Special Services
Personnel 476,328 467,227 9,101 58% 57% 816,563 816,563
Materials B Services 100,875 78,586 22,289 58% 45% 172,928 172,928
Capital Outlay 166,918 287,618 (120,700) 58% 101% 286,145 287,618 (1,473)
Total Special Services 744,121 833,431 (89,310) 1,275,636 1,277,109 (1,473)
Regional Work Center
Personnel 1,266,720 1,301,849 (35,129) 58% 60% 2,171,520 2,246,520 (75,000)
Materials B Services 265,579 136,104 129,475 58% 30% 455,278 380,278 75,000
Capital Outlay 18,667 22,994 (4,327) 58% 72% 32,000 32,000 -
Total Regional Work Center 1,550,966 1,460,947 90,019 2,658,798 2,658,798
Training
Personnel 112,811 105,945 6,866 58% 55% 193,391 193,391
Materials B Services 28,752 21,069 7,683 58% 43% 49,289 49,289
Capital Outlay 58 58 58% 0% 100 100
Total Training 141,621 127,014 14,607 242,780 242,680 100
Non -Departmental
Materials B Services 25,506 31,406 (5,900) 58% 72% 43,725 43,725
Transfers Out 29,167 25,000 4,167 58% 50% 50,000 50,000 -
Contingency 1,725,130 1,725,130 58% n/a 2,957,365 - 2,957,365
Total Non -Departmental 1,779,803 56,406 1,723,397 3,051,090 93,725 2,957,365
Total Requirements 18,893,772 16,298,626 2,595,146 58% 50% 32,389,321 28,463,929 3,925,392
Exp. %
NET (Resources - Requirements)
(1) 535,939 535,940 168,718 168,718
Sheriff Notes
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
a) IGA with Countywide & Rural Law Enforcement Districts, based on actual costs and payment,
is adjusted to actual quarterly. Actual 1st and 2nd quarter expenditures were less than budgeted.
Actual expenditures for FY 2009 are projected to be less than budgeted.
b) Sheriff's Services Division year-to-date variance is due to timing of Capital Projects and one open
position which has been filled. Expenditures for capital software will be less than planned for tie year.
c) Personnel expenditures in Civil will be less than budget by approximately $40,000 for the year
due to unfilled budgeted positions.
d) Automotive/Communications year-to-date variance is due to timing of budget and actual purchase
of material and services for new car preparation. Personnel expenses for the year will be Tess than
budgeted due to an open position which was filled in the 2nd quarter.
e) Expenditures of $54,000 planned for Byrne Grant will not be incurred as the grant was not
renewed.
f) Personnel expenditures in Patrol will be less than budget by approximately $250,000 for the
year due to unfilled budgeted employee positions.
g)
Adult Jail year-to-date variance is due to delays in filling open positions. Capital
expenditures for the jail control panel system project will be incurred later in the year and will
be less than budgeted. The delays in hiring and lower capital expenditures will result in the
Adult Jail expenditures at $550,000 less than budgeted.
h) Work Center year-to-date variance due to timing of expenditures for inmate Addictions
Treatment programs and other expenses related to inmate population.
Sheriff 701
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $2,560,294 $ 2,611,374 $ 51,080 58% n/a $ 2,560,294 $2,611,374 $ 51,080
Revenues
Tax Revenues - Current 8,498,345 12,701,550 4,203,205 58% 87% a) 14,568,591 14,206,458 (362,133)
Tax Revenues - Prior 157,180 424,254 267,074 58% 157% b) 269,452 524,254 254,802
Federal Grants 11,667 35,354 23,687 58% n/a 20,000 35,354 15,354
State Grant 26,341 52,476 26,135 58% 116% c) 45,156 69,000 23,844
Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000
SB 1145 1,129,228 967,910 (161,318) 58% 50% 1,935,819 1,935,819
Des Cty Court Security 75,250 75,019 (231) 58% 58% 129,000 129,000
Des Cty Juvenile Contract 14,000 1,582 (12,418) 58% 7% d) 24,000 3,000 (21,000)
Transport 2,365 2,365 58% n/a 2,365 2,365
Title III Reimbursement 75,000 75,000 58% n/a e) 150,000 150,000
DC Fair & Expo Center 5,415 5,415 58% n/a 5,415 5,415
Local Gov't Pmts 2,235 2,235 58% n/a 2,235 2,235
Inmate Commissary Fees 35,000 39,079 4,079 58% 65% 60,000 60,000 -
Work Center Work Crews 87,500 22,605 (64,895) 58% 15% f) 150,000 50,000 (100,000)
Concealed Handgun Classes 933 3,375 2,442 58% n/a 1,600 6,000 4,400
Soc Sec Incentive -Fed 2,333 4,200 1,867 58% 105% 4,000 5,000 1,000
Miscellaneous 292 1,441 1,149 58% 288% 500 4,026 3,526
Oregon Mentors 4,414 4,414 58% n/a 8,000 8,000
Medical Services Reimb 7,000 9,359 2,359 58% 78% 12,000 12,000
Restitution 613 265 (348) 58% 25% 1,050 1,050
Sheriff Fees 89,609 94,803 5,194 58% 62% 153,615 153,615
Interest 26,250 48,499 22,249 58% 108% 45,000 85,000 40,000
Interest on Unsegregated 2,100 5,566 3,466 58% 155% 3,600 10,600 7,000
Rentals 19,146 55,530 36,384 58% 169% g) 32,824 62,824 30,000
Donations 48 48 58% n/a 48 48
Total Revenues 10,185,704 14,632,344 4,446,640 58% 84% 17,461,207 17,526,063 64,856
TOTAL RESOURCES 12,745,998 17,243,718 4,497,720 58% 86% 20,021,501 20,137,437 115,936
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 11,679,210
Exp. %
9,995,933 1,683,277 58% 50% h) 20,021,501 17,383,582 2,637,919
TOTAL REQUIREMENTS 11,679,210 9,995,933 1,683,277 58% 50% 20,021,501 17,383,582 2,637,919
NET (Resources - Requirements)
1,066,788 7,247,785 6,180,997 - 2,753,855 2,753,855
a) Historically, 85% of property tax receipts are collected through November. Current analysis indicates 2.5% variance from budget.
b) Delinquent FY 2008 taxes exceeded amounts estimated.
c) Revised State funding allocation.
d) Expect Tess revenue for court security from the Juvenile Department.
e) Title III revenue was not included in FY2009 budget due to uncertainty of Timber Payments renewal.
f) Expect revenue to increase as work crews expand but work crew revenue will be less than budgeted due to economic down turn.
g) Rental receipts from 911 not included in FY 2009 budget due to uncertainty of 911 levy passing.
h) IGA with DCSO based on actual costs and payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters
were less than budgeted.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $2,560,294 $ 2,611,374 $ 51,080 58% n/a $ 2,560,294 $2,611,374 $ 51,080
Revenues
Tax Revenues - Current 8,498,345 12,701,550 4,203,205 58% 87% a) 14,568,591 14,206,458 (362,133)
Tax Revenues - Prior 157,180 424,254 267,074 58% 157% b) 269,452 524,254 254,802
Federal Grants 11,667 35,354 23,687 58% n/a 20,000 35,354 15,354
State Grant 26,341 52,476 26,135 58% 116% c) 45,156 69,000 23,844
Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000
SB 1145 1,129,228 967,910 (161,318) 58% 50% 1,935,819 1,935,819
Des Cty Court Security 75,250 75,019 (231) 58% 58% 129,000 129,000
Des Cty Juvenile Contract 14,000 1,582 (12,418) 58% 7% d) 24,000 3,000 (21,000)
Transport 2,365 2,365 58% n/a 2,365 2,365
Title III Reimbursement 75,000 75,000 58% n/a e) 150,000 150,000
DC Fair & Expo Center 5,415 5,415 58% n/a 5,415 5,415
Local Gov't Pmts 2,235 2,235 58% n/a 2,235 2,235
Inmate Commissary Fees 35,000 39,079 4,079 58% 65% 60,000 60,000 -
Work Center Work Crews 87,500 22,605 (64,895) 58% 15% f) 150,000 50,000 (100,000)
Concealed Handgun Classes 933 3,375 2,442 58% n/a 1,600 6,000 4,400
Soc Sec Incentive -Fed 2,333 4,200 1,867 58% 105% 4,000 5,000 1,000
Miscellaneous 292 1,441 1,149 58% 288% 500 4,026 3,526
Oregon Mentors 4,414 4,414 58% n/a 8,000 8,000
Medical Services Reimb 7,000 9,359 2,359 58% 78% 12,000 12,000
Restitution 613 265 (348) 58% 25% 1,050 1,050
Sheriff Fees 89,609 94,803 5,194 58% 62% 153,615 153,615
Interest 26,250 48,499 22,249 58% 108% 45,000 85,000 40,000
Interest on Unsegregated 2,100 5,566 3,466 58% 155% 3,600 10,600 7,000
Rentals 19,146 55,530 36,384 58% 169% g) 32,824 62,824 30,000
Donations 48 48 58% n/a 48 48
Total Revenues 10,185,704 14,632,344 4,446,640 58% 84% 17,461,207 17,526,063 64,856
TOTAL RESOURCES 12,745,998 17,243,718 4,497,720 58% 86% 20,021,501 20,137,437 115,936
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 11,679,210
Exp. %
9,995,933 1,683,277 58% 50% h) 20,021,501 17,383,582 2,637,919
TOTAL REQUIREMENTS 11,679,210 9,995,933 1,683,277 58% 50% 20,021,501 17,383,582 2,637,919
NET (Resources - Requirements)
1,066,788 7,247,785 6,180,997 - 2,753,855 2,753,855
a) Historically, 85% of property tax receipts are collected through November. Current analysis indicates 2.5% variance from budget.
b) Delinquent FY 2008 taxes exceeded amounts estimated.
c) Revised State funding allocation.
d) Expect Tess revenue for court security from the Juvenile Department.
e) Title III revenue was not included in FY2009 budget due to uncertainty of Timber Payments renewal.
f) Expect revenue to increase as work crews expand but work crew revenue will be less than budgeted due to economic down turn.
g) Rental receipts from 911 not included in FY 2009 budget due to uncertainty of 911 levy passing.
h) IGA with DCSO based on actual costs and payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters
were less than budgeted.
Sheriff 702
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 1,169,561 $ 1,178,512 $ 8,951 58% n/a $ 1,169,561 $ 1,178,512 $ 8,951
Revenues
Tax Revenues - Current 4,139,820 6,213,329 2,073,509 58% 88% a) 7,096,836 6,949,467 (147,369)
Tax Revenues - Prior 75,125 235,540 160,415 58% 183% b) 128,785 295,540 166,755
Federal Grants 16,625 13,135 (3,490) 58% 46% 28,500 28,500
US Forest Service 42,000 25,125 (16,875) 58% 35% 72,000 72,000
State Grant 46,312 45,571 (741) 58% 57% 79,392 79,392
SB #1065 Court Assessment 39,083 32,085 (6,998) 58% 48% 67,000 67,000
Marine Board License Fee 57,717 (57,717) 58% 0% c) 98,944 98,944
Narcotic Task Force 64,167 27,500 (36,667) 58% 25% d) 110,000 27,500 (82,500)
Des Cty General Fund Grnt 125,405 (125,405) 58% 0% e) 214,980 214,980
Des Cty Transient Room Tax 1,420,428 1,420,428 58% 58% 2,435,020 2,435,020
Des Cty Other Grant 73,597 (73,597) 58% 0% f) 126,167 - (126,167)
City of Sisters 229,399 233,342 3,943 58% 59% 393,255 400,014 6,759
Des Cty Tax/Fin Contract 1,604 860 (744) 58% 31% 2,750 2,750 -
Des Cty CDD Contract 31,713 29,447 (2,266) 58% 54% g) 54,365 33,978 (20,387)
Des Cty Solid Waste Cntrt 31,713 33,977 2,264 58% 62% g) 54,365 74,752 20,387
Des Cty Clerk/Election 1,750 2,026 276 58% 68% 3,000 3,000
Security & Traffic Reimb 15,167 1,316 (13,851) 58% 5% h) 26,000 13,000 (13,000)
Seat Belt Program 3,500 4,700 1,200 58% 78% 6,000 6,000 -
Miscellaneous 1,458 6,398 4,940 58% n/a 2,500 13,655 11,155
Sheriff Fees 2,917 3,702 785 58% n/a 5,000 5,000
Court Fines & Fees 49,583 63,662 14,079 58% 75% 85,000 85,000
Impound Fees 43,750 43,500 (250) 58% 58% 75,000 75,000 -
Interest 17,500 13,820 (3,680) 58% 46% 30,000 30,000
Interest on Unsegregated 1,400 2,722 1,322 58% 113% 2,400 5,400 3,000
Grants - Private 6,000 6,000 58% n/a 6,000 6,000
Sale of Equip & Material 583 4,526 3,943 58% 453% 1,000 6,000 5,000
Total Revenues 6,532,316 8,462,712 1,930,396 58% 76% 11,198,259 11,027,892 (170,367)
TOTAL RESOURCES 7,701,877 9,641,224 1,939,347 58% 78% 12,367,820 12,206,404 (161,416)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 7,214,562
Exp. %
6,669,914 544,648 58% 54% g) 12,367,820 11,080,347 1,287,473
TOTAL REQUIREMENTS 7,214,562 6,669,914 544,648 58% 54% 12,367,820 11,080,347 1,287,473
NET (Resources - Requirements)
487,315 2,971,310 2,483,995 - 1,126,057 1,126,057
a) Historically, 85% of property tax receipts are collected through November. Current analysis indicates a 2.1% variance from budget.
b) Delinquent FY 2008 taxes exceeded amounts estimated.
c) Marine Board fees for marine patrol are received semi-annually in Feb. and June.
d) Additional Byrne Grant revenue will not be received this year.
e) Payment from Deschutes County (General Fund) will be made in June 2009.
f) Court fines and fees collected by Justice Court will be Tess than expenses resulting in no transfer to Sheriff's Office (M. Wynr e).
g) Adjustment made in law enforcement service levels between CDD and Solid Waste. IGA with DCSO based on actual costs ;rnd
payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters were less than budgeted.
h) Fewer events requiring patrol/traffic control services.
Year End
Budget
Projection
Variance
TOTAL RESOURCES 7,701,877 9,641,224 1,939,347 58% 78% 12,367,820 12,206,404 (161,416)
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Materials and Services 7,214,562
Exp. %
6,669,914 544,648 58% 54% g) 12,367,820 11,080,347 1,287,473
TOTAL REQUIREMENTS 7,214,562 6,669,914 544,648 58% 54% 12,367,820 11,080,347 1,287,473
NET (Resources - Requirements)
487,315 2,971,310 2,483,995 - 1,126,057 1,126,057
a) Historically, 85% of property tax receipts are collected through November. Current analysis indicates a 2.1% variance from budget.
b) Delinquent FY 2008 taxes exceeded amounts estimated.
c) Marine Board fees for marine patrol are received semi-annually in Feb. and June.
d) Additional Byrne Grant revenue will not be received this year.
e) Payment from Deschutes County (General Fund) will be made in June 2009.
f) Court fines and fees collected by Justice Court will be Tess than expenses resulting in no transfer to Sheriff's Office (M. Wynr e).
g) Adjustment made in law enforcement service levels between CDD and Solid Waste. IGA with DCSO based on actual costs ;rnd
payment is adjusted to actual each quarter. Actual expenditures for 1st and 2nd quarters were less than budgeted.
h) Fewer events requiring patrol/traffic control services.
HEALTH
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY
Coll. %
RESOURCES:
Beg. Net Working Capital $ 707,000 $ 972,436 $ 265,436 100% 138%
Revenues
Medicare Reimbursement 2,333 1,548 (785) 58% 39% a) 4,000 4,000
State Grant 929,725 970,872 41,147 58% 61% b) 1,593,814 1,852,066 258,252
Child Dev & Rehab Center 20,263 (20,263) 58% 0% c) 34,737 34,737
State Miscellaneous 155,070 144,597 (10,473) 58% 54% 265,834 265,834
STARS Foundation - 2,650 2,650 58% n/a 2,650 2,650
OMAP 157,500 152,715 (4,785) 58% 57% 270,000 270,000
Family Planning Exp Proj 277,083 213,897 (63,186) 58% 45% d) 475,000 475,000
Grants 20,008 20,008 58% n/a 20,008 20,008
Contract Payments/ESD 4,667 (4,667) 58% 0% e) 8,000 8,000
Miscellaneous 670 670 58% n/a 800 800
Patient Insurance Fees 53,346 84,504 31,158 58% 92% f) 91,450 131,450 40,000
Health Dept/Patient Fees 129,792 88,973 (40,819) 58% 40% f) 222,500 182,500 (40,000)
Vital Records -Birth 23,333 19,665 (3,668) 58% 49% 40,000 40,000
Vital Records -Death 54,833 61,035 6,202 58% 65% 94,000 94,000
Interest on Investments 22,167 16,708 (5,459) 58% 44% 38,000 38,000
Donations 5,308 4,629 (679) 58% 51% 9,100 9,100
Interfund Contract 73,641 27,220 (46,421) 58% 22% g) 126,242 113,160 (13,082)
Administrative Fee 15,750 15,750 58% 58% 27,000 27,000
Interfund Grant 10,713 10,713 58% n/a 10,713 10,713
Total Revenues 1,924,811 1,836,154 (88,657) 58% 56% 3,299,677 3,579,018 279,341
Revised
Year End
Budget
Projection
Variance
$ 707,000 $ 972,436 $ 265,436
Transfers In -Reserve Fund 14,583 - (14,583) 58% 0% 25,000 25,000
Transfers In -General Fund 1,540,721 1,540,721 - 58% 58% 2,641,236 2,641,236
TOTAL RESOURCES 4,187,115 4,349,311 176,779 58% 65% 6,672,913 7,217,690 544,777
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
Exp. %
2,650,999 2,635,308 15,691 58% 58% 4,544,569 4,536,160 8,409
820,475 796,514 23,961 58% 57% 1,406,529 1,406,529
43,750 47,227 (3,477) 58% 63% 75,000 75,000
87,500 75,000 12,500 58% 50% 150,000 150,000
289,809 289,809 58% n/a 496,815 496,815
3,892,533 3,554,049 338,484 58% 53% 6,672,913 6,167,689 505,224
294,582 795,262 515,263 - 1,050,001 1,050,001
a) Corrections required to DCHD Medicare status, application process. Most claims currently on hold.
b) Projection includes revisions 1 - 5 to State Grant.
c) Payments received quarterly during the October 08 through September 09 contract period.
d) Payments are received one month in arrears.
e) Contract not yet signed.
f) Began billing private insurance for immunizations - budgeted to bill patients direct.
g) Payments normally received 30 days after the end of each quarter.
RESOURCES:
Beg. Net Working Capital $ 2,750,000 $ 2,695,308 $ (54,692) 100% 98% $ 2,750,000 $ 2,695,308 $ (54,692)
Revenues
Marriage Licenses 3,208 3,250 42 58% 59% 5,500 5,500
MENTAL HEALTH
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Revised
Year to Date
Budget
Actual Variance
FY % Coll. %
Revised
Year End
Budget
Projection
Variance
Divorce Filing Fees 72,917 67,729 (5,188) 58% 54% 125,000 125,000
Domestic Partnership Fee 1,167 70 (1,097) 58% n/a 2,000 2,000
Federal Grants 140,870 22,970 (117,900) 58% 10% a)b) 241,492 229,184 (12,308)
State Grants 3,116,975 3,112,342 (4,633) 58% 58% 5,343,386 5,343,386
State Miscellaneous 104,834 69,059 (35,775) 58% 38% c) 179,716 179,716
Title 19 175,411 158,999 (16,412) 58% 53% 300,705 300,705
Liquor Revenue 61,833 59,068 (2,765) 58% 56% 106,000 106,000
School Districts 58,333 34,500 (23,833) 58% 35% d) 100,000 70,000 (30,000)
Contract Payments 7,020 7,020 58% n/a 14,040 14,040
Miscellaneous 51,217 52,307 1,090 58% 60% 87,800 87,800
Patient Insurance Fees 126,875 78,961 (47,914) 58% 36% 217,500 200,000 (17,500)
Patient Fees 6,708 4,502 (2,206) 58% 39% 11,500 8,500 (3,000)
Interest on Investments 42,583 53,327 10,744 58% 73% 73,000 88,000 15,000
Rentals 9,625 8,000 (1,625) 58% 48% 16,500 16,500
Donations 5,833 100 (5,733) 58% 1% 10,000 3,500 (6,500)
Interfund Contract 1,820 7,464 5,644 58% 239% 3,120 8,764 5,644
Administrative Fee 1,689,800 1,660,351 (29,449) 58% 57% 2,896,800 2,921,800 25,000
Crime Prevention Services 83,932 41,214 (42,718) 58% 29% b) 143,884 143,884
Total Revenues
5,753,941 5,441,233 (312,708) 58% 55% 9,863,903 9,854,279 (9,624)
Transfers In -General Fund 904,691
Transfers In -Other 264,731
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
904,691 58% 58% 1,550,899 1,550,899
295,648 30,917 58% 65% 453,825 506,825 53,000
9,673,363 9,336,880 (336,483) 58% 64% 14,618,627 14,607,311 (11,316)
Exp. %
4,931,399 4,656,836 274,563 58% 55% e) 8,453,826 7,790,000 663,826
2,574,622 2,087,493 487,129 58% 47% 4,413,638 4,150,000 263,638
58 58 58% 0% 100 - 100
87,500 75,000 12,500 58% 50% 150,000 150,000
933,953 933,953 58% n/a 1,601,063 1,601,063
TOTAL REQUIREMENTS 8,527,532 6,819,329 1,708,203 58% 47% 14,618,627 12,090,000 2,528,627
NET (Resources - Requirements) 1,145,831 2,517,551 1,371,720 - 2,517,311 2,517,311
a) Negative variance due to an adjustment for over -accrual of FY 2008 revenue.
b) Grant billing paid quarterly, in arrears.
c) State miscellaneous YTD actual variance due to historical 30-60 day delay in receiving payment.
d) Services to school districts commence at start of school year and are billed monthly in arrears.
e) Anticipated salary savings due to unfilled positions and reduce work schedule beginning March 1, 2009.
RESOURCES:
Beg. Net Working Capital
Revenues
Admin -Operations
Admin -GIS
Admin -Code Enforcement
Building Safety
Electrical
Contract Services
Env Health -On Site Prog
Env Health-Lic Facilities
Env Health - Drinking H2O
Planning -Current
Planning -Long Range
Total Revenues
Trans In -CDD Reserve
Trans In -CDD Bldg!Elec
Trans In -Gen Fund
Trans In -Newberry (297)
Trans In -Other
TOTAL RESOURCES
COMMUNITY DEVELOPMENT
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ (2,777,224) $(2,667,071)
20,563
2,917
179,958
1,004,325
265,490
310,333
425,658
399,671
44,897
805,860
353,380
(7,967)
1,211
113,253
552,058
151,501
112,076
157,777
523,888
52,556
515,214
155,846
$ 110,153 100% 96%
(28,530)
(1,706)
(66,705)
(452,267)
(113,989)
(198,257)
(267,881)
124,217
7,659
(290,646)
(197,534)
3,813,052
1,447,898
1,317,006
48,250
58
58% -23%
58% 24%
58% 37%
58% 32%
58%
58% 21%
58% 22%
58% 76%
58% 68%
58%
58% 26%
33%
37%
2,327,413 (1,485,639) 58% 36%
1,399,756
1,144,255
116,667
131,666
(48,142)
(172,751)
116,667
83,416
(58)
3,849,040
REQUIREMENTS:
EXPENDITURES & TRANSFERS
Admin -Operations Division 1,253,117
154,438
143,462
632,158
209,861
166,835
200,402
316,523
51,367
48,344
635,807
372,371
Admin -GIS Division
Admin -Code Enforcement
Building Safety Division
Electrical Division
Contract Services
Env Health -On Site Pgm
Env Health -tic Facilities
Env Health - Drinking H2O
EPA Grant
Planning -Current Division
Planning -Long Range Div
Transfers Out (D/S Fund)
Contingency
719,452
2,452,686 (1,396,354)
1,171,808
137,107
129,763
599,579
169,463
172,555
168,651
296,988
46,666
40,824
538,578
308,636
150,000
58%
58%
0%
0%
0%
58%
a)
b)
c)
c)
c)
d)
c)
e)
d)
c)
c)
56%
51%
n/a f)
159% g)
0%
29%
Exp. %
$(2,777,224)
35,250
5,000
308,500
1,721,700
455,125
532,000
729,700
685,150
76,967
1,381,475
605,795
$(2,667,071) 110,153
13,500
2,100
202,000
1,040,000
270,000
204,000
285,000
685,150
76,967
880,000
446,500
(21,750)
(2,900)
(106,500)
(681,700)
(185,125)
(328,000)
(444,700)
(501,475)
(159,295)
6,536,662 4,105,217 (2,431,445)
2,482,111
2,257,725
0
82,714
100
2,482,111
2,257,725
200,000
131,666
200,000
48,952
(100)
8,582,088 6,509,648 (2,072,440)
81,309 58% 55% h) 2,148,200
17,331 58% 52% h) 264,751
13,699 58% 53% h) 245,934
32,579 58% 55% i) 1,083,700
40,398 58% 47% h) 359,761
(5,720) 58% 60% h) 286,002
31,751 58% 49% h) 343,547
19,535 58% 55% h) 542,610
4,701 58% 53% h) 88,057
7,520 58% 49% h) 82,875
97,229 58% 49% h) 1,089,954
63,735 58% 48% h) 638,351
86% 175,000
719,452 58% n/a 1,233,346
2,080,752
249,186
235,000
1,176,165
240,165
185,862
324,000
510,000
83,000
78,000
858,085
565,000
150,000
67,448
15,565
10,934
(92,465)
119,596
100,140
19,547
32,610
5,057
4,875
231,869
73,351
25,000
1,233,346
TOTAL REQUIREMENTS 4,904,137 3,930,618 1,123,519 58% 46% 8,582,088 6,735,215 1,846,873
NET (Resources - Requirements) (1,055,097) (1,477,932) (272,835)
Revenues
Expenditures
Net from Operations
2,327,413
3,930,618
(1,603,205)
(225,567) (225,567)
4,105,217
6,735,215
(2,629,998)
a) Revenue is low in relation to budget due to reduced Addressing Fee, Road Access permits, and interest.
b) Payments for custom GIS work are received as work is requested.
c) Although revenue is seasonal based on development patterns, year end projections are estimated below budget.
d) Revenue is received as clients are billed, usually lagging 1-2 months behind. Projected below budget (Contract Svcs).
e) Revenue is received primarily in December through February after license renewal statements are mailed out.
f) A transfer from the General Fund for long range planning.
g) Payments are received in installments or as billed. Funds to be transferred in from Fund 297.
h) Year end figures adjusted downward to reflect anticipated personnel reduction and reduced work week (36 hours).
i) Expenses increased due to the shift of staffing from Contract Services and Electrical to Building Safety.
Year End
Budget
Projection
Variance
$(2,777,224)
35,250
5,000
308,500
1,721,700
455,125
532,000
729,700
685,150
76,967
1,381,475
605,795
$(2,667,071) 110,153
13,500
2,100
202,000
1,040,000
270,000
204,000
285,000
685,150
76,967
880,000
446,500
(21,750)
(2,900)
(106,500)
(681,700)
(185,125)
(328,000)
(444,700)
(501,475)
(159,295)
6,536,662 4,105,217 (2,431,445)
2,482,111
2,257,725
0
82,714
100
2,482,111
2,257,725
200,000
131,666
200,000
48,952
(100)
8,582,088 6,509,648 (2,072,440)
81,309 58% 55% h) 2,148,200
17,331 58% 52% h) 264,751
13,699 58% 53% h) 245,934
32,579 58% 55% i) 1,083,700
40,398 58% 47% h) 359,761
(5,720) 58% 60% h) 286,002
31,751 58% 49% h) 343,547
19,535 58% 55% h) 542,610
4,701 58% 53% h) 88,057
7,520 58% 49% h) 82,875
97,229 58% 49% h) 1,089,954
63,735 58% 48% h) 638,351
86% 175,000
719,452 58% n/a 1,233,346
2,080,752
249,186
235,000
1,176,165
240,165
185,862
324,000
510,000
83,000
78,000
858,085
565,000
150,000
67,448
15,565
10,934
(92,465)
119,596
100,140
19,547
32,610
5,057
4,875
231,869
73,351
25,000
1,233,346
TOTAL REQUIREMENTS 4,904,137 3,930,618 1,123,519 58% 46% 8,582,088 6,735,215 1,846,873
NET (Resources - Requirements) (1,055,097) (1,477,932) (272,835)
Revenues
Expenditures
Net from Operations
2,327,413
3,930,618
(1,603,205)
(225,567) (225,567)
4,105,217
6,735,215
(2,629,998)
a) Revenue is low in relation to budget due to reduced Addressing Fee, Road Access permits, and interest.
b) Payments for custom GIS work are received as work is requested.
c) Although revenue is seasonal based on development patterns, year end projections are estimated below budget.
d) Revenue is received as clients are billed, usually lagging 1-2 months behind. Projected below budget (Contract Svcs).
e) Revenue is received primarily in December through February after license renewal statements are mailed out.
f) A transfer from the General Fund for long range planning.
g) Payments are received in installments or as billed. Funds to be transferred in from Fund 297.
h) Year end figures adjusted downward to reflect anticipated personnel reduction and reduced work week (36 hours).
i) Expenses increased due to the shift of staffing from Contract Services and Electrical to Building Safety.
ROAD
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 6,392,830
Revenues
System Development Ch 11,667
Mineral Lease Royalties 2,917
Forest Receipts 1,608,647
State Grant 985,429
State Miscellaneous -
Motor Vehicle Revenue 4,462,500
City of Bend 145,833
City of Redmond 233,333
City of Sisters 29,167
City of La Pine
Miscellaneous
Road Vacations
Interest on Investments
Donations
Interfund Contract
Equipment Repairs
Vehicle Repairs
LID Construction
Vegetation Management
Inter -fund: Forester
Car Washes
Sale of Eqp & Material
Sale of Public Lands
Total Revenues
Trans In - CDD
Trans In - Solid Waste
Trans In -Road Imp Res
$ 6,392,830
Revised
Year End
Budget
Projection
Variance
0 100% 100% $ 6,392,830 $ 6,392,830 $ 0
1,386 (10,281) 58% 7% 20,000 20,000
20,892 17,975 58% n/a 5,000 25,000 20,000
2,759,606 1,150,959 58% 100% a) 2,757,680 2,759,606 1,926
1,689,307 703,878 58% 100% b) 1,689,306 1,689,307 1
5,758 5,758 58% n/a b) - 5,758 5,758
4,479,814 17,314 58% 59% 7,650,000 7,650,000
206,121 60,288 58% 82% c) 250,000 250,000
11,781 (221,552) 58% 3% c) 400,000 400,000
- (29,167) 58% 0% c) 50,000 50,000
11,103 11,103 58% n/a c) 20,000 20,000
23,333 20,263 (3,070) 58% 51% 40,000 40,000
583 500 (83) 58% 50% 1,000 1,000
72,917 120,464 47,547 58% 96% 125,000 180,000 55,000
1,423 2,684 1,261 58% 110% 2,440 2,684 244
507,500 - (507,500) 58% 0% d) 870,000 870,000
175,000 119,955 (55,045) 58% 40% e) 300,000 300,000
58,333 (58,333) 58% 0% d) 100,000 100,000
49,583 (49,583) 58% 0% d) 85,000 85,000
55,417 - (55,417) 58% 0% d) 95,000 95,000
12,833 - (12,833) 58% 0% d) 22,000 22,000
2,042 1,514 (528) 58% n/a e) 3,500 3,500
393,750 424,984 31,234 58% 63% e) 675,000 675,000
117 (117) 58% 0% 200 200
8,832,324 9,876,132 1,043,808 58% 65% 15,141,126 15,244,055 102,929
15,161
502,524
3,407
12,995
430,735
(2,166) 58%
(71,789) 58%
(3,407) 58%
TOTAL RESOURCES 15,746,246 16,712,692 966,446 58%
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Transfers Out
Contingency
3,282,458
6,465,546
2,129,167
175,000
1,030,396
3,193,384
3,709,810
5,126
89,074
2,755,736
2,124,041
175,000
1,030,396
58%
58%
58%
58%
58%
TOTAL REQUIREMENTS 13,082,567 6,908,320 6,174,247 58%
NET (Resources - Requirements)
2,663,679 9,804,372 7,140,693
50%
50% f)
0%
25,990
861,470
5,841
25,990
861,470
5,841
70% 22,427,257 22,530,186 102,929
Exp. %
a) Annual payment to be received in January 2009.
b) Senate Bill 994 ODOT pmt 11/01/08 $1,230,565 balance STP due upon billing
c) Billing upon completion of work.
d) Payment to be received in June 2009 from various funds
e) Billed to County departments monthly in arrears.
f) Payment to be received quarterly from Solid Waste
g) Seasonal expense includes overlays to occur Spring 2009
57%
33%
0%
0%
n/a
g)
9)
5,627,071
11,083,793
3,650,000
300,000
1,766,393
5,627,071
11,083,793
3,650,000
300,000
,766,393
31% 22,427,257 20,660,864 ,766,393
1,869,322 °,869,322
ADULT PAROLE & PROBATION
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 663,144 $ 700,907 $ 37,763 100% 106%
Revenues
State Miscellaneous 19,186 23,180 3,994 58% 70% a) 32,890 32,890
SB 1145 1,693,968 1,451,865 (242,103) 58% 50% b) 2,903,945 2,903,945
Probation Work Crew Fees 19,833 28,173 8,340 58% 83% d) 34,000 34,000
Miscellaneous 2,917 1,870 (1,047) 58% 37% 5,000 5,000
Electronic Monitoring Fee 64,167 98,858 34,691 58% 90% c) 110,000 110,000
Probation Superv. Fees 145,833 143,185 (2,648) 58% 57% 250,000 250,000
Interest on Investments 16,430 18,883 2,453 58% 67% 28,165 28,165 -
Crime Prevention Services 6,250 6,250 58% n/a 25,000 25,000
Drug Court- Byrne 29,167 5,816 (23,351) 58% 12% f) 50,000 29,167 (20,833)
Total Revenues 1,991,501 1,778,080 (213,421) 58% 52% 3,414,000 3,418,167 4,167
$ 663,144 $ 700,907 $ 37,763
Transfers In -General Fund 91,629 91,629 - 58% 58% 157,078 157,078
Transfers In -Video Lottery 61,833 61,833 58% 58% 106,000 106,000
Transfers In -Sheriff 29,167 25,000 (4,167) 58% 50% 50,000 50,000
TOTAL RESOURCES 2,837,274 2,657,449 (179,825) 58% 61% 4,390,222 4,432,152 41,930
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp.
1,864,595 1,721,459 143,136 58% 54% 3,196,449 3,196,449
403,818 492,414 (88,596) 58% 71% e) 692,259 692,259
58 58 58% 0% 100
292,492 292,492 58% n/a 501,414
100
501,414
TOTAL REQUIREMENTS 2,560,963 2,213,873 347,090 58% 50% 4,390,222 3,888,708 501,514
NET (Resources - Requirements)
276,311 443,576 167,265 543,444 543,444
a) Received two quarters of subsidy with one years worth of AIP funds.
b) Funding for two quarters received.
c) Increased use of Electronic Monitoring Devices, in lieu of jail sanctions. Increased court requests for EMD's.
d) New Community Service Specialist has increased efficiency of program thus service population being managed closer and has
better collection rate
e) Recent reorganization required building modifications for Redmond and Bend offices.
f) Byrne grant hasn't released funds.
Year End
Budget
Projection
Variance
$ 663,144 $ 700,907 $ 37,763
Transfers In -General Fund 91,629 91,629 - 58% 58% 157,078 157,078
Transfers In -Video Lottery 61,833 61,833 58% 58% 106,000 106,000
Transfers In -Sheriff 29,167 25,000 (4,167) 58% 50% 50,000 50,000
TOTAL RESOURCES 2,837,274 2,657,449 (179,825) 58% 61% 4,390,222 4,432,152 41,930
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp.
1,864,595 1,721,459 143,136 58% 54% 3,196,449 3,196,449
403,818 492,414 (88,596) 58% 71% e) 692,259 692,259
58 58 58% 0% 100
292,492 292,492 58% n/a 501,414
100
501,414
TOTAL REQUIREMENTS 2,560,963 2,213,873 347,090 58% 50% 4,390,222 3,888,708 501,514
NET (Resources - Requirements)
276,311 443,576 167,265 543,444 543,444
a) Received two quarters of subsidy with one years worth of AIP funds.
b) Funding for two quarters received.
c) Increased use of Electronic Monitoring Devices, in lieu of jail sanctions. Increased court requests for EMD's.
d) New Community Service Specialist has increased efficiency of program thus service population being managed closer and has
better collection rate
e) Recent reorganization required building modifications for Redmond and Bend offices.
f) Byrne grant hasn't released funds.
COMM ON CHILDREN & FAMILIES
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 571,035 $ 532,187 $ (38,848) 100% 93% $ 571,035 $ 532,187 $ (38,848)
Revenues
Federal Grants 138,119 157,845 19,726 58% 67% a) 236,775 310,560 73,785
Title IV - Family Sup/Pres 21,964 18,601 (3,363) 58% 49% a) 37,652 40,982 3,330
HealthyStart Medicaid 75,833 23,655 (52,178) 58% 18% b) 130,000 95,000 (35,000)
Child Care Block Grant 44,136 8,719 (35,417) 58% 12% a) 75,661 87,779 12,118
Level 7 Services 102,196 122,488 20,292 58% 70% a) 175,193 201,546 26,353
Juvenile Crime Prevention 231,613 168,564 (63,049) 58% 42% a) 397,050 471,171 74,121
State Prevention Funds 80,208 43,750 (36,458) 58% 32% f)g) 137,500 187,499 49,999
HealthyStart /R -S -G 213,510 357,117 143,607 58% 98% b) 366,017 357,117 (8,900)
OCCF Grant 431,255 729,986 298,731 58% 99% j) 739,295 876,986 137,691
Miscellaneous 4,667 6,493 1,826 58% 81% 8,0008,000 -
Court Fines & Fees 14,000 35,061 21,061 58% 146% c)g) 24,000 75,000 51,000
Interest on Investments 14,583 21,418 6,835 58% 86% d) 25,000 40,000 15,000
Grants -Private 5,833 (5,833) 58% o% e) 10,0005,000 (5,000)
Total Revenues 1,377,917 1,693,697 315,780 58% 72% 2,362,143 2,756,640 394,497
Trans from General Fund 204,922 204,922 - 58% 58% 351,295 351,295
Trans from GF -Other 4,020 3,446 (574) 58% 50% 6,891 6,891
Total Transfers In 208,942 208,368 (574) 58% 58% 358,186 358,186
TOTAL RESOURCES 2,157,894 2,434,252 276,358 58% 74% 3,291,364 3,647,013 355,649
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
331,416 287,523 43,893 58% 51% 1) 568,142 519,399 48,743
1,331,990 1,161,203 170,787 58% 51% g)h) 2,283,412 2,661,177 (377,765)
58 58 58% 0% 100 - 100
256,498 - 256,498 58% n/a 439,710 439,710
TOTAL REQUIREMENTS 1,919,962 1,448,726 471,236 58%
44%
3,291,364 3,180,576 110,788
NET (Resources - Requirements) 237,932 985,526 747,594 466,437 466,437
a) FY 2008 revenues received and reported in FY 2009.
b) Medicaid revenue projected to be Tess than budget.
c) Circuit Court fees increased to Mary's Place.
d) Interest revenue will exceed budget because monthly cash balance is higher than expected.
e) Youth conference donations projected to be less.
f) Safe & Drug Free Schools grant amount is $100,000 - budgeted @ $50,000.
g) $100,999 of additional resources (Safe & Drug Free Schools and Circuit Court fees).
h) Increase in discretionary spending of $129,766.
i) Personnel reduced due to open position, and new hires.
j) OCCF grants and M&S increased by $147,000 Community Schools grant.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 571,035 $ 532,187 $ (38,848) 100% 93% $ 571,035 $ 532,187 $ (38,848)
Revenues
Federal Grants 138,119 157,845 19,726 58% 67% a) 236,775 310,560 73,785
Title IV - Family Sup/Pres 21,964 18,601 (3,363) 58% 49% a) 37,652 40,982 3,330
HealthyStart Medicaid 75,833 23,655 (52,178) 58% 18% b) 130,000 95,000 (35,000)
Child Care Block Grant 44,136 8,719 (35,417) 58% 12% a) 75,661 87,779 12,118
Level 7 Services 102,196 122,488 20,292 58% 70% a) 175,193 201,546 26,353
Juvenile Crime Prevention 231,613 168,564 (63,049) 58% 42% a) 397,050 471,171 74,121
State Prevention Funds 80,208 43,750 (36,458) 58% 32% f)g) 137,500 187,499 49,999
HealthyStart /R -S -G 213,510 357,117 143,607 58% 98% b) 366,017 357,117 (8,900)
OCCF Grant 431,255 729,986 298,731 58% 99% j) 739,295 876,986 137,691
Miscellaneous 4,667 6,493 1,826 58% 81% 8,0008,000 -
Court Fines & Fees 14,000 35,061 21,061 58% 146% c)g) 24,000 75,000 51,000
Interest on Investments 14,583 21,418 6,835 58% 86% d) 25,000 40,000 15,000
Grants -Private 5,833 (5,833) 58% o% e) 10,0005,000 (5,000)
Total Revenues 1,377,917 1,693,697 315,780 58% 72% 2,362,143 2,756,640 394,497
Trans from General Fund 204,922 204,922 - 58% 58% 351,295 351,295
Trans from GF -Other 4,020 3,446 (574) 58% 50% 6,891 6,891
Total Transfers In 208,942 208,368 (574) 58% 58% 358,186 358,186
TOTAL RESOURCES 2,157,894 2,434,252 276,358 58% 74% 3,291,364 3,647,013 355,649
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Capital Outlay
Contingency
Exp. %
331,416 287,523 43,893 58% 51% 1) 568,142 519,399 48,743
1,331,990 1,161,203 170,787 58% 51% g)h) 2,283,412 2,661,177 (377,765)
58 58 58% 0% 100 - 100
256,498 - 256,498 58% n/a 439,710 439,710
TOTAL REQUIREMENTS 1,919,962 1,448,726 471,236 58%
44%
3,291,364 3,180,576 110,788
NET (Resources - Requirements) 237,932 985,526 747,594 466,437 466,437
a) FY 2008 revenues received and reported in FY 2009.
b) Medicaid revenue projected to be Tess than budget.
c) Circuit Court fees increased to Mary's Place.
d) Interest revenue will exceed budget because monthly cash balance is higher than expected.
e) Youth conference donations projected to be less.
f) Safe & Drug Free Schools grant amount is $100,000 - budgeted @ $50,000.
g) $100,999 of additional resources (Safe & Drug Free Schools and Circuit Court fees).
h) Increase in discretionary spending of $129,766.
i) Personnel reduced due to open position, and new hires.
j) OCCF grants and M&S increased by $147,000 Community Schools grant.
SOLID WASTE
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
FY %
Coll. %
RESOURCES:
Beg. Net Working Capital $ 1,221,164 $ 1,254,853 $ 33,689 100% 103% $ 1,221,164 $ 1,254,853 $ 33,689
Revenues
State Grant 26,833 (26,833) 58% 0% a) 46,000 46,000
Miscellaneous 20,417 17,426 (2,991) 58% 50% 35,000 30,000 (5,000)
Refunds/Reimbursements 15,938 15,938 58% N/A b) 15,938 15,938
Franchise 3% Fees 116,667 27,095 (89,572) 58% 14% c) 200,000 200,000
Commercial Disp. Fees 976,918 732,692 (244,226) 58% 44% d) 1,674,716 1,321,000 (353,716)
Private Disposal Fees 914,500 803,011 (111,489) 58% 51% 1,567,714 1,421,000 (146,714)
Franchise Disposal Fees 2,815,404 2,501,200 (314,204) 58% 52% 4,826,406 4,450,000 (376,406)
Yard Debris 40,979 38,724 (2,255) 58% 55% 70,249 75,000 4,751
Special Waste 17,500 10,543 (6,957) 58% 35% e) 30,000 30,000
Interest 58,333 30,613 (27,720) 58% 31% 100,000 57,000 (43,000)
Sale of Equip & Material 29,167 52,497 23,330 58% 105% f) 50,000 65,000 15,000
Total Revenues 5,016,718 4,229,739 (786,980) 58% 49% 8,600,085 7,710,938 (889,148)
TOTAL RESOURCES 6,237,882 5,484,591 (753,291) 58% 56% 9,821,249 8,965,790 (855,459)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,058,748 1,038,716 20,032 58% 57% 1,814,996 1,816,455 (1,459)
2,571,133 2,239,186 331,947 58% 51% g) 4,407,657 4,078,784 328,873
566,876 408,859 158,017 58% 42% 971,788 971,788
140,423 65,415 75,008 58% 27% h) 240,725 146,275 94,450
1,085,858 930,735 155,123 58% 50% i) 1,861,470 1,361,470 500,000
306,024 - 306,024 58% n/a 524,613 524,613
TOTAL REQUIREMENTS 5,729,062 4,682,911 1,046,151 58% 48% 9,821,249 8,374,772 1,446,477
NET (Resources - Requirements)
508,820 801,680 292,860 591,018 591,018
a) Habitat for Humanity Project reimbursement funds - will request at project completion in June, 2009.
b) Monies refunded from Cedar Creek landscaping contract.
c) Franchise fees are due April 15, 2009.
d) Downtum in construction has caused Tess revenue in this area.
e) Unpredictable revenue from asbestos and contaminated soil clean-ups.
f) Unexpected higher revenues on sale of recyclables; somewhat seasonal - will probably see drop in revenue over the winter.
g) Some single, Targe budget items cause this number to fluctuate.
h) Most capital items not yet purchased.
i) Will not be transferring the balance.
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 1,221,164 $ 1,254,853 $ 33,689 100% 103% $ 1,221,164 $ 1,254,853 $ 33,689
Revenues
State Grant 26,833 (26,833) 58% 0% a) 46,000 46,000
Miscellaneous 20,417 17,426 (2,991) 58% 50% 35,000 30,000 (5,000)
Refunds/Reimbursements 15,938 15,938 58% N/A b) 15,938 15,938
Franchise 3% Fees 116,667 27,095 (89,572) 58% 14% c) 200,000 200,000
Commercial Disp. Fees 976,918 732,692 (244,226) 58% 44% d) 1,674,716 1,321,000 (353,716)
Private Disposal Fees 914,500 803,011 (111,489) 58% 51% 1,567,714 1,421,000 (146,714)
Franchise Disposal Fees 2,815,404 2,501,200 (314,204) 58% 52% 4,826,406 4,450,000 (376,406)
Yard Debris 40,979 38,724 (2,255) 58% 55% 70,249 75,000 4,751
Special Waste 17,500 10,543 (6,957) 58% 35% e) 30,000 30,000
Interest 58,333 30,613 (27,720) 58% 31% 100,000 57,000 (43,000)
Sale of Equip & Material 29,167 52,497 23,330 58% 105% f) 50,000 65,000 15,000
Total Revenues 5,016,718 4,229,739 (786,980) 58% 49% 8,600,085 7,710,938 (889,148)
TOTAL RESOURCES 6,237,882 5,484,591 (753,291) 58% 56% 9,821,249 8,965,790 (855,459)
REQUIREMENTS
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
Exp. %
1,058,748 1,038,716 20,032 58% 57% 1,814,996 1,816,455 (1,459)
2,571,133 2,239,186 331,947 58% 51% g) 4,407,657 4,078,784 328,873
566,876 408,859 158,017 58% 42% 971,788 971,788
140,423 65,415 75,008 58% 27% h) 240,725 146,275 94,450
1,085,858 930,735 155,123 58% 50% i) 1,861,470 1,361,470 500,000
306,024 - 306,024 58% n/a 524,613 524,613
TOTAL REQUIREMENTS 5,729,062 4,682,911 1,046,151 58% 48% 9,821,249 8,374,772 1,446,477
NET (Resources - Requirements)
508,820 801,680 292,860 591,018 591,018
a) Habitat for Humanity Project reimbursement funds - will request at project completion in June, 2009.
b) Monies refunded from Cedar Creek landscaping contract.
c) Franchise fees are due April 15, 2009.
d) Downtum in construction has caused Tess revenue in this area.
e) Unpredictable revenue from asbestos and contaminated soil clean-ups.
f) Unexpected higher revenues on sale of recyclables; somewhat seasonal - will probably see drop in revenue over the winter.
g) Some single, Targe budget items cause this number to fluctuate.
h) Most capital items not yet purchased.
i) Will not be transferring the balance.
RESOURCES:
Beginning Net Working Capital
Revenues
Inter -fund Charges:
Risk Management
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
$2,500,000
$2,549,708
$49,708 100% 102%
Budget
Year End
Projection
Variance
$2,500,000 $2,549,708 $49,708
General Liability 234,448 234,444 (4) 58% 58% 401,910 401,910
Property Damage 167,005 167,006 1 58% 58% 286,294 286,294 -
Vehicle 104,614 104,326 (288) 58% 58% 179,338 179,338
Workers' Compensation 563,097 588,259 25,162 58% 61% 965,309 965,309
Unemployment 88,506 93,632 5,126 58% 62% 151,725 151,725 -
Claims Reimb-Workers' Compensation 1,750 28,191 26,441 58% 940% 3,000 28,191 25,191
Claims Reimb-Gen Liab/Property 11,667 630 (11,037) 58% 3% 20,000 20,000 -
Process Fee-Events/Parades 175 210 35 58% n/a 300 300
Miscellaneous 2,917 (2,917) 58% 0% 5,000 5,000
Skid Car Training 14,583 10,360 (4,223) 58% 41% 25,000 25,000
Interest on Investments 29,167 46,964 17,797 58% 94% 50,000 50,000
TOTAL REVENUES 1,217,928 1,274,022 56,094 58% 61% 2,087,876 2,113,067 25,191
Transfers In -PERS Reserve 58 (58) 58% 0% 100 (100)
TOTAL RESOURCES 3,717,986 3,823,730 105,744 58% 83% 4,587,976 4,662,775 74,799
Appropriations/Expenditures
Direct Insurance Costs:
GENERAL LIABILITY
0/0
Ex
Settlement / Benefit 6,902
Defense 1,050
Professional Service 6,905
Insurance 143,544
Loss Prevention 184
Total General Liability 758,333 158,584 758,333 58% 12% a) 1,300,000 400,000 900,000
PROPERTY DAMAGE
Insurance 149,933
Repair / Replacement 41,176
Total Property Damage 195,417 191,109 195,417 58% 57% 335,000 335,000
VEHICLE
Professional Service 942
Repair / Replacement 23,444
Insurance 471
Loss Prevention 8,153
Total Vehicle 93,333 33,010 93,333 58% 21% b) 160,000 125,500 34,500
WORKERS' COMPENSATION
Settlement / Benefit 398,627
Professional Service 6,250
Insurance 24,845
Loss Prevention 5,455
Miscellaneous 22,588
Workers' Comp Losses 55,401
Total Workers' Compensation 417,083 513,165 417,083 58% 72% c) 715,000 815,000 (100,000)
UNEMPLOYMENT - Settlement / Benefits 37,917 96,554 (58,637) 58% 149% d) 65,000 150,000 (85,000)
Total Direct Insurance Costs 1,502,083 992,422 1,405,529 58% 39% 2,575,000 1,825,500 749,500
Insurance Administration:
Personal Services 210,675 170,544 40,131 58% 47% 361,157 361,157
Materials & Service 112,002 83,191 28,811 58% 43% 192,004 192,004 -
Capital Outlay 58 58 58% 0% 100 - 100
Total Insurance Administration 322,736 253,735 69,001 58% 46% 553,261 553,161 100
Contingency 851,500 - 851,500 58% n/a 1,459,715 1,459,715
TOTAL APPROPRIATIONS/EXPENDITURES 2,676,319 1,246,157 2,326,030 58% 27% 4,587,976 2,378,661 2,209,315
NET 1,041,667 2,577,573 2,431,774 2,284,114 2,284,114
a) Savings is based on lower than expected year-to-date expenditures; offset by last year actuals and insurance premium charge.
b) Savings is based on lower than expected year-to-date expenditures.
c) Year end projection is higher than budget due to settlement/closing of $140,000 claim and an upcoming settlement.
d) Year end projection is higher than budget due to CDD layoffs and possible increase in unemployment claims as a result.
Health Benefits Trust
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance1 FY %
Coll. %
RESOURCES
Beg. Net Working Capital
Revenues:
Internal Premium Charges
P)T Emp - Add! Prem
Employee Prem Contribution
COIL
Retiree / COBRA Co -Pay
Medical Services Reimb
Prescription Rebates
Interest
Total Revenues
TOTAL RESOURCES
REQUIREMENTS
Expenditures:
Personal Services
Materials & Services
Conferences and Seminars
Claims Paid-Medical/Rx
Claims Paid-DentalNision
Refunds
Insurance Expense
State Assessments
Administration Fee
PPO Fee
Health Impact
Printing
Program Supplies
Other
Total Materials & Services
Capital Outlay
Contingency
Revised
Budget
Year End
Projection
Variance ,
$14,000,000 $14,862,418 $ 862,418 100% 106% $14,000,000 14,862,418 $ 862,418
7,278,425
76,417
209,922
466,667
233,333
218,750
7,431,409 152,984
29,665 (46,752)
201,075 (8,847)
676,586 209,919
357,714 124,381
11,986 11,986
10,393 10,393
272,353 53,603
8,483,514
58% 60% a) 12,477,300 12,739,748 262,448
58% 23% b) 131,000 51,000 (80,000)
58% 56% 359,866 339,866 (20,000)
58% 85% 800,000 1,120,000 320,000
58% 89% 400,000 600,000 200,000
58% n/a 11,986 11,986
58% n/a 10,393 10,393
58% 73% 375,000 450,000 75,000
8,991,181 507,667 58% 62% 14,543,166 15,322,992 779,826
22,483,514 23,853,599
66,334 63,161
1,370,085 92% 84%
Exp. %
28,543,166 30,185,410 1,642,244
3,173 58% 56% 113,715 113,715
1,750 1,410 340
6,879,046 5,585,923 1,293,123
938,652 912,508 26,144
(25,199) 25,199
208,548 213,691 (5,143)
37,333 134,149 (96,815)
158,726 159,450 (724)
27,462 20,319 7,143
24,967 28,875 (3,908)
4,667 8,977 (4,310)
1,167 180 987
8,845 18,734 (9,889)
8,291,162
8,292,626
TOTAL REQUIREMENTS 16,650,122
7,059,017 1,232,145
8,292,626
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
58%
7,122,178 9,527,944 58%
NET (Resources - Requirements) 5,833,392 16,731,421 10,898,030
47%
47% c)
57% c)
n/a
60%
210% d)
59%
43%
67%
112%
9%
124%
50%
0%
0%
3,000 3,000
11,792,650 9,369,935
1,609,117 1,530,658
(25,199)
357,511 357,511
64,000 134,149
272,102 272,102
47,077 47,077
42,800 42,800
8,000 8,000
2,000 2,000
15,163 15,163
2,422,715
78,459
25,199
(70,149)
14,213,420
100
14,215,931
11,757,196
2,456,224
100
14,215,931
25% 28,543,166 11,870,911 16,672,255
18,314,499 18,314,499
a) Projection is the amount budgeted for FY 2009, as amended, for HBT payments in the operating funds.
b) Fewer part-time employees opting for plan available to full-time employees.
c) Based on annualizing 31 weeks of claims paid; YTD average is $209,616.81 per week.
d) State Assessment is paid in August and January.
RESOURCES:
Beg. Net Working Capital
Revenues
Property Taxes - Current
Property Taxes - Prior
State Reimbursement
Telephone User Tax
Data Network Reimb.
Jefferson County
User Fee
Contract Payments
Miscellaneous
Interest
Interest on Unsegregated Tax
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
NET (Resources - Requirements)
DESCHUTES COUNTY 911
Statement of Financial Operating Data
Seven Months Ended
January 31, 2009
Year to Date
Budget
Actual
Variance
% of FY
% Coll.
$2,393,117 $2,636,885 $ 243,768 100% 110%
3,486,611
33,046
12,833
469,635
19,833
12,825
19,542
40,833
4,813
29,167
758
5,253,724
85,865
14,445
433,462
25,128
31,829
19,429
58,983
8,901
64,768
2,218
1,767,113
52,819
1,612
(36,173)
5,295
19,004
(113)
18,150
4,088
35,601
1,460
4,129,896 5,998,752 1,868,856
6,523,013 8,635,638 2,112,625
2,174,681
516,967
140,000
77,000
75,833
2,541,400
Revised
Budget
Year End
Projection
Variance
$ 2,393,117 $ 2,636,885 $ 243,768
58% 88% a) 5,977,048
58% 152% b) 56,650
58% 66% 22,000
58% 54% 805,089
58% 74% 34,000
145% c) 21,985
58% 58% 33,500
58% 84% 70,000
58% 108% d) 8,250
130% e) 50,000
58% 171% 1,300
58%
58%
5,876,474 (100,574)
96,500 39,850
22,000
805,089
33,164 (836)
31,829 9,844
33,500
70,000
8,901 651
100,000 50,000
2,218 918
58% 85% 7,079,822 7,079,675 (147)
58% 91% 9,472,939 9,716,560 243,621
1,979,811 194,870 58%
429,943 87,024 58%
140,000 58%
- 77,000 58%
- 75,833 58%
- 2,541,400 58%
Vo Exp.
53%
49%
0% f)
0% g)
0%
n/a
3,728,025 3,728,025
886,229 886,229
240,000 107,022 132,978
132,000 132,000
130,000 130,000
4,356,685 - 4,356,685
5,525,881 2,409,754 3,116,127 58% 25% 9,472,939 4,983,276 4,489,663
997,132 6,225,884 5,228,752 - 4,733,284 4,733,284
a) Historically, 85% of property tax receipts are collected through November.
b) Delinquent FY 2008 taxes exceeded amounts estimated.
c) Camp Sherman tax revenue. Revise year end projection to reflect previous 7 month history.
d) Miscellaneous charges for CAD printouts/tapes revenue is higher than anticipated.
e) Based on the first 7 months of actual, the interest for FY 2009 will be projected at $100,000.
f) Payment required for FY 2009 on Deschutes County FF&C 2008A borrowing (construction of new building).
o.
U O)
O
CO 7
.cam
O CD
N j
8
co
i
0
(0
i
7
a
u_
0) f0
co a
70
0
a
E
0
0
a
E
0
z
a
0
0
0
0
01
7
CO o,Nollnlo 0 0
rn'nalc0ov on
cD',- 0'' CO CV M 0 N1
I vv
10 oI O 1'10 0', O O 01010100
10 O 0 0:. 0 0, O 010 O O"O
o O 010,0'.0 O 01010 0'a
O u) M �''u�j'V. oD (D1�1V N'
N
N O (O C)
10'aD ',0 �,O o •cpp'p)
O 0.N0'U 0 O O1 0 V
ON'
1 N O pp)ION'O 0 N0 '10
• M pea
▪ N V i co LC) LO n' zy
e1
r
II 1 __- • j ! -�_
:OI SI 010 O:O,!
Oo'c)
'al OI 0'10 l0 ' l
''0: aic)
10p1'10 ' O.0 i',0I0',Oc)
1{0i �'0. IID - ''V'n
(h N
O. O O O 10 'c)
O: O O''O �O c)
O ' u) ' 1010: "an I ' '1c).
0, O o OO ;O 0 O''
I O. Io0DOIO O ' (OD ' O 1IO
'M' N'p)IVV O '10 0-
'V IN, M1, V 1c)
''010 O,O'O,0'0110 la is
000111 O 0
0 0',0 0,0110 �O
O
OIO O: ' 0: 10.10 .0
_1
1 CO 10 CO VIN V V' 1 ' 11
I
10: 0110 01 '10
O ' O O '101'!0
NI O N !N' 1c) U)
10 1
1 '
N O(OM c)
• x0 0 N 10
O N O M ' O
N V IL)
(0
c)
CD
O
001
N O CO
O i 00 cD I
ai
(00 I
NI
• c)
V N
n
IV
M e)
CO
CO
IV
O
v n NON N
I— CO
0 0 0'0:10
M.O 0.10 V
(()00 V'0
ID0:0 et :et
0'1. O 00,o
a0
1-. 10 3
u)'..O
N (p
CO 10'
c) I o'
u0 Io
0 � V 'V CO V
CO N'i N 0)
a): 0-) p)
0 00,0 V 0 M:010 la 0 0.
'O 0'010 (01 0(00(0001'),
OIO:.0'10 O c) c•-) OD. CI 0 I
10 (n 0100 (D O'IO'01N � n p)
'co 0j., c) N M'a0 0,..- co p)I
1 N. CO `-'1`-'n
0'0 !O VI :CD 'CO OCD la OY10 0.
n CD: N OI O'(D 0 ,0'010 1'7
VO '' (D.1- OMIOO'0 10 NI
N CO� OD O,,-' (D e)
1N N , --..." ---,41',
et et O0i
CD CV
O(NO
O (V0
�cc00!
O I(VOI
•
OLO
co et
N
M
1-
CD CD
O
a 1V
CO
(0
coa,—
N r
OO.OI 0,1__ _1'f
01x0 0 0' (D I0)
.(1 0.. "q.
CO 10
I0 o
M '
T'0
M
N I
N
(D n 0
(DI N
N
' (0
N
0
N
N
v
O'01'O' 1 "I, 1 10
N n 'O pf 10
() N
p)1
0-
a p)'.
o
01
CV
It-OSetj-I '.NI MI 0 CO
M1
CO
N
Ia OI ' '' Ofaa
t
V ' I(01 111'1 I IO N.Q
r co: lit)11
,. p)
11(0 M :col Iq.
u) (0 N, O 1 M
'(0 (D N,
ac) _.�''' ID :.M ' ' V" CV
O 0 1 (O '.N 0 CO ! M OI CO
CO ',V co M O ac)' :O N1 N CO CO CV (pp
0 ' 0 N � 1 , (0 0(n1)I 011 v
1
(0j 0 1 O. V O '0 'I'i..:i O VI
(D' 1111 'IVO VO!' V V ' 0 "M1,',
N 1 V 1I (9 n0 V .- (O
CO
(V
10
100let
v
CD (0
0
el
ID
0.
(Ov
0)
Y) U),
02'. (gipp
N N'
n
col
1
co
co
tr-
• Ito
10'1 to
10 O
'0'011'p1p)
N((0111'0) e)
OIa00 --IID 0.
I�,n 0 1N N
0 N (0 SrN! 0.0 CO
VI ID'V,a ' (NO'
p) • �' x(00 a I0 0 1 II (Lj
10
:07, N.
Deschutes County - Fair and Expo Center
YTD -Budget Basis
Statement of Financial Operating Data
Seven Months Ended January 31, 2009
Year to Date
Budget
Actual
Variance
FY%
Coll. %
Year End
Budget
Projection
Variance
RESOURCES:
Beg. Net Working Capital $ 150,000 $ 142,470 $ (7,530) 100% 95% $ 150,000 $ 142,470 ',i (7,530)
Receipts:
Security & Traffic Reimb 15,000 4,096 (10,904) 58% 12% 35,000 24,096 (10,904)
Miscellaneous - 3,146 3,146 58% 79% 4,000 7,146 3,146
Vending Machines 3,000 298 (2,702) 58% 5% 6,000 3,298 (2,702)
Telephone Fees - Events 2,000 280 (1,720) 58% 6% 5,000 3,280 (1,720)
Special Events Revenues 337,000 220,092 (116,908) 58% 36% 610,000 493,092 (116,909)
Interest 4,662 2,182 (2,480) 58% 27% 8,000 5,520 (2,480)
Parking Fees - - - 58% 0% 4,000 4,000
Storage 34,000 15,323 (18,677) 58% 23% 67,000 48,323 (18,677)
Camping at F & E 2,000 - (2,000) 58% 0% 15,000 13,000 (2,000)
Horse Stall Rental 4,000 588 (3,412) 58% 1% 55,000 51,588 (3,412)
Concession % - Food 104,500 75,491 (29,009) 58% 27% 280,000 250,991 (29,009)
Rights (Signage, etc.) 35,000 47,000 12,000 58% 49% 95,000 107,000 12,000
Interfund Contract - - 58% 0% 45,000 45,000
Video Lottery 10,000 - (10,000) 58% 0% 10,000 - (10,000)
Total Receipts 551,162 368,496 (182,666) 58% 30% 1,239,000 1,056,333 (182,667)
Transfers In 468,026 365,177 (102,850) 58% 58% 633,203 530,353 (102,850)
TOTAL RESOURCES 1,169,188 876,142 (293,046) 58% 43% 2,022,203 1,729,156 (293,047)
REQUIREMENTS:
Expenditures:
Personal Services
Materials and Services
Debt Service
Capital Outlay
Transfers Out
Contingency
TOTAL REQUIREMENTS
Exp. %
493,500 468,002 25,498 58% 55% 846,075 820,577 25,498
452,354 324,459 127,895 58% 42% 775,739 669,078 106,661
73,990 73,990 (0) 58% 87% 85,064 117,104 (32,040)
58% 0% 45,000 45,000
67,000 67,000 - 58% 86% 78,000 78,000
112,189 112,189 58% n/a 192,325 - 192,325
1,199,033 933,451 265,582 58% 46% 2,022,203 1,684,759 337,444
NET (Resources - Requirements) (29,845) (57,309) (27,464) 44,397 44,397
Accrued Revenue (Accounts Receivable):
Current Month Events 14,000
Prior Months 5,417
Total Accounts Receivable 19,417
Deposits Received for Future Events:
FY 2009:
February 5,200
March 9,550
April 5,252
May 3,450
June 2,400
FY 2010 10,905
FY 2011 & Beyond 36,860
TOTAL 73,617
Deschutes County Fair and Expo Center
Statement of Financial Operating Data
January 2009
RESOURCES:
Beg. Net Working Capital
Receipts:
Security & Traffic Reimb
Budget
Actual
Variance
$
2,000
$
Miscellaneous - 60
Vending Machines -
Telephone Fees - Events 140
Special Events Revenues 34,000 36,737
Interest 666 85
Parking Fees
Storage 1,076 1,076
Camping at F & E -
Horse Stall Rental -
Concession % - Food 18,000 14,000 (4,000)
Rights (Signage, etc.) 18,000 21,000 3,000
Interfund Contract
Video Lottery
Total Receipts 72,666 73,098 432
$
(2,000)
60
140
2,737
(581)
Transfer In:
GF, TRT, Welcome Center
Total Transfers
TOTAL RESOURCES
72,666 73,098 432
REQUIREMENTS:
Expenditures:
Personal Services 70,500 67,152 3,348
Materials and Services 64,622 62,581 2,041
Debt Service
Capital Outlay -
Transfers Out -
Contingency -
TOTAL REQUIREMENTS
135,122 129,733 5,389
NET (Resources - Requirements) (62,456) (56,635) 5,821
Deschutes County
Fair and Expo Center
Accounts Receivable
January 31, 2009
Current Month
Food & Beverage Estimate
Total Current Month
Prior Months:
14,000.00
14,000.00
October, 2008
Hunter Jumpers 1,000.00
KRDM Dance 1,002.00
August, 2008
White Stallion Productions 2,500.00
April, 2006
NW Expo & Trade show 915.00
Total Prior Months 5,417.00
Total Accrued Revenue as of January 31, 2009 19,417.00
Deschutes County
Bethlehem Inn (Fund 128)
January 31, 2009
RESOURCES:
Beg. Net Working Capital
Revenues
Grants - Private
Total Revenues
TOTAL RESOURCES
REQUIREMENTS:
Expenditures
Debt Service (Negative Int Rev)
TOTAL REQUIREMENTS
Year to Date
Budget
Actual
Variance
FY %
Coll. %
$ (2,600,000) $ (2,619,549) $ (19,549) 100% 101% a) $ (2,600,000) $ (2,619,549) $ (19,549)
- 17% 0% 2,700,000 2,700,000
- 17% 0% 2,700,000 2,700,000
(2,600,000) (2,619,549) (19,549) 17% -2620%
Exp. %
100,000 80,451 (19,549)
46,920 (46,920) 17% 47% b) 100,000 100,000
46,920 (46,920) 17% 47% 100,000 100,000
NET (Resources - Requirements) (2,600,000) (2,666,469) (66,469) (19,549) (19,549)
a) The beginning working capital is $19,549 less than estimated for the FY 2009 budget.
b) January interest expense was $5,575; average monthly interest is $6,703.
Year End
Budget
Projection
Variance
$ (2,600,000) $ (2,619,549) $ (19,549) 100% 101% a) $ (2,600,000) $ (2,619,549) $ (19,549)
- 17% 0% 2,700,000 2,700,000
- 17% 0% 2,700,000 2,700,000
(2,600,000) (2,619,549) (19,549) 17% -2620%
Exp. %
100,000 80,451 (19,549)
46,920 (46,920) 17% 47% b) 100,000 100,000
46,920 (46,920) 17% 47% 100,000 100,000
NET (Resources - Requirements) (2,600,000) (2,666,469) (66,469) (19,549) (19,549)
a) The beginning working capital is $19,549 less than estimated for the FY 2009 budget.
b) January interest expense was $5,575; average monthly interest is $6,703.
Deschutes County
General Support Services - BOCC
Conference/Seminar, Education/Training and Related Travel Expenditures
FY 2009
Jul
Aug
Sep
Oct
Nov
Dec
Jan
YTD Total
Tammy Baney
Conf/Sem & Educ/Training - 2,300 314 - - 40 2,654
Travel Meals - - 4 40
Accommodations - 238 � 363
600
Airfare - - - - - -
Mileage reimbursement - 74 1 - 278 117 453_ 104 1_,026
Ground Transport - - 91 - - 24 T - 115
Total Baney ,74 1 2,391 1 830 1 117 880 144 1 4,436
Mike Daly
Conf/Sem & Educ/Training 26 360 - - ! 386
Travel Meals - 396 - 12 29 437
Accommodations - - - 540 141 - 680
Airfare -
Mileage reimbursement - 82 . 242 420 331 1 18 1,092
Ground Transport 44 15 59
Total Daly 522 26 1,154 561 374 18 1 2,654
Dennis Luke
Travel Meals _ � - 25
g _ - 260 505
66 'r --
Conf/Sem & EduclTrainm ' 26 21925 116
Accommodations - - 429 98 15 98 640
Airfare
Mileage reimbursement 85 137 246_ 239 ' 228 248 1,183
Ground Transport - - -
Total Luke 85 163 895 362
308 631 2,444
Alan Unger
Conf/Sem & Educ/Training -
Travel Meals
Accommodations
Airfare -
Mileage reimbursement _ Ground Transport
Total Unger -
BOCC Staff 1
Conf/Sem & Educ/Training
Travel Meals -
Accommodations -
Airfare -
Mileage reimbursement - - - - 16 16
Ground Transport
Total BOCC Staff - 16 16
Total - BOCC Department
Conf/Sem & Educ/Training - - 2,352 893 - - 300 ` 3,545
Travel Meals - 396 - 12 1 25 134 25 593
Accommodations - - 1,207 238 378 T 98 1,921
Airfare - - - - - - - -
Mileage Reimbursement 241 137 766 ! 776 1,011 386 3,317
Ground Transport - 1 44 91 - - 39 - 174
Total - BOCC Department ' - 681 j 2,580 2,879 1,039 1,563 809 F 9,550
FY 2009 Budget 21 250
Percent Expended 44.9%
2/17/2 )09