Loading...
HomeMy WebLinkAbout2010-03-01 Work Session MinutesDeschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, MARCH 1, 2010 Present were Commissioners Dennis R. Luke, Alan Unger and Tammy Baney; Dave Kanner, County Administrator; Erik Kropp, Deputy County Administrator; Marty Wynne, Finance; and David Givans, Internal Auditor. No representatives of the media or other citizens were present. Chair Luke opened the meeting at 1:30 p.m. 1. Finance Update. In regard to rates, Marty Wynne said they are still at 0.55, and are still dropping. A year ago it was 1.3%. Expectations are falling. Solid Waste revenues are down and the forecast is not for any great improvement; however, the projection from the Director is that they will be at about budget. Dave Kanner clarified that there will still be a shortage, but the beginning net working capital will be drawn down and operational expenses will be cut. This may mean shutting down the landfill one day a week, on a day that negatively affects the fewest people. Commissioner Baney asked if the cell closure could be tracked separately from other projects. Mr. Wynne said that change orders are to be expected with most big projects. Commissioner Baney would like to be sure the current bidding process is working. The group briefly discussed the project. 2. Audit Committee Search and Selection of Members. David Givans gave a brief overview of the potential process. There are ten candidates and from one to three seats that can be filled. Two current members have indicated they will be leaving. Minutes of Board of Commissioners' Work Session Monday, March 1, 201( Page 1 of 3 Pages He said that the candidates all appear to be quality people. Commissioner Unger asked if there is a balance that is best for this group. Mr. Givans stated that the Board seems to favor the interview approach, to get to know the candidates, and go from there. Commissioner Baney suggested that the Committee do the screening or initial interviews and make recommendations on which individuals they prefer. They may or may not be interviewed by the Commissioners; Commissioner Unger may sit in on the interviews to learn more. 3. Update of Commissioners' Meetings and Schedules. Commissioner Unger is meeting with the Bureau of Reclamation Regional Director next week to discuss water issues. In regard to an upcoming regional meeting with the State scheduled for Thursday, March 4, the Board would like the following issues discussed: the transportation planning rule; an update on south County groundwater issues; and the Department of State Lands' 200 acres in Redmond. Potential discussion items also include a partnership in building roads that are in failure or allowing for a variance because of the State's inability to partner; helping Bethlehem Inn, as a regional facility, to get on solid financial footing; assisting with the development of La Pine Industrial Park and First Street improvements; Tumalo traffic safety improvements; the Comprehensive Plan update; and rail improvements (O'Neill Junction). Commissioner Luke said that Scott Cooper of Crook County needs assistance with some expenses for Mr. Cooper to meet with representatives of the State out of the area regarding the Partnership for Poverty. The Board is supportive. 4. Other Items. The Board went into Executive Session, under ORS 192.660(2)(h), Litigation. After the Session, relating to the John Johnson Measure 49 remand, the following action was taken. BANEY: Direct staff to draft a documents relating to an appeal. UNGER: Second. Minutes of Board of Commissioners' Work Session Monday, March 1, 2011! Page 2 of 3 Pages VOTE: BANEY: Yes. LINGER: Yes. LUKE: Chair votes yes. The Board considered sending a letter to the Planning Commissioners to request a specific timeframe be following in regard to the Comprehensive Plan update. BANEY: Move signature. UNGER: Second. VOTE: BANEY: Yes. UNGER: Yes. LUKE: Chair votes yes. Being no further items addressed, the meeting adjourned at 3:15 p.m. DATED this 1st Day of March 2010 for the Deschutes County Board of Commissioners. ATTEST: Dennis R. Luke, Chair Cue„,„ Alan Unger, Vice Chair 7 Tammy Baney, Com ' sioner Recording Secretary Minutes of Board of Commissioners' Work Session Monday, March 1, 2010 Page 3 of 3 Pages TES 0 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 COMMI SIONERS 1:30 P.M., MONDAY, MARCH 1, 2010 1. Finance Update — Marty Wynne 2. Audit Committee Search and Selection of Members — David Givans 3. Update of Commissioners' Meetings and Schedules 4. Other Items • Executive Session under ORS 192.660(2)(h), Litigation PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), pending or threatened litigation; or ORS 192.660(2) (b), personnel issues Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. Ifyou have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 1, 2010 (1) Monthly Investment Report (2) January 2010 Financials • eschutes ount 96' 47 • t.i Investment 'a Investment Income Fiscal Year 2009-10 0 H } c) C asn $ 132,376 $ 1,058,924 Total Investment Income 132,376 1,058,924 Less Fee: 5% of Invest. Income (6,619) (52,946) Investment Income - Net $ 125,757 $ 1,005,978 Investments By County Function General $ 141,126,852 Total Investments $ 141,126,852 t c 0 2 15 2 im3 U —,l L A cn C w w% Fw0) mE4 0 � Co CO N O O O Average Maturity in Days tt n 00000 0 0 0 0 0 0 0 0 0 0 1- N N N r r r y cn E o 3 c E a w X"U 0) (0 ' C C 2 7 a) 0 N Q N (6 0) O a) _Y 6 -o c U(0 - u_ m Time Certificates a) 0_ v) CL O c6 Z (1) E O E 2- U U j 10 0 0 01 o o' 1 0, 0 I ->j 2' I >J Io O o >. \ \ 0 N U U U U U U U U U' U U U U I U L.(2) U U I U C2),!,' OI NII N' (J C 0 U N 0 pl1 U U -2-1"F. L S --2,•.:_.,,T., t7 U cp' U N O Q N O a O O N 3,3 zz z 31Z Z z Z, 311 ZIZ 3 Z 3lz Z Z Z o`',� o Oi,Z 3!�',ZC Z Z m o o 3 �'�Z m o eo 'o'�'o i� _ joo:o o; uol u: o. of i'QI al E. E' '. 'o o 'd�, '10 °�'O O,^�,o IM - 1 it L 1 1 L t- J Ft. m • r N 0 Q 10 0 CO N 0 0 CO N 0 n, � 0 O O 010, 0 0• 1 � O 0 (0 (0 O, N 0 • V N 0 O'� 01 0 CO CO 1 N 0 N 0 0 0� 0 Nor ) 0 r • O C A NINIO O ^ 0 0 M; O I n l O N' r 0 *6.6 O o IO O1 O O r 0 0 0 10' N :, O II n O Q r O O I O O' O M 0 r N, �. N 001 c0•M r N� N 0 I' - 6 N CO jIE.�. 6,n FllO .-,1010 .-'Q N Q•Ia. OOri pp co l.I ei C')1 O'O,'c Oi. �IQ NIC -)j MI Q:N WIi,1 CIV N OIIOICc.O� aDi<O 6, aD, C -)':<O 6, OIO0 I0 0. N'<O )': 00 N, M N MIO N 0 O' 0 N,, 0'.01 O 0 0� 0 r �'' 0 0 0 -I 0 0' 0 0.- 0 O, 0 0 0' O 03 O O 01 010 0CO, . 0' 0 01 o AS 0 n: 0 CO 0, 04 N M 10 r 0 .- J 10 >,y N Q.I NI QI,N ..-010.-0 Q',� r N -N N r r N N 1 N! NI NI NI CO I N N NIN N N!,r NSI N 01 N N N' N: N N N, cV N N:.. N N' N'. 00 (0 Q NN �,,, �� 1 I+ rI 1 F —1 HL • • 0'0 000InI N 0 coQ0 -.0'OIo 0ri0l000 O'0N•00I�Tol Q:NOo', o•f o�OOofo o. 0001 oT Nr !Vl I! ' T 11 r L O j o .4-1 01 0' N N o Q! O I co'. O O' .0 a0 O O O O O O I 0' 0, O M 0. 0j n 01, N O 0 0 0,0 0 0 0 0 0, 010, 0 n :co 6 0 • ! O NCO Q CO c0 N 10 c0: Q' O O O O 21 c0 o U) N'1 O 0 0. 0 0 0 0 a0 212. O M O:. Q 6."1.9 61°18 21 0 '4918 81'1.1 Q O: 21`"°c' 0 O. ', r 0)'. o,, c-- co NI00)1N1 co) CQO c0'M I c0.7. 0101 .321 N 0 0 N: .- a(0 po 0 cO: .3.: .31 N C1 -).O IN O a0 .3. O 0IO 110 0 (0 �I(0 1 O060,..):11..7:):0 I O. O O N N' Q il 6 N 10) oi 0I O r. Q 100 N. 0 m 10 01• 01 0 0 0' 11 0 0 CO• 0 0, 0; 0, 0 O co1 011 0: 0 0 03 0 0 CO 01 01 0) O' , M 10 c+O) 0I 0 0 0 1 O, O ' 0, 0 OI O, 0 0 r O` 0 0. 0 coco. NI Q1N Q N Q r NIN N 1 N N :1N NIN NIN nit N N1N N N N N NIN N NI NIN N N1N N r N' M 0 fd 0): I -• 1 I f } I f �1 1011 CD10 0)00.0• oc.:O• o!�QQ�+ o c001O� 100000'' of o o 0 o 00 o 00 o 010'001 o 01 co,I co, o O 0)'O o o 01, NN:ir 1 0 0 0 1 p0 ppapo 0 O • O O CD 0 I 0 0 N 0I CO 0, 0 0 0 0 0: 0 0 101 0 pQO O O, o !col (DI Icoo O, O O I 0 0 01 0ca 1! O O ca I O)' 0 01 0, 01 (0) :rico O cr, N� 01 0 01 0 p 0 co. 0 0:. 0 01 0I co 100' OO) 0 O CON0 0 01 01 0 01 0. 01 0 Q •• O 0 0` 0I 0 0 0 CCOO 0 0 0 c00I N COO- a00-• 01 1`...1. 01, 01 , COo0 0 v) Q '. O N 0 0 0 N! 00) O, N 0': 0 CO (Cr n1 0 0• 0 0 p01 0I 0 0 0 p0 O, Q: 05 0 0 0 0 0 0 011 00 0I OI 100, 0 0, Q! O 61 O O 011 010) 10 00 16,- 0: 0 0, O 1 0.10 •-' 0 01 0 0, —10 0—!0.10.,.. 1 0 r O 0 0I 0)' 0,— 00 =!0..0.!= 0 0 0 0' —_.10.. 0 0:0i: M M LO {V Hui! N. (0 10 Q•N ''. N NiN1.- 1 NIN N;N NIN N NIN N:�r1 NIN N:N SIN NtN nil NN. N,N N NI 0-0 0 0) :O1 1 I O m re°' L �� �HI}�� .� I.I��. ,o1���I�.�1��.� �'' �� ▪ ����I . e o �Iz uld aIr`. M OIOOOIOOOOO 0:000100 c000:0,0001000 a01c0'IO O 000000000 1000:000, OISpO N: `d Q 1 OI c00 OI O 00 Q C0 NQ' 011N O O o r o M N OI OI O o QI10Q N 100 00' O M O O 0. N� 00N1r,Q O MNO r IN I0N - ^x> 0. 10101Q 0' O o: 0!o O QINO (ol 0r N• r N1 n'. O 01 O r. 6'0.°)...1°:!,‘0 6 0Mr Q• — 0 o1O OO N1NOO' 60oQ 1 Q10. r ♦ .Em0d N!pWC �NN'r r Ni N. M.r r1 r,0) Mr rN�-INNNI�Oo r00 r�rrl0. 0r r1� 00 r0,1'O r la,E'U d r'adH d Ya ES' o o, Ely) a°)mC7o 1 • rl aI vvF12 mgr I- -,,......,-.- 1,..9., r r. �1 eI a! el el 1 , .:, � .: o -7 m to 'In �'ca o o 01 o 010 0 0 0 0 0 olO 0 O'o 10 o1Ololo in•o O Inlo o O O __ I coy IN co NMI CO 11.1 r 1001011 CO CO' CON. cco:0010,1 I a00A' 00 0 mn co:NC1 in 00), 000 Q1 1'. :4 CO r�M Q Qli, r N 011 0.1 IO 0 0 iO 0 0 r r O O_r :r t0 r r 1O 0 r r r .N.. C m j1I �, �' 1 I I ^' l c 0 m Ea,'c 1 I_ • L r f _L 1 c E IY ' 01 7 r co!Q r' N I CO f0': 01 0, n 110 co t0 Q O) o co 0 0' 01 co O' co! 0 n r r. N co, c0 i O', r r 011 0 c0 0 r: r'! co,co! U) O o O . Q 4 > 2 p + of �Q+r r o r� 'r� rl a'iu� va0i� u� vQi �.rl�� •-.7,!1.7 1.71.1=11.7!!.7,1r, 0• 0 �.r N+-_, vl c° --._. _ -1 cp Q M c0 0 Q Q M' Q 10 co, Q O N1 0 c0 r Q 101 MQ Q Q Q c0 co o co co r co 0)1 n C co coMIN oQ N n,000 LO; 1,...] N E >, r d 0 010. 0 ,::;,,o, 0 0 011 01 0 0 0 0' 0 1 00 0 2 LO▪ Ir N NI c0 r '0):O IQ O Q1 I.- A co 011.- NIN IA CO'N c01<O N 7.1 1011OI O) co NI N CO rI N1M o 0 M N N R c- o O O r N• N O 0 O O 0 OI 0 O 0 0! 0 0 0 0, \ 4- — p � O rIQ1O1�V QVIN Q OO 0 0 MIO \ o _O r 10 N O_,r _N M o r Q Q' e.1Q!Q:Q!Q c! r $ as ,- m ch CO Q 0 n: r r CO 0, 0 O) O O, O M M 0 M Q 43.11.11. IA N CO CO CO CO r, r r r CO 01: OI O O ' > 19 E� :00000000'ol, r 00000'000000 oQF,Jm I m10 0 010)101 0 0'01 0 0) 0'0)10 CDI0 OI 0 6fI0 0 Tlm 0 0110 0,'00 o 0 0 0 o 010 00 o 0IO) 0 O o m O m y 00000,010o00oQ,o1oQo0000�01010100CDelo.o000,o0 10'o rIo 1 I .c • N r N 01 c0', 00 r r 101 0 Q ' 10: 0)I r 0 05 O', 05NI v O N. a01 O N O 6` m1 0 O - 1I) N 10 10, 0 h 0) N' N N 1 :, E O Q: Q,. -:2,..-1.-•Q O Q r 1 r r - N 0' 0 5 0 I O O Q Q O 1 z. Q Q. E` -,11Q M ! "--.1-..'. O•Q Q, Q r !' JI Q: MI . c0 N' CO 0, V CO: M A- ! CO r n NJ N CJ, CO O, O 0 r CO NCA N r �I N N I [ LL aipl 1 1 ZDUD UUUOIaUQQ�Ci'lQL104 U�I QLL�LL LL+UaLL UILL LLIH�LL1,1�HILLLLLL LLLL(Z.)1LLQZQ'LLI LLI LLI mm UiY �y m2>t 1, 6Z L F O. 00000,00 Ooo oo 0: 01,- 0: ,1 0 000 -il Q (.71 F F 1 F F I F F F I--: LL F, LL LL LL < ' < L I 1 0 LL ' „a 0 2 a II D- co. l a an w i a- Q� z m m•m ml z z a 0.03'03.03:7I�m �ImTxlx 3 h; 03 0- =1II� 3 uzi' zlz�� co >141- co x a m-- ml a1� Y o N LLva a U m QIm LL LL U. • _—� L IZIZ m m d N ! M m M:. (V c0 M M O 0 OI N M 10. ry Ql 10 10 r r LL 1 f0 Z r;1 c0I m 3 1 0'.`� J J O I N N 7 m Q J J 7 0) a '0 Ila x v NY m C7 Cj>',> n 2 3 o M w 3 z i, Z l� ;X X X,,� N Q X xI Q�• Q M (71 (7 N, X1 (7 x X X X x 0.x0) o (7 31� 6 N. � CO • M COCO ", 05 M M 1 ,1 M C00' M 0 M M O) I� 1 co 1 Ni 1 O M: M CMO <O•C00 CMO O M M I CMO m I Z 0),. 10 r N 0 r I co I r. O I r r '-' O CO. IMI ti MI M' MI 0)1 cr) co co!M c0 0 c:-) co M M. M cO i th M' c0 co:, --co 1 MI co 0 co;M'., M (0 00 r T t fi 4- - • 0' C :CI O I O I I 1 I I O s o O 400! I UI O O' IU 2 1 Al L m c • 'O' d s ' O�O rn� t71 U ! 1 U1 IU sl , U 1 u • d1� dlm - go-) ° : c v U.U,p v' U �' Q �, �I ZI , U 'm m fn:m < 1 d a1 o c m d 0 v1N m Z 1 s Im:..p• d, {r: d1 c m !d >m.Z d10 921..);„,..J.,-? s,8 m', U. U mZ c m EE o �, i�H-2,4,1136 Qu o1w N l m1 IU, gy m' U t9 N. t' • mldx dtk ,,c1 1mVu dQt.1 O UI` Ipg u 'i e!' 1 on Z U n,a cm m'mZ N 750-11<1.1 ...a. d N m 1 s s CO O 1> r =LL d m— ol>U 4.) cd`cUI_,aci, 1 'u: •c c'1 o u. cU 1 U oo dm �' ! :.c c 1�dEE my• c a): ld m md1 1 U d. Id > H m� Idvyd E• o�5,0d I °' m£ m E w '0 00! La wl '', 1 s o c m o,o dn.amlumi o �:Ig-t. of oil dl.E lLn E j2 a1$jQ�m`Imw! Li j m 0L01 --� �.._>� �I : 8miUi2IYL�.aIKmwal2`00I0t_:�-1,2 1 H • ia, E o `0 01 & o a, d1I mf 1 ,3H!) ° UI o - eh , ,> U m m i rul '. 2 1� �, i cic:c�,acla ''m Em�m1cVj�� nEl-112:2.2 P.UU cml0�0-,•, .-,00Ulm-I-II -,05121-, i.). C-) Um "' �"� IrIUIm mim 'ml2:m � 21LL C7 u. 0 712:t4i;u!LLILL > �l� O L1. L. n L.IN Y LL LL LL LL u_ �1aILL !-°• LL1u1u. u. all ! ! j rte' d Y O U • 0) p O d d A 57 - or a' c o 0 0 U • d 5 4'1 Memorandum Date: February 11, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find January 2010 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705) and Health Benefits Trust (675). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. 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 11,563,327 18,474,792 6,911,465 58% 93% a) 19,822,847 20,674,385 851,538 Gen. Rev. - excl. Taxes 1,704,186 2,131,013 426,827 58% 73% b) 2,921,462 2,921,462 Assessor 478,744 638,749 160,005 58% 78% c) 820,704 820,704 County Clerk 608,516 827,669 219,153 58% 79% d) 1,043,171 1,477,971 434,800 BOPTA 8,045 11,441 3,396 58% 83% c) 13,791 13,791 District Attorney 194,133 123,812 (70,321) 58% 37% 332,800 381,603 48,803 Finance/Tax 109,112 147,643 38,531 58% 79% c) 187,049 197,827 10,778 Veterans 40,945 33,936 (7,009) 58% 48% 70,192 70,192 Property Management 50,428 51,428 1,000 58% 59% 86,450 86,450 Grant Projects 1,169 1,169 58% 58% 2,000 2,000 Total Revenues 14,758,605 22,441,652 7,683,047 58% 89% 25,300,466 26,646,385 1,345,919 TOTAL RESOURCES 20,808,605 29,217,647 8,409,042 58% 93% 31,350,466 33,422,380 2,071,914 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Transfers Out Exp. % 1,919,535 1,784,120 135,415 58% 54% 3,290,631 3,290,631 852,077 736,748 115,329 58% 50% 1,460,704 1,450,704 10,000 34,830 29,007 5,823 58% 49% 59,708 63,614 (3,906) 2,675,903 2,671,825 4,078 58% 58% 4,587,263 4,563,140 24,123 435,441 453,886 (18,445) 58% 61% e) 746,471 703,061 43,410 131,659 130,069 1,590 58% 58% 225,701 225,701 139,816 138,246 1,570 58% 58% 239,685 239,685 61,643 59,865 1,778 58% 57% 105,673 105,673 940,920 414,328 526,592 58% 26% 1,613,006 1,493,006 120,000 3,555,249 3,555,249 58% 0% 6,094,713 6,094,713 10,747,073 6,418,094 4,328,979 58% 35% 18,423,555 12,135,215 6,288,340 7,540,698 7,424,311 116,387 58% 57% 12,926,911 12,926,911 TOTAL REQUIREMENTS 18,287,771 13,842,405 4,445,366 58% 44% 31,350,466 25,062,126 6,288,340 NET (Resources - Requirements) 2,520,834 15,375,243 12,854,409 - 8,360,254 8,360,254 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) Year to date includes expenditures paid annually. Year End $ Budget Projection Jariance 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 11,563,327 18,474,792 6,911,465 58% 93% a) 19,822,847 20,674,385 851,538 Gen. Rev. - excl. Taxes 1,704,186 2,131,013 426,827 58% 73% b) 2,921,462 2,921,462 Assessor 478,744 638,749 160,005 58% 78% c) 820,704 820,704 County Clerk 608,516 827,669 219,153 58% 79% d) 1,043,171 1,477,971 434,800 BOPTA 8,045 11,441 3,396 58% 83% c) 13,791 13,791 District Attorney 194,133 123,812 (70,321) 58% 37% 332,800 381,603 48,803 Finance/Tax 109,112 147,643 38,531 58% 79% c) 187,049 197,827 10,778 Veterans 40,945 33,936 (7,009) 58% 48% 70,192 70,192 Property Management 50,428 51,428 1,000 58% 59% 86,450 86,450 Grant Projects 1,169 1,169 58% 58% 2,000 2,000 Total Revenues 14,758,605 22,441,652 7,683,047 58% 89% 25,300,466 26,646,385 1,345,919 TOTAL RESOURCES 20,808,605 29,217,647 8,409,042 58% 93% 31,350,466 33,422,380 2,071,914 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Transfers Out Exp. % 1,919,535 1,784,120 135,415 58% 54% 3,290,631 3,290,631 852,077 736,748 115,329 58% 50% 1,460,704 1,450,704 10,000 34,830 29,007 5,823 58% 49% 59,708 63,614 (3,906) 2,675,903 2,671,825 4,078 58% 58% 4,587,263 4,563,140 24,123 435,441 453,886 (18,445) 58% 61% e) 746,471 703,061 43,410 131,659 130,069 1,590 58% 58% 225,701 225,701 139,816 138,246 1,570 58% 58% 239,685 239,685 61,643 59,865 1,778 58% 57% 105,673 105,673 940,920 414,328 526,592 58% 26% 1,613,006 1,493,006 120,000 3,555,249 3,555,249 58% 0% 6,094,713 6,094,713 10,747,073 6,418,094 4,328,979 58% 35% 18,423,555 12,135,215 6,288,340 7,540,698 7,424,311 116,387 58% 57% 12,926,911 12,926,911 TOTAL REQUIREMENTS 18,287,771 13,842,405 4,445,366 58% 44% 31,350,466 25,062,126 6,288,340 NET (Resources - Requirements) 2,520,834 15,375,243 12,854,409 - 8,360,254 8,360,254 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) Year to date includes expenditures paid annually. RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -Court Assess. Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Grants - Private Health & Human Svcs Chg CCF Interfund Grant Crime Pry Svcs Interfnd Grnt Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services COMM JUSTICE -JUVENILE Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. $ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 18,535 35,000 9,333 17,500 193,929 35,000 467 121,416 175 583 7,583 1,428 39,667 11,667 492,283 3,233,525 4,810,808 1,650,922 Materials and Services 771,223 Capital Outlay 58 Juvenile Resource Center Personal Services 1,477,090 Materials and Services 107,860 Capital Outlay 58 Contingency 351,513 21,145 2,610 58% 67% a) 29,263 (5,737) 58% 49% 7,572 (1,761) 58% 47% 15,557 (1,943) 58% 52% b) 67,655 (126,274) 58% 20% c) 64,350 29,350 58% 107% d) 207 (260) 58% 26% 33,341 (88,075) 58% 16% e) 31 (144) 58% 10% 225 (358) 58% 23% 10,835 3,252 58% 83% 1,400 (28) 58% 57% 612 612 58% n/a 1,245 1,245 58% n/a 16,024 (23,643) 58% 24% 5,521 (6,146) 58% 28% 274,983 (217,300) 58% 33% 3,233, 524 4,708,548 1,638,579 628,799 1,342,612 112,911 (1) (102,260) 12,343 142,424 58 f) f) 31,775 60,000 16,000 30,000 332,450 60,000 800 208,141 300 1,000 13,000 2,448 68,000 20,000 52,994 56,000 12,000 38,000 340,076 120,000 400 75,000 100 500 17,000 2,400 612 2,000 54,495 20,000 21,219 (4,000) (4,000) 8,000 7,626 60,000 (400) (133,141) (200) (500) 4,000 (48) 612 2,000 (13,505) 843,914 791,577 (52,337) 58% 58% 5,543,186 58% 63% 7,472,100 58% 58% 58% 134,478 58% (5,051) 58% 58 58% 351,513 58% Exp. % 58% 48% g) 0% 53% 61% h) 0% n/a 2,830,152 1,322,097 100 2,532,154 184,903 100 602,594 5,543,186 7,534,804 62,704 2,887,000 1,135,000 100 2,340,000 186,000 (56,848) 187,097 192,154 (1,097) 100 602,594 TOTAL REQUIREMENTS 4,358,724 3,722,901 635,823 58% 50% 7,472,100 6,548,100 924,000 NET (Resources - Requirements) 452,084 985,647 533,563 986,704 986,704 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -December. c) OYA Basic and Diversion first quarter payment received in November. 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 BRS revenue for July -November. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. 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 h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. Year End Budget Projection Variance $ 1,085,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 18,535 35,000 9,333 17,500 193,929 35,000 467 121,416 175 583 7,583 1,428 39,667 11,667 492,283 3,233,525 4,810,808 1,650,922 Materials and Services 771,223 Capital Outlay 58 Juvenile Resource Center Personal Services 1,477,090 Materials and Services 107,860 Capital Outlay 58 Contingency 351,513 21,145 2,610 58% 67% a) 29,263 (5,737) 58% 49% 7,572 (1,761) 58% 47% 15,557 (1,943) 58% 52% b) 67,655 (126,274) 58% 20% c) 64,350 29,350 58% 107% d) 207 (260) 58% 26% 33,341 (88,075) 58% 16% e) 31 (144) 58% 10% 225 (358) 58% 23% 10,835 3,252 58% 83% 1,400 (28) 58% 57% 612 612 58% n/a 1,245 1,245 58% n/a 16,024 (23,643) 58% 24% 5,521 (6,146) 58% 28% 274,983 (217,300) 58% 33% 3,233, 524 4,708,548 1,638,579 628,799 1,342,612 112,911 (1) (102,260) 12,343 142,424 58 f) f) 31,775 60,000 16,000 30,000 332,450 60,000 800 208,141 300 1,000 13,000 2,448 68,000 20,000 52,994 56,000 12,000 38,000 340,076 120,000 400 75,000 100 500 17,000 2,400 612 2,000 54,495 20,000 21,219 (4,000) (4,000) 8,000 7,626 60,000 (400) (133,141) (200) (500) 4,000 (48) 612 2,000 (13,505) 843,914 791,577 (52,337) 58% 58% 5,543,186 58% 63% 7,472,100 58% 58% 58% 134,478 58% (5,051) 58% 58 58% 351,513 58% Exp. % 58% 48% g) 0% 53% 61% h) 0% n/a 2,830,152 1,322,097 100 2,532,154 184,903 100 602,594 5,543,186 7,534,804 62,704 2,887,000 1,135,000 100 2,340,000 186,000 (56,848) 187,097 192,154 (1,097) 100 602,594 TOTAL REQUIREMENTS 4,358,724 3,722,901 635,823 58% 50% 7,472,100 6,548,100 924,000 NET (Resources - Requirements) 452,084 985,647 533,563 986,704 986,704 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -December. c) OYA Basic and Diversion first quarter payment received in November. 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 BRS revenue for July -November. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. 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 h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. SHERIFF - Fund 255 Statement of Financial Operating Data Seven Months Ended January 31, 2010 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,808,379 7,418,438 $ 183,677 $ 183,677 100% 9,924,783 6,677,567 16,484 (1,883,596) (740,871) 16,484 nla $ - $ 183,677 $ 183,677 58% 49% a) 20,242,936 17,258,442 2,984,494) 58% 53% a) 12,717,322 11,209,667 1,507,655) 58% n/a - 35,000 35,000 19,226,817 TOTAL RESOURCES 19,226,817 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,228,143 Civil 424,061 Automotive/Communications 815,432 Investigations/Evidence 981,357 Patrol/Civil/Comm Supp 4,355,147 Records 374,712 Adult Jail 5,305,365 Court Security 125,946 Emergency Services 109,708 Special Services Division 646,736 Regional Work Center 1,597,075 Training Division 175,031 Other Law Enforcement Svcs 307,826 Non -Departmental 270,109 Contingency 2,224,337 16,618,834 (2,607,983) 58% 50% 32,960,258 28,503,109 4,457,149) 16,802,511 (2,424,306) 58% 51% 32,960,258 28,686,786 4,273,472) 1,194,053 429,811 810,978 880,747 4,336,917 343,700 4,718,577 111,821 115,069 658,855 1,357,087 194,609 323,418 436,778 Transfers Out 285,833 245,000 34,090 (5,750) 4,454 100,610 18,230 31,012 586,788 14,125 (5,361) (12,119) 239,988 (19,578) (15,592) (166,669) 2,224,337 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% Exp. 57% 59% 58% 52% b) 58% c) 54% 52% c) 52% 61% 59% 50% c) 65% d) 61% 94% n/a 2,105, 388 726,961 1,397,884 1,682,327 7,465,967 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,813,149 2,105,388 726,961 1,397,884 1,613,327 69,000 7,365,967 100,000 642,363 8,826,909 268,000 215,908 188,071 1,108,690 2,473,842 372,053 527,702 463,044 - 3,813,149 264,000 (72,000) 40,833 58% 50% e) 490,000 440,000 50,000 TOTAL REQUIREMENTS 19,226,818 16,157,420 NET (Resources - Requirements) 3,069,398 58% 49% 32,960,258 28,468,109 4,492,149 (1) 645,091 645,092 218,677 218,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 2nd quarter actual. b) Delay of employee retirement expenses to next year. c) Personnel expenditures less than budgeted due to unfilled positions. d) Unplanned shooting range relocation expenses and JAG grant expenses. e) Interfund to P&P expenses being charged to Adult Jail. Year End Budget Projection Variance nla $ - $ 183,677 $ 183,677 58% 49% a) 20,242,936 17,258,442 2,984,494) 58% 53% a) 12,717,322 11,209,667 1,507,655) 58% n/a - 35,000 35,000 19,226,817 TOTAL RESOURCES 19,226,817 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,228,143 Civil 424,061 Automotive/Communications 815,432 Investigations/Evidence 981,357 Patrol/Civil/Comm Supp 4,355,147 Records 374,712 Adult Jail 5,305,365 Court Security 125,946 Emergency Services 109,708 Special Services Division 646,736 Regional Work Center 1,597,075 Training Division 175,031 Other Law Enforcement Svcs 307,826 Non -Departmental 270,109 Contingency 2,224,337 16,618,834 (2,607,983) 58% 50% 32,960,258 28,503,109 4,457,149) 16,802,511 (2,424,306) 58% 51% 32,960,258 28,686,786 4,273,472) 1,194,053 429,811 810,978 880,747 4,336,917 343,700 4,718,577 111,821 115,069 658,855 1,357,087 194,609 323,418 436,778 Transfers Out 285,833 245,000 34,090 (5,750) 4,454 100,610 18,230 31,012 586,788 14,125 (5,361) (12,119) 239,988 (19,578) (15,592) (166,669) 2,224,337 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% Exp. 57% 59% 58% 52% b) 58% c) 54% 52% c) 52% 61% 59% 50% c) 65% d) 61% 94% n/a 2,105, 388 726,961 1,397,884 1,682,327 7,465,967 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,813,149 2,105,388 726,961 1,397,884 1,613,327 69,000 7,365,967 100,000 642,363 8,826,909 268,000 215,908 188,071 1,108,690 2,473,842 372,053 527,702 463,044 - 3,813,149 264,000 (72,000) 40,833 58% 50% e) 490,000 440,000 50,000 TOTAL REQUIREMENTS 19,226,818 16,157,420 NET (Resources - Requirements) 3,069,398 58% 49% 32,960,258 28,468,109 4,492,149 (1) 645,091 645,092 218,677 218,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 2nd quarter actual. b) Delay of employee retirement expenses to next year. c) Personnel expenditures less than budgeted due to unfilled positions. d) Unplanned shooting range relocation expenses and JAG grant expenses. e) Interfund to P&P expenses being charged to Adult Jail. SHERIFF 701 Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 58% n!a $ 2,470,519 $ 3,343,461 $ 872,942 Revenues Tax Revenues - Current 8,644,827 13,401,104 4,756,277 58% 90% a) 14,819,703 14,981,411 161,708 Tax Revenues - Prior 291,667 644,694 353,027 58% 129% a) 500,000 727,128 227,128 Federal Grants 20,417 102,868 82,451 58% 294% b) 35,000 110,000 75,000 State Grant 26,341 36,920 10,579 58% 82% 45,156 45,156 Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000 SB 1145 1,004,029 1,480,995 476,966 58% 86% c) 1,721,192 1,935,336 214,144 Des. Cty Video Lottery Grant 2,917 5,000 2,083 58% n/a 5,000 5,000 Des Cty Court Security 75,250 74,988 (262) 58% 58% 129,000 129,000 Des Cty Juvenile Contract 1,750 (1,750) 58% 0% 3,000 3,000 Title III Reimbursement 87,500 - (87,500) 58% n/a 150,000 150,000 Transport 1,167 2,410 1,243 58% n/a 2,000 4,000 2,000 DC Fair & Expo Center - 2,100 2,100 58% n/a 3,000 3,000 Inmate Commissary Fees 35,000 29,534 (5,466) 58% 49% 60,000 60,000 Work Center Work Crews 24,763 19,590 (5,173) 58% 46% 42,450 42,450 Concealed Handgun Classes 3,500 4,125 625 58% 69% 6,000 6,000 Soc Sec Incentive -Fed 2,917 7,800 4,883 58% 156% 5,000 10,000 5,000 Miscellaneous 2,333 2,863 530 58% 72% 4,000 4,000 Oregon Mentors 2,917 1,902 (1,015) 58% n/a 5,000 5,000 Medical Services Reimb 7,000 6,514 (486) 58% 54% 12,000 12,000 Restitution 613 1,009 396 58% 96% 1,050 1,050 Sheriff Fees 93,333 118,376 25,043 58% 74% 160,000 160,000 - Interest 16,528 27,345 10,817 58% 97% 28,333 46,877 18,544 Interest on Unsegregated 2,061 2,645 584 58% 75% 3,533 3,533 - Rentals 17,499 60,030 42,531 58% 200% d) 30,000 67,236 37,236 Donations - 50 50 58% n/a 50 50 Total Revenues 10,367,246 16,032,862 5,665,616 58% 90% 17,772,417 18,516,227 743,810 TOTAL RESOURCES 12,837,765 19,376,323 6,538,558 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 11,808,380 58% 96% 20,242,936 21,859,688 1,616,752 Exp. % 9,924,783 1,883,597 58% 49% e) 20,242,936 17,258,442 2,984,494 TOTAL REQUIREMENTS 11,808,380 9,924,783 1,883,597 58% 49% 20,242,936 17,258,442 2,984,494 NET (Resources - Requirements) 1,029,385 9,451,540 8,422,155 - 4,601,245 4,601,245 a) Projection based on actual collections through November 30, 2009. b) Unplanned JAG Grant received. c) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. d) FBI relocation from Sheriffs Office has been delayed resulting in 6 months of additional rental revenue. e) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 58% n!a $ 2,470,519 $ 3,343,461 $ 872,942 Revenues Tax Revenues - Current 8,644,827 13,401,104 4,756,277 58% 90% a) 14,819,703 14,981,411 161,708 Tax Revenues - Prior 291,667 644,694 353,027 58% 129% a) 500,000 727,128 227,128 Federal Grants 20,417 102,868 82,451 58% 294% b) 35,000 110,000 75,000 State Grant 26,341 36,920 10,579 58% 82% 45,156 45,156 Transp. of State Wards 2,917 (2,917) 58% 0% 5,000 5,000 SB 1145 1,004,029 1,480,995 476,966 58% 86% c) 1,721,192 1,935,336 214,144 Des. Cty Video Lottery Grant 2,917 5,000 2,083 58% n/a 5,000 5,000 Des Cty Court Security 75,250 74,988 (262) 58% 58% 129,000 129,000 Des Cty Juvenile Contract 1,750 (1,750) 58% 0% 3,000 3,000 Title III Reimbursement 87,500 - (87,500) 58% n/a 150,000 150,000 Transport 1,167 2,410 1,243 58% n/a 2,000 4,000 2,000 DC Fair & Expo Center - 2,100 2,100 58% n/a 3,000 3,000 Inmate Commissary Fees 35,000 29,534 (5,466) 58% 49% 60,000 60,000 Work Center Work Crews 24,763 19,590 (5,173) 58% 46% 42,450 42,450 Concealed Handgun Classes 3,500 4,125 625 58% 69% 6,000 6,000 Soc Sec Incentive -Fed 2,917 7,800 4,883 58% 156% 5,000 10,000 5,000 Miscellaneous 2,333 2,863 530 58% 72% 4,000 4,000 Oregon Mentors 2,917 1,902 (1,015) 58% n/a 5,000 5,000 Medical Services Reimb 7,000 6,514 (486) 58% 54% 12,000 12,000 Restitution 613 1,009 396 58% 96% 1,050 1,050 Sheriff Fees 93,333 118,376 25,043 58% 74% 160,000 160,000 - Interest 16,528 27,345 10,817 58% 97% 28,333 46,877 18,544 Interest on Unsegregated 2,061 2,645 584 58% 75% 3,533 3,533 - Rentals 17,499 60,030 42,531 58% 200% d) 30,000 67,236 37,236 Donations - 50 50 58% n/a 50 50 Total Revenues 10,367,246 16,032,862 5,665,616 58% 90% 17,772,417 18,516,227 743,810 TOTAL RESOURCES 12,837,765 19,376,323 6,538,558 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 11,808,380 58% 96% 20,242,936 21,859,688 1,616,752 Exp. % 9,924,783 1,883,597 58% 49% e) 20,242,936 17,258,442 2,984,494 TOTAL REQUIREMENTS 11,808,380 9,924,783 1,883,597 58% 49% 20,242,936 17,258,442 2,984,494 NET (Resources - Requirements) 1,029,385 9,451,540 8,422,155 - 4,601,245 4,601,245 a) Projection based on actual collections through November 30, 2009. b) Unplanned JAG Grant received. c) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. d) FBI relocation from Sheriffs Office has been delayed resulting in 6 months of additional rental revenue. e) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual. RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grnt Des Cty Transient Room Tax City of Sisters Des Cty Tax/Fin Contract Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security & Traffic Reimb Seat Belt Program Miscellaneous Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Sale of Reportable Assets Sale of Equip & Material Total Revenues TOTAL RESOURCES SHERIFF 702 Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Col I. % $1,287,473 $ 1,433,708 $ 146,235 58% 4,223,159 139,417 1,167 44,625 109,453 39,083 72,606 503,512 1,042,322 245,009 583 15,857 47,570 1,167 58,333 7,583 3,500 5,833 2,917 49,583 43,750 5,833 1,050 3,500 6,565,414 328,087 55,506 51,000 81,481 29,263 78,500 10,000 1,042,322 242,675 1,405 15,856 47,569 663 6,290 7,871 5,150 7,014 7,280 68,568 7,800 500 1,122 7,486 1,296 6,779 10,503 2,342,255 188,670 54,339 6,375 (27,972) (9,820) 5,894 (493,512) (2,334) 822 (1) (1) (504) (52,043) 288 1,650 1,181 4,363 18,985 (35,950) 500 1,122 1,653 246 6,779 7,003 6,667,412 8,687,400 7,954,885 10,121,108 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 7,418,438 6,677,567 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% n/a $ 1,287,473 91% 137% 2775% 67% 43% 44% 63% 1% 58% 58% 141% 58% 58% 33% n/a 61% 86% 70% 146% 81% 10% a) 7,239,702 a) 239,000 b) 2,000 76,500 187,633 67,000 124,468 863,163 1,786,837 c) 420,015 1,000 27,183 81,548 2,000 d) 100,000 13,000 6,000 10,000 5,000 85,000 e) 75,000 n/a n/a 75% 10,000 72% 1,800 n/a 175% 6,000 $1,433,708 $ 146,235 7,339,633 370,961 55,506 76,500 187,633 67,000 124,468 863,163 1,786,837 416,016 1,405 27,183 81,548 2,000 100,000 13,000 6,000 10,000 10,000 85,000 13,371 500 2,500 12,833 1,800 10,000 12,000 99,931 131,961 53,506 (3,999) 405 5,000 (61,629) 500 2,500 2,833 10,000 6,000 2,019,988 58% 76% 11,429,849 11,676,857 247,008 2,166,223 58% 80% 12,717,322 13,110,565 393,243 Exp. % 740,871 58% 53% f) 12,717,322 11,209,667 1,507,655 TOTAL REQUIREMENTS 7,418,438 6,677,567 740,871 58% 53% 12,717,322 11,209,667 1,507,655 NET (Resources - Requirements) 536,447 3,443,541 2,907,094 - 1,900,898 1,900,898 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) 2nd Qtr invoice not received. e) Change in law resulting in less impound fee revenue. f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual. Year End Budget Projection Variance n/a $ 1,287,473 91% 137% 2775% 67% 43% 44% 63% 1% 58% 58% 141% 58% 58% 33% n/a 61% 86% 70% 146% 81% 10% a) 7,239,702 a) 239,000 b) 2,000 76,500 187,633 67,000 124,468 863,163 1,786,837 c) 420,015 1,000 27,183 81,548 2,000 d) 100,000 13,000 6,000 10,000 5,000 85,000 e) 75,000 n/a n/a 75% 10,000 72% 1,800 n/a 175% 6,000 $1,433,708 $ 146,235 7,339,633 370,961 55,506 76,500 187,633 67,000 124,468 863,163 1,786,837 416,016 1,405 27,183 81,548 2,000 100,000 13,000 6,000 10,000 10,000 85,000 13,371 500 2,500 12,833 1,800 10,000 12,000 99,931 131,961 53,506 (3,999) 405 5,000 (61,629) 500 2,500 2,833 10,000 6,000 2,019,988 58% 76% 11,429,849 11,676,857 247,008 2,166,223 58% 80% 12,717,322 13,110,565 393,243 Exp. % 740,871 58% 53% f) 12,717,322 11,209,667 1,507,655 TOTAL REQUIREMENTS 7,418,438 6,677,567 740,871 58% 53% 12,717,322 11,209,667 1,507,655 NET (Resources - Requirements) 536,447 3,443,541 2,907,094 - 1,900,898 1,900,898 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) 2nd Qtr invoice not received. e) Change in law resulting in less impound fee revenue. f) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 6 month actual. PUBLIC HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. Revised Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355 Revenues Medicare Reimbursement 2,333 50 (2,283) 58% 1% 4,000 4,000 State Grant 1,417,458 1,063,947 (353,511) 58% 44% a) 2,429,928 2,701,113 271,185 Child Dev & Rehab Center 20,263 7,690 (12,573) 58% 22% 34,737 30,759 (3,978) State Miscellaneous 124,390 115,280 (9,110) 58% 54% 213,240 227,646 14,406 OMAP 176,750 267,526 90,776 58% 88% 303,000 360,000 57,000 Family Planning Exp Proj 277,083 282,472 5,389 58% 59% b) 475,000 475,000 Grants 40,611 40,611 58% n/a c) 40,611 40,611 FY 2008-2009 4,568 4,568 58% n/a 4,568 4,568 Miscellaneous 2,420 2,420 58% n/a 2,420 2,420 Patient Insurance Fees 78,050 96,903 18,853 58% 72% 133,800 156,119 22,319 Health Dept/Patient Fees 88,754 71,902 (16,852) 58% 47% 152,150 124,000 (28,150) Vital Records -Birth 21,000 17,725 (3,275) 58% 49% 36,000 36,000 Vital Records -Death 57,167 47,605 (9,562) 58% 49% 98,000 98,000 Interest on Investments 22,167 9,828 (12,339) 58% 26% 38,000 16,848 (21,152) Donations 5,133 33,768 28,635 58% 384% 8,800 33,768 24,968 Interfund Contract 76,868 42,075 (34,793) 58% 32% d) 131,774 127,704 (4,070) Administrative Fee 15,750 15,750 58% 58% 27,000 27,000 - Drug Court Byrne 1,647 1,647 58% n/a - 30,061 30,061 Total Revenues 2,383,166 2,121,767 (261,399) 58% 52% 4,085,429 4,495,617 410,188 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) 14,583 (14,583) 58% 0% 25,000 25,000 1,352,030 1,352,029 (1) 58% 58% 2,317,765 2,317,765 4,649,779 4,594,151 (41,045) 58% 63% 7,328,194 7,958,737 630,543 Exp. % 2,600,661 2,434,172 166,489 58% 55% a) 4,458,276 4,539,942 (81,666) 1,029,310 836,322 192,988 58% 47% a) 1,764,531 2,064,915 (300,384) 21,526 - 21,526 58% 0% 36,902 36,902 87,500 75,000 12,500 58% 50% 150,000 150,000 535,783 535,783 58% n/a 918,485 918,485 4,274,780 3,345,494 929,286 58% 46% 7,328,194 6,791,759 536,435 374,999 1,248,657 888,241 - 1,166,978 1,166,978 a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 6. Grant appropriation for revisions in process. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. d) Public Health Nurse II for Juvenile, reduced to .60 FTE from .75 FTE. Contract is for actual expenditure. BEHAVIORAL HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2010 Revised Year to Date Budget Actual Variance FY % Coll. °A° Revised Year End Budget Projection ,variance RESOURCES: Beg. Net Working Capital $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) Revenues Marriage Licenses 3,208 3,115 (93) 58% 57% 5,500 5,500 Divorce Filing Fees 72,917 74,145 1,228 58% 59% 125,000 125,000 Domestic Partnership Fee 1,167 75 (1,092) 58% 4% 2,000 200 (1,800) Federal Grants 58,228 75,168 16,940 58% 75% a) 99,819 99,819 State Grants 3,078,300 3,261,006 182,706 58% 62% b) 5,277,086 5,351,224 74,138 State Miscellaneous 107,751 83,555 (24,196) 58% 45% 184,716 184,716 Title 19 175,411 41,510 (133,901) 58% 14% c) 300,705 200,000 (100,705) Liquor Revenue 61,833 65,598 3,765 58% 62% 106,000 106,000 - School Districts 40,833 54,300 13,467 58% 78% 70,000 88,800 18,800 Miscellaneous 23,800 18,173 (5,627) 58% 45% 40,800 30,000 (10,800) Patient Insurance Fees 144,375 66,363 (78,012) 58% 27% 247,500 150,000 (97,500) Patient Fees 6,708 1,824 (4,884) 58% 16% 11,500 5,000 (6,500) Seizure/Forfeiture 13,129 13,129 58% n/a - 13,129 13,129 Interest on Investments 18,667 25,425 6,758 58% 79% 32,000 45,000 13,000 Rentals 9,625 5,250 (4,375) 58% 32% 16,500 16,500 Donations 1,750 7,000 5,250 58% 233% 3,000 7,000 4,000 Interfund Contract 1,820 (1,820) 58% 0% 3,120 (3,120) Administrative Fee 1,770,390 1,739,947 (30,443) 58% 57% 3,034,954 3,031,954 (3,000) Comm. on Children & Fam 12,833 (12,833) 58% 0% 22,000 (22,000) Crime Prevention Services 74,083 38,260 (35,823) 58% 30% a) 127,000 127,000 Total Revenues 5,663,699 5,573,843 (89,856) 58% 57% 9,709,200 9,586,842 (122,358) Transfers In -General Fund 767,759 Transfers In -Other 149,121 TOTAL RESOURCES 761,929 (5,830) 58% 58% 1,316,158 1,316,158 217,658 68,537 58% 85% 255,636 363,129 107,493 9,305,579 9,143,426 (162,153) 58% 65% 14,005,994 13,856,125 (149,869) REQUIREMENTS: Expenditures Personal Services 4,611,647 Materials and Services 2,364,550 Capital Outlay 46,667 Transfers Out 87,500 Contingency 1,059,800 TOTAL REQUIREMENTS Exp. % 4,175,286 436,361 58% 53% d) 7,905,680 7,470,661 1,902,097 462,453 58% 47% 4,053,514 3,653,514 46,667 58% 0% 80,000 75,000 12,500 58% 50% 150,000 150,000 1,059,800 58% n/a 1,816,800 435,019 400,000 80,000 1,816,800 8,170,164 6,152,383 2,017,781 58% 44% 14,005,994 11,274,175 2,731,819 NET (Resources - Requirements) 1,135,415 2,991,043 1,855,628 - 2,581,950 2,581,950 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 Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % CoII. % RESOURCES: Beg. Net Working Capital $ 413,471 Revenues Admin -Operations 2,129 Admin -GIS 1,210 Admin -Code Enforcement 110,513 Building Safety 568,619 Electrical 163,625 Contract Services 149,042 Env Health -On Site Prog 170,829 Env Health-Lic Facilities 402,777 Env Health - Drinking H2O 55,598 Planning -Current 574,088 Planning -Long Range 250,192 Total Revenues 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188 9,973 17,667 93,630 496,083 145,117 46,585 120,936 584,262 56,842 358,942 207,756 7,844 16,457 (16,883) (72,536) (18,508) (102,457) (49,894) 181,485 1,244 (215,146) (42,436) 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 273% a) 851% b) 49% C) 51% C) 52% C) 18% d) 41% C) 85% e) 60% f) 36% g) 48% C) 3,650 2,075 189,450 974,775 280,500 255,500 292,850 690,475 95,311 984,150 428,900 14,500 40,300 153,200 798,000 225,400 118,000 191,000 690,475 95,311 633,200 378,400 10,850 38,225 (36,250) (176,775) (55,100) (137,500) (101,850) (350,950) (50,500) 2,448,622 2,137,792 (310,830) 58% 51% 4,197,636 3,337,786 (859,850) Trans In -GF 709,699 Trans In -GF for Lng Rng Ping 175,000 Trans In -Other 58 TOTAL RESOURCES 3,746,850 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Env Health-Lic Facilities Env Health - Drinking H2O EPA Grant Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations 996,399 125,770 105,565 423,001 120,586 154,456 140,401 289,302 47,016 472,373 321,900 103,635 274,167 709,700 1 0% n/a 1,216,627 1,216,627 150,000 (25,000) 0% n/a 300,000 300,000 (58) 0% 0% 100 (100) 3,627,150 (119,700) 58% 59% 6,127,834 5,484,072 (643,762) 970,003 118,657 103,761 401,463 116,283 150,025 135,043 287,702 48,588 451,681 250,345 162,418 26,396 7,113 1,804 21,538 4,303 4,431 5,358 1,600 (1,572) 20,692 71,555 (58,783) 274,167 58% 58% 58% 58% 58% 58% 58% 58% 58% Exp. % 57% h) 55% 57% 55% h) 56% h) 57% h) 56% 58% 60% 58% 56% h) 58% 45% 0% 91% 58% n/a 1,708,112 215,606 180,969 725,145 206,719 264,781 240,687 495,946 80,598 809,783 551,828 177,660 470,000 1,665,512 42,600 215,606 164,669 16,300 637,533 87,612 193,187 13,532 253,542 11,239 240,687 495,946 80,598 724,883 84,900 551,828 177,660 - 470,000 3,574,571 3,195,968 378,603 58% 52% 6,127,834 5,401,651 726,183 172,279 431,183 258,904 2,137,792 3,195,968 (1,058,176) 82,421 82,421 3,337,786 5,401,651 (2,063,865) 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. 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) Significant slowdown in land use applications. h) Projection reflects layoffs effective in February and the Building Official retirement in November. Year End Budget Projection Variance 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188 9,973 17,667 93,630 496,083 145,117 46,585 120,936 584,262 56,842 358,942 207,756 7,844 16,457 (16,883) (72,536) (18,508) (102,457) (49,894) 181,485 1,244 (215,146) (42,436) 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 273% a) 851% b) 49% C) 51% C) 52% C) 18% d) 41% C) 85% e) 60% f) 36% g) 48% C) 3,650 2,075 189,450 974,775 280,500 255,500 292,850 690,475 95,311 984,150 428,900 14,500 40,300 153,200 798,000 225,400 118,000 191,000 690,475 95,311 633,200 378,400 10,850 38,225 (36,250) (176,775) (55,100) (137,500) (101,850) (350,950) (50,500) 2,448,622 2,137,792 (310,830) 58% 51% 4,197,636 3,337,786 (859,850) Trans In -GF 709,699 Trans In -GF for Lng Rng Ping 175,000 Trans In -Other 58 TOTAL RESOURCES 3,746,850 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Env Health-Lic Facilities Env Health - Drinking H2O EPA Grant Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations 996,399 125,770 105,565 423,001 120,586 154,456 140,401 289,302 47,016 472,373 321,900 103,635 274,167 709,700 1 0% n/a 1,216,627 1,216,627 150,000 (25,000) 0% n/a 300,000 300,000 (58) 0% 0% 100 (100) 3,627,150 (119,700) 58% 59% 6,127,834 5,484,072 (643,762) 970,003 118,657 103,761 401,463 116,283 150,025 135,043 287,702 48,588 451,681 250,345 162,418 26,396 7,113 1,804 21,538 4,303 4,431 5,358 1,600 (1,572) 20,692 71,555 (58,783) 274,167 58% 58% 58% 58% 58% 58% 58% 58% 58% Exp. % 57% h) 55% 57% 55% h) 56% h) 57% h) 56% 58% 60% 58% 56% h) 58% 45% 0% 91% 58% n/a 1,708,112 215,606 180,969 725,145 206,719 264,781 240,687 495,946 80,598 809,783 551,828 177,660 470,000 1,665,512 42,600 215,606 164,669 16,300 637,533 87,612 193,187 13,532 253,542 11,239 240,687 495,946 80,598 724,883 84,900 551,828 177,660 - 470,000 3,574,571 3,195,968 378,603 58% 52% 6,127,834 5,401,651 726,183 172,279 431,183 258,904 2,137,792 3,195,968 (1,058,176) 82,421 82,421 3,337,786 5,401,651 (2,063,865) 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. 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) Significant slowdown in land use applications. h) Projection reflects layoffs effective in February and the Building Official retirement in November. 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 ROAD Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. % $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 285,833 - (285,833) 58% 0% 490,000 - (190,000) 462 462 58% n/a - 462 462 5,833 25,769 19,936 58% 258% 10,000 30,000 20,000 1,447,833 2,482,350 1,034,517 58% 100% a) 2,482,000 2,482,350 350 242,362 - (242,362) 58% 0% 415,477 - (1.15,477) - 54,322 54,322 58% n/a 66,476 66,476 4,666,667 4,435,693 (230,974) 58% 55% 8,000,000 7,900,000 (100,000) 131,250 250,085 118,835 58% 111% b) 225,000 250,085 25,085 145,833 316,603 170,770 58% 127% b) 250,000 316,603 66,603 5,833 (5,833) 58% 0% b) 10,000 10,000 5,833 - (5,833) 58% n/a b) 10,000 10,000 292 884 592 58% n/a 500 1,200 700 75,833 15,923 (59,910) 58% 12% 130,000 156,075 26,075 583 500 (83) 58% 50% 1,000 1,000 29,167 28,744 (423) 58% 57% 50,000 40,000 (10,000) 1,315 1,315 58% n/a 1,315 1,315 - 75 75 58% n/a - 375 375 408,333 - (408,333) 58% 0% c) 700,000 700,000 160,417 141,291 (19,126) 58% 51% 275,000 245,000 (30,000) 52,500 (52,500) 58% 0% c) 90,000 90,000 20,417 (20,417) 58% 0% c) 35,000 35,000 12,833 - (12,833) 58% 0% c) 22,000 22,000 1,458 1,982 524 58% 79% 2,500 3,300 800 406 406 58% n/a - 500 500 466,667 386,593 (80,074) 58% 48% 800,000 581,000 !219,000) 8,165,777 8,142,997 (22,780) 58% 58% 13,998,477 12,942,741 (1 055,736) Trans In - CDD 10,611 - (10,611) 58% 0% 18,190 18,190 Trans In - Solid Waste 413,331 354,284 (59,047) 58% 50% d) 708,567 708,567 Trans In - Transp SDC 43,750 37,500 (6,250) 58% 50% d) 75,000 75,000 Trans In -Road Imp Res 5,833 (5,833) 58% 0% c) 10,000 10,000 TOTAL RESOURCES 13,467,217 13,426,430 (78,287) 58% 68% 19,681,899 18,646,147 (1,035,752) REQUIREMENTS: Expenditures Personal Services 3,304,801 Materials and Services 5,327,706 Capital Outlay 1,575,000 Transfers Out 233,333 Contingency 1,040,268 Exp. Vo 3,075,404 229,397 58% 54% 5,665,373 5,311,065 5,037,183 290,523 58% 55% e) 9,133,210 8,807,712 978,425 596,575 58% 36% 2,700,000 1,217,702 233,333 58% 0% 400,000 400,000 1,040,268 58% n/a 1,783,316 354,308 325,498 1,482,298 1,783,316 TOTAL REQUIREMENTS 11,481,108 9,091,012 2,390,096 58% 46% 19,681,899 15,736,479 2,945,420 NET (Resources - Requirements) 1,986,109 4,335,418 2,311,809 2,909,668 2,909,668 a) Annual payment, $2,482,350, received January 15, 2010. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays Year End Budget Projection Variance $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 285,833 - (285,833) 58% 0% 490,000 - (190,000) 462 462 58% n/a - 462 462 5,833 25,769 19,936 58% 258% 10,000 30,000 20,000 1,447,833 2,482,350 1,034,517 58% 100% a) 2,482,000 2,482,350 350 242,362 - (242,362) 58% 0% 415,477 - (1.15,477) - 54,322 54,322 58% n/a 66,476 66,476 4,666,667 4,435,693 (230,974) 58% 55% 8,000,000 7,900,000 (100,000) 131,250 250,085 118,835 58% 111% b) 225,000 250,085 25,085 145,833 316,603 170,770 58% 127% b) 250,000 316,603 66,603 5,833 (5,833) 58% 0% b) 10,000 10,000 5,833 - (5,833) 58% n/a b) 10,000 10,000 292 884 592 58% n/a 500 1,200 700 75,833 15,923 (59,910) 58% 12% 130,000 156,075 26,075 583 500 (83) 58% 50% 1,000 1,000 29,167 28,744 (423) 58% 57% 50,000 40,000 (10,000) 1,315 1,315 58% n/a 1,315 1,315 - 75 75 58% n/a - 375 375 408,333 - (408,333) 58% 0% c) 700,000 700,000 160,417 141,291 (19,126) 58% 51% 275,000 245,000 (30,000) 52,500 (52,500) 58% 0% c) 90,000 90,000 20,417 (20,417) 58% 0% c) 35,000 35,000 12,833 - (12,833) 58% 0% c) 22,000 22,000 1,458 1,982 524 58% 79% 2,500 3,300 800 406 406 58% n/a - 500 500 466,667 386,593 (80,074) 58% 48% 800,000 581,000 !219,000) 8,165,777 8,142,997 (22,780) 58% 58% 13,998,477 12,942,741 (1 055,736) Trans In - CDD 10,611 - (10,611) 58% 0% 18,190 18,190 Trans In - Solid Waste 413,331 354,284 (59,047) 58% 50% d) 708,567 708,567 Trans In - Transp SDC 43,750 37,500 (6,250) 58% 50% d) 75,000 75,000 Trans In -Road Imp Res 5,833 (5,833) 58% 0% c) 10,000 10,000 TOTAL RESOURCES 13,467,217 13,426,430 (78,287) 58% 68% 19,681,899 18,646,147 (1,035,752) REQUIREMENTS: Expenditures Personal Services 3,304,801 Materials and Services 5,327,706 Capital Outlay 1,575,000 Transfers Out 233,333 Contingency 1,040,268 Exp. Vo 3,075,404 229,397 58% 54% 5,665,373 5,311,065 5,037,183 290,523 58% 55% e) 9,133,210 8,807,712 978,425 596,575 58% 36% 2,700,000 1,217,702 233,333 58% 0% 400,000 400,000 1,040,268 58% n/a 1,783,316 354,308 325,498 1,482,298 1,783,316 TOTAL REQUIREMENTS 11,481,108 9,091,012 2,390,096 58% 46% 19,681,899 15,736,479 2,945,420 NET (Resources - Requirements) 1,986,109 4,335,418 2,311,809 2,909,668 2,909,668 a) Annual payment, $2,482,350, received January 15, 2010. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays ADULT PAROLE & PROBATION Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% Revenues DOC Measure 57 126,761 217,350 90,589 58% 100% a) 217,305 217,350 45 State Miscellaneous 4,667 (4,667) 58% 0% b) 8,000 4,301 (3,699) Alternate Incarceration 30,918 30,918 58% n/a 30,918 30,918 State Subsidy 17,208 9,980 (7,228) 58% 34% c) 29,500 13,306 (16,194) SB 1145 1,656,623 2,221,492 564,869 58% 78% d) 2,839,925 2,961,990 122,065 Probation Work Crew Fees 23,333 21,100 (2,233) 58% 53% 40,000 36,000 (4,000) Miscellaneous 1,750 2,460 710 58% 82% 3,000 3,000 Electronic Monitoring Fee 93,333 105,030 11,697 58% 66% e) 160,000 175,000 15,000 Probation Superv. Fees 128,333 130,337 2,004 58% 59% 220,000 220,000 Interest on Investments 5,250 7,465 2,215 58% 83% 9,000 9,000 Interfund - Sheriff 29,167 37,500 8,333 58% 75% f) 50,000 50,000 Crime Prevention Services 29,167 12,500 (16,667) 58% 25% g) 50,000 50,000 Total Revenues 2,115,592 2,796,132 680,540 58% 77% 3,626,730 3,770,865 144,135 $ 467,892 $ 487,674 $ 19,782 Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 67,100 67,102 2 58% 58% 115,029 115,029 2,650,584 3,350,908 700,324 58% 80% 4,209,651 4,373,568 163,917 Exp. % 1,743,046 1,621,132 121,914 58% 54% 2,988,079 2,988,079 462,043 413,925 48,118 58% 52% 792,073 792,073 58 58 58% 0% 100 250,483 250,483 58% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 2,455,630 2,035,057 420,573 58% 48% 4,209,651 3,780,152 429,499 NET (Resources - Requirements) 194,954 1,315,851 1,120,897 - 593,416 593,416 a) New grant appropriated for drug addicted offenders. b) Payment to be received in February. c) Item has been split with the AIP line item. Over all revenue will be higher due to a greater offender population. d) Offender population was greater this biennium and DOC funded higher than base line budgeted amount. e) Increase in EMD use by the courts. f) Funding is provided at the beginning of each quarter. g) Payments made quarterly. 2nd quarter payment to be received in February. Year End Budget Projection Variance $ 467,892 $ 487,674 $ 19,782 Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 67,100 67,102 2 58% 58% 115,029 115,029 2,650,584 3,350,908 700,324 58% 80% 4,209,651 4,373,568 163,917 Exp. % 1,743,046 1,621,132 121,914 58% 54% 2,988,079 2,988,079 462,043 413,925 48,118 58% 52% 792,073 792,073 58 58 58% 0% 100 250,483 250,483 58% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 2,455,630 2,035,057 420,573 58% 48% 4,209,651 3,780,152 429,499 NET (Resources - Requirements) 194,954 1,315,851 1,120,897 - 593,416 593,416 a) New grant appropriated for drug addicted offenders. b) Payment to be received in February. c) Item has been split with the AIP line item. Over all revenue will be higher due to a greater offender population. d) Offender population was greater this biennium and DOC funded higher than base line budgeted amount. e) Increase in EMD use by the courts. f) Funding is provided at the beginning of each quarter. g) Payments made quarterly. 2nd quarter payment to be received in February. COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Seven Months Ended January 31, 2010 RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 214,550 63,717 (150,833) 58% 17% d) 367,800 367,600 (200) Title IV - Family Sup/Pres 21,964 12,545 (9,419) 58% 33% a) 37,652 14,907 (22,745) HealthyStart Medicaid 55,417 25,585 (29,832) 58% 27% 95,000 95,000 Child Care Block Grant 47,410 (47,410) 58% 0% a) 81,275 (81,275) Level 7 Services 102,196 84,336 (17,860) 58% 48% a) 175,193 257,982 82,789 HealthyStart /R -S -G 179,420 76,820 (102,600) 58% 25% a) 307,577 308,924 1,347 OCCF Grant 358,197 254,327 (103,870) 58% 41% a) 614,052 498,383 (115,669) Local Government Grants 7,849 7,849 58% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,667 1,834 (2,833) 58% 23% 8,000 8,000 Court Fines & Fees 43,750 44,487 737 58% 59% c) 75,000 70,000 (5,000) Interest on Investments 17,500 5,649 (11,851) 58% 19% 30,000 30,000 Grants -Private 1,167 (1,167) 58% 0% 2,000 2,000 Interfund Grants 109,375 61,875 (47,500) 58% 33% 187,500 187,500 Crime Prevention Services 43,371 10,683 (32,688) 58% 14% 74,350 74,350 Total Revenues 1,198,984 649,707 (549,277) 58% 32% 2,055,399 1,922,495 (132,904) Trans from General Fund Total Transfers In 165,861 165,861 - 58% 58% 284,333 284,333 165,861 165,861 - 58% 58% 284,333 284,333 TOTAL RESOURCES 1,989,388 1,484,194 (505,194) 58% 50% 2,964,275 2,875,454 (88,821) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 314,987 303,707 11,280 58% 56% b) 539,978 526,639 13,339 1,118,742 800,959 317,783 58% 42% a,d,e) 1,917,843 1,791,449 126,394 58 - 58 58% 0% 100 100 295,373 295,373 58% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,729,160 1,104,666 624,494 58% 37% 2,964,275 2,318,088 646,187 NET (Resources - Requirements) 260,228 379,528 119,300 a) Revenue projections based on final legislative allocations. 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. e) Regional project contributions from Crook & Jefferson counties. 557,366 557,366 Year to Date Budget Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 214,550 63,717 (150,833) 58% 17% d) 367,800 367,600 (200) Title IV - Family Sup/Pres 21,964 12,545 (9,419) 58% 33% a) 37,652 14,907 (22,745) HealthyStart Medicaid 55,417 25,585 (29,832) 58% 27% 95,000 95,000 Child Care Block Grant 47,410 (47,410) 58% 0% a) 81,275 (81,275) Level 7 Services 102,196 84,336 (17,860) 58% 48% a) 175,193 257,982 82,789 HealthyStart /R -S -G 179,420 76,820 (102,600) 58% 25% a) 307,577 308,924 1,347 OCCF Grant 358,197 254,327 (103,870) 58% 41% a) 614,052 498,383 (115,669) Local Government Grants 7,849 7,849 58% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,667 1,834 (2,833) 58% 23% 8,000 8,000 Court Fines & Fees 43,750 44,487 737 58% 59% c) 75,000 70,000 (5,000) Interest on Investments 17,500 5,649 (11,851) 58% 19% 30,000 30,000 Grants -Private 1,167 (1,167) 58% 0% 2,000 2,000 Interfund Grants 109,375 61,875 (47,500) 58% 33% 187,500 187,500 Crime Prevention Services 43,371 10,683 (32,688) 58% 14% 74,350 74,350 Total Revenues 1,198,984 649,707 (549,277) 58% 32% 2,055,399 1,922,495 (132,904) Trans from General Fund Total Transfers In 165,861 165,861 - 58% 58% 284,333 284,333 165,861 165,861 - 58% 58% 284,333 284,333 TOTAL RESOURCES 1,989,388 1,484,194 (505,194) 58% 50% 2,964,275 2,875,454 (88,821) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 314,987 303,707 11,280 58% 56% b) 539,978 526,639 13,339 1,118,742 800,959 317,783 58% 42% a,d,e) 1,917,843 1,791,449 126,394 58 - 58 58% 0% 100 100 295,373 295,373 58% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,729,160 1,104,666 624,494 58% 37% 2,964,275 2,318,088 646,187 NET (Resources - Requirements) 260,228 379,528 119,300 a) Revenue projections based on final legislative allocations. 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. e) Regional project contributions from Crook & Jefferson counties. 557,366 557,366 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 214,550 63,717 (150,833) 58% 17% d) 367,800 367,600 (200) Title IV - Family Sup/Pres 21,964 12,545 (9,419) 58% 33% a) 37,652 14,907 (22,745) HealthyStart Medicaid 55,417 25,585 (29,832) 58% 27% 95,000 95,000 Child Care Block Grant 47,410 (47,410) 58% 0% a) 81,275 (81,275) Level 7 Services 102,196 84,336 (17,860) 58% 48% a) 175,193 257,982 82,789 HealthyStart /R -S -G 179,420 76,820 (102,600) 58% 25% a) 307,577 308,924 1,347 OCCF Grant 358,197 254,327 (103,870) 58% 41% a) 614,052 498,383 (115,669) Local Government Grants 7,849 7,849 58% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,667 1,834 (2,833) 58% 23% 8,000 8,000 Court Fines & Fees 43,750 44,487 737 58% 59% c) 75,000 70,000 (5,000) Interest on Investments 17,500 5,649 (11,851) 58% 19% 30,000 30,000 Grants -Private 1,167 (1,167) 58% 0% 2,000 2,000 Interfund Grants 109,375 61,875 (47,500) 58% 33% 187,500 187,500 Crime Prevention Services 43,371 10,683 (32,688) 58% 14% 74,350 74,350 Total Revenues 1,198,984 649,707 (549,277) 58% 32% 2,055,399 1,922,495 (132,904) Trans from General Fund Total Transfers In 165,861 165,861 - 58% 58% 284,333 284,333 165,861 165,861 - 58% 58% 284,333 284,333 TOTAL RESOURCES 1,989,388 1,484,194 (505,194) 58% 50% 2,964,275 2,875,454 (88,821) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 314,987 303,707 11,280 58% 56% b) 539,978 526,639 13,339 1,118,742 800,959 317,783 58% 42% a,d,e) 1,917,843 1,791,449 126,394 58 - 58 58% 0% 100 100 295,373 295,373 58% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,729,160 1,104,666 624,494 58% 37% 2,964,275 2,318,088 646,187 NET (Resources - Requirements) 260,228 379,528 119,300 a) Revenue projections based on final legislative allocations. 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. e) Regional project contributions from Crook & Jefferson counties. 557,366 557,366 SOLID WASTE Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 Revenues State Grant 37,850 37,850 58% n/a a) 37,850 37,850 Miscellaneous 17,500 15,289 (2,211) 58% 51% 30,000 30,000 Franchise 3% Fees 116,667 18,786 (97,881) 58% 9% b) 200,000 200,000 Commercial Disp. Fees 814,567 520,764 (293,803) 58% 37% c) 1,396,400 1,396,400 Private Disposal Fees 899,092 808,105 (90,987) 58% 52% 1,541,300 1,541,300 Franchise Disposal Fees 2,767,042 2,273,696 (493,346) 58% 48% d) 4,743,500 4,743,500 Yard Debris 43,750 41,791 (1,959) 58% 56% 75,000 75,000 Special Waste 17,500 14,253 (3,247) 58% 48% 30,000 30,000 Interest 8,167 8,622 455 58% 62% 14,000 14,000 Sale of Equip & Material 20,417 15,879 (4,538) 58% 45% 35,000 35,000 Total Revenues 4,704,702 3,755,035 (949,667) 58% 47% 8,065,200 8,103,050 37,850 TOTAL RESOURCES 5,043,313 4,221,360 (821,953) 58% 50% 8,403,811 8,569,375 165,564 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 1,028,754 983,533 45,221 58% 56% 1,763,578 1,763,578 2,186,482 1,840,109 346,373 58% 49% e) 3,748,254 3,748,254 565,113 405,019 160,094 58% 42% 968,765 968,765 86,917 28,460 58,457 58% 19% f) 149,000 149,000 839,864 354,284 485,580 58% 25% 1,439,767 1,439,767 195,094 195,094 58% n/a 334,447 334,447 TOTAL REQUIREMENTS 4,902,224 3,611,405 1,290,819 58% 43% 8,403,811 8,069,364 334,447 NET (Resources - Requirements) 141,089 609,955 468,866 500,011 500,011 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) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year. f) Capital item purchases are spread out throughout the fiscal year. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 Revenues State Grant 37,850 37,850 58% n/a a) 37,850 37,850 Miscellaneous 17,500 15,289 (2,211) 58% 51% 30,000 30,000 Franchise 3% Fees 116,667 18,786 (97,881) 58% 9% b) 200,000 200,000 Commercial Disp. Fees 814,567 520,764 (293,803) 58% 37% c) 1,396,400 1,396,400 Private Disposal Fees 899,092 808,105 (90,987) 58% 52% 1,541,300 1,541,300 Franchise Disposal Fees 2,767,042 2,273,696 (493,346) 58% 48% d) 4,743,500 4,743,500 Yard Debris 43,750 41,791 (1,959) 58% 56% 75,000 75,000 Special Waste 17,500 14,253 (3,247) 58% 48% 30,000 30,000 Interest 8,167 8,622 455 58% 62% 14,000 14,000 Sale of Equip & Material 20,417 15,879 (4,538) 58% 45% 35,000 35,000 Total Revenues 4,704,702 3,755,035 (949,667) 58% 47% 8,065,200 8,103,050 37,850 TOTAL RESOURCES 5,043,313 4,221,360 (821,953) 58% 50% 8,403,811 8,569,375 165,564 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 1,028,754 983,533 45,221 58% 56% 1,763,578 1,763,578 2,186,482 1,840,109 346,373 58% 49% e) 3,748,254 3,748,254 565,113 405,019 160,094 58% 42% 968,765 968,765 86,917 28,460 58,457 58% 19% f) 149,000 149,000 839,864 354,284 485,580 58% 25% 1,439,767 1,439,767 195,094 195,094 58% n/a 334,447 334,447 TOTAL REQUIREMENTS 4,902,224 3,611,405 1,290,819 58% 43% 8,403,811 8,069,364 334,447 NET (Resources - Requirements) 141,089 609,955 468,866 500,011 500,011 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) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year. f) Capital item purchases are spread out throughout the fiscal year. RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments TOTAL REVENUES RISK MANAGEMENT Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance % of FY Coll. $2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $17'',314 266,562 266,550 (12) 58% 58% 456,964 456,964 167,005 166,894 (111) 58% 58% 286,294 286,294 107,447 107,447 (0) 58% 58% 184,195 184,195 499,248 499,240 (8) 58% 58% 855,854 855,854 93,445 93,452 7 58% 58% 160,191 160,191 14,583 - (14,583) 58% 0% 25,000 25,000 - 5,833 102,825 96,992 58% 1028% 10,000 105,000 9:,000 525 560 35 58% 62% 900 900 - 2,333 (22) (2,355) 58% -1% 4,000 4,000 - 12,833 9,520 (3,313) 58% 43% 22,000 22,000 - 17,500 22,207 4,707 58% 74% 30,000 30,000 1,187,316 1,268,673 81,357 58% 62% 2,035,398 2,130,398 9'.,000 Transfers In -PERS Reserve 58 - (58) 58% 0% 100 (100) TOTAL RESOURCES 3,679,351 3,937,964 258,613 58% 87% 4,527,475 4,799,689 27,2,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 54,088 Defense 974 Professional Service 307 Insurance 139,373 a) Loss Prevention 25 Repair / Replacement 4,192 Total General Liability 212,982 198,958 14,024 58% 54% 365,112 350,000 15,112 PROPERTY DAMAGE Insurance 135,996 a) Repair / Replacement 114,806 b) Total Property Damage 175,000 250,802 (75,802) 58% 84% 300,000 340,000 (4),000) VEHICLE Professional Service 1,015 Insurance 411 Loss Prevention 7,537 Repair / Replacement 46,244 Total Vehicle 70,000 55,207 14,793 58% 46% 120,000 90,000 30,000 WORKERS' COMPENSATION Settlement / Benefit 388,146 Insurance 81,028 Loss Prevention 14,832 Miscellaneous 21,624 Total Workers' Compensation 361,667 505,630 (143,963) 58% 82% 620,000 746,277 (126,277) UNEMPLOYMENT - Settlement/Benefits 81,667 170,808 (89,141) 58% 122% c) 140,000 200,000 (E0,000) % Exp. Total Direct Insurance Costs 901,315 1,181,404 (280,089) 58% 76% 1,545,112 1,726,277 (lf 1,165) Insurance Administration: Personal Services 159,853 156,127 3,726 58% 57% 274,034 274,034 Materials & Service 143,788 107,521 36,267 58% 44% 246,493 246,493 - Capital Outlay 58 - 58 58% 0% 100 - 100 Total Insurance Administration 303,699 263,648 40,051 58% 51% 520,627 520,527 100 Contingency 1,436,013 1,436,013 58% n/a 2,461,736 2,4+1,736 TOTAL REQUIREMENTS 2,641,027 1,445,052 1,195,975 58% 32% 4,527,475 2,246,804 2,210,671 NET 1,038,324 2,492,912 1,454,588 - 2,552,885 2,5;;2,885 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) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD an i Health Services. Year End Budget Projection Variance $2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $17'',314 266,562 266,550 (12) 58% 58% 456,964 456,964 167,005 166,894 (111) 58% 58% 286,294 286,294 107,447 107,447 (0) 58% 58% 184,195 184,195 499,248 499,240 (8) 58% 58% 855,854 855,854 93,445 93,452 7 58% 58% 160,191 160,191 14,583 - (14,583) 58% 0% 25,000 25,000 - 5,833 102,825 96,992 58% 1028% 10,000 105,000 9:,000 525 560 35 58% 62% 900 900 - 2,333 (22) (2,355) 58% -1% 4,000 4,000 - 12,833 9,520 (3,313) 58% 43% 22,000 22,000 - 17,500 22,207 4,707 58% 74% 30,000 30,000 1,187,316 1,268,673 81,357 58% 62% 2,035,398 2,130,398 9'.,000 Transfers In -PERS Reserve 58 - (58) 58% 0% 100 (100) TOTAL RESOURCES 3,679,351 3,937,964 258,613 58% 87% 4,527,475 4,799,689 27,2,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 54,088 Defense 974 Professional Service 307 Insurance 139,373 a) Loss Prevention 25 Repair / Replacement 4,192 Total General Liability 212,982 198,958 14,024 58% 54% 365,112 350,000 15,112 PROPERTY DAMAGE Insurance 135,996 a) Repair / Replacement 114,806 b) Total Property Damage 175,000 250,802 (75,802) 58% 84% 300,000 340,000 (4),000) VEHICLE Professional Service 1,015 Insurance 411 Loss Prevention 7,537 Repair / Replacement 46,244 Total Vehicle 70,000 55,207 14,793 58% 46% 120,000 90,000 30,000 WORKERS' COMPENSATION Settlement / Benefit 388,146 Insurance 81,028 Loss Prevention 14,832 Miscellaneous 21,624 Total Workers' Compensation 361,667 505,630 (143,963) 58% 82% 620,000 746,277 (126,277) UNEMPLOYMENT - Settlement/Benefits 81,667 170,808 (89,141) 58% 122% c) 140,000 200,000 (E0,000) % Exp. Total Direct Insurance Costs 901,315 1,181,404 (280,089) 58% 76% 1,545,112 1,726,277 (lf 1,165) Insurance Administration: Personal Services 159,853 156,127 3,726 58% 57% 274,034 274,034 Materials & Service 143,788 107,521 36,267 58% 44% 246,493 246,493 - Capital Outlay 58 - 58 58% 0% 100 - 100 Total Insurance Administration 303,699 263,648 40,051 58% 51% 520,627 520,527 100 Contingency 1,436,013 1,436,013 58% n/a 2,461,736 2,4+1,736 TOTAL REQUIREMENTS 2,641,027 1,445,052 1,195,975 58% 32% 4,527,475 2,246,804 2,210,671 NET 1,038,324 2,492,912 1,454,588 - 2,552,885 2,5;;2,885 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) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD an i Health Services. DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance % of FY Coll. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $5,137,000 $ 5,611,168 $ 474,168 100% 109% $5,137,000 $5,611,168 $ 474,168 Revenues Property Taxes - Current 3,576,290 5,553,526 1,977,236 58% 91% a) 6,130,782 6,208,795 78,013 Property Taxes - Prior 58,333 234,077 175,744 58% 234% a) 100,000 270,275 170,275 State Reimbursement 14,292 3,821 (10,471) 58% 16% b) 24,500 6,000 (18,500) Telephone User Tax 312,667 206,538 (106,129) 58% 39% 536,000 536,000 Data Network Reimb. 19,833 26,032 6,199 58% 77% c) 34,000 27,880 (6,120) Jefferson County 16,333 32,696 16,363 58% 117% 28,000 32,696 4,696 User Fee 35,292 51,388 16,096 58% 85% d) 60,500 60,500 Contract Payments 40,833 25,574 (15,259) 58% 37% e) 70,000 26,000 (44,000) Miscellaneous 4,958 5,119 161 58% 60% 8,500 8,500 Interest 21,000 51,946 30,946 58% 144% 36,000 75,000 39,000 Interest on Unsegregated Tax 2,188 1,096 (1,092) 58% 29% 3,750 3,750 Total Revenues 4,102,019 6,191,813 2,089,794 58% 88% 7,032,032 7,255,396 223,364 Transfers In -Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 58 (58) 58% 0% 100 (100) 9,239,019 11,802,981 2,563,962 58% 97% 12,169,132 12,866,564 697,432 Exp. 2,226,167 2,020,441 205,726 58% 53% 3,816,287 3,816,287 752,221 571,476 180,745 58% 44% 1,289,522 1,289,522 102,083 52,864 49,219 58% 30% 175,000 175,000 1,131,048 1,131,048 58% 0% 1,938,939 1,938,939 - 2,887,141 2,887,141 58% n/a 4,949,384 4,949,384 TOTAL REQUIREMENTS 7,098,660 2,644,781 4,453,879 58% 22% 12,169,132 7,219,748 4,949,384 NET (Resources - Requirements) 2,140,359 9,158,200 7,017,841 - 5,646,816 5,646,816 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. Health Benefits Trust Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY Coll. % Revised Budget * Year End L Projecton Variance RESOURCES Beg. Net Working Capital $ 17,894,797 $ 17,894,797 $ (0) 100% 100% $ 17,894,797 $ 17,894,797 1 (0) Revenues: Internal Premium Charges 6,113,333 6,124,073 10,739 58% 58% a) 10,480,000 10,480,000 P/T Emp - Add'I Prem 32,083 26,430 (5,653) 58% 48% 55,000 55,000 Employee Prem Contribution 192,500 198,310 5,810 58% 60% 330,000 330,000 COIC 583,333 637,958 54,624 58% 64% 1,000,000 1,040,000 40,000 Retiree / COBRA Co -Pay 291,667 351,171 59,505 58% 70% 500,000 555,000 55,000 Prescription Rebates 12,389 12,389 58% n/a 12,389 12,389 Interest 131,250 140,833 9,583 58% 63% 225,000 225,000 Total Revenues 7,344,167 7,491,164 146,997 58% 60% 12,590,000 12,697,389 107,389 TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Other Total Materials & Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 25,238,964 25,385,961 146,997 92% 83% 30,484,797 30,592,186 107,389 Exp. % 63,757 60,519 3,237 58% 55% 109,297 109,297 1,750 530 1,220 58% 18% 3,000 3,000 8,311,086 6,882,577 1,428,509 58% 48% b) 14,247,576 11,544,967 2,702,609 1,062,833 972,840 89,994 58% 53% b) 1,822,000 1,631,860 190,140 (48,173) 48,173 58% n/a (48,173) 48,173 217,315 217,493 (178) 58% 58% 372,540 372,540 6,708 68,989 (62,280) 58% n/a c) 11,500 11,500 170,779 168,866 1,913 58% 58% 292,764 292,764 47,628 21,897 25,731 58% 27% 81,648 81,648 28,917 29,002 (85) 58% 59% 49,572 49,572 5,833 1,860 3,973 58% 19% 10,000 10,000 58,333 1,239 57,094 58% 1% 100,000 100,000 16,951 17,145 (194) 58% 59% 29,059 29,059 9,928,134 8,334,265 1,593,870 58% 49% 17,019,659 14,078,738 2,940,921 - 58% 0% 100 100 7,790,849 7,790,849 58% 0% 13,355,741 - 13,355,741 17,782,740 8,394,784 9,387,956 58% 28% 30,484,797 14,188,035 15,296,762 7,456,224 16,991,177 9,534,953 - 16,404,151 1,5,404,151 * Proposed revisions to FY 2010 original budget a) Amount budgeted to be transferred from operating funds for FY 2010. b) Projection based on annualizing 31 weeks of claims paid. YTD actual is $251,847 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. RESOURCES: Beg. Net Working Capital Receipts: Security & Traffic Reimb Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Donations Interfund Contract Total Receipts Transfers In General Fund Transient Room Tax Welcome Center County Fair (619) F & E Reserve (617) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfer to Reserve Fund (617) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY % Coll. % $ 75,000 $ 42,232 $ (32,768) 12,000 2,004 1,150 600 256,700 1,164 32,000 2,000 102,000 16,420 3,867 525 155,977 (23) 12,385 1,185 39,282 38,000 3,300 100% 56% (12,000) 58% 0% 1,863 58% (625) 58% 23% (600) 58% 0% (100,723) 58% 29% (1,187) 58% -1% (19,615) 58% 21% (2,000) 58% 0% 1,185 58% 3% (62,718) 58% 17% 21,580 58% 44% 3,300 58% n/a - 58% 0% 97% 426,038 99,000 11,383 80,000 197,421 387,804 888,842 481,068 309,939 79,393 254,498 (171,540) 58% 25% 98,960 11,382 80,000 80,000 270,342 (117,462) 567,072 (321,770) 448,307 268,525 73,035 32,761 41,414 6,358 870,400 789,868 58% 58% 58% 58% 58% 50% 50% 100% 41% a) n/a c) Year End Budget Projection Variance $ 75,000 $ 42,232 $ (32,768) 12,000 4,000 2,300 1,200 540,000 2,000 58,000 7,000 45,000 235,000 86,420 45,000 5,863 1,675 600 382,557 812 44,000 5,015 46,170 110,000 108,000 3,300 45,000 (12 000) 1 863 625) 600) (157 443) (1 188) (14 000) (1 985) 1 170 (125 000) 21 580 3 300 1,037,920 752,992 (284,928) 197,919 22,765 80,000 197,421 498,105 197,919 22,765 80,000 85,118 243,243 629,045 (112,303) 243.243 130,940 58% 35% 1,611,025 1,424,269 (186 756) Exp. % 58% 54% 824,769 58% 51% b) 531,604 58% 63% 116,188 58% 0% 100 58% 0% c) 16,412 58% n/a 121,952 791,960 32 809 516,120 15 484 116,188 100 16 412 121 952 80,532 58% 49% 1,611,025 1,424,268 186 757 18,442 (222,796) (241,238) a) Transfer from Annual County Fair fund will be $112,303 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 Prior Months Total Accounts Receivable 6,650 3,948 10,598 0 0 Deposits Received for Future Events: 2010: February March April May June FY 2011 FY 2012 & beyond TOTAL 8 567 8 610 5 875 4 440 1 000 40 950 5 550 74 992 a) U c ca co H O) ' CO CO r CO - I- O c00 ' O CO ' co CO L() f rCO ✓ COCO0�a-COOO N O O O I'- co O I'- co O) O O O I- CO co r M N M O O co • O co O I - u) M CO L() 0 ct OO CA ' O O) ' O co_ CO OO O - c O M O O O I N O N N N CO O) O CY) co co CO CO O) co CO CO O O N CO O O N N O CO �C \ I COOO O O CO O O N co co N CO CO Cv) 14) v co co CO O) N M co O co O O 75 a) c O o 0_ cn rn a) U (0 E E 7 E c U W RESOURCES: r, Q) 0co CC) N a - CO Total Resources EXPENDITURES: • N M N a- CO M O N 0000 CO 0I'-000) co co 0 a- CO I- co N M CO CC) CC) O CO O a - C") N I� O r I 1 1 11 1 1 • N CO N ct a- CO CO r 0 00-0(c�00�cMN CO a- N I - co a) U cn O U Z coo c 0 0 0 cn (I) • a) m Q) aS D Ucn 0_ L E Q) N O U .r S U •,---. cn Q) 0 U a) c- co a) a) Q) c c c 0_ c0 L .5)•17; � � c `C - a) a) 2 c O ca - cn a) v ct Q w— a c c u_ Q co O O O O CO M N CO M N r Onc 70.1 lC 3 o E _ lC O a 3 c O U Eco °- QaLa)) -c UZ000 N O O co co O M O O N O) N Total Expenditures Co ti co N N N .47 m z C70 Cf) (n Z C • w LL 2 O a) 0 O M WSo U¢ in co w 2U� 0Z 0 0 co 1— C0 a)• w 0 a) 0 ca) CU 7 - o m Amount Paid c a) E E O E O Q U 0 d 0 Cn a) 0 0o 10 10 10 N O Cr) O O 10 o • N Cr) O a) CCD CO N O 10O O O O O M M co CV 10 • ami O 0 := CI) a) L 0 O 0 < < (U UU O 001- 10(0 - J 0 o o N CO LO CD M M 0 CO CN O NN f� L[) N N O C0 r- O) •,tC` a0 ,— O r- N O 03 N C) CO f's O CO 0) f. CO Cf) - CO — N N r o 1 1 N oNNMCO O vir O O 0 64 O CO CO 0 CO Cn 0 E CL N 0 O O U 1) C Powers of Automation CO 64 O CD CD 0 iz E a Tomco Electric Cfl O M CO CO 0) 0 N CO -'CO - 669 O 0 O o Lri0 O 0 c 64 O -.o O 0 C70 45_ OO wO O o 0 1.6 0) O ` E ' N CO. oo(O caaS_0 a) E 69 o E 2 J 7 1 o CCi (4 oo �, 69. omcc��rnco o 0 of �, a) Nom' CO o "-' p) i o coOO O U CO '� O ` CO .. C to O coo "0 CD 613 U N N �fn o 0 O N Cn -Es c`0 (13 °� cova) • E C ots 7 7 -C ,_ O 0) C 28 (9 cn a) a) U as T g C • cn as- .ca2 ,NM l's 0) 0 •cL 4t4ta WItIt1- O U Engineered Structures Inc 0 0 CO C)0 CN - CO C)O LO C3) C70 Total Engineered Structures, Inc. M O O N 0) N CO co - co o o M O r -- co - co o Total Encumbrances & Commitments 0) PROJECTION 1— O Encumbrances & Commitments RESOURCES: CO i 1 M CO M C) O 1- N M 0 1� Tr CO 0 MOO u•) 117 0) N CO N CO d• N O M C) O O N M O O co O O 0) O LO 1.0 0) N CO N CO N M M O ti c0 c0 co c0 CO 03 05 O CO CO 0 1s C) 0 CO 0 0 0 0) O 0 O c) 0 0 U•) CO 0 0 0 0 r r r co_. r O O N. r M N O N r r r 0 CO 14) N 0) 14) N 1. O 00 0)) O 0O0 O O O O O -' O r' 0 0' ' 0 0 N. r- N O O r r 0 CO CO CV CO CO N N. d• N CO 0 0) CO CO d• CO r c17 N CO r CO11') 0 CO U•) O d CO d• ct 0) N. r O- 1� r 0) N CO N CO 0 0) CO CO d CO r N. N CO r CO '4) 0 CO O CO d• d• ct 0) N r r i.0 cf) 1- M L ) N r d' CO r 0) N o N 12 OO w U C `-' CO X LL 7 U N. U Z a) m O -0 C7 g 0 U =. C co y (n > c C LL N N U a) a) 2) � i2 E v Yr V W Q) U c`p Na L.L. m a°i c rn ? cm C) U E rn co) c O H .g •c co v) •o 8 43 •c z E a m .5 . c co a� o 12 ID a� n a��i W .cL.� 2 m y av'i > c L c_ O a) N , O X cUQWF—aSSILQaWO� co LL 1— cF- W C0 0 0) cf) CO C0 N 0) CO cf) N CO CO Total Materials & Services Tr 0 0 0 0 O N O O O O O CO O O O O M 1: (Si c1) Cfl c17 O O co co N d• N N r N CO N r N. O O O co ' O O O 0) M co" d '4) N CO. M I 1 M (xi co N. M '4 ) '4 ) N. 0 N O M cc-) d• N. N. cf) O O cf) '4 ) d N CO M 0 N N M cc (0 d• Ct 0) C) C) C1) N C) Cl C) N C) u) e- 1- 00)) 00) 0) 0) 0) 0) 0) O 0) 0) N 0 e- u) C a) U E co C 02 N > a+ C a) CU 2 O Q 'y O La E _7 U> � X r �. (0 L- 2 >, CL Z 3 cti v) a) a ,_ °a v) ca O Uc 1)a) 0 U 'i a) a) a.2 c is < T.123 vai v) c L J m a g o f ate) 1_46 UZDOU1il— w I. Z O O O r • _ • U M O U t cn CL) a) O c o_ cts ci) 0) cts00 I- 0) PROJECTION J 1- 0 O U Q) (a Encumbrances & Commitments RESOURCES: c0 CO N O 00 r- CO0 M I- N O O • N InLC) Iss NCOOC) cri O N O N O N CO O CO CO 'I- N- N- ' r M I� N O M N 00 0) Total Resources co 00 In O r r (.6 N 911. L 000 ▪ s- 0 0 CO CO 0 N- '- cC) O co O O 0) co O co In O O in co O O O r r r O. r O R r M N O N r r r N 11•) N 0) o 00 0 ) 000 00 ' 0 0 co U•) N N LC)O N O O ' L NCO 0 01 co ,- L 0 0O In 000 co 0) In r Ln O I� M In N r .17 r 0) ti co I 1 1 1 1 1 1 1 M CO N CO O 0) M 00 dr CO I- N. Cs.1 00 a- 1.0 0 CO 00 I.N00rMIn0OIn00 0) dr dr0) N- r r In r to n INC In N r M r 0) N N M O O In 00 O N M CO N 0) M CO M 0) M O N CO M cM OO c•M 0) O co a) OI - ON C0 0) O M v 0) 0) coo) N v O 0) 0) r r N O O N 0) co O O 0 0 M� 0) 00 OO ) N N r In 0) 0) N N N ti ti If) 0) In C`r) N CO M O N N ti ti If) 0) In C") N CO M O N N M M cd CO co d a) V U U >1 U Z a) cn V) ca c a U c r c • O Cn Cn > en a) f/) •U a) a) 0) a R O 0 W ea U �a U >;a c Q) 0 t� U R as a) a ca I- °S 0 'c1 Cn a) -O U N c w c 4-(;) E U 0 a) a) .c c c a• a) p a U cB c c c a in , ca � c •c R U a) a) is V) Cn O X as<un-� S �uiQtiWO~ alZ00 W Z U N C0 N 00 Total Expenditures m Z H Z w O2 co H co -02o c2N O �U M NZc`a Z Q z CL 23. U cZ �q0 U LL L m L rn5 0 z w Amount Paid O E O E E O < U 0 Q cn0 N 0 0 ^c \W 0) CO LN r Cf) - Cf) M CO N CO LO M CO M N LCA Architects LCA Architects Total Architect Ln Interior modular walls Herman Miller La La co M co 00) co Lf) Lf) O r- co co r O CO M 0) C'') M cr 0) O L(0) I� ON (O 0 0 I� M ,— Powers of Automation O CO N O cam') c 0 .76a E a Tomco Electric N CO ,— N N Lf) O O O N I- N- Q) 0 r COIn LO L) c`o () ti r N N M co O M O ti E4a O 0 r - O (? rn o co O • E co E O rn O v E N M p • Nf CS) E 7 (O c)''' O cd eaO 7i;• 2 r 0 - O o cnwC'1 to"- O'' M ..> U • 0.o O L • 7 0 a) U 0 0 m 0 • w O 2 e2 c• 0.5 _c N • O O O s u, 0 0) E 2 c C U O U 11) U'4.7. cn = c U c E < D �i C0 D �a .c L *k *k *t * *k H 00 Engineered Structures Inc Total Engineered Structures, Inc. Total Encumbrances & Commitments RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service (Negative Int Rev) TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31, 2010 Year to Date Budget Actual Variance FY Coll. % $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% a) $ (2,666,469) $ (2,689,172) $ (22,703) 2,766,469 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) 42% 0% 2,766,469 100,000 (2,689,172) (2,789,172) 42% -2689% Exp.1% - (2,766,469) - (2,766,469) 100,000 (2,689,172) (2,789,172) 100,000 22,134 77,866 42% 22% b) 100,000 35,000 65,000 100,000 22,134 77,866 42% 22% - (2,711,305) (2,711,305) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) January interest expense was $2,455.12. 100,000 35,000 65,000 - (2,724,172) (2,724,172) Year End Budget Projection Variance $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% a) $ (2,666,469) $ (2,689,172) $ (22,703) 2,766,469 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) 42% 0% 2,766,469 100,000 (2,689,172) (2,789,172) 42% -2689% Exp.1% - (2,766,469) - (2,766,469) 100,000 (2,689,172) (2,789,172) 100,000 22,134 77,866 42% 22% b) 100,000 35,000 65,000 100,000 22,134 77,866 42% 22% - (2,711,305) (2,711,305) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) January interest expense was $2,455.12. 100,000 35,000 65,000 - (2,724,172) (2,724,172) Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2010 2/22/: 1)1 0 Jul Aug Sep Oct Nov Dec Jan YTD Total Tammy Baney 350 Conf/Sem & Educ/Training - - - - 350 - - - - - 66 - Travel Meals - - 15 20 90 125 Accommodations - - - 595 - - 595 - 1,676 45 Airfare Mileage reimbursement - 256 86 573 299 396 - Ground Transport/Parking - 1 - - 45 - Total Baney - 256 86 1,578 319 486 66 2,791 Dennis Luke 220 - 77 - - 25 - - 570 189 721 - 1,367 Conf/Sem & Educ/Training - - - 25 - 350 25 452 - 113 Travel Meals - - - Accommodations - 77 116 - Airfare - - - Mileage reimbursement - 329 85 257 485 210 - Ground Transport/Parking - - - 34 - - - 34 Total Luke - -------------------a 432 85 1,118 714 507 - 2,881 Alan Unger - - 50 350 Conf/Sem & Educ/Training - - - - 350 - - Travel Meals - - - - - 50 1,276 - 978 Accommodations - - 624 - 651 - Airfare 1 - - - - - .. - - - - - Mileage reimbursement - 978 - Ground Transport/Parking - - - 56 - - - 56 Total Unger - - - 1,031 - 1,630 50 2,711 Total - BOCC Department Conf/Sem & Educ/Training - - - 700 - 220 - 1,270 Travel Meals 25 - 40 133 90 76 364 Accommodations - 77 - ' 1,046 116 77 - 2,592 Airfare - - - - - - - - Mileage Reimbursement 585 172 831 1 784 606 66 4,022 Ground Transport - - - 79 - - - 13E Total - BOCC Department - 687 172 2,696 1,034 993 142 8,382 1 22,75C FY 2010 Budget 1 , Percent Expended 36.8"o 2/22/: 1)1 0