The URL can be used to link to this page

2010-159-Minutes for Meeting March 01,2010 Recorded 3/23/2010DESCHUTES COUNTY OFFICIAL RECORDS r} NANCY BLANKENSHIP, COUNTY CLERK 4J 010.159 COMMISSIONERS' JOURNAL 03/23/2010 03;31;41 PM ,,(11111, 111111, 11III Do not remove this page from original document. Deschutes County Clerk Certificate Page L r If this instrument is being re-recorded, please complete the following statement, in accordance with ORS 205.244: Re-recorded at the request of [give reason] previously recorded in Book_ or as Fee Number to correct and Page Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.orsz 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, 2010 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, 2010 Page 2 of 3 Pages VOTE: BANEY: Yes. UNGER: Yes. LUTE: 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. LUTE: Chair votes yes. Being no further items addressed, the meeting adjourned at 3:15 p.m. DATED this 1" Day of March 2010 for the Deschutes County Board of Commissioners. ATTEST: Recording Secretary Dennis R. Luke, Chair C~ Alan Unger, Vice Chair Tammy Baney, Com . sioner Minutes of Board of Commissioners' Work Session Monday, March 1, 2010 Page 3 of 3 Pages Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, 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 v rn (D Go rnrn C CO Go N U1 O CD r1 o oLO P o P V O O N ~ L } p1 V CO CO > LL Ch ' M Cfl i~ ~ N CO P M (0 P to N P 19 7 E9 EH N N 0 00 0 0 o CD w r' C4 CD E O r U9. to E~z m ' r c O c o 0 O V E e E m d d to N C y ~ 0) 1 E C m ~ E V1 m E M 0 d C ~ is m ~ U e e e e C e e O d' O CO N 10 0 , d. O O P O O 1 O O O O M O A 0 C 0 P N I'- C_O CO C V N to CO C D N N P 00 O O r ~ r N ~ _ el P L ;r 6> 60 c N O) U L C (U Q y to U O) ~ C U 0- - C6 N ~ N O ~.cc O E v (O Z w-. a ~ U u► a) COQQH d U m C O E QO) O)=dQ N N O O E (U N U' O UUCOJ 1- n a> C U ®ocumen! Reproduces Poorly (Archived) e e e e e e e OOtnWin OO CO O h N N N P P P fn U E 0 L E p. Cu Q CUD) 16 C V U y0 U c~ N Z CO Q ~ N O N ` ~j a~ ca a~m i~a~ c a~E La U~-j iii=UU H m a C a 'C o a N M LL Q d E U o E . to U d C m W N N Q O ~ Z U 0. io H U F - ° a v C~ U U U U V UI V U U U U U U U U U U U U cy cy U U p~ U d U d 5 U c M U ~p U N d e e N e e O U c r r c c m C oQ o 0 0 p Z Z Z Z Z Z Z Z Z Z Z Z Z Z° Z°° Z- Z ZV Z VZ Z m o 0 2. ~V Z Z m! o.-~o~?o'~?c Z 0000 00 o o 'v cEE ~0 0 0'v' ooip o~,Qjo Mo N T ~ W10 QTMrA~ c-~aN O!O O WIOrO 10 A O O Q 0 0 0 W WHO Oan N O O O Q N OHO O+O O MA~ W n NTO O C'f~Nal~ a }M O O~'rnN ~NOaM W(7NO NO~10O nrnOOrn000'.A NOOWNOU7OQN000OOMW~WWNOO WWrn ryn W u7r ' W W N rn th tp ej r7' O r O N A O a0 u)~ O N W O, O O' I. 0 0 0 W N O A O r 0 0 0 0 0 M tp N N O O W M N N 47 r N N O C N N O A n W N a O W W W W ~0 W W' N n' O O O O n W' W O rn N O Q O pp Q 0.~0 0 0 0 M W ~ O rn N 0 0 O W W N rn rn Q N N d aD N M M W. A N W a{ p~ n N N M, sr O~ O O n A u7 W W O O N O N O O N M W N O n W 0 W O W O Q N n a0 O r O N e') O O O O N WMrnM ^ rn M - r M' M o_,0 0m - Q V7 M MQ N a0 N Q N O O W W W aD M W. t0 A rn i V7 N W W rn W M O M O W N O rn Q'O M O Q N'O n,W W A N N O N N O W y M N N M,M M rn Q Q n M M u7 rn P O H O 0 0 ml N N 0 0 ~ B O O ~ O i 0 0 0 0 0 0 0 X 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c It U) W ~ c l! > N V N, V N ? :V N N . N N NN N N N N N N N N N N N N N N N. N N N N N N N N N N. V7 m W P N f+I rn C i W M ~ Q ~ N Q N Q aO.Oa ~+O♦A N+10 W V O+ •-=aO+O.O p'+O}O+n~0 O Oa O. O«O O}N O O♦10 O}Q N'O O O;O 0+0.0+0'0 O O«O O++ M N+r + » , . + . , . O O Q O W N o O Q O 7 0 0 N W 0 O ~ 0 0 0 O O O O M O O n O Q N 0 0 0 0 0 0 0 0 0 0 0 0 0 n W rn M O N Q N N N ap st O o. 0 O c0 c0' O u7 N O O 0 0 0 0 0 07 O o mO V N O O OI O O 0 0 0 < O O O O, C) m Of m w M N W W N O W M W W M n O N N Q W^ W O O rn W N n W Q A W' N W, N N Q. O W W. O N W N O W W Q . > N n W 10 rn N ~0 W ~A N N W N N W O O W M UJ N M W c NI a0. O O' A rn' O W A W rn W 0 m rn Q f0 Q N C'I O rn rn W M rn O rn O' O M M m. o O Q Q 0 0 0 N N O O O' M O W W O N M O M rn O 1") Y ! O O O N n Q N rn u) Q < p n 0 N O O O O O n 0 O M 0 0 O O o o M O O rn o o w O 0 0 0. O O 0 0 0 0 0 0 0 c, 0 0 O O O OOW m N N N 0 0 0 O O O O O O O O o 0 a o 0 0 O O rn 0 u) M q Q N,7 N, a ~ N N ~ N N N N N NON N'N.N N N N N N N N N N.N N.N N N N 0 N LQ LQ li , I W M ~ M • O Oa Mao O O.O♦O 'o `O'19 O O+O O O O O OYOa00 O!O O W O O O O*0`O`O+O Oa00+O O+O M~Oa0±OT0+ N4N-n « a +-a-- N O O W O. 0 0 0 0 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 OI O O, O O. O O O O O O O O O O O O O N O O O O M W rn S a07 O O t+I OO 0 0 0 0 0 0 IV O W Oi 0 0 0 0 0 0 O'O O n 0 0 0 0 0 0 0 0 o 0 o o o o. CJ o o of r m N Q O Q O O O O O O m o g W M o', O 0 o 0 0 o Q~ O O o Q O O O O O O Q O 0 0 W o o w O N. O, O W W m W O W 0 0 0 0 0 0 0 0 •1 M rn W O W O O c O O O W O O Q o o 0 0 c O q q O 0 c n N W ae O n o o W W O N la rn 0 O O O O Q O rn O M A Y O ep 0 0 0 0 0 0 0i O O~ M Oi 0 0 0 0 0 0n O O O W O n O ;F.6 0 O rn c; o C d' O N O O O N rn O N O O W O A 0 0 0 0 0 0 0 0 0 0 0 Q rn O O O O O O rn O O O'V7 0 0' 0 0 0 O'. A O E) o o o 0 0 0 0 g o 0 0 o o~ o 0 0 0 0 0'o rn o o 0 0 o m o 0 0 o.o 0 0 0 o n M uJ K f V R N O N O cN N N N N N N N N N N N N (V N N N N' N N N N N N N N N N' M Oi eJ m d W M M op n. C r C e e e e w e a s \ a a +a a a a e \ o %e e `e +e _ +R a e o w e e \ R \ e a \ \ e a e e a +1 a Z'Q ~ d y FU- y~ + V 4t O GOp O m a00 0 0 R OW N V O' N O N N m 0 0 0 N C t00 O W N N O O O M O O N N O N V O' ~`~9 N O r N N a- U> y N W N u) O ID O N W W O a V O O N n N n 0 0 0 W W W W W M A Q W W O O O N N O O rn W O Q QLq aD r + y m N N_ b m e } R' N N N N f+f M C) N N N N O O' O O e- O O - O O O O N E O V N N- ooEwdlq'c7o „ c e t + a t a e `ot \ \a e a a e a e- a + e• e aR ae e e- e e a e e +e e e e e• e e , a ' U U F 7 LL m J F- a 0 y O W OWN 10 0 O 0 0 0 0 0 0 0 0 O O O O O'O O.O 0 0 0 O i0 O O O O+ J u7 A 7 A A 0 O .0 O O O 10 a W O O N 10 O .1. O O 10 n U O N 10 O Q O ~a N M. N M ap . U7 IA O o O M g W N W W M n W. n 0 0 0 M N (+I M 0 0 Q dl C o K V MI M Q Q N N N W CJ O off O O r r O' O-- 00 al N O C C O ~ m C « N - N u Ea c a m ` O U o 0 a ~ 0 F- m yO O r A O a n N W W O O n N> W Q rn N W rn o 0 0 o W o n A n N W y Wy o n n n o W W W n m W u7 0 0 or Q ~ a++ Q Z CQ') r M t+WI N N N A N O M uS V N M N N N r r A r C VM1 10 r N N N ~i N N N S m m 'w n r N E C O O _O Oa0 O O _O'O O.O Oa0 O O O - - - - - - - - - - - - - O at > 0 0 lz !z z: I~ N W m ? _it' O _ - - - - ` - 7-N i+I N aD O T N m O N N N <O N M N c0 t+I, N A C `a ~S,VOon oA LV a Q z,s,.oooo•o-\oo p f+1 M Q Q A aD W~ C) O O ~ N N. N M M M, M Q Q N N u) W W W W n Iii n n W rn rn O O N > O g 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 oIO o 0 0 0 o a o 00 a + a + ate, r + - s + r ♦ t , , + + + r + a F- J m ar rn W rn rn rn rn rn W rn m rn o rn rn W rn rn rnrn rn rn rn rn rn rn rn a rn rn rn rn rn rn rn rn o 0 0 0 o rn rn o 0 o rn o. 0 0 0 0 0 0,0 0 N, 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 o o o L N A N O W A u) a O f N 10 A O rn O rn N Q O N. a a N O T O~ Of O' N N t0 O rn r N N .o. p o~lo ooLV Qr z Q Q oQo.-ooQ"oo:z z!zQQQ`IQQz7- Q Q!zzQQQQ 0 0 Qo 0 0 0 0 0 0 0 0 0 0 0 0 o,0 0 0 0 0 ~O ° o= o o 0 0 0 0 o 0 0 o' LL a ~ ~-,--r+ -ate ~ m m USYJO.Ky+N fn7 ~OODUI¢i F-F eddy«U Da0 O.u,LLt U'+LLr0, LL«O: p.. LLaLL LL a LL : U.LL 0Z Z ♦~rLL+LLTLL}LL«LL.U IaL~LL U LL LL < LL, a ~t~ Z m mrm m;. Z♦Z _ r ♦ a a « ~aeej+ Ka f.) C ¢ ~U M m aLL u- Z LL Co + LL a m ♦ LL +LL Z+ Z LL Z Z Z, C3 >'Z~Ha m Uca cil W3mpmp',xcna(n~wCLfnWmW VJW Yafnamaa~mm~:mmv)~n d E a W Z Y- [O m 3 fn Q J J O N' ~0 ] m Q IY J j W Y N rn n Y nZ C 1' E w tV F- W LL m m o '000 3> C7 aNO x 0 U m C9 N H 3: M ry W XW rn rn rn M N M w M -M M 'm Z m N X U) (D W ~ry X X LL M W •N M 2 M rn M n W M M M rn M MpWj Mj M N X X M M M ONi M M ~vMj cMY O W M.r)' M cW'I M N W M W - « U + r a M M M M M rn ej M M M M M ~y M M M MM 7 M M M NO M U+ ♦ + r. « ♦ as t D♦ .Y.. t t ♦Lr~♦ ,~a. +.+U t-. .O. O ZUU ♦Q« v-t a a +O ♦ + -_a + a + ♦ a Z U V U 0 U Cj C m C e1 is c U~U m Y m Zi U c U m d~- dm oxy y~ d'ci m a V p :U c p' p c Ui Y m d U am.fn -9, c a o c m d dm o m ~U'o0 m Z U. U m Z c m. m E m d,~ cmm3 °_'mm rnQ mZ rnw 0) UmR°o mU.C m U co U m rn Z Q mycmrtS Z mUJmm- m¢Ca o >U a) aa) cl0 a) m o c c ~ o' cv m ~U U U ° o E aimm>r.2Odr °c''vLLm EoTO e y E. aEm a)'a EE m co m 0 U m m o c c E>+ma-Umo n'NCEn Ecn _ £ m W m W ,a O m m o o l nm d o d E o ry o )L, - m ul E co i m w. LL m. m LL , LL LL U U C co c 1 LL LL V Y LL LL LL} m m U 2 Y J d C'Tfn-tom'VJ 7 m U LL 1- m o o m m m a C C E C m a r m U g L m m w r g m m co m m CO .m a' m 2 m a m m w e > T Y a- JE IJ C: JW~. J m U J J N>yJ UJJJfn rdJ T ♦ -a_ , C. a m2 o2:2 DLL 'E=E oxlz~~z~ Z LL LL m 2 LL ox..mx LL 22 S. ZS OLLZLL C F- U m m m m J m m x LLI. co V m 0 LL l 2E LL JLL LL LL 0 _ LL LL ~LL LL F- LLLL LLLL Jm - - F- 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 Year End $ E ud et Actual Variance FY % Coll. % Budget L Projection Variance RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% $ 6,050,000 $ 6,775,995 $ 725,995 Revenues Property Taxes 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: Exp. Expenditures Assessor 1,919,535 1,784,120 135,415 58% 54% 3,290,631 3,290,631 - County Clerk 852,077 736,748 115,329 58% 50% 1,460,704 1,450,704 10,000 BOPTA 34,830 29,007 5,823 58% 49% 59,708 63,614 (3,906) District Attorney 2,675,903 2,671,825 4,078 58% 58% 4,587,263 4,563,140 24,123 Finance/Tax 435,441 453,886 (18,445) 58% 61% e) 746,471 703,061 43,410 Veterans 131,659 130,069 1,590 58% 58% 225,701 225,701 - Property Management 139,816 138,246 1,570 58% 58% 239,685 239,685 - Grant Projects 61,643 59,865 1,778 58% 57% 105,673 105,673 - Non-Departmental 940,920 414,328 526,592 58% 26% 1,613,006 1,493,006 120,000 Contingency 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 Transfers Out 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. COMM JUSTICE-JUVENILE Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 1,085,000 $1,200,041 $ 115,041 100% 111% $ 1,085,000 $1,200,041 $ 115,041 Revenues Federal Grants 18,535 21,145 2,610 58% 67% a) 31,775 52,994 21,219 SB #1065-Court Assess. 35,000 29,263 (5,737) 58% 49% 60,000 56,000 (4,000) Discovery Fee 9,333 7,572 (1,761) 58% 47% 16,000 12,000 (4,000) Food Subsidy 17,500 15,557 (1,943) 58% 52% b) 30,000 38,000 8,000 OYA Basic & Diversion 193,929 67,655 (126,274) 58% 20% c) 332,450 340,076 7,626 Inmate/Prisoner Housing 35,000 64,350 29,350 58% 107% d) 60,000 120,000 60,000 Inmate Commissary Fees 467 207 (260) 58% 26% 800 400 (400) Contract Payments 121,416 33,341 (88,075) 58% 16% e) 208,141 75,000 (133,141) Miscellaneous 175 31 (144) 58% 10% 300 100 (200) MIP Diversion Fees 583 225 (358) 58% 23% 1,000 500 (500) Interest on Investments 7,583 10,835 3,252 58% 83% 13,000 17,000 4,000 Leases 1,428 1,400 (28) 58% 57% 2,448 2,400 (48) Grants - Private - 612 612 58% n/a - 612 612 Health & Human Svcs Chg - 1,245 1,245 58% n/a - 2,000 2,000 CCF Interfund Grant 39,667 16,024 (23,643) 58% 24% 0 68,000 54,495 (13,505) Crime Prv Svcs Interfnd Grnt 11,667 5,521 (6,146) 58% 28% f) 20,000 20,000 - Total Revenues 492,283 274,983 (217,300) 58% 33% 843,914 791,577 (52,337) Transfers In-General Fund 3,233,525 3,233,524 (1) 58% 58% 5,543,186 :1,543,186 - TOTAL RESOURCES 4,810,808 4,708,548 (102,260) 58% 63% 7,472,100 7,534,804 62,704 REQUIREMENTS: Exp. Expenditures Community Justice-Juvenile Personal Services 1,650,922 1,638,579 12,343 58% 58% 2,830,152 2,887,000 (56,848) Materials and Services 771,223 628,799 142,424 58% 48% g) 1,322,097 1,135,000 187,097 Capital Outlay 58 - 58 58% 0% 100 100 - Juvenile Resource Center Personal Services 1,477,090 1,342,612 134,478 58% 53% 2,532,154 :2,340,000 192,154 Materials and Services 107,860 112,911 (5,051) 58% 61% h) 184,903 186,000 (1,097) Capital Outlay 58 - 58 58% 0% 100 - 100 Contingency 351,513 - 351,513 58% n/a 602,594 602,594 TOTAL REQUIREMENTS NET (Resources - Requirements) 4,358,724 3,722,901 635,823 58% 50% 7,472,100 15,548,100 924,000 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. D 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 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues Year to Date Year End EBudget Actual Variance FY % con. % Budget Projection Variance $ - $ 183,677 $ 183,677 100% 11,808,379 9,924,783 (1,883,596) 58% 7,418,438 6,677,567 (740,871) 58% _ - 16,484 16,484 58% 19,226,817 16,618,834 (2,607,983) 58% nla $ - $ 183,677 $ 183,677 49% a) 20,242,936 17,258,442 (2,984,494) 53% a) 12,717,322 11,209,667 (1,507,655) n/a - 35,000 35,000 50% 32,960,258 28,503,109 (4,457,149) TOTAL RESOURCES 19,226,817 16,802,511 (2,424,306) 58% 51% 32,960,258 28,686,786 (4,273,472) REQUIREMENTS: Ex p. 9/61 EXPENDITURES & TRANSFERS Sheriffs Division 1,228,143 1,194,053 34,090 58% 57% 2,105,388 2,105,388 - Civil 424,061 429,811 (5,750) 58% 59% 726,961 726,961 - Automotive/Communications 815,432 810,978 4,454 58% 58% 1,397,884 1,397,884 - Investigations/Evidence 981,357 880,747 100,610 58% 52% b) 1,682,327 1,613,327 69,000 Patrol/Civil/Comm Supp 4,355,147 4,336,917 18,230 58% 58% c) 7,465,967 7,365,967 100,000 Records 374,712 343,700 31,012 58% 54% 642,363 642,363 - Adult Jail 5,305,365 4,718,577 586,788 58% 52% c) 9,094,909 8,826,909 268,000 Court Security 125,946 111,821 14,125 58% 52% 215,908 215,908 - Emergency Services 109,708 115,069 (5,361) 58% 61% 188,071 188,071 - Special Services Division 646,736 658,855 (12,119) 58% 59% 1,108,690 1,108,690 - Regional Work Center 1,597,075 1,357,087 239,988 58% 50% c) 2,737,842 2,473,842 264,000 Training Division 175,031 194,609 (19,578) 58% 65% d) 300,053 372,053 (72,000) Other Law Enforcement Svcs 307,826 323,418 (15,592) 58% 61% 527,702 527,702 - Non-Departmental 270,109 436,778 (166,669) 58% 94% 463,044 463,044 - Contingency 2,224,337 - 2,224,337 58% n/a 3,813,149 - 3,813,149 Transfers Out 285,833 245,000 40,833 58% 50% e) 490,000 440,000 50,000 TOTAL REQUIREMENTS 19,226,818 16,157,420 3,069,398 58% 49% 32,960,258 28,468,109 4,492,149 NET (Resources - Requirements) (1) 645,091 645,092 - 218,677 218,677 a) Revenue from LED's based o n actual expen diture and adju sted quarterly. Projection is based on 2nd quarter actual. b) Delay of employee retirement expenses to n ext year. c) Personnel expenditures less t han budgeted due to unfilled positions. d) Unplanned shooting range relocation expens es 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 'ear End T Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 58% nla $ 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 58% REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 11,808,380 9,924,783 1,883,597 58% TOTAL REQUIREMENTS 11,808,380 9,924,783 1,883,597 58% NET (Resources - Requirements) 1,029,385 9,451,540 8,422,155 96% 20,242,936 21,859,688 1,616,752 Ex p. 49% e) 20,242,936 17,258,442 2,984,494 49% 20,242,936 17,258,442 2,984,494 - 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. SHERIFF 702 Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Year End Budget Actual Variance FY % Coil. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,287,473 $ 1,433,708 $ 146,235 58% n/a $1,287,473 $1,433,708 $ 146,235 Revenues Tax Revenues - Current 4,223,159 6,565,414 2,342,255 58% 91% a) 7,239,702 7,339,633 99,931 Tax Revenues - Prior 139,417 328,087 188,670 58% 137% a) 239,000 370,961 131,961 Federal Grants 1,167 55,506 54,339 58% 2775% b) 2,000 55,506 53,506 US Forest Service 44,625 51,000 6,375 58% 67% 76,500 76,500 - State Grant 109,453 81,481 (27,972) 58% 43% 187,633 187,633 - SB #1065 Court Assessment 39,083 29,263 (9,820) 58% 44% 67,000 67,000 - Marine Board License Fee 72,606 78,500 5,894 58% 63% 124,468 124,468 - Des Cty General Fund Grnt 503,512 10,000 (493,512) 58% 1% 863,163 863,163 - Des Cty Transient Room Tax 1,042,322 1,042,322 - 58% 58% 1,786,837 1,786,837 - City of Sisters 245,009 242,675 (2,334) 58% 58% c) 420,015 416,016 (3,999) Des Cty Tax/Fin Contract 583 1,405 822 58% 141% 1,000 1,405 405 Des Cty CDD Contract 15,857 15,856 (1) 58% 58% 27,183 27,183 - Des Cty Solid Waste Contr 47,570 47,569 (1) 58% 58% 81,548 81,548 - Des Cty Clerk/Election 1,167 663 (504) 58% 33% 2,000 2,000 - School Districts 58,333 6,290 (52,043) 58% n/a d) 100,000 100,000 - Security & Traffic Reimb 7,583 7,871 288 58% 61% 13,000 13,000 - Seat Belt Program 3,500 5,150 1,650 58% 86% 6,000 6,000 - Miscellaneous 5,833 7,014 1,181 58% 70% 10,000 10,000 - Sheriff Fees 2,917 7,280 4,363 58% 146% 5,000 10,000 5,000 Court Fines & Fees 49,583 68,568 18,985 58% 81% 85,000 85,000 - Impound Fees 43,750 7,800 (35,950) 58% 10% e) 75,000 13,371 (61,629) Restitution - Street Crimes - 500 500 58% n/a - 500 500 Seizure/Forfeiture - 1,122 1,122 58% n/a - 2,500 2,500 Interest 5,833 7,486 1,653 58% 75% 10,000 12,833 2,833 Interest on Unsegregated 1,050 1,296 246 58% 72% 1,800 1,800 - Sale of Reportable Assets - 6,779 6,779 58% n/a - 10,000 10,000 Sale of Equip & Material _ 3,500 10,503 7,003 58% 175% 6,000 12,000 6,000 Total Revenues 15,667,412 8,687,400 2,019,988 58% 76% 11,429,849 11,676,857 247,008 TOTAL RESOURCES Ar,954,885 10,121,108 2,166,223 58% 80% 12,717,322 13,110,565 393,243 REQUIREMENTS: Exp. % EXPENDITURES & TRANSFE RS Materials and Services 7,418,438 6,677,567 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 Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $1,120,355 $ 220,355 Revenues Medicare Reimbursement 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 14,583 - (14,583) 58% 0% 25,000 25,000 - Transfers In-General Fund 1,352,030 1,352,029 (1) 58% 58% 2,317,765 2,317,765 - TOTAL RESOURCES 4,649,779 4,594,151 (41,045) 58% 63% 7,328,194 7,958,737 630,543 REQUIREMENTS: Exp. Expenditures Personal Services 2,600,661 2,434,172 166,489 58% 55% a) 4,458,276 4,539,942 (81,666) Materials and Services 1,029,310 836,322 192,988 58% 47% a) 1,764,531 2,064,915 (300,384) Capital Outlay 21,526 - 21,526 58% 0% 36,902 36,902 - Transfers Out 87,500 75,000 12,500 58% 50% 150,000 150,000 - Contingency 535,783 - 535,783 58% n/a 918,485 - 918,485 TOTAL REQUIREMENTS 4,274,780 3,345,494 929,286 58% 46% 7,328,194 6,791,759 536,435 NET(Resources - Requirements) 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 11 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 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Seizure/Forfeiture Interest on Investments Rentals Donations Interfund Contract Administrative Fee Comm. on Children & Fam Crime Prevention Services Year to Date EBudget Actual Variance FY % Coll. % $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% 3,208 3,115 (93) 72,917 74,145 1,228 1,167 75 (1,092) 58,228 75,168 16,940 3,078,300 3,261,006 182,706 107,751 83,555 (24,196) 175,411 41,510 (133,901) 61,833 65,598 3,765 40,833 54,300 13,467 23,800 18,173 (5,627) 144,375 66,363 (78,012) 6,708 1,824 (4,884) - 13,129 13,129 18,667 25,425 6,758 9,625 5,250 (4,375) 1,750 7,000 5,250 1,820 - (1,820) 1,770,390 1,739,947 (30,443) 12,833 - (12,833) 74,083 38,260 (35,823) Revised Year End Budget Projection Variance $ 2,725,000 $ 2,589,996 $ (135,004) 57% 5,500 5,500 - 59% 125,000 125,000 - 4% 2,000 200 (1,800) 75% a) 99,819 99,819 - 62% b) 5,277,086 5,351,224 74,138 45% 184,716 184,716 - 14% c) 300,705 200,000 (100,705) 62% 106,000 106,000 - 78% 70,000 88,800 18,800 45% 40,800 30,000 (10,800) 27% 247,500 150,000 (97,500) 16% 11,500 5,000 (6,500) n/a - 13,129 13,129 79% 32,000 45,000 13,000 32% 16,500 16,500 - 233% 3,000 7,000 4,000 0% 3,120 (3,120) 57% 3,034,954 3,031,954 (3,000) 0% 22,000 - (22,000) 30% a) 127,000 127,000 - 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% Total Revenues 5,663,699 5,573,843 (89,856) 58% Transfers In-General Fund 767,759 761,929 (5,830) 58% Transfers In-Other 149,121 217,658 68,537 58% TOTAL RESOURCES 9,305,579 9,143,426 (162,153) 58% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 57% 9,709,200 9,586,842 (122,358) 58% 1,316,158 1,316,158 - 85% 255,636 363,129 107,493 65% 14,005,994 13,856,125 (149,869) Exp. 4,611,647 4,175,286 436,361 58% 53% d) 7,905,680 7,470,661 435,019 2,364,550 1,902,097 462,453 58% 47% 4,053,514 3,653,514 400,000 46,667 - 46,667 58% 0% 80,000 - 80,000 87,500 75,000 12,500 58% 50% 150,000 150,000 - 1,059,800 - 1,059,800 58% n/a 1,816,800 - 1,816,800 8,170,164 6,152,383 2,017,781 58% 44% 14,005,994 11,274,175 2,731,819 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 'Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 413,471 629,659 $ 216,188 100% 152%n $ 413,471 $ 629,659 216,188 Revenues Admin-Operations 2,129 9,973 7,844 58% 273% a) 3,650 14,500 10,850 Admin-GIS 1,210 17,667 16,457 58% 851% b) 2,075 40,300 38,225 Admin-Code Enforcement 110,513 93,630 (16,883) 58% 49% c) 189,450 153,200 (36,250) Building Safety 568,619 496,083 (72,536) 58%u 51% c) 974,775 798,000 (176,775) Electrical 163,625 145,117 (18,508) 58% 52% c) 280,500 225,400 (55,100) Contract Services 149,042 46,585 (102,457) 58%u 18% d) 255,500 118,000 (137,500) Env Health-On Site Prog 170,829 120,936 (49,894) 58% 41% c) 292,850 191,000 (101,850) Env Health-Lic Facilities 402,777 584,262 181,485 58% 85% e) 690,475 690,475 - Env Health - Drinking H2O 55,598 56,842 1,244 58% 60%u f) 95,311 95,311 - Planning-Current 574,088 358,942 (215,146) 58% 36% g) 984,150 633,200 (350,950) Planning-Long Range 250,192 207,756 (42,436) 58% 48% c) 428,900 378,400 (50,500) Total Revenues 2,448,622 2,137,792 (310,830) 58% 51% 4,197,636 3,337,786 (859,850) Trans In-GF 709,699 709,700 1 0% n/a 1,216,627 1,216,627 - Trans In-GF for Ong Rng Ping 175,000 150,000 (25,000) 0% n/a 300,000 300,000 - Trans In-Other 58 - (58) 0% 0%u 100 - (100) TOTAL RESOURCES 3,746,850 3,627,150 (119,700) 58%, 59% 6,127,834 5,484,072 (643,762) 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 Exp. 996,399 970,003 26,396 58% 57% h) 1,708,112 1,665,512 125,770 118,657 7,113 58% 55% 215,606 215,606 105,565 103,761 1,804 58% 57% 180,969 164,669 423,001 401,463 21,538 58% 55% h) 725,145 637,533 120,586 116,283 4,303 58% 56% h) 206,719 193,187 154,456 150,025 4,431 58% 57% h) 264,781 253,542 140,401 135,043 5,358 58% 56% 240,687 240,687 289,302 287,702 1,600 58% 58% 495,946 495,946 47,016 48,588 (1,572) 58% 60% 80,598 80,598 Planning-Current 472,373 451,681 20,692 58% 56% h) Planning-Long Range 321,900 250,345 71,555 58% 45% Transfers Out (D/S Fund) 103,635 162,418 (58,783) 0% 91% Contingency 274,167 - 274,167 58% n/a TOTAL REQUIREMENTS 3,574,571 3,195,968 378,603 58%u 52% NET (Resources - Requirements) 172,279 431,183 258,904 Revenues Expenditures Net from Operations 2,137,792 3,195,968 (1,058,176) 42,600 16,300 87,612 13,532 11,239 809,783 724,883 84,900 551,828 551,828 - 177,660 177,660 - 470,000 - 470,000 6,127,834 5,401,651 726,183 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. ROAD Statement of Financial Operating Data Seven Months Ended January 31, 2010 [ Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 Revenues Federal Reimbursements 285,833 - (285,833) 58% 0% 490,000 - (490,000) System Development Chrg - 462 462 58% n/a - 462 462 Mineral Lease Royalties 5,833 25,769 19,936 58% 258% 10,000 30,000 20,000 Forest Receipts 1,447,833 2,482,350 1,034,517 58% 100% a) 2,482,000 2,482,350 350 State Grant 242,362 - (242,362) 58% 0% 415,477 - (415,477) State Miscellaneous - 54,322 54,322 58% n/a - 66,476 66,476 Motor Vehicle Revenue 4,666,667 4,435,693 (230,974) 58% 55% 8,000,000 7,900,000 (100,000) City of Bend 131,250 250,085 118,835 58% 111% b) 225,000 250,085 25,085 City of Redmond 145,833 316,603 170,770 58% 127% b) 250,000 316,603 66,603 City of Sisters 5,833 - (5,833) 58% 0% b) 10,000 10,000 - City of La Pine 5,833 - (5,833) 58% n/a b) 10,000 10,000 - Admin Recovery (SDC) 292 884 592 58% n/a 500 1,200 700 Miscellaneous 75,833 15,923 (59,910) 58% 12% 130,000 156,075 26,075 Road Vacations 583 500 (83) 58% 50% 1,000 1,000 - Interest on Investments 29,167 28,744 (423) 58% 57% 50,000 40,000 (10,000) Other Bank/LGIP Interest - 1,315 1,315 58% n/a - 1,315 1,315 Parking Fees - 75 75 58% n/a - 375 375 Interfund Contract 408,333 - (408,333) 58% 0% c) 700,000 700,000 - Equipment Repairs 160,417 141,291 (19,126) 58% 51% 275,000 245,000 (30,000) Vehicle Repairs 52,500 - (52,500) 58% 0% c) 90,000 90,000 - Vegetation Management 20,417 - (20,417) 58% 0% c) 35,000 35,000 - Inter-fund: Forester 12,833 - (12,833) 58% 0% c) 22,000 22,000 - Car Washes 1,458 1,982 524 58% 79% 2,500 3,300 800 Car Rental - 406 406 58% n/a - 500 500 Sale of Eqp & Material 466,667 386,593 (80,074) 58% 48% 800,000 581,000 (219,000) Total Revenues 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 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 13,467,217 13,426,430 (78,287) 58% 68% Exp. 19,681,899 18,646,147 (1,035,752) 3,304,801 3,075,404 229,397 58% 54% 5,665,373 5,311,065 354,308 5,327,706 5,037,183 290,523 58% 55% e) 9,133,210 8,807,712 325,498 1,575,000 978,425 596,575 58% 36% 2,700,000 1,217,702 1,482,298 233,333 - 233,333 58% 0% 400,000 400,000 - 1,040,268 - 1,040,268 58% n/a 1,783,316 - 1,783,316 TOTAL REQUIREMENTS 11,481,108 9,091,012 2,390,096 58% 46% NET(Resources - Requirements) 1,986,109 4,335,418 2,311,809 a) Annual payment, $2,482,350, received January 15, 2010. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays 19,681,899 15,736,479 3,945,420 - 2,909,668 2,909,668 ADULT PAROLE & PROBATION Statement of Financial Operating Data Seven Months Ended January 31, 2010 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund - Sheriff Crime Prevention Services Total Revenues Transfers In-General Fund TOTALRESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Year End Budget Actual Variance FY % [Coll. % Budget Projection Variance $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782 126,761 217,350 90,589 58% 100% a) 217,305 217,350 45 4,667 - (4,667) 58% 0% b) 8,000 4,301 (3,699) - 30,918 30,918 58% n/a - 30,918 30,918 17,208 9,980 (7,228) 58% 34% c) 29,500 13,306 (16,194) 1,656,623 2,221,492 564,869 58% 78% d) 2,839,925 2,961,990 122,065 23,333 21,100 (2,233) 58% 53% 40,000 36,000 (4,000) 1,750 2,460 710 58% 82% 3,000 3,000 - 93,333 105,030 11,697 58% 66% e) 160,000 175,000 15,000 128,333 130,337 2,004 58% 59% 220,000 220,000 - 5,250 7,465 2,215 58% 83% 9,000 9,000 - 29,167 37,500 8,333 58% 75% f) 50,000 50,000 - 29,167 12,500 (16,667) 58% 25% g) 50,000 50,000 - 2,115,592 2,796,132 680,540 58% 77% 3,626,730 3,770,865 144,135 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 - 100 250,483 - 250,483 58% n/a 429,399 - 429,399 2,455,630 2,035,057 420,573 58% 48% 4,209,651 3,780,152 429,499 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 Year to Date Feludget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ (524,543 $ 668,626 $ 44,083 100% Revenues Federal Grants 214,550 63,717 (150,833) 58% Title IV - Family Sup/Pres 21,964 12,545 (9,419) 58% HealthyStart Medicaid 55,417 25,585 (29,832) 58% Child Care Block Grant 47,410 - (47,410) 58% Level 7 Services 102,196 84,336 (17,860) 58% HealthyStart /R-S-G 179,420 76,820 (102,600) 58% OCCF Grant 358,197 254,327 (103,870) 58% Local Government Grants - 7,849 7,849 58% Charges for Svcs-Misc 4,667 1,834 (2,833) 58% Court Fines & Fees 43,750 44,487 737 58% Interest on Investments 17,500 5,649 (11,851) 58% Grants-Private 1,167 - (1,167) 58% Interfund Grants 109,375 61,875 (47,500) 58% Crime Prevention Services _ 43,371 10,683 (32,688) 58% Total Revenues 1,198,984 649,707 (549,277) 58% 107% 17% 33% 27% 0% 48% 25% 41% n/a 23% 59% 19% 0% 33% 14% 32% Trans from General Fund 165,861 165,861 - 58% 58% Total Transfers In 165,861 165,861 - 58% 58% TOTAL RESOURCES 1,989,388 1,484,194 (505,194) 58% 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. Year End Budget Projection Variance $ 624,543 $ 668,626 $ 44,083 d) 367,800 367,600 (200) a) 37,652 14,907 (22,745) 95,000 95,000 - a) 81,275 - (81,275) a) 175,193 257,982 82,789 a) 307,577 308,924 1,347 a) 614,052 498,383 (115,669) e) - 7,849 7,849 8,000 8,000 - C) 75,000 70,000 (5,000) 30,000 30,000 - 2,000 2,000 - 187,500 187,500 - 74,350 74,350 - 2,055,399 1,922,495 (132,904) 284,333 284,333 - 284,333 284,333 - 2,964,275 2,875,454 (88,821) 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% 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 1 st 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. 2,964,275 2,318,088 646,187 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. % Budget Projection 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 TOTAL REQUIREMENTS 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 4,902,224 3,611,405 1,290,819 58% 43% NET (Resources - Requirements) 141,089 609,955 468,866 ti ear End 'Variance 8,403,811 8,069,364 334,447 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. RISK MANAGEMENT Statement of Financial Operating Data Seven Months Ended January 31, 2010 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments TOTAL REVENUES Transfers In-PERS Reserve TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance Repair / Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT - Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Contingency TOTAL REQUIREMENTS NET Year to Date Year End Bud et Actual Variance % of 7y--,--Col- Budget Pro'ection Variance $2,491,977 $2,669,291 $177,314 100% 107% 266,562 266,550 (12) 58% 58% 167,005 166,894 (111) 58% 58% 107,447 107,447 (0) 58% 58% 499,248 499,240 (8) 58% 58% 93,445 93,452 7 58% 58% 14,583 - (14,583) 58% 0% 5,833 102,825 96,992 58% 1028% 525 560 35 58% 62% 2,333 (22) (2,355) 58% -1% 12,833 9,520 (3,313) 58% 43% 17,500 22,207 4,707 58% 74% 1,187,316 1,268,673 81,357 58% 62% 58 - (58) 58% 0% 3,679,351 3,937,964 258,613 58% 87% Exp. $2,491,977 $2,669,291 $177,314 456,964 456,964 286,294 286,294 - 184,195 184,195 - 855,854 855,854 - 160,191 160,191 - 25,000 25,000 - 10,000 105,000 95,000 900 900 - 4,000 4,000 22,000 22,000 30,000 30,000 - 2,035,398 2,130,398 95,000 100 - (100) 4,527,475 4,799,689 272,214 54,088 974 307 139,373 a) 25 4,192 212,982 198,958 14,024 58% 54% 365,112 350,000 15,112 135,996 a) 114,806 b) 175,000 250,802 (75,802) 58% 84% 300,000 340,000 (40,000) 1,015 411 7,537 46,244 70,000 55,207 14,793 58% 46% 120,000 90,000 30,000 388,146 81,028 14,832 21,624 361,667 505,630 (143,963) 58% 82% 620,000 746,277 (126,277) 81,667 170,808 (89,141) 58% 122% c) 140,000 200,000 (60,000) 901,315 1,181,404 (280,089) 58% 76% 1,545,112 1,726,277 (181,165) 159,853 156,127 3,726 58% 143,788 107,521 36,267 58% 58 - 58 58% 303,699 263,648 40,051 58% 1,436,013 - 1,436,013 58% 2,641,027 1,445,052 1,195,975 58% 1,038,324 2,492,912 1,454,588 57% 274,034 274,034 - 44% 246,493 246,493 - 0% 100 - 100 51% 520,627 520,527 100 n/a 2,461,736 - 2,461,736 32% 4,527,475 2,246,804 2,280,671 - 2,552,885 2,552,885 a) Annual insurance payment (1011/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 and Health Services. DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Year End Budget Actual Variance % of FY % Coll. Budge t Projection Variance RESOURCES: Beg. Net Working Capital $5,137,000 $ 5,611,168 $ 474,168 Revenues Property Taxes - Current 3,576,290 5,553,526 1,977,236 Property Taxes - Prior 58,333 234,077 175,744 State Reimbursement 14,292 3,821 (10,471) Telephone User Tax 312,667 206,538 (106,129) Data Network Reimb. 19,833 26,032 6,199 Jefferson County 16,333 32,696 16,363 User Fee 35,292 51,388 16,096 Contract Payments 40,833 25,574 (15,259) Miscellaneous 4,958 5,119 161 Interest 21,000 51,946 30,946 Interest on Unsegregated Tax 2,188 1,096 (1,092) Total Revenues 4,102,019 6,191,813 2,089,794 Transfers In-Other TOTAL RESOURCES 58 - (58) 9,239,019 11, 802, 981 2,563,962 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 100% 109% $5,137,000 $5,611,168 $ 474,168 58% 91% a) 6,130,782 6,208,795 78,013 58% 234% a) 100,000 270,275 170,275 58% 16% b) 24,500 6,000 (18,500) 58% 39% 536,000 536,000 - 58% 77% c) 34,000 27,880 (6,120) 58% 117% 28,000 32,696 4,696 58% 85% d) 60,500 60,500 - 58% 37% e) 70,000 26,000 (44,000) 58% 60% 8,500 8,500 - 58% 144% 36,000 75,000 39,000 58% 29% 3,750 3,750 - 58% 88% 7,032,032 7,255,396 223,364 58% 0% 100 - (100) 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 7,098,660 2,644,781 4,453,879 58% 22% 12,169,132 7,219,748 4,949,384 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. I I r Health Benefits Trust Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Revised Year End Budget Actual Variance FYI/. Coll. % Budget * Projection Variance RESOURCES Beg. Net Working Capital $17,894,797 $ 17,894,797 $ (0) 100% 100% $17,894,797 $17,894,797 $ (0) Revenues: Internal Premium Charges 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 25,238,964 25,385,961 146,997 92% 83% 30,484,797 30,592,186 107,389 REQUIREMENTS Exp. Expenditures: Personal Services 63,757 60,519 3,237 58% 55% 109,297 109,297 - Materials & Services Conferences and Seminars 1,750 530 1,220 58% 18% 3,000 3,000 - Claims Paid-Medical/Rx 8,311,086 6,882,577 1,428,509 58% 48% b) 14,247,576 11,544,967 2,702,609 Claims Paid-Dental/Vision 1,062,833 972,840 89,994 58% 53% b) 1,822,000 1,631,860 190,140 Refunds - (48,173) 48,173 58% n/a - (48,173) 48,173 Insurance Expense 217,315 217,493 (178) 58% 58% 372,540 372,540 - State Assessments 6,708 68,989 (62,280) 58% n/a c) 11,500 11,500 - Administration Fee 170,779 168,866 1,913 58% 58% 292,764 292,764 - PPO Fee 47,628 21,897 25,731 58% 27% 81,648 81,648 - Health Impact 28,917 29,002 (85) 58% 59% 49,572 49,572 - Printing 5,833 1,860 3,973 58% 19% 10,000 10,000 - Program Supplies 58,333 1,239 57,094 58% 1% 100,000 100,000 - Other 16,951 17,145 (194) 58% 59% 29,059 29,059 - Total Materials & Services 9,928,134 8,334,265 1,593,870 58% 49% 17,019,659 14,078,738 2,940,921 Capital Outlay - - - 58% 0% 100 - 100 Contingency _ 7,790,849 - 7,790,849 58% 0% 13,355,741 - 13,355,741 TOTAL REQUIREMENTS 17,782,740 8,394,784 9,387,956 58% 28% 30,484,797 14,188,035 16,296,762 NET (Resources - Requirements) _ 7,456,224 16,991,177 9,534,953 - 16,404,151 16,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. I N O LL 0 L p moN Uoo,) d N N m m O M 0 OX. m , W Co 2 N ~ r C ~ L N ;a p O c 70 O LL C y N w o Z N N O? 2 7 - ~ N m >`IL N C J Q a O ~ H U na w O 0O a ~ a > O I M'OIO~,l O Oi IMipi I IW 7101M1 IODi IaDi 010 pl I M OIto N N O OHO O r O N' cO N O CO O m IN I O CO.OIW' ! ! ^I I 7 CD O!O Q11.- O (OI ' Co llcol iaDIV MI N n L C'R'- IM ' O m d I ' (O N "N_Id_I 0I. a Itp N10 'a0I O' ' i LO INI I mo. r.. M MI ( M vl Imo! ito i N IM v u v t0 7 ~ ' . _.I I.~ I I I I~ I I"I I I III I ' ! ' ' co I " I I I , l~lll II~1 ilI!III~ ~I~I'III~, O 16 p O c`1 7 LL m IO 010~00100!O10 O,O O170 MI MI O O ' O W O!0 O O OIOIOIO O:O O OO I Ic0'O!Oh ~1 !oN IOpI cOIOIN 1O 0 N OIO O 0 CD'COjO10: N' I~iCO < IT '.OIV_I O 10111 O17 e-N ~II~ Vc07IN a 7 QI I7 I Ito to i0 (o N 1i to t~INlO n 0I ~I INI 71 IN M 0 O In O Ie- p N O O) of ojl~ IM I7 ICI I II~II IIII I I II II II III Ni 0 Ia ONE CD 100 e-IDI ~--I N N IT S NIeN- j~ p + a ~m O c _ I I I I °o 0I^10101010 M of IOCOO O co 1N IOIOI~ OI CA00I 01~ O 0 O! IN o O 'M OIO IOI COIOI~ SO O O O mlw 1 Q) I - ' O o ' I Cl I M N I I O: p U N 7 m , ~e I ,N OIM a0 I O h Ole- c I r;N plln ~ aIOIM O Ic- 0 OI I T O p ol~ p CO ~ N Mlt.: LL Q LL` I ^ : I i i; •01N OCD co Iii to, ~10i M Iv, I"•,. ie" I I i t ! I I~ I I I ICI V I - I .7 N co co I I I ~ I r ~ I i.^; laI ~I I I I I I Iv' ' ' i ~ ll I i ` I 1~ ,Ii I, p 1p i ; I I o I I'i of ' U its I ItO N 1 Q h N1 ' IN -11 , I I 1 1 I 1 I I I I I I I I00 OOI IpO OO'^ NI~1 p•~I p O' IN D) N M co 101 MO CI 0IQ) 7 90 M ~ IMI ip M OI O C ! i I OO M:tO COI 1 ' N Ilf N I , I ' IN Nld Al ~I~ ICI N :p IOIIO M Co' cc ~I ICI M 71 N M N I I' I~ I I II I I I I I i ! I I' j I >1 O 1010 COI 101: IcN7 i i N n IC U, I 1 IO iNI ' IO ICOIM p , ' ^I 00 C4 ca N I I 0 al CI n1 ICD 0 If'fi In 7 7 Ip I c+j ' 7 ' ' , 1 Of v' - i I I I l 1 ICI ~ 1 1 vI I I 1 i I c0 _ 10 0!OICD 10 t0 O 'O.OI M I ' O MI O 10 t0 O OI M I j I0I I 'O 't0 INI a) CL O CO 010 ' O MIV1 I v pIN, ^ I In O M ' O 7 M C , ~ i e-I 1 1i ' jl I O Q NI 1 ' It pI I I V) l nI 1 L !°'O 'OI 'O '.'O~n 0!N'I I M O M 0 ' nI M A 1 IN ' IN i iM IMI 01 IOe- I ' ' I ' 'ICI ' tOOItOD ' I iAI O' ' M'cooI f0 O. I I7 I 0 C D I 1 - pI ^ - IM 0 C41 1 , 17I NI to ! i' ' ~I IIII~I~I ~~I~,II~I II~I O eD! p' N M1M 1 MI 0 1 N 7 0 70 01 i MI OI 101 M N O MIM ^I I I ' OI I ~ M u a~i co;v; i l rn ILn Itol r IIII N. YO m 7 1 co O N101 Cpl INI IO O 7101 OIN!O O 10i Ito' COc0 N t0 O' O OI MO O NIMI tD cO'O O IW• co, e- N 0' C4! CO•M M 0 ' O7 t0 NIO MI ct ' 10) M~ c ' OO h' } O o Q I q i '407 cq cc M M M) I7 itOO ItO O IVI(`aO71M n• N•'OIO Oi IMI j N n 0I CO IOD I INI IN INI 7 1 1 I ~I I Z` co co ~0R.r1 I0 CD ~N~^ 0 01 0 :n OI O'O Oi IA M M' M1V'I n,Ni Ib 10 ''p1 ICI 1 III o ~ ' r_ - • M tDlO 4) ri 'r EMI I .e-1 N' 'tp'7I ° LO (001 INI ,II IIIIII 11 IIII ~ I III m W nl ^ Of OI IN Wf 101 IpI O OiOI O e- ICI i~ Iv, ' ' : 'v IoIMI la°I Irn °on°7 ~1 v o ° ' 0 vl m c o o! P 7 ~I MI Icai VIN! tOI Ofl CO MI IOIO OI 1t01 tpI co 7: O I- l i Iv I 17 MI IOf O f f _ I I • i i! I I I l r l l 1 I I 1 1 1 1 1 1 d E O' ICI 'Cp Ic01 171 Ito! OI i, 0 I i `-a0' 'cD'71 IN' o cOl ' ' 1 'ONf , j INI I 'O t0' 1 ~I4jl IpI IMI ICI ICDi IMI ' ' I 1 Ir pl t0 t0 M OI ,M I Q a 'O. IO aO~P, IC 0) Ia , ilp gal OM n~ ~oi I 1 .N 'a IO I'I •Ni ii ~I~ ' I N O1 NI O 1 I ~ i 101 OI ^ N tn. 711 I 7I 1 I tol I Iccl7 tD1 1 la I I I I I I V ~ C I 1~ 1 I i I I I I I I I I I I 1 j I I I0 ! I~iNI ~I~I^IMI NI ' ' ' ' e- 1~•NO L IpI CO !N O 101 ' ~~I tp0 1 i M 00I(q ' 'I MI 10 NI S ; d I ip 7 ~ti 7 7 N INI Ic0 7 ao M p 010 Iii COI ,7 Ip q M tnI ) N I I i I I I I I i ~ I V I I I CI 11 j I I I ~ ~ n 1 I I ' OI ' ' :h IOI IM I io7l Irk 'NI'^' I NI~ O I!~I N toI ~ I ~ 7 e tol ' ~ i d' 171 rn Q ^ c'I 1 ^I I°° 11C~o 0 jo77 mo O m Itol Im I ~ I I I I I ! I I ICI I 1 1 1 I I I I I I 7 O i i , ! I N IC00 n NI 101 O O C MIOI c^o tV101 ' e- ' ' ' ' pMji p I M to 1 cO C M I C II aND I VIII I N co Cl) l l ~ I I - I 1 I I I I I I I ~ I I o ~ 1 I LL ID N m I I m 41 ( N I i I l a 1 N > I c l i 2 ID l 01 ~ l t; > U 010 m m W V x' v I~ o 0 a j d U- N LL c m o m = a i a t w e d Nh T gm I w 3 m a c Al a t I m v a > m ~ c ml °>'j U. o m _ rnl-`0 c °-n tal ~ ol 0 o ~ ~I m I o a aUc ~+a) y to c m a3 m o t U z c E o c , LL LL MI m U m e > v c > u n) to c~ W t~ c L c L. O m I e to .O. m v) ° ) C a m m of O c C C Lo 0 O. y, a y R c n y Z LL F e E O N m Z m t m I I > m ~ 3 I ` 6 O c) O t ° ~ R 1 - «I y I m a ) Z V C oI p m yltnl m ~ c m O c) m C m m O C y w F L- tnl Ox U m > S F a ILL2 (0 Uo L ~I c c C7 ~ ~ Q ~ m c 1 L O I I OI I~ O Ln ~I DS~ Fm` Z z ~ Deschutes County - Fair and Expo Center YTD-Budget Basis Statement of Financial Operating Data Seven Months Ended January 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 75,000 $ 42,232 $ (32,768) 100% 56% $ 75,000 $ 42,232 $ (32,768) Receipts: Security & Traffic Reimb 12,000 - (12,000) 58% 0% 12,000 - (12,000) Miscellaneous 2,004 3,867 1,863 58% 97% 4,000 5,863 1,863 Vending Machines 1,150 525 (625) 58% 23% 2,300 1,675 (625) Telephone Fees - Events 600 - (600) 58% 0% 1,200 600 (600) Special Events Revenues 256,700 155,977 (100,723) 58% 29% 540,000 382,557 (157,443) Interest 1,164 (23) (1,187) 58% -1% 2,000 812 (1,188) Storage 32,000 12,385 (19,615) 58% 21% 58,000 44,000 (14,000) Camping at F & E 2,000 - (2,000) 58% 0% 7,000 5,015 (1,985) Horse Stall Rental - 1,185 1,185 58% 3% 45,000 46,170 1,170 Concession % - Food 102,000 39,282 (62,718) 58% 17% 235,000 110,000 (125,000) Rights (Signage, etc.) 16,420 38,000 21,580 58% 44% 86,420 108,000 21,580 Donations - 3,300 3,300 58% n/a - 3,300 3,300 Interfund Contract - - - 58% 0% 45,000 45,000 - Total Receipts 426,038 254,498 (171,540) 58% 25% 1,037,920 752,992 (284,928) Transfers In General Fund 99,000 98,960 (40) 58% 50% 197,919 197,919 - Transient Room Tax 11,383 11,382 (1) 58% 50% 22,765 22,765 - Welcome Center 80,000 80,000 - 58% 100% 80,000 80,000 - County Fair (619) 197,421 80,000 (117,421) 58% 41% a) 197,421 85,118 (112,303) F & E Reserve (617) - - - 58% n/a c) - 243,243 243,243 Total Transfers In 387,804 270,342 (117,462) 498,105 629,045 130,940 TOTAL RESOURCES 888,842 567,072 (321,770) 58% 35% 1,611,025 1,424,269 (186,756) REQUIREMENTS: Exp. Expenditures: Personal Services 481,068 448,307 32,761 58% 54% 824,769 791,960 32,809 Materials and Services 309,939 268,525 41,414 58% 51% b) 531,604 516,120 15,484 Debt Service 79,393 73,035 6,358 58% 63% 116,188 116,188 - Capital Outlay - - - 58% 0% 100 - 100 Transfer to Reserve Fund (617) - - - 58% 0% c) 16,412 - 16,412 Contingency - - - 58% n/a 121,952 - 121,952 TOTAL REQUIREMENTS 870,400 789,868 80,532 58% 49% 1,611,025 1,424,268 186,757 NET (Resources - Requirements) 18,442 (222,796) (241,238) - 0 0 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 6,650 Prior Months 3,948 Total Accounts Receivable 10,598 Deposits Received for Future Events: 2010: February 8,567 March 8,610 April 5,875 May 4,440 June 1,000 FY 2011 40,950 FY 2012 & beyond 5,550 TOTAL 74,992 00 LO d' 0 c 7 LL O U ~ O • O N O=a.M U :a Co U) CL a) M c D U U U U O O CL O a) c O M N O r- 1` Co C co r= o a0 co 0 S oo o r. `d 00 M 00 It ~ CO M N ~t O O ct N CO Cn 0) CO O ' T- 00 ' ti m N N CO O Cfl It M (D Lo -47 06- CNT C) N 'IT CY) 1-: c d_ It N I` CO CO d (D MC) t - (D C) C) CO cY 00 Nt O ti r-Or N V) M 0 00 ~T O I- C 0) M 00 0 0 00 00 CCr OOO) ttt OOM~00LOr`MN M O CoO Co LO M O o LO Cl M~~~M n~~ 0 ° ° F - mt M 0 0 0co It rl V- N A M LO r 00 N ~ N M 1,- CO CO CC ct L 00 0 00 CO 0It 00 0 00 N N O O 00 0 M LA C) r- 00 C) C.0 M M O O 0 C) 0 0 LO I' O M ' O LC' ' N O M M O ' O O O (fl z OLn C r r- 0) O O O 7 LLD It OH co LA ~ M O 00 O O M E m CV c M CD r- r` M 00 tCi LLB L6 CO O r-0) r~ '9T NMCN Tc COCf) 0 00 d [t N LO "t 00 M N 00 M 0 O co Nt O r- CO M O 00 00 M IT a) N ~ M d' Iq It O C) 'It M c 00 r 1- M N Ln O O U') 00 , ( 4 't 0) C•i Cp Lri Lfi 00 "Zi CO Ct) 1-: O (5 e- N p 0 u) O t0 cM - N r` 00 co 00 CO O W N M LO ti N N O M G0 CO d' I~i L<7 T U) U a) U co E M E c U L co r- M 1 P- -0 G 00 q c 0 ~ l C 0 a CJ M x Co Cc W l1~ Lo co C0 r r M' ' i ' i i i i i i M r` f` O O O CO V) LO C 0p 00 N N N N N M N CO N d c CO CO r O M 00 00 r CO O 00 M LO O co 'IT O~ CO M O CO 0 0 ti r O O Itt M CO r r- M N co M LO co (d V L6 06 d CO 1 <6 d r- N 1 N to N N It ~t r d , N N er C~ i~ O U a) U c N U) d o 7 U V > 4- C) O z a) N m R 0) C)) N U > N) 3 E j U °d IL R C ) O N W Z3 > ) . o p C V U 7 N N 7 c od U) U O) U O N U a) ' U p C u j cc d 4-- E a C: n o d C a) m o.S c P ~ c d cu rn p n N _ ° ~0: z.c C: W c ` t 0 o N ` H Q) a) 0 x W w 0 a X M<W~a 5 a i- 5LL¢ . w a.w0 a Uz0 c h - ~0 o d w co cF z O Lo C/) 'a z c W LL N N L O M Co .a z Q c m U L U W c 00Z q O O LL u2F- cn 0 N W 0 co co Ul) LO co i m U') O - 00 t n M U N Cl M '1, N O) O Z M ~ LO co N co aO 0) C \f ' O G ~ co ~ O Cfl C: N M e CO M 't 00 C ) 04 LO =3 t d co E Q C= a) co O U-) O co to O to co ti N rn O N N~ U) N N 0 d•r- 00 ~0 tiNO Cfl CO co U') co O E c MO O co N O O~ O M m f- O m O m 1- - =3 O M M CM Ni CO - 1-: N C \F d• d c In CO CONNMCO CO 00 00 m ~ r 0 N N 0 co 0 Q V q U M O _ O O O M N N 00 to f~ O O 06 c o O co LO 0 O O c CF) ~09 - 69OO o O ti U) b 00 O O O C 0 O d U) N O O o O° fn O to N O CL ^ C6 0 O CO o~ N E ~ &J, Co O 0 = r CO O F= Z> J 0 y* EA 0 a O ~ O C O N O N O U) ? CO j c CO o O N a) 0 61) \ Ef3 o t CT CD C: C I C V 0 U) O X 0 CD 0 O 0 0 U, o w, a~ L U O O- o co ~ U N N~ Cn o U O O co _ ~ to m C` a co 0 O Co w O C 0 C od ' 5 0 0) a: O : - C O)m c c U m c C1 O X U cu L 00 _ C U U~ -L- v~ W c m f m O a - U U U+ M N U N a c 0) <<<D2LiD Fa E 3 E 5)N L ~-NM LnCO I-0 tt~tt 0 i- O a oU E c ~ E ui 0 U c 0 06 c 0 (n a) 0 L A~ L 0 L t+ Cn c 0 0 U a N c` N > cn (n U U O U L. U) E CD W a Q :E o w m c W Q Q O W UU o c~ o ca 0 F- 0 a F- W t- cU 5 O C C6 O O N C 7 v T ~ O O Y 2 N 7 a M 0 - ca O CO 7 ~ N N U a. t (D C 0) ~ O O N 2 a) ~ U a) O tl 0- .Q to U rn W V O co W w cD to f co CO CO co ~ 'MOO C - O [t O to r 01 M M v N V v r-Z 0 L ~d M 0) O 1 0 m M N ~ O O 01 CDM0000 t~NMOM C)mw01- o m w 0 d'MOIt CDOOtl_ 000LOM000 qt 00 NOO 000 V OOON 01 h It t~IT0000 0 't't0 - e-~0 T 000 (0 It 0 0000 O O M CA CO tO h LO O) N CD IT tl - M N O CD LO N C \f 1- [r r O 11 m c vi CO to CD Ln M t: O1 N 00 ct CO N to CA I,- - O O M N N M N ct 0 N CD ~ IV co 0) 0) M N Cp N r to c)co CAON ONco Oco OO Ot` CD 0) 000 00 OOto 00 OOCO f` t-- OOOtl- OOOr- N co 0 Itco ON Oct ' 0~ ' 00 0000 LO ' 00CD to N ' 00fC6 t6 M to CA N 0 V t`e- NO CO LO N O~ ~-ON tO to q:r I:i Cn LdCOuiO M N Ct O M d' N 00 It co N LO (N CD U') co C7 N CO M r tO CO CO CO r It N (0 O 0) 'I Cl) 00 It CO c- CO It ct Cl e- t~ ' tO N 0 M U') O CD LO M Ct e- N N IV co tz ' r- 0) CO V d CA t- c- r LO V LO N CO CO 00 O M ti O LO to O t- M to rl- N r 1 f N ' M M O O CV M N 01 0 ) M O N O N O co T- t` C7 M N N N i ti ( I,- ( M Cl) O 0 O 0 1 1 1 1 i i 1 1 C O M i ce) ) 0 1 0 M M 06 0 06 ~ C%i C%i V r ~ LO r Ln r (D CO r CO N t0 O rn 't M 00 "t 0 ~ rn I- ~ N t*- N CO CO LO O CO LO 0 V' co ~ 0 I`- ' i T- 01 ci d: qt 0 r.- r r to 'IT r to ' o co M co O c1l) ~ O M I- co L N 1 N to to t: M CV M N A CO M co fl, co t` m O e- N crl) M r N cn N O U U) O O O 7 N cu t` =7 a) X U U LL U) O ci 06 ~ N O a) N N N U) E m 0 w c to cn > ' U) a) ca m N c :3 w► ) (D c c to -0 [2 3 C 20 a 3 a i a. (n ~ w ~o S2 C- Y a. L U) LL & 0 > o X E cm a) 2 -0 2 3: CL M C O U U) F" °rS .C 0) 1 O U a) ' C U) CD E 6 L O M a) a) O V C d Ul OZ a/ U a) O, m m (M C C y C CL cm '0 ° O te O O U U d ~ CL x m a3 in W Z cn t C C C 2 U) a ) r-= 0 o o ° - t LU N c a) C 2 r W i CT in O a 0 i C CO « E 0 O N> C U L C O N a) 0 'C I- 3 cn <n O C 0 E E v 0 O 7 O F- CO O O O <LU C X CLLQIZW O~ UZOO ULLI- 0 (D a3 LL F-5t- ~ LL ~ Z CO O V ~ O N 7 _ 3 LL M O U U to CU CU 7 ~ O C CL CU U CU Z CL z O O U ` L r 0) W U O N w w O ~ O CO V M ~t CO O O O00 N 00 M O O LO C) C) fM LO e n Iq It - ' CO O 'IT O U) T" C1 cli M C6 N v d i v . LO 0) O M CY) m M N r- r vv O ~ O) 0) CO N O I- co O 1 co M O M CO O I-- [t M C) 't co O O O o0 O 00 U) O O U') co O r~ CO It O O N O O H N r O) ~ IT 1N0 1 0 O`;t VOr-7~Od•-0 0 CO V 0 0 O 0) M N LO CO r I- r M N O N rqt LO N O qlT Ch I-_ CO Il_ ' V- CA N O ~ N O O M N N d LO 0 0 0) 0) M M N N C O N O O co O N Co O 00 O Co O O O O1 O 00 O O O LO 00 n f- n II- N Co 0N0 N Opt ' O- ' 00 ' ' O CO LO ' U7 N ' Cfl 00 LO NN LO ~ a) ~ 0) Ono NO N CO) LO LO O) M M M M M CD co d NCO OOctM00'I (0 (0 d qt O r n 17 ' N Lf) N00-M LOO Co L000"T N N v co - . O Cfl V N M n LO d' ~ LO N CO CO co O 00 ~ ~ rl- ~ d Ld N cei O O N M C\l M O N N CO M Ch N N C n ti n M M r r O 0 O CO a i I i i I i i CO M M 0 ! m vr M -Itf M 06 C0 C6 CO C% O O It_ LO LO CO CO r CO N CO O O qt Cl) 00 '4t CO ~ W O n NT N I,- NOO - Ce) LO OCo LO 00CT c) r O n 0) C r V ql:3j 0) f- ~ c LO [f ~ LO In M M co O M 1~ Lf) V O Ln I*_ M Lc N r d O N Lr Ln n M N M N O M co n co n 01 O r N C) M r N N N O U N N C (Q y ~ O _ N U U z N a U) 3 O . Q) U) a) L 4) O O) off 7 N c0 V) Lu ca cu U) > CO 3 N c a) U E O U (p HAYS O . ~ fn 0),a Cn O O_ m c- E U C O) O V N V - U Im 42 CM.G C: a CL 0) (D 0) 0 CL >1 N O t m vi CU : 6(D 0 i L 1) U o i W C: W 0) N a) CD f L '01 r- 0) s 3 u) v~ o i W~¢w~a ~Su.¢aw0 UzOo 0 m mi z U 0) 00 It L r- r- C) C) LO Lc) M ce) co C) 7 1- M CD V O 00 cu cu 0 CO M O LO CA C 00 d r Cn r co (N O Cn CL M cq Lc) N 00 cl: ' • C: r- CO C14 , In Ce) CD 06 1 O O N N C 4 d) E Q C . 00 O r- O 00 O O O In O 00 LO M O CO M O O Cl) 0) r O O M a7 00 r V C 00 O O CD Cl) 0) M M It 0) O LO CD LO LO -L' O E 0 N r , v) 0) O LO 1- CO 1-: N- 1- N CO CD 00 00 lA f- M E N N O r CD M I- O Q N N N U M (n CD Z CD O CD UJ L M N 00 O c! fi3 O O 00 O N 7 -C ~ o O r- U M M Lfi M O U C _ O a) z CU O Q D 00 0 4-- O C O a W Q Cn N 0) 0o o d N to N 0- C6 CD ce) (3) ' GF3. EL Z 0 U o N O D r C O co v ~ E a) = cD C7 O O O o L 00 ~ . (03, O U) N N 0) Z) O 75 N 609- O c ~ U Cl) O U cn X o N - cc c p Cl) • o .0 t5 a~ - w ° a o " co ° ca 0 t o a) O c 'D 0 U 0 c: o° N U c ca w o U O U w U Y L o r ~E o N a C: 0) < L u c a dZ c c E 3 cu -a -O a) E O c E - E vi O 06 O N U U O c O U) C C 0) to U) N ` E O U 7 a N > U U = N O fn N E ` ~ O C_ U O FJJ L C~ w Q Q Fa E C a) U C W O o o c `E O U U F - J J 2 0_ i- W Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% a) $ (2,666,469) $ (2,689,172) $ (22,703) Revenues Grants - Private 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) Total Revenues 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) TOTAL RESOURCES 100,000 (2,689,172) (2,789,172) 42% -2689% 100,000 (2,689,172) (2,789,172) REQUIREMENTS: Exp. Expenditures Debt Service (Negative Int Rev) 100,000 22,134 77,866 42% 22% b) 100,000 35,000 65,000 TOTAL REQUIREMENTS 100,000 22,134 77,866 42% 22% 100,000 35,000 65,000 NET (Resources - Requirements) - (2,711,305) (2,711,305) - (2,724,172) (2,724,172) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) January interest expense was $2,455.12. Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2010 Jul Aug Sep Oct Nov Dec Jan YTD Total Tammy Baney Conf/Sera & Educ/Training - - - 350 - - - 350 Travel Meals - - - 15 20 125 Accommodations j - - - 595 ! - j - - 595 Airfare - ~ I Mileage reimbursement - 256 86 5731 299 1 396 66 1,676 Ground Transport/Parking - - - 45 ' - I - I - i 45 Total Baney - 256 86 1,578 ; 319 1 486 66 2,791 Dennis Luke Conf/Sera & Educ/Training - - - 350 - 1 220 57 0 Travel Meals - j 25 - 25 113 - r 25 _ _ 189 Accommodations - 77 - 452 116 77 - 721 Airfare Mileage reimbursement - 329 85 257 485 210 - 1,367 Ground Transport/Parking - - - 34 - - - 34 Total Luke - ! 432 85 1,118 714 507 , - 2,881 Alan Unger Conf/Sera & Educ/Training - - - 350 i - - - 350 Travel Meals - - - - - - 50 50 Accommodations - - - 624 - 651 - 1,276 Airfare Mileage reimbursement 978 _ 978 Ground Transport/Parking - - - 56 ! - - - 56 Total Unger 1,630 50 j 2,711 Total - BOCC Department Conf/Sera & Educ/Training j - - - 700 - j 220 - 1,270 Travel Meals - 25 - 40 133 1 90 76 j 364 Accommodations - 77 1,046 116 77 ! - ! 2,592 Airfare - - - - - - - - Mileage Reimbursement 585 172 831 784 606 66 4,022 Ground Transport - - - 79 - - - ~ 135 Total - BOCC Department ! - 687 172 2,696 1 1,034 1 993 j 142 8,383 FY 2010 Budget j 22,750 I Percent Expended 36.8% I I I I 2/22/2010