The URL can be used to link to this page

Home My WebLink About2009-09-02 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 WEDNESDAY, SEPTEMBER 2, 2009 Present were Commissioners Dennis R. Luke and Tammy Baney; Commissioner Alan Unger was out of the office. Also present were Dave Kanner, County Administrator,- Erik Kropp, Deputy County Administrator; and, at various times, Tom Anderson, Nick Lelack, Anthony Raguine and Kevin Harrison, Community Development; Marty Wynne, Finance; Anna Johnson, Communications; Steve Grin, Mark Pilliod, Laurie Craghead and Christopher Bell, Legal Counsel; Sheriff Larry Blanton, Sue Brewster and Capt. Tim Edwards, Sheriff's Office; and one other citizen. No representatives of the media were in attendance. The meeting originally began at 1:00 p.m., with two executive sessions taking place during this time. The agenda items were not discussed in order. 1. Executive Session, under ORS 192(660)(2)(h), Litigation. After executive session ended at 2:20 p.m., the following motion was made. LLTKE: Authorize Legal Counsel to proceed with mediation and package an appropriate settlement with the claimant with a dollar figure no greater than the dollar figure discussed in executive session. LINGER: Second. VOTE: LUKE: Yes. UNGER: Yes. BANEY: Chair votes yes. 2. Tax/Finance Update. Marty Wynne gave the investment report, which notes that the LGIP has dropped to 0.8. The Barik of the Cascades has gotten some (negative) attention lately from the FDIC. Minutes of Board of Commissioners' Work Session Wednesday, September 2, 2009 Page 1 of 4 Pages Mr. Wynne presented a year-end report and a current year report. Regarding year-end, the general fund shows that the actual net reflects a positive variance. Mental Health's financials are off some. Current year shows County revenue is up a little. Community Development's numbers, however, are down even more. He presented a graph showing activity at Community Development. Revenue is down significantly from last year. Revenue was $3.9 million in 2008-09, but the budget was $4.2 million. Bottom line, what he sees for July and August 2009 is not good. Commissioner Baney said that she feels that the City will recover more quickly than the County. Mr. Kanner said that some commercial building projects are occurring within the City, but there is not much activity in the housing sector. Regarding the Annual Fair, revenue was down significantly and the fund will be short about $114,000. Commissioner Luke asked about the amount left in the fund for work on the next Fair. Mr. Wynne replied that they have a budget for this but adjustments will have to be made. 3. Review of Request to Modify Bond for Tetherow Destination Resort (Arrowood). Laurie Craghead said that the overnight lodging improvement agreement has been amended before, determining the date of final approval, and there was a change regarding moving the lodging around. They are allowed to ask for three one-year extensions if it is in the public interest to do so. They have asked for the first extension. During this process, they asked also about the possibility of changing the type of security from a bond to a letter of credit from Wells Fargo. There are positives and negatives to doing this, but staff recommends the switch be allowed. This will come before the Board on September 9. Commissioner Luke asked why a letter of credit is better than a bond. Ms. Craghead replied that banks generally do not fight the obligee when the obligee has a letter of credit. However, security companies will try everything they can to get out of providing the funds. Wells Fargo is in a much better financial situation that Westchester, who has the bonds. The funds are much more likely to actually be there. Minutes of Board of Commissioners' Work Session Wednesday, September 2, 2009 Page 2 of 4 Pages Commissioner Luke asked if any units have been built over the past year. Anthony Raguine said none so far, but they have to comply with the 2:1 ratio. Don Bauhofer of Arrowood said that six or seven homes have been built or are under construction. Ms. Craghead said that the ratio is based on lots, not houses. They are not out of compliance. Commissioner Luke said the County has been criticized for allowing extensions. This is one reason there were bills in the legislature looking at destination resorts. He would like to see some kind of plan. He realizes that the economic conditions are a big problem right now, but would like to see some kind of plan for when things start turning around. Commissioner Baney stated that Pronghorn was granted a five-year extension, and this is the first extension, which is allowed per the agreement. 4. Discussion of Draft Update to Communications Policy #GA -3. Mr. Kanner said the only change being proposed is on page 4, relating to an issue that is getting a lot of attention. Social networking is a relatively new situation, but care must be taken to provide guidelines about what can be discussed. This will be addressed at the Wednesday, September 9 work session. 5. Update Commissioners' Meetings and Schedules. None were discussed 6. Other Items. Commissioner Baney said that she and Dave Kanner met with representatives of Rocky Mountain products, who want to borrow funds for a new building. They are seeking $2.2 million to expand their building for a new product line. There are funds available at the State level, so that is the direction they will go. The County does not have the funds to do this, and Mr. Kanner was not comfortable with what little information was shared with him. Minutes of Board of Commissioners' Work Session Wednesday, September 2, 2009 Page 3 of 4 Pages 7. Executive Session, under ORS 192(660)(2)(h), Litigation. The group went into an additional executive session at 2:25 p.m. No action was taken and the session adjourned at 3:20 p.m. Being no further items addressed, the meeting adjourned at 3:55 p. m. DATED this 2' Day of September 2009 for the Deschutes County Board of Commissioners. ATTEST: bnio.uL,f es. Recording Secretary Tammy Baney, Chair Dennis R. Luke, Vice Chair a..,6„.„. amp_ Alan Unger, Commissioner Minutes of Board of Commissioners' Work Session Wednesday, September 2, 2009 Page 4 of 4 Pages ‘51 - 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:00 P.M., WEDNESDAY, SEPTEMBER 2, 2009 PLEASE NOTE EARLIER TIME! 1. Executive Session, under ORS 192(660)(2)(h), Litigation — Mark Pilliod 2. Tax/Finance Update — Marty Wynne 3. Review of Request to Modify Bond for Tetherow Destination Resort — Laurie Craghead, Anthony Raguine 4. Discussion of Draft Update to Communications Policy #GA -3 — Erik Kropp 5. Update Commissioners' Meetings and Schedules 6. Other Items 7. Executive Session, under ORS 192(660)(2)(h), Litigation — Steve Grin PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), pending or threatened litigation; or ORS 192.660(2) (b), personnel issues Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regardinga 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. Wed., Sept. 2, 2009 aJ L(0 • E v 0 LJI Work Session L • C • V Q) 130 J Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA September 2, 2009 (1) Monthly Investment Report (2) FY 08-09 Year End Financials (3) July 2009 Financials (4) Dog Licensing Data and Graphs eschutes Count atal Investme t " •. Investment Income Fiscal Year 2009-10 Jul -09 Y -T -D CO a0 11) CO CO 64 Total Investment Income 181,865 181,865 Less Fee: 5% of Invest. Income (9,093) (9,093) Investment Income - Net $ 172,772 $ 172,772 Investments By County Function General $ 115,859,291 Total Investments $ 115,859,291 N ai 0) c 0 L 0 0. -0 0 i' O 2 1 O .` O. s 0 2 c d U N 0 4- ca 0. E 0 U o Q O OOD O O O Average Maturity in Days 03 N 0 a 0 0 0 a a O O to N lA O 0 O O h N N N e- e- 1 f!1 (n E 0 = C EN co d co o c 0 2 3 a) 0 to or ZN m Q m 0 mF-d a`).Y a -o c 0 � ii m Time Certificates a) n (o CI_ a) O TraZ o m E o E o. 00 l Total Portfolio: By Investment Types U m a CJ J aI j 1 10) ,' �01olo olojI U 2 O UI'U'U UI,UIU UIU O U!U O O .-).i .-).1 O UIUIU O U.0 UIU O UIU U U O SIN �iF) zl o 'z z',21ziz1133 z z'z,zlz 3!2 z',z�lz'z zz,zlz z!zz, ,CZ!.z ZZ'�ilz!Z11z Z,Z '-1 0: VIII .. 0ICn�''n ICO: !r 1'-. �CV a10 I. L-101 a C')l'i. QINI0'ICn 01coI0 0' 1O o of o 0 0, co, 0 Cn �I '0D 0 COIODIS COIN CDI00 N Ch 461.10 CD O,� V'IC'n10D Cn N.0 CO 10�'1010!N10 O 0,IO 0101. 0 o c' o o, 1 0D' O O 0D' O'; ri O O O to 01 to I N I O CO CO Cp 1 CO, O CO;N 1 C0r O 100 O Ls" I to O' O r I • O 1 001 COI'' 0DI 1.r CO' CO O O:0I0)I0 7! S ' N N! OI n1 n1 to, 10'; 0l co co co 010 co'to� C..0 Di r-1 OI A u0i O m 1 O fh tD 0 N 0 0 N I CD CO l CO N . to 00 CO CO W. 1. 00 CO' 1n O , CD 14....1 l0I N CO. ! 0 0 0 1. , 0: CO CO 0 N O O COI CO''1010)1 uj pl C')I N 0) N 0 O 0I C') O ' 0 O C') NI CO OC') Oil C') 0 0 0 O 0 N N a O)j C'') pp="a0 O'0D' N t0I 0' O O OI OI' O c' OIN(')IO (D. N12 0g' QQ M O C') C') 10.0 I.IO 0Ir1CD I co 0 r Y) O', j .- O 01 N 0'-00 o' 01 01 0 I .- I O O 0 O I O O! O' C/) CO (n CO 1 N tV N N CO N N ��N N N N ' N' N' 1 N'a- N N N'I '-'N.N N N N N'NII tD N t0 1 1 ^ OI 7 -7 71,tl�� 1-'I 1 _�_ 1 t1 1�I1 �_ --070- ' op 1 01 0 O! "- CO 01 J8.10 1 L-!,0110'0 O l 0 I O 0 CO ' 0 C V O 0 0 0 0' O O; 0 0 ; 01 0 to c') 0 O 01 01 01 CO 1 0' 0 o 81 0' CO I' O O S 0' Ol CO CO o 1. O1 el N'I O S1 01 0 O O 0' C'', O 0 S' of o, O c' r Of I '. 01 0 O. S O O CD O o',— tD tOj O O O O tp VI,O r �� N N O O' 01 0 O N,I O tD N O O O 0 cid c' N O O O O ' tD. 0) a V- 0I N' NI (0 N CO ', f') 10 V. 1. CO N' cD N (0 <O N f0 O C') ^ [0 c0 O tD 2 0 !.01 O v 81 S co' is.tf 0 co! n el CD - r) t7 O1 VV I v '). toll. '- t0. 'dill r) Cn m1 .- v Cn 8 N o - I co col Li,' I Cn CD 000 010) 01 N 1A 01 C`] 0. co 10 : 0.11 N1 Cnl of N tG C7, COI 0)�'- C() N O C=I f� 1 O .'^I Cil N MSI P. N - C'7 CO CO O L- CN I' CO ',,LL 18,2810..`21;e1--816'1.91.2 O C'') N N t7�01 (O O el 211`" N O `,;'18;2'.:F,8 O.N CS (g8'.:7) 0) O S OI OI II C') O r' oI oo OIo1 o O 0.10 ,010100 0 0'o O- o al0 0 0 1 N r)lorn to .21 N '-I N1 NI ' 4')I NI N1 ININ N NII ' N'', N 'I'A'N - N' N N �I NI NI N N 44'4C'4] , 0, N 4') L HI p I 1 r l 1 �'- '01000.OS!OI°,6)-.'`'18'°' NIOoI7 S'0S0SIO 0010°10' 0 008!°018S'00001S-'SIS0 I 00 jo�IOI __ MC') W S0. ellN '1 O Oa1S S1 W' SI 010; ('4 N OI0.1 t(0 010 0100 01010 0.1 elI 0)),<0. 0 SI S,. 00I O 0 0110,1 0 4 0 I� I'1 r 4') O't1"), 0151 S'0 O M' 0,N 0 Oj O! N 0),010 N!O1 tD A o,O10S' 0100 0,0010' 0000 0,010,0000oo'-000So N0 O to 13 1N L-! Ni!! (VI C'), NI (V 1, ' IN NIN NI 'I N1 ' N :,11: ' N N' N� NI - N NI M N CViICV1 CV I m N 4 1 1- I 1 1- ; 1 It , 1 I F 1• T ▪ J IOC ! a° 1 a 1 a° 1 a° a I a° Ia a°, a a°, a°t a ;,;°' a°� e a° o a° I �e o ait l o o , a a° a°1 a g°1 a°, a° } a°1 o o a°! a°tom I } ae ae ae ae l 1.01 O to tn1• O O O :13,g o O' O.' O 4')1 8.8; O O 0' 0 O 01, 0 01 4011 O O o to. 011 0 O, o' o_o CO p O C) 'tn O 10110! 0. O, O C) 0 101 ' O O 0 01 0 0). c0' 0 0,'; O p N- SI N O 0' ' 10 Cn 10 0 OI O 0i 11) 11) , 0 N I(V OI' O O 1N r N!N1 O 1n CO'1C) 1� CD110'O V'_m!O )11.1C0 u) i0 O N OIL -10 NIP-. N11.; O!O O!f�I N W o1CO • t CO'N tV 1 fn t')' a N fn fn f')! fn N t') CV N N c- N N f') a'- fn fn `- N N N IV N o N I to I j- 1 Q. a°t a° a°1 a° 1 a°, a° a° a a° a` a° a° 1 a° a° I 0 a°r a° 0 o 0 O 0 tc) O ' COI 0 Si'?"O, 01 ,;812,R`4.)(1&) o 0 O §;0L o N O1 NI 101 n I u), I O.O�u) S,S' !O OOoi OI' I CD 101 •- N 1 C7 I N, O f. Of N uI Cn N' fn t0 C0'. 1 r O O Of� 1 -4,' to 0),! IO 10;M v' ! Ir)I�-,'4') �1NININ.L!!".. II ' 1 1 Market Value I O U 0) m C 0 co m A � C c. o 0' A o C U, 01 , 0 I I N o 'E Ic Er t0 N1 !NNI I I mo° Idi U I a w ''�1 oI 1i 1_ E _ o O c0 __1 -_. C 1.1 O u.. 0D (0 O co'O O 00 40 O O 0 -} ?..a, CV~` •' 14 - Z1 go Cn CO 144...: CO OI LI CO 4.44 -.-000 CO.N CD N C`) 1. C`) m.,; J n - fn 10Y �O N4O C•—�21n�� r;nT E '► y) 10 4-7 ep Cp+ e{ 7 T 1 ae{ CO I LT 1 ppp 2H I 01 Q I S S 4') C`) C`) 11. o 0ND ' Cn tD ^ N' 7 � 0 3 j 10 ' I CO 10) 10 0I 10, a O 10 E �+ T IOO O.00 OOO OIO O+O OO, OH▪ O 0O,O O,O 00010�0000-, j-, I -_- -I I' > o ' 11 m 1 0 0 o, o o 0 0 o Q O Q Q1 �I 0 C7 . fn `-'31-1 n I r ^, 0 Q n' O UI r -I- u) iO r ININ -ed. r .`- Cj) COI O 41.: O t,I p) !. i 7.1. -, Ai 0)1 A _ 7, ' O •-I Q.. � -I N N O OI � Q - N, O OI OI N Q,17.1.-7. Q, -H Q,-..1-,,-,..,0, O O O, N F0 , 1 �' O R'S I O O 1 O) O 01 (VIN N I j fn I M' r f.1 n cD COO � �O O (V C'7 Ch CO > o I 1 E� le; o- o'oI0 0 0 0 I. -i. of o: 0ISIS Oi0 O o 0IOIO'-1 10,01010 0l0!010� Q o o 1 1_- I I 1 ! t 1 �- 1 1 j 1 F- J CO y) 'I CO I W 03'N-103103 0 COCO 01'03103 CO CO O O c01 O O 1 O I Cr) Cl) N' O O O I 0) 0 O 1 O O O j O 04 0 O o 0010o Q 0 0 01Q)01010.0 0 00,0IQI010 OlQ.000 o Q Q 001Q'010 Io Q 010,0 L H 11n 1' 0V i (O _' O a I N CO ua1� Ch � CO fV ,---„(c.--;,, O t0, QV 1. _' iO f'� 1 O I 1n to 0, O O r CA _ a 1 j E1 0 O �_ �i NN N O NQ O N O'OI OIO N N '- N 10 QUO O O NII ! ! 1 D N N N CO CV O tD �O N N _N; N ca--'' ' CV Cn m 7 1 m u) CO' 1. a s C7 fh �' a $1 01 �1o 810101 o,�f i l I t- } Q ILL1m1� m�zl>im 0. LLlalalzl¢!cl 1 <I 0, 0 o z111� �Ic,LLIa z-��o,0 0 0'0 010i oiLL'LL1 o O o -HALL' I ll t 1 1, j ial�1rnrnF �3tm� . 010, o0 0 o O oIO;O O O O 8- i 7 W Z. < Z, I0, ZI 010 Z 0110 0 Q Z 101.0 0 i • I. Z < 4 0 1.- __ }- j < -LLII 1__ t- t- i. _ -_t A. L_ tt .1 < °•s ca ce!uzi!ca LI; ceI> n1�1cal-JID!�1m �1a 0 mlm,mlDI031-1 103 m'�TCL,5,(0131CL1CL!�I01co ml aluiizn,1 _._ ,1_112;;;144) o '1 1 ,D, N 4') 0) ��N ml�I '-- • ') -Jt-� I- —1 1 1 r i 1 1 li. 1m N, n Cn rn u) Cn m 1n ! 1 1 , x �I J o a r DI m J O 10 U' 0 110 �I1011244.'11 1 'cVI- 110 014- 4 o Q Q co _ 'WILL N X f. XXfn 1 X XIX X N W1 X u O;oI X 1 1 1. 1 0D 00 1 00 j Cn I I N I Cn Cn A C')' c0 C')1 C ) cn Cn a0 O O O t0 'm ; 'fl '_ (0 Cn!!'°.'34)1� , G I r) I sn Q � 1 cm.' r) r) I t� � � 1 r) � r) I N l I ! ,=, O n ro i. �n n o)' cn1 i< ) M 010 r) in r) n r' 01 01� 1 Jr 11: d 1 1JI1 j 1 i t " 1 , I• m 5U,,VIU U 'C UI, 1'cp'pI�'p' �allb1m! O Z' 10ZI j i I s-01 1 ! I z1m U IpU z1 -?_•,(S, 8I 'IUI 8Ip1 ' IUU1 I UKliil-l„mIm @'1,3,862761'11,111 ma!mov6aCeZ1� mI0I 1. 0Z'I p 000 0-0IUp!°m oLL�UlUi��Y cl 8. 21j0 0.0cj-1N O Y o:;!-:1(galo.„,Gizi,708;.: ,::E II8t m G 8I 0tiI 8I ' 001 'I U1U 1 tifU. 1j .,ppIm' I 1 � w m a��H2 Ea1 - _IcH.4-11 l�iII'�mI iwl ! m 07yiTEU t I1U I10l1m o(3I� f3mcg'Iu Ct. i , �I�-'D -d IId { �rE>-m LLOj¢ISI-C¢(1 EI�QQ�- Nm : c cala3 NI ', ,, nY YIMmmm0 712of w I Y . Y21CIECmmy .7NaI �„I ,CI CICI C UC 'C'U.+E' 22MJ1 (fC hi1- 1 + 4 I L Ia^i-L w Im' Hc I(R�IZLQ200o1c7m,o. a.1u_uF-o'00m,mml0)m COa0mu'LLLLu_IU,LLjUILLILLiu,uIu.. J Im , I 1 w I I I I 1 1 181 , 0 O GENERAL FUND Statement of Financial Operating Data Year Ended June 30, 2009 ("Final" as of 812612009) Year to Date Budget Actual Variance Coll. RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,461,433 $ 411,433 107% Revenues Property Taxes 19,417,900 19,754,489 336,589 102% Gen. Rev. - excl. Taxes 2,627,789 2,729,348 101,559 104% Assessor 861,290 959,191 97,901 111% County Clerk 1,715,612 1,427,368 (288,244) 83% BOPTA 13,098 15,216 2,118 116% District Attorney 356,474 412,367 55,893 116% Finance/Tax 199,346 203,725 4,379 102% Veterans 70,000 61,164 (8,836) 87% Property Management 102,080 102,085 5 100% Grant Projects 2,000 2,000 100% Total Revenues 25,365,589 25,666,953 301,364 101% TOTAL RESOURCES 31,415,589 32,128,386 712,797 102% REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Transfers Out Exp. % 3,654,092 3,386,142 267,950 93% 1,549,330 1,460,043 89,287 94% 61,823 57,825 3,998 94% 4,815,262 4,579,853 235,409 95% 789,040 756,505 32,535 96% 236,965 231,953 5,012 98% 254,431 250,018 4,413 98% 106,784 105,064 1,720 98% 1,457,222 1,362,651 94,571 94% 4,889,586 - 4,889,586 n/a 17,814,535 12,190,054 5,624,481 68% 13,218,088 13,162,337 55,751 100% TOTAL REQUIREMENTS 31,032,623 25,352,391 5,680,232 82% NET (Resources - Requirements) 382,966 6,775,995 6,393,029 Beginning NWC per Adopted Budget 6,050,000 COMM JUSTICE -JUVENILE Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 1,090,000 $ 1,161,149 $ 71,149 107% Revenues Federal Grants 134,075 154,733 20,658 115% State Miscellaneous 51,000 46,613 (4,387) 91% SB #1065 -Court Assess. 64,000 60,995 (3,005) 95% Discovery Fee 16,000 15,264 (736) 95% Food Subsidy 39,000 35,699 (3,301) 92% Juvenile Crime Prevention 364,171 374,963 10,792 103% Inmate/Prisoner Housing 60,000 126,300 66,300 211% Inmate Commissary Fees 500 730 230 146% Contract Payments 343,696 241,471 (102,226) 70% Miscellaneous 300 364 64 121% MIP Diversion Fees 1,600 825 (775) 52% Interest on Investments 30,000 34,998 4,998 117% Leases 12,600 5,050 (7,550) 40% Grants -Private 1,382 1,382 n/a Crime Prevention Services 19,733 19,733 n/a Level 7 90,000 50,435 (39,565) 56% Total Revenues 1,206,942 1,169,555 (37,388) 97% Transfers In -General Fund 6,007,840 6,007,840 - 100% TOTAL RESOURCES 8,304,782 8,338,544 33,762 100% REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Exp. % 2,928,514 2,904,468 24,046 99% Materials and Services 1,643,861 1,515,926 127,935 92% Capital Outlay 100 100 0% Juvenile Resource Center Personal Services 2,894,375 2,512,445 381,930 87% Materials and Services 207,573 205,604 1,969 99% Capital Outlay 100 100 0% Contingency 630,259 630,259 n/a TOTAL REQUIREMENTS 8,304,782 7,138,443 1,166,339 86% NET (Resources - Requirements) - 1,200,101 1,200,101 Beginning NWC per Adopted Budget 1,085,000 Sheriff - Fund 255 Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues Budget Actual Variance , Coli. % $ 20,021,501 12,367,820 $ 138,600 $ 138,600 17,024,148 10,986,674 45,076 n/a (2,997,353) 85% (1,381,146) 89% 45,076 n/a 32,389,321 28,055,898 (4,333,423) TOTAL RESOURCES 32,389,321 28,194,499 (4,194,822) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 2,241,306 Civil 1,184, 729 Automotive/Communications 1,307,464 Investigations/Evidence 1,710,801 Patrol/Civil/Comm Supp 7,797,946 Records 668,705 Adult Jail 9,819,507 Court Security 215,135 Emergency Services 175,424 Special Services Division 1,337,636 Regional Work Center 2,698,798 Training Division 242,780 Non -Departmental 43,725 Contingency 2,895,365 Transfers Out 2,200,947 40,359 1,136,343 48,386 1,275,635 31,829 1,598,187 112,614 7,479,545 318,401 664,971 3,734 9,103,388 716,119 203,380 11,755 169,016 6,408 1,300,585 37,051 2,553,069 145,729 226,131 16,649 49,625 (5,900) - 2,895,365 50,000 50,000 87% 87% Exp. % TOTAL REQUIREMENTS 32,389,321 NET (Resources - Requirements) 98% 96% 98% 93% 96% 99% 93% 95% 96% 97% 95% 93% 113% n/a 100% 28,010,822 4,378,499 86% 183,677 183,677 Beginning NWC per Adopted Budget Sheriff 701 Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants State Grant Transp. of State Wards SB 1145 Des Cty Court Security Des Cty Juvenile Contract Transport Title III Reimbursement DC Fair & Expo Center Local Gov't Pmts Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive -Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Rentals Donations Total Revenues Budget Actual Variance Coli. % J $ 2,560,294 $ 2,611,374 $ 51,080 14,568,591 269,452 20,000 45,156 5,000 1,935,819 129,000 24,000 60,000 150,000 1,600 4,000 500 12,000 1,050 153,615 45,000 3,600 32,824 14,474,348 497,600 60,508 70,343 11,691 1,815,672 128,611 6,489 3,737 145,205 7,875 7,440 81,546 29,760 11,030 9,800 3,861 9,814 19,644 563 184,648 92,413 7,329 76,260 48 (94,243) 228,148 40,508 25,187 6,691 (120,147) (389) (17,511) 3,737 145,205 7,875 7,440 21,546 (120,240) 9,430 5,800 3,361 9,814 7,644 (487) 31,033 47,413 3,729 43,436 48 17,461,207 n/a 99% 185% 303% 156% 234% 94% 100% 27% n/a n/a n/a n/a 136% 20% 689% 245% 772% n/a 164% 54% 120% 205% 204% 232% n/a 17,756,235 295,028 102% TOTAL RESOURCES 20,021,501 20,367,609 346,108 102% REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 20,021,501 Exp. % 17,024,148 2,997,353 85% TOTAL REQUIREMENTS 20,021,501 17,024,148 2,997,353 85% NET (Resources - Requirements) - 3,343,461 3,343,461 Beginning NWC per Adopted Budget 2,470,519 Sheriff 702 Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) 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 Narcotic Task Force Des Cty General Fund Grnt Des Cty Transient Room Tax Des Cty Other Grant City of Sisters Des Cty Tax/Fin Contract Des Cty CDD Contract Des Cty Solid Waste Cntrt Des Cty Clerk/Election Security & Traffic Reimb Seat Belt Program Miscellaneous Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Interest Interest on Unsegregated Grants - Private Sale of Equip & Material Total Revenues TOTAL RESOURCES Budget Actual 1 Variance Coll. % $ 1,169,561 $ 1,178,512 $ 8,951 7,096,836 128,785 28,500 72,000 79,392 67,000 98,944 110,000 214,980 2,435,020 126,167 393,255 2,750 54,365 54,365 3,000 26,000 6,000 2,500 5,000 85,000 75,000 30,000 2,400 1,000 7,080,544 277,946 24,379 66,750 135,746 60,995 114,966 27,500 214,980 2,435,020 400,014 860 40,774 67,956 3,326 7,320 8,425 10,716 7,211 126,023 77,600 353 29,242 3,585 6,000 13,641 n/a (16,292) 100% 149,161 216% (4,121) 86% (5,250) 93% 56,354 171% (6,005) 91% 16,022 116% (82,500) 25% 100% 100% (126,167) 0% 6,759 102% (1,890) 31% (13,591) 75% 13,591 125% 326 111% (18,680) 28% 2,425 140% 8,216 429% 2,211 144% 41,023 148% 2,600 103% 353 n/a (758) 97% 1,185 149% 6,000 n/a 12,641 1364% 11,198,259 11,241,870 12,367,820 12,420,382 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 12,367,820 TOTAL REQUIREMENTS NET (Resources - Requirements) 43,611 100% 52,562 100% Exp. % 10,986,674 1,381,146 89% 12,367,820 10,986,674 1,381,146 89% - 1,433,708 1,433,708 Beginning NWC per Adopted Budget 1,287,473 HEALTH Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 707,000 $ 972,436 $ 265,436 138% Revenues Medicare Reimbursement 4,000 1,548 (2,452) 39% Federal Grants 2,300 2,300 n/a State Grant 1,593,814 1,849,247 255,433 116% Child Dev & Rehab Center 34,737 33,401 (1,336) 96% State Miscellaneous 265,834 255,343 (10,491) 96% STARS Foundation 2,650 2,650 n/a OMAP 270,000 367,171 97,171 136% Family Planning Exp Proj 475,000 490,033 15,033 103% Grants 31,181 31,181 n/a Sale of Map Photo or Copies - 163 163 n/a Contract Payments/ESD 8,000 8,000 100% Miscellaneous - 3,114 3,114 n/a Patient Insurance Fees 91,450 165,954 74,504 181% Health Dept/Patient Fees 222,500 155,731 (66,769) 70% Vital Records -Birth 40,000 34,925 (5,075) 87% Vital Records -Death 94,000 101,430 7,430 108% Interest on Investments 38,000 26,069 (11,931) 69% Donations 9,100 8,852 (248) 97% Interfund Contract 86,160 95,706 9,546 111% Administrative Fee 27,000 27,000 - 100% Interfund Grant 40,082 40,082 - 100% Total Revenues 3,299,678 3,699,900 400,222 112% Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 25,000 25,000 2,641,235 2,641,235 6,672,913 7,338,571 - 100% - 100% 665,658 110% Exp. % 4,524,171 4,531,159 (6,988) 100% 1,516,529 1,486,232 30,297 98% 75,000 54,945 20,055 73% 150,000 150,000 100% 407,213 407,213 n/a TOTAL REQUIREMENTS 6,672,913 6,222,336 450,577 93% NET (Resources - Requirements) 1,116,235 1,116,235 Beginning NWC per Adopted Budget 900,000 MENTAL HEALTH Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Contract Payments Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Donations Interfund Contract Administrative Fee Crime Prevention Services Total Revenues Transfers In -General Fund Transfers In -Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Budget Actual Variance CoII. % $ 2,750,000 $ 2,695,308 $ (54,692) 98% 5,500 5,390 125,000 121,515 2,000 95 241,492 163,334 5,417,129 5,377,438 179,716 218,163 300,705 316,923 106,000 138,911 100,000 69,000 14,040 87,800 124,307 217,500 200,093 11,500 6,441 73,000 77,506 16,500 19,769 10,000 100 3,120 7,984 2,896,800 2,879,474 143,884 143,884 (110) 98% (3,485) 97% (1,905) 5% (78,158) 68% (39,691) 99% 38,447 121% 16,218 105% 32,911 131% (31,000) 69% 14,040 n/a 36,507 142% (17,407) 92% (5,059) 56% 4,506 106% 3,269 120% (9,900) 1% 4,864 256% (17, 326) 9,937,646 1,550,899 453,825 99% 100% 9,884,367 (53,279) 99% 1,550,899 - 100% 436,825 (17,000) 96% 14,692,370 14,567,399 (124,971) 99% 8,326,706 7,779,352 547,354 4,474,780 4,048,052 426,728 100 100 150,000 150,000 1,740,784 - 1,740,784 14,692,370 11,977,404 2,714,966 82% Exp. % 93% 90% 0% 100% n/a 2,589,995 2,589,995 Beginning NWC per Adopted Budget 2,725,000 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. RESOURCES: Beg. Net Working Capital $ (2,777,224) $ (2,667,071) $ 110,153 96% Revenues Admin -Operations 35,250 (14,720) (49,970) -42% Admin -GIS 5,000 1,836 (3,164) 37% Admin -Code Enforcement 308,500 195,272 (113,228) 63% Building Safety 1,721,700 920,554 (801,146) 53% Electrical 455,125 257,945 (197,180) 57% Contract Services 532,000 230,171 (301,829) 43% Env Health -On Site Prog 729,700 249,657 (480,043) 34% Env Health-Lic Facilities 685,150 670,393 (14,758) 98% Env Health - Drinking H2O 76,967 103,992 27,025 135% Planning -Current 1,381,475 916,635 (464,840) 66% Planning -Long Range 605,795 390,247 (215,549) 64% Total Revenues 6,536,662 3,921,979 (2,614,683) 60% Trans In -CDD Reserve 2,482,111 2,477,135 (4,976) 100% Trans In -CDD Bldg/Elec 2,257,725 2,243,164 (14,561) 99% Trans In -Gen Fund - 200,000 200,000 n/a Trans In -Newberry (297) 82,714 131,666 48,952 159% Trans In -Other 100 850,000 849,900 850000% TOTAL RESOURCES 8,582,088 7,156,873 (1,425,215) 83% REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Division Admin -GIS Division Admin -Code Enforcement Building Safety Division Electrical Division Contract Services Env Health -On Site Pgm Env Health-Lic Facilities Env Health - Drinking H2O EPA Grant Planning -Current Division Planning -Long Range Div Transfers Out (D/S Fund) Contingency Exp. % 2,111, 666 1,967,774 143,892 93% 262,679 230,499 32,180 88% 245,934 214,340 31,594 87% 1,062,701 990,293 72,408 93% 305,388 281,851 23,537 92% 280,279 259,694 20,585 93% 343,547 297,523 46,024 87% 537,497 508,538 28,959 95% 88,057 82,623 5,434 94% 82,875 79,862 3,013 96% 1,015,700 957,296 58,404 94% 638,350 509,608 128,742 80% 175,000 150,000 25,000 86% 1,432,415 1,432,415 n/a TOTAL REQUIREMENTS 8,582,088 6,529,900 2,052,188 76% NET (Resources - Requirements) - 626,973 626,973 Beginning NWC per Adopted Budget 413,471 Revenues 3,921,979 Expenditures 6,529,900 Net from Operations (2,607,921) ROAD Statement of Financial Operating Data Year Ended Jun 8/26/2009) June 20, 2009 Final as of Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 6,392,830 $ 6,392,830 $ 0 100% Revenues System Development Ch 20,000 4,389 (15,611) 22% Mineral Lease Royalties 5,000 115,994 110,994 2320% Federal Grant - 719,917 719,917 n/a Forest Receipts 2,757,680 2,759,606 1,926 100% State Grant 1,689,306 1,689,307 1 100% State Miscellaneous - 5,758 5,758 n/a Motor Vehicle Revenue 7,650,000 7,147,061 (502,939) 93% City of Bend 250,000 206,121 (43,879) 82% City of Redmond 400,000 206,263 (193,737) 52% City of Sisters 50,000 - (50,000) 0% City of La Pine 11,103 11,103 n/a Admin Recovery (SDC) 570 570 n/a Miscellaneous 40,000 59,729 19,729 149% Road Vacations 1,000 1,500 500 150% Interest on Investments 125,000 189,782 64,782 152% Donations 2,440 2,684 244 110% Interfund Contract 870,000 742,316 (127,684) 85% Equipment Repairs 300,000 262,263 (37,737) 87% Vehicle Repairs 100,000 87,221 (12,779) 87% LID Construction 85,000 26,344 (58,656) 31% Vegetation Management 95,000 52,482 (42,518) 55% Inter -fund: Forester 22,000 19,446 (2,554) 88% Car Washes 3,500 3,398 (102) 97% Sale of Eqp & Material 675,000 786,364 111,364 116% Sale of Public Lands 200 76 (124) 38% Total Revenues 15,141,126 15,099,694 (41,432) 100% Trans In - CDD 25,990 7,800 (18,190) 30% Trans In - Solid Waste 861,470 861,470 - 100% Trans In -Road Imp Res 5,841 5,841 - 100% TOTAL RESOURCES 22,427,257 22,367,635 (59,622) 100% REQUIREMENTS: Expenditures Personal Services 5,627,071 5,466,267 160,804 97% Materials and Services 11,083,793 9,158,678 1,925,115 83% Capital Outlay 3,650,000 2,551,042 1,098,958 70% Transfers Out 300,000 300,000 100% Contingency 1,766,393 1,766,393 n/a TOTAL REQUIREMENTS 22,427,257 17,475,987 4,951,270 78% Exp. % NET (Resources - Requirements) - 4,891,648 4,891,648 Beginning NWC per Adopted Budget 4,871,665 ADULT PAROLE & PROBATION Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 663,144 $ 700,907 $ 37,763 106% Revenues State Subsidy 32,890 29,227 (3,663) 89% State Miscellaneous - 4,301 4,301 n/a SB 1145 2,903,945 2,723,508 (180,437) 94% Probation Work Crew Fees 34,000 47,368 13,368 139% Miscellaneous 5,000 3,842 (1,158) 77% Electronic Monitoring Fee 110,000 168,670 58,670 153% Probation Superv. Fees 250,000 251,418 1,418 101% Interest on Investments 28,165 26,920 (1,245) 96% Crime Prevention Services - 25,000 25,000 n/a Drug Court - Byrne 50,000 23,670 (26,330) 47% Total Revenues 3,414,000 3,303,921 (110,079) 97% Transfers In -General Fund Transfers In -Video Lottery Transfers In -Sheriff TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 157,078 106,000 50,000 157,078 100% 70,667 (35,333) 67% 50,000 - 100% 4,390,222 4,282,573 (107,649) 98% Exp. % 3,054,449 2,938,108 116,341 96% 834,259 856,791 (22,532) 103% 100 100 0% 501,414 - 501,414 n/a TOTAL REQUIREMENTS 4,390,222 3,794,899 595,323 86% NET (Resources - Requirements) 487,674 487,674 Beginning NWC per Adopted Budget 467,892 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 571,035 $ 532,187 $ (38,848) 93% Revenues Federal Grants 236,775 282,867 46,092 119% Title IV - Family Sup/Pres 37,652 40,982 3,330 109% HealthyStart Medicaid 130,000 131,109 1,109 101% Child Care Block Grant 75,661 107,477 31,816 142% Level 7 Services 175,193 201,546 26,353 115% Juvenile Crime Prevention 397,050 468,201 71,151 118% State Prevention Funds 187,500 187,499 (1) 100% HealthyStart /R -S -G 366,017 350,605 (15,412) 96% OCCF Grant 881,795 843,062 (38,733) 96% Miscellaneous 8,000 8,467 467 106% Court Fines & Fees 24,000 67,332 43,332 281% Interest on Investments 25,000 29,839 4,839 119% Miscellaneous/Crime Prev - 80,266 80,266 n/a Grants -Private 10,000 - (10,000) 0% Total Revenues 2,554,643 2,799,252 244,609 110% Trans from General Fund 351,295 351,295 - 100% Trans from GF -Other 6,891 6,891 - 100% Total Transfers In 358,186 358,186 - 100% TOTAL RESOURCES 3,483,864 3,689,625 205,761 106% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 568,142 491,133 77,009 86% 2,590,178 2,529,865 60,313 98% 100 100 0% 325,444 325,444 n/a TOTAL REQUIREMENTS 3,483,864 3,020,998 462,866 87% NET (Resources - Requirements) - 668,627 668,627 Beginning NWC per Adopted Budget 624,543 SOLID WASTE Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance Coll. % RESOURCES: Beg. Net Working Capital $ 1,221,164 $ 1,254,853 $ 33,689 103% Revenues State Grant 46,000 - (46,000) 0% Miscellaneous 35,000 31,028 (3,972) 89% Refunds/Reimbursements - 15,938 15,938 n/a Franchise 3% Fees 200,000 225,732 25,732 113% Commercial Disp. Fees 1,674,716 1,025,742 (648,974) 61% Private Disposal Fees 1,567,714 1,345,794 (221,920) 86% Franchise Disposal Fees 4,826,406 3,857,266 (969,140) 80% Yard Debris 70,249 64,566 (5,683) 92% Special Waste 30,000 13,003 (16,997) 43% Interest 100,000 37,742 (62,258) 38% Leases 240 240 n/a Sale of Equip & Material 50,000 71,086 21,086 142% Total Revenues 8,600,085 6,688,137 (1,911,948) 78% TOTAL RESOURCES 9,821,249 7,942,990 (1,878,259) 81% REQUIREMENTS Expenditures Personal Services 1,814,996 1,766,633 48,363 97% Materials and Services 4,407,657 3,740,678 666,979 85% Debt Service 971,788 971,788 100% Capital Outlay 240,725 136,094 104,631 57% Transfers Out 1,861,470 861,470 1,000,000 46% Contingency 524,613 - 524,613 n/a Exp. TOTAL REQUIREMENTS 9,821,249 7,476,663 2,344,586 76% NET (Resources - Requirements) 466,327 466,327 Beginning NWC per Adopted Budget 338,611 Risk Management Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: Year to Date Budget Actual Variance % Coll. $2,500,000 $2,549,708 $49,708 102% General Liability 401,910 401,911 1 100% Property Damage 286,294 286,294 - 100% Vehicle 179,338 178,843 (495) 100% Workers' Compensation 965,309 1,001,405 36,096 104% Unemployment 151,725 158,109 6,384 104% Claims Reimb-Workers' Compensation 3,000 39,878 36,878 1329% Claims Reimb-Gen Liab/Property 20,000 91,532 71,532 458% Process Fee-Events/Parades 300 1,225 925 408% Miscellaneous 5,000 - (5,000) 0% Skid Car Training 25,000 16,170 (8,830) 65% Interest on Investments 50,000 69,823 19,823 140% TOTAL REVENUES 2,087,876 2,245,190 157,314 108% Transfers In -PERS Reserve 100 - (100) 0% TOTAL RESOURCES 4,587,976 4,794,898 206,922 105% Appropriations/Expenditures % Exp. Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 19,777 Defense 4,975 Miscellaneous 5 Professional Service 7,907 Insurance 157,927 Loss Prevention 329 Repair/ Replacement 2,192 Total General Liability 1,300,000 193,112 1,300,000 15% PROPERTY DAMAGE Insurance 149,224 Professional Service 48 Repair / Replacement 96,593 Total Property Damage 335,000 245,865 335,000 VEHICLE Professional Service 942 Repair / Replacement 36,098 Insurance 471 Loss Prevention 14,039 Repair / Replacement 11,890 Total Vehicle 160,000 63,440 160,000 40% WORKERS' COMPENSATION Settlement / Benefit 726,282 Professional Service 6,250 Insurance 42,704 Loss Prevention 10,586 Miscellaneous 45,017 Workers' Comp Losses 66,001 Total Workers' Compensation 715,000 896,840 715,000 125% UNEMPLOYMENT - Settlement / Benefits 65,000 285,374 (220,374) 439% Total Direct Insurance Costs 2,575,000 1,684,631 2,289,626 65% Insurance Administration: Personal Services 361,157 295,471 65,686 82% Materials & Service 192,004 145,505 46,499 76% Capital Outlay 100 - 100 0% Total Insurance Administration 553,261 440,975 112,286 80% Contingency 1,459,715 1,459,715 n/a TOTAL APPROPRIATIONS/EXPENDITURES 4,587,976 2,125,607 3,861,627 46% NET 2,669,291 4,068,548 73% Beginning NWC per Adopted Budget 2,491,977 DESCHUTES COUNTY 911 Statement of Financial Operating Data Year Ended June 20, 2009 (Final as of 8/26/2009) Budget Actual Variance % Coli. RESOURCES: Beg. Net Working Capital $ 2,393,117 $ 2,636,885 $ 243,768 110% Revenues Property Taxes - Current 5,977,048 5,985,608 8,560 100% Property Taxes - Prior 56,650 101,308 44,658 179% State Reimbursement 22,000 23,060 1,060 105% Telephone User Tax 805,089 1,081,854 276,765 134% Data Network Reimb. 34,000 25,128 (8,872) 74% Jefferson County 21,985 43,420 21,435 197% User Fee 33,500 27,663 (5,837) 83% Contract Payments 70,000 60,579 (9,421) 87% Miscellaneous 8,250 11,410 3,160 138% Interest 50,000 116,727 66,727 233% Interest on Unsegregated Tax 1,300 2,948 1,648 227% Total Revenues 7,079,822 7,479,705 399,883 106% TOTAL RESOURCES 9,472,939 10,116,590 643,651 107% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency % Exp. 3,728,025 3,422,337 305,688 92% 993,251 925,157 68,094 93% 132,000 27,928 104,072 21% 130,000 130,000 100% 4,489,663 - 4,489,663 n/a TOTAL REQUIREMENTS 9,472,939 4,505,422 4,967,517 48% NET (Resources - Requirements) - 5,611,168 5,611,168 Beginning NWC per Adopted Budget 5,137,000 Health Benefits Trust Statement of Financial Operating Data Year Ended June 30, 2009 (Final as of 8/26/2009) RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges 12,477,300 P/T Emp - Add'I Prem 131,000 Employee Prem Contribution 359,866 COIC 800,000 Retiree / COBRA Co -Pay 400,000 Medical Services Reimb Prescription Rebates Interest 375,000 Budget Actual Variance Coll. % $14,000,000 $ 14,862,418 $ 862,418 106% 12,689,448 212,148 102% 52,964 (78,036) 40% a) 347,028 (12,838) 96% 1,197,050 397,050 150% 624,646 224,646 156% 11,986 11,986 n/a 23,082 23,082 n/a 414,626 39,626 111% Total Revenues 14,543,166 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 28,543,166 15,360,830 817,664 106% 30,223,248 113,715 108,328 3,000 11,792,650 1,609,117 357,511 64,000 272,102 47,077 42,800 8,000 2,000 15,163 1,680,082 106% Exp. % 5,387 95% 1,410 1,590 47% 9,739,836 2,052,814 83% b) 1,634,479 (25,362) 102% b) (66,328) 66,328 n/a 367,688 (10,177) 103% 134,149 (70,149) 210% 278,583 (6,481) 102% 34,962 12,115 74% 49,678 (6,878) 116% 9,797 (1,797) 122% 700 1,300 35% 35,169 (20,006) 232% 14,213,420 14,215,931 28,543,066 12,220,123 1,993,297 86% - 0% - 14,215,931 0% 12,328,451 16,214,615 43% NET (Resources - Requirements) • 100 17,894,797 17,894,697 Beg NWC - FY 2010 Adopted Budget 18,100,000 a) Fewer part-time employees opting for plan available to full-time employees. b) Weekly claims average for FY 2009 - $217,461. 8/26/21109 Memorandum Date: August 18, 2009 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find July 2009 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriff's (255, 701, 702), Health (259), Mental Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), Health Benefits Trust Fund (675) and 9-1-1 (705). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data One Month Ended July 31, 2009 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 1,651,904 163,359 (1,488,545) 8% 1% a) 19,822,847 19,822,847 Gen. Rev. - excl. Taxes 243,455 580,326 336,871 8% 20% b) 2,921,462 2,921,462 Assessor 68,392 198,394 130,002 8% 24% c) 820,704 820,704 County Clerk 86,931 141,973 55,042 8% 14% d) 1,043,171 1,043,171 BOPTA 1,149 3,906 2,757 8% 28% c) 13,791 13,791 District Attorney 27,733 932 (26,801) 8% 0% 332,800 332,800 Finance/Tax 15,587 49,072 33,485 8% 26% c) 187,049 187,049 Veterans 5,849 (5,849) 8% 0% 70,192 70,192 Property Management 7,204 7,204 - 8% 8% 86,450 86,450 Grant Projects 167 167 - 8% 8% 2,000 2,000 Total Revenues 2,108,371 1,145,333 (963,038) 8% 5% 25,300,466 25,300,466 TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor 274,219 244,538 29,681 8% 7% 3,290,631 3,290,631 County Clerk 121,725 85,164 36,561 8% 6% 1,460,704 1,460,704 BOPTA 4,976 7,146 (2,170) 8% 12% 59,708 59,708 District Attorney 382,272 365,415 16,857 8% 8% 4,587,263 4,587,263 Finance/Tax 62,206 50,800 11,406 8% 7% 746,471 746,471 Veterans 18,808 17,653 1,155 8% 8% 225,701 225,701 Property Management 19,974 18,484 1,490 8% 8% 239,685 239,685 - Grant Projects 8,806 8,353 453 8% 8% 105,673 105,673 Non -Departmental 134,417 54,150 80,267 8% 3% 1,613,006 1,613,006 Contingency 507,893 507,893 8% 0% 6,094,713 6,094,713 8,158,371 7,921,328 (237,043) 8% 25% 31,350,466 32,076,461 725,995 Exp. % 1,535,296 851,703 683,593 8% 5% 18,423,555 12,328,842 6,094,713 Transfers Out 1,077,243 968,989 108,254 8% 7% 12,926,911 12,926,911 TOTAL REQIJIREMENTS 2,612,539 1,820,692 791,847 8% 6% 31,350,466 25,255,753 6,094,713 NET (Resources - Requirements) 5,545,832 6,100,636 554,804 - 6,820,708 6,820,708 a) Approximately 85% of the property taxes are collected in October and November b) Includes annual PILT payment of $467,230. c) Includes 1st Quarter A & T Grant: Assessor -$197,517, Tax -$46,518 and BOPTA -$3,906. d) Significant foreclosure and refinancing recordings. Year End $ Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% $ 6,050,000 $ 6,775,995 $ 725,995 Revenues Property Taxes 1,651,904 163,359 (1,488,545) 8% 1% a) 19,822,847 19,822,847 Gen. Rev. - excl. Taxes 243,455 580,326 336,871 8% 20% b) 2,921,462 2,921,462 Assessor 68,392 198,394 130,002 8% 24% c) 820,704 820,704 County Clerk 86,931 141,973 55,042 8% 14% d) 1,043,171 1,043,171 BOPTA 1,149 3,906 2,757 8% 28% c) 13,791 13,791 District Attorney 27,733 932 (26,801) 8% 0% 332,800 332,800 Finance/Tax 15,587 49,072 33,485 8% 26% c) 187,049 187,049 Veterans 5,849 (5,849) 8% 0% 70,192 70,192 Property Management 7,204 7,204 - 8% 8% 86,450 86,450 Grant Projects 167 167 - 8% 8% 2,000 2,000 Total Revenues 2,108,371 1,145,333 (963,038) 8% 5% 25,300,466 25,300,466 TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor 274,219 244,538 29,681 8% 7% 3,290,631 3,290,631 County Clerk 121,725 85,164 36,561 8% 6% 1,460,704 1,460,704 BOPTA 4,976 7,146 (2,170) 8% 12% 59,708 59,708 District Attorney 382,272 365,415 16,857 8% 8% 4,587,263 4,587,263 Finance/Tax 62,206 50,800 11,406 8% 7% 746,471 746,471 Veterans 18,808 17,653 1,155 8% 8% 225,701 225,701 Property Management 19,974 18,484 1,490 8% 8% 239,685 239,685 - Grant Projects 8,806 8,353 453 8% 8% 105,673 105,673 Non -Departmental 134,417 54,150 80,267 8% 3% 1,613,006 1,613,006 Contingency 507,893 507,893 8% 0% 6,094,713 6,094,713 8,158,371 7,921,328 (237,043) 8% 25% 31,350,466 32,076,461 725,995 Exp. % 1,535,296 851,703 683,593 8% 5% 18,423,555 12,328,842 6,094,713 Transfers Out 1,077,243 968,989 108,254 8% 7% 12,926,911 12,926,911 TOTAL REQIJIREMENTS 2,612,539 1,820,692 791,847 8% 6% 31,350,466 25,255,753 6,094,713 NET (Resources - Requirements) 5,545,832 6,100,636 554,804 - 6,820,708 6,820,708 a) Approximately 85% of the property taxes are collected in October and November b) Includes annual PILT payment of $467,230. c) Includes 1st Quarter A & T Grant: Assessor -$197,517, Tax -$46,518 and BOPTA -$3,906. d) Significant foreclosure and refinancing recordings. COMM JUSTICE -JUVENILE Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY%TColl.% RESOURCES: Beg. Net Working Capital $1,085,000 $1,200,107 $ 115,107 100% 111% $1,085,000 $1,200,107 $ 115,107 Revenues Federal Grants 2,648 (2,648) 8% 0% 31,775 31,775 SB #1065 -Court Assess. 5,000 2,733 (2,267) 8% 5% 60,000 60,000 Discovery Fee 1,333 1,938 605 8% 12% 16,000 16,000 Food Subsidy 2,500 (2,500) 8% 0% 30,000 30,000 Juvenile Crime Prevention 27,704 (27,704) 8% 0% 332,450 332,450 Inmate/Prisoner Housing 5,000 150 (4,850) 8% 0% 60,000 60,000 Inmate Commissary Fees 67 (67) 8% 0% 800 800 Contract Payments 17,345 - (17,345) 8% 0% 208,141 208,141 Miscellaneous 25 - (25) 8% 0% 300 300 MIP Diversion Fees 83 - (83) 8% 0% 1,000 1,000 Interest on Investments 1,083 2,134 1,051 8% 16% 13,000 13,000 Leases 204 200 (4) 8% 8% 2,448 2,448 Grants - Private 58 58 8% n/a 58 58 Level 7 5,667 (5,667) 8% n/a 68,000 68,000 Crime Prevention Services 1,667 - (1,667) 8% 0% 20,000 20,000 Total Revenues 70,326 7,213 (63,113) 8% 1% 843,914 843,972 58 Transfers In -General Fund 461,932 461,932 - 8% 8% 5,543,186 5,543,186 TOTAL RESOURCES 1,617,258 1,669,252 51,994 8% 22% 7,472,100 7,587,265 115,165 REQUIREMENTS: Expenditures Community Justice -Juvenile Exp. % Personal Services 235,846 233,752 2,094 8% 8% 2,830,152 2,830,152 Materials and Services 110,175 63,480 46,695 8% 5% 1,322,097 1,322,097 Capital Outlay 8 - 8 8% 0% 100 100 Juvenile Resource Center Personal Services 211,013 185,516 25,497 8% 7% 2,532,154 2,532,154 Materials and Services 15,409 25,974 (10,565) 8% 14% 184,903 184,903 Capital Outlay 8 8 8% 0% 100 100 Contingency 50,216 - 50,216 8% n/a 602,594 TOTAL REQUIREMENTS 622,675 508,722 113,953 8% NET (Resources - Requirements) 7% 602,594 7,472,100 6,869,506 602,594 994,583 1,160,530 165,947 717,759 717,759 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,085,000 $1,200,107 $ 115,107 100% 111% $1,085,000 $1,200,107 $ 115,107 Revenues Federal Grants 2,648 (2,648) 8% 0% 31,775 31,775 SB #1065 -Court Assess. 5,000 2,733 (2,267) 8% 5% 60,000 60,000 Discovery Fee 1,333 1,938 605 8% 12% 16,000 16,000 Food Subsidy 2,500 (2,500) 8% 0% 30,000 30,000 Juvenile Crime Prevention 27,704 (27,704) 8% 0% 332,450 332,450 Inmate/Prisoner Housing 5,000 150 (4,850) 8% 0% 60,000 60,000 Inmate Commissary Fees 67 (67) 8% 0% 800 800 Contract Payments 17,345 - (17,345) 8% 0% 208,141 208,141 Miscellaneous 25 - (25) 8% 0% 300 300 MIP Diversion Fees 83 - (83) 8% 0% 1,000 1,000 Interest on Investments 1,083 2,134 1,051 8% 16% 13,000 13,000 Leases 204 200 (4) 8% 8% 2,448 2,448 Grants - Private 58 58 8% n/a 58 58 Level 7 5,667 (5,667) 8% n/a 68,000 68,000 Crime Prevention Services 1,667 - (1,667) 8% 0% 20,000 20,000 Total Revenues 70,326 7,213 (63,113) 8% 1% 843,914 843,972 58 Transfers In -General Fund 461,932 461,932 - 8% 8% 5,543,186 5,543,186 TOTAL RESOURCES 1,617,258 1,669,252 51,994 8% 22% 7,472,100 7,587,265 115,165 REQUIREMENTS: Expenditures Community Justice -Juvenile Exp. % Personal Services 235,846 233,752 2,094 8% 8% 2,830,152 2,830,152 Materials and Services 110,175 63,480 46,695 8% 5% 1,322,097 1,322,097 Capital Outlay 8 - 8 8% 0% 100 100 Juvenile Resource Center Personal Services 211,013 185,516 25,497 8% 7% 2,532,154 2,532,154 Materials and Services 15,409 25,974 (10,565) 8% 14% 184,903 184,903 Capital Outlay 8 8 8% 0% 100 100 Contingency 50,216 - 50,216 8% n/a 602,594 TOTAL REQUIREMENTS 622,675 508,722 113,953 8% NET (Resources - Requirements) 7% 602,594 7,472,100 6,869,506 602,594 994,583 1,160,530 165,947 717,759 717,759 Sheriff - Fund 255 Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ Revenues Law Enf Dist Countywide 1,686,911 Law Enf Dist Rural 1,059,777 Interest - Total Revenues TOTAL RESOURCES $ 183,677 $ 183,677 100% 1,686,911 1,059,777 3,952 3,952 8% 8% 8% 2,746,688 2,750,640 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications Investigations/Evidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non -Departmental Contingency Transfers Out TOTAL REQUIREMENTS NET (Resources - Requirements) 2,746,688 2,934,317 163,432 60,580 116,490 140,194 631,048 53,530 753,743 17,992 15,673 92,391 228,154 25,004 43,975 38,587 320,895 45,000 161,667 62,135 293,703 126,952 566,375 50,375 618,081 14,502 16,000 88,019 180,317 31,265 42,731 5,254 3,952 8% 187,629 8% 1,765 (1,555) (177,213) 13,242 64,673 3,155 135,662 3,490 (327) 4,372 47,837 (6,261) 1,244 33,333 320,895 45,000 n/a 8% 8% n/a 8% 9% Exp. % $ - $ 183,677 $ 183,677 20,242,936 20,242,936 12, 717, 322 12, 717, 322 3,952 3,952 32,960,258 32,964,210 3,952 32,960,258 33,147,887 187,629 8% 8% 1,961,188 8% 9% 726,961 21% a) 1,397,884 1,682,327 7,572,575 642,363 9,044,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 1% 463,044 n/a 3,850,741 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 7% 8% 7% 7% 9% 8% 7% 10% 8% 1,961,088 100 726,961 1,397,884 1,682,327 7,572,575 642,263 100 9,044,909 215,808 100 188,071 1,108,690 2,737,742 100 299,953 100 527,602 100 463,044 - 3,850,741 0% 540,000 540,000 2,746,688 2,257,376 489,312 8% 7% 32,960,258 29,108,917 3,851,341 676,941 676,941 - 4,038,970 4,038,970 Year End Budget Projection Variance $ - $ 183,677 $ 183,677 20,242,936 20,242,936 12, 717, 322 12, 717, 322 3,952 3,952 32,960,258 32,964,210 3,952 32,960,258 33,147,887 187,629 8% 8% 1,961,188 8% 9% 726,961 21% a) 1,397,884 1,682,327 7,572,575 642,363 9,044,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 1% 463,044 n/a 3,850,741 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 7% 8% 7% 7% 9% 8% 7% 10% 8% 1,961,088 100 726,961 1,397,884 1,682,327 7,572,575 642,263 100 9,044,909 215,808 100 188,071 1,108,690 2,737,742 100 299,953 100 527,602 100 463,044 - 3,850,741 0% 540,000 540,000 2,746,688 2,257,376 489,312 8% 7% 32,960,258 29,108,917 3,851,341 676,941 676,941 - 4,038,970 4,038,970 RESOURCES: Beg. Net Working Capital Total Revenues TOTAL RESOURCES REQUIREMENTS: Sheriff's Services SHERIFF -Expenditure Detail Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget 1 Actual 1 Variance 1 FY % 1 Coll. % Budget Year End Projection Variance $ - $ 183,677 $ 183,677 100% n/a $ - $ 183,677 $ 183,677 2,746,688 2,750,640 3,952 8% 8% 32,960,258 32,964,210 3,952 2,746,688 2,934,317 187,629 8% 9% 32,960,258 33,147,887 187,629 Exp. % Personnel 93,387 91,923 1,464 8% 8% 1,120,639 1,120,639 Materials & Services 70,037 69,744 293 8% 8% 840,449 840,449 Capital Outlay 8 - 8 8% 0% 100 100 Total Sheriffs Services 163,432 161,667 1,765 1,961,188 1,961,088 100 Civil / Special Units Personnel 55,226 60,429 (5,203) 8% 9% 662,717 662,717 Materials & Services 3,687 1,706 1,981 8% 4% 44,244 44,244 Capital Outlay 1,667 - 1,667 8% 0% 20,000 20,000 Total Civil 60,580 62,135 (1,555) 726,961 726,961 Automotive/Communications Personnel 31,055 25,782 5,273 8% 7% 372,659 372,659 Materials & Services 84,810 267,921 (183,111) 8% 26% 1,017,725 1,017,725 Capital Outlay 625 - 625 8% 0% 7,500 7,500 Total Automotive/Communications 116,490 293,703 (177,213) 1,397,884 1,397,884 Investigations/Evidence Personnel 119,584 114,531 5,053 8% 8% 1,435,003 1,435,003 Materials & Services 14,360 12,421 1,939 8% 7% 172,324 172,324 Capital Outlay 6,250 - 6,250 8% 0% 75,000 75,000 Total Investigations/Evidence 140,194 126,952 13,242 1,682,327 1,682,327 Patrol/Civil/Comm Support Personnel 557,934 516,950 40,984 8% 8% 6,695,212 6,695,212 Materials & Services 50,364 49,425 939 8% 8% 604,363 604,363 Capital Outlay 22,750 - 22,750 8% 0% 273,000 273,000 Total Patrol/Civil/Comm Supp 631,048 566,375 64,673 7,572,575 7,572,575 Records Personnel 46,872 48,197 (1,325) 8% 9% 562,465 562,465 Materials & Services 6,650 2,178 4,472 8% 3% 79,798 79,798 Capital Outlay 8 - 8 8% 0% 100 100 Total Records 53,530 50,375 3,155 642,363 642,263 100 Adult Jail Personnel 605,953 552,592 53,361 8% 8% 7,271,441 7,271,441 Materials & Services 144,720 65,489 79,231 8% 4% 1,736,643 1,736,643 Capital Outlay 3,069 - 3,069 8% 0% 36,825 36,825 Total Adult Jail 753,742 618,081 135,661 9,044,909 9,044,909 Court Security Personnel 16,823 14,112 2,711 8% 7% 201,870 201,870 Materials & Services 1,162 390 772 8% 3% 13,938 13,938 Capital Outlay 8 - 8 8% 0% 100 - 100 Total Transport/Court Security 17,993 14,502 3,491 215,908 215,808 100 Emergency Services Personnel 12,471 14,702 (2,231) 8% 10% 149,651 149,651 Materials & Services 1,535 1,298 237 8% 7% 18,420 18,420 Capital Outlay 1,667 - 1,667 8% 0% 20,000 20,000 Total Emergency Services 15,673 16,000 (327) 188,071 188,071 Special Services Personnel 73,362 85,303 (11,941) 8% 10% 880,339 880,339 Materials & Services 12,288 2,716 9,572 8% 2% 147,451 147,451 Capital Outlay 6,742 - 6,742 8% 0% 80,900 80,900 Total Special Services 92,392 88,019 4,373 1,108,690 1,108,690 Regional Work Center Personnel 196,966 173,330 23,636 8% 7% 2,363,596 2,363,596 Materials & Services 31,179 6,987 24,192 8% 2% 374,146 374,146 Capital Outlay 8 - 8 8% 0% 100 100 Total Regional Work Center 228,153 180,317 47,836 2,737,842 2,737,742 100 Training Personnel 18,933 16,056 2,877 8% 7% 227,201 227,201 Materials & Services 6,063 15,209 (9,146) 8% 21% 72,752 72,752 - Capital Outlay 8 - 8 8% 0% 100 100 Total Training 25,004 31,265 (6,261) 300,053 299,953 100 Other Law Enforcement Services Personnel 40,822 40,177 645 8% 8% 489,861 489,861 Materials & Services 3,145 2,554 591 8% 7% 37,741 37,7.41 Capital Outlay 8 - 8 8% 0% 100 - 100 Total Other Law Enforcement Svcs 43,975 42,731 1,244 527,702 527,602 100 Non -Departmental Materials & Services 38,587 5,254 33,333 8% 1% 463,044 463,044 Transfers Out 45,000 - 45,000 8% 0% 540,000 540,000 - Contingency 320,895 - 320,895 8% n/a 3,850,741 - 3,850,741 Total Non -Departmental 404,482 5,254 399,228 4,853,785 1,003,044 3,850,741 Total Requirements 2,746,688 2,257,376 489,312 8% 7% 32,960,258 29,108,917 3,851,341 NET (Resources - Requirements) 676,941 676,941 4,038,970 4,038,970 Sheriff Notes Statement of Financial Operating Data One Month Ended July 31, 2009 a) July actual includes annual amount ($260,405) of transfer to Fund 245 Communications System. RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants State Grant Transp. of State Wards SB 1145 Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive -Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Rentals Donations Total Revenues TOTAL RESOURCES Sheriff 701 Statement of Financial Operating Data One Month Ended July 31, 2009 Budget Actual Year to Date Variance FY %I Coil. % $ 2,470,519 1,234,975 41,667 2,917 3,763 417 143,433 417 10,750 250 12,500 167 5,000 3,538 500 417 333 417 1,000 88 13,333 2,361 294 2,499 $ 3,343,461 $ 872,942 8% 115,401 600 483,834 10,713 123 6,960 600 2,000 188 702 189 20,941 2,918 71 33,647 50 (1,234,975) 73,734 (2,317) (3,763) (417) 340,401 (417) (37) (250) (12, 500) (167) (4,877) 3,422 100 1,583 (145) 285 (1,000) 101 7,608 557 (223) 31,148 50 nla $ 2,470,519 $ 3,343,461 $ 872,942 8% 0% a) 14,819,703 14,819,703 8% 23% 500,000 500,000 8% 2% 35,000 35,000 8% 0% 45,156 45,156 8% 0% 5,000 5,000 - 8% 28% b) 1,721,192 1,935,336 214,144 8% n/a 5,000 5,000 - 8% 8% 129,000 129,000 8% 0% 3,000 3,000 8% n/a 150,000 150,000 8% n/a 2,000 2,000 - 8% 0% 60,000 60,000 8% 16% 42,450 42,450 8% 10% 6,000 6,000 8% 40% 5,000 5,000 8% 5% 4,000 4,000 8% n/a 5,000 5,000 8% 0% 12,000 12,000 18% 1,050 1,050 8% 13% 160,000 160,000 8% 10% 28,333 28,333 8% 2% 3,533 3,533 8% 112% c) 30,000 51,236 21,236 8% n/a - 50 50 8% 1,481,036 678,937 (802,099) 8% 4% 17,772,417 18,007,847 235,430 3,951,555 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,686,912 TOTAL REQUIREMENTS NET (Resources - Requirements) 4,022,398 70,843 1,686,911 1,686,912 1,686,911 8% 20% 20,242,936 21,351,308 1,108,372 Exp. % 1 8% 8% 20,242,936 20,242,936 1 8% 2,264,643 2,335,487 70,844 8% 20,242,936 20,242,936 - 1,108,372 1,108,372 a) Approximately 85% of the property taxes are collected in October and November b) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. c) FBI relocation from Sheriff's Office has been delayed resulting in 4 months of additional rental revenue. Year End Budget _ Projection Variance nla $ 2,470,519 $ 3,343,461 $ 872,942 8% 0% a) 14,819,703 14,819,703 8% 23% 500,000 500,000 8% 2% 35,000 35,000 8% 0% 45,156 45,156 8% 0% 5,000 5,000 - 8% 28% b) 1,721,192 1,935,336 214,144 8% n/a 5,000 5,000 - 8% 8% 129,000 129,000 8% 0% 3,000 3,000 8% n/a 150,000 150,000 8% n/a 2,000 2,000 - 8% 0% 60,000 60,000 8% 16% 42,450 42,450 8% 10% 6,000 6,000 8% 40% 5,000 5,000 8% 5% 4,000 4,000 8% n/a 5,000 5,000 8% 0% 12,000 12,000 18% 1,050 1,050 8% 13% 160,000 160,000 8% 10% 28,333 28,333 8% 2% 3,533 3,533 8% 112% c) 30,000 51,236 21,236 8% n/a - 50 50 8% 1,481,036 678,937 (802,099) 8% 4% 17,772,417 18,007,847 235,430 3,951,555 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,686,912 TOTAL REQUIREMENTS NET (Resources - Requirements) 4,022,398 70,843 1,686,911 1,686,912 1,686,911 8% 20% 20,242,936 21,351,308 1,108,372 Exp. % 1 8% 8% 20,242,936 20,242,936 1 8% 2,264,643 2,335,487 70,844 8% 20,242,936 20,242,936 - 1,108,372 1,108,372 a) Approximately 85% of the property taxes are collected in October and November b) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. c) FBI relocation from Sheriff's Office has been delayed resulting in 4 months of additional rental revenue. Sheriff 702 Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $1,287,473 $ 1,433,708 $ 146,235 Revenues Tax Revenues - Current 603,308 - Tax Revenues - Prior 19,917 61,042 Federal Grants 167 3,185 US Forest Service 6,375 - State Grant 15,636 SB #1065 Court Assessment 5,583 2,733 Marine Board License Fee 10,372 - Des Cty General Fund Grnt 71,930 10,000 Des Cty Transient Room Tax 148,903 City of Sisters 35,001 34,668 Des Cty Tax/Fin Contract 83 Des Cty CDD Contract 2,265 2,265 Des Cty Solid Waste Contr 6,796 6,796 Des Cty Clerk/Election 167 School Districts 8,333 Security & Traffic Reimb 1,083 1,386 Seat Belt Program 500 900 Miscellaneous 833 804 Sheriff Fees 417 938 Court Fines & Fees 7,083 8,852 Impound Fees 6,250 4,900 Interest 833 588 Interest on Unsegregated 150 35 Grants - Private Sale of Equip & Material 500 (603,308) 41,125 3,018 (6,375) (15,636) (2,850) (10,372) (61,930) (148,903) (333) (83) (167) (8,333) 303 400 (29) 521 1,769 (1,350) (245) (115) 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% (500) 8% Total Revenues 952,485 139,092 TOTAL RESOURCES 2,239,958 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,059,777 n/a $ 1,287,473 $1,433,708 $ 146,235 0% 26% 159% 0% 0% 4% 0% 1% 0% 8% 0% 8% 8% 0% n/a 11% 15% 8% 19% 10% 7% 6% 2% n/a 0% (813,393) 8% 1% a) 7,239,702 239,000 2,000 76,500 187,633 67,000 124,468 863,163 1,786,837 b) 420,015 1,000 27,183 81,548 2,000 100,000 13,000 6,000 10,000 5,000 85,000 75,000 10,000 1,800 7,239,702 239,000 3,185 1,185 76,500 187,633 67,000 124,468 863,163 1,786,837 416,016 (3,999) 1,000 27,183 81,548 2,000 100,000 13,000 6,000 10,000 5,000 85,000 75,000 10,000 1,800 6,000 6,000 11,429,849 11,427,035 (2,814) 1,572,800 (667,158) 8% 12% 12,717,322 12,860,743 143,421 1,059,777 TOTAL REQUIREMENTS 1,059,777 1,059,777 NET (Resources - Requirements) 1,180,181 513,023 (667,158) Exp. % 8% 8% 12,717,322 12,717,322 8% 8% 12,717,322 12,717,322 143,421 143,421 a) Approximately 85% of the property taxes are collected in October and November b) Actual escalation increase to Sisters law enforcement contract will be Tess than estimated for the budget. Year End Budget Projection Variance n/a $ 1,287,473 $1,433,708 $ 146,235 0% 26% 159% 0% 0% 4% 0% 1% 0% 8% 0% 8% 8% 0% n/a 11% 15% 8% 19% 10% 7% 6% 2% n/a 0% (813,393) 8% 1% a) 7,239,702 239,000 2,000 76,500 187,633 67,000 124,468 863,163 1,786,837 b) 420,015 1,000 27,183 81,548 2,000 100,000 13,000 6,000 10,000 5,000 85,000 75,000 10,000 1,800 7,239,702 239,000 3,185 1,185 76,500 187,633 67,000 124,468 863,163 1,786,837 416,016 (3,999) 1,000 27,183 81,548 2,000 100,000 13,000 6,000 10,000 5,000 85,000 75,000 10,000 1,800 6,000 6,000 11,429,849 11,427,035 (2,814) 1,572,800 (667,158) 8% 12% 12,717,322 12,860,743 143,421 1,059,777 TOTAL REQUIREMENTS 1,059,777 1,059,777 NET (Resources - Requirements) 1,180,181 513,023 (667,158) Exp. % 8% 8% 12,717,322 12,717,322 8% 8% 12,717,322 12,717,322 143,421 143,421 a) Approximately 85% of the property taxes are collected in October and November b) Actual escalation increase to Sisters law enforcement contract will be Tess than estimated for the budget. RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous OMAP Family Planning Exp Proj Grants Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES HEALTH Statement of Financial Operating Data Eleven Months Ended May 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 900,000 $ 1,143,354 $ 243,354 100% 127% $ 900,000 $ 1,143,354 $ 243,354 333 (333) 8% 0% 4,000 4,000 151,854 136,973 (14,881) 8% 8% a) 1,822,242 1,688,146 (134,096) 2,895 - (2,895) 8% 0% 34,737 34,737 17,770 9,152 (8,618) 8% 4% 213,240 213,240 25,250 24,596 (654) 8% 8% 303,000 303,000 39,583 - (39,583) 8% 0% b) 475,000 475,000 - 21,833 21,833 8% n/a c) 21,833 21,833 11,150 11,443 293 8% 9% 133,800 133,800 12,679 12,937 258 8% 9% 152,150 152,150 3,000 2,820 (180) 8% 8% 36,000 36,000 8,167 9,415 1,248 8% 10% 98,000 98,000 3,167 1,611 (1,556) 8% 4% 38,000 38,000 733 1,212 479 8% 14% 8,800 8,800 10,981 (10,981) 8% 0% 131,774 131,774 2,250 2,250 8% 8% 27,000 27,000 289,812 234,242 (55,570) 8% 7% 3,477,743 3,365,480 (112,263) 2,083 (2,083) 8% 0% 25,000 25,000 193,147 193,147 8% 8% 2,317,765 2,317,765 1,385,042 1,570,743 187,784 8% 23% 6,720,508 6,851,599 131,091 REQUIREMENTS: Expenditures Personal Services 368,961 Materials and Services 119,031 Capital Outlay 1,409 Transfers Out 12,500 Contingency 58,142 TOTAL REQUIREMENTS NET (Resources - Requirements) 335,410 70,529 33,551 48,502 1,409 12,500 58,142 8% Soda Exp. % 8% d) 4,427,529 4,227,991 199,538 5%a 1,428,371 1,428,371 8% 0% 16,902 16,902 8% 0% 150,000 150,000 8% n/a 697,706 697,706 560,043 405,939 154,104 8% 6% 6,720,508 5,823,264 897,244 824,999 1,164,804 341,888 - 1,028,335 1,028,335 a) State Grant projection adjusted to actual FY 2010 contract. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. d) Projection based on currently unfilled positons and anticipated reduction in budgeted FTE. Year End Budget Projection Variance $ 900,000 $ 1,143,354 $ 243,354 100% 127% $ 900,000 $ 1,143,354 $ 243,354 333 (333) 8% 0% 4,000 4,000 151,854 136,973 (14,881) 8% 8% a) 1,822,242 1,688,146 (134,096) 2,895 - (2,895) 8% 0% 34,737 34,737 17,770 9,152 (8,618) 8% 4% 213,240 213,240 25,250 24,596 (654) 8% 8% 303,000 303,000 39,583 - (39,583) 8% 0% b) 475,000 475,000 - 21,833 21,833 8% n/a c) 21,833 21,833 11,150 11,443 293 8% 9% 133,800 133,800 12,679 12,937 258 8% 9% 152,150 152,150 3,000 2,820 (180) 8% 8% 36,000 36,000 8,167 9,415 1,248 8% 10% 98,000 98,000 3,167 1,611 (1,556) 8% 4% 38,000 38,000 733 1,212 479 8% 14% 8,800 8,800 10,981 (10,981) 8% 0% 131,774 131,774 2,250 2,250 8% 8% 27,000 27,000 289,812 234,242 (55,570) 8% 7% 3,477,743 3,365,480 (112,263) 2,083 (2,083) 8% 0% 25,000 25,000 193,147 193,147 8% 8% 2,317,765 2,317,765 1,385,042 1,570,743 187,784 8% 23% 6,720,508 6,851,599 131,091 REQUIREMENTS: Expenditures Personal Services 368,961 Materials and Services 119,031 Capital Outlay 1,409 Transfers Out 12,500 Contingency 58,142 TOTAL REQUIREMENTS NET (Resources - Requirements) 335,410 70,529 33,551 48,502 1,409 12,500 58,142 8% Soda Exp. % 8% d) 4,427,529 4,227,991 199,538 5%a 1,428,371 1,428,371 8% 0% 16,902 16,902 8% 0% 150,000 150,000 8% n/a 697,706 697,706 560,043 405,939 154,104 8% 6% 6,720,508 5,823,264 897,244 824,999 1,164,804 341,888 - 1,028,335 1,028,335 a) State Grant projection adjusted to actual FY 2010 contract. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. d) Projection based on currently unfilled positons and anticipated reduction in budgeted FTE. RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Donations Interfund Contract Administrative Fee Comm. on Children & Fam Crime Prevention Services Total Revenues Transfers In -General Fund Transfers In -Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) MENTAL HEALTH Statement of Financial Operating Data One Month Ended July 31, 2009 $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) 458 10,417 167 8,318 384,270 15,393 25,059 8,833 5,833 3,400 20,625 958 2,667 1,375 250 260 252,913 1,833 10,583 830 372 8% 10,519 102 8% 10 (157) 8% - (8,318) 8% 569,407 185,137 8% (15,393) 8% - (25,059) 8% (8,833) 8% - (5,833) 8% 138 (3,262) 8% - (20,625) 8% 430 (528) 8% 4,225 1,558 8% (1,375) 8% 7,000 6,750 8% - (260) 8% 245,413 (7,500) (1,833) (10,583) 8% 8% 8% 15% 8% 1% 0% 12% a) 0% 0% 0% 0% 0% 0% 4% 13% 0% 233% 0% 8% 0% 0% 5,500 125,000 2,000 99,819 4,611,239 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 3,000 3,120 3,034,954 22,000 127,000 5,500 125,000 2,000 99,819 5,351,224 739,985 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 7,000 4,000 3,120 3,031,954 (3,000) 22,000 127,000 753,612 837,972 84,360 8% 9% 9,043,353 9,784,338 740,985 109,680 21,303 109,680 21,303 8% 8% 3,609,595 3,558,951 (50,644) 8% 595,771 337,793 6,667 12,500 158,949 577,705 145,569 18,066 8% 192,224 6,667 8% 12,500 8% 158,949 8% 8% 1,111,680 723,274 388,406 8% 2,497,915 2,835,677 337,762 a) Dept of Human Services Grant projected at amended contract for FY 2010. 8% 8% 1,316,158 255,636 1,316,158 363,129 107,493 27% 13, 340,147 14, 053, 621 713,474 Exp. % 8% 4% 0% 0% n/a 5% 7,149,249 4,053,514 80,000 150,000 1,907,384 7,149,249 4,053,514 80,000 150,000 13, 340 ,147 11, 432, 763 1,907,384 1,907,384 - 2,620,858 2,620,858 Year to Date Budget Actual Variance FY % Coll. % $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) 458 10,417 167 8,318 384,270 15,393 25,059 8,833 5,833 3,400 20,625 958 2,667 1,375 250 260 252,913 1,833 10,583 830 372 8% 10,519 102 8% 10 (157) 8% - (8,318) 8% 569,407 185,137 8% (15,393) 8% - (25,059) 8% (8,833) 8% - (5,833) 8% 138 (3,262) 8% - (20,625) 8% 430 (528) 8% 4,225 1,558 8% (1,375) 8% 7,000 6,750 8% - (260) 8% 245,413 (7,500) (1,833) (10,583) 8% 8% 8% 15% 8% 1% 0% 12% a) 0% 0% 0% 0% 0% 0% 4% 13% 0% 233% 0% 8% 0% 0% 5,500 125,000 2,000 99,819 4,611,239 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 3,000 3,120 3,034,954 22,000 127,000 5,500 125,000 2,000 99,819 5,351,224 739,985 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 7,000 4,000 3,120 3,031,954 (3,000) 22,000 127,000 753,612 837,972 84,360 8% 9% 9,043,353 9,784,338 740,985 109,680 21,303 109,680 21,303 8% 8% 3,609,595 3,558,951 (50,644) 8% 595,771 337,793 6,667 12,500 158,949 577,705 145,569 18,066 8% 192,224 6,667 8% 12,500 8% 158,949 8% 8% 1,111,680 723,274 388,406 8% 2,497,915 2,835,677 337,762 a) Dept of Human Services Grant projected at amended contract for FY 2010. 8% 8% 1,316,158 255,636 1,316,158 363,129 107,493 27% 13, 340,147 14, 053, 621 713,474 Exp. % 8% 4% 0% 0% n/a 5% 7,149,249 4,053,514 80,000 150,000 1,907,384 7,149,249 4,053,514 80,000 150,000 13, 340 ,147 11, 432, 763 1,907,384 1,907,384 - 2,620,858 2,620,858 Year End Budget Projection Variance $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) 458 10,417 167 8,318 384,270 15,393 25,059 8,833 5,833 3,400 20,625 958 2,667 1,375 250 260 252,913 1,833 10,583 830 372 8% 10,519 102 8% 10 (157) 8% - (8,318) 8% 569,407 185,137 8% (15,393) 8% - (25,059) 8% (8,833) 8% - (5,833) 8% 138 (3,262) 8% - (20,625) 8% 430 (528) 8% 4,225 1,558 8% (1,375) 8% 7,000 6,750 8% - (260) 8% 245,413 (7,500) (1,833) (10,583) 8% 8% 8% 15% 8% 1% 0% 12% a) 0% 0% 0% 0% 0% 0% 4% 13% 0% 233% 0% 8% 0% 0% 5,500 125,000 2,000 99,819 4,611,239 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 3,000 3,120 3,034,954 22,000 127,000 5,500 125,000 2,000 99,819 5,351,224 739,985 184,716 300,705 106,000 70,000 40,800 247,500 11,500 32,000 16,500 7,000 4,000 3,120 3,031,954 (3,000) 22,000 127,000 753,612 837,972 84,360 8% 9% 9,043,353 9,784,338 740,985 109,680 21,303 109,680 21,303 8% 8% 3,609,595 3,558,951 (50,644) 8% 595,771 337,793 6,667 12,500 158,949 577,705 145,569 18,066 8% 192,224 6,667 8% 12,500 8% 158,949 8% 8% 1,111,680 723,274 388,406 8% 2,497,915 2,835,677 337,762 a) Dept of Human Services Grant projected at amended contract for FY 2010. 8% 8% 1,316,158 255,636 1,316,158 363,129 107,493 27% 13, 340,147 14, 053, 621 713,474 Exp. % 8% 4% 0% 0% n/a 5% 7,149,249 4,053,514 80,000 150,000 1,907,384 7,149,249 4,053,514 80,000 150,000 13, 340 ,147 11, 432, 763 1,907,384 1,907,384 - 2,620,858 2,620,858 COMMUNITY DEVELOPMENT Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY Coll. % RESOURCES: Beg. Net Working Capital $ 413,471 $ 626,973 $ 213,502 100% 152% $ 413,471 $ 626,973 213,502 Revenues Admin -Operations 304 2,418 2,114 8% 66% a) 3,650 3,650 Admin -GIS 173 (173) 8% 0% b) 2,075 2,075 Admin -Code Enforcement 15,788 13,712 (2,076) 8% 7% 189,450 189,450 Building Safety 81,231 60,774 (20,457) 8% 6% 974,775 974,775 Electrical 23,375 21,535 (1,840) 8% 8% 280,500 280,500 Contract Services 21,292 3,015 (18,277) 8% 1% c) 255,500 255,500 Env Health -On Site Prog 24,404 17,900 (6,504) 8% 6% 292,850 292,850 Env Health-Lic Facilities 57,540 28,775 (28,765) 8% 4% d) 690,475 690,475 Env Health - Drinking H2O 7,943 (7,943) 8% 0% e) 95,311 95,311 Planning -Current 82,013 94,289 12,276 8% 10% 984,150 984,150 Planning -Long Range 35,742 18,465 (17,277) 8% 4% 428,900 428,900 Total Revenues 349,805 260,883 (88,922) 8% 6% 4,197,636 4,197,636 Trans In -GF 101,386 101,386 - 0% n/a 1,216,627 1,216,627 Trans In -GF for Lng Rng Ping 25,000 - (25,000) 0% n/a 300,000 300,000 Trans In -Other 8 - (8) 0% 0% 100 (100) TOTAL RESOURCES 889,670 989,242 99,572 8% 16% 6,127,834 6,341,236 213,402 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 Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency Exp. % 142,343 143,004 (661) 8% 8% 1,708,112 1,708,112 17,967 16,793 1,174 8% 8% 215,606 215,606 15,081 14,482 599 8% 8% 180,969 180,969 60,429 58,272 2,157 8% 8% 725,145 725,145 17,227 16,064 1,163 8% 8% 206,719 206,719 22,065 20,772 1,293 8% 8% 264,781 264,781 20,057 18,945 1,112 8% 8% 240,687 240,687 41,329 40,497 832 8% 8% 495,946 495,946 6,717 6,411 306 8% 8% 80,598 80,598 67,482 56,832 10,650 8% 7% 809,783 809,783 45,986 33,852 12,134 8% 6% 551,828 551,828 14,805 14,805 0% 0% 177,660 177,660 39,167 39,167 8% n/a 470,000 470,000 TOTAL REQUIREMENTS 510,655 425,924 84,731 8% 7% 6,127,834 5,657,834 470,000 NET (Resources - Requirements) Revenues Expenditures Net from Operations 379,015 563,318 184,303 260,883 425,924 683,402 683,402 4,197,636 5,657,834 (165,041) (1,460,198) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Payments for custom GIS work are received as work is requested. c) Revenue is received as clients are billed, usually lagging 1-2 months behind. d) Revenue is received primarily in December through February after license renewal statements are mailed out. e) The State has not yet been invoiced for contracted work. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 413,471 $ 626,973 $ 213,502 100% 152% $ 413,471 $ 626,973 213,502 Revenues Admin -Operations 304 2,418 2,114 8% 66% a) 3,650 3,650 Admin -GIS 173 (173) 8% 0% b) 2,075 2,075 Admin -Code Enforcement 15,788 13,712 (2,076) 8% 7% 189,450 189,450 Building Safety 81,231 60,774 (20,457) 8% 6% 974,775 974,775 Electrical 23,375 21,535 (1,840) 8% 8% 280,500 280,500 Contract Services 21,292 3,015 (18,277) 8% 1% c) 255,500 255,500 Env Health -On Site Prog 24,404 17,900 (6,504) 8% 6% 292,850 292,850 Env Health-Lic Facilities 57,540 28,775 (28,765) 8% 4% d) 690,475 690,475 Env Health - Drinking H2O 7,943 (7,943) 8% 0% e) 95,311 95,311 Planning -Current 82,013 94,289 12,276 8% 10% 984,150 984,150 Planning -Long Range 35,742 18,465 (17,277) 8% 4% 428,900 428,900 Total Revenues 349,805 260,883 (88,922) 8% 6% 4,197,636 4,197,636 Trans In -GF 101,386 101,386 - 0% n/a 1,216,627 1,216,627 Trans In -GF for Lng Rng Ping 25,000 - (25,000) 0% n/a 300,000 300,000 Trans In -Other 8 - (8) 0% 0% 100 (100) TOTAL RESOURCES 889,670 989,242 99,572 8% 16% 6,127,834 6,341,236 213,402 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 Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency Exp. % 142,343 143,004 (661) 8% 8% 1,708,112 1,708,112 17,967 16,793 1,174 8% 8% 215,606 215,606 15,081 14,482 599 8% 8% 180,969 180,969 60,429 58,272 2,157 8% 8% 725,145 725,145 17,227 16,064 1,163 8% 8% 206,719 206,719 22,065 20,772 1,293 8% 8% 264,781 264,781 20,057 18,945 1,112 8% 8% 240,687 240,687 41,329 40,497 832 8% 8% 495,946 495,946 6,717 6,411 306 8% 8% 80,598 80,598 67,482 56,832 10,650 8% 7% 809,783 809,783 45,986 33,852 12,134 8% 6% 551,828 551,828 14,805 14,805 0% 0% 177,660 177,660 39,167 39,167 8% n/a 470,000 470,000 TOTAL REQUIREMENTS 510,655 425,924 84,731 8% 7% 6,127,834 5,657,834 470,000 NET (Resources - Requirements) Revenues Expenditures Net from Operations 379,015 563,318 184,303 260,883 425,924 683,402 683,402 4,197,636 5,657,834 (165,041) (1,460,198) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Payments for custom GIS work are received as work is requested. c) Revenue is received as clients are billed, usually lagging 1-2 months behind. d) Revenue is received primarily in December through February after license renewal statements are mailed out. e) The State has not yet been invoiced for contracted work. RESOURCES: Beg. Net Working Capital Revenues Federal Reimbursements Mineral Lease Royalties Forest Receipts State Grant 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 Interfund Contract Equipment Repairs Vehicle Repairs Vegetation Management Inter -fund: Forester Car Washes Sale of Eqp & Material Total Revenues ROAD Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 4,871,665 40,833 833 206,833 34,623 666,667 18,750 20,833 833 833 42 10,833 83 4,167 58,333 22,917 7,500 2,917 1,833 208 66,667 Budget Year End Projection Variance $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 589,104 114 551 7,914 (40,833) (833) (206,833) (34,623) (77,563) (18,750) (20,833) (833) (833) 72 (10,282) (83) 3,747 (58,333) (22,917) (7,500) (2,917) (1,833) (208) 64 (66,603) 1,166,538 Trans In - CDD 1,516 Trans In - Solid Waste 59,047 Trans In - Transp SDC 6,250 Trans In -Road Imp Res 833 8% 0% 490,000 490,000 8% 0% 10,000 10,000 8% 0% a) 2,482,000 2,482,000 8% 0% 415,477 415,477 8% 7% 8,000,000 8,000,000 8% 0% b) 225,000 225,000 8% 0% b) 250,000 250,000 8% 0% b) 10,000 10,000 8% n/a b) 10,000 10,000 8% n/a 500 500 8% 0% 130,000 130,000 8% 0% 1,000 1,000 8% 16% 50,000 50,000 8% 0% c) 700,000 700,000 8% 0% 275,000 275,000 8% 0% c) 90,000 90,000 8% 0% c) 35,000 35,000 8% 0% c) 22,000 22,000 8% 0% 2,500 2,500 8% 0% 800,000 800,000 597,747 (568,791) 8% 4% 13,998,477 13,998,477 (1,516) (59,047) (6,250) (833) TOTAL RESOURCES 6,099,599 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 5,489,396 (610,203) 8% 8% 8% 8% 0% 18,190 18,190 0% d) 708,567 708,567 0% 75,000 75,000 0% c) 10,000 10,000 8% 31% 19,681,899 19,701,883 19,984 Exp. % 472,114 444,270 27,844 8% 8% 5,665,373 5,665,373 - 761,101 330,614 430,487 8% 4% 9,133,210 9,133,210 - 225,000 225,000 8% 0% 2,700,000 2,700,000 33,333 33,333 8% 0% 400,000 400,000 148,610 148,610 8% n/a 1,783,316 1,783,316 1,640,158 774,884 865,274 NET (Resources - Requirements) 4,459,441 4,714,512 255,071 a) Annual payment anticipated to be received in December 09. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, 430 . d) Payment received quarterly from Solid Waste. 8% 4% 19,681,899 17,898,583 1,783,316 1,803,300 1,803,300 ADULT PAROLE & PROBATION Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% Revenues State Miscellaneous 667 (667) 8% 0% a) 8,000 4,301 (3,699) State Subsidy 2,458 3,327 869 8% n/a 29,500 29,500 SB 1145 236,660 725,750 489,090 8% 26% b) 2,839,925 2,839,925 Probation Work Crew Fees 3,333 1,970 (1,363) 8% 5% c) 40,000 40,000 Miscellaneous 250 255 5 8% 9% 3,000 3,000 Electronic Monitoring Fee 13,333 11,344 (1,989) 8% 7% 160,000 160,000 Probation Superv. Fees 18,333 23,437 5,104 8% 11% 220,000 220,000 Interest on Investments 750 1,143 393 8% 13% 9,000 9,000 Crime Prevention Services 4,167 (4,167) 8% n/a 50,000 50,000 Total Revenues 279,951 767,226 487,275 8% 23% 3,359,425 3,355,726 (3,699) $ 467,892 $ 487,674 $ 19,782 Transfers In -General Fund Transfers In -Sheriff TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 9,586 9,586 8% 8% 115,029 115,029 4,167 (4,167) 8% 0% 50,000 50,000 761,596 1,264,486 502,890 8% 32% 3,992,346 4,008,429 16,083 Exp. % 238,227 227,252 10,975 8% 8% 2,858,726 2,858,726 58,677 40,778 17,899 8% 6% 704,121 704,121 8 8 8% 0% 100 100 35,783 35,783 8% n/a 429,399 TOTAL REQUIREMENTS 332,695 268,030 64,665 8% NET (Resources - Requirements) 7% 429,399 3,992,346 3,562,947 429,399 428,901 996,456 567,555 445,482 445,482 a) Have not received the hearings officer funds for this quarter. The $8,000 budgeted was for the biennium, actual should be $4,301. b) 1145 money has been received for the quarter. c) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients. Year End Budget Projection Variance $ 467,892 $ 487,674 $ 19,782 Transfers In -General Fund Transfers In -Sheriff TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 9,586 9,586 8% 8% 115,029 115,029 4,167 (4,167) 8% 0% 50,000 50,000 761,596 1,264,486 502,890 8% 32% 3,992,346 4,008,429 16,083 Exp. % 238,227 227,252 10,975 8% 8% 2,858,726 2,858,726 58,677 40,778 17,899 8% 6% 704,121 704,121 8 8 8% 0% 100 100 35,783 35,783 8% n/a 429,399 TOTAL REQUIREMENTS 332,695 268,030 64,665 8% NET (Resources - Requirements) 7% 429,399 3,992,346 3,562,947 429,399 428,901 996,456 567,555 445,482 445,482 a) Have not received the hearings officer funds for this quarter. The $8,000 budgeted was for the biennium, actual should be $4,301. b) 1145 money has been received for the quarter. c) Courts are diverting some offenders to monitored probation to monitor community service, reduction in clients. RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Child Care Block Grant Level 7 Services HealthyStart /R -S -G OCCF Grant Miscellaneous Court Fines & Fees Interest on Investments Grants -Private Miscellaneous Crime Prevention Services Total Revenues COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % CoII. % Budget Year End Projection Variance $ 624,543 $ 671,859 $ 47,316 100% 108% $ 624,543 $ 671,859 $ 47,316 18,750 3,138 7,917 6,773 14,599 25,631 51,171 667 6,250 2,500 167 15,625 6,196 41 6,311 1,084 (18,750) (3,138) (7,917) (6,773) (14,599) (25,631) (51,171) (626) 61 (1,416) (167) (15,625) (6,196) 159,384 7,436 (151,948) Trans from General Fund 23,694 23,694 Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 23,694 23,694 8% 0% 225,000 225,000 8% 0% 37,652 37,652 8% 0% 95,000 95,000 0% 81,275 81,275 8% 0% 175,193 175,193 8% 0% 307,577 307,577 8% 0% 614,052 614,052 8% 1% 8,000 8,000 8% 8% 75,000 75,000 8% 4% 30,000 30,000 8% 0% 2,000 2,000 8% n/a 187,500 187,500 8% 0% 74,350 74,350 8% 8% 0% 1,912,599 1,912,599 8% 8% 8% 8% 284,333 284,333 284,333 284,333 807,621 702,989 (104,632) 8% 25% 2,821,475 2,868,791 47,316 44,998 147,920 8 42,196 Exp. % 38,866 6,132 8% 7% 10,764 137,156 8% 1% - 8 8% 0% 42,196 8% n/a 235,122 49,630 185,492 8% 2% 572,499 653,359 539,978 1,775,043 100 506,354 539,978 1,775,043 100 506,354 2,821,475 2,315,121 506,354 80,860 553,670 553,670 SOLID WASTE Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 Revenues Miscellaneous 2,500 2,387 Franchise 3% Fees 16,667 2,461 Commercial Disp. Fees 116,367 81,486 Private Disposal Fees 128,442 143,425 Franchise Disposal Fees 395,292 455,401 Yard Debris 6,250 7,575 Special Waste 2,500 100 Interest 1,167 1,430 Sale of Equip & Material 2,917 1,650 (113) (14,206) (34,881) 14,983 60,109 1,325 (2,400) 263 (1,267) Total Revenues 672,102 695,915 23,813 100% 138% $ 338,611 $ 466,325 $ 127,714 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% TOTAL RESOURCES 1,010,713 1,162,240 151,527 8% REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 146,965 312,355 80,730 12,417 119,981 27,871 136,003 10,962 112,734 199,621 80,730 - 12,417 - 119,981 27,871 8% 8% 8% 8% 8% 8% TOTAL REQUIREMENTS 700,319 248,737 451,582 8% NET (Resources - Requirements) 310,394 913,503 603,109 8% 1% a) 6% 9% 10% 10% 0% b) 10% 5% c) 9% 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 8,065,200 8,065,200 14% 8,403,811 8,531,525 127,714 Exp. % 8% 3% d) 0% e) 0% f) 0% nfa 1,763, 578 3,748,254 968,765 149,000 1,439,767 334,447 1,763,578 3,748,254 968,765 149,000 1,439,767 334,447 3% 8,403,811 8,069,364 334,447 462,161 462,161 a) Due April 15, 2010. b) Contaminated soil and asbestos loads are intermittent. c) Revenue is largely contingent on recycling prices which are down at this time. d) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY. e) Payments are scheduled for Nov and May. f) Capital item purchases are spread out throughout the fiscal year. Year End Budget Projection Variance 100% 138% $ 338,611 $ 466,325 $ 127,714 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% TOTAL RESOURCES 1,010,713 1,162,240 151,527 8% REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 146,965 312,355 80,730 12,417 119,981 27,871 136,003 10,962 112,734 199,621 80,730 - 12,417 - 119,981 27,871 8% 8% 8% 8% 8% 8% TOTAL REQUIREMENTS 700,319 248,737 451,582 8% NET (Resources - Requirements) 310,394 913,503 603,109 8% 1% a) 6% 9% 10% 10% 0% b) 10% 5% c) 9% 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 30,000 200,000 1,396,400 1,541,300 4,743,500 75,000 30,000 14,000 35,000 8,065,200 8,065,200 14% 8,403,811 8,531,525 127,714 Exp. % 8% 3% d) 0% e) 0% f) 0% nfa 1,763, 578 3,748,254 968,765 149,000 1,439,767 334,447 1,763,578 3,748,254 968,765 149,000 1,439,767 334,447 3% 8,403,811 8,069,364 334,447 462,161 462,161 a) Due April 15, 2010. b) Contaminated soil and asbestos loads are intermittent. c) Revenue is largely contingent on recycling prices which are down at this time. d) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the FY. e) Payments are scheduled for Nov and May. 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 One Month Ended July 31, 2009 Year to Date Budget Actual Variance % of FY Coll. $2,491,977 12,669,291 5177,314 100% 107% 52,491,977 $2,669,291 $177,314 38,080 38,079 (1) 8% 8% 456,964 456,964 23,858 23,842 (16) 8% 8% 286,294 286,294 15,350 15,350 0 8% 8% 184,195 184,195 71,321 71,320 (1) 8% 8% 855,854 855,854 13,349 13,350 1 8% 8% 160,191 160,191 2,083 - (2,083) 8% 0% 25,000 25,000 833 - (833) 8% 0% 10,000 10,000 75 175 100 8% 19% 900 900 333 12 (321) 8% 0% 4,000 4,000 1,833 - (1,833) 8% 0% 22,000 22,000 2,500 4,306 1,806 8% 14% 30,000 30,000 169,617 166,434 (3,182) 8% 8% 2,035,398 2,035,398 Transfers In -PERS Reserve 8 - (8) 8% 0% 100 (100) TOTAL RESOURCES 2,661,602 2,835,725 174,123 8% 63% 4,527,475 4,704,689 177,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 677 Defense - Miscellaneous Professional Service - Insurance 1,418 Loss Prevention 13 Repair / Replacement - Total General Liability 30,426 2,108 30,426 8% 1% 365,112 365,112 PROPERTY DAMAGE Insurance Professional Service - Repair / Replacement 6,777 Total Property Damage 25,000 6,777 25,000 8% 2% 300,000 300,000 VEHICLE Professional Service Repair / Replacement Insurance - Loss Prevention 87 Repair / Replacement 355 Total Vehicle 10,000 442 10,000 8% 0% 120,000 120,000 WORKERS' COMPENSATION Settlement / Benefit 44,080 Professional Service Insurance 61,773 Loss Prevention Miscellaneous Workers' Comp Losses - Total Workers' Compensation 51,667 105,853 51,667 8% 17% 620,000 620,000 UNEMPLOYMENT - Settlement / Benefits 11,667 - 11,667 8% 0% 140,000 145,000 (5,000) % Exp. Total Direct Insurance Costs 128,759 115,180 128,759 8% 7% 1,545,112 1,550,112 (5,000) Insurance Administration: Personal Services 22,836 22,460 376 8% 8% 274,034 274,034 Materials & Service 20,541 15,162 5,379 8% 6% 246,493 246,493 Capital Outlay 8 - 8 8% 0% 100 - 100 Total Insurance Administration 43,386 37,622 5,763 8% 7% 520,627 520,527 100 Contingency 205,145 205,145 8% n/a 2,461,736 - 2,461,736 TOTAL APPROPRIATIONS/EXPENDITURES 377,290 152,802 339,667 8% 3% 4,527,475 2,070,639 2,456,836 NET 2,284,312 2,682,923 513,790 2,634,050 2,634,050 Year End Budget ProLection Variance $2,491,977 12,669,291 5177,314 100% 107% 52,491,977 $2,669,291 $177,314 38,080 38,079 (1) 8% 8% 456,964 456,964 23,858 23,842 (16) 8% 8% 286,294 286,294 15,350 15,350 0 8% 8% 184,195 184,195 71,321 71,320 (1) 8% 8% 855,854 855,854 13,349 13,350 1 8% 8% 160,191 160,191 2,083 - (2,083) 8% 0% 25,000 25,000 833 - (833) 8% 0% 10,000 10,000 75 175 100 8% 19% 900 900 333 12 (321) 8% 0% 4,000 4,000 1,833 - (1,833) 8% 0% 22,000 22,000 2,500 4,306 1,806 8% 14% 30,000 30,000 169,617 166,434 (3,182) 8% 8% 2,035,398 2,035,398 Transfers In -PERS Reserve 8 - (8) 8% 0% 100 (100) TOTAL RESOURCES 2,661,602 2,835,725 174,123 8% 63% 4,527,475 4,704,689 177,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 677 Defense - Miscellaneous Professional Service - Insurance 1,418 Loss Prevention 13 Repair / Replacement - Total General Liability 30,426 2,108 30,426 8% 1% 365,112 365,112 PROPERTY DAMAGE Insurance Professional Service - Repair / Replacement 6,777 Total Property Damage 25,000 6,777 25,000 8% 2% 300,000 300,000 VEHICLE Professional Service Repair / Replacement Insurance - Loss Prevention 87 Repair / Replacement 355 Total Vehicle 10,000 442 10,000 8% 0% 120,000 120,000 WORKERS' COMPENSATION Settlement / Benefit 44,080 Professional Service Insurance 61,773 Loss Prevention Miscellaneous Workers' Comp Losses - Total Workers' Compensation 51,667 105,853 51,667 8% 17% 620,000 620,000 UNEMPLOYMENT - Settlement / Benefits 11,667 - 11,667 8% 0% 140,000 145,000 (5,000) % Exp. Total Direct Insurance Costs 128,759 115,180 128,759 8% 7% 1,545,112 1,550,112 (5,000) Insurance Administration: Personal Services 22,836 22,460 376 8% 8% 274,034 274,034 Materials & Service 20,541 15,162 5,379 8% 6% 246,493 246,493 Capital Outlay 8 - 8 8% 0% 100 - 100 Total Insurance Administration 43,386 37,622 5,763 8% 7% 520,627 520,527 100 Contingency 205,145 205,145 8% n/a 2,461,736 - 2,461,736 TOTAL APPROPRIATIONS/EXPENDITURES 377,290 152,802 339,667 8% 3% 4,527,475 2,070,639 2,456,836 NET 2,284,312 2,682,923 513,790 2,634,050 2,634,050 Health Benefits Trust Statement of Financial Operating Data One Month Ended July 31, 2009 Revised Budget* Year End 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 873,333 872,658 (676) 8% 8% a) 10,480,000 10,471,895 (8,105) PIT Emp - Addi Prem 4,583 4,319 (264) 8% 8% 55,000 55,000 Employee Prem Contribution 27,500 28,280 780 8% 9% 330,000 330,000 COIC 83,333 92,083 8,750 8% 9% 1,000,000 1,000,000 Retiree / COBRA Co -Pay 41,667 50,423 8,756 8% 10% 500,000 500,000 Interest 18,750 26,346 7,596 8% 12% 225,000 225,000 Total Revenues 1,049,167 1,074,110 24,943 8% 9% 12,590,000 12,581,895 (8,105) 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 18,943,964 18,968,906 24,943 92% 62% 30,484,797 30,476,692 (8,105) 9,108 8,625 483 8% Exp. % 8% 109,297 109,297 250 315 (65) 8% 11% 3,000 3,000 1,187,298 1,153,193 34,105 8% 8% b) 14,247,576 11,993,210 2,254,366 151,833 154,355 (2,522) 8% 8% b) 1,822,000 1,605,292 216,708 (4,735) 4,735 8% n/a (4,735) 4,735 31,045 30,611 434 8% 8% 372,540 372,540 958 68,989 (68,030) 8% n/a c) 11,500 11,500 24,397 23,183 1,214 8% 8% 292,764 292,764 6,804 2,919 3,885 8% 4% 81,648 81,648 4,131 4,135 (4) 8% 8% 49,572 49,572 833 833 8% 0% 10,000 10,000 8,333 8,333 8% 0% 100,000 100,000 2,422 2,059 362 8% 7% 29,059 29,059 1,418,305 1,435,024 -16,719 8% 8% 17,019,659 14,543,849 2,475,810 - 8% 0% 100 100 1,112,978 1,112,978 8% 0% 13,355,741 13,355,741 TOTAL REQUIREMENTS 2,540,391 1,443,649 1,096,743 8% 5% 30,484,797 14,653,146 15,831,651 NET (Resources - Requirements) * 16,403,572 17,525,258 1,121,685 - 15,823,545 15,823,545 * Proposed revisions to FY 2010 original budget a) Amount budgeted to be transferred from operating funds for FY 2010. b) Based on annualizing 5 weeks of claims paid. $261,510 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. Year to Date Budget Actual Variance FY % Coll. % Revised Budget* Year End 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 873,333 872,658 (676) 8% 8% a) 10,480,000 10,471,895 (8,105) PIT Emp - Addi Prem 4,583 4,319 (264) 8% 8% 55,000 55,000 Employee Prem Contribution 27,500 28,280 780 8% 9% 330,000 330,000 COIC 83,333 92,083 8,750 8% 9% 1,000,000 1,000,000 Retiree / COBRA Co -Pay 41,667 50,423 8,756 8% 10% 500,000 500,000 Interest 18,750 26,346 7,596 8% 12% 225,000 225,000 Total Revenues 1,049,167 1,074,110 24,943 8% 9% 12,590,000 12,581,895 (8,105) 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 18,943,964 18,968,906 24,943 92% 62% 30,484,797 30,476,692 (8,105) 9,108 8,625 483 8% Exp. % 8% 109,297 109,297 250 315 (65) 8% 11% 3,000 3,000 1,187,298 1,153,193 34,105 8% 8% b) 14,247,576 11,993,210 2,254,366 151,833 154,355 (2,522) 8% 8% b) 1,822,000 1,605,292 216,708 (4,735) 4,735 8% n/a (4,735) 4,735 31,045 30,611 434 8% 8% 372,540 372,540 958 68,989 (68,030) 8% n/a c) 11,500 11,500 24,397 23,183 1,214 8% 8% 292,764 292,764 6,804 2,919 3,885 8% 4% 81,648 81,648 4,131 4,135 (4) 8% 8% 49,572 49,572 833 833 8% 0% 10,000 10,000 8,333 8,333 8% 0% 100,000 100,000 2,422 2,059 362 8% 7% 29,059 29,059 1,418,305 1,435,024 -16,719 8% 8% 17,019,659 14,543,849 2,475,810 - 8% 0% 100 100 1,112,978 1,112,978 8% 0% 13,355,741 13,355,741 TOTAL REQUIREMENTS 2,540,391 1,443,649 1,096,743 8% 5% 30,484,797 14,653,146 15,831,651 NET (Resources - Requirements) * 16,403,572 17,525,258 1,121,685 - 15,823,545 15,823,545 * Proposed revisions to FY 2010 original budget a) Amount budgeted to be transferred from operating funds for FY 2010. b) Based on annualizing 5 weeks of claims paid. $261,510 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. DESCHUTES COUNTY 911 Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance % of FY % Coll. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $5,137,000 $ 5,616,955 $ 479,955 100% 109% $5,137,000 $5,616,955 $ 479,955 Revenues Property Taxes - Current 510,899 (510,899) 8% 0% a) 6,130,782 6,130,782 Property Taxes - Prior 8,333 43,201 34,868 8% 43% 100,000 100,000 State Reimbursement 2,042 725 (1,317) 8% 3% b) 24,500 24,500 Telephone User Tax 44,667 (44,667) 8% 0% 536,000 536,000 Data Network Reimb. 2,833 (2,833) 8% 0% c) 34,000 34,000 Jefferson County 2,333 175 (2,158) 8% 1% 28,000 28,000 User Fee 5,042 (5,042) 8% 0% d) 60,500 60,500 Contract Payments 5,833 (5,833) 8% 0% c) 70,000 70,000 Miscellaneous 708 690 (18) 8% 8% 8,500 8,500 Interest 3,000 8,137 5,137 8% 23% 36,000 36,000 Interest on Unsegregated Tax 313 29 (284) 8% 1% 3,750 3,750 Total Revenues 586,003 52,957 (533,046) 8% 1% 7,032,032 7,032,032 Transfers In -Other 8 (8) 8% 0% 100 (100) TOTAL RESOURCES 5,723,003 5,669,912 (53,091) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 8% 47% 12,169,132 12,648,987 479,855 Exp. 318,024 308,637 9,387 8% 8% 3,816,287 3,816,287 107,460 84,431 23,029 8% 7% 1,289,522 1,289,522 14,583 - 14,583 8% 0% 175,000 175,000 161,578 161,578 8% 0% 1,938,939 1,938,939 412,449 412,449 8% n/a 4,949,384 - 4,949,384 TOTAL REQUIREMENTS 1,014,094 393,068 621,026 8% 3% 12,169,132 7,219,748 4,949,384 NET (Resources - Requirements) 4,708,909 5,276,844 567,935 - 5,429,239 5,429,239 a) Approximately 85% of the property taxes are collected in October and November. b) July payment (MSAG) is pending. c) Agencies have just been billed; awaiting receipts. d) U.S. Forest Service (quarterly) -payments are current. Crooked River Ranch (annual) -will be billed this month. COIDC (monthly Apr -Sept) -payments are current. 0� 0� 10' Oii M 010'x' r'. 0' 0 0'' I 10 CO OI(0'. M' 0 0 0 0' �'N r 1 CO NI O N N 'O a LL m N 7 Is N t)0) sic r 1 '.p 1, NN- ,00000000000I 0)I00't '1M li O O�lolco 0)I4)0 1N, SIO 0.0 0 0;010 0 O pp 1(O'O.OIr1 -rl 10,,,,,0,.., 'N 0'N N'. 1(1 t0 N 110 O; - -1(7, OIO N'. r (O SIO OI j0'a'O 0)11+ O V1 ' ails 001 i o I� N O -Is, 4) t01N Ito VI) V —I CO I40 t0 :(OiN (OI 'I -IN 0 1-'', (01.00 �ja-- ' 4), t01 Ii��N ',� 1r, C•41,:01: I 'OII x101, 0),NICO 0) ....,� riN jc0 t0 M V o 0:o'01010 O.0 0101 (0 aI �'0 0. ('100) c0� 0)4) 0 N CO,1I O O 010010'010',0 O O 1+) N'0) c0 ,- (0 01(V O N O,OIO O 1+110 O 1 I(0 (p" ' 11N r;. IN1a'0) 0).r 0'aj '.1,1-:1,' c014) 4)', LL') (V. 4)Ia 10l 0) Tr' 1N (O',,I(0 r'. N O r !(0'(D 1,7 !...:1''� t0 :�I(+)' a N (r)I ''.t4) 1NL a 0 0 1N. 011 (0 14) iC) �I `---1!..1. ,� al 0 v V' o 1,..t'' o I'o1 (0 105 10'ID , (V, IN'. ,N - , N, 1 1.o 1 yr 1 I ' 1 1 ' 1i � oM1 or ;71 ' 1 1 I '' 0 ' o:rI1M1 'o Cl 0 v 0I •- 10 a No'o 0 01)0,40 1— o1� r la N 001 (0 '0(71 '0.ppN- 1 �ro1v VI Oil 0 7, , 10. 0'O O �. 0 0l , 01,0101OI -'1I1 O O',O O NIN 11+) 0, 11' M 0 10 t0 CO '0) 0,,.'10'1 ' a) co r at, ' `,O N:c>...-,,,-, ' ' I0), ri N'11•:'I:. N)1 ''. O !M, 'O), ,'oilC'1 4)1 1 p) - 'co:'0, 1 ro. ''.' 101 'o a :4)1 cc I I I - 0' 0' 0 x''0: 0 1 0 'a,01 O 1.- 1101 1 of O.0 O O 10 N N 1+) O 'M 0), 1(0 o. 0 100 01 ''' 0201 100, 1- 1'')' O' 4.- ' o ' NIP 47 '0) j Iro M'. 101 1 'o:o :0� '01047 O 4) :NI 1 M', - O'0 0, :0,0,0- -, 0101,r 10 r' 11 M 0" ',M 0'. 00101' , O. "0'0471 ' I�r1M 11 rMI ' O :M ' rl Vj 'N V1 (O� O)''1 'O rn- IV:1 10' ro'1 '01 o,a C. -21X'2'8. (O+) '01'. •001 ' C40': l7' ",O IN . '0) 'O a (+1 M'' a 0-) r1 , rola, U N o 47 O I o a. , O ,r 'O(0 en 0 VI Of 04 CD (M7 ' N ',101 ((00'V (7 N, 0''. 0 0 0 0'41) a, 01I, 0 ''N T (O (7 0 (00 (O+) ' 0. "'O LC/ 01 0. CC) ''p' N1 CO Cl� .101'); V)' '(V' ' Is 4) (0 a 'M r 0). 0)i ' NI CO, Ti.. CO 4') 'a' O. O. OO L a � 0 M. co' 1''))' O, O M C)' 0 M '0 (O. r. 1 ' 0. , 101 •c DO 0. c•-2 , p, 00 ' ala'. N I O O'. 10V ('' 4 C r I ('M 1r. '7 r a : --- a O 0 0 a10 O 0 011 10 (O r (O/), 0,01 ,, 0I I ' filet. 1 CI :rs cc) , 0 � 0, 4'1, i i SI ',011 0) (0 1N1 031 0) 1 DOM IM' t0 ''r r' M' (0 N �N' CO (O 1N 0 �0� �N I 010 10 471 1a 01 r rN MI 10 O (0 O,,O ',O r 1') O' 1'7'0 M ''N ' 01 1100 4'- 1 0), 'N NI (041 01' IO '0 N'. 1 1 1N1 .,4711 r 101 1 a NI 1 O', 1- a ; 1 O 0 O (O 1N. . 0, ' , (M7 '',4)' r'i,c1) ' O ''', OI (O', I j IN '0, 101 N1' N 1 N, 0, ' 0) N E m Z .0 O O 1 0i '01 IS' O 10 O03,. O 0)' co ' I, OI M N (0 0 0' N', in M 011. • 0, O' Is • r N E d N N O o) To } U Q T M• ' ONf. a' 40 1r ! 1(01 01 1(Q. O (0 1 0 (u0+ O7 I.0 ' 1,1 0'. rfW N 1.1 ) + 11'0 00II1, 1r0 O) N 10.N1 ' DO ;00) IN.O.� ' ' ' ' M "' (7 co.I `41-:::1 c'- (0— 'M'I1 ,: (OI r Ir N,01, N1 '0) e n apt '10 10 M,0 (0 101` N1 t01N ' 001 , 00I N'01� ' , 1M'1 Oj (MO 1. 1 co vI V I, � 1', 1 ' ' ' :co: I, v1 0 m I^ a, rm_ 01 .0 C OI 1 U 2 a 1.)� a)U- �"1 31 N N ( m o O C V) ON W 3' 1-=--.0,,? -0 c ` C 'O L �c..7.,!... m •c c &Ucco U� E 'U>>>mI W m m m 1.W -> co: 012 ID O--,,ILL,„,,-,,_1 ,i'l o c m O 0a 11L c z °) `wu_ -7,07E ' c,, c y m 2 01 1Z V E� (DI � ac) o' m c > ails Gl m m CO c!3'm m L+ a1i U o, 1 t O)'L0 m ro; 1,2 D � ¢ �I� y1 lot o'. o ''1 1 's m�Fe15 01� 1 I �1 Iz RESOURCES: Beg, Net Working Capital Receipts: Security & Traffic Reimb Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Total Receipts Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data One Month Ended July 31, 2009 Year to Date Budget Actual Variance FY % Coll. Year End Budget Projection Variance $ 75,000 $ 42,232 $ (32,768) 100% 56% $ 75,000 $ 42,232 $ (32,768) 12,000 (12,000) 8% 0% 12,000 (12,000) - - 8% 0% 4,000 4,000 - 8% 0% 2,300 2,300 8% 0% 1,200 1,200 9,000 - (9,000) 8% 0% 540,000 531,000 (9,000) 168 167 (1) 8% 8% 2,000 1,999 (1) - 8% 0% 58,000 58,000 - 2,000 - (2,000) 8% 0% 7,000 5,000 (2,000) - - 8% 0% 45,000 45,000 - - 8% 0% 235,000 235,000 3,420 11,000 7,580 8% 13% 86,420 86,420 - 8% 0% 45,000 45,000 14,588 11,167 (3,421) 8% 1% 1,037,920 1,014,919 (23,001) 22,765 (22,765) 8% 0% 498,105 498,105 112,353 53,399 (58,954) 8% 3% 1,611,025 1,555,256 (55,769) Exp. % 68,724 63,571 5,153 8% 8% 824,769 819,606 5,163 44,277 18,286 25,991 8% 3% 531,604 531,604 (0) 8% 0% 116,188 116,188 - 8% 0% 100 - 100 8% 0% 16,412 16,412 - 8% n/a 121,952 121,952 113,001 81,857 31,144 8% 5% 1,611,025 1,483,810 127,215 (648) (28,458) (27,810) 71,445 71,445 Accrued Revenue (Accounts Receivable): Current Month Events Prior Months 565 Total Accounts Receivable 565 Deposits Received for Future Events: 2010: August 7,580 September 4,935 October 5,290 November 4,550 December 1,205 January 109 February 420' March 250 April 4,300 May 2,900 June 1,000 FY 2011 35,210 FY 2012 & Beyond 5,250 TOTAL 72,990 REVENUES Gate Receipts Carnival Commercial Exhibitors: Deschutes County Fair - Fund 619 Revenues and Expenses FAIR 2009 - July 29 to August 1, 2009 Fiscal Year 2010 400,000 154,000 281,425 123,197 Outside 70,000 82,395 Inside 38,000 42,700 Food 12,000 13,900 Livestock Entry Fees 4,000 4,598 RN Camping/Horse Stall Rental 17,000 17,600 Concessions: Food 146,850 63,709 50,000 113,709 Fair Sponsorship: Rodeo 23,000 19,350 - 19,350 84% (3,650) On -ground Stages 13,000 3,000 5,000 8,000 62% (5,000) Day 8,000 5,000 - 5,000 63% (3,000) Golf Carts 2,500 4,125 - 4,125 165% 1,625 Food Court 3,000 3,000 3,000 100% Concert 30,000 - 30,000 30,000 100% Presenting Sponsors 12,000 12,000 - 12,000 100% Barn Sponsors 6,000 3,400 3,400 57% (2,600) Parade Sponsors 4,800 4,800 N/A 4,800 Transfer In -General Fund 5,000 5,000 5,000 100% - T -Shirts 3,500 3,725 - 3,725 106% 225 Donations 13 - 13 N/A 13 State Grant 25,000 - 42,200 42,200 169% 17,200 Interest 2,000 259 259 13% (1,741) 3,680 4,900 2,000 285,105 128,097 84,395 42,700 13,900 4,598 17,600 71% (114895) 83% (25 903) 121% 112% 116% 115% 104% 77% 14 395 4 700 1.900 598 600 (33,141) TOTAL REVENUES 974,850 693,197 137,780 830,977 85% (143,873 EXPENSES Personnel 178,128 108,382 73,403 181,786 102% (3,658) Materials and Services 623,444 465,951 106,829 572,780 92% 50,664 Contingency 31,157 - - - 0% 31,157 TOTAL EXPENSES 832,729 574,333 180,232 754,565 91% 78,164 Net Fair - 2009 142,121 118,864 (42,452) 76,411 (65,710) Transfer to Fund 618 197,421 101,702 101,702 95,719 Retained in Annual Fair Fund (55,300) 118,864 (144,155) (25,291) 30,+109 Beg Net Working Capital 55,300 25,291 25,291 Ending Balance 144,155 (144,155) (0) Actual - Through FY 2010 Budget August 14, 2009 Additional Estimated Projected Total % of Budget Variance 400,000 154,000 281,425 123,197 Outside 70,000 82,395 Inside 38,000 42,700 Food 12,000 13,900 Livestock Entry Fees 4,000 4,598 RN Camping/Horse Stall Rental 17,000 17,600 Concessions: Food 146,850 63,709 50,000 113,709 Fair Sponsorship: Rodeo 23,000 19,350 - 19,350 84% (3,650) On -ground Stages 13,000 3,000 5,000 8,000 62% (5,000) Day 8,000 5,000 - 5,000 63% (3,000) Golf Carts 2,500 4,125 - 4,125 165% 1,625 Food Court 3,000 3,000 3,000 100% Concert 30,000 - 30,000 30,000 100% Presenting Sponsors 12,000 12,000 - 12,000 100% Barn Sponsors 6,000 3,400 3,400 57% (2,600) Parade Sponsors 4,800 4,800 N/A 4,800 Transfer In -General Fund 5,000 5,000 5,000 100% - T -Shirts 3,500 3,725 - 3,725 106% 225 Donations 13 - 13 N/A 13 State Grant 25,000 - 42,200 42,200 169% 17,200 Interest 2,000 259 259 13% (1,741) 3,680 4,900 2,000 285,105 128,097 84,395 42,700 13,900 4,598 17,600 71% (114895) 83% (25 903) 121% 112% 116% 115% 104% 77% 14 395 4 700 1.900 598 600 (33,141) TOTAL REVENUES 974,850 693,197 137,780 830,977 85% (143,873 EXPENSES Personnel 178,128 108,382 73,403 181,786 102% (3,658) Materials and Services 623,444 465,951 106,829 572,780 92% 50,664 Contingency 31,157 - - - 0% 31,157 TOTAL EXPENSES 832,729 574,333 180,232 754,565 91% 78,164 Net Fair - 2009 142,121 118,864 (42,452) 76,411 (65,710) Transfer to Fund 618 197,421 101,702 101,702 95,719 Retained in Annual Fair Fund (55,300) 118,864 (144,155) (25,291) 30,+109 Beg Net Working Capital 55,300 25,291 25,291 Ending Balance 144,155 (144,155) (0) RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service (Negative Int Rev) 100,000 4,074 95,926 8% 4% b) 100,000 8,274 91,726 Deschutes County Bethlehem Inn (Fund 128) One Month Ended July 31, 2009 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) 8% 0% 2,766,469 - (2,766,469) 2,766,469 - (2,766,469) 8% 0% 2,766,469 - (2,766,469) 100,000 (2,689,172) (2,789,172) 8% -2689% 100,000 (2,689,172) (2,789,172) Exp. % TOTAL REQUIREMENTS 100,000 4,074 95,926 8% 4% 100,000 8,274 91,726 NET (Resources - Requirements) - (2,693,246) (2,693,246) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) July interest expense was $4,074. • - (2,697,446) (2,697,446) 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) 8% 0% 2,766,469 - (2,766,469) 2,766,469 - (2,766,469) 8% 0% 2,766,469 - (2,766,469) 100,000 (2,689,172) (2,789,172) 8% -2689% 100,000 (2,689,172) (2,789,172) Exp. % TOTAL REQUIREMENTS 100,000 4,074 95,926 8% 4% 100,000 8,274 91,726 NET (Resources - Requirements) - (2,693,246) (2,693,246) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) July interest expense was $4,074. • - (2,697,446) (2,697,446) Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2009 (Final as of 8/4/2009) 8/4 2009 Jul Au• Se• Oct Nov Dec Jan Feb Mar A. Ma Jul YTD Total Tammy Baney _ Conf/Sem & Educ/Training - - , 2,300 314 - - 40 530 30 30 - - 3,244 Travel Meals - - - - - 40 I - - - 278 - - 318 Accommodations - - - , 238 ! - 363 - ' - - 1,503 - - 2,103 Airfare - - -- - - - - - 520 , - - 520 Mileage reimbursement _74 _- 91 278 117 453 104 87 - 471 - &' 4 2,269 Ground Transport - - - - - 24 ' - - - 122 - - 51447 146 Total Baney 74 2,391 1 830 117 880 144 617 30 2,923 - 8,600 Mike Daly Conf/Sem & Educ/Training - - 26 360 - - - - - - - - 386 Travel Meals - 396 - 12 - 29 - - - - - 437 Accommodations - - - 540 141 - - - - - 680 Airfare - - - - - 242 - 420 - 331 _- _ 18 - - - - - - - - - - 1,092 Mileage reimbursement - _ 82 Ground Transport - 44 - - - 15 - - - - - - 59 Total Daly 522 ! 26 1,154 561 374 18 - - - - 2,654 Dennis Luke Conf/Sem & Educ/Training - - 26 219 - - 260 70 30 - - 605 Travel Meals - - - - 25 66 25 25 25 - 25 4;1 242 Accommodations - - - 429 98 , 15 98 , 98 77 , - 77 1 `.4 1,046 Airfare - - - - - - _ - - - Mileage reimbursement - 85 137 246 239 ' 228 248 279 320 98 218 4s0 2,527 Ground Transport - - - - - - - - - - - - - Total Luke 85 163 895 362 308 631 472 ! 452 98 321 634 4,420 Alan Unger _ 97 47 Conf/Sem & Educ/Training - - - - - - - 70 70 10 - - - 247 Travel Meals - - - - - - - - - - - 47 Accommodations - - - - - - - - - - 375 - 375 Airfare - - - - - - Mileage reimbursement _ - - - _ - - - - - - - - 1,576 1,576 Ground Transport - - - - - - - Total Unger - - - - - - 70 70 10 - 2,095 2,245 BOCC Staff - - Conf/Sem & Educ/Training - - - - - - - - - - - Travel Meals - - _ - - - - -- - - - - - - Accommodations - - - _ - - - Airfare - - - - - - - - - - - - Mileage reimbursement - - - - - - 16 - - - - 16 Ground Transport - - - - - - - - ' - - - - - Total BOCC Staff - - - - - 16 - - - - 16 Total - BOCC Department Conf/Sem & Educ/Training - - , 2,352 893 - � - 300 670 1 130 40 - 97 4,482 Travel Meals - 396 -_ 12 , 25 1 134 25 25 ; 25 278 25 97 1,044 Accommodations - - - 1,207 238 I 378 98 98 ; 77 1,503 77 529 4,205 Airfare - - - - - - - - 520 ', - - 520 Mileage Reimbursement 241 ; 228 766 776 > 1,011 386 365 1320 569 218 2,5{x9 7,480 Ground Transport 44 - - - 39 - - - 122 - - 205 Total - BOCC Department - 681 2,580 2,879 ; 1,039 ; 1,563 809 1,158 ', 552 1 3,031 ' 321 3,3;:2 17,935 1- _ 21,250 FY 2009 Budget Percent Expended _ T _ _ _ _ _ 84.4% 8/4 2009 O CO CD 0 O 0. M' 0 00 0 00 O O O 0 0 0 O O O 0 0 O O O O O O O O O O 00 CO N 0 CO CO 't N 0 co LL O O LL 0 CO O co9 `O LL 0 >0 LL Dog Licenses Issued 13,500 - 13,024 13,000 - 12,586 12,588 12,500 12,118 � --- -- � 12,000 11,500 --- 11;290 - - 11,000 10,500 - _ - 10,000 FY 04-05 FY 05-06 FY 06-07 FY 07-08 FY 08-09 Fiscal Year O co N O O O O ti O ti ti ti 9 O N ccii , f i co ti m N 0)) r-- - O co N O O O O ti O ti ti ti 9 O % Increase: FY 04-05 vs. FY 08-09 O 0 0 0 0 0 0 0 0 0 0 1i 0 ui 0 psi 0 N N aseeJ3ui aBewealed 0 co 0 0 cn ID cn(1) U J Dog License Fee Distribution 0 0 CNI 0 0 (o 0 0 0 (() 0 0 0 0 0 0 0 O (0 tt N 1 r r s;!uii1 AI!3 emu! - °GA pemv A O 0 H. Societies DESCHUTES COUNTY Community Development Monthly Revenue - Fiscal Years 2008/09 & 2009/10 rn LO 0) 0 o o 0 0 >- >- • LL ❑ ❑ 0) O O N O N ti /111O CO 1.0 rn N M ti O 10111111111111111 O O O O O O 6 O O O (0 'c) O O O O O N O O O O O a) a a Q L 2 N a) LL U a) 0 O Z U 0 Q a) Q DESCHUTES COUNTY (0 L() 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O 0 0 O 0 0 0 O S 6 O 0 I-- to (C) d' CO N 1- 01 o 0 N a 0 0 0 N A ti 0 0 CN Date: To: From: Re: August 26, 2009 Board of County Commissioners Erik Kropp, Deputy County Administrator Draft Update to Deschutes County Communications Policy, GA -3 Attached is a draft update to the County's Communication Policy for your consideration at the September 2, 2009 Work Session. The draft changes are underlined and can be found on page 4 under a new proposed section called "Social Networking Sites, Blogs, Postings on the Internet." The rest of the policy remains unchanged. The proposed changes update the policy to include new media sources and outlets and cover the following topics: • Staff/County officials have the free speech right to comment on County affairs on personal blogs, social network sites, and other websites, but defamatory statements are not protected under law. • Departments that choose to use social networking tools for department public communication shall first consult with the Public Communications Coordinator and IT staff. c: Dave Kanner, County Administrator Anna Johnson, Public Communications Coordinator Mark Pilliod, Legal Counsel Joe Sadony, IT Director -(ES 0 Deschutes County Administrative Policy No: GA -3 Effective Date: DRAFT { DESCHUTES COUNTY COMMUNICATIONS POLICY STATEMENT OF POLICY It is the policy of Deschutes County to deliver messages to the public, the media and to each other in a manner that is consistent, effective and accurate. APPLICABILITY This policy applies to all Deschutes County employees. Adherence to certain portions of this policy, including but not limited to notice, representation of personal opinions, media conferences and releases, spokespersons and statements, is not required of elected officials, although elected officials are encouraged to use this policy as a guideline. In addition, this policy recognizes that the provisions of ORS 260.432 regarding advocacy of political positions during working hours does not apply to elected officials. POLICY AND PROCEDURE In General All employees shall inform the Public Communications Coordinator of all media contacts, and opportunities for media interaction. Departments with internal public information or marketing functions/staff shall coordinate their efforts with the Public Communications Coordinator to ensure consistent and coordinated public messages. These departmental staff positions, while reporting directly to the respective department head or supervisor, shall inform the Public Communications Coordinator of all media and marketing projects/campaigns prior to their execution. The Public Communications Coordinator will review and may assist in the stages of coordination and proofing of County publications and communication projects. Incidents To the best of their ability and in as timely a manner as possible, Departments will notify the County Administrator and/or Public Communications Coordinator of incidents that may receive media attention, prior to these items becoming public knowledge. Minor inquiries (for example: spelling of an employee's name, the date and time of a meeting, etc.) do not require Administration notification. The County Administrator and the Public Communications Coordinator will notify the Board of County Commissioners and department managers as necessary. Newsworthy events are those that have received or are likely to receive media interest. Examples include employee arrests, significant accidents on the job, investigations, and other events of similar importance. Notification must occur as promptly as possible, and may be through an email or phone call to the County Administrator and Public Communications Coordinator concurrently. Departments must provide notification when media coverage is known to have occurred about the incident. Media Advisories All departments will notify the County Administrator and Public Communications Coordinator with as much advance notice possible to issuing media advisories. Examples: health related media advisories, and Parole & Probation sex offender absconder notices. The County Administrator Policy No. GA -3, Communications Page 1 and the Public Communications Coordinator will notify the Board of County Commissioners and other key staff as necessary. A copy of the media advisory shall be provided to the Public Communications Coordinator and the County Administrator to ensure that administrative staff and the Board can respond appropriately if there are any media or public inquiries relating to the advisory. Media Inquiries Department staff shall notify the County Administrator and/or the Public Communications Coordinator of all inquiries from the media. The County Administrator and/or the Public Communications Coordinator will notify the Board of County Commissioners and other key staff as necessary. Inquiries may include requests for interviews or requests for information. Notification shall occur promptly, preferably prior to media interviews of County staff,. In the event that an interview, information or access is provided prior to notification to the County Administrator and the Public Communications Coordinator, every effort should be made to contact both as soon as possible thereafter. All employees are expected to practice common sense and professionalism in interactions with media representatives and in determining the appropriate response to media inquiries. All employees are to practice open, honest and factual communications without guessing or making assumptions when responding to the media. Employees shall be respectful of news media deadlines, and should not withold documents and information that is routine or has already been made public. For guidance on handling requests for documents and public information, refer to policy #GA -2, Public Records Requests. If in doubt on how to respond to media inquiries, employees shall refer to their supervisor or department head. Departments are encouraged to contact the Public Communications Coordinator for media guidance, media training and/or advice, if needed. When speaking to the media or members of the public, employees shall not, under any circumstances, predict or state the certainty of future Board of Commissioners' action on any matter. Countywide Emails All employees will contact the Public Communications Coordinator prior to sending countywide email messages except as provided for herein. All staff email messages will be considered on a case-by-case basis for message urgency and topic. All staff messages may be sent without prior approval in cases of Personnel and Risk Management Department trainings and announcements, countywide outages of telephone, HVAC or other support systems, or in cases of scheduled computer maintenance that will limit access to programs and applications. Please refer to Policy #IT -1, Computer Usage for further details. Branding It is each department's responsibility to create increased awareness of Deschutes County's image and services by using the approved County logo on all internal and external materials for distribution. Custom printed materials already ordered and in-house should be depleted before implementing this branding policy on new printing orders. Marketing Campaigns Department staff will inform the Public Communications Coordinator prior to launching any marketing initiative to ensure consistent County -wide design and quality. Policy No. GA -3, Communications Page 2 *Advertising All advertising for county programs and services, whether paid or unpaid, will identify the County with the words "Deschutes County" and one of the approved County logos. Departments that coordinate their own ad placement shall have all ads approved by the Public Communications Coordinator prior to the purchase of advertising space for the ad and prior to the start of any advertising campaign. This provision is intended to complement and not conflict with Policy #GA -5, "Advertising (at Knott Landfill)." Conflicts between these two policies shall be referred to the County Administrator for resolution. Collateral Materials (brochures, annual reports, newsletters, vinyl banners, flyers, etc.) Departments will develop materials as necessary to support their communications goals and strategies. All collateral materials will appropriately identify the County and will always include one of the approved Deschutes County logos and the name "Deschutes County" on the face of the brochure/flyer or other materials. All collateral materials developed by departments must be reviewed by the Public Communications Coordinator at least two weeks prior to the scheduled printing of such materials. The development of new department logos is discouraged. If a department has its own County logo design (prior to the approval date on this policy), it shall adhere to the following guidelines. If the collateral is a brochure: 1) The department logo will be placed on the first page and 2) The name "Deschutes County" shall appear on the first page 2) The approved Deschutes County logo must appear on the final page -at the bottom of the collateral. 3) If the collateral material is in a format other than a brochure, both logos must appear on the front page. Deschutes County's color logo shall be used on all color collateral materials. Representation of County Positions and Personal Opinions No County employee, when acting in their official capacity, shall submit a letter to the editor or opinion piece to any newspaper, periodical or online forum that has not been approved in advance by the County Administrator or the Administrator's designee. The County Administrator and/or the Public Communications Coordinator will notify the Board of County Commissioners and department managers as necessary. In no event shall meetings with editorial boards of any news organization be held without the prior notification of the County Administrator and/or Public Communications Coordinator. Correspondence to media shall reflect strategic alignment between employees and Department management. Staff is welcome to consult with the Public Communications Coordinator in advance for advice on these types of media correspondence. Failure to adhere to the provisions of this section of this policy shall be grounds for disciplinary action. Consistent with the provisions of ORS 260 as it currently exists or may from time to time be amended, this policy is not intended to restrict an employee's first amendment right to freely express their personal opinions in print or electronic media or other public forum. However, when commenting on County issues as a private citizen, such expression should clearly state that the employee is offering his or her personal view and is not speaking on behalf of the County. When speaking to the public or the news media in their official capacity as a county employee, employees should offer only the officially adopted positions, policies and staff recommendations of the County. Policy No. GA -3, Communications Page 3 Social Networking Sites, Blogs, Postings on the Internet The County recognizes that employees and County officials have the free speech right to comment about Coun affairs on their sersonal blo s social networkin sites and other websites (on their own time). However, defamatory statements about County employees or officials are not protected under law and the County will not defend and will not hold harmless those who make such allegedly defamatory comments. County employees/officials commenting on County affairs shall differentiate theiLpersonal opinions from the official position of Deschutes County. Social networking tools (including- but not limited to - blogs, Facebook, and Twitter) are fast becoming a part of mainstream communications. By working with the IT Department's web staff, departments can effective) and efficiently leverage these tools to enhance Deschutes County's ability communicate with the public. Department staff shall consult with the Public Communications Coordinator and IT staff to discuss and strategize implementation of a department social networking tool. County department social networking tools shall not be created without the direct involvement of the IT Department's Web staff. IT will create the social media tool (e.g., Twitter account or Facebook "Fan" page) on behalf of the department. Department staff shall maintain the tool to ensure that information is timely and up to date, in accordance with the established strategies and goals. If this requirement cannot be met, the site will be decommissioned. Media Conferences Departments are encouraged to plan media conferences with the assistance of the Public Communications Coordinator. Departments shall notify the Public Communications Coordinator and County Administrator of their intention to hold a media conference prior to scheduling and announcing the media event. The County Administrator and the Public Communications Coordinator will notify the Board of County Commissioners and department managers as necessary. The Public Communications Coordinator can assist departments with media conference planning details, speech writing, talking points, inviting speakers and/or dignitaries, developing an agenda/program, preparation of media releases/media kits and more. Media (Press) Releases All media releases shall be prepared using the approved template which can be obtained from the Public Communications Coordinator for future use. County employees shall have media releases reviewed by the Public Communications Coordinator as much in advance as possible to media release distribution. Media releases concerning emergency situations, breaking news, crime scenes and fires may be sent without prior review. Departments are responsible for notifying community partners or agencies mentioned in media releases. All media releases shall include a County contact that is immediately available to media representatives at the time the media release is distributed. Spokespersons Departments are encouraged to identify a spokesperson that is authorized to speak on behalf of the department. The authorized spokesperson may be the department head or any other person designated by the director. No one will speak on behalf of the Board of County Commissioners or on behalf of the County Administrator unless expressly authorized to do so by the individuals themselves. If an employee speaks to the media, they shall speak truthfully and factually; not repeating rumors or hearsay. Employees shall not speculate about other's motives or thoughts, and may speak only on actions that have been taken. At all times, employees shall be aware if they speak untruthfully (even if the item was heard from someone else), the employee may be subject to a Policy No, GA -3, Communications Page 4 defamation claim. The County is not required to defend or indemnify an employee who makes allegedly defamatory statements, if the employee was not speaking in the course and scope of their employment or if the statement constituted malfeasance in office or willful or wanton neglect of duty. The employee may be required to pay for their own legal expenses if a legal action is filed as a result of their conversation with the media. So as to avoid prejudicing the outcome of an investigation or official proceeding by having it "tried in the media," employees should refrain from talking to the news media about personnel and legal matters or claims under investigation by the County or about the investigative proceedings themselves during the course of an ongoing County investigation. Employees shall refer media inquiries to County Legal Counsel if questions arise regarding a County investigation or other official proceeding. Employees shall not provide to the media any information that is protected from disclosure under local, state and federal regulations. If employees are uncertain about speaking to the media, they may refer the media contact to the department spokesperson. If that contact is not available, the media representative can be referred to the County Public Communications Coordinator, County Administrator or to Legal Counsel. Written Statements Written statements to the media are appropriate when a one-on-one interview is not possible or appropriate. Whenever practical, departments shall have the Public Communications Coordinator and/or the County Administrator approve written statements. *Approved Deschutes County logos can be obtained from the County's Pubic Communications Coordinator or Website Manager. Approved by the Deschutes County Board of Commissioners DATE Dave Kanner County Administrator Policy No. GA -3, Communications Page 5