Loading...
2011-38-Minutes for Meeting January 31,2011 Recorded 2/11/2011COUNTY NANCYUBLANKENSHIP,F000NTY CLERKOS Q 2011-38 COMMISSIONERS' JOURNAL 02/11/201108:03:42 AM IIIIIII IIIIIIIIIIIIIIIIII III 2011-38 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.ora MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, JANUARY 31, 2011 Present were Commissioners Tammy Baney, Alan Unger and Tony DeBone. Also present were Dave Kanner, County Administrator; Erik Kropp, Deputy County Administrator; and, for a portion of the meeting, Marty Wynne, Finance; Judith Ure, Administration; Tom Anderson and Nick Lelack, Community Development; representatives of the media from The Bulletin, The Source and KBND radio, and four other citizens. Chair Baney opened the meeting at 1: 30 p.m. 1. Finance Update. Marty Wynne explained there is a 0.7% budgeted yield, and this should be able to be maintained for the year. Commissioner Unger asked about corporate notes. Mr. Wynne said the amount is established at the time of purchase. Regarding operating reports, $1.8 million will be transferred from the general fund, and an update forecast is due after March. For Community Development, the budgeted amount is holding, but it will start out $500,000 down for FY 2011-12. Revenue is off by over $200,000 for the first six months. January was good for the Health Benefits Trust fund. It was around 9% up to that point, but is now at about 4%. It is projected to be between 5-7.5%. By the end of 2011, if nothing changes, it may be upside down. This assumes that the employee contribution will increase from $50 to $65 per employee. This will mean indirect charges to departments at 5% more. An assumption for future years shows charges to departments increasing by 10% per year, if the employee contribution stays the same. A significant assumption is the employee on-site clinic will generate savings. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 1 of 9 Pages It costs a lot to keep funds in reserve, so a decision needs to be made whether all of this reserve is necessary. Mr. Kanner stated that five-year forecasts are notorious for being off. Historically, claims have been 9-10% over the past five or six years. Mr. Wynne referred to the overhead projection of a spreadsheet. He said if assumptions remain the same, there would be a 10% increase per year. Instead of percentages of 5, 5, 10, 10, 10, it could be 7.5% for each. The bottom end working capital may not need $13-15 million in reserves. The fund cannot continue with increased costs without offsetting by employee contributions. Regarding capital projects, the Oregon State Police and 911 projects came in below budget. Mr. Kanner noted that the savings would probably move into the debt service fund. 2. Update regarding Bethlehem Inn Lease Agreement. Erik Kropp said that a discussion of the status of the Bethlehem Inn is desired prior to proceeding with a lease. A couple of items have been added: an update on the Bethlehem Inn strategy, and some ways to come up with outcome measures. Three members would be added to the Board by Deschutes County as well. If measures can be met, lease payments will be held in an account. Chair Baney stated that they are trying to find ways to success. It is important to have these services in the community. She is concerned because when space is offered to nonprofits, it is difficult to have a successful exit. The services are needed, but there needs to be a way to make sure goals are met. She does not want to see, after two years, no way for them to move out. Then the agreement would be back to square one. She said she is concerned about the model of looking for state or federal funds for shelters. A lot has changed in the economy and funding. She wants to know what they hope to achieve during that time. She sees them keeping the service, but not necessarily the same structure. Perhaps there should be more of a community model. Commissioners Unger and DeBone agreed. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 2 of 9 Pages Deborah Bolton stated she is appreciative of the County's support. They have earned a reputation in the community for handling a growing, critical issue. Their work evolved from the grassroots level to more than just occasional overnight stays. They know the challenges of funding. The lease is clear regarding responsibilities, and they have upheld it except in a few areas. They have established a task force to put together a plan, but do not have it to present at this time. Industry experts are helping them pin this information down. Nothing has been approved thus far by their board. The continued partnership and sharing of ideas helps. Tom O'Brien said they would welcome having others on their board. They have guidelines, a nominating committee and more. Their board agreed to two additional people at the time, as he was not clear three were desired. They are allowed a maximum of 13 and they have 11 now. They want people who can really help. To add a third, they would have to change their bylaws. Chair Baney asked what their needs on their board might be, in relation to expertise or knowledge. Mr. O'Brien replied a lot of board members are fairly new to the community. More experience at the local level would be helpful. About 2/3 of donations are from individual contributors. Gwenn Wysling said that there is other work going on behind the scenes at the Inn. Their board has stepped up to maintain or increase ways to meet the needs of the community. The need and demographics are very different than they were a few years ago. Management has changed, but there is a solid group now and they have the support of the community. Chair Baney asked about outcomes, so the County will know what progress is being made. Ms. Wysling asked if this should be addressed outside the lease. Chair Baney replied that it has some bearing on negotiations, but not necessarily within executive session. Ms. Bolton stated that they have some properties identified, but that is not for disclosure yet. Chair Baney said that she is looking primarily at benchmarks. Ms. Wysling stated that is would not all be based on fundraisers, as there are some financial strategies that cannot be identified at this time. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 3 of 9 Pages Chair Baney stated that at the end of the agreement, a decision would have to be made as to whether to turn the property back to Bethlehem Inn. Commissioner Unger added that the outcomes might be dynamic; at that time, the County can choose to adjust or renew. Ms. Wysling indicated the group will update the County on their progress. Ms. Bolton added that they will work within the scope of lease, but 17 months is quick. They will perhaps identify another site during that time and ask for adjustments if more time is needed. Mr. O'Brien added that they are serious about looking, but are sensitive about announcing any plans at this time. Dave Kanner noted that the lease rate would be equal to the interest, and payments should be applied to the fund instead of held separately. Chair Baney said it should be noted that the intent is at the end of the two-year agreement, if they have the ability to move forward, the County would give them this amount. Mr. Kanner said that they cannot appropriate funds before July 1, 2012. This would be subject to budget discussions for FY 2.012-13. Chair Baney noted that they have not been charged for the past 3-1/2 years. It will be money well spent if they meet their goals. Commissioner DeBone said that it appears the County is going to lose $1 million in this deal. The $2.5 million property is not as valuable as it was. Chair Baney stated that they are not parting with the property. Mr. Kropp added that the goal is to recoup the investment. Commissioner Unger said that he is supportive of what they are doing. There were expectations that the $1 million would be recouped, but sometimes plans just don't get there. Chair Baney stated that if the Bethlehem Inn stays, they would have a different vision. If they decide to move out, the County can look at other uses. Commissioner DeBone asked what market rent is on this type of property. Mr. Kropp replied that he tried to apply it, but it is hard to compute. Chair Baney indicated that two new members would be appropriate. She would like to have a quarterly update from them. Commissioner DeBone asked if they are going to install a kitchen. Ms. Deborah replied that finding an appropriate property is more important at this time. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 4 of 9 Pages 3. Review of Legislative Priorities. Mr. Kanner said that Public Affairs Counsel asked the Board to review some legislative items. He farmed some out to department heads. He would like the Board to determine the priority of some of the bills. Priority 1 would be very important and the County should take the lead. Priority 2 is important, and the County should provide input and support as appropriate. Priority 3 is possibly important; something for the County to watch. Priority 4 would have little relevance or impact on the County. HB 2151 - Liquor Licenses. This sets limits on the number of alcohol premises. The Commissioners said they are uncertain of the purpose of this bill. There are not that many outside of city limits. It was rated a 3. HB 2385 - Tobacco Tax. The Health Department wants active support. It allows counties to establish a tax, with 20% going towards local health costs. Commissioner Unger pointed out with the formula the State has, it is not certain how much would even come back to the County. Chair Baney added that the County might lose State revenue if this was a source for the County. It was rated a 2. BB 2518 - Real Estate Transfer Fee. Realtors do not support a transfer fee in an already depressed market. The Assessor said it may not affect the County dramatically, but could be challenging for his office. It would not necessarily benefit the County. More information is needed. It was rated a 2. HB 2609 - Buildable Land. It was felt this could be beneficial. Tom Anderson said this is primarily for cities or a metro service district. Commissioner Unger stated that it might help create a funding stream. Mr. Kanner said there is only one MSD and that is Metro. Mr. Kropp added that it could compete against what the County wants to do. Mr. Anderson said it is hard to tell if it is just for Metro. Mr. Kanner stated that `shovel ready' means that roads, etc. are in, and this only occurs in cities. This was rated a 3. HB 2710 - Court Fees. This refers to Justice Court, and would have an adverse effect. This was rated a 2. BB 2881 - Nuisance Ordinance - This would use the Assessor's Office to help collect fees. The consensus was that the idea was good, but the method is not. This was rated a 2, actively oppose. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 5 of 9 Pages HB 2997 - Regional Land Use Planning. This would create five regional land use planning commissions. The question was raised, would this take the place of LCDC? The implications are uncertain. Nick Lelack said this is a long shot. The one region would be all of eastern Oregon. It might be beneficial, but the DLCD would worry about consistency. This was rated a 2. SB 186 - Land Use Appeals. This would limit appeals to LUBA to property owners who have property located within a certain distance from the property directly affected by the decision. Commissioner Unger said that this takes away standing. There could be things that are of importance to others in regard to transportation, wildlife, the rivers or other issues. Chair Baney noted that this probably came up to deal with groups that are no-growth or have a financial interest, who get involved at the last minute. Mr. Lelack added that appeals are a great source of frustration. Perhaps they want to have any appeal to be raised at the local level first, or it cannot be raised at LUBA later. There will be more proposals to revise the appeal process. This was rated a 2. HB 2658 - Land Use Review. This concerns different filing fees. Community Development and Legal say it might limit the ability to collect fees or cover the cost of appeals. Mr. Anderson said it also makes it easier to submit appeals. More appeals will happen because of less cost, negatively impacting the County. This does not ease the requirements of which appeals should be addressed. This was rated a 2. SB 3075 541, 542 -Transient Lodging Tax. The Fair Board opposes these. The Road department supports them somewhat. Some funds would be for public health and safety. It would be the same amount of money spread out further. Chair Baney said that if the Board supports this, but the Fair Board does not, it is challenging. It does link tourism to roads. Federal road dollars are going away. This was rated a 2. Mr. Kanner said there is a rumor that the next budget cycle will eliminate State funding for county fairs. That's all some counties get for their annual fair. It amounts to about $30,000 here. The Fair Board. is soliciting letters to go to the State for this. Dan Despotopulos asked the Board to write a letter in this regard, as a good will gesture. He will forward sample letters. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 6 of 9 Pages SB 316 - Tax Credits, Enterprise Zones. This adjusts the sunset provision on rural enterprise zones. Mr. Lelack said he assumes this extends the sunset provision. There is none in this County, but Crook County has one. Commissioner Unger asked about the La Pine Industrial Park and the Bend Airport. It benefits businesses that want to come in and encourages industrial uses. Startup costs are expensive. Chair Baney asked why it isn't called a tax credit instead. This was rated a 2. SB 473 (Energy Facilities), 476 (Planning Goal Exceptions), 549 (Land Use Planning Goals), 477 (Farm Use Assessment), 548 (Exclusive Farm Use) and 547 (Secondary Lands). Mr. Anderson said these are meant to provide more development opportunities, but are also designed to work against Oregon land use planning. They are unlikely to have a chance. All but SB 476 and 549 were rated a 3 until it is known whether they remain viable. SB 476 is meant for a quick Goal exception for employers that create ten or more jobs. It would be for a use that is not allowed at all in the zone. Commissioner Unger observed that there could be unintended consequences. Mr. Lelack said it simply provides a process if the County chooses to exercise it. This was rated a 2. In regard to SB 549, Commissioner Baney said there is not enough money for sewering. It makes a false impression that it is even possible in most situations. Commissioner Unger noted that this issue needs some kind of funding. Mr. Kanner said that it creates a mechanism to begin. The County cannot be left on the hook if a sewer authority does not hold up. Commissioner DeBone stated it is at least moving towards something. Chair Baney said she is undecided if she is supportive. Mr. Anderson said there are two key considerations. It is still early, and it has not yet officially been reviewed by the DEQ steering committee. Taking a position now might not be a good idea; it would be better to wait to see what happens if and when it goes through committee. He will ask for feedback. This was rated a 2. Mr. Kanner said not on the list was a moratorium that all new rulemaking would include the Big Look legislation. He has not heard anything more on Skyline Forest legislation. Mr. Lelack said there is a lot going on behind the scenes. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 7 of 9 Pages 4. Update of Commissioners' Meetings and Schedules. There is a ribbon cutting at the employee clinic on Thursday. Jim Lussier, retired CEO of St. Charles, has been invited. Commissioner Unger will be meeting with ODOT in Salem on Friday to discuss flexible funding. He has a COIC board meeting and a COACT meeting on Thursday, and a south Redmond development meeting on Tuesday. He is meeting with Congressman Walden on Thursday regarding the Deschutes Water Alliance. Commissioner DeBone is starting to review Audit Committee information. He is attending a DEQ meeting Tuesday night. Chair Baney said she has a Commission on Children & Families' strategy meeting at AOC. She's also working on federal. legislation for NACo priorities. She plans to meet with Congressman Walden at Mid-Oregon Credit Union on Wednesday. He is adamant there is no plan in place for timber receipt funds. She wants to find out from him what might be needed. There is a conference call on Thursday regarding the sage grouse plan. They need to consider protection, economic development and property rights in this sensitive issue. 5. Other Items. Mr. Kanner said he is drafing a response to Mr. Lyons e-mail about Powell Butte Highway near the Bend Airport. This is a recurring theme from same person. It is not a great intersection, but the counts do not support changes. ODOT did a speed study but the counts are about half of that of other locations, and there have not been that many accidents. Chair Baney said she has been requested to participate in funding for NACo, which is in Portland next time. The Oregon Counties' Fund would do a state sponsorship through AOC. They'd like a contribution of $2,000. Mr. Kanner said he will figure out which funds to use. Chair Baney stated she has been reading the e-mails regarding notifications of threats or potential problems. People are more desperate and more frustrated with government. She wants to make employee safety a priority. Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 8 of 9 Pages Mr. Kanner said that I.T. is moving forward with a vendor. Security cameras for the parking lots and hallways may take longer. Mr. Kropp added that a comprehensive program is just starting. They need to figure out who, how and when to notify. They have a long way to go. Chair Baney would like to see this made a priority. Mr. Kropp said that Lt. Shelton and Capt. Mills are helping and will train. There will be at least annual training for all employees at some point. Mr. Kanner stated that the Board had asked about meeting with other boards of districts and committees. He will distribute a list of all that have an affiliation with the County so the Commissioners can identify which they want to meet with at some point. Commissioner DeBone stated that he hopes to spend some time meeting with local companies to see what the County can do for them. Being no further discussion, the meeting adjourned at 3: SS p. m. DATED thisi, Day of / 2011 for the Deschutes County Board of Commissioners. C4 Tammy Baney, Chair Anthony DeBone, Vice Chair ATTEST: a`"` ILYIt_L_ (&6t"a~,5k Alan Unger, Commissioner Recording Secretary Minutes of Board of Commissioners' Work Session Monday, January 31, 2011 Page 9 of 9 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, JANUARY 31, 2011 1. Finance Update - Marty Wynne 2. Update regarding Bethlehem Inn Lease Agreement - Erik Kropp 3. Review of Legislative Priorities - Dave Kanner, David Inbody 4. Update of Commissioners' Meetings and Schedules 5. Other Items 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. ~ J M H ~ ,s o co a v ~ 15 ~ 00 ~ M ~ t ~ o oL\ v_ Q 3~ 3 c ~ ~ ~ V 4 U \fl 4 • i- fo ~ a c ~N w o a~ ~ .~ea c0 n. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA January 31, 2011 (1) Monthly Investment Report (2) December 2010 Financials Document Reproduces Poorly (Archived) V C d C* N to ~ } 9 V. N o E cc Ma n r- (0 1- IL N ' N t0 t0 P n ^ M t00 ti m 0 E9 to N N O O C 0 N CD tU to tp E (0 w Cv) CI) Q C P N m ; Z O N C C C E m 0 t0~ V C o f0 O C C N d m > C Ua) g ~p f/1 J > C ip e~t1 C l0- 0 eeO s ge ° a °o^°tio0~~v o O PCOONPgo O ~ P gg t r- tf 0 0 0 IT N MOM N ' Q p' ' N O O O R LO O M CO V O LO CO M d V M to O CO t0 LO v- CO N P 40 M 1~ t'7 P j tf! 44 N . ' C to N to N S C . Q QI C U t ~ U U E C1 (L) 3 < N > 45 U 1 c`u m E o r EA- a) m a oo~ 0 00 LL mJ 0 b- t0 t0 N N C N OA Oe e e O O to to 1000 O P N N N W. P N y N CL 7 4) M r N U a 0 lN9 Q ¢ t: d 0 N rn 0 N N m a m E n CO (D M 0 _ N N N (n ~ U e Q {L ¢ N V F. C Y Y6 0 C N Q ~ ~ m U E U c Q ~ 00 d > U C m . O m ti ~o O ao~ 0Z`- CL U m N LO a 0 J t A ~ U U _U U U U _U _U U U U U U U U U U U U U U U U U U U U U U ? V _ n U p l U m i+ ~A j N G Z Z Z Z Z Z Z Z Z Z Z Z Z _ Z _ Z Z Z Z Z ' Z z Z ° ~ O R M O t(pp V - - - - - - - - - - - O U o o o N O CD O N O O Q o O o O o O d M V7 M N M n u) N N O IO O O d d N N O O M M 0 0 0 0 c0 iO Ol a0 n O 0 O (O N N N N d O O tp d O O d A O O n 6 O O N N n O) O O n (0 O O M M O o o 0 o 0 0 0 Op M O n n 10 O O N dd ,O N n O o n O 10 O O C O IO N ~O n M O 0 O (G 0 d O O N d 0 (O OI N N n d N d 1~ d O ,O M M O ,O o O O O M O [o o O 10 O (V N M n O 0 'o o D d M o O 00 M O o N LO 10 N O O 01 O O M . O O o a O O O O d M co r N a N d M N O N O O M N p N m m .C n M O (7 O M 00 M O tV O W N M ,O C ,O n Ol ~ ~O 00 n M 10 N n OJ ,O N Iq M n o N o o 0 0 0 00 n 0 O 00 d N O O o0 7 N E r y O d O ,O O O O O d O O N 0 O O O N d N N O m N O M O) n f O N N o n V; M O d O M N M N d d N d d n d N O V c M O aD N If O (V N O o N N a N CJ d (p 00 LLj (p 10 OI V M V O N a o o 00 ~ w m > > N N N N " N 0 N 0 N 0 N N N 0 N 0 N 0 N N 0 N N 0 N O N N O O N O O O O N 0 0 0 0 V O i0 d c M ,O o Iq (q I C N N N N N N N N N N N ( o t0 ~ 't M p ,A r to M (y n f0 M p 4) O O N N O O O O n N 10 0 O i0 N ,O n N N O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 N a0 O) c0 i0 M 0 9 0 0 0 0 n t0 O O O O N n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 00 O n n A ~p O N N n O ,O o O 00 N N O O n d (p O d O) O N 0 M 0 O N N c0 O 0 N M 0 O d 0 O d 0 O o 0 0 d M 0 d 0 d 0 0 0 f~ 00 O o O N N 0 N 0 N 0 O) 0 O 0 (0 O ~O 0 d 0 (0 0 N 0 c0 0 0 0 N d 0 r M M o rn e N Oi d O O N 10 M 0 M 0 O O O N <0 7 O 7 O O O 0 N M N d o 0 O n d O d O 0 d a0 ,O 0 O i0 t0 M M o O O d W OI O O i0 M O d n d N a o) m O d ap N O o O O N O O d O 0 c0 0 M 10 n M m m _ O d ~ T O O O O 10 M Y c O O Of O O) O 0 0 0 q 0 0 0 0 0 0 0 0 0 O N O U, N (5l O O M m m 0) M M m Of I Ol om n W <0 yy d d N N E N ~ N N (V N N N (V N N N N N (V N N ~ N N N ~ N ~ ~ of t0 n2 N o O o O ao n o 0 o 0 o 0 ao 0 o 0 o 0 o 0 o 0 0 0 o 0 0 o o 0 o 0 o 0 o 0 M N O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O 0 O o O 0 O 0 ao o 0 oo 0 0 o 0 I n N o n I n a W W O U O N ap O O O n ~O O 0 O O 0 d t0 0 0 I~ 10 0 0 O 0 O 0 O o 0 O 0 d o 0 (O 0 o ,0 o 0 O 0 O 0 O 0 t0 0 O Ol O 0 N 0 O 0 O 0 O 0 O 0 d 0 o 0 0 0 0 0 0 0 0 0 (O 0 O 0 O 0 Op 0 O 0 0 O O 0 O R O o r fV l+l M c oo O o O (~i M o O of O O o O d (~i d oi 0 o O 0 o O 0 o O 0 o o (0 ~ M M ad to n n o 0 o 0 o 0 o co 0 vi O 0 o o OD a n a o 0 o d 0 o o 0 vi m 0 o T N v N 0 o o 0 o a 0 o o ,O oi O O o o f0 ~i o d o a o i0 o t0 0 o 0 0 0 oo 0 0 0 o 0 m n N o eo OD o m ui c O W O O O) O ci W 0 0 W 0 o 0 o 0 0 0 0 0 0 N O O N c t T31 0 O 0 0 0 0 d A (V N (V N (V lV N N (V N N N N N N (V (V N N N N N N (V N N N o n N rn C O t O O C I1 p N y N 10 o C m m o m w m E o e s o o s a o o e s o o v o 0 o s o 0 o v o 0 o e s o o e e s o o v ° E n Z ' O m (0 O M N O M O N O M a0 d 0 0 ~O 0 ,O 0 O 0 10 0 M 0 N 0 O 0 0 0 M 0 0 0 0 0 0 0 0 N O O M O M O N e O o O o e O N e O o O 3 O 0 3 O A O m U m r N ¢ O m N gy O N n r N 0 00 O M M d O N O O O c0 O f0 O 00 10 n O 0 n OD M (0 0 O ~O O ,O n n ,O N f0 O r O N M O ,O Op M n O 0 O t0 O O M O N i0 t0 N (0 pp 40 N O A A N y N m m Q in m > C O N O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O E O Y a U o `O U E F m S LL m co a J A o H o o O O o O M e O a e O O a O N v 10 n e O 0 c O W o o W s a i0 e 0 M o ,O N o O O v ,O n a LO o 0 o 0 e 0 o 0 0 v 0 e 0 o a 0 N e O LL J Q' i0 M N N N O O n O M O M <0 O (0 O n n ~ O N t0 O O i0 N fp O a0 ,O n O o 10 N ~O N N O M O N O m C U F o O r 0 0 O d 0 ,O O O O O C m l m O ~H o N C N a Q Q' N E O IL m c O m n m ` U m c E Y F 0 ° m Q O Z T m t0 n o O) (0 n 0 t0 N 0 O d 10 O M n ap ,O N d ,O t0 d [0 r n s n S O n t0 M dM N 10OI d M M 10 M c0 d n N t0 O d ,O u7 M f0 o n t0 M 10 M O) p ~O Ol d 10 ap ,O M N h a0 10 00 n N Ol M O W r M n M n n O f0 M n r N n M n M n n M n c A m (0 10 E m > C w ( ~ - - - - f- - - - " - N N_ N N N_ N N_ N N N_ N_ N N N N N N m j 0 ' I~ r LL') a0 t0 O O m m t0 N N n n f~ a0 N t (h O M f~ Of OI OI W M N C ~ O O O \ M ~ ' N N O N N N N O O N O O O O O N N O O N O O N O N ~ ~ N O ~ ~ 0 0 0 ~ m~ j0 V E 0 0 0 0 ( ~ 0 (h 0 V' 0 0 N 0 i0 0 f0 0 ,D 0 n 0 aD 0 W 0 W 0 0 m 0 0 O O r N o 0 n a0 T O O O N > V ~ O F o 0 o 0 o 0 0 0 0 o o Q F J M A y 0 0 0 0 0 ° O O O O o Q 0 O_ o O_ O O o 0 _O O o 0 _O O o O O _O 0 0 0 0 0_ o O O_ _0 0 L O ~ T O O O> ~ O O A Of OI ~ r fh ~ n (O ~ ,A A N M A A n M N (p M M I~ V O~ ~ ~ OI O, fh E 7 Q ~ o O o ~ o M o N N o ~ \ N O N N N N N ` o \ o N O N ~ N N N M M O a N N O N O n N 1~ O N O N N N O N N N W ~ m N O O ~ 0 N 0 0 0 0 ~ N a o o ~ o o o o o o o o o o ~ ~ o o o ~ Q ca W LL m a m m z > r a LL ¢ a z ¢ o m U m co = x Y a a LY (n rn u~ n ; m V U LL L- F edAl O O ¢ Q LL Z Z O LL LL LL LL ¢ LL LL T r - LL m U U l L U U w U f i LL LL U LL U LL LL LL LL T tl~o9 - mLL' - LL S - Q m - ~'S - ~ U - VZJ - (Z - ~ - - (~/l Y - (Zp - d - ~ - S - 'a - (Zii - (Zo - e - S K U S m 7 cn w ~ S m 3 h 3 w 'a mW L O m a) O N O n Q t0 Q Z 10 L ,O LL O } m nn 'O 2' Z N Y J d Z X d M N OI a M 00 al O O O N 3 Z ¢ C MO J M t0 L M LL. "f NN M Q O ' Q Q n d Q M U' Q 10 M Q G • n r O N M M th M r M M M M M M M M N pOj X M M M M M a0 M (ND M m M ~ M d OI O O o m _ M M O M M M M f' M U Q M M Of O M M M CO) S M t7 M Cl) M M M M M M M M ~ O C 4 L U U 0 O U Z U U m y N a N U ° •a N U U U U Z U L] U , L C y l~ U C O C m t l O m m y C m y O U m t m p N N d . W U C m U m m Z y c y c m U 'a d m D U m l] U y c C m U m U y E U N m 1 m ` m • N y S (O a~ C C o U a a m O Z C m w N ' a, U ca m m V U U m m m LL 'C Q r n LL C ' N Z ; Cn m t0 i ¢ N m C C ~ f0 O ° C > U y c ` m y c U y c N y i ° ° E m d p m c ° LL n d y E N o U f 0 m d m m E m 'O U 61 m W N N m , y o m m o O In m m N m m m N m ~c c x c O E d E d U m y O t y c E a m ~ r U j Q d LL m m m » m m y c LL j m L « ` w m m m o o m U S d Y 'c lL d m K m N o N °I h E S m m o 0 o 0 m LL E N S p y m 0 E (0 m m m co N m m - O E j ~ m m LL Q Q Q Q m 7 E U C J 7 U v) U M 2 a' J J J E 2 d C 1 2 m m 020 C LL C S 0 S ~ U N U = LL O fn O (n (n MI Y LL LL S 3 E S LL LL L L Z O E EI S S LL O Z I O ' Z m Z LL Z LL J LL LL L L FLL U S m S LL LL A LL LL S LL U ~ LL LL m H Memorandum Date: January 13, 2011 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find December 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 GENERAL FUND Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End $ Budget Actual Variance FY % Coll. % Budget 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 10,283,000 18,603,798 8,320,798 50% 90% 20,566,000 20,566,000 - Gen. Rev. - excl. Taxes 1,198,569 1,717,773 519,204 50% 72% a) 2,397,138 2,397,138 - Assessor 397,845 464,232 66,387 50% 58% b) 795,690 795,690 - County Clerk 610,357 787,399 177,042 50% 65% 1,220,714 1,220,714 - BOPTA 6,199 843 (5,356) 50% 7% 12,398 12,398 - District Attorney 157,050 78,647 (78,403) 50% 25% 314,100 270,300 (43,800) Finance/Tax 90,100 119,545 29,445 50% 66% b) 180,200 180,200 - Veterans 33,933 16,886 (17,047) 50% 25% 67,866 67,866 - Property Management 45,566 51,080 5,514 50% 56% 91,132 91,132 - Grant Projects 1,000 1,000 0 50% 50% 2,000 2,000 - Total Revenues 12,823,619 21,841,203 9,017,584 50% 85% 25,647,238 25,603,438 (43,800) TOTAL RESOURCES 21,123,619 31,518,903 10,395,284 50% 93% 33,947,238 35,281,137 1,333,899 REQUIREMENTS: Exp, Expenditures Assessor 1,691,110 1,573,300 117,810 50% 47% 3,382,219 3,382,219 - County Clerk 742,064 665,442 76,622 50% 45% 1,484,127 1,484,127 - BOPTA 37,702 27,501 10,201 50% 36% 75,403 75,403 - District Attorney 2,441,064 2,349,759 91,305 50% 48% 4,882,127 4,748,714 133,413 Finance/Tax 423,455 437,087 (13,632) 50% 52% 846,910 846,910 - Veterans 131,099 130,472 627 50% 50% 262,197 262,197 - Property Management 126,614 125,797 817 50% 50% 253,227 253,227 - Grant Projects 56,102 54,321 1,781 50% 48% 112,203 112,203 - Non-Departmental 1,109,694 646,839 462,855 50% 29% 2,219,387 2,219,387 - Contingency 3,422,637 - 3,422,637 50% n/a 6,845,274 - 6,845,274 10,181,541 6,010,518 4,171,023 50% 30% 20,363,074 13,384,387 6,978,687 Transfers Out 6,487,082 6,669,257 (182,175) 50% 51% 12,974,164 12,974,164 - TOTAL REQUIREMENTS 16,668,623 12,679,775 3,988,848 50% 38% 33,337,238 26,358,551 6,978,687 NET (Resources - Requirements) 4,454,996 18,839,128 14,384,132 c) 610,000 8,922,586 8,312,586 a) YTD Actual includes annual payments: Federal in lieu of taxes - $471,913 and State tax on electric co-ops - $464,452. b) YTD Actual includes A&T grant received quarterly in advance c) Appropriation transferred to Fund 575 - $610,000 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date F Revised Year End -Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 987,000 $1,039,997 $ 52,997 100% 105% $ 987,000 $1,039,997 $ 52,997 Revenues Federal Grants 7,764 3,882 (3,882) 50% 25% a) 15,527 15,527 - SB #1065-Court Assess. 30,000 25,303 (4,697) 50% 42% 60,000 57,500 (2,500) Discovery Fee 8,000 6,843 (1,157) 50% 43% 16,000 16,000 - Food Subsidy 19,000 13,351 (5,649) 50% 35% b) 38,000 37,000 (1,000) OYA Basic & Diversion 170,003 48,917 (121,086) 50% 14% c) 340,006 324,264 (15,742) Inmate/Prisoner Housing 50,000 33,900 (16,100) 50% 34% d) 100,000 80,000 (20,000) Inmate Commissary Fees 50 59 9 50% 59% 100 100 - Contract Payments 44,245 33,505 (10,740) 50% 38% 88,490 70,000 (18,490) Miscellaneous 150 52 (98) 50% 17% 300 100 (200) MIP Diversion Fees 500 50 (450) 50% 5% 1,000 300 (700) Interest on Investments 8,500 4,464 (4,036) 50% 26% 17,000 9,000 (8,000) Leases 1,200 1,200 - 50% 50% 2,400 2,400 - Grants - Private 250 327 77 50% 65% 500 500 - Health & Human Svcs Chg 3,000 3,319 319 50% 55% 6,000 6,000 - CCF Interfund Grant 30,248 24,125 (6,123) 50% 40% b)e) 60,495 96,500 36,005 Gen Fund Grant-Crime Prev. 10,000 5,000 (5,000) 50% 25% 20,000 20,000 - Total Revenues 382,910 204,297 (178,613) 50% 27% 765,818 735,191 (30,627) Transfers In-General Fund 2,771,593 2,771,593 - 50% 50% 5,543,186 5,543,186 - TOTAL RESOURCES 4,141,503 4,015,887 (125,616) 50% 55% 7,296,004 7,318,374 22,370 REQUIREMENTS: Exp. Expenditures Community Justice-Juvenile Personal Services 1,481,978 1,357,424 124,554 50% 46% 0 2,963,956 2,750,000 213,956 Materials and Services 599,943 501,950 97,993 50% 42% g) 1,199,886 1,100,000 99,886 Capital Outlay 50 - 50 50% 0% 100 - 100 Juvenile Resource Center Personal Services 1,157,552 1,064,927 92,625 50% 46% h) 2,315,104 2,200,000 115,104 Materials and Services 87,747 83,163 4,584 50% 47% 175,494 167,000 8,494 Contingency 320,732 - 320,732 50% n/a 641,464 - 641,464 TOTAL REQUIREMENTS 3,648,002 3,007,464 640,538 50% 41% 7,296,004 6,217,000 1,079,004 NET (Resources - Requirements) 493,501 1,008,423 514,922 - 1,101,374 1,101,374 a) Second quarter Federal Grant anticipated in March b) Reimbursements for food subsidy received approximately one month after monthly billings, CCF billed quarterly c) OYA monies collected in Nov, Feb, May, and June - Reduction due to most current information from the State regarding cuts d) Revenue is generated when non-Deschutes juveniles utilize facility - less utilization than anticipated to date e) Additional funding from CCF allocated for Juvenile programs f) Salary savings due to approximately 3.00 FTE unfilled g) DHS/BRS match payments and Maplestar contract payments are less than originally budgeted due to reduction in youth using the program h) Salary savings due to less on-call and overtime for the detention facility SHERIFF - Fund 255 Statement of Financial Operating Data Six Months Ended December 31, 2010 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Total Revenues I Year to Date Year End Budget Actual Variance FY % Co. % Budget Projection Variance $ - $ 207,689 $ 207,689 100% nla $ - $ 207,689 $ 207,689 11,414,729 8,881,052 (2,533,677) 50% 39% 22,829,457 18,870,580 (3,958,877) 6,832,970 5,695,519 (1,137,451) 50% 42% 13,665,939 11,589,126 (2,076,813) - 7,911 7,911 50% n/a - 7,911 7,911 18,247,699 14,584,482 (3,663,217) 50% 40% 36,495,396 30,467,617 (6,027,779) TOTAL RESOURCES 18,247,699 14,792,171 (3,455,528) 50% 41% 36,495,396 30,675,306 (5,820,090) REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Sheriffs Division 1,420,834 1,517,974 (97,140) 50% 53% a) 2,841,668 2,875,668 (34,000) Civil 399,218 403,943 (4,725) 50% 51% 798,436 798,436 - Automotive/Communications 726,518 803,820 (77,302) 50% 55% b) 1,453,036 1,403,036 50,000 Investigations/Evidence 825,396 756,550 68,846 50% 46% b) 1,650,792 1,550,792 100,000 Patrol/Civil/Comm Supp 3,914,326 3,864,777 49,549 50% 49% c) 7,828,651 7,830,651 (2,000) Records 330,193 300,603 29,590 50% 46% 660,386 660,386 - Adult Jail 4,923,432 4,224,967 698,465 50% 43% d) 9,846,864 9,671,864 175,000 Court Security 120,426 133,664 (13,238) 50% 55% 240,851 240,851 - Emergency Services 87,221 82,603 4,618 50% 47% 174,441 174,441 - Special Services Division 583,702 568,290 15,412 50% 49% 1,167,404 1,167,404 - Regional Work Center 1,438,121 1,299,775 138,346 50% 45% e) 2,876,242 2,676,242 200,000 Training Division 165,000 127,057 37,943 50% 39% 330,000 330,000 - Other Law Enforcement Svcs 298,459 297,246 1,213 50% 50% 596,917 596,917 - Non-Departmental 141,509 41,509 100,000 50% 15% 283,018 283,018 - Contingency 2,773,345 - 2,773,345 50% n/a 5,546,690 - 5,546,690 Transfer Out - Jail Remodel 50,000 100,000 100,000 Transfers Out - D/S Fund 50,000 160,539 (110,539) 50% 161% 100,000 100,000 - TOTAL REQUIREMENTS 18,247,700 14,583,317 3,614,383 50% 40% 36,495,396 30,459,706 6,035,690 NET (Resources - Requirements) - 208,854 158,854 - 215,600 215,600 a) Higher than budgeted employee vacation sell back b) Delay in filling open positions will result in lower personnel expenditures for FY 2011 c) Projected savings due to open positions will be offset by unplanned purchase of additional patrol vehicles d) Unfilled budgeted positions in Adult Jail resulting in lower personnel expenditures for FY 2011. Forecast includes $292,000 for jail bed rental e) Unfilled budgeted positions and lower material and service expenditures projected for FY 2011 SHERIFF 701 Statement of Financial Operating Data Six Months Ended December 31, 2010 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants State Grant Transp. of State Wards SB 1145 Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Rentals Donations Sale of Reportable Assets Total Revenues TOTAL RESOURCES Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 4,722,862 $ 5,478,092 $ 755,230 100% 116% $ 4,722,862 $ 5,478,092 $ 755,230 7,4213,797 13,203,670 5,776,873 321,000 541,145 220,145 17,500 46,415 28,915 24,238 37,037 12,799 :2,500 - (2,500) 987,330 987,330 - :2,500 - (2,500) 4.7,500 47,427 (73) - 3,454 3,454 75,000 59,492 (15,508) 2,000 424 (1,576) - 3,825 3,825 24,000 25,759 1,759 12,500 37,470 24,970 :3,000 1,525 (1,475) 2,500 4,800 2,300 ?,500 3,266 766 - 5,120 5,120 (3,000 6,479 479 500 3,303 2,803 80,000 129,870 49,870 14,167 16,889 2,722 1,767 1,318 (449) - 2,500 2,500 - 200 200 - 1,257 1,257 9,053,299 15,169,975 6,116,676 50% 89% 14,853,594 14,853,594 - 50% 84% 642,000 727,000 85,000 50% 133% a) 35,000 35,000 - 50% 76% 48,475 48,475 - 50% 0% 5,000 5,000 - 50% 50% a) 1,974,660 1,854,660 (120,000) 50% 0% 5,000 5,000 - 50% 50% 95,000 95,000 - 50% n/a - 3,454 3,454 50% 40% a) 150,000 150,000 - 50% 11% 4,000 4,000 - 50% n/a - 3,825 3,825 50% 54% 48,000 48,000 - 50% 150% b) 25,000 50,000 25,000 50% 25% 6,000 6,000 - 50% 96% 5,000 5,000 - 50% 65% 5,000 5,000 - 50% n/a - 10,000 10,000 50% 54% 12,000 12,000 - 50% 330% 1,000 5,000 4,000 50% 81% C) 160,000 200,000 40,000 50% 60% 28,333 28,333 - 50% 37% 3,533 3,533 - 50% n/a - 2,500 2,500 50% n/a - 200 200 50% n/a - 1,257 1,257 50% 84% 18,106,595 18,161,831 55,236 13,776,161 20,648,067 6,871,906 50% REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 11,414,729 8,881,052 2,533,677 50% 90% 22,829,457 23,639,923 810,466 Exp. TOTAL REQUIREMENTS 11,414,729 8,881,052 2,533,677 50% NET (Resources - Requirements) 2,361,432 11,767,015 9,405,583 a) Anticipated funding reduction from Dept. of Corrections b) Contract revenue from USFS is higher than anticipated c) Actual revenue for concealed weapons permits and civil papers will exceed budget d) Payment to Sheriffs Office adjusted to actual quarterly 39% d) 22,829,457 18,870,580 3,958,877 39% 22,829,457 18,870,580 3,958,877 4,769,342 4,769,342 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants Federal Grants-BLM US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grant Des Cty Transient Room Tax City of Sisters Des Cty Tax/Fin Contract Des Cry 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 Interest Interest on Unsegregated Donations Sale of Reportable Assets Sale of Equip & Material Total Revenues TOTAL RESOURCES SHERIFF 702 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $1,905,939 $ 2,421,863 $ 515,924 100% 127% $1,905,939 $2,421,863 $ 515,924 3,754,123 6,650,715 2,896,592 50% 89% 7,508,247 7,508,247 - 157,000 269,985 112,985 50% 86% 314,000 371,000 57,000 1,000 4,916 3,916 50% 246% a) 2,000 10,000 8,000 - 5,981 5,981 50% n/a - 10,000 10,000 38,250 44,625 6,375 50% 58% 76,500 76,500 - 93,817 61,164 (32,653) 50% 33% 187,633 187,633 - 33,500 25,303 (8,197) 50% 38% 67,000 67,000 - 71,217 - (71,217) 50% 0% b) 142,433 142,433 - 351,179 - (351,179) 50% 0% c) 702,358 702,358 - 973,821 973,821 - 50% 50% 1,947,642 1,947,642 - 216,327 216,327 - 50% 50% 432,655 432,655 - 500 - (500) 50% 0% 1,000 1,000 - 27,183 27,183 - 50% 50% 54,366 54,366 - 27,183 27,183 - 50% 50% 54,366 54,366 - 1,000 675 (325) 50% 34% 2,000 2,000 - 50,000 6,103 (43,897) 50% 6% d) 100,000 100,000 - 6,500 1,081 (5,419) 50% 8% 13,000 13,000 - 3,000 3,725 725 50% 62% 6,000 6,000 - 5,000 6,917 1,917 50% 69% 10,000 10,000 - 250 - (250) 50% 0% 500 500 - 5,000 4,720 (280) 50% 47% 10,000 10,000 - 42,500 61,104 18,604 50% 72% e) 85,000 120,000 35,000 7,500 3,300 (4,200) 50% 22% 15,000 15,000 - 250 - (250) 50% 0% 500 500 - 5,000 5,850 850 50% 59% 10,000 10,000 - 900 662 (238) 50% 37% 1,800 1,800 - - 150 150 50% n/a - 150 150 5,000 21,318 16,318 50% 213% f) 10,000 25,000 15,000 3,000 6,716 3,716 50% 112% 6,000 10,000 4,000 5,880,000 8,429,524 2,549,524 50% 72% 11,760,000 11,889,150 129,150 7,785,939 10,851,386 3,065,447 50% 79% 13,665,939 14,311,013 645,074 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 6,832,970 5,695,519 1,137,451 50% TOTAL REQUIREMENTS 6,832,970 5,695,519 1,137,451 50% NET (Resources - Requirements) 952,969 5,155,867 4,202,898 a) Actual HIDTA overtime reimbursement higher than budgeted b) Payments are received in Feb & June c) Grant will be received in June 2011 d) Most of this revenue is received in Quarters 3 & 4 e) Revenue from traffic fines will exceed budget f) Proceeds from sale of used patrol vehicles were higher than estimated g) Payment to Sheriffs Office adjusted to actual quarterly Exp. 9/61 42% g) 13,665,939 11,589,126 2,076,813 42% 13,665,939 11,589,126 2,076,813 2,721,887 2,721,887 PUBLIC HEALTH Statement of Financial Operating Data Six Months, Ended December 31, 2010 Year to Date Revised Year End Fudget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,100,000 $ 1,615,306 $ 515,306 100% 147% $1,100,000 $1,615,306 $ 515,306 Revenues Medicare Reimbursement 4,000 9:2 (3,908) 50% 1% 8,000 200 (7,800) State Grant 1,256,489 1,305,500 49,011 50% 52% 2,512,977 2,573,752 60,775 Child Dev & Rehab Center 15,380 7,690 (7,690) 50% 25% 30,759 30,759 - State Miscellaneous 109,948 77,496 (32,452) 50% 35% 219,896 219,896 - OMAP 238,900 267,668 28,768 50% 56% 477,800 477,800 - Family Planning Exp Proj 247,500 222,506 (24,994) 50% 45% 495,000 533,000 38,000 Grants 32,500 65,605 33,105 50% 101% a) 65,000 113,773 48,773 Water Program-Base Fee 21,000 18,77:2 (2,228) 50% 45% 42,000 42,000 - Water Program-Field Work 27,909 30,240 2,331 50% 54% 55,817 55,817 - H20 Sys Insp-Priv Wells 100 - (100) 50% 0% 200 200 - Miscellaneous - 38 38 50% n/a - 201 201 Patient Insurance Fees 95,130 58,184 (36,946) 50% 31% 190,260 120,260 (70,000) Health Dept/Patient Fees 74,488 50,609 (23,879) 50% 34% 148,975 100,975 (48,000) Vital Records-Birth 18,000 15,125 (2,875) 50% 42% 36,000 30,000 (6,000) Vital Records-Death 49,000 49,235 235 50% 50% 98,000 96,000 (2,000) Environmental Health 343,675 398,049 54,374 50% 58% 687,350 687,350 - Interest on Investments 8,450 5,695 (2,755) 50% 34% 16,900 12,758 (4,142) Donations 3,000 30,981 27,981 50% 516% b) 6,000 35,430 29,430 Interfund Contract 94,689 17,092 (77,597) 50% 9% 189,378 162,513 (26,865) Administrative Fee 13,500 13,500 - 50% 50% 27,000 27,000 - Total Revenues 2,653,658 2,634,077 (19,581) 50% 50% 5,307,312 5,319,684 12,372 Transfers In-General Fund 1,158,883 1,158,883 - 50% 50% 2,317,765 2,317,765 - Transfers In-PH Res Fund 33,562 33,562 - 50% 50% 67,123 67,123 - Transfers In-Gen. Fund Other 33,906 33,906 - 50% 50% 67,812 67,812 - TOTAL RESOURCES 4,980,009 5,475,734 495,725 50% 62% 8,860,012 9,387,690 527,678 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 2,970,477 2,814,243 156,234 50% 47% 5,940,953 5,707,953 233,000 1,002,694 971,635 31,059 50% 48% 2,005,387 1,905,118 100,269 12,500 5,432 7,068 50% 22% 25,000 25,000 - 75,000 75,000 - 50% 50% 150,000 150,000 - 369,336 - 369,336 50% n/a 738,672 - 738,672 4,430,007 3,866,310 563,697 50% 44% 8,860,012 7,788,071 1,071,941 550,002 1,609,424 1,059,422 - 1,599,619 1,599,619 a) Health Matters-local grant for Chronic Care Program is $17,000 & $21,000. Bioterrorism NACCHO grant $10,000 received in July b) My Future My Choice donation carry over from FY10, in the amount of $25,880. $3550 HIV sponsorship donation BEHAVIORAL HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 2,616,050 $ 2,651,262 $ 35,212 100% 101% $ 2,616,050 $ 2,651,262 $ 35,212 Revenues Marriage Licenses 2,750 2,950 200 50% 54% 5,500 5,500 - Divorce Filing Fees 65,000 66,568 1,568 50% 51% 130,000 130,000 - Domestic Partnership Fee 500 30 (470) 50% 3% 1,000 250 (750) Federal Grants 48,485 20,660 (27,825) 50% 21% a) 96,969 96,969 - State Grants 2,981,666 2,851,842 (129,824) 50% 48% b) 5,963,332 5,690,358 (272,974) State Miscellaneous 74,087 41,500 (32,587) 50% 28% 148,173 148,173 - ABHA - 4,000 4,000 50% n/a - 4,000 4,000 Title 19 150,463 57,484 (92,979) 50% 19% 300,925 200,000 (100,925) Liquor Revenue 52,700 52,547 (153) 50% 50% 105,400 105,400 - School Districts 35,000 20,440 (14,560) 50% 29% 70,000 70,000 - Miscellaneous 8,450 19,708 11,258 50% 117% 16,900 25,000 8,100 Patient Insurance Fees 77,000 33,979 (43,021) 50% 22% 154,000 75,000 (79,000) Patient Fees 6,500 961 (5,539) 50% 7% 13,000 3,000 (10,000) Interest on Investments 21,793 12,080 (9,713) 50% 28% 43,585 25,000 (18,585) Rentals 6,550 6,625 75 50% 51% 13,100 13,100 - Interfund Contract-Gen. Fund 63,500 39,771 (23,729) 50% 31% a) 127,000 127,000 - Comm. on Children & Fam 12,000 - (12,000) 50% 0% c) 24,000 - (24,000) Administrative Fee 2,105,729 2,088,569 (17,160) 50% 50% 4,211,457 4,211,457 - Total Revenues 5,712,173 5,319,714 (392,459) 50% 47% 11,424,341 10,930,207 (494,134) Transfers In-General Fund 658,079 658,079 - 50% 50% 1,316,158 1,316,158 - Transfers In-OHP-CDO 50,000 50,000 - 50% 50% 100,000 100,000 - Transfers In-Acute Care Svcs 182,829 182,829 - 50% 50% 365,657 365,657 - Transfers In-ABHA 334,126 334,126 - 50% 50% 668,252 668,252 - TOTAL RESOURCES 9,553,257 9,196,010 (357,247) 50% 56% 16,490,458 16,031,536 (458,922) REQUIREMENTS: Exp. Expenditures Personal Services 4,613,231 4,391,863 221,368 50% 48% d) 9,226,461 8,713,883 512,578 Materials and Services 2,336,186 1,637,166 699,020 50% 35% 4,672,371 3,969,470 702,901 Capital Outlay 383,000 - 383,000 50% 0% 766,000 766,000 - Transfers Out 78,582 75,000 3,582 50% 48% 157,164 157,164 - Contingency 834,231 - 834,231 50% n/a 1,668,462 - 1,668,462 TOTAL REQUIREMENTS 8,245,230 6,104,029 2,141,201 50% 37% 16,490,458 13,606,517 2,883,941 NET (Resources - Requirements) 1,308,027 3,091,981 1,783,954 - 2,425,019 2,425,019 a) Grant billing received quarterly, in arrears b) Department of Human Services Grant projected at amended contract amount for FY 11 c) Child and Family prevention program eliminated d) Personnel expenditure projected to be less than budgeted due to unfilled positions COMMUNITY DEVELOPMENT Statement of Financial Operating Data Six Months Ended December 31, 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) 8,250 9,380 1,130 50% 57% 16,500 18,000 1,500 1,375 3,447 2,072 50% 125% a) 2,750 6,000 3,250 80,859 74,606 (6,253) 50% 46% 161,718 164,400 2,682 540,609 423,673 (116,936) 50% 39% b) 1,081,217 1,069,000 (12,217) 133,326 127,979 (5,347) 50% 48% 266,652 261,000 (5,652) 92,000 116,471 24,471 50% 63% c) 184,000 189,500 5,500 141,915 138,483 (3,432) 50% 49% 283,830 275,600 (8,230) 388,481 337,957 (50,524) 50% 43% d) 776,962 708,000 (68,962) 176,886 123,364 (53,522) 50% 35% e) 353,771 338,600 (15,171) 1,563,701 1,355,360 (208,341) 50% 43% 3,127,400 3,030,100 (97,300) Trans In-GF 126,694 126,694 - 50% 50% 253,387 253,387 - Trans In-GF for Lng Rng Ping 258,000 258,000 - 50% 50% 516,000 516,000 - TOTAL RESOURCES 2,634,476 2,353,085 (281,391) 50% 51% 4,582,868 4,412,518 (170,350) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 701,198 690,519 10,679 Admin-GIS 108,068 103,130 4,938 Admin-Code Enforcement 92,366 91,597 769 Building Safety 250,165 241,945 8,220 Electrical 93,803 88,829 4,974 Contract Services 122,126 119,199 2,927 Env Health-On Site Pgm 116,003 135,229 (19,226) Planning-Current 345,145 310,001 35,144 Planning-Long Range 246,214 286,772 (40,558) Transfers Out (D/S Fund) 86,655 145,000 (58,345) Contingency 129,693 - 129,693 Exp. 50% 49% 1,402,396 1,402,396 - 50% 48% f) 216,135 168,000 48,135 50% 50% 184,732 184,732 - 50% 48% g) 500,330 475,200 25,130 50% 47% 187,606 187,606 - 50% 49% 244,251 244,251 - 50% 58% h) 232,006 220,000 12,006 50% 45% 690,290 690,290 - 50% 58% i) 492,427 492,427 - 50% 84% 173,310 173,310 - 50% n/a 259,385 - 259,385 TOTAL REQUIREMENTS 2,291,436 2,212,221 79,215 50% 48% NET (Resources - Requirements) 343,040 140,864 (202,176) Revenues 1,355,360 Expenditures 2,212,221 Net from Operations (856,861) 4,582,868 4,238,212 344,656 174,306 174,306 3,127,400 3,030,100 (97,300) 4,582,868 4,238,212 344,656 (1,455,468) (1,208,112) 247,356 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 ($200,000 Sunriver Aquatic Ctr, $50,000 La Pine biomass plant) c) City of Redmond receipts lag one month behind. YTD is high due to new high school fee revenue d) YTD business volume/revenue less than expected e) Grant payments received irregularly f) Savings due to resignation of CDD webmaster, who will not be replaced g) Savings due to retirement of Building Inspector in January. Decision on replacement will be made at a later date h) Includes $35,651 in time management payout to retired employee, to be made up by salary savings as position will remain unfilled i) 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 Six Months Ended December 31, 2010 RESOURCES: Beg. Net Working Capital Revenues Mineral Lease Royalties Forest Receipts State Miscellaneous Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SDC) Miscellaneous Road Vacations Interest on Investments Other Bank/LGIP Interest Parking Fees Grants-Private Interfund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Forester Car Washes Car Rental Sale of Equip & Material Total Revenues Trans In - Solid Waste Trans In - Transp SDC Trans In-Road Imp Res 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 $ 3,430,429 $ 3,419,603 $ (10,826) 100% 100% $ 3,430,429 $ 3,419,603 $ (10,826) 10,000 5,108 (4,892) 50% 26% a) 20,000 5,108 (14,892) 1,118,500 - (1,118,500) 50% 0% b) 2,237,000 2,237,060 60 48,492 - (48,492) 50% 0% c) 96,984 - (96,984) 5,000,000 4,258,609 (741,391) 50% 43% d) 10,000,000 9,850,000 (150,000) 137,500 215,049 77,549 50% 78% e) 275,000 275,000 - 175,000 250,458 75,458 50% 72% e) 350,000 350,000 - 5,000 - (5,000) 50% 0% e) 10,000 10,000 - 5,000 - (5,000) 50% 0% e) 10,000 10,000 - - 843 843 50% n/a - 1,000 1,000 45,000 16,628 (28,372) 50% 18% 90,000 90,000 - 500 500 - 50% 50% 1,000 1,000 - 20,000 10,599 (9,401) 50% 26% 40,000 40,000 - - 61 61 50% n/a - 100 100 450 - (450) 50% 0% 900 900 - - 2,434 2,434 50% n/a - 2,434 2,434 375,000 234 (374,766) 50% 0% f) 750,000 750,000 - 125,000 77,306 (47,694) 50% 31% 250,000 250,000 - 45,000 - (45,000) 50% 0% 90,000 90,000 - 5,000 - (5,000) 50% 0% 0 10,000 10,000 - 17,500 - (17,500) 50% 0% 0 35,000 35,000 - 12,500 - (12,500) 50% 0% 0 25,000 25,000 - 1,500 1,428 (72) 50% 48% 3,000 3,000 - -250 - (250) 50% 0% 500 500 - 301,750 224,667 (77,083) 50% 37% 603,500 603,500 - 7,448,942 5,063,924 (2,385,018) 50% 34% 14,897,884 14,639,602 (258,282) 145,870 145,870 - 50% 50% 291,740 291,740 - 100,000 100,000 - 50% 50% 200,000 200,000 - 6,020 - (6,020) 50% 0% 12,040 12,040 - 11,131,261 8,729,397 (2,401,864) 50% 59% 18,832,093 18,562,985 (269,108) Exp. 2,876,484 2,695,150 181,334 50% 47% 5,752,967 5,752,967 - 4,735,512 4,459,591 275,921 50% 47% 9,471,023 9,471,023 - 585,846 - 585,846 50% 0% g) 1,171,691 75,000 1,096,691 200,000 - 200,000 50% 0% 400,000 400,000 - 1,018,206 - 1,018,206 50% n/a 2,036,412 - 2,036,412 9,416,048 7,154,741 2,261,307 50% 38% 18,832,093 15,698,990 3,133,103 1,715,213 1,574,656 (140,557) - 2,863,995 2,863,995 a) Mineral lease payments discontinued under FY 2011 Continuing Resolution b) Annual payment-January 2011 c) Received in June 2010 d) Gas tax will increase by 25% ($.06/gal.) effective January 2011 (revised State estimate) e) Billed upon completion of work f) Payment to be received in June 2011 from Funds 326, 328, 329, & 340 g) $1,096,691 19th Street construction reserve ADULT PAROLE & PROBATION Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Revised 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 108,653 217,350 108,697 50% 100% a) 217,305 217,350 45 State Miscellaneous 2,151 - (2,151) 50% 0% b) 4,301 4,301 - Alternate Incarceration 15,459 30,918 15,459 50% 100% a) 30,918 30,918 - State Subsidy 6,500 6,653 153 50% 51% 13,000 13,000 - SB 1145 1,480,995 1,480,995 (0) 50% 50% c) 2,961,990 2,781,990 (180,000) Probation Work Crew Fees 19,000 11,375 (7,625) 50% 30% d) 38,000 20,613 (17,387) Miscellaneous 1,500 1,960 460 50% 65% 3,000 3,000 - Electronic Monitoring Fee 85,000 79,251 (5,749) 50% 47% 170,000 160,000 (10,000) Probation Superv. Fees 105,000 96,384 (8,616) 50% 46% 210,000 192,000 (18,000) Interest on Investments 4,500 4,984 484 50% 55% 9,000 9,000 - Interfund - Sheriff 25,000 25,000 - 50% 50% 50,000 50,000 - Crime Prevention Grant 25,000 12,500 (12,500) 50% 25% 50,000 50,000 - Total Revenues 1,878,758 1,967,370 88,612 50% 52% 3,757,514 3,532,172 (225,342) Transfers In-General Fund 57,515 57,515 - 50% 50% 115,029 115,029 - TOTAL RESOURCES 2,552,644 2,753,534 200,890 50% 61% 4,488,914 4,375,850 (113,064) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 1,586,629 1,483,290 103,339 50% 47% e) 3,173,257 2,966,580 206,677 447,137 381,475 65,662 50% 43% 894,274 894,274 - 50 - 50 50% 0% 100 - 100 210,642 - 210,642 50% n/a 421,283 - 421,283 2,244,458 1,864,765 379,693 50% 42% 4,488,914 3,860,854 628,060 308,186 888,769 580,583 - 514,996 514,996 a) Annual payment received in July b) Payment from Parole Board for hearings not yet received c) Anticipated funding cuts from Dept. of Corrections. Money above opt out d) Increase in fee waivers from court due to economic conditions e) Personnel expenditure projected to be less than budgeted due to unfilled positions COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Six Months Ended Dece mber 31, 2010 Year to Date evised C Year End Bud et Actual Variance FY % Coll. % E ud et Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 200,084 123,538 (76,546) 50% 31% 400,167 400,167 - Title IV - Family Sup/Pres 31,875 37,556 5,681 50% 59% 63,750 63,750 - HealthyStart Medicaid 47,500 26,212 (21,288) 50% 28% 95,000 95,000 - Level 7 Services 128,992 112,094 (16,898) 50% 43% 257,984 257,984 - State Prevention Funds 7,250 6,696 (554) 50% 46% a) 14,500 17,000 2,500 HealthyStart /R-S-G 154,462 134,805 (19,657) 50% 44% b) 308,924 263,596 (45,328) OCCF Grant 302,162 290,050 (12,112) 50% 48% b) 604,323 549,044 (55,279) Charges for Svcs-Misc 4,000 1,153 (2,847) 50% 14% 8,000 8,000 - Court Fines & Fees 37,500 39,941 2,441 50% 53% 75,000 78,000 3,000 Interest on Investments 10,000 2,954 (7,046) 50% 15% c) 20,000 8,000 (12,000) Grants-Private 2,500 - (2,500) 50% 0% d) 5,000 - (5,000) Donations - 157 157 50% n/a - 157 157 Miscellaneous 129,277 59,517 (69,760) 50% 23% e) 258,554 118,500 (140,054) Total Revenues 1,055,602 834,673 (220,929) 50% 40% 2,111,202 1,859,198 (252,004) Trans from General Fund 142,167 142,167 - 50% 50% 284,333 284,333 - Trans from GF-Other 12,500 12,500 - 50% 50% 25,000 25,000 - Total Transfers In 154,667 154,667 - 50% 50% 309,333 309,333 - TOTAL RESOURCES 1,773,031 1,624,680 (148,351) 50% 54% 2,983,297 2,803,871 (179,426) REQUIREMENTS: Exp. Expenditures Personal Services 299,780 255,782 43,998 50% 43% f) 599,559 525,226 74,333 Materials and Services 987,542 508,596 478,946 50% 26% b) 1,975,084 1,799,758 175,326 Capital Outlay 50 - 50 50% 0% 100 - 100 Contingency 204,277 - 204,277 50% n/a 408,554 - 408,554 TOTAL REQUIREMENTS 1,491,649 764,378 727,271 50% 26% 2,983,297 2,324,984 658,313 NET (Resources - Requirements) 281,382 860,302 578,920 - 478,887 478,887 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) Youth conference donations will not be received e) LAUNCH grant will be reported in Public Health (Fund 259) $100,000 - SPF grant will not be received f) Personnel costs will be less than budgeted due to open positions SOLID WASTE Statement of Financial Operating Data Six Months Ended December 31, 2010 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Sale of Carbon Credits Sale of Equip & Material Recyclables Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Contingency TOTAL REQUIREMENTS Year to Date Year End Bud et Actual Variance FY % Coll. % Budget Projection Variance $ 392,509 $ 318,001 $ (74,508) 100% 81% $ 392,509 $ 318,001 $ (74,508) 14,000 11,605 (2,395) 50% 41% 28,000 22,000 (6,000) 100,000 16,400 (83,600) 50% 8% a) 200,000 200,000 - 420,000 467,251 47,251 50% 56% 840,000 840,000 - 657,000 692,802 35,802 50% 53% 1,314,000 1,314,000 - 1,829,500 2,083,306 253,806 50% 57% 3,659,000 3,659,000 - 36,500 47,265 10,765 50% 65% b) 73,000 73,000 - 12,500 41,009 28,509 50% 164% c) 25,000 50,000 25,000 6,250 4,221 (2,029) 50% 34% 12,500 8,000 (4,500) - 1 1 50% n/a - 1 1 40,000 - (40,000) 50% 0% d) 80,000 - (80,000) - 100 100 50% n/a e) - 100 100 10,000 23,154 13,154 50% 116% f) 20,000 35,000 15,000 3,125,750 3,387,114 261,364 50% 54% 6,251,500 6,201,101 (50,399) 3,518,259 3,705,115 186,856 50% 56% 6,644,009 6,519,102 (124,907) Exp. 800,059 807,515 (7,456) 50% 50% 1,432,915 1,183,540 249,375 50% 41% g) 485,033 401,732 83,301 50% 41% 59,000 46,139 12,861 50% 39% h) 145,870 145,870 - 50% 50% 399,128 - 399,128 50% n/a 3,322,005 2,584,796 737,209 50% 39% NET (Resources - Requirements) 196,254 1,120,319 924,065 a) Franchise fees are received in April. Wilderness Garbage pays monthly b) Seasonal material - revenue will decrease in winter c) Bonneville Power did large clean-up of contaminated soil-unexpected revenue d) No market at this time. Not expected to market this fiscal year e) Minor revenue for sale of gate remotes f) Markets for recyclables varies throughout the year - usually declines in the winter g) Larger expenditures (i.e. grinding at $75,000) made in spring h) One item remaining-software being researched 1,600,118 1,600,118 - 2,865,829 2,865,829 - 970,066 970,066 - 118,000 118,000 - 291,740 291,740 - 798,256 - 798,256 6,644,009 5,845,753 798,256 673,349 673,349 RISK MANAGEMENT Statement of Financial Operating Data Six Months Ended December 31, 2010 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention 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 Professional Service Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT - Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Contingency TOTAL REQUIREMENTS NET Year to Date Year End Budget Actual Variance % of FY % Coll. Budget Pro ection Variance $2,500,000 $2,374,541 ($125,460) 100% 95% 167,916 167,916 0 50% 50% 147,009 147,009 0 50% 50% 91,355 91,355 - 50% 50% 453,181 450,254 (2,927) 50% 50% 85,219 85,016 (203) 50% 50% 15,000 - (15,000) 50% 0% 10,000 16,683 6,683 50% 83% 750 700 (50) 50% 47% 1,000 - (1,000) 50% 0% 11,000 10,780 (220) 50% 49% 15,000 9,110 (5,890) 50% 30% 997,429 978,823 (18,606) 50% 49% 3,497,429 3,353,364 (144,065) 50% 75% Exp. $2,500,000 $2,374,541 ($125,460) 335,833 335,833 - 294,019 294,019 - 182,710 182,710 - 906,361 906,361 - 170,437 170,437 - 30,000 30,000 - 20,000 20,000 - 1,500 1,500 - 2,000 2,000 - 22,000 22,000 - 30,000 30,000 - 1,994,860 1,994,860 - 4,494,860 4,369,401 (125,460) 46,633 2,037 5,000 133,418 366 250 200,000 187,704 12,296 50% 47% 400,000 377,000 23,000 153,414 10,921 150,000 164,335 (14,335) 50% 55% 1,739 390 10,373 21,540 60,000 34,041 25,959 50% 28% 311,654 5,000 62,158 19,315 10,726 325,000 408,852 (83,852) 80,000 98,778 (18,778) 815,000 893,710 (78,710) 144,727 142,621 2,106 114,417 82,909 31,508 50 - 50 259,194 225,530 33,663 1,173,237 - 1,173,237 2,247,430 1,119,240 1,128,190 1,249,999 2,234,124 984,125 300,000 270,000 30,000 120,000 100,000 20,000 50% 63% 650,000 750,000 (100,000) 50% 62% 160,000 320,000 (1601000) 50% 55% 1,630,000 1,817,000 (187,000) 50% 49% 289,453 289,453 - 50% 36% 228,834 228,834 - 50% 0% 100 - 100 50% 44% 518,387 518,287 100 50% n/a 2,346,473 - 2,346,473 50% 25% 4,494,860 2,335,287 2,159,573 - 2,034,114 2,034,114 DESC HUTES COUNTY 911 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance % of FY % Coll. Budget Projection Variance RESOURCES: Beg. Net Working Capital $5,861,335 $ 6,691,945 $ 830,610 Revenues Property Taxes - Current 3,178,811 5,522,152 2,343,341 Property Taxes - Prior 69,000 207,215 138,215 Federal Grants 237,000 - (237,000) State Reimbursement 5,000 8,921 3,921 Telephone User Tax 275,000 216,782 (58,218) Data Network Reimb. 6,000 1,528 (4,472) Jefferson County 15,500 29,471 13,971 User Fee 25,000 48,026 23,026 COPS Reimbursements 15,000 - (15,000) Contract Payments 35,000 252 (34,748) Miscellaneous 4,250 5,978 1,728 Interest 20,000 24,886 4,886 Interest on Unsegregated Tax 1,000 551 (449) Total Revenues 3,886,561 6,065,762 2,179,201 TOTALRESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 9,747,896 12,757,707 3,009,811 100% 114% $5,861,335 $6,691,945 $ 830,610 50% 87% 6,357,621 6,357,621 - 50% 150% 138,000 207,215 69,215 50% 0% a) 474,000 647,395 173,395 50% 89% 10,000 20,921 10,921 50% 39% b) 550,000 550,000 - 50% 13% c) 12,000 12,000 - 50% 95% 31,000 31,000 - 50% 96% d) 50,000 48,026 (1,974) 50% 0% e) 30,000 30,000 - 50% 0% e) 70,000 70,000 - 50% 70% 8,500 8,500 - 50% 62% 40,000 40,000 - 50% 28% 2,000 2,000 - 50% 78% 7,773,121 8,024,678 251,557 50% 94% 13,634,456 14,716,623 1,082,167 Exp. 2,004,399 1,832,318 172,081 50% 46% 4,008,798 3,878,798 130,000 762,072 649,903 112,169 50% 43% 1,524,144 1,524,144 - 281,500 79,163 202,337 50% 14% e) 563,000 1,763,000 (1,200,000) 507,031 754,061 (247,030) 50% 74% f) 1,014,061 1,014,061 - 3,262,227 - 3,262,227 50% n/a 6,524,453 - 6,524,453 6,817,229 3,315,445 3,501,784 50% 24% 13,634,456 8,180,003 5,454,453 2,930,667 9,442,262 6,511,595 - 6,536,620 6,536,620 a) Two grants 1) EOC - billed EOM $212,402 in December 2) CAD-to-CAD - billed EOM $79,163 in December b) Received quarterly (Nov, Feb, May and Aug) for fiscal year c) Yearly agency billings were mailed in December d) Crooked River Ranch paid annual fee e) $1.2 million will be expended in FY 2011 for the Records Management System. A transfer of appropriation is pending 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 Six Months Ended December 31, 2010 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I Prem Employee Prem Contribution COIC Retiree / COBRA Co-Pay Prescription Rebates Interest Total Revenues Year to Date Budget Actual Variance FY % Coll. % $ 16,400,000 $ 16,988,140 $ 588,140 ioo% 104% 5,623,000 5,716,663 93,663 50% 51% a) 25,000 21,582 (3,418) 50% 43% 250,000 243,395 (6,605) 50% 49% 487,500 712,714 225,214 50% 73% 225,000 372,975 147,975 50% 83% - 46,718 46,718 50% n/a 50,000 62,666 12,666 50% 63% 6,660,500 7,176,713 516,213 50% 54% Revised Year End Budget Projection Variance $16,400,000 $16,988,140 588,140 11,246,000 11,403,534 157,534 50,000 40,000 (10,000) 500,000 485,000 (15,000) 975,000 1,200,000 225,000 450,000 600,000 150,000 - 46,718 46,718 100,000 120,000 20,000 13,321,000 13,895,252 574,252 TOTAL RESOURCES 23,060,500 24,164,853 1,104,353 92% 81% 29,721,000 30,883,391 1,162,391 REQUIREMENTS Exp. Expenditures: Personal Services 64,640 61,349 3,291 50% 47% 129,280 129,280 - Materials & Services Claims Paid-Medical/Rx 6,225,097 6,208,509.59 16,587 50% 50% b) 12,450,194 11,957,130 493,064 Claims Paid-Dental/Vision 935,689 859,820.66 75,868 50% 46% b) 1,871,377 1,655,951 215,426 Refunds - (44,757) 44,757 50% n/a - (44,757) 44,757 Insurance Expense 165,000 168,376 (3,376) 50% 51% 330,000 330,000 - State Assessments 37,500 62,429 (24,929) 50% 83% 75,000 75,000 - Administration Fee 150,000 148,817 1,183 50% 50% 300,000 300,000 - PPO Fee 20,000 19,917 83 50% 50% 40,000 40,000 - Health Impact 25,500 25,458 43 50% 50% 51,000 51,000 - Deschutes Onsite Clinic: Healthstat 114,760 31,490 83,270 50% n/a 229,520 229,520 - Equipment 7,250 - 7,250 5o% n/a 14,500 14,500 - Remodel 56,750 25,088 31,662 50% n/a 113,500 113,500 - Miscellaneous 30,950 427 30,523 50% n/a 61,900 61,900 - Other 75,571 20,699 54,871 50% 14% 151,141 151,141 - Total Materials & Services 7,844,066 7,526,274 317,792 50% 48% 15,688,132 14,934,885 753,247 Capital Outlay 100 - 100 50% 0% 100 - 100 Contingency 6,951,744 - 6,951,744 5o% 0% 13,903,488 - 13,903,488 TOTAL REQUIREMENTS 14,860,550 7,587,623 7,272,927 50% 26% 29,721,000 15,064,165 14,656,835 NET (Resources - Requirements) 8,199,950 16,577,230 8,377,280 - 15,819,227 15,819,227 a) Year End Projection is amount appropriated in operating departments' budgets. b) Projection based on annualizing 27 weeks of claims paid. YTD actual is an average of $260,132 per week. Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Six Months Ended December 31, 2010 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 Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Reserve Fund (617) Total Transfers In Year to Date Year End Bud et Actual Variance FY % Coll. % Bud et Pr0.ection Variance $ 2,809 $ 6,590 $ 3,781 100% 235% $ 2,809 $ 6,590 $ 3,781 338,871 366,087 27,216 50% 54% a) 677,742 682,087 4,345 1,000 578 (422) 50% 29% 2,000 1,578 (422) 25,500 13,901 (11,600) 50% 27% b) 51,000 30,901 (20,099) 4,500 440 (4,060) 50% 5% 9,000 9,440 440 21,000 255 (20,745) 50% 1% 42,000 38,255 (3,745) 105,500 102,683 (2,817) 50% 49% a) 211,000 187,683 (23,317) 46,500 14,000 (32,500) 50% 15% 93,000 94,000 1,000 22,500 - (22,500) 50% 0% c) 45,000 45,000 - 2,207 12,689 10,482 50% n/a 4,414 15,627 11,213 _ 567,578 510,633 (56,945) 50% 45% 1,135,156 1,104,571 (30,585) 98,960 98,960 - 50% 50% 197,919 197,919.00 - 12,437 12,437 - 50% 50% 24,873 24,873.00 - 40,000 40,000 - 50% 50% 80,000 80,000 - 115,616 100,000 (15,616) 50% 43% d) 231,232 166,000 (65,232) 50 - (50) 50% 0% 100 100 - 267,062 251,396 (15,666) 534,124 468,892 (65,232) TOTAL RESOURCES 837,449 768,620 (68,829) 50% 46% 1,672,089 1,580,053 (92,036) REQUIREMENTS: Exp. Expenditures: Personal Services 465,947 441,193 24,754 50% 47% 931,893 907,140 24,753 Materials and Services 238,343 273,311 (34,968) 50% 57% e) 476,685 525,653 (48,968) Debt Service 57,782 72,061 (14,279) 50% 62% 115,563 115,563 - Capital Outlay _ 50 - 50 50% 0% 100 - 100 Total Expenditures 762,121 786,564 (24,443) 1,524,241 1,548,355 (24,115) Transfers Out - Reserve Fund 5,000 10,000 (5,000) 50% 100% 10,000 10,000 - Contingency 68,924 - 68,924 50% n/a 137,848 - 137,848 TOTAL REQUIREMENTS 836,045 796,564 39,481 50% 48% 1,672,089 1,558,355 113,733 NET (Resources - Requirements) 1,405 (27,944) (29,349) - 21,698 21,698 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 w ti 0 x a a H a U CrS a.~ a~ H a ~ O O~ v~ a~ N N I~ O 1~ 0 N r i3 I N 0 0 O CD O 0 0 0 N O V 00 M N M fl- M O M O co CD CD O O O O V O C 0 It O CM ' M N O ' 00 It O M CD O O O CD r (0 N r~: O O 00 v 1-7 - ClO V' C \f 00 0 N O r v O t` O O O O CA v 1, C14 O N N Q O M CD CO CM O CM N (D O r O I` N O M O O CM 00 O It Cc r CO O CM O V' M O O M O 00 CD M N O O N O O ~p CM O V N V• CM O CM N O O 00 V• r co c) fl- O O M M r 0 14, 1-- N V V'0000 O~00Il1r- 00 O N V' N O N ~ LO C-4 M ~ O r M 0 r 0 N 0 0 LO V' N O N O O V' O tD O O O co CD O V• O O O co N N O U+~ OO O MO Oti OO 0 CO M M O a) p~ O O O O V ' O O ' O O ' ' ' N CO M ' ' M O ' p p O O O Cfl V• O LO O CY) O O O d 3 N IV M 00 O r Cl) O 00 O O 0 m _ CD Il- ti M O co O O (D cc O a c 7 a0 U O N M O a a) U CU CD U a) CC, p O o t p O O U) c O CT m 0 I- O M CD O O N O N co M r O ti N 0 M co V r CO (D CD M O V M O O M O co O m N N Q) 0 O IV N O M~ M N O 00 V: r co CD P. N V 1~ N V 0 (D O CD O O 00 r. 1~ O O p O N co COQ M 0 r O N N N r M O r 00 O O (D 1101 1 1 Ni IV' 0 N (o E E E U O L C-) a 06 c .a co (D T a rn V v ~ ti N O N co N r M Lo cl w U O CO) w w co I w N Cn O 0 CD U c (a 7 N 0 CD c CA N CD V N 0 0 rn d v, ~ a m ~ o o m ~ F- 1 1 1 1 1 1 1 1 1 1 i i O M O N CD O CM N 0 N CD M r O I,- N 0 07 CD w m LO "t m O O M O w (D 0 CD NO(3V'MNOrt>D V r000 c V• 0 CD O CD O O ~ M I~ r I- 0 (D M rn LO 01) O r co V• V' tn C O to CO co M (6 N cs N N co co M O M 0 O N V• M O V I OI r N N d a) U 4 w co z (D (1) f~ c (~Ct c p ~ w - ~ a) > rn c E ~ aa)i m 0) ots~ ~Co ~v o >O Lu p U tti . n. LL 0 a 0 M tm J-- p~ cw U Ern U,U_M co °_EQ' Haw'c(n (D L C w U .2 Z, a) a _ Cd 0 Cr) .c c a m 0 c o a) a) V -Co a) i W s N~ 't vi a) O N 0 CU 3 N c 0 X mQ`wHCL ~LL<a`m~0~ oz0=U~ w 0 7 a c a~ CL X w w 0 H m Z LO LO M Cl) CO CO N N Co co r- r- O O f~ C(') Cl) It O It LO N O N N~ CC) N N O Cl) N O LO Il- CO O qT qT N 00 CO 00 N qt O 00 V N O M O m c) co d c,) Lo O O V t` O - O ti N O 00 O M M V (M I~ M N h (0 - M W- N W N W W M M A N (M N- V qT M q• O Wt`MMMr-- MLO V MLO O V O V r- et CO CD UAI-a0It I,- LO CD ti(oCflqt NtiO(OON - N NN V d -O~(6 .-ti6 C6 (oMN0000NMM06L6V I-: C6rl: NN(6 Omvi I1CT V r- N CV Co N N (M CO - N N N 00 LO I- C) O ~t O d Cn 0 04 0p co a) O O CO LO . O ~ (CD O _ co N C Z M M V N CO Cl) :3 06 LO 0~ ~i LL M In ~ ~O O M -SOj M f~ N Ci (0 04 04 r O N - a) Lci c) 6-k 00 0 41) CD N O co CO p N > CA EA ~ .r CA ~ C6 0 O r- ° d (O N, O \ M O O r O O CO 64 •r O ~ o Co (o I~ - U M CYfl o N N 1 4) y 0 w o O o C) I- CD C~l V 475 o " 6- 'Q Z a) _ O O ti O C) E,9 C) - Co ` 0) \ O ~ I- CO ~ O CO 0 w - V) ~ ~ Cn 00 O CO 00 W CO 649, C C [o a O C) CO \ 0 0 r m 0 O mQ E ~ o 00"-~ O m(D co a (0 CO 00 0 ~Vl~ ON O T U(n 0 ~ Off; ~ a) ~ N(„~~ OCD UU N ~ y~ EO E;N•~ .-•~CO~O N~o ~ CD LU VU0 m ~CO~ m'~ 0w O~f~EASo ~w C Oc CA~ 0 0 O m N° U~O Co ce) C) O Z 0 C CD C) CD 5 CD E J CT to o CV) m O C m C N (o O c O U o O co O C co U Co M a a Q o co w (D o m~ O E M Q as o C. c o c (v E~ W Q (f3 O n c C U) OO o N O U (U U m 0 CD =3 cr rn L ( 0 D 7 rn m O m Y y O N (O O m CA O > - y a) a) U O a m C m V U m w C m_ O T Co r (n C co Oo 0 U C C O' U:k C c N CD Co C) O N 7(D( M 0 r- 0) a p U O O 0) C« N N 0 c co o o Co 0 0 m c Q. 5 co a m m s c m m uroi o CO o) c a) a) 0 :3 rn Z j U N N~ U) 0 U .C p) C N C N p) U N Q U) o m= w L `O N a m 0 N W U O CL) N M c ca re, -O 4) -0 ~ Co C a CU - a (a c"° 3 0 a a U C 'C CD V 0 CL E0)0) O O m vi a~ (m a o + m m c T m m v o o a) co L) Erna, COQ ems O~ 0'~ c m 4) s CO >a ~i E E E m C x~ o c rn c a m a) a) U m c g Y ~ V m U 'c ° m 3 - N o'3 .0 rn 3 m e U O c i w c c E U Y- a ci o a U .C U 0° i m E U a U U Q U Q (i L rn v a=° c= o LI) m u) 0 y o N a .N .N o a~ o (`o .N p x •N m U V 0 U U Uw m a)} O2I.~.-~a2 L) Lu wO=2MQW~O2 N C _QQeQ~==LL =OrN_M___~I~000_ -Cl7ti0C)Oe-N('~~t00000~ V Loot- CD +m+ C 00 E c E E CA O U U C O oa U co U) a) :3 V 7 (n C a ca N m c a~ E a C U W N W 76 C p) m 0 W O H cD O c m O O N C 3 L O •C r Q N c O 03 a M U (6 .n (D m N t N 0 a p m m o a) . U N O tl :6 .Q m U a) ~ N (D N M O (0 1z O N ' M N M I,- ~ w N N 'V O O co O MOOtoO (D O O M 0) M vi M N M to O M I- (D N (D ~ M M N tD O N O O N O(OOO w O N O O N O N M to O tO h M (D N N M 11 w M N (O ' r O (D r M O tO M co (O O M tD M 00 M N n tO M M t- O N M ~ O M N tD I . . I I N O 00 O t(~ (O N N to aO M O N O) M M r M M M ~ O M M M tt r O N M r to to V O Vs (D 00 d V M r- 0 r N N' ' ' ' U.) (DD M O O N 14, CV I- d' L r N O tO r CM M ti v v r` v ~ to cq w 04 N O M O N O N W tO 00 r Ih M to t() O O CD "t CD r tO M r (D M W (D M t r O h t- O O O (D M O 00 lf7 O~ O CO CD M tO ~ w n M w O M ' ' O O to O CD O CD M O N E Ni to r ~ N O to •--7 00 M (O ~ 00 N O N ti M r M t-- r- O M N N r to r r M tO t- 00 O r N r et L O00 O~ OO OOO tO tl- OOO ~ N OO OOo OO 000 00 r` OOO r- tD O~ ' Or 100 ' ' 000 (0 to I 1000 to N ' rr NO Or Or O N v tnr~ r O Nto N M to O ( MM N (D t ) t i U ( D ~ (M to tD N M CO O N CO N 00 tO 00 r r- O (D (O t- to (D M 00 ~t to M r (D O 00 O 00 'ct r a) M (O N (O Iq 00 tC) 0) ~ 0) (D (D 00 (o q 00 t` M O r M ' ' 00 O N M N (6ODV NNE vtn 6 o O d'm O W N N M N r V) M ~ v LO I O N r V W I . . I . I I I I . . 1 et r 0 0 r N O W O N M N W tO 00 r r- O (D M tt O to M -t tO M r CO M M (O M~ r M V, M O(OOMO toO~O)OOOpto V*Mtl-MOr M Oo M N ti O 0o Nr O N t- tO e O tO to M M~ O 0o N m N tO O N M V' O N r to r M N Iw co r co r 00 r 00 r r r r O ' ' t" tO O tD N r N t() O M O) O 00 O tO tD m O m Cp (C O O r N `7 (o CD M ~ M ~ t0 N rI1I tO 0 o U w N a) O r 3 N d m ~ a) U N ll t) C 3 N p v) O ~ a) w 0f a) a) I- U z E a) - N to C m ~ 'U a) w c N (~6 0 3 N O N V cn U) ~ 0~ 3 a) N N O E 3 3 Q 0 d vi r c m E rn o _ w U m rn -M c 0 F- a2S + c m t_ (n U -o a) •c ea c m m rn (D c w Q 06 E a~ a) M (a O V C 0 O O t m 0` u a) m 0) c c o c a 0) 0 c° O O o 0 3 3 0 0) ~~o ~ 0 as ma 0 ) a~ aw~ ~~m a i = -0-E C Q m 202 0C ZZ) ~ 0 aoiFO- m w cca o o X mQ wH It_ aw m 0 LL ° m LL F- Lu U F - d z "t N r- ; R M ac) ui (O N N to 00 O) M O N N M N M O M O It m M m 1- m w m w Itt O O w - - N M (O N M N to to O v (O 00 d qT w m (O O N' ' N T- co CO N v- O N q N r- d tf) CO I- to to 00 tD - v v v 00 r- 00 N N O 00 ~ 'T O ti r N O 00 O N O N 00 O 00 O I` V to to 0) N M O M ~ ~ to M (0 O 00 (O 00 qT 00 O r- (O CO C) M CO O M 0) U') 0) 't O O w 00 LO d' w m M ~ M' ' M r co M to rl tp CO a0 d' O N PI q t(> (O O O O t» CD LO C~ O ~ 00 N CA 1,- _ _ N N ~ t` r tN M M N N M O N O N O co O 1- O O O LO ti r- N O co O w O O O co O O O 00 r- r- w O C l! N O ' O ' 0 C ' O (O to ' tO N ' O N U') t~ N O O N N• It r- LO I- O N N L() O 0) Go CO m co L A LO M co C -f M M O O (0 O ~ N C LL M O a) U v ~ ED a) E L CL N N 0 Q Q (o U o r L r ~ CA V I- N N m w O NCO N W U) W O) I- Itt LO tt) m m M d' M q' t(7 M - O O 00 (0 M qqr 00 M ti CO (0 Cl) t- (O O M to t() M o m CO CO O O~ w m M I- M M V M 00 rl to (O C I~i O N t-V Cn (O O O 0 0> O LO V) 0 to 00 N O _ N co w N NT I,- 1~ T- d' M t'> N N M 00 r 00 r ao r 00 r ,t I- N N m 00 O N O N 00 to 00 O ti v M O N O M tT M V- Vf LO CO c O CA 00 (O 00 V 00 O ti LO r O N CO (fl M to tf> rn v rn (O (O 00 LO V 00 M M ti too (O M N M06 ti o> (OOOct ONI-V7 L6 rn - O O CD Cl) O (0 00 N O 1q, r- O P. N ( 0 N 'IT O CO O M Mi O N M CO N N to O U 4) U fA y U Z U m a) CO) m O C R) (n t~ m= OZS > C w C 'v) CA 'V to (1)) O oI 06 M C: R c E 0 O N d W _ N m to O- - I LL L a) (D U > m " CL Z. 'a W (D m U E L) s ~ Z5 N c- c o CD U) m O m c' E e i 0 K = a. o ca w • r_ c m e a O a) c U a) o .N c w O y v a) a 2 a E t c a) m 4: to v 'L C L H 3 N = a) c~ H is c~ Q w wH~ C LLQaD 20 Uz~O 0 4.1 M w ~ H Z w cD F- O C N O M Z OQE D- Cn U m ~Z~ U Q rnD U Z w c a) ~ CO 3 Op ao m O m co M N CD C M 0 O LQ cq 3 N N Q C O to o C-- COOS O f- cD CD O N O 000 O NO CDC 0CD C.- 0 F-M V 000OCO COM CO N N N O M COM MO O CO O I- r- N O (M w N m 0) lqr 70 f~lDNI- NN MOAN CO Lo c) h (A E C O Cl MM't toOC Vt a00-N OMgq It ~M'dO ~NN N-1OONOO CO t0 t0 3 O r N CO 06 co O O It r.- CD O N O n N OD M I~ M O to N CO M n l0 (D n M CO O N E E U') O CM 7 0 CO N N N t- ~ 00 E to to rn U Q N N N 01 M M N N ~j t0 M 0 4 O U) 0 O N Cl 69 06 w o M N N w aO O 17 COOc 00 CV O LO .R Clot V9. Oy) M N co a) p o O O On M O 0) CAN NCA ° r O V O fAO~ U 0 O~ ~ 0 U)CT 06 691 16 00- O N ~ o a) tO ~ 0 0 O O o M y o C O 2 c O rn~ O O v N 04 o - o U 00 N "N' d o c C U o 0I y o 0 0) CO o 0 ai M v ° Ix! ~_M'O„c E..a ° O 0` v pO00° u) p o E pc°° pN c E 0 o o E c ctOi mY__ me v° 0 CO a) CU r O o 69? a) 0 O 3 U U CL O t O .3 O O CO O N N .M.. E 2 0) O o O N C v w M f0 0~ N~ N U y CO 0 0 N E 7 C C C 0 0 E 3 r- 0(D 0 - o MZ.U~ood c Lnc'~°~~`=c t~o• pp8 mm~=~o$ t°6~v E2 O vo U o QM w o o ~ Q~ c v v ca cn EotS rnU c 0) m 3UO(m) pwch czrcLca mCEMM L) y- map Ca) cp~~.f00 U O t9 cLpo a) w t ce) p ~O L 7 N 7 U `m m m 'O Q C C 'U E '0 3 C C f~0 X LL C D or 'O p a) j a) CO l77 E N a) ~S in U a 3 v a a? ; m or O1 o-° d N U c m ~,Y E Z' U E m dC E E M U U 6 p f>~ o U v U Q o 3r'2 U tco 0 V p N' U U Y O y y 'O E !n O •O v y Mn 'a y V y y CO N 0 y O X w U `O OOM 0=O-NMtoCO 000-NM V U') C.0 Dt-- NM7t3t*k a#~k ~k 0 a) co r- c E E O cli U U C 7 ca N U N a) O U 3 C U_ ~ N d a) _N (n N E N 3 C c F w ca a) C C W B N cm 76 0 a *6 2 w 'qk ~Y a O ~ O ~ r c O N ~LL Y v ~ c M U CL .0 N o E a a) U ; L a) ca O LL 3 0 a) ~ Z 0 CO) W V O CO) W w 00 co T.- CL O W) 000000 O O - O O O O M O O co Cf) C) V) v' N co N N O O O O O ' O M O M IT N to N N O co 00 C) T- O ' O O M O co v v N C I O O co o - T- O ' O O M O co M M IT It N IN O O ti a c 7 LL U) r +N+ V O L O _ d N N a) c ~ L <0 N 4' O H LL E F X00 r- N 00 O ti ~ 0 ~ r 0 O I~ llt N r- M LM (D O O O O O O O O O O O O CD I- r LC) CD I~ (D M M O CN LU)(D i i O O O O O O O O O O LA M M N M O O O O CO i CN C14 L I~ (0 c M O C~ C14 ~ O Co N 2 L 7 M ~ X V c o~ D N fn a) off C N (a c, cn Q Ui 'a W ~ a N CC) m V 2 tt) c PQ6 cc t: 2 o R O z 7@ c `O Q a. -Q) Co 0 W oU O O O O O O O LA M N Cl) r- ac i M N 00 N• M m L 7 Y .C L 7 LL a) U_ od c C7 a E-N w O U X~ 00 LL U W od L a)EU~ 3CLN . Y S tz E .E a U) = ~WOLL LL rn 0 O co o IT i LO i LO O P- O O ~ N C) ~ r r 000000 O 00 O O CO O O O C0 r~ 0 0 0 0 0 0 0 1 N O 00 co O O O ti 1- CD O r- 00 M N 0 tD N 0 0 0 0 0 0 co O 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 O ' O0OO000OCM M d 1- CD m M N 0 to N O 0 r co CD 00 1* ti IIT O I i O0 N 1t m CD CD to N ~ f~ M O 0 co co r*- III LOA 00 N 0 (0 O w r N to ti to r- N w t. LO N 0 >w E W R O N 7 CL E N O a) E (n C -a) O c y U) U) O CTS .N V O c o c Q y c 0)'0 O 7 L U rC, cu ca = (5 o co a- of 6- ul F- N L C d CL K W r~+ O H N Z N C m U m O U O m O N (D U m .Q mp E _T L \ m ~ = p m C L p LL C O` N L E F- N H N U m i/i W U O U) W w (p M 00 L0 ; ;zl a0 0 & - C0 M A N to a) c- 0 - O CO M M M 00 O co O a) ' ~0 (o MM01- ' M O N - CO O LO00 00 LO O cc N r OD LO C L6 NN_voo NaM C6 O MM N4 C OM 000')m ~a00M MN~-MCDNI,-M0 0) a) w O cM O M It N eM O O ~ to O O. O M - M LO co (0 r N 00-0rM Cr CDOI`MO-OONaDN V' (0 co ' N LO O N LO M O . CO aO to (M LO (M N 00 to CO LO N to N Cl) N Cl) E O f C' f-- O r - M CO co m ~ ~ N r r r 000 00 000 M e- O O CD O 00 00 000 00 000 (000 O mto U) LO 00 000 OO 000 ' Cl) NO ' 0 ' h NN OO ' cM O N O to r- (3N LO O CO N - O O M to t tA0- ~M V) 000 0 CAM c l; N N f0 ~ OMco tom to aOOONNmmNNr- mN mCn CO M O M 'I N M - 0 - (O CD V- - M M - M CO (O O tp OD OO -O-Irf O aOC 1~M0000 NaON0 (Ow ' ti tp LO O N LO - C7 LO CO 0 LO M aM CO (D ' Ili O N NON -to co CV) co too((00 at - N r 04 N r- LO LO N N i i~ . . i . i i i O 0 m 0) CD C) M M M Cl) Ln N N ti r~ ' to L to t0 (D ~tOMOtoC> Mco LO ONNMCA NN~CAO IT v tD MO(MI-T N M M - rl- --(0C»-MM-MM r- ti to O OO -OEM a000NI-M(OOO-,NOc N- NN ' * Co LOON LO ~M CAr MOO toe-MM.-aO~ a0 IlI: tc 1. N to N O I- M r Cl Lo co co et O N LO LO (0 N r N r y U U a E n N (D C N uyi E m m Z CL tr N ev O L C p U O O pjf a H to CD N (n c m y C M C 0) O H U N m °a 7 - ea O LL_ am. Lu IL a c m a me L E 0.a) a CL m W>> c m U rn tv t9 . ea Z c cmicc~n W Fcat;a)E rnaa 0 ~~C) ~mm o M cW m G_ m m o c c v' U O 2 x (D (D .2 - It - 75 ii 3 n a W e CM > cm a~i ayi c>- C m 0 c 0 y azi LL CL 0 o m m O«. O X asQW W-i a._LLCL<:D mV J U I~ FO 6) F- in S F- Lu - Z Lo Cl? 00 N 17. O LO U Ef} N O O Cl U U 12 C N 3 ~ to f0 •N > aM C y N p LO m rn m ti O M d CO d' N y ~ a -o c c O ~ L LL C - O y C U 7 U 0 tA H a ~ O Z, O C O O C7 O N U M El? ~ M C > O 2 a O m V C 7 W > N M to a O m 0 U 0 C U Co O 3 M M NMI. r M O N cn - 04 O - N U N t m C Z .O I~ O y 0 N to 0 m N a Q 0 U O 0Qo n O CO C m N m:3~ N L C) ' C) 04 LO 0) (D ' m 0) a) N U) M O I~ M r- t() 00 M r M N O r- L d' CO O LO c LL L c a) U w O O N C) r W O M cn C-) a) 0 -0 7 Z V Q a) coU m W Z 7 O M m L LL M c = (D0 w E m a) N a) U a) U) U') O ' LO O co to CO co U ) (0 to O ~ M M It (0 Cf) ~ C14 M LO CN to t,: cl~ N M L r M N LO t CD 00 O OOOLO OOo M(OMOMtiNN-0M 'T O 00 O LO CD CDm Oil- mmco vOco to varnco I- O O O M to (::M to O) d• to (O (A Oct 00 (C) O O 00 O L M O I-- r- Cl) to CO d' Il- IT N It O CO qt ~ M'-T r- M O CO r l- ti N N CD N N N N N O M Cl) LO I` (D a) C) x a) O 0 rn a) to c a) CL x a) a) (a .0 E w a) L L 7 7 a) a¢ (D a) 75 75 N (a c c c c as N U c ~ O U) aO) a) CD (a. c T fl c U V to c to Co ~ C O U w J U Q CL 7 O O O 3 0 c U U N V QQ~(n a) a) c c z U 0 tO cu w N c c N O aa0Q a) rn cu 0) Y N •O iac a ~rn~ a) C 0 7 0 U .L m (a 0 a V a a) V a) C `p)= Y U c N N N L w L N .0 -O > 0-0 a) - am " U'c j y ~0 N = m> 0 O co (1) O. c :3 U Z L O Q L O 0 O N C:F 0 ~ O to v a) N _ fa U ~ (wa to :3 00 m C co cc c (0i CD L L - -a (a L o r~ noa L -_c.(a~co r-a c ) E (a V -0 O • m :D 0 N (La c T co U E 0 a) m a) 0 c c t~ :L- C-) Z . N Q D E N U O (a (a cc ULL D v1-ao~cn(ncn LO CO ti 00 G) O e- r N CO TO # *k *k *k *k *k *k *k *k a) L L L L L L L L L L L L N 'O a 'a ~ 'a a 'O 'ts ~ 'O "0 '0 M7 L L L L L L L L L L L L L M X00 0000000000 a)a) a)a)a)a)a)a)ma)a)m~ m OI m _ N (a N (a N (a M N N (a N N = L L L t= L L L L ca w o o 0000000000-6 Deschutes County Bethlehem Inn (Fund 128) Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ (2,725,000) $ (2,722,510) $ 2,490 100% 100% $ (2,725,000) $ (2,722,510) $ 2,490 Revenues Grants - Private 1,430,500 - (1,430,500) 50% 0% 2,861,000 - (2,861,000) Total Revenues 1,430,500 - (1,430,500) 50% 0% 2,861,000 - (2,861,000) TOTAL RESOURCES (1,294,500) (2,722,510) (1,428,010) 50% -2002% 136,000 (2,722,510) (2,858,510) REQUIREMENTS: Exp. Expenditures Debt Service: Interest Expense 18,000 10,465 7,535 50% 29% a) 36,000 22,000 14,000 Interest Payment 50,000 - 50,000 50% 0% 100,000 - 100,000 TOTAL REQUIREMENTS 68,000 10,465 57,535 50% 8% 136,000 - 100,000 NET (Resources - Requirements) (1,362,500) (2,732,975) (1,370,475) a) Interest on December 2010 negative cash balance ( $2,731,574.92) = $1,399.91. b) Recap of expenditures - inception through December, 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 215,062 Total expended $ 2,732,975 b) - (2,722,510) (2,758,510) Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of December 31, 2010 Engineering Contract G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Change Order #2 Change Order #3 Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through December 31, 2010 Balance Due 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 Change Order #14 Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through December 31, 2010 Balance Due DEQ requirement for gas detection LFG well field management SOPs Storm sewer realignment, drainage, Area A thickness Meet CEC requirements, increase to electrical panel, Storm sewer realignment due to refuse encountered Revise valve vaults for improved efficiencies Add1 cover material from what will be Cell 6 Environmental controls building, pump station bulkheads Adjustment to pipe alignment to increase slope Additional rock to be set aside for future needs Manhole covers below grade to meet Road Dept requirements Modular Block Wall instead of MSE Wall Upgrade of cables (pump and leachate) Leachate Line connection from Cell 5 to Cells 3 & 4 Additional cover material due to settling Well modification, flow meter less LFG vaults Total of Engineering and Construction Contracts: Original Contracts Change Orders Total Contract Amount Paid Through June 30, 2010 July 1, 2010 through December 31, 2010 Balance Due "Area A" "Cell 5" an i Capital Closure Fund Projects Fund 611 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 19,656.00 21,500.00 21,500.00 34,316.00 33,431.00 67,747.00 317,341.00 215,947.00 533,288.00 254,413.44 153,904.42 408,317.86 62,927.56 62,042.58 124,970.14 2,097,140.50 3,290,779.98 5,387,920.48 - 45,095.00 14,302.54 - 24,885.69 - 152, 500.00 152, 500.00 - 148,958.89 1,332.00 - - 225,000.00 2,486.98 - - 5,167.76 - 3,200.00 6,354.75 26,000.00 - 5,350.00 2,323,997.71 3,877,056.38 1,707,132.00 2,054,537.51 373,720.63 1,534,748.19 243,145.08 287,770.68 45,095.00 14, 302.54 24,885.69 305,000.00 148,958.89 1,332.00 225,000.00 2,486.98 5,167.76 3,200.00 6,354.75 26,000.00 5,350.00 6,201,054.09 3,761,669.51 1,908,468.82 530,915.76 2,339,009.50 3,473,295.98 5,812,305.48 302,329.21 619,707.40 922,036.61 2,641,338.71 4,093,003.38 6,734,342.09 1,961,545.44 2,208,441.93 4,169,987.37 436,648.19 1,50&,79,0J7 243,145.08 287,77G.68 w G Deschutes County Summary - Expenditures Compared to FY 2011 Budget FY 2011 Appropriations - M&S and Capital Outlay Expended to date in FY 2011 Remaining Appropriation Balance Due on Contracts Remaining Appropriation after contracts paid in full FY 2011 Expenditures for other activities Remaining Appropriation after Contracts/Other Additional Appropriation in Contingency and Reserve for Future Expenditures "Area A" "Cell 5" Landfill SW Capital Closure Projects Fund Fund 611 613 Total f00,uuu L,0Jt5,wtf J,;J23,b3d 436,648 1,596,791 348,352 941,847 1,290,199 243,145 2871M 105,207 654,077 759,283 32,210 299,387 331,597 72,997 354,690 427,686 306,221 551,196 857,417 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2011 BOCC Conference & Travel Jul Aug Sep Oct Nov Dec YTD Total Tammy Baney Conf/Sem & Educ/Training - - - 305 45 75 425 Travel Meals - 20 - - - 150 170 Accommodations - 77 - 429 - 127 633 Mileage reimbursement - 240 - 255 - 306 801 Ground Transport/Parking - - - - - 27 27 Total Baney - 337 - 989 45 685 2,056 Dennis Luke Conf/Sem & Educ/Training - - - 305 - - 305 Travel Meals - 56 37 25 74 32 225 Accommodations - 77 76 506 85 (214) 529 Mileage reimbursement - 282 178 190 211 148 1,008 Ground Transport/Parking - 17 - - - - 17 Total Luke - 432 292 1,025 370 (34) 2,085 Alan Unger Conf/Sem & Educ/Training - - - 305 45 - 350 Travel Meals - - - 198 - - 198 Accommodations - - - 1,414 - - 1,414 Airfare 1,133 - - - - 1,133 Mileage reimbursement - - - 372 - - 372 Ground Transport/Parking - - - 29 - - 29 Total Unger 1,133 - - 2,317 45 - 3,495 Tony DeBone Conf/Sem & Educ/Training - - - - 350 - 350 Accommodations - - - 536 - (107) 429 Mileage reimbursement - - - - - 122 122 Total Other - - - 536 350 14 900 Total - BOCC Department Conf/Sem & Educ/Training - - - 610 395 75 1,430 Travel Meals - 76 37 25 74 182 593 Accommodations - 154 76 1,470 85 (195) 3,005 Airfare - - - - - - 1,133 Mileage Reimbursement 522 178 445 211 454 2,302 Ground Transport - 17 - - - 27 73 Total - BOCC Department - 769 292 2,550 765 544 8,536 FY 2011 Budget 19,600 Percent of FY 2011 Budget Expended 43.6% BOCC County College Public Information - - 1,874 - - - 1,874 Office/Copier Supplies - - 33 65 52 - 150 Meeting Supplies - - 295 930 828 - 2,053 I - - 2,202 995 880 - 4,077 12/22/2010 Building Services - 620 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 310,000 $ 371,047 $ 61,047 Revenues Cleaning/Maintenance 45,006 39,383 (5,623) Utility Reimbursement 4,150 1,619 (2,531) Facilities Charge to State 88,998 72,925 (16,073) Miscellaneous - 3,827 3,827 Interest on Investments 3,500 1,704 (1,796) Grants - 5,800 5,800 Building Svcs Indirect Chgs 995,618 995,615 - Total Revenues 1,137,272 1,120,872 (16,397) Transfers In 38,963 38,963 (1) TOTAL RESOURCES 1,486,235 1,530,882 44,650 100% n/a; $ 310,000 $ 371,047 $ 61,047 50% 44%, 90,012 90,012 - 50% 20% 8,300 8,300 - 50% 41% 177,996 177,996 - 50% n/a - 3,827 3,827 50% 24% 7,000 3,300 (3,700) 50% n/a; - 5,800 5,800 50% 50% 1,991,229 1,991,229 - 50% 49% 2,274,537 2,280,463 5,926 50% 50% 77,925 77,925 - 50% 57% 2,662,462 2,729,435 66,973 REQUIREMENTS: Expenditures Personal Services 830,101 818,660 11,441 Materials and Services 393,289 330,263 63,026 Capital Outlay 3,000 - 3,000 Contingency 104,842 - 104,842 Exp. 49% 1,660,202 1,660,202 - 42% 786,577 786,577 - 0%> 6,000 6,000 - 0% 209,683 - 209,683 50% 50% 50% 50% TOTAL REQUIREMENTS 1,331,231 1,148,922 182,309 50% NET (Resources - Requirements) 155,004 381,959 226,959 43% 2,662,462 2,452,779 209,683 276,656 276,656 Admin Services - 625 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance FY % C011. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 120,000 $ 70,480 $ (49,520) 100% Revenues Miscellaneous - 20 20 50% Interest on Investments 385 430 45 50% Admin Dept Indirect Chgs 440,869 441,050 181 50% Total Revenues 441,254 441,500 246 50% Transfers In-General Fund 20,000 20,000 - 50% TOTAL RESOURCES 581,254 531,980 (49,274) 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 422,894 412,710 10,183 50% 57,997 28,663 29,333 50% 50 - 50 50% 40,314 - 40,314 50% 521,254 441,373 79,881 50% NET (Resources - Requirements) 60,000 90,606 30,606 n/a $ 120,000 $ 70,480 $ (49,520) n/a - 20 20 56% 770 770 - 50% 881,738 881,738 - 50% 882,508 882,528 20 50% 40,000 40,000 - 51% 1,042,508 993,008 (49,500) Exp. 49% 845,787 845,787 - 25% 115,993 115,993 - 0% 100 - 100 0%'; 80,628 - 80,628 42%` 1,042,508 961,780 80,728 - 31,228 31,228 BOCC - 628 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End -Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 100,000 $ 95,210 $ (4,790) 100% Revenues Sale Map Photo or Copies 75 35 (40) 50% Interest on Investments 350 355 5 50% Admin Dept Indirect Chgs 180,410 180,484 74 50% TOTAL RESOURCES 280,835 276,085 (4,750) 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 168,772 166,912 1,860 50% 48,449 57,325 (8,876) 50% 50 - 50 50% 13,565 - 13,565 50% 230,836 224,237 6,599 50% n/a $ 100,000 $ 95,210 $ (4,790) n/a' 150 150 - n/a 700 700 - 50% 360,820 360,820 - 60%. 461,670 456,880 (4,790) Exp. 49% 337,544 337,544 - 59% 96,897 96,897 - 0% 100 - 100 0% 27,129 - 27,129 49%: - - 461,670 434,441 27,229 NET (Resources - Requirements) 49,999 51,848 1,850 - 22,439 22,439 Finance - 630 Statement of Financial Operating Data Six Months Ended December 31, 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 40,000 23,788 (16,212) 50% Photo copies - 151 151 50% COLES/CODE Contract 2,723 - (2,723) 50% Interest on Investments 6,000 2,053 (3,947) 50% Interfund Contracts 10,000 10,000 - 50% Administrative Fee 6,000 6,000 - 50% Finance Dept Indirect Chgs 413,937 414,107 170 50% Total Revenues 478,660 456,098 (22,562) 50% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 978,660 1,029,431 n/a $ 500,000 $ 573,333 $ 73,333 30% 80,000 45,000 (35,000) n/a - 151 151 0%` 5,446 5,446 - 17% 12,000 4,000 (8,000) 50%' 20,000 20,000 - 50% 12,000 12,000 - 50% 827,874 827,874 - 48% 957,320 914,471 (42,849) 50,771 50% 71% Exp. 433,395 410,141 23,254 50% 136,022 167,795 (31,773) 50% 5,000 - 5,000 50% 154,243 - 154,243 50% 728,660 577,936 150,724 50% NET (Resources - Requirements) 250,000 451,494 201,494 1,457,320 1,487,803 30,483 47%' 866,790 866,790 - 62% 272,044 272,044 - 0% 10,000 - 10,000 0%t 308,486 - 308,486 40% 1,457,320 1,138,834 318,486 348,969 348,969 a) Will be paid in June 2011. Legal-640 Statement of Financial Operating Data Six Months Ended December 31, 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% Revenues Sale Map Photo or Copies 150 140 (10) 50% Miscellaneous 1,500 316 (1,184) 50% Interest on Investments 750 628 (122) 50% Interfund Contract 7,500 6,364 (1,136) 50% Legal Counsel Indirect Chgs 377,316 377,316 - 50% Total Revenues 387,216 384,763 (2,453) TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 477,216 512,892 35,676 50% n/a $ 90,000 $ 128,128 $ 38,128 47% 300 300 - 11% 3,000 3,000 - 42% 1,500 1,100 (400) 42%;_' 15,000 15,000 - 50%, 754,632 754,632 - 774,432 774,032 (400) 59% 864,432 902,160 37,728 Exp. 374,179 354,402 19,776 50% 47% 748,357 748,357 - 24,238 17,255 6,983 50% 36% 48,475 48,475 - 50 - 50 50% 0% 100 - 100 33,750 - 33,750 50% 0% . 67,500 - 67,500 TOTAL REQUIREMENTS 432,216 371,657 60,559 50% 43% 864,432 796,832 67,600 NET (Resources - Requirements) 45,000 141,235 96,235 - 105,328 105,328 Personnel - 650 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 290,000 $ 351,450 $ 61,450 100% n/a $ 290,000 $ 351,450 $ 61,450 Revenues Miscellaneous 500 13,789 13,289 50% 1379% a) 1,000 13,789 12,789 Interest on Investments 3,000 1,516 (1,484) 50% 25%, 6,000 3,000 (3,000) Personnel Indirect Chgs 362,665 362,665 - 50% 50% 725,330 725,330 - Total Revenues 366,165 377,970 11,805 50% 52% 732,330 742,119 9,789 TOTAL RESOURCES 656,165 729,421 73,256 1,022,330 1,093,569 71,239 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 300,537 290,544 9,993 50% 170,078 54,892 115,186 50% 50 - 50 50% 40,500 - 40,500 50% 511,165 345,435 165,730 50% 145,000 383,985 238,985 Exp. 48% 601,074 601,074 - 16% 340,156 340,156 - 0% 100 - 100 0% 81,000 - 81,000 34% 1,022,330 941,230 81,100 - 152,339 152,339 a) Manley Services Payment Information Tech - 660 Statement of Financial Operating Data Six Months Ended December 31, 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% n/a $ 435,000 $ 480,723 $ 45,723 Revenues City of Redmond - - - 50% n/a - - - Miscellaneous 500 - (500) 50% 0% 1,000 1,000 - Interest on Investments 3,000 1,954 (1,046) 50% 33% 6,000 3,800 (2,200) Leases 10,500 8,810 (1,690) 50% n/a 21,000 21,000 - I T Indirect Chgs 1,011,623 1,011,623 - 50% 50% 2,023,245 2,023,245 - Total Revenue 1,025,623 1,022,386 (3,236) 50% 50% 2,051,245 2,049,045 (2,200) Transfers In-General Fund 33,000 33,000 - 50% 50% 66,000 66,000 - TOTAL RESOURCES 1,493,623 1,536,110 42,487 50% 60% 2,552,245 2,595,768 43,523 REQUIREMENTS: Exp. °io Expenditures Personal Services 912,879 905,688 7,190 50% 50% 1,825,757 1,795,757 30,000 Materials and Services 261,439 204,949 56,489 50% 39% 522,877 442,877 80,000 Capital Outlay 50 - 50 50% 0% 100 - 100 Contingency 101,756 - 101,756 50% 0% 203,511 - 203,511 TOTAL REQUIREMENTS 1,276,123 1,110,637 165,485 50% 44% 2,552,245 2,238,634 313,611 NET (Resources - Requirements) 217,500 425,473 207,973 - 357,134 357,134 1 IT Reserve - 661 Statement of Financial Operating Data Six Months Ended December 31, 2010 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 161,896 $ 212,360 $ 50,464 100% nla $ 161,896 $ 212,360 $ 50,464 Revenues Interest 1,000 762 (238) 50% 38% 2,000 1,500 (500) Interfund Contract - 3,400 3,400 50% n/a' a) - 3,400 3,400 IT Reserve Charges 117,000 117,000 - 50% 50% 234,000 234,000 - Total Revenue 118,000 121,162 3,162 50% 51% 236,000 i 238,900 2,900 TOTAL RESOURCES 279,896 333,522 53,626 50% 84% 397,896 451,260 53,364 REQUIREMENTS: Exp. °io Expenditures Materials and Services 37,000 1,940 35,060 50% 3% b) Capital Outlay 62,000 39,771 22,229 50% 32% b) Res for Future Expenditure 99,948 - 99,948 50% 0% TOTAL REQUIREMENTS 198,948 41,711 157,237 50% 10% NET (Resources - Requirements) 80,948 291,810 210,862 74,000 74,000 124,000 124,000 - 199,896 - 199,896 397,896 198,000 199,896 253,260 253,260 a) From Solid Waste N 0 T.- C4 7 ~ r ~ LL O N ay+ c) r r d N m 0 LL O w r+ C V ~ C V _ \ C 0 0 ~ O r 4) o s U V W d N M O } C 0. 4 O r Co v L U O V N V O co d N M a` LL 0 o co O s U co CO) (D d V O 0 d N a` 0 O 0 CO s U 'd N 0) t5 O 0) N .O LL a 'O r w r V O .O0) N ~ a` U. w r C1 O N 3 } CO LL 0 0 0 0 O O O O O O O O T T T Ln o o Ln LO N V M O O 00 c'! 0 I- 000 co T O O O O O O O O O O O O T r r rn v O O O O 00 M 0 00 ocO O t.- v r 0 0 0 0 O O O O O O O O T r r rn o 0 0 r O O rn LL CMO O C`7 r 0 0 0 O O r O rn O O 000 N O t0 0 co N N t0 co r M O O O O (D r O O M r- LO O CO 01 N r C 0 0 O 1~ T 01 CO O CO M co ~ M 0 0 O ~ h O 0 0 0 0 0 O O O O M M ^ M m NO '1L° 0 0 0 O O O O O n N O LO It co 0 V) V c o v LO 0 N n 00 M T- CO co C6 V7 06 C4 ci C6 CC) M IT w 04 ^ co O C 0 T r r r V% O O O O O O O O O N (D (D O Lr) 0) Go P. N N M 00 1` CA 1` 0 O~ LO G 0 0 O N O r ti r 00 r r 0 0 0 0 0 O O T r-~ N I- 1` It Cf) O N N M M r O r- r- q* le cm N M A O 'r O r v v co Of M L6 T r r 0 ~i 0 0 0 0 o (~I o N N ~ h H'1' st O O u r N N O O O O M N M N r- O o O O N W) M O) r O O O C5 P- CO 00 O co 00 M 0 N 0 a) Cp N r O r r r M M O O O - O W W M r O O O O h O C It N 00 M 0 0 0 0 0 0 M o) co v r 0 0 1 O _ v N_ O 0 0 co CO r r M O r r r CO) O O O O O C) O O 00 O O O O O O O O N O 0 O O O O r r O O O O f` O O N N N N O O r M 1` T r r op; T O N O O O co Mo;=, O M O co 0 O COD O v d O n CC 00 O co co co O rn N N V Go w O LO Oo .1 N O tp o c vi M W) 0 i co a> LO rn v ~z T N r L r I r ER T t Lp W) I-- M 0 0 ~ 0 O 0 0 0 N O M r It 14 CA 00 _ M N O T- (D Co co r r r r VT r r N O O (D 1 " co 40 L _ W N v O ' O 00 M N CD 00 O N M M CO CA 1• T r C N E9 N ~WN Z N N N C CL 7 W 10 Q Z MG) U) ~ c o L1 0: w Y r U o O N d n 06 ati D o U U LO W U Oyi u m rn w N l0 QQ r W E 2 m 2 w O w y a R T W CA Z a O U to H a. 0 V U Q w _y w CL F W 00) W UO w 5 O O X 0 m U Q ~ c 0 U 0' m F LU Cf) N 0 N N E C O Co CD d L1 N M w 00 c 07 O C C N G e Co m ' N x uj 0 N;__rn D > E L) 3 CD ' aL =3 a) z U, 10 w y d E c Co Cn .@ 7 'o a o U r C co 0 a N T T O U) N O N LL O N U) M T d C. N m LL O c 0~1 C •C O O T 0) o tCp t U 'a O w T a)) N O ~ a LL d 110 L U 13 w T d N O ~ IL LL W O to t U V M M T N N O } d LL d o ~ t U N d (D N O a LL 'O T O O 0) N f a } LL 4a T- 0) r V N 7 m LL 0 M i O O M M T 0 cO i M L0 c N tO M T 0 i O to le co O T 0 O~ co 0 0 0 0 O O O O O O O O r r r O U) O to N O h Oo ~ CO CO OMO O r r 0 0 0 0 O Cl O O O O O O r r r O O GO M O O v N r 0 0 0 0 O O O O O O O O r r r N O O O N ~ O O ~ O O M N tM0 M ~ M r t0 0 0 0 O co CA O a) M O O V O O m O 0> N O N M O N T M 0 0 0 O co o O o r O to O I M to a) 000 M W) T r M 0 0 0 O U) O O O O O ONO ONE O r- M O co T co O 40 W) C6 M 0 0 0 0 0 0 0 O O O O M N O O O O O Cl) LO r M M ti x 0 0 0 O r N I~ CIQ O O O N O M o 0 0 r C p c 0 0 0 O CO N to tO tp N r T r T M O O O O tN T O O O O f~ O N 00 M O O O CO O 6 co qr w o c qr N 0 --t CO 0 0 tO M T r T O O O O O O O O O O O O O O O O O O O O T- 0 0 N t~ v M O ~ M r r T y C O r~ lp o w 0 0: W Lt: CL y U Y o 3 z cm C c m 0] ~ y ~i Lt: L U .2 2 a U a D n w U U c o U CO O U y x a o: a N Q ~ N ~ ~ W w u -1 F O N r- 0 0 0 OF O CO 0 0 't LO co v Lo a) It O M T co M U) OOO r- co ~ co 0 r N ~ O O r 0f~ N 0 0 O g~; N ~ ice''. O ~ 00 t"7 ~ r O r T 0 0 0 O O O ~ N co c: M N fl O O O N CO O t` t` It IT N -7 C; O V) r IT v co L r t 0 0 0 O ~ O N 0 0 CO O O r ~ OI t0 N N C O C> a> M T T Y~ 0 0 O O M co a> O 00 M T T u'. 0 0 r h I~ lO M Lo ~ 01 00 N tO v 0 0 N co ui n M LO IT N N M N N I 00 M M r- co O co N O N r O co N O N r o m O M O to 0- o w O O O t0O M :s a p O t0O O n o n tO O O La 0 N O V T to to V v r T T T r V to LO t- M 0 O co N _ co 0 0 CA M 01 00 r N M t0 T CO co M m O 0o r M r v tp tt) v r T T T tR 0 CO M 0 0 O O O N cY O ' r (p 00 M T M M 0 0 ~ M t O 0 ) r w C N C7 w y y ~ U ~ y • ~ • w 2 00 06 W y 2 U y u H W U) IL 0 w Z w a m w w F d N a A M H m m Q F - C O Q W 0 d N F F O X 10 U Q o 0 F W 4 V 0) 0) T O t6 C cm O to LU a y ~ t6 O c rn O C C CO a c CO (6 ' w k C) c C w 0 ) G> 0- i 3 EUc0i :3 1 z to 4) N E A c C6 t6 7 C O OTC c w Q TO: BOARD OF COUNTY COMMISSIONERS FROM: DAVE INBODY SUBJECT: 2011 STATE LEGISLATIVE PRIORITIES (PRE-SESSION) DATE: 1/28/2011 CC: DAVE KANNER, ERIK KROPP Background In preparation for the 2011 State Legislative session, Public Affairs Counsel, Deschutes County's state lobbyists in Salem, provided a list of 150 pieces of legislation that they thought might be of interest to the County. These bills were reviewed by Administration, as well as departments that might be impacted by the legislation. This review identified legislation recommended as the top priorities for the County. This was based on the degree of impact, positive or negative, these pieces of legislation could have on Deschutes County. Priority Legislation Reviewers were asked to make a recommendation whether the County should support or oppose each piece of legislation and how high a priority it should be based on the following guidelines: • Priority 1 - Very important, the County should take the lead in making sure it passes/fails • Priority 2 - Important, the County doesn't have to lead, but should provide necessary support to make sure it passes/fails • Priority 3 - Possibly important, monitor it, but no active engagement Priority 4 - Little or no relevance or impact on the County In some cases, it was determined that support or opposition to a piece of legislation was ultimately a policy decision to be determined by the Board of Commissioners. Information regarding these pieces of legislation is provided below. It is requested that the Board of Commissioners review this legislation and determine whether the County should take a position on each and how high a priority each one should be. House Bill 2151 - Liquor Licenses Requested by the Governor on behalf of the Oregon Liquor Control Commission This legislation allows cities and counties to adopt limits on the number of premises that the Oregon Liquor Control Commission may license for full or limited on-premises sales or off-premises sales of alcoholic beverages or as a brewery-public house. This legislation was reviewed by the Community Development Department. House Bill 2385 - Tobacco Tax Requested by the House Interim Committee on Health Care This legislation removes a prohibition against imposition of taxes by a county on cigarettes and tobacco products. It requires at least 20% of any tax imposed to be used for public health programs or services. This legislation was reviewed by the Health Services Department and recommended support. It was identified as a useful source of public health funding. The Oregon Coalition of Local Health Officials supports this bill and has identified it as a high priority. House Bill 2518 - Real Estate Transfer Fees Requested by the House Interim Committee on Revenue This legislation permits local governments to impose real estate transfer taxes or fees, provided they are structured progressively, based on consideration paid for the property. Transfers for a buyer that is a first time homebuyer are exempt. The marginal rate of tax or fee decreases as the length of ownership by the seller increases. This legislation was reviewed by the County Assessor's Office. It was noted that the legislation does not directly impact assessments and taxation, but this could change depending upon how it is administered. Realtors are currently working to get a constitutional ballot measure that would not allow real estate transfer taxes. House Bill 2609 - Buildable Land Sponsored by Rep. Schaufler Requested by the Oregon Home Builders Association This legislation requires metropolitan service districts to provide a rolling, 5-year supply of shovel-ready buildable lands for needed housing and for industrial and commercial uses. This legislation was reviewed by the Community Development Department. It is identified as a potential benefit to economic development. House Bill 2710 - Court Fees Requested by the House Interim Committee on Judiciary for Joint Interim Committee on State Justice System Revenue This legislation revises laws related to court fees. This legislation would require a 3/5 majority for approval. This legislation was reviewed by the Justice Court and recommended opposition. It was indicated that this legislation would have an adverse impact on the Justice Court. 2 House Bill 2881 - Nuisance Ordinance, Property Tax Statement Sponsored by Rep. J. Smith This legislation authorizes local government that imposes fines or penalties for violation of nuisance ordinances to certify delinquent nuisance fines or penalties to county assessor to be collected in the same manner as ad valorem property taxes. This legislation was reviewed by the County Assessor's Office, the Legal Department, and the Community Development Department. Although the County has few nuisance cases, it was seen as potentially a good precedent for enforcement. However, including something unrelated to property tax on property tax bills was a concern. It is expected to cause an increased expense to the County, result in administrative problems and cause confusion to property owners. AOC has opposed similar legislation in the past. House Bill 2997 - Regional Land Use Planning Sponsored by Reps. Garrard & Richardson This legislation establishes five regional land use planning commissions. The chairs of each regional commission would make up the Land Conservation and Development Commission. This legislation was reviewed by the Community Development Department. Senate Bill 186 - Land Use Appeals Sponsored by Sen. Kruse This legislation limits who can submit land use appeals to the Land Use Board of Appeals to someone who owns, or has ownership interest in real estate property within (x) miles of the real property affected by the decision. This legislation was reviewed by the Community Development Department. House Bill 2658 - Land Use Review Sponsored by Rep. Garrard This legislation establishes different filing fees for participation in quasi-judicial review of local government decisions affecting land use for persons who are adversely affected by the decision. This legislation was reviewed by the Community Development Department and the Legal Department. It was noted the legislation may reduce the amount of fees able to be collected. Additionally, there were concerns raised about the County's ability to cover the cost of appeals. 3 Senate Bill 307 - Transient Lodging Tax Requested by the Senate Interim Committee on Finance and Revenue This legislation expands the allowable purposes for new or increased local transient lodging tax to include funding of tourism-related services. This legislation was reviewed by the Road Department and the Fair & Expo Center. Road supported the legislation because the definition would include road maintenance and snow plowing. Fair & Expo opposed it because their funding might be at risk with an expansion of the definition. Senate Bill 541- Transient Lodging Tax Sponsored by Sen. Johnson Requested by the League of Oregon Cities This legislation expands the definition of tourism promotion to include maintaining public health, safety and welfare of residents and tourists in connection with tourism and tourism-related facilities, including improvements on or adjacent to unimproved scenic and historic areas and open spaces intended for tourists. This legislation was reviewed by the fair and Expo Center and recommended opposition. An expansion of the definition potentially puts their funding at risk. Senate Bill 542 - Transient Lodging Tax Sponsored by Sen. Johnson Requested by Tillamook County This legislation expands the definition of tourism promotion to include roads that serve tourist destinations. This legislation was reviewed by the Road Department and the Fair & Expo Center. Road supported the legislation because the definition would include road maintenance and snow plowing. Fair & Expo opposed it because their funding might be at risk with an expansion of the definition. Senate Bill 316 - Tax Credits, Enterprise Zones Requested by the Senate Interim Committee on Finance and Revenue This legislation adjusts the sunset for long term tax credits for rural enterprise zones. This legislation was reviewed by the Community Development Department. Senate Bill 473 - Energy Facilities Sponsored by Sen. George This legislation allows energy facilities and hydroelectric facilities as outright permitted uses in exclusive farm use zones, mixed farm and forest zones and forest zones. This legislation was reviewed by the Community Development Department. Senate Bill 476 - Planning Goal Exceptions Sponsored by Sen. George This legislation authorizes local governments to adopt an exception to statewide land use goal without demonstrating that statutory standards for the exception had been met for an employer of 10 or more employees. It requires the jobs to be family wage jobs. This legislation was reviewed by the Community Development Department. Senate Bill 549 - Land Use Planning Goals Sponsored by Sen. George This legislation limits the applicability of statewide land use planning goals to areas of critical state concern as designated by the Legislative Assembly. This legislation was reviewed by the Community Development Department. Senate Bill 477 - Farm Use Assessment Sponsored by Sen. George This legislation provides that all land within exclusive farm use zone qualifies for farm use special assessment. This legislation was reviewed by the Community Development Department. Senate Bill 548 - Exclusive Farm Use Sponsored by Sen. George This legislation prohibits the use of income tests to determine whether primary or accessory dwellings customarily provided with farm use is an outright permitted use in EFU. This legislation was reviewed by the Community Development Department. Senate Bill 547 - Secondary Lands Sponsored by Sen. George This legislation establishes policy, criteria, procedures and other factors for identifying secondary land. This legislation was reviewed by the Community Development Department. 5