Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Finance Update
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 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 >, CD O C 7 N 7 L 0) y M N D CDC T L U = = O) CA U 3 �CD � o ca) ~ E H U C/) a) U ca ca a) a) co O` o 0. m 0 U a) CV ca oD a RESOURCES: N c))) O O ' O ' O N 00 co O M O 0 t- O M O O O)OOO U) c5 N N O CO LO N N � O O O O O O O O O 0 M O N O CO LO la I co O M O n O M O N 0)o -0c') tri coo1(0N1 N1 00 N CA y O O N CD V O O) A- CO O) v c.) lC) (0 O h ' 00 cf) O ' O O O) et. O N M In CD et O O) M N M O) O et O) M co O r co O) O) — O N O) IC) et O CO O CO 0 0 1 O cD O IC) M O M N 1C) N N A- O O O CO O) O O O O O ' M N O' O' O) N 16 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) 11) et O t` CO N CO 0 A- CO. .- O O) O) N 00 CD 00 it; O N M A- 1 16 O) O) CO N r 0 N L 10 00) 11) IC) ' M O O O) N 1- CO 0) N O) t- co IC) r co 0) N M N O) O) a co r- M N M O A- A- co.. N c0 N O 1C) O N c)— 16 N 1- 0 O M M 0 C•1 c5 I0 IC) N N CO CO O O et O) M co 00 O 0 U 0 E m N C O C . � • () 7 U a) ce C` co N y O o E a) a) >t 0 z a a)to la o 2 0 m :+ H co p) u) (1) Q� 7 C O C E O tO Cl)'°� O 0 Miri o C Tij O LL L. ` la a cc0 re mrnc LE am:: �+cas E. m w>= H ica U� E°)la m°a?la oaZia�i mcCCw� Z ms ., > ,.. 0Wt aYo _ -2 'cop OCC @ N C a) C (a +' a) tH O OH C0 CO W¢ CLQ�Uag0— oJ c �UH Z U O 0. �O m 0.) CO r N CD 1C) O 6H O 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 co a) c_ .° O. a) N U C ca 7 O CA � y d o O O U U C 46- 6- CA CO CA CO w .- M ONA- U N O t t co co Uc0 y co a) N gLL o¢a 0 CD cco N N O m 6g C 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