The URL can be used to link to this page

2012-1707-Minutes for Meeting June 25,2012 Recorded 7/18/2012DESCHUTES COUNTY OFFICIAL NANCY BLANKENSHIP, COUNTY COMMISSIONERS' JOURNAL 11111111 IIII111111IIIIIIII x-307 RECORDS w 20124 707 CLERK Ir + 07/18/2012 08:03:30 AM Do not remove this page from original document. Deschutes County Clerk Certificate Page Deschutes County Board of Commissioners 1300 NW Wall St., Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, JUNE 25, 2012 Allen Room - Administration Building - 1300 NW Wall St., Bend Present were Commissioners Anthony DeBone, Alan Unger and Tammy Baney. Also present were Erik Kropp, Interim County Administrator; and, for a portion of the meeting, Marty Wynne, Finance; David Givans, Internal Auditor; John Laherty and Laurie Craghead, County Counsel; Tom Anderson, Community Development; media representative Erik Hidle of the Bulletin; and one other citizen. Chair DeBone opened the meeting at 10:00 a.m. 1. Before the Board was the Finance/Tax Update. Marty Wynne said there were not too many changes from the previous report. He updated the Board on the Fair/Expo fund, which includes a transfer. The ending/beginning net working capital has changed to a higher amount. He said that most of the larger account balances are a bit higher than projected. This shows stability and that the budget and forecast are close, which is healthy. The beginning net capital figures for the new fiscal year are forecast at the start of budget meetings, and these numbers are very close to those. 2. Before the Board was a Discussion of Possible Code Changes regarding Dog Board of Supervisors Decisions and Requirements. Erik Kropp explained the basic issues relating to dog board hearings. There are some things that need to be updated in the County ordinance for consistency. Chair DeBone said he was contacted by a woman involved in a hearing and there is some confusion. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 1 of 13 John Laherty stated there are two issues to consider. Some County rules do not track exactly with State law. The second issue is where Code mirrors state law but imparts requirements on the County that are not required by State law. A livestock owner can request compensation from the County to cover costs of livestock, requiring the County to file small claims against the dog owner. If the dog owner went directly to court, it would be a one-step process. And it is a burden on the Dog Board members to put a value on livestock. This is not required by State law. He feels this provision should be removed and that livestock owners be required to initiate this type of action in civil court themselves. If the Dog Board members make a decision about the value of livestock, there is no provision for judicial revenue of that decision by the County. It is an obligation that this group is not best suited to address. The definition of livestock in County Code does not indicate if chickens should be caged to be considered livestock. There have been inconsistent rulings on this. The Courts have required them to be caged. Some involve free-range chickens but on the owners' property. Another issue is the requirement for veterinary testing of a dog once impounded, if that might provide further evidence of eating livestock, including a fecal examination. It is not done that often because it can be days before the Dog Board is aware of the case and by then it is too late. Mr. Laherty suggested that this be left as discretionary. The hearings process does not comply with State law, in writing, although in practice it is handled that way. The wording needs to be changed. Chair DeBone stated that there are cases when people let their chickens out during the day or pens are not built well enough to keep out an aggressive dog. Mr. Laherty stated that if the dog comes onto the chicken owners' property, the dog owner is responsible and can be cited for at least dog at large. Commissioner Baney stated that once a dog kills chickens, it will happen again if the opportunity arises. Mr. Laherty noted that despite the relatively small impacts, they are very emotional to the parties. Chair DeBone said that the Code is written to address large livestock killed or injured by dogs. It probably was not the intention for it to include chickens. And there is a need to control dogs that pack together and create a danger to livestock and humans. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 2 of 13 Mr. Laherty said that it gets emotional when it involves the disposition of the dog. Sometimes the dog can be relocated but occasionally it results in euthanasia. Laurie Craghead said the definition of livestock comes from statute, and the County can be more restrictive and not less. There is little case law on this. She is not sure requiring fencing for the chickens can be supported. Commissioner Unger stated that it is a control issue. If someone tries to keep the chickens safe, that's one thing. If the chickens are loose and the fencing is inadequate, that is another thing. Mr. Laherty said that the majority of cases now involve chickens. They may have a coop but let the chickens out during the day. Usually they know it is a dog because the instances are seen. There have been three cases with the same chicken owners recently, but the fence is just three feet high. Two of three dogs were shot by the chicken owner. He knows that this is an issue but does not seem to want to fix the fencing. There should be more responsibility on the chicken owners. This could escalate into a more serious issue. Mr. Laherty asked if the Board wants more responsibility put on the livestock owners. Commissioner Baney asked what the obligation of the dog owner is to contain their dogs. Some dogs will stay close but others won't. Mr. Laherty indicated that in addition to the Dog Board ordinance, depending on the level of the offense a lot of things can happen; but there is a dog at large ordinance which cites them into court, resulting in a fine. There are serious consequences for people who do not contain their dogs. They can be cited for dog at large regardless of the livestock impacts. Commissioner Unger thinks that the livestock needs to be protected in a reasonable way; and dogs need to be kept on their own property as well. Mr. Laherty added that rabbits and other fur bearing animals need to be confined; but there is nothing noted for poultry. The Dog Board may have to make a determination as to what is considered adequate for protection. A cage would have a roof, a fence would not, so what is "reasonable" needs to be determined. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 3 of 13 Commissioner Baney and Chair DeBone support reasonable containment, a reasonable good-faith effort. It is implied that there should be an exception for those returned to the owner. Also, it is unclear what evidence has to be received in order for law enforcement to impound a dog. At this point it has to come from a complainant. A situation was that the livestock owner wanted the dog impounded, but the livestock owner would not sign the complaint. The livestock owner did not attend the hearing, either. The evidence should include a written complaint form signed by the livestock owner. Commissioner Unger said that the Deputy should be able to do this if there is clear evidence of the offense. Mr. Laherty said that it might be a recurring problem with a specific dog and the Sheriffs Office says the Deputy can sign the complaint in those cases. Regarding substantial additional evidence done through a veterinarian, this should be within the discretion of the County. The dog owner is supposed to complete a hearing request form, but this is not set forth in Code although it is in State law. It is what they have been doing anyway. State law requires any decision of the Dog Board to be supported by substantial evidence, but this is not noted in Code. Code allows the Dog Board to charge the complainant if the dog is not found guilty; the complainant would pay the impound fees. Ms. Craghead said there is a one-time $20 impound fee plus there likely are daily boarding fees. Mr. Laherty said that historically the bill for the impound fees is paid by the dog owner or the County. Some of these cases have deeper issues between neighbors. It might make sense to have this in place in case it is not truly a dog board case. State law requires that any dog found guilty of these infractions is to be ID chipped. Code does not address the requirements of mailing the decision to the dog owner, although this is required by State law. It is done this way now, but needs to be in writing. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 4 of 13 Code allows the livestock owner to submit a claim for compensation to the County, and that this is paid by the County. The County would then have to seek reimbursement. Small claims require a preponderance of evidence, when it is just substantial evidence before the Dog Board. Commissioner Baney asked if there could be a cap as to what the Dog Board can set as a value of an animal. Mr. Laherty said there could be, and the livestock owner can take any additional amounts to small claims court. The costs to the dog owner can be $500 to $1,000 or more, and rarely does the County get reimbursed for the costs of housing the dog. Trying to pursue further costs would likely be fruitless. Commissioner Unger asked why this does not go to Justice Court instead of Circuit Court. Ms. Craghead said the decision of the Dog Board is final, and anything further has to be in Circuit Court. Commissioner Baney asked if the County can require the dog owner to pay the livestock owner direct. That is a civil dispute. Ms. Craghead indicated the livestock owner could not enforce it. Ms. Craghead said that the County pays impound fees for dogs to the shelters, and if there is any further amount coming from the dog owners, the shelters keep that as well. However, it is rare that the shelters get both. If someone comes before the Dog Board and has a substantial loss, if there is a limit set, the balance needs to be pursued in civil court. The Board spoke about a $100 limit to cover smaller cases. Mr. Laherty said they can tell the livestock owner to file a small claims case for anything larger. The Dog Board could have authority to make an award for smaller cases. Commissioner Baney feels that the fact that there is a dog at large citation plus a hearing, some people will feel there has been at least an effort made towards resolution. Commissioner Unger thought maybe the Dog Board should have some flexibility if it is under or over a certain amount. Chair DeBone feels that setting $100 is too rigid. Mr. Laherty thinks a cap is appropriate. Commissioner Unger thinks $500 is appropriate from the County as there are other avenues to pursue a higher amount. Commissioners DeBone and Baney said that a $100 limit is correct, but this can be revisited if needed. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 5 of 13 Mr. Laherty stated that the current wording is that the County `shall' file against the dog owner, and this should be worded to `may' as appropriate. In regard to adopting this by emergency, Ms. Craghead said it might be wise to do so to remove the `shall' requirements. Chair DeBone would like this to have a public hearing, possibly with first reading at one meeting and second reading at another. 3. Before the Board was Consideration of Signature of a Support Letter for Renewable Energy Proposals. Commissioner Baney felt that the request for this letter is non-partisan, simply that counties be allowed to share in the profit from renewables on public lands. This might be appropriate since nearly 80% of the county is publicly owned. It is supported by NACo. Commissioner Unger stated that this would help give local control to local impacts resulting from the development. This is on a national level. If this is going to happen, the counties should be allowed to share any revenue to offset the potential impacts at the local level. This is similar to what has happened with forest revenue but would be for geothermal and other energy resources. At the request of Chair DeBone, one paragraph was stricken and some minor changes made, but the rest was felt appropriate to sign. BANEY: Move signature of a letter of support. LINGER: Second. VOTE: BANEY: Yes. UNGER: Yes. DEBONE: Abstain. 4. Before the Board was Consideration of Signature of a Support Letter for Governor's Volunteer Awards (Jericho Road). Mr. Kropp gave a brief overview. It is an annual award at the State level. BANEY: Move signature of a letter of support. UNGER: Second. VOTE: BANEY: Yes. UNGER: Yes. DEBONE: Chair votes yes. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 6of13 5. Before the Board was Discussion of Local Animal Welfare and Consideration of Coordinating Programs and Efforts regarding Shelter Activities. Commissioner Baney wants to see a round table discussion of all parties who provide spay/neuter services to animals in the community. The underlying problem is pet overpopulation, primarily concerning cats, and the lack of resources to control this. There is Cat Rescue, Adoption & Foster Team, Bend Spay/Neuter Project, the Humane Societies and a few others. Clarification is needed in terms of who should be taking on the role of educating the public and taking control of this problem. She wants to know if there is a role for the County to help encourage this effort. Ms. Craghead said this is part of the contracts with the humane societies. Commissioner Baney feels that there is a problem that is not being addressed, and perhaps the County has a role in this. The question is whether the Board is supportive of convening these groups, and have a conversation as to who is doing what in this regard. It is mostly a cat issue but should relate to all companion animals. Chair DeBone said he is not a cat person but will go with the recommendation for now. Commissioner Unger said that to get to a no kill status, spay/neuter would help to get to critical mass. It will be an issue of how the costs get covered. Commissioner Baney feels there should be a countywide and perhaps a regional effort in this regard. The Board is supportive of these efforts. 6. EXECUTIVE SESSION, under ORS 192.660(2)(h), Pending or Threatened Litigation. The Board took action after the executive session. BANEY: Move signature of an Order allowing staff to inform the Court, upon receipt of an official remand of the Court, that the matter is to be remanded to a County-appointed Hearings Officer. UNGER: Second. VOTE: BANEY: Yes. UNGER: Yes. DEBONE: Chair votes yes. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 7of13 7. ADDITION TO THE AGENDA The group took a short break, after which Consultant Greg Prothman joined the meeting, as well as the assistant to the County Administrator, Dave Inbody, and Anna Johnson, Communications. Mr. Prothman and his company have been selected to assist the County in the recruitment of a new County Administrator. Mr. Prothman said that the openings for positions such as this one has remained fairly low, in large part because of the economy. Many people have remained in place. Mr. Prothman said they have taken the first cut at a recruitment brochure. What has been left blank is the `ideal candidate' information. This will be the measuring point, and the Board will need to advise how far and wide to cast the net. They typically start in the west or northwest, and distribute about 800 letters. These would mostly be directed at those people living in comparable size communities. Commissioner Unger said the community size criteria did not work with the Redmond Airport; they ended up with a hire from a much larger community. Ms. Prothman said they could expand the search higher but probably not go into a smaller community. They place additional advertising where county and city administrators would see it. A lot of people have their site bookmarked as well. It will be by definition a national search, but there would be a better chance of success of attracting candidates from Colorado and west, where there is not as great a cultural difference. He will review applications and begin the screening process. He can identify those that are rising and eliminate those that do not fit. He will then do interviews as appropriate. Soon he will be prepared to update the Board. There would have been preliminary background checks and Skype interviews. The Board can go through the entire stack of resumes if desired, but at least the top 15 or 20 to see who, in their opinion, rises to the top. Commissioner Baney said they went through a similar process and felt that they had two good candidates, but those did not work out. She asked if there is a secondary component in this situation. Mr. Prothman stated this is an important issue, but there is a time factor involved; therefore, they do not want to wait too long to act. If no one is found, they would conduct a further search. If the person does not stay with the County for more than two years, not including natural causes, the firm would do another search at that time. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 8of13 Mr. Kropp asked about the background check. Mr. Prothman said they ask for structured references, such as supervisors, subordinates and others that are not just the cream puff references. They will look also outside of those. They get a sense of the pattern of employment, strengths and weaknesses. They verify credit and criminal background. Some did not finish their degree as they claim. Candidates are asked to disclose any involuntary separations or any lawsuits or similar issues in the past, no matter how it resolved. Mr. Prothman said that an investigator can be used for further background research. Commissioner Baney stated that people seem to be hesitant to come forward with whatever weaknesses they may have. The level of disclosure or remembrance was widely varied. She wants to make sure it is different this time. Mr. Inbody asked what the biggest roadblocks or concerns are. Mr. Prothman said that they can generally figure out when someone is not being completely truthful. They have done about 90 executive searches and three did not work out well. He feels the process works and they know what to look for. Candidate-supplied information is important, but so is input from others. He looks for job patterns, especially if they are not completely accurate about dates of employments. They look at the various skillsets needed for this type of position. He can generally pinpoint any issues with particular skills, and whether the same skill issue was the reason the person is no longer with a previous employer. Commissioner Baney stated they will be asked by the media how this search will be different from the last. Mr. Kropp said that the firm will talk some people into applying and others from not applying, outside the public eye. Mr. Prothman said that credibility is important, and also being at arms-length. Some candidates will contact him and ask if he thinks they might be a good fit for a position. Commissioner Baney may have a few names to forward on to Mr. Prothman. Mr. Kropp said he also has a list. Mr. Kropp asked about whether having city or county experience makes a difference. Mr. Prothman responded that some have both, but generally the skills are transferable. Counties are more difficult due to a wider range of issues they have to address. Some counties provide more services than others as well. There is a learning curve in any case. The working relationship with the Board is the key component, along with the culture of the organization and the area. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 9 of 13 Chair DeBone asked how much Mr. Prothman ends up being a mentor or career coach. Mr. Prothman said they help managers to be successful in what they do. There is a personal connection with many of them. Anna Johnson asked how he would learn enough about the local culture to convey this to others. Mr. Prothman stated that this is challenging, and he hopes to learn some of that by talking with department directors and others. Having Mr. Kropp as a key player in this process is encouraging. Commissioner Unger asked if $120,0004150,000 is the right salary range. Mr. Prothman said it is a challenge to know if this is the right amount. The metro areas tend to pay more, but the work is more complex. He does not know enough yet to know if the top salary is sufficient to attract the best people. However, there are political realities to consider. The proposal will include a salary survey. Mr. Kropp said the previous Administrator was terminated by a two to one vote. He asked how this concern might be addressed. Mr. Prothman said that there can be a wide variety of reasons for this that are not necessarily tied to job performance. He wants to give candidates the best explanation possible and where potential pitfalls may be. Commissioner Baney asked how much research he has done on the Board. Mr. Prothman said his wife has done much of it. The process starts today. He is aware of the amenities of the area. He added that he assisted the City of Bend with the search for Police Chief. Mr. Kropp asked how candidates feel about a three-member Board. Mr. Prothman replied that the more sophisticated ones know they have to be credible with all three. They have to confident they are giving all three the same input. Some think three is good because it is more manageable. Those who are concerned about this may have other issues. Commissioner Baney said that they need to understand the boundaries about talking about things that may lead to a decision. Commissioner Unger stated there is a macro view with the world, and a micro view at the local level. Someone needs to understand budgets well and work with departments, but someone needs to watch what is happening in the big picture. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 10 of 13 Mr. Prothman said that in his experience, managers often are focused on the short-term but need to look at least five years out, and think strategically. The Board has to rely on the Administrator to have the whole picture in mind, external and internal. The Administrator has to be sure the departments are being run consistently and are achieving goals. Commissioner Unger asked about training. There may be areas that need improvement, but that did not happen with the last Administrator. Some things cannot be changed while others can. A person needs to be adaptable to the current situation. Mr. Prothman stated that the person has to have fundamental core skillsets. Those have to be in place first. It is not like a small city where you might be able to learn as you go. The basics need to be there, and minor changes can happen later. Mr. Kropp said that the Administrator has to do actual work. There is not a lot of staff to pick up the slack. The Administrator has to make decisions and get involved and not just delegate. Mr. Prothman feels that it is critical to do staff reports and work with the media. The number of candidates that expect a lot of staff help is getting smaller. Commissioner Unger voiced concerns about how the spouses are handled. Mr. Prothman stated that he always asks about the family. Does the spouse work and plan to continue on a career path? Are the children at an age where this might be critical? There has to be a family plan, including the sale of the current home. He recommends bringing out the spouse for interviews, and have a program set up for the spouse to meet with employment counselors if appropriate, and see all the amenities of the area. Debbie Legg said that it is important to have that conversation early on so it does not become an issue later. Mr. Prothman confirmed the afternoon's schedule and the plan going forward. (See attached form.) Advertising can start as early as next week. He is racing a deadline that has to do with the school year. This will help with those candidates that have children in school. There are concerns about vacations but via Skype, interviews can be handled from about anywhere. There is no perfect time for everyone. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 11 of 13 Commissioner Unger said they opened the position up to the private sector. It was very telling that there were great differences. Mr. Prothman stated that when you get down to selection, you find decisive people that make quick decisions in the private sector, but it does not always fit in the public arena. The process is important even if the decision is the right one. Public sector managers have to know policy enough to know what can be done quickly and what needs a greater process, more input from the Board or citizens. If the person has served in public sector agencies, they may have applicable skillsets. But if they have no public sector experience, they may be frustrated by the public process. Commissioner Unger asked whether the Commissioners should talk with anyone who calls them about this. Mr. Prothman said that most candidates will stick with the process. Those should be referred back to him, as they all should know that there is a process to follow and this could be a red flag. It is like a land use process where the Commissioners can't receive information outside of the process. Commissioner Unger asked what a typical job length is for a position like this. He feels five or six years is probably where most end up. Employees with the County tend to stay for twenty years or longer. Mr. Prothman said the industry average is about 3.5 to four years, although some have been in place for decades. If the fit is good, and they enjoy the work, they could stay for seven or eight years. They tend to closely look at those who have not been in a position for two years. They tell candidates that they need to be able to commit for at least five years. Mr. Kropp said that individually the Commissioners should tell Mr. Prothman what is expected when working with other elected officials, especially the District Attorney and Sheriff, who are elected officials and have very strong personalities. Being no further discussion, the meeting adjourned at 1:20 p.m. Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 12 of 13 DATED this I Day of 2012 for the Deschutes County Board of Commissioner Anthony DeBone, Chair ATTEST: Recording Secretary atA4,- V~~ - Alan Unger, Vice Chair Tammy Bane', Commissioner Minutes of Board of Commissioners' Work Session Monday, June 25, 2012 Page 13 of 13 -~r-- C Deschutes County Board of Commissioners 1300 NW Wall St., Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 10:00 A.M., MONDAY, JUNE 25, 2012 -Note earlier time! 1. FINANCE/TAX Update - Marty Wynne 2. DISCUSSION of Possible Code Changes regarding Dog Board of Supervisors Decisions and Requirements - John Laherty 3. CONSIDERATION of Signature of a Support Letter for Renewable Energy Proposals - Commissioner Baney 4. CONSIDERATION of Signature of a Support Letter for Governor's Volunteer Awards (Jericho Road) - Erik Kropp 5. DISCUSSION of Local Animal Welfare and Consideration of Coordinating Programs and Efforts regarding Shelter Activities - Commissioner Baney 6. EXECUTIVE SESSION, under ORS 192.660(2)(h), Pending or Threatened Litigation Mark Pilliod 7. ADDITIONS TO THE AGENDA 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; ORS 192.660(2) (b), personnel issues; or other executive session items. Allen Room - Administration Building - 1300 NW Wall St., Bend 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. 'i CN _ i O N ' N O ' N C ~ C E . ~ ! I I c 0 s ca. ~ i i l~ I i o Ise o ~I I I Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA June 25, 2012 (1) Monthly Investment Report (2) May 2012 Financials Ql A r~► r v ~ rm v E r ti r- CO ED ~ r o N ~ tQQ ~ t9 f~ U ~P C %l . {y W) tD in ch M T H N go rp+ r r ~ V N H N Z LL O tl! ~ r C o row ~g H N ~ c~ M O 3 Is M O w ti v N , r O r ~ O1 N ~ ~Y pf I► N 0 T Y! 140 III ip 21 C. al V, ~ v y~ C Docurnent Reproduces Poorly (Archived) 0000 90 Q H U E I U- to N a 7+ H r C d E y > I ~ I ~ m 0 •0 a m 0 m N d m LL CM d U Ern m U N td N 0O o O O Z U - V m c° d M1 J ~ I I I -.z X11 1 IIo _I,~ o e !c 1 I VI U U U UIU:U U UIU UIU UIU UIU U U UU'IU UIUI olv c ~I°o1' o K! Z Z Z. ZI, ZIZ Z'.Z ZIIZ Z Z'.,Z Z'I ZIZ Z ZIZ Z ZIZ co ro~:. .I p'. 0 I 0 0 c c o'I rv', o o o LT LT I n~ e- Z I I Ir I I I I I ~I I _ I ml Lo l I d 1- n R 4 4 n I n' m. CA W M to ! p W R N II O o l N to CO Cn ~ I M CD n co Q b O (D (D ~ OCO 4 07 co CO o N LrJ M L[) CO R N M 0) a O O N Ln OO O CO R a.. o r CO r: . co : o Lp ! r I M I W c-4 M II O I N 1I O d I n li l m. co O 0: LA r n t- CO C•7 4 CD ti LA M Co O N m 00 '00 0(o CD m CO n to 6) CO m O o , M m d• n m O n n O G r± N~oI. N:.n RI 4'mIN NI:. N!bCD NI: LO nI ~rIQ Nl ml, rl OEM, b't'.. o Lf) Ln : CQ N 4 n R N o, ti r N (D ! r R ti. m I N co IN~,. ~~N r ~41r rlLf)I o(i')'.(° LA r 3 E ' N :CA to R R I N. N' r I, M r 6' CD I O I CA N! R 4' N m COI co LO LO R N O N p N4p 0 0 0 CV O N O r r 0', O Nr j d O M Ln 11r O p N 4 n 0 IN NIA N NI. NI N', N! N N r C N!N N. iN N. m411n N: NIII <AI EMI 00 N 'I r wl, W O d 0:010 4' O CD b d n O p ICI N u) M :.I 11 d o 0 0 co d a a Mlc p'p o 4cD nw O C) O O olld Ln:d a rlp a: ? l l l l : l: o o N (D 6 o olmlo obo o co co oo Ln, o o no o C-)!- In N Co ap O 4 N O M CO d N N rV CI M R m O O R N: 00 O b'm :dt CO n C I OM) r r O r r l (D O N O p p p n N 0 CO m N (O U-)Lf) CO N O m : N Cn : u) u7I u7 4 N LO N 04 -t CO O: O N p -t (P d I~ QI~ (V:O O a, olO N M N LnI R: 41 LO W O r d o -,t.0 O N w Io n Y N 4 N 0 0 O b O o l O l p p r r CO O N O O r r a O to II. O iCVI C4 N N N NI, NI N'N SIN N.N N :C4 C14 n Cl) C; N I I I O' Lo LA III : I 4 4 0 o O l b b: M O O o p 4 4~ 4 o o O o : d W N o: p p p q 0 0: Ol d d:. 7 O o o p p 4 0 0 ~ o O b a o o: o p O p l 4:~ 0(D (D l ~ O l 0 o 0 o 0 0 0 o 0 0 o o CO ti CO O ~'I O 11 01 a (O (01010 4 CO r O (D o b d O O O O O p M Im U ! O I cl b d d• ! CA ! o O p R U.) r m O o l n d d d a O! O Ln n b u) COI ! R o' e p p 4 r ! O O Lr M ti o O n R I p 4 4 CD O o d (f) r N C -,f N C! O r p' r 4 C) (.0 Lo 00) o' co) N o p p LL7 O 0) Lf) ~(D ICn O H ~ I p N p 4 r r' O CA R LD ' to 1. Y I CV N N: N: N N N N N N N' N N r- V: N M C) N M O I I CI I -A CL (n 1 U) CL w U U -lo R -1 -R (D o:o'v a a'a e'e a 1° 3~ 0 3EI N li IF C I O CD 0 M M I M 0 0 0: 0 4: 4 0 0. 0, 0 0 0 0 0 '1 0 o M N CD (D •U C) t' N¢ 1 Q' o •O d1 Lf):. n O LO N LA' Cp LO p' p O' Lf) CO. (O :i Lf) O LO d' LU n u)I CN Co C I,W) (D M a N [Q n 1, q) : ti l . LO' U") (D Col p' p N O Lp b n : r m d Ln " LO 1'' f+ (O IN co E U C) _ G o p 4 4 CD O O O- I Y o o p r r' p O ~ 16 O 1 C i O O I C7 O :I ~ Q'i, N F N r Q. .R-• OI OI E!U)I yl N O UIU'.F17 LL:co H LO O Lo p 4' O O b o o 0: O p l 1 O r n O N p Lf) LO C3 LO LD b a' Lo ! 0. ro M O (D 9 n N co Ln Un N: M Lo C\l LO Cl) LO U') 0 VI N o v m p I I 1 y d I I I ` W BCD ° O! T M M(-M 4:. NnI (D In CO !~I r`I 1 y'.~ 1. Q Zol p LO It LO LO Li11uu Lo u°) u)': M, n' N u) n M r-I nIl(D n n nl'N N N N N NN p(yj 0 ~ ti tiµ MIC :...._..h-- -.~T y 3 c) m m'm c) c) m co m:m 'Lu > O r= ao nla!(n Q'col`m rn ao LDI~ d L)I~ p rnl,rn ` nl~ e~ g ~3, O Ip1p p NIO O~ O. IM: M O N N:4 p 4'N r y ro'jd U I I I W Cl MIM MICA. OI p~r.~ r: MI RI in Ln '.co N.N ('O 4 Lko OI,O O!blol Ol, O.r rl0. o!O141,Q 4I CD: O.4.O.e-. r- O 'Q oIJ m N OIIO O O oI'p r r~ r1 r r r .N-- III ~ N M (D O, r 4 m' r M~ I~ d' M 6 W 1 r O m CA ~D iq n ~ I, I. I I I ` ~ b a o I r N o O 4 1 N N O ro m: N NIN N O N o N: r I I I 3 NIN N : N m N <T tT O (V M C r I u) co 4 N N o`) I LL fl , r 4 0 o 0 1 0 O r 0 O 0: r! p p 4 r r r 4 Q U Q Or ~I LL Co } I, m Z `J I F' d Q I, a' 2 i Q d U I CL (L ix V) U) in ul -O O O < LL OO O' U Z U Z: Z ❑ CD ¢ Z~ -I- add1 H H LL U LL L) LL LL Z LL LL Q m LL C) Z ¢ 7 OF LL LL Z Z I` 9 LL U) (,L :D ~Z , Z U) U) D Z a LL ~ 1I R: U) (A 2 U- Un (A i L I . UDI W } Y', = 1 LL Q : II I'I I I, I ! II: E Y z~x (7', <1cl) N ❑.m mI C7 2 II : I 7 F P- C7 (910 Rt' o O Z n a C7 P, O. M 'M. m~~ M., cDI(D (DI 4:, nI n IM m ("~I MI :OBIT O>I, INI Q) I 4) LA. :e) mI,' 1 O M ! (h m M M Cl) Cl) Cl) n 0) QNj G ~ UIIIU U U: 0 O Z, c'I c Y a) ~I, roI p d v mI m v U UT III U t4 (n m c mI c m ro n V) ~I Q U n J N' N ~Im Co y° M n: ro ro 'm .a -Q c v x ~'I U c m a - 1 m a §i i m x (3'1 w V p p o Y o (a: m La x c ~I M p c IL) N M' 2 a n1 m U S c ' LL ° F Y c.U c m c: m p m' 1 I v ro ~ ro 0 Z 1 o rn-- W U'. cU'I U N '.U UU (0 m 71 C U co p_IE o y. vl d' Im CA m m co y ~'z! ro L o v Q'z O MILL r- i m II ~ z j ro a v''I roIa m m t m Y C) i° p m a)❑ C) 7 LL (6 U Q) c' c: c v v v ro U' c m v EI m m wI.S Q vI E: ° C (tll N Ld C6 v' m. N' N N O,, T'j O Y Y 01 p)E 0 a - aj N N H Q 'm' + m www wlm cjm roIIro mlaIo m c''I1 'ImIaroi oE m ko'I01a•O).Ecn E - to co co U U Y d m Un ❑ m U U LL _ m cz LL C) M: F-- LL v, O 7 LL ' G T_.._. CD CD CLI rte Q., J m CL 1 - N (U N I o ' -C I 00 ` E w ~ ma c ro v E> s o v Ln 0 Y E 2 (x = U J E o o ai aci aci o o ~ o t o yv o Z 2 w m 7) Li- CL ID.LLILL'LLI~ _ ~L~ 2:U:al y :(nICALL LL J.m r~ Memorandum Date: June 18, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find May 2012 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriff's (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 Revenues Property Taxes 18,425,886 21,346,272 2,920,386 92% 106% a) 20,100,967 21,446,272 1,345,305 Gen. Rev. - excl. Taxes 2,183,794 2,154,028 (29,766) 92% 90% b) 2,382,321 2,382,321 - Assessor 725,080 755,202 30,122 92% 95% c) 790,996 790,996 - County Clerk 1,346,315 1,321,121 (25,194) 92% 90% 1,468,707 1,412,207 (56,500) BOPTA 11,365 14,788 3,423 92% 119% c) 12,398 14,788 2,390 District Attorney 273,780 210,114 (63,666) 92% 70% d) 298,669 325,676 27,007 Finance/Tax 177,742 210,547 32,805 92% 109% c) 193,900 210,547 16,647 Veterans 56,229 52,331 (3,899) 92% 85% 61,341 64,351 3,010 Property Management 88,183 88,683 500 92% 92% 96,200 96,200 - Grant Projects 1,833 1,833 0 92% 92% 2,000 2,000 - Total Revenues 23,290,207 26,154,920 2,864,713 92% 103% 25,407,499 26,745,358 1,337,859 TOTAL RESOURCES 30,590,207 34,400,645 3,810,438 92% 105% 32,707,499 34,991,083 2,283,584 REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non-Departmental Contingency Transfers Out TOTAL REQUIREMENTS NET (Resources - Requirements) 3,121,525 2,992,393 129,132 1,305,301 1,031,404 273,897 66,369 58,648 7,721 4,472,688 4,169,861 302,827 745,844 696,771 49,073 240,272 233,377 6,895 236,192 235,709 484 108,822 108,871 (49) 1,665,549 946,019 719,530 4,790,253 4,790,253 16,752,815 10,473,051 6,279,764 12,813,726 12,554,322 259,404 29,566,541 23,027,373 6,539,168 1,023,667 11,373,272 10,349,606 Beginning Net Working Capital per Adopted Budget Exp.% 92% 88% 3,405,300 3,283,300 122,000 92% 72% 1,423,965 1,183,965 240,000 92% 81% 72,402 72,402 - 92% 85% 4,879,296 4,511,771 367,525 92% 86% 813,648 799,648 14,000 92% 89% 262,115 260,100 2,015 92% 91% 257,664 257,664 - 92% 92% 118,715 118,715 - 92% 52% e) 1,816,962 1,700,962 116,000 92% n/a f) 5,225,730 - 5,225,730 92% 57% 18,275,797 12,188,527 6,087,270 92% 90% 13,978,610 13,978,610 - 92% 71% 32,254,407 26,167,137 6,087,270 f) 453,092 8,823,946 8,370,854 8,700,000 a) Projection is year to date actual plus $150,000 estimated to be received in June. b) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823 c) A & T Grant received quarterly-July, October, January & April. Total budgeted $847,898; total received $840,927 d) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes nine months of receipts) e) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June and is projected to be $116,000 less than budgeted f) Appropriation (authority to spend) transferred to Video Lottery Fund $34,697, F & E $47,295, Annual Fair $46,100 and Funds 160/170 $325,000 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Eleven Months Ended May 31, 2012 to Daa d Bud et Actual / nce FY % Call. % Budget Protect o n I 1 Variance RESOURCES: _ Beg. Net Working Capital $ 1,101,374 $ 1,099,010 $ (2,364) 100% 100% $ 1,101,374 $ 1,099,010 $ (2,364) Revenues Federal Grants 9,167 6,932 (2,235) 92% 69% a) 10,000 10,000 - SB #1065-Court Assess. 45,833 43,916 (1,917) 92% 88% 50,000 50,000 - Discovery Fee 13,750 12,868 (882) 92% 86% 15,000 16,000 1,000 Food Subsidy 22,917 21,489 (1,428) 92% 86% 25,000 25,000 - OYA Basic & Diversion 199,373 266,982 67,609 92% 123% b) 217,498 355,730 138,232 Inmate/Prisoner Housing 81,116 65,420 (15,696) 92% 74% c) 88,490 80,000 (8,490) Inmate Commissary Fees 92 220 128 92% 220% 100 250 150 Contract Payments 64,167 84,213 20,046 92% 120% d) 70,000 111,000 41,000 Miscellaneous 55 337 282 92% 562% e) 60 400 340 Program Fees 37 - (37) 92% 0% 40 - (40) MIP Diversion Fees 275 1,040 765 92% 347% e) 300 1,200 900 Interest on Investments 6,875 7,424 549 92% 99% 7,500 8,000 500 Leases 2,200 1,200 (1,000) 92% 50% f) 2,400 1,200 (1,200) Grants - Private 458 934 476 92% 187% 500 1,000 500 Behavioral Health 5,500 2,905 (2,595) 92% 48% g) 6,000 5,500 (500) CFC Interfund Grant 141,284 109,341 (31,943) 92% 71% h)i) 154,128 134,620 (19,508) Gen Fund Grant-Crime Prev 18,333 15,000 3,333 92% 75% i) 20,000 20,000 - Total Revenues 611,432 640,221 28,789 92% 96% 667,016 819,900 152,884 Transfers In-General Fund 4,878,005 4,878,005 - 92% 92% 5,321,459 5,321,459 - TOTAL RESOURCES 6,590,811 6,617,236 26,425 92% 93% 7,089,849 7,240,369 150,520 REQUIREMENTS: Exp. Expenditures Community Justice-Juvenile Personal Services 4,683,313 4,531,380 151,933 92% 89% j) 5,109,069 4,970,000 139,069 Materials and Services 1,118,089 1,056,440 61,649 92% 87% b)h) 1,219,733 1,155,000 64,733 Capital Outlay 36,758 - 36,758 92% 0% 40,100 40,100 - Transfers Out 46,200 37,800 8,400 92% 75% 50,400 50,400 - Contingency 614,668 - 614,668 92% n/a 670,547 - 670,547 TOTAL REQUIREMENTS 6,499,028 5,625,620 873,408 92% 79% 7,089,849 6,215,500 874,349 NET (Resources - Requirements) 91,783 991,616 899,833 - 1,024,869 1,024,869 Beginning Net Working Capita l per Adopted Budget 1,010,415 a) Federal Grant billing, reimbursed quarterly in arrears b) OYA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly c) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated Billings outstanding - $7,080 d) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears, trending higher than anticipated e) Revenues trending greater than anticipated - dependent on use of programs or services (MIP Diversion Fees, photocopies, etc) f) Citizen Review Board vacated. Revenue projected adjusted accordingly g) Due to change in practice, Behavioral Health's referrals for functional family therapy have decreased--$2,352 billing outstanding h) CFC (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly i) Grants paid quarterly Page 2 j) Actual for the year projected to be less than budgeted due to vacant positions SHERIFF - Fund 255 Statement of Financial Operating Data Eleven Months Ended May 31, 2012 RESOURCES: Beg. Net Working Capital $ - $ - $ - Revenues Law Enf Dist Countywide 20,244,419 16,636,037 (3,608,382) "13;24407. 10583.298 t338) Total Revenues 33,489,056 27,219,336 (6,269,720) Year to Date rRevised Year End Bud et Actual Variance FY % Coll. % ud et Projection Variance 100% n/a $ - $ - $ - 92% 75% * 22,084,821 18,593,066 (3,491,755) 92% 73% * ' 14,446,696 1.15763,488 '(2,685,207) 92% 75% 36,533,516 30,356,554 (6,176,962) TOTAL RESOURCES 33,489,056 27,219,336 (6,269,720) 92% 75% 36,533,516 30,356,554 (6,176,962) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications Investigations/Evidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non-Departmental Contingency Transfers Out - D/S Fund Exp. 2,368,613 2,255,139 113,474 92% 87% a) 2,583,941 2,478,941 105,000 755,420 686,982 68,438 92% 83% b) 824,095 748,995 75,100 1,567,431 1,386,838 180,593 92% 81% c) 1,709,925 1,558,107 151,818 1,589,700 1,315,878 273,822 92% 76% b) 1,734,218 1,538,664 195,554 7,337,645 7,188,858 148,787 92% 90% b) 8,004,704 7,862,704 142,000 660,651 635,441 25,210 92% 88% 720,710 694,610 26,100 9,630,983 8,639,348 991,635 92% 82% d) 10,506,527 9,704,527 802,000 262,719 251,967 10,752 92% 88% 286,602 275,402 11,200 176,848 161,931 14,917 92% 84% 192,925 175,525 17,400 1,223,898 1,009,995 213,903 92% 76% 1,335,161 1,283,161 52,000 2,766,927 2,620,514 146,413 92% 87% b) 3,018,466 2,868,366 150,100 297,243 241,463 55,780 92% 74% 324,265 285,165 39,100 579,568 557,857 21,711 92% 88% 632,256 609,156 23,100 67,128 67,128 - 92% 92% 73,231 73,231 - 4,020,949 - 4,020,949 92% n/a 4,386,490 - 4,386,490 183,333 200,000 (16,667) 92% 100% 200,000 200,000 - TOTAL REQUIREMENTS 33,489,056 27,219,339 6,269,717 92% 75% 36,533,516 30,356,554 6,176,962 NET (Resources - Requirements) * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Less than planned personnel and software maintenance expenditures b) Less than planned personnel expenditures due to open positions c) Expenses for Communication System Study will be incurred next fiscal year d) Less than budgeted expenditures due to open positions, jail bed rental expenses, and jail management software costs Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Eleven Months Ended May 31, 2012 RESOURCES: Beg. Net Working Capital Tax Revenues - Current Tax Revenues - Prior Federal Grants & Reimb State Grant Transp. of State Wards SB 1145 Prisoner Housing Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport Other DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Inmate Telephone Fee Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Debit Card Fee Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Donations - "Shop with a Cop" Donations Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments- Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Non Dept - ISF Charges Non Dept - Jamison D/S Contingency Total to Fund 255 Transfer to Reserve Fund (703) Total Requirements Net Year to Date Year End Budget Actual Variance FY % coll. % Budget Projection Variance $ 5,108,671 $ 6,090,734 $ 982,063 13,114,604 14, 990,406 1,875,802 100% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 920 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 92% 119% 105% 142% 87% 117% 126% 96% a) n/a b) 100% 90% 77% 27% C) 46% n/a 0% 209% 67% 104% 164% d) 184% 154% 48% n/a 80% 35% 104% 162% 42% n/a e) n/a n/a 105% $ 5,108,671 $6,090,734 $ 982,063 14,306,841 15,100,406 793,565 501,000 740,590 239,590 35,200 35,200 - 48,475 56,577 8,102 5,000 7,000 2,000 1,537,663 1,479,991 (57,672) - 120,000 120,000 5,000 5,000 - 91,000 91,000 4,180 4,180 150,000 100,000 (50,000) 1,000 1,000 - - 4,074 4,074 3,825 3,825 - 6,600 14,000 7,400 50,000 50,000 - 3,500 3,650 150 48,000 84,000 36,000 5,000 9,200 4,200 5,000 8,500 3,500 15,000 15,000 - - 275 275 16,000 16,000 - 5,000 5,000 - 200,000 225,000 25,000 28,333 50,000 21,667 3,533 3,533 - - 12,022 12,022 - 250 250 1,000 8,000 7,000 17, 076,150 18, 253, 274 1,177,124 459,250 710,590 251,340 32,267 30,784 (1,483) 44,435 56,577 12,142 4,583 6,304 1,721 1,409, 524 1,479,991 70,467 - 99,763 99,763 4,583 5,000 417 83,417 82,261 (1,156) 3,832 3,224 (608) 137,500 40,358 (97,142) 917 465 (452) - 4,074 4,074 3,506 - (3,506) 6,050 13,823 7,773 45,833 33,630 (12,203) 3,208 3,650 442 44,000 78,953 34,953 4,583 9,200 4,617 4,583 7,681 3,098 13,750 7,239 (6,511) - 251 251 14,667 12,820 (1,847) 4,583 1,747 (2,836) 183,333 208,619 25,286 25,972 45,849 19,877 3,239 1,495 (1,744) - 12,022 12,022 - 250 250 917 7,599 6,682 15,653,136 17,954,626 2,301,490 20,761,807 24,045,360 3,283,553 92% 108% EE E 22,184,821 24,344,008 2,159,187 2,221,735 2,115,298 106,437 92% 87% 2,423,711 2,325,222 98,489 755,420 686,982 68,438 92% 83% 824,095 748,995 75,100 586,517 518,941 67,576 92% 81% 639,837 583,028 56,809 9,630,983 8,639,348 991,635 92% 82% 10,506,527 9,704,527 802,000 262,719 251,967 10,752 92% 88% 286,602 275,402 11,200 176,848 161,931 14,917 92% 84% 192,925 175,525 17,400 850,866 702,159 148,707 92% 76% 928,217 892,066 36,151 2,766,927 2,620,514 146,413 92% 87% 3,018,466 2,868,366 150,100 181,464 147,411 34,053 92% 74% 197,961 174,090 23,870 579,568 557,857 21,711 92% 88% 632,256 609,156 23,100 33,631 33,631 0 92% 92% 36,689 36,689 - 183,333 200,000 (16,667) 92% 100% 200,000 200,000 - 2,014,408 - 2,014,408 92% 0% 2,197,536 2,197,536 20,244,419 16,636,038 3,608,381 22,084,821 18,593,066 3,491,755 91,667 100,000 (8,333) 92% 100% 100,000 100,000 - 20,336,086 16,736,038 3,600,047 92% 75% 22,184,821 18,693,066 3,491,755 425,721 7,309,322 6,883,601 - 5,650,941 5,650,941 Beginning Net Working Capital per Adopted Budget Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 c) Less than planned SAR mission Title III reimbursements. Funds will carryover to next year d) Change to new vendor resulting in revenue increase e) Accounting change for Shop with a Cop donations 4, 507, 352 Page 4 Fund 702 LED Rural Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % I. ....Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 2,936,523 $ 3,004,533 $ 68,010 100% 102 % $ 2,936,523 $ 3,004,533 $ 68,010 Revenues Tax Revenues - Current 6,735,781 7,538,451 802,670 92% 103% 7,348,125 7,578,451 230,326 Tax Revenues - Prior 235,583 353,199 117,616 92% 137% 257,000 373,199 116,199 Federal Grants & Reimb 11,000 11,377 377 92% 95% 12,000 12,000 - Federal Grants-BLM 22,917 22,758 (159) 92% n/a 25,000 25,000 US Forest Service 72,188 59,063 (13,126) 92% 75% 78,750 78,750 State Grant 184,224 117,534 (66,690) 92% 68°% 200,972 200,972 SB #1065 Court Assessment 55,000 43,916 (11,084) 92% 73% 60,000 60,000 Marine Board License Fee 130,471 73,663 (56,808) 92% 52% a) 142,332 142,332 - Bureau of Reclamation 22,720 22,720 920/. n/a b) - 26,000 26,000 Des Cty General Fund Grant 528,132 - (528,132) 92% o% c) 576,144 460,144 (116,000) Des Cty Transient Room Tax 1,901,035 1,901,035 (0) 92% 92% c) 2,073,856 2,189,856 116,000 Des Cty Tax/Fin Contract - 540 540 920/. - 540 540 City of Sisters 412,464 412,464 0 92% 92% 449,961 449,961 - Des Cty COD Contract 49,836 49,836 (1) 92% 92% 54,366 54,366 Des Cty Solid Waste Contr 49,836 49,836 (1) 92% 92% 54,366 54,366 Des Cty Clerk/Eleetion 1,833 595 (1,239) 920% 300% 2,000 2,000 School Districts 73,333 23,445 (49,888) 92% 29% d) 80,000 40,000 (40,000) Claims Reimbursement - 24,719 24,719 92% n/a - 24,719 24,719 Security & Traffic Reimb 4,583 680 (3,903) 92% 14% 5,000 5,000 - Seat Belt Program 11,000 7,245 (3,755) 92% 60% 12,000 12,000 - Miscellaneous 7,333 13,009 5,676 92% 163% 8,000 14,000 6,000 False Alarm Fees 1,833 1,500 (333) 92% 75% 2,000 2,000 - Restitution - 2,219 2,219 92% n/a - 5,000 5,000 Sheriff Fees 9,167 8,649 (518) 92% 86% 10,000 10,000 - Court Fines & Fees 105,417 125,138 19,721 92% 109% 115,000 140,000 25,000 Impound Fees 6,417 4,300 (2,117) 92% 61% 7,000 7,000 - Restitution - Street Crimes 458 - (458) 921% 0% 500 500 - Seizure/Forfeiture - 1,324 1,324 92% n/a - 1,324 1,324 Interest 9,167 21,229 12,062 92% 212% 10,000 23,000 13,000 Interest on Unsegregated 1,650 754 (896) 92% 42% 1,800 1,000 (800) Grants-Private - 7,000 7,000 92% n/a - 7,000 7,000 Donations - 13,755 13,755 92% n/a - 13,755 13,755 Sale of Equip & Material 5,500 11,601 6,101 92% 193% 6,000 15,000 9,000 Sale of Reportable Assets 18,333 66,490 48,157 92% 332% e) 20,000 66,490 46,490 Total Revenues 10,644,491 10,990,039 345,548 60% 95% 11,612,172 12,095,725 483,553 TOTAL RESOURCES 13,581,014 13,994,571 413,557 50% 96°% 14,548,695 15,100,258 561,563 REQUIREMENTS: Exp. Fund 255 Departments: Sheriffs Services 146,878 139,841 7,036 92% 87% 160,230 153,719 6,511 Auto/Comm 980,914 867,897 113,017 92% 81% 1,070,088 975,079 95,009 Investigations 1,589,700 1,315,878 273,822 92% 76% 1,734,218 1,538,664 195,554 Patrol 7,337,645 7,188,858 148,787 92% 90% 8,004,704 7,862,704 142,000 Records 660,651 635,441 25,210 92% 88% 720,710 694,610 26,100 Special Services 373,032 307,836 65,195 92% 76% 406,944 391,095 15,849 Training 115,779 94,052 21,727 92% 74% 126,304 111,075 15,230 Non Dept - ISF Charges 33,497 33,497 - 92%6 92% 36,542 36,542 - Contingency 2,006,541 - 2,006,541 92% 0% 2,188,954 - 2,188,954 ~tota4tofFutad.255 13,244,637. 10,583,301 -2,6611,3.36. 14,448,695 11.763,488 2,685,207 Transfer to Reserve Fund (704) 91,667 100,000 (8,333) 92% 100% 100,000 100,000 - Total Requirements 13,336,304 10,683,301 2,653,003 92% 73% 14,548,695 11,863,488 2,685,207 Net 244,710 3,311,270 3,066,560 - 3,236,770 3,236,770 Beginning Net Working Capital per Adopted Budget 2,859,915 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services a) Reimbursement requested semiannually in January and June b) BUR patrol contract signed after budget adopted c) Received annually in June. Less will be received from General Fund due to additional resources available from Transient Room Tax Page 5 d) Reimbursement for SRO deputies will be less than planned from the Bend La Pine School District e) Proceeds for sale of used patrol vehicles higher than planned PUBLIC HEALTH Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 Revenues Medicare Reimbursement 550 770 220 92% 128% 600 800 200 State Grant 2,484,299 2,395,594 (88,705) 92% 88% 2,710,144 2,729,165 19,021 Child Dev & Rehab Center 22,556 25,514 2,958 92% 104% 24,607 30,759 6,152 State Miscellaneous 206,093 123,172 (82,921) 92% 55% a)b) 224,829 127,000 (97,829) OMAP 480,196 548,857 68,661 92% 105% 523,850 582,000 58,150 Title 19 - 352 352 92% n/a - 500 500 Family Planning Exp Proj 476,667 448,039 (28,628) 92% 86% 520,000 532,000 12,000 Local Grants 41,250 104,395 63,145 92% 232% 45,000 118,448 73,448 Water Program-Base Fee 38,500 28,158 (10,342) 92% 67% a) 42,000 38,000 (4,000) Contract Payments - 51,092 51,092 92% n/a - 51,092 51,092 Water Program-Field Work 51,166 28,295 (22,871) 92% 51% a) 55,817 55,817 - H20 Sys Insp-Priv Wells 183 - (183) 92% 0% 200 200 - Miscellaneous - 4,529 4,529 92% n/a - 7,000 7,000 Patient Insurance Fees 124,098 166,218 42,120 92% 123% 135,380 170,000 34,620 Health Dept/Patient Fees 108,873 94,345 (14,528) 92% 79% 118,770 110,000 (8,770) Vital Records-Birth 28,050 34,545 6,495 92% 113% 30,600 35,000 4,400 Vital Records-Death 91,667 93,185 1,518 92% 93% 100,000 100,000 - Environmental Health 645,654 737,292 91,638 92% 105% C) 704,350 745,000 40,650 NSF Fee - 60 60 92% n/a - 60 60 Interest on Investments 11,000 9,457 (1,543) 92% 79% 12,000 10,000 (2,000) Donations 23,861 10,052 (13,809) 92% 39% 26,030 15,000 (11,030) Interfund Contract 181,855 125,703 (56,152) 92% 63% a) 198,387 160,000 (38,387) Administrative Fee 13,801 13,801 - 92% 92% 15,056 15,056 - Total Revenues 5,030,319 5,043,425 13,106 92% 92% 5,487,620 5,632,897 145,277 Transfers In-General Fund 2,124,617 2,124,617 - 92% 92% 2,317,765 2,317,765 - Transfers In-PH Res Fund 27,500 22,500 (5,000) 92% 75% 30,000 30,000 - Transfers In-Gen. Fund Other 59,675 48,825 (10,850) 92% 75% 65,100 65,100 - TOTAL RESOURCES 8,839,029 8,941,496 102,467 92% 94% 9,497,403 9,747,891 250,488 REQUIREMENTS: Exp. Expenditures Personal Services 5,674,838 5,593,893 80,945 92% 90% 6,190,732 6,103,000 87,732 Materials and Services 1,923,803 1,683,234 240,569 92% 80% 2,098,694 1,904,960 193,734 Capital Outlay 120,542 66,591 53,951 92% 51% 131,500 89,000 42,500 Transfers Out 262,167 214,500 47,667 92% 75% 286,000 286,000 - Contingency 724,604 - 724,604 92% n/a 790,477 - 790,477 TOTAL REQUIREMENTS 8,705,954 7,558,218 1,147,736 92% 80% 9,497,403 8,382,960 1,114,443 NET (Resources - Requirements) 133,075 1,383,278 1,250,203 - 1,364,931 1,364,931 Beginning Net Working Capital per Adopted Budget 1,336,051 a) Received quarterly, in arrears b) Elimination of the State self sufficiency program c) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Page 6 Budget=$110,000). These are due annually and collected primarily in December and January BEHAVIORAL HEALTH Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Bud et Proiection variance RESOURCES: Beg. Net Working Capital $ 3,268,759 $ 3,108,163 $ (160,596) 100% 95% $ 3,268,759 $ 3,108,163 $ (160,596) Revenues Marriage Licenses 5,042 4,970 (72) 92% 90% 5,500 5,600 100 Divorce Filing Fees 121,917 133,924 12,007 92% 101% 133,000 150,000 17,000 Domestic Partnership Fee 92 65 (27) 92% 65% 100 100 - Federal Grants 253,593 217,488 (36,105) 92% 79% 276,647 276,647 - State Grants 6,383,852 7,108,851 724,999 92% 102% a) 6,964,202 7,566,736 602,534 State Miscellaneous 113,825 47,987 (65,838) 92% 39% b)c) 124,173 61,860 (62,313) ABHA - 164,728 164,728 92% n/a d) - 170,000 170,000 Title 19 258,772 184,613 (74,159) 92% 65% 282,297 202,300 (79,997) Liquor Revenue 96,250 115,758 19,508 92% 110% 105,000 141,500 36,500 School Districts 69,300 80,300 11,000 92% 106% 75,600 80,300 4,700 Miscellaneous 12,833 7,322 (5,511) 92% 52% 14,000 14,000 - Patient Insurance Fees 104,225 182,497 78,272 92% 161% 113,700 192,000 78,300 Patient Fees 1,656 946 (710) 92% 52% 1,807 1,150 (657) Interest on Investments 22,917 23,282 365 92% 93% 25,000 26,700 1,700 Rentals 12,008 13,125 1,117 92% 100% b) 13,100 14,000 900 Donations - 108 108 92% n/a - 200 200 Administrative Fee 4,060,548 4,014,675 (45,873) 92% 91% 4,429,689 4,429,689 - Sheriff 18,333 - (18,333) 92% 0% e) 20,000 - (20,000) Interfund Contract-Gen Fund 116,417 109,686 (6,731) 92% 86% b) 127,000 127,000 - Comm. on Children & Fam - 725 725 92% n/a - 725 725 Total Revenues 11,651,580 12,411,050 759,470 92% 98% 12,710,815 13,460,507 749,692 Transfers In-General Fund 1,158,223 1,158,223 - 92% 92% 1,263,515 1,263,515 - Transfers In-OHP-CDO 248,785 363,073 114,287 92% 134% 271,402 396,077 124,675 Transfers In-Acute Care Svcs 231,473 231,473 - 92% 92% 252,515 252,515 - Transfers In-ABHA 275,791 290,605 14,814 92% 97% f) 300,863 387,473 86,610 TOTAL RESOURCES 16,834,611 17,562,587 727,975 92% 97% 18,067,869 18,868,250 800,381 REQUIREMENTS: Exp. Expenditures Personal Services 9,559,171 8,743,723 815,448 92% 84% 10,428,186 9,486,500 941,686 Materials and Services 5,321,937 5,150,310 171,627 92% 89% 5,805,749 5,350,000 455,749 Capital Outlay 357,500 111,406 246,094 92% 29% 390,000 390,000 - Transfers Out 262,167 214,500 47,667 92% 75% 286,000 286,000 - Contingency 1,061,440 - 1,061,440 92% n/a 1,157,934 - 1,157,934 TOTAL REQUIREMENTS 16,562,215 14,219,939 2,342,276 92% 79% 18,067,869 15,512,500 2,555,369 NET (Resources - Requirements) 272,396 3,342,648 3,070,251 - 3,355,750 3,355,750 Beginning Net Working Capital per Adopted Budget 3,320,96$ a) Department of Human Services Grant projected at amended contract amount b) Received quarterly, in arrears c) Elimination of State contract for Temporary Assistance for Needy Families (TANF) program d) Revenue for Adult Mental Health Initiative clients, not included in original budget e) Funding for Mental Health Court from the Sheriffs Department eliminated f) Transfer made quarterly Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Eleven Months Ended May 31, 2012 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 57% $ 229,822 $ 131,776 (98,046) 104% 24,350 27,500 3,150 172% a) 1,000 1,900 900 94% 166,700 171,800 5,100 75% b) 1,200,880 1,075,000 (125,880) 82% b) 259,150 235,000 (24,150) 56% c) 160,200 115,000 (45,200) 98% 280,400 301,000 20,600 73% b) 674,900 565,000 (109,900) 86% d) 253,726 240,000 13,726 2,769,530 2,373,531 (395,999) 92% 79% 3,021,306 2,732,200 (289,106) Trans In-GF 668,825 677,159 8,334 92% 93% 729,625 849,625 120,000 Trans In-GF for Lng Rng Ping 454,080 454,080 - 92% 92% 495,360 495,360 - Trans In-Other 92 - 92 92% 0% 100 - (100) TOTAL RESOURCES 4,122,349 3,636,546 (485,803) 92% 81% 4,476,213 4,208,961 (267,252) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Pgm Planning-Current Planning-Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS Exp. 1,294,167 1,294,350 (183) 92% 92% 1,411,818 1,403,590 117,109 111,833 5,276 92% 88% 127,755 123,990 187,523 191,864 (4,341) 92% 94% 204,570 210,679 515,196 507,980 7,216 92% 90% 562,032 551,447 239,663 196,897 42,766 92% 75% 261,450 230,040 151,882 155,957 (4,075) 92% 94% e) 165,689 171,713 131,182 138,816 (7,634) 92% 97% f) 143,108 144,862 567,419 543,543 23,876 92% 88% 619,002 608,794 438,906 413,076 25,830 92% 86% d) 478,806 452,033 159,395 160,242 (847) 92% 92% 173,885 173,885 300,757 - 300,757 92% n/a 328,098 - 4,103,199 3,714,559 388,640 92% 83% NET (Resources - Requirements) 19,150 (78,012 97,162) Beginning Net Working Capital per Adopted Budget Revenues Expenditures Net from Operations 2,373,531 3,714,559 (1,341,028) a) GIS revenue is sporadic based on the frequency of customer requests b) Fall activity less than anticipated c) Contract payments from Redmond are currently on hold pending finalization of a new contract d) As Tumalo area wetland inventory grant will not be received, budgeted expenses will not occur e) Year to date actual includes payout to retired employee f) Extra Help expenditures occur primarily in the summer months Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 229,822 131,776 $ (98,046) 100% 22,321 25,226 2,905 92% 917 1,721 804 92% 152,808 157,456 4,648 92% 1,100,807 897,403 (203,404) 92% 237,554 211,707 (25,847) 92% 146,850 89,869 (56,981) 92% 257,033 275,918 18,885 92% 618,658 495,025 (123,633) 92% 232,582 219,205 13,377 92% 8,228 3,765 (6,109) 10,585 31,410 (6,024) (1,754) 10,208 26,773 328,098 4,476,213 4,071,033 405,180 - 137,928 137,928 10,000 3,021,306 2,732,200 (289,106) 4,476,213 4,071,033 405,180 (1,454,907) (1,338,833) 116,074 Page 8 ROAD Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget Actual Variance FY % Coil. % _ Budget Projection Variance RESOURCES: Beg. Net Working Capital $3,417,158 $ 3,417,158 $ 0 100% 100% $ 3,417,158 $ 3,417,158 $ 0 Revenues System Development Charge - 1,617 1,617 92% n/a - 1,617 1,617 Federal Reimbursements 550,000 600,000 50,000 92% 100% a) 600,000 600,000 - Federal Grant(ARRA) 18,333 20,000 1,667 92% 1o0% b) 20,000 20,000 - Mineral Lease Royalties 36,667 143,712 107,045 92% 359% c) 40,000 143,712 103,712 Forest Receipts 1,201,899 1,322,661 120,762 92% 101% d) 1,311,162 1,322,661 11,499 State Miscellaneous 458,371 500,041 41,670 92% 100% e) 500,041 1,355,185 855,144 Motor Vehicle Revenue 10,395,000 9,514,075 (880,925) 92% 84% f) 11,340,000 10,460,748 (879,252) City of Bend 252,083 29,941 (222,142) 92% 11% g) 275,000 29,941 (245,059) City of Redmond 320,833 4,248 (316,585) 92% 1% g) 350,000 220,000 (130,000) City of Sisters 9,167 1,135 (8,032) 92% 11% g) 10,000 1,135 (8,865) City of La Pine 9,167 (9,167) 92% o% g) 10,000 - (10,000) Admin Recovery (SDC) 917 2,259 1,342 92% 226% 1,000 2,259 1,259 Miscellaneous 18,333 35,859 17,526 92% 179% 20,000 40,000 20,000 Road Vacations 917 1,500 583 92% 150% 1,000 2,000 1,000 Interest on Investments 18,333 18,513 180 92% 93% 20,000 19,731 (269) Parking Fees 132 - (132) 92% 0% 144 144 Interfund Contract 669,167 - (669,167) 92% 0%o h) 730,000 746,579 16,579 Equipment Repairs 183,333 244,414 61,081 92% 122% 200,000 250,000 50,000 Vehicle Repairs 82,500 - (82,500) 92% 0% 90,000 78,800 (11,200) LID Construction 9,167 - (9,167) 92% 0% h) 10,000 - (10,000) Vegetation Management 65,542 2,056 (63,486) 92% 3% h) 71,500 40,175 (31,325) Forester 22,917 4,486 (18,431) 92% 18% h) 25,000 29,000 4,000 Car Washes 3,208 4,068 860 92% 116% 3,500 5,000 1,500 Car Rental - 893 893 92% n1a - 1,000 1,000 Sale of Equip & Material 580,250 790,349 210,099 92% 125% 633,000 858,839 225,839 Total Revenues 14,906,236 13,241,826 (1,664,410) 92% 81% 16,261,347 16,228,527 (32,820) Trans In - Solid Waste 261,959 214,330 (47,629) 92% 75% 285,773 285,773 Trans In - Transp SDC 229,167 187,500 (41,667) 92% 75% 250,000 250,000 Trans In-Road Imp Res 11,000 - (11,000) 92% 0% 12,000 (12,000) W TOTAL RESOURCES 18,825,520 17,060,814 (1,723,039) 92%, 93% 20,226,278 20,181,458 (44,820) REQUIREMENTS: Exp. Expenditures Personal Services 5,147,379 4,905,451 241,928 92% 87% 5,615,323 5,348,551 266,772 Materials and Services 9,858,853 7,665,944 2,192,909 92% 71%n i) 10,755,112 9,769,205 985,907 Capital Outlay 1,133,633 75,288 1,058,345 92% 6% j) 1,236,691 85,936 1,150,755 Transfers Out 550,000 600,000 (50,000) 92% 100% 600,000 600,000 - Contingency 1,850,889 - 1,850,889 92% n/a 2,019,152 - 2,019,152 TOTAL REQUIREMENTS 18,540,754 13,246,683 5,294,071 92% 65% 20,226,278 15,803,692 4,422,586 NET (Resources - Requirements) 284,766 3,814,131 3,571,032 - 4,377,766 4,377,766 Beginning Net Working Capital per Adopted Budget 4,719,551 a) Revenue received in November at completion of the Cascade Lakes chip seal project b) Payment received in December c) Mineral leases higher than anticipated d) Received annually in January e) Annual payment received in August, plus payments from FY 2010 & 2011 previously reserved for 19th St expected to be received in FY 2012 f) Revenues trending less than estimates provided by ODOT g) Billed upon completion of work h) Payments to be received in June 2012 from other Road Department funds i) Expenditures are seasonal and higher during summer. YTD includes $2.5 million paid to Knife River on the Page 9 Full Depth Reclamation Project in South County j) Budget includes $1,096,691 for future projects that will not be expended in FY 2012 ADULT PAROLE & PROBATION Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 560,000 $ 634,125 $ 74,125 100% 113% $ 560,000 $ 634,125 $ 74,125 Revenues DOC Measure 57 199,238 219,240 20,002 92% 101% a) 217,350 219,240 1,890 State Miscellaneous 3,943 4,301 358 92% 100% a) 4,301 4,301 - Alternate Incarceration 28,342 - (28,342) 92% 0% b) 30,918 (30,918) State Subsidy 11,917 13,826 1,909 92% 106% c) 13,000 13,826 826 SB 1145 2,617,686 2,748,556 130,870 92% 96% c) 2,855,659 2,748,953 (106,706) Probation Work Crew Fees 22,000 18,420 (3,580) 92% 77% 24,000 20,000 (4,000) Miscellaneous 3,758 2,600 (1,158) 92% 63% 4,100 3,000 (1,100) Electronic Monitoring Fee 155,833 122,993 (32,840) 92% 72% 170,000 125,446 (44,554) Probation Superv. Fees 183,333 171,561 (11,772) 92% 86% 200,000 182,674 (17,326) Interest on Investments 8,250 5,716 (2,534) 92% 64% 9,000 7,000 (2,000) Interfund - Sheriff 45,833 45,833 - 92% 92% 50,000 50,000 - Crime Prevention Grant 45,833 37,500 (8,333) 92% 75% d) 50,000 50,000 - CFC-Domestic Violence 68,596 56,124 „ 12,472) 92% 75% d) 74,832 74,832 - Total Revenues 3,394,562 3,446,670 52,108 92% 93% 3,703,160 3,499,272 (203,888) Transfers In-General Fund 310,101 310,101 - 92% 92% 338,292 338,292 - TOTAL RESOURCES 4,264,663 4,390,896 126,233 92% 95% 4,601,452 4,471,689 (129,763) REQUIREMENTS: Exp. Rio Expenditures Personal Services 2,904,631 2,772,598 132,033 92% 87% e) 3,168,688 3,084,689 83,999 Materials and Services 812,983 660,436 152,547 92% 74% f) 886,890 800,000 86,890 Capital Outlay 92 - 92 92% 0% 100 - 100 Transfers Out 26,400 21,600 4,800 92% 75% 28,800 28,800 - Contingency 473,893 - 473,893 92% n/a 516,974 - 516,974 TOTAL REQUIREMENTS 4,217,999 3,454,634 763,365 92% 75% 4,601,452 3,913,489 687,963 NET (Resources - Requirements) 46,664 936,262 889,598 - 558,200 558,200 Beginning Net Working Capit al per Adopted Budget 570,000 a) Annual allocation received in January b) AIP funds are being spent down from previous year; we do not anticipate any new funds this year c) Payments received from State at beginning of quarter d) Interfund grant received end of each quarter e) Less than planned expenditures due to open positions f) Less than planned expenditures due to Measure 57 tax amount Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Eleven Months Ended May 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart /R-S-G OCCF Grant Program Fees Charges for Svcs-Mist Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $ 467,111 $ 556,143 $ 89,032 100% 119% $ 467,111 $ 556,143 $ 89,032 274,531 256,184 (18,347) 36,052 35,888 (164) 87,083 43,050 (44,033) 236,484 175,941 (60,543) 22,458 79,801 57,343 285,852 258,203 (27,649) 499,769 502,290 2,521 - 3,813 3,813 7,333 1,880 (5,453) 71,500 80,355 8,855 4,583 4,116 (467) - 71 71 110,802 316,041 205,239 1,636,447 1,757,633 121,186 Trans from General Fund 250,217 250,217 - 92% 92% 272,960 272,960 - Total Transfers In 250,217 250,217 - 92% 92% 272,960 272,960 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 2,353,775 2,563,993 210,218 92% 102% 92% 86% a) 299,488 305,416 5,928 92% 91% a)b) 39,329 39,534 205 92% 45% a)c) 95,000 85,000 (10,000) 92% 68% a)b) 257,982 196,898 (61,084) 92% 326% d) 24,500 79,801 55,301 92% 83% a)b) 311,838 258,203 (53,635) 92% 92% a)b) 545,203 509,579 (35,624) 92% n/a e) - 5,000 5,000 92% 24% f) 8,000 3,000 (5,000) 92% 103% g) 78,000 86,735 8,735 92% 82% 5,000 5,000 - 92% n/a e) - 300 300 92% 261% h) 120,875 320,875 200,000 92% 98% 1,785,215 1,895,341 110,126 Exp. 2,525,286 2,724,444 199,158 554,692 542,974 11,718 92% 90% i) 605,119 589,664 15,455 1,546,397 1,210,931 335,466 92% 72% j) 1,686,979 1,631,476 55,503 92 - 92 92% 0% 100 100 - 213,664 - 213,664 92% n/a 233,088 233,088 2,314,845 1,753,905 560,940 92% 69% NET (Resources - Requirements) 38,930 810,088 771,158 Beginning Net Working Capital per Adopted Budget 2,525,286 2,221,240 304,046 503,204 503,204 511,994 a) Grant payments received normally within 60 days after the end of each quarter b) FY 2012 and FY 2013 Intergovernmental Agreement finalized funding levels from OCCF. Community Schools grant included in year-end projection at $9,484. Additional Casey Foundation grant of $11,214 received c) Medicaid revenues reduced due to lower projections d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from DHS not budgeted for $48,122 e) Youth Suicide Prevention training donations & fees expected to be received f) Charges for services lower than projected g) Court fees projected to be higher than estimated in the original budget h) Two additional grants of $55,000 & $180,000 awarded. $55,000 received in last fiscal year, $20,000 grant from OHP expected i) Personnel projection increased due to TML sell back, overtime,and increased hours for EC Specialist j) Sub-grant expenditures paid quarterly. Federal grant amount increased and SPF-SIG grant expenditures added Page 11 $21,214 in expenditures added, remaining $10,000 for staff expenses SOLID WASTE Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,092,508 $ 1,141,691 $ 49,183 100% 105% $1,092,508 $ 1,141,691 $ 49,183 Revenues Miscellaneous 20,167 17,321 (2,846) 92% 79% 22,000 20,000 (2,000) Franchise 3% Fees 183,333 207,462 24,129 92% 104% 200,000 210,000 10,000 Commercial Disp. Fees 788,333 781,414 (6,919) 92% 91% 860,000 860,000 - Private Disposal Fees 1,204,500 1,179,102 (25,398) 92% 90% 1,314,000 1,314,000 - Franchise Disposal Fees 3,666,667 3,540,614 (126,053) 92% 89% 4,000,000 3,883,875 (116,125) Yard Debris 66,917 79,401 12,484 92% 109% a) 73,000 90,000 17,000 Special Waste 22,917 5,318 (17,599) 92% 21% b) 25,000 10,000 (15,000) Interest 6,875 9,805 2,930 92% 131% 7,500 10,500 3,000 Leases 1 9,494 9,493 92% n/a c) 1 10,394 10,393 Donations - 2,880 2,880 92% n/a d) - 2,880 2,880 Sale of Reportable Assets - 16,494 16,494 92% n/a e) - 16,494 16,494 Recyclables 27,500 71,679 44,179 92% 239% f) 30,000 77,000 47,000 Bond Issuance 4,614,775 5,044,437 429,662 92% 100% g) 5,034,300 5,044,437 10,137 Premium 145,231 148,507 3,276 92% 94% g) 158,434 148,507 (9,927) Total Revenues 10,747,216 11,113,928 366,712 92% 95% 11,724,235 11,698,087 (26,148) TOTAL RESOURCES 11,839,724 12,255,619 415,895 92% 96% 12,816,743 12,839,778 23,035 REQUIREMENTS Exp. Expenditures Personal Services 1,532,298 1,473,790 58,508 92% 88% 1,671,598 1,610,000 61,598 Materials and Services 2,829,266 2,422,410 406,856 92% 78% 3,086,472 2,919,945 166,527 Debt Service 5,569,251 5,992,804 (423,553) 92% 99% g) 6,075,547 6,075,547 - Capital Outlay 185,167 160,400 24,767 92% 79% 202,000 174,000 28,000 Transfers Out-Road 261,959 214,330 47,629 92% 75% 285,773 285,773 - Trans Out-Post Closure 366,667 200,000 166,667 92% 50% h) 400,000 400,000 - Trans Out-Equip Reserve 229,167 250,000 (20,833) 92% 100% 250,000 250,000 - Trans Out-Capital Res 388,667 212,000 176,667 92% 50% h) 424,000 424,000 - Contingency 386,240 - 386,240 92% n/a 421,353 421,353 TOTAL REQUIREMENTS 11,748,682 10,925,734 822,948 92% 85% 12,816,743 12,139,265 677,478 NET (Resources - Requirements) 91,042 1,329,885 1,238,843 - 700,513 700,513 Beginning Net Working Capital per Adopted Budget 700,513 a) Seasonal item-Fall and Spring b) Dependent on special clean-ups such as asbestos and contaminated soil c) Revenue from rent on Rickard Road property, not included in original budget d) Incentive for energy efficient lighting upgrade in Knott Transfer Station building e) Sold glass crusher at auction f) Recycling markets are higher than expected. Often it can be seasonal Page 12 g) Refunding of FF&C 2003 debt h) Transfers will be completed in June RISK MANAGEMENT Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget] Actual Variance % of FY % Coll. Budget Pro'ection Variance RESOURCES: Beginning Net Working Capital $2,100,000 $2,039,937 ($60,063) Revenues Inter-fund Charges: General Liability 229,950 229,951 0 Property Damage 285,664 285,664 0 Vehicle 163,451 163,451 (0) Workers' Compensation 1,351,115 1,351,115 0 Unemployment 231,397 231,693 296 Claims Reimb-Workers' Compensation 4,583 548 (4,035) Claims Reimb-Gen Liab/Property 18,333 64,807 46,474 Process Fee-Events/Parades 1,375 1,980 605 Miscellaneous 46 - (46) Skid Car Training 16,500 12,950 (3,550) Interest on Investments 13,750 12,732 (1,018) Other Interest 46 - (46) TOTAL REVENUES 2,316,210 2,354,890 38,679 Transfers In-General Fund 183,333 200,000 16,667 TOTAL RESOURCES 4,599,544 4,594,827 (4,717) Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit 121,514 Defense 201,605 Professional Service 5,677 Insurance 131,591 Repair / Replacement 5,517 Total General Liability 435,417 465,905 (30,489) PROPERTY DAMAGE Insurance 116,418 Repair / Replacement 69,277 Total Property Damage 275,000 185,695 89,305 VEHICLE Professional Service 157 Insurance 376 Loss Prevention 14,194 Repair / Replacement 81,908 Total Vehicle 91,667 96,635 (4,969) WORKERS' COMPENSATION Settlement / Benefit 886,591 Professional Service 5,000 Insurance 105,997 Loss Prevention 49,182 Miscellaneous 32,959 Total Workers' Compensation 1,100,000 1,079,729 20,271 UNEMPLOYMENT - Settlement/Benefits 229,167 184,953 44,213 Total Direct Insurance Costs 2,131,250 2,012,918 118,332 Insurance Administration: Personal Services 269,827 252,389 17,438 Materials & Service 155,306 125,985 29,321 Capital Outlay 92 - 92 Total Insurance Administration 425,225 378,374 46,851 Transfers Out 6,600 5,400 1,200 TOTAL REQUIREMENTS 2,563,075 2,396,692 166,383 NET 2,036,469 2,198,135 161,666 Beginning Net Working Capital per Adopted Budget * Contingency is $2,030,693. 100% 97% $2,100,000 $2,039,937 ($60,063) 92% 92% 250,855 250,855 92% 92% 311,633 311,633 92% 92% 178,310 178,310 92% 92% 1,473,944 1,473,944 92% 92% 252,433 252,433 92% 11% 5,000 1,000 (4,000) 92% 324% 20,000 70,000 50,000 92% 132% 1,500 2,000 500 92% 0% 50 50 92% 72% 18,000 14,000 (4,000) 92% 85% 15,000 15,000 - 92% 0% 50 50 - 92% 93% 2,526,775 2,569,275 42,500 92% 100% 200,000 200,000 - 92% 95% 4,826,775 4,809,212 (17,563) Exp. 92% 98% 475,000 475,000 - 92% 62% 300,000 200,000 100,000 92% 97% 100,000 100,000 - 92% 90% 1,200,000 1,159,729 40,271 92% 74% 250,000 184,953 65,047 92% 87% 2,325,000 2,119,682 205,318 92% 86% 92% 74% 92% 0% 92% 82% 92% 75% 92% 86% 294,357 294,357 - 169,425 169,425 - 100 - 100 463,882 463,782 100 7,200 7,200 - 2,796,082 2,590,664 205,418 * 2,030,693 2,218,548 187,855 2,000,000 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Revised Year End Budget Actual Variance % of FY % Call. Budget Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes - Current 5,485,125 6,220,939 735,814 92% 104% 5,983,773 6,260,939 277,166 Property Taxes - Prior 183,333 274,558 91,225 92% 137% 200,000 284,558 84,558 Federal Grants - 184,578 184,578 92% n/a - 203,958 203,958 State Reimbursement 49,500 26,500 (23,000) 92% 49% a) 54,000 35,995 (18,005) Telephone User Tax 687,500 579,221 (108,279) 92% 77% 750,000 750,000 - Grant - Sunriver Serv Dist - 22,500 22,500 92% n/a - 22,500 22,500 Data Network Reimb. 24,933 34,698 9,765 92% 128% b) 27,200 34,698 7,498 Jefferson County 32,083 28,338 (3,745) 92% 81% 35,000 35,000 - User Fee 47,667 6,469 (41,198) 92% 12% c) 52,000 54,127 2,127 Police RMS User Fees 182,417 131,687 (50,730) 92% 66% d) 199,000 276,509 77,509 Contract Payments 29,333 33,061 3,728 92% 103% b) 32,000 33,061 1,061 Miscellaneous 8,250, 10,232 1,982 92% 114% 9,000 11,750 2,750 Contracted Training - 2,369 2,369 92% n/a e) - 4,745 4,745 Interest 32,083 50,413 18,330 92% 144% 35,000 55,000 20,000 Interest on Unsegregated Tax 733 621 (112) 92% 78% 800 800 - Donations - 750 750 92% n/a - 750 750 Total Revenues 6,762,957 7,606,933 843,976 92% 103% 7,377,773 8,064,390 686,617 TOTAL RESOURCES 13,162,957 15,166,571 2,003,614 92% 110% 13,777,773 15,624,029 1,846,256 REQUIREMENTS: % Exp. Expenditures Personal Services 3,887,431 3,496,003 391,428 92% 82% 4,240,834 3,800,000 440,834 Materials and Services 1,766,743 1,637,516 129,227 92% 85% 1,927,356 1,927,356 - Capital Outlay 1,040,068 556,336 483,732 92% 49% f) 1,134,620 1,134,620 - Transfers Out 458,333 500,000 (41,667) 92% 100% g) 500,000 500,000 - Contingency 5,477,049 - 5,477,049 92% n/a 5,974,963 - 5,974,963 TOTAL REQUIREMENTS 12,629,624 6,189,856 6,439,768 92% 45% 13,777,773 7,361,976 6,415,797 NET (Resources - Requirements) 533,333 8,976,715 8,443,382 - 8,262,053 8,262,053 Beginning Net Working Capital per Adopted Budget 8,000,000 a) GIS/MSAG monthly billings to Oregon Emergency Management--Projection revised to $35,995 to reflect outstanding receipts for Apr-Jun b) Invoiced annually; all expected revenues received c) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch invoiced annually FY 2012 = $47,658 d) City of Bend and Sunriver Service District billed and $77,509 payment expected e) Training occurred first of June - Total receipts of $2,376 are outstanding f) Projects pending with partnering agencies g) Entire amount budgeted transferred to reserve fund in September Page 14 Health Benefits Trust Statement of Financial Operating Data Eleven Months Ended May 31, 2012 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Addl Prem Employee Prem Contribution COIC Retiree / COBRA Co-Pay Fees for Clinic Services Federal Payment (ERRP) Prescription Rebates Claims Reimbursements Vending Machines (Wellness Rebate) Interest Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials 6 Services Claims Paid-Medical/Rx Claims Paid-Dental/Vision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Other - Administration Other - Wellness Admin & Wellness Deschutes On-site Clinic Healthstat Medications/Drugs/Vacc Medical Supplies Equipment Miscellaneous Total DOC Deschutes On-site Pharmacy Remodeling Costs Total Pharmacy Capital Outlay Contingency Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $15,500,000 $15,829,888 $ 329,888 100% 0 $15,500,000 $15,829,888 329,888 11,014,402 11,064,143 49,741 92% 92% 12,015,711 12,070,000 54,289 45,833 28,716 (17,118) 92% 57% 50,000 31,000 (19,000) 577,500 549,690 (27,810) 92% 87/0 630,000 595,000 (35,000) 1,155,000 1,201,514 46,514 92% 95% 1,260,000 1,300,000 40,000 458,333 765,797 307,464 92% 153% 500,000 800,000 300,000 - 200 200 92% n/a - 200 200 150,431 150,431 92% n/a ' 150,431 150,431 107,502 107,502 92% n/a 107,502 107,502 36,297 36,297 92% n/a 36,297 36,297 - 51 51 92% n/a 51 51 73,333 93,184 19,851 92% 116% 80,000 100,000 20,000 13,324,402 13,997,526 673,124 92% 96% 14,535,711 15,190,482 654,771 28,824,402 29,827,414 1,003,012 92% 103% 30,035,711 31,020,370 984,659 Exp. 138,617 130,802 7,815 92% 86% 151,218 151,218 11,434,761 11,832,520 (397,759) 92% 95% a) 12,474,284 13,063,051 (588,767) 1,708,642 1,750,998 (42,356) 92% 94% a) 1,863,974 1,933,394 (69,421) - (92,133) 92,133 92% n/a - (92,133) 92,133 320,833 325,481 (4,648) 92% 93% 350,000 350,000 - 137,500 155,263 (17,763) 92% 104% 150,000 155,263 (5,263) 293,333 291,931 1,402 92% 91% 320,000 320,000 45,833 44,799 1,034 92% 90% 50,000 50,000 50,417 47,294 3,123 92% 86% 55,000 55,000 57,125 101,403 (44,278) 92% 163% 62,318 95,000 (32,682) 72,274 24,429 47,845 92% 31% 78,844 78,844 14,259,335 14,612,787 (353,453) 92% 94% 15,555,638 16,159,637 (603,999) 877,433 564,729 312,705 92% 59% 957,200 857,200 100,000 297,917 127,241 170,676 92% 39% 325,000 225,000 100,000 2,750 22,481 (19,731) 92% 749% 3,000 30,000 (27,000) 3,667 150 3,517 92% 4% 4,000 1,000 3,000 4,996 10,030 (5,034) 92% 184% 5,450 10,000 4,550 1,186,763 724,631 462,132 92% 56% 1,294,650 1,123,200 171,450 - 128,373 (128,373) 92% n/a - 128,373 _ 12( 8,373) - 128,373 (128,373) 92% n/a - 128,373 (128,373) 183 - 183 92% n/a 200 - 200 12,086,454 - 12,086,454 92% n/a 13,185,223 - 13,185,223 TOTAL EXPENDIREQUIREMNTS 27,671,352 15,465,791 12,074,759 92% 51% 30,035,711 17,411,210 12,624,501 NET (Resources - Requirements) 1,153,050 14,361,623 13,077,771 13,609,160 13,609,160 Beginning Net Working Capital per Adopted Budget 3, 00,000 " Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible. a) Projection based on annualizing 48 weeks of claims paid. YTD actual is $281,071 per week Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Eleven Months Ended May 31, 2012 4 Year to Date Year End Budget (11/12 = of annual Actual Variance F % Coll. Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 75,000 $ (40,601) $ (115,601) 100% -54% $ 75,000 $ (40,601) $ (115,601) Receipts: Special Events Revenues 554,583 493,965 (60,619) 92% 82% 605,000 543,965 (61,035) Interest 1,375 155 (1,220) 92% 10% 1,500 155 (1,345) Storage 53,167 37,072 (16,095) 92% 64% 58,000 37,072 (20,928) Camping at F & E 5,500 19,240 13,740 92% 321% 6,000 19,240 13,240 Horse Stall Rental 27,500 21,714 (5,787) 92% 72% 30,000 30,714 714 Concession % - Food 201,667 135,031 (66,635) 92% 61% 220,000 138,031 (81,969) Rights (Signage, etc.) 102,667 124,000 21,333 92% 111% 112,000 130,000 18,000 Grants - - - 92% n/a - 33,424 33,424 Interfund Contract 43,083 46,833 3,750 92% 100% 47,000 47,000 - Miscellaneous 6,240 10,266 4,027 92% n/a 6,807 10,416 3,609 Total Receipts 995,781 888,276 (107,505) 92% 82% 1,086,307 990,018 (96,289) Transfers In General Fund (001) 155,833 305,837 - 92% 180% 170,000 370,000 200,000 Room Tax (160) 23,599 23,595 - 92% 92% 25,744 25,744 - Welcome Center (170) 75,900 75,900 - 92% 92% 82,800 82,800 - Annual County Fair (619) 201,667 220,000 18,333 92% 100% 220,000 220,000 - Reserve Fund (617) 92 - (92) 92% 0% 100 - (100) Total Transfers In 457,090 625,332 18,242 _ 498,644 698,544 199,900 GF Appropriation Transfer 47,295 TOTAL RESOURCES 1,527,872 1,473,007 (54,865) 92% 86% 1,707,246 1,647,960 (11,991) REQUIREMENTS: Exp. 9/6 Expenditures: Personal Services 775,517 754,860 20,657 92% 89% 846,018 816,959 29,059 Materials and Services 674,722 591,233 83,489 92% 80% 736,060 723,497 12,563 Debt Service 105,479 113,695 (8,216) 92% 99% 115,068 113,695 1,373 Capital Outlay 92 - 92 92% 0% 100 - 100 Total Expenditures 1,555,809 1,459,788 96,021 1,697,246 1,654,151 43,095 Transfers Out - Reserve Fund 9,167 10,000 (833) 92% 100% 10,000 10,000 - Contingency - - - 92% n/a - - - TOTAL REQUIREMENTS 1,564,976 1,469,788 95,188 92% 86% 1,707,246 1,664,151 43,095 NET (Resources - Requirements) 37,104 3,219 40,323 - (16,190) 31,105 Beginning Net Working Capital per Adopted Budg et 46,373 Page 16 F U W ti O A. a H a v U 0 0 z a~ a~ i p~ N C T O N O t „N (D O U CL O Z ; Q0 O0 00 ccv)O00 co O tT O 0 8 ' 8 1 ' 00 00 4 00 (00 tL ? c ? O 0 0 0 0 47 4) T u 0 f` t- p O' 9 9 M O - CD 0 Mqr T al T T cm r M M M V O M f7 c`7 M 1 o M M 0 0 4 in O cco O I M 1•f O M O 0 0 lq~ T g r T ~ T T Or70C 7 1 1 c000MI cD M l IO I I lII 0 0 p 0000 ~ a 00 00 QD T O[h c~7 ' O r O ON470M N V 0 Cl 0raN r 0 O M of N " Ir p7 O <O d T cl 1 off N M T If1 T 1 c Lo IA Cp~M OOCOOOO O 'I 1"f 4I O0 p0 ~MQ 08 ' 88 c3 , 8 Im l M1 OcM] IC~] I M gp N 47 0 If-. 0 0 r O N IMI N T M P.. ' N co 0 C> r- Co~ La CO O V_ r 't to O O N d T CV M 1_r TO$cD p O p f~ 1w 41 V-M C N M 'W N p ON[SM rt c0 MO! C O ~ O ~ rj r T 1 1 1 1 1 1 M00p t0pe~ ' O 0 _ ~ rt 0"0"'0 co o r N a 0.C a cv r r C C ~U-w O Coe, LC) Ln 0 W N N V" v f` N ~ r__ W)) O IA cD W[ 47 r v 1 1 1 r e+7 f 0 N N 0 0 T T : . 02 y a: H ~ N N ~ r~ W H~u3 U a ' w m a ...U a ~ ~ c Wt CL w~ ' - m m3 a_LL° y 0 La I.- ~ O a c m dH UJO.' w 0 N M T N V IF7 , N W N m T I%. a w v ~ c ~ a~ m c~ CL ~ws! O U p N f► Ob N OI N M C3 c (1. m Z c'7 T Q N ~ N ~ r N O C1 0 C O 0. O p U m 41 ~ .a, Q OA ~ W) 0 (v m N a~ 0 m O N N 3: r '3 0 N O U_ N C } r+ L1. by C1 cA t0 m Q rW 3 ~ a, a ~ m c~ cv ~o O (D ~ N } ~ O LL ~ N U) CD P Z W 7 ~2 LL H 2 CV C:m O SUN CIO ❑ a cts Q C7~ O L C 7 m O U ~ L U o Z Zw Ill) 47 U C7f O N 7 m O O a. if1 ~n C 7 d E Q C O O E C O O t =3 E Lu) tu) O Q U C O .Q U N ❑ U ~i L U Q 4 U o ~ nC, W 4 Q J m ,.J m Deschutes County Bethlehem Inn (Fund 128) Eleven Months Ended May 31, 2012 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Lease Payments Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment TOTAL REQUIREMENTS Budget Actual Variance FY % Coll. % Budget Projection I „ Variance_ $ (2,711,235) $ (2,716,581) $ (5,346) 100% 100% $ (2,711,235) $ (2,716,581) $ (5,346) 2,568,341 - (2,568,341) 92% 0% 22,374 24,408 2,034 92% 100% 2,590,715 24,408 (2,566,307) 92% 1% 2,801,827 - (2,801,827) 24,408 24,408 - 2,826,235 24,408 (2,801,827) (120,520) (2,692,173) (2,571,653) 92% -2341% Exp. 13,750 16,674 (2,924) 92% 111% a) 91,667 - 91,667 92% 0% 105,417 16,674 88,743 92% 14% NET (Resources - Requirements) (225,936) 2,708,847) (2,482,911) Beginning Net Working Capital per Approved Budget a) Interest on May 2012 negative cash balan ce: $1,339.30. b) Inception through May 31, 2012 Revenues - Lease Payments $ 48,816 Expenditures: Land/Building (Amertitle) - July 2007 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 239,750 Total expended 2,757,663 Net $ 2,7~ 08 847) 115,000 (2,692,173) (2,807,173) 15,000 18,000 (3,000) 100,000 - 100,000 115,000 18,000 100,000 b) - (2,710,173) (2,707,173) (2,710,000) U U m j U CCCQ777 Q U) U) 3 t U a C d f` N C m N d C C xx W CT C C 2-0 C C ~ 0 W m N U) U G (ll c C 0 U 7U C Q1 0- x w O m N Co U N 2~ W C 7 o ~ 0~ O ~1 Lo 10 O I CO j CO co l rn v) Lo w ID I N O' u) 'I n . H ' U-i cr M HI V ti O. In ~ M N cC M Ln N 10 I rn' v Co, LO rl M I I.- N i In co n 1 ~ a i d K! 0 0 147 ! ' ~ LO 'I 10,CO CA III 'O,r Ir, N IM I BCD n Il CI ~I r' r O N ICO r.(q co N r r IT IM 1117 N V In tiICD1M N l!)I ; ~t 1 n' NId"I I10 W ~ r CY IN I N ICO N ~I I i A ca 1 . 47 j : CA CA CIJ 4 O f._'_ LO Ln ~ I a I I 0o ~ N I A In V 0o ~7'M C U-5 lq, 0 00 4 to ~U) m ~t:0 NIM r- 00 Lo CD m 7 k I ~ N r I I I IAOL V li N I N IC) I O ~~I M 10 N M II, ' I 'N Ip. 1. O~ O ' CO II, ' i~ t~D III _ _ ! C in ll7 T O 1 f, cp N H ' l ' ' 0 l!7 N lfl N Cf) co OD M C. M d N LO Lf) co CO Co CO t+ O C N 1 + N N r O 7 N I 0 I I n i I ' j ' II I 1 I ! I I - I t r , w I ' l I . I . r r I M I I I - O j Q O ' CO ' CD N 1 8 I I I - 0 I - ! I - I---- - ~ I . L -~I l p-' - I - I I n to 0 n • M r I ' N N r Cf) I~ Lf) 14t . C17 v CD I v CO I O I` ~ a co r~ i N 1 ! II, O) Co LO I CO P. cD I ~ I ~ ^I Z II I I ' I I W 'Q'. N: IM u7 N 101 N n N CO 0) CD O 'N 4 co lD CA CP' ~I O CD 0 CD IO U P7 'I F [q M CG M : Y' Co 0 r!' N ( r O II ~ I I I I I I I I NII I I IC I I N 07 I A ! t F.. N r l 4 M : C! J { N 1 Q C9 N r) Cfl u IIN N' It•Ir IM ' NIN', Il~ir - Cy L r tfj 1► !Cp v I I I I r I I I I I I I I I rT C]j I C d C CD 47 M I D O co 1 ~ A I I II I ~ 1 I I I S I I I , I 1 I 7 fD lp~ - ICO I W ICD M CD W u) co CD co; . I~ C7 W m co i0', , T OI j ! 'I r r r r r C.7 1 CA II I I I I I I I ' I I I I I~~ ~I ~ I I I I I I I I I .v~ I I L ~ i I I I I II IC X• I I II 1 ' I II ~'I CI 7 li ' I I li X! I ,~I 01 11 I Q1 I I l0 1 IL-! G1 ' I C CI I I W C . I ~ ~ ~ m I II I II 1 ~ : I : Y OZ{. C C I CI~ : C. C: I 40 ' C G 41 C ' I ~ o I , I ' I.O CCI I 11,7' V I I ( N yl Co a~IE2 N d IL NCI 0 !I,~I II IN , E,m E l Iw ro l C Ix1 1 OQj GI N~ . - m c V d' ~''p I d 7 I~ IMO 7 . C' I~Ip 5 C. p ' 11. A OI 7 CL ~I 'D. o. 71 x 1 ` I'O D ¢ . G I I~1, !7 7 61 '..'O t o a Cy O IV fU ~N.I 7'N V Imo. O . L 41I W a as W AIw m: W A rn y ~!d'O~'Imllal Ellro gall o,o Ilc r;I~Iotslm•o E;cis C I pIW lV!o~ ~I CD c ~ ` iUl I} 'O aI LL ml pp a V Q all ' ' d' p IE O o d~ m E au o PI~ to E m1o O U ml w M EI UM E m m m il, E m' U'E o l p .121. EI a~ llo: NI ,c O fxl U U T, U) 15' E I a~ m e ~Q j c 1 E n~ ox C E m 0) c Ia.., 7 ~ I(Q~~ 7 O Imo; O.Cp Cd171d j~o C0;7 O' ~ ° ' H l ' c I l ' ~ I I M, u) E m 0) OI COI C9 7 , Cj i0N'I& c ; U V1:=. 1 O, ' ( U ;o~' I lm'~ lmlU E lo t - iE I I la, o - E I (D oIUIHI!¢ ¢I2ICD O U H ¢la Q WO F- I Ili o oi0 -j¢ a 'I C9 LL'I 0. D F- O 0!2 I m r ¢I ~~I m'll V o -it * d e 11* a N o N * O 0 M 0 N 0 ri 0 r- 0 0 0 M 0 M 0 lkt 0 r- C i N I 1 Lri N M r4 N r4 Cl N N 1.~ N i ~ 4 Q O M ~ 4 O 00 0 v R* LLn 0 0 0 L`nn 000 ONO N 000 O o°l ~ Ln Tr M c rn ll:r Ln 00 00 n rn n 00 n Ln o 00 lqt All, m N ri ri m R* .l lD n m 00 N ~ M r-~ N r-I ri M rI ~l 00 06 ri N N to N o am r-I r• M 0 ~ w m r-I 0 ri O w tD O E M 00 M O O M t lD mi FZ m Ln c-4 w o O r-I ~ Ln W -4 C rn oo rn r• rn rn C1 rn N N Ln Ln o ri o0 N _ m -,r O L -zz Ln n r. 06 m o 06 C, of m a-1 N N Ln M ka Ln m I• Ln o o r-I uD O 60 N 00 O LD N m M ri m Ln Ln r• N N LD C 00 ri Ln M r 1 m N 00 rr~ L ,L a 0 Ln N Ln r-I o0 o r-I o qtr m 0 0 0 M M ei A N ~ ba M co o O C? O n 06 •-I q:T O V-1 o r i Ln M n O Ln -d~ m Cl 0 00 N Ln O lD m m r4, tD m O N m M D 0 6 r-I o 0 Qi ri r o 0 d r- Ln m m ri r-I Ln ri 0 d 0 r- o 0 d 0 0 N' 5 0 d 0 0 06 o 0 d 0 00 fy" r-I r• m lp Kt LL ~ O QJ N W E C W CD C:, 00 r- M a_ m U- 7i C M C O u a) I I m Q 06 Q C71 'N N-0 -C 0 l6 " U Y v-I L GJ Q1 © Q m LL 'Q e I m m J U (n V) a m U ac a U Ln rn LL O1 C D C C Q) U C iF a-1 N M Ln tp n DO C1 0 V4 N M CT LA 71 74 ra ri r♦ 71 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Eleven Months Ended May 31, 2012 Year to Date Year End Budget (11/12 of annual) Actual Variance =~X.Coll. Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 75,000 $ (40,601) $ (115,601) 100% -54% Receipts: Special Events Revenues 554,583 493,965 (60,619) 92% 82% Interest 1,375 155 (1,220) 92% 10% Storage 53,167 37,072 (16,095) 92% 64% Camping at F & E 5,500 19,240 13,740 92% 321% Horse Stall Rental 27,500 21,714 (5,787) 92% 72% Concession % - Food 201,667 135,031 (66,635) 92% 61% Rights (Signage, etc.) 102,667 124,000 21,333 92% 111% Grants - - - 92% n/a Interfund Contract 43,083 46,833 3,750 92% 100% Miscellaneous 6,240 10,266 4,027 92% n/a Total Receipts 995,781 888,276 (107,505) 92% 82% Transfers In General Fund (001) 155,833 305,837 - 92% 180% Room Tax (160) 23,599 23,595 - 92% 92% Welcome Center (170) 75,900 75,900 - 92% 92% Annual County Fair (619) 201,667 220,000 18,333 92% 100% Reserve Fund (617) 92 - (92) 92% 0% Total Transfers In 457,090 625,332 18,242 GF Appropriation Transfer TOTAL RESOURCES 1,527,872 1,473,007 (54,865) 92% 86% REQUIREMENTS: Exp. %16 Expenditures: Personal Services 775,517 754,860 20,657 92% 89% Materials and Services 674,722 591,233 83,489 92% 80% Debt Service 105,479 113,695 (8,216) 92% 99% Capital Outlay 92 - 92 92% 0% Total Expenditures 1,555,809 1,459,788 96,021 Transfers Out - Reserve Fund 9,167 10,000 (833) 92% 100% Contingency - - - 92% n/a TOTAL REQUIREMENTS 1,564,976 1,469,788 95,188 92% 86% NET (Resources - Requirements) (37,104) 3,219 40,323 Beginning Net Working Capital per Adopted Budget $ 75,000 $ (40,601) $ (115,601) 605,000 543,965 (61,035) 1,500 155 (1,345) 58,000 37,072 (20,928) 6,000 19,240 13,240 30,000 30,714 714 220,000 138,031 (81,969) 112,000 130,000 18,000 - 33,424 33,424 47,000 47,000 - 6,807 10,416 3,609 1,086,307 990,018 (96,289) 170,000 370,000 200,000 25,744 25,744 - 82,800 82,800 - 220,000 220,000 - 100 100,000 99,900 498,644 798,544 299,900 47,295 1,707,246 1,747,960 88,009 846,018 816,959 29,059 736,060 723,497 12,563 115,068 113,695 1,373 100 - 100 1,697,246 1,654,151 43,095 10,000 10,000 - 1,707,246 1,664,151 43,095 - 83,810 131,105 46,373 Page 16 DESCHUTES COUNTY LEGAL COUNSEL JOHN E. LAHERTY Assistant Legal Counsel W541-330-4645 DATE: June 21, 2012 TO: Commissioner Anthony DeBone DATE: June 20, 2012 Commissioner Tammy Baney Commissioner Alan Unger RE: Amendment to Deschutes County FILE NO.: 29/1-005 Dog Board Ordinance, Chapter 6.12 Pursuant to Oregon law and Chapter 6.12 of Deschutes County Code, the Deschutes County Board of Supervisors, acting as the "Dog Board," is responsible for adjudicating matters in which dogs are accused of chasing, injuring or killing livestock. Specifically, the Dog Board is required to decide the following issues: (1) disposition of the dog (i.e., return to owner, place for adoption, or euthanize), (2) assessment of fines and costs to the dog owner, and (3) payment of compensation to the livestock owner. At this time, it appears some provisions of Chapter 6.12 do not clearly track state law, do not clearly set out appropriate procedures for Dog Board cases, and/or impose impractical obligations upon the County. For these reasons, I believe it appropriate that the Board consider adopting certain revisions to Chapter 6.12. I have prepared a matrix setting forth the specific sections of Chapter 6.12 that appear appropriate for revision. That matrix is attached to this memo. cc: Erik Kropp, Interim County Administrator Mark Pilliod, Legal Counsel Bonnie Baker, Recording Secretary w/attachment DCC Chapter 6.1.2 Proposed Issues For BOCC Review Code Section Issue Options Staff Recommendation 6.1.2.020 As written, unclear as to Clarify section to either include Staff has no whether un-caged chickens = or exclude un-caged chickens recommendation on this livestock. from definition of livestock. issue. 6.12.040 Makes it a Class A violation to _ • Add exception language _ Add exception language own or keep any dog that has for dogs returned to for dogs returned by killed or injured livestock. owner by court or Dog court or Dog Board. Board; or • Leave language as-is. 6.12.050(A) As written, unclear as to what • Clarify language; or Amend section to require evidence must be received . Leave language as-i.s receipt of written from a complainant in order complaint (under penalty for law enforcement to of perjury) from impound dog. complainant. 6.12.050(B) Requires County to conduct . Leave section as-is; or ` Amend to make testing veterinary testing of dog if . Amend section to make wholly within County's there is reason to believe such testing wholly within discretion. testing would provide County's discretion "substantial further evidence." 6.12.060(A)(1) Does not require dog owner to . Amend section to include Arnend section to include request hearing. Instead, gives provisions of ORS provisions of ORS impression that hearing is 609.156 re. notice and 609.156 re, notice and automatic. Does not comport request for hearing; or request for hearing. with state law. _ • Leave as-is. 6.12.060 Does not set out applicable . Amend to set forth- Amend to ~ include evidentiary standard for Dog evidentiary standard; or standards from ORS Board hearings. • Leave as-is. 609.158(3) "reliable, probative and substantial evidence." 2.060(C) Allows Board to charge • Leave as-is; or Staff has no complainant for impound . Eliminate this section to recommendation on this expenses if dog found not comport with historical issue. guilty. Board practice. 6.12.060 Does not require County to • Amend section to include Amend section to include micro-chip dogs (as required language of ORS language of ORS by ORS 609.168). Does not 609.168; or 609.168. comport with state law. 0 Leave as-is. Issue T Options Staff Recommendation 6.12.060 Does not address mailing notification to dog owner of Board's decision, as required by ORS 609.156(4). Does not comport with state law. 6.12.080 Permits livestock owner to request compensation from Dog Board for damaged/killed livestock. _ 6.12.090 Requires any compensation for damaged/killed livestock to be paid directly by County to livestock owner include; • Amend section to include Amend section to language of ORS language of ORS 609.156(4); or 609.156(4). • Leave as-is. • Remove this provision; or • Leave as-is. • Remove this provision and require livestock owner to pursue compensation via civil court action; or • Leave as-is. 6.12.100 Subrogates County to rights of livestock owner after paying compensation; requires County counsel to file suit against dog owner to recover amounts 6.12.110 Provides that livestock owner's right to recover compensation from Dog Board does not prohibit livestock owner from pursuing civil remedies (i.e., legal action for • Remove this provision; or • Leave as-is. + Amend this provision to state that Dog Board does not have authority to award livestock owner compensation; or 0 heave as-is. Remove this provision. Remove this provision and require livestock owner to pursue compensation via civil court action. Remove this provision. Amend to expressly state that Dog Board does not have authority to award livestock owner compensation. O U V w ~I rrro W L V ♦ f+ ~ aL•+ r y E r rr~ Q i ~ U E n n z z z z m m 0 M N p O O N _ ; p 7 7 7 7 U W w W W O U O C U c CU rn z z z z c M M co O (n 2 U CA 2 U cn U) N 3 o > `n ca U) c ) L m om- 1 N L O (D h d) U ~ 4` O C C1 -0 N N ❑ O O O U O •Q C O - 00 a) c Q) (D O p N 4= O _ C 2 ca U rn U IL a V ' O O C O Y O C y in _ Q _ L -0 Q) C Q) cA U) a ¢ a v O L~• T LL LL H O co Q C a) _ O j Q V O U) Z 2 H M_ 06 6r N N N 4 m C%. • o Q N N Q (V N N N r O ' N N N fn 0 [y N lT• C c ? cm d) O co CL N WHY APPLY? r_ Located in the heart of Central Oregon, De- schutes County _ serves as the outdoor recreation capital of the state. Both resi- - dents and visitors en- joy skiing, snowboard- ing, fishing, hunting, hiking, camping, rock climb- ing, bicycling, rafting, kayaking, and golfing, as well as a variety of annual festivals and sporting events. Deschutes County is financially sound and offers the right candidate a challenging and rewarding career opportunity. The natural beauty of the area, its mild climate, and diverse recrea- tional opportunities make Deschutes County a great place to live, work, and play. THE COMMUNITY For the past decade, the Central Oregon region has been recognized nationally and internationally as one of the best places to live. Deschutes County is conveniently located within a three hour drive to Portland, Oregon and within one hour to the Cascade Mountain Range. With an average elevation of 3,600 feet, the area enjoys a dry, high desert climate with cool nights and sunny days. Annual precipitation averages 11.7 inches. The countywide population is 158,000 spread over 3,055 square miles. Tourism brings approximately 1.5 million visitors annually to Deschutes County. The Mount Bachelor ski resort brings in tourists from all over Oregon, Washington, and California. The nearby Cascade Lakes are also a large draw for tourists and the area boasts a concentration of 29 world-class golf courses. Recreational activities including include downhill and cross Other local features include a vibrant visual and performing arts community, outstanding restaurant scene, extensive and respected health care net- work, and a high quality education system. The combined infrastructure investment totals in the billions of dollars and acts as a magnet for profes- sional talent from across the U.S. and abroad. The cities of Bend, the county seat, Redmond, La Pine, and Sisters are the four municipalities in the County. Roberts Field Redmond Municipal Airport connects the county to other major US western cities. In addition to excellent public and private K- 12 schools, Bend is home to Central Oregon Community College (COCC) and Oregon State University's Cascade Campus. THE COUNTY Deschutes County is one of the largest employers in Central Oregon and the largest municipal gov- ernment in the region. The County has 816 FTE positions and a $267 million annual budget. The County provides public safety, public health and behavioral health, community development, road construction and maintenance, elections, assess- ment and taxation, solid waste, social services, and operates a large fair/expo center. Indirect services that support county operations include finance, personnel, property and facilities man- agement, internal auditing, information technology, legal counsel, and public information. Deschutes County is a General Law County which enables the County to write ordinances on any subject not preempted by the state. The Board of County Commissioners is the governing body of the County and is comprised of three commission- country skiing, hiking, biking, rafting, golfing, camping, fishing, picnicking, rock climbing, and general sightseeing. ers elected at large. The Board's duties include executive, judicial (quasi-judicial) and legislative authority over policy matters of countywide con- cern. The executive duties consist of establishing the budget, with the aid of a three lay member Budget Committee. The Board's charge also includes creation and en- forcement of county ordinances and, in general, the resolution of any problems arising between the citizenry and various county departments. The Board of Commissioners also acts as the govern- ing body for other local public entities such as the Sunriver Service District, the 9-1-1 Service District, and the Extension/4-H County Service District. To implement policy and manage the day-to-day op- erations of the County, the Board appoints the County Administrator. Deschutes County has a reputation for innovation, pilot programs, and successful collaboration with its regional partners. The State of Oregon often looks to the County to implement new programs or demonstrate new ways of providing services, such as the creation of a coordinated care organization to deliver health care services to residents on the Oregon Health Plan. Despite the national recession, Deschutes County has remained financially sound. Due to strategic budget reductions made in prior years, strong fi- nancial reserves, and a history of conservative fis- cal management, Deschutes County has largely maintained services during an extended period of decreasing revenues. In fact, Moody's Investors Service has assigned Deschutes County an Aa3 rating for full faith and credit obligations and an Aa2 rating for outstanding general obligation debt. Well-funded reserves in the County's Public Em- ployee Retirement System (PERS) fund have off- set increases charged by the State of Oregon which administers the program. The County is self-funded for health insurance and to help control health care costs, recently opened an on-site clinic for employees and dependents covered by the health plan. Strong reserves in the Health Benefits Trust fund have allowed the Coun- ty to increase departmental charges for health in- surance costs only 1.6 percent over the last four fiscal years. THE POSITION The County Administrator is appointed by and serves at the discretion of the Board of County Commissioners. The Administrator is the Chief Administrative Officer and is responsible for: General operations of the County Y Supervision and management of all non- elected department directors Administering the County's personnel system and rules ➢ Conducting short and long term planning Implementation of the Board's goals and poli- cies Administering the County's public contracting and purchasing processes ➢ Acting as the organization's Budget Officer and developing the County's proposed annual budget Y Ensuring compliance with state laws, ordin- ances, service contracts, and all orders, and resolutions, policies, rules, procedures, and regulations adopted by the Board of County Commissioners. Mr. Erik Kropp is currently the Interim County Ad- ministrator. He will not be a candidate for this po- sition. OPPORTUNITIES & CHALLENGES Deschutes County is currently involved in a wide variety of innovative activities and initiatives de- signed to improve operations and increase public access to services, use resources more effective- ly, and manage finances in a challenging econom- ic climate. Examples of just some of the many is- sues being addressed include: ➢ During the past biennium, the Oregon State Legislature passed major reform legislation in the areas of health and education. As a result, Deschutes County is involved in developing an innovative coordinated care system and a pub- liclprivate Central Oregon Health Council to develop a regional health improvement plan. In addition, the impending creation of a new Oregon Education Investment Board and Early Learning Council is expected to impact county services provided to women, children, and families. Y In conjunction with its successful on-site em- ployee health clinic, the County is planning to open an on-site pharmacy. The pharmacy will serve employees, retirees, and dependents enrolled in the county benefits plan and is in- tended to result in significant health benefit cost savings over time. Y Deschutes County recently purchased a 40,000 square foot office building in the City of Redmond to serve as a North County campus which will increase accessibility to a wide va- riety of public and social services. In addition to housing several county departments, parts of the building will be leased to other govern- ment agencies and local non-profit organiza- tions. The North County campus will open in 2012. Y Despite its relatively healthy financial situation, Deschutes County, like all local and state gov- ernments, will continue to face challenges re- lated to reduced revenue. Many county func- tions are mandated by the State of Oregon and the County is reliant on state funding to provide such services. Securing a permanent tax rate for the Deschutes County 9-1-1 Service District and addressing the loss of revenue from Fed- eral Forest Payments under the Secure Rural Schools (SRS) and Community Self- Determination Act are high priorities. SRS funds are set to expire in July 2012 and pro- vide a major funding source for road construc- tion and maintenance. r In May 2010, the County proposed a bond measure to fund jail expansion which was not approved by voters. As a result, the Sheriffs Office is challenged with managing growth in the adult jail inmate population within the exist- ing inmate capacity. Y As in much of the country, the local unem- ployment rate and number of foreclosures in Deschutes County remain high. The Board of Commissioners has placed a priority on assist- ing with economic development and job crea- tion and has developed a fund to support these efforts. IDEAL CANDIDATE PROFILE The County is seeking a County Administrator with..... EXPERIENCE & EDUCATION Successful candidates for this position will have a bachelor's degree from an accredited college or university in public administration, business admin- istration, political science, or a related field, and at least eight years of progressively responsible ex- ecutive or management experience obtained at the senior level of a medium or large public or private organization, agency, or association. A master's degree in public administration is preferred. Possession of or ability to obtain a valid Oregon Driver's License within 30 days of hire date is re- quired. The employment offer will be contingent upon an acceptable and verifiable driver's license and driving history. The candidate selected for this position will be required to pass a drug screen- ing and a thorough background, employment, and criminal history investigation. COMPENSATION & BENEFITS Y $xxx,xxx to $xxx,xxx DOQ Y Deschutes County I Fs www.deschutes.org Deschutes County actively recruits persons from various ethnic and cultural backgrounds to enhance ser- vice to its diverse communities. Deschutes County is an equal opportunity, affirmative action employer. All qualified candidates are strongly encouraged to apply by xxx xx, 2012 (first review, open until filled). Applications, responses to the supplemental questions, resumes and cover letters will only be accepted electronically. To apply online, go to www.prothman.com and click on "submit your application" and fol- low the directions provided. Resumes, cover letters and responses to supplemental questions can be uploaded once you have logged in. At www.prothman.com 371 NE Gilman Blvd., Suite 350 Issaquah, WA 98027 206.368.0050