Loading...
HomeMy WebLinkAboutFinance UpdateMonthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA January 25, 2010 (1) Monthly Investment Report (2) December 2009 Financials Investment Income Fiscal Year 2009-10 0 iL $ 138,206 $ 926,548 Total Investment Income 138,206 926,548 Less Fee: 5% of Invest. Income (6,910) (46,327) Investment Income - Net $ 131,296 $ 880,221 0 6.) a) 0 Investments By County Function General $ 140,343,394 Total Investments $ 140,343,394 eschutes ount j iIIMIPZI N rortolio IP ot• nv- m- r, 0 0 c o c o r tD O LSA O e. o O h O N 0 CU a 0 N � o ca .c(1) (6 Z uoi o CU O E o 0 E Q ui o O O 01-D N Lt ) N O) O LGIP/BOTC O O O O 0) Q) M O 69 Total Investments t c O 2 c d 0 D G O et CO ISN CJ T r aco co ,rt Q T Y • • r 47 0 4-- C CD a) Ufa E 0) O > U) O R ccs E O U O O O o et et • O • L • Nco 0 cc ~ t Cc 0cO c C 2 N M r M Average Maturity in Days co o 0 c N 0 0 0 0 0 0 0 O O Ln Un ) 0 0 0 0 h N N N r r y E U o c E O al X Q)'3 0 c6'- C 2 3O o Z+ m Q in O m L cn 1— L ) 0- • C 0 _) 0 - Li m Time Certificates 'CB cis a) 4 O • Z U . 0.1 L E o • Q o 0 O 0 Total Portfolio: By Investment Types U 1- CO CL E O U 0 z Market Value 0 0 0 0 0. '0 0'' 0I 01 0 0 00000000000000000010010U 1 0) ,N N .- 0 0',14)0 0� 0 X10 0a.N c`) <n Z z z z'zz ZZ zlz z z zlz1Z'z Zlz,zz z'zQ N o' �z z Qlz'z - z �,Z z,cnIro Ia) hl 0 0.0 0 0 0 o 0,0 0 0' 0 n +-, c0 1n V CO N V N 0 010'0 0 pI0) n 01014 0 0'0 NIc0 O O'n'iN 0 0)0 N cm'', r O' 0 a) ,- i N o V M <D'M N 0 < O' CI 0 n' 0) 0 0 C'0 0 o n 10 0 0 0 04 o 1LL')'O, N, O,<0 ,- 0 O <D (D , S0 ' N C 0110'0 M 01010,01 n p I N 10 0 u) <0 0,0,0+ 10 0 0 O. co N O n 0 V n 0 <D .- 0 O. V N 1 N, 0 0 0 0 N V 0 c0 0' 00 03,0 00p 0 10 0 0 0. 0 0 0 0103,0 C N O V I o V V 010 O 0 N c0, N <1) r•1,-, l <D n' N' W, V 0) <O n 10 , N M V O, O 0 n *- n u) r <0 <O 0 0 .0 0) O <D u)' <O N u) 013.3113.<3 0' '0 O <3.-1N, r N CIM n M <0 0 0 0 CO V u)I0 CO V N WW N C 41 co O V.0 M'O N 0' -,Q.N 010V•OJ 10,C1M r O V'<0 0 N N n V N'NI0 N 04 0, V'M N V V V' O.- o'`—'O r 0. O''- o1o1rl 010 r 0'010 0 '0'0 r o<o ,,O 0 0 0 0 oIo N N N' V N VIN V'- N NN - NI N N N <V 101 N N N. N N; N N N, N NV N N '0 0010 CO C' 0 W n 0'04,0 01010,010 1 <0 0 .-- V, 0 0 0 010.0 0 0,0. 0 0' 0 M' n 0 0 0'0 0:0'0 O'0 Oi101<31 01:0 n O 0!NI0 NIO 0.0 C 0-0 '- O OI0I0 01010 0 �I0I0,0 O'.M' 0 O OIO N V V <0 0 n -011- N <0 V' <V 04' 0 V n O 1 r 01010'01 N NI -0,01 ‘-'03,N1,0 V M C, 0 N N10 <D n •-", ,C3 '-'0 N 0'01 O VIO V' O MIC') NIOIN. - 0?Vn 0'10 a O ' W COO- - V N 10 <0 +-1n 0 , <h V c01 N n 0 0 C 4,16 0 0' V'' a0 O O 01 n O' N M 0 10110 O N <0 C N I O ,- 0 0' 10 0 M I M 0. 0. r 0 0 f' , to M! N 0 <0 ' 0 10) 0 101 0 1 0100 0. 0 CO 0 C M 0 010 - 1 0 0 1 0) CO 0 .. 0 0' 0 a- 0: 0 0' 0 0 0,- 010,0 0 ,- 0 0, 0!0 0 0,010,0 0 • 0 r 0'010'0 0,0 0 NNN V'1 N' V N 'V-, N. 04.0 (, I N, N1 011001, N N N •- N'' r' e- . NNN-SINr Original Cost w <a ce >- 0 O 0 O • re U o • ;� N 0 01. 01 O' O M 0 0 0.0 0 0 0 0 N I 0 O O' O O O O' O O 0' 0 0 0 0,010,o 0 0 0 0 0:010 01 0 o,c0 o j W l 0 o o -0, 10 00 'r' 0 0 0 0 0 0 1 0 0 •0 I O 0) 0 0 00'0. 0 O O ' O O O o <0, 0.0.0 000 O o' o 1p ' o 0 01 100 <D 0) 010 O 0'O Old O. O' o l O n 010 6;0,6 . 0 0 01, 0 O. '1010100,0.0 0,00 0, 0 01'010310 <01010.01 0 0 0 01 o O V 0,0101V- 0 01 o 0 0 0 O' O o W N c0 0I0I0 o o•o.o 01001 V M 0'(0)0'0,010 O O' oIo 0 010 r1-0 1 O 0 010'0 010,4 <D 0I 00'0,0 00,0'0'000)0 10 n r 001,000000'100.0, 0,100100000 n0 V 01 V 0)0)0 0 0 04 0) 0'01010 0 0 nl0 010) 0)0 0( 0(0 01 0 0,4-'0 0101'0'0 o'ol0,0,01 O O'O'' 0,0 O.O. 010'r 0 010,0 0,010 , 0 0 0'0 r 0)0 OIC 0'r. 0;0 00 0 0 0 N. N NV N. V N V '- 1 N 01 N r N N, N N' N, N N N' N. N' - NI N N N NIN 0.1 1 01 o ; a ; \ '� o a '� u o o \ t o` ' o o \ a2. 0 0 0 V 0,,,0;0 0 0'0.0 0 0.00;0100 0,olo'O 00 010 0 0',0 10 0 0 0 0 0 0'01 V 10 o 10 00 a0' 0 C 0.0,0 VI0 Nr O10 100 r <0 M 10.00 0 tel 0.10• IN11<) 0 00''3010 V [0 V W. 1 0 <0 W V7 O' 0 Cl O ,710. N (� N n 0.10d9 r 00,00'00. 00 N M N". V •-' K) 04 0 0 • N .'• ' N N M r .-• <") M 'r >- r' CV r NIN N O O r 01 0 r 1<0 r r r H 0 32323232' n 0'10l10]01 M N'. MICO .-117.0 V. 0 • =,,?::.`.: 0 0 0 0 0 0.0 0 0 0 010'0 0 u) 0 0 0 <0 C <0 0.0104 00 0 1 0 <0 014 u) 0,0'0 O M, W 03,03 03'01) ('- 'W 10)0.10 r .--•(v.0, N 0 0,0'0'0 0', r '- , O , —1— 138,727,756.98 $140,343,394.36 C 0) O M o v V o Nn ,0 N M V :W <D CO CO co V ✓ 1L. C0 N ( • Co P M to 0 u) 10 0 00 10 0 N in o m 0'0 N C 0 d a 0 Ea El c E °7 y A O '<r• N n 0 V n N O' (0 0 0 0 14) W <0 V C 114) <0I 0 0 0 0 0 0, 0 n n n N <D' <D 0 I n n n M 0 I M y> g C M V� 01'01 al C N O.<O 0 0'10 M M M fV.N M , V WI V V VM V V V(W u) <0 <D O O <0 N M n 0' 0 u) <0 � u) n •1<) V M 10' V o I n CO 01 <0I u) n n n i n 0 LL) <0 u) u) 01 1<) n <0 <0 <0 • W N 1 n I N E T N'C,0'0' go 0 0)000 0 0'0 0.0 0:0 oIo D o 1 r :57; > 0 • 3 INa0 0 , N10 W 0 01,0410:0 01OIOO 0 ONO,N N N N MIN `41,1 • MC0,1000 O Q014 <0 <O <000) ' +S U E 0 0 000'0 0 0 0 0 0 0 0,0 O oIOOOo 0 0 0,0 OOO'o 0)0 0 0 0 1 04 N u !CO O) CW C C CO 1Q 0'01]0.0',0_ Q 0 8 N'n No • N O,NIOI 'O <(4 V. V'8 0'V'•- 0O'0.0 010 O a E z' Q U c O 0. 0 N 00 c N E M N 0) 0) NIC' O) 0)a,' 0)' O) W 0) C 0)1 0) C 0)' C ,O C' C' 0)1 0) 0) O) O) 10) C' O) C 0) 0) 0) O fl O' o i o! O O o h o O 0,00 O 00,00 0 0,01' 0 0 0 o.2 o 2jQ o l o l o N , n'lO O r• ^, ' i0 '0 ti 23,8-310 . 0 •-' N V O 04'14) W O <V O C 0), O O NIA O N1`N r4`Q<0Q•M 0=00,`00 IN]<o O 0 0 0,01010 00 r 0 0 0 0, 01 0 01 O r I r O Z'0 00'00 O'O'D'a 101< 2 Z 2 O,2'p © 2"2 Q Q Z'< 2 Z < <'0 2 010 2 Q'Q1Q O'rr'O 1-'1- (-11-1)-- 4L H u. 0-10 U- 0 0-11- 1-1.t_u- 0- 1L 0,u. 1. U 0-11-0,0-1-011-11-0<1- 0 LLL I -,I- , - 0214 a U'm'<m 0- 0- Z L- m a,mla'0- <2 'Z; L1. Z 101Z�Z,0 > Z'0 m 10 Z,0 Z 0- 0:0(10 m 0 mJ' 0 Ti�}Iu) 0;0,0 S)S,1 0 0'<0's m a 0'0,0 W u) u) Y 0((0,0 u) N M C M N <D � 0 u)1 M M M 0 1 <0' 0) N 1 M 11) 01,1,0 W• Z 0(10 2i 10 a J J •�;<") 0) 1010, 1 v 010 < )"1 T 0 °) Im '(D 4 >1> m.u) 0 y,0l0 u)' Z <0!N. 0 I--,40 0 F• '.2 co T 2.2 M''00' 0 o,>'0` X XIV M X >( X N W X 0- .10 0 N X M n M M M M <D M n W 0 C C 0,-)101,,) M'M co M,3-Im� MI 'PIM COI M' M ' MI M, Mco MC MIM N (7.7.,,„.. 0 M'' M M MIM 17„7.-,;7,1c7-,is,,').,;4,-,1,,,,,,T.-,,A, M C (0 0 0 0 .Z 0�0J 0 0 10, U'' �0 10 ❑I Z 'pion' R �I,1� fl <ci 011 m Z ICJ o o �I Z Y 'mi 'UIU w � <n U 1 U LO 'C) m w1 y 101.. YID ,ISI Y Y 011 1 0)01 >l w El c.0 Y E �° u c1 c 0 U >. SIU �Im'):.9.L11%)31' m .clQi<lim.� mlQ a) W '3i014'01<• l y1 a W c til i«6 'O OIO O 7 O, T a LL <0 010 0R1- 01- ' o 0 >I0) co co m' 0' o o �' < 0s 0].rlm �m'm, acr:1 CT a a))gla < ¢',1111 vjmlm'-c1M 1110 <10'm -,-.11=,,,,2 0 0 ml m < E <oa -9I m S 0 1 21 0I LCL E;= E o =IZIZ ZI 1lwI,1Vi. ao)I=ILL 0 = 21 a a),= Z�S110-0 ILL•>i'H 0 10)1,1 Ol10 J,1 u 1 u LL]0 it DILL 7 i u LL LL u..>•li1LL U' I0- LL!VJ1L-)o Y lIL_IL,LLILL Total Investments < ''U 0'Li m (0'O'm'Z > CO 'CO U SIY'J1a Ot Rn 00 0-Q,0.Z'.< 0 10'0U'u.00 10 O Memorandum Date: January 19, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find December 2009 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 Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 6,050,000 Revenues Property Taxes 9,911,424 Gen. Rev. - excl. Taxes 1,460,731 Assessor 410,352 County Clerk 521,586 BOPTA 6,896 District Attorney 166,400 Finance/Tax 93,525 Veterans 35,096 Property Management 43,224 Grant Projects 1,002 $ 6,775,995 18,183,192 1,930,097 426,974 718,177 8,208 112,702 113,807 33,936 43,224 1,002 $ 725,995 100% 112% $ 6,050,000 $ 6,775,995 $ 725,995 8,271,768 469,366 16,622 196,591 1,312 (53,698) 20,282 (1,160) Total Revenues 12,650,236 21,571,319 8,921,083 TOTAL RESOURCES 18,700,236 28,347,314 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency 1,645,316 730,352 29,854 2,293,632 373,236 112,851 119,843 52,837 806,503 3,047,357 9,211,781 Transfers Out 6,463,456 TOTAL REQUIREMENTS 15,675,237 NET (Resources - Requirements) 3,024,999 1,528,255 601,553 25,037 2,244,228 380,278 111,542 118,652 50,963 354,580 5,415,088 6,506,623 11,921,711 16,425, 603 50% 92% a) 19,822,847 20,674,385 851,538 50% 66% b) 2,921,462 2,921,462 50% 52% c) 820,704 820,704 50% 69% d) 1,043,171 1,193,171 150,000 50% 60% c) 13,791 13,791 50% 34% 332,800 332,800 50% 61% c) 187,049 187,049 50% 48% 70,192 70,192 50% 50% 86,450 86,450 50% 50% 2,000 2,000 50% 85% 25,300,466 26,302,004 1,001,538 9,647,078 50% 90% 31,350,466 33,077,999 1,727,533 117,061 128,799 4,817 49,404 (7,042) 1,309 1,191 1,874 451,923 3,047,357 3,796,693 (43,167) 3,753,526 13,400,604 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Exp. % 46% 41% 42% 49% 51% 49% 50% 48% 22% 0% 29% 50% 38% 3,290,631 3,290,631 1,460,704 1,460,704 59,708 59,708 4,587,263 4,587,263 e) 746,471 746,471 225,701 225,701 239,685 239,685 105,673 105,673 1,613,006 1,493,006 120,000 6,094,713 6,094,713 18,423,555 12,208,842 6,214,713 12,926,911 12,926,911 a) Projection based on actual collections through November 30, 2009 b) Year to date includes annual PILT payment of $467,230. c) Includes 2 quarters of A & T Grant: Assessor -$415,093, Tax -$97,761 and BOPTA -$8,208. d) Significant foreclosure and refinancing recordings. e) Year to date includes expenditures paid annually. 31,350,466 25,135,753 6,214,713 7,942,246 7,942,246 Year End $ Budget Projection 'Variance $ 725,995 100% 112% $ 6,050,000 $ 6,775,995 $ 725,995 8,271,768 469,366 16,622 196,591 1,312 (53,698) 20,282 (1,160) Total Revenues 12,650,236 21,571,319 8,921,083 TOTAL RESOURCES 18,700,236 28,347,314 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non -Departmental Contingency 1,645,316 730,352 29,854 2,293,632 373,236 112,851 119,843 52,837 806,503 3,047,357 9,211,781 Transfers Out 6,463,456 TOTAL REQUIREMENTS 15,675,237 NET (Resources - Requirements) 3,024,999 1,528,255 601,553 25,037 2,244,228 380,278 111,542 118,652 50,963 354,580 5,415,088 6,506,623 11,921,711 16,425, 603 50% 92% a) 19,822,847 20,674,385 851,538 50% 66% b) 2,921,462 2,921,462 50% 52% c) 820,704 820,704 50% 69% d) 1,043,171 1,193,171 150,000 50% 60% c) 13,791 13,791 50% 34% 332,800 332,800 50% 61% c) 187,049 187,049 50% 48% 70,192 70,192 50% 50% 86,450 86,450 50% 50% 2,000 2,000 50% 85% 25,300,466 26,302,004 1,001,538 9,647,078 50% 90% 31,350,466 33,077,999 1,727,533 117,061 128,799 4,817 49,404 (7,042) 1,309 1,191 1,874 451,923 3,047,357 3,796,693 (43,167) 3,753,526 13,400,604 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Exp. % 46% 41% 42% 49% 51% 49% 50% 48% 22% 0% 29% 50% 38% 3,290,631 3,290,631 1,460,704 1,460,704 59,708 59,708 4,587,263 4,587,263 e) 746,471 746,471 225,701 225,701 239,685 239,685 105,673 105,673 1,613,006 1,493,006 120,000 6,094,713 6,094,713 18,423,555 12,208,842 6,214,713 12,926,911 12,926,911 a) Projection based on actual collections through November 30, 2009 b) Year to date includes annual PILT payment of $467,230. c) Includes 2 quarters of A & T Grant: Assessor -$415,093, Tax -$97,761 and BOPTA -$8,208. d) Significant foreclosure and refinancing recordings. e) Year to date includes expenditures paid annually. 31,350,466 25,135,753 6,214,713 7,942,246 7,942,246 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -Court Assess. Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Grants - Private Health & Human Svcs Chg CCF Interfund Grant Crime Pry Svcs Interfnd Grnt Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services COMM JUSTICE -JUVENILE Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 1,085,000 15,888 30,000 8,000 15,000 166,225 30,000 400 104,071 150 500 6,500 1,224 34,000 10,000 $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 421,958 21,145 5,257 50% 67% a) 25,512 (4,488) 50% 43% 6,223 (1,777) 50% 39% 13,957 (1,043) 50% 47% b) 67,655 (98,570) 50% 20% c) 64,200 34,200 50% 107% d) 53 (347) 50% 7% 25,973 (78,098) 50% 12% e) 20 (130) 50% 7% 225 (275) 50% 23% 9,725 3,225 50% 75% 1,200 (24) 50% 49% 612 612 50% n/a 277 277 50% n/a 16,024 (17,976) 50% 24% 5,521 (4,479) 50% 28% 258,322 (163,636) 50% 31% f) f) 31,775 60,000 16,000 30,000 332,450 60,000 800 208,141 300 1,000 13,000 2,448 68,000 20,000 52,994 56,000 12,000 38,000 340,076 120,000 100 75,000 100 500 17,000 2,400 612 277 54,495 20,000 21,219 (4,000) (4,000) 8,000 7,626 60,000 (700) (133,141) (200) (500) 4,000 (48) 612 277 (13,505) 843,914 789,554 (54,360) 2,771,593 2,771,592 (1) 50% 50% 5,543,186 5,543,186 4,278,551 4,229,955 (48,596) 50% 57% 7,472,100 7,532,781 60,681 1,415,076 1,405,041 Materials and Services 661,049 519,933 Capital Outlay 50 Juvenile Resource Center Personal Services 1,266,077 1,149,400 Materials and Services 92,452 99,345 Capital Outlay 50 Contingency 301,297 10,035 50% 141,116 50% 50 50% 116,677 50% (6,893) 50% 50 50% 301,297 50% Exp. 50% 2,830,152 39% g) 1,322,097 0% 100 45% 2,532,154 54% h) 184,903 0% 100 n/a 602,594 2,887,000 1,125,000 100 2,340,000 181,000 (56,848) 197,097 192,154 3,903 100 602,594 TOTAL REQUIREMENTS 3,736,051 3,173,719 562,332 50% 42% 7,472,100 6,533,100 939,000 NET (Resources - Requirements) 542,500 1,056,236 513,736 999,681 999,681 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -November. December payment expected to be received in January. c) OYA Basic and Diversion first quarter payment received in November. Payments are based on reimbursement requests for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year. d) Utilization of housing for juveniles by Crook County projected to exceed original estimates. e) YTD BRS revenue for July -November. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. g) Positive variance a result of accruals during July of June expenses, BRS contract payments being lower than anticipated due to low youth count in the program and a decrease in Maplestar contract for youth services h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. Year End Budget Projection Variance $ 1,200,041 $ 115,041 100% 111% $ 1,085,000 $ 1,200,041 $ 115,041 421,958 21,145 5,257 50% 67% a) 25,512 (4,488) 50% 43% 6,223 (1,777) 50% 39% 13,957 (1,043) 50% 47% b) 67,655 (98,570) 50% 20% c) 64,200 34,200 50% 107% d) 53 (347) 50% 7% 25,973 (78,098) 50% 12% e) 20 (130) 50% 7% 225 (275) 50% 23% 9,725 3,225 50% 75% 1,200 (24) 50% 49% 612 612 50% n/a 277 277 50% n/a 16,024 (17,976) 50% 24% 5,521 (4,479) 50% 28% 258,322 (163,636) 50% 31% f) f) 31,775 60,000 16,000 30,000 332,450 60,000 800 208,141 300 1,000 13,000 2,448 68,000 20,000 52,994 56,000 12,000 38,000 340,076 120,000 100 75,000 100 500 17,000 2,400 612 277 54,495 20,000 21,219 (4,000) (4,000) 8,000 7,626 60,000 (700) (133,141) (200) (500) 4,000 (48) 612 277 (13,505) 843,914 789,554 (54,360) 2,771,593 2,771,592 (1) 50% 50% 5,543,186 5,543,186 4,278,551 4,229,955 (48,596) 50% 57% 7,472,100 7,532,781 60,681 1,415,076 1,405,041 Materials and Services 661,049 519,933 Capital Outlay 50 Juvenile Resource Center Personal Services 1,266,077 1,149,400 Materials and Services 92,452 99,345 Capital Outlay 50 Contingency 301,297 10,035 50% 141,116 50% 50 50% 116,677 50% (6,893) 50% 50 50% 301,297 50% Exp. 50% 2,830,152 39% g) 1,322,097 0% 100 45% 2,532,154 54% h) 184,903 0% 100 n/a 602,594 2,887,000 1,125,000 100 2,340,000 181,000 (56,848) 197,097 192,154 3,903 100 602,594 TOTAL REQUIREMENTS 3,736,051 3,173,719 562,332 50% 42% 7,472,100 6,533,100 939,000 NET (Resources - Requirements) 542,500 1,056,236 513,736 999,681 999,681 a) Federal Grant projection increased for funds not spent in prior fiscal year. Reimbursements received quarterly. b) Food Subsidy receipts reflect payments for July -November. December payment expected to be received in January. c) OYA Basic and Diversion first quarter payment received in November. Payments are based on reimbursement requests for actual expenditures in prior quarter. Department anticipates projected amount to be received in full by end of fiscal year. d) Utilization of housing for juveniles by Crook County projected to exceed original estimates. e) YTD BRS revenue for July -November. Projection reduced to reflect actual youth count at less than half of original estimate. f) First quarter payments received in November. g) Positive variance a result of accruals during July of June expenses, BRS contract payments being lower than anticipated due to low youth count in the program and a decrease in Maplestar contract for youth services h) Negative variance due to an annual subscription payment, one time appliance purchase, and special needs of youth in detention. RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues SHERIFF - Fund 255 Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % COLI. % 10,121,468 6,358,661 $ 183,677 $ 183,677 100% 8,237,872 5,617,790 15,352 (1,883,596) (740,871) 15,352 16,480,129 TOTAL RESOURCES 16,480,129 REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,052,694 Civil 363,481 Automotive/Communications 698,942 Investigations/Evidence 841,164 Patrol/Civil/Comm Supp 3,732,984 Records 321,182 Adult Jail 4,547,456 Court Security 107,954 Emergency Services 94,036 Special Services Division 554,345 Regional Work Center 1,368,921 Training Division 150,027 Other Law Enforcement Svcs 263,851 Non -Departmental 231,522 Contingency 1,906,575 Transfers Out 13,871,014 (2,609,115) 50% 50% 50% 50% n/a $ - $ 183,677 $ 183,677 41% a) 20,242,936 17,316,790 ;2,926,146) 44% a) 12,717,322 11,224,719 ;1,492,603) n/a - 35,000 35,000 42% 32,960,258 28,576,509 (4,383,749) 14,054,691 (2,425,438) 50% 43% 32,960,258 28,760,186 (4,200,072) 1,024,084 374,969 719,385 763,513 3,685,847 291,405 4,021,949 96,142 100,415 558,158 1,158,657 141,443 283,567 431,524 245,000 245,000 28,610 (11,488) (20,443) 77,651 47,137 29,777 525,507 11,812 (6,379) (3,813) 210,264 8,584 (19,716) (200,002) 1,906,575 TOTAL REQUIREMENTS 16,480,134 13,896,058 NET (Resources - Requirements) 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Exp. % 49% 52% 51% b) 45% 49% c) 45% 44% C) 45% 53% 50% 42% C) 47% 54% 93% n/a 50% 50% 2,105,388 726,961 1,397,884 1,682,327 7,465,967 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,813,149 2,105,288 726,961 1,397,884 1,682,327 7,340,967 642,263 8,844,909 215,808 188,071 1,108,690 2,507,742 299,953 527,602 463,044 100 125,000 100 250,000 100 230,100 100 100 - 3,813,149 490,000 490,000 2,584,076 50% 42% 32,960,258 28,541,509 4,418,749 (5) 158,633 158,638 218,677 218,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System. c) Personnel expenditures Tess than budgeted due to unfilled positions. Year End Budget Projection Variance n/a $ - $ 183,677 $ 183,677 41% a) 20,242,936 17,316,790 ;2,926,146) 44% a) 12,717,322 11,224,719 ;1,492,603) n/a - 35,000 35,000 42% 32,960,258 28,576,509 (4,383,749) 14,054,691 (2,425,438) 50% 43% 32,960,258 28,760,186 (4,200,072) 1,024,084 374,969 719,385 763,513 3,685,847 291,405 4,021,949 96,142 100,415 558,158 1,158,657 141,443 283,567 431,524 245,000 245,000 28,610 (11,488) (20,443) 77,651 47,137 29,777 525,507 11,812 (6,379) (3,813) 210,264 8,584 (19,716) (200,002) 1,906,575 TOTAL REQUIREMENTS 16,480,134 13,896,058 NET (Resources - Requirements) 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Exp. % 49% 52% 51% b) 45% 49% c) 45% 44% C) 45% 53% 50% 42% C) 47% 54% 93% n/a 50% 50% 2,105,388 726,961 1,397,884 1,682,327 7,465,967 642,363 9,094,909 215,908 188,071 1,108,690 2,737,842 300,053 527,702 463,044 3,813,149 2,105,288 726,961 1,397,884 1,682,327 7,340,967 642,263 8,844,909 215,808 188,071 1,108,690 2,507,742 299,953 527,602 463,044 100 125,000 100 250,000 100 230,100 100 100 - 3,813,149 490,000 490,000 2,584,076 50% 42% 32,960,258 28,541,509 4,418,749 (5) 158,633 158,638 218,677 218,677 a) Revenue from LED's based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. b) Year to date actual includes annual amount ($260,405) of transfer to Fund 245 Communications System. c) Personnel expenditures Tess than budgeted due to unfilled positions. SHERIFF 701 Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 50% n/a $ 2,470,519 $ 3,343,461 $ 872,942 Revenues Tax Revenues - Current 7,409,852 13,242,327 5,832,475 50% 89% a) 14,819,703 14,981,411 161,708 Tax Revenues - Prior 250,000 588,522 338,522 50% 118% a) 500,000 727,128 227,128 Federal Grants 17,500 102,868 85,368 50% 294% b) 35,000 110,000 75,000 State Grant 22,578 36,920 14,342 50% 82% 45,156 45,156 Transp. of State Wards 2,500 - (2,500) 50% 0% 5,000 5,000 - SB 1145 860,596 987,330 126,734 50% 57% c) 1,721,192 1,935,336 214,144 Des. Cty Video Lottery Grant 2,500 5,000 2,500 50% n/a 5,000 5,000 Des Cty Court Security 64,500 64,275 (225) 50% 50% 129,000 129,000 Des Cty Juvenile Contract 1,500 (1,500) 50% 0% 3,000 3,000 Title III Reimbursement 75,000 (75,000) 50% n/a 150,000 150,000 Transport 1,000 2,410 1,410 50% n/a 2,000 4,000 2,000 DC Fair & Expo Center - 2,100 2,100 50% n/a 3,000 3,000 Inmate Commissary Fees 30,000 20,327 (9,673) 50% 34% 60,000 60,000 - Work Center Work Crews 21,225 19,590 (1,635) 50% 46% 42,450 42,450 Concealed Handgun Classes 3,000 3,725 725 50% 62% 6,000 6,000 Soc Sec Incentive -Fed 2,500 5,400 2,900 50% 108% 5,000 10,000 5,000 Miscellaneous 2,000 1,665 (335) 50% 42% 4,000 4,000 Oregon Mentors 2,500 1,902 (598) 50% n/a 5,000 5,000 Medical Services Reimb 6,000 5,783 (217) 50% 48% 12,000 12,000 Restitution 525 854 329 50% 81% 1,050 1,050 Sheriff Fees 80,000 100,424 20,424 50% 63% 160,000 160,000 Interest 14,167 18,499 4,332 50% 65% 28,333 28,333 Interest on Unsegregated 1,767 2,553 786 50% 72% 3,533 3,533 Rentals 14,999 54,314 39,315 50% 181% d) 30,000 67,236 37,236 Donations 50 50 50% n/a - 50 50 Total Revenues 8,886,209 15,266,838 6,380,629 50% 86% 17,772,417 18,497,683 725,266 TOTAL RESOURCES 11,356,728 18,610,299 7,253,571 50% 92% 20,242,936 21,841,144 1,598,208 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 10,121,469 8,237,872 1,883,597 50% 41% e) 20,242,936 17,316,790 2,926,146 Exp. % TOTAL REQUIREMENTS 10,121,469 8,237,872 1,883,597 50% 41% 20,242,936 17,316,790 2,926,146 NET (Resources - Requirements) 1,235,259 10,372,427 9,137,168 - 4,524,353 4,524,353 a) Projections based on actual collections through November 30, 2009. b) Unplanned JAG Grant received. c) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. d) FBI relocation from Sheriff's Office has been delayed resulting in 6 months of additional rental revenue. e) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. Year End Budget _ Projection Variance RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 50% n/a $ 2,470,519 $ 3,343,461 $ 872,942 Revenues Tax Revenues - Current 7,409,852 13,242,327 5,832,475 50% 89% a) 14,819,703 14,981,411 161,708 Tax Revenues - Prior 250,000 588,522 338,522 50% 118% a) 500,000 727,128 227,128 Federal Grants 17,500 102,868 85,368 50% 294% b) 35,000 110,000 75,000 State Grant 22,578 36,920 14,342 50% 82% 45,156 45,156 Transp. of State Wards 2,500 - (2,500) 50% 0% 5,000 5,000 - SB 1145 860,596 987,330 126,734 50% 57% c) 1,721,192 1,935,336 214,144 Des. Cty Video Lottery Grant 2,500 5,000 2,500 50% n/a 5,000 5,000 Des Cty Court Security 64,500 64,275 (225) 50% 50% 129,000 129,000 Des Cty Juvenile Contract 1,500 (1,500) 50% 0% 3,000 3,000 Title III Reimbursement 75,000 (75,000) 50% n/a 150,000 150,000 Transport 1,000 2,410 1,410 50% n/a 2,000 4,000 2,000 DC Fair & Expo Center - 2,100 2,100 50% n/a 3,000 3,000 Inmate Commissary Fees 30,000 20,327 (9,673) 50% 34% 60,000 60,000 - Work Center Work Crews 21,225 19,590 (1,635) 50% 46% 42,450 42,450 Concealed Handgun Classes 3,000 3,725 725 50% 62% 6,000 6,000 Soc Sec Incentive -Fed 2,500 5,400 2,900 50% 108% 5,000 10,000 5,000 Miscellaneous 2,000 1,665 (335) 50% 42% 4,000 4,000 Oregon Mentors 2,500 1,902 (598) 50% n/a 5,000 5,000 Medical Services Reimb 6,000 5,783 (217) 50% 48% 12,000 12,000 Restitution 525 854 329 50% 81% 1,050 1,050 Sheriff Fees 80,000 100,424 20,424 50% 63% 160,000 160,000 Interest 14,167 18,499 4,332 50% 65% 28,333 28,333 Interest on Unsegregated 1,767 2,553 786 50% 72% 3,533 3,533 Rentals 14,999 54,314 39,315 50% 181% d) 30,000 67,236 37,236 Donations 50 50 50% n/a - 50 50 Total Revenues 8,886,209 15,266,838 6,380,629 50% 86% 17,772,417 18,497,683 725,266 TOTAL RESOURCES 11,356,728 18,610,299 7,253,571 50% 92% 20,242,936 21,841,144 1,598,208 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 10,121,469 8,237,872 1,883,597 50% 41% e) 20,242,936 17,316,790 2,926,146 Exp. % TOTAL REQUIREMENTS 10,121,469 8,237,872 1,883,597 50% 41% 20,242,936 17,316,790 2,926,146 NET (Resources - Requirements) 1,235,259 10,372,427 9,137,168 - 4,524,353 4,524,353 a) Projections based on actual collections through November 30, 2009. b) Unplanned JAG Grant received. c) Actual State reimbursement for 1145 inmate housing will exceed amount estimated for the budget. d) FBI relocation from Sheriff's Office has been delayed resulting in 6 months of additional rental revenue. e) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grnt Des Cty Transient Room Tax City of Sisters Des Cty Tax/Fin Contract Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security & Traffic Reimb Seat Belt Program Miscellaneous Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Sale of Reportable Assets Sale of Equip & Material Total Revenues TOTAL RESOURCES SHERIFF 702 Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 1,287,473 $ 1,433,708 3,619,850 119,500 1,000 38,250 93,817 33,500 62,234 431,582 893,419 210,008 500 13,592 40,774 1,000 50,000 6,500 3,000 5,000 2,500 42,500 37,500 5,000 6,487,627 299,669 55,506 51,000 76,080 25,512 10,000 893,418 208,008 1,405 13,591 40,773 663 6,290 2,871 4,700 7,004 6,080 57,953 7,100 500 1,122 4,235 900 1,251 6,779 10,503 3,000 $ 146,235 50% n/a $ 1,287,473 2,867,777 50% 180,169 50% 54,506 50% 12,750 50% (17,737) 50% (7,988) 50% (62,234) 50% (421,582) 50% (1) 50% (2,000) 50% 905 50% (1) 50% (1) 50% (337) 50% (43,710) 50% (3,629) 50% 1,700 50% 2,004 50% 3,580 50% 15,453 50% (30,400) 50% 500 50% 1,122 50% (765) 50% 351 50% 6,779 50% 7,503 50% 5,714,926 8,279,640 7,002,399 9,713,348 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 6,358,661 2,564,714 50% 2,710,949 50% $1,433,708 $ 146,235 90% a) 7,239,702 7,339,633 99,931 125% a) 239,000 370,961 131,961 2775% b) 2,000 55,506 53,506 67% 76,500 76,500 41% 187,633 187,633 38% 67,000 67,000 0% 124,468 124,468 1% 863,163 863,163 50% 1,786,837 1,786,837 50% c) 420,015 416,016 (3,999) 141% 1,000 1,405 405 50% 27,183 27,183 50% 81,548 81,548 33% 2,000 2,000 n/a 100,000 100,000 22% 13,000 13,000 78% 6,000 6,000 70% 10,000 10,000 122% 5,000 10,000 5,000 68% 85,000 85,000 9% 75,000 75,000 n/a 500 500 n/a 2,500 2,500 42% 10,000 10,000 70% 1,800 1,800 n/a 10,000 10,000 175% 6,000 12,000 6,000 72% 11,429,849 11,735,653 305,804 76% 12,717,322 13,169,361 452,039 Exp. % 5,617,790 740,871 50% 44% d) 12,717,322 11,224,719 1,492,603 TOTAL REQUIREMENTS 6,358,661 5,617,790 740,871 50% NET (Resources - Requirements) 643,738 4,095,558 3,451,820 44% 12,717,322 11,224,719 1,492,603 1,944,642 1,944,642 a) Projections based on actual collections through November 30, 2009. b) Unplanned JAG grant received and higher than planned HIDTA reimbursements. c) Actual escalation increase to Sisters law enforcement contract will be Tess than estimated for the budget. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. Year End Budget Projection `/ariance 50% n/a $ 1,287,473 2,867,777 50% 180,169 50% 54,506 50% 12,750 50% (17,737) 50% (7,988) 50% (62,234) 50% (421,582) 50% (1) 50% (2,000) 50% 905 50% (1) 50% (1) 50% (337) 50% (43,710) 50% (3,629) 50% 1,700 50% 2,004 50% 3,580 50% 15,453 50% (30,400) 50% 500 50% 1,122 50% (765) 50% 351 50% 6,779 50% 7,503 50% 5,714,926 8,279,640 7,002,399 9,713,348 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 6,358,661 2,564,714 50% 2,710,949 50% $1,433,708 $ 146,235 90% a) 7,239,702 7,339,633 99,931 125% a) 239,000 370,961 131,961 2775% b) 2,000 55,506 53,506 67% 76,500 76,500 41% 187,633 187,633 38% 67,000 67,000 0% 124,468 124,468 1% 863,163 863,163 50% 1,786,837 1,786,837 50% c) 420,015 416,016 (3,999) 141% 1,000 1,405 405 50% 27,183 27,183 50% 81,548 81,548 33% 2,000 2,000 n/a 100,000 100,000 22% 13,000 13,000 78% 6,000 6,000 70% 10,000 10,000 122% 5,000 10,000 5,000 68% 85,000 85,000 9% 75,000 75,000 n/a 500 500 n/a 2,500 2,500 42% 10,000 10,000 70% 1,800 1,800 n/a 10,000 10,000 175% 6,000 12,000 6,000 72% 11,429,849 11,735,653 305,804 76% 12,717,322 13,169,361 452,039 Exp. % 5,617,790 740,871 50% 44% d) 12,717,322 11,224,719 1,492,603 TOTAL REQUIREMENTS 6,358,661 5,617,790 740,871 50% NET (Resources - Requirements) 643,738 4,095,558 3,451,820 44% 12,717,322 11,224,719 1,492,603 1,944,642 1,944,642 a) Projections based on actual collections through November 30, 2009. b) Unplanned JAG grant received and higher than planned HIDTA reimbursements. c) Actual escalation increase to Sisters law enforcement contract will be Tess than estimated for the budget. d) Payment to Sheriffs Office based on actual expenditure and adjusted quarterly. Projection is based on 1st quarter actual. 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 Patent Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Drug Court Byme Total Revenues Transfers In -Reserve Fund Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) PUBLIC HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY Coll. % Revised Year End Budget Projection Variance $ 900,000 $ 1,120,355 $ 220,355 100% 124% $ 900,000 $ 1,120,355 $ 220,355 2,000 1,214,964 17,369 106,620 151,500 237,500 66,900 76,075 18,000 49,000 19,000 4,400 65,887 13,500 23 (1,977) 50% 1% 4,000 4,000 887,126 (327,838) 50% 37% a) 2,429,928 2,797,625 367,697 7,690 (9,679) 50% 22% 34,737 34,737 86,533 (20,087) 50% 41% 213,240 213,240 228,888 77,388 50% 76% 303,000 303,000 225,507 (11,993) 50% 47% b) 475,000 475,000 31,348 31,348 50% n/a c) 31,348 31,348 4,568 4,568 50% n/a 4,568 4,568 2,420 2,420 50% n/a 2,420 2,420 69,629 2,729 50% 52% 133,800 133,800 62,397 (13,678) 50% 41% 152,150 152,150 14,890 (3,110) 50% 41% 36,000 36,000 47,480 (1,520) 50% 48% 98,000 98,000 8,658 (10,342) 50% 23% 38,000 38,000 3,187 (1,213) 50% 36% 8,800 8,800 29,649 (36,238) 50% 22% 131,774 131,774 13,500 - 50% 50% 27,000 27,000 1,647 1,647 50% n/a - 30,061 30,061 2,042,715 1,725,140 (317,575) 50% 42% 4,085,429 4,521,523 436,094 12,500 1,158,883 4,114,098 2,229,138 882,266 18,451 75,000 459,243 1,158,882 4,004,377 2,079,853 704,022 75,000 (12,500) 50% 0% (1) 50% 50% (97,221) 50% 149,285 178,244 18,451 459,243 55% Exp. % 25,000 2,317,765 7,328,194 50% 47% a) 4,458,276 50% 40% a) 1,764,531 50% 0% 36,902 50% 50% 150,000 50% n/a 918,485 25,000 2,317,765 7,984,643 4,539,942 2,064,915 36,902 150,000 656,449 (81,666) (300,384) 918,485 3,664,098 2,858,875 805,223 50% 39% 7,328,194 6,791,759 536,435 450,000 1,145,502 708,002 - 1,192,884 1,192,884 a) State Grant projection adjusted to actual FY 2010 contract, includes Rev. 1 - 5. Grant appropriation for revisions in process. b) Payments are received one month in arrears. c) Grants for HIV and Chronic Care were not included in FY 2010 budget. RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Seizure/Forfeiture Interest on Investments Rentals Donations Interfund Contract Administrative Fee Comm. on Children & Fam Crime Prevention Services Total Revenues Transfers In -General Fund Transfers In -Other BEHAVIORAL HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % Revised Budget Year End Projection /ariance $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% $ 2,725,000 $ 2,589,996 $ (135,004) 2,750 62,500 1,000 49,910 2,638,543 92,358 150,353 53,000 35,000 20,400 123,750 5,750 16,000 8,250 1,500 1,560 1,517,477 11,000 63,500 2,940 190 50% 53% 5,500 5,500 64,965 2,465 50% 52% 125,000 125,000 70 (930) 50% 4% 2,000 200 (1,800) 56,451 6,541 50% 57% a) 99,819 99,819 2,689,013 50,470 50% 51% b) 5,277,086 5,351,224 74,138 48,009 (44,349) 50% 26% 184,716 184,716 18,594 (131,759) 50% 6% c) 300,705 300,705 53,321 321 50% 50% 106,000 106,000 47,400 12,400 50% 68% 70,000 88,800 18,800 10,877 (9,523) 50% 27% 40,800 30,000 (10,800) 55,233 (68,517) 50% 22% 247,500 150,000 (97,500) 1,780 (3,970) 50% 15% 11,500 5,000 (6,500) 13,129 13,129 50% n/a - 13,129 13,129 22,498 6,498 50% 70% 32,000 45,000 13,000 5,250 (3,000) 50% 32% 16,500 16,500 7,000 5,500 50% 233% 3,000 7,000 4,000 (1,560) 50% 0% 3,120 (3,120) 1,494,534 (22,943) 50% 49% 3,034,954 3,031,954 (3,000) (11,000) 50% 0% 22,000 (22,000) 38,260 (25,240) 50% 30% a) 127,000 127,000 4,854,601 658,079 127,818 4,629,324 (225,277) 50% 48% 9,709,200 9,687,547 (21,653) 658,080 1 50% 50% 1,316,158 1,316,158 181,566 53,748 50% 71% 255,636 363,129 107,493 TOTAL RESOURCES 8,365,498 REQUIREMENTS: Expenditures Personal Services 3,952,840 Materials and Services 2,026,757 Capital Outlay 40,000 Transfers Out 75,000 Contingency 908,400 8,058,966 (306,532) 50% 58% 14,005,994 13,956,830 (49,164) Exp. % 3,534,369 418,471 50% 45% d) 1,609,025 417,732 50% 40% 40,000 50% 0% 75,000 50% 50% 908,400 50% n/a TOTAL REQUIREMENTS 7,002,997 7,905,680 4,053,514 80,000 150,000 1,816,800 7,470,661 3,653,514 150,000 435,019 400,000 80,000 1,816,800 5,218,394 1,784,603 50% 37% 14,005,994 11,274,175 2,731,819 NET (Resources - Requirements) 1,362,501 2,840,572 1,478,071 - 2,682,655 2,682,655 a) Grant billing received quarterly, in arrears. b) Dept of Human Services Grant projected at amended contract amount for FY 2010. c) Delay in payment due to problems with the State MMIS software system. d) 10% reduction in hours through 12/31/09. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 413,471 629,659 $ 216,188 100% 152% $ 413,471 $ 629,659 216,188 Revenues Admin -Operations 1,825 8,886 7,061 50% 243% a) 3,650 15,000 11,350 Admin -GIS 1,038 9,445 8,407 50% 455% b) 2,075 40,700 38,625 Admin -Code Enforcement 94,725 80,122 (14,603) 50% 42% c) 189,450 151,300 (38,150) Building Safety 487,388 425,159 (62,229) 50% 44% c) 974,775 789,100 (185,675) Electrical 140,250 128,917 (11,333) 50% 46% c) 280,500 235,500 (45,000) Contract Services 127,750 44,928 (82,822) 50% 18% d) 255,500 107,900 (147,600) Env Health -On Site Prog 146,425 113,452 (32,974) 50% 39% c) 292,850 224,200 (68,650) Env Health-Lic Facilities 345,238 395,251 50,013 50% 57% e) 690,475 690,475 Env Health - Drinking H2O 47,656 56,842 9,186 50% 60% f) 95,311 95,311 Planning -Current 492,075 322,213 (169,862) 50% 33% g) 984,150 641,800 (342,350) Planning -Long Range 214,450 189,527 (24,923) 50% 44% c) 428,900 374,410 (54,490) Total Revenues Trans In -GF Trans In -GF for Lng Rng Ping Trans In -Other TOTAL RESOURCES 2,098,820 1,774,741 (324,079) 50% 42% 4,197,636 3,365,696 (831,940) 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 608,314 608,314 0% n/a 1,216,627 1,216,627 150,000 150,000 - 0% n/a 300,000 300,000 50 (50) 0% 0% 100 (100) 3,270,655 3,162,713 (107,942) 50% 52% 6,127,834 5,511,982 (615,852) Exp. %, 854,056 831,864 22,192 50% 49% 1,708,112 1,708,112 107,803 101,655 6,148 50% 47% 215,606 215,606 90,485 88,745 1,740 50% 49% 180,969 180,969 362,573 341,978 20,595 50% 47% h) 725,145 698,080 27,065 103,360 99,679 3,681 50% 48% h) 206,719 193,187 13,532 132,391 125,594 6,797 50% 47% h) 264,781 260,270 4,511 120,344 115,269 5,075 50% 48% 240,687 240,687 247,973 246,109 1,864 50% 50% 495,946 495,946 40,299 42,047 (1,748) 50% 52% 80,598 80,598 404,892 384,196 20,696 50% 47% 809,783 784,783 25,000 275,914 210,658 65,256 50% 38% 551,828 551,828 88,830 162,418 (73,588) 0% 91% 177,660 177,660 235,000 235,000 50% n/a 470,000 470,000 TOTAL REQUIREMENTS 3,063,920 2,750,210 313,711 50% 45% 6,127,834 5,587,726 540,108 NET (Resources - Requirements) 206,735 412,504 205,769 (75,744) (75,744) Revenues 1,774,741 3,365,696 Expenditures 2,750,210 5,587,726 Net from Operations (975,469) (2,222,030) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer. c) Projections are below budget due to recent volume downturns. d) Significant drop-off in City of Redmond work. e) Revenue is received primarily in December through February following mailing of license renewal statements. f) Payments from State DHS are received irregularly. g) Significant slowdown in land use applications. h) Projection reflects the retirement of the Building Safety Director in November. Year End Budget Projection Variance Total Revenues Trans In -GF Trans In -GF for Lng Rng Ping Trans In -Other TOTAL RESOURCES 2,098,820 1,774,741 (324,079) 50% 42% 4,197,636 3,365,696 (831,940) 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 608,314 608,314 0% n/a 1,216,627 1,216,627 150,000 150,000 - 0% n/a 300,000 300,000 50 (50) 0% 0% 100 (100) 3,270,655 3,162,713 (107,942) 50% 52% 6,127,834 5,511,982 (615,852) Exp. %, 854,056 831,864 22,192 50% 49% 1,708,112 1,708,112 107,803 101,655 6,148 50% 47% 215,606 215,606 90,485 88,745 1,740 50% 49% 180,969 180,969 362,573 341,978 20,595 50% 47% h) 725,145 698,080 27,065 103,360 99,679 3,681 50% 48% h) 206,719 193,187 13,532 132,391 125,594 6,797 50% 47% h) 264,781 260,270 4,511 120,344 115,269 5,075 50% 48% 240,687 240,687 247,973 246,109 1,864 50% 50% 495,946 495,946 40,299 42,047 (1,748) 50% 52% 80,598 80,598 404,892 384,196 20,696 50% 47% 809,783 784,783 25,000 275,914 210,658 65,256 50% 38% 551,828 551,828 88,830 162,418 (73,588) 0% 91% 177,660 177,660 235,000 235,000 50% n/a 470,000 470,000 TOTAL REQUIREMENTS 3,063,920 2,750,210 313,711 50% 45% 6,127,834 5,587,726 540,108 NET (Resources - Requirements) 206,735 412,504 205,769 (75,744) (75,744) Revenues 1,774,741 3,365,696 Expenditures 2,750,210 5,587,726 Net from Operations (975,469) (2,222,030) a) Revenues are higher than budgeted due to interest earnings on positive fund balance. b) Custom GIS work revenue sporadic. Includes $37,175 reimbursement from IT -Web Programmer. c) Projections are below budget due to recent volume downturns. d) Significant drop-off in City of Redmond work. e) Revenue is received primarily in December through February following mailing of license renewal statements. f) Payments from State DHS are received irregularly. g) Significant slowdown in land use applications. h) Projection reflects the retirement of the Building Safety Director in November. ROAD Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 Revenues Federal Reimbursements 245,000 - (245,000) 50% 0% 490,000 490,000 System Development Chrg 462 462 50% n/a 925 925 Mineral Lease Royalties 5,000 15,800 10,800 50% 158% 10,000 25,000 15,000 Forest Receipts 1,241,000 (1,241,000) 50% 0% a) 2,482,000 2,482,350 350 State Grant 207,739 - (207,739) 50% 0% 415,477 415,477 Motor Vehicle Revenue 4,000,000 3,678,315 (321,685) 50% 46% 8,000,000 8,000,000 City of Bend 112,500 250,085 137,585 50% 111% b) 225,000 275,000 50,000 City of Redmond 125,000 316,603 191,603 50% 127% b) 250,000 350,000 100,000 City of Sisters 5,000 (5,000) 50% 0% b) 10,000 10,000 City of La Pine 5,000 - (5,000) 50% n/a b) 10,000 10,000 Admin Recovery (SDC) 250 764 514 50% n/a 500 1,500 1,000 Miscellaneous 65,000 13,827 (51,173) 50% 11% 130,000 130,000 Road Vacations 500 500 50% 50% 1,000 1,000 Interest on Investments 25,000 25,761 761 50% 52% 50,000 50,000 Other Bank/LGIP Interest - 1,106 1,106 50% n/a 1,500 1,500 Interfund Contract 350,000 - (350,000) 50% 0% c) 700,000 700,000 Equipment Repairs 137,500 121,801 (15,699) 50% 44% 275,000 275,000 Vehicle Repairs 45,000 (45,000) 50% 0% c) 90,000 90,000 Vegetation Management 17,500 (17,500) 50% 0% c) 35,000 35,000 Inter -fund: Forester 11,000 - (11,000) 50% 0% c) 22,000 22,000 Car Washes 1,250 1,342 92 50% 54% 2,500 2,500 Car Rental 406 406 50% n/a 1,000 1,000 Sale of Eqp & Material 400,000 353,390 (46,610) 50% 44% 800,000 800,000 Total Revenues 6,999,239 4,780,162 (2,219,077) 50% 34% 13,998,477 14,168,252 169,775 Trans In - CDD Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res 9,095 (9,095) 50% 0% 18,190 18,190 354,284 354,284 - 50% 50% d) 708,567 708,567 37,500 37,500 - 50% 50% d) 75,000 75,000 5,000 (5,000) 50% 0% c) 10,000 10,000 TOTAL RESOURCES 12,239,283 10,063,595 (2,213,188) 50% 62% 19,681,899 19,871,658 189,759 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. % 2,832,687 2,642,833 189,854 50% 47% 5,665,373 5,665,373 4,566,605 4,785,817 (219,212) 50% 52% e) 9,133,210 9,133,210 1,350,000 968,760 381,240 50% 36% 2,700,000 2,700,000 200,000 200,000 50% 0% 400,000 400,000 - 891,658 891,658 50% n/a 1,783,316 1,783,316 TOTAL REQUIREMENTS 9,840,950 8,397,410 1,443,540 50% 43% 19,681,899 17,898,583 1,783,316 NET (Resources - Requirements) 2,398,333 1,666,185 (769,648) 1,973,075 1,973,075 a) Annual payment, $2,482,350, received January 15, 2010. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% $ 4,871,665 $ 4,891,649 $ 19,984 Revenues Federal Reimbursements 245,000 - (245,000) 50% 0% 490,000 490,000 System Development Chrg 462 462 50% n/a 925 925 Mineral Lease Royalties 5,000 15,800 10,800 50% 158% 10,000 25,000 15,000 Forest Receipts 1,241,000 (1,241,000) 50% 0% a) 2,482,000 2,482,350 350 State Grant 207,739 - (207,739) 50% 0% 415,477 415,477 Motor Vehicle Revenue 4,000,000 3,678,315 (321,685) 50% 46% 8,000,000 8,000,000 City of Bend 112,500 250,085 137,585 50% 111% b) 225,000 275,000 50,000 City of Redmond 125,000 316,603 191,603 50% 127% b) 250,000 350,000 100,000 City of Sisters 5,000 (5,000) 50% 0% b) 10,000 10,000 City of La Pine 5,000 - (5,000) 50% n/a b) 10,000 10,000 Admin Recovery (SDC) 250 764 514 50% n/a 500 1,500 1,000 Miscellaneous 65,000 13,827 (51,173) 50% 11% 130,000 130,000 Road Vacations 500 500 50% 50% 1,000 1,000 Interest on Investments 25,000 25,761 761 50% 52% 50,000 50,000 Other Bank/LGIP Interest - 1,106 1,106 50% n/a 1,500 1,500 Interfund Contract 350,000 - (350,000) 50% 0% c) 700,000 700,000 Equipment Repairs 137,500 121,801 (15,699) 50% 44% 275,000 275,000 Vehicle Repairs 45,000 (45,000) 50% 0% c) 90,000 90,000 Vegetation Management 17,500 (17,500) 50% 0% c) 35,000 35,000 Inter -fund: Forester 11,000 - (11,000) 50% 0% c) 22,000 22,000 Car Washes 1,250 1,342 92 50% 54% 2,500 2,500 Car Rental 406 406 50% n/a 1,000 1,000 Sale of Eqp & Material 400,000 353,390 (46,610) 50% 44% 800,000 800,000 Total Revenues 6,999,239 4,780,162 (2,219,077) 50% 34% 13,998,477 14,168,252 169,775 Trans In - CDD Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res 9,095 (9,095) 50% 0% 18,190 18,190 354,284 354,284 - 50% 50% d) 708,567 708,567 37,500 37,500 - 50% 50% d) 75,000 75,000 5,000 (5,000) 50% 0% c) 10,000 10,000 TOTAL RESOURCES 12,239,283 10,063,595 (2,213,188) 50% 62% 19,681,899 19,871,658 189,759 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. % 2,832,687 2,642,833 189,854 50% 47% 5,665,373 5,665,373 4,566,605 4,785,817 (219,212) 50% 52% e) 9,133,210 9,133,210 1,350,000 968,760 381,240 50% 36% 2,700,000 2,700,000 200,000 200,000 50% 0% 400,000 400,000 - 891,658 891,658 50% n/a 1,783,316 1,783,316 TOTAL REQUIREMENTS 9,840,950 8,397,410 1,443,540 50% 43% 19,681,899 17,898,583 1,783,316 NET (Resources - Requirements) 2,398,333 1,666,185 (769,648) 1,973,075 1,973,075 a) Annual payment, $2,482,350, received January 15, 2010. b) Billed upon completion of work. c) Payment to be received in June 2010 from Funds 326, 328, 329, 340, and 430. d) Transfer made quarterly. e) Seasonal expenditures, Aggregate/Asphalt & Preservation/Overlays RESOURCES: Beg. Net Working Capital Revenues ADULT PAROLE & PROBATION Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $ 467,892 $ 487,674 $ 19,782 100% 104% $ 467,892 $ 487,674 $ 19,782 State Miscellaneous 4,000 (4,000) 50% 0% a) 8,000 4,301 (3,699) State Subsidy 14,750 37,571 22,821 50% 127% b) 29,500 44,224 14,724 SB 1145 1,419,963 1,480,995 61,032 50% 52% 2,839,925 2,961,990 122,065 Probation Work Crew Fees 20,000 19,195 (805) 50% 48% 40,000 40,000 Miscellaneous 1,500 2,155 655 50% 72% 3,000 3,000 Electronic Monitoring Fee 80,000 89,096 9,096 50°l° 56% 160,000 160,000 Probation Superv. Fees 110,000 110,968 968 50% 50% 220,000 220,000 Interest on Investments 4,500 6,327 1,827 50% 70% 9,000 9,000 Interfund - Sheriff 25,000 25,000 50% 50% 50,000 50,000 Crime Prevention Services 25,000 12,500 (12,500) 50% 25% c) 50,000 50,000 Total Revenues 1,704,713 1,783,807 79,094 50% 52% 3,409,425 3,542,515 133,090 Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 57,515 57,516 1 50% 50% 115,029 115,029 2,230,120 2,328,997 98,877 50% 58% 3,992,346 4,145,218 152,872 Exp. % 1,429,363 1,376,625 52,738 50% 48% 2,858,726 2,858,726 352,061 350,064 1,997 50% 50% 704,121 704,121 50 50 50% 0% 100 214,700 214,700 50% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 1,996,174 1,726,689 269,485 50% 43% 3,992,346 3,562,847 429,499 NET (Resources - Requirements) 233,946 602,308 368,362 a) Payment to be received in January. b) Subsidy revenues will be higher than the budgeted amount. c) Payments made quarterly, funds to be released in January. 582,371 582,371 Year End Budget Projection Variance $ 467,892 $ 487,674 $ 19,782 State Miscellaneous 4,000 (4,000) 50% 0% a) 8,000 4,301 (3,699) State Subsidy 14,750 37,571 22,821 50% 127% b) 29,500 44,224 14,724 SB 1145 1,419,963 1,480,995 61,032 50% 52% 2,839,925 2,961,990 122,065 Probation Work Crew Fees 20,000 19,195 (805) 50% 48% 40,000 40,000 Miscellaneous 1,500 2,155 655 50% 72% 3,000 3,000 Electronic Monitoring Fee 80,000 89,096 9,096 50°l° 56% 160,000 160,000 Probation Superv. Fees 110,000 110,968 968 50% 50% 220,000 220,000 Interest on Investments 4,500 6,327 1,827 50% 70% 9,000 9,000 Interfund - Sheriff 25,000 25,000 50% 50% 50,000 50,000 Crime Prevention Services 25,000 12,500 (12,500) 50% 25% c) 50,000 50,000 Total Revenues 1,704,713 1,783,807 79,094 50% 52% 3,409,425 3,542,515 133,090 Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 57,515 57,516 1 50% 50% 115,029 115,029 2,230,120 2,328,997 98,877 50% 58% 3,992,346 4,145,218 152,872 Exp. % 1,429,363 1,376,625 52,738 50% 48% 2,858,726 2,858,726 352,061 350,064 1,997 50% 50% 704,121 704,121 50 50 50% 0% 100 214,700 214,700 50% n/a 429,399 100 429,399 TOTAL REQUIREMENTS 1,996,174 1,726,689 269,485 50% 43% 3,992,346 3,562,847 429,499 NET (Resources - Requirements) 233,946 602,308 368,362 a) Payment to be received in January. b) Subsidy revenues will be higher than the budgeted amount. c) Payments made quarterly, funds to be released in January. 582,371 582,371 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Six Months Ended December 31, 2009 RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 112,500 63,717 (48,783) 50% 28% d) 225,000 367,600 142,600 Title IV - Family Sup/Pres 18,826 (18,826) 50% 0% a) 37,652 14,907 (22,745) HealthyStart Medicaid 47,500 (47,500) 50% 0% 95,000 95,000 Child Care Block Grant 40,638 (40,638) 50% 0% a) 81,275 (81,275) Level 7 Services 87,597 (87,597) 50% 0% a) 175,193 257,982 82,789 HealthyStart/R-S-G 153,789 76,820 (76,969) 50% 25% a) 307,577 308,924 1,347 OCCF Grant 307,026 253,327 (53,699) 50% 41% a) 614,052 498,383 (115,669) Local Government Grants - 7,849 7,849 50% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,000 1,374 (2,626) 50% 17% 8,000 8,000 Court Fines & Fees 37,500 38,979 1,479 50% 52% c) 75,000 70,000 (5,000) Interest on Investments 15,000 5,037 (9,963) 50% 17% 30,000 30,000 Grants -Private 1,000 - (1,000) 50% 0% 2,000 2,000 Interfund Grants 93,750 61,875 (31,875) 50% 33% 187,500 187,500 Crime Prevention Services 37,175 10,683 (26,492) 50% 14% 74,350 74,350 Total Revenues 956,301 519,661 (436,640) 50% 27% 1,912,599 1,922,495 9,896 Trans from General Fund Total Transfers In 142,167 142,166 142,167 142,166 (1) 50% 50% 284,333 284,333 (1) 50% 50% 284,333 284,333 TOTAL RESOURCES 1,723,011 1,330,453 (392,558) 50% 47% 2,821,475 2,875,454 53,979 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 269,989 257,905 12,084 50% 48% b) 539,978 526,639 13,339 887,522 441,537 445,985 50% 25% a,d,e) 1,775,043 1,791,449 (16,406) 50 - 50 50% 0% 100 100 253,177 253,177 50% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,410,738 699,442 711,296 50% 25% 2,821,475 2,318,088 503,387 NET (Resources- Requirements) 312,273 631,011 318,738 557,366 557,366 a) Revenue projections based on final legislative allocations. b) Personnel projection reduced due to two positions open in 1st quarter. c) Court fees reduced for FY 2010. d) New federal grant for the Family Access Network awarded. e) Regional project contributions from Crook & Jefferson counties. Year to Date Budget Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 112,500 63,717 (48,783) 50% 28% d) 225,000 367,600 142,600 Title IV - Family Sup/Pres 18,826 (18,826) 50% 0% a) 37,652 14,907 (22,745) HealthyStart Medicaid 47,500 (47,500) 50% 0% 95,000 95,000 Child Care Block Grant 40,638 (40,638) 50% 0% a) 81,275 (81,275) Level 7 Services 87,597 (87,597) 50% 0% a) 175,193 257,982 82,789 HealthyStart/R-S-G 153,789 76,820 (76,969) 50% 25% a) 307,577 308,924 1,347 OCCF Grant 307,026 253,327 (53,699) 50% 41% a) 614,052 498,383 (115,669) Local Government Grants - 7,849 7,849 50% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,000 1,374 (2,626) 50% 17% 8,000 8,000 Court Fines & Fees 37,500 38,979 1,479 50% 52% c) 75,000 70,000 (5,000) Interest on Investments 15,000 5,037 (9,963) 50% 17% 30,000 30,000 Grants -Private 1,000 - (1,000) 50% 0% 2,000 2,000 Interfund Grants 93,750 61,875 (31,875) 50% 33% 187,500 187,500 Crime Prevention Services 37,175 10,683 (26,492) 50% 14% 74,350 74,350 Total Revenues 956,301 519,661 (436,640) 50% 27% 1,912,599 1,922,495 9,896 Trans from General Fund Total Transfers In 142,167 142,166 142,167 142,166 (1) 50% 50% 284,333 284,333 (1) 50% 50% 284,333 284,333 TOTAL RESOURCES 1,723,011 1,330,453 (392,558) 50% 47% 2,821,475 2,875,454 53,979 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 269,989 257,905 12,084 50% 48% b) 539,978 526,639 13,339 887,522 441,537 445,985 50% 25% a,d,e) 1,775,043 1,791,449 (16,406) 50 - 50 50% 0% 100 100 253,177 253,177 50% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,410,738 699,442 711,296 50% 25% 2,821,475 2,318,088 503,387 NET (Resources- Requirements) 312,273 631,011 318,738 557,366 557,366 a) Revenue projections based on final legislative allocations. b) Personnel projection reduced due to two positions open in 1st quarter. c) Court fees reduced for FY 2010. d) New federal grant for the Family Access Network awarded. e) Regional project contributions from Crook & Jefferson counties. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% $ 624,543 $ 668,626 $ 44,083 Revenues Federal Grants 112,500 63,717 (48,783) 50% 28% d) 225,000 367,600 142,600 Title IV - Family Sup/Pres 18,826 (18,826) 50% 0% a) 37,652 14,907 (22,745) HealthyStart Medicaid 47,500 (47,500) 50% 0% 95,000 95,000 Child Care Block Grant 40,638 (40,638) 50% 0% a) 81,275 (81,275) Level 7 Services 87,597 (87,597) 50% 0% a) 175,193 257,982 82,789 HealthyStart/R-S-G 153,789 76,820 (76,969) 50% 25% a) 307,577 308,924 1,347 OCCF Grant 307,026 253,327 (53,699) 50% 41% a) 614,052 498,383 (115,669) Local Government Grants - 7,849 7,849 50% n/a e) 7,849 7,849 Charges for Svcs-Misc 4,000 1,374 (2,626) 50% 17% 8,000 8,000 Court Fines & Fees 37,500 38,979 1,479 50% 52% c) 75,000 70,000 (5,000) Interest on Investments 15,000 5,037 (9,963) 50% 17% 30,000 30,000 Grants -Private 1,000 - (1,000) 50% 0% 2,000 2,000 Interfund Grants 93,750 61,875 (31,875) 50% 33% 187,500 187,500 Crime Prevention Services 37,175 10,683 (26,492) 50% 14% 74,350 74,350 Total Revenues 956,301 519,661 (436,640) 50% 27% 1,912,599 1,922,495 9,896 Trans from General Fund Total Transfers In 142,167 142,166 142,167 142,166 (1) 50% 50% 284,333 284,333 (1) 50% 50% 284,333 284,333 TOTAL RESOURCES 1,723,011 1,330,453 (392,558) 50% 47% 2,821,475 2,875,454 53,979 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 269,989 257,905 12,084 50% 48% b) 539,978 526,639 13,339 887,522 441,537 445,985 50% 25% a,d,e) 1,775,043 1,791,449 (16,406) 50 - 50 50% 0% 100 100 253,177 253,177 50% n/a 506,354 506,354 TOTAL REQUIREMENTS 1,410,738 699,442 711,296 50% 25% 2,821,475 2,318,088 503,387 NET (Resources- Requirements) 312,273 631,011 318,738 557,366 557,366 a) Revenue projections based on final legislative allocations. b) Personnel projection reduced due to two positions open in 1st quarter. c) Court fees reduced for FY 2010. d) New federal grant for the Family Access Network awarded. e) Regional project contributions from Crook & Jefferson counties. SOLID WASTE Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 Revenues State Grant 37,850 37,850 50% n/a a) 37,850 37,850 Miscellaneous 15,000 12,461 (2,539) 50% 42% 30,000 30,000 Franchise 3% Fees 100,000 16,162 (83,838) 50% 8% b) 200,000 200,000 Commercial Disp. Fees 698,200 462,691 (235,509) 50% 33% c) 1,396,400 1,396,400 Private Disposal Fees 770,650 722,663 (47,987) 50% 47% 1,541,300 1,541,300 Franchise Disposal Fees 2,371,750 2,009,045 (362,705) 50% 42% d) 4,743,500 4,743,500 Yard Debris 37,500 40,327 2,827 50% 54% 75,000 75,000 Special Waste 15,000 13,989 (1,011) 50% 47% 30,000 30,000 - Interest 7,000 7,894 894 50% 56% 14,000 14,000 Sale of Equip & Material 17,500 15,573 (1,927) 50% 44% 35,000 35,000 - Total Revenues 4,032,600 3,338,655 (693,945) 50% 41% 8,065,200 8,103,050 37,850 TOTAL RESOURCES 4,371,211 3,804,980 (566,231) 50% 45% 8,403,811 8,569,375 165,564 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 881,789 838,608 43,181 50% 48% 1,763,578 1,763,578 1,874,127 1,487,653 386,474 50% 40% e) 3,748,254 3,748,254 484,383 405,019 79,364 50% 42% 968,765 968,765 74,500 25,850 48,650 50% 17% f) 149,000 149,000 719,884 354,284 365,600 50% 25% 1,439,767 1,439,767 167,224 167,224 50% n/a 334,447 334,447 TOTAL REQUIREMENTS 4,201,907 3,111,414 1,090,493 50% 37% 8,403,811 8,069,364 334,447 NET (Resources - Requirements) 169,304 693,566 524,262 500,011 500,011 a) Was due last fiscal year but received in FY 2010. b) Due April 15, 2010. c) This is largely construction waste and has not picked back up as yet. d) Rate increase to go into effect January 1, 2010. e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year. f) Capital item purchases are spread out throughout the fiscal year. Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% $ 338,611 $ 466,325 $ 127,714 Revenues State Grant 37,850 37,850 50% n/a a) 37,850 37,850 Miscellaneous 15,000 12,461 (2,539) 50% 42% 30,000 30,000 Franchise 3% Fees 100,000 16,162 (83,838) 50% 8% b) 200,000 200,000 Commercial Disp. Fees 698,200 462,691 (235,509) 50% 33% c) 1,396,400 1,396,400 Private Disposal Fees 770,650 722,663 (47,987) 50% 47% 1,541,300 1,541,300 Franchise Disposal Fees 2,371,750 2,009,045 (362,705) 50% 42% d) 4,743,500 4,743,500 Yard Debris 37,500 40,327 2,827 50% 54% 75,000 75,000 Special Waste 15,000 13,989 (1,011) 50% 47% 30,000 30,000 - Interest 7,000 7,894 894 50% 56% 14,000 14,000 Sale of Equip & Material 17,500 15,573 (1,927) 50% 44% 35,000 35,000 - Total Revenues 4,032,600 3,338,655 (693,945) 50% 41% 8,065,200 8,103,050 37,850 TOTAL RESOURCES 4,371,211 3,804,980 (566,231) 50% 45% 8,403,811 8,569,375 165,564 REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Exp. % 881,789 838,608 43,181 50% 48% 1,763,578 1,763,578 1,874,127 1,487,653 386,474 50% 40% e) 3,748,254 3,748,254 484,383 405,019 79,364 50% 42% 968,765 968,765 74,500 25,850 48,650 50% 17% f) 149,000 149,000 719,884 354,284 365,600 50% 25% 1,439,767 1,439,767 167,224 167,224 50% n/a 334,447 334,447 TOTAL REQUIREMENTS 4,201,907 3,111,414 1,090,493 50% 37% 8,403,811 8,069,364 334,447 NET (Resources - Requirements) 169,304 693,566 524,262 500,011 500,011 a) Was due last fiscal year but received in FY 2010. b) Due April 15, 2010. c) This is largely construction waste and has not picked back up as yet. d) Rate increase to go into effect January 1, 2010. e) Some larger ticketed items are budgeted in M&S but not scheduled for purchase until later in the fiscal year. f) Capital item purchases are spread out throughout the fiscal year. RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: RISK MANAGEMENT Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance %of FY % Coll. $2,491,977 $2,669,291 $177,314 100% 107% $2,491,977 $2,669,291 $177,314 General Liability 228,482 228,471 (11) 50% 50% 456,964 456,964 - Property Damage 143,147 143,052 (95) 50% 50% 286,294 286,294 Vehicle 92,098 92,097 (1) 50% 50% 184,195 184,195 Workers' Compensation 427,927 427,920 (7) 50% 50% 855,854 855,854 Unemployment 80,096 80,102 7 50% 50% 160,191 160,191 Claims Reimb-Workers' Compensation 12,500 (12,500) 50% 0% 25,000 25,000 - Claims Reimb-Gen Liab/Property 5,000 90,375 85,375 50% 904% 10,000 92,000 82 000 Process Fee-Events/Parades 450 525 75 50% 58% 900 900 - Miscellaneous 2,000 (23) (2,023) 50% -1% 4,000 4,000 Skid Car Training 11,000 7,490 (3,510) 50% 34% 22,000 22,000 - Interest on Investments 15,000 19,860 4,860 50% 66% 30,000 30,000 TOTAL REVENUES 1,017,699 1,089,869 72,170 50% 54% 2,035,398 2,117,398 82 000 Transfers In -PERS Reserve 50 (50) 50% 0% 100 100) TOTAL RESOURCES 3,509,726 3,759,160 249,434 50% 83% 4,527,475 4,786,689 259,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 135,996 a) Repair / Replacement 110,089 b) Total Property Damage 150,000 246,085 (96,085) 50% 82% 300,000 350,000 (5(,000) VEHICLE Professional Service 883 Insurance 411 Loss Prevention 7,489 Repair / Replacement 30,912 Total Vehicle 60,000 39,694 20,306 50% 33% 120,000 90,000 30,000 WORKERS' COMPENSATION Settlement / Benefit 283,582 Insurance 72,921 Loss Prevention 5,958 Miscellaneous 10,678 Total Workers' Compensation 310,000 373,138 (63,138) 50% 60% 620,000 746,277 (12n1,277) UNEMPLOYMENT - Settlement/Benefits 70,000 101,687 (31,687) 50% 73% c) 140,000 200,000 (61,000) % Exp. 48,206 974 307 139,373 a) 13 4,192 182,556 193,064 (10,508) 50% 53% 365,112 370,000 (4,888) Total Direct Insurance Costs 772,556 953,668 (181,112) 50% 62% 1,545,112 1,756,277 (211,165) Insurance Administration: Personal Services 137,017 133,502 3,515 50% 49% 274,034 274,034 Materials & Service 123,247 91,385 31,862 50% 37% 246,493 246,493 Capital Outlay 50 - 50 50% 0% 100 - 100 Total Insurance Administration 260,314 224,887 35,427 50% 43% 520,627 520,527 100 Contingency 1,230,868 1,230,868 50% n/a 2,461,736 2,4E1,736 TOTAL REQUIREMENTS 2,263,738 1,178,555 1,085,183 50% 26% 4,527,475 2,276,804 2,25),671 NET 1,245,989 2,580,605 1,334,617 - 2,509,885 2,50,885 a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October. b) Expenditures in property damage is offset by claims reimbursement revenue. c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD an( Health Services. Year End Budget Projection Variance 107% $2,491,977 $2,669,291 $177,314 General Liability 228,482 228,471 (11) 50% 50% 456,964 456,964 - Property Damage 143,147 143,052 (95) 50% 50% 286,294 286,294 Vehicle 92,098 92,097 (1) 50% 50% 184,195 184,195 Workers' Compensation 427,927 427,920 (7) 50% 50% 855,854 855,854 Unemployment 80,096 80,102 7 50% 50% 160,191 160,191 Claims Reimb-Workers' Compensation 12,500 (12,500) 50% 0% 25,000 25,000 - Claims Reimb-Gen Liab/Property 5,000 90,375 85,375 50% 904% 10,000 92,000 82 000 Process Fee-Events/Parades 450 525 75 50% 58% 900 900 - Miscellaneous 2,000 (23) (2,023) 50% -1% 4,000 4,000 Skid Car Training 11,000 7,490 (3,510) 50% 34% 22,000 22,000 - Interest on Investments 15,000 19,860 4,860 50% 66% 30,000 30,000 TOTAL REVENUES 1,017,699 1,089,869 72,170 50% 54% 2,035,398 2,117,398 82 000 Transfers In -PERS Reserve 50 (50) 50% 0% 100 100) TOTAL RESOURCES 3,509,726 3,759,160 249,434 50% 83% 4,527,475 4,786,689 259,214 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance 135,996 a) Repair / Replacement 110,089 b) Total Property Damage 150,000 246,085 (96,085) 50% 82% 300,000 350,000 (5(,000) VEHICLE Professional Service 883 Insurance 411 Loss Prevention 7,489 Repair / Replacement 30,912 Total Vehicle 60,000 39,694 20,306 50% 33% 120,000 90,000 30,000 WORKERS' COMPENSATION Settlement / Benefit 283,582 Insurance 72,921 Loss Prevention 5,958 Miscellaneous 10,678 Total Workers' Compensation 310,000 373,138 (63,138) 50% 60% 620,000 746,277 (12n1,277) UNEMPLOYMENT - Settlement/Benefits 70,000 101,687 (31,687) 50% 73% c) 140,000 200,000 (61,000) % Exp. 48,206 974 307 139,373 a) 13 4,192 182,556 193,064 (10,508) 50% 53% 365,112 370,000 (4,888) Total Direct Insurance Costs 772,556 953,668 (181,112) 50% 62% 1,545,112 1,756,277 (211,165) Insurance Administration: Personal Services 137,017 133,502 3,515 50% 49% 274,034 274,034 Materials & Service 123,247 91,385 31,862 50% 37% 246,493 246,493 Capital Outlay 50 - 50 50% 0% 100 - 100 Total Insurance Administration 260,314 224,887 35,427 50% 43% 520,627 520,527 100 Contingency 1,230,868 1,230,868 50% n/a 2,461,736 2,4E1,736 TOTAL REQUIREMENTS 2,263,738 1,178,555 1,085,183 50% 26% 4,527,475 2,276,804 2,25),671 NET 1,245,989 2,580,605 1,334,617 - 2,509,885 2,50,885 a) Annual insurance payment (10/1/09-10/01/10), of $138,000 for Gen Liab and $135,996 for Property Damage, expended in October. b) Expenditures in property damage is offset by claims reimbursement revenue. c) Expenditure for the quarter ended 9/30/09, paid in November, is $101,687. Unemployment payments required due to layoffs in CDD an( Health Services. RESOURCES: Beg. Net Working Capital Revenues Property Taxes - Current Property Taxes - Prior State Reimbursement Telephone User Tax Data Network Reimb. Jefferson County User Fee Contract Payments Miscellaneous Interest Interest on Unsegregated Tax Total Revenues Transfers In -Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency DESCHUTES COUNTY 911 Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance % of FY Coll. $5,137,000 $ 5,611,168 $ 474,168 3,065,391 50,000 12,250 268,000 17,000 14,000 30,250 35,000 4,250 18,000 1,875 5,487,866 213,572 3,339 206,538 26,032 32,415 50,513 25,574 4,334 43,430 1,058 2,422,475 163,572 (8,911) (61,462) 9,032 18,415 20,263 (9,426) 84 25,430 (817) 3,516,016 6,094,671 2,578,655 50 Budget Year End Projection Variance 100% 109% $5,137,000 $5,611,168 $ 474,168 50% 90% 214% 50% 14% 50% 39% 50% 77% 50% 116% 50% 83% 50% 37% 50% 51% 50% 121% 50% 28% 50% 50% 87% a) 6,130,782 a) 100,000 b) 24,500 536,000 c) 34,000 28,000 60,500 d) 70,000 8,500 36,000 3,750 6,208,795 78,013 270,275 170,275 6,000 (18,500) 536,000 27,880 (6,120) 32,415 4,415 60,500 26,000 (44,000) 8,500 43,430 7,430 3,750 7,032,032 7,223,545 191,513 (50) 50% 0% 100 - (100) 8,653,016 11,705,839 3,052,823 50% 96% 12,169,132 12,834,713 665,581 % Exp. 1,908,144 1,724,731 183,413 50% 45% 644,761 484,355 160,406 50% 38% 87,500 13,830 73,670 50% 8% 969,470 969,470 50% 0% 2,474,692 2,474,692 50% n/a TOTAL REQUIREMENTS 6,084,567 2,222,916 3,861,651 50% 18% NET (Resources - Requirements) 2,568,449 9,482,923 6,914,474 a) Projections based on actual collections through November 30, 2009 b) Less activity being performed. c) Annual billings. d) Less contract activity with law enforcement agencies. 3,816,287 3,816,287 1,289,522 1,289,522 175,000 175,000 1,938,939 1,938,939 4,949,384 4,949,384 12,169,132 7,219,748 4,949,384 - 5,614,965 5,614,965 Health Benefits Trust Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % Revised Budget * Year End F. Projection Variance RESOURCES Beg. Net Working Capital $ 17,894,797 $ 17,894,797 $ (0) 100% 100% $ 17,894,797 $ 17,894,797 $ (0) Revenues: Internal Premium Charges 5,240,000 5,242,111 2,111 50% 50% a) 10,480,000 10,480,000 PIT Emp - Add'I Prem 27,500 22,728 (4,772) 50% 41% 55,000 55,000 Employee Prem Contribution 165,000 169,820 4,820 50% 51% 330,000 330,000 COIC 500,000 546,874 46,874 50% 55% 1,000,000 1,040,000 40,000 Retiree / COBRA Co -Pay 250,000 307,504 57,504 50% 62% 500,000 555,000 55,000 Prescription Rebates 12,389 12,389 50% n/a 12,389 12,389 Interest 112,500 125,482 12,982 50% 56% 225,000 225,000 Total Revenues 6,295,000 6,426,908 131,908 50% 51% 12,590,000 12,697,389 107,389 TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-DentalNision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Other Total Materials & Services Capital Outlay Contingency 24,189,797 24,321,705 131,908 92% 80% 30,484,797 30,592,186 107,389 Exp. % 54,649 51,874 2,775 50% 47% 109,297 109,297 1,500 505 995 50% 17% 3,000 3,000 7,123,788 5,683,473 1,440,315 50% 40% b) 14,247,576 10,945,947 3.301,629 911,000 791,840 119,160 50% 43% b) 1,822,000 1,525,025 296,975 (42,046) 42,046 50% n/a (42,046) 42,046 186,270 186,001 269 50% 50% 372,540 372,540 5,750 68,989 (63,239) 50% n/a c) 11,500 11,500 146,382 144,413 1,969 50% 49% 292,764 292,764 40,824 18,699 22,125 50% 23% 81,648 81,648 24,786 24,812 (26) 50% 50% 49,572 49,572 5,000 393 4,607 50% 4% 10,000 10,000 50,000 1,239 48,761 50% 1% 100,000 100,000 14,530 15,655 (1,126) 50% 54% 29,059 29,059 8,509,830 6,893,973 1,615,857 50% 41% 17,019,659 13,379,009 3,340,650 - 50% 0% 100 100 6,677,871 6,677,871 50% 0% 13,355,741 13,;955,741 TOTAL REQUIREMENTS 15,242,349 6,945,846 8,296,502 50% 23% 30,484,797 13,488,306 16,' 96,491 NET (Resources - Requirements) 8,947,449 17,375,859 8,428,410 - 17,103,880 17," 03,880 * Proposed revisions to FY 2010 original budget a) Amount budgeted to be transferred from operating funds for FY 2010. b) Projection based on annualizing 27 weeks of claims paid. YTD actual is $238,269 per week. c) Zurich to reimburse County $57,490 (5/6ths) of the $68,989 payment made in July for the July through December assessment. O 0 a C C CO0 _O O 0) N 3- o LL m O 0 O 0 2 g 0 W 0 3 Q O a) j } � Q a E U O 4) U O 7 r- CDOMOCCOO CO N O O (D 0-. N' r Q1 CO co 0,0)'o,.-'rl0' ' co o vNM NA,V r A -a O• 'O O CO OCO CO O'. - CO 01,E CO N r (O OD CO ' O cci N' O N (O OD 0,1 r a. 0) CON 0.0 0, 0 0 O, O, O O'. O O 0) a 0 M O co O, 0. 0' CD,C))'0 0 N, '�'(OD'O a. ▪ .- to V co Lo N V 01 O LO M M O r 0 OI N,V 0 A- r ,- U) r o '.M o ^ O.r.o rO co .o I • co "O O CV CV O CO a 0 CO ✓ a 0�0�'a Lc) 0 0) v m r (O • CO OD U) N .N 0 CD LO (0(O m'Mr a)rn c ci cv CO N • N N CO O N O COO CO COOO N N 1.0 N N 4)) CO 0 a 0 A- a) r 'o a a a1 at O) (a (0 co' N (O r (V O r' (D CO' Oa r CV - a), N CO CO.N CV N O O' N 0 0 OD CS. 0 (O'0 CO CO 0 CO O CO O O OD CO (O 0 V 00 N • N 0,CO0 0) r ('i of :co 0- coV o ri 0 (c M N V - 0) CV OD CO r O 'Cr a 0 0 CO (c N N '(D.O V- 0 (4) 0 N 0 0 (0 (N+) is_ r (o+) ✓ N r CID o CO 0 (24,320)! (26,014)i LO 0' 0 0 N0- 0) 0 a) (0' ' co O.,o ' ' M a. r CO ' O. 0)) ',Nr,r ((00'V 0 - a o 0',010 0 0.-,, N O'O'O 0 '0 N a' N.. 10 L0,0 CD ' 0MO r 0 c - co N r'a (a o 0 o co 0 0) r M O O a1ri O Is, 0 OO O. 4)1 CD CV N O r 0 O' co O r' O (4)' CO 0 CO N' N'M ' 0' 0 0 0 ' r CO r M ' O CO. (00 01. N'O. N (0 sr N.) a 0 (0 N o'. 0' L'a)' a ((00 v. O' — ' a.0' ' ' CO N 01 co '!, a O r coN00)) 0 (00 CO (MO O r v1 a. CO O' O CO 00) 0 CO 0i'(n (0• 0- 1N Is, N CO 0 0 00 a,3 0 0 0 (a (D (a 0 O 0 0 M M 0' 0) r' CO (D - ' O ' O O M .0 r M O, 10 ' ' ' ' ' (4) •of (v' co ' a 0) N M' (O (O',a 1A N o o '.7 a .- 0r 0 'O c0. a r 0 0 0 co co O 0) a1 O O a0 a0 N ,, ,, O ' O, ' co r.M ' O CO. O, ' ' ' N t+f cm m ( 4 04 (0 a 0) o co (4) vi co N (a, (0 10 if) r N CO. r 0,N `Cl. M C0 0) r i'.' N 0 0,0 CO O N O: O' N O O' CO r CO N v a O o CO O O' CO CO 1 CO CO 0 0 N N IO ' ' O'. N ' lO r LO CO ' ("! N,0'M ',O ' 0 M'O'.0 ' a1. r N ^' .'M Cc N (01 (V, 0l' (Oczi ✓ CO 0) V N M, r. 0).� (0 0) r 001. • co CV 10 N LO CO' CO CO 0 N O 0 O' 0 0..0' 0 0 N r r 'O a (O 0 N O.O'N O 01- O (O• ' '0) CO V' a_ O CO ,a' 0) o',M r ..4. (0 O 0) it N ! 07 CO, cn a', V CO CD 0) W 0).i'-'. a O, O,) ID (O O M r CO CO' m CO a CO - O 0) n- 0 O V N IO O CO r . N 'Cr I(a' (DCO ,OCol 0 O aD. r 0 O OD 01 CO (0 O)' r , (V''0 a (a r- o r (n 00 i X0...0 (O M. 4-. co N N' - (0 a, O r N a 0 co ' �a a', 03 N' O `Cr' O LL (01 N'c O N 0'',- O '. 0) N CMo▪ ' 'a'O coO',M N o a N a (0 CO CO 0 ao, 0.O 'O (0. N'0 r� ('4 CO 01. ' 0 1 0) 0 CO r,N " O q 'N O!'. loo, cc.,,,. 1 a CT 1`, 001. (00 0) O (O', N O 1) 7 rn c)Ei 0) C (0 C: d N' O m 0 Q' O N d N Z K EL' 1.1 _ (7 0 r 7 y y .T. sol. N. W 21'11'03 Y, 0) W >< en v OI a)!LL ,IL d > lL�(1' Q'Q �'I «, of O'a C,I � ;O'iU'N vCLL C C CIN a)! c (0 0 0'' � LL'� N OLL o� �,�', rnf0 y'00 (0 0. w c'NIOIm LL t'Z diLLl�'I�'EU lad x rnXLc!a)1cu) m e cj_! ac,m a �''rn ly Z O m ,t'' c) XELI C 01Ora cl) � y0 c , �°0 c(/1 d E,u � d rnl e8,m -5.,z o E �'c!c a), ea ea w ca ca �� ZI V� a'174'g'I,(?1��aci °o a' c a�i � V) co 2,.'U > ' E.' a) U o ;,�•� of d -I c O'K,S Q �' y! to o,. 14.0 1 ~ 0! F. SmKo,_oti, 1Z RESOURCES: Beg. Net Working Capital Receipts: Security & Traffic Reimb Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Donations Interfund Contract Total Receipts Transfers In General Fund Transient Room Tax Welcome Center County Fair (619) F & E Reserve (617) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfer to Reserve Fund (617) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data Six Months Ended December 31, 2009 Year to Date Budget _ Actual Variance FY % Coil. % $ 75,000 $ 42,232 $ (32,768) 100% 56% 12,000 1,670 1,150 600 222,800 998 32,000 2,000 80,000 3,540 124 142,589 87 12,037 1,170 33,282 3,420 25,000 3,300 (12,000) 1,870 (1,026) (600) (80,211) (911) (19,963) (2,000) 1,170 (46, 718) 21,580 3,300 356,638 99,000 11,383 80,000 147,421 337,804 769,442 412,344 265,662 73,035 50% 0% 50% 89% 50% 50% 0% 50% 26% 50% 4% 50% 21% 50% 0% 50% 3% 50% 14% 50% 29% 50% 50% 5% nla 0% 221,129 (135,509) 50% 21% 98,960 (40) 11,382 (1) 80,000 - 30,000 (117,421) 220,342 (117,462) 483,703 (285,739) 386,568 222,819 73,035 50% 50% 50% 50% 50% 50% 50% 100% 15% a) nla c) Year End Budget Projection Variance $ 75,000 $ 42,232 $ (32,768) 12,000 4,000 2,300 1,200 540,000 2,000 58,000 7,000 45,000 235,000 86,420 45,000 5,871 1,274 600 471,173 1,088 44,037 5,000 46,170 188,282 113,000 3,300 45,000 (12, 000) 1,371 (1 )26) (300) (68, 327) ( 312) (13,'363) (2,!)00) 1, 70 (46,:'18) 26,: X80 3,:: 00 1,037,920 924,795 (113,125) 197,919 22,765 80,000 197,421 498,105 50% 30% 1,611,025 25,776 50% 42,843 50% (0) 50% - 50% - 50% - 50% Exp. 3/0 47% 824,769 42% b) 531,604 63% 116,188 0% 100 0% c) 16,412 nla 121,952 197,919 22,765 80,000 85,118 (112,3)3) 76,946 76,916 462,748 (35,3 57) 1,429,775 (181,2:50) 798,951 25,8' 8 514,635 16,9E 9 116,188 - 1(0 16,4'' 2 121,9(.2 751,041 682,422 68,619 50% 42% 1,611,025 1,429,774 181,251 18,401 (198,720) (217,121) a) Transfer from Annual County Fair fund will be $112,303 less than budgeted. b) It is likely that M & S will be less than what is currently projected. c) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund. Accrued Revenue (Accounts Receivable): Current Month Events Prior Months Total Accounts Receivable 3,000 18,215 21,215 • 0 Deposits Received for Future Events: 2010: January February March April May June FY 2011 FY 2012 & beyond TOTAL 50'; 2,27, 611 5,87( 4,16( 1,00( 37,79( 5,55(. 57,755 Deschutes County Fair - Fund 619 Revenues and Expenses FAIR 2009 - July 29 to August 1, 2009 Fiscal Year 2010 REVENUES Gate Receipts 400,000 284,806 Carnival 154,000 127,997 Commercial Exhibitors: Outside 70,000 84,395 Inside 38,000 42,700 Food 12,000 13,900 Livestock Entry Fees 4,000 4,951 RN Camping/Horse Stall Rental 17,000 18,102 Concessions: Food 146,850 112,931 - 112,931 77% Fair Sponsorship: Rodeo 23,000 19,350 - 19,350 84% (3,6E0) On -ground Stages 13,000 8,000 8,000 62% (5,000) Day 8,000 5,000 - 5,000 63% (3,000) Golf Carts 2,500 4,125 - 4,125 165% 1,625 Food Court 3,000 3,000 - 3,000 100% - Concert 30,000 30,000 - 30,000 100% Presenting Sponsors 12,000 12,000 - 12,000 100% Barn Sponsors 6,000 3,400 3,400 57% (2,60)) Parade Sponsors 4,800 4,800 N/A 4,800 Transfer In -General Fund 5,000 5,000 - 5,000 100% T -Shirts 3,500 3,725 3,725 106% 225 Donations 1,229 1,229 N/A 1,229 State Grant 25,000 41,963 - 41,963 168% 16,96: Interest 2,000 791 - 791 40% (1,20) 284,806 127,997 84,395 42,700 13,900 4,951 18,102 71% 83% 121% 112% 116% 124% 106% (115,1g4) (26,0)3) 14,395 4,700 1,900 9`i1 1,102 (33,919) TOTAL REVENUES 974,850 832,165 832,165 85% (142,685) EXPENSES Personnel 178,128 181,800 181,800 102% (3,672) Materials and Services 623,444 590,538 - 590,538 95% 32,90E Contingency 31,157 - - - 0% 31,157 TOTAL EXPENSES 832,729 772,338 772,338 93% 60,391 Net Fair - 2009 142,121 59,827 59,827 (82,294) Transfer to Fund 618 197,421 30,000 55,118 85,118 112,303 Retained in Annual Fair Fund (55,300) 29,827 (55,118) (25,291) 30,009 Beg Net Working Capital 55,300 25,291 25,291 Ending Balance 55,118 (55,118) (0) (0.00) Actual - Through FY 2010 Budget December 31, 2009 Additional Estimated Projected Total % of Budget Varian 3e REVENUES Gate Receipts 400,000 284,806 Carnival 154,000 127,997 Commercial Exhibitors: Outside 70,000 84,395 Inside 38,000 42,700 Food 12,000 13,900 Livestock Entry Fees 4,000 4,951 RN Camping/Horse Stall Rental 17,000 18,102 Concessions: Food 146,850 112,931 - 112,931 77% Fair Sponsorship: Rodeo 23,000 19,350 - 19,350 84% (3,6E0) On -ground Stages 13,000 8,000 8,000 62% (5,000) Day 8,000 5,000 - 5,000 63% (3,000) Golf Carts 2,500 4,125 - 4,125 165% 1,625 Food Court 3,000 3,000 - 3,000 100% - Concert 30,000 30,000 - 30,000 100% Presenting Sponsors 12,000 12,000 - 12,000 100% Barn Sponsors 6,000 3,400 3,400 57% (2,60)) Parade Sponsors 4,800 4,800 N/A 4,800 Transfer In -General Fund 5,000 5,000 - 5,000 100% T -Shirts 3,500 3,725 3,725 106% 225 Donations 1,229 1,229 N/A 1,229 State Grant 25,000 41,963 - 41,963 168% 16,96: Interest 2,000 791 - 791 40% (1,20) 284,806 127,997 84,395 42,700 13,900 4,951 18,102 71% 83% 121% 112% 116% 124% 106% (115,1g4) (26,0)3) 14,395 4,700 1,900 9`i1 1,102 (33,919) TOTAL REVENUES 974,850 832,165 832,165 85% (142,685) EXPENSES Personnel 178,128 181,800 181,800 102% (3,672) Materials and Services 623,444 590,538 - 590,538 95% 32,90E Contingency 31,157 - - - 0% 31,157 TOTAL EXPENSES 832,729 772,338 772,338 93% 60,391 Net Fair - 2009 142,121 59,827 59,827 (82,294) Transfer to Fund 618 197,421 30,000 55,118 85,118 112,303 Retained in Annual Fair Fund (55,300) 29,827 (55,118) (25,291) 30,009 Beg Net Working Capital 55,300 25,291 25,291 Ending Balance 55,118 (55,118) (0) (0.00) DESCHUTES COUNTY - ANNUAL FAIR Budgeted and Actual Materials and Services Fair 2009 Medical Contract Public Information Temporary Help - Office Temporary Help - Labor Transportation Internal Service - Admin Svcs Internal Service - BOCC Internal Service - Finance Internal Service - Legal Internal Service - Personnel Internal Service - IT Internal Service - IT Reserve Food Booth Cash Control Gate Receipts Cash Control Major Entertainment Grounds Entertainment Open Class Rodeo Security Water & Sewer Portable Sanitation Garbage Grounds Upkeep, Landscape Building Repair & Maintenance Vehicle & Equipment R & M Maintenance Agreements Copy Machine Rental Equipment Rental Membership & Dues Conferences & Seminars Software Licenses Insurance Premiums Telephone Cellular Announcements Promotion Advertising Printing Travel Refunds and Adjustments Premiums -Other (Over) / Short Contributions (Buckaroo Breakfast) Custodial supplies General supplies Postage Queen Court Demo & Program supplies Bldg/Grounds R & M Supplies Safety supplies Shop supplies Straw & Hay Electricity Gas/Oil/Diesel Heating Oil/Propane Natural Gas Signage Non -Office Furniture & Fixtures TOTAL 9,500 9,735.00 14,600 15,335.61 334.00 15,000 14,401.51 25,000 24,708.99 9,000 9,114.15 4,130 4,216.00 3,421 3,863.00 4,274 4,790.50 7,343 7,993.00 1,622 1,808.00 16,461 18,666.00 2,253 2,282.50 4,400 4,400.00 12,000 19,384.89 (7,384.89) 122,500 119,323.11 3,176.89 34,000 31,650.00 2,350.00 26,000 27,206.00 (1,206.00) 60,000 49,269.00 10,731.00 45,000 45,801.38 (801.38) 2,000 2,000.00 3,000 2,780.00 220.00 4,000 2,195.00 1,805.00 3,500 3,500.00 2,000 3,536.65 (1,536.65) 45.00 (45.00) 500 118.30 381.70 500 597.44 (97.44) 52,000 35,238.27 16,761.73 1,300 1,285.00 15.00 600 445.00 155.00 500 500.00 39,190 39,511.50 (321.50) 2,000 788.45 1,211.55 800 804.09 (4.09) 2,671.93 (2,671.93) 19,000 14,530.00 4,470.00 - 1,200.00 (1,200.00) 4,000 7,017.70 (3,017.70) 1,550 1,956.63 (406.63) 1,500 1,500.00 20,000 20,000.00 - 300 (49.10) 349.10 1,000.00 (1,000.00) 6,000 3,894.80 2,105.20 2,500 2,886.97 (386.97) 1,800 1,372.17 427.83 1,500 982.90 517.10 500 413.92 86.08 2,000 3,430.96 (1,430.96) 400 400.00 300 89.00 211.00 8,000 8,167.00 (167.00) 17,000 12,217.15 4,782.85 6,000 1,552.79 4,447.21 500 139.13 360.87 1,800 1,797.17 2.83 400 411.76 (11.76) 3,227.69 (3,227.69) (235.00) (735.61) (334.00) 598.49 291.01 (114.15) (86.00) (442.00) (516.50) (650.00) (186.00) (2,205.00) (29.50) 623,444 590,537.91 32,906.09 Actual - Through FY 2010 Budget December 31, 2009 (Over)/Under 9,500 9,735.00 14,600 15,335.61 334.00 15,000 14,401.51 25,000 24,708.99 9,000 9,114.15 4,130 4,216.00 3,421 3,863.00 4,274 4,790.50 7,343 7,993.00 1,622 1,808.00 16,461 18,666.00 2,253 2,282.50 4,400 4,400.00 12,000 19,384.89 (7,384.89) 122,500 119,323.11 3,176.89 34,000 31,650.00 2,350.00 26,000 27,206.00 (1,206.00) 60,000 49,269.00 10,731.00 45,000 45,801.38 (801.38) 2,000 2,000.00 3,000 2,780.00 220.00 4,000 2,195.00 1,805.00 3,500 3,500.00 2,000 3,536.65 (1,536.65) 45.00 (45.00) 500 118.30 381.70 500 597.44 (97.44) 52,000 35,238.27 16,761.73 1,300 1,285.00 15.00 600 445.00 155.00 500 500.00 39,190 39,511.50 (321.50) 2,000 788.45 1,211.55 800 804.09 (4.09) 2,671.93 (2,671.93) 19,000 14,530.00 4,470.00 - 1,200.00 (1,200.00) 4,000 7,017.70 (3,017.70) 1,550 1,956.63 (406.63) 1,500 1,500.00 20,000 20,000.00 - 300 (49.10) 349.10 1,000.00 (1,000.00) 6,000 3,894.80 2,105.20 2,500 2,886.97 (386.97) 1,800 1,372.17 427.83 1,500 982.90 517.10 500 413.92 86.08 2,000 3,430.96 (1,430.96) 400 400.00 300 89.00 211.00 8,000 8,167.00 (167.00) 17,000 12,217.15 4,782.85 6,000 1,552.79 4,447.21 500 139.13 360.87 1,800 1,797.17 2.83 400 411.76 (11.76) 3,227.69 (3,227.69) (235.00) (735.61) (334.00) 598.49 291.01 (114.15) (86.00) (442.00) (516.50) (650.00) (186.00) (2,205.00) (29.50) 623,444 590,537.91 32,906.09 Q) > CO CO 737 c E u_ U CO O O N LL O O N LL Lo CO ti O CT .71- O Ln O r O CO M LL) of CO r 0) O O r O O O In O Ln Ct in M CT I� N O M Lo N r N r 0 CO M M r r r CO O I` Lo r N r Ln Ln M r 0 0) O O O 0) Ln O M N CO 0) O N CO O O CT 6) r O CO CO 1� O N 0 N. O O N O) CY) r Ln r co Cn N r r Lo �t N r r r O O r c a) a) 4 o co L) in c 44'0OLoNCAON0 .0 • O) O) to N 4 to ti N. 4- CO O O M CO CD N I` N- • e- r r ✓ 0 't O Ln O I� O In M O M 0) O CO Ln O Ln CO CO N O Ln O COOti NCoc C)'- O tOn cri M L[) .4- N COO CD "I- • r r r r O CO Ln O d M CO Ln N. CD M O Ln M O O O r O r Ln CO Lo r 0 CD CO O ti Ln r 0 Ln CO CO CO O r Lfi O ti r Lfi O r CO M CO Lo Ln Ln Ct) Ln r CD CO '1- r r r CV O r Lo Cn CO Lo co CO CO O 00 OOOI�4OMMOLnLnOO NO [t Nr CO O MLn ti O Ln o O M c Ln Ln 1- Lo CO N Ln Lo M M r N co M r r r CO N N M M Lo N O r r 0 e- V) M CO r CO N Cr) In O r 0 0 CO Ln ti 4 O t` CO N- r r r of O CT ✓ O Ln N Ln M M N to r to M C r co I- M M r r r N ti In N O r N Q) O O O M Cf) Od LI" 0NCOt(OOD)0O M I` M N L[7 CO C7) M In N M O Q) O O CV C6 NO O O) r O) r In CCV M D) C) r 0 C) CO r Ln ti r CO M Ln Ln O In O r co s- 14) Ln N O) r CO r CD Is N CO ti co O M O O M co co 4 Ln Ln f- Q) O ti O Ln O MON O N N CP r r O) N- r r NC`9rr000C�)0 COO O M r 0 CO O) CO Ln Ln M VI '4 N 0 N O CO ' O r ' r O CO- Lo N CO Co O ti M r CM 0 e- N CO M C • r w O N N u a _a U) x ' , r W c w c m n m To M •5 E N LL c C, fn Z o c Y .a 'N c rn W "Ca d aD o E gi a.)n co E W as c ifs o >> o'Ca� IXOWOO j04OL.L..I- State Grant O O ti O CO CO N CO Of O 0 1 N CO O 1 N CO CC N r T O T CO M CV1 O Q) O o0 N O) O L1) co, M O O co W Z W ci)w c 8 I .�o Lcoa mami 0OH cu c 2 EXPENDITURES: O M O Ln O ▪ 0)) ✓ Ln Ln O in CO COO 03 ✓ ti Q) CO CO CO I- ti r coO N- LOn O) d O N Ln CD CO • CD N M CO N Lo I` r coO A'- • CO CO eN- Ln N Lf) ✓ CO CA O CO CO CO co CO co M M N ti 1` et M ti M O) ti O O O 0 o N O Lf) CA O N Lf) ti CO N Lf) M co O O M O ti ti N n Co; O O CO co O co ✓ r ti ti ✓ r O 00 lOn O Ln O CV CD 03 0 CO r N O co co O O • 03 N N • 0 r CO O o O r CO N .t co ▪ L• O O 4. N co Gross Profit Transfer to Fair & Expo Fund Q) O NZ. N CO O N 0 CV co O N LO COO O ti oo O O co co 1` TOTAL EXPENDITURES Retained in Annual Fair Fund Assets Cash Accrued revenue DESCHUTES COUNTY Annual County Fair (Fund 619) Balance Sheet December 31, 2009 $ 56,318 Total Assets $ 56,318 Liabilities Deferred Revenue (Fair 2010) Transfer to Fund 618 $ 1,200 55,118 Total Liabilities 56,318 Fund Balance Fund Balance Total Liabilities and Fund Balance 56.318 The "Fair Year" is January 1 through December 31. RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service (Negative Int Rev) TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County Bethlehem Inn (Fund 128) Six Months Ended December 31, 2009 Year to Date Budget Actual Variance FY % Coll. % $(2,666,469) $(2,689,172) $ (22,703) 100% 101% a) $(2,666,469) $(2,689,172) $ (22,703 2,766,469 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) 42% 0% 2,766,469 100,000 (2,689,172) (2,789,172) 42% -2689% Exp. % - (2,766,469 - (2,766,469, 100,000 (2,689,172) (2,789,172) 100,000 19,679 80,321 42% 20% b) 100,000 45,000 55,000 100,000 19,679 80,321 42% 20% - (2,708,850) (2,708,850) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) December interest expense was $2,525.68. 100,000 45,000 55,000 - (2,734,172) (2,734,172) Year End Budget Projection Variance $(2,666,469) $(2,689,172) $ (22,703) 100% 101% a) $(2,666,469) $(2,689,172) $ (22,703 2,766,469 2,766,469 - (2,766,469) 42% 0% 2,766,469 - (2,766,469) 42% 0% 2,766,469 100,000 (2,689,172) (2,789,172) 42% -2689% Exp. % - (2,766,469 - (2,766,469, 100,000 (2,689,172) (2,789,172) 100,000 19,679 80,321 42% 20% b) 100,000 45,000 55,000 100,000 19,679 80,321 42% 20% - (2,708,850) (2,708,850) a) The beginning working capital is $22,703 less than estimated for the FY 2010 budget. b) December interest expense was $2,525.68. 100,000 45,000 55,000 - (2,734,172) (2,734,172) Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2010 Tammy Baney Conf/Sem & Educ/Training Travel Meals Accommodations Airfare 350 - 350 15 20 90 125 595 - 595 Mileage reimbursement - 256 86 573 299 396 1,610 Ground Transport/Parking Total Baney 256 86 1,578 319 486 2,725 45 - 45 Dennis Luke Conf/Sem & Educ/Training - 350 - 220 570 Travel Meals 25 - 25 113 25 189 Accommodations - 77 - 452 77 77 683 Airfare Mileage reimbursement 329 85 257 485 210 1,367 Ground Transport/Parking - - 34 - 34 Total Luke 432 85 1,118 676 532 2,842 Alan Unger Conf/Sem & Educ/Training - 350 - - 350_ Travel Meals - Accommodations 624 - 65.1 1,276 Airfare - - - Mileage reimbursement - - 978 978 Ground Transport/Parking - - 56 - 75 131 Total Unger 1,031 1,704 2,735 Total - BOCC Department Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage Reimbursement Ground Transport - 700 - 220 1,270 25 - 40 133 115 314 77 - 1,046 77 77 2,553 585 172 831 784 606, 3,956 79 ' - 210 Total - BOCC Department 687 172 2,696 995 1,018 8,302 FY 2010 Budget 22,750 Percent Expended 36.5% 12/30/200' YTD Jul Aug Sep Oct Nov Dec Total 350 - 350 15 20 90 125 595 - 595 Mileage reimbursement - 256 86 573 299 396 1,610 Ground Transport/Parking Total Baney 256 86 1,578 319 486 2,725 45 - 45 Dennis Luke Conf/Sem & Educ/Training - 350 - 220 570 Travel Meals 25 - 25 113 25 189 Accommodations - 77 - 452 77 77 683 Airfare Mileage reimbursement 329 85 257 485 210 1,367 Ground Transport/Parking - - 34 - 34 Total Luke 432 85 1,118 676 532 2,842 Alan Unger Conf/Sem & Educ/Training - 350 - - 350_ Travel Meals - Accommodations 624 - 65.1 1,276 Airfare - - - Mileage reimbursement - - 978 978 Ground Transport/Parking - - 56 - 75 131 Total Unger 1,031 1,704 2,735 Total - BOCC Department Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage Reimbursement Ground Transport - 700 - 220 1,270 25 - 40 133 115 314 77 - 1,046 77 77 2,553 585 172 831 784 606, 3,956 79 ' - 210 Total - BOCC Department 687 172 2,696 995 1,018 8,302 FY 2010 Budget 22,750 Percent Expended 36.5% 12/30/200' RV Park (Fund 601) Statement of Financial Operating Data Six Months Ended December 31, 2009 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) Reven ues RV Park Fees < 31 Days 79,290 50,240 (29,050) 50% 32% a) 158,580 128,580 (30,000) RV Park Fees > 30 Days - 7,150 7,150 50% n/a a) - 7,150 7,150 Washer / Dryer 400 732 332 50% 91 % 800 800 - Vending Machines 266 266 50% n/a 266 266 City of Redmond 500 500 50% n/a 500 500 Interest on Investments 150 218 68 50% 73% 300 250 (50) Cancellation Fees 602 602 50% n/a 602 602 Total Revenues 79,840 59,707 (20,133) 50% 37% 159,680 138,148 (21,532) Transfers In -Fund 130 160,000 160,000 - 50% 84% 190,000 190,000 TOTAL RESOURCES 289,840 222,138 (67,702) 50% 56% 399,680 330,579 09,101) REQUIREMENTS: Expenditures Exp. % Materials & Services 34,380 38,780 (4,400) 50% 56% 68,760 68,760 Debt Service 121,286 157,883 (36,597) 50% 65% 242,571 242,571 Contingency 44,175 - 44,175 50% n/a 88,349 88,349 TOTAL REQUIREMENTS 199,841 196,663 3,178 50% 49% 399,680 311,331 88,349 NET (Resources - Requirements) 89,999 25,476 (64,523) 19,248 19,248 a) Approximately 1,793 space rentals. ( $50,240+ $7,150) / $32 = 1,793) Year End Budget Projection Valiance RESOURCES: Beg. Net Working Capital $ 50,000 $ 2,431 $ (47,569) 100% n/a $ 50,000 $ 2,431 $ (47,569) Reven ues RV Park Fees < 31 Days 79,290 50,240 (29,050) 50% 32% a) 158,580 128,580 (30,000) RV Park Fees > 30 Days - 7,150 7,150 50% n/a a) - 7,150 7,150 Washer / Dryer 400 732 332 50% 91 % 800 800 - Vending Machines 266 266 50% n/a 266 266 City of Redmond 500 500 50% n/a 500 500 Interest on Investments 150 218 68 50% 73% 300 250 (50) Cancellation Fees 602 602 50% n/a 602 602 Total Revenues 79,840 59,707 (20,133) 50% 37% 159,680 138,148 (21,532) Transfers In -Fund 130 160,000 160,000 - 50% 84% 190,000 190,000 TOTAL RESOURCES 289,840 222,138 (67,702) 50% 56% 399,680 330,579 09,101) REQUIREMENTS: Expenditures Exp. % Materials & Services 34,380 38,780 (4,400) 50% 56% 68,760 68,760 Debt Service 121,286 157,883 (36,597) 50% 65% 242,571 242,571 Contingency 44,175 - 44,175 50% n/a 88,349 88,349 TOTAL REQUIREMENTS 199,841 196,663 3,178 50% 49% 399,680 311,331 88,349 NET (Resources - Requirements) 89,999 25,476 (64,523) 19,248 19,248 a) Approximately 1,793 space rentals. ( $50,240+ $7,150) / $32 = 1,793) U C 0 0 0 % Occupancy % Occupancy -14 M Co 69 > cn CC a) U.. RV Park Fees 0 0 0 O)coCON O CO O N O N r rMCO�d)0 r) CD~ O I` M N M t.. COO a CCOOCOO N 0 CO d O) O) CO N M N.< -- COON h• in 0 0 0 0 0 0 0 0 0 0 0 0 0 Ocod �OOOOMtnr-NSM CO COO CO COct(0.- NIn COO 4606uir-0004t•ONI` O CO N r- M d) 0 0) r- O O CO M CO r- N N S r- N N•ctCOvtNCOCOCOCOd NOON Cf) ' O) V M r- O N CO CO M M O r CO d' Cfl r- O O O O o CD r I� ti M h N 47 0 0 0 0 0 0 0 0 0 0 0 0 0 N Cfl ti CO CO O O I's- M In o1 CO r-- O d: O to vk M I- O CO N r- O O N O) O) o) N OCOOOI's s- 10MNv- NO CO NCONtiM �MOMMCOCO T- M O)_ 7 CO 7 m to C C3) C a) Co II • N O • 6F1 CC) j O oco cc ' O- M . 0 05 0. LO N1.- a) 7 'L7 0) a) C +. CCS C .0 O ' O M CO CO N O CO CO CO o) COa) r - M M .— CO M CO CC) N MT- CO M CO 0 CO O OO(')N� `70(0(00),rO 0) M N O N r - N O) O) d II y CO, r N TO ✓ o 00)j W l() N 8 ea C*) CD U O) E c a)>roa) 4 cu)c-— V _ N 7 O CoU Co .0 0 V M > O 0 Ili Co 'C7 6 l i i E E E ca?-.' 00 69 R) 7 p a) a) O L U a) L r- r-- 3 0 2 >, C7) 0.... > 0 c .0 �- 'C >, C 0 O to N Building Services - 620 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 272,938 $ 439,838 $ 166,900 100% nta Revenues Cleaning/Maintenance 42,738 30,884 (11,854) 50% Utility Reimbursement 4,500 2,549 (1,951) 50% Facilities Charge to State 68,232 67,500 (732) 50% Miscellaneous 24 24 50% Interest on Investments 5,000 3,752 (1,248) 50% Building Svcs Indirect Chgs 872,641 872,645 50% Total Revenues 993,110 977,354 415,760) 50% Transfers In 111,422 93,422 (18,000) 50% TOTAL RESOURCES 1,377,470 1,510,614 133,140 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Budget Year End Projection Variance $ 272,938 $ 439,838 $ 166,900 36% 85,475 85,475 28% 9,000 9,000 49% 136,464 136,464 n/a 38% 10,000 7,000 50% 1,745,275 1,745,275 (3,000) 49% 1,986,214 1,983,214 42% a) 222,844 222,844 (3,000) 61% 2,481,996 2,645,896 Exp. % 777,158 741,004 36,154 50% 48% 1,554,315 1,554,315 349,841 353,568 (3,727) 50% 51% 699,681 699,681 18,000 18,000 50% 0% a) 36,000 36,000 96,000 96,000 50% 0% 192,000 163,900 192,000 1,240,998 1,094,571 146,427 50% 44% 2,481,996 2,289,996 192,000 136,472 416,042 279,566 - 355,900 355,900 a) None of the $36,000 budgeted transfer from the General Fund has been made. The transfer is for the Capital Outlay expenditures budgeted as: $6,000 for floors at Historic Museum and $30,000 for Phase I of roof on Juvenile building. Admin Services - 625 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY % Coll. % Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $ 120,000 $ 117,586 $ (2,414) 100% n/a $ 120,000 $ 117,586 $ (2,414) Revenues Miscellaneous 41 41 50% n/a Interest on Investments 2,000 1,069 (931) 50% 27% 4,000 2,000 (2,000) Admin Dept Indirect Chgs 346,148 346,163 15 50% 50% 692,295 692,295 Total Revenues 348,148 347,272 (875) 50% 50% 696,295 694,295 (2,000) Transfers In -General Fund 20,000 20,000 - 50% 50% 40,000 40,000 TOTAL RESOURCES 488,148 484,858 (3,289) 50% 57% 856,295 851,881 (4,414) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. % 319,518 314,359 5,159 50% 49% 74,972 55,502 19,470 50% 37% 50 50 50% 0% 33,608 33,608 50% 0% 639,036 149,943 100 67,216 639,036 149,943 100 67,216 TOTAL REQUIREMENTS 428,148 369,861 58,287 50% 43% 856,295 788,979 67,316 NET (Resources - Requirements) 60,000 114,998 54,998 62,902 62,902 BOCC - 628 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY % Coll. % Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $ 50,000 $ 68,511 $ 18,511 100% nla $ 50,000 $ 68,511 $ 18,511 Revenues Sale Map Photo or Copies 50 30 Interest on Investments 250 713 Admin Dept Indirect Chgs 286,709 286,709 (20) 50% n/a 100 100 463 50% n/a 500 1,000 500 - 50% 50% 573,417 573,417 TOTAL RESOURCES 337,009 355,962 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 18,954 50% 57% 624,017 643,028 19,011 Exp. %, 245,078 243,749 1,329 50% 50% 490,156 490,156 37,124 28,381 8,743 50% 38% 74,247 74,247 50 50 50% 0% 100 100 29,757 29,757 50% 0% 59,514 59,514 TOTAL REQUIREMENTS 312,009 272,131 39,878 50% 44% 624,017 564,403 59,614 NET (Resources - Requirements) 25,000 83,832 58,832 - 78,625 78,625 Finance - 630 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY % Coll. Budget Year End Projection k ariance RESOURCES: Beg. Net Working Capital $ 740,000 $ 777,692 $ 37,692 100% n/a $ 740,000 $ 777,692 $ 37,692 Revenues Investment Fee 47,500 46,331 (1,169) 50% 49% 95,000 93,000 (2,000) Photo copies 47 47 50% n/a 47 47 Interest on Investments 9,000 5,177 (3,823) 50% 29% 18,000 10,000 (8,000) Interfund Contracts 14,000 14,004 4 50% 50% 28,000 28,000 Administrative Fee 6,000 6,000 - 50% 50% 12,000 12,000 Finance Dept Indirect Chgs 358,211 358,218 7 50% 50% 716,422 716,422 Total Revenues 434,711 429,778 (4,933) 50% 49% 869,422 859,469 (9,953) TOTAL RESOURCES 1,174,711 1,207,470 32,759 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 75% Exp. % 1,609,422 1,637,161 27,739 411,206 409,561 1,644 50% 50% 822,411 822,411 177,243 201,462 (24,219) 50% 57% 354,486 354,486 40,000 40,000 50% 0% 80,000 80,000 176,263 176,263 50% 0% 352,525 352,525 TOTAL REQUIREMENTS 804,711 611,023 193,688 50% 38% 1,609,422 1,176,897 432,525 NET (Resources - Requirements) 370,000 596,446 226,446 460,264 460,264 Legal - 640 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date 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 150 6 (145) 50% 2% 300 300 Miscellaneous 1,500 (1,500) 50% 0% 3,000 3,000 Interest on Investments 750 970 220 50% 65% 1,500 1,500 Interfund Contract 1,000 4,400 3,400 50% 220% 2,000 4,400 2,400 Legal Counsel Indirect Chgs 349,955 349,955 - 50% 50% 699,907 699,907 Total Revenues 353,355 355,330 1,975 706,707 709,107 2,400 Budget Year End Projection V3riance $ 87,000 $ 102,125 $ 15,125 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 440,355 457,455 17,100 50% 58% 793,707 811,232 17,525 Exp. % 337,517 331,606 5,911 50% 49% 675,034 675,034 27,126 21,100 6,026 50% 39% 54,252 54,252 50 50 50% 0% 100 100 32,161 32,161 50% 0% 64,321 64,321 TOTAL REQUIREMENTS 396,854 352,706 44,148 50% 44% 793,707 729,286 64,421 NET (Resources - Requirements) 43,501 104,749 61,248 81,946 81,946 Personnel - 650 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY % CoII. % Budget Year End Projection Varance RESOURCES: Beg. Net Working Capital $ 360,525 $ 423,562 $ 63,037 100% n/a $ 360,525 $ 423,562 $ 63,037 Revenues Miscellaneous 250 917 667 50% 183% 500 917 417 Interest on Investments 2,000 3,206 1,206 50% 80% 4,000 6,000 2,000 Personnel Indirect Chgs 316,471 316,479 9 50% 50% 632,941 632,941 Total Revenues 318,721 320,602 1,882 50% 50% 637,441 639,858 2,417 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 679,246 744,165 64,919 997,966 1,063,420 65,454 Exp. % 291,930 281,008 10,921 50% 48% 583,859 583,859 168,004 63,200 104,804 50% 19% 336,007 336,007 50 50 50% 0% 100 100 39,000 39,000 50% 0% 78,000 78,000 TOTAL REQUIREMENTS 498,983 344,208 154,775 50% 34% 997,966 919,866 78,100 NET (Resources - Requirements) 180,263 399,956 219,694 143,554 14.3,554 Information Tech - 660 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY%J Coll.% RESOURCES: Beg. Net Working Capital $ 437,214 Revenues City of Redmond Miscellaneous 500 Interest on Investments 6,000 I T Indirect Chgs 955,038 Total Revenue 961,538 Transfers In -General Fund 32,501 Budget Year End Projection Vat lance $ 538,155 $ 100,941 100% nia $ 437,214 $ 538,155 $ 100,941 4,265 955,032 959,297 (500) (1,735) (6) (2,241) 50% nla 50% 50% 50% 50% 0% 36% 50% 50% 32,500 (1) 50% 50% TOTAL RESOURCES 1,431,253 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 1,529,952 98,699 50% 63% Exp. % 864,790 849,008 15,782 50% 49% 251,114 177,118 73,996 50% 35% 50 50 50% 0% 96,692 96,692 50% 0% 1,212,646 1,026,126 186,520 50% 42% NET (Resources - Requirements) 218,608 503,826 285,219 1,000 12,000 1,910,076 1,000 8,000 (4,000) 1,910,076 1,923,076 1,919,076 (4,000) 65,001 65,001 2,425,291 2,522,232 96,941 1,729,580 1,729,580 502,227 502,227 - 100 100 193,384 1413,384 2,425,291 2,231,807 1S3,484 290,425 290,425 IT Reserve - 661 Statement of Financial Operating Data Six Months Ended Dectember 31, 2009 Year to Date Budget Actual Variance FY Coll. Budget Year End Projection Variance RESOURCES: Beg. Net Working Capital $ 350,938 $ 373,691 $ 22,753 100% nia $ 350,938 $ 373,691 $ 22,753 Revenues Interest 1,000 3,117 2,117 50% 156% 2,000 6,000 4,000 IT Reserve Charges 117,000 117,005 5 50% 50% 234,000 234,000 Total Revenue 118,000 120,122 2,122 50% 51% 236,000 240,000 4,000 TOTAL RESOURCES 468,938 493,813 24,875 50% 84% 586,938 613,691 26,753 REQUIREMENTS: Expenditures Materials and Services Capital Outlay Contingency Exp. % 189,995 19,906 170,089 50% 5% 379,990 379,990 63,000 63,000 50% 0% 126,000 126,000 40,474 40,474 50% 0% 80,948 t 0,948 TOTAL REQUIREMENTS 293,469 19,906 273,563 50% 3% 586,938 505,990 80,948 NET (Resources - Requirements) 175,469 473,906 298,437 107,701 107,701