Loading...
2013-118-Minutes for Meeting March 25,2013 Recorded 4/5/2013COUNTY NANCYUBLANKENSHIP,F000NTY CLERKD5 1+J L~+3'~~~ COMMISSIONERS' JOURNAL in .mom 04/05/2013 11:H:39 AM 2013-11 Do not remove this page from original document. Deschutes County Clerk Certificate Page Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www,deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, MARCH 25, 2013 Present were Commissioners Alan Unger, Tammy Baney and Anthony DeBone. Also present were Tom Anderson, Interim County Administrator; Erik Kropp, Deputy County Administrator; and for a portion of the meeting, Marty Wynne and Jeanine Faria, Finance; Nick Lelack and Will Groves, Community Development; and about a dozen other citizens. Chair Unger opened the meeting at 1:30 p.m. 1. Finance/Tax Update. Marty Wynne said the pool rate has dropped again. It is hard to realize it is going down still, and the Oregon rate is higher than most in the country. The rate changes weekly and is not forecast. It was 0.6 for a long time but has gone down. The budget for this fiscal year assumes 0.4. The general fund shows a budget ending balance of $9.8 million, and next year will be around $9.5 million for the beginning net. This includes transfers out for things such as the jail bond. Revenue has been stable, and tax and Clerk revenue is higher than budget. Room tax is up considerably. For the most part, the County is healthy financially. There have been no changes on most capital projects; however, they are currently developing the numbers for the jail remodel project. They are collecting about 92-94% of taxes, which is conservative. 2. Discussion of IGA's with the Cities of Sisters, Redmond and La Pine regarding Community Development Services. Nick Lelack stated that next Monday the Board is to consider three intergovernmental agreements with the cities of La Pine, Redmond and Sisters. The cities have all approved these documents. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 1 of 11 This is an update to the 2008 agreement with Redmond. Due to a higher additional workload, there will be a little more funding for the County. The County has provided backup services to Redmond City staff for years. It makes sense for them to not hire staff but to utilize existing talent within the County. Citizens file with the City but the County responds quickly. The County has a pool of on-call staff to handle the fluctuating demand. The City of Sisters had County staff helping there the first of the year. Someone is at Sisters City Hall on some days of the week. It has been going well with them also. The County has a person on call who lives in that area. The fee split is higher for the County due to having a person readily available. The County has provided planning services to the City of La Pine since La Pine became a city. There have been some revisions since then. The existing IGA expired last summer. The City may take over planning services with thirty days' notice. They are not sure when this will happen, but the County is helping them to get to that point. They have provided some free services to them, such as GIS, over time. There will be a transition period as the City is able to take over these services. 3. Discussion of EDCO and Participation of Cities. Tom Anderson said the County has received specific inquiries from the cities of La Pine and Sisters regarding economic development assistance. EDCO prepared a lengthy proposal regarding the use of these kinds of funds and how economic development could be expanded or assisted. The objective is to isolate different components for the Board to consider, and the Board can look at the top priorities for lottery fund dollars. Historically this has included base funding for EDCO and other major partners of the County such as COIC, the Upper Deschutes Watershed Council and others. The Board will hear what those components might be and deliberate how this would be addressed in the context of other service partners. No one is expecting a decision today. Roger Lee said there was good feedback from staff on making this more manageable and consistent. For fiscal year 2013-014, it has three major components with local programs and entrepreneurships, and a focus on regionalization. Staff wanted to know priorities, but they are almost listed that way (see handout). They are all important and they tried to cover as much as possible. As a regional organization with local offices, EDCO and this situation is unique, and it works. Local managers draw off regional staff for assistance. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 2of11 A good example of how this works is the recent American Airlines travel bank commitment by the cities, counties and others to bring that carrier to this region. Commissioner DeBone asked about the two-year commitment, and the venture catalyst program. Mr. Coonan said that Founders' Pad needs some initial support. It is not an EDCO administered program. The venture capitalist program is meant to be more long term. It is a critical component but is not self-funding at this point, and will require ongoing support. They hope that the County will offer support as well in the amount of $30,000. If some element of this program falls out, they should have enough community support to maintain this. Chair Unger noted that these help position the area in a new way to do business and be recognized as a place that is innovative. Mr. Lee said that it creates some buzz nationally, but the focus is to help busiensses and not necessarily just marketing. Support involves money and mentorship. He is confident that this works. The picture of economic development is changing and a lot of this is based on young companies. Chair Unger stated that the time is right for this kind of change. You cannot wait for the market to change. It needs to be pursued and more investment should be made in this regard. Mr. Coonan said that adding the other cities and areas makes the strategy more cohesive. Commissioner Baney said that not all communities were interested in the past. She asked how EDCO adjusted to this. She asked about REDAP and REDI and how those fit in. Mr. Lee stated that EDCO is more economical and streamlined, and is a more effective model. They help to get the ball rolling and then turn it over to local management. EDCO has allocated resources to help make the local entities successful, in a cost-effective way. The cities could not hope to do this on their own. Chair Unger said they used to do this individually, but the results were not as successful as they could have been. The support was not there. It is better to tie things together. Commissioner Baney stated that she struggles with the Bend part of the equation. There are other groups that work towards economic development. She does not understand how this works on the ground. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 3 of 11 Mr. Lee said that the city's advisory board helps them to decide how to direct these resources. They still contract to deliver the work. Caroline Eagan of Bend stated that they have no expertise on how to sell a region, so; are working this out with EDCO. It would be good to have a plan on what is needed once the businesses get here. They can get the expertise they need before then from EDCO. Mr. Lee said they have a marketing committee, but it is a fluid process and evolving. Mr. Coonan added that they are using the program to work with later stage companies. Commissioner DeBone said it shows an amount of $417,000. Mr. Lee stated it is not that much, but all funds would be highly leveraged. Some of it is existing funding. Commissioner DeBone said that a couple of the cities are looking at hiring this person. Mr. Anderson stated that it would probably be mid-April due to the budget process. The main reason to have today's discussion is to bring everyone up to speed. There are other things that are important to consider during budgeting time, so mid-April is the most appropriate time to look at hiring. Commissioner Baney asked about giving funds to Founders' Pad. Mr. Lee said it could be a pass-through to them via EDCO. He hopes it will not be a piecemeal type of transaction. Mr. Coonan stated that updates would be as the Board wishes but a representative of Founders' Pad should be available to demonstrate the progress of the company. Commissioner Baney is concerned that this Board cannot bind a future Board, but she is willing to at least help La Pine and Sisters for the next two years. There are other possible unknowns that are not under the control of the Board. She is trying to figure out how to assist the other cities since it is more complicated in those situations. Mr. Anderson said he supports this opinion, but the additional $40,000 is more than what they have allocated this year for existing organizations. Barring the infusion of other funds, there may be some organizations that are not funded next year that have been in the past. The $40,000 would necessitate this type of decision barring a transfer of funds from another source. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 4 of 11 Chair Unger stated that he supports a year and hopes that there will not have to be a second year. Commissioner DeBone said that this affects the hiring decision and two years or longer would be more appropriate. Rick Allen with the City of La Pine said he likes the two-year proposal. It takes time to do this process and a year would be hard. He prefers a 24 or 36-month commitment. Regarding not buying into the future, there are conditions for funding. There are outs if there need to be changes for some reason. He is reluctant to agree to just a year. He knows they will want to see that it is working. Chair Unger is supportive of economic development, but wants to know what they are really doing with this funding. There are some unknowns that are critical components. Mr. Allen said that if it is not working right, they could be told. La Pine and Sisters do not have this in place already and will need more time. Commissioner Baney said that they could do quarterly updates to keep the Board informed. Chair Unger stated he wants to know more about traded sector and commercial activities, and what the focus will be on job creation. Mr. Allen replied that the funds go to EDCO and EDCO will oversee the process. Mr. Lee said they pass the funds on and the local communities execute the programs. The idea is to be consistent. Mr. Anderson stated that there might be an additional IGA with those cities to make sure they are all on the same page. Mr. Allen stated that they have a group formed to address this program and would appreciate having a Commissioner or manager involved. Mr. Anderson said that the April 15 work session might be an appropriate date to discuss these allocations further. Ms. Eagan suggested two years, since she is doing that now. Mr. Allen said that they are trying to look broader and bigger, and with the help of EDCO they can make strides. He thinks this work makes a huge difference. 4. Review of Discretionary Grant Funds Requests. Commissioner Baney said there is $32,000 total left for this purpose. Judith Ure stated that they got a note from AOC saying that the there will be 2.2% less coming from the State, which will all come out of the 0 quarter this year for two years. Revenue projections are down. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 5 of 11 The net impact will be about $15,000 less coming in to the program. She thought revenue would be stronger than it is. She provided a handout on the total revenue picture for this funding, what the Commissioners have allocated this year, and what remains. The Board could spend all of it today and have nothing for the next quarter. The requests for funds far outweighs the balance available. Many of the applicants are represented at the meeting today to answer questions, if any. Network of Volunteer Administrators - $15500 2013 Volunteer of the Year Event. Chair Unger feels this request deserves support. The Commissioners granted $500 each. Mr. Anderson stated there are some groups that get funding from elsewhere. CASA and HSCO are service partners. Bethlehem Inn is a community grant recipient as is Big Brothers - Big Sisters. Commissioner DeBone wants to support in kind where he can, by a third. They are all deserving. Chair Unger feels there are some that are more important to the County than others. Some promote safety, such as the Upper Deschutes River Coalition. Sisters Kiwanis Community Service Foundation - $3,000 - Food Bank Building Construction. Chair Unger said he was a Kiwanis for a while, and they focus a lot on children. David Hiller said that 3,632 people participated last year. Chair Unger granted $500 and Commissioner Baney granted $1,000. Sisters Trails Alliance - $5,000 - Create Waterproof, High-Quality Map of the Sisters Trail System. Chair Unger likes the fact they are setting themselves up for a funding stream in the future. It will help with future revenue. They can look for other donations and loans since there is a pay back. Commissioner Baney said that cycling is an important piece of the economy. Chair Unger granted $500 and Commissioner Baney granted $1,000.. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 6of11 CASA of Central Oregon - $2,500 - "I Am for the Child" Volunteer Recruitment Program. Commissioner Baney said they already get funding in the amount of $30,000 a year as a community partner. Upper Deschutes River Coalition - $2,000 - Wildland Fuel Reduction Maintenance Mailing. Deschutes River Woods Neighborhood Association - $900 - Mailing Campaign regarding Emergency Evacuation Zones. Commissioner DeBone said that this should be through Project Wildfire if possible, as should the UDWC mailing. Commissioner Baney said that this should be through Title 111. Chair Unger pointed out that there is no money left in that program. Commissioner Baney asked how they could do this for all areas; it would not be possible. Chair Unger said he would support this at some level. Commissioner DeBone said he could talk to the next UDRC meeting group and see if they can do this kind of project jointly. Commissioner Baney stated that she thinks they may have another grant in mind. Ms. Ure stated that they had another one submitted previously but it was withdrawn. Commissioner DeBone would like to discuss this more with the County Forester and Project Wildfire staff to see if there are other options. Chair Unger feels these are important to safety. Commissioner Baney feels this might be done another way. Commissioner DeBone will talk to the parties to find out if there might be other funding stream. Mr. Kropp stated that many of these people might be contacted through e-mail lists instead of a paper mailing. Tri-County High School Rodeo Club - $2,500 - 2013 High School Rodeo Event. The Board said they need to plan for this in the future. Commissioners Baney and Unger granted $500 each. La Pine Rodeo Association - $1,500 - Annual La Pine Rodeo Event. Commissioner DeBone said that the land grant is coming next year. He met with this group and they need operational funds for this year. Chair Unger stated that there are a lot of rodeo events and he feels they should find other sources. They were asked last year to plan for this. He may help this year, but not next year. The Commissioners granted $500 each. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 7of11 St. Vincent De Paul, Redmond - $484 - Complete Striping of Parking Areas at Facility. Chair Unger granted $200; Commissioner DeBone granted $100 and Commissioner Baney granted $184. Humane Society of Central Oregon - $1,245 - Defibrillator (AED) for Thrift Store. The Commissioners felt this organization could find the money for this. Cascade Theatrical Company - $2,500 - Support Remaining 2012-13 Main Stage Season Productions. Chair Unger supports the arts, but he wants to focus more on public safety issues. This is for operational costs. Commissioner Baney said the legislature looks at economic development grants in particular. Chair Unger said they have supported a lot of things in the past, but the past year has been more difficult. Commissioner Baney granted $750. Bethlehem Inn - $5,000 - Third Annual Spotlight on Homelessness Dinner Event. Commissioner Baney granted $1,000; Chair Unger granted $500; Commissioner DeBone granted $400. Serendipity West Foundation - $1,500 - Challenge Days Workshops for Bend-La Pine Middle and High School Students. This is a foundation formed by a teacher, not a school function. They were funded in the past under a different name. Mr. Inbody said that it was called Challenge Days in the past. Chair Unger stated that it does change lives, not just the students but also adults. He will put some money in this time around. Chair Unger granted $500; Commissioners Baney and DeBone granted $250 each. Big Brothers-Big Sisters of Central Oregon - $2,500 - Bowl for Kids' Sake. Chair Unger granted $250; Commissioner Baney granted $750. Chair Unger said that there may be a request for dump fees to clean up the trail areas east of Redmond. Commissioner Baney stated that Solid Waste may have some funds remaining for use by nonprofits. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 8 of 11 5. Discussion of an Application regarding Changing the Required Overnight Lodging Ratio for Bend Urban Area Destination Resorts (Tetherow). Will Groves gave a PowerPoint presentation (a copy of which is attached for reference.) He will be looking for some Board direction. (His staff report is also attached.) This is only for Eastern Oregon. Laurie Craghead added that Goal 8 was changed in 2009, so the County has had to make adjustments to local law. Some is before the Planning Commission and then will come to the Board. The amendment lowers the mandatory minimum of overnight units that a resort must provide for each residential unit. This does not allow new construction or higher densities beyond what is presently allowed. They could ask for increased residential units if conditions can be met. They could increase the number of overnight units, for instance in a large hotel. Tetherow is conceptually approved for 589 residential units and 300 overnight units. To date, 357 residential lots have been platted and 198 overnight units have been approved through bonding (not yet constructed). This amendment could be used to change the mix of residential/overnight units. Off-site impacts requires a modification of the conceptual master plan, and infrastructure has to be in place. It is believed that these changes would not significantly affect transportation issues. Various arguments have been made about this change, primarly to mirror State law and to provide flexibility for resorts to react to market demand. Some people feel that if there are not more overnight units, this will negatively affect the local tourist-based economy. There will be amendments to Title 18 and Title 19 presented to the Board. They could be addressed at the same time or Title 18 first. This allows more flexibility to the clients. The Planning Commission is addressing these amendments at this time. Board direction is requested in this regard. Staff prefers these be dealt with separately. The cost would be the same in either case. There would be a time delay and it affects bonding. A faster process may mean less cost to the applicant. 6. Other Items. Commissioner DeBone asked about the La Pine Boy Scouts coming to a Board meeting. It was thought that the one on April 15 might be appropriate. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 9of11 He asked again about holding a regular meeting in La Pine. Chair Unger thought it might be appropriate for it to be a joint meeting with the Council. Discussion occurred about the State of the County being presented at a La Pine Chamber breakfast. Cahir Unger would like to tour the new Little Deschutes Lodge 11. Tom Anderson suggested they wait to meet until the DEQ steering committee has made its recommendations on groundwater issues. Chair Unger said that he attended a meeting regarding the OSU Cascades Campus, and met with the Governor. There was a map on the wall showing how the campus would grow. There is a big chunk of land on that map showing the armory and the County-owned land (former landfill). This could figure into the long-term picture, maybe through a trade with DSL for land by the Redmond airport. General Caldwell was there and talked about the armory. They would take out a twenty-year loan to build it and the State pays it back. They may want to combine Bend and Redmond on this property. Commissioner Baney said that Juniper Ridge was given to the City by the County in part for a university. She would rather trade for that and not the demo landfill, which has too much liability attached. This was master planned by the City. Chair Unger noted that the City of Bend needs to figure out how to handle transportation and infrastructure issues. Commissioner Baney asked if the current configuration for the university not working. Chair Unger said it is hard to buy land near the college for a reasonable price. A committee is looking at options. Commissioner DeBone asked about Juniper Ridge. Chair Unger said that there is no infrastructure in place. They may want to be downtown where COCC is. Commissioner Baney reiterated the City could give back Jumper Ridge. Chair Unger stated he will be going to Washington, DC to support Rural Voice the week of May 13. They need some leadership there. Other Oregon Commissioners might participate. They need to talk about collaborative forest support and contract renewals. Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 10 of 11 Chair Unger said that of the 140,000 acres burned in local forest fires, the U.S. Forest Service is moving forward to treat about 1,000 acres. The challenge is salvage logging. There is no environmental reason to do this, as it disturbs the ground even more. They might do harvesting in the least sensitive areas near roads. The collaborative group does not want to get into a fight on this, and instead wants to focus on the green forests that still exist. The law supports doing nothing. This is an experiment, and is about just 1,000 acres out of the 140,000. They need to focus on the future. Being no further items addressed, the work session ended at 2:55 p.m. ~i~ DATED this ® Day of 2013 for the Deschutes County Board of Commissioners. ATTEST: uq6~m~~, Recording Secretary Alan Unger, Chair r4v~~, - Tammy Baney, Vice C it Z50b C/944---, Anthony DeBone, Commissioner Minutes of Board of Commissioners' Work Session Page 11 of 11 Monday, March 25, 2013 ~``~~t ps C ~G a Deschutes County Board of Commissioners n 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, MARCH 25, 2013 1. Finance/Tax Update - Marty Wynne, Jeanine Faria 2. Discussion of IGA's with the Cities of Sisters, Redmond and La Pine regarding Community Development Services - Nick Lelack 3. Discussion of EDCO and Participation of Cities - Roger Lee 4. Review of Discretionary Grant Requests - Judith Ure Network of Volunteer Administrators - $1,500 - 2013 Volunteer of the Year Event Upper Deschutes Watershed Coalition - $2,000 - Wildland Fuel Reduction Maintenance Mailing Sisters Kiwanis Community Service Foundation - $3,000 - Food Bank Building Construction • Sisters Trails Alliance - $5,000 - Create Waterproof, High-Quality Map of the Sisters Trail System • CASA of Central Oregon - $2,500 - "I Am for the Child" Volunteer Recruitment Program • Deschutes River Woods Neighborhood Association - $900 - Mailing Campaign regarding Emergency Evacuation Zones • Tri-County High School Rodeo Club - $2,500 - 2013 High School Rodeo Event • La Pine Rodeo Association - $1,500 Annual La Pine Rodeo Event • St. Vincent De Paul, Redmond - $484 - Complete Striping of Parking Areas at Facility Humane Society of Central Oregon - $1,245 - Defibrillator (AED) for Thrift Store Cascade Theatrical Company - $2,500 Support Remaining 2012-13 Main Stage Season Productions • Bethlehem Inn - $5,000 - Third Annual Spotlight on Homelessness Dinner Event • Serendipity West Foundation - $1,500 - Challenge Days Workshops for Bend-La Pine Middle and High School Students 5. Discussion of Application regarding Changing the Required Overnight Lodging Ratio for Bend Urban Area Destination Resorts (Tetherow) - William Groves 6. Other Items PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), litigation; ORS 192.660(2xd), labor negotiations; or ORS 192.660(2) (b), personnel issues. Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. Ifyou have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. ,b - ~ I ~ A S N ~ .dJ " ` V 0 -1 _ rv r izz o .9 ^vn N c , j j N N h 1 3 c 3 0 r I j ct O a~ Z v c~ r. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 25, 2013 (1) Monthly Investment Report (2) January 2013 Financials T C7 Q N d ' ~ ( V P07 0 C4 v } C N = Co Co EA N d ~ N S1 n r H CD In 7 U. N N u7 (O C ti r M N ti eo c FR M1 a o C N N N O a O E V M el U C F d C d ER a► E~ z LL 4 u1 0 d) C E 7 = Z O O N O 0 U E 0 ~-S m 0 m c E w E co o a J ~ C C io (Yo O c H v C7 e eeee e c cm 4 to cm O O O O ' cm OmNOmC> " C> Hf Wn O N Ci O r CIO co co n to 0 M rn O O ' V OD ' OD ' N at M V (D o W v r CD co co I- m (D CD r r @9 r Jp _a • C N N (0 m CL U) cn ~ C t N O. ' N a ~z°O N o ~C ) - ¢ a _ E2 0 c E oUH a) ca (D U) 41 m in O O O cc C7 U U H7-i L j- H dcasument Reproduces Poorly (Archived) o N .3 0) Wr H O C c 2 O O 2 2 w qt V- N e e 0 a e e e a at ~ O Q N N N C) ('9 w E ' u, m Q) - CL cn U) o (D E - W Q) 0 C a 0 ca ' L U o C N U Z E C ro g d~ 0_ ~ C N E O N P L m~ 0 U 0~ J L W ° I ~ II tli G I C d E H MM W O IL O H N d) 2 . (D o C N ~ LL m co a_ W N J U o 0C EL z 0 r~ ~ I ~ N 4 4 C CD I U d U U U U U U U U U U U U U U p e p 04 m I :d _ Z _ Z _ Z _ Z _ Z Z Z z _ z Ca I Z _ Z Z ' O C>• i, p Lo LO O N O r ~ Z ! I O ¢ M I O O ~ r R NN CM9 1 LD O ¢ O . P] CO N O 0 O 0 C 0 M - ti Ci 1": C 0 LD 0 ) Lq A ~ Q N O Q d0 m r` f• rn ~ o) vi co N , u~ w M In N (D m fP, O N r-- M Co m ao u; N in O 00 tO ti M N m t- b In o O m . w 1~ CD N C r O I w^ M CD In N O 01 F N C~ Co CO fl O! 7 L Q 47 N Cp LO 47 O to N Q Q O C (D C7 Co N [r 1 V Q ¢ LL7 t- N Q1 O to N t~7 r M R Q IM1 (p N ip {4 l y r 0 r CV O O N l r r O Q - N N (D r Cp 17 O ¢ O C* O y r (y N N N I N N N r '1 m r r ¢ h M (P M r y - Co LO b Q O ¢ I Co r-- O (D O O (1"l N Q O I Q O ¢ Q M M ¢ Q O' O O 0) (~7 Q7 n M O Cl! l 1• co pp O CCpp pp~~ d1 N ~l] u, O O M m U') v N 47 f• Q N Q Co Q (D W O w N r d ►J (D fD CD r q c0 r Q Ill N N O (C O C0; r CIt ep 41 O N N N Q LO O V P_ I O C1 Q C, It j ufi ti 0) Cm A Y r CO Q N N I b N l 0 i N O N r r c N I c; N r N N N C7'' _71 i 1 I (0 Cp ,00 0) Ln I C O pp O Q 0 0 0 0 O O O Q O Q b' ' O Co ti O C O O O ~t Q Q O O 0 a 0 O 0 O ¢ ¢ b pp 0 ' 0 0 0 0 0 0 0 0 0 Q L6, ¢ R~ ¢ M (D ! to j V O O O O Q O Q O p M O I V N 0 Q 0 Q nI V M Cp N N O Q Q N N O O ¢ O 0 O 0 vv m O O c O O ¢ N O Q j M N In V Q O C O CQO N N Q O r r O ~ N N p (D Q r- r N N N N N r N 1 r CD r r r M 1 O it I • ~ O. V) N7 D H C a . ~ a o d O O O O O O e e e o e o ~ T 6 d T U - " pp pp O p O 0 0 ¢ 0 (n 0 0 N 0 (l] (1 N In Q 0 Q 0 Q 0 N C q C w 410 O N y O ~ e~ +3 00 1- r Cr) (D In r Nt (D ct fl- R ( D 1~ t► (D N f0 L U ro m C } ar O O r - 16 Q Q Q Q ¢ b 0 0 0 4 C; 4 0 11 E 0) F- N LL o E tn :D 1 LL fn -A 11-- p CD LO C1 Ln CD C1 11~ LO CD U M 47 (n C; 1i M G i C 4) O I^ I . • r O ~ r 7 X0 m ' G1 1 I E ~ O I o a j c - ~ r I r c ! I j OD I- r-- Lo LO M CD CD C, It C, I p m n N m l n M n LO u c` O M rl M r~ N (n (^M ti M r- D E C ~ i z a ti uO O i I - ( h I (~7 '7 f~ h M M M l o t Q R V ~ I ~ C O I c . I T I r r I ~ I r~ ( 7 l0 M _ b N N C, r 0 m o o r r o I~ Q Q I lh I ~p l0 10 O M 1 (7 (a N aD m _ M (O (O ' 1l- m 0 0 0 l 0 , CD Q Q Q r 4 ¢ ¢ b . b I C1 0 3 ~ H H r r r r N ~ N ,I = r O UPS r ~ ~ b m lD I V a (d (`7 Co C. N y N r r N l(] Q N ( Q Q r Q N b r rn ¢ O N Q N b r bl N r b b 0 bl O' b a m11a m, LL m m z F- a 7 LL a a j 'Ix a a a a , i, m m U C,1 2 Y 1 .0. a v~ v, ~ v~ 3 m U C1 LL ~ - ed~i I ❑ Q Z! ❑ O ❑ ZI ❑ ❑ 1 - ❑ Q Z Z - l F LL U F- F- r U F- F- F - LL z F-F-I U I )Iueg W U z (n ¢ U 7 (n F- cn LL Z) LL ~ LL z Ul LL IS Z (n Z (n LL ~0- z U) ai E to LL Cl 11 = Z 47 m (D o = Co LO C7! U) d N ti t , M N ( p 3 f• N O M ] di E V a L` o v1 ❑ U U ❑ v N ! H p AC C y N C C I V L ( ❑ d U n ' ' l ~p 7 m M U) VJ ZJ O. 0 ~ fd 1 ' y O S U C o y U nl d i U m 7 N ~ C ' y C u (LL 1 D' a .2 ' ~U ~ y v N ( C m C 7 y c l Co o U o e- c (a ro [O ❑ U 4> ❑ U❑ , V . 4) ❑ y U) ~I ro 12 7 ro c m C 0 Q (d - z rn w C 7 d 0 LL (d CO p m V) U ! O Z Q m O N N N C ' c M Z (D ¢ (C ( 1 O a N (ytl ID 4 U C c V c c rt tS c j c' E ?E m a ❑ U ii L N e n U E, F- X m Cm . m c m m w m 6 0 Y 'r - CD I m p p i u) W (C (d L (C Co m O Co m U U = d LL of n (n . C] U l ~ H E O L C LL 21 Q N z d 7 ro -F l c IE CL N - (D E 7 f1 Co O 2 a, E L W .s "vi c o a) E 75 5 E r E w l C ° U a ~ cg ,r l cA Z) 2 UI D LL Q. ~ Z) 2 a C7; ' w _J w m a f- Memorandum Date: February 25, 2013 To: Board of County Commissioners Tom Anderson, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find January 2013 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 L Year End $ Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% $ 8,700,000 $ 9,059,394 $ 359,394 Revenues Tax Revenues - Current 11,778,410 18,660,711 6,882,301 58% 92% 20,191,560 20,416,485 224,925 Tax Revenues - Prior 396,667 851,224 454,557 58% 125% 680,000 877,835 197,835 Gen. Rev. - excl. Taxes 1,392,610 1,984,414 591,804 58% 83% a) 2,387,331 2,687,331 300,000 Assessor 436,699 675,147 238,448 58% 90% b) 748,626 873,626 125,000 County Clerk 805,013 944,658 139,645 58% 68% 1,380,023 1,620,023 240,000 BOPTA 7,232 13,313 6,081 58% 107% b) 12,398 18,313 5,915 District Attorney 107,738 84,573 (23,165) 58% 46% 184,694 184,694 - Finance/Tax 116,025 202,950 86,925 58% 102% b) 198,900 242,950 44,050 Veterans 39,900 18,887 (21,013) 58% 28% c) 68,400 68,400 - Property Management 57,892 54,976 (2,916) 58% 55% 99,244 99,244 - Grant Projects 1,167 1,167 (0) 58% 58% 2,000 2,000 - Total Revenues 15,139,353 23,492,018 8,352,665 58% 91% 25,953,176 27,090,901 1,137,725 TOTAL RESOURCES 23,839,353 32,551,413 8,712,060 58% 94% 34,653,176 36,150,295 1,497,119 REQUIREMENTS: Exp. Expenditures Assessor 2,081,189 1,956,593 124,596 58% 55% 3,567,752 3,467,752 100,000 County Clerk 856,122 770,361 85,761 58% 52% 1,467,638 1,361,638 106,000 BOPTA 42,225 31,536 10,689 58% 44% 72,385 72,385 - District Attorney 3,076,889 2,913,027 163,862 58% 55% 5,274,667 5,124,667 150,000 Finance/Tax 486,421 479,603 6,818 58% 58% 833,865 833,865 - Veterans 152,245 142,364 9,881 58% 55% 260,992 260,992 - Property Management 158,682 156,120 2,562 58% 57% 272,027 272,027 - Grant Projects 71,370 68,936 2,434 58% 56% 122,349 122,349 - Non-Departmental 1,000,225 587,339 412,886 58% 34% d) 1,714,671 1,414,671 300,000 Contingency 4,456,771 4,456,771 58% n/a 7,640,178 - 7,640,178 12,382,139 7,105,880 5,276,259 58% 33% 21,226,524 12,930,346 8,296,178 Transfers Out 7,616,380 7,568,709 47,671 58% 58% 13,056,652 13,056,652 - TOTAL REQUIREMENTS 19,998,519 14,674,589 5,323,930 58% 43% 34,283,176 25,986,998 8,296,178 NET (Resources - Requirements) 3,840,835 17,876,824 14,035,990 e) 370,000 10,163,297 9,793,297 a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes three quarters - July, October & January c) State payment received quarterly. YTD includes one quarter d) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013 and is projected to be $300,000 less than budgeted due to available Transient Room Tax revenues e) Appropriation Transfers (authority to expend): County School Fund $360,000, Grant Fund $10,000 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Seven Months Ended January 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065-Court Assess. Jail Funding HB #2712 Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants - Private CFC Interfund Grant Interfund Grant - Gen Fund Total Revenues Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 1,010,415 $ 995,051 $ (15,364) 100% 98% $ 1,010,415 $ 995,051 $ (15,364) 3,500 - (3,500) 58% 0% a) 6,000 6,000 - 2,256 4,555 2,299 58% 118% b) 3,867 6,655 2,788 - 18,707 18,707 58% 41% b) 46,133 46,133 - 7,583 5,468 (2,115) 58% 42% 13,000 10,000 (3,000) 12,250 14,010 1,760 58% 67% c) 21,000 28,000 7,000 218,952 188,030 (30,922) 58% 50% d) 375,347 375,347 - 35,000 90,240 55,240 58% 150% c) 60,000 150,000 90,000 58 - (58) 58% 0% 100 100 - 71,167 41,479 (29,688) 58% 34% e) 122,000 100,000 (22,000) 117 - (117) 58% 0% 200 200 - 29 - (29) 58% 0% 50 50 - 583 275 (308) 58% 28% 1,000 1,000 - 4,667 3,676 (991) 58% 46% 8,000 6,200 (1,800) 700 600 (100) 58% 50% 1,200 1,200 - 292 1,036 744 58% 207% c) 500 1,500 1,000 73,302 60,731 (12,572) 58% 48% f) 125,661 125,661 - 11,667 10,000 (1,667) 58% 50% d) 20,000 20,000 - 442,123 438,806 (3,317) 58% 55% 804,058 878,046 73,988 Transfers In-General Fund 3,117,638 3,117,639 1 58% 58% 5,344,523 5,344,523 - TOTAL RESOURCES 4,570,176 4,551,496 (18,680) 58% 64% 7,158,996 7,217,620 58,624 REQUIREMENTS: Expenditures Community Justice-Juvenile Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 2,960,427 2,876,949 83,478 58% 57% g) 5,075,017 5,025,017 50,000 696,477 608,159 88,318 58% 51% g) 1,193,960 1,075,000 118,960 58 - 58 58% 0% 100 - 100 29,400 25,200 4,200 58% 50% h) 50,400 50,400 - 489,719 - 489,719 58% n/a 839,519 - 839,519 4,176,081 3,510,308 665,773 58% 49% 7,158,996 6,150,417 1,008,579 394,095 1,041,188 647,093 - 1,067,203 1,067,203 a) Grant payment anticipated in last quarter, pending completion of project. b) HB #2712 replaced SB #1065 effective January 1, 2012, c) Revenues trending higher than anticipated - $8,400 billing outstanding for inmate/prisoner housing. d) Payments received quarterly. e) Contract payment reimbursement request submitted monthly, received 1-2 months in arrears. f) Grant payments are generated by program activity during the school year and are received quarterly in arrears. g) Expenditures trending lower than anticipated. h) Transfers out recorded quarterly. Page 2 SHERIFF - Fund 255 Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 100% n/a $ - $ - $ - Revenues Law Enf Dist. Countywide 13,160,949 10,734,945 (2,426,004) 58% 48% * 22,561,626 18,854,105 (3,707,521) Law EnfDWRurral 8,424,32p 7,270,494 (1,1,530 58% 50% * 14,441,692_ 12,299,717 (2,141,975)_ Total Revenues 21,585,269 18,005,439 (3,579,830) 58% 49% 37,003,318 31,153,822 (5,849,496) TOTAL RESOURCES 21,585,269 18,005,439 (3,579,830) 58% 49% 37,003,318 31,153,822 (5,849,496) REQUIREMENTS: Exla. EXPENDITURES & TRANSFERS Sheriffs Division 1,320,451 1,322,287 (1,836) 58% 58% a) 2,263,630 2,263,630 - Civil 466,077 426,261 39,816 58% 53% b) 798,989 734,889 64,100 Automotive/Communications 1,054,346 1,191,053 (136,707) 58% 66% c) 1,807,450 1,807,450 - Investigations/Evidence 879,772 841,457 38,315 58% 56% 1,508,180 1,508,080 100 Patrol/Civil/Comm Supp 4,823,792 4,841,302 (17,510) 58% 59% b) 8,269,358 8,169,358 100,000 Records 418,610 411,581 7,029 58% 57% b) 717,617 677,517 40,100 Adult Jail 6,032,875 5,849,710 183,165 58% 57% d) 10,342,072 10,383,042 (40,970) Court Security 176,751 175,373 1,378 58% 58% 303,001 302,901 100 Emergency Services 113,478 107,471 6,007 58% 55% 194,533 194,433 100 Special Services Division 785,188 711,895 73,293 58% 53% 1,346,037 1,346,037 - Regional Work Center 1,553,462 1,456,486 96,976 58% 55% b) 2,663,078 2,532,978 130,100 Training Division 294,554 237,562 56,992 58% 47% 504,950 504,850 100 Other Law Enforcement Svcs 375,377 383,271 (7,894) 58% 60% 643,504 643,404 100 Non-Departmental 49,731 49,731 0 58% 58% 85,253 85,253 - Contingency 3,240,805 - 3,240,805 58% n/a 5,555,666 - 5,555,666 TOTAL REQUIREMENTS 21,585,269 18,005,439 3,579,830 58% 49% 37,003,318 31,153,822 5,849,496 NET (Resources - Requirements) - - - * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Retiree health insurance expenses will exceed amount originally budgeted for the year. Appropriation will be increased b) Projected variance due to delays in filling open positions c) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund, expended in July 2012 d) Projection includes $103,685 for four new Correction Technicians and $144,970 for additional bed rental expense less savings from open positions. Appropriation will be increased Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % I I - Budget I Projection Varian__ J RESOURCES: Beg. Net Working Capital $4,507,352 $ 5,883,963 $ 1,376,611 100% 131% $ 4,507,352 $5,883,963 $ 1,376,611 Tax Revenues - Current 8,975,015 14,251,393 5,276,378 58% 93% a) 15,385,740 15,475,169 89,429 Tax Revenues - Prior 256,667 624,696 368,029 58% 142% 440,000 624,696 184,696 Federal Grants & Reimb 17,500 24,510 7,010 58% 82% 30,000 24,510 (5,490) State Grant 43,167 73,325 30,158 58% 99% 74,000 140,448 66,448 Jail Funding HB 2712 - 18,707 18,707 58% n/a - 46,133 46,133 Transp, of State Wards 2,917 1,056 (1,861) 58% 21% 5,000 5,000 - SB 1145 863,328 1,109,993 246,665 58% 75% 1,479,991 1,479,991 - Prisoner Housing 29,167 97,817 68,650 58% 196% b) 50,000 178,817 128,817 Des. Cty Video Lottery Grant 2,917 5,000 2,083 58% 100% 5,000 5,000 - Des Cty Court Security 140,583 68,015 (72,569) 58% 28% 241,000 116,597 (124,403) Des Cty Juvenile Contract 2,438 3,462 1,024 58% 83% 4,180 4,180 - Title III Reimbursement - 26,795 26,795 58% n/a c) - 39,916 39,916 Transport 292 1,126 834 58% 225% 500 1,500 1,000 Other 2,042 7,288 5,246 58% 208% 3,500 7,288 3,788 DC Fair & Expo Center 2,333 756 (1,577) 58% 19% 4,000 4,000 - Inmate Commissary Fees 5,833 12,069 6,236 58% 121% 10,000 15,000 5,000 Work Center Work Crews 29,167 30,605 1,438 58% 61% 50,000 50,000 - Concealed Handgun Classes 2,042 5,200 3,158 58% 149% 3,500 8,000 4,500 Inmate Telephone Fee 46,667 42,060 (4,607) 58% 53% 80,000 80,000 - Soc Sec Incentive-Fed 2,917 8,000 5,083 58% 160% 5,000 8,000 3,000 Miscellaneous 2,917 4,140 1,223 58% 83% 5,000 5,000 - Oregon Mentors 583 - (583) 58% 0% 1,000 1,000 - Debit Card Fee 58 285 227 58% 285% 100 500 400 Medical Services Reimb 7,583 7,113 (470) 58% 55% 13,000 13,000 - Restitution 2,917 - (2,917) 58% 0% 5,000 5,000 - Sheriff Fees 145,833 153,164 7,331 58% 61% 250,000 250,000 - Interest 16,528 23,139 6,611 58% 82% 28,333 39,666 11,333 Interest on Unsegregated 2,061 1,109 (952) 58% 31% 3,533 3,533 - Donations - "Shop with a Cop" 30,273 50,290 20,017 58% 97% 51,897 51,897 - Grants - 3,000 3,000 58% n/a - 3,000 3,000 Sale of Reportable Assets 2,917 574 2,343 58% 11% 5,000 5,000 - Total Revenues 10,636,662 16 654,687 6,018,025 50% 91% 18,234,274 18,691,841 457,567 TOTAL RESOURCES 15,144,014 22,538,649 7,394,635 58% 99% 22,741,626 24,575,803 1,834,177 REQUIREMENTS: Exp. Fund 255 Departments: Sheriffs Services 1,232,733 1,234,447 (1,714) 58% 58% 2,113,257 2,113,257 - Civil 466,077 426,261 39,816 58% 53% 798,989 734,889 64,100 Auto/Comm 388,790 439,201 (50,411) 58% 66% 666,497 666,497 - Adult Jail 6,032,875 5,849,710 183,165 58% 57% 10,342,072 10,383,042 (40,970) Court Security 176,751 175,373 1,377 58% 58% 303,001 302,901 100 Emergency Services 113,478 107,471 6,006 58% 55% 194,533 194,433 100 Special Services 543,303 492,588 50,715 58% 53% 931,377 931,377 - Work Center 1,553,462 1,456,486 96,976 58% 55% 2,663,078 2,532,978 130,100 Training 180,061 145,222 34,839 58% 47% 308,676 308,615 61 Other (CODE, Forensic) 375,377 383,271 (7,894) 58% 60% 643,504 643,404 100 Nan Dept - ISF Charges 24,915 24,915 (0) 58% 58% 42,712 42,712 - Contingency 2,073,126 - 2,073,126 58% n/a 3,553,930 - 3,553,930 Total to frond 255 S,1 , 9 9 10,734,945 2,42+6, " 2 ;561;.2 . 1 , 54,106 521 5,W?, Transfer to Reserve Fund (703) 58,333 100,000 (41,667) 58% 100% 100,000 100,000 - Non Dept - Comm System Res 46,667 80,000 33,333 58% 100% 80,000 80,000 - Total Requirements 13,265,949 10,914,945 2,351,002 58% 48% 22,741,626 19,034,105 3,707,521 Net 1,878,066 11,623,704 9,745,639 - 5,541,698 5,541,698 a) Current year taxes due November, February and May b) Reimbursement from the State will exceed plan due to higher number of SB 395 inmates c) Approved carryover of prior year Title III funds * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. Page 4 Fund 702 LED Rural Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date J FY 2013 Year End Budget Actual I Variance I FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 2,859,915 $ 3,244,571 $ 384,656 100% 113% $ 2,859,915 $ 3,244,571 $ 384,656 Revenues Tax Revenues - Current 4,404,167 6,938,293 2,534,126 58% 92% a) 7,550,000 7,534,089 (15,911) Tax Revenues - Prior 134,167 309,474 175,307 58% 135% 230,000 309,474 79,474 Federal Grants & Reimb 8,750 24,374 15,624 58% 162% 15,000 24,374 9,374 Federal Grants-BLM 15,167 6,233 (8,935) 58% 24% 26,000 26,000 - US Forest Service 43,750 39,375 (4,375) 58% 53% 75,000 75,000 Bureau of Reclamation 15,167 9,386 (5,781) 58% 36% 26,000 26,000 - State Grant 110,363 174,383 64,020 58% 92% 189,194 262,800 73,606 SB #1065 Court Assessment 32,083 4,555 (27,528) 58% 8% 55,000 4,555 (50,445) Marine Board License Fee 82,886 51,770 (31,116) 58% 36% 142,091 142,091 - Des Cty General Fund Grant 336,429 - (336,429) 58% 0% b) 576,735 576,735 - Des Cty Transient Room Tax 1,209,405 1,209,405 (0) 58% 58% 2,073,265 2,073,265 - Des Cty Tax Office Contract 292 540 248 58% 108% 500 540 40 City of Sisters 272,977 273,077 100 58% 58% 467,960 467,960 - Des Cty CDD Contract 31,714 31,714 (0) 58% 58% 54,366 54,366 - Des Cty Solid Waste Contr 31,714 31,714 (0) 58% 58% 54,366 54,366 Des Cty Clerk/Election 583 995 412 58% 99% 1,000 1,000 School Districts 23,333 15,141 (8,192) 58% 38% 40,000 40,000 - Claims Reimbursement - 324 324 58% n/a - 324 324 Security & Traffic Reimb 2,917 - (2,917) 58% 0% 5,000 5,000 - Seat Belt Program 5,833 3,360 (2,473) 58% 34% 10,000 10,000 - Miscellaneous 3,500 7,460 3,960 58% 124% 6,000 8,000 2,000 False Alarm Fees 1,167 2,700 1,533 58% 135% 2,000 4,000 2,000 Restitution 2,917 1,227 (1,691) 58% 25% 5,000 5,000 - Sheriff Fees 5,833 5,899 66 58% 59% 10,000 10,000 Court Fines & Fees 70,000 65,618 (4,382) 58% 55% 120,000 120,000 Impound Fees 2,333 3,200 867 58% 80% 4,000 4,000 Restitution - Street Crimes 292 - (292) 58% 0% 500 500 - Seizure/Forfeiture 583 140 (443) 58% 14% 1,000 1,000 - Interest 5,833 10,266 4,433 58% 103% 10,000 17,500 7,500 Interest on Unsegregated 1,050 542 (508) 58% 30% 1,800 1,800 - Grants-Private - 6,500 6,500 58% n/a - 6,500 6,500 Donations - 4,120 4,120 58% n/a - 4,120 4,120 Sale of Equip & Material 5,833 2,004 (3,829) 58% 20% 10,000 5,000 (5,000) Sale of Reportable Assets 23,333 6,817 16,516 58% 17% _ 40,000 20,000 (20200) Total Revenues 6,884,372 9,240,605 2,356,234 50% 78% 11,801,777 11,895,360 93,583 TOTAL RESOURCES 9,744,287 12,485,175 2,740,890 50% 85% 14,661,692 15,139,930 478,238 REQUIREMENTS: Exp. Fund 255 Departments: Sheriffs Services 87,718 87,839 (122) 58% 58% 150,373 150,373 - Auto/Comm 665,556 751,852 (86,296) 58% 66% 1,140,953 1,140,953 - Investigations 879,772 841,457 38,315 58% 56% 1,508,180 1,508,080 100 Patrol 4,823,792 4,841,302 (17,510) 58% 59% 8,269,358 8,169,358 100,000 Records 418,610 411,581 7,029 58% 57% 717,617 677,517 40,100 Special Services 241,885 219,306 22,579 58% 53% 414,660 414,660 - Training 114,493 92,340 22,153 58% 47% 196,274 196,235 39 Non Dept - ISF Charges 24,816 24,816 (0) 58% 58% 42,541 42,541 - Contingency 1,167,679 - 1,167,679 58% n/a 2,001,736 - 2,001,736 _ _ _ _ t0t41 to Furtd 256 8.4930) 7' ! U.434 1, 14,A41, 12 ,7 7 2,1 4 1,9 f5 Transfer to Reserve Fund (704) 58,333 100,000 (41,667) 58% 100% 100,000 100,000 - Non Dept - Comm System Res 70,000 120,000 (50,000) 58% 100% 120,000 120,000 - Total Requirements 8,552,654 7,490,494 1,062,159 58% 51% 14,661,692 12,519,717 2,141,975 Net 1,191,633 4,994,681 3,803,048 - 2,620,213 2,620,213 a) Current year taxes due Novem ber, February and May b) Will be received June 2013 Page 5 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End I Budget Actual Variance FY % Coll. % I I Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,336,051 $ 1,327,199 $ (8,852) 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 583 8 (575) 58% 1% 1,000 1,000 - Federal Grant - 5,000 5,000 58% n/a - 5,000 5,000 Federal Grant (ARRA) 116,667 106,250 (10,417) 58% 53% 200,000 212,500 12,500 State Grant 1,700,037 1,567,878 (132,159) 58% 54% 2,914,349 2,934,303 19,954 Child Dev & Rehab Center 23,105 16,360 (6,745) 58% 41% a) 39,609 39,609 - State Miscellaneous 78,598 77,967 (631) 58% 58% a) 134,740 134,740 - OMAP 366,093 235,739 (130,354) 58% 38% 627,588 514,944 (112,644) Title 19 205 - (205) 58% n/a 352 - (352) Family Planning Exp Proj 320,833 224,928 (95,905) 58% 41% 550,000 550,000 - Local Grants 28,000 - (28,000) 58% 0% 48,000 55,200 7,200 Environmental Health-Water 53,783 36,132 (17,651) 58% 39% 92,200 92,200 - Contract Payments 60,556 68,648 8,092 58% n/a 103,810 158,354 54,544 Miscellaneous - 2,139 2,139 58% n/a - 3,000 3,000 Patient Insurance Fees 112,700 112,324 (376) 58% 58% 193,200 193,200 - Health Dept/Patient Fees 60,142 50,753 (9,389) 58% 49% 103,100 85,000 (18,100) Vital Records-Birth 23,917 19,780 (4,137) 58% 48% 41,000 35,000 (6,000) Vital Records-Death 58,333 61,400 3,067 58% 61% 100,000 100,000 - Environmental Health-Lic Fac 420,029 630,182 210,153 58% 88% b) 720,050 720,050 - Interest on Investments 7,000 3,142 (3,858) 58% 26% 12,000 5,400 (6,600) Donations 3,092 19,017 15,925 58% 359% 5,300 22,277 16,977 Interfund Contract 92,534 81,850 (10,684) 58% 52% 158,629 164,000 5,371 Administrative Fee 467 rv 467 (0) 58% 58% 800 800 - Total Revenues 3,526,674 3,319,965 (206,709) 58% 55% 6,045,727 6,026,577 (19,150) Transfers In-General Fund 1,370,460 1,370,460 - 58% 58% 2,349,357 2,349,357 - Transfers In-PH Res Fund 35,079 30,068 (5,011) 58% 50% 60,136 60,136 - Transfers In-Gen. Fund Other 37,975 32,550 (5,425) 58% 50% 65,100 65,100 - TOTAL RESOURCES 6,306,239 6,080,242 (225,997) 58% 62% 9,856,371 9,828,369 (28,002) REQUIREMENTS: Exp. °i° Expenditures Personnel Services 3,748,614 3,652,145 96,469 58% 57% 6,426,195 6,282,220 143,975 Materials and Services 1,244,303 1,130,316 113,987 58% 53% c) 2,133,090 2,136,883 (3,793) Capital Outlay 37,917 - 37,917 58% 0% d) 65,000 - 65,000 Transfers Out 91,700 78,600 13,100 58% 50% 157,200 157,200 - Contingency 627,017 - 627,017 58% n/a 1,074,886 - 1,074,886 TOTAL REQUIREMENTS 5,749,551 4,861,061 888,490 58% 49% 9,856,371 8,576,303 1,280,068 NET (Resources - Requirements) 556,688 1,219,180 662,492 - 1,252,066 1,252,066 a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan c) Projection includes grant related expenditures. Appropriation will be increased d) OCHIN System expenditure made in FY 2012 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants Federal Grant (ARRA) State Grants State Miscellaneous Adult Mental Health Initiative Title 19 Liquor Revenue School Districts Contract Payments Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Forfeitures Administrative Fee Interfund Contract-Gen Fund Total Revenues Year to Date Budget Actual Variance FY % Coll. % $3,320,968 $ 3,113,095 $ (207,873) 100% 3,792 3,505 (287) 93,333 71,834 (21,499) 26 50 24 147,204 67,702 (79,502) 37,188 - (37,188) 4,509,516 4,286,722 (222,794) 36,085 15,996 (20,089) 116,667 229,038 112,371 157,177 73,004 (84,173) 82,542 67,740 (14,802) 40,250 14,400 (25,850) - 34 34 - 5,552 5,552 51,060 62,195 11,135 554 1,109 555 14,583 11,989 (2,594) 10,792 7,625 (3,167) - 140 140 3,087,307 3,033,714 (53,593) 74,083 38,920 (35,1631 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 8,462,159 7,991,269 (470,890) 58% FY 2013 Year End Budget Pro'ection Variance 94% $ 3,320,968 $ 3,113,095 $ (207,873) 54% 6,500 6,500 - 45% 160,000 125,056 (34,944) 111% 45 100 55 27% a) 252,349 252,349 - 0% 63,750 63,750 - 55% b) 7,730,599 7,883,477 152,878 26% 61,860 61,860 - 115% 200,000 230,000 30,000 27% 269,446 269,446 - 48% 141,500 141,500 - 21% C) 69,000 14,400 (54,600) n/a - 1,000 1,000 n/a - 7,000 7,000 71% 87,532 130,000 42,468 117% 950 1,500 550 48% 25,000 20,500 (4,500) 41% 18,500 18,500 - n/a - 140 140 57% 5,292,527 5,292,527 - 31% a) 127,000 127,000 - 55% 14,506,558 14,646,605 140,047 Transfers In-General Fund 762,876 762,876 0.25 58% 58% 1,307,787 1,307,787 - Transfers In-OHP-CDO 282,622 282,622 (1) 58% 58% 484,494 484,494 - Transfers In-Acute Care Svcs 154,370 154,371 1 58% 58% 264,631 264,631 - Transfers In-ABHA 305,689 305,690 1 58% 58% 524,039 524,039 - TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 13,288,684 12,609,922 (678,761) 58% 62% 20,408,477 20,340,651 (67,826) Exp. 6,662,861 6,263,873 398,988 58% 55% d) 11,422,048 10,800,000 622,048 3,846,637 2,832,891 1,013,746 58% 43% 6,594,235 5,850,000 744,235 29,225 19,645 9,580 58% 39% 50,100 30,000 20,100 119,000 102,000 17,000 58% 50% 204,000 204,000 - 1,247,222 - 1,247,222 58% n/a 2,138,094 - 2,138,094 11,904,945 9,218,410 2,686,535 58% 45% 20,406,477 16,884,000 3,524,477 1,383,739 3,391,513 2,007,774 - 3,456,651 3,456,651 a) Received quarterly, in arrears b) Oregon Health Authority grant projected at amended contract amount c) Services to school districts commence at start of school year and are billed monthly in arrears d) "On-Call" forecasted to exceed amount budgeted. Appropriation will be increased Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Seven Months Ended January 31, 2013 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 Transfers In General Fund - Gen Ops General Fund - L/R Planning A&T Reserve (D/S assistance) Other TOTAL RESOURCES Year to Date FY 2013 Year End Budget Actual Variance FY% Coll. % Budget Pmjection Variance $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 12,886 17,968 5,082 58% 81% 22,090 22,090 - 729 355 (374) 58% 28% a) 1,250 1,250 - 96,950 116,444 19,494 58% 70% 166,200 166,200 - 742,919 729,495 (13,424) 58% 57% 1,273,575 1,273,575 - 149,333 170,376 21,043 58% 67% 256,000 256,000 - 65,100 74,298 9,198 58% 67% 111,600 111,600 - 182,566 161,628 (20,938) 58% 52% 312,971 312,971 - 371,788 378,390 6,602 58% 59% 637,350 637,350 - 132,079 160,416 28,337 58% 71% 226,421 226,421 - 1,754,350 1,809,371 55,021 58% 60% 3,007,457 3,007,457 - 498,673 498,673 - 58% 58% 854,872 854,872 - 288,960 288,960 - 58% 58% 495,360 495,360 - 52,253 85,409 33,156 58% 95% 89,577 89,577 - 58 - _ (58) 58% 0% 100 - 100 2,604,294 2,874,895 270,601 58% 64% 4,457,366 4,639,748 182,382 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 789,360 772,307 17,053 Admin-GIS 68,704 66,264 2,440 Admin-Cade Enforcement 133,540 122,378 11,162 Building Safety 362,301 360,289 2,012 Electrical 118,551 116,845 1,706 Contract Services 82,685 88,202 (5,517) Env Health-On Site Pgm 93,121 89,741 3,380 Planning-Current 374,684 332,680 42,004 Planning-Long Range 270,317 227,993 42,324 Transfers Out (D/S Fund) 104,507 170,818 (66,311) Contingency 202,361 - 202,361 Exp. 58% 57% b) 1,353,189 1,311,323 41,866 58% 56% 117,778 117,778 - 58% 53% b) 228,925 216,747 12,178 58% 58% 621,087 621,087 - 58% 57% 203,231 203,231 - 58% 62% 141,745 141,745 - 58% 56% 159,636 159,636 - 58% 52% c) 642,315 634,887 7,428 58% 49% c,d) 463,401 349,567 113,834 58% 95% 179,155 179,155 - 58% n/a 346,904 - 346,904 TOTAL REQUIREMENTS 2,600,131 2,347,515 252,616 58% 53% NET (Resources - Requirements) 4,163 527,379 523,216 Revenues 1,809,371 Expenditures 2,347,515 Net from Operations (538,145 4,457,366 3,935,156 522,210 - 704,592 704,592 3,007,457 3,007,457 - 4,457,366 3,935,156 522,210 (1,449,909) (927,699) 522,210 a) Revenue is sporadic throughout the year as GIS services are requested. b) Reflects savings due to CD Directors appointment as Interim County Administrator through 6/30/13. c) Reflects savings due to Planning Director's reduced allocation through 6/30/13 while serving as Interim CD Director d) Reflects savings from retired employee; position is not expected to be refilled Page 8 ROAD Statement of Financial Operating Data Seven Months Ended January 31, 2013 RESOURCES: Beg. Net Working Capital Revenues System Development Charge Federal Grant (ARRA) Mineral Lease Royalties Forest Receipts State Miscellaneous Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SDC) Miscellaneous Road Vacations Interest on Investments Interfund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Forester Car Washes Car Rental Sale of Equip & Material Total Revenues Trans In - Solid Waste Trans In - Transp SDC Trans In-Road Imp Res TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 4,719,551 $ 4,723,852 $ 4,301 100% 100% $ 4,719,551 $ 4,723,852 $ 4,301 - 1,155 1,155 58% n/a - 1,200 1,200 4,083 7,335 3,252 58% 105% 7,000 10,000 3,000 23,333 28,750 5,417 58% 72% 40,000 40,000 - 231,482 1,265,121 1,033,639 58% 319% a) 396,826 1,265,121 868,295 316,336 542,290 225,954 58% 100% b) 542,290 542,290 - 6,294,192 6,305,131 10,939 58% 58% c) 10,790,043 10,450,000 (340,043) 14,583 - (14,583) 58% 0% d) 25,000 25,000 - 204,167 10,807 (193,360) 58% 3% d) 350,000 350,000 - 5,833 - (5,833) 58% 0% d) 10,000 10,000 - 5,833 10,000 4,167 58% 100% d) 10,000 10,000 - - 1,689 1,689 58% n/a - 2,000 2,000 11,667 14,894 3,227 58% 74% 20,000 20,000 - 583 - (583) 58% 0% 1,000 1,000 - 8,750 16,962 8,212 58% 113% 15,000 16,962 1,962 402,500 - (402,500) 58% 0% e) 690,000 590,000 (100,000) 128,333 125,455 (2,878) 58% 57% 220,000 220,000 - 52,500 - (52,500) 58% 0% e) 90,000 80,000 (10,000) 5,833 - (5,833) 58% 0% f) 10,000 - (10,000) 14,583 - (14,583) 58% 0% e) 25,000 50,000 25,000 14,583 - (14,583) 58% 0% e) 25,000 25,000 - 2,333 1,594 (739) 58% 40% 4,000 4,000 - 583 284 (299) 58% 28% 1,000 1,000 - 422,100 556,028 133,928 58% 77% 723,600 723,600 - 8,164,190 8,887,496 723,306 58% 64% 13,995,759 14,437,173 441,414 161,159 138,136 (23,023) 58% 50% g) 276,272 276,272 - 145,833 - (145,833) 58% 0% f) 250,000 - (250,000) 7,000 - 7,000 58% 0% f) 12,000 - (12,000) 13,197,733 13,749,483 697,583 58% 69% 19,253,582 19,437,297 183,715 Exp. 19,253,582 13,780,072 5,473,510 3,129,701 3,144,495 (14,794) 58% 59% h) 5,365,202 5,299,523 65,679 5,505,886 3,745,468 1,760,418 58% 40% 1) 9,438,662 8,131,549 1,307,113 1,188,425 9,233 1,179,192 58% 0% j) 2,037,300 74,000 1,963,300 160,417 - 160,417 58% 0% 275,000 275,000 - 1,246,827 - 1,246,827 58% n/a 2,137,418 - 2,137,418 5,657,225 5,657,225 11,231,256 6,899,196 4,332,060 58% 36% 1,966,477 6,850,287 5,029,643 a) Payment received annually in January b) Payment received annually in October c) Actual receipts are lower than projections d) Billed upon completion of work e) Payments to be received in June 2013 from other Road Department funds f) No SDC qualifying projects in FY 2013; no resources will be transferred in from SDC fund. g) Payments made quarterly h) Retro COLA raises for 701 members, early retirement and resignations i) Expenditures are seasonal and higher during summer months j) GIP project reserve carry over FY 2014 Page 9 ADULT PAROLE S PROBATION Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 570,000 $ 630,226 $ 60,226 100% 111% $ 570,000 $ 630,226 $ 60,226 Revenues DOC Measure 57 127,890 219,240 91,350 58% 100% a) 219,240 219,240 - State Miscellaneous 2,509 - (2,509) 58% 0% b) 4,301 4,301 - Alternate Incarceration 8,750 - (8,750) 58% 0% c) 15,000 3,000 (12,000) State Subsidy 8,065 18,872 10,807 58% 136% d) 13,826 21,826 8,000 SB 1145 1,603,323 2,061,416 458,093 58% 75% d) 2,748,556 2,748,556 - Probation Work Crew Fees 13,125 7,608 (5,518) 58°x6 34% 22,500 14,180 (8,320) Miscellaneous 2,625 2,977 352 58% 66% 4,500 4,500 - Electronic Monitoring Fee 75,833 94,559 18,726 58% 73% 130,000 153,257 23,257 Probation Superv. Fees 110,833 102,042 (8,791) 58% 54% 190,000 172,380 (17,620) Interest on Investments 5,250 3,268 (1,982) 58% 36% 9,000 9,000 - Interfund - Sheriff 29,167 29,167 (0) 58% 58% 50,000 50,000 - Crime Prevention Grant 29,167 25,000 (4,167) 58% 50% d) 50,000 50,000 - CFC-Domestic Violence 43,652 28,785 14,867) 58% 38% d) 74,832 74,832 - Total Revenues 2,060,189 2,592,933 532,744 58% 73% 3,531,755 3,525,072 (6,683) Transfers In-General Fund 253,939 253,939 - 58% 58% 435,328 435,328 - TOTAL RESOURCES 2,884,128 3,477,098 592,970 58% 77% 4,537,083 4,590,626 53,543 REQUIREMENTS: Exp. Expenditures Personnel Services 1,803,253 1,708,539 94,714 58% 55% 3,091,291 3,041,291 50,000 Materials and Services 518,984 467,995 50,989 58% 53% 889,687 889,687 - Capital Outlay 58 - 58 58% 0% 100 - 100 Contingency 324,336 - 324,336 58% n/a 556,005 - 556,005 TOTAL, REQUIREMENTS 2,646,631 2,176,533 470,098 58% 48% 4,537,083 3,930,978 606,105 NET (Resources - Requirements) 237,497 1,300,565 1,063,068 - 659,648 659,648 a) Payment received annually in September b) Annual allocation normally received by end of calendar year c) Funds are specific to a certain population, which has been smaller than expected d) State/County invoiced quarterly Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 13 L Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 511,994 $ 567,120 $ 55,126 100% 111% $ 511,994 $ 567,120 $ 55,126 Revenues Federal Grants 116,341 132,015 15,674 58% 66% a) 199,441 251,856 52,415 Title IV - Family Sup/Pres 23,061 23,051 (10) 58% 58% 39,533 39,533 - HealthyStart Medicaid 49,583 21,456 (28,127) 58% 25% a) 85,000 60,000 (25,000) Youth Investment 114,857 95,433 (19,424) 58% 48% 196,898 196,897 (1) State Prevention Funds 28,071 46,839 18,768 58% 97% b) 48,122 58,022 9,900 HealthyStart /R-S-G 128,305 109,974 (18,331) 58% 50% 219,951 219,951 - OCCF Grant 244,881 198,165 (46,716) 58% 47% a) 419,796 391,940 (27,856) Charges for Svcs-Misc 4,667 1,953 (2,714) 58% 24% 8,000 4,000 (4,000) Program Fees - 4,591 4,591 58% n/a - 4,591 4,591 Court Fines & Fees 46,366 43,277 (3,089) 58% 54% c) 79,485 75,034 (4,451) Interest on Investments 583 2,150 1,567 58% 215% 1,000 5,000 4,000 Grants, Private 1,167 - (1,167) 58% n/a 2,000 - (2,000) Interfund Grants 187,177 135,000 52,177 58% 42% d) 320,874 350,374 29,500 Total Revenues 945,059 813,904 (131,155) 58% 50% 1,620,100 1,657,198 37,098 Trans from General Fund 160,999 161,000 1 58% 58% 275,984 275,984 - Total Transfers In 160,999 161,000 1 58% 58% 275,984 275,984 - TOTAL RESOURCES 1,618,052 1,542,025 (76,027) 58% 64% 2,408,078 2,500,303 92,225 REQUIREMENTS: Exp. Expenditures Personnel Services 377,693 339,193 38,500 58% 52% e) 647,474 589,457 58,017 Materials and Services 860,998 686,516 174,482 58% 47% f) 1,475,997 1,537,247 (61,250) Capital Outlay 58 - 58 58% 0% 100 - 100 Contingency 165,962 - 165,962 58% n/a 284,507 284,507 TOTAL REQUIREMENTS 1,404,711 1,025,709 379,002 58% 43% 2,408,078 2,126,704 281,374 NET (Resources - Requirements) 213,341 516,316 302,975 - 373,599 373,599 a) Projection based on actual awarded amounts b) Additional GLS grant funds of $3,500 awarded c) State reduced the Circuit Court fees d) Additional grant funds of $17,500 - A & D 70 and $12,000 EUDL projected to be received e) Personnel expenditures projected to be less than appropriated. Open position, due to retirement, will not be filled f) M & S projected to be greater than originally budgeted due to new Federal grant awarded. Appropriation transfer will be requested Page 11 SOLID WASTE Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Call. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 Revenues Miscellaneous 12,833 10,845 (1,988) 58% 49% 22,000 22,000 - Franchise 3% Fees 116,667 82,890 (33,777) 58% 41% a) 200,000 200,000 - Commercial Disp. Fees 501,667 563,632 61,965 58% 66% 860,000 900,000 40,000 Private Disposal Fees 766,500 787,033 20,533 58% 60% 1,314,000 1,320,000 6,000 Franchise Disposal Fees 2,333,333 2,398,382 65,049 58% 60% 4,000,000 4,050,000 50,000 Yard Debris 42,583 63,751 21,168 58% 87% b) 73,000 73,000 - Special Waste 14,583 60,680 46,097 58% 243% c) 25,000 70,000 45,000 Interest 4,375 4,749 374 58% 63% 7,500 7,500 - Leases 6,300 6,300 (0) 58% 58% 10,801 10,801 - Donations - 1,680 1,680 58% n/a - 1,680 1,680 Sale of Assets - 1,451 1,451 58% n/a - 1,451 1,451 Recyclables 26,250 26,743 493 58% 59% 45,000 45,000 - Total Revenues 3,825,091 4,008,136 183,045 58% 61% 6,557,301 6,701,432 144,131 TOTAL RESOURCES 4,525,604 4,815,607 290,002 58% 66% 7,257,814 7,508,903 251,089 REQUIREMENTS Exp. Expenditures Personnel Services 1,011,104 968,953 42,151 58% 56% 1,733,321 1,733,321 - Materials and Services 1,743,766 1,446,958 296,808 58% 48% d) 2,989,313 2,989,313 - Debt Service 552,249 405,589 146,660 58% 43% e) 946,713 946,713 - Capital Outlay 48,417 58,768 (10,351) 58% 71% f) 83,000 83,000 - Transfers Out Road 161,159 138,136 23,023 58% 50% g) 276,272 276,272 - Capital Reserve 367,500 630,000 (262,500) 58% 100% h) 630,000 630,000 - Contingency 349,530 - 349,530 58% n/a 599,195 599,195, TOTAL REQUIREMENTS 4,233,725 3,648,404 585,321 58% 50% 7,257,814 6,658,619 599,195 NET (Resources - Requirements) 291,879 1,167,202 875,323 - 850,284 850,284 a) Due April 15, 2013 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Purchasing will pick up as year progresses e) Semi-Annual: November and May f) In the process of contacting bidders g) Quarterly h) All of FY 2013 budgeted transfer made because resources needed for Fund 613's capital projects. Page 12 RISK MANAGEMENT Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date Year End Bud et Prdection Variance Budget Actual Variance % of FY % Coll. I _ ~ RESOURCES: Beginning Net Working Capital $2,000,000 $2,240,791 $240,791 Revenues Inter-fund Charges: General Liability 153,028 153,028 0 Property Damage 182,863 182,863 0 Vehicle 101,287 101,287 (0) Workers' Compensation 840,103 840,103 0 Unemployment 145,833 145,922 89 Claims Reimb-Workers' Compensation 292 - (292) Claims Reimb-Gen Liab/Property 35,000 14,568 (20,432) Process Fee-Events/Parades 1,167 215 (952) Miscellaneous 29 37 8 Skid Car Training 9,333 15,090 5,757 NSF Fee - 30 30 Interest on Investments 8,750 6,880 (1,870) Other Interest 29 - (29) TOTAL REVENUES 1,477,714 1,460,023 (17,691) TOTAL RESOURCES 3,477,714 3,700,814 223,099 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement / Benefit 365,893 5202 Defense 37,481 5203 Professional Service 10,174 5204 Insurance 138,350 5205 Loss Prevention 8,232 5206 Miscellaneous 45 5207 Repair / Replacement 200 Total General Liability 175,000 560,375 (385,375) PROPERTY DAMAGE 5204 Insurance 159,171 5207 Repair / Replacement 41,463 Total Property Damage 145,833 200,634 (54,800) VEHICLE 5203 Professional Service - 5204 Insurance 366 5205 Loss Prevention 11,421 5207 Repair / Replacement 18,650 Total Vehicle 58,333 30,438 27,896 WORKERS' COMPENSATION 5201 Settlement / Benefit 233,874 5203 Professional Service - 5204 Insurance 98,178 5205 Loss Prevention 24,779 5206 Miscellaneous 22,086 Total Workers' Compensation 583,333 378,917 204,417 5201 UNEMPLOYMENT - Settlement/Benefits 1451833 93,403 52,430 Total Direct Insurance Costs 1,108,333 1,263,767 (155,433) Insurance Administration: Personnel Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET a) Annual premium paid in July 2012 " Contingency is $2,149,038 179,606 171,220 8,386 98,578 71,405 27,172 58 - 58 278,242 242,625 35,617 4,200 3,600 600 1,390,775 1,509,992 (119,217! 2,086,939 2,190,822 103,883 100% 112% $2,000,000 $2,240,791 $240,791 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 0% 58% 24% 58% 11% 58% 74% 58% 94% 58% n/a 58% 46% 58% 0% 58% 58% 58% 82% Ex . a) 58% 187% a) 58% 80% 58% 30% a) 262,333 262,333 313,480 313,480 - 173,635 173,635 1,440,176 1,440,176 250,000 250,000 - 500 500 - 60,000 60,000 - 2,000 2,000 - 50 50 - 16,000 16,000 _ - 60 60 15,000 12,000 (3,000) 50 50 - 2,533,224 2,530,284 (2t94A 4,533,224 4,771,075 237,851 300,000 725,000 (425,000) 250,000 230,000 20,000 100,000 60,000 40,000 58% 38% 1,000,000 600,000 400,000 58% 37% 250,000 230,000 20,000 58% 67% 1,900,000 1,845,000 55,000 58% 56% 307,896 307,896 - 58% 42% 168,990 168,990 - 58% 0% 100 - 100 58% 51% 476,986 476,886 100 58% 50% 7,200 7,200 - 58% 63% 2,384,186 2,329,086 55,100 * 2,149,038 2,441,989 292,951 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance % of FY % Coll. Budget PMection Variance RESOURCES: Beg. Net Working Capital $ 8,000,000 $ 8,883,086 $ 883,086 100% 111% $ 8,000,000 $ 8,883,086 $ 883,086 Revenues Property Taxes - Current 3,819,484 5,699,756 1,880,272 58% 87% a) 6,547,687 6,222,963 (324,724) Property Taxes - Prior 107,917 244,613 136,696 58% 132% 185,000 257,655 72,655 Federal Grants 140,000 - (140,000) 58% 0% b) 240,000 240,000 - State Reimbursement 21,000 12,113 (8,888) 58% 34% c) 36,000 36,000 - Telephone User Tax 437,500 192,602 (244,898) 58% 26% 750,000 750,000 - Data Network Reimb. 17,500 - (17,500) 58% 0% d) 30,000 30,000 - Jefferson County 17,500 27,294 9,794 58% 91% 30,000 31,262 1,262 User Fee 25,667 2,156 (23,511) 58% 5% e) 44,000 44,000 - Police RMS User Fees 162,721 187,031 24,310 58% 67% d) 278,950 278,950 - Contract Payments 18,083 - (18,083) 58% 0% d) 31,000 31,000 - Miscellaneous 5,250 4,600 (650) 58% 51% 9,000 9,000 - Claims Reimbursement - 46,760 46,760 58% n/a f) - 46,760 46,760 Interest 23,333 29,981 6,648 58% 75% 40,000 50,000 10,000 Interest on Unsegregated Tax 350 445 95 58% 74% 600 600 - Total Revenues 4,796,305 6,447,350 1,651,045 58% 78% 8,222,237 8,028,190 (194,047) TOTAL RESOURCES 12,796,305 15,330,436 2,534,131 58% 95% 16,222,237 16,911,276 689,039 REQUIREMENTS: % Exp. Expenditures Personnel Services 2,531,953 2,290,326 241,627 58% 53% 4,340,490 4,000,000 340,490 Materials and Services 1,195,951 1,089,352 106,599 58% 53% 2,050,202 2,050,202 - Capital Outlay 327,833 46,514 281,319 58% 8% 562,000 562,000 - Transfers Out-Reserve Fund 291,667 500,000 (208,333) 58% 100% g) 500,000 500,000 - Contingency 5,115,568 - 5,115,568 58% n/a 8,769,545 - 8,769,545 TOTAL REQUIREMENTS 9,462,972 3,926,191 5,536,781 58% 24% 16,222,237 7,112,202 9,110,035 NET (Resources - Requirements) 3,333,333 11,404,244 8,070,911 - 9,799,074 9,799,074 a) Current year taxes due November, February and May b) ODOT Project-reimbursements expected to be received over the next 3-4 months c) Nov/Dec payments outstanding; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance d) Annual billings to Police/Fire agencies mailed in January e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June f) Reimbursement for faulty UPS - American Power Conversion g) Amount appropriated was transferred September 15, 2012 Page 14 Health Benefits Trust Statement of Financial Operating Data Seven Months Ended January 31, 2013 Year to Date FY 2013 Budget Actual Variance FY % ]Coll. % Budget Projection Variance RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges PIT Emp - Add'I Prem Employee Prem Contribution COIC Retiree I COBRA Co-Pay Medical Services Reimb Prescription Rebates Claims Reimbursements Vending Machines (Wellness Rebate) Interest Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personnel Services (all depts) Materials & Services Claims Paid-Medical Claims Paid-Prescription Claims Paid-Dental/Vision Claims Refunds Insurance Premiums State Assessments Administration Fee Preferred Provider Fee Health Impact Refund - ERRP Other - Administration Other - Wellness Admin & Wellness Deschutes On-site Clinic Contracted Services Medical Supplies Equipment Other Total DOC Deschutes On-site Pharmacy Contracted Services Medication and Drugs Start Up Costs-Take Care Other Total Pharmacy Capital Outlay Contingency $13,800,000 $14,551,028 $ 751,028 100% 105% $ 13,800,000 $14,551,028 751,028 7,463,750 7,488,520 24,770 29,167 19,217 (9,950) 367,500 372,165 4,665 758,333 819,047 60,714 437,500 546,857 109,357 - 441 441 29,697 29,697 50,493 50,493 - 105 105 46,667 44,381 2( 285) 9,102,917 9,370,924 268,008 22,902,917 23,921,952 1,019,035 58"/ 59"/ 12,795,000 12,838,000 43,000 58% 38% 50,000 40,000 (10,000) 58% 59% 630,000 630,000 - 58% 63% 1,300,000 1,400,000 100,000 58% 73% 750,000 930,000 180,000 58% n/a - 441 441 58% n/a 29,697 29,697 58% n/a 50,493 50,493 58% n/a - 105 105 58% 55% 80,000 75,000 5,000 58% 60% 15,605,000 15,993,736 388,736 92% 104% 29,405,000 30,544,764 1,139,764 Exp. % 117,117 113,992 3,125 58% 57% 200,772 200,772 5,850,950 6,810,612 (959,662) 68% 68%a) 10,030,200 11,805,061 (1,774,861) 1,122,100 636,685 485,415 58% 33% a) 1,923,600 1,103,588 820,012 1,041,950 1,001,535 40,415 58% 56% a) 1,786,200 1,735,995 50,205 - (84,770) 84,770 58% n/a (84,770) 84,770 204,167 197,140 7,027 58% 56% 350,000 350,000 - 93,333 89,329 4,004 58% 56% 160,000 160,000 186,667 194,546 (7,879) 58% 61% 320,000 320,000 29,167 29,605 (439) 58% 59% 50,000 50,000 32,083 30,456 1,628 58% 55% 55,000 55,000 - 58,552 (58,552) 58% n1a b) - 58,552 (58,552) 38,123 31,799 6,323 58% 49% 65,353 65,353 61,250 15,984 45,266 58% 15% 105,000 105,000 8,659,789 9,011,474 (351,684) 58% 61% 14,845,353 15,723,778 (878,425) 399,000 436,127 (37,127) 58% 64% C) 684,000 750,000 (66,000) 17,500 6,298 11,202 58% 21% 30,000 20,000 10,000 583 1,511 (928) 58% 151% 11000 1,511 (511) 12,503 28,779 (16,277) 58% 134% 21,433 21,433 429,586 472,714 (43,128) 58% 64% 736,433 792,944 (56,511) 179,834 238,782 (58,948) 583,333 785,955 (202,621) - 59,898 59,898 91659 10,025 365 772,827 1,094,659 (321,832) 58 - 58 7,173,539 7,173,539 58% 77% c) 308,287 400,000 (91,713) 58% 79%C) 1,000,000 1,350,000 (350,000) 58% n/a c) - 59,898 (59,898) 58% n/a 16,559 16,559 58% Ma 1,324,846 1,826,457 (501,611) 58% n/a 100 - 100 58% n/a 12,297,496 12,297,496 TOTAL EXPEND/REQUIREMNTS 16,380,090 10,692,838 6,460,078 58% 36% 29,405,000 18,543,951 10,861,049 NET (Resources - Requirements) 6,522,827 13,229114 7,479114 12,000,813 12,000,813 Revenues less Expenditures (1,321,914) (2,550,214) a) Projection based on annualizing 30 weeks of claims paid b) Disallowance of Early Retiree Reinsurance Program items (Reported as revenue in FY 2012) c) YTD Actual include estimates: January administrative and "ingredient" costs. Also, start up costs for the pharmacy. These items had not been paid as of January 31, 2013. Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Seven Months Ended January 31, 2013 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personnel Services Materials and Services Debt Service Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Budget (7/12 of annual) Actual Variance I FY % Coll. Year End FY 2013 Budget Projection Variance $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) 354,421 156,177 (198,244) 58% 26% 607,578 429,177 (178,401) 875 30 (845) 58% 2% 1,500 655 (845) 33,507 13,844 (19,663) 58% 24% 57,441 36,844 (20,597) 3,500 - (3,500) 58% 0% 6,000 6,000 - 17,500 16,367 (1,133) 58% 55% 30,000 46,367 16,367 110,833 61,278 (49,555) 58% 32% 190,000 145,278 (44,722) 55,417 30,338 (25,079) 58% 32% 95,000 86,338 (8,662) 11,667 1,400 (10,267) 58% 7% 20,000 20,000 - 3,967 2,334 (1,633) 58% n/a 6,800 5,934 (866) 591,686 281,767 (309,919) 58% 28% 1,014,319 776,592 (237,727) 99,167 99,169 - 58% 58% 170,000 170,000 - 15,017 15,015 - 58% 58% 25,744 25,744 - 48,300 48,300 - 58% 58% 82,800 82,800 - 154,151 150,000 (4,151 58% 57% 264,259 207,000 (57,259 316,635 312,484 (4,151 542,803 485,544 57,259) 954,694 629,306 (325,389) 58% 39% 1,603,495 1,297,191 (306,304) Ex p. 485,265 470,217 15,048 58% 57% 831,882 816,873 15,009 295,297 278,913 16,383 58% 55% 506,223 511,031 (4,808) 66,569 70,609 (4,039) 58% 62% 114,119 114,119 - 8,318 9,000 (682) 58% 63% 14,259 9,000 5,259 855,448 828,739 26,710 1,466,483 1,451,023 15,460 79,924 - 79,924 58% n/a 137,012 - 137,012 935,372 828,739 106,633 58% 52% 1,603,495 1,451,023 152,472 19,322 (199,433) X218,755 153,832 153,832 Page 16 H w ti 0 a a a F a, d' U U c 0 0 z U . r, U a~ x as a~ a~ M O C N .a CY) m D N 7 ° C U N 4) 2 U) L :3 0) L 7 Q O ,L• U ~ r o C) CL Z U C M M M ("7 C N N N i j Cl) M r r M M Q Co C) (D Q C) r Q 0 V IA C7 C? Q Q C) Q O to C) C) M M N fl M O CO r C] r ID co I- to ' Q C) CS C) f,- n C) C] r Q (D r Q Q C) ' r 14 7 Q N Lc)- C7 M C) C) C] N Q le 4-) L M M Q N 1` r 1- N aD O N Q N Q C$ C) , CS V- d M M Nr Nr n LO d] u] MI - N t.T M r If1 r cr 117 ch Q "O N Q ~ N O r Q M C) C7 Q m o C) C] Q Q C) M Q m M co ti N b9 r C) r Q Q Ir IA a a C) C7 f,- ti C) C) U') O C) Q C) C3 V) ' r r C) r C7 CS O r ti it) co n Cl d -O C O C7 N Lf) Q M CS Q Q N C) r L6 In M L CS N 1• r N N aD O N O N C) C) Q M 91) r N n r ~ -D LL (C qtr ti an M LO IT M f• M LO M N M r 4l1 r M.4 9 T' N D N LY LI.. O U M Q Q M to r C) C) N co Q lw r C) C) (D Oj M Mt'- N O M C) M r M~ O Ill co m U -O ' C] C] C) lrj 1A N' M M N C) Q N N ' N 4" 7 ro d N LO CCD m ) In N tV (n co M r CD O) N N Q CD d Q N V) + C co C Ict 1{'7 w R) N N r r r r U Q > U C5 C C CS N C) C~ Cl N- C) (D I I I 16 O W N O U V' to N lD N N N CJ O C O 7 a L 2 2 U D O N U U (+M C) C) M w Q -t r C) M 1• (+M Q co C5 10 r C) Q r- CD ' O O C7 ((7 141 C7 W O) M ' M Q N N Q CS r M Q N N 111 ' N M V) C14 N .'L-•• N B C) 0 N C] CO co M N N 4d r` Q a) 3 C) N C] m co CS r ti C) C) Nr lqr ti qr 141 111 N }L-+ r r N r r r U- }i N N C U O d) O C d) N 4] c 'O U c c C) V ° (n 1 V 7 QN m L Ca (D L O co v v 0 ~ U rn U M d U ~ r ~ c 0) m v , Cf 0 'Y ° C a ❑ y C 7 IM V) co 0) ad _ CL " cn c 4i Li li to N~ W N CO @ O LD 'a 3 a ° i E E E U) W (DO ° v, ;r 3 :3 rn CD v 0 ; z 10 o 0 (D _ CO N M (D :3 m m C m j 3 i U vl C) U) O C O H Q5 4n go ca v L) c m 4U O p= c (D 0 - w aUi a°Di m a U) ~ ~ v O cu c' ° a w H y D c 4 L W IL w Z 4 C C (D C) ' + O s+ E es ' W CL a) In ° a H F - CL M o v U) ch U U) U) m LU (1) u; 4)i x m Q W s LL co J w U p N 0 N C 0: miwQ i- ~H- ul U M- a m~ U ~ CD Q C> O ~ lp ~ N N m O 0 000LO cCD w to c0 Q Ln 0 f- Lo Nr N~ h O I-- O) OD 1- 1~ tt7 C7 CO N Lc) d Ui cv r t-) M W C N 'Q 7 O E Q c o 0© C) a ti i C, E C OO F= 0 NN co E O CN U d z -0 w U- H ch rn ° a: N m C30 E Cf) m ❑ W 7 W 0 N O C 0„ N L =3 En C CL w (L o m 0) a) N a,t N 0 m U O E o O c 0 E Q E x s c v ❑ ~ o ` rn v) ❑ ca Z w e a- t c 0 U oa rn ❑ O c J c c E c U. Q Z C a) 0 7 0 c y 7 S O O 0co O E 9 ❑UW wmood)a1- 222 m o m m 4 0 2 Ad a$ 0 7 E E E 0 0 0 0" 2 2 2 Q Q Q Q 2 Q C7(DCD C)(~C1C7 0 (700 C?(?00 c7 m m m co co co co co w af Of of J J J J J J J r.l in mm mmmm m r 0 O O 9, N O O It O in N L a O c w ro a !d O H M It O (D N a M c C ~ U c U m N (a o D ~ o D CL U CC) to NIN CSco OON C(p04 C) 0) N aNM O O C7 06 LO O to Ca co C7 to O N C) N C] (O O ' O n co C7 co C7 'cY O qt Ln r w (a O co O co N O ( cq C) 0) N O N M O co O OD It ~ C) w N T . . . . L C7 co C) to N C) C14 C) 0) CM C) ca a N to O aD O OD It C7 OD r r 3 CL td U cm v r Y "C1 N O : V" H a+ N O, z c N o L c N 1 W 4 = im C U) a (1) 0 f O U) CO - U U) w 0 W (D Go li m H h ~ ch N C) 0) . Q N ['7 (O C7 C) M LO O O M O t•7 N C7 O N O O C7 t7) CD M co C7 C) C) I_ C7 C7 Cn C7 qq aD L6 Ln N r C? N r (D 1- r co (h c0O(D LOC)C7 O.- N C7 C7 O O O C) r O O d ' N C7 O' C7 I*: OD L(7 117 r O N M r• r (h t+7 r (a C) C? m co CA L+7 (O N N ' ~ Q C) L 01 ( r N r Lf) r- LO N 00 . . . . . . . . . Chi CS0)OD 01 mco Nr r Co O am 0 N co V' L ' O N V- LL7 N OD LO LO L17 If) c~ a~7 co co ILO Ul) Lo 1117 LO 117 N N LO LA LO LO 31 C) CD C7 m ti r N N L(7 Lo U") LO co co N N Ln LO 1q, v L(7 Ln to V N O U ~ U d U ~ ~ to ro N N N~ Q tl) C V 11 ¢ - O tT O 0) N m m U c U L (D 0) td rn to 0 0) tll CF) T 'C [1 LA co co O ¢ V Z c r (D"? U v 0 ro 3 0 CL a? L Co m a 2 (D- •L H (D H x m W a- U)s LLjmm mz ui g U M I~ O M co ' T CD co to ' IRO I co qt to qt to ' Im c" M to M co ' N T 0 O OD M V_ 3 7+ ~ U ~ c ~ CL rn~ c W •c - 0.9 U O I- Rt N O N . N G V_ O S M co N r 0 to N d O m z N T C: 7 LL C 7 LL w U N O L c U nom) _ c f0 E L c a) (D c E o U) (D U :3 0 N c N ~ L ~ L U N .0) T Q C) N t LL c C: U y' N ~ .r ~ L ~ O m (D L_ -O O 'm 4 U CL @ CD rZ (ND O C,0 ~ Q m .0 Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Lease Payments Total Revenues Transfers In: Project Development (140) Gen Capital Res (143) TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment TOTAL REQUIREMENTS Budget Actual Variance FY % Coll. % I Budget I Projection I Variance $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) 58,679 - (58,679) 58% 0% 100,592 - (100,592) 14,238 16,272 2,034 58% 67% 24,408 24,408 - 72,917 16,272 (56,645) 58% 13% 125,000 24,408 (100,592) 962,500 - (962,500) 58% 0% 1,650,000 - (1,650,000) 618,333 - (618,333 58% 0% 1,060,000 - 1,060,000 (1,056,250) (2,693,901) (1,637,651) 58% -2155% 125,000 (2,685,765) (100,765) Exp. % 14,583 8,773 5,810 58% 35% i9) 25,000 16,500 8,500 58,333 - 58,333 58% 0% 100,000 - 100,000 72,917 8,773 64,144 58% 7% 125,000 16,500 100,000 - (2,702,265) ~765~ NET (Resources - Requirements) (1,129,167) (2,702,674) (1,573,507) a) Interest on January 2013 negative cash balance: $1,322.39. b) Inception through January 31, 2013 Revenues - Lease Payments $ 65,088 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 249,849 Total expended 2,767,762 Net $(2,702,674) Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2013 BOCC Conference & Travel Jul T e Oct I Nov I Dec I Jan I YTD Total 0111111Y "IN Y - _ - 30 - - Educ/Trainin9 Cf/Sem & on . - _ . Travel Meals " . . Accommodations 1 7 , 127 - Airfare - - - Mileage reimbursement 384 790 Ground Trans ort/Parking - 35 { Total Baney - 566 790 30 10 65, _ 105 66 82 + 168 119 R " . r 246 6$3 557T 2414 , _ 35 87 - 704 2,968 Ton DeBone Conf/Sem & Educ/Tramm 30 - 15 470 35 1 560 Travel Meals - ~ 76-' - 76 Accommodations - - - 429 - - - - 429 Airfare - Mileage reimbursement - ~ - _ - 471 562 ; - _ 1,033 Ground Transport - - - - 19 - 1 Total Other 30 - 15 1,369 10 657 35 2,117 OCC Department otal - B _ _ Conf/Sem & Educ/Trainmg 125 15 775 20 - 16 5 9 100 - Travel Meals 20 66 76. 82 ! 244 Accommodations - _ 127 - 857_' 11 9 - - 1,104 Airfare ~ ment b _ 4 5 ,260 683 2 557 56 3,558 ort Ground Tans 3 19 54 Total - BOCC Department 125 678 15 2,893 888 657 804 6,060 - - FY 2013 Budget ti 15,250 Percent of FY 2013 Budget Expended 39.7% BOCC County College 8.5 ' Office/Copier Supplies _ 76 5 1 9 $69 I Meetin Supplies -._.._._._.r....~ 811 - 2,441 Total BOCC County College - 846 811 869 ? - -T 2 526 i I NOTE: Above amounts include only those expenditures processed for payment. Additional conference and travel costs may have been incurred, but not processed for payment. 1/28/2013 Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 25, 2013 (1) Monthly Investment Report (2) February 2013 Financials Docufn,'31 it Pr;PrO(juces Poorly (Archived) ° M © Goo O N to E I '1~1 N r 69 M ~ ~ C G Cp M M .J LL C 7 O O O O O C M T o CD d rS tC r- to d LL EA W o C) O Q1 01 E to W) 0 C r r d d 3 (a N► C Z LL C C E 0 c O V C E a C 7+ LO C ~ E CC G E 0 E 4 ) C ~ to d C C F" a~ C7 ae e aE aE at at a!, Q OP.- NOOO~ O O 01 M O O O 4 tl7 tLf 4 N o co O r co tt] m to (0 S co 'r , m to Cp ~ r CO r tD r N (O Q1 co r- M co to ~I M r r 9 144 to ~ (D a to d a iW a o r E mz w p~vU a a F- T c 01 0°U~ `m c E0 EEL 'Dea.`4 UU~-:5lim- H 0 cc 0 H C C' 0 2 co o N o e e e e ae e at MI) Q O M O O r r N N N T rn CL 0 E K U Q d w a CA g:3 m 0 z E C6 Q U 2 0 0 ~ e N N U CD o m d E c E E E N (6 U - ~ , cri u -j -coFQ ~ . o d Q A r+ C ? y E ¢ M U U) mo 7 m C E me a co m : U 0 . a w ~ y 0 0 ° ~ ~z 0 r- i i I ~ U % w 0 U Z U Z U z U Z U Z U Z U Z U I Z U Z U Z Cu U Z U Z U Z U Z IU Z o O A W N e7 O 4 C lA 4 O arc U 0 d d I 7 4 ui ui C7 C4 Q ap 4 Z 1 . [A cq O In Q! Co 14r ~ N N R m c~i CO O . p O d Q M M ti co O O O - O O o IN v it C7 v N a! O O In ao Cl lq In o 4] O! Co CA Q N CC Q n O n d M 'gr M C 1 O N CO M N In 0 O Go Q Co co O N n M n CO O O ~jN O m COO O CD cdl ~ n V Co N M r O I Y'^ M oc V V! c'! o! a In n In O qr h R 6 R ' co C! a 7 7 Y O lC7 N Cp ! If) O U., CA N M 0 O 0 m (D m co ' R cm R Q O R O Ch iO r Ifl N l CP C r - l{ ) co (D n D 1+ Co w c r d 7 ; r N O O N r r 0 0 r N N Co r N iC ) C 7 Cl 6 N C Q! - 1 C 'j N N N N N CA r iv M ) C r` M Co to C i T . . Q O O ti d Cl) o N Co T O 0 O d d Go CO C, P7 O Cp Q Q Q 6 ~ ' Co i M co M d O CA 11 r CD W 0 0 : N I Q N M tb to l w p ►J n O r O r,- C co Q In M t t co O C7 N Co 03 O Co r Co 'i n N Q! Q O N C j O N N N n Cl d N C ' n Co 4 N C) C 0 03 1 O Co Q O O O I N IA O! I O O W O O N N O Q d r r O d O C O O i R ;N V N CD Iri O F I _1 M N M j Cp I r N N CV C% N N N ' r l I I CD r M r r M M I , I N 1 0 Cl O 0 O 0 O 0 Q 0 O 0 O 0 pp C? O 0 O 0 o 0 0 9 O 0 o 0 0 o o O O N r M In h 4 C u O O V O o O Q o 0 o 0 O 0 Q O 0 O 0 O d O O ~ 0 CD O Lo n O O In N Iq O eF {p Q 0 Iv n q It Q o O 0 C O V w O O C j 0 ID O M Q1 N I O N I~ 0 O 0 4- O O m M ti o LD C' O C • O r lA Cp N r o N Q o 0 o It7 r O r l r 4 O d V r I r N ~ N O co V r In C O M N C9 M r N N N N c r N r l CA m m U C ! - r - - w CL c U) N - C m - c a 2 O U p o - n ` Q G p di a! e Q ~ Q o O o o o a d O o O O O ~ M O Lo o ! O - n e Q ~ o - a I ai M o o • • m _ Z N U Q F- d! m !n Y Co Co CO !te l17 r O M Co47 O 47 l[) Lo r P In Co N r 0 n 0 CD 0 n I 0' N N Lo (D m C o O r O Q 0 0 0 j 0 O CD O i 0 O CS C5 0 o E _ EL U d d F-- N C CL ~i • V V F- U) ❑ lL EU m - J w . C) O R M O Cpl o C6 iL6 uo d v c U 4) I ~ 'I i i I i d ~a a I Cl N 0 v « I t o o - • o m l~°E' ICI . . . C w r ~ IC] Lo d L N T'i N C g _ 6 o r7 n r ~ N ~ M n M n . ( M M n In M in Co U-) r- (n r l n~ ~ y ~ m m co m m rl M M m 7 d d In O gO O •C O Lo c. O! o`! v _ ti CD In M C Qm ~C`] co i r `v 0 f) Q In , g ~Q n O o r w 0 a 0 r- O co d cD Pl n' r a ' . DI 10 l0 Y v E g O o O O O Q O O r o O O O O d o Q O0 m l r N r N N N N N N M M t O Cp O m Cp Q1 Ill C1 d j N CD ;;I 1 III li ` C) CM N N N N O 1~1 O r Q O N n r M ~V C`] O Q. O O r I O p 7 O O O 4 C) r 0 C7 ~ S l d Q ~ V ~ m m W, Z N S N !sue ^ a ( J U S d U ) ) i co U U I L ~ F edAl 'o Q z ❑I ❑ ❑ Z ❑ ❑ ❑ Q Z ❑ ❑'Z ❑ F- LL U H H H U H H H LL U H F-'U F- w z Q CL LL LL w (LI Z J Z d 3: ' t LL ue 11 9 U Z U Vi cn ~ z 0 U) U), ~ EL = a) c LL o Q ~t C.) Z 6 7 E I ❑ M 00 ~ 7 Y c o G cnA cnA M l N (D III A n O rn CT rn C ) of Cp' CC) OI Z °D U+ o U CD co - - C ❑ ❑ U Z U ❑ ❑ ❑ I U) 0 Y c z y Y w L N (D ❑ U O U' EL J C m l~ fC6 m CC. :.s Q N N O y Q • c 'D c C (p Y C U U N U (D d m Lo co 7 N O y N 0 c0 N -C f V Co c Y m ❑ O C (p ❑ ❑ O ❑ U C ~ 12 S l0 C O U ~p •Z o c N d m 7 LL c co U e. m Co U W V) I II I U U co ' L-. Y m ~ l0 Y = C/) M Q O7 Q L 7 Q 7 Cb C 0 0 Z 0 w ca C Y U CC Y co LI Y C O O O -0 LL E CO ~ p NI CA C 7 r LL Lo E o (j N r ~ 01 a m _ 7 5 c O ' ` tq c U co c N a) I W Y G Y G r N m E m 7. E N U CO t o d L o V) - Y C E E • y y F- d E - ca X W o m. j - CA ca o C7 L _ CO I O C m m LLI I ' O o Co m CO o U o o U' Z eU Y d I • CL it 'n a ) d 1 Cn E D m CD m CO o C] o CJ ~ LL ~ F- W ❑ a~ 7 o o . LL L I L O m LL _ - a+ ~ Co Q N E E eT J o D o 0 1 c - - - - n m a l E °l a ~ E g o E ( a 9 = _ j ~ .E 0 a ~ cn rn ~ ~ T ~ IL t Memorandum Date: March 20, 2013 To: Board of County Commissioners Tom Anderson, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find February 2013 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Eight Months Ended February 28, 2013 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues TOTAL RESOURCES 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) Year to Date Budget Actual Variance FY % Coll. % $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% EXp. 13,461,040 19,617,452 6,156,412 67% 97% 20,191,560 20,774,199 453,333 922,486 469,153 67% 136% 680,000 950,988 1,591,554 2,045,386 453,832 67% 86% a) 2,387,331 2,687,331 499,084 677,376 178,292 67% 90% b) 748,626 873,626 920,015 1,060,762 140,747 67% 77% 1,380,023 1,620,023 8,265 13,313 5,048 67% 107% b) 12,398 18,313 123,129 99,527 (23,602) 67% 54% 184,694 184,694 132,600 208,592 75,992 67% 105% b) 198,900 248,592 45,600 37,324 (8,276) 67% 55% c) 68,400 68,400 66,163 62,829 (3,334) 67% 63% 99,244 99,244 1,333 1,333 0 67% 67% 2,000 2,000 17,302,116 24,746,382 7,444,266 67% 95% 25,953,176 27,527,410 26,002,116 33,805,776 7,803,660 67% 98% 2,378,501 2,240, 003 138,498 978,425 856,965 121,460 48,257 37,238 11,019 3,516,445 3,307,224 209,221 555,910 529,362 26,548 173,995 163,044 10,951 181,351 177,849 3,502 81,566 78,799 2,767 1,143,114 682,161 460,953 4,532,785 4,532,785 13,590,349 8,072,645 5,517,704 9,265,101 8,561,908 703,194 22,855,450 16,634,553 6,220,897 3,146,667 17,171, 223 14,024, 557 Beginning Net Working Capital per Requested Budget 9,000,000 a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes three quarters - July, October & January c) State payment received quarterly. YTD includes one quarter d) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013 and is projected to be $300,000 less than budgeted due to available Transient Room Tax revenues e) Appropriation Transfers (authority to expend): County School Fund $360,000, Grant Fund $10,000 FY 2013 Year End $ Budget Projection Variance $ 8,700,000 $ 9,059,394 $ 359,394 582,639 270,988 300,000 125,000 240,000 5,915 49,692 1,574,234 34,653,176 36,586,804 1,933,628 67% 63% 3,567,752 3,467,752 100,000 67% 58% 1,467,638 1,361,638 106,000 67% 51% 72,385 72,385 - 67% 63% 5,274,667 5,074,667 200,000 67% 63% 833,865 833,865 - 67% 62% 260,992 260,992 - 67% 65% 272,027 272,027 - 67% 64% 122,349 122,349 - 67% 40% d) 1,714,671 1,414,671 300,000 67% n/a 6,799,178 - 6,799,178 67% 40% 20,385,524 12,880,346 7,505,178 67% 62% 13,897,652 13,897,652 - 67% 49% 34,283,176 26,777,998 7,505,178 e) 370,000 9,808,806 9,438,806 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 1,010,415 $ 995,051 $ (15,364) 100% 98% $1,010,415 $ 995,051 $ (15,364) Revenues Federal Grants 4,000 - (4,000) 67% 0% a) 6,000 6,000 - SB #1065-Court Assess. 2,578 5,087 2,509 67% 132% b) 3,867 7,000 3,133 Jail Funding HB #2712 - 27,849 27,849 67% 60% b) 46,133 37,000 (9,133) Discovery Fee 8,667 5,488 (3,179) 67% 42% 13,000 8,232 (4,768) Food Subsidy 14,000 14,010 10 67% 67% c) 21,000 28,000 7,000 OYA Basic & Diversion 250,231 188,030 (62,201) 67% 50% d) 375,347 375,347 - Inmate/Prisoner Housing 40,000 94,920 54,920 67% 158% c) 60,000 140,000 80,000 Inmate Commissary Fees 67 - (67) 67% 0% 100 100 - Contract Payments 81,333 61,995 (19,338) 67% 51% e) 122,000 100,000 (22,000) Miscellaneous 133 52 (81) 67% 26% 200 200 - Program Fees 33 - (33) 67% 0% 50 50 - MIP Diversion Fees 667 275 (392) 67% 28% 1,000 500 (500) Interest on Investments 5,333 4,173 (1,160) 67% 52% 8,000 6,175 (1,825) Leases 800 800 - 67% 67% 1,200 1,200 - Grants - Private 333 1,201 868 67% 240% c) 500 1,500 1,000 CFC Interfund Grant 83,774 60,731 (23,044) 67% 48% f) 125,661 1257661 - Interfund Grant - Gen Fund 13,333 10,000 (3,333) 67% 50% d) 20,000 20,000 - Total Revenues 505,282 474,611 (30,671) 67% 59% 804,058 856,965 52,907 Transfers In-General Fund 3,563,016 3,563,016 - 67% 67% 5,344,523 5,344,523 - TOTAL RESOURCES 5,078,713 5,032,678 (46,035) 67% 70% 7,158,996 7,196,539 37,543 REQUIREMENTS: Exp. °i° Expenditures Community Justice-Juvenile Personnel Services 3,383,345 3,300,714 82,631 67% 65% g) 5,075,017 4,964,036 1107981 Materials and Services 795,973 685,602 110,371 67% 57% g) 1,193,960 1,050,000 143,960 Capital Outlay 67 - 67 67% 0% 100 - 100 Transfers Out 33,600 25,200 87400 67% 50% h) 50,400 50,400 - Contingency 559,679 - 559,679 67% n/a 839,519 - 8397519 TOTAL REQUIREMENTS 4,772,664 4,011,516 761,148 67% 56% 7,158,996 6,064,436 1,094,560 NET (Resources - Requirements) 306,049 1,021,161 715,112 - 1,132,103 1,132,103 Beginning Net Working Capital per Requested Budget 1,125,000 a) Grant payment anticipated in last quarter, pending completion of project. b) HB #2712 replaced SB #1065 effective January 1, 2012. c) Revenues trending higher than anticipated - $12,960 billing outstanding for inmate/prisoner housing. d) Payments received quarterly. e) Contract payment reimbursement request submitted monthly, received 1-2 months in arrears. f) Grant payments are generated by program activity during the school year and are received quarterly in arrears. g) Expenditures trending lower than anticipated. Currently 5.8 unfilled FTE; Eliminating 4.8 FTE h) Transfers out recorded quarterly. Page 2 SHERIFF - Fund 255 Statement of Financial Operating Data Eight Months Ended February 28, 2013 I Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 100% n/a $ - $ - $ - Revenues Law Enf Dist Countywide 15,041,084 12,230,531 (2,810,553) 67% 54% 22,561,626 18,874,105 (3,687,521) L anr_t of bfst Rural 9,627,795 8,215 12 1,41 , 67% 57% 14 41,692 12,259,717 2,181,978 Total Revenues 24,668,879 20,445,543 (4,223,336) 67% 55% 37,003,318 31,133,822 (5,869,496) TOTAL. RESOURCES 24,668,879 20,445,543 (4,223,336) 67% 55% 37,003,318 31,133,822 (5,869,496) REQUIREMENTS: F -Ex _p -9/61 EXPENDITURES & TRANSFERS Sheriffs Division 1,509,087 1,502,863 6,224 67% 66% 2,263,630 2,263,630 - Civil 532,659 486,144 46,515 67% 61% a) 798,989 734,889 64,100 Automotive/Communications 1,204,967 1,323,796 (118,829) 67% 73% b) 1,807,450 1,807,450 - Investigations/Evidence 1,005,453 954,358 51,095 67% 63% a) 1,508,180 1,468,080 40,100 Patrol/Civil/Comm Supp 5,512,905 5,482,620 30,285 67% 66% a) 8,269,358 8,169,358 100,000 Records 478,411 463,909 14,502 67% 65% a) 717,617 677,517 40,100 Adult Jail 7,253,355 6,675,972 577,383 67% 61% c) 10,880,032 10,383,042 496,990 Court Security 202,001 200,163 1,838 67% 66% 303,001 302,901 100 Emergency Services 129,689 122,290 7,399 67% 63% 194,533 194,433 100 Special Services Division 897,358 790,613 106,745 67% 59% 1,346,037 1,346,037 - Regional Work Center 1,775,385 1,668,722 106,663 67% 63% d) 2,663,078 2,532,978 130,100 Training Division 336,633 274,575 62,058 67% 54% 504,950 504,850 100 Other Law Enforcement Svcs 429,003 442,685 (13,682) 67% 69% 643,504 663,404 (19,900) Non-Departmental 56,835 56,835 (0) 67% 67% 85,253 85,253 - Contingency 3,345,137 - 3,345,137 67% n/a 5,017,706 - 5,017,706 TOTAL. REQUIREMENTS 24,668,878 20,445,543 4,223,335 67% 55% 37,003,318 31,133,822 5,869,496 NET (Resources - Requirements) - - - " Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Projected variance due to Personnel expenditures projected to be less than budgeted due to open positions and overtime. b) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund, expended in July 2012 c) Personnel budget was increased for the annual cost of six Correction Technicians. Technicians will be hired in March, resulting in projected difference between actual and budget of $428,000. Also, $90,000 budgeted for Capital Outlay will not be expended d) Personnel and Materials & Services expenditures projected to be less than budgeted due to timing of filling positions and savings in the cost of inmates' meals. Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 I Year End Budget Actual Variance FY % Coli. % I Budget 11 Projection Variance RESOURCES: Beg. Net Working Capital $4,507,352 $ 5,883,963 $ 1,376,611 100% 131% $ 4,507,352 $5,883,963 $ 1,376,611 Tax Revenues - Current 10,257,160 14,950,184 4,693,024 67% 97% a) 15,385,740 15,642,467 256,727 Tax Revenues - Prior 293,333 678,722 385,389 67% 154% 440,000 678,722 238,722 Federal Grants & Reimb 20,000 24,510 4,510 67% 82% b) 30,000 24,510 (5,490) State Grant 49,333 105,734 56,401 67% 143% c) 74,000 140,448 66,448 Jail Funding HB 2712 - 27,849 27,849 67% n/a d - 46,133 46,133 Transp. of State Wards 3,333 1,056 (2,277) 67% 21% 5,000 5,000 - SB 1145 986,661 1,109,993 123,332 67% 75% 1,479,991 1,479,991 - Prisoner Housing 33,333 139,501 106,168 67% 279% e) 50,000 178,817 128,817 Des. Cty Video Lottery Grant 3,333 5,000 1,667 67% 100% 5,000 5,000 - Des Cty Court Security 160,667 77,731 (82,937) 67% 32% f) 241,000 116,597 (124,403) Des Cty Juvenile Contract 2,787 3,462 675 67% 83% 4,180 4,180 - Title III Reimbursement - 26,795 26,795 67% n/a g) - 39,916 39,916 Transport 333 1,320 987 67% 264% 500 1,500 1,000 Other 2,333 7,288 4,955 67% 208% 3,500 7,288 3,788 DC Fair & Expo Center 2,667 756 (1,911) 67% 19% 4,000 4,000 - Inmate Commissary Fees 6,667 12,921 6,254 67% 129% 10,000 15,000 5,000 Work Center Work Crews 33,333 32,306 (1,027) 67% 65% 50,000 50,000 - Concealed Handgun Classes 2,333 5,625 3,292 67% 161% 3,500 8,000 4,500 Inmate Telephone Fee 53,333 46,874 (6,459) 67% 59% 80,000 80,000 - Soc Sec Incentive-Fed 3,333 9,200 5,867 67% 184% 5,000 9,200 4,200 Miscellaneous 3,333 5,006 1,673 67% 100% 5,000 5,000 - Oregon Mentors 667 - (667) 67% 0% 1,000 1,000 - Debit Card Fee 67 347 280 67% 347% 100 500 400 Medical Services Reimb 8,667 7,113 (1,554) 67% 55% 13,000 13,000 - Restitution 3,333 - (3,333) 67% 0% 5,000 5,000 Sheriff Fees 166,667 185,723 19,056 67% 74% 250,000 250,000 - Interest 18,889 27,668 8,779 67% 98% 28,333 39,666 11,333 Interest on Unsegregated 2,355 1,260 (1,095) 67% 36% 3,533 3,533 - Donations - "Shop with a Cop" 34,598 50,290 15,692 67% 97% 51,897 51,897 - Grants - 3,000 3,000 67% n/a - 3,000 3,000 Sale of Reportable Assets 3,333 574 2,759 67% 11% 5,000 5,000 - Total Revenues 12,156,181 17,547,807 5,391,626 67% 96% 18,234,274 18,914,364 680,090 TOTAL RESOURCES 16,663,533 23,431,770 6,768,237 67% 103% 22,741,626 24,798,327 2,056,701 REQUIREMENTS: Ex p. 7% Fund 255 Departments: Sheriffs Services 1,408,838 1,403,028 5,810 67% 66% 2,113,257 2,113,257 - Civil 532,659 486,144 46,516 67% 61% 798,989 734,889 64,100 Auto/Comm 444,331 488,150 (43,818) 67% 73% 666,497 666,497 - Adult Jail 7,253,355 6,675,972 577,383 67% 61% 10,880,032 10,383,042 496,990 Court Security 202,001 200,163 1,838 67% 66% 303,001 302,901 100 Emergency Services 129,689 122,290 7,399 67% 63% 194,533 194,433 100 Special Services 620,918 547,057 73,861 67% 59% 931,377 931,377 - Work Center 1,775,385 1,668,722 106,663 67% 63% 2,663,078 2,532,978 130,100 Training 205,784 167,848 37,936 67% 54% 308,676 308,615 61 Other (CODE, Forensic) 429,003 442,685 (13,682) 67% 69% 643,504 663,404 (19,900) Non Dept - ISF Charges 28,475 28,475 (0) 67% 67% 42,712 42,712 - Contingency 2,010,647 - 2,010,647 67% n/a 3,015,970 - 3,015,970 Total to Fund 255 15,041,084 12,230,531 2,810,553 22,561,626 18,874,105 3,687,521 Transfer to Reserve Fund (703) 66,667 100,000 (33,333) 67% 100% 100,000 100,000 - Non Dept - Comm System Res 53,333 80,000 (26,667) 67% 100% 80,000 80,000 - Total Requirements 15,161,084 12,410,531 2,750,552 67% 55% 22,741,626 19,054,105 3,687,521 Net 1,502,449 11,021,239 9,518,790 - 5,744,222 5,744,222 Beginning Net Working Capital per Requested Budget 5,541,699 a) Current year taxes due November, February and May b) Less than planned BOJ Criminal Alien Assistance (SCARP) reimbursement c) Unplanned Homeland Security Grant for Engineering Communication System Study d) Unplanned changes at the State level in Circuit Court revenue distribution e) Reimbursement from the State will exceed plan due to higher number of SB 395 inmates f) Changes made at State level in distribution of Circuit Court revenue g) Approved carryover of prior year Title III funds * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services Page 4 Fund 702 LED Rural Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date I FY 2013 Year End Budget Actual Variance I FY % Coll. % Bud et Pr jection Variance RESOURCES: Beg. Net Working Capital $2,859,915 $3,244,571 $ 384,656 100% 113% $2,859,915 $3,244,571 $ 384,656 Revenues Tax Revenues - Current 5,033,333 7,278,500 2,245,167 67% 96% a) 7,550,000 7,615,538 65,538 Tax Revenues - Prior 153,333 336,211 182,878 67% 146% 230,000 336,290 106,290 Federal Grants & Reimb 10,000 29,242 19,242 67% 195% b) 15,000 29,242 14,242 Federal Grants-BLM 17,333 6,233 (11,101) 67% 24% 26,000 26,000 - US Forest Service 50,000 39,375 (10,625) 67% 53% 75,000 75,000 - Bureau of Reclamation 17,333 18,830 1,497 67% 72% 26,000 26,000 - State Grant 126,129 205,740 79,611 67% 109% c) 189,194 262,800 73,606 SB #1065 Court Assessment 36,667 5,087 (31,580) 67% 9% d) 55,000 5,087 (49,913) Marine Board License Fee 94,727 57,765 (36,962) 67% 41% 142,091 142,091 - Des Cty General Fund Grant 384,490 - (384,490) 67% 0% e) 576,735 576,735 Des Cty Transient Room Tax 1,382,177 1,382,177 (0) 67% 67% 2,073,265 2,073,265 - Des Cty Tax Office Contract 333 540 207 67% 108% 500 540 40 City of Sisters 311,973 312,073 100 67% 67% 467,960 467,960 - Des Cty CDD Contract 36,244 36,244 0 67% 67% 54,366 54,366 - Des Cty Solid Waste Contr 36,244 36,244 0 67% 67% 54,366 54,366 - Des Cty Clerk/Election 667 996 329 67% 100% 1,000 1,000 - School Districts 26,667 15,141 (11,526) 67% 38% 40,000 40,000 - Claims Reimbursement - 860 860 67% n/a - 860 860 Security & Traffic Reimb 3,333 - (3,333) 67% 0% 5,000 5,000 - Seat Belt Program 6,667 3,710 (2,957) 67% 37% 10,000 10,000 - Miscellaneous 4,000 7,631 3,631 67% 127% 6,000 8,000 2,000 False Alarm Fees 1,333 2,900 1,567 67% 145% 2,000 4,000 2,000 Restitution 3,333 1,247 (2,087) 67% 25% 5,000 5,000 - Sheriff Fees 6,667 6,289 (378) 67% 63% 10,000 10,000 - Court Fines & Fees 80,000 77,519 (2,481) 67% 65% 120,000 120,000 Impound Fees 2,667 3,500 833 67% 88% 4,000 4,000 - Restitution - Street Crimes 333 - (333) 67% 0% 500 500 Seizure/Forfeiture 667 140 (527) 67% 14% 1,000 1,000 - Interest 6,667 12,588 5,921 67% 126% 10,000 17,500 7,500 Interest on Unsegregated 1,200 615 (585) 67% 34% 1,800 1,800 - Grants-Private - 6,500 6,500 67% n/a - 6,500 6,500 Donations - 4,120 4,120 67% n/a - 4,120 4,120 Sale of Equip & Material 6,667 2,829 (3,838) 67% 28% 10,000 5,000 (5,000) Sale of Reportable Assets 26,667 6,817 19,850 67% 17% f) 40,000 20,000 20,000 Total Revenues 7,867,852 9,897,663 2,029,813 50% 84% 11,601,777 12,009,561 207,784 TOTAL RESOURCES 10,727,767 13,142,234 2,414,468 50% 90% 14,661,692 15,254,132 592,440 REQUIREMENTS: Exp. Fund 255 Departments: Sheriffs Services 100,249 99,835 413 67% 66% 150,373 150,373 Auto/Comm 760,635 835,646 (75,011) 67% 73% 1,140,953 1,140,953 - Investigations 1,005,453 954,358 51,095 67% 63% 1,508,180 1,468,080 40,100 Patrol 5,512,905 5,482,620 30,286 67% 66% 8,269,358 8,169,358 100,000 Records 478,411 463,909 14,503 67% 65% 717,617 677,517 40,100 Special Services 276,440 243,556 32,884 67% 59% 414,660 414,660 - Training 130,849 106,727 24,122 67% 54% 196,274 196,235 39 Non Dept - ISF Charges 28,361 28,361 (0) 67% 67% 42,541 42,541 - Contingency 1,334,491 - 1,334,491 67% n/a 2,001,736 - 2,001,736 Tot*t'ty lZmd V927,745 9116,012 1 , 1 2,1 1;J Transfer to Reserve Fund (704) 66,667 100,000 (33,333) 67% 100% 100,000 100,000 - Non Dept Comm System Res 80,000 120,000 (40,000 67% 100% 120,000 120,000 Total Requirements 9,774,461 8,435,012 1,339,449 67% 58% 14,661,692 12,479,717 2,181,975 Net 953,305 4,707,222 3,753,916 - 2,774,414 2,774,414 Beginning Net Working Capital per Requested Budget 2,620,213 a) Current year taxes due November, February and May b) JAG grant for 800 MHz radios c) Homeland Security grant Communication System Engineer ing Study d) Changes made at State level in distribution of Circuit Court revenue e) Will be received June 2013 f) Less than planned revenue from sale of surpl us vehicles Page 5 Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Goll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,336,051 $ 1,327,199 $ (8,852) 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 667 8 (659) 67% 1% 1,000 100 (900) Federal Grant - 9,000 9,000 67% n/a - 9,000 9,000 Federal Grant (ARRA) 133,333 106,250 (27,083) 67% 53% 200,000 212,500 12,500 State Grant 1,942,899 1,567,878 (375,021) 67% 54% 2,914,349 2,934,303 19,954 Child Dev & Rehab Center 26,406 16,360 (10,046) 67% 41% a) 39,609 39,609 - State Miscellaneous 89,827 81,890 (7,937) 67% 61% a) 134,740 134,740 - OMAP 418,392 343,879 (74,513) 67% 55% 627,588 608,494 (19,094) Title 19 235 - (235) 67% n/a 352 - (352) Family Planning Exp Proj 366,667 316,214 (50,453) 67% 57% 550,000 550,000 - Local Grants 32,000 - (32,000) 67% 0% 48,000 55,200 7,200 Environmental Health-Water 61,467 46,428 (15,039) 67% 50% 92,200 92,200 - Contract Payments 69,207 74,979 5,772 67% n/a 103,810 158,354 54,544 Miscellaneous - 2,169 2,169 67% n/a - 3,000 3,000 Patient Insurance Fees 128,800 135,844 7,044 67% 70% 193,200 193,200 - Health Dept/Patient Fees 68,733 61,057 (7,676) 67% 59% 103,100 85,000 (18,100) Vital Records-Birth 27,333 21,950 (5,383) 67% 54% 41,000 35,000 (6,000) Vital Records-Death 66,667 74,865 8,198 67% 75% 100,000 100,000 - Environmental Health-Lic Fac 480,033 672,854 192,821 67% 93% b) 720,050 740,050 20,000 Interest on Investments 8,000 3,718 (4,282) 67% 31% 12,000 5,400 (6,600) Grants-private 11,251 33,753 22,502 67% 200% 16,876 16,876 - Donations 3,533 19,101 15,568 67% 360% 5,300 22,277 16,977 Interfund Contract 105,753 81,850 (23,903) 67% 52% 158,629 164,000 5,371 Administrative Fee 533 533 0 67% 67% 800 800 - Total Revenues 4,041,736 3,670,580 (371,156) 67% 61% 6,062,603 6,160,103 97,500 Transfers In-General Fund 1,566,240 1,566,240 - 67% 67% 2,349,357 2,349,357 - Transfers In-PH Res Fund 40,091 30,068 (10,023) 67% 50% 60,136 60,136 - Transfers In-Gen. Fund Other 43,400 32,550 10,850 67% 50% 65,100 65,100 - TOTAL RESOURCES 7,027,518 6,626,637 (400,881) 67% 67% 9,873,247 9,961,895 88,648 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS Exp. 4,303,137 4,186,561 116,576 67% 65% 6,454,705 6,282,220 172,485 1,427,919 1,247,494 180,425 67% 58% 2,141,878 2,136,883 4,995 43,333 - 43,333 67% 0% c) 65,000 - 65,000 104,800 78,600 26,200 67% 50% 157,200 157,200 - 702,976 - 702,976 67% n/a 1,054,464 - 1,054,464 6,582,165 5,512,655 1,069,510 67% 56% NET (Resources - Requirements) 445,353 1,113,983 668,630 Beginning Net Working Capital per Requested Budget a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan c) OCHIN System expenditure made in FY 2012 9,873,247 8,576,303 1,296,944 - 1,385,592 1,385,592 1,385,592 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 Year End Bud et Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $3,320,968 $ 3,113,095 $ (207,873) 100% 94% $3,320,968 $3,113,095 $ (207,873) Revenues Marriage Licenses 4,333 3,740 (593) 67% 58% 6,500 6,500 - Divorce Filing Fees 106,667 82,021 (24,646) 67% 51% 160,000 125,056 (34,944) Domestic Partnership Fee 30 55 25 67% 122% 45 100 55 Federal Grants 168,233 124,784 (43,449) 67% 49% a) 252,349 252,349 - Federal Grant (ARRA) 42,500 21,250 (21,250) 67% 33% 63,750 63,750 - State Grants 5,197,066 4,906,691 (290,375) 67% 63% b) 7,795,599 7,883,477 87,878 State Miscellaneous 41,240 21,151 (20,089) 67% 34% 61,860 61,860 - Adult Mental Health Initiative 133,333 229,038 95,705 67% 115% 200,000 230,000 30,000 Title 19 179,631 62,676 (116,955) 67% 23% 269,446 269,446 - Liquor Revenue 94,333 79,479 (14,854) 67% 56% 141,500 141,500 - School Districts 46,000 14,400 (31,600) 67% 21% c) 69,000 14,400 (54,600) Contract Payments - 34 34 67% n/a - 1,000 1,000 Miscellaneous - 11,154 11,154 67% n/a - 12,000 12,000 Patient Insurance Fees 58,355 63,809 5,454 67% 73% 87,532 130,000 42,468 Patient Fees 633 1,140 507 67% 120% 950 1,500 550 Interest on Investments 16,667 13,581 (3,086) 67% 54% 25,000 20,500 (4,500) Rentals 12,333 9,375 (2,958) 67% 51% 18,500 18,500 - Forfeitures - 140 140 67% n/a - 140 140 Administrative Fee 3,528,351 3,470,386 (57,965) 67% 66% 5,292,527 5,292,527 - Interfund Contract-Gen Fund 84,667 78,084 (6,583) 67% 61% a) 127,000 127,000 - Total Revenues 9,714,372 9,192,987 (521,385) 67% 63% 14,571,558 14,651,605 80,047 Transfers In-General Fund 871,858 871,858 0.50 67% 67% 1,307,787 1,307,787 - Transfers In-OHP-CDO 322,996 322,996 - 67% 67% 484,494 484,494 - Transfers In-Acute Care Svcs 176,424 176,424 - 67% 67% 264,631 264,631 - Transfers In-ABHA 349,360 349,360 - 67% 67% 524,039 524,039 - TOTAL RESOURCES 14,755,978 14,026,720 (729,258) 67% 69% 20,473,477 20,345,651 (127,826) REQUIREMENTS: Exp. Expenditures Personnel Services 7,707,135 7,170,723 536,412 67% 62% 11,560,702 10,800,000 760,702 Materials and Services 4,401,970 3,558,307 843,663 67% 54% 6,602,955 5,850,000 752,955 Capital Outlay 33,400 19,645 13,755 67% 39% 50,100 30,000 20,100 Transfers Out 136,000 102,000 34,000 67% 50% 204,000 204,000 - Contingency 1,370,480 - 1,370,480 67% n/a 2,055,720 - 2,055,720 TOTAL REQUIREMENTS 13,648,985 10,850,675 2,798,310 67% 53% 20,473,477 16,884,000 3,589,477 NET (Resources - Requirements) 1,106,993 3,176,045 2,069,052 - 3,461,651 3,461,651 Beginning Net Working Capital per Adopted Budget 3,461,651 a) Received quarterly, in arrears b) Oregon Health Authority grant projected at amen ded contract amount c) Contract for services to school districts terminated by mutual agreement Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Eight Months Ended February 28, 2013 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 Transfers In General Fund - Gen Ops General Fund - UR Planning A&T Reserve (D/S assistance) Other TOTALRESOURCES Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Proiection Variance $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 14,727 19,635 4,908 67% 89% 22,090 24,483 2,393 833 445 (388) 67% 36% a) 1,250 1,000 (250) 110,800 127,598 16,798 67% 77% 166,200 178,000 11,800 849,050 834,450 (14,600) 67% 66% 1,273,575 1,190,747 (82,828) 170,667 185,667 15,000 67% 73% 256,000 268,496 12,496 74,400 80,206 5,806 67% 72% 111,600 184,800 73,200 208,647 184,981 (23,666) 67% 59% 312,971 283,140 (29,831) 424,900 421,998 (2,902) 67% 66% 637,350 613,255 (24,095) 150,947 175,081 24,134 67% 77% 226,421 266,897 40,476 2,004,971 2,030,062 25,091 67% 68% 3,007,457 3,010,818 3,361 569,913 569,912 (1) 67% 67% 854,872 854,872 - 330,240 330,240 - 67% 67% 495,360 495,360 - 59,718 85,409 25,691 67% 95% 89,577 89,577 - 67 - (67) 67% 0% 100 - (100) 2,974,909 3,208,105 233,196 67% 72% 4,457,366 4,643,109 185,743 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 902,126 877,469 24,657 Admin-GIS 78,519 75,459 3,060 Admin-Code Enforcement 152,617 139,182 13,435 Building Safety 414,058 405,910 8,148 Electrical 135,487 133,116 2,371 Contract Services 94,497 100,336 (5,839) Env Health-On Site Pgm 106,424 101,606 4,818 Planning-Current 428,210 378,357 49,853 Planning-Long Range 308,934 252,427 56,507 Transfers Out (D/S Fund) 119,437 170,818 (51,381) Contingency 231,269 - 231,269 Exp. 67% 65% b) 1,353,189 1,311,323 41,866 67% 64% 117,778 117,778 - 67% 61% b) 228,925 216,747 12,178 67% 65% 621,087 621,087 - 67% 65% 203,231 203,231 - 67% 71% 141,745 141,745 - 67% 64% 159,636 159,636 - 67% 59% c) 642,315 634,887 7,428 67% 54% c,d) 463,401 349,567 113,834 67% 95% 179,155 179,155 - 67% n/a 346,904 - 346,904 TOTAL REQUIREMENTS 2,971,578 2,634,679 336,899 67% 59% NET (Resources - Requirements) 3,331 573,426 570,095 Beginning Net Working Capital per Requested Budget 4,457,366 3,935,156 522,210 - 707,953 707,953 696,290 Revenues 2,030,062 3,007,457 3,010,818 3,361 Expenditures 2,634,679 4,457,366 3,935,156 522,210 Net from Operations (604,617) (1,449,909) (924,338) 525,571 a) Revenue is sporadic throughout the year as GIS services are requested b) Reflects savings due to CD Director's appointment as Interim County Administrator through 6/30/13 c) Reflects savings due to Planning Director's reduced allocation through 6/30/13 while serving as Interim CD Director d) Reflects savings from retired employee; position is not expected to be refilled Page 8 ROAD Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date tY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 4,719,551 $ 4,723,852 $ 4,301 100% 100% $ 4,719,551 $ 4,723,852 $ 4,301 Revenues System Development Charge - 1,386 1,386 67% n/a - 1,400 1,400 Federal Grant (ARRA) 4,667 7,335 2,668 67% 105% 7,000 7,335 335 Mineral Lease Royalties 26,667 28,750 2,083 67% 72% 40,000 40,000 - Forest Receipts 264,551 1,265,121 1,000,570 67% 319% a) 396,826 1,265,121 868,295 State Grant - 2,618 2,618 67% n/a - 2,618 2,618 State Miscellaneous 361,527 542,290 180,763 67% 100% b) 542,290 542,290 - Motor Vehicle Revenue 7,193,362 7,281,884 88,522 67% 67% c) 10,790,043 10,450,000 (340,043) City of Bend 16,667 - (16,667) 67% 0% d) 25,000 309,350 284,350 City of Redmond 233,333 10,807 (222,526) 67% 3% d) 350,000 387,240 37,240 City of Sisters 6,667 - (6,667) 67% 0% d) 10,000 - (10,000) City of La Pine 6,667 10,000 3,333 67% 100% d) 10,000 10,000 - Admin Recovery (SDC) - 1,880 1,880 67% n/a - 2,000 2,000 Miscellaneous 13,333 16,880 3,547 67% 84% 20,000 20,000 - Road Vacations 667 - (667) 67% 0% 1,000 500 (500) Interest on Investments 10,000 19,807 9,807 67% 132% 15,000 22,000 7,000 Interfund Contract 460,000 - (460,000) 67% 0% e) 690,000 590,000 (100,000) Equipment Repairs 146,667 138,154 (8,513) 67% 63% 220,000 185,000 (35,000) Vehicle Repairs 60,000 - (60,000) 67% 0% e) 90,000 80,000 (10,000) LID Construction 6,667 - (6,667) 67% 0% f) 10,000 - (10,000) Vegetation Management 16,667 - (16,667) 67% 0% e) 25,000 50,000 25,000 Forester 16,667 - (16,667) 67% 0% e) 25,000 25,000 - Car Washes 2,667 1,608 (1,059) 67% 40% 4,000 4,000 - Car Rental 667 284 (383) 67% 28% 1,000 1,000 - Sale of Equip & Material 482,400 606,135 123,735 67% 84% 723,600 823,851 100,251 Total Revenues 9,330,510 9,934,939 604,429 67% 71% 13,995,759 14,818,705 822,946 Trans In - Solid Waste 184,181 138,136 (46,045) 67% 50% g) 276,272 276,272 - Trans In - Transp SDC 166,667 - (166,667) 67% 0% f) 250,000 - (250,000) Trans In-Road Imp Res 8,000 - (8,000) 67% 0% f) 12,000 - 12,000 TOTAL RESOURCES 14,408,909 14,796,927 554,685 67% 75% 19,253,582 19,818,829 565,247 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 3,576,801 3,606,094 (29,293) 67% 67% h) 5,365,202 5,310,875 54,327 6,292,441 4,072,149 2,220,292 67% 43% i) 9,438,662 8,144,702 1,293,960 1,358,200 9,233 1,348,967 67% 0% j) 2,037,300 73,884 1,963,416 183,333 275,000 (91,667) 67% 100% 275,000 275,000 - 1,424,945 - 1,424,945 67% n/a 2,137,418 - 2,137,418 12,835,720 7,962,476 4,873,244 67% 41% 1,573,189 6,834,451 5,427,929 Beginning Net Working Capital per Requested Budget a) Payment received annually in January b) Payment received annually in October c) Actual receipts are lower than projections d) Billed upon completion of work e) Payments to be received in June 2013 from other Road Department funds f) No SDC qualifying projects in FY 2013; no resources will be transferred in from SDC fund g) Payments made quarterly h) Retro COLA raises for 701 members, early retirement and resignations i) Expenditures are seasonal and higher during summer months j) CIP project reserve carry over FY 2014 19,253,582 13,804,461 5,449,121 6,014,368 6,014,368 6,014,368 Page 9 ADULT PAROLE & PROBATION Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 570,000 $ 630,226 $ 60,226 100% 111% $ 570,000 $ 630,226 $ 60,226 Revenues DOC Measure 57 146,160 219,240 73,080 67% 100% a) 219,240 219,240 - State Miscellaneous 2,867 - (2,867) 67% 0% b) 4,301 4,301 - Alternate Incarceration 10,000 - (10,000) 67% 0% c) 15,000 3,000 (12,000) State Subsidy 9,217 18,872 9,655 67% 136% d) 13,826 21,826 8,000 S61145 1,832,370 2,061,416 229,046 67% 75% d) 2,748,556 2,748,556 - Probation Work Crew Fees 15,000 8,320 (6,680) 67% 37% 22,500 14,180 (8,320) Miscellaneous 3,000 3,529 529 67% 78% 4,500 4,500 - Electronic Monitoring Fee 86,667 107,586 20,919 67% 83% 130,000 153,257 23,257 Probation Superv. Fees 126,667 117,561 (9,106) 67% 62% 190,000 172,380 (17,620) Interest on Investments 6,000 3,794 (2,206) 67% 42% 9,000 9,000 - Interfund - Sheriff 33,333 33,333 0 67% 67% 50,000 50,000 - Sale of Equipment - 250 250 67% n/a - 250 250 Crime Prevention Grant 33,333 25,000 (8,333) 67% 50% d) 50,000 50,000 - CFC-Domestic Violence 49,888 28,785 (21,103) 67% 38% d) 74,832 74,832 - Total Revenues 2,354,502 2,627,687 273,185 67% 74% 3,531,755 3,525,322 (6,433) Transfers In-General Fund 290,217 290,216 1 67% 67% 435,328 435,328 - TOTAL RESOURCES 3,214,719 3,548,128 333,409 67% 78% 4,537,083 4,590,876 53,793 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Exp. 2,060,861 1,949,466 111,395 67% 63% 3,091,291 3,041,291 50,000 593,125 530,176 62,949 67% 60% 889,687 889,687 - 67 - 67 67% 0% 100 - 100 370,670 - 370,670 67% n/a 556,005 - 556,005 3,024,723 2,479,642 545,081 67% 55% NET (Resources - Requirements) 189,996 1,068,487 878,491 Beginning Net Working Capital per Requested Budget a) Payment received annually in September b) Annual allocation normally received by end of calendar year c) Funds are specific to a certain population, which has been smaller than expected d) State/County invoiced quarterly 4,537,083 3,930,978 606,105 659,898 659,898 697,000 Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Eight Months Ended February 28, 2013 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Youth Investment State Prevention Funds HealthyStart /R-S-G OCCF Grant Charges for Svcs-Mist Program Fees Court Fines & Fees Interest on Investments Grants, Private Interfund Grants Total Revenues Year to Date FY 13 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $ 511,994 $ 567,120 $ 55,126 203,037 26,355 56,667 131,265 32,081 146,634 279,864 5,333 52,990 667 1,333 213,916 1,150,142 132,015 28,545 44,234 154,986 46,839 164,961 296,149 2,003 4,765 49,389 2,398 247,718 1,174,003 (71,022) 2,190 (12,433) 23,721 14,758 18,327 16,285 (3,330) 4,765 (3,601) 1,731 (1,333) 33,802 23,861 Trans from General Fund 183,997 184,000 3 Total Transfers In 183,997 184,000 3 100% 111% $ 511,994 $ 567,120 $ 55,126 67% 43% a) 304,556 251,856 (52,700) 67% 72% 39,533 39,533 - 67% 52% a) 85,000 60,000 (25,000) 67% 79% 196,898 196,897 (1) 67% 97% b) 48,122 58,022 9,900 67% 75% 219,951 219,951 - 67% 71% a) 419,796 391,940 (27,856) 67% 25% 8,000 4,000 (4,000) 67% n/a - 4,765 4,765 67% 62% c) 79,485 75,034 (4,451) 67% 240% 1,000 5,000 4,000 67% n/a 2,000 - (2,000) 67% 77% d) 320,874 350,374 29,500 67% 68% 1,725,215 1,657,372 (67,843) 67% 67% 275,984 275,984 - 67% 67% 275,984 275,984 - TOTAL RESOURCES 1,846,133 1,925,123 78,990 67% 77% 2,513,193 2,500,477 (12,716) REQUIREMENTS: Exp. Expenditures Personnel Services 431,649 386,516 45,133 67% 60% e) 647,474 589,457 58,017 Materials and Services 1,048,984 708,858 340,126 67% 45% f) 1,573,476 1,537,247 36,229 Capital Outlay 67 - 67 67% 0% 100 - 100 Contingency 194,762 - 194,762 67% n/a 292,143 292,143 TOTAL REQUIREMENTS 1,675,462 1,095,374 580,088 67% 44% 2,513,193 2,126,704 386,489 NET (Resources - Requirements) 170,671 829,750 659,079 Beginning Net Working Capital per Requested Budget 373,773 373,773 375,704 a) Projection based on actual awarded amounts b) Additional GLS grant funds of $3,500 awarded c) State reduced the Circuit Court fees d) Additional grant funds of $17,500 - A & D 70 and $12,000 EUDL projected to be received e) Personnel expenditures projected to be less than appropriated. Open position, due to retirement, will not be filled f) M & S projected to be greater than originally budgeted due to new Federal grant awarded. Appropriation transfer will be requested Page 11 SOLID WASTE Statement of Financial Operating Data Eight Months Ended February 28, 2013 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Donations Sale of Assets Recyclables Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Transfers Out Road Capital Reserve Contingency TOTAL REQUIREMENTS Year to Date FY 2013 Year End Budget Actual Variance FY % Cnll. % Bud et Projection Variance $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 14,667 11,906 (2,761) 67% 54% 22,000 22,000 - 133,333 85,501 (47,832) 67% 43% a) 200,000 200,000 - 573,333 637,341 64,008 67% 74% 860,000 940,000 80,000 876,000 868,659 (7,341) 67% 66% 1,314,000 1,290,000 (24,000) 2,666,667 2,731,838 65,171 67% 68% 4,000,000 4,035,000 35,000 48,667 66,208 17,541 67% 91% b) 73,000 85,000 12,000 16,667 61,566 44,899 67% 246% c) 25,000 70,000 45,000 5,000 5,323 323 67% 71% 7,500 8,000 500 7,200 7,201 1 67% 67% 10,801 10,801 - - 1,680 1,680 67% n/a - 1,680 1,680 - 1,451 1,451 67% n/a - 1,451 1,451 - 30,000 28,593 51,407 67% 64% 45,000 42,000 3,000) 4,371,534 4,507,268 135,733 67% 69% 6,557,301 6,705,932 148,631 5,072,047 5,314,738 242,691 67% 73% 7,257,814 7,513,403 255,589 Exp. 1,155,547 1,104,621 50,926 67% . 64% 1,733,321 1,707,324 25,997 1,992,875 1,624,346 368,529 67% 54% d) 2,989,313 3,047,103 (57,790) 631,142 405,589 225,553 67% 43% e) 946,713 946,713 - 55,333 61,620 (6,287) 67% 74% f) 83,000 80,336 2,664 184,181 138,136 46,045 67% 50% g) 276,272 276,272 - 420,000 630,000 (210,000) 67% 100% h) 630,000 630,000 - 399,463 - 399,463 67% n/a 599,195 599,195 4,838,541 3,964,312 874,229 67% 55% 7,257,814 6,687,748 570,066 NET (Resources - Requirements) 233,506 1,350,426 1,116,920 Beginning Net Working Capital per Requested Budget a) Due April 15, 2013 b) Seasonal item-Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Purchasing will pick up as year progresses e) Semi-Annual: November and May f) In the process of contacting bidders g) Quarterly h) All of FY 2013 budgeted transfer made because resources needed for Fund 613's capital projects 825,655 825,655 825,655 Page 12 RISK MANAGEMENT Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date Year End Bud et Actual Variance % of FY % Coll. Bud et Projection Variance RESOURCES: Beginning Net Working Capital $2,000,000 $2,240,791 $240,791 Revenues Inter-fund Charges: General Liability 174,889 174,889 0 Property Damage 208,987 208,987 0 Vehicle 115,757 115,757 (0) Workers' Compensation 960,117 960,117 0 Unemployment 166,667 166,768 102 Claims Reimb-Workers' Compensation 333 - (333) Claims Reimb-Gen Liab/Property 40,000 30,112 (9,888) Process Fee-Events/Parades 1,333 390 (943) Miscellaneous 33 37 3 Skid Car Training 10,667 16,490 5,823 NSF Fee - 30 30 Interest on Investments 10,000 7,802 (2,198) Other Interest 33 - (33) TOTAL REVENUES 1,688,816 1,681,379 (7,437) TOTAL RESOURCES 3,688,816 3,922,170 233,354 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement / Benefit 365,893 5202 Defense 37,481 5203 Professional Service 10,174 5204 Insurance 138,350 5205 Loss Prevention 8,232 5206 Miscellaneous 45 5207 Repair / Replacement 200 Total General Liability 200,000 560,375 (360,375) PROPERTY DAMAGE 5204 Insurance 159,171 5207 Repair/Replacement 41,463 Total Property Damage 166,667 200,634 (33,967) VEHICLE 5203 Professional Service - 5204 Insurance 366 5205 Loss Prevention 11,421 5207 Repair / Replacement 18,650 Total Vehicle 66,667 30,438 36,229 WORKERS' COMPENSATION 5201 Settlement / Benefit 233,874 5203 Professional Service - 5204 Insurance 98,178 5205 Loss Prevention 24,779 5206 Miscellaneous 22,086 Total Workers' Compensation 666,667 378,917 287,750 5201 UNEMPLOYMENT - Settlement/Benefits 166,667 93,403 73,263 Total Direct Insurance Costs 1,266,667 1,263,767 2,900 Insurance Administration: Personnel Services 205,264 196,782 8,482 Materials & Service 112,660 134,498 (21,838) Capital Outlay 67 - 67 Total Insurance Administration 317,991 331,280 (13,289) Transfers Out 4,800 3,600 1,200 TOTAL REQUIREMENTS 1,589,457 1,598,646 (9,189) NET 2,099,359 2,323,524 224,165 Beginning Net Working Capital per Requested Budget a) Annual premium paid in July 2012 * Contingency is $2,149,038 100% 112% $2,000,000 $2,240,791 $240,791 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 0% 67% 50% 67% 20% 67% 74% 67% 103% 67% n/a 67% 52% 67% 0% 67% 66% 67% 87% Ex . a) 67% 187% a) 67% 80% 67% 30% a) 262,333 262,333 - 313,480 313,480 - 173,635 173,635 - 1,440,176 1,440,176 - 250,000 250,000 - 500 500 - 60,000 60,000 - 2,000 2.000 - 50 50 - 16,000 16,490 490 - 60 60 15,000 12,000 (3,000) 50 50 - 2,533,224 2,530,774 (2,450) 4,533,224 4,771,565 238,341 300,000 700,000 (400,000) 250,000 230,000 20,000 100,000 60,000 40,000 67% 38% 1,000,000 550,000 450,000 67% 37% 250,000 230,000 20,000 67% 67% 1,900,000 1,770,000 130,000 67% 64% 307,896 307,896 - 67% 80% 168,990 168,990 - 67% 0% 100 - 100 67% 69% 476,986 476,886 100 67% 50% 7,200 7,200 - 67% 67% 2,384,186 2,254,086 130,100 * 2,149,038 2,517,479 368,441 2,517 479 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date FY 2013 Year End Budget Actual Variance % of FY % Coll. Bud et Projection Variance RESOURCES: Beg. Net Working Capital $8,000,000 $ 8,883,086 $ 883,086 100% 111% $8,000,000 $8,883,086 $ 883,086 Revenues Property Taxes - Current 4,365,125 5,979,234 1,614,109 67% 91% a) 6,547,687 6,256,420 (291,267) Property Taxes - Prior 123,333 265,873 142,540 67% 144% 185,000 279,126 94,126 Federal Grants 160,000 - (160,000) 67% 0% b) 240,000 240,000 - State Reimbursement 24,000 17,729 (6,271) 67% 49% c) 36,000 36,000 - Telephone User Tax 500,000 383,681 (116,319) 67% 51% 750,000 750,000 - Data Network Reimb. 20,000 14,013 (5,987) 67% 47% d) 30,000 43,804 13,804 Jefferson County 20,000 27,676 7,676 67% 92% 30,000 31,262 1,262 User Fee 29,333 4,313 (25,020) 67% 10% e) 44,000 44,000 - Police RMS User Fees 185,967 210,176 24,209 67% 75% f) 278,950 252,000 (26,950) Contract Payments 20,667 392 (20,275) 67% 1% g) 31,000 1,988 (29,012) Miscellaneous 6,000 6,879 879 67% 76% 9,000 9,000 - Claims Reimbursement - 46,760 46,760 67% n/a h) - 46,760 46,760 Interest 26,667 34,494 7,827 67% 86% 40,000 50,000 10,000 Interest on Unsegregated Tax 400 506 106 67% 84% 600 600 - Total Revenues 5,481,492 6,991,725 1,510,233 67% 85% 8,222,237 8,040,960 (181,277) TOTAL RESOURCES 13,481,492 15,874,811 2,393,319 67% 98% 16,222,237 16,924,046 701,809 REQUIREMENTS: % Exp. Expenditures Personnel Services 2,893,660 2,602,030 291,630 67% 60% 4,340,490 4,000,000 340,490 Materials and Services 1,366,801 1,235,063 131,738 67% 60% 2,050,202 2,050,202 - Capital Outlay 374,667 46,514 328,153 67% 8% 562,000 562,000 - Transfers Out-Reserve Fund 333,333 500,000 (166,667) 67% 100% i) 500,000 500,000 - Contingency 5,846,363 - 5,846,363 67% n/a 8,769,545 - 8,769,545 TOTAL REQUIREMENTS 10,814,824 4,383,607 6,431,217 67% 27% 16,222,237 7,112,202 9,110,035 NET (Resources - Requirements) 2,666,668 11,491,203 8,824,935 - 9,811,844 9,811,844 Beginning Net Working Capital per Requested Budget 9,800,000 a) Current year taxes due November, February and May b) ODOT Project-reimbursements expected to be received over the next 2.3 months c) Jan/Feb payments outstanding; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance d) Annual billings are arriving from Police/Fire agencies e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June f) RMS - Projection reduced to reflect actuals & the $29,103 expected from agency billings g) Protection reduced to reflect $2910 now included in Police RMS User Fees line item h) Reimbursement for faulty UPS - American Power Conversion i) Amount appropriated was transferred September 15, 2012 Page 14 Health Benefits Trust Statement of Financial Operating Data Eiaht Months Ended February 28, 2013 Year to Date FY 2013 Bud et Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES Beg. Net Working Capital $13,800,000 $14,551,028 $ 751,028 100% 106% $ 13,800,000 $14,561,028 751,028 Revenues: Internal Premium Charges 8,530,000 8,580,636 50,636 67% 67% ` 12,795,000 12,871,238 76,238 P/TEmp - Add'IPrem 33,333 21,857 (11,476) 67% 44% 50,000 33,000 (17,000) Employee Prem Contribution 420,000 425,550 5,550 67% 68% 630,000 638,000 8,000 COIC 866,667 935,964 69,298 67% 72% 1,300,000 1,400,000 100,000 Retiree / COBRA Co-Pay 500,000 615,538 115,538 67% 82% 750,000 923,000 173,000 Medical Services Reimb - 441 441 67% n/a " - 441 441 Prescription Rebates - 66,836 66,836 67% n/a - 66,836 66,836 Claims Reimbursements 50,493 50,493 67% n/a'- 50,493 50,493 Vending Machines (wellness Rebate) - 222 222 67% n/a - 222 222 Interest 53,333 49,612 3,722 67% 62% 80,000 73,000 7,000 Total Revenues 10,403,333 10,747,149 343,816 67% 69% , 15,605,000 16,056,231 451,231 TOTAL RESOURCES 24,203,333 25,298,177 1,094,844 92% 106% 29,405,000 30,607,258 1,202,258 REQUIREMENTS Expenditures: Personnel Services (all depts) 133,848 132,182 1,666 67% 66% 200,772 200,772 - Materials & Services Claims Paid-Medical 6,686,800 7,719,709 (1,032,909) 67% 77% a) 10,030,200 11,556,562 (1,526,362) Claims Paid-Prescription 1,282,400 720,481 561,919 67% 37% a) 1,923,600 1,028,482 895,118 Claims Paid-Dental/Vision 1,190,800 1,191,720 (920) 67% 67% a), 1,786,200 1,848,148 (61,948) Claims Refunds - (93,210) 93,210 67% n/a - (93,210) 93,210 Insurance Premiums 233,333 224,928 8,405 67% 64% 350,000 350,000 - State Assessments 106,667 89,329 17,338 67% 56%' 160,000 194,510 (34,510) Administration Fee 213,333 222,403 (9,070) 67% 70% 320,000 320,000 - Preferred Provider Fee 33,333 33,842 (509) 67% 68% 50,000 50,000 Health Impact 36,667 34,799 1,868 67% 63% 55,000 55,000 - Refund - ERRP - 58,552 (58,552) 67% n/a b) - 58,552 (58,552) Other - Administration 43,569 33,448 10,120 67% 51% 65,353 65,353 - Other- Wellness 70,000 17,830 52,170 67% 17% 105,000 55,000 50,000 Admin & Wellness 9,896,902 10,253,831 (356,929) 67% 69% 14,845,353 15,488,397 (643,044) Deschutes On-site Clinic Contracted Services 456,000 544,211 (88,211) 67% 80%!c) " 684,000 786,719 (102,719) Medical Supplies 20,000 17,543 2,457 67% 58% c 30,000 17,543 12,457 Equipment 667 2,170 (1,503) 67% 217% 1,000 2,170 (1,170) Other 14,289 30,239 15,951 67% 141% ' 21,433 36,000 (14,667) Total DOC 490,955 594,163 (103,207) 67% 81%'';'c ; 736,433 842,432 (105,999) Deschutes On-site Pharmacy Contracted Services 205,625 260,030 (54,505) 67% 84% 0 308,287 343,325 (35,038) Medication and Drugs 666,667 888,595 (221,928) 67% 89% c) 1,000,000 1,500,000 (500,000) Start Up Costs-Take Care - 59,898 59,898 67% n/a e) - 59,898 (59,898) Other 11,039 11,574 (5351 67% n/a 16,559 30,000 13441 Total Pharmac 231 883 1,220,097 (336 866 67% n/a 1,324,846 1,933,223 608,377 y , Total Spec Approp/Expenditures 117404,936 12,200,272 (795,336) 67% 71% 17,107,404 18,464,823 (1,357,419) Contin enc 198 397 8 - 198,397 8 67% n/a 12,297,596 - 12 297,596 g y , , , Total Approp/Expenditures 18,720,103 12,200,272 7,403,061 67% 41% 29,405,000 18,464,823 10,940,177 NET (Resources - Requirements) 6483,231 13,097,906 8 497 905 - 12,142,435 12 142,435 _ Beginning NWC per Requested FY Budget 12,100,000 Revenues less Expenditures 1,453,123 2,408,592) a) Projection based historical data. b) Disallowance of Early Retiree Rei nsurance Program items (Repo rted as revenue in FY 2012) c) YTD Actual include accruals (January actual paid in March) and estimates (Febru ary based on January actual) Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Eight Months Ended February 28, 2013 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Morse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Reserve Rund (617) Annual County Fair (619) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personnel Services Materials and Services Debt Service Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Year End Budget (7/12 of FY 2013 annual Actual Variance FY % Coll. % Budget Projection Variance $ 46,373 $ 35,055 $ (11,318) 100% 405,052 178,477 (226,575) 67% 29% 1,000 (43) (1,043) 67% -3% 38,294 14,303 (23,991) 67% 25% 4,000 2,600 (1,400) 67% 43% 20,000 18,115 (1,886) 67% 60% 126,667 72,250 (54,416) 67% 38% 63,333 30,338 (32,996) 67% 32% 13,333 1,600 (11,733) 67% 8% 4,533 2,534 (2,000) 67% n/a 676,213 320,174 (356,040) 67% 32% 113,333 113,336 - 67% 67% a) 17,163 17,160 - 67% 67% 55,200 55,200 - 67% 67% b) 176,173 150,000 26,173) 67% 57% 361,869 335,696 (26,173 1,084,454 690,925 (393,530) 67% 43% 76% $ 46,373 $ 35,055 $ (11,318) Exp. 0/61 607,578 414,477 (193,101) 1,500 457 (1,043) 57,441 37,303 (20,138) 6,000 8,600 2,600 30,000 45,115 15,115 190,000 148,250 (41,750) 95,000 86,338 (8,662) 20,000 20,000 - 6,800 6,134 666 1,014,319 766,674 (247,645) 170,000 320,000 150,000 25,744 25,744 - 82,800 82,800 - - 50,000 50,000 264,259 245,000 19,259) 542,803 723,544 180,741 1,603,495 1,525,272 (78,223) 554,588 537,153 17,435 67% 65% 831,882 814,491 17,391 337,482 349,357 (11,875) 67% 69% 506,223 539,305 (33,082) 76,079 70,609 5,471 67% 62% 114,119 114,119 - 9,506 9,000 506 67% 63% 14,259 9,000 5,259 977,655 966,119 11,537 1,466,483 1,476,915 (10,432) 91,341 - 91,341 67% n/a 137,012 - 137,012 1,068,997 966,119 102,878 67°x6 60% 1,603,495 1,476,915 126,580 NET (Resources - Requirements) 15,458 275,194 (290,652 - 48,357 48,357 a) $100,000 budgeted as Transfer GF to Reserve fund will instead be transferred to Operating Fund and an additional $50,000 will be transferred from the General Fund. b) $50,000 will be transferred from the F & E Reserve fund, pending the adoption of a supplemental budget. Page 16 H v w 0 a a a ENO a 441~ U U c 0 0 Z U i4 U B 1-4 a~ a~ a~ a~ a~ GC1 M T c N N 27~ m O U U U) (D LL 6 U C O N O ❑ U c 4 O O. Z U c c~ c~ ch th v M CO) T r M t'7 C7 ce) O C7 0 CO) C7 C7 C7 C? O M M a] 4 CO (0 ti C) t 00 10- 10 C]OLO C)C) r-- rOT co to O O C7 C7 V- f O O r C] C7 'e^ O C7 C? ' r 4i C) N 117 O M CD u7 47 M Lo C7 aO N O N O C7 O O N C) r V N ti r f~- N O C? C7 C7 T- M V n LO M LO IT M f~ N Cl) C7 r t0 r M C tf7 C? M O O C7 F7 O O O O C7 C? co O Ce) C7 cc I,- C) T C7 C] V W O Co 117 C? O 117 r C7 r r f~ f- C] C) O O N 1~- C] O T O C) ' r O O C] LO w C7 O N L f)- c r)- 17 O M u7 O 00 C NT N M M ti C) 0 cV O T It N f- T f- N a O O C) r N r Tlq N V) C) LL7 qt M r- M Cp M t- t0 T C6 r tp co O C7 O r r- T T C? M N M O m t0 f► T O C? o'r d) N M O N M r ch V f- C"1 ' C? O O P- CC a ' CO CA 0) m O N N ' t0 N N 11) C) 4C) N CD CA M O N N N O C) N O ce) f~ T C~ C? O C7 C"1 co CD r Rn C% r r C i I I p O t17 4c] tO 1q N N N N M C) O W r f~ O M N M C] M tf) t- T O C7 CF3 W, CA N 0) C] N ce) M -T fl- C"7 ' C] 0 O n GD C) M W W co C] N N ' t0 N N cC) 6 td7 N T of vi Lr N N f~: t{7 C) CN C) m U') r- CD C) RI- LD q~ CO CD U) r N r r r N O ~ U rt+ U & C C:) C-4 CN '%t •CY C r r r O C C c O O O O C LL LL U_ G) vi E E E c we-00022 Z 0> = E (D a . 2 2 2 3 7 N N c O O C a U) Im U) CA d'mJfY~'I- GF- 0 pJ -0 N E N 100 ~U) m c U :3 fA LL N to ~ ❑ fA y LU ❑ co c) m m rr a m E ca 0 co C CD a 22 ~ c w 0 4) Q c 0 G ~ (D Z A (D N W N C C a) - a) O cu 'D O+ 0) x c 4J a w Cp ¢ (D (D W C LL ~ H H N 1 C N H O c y U G) x W p - U O F Z .r M 0 CA O "a N :3 C7 - Q N N r C 10 > co LL, M' N C7 L } t LL N © U C ~ O C CA N C E O O U a CU 10- r- c @ ~ ~y" O a_ L E v) ca 2 U N N ¢ N 2 O 7 L CN N O N ~ T LL. O N O r } r C= O U- L:) N C O U- U O C cn L U w co U cn =1 O 'C] rn cu co v 3 CL C) CA N C =p 3 U a) O Q) .O N ~ h- ER cu i C 0 1 1 1 1 1 1 o a 0 L N N N p 0 CD LO C) In Lo Ln 9 N ~T r- O 1- N ~ C7 hCDnI-- LO Mw (N C) L6 C7 r C7 C to I ~ N N cU ~ Z "O w U g c7 V W~ N -o O co m ❑ m W Q L 1~ w L y + ZZ y + y ° U L ~ U Z W CZ) O G O O LO O o P Ln Lt j C N N - i C] LCD n c+i tQ C3 E N w C U) CO CD N+ co N L N Lc a ¢ E aa'D - d -6 E 0 0 (D 0 E c 0 E a E 0 0 2N N p T co N C d C L L N C] n.. ~ 7 0) 0) O c: C O ~ ) ( C 2)J 0 ) D . - . - ❑Uw wM:000) L- - W cn c a~ x w N T5 cu m 7 L 2222 N L L L 4 V L 4 V Q Q Q Q Q Q Q Q ' ' CD -3 C~o M co M ca w Of w O co mm mmmm co N L 0 U) c d 7► IL 0 H Ch 4 O (D N 't 6 'O N 7 O U U (D CA LL ~UL ~ ~ rn U 2 a)( O a) 2 tLn CO _n a Cn Q) U C (p I CO r T 1 1 (h th CD (OOCDV) CD It- qr omctma CCD "t00 C) fCO Ln T C, c0 C7 ico o (N C) N Q CQ C7 ' CD n Icco C~ cc t C3 It LO m CO C)COC)coM C (NO Ca CD ~ M a) ~N00 ci r A 00 T r 1 1 1 I 1I C) CO C) to M C) (N O r O (C) O M O 00 C7 00 I• v C) CO T T m a) v T _0 CN O T U- CO -0 (D U) U) E C C C1 ° o Z u a 0 0) ca C: w c L IN N IX N ~ V) CA W 4) N wmU- (D O or cH O> C*) C Cn to 0) 04 T T 1 1 1 Q 1 1 1 1 ~ cV C 7 am M co (OnC)mto COC) M a M 0 0 N O C) N w O C) W Cl Cl) Cl M CO OC~ OI-OC7 mC7d' I,- I~ 0 L6 L6 Cl T O N T CO N N T I,- V) LO T Ln Ln C) Q C) r r co C7 N C7 T CDOO ' 1~C]C 1 4 N N N co LO U') r C7 N T CO LO LO I~ T M Ul) U) CD C) 0) C4 M Q (D CO C) C) rCp N U 0) C14 U-) ce) r- ' C M 1 I ) u 0 I h (p C r LC) r- C NF tC) N co LO U') trj tt! co I Oo I I 1 1 i 1 1 11 11 NIN T T Cf)(0 co Fl t-- m NrNNNr LD m Nr ' T Q M U') ' O) U-) v co r N T 4[) r T T to N co t() Lt7 0 0 U U U C E w O U_ in 0) a Q O W CO y cn U_ N R~ E o o b- ' c U " a) a) cd m U) eo H h'1 0 4) a' a t3 CD c M ca- 0 C~ O a) m .E a, - m O U ro Z LU U) r- (D .ro .S m LD00c ~ ¢`waC5 ~ti~2 ~Z~ W :E U M 'IM) O CO) CD ' r Q) ' IW I L7D CD IC* OD 1 N O d' M to ' N T C7 u~ ' ICI W Ch T N 3 U r c ~ ry (D rnCL X w c o ~ U b O N N CS NII (D mt M 40 N r CD M a) a Z N C LL 'C7 C 7 U- rN-U N T d C 7 0-0 U C [2 E N 0) C 4 N w N N C Q) N 7m N O 1_ N a r LL C C U y' a) ro a) 0 m m (D ~ 'C3 O 0 m CL ro N o (Q 'T-0 m -0 Deschutes County Bethlehem Inn (Fund 128) Eight Months Ended February 28, 2013 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Lease Payments Total Revenues Transfers In: Project Development (140) Gen Capital Res (143) TOTAL. RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment TOTAL REQUIREMENTS Bud et Actual Variance FY % Coll. % Budget Projection Variance $(2,710,000) $(2,710,173) $ (173) 100° 100% $(2,710,000) $(2,710,173) $ (173) 67,061 - (67,061) 67% 0% 100,592 - (100,592) 16,272 18,306 2,034 67% 75% 24,408 24,408 - 83,333 18,306 (65,027) 67% 15% 125,000 24,408 (100,592) 1,100,000 - (1,100,000) 67% 0% 1,650,000 - (1,650,000) 706,667 - (706,667) 67% 0% 1,060,000 - 1,060,000 (820,000) (2,691,867) (1,871,867) 67% -2153% 125,000 (2,685,765) (100,765) Exp. 16,667 9,866 6,800 67% 39% a) 25,000 15,000 10,000 66,667 - 66,667 67% 0% 100,000 - 100,000 83,333 9,866 73,467 67% 8% 125,000 15,000 100,000 NET (Resources - Requirements) 903,333 2,701,733 1,798,400 a) Interest on February 2013 negative cash balance: $1,1093.33. b) Inception through February 31, 2013 Revenues - Lease Payments $ 67,122 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 250,943 Total expended 2,768,855 b) - 2,700,755 (1 Net $ 2,701,733 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2013 BOCC Conference & Travel Jul Aug Sep Oct Nov Dec Jan Feb YTD Total Tammy aney . T.. _ . Conf/Sem & Educ/Training ~ 30 _ 10 65 80 185 Travel Meals 20 - - 66 $2 - 168 Accommodations - 127 119 246 Airfare - - Mileage reimbursement 384 ! - 790 683 557 432 2,846 Ground Transport/Parking 35 - ~ ~ - 35 Total Baney 30 - 566 - - 790 878 ' - 704. 512 3,480 Alan. Unger Conf/Sem & Educ/Traimn 65 305 65 80 515 Travel Meals Accommodations - - - 429 ' - - _ 429 Airfare - - " - - Mileage reimbursement - 112 - - - - - 112 Ground Transport/Parking - - - - - - " Total Unger - 65 _ 112 - 734 - - 65 : 80 55 1,055 Tony DeBone g Conf/Sem & Educ/Trainin 30 15 470 10 - - 35 580 1,140 Travel Meals - - - - - - - - 76 - - 76 - Accommodations - - - 429 - - - 339 768 Airfare - - - _ - - - Mileage reimbursement - 471 = 562 399 1,432 Ground Transport - - 19 19 Total Other 30 15 1,369 10 657 35 1,318 3,434 Total - BOCC Department Conf/Sem & Educ/Training 125 ' Travel Meals - Accommodations - Airfare - Mileage Reimbursement - Ground Transport - Total.- otal - 66-CC Department 125 FY 2013 Budget Percent of FY 2013 Budget Expended - 15 775 20 20 - - 66 127 857 119 496 1,260 683 35; - - - 678 15 2,893 -888 - 76 165 82 - 740 - 339 1,840 244 1,443 562 19 557 - 831 _ - 4,389 54 657 804 1,910 7,970 - 15,250 52.3% BOCC County College Office/Copier Supplies - - 85 - - - 85 - - -T - - - - - - 2,441 811 869 Meeting Supplies 761 Total BOCC County College 846 ' 811 869 2,526 NOTE: Above amounts include only those expenditures processed for payment. Additional conference and travel costs may have been incurred, but not processed for payment. 2/26/2013 Community Development Department Planning Division Building Safety Division Environmental Soils Division 117 NW Lafayette Avenue Bend Oregon 97701-1925 (541)388-6575 FAX(541)385-1764 http://www.co.deschutes.or,us/cdd/ MEMORANDUM To: From: Work Session: Re: Deschutes County Board of Commissioners Nick Lelack, AICP, Interim Director March 25, 2013 City-County IGA Updates The purpose of this work session is to brief the Board of Commissioners (Board) on three City- County Intergovernmental Agreements (IGA), and answer questions in preparation for their consideration of two of them on Monday, April 1. The Board on April 1 will consider approval of the City of Redmond and City of Sisters IGAs because the amount of those contracts exceeds the authority of the County Administrator. 1. City of Redmond for Building Inspections and Plan Review Services IGA. Since 2002, the City of Redmond has contracted with Deschutes County to provide building inspection and plan review services on an as-needed basis. The agreement was last updated in 2008. The County has provided residential building inspection and plan review services, as well as plumbing and electrical building inspections. During the economic downturn from 2008-2011, the City laid off building services staff except its Building Official and one permit technician. Now, with residential permit activity increasing, City staff is experiencing heightened demand, but not enough to hire additional staff. This IGA update expands the County's services to also include residential and commercial building mechanical and structural inspections and plan review when requested by the City. In addition, the agreement formally recognizes County staff's role to continue providing back- up building services (e.g., consultations with customers) when City Building Official Gary Lampella is unavailable. To compensate the County for the additional services, the County will earn 55% of permit fees, up from 46% under the current contract. The Redmond City Council approved the IGA, and Interim City Manager Sharon Harris has signed it. 2. City of Sisters for Building Official Services IGA. In December 2012, the City of Sisters selected Deschutes County to provide Building Official Services. Beginning January 1, 2013, the County serves as the City's Building Quality Services Performed with Pride Official, performs all building inspections, including structural, mechanical, electrical and plumbing, all plan reviews, and provides office hours 4-5 days per week at city hall. Deschutes County earns 62% of all fees,. The City earns 38% for taking in all permit applications, and providing office space, equipment and supplies. The Sisters City Council approved the IGA, and City Manager Eileen Stein has signed it. 3. City of La Pine for Planning and GIS Services IGA. Deschutes County has provided current planning services to the City of La Pine since its incorporation in 2006. The first IGA was established to formalize this service in 2007. The contract was renewed annually through 2012. The IGA was amended in 2010 to address appeal procedures, and in 2011 to address land use permit time extension. The updated IGA provides the following: The City may take over planning services with a 30-day notification to the County. The County will provide GIS services to the City for fees established in the IGA. The City and County will establish in writing procedures to ensure land use compatibility with building permits when the City takes over planning services. The La Pine City Council approved the IGA, and the Mayor and City Recorder have signed it. This IGA is pending Interim County Administrator approval and signature. It does not require Board approval due to the compensation structure (the County receives land use permit fees for services from applicants) and fees/amounts fall within the allowable range for the Administrator's approval. Attachments: Deschutes County IGAs with the Cities of: • Redmond for Building Inspection and Plan Review Services • Sisters for Building Official Services • La Pine for Planning and GIS Services ECONOMIC DEVELOPMENT FOR CENTRAL OREGON Deschutes County Economic Development Investment Initiative Revised & Abridged Proposal for 2013-14 Fiscal Year March 20, 2013 OVERVIEW The following proposal was refined from a lengthier and more comprehensive draft proposal provided to the Deschutes County Commission and staff in January 2013. Before outlining this proposal, EDCO would like to acknowledge the outstanding partnership it has enjoyed with Deschutes County over the past three decades. For the current fiscal year this includes $112,200 for the regional economic development organization, $20,000 for the Venture Catalyst Program and the significant investment made in the Deschutes County Forgivable Loan Fund, which has been a very important local incentive for job-creation projects. Without this funding, EDCO's current level of effectiveness would not be possible. The matrix and supporting narrative below represents only a one year investment for consideration at this time. Ideally, Deschutes County leadership is committed (as it has been to EDCO funding in the past) to a sustained, multi-year effort for the best possible results; however, the details of such a partnership are not outlined in this document. EDCO's TOP FUNDING PRIORITIES Deschutes County Local City and/or Estimated Total 2013-14 Private Sector FY13-14 Program or Program Investment Investment Budget La Pine/South Deschutes County $20,000 $28,000 $48,000 Sisters Country $20,000 $40,000 $60,000 Greater Redmond $10,000 $129,000 $139,000 Greater Bend $15,000 $95,000 $110,000 Sub Totals: $65,000 $292,000 $357,000 Supporting Entrepreneurship Companies Venture Catalyst Program $30,000 $45,000 $75,000 FoundersPad Accelerator* $15,000 $60,000 $75,000 Sub Totals: $45,000 $105,000 $145,000 Economic Regional Development Capacity Administrative & manager $5,000 $10,000 $15,000 coaching for new local programs Targeted marketing & lead $10,000 $10,000 $20,000 generation Sub Totals: $15,000 $20,000 $35,000 TOTAL: $125,000 $417,000 $537,000 'FoundersPad is not on EDCO-managed program Strong Local Economic Development Capacity A strong regional organization with equally capable economic development professional capacity at the local level is a model unique to EDCO in the Pacific Northwest. EDCO contracts to deliver comprehensive local economic development programs that are financially underwritten by the communities. This proposal launches a new program in La Pine with a half-time manager, takes an existing program in Sisters to the "next lever with a three quarter-time manager. In Bend and Redmond, funding will boost ongoing activities for established programs by supporting focused marketing and recruitment efforts outside the region (specifically California) to generate new leads for job creation projects. Although not equal, EDCO believes the allocations between these programs are equitable and consistent with the needs of each community in the region. Supporting Entrepreneurship & Early Stage Companies Fostering entrepreneurship is an important and relatively new component to the region's economic development strategy. The two critical components for establishing Deschutes County as a premier place to start and grow new companies are 1) a robust mentoring network and 2) access to equity/growth capital. Development of these key infrastructure assets will not happen without focused and sustained effort. EDCO's funding priorities for the coming fiscal year include partial underwriting of the Venture Catalyst Program (VCP) and the FoundersPad accelerator. FoundersPad is a key infrastructure asset for mentoring concept stage companies, while the VCP is focused on both mentoring and launch of a new year-round angel investment fund and early growth stage venture capital fund based in Deschutes County. Regional Economic Development Capacity The model that EDCO has pioneered over the past decade has had the effect of reducing capital available for the regional organization. Volunteers and local managers rely on services which include, but are not limited to, marketing, lead generation, professional coaching, legislative, recruitment process management, event production, media relations and critical improvements the region's business climate (air service, industrial land supply, transportation improvements, etc.) to effectively execute at the community level. Adding oversight of programs in La Pine and Sisters will stretch existing regional staff even further. This element of the Deschutes County Economic Development Investment Initiative is to ensure that the regional organization remains financially solid and fully capable of supporting local managers within the County's borders. Summary EDCO applauds the Commission and the Deschutes County administrative management team for your vision and foresight to seriously entertain this proposal, which is a significant step forward in changing our economic development future, and how video poker lottery funding is invested. We believe this proposal represents a well-planned and cost effective strategy that is broadly supported by the communities within Deschutes County and leverages greater investment (nearly four-to-one) in economic development. Pending the approval of the Commission, EDCO stands ready to execute on all elements of the initiative in a timely manner. M e-I 0 N rl N M 4- O LA m N 7 a+ co 10 C 3 LL m IL^ V O 4+ L V LA 0 0 0 0 O Q O ~r co cm LD n n m 0 0 0 0 0 0 0 0 M m en lD ~o w m Ln Ln 0 0 0 N r N m m 00 lqr ' O1 Ol n m m O Lri Ln Ln 4 Lfj 14, d' l6 M O 1~ ' r i 00 00 N •-i i/} i/} r!T i 4 t/'!• t/} {P'F td F tJ} q* m 4.4 to t~ tl? Ln m a ro 7 ~ ,4 cf O ~ CJ I Q W LL a C L a ¢ O C a y tn Ln O O m U 0 IZ a E a a a a a Q i C 0 , a L s O , W a C O , a L s C O , a i s is v ro m r CO C: tw cc r- G m C 4~ FO a.+ Q p - m m 0 D co O O 1 O co O O CD CD CD a Lfl r r1l ~ ry rl~ r-i i -1 N ~--I ih '6l'F ih t/1 tn' ..Lf V ` Y m v L ro 1 M w C14 L L W w Q N to to } L S C LL S a -O ro ro Ln a N a a ' -a cc ac o M c c f° a a' +-j m CL E E Iy LJU Q Q U) O m V C Q CO U c O N_ Q C7 p N N 0 N C a U A m O r d O) T m co W O m 0 N Q W- 42 m Y O O d Lo C N a ` C O c o d. [L1 N W Cn •C. 7 M c O w N co 'm U- 0 ' CT W - t• U C 'r~ U U ~ G ID O lL EN , T ro m W C) O G~ "O N . 7 C C T a¢ C C C m m c-U-`Oq.-.'a'te _1 m i -`°r -w m - co w' a m a m C N Cr 7W c. c c~~-~ c U•c N~ a O w m 'p o W 7 - E o C „C) IU- _r m Cri E_o U N ~ rna m9 c co E p C~ c N w- > C p O c O _m O Z - O p _ tU t C - U c O U N U C - 7 m Z N 0 IJ .E C N E g 0 L W- L C C c o o g m o G n o a g° ~'c a 7 E- m n U J 2 a G m c c O m p y 0, ~ a~ E ,S U0 a ; N ~ v~ ' U U `W o ~ o~ ~ d m p m~ ~2 c rnM ~'o w 7.; x m p m 3 ro u. F U cn ~ ij o d m m c w E ~v a m° m U o o m. d - Q o o o c Y 0 CL (13 d rL 61 q~q~~ lL_ p N N O O Q~ U 7 N J C O L co U O Q1 ~p U W C N O c y ¢.ro. 1 u..❑ i6.J ° d. t o c c p rc c 0.N.:., o) ° m E c aci m o a 7 Cm] 01.x. E-. :C U N, N 'C p N C :.7 7 C¢ Q...R- 3 C. 6 E C O 2 m m O U W J W U d 7 U N 2 'QN Qf' J U O LT N J:.W 7 U v E m 'Z J ~.Cfj Q U¢ J ON U lL d LL C300.0000 6666060 O O 0 o. o a rs 0600 O0 0 0 G 6. t7 6 6 0 6 0 O. 0 0© P' 0 v Ca Ca Ca G o o tl a 6 6 'O O O C3, 6 4:5 6 o C7 66 6 6 C'O 0 6 O O O Cl 17 C) P C?.O. 66014060owCD CD.9p 01 K6a06)0 000 CD GgCD 000 q q "0' 6 0 40 o in o C Ll uQ a s o' 6 N:.N tv N V, N 'r r m - 0 M w w : 60.40 w W' ":w 40 w 6q in 69 us 40 O O O 4 Q d b b O 0 O C) Cl o o G (D G GGCSa QqQ 6 6 6 C., CD CD CD 1o OO O o 0 0 M 4 4 O O O M I O't0 CN N N r 0 V) 60.69.64''63. v3 v3 60 w Sri V3. CS3 69 69 Cs) 69 E/i 6v cg vi U.) E» as u-, v~ 6s W) 6% 6q O'O O O'..' 'o d 4 b d o o n b O a O O.' 'Q O 0 D o d d O O O 66, C) O O O c'i O O- O' O' Q' G O o rM G G 0 0 047. C?'C7 CV o f). o r) U) O U) 69 t6' 64 6'D 6464 69 v3 v3'. 64 to 0' bti t`' v7 to 0 e9 Cfr Q> 69 L9 0 Cr7 <fl Ear di 6fy y9 C9 O. 0..0 -O G O G. G G G G G' O C) 'O O' ~.,C7.U OO o d o00b bO O CJ CD O' O CD 0 4 G O d 0 0 O Q (D so CD CD d O G G G m G G C) CD O 47''.' O 4n d N U) U1 O M U) U) U) o O N N Lo 63 63604 " 64 64 v) 64 69 69 W w 69 69 69 69 f9 d-}.Eq 69 C/} VT 69 69 69 64 w 64, (t3 O O. O d 0 Cl c Cl 0 G G G 'G G G G O G G G G Cl G G G O G G O O O Q O O O Q 4 0 0 0 0 Q 4 00 0 0 d o b 0 0 0 0 0.0 0 0 o G G 0 0 0 0 G o 0 0 0 0 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 O O o O G 4 4 0 4 0 0 0 0 0 0 0 0 0 0 6 G o C7 0 0 C7 O U o 0 o O U7 O o 0 o O V o 0 O O O' G G G 0 4 4 C7 0 4 4 U 4 d N U U U U o U U 4 U Q Q Q Q Q o Q v O Q Q Q Q co Q O In Llzr O r cl c 0 0 G G N U7 O O ICJ N N G LQ U7 G G U7 g G G O 'O 0 0 U) U) CP N N N N 4 0 V U) O C 1' N. N m N U) C) U7 N. m N m N m N N U) , N N U7 U) Lo N CJ N N N r r r r Ch Uj N N W v3 V~ 646969 bFi to us 69 v3 H3 bs Ea 69 HT 69 EA 69 ft 6969 Et76969 fq Efr b969 b9 b V3 V C C f 6 69 f V3 V3 V3 f U Q' Q d C U C O C9 N 6 O N N N N. N'CV N.CV 04 04 N CV N N N N'.N N:N N N N N r N N N M M M C7 M [h M M Ch ch C") crJ M O'O O ~ O O.D 4 O;'.N N O.N rO N O;N b 4'O O 4 d N 4.4 O b b.... Q Q O N N Q O Q N N (D Q Q IN 14 'ZI LV Fi_'~V N N ~V' Ly 4 v) O N''. N N Lv CC) " f• ~ U>-V t0 r O M ~+l 1~ V C7 1~ Mr OrONW LO NCO r U7 N N r N r`. _ O N N_ N N e- C` N N r N r n n a T m r~ m 4) ~ r r.-.~ N r]c, ' r C`V r~- CV r`- r M r r r r r - N N N N N N N N" N N N M [•7 C•7 Co M Co Co Co C`7 N M C•7 m zzzz}}}z~~~zzz~zzr~rrZ- .0 Lam C No bl ° C 0 O ° LL. ° N L Q s„ p •nn ro U- C p N' otc . m o p O U 7 ~ ~ ` ~ U C ° a C. L O C fC L wr- F ~ 7 c o ° ) 5 E) a (n a) C o C t) !V C6 ' E 7 0 C U N N ' ~ U m (6 5 p ~r " N O W m ' K _ q C E ° ro E d' U U y m c . . m N v m ' L U Um= b LLC'... OO7.CC e to . r ._.OVS.E O4) , ~ . 4 _ o m _N OUO EUd't~ L C ~ L m O a E L. o ~ C 9 m 'n LL L L N ~ o i Q o Z - m? c O 0 o m Q, L ) N N d ' U j j C1' Fj " d 0 o 16 0 O1 L Vl m V U U J 1 O U U N L1: or O Q . 0 c ` m v 0 O p 67' C d a 6 V C L N WT N m p o C¢ a) 0) D > N = U d d L ~ L r u,, Oo as EZ Qm w E 'C N EL m W ° ~ ci m O N Q1 F w no °a3 q) N C L m 7 L L E Y r L o V r 0 u n -2 . E d d t U.'~ C7 0 ~ N ¢ L O N` C O❑ 'um M m [4 w c m cm 6~i L-' . E E a a~! c rn L Ql Vi N N E 0. m m U a 0 o o' ] 'C ~q "O m Q C co ro m m m CO CJ,U ,...I J Z.Z Q,.ln...W. .v N m o° C6 y ..LL U U U,C], C],'...Z O„U CO Q m m 7 N 0 U U D = Z (n 0 0 0 H 5 4 O r• M w 0 N M Pi w 0 47 1P w O r d 7 a E U I c m ro ~ a c1 e' ~I' C7 'I a' f06 O co u E ` Eli ~ CHI' D bA ro rI 7 ~I M Q N '1 I ai I 1 ~ 'Cf d I I I 'I ~ ~ o o W a1 1 I CU CU 11 _ _ II Cu O ooh' c7aC) ° o 01 °o o 0O °0 1 ° ° o 0 o alo cs C), o 0 0 0 d'olo o'''. 11} v1 o yr V)- O 11} 11} n Ln o o ~--I N 11 Ln Lf) 11x1'1 qj'~ vy'V-j- o a oo 0 0 0 0 0 oo o'. 00O1o0000000C) C) a 4 o O.~* O O C) 1101C) O Ln Ln O 11} v). 00 0 0 o Ln o o l r• r• o r--1 Ln o 0 rv Ln Ln tn. tn L4 11x, 1n. V"- I 11 o oO O O ;C010 O O 4 0 0 0° 0 O110 O O o 6 O O c i o !0 0 6 0 n 1O; O 0 0 N Ln N Ln Ln 111 0 lf1 III th -Ln 11 11F 4-4 111•'1, 44- 4l} J). V). 1 N 1 I I I I, ~ 1 O L i 1 I M LL, o 4- QI' pI Ln c I O in Y ' Z O ~ O O 1 I ! I ' I '1 I L o~ ~ ~ , I a 'O 1 NI a-+ tio N ° f 7 m c v ro U 0I I a p 1n o } m qp LI w p - 010 ' S II ±f I N Z. 'O p Q E r! EI - 7 1 C 1 ¢ p ` vl a p 0 1 CL) o ao U aj 0 1 i a 4 s > w ro L4- U U LL rv.• p LL Y v1 p vn c O U 1n c s V) tLo m ro . a -C CUD ra - ¢ 1^ a L O a a a,= ~ I M a 7 ' t v 4) ~I E 3 1 IY, a a 'A s a 'a O U 1 =0 4 a I a C O U 1 1 Y Q 1 1n O , ❑ 0 'm` C a U ¢ E n O 3 'A L , vm °p ,j ~L v,¢ 4- v, 11 v m a a n QI VLm CIO U S Ln H N 75 (1 JIZ d I QI all n •ii tI 0 S? O ro r I I I I I a I O I m N a m G Ln a CL tio ~ m a o- ~1 o cr c ro .I 0 1 a ~ 4- 1 0 0 0 00 tio L 00 ro E ! u O O 4 7 j v v CL _ p m U Mro I I I Q ~ _ r. _ N V et C] O O O Q1 N O y ri N &M N w I T! I r% N 0 ao iA M A6 N A4 t0 4^ 4 rq M ~ tD N M O ' lL 00 n j co 00 rq I ~4 N to ri 01 -j 1 0- C I ih +n - - ~ L 'd W O tD cn O O O M W CD V4 N W a oo O co O O O© O U l t4 a 4 W Q W y f~ O 1l M 00 0 010 N r-1 O tl1 t!1 > tL ti. a r-I TH N 1 N 00 O L' 1L' N N r-i W tD N O 00 V1 co An. Ln tp r-I ! V? r-I ri v-I I► W-1 0 Ln Ln M VF ri ; r-1 Ln 4!f tD ~i in z o 'a 0 0 o cm o O 0) 0 0 00 00 0 Rt O N a (D C) O Ln n In l► ! 00 to 0 C O 0 N M l t o R a n o C) Rt 0 LL LL h0 O O 0 0 0 tD Ln N M r4 A4 00 o l 'O O O r-1 Ln t0 ~ r-I V} r1 ri ri n 4 7 co t0 i,J? t0 to L? M An 44 r-4 V} r -I +h 41? 1!4 W a"1 V► (U ro ti° a ,A i I O ~ 41 C L U H O ro ~ - a CL O U a v ' y J ~ C ~ ro ~ O ~ a y E ro Qu a ro u ~ G ~ a 3 ro ~O a 0 E E a u u ? O O U c 4J C41 L 4~ !n 0 i N N c V ~ i u I C I a I ~ I d I ' I a ~ v , I a I ~ c m M C d C m co 4-- a C tko a .o a u.1 C 4 c C ' ' u a a , p x o o H W F^ co F- Deschutes County Video Lottery (Fund 165) Through March 19, 2013 Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Pro ection Variance Revenues State - Video Lottery (a) Interest Total Revenues Expenditures Personnel Materials and Services: Grants ( 59.20) Community Grants Discretionary Grants Tammy Baney Tony DeBone Alan Unger COCOA CASA Deschutes County 2-1-1 Upper Deschutes Watershed To Be Determined (b) Total Grants Law Enforcement Dlstrict #1 Economic Development of CO Memberships & Dues ISF Charges Capital Outlay Total Expenditures ( c ) Contingency Revenues less Expenditures Transfers In - General Fund Transfers Out - Econ Devel Fund Change in Fund Balance Beginning Balance Ending Balance $450,000 $458,186 $ 8,186 75% 76% $600,000 $581,786 $(1.8,214) 563 781 219 75% 104% 750 -000 25D 450,563 458,967 8,405 75% 76% 600,750 582,786 17,t1e64 7,942 1,791 6,151 75°k 17% 10,589 2,319 8,270 262,500 315,050 (52,550) 75% 90% 350,000 358,800 (8,800) 15,000 7,333 7,667 75% 37% 15,000 10,333 4,667 75% 52% 15,000 15,334 (334) 75% 77% 24,375 10,000 14,375 75% 31% 22,500 10,000 12,500 75% 33% 15,000 16,250 (1,250) 75% 81% 15,000 15,000 - 75% 75% 10,104 12,500 2196> 75% 91% 394,679 411,800 (17,121) 75% 78% 5,000 51000 - 75% 100% 84,150 84,150 - 75% 75% 13,758 12,134 1,624 75% 88% 8,294 8,294 - 75% 75% 75 75 76% 0% 513,898 523,169 (9,271) 75%, 77% 20,000 20,000 - 20,000 20,000 20,000 20,000 - 32,500 32,500 - 30,000 30,000 20,000 20,000 - 20,000 20,000 - 13,739 12,500 1,239 526,239 533,800 (7,561) 5,000 5,000 - 112,200 112,200 - 13,758 12,134 1,624 11,058 11,058 - 100 100 678,944 676,511 2,433 _ 47,867 - 47,867 75% 0% 63,823 - 63,823 (111,202) (64,201) 47,001 (142,017) (93,725) 48,292 89,350 89,350 . 75% 100% 89,350 89,350 - (35,500 35,500 - - 75% 75% 47,333 (47,333) (57,352) (10,351) 47,001 75% 10% (100,000) (51,708) 48,292 100,000 116,562 16,562 100% 117% 100,000 116,662 1656~? $ 42,648 $106,211 $ 63,563 75% NIA $ $ 64,854 $ 64,854 Beginning Net Working Capital per Requested Budget 100 000 a) 4 quarterly payments. b) Three payments made in FY 2013 which were for prior years. c) Appropriation will be transferred from Contingency to Materials & Services, as necessary. / n A"~\ Community Development Department Planning Division Building Safety Division Environmental Soils Division 117 NW Lafayette Avenue Bend Oregon 97701-1925 (541)388-6575 FAX(541)385-1764 http://www.co.deschutes.or.us/cdd/ MEMORANDUM To: Deschutes County BOCC From: Will Groves, Senior Planner Date: March 19, 2013 Work Session: March 25, 2013 Re: TA -12-3, Title 19 Destination Resort Overnight Ratio Public Hearing SUMMARY Weston Investment CO. LLC has applied for text amendments to the Deschutes County Code (DCC) to change the ratio of required overnight lodging to residential units for Destination Resorts in the Bend Urban Area, case file Text Amendment (TA)-12-3. Before 2003, Destination Resorts were required by state law to provide 1 overnight lodging unit for every 2 individually owned lots in the resort (2:1 ratio). The text amendment would allow 2.5 individually owned lots for each overnight lodging unit in Bend Urban Area destination resorts, as allowed under ORS 197.445(b) since 2003. A draft of the proposed amendment is attached to this memorandum. On February 28, the Planning Commission voted 4-3 to recommend the Board of County Commissioners approve the proposed text amendments, subject to developing findings under Goal 12 and the Transportation Planning Rule with Staff. Staff believes that suitable findings have been developed in coordination with the applicant. Please note that Staff has received an application for a parallel amendment to DCC Title 18 to change the destination resort overnight ratio to 2.5:1 in the rest of the County, outside of the Bend Urban Area. That amendment (TA-13-1) is scheduled for Planning Commission deliberations on March 28, 2013. A motion to recommend approval of TA-13-1 failed on a 3-3 vote on March 14, 2013. Staff seeks BOCC direction on the public hearing process for the two text amendments. Specifically, should the Title 18 and 19 amendments be coordinated and heard on the same dates or be heard on separate schedules? The applicants have requested the amendments be heard separately.. Because these two matters are similar, hearing them on the same schedule Quality Services Performed with Pride allows ideas developed in either hearing process to be easily applied to the other text amendment. However, there are advantages to hearing these matters on separate schedules similar to the Planning Commission. The impacts of the Title 19 amendment are more geographically restricted (to the Bend Urban Area), making the analysis and findings somewhat simpler. The knowledge gained from the Title 19 amendment hearing process may inform the Board's understanding of this issue as it considers the broader impacts associated with the Title 18 amendments. . The Title 19 amendments can be scheduled for a public hearing as early as Monday, April 9, whereas the Planning Commission may or may not make a recommendation on Thursday, March 28. If the Commission makes a recommendation on March 28, the earliest a Board public hearing can be scheduled is April 30 due to staff scheduling conflicts. ALTERNATIVE COURSES OF BOARD OF COUNTY COMMISSIONERS ACTION 1) Direct Staff to schedule the Title 18 and 19 amendments for hearings before the BOCC separately and as soon as each amendment is able to be heard (Title 19 on April 9 and Title 18 on April 30), 2) Direct Staff to coordinate the Title 18 and 19 amendments to be heard on the same dates (April 30 is the earliest date both amendments can be heard at the same time).. ATTACHMENTS: 1. Proposed Amendments to DCC Chapter 19.04, Title, Purpose, Compliance and Definitions. 2. Proposed Amendments to DCC Chapter 19.106, Destination Resorts.