Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2010-07-26 Work Session Minutes
TES 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 MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, JULY 26, 2010 Present were Commissioners Dennis R. Luke, Alan Unger and Tammy Baney. Also present were Dave Kanner, County Administrator; and, for portions of the meeting, Cynthia Smidt, Community Development; Mark Pilliod, Chris Bell and Laurie Craghead, County Counsel; Marty Wynne, Finance; Debbie Legg, Personnel; media representative Erin Golden of The Bulletin, and one other citizen. Chair Luke opened the meeting at 1:30 p.m. Commissioner Luke stated that this is a discussion that continues from the recent joint meeting of the Board and the City of Sisters Council. Brad Bailey of High Country Disposal asked to address the Board regarding the planned recycling center outside Sisters. The center will be open seven days a week during normal working hours. The area will need to be secured because there is no one there to monitor activity in the evenings, and the City of Sisters will provide some staffing at the site. Service is not mandatory at this time. The area around Sisters will have a new boundary, and rates will be increasing slightly, effective August 1. 1. Consideration of Signature of Document No. 2010-510, Approving a Conditional Use Permit for a Room and Board Arrangement (Applicant: Anderson). Cynthia Smidt and Laurie Craghead came before the Board. Ms. Smidt said that this is the last day for signature of the appropriate document. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 1 of 4 Pages Commissioner Unger stated that the document says the stay has to be thirty days or longer. He pointed out that it appears the room has to be set aside for that period of time even if the guests leave early. Commissioner Luke asked Marty Wynne if there needs to be a room tax collected. Mr. Wynne stated that there is a tax charged for under thirty days. Commissioner Unger stated that since there is no bed and breakfast provision, this is the best there is at this time until it is addressed otherwise. Ms. Smidt said that there would need to be an applicant -initiated or County - initiated text amendment to clarify this issue. UNGER: Move approval of Document No. 2010-510. BANEY: Second. VOTE: UNGER: Yes. BANEY: Yes. LUKE: Chair votes yes. 2. Finance Update. Marty Wynne gave a brief overview of current finances and the investment report. CD rates are down to 0.08. Bankers' acceptance notes are issued by banks on behalf of corporations and are more competitive, and commercial paper is up. The average investment is 1.26. Departments have been asked to project out to 0.7. Maturity for investments occurs beyond the end of the next fiscal year. Even though loan rates are low, it does not make a difference if no one can qualify for a loan. Housing values continue to fall. Mr. Wynne distributed the preliminary beginning net working capital for the fiscal year. Some funds are down because revenue in the form of grants has not yet been received. The general fund is significantly higher. A sheet comparing May to current shows projections was reviewed. Several categories came in higher than anticipated. Regarding the landfill area closure and cell construction, there were some change orders required. There were additional change orders when it was decided that the size of the Oregon State Police/9-1-1 building was increased. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 2 of 4 Pages 3. County College Update. Mr. Kanner stated this is modeled on the Citizens Academy that the Sheriff's Office hosts. The first meeting is September 14 and it would be good if the Commissioners could attend at that time. One class will be held on election night and attendees will be able to see the election process. He shared the schedule with the Board, which will take place on Tuesday evenings. He wants the department directors to be involved in interactive activities. 4. Other Items. UNGER: Move approval of the Consent Agenda. LUKE: Second. VOTE: UNGER: Yes. BANEY: Yes. LLTKE: Chair votes yes. Consent Agenda Items 6. Signature of Order No. 2010-041, Declaring Certain County Personal Property Surplus and Authorizing Its Sale 7. Signature of a Letter Appointing Michael Waggoner to the Newberry Estates Special Road District Board, through December 31, 2011 8. Approval of Minutes: • Business Meeting of July 19 • Work Session of July 19 Mr. Kanner asked about scheduling a joint hearing with the Planning Commission on text amendment regarding La Pine. Commissioner Luke said he was waiting to see what the City of La Pine wants to do. The Commissioners do not want to cause any delays. Discussion occurred regarding scheduling as two of the Commissioners will be out of the office part. of August. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 3 of 4 Pages Commissioner Baney stated that the U.S. Forest Service welcome center is now back on track. It is hoped that the project will be able to use local contractors. Commissioner Unger gave an overview of his recent trip to Washington D.C. in search of grant funding for landscape management issues. The U.S. Forest Service lead staff person will be the head person in this area later in the year. Collaborative partners need to get together and communicate their support of the process. 9. Executive Session, called under ORS 192.660(2)(d), labor negotiations. The Board went into executive session at 2:35 p.m.; which ended at 2:50 p.m. Being no further items addressed, the meeting adjourned at 3:10 p.m. APPROVED this Day of 2010 for the Deschutes County Board of Commissioners. ATTEST: I/mkt_ 169-1CLA---- Recording Secretary ennis R. Luke, Chair Alan Unger, Vice Chair Tammy Baney, Com n4i sioner Minutes of Board of Commissioners' Work Session Monday, July 26, 20 [ 0 Page 4 of 4 Pages Tis 0 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, JULY 26, 2010 1. Consideration of Signature of Document No. 2010-510, Approving a Conditional Use Permit for a Room and Board Arrangement (Applicant: Anderson) — Cynthia Smidt, Community Development 2. Finance Update — Marty Wynne 3. County College Update — Dave Kanner 4. Other Items Consent Agenda 6. Signature of Order No. 2010-041, Declaring Certain County Personal Property Surplus and Authorizing Its Sale 7. Signature of a Letter Appointing Michael Waggoner to the Newberry Estates Special Road District Board, through December 31, 2011 8. Approval of Minutes: • Business Meeting of July 19 • Work Session of July 19 9. Executive Session, called under ORS 192.660(2)(d), labor negotiations PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), pending or threatened litigation; or ORS 192.660(2) (b), personnel issues Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA July 26, 2010 (1) Monthly Investment Report (2) June 2010 Preliminary Financials ' eschutes vont A I' , - trnent -ort olio As Investment Income Fiscal Year 2009-10 Ci e >- / 4 $ 104,800 $ 1,636,416 Total Investment Income 104,800 1,636,416 Less Fee: 5% of Invest. Income (5,240) (81,821) Investment Income - Net $ 99,560 $ 1,554,595 Investments By County Function General $ 120,654,677 Total Investments $ 120,654,677 //° ° c' S©oico' coSgR ok�odo\ CO- N ƒ ƒ CL Q) m (/)$ DJ 0 1 • C' az22\ £ a 0 crs E o H ¥ 0 E_ _ 0 OOPSƒ C § q T u) 0 co0- E 0 Q // CO 2e 000 a♦• § d ]/a RFU X25 ° 0 0 2 n n—n Average Maturity in Days § \ c 0 e e a a J@ a 00 10 ID to 0 o 0 0 w CV N C E \ \ m $ k 2 \ 0 0 '0 <. o 2 ¥ oR = 2 & \ \ \ Q J±2 Time Certificates / Total Portfolio: By Investment Types I - o 0'-:-2..:1:1 l o,tl, I,oi�l2�.Qe ��0 (�', IU U 0,0 U U'U 0,010 Q U U,U U V V: UIU U O I U' U I U' U I UI UI U U U U N) M CJ'1Q 2 '. U' 2IC ' aratle c�'a Nlo j p zzz,zz"z2zz''z'zzzz,zzZ,zzllz4'zzzlZzz'zj2zzz"NIZ,z' mz' o'omoaoo e m'. 01 co c CIc:r 01��10N,O 4O + L h 1- 1 r - -, + + -A rM r NIR 011 NO O O 0', to NI r1N o. •Rt N', IO to 01 - co0�0! r --- O_ , -- --L_ I L- U U O p ,0 ^.. O O Ri p, M O, + p 10'0 IN r ' - 0 'r IN r MtO NIM rlNiO OO:�-, 1001 010001101 t0 N�OI Vi N'O'i M�'10OO IOt01N O' �O 'N •-p IM r O ? MIO r:O Nr O o, 10'0 1!)''010 N� IN r R,r, MIO'O La -3"9,0.°3.,,t O -7,0,`;',g'-'''',6°,',,",,,90`'' MIO N r1 ItD M'. 'RI Mr ,pp ,0 pp I� c0 ''. 10 011 'Q,O a0 CO. CO 00 Y'1 CO'to ,0 r10 0 011 N' R R!N'M„ll0 cp17.0 0000N10,0 1n'lb R rl 1 R. 1011 Nr ( ''0 Olr O'N'W V t0)• (0 1•- to iN M. Vl.- 0 ic01� 1n I yen N I M I III,,r, h[ 'tn 1n 1(1110,00 OI o 1- col c0 Mc0 st tii ICO.0 pp' c 0tD ...,-..2181c:2104 O •---' 0 O NR j 01 ,7' co 0, 0; 0 n -, 0 01 � 0. 0 I N Icsi0 I .0. cr,' Nicol CD CNI 0.- e 1 0 N� I o ,' O O o li O lei O O 01 I1 ,- co, -10 ''01 I� 0 � 0N01 a1 0 � -10 O ..- 0 0' 1 - o. 0,.- '01 0 0�01 �I0 0'. 0,.- ,0 •'1 I R I, C i R 1 I V I N N N 1 •- 1 N N I N N r N N I CV l l V, N 111 N 1 N N 1 N N N N I N I N N NJ N-, , NIN' O l l� N '1 N J y 101 0 1 -I- 7 -,• '- -, r +- -1, f r--1 1, r- 1 �- 1 - r - _1 L _ -. - r - r' 017 r r 100 0 0, 0 0 0 0 CO j 0 M f.'3' 0 M I eer� ' 0' 10 ' )D 10' 0 CO 0 0 0 0 0p 01 0 0 0 0 o, 0 i 0 f 00 Iry M 1 t0 001 M•.• r• I v r• 0 Cr,1 01 0 01 101 0 0 M' tet, 0 0 R 010 10 0 010, r 0 0 0. o of 01 ,0 0 01 0 1 0 001.- -N r 0 r O NI 0, 0 0•) ''D' tO o 01 0' 0 N N 0 t01 •-),0' 0 010 0 010 o 0p O 0, 0 0, CJI 0 0 0 00.0 N T CO CO : M j � 0'M 01 R I r 1 N, 00 CO! CO' 101 0 01 00 , N R .WIN M 1 101 N! N 1 N 1 r CO � ,OI O o (DIN 0 0, (01 0 01 0" W I R ,4•1 I 101 W ,DI1 10 00' 01 �''D'MIM r.- or r O M,N 101.-1W coI- to col MI I -I M MI co .- I -I toIO O N110 010 I I- 00 rR o I O 0) {O o OI co co 'aril co M, oil 01N ry CA10 totA'OIR .- o1 r cp R'to oli o, c0 CV, cioril NIO 0) MI ON N. -IO coO 0i0 N )''0p10 M101.010'0 '. 010 ' 0-I r 00, 01r 0 0000 O 01 00 1,4,0 11.- j 10 ,-1O O ,0 010.0 7(O O'7 O 0),O O'1OIol.-10 0 0 010 O OlO 0 ,oI0r 0I Ol co 111 R1 V. NrRi 'Q ." N 0 0 .- ,N N, INI �1 N I0 N NIN NI Nf NI tV N lV NDN N NI OF NI NII ,o r•-.- N 0) 1 1 1 ! 1 I 1 li ' I I �I I u' 1 ,'1_ 1_- i_ >__r _, - ,t T 1 i,_ -+ L H,4 T I I r-4 p� I- 7T -p i- i ----'pp -t 4 fl p 1 ppI rpp- 1 1----H t +- -r-- O'0 10l 0 0,010 0 0 r 0 o,011010 1 0 O, 0 I 0 O�010'010 010 0!ol 0 O o,0 0 O O I 0 O O 010 0 1 r10) 10 N 0,1 I 1 IO 0'1010 O0io 0p 0, Ni 0110 01,0,0 0',0,010 01 0101010,0100 00'0 0 alo 0 ol0 o 0 0 1 OI0 I0 oil 1 1 I''D 0 0' o 0) 0' 0110 M oIo N O10'V10 101 O o oIR! co c0 OI 0j0I10 0 0IOI co ol01NlOIoj M $ $I to 0'010 0 o(R' 0)1to olcolofo, o,v u`li 1 o of o''?1MI 0 0 0 0 0 0)0 O co o o r10 0 I 011.4 Ml I p aii0 0I 0 0LO7�IM r 0'0,$ 0;0 civil 0, oO 00 000 0 p 010 0 r'O ,0'01 v10I0II 0)10I0) 011 pplolcvIN -010 N1O,0 ccppl R,r10,0 0,0'0(0 p1 010 pI DI 0101 0 ppp:000 0 0)0p14 010 0, 0' cO lr 101 > 1010 JO 017 0 010'017 0 0'7H-1.7 1,01 .-,0010 IO O 0,010 0 010,7 0101010 O�j t0 l0 M- I C .� 1 R 0 R , V .-1 NN,N ,-1 N N N I,! ,-I 1 N 1 N' e- j N NIN 0 NIN N N 0 c V 0 N 1 N I N 1 N 0) I r N 0)I i 1 0) r I I I 11 ij p1Ml f 0 0) 0 0 0 � 0 0' 'c_)•_) 0 1 0= o l� o l 0 3el oo' o 2e 3zto oro 0 3�' o h ' 2' r� ,I � 8)8)8' 0 orT -00 110, 00,010)01,0!01, 0, lm(0100000010010110 �lofo0 oIo Olo� 1.10'0110 OI t0 IZ O, y1179aU ��1-r �' _ _ ` 0,d al d - i-- I L I 1 d0- Io E�_ __ Ids �I`21 Si° 1� � � �10p m!? "- Olr F-rw 1 001 01 0' 0O 01 0 N, R 0 )1 0 (1) OI LL) ', 10.. M ,L1. M 10 01 101 M N O I O 00 00 O ,0 01 ,0I OI 1) 0 r. R' r 10 110 0 ' N' i O � 1.� (� 1 � 1 > I ''p 01�1,r) o' 110 O V:IN O 017 N rN17 CD., ,, cOl MRI•- 001N •-10 0f (0,0 r o1 r10 WI 0100101 NII C4' 0 '01 01114 UID 1' gymC 1 1Nje1N Moil.- 1 1�1.-IM e-, OIo 0 0 ._IOI.= of O,�( ,Ia •:1 E 'yF-1;Y1�- I. T- -1Lli o�1°\n 0, 0, 1000.01,*•" l -o l�lll00 of o1007o ot°g10 01.010 I -1_i__ l- �EI�.,lm colo of _ UVF-�I .'�11J F', 1 11 I 01 ,0 j r l r 1 01 1 0' M o i o tl 101 r 0 0 N' to I N o 10 N O. o o, 'cf n' 1 ! 111 M '0 M 01 ` ) rM'o o,c'IoT rIM1M10 01 r r� c�lrl--,0) 0 0 Ic411 M, 1 �I 11u1 o ui 0.11 Oi o! LiL o,Oioi O 11011vi'io l�f E1 1 IM RIR' 1 ( 1 I 11 , 1 m �, 1 CI 1 1 1 4 1 1 O O 1411 p W 1 ( 1 I aid C >, 1 , m1 1 1 11 ri 1 11 f1 1, 1 I 1 1 =x..10 c.1 1 ' 1 I I '�1 w1d O. T41 M-1- t CO r o 1Om)sD R rn 0'', --r �- - T r- t 0) 0)-M - r co M m�' __.r.1 ,- of �Ilm c1"Ic'�1� ' -'- ._--_.1--� - -r -- _ 1 _ 1 - --i T -- 1 - - - --- m I 11 1r p r- t r-" co i--+- - t -r-- -,----1--- ,, + - T 1.7001 �1RO. ID, VI 'ti OI s0 ''Oor-1a coR1V V' t0 N M co1N ,OR1col co o)oiM'M at ai ZI Market Value M 0 V W 0 a d m ,a Y � 011 a w U K 0 0 r.,1 -,I0,10(7, t A,: ,(R,01n ,)IN3r NI'R)M�IjI1017, �!�]S! 111�Ri3 10R2 n (D10c0 c0 It0!r�r11!?o gC'! 1 I 1 1 T Lt ml�Ic T, �010,0- 10 010 0 010101010,0 01 .-I ,H1- .-I • I = I� 1•-IN110 i10,t 1 1 1ot11Nir r . rn o' '4`101 r -:r ail kola!! o ,oio rni rnliDl ,,D .-I rn ,n Mfg ,n''oI0 M � �11oi11 • cIU' r A 0 Q .-- I N N .'� I N �V - 01 0` 0 [� I .- N N I O I N NIN 001 0 N O 0)01.. F.3) 0 N N N V 0) I�,r'0j0 0'33103 0110100',0 A, . .�'MIRiiii iii c--r-a rlc4lcolirn rn'rn1rn rn rn o.0 o1�i�:,y �II> SI�,1"- o F- ! 1 �', OI O'000!o' o 0o!.-`,-,..-17-1,- - o 00' o100lo, 000, 00f 0 o alo' 0001.-I 171.-j0 4 0010 1 f 1 01' ( 011 0) i 01 0) 0 0' 01 0)1 0)' 0) 0) 01 c0 01' 0) 0110)1 O milt 0) 0) 0. 0 0 0 0 0 01 0 0 011 O' o 0 O OI 0) 01 1 331 I0 p1�0 Q'Q10'RIQiQ,,Q10 o,Q 0 IojglO o�o,� I� L ��.- QI I �1gI1 I1 tl Q Q Irlf,1.-II0 01:.- V.-Iln,,n. r1 o 1 Cn1o, of rn l co'' `,.:2 O,rn.rn)� MI n)c'o 0 _- rn011• rn17,N17 71 1 1 1 01 0 O o, Q,N N1 .= I. --I NI O', 0,,''`)I F3 g:, 1N1N'N.`1 NIQ .- N�M QQI0 � N NI R1 R 0Q0 0 aii!gr ,01 ,, t0 0 r'� M1 O).-� N,V 0 000 M M 10 (7 P_$' a R 10 1 NI,0( I olofojo 0 010 `�(010�`81a 1 101010i�101o:,- ri.-Io 01010 0,0,0 0 01,0 010.0'1•-10111 Q IIU'IKIaimC!-�m�11 >'i,afLLQaZ¢lol 1 ; 1 i I to m U,S, a ceiw v) th 7`� CI0 0',0',1- r - }- (1 '�( I{ 1 ad. I0 0 of - 0,0 oto 4 0i 4'Q z� ¢101 at o', 011 Z 0-Zia;0J0-0141zjZ <1.ti a as z'al a. a!Q a'I , , 1 + 1 1 1 i F -T i T 'I F- f' F-1 F-1 F-'1-11- LLLf-�LL'LL; UI LLIF-'LLF-, F"'. ti F-' U,t-�F-1 F'�F-1 t1'I U1 UF- LL1t�LL ti li,tL,U la_ tt�tiltil�I l I 1 1 1 I i yuoe m �im'm 0'-1 m cof 2>i'tzi�l>i �'=1�I0 (1) (fl (/)) (1)) ui a 311 a n (0 Z �'�j1 �!I i1 0' 1 I I I I , t ! ' 1' - �1 I I I .0 �1 z,Hia mj '�i 1 0 a,;j11 I�Io1�� �IEDv 4334 ���r 0lao Z10Idl I ., 1 1 , E I ' ' I F-1 I SIVIf/�11G1 lm Ia I�'.. 01 1 lal �I Z1 LLI LLI% Z OCI01� UI �� ,tel �Il 2 ,--'W oil- al I ( >1 1 I� 0 012 rn 71'�jM DIY �I Ut1� 1 z 1 I M� 1oxilMl0' 1�, ,r,' rn ���1 `�o>'inj )ic�loxi of ;'MIN 01 M1rn'0'�LLpI • to f 1 M ml c0, MI N 0 0 10 010) M1 IM N 01,1M10) MIM M M10,i I I , O , I M( 0'M M 0I 1.M' 10 10,01 1 miosioRi� Min ro ch M'<')17 0l MIMIty1M', 1 I 1 1 I �I 1 1 ' ''NI �� �_ -,--)--- L 1 +_i �_i I+ 1 1 1 I I '84 C -- --� . - I ( I rt 1 -� -t - 1 -'( ) 0' 1 N ',4,"i 1 1 ELI' L I' r m 1o��jol p' 101 1 ml xl ° c j fol I(..);(),( -)r ❑�' o, 1 U 1 1 v c LI -,.,F �� 1 :.�, U ;'� ui i61 1 Icrsl��m ml� �PSi ._ j0 Iti�N1ti i0 1 1 , I V'. 1 � 1 ',c:) Y' II 1iU 11 !,,.1;,0,,,tE,,..,,5.,,, aod'�Iam''010ij°��,y y0' Y, tee''ZI ° ci mIyG'�,mI Id G I°o IU -tea U I 1 O' ''lm 1 1 Vl -I� m >,i.SOI�i, olc cin O Z Idcls �1 m 10n,.. - al G 0' w1 H' �IU1 ' fmj �', U; m'Um 0 �imil ,rz�U wI II �1 mla�lml ml ISIZ niml�¢I'S33'10�I,x '1( `4133 ,- 1�., I Y, _ ', a a; 1 ,EDI pi01 iU U �e'U 11 '!alu.lclm ml m, 'rnl�lu.I�!d mr- i•+ j OI c 001(-) Y. y E) 1 o' ci ml 01 col 1 : g.IU I 1 ' c I 1 f!11� '�'D' li. c' ',.1:),:1;,.2,a):: iYjE i� d1� jEm, 1�it���E i-o� a)I m' mi,�Ultn 1 !dl�l'I 1Ym:m 1a '( 33 331!EJ..x jm�wlir''gl6,(T,0 Ia�,Ell Qj �'011a 01331 oT._,_:_.W' 3siL c!�I.>IalmI-'>of tI--1fi1�1g '�1`"1U '-1:t- _I 1 11 _pl, ;07.6 !IzI_Flueii_i°f),LF:j.-717,1°11' ��p U0u H: 0) iii aY!.xIYItI. co 0133)33 w'm'1412' 01 01 .cl EI a'mjwl cim�mlml_NI crtmlmim i (o cD o mllmla!m a l w m> 1 mI E' c% ml33101m S OSxj m1LLfE121 Eo' 2Io, @I-Iol151 d LLIm�' E LLLL1S z 21LL>JO,-'12°1-17j, �l + laO LLSZLLZWI 1 C 331 ,mlmiml Jlm LL i'1LL',LL10, LLl)1LLJ012LSll 0, 0J LL,(01(0 LL,J �,D LL1 LLLL LL 0 01- )LL1LL; LL1 LLILLJI .Jl0' I f 1 k"} Memorandum Date: July 20, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find June 2010 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriff's (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705) and Health Benefits Trust (675). The projected information has been reviewed and updated, where appropriate, by thE: respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 Year to Date Budget Actual Variance FY% Coll. RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% Revenues Property Taxes 19,822,847 21,289,179 1,466,332 100% 107% Gen. Rev. - excl. Taxes 2,921,462 3,150,964 229,502 100% 108% Assessor 820,704 847,684 26,980 100% 103% County Clerk 1,043,171 1,599,757 556,586 100% 153% BOPTA 13,791 14,432 641 100% 105% District Attorney 332,800 332,606 (194) 100% 100% Finance/Tax 187,049 194,914 7,865 100% 104% Veterans 70,192 70,154 (38) 100% 100% Property Management 86,450 98,370 11,920 100% 114% Grant Projects 2,000 2,000 100% 100% Total Revenues 25,300,466 27,600,061 2,299,595 100% 109% TOTAL RESOURCES 31,350,466 34,376,056 3,025,590 100% 110% REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency Transfers Out Exp. 3,290,631 3,082,496 208,135 100% 94% 1,460,704 1,301,868 158,836 100% 89% 60,358 59,883 475 100% 99% 4,622,263 4,580,458 41,805 100% 99% 755,971 747,699 8,272 100% 99% 234,222 234,030 192 100% 100% 239,685 238,431 1,254 100% 99% 105,673 103,728 1,945 100% 98% 1,613,006 1,423,351 189,655 100% 88% 5,515,042 5,515,042 100% 0% 17,897,555 11,771,944 6,125,611 100% 66% 13, 046, 911 12, 960, 911 86,000 100% 99% TOTAL REQUIREMENTS 30,944,466 24,732,855 6,211,611 100% 80% NET (Resources - Requirements) 406,000 9,643,201 9,237,201 Beginning NWC per Adopted Budget 8,300,000 COMM JUSTICE -JUVENILE Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % CoII. % RESOURCES: Beg. Net Working Capital $ 1,085,000 Revenues Federal Grants 31,775 SB #1065 -Court Assess. 60,000 Discovery Fee 16,000 Food Subsidy 30,000 OYA Basic & Diversion 332,450 Inmate/Prisoner Housing 60,000 Inmate Commissary Fees 800 Contract Payments 208,141 Miscellaneous 300 MIP Diversion Fees 1,000 Interest on Investments 13,000 Leases 2,448 Grants - Private Health & Human Svcs Chg - CCF Interfund Grant 68,000 Crime Pry Svcs Interfnd Grnt 20,000 $ 1,200,041 $ 115,041 100% 111% 53,491 21,716 100% 56,535 (3,465) 100% 15,989 (11) 100% 26,251 (3,749) 100% 225,712 (106,738) 100% 107,507 47,507 100% 279 (521) 100% 98,551 (109,590) 100% 153 (147) 100% 400 (600) 100% 15,779 2,779 100% 2,500 52 100% 1,721 1,721 100% 1,660 1,660 100% 46,272 (21,728) 100% 20,000 100% Total Revenues 843,914 Transfers In -General Fund 5,543,186 TOTAL RESOURCES 7,472,100 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services 672,798 (171,116) 100% (56,075) 100% 99% 5,543,186 7,416,025 2,830,152 2,847,680 Materials and Services 1,322,097 1,116,945 Capital Outlay 100 Juvenile Resource Center Personal Services 2,532,154 2,301,600 Materials and Services 184,903 181,695 Capital Outlay 100 Contingency 602,594 168% 94% 100% 88% 68% 179% 35% 47% 51% 40% 121% 102% n/a n/a 68% 100% 80% 100% 100% Exp. % (17,528) 100% 101% 205,152 100% 84% 100 100% 0% 230,554 100% 91% 3,208 100% 98% 100 100% 0% 602,594 100% n/a TOTAL REQUIREMENTS 7,472,100 6,447,920 1,024,180 100% 86% NET (Resources - Requirements) 968,105 968,105 Beginning NWC per Adopted Budget 987,000 SHERIFF - Fund 255 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest - $ 183,677 20,242,936 12, 717, 322 $ 183,677 100% n/a 16,777,094 (3,465,842) 100% 83% 10,919,465 (1,797,857) 100% 86% 24,013 24,013 100% n/a Total Revenues 32,960,258 27,720,571 (5,239,687) 100% 84% TOTAL RESOURCES 32,960,258 27,904,248 (5,056,010) 100% 85% REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 2,190,388 Civil 746,874 Automotive/Communications 1,397,884 Investigations/Evidence 1,697,327 Patrol/Civil/Comm Supp 7,585,967 Records 642,363 Adult Jail 9,154,909 Court Security 215,908 Emergency Services 192,071 Special Services Division 1,193,690 Regional Work Center 2,737,842 Training Division 465,053 Other Law Enforcement Svcs 587,702 Non -Departmental 463,044 Contingency 3,199,236 2,131,685 724,992 1,353,489 1,522,296 7,257,604 594,992 8,493,844 196,026 182,209 1,105,660 2,372,843 419,548 548,650 463,044 Transfers Out 490,000 490,000 58,703 21,882 44,395 175,031 328,363 47,371 661,065 19,882 9,862 88,030 364,999 45,505 39,052 3,199,236 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Exp. % 97% 97% 97% 90% 96% 93% 93% 91 % 95% 93% 87% 90% 93% 100% n/a - 100% 100% TOTAL REQUIREMENTS 32,960,258 27,856,883 5,103,375 100% 85% NET (Resources - Requirements) 47,365 47,365 Beginning NWC per Adopted Budget SHERIFF 701 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 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 Other Claims Reimbursement DC Fair & Expo Center 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 Budget Actual Variance FY Coll. % $ 2,470,519 $ 3,343,461 14,819,703 500,000 35,000 45,156 5,000 1,721,192 5,000 129,000 3,000 150,000 2,000 60,000 42,450 6,000 5,000 4,000 5,000 12,000 1,050 160,000 28,333 3,533 30,000 15,331,889 837,220 122,411 71,283 6,102 1,974,660 5,000 121,050 5,456 47,259 2,837 1,320 37,528 2,100 61,084 22,350 6,875 11,400 9,382 2,136 14,575 1,449 212,606 57,104 3,473 85,094 50 $ 872,942 100% n/a 512,186 100% 103% 337,220 100% 167% 87,411 100% 350% 26,127 100% 158% 1,102 100% 122% 253,468 100% 115% - 100% n/a (7,950) 100% 94% 2,456 100% 182% (102,741) 100% n/a 837 100% n/a 1,320 100% n/a 37,528 100% n/a 2,100 100% n/a 1,084 100% 102% (20,100) 100% 53% 875 100% 115% 6,400 100% 228% 5,382 100% 235% (2,864) 100% n/a 2,575 100% 121% 399 100% 138% 52,606 100% 133% 28,771 100% 202% (60) 100% 98% 55,094 100% 284% 50 100% n/a 17,772,417 19,053,693 20,242,936 22,397,154 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 20,242,936 16,777,094 TOTAL REQUIREMENTS 20,242,936 16,777,094 NET (Resources - Requirements) Beginning NWC per Adopted Budget 1,281,276 100% 107% 2,154,218 100% 111% C Exp. % 3,465,842 100% 83% 3,465,842 100% 83% 5,620,060 5,620,060 4,722,862 SHERIFF 702 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 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 Grants Des Cty General Fund Grnt Des Cty Transient Room Tax City of Sisters Des Cty Tax/Fin Contract Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Claims Reimbursement Security & Traffic Reimb Seat Belt Program Miscellaneous Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Sale of Reportable Assets Sale of Equip & Material Total Revenues Budget Actual Variance FY % Coll. % $ 1,287,473 $ 1,433,708 7,239,702 7,464,529 239,000 430,504 2,000 79,159 76,500 57,375 187,633 139,487 67,000 56,535 124,468 78,500 3,468 863,163 643,163 1,786,837 2,016,837 420,015 416,015 1,000 1,405 27,183 27,183 81,548 81,545 2,000 2,084 100,000 57,745 - 36,232 13,000 12,761 6,000 9,150 10,000 10,222 5,000 12,291 85,000 134,040 75,000 12,400 1,074 - 1,122 10,000 16,695 1,800 1,701 - 6,779 6,000 13,656 $ 146,235 100% 224,827 191,504 77,159 (19,125) (48,146) (10,465) (45,968) 3,468 (220,000) 230,000 (4,000) 405 (3) 84 (42,255) 36,232 (239) 3,150 222 7,291 49,040 (62,600) 1,074 1,122 6,695 (99) 6,779 7,656 11,429,849 11,823,656 TOTAL RESOURCES 12,717,322 13,257,364 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 12,717,322 10,919,465 393,807 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% n/a 103% 180% 3958% 75% 74% 84% 63% n/a 75% 113% 99% 141% 100% 100% 104% n/a n/a 98% 153% 102% 246% 158% 17% n/a n/a 167% 95% n/a 228% 103% 540,042 100% 104% Exp. 1,797,857 100% 86% TOTAL REQUIREMENTS 12,717,322 10,919,465 1,797,857 100% 86% NET (Resources - Requirements) 2,337,899 2,337,899 Beginning NWC per Adopted Budget 1,905,939 PUBLIC HEALTH Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous OMAP Family Planning Exp Proj Grants FY 2008-2009 Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Drug Court Byrne Total Revenues Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES Budget Actual Variance FY % Coll. % $ 900,000 $ 1,120,355 $ 220,355 100% 124% 4,000 2,709,730 34,737 213,240 303,000 475,000 133,800 152,150 36,000 98,000 38,000 8,800 91,692 27,000 40,082 4,365,231 25,000 2,317,765 7,607,996 346 (3,654) 100% 9% 2,095,576 (614,154) 100% 77% 23,069 (11,668) 100% 66% 207,395 (5,845) 100% 97% 540,420 237,420 100% 178% 493,165 18,165 100% 104% 55,755 55,755 100% n/a 4,568 4,568 100% n/a 2,440 2,440 100% n/a 151,004 17,204 100% 113% 126,603 (25,547) 100% 83% 33,250 (2,750) 100% 92% 99,540 1,540 100% 102% 16,220 (21,780) 100% 43% 42,535 33,735 100% 483% 60,381 (31,311) 100% 66% 27,000 - 100% 100% 20,452 (19,630) 100% n/a 3,999,719 (365,512) 100% 92% REQUIREMENTS: Expenditures Personal Services 4,548,325 Materials and Services 1,912,716 Capital Outlay 86,902 Transfers Out 150,000 Contingency 910,053 25,000 2,317,765 7,462,839 - 100% 100% - 100% 100% (145,157) 100% 98% 4,265,820 282,505 1,707, 520 205,196 26,414 60,489 150,000 - 910,053 TOTAL REQUIREMENTS 7,607,996 NET (Resources - Requirements) Beginning NWC per Adopted Budget 100% 100% 100% 100% 100% Exp. % 94% 89% 30% 100% n/a 6,149,753 1,458,243 100% 81% 1,313,086 1,313,086 1,100,000 BEHAVIORAL HEALTH Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget RESOURCES: Beg. Net Working Capital $ 2,725,000 Revenues Marriage Licenses 5,500 Divorce Filing Fees 125,000 Domestic Partnership Fee 2,000 Federal Grants 99,819 State Grants 5,277,086 State Miscellaneous 184,716 Title 19 300,705 Liquor Revenue 106,000 School Districts 70,000 Miscellaneous 40,800 Patient Insurance Fees 247,500 Patient Fees 11,500 Seizure/Forfeiture Interest on Investments 32,000 Rentals 16,500 Donations 3,000 Interfund Contract 3,120 Administrative Fee 3,034,954 Comm. on Children & Fam 22,000 Crime Prevention Services 127,000 Actual Variance FY % Coll. % Total Revenues Transfers In -General Fund Transfers In -Other $ 2,589,996 $ (135,004) 100% 95% 5,265 129,371 95 95,346 5,367,146 166,755 126,735 132,272 89,900 37,413 144,882 3,235 13,129 38,903 13,500 7,000 3,001,703 50,686 120,632 (235) 4,371 (1,905) (4,473) 90,060 (17,961) (173,970) 26,272 19,900 (3,387) (102,618) (8,265) 13,129 6,903 (3,000) 4,000 (3,120) (33,251) 28,686 (6,368) 9,709,200 1,316,158 255,636 100% 96% 100% 103% 100% 5% 100% 96% 100% 102% 100% 90% 100% 42% 100% 125% 100% 128% 100% 92% 100% 59% 100% 28% 100% n/a 100% 122% 100% 82% 100% 233% 100% 0% 100% 99% 100% 230% 100% 95% 9,543,969 (165,231) 100% 98% 1,316,158 - 100% 100% 363,129 107,493 100% 142% TOTAL RESOURCES 14,005,994 13,813,252 (192,742) 100% 99% REQUIREMENTS: Expenditures Personal Services 8,070,245 7,483,656 Materials and Services 4,053,514 3,621,096 Capital Outlay 80,000 Transfers Out 150,000 150,000 Contingency 1,652,235 Exp. % 586,589 100% 93% 432,418 100% 89% 80,000 100% 0% 100% 100% 1,652,235 100% n/a TOTAL REQUIREMENTS 14,005,994 11,254,752 NET (Resources - Requirements) 2,751,242 100% 80% 2,558,500 2,558, 500 Beginning NWC per Adopted Budget 2,616,050 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 Year to Date Budget Actual Variance FY % CoII. % RESOURCES: Beg. Net Working Capital $ 413,471 Revenues Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Prog Env Health-Lic Facilities Env Health - Drinking H2O Planning -Current Planning -Long Range Total Revenues Trans In -GF Trans In -GF for Lng Rng Ping Trans In -Other TOTAL RESOURCES 3,650 2,075 189,450 974,775 280,500 255,500 292,850 690,475 95,311 984,150 428,900 629,659 $ 216,188 100% 152% 17,639 38,809 171,136 953,909 261,645 124,685 241,626 737,517 93,874 670,045 311,651 13,989 36,734 (18,314) (20,866) (18,855) (130,815) (51,225) 47,042 (1,437) (314,105) (117, 249) 4,197,636 3,622,537 1,216,627 1,216,627 300,000 300,000 115,799 114,734 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 483% 1870% 90% 98% 93% 49% 83% 107% 98% 68% 73% (575,099) 100% 86% - 100% 100% - 100% 100% (1,065) 100% 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 6,243,533 5,883, 556 99% (359,977) 100% 94% 1,708,112 1,604,912 103,200 215,606 206,124 9,482 180,969 167,604 13,365 725,145 633,966 91,179 206,719 189,207 17,512 264,781 249,136 15,645 240,687 236,986 3,701 495,946 519,440 (23,494) 80,598 83,219 (2,621) 809,783 771,285 38,498 551,828 458,298 93,530 177,660 177,660 585,699 - 585,699 TOTAL REQUIREMENTS 6,243,533 5,297,837 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Exp. 94% 96% 93% 87% 92% 94% 98% 105% 103% 95% 83% 100% n/a 945,696 100% 85% NET (Resources - Requirements) 585,719 585,719 Beginning NWC per Adopted Budget 686,081 Revenues Expenditures Net from Operations 3,622,537 5,297,837 1,675,301) ROAD Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% Revenues Federal Reimbursements 490,000 (490,000) 100% 0% System Development Chrg 693 693 100% n/a Mineral Lease Royalties 10,000 115,306 105,306 100% 1153% Forest Receipts 2,482,000 2,482,310 310 100% 100% State Grant 415,477 (415,477) 100% 0% State Miscellaneous 54,322 54,322 100% n/a Motor Vehicle Revenue 8,000,000 7,728,198 (271,802) 100% 97% City of Bend 225,000 297,294 72,294 100% 132% City of Redmond 250,000 316,603 66,603 100% 127% City of Sisters 10,000 (10,000) 100% 0% City of La Pine 10,000 (10,000) 100% n/a Admin Recovery (SDC) 500 1,431 931 100% n/a Miscellaneous 130,000 157,272 27,272 100% 121% Road Vacations 1,000 500 (500) 100% 50% Interest on Investments 50,000 45,226 (4,774) 100% 90% Other Bank/LGIP Interest 1,736 1,736 100% n/a Parking Fees 300 300 100% n/a Interfund Contract 700,000 715,469 15,469 100% 102% Equipment Repairs 275,000 254,617 (20,383) 100% 93% Vehicle Repairs 90,000 78,089 (11,911) 100% 87% Vegetation Management 35,000 (35,000) 100% 0% Inter -fund: Forester 22,000 12,153 (9,847) 100% 55% Car Washes 2,500 3,818 1,318 100% 153% Car Rental 406 406 100% n/a Forester - 100% n/a Sale of Eqp & Material 800,000 745,748 (54,252) 100% 93% Total Revenues 13,998,477 13,011,491 (986,986) 100% 93% Trans In - CDD Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res 18,190 708,568 75,000 10,000 18,190 708,567 75,000 - 100% 100% (1) 100% 100% - 100% 100% (10,000) 100% 0% TOTAL RESOURCES 19,606,900 18,704,897 (977,003) 100% 100% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. % 5,665,373 5,302,283 363,090 100% 94% 9,133,210 8,368,366 764,844 100% 92% 2,700,000 1,302,528 1,397,472 100% 48% 400,000 400,000 100% 100% 1,783,316 1,783,316 100% n/a TOTAL REQUIREMENTS 19,681,899 15,373,177 4,308,722 100% 78% NET (Resources - Requirements) (74,999) 3,331,719 3,331,718 Beginning NWC per Adopted Budget 3,430,429 ADULT PAROLE & PROBATION Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Year to Date Budget Actual Variance FY % CoII. RESOURCES: Beg. Net Working Capital $ 467,892 $ 487,674 $ 19,782 100% 104% Revenues DOC Measure 57 217,305 217,350 45 100% 100% State Miscellaneous 8,000 4,301 (3,699) 100% 54% Alternate Incarceration 30,918 30,918 100% n/a State Subsidy 29,500 13,306 (16,194) 100% 45% SB 1145 2,839,925 2,961,989 122,064 100% 104% Probation Work Crew Fees 40,000 32,475 (7,526) 100% 81% Miscellaneous 3,000 4,580 1,580 100% 153% Electronic Monitoring Fee 160,000 191,291 31,291 100% 120% Probation Superv. Fees 220,000 235,217 15,217 100% 107% Interest on Investments 9,000 12,377 3,377 100% 138% Interfund - Sheriff 50,000 50,000 - 100% 100% Crime Prevention Services 50,000 50,000 - 100% 100% Total Revenues 3,626,730 3,803,803 177,073 100% 105% Transfers In -General Fund 115,029 115,029 - 100% 100% TOTAL RESOURCES 4,209,651 4,406,506 196,855 100% 105% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 2,988,079 2,871,561 116,518 100% 96% 792,073 787,515 4,558 100% 99% 40,100 10,448 29,652 100% 26% 389,399 389,399 100% n/a TOTAL REQUIREMENTS 4,209,651 3,669,523 540,128 100% 87% NET (Resources - Requirements) 736,983 736,983 Beginning NWC per Adopted Budget 616,371 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% Revenues Federal Grants 367,800 330,337 (37,463) 100% 90% Title IV - Family Sup/Pres 37,652 12,545 (25,107) 100% 33% HealthyStart Medicaid 95,000 79,223 (15,777) 100% 83% Child Care Block Grant 81,275 (81,275) 100% 0% Level 7 Services 175,193 210,673 35,480 100% 120% State Prevention Funds 8,374 8,374 100% n/a HealthyStart /R -S -G 307,577 308,924 1,347 100% 100% OCCF Grant 614,052 501,959 (112,093) 100% 82% Local Government Grants - 7,849 7,849 100% n/a Charges for Svcs-Misc 8,000 4,262 (3,738) 100% 53% Court Fines & Fees 75,000 77,623 2,623 100% 103% Interest on Investments 30,000 9,005 (20,995) 100% 30% Grants -Private 2,000 (2,000) 100% 0% Donations - 4,000 4,000 100% n/a Video Lottery - 2,000 2,000 100% n/a Interfund Grants 187,500 169,900 (17,600) 100% 91% Crime Prevention Services 74,350 49,565 (24,785) 100% 67% Total Revenues 2,055,399 1,776,238 (279,161) 100% 86% Trans from General Fund 284,333 Total Transfers In 284,333 - 100% 100% 284,333 284,333 - 100% 100% TOTAL RESOURCES 2,964,275 2,729,197 (235,078) 100% 92% REQUIREMENTS: Expenditures Personal Services 539,978 528,678 11,300 100% 98% Materials and Services 1,917,843 1,402,221 515,622 100% 73% Capital Outlay 100 100 100% 0% Contingency 506,354 - 506,354 100% n/a TOTAL REQUIREMENTS 2,964,275 1,930,899 1,033,376 100% 65% Exp. % NET (Resources - Requirements) 798,298 798,298 Beginning NWC per Adopted Budget 562,762 SOLID Statement of Fina Year Ended PRELIMINARY WASTE ncial Operating Data June 30, 2010 AS OF 7/19/2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% Revenues State Grant 37,850 37,850 100% n/a Miscellaneous 30,000 26,562 (3,438) 100% 89% Franchise 3% Fees 200,000 209,129 9,129 100% 105% Commercial Disp. Fees 1,396,400 842,145 (554,255) 100% 60% Private Disposal Fees 1,541,300 1,405,964 (135,336) 100% 91% Franchise Disposal Fees 4,743,500 3,826,290 (917,210) 100% 81% Yard Debris 75,000 75,843 843 100% 101% Special Waste 30,000 34,181 4,181 100% 114% Interest 14,000 12,298 (1,702) 100% 88% Leases 241 241 100% n/a Interfund-Miscellaneous - 5,952 5,952 100% n/a Sale of Equip & Material 35,000 33,577 (1,423) 100% 96% Total Revenues 8,065,200 6,510,034 (1,555,166) 100% 81% TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 8,403,811 6,976,359 (1,427,452) 100% 83% Exp. % 1,763,578 1,735,389 28,189 100% 98% 3,748,254 3,108,642 639,612 100% 83% 968,765 968,765 (0) 100% 100% 149,000 52,897 96,103 100% 36% 1,439,767 708,567 731,200 100% 49% 334,447 334,447 100% n/a TOTAL REQUIREMENTS 8,403,811 6,574,260 1,829,551 100% 78% NET (Resources - Requirements) 402,099 402,099 Beginning NWC per Adopted Budget 392,509 RISK MANAGEMENT Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments TOTAL REVENUES Budget Actual Variance % of FY % Coll. $2,491,977 $2,669,291 $177,314 100% 107% 456,964 456,964 100% 100% 286,294 286,079 (215) 100% 100% 184,195 184,195 100% 100% 855,854 861,712 5,858 100% 101% 160,191 161,683 1,492 100% 101% 25,000 (25,000) 100% 0% 10,000 121,666 111,666 100% 1217% 900 1,830 930 100% 203% 4,000 14 (3,987) 100% 0% 22,000 11,760 (10,240) 100% 53% 30,000 32,539 2,539 100% 108% 2,035,398 2,118,441 83,043 100% 104% Transfers In -PERS Reserve 100 (100) 100% 0% TOTAL RESOURCES 4,527,475 4,787,732 260,257 100% 106% Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 136,185 Repair / Replacement 128,602 Total Property Damage 340,000 264,787 75,213 100% 78% VEHICLE Professional Service 3,080 Insurance 411 Loss Prevention 15,668 Repair/ Replacement 171,340 Total Vehicle 200,000 190,498 9,502 100% 95% WORKERS' COMPENSATION Settlement / Benefit 723,362 Insurance 109,886 Loss Prevention 36,023 Miscellaneous 32,594 Total Workers' Compensation 800,000 901,866 (101,866) 100% 113% UNEMPLOYMENT - Settlement/Benefits 220,000 236,784 (16,784) 100% 108% % Exp. 84,849 3,184 2,546 153,953 25 4,883 365,112 249,439 115,673 100% 68% Total Direct Insurance Costs 1,925,112 1,843,374 81,738 100% 96% Insurance Administration: Personal Services 274,034 272,148 1,886 100% 99% Materials & Service 246,493 194,009 52,484 100% 79% Capital Outlay 100 100 100% 0% Total Insurance Administration 520,627 466,157 54,471 100% 90% Contingency 2,081,736 - 2,081,736 100% n/a TOTAL REQUIREMENTS 4,527,475 2,309,531 2,217,944 100% 51% NET - 2,478,201 2,478,201 Beginning NWC per Adopted Budget 2,500,000 DESCHUTES COUNTY 911 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Year to Date Budget Actual Variance % of FY % Coll. RESOURCES: Beg. Net Working Capital $ 5,137,000 $ 5,611,168 $ 474,168 100% 109% Revenues Property Taxes - Current 6,130,782 6,328,544 197,762 100% 103% Property Taxes - Prior 100,000 301,139 201,139 100% 301% State Reimbursement 24,500 7,096 (17,404) 100% 29% Telephone User Tax 536,000 653,956 117,956 100% 122% Data Network Reimb. 34,000 26,032 (7,968) 100% 77% Jefferson County 28,000 44,499 16,499 100% 159% User Fee 60,500 55,706 (4,794) 100% 92% Contract Payments 70,000 25,574 (44,426) 100% 37% Miscellaneous 8,500 9,006 506 100% 106% Interest 36,000 83,624 47,624 100% 232% Interest on Unsegregated Tax 3,750 1,439 (2,311) 100% 38% Total Revenues 7,032,032 7,536,616 504,584 100% 107% Transfers In -Other 100 - (100) 100% 0% TOTAL RESOURCES 12,169,132 13,147,784 978,652 100% 108% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency % Exp. 3,816,287 3,498,519 317,768 100% 92% 1,289,522 1,197,101 92,421 100% 93% 175,000 39,300 135,700 100% 22% 1,938,939 1,938,939 100% 100% 4,949,384 4,949,384 100% n/a TOTAL REQUIREMENTS 12,169,132 6,673,859 5,495,273 100% 55% NET (Resources - Requirements) 6,473,925 6,473,925 Beginning NWC per Adopted Budget 5,861,335 Health Benefits Trust Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES Beg. Net Working Capital $ 17,894,797 $ 17,894,797 $ (0) 100% 100% Revenues: Internal Premium Charges 10,480,000 10,479,809 (191) 100% 100% P/T Emp -Add'I Prem 55,000 43,758 (11,242) 100% 80% Employee Prem Contribution 330,000 340,983 10,983 100% 103% COIC 1,000,000 1,135,675 135,675 100% 114% Retiree / COBRA Co -Pay 500,000 610,377 110,377 100% 122% Prescription Rebates 42,066 42,066 100% n/a Interest 225,000 208,595 (16,405) 100% 93% Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Workplace Clinic Other Total Materials & Services Capital Outlay Contingency 12,590,000 12,861,265 271,265 100% 102% 30,484,797 30,756,061 271,264 92% 101% 109,297 103,742 5,555 100% Exp. 'Yo 95% 3,000 749 2,251 100% 25% 14,247,576 11,225,228 3,022,348 100% 79% 1,822,000 1,687,568 134,432 100% 93% (108,289) 108,289 100% n/a 372,540 374,287 (1,747) 100% 100% 11,500 1,039 10,461 100% n/a 292,764 358,744 (65,980) 100% 123% 81,648 37,838 43,810 100% 46% 49,572 49,865 (293) 100% 101% 10,000 10,800 (800) 100% 108% 100,000 1,239 98,761 100% 1% 3,959 (3,959) 100% n/a 29,059 24,741 4,318 100% 85% 17,019,659 13,667,768 3,351,891 100% 80% 100.00 100 100% 0% 13,355,741 13,355,741 100% 0% TOTAL REQUIREMENTS 30,484,797 13,771,510 16,713,287 100% 45% NET (Resources - Requirements) ' 16,984,551 16,984,551 Beginning NWC per Adopted Budget 16,400,000 Note: Actual average weekly claims FY 2010 = $266,761 O W (0 U o 0 C L wOo U -0 e0 o c O. C C X w W m L c _ O) c O •_ CC0. LL X CO W O C c6 o o r O aci > (0 > O J (0 C • 2U 0 0 0 Variance Over (Under) �IO Cl` (0 Co Nr co � A � O C�IIto )I:--!,-= 0 M: CD .N CO �CO It O in ,M lr'.0) ''CO N- Yi, r .-- Imo. co Ni.O CD I C). 0O, N IA:r I �, 01 .M.. .... WI 4, '0 a Ir CO 0 ...-1'. Ili I,Ci: , N c0 O1OI� (0 CO 0'100 N. IA M NCO CD 1r , N ', CO CO 1 N N I ,011. I-: �;� co)(D 0) NICC/ ,(DI N,. '' o- O 1 N yy N co r FY 2010 Budget ' O O 00000000000 N IO r � Ir O 0 N 0110 O 0 0 0 cci r- to IA I CD CD O CD 01 O iri N to C) o• O O O CC) O' T I O) It 1 CO O I C. o o- CNO C) (0 O r CO: C.' It' CDI M r M C.ION O i0 CD C0.. 0 O ' 145 CO C. 0I ,,. 0,00'0) IC) O'. 000 0 CDN Orr i0 N. 0 N,COI iN. N O'er rI O) N, -.0O10) ,- N ID !N,N N U1'0O V O 'O,O) o ao k- ., r NI IN!N Ln r1r ' Year to Date Actual O) O C` yr CO r- CO co ' co u') u) 0', o N. o -I co co C'71C,- N .7 INN r 0)1 O) co to co CO r O O 0 IAMr .7 O) O IC) co CD CD c ' C) N 1 co' 0) Iu 0 I '.cr CD N. . CC) II NII W OI OI N � h O '.c O) 'N O I CC) !� Cv N 0,0 I 010! 0IM1N NIACD r I v. ' CD OD: .. O) IC) 0 O 001 (0'0'0 r '; CO r 010 (0 ,I,.N. 0'0O O) N 00 :00 r 1 O O 0 IA NCD I— r 'I'. a a N N IN I( CD hI r w N N . 'I 0 . i N'CO: � 0 CO � N" r, ' !O. 11)•1 , -V :IA CO. 0' O;r co ONO- ' r b r er O CO v. ` !. ' I i' 1 C.� :0 N 10 N O) . o• CO. ' ' '',I� �I ' Ibl O Irl, O IIt CV ICO' SIM p. M IC) 1`- - I'k 1� . . 1, 0 ' 1'N ' ' g N CO' . 'MI COO' N' cc COQ r— ' t0 OD 0 (19,340) O 00 ' �I C. Cl r r "d. i M T t0 (12,375) IE G Q PI ,C0 Ih co 0 r- ' C. CO'N O M N 0 MOO IA C),N O C) CD o r 1 ! ,O ' I ' 1 h ' r O� CDS 0n C) �Ia IA O ' Oi O M It M N N It N v :. O T O, O'. ' Cl N O r. 1 1 ,. ' ' ' ' ' '', 0 r r N N N co r Ni r.. L 2 Cl O co' . N � f` 00 C. coCCCOO (Orr O Tr O IF 0 C 0 co 'IOI' o Oi CAI NI- I, a 'r coI h b rl IC) IF v Cl CO It v_ ' CO CO O co cc O I W N O co CD I 1 IC) v. ' O,N 00 ':vO I O)' i .0-u)' I O to :' I O O o co N CD O r M O CO a r Of CO M'. January February N C) N 'I T ' ' Cl 01I) O. r ' h h ' r CO It O)'. f` I l (0 CD V Of N CM O C- o (O N U) r ' M r CO CO O YY CO M v :1 III 0 0I OI ' to N CO ' ' ' i' ICD ' CO c A CD o .00 00 M M ' ' CO It e0 ''I ' U) N r CD) C- rn L O V ICD ' O N t. el N a N I 1 , O Ir C. CO CO 00 I.- ' ti '',1'O N N N ►• IC C. ri CO IO''. ' 01 O ' MI O .... ' :O ' O C.0 10A ' O 0 CO CCOO N CD CO ci NN December IIA Cl N T--'- 11 C) CSI 0'. o co 0 1 0 M :O) 1 I T ' . 0 CO CD (O r r IV I NCO O v <0 0 f0 ' N V 0 CD' 1 COI 0I 0 r '1st co COI ', 'CD ' CD 0 O O'CO oo M 0� N r y ' 10 0O It Oi V CA CO Iri ' ' 0 O O O C) 1 r N M ' CD' 0) r 3 ICD 1 November I - 46,510 ' M'1 N 1 ,C- O) 00 ' I 0O.0 r c) O co co 00 0o• CD !co CO n . IA co It: r r: a OV r CO N' N. ,M '0I . ;O 1 I 01 . C0' C. to -.. CO M 0 C) N. ' . MCO O 0 iN. CD O)', r; co 0� O I September October O o ' Oi0. O ' ' t. ' OD t0 O O V' co 00 O) O. O co ' t. r 1 r M 0 N Cl ' . N, N O) O O,' cO N O N ' . ' . M Cl ' rr Y N co N' It r n N CAS N' n C0 0 d'� CO C) IF CO ' V 0 r CO a 0 0 O tD M CO ' '�N i . • M ' O 00 V .CA V CO CO O, O ,.0 o CO L ' ' CO O N CCfI M .- 0: O, N , U 1 August CO C: NI 19 18,527 66,273 34,187 100,460 - - -------- (81,933) Cl 42 (81,891)1 > 7 . 1 1 1 1 1 1 1 1 0 ^ONO 0v. CO ' W 0 0I CO 0' Cl.O.. I 42,232 11,000 167 53,399 (28,607) Fair & Expo Center Operating Revenues Event Revenues Telephone Fees - Events Traffic & Security Reimb Storage Camping Horse Stall Rental Concession Percentage - Food Vending Machines Interfund Contract Miscellaneous Total Operating Revenues O Expens Persinel Co tses o Materials and Services Capital Outlay Total Operating Expenditures Net Fair & Expo Center Other Cash flows: Beginning NWC (July 1, 2009) - Rights (Signage_ , etc.) Donations Interest Debt Service Transfers From (To) General Fund Room Tax (Fund 160) Welcome Center (Fund 170) Annual County Fair Reserve Fund Net Other Cash Flows F W 2 Contingency RESOURCES: Beg. Net Working Capital Receipts: Security & Traffic Reimb Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Donations Interfund Contract Total Receipts Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % $ 75,000 $ 42,232 $ (32,768) 100% 56% 12,000 - (12,000) 100% 0% 4,000 3,658 (342) 100% 91% 2,300 1,319 (981) 100% 57% 1,200 740 (460) 100% 62% 540,000 383,679 (156,321) 100% 71% 2,000 213 (1,787) 100% 11% 58,000 43,463 (14,537) 100% 75% 7,000 7,365 365 100% 105% 45,000 22,875 (22,125) 100% 51% 235,000 123,539 (111,461) 100% 53% 86,420 115,000 28,580 100% 133% 3,300 3,300 100% n/a 45,000 45,000 - 100% 100% 1,037,920 750,151 (287,769) 100% 72% Transfers In General Fund 197,919 197,919 Transient Room Tax 22,765 22,765 Welcome Center 80,000 80,000 County Fair (619) 197,421 80,000 F & E Reserve (617) 250,000 (117,421) 250,000 Total Transfers In 498,105 630,684 TOTAL RESOURCES 1,611,025 1,423,066 REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfer to Reserve Fund (617) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Beginning NWC per Adopted Budget 824,769 531,604 116,188 100 16,412 121,952 1,611,025 100% 100% 100% 100% 100% 132,579 (187,959) 100% 100% 100% 100% 41% a) n/a b) 88% Exp. % 774,532 50,237 100% 94% 516,092 15,512 100% 97% 116,188 0 100% 100% 100 100% 0% 16,412 100% 0% b) 121,952 100% n/a 1,406,812 204,213 100% 87% 16,254 16,254 2,809 a) Transfer from Annual County Fair fund will be $117,421 less than budgeted. b) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund. Accrued Revenue (Accounts Receivable): Current Month Events Prior Months Total Accounts Receivable 12,360 15,831 28,191 Deposits Received for Future Events: FY 2011 July 104,764 August 89,300 September 4,170 October 2,600 November 4,550 December 275 January 100 February 620 March 500 April 1,800 May 600 June 800 FY 2012 & beyond 6,550 TOTAL 216,629 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES Deschutes County Bethlehem Inn (Fund 128) Year Ended June 30, 2010 and FY 2011 Budget FY 2010 Budget Actual Variance FY % Coll. $ (2,666,469) 2,766,469 2,766,469 $ (2,689,172) $ (22,703) 100% FY 2011 Adopted Budget 101% $ (2,725,000) - (2,766,469) 100% 0% - (2,766,469) 100% 0% 100,000 (2,689,172) (2,789,172) 100% -2689% REQUIREMENTS: Expenditures Debt Service: Negative Interest Revenue Interest Payment 100,000 33,338 Exp. % 66,662 100% 33% a) TOTAL REQUIREMENTS 100,000 33,338 NET (Resources - Requirements) Beginning NWC per Adopted Budget 66,662 100% 33% - (2,722,510) (2,722,510) a) June 2010 interest expense - $2,221.55. b) Recap of expenditures - inception through June, 2010 Land/Building (Amertitle) - July 2007 Hickman Williams City of Bend - May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended $ 2,241,313 17,578 250,000 5,289 3,732 2,517,913 204,597 $ 2,722,510 b) 2,861,000 2,861,000 136,000 36,000 100,000 136,000 U) `) C 4) LL! a) 1 H Oar coco w N cc O ', V N U �� (pC O 'C N L▪ O Ll}. O c O o ma. O N 16) cv LU C E 4) 0) U C C O U O 0 N O) co >- 2 2 LU CL YTD Total' 0 CO co 1.0 CO .— N In r-- 0 1n co 11) I' N 0) O "et O'— 1n CO co co 0) N O c- CO In co N M 0 NU) 01 4N 10 0 I- O M 1 n C r CO CO r CO In M N CO C7 0 0 CO 0 0 CO In M N CD O) I) In co c- M 1 11, O) (D u5 In co r 111 o) 0) csiH O1 N N N I 13 j C -3 (D 229 285 I. O is. IA r M I N w > RS 00 r. 1 1 1 100 1.0M N 77 386 I 752 (Ni 1 1 1 I 1 _L5C1 O CO O CO I+ f'..1 (p CO I N iO Ilr -t QQ O O N r- I co O� 1 cv 1 1 I- 1 ti 1 10 1 1 1 10 i~ 1 1 co O NCO r 1 co co 1 I O lid co M 1 1 1 M t 30 co (() co 30 30 t 06 M Feb O N i1"-- I- (D CO ' 483 1 57. r CO T 11 1 ' N 1 1 1 1 i• 0 CO 300 I O CO ILL 1 1 1 CD 1 CO 1 In N 1 1 1 '1 r 50 1 1 �,' 11 --- 501 1 1 CO n. I Dec 1 0 1 CRS i M, 1 486 220 1 N- 0 � 1 507 1 1 r CO COI, 0)I 1 0 �1(0 1 1 0 01 O0)I > Z1 O N 1 C3) 0) N I I 319 M .-- r CO r 485 1 I tt T- 1r, 1 1 I 1 1 1 1 M M T I Oct O co In In if)110 M 1n Cr 1,578 0 CCS) 1n N N if) 257 •t M COCO 350 624 1 LO T IIT 1 1 0 0 401 CI) 1 i, 1 1 II 1 CO S 1 1 1 1.0 CO 1 1 1 1 1 1 II I I 1 1 1 687 172 7) Q 1 I 1 1.n. N 1 111 (.4 ! 1 (V P. -N (Y) 1 CIi 1 1 1 1 1 ! 1 1 1 N 1 1 1 I 1 1 1 ! 1 1 1 I 1 1 1 1 1 1 1 1 1 1 1 Tammy Baney Conf/Sem & Educ/Training Travel Meals Accommodations Mileage reimbursement Ground Transport/Parking Total Baney Dennis Luke Conf/Sem & Educ/Training Travel Meals Accommodations Mileage reimbursement - Ground Transport/Parking Total Luke Alan Unger Conf/Sem & Educ/Training 1 Travel Meals 1 Accommodations Mileage reimbursement Ground Transport/Parking Total Unger Other Conf/Sem & Educ/Training Total Other Total - BOCC Department Conf/Sem & Educ/Training Travel Meals W U w m 2 co w cc 1- 0 z w W - J uctZ 0 1 C ›- cc cc Z_ 5 J w a PROJECTION - J 0 a) 0) vCL m a) a) co OD RESOURCES: o O) O ▪ LO- N— M O O O • o 0)00) tt O cr LO N N M CO CD 000 0 0 0 O0 O N - MCO co CA co LC)• N ti N M o co i O � M • NCO N 1� N M CO CO 0 (1) U a) U co co m c• v) 0 V N U C co) d -o 2 co E r- O O N CO N.- CO CO In cam-- ' l() ' CC) N ' CO CO CN N -OO M (0 O 0 O N CO — 0 0) CO U) 0 O N 0 0 N.- CO CO L() COO LO N0C -0L() CO O 0 CO) N CO CO CO L() Oco- 0co- OOONCO - - co Co 00 CO co in oN- oo 0 O v ' o o) ' 0LO ' ' ' N c0.1 OO O, .— CO 1. N- CO 0 CT�ONNOMN- COOO 0N-00(-MNOM-00 COLf) Id) �Cr) NN- OOCOO OOtri CpO 1(0— M co 0 N N CA�ONNOMN- COOO 0)N -LO - N0c) -00 CO O Cn CA N tt CO CO CO O OI�CO- OC')OONCO iM coO 0) M Cr) ti _ti O (1) (0 co CO CO CO CA CO CO CO O r - O N co CO C0 0 co CO 0 O CO 0 0 O 0 CO CO O N N d O N co CO O Cl) N CO N- NCO 00 0 O CO 0 CO N d• N- (1) o co CO CO O O Ln CO N O O M CO N O 0 cri CO M O O '(•) CO N O O M v U) CO C70 C0 M N- N- CO - L.6 COO N CO N 0) C7) O co O CO ti c0 0) ce ti 0 CO LO CO C7)M O M N LA Cr) cu o .t,U = U a) cn 0Z a 112 )co c R c O = = �tS a) O += 0 °) uci) v) ci . C > co c a) O V) •- a) a) 0) co 7 Ls 2 To O > W O o co d LL " 'C U 0 O c S C) U) 0 a) E m t. U U co y I.E. E .co 1- 0 co v a) 0 _°c) c c d •N 0) co O° 7 o a) o V Z m �= C C C y N O N �' O U �. to u) d • 2 c) a) co -- vim) a) > .c = C t ° a) E. D 0 - m a) -o c �. •— .r w�¢wi--d cwQa02O -.ca. a) Total Expenditures z Lo� Z CW L a) O a0N U . o o co ca Q a) U v U 45 ° �L w m C W 0 a) 0 c a) (D = m 0 Amount Paid a) E E O E O Q 0 0 n 0 0 a) 0 rn N CO (n CO O i - CD CO 0) CO- Co' CD CO M N 14) CO O O 0 O Q) O M do' co (N O N LC) CD O d' CD 0 N N ON N i- LC)N NCDCON014)N-000�•:1- O 0) CA ct CO NOO(nMCT) ctCf) N CO 0) CO i,- CA CO CT/ (n CT) LO O In CDC71N CONN N MCD N h N O CD M N O O O co co O M 0 co to rn o p O r: CA g CD Con C") M ? N ( r (C') a) ER 'n E - O O .'NiC'0 w0 co a_ N CD o i O co O a) co pp CO N CD CO COSCO O ER o� co In o (D fn CD o ^ N d' a) �0 c A 0 0 0 0 � �`- N� a) m 0 3 0 0 0 co,_ o Y 0 o ..cam 0 cc cn 03 rn o � � ` O ' .-. COv � 0 0 ° ccD_ COQ L COAD .3 O. cM oocootS m a) E�ea�COCjc `pU aa)) CT (13 o °° o EA .2e Y Q �. ; 8 "' ".40 :-.0 CEC-15OER O u0) C C ._ Cn O CO \ a) a) = '5 CD SER 5 �� c5m���v3,�oonmo v) a)cn m co ° co .-•. 0 ° cDpcn0m E a) U O d 0 co w 3 0 .N .N O co V y C CT a) O C 20), ) ZT O O CD 0 O N (v N C c6 Cfl = 10 CD N-0 a) CD C N 0 ` N` O b b 03 a) " o O L• " a) N L O _ C C- c .. N 7 7 L 0= C (� C cr To n U° o u) c c U 3 .�2 w E Y~Cl- o s 0 x To as U O ° 0 = c= w p `n 6 Cn ti 0 U rnW •C cn To a) 0 0 a (o a)=Du))DM>QO2LL w E cn .cm 7 0- = E C NMCI) CU QD2a rt ��O�NMd LO O(Aco Total Architect Powers of Automation Tomco Electric Engineered Structures Inc C0 N (C') CO O CO co - CD O CD M Total Engineered Structures, Inc. Total Encumbrances & Commitments PROJECTION J 1- 0 CV 0 c .` CO 7 To O F- 0 N N to ET 0 a U 0 U C CO .0 E 0 U C w & Commitments 0 a w RESOURCES: CO 1- 0) 0) ti CO M N. CO N M N 0 O N CMO CO CV N O M O O O N M O O v co O O 0) cc Cf) CO a) N CD N CO (-6 N CO 1- 0) N v ticoa)v M o0 0 o0 Lo N M CCD c) N O M (0 N CD C4. V (0 (0 ti to 1'- 0) M M CO 1- 0) N F- I` M 0 CA 1` CO 0 ' Fs M 00 00 00 0) Ct)Mr- 0c) N M CO M c) A- le co 0 U O U O C 1- c0 to co ) 0 O N. -0 N C c 7y L_ cii2 , 0 N C O 3 C 0 U 2C9i6I6r2 17Q)c2_ moLLI.=SFo- EXPENDITURES: ✓ o) 10 CO o) 10 o) M N. 0) CD CO '- • N ' vCO O' 00 Cr N N- I Cf) 0) 00 Cr; '-0iMONCD00)CCDD 0(0000 • N O CO CO 0 0 0 CC) N O N CD r- Cf) N 0) Cr) N O CO 0)) O CON. CO O O 0 0 0' 0 1-' 0 0 ' ' 0 0 I- - Nd (5, '- O CO Ct) N 1.0 CO N N. -tO 0) O 1- CD 0) CO Cf) 0) CO N I- CO Cr) 1- 00 0) CO CO 00 ti CO O) N Cr) CO O Cf) CO CO 6'054 O N ti 4, CD N 0) LC) N N I 1 1 1 1 I I� O O O co 0) o0 u) 0) CO N A- CD M 1- 00 0) CO CO CO - CD N N O) ' CO 0 CO CO CO C6064' 0 N N 0) N N 00 0) M C CD N A- A- co - A - co 0) co N 0) L[) O CD 0) O O N '1'00 0 0) Q 10 CCS 0 M N N N CO O O O N O N 0 0 0 Cf) 0 O 0 O 1i6CD C0 ,- C0 COCDCOCr) LC) (0 M N 1- N CO N C0 ' ' O O O Cf) CO Cf) Cf) MN CCD M CO 10 00 't ' O 0 C0 10(0 CM'S N 00) CV - C0) 0) N Cf) Cf) ti O ":t coON 0 0) a0 N Ns A- 0) 00 00 O co O_ CD ti 10 Cf) O 0 Cf) CCS M CD N co Cf) Cn M 0) N CO 00 00 N co N 7 d a) X_ t1 y U LL .Z U Z U ) o N N Vi u) E as c 0 o3� C N y>« co 0 U N N (O o 0 0 Nin in 7 asO E 3 7 0 U N (1.) 0= DI a) Of .c • = ' U N 2, �+ 2 O fO 1-t a C N 0 € U CC m V) N a 00 p7) CC °d w` W a -p U N— ...?".E2 j c N /1220 waoim:cE cca�'0)'3°O po >jo m c c Cc`a c 1-1-2 Uoon=cis'rnno o> c r c° o m a vai 'v5 E E o C N - N "O 'C ..• •- F' o c 0 3 cv F- m<wF-aSSw<awo2 UZDOUIiF- 10 N M O 1- co C0 (0 N9 to M Total Expenditures N 0 0 c4) 0 0 z PROJECTION w 00 w m 2 co 0 • c o ? u_ N 0 O ..O z U 0 M w 2.;) O 7 r d r w U z O T rn G CL z J w a O 1 - ti U 0) O - 0_ m O a) 0 o 0 to 00 c co E o c0 Received and a) c a) 0. X w RESOURCES: O O O r -- co- CM Ln CC) N O O N O N O CO O CO O N O N O N NC000) cri ri (.fl T M I� O T it) co- 00 CO N co co CO M I CO T M r M ci L0 MCO N 0 U 0 U c 4- 0 m c to CI) C a) 2 0 O O c o a) mw m a) c co w O w To H ▪ M I- a) co Lo Occ0 4- o O) - ' N ' - CO 0 '�CO CO- d vN 1 4_ r- v dr CO O O N CO O O lti O CO O TOMOCOCI) CO000•:1- 00 O) N...F CD CO CO 0 0�...F d- CO O l(i T V N O N N. LC) N O) N 0 a) 0 co 0 0 O I� T N O O N LC) N (0 di- - COM�0C0a)CCO OOC�Oa or - T N O T CO O CC) CO CO Na0N N T I� CO 0) Co i i 1 N � COCOMoCCO(0CCOOCCOCCOO)Oo N T N O T CO O lti d' CO CO M 00 dr O N NZT N I`• N D) N O N CO 0) C0 (0 00 C0 N M co C0 N co 0) C0 N Lo C0 N d- O O d r N T d- O t0 M O co) '- M ti N v O) O CC) x- 00 00 O O 00 00 00 d- d- O ONO M O co- r- •• ti CO N T CO CC) N N Ch (0 Lo 0) cri co N Lo- co !) r -- r -- Lo (0 Lo 0) M CO N Cc) M M N CNO 1- 00 0) M 0) 1- 0) CD 0) c0 N N 00 0 00 I� r co O O Ni Tr - O O 00 is - CO CO N M T T N T o o ci U Z ^ U U z a) a) in U) co c in c.) >=0lf c -. co _O °) • O U) CD o N m m 0) co 7 o Es w --o U N d u_-, ,_ U >�O. = %O a) t o a) a) :: �, -0 O CS 7 ,c a) V co 0 0 c0 ti a) a 01 H_ at) U C v) o -0 U a) •N s CEQ O. ° m e .c m a r r y co O U a) a) �a z cos.c;= c`C vi a):= w O a)•• • 3 N =•. W v rn c cp N o> c_ O s - a) c H W�¢w�a5 cii¢a`m O UzmO Total Expenditures w z a) U c a) N 7 N a Amount Paid C a) E E O E E o Q U c O 0. .c U co a) 0 1e3 c a) o a) Co o O 0) O CO O N O O r'- %- N u) N- N N d' 0'- %-- Lf) N N- N N 00O 00 O O 0 a) O a) 0 N t- a) O N .- N a) a) cI) U a) N 0 a) O c Ta c C X O w • p aCe LCA Architects LCA Architects Total Architect Interior modular walls Herman Miller O Co u) a) Co d' NZ 00 O CO U) O N-000'-Ot-COCO0N0000 LC) a) co Co co co a) O Co CT N O a) 00 Co d' O MMd'00LC) 00tnr- no_ 0.-N c0 r N to 00 O0 .- d O d O d NZ O O O In N O 0 0) E a) Cd a 0 0 0 0 -a c Powers of Automation Tomco Electric N M CO M N Lc) ..� u) �. O N N ^ M Co 0 COOc 00 CN 00 c d'co d O CA Ud) O N 0 a)0 hi.-. a) -1- Oa Ea 0 r- N a)ea \0 Co •- " .- ^ O Oo C 0 d 0 0 Ea C O co) O N Oe a) Cn•Oo 0 O oe• cA M OHO oEAL �o O� crcn 03 a) p d 1:27 Co p O nj .Mi Efi :co C EA K� O tT .-- O cA O. F N o cn nj cn 3 d c �. Hf./2d' >'U to p C c N �t `O N `)a) e. �'c p 0 v c0 d;h a) 2 E• 2 iJflflU! co cooU 7,0• a)— o= a }.DcnD2QU�Q c ca) 2 Q D u_ O c o.- NMincoaoo '°)2t rk W itItItItItItIt O 0 Engineered Structures Inc 1- N O 0 r- -1- 1: N r- 1- -1- -1- O a) O ts•- O co O a) c0 O N co co co � co Lo N co N N Total Change Orders Total Engineered Structures, Inc. Total Encumbrances & Commitments CO O • o wuo c >N O w M 0) O` C CD fa.. rn a U - a)~ 0 PROJECTION O 0 fa -c co ta -45 a) 0 O -a CL. m Encumbrances & Commitments Received and RESOURCES: O O r O) M O CO O 0 r N OC) 0 I� CO N N 0 N O t0 t0 N 0 O r 0 M co CO O 0a) r ' O OC) c0 N CD I� N CO r N • 0 00 Nt CO 0 ' ' N cci o CO wt. CO 0 0- c c U- • U- Transfer In -911 Transfer In -911 Federal Grants co EXPENDITURES: M O N 0 N CO N O O O O 0 0 N M N co co co O 0 1 1 I 1 I N 0 0 0 N O O N O 0 0 0 0 0 0 N 0 O 0 0 0 0 0 0 0 0 0 CO Ti O 0 0 0 0 0 0 0 0 0 0 N �) r 0 0 0 0 0 0— O M r N r 0 CO I'- f'.) C'�) c) (00 N N r r r N 00 0 0 0 0 0 0 0 0 0 co co co co 0 0 0 0 0 0 0 00 r to 00000 M r co — co CO I'- M M N N r r r N 0 0 ' Co N N N 0 0 N N O co O CO O 0) 0 r O O O t0 t0 N 0 1- 0) u) LL c a ch d a) 2 X OJ 0 ILL ocs 0 ac) 0 7, v) co m E us ca co 0 a0)fEoO 2 • c �O U a E E rn • 2 ct 0) 0 co • = as a) L a) 0) u) �, >, (n ° a oa j a) a) E(.)= o a) w d ais .. v co O p as ? a a'c p c o C aY CO O c " r 0 51- •E o wo�i -c co co 0 u H Total Expenditures 0 0) N O 0 d Z Amount Paid O N 0 Radio Dispatch System 0 co) ti a) L() a) a) ti P�JECTION `a) a) U a) O U a) CA _O > Q)) O C 7 N 7 L O) y M N D CDC T L U = =CD O) �� o ca) ~ E H U C/) a) U ca ca a) a) co O` o 0. m 0 U a) O cD oD a CA CA U C a) E E E U O w v aS RESOURCES: N c))) O O ' O ' O N co O O O O O O O O O 0 M O N O CO LO la I O 0 O N co O M O n O M O N 0)o -0c') co 1c N 1 N 00 N CQ y O O N CD V O O) A- CO O) v c.) lC) (0 O h ' 00 lc)O ' O O O) et. O N M In CD et O O) M N co O) O et O) M co O r co O) O) — O N O) In et 0 CO O CO 0 0 1 O cD O 10 M O M N 10 N N A- O O O CO O) O O O O O ' M N O' O' O) N 1() O CO- N I's A- A- CO O CO N O M O CO N O co O N 000)-0)("4 M M CD CO O 1- CO O) N 1- CO N O) 1l) et O t` CO N CO 0 A- O.- O O) O) N 00 CD 00 1l) O N MA- 16 16 O) O) CO N r 0 N L 10 00) 11) 1C) ' M O O O) N 1- CO 0) N O) t- co 1l) r co 0) N M N O) O) a co r- M N M O A- A- O N co N O ll) O N c) 16 N 1- 0 OC•1 c5 M M 0 to 1l) N N CO CO O O et O) M co 0 U c.) E m N C O C •� (� 7 U a) Ce C` v)($) O 4.7. E a) a) >t N 0 z a a)to 1a o 2 0 m :+ H co p) O (1) Q 7 C O C E O N Cl)'°� O 0 Miri o C Tij O LL L. ` 1a a c c 0 re m rn c L E a m :: �+ cas E. m W>= H i C E U E 1a CO a? 1a o aZi ami o @'L co' au' O, m ami o �� �) ti v?� p 2�— �� x C7w_� y Z ms ., m c't v) a)Y o > C 17) N G ,.. 0W C a) C (a W i C op C cm ca +O' a) C-0 t. .0 @ H O O H C 0 CO W¢ CLQ�Uag0— oJ c �UH Z U a) 2. �O a) m 0.) CO r N CD 1l) O Ea. O a) O O0_ N acv Ur a) -o 2 c a3 N N U U C O 7 co N > G 3 O O U O O >+ N M 'j O ea a tea, c_ .° Oar a) C ca > � y d o O O U U C 46- 6- CA M CO w .- M ONA- UN O t co c, .0 ;73 y o coO a) N gLL o ¢ o c• • 0CD co c N N O m 6g m 0) to 7 LL Q) F- U w 2 a) F- ocp CD N cn U o a co zZ U Q a W \ U � z O V m • cu LL D c U OZ W `) 1-- c.) Q) (1) C Q) CO 7 to 0 Amount Paid M CO tt7 0) 00 M MN CD 0 0 0 0 O N. N. O co O O O O N. N. ' N O O 0) to M M Co M M O 0 0 0 0 0 00 0) CD tt) CD 0 0 O f- O) CO MLC) 00 tf)0) 0) M t.Ci CD O N N N 0) r- N vi 3 a) Y C x a) Ct yO (O U YC •..7 .6 u)a as •CC . 1' 3 O.0 �v-0 i CO la O C N V C C 7 a)c Z o oaoiooa�i N a) 0 c _C E w o O) p.. C U 0 0 co tL0 c W >. 0 cn O c w w 0ccn v c•c EL = C 0) V N N CV as C �, L E O V 0 C O U0_0 C= C CT Qre WCJ(/)Q 0LL0 ° D a m Q) Q) CV CV O U U U 0 >, * 4t cD a 0 0 0 c tD Q) U U U .0 L"O O U V 0 00 Q Q Q Q W n O Q) as CVO c as O N m CO CO ch C 5j L L c c c c o v)00 as aa0< 2 Change Order #3 M M r t() La O O co co co o M cc) M Total HSW Builders Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of June 30, 2010 "Area A" "Cell 5" Landfill Closure Fund 611 SW Capital Projects Fund 613 Total Engineering Contract G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through June 30, 2010 Balance Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order #1 Change Order #2 Change Order #3 Total Paid through June 30, 2010 Balance 241,869.00 19, 656.00 261, 525.00 254,413.43 7,111.57 182,516.00 182,516.00 153,904.43 28,611.57 424,385.00 19,656.00 444, 041.00 408,317.86 35,723.14 2,097,140.50 3,290,779.98 5,387,920.48 2,097,140.50 1,707,132.00 390, 008.50 Total of Engineering & Construction Contracts Original Contracts Change Orders Total Paid through June 30, 2010 Balance 2,339,009.50 19,656.00 2,358,665.50 1,961, 545.43 397,120.07 45,094.00 14,302.54 24,885.69 3,375,062.21 2,054,537.51 1, 320, 524.70 3,473,295.98 84,282.23 3,557,578.21 2,208,441.94 1,349,136.27 45,094.00 14,302.54 24,885.69 5,472,202.71 3,761,669.51 1, 710, 533.20 5,812,305.48 103,938.23 5,916,243.71 4,169,987.37 1,746,256.34 Notes: a) Additional landfill gas investigation per DEQ as part of a requirement to address offsite landfill gas migration. b) Construction of CeII #5 began in FY 2008. Through June 30, 2009, $3,557,678 has been expended and reported as "Construction in Progress" on the County's CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction, Taylor NW, KN EX Co, Jack Robinson & Sons. c) To date in FY 2010, payment has been made to Central Electric Co-op: $13,311 for the Closure of Area A and $20,822 for CeII 5. RV Park (Fund 601) Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Year to Date Budget Actual Variance FY% Coll. % RESOURCES: Beg. Net Working Capital $ 50,000 $ 2,431 $ (47,569) 100% n/a $ 50,000 $ 2,431 $ (47,569) Revenues RV Park Fees < 31 Days 158,580 96,572 (62,008) 100% 61% a) 158,580 96,572 (62,008) RV Park Fees > 30 Days - 10,710 10,710 100% n/a a) - 10,710 10,710 Restitution 3,643 3,643 100% n/a - 3,643 3,643 Washer / Dryer 800 948 148 100% 118% 800 948 148 Vending Machines 450 450 100% n/a 450 450 City of Redmond 500 500 100% n/a 500 500 Room Tax Collection Fee 500 500 100% n/a 500 500 Interest on Investments 300 326 26 100% 109% 300 326 26 Cancellation Fees 1,803 1,803 100% n/a - 1,803 1,803 Total Revenues 159,680 115,453 (44,228) 100% 72% 159,680 115,453 (44,227) Transfers In -Fund 130 190,000 190,000 - 100% 100% 190,000 190,000 TOTAL RESOURCES 399,680 307,884 (91,797) 100% 77% 399,680 307,884 (91,796) REQUIREMENTS: Expenditures Materials & Services Debt Service Contingency Exp. % 83,760 80,732 3,028 100% 96% 83,760 80,732 3,028 242,571 242,571 0 100% 100% 242,571 242,571 73,349 73,349 100% n/a 73,349 73,349 TOTAL REQUIREMENTS 399,680 323,302 76,378 100% 81% 399,680 323,303 76,377 NET (Resources - Requirements) (15,419) (15,419) - (15,419) (15,419) Beg NWC per Adopted Budget 15,000 15,000 a) Approximately 3,353 space rentals. ( $96,572+ $10,710) / $32 = 3,353) Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 50,000 $ 2,431 $ (47,569) 100% n/a $ 50,000 $ 2,431 $ (47,569) Revenues RV Park Fees < 31 Days 158,580 96,572 (62,008) 100% 61% a) 158,580 96,572 (62,008) RV Park Fees > 30 Days - 10,710 10,710 100% n/a a) - 10,710 10,710 Restitution 3,643 3,643 100% n/a - 3,643 3,643 Washer / Dryer 800 948 148 100% 118% 800 948 148 Vending Machines 450 450 100% n/a 450 450 City of Redmond 500 500 100% n/a 500 500 Room Tax Collection Fee 500 500 100% n/a 500 500 Interest on Investments 300 326 26 100% 109% 300 326 26 Cancellation Fees 1,803 1,803 100% n/a - 1,803 1,803 Total Revenues 159,680 115,453 (44,228) 100% 72% 159,680 115,453 (44,227) Transfers In -Fund 130 190,000 190,000 - 100% 100% 190,000 190,000 TOTAL RESOURCES 399,680 307,884 (91,797) 100% 77% 399,680 307,884 (91,796) REQUIREMENTS: Expenditures Materials & Services Debt Service Contingency Exp. % 83,760 80,732 3,028 100% 96% 83,760 80,732 3,028 242,571 242,571 0 100% 100% 242,571 242,571 73,349 73,349 100% n/a 73,349 73,349 TOTAL REQUIREMENTS 399,680 323,302 76,378 100% 81% 399,680 323,303 76,377 NET (Resources - Requirements) (15,419) (15,419) - (15,419) (15,419) Beg NWC per Adopted Budget 15,000 15,000 a) Approximately 3,353 space rentals. ( $96,572+ $10,710) / $32 = 3,353) T 0 C cis U 0 to 0 D c (1) 0 a 0 CCs f1 0 0 0 Occupancy L M C RV Park Fees Actual Received: \ \ \ \ \ \ \ \ \ \ \ \ \ 0 0 0 0 0 0 0 0 0 0 0 0 0 CD s•- O In N s-- CO O In co r t` en co .71' CO N N . - s-- O O 0 CO N cam- 14) CO szt CD 0 CI 1* --CSO C CD N M Iii P'sc7NCe) NNNCOM CO szt 1- CO 1' CO CO 1' N N CO N COf+tnCOCDN I+InCDcs) In 00 co vr O CA Co N co O In r co co N N c- CO O N N N A) CO N O ti N c- c- N 0 0 0 0 0 0 0 0 0 0 0 0 0 OCoTOOCocoLo NSM CD CO Cn CO CD 1' In r N In ti Co 0 O6II7r6C5OTiP-6NK 0 CO 1- N r M 0) 1- O o, r• O 0 CO In 000IS) MNNN 1tCc) Nc r NNIs- h. N 11) 1- 1- M s O N COO 1- CND M M CO O r Co 1 Co r- C0 0 0 0 Iri s-" Cn co r- v ti ti cM ti r -r N COCD 1 In C 8° \ \° \° \° \° \° \° \ O C C 0 0 0 0 C 0 0 0 0 C 0• 0 N(OP-�I-M000)0N-C7t1)O) aj'1 co O•Olnd: co.r-O) Jo II l6 ti 6 c N O O r N O O) Cp M M O N r T- CO O N U In N OCo001�InMNN0)CO 0.IOn NCD COONtic� Cf) CO OCCOC)COCO0 �� s- M M -0 rn C N c n 0�t °) �0 O d- C7 C0 CO N O CD d' CD 1- CD 0 co r .-. M C'7 s- d' CO C'7 CO In N Ce) a0 M CO c) Co 00 C') N d 000000)1-0 Cr) Ca•CA C))co" CC)NT- NCAN- Tir II cns-CD C7N CA CD u)CO s C7 N E9 in CD ce) a) 0 O To' N 7 N ate.. E N a Q cp0 O CO U co i I5 ii) a) �, 0 N N a) E E 0C3 40 .. CD 0 >>'aa))oommcpma�=a1)) —, �¢cnOZo�u_M¢M�>- s- Building Services - 620 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 272,938 $ 439,838 $ 166,900 100% nla Revenues Cleaning/Maintenance 85,475 61,643 (23,832) 100% 72% Utility Reimbursement 9,000 8,102 (898) 100% 90% Facilities Charge to State 136,464 183,693 47,229 100% 135% Miscellaneous 63 63 100% n/a Interest on Investments 10,000 5,934 (4,066) 100% 59% Building Svcs Indirect Chgs 1,745,275 1,745,275 100% 100% Total Revenues 1,986,214 2,004,711 18,497 100% 101% Transfers In 222,844 186,844 (36,000) 100% 84% TOTAL RESOURCES 2,481,996 2,631,393 149,397 100% 106% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 1,554,315 1,510,151 44,164 100% 97% 799,681 748,334 51,347 100% 94% 36,000 36,000 100% 0% 92,000 - 92,000 100% 0% TOTAL REQUIREMENTS 2,481,996 2,258,486 223,510 100% 91% NET (Resources - Requirements) 372,907 372,907 Beginning NWC per Adopted Budget 310,000 Admin Services - 625 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual _ Variance FY Coll. RESOURCES: Beg. Net Working Capital $ 120,000 $ 117,586 Revenues Miscellaneous Interest on Investments 4,000 Admin Dept Indirect Chgs 692,295 Total Revenues 696,295 Transfers In -General Fund 40,000 81 1,680 692,041 693,802 40,000 $ (2,414) 81 (2,320) (254) (2,493) TOTAL RESOURCES 856,295 851,388 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 640,536 148,443 100 67,216 640,355 147,799 (4,907) 100% n/a 100% 100% 100% 100% 100% 100% n/a 42% 100% 100% 100% 99% Exp. % 181 100% 100% 644 100% 100% 100 100% 0% 67,216 100% 0% TOTAL REQUIREMENTS 856,295 NET (Resources - Requirements) 788,155 68,140 100% 92% 63,233 63,233 Beginning NWC per Adopted Budget 120,000 BOCC - 628 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 50,000 $ 68,511 $ 18,511 100% n/a Revenues Sale Map Photo or Copies 100 69 (32) 100% n/a Interest on Investments 500 1,263 763 100% n/a Admin Dept Indirect Chgs 573,417 573,207 (210) 100% 100% TOTAL RESOURCES 624,017 643,049 19,033 100% 103% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 490,156 488,305 1,851 100% 100% 74,247 58,244 16,003 100% 78% 100 - 100 100% 0% 59,514 - 59,514 100% 0% TOTAL REQUIREMENTS 624,017 546,550 77,467 100% 88% NET (Resources - Requirements) 96,499 96,500 Beginning NWC per Adopted Budget 100,000 Finance - 630 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 RESOURCES: Beg. Net Working Capital Revenues Investment Fee Photo copies Interest on Investments Interfund Contracts Administrative Fee Finance Dept Indirect Chgs Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Budget Actual Variance FY% Coll. $ 740,000 95,000 18,000 28,000 12,000 716,422 869,422 $ 777,692 $ 37,692 81,828 47 8,277 28,000 12,000 716,161 846,314 (13,172) 47 (9,723) (261) (23,108) 1,609,422 1,624,006 834,911 354,486 80,000 340,025 833,369 222,153 100% n/a 100% 86% 100% n/a 100% 100% 100% 100% 100% 46% 100% 100% 100% 97% 14,584 100% 101% 1,542 100% 132,333 100% 80,000 100% 340,025 100% TOTAL REQUIREMENTS 1,609,422 1,055,522 NET (Resources - Requirements) Beginning NWC per Adopted Budget 500,000 Exp. % 100% 63% 0% 553,900 100% 66% 568,484 568,484 Legal - 640 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 87,000 $ 102,125 $ 15,125 100% n/a Revenues Sale Map Photo or Copies 300 54 (246) 100% 18% Miscellaneous 3,000 32,222 29,222 100% 1074% a) Interest on Investments 1,500 1,619 119 100% 108% Interfund Contract 2,000 10,846 8,846 100% 542% b) Legal Counsel Indirect Chgs 699,907 699,907 - 100% 100% Total Revenues 706,707 744,648 37,941 TOTAL RESOURCES 793,707 846,773 53,066 100% 107% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. °A) 679,034 677,691 1,343 100% 100% 54,252 43,186 11,066 100% 80% 100 - 100 100% 0% 60,321 - 60,321 100% 0% TOTAL REQUIREMENTS 793,707 720,877 72,830 100% 91% NET (Resources - Requirements) 125,896 125,896 Beginning NWC per Adopted Budget 90,000 a) Charges to 911. b) Contract with DA's office for Steve Griffin Personnel - 650 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY% Coil. % RESOURCES: Beg. Net Working Capital $ 360,525 $ 423,562 $ 63,037 100% n/a Revenues Miscellaneous 500 1,064 564 100% 213% Interest on Investments 4,000 5,198 1,198 100% 130% Personnel Indirect Chgs 632,941 631,069 (1,872) 100% 100% Total Revenues 637,441 637,330 (111) 100% 100% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 997,966 1,060,893 62,927 Exp. % 583,859 569,669 14,190 100% 98% 336,007 139,466 196,541 100% 42% 100 100 100% 0% 78,000 78,000 100% 0% TOTAL REQUIREMENTS 997,966 709,134 288,832 100% 71% NET (Resources - Requirements) 351,758 351,758 Beginning NWC per Adopted Budget 290,000 Information Tech - 660 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 RESOURCES: Beg. Net Working Capital Revenues City of Redmond Miscellaneous Interest on Investments Leases I T Indirect Chgs Total Revenue Budget Actual Variance FY CoII. % $ 437,214 1,000 12,000 1,910,076 1,923,076 Transfers In -General Fund 65,001 $ 538,155 $ 100,941 100% n/a 14,310 189 7,184 12,222 1,910,076 1,943,980 65,001 14,310 100% n/a (811) 100% 19% (4,816) 100% 60% 12,222 100% n/a - 100% 100% 20,904 100% 101% - 100% 100% TOTAL RESOURCES 2,425,291 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 2,547,136 1,729,580 1,717,735 502,227 342,352 100 193,384 2,425,291 2,060,087 121,845 100% 105% Exp. % 11,845 100% 99% 159,875 100% 68% 100 100% 0% 193,384 100% 0% 365,204 100% 85% 487,049 487,049 Beginning NWC per Adopted Budget 435,000 IT Reserve - 661 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 RESOURCES: Beg. Net Working Capital Revenues Interest IT Reserve Charges Transfer In -General Fund Total Revenue TOTAL RESOURCES REQUIREMENTS: Expenditures Materials and Services Capital Outlay Contingency Budget Actual Variance FY % Coll. % $ 350,938 $ 373,691 $ 22,753 100% n/a 2,000 5,504 3,504 100% 275% 234,000 234,000 100% 100% - 90,000 90,000 100% 100% 236,000 329,504 93,504 100% 101% 586,938 489,990 106,000 80,948 703,195 116,257 100% 104% 447,835 43,001 42,155 100% 62,999 100% 80,948 100% Exp. % TOTAL REQUIREMENTS 676,938 490,835 186,103 100% 73% NET (Resources - Requirements) (90,000) 212,360 302,360 Beginning NWC per Adopted Budget 161,896 Page 1 of 2 Marty Wynne From: Mark_S_Hudspeth@KeyBank.com Sent: Monday, July 26, 2010 9:16 AM Subjec eyBank Indicative CD Rates 1 YEAR- 0.05 1.5 years- 0.08 years 0.17 3 years 0.50 Please call or email us for specific rate quote - Mark Hudspeth - 503-790-7682 - mark_s_hudspeth@keybank.com Melissa Greenough - Toll Free: 1-866- 878-1235 / Direct: 425-709-4545 - melissa_greenough@keybank.com Listed above are current indicate rates for our CDs. Interest rates may vary from day to day and on the CD size. The daily deadline for purchasing Certificates of Deposit is 3:00 p.m. EST. Mark S. Hudspeth KeyBank 1211 SW 5th Avenue, Suite 400 Portland, OR 97202 Ph. 503-790-7682 Fax 503-790-7574 Email mark_s_hudspeth@keybank.com Email Classification: KeyCorp Public This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm -Leach -Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 7/26/2010 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2010 PRELIMINARY, as of 712312010 - Additional FY 2010 Revenues and Expenditures WILL BE recorded Fund # Fund Name BUDGETED ACTUAL Difference Contingency Res for Future Exp Unappropriated OPERATNG FUNDS 001 General 8,300,000 701 Law Enforcement -County 705 Des Co 911 675 Health Benefits Trust 4,722,862 5,861,335 16,400,000 9,633,457.87 1,333,458 7,482,774 5,620,060.33 897,198 6,484,136.93 ! 622,802 6,524,453 16,988,139.69 588,140 12,965,479 702 Law Enforcement -Rural 1,905,939 2,356,082.41 450,143 220 , Comm on Child & Fam 562,762 841,831.41 279,069 408,554 259 Health 142 General County Projects 355 Adult P & P 1,100,000 1,343,237.96 ! 243,238 1,210,000 1,407,183.05 197,183 616,371 ! 735,699.14 119,328 761,568 1,681,831 441,641 215 Law Library 150,000 ' 630 Finance 500,000 254,383.28 568,179.77 104,383 182,474 68,180 308,486 350 Dog Control 327 ' Forest Title III 650 Personnel 620 Building Services 133,711 515,592 290,000 310,000 198,215.53 64,505 44,699 25,000 577,575.52 61,984 408,200 351,451.98 61,452 81,000 370,224.42 60,224 209,683 661 Citrix 161,896 1 660 Information Tech 435,000 105 Business Loan 75,000 212,359.54 484,763.44 119,736.15 50,464 49,763 44,736 199,896 203,511 280 OHP-CDO 528,000 572,377.83 44,378 275,1961 706 :911 New Facility Property 370,939 !; 408,693.48 37,754 640 :Legal 90,000 125,671.04 35,671: 67,500 329 Public Land Corner 990,401 I 1,025,419.19 35,018 721,001 270 ABHA 3,014,373 3,045,125.05 30,752 2,076,208', 305 GIS Dedicated 348,000 378,298.50 30,299 ,' 53,000 116,672 115 Crime Prevention Services 28,722.57 28,723 123 Justice Courts 145,000 720 Extension 4-H 282,176 173,478.20 305,408.61 28,478 59,116 23,233 141,970 255 Sheriffs Office 19,742.22 19,742 5,632,690 260 HealthyStart 550,000 561,250.75 11,251 386,936 165 Video Lottery 30,000 37,226.33 7,226 42,914 618 Fair & Expo Center 2,809 9,756.45 6,947 137,848 240 Court Security 5,212.79 5,213 208 Liquor Enforcement 10,000 14, 708.21 4,708 12,818 245 DC Communication System 85,000 87,574.88 2,575 89,8131 143 General Capital Reserve 1,084,000 1,086,105.09 2,105 589,300 212 Victims' Assistance 74,000 75,878.32 1,878 35,088 145 County School 199.78 200 200 Industrial Development 45,000 44,578.96 (421) 11,452 235 Asset Forfeiture 25,000 24,478.37 _ (522) 25,917 328 Surveyor 2,665 1,173.54 (1,491) 2,665 628 BOCC 100,000 95,213.66 (4,786) 27,129 610 Solid Waste 392,509 619 Deschutes County Fair 330 Road Building & Equip 230 Juvenile 558,304 987,000 387,006.31 (5,503) 798,256 (17,354.46) (17,354)', 86,603 540,712.00 (17,592)1 492,297 965,722.68 (21,277)r 621,106 218 Clerk's Records 332,491 306,814.18 (25,677) 330,341 601 RV Park 15,000 (16,375.33) (31,375) 24,190 276 Acute Care Services 1,001,701 969,703.87 (31,997) 921,844 340 Vehicle Maint & Res 1,048,257 1,012,668.01 (35,589) 1,024,557 670 Insurance 625 Administrative Services 2,500,000 120,000 2,460,108.56 (39,891) 2,346,473 _ 61,236.90 (58,763) 80,628 297 Newberry Neighborhood 505,793 443,826.45 (61,967) 86,960 185,000 275 Mental Health 2,616,050 2,551,766.18 (64,284), 1,891,454', 295 CDD 686,081 612,736.45 (73,345) 259,3851 205 Land Sale Maintenance 197,000 116,150.59 (80,849) 103,945 i 325 (Road 3,430,429 3,308,308.65 (122,120) 2,036,412 326 1Natural Resource Protection 58,747 (118,523.32) (177,270) 42,027 7/2: /2010 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2010 PRELIMINARY, as of 7/23/2010 - Additional FY 2010 Revenues and Expenditures WILL BE recorded Fund # Fund Name BUDGETED ACTUAL Difference Contingency 1 Res for Future Exp 1 Unappropriated CAPITAL PROJECT FUNDS i 430 Local Impr District 218,949 214,336.23 ; (4,613) 221,466 1 - 456 Jail Construction - - 1 - - _ 457 Jamison Acq & Remodel 580,000 578,012.20 ! (1,988) _ 590,047 1 - 458 OSP Bldg Construction 535,574 1,924,106.80 I 1,388,533 - - 459 Secure Treatment Facility _ 1,000,000 1,166,888.65 166,889 - - 460 911 Building Construction 170,000 1,373,730.80 I 1,203,731 - 1 613 ,Solid Waste Cap Projects 759,834 1,080,618.56 I 320,785 551,196 ` - DEBT SERVICE FUNDS 523 LID 2005 (U S Bank) - 319.49 319 - I - 524 LID 2007 (BOTC) - 27,173.30 27,173 - 53,014 525 LID 2009 (BOTC) i - 7,414.89 , 7,415 - 15,100 530 CDD Bldg DS 15,900 16,003.65 104 - 15,000 535 Full Faith & Credit 2003 50,900 63,805.48 I 12,905 - 38,396 536 Full Faith & Credit 2005 3,300 3,935.60 1 636 - 1,400 538 Full Faith & Credit 2007 - 235.72 236 - - 539 Full Faith & Credit 2008 309,000 309,939.23 939 - 511,000 540 HHS/BJCC DS 10,800 9,459.44 (1,341) - , 10,300 541 Full Faith & Credict, 2010 - 39,057 560 Public Safety DS 200,000 332,390.32 132,390 - 150,000 575 PERS D/S 120,000 119,887.18 (113) - 120,000 590 Fairgrounds DS 100,000 260,234.58 160,235 - 100,000 731 Bend Library DS 60,000 128,326.26 68,326 - 58,200 741 [Redmond Library DS 10,000 28,186.19 18,186 - 9,000 751 Sunriver Library DS 8,000 13,427.95 5,428 - 8,000 OHTER FUNDS 120 Grant Projects - 15,421.43 ' 15,421 - 1 - 125 La Pine Industrial - 950.66 ' 951 - - 128 Bethlehem Inn (2,725,000)[ (2,722,509.91) 2,490 - - 130 - Park Acquisition & Devel - 9,618.77 9,619 - 132 Park Development Fees 119,000 119,423.16 423 - - 150 Special Transportation 50,000 1 377,510.25 327,510 - - 155 Taylor Grazing 9,500 8,914.52 (585) - - 160 Transient Room Tax - 1,695.61 1,696 - - 170 Welcome Center - 965.78 966 - - 290 Code Abatement 95,800 94,919.81 (880)- I - 296 CDD-TDC 207,338 291,359.81 84,022 110,4381 - RESERVE FUNDS 111 Court Technology Reserve - 2,607.13 2,607 - - 114 A & T Reserve 211,000 242,945.84 31,946 - 192,100 - 135 PERS Reserve 12,200,000 12,481,623.94 281,624 - 13,218,900 - 140 Project Development 2,800,000 2,842,790.95 42,791 - 1,923,206 - 261 1Health Department Reserve 518,532 517,541.25 i (991) - 458,482 - 335 Road Improvement Res 12,040 12,027.33 L (13) - 10,200 - 336 Countywide Trans SDC 181,957 212,238.80 30,282 184,957 '', 611 Landfill Closure 1,081,221 1,567,871.15 486,650 - 1 306,221 - 612 Landfill Postclosure 2,406,772 2,406,237.48 (535) - 115,772 j - 614 Solid Waste Equip Res 756,139 ' 755,465.27 (674) 30,430 1 - 615 Solid Waste Enviro Remed 75,262 74,666.67 (595) - 1 77,262 : - 617 Fair & Expo Center Reserve 320,000 335,194.03 15,194 - 412,800 - 703 LED County Capital Reserve 953,180 1 959,000.05 5,820 - - 704 LED Rural Capital Reserve 942,085 ! 947,676.97 5,592 - - 710 Des Co 911 - Equip Res 1,278,000 1,021,733.86 (256,266), - 1,538,000 - 721 Extension 4-H Bldg Res 75,100 75,347.34 247 Total 91,197,376.00 100,569,190.43 9,371,814 1 53,314,0691 20,066,696 1,455,139 i I 7/23 2010 GENERAL FUND Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/23/2010 Annual Actual Projection Actual vs. Budget 30 -Jun -10 31 -May -10 May Projection RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 6,775,995 Revenues Property Taxes 19,822,847 21,289,179 21,116,939 172,240 Gen. Rev. - excl. Taxes 2,921,462 3,150,964 2,921,462 229,502 Assessor 820,704 847,684 848,204 (520) County Clerk 1,043,171 1,599,757 1,552,066 47,691 BOPTA 13,791 14,432 14,432 0 District Attorney 332,800 332,606 384,185 (51,579) Finance/Tax 187,049 194,914 197,827 (2,913) Veterans 70,192 70,154 63,871 6,283 Property Management 86,450 98,370 86,450 11,920 Grant Projects 2,000 2,000 2,000 Total Revenues 25,300,466 27,600,061 27,187,436 412,625 TOTAL RESOURCES 31,350,466 34,376,056 33,963,431 412,625 REQUIREMENTS: Expenditures Assessor 3,290,631 3,082,496 3,157,631 (75,135) County Clerk 1,460,704 1,301,868 1,293,000 8,868 BOPTA 60,358 59,883 59,714 169 District Attorney 4,622,263 4,580,459 4,587,263 (6,804) Finance/Tax 755,971 747,699 755,971 (8,272) Veterans 234,222 234,030 233,701 329 Property Management 239,685 238,431 239,685 (1,254) Grant Projects 105,673 103,728 105,673 (1,945) Non -Departmental 1,613,006 1,423,351 1,483,006 (59,655) Contingency 5,515,042 - 17,897,555 11,771,944 11,915,644 (143,700) Transfers Out 13,046,911 12,960,911 13,046,911 (86,000) TOTAL REQUIREMENTS 30,944,466 24,732,855 24,962,555 (229,700) NET (Resources - Requirements) 406,000 9,643,201 9,000,876 642,325 Beginning NWC per Adopted Budget 8,300,000 Year 2009-10 a) 0 C N 0 rnO-00)OI� I.00nc)oCnCo -oO o 01 0 Ns 0 Nr - r` CD O QD U) CD 0 U) o o 0 U7000OO6OU)NOOOp6CDT-T- NO � O CD O 003 Ns CD O Nr co 03 03 OCD 000 co 03 Nr N C~ N UO) r- (0 0) 0/ 0 C) (D U) I- — (0 v N •- M (0 C'l Nr .-- O'— O Cs Nr Cr) O U) 07 O CC) CD CD N- O 00 Nr r I,- M O CD r- O CA O V) O O O O O O O O • 0 O'— 0 O t f. O O N CD (D -- O O O O 0 ▪ I-c)CDODNV-000oO03N 000OO � NC3)'Ct0)0 t ti 00'tNCDCANOU) CD ti C:16 N N-05 N -1.0-1"---v- 0 (D CV QD Ns 0 01 CD CO CV 01 CD NN L11 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 O O 0 O O 0 0— 0 0 0 0 0 c 0 0 6 O U)C3C301000CnC O•- 000 O '—O(000014)eru) U) 00 000) O _ _ _ _ CO- _ _ _ _ _ _ _ r- N 00 1.6O CA N U) N t1) CC) I` O U) 00 M 01 N CO r- M 0) co U) Nr 0 "rn cn N 0 O o " No W N U xc00 c3 c W Z x p` U U N c 1-c Q O (0 0) Q) I- x (1) c3 a) a) c•c c yH Ew~2 c3 LL w a) a) l- c 0 3 0 0 a) V m a') m • J °) a E OS m •� o cnJJd5'zi<1-HCn2U Foreclosure Fees 3,150,964.60 2,921,462.00 (Engineering Contract Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of June 30, 2010 "Area A" Landfill Closure Fund 611 "Cell 5" SW Capital Projects Fund 613 Total G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through June 30, 2010 Balance Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order #1 Change Order #2 Change Order #3 Change Order #4 Change Order #5 Change Order #6 Total Paid through June 30, 2010 Balance 241,869.00 19,656.00 261, 525.00 254,413.43 7,111.57 182, 516.00 182,516.00 153,904.43 28,611.57 424, 385.00 19,656.00 444,041.00 408,317.86 35,723.14 2,097,140.50 3,290,779.98 5,387,920.48 14,302.54 24,885.69 152, 500.00 45,094.00 152,500.00 148,958.89 225,000.00 45,094.00 14,302.54 24,885.69 305,000.00 148,958.89 225,000.00 2,288,828.73 3,862,332.87 6,151,161.60 1,707,132.00 2,054,537.51 3,761,669.51 581,696.73 1,807,795.36 2,389,492.09 Total of Engineering & Construction Contracts Original Contracts Change Orders Total Paid through June 30, 2010 Balance 2,339,009.50 19,656.00 2,358,665.50 1,961,545.43 397,120.07 3,473,295.98 45,094.00 3,518,389.98 2,208,441.94 1,309,948.04 5,812,305.48 103,938.23 5,916,243.71 4,169,987.37 1,746,256.34 Notes: a) Additional landfill gas investigation per DEQ as part of a requirement to address offsite landfill gas migration. b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678 has been expended and reported as "Construction in Progress" on the County's CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction, Taylor NW, KN EX Co, Jack Robinson & Sons. c) To date in FY 2010, payment has been made to Central Electric Co-op: $13,311 for the Closure of Area A and $20,822 for Cell 5. PR and print ads (Bulletin) begin Application deadline Application review/final 2 -Aug 20 -Aug 24 -Aug Applicant notification 25 -Aug CLASS FOCUS DATA Admin/BOCC/Cty overview Sept. 14 Road/Solid Waste Sept. 21 Sheriff's Office/ 911 Sept. 28 DA/CCF/Juv & P&P Oct. 5 Health Services Oct. 12 CDD Oct. 19 Clerk/Fair & Expo Oct. 26 Elections/Assessor/Tax & Finance Nov. 2