The URL can be used to link to this page

2012-55-Minutes for Meeting January 30,2012 Recorded 2/10/2012DESCHUTES COUNTY OFFICIAL RECORDS r} ~~~~~CJ~ NANCY BLANKENSHIP, COUNTY CLERK yJ COMMISSIONERS' JOURNAL 02/10/2012 08;05;30 AM III all 2032-35 Do not remove this page from original document. Deschutes County Clerk Certificate Page 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, JANUARY 30, 2012 Present were Commissioners Anthony DeBone and Alan Unger; Commissioner Tammy DeBone was out of the office. Also present were Erik Kropp, Interim County Administrator; and, for a portion of the meeting, Dave Inbody, Administration; Marty Wynne, Finance; and five other citizens. Chair DeBone opened the meeting at 1:30 p.m. 1. Finance/Tax Update. Marty Wynne said there was an announcement by the federal government laying out a plan to keep interest rates low through 2014. Rates have dropped since then and it is unlikely they will increase. The investment return shows the yield at 0.79, which is good for the current marketplace. Most investments are about half of that. The general fund has changed; departments are being asked to forecast year- end, resulting in some variances. Behavioral Health shows few changes but there is a possibility of having to make a reimbursement to the State. The ABHA audit was also completed, showing the beginning net working capital number as incorrect. Ramifications may occur if the County leaves the program in regard to whether some of that funding should go to the County. Community Development's revenue for the overall year so far is showing better than anticipated in the second half. The Fair/Expo may experience a small negative variance the end of the year, based on beginning net working capital. Mr. Kropp said they might spend out of operating funds rather than reserves unless there is a shortage. The big unknown is the North County Campus project and whether the State will participate. This also relates to the Bethlehem Inn fund. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 1 of 7 Pages 2. Review of Economic Development Grant Requests. Dave Inbody gave an overview of the requests, and advised the Commissioners of the amount they had left to grant. He said the total amount requested at this time is about $30,000 and the amount left in the accounts for all three Commissioners is approximately$23,000. There may be about $75,000 additional coming from the State that was not budgeted, but this will not be known for a while. Deschutes Soil and Water District ($2,400) - Outreach Assistance: Spring Alaska Olson of DSWCD, and also on the Weed Board, said they all have issues that need support. They provide educational opportunities, but never actually been funded to be there. The Dept. of Agriculture funds some work, but does not allow them to discuss noxious weeds with the public. They want to find a way to be paid for the costs of this kind of outreach. Commissioner Unger noted that the entities need to work together to multiply the effect. He is interested in the big picture. Rex Barber of the DSWCD added that the Oregon Dept. of Agriculture is the State funding source, but they say they can only deal with agriculture water quality, and are not supposed to address weed issues. They are often on sight working as the SWCD on water issues, however, and this is a good opportunity to address weed issues. William Kuhn of the DSWCD indicated they did site visits and it was not that they do not respond, but they cannot do anything to get something done in these cases. They would like to get funding or write a grant for something that does not directly deal with the water. They are supposed to be dealing with the soil, and other aspects as well. Ms. Olson added that this could help get the County weed group more involved as well. Patricia Gainsforth of the DSWCD stated their allocation of direct dollars comes from the ODA. They are trying to stay clear with the funding track, but support the whole concept. It is also important to hold the tri-counties together. They are also linked closely with private or production land, and hope to make people working and living off the land be more productive. Ms. Olson added that they are being asked for assistance at various levels, private and government. Commissioner Unger wants to support these efforts, and would like to see a whole program to address weed, soil and water issues. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 2 of 7 Pages Commissioners DeBone and Unger granted $950 each, and Commissioner Baney had indicated she would grant $500. La Pine Community Action Team ($2,400) - La Pine Gap Network Program: This would coordinate human services efforts; it would be a clearinghouse that would unite the efforts of churches, government and other organizations to help with public needs. Commissioner DeBone said that this is part of the Partnership to End Poverty. This is important because there is St. Vincent DePaul and the Community Kitchen, plus other agencies in the area that need to work together, and there are gaps in what is provided by each. Commissioner Unger stated that it is important to coordinate the groups. The three Commissioners granted $800 each. Humane Society of Central Oregon ($2,598) - Two AED's: Dave Inbody indicated that this would be for their facilities since they deal with the public, and think they should have these AED units on hand. Commissioner Baney had indicated she feels this is an operational expense, and they receive enough funding that way already. Commissioner Unger granted $500 and Commissioner DeBone granted $700. OSU/Deschutes County Extension ($2,000) - Living on a Few Acres Conference: Ms. Olson said that this ties in with the Upper Deschutes Watershed group's work as well, since some of the same people are involved with both groups. Commissioner Unger said that the goal should be to have small farmers be more successful and keep things local if possible. Ms. Olson stated that a conference will occur later this year at which they hope to educate farmers on what they can and cannot do in this regard. Commissioner DeBone said the South County group is discussing this issue, and things like developing a greenhouse project. Commissioner Unger granted $1,000; Commissioners DeBone and Baney granted $500 each. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 3 of 7 Pages Bend Heroes Foundation ($9,000) - Honor Flight of Eastern Oregon Commissioner DeBone stated this has to do with the World War II group. Commissioner Unger said he wants to support veterans in general, for housing, health care and other needs. He does not feel it is appropriate to fund a flight back to Washington D.C. when there are so many other local veteran needs. The Commissioners granted $2,700 ($900 each, for three attendees). CASA of Central Oregon ($2,500) - Voice of Hope: Dave Inbody said these funds would be used to help recruit and train additional volunteers and support the existing volunteers. They already get $30,000 from the County as a community partner. Commissioner Unger said that almost all are volunteers and it is an important program. Many programs would cease to function well or at all without the help of volunteers. Commissioners DeBone and Unger granted $1,000 each. Network of Volunteer Administrators ($1,500) - 2012 Volunteer of the Year: Dave Inbody indicated this is to support the annual event to recognize the work of volunteers. The Commissioners granted $500 each. Tri-County High School Rodeo ($2,500) - 2012 Tri-County High School Rodeo: Commissioner Unger asked about the purpose of the funding. He thought it was to offset costs of renting the facilities. The three Commissioners granted $500 each. Greater Redmond Historical Society ($3,000) - Redmond Museum Computer Network: Commissioner Unger stated they are trying to get their museum going. This function used to be funded by the City, but the City cut it from their budget, so the group became a nonprofit to be able to apply for other funds. Commissioner Baney granted $1,000; Commissioners Unger and DeBone granted $500 each. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 4 of 7 Pages Sisters Outdoor Quilt Show - $1,500 - Quilt for Two Rivers: Mr. Inbody said that this group has some grant funding identified, but are seeking additional funds, and hope to get a match. Commissioners DeBone and Unger granted ,$500 each. La Pine Rodeo Association ($1,000) - 2012 La Pine Rodeo: Commissioner DeBone said this group needs to do more planning as to where the advertising dollars will go. He would like to know the status of the possible acquisition of land they have requested. The need may change in the future. The Board put this on hold for now. 3. Review of Spay/Neuter Grant Awards. Dave Inbody said that some funding comes from the animal control fund; the rest from public donations. The selection committee discussed whether equine gelding is appropriate, based on objectives. The justification was that it was not a consideration before, but due to the large number of abandoned horses, it has become an issue. Bend Spay & Neuter and CRAFT provide more direct services to the public. The two shelters back-fund some of this work, but do not provide that much direct services to the public. Commissioner Unger feels that Redmond continues to ask for help to operate, and he is concerned how they plan to function in the future. They have a new board president, who has been asked to explain how they can begin to live within their means. There seems to be more involved than just a cash flow problem. He is prepared for them to go bankrupt if they cannot get their house in order. Commissioner DeBone agreed. Commissioners DeBone and Unger support staff's recommendations regarding the spay/neuter grant funds. UNGER: Move approval of distribution of the funding as recommended by the selection committee. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Chair votes yes. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 5 of 7 Pages 4. Commissioner Retreat Planning. Erik Kropp asked if the Board wants to wait until a new Administrator has been selected or is on board. There are a lot of variables. Commissioner Unger suggested they move forward with this, because the new Administrator would not be able to provide a lot of input as a new person, if even here by then. Mr. Inbody said the goals can change each year, or are refined over time. Mr. Kropp added that they need to discuss the economic development fund and its criteria; how to handle the Bend Airport; and address health reform if there is time. The budget committee has recommended some decisions be made prior to the budget meetings taking place; in particular RAC and weed issues. The Board wants to go forward with the retreat regardless of when the new Administrator comes on board. There are other issues such as 19th St., SDC's, the land near the Fairgrounds, the history of the Welcome Center exchange, bonding projects, and additional topics. Mr. Kropp would put a list together in advance so everyone can be prepared. He suggested two half-days might work best. 5. Other Items. Erik Kropp said he talked with representatives of the City of Bend about a possible fund to help the Bend Airport. Commissioner Unger indicated that more needs to be known about efforts made to this point regarding developing the airport, and how the City would make any changes work. They need a successful plan while protecting the current users there. Mr. Kropp asked about discussing expanding the Redmond or Sisters enterprise zone, either at a work session or a business meeting. Commissioner Unger said if a city wants to do this, he is supportive of them going ahead with it. Commissioner DeBone agreed. There was a brief discussion regarding the interview process for County Administrator later in the week. Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 6 of 7 Pages In regard to the recycling center in Sisters, Commissioner Unger said things have changed since it has become easier for the public to recycle. He feels they should also look at a transfer station where there can be a fee charged for regular waste disposal. The City wants the County to continue to partner and fund the recycling center. The executive session planned under ORS 192.660(2)(e), real property negotiations, was delayed until Wednesday afternoon. Being no further discussion, the meeting adjourned at 4:40 p.m. DATED this Day of 2012 for the Deschutes County Board of Commissioners. Anthony DeBone, Chair 6~L- 0,+~ ATTEST: &"A-~ &ktlt- Recording Secretary Alan Unger, Vice Chair Tammy Baney, Com issioner Minutes of Board of Commissioners' Work Session Wednesday, January 30, 2012 Page 7 of 7 Pages N i H o C 1 \Vx` ~~l U_ u ti N ~ a h Q 1 `X~~ ^ Vd M • \ ~ 9 ~ ~ cd o. y ~ E ..~c ro z o ~ ej I o C a 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, MONDAY, JANUARY 30, 2012 1. Finance/Tax Update - Marty Wynne 2. Review of Economic Development Grant Requests - Dave Inbody Deschutes Soil and Water District ($2,400) - Outreach Assistance • La Pine Community Action Team ($2,400) - La Pine Gap Network Program • Humane Society of Central Oregon ($2,598) - Two AED's OSU/Deschutes County Extension ($2,000) - Living on a Few Acres Conference • Bend Heroes Foundation ($9,000) - Honor Flight of Eastern Oregon • CASA of Central Oregon ($2,500) - Voice of Hope • Network of Volunteer Administrators ($1,500) - 2012 Volunteer of the Year • Tri-County High School Rodeo ($2,500) - 2012 Tri-County High School Rodeo • Greater Redmond Historical Society ($3,000) - Redmond Museum Computer Network • Sisters Outdoor Quilt Show ($1,500) - Quilt for Two Rivers • La Pine Rodeo Association ($1,000) - 2012 La Pine Rodeo 3. Review of Spay/Neuter Grant Awards - Dave Inbody 4. Commissioner Retreat Planning - Erik Kropp 5. Other Items Executive Session under ORS 192.660(2)(e), real property 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), litigation; ORS 192.660(2)(d), labor negotiations; or ORS 192.660(2) (b), personnel issues. Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA January 30, 2012 (1) Monthly Investment Report (2) December 2011 Financials rn M 0 CCOO E T ~N V r } = o N C Cc to N d ~ E cc O M C4 - CO 0 M > M ' M M o E COO COO M w V N N C o Oi C O Co (o o c CV) ri CN CM ~ m m U fA h E Z . 0 a m C C E O o u U C O >4 M LO W w m N m C C O LL (A £ 9N> 0 J C C C O .CY c MO- N 0 e ~Oog°O O O 00 b 0 0 0 O O~V.Orr.,CDw O V. M N N M ' Q r ' Ci ' M r M CO CV CD O 0) C07 - N W N O OIM N COI N V. to 1 N N C d N N y a C a o m a NZ ~8U O OQQF- m 4) m 120 C E O V F- m y m E& 4 ai O C a 0 0 Cq 0 0 O UUF-:j tLm -j H Cn N CO m N C CV Dwument Reproduces Poorly (Archived) ee ee e o e o 0 oo 0 0 T T ~n~nooo 1 N N N T In E L m ` « ° y a to K N cis •U O' w O.O. a (a CL 0 ~ O 4) NO c0 Z Q Q Ca p 2 ` m N m O) F- L N E O a » m E e m UV C -i ti H H _ N m a> C o n CL d LL Q F- a r C d w ~ CC E O U N d 1-rCO C U m m O f6 N o `02 CL O p O Z r U O a IL o m A aco O J H z~ V U U U U U U U U U U U U U U U U U O U O D U V U O U N O U > N . o ° o o ° o O X p z z z z z z z z z z z z z z z z z 04 z m z z m z m z ~ z m o a ~ o ' c 0° c d 7 " 7 : ' M 7 - 0 ° '4 c o o Z G v O a Q O O o V O O V' m n CO n (D V' V' Co W m O O r m r O M M m W 00 n M In m 00 r (o C) O m M 0) 0O V V O O N N O O M M M M 0 O 0) n o Cl? co V' M c0 m 00 co rn V' o) V• co M c0 O C O O O (D O IT M CO M 0) v V' 00 It co co O O M N O M Co CO CO N O M co m W co N N Q) (o In o0 00 0) n C3 O I~ M O O M co M M o M O O O o N N W co O) 00 M O N O 0) V (n Ln r O N r V' O M N n N 0 co N lD n W V 00 N O Cl CO O Cl Cl O V C) N n ' V r Q1 M r 7 E O M lD N ' V' ' N co n N n V' O ' (n 00 00 Lo V' m ui n N N 00 O O M CD N co O 10 y /0 O M t N V O V N N O N C O M O _ O O W O N M O N V ^ O M O N O N O (n O N N C N C N O O N O d' N O co V' 0) O M m o) (O co 1 Co M m N Of t0 > ~L ; N N N N N N N N N N N N N N N N N N N M CO o f 0 N 41 N O M C V' O N OO Ifl fA N r O co It O 0 O 0 M c'M M Cl) O O O a O C) n O Cl) U') O C. 0 O 0 O 0 O m O C) O 0 O 0 O 0 O N N O O n O 0 O 0 O C) O (n CO O O r W 00 M m V n O CO O O n M o c) C) m 0 0 0 0 co n O N O O N 0 (D O O O m O M N W c0 jp (o N (D V' to M W N V (O N O V' O N r It M O O M V O V' co V' W Ify N CO O > ~ l0 m (0 00 cc V n v O 8 m C M n (o n v (D N O co r n co O W O cl~ "It O (n O N V' 0) d• O g co cm 00 N O O N N O O O W O M 00 O O co co O a y M CO V O O O O In O M M V O O N. O O co O co N O V' d1 0) M co y O N O N O C c 0 0 0 C C Ci 0 0D O N 0 0 0 0) r Cl O O If) 00 N N N N N N N N N N N N N N N N N N m N V (D N O O O O O O O O O O O O o a C) 0 0 0 C) C) 0 C) C) 0 0 0 0 0 0 00 00 m N W O O C) O O O O O O O O O . O O C) 0 0 0 O O O O O O O O O C) M V' O O U O O O O O O O V' CD C) 0 0 0 C) 0 co 0 co 0 O 0 O 0 O 0 co V' m O V' O C) O 0 CD 00 V 0 0 0 0 C) 0 C) 0 C) 0 0 0 C) 0 0 Ci 0 C) C) 0 C) m N N 00 00 m N ~p O O O O O O N V O O O O V Q7 C1 O V O O O O V' (0 (n M M r O O O O N v n n O 0 O V O O O O O O O O V' 00 0 O 0 O 0 O r N O CO CN! O It O C O M V' N V' O O O O V' co (n m V' 0 0 m m N 0 0 0 0 l0 O V' O C3, 0) M N •W C N C N O o 0 0 0 - r 0 0 0 W D1 N 0 0 0 0 0 cc O N O N N N N N N N N N N N N N N N N N N N V co co r M N U • CL N N O m C m a N o c 0 a ~ d E 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 o e o ~p z ( ~ v ' 0 O 0 (A 0 m 0 n 0 O 0 c0 N M c17 0) V' 0 O 0 In 0 O 0 O 0 0 0 (0 0 co O 0) 0 0 0 0 ' 0 0 0 0 N O O H) m r 7 N 0 ¢ ¢ d p N O O n t0 r w M M O 00 O O N O O (0 00 00 N n O n O 1n O M O O O V D l0 O 47 r V l0 (D O) n O in If) r N t0 0 N V N m > C ~ C) Ci ~ o o o o a a - - o o o o C) - - Ci Ci o ~ Ci o Ci o CD c o E on o a) l0 o Y a E o `o E w - U U 1- l1 m H o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c C d n O O C) 0 0 0 0 0 0 0 0 O 0 0 0 O CL . m r> O o N (D C) o LL7 n lf) " O 00 M v V 00 (n (o 0 rn 0 (n O (D V (o O n O n U) n 0 N O V' (n N U') O M O U) O O (o O O r U c d E w Ci 0 N d o o d a) E. O a O >c • c y K C a ) N C E w Y o N ~ H O O N O) D) M M W r oo O (N o r V' M W LL7 n (0 O C N > > m N ¢ C m G O (n r O o O n U') .4 u7 ir) O Lo n (O co M m n m co N r N O O V' M n M r D) O n M r N Lo M r M n M n M n IT co M M n M N E Z o r m N d N N N N N N N N N N M M M M > > O C N N N M M M M M M M co Co M M M N 0 o n n n a o o Z;5 o o n rn m n o v u~ rn o w m N o o r~ I ~ m Q O N O o O O r h N O M M O O \ M M O - N O N N N O O O N ry -m _ (p I, U ~ E g o o ( o W O ` O r- O O M O M O O O O O o o o M 0 V 0 V' 0 V O O O to O co O co O 1, O 00 O cn O N - N > ¢ r O V 0j 0 H J m - H N 0 0 0 0 0 ~ ~ O O O ~ L f~ M c0 O N c`') _ E) M V _ 00 00 _ O N N N O 00 O) c~ co N lI7 IZl O N N N O O ~ O N N O M M e- N N N N N N ~ N O N r 0 N N N N (h N Q1 O V' ( ( In V V it7 co co I~ O N N N CL o o - v ~ o o o o o o ~ ~ o ~ o o o o o ~ o o o o ~ ~ Q U Q LL m ' m z > H a ¢ a z a c m m c~ c~ x x a a m N fA m o ~ m c~ c~ ~ ~ ~ adA L 0 a a < 0 0 0 0 0 ¢ ¢ ¢ U ¢ U . LL LL LL F- F- 0 U U U L i l i t i LL I i . LL F- LL a U d Z 3: a Z Z Z a LL LL LL ¢ m LL w ¢ Z ¢ ¢ > Z H , LL ¢ w z )Ju@g D m D (n a (n (n N 2 ~ ~ U w 2 0 0 0 U U w o w a U U w N J O W V } C1 Q) S 00 Y V' 2 M } 00 U co LL M J V (o LL W Q 10 Y w Y 2 X (7 ¢ (h a N (7 ~ X co m a co (9 Z X ' n N N N Y _ 3: w d M X M Co c'7 U M co w co CO O U V' n r co U n U (O U (0 N M CO M O 0) (n m CO NN CO 0) N M co O 04 co M U M M M (h co M M M M n M D j co M rn M M N O O O U Q U U U U Q ~ U U 0 U N C y N : + m U 0 ' 1 U U O U m c ~c . Q. • U) U V ym•, m m • c U y N m U N 7 m m (a c.) 7 C m m C, 6 N u! ` V cQ 0 y 0 y c 0 U a m a m D. m y C y C M 'o C C m f0 O y C m N m U V a) m d YO N m N 7 m 0 0 m T °f c -.,e c N ct~7 f a .m. O V C y m o V) C) . y U U c U U m c U U U m m 7 y C m co E N L y N m m m O) U Q T Z cm w C 7 t Q y N y m y Y m C U C U C C~ N LL Z m co p U N ¢ ° ° m p m d N LL C ' Z m > N O) m ' Co LL 0 N m ` N C c m U c m N c m c m y v v N o U c > O m y Y d E o m o E p ° L C - v N d y E o a N C) U y H 0) m N m a) > m CO N 'O m N N N (n x N - m EP, (n c c in m 7 o E o L o . U m m a E N c E 0 0 -a N E m m ` m co LL W W W W .5 m m N O m m m m U U 2 N Y a C a w N W O O O D m m U U 0 LL H [ ar p 7 • 7 C 7 U 7 D c a) l` f`0 m U o > U LL ¢ L E Q Z 4) y C m J E , . m J m U ~ J E 0) c 0) r m C E j ' m I ) m ~ J L O y m J .i g J 2 3 W N Y y O) C E m E _ ~ E S LL 2 E O O N - N a) O 75 L-L 'C 2 m 7 O = .m.• 2 m z O Z W A T J m ~ LL d D LL I LL LL J 2 (D (D o (7 = U LL d- U- 3: (n LL 3: LL U LL J m H Memorandum Date: January 19, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find December 2011 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), 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 GENERAL FUND Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Revised Year End $ Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 Revenues Property Taxes 10,050,484 18,693,028 8,642,544 50% 93% 20,100,967 20,800,967 700,000 Gen. Rev. - excl. Taxes 1,191,161 1,548,728 357,567 50% 65% a) 2,382,321 2,382,321 - Assessor 395,498 427,577 32,079 50% 54% b) 790,996 790,996 - County Clerk 734,354 701,062 (33,292) 50% 48% 1,468,707 1,412,207 (56,500) BOPTA 6,199 8,236 2,037 50% 66% b) 12,398 12,398 - District Attorney 149,335 116,875 (32,460) 50% 39% c) 298,669 325,676 27,007 Finance/Tax 96,950 128,057 31,107 50% 66% b) 193,900 193,900 - Veterans 30,671 17,544 (13,128) 50% 29% 61,341 64,351 3,010 Property Management 48,100 50,100 2,000 50% 52% 96,200 96,200 - Grant Projects 1,000 1,000 0 50% 50% 2,000 2,000 - Total Revenues 12,703,752 21,692,206 8,988,454 50% 85% 25,407,499 26,081,016 673,517 TOTAL RESOURCES 20,003,752 29,937,931 9,934,179 50% 92% 32,707,499 34,326,741 1,619,242 REQUIREMENTS: Exp. Expenditures Assessor 1,702,650 1,617,430 85,220 50% 47% 3,405,300 3,305,300 100,000 County Clerk 711,983 497,079 214,904 50% 35% 1,423,965 1,223,965 200,000 BOPTA 36,201 26,240 9,961 50% 36% 72,402 72,402 - District Attorney 2,439,648 2,207,601 232,047 50% 45% 4,879,296 4,511,771 367,525 Finance/Tax 406,824 383,666 23,158 50% 47% 813,648 813,648 - Veterans 131,058 125,462 5,596 50% 48% 262,115 260,100 2,015 Property Management 128,832 126,942 1,890 50% 49% 257,664 257,664 - Grant Projects 59,358 57,503 1,855 50% 48% 118,715 118,715 - Non-Departmental 908,481 491,716 416,765 50% 27% d) 1,816,962 1,816,962 - Contingency 3,363,361 3,363,361 50% n/a 6,726,722 - 6,726,722 9,888,396 5,533,638 4,354,758 50% 28% 19,776,789 12,380,527 7,396,262 Transfers Out 6,465,355 6,512,538 (47,183) 50% 50% 12,930,710 12,930,710 - TOTAL REQUIREMENTS 16,353,751 12,046,176 4,307,575 50% 37% 32,707,499 25,311,237 7,396,262 NET (Resources - Requirements) 3,650,002 17,891,754 14,241,753 - 9,015,504 9,015,504 a) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823 b) A & T Grant received quarterly-July, October, January & April c) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes three months of receipts) d) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Year r End Bud et g Actual Variance FY % Coll. % I I Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,101,374 $1,099,010 $ (2,364) 100% 100% $1,101,374 $1,099,010 $ (2,364) Revenues Federal Grants 5,000 2,100 (2,900) 50% 21% a) 10,000 10,000 - SB #1065-Court Assess. 25,000 24,515 (485) 50% 49% 50,000 50,000 - Discovery Fee 7,500 5,769 (1,731) 50% 38% 15,000 15,000 - Food Subsidy 12,500 10,468 (2,032) 50% 42% b) 25,000 25,000 - OYA Basic & Diversion 108,749 94,675 (14,074) 50% 44% c) 217,498 355,730 138,232 Inmate/Prisoner Housing 44,245 24,600 (19,645) 50% 28% d) 88,490 60,000 (28,490) Inmate Commissary Fees 50 - (50) 50% 0% 100 100 - Contract Payments 35,000 41,478 6,478 50% 59% e) 70,000 100,000 30,000 Miscellaneous 30 169 139 50% 282% f) 60 200 140 Program Fees 20 - (20) 50% n/a 40 40 - MIP Diversion Fees 150 665 515 50% 222% f) 300 825 525 Interest on Investments 3,750 4,425 675 50% 59% 7,500 7,500 - Leases 1,200 600 (600) 50% 25% g) 2,400 1,200 (1,200) Grants - Private 250 300 50 50% 60% 500 500 - Behavioral Health 3,000 138 (2,862) 50% 2% h) 6,000 331 (5,669) CFC Interfund Grant 77,064 33,655 (43,409) 50% 22% i)j) 154,128 134,620 (19,508) Gen Fund Grant-Crime Prev 10,000 5,000 (5,000) 50% 25% j) 20,000 20,000 - Total Revenues 333,508 248,557 (84,951) 50% 37% 667,016 781,046 114,030 Transfers In-General Fund 2,660,730 2,660,730 - 50% TOTAL RESOURCES 4,095,612 4,008,297 (87,315) 50% REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 50% 5,321,459 5,321,459 - 57% 7,089,849 7,201,515 111,666 Exp. 2,554,535 2,457,918 96,617 50% 48% k) 5,109,069 4,975,000 134,069 597,867 513,480 84,387 50% 43% c)i) 1,195,733 1,100,000 95,733 50 - 50 50% 0% 100 - 100 25,200 25,200 - 50% 50% 50,400 50,400 - 367,274 - 367,274 50% n/a 734,547 - 734,547 3,544,926 2,996,598 548,328 50% 42% 7,089,849 6,125,400 964,449 550,686 1,011,699 461,013 - 1,076,115 1,076,115 a) Outstanding $2,167 Federal Grant billing, reimbursed quarterly in arrears b) $1727 billing outstanding c) OYA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly, $91,000 billing outstanding d) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated Billings outstanding - $5,550 e) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears, trending higher than anticipated f) Revenues trending greater than anticipated - dependent on use of programs or services (MIP Diversion Fees, photocopies, etc) g) Citizen Review Board vacated. Revenue projected adjusted accordingly h) Due to change in practice, Behavioral Health's referrals for functional family therapy have decreased. Anticipated as permanent i) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly j) Grants paid quarterly-$5,000 outstanding payment for General Fund Grant-Crime Prevention Page 2 k) Actual for the year projected to be less than budgeted due to vacant positions Fund 701 LED-Countywide Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Tax Revenues - Current Tax Revenues - Prior Federal Grants & Reimb State Grant Transp. of State Wards SB 1145 Prisoner Housing Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport Other DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Inmate Telephone Fee Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Debit Card Fee Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Donations - "Shop with a Cop" Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments: Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Non Dept - ISF Charges Non Dept - Jamison D/S Contingency Total to Fund 255 Transfer to Reserve Fund (703) Total Requirements I Year to Date Year End Budget Actual Variance FY % Coll. % E Budget Projection Variance $5,108,671 $ 6,090,734 $ 982,063 7,153,421 13,284,163 6,130,742 100% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 119% 93% 97% 87% 40% 65% 48% a) n/a b) 100% 49% 53% 0% C) 26% n/a 0% 88% 51% 38% 88% d) 84% 68% 26% n/a 47% 35% 54% 76% 29% n/a n/a 87% $ 5,108,671 $ 6,090,734 $ 982,063 14,306,841 14,627,128 320,287 501,000 501,000 - 35,200 35,200 - 48,475 48,475 - 5,000 5,000 - 1,537,663 1,479,991 (57,672) - 26,492 26,492 5,000 5,000 - 91,000 91,000 - 4,180 4,180 - 150,000 150,000 - 1,000 1,000 - - 3,570 3,570 3,825 3,825 - 6,600 10,000 3,400 50,000 50,000 - 3,500 3,500 - 48,000 84,000 36,000 5,000 5,000 - 5,000 5,000 - 15,000 15,000 - - 100 100 16,000 16,000 - 5,000 5,000 - 200,000 200,000 - 28,333 42,000 13,667 3,533 3,533 - - 11,897 11,897 1,000 5,817 4,817 17,076,150 17,438,708 362,558 250,500 486,155 235,655 17,600 30,784 13,184 24,238 19,257 (4,981) 2,500 3,240 740 768,832 739,996 (28,836) - 26,492 26,492 2,500 5,000 2,500 45,500 44,870 (630) 2,090 2,219 129 75,000 - (75,000) 500 255 (245) - 3,570 3,570 1,913 - (1,913) 3,300 5,780 2,480 25,000 25,665 665 1,750 1,325 (425) 24,000 42,029 18,029 2,500 4,200 1,700 2,500 3,423 923 7,500 3,900 (3,600) - 69 69 8,000 7,539 (461) 2,500 1,727 (773) 100,000 108,068 8,068 14,167 21,405 7,238 1,767 1,020 (747) - 11,897 11,897 500 5,817 5,317 8,538,078 14,889,865 6,351,787 13,646,749 20,980,599 7,333,850 50% 95% Exp. 1,211,855 1,142,006 69,850 50% 47% 412,048 375,865 36,183 50% 46% 303,507 314,955 (11,449) 50% 52% 5,253,264 4,610,153 643,111 50% 44% 143,301 142,224 1,077 50% 50% 92,813 86,109 6,704 50% 46% 464,109 409,842 54,267 50% 44% 1,509,233 1,400,461 108,772 50% 46% 98,980 79,030 19,951 50% 40% 316,128 312,545 3,583 50% 49% 18,344 18,345 (0) 50% 50% 100,000 100,000 - 50% 50% 1,118,829 - 1,118,829 50% 0% 11,042,411 8,991,534 2,050,877 50,000 100,000 (50,000) 50% 100% 11,092,411 9,091,534 2,000,876 50% 41% 22,184,821 23,529,442 1,344,621 2,423,711 2,388,237 35,474 824,095 790,748 33,347 607,014 607,014 - 10,506,527 9,913,359 593,168 286,602 286,602 - 185,625 185,625 - 928,217 928,217 - 3,018,466 2,847,049 171,417 197,961 197,961 - 632,256 632,256 - 36,689 36,689 - 200,000 200,000 - 2,237,659 - 2,237,659 22,084,821 19,013,756 3,071,065 100,000 100,000 22,184,821 19,113,756 3,071,065 Net 2,554,339 11,889,065 9,334,727 - 4,415,686 4,415,686 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 Page 4 c) Reimbursement requested semiannually in January and June d) Change to new vendor resulting in revenue increase Fund 702 LED Rural Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants & Reimb Federal Grants-BLM US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Bureau of Reclamation Des Cty General Fund Grant Des Cty Transient Room Tax Des Cty Tax/Fin Contract City of Sisters Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security & Traffic Reimb Seat Belt Program Miscellaneous Restitution Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Grants-Private Donations Sale of Equip & Material Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments: Year to Date J I Year End Budget Actual Variance FY % Coll. % LEludget Pro'ection Variance $ 2,936,523 $ 3,004,533 $ 68,010 100% 102% $ 2,936,523 $ 3,004,533 $ 68,010 3,674,063 6,705,357 3,031,294 128,500 242,785 114,285 6,000 8,598 2,598 12,500 8,873 (3,627) 39,375 19,688 (19,687) 100,486 59,359 (41,127) 30,000 24,515 (5,485) 71,166 - (71,166) - 4,189 4,189 288,072 - (288,072) 1,036,928 1,036,928 - - 540 540 224,981 224,981 - 27,183 27,183 - 27,183 27,183 - 1,000 - (1,000) 40,000 3,457 (36,543) 2,500 680 (1,820) 6,000 4,690 (1,310) 5,000 2,736 (2,264) - 2,069 2,069 5,000 4,274 (726) 57,500 58,801 1,301 3,500 1,800 (1,700) 250 - (250) - 1,324 1,324 5,000 9,495 4,495 900 515 (385) - 2,000 2,000 - 2,555 2,555 3,000 11,074 8,074 10,000 35,855 25,855 50% 91% 7,348,125 7,512,627 164,502 50% 94% 257,000 257,000 - 50% 72% 12,000 12,000 - 50% n/a 25,000 25,000 - 50% 25% 78,750 78,750 - 50% 30% 200,972 200,972 - 50% 41% 60,000 60,000 - 50% 0% a) 142,332 142,332 - 50% n/a b) - 20,000 20,000 50% 0% c) 576,144 576,144 - 50% 50% 2,073,856 2,073,856 - 50% - 540 540 50% 50% 449,961 449,961 - 50% 50% 54,366 54,366 - 50% 50% 54,366 54,366 - 50% 0% 2,000 2,000 - 50% 4% d) 80,000 40,000 (40,000) 50% 14% 5,000 5,000 - 50% 39% 12,000 12,000 - 50% 27% 10,000 10,000 - 50% n/a - 5,000 5,000 50% 43% 10,000 10,000 - 50% 51% 115,000 115,000 - 50% 26% 7,000 7,000 - 50% 0% 500 500 - 50% n/a - 1,324 1,324 50% 95% 10,000 20,000 10,000 50% 29% 1,800 1,800 - 50% n/a - 2,000 2,000 50% n/a - 2,555 2,555 50% 185% 6,000 11,074 5,074 50% 179% 20,000 35,855 15,855 5,806,087 8,531,504 2,725,417 8,742,610 11,536,037 2,793,427 50% 73% 50% 79% Exp. 11,612,172 11,799,022 186,850 14,548,695 14,803,555 254,860 Sheriffs Services 80,115 75,497 4,618 50% 47% 160,230 157,885 2,345 Auto/Comm 507,597 526,744 (19,147) 50% 52% 1,015,193 1,015,193 - Investigations 867,109 745,704 121,405 50% 43% 1,734,218 1,532,403 201,815 Patrol 3,955,852 3,916,535 39,317 50% 50% 7,911,704 7,801,433 110,271 Records 360,355 307,551 52,804 50% 43% 720,710 720,710 - Special Services 203,472 179,680 23,791 50% 44% 406,944 406,944 - Training 63,152 50,423 12,729 50% 40% 126,304 126,304 - Non Dept - ISF Charges 18,271 18,271 - 50% 50% 36,542 36,542 - Contingency 1,168,425 - 1,168,425 50% 0% 2,336,849 - 2,336,849 #Ck 4 41, 40 W-W, Transfer to Reserve Fund (704) Total Requirements 50,000 100,000 (50,000) 50% 100% 7,274,348 5,920,406 1,353,941 50% 41% 100,000 100,000 14,548,695 11,897,415 2,651,280 Net 1,468,263 5,615,631 4,147,368 - 2,906,140 2,906,140 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services. a) Reimbursement requested semiannually in January and June b) BOR patrol contract signed after budget adopted Page 5 c) Received annually in June d) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District PUBLIC HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 Revenues Medicare Reimbursement 300 461 161 50% 77% 600 600 - State Grant 1,355,072 1,099,325 (255,747) 50% 41% 2,710,144 2,710,144 - Child Dev & Rehab Center 12,304 7,690 (4,614) 50% 31% 24,607 30,759 6,152 State Miscellaneous 112,415 63,395 (49,020) 50% 28% a)b) 224,829 127,000 (97,829) OMAP 261,925 288,142 26,217 50% 55% 523,850 523,850 - Title 19 - 352 352 50% n/a - 500 500 Family Planning Exp Proj 260,000 215,494 (44,506) 50% 41% 520,000 520,000 - Local Grants 22,500 46,988 24,488 50% 104% 45,000 48,745 3,745 Water Program-Base Fee 21,000 9,386 (11,614) 50% 22% a) 42,000 42,000 - Contract Payments - 25,000 25,000 50% n/a - 25,000 25,000 Water Program-Field Work 27,909 14,295 (13,614) 50% 26% a) 55,817 55,817 - H20 Sys Insp-Priv Wells 100 - (100) 50% 0% 200 200 - Miscellaneous - 3,740 3,740 50% n/a - 7,000 7,000 Patient Insurance Fees 67,690 84,157 16,467 50% 62% 135,380 135,380 - Health Dept/Patient Fees 59,385 46,142 (13,243) 50% 39% 118,770 118,770 - Vital Records-Birth 15,300 20,345 5,045 50% 66% 30,600 30,600 - Vital Records-Death 50,000 49,040 (960) 50% 49% 100,000 100,000 - Environmental Health 352,175 408,371 56,196 50% 58% c) 704,350 704,350 - Interest on Investments 6,000 5,357 (643) 50% 45% 12,000 12,000 - Donations 13,015 8,922 (4,093) 50% 34% 26,030 26,030 - Interfund Contract 99,194 17,852 (81,342) 50% 9% a) 198,387 198,387 - Administrative Fee 7,528 7,528 - 50% 50% 15,056 15,056 - Total Revenues 2,743,812 2,421,982 (321,830) 50% 44% 5,487,620 5,432,188 (55,432) Transfers In-General Fund 1,158,882 1,158,882 - 50% 50% 2,317,765 2,317,765 - Transfers In-PH Res Fund 15,000 15,000 - 50% 50% 30,000 30,000 - Transfers In-Gen. Fund Other 32,550 32,550 - 50% 50% 65,100 65,100 - TOTAL RESOURCES 5,547,162 5,330,543 (216,619) 50% 56% 9,497,403 9,547,182 49,779 REQUIREMENTS: Exp. Expenditures Personal Services 3,112,242 3,003,230 109,012 50% 48% 6,224,483 6,054,483 170,000 Materials and Services 953,347 903,283 50,064 50% 47% 1,906,694 1,906,694 - Capital Outlay 100,000 - 100,000 50% 0% d) 200,000 200,000 - Transfers Out 143,000 143,000 - 50% 50% 286,000 286,000 - Contingency 440,113 - 440,113 50% n/a 880,226 - 880,226 TOTAL REQUIREMENTS 4,748,702 4,049,513 699,189 50% 43% 9,497,403 8,447,177 1,050,226 NET (Resources - Requirements) 798,460 1,281,030 482,570 - 1,100,005 1,100,005 a) Received quarterly, in arrears b) Elimination of the State self sufficiency program c) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Budget=$110,000). These are due annually and collected in December and January Page 6 d) Computer BEHAVIORAL HEALTH ` Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 3,268,759 $ 3,108,163 $ (160,596) 100% 95% $ 3,268,759 $ 3,108,163 $ (160,596) Revenues Marriage Licenses 2,750 3,280 530 50% 60% 5,500 8,000 2,500 Divorce Filing Fees 66,500 79,096 12,596 50% 59% 133,000 150,000 17,000 Domestic Partnership Fee 50 45 (5) 50% 45% 100 100 - Federal Grants 12,149 23,245 11,096 50% 96% a) 24,298 24,298 - State Grants 3,608,276 3,566,292 (41,984) 50% 49% b) 7,216,551 7,164,922 (51,629) State Miscellaneous 62,087 10,310 (51,777) 50% 8% c)d) 124,173 61,860 (62,313) ABHA - 162,269 162,269 50% n/a e) - 170,000 170,000 Title 19 141,149 83,896 (57,253) 50% 30% 282,297 282,297 - Liquor Revenue 52,500 72,319 19,819 50% 69% 105,000 105,000 - School Districts 37,800 38,300 500 50% 51% 75,600 75,600 - Miscellaneous 7,000 7,964 964 50% 57% 14,000 14,000 - Patient Insurance Fees 56,850 44,521 (12,329) 50% 39% 113,700 113,700 - Patient Fees 904 550 (354) 50% 30% 1,807 1,807 - Interest on Investments 12,500 13,539 1,039 50% 54% 25,000 25,000 - Rentals 6,550 5,500 (1,050) 50% 42% c) 13,100 13,100 - Donations - 108 108 50% n/a - 200 200 Administrative Fee 2,214,845 2,176,934 (37,911) 50% 49% 4,429,689 4,429,689 - Sheriff 10,000 - (10,000) 50% 0% f) 20,000 - (20,000) Interfund Contract-Gen Fund 63,500 37,287 (26,213) 50% 29% c) 127,000 127,000 - Comm. on Children & Fam - 725 725 50% n/a - 725 725 Total Revenues -6,355,410 6,326,180 (29,230) 50% 50% 12,710,815 12,767,298 56,483 Transfers In-General Fund 631,758 631,758 - 50% 50% 1,263,515 1,263,515 - Transfers In-OHP-CDO 135,701 135,702 - 50% 50% 271,402 271,402 - Transfers In-Acute Care Svcs 126,258 126,258 - 50% 50% 252,515 252,515 - Transfers In-ABHA 150,432 150,432 - 50% 50% g) 300,863 300,863 - TOTAL RESOURCES 10,668,318 10,478,493 (189,826) 50% 58% 18,067,869 17,963,756 (104,113) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 4,947,096 4,619,465 327,631 50% 2,830,375 2,330,238 500,137 50% 207,500 54,622 152,878 50% 143,000 143,000 - 50% 905,965 - 905,965 50% 9,033,936 7,147,325 1,886,611 50% 1,634,382 3,331,168 1,696,785 Exp. 47% 9,894,191 9,894,191 - 41% 5,660,749 4,533,668 1,127,081 13%° 415,000 415,000 - 50% 286,000 286,000 - n/a 1,811,929 - 1,811,929 40% 18,067,869 15,128,859 2,939,010 - 2,834,897 2,834,897 a) Grant expired September 30, 2011 b) Department of Human Services Grant projected at amended contract amount c) Received quarterly, in arrears d) Elimination of State contract for Temporary Assistance for Needy Families (TANF) program e) Revenue for Adult Mental Health Initiative clients, not included in original budget f) Funding for Mental Health Court from the Sheriffs Department eliminated g) Transfer made quarterly Page 7 ROAD Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Year End Budget Actual Variance FY % Coll. % I Budget I Projection I Variance RESOURCES: Beg. Net Working Capital $ 2,834,720 $ 3,417,158 $ 582,438 100% 121% $ 2,834,720 $ 3,417,158 $ 582,438 Revenues System Development Charge - 924 924 50% n/a - 2,000 2,000 Federal Reimbursements 300,000 600,000 300,000 50% 100% a) 6009000 600,000 - Federal Grant (ARRA) 10,000 20,000 109000 50% 100% b) 20,000 20,000 - Mineral Lease Royalties 20,000 6,630 (13,370) 50% 17% 40,000 40,000 - Forest Receipts 655,581 - (655,581) 50% 0% c) 1,311,162 1,322,661 11,499 State Miscellaneous 250,021 500,041 250,020 50% 100% d) 500,041 500,041 - Motor Vehicle Revenue 5,670,000 5,3619585 (308,415) 50% 47% e) 11,340,000 10,723,000 (617,000) City of Bend 137,500 29,941 (107,559) 50% 11% f) 275,000 275,000 - City of Redmond 175,000 4,248 (170,752) 50% 1% f) 350,000 350,000 - City of Sisters 5,000 - (5,000) 50% 0% f) 10,000 10,000 - City of La Pine 5,000 - (5,000) 50% 0% f) 10,000 10,000 - Admin Recovery (SDC) 500 1,317 817 50% 132% 1,000 2,500 1,500 Miscellaneous 10,000 17,700 7,700 50% 89% 20,000 20,000 - Road Vacations 500 500 - 50% 50% 1,000 1,000 - Interest on Investments 10,000 8,790 (19210) 50% 44% 20,000 20,000 - Parking Fees 72 - (72) 50% 0% 144 144 - Interfund Contract 365,000 - (365,000) 50% 0% g) 730,000 730,000 - Equipment Repairs 100,000 121,531 21,531 50% 61% 200,000 200,000 - Vehicle Repairs 459000 - (45,000) 50% 0% 90,000 90,000 - LID Construction 5,000 - (5,000) 50% 0% g) 10,000 10,000 - Vegetation Management 35,750 - (35,750) 50% 0% g) 71,500 71,500 - Forester 12,500 3,352 (9,148) 50% 13% g) 25,000 25,000 - Car Washes 1,750 1,758 8 50% 50% 3,500 3,500 - Sale of Equip & Material 316,500 325,870 9,370 50% 51% 633,000 633,000 - Total Revenues 8,130,674 7,004,187 (1,126,487) 50% 43% 16,261,347 15,659,346 (602,001) Trans In - Solid Waste 142,887 142,887 - 50% 50% 285,773 285,773 - Trans In - Transp SDC 125,000 125,000 - 50% 50% 250,000 250,000 - Trans In-Road Imp Res 6,000 - (6,000) 50% 0% 12,000 12,000 - TOTAL RESOURCES 11,239,281 10,689,232 (550,049) 50% 57% 19,643,840 19,624,277 (19,563) REQUIREMENTS: EXp. Expenditures Personal Services 2,807,662 2,680,713 126,949 50% 48% 5,615,323 5,615,323 - Materials and Services 5,086,337 5,735,567 (649,230) 50% 56% h) 10,1729674 10,755,112 (582,438) Capital Outlay 618,346 25,288 593,058 50% 2% 1,236,691 1,236,691 - Transfers Out 300,000 - 300,000 50% 0% 600,000 6009000 - Contingency 1,009,576 - 1,009,576 50% n/a 2,019,152 - 2,019,152 TOTAL REQUIREMENTS 9,821,921 8,441,568 1,380,353 50% 43% 199643,840 18,207,126 1,436,714 NET (Resources - Requirements) 1,417,360 2,247,664 830,304 - 1,417,151 1,417,151 a) Revenue received in November at completion of the Cascade Lakes chip seal project b) Payment received in December c) Received annually in January d) Annual payment received in August e) Revenues trending less than estimates provided by ODOT f) Billed upon completion of work g) Payments to be received in June 2012 from other Road Department funds Page 9 h) Expenditures are seasonal and higher during summer. YTD includes $2.5 million paid to Knife River on the Full Depth Reclamation Project in South County ADULT PAROLE & PROBATION Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund - Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 560,000 $ 634,125 $ 74,125 100% 113% $ 560,000 $ 634,125 $ 74,125 108,675 - (108,675) 50% 0% a) 217,350 219,240 1,890 2,151 - (2,151) 50% 0% b) 4,301 4,301 - 15,459 - (15,459) 50% 0% c) 30,918 21,000 (9,918) 6,500 6,913 413 50% 53% 13,000 13,000 - 1,427,829 1,374,278 (53,551) 50% 48% 2,855,659 2,748,953 (106,706) 12,000 11,520 (480) 50% 48% 24,000 24,000 - 2,050 883. (1,167) 50% 22% 4,100 2,100 (2,000) 85,000 65,882 (19,118) 50% 39% 170,000 170,000 - 100,000 87,830 (12,170) 50% 44% 200,000 200,000 - 4,500 2,912 (1,588) 50% 32% 9,000 9,000 - 25,000 25,000 - 50% 50% 50,000 50,000 - 25,000 12,500 (12,500) 50% 25% d) 50,000 50,000 - 37,416 18,708 (18,708) 50% 25% d) 74,832 74,832 - 1,851,580 1,606,426 (245,154) 50% 43% . 3,703,160 3,586,426 (116,734) 169,146 169,146 - 50% 50% 338,292 338,292 - 2,580,726 2,409,697 (171,029) 50% 52% 4,601,452 4,558,843 (42,609) Exp. 1,584,344 1,497,992 86,352 50% 47% 3,168,688 3,168,688 - 443,445 346,867 96,578 50% 39% 886,890 886,890 - 50 - 50 50% 0% 100 - 100 14,400 14,400 - 50% 50% 28,800 28,800 - 258,487 - 258,487 50% n/a 516,974 - 516,974 2,300,726 1,859,259 441,467 50% 40% 280,000 550,438 270,438 a) Annual allocation expected in January b) Annual allocation normally received in February c) State invoiced quarterly. Payment from State pending d) Interfund grant received quarterly. Payments have been requested 4,601,452 4,084,378 517,074 - 474,465 474,465 Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart /R-S-G OCCF Grant Program Fees Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 467,111 $ 556,143 $ 89,032 100% 119% $ 467,111 $ 556,143 $ 89,032 149,744 121,379 (28,365) 19,665 24,118 4,453 47,500 19,205 (28,295) 128,991 100,923 (28,068) 12,250 45,986 33,736 155,919 129,102 (26,817) 272,602 252,716 (19,886) - 1,005 1,005 4,000 610 (3,390) 39,000 47,458 8,458 2,500 2,044 (456) - 71 71 60,438 22,969 (37,469) 892,609 767,586 (125,023) 50% 41 % a) 299,488 301,491 2,003 50% 61% a)b) 39,329 39,534 205 50% 20% a)c) 95,000 85,000 (10,000) 50% 39% a)b) 257,982 196,898 (61,084) 50% 188% d) 24,500 77,622 53,122 50% 41 % a)b) 311,838 258,203 (53,635) 50% 46% a)b) 545,203 502,290 (42,913) 50% n/a e) - 2,500 2,500 50% 8% 8,000 8,000 - 50% 61% f) 78,000 85,000 7,000 50% 41% 5,000 5,000 - 50% n/a e) - 300 300 50% 19% g) 120,875 300,875 180,000 50% 43% 1,785,215 1,862,713 77,498 Trans from General Fund 136,482 136,482 - 50% 50% 272,960 272,960 - Total Transfers In 136,482 136,482 - 50% 50% 272,960 272,960 - TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 1,496,202 1,460,211 (35,991) 50% 58% 2,525,286 2,691,816 Exp. 302,560 285,213 17,347 50% 47% h) 605,119 579,945 843,490 471,715 371,775 50% 28% i) 1,686,979 1,744,961 50 - 50 50% 0% 100 100 116,544 - 116,544 50% n/a 233,088 1,262,644 756,928 505,716 50% 30% NET (Resources - Requirements) 233,558 703,283 469,725 2,525,286 2,325,006 166,530 25,174 (57,982) 233,088 200,280 - 366,810 366,810 a) Grant payments received normally within 60 days after the end of each quarter b) FY 12 and FY 13 Intergovernmental Agreement finalized funding levels from OCCF. Community Schools grant included in year- end projection at $9,484 c) Medicaid revenues reduced due to lower projections d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from DHS not budgeted for $48,122 e) Youth Suicide Prevention training donations & fees expected to be received f) Court fees projected to be higher than estimated in the original budget g) Two additional grants of $55,000 & $180,000 awarded. $55,000 received in last fiscal year, no additional expected h) Personnel costs lower due to part-time Early Childhood Specialist i) Sub-grant expenditures paid quarterly. Federal grant amount increased and SPF-SIG grant expenditures added Page 11 SOLID WASTE Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,092,508 $ 1,141,691 $ 49,183 100% 105% $1,092,508 $ 1,141,691 $ 49,183 Revenues Miscellaneous 11,000 10,285 (715) 50% 47% 22,000 22,000 - Franchise 3% Fees 100,000 16,049 (83,951) 50% 8% a) 200,000 200,000 - Commercial Disp. Fees 430,000 462,835 32,835 50% 54% 860,000 860,000 - Private Disposal Fees 657,000 697,821 40,821 50% 53% 1,314,000 1,314,000 - Franchise Disposal Fees 2,000,000 2,052,700 52,700 50% 51% 4,000,000 4,000,000 - Yard Debris 36,500 53,208 16,708 50% 73% b) 73,000 73,000 - Special Waste 12,500 2,307 (10,193) 50% 9% c) 25,000 25,000 - Interest 3,750 5,978 2,228 50% 80% 7,500 7,500 - Leases 1 4,993 4,992 50% n/a d) 1 10,394 10,393 Donations - 2,880 2,880 50% n/a e) - 2,880 2,880 Sale of Reportable Assets - 15,100 15,100 50% n/a f) - 15,100 15,100 Recyclables 15,000 47,364 32,364 50% 158% g) 30,000 60,000 30,000 Total Revenues 3,265,751 3,371,520 105,769 50% 52% 6,531,501 6,589,874 58,373 TOTAL RESOURCES 4,358,259 4,513,211 154,952 50% 59% 7,624,009 7,731,565 107,556 REQUIREMENTS Exp. Expenditures Personal Services 835,799 797,094 38,705 50% 48% 1,671,598 1,671,598 - Materials and Services 1,446,526 1,309,027 137,499 50% 45% 2,893,052 2,893,052 - Debt Service 485,617 398,826 86,791 50% 41% h) 971,233 971,233 - Capital Outlay 86,000 84,553 1,447 50% 49% 172,000 172,000 - Transfers Out-Road 142,887 142,887 1 50% 50% 285,773 285,773 - Transfers Out-Res Fund 537,000 662,000 (125,000) 50% 62% i) 1,074,000 1,074,000 - Contingency 278,177 - 278,177 50% n/a 556,353 556,353 TOTAL REQUIREMENTS 3,812,006 3,394,387 417,620 50% 45% 7,624,009 7,067,656 556,353 NET (Resources - Requirements) 546,253 1,118,825 572,572 - 663,909 663,909 a) Due April 15, 2012 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Revenue from rent on Rickard Road property, not included in original budget e) Incentive for energy efficient lighting upgrade in Knott Transfer Station building f) Sold glass crusher at auction g) Recycling markets are higher than expected. Often it can be seasonal h) To be-expended in November ($398,827) and May ($572,406) i) Transferred full amount budgeted for SW Equip Reserve Page 12 RISK MANAGEMENT Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments Other Interest TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Repair / Replacement Total General Liability PROPERTY DAMAGE Insurance Repair / Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT - Settlement/Benefits Year to Date Year End Budget I I Actual Variance % of FY F-1. Coll. Budget Projection Variance $2,100,000 $2,039,937 ($60,063) 125,428 125,428 0 155,817 155,817 0 89,155 89,155 (0) 736,972 736,972 0 126,217 126,378 161 2,500 - (2,500) 10,000 63,110 53,110 750 665 (85) 25 - (25) 9,000 5,600 (3,400) 7,500 6,816 (684) 25 - (25) 1,263,388 1,309,940 46,552 3,363,388 3,349,877 (13,511) 110,162 149,692 196 109,664 5,517 200,000 375,230 (175,230) 116,097 64,293 150,112 180,390 (30,279) 376 6,585 25,924 50,743 32,885 17,857 459,460 64,668 11,229 10,735 400,000 546,092 (146,092) 125,000 53,465 71,535 100% 97% $2,100,000 $2,039,937 ($60,063) 50% 50% 250,855 250,855 - 50% 50% 311,633 311,633 - 50% 50% 178,310 178,310 - 50% 50% 1,473,944 1,473,944 - 50% 50% 252,433 252,433 - 50% 0% 5,000 5,000 - 50% 316% 20,000 75,000 55,000 50% 44% 1,500 1,500 - 50% 0% 50 50 - 50% 31% 18,000 18,000 - 50% 45% 15,000 15,000 - 50% 0% 50 50 - 50% 52% 2,526,775 2,581,775 55,000 50% 72% 4,626,775 4,621,712 (5,063) Ex . 50% 94% 400,000 475,000 (75,000) 50% 60% 300,223 278,000 22,223 50% 32% 101,485 80,000 21,485 50% 68% 800,000 980,000 (180,000) 50% 21% 250,000 250,000 - Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET 925,854 1,188,063 (262,209) 147,179 132,399 14,779 83,859 70,935 12,924 50 - 50 231,087 203,334 27,753 3,600 3,600 - 1,160,541 1,394,997 (234,456) 2,202,847 1,954,880 (247,967) 50% 64% 1,851,708 2,063,000 (211,292) 50% 45% 294,357 294,357 - 50% 42% 167,717 167,717 - 50% 0% 100 - 100 50% 44% 462,174 462,074 100 50% 50% 7,200 7,200 - 50% 60% 2,321,082 2,532,274 (211,192) ` 2,305,693 2,089,438 (216,255) Contingency is $2,305,693. Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Revised Year End Budget Actual Variance % of FY % Coll. LBudapt Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes - Current 2,991,887 5,514,066 2,522,179 50% 92% 5,983,773 6,117,731 133,958 Property Taxes - Prior 100,000 188,036 88,036 50% 94% 200,000 200,000 - Federal Grants - 115,863 115,863 50% n/a - 203,958 203,958 State Reimbursement 27,000 10,836 (16,164) 50% 20% a) 54,000 27,000 (27,000) Telephone User Tax 375,000 193,349 (181,651) 50% 26% 750,000 750,000 - Data Network Reimb. 13,600 34,698 21,098 50% 128% b) 27,200 34,698 7,498 Jefferson County 17,500 26,087 8,587 50% 75% 35,000 35,000 - User Fee 26,000 2,156 (23,844) 50% 4% c) 52,000 52,000 - Police RMS User Fees 99,500 - (99,500) 50% 0% d) 199,000 199,000 - Contract Payments 16,000 33,061 17,061 50% 103% b) 32,000 33,061 1,061 Miscellaneous 4,500 4,280 (220) 50% 48% 9,000 9,000 - Interest 17,500 26,726 9,226 50% 76% 35,000 35,000 - Interest on Unsegregated Tax 400 424 24 50% 53% 800 800 - Total Revenues 3,688,887 6,149,582 2,460,695 50% 83% 7,377,773 7,697,248 319,475 TOTAL RESOURCES 10,088,887 13,709,221 3,620,334 50% 100% 13,777,773 15,256,887 1,479,114 REQUIREMENTS: % Exp. Expenditures Personal Services 2,120,417 1,899,006 221,411 50% 45% 4,240,834 4,040,834 200,000 Materials and Services 963,678 757,306 206,372 50% 39% 1,927,356 1,927,356 - Capital Outlay 567,310 326,838 240,472 50% 29% 1,134,620 1,134,620 - Transfers Out 250,000 500,000 (250,000) 50% 100% e) 500,000 500,000 - Contingency 2,987,482 - 2,987,482 50% n/a 5,974,963 - 5,974,963 TOTAL REQUIREMENTS 6,888,887 3,483,150 3,405,737 NET (Resources - Requirements) 3,200,000 10,226,071 7,026,071 50% 25% 13,777,773 7,602,810 6,174,963 - 7,654,077 7,654,077 a) GIS/MSAG monthly billings to Oregon Emergency Management-projected revenue overestimated. Projection revised to $27,000 b) Invoiced annually; all expected revenues received c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually June 30th. Payment will not be received from Crooked River Ranch until FY 13 d) Fees expected to be billed out in January e) Entire amount budgeted transferred to reserve fund in September Page 14 Health Benefits Trust Statement of Fin ancial Operati ng Data Six Months Ended December 3 1, 2011 Year to Date Revised E Year End ~ Budget Actual Variance FY % Coll. % R,,,qget I Projection Va RESOURCES Beg. Net Working Capital $15,500,000 $ 15,829,888 $ 329,888 100% 0 $15,500,000 $15,829,888 329,888 Revenues: Internal Premium Charges 6,007,856 6,023,479 15,624 50% 50% 12,015,711 12,015,711 - P/T Emp - Add'I Prem 25,000 14,916 (10,084) 50% 30% 50,000 50,000 - Employee Prem Contribution 315,000 314,390 (610) 50% 50% 630,000 630,000 - COIC 630,000 644,242 14,242 50% 51% •1,260,000 1,260,000 - Retiree / COBRA Co-Pay 250,000 440,595 190,595 50% 88% 500,000 750,000 250,000 Fees for Clinic Services - 200 200 50% n/a - 200 200 Federal Payment (ERRP) 150,431 150,431 50% n/a ' - 150,431 150,431 Prescription Rebates - 55,663 55,663 50% n/a - 55,663 55,663 Interest 40,000 57,043 17,043 50% 71% 80,000 80,000 - Total Revenues 7,267,856 7,700,961 433,106 50% 53% 14,535,711 14,992,006 456,295 TOTAL RESOURCES 22,767,856 23,530,849 762,994 92% 103% 30,035,711 30,821,894 786,183 REQUIREMENTS EP, % Expenditures: Personal Services 75,609 66,739 8,870 50% 44% 151,218 151,218 - Materials & Services Claims Paid-Medical/Rx 6,237,142 5,975,800 261,342 50% 48% a) 12,474,284 11,509,059 965,226 Claims Paid-Dental/Vision 931,987 937,779 (5,792) 50% 50% a) 1,863,974 1,806,093 57,880 Refunds 0 (38,642) 38,642 50% n/a - (38,642) 38,642 Insurance Expense 175,000 175,867 (867) 50% 50% 350,000 350,000 - State Assessments 75,000 70,788 4,212 50% 47% 150,000 150,000 Administration Fee 160,000 159,272 728 50% 50% 320,000 320,000 PPO Fee 25,000 24,278 722 50% 49% 50,000 50,000 Health Impact 27,500 25,696 1,805 50% 47% 55,000 55,000 Other 70,581 75,477 (4,896) 50% 53% 141,162 141,162 - Total HBT - Dept 31 7,777,819 7,473,053 304,766 50% 48% 15,555,638 14,493,890 1,061,748 Deschutes On-site Clinic Healthstat 478,600 250,371 228,229 50% 26% b) 957,200 957,200 - Medications/Drugs 162,500 76,422 86,078 50% 24% 325,000 325,000 Medical Supplies 1,500 14,599 (13,099) 50% 487% 3,000 30,000 (27,000) Equipment 2,000 150 1,850 50% 4% 4,000 4,000 - Miscellaneous 2,725 5,717 (2,992) 50% 105% 5,450 10,000 (4,550) Total DOC 647,325 347,258 300,067 50% 27% 1,294,650 1,326,200 (31,550) Deschutes On-site Pharmacy Remodeling Costs - 1,965 (1,965) 50% n/a - 1,965 1,965 Total Pharmacy - 1,965 (1,965) 50% n/a - 1,965 (1,965) Capital Outlay 100 - 100 50% n/a 200 - 200 Contingency 6,592,612 - 6,592,612 50% n/a 13,185,223 - 13,185,223 TOTAL EXPEND/REQUIREMNTS 15,017,856 7,822,276 7,195,579 50% 26% 30,035,711 15,822,055 14,213,656 NET (Resources - Requirements) 7,750,000 15,708,573 7,958,573 - 14,999,839 14,999,839 * Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible a) Projection based on annualizing 27 weeks of claims paid. YTD actual is $254,627 per week b) Healthstat is approximately $51,000 per month. "Year to Date" includes four months - July through October Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Year to Date Year End Budget (6/12 annual) of Actual Variance FY % Coll. % Budget Projection Variance $ 75,000 $ (40,601) $ (115,601) 100% -54% $ 75,000 $ (40,601) $ (115,601) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures 302,500 294,591 (7,909) 50% 49% 605,000 566,591 (38,409) 750 254 (496) 50% 17% 1,500 1,003 (497) 29,000 12,426 (16,575) 50% 21% 58,000 35,426 (22,574) 3,000 - (3,000) 50% 0% 6,000 6,000 - 15,000 4,186 (10,814) 50% 14% 30,000 34,186 4,186 110,000 67,191 (42,809) 50% 31% 220,000 186,191 (33,809) 56,000 18,000 (38,000) 50% 16% 112,000 124,000 12,000 23,500 - (23,500) 50% 0% 47,000 47,000 - 3,404 6,789 3,386 50% n/a 6,807 8,994 2,187 543,154 403,436 (139,717) 50% 37% 1,086,307 1,009,392 (76,915) 85,000 85,002 - 50% 50% 170,000 170,000 - 12,872 12,870 - 50% 50% 25,744 25,744 - 41,400 41,400 - 50% 50% 82,800 82,800 - 110,000 150,000 40,000 50% 68% 220,000 220,000 - 50 - (50) 50% 0% 100 - (100) 249,322 289,272 39,950 498,644 498,544 (100) 867,476 652,107 (215,368) 50% 39% 1,659,951 1,467,335 (192,616) Exp. 9/61 433,009 421,087 11,922 50% 49% 866,018 854,145 11,873 240,530 296,073 (55,543) 50% 62% 481,060 524,356 (43,296) 57,534 71,266 (13,732) 50% 62% 115,068 115,068 - 50 - 50 50% 0% 100 - 100 731,123 788,427 (57,304) 1,462,246 1,493,569 (31,323) Transfers Out - Reserve Fund 5,000 10,000 (5,000) 50% 100% 10,000 10,000 - Contingency 93,853 - 93,853 50% n/a 187,705 - 187,705 TOTAL REQUIREMENTS 829,976 798,427 31,549 50% 48% 1,659,951 1,503,569 156,382 NET (Resources - Requirements) 37,500 (146,319) (183,819) - (36,234) (36,234) Page 16 H U W ti O a ENO 00 a lq~ C40) U ~ U z ~a r O C N ~ r M « m a) 00 U a)U) (D a) 7 .c L O U C J Q o O U .0 O - Z O' (D U c vi w V O U) w w O N 0 - N r s s O O' O O i I I a I I O ' 0 O 0 ' O O r O O N O O O O N V d IV O M O O N O r- O O r O N O O O O M O O co O O M (4 M Il- r M O LO M r N r 0 0 0 0 0 0 0 0 ' 0 0 0 ' 0 O M M ' O O O N LO O N O O N O M N O O O r r O N co M ti N r- M ~ N V `ct (0 1* r O Ln 'ct 00 LO N ( V V M r- to M Ln LO O M O O O- O O M T- O O O O M O O co O O M 0 M O M 0000 ' O 00 ' (400 ' ( 4 CD M co ' O ' OONO N OOr0 `-ON (0 M (1- N ~ C) LO M V) 1 eq Ct 'Ili 1-0 CD 'IT 'T co 40 N - C NF er M O Cl N O O r W N O O N 0 CO O t CO O M ~ Cl) 00 r IV O O O O O O' ' 00 ' 0 ' O N N ' 0n O N LO O N N 0 O C O vi N M V) C \f CD C) O tn M r~- ( 4 l N r 0 ° 0 O O O O O N N N N M O O N r- 0 0 r ' O N O O N 0 M O - M_ O CY) M M r 0 0 0 0 0 M' ' 00 0 O O N N ' N ti N Ln O N N 07 LLB N N c r; N r 1~ "T f4 O N V CD C) 1q, cn le w cm r r N N O U O L N E d (0 V C) C-4 y V rn 0 0 r U rn N La ova M~ c c ~LL LL V N C N N N N' " m viEE w O ` 0 N 0 0 L N r Q a O 5 H L U N . N M La U C N rn cn c N O N 06 'c L) a) O D a- U c m o i Evv a m co c _cn Oco x d 3 3 .0 N- Z O ~ _ c c W O c vi .L - (D > p -a 0 m E o C w c c o o cn cn CU CD p o N p caQwd _ N 0 CLL~ F ~ e Q J~~ i~~ ~ X - c o U H - F- F- LU U Z M r O N ~ N 66~ r N ~ LL o v O C 7 LL to O U O 0 m a N O E o O U > c`0 a) a) ~ c N N ~ O E O CL 4 E cn m O L O 3 O O N 0 O N N L ~ O N O LL N C } Z LL U C_ +O+ UU co cu CU O L y U a° c co ca 3 a rnN c c0 ~O° ~o a~ Lri L i- ~ m .n N C Z W c N ~ m c 15 0 C7 m U Q U U W a) 0 (n Z c ~ O m L U L ~ U `o Z Z W O O N N O O M M L6 L6 N N O O O O ~ lLO Deschutes County Bethlehem Inn (Fund 128) Six Months Ended December 31, 2011 Budget Actual Variance FY % Coll. % I Budget ( Projection I Variance RESOURCES: Beg. Net Working Capital $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100% $ (2,711,235) $ (2,716,581) $ (5,346) Revenues Grants - Private 1,400,914 - (1,400,914) 50% 0% 2,801,827 - (2,801,827) Lease Payments 12,204 14,238 2,034 50% 58% 24,408 24,408 - Total Revenues 1,413,118 14,238 (1,398,880) 50% 1% 2,826,235 24,408 (2,801,827) TOTAL RESOURCES (1,298,118) (2,702,343) (1,404,225) 50% -2350% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp. Expenditures Debt Service: Interest Expense 7,500 9,993 (2,493) 50% 67% a) 15,000 17,000 (2,000) Interest Payment 50,000 - 50,000 50% 0% 100,000 - 100,000 TOTAL REQUIREMENTS 57,500 9,993 47,507 50% 9% 115,000 17,000 100,000 NET (Resources - Requirements) (1,355,618) (2,712,336) (1,356,718) a) Interest on December 2011 negative cash balance: $1,271.27. b) Inception through December 31, 2011 Revenues - Lease Payments $ 38,646 Expenditures: 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 233,069 Total expended 2,750,982 Net $ (2,712,336) b) - (2,709,173) (2,707,173) 11 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2012 BOCC Conference & Travel Jul Aug Sep Oct Nov Dec YTD Total Tammy Baney Conf/Sem & Educ/Training 665 - - 305 ! 15 - 985 Travel Meals - - 220 j - j 30 90 340 Accommodations 996 - 211 429 - - 1,635 Airfare - - - - - - - Mileage reimbursement - - ! 794 _ 677 309 1,779 Ground Transport/Parking ! - - 150 - - - 150 Total Baney 1,661 - 1,375 j 734 722 399 4,890 Alan Unger Conf/Sem & Educ/Training 665 - - 305 45 - 1,015 Travel Meals - - - - - - - Accommodations 1,131 - - 3221 - - 1,452 Airfare Mileage reimbursement - - ! - - - _ _ Ground Transport/Parking Total Unger j 1,796 - - 627 45 - 2,467 Tony DeBone Conf/Sem & Educ/Training 665 - - 305 45 - 1,015 Travel Meals - Accommodations 908 - - 429 - - 1,337 Airfare - - - - - - - Mileage reimbursement - 300 - 146 - 163 609 Ground Transport - 54 - ! - - - 54 Total Other 1,573 ( 354 - 880 45 163 3,015 Total - BOCC Department Conf/Sem & Educ/Training j 1,330 - - 610 60 - 3,015 Travel Meals - - ! 220 - 30 90 340 Accommodations 1,904 - 211 857 - _ - 4,424 Airfare - - - - - Mileage Reimbursement - 300 794 ! 146 I 677 472 2,389 Ground Transport - j 54 150 - ! - - 204 Total - BOCC Department 3,234 354 1,375 1,613 767 562 10,372 FY 2012 Budget ! 14,750 Percent of FY 2012 Budget Expended 70.3% ! I ~ BOCC County College j Public Information Office/Copier Supplies - - 120 - 59 ! 11 189 Meeting Supplies - - 556 829 788 - 2,172 - - 675 829 847 11 2,361 ~ I 12/29/2011 RV Park (Fund 601) Statement of Financial Operating Data Six Months Ended December 30, 2011 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $10,000 $ (28,100) $ (38,100) 100% n/a $10,000 $ (28,100) $ (38,100) Revenues RV Park Fees < 31 Days 89,250 93,061 3,811 50% 52% a) 178,500 178,500 - RV Park Fees > 30 Days 3,700 3,250 (450) 50% 44% a) 7,400 7,400 - Tent Space Rental 400 - (400) 50% 0% 800 800 - Washer/ Dryer 797 733 (64) 50% 46% 1,593 1,593 - Vending Machines 600 298 (302) 50% 25% 1,200 1,200 - City of Redmond 2,000 - (2,000) 50% 0% 4,000 4,000 - Room Tax Collection Fee - - - 50% n/a - - - Interest on Investments - 92 92 50% n/a - 92 92 Cancellation Fees - 1,058 1,058 50% n/a - 1,058 1,058 Total Revenues 96,747 98,492 1,745 50% 51% 193,493 194,643 1,150 Transfers In-Fund 130 70,000 110,000 40,000 50% 79% 140,000 140,000 - TOTAL RESOURCES 176,747 180,392 3,645 50% 53% 343,493 306,543 (36,950) REQUIREMENTS: Exp. Expenditures Materials & Services 42,861 50,954 (8,093) 50% 59% 85,722 85,722 - Debt Service 159,825 159,825 - 50% 66% b) 242,829 242,829 - Contingency 7,471 - 7,471 50% n/a 14,942 - 14,942 TOTAL REQUIREMENTS 210,157 210,779 (622) 50% 61% 343,493 328,551 14,942 NET (Resources - Requirements) (33,410) (30,387) 3,023 - (22,008) (22,008) a) 3,010 RV spaces rented b) Debt service expended semi-annually - November and May. r O N } LL a O (n C N N O C w O LL (~6 N ..U) ` U O tp C O N 3 LL U O c O c 3 a O O C N U m CL s > U 0 ~ N_ O N } LL O O O O O p p N M (D 0 0 0 ( 7 ti to O O M of 'I qT MI- N O N ,qT N r r LorCOC)(DDC) O V' 00 d' N O r ('7 cM(0(OrLO O r 000(DNN r O I` M r M M co - ti N IT O CA \o \°0 0 \o \°0\0o 0 0 0 0 0 0 0 0 0 M I~ N O (D O N T O fl- O O M 00 N I- r I'- LO (D M Lo CO d' It M 00 N O LO CO O r N to '9T N N N M Cf r - r T- M Dd)NrOMOIftoMI,N I~ 00 M f~ r r to (D 00 In O O r~ N M Lo r r r r CO r~ r r ~ NNMMm(Dql mmIT 'IT (DN M to r 0 N r O- I- Lo 'T 0 0 M IT O IT 00 0 Il- N m m O f- 1~ 6 Vr- to M r N L6 N v C N r \o 0 \o \o \o \o \o 0 0 0 0 0 0 0 0 0 0 0 0 (0 r 0 to N r (D 1l- 0 to M r- I-000 V M N N -000W r 0 00 O N O N N O C0 CD O 00 N r r N LO O O M O r- q- 'cr m (D m (D M r to M IT M I- CD m to N M w ti ('M N M N N N O Cl) v (D ~ qq' 'I 00 ~ 00 00 IT N N w N mI- O 00 (D N r- LO (D O'cr LOW 00 C O Q 00 N M O to r M m N N r 00 O N C NT O 00 r- O 1` N N O T- 0 0 0 0 0 0 0 0 c 0 \ 0 \ 0 0 \ 0 c O M "T V, CD (D M M Lo r N V M (D 00 0 M (D ~ to ~ N to i- (D O ~Oco tnr0004I-(DN r r N C) M Iq N M O cp a M ~ O O 00 Lo M O Lo r r M N N N qT MN•- 04 C14 I-L` N N IT (D v N 0 w w 00 v N w N LO NT O V M r O N 0 V (D M M M1- O r (D V 0- -T 0 Ct C L6 r O (D r d' I~ ti M ll~ r r N co l0 7 r L L L (O NN~ (D a) ICI. m -0 ` O :3 2 -0 Q w cu :3 -0 CU M 0 CL 4) V 3 N Q~Qc/)OZ0~U <1-5 } a~ rn ~ a pp 3 3 m 'o c N N N 0 M b4 cu a) C) 0 U U) a m 00 0) Qti a N r ~ N N 3 a c~a C + 3 O C ~ (n o C6 a O N ~ 0) 00 M C') cu - O ti 1` to O O 00 a r - M N a) , O to cu co M O U C U-) 0) ui 3 U) CD O U .cu C) O (m Lo 'a > m m CL C6 (D N ti cn O b4 U 3 03 m r o m N Building Services - 620 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital $ 424,000 $ 529,500 $ 105,500 Revenues Cleaning/Maintenance 81,690 71,870 (9,820) Insurance Reimbursement - 9,331 9,331 Utility Reimbursement 2,000 1,701 (299) Facilities Charge to State 94,008 73,435 (20,573) Miscellaneous - 52 52 Interest on Investments 1,500 2,085 585 Interfund contract 5,000 5,950 950 Building Svcs Indirect Chgs 995,615 995,615 - Total Revenues 1,179,813 1,160,038 (19,775) TOTAL RESOURCES 1,603,813 1,689,538 85,726 REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance 100% n/a $ 424,000 $ 529,500 $ 105,500 50% 44% 163,380 163,380 - 50% n/a - 9,331 9,331 50% 43% 4,000 4,000 - 50% 39% 188,016 188,016 - 50% n/a - 52 52 50% 69% 3,000 4,000 1,000 50% 59% 10,000 10,000 - 50% 50% 1,991,229 1,991,229 - 50% 49% 2,359,625 2,370,008 1,052 50% 61% 2,783,625 2,899,508 106,552 Exp. 840,343 838,901 1,441 50% 50% 1,680,685 1,680,685 - 381,279 365,720 15,559 50% 48% 762,558 762,558 - 19,800 19,800 - 50% 50% 39,600 39,600 - 50 - 50 50% 0% 100 - 100 150,341 - 150,341 50% 0% 300,682 - 300,682 TOTAL REQUIREMENTS 1,391,813 1,224,421 167,391 50% 44% NET (Resources - Requirements) 212,000 465,117 253,117 2,783,625 2,482,843 300,782 416,665 407,334 Beginning NWC Per FY 2013 Requested Budget 415,000 Admin Services - 625 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital $ 183,000 $ 158,276 $ (24,724) 100% Revenues Miscellaneous - 30 30 50% Interest on Investments - 414 414 50% Admin Dept Indirect Chgs 440,869 440,869 - 50% Total Revenues 440,869 441,313 444 50% Transfers In-General Fund 20,000 20,000 - 50% TOTAL RESOURCES 643,869 619,589 (24,280) 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance n/a $ 183,000 $ 158,276 $ (24,724) n/a - 30 30 n/a - 600 600 50% 881,738 881,738 - 50% 881,738 882,368 630 50% 40,000 40,000 - 56% 1,104,738 1,080,644 (24,094) Exp. 430,635 557,252 (126,617) 50% 65% a) 861,269 992,379 54,324 42,435 11,889 50% 39% 108,648 108,648 1,800 1,800 - 50% 50% 3,600 3,600 50 - 50 50% 0% 100 100 65,561 - 65,561 50% 0% 131,121 - 552,369 601,487 (49,118) 50% 54% 1,104,738 1,104,727 (131,110) 131,121 11 NET (Resources - Requirements) 91,500 18,102 (73,398) b) - (24,083) (24,083 Beginning NWC Per FY 2013 Requested Budget 140,000 a) YTD actual includes payout to County Administrator. Projection is YTD Actual plus 6 months at December actual, and $50,000 new County Administrator. b) A transfer from the General Fund is anticiapted to be made prior to year end. BOCC - 628 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital $ 115,000 $ 114,142 $ (858) 100% n/a Revenues Sale Map Photo or Copies - 11 11 50% n/a Interest on Investments 250 416 166 50% n/a Admin Dept Indirect Chgs 180,410 180,410 - 50% 50% TOTAL RESOURCES 295,660 294,979 (681) 50% 62% REQUIREMENTS: Exp. Expenditures Personal Services 168,832 169,016 (184) 50% 50% Materials and Services 44,781 48,103 (3,322) 50% 54% Capital Outlay 50 - 50 50% 0% Contingency 24,498 - 24,498 50% 0% TOTAL REQUIREMENTS 238,161 217,118 21,043 50% 46% NET (Resources - Requirements) 57,499 77,860 20,361 Beginning NWC Per FY 2013 Requested Budget Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 115,000 $ 114,142 $ (858) 500 800 300 360,820 360,820 - 476,320 475,762 (558) 337,664 337,664 - 89,561 89,561 - 100 - 100 48,995 - 48,995 476,320 427,225 49,095 48,537 48,537 60,000 Finance - 630 Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 603,000 $ 788,522 $ 185,522 100% n/a Revenues Investment Fee 20,000 22,049 2,049 50% 55% Photo copies 75 401 326 50% 267% IGA Contracts 7,723 - (7,723) 50% 0% Interest on Investments 2,000 2,706 706 50% 68% Interfund Contracts 6,000 6,000 - 50% 50% Finance Dept Indirect Chgs 413,937 413,937 - 50% 50% Total Revenues 449,735 445,093 (4,642) 50% 49% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency $ 603,000 $ 788,522 $ 185,522 40,000 42,000 2,000 150 401 251 15,446 15,446 - 4,000 5,000 1,000 12,000 12,000 - 827,874 827,874 - 899,470 902,721 3,251 1,052,735 1,233,615 180,880 50% 82% 1,502,470 1,691,243 188,773 Exp. 452,566 422,067 30,498 50% 47% 905,131 905,131 - 137,451 164,852 (27,401) 50% 60% 274,902 274,902 - 5,000 - 5,000 50% 0% 10,000 - 10,000 156,219 - 156,219 50% 0% 312,437 - 312,437 TOTAL REQUIREMENTS 751,235 586,919 164,316 50% 39% NET (Resources - Requirements) 301,500 646,696 345,196 Beginning NWC Per FY 2013 Requested Budget 1,502,470 1,180,033 322,437 511,210 511,216-- 540,000 Legal-640 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital $ 148,500 $ 154,921 $ 6,421 100% Revenues Sale Map Photo or Copies 150 123 (27) 50% Miscellaneous 500 6 (494) 50% Interest on Investments 750 722 (28) 50% Interfund Contract 4,750 - (4,750) 50% Legal Counsel Indirect Chgs 377,316 377,316 - 50% Total Revenues 383,466 378,167 (5,299) TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % C0II % Budget Projection Variance 531,966 533,089 n/a $ 148,500 $ 154,921 $ 6,421 41% 300 300 - 1% 1,000 1,000 - 48% 1,500 1,500 - 0% 9,500 9,500 - 50% 754,632 754,632 - 766,932 766,932 1,123 50% 58% Exp. 915,432 921,853 6,421 375,760 323,237 52,522 50% 43% 751,519 751,519 - 22,321 19,100 3,221 50% 43% 44,642 44,642 - 50 - 50 50% 0% 100 - 100 59,586 - 59,586 50% 0% 119,171 - 119,171 457,716 342,337 115,379 50% 37% NET (Resources - Requirements) 74,250 190,751 116,501 Beginning NWC Per FY 2013 Requested Budget 915,432 796,161 119,271 125,692 125,692 150,000 Personnel - 650 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments Personnel Indirect Chgs Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 305,500 $ 360,650 $ 55,150 100% nla $ 305,500 $ 360,650 $ 55,150 500 274 (226) 50% 27% 1,500 1,434 (66) 50% 48% 362,665 362,665 - 50% 50% 364,665 364,373 (292) 50% 50% TOTAL RESOURCES 670,165 725,023 54,858 1,000 274 (726) 3,000 3,000 - 725,330 725,330 - 729,330 728,604 (726) 1,034,830 1,089,254 54,424 REQUIREMENTS: Exp. Expenditures Personal Services 305,292 297,275 8,017 50% 49% Materials and Services 153,705 67,391 86,313 50% 22% Capital Outlay 50 - 50 50% 0% Contingency 58,369 - 58,369 50% 0% TOTAL REQUIREMENTS 517,415 364,666 152,749 50% 35% NET (Resources - Requirements) 152,750 360,357 207,607 610,584 610,584 - 307,409 200,000 107,409 100 - 100 116,737 - 116,737 1,034,830 810,584 224,246 - 278,670 278,670 Beginning NWC Per FY 2013 Requested Budget 290,000 7 Information Tech - 660 Statement of Financial Operating Data Six Months Ended December 31, 2011 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 513,000 $ 650,653 $ 137,653 100% nla $ 513,000 $ 650,653 $ 137,653 Revenues Miscellaneous - 50 50 50% n/a - 50 50 Interest on Investments 2,000 2,635 635 50% 66% 4,000 4,000 - Leases 10,500 16,047 5,547 50% 76% 21,000 30,000 9,000 I T Indirect Chgs 1,011,623 1,011,623 - 50% 50% 2,023,245 2,023,245 - Total Revenue 1,024,123 1,030,355 6,232 50% 50% 2,048,245 2,057,295 9,050 Transfers In-General Fund 33,000 33,000 - 50% 50% 66,000 66,000 - TOTAL RESOURCES 1,570,123 1,714,007 143,885 50% 65% 2,627,245 2,773,948 146,703 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency Exp. 914,081 859,182 54,899 50% 47% 1,828,162 1,828,162 - 259,043 162,578 96,465 50% 31% 518,085 518,085 - 50 - 50 50% 0% 100 - 100 140,449 - 140,449 50% 0% 280,898 - 280,898 TOTAL REQUIREMENTS 1,313,623 1,021,760 291,863 50% 39% NET (Resources - Requirements) 256,500 692,248 435,748 Beginning NWC Per FY 2013 Requested Budget 2,627,245 2,346,247 280,998 427,701 427,701 568,550 IT Reserve - 661 Statement of Financial Operating Data Six Months Ended December 31, 2011 RESOURCES: Beg. Net Working Capital Revenues Interest IT Reserve Charges Total Revenue Year to Date Revised Year End Budget Actual Variance FY % coil. % Budget Projection Variance $ 304,896 $ 340,594 $ 35,698 100% n/a $ 304,896 $ 340,594 $ 35,698 750 1,467 717 50% 98% 1,500 3,000 1,500 117,000 117,000 - 50% 50% 234,000 234,000 - 117,750 118,467 717 50% 50% 235,500 237,000 1,500 TOTAL RESOURCES 422,646 459,061 36,415 50% 85% REQUIREMENTS: Exp. Expenditures Materials and Services 55,750 11,326 44,424 50% 10% Capital Outlay 49,500 43,848 5,652 50% 44% Res for Future Expenditure 164,948 - 164,948 50% 0% TOTAL REQUIREMENTS 270,198 55,174 215,024 50% 10% NET (Resources - Requirements) 152,448 403,887 251,439 Beginning NWC Per FY 2013 Requested Budget 540,396 577,594 37,198 111,500 99,000 329,896 111,500 - 99,000 - - 329,896 540,396 210,500 329,896 - 367,094 367,094 365,593 TO: BOARD OF COUNTY COMMISSIONERS FROM: DAVE INBODY SUBJECT: FY 2012 SPRAY AND NEUTER GRANT AWARDS DATE: 1/26/2012 CC: 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. Spay and Neuter Grant Funding Sources 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. Spay and Neuter Grant Recipients FY 2012 Grants This year contributions from dog licensees and pet ID applicants totaled $2,952.29. It is requested, similar to last year, that the Board of Commissioners authorize $10,047.71 in additional funding in support of this grant, which would create a total amount for spay and neuter grants of $13,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 Recommendations Five applications were received for Spay and Neuter Grants. These applications were reviewed by Robin Ingram (Accounting Clerk in Finance responsible for dog licenses), Cheryl Circle (Revenue Accounting Supervisor) and Dave Inbody (Assistant to the County Administrator). All reviewers were asked to rate each applicant on the criteria as described above. Additionally, each reviewer was asked to indicate whether they felt the applicant should receive a grant. All three reviewers recommended that all five applicants should receive a grant, with one exception. Reviewers were also asked to recommend how the $13,000 in funding should be distributed between the applicants. It is recommended that the Spay and Neuter Grant funding be distributed based on the average of the three recommended grant amounts from the reviewers. These amounts are as follows: • Bend Spay and Neuter Project $4,000 • Cat Rescue, Adoption & Foster Team $4,000 • Humane Society of Redmond $2,000 • Humane Society of Central Oregon $2,000 • Equine Outreach $1,000 2 DRAFT Board Retreat Agenda 1. FY 2011-12 Goals and Update 2. FY 2012-12 Goal setting 3. Budget -Current year one time revenue -Last year Budget Committee follow up items -FY 12-13 budget: -budget priorities -budget process -budget assumptions -budget requests: 4. BOCC Business meetings - department presentations 5. CFC future