Loading...
2010-2932-Minutes for Meeting November 01,2010 Recorded 11/16/2010DECHUTES COUNTY OFFICIAL BLANKENSHIP, IONERS' COUNTY COMMISS IIIt11111111111 -ZRECORDS CJ ?10 .1931 111111111 II CLERK 111161201011:37:52 AM Do not remove this page from original document. Deschutes County Clerk Certificate Page 4 6 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, NOVEMBER 1, 2010 Present were Commissioners Dennis R. Luke, Tammy Baney and Alan Unger. Also present were Dave Kanner, County Administrator; Marty Wynne, Finance; Erik Kropp, Deputy County Administrator; Dave Inbody, Assistant to the Administrator; Hillary Borrud of The Bulletin; and two other citizens. Chair Luke opened the meeting at 1:30 p.m. 1. Tax/Finance Update. Marty Wynne explained the budgetary reasons why the County has not had to have huge layoffs even though revenue has been down for a long time. (He referred to a handout, a copy of which is attached for reference) Health Benefits and PERS costs went down; however, some reserves were drawn down to make this happen. The transfers out are not up, which has to do with holding the line on costs. He then discussed the foreclosure revenue from fiscal year 2010-11. Some of the figures are notices of default, which may or may not result in foreclosures. The high foreclosure level does not bode well for the coming year. The average yield is 0.87, the same as the previous month. The investment pool dropped to 0.50 for the first time in a long time. Mr. Wynne said that the estimate increase in property values this year was set at 2.2% but it came in at just I%. The amount was conservative, but does impact the budgeting process. The Health Benefits trust has been on a roller coaster this fiscal year, with a lot of expense in July, but a low amount of costs the last month, resulting with the overall amount just 1.3% more than last year. The capital construction projects have come in under budget. Minutes of Board of Commissioners' Work Session Monday, November 1, 2010 Page 1 of 4 Pages Commissioner Luke asked about the Humane Society of Redmond's request for additional financial assistance. He feels this should probably be handled directly through the County so it is known where it is going. This will be discussed at a future date. 2. Update on Spay/Neuter Grant Program. The Commissioners indicated they would contribute to the amount collected up to $5,000, as done in previous years. 3. Economic Development Grant Summary/Requests. . La Pine Christmas Basket Association - $59000 Commissioner Luke feels this is similar to "Shop with a Cop", and asked whether there is a different funding source for this type of program. Dave Kanner stated that the Board always has the option of using general fund contingency dollars for this. Commissioner Unger feels this involves direct services to people. Commissioner Baney said that they received $2,500 last year, and the Food Bank and others have gotten funding throughout the year. The Commissioners agreed that $2,500 was appropriate. Cloverdale Volunteer Fire Fighters Association - Thermal Imaging Camera -$5,150 All of the Commissioners granted $500 each. Cat Rescue, Adoption & Foster Team - Targeted Areas Trap and Alter Project - $5,323.64 The Commissioners asked Mr. Kanner to develop a plan for a fund to address community pet spay and neuter needs, and bring that to them on Wednesday. • Pet Evacuation Team - Cargo Trailer - $2,500 The Commissioner felt that the PET could borrow a trailer from the Sheriff's Office, or can apply for grant funds later in the fiscal year, closer to wildfire season. Minutes of Board of Commissioners' Work Session Monday, November 1, 2010 Page 2 of 4 Pages • Central Oregon Police Chaplaincy - $3,000 - Maintaining Operations The Commissioners granted $500 each. Grandma's House - Volunteer Program - $3,300 Woody Medeiros and Vito DiMaio came before the Board and requested funding to help with their volunteer program. Donations are down and more volunteers are needed, so they would like to have additional funding for a volunteer coordinator position. They are fortunate enough to own the property they use. Commissioner Baney said she is cautious about funding operations. There are a lot of other groups that are having a problem with operational expenses. Lottery grant dollars are usually for out of the ordinary costs or special projects. Commissioners Baney granted $1,000; Commissioner Luke granted $1,400; and Commissioner Unger granted $600. The consensus was that it would need to be used for stipends for the overnight volunteers and not for the coordinator position. . Humane Society of Redmond - Commercial Washer & Dryer - $12,000 Commissioner Unger feels this should be addressed with other funding issues the HSR has. Mr. Kanner said they could get the remainder of what is in the optional advance fund and enter into another agreement for an additional amount of money that would be in essence a loan. Commissioner Luke pointed out that they do have an asset in the Teater Trust that eventually will be paid out. Commissioner Unger is worried about their business plan and their inability to deal with fluctuations in their workload. They are burning out their volunteers and making short-sighted decisions. It was determined that the washer and dryer should be part of any negotiated loan. Deschutes Economic Alliance - Economic Roadmap - $25,000 Commissioners Luke and Baney granted $500 each; Commissioner Unger granted $1,000. Minutes of Board of Commissioners' Work Session Monday, November 1, 2010 Page 3 of 4 Pages 4. Update of Commissioners' Meetings and Schedules. None were discussed. 5. Other Items. The Board went into Executive Session at this time, under ORS 192.660(2)(d), labor negotiations and ORS 192.660(2)(h), litigation. Being no further items discussed, the meeting adjourned at 3:25 p.m. DATED this Deschutes County ATTEST: Day of L 2010 for the Board of Commissioners. Recording Secretary 51;1 -01 Dennis R. Luke, Chair W Alan Unger, Vice Chair /wi Tammy Baney, Commissioner Minutes of Board of Commissioners' Work Session Monday, November 1, 2010 Page 4 of 4 Pages Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, NOVEMBER 1, 2010 1. Tax/Finance Update - Marty Wynne 2. Update on Spay/Neuter Grant Program - Dave Inbody 3. Economic Development Grant Summary/Requests: • La Pine Christmas Basket Association - $5,000 • Cloverdale Volunteer Fire Fighters Association - Thermal Imaging Camera -$5,150 • Cat Rescue, Adoption & Foster Team - Targeted Areas Trap and Alter Project - $5,323.64 • Pet Evacuation Team - Cargo Trailer - $2,500 • Central Oregon Police Chaplaincy - $3,000 - Maintaining Operations • Grandma's House - Volunteer Program - $3,300 • Humane Society of Redmond - Commercial Washer & Dryer - $12,000 4. Update of Commissioners' Meetings and Schedules 5. Other Items Executive Session, under ORS 192.660(2)(d), labor negotiations PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), pending or threatened litigation; or ORS 192.660(2) (b), personnel issues Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners ' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. /f you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. v S O r o L OJ N F.1 'o 0 0 O -v Z N . E c a ~ N X C Q c` N C ® a ~ ~ v G1 0 M N O N G L r V a) N U) co O L UO 0 0 1` N M O ti CO co ~ M N M Iq N - LO ~ O (D M O0 L O r ~ LL Id_ 1 1 .he o LO LO LO LO O U M LO O O Go N 00 O O ~ le = CO r- 1~ C \f >m N N N co LL U N as L s N E L (D CO AA`` W O 75 :3 Q (n U 0 O 3 L s C1 0 N ti ni N O L Q co = V M d D LO O LO LO LO O r ~ ~ v- LO CD N co 00 UO Iq LO N M co It M LO O LL Z 1 O O O 0 LO LO UO 00 LO LO M r C) UO N N ";i CM ~ M N LL O U Q~ L ~ s tl L A A 0 Gs ~ ~ O Q cn O O 3 L s r- Q O N L co to w 0 iL di a r r O N L C{i .1" t0 V L U. C 3 LL L ~C W C O W V d d . 0 0 0 0 0 0 0 0 0 L O LO M Cfl O O O O O N O d` It M LO N r Lo N 4 O ^ o o o 0 0 0 0 0 O V 0) T 00 O 0) 0 O L 0 ❑ I-- MNI-- CD N 0)co(D0.4 r e ~ .0. CV m C 7 O Naf-00 fMO)CD CV 00)Oti Re LO (00)(0co N d Vt ~ 0) LO CD 00 It it LO Re ca ❑ 0) O 0 00 O _ P._ 00 C0 Lo CO ~ CD 0 IT O C ~C V M v~ ti C M r c m OOOOit N Ofl- 0)~CD O O M 0) ~ Re ~ LO N Cfl N 'O O (0 P- Ln (0 M IRT r CO p 0) CO f- LO O m 0) f- N d' M O eq co CA CA N T- CO Iq Cfl ti Ln C2 Lo M ~ N M I- N I- 0) 1. x LL m O N ~Ili LO 1 C \f N N N _ N C C O U) N co co Il- 0) N (fl 00 N LO r C1 0) N 00 00 O T- ~ N O Ln - O LO M CO N O) 00 M D7 L - 0 c CD (fl ti LO 0) Co LO 00 00 LO m N r It LO NMCD LOOI- LO L V Q 'a' r- O M W) 00 M 0 00 0) LL. rl N O N cl T- N CA C N r N L O _ cu C ,A N N (n W U , A co z 21 0 0) N 0 U) w U) N a) > X> N Y y-+ N O w of a~ H c O N 0 Z Z m m u i , W N a) W (D e co O N CL C (A W O CL 0 W C w L- N ~dCDQU X W m m cn2IL F- Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA November 1, 2010 (1) Monthly Investment Report (2) September 2010 Financials V r C d ~ O N ~ y } v LO CO N 4 ~ Cl) CO "t N P ti P N o } N m H n 00 W E CO O C O M M C'M O Q O N fA tR M M co M ac O P P N N E V Cn M O 0 C O ER eA a7 C E z LL 0 o A > 41 C C C E 7 w C 0 O U 0 Eo 5 A y LO C m 47 d Qj a1 w c ~~E N - E f a y _ c ~ m C ~ !6 H c a) U ~'I e ~ ~ a a ~ a ~ o 0 L' NNNNNNMIO O N O O CO P O P E`r P P N v O CO CO IT O r- M P I- O N M .r . 00 Cl) O 0) 00 CC) CO r- O P r 00 Cl) to O 6) co 6R CO O S C N O N N lD O YL P P P 7v II l1 CD C N CL (n ate) d m(1)a?m•-CL CL - LI o U co 'c C E mZw w m~U ~ C~ tv Q Q F- d c " N a) ` O E Qm~ a)Yo UUH acO~ EO- 0 ~I C ~I 2 C~6 CC a) 0 0 0 0 0 0 0 0 tn Ln Ln o 0 O O V- P P. N N N V- N E CA v 7 E m U) ca Q~0.w a i m e U ca 0 c cmi a o = Co C4 a N O ` o ca ` C6 a) d d C6 a) c m E 0 E V~ C1, o o 11 CO H U U _ N N 77 W C o N Q a C CO m N . A L ¢ N D ` U C O U o x o N w O ~D`~ c C N E CO U Q > A m ~ O N N p ~ o W & O N O Z r ~ U O IL io O F - 00 0 m a LO J o R N o o~CD Oco o °0 ' K 0 Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z m z h • O N N O NOM O z iz~ O O N O Q 0 0 0 0 r- O O O V co N n N o V N O M 0 0 co m f- O (0 N O to O N O Ih N co A c N M O O r Q O If) O f` m 0 0 0 m tO m CO N In C N O M 0 0 0 O CO O CO N O 7 0 N m 0 U7 m 00 M 7 O O 00 M O c + O t- O M M O LO O CO O N CO N t` V r- O M O O M CO c0 Cl LO N O O O N O O O 0 (n 00 (O CO r 0 0 W V m N V V V M M M O 0) W O O N O 10 O LO N 0 co V- O O N M M co co V' O O r` O N M M . d to CD n rn N M O V m W O M m N M Cn M r m rn O n t() Cn ccC' r O m CO O W M O O R E j, 0) M P, M O M O M M N N V N CO V O O f\ N O CD O LO O V N ' CD CO M M O n O M O M M O V to O O V O O N O V M N m N M O N M M M M N O M 0 0 - 0 0 0 0 0 0 O W r- ao co co coo m c0 > 0 _ 0 0 0 ~ C 0 C C C 0 N o0 N N W t` (D O m C > N N N N N N N N N N N N N N N N N N N N N N N N N M to O CO V O N O h N - - N M N O c . H M O o o O V 0 c0 O N O O CO O M n M O O O m 0 0 0 0 0 0 c0 Co O O O O N N 00 N N O O O O m o n O N O CO V O N CO M O O D O 0 0 0 0 0 0 t` M O O 0 O f` 0) W N O o 0 0 N o N o O O M O (O M 0 0 0 CO 0 0 0 0 0 0 r r- o O N 0 CO V N {0 N' N N O W In M U') V CD V O M (O M CO V [D N O O fD N O O ~ co 00 O v CD O c O m CD m m CO M O O V c M " O C'N W N N h O C r O ccO O t` CO N O M M M O 10 c'M O N 10 O 10 c0 M CO O 0 M O N r!') V LO O C. M Co O O M O O V 0) O M O 00 O O N O 0) CO O O (D 0 O O M 0 0 0 0 ~ (D CO n M O Y O O C O O O m C m q 0 0 0 0 CO 0 0 0 0 0 0 0 0 0 0 0 _ W m N N N - N N - N - N N N N N N N N N N N N N N N N N N Cn co v M V O n N O r W 0 0 0 0 0 0 m O O O m O o 0 0 0 0 0 0 0 0 0 0 M 0 0 0 0 0 0 C. N 0 0 0 0 0 0 f` O O O O O O O O O O O O O O O O N O 0 0 0 0 0 0 N O CO O O N O O O O O O P- O O O n O O O O C. O O O O O o 0 m 0 0 0 0 0 0 0 v 00 U w A M O O N O O O V O O 7 000 7' CO O O O o (O O 0 N 0 0 0 O O O O N m M 0 0 0 m 0 0 0 cD CIl M 0 0 0 O M~ O C O m q c ~ O O O Vi O (O M ocN I 10 M n O (b O M O m O M 03 O O O~ M r- o O O M 0 V O rn O M O N O m Lo N C O fD It 1-- 0 0 0 O O _O O V m O O O m CO m 0 0 0 m O V O O M O m 0 0 m r n r0 - O O O O O C_ _ m O O C O m 0 0 0 0 0 0_ _ 0 C_ _ O m 0 M_ _ r O M to m _ _ _ _ _ N ' r r r r N N N N N r N N N N N N N N N N N N N N N N N In CO ~T O M V O O CU U) 40 CO, n - - - - - - - - - CO m - a- v 2 T T ~ 0 v~ ~ e a ~pZw o o a o 0 0 0 o e e o 0 0 0 0 0 0 0 o e o 0 0 0 0 0 0 0 0 0 0 o e e 0 1 mQ >0 O O O O O O O N O 0 0 M O O O O O O O O O O m 0 0 000 a O N O O M C(0 E~R L' N Q O > :2 S O N CO O M M M to co 7 Cn O M M N O O co co O (n O N- O W) n m M M m M (O )n O r N (`1 Co r N O- O- N r N 7 m 00 M V M N O (D O Cb I- m N U 2 O W O O N co 00 n r N O 00 m + . - O) w E O M M - r 0 0 0 O N O O O Y - - 0 0 0 0- 0--- 0 0 0 } m a N F-- N O E C m o 0.9 U) FD 6 - - - - - - - - - LL _ U U ~ 7 LL M -i _ o 0 0 o a o 0 0 0 0 0 0 0 0 0 0 0 0 e o e O O (O M O O O 0 0 0 O to o 0 0 0 0 rn O O O O J d M n r LO Cn O O 0 0 CO Ih 0 M 00 m m N O n N O to CL N M W CO M U W M r M M (O CO n n O N ( c ? q q N c 7 O CO V It - U) CO O o co M 00 M 0 M O O m C U i d N ° N c G F r o m O j m a Ea o c ® N C A c L y O m d 0 co - r C O O A co co V' m (n (O m O o o to r- N (O n r O r- m m co M r co O O m m Cp m d> N Q m O T m cg 0 O r- V h m O O O C -,r 4 V 'C co N V M co N V M t- V V M M M e~ C W) V m r- M m m m V M V) (O W) CO CO t0 W) 7 (O rn V (O to m (o In W) i- n n P, (0 E T 2 N C > I~ N N N N N N 0) > 0 0 0 0 0 0 0 _ '7 0 I~ n m (n m m o m m Cn m m m M r n O M n - - - - A m N N 0 0 0 0 ~ c\ ~ N N O N N N O O N O O O O O N N O N . . r ~ N y w n m m m > U O O O N M M V n m n m o o ~ s EIS - I Lo C CO CO cn m m . co •-•-•-0000o000oooooooooo•-.-~oooooo ¢ m tJ - F-I (a m m m O m m m O m m o m m o m M00000 0 0 0 0 0 0 0 0 0 0 0 R R c y _ ' ' o 0 0 0 0 0 0 o o o 0 0 0 0 t I v U) n n o m m o o m w o o m m h f~ o n n N n fz rz c) (h r~ M V O I t 7 \ O O M\ N\\ N N`\\ O N O\ O N V m m N co h r- n M m N N O M M m M V r- r- m m m m i L O' o O 0 0 0 0 0 0---- 0 0 0 0 0 0 o 0 o o o 0 o o o 0 ¢ U I= LL m co co z> I.- CL LL ¢(L Z Q p ~ _ SmUUu.F-r m mU 2YJa~MfntA7 adAy LL LL U Z Q Q LL Q O F- F- LL F- F Z F- F- ( j L L L L L ( L LL L LL LL LL L U LL F- LL M U U LL logs LLZ LL m a m LL¢LL LL ~Z Z>F-mZ~LL CL ZZLL mmCL ULL LL LL Q N mm U(n(n(n(nY(nCL CL co N3 m3 Sm a E M M N to 0 0 0) N 0 0 rn LO CD m r- t0 0 v M tO Z) r- J ZL-(Dm F- t- vIL z dx r~ O N N M S U N Y m m O Q Z LL LL M F- U F- > ' O Q ' ¢ U V M W cp N X G M CO M m m M M r M M M M 0) M M m M M c) M 6 M M m m M Ni M ~ m M • N 7 j m (y M M M N V 0 m O c) M m m M M Cl) M M Cl) Cl) M co M M m M 'y U C ) , co U CL 2 0 0) c R: m . w CD Y U V U U U O U 7 C CO f~0 N rn O Y U C 0) U CO (U co J N Co m Y C m N U N V m Y Z C co Y ' C N U m m U c C U a O c m 0) ' ' U y Z i c U co z Co Y O U m U 0 U (Q m U Z U C N LL' d C co ~ N m o U z m C E L U " m` C - m ' U 0) 2)< 0 U ( C m U N C C Y) m m Z U m U Y y ¢ m N 4E m VI Q mm Z m' LL c m > 12 0 m- N m Co ( Y - ( O Y Y - - co U Y m` C ( (0 c cU U c c o o .D m LL O O m >,.2 N N p - oEo~ E d '~C', C m -U T' O > O CD m m O U m N m m d ~ N E L w mc - Y Y Y F- J 'c a-- a0) 0) C C N N U E E T m 7 C ~ W m m IW = Y ca)m o mL m L a ` a O mm oomaamoo E~'moo yE(n ~ - m m 2--- m m m LL > (D - - 1 c m - ' w lL - ~ m USYJa~(~(n(nS m0ULLF J co LL U 7 7 7 3 m O U m ` H d Q m N Q U L E m'L C m m m (s2 Q m co N ~ m m CO m Q N N j Ui Y U O. 4 J - = O_ O CL Y 1! f w N Y d > - m O N S O U N LL m E LL LL m LL O Z E m Z lUL O Z S S N LL E S E N O (D R ' CL > LL LL ULL ~LL 7mM: (3 LL U) yLL.::i3: :D LLLLLLLLrILDmLLILSLL J m H Memorandum Date: October 14, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find September 2010 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End $ Budget Actual Variance FY % Y C0ll. % et L B Projection Variance RESOURCES: Beg. Net Working Capital $ 8,300,000 $ 9,677,699 $ 1,377,699 100% 117% $8,300,000 $9,677,699 $ 1,377,699 Revenues Property Taxes 5,141,500 377,019 (4,764,481) 25% 2% a) 20,566,000 20,566,000 - Gen. Rev. - excl. Taxes 599,285 1,289,304 690,019 25% 54% b) 2,397,138 2,397,138 - Assessor 198,923 211,621 12,698 25% 27% c) 795,690 795,690 - County Clerk 305,179 398,800 93,621 25% 33% 1,220,714 1,220,714 - BOPTA 3,100 378 (2,722) 25% 3% 12,398 12,398 - District Attorney 78,525 17,607 (60,918) 25% 6% 314,100 314,100 - Finance/Tax 45,050 55,172 10,122 25% 31% c) 180,200 180,200 - Veterans 16,967 - (16,967) 25% 0% 67,866 67,866 - Property Management 22,783 22,540 (243) 25% 25% 91,132 91,132 - Grant Projects 500 500 0 25% 25% 2,000 2,000 - Total Revenues 6,411,812 2,372,941 (4,038,871) 25% 9% 25,647,238 25,647,238 - TOTAL RESOURCES 14,711,812 12,050,641 (2,661,171) 25% 35% 33,947,238 35,324,937 1,377,699 REQUIREMENTS: Exp. Expenditures Assessor 845,555 771,729 73,826 25% 23% 3,382,219 3,382,219 - County Clerk 371,032 286,936 84,096 25% 19% 1,484,127 1,484,127 - BOPTA 18,851 15,458 3,393 25% 21% 75,403 75,403 - District Attorney 1,220,532 1,147,684 72,848 25% 24% 4,882,127 4,882,127 - Finance/Tax 211,728 194,186 17,542 25% 23% 846,910 846,910 - Veterans 65,549 64,706 843 25% 25% 262,197 262,197 - Property Management 63,307 63,145 162 25% 25% 253,227 253,227 - Grant Projects 28,051 26,851 1,200 25% 24% 112,203 112,203 - Non-Departmental 547,972 346,333 201,639 25% 16% 2,191,887 2,191,887 - Contingency 1,870,694 - 1,870,694 25% n/a 7,482,774 - 7,482,774 5,243,271 2,917,027 2,326,244 25% 14% 20,973,074 13,490,300 7,482,774 Transfers Out 3,243,541 3,521,804 (278,263) 25% 27% 12,974,164 12,974,164 - TOTAL REQUIREMENTS 8,486,812 6,438,831 2,047,981 25% 19% 33,947,238 26,464,464 7,482,774 NET (Resources - Requirements) 6,225,000 5,611,810 (613,190) - 8,860,473 8,860,473 a) Approximately 85% of the property taxes are collected in October and November b) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452. c) YTD Actual includes A&T grant received quarterly in advance COMM JUSTICE-JUVENILE Statement of Financial Operating Data Three Months Ended September 30, 2010 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 Gen Fund Grant-Crime Prev Total Revenues Year to Date Year End Budget Projection Variance Budget Actual Variance FY % Coll. % L I $ 987,000 $1,039,997 $ 52,997 100% 105% $ 987,000 $ 1,039,997 $ 52,997 3,882 - (3,882) 15,000 11,582 (3,418) 4,000 1,675 (2,325) 9,500 6,098 (3,402) 85,002 - (85,002) 25,000 13,500 (11,500) 25 54 29 22,123 15,124 (6,999) 75 20 (55) 250 50 (200) 4,250 2,491 (1,759) 600 600 - 125 219 94 1,500 - (1,500) 15,124 - (15,124) 5,000 - (5,000) 191,456 51,413 (140,043) 25% 0% a) 15,527 15,527 - 25% 19% 60,000 60,000 - 25% 10% 16,000 16,000 - 25% 16% d) 38,000 38,000 - 25% 0% a) 340,006 340,006 - 25% 14% 100,000 100,000 - 25% 54% 100 100 - 25% 17% 88,490 88,490 - 25% 7% 300 300 - 25% 5% 1,000 1,000 - 25% 15% 17,000 17,000 - 25% 25% 2,400 2,400 - 25% 44% 500 500 - 25% 0% d) 6,000 6,000 - 25% 0% a)b) 60,495 96,500 36,005 25% 0% a) 20,000 20,000 - 25% 7% 765,818 801,823 36,005 25% 25% 5,543,186 5,543,186 - 25% 34% 7,296,004 7,385,006 89,002 Transfers In-General Fund 1,385,797 1,385,796 (1) TOTAL RESOURCES 2,564,253 2,477,206 (87,047) REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 740,989 676,161 64,828 25% 23% 2,963,956 2,963,956 - 299,972 227,674 72,298 25% 19% 1,199,886 1,199,886 - 25 - 25 25% 0% 100 - 100 583,866 549,441 34,425 25% 24% 2,335,462 2,335,462 - 43,874 44,402 (528) 25% 25% c) 175,494 175,494 - 155,277 - 155,277 25% n/a 621,106 - 621,106 1,824,003 1,497,678 326,325 25% 21% 7,296,004 6,674,798 621,206 740,250 979,528 239,278 - 710,208 710,208 a) Reimbursements received quarterly in arrears b) Additional funding from CCF allocated for Juvenile programs c) Negative variance due to a $10,000 annual subscription expended in July d) Awaiting reimbursements from current billings SHERIFF - Fund 255 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues TOTAL RESOURCES I Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ - $ 207,689 $ 207,689 100% n/a $ - $ 207,689 $ 207,689 5,707,364 4,241,618 (1,465,746) 25% 19% 22,829,457 21,363,711 (1,465,746) 3,416,485 2,859,266 (557,219) 25% 21% 13,665,939 13,108,720 (557,219) - 4,521 4,521 25% n/a - 4,521 4,521 9,123,849 7,105,405 (2,018,444) 25% 19% 36,495,396 34,476,952 (2,018,444) 9,123,849 7,313,094 (1,810,755) 25% 20% 36,495,396 34,684,641 (1,810,755) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 701,417 Civil 199,609 Automotive/Communications 363,259 Investigations/Evidence 412,698 Patrol/Civil/Comm Supp 1,957,163 Records 165,097 Adult Jail 2,488,424 Court Security 60,213 Emergency Services 43,610 Special Services Division 284,351 Regional Work Center 692,353 Training Division 82,500 Other Law Enforcement Svcs 144,229 Non-Departmental 70,755 Contingency 1,408,172 Exp. 627,747 73,670 25% 22% 2,805,668 2,805,668 - 206,866 (7,257) 25% 26% 798,436 798,436 - 547,389 (184,130) 25% 38% a) 1,453,036 1,453,036 - 389,862 22,836 25% 24% 1,650,792 1,650,792 - 1,837,957 119,206 25% 23% 7,828,651 7,828,651 - 150,310 14,787 25% 23% 660,386 660,386 - 2,040,837 447,587 25% 21% b) 9,953,695 9,953,695 - 66,349 (6,136) 25% 28% 240,851 240,851 - 42,922 688 25% 25% 174,441 174,441 - 300,137 (15,786) 25% 26% 1,137,404 1,137,404 - 623,988 68,365 25% 23% 2,769,411 2,769,411 - 69,054 13,446 25% 21% 330,000 330,000 - 134,877 9,352 25% 23% 576,917 576,917 - 20,755 50,000 25% 7% 283,018 283,018 - - 1,408,172 25% n/a 5,632,690 - 5,632,690 Transfers Out - D/S Fund 50,000 - 50,000 25% TOTAL REQUIREMENTS 9,123,850 7,059,050 2,064,800 25% NET (Resources - Requirements) - 254,044 254,044 0% 200,000 200,000 - 19% 36,495,396 30,862,706 5,632,690 3,821,935 3,821,935 a) Annual expenditure for Interagency Communications System was made in July b) Variance due to hiring delays and timing of jail bed rental SHERIFF 701 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants State Grant Transp. of State Wards SB 1145 Des. Cty Video Lottery Grant Des Cty Court Security Title III Reimbursement Transport DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Donations Total Revenues TOTAL RESOURCES I Year to Date Year En Budget Actual Variance FY % Coll. % Budget Projection Variance $ 4,722,862 $ 5,478,092 $ 755,230 100% 3,713,399 160,500 8,750 12,119 1,250 493,665 1,250 23,750 37,500 1,000 12,000 6,250 1,500 1,250 1,250 3,000 250 40,000 7,083 883 274,019 18,162 493,665 23,714 83 3,825 19,280 14,820 1,050 1,800 2,753 3,120 4,984 2,795 74,014 6,990 100 200 (3,713,399) 25% 113,519 25% (8,750) 25% 6,043 25% (1,250) 25% - 25% (1,250) 25% (36) 25% (37,500) 25% (917) 25% 3,825 25% 7,280 25% 8,570 25% (450) 25% 550 25% 1,503 25% 3,120 25% 1,984 25% 2,545 25% 34,014 25% (93) 25% (783) 25% 200 25% (3,581,274) 25% 4,526,648 945,374 9,249,510 6,423,466 (2,826,045) 25% REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 5,707,364 4,241,618 1,465,746 25% 116% $ 4,722,862 $ 5,478,092 $ 755,230 0% a) 14,853,594 43% 642,000 0% 35,000 37% 48,475 0% 5,000 25% 1,974,660 0% 5,000 25% 95,000 0% 150,000 2% 4,000 n/a - 40% 48,000 59% 25,000 18% 6,000 36% 5,000 55% 5,000 n/a - 42% 12,000 280% 1,000 46% 160,000 25% 28,333 3% 3,533 n/a - 5% 18,106,595 3,825 5,000 4,000 200 14,853,594 642,000 35,000 48,475 5,000 1,974,660 5,000 95,000 150,000 4,000 3,825 48,000 25,000 6,000 5,000 5,000 5,000 12,000 5,000 160,000 28,333 3,533 200 18,119,620 13,025 28% 22,829,457 23,597,712 768,255 Exp. 0/61 TOTAL REQUIREMENTS 5,707,364 4,241,618 1,465,746 25% NET (Resources - Requirements) 3,542,146 2,181,848 (1,360,299) 19% b) 22,829,457 21,363,711 1,465,746 19% 22,829,457 21,363,711 1,465,746 2,234,001 2,234,001 a) Approximately 85% of the property taxes are collected in October and November b) Payment to Sheriffs Office adjusted to actual quarterly SHERIFF 702 ` Statement of Financial O perating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % coil. % Bud et Projection Variance R Beg. Net Working Capital $1,905,939 $ 2,421,863 $ 515,924 100% 127% $1,905,939 $2,421,863 $ 515,924 Revenues Tax Revenues - Current 1,877,061 - (1,877,061) 25% 0% a) 7,508,247 7,508,247 - Tax Revenues - Prior 78,500 138,666 60,166 25% 44% 314,000 314,000 - Federal Grants 500 - (500) 25% 0% 2,000 2,000 - Federal Grants - 2,982 2,982 25% n/a - 2,982 2,982 US Forest Service 19,125 12,750 (6,375) 25% 17% 76,500 76,500 - State Grant 46,908 13,508 (33,400) 25% 7% 187,633 187,633 - SB #1065 Court Assessment 16,750 11,582 (5,168) 25% 17% 67,000 67,000 - Marine Board License Fee 35,608 - (35,608) 25% 0% 142,433 142,433 - Des Cty General Fund Grant 175,590 - (175,590) 25% 0% 702,358 702,358 - Des Cty Transient Room Tax 486,911 486,911 - 25% 25% 1,947,642 1,947,642 - City of Sisters 108,164 108,164 - 25% 25% 432,655 432,655 - Des Cty Tax/Fin Contract 250 - (250) 25% 0% 1,000 1,000 - Des Cty CDD Contract 13,592 13,592 - 25% 25% 54,366 54,366 - Des Cty Solid Waste Contr 13,592 13,592 - 25% 25% 54,366 54,366 - Des Cty Clerk/Election 500 - (500) 25% 0% 2,000 2,000 - School Districts 25,000 - (25,000) 25% 0% 100,000 100,000 - Security & Traffic Reimb 3,250 1,081 (2,169) 25% 8% 13,000 13,000 - Seat Belt Program 1,500 1,975 475 25% 33% 6,000 6,000 - Miscellaneous 2,500 5,148 2,648 25% 51% 10,000 10,000 - Restitution 125 - (125) 25% 0% 500 500 - Sheriff Fees 2,500 2,476 (24) 25% 25% 10,000 10,000 - Court Fines & Fees 21,250 32,678 11,428 25% 38% 85,000 85,000 - Impound Fees 3,750 1,800 (1,950) 25% 12% 15,000 15,000 - Restitution - Street Crimes 125 - (125) 25% 0% 500 500 - Interest 2,500 2,236 (264) 25% 22% 10,000 10,000 - Interest on Unsegregated 450 49 (401) 25% 3% 1,800 1,800 - Sale of Reportable Assets 2,500 14,904 12,404 25% 149% b) 10,000 20,000 10,000 Sale of Equip & Material 1,500 976 (524) 25% 16% 6,000 6,000 - Total Revenues 2,940,001 865,070 (2,074,931) 25% 7% 11,760,000 11,772,982 12,982 TOTAL RESOURCES 4,845,940 3,286,933 (1,559,007) 25% 24% 13,665,939 14,194,845 528,906 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Materials and Services 3,416,485 2,859,266 557,219 25% 21% c) 13,665,939 13,108,720 557,219 TOTAL REQUIREMENTS 3,416,485 2,859,266 557,219 25% 21% 13,665,939 13,108,720 557,219 NET (Resources - Requirements) 1,429,455 427,667 (1,001,788) - 1,086,125 1,086,125 a) Approximately 85% of the property taxes are collected in October and November b) Proceeds from sale of used patrol vehicles were higher than anticipated c) Payment to Sheriffs Office adjusted to actual quarterly PUBLIC HEALTH Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous OMAP Family Planning Exp Proj Grants Water Program-Base Fee Water Program-Field Work H2O Sys Insp-Priv Wells Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records-Birth Vital Records-Death Environmental Health Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues Year to Date I Budget Actual Variance FY % Coll. $1,100,000 $ 1,615,306 $ 515,306 100% 147% 2,000 - (2,000) 25% 0% 8,000 8,000 - 623,744 637,675 13,931 25% 26% a) 2,494,977 2,552,757 57,780 7,690 - (7,690) 25% 0% 30,759 30,759 - 54,974 40,243 (14,731) 25% 18% 219,896 219,896 - 119,450 110,306 (9,144) 25% 23% 477,800 477,800 - 123,750 94,221 (29,529) 25% 19% 495,000 495,000 - 16,250 48,773 32,523 25% 75% b) 65,000 113,773 48,773 10,500 9,386 (1,114) 25% 22% 42,000 42,000 - 13,954 14,840 886 25% 27% 55,817 55,817 - 50 - (50) 25% 0% 200 200 - - 201 201 25% n/a - 201 201 47,565 24,722 (22,843) 25% 13% 190,260 190,260 - 37,244 24,239 (13,005) 25% 16% 148,975 148,975 - 9,000 7,970 (1,030) 25% 22% 36,000 36,000 - 24,500 26,660 2,160 25% 27% 98,000 98,000 - 171,838 42,789 (129,049) 25% 6% 687,350 687,350 - 4,225 3,073 (1,152) 25% 18% 16,900 16,900 - 1,500 30,315 28,815 25% 505% c) 6,000 31,880 25,880 47,345 - (47,345) 25% 0% 189,378 189,378 - 6,750 6,750 - 25% 25% 27,000 27,000 - 1,322,329 1,122,163 (200,166) 25% 21% 5,289,312 5,421,946 132,634 Revised Year End Budget Projection Variance $1,100,000 $1,615,306 $ 515,306 Transfers In-General Fund 579,441 579,441 - 25% 25% 2,317,765 2,317,765 - Transfers In-PH Res Fund 16,781 - (16,781) 25% 0% 67,123 67,123 - Transfers In-Gen. Fund Other 16,953 16,953 - 25% 25% 67,812 67,812 - TOTAL RESOURCES 3,035,504 3,333,863 298,359 25% 38% 8,842,012 9,489,952 647,940 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 1,482,394 1,378,189 104,205 25% 23% 5,929,577 5,929,577 - 499,691 450,364 49,327 25% 23% 1,998,763 1,998,763 - 6,250 - 6,250 25% 0% 25,000 25,000 - 37,500 37,500 - 25% 25% 150,000 150,000 - 184,668 - 184,668 25% n/a 738,672 - 738,672 2,210,503 1,866,053 344,450 25% 21% 8,842,012 8,103,340 738,672 825,001 1,467,810 642,809 - 1,386,612 1,386,612 a) Department of Human Services Grant projected at amended contract amount for FY 11 b) Health Matters-local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July c) My Future My Choice donation carry over from FYI 0, in the amount of $25,880 BEHAVIORAL HEALTH Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue School Districts Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Interfund Contract-Gen. Fund Comm. on Children & Fam Administrative Fee Total Revenues Year to Date Budget Actual Variance FY % Coll. % Revised Year End Bud et Projection Variance $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% 1,375 1,975 600 32,500 33,407 907 250 15 (235) 24,242 - (24,242) 1,323,466 1,203,603 (119,863) 37,043 15,868 (21,175) 75,231 18,343 (56,888) 26,350 14,076 (12,274) 17,500 6,640 (10,860) 4,225 4,709 484 38,500 13,334 (25,166) 3,250 428 (2,822) 10,896 6,522 (4,374) 3,275 2,875 (400) 31,750 - (31,750) 6,000 - (6,000) 990,287 969,036 (21,251) 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 36% 26% 2% 0% a) 23% b) 11% 6% 13% 9% 28% 9% 3% 15% 22% 0% a) 0% 24% 2,626,140 2,290,831 (335,309) 25% 22% $ 2,616,050 $ 2,651,262 $ 35,212 5,500 5,500 - 130,000 130,000 - 1,000 1,000 - 96,969 96,969 - 5,293,862 5,020,888 (272,974) 148,173 148,173 - 300,925 300,925 - 105,400 105,400 - 70,000 70,000 - 16,900 16,900 - 154,000 154,000 - 13,000 13,000 - 43,585 43,585 - 13,100 13,100 - 127,000 127,000 - 24,000 24,000 - 3,961,146 3,961,146 - 10,504,560 10,231,586 (272,974) Transfers In-General Fund 329,040 329,040 - 25% 25% 1,316,158 1,316,158 - Transfers In-OHP-CDO 24,999 24,999 - 25% 25% 100,000 100,000 - Transfers In-Acute Care Svcs 91,413 91,413 - 25% 25% 365,657 365,657 - Transfers In-ABHA 167,063 167,063 - 25% 25% 668,252 668,252 - TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 5,854,705 5,554,608 (300,097) 25% 36% 15,570,677 15,332,915 (237,762) Exp. 2,307,477 2,154,147 153,330 25% 23% 9,229,909 9,229,909 - 1,000,725 733,064 267,661 25% 18% 4,002,901 4,002,901 - 185,000 - 185,000 25% 0% 740,000 740,000 - 39,291 37,500 1,791 25% 24% 157,164 157,164 - 360,176 - 360,176 25% n/a 1,440,703 - 1,440,703 3,892,669 2,924,711 967,958 25% 19% 15,570,677 14,129,974 1,440,703 1,962,036 2,629,897 667,861 - 1,202,941 1,202,941 a) Grant billing received quarterly, in arrears b) Department of Human Services Grant projected at amended contract amount for FY 11 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 686,081 613,031 $ (73,050) 100% 89% $ 686,081 $ 613,031 (73,050) 4,125 5,093 968 25% 31% 16,500 16,500 - 688 915 227 25% 33% a) 2,750 2,500 (250) 40,430 39,886 (544) 25% 25% 161,718 161,718 - 270,304 242,644 (27,660) 25% 22% b) 1,081,217 1,081,217 - 66,663 71,836 5,173 25% 27% 266,652 266,652 - 46,000 40,212 (5,788) 25% 22% c) 184,000 175,000 (9,000) 70,958 80,406 9,448 25% 28% 283,830 283,830 - 194,241 219,306 25,065 25% 28% 776,962 776,962 - 88,443 59,008 (29,435) 25% 17% d) 353,771 353,771 - 781,852 759,306 (22,546) 25% 24% 3,127,400 3,118,150 (9,250) Trans In-GF 63,348 63,348 - 25% 25% 253,387 253,387 - Trans In-GF for Lng Rng Ping 129,000 129,000 - 25% 25% 516,000 516,000 - TOTAL RESOURCES 1,660,281 1,564,685 (95,596) 25% 34% 4,582,868 4,500,568 (82,300) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 350,599 341,517 9,082 Admin-GIS 54,034 50,917 3,117 Admin-Code Enforcement 46,183 45,380 803 Building Safety 125,083 119,890 5,193 Electrical 46,902 43,512 3,390 Contract Services 61,063 59,249 1,814 Env Health-On Site Pgm 58,002 99,200 (41,198) Planning-Current 172,573 128,789 43,784 Planning-Long Range 123,107 160,698 (37,591) Transfers Out (D/S Fund) 43,328 - 43,328 Contingency 64,846 - 64,846 Exp. 25% 24% 1,402,396 1,402,396 - 25% 24% 216,135 216,135 - 25% 25% 184,732 184,732 - 25% 24% 500,330 500,330 - 25% 23% 187,606 187,606 - 25% 24% 244,251 244,251 - 25% 43% e) 232,006 220,000 12,006 25% 19% 690,290 690,290 - 25% 33% f) 492,427 492,427 - 25% 0% 173,310 173,310 - 25% n/a 259,385 - 259,385 TOTAL REQUIREMENTS 1,145,720 1,049,152 96,568 25% 23% NET (Resources - Requirements) 514,561 515,533 972 Revenues 759,306 Expenditures 1,049,152 Net from Operations (289,846) 4,582,868 4,311,477 271,391 - 189,091 189,091 3,127,400 3,118,150 (9,250) 4,582,868 4,311,477 271,391 (1,455,468) (1,193,327) 262,141 a) Custom GIS work revenue sporadic b) YTD revenue is low in relation to budget, it is expected that budget projections will be met, as several large projects are expected to generate significant revenue later in the fiscal year c) City of Redmond receipts lag one month behind d) Grant payments received irregularly e) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled 0 Approximately $51,000 in consultant expense was paid in a lump sum and will be reimbursed through grant revenue ROAD Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date 1 Year End Budget Actual Variance FY % Coll. %1 Budget Projection Variance RESOURCES: Beg. Net Working Capital $3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) Revenues Mineral Lease Royalties 5,000 5,108 108 25% 26% 20,000 20,000 - Forest Receipts 559,250 - (559,250) 25% 0% a) 2,237,000 2,237,000 - State Miscellaneous 24,246 - (24,246) 25% 0% 96,984 96,984 - Motor Vehicle Revenue 2,500,000 2,024,516 (475,484) 25% 20% b) 10,000,000 10,000,000 - City of Bend 68,750 - (68,750) 25% 0% c) 275,000 275,000 - City of Redmond 87,500 - (87,500) 25% 0% c) 350,000 350,000 - City of Sisters 2,500 - (2,500) 25% 0% c) 10,000 10,000 - City of La Pine 2,500 - (2,500) 25% 0% c) 10,000 10,000 - Admin Recovery (SDC) - 507 507 25% n/a - 1,000 1,000 Miscellaneous 5,000 8,134 3,134 25% 41% 20,000 20,000 - Road Vacations 250 500 250 25% 50% 1,000 1,000 - Interest on Investments 10,000 7,664 (2,336) 25% 19% 40,000 40,000 - Other Bank/LGIP Interest - 61 61 25% n/a - 100 100 Parking Fees 225 - (225) 25% 0% 900 900 - Interfund Contract 187,500 234 (187,266) 25% 0% d) 750,000 750,000 - Equipment Repairs 62,500 33,759 (28,741) 25% 14% 250,000 250,000 - Vehicle Repairs 22,500 - (22,500) 25% 0% 90,000 90,000 - LID Construction 2,500 - (2,500) 25% 0% d) 10,000 10,000 - Vegetation Management 8,750 - (8,750) 25% 0% d) 35,000 35,000 - Forester 6,250 - (6,250) 25% 0% d) 25,000 25,000 - Car Washes 750 - (750) 25% 0% 3,000 3,000 - Car Rental 125 - (125) 25% 0% 500 500 - Sale of Equip & Material 150,875 78,573 (72,302) 25% 13% 603,500 603,500 - Total Revenues 3,706,971 2,159,056 (1,547,915) 25% 15% 14,827,884 14,828,984 1,100 Trans In - Solid Waste 72,935 72,935 - 25% 25% 291,740 291,740 - Trans In - Transp SDC 50,000 50,000 - 25% 25% 200,000 200,000 - Trans In-Road Imp Res 3,010 - (3,010) 25% 0% 12,040 12 040 - , TOTAL RESOURCES 7,263,345 5,701,594 (1,561,751) 25% 39% 18,762,093 18,752,367 (9,726) REQUIREMENTS: Exp. Expenditures Personal Services 1,438,242 1,328,404 109,838 25% 23% 5,752,967 5,752,967 - Materials and Services 2,350,256 2,353,269 (3,013) 25% 25% 9,401,023 9,401,023 - Capital Outlay 292,923 - 292,923 25% 0% 1,171,691 1,171,691 - Transfers Out 100,000 - 100,000 25% 0% 400,000 400,000 - Contingency 509,103 - 509,103 25% n/a 2,036,412 - 2 036 412 , , TOTAL REQUIREMENTS 4,690,524 3,681,673 1,008,851 25% 20% 18,762,093 16,725,681 2,036,412 NET (Resources - Requirements) 2,572,821 2,019,921 (552,900) - 2,026,686 2,026,686 a) Annual payment-January 2011 b) Gas tax will increase by 25% ($.06/gal.) effective January 2011 c) Billed upon completion of work d) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 ADULT PAROLE & PROBATION Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278 Revenues DOC Measure 57 54,326 217,350 163,024 25% 100% a) 217,305 217,350 45 State Miscellaneous 1,075 - (1,075) 25% 0% b) 4,301 4,301 - Alternate Incarceration 7,730 30,918 23,188 25% 100% a) 30,918 30,918 - State Subsidy 3,250 3,327 77 25% 26% 13,000 13,000 - SB 1145 740,498 740,497 (1) 25% 25% 2,961,990 2,961,990 - Probation Work Crew Fees 9,500 5,395 (4,105) 25% 14% c) 38,000 38,000 - Miscellaneous 750 1,260 510 25% 42% 3,000 3,000 - Electronic Monitoring Fee 42,500 37,354 (5,146) 25% 22% 170,000 170,000 - Probation Superv. Fees 52,500 55,276 2,776 25% 26% 210,000 210,000 - Interest on Investments 2,250 2,847 597 25% 32% 9,000 9,000 - Interfund - Sheriff 12,500 12,500 - 25% 25% 50,000 50,000 - Crime Prevention Grant 12,500 12,500 - 25% 25% 50,000 50,000 - Total Revenues 939,379 1,119,224 179,845 25% 30% 3,757,514 3,757,559 45 Transfers In-General Fund 28,758 28,758 - 25% 25% 115,029 115,029 - TOTAL RESOURCES 1,584,508 1,876,631 292,123 25% 42% 4,488,914 4,601,237 112,323 REQUIREMENTS: Exp. Expenditures Personal Services 788,225 743,504 44,721 25% 24% 3,152,899 3,152,899 - Materials and Services 223,569 178,619 44,950 25% 20% 894,274 894,274 - Capital Outlay 25 - 25 25% 0% 100 - 100 Contingency 110,410 - 110,410 25% n/a 441,641 - 441,641 TOTAL REQUIREMENTS 1,122,229 922,123 200,106 25% 21% 4,488,914 4,047,173 441,741 NET (Resources - Requirements) 462,279 954,508 492,229 - 554,064 554,064 a) Annual payment received in July b) Payment from Parole Board for hearings not yet received c) Increase in fee waivers from court due to economic conditions COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 56,613 - (56,613) 25% 0% 226,450 $ 226,450 - Title IV - Family Sup/Pres 15,938 - (15,938) 25% 0% 63,750 $ 63,750 - HealthyStart Medicaid 23,750 - (23,750) 25% 0% 95,000 $ 95,000 - Level 7 Services 64,496 - (64,496) 25% 0% 257,984 $ 257,984 - State Prevention Funds 3,625 - (3,625) 25% 0% a) 14,500 $ 17,000 2,500 HealthyStart /R-S-G 77,231 70,409 (6,822) 25% 23% b) 308,924 $ 263,596 (45,328) OCCF Grant 151,081 142,043 (9,038) 25% 24% b) 604,323 $ 544,501 (59,822) Charges for Svcs-Misc 2,000 310 (1,690) 25% 4% 8,000 $ 8,000 - Court Fines & Fees 18,750 20,044 1,294 25% 27% 75,000 $ 78,000 3,000 Interest on Investments 5,000 1,606 (3,394) 25% 8% c) 20,000 $ 8,000 (12,000) Grants-Private 1,250 - (1,250) 25% 0% 5,000 $ 5,000 - Donations - 157 157 25% n/a - $ 157 157 Miscellaneous 64,639 28,475 (36,164) 25% 11% d) 258,554 $ 118,500 (140,054) Total Revenues 484,373 263,044 (221,329) 25% 14% 1,937,485 1,685,938 (251,547) Trans from General Fund 71,082 71,082 - 25% 25% 284,333 284,333 - Trans from GF-Other 6,250 6,250 - 25% 25% 25,000 25,000 - Total Transfers In 77,332 77,332 - 25% 25% 309,333 309,333 - TOTAL RESOURCES 1,124,467 975,716 (148,751) 25% 35% 2,809,580 2,630,611 (178,969) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Exp. 149,890 123,470 26,420 25% 21% e) 599,559 543,424 56,135 450,342 56,727 393,615 25% 3% b) 1,801,367 1,657,922 143,445 25 - 25 25% 0% 100 - 100 102,139 - 102,139 25% n/a 408,554 - 408,554 702,396 180,197 522,199 25% 6% NET (Resources - Requirements) 422,071 795,519 373,448 2,809,580 2,201,346 608,234 429,265 429,265 a) FY 2011 Budget includes $8,374 which was received in FY 2010. Additional $14,500 grant received b) Governor's mandated State General Fund reductions in July & Sept 2010. Additional $19,900 grant received c) Interest revenue projected to be less than budgeted d) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received e) Personnel costs will be less than budgeted due to open positions SOLID WASTE Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508) Revenues Miscellaneous 7,000 6,574 (426) 25% 23% 28,000 28,000 - Franchise 3% Fees 50,000 8,406 (41,594) 25% 4% a) 200,000 200,000 - Commercial Disp. Fees 210,000 237,116 27,116 25% 28% 840,000 840,000 - Private Disposal Fees 328,500 407,149 78,649 25% 31% 1,314,000 1,314,000 - Franchise Disposal Fees 914,750 1,083,069 168,319 25% 30% 3,659,000 3,659,000 - Yard Debris 18,250 30,870 12,620 25% 42% b) 73,000 73,000 - Special Waste 6,250 3,445 (2,805) 25% 14% 25,000 25,000 - Interest 3,125 2,045 (1,080) 25% 16% 12,500 12,500 - Sale of Carbon Credits 20,000 - (20,000) 25% 0% c) 80,000 80,000 - Recyclables 5,000 11,637 6,637 25% 58% d) 20,000 20,000 - Total Revenues 1,562,875 1,790,311 227,436 25% 29% 6,251,500 6,251,500 - TOTAL RESOURCES 1,955,384 2,108,312 152,928 25% 32% 6,644,009 6,569,501 (74,508) REQUIREMENTS Exp. Expenditures Personal Services 400,030 404,384 (4,354) 25% 25% 1,600,118 1,600,118 - Materials and Services 716,457 446,071 270,386 25% 16% e) 2,865,829 2,865,829 - Debt Service 242,517 - 242,517 25% 0% f) 970,066 970,066 - Capital Outlay 29,500 - 29,500 25% 0% g) 118,000 118,000 - Transfers Out-Road 72,935 72,935 - 25% 25% h) 291,740 291,740 - Contingency 199,564 - 199,564 25% n/a 798,256 - 798,256 TOTAL REQUIREMENTS 1,661,003 923,390 737,613 25% 14% 6,644,009 5,845,753 798,256 NET (Resources - Requirements) 294,381 1,184,922 890,541 a) Franchise fees are received in April. Wilderness Garbage pays monthly b) Seasonal material - revenue will decrease in winter c) No market at this time d) Markets for recyclables varies throughout the year - usually declines in the winter e) Larger expenditures (i.e. grinding at $75,000) made intermittently during year f) Expended in November ($367,098) and May ($602,968) g) Will be expended by December 31, 2010 h) Transfers made quarterly 723,748 723,748 RISK MANAGEMENT Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance % of FY % Coll. Pro'ection Budget Variance I RESOURCES: Beginning Net Working Capital $2,500,000 $2,374,541 ($125,460) Revenues Inter-fund Charges: General Liability 83,958 83,958 (0) Property Damage 73,505 73,505 0 Vehicle 45,678 45,678 - Workers' Compensation 226,590 225,127 (1,463) Unemployment 42,609 42,508 (101) Claims Reimb-Workers' Compensation 7,500 - (7,500) Claims Reimb-Gen Liab/Property 5,000 10,110 5,110 Process Fee-Events/Parades 375 630 255 Miscellaneous 500 - (500) Skid Car Training 5,500 1,120 (4,380) Interest on Investments 7,500 5,291 (2,209) TOTAL REVENUES 498,715 487,927 (10,789) TOTAL RESOURCES 2,998,715 2,862,468 (136,248) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 45,660 Defense 1,010 Insurance 1,418 Loss Prevention 366 Repair / Replacement 100 Total General Liability 100,000 48,553 51,447 PROPERTY DAMAGE Insurance 1,255 Repair / Replacement 5,194 Total Property Damage 75,000 6,449 68,551 VEHICLE Professional Service 1,250 Insurance 390 Loss Prevention 529 Repair / Replacement 5,902 Total Vehicle 30,000 8,071 21,929 WORKERS' COMPENSATION Settlement / Benefit 159,623 Insurance 46,424 Loss Prevention 7,814 Total Workers' Compensation 162,500 213,861 (51,361) UNEMPLOYMENT - Settlement/Benefits 40,000 40,000 Total Direct Insurance Costs 407,500 276,934 130,566 Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Contingency TOTAL REQUIREMENTS NET 72,363 71,183 1,180 57,209 41,810 15,399 25 - 25 129,597 112,993 16,604 586,618 - 586,618 1,123,715 389,927 733,788 1,875,000 2,472,541 597,540 100% 95% $2,500,000 $2,374,541 ($125,460) 25% 25% 335,833 335,833 25% 25% 294,019 294,019 25% 25% 182,710 182,710 - 25% 25% 906,361 906,361 - 25% 25% 170,437 170,437 - 25% 0% 30,000 30,000 - 25% 51% 20,000 20,000 - 25% 42% 1,500 1,500 - 25% 0% 2,000 2,000 - 25% 5% 22,000 22,000 - 25% 18% 30,000 30,000 25% 24% 1,994,860 1,994,860 - 25% 64% 4,494,860 4,369,401 (125,460) %E 25% 12% 400,000 400,000 - 25% 2% 300,000 280,000 20,000 25% 7% 120,000 115,000 5,000 25% 33% 650,000 680,000 (30,000) 25% 0% 160,000 160,000 - 25% 17% 1,630,000 1,635,000 (5,000) 25% 25% 289,453 289,453 - 25% 18% 228,834 228,834 - 25% 0% 100 - 100 25% 22% 518,387 518,287 100 25% n/a 2,346,473 - 2,346,473 25% 9% 4,494,860 2,153,287 2,341,573 - 2,216,114 2,216,114 DESCHUTES COUNTY 911 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Year to Date Year End 11 F Budget Actual Variance % of FY % Coll. Budget Projection Variance Beg. Net Working Capital $5,861,335 $ 6,691,945 $ 830,610 100% 114% $5,861,335 $6,691,945 $ 830,610 Revenues Property Taxes - Current 1,589,405 - (1,589,405) 25% 0% a) 6,357,621 6,357,621 - Property Taxes - Prior 34,500 106,321 71,821 25% 77% 138,000 138,000 - Federal Grants 118,500 - (118,500) 25% 0% b) 474,000 474,000 - State Reimbursement 2,500 1,518 (982) 25% 15% 10,000 10,000 - Telephone User Tax 137,500 - (137,500) 25% 0% c) 550,000 550,000 - Data Network Reimb. 3,000 1,528 (1,472) 25% 13% d) 12,000 12,000 - Jefferson County 7,750 490 (7,260) 25% 2% 31,000 31,000 - User Fee 12,500 45,869 33,369 25% 92% e) 50,000 50,000 - COPS Reimbursements 7,500 - (7,500) 25% 0% 30,000 30,000 - Contract Payments 17,500 - (17,500) 25% 0% d) 70,000 70,000 - Miscellaneous 2,125 2,150 25 25% 25% 8,500 8,500 - Interest 10,000 13,069 3,069 25% 33% 40,000 40,000 - Interest on Unsegregated Tax 500 41 (459) 25% 2% 2,000 2,000 - Total Revenues 1,943,280 170,986 (1,772,294) 25% 2% 7,773,121 7,773,121 - TOTAL RESOURCES 7,804,615 6,862,931 (941,684) 25% 50% 13,634,456 14,465,066 830,610 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 1,002,200 895,044 107,156 25% 22% 4,008,798 4,008,798 - 381,036 329,500 51,536 25% 22% 1,524,144 1,524,144 - 140,750 - 140,750 25% 0% 563,000 563,000 - 253,515 754,061 (500,546) 25% 74% f) 1,014,061 1,014,061 - 1,631,113 - 1,631,113 25% n/a 6,524,453 - 6,524,453 3,408,614 1,978,605 1,430,009 25% 15% 13,634,456 7,110,003 6,524,453 4,396,001 4,884,326 488,325 - 7,355,063 7,355,063 a) Approximately 85% of the property taxes are collected in October and November b) Grants - Billings will be sent to OEM (Oregon Emergency Mgmt) this month c) Received quarterly d) Yearly agency billings will be mailed out next month e) Crooked River Ranch paid annual fee f) Transfers made as requested. Transfer to New Facility Property Fund, $754,061, made 9/15/10 & Transfer to Reserve Fund, $260,000, will be made in 3rd Qtr Health Benefits Trust Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES Beg. Net Working Capital $ 16,400,000 $ 16,988,140 $ 588,140 100% 104% $16,400,000 $16,988,140 588,140 Revenues: Internal Premium Charges 2,811,500 2,851,412 39,912 25% 25% a) 11,246,000 11,403,534 157,534 P/T Emp - Add'I Prem 12,500 9,643 (2,857) 25% 19% 50,000 50,000 - Employee Prem Contribution 125,000 120,645 (4,355) 25% 24% 500,000 500,000 - COIC 243,750 343,962 100,212 25% 35% 975,000 975,000 - Retiree / COBRA Co-Pay 112,500 176,538 64,038 25% 39% 450,000 450,000 - Prescription Rebates - 23,543 23,543 25% n/a - 23,543 23,543 Interest 25,000 34,800 9,800 25% 35% 100,000 100,000 - Total Revenues 3,330,250 3,560,542 230,292 25% 27% 13,321,000 13,502,077 181,077 TOTAL RESOURCES 19,730,250 20,548,682 818,432 92% 69% 29,721,000 30,490,217 769,217 REQUIREMENTS Exp. Expenditures: Personal Services 32,320 30,456 1,864 25% 24% 129,280 129,280 - Materials & Services Claims Paid-Medical/Rx 3,390,311 2,919,124 471,186 25% 22% b) 13,561,242 11,676,497 1,884,745 Claims Paid-Dental/Vision 509,595 405,804 103,790 25% 20% b) 2,038,378 1,623,217 415,161 Refunds - (21,128) 21,128 25% n/a - (21,128) 21,128 Insurance Expense 82,500 85,782 (3,282) 25% 26% 330,000 330,000 - State Assessments 18,750 62,429 (43,679) 25% n/a 75,000 75,000 - Administration Fee 75,000 73,942 1,058 25% 25% 300,000 300,000 - PPO Fee 10,000 9,816 184 25% 25% 40,000 40,000 - Health Impact 12,750 12,618 132 25% 25% 51,000 51,000 - Workplace Clinic Healthstat - 31,490 (31,490) 25% n/a - 31,490 (31,490) Equipment - - - 25% n/a - - - Remodel - 9,688 (9,688) 25% n/a - 9,688 (9,688) Miscellaneous - 295 (295) 25% n/a - 295 (295) Other 37,785 9,716 28,070 25% 6% 151,141 151,141 - Total Materials & Services 4,136,690 3,599,576 537,115 25% 22% 16,546,761 14,267,199 2,279,562 Capital Outlay 100.00 - 100 25% 0% 100 - 100 Contingency 3,261,215 - 3,261,215 25% 0% 13,044,859 - 13,044,859 TOTAL REQUIREMENTS 7,430,325 3,630,032 3,800,293 25% 12% 29,721,000 14,396,479 15,324,521 NET (Resources - Requirements) 12,299,925 16,918,650 4,618,725 - 16,093,737 16,093,737 a) Year End Projection is amount appropriated in operating departments' budgets. b) Projection based on annualizing 13 weeks of claims paid. YTD actual is $254,139 per week. Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 2,809 $ 6,590 $ 3,781 100% 235% $ 2,809 $ 6,590 $ 3,781 Receipts: Special Events Revenues 169,436 280,734 111,298 25% 41% a) 677,742 766,475 88,733 Interest 500 374 (126) 25% 19% 2,000 1,875 (125) Storage 12,750 - (12,750) 25% 0% b) 51,000 51,000 - Camping at F & E 2,250 440 (1,810) 25% 5% 9,000 9,440 440 Horse Stall Rental 10,500 255 (10,245) 25% 1% 42,000 42,255 255 Concession % - Food 52,750 72,930 20,180 25% 35% a) 211,000 206,930 (4,070) Rights (Signage, etc.) 23,250 14,000 (9,250) 25% 15% 93,000 94,000 1,000 Interfund Contract 11,250 - (11,250) 25% 0% c) 45,000 45,000 - Miscellaneous 1,104 9,363 8,260 25% n/a 4,414 14,040 9,626 Total Receipts 283,789 378,096 94,307 25% 33% 1,135,156 1,231,015 95,859 Transfers In General Fund (001) 49,480 49,480 - 25% 25% 197,919 197,919 - Room Tax (160) 6,218 6,218 - 25% 25% 24,873 24,873 - Welcome Center (170) 20,000 20,000 - 25% 25% 80,000 80,000 - Annual County Fair (619) 57,808 - (57,808) 25% 0% d) 231,232 175,000 (56,232) Reserve Fund (617) 25 - (25) 25% 0% 100 100 - Total Transfers In 133,531 75,698 (57,833) 534,124 477,892 (56,232) TOTAL RESOURCES 420,129 460,384 40,255 25% 28% 1,672,089 1,715,497 43,408 REQUIREMENTS: Exp. Expenditures: Personal Services 232,973 229,210 3,763 25% 25% 931,893 928,130 3,763 Materials and Services 119,171 155,385 (36,214) 25% 33% e) 476,685 526,899 (50,214) Debt Service 28,891 - 28,891 25% 0% 115,563 115,563 - Capital Outlay 25 - 25 25% 0% 100 - 100 Total Expenditures 381,060 384,595 (3,535) 1,524,241 1,570,592 (46,351) Transfers Out - Reserve Fund 2,500 - 2,500 25% 0% 10,000 10,000 - Contingency 34,462 - 34,462 25% n/a 137,848 - 137,848 TOTAL REQUIREMENTS 418,022 384,595 33,427 25% 23% 1,672,089 1,580,592 91,497 NET (Resources - Requirements) 2,107 75,788 73,682 - 134,905 134,905 a) Revenue unusually high in July and August due to BMW and FMCA events. b) Most storage activity begins in October. c) Interfund contract revenue is for park maintenance, from Fund 130 d) Cash flow from Fair 2010 is projected to be $57,000 less than budgeted e) Year to date amounts include costs associated with BMW and FMCA events and expenditures for HVAC repairs. H U W ti O a. a H a U a r., O a, U c~ G Q~ N U CJ N O ~ ~ M ~ O O N 00 r 00 O M 00 O O O O N CA It 00 CO) w m I` M M O co cY O M O O M N 00 C OiN M V- ' CA ' MNO ' MM~-0 - ` 0 O COO CA M 0 O It d O O (fl O0) C6 I-00 N O N11 C \T O -00 a) N VN ~ M M I~ O O CO M O M N M O ~ M O M CO N O O N M 0) Itt~ CO HOMO V'M V OMMCO V il- O OO O ti 00 O)Il- w f- V OOMNCOOMM - W N M COO 't Cfl Of p lq Ln O ~I~i [ O CO O O ~ M I` 00 1-: N O N' I' cr O O N 00 Cfl O M co 0 O O CO CO O N N- M O M O 'It N O M CO CD d O CO M O "O C LL O U O N w O O L M d 00 a) cn 'Q E ~ U n U O N to U fn O O ~ Q a M O O L N ~ Cn ~ C O O) a) 0 00 O CO CO O ,f 0 0 O CO N N O U O O O M O O Il- O O O CO M M O a) Q O O O O I ' 00) ' O LO N co M M O ' O 6 7 O p O O O O O ( 11 r- C O O O L O tl• O) CO O M O 00 O O CA CL M N M r co I- ti M CO to O O Cfl O I-CA 1- CA I-- 0) NO)N00Me-000Ce) N N N V M 'It - O .-'I M0dtM'I OMOCD ~ N O O N er a) C l Il CO I~ ti C11 M N OO CO Cr) M C4 CO ' ' OO N a) t6 It LO 0 -CO COOOLCiM Wr -W O O N co p Q O N co CO - M co O O O O N L N e- M O 00 O O M O CL Cfl O Ici d' O V- cn rn a) c U a) N E a E E E U O ~U U 06 w V O N w w O O O O CF i 0 O O) O O O O O ti Mfl- M N M N M M 000M N CO Cfl a0 00 d ~ CO ~"t MO tM"It OMM0 q, N CA a) CA Il CO f- fl CA d n N 00 r- 0: M T-1 M CO OO OO O r V O O ~000LO COOM~MI`M~ ~ O O N co O N 00 CO M M O rn rn v M N c M O r M M M N T- cn w O U a) U C LB N O C N N 0) U U p to a 4~; o o m ~ E- N N a) V U > U cn o U Z fn c t C ) Q U 7 ^ o~ a) E p Q) .2 fn to a) (n a) w a) m U) od 7 c> N L C O .2 CD O > o Lu C .2 0) co .Cl) . d LL C. w •o O CL ca +3.+ ~ L Cn U 0)-a U Em Q) •C 2 ` Lo O E U G c c) ' 4. ` c) 0 U Q ul ~ ~ ca a) L t ii N r lb CL w~Q wl- cu a fn s a) -0 LLQa~ ~O Uz0 :D 0 N C N x w H m z CO CO O O O) O oS Cr O O co N r M CO 00 '~i It M M O N O N (14 f~ Lf) N N O Cl) N O LP) I- CO O;t I;t N 00 CO 00 N It O ti It CO 00 CA "IT ti 00 O I-- N O 00 Lo M 0) ,t M P- CO N 1-- (fl ~ Ce) CO N 00 N M N co CA CO I- 0) M O) t- M LO It CA LO O rt LO It - It CO CO LO ~ 00 ti Lf) O N N co _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ r' N N V V 1- Lf) r Cf) ~ I` O 00 CO M N 00 00 N M M 00 Lf) I- 00 N Cf) 00 M N CC NNMCD N N M tf) M C O d Lf) M N LO CO LO O ,It O ti (A Z M M ^ v''' ^ W N - rn 06 N 'IT LL 2 - ;T LO r,: 't 45 C' ~ ~ CV O N U O M CM O 00 O O o -M ~N O N O o co O CO 00 > Cr~ 04 Go), O-0 IT O o ~..~~E13~w p 04 _ U M In o N N w to 0 00 o N ~O° \o NtiN~ N N 0 3 00~ O Z o - O O ~ U ~o co COO o Q E O"T O C) IT c m CO c CO N co UM C\l (D ~~M L , NO~~ OCD O V N'~ «ER a N U W a) C p ~ otS ~ o E d3 T LO (o o m j ~ E!-? 0 t, N m O O co to W. O O 0 z CD 4-- 0 't E Co O N O N CO O c 0 c) v N C> C' .LU al (6 N 64 o c c ° M N o o O E CO :3 a~ ~O'6 Mo 0)C) 0 > U~ v N n ¢ o m N c c bog, C) c o CD (10 00 0) a~ a~ o o rn 0 U CO L a o:3 CT O c a) m m ~n C U CD O o O `O 4 o (D C y U N O_ E .O ui 'a (c: N c c Y m co 0) z W 7 C) N N Q C/) o U rn c~ O_ N s C U U O O H Lc a) 0 C: U) Co Co c: °d C'D 0 0 ~ M° t- Co c> Lcv ° a) CQ O cUO U; (1) U c 3 0 rn C off 7 7 L O U C a) a) L c c N c a) m U ca o) 3 H U ~ U o c E -0 0 -0 O 5 to C C 3 c T U ~c - a CU ` O U .c U U U E La m C) Cv ca U-) <OCL 22UWHc v, c) Q Q Q = LL O N M t to I- M 0 LO fl- M M N M "t - 75 C '~F°- a' OU c E ui O C O od N U N N w N U) c U) O O O C C N W O W C Y p) Y O C O W CO O c m O to U) c 7 LL O T r ~ O a) N O O O d M U M N a) L d 0 a) a CD m rn m O a) L ~ L H U ) 0 a m .Q m U r 0) ,~T N ti O a0 aaO av M~ mOO 01) co r M to [t co M M B O O CO q l" O O O O N 11 O N' O O N' a' V' O O' d• O' U) U) d• O' ' ' r It O M 1- (O ti co ~ N I~ d LO 't CO co f-- to M IT to (O to v r T co 'T O O M LO O 11 N N O N r- co LO N ~t 0 0 LO O M M O N O O U) B O O M U) m O O O O O w M r MOO ~tti MMM00MO0 M "T00r O 0000000 M cr OOOO(o Nit VtO(O(gRC ltzl R q q Od 0000 V 0O a0 M U) M N U) r T N O N I- r ct M O ~ r a0 ti O~ ~ t~ C' U) (D LO O M to 00 U) N 0) r d O O Cl) M 1- 04 N r-- r 11 N t0 'IT M N 1- N U) N r M LO 00 r N M C \f r N r V (0 O N O O N O 00 O~ O O O O O U) n 00011- N O U) O O (D O O O 00 O O 00000 P- O O O r- t0 O C \L O C %L ' O r' q q 0 0 0 0 U) 0 0 0 U) N ' O N CM U) O t. - N O O r O r o N V U) r~1-- O U) h M (O N co U) N U) U) U) O O M N N N N O It t0 N (O O U) CO U) U) t0 M N CC 1- M V- L CO r O r t0 O U) 00 O N (O 00 U) "T M B O O 00 i,- U) O to O CO ct O t r M O M a- CO O O co 00 It O 00 CA (O N 00 00 h Nt (O (O O O Cl) N I- v m 0 O O U) d' O w m I` M O ' ' 00 IT M ~ U) M a0 M 1-: (o Ui CO V: O N r, v U) d N V7 Co v O N ( of U) M M E O) 00 N O M t0 M O r to h O 00 N M `~T O N U) O U) CO N r N co M N (D N r U) r r U) U) t0 CO LO LO 00 0 ~i CS C% d r O r (D O U) 00 O N CO ~ 00 LO t M r- 00 U) M f` U) LO O t0 CO O a T- M O CO - (O O O (D 00 rt O 00 M U) U) N 00 CO N O) (O O O O Cl) N rt 0) (O O w 0 ~t w m m [t O Nr 00 dT ~ 00 d M 00 M r CO tf) CO Ct O N t d U) Ili d (O M O rz vi N U) M Cl) P- 0) 00 N O Cl) I-T r U) r U) N d' U) N M IT O N U') O U) M N r r O) M N t0 r N V' U) m U N L C co f.) a) x ti co LO w C3 od y E m j E (~'a m ( z N O p c a) - Y N > 3 y N (D a) m a) O 3 L c LL N N U m m 0) 3 ¢ j (a ~ a l p Q. a) - R ~ > w U) Yr v L W 0 a .te CD - it + + M LL W 3 U C U U_ R j C - N y a) Q od m m c V a) U L C y r F" ~ U (n ZT -o u a) •N m 2 ( c 4= E a) O U Q j LO d D 0) c C 7 N a~ C) •0 Y L O ltL G .2.. C 75 ~ U N a) Q i . d m in Z m L ui a) c a) o" L) ° Q r . 'E 3 w N ° a io W 0 CY) a(ni m y .L m s c I - a ) c V o aUi H ~v w o Q) m o d X mQwHa- LLQaw202 mzZ) 00LL1- c w Ca LL F- c F- w Z 0 H Z "t N, -r- O 00 lC)Or lnd'M OOO O 00 N CO Cfl- T- M M I-- O O 00 d' - 00 O O O O N r Cfl N M M N ' I ' 'IT CO 00 ' 'IT 00 ti ' CO Ln It O It r M ~ ` O ~ v- C O ~ co a) 0 fe) ILO O IT N N ON~ CO tO N It O r in O 00 00 O N CO t- O LO d' M O CO 00 O O 00 CO) N M O RT Cl) CA M O CO CA O O 00 T Co CO co O O Cfl M r COOM O) NIt d'OCO0w0Itwr-0 m 0 It0 ~ co r M Ln CO If Ln r d' N O C \T -14 U') e r r M I` CO r C %i Ln O co N 00 LO N O CO It 03 O M ":T co I* Nd' 1- N LO LO NE- O IT N M M N N M O N O N O co O f- O O O Ltd N. I~ N OOO tO O W 000 OO O O I,- r- cO O N O N O V' O ~ ' C 0' ' ' O CO LQ ' LA N ' O N LO 1- I- - N O O N 't V 1- co rl- N Go LO N In CO 0 0 N co LO LO 0 co M M C6 M COO O d' O -p N ~ c O c L CO O - L U C).0 u) a) E a) O a) CL Q L a) Cl) M m U o L r ~ O ~ ~ r- r CO O CA W O N CO - 0O LO T M (I- CO co co to M ct 00 M O M ~ CO O O CO M 't r M N CO CO M 0) CO co M LO N I- 't 0 CO CO w 0 C 00 fl- M to O O LCD CA M 00 Cfl 00 L() CO ~t O C NT ' Lf) Ni CD 00 00 Itf M O to N O co 0 0) 0) 0 co N CO O N d Lo V) O In M M N C \F c- LO Lfl CO O M M Ln LO ' CO CO (D 01 00 00 ' ~i C %i V t0 O LO CO O N CO CO LO "t 04 fl- r- M M m 1- M r- Co CO O M ~ CO O O CO CO '7 rl- 00 00 co Ltd M v co co M Lo Nrl- VCACOCOCOUOIT 00MM r N lqi CO 0) M 00 Co 00 Ln 00 O N r-: .Zf L6 CO 00 LO M CO co to Cl) E co N O It N CV cn C to It V O ( O co M Ln N Cl) LO C cn U) O U a) to d co C: U) a) tv 7 U CD 0 4) ~1% 0z o a) V) rn m CA 0 U c to a) N fn -0 ` > w c O d Co L 0 0) a) O O) od O :3 O E cu - c fn a N 0) W 0 V a LL ' 'i_ U > y ca Cl) W 0) C 7 ? co c a) U O a) w Q Q a) CU m a) m a y L U U o C7 p aa)) 4(D) rs .c c c IL rn w O° p° Z3 - C 4) :3 4.L « in z L .c c- 'C Co u o N N U Q- ~ 'a W 0 C: - c L 3 rn cn N ~ m r nW. a? 2 °c) (01) m c c a°) -0 H- a) c v HO L m°ti5~ x co<LU a LLQn.~~O UZ~O 0 z Z ^ W j N Lv O M U ~ L f< E a M a) U ~ W U O Co Q O) ~ U Z W U M LO CO C: a) Co m C9 N 06 It i CNO Co ~ - LO O M Cfl M 1~ IT LO 7 co 0 N N Q C O O O M O f- COO O f~ CO CO O N O O O CO r- N O 0 ~ ~ O CO f~ CO M M 0) - O CO O ti r- N O tT CO N M M tt d O I~ O N E O 'cT O ti O C) w C O CA ~ ~ MM'IT 0) C) O O C) LO W 0 N OM000ITW M~O) O O O) _ E C O O O 1 r- ~Nm C6 C61: 6 r6 rl°CflNCAtiNc-COMr.M CO - - IT O CD N rl O Co N N Co E - 'I Q O ~ T O \F CO O N C U ce) Ul) Cf M N N M to O M 00 V) 'T O O O O N Cl EH y3 04 co C"! 4- CO O T7 CD 0°O04 O) O C)o 00 Nr EFY o o6 ° ~v GH ct ° O ~ O o O ~ v N ..N O fiR CNtiN N64 00 ~ - O 4- o< 0 00 0 O ti 04 Op 4- po M„C C: p OL m ~ c °d Q) Ln 0 O 'O c- U Cl M E CV M o \ L O cn M cn O c O) U o C U) ~ LO V' M oV O O M 0 E M ~ O a) ~ 0 C O O M. O C V o L ce) E U O C ~ ~ ~ a) Co g or= v° ~ CLc~ ~n , 10 n0w00~ a ) 4 60% 6 'IT Q) 0 .2 Q) 0) Cf) O M 0' 0) 0 " O CD ~ a c0 ~ C a) p C L U 0) cD L C Cl) C9 0 E d U o ° 3 U C o cn U~ 'O U O L C M w O O t7 C O_ C O O O C U N - O C CD L m ' a) p a) E 5 a U N N m V O 0 O U O o U C 3 U cn C L (a (0 L o a) 0) M 'p m a) U O U' Y a) 3 O cu Lc6 C a O C N U a) (9 CO O O L C od L C) 0 N U •7 a) 3 U (0 3 'O O C .E U U ~ O) 3 c O ( 4 E g 3 E U L E U> N co O E U CU O v a) U v v ro E u) -0 c E -a U U u)i -p O - N O O M N N a - a) x a) N = ~ ~ U L U: ~:.~(A~ Wu1 Q~C7U~n~~d QU O • C O) m LL. O D CA O- N O~NMOCOCOO~NM~OCOI~ C co C ` °O _ NMMM t t * t t * *t it *t *t t t t t t ~t t ~t S O U E c E E v) a O U U U U L U Q) L L 3 C -p C U 3 / L ''a^^. v/ a) 3 O C U C W c p E c W m O a`) C m p F- 2 W F- O O ~ O C p ~ N LL O c co U CL-0 (n o ~ d aEi CD N c L 0 LL 0) O N ~ Z L F- O O O O M ` M 0 0 0 0 O O O O O O O 0 0 0 0 0 0 0 O O O O Cl) M O O O O O O O 0 0 0 0 0 0 0 O M O O I,- 1- O O O O O O O O O O O LO LO 7 0 O 1- MOd 1z OOO to tn~1- OMtoC 000M M l C'')) O CO) to O M M N I* N O e- CO cn -q! N co r- t 0) w N N r- C O O O O O O O 000 0 0 0 0 0 0 0 O 00 O 000 O O O O 0 0 0 0 0 0 0 O OO ' O 000 O OOO 0000 LOLO0 O ' M O M O O O to to to r- L 00 to 0 M O M M M O M to to 0 M CM N- d I- r- O ~ c CO M IcT N w O I- M N r O O N N ~ 1- C O 0 0 cM LO 0 Il- LO N T- 0 O co M O CO co N 00 r- 00 11 ti ti O O oc ' ' 00 1 ' dt ' ' ' ' M T- Ul) Ce) It M Nt co M Cq L6 Cl) Ce ) O LO r N d' V LO LO M N LC) r M N N - 1- C i I I i I i i I i i I I I I I I O OO MLO O 1 ' I,- ' In i i 1 ' N T- 0 O M M O co O N o0 00 14 O ' I- ti 00 O co 00 d M e- to M M O r V- t M V) N N V 14 to to M N to M N N r- V N N .C ` LL C r N (D N ~w O~ c U LO ° od o a) U) ~ c ° co E 0 w co O m (6 a E C7 X 0 > ~ v! 7 LL v cn - c 0 :3 ¢ 3 v 0 O a 0 c Q E t0 E 3 O d w V w i CO U ii Ow E N n r- c U) > B CL c W rn 3 ~ c m = atS a) ~ f + ~ j V c 0 (A H od F m m E w o ~ ~ Q 'a) 3 c o CL c 0) 0 0 O N N a~ N W L a .2? 0 c~ SF- ep E Qo a ~wOLL O (0 od c L w CL w 0 w 0 0 X co tB U LL ° Z LL C I- w U Cl) oz oW ~Ho U o N 0 0 U M ap ~ a.. Q E w c a) - w o- U Z cn LL Zca ~U Z W a) U c a) (E 7 N p m i i CO i (0 V w c ti o o r- E Q c i i M i 00 E C 00 7 E O U c O a E Q Q U) p cn O "O N O c a) U c c O 2 a) N co v ti 0 M co co 1 'b (D c a) U N U O Q.' O to N O c 7 Cl) U N ~ N m > > a L N U N N ' N N L ❑ U- 0 E I- co Q) H 7 U N CO c) O LO 01 CO v 0 0 . ~ rn Ln Oo N O O O co M O CO r 1,- O O O ~ LO LO O O N N ' - O LO M L O r~ ' 00 ~ 0 ' (M N N E O ti O N LCj 6d v 006 v cr v v M . O O M O N U) 00 r- U ) CO 0) CO) In Cl N i O L O O. LO L V'OM0U') co ~OOMN~000o t0 OO 0 CO) (o:~ 0 M O M O O N M CO O ~ (D O CO O L- O d cc N O 00-0~tO ~'fOi~MO~-OOM00Nh OO ' ti Of LO O N N O to r- 00 O 00 LO CO LO Cl) N LO (0 0 0 (O N O Cc CO LO N - N N N N LI- ~ O) LA U - N r- O M LO LO co N (d c- C% r > C M rn 000 00 000 M~0 O COO 00 00 U ' 000 00 000 0000 O 0 LO LOCO 00 0 2 O O O O O O O O ' M N O' O' ti N Cl O ct ' a ('M O N 0 LD L- O) N LO O (0 N ~ 00 M Ln cc a LO LO - r N r M LO co co O N 0) N O f N . C14 r, C \ f ce) 00 ~t c j -CU U- U) - q;t O M O LO e- O V O 0 N 0 0 N 0 1l- V' O r-~ LA ~ '0 (n c 0 MOMOOA 0000-0000-CO r ~ ON a) 0) N ~ 0 0 0 - 0 LO CC LO lzt O~ M O CM O C II N O IT v ' O r' j U')ONN0m NCO CO 00 LO0C4CO LOS O OO t0 M O O N N O OO N 0 L 0 N N N LO 0 0 - N N r 7 O C U 0A 0 co LO 0) 00 O) a) ~j co . r. . . . . . . . . . L°n ti I N N o LO N 00 coo m le V 0 O -D co co M M O O N 0 CL cn a) C ~ O V O CO O u) r L- LO 0) N LA O N LO r- q:r (A r- I- CO LA m 3 co O M O O ti O h to fA CO CO 1- O N N N O 0 0 - 0 Ln CO d C IL M W M 0 M O N LO Ll- ~ ' N It U t0 O N N O Of (0 CO CO 00 l0 O N M LO r r M M 00 d O O N (0 LO N r 1 N O V w w N~ O N N N L() > M N L N a 0 U O y N M N (A CO O r CO U O CN co - U O y N ` 4 E d U9. C O c 7 N tl (D c Q) • N + N Of ~ O c _ (n N to O End U O N T P- 0(0 o . 0) Z c ❑ 7 N ca 'O rn .U 00 N .L+ N a) - N ~ 'A N 0 O O C y m O U) 0 2) (D c U) 'U N O °a . 7 L ftl d to L ❑ r LL 3. (D N N (D 7 c w Y of ~N 0) c E a~ m c a (''a ° W a v 3 > cm a co 'i E U c E a) H 0 U o Q o V m o c c U to U) its U (U c rn C CL N U ' 3 :3 CD 4) U) a o (6 of f0 2 L L c (D ' O V; Q 0 = Qf to 0 .O. O O 7 c 'C R a r'' O- Z m 1 c `C cn N L O w A Vl L K m w 'a CO c O N _ a N a T w . _ ~ O > j Lt '0 F0- , dw QoF0- co m0 U) w v, c o ho M 0 c c 0)) x criQ W W Ja._LLa¢❑~t- mU ;a m N ' , 0 O 0 O 0. - 1 fn F- ❑ S F- w Z U I~ E- Z (0 LO 04 C.0 0 , 0) d O O O 0)NC N MO M C Chf~C4 N N CM CV ' M Lo 41 M M 0 4, co o 00 "0 C*l tr) O L 0 M Cfl Cl 1 C O M - N CM ~ O S NM ~ (D Lr) CO ti N c - O r M O LO C 7 LL L a) C U) a) U W O > C) N p Ce) U L N Z E U Q Cn W c) cf) Z L- O O U Co LL L H ? c U N Z E W co a) Q) U a) 00 0 CD OOO OCO 00mwMtiN N N 00 0 U)COOO Of- mm0''CD 00LO LO co O O O M Cn 0 O LO O) ~ O Co CA tl M LO ~ co O ti ti M LA Cfl O f` d• N O M "t ti, co O fl- r- r- N 't- N N N N N Cj 0 M ~ L r r te a) U a) a) O O c N U C L O a) O) C O tYn .L 'Q C Cn a) CU - C cn V U) m C Q U W-1fnQ vi a cu Y ~ C cu C6 U Y U c c m U 0) CL CU O-0 Na-0ctS -FD ' fB ~'o (D U CO O O_ C O U C O m a) O U • U U C N O (B (6 c U L O O O 0 I S E co ~ L (B O U w+ a) ca C m L U C C 0) O Q) Q. co ~ ULLZ) vim d O a) O) a) U w U _ L ~ O ~ .a 7 cu "O C O 0 O) T c0 .c E -0 Q E m -C a) m H IL Q N 4) U ~ ' a n m cu 3 L E aw a) (D U U a) a) 2 2 Q Q Q) 75 73 C C c c CL fl O_ 7 U U Q Q 4) U) Q) a) c c CU N O ti N C C C `O O Ea.UQ *t 4t *t t *t it *k a) a) m a) a) m m a) m L d O O d d O 7 X00 000000 Co m7mm mmmmmmw m c~UU UUUUUU o 2 H Deschutes County Bethlehem Inn (Fund 128) Threee Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Negative Interest Revenue Interest Payment TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Proiection Variance $ (2,725,000) $ (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 2,861,000 - (2,861,000) 8% 0% 2,861,000 - (2,861,000) 2,861,000 - (2,861,000) 8% 0% 2,861,000 - (2,861,000) 136,000 (2,722,510) (2,858,510) 8% -2002% 136,000 (2,722,510) (2,858,510) Exp. 36,000 5,843 30,157 8% 16% 36,000 36,000 - 100,000 - 100,000 8% 0% a) 100,000 - 100,000 136,000 5,843 130,157 8% 4% 136,000 - 100,000 NET (Resources - Requirements) - (2,728,353) (2,728,353) a) September 2010 interest expense - $1, 805.31 b) Recap of expenditures - inception through September, 2010 Land/Building (Amertitle) - July 2007 $ 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 210,440 Total expended $ 2,728,353 b) - (2,722,510) (2,758,510) Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of September 30, 2010 G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through September 30, 2010 Balance Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order #1 Change Order #2 Change Order #3 Change Order #4 Change Order #5 Change Order #6 Change Order #7 (not likely to occur) Change Order #8 Change Order #9 Change Order #10 Change Order #11 Change Order #12 Change Order #13 Total Paid through September 30, 2010 Balance Closure Fund I Projects Fund 611 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 - 19,656.00 261,525.00 182,516.00 444,041.00 255,317.56 176,308.57 431,626.13 6,207.44 6,207.43 12,414.87 "Cell 5" 2,097,140.50 3,290,779.98 5,387,920.48 14,302.54 24,885.69 152,500.00 1,332.00 45,095.00 152,500.00 148,958.89 45,095.00 14,302.54 24,885.69 305,000.00 148,958.89 1,332.00 2,486.98 26,000.00 2,318,647.71 1,983,230.82 335,416.89 225,000.00 5,167.76 3,200.00 6,354.75 3,877,056.38 3,202,139.17 674,917.21 225,000.00 2,486.98 5,167.76 3,200.00 6,354.75 26,000.00 6,195,704.09 5,185,369.99 1,010,334.10 Total of Engineering & Construction Contracts Original Contracts 2,339,009.50 3,473,295.98 5,812,305.48 Change Orders 215,163.21 579,921.65 795,084.86 Total 2,554,172.71 4,053,217.63 6,607,390.34 Paid through September 30, 2010 2,238,548.38 3,378,447.74 5,616,996.12 Balance 315,624.33 674,769.89 990,394.22 Notes: a) Additional landfill gas investigation per DEQ as part of a requirement to address offsite landfill gas migration. b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678 has been expended and reported as "Construction in Progress" on the County's CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction, Taylor NW, KN EX Co, Jack Robinson & Sons. c) To date in FY 2010, payment has been made to Central Electric Co-op: $13,311 for the Closure of Area A and $20,822 for Cell 5. Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2011 I I BOCC Conference & Travel Jul Aug Sep YTD Total Tammy Baney j Travel Meals - 20 j - 20 Accommodations j - 77 - 77 Mileage reimbursement - 240 - 240 Ground Transport/Parking - - - - Total Baney ! - ! 337 - 337 Dennis Luke Travel Meals - 56 37 j 93 Accommodations 77 76 ! 153 Mileage reimbursement- 282 178 460 Ground Transport/Parking - 17 - j 17 Total Luke - 432 292 723 Alan Unger j Airfare 1,133 - - 1,133 Ground Transport/Parking - - - - Total Unger 1,133 - j - 1,133 Total - BOCC Department j Travel Meals - 76 37 113 Accommodations - 154 76 230 Airfare - - - 1,133 Mileage Reimbursement j 522 178 ! 700 Ground Transport - ! 17 - 17 Total - BOCC Department - j 769 292 2,193 FY 2011 Budget 19,600 Percent of FY 2011 Budget Expended j 11.2% ! I BOCC County College Public Information - - 1,874 1,874 Office/Copier Supplies - - 33 33 Meeting Supplies - - 295 295 j - - j 2,202 2,202 9/24/2010 Building Services - 620 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital $ 310,000 $ 371,047 $ 61,047 100% Revenues Cleaning/Maintenance 22,503 15,325 (7,178) 25% Utility Reimbursement 2,075 5,913 3,838 25% Facilities Charge to State 44,499 29,170 (15,329) 25% Miscellaneous - 677 677 25% Interest on Investments 1,750 955 (795) 25% Building Svcs Indirect Chgs 497,810 497,807 - 25% Total Revenues 568,637 549,847 (18,787) 25% Transfers In 19,481 19,481 0 25% TOTAL RESOURCES 898,118 940,375 42,260 25% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance n/a $ 310,000 $ 371,047 $ 61,047 17% 90,012 90,012 - 71% 8,300 8,300 - 16% 177,996 177,996 - n/a - - - 14% 7,000 7,000 - 25% 1,991,229 1,991,229 - 240/6 2,274,537 2,274,537 - 25% 77,925 77,925 - 35% 2,662,462 2,723,509 61,047 Exp. 415,051 407,554 7,497 25% 25% 1,660,202 1,660,202 - 196,644 173,370 23,275 25% 22% 786,577 786,577 - 1,500 - 1,500 25% 0% 6,000 6,000 - 52,421 - 52,421 25% 0% 209,683 - 209,683 665,616 580,924 84,692 25% 22% 2,662,462 2,452,779 209,683 NET (Resources - Requirements) 232,503 359,452 126,952 - 270,730 270,730 Admin Services - 625 Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budge t Projection Variance RESOURCES: Beg. Net Working Capital $ 120,000 $ 70,480 $ (49,520) 100% n/a $ 120,000 $ 70,480 $ (49,520) Revenues Miscellaneous - 10 10 Interest on Investments 193 230 37 Admin Dept Indirect Chgs 220,435 220,706 271 Total Revenues 220,627 220,946 319 Transfers In-General Fund 10,000 10,000 - TOTAL RESOURCES 350,627 301,425 (49,202) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 25% n/a - 10 10 25% 30% 770 770 - 25% 25% 881,738 881,738 - 25% 25% 882,508 882,518 10 25% 25% 40,000 40,000 - 25% 29% 1,042,508 992,998 (49,510) Exp. 211,447 205,193 6,254 25% 24% 845,787 845,787 - 28,998 12,542 16,456 25% 11% 115,993 115,993 - 25 - 25 25% 0% 100 - 100 20,157 - 20,157 25% 0% 80,628 - 80,628 260,627 217,735 42,892 25% 21% 1,042,508 961,780 80,728 NET (Resources - Requirements) 90,000 83,690 (6,310) - 31,218 31,218 BOCC - 628 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital $ 100,000 $ 95,210 $ (4,790) 100% n/a Revenues Sale Map Photo or Copies 38 25 (13) 25% n/a Interest on Investments 175 223 48 25% n/a Admin Dept Indirect Chgs 90,205 90,316 111 25% 25% TOTAL RESOURCES 190,418 185,774 (4,643) 25% 40% REQUIREMENTS: Exp. $ 100,000 $ 95,210 $ (4,790) 150 150 - 700 700 - 360,820 360,820 - 461,670 456,880 (4,790) Expenditures Personal Services 84,386 83,513 873 25% 25% 337,544 337,544 - Materials and Services 24,224 29,268 (5,044) 25% 30% 96,897 96,897 - Capital Outlay 25 - 25 25% 0% 100 - 100 Contingency 6,782 - 6,782 25% 0% 27,129 - 27,129 TOTAL REQUIREMENTS 115,417 112,781 2,636 25% 24% 461,670 434,441 27,229 NET (Resources - Requirements) 75,001 72,993 (2,007) - 22,439 22,439 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance Finance - 630 Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 500,000 $ 573,333 $ 73,333 100% Revenues Investment Fee 20,000 12,484 (7,516) 25% COLES/CODE Contract 1,362 - (1,362) 25% Interest on Investments 3,000 1,184 (1,816) 25% Interfund Contracts 5,000 5,000 - 25% Administrative Fee 3,000 3,000 - 25% Finance Dept Indirect Chgs 206,969 207,223 255 25% Total Revenues 239,330 228,892 (10,438) 25% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 739,330 802,224 n/a $ 500,000 $ 573,333 $ 73,333 16% 80,000 80,000 - n/a 5,446 5,446 - 10% 12,000 12,000 - 25% 20,000 20,000 - 25% 12,000 12,000 - 25% 827,874 827,874 - 24% 957,320 957,320 - 62,894 25% 55% Exp. 1,457,320 1,530,653 73,333 216,698 206,288 10,409 25% 24% 866,790 866,790 - 68,011 90,868 (22,857) 25% 33% 272,044 272,044 - 2,500 - 2,500 25% 0% 10,000 - 10,000 77,122 - 77,122 25% 0% 308,486 - 308,486 364,330 297,156 67,174 25% 20% NET (Resources - Requirements) 375,000 505,068 130,068 1,457,320 1,138,834 318,486 391,819 391,819 a) Will be paid in June 2011. Legal-640 Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 90,000 $ 128,128 $ 38,128 100% n/a Revenues Sale Map Photo or Copies 75 140 65 25% 47% Miscellaneous 750 - (750) 25% 0% Interest on Investments 375 344 (31) 25% 23% Interfund Contract 3,750 - (3,750) 25% 0% Legal Counsel Indirect Chgs 188,658 188,658 0 25% 25% Total Revenues 193,608 189,142 (4,466) TOTAL RESOURCES 283,608 317,270 33,662 25% 37% Exp. REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 187,089 176,420 10,670 25% 24% 12,119 6,916 5,203 25% 14% 25 - 25 25% 0% 16,875 - 16,875 25% 0% TOTAL REQUIREMENTS 216,108 183,335 32,773 25% 21% NET (Resources - Requirements) 67,500 133,935 66,435 $ 90,000 $ 128,128 $ 38,128 300 300 - 3,000 3,000 - 1,500 1,500 - 15,000 15,000 - 754,632 754,632 - 774,432 774,432 864,432 902,560 38,128 748,357 748,357 - 48,475 48,475 - 100 - 100 67,500 - 67,500 864,432 796,832 67,600 105,728 105,728 Personnel - 650 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments Personnel Indirect Chgs Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Year End Projection Variance Budget Actual Variance FY % Coll. % Budget $ 290,000 $ 351,450 $ 61,450 100% nla $ 290,000 $ 351,450 $ 61,450 250 13,722 13,472 25% 1372% a) 1,000 13,722 12,722 1,500 831 (669) 25% 14% 6,000 6,000 - 181,333 181,333 0 25% 25% 725,330 725,330 - 183,083 195,886 12,803 25% 27% 732,330 745,052 12,722 473,083 547,336 74,254 1,022,330 1,096,502 74,172 Ex p. 150,269 144,919 5,349 25% 24% 85,039 28,025 57,014 25% 8% 25 - 25 25% 0% 20,250 - 20,250 25% 0% 255,583 172,945 82,638 25% 17% 217,500 374,391 156,891 601,074 601,074 - 340,156 340,156 - 100 - 100 81,000 - 81,000 1,022,330 941,230 81,100 - 155,272 155,272 a) Manley Services Payment Information Tech - 660 Statement of Financial Operating Data Three Months Ended September 30, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 435,000 $ 480,723 $ 45,723 100% nla $ 435,000 $ 480,723 $ 45,723 Revenues City of Redmond - - - 25% n/a - - - Miscellaneous 250 - (250) 25% 0% 1,000 1,000 - Interest on Investments 1,500 1,119 (381) 25% 19% 6,000 6,000 - Leases 5,250 7,048 1,798 25% n/a 21,000 21,000 - I T Indirect Chgs 505,811 505,811 - 25% 25% 2,023,245 2,023,245 - Total Revenue 512,811 513,978 1,167 25% 25% 2,051,245 2,051,245 - Transfers In-General Fund 16,500 16,500 - 25% 25% 66,000 66,000 - TOTAL RESOURCES 964,311 1,011,202 46,891 25% 40% 2,552,245 2,597,968 45,723 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 456,439 452,592 3,847 25% 25% 1,825,757 1,825,757 - 130,719 120,072 10,647 25% 23% 522,877 522,877 - 25 - 25 25% 0% 100 - 100 50,878 - 50,878 25% 0% 203,511 - 203,511 TOTAL REQUIREMENTS 638,061 572,665 65,397 25% 22% NET (Resources - Requirements) 326,250 438,537 112,287 2,552,245 2,348,634 203,611 249,334 249,334 IT Reserve - 661 Statement of Financial Operating Data Three Months Ended September 30, 2010 RESOURCES: Beg. Net Working Capital Revenues Interest Interfund Contract IT Reserve Charges Total Revenue Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 161,896 $ 212,360 $ 50,464 100% n/a $ 161,896 $ 212,360 $ 50,464 500 464 (36) 25% 23% 2,000 2,000 - - 3,400 3,400 25% n/a a) - 3,400 3,400 58,500 58,500 - 25% 25% 234,000 234,000 - 59,000 62,364 3,364 25% 26% 236,000 239,400 3,400 TOTAL RESOURCES 220,896 274,724 53,828 25% 69% REQUIREMENTS: Exp. Expenditures Materials and Services 18,500 - 18,500 25% 0% b) Capital Outlay 31,000 39,771 (8,771) 25% 32% b) Res for Future Expenditure 49,974 - 49,974 25% 0% TOTAL REQUIREMENTS 99,474 39,771 59,703 25% 10% NET (Resources - Requirements) 121,422 234,953 113,531 397,896 451,760 53,864 74,000 74,000 - 124,000 124,000 - 199,896 - 199,896 397,896 198,000 199,896 - 253,760 253,760 a) From Solid Waste TO: BOARD OF COUNTY COMMISSIONERS FROM: DAVEINBODY SUBJECT: FY 2011 SPAY AND NEUTER GRANTS DATE: 10/28/2010 CC: DAVE KANNER, ERIK KROPP Background Beginning in November 2007, the Deschutes County Dog License and Pet ID Application provided for licensees to contribute additional funds to spay and neuter programs in Deschutes County. These funds are offered in the form of grants to non-profit organizations in Deschutes County offering spay and neuter services. In November 2008, the first spay and neuter grants were awarded to the Bend Spay and Neuter Project and the Humane Society of Redmond totaling $4,000. These grants were funded by $2,000 from licensee contributions and a $2,000 match from the Board of Commissioners through the Video Lottery Fund. Applications were reviewed by two members of the Dog Board, Judith Parker and Laurel Pierson, and Dave Inbody, Assistant to the County Administrator. In 2009, a total of $5,000 was awarded consisting of $2,500 from licensee contributions and a $2,500 match from the Board of Commissioners. Funding Obiectives This grant has the following three primary objectives: 1. Expand spay and neuter services in Deschutes County in an effort to reduce the number of unwanted dogs and cats in the county 2. Provide promotion or education associated with spay and neutering services 3. Outreach to provide services for those who would not otherwise undertake the procedures due to financial constraints or physical limitations. Eligibility for Grants Requirements for applicants to the community grant program: • The applicant must be a 501(c)(3) tax-exempt organization. • The organization must be located in Deschutes County. • The proceeds from the grant must be utilized in support of Deschutes County residents. • All proceeds must be used for expenses associated with direct spay and neuter services or spay and neuter education or promotion. FY 2011 Grants This year contributions from dog licensees and pet ID applicants totaled $2,397.60. It is requested, similar to previous years, that the Board of Commissioners provide additional funding in support of this grant. A grant of $2,602.40 is requested which would create a total amount for spay and neuter grants of $5,000. The criteria for selection will be the following: 1. Stability and solvency of the organization 2. Ability of funds to provide leverage for receipt of additional funding 3. Program connection to grant funding objectives A press release will be used distributed soliciting grant applications. This release will also appear on the website. Additionally, letters of notification will be sent to last year's recipients, as well as the Humane Society of Central Oregon and all known veterinarian clinics and hospitals in Deschutes County. Deschutes County Spay and Neuter Grant Application Complete this application form and return it, along with a letter from the IRS granting your organization 501(c)(3) tax-exempt status, to the following address: Dave Inbody Deschutes County Department of Administrative Services 1300 NW Wall Street, Suite 200 Bend, Oregon 97701 Applications may also be sent via e-mail to davidi deschutes.orq. All documentation must be received by December 3, 2010. Any applications that have not completed all requested documentation will not be considered. No information or materials in addition to that specifically requested in this application will be considered. Contact Information Organization Name Address City Zip Code Phone Number Alternate Phone Number Fax Number Website E-Mail Address I certify that the all information provided to Deschutes County is correct and that I am authorized by the governing board of this organization to submit this grant application. Further, I certify that this organization is in good standing with the IRS and retains its official 501(c)(3) tax-exempt status. Additionally, I certify that this organization is located in Deschutes County and any proceed from this grant will be used in support of Deschutes County residents. Print Name Signature _ Title Date Organizational Information In order to be considered for this Spay and Neuter Grant please provide the following pieces of information: 1. Briefly describe the history of your organization (max 150 words): 2. Provide the Mission of your organization 3. Describe the leadership and structure of your organization. If there is a board, include the names of its members (max 100 words) 4. Briefly describe the primary activities conducted by your organization (max 150 words 5. Provide total expenditures for the most recent 12-month period (the most recent full fiscal year may be substituted) 6. Provide total financial support received during the most recent 12-month period (the most recent full fiscal year may be substituted) 7. Describe the specific program or project that this grant will support (max 150 words) 8. Describe how this program or project will positively impact the goal of promoting or expanding spay and neuter services (max 100 words) 9. Explain the anticipated outcomes of this project or program and describe how success will be measured (max 100 words) Y Y 0 a' v ° o a) z CL CL a, m O o y m e al E a m c E 3 o ° a` > Q w m -°y r- E c c v '0 u v oa 'o > m a m co 0 a m m v E c oo o r o o c` 0 E O al 'p 00 N, O fa U- U yi E cm m "Cu L a Q 3 u 0 to C 000 d c u S a) m co o` O o Y g ra (U a EL E m a c 'm ots r- :3 co 0) fa O 2 3> 7 t O O O p z m O 'L-^ y N co N •c N E `c E 4 c v v c y N c N Li CC Z u° Ln Lu u° 3 v cc u° Q° 0 t-- H U U 3 ca E E O H 0 0 0 0 w of r Cl 0 0 000 VJ C O N C N !L^ V cu c 0 U N Q O O N r r ~ C N o }O LL O H Q 0 0 0 0 0 0 0 o O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ln o o w o LO o O o Ln Lo N (N .--I e-4 N M .--4 ei N e•L 14 V} A^ A^ A^ In V1 V) V} to V} V} to to A^ V) V! Vf to in Vf V► V1 V? O O O O C) O O O O O O O O O O O O O O 0 0 0 0 O O O O O M O O C O 0 0 0 O O O M O O O O Ln Ln Ln to Ln O M O t!1 Ln N ci -4 N to N U} V► V1 V1 V? VT V1 V1 Vf to V} V1 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O 0 0 0 0 0 0 0 O O O O O O O 4 O O O O 0 0 0 0 0 O Ln M 0 0 0 0 Ln O Ln Ln Ln Ln N m O Ln Ln r-4 V► V} V} V1 V) V} V~- V} In V~- V} V} V} V^ V? 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ' o 0 o M ' o 0 O O O O O 0 0 Ln en O O O Ln Ln Ln O 00 O N M Ln N to V). V} Lf Vf V► V► V* vs• V). V). v* V). in AA. O O O O O O O O O O O o O Cl O O -It O O O O O O O O O O O O O O O O O O O O O O LO O O O O O O O O O O O O O O O O O O O O O O m O O O O O O 0 0 0 0 0 0 0 0 0 0 0 Ln a O O O N in O O O O O O O O O Ln O I O Ln 0 0 Il O O W O M rL O " 0 Ln O IT N W N N Ln N %D r7 r/ M 'i N ei .4 Ln Ln Ln m M N N N 'i fA ug~ VL V). V} V1 V1 Vf to V1 V) Vf V* V? Vf to V1f V► V* in V~- V? V► 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .-L i-7 ,y ei 'p 0 e-1 'y O O O O O O O O O 0 0 0 . 0 0 ° O O O 0 0 0 0 N N N N N N N N N N N \ N \ N \ N \ N \ S \ \ \ \ N \ N N N \ N N N N N N N N O O O O a a ~ ~ ~ ~••L '-L '-L '-L ~ e-L o co 0 0 co ao W m m W m W m \ m ; \ 0 \ 0 \ o O \ \ \ \ \ \ \ 0 0 2 14 ~q 1-4 1-1 1.4 14 1.4 c 0 Y 0 0 W CU H N fa T c c C L O > u L « m O p U c a, v ~ E E o rn E c L c y c m T r rt7 E E o c $ U E m E L 0 lL 2 '6 Lp r F" W 0 E U > u (g A N LL 0 U d N' p > E E is > Q u a OJ > 000 4 O 0 W tip O a c O E E at _ 0 v Q E ° w a) D 0 m co o c0 ~ M y u a m LL ° 5 E y L E E o c 3 m E y ' d F E) m O o a 3 v c Y co v H o = o c • v . 3• L 7 LL U m u D U ° N U d m > N co O 0 c ` m o O o . ° aa) tw a o 0 O ; a m c O a O f m a 0 E ca > a' E L c y > L L E Y E t 00 C Ol m C N W LO N rn ' _ N V C v G E C N W N > ° a c c E N m 3 7 0 ca 0) m N m (D 3 ly z x Ln o 0 u u oc o -1 u 0C W 0 0 0 0 al = Y 7 J m a c m m L0 m N m 7 a N m c a O A D D M M D ID b* D D N to A D D ri 61 LLY LO N N N D7 a i 0 ;a La LL 0 o °i n o O co co F- co M 41-b. Oil 611, C) C, CD O O O O v v C) CN C4 It O Y q 3 O er 64 fA 0. O O C. CD 0) a; C) C) all O N N c o r. to (fl to 00 0 00 (D 00 Go L0 'ao °o 00 a ~a O O' m ~ E9 f~9 /A r' O N r N N m U LL U. O H La H m 0 LL u L m O m m v c R to m 00 O O M d O) SC 'A CO m m _d ~ d lC E O a a e