The URL can be used to link to this page

Home My WebLink About2013-03-25 Work Session Minutes Minutes of Board of Commissioners’ Work Session Monday, March 25, 2013 Page 1 of 11 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 2 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 ex isting 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 3 of 11 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 4 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 5 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 o versee 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 4th quarter this year for two years. Revenue projections are down. Minutes of Board of Commissioners’ Work Session Monday, March 25, 2013 Page 6 of 11 The net impact will be about $18,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 - $1,500 – 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 7 of 11 ___________________________ 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 III. 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 8 of 11 ___________________________ 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. ___________________________ 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 9 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 10 of 11 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 II. 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. 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 fitrther items addressed, the work session ended at 2:55 p.m. '2..,AI~ DATED this t/:---Day of ~ 2013 for the Deschutes County Board of Commissioners. Al ~ ATTEST: Anthony DeBone, Commissioner Recording Secretary Minutes of Board of Commissioners' Work Session Monday, March 25, 2013 Page 11 of 11 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, MARCH 25, 2013 1. Finance/Tax Update -Marty Wynne. Jeanine Faria 2. Discussion ofIGA'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 o/Commissioners' meeting rooms at l300 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. I i I I I I I - 4o Work Session (Please Print) Name · :3 ~·.... E<-~ --.!~v"-v , IJ I-J I '" /... E IL _ Kef! S.l{j2E~/;t)tY£g 1- Monday, March 25, 2013 A~encv Mailing Address ~.Qrl Zip _ Phone # e-mail addres ~ . ~~{oz jl~k"'~~L"II£. \dSt:: -=-~t _ 4i\\~_$'1\\lIu1oluH" 'v~~l ~~~ ~_ ~!I{-l-CX; -~~~o . __ clC.VI .",-; ll£v@ S-15"-££~1 ?~.I3'o)U2U S'5XC./2f 9D~ S''IC'1JD cAQJ' dL~~«C£ec,. ,.",._. &_ .s;'/tff/c/Cs /rb,l/"S/il,e~p;J~' ;-;2,4)).5 A )~//1A1 Ig;;;; CJ 6vJ(/lW I .5/s/'Qs _ / /...5' ~fL27/-OB.'£'/ a G /Yl/9/~~C!, _ -~ I I r L t -t I Page # of Pages I · 1/z'o,-n. Work Session (Plel1s~ Pr~nt) Name =}:~'" E,-~"'R-f 0c.."V I iJ I-I I t-. '-'~a... /)£~LS£Rk~!-E/JI/):: VRE _~~_l~IM~Uing Address T I S, s'1::EIf.s KIIAj)./.o1~S ?D. [Sol< 1;('1'6 ~/ff/E/cs J.@)J2fl)J//1N(~/~~~~1P I I Ci!'l~ip -=,"T"loz Phone # ~~~I ~ 3)~-1dG-t,G60 , S'ST&"12f I 9r-)S'Y 15"~t J../tOrPl,.OIC, .5/5;T.e;e~: ?//5ft512:2(/-ps~ 1 I I Monday, March 25. 2013 e-mail address jl~k.\~~(("\/(,t'. tr..: ll.£v @ /-(5"1/,,, SIiIR 4 eLL b.~~~./~eev ~~St j eo ..". p;)~' &G~fl/A"t:!. Pas:e # of Pas:es Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 25, 2013 (1) Monthly Investment Report (2) January 2013 Financials "., Deschutes County $ 8,113,468 7,094,838 3,941,893 Commercial Paper Corporate Notes Time Certificates U. S. Treasuries Federal Agencies Bankers' Acceptances LGIP/BOTC Total Investments Total Portfolio: By Investment Types Time Corpo~'M'ificates Federal Notes 5% Agencies 6% 3% LGIP/BOTC 86% 0.00% 5.96% 5.22% 0.00% 2.90% 0.00% Investments By County Function General $ 136,026,906 $ Investment Income Fiscal Year 2012-13 Jan-13 I I Y-T-D 71,217 $ 420,133 -- Total Investments $ 136,026,906 Total Investment Income Less Fee: 5% of Invest. Income Investment Income -Net 1$ 71,217 (3,561 ~ 67,656 420,133 (21,007~ $ 399,127 Yield Percentages ---~.~BOTC I LGIP ~ 0.59% 0.59% Investments ~ 0.75% 0.82% Average ~ 0.61% 0.62% Category Maximums: U.S. Treasuries ~LGIP Federal Agencies Banker's Acceptances Time Certificates Commercial Paper Corporate Notes Term Maximums: 0-18 Months 19 -24 Months 100% 100% 75% 25% 25% 20% 10% 100%J 30% t,clOomparators 3 Month Treas. ~ 0.07% 12 Month Treas . ~ 0.14% 3 MonthCP ~ 0.18% Months to Maturity 18 Months 92% 24 Months 8% 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), Sheriff's (255,701,702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice -Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data Seven Months Ended January 31, 2013 RESOURCES: 8eg. Net Working Capital Revenues Tax Revenues -Current Tax Revenues -Prior Gen. Rev. -excl. Taxes Assessor County Clerk BOPTA District Attorney FinancelT ax Veterans Property Management Grant Projects Total Revenues Vearto Date Actual Variance $ 8,700,000 11,778,410 396,667 1,392,610 436,699 805,013 7,232 107,738 116,025 39,900 57,892 1,167 15,139,353 $ 9,059,394 $ 359,394 18,660,711 6,882,301 851,224 454,557 1,984,414 591,804 675,147 238,448 944,658 139,645 13,313 6,081 84,573 (23,165) 202,950 86,925 18,887 (21,013) 54,976 (2,916) 1,167 (0) 23,492,018 8,352,665 100% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 104% 92% 125% 83% a) 90% b) 68% 107% b) 46% 102% b) 28% c) 55% 58% 91% FY 2013 Budget Year End Projection $ Variance $ 8,700,000 $ 9,059,394 20,191,560 20,416,485 680,000 877,835 2,387,331 2,687,331 748,626 873,626 1,380,023 1,620,023 12,398 18,313 184,694 184,694 198,900 242,950 68,400 68,400 99,244 99,244 2,000 2,000 I $ 359,394 224,925 197,835 300,000 125,000 240,000 5,915 44,050 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: I Exp.%1 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 FinancelTax 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% nla 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 NET (Resources -Requirements) 19,998,519 3,840,835 14,674,589 17,876,824 5,323,930 14,035,990 58% 43% e) 341283,176 370,000 25,986,998 10,163,297 8,296,178 9,793,297 a} Includes annual payments: PILT $730,983. FY 2012 PILTwas $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 Transfers In-General Fund Year to Date IFY % I Coil. % 100% 98% 58% 0% a) 58% 118% b) 58% 41% b) 58% 42% 58% 67% c) 58% 50% d) 58% 150% c) 58% 0% 58% 34% e) 58% 0% 58% 0% 58% 28% 58% 46% 58% 50% 58% 207% c) 58% 48% f) 58% 50% d) 58% 55% 58% 58% FY2013 Year End Budget Projection Variance $1,010,415 6,000 3,867 46,133 13,000 21,000 375,347 60,000 100 122,000 200 50 1,000 8,000 1,200 500 125,661 20,000 804,058 5,344,523 $ 995,051 $ (15,364) 6,000 6,655 2,788 46,133 10,000 (3,000) 28,000 7,000 375,347 150,000 90,000 100 100,000 (22,000) 200 50 1,000 6,200 (1,800) 1,200 1,500 1,000 125,661 20,000 878,046 73,988 5,344,523 Budget $1,010,415 3,500 2,256 7,583 12,250 218,952 35,000 58 71,167 117 29 583 4,667 700 292 73,302 11,667 I Actual $ 995,051 4,555 18,707 5,468 14,010 188,030 90,240 41,479 275 3,676 600 1,036 60,731 10,000 442,123 438,806 3,117,638 3,117,639 I Variance $ (15,364) (3,500) 2,299 18,707 (2,115) 1,760 (30,922) 55,240 (58) (29,688) (117) (29) (308) (991) (100) 744 (12,572) (1,667) (3,317) 1 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 2,960,427 696,477 58 29,400 489,719 2,876,949 608,159 25,200 83,478 88,318 58 4,200 489,719 1 Exp. %1 58% 57% g) 58% 51% g) 58% 0% 58% 50% h) 58% nfa 5,075,017 1,193,960 100 50,400 839,519 5,025,017 1,075,000 50,400 50,000 118,960 100 839,519 TOTAL REQUIREMENTS 4,176,081 3,510,308 665,773 58% 49% 7,158,996 6,150,417 1,008,579 NET (Resources -Requirements) 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 Actual Variance Variance RESOURCES: Beg. Net Working Capital $ $ $ 100% nla $ $ $ Revenues .Law Enf Dist Countywide 13,160,949 10,734 ,945 58% 48% 22 ,561 ,626 18 ,854,105 .Law Enf DiM Rural 8,424,320 7,270.494 58% 50% 14,441 ,692 12,299,717 Total Revenues 21,585,269 18,005,439 58% 49% 37,003,318 31,153,822 TOTAL RESOURCES 21,585,269 18,005,439 (3,579,830) 58% 49% 37,003,318 31,153,822 (5,849,496) REQUIREMENTS: Exp . %1 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 PatrollCivillComm 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 SVC5 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 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% nla 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% nla 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% nla 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 58% 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: 1 Exp. %1 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 Non 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 Fund 255 13 ,160,949 10,734,945 2.426,003 22 ,561,626 18 ,854,105 3,707,521 Transfer to Reserve Fund (703) Non Dept -Comm System Res Total Requirements 58,333 46,667 13,265,949 100,000 80,000 10,914,945 (41,667) (33,333~ 2,351,002 58% 100% 58% 100% 58% 48% 100.000 80,000 22,741,626 100,000 80,000 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 PUBLIC HEALTH Statement of Financial Operating Data Seven Months Ended January 31,2013 RESOURCES: Beg. Net Working Capital Revenues Medicare ReimbUrsement Federal Grant Federal Grant (ARRA) State Grant Child Dev & Rehab Center State Miscellaneous OMAP Title 19 Family Planning Exp Proj Local Grants Environmental Health-Water Contract Payments Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records-Birth Vital Records-Death Environmental Health-Lic Fac Interest on Investments Donations Interfund Contract Administrative Fee Vearto Date Actual Variance $1,336,051 583 116,667 1,700,037 23,105 78,598 366,093 205 320,833 28,000 53,783 60,556 112,700 60,142 23,917 58.333 420,029 7,000 3,092 92,534 467 $ 1,327,199 $ (8,852) 8 (575) 5,000 5,000 106,250 (10,417) 1,567,878 (132,159) 16,360 (6,745) 77,967 (631) 235,739 (130,354) (205) 224,928 (95,905) (28,000) 36,132 (17,651 ) 68,648 8,092 2,139 2,139 112,324 (376) 50,753 (9,389) 19,780 (4,137) 61,400 3,067 630,182 210,153 3,142 (3,858) 19,017 15,925 81,850 (10,684) 467 ~O~ 100% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 99% 1% nla 53% 54% 41% a) 58% a) 38% nla 41% 0% 39% nla nla 58% 49% 48% 61% 88% b) 26% 359% 52% 58% Variance $1,336,051 $1,327,199 $ (8,852) 1,000 1,000 5,000 5,000 200,000 212,500 12,500 2,914,349 2,934,303 19,954 39,609 39,609 134,740 134,740 627,588 514,944 (112,644) 352 (352) 550,000 550,000 48,000 55,200 7,200 92,200 92,200 103,810 158,354 54,544 3,000 3,000 193,200 193,200 103,100 85,000 (18,100) 41,000 35,000 (6,000) 100,000 100,000 720,050 720,050 12,000 5,400 (6,600) 5,300 22,277 16,977 158,629 164,000 5,371 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 Transfers In-PH Res Fund Transfers In-Gen. Fund Other TOTAL RESOURCES 1,370,460 35,079 37,975 6,306,239 1,370,460 30,068 32,550 6,080,242 (5,011 ) {5,425} (225,997) 58% 58% 58% 58% 58% 50% 50% 62% 2,349,357 60,136 65,100 9,856,371 2,349,357 60,136 65,100 9,828,369 (28,002) REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency 3,748,614 1.244,303 37.917 91.700 627.017 3,652,145 1,130.316 78,600 96,469 113.987 37,917 13,100 627.017 I Exp·%1 58% 57% 58% 53% c) 58% 0% d) 58% 50% 58% nla 6.426.195 2,133,090 65,000 157.200 1,074.886 6,282,220 2.136,883 157,200 143,975 (3,793) 65,000 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 quarter1y 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 Page 6d) OCHIN System expenditure made in FV 2012 BEHAVIORAL HEALTH Statement of Financial Operating Data Seven Months Ended January 31,2013 Year to Date Actual Variance 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 3,792 3,505 (287) 58% 54% 6,500 6,500 Divorce Filing Fees 93.333 71.834 (21,499) 58% 45% 160.000 125.056 (34,944) Domestic Partnership Fee 26 50 24 58% 111% 45 100 55 Federal Grants 147,204 67.702 (79.502) 58% 27% a) 252.349 252.349 Federal Grant (ARRA) 37.188 (37.188) 58% 0% 63.750 63.750 State Grants 4,509,516 4.286.722 (222.794) 58% 55% b) 7,730,599 7,883,477 152,878 State Miscellaneous 36,085 15,996 (20.089) 58% 26% 61.860 61,860 Adult Mental Health Initiative 116.667 229,038 112.371 58% 115% 200,000 230.000 30,000 Title 19 157,177 73.004 (84.173) 58% 27% 269,446 269,446 Liquor Revenue 82,542 67,740 (14,802) 58% 48% 141,500 141,500 School Districts 40,250 14,400 (25,850) 58% 21% c) 69,000 14,400 (54,600) Contract Payments 34 34 58% nla 1,000 1.000 Miscellaneous 5,552 5.552 58% nla 7,000 7,000 Patient Insurance Fees 51,060 62,195 11,135 58% 71% 87,532 130,000 42,468 Patient Fees 554 1,109 555 58% 117% 950 1,500 550 Interest on Investments 14,583 11,989 (2,594) 58% 48% 25.000 20,500 (4,500) Rentals 10,792 7.625 (3.167) 58% 41% 18.500 18.500 Forfeitures 140 140 58% nla 140 140 Administrative Fee 3.087.307 3.033,714 (53,593) 58% 57% 5.292,527 5.292,527 Interfund Contract-Gen Fund 74,083 38,920 {35. 1631 58% 31% a) 127,000 127,000 Total Revenues 8,462,159 7,991,269 (470,890) 58% 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-COO 282.622 282,622 (1 ) 58% 58% 484,494 484,494 Transfers In-Acute Care Svcs 154.370 154.371 58% 58% 264,631 264.631 Transfers In-ABHA 305,689 305.690 58% 58% 524,039 524,039 TOTAL RESOURCES 13,288,684 12,609,922 (678,761) 58% 62% 20,408,477 20,340,651 (67,826) REQUIREMENTS: Exp. %1 Expenditures Personnel Services 6,662,861 6.263,873 398,988 58% 55% d) 11,422,048 10,800,000 622,048 Materials and Services 3,846.637 2,832,891 1,013,746 58% 43% 6,594,235 5,850,000 744.235 Capital Outlay 29,225 19,645 9,580 58% 39% 50,100 30.000 20.100 Transfers Out 119,000 102.000 17,000 58% 50% 204,000 204,000 Contingency 1.247.222 1.247.222 58% nla 2.138.094 2.138.094 TOTAL REQUIREMENTS 11,904,945 9.218,410 2,686,535 58% 45% 20,408,477 16,884,000 3,524,477 NET (Resources -Requirements) 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 Year to Date Budget I Actual I Variance I FY % I Coil. % RESOURCES: 8eg. Net Working Capital $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 Revenues Admin-Operations 12,886 17,968 5,082 58% 81% 22,090 22,090 Admin-GIS 729 355 (374) 58% 28% a) 1,250 1,250 Admin-Code Enforcement 96,950 116.444 19,494 58% 70% 166,200 166,200 Building Safety 742,919 729,495 (13,424) 58% 57% 1,273,575 1,273,575 Electrical 149.333 170,376 21,043 58% 67% 256,000 256,000 Contract Services 65,100 74,298 9,198 58% 67% 111,600 111,600 Env Health-On Site Prog 182,566 161,628 (20,938) 58% 52% 312,971 312,971 Planning-Current 371,788 378,390 6,602 58% 59% 637,350 637,350 Planning-long Range 132,079 160,416 28,337 58% 71% 226,421 226,421 FY 2013 Year End Budget Projection Variance Total Revenues 1.754,350 1,809,371 55,021 58% 60% 3,007.457 3,007,457 Transfers In General Fund -Gen Ops 498,673 498,673 58% 58% 854,872 854,872 General Fund -UR Planning 288,960 288,960 58% 58% 495,360 495,360 A&T Reserve (D/S assistance) 52,253 85,409 33,156 58% 95% 89,577 89,577 Other 58 {58} 58% 0% 100 {100} TOTAL RESOURCES 2,604.294 2,874,895 270,601 58% 64% 4,457,366 4,639,748 182,382 REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Admin-Operations 789,360 772,307 17,053 58% 57% b) 1,353,189 1,311,323 41,866 Admin-GIS 68,704 66,264 2,440 58% 56% 117,778 117,778 Admin-Code Enforcement 133,540 122,378 11,162 58% 53% b) 228,925 216,747 12,178 Building Safety 362,301 360,289 2,012 58% 58% 621,087 621,087 Electrical 118,551 116,845 1,706 58% 57% 203,231 203,231 Contract Services 82,685 88,202 (5,517) 58% 62% 141,745 141,745 Env Health-On Site Pgm 93,121 89,741 3,380 58% 56% 159,636 159,636 Planning-Current 374,684 332,680 42,004 58% 52% c) 642,315 634,887 7,428 Planning-long Range 270,317 227,993 42,324 58% 49% c,d) 463,401 349,567 113,834 Transfers Out (DIS Fund) 104,507 170,818 (66,311) 58% 95% 179,155 179,155 Contingency 202,361 202,361 58% nla 346,904 346,904 TOTAL REQUIREMENTS 2,600,131 2,347,515 252,616 58% 53% 4,457,366 3,935,156 522,210 NET (Resources -Requirements) 4,163 527,379 523,216 704,592 704,592 Revenues Expenditures Net from Operations 1,809,371 2,347,515 {538,145} 3,007,457 4,457,366 {1,449,9091 3,007,457 3,935,156 {927,699 1 522,210 522,210 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 Seven Months Ended January 31,2013 Year to Date Budget I Actual I Variance IFY % I Coil. % FY 2013 Year End Budget 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,155 1,155 58% nfa 1,200 1,200 Federal Grant (ARRA) 4,083 7,335 3,252 58% 105% 7,000 10,000 3,000 Mineral Lease Royalties 23,333 28,750 5,417 58% 72% 40,000 40,000 Forest Receipts 231,482 1,265,121 1,033,639 58% 319% a) 396,826 1,265,121 868,295 State Miscellaneous 316,336 542.290 225,954 58% 100% b) 542,290 542,290 Motor Vehicle Revenue 6,294,192 6,305,131 10,939 58% 58% c) 10,790,043 10,450,000 (340,043) City of Bend 14,583 (14,583) 58% 0% d) 25,000 25,000 City of Redmond 204,167 10,807 (193,360) 58% 3% d) 350,000 350,000 City of Sisters 5,833 (5,833) 58% 0% d) 10,000 10,000 City of La Pine 5,833 10,000 4,167 58% 100% d) 10,000 10,000 Admin Recovery (SOC) 1,689 1,689 58% nfa 2,000 2,000 Miscellaneous 11,667 14,894 3,227 58% 74% 20,000 20,000 Road Vacations 583 (583) 58% 0% 1,000 1,000 Interest on Investments 8,750 16,962 8,212 58% 113% 15,000 16,962 1,962 Interfund Contract 402,500 (402,500) 58% 0% e) 690,000 590,000 (100,000) Equipment Repairs 128,333 125,455 (2,878) 58% 57% 220,000 220,000 Vehicle Repairs 52,500 (52,500) 58% 0% e) 90,000 80,000 (10,000) LID Construction 5,833 (5,833) 58% 0% f) 10,000 (10,000) Vegetation Management 14,583 (14,583) 58% 0% e) 25,000 50,000 25,000 Forester 14,583 (14,583) 58% 0% e) 25,000 25,000 Car Washes 2,333 1,594 (739) 58% 40% 4,000 4,000 Car Rental 583 284 (299) 58% 28% 1,000 1,000 Sale of Equip & Material 422,100 556,028 133,928 58% 77% 723,600 723,600 Total Revenues 8,164,190 8,887,496 723,306 58% 64% 13,995,759 14,437,173 441,414 Trans In· Solid Waste 161,159 138,136 (23,023) 58% 50% g) 276,272 276,272 Trans In • Transp SOC 145,833 (145,833) 58% 0% f) 250,000 (250,000) Trans In-Road Imp Res 7,000 (7,000) 58% 0% f) 12,000 (12,000) TOTAL RESOURCES 13.197,733 13.749,483 697.583 58% 69% 19,253,582 19.437,297 183,715 REQUIREMENTS: I Exp·%1 Expenditures Personnel Services 3.129.701 3,144,495 (14,794) 58% 59% h) 5,365,202 5,299,523 65,679 Materials and Services 5,505,886 3,745,468 1,760,418 58% 40% i) 9,438,662 8,131,549 1,307.113 Capital Outlay 1,188,425 9,233 1,179.192 58% 0% j) 2,037,300 74,000 1,963,300 Transfers Out 160,417 160,417 58% 0% 275,000 275,000 Contingency 1,246,827 -1,246,827 58% nfa 2,137,418 -2,137,418 TOTAL REQUIREMENTS 11,231,256 6,899,196 4,332,060 58% 36% 19,253,582 13,780,072 5,473,510 NET (Resources -Requirements) 1,966,477 6,850,287 5,029,643 5,657,225 5,657,225 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 SOC qualifying projects in FY 2013; no resources will be transferred in from SOC 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 Page 9 ADULT PAROLE & PROBATION Statement of Financial ~perating Data Seven Months Ended January 31,2013 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy S81145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC·Domestic Violence $ 570,000 127,890 2,509 8,750 8,065 1,603,323 13,125 2,625 75,833 110,833 5,250 29,167 29,167 43,652 Year to Date Variance 100% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% $ 630.226 $ 60.226 219,240 91,350 (2,509) (8,750) 18,872 10,807 2,061,416 458,093 7,608 (5,518) 2,977 352 94,559 18,726 102,042 (8,791) 3,268 (1,982) 29,167 (0) 25,000 (4,167) 28,785 ~14!867~ Coil. % 111% 100% 0% 0% 136% 75% 34% 66% 73% 54% 36% 58% 50% 38% a) b) c) d) d) d) d) FY 2013 Year End Budget Projection Variance $ 570.000 $ 630,226 $ 60.226 219,240 219,240 4,301 4,301 15,000 3,000 (12,000) 13,826 21,826 8,000 2,748,556 2,748,556 22,500 14,180 (8,320) 4,500 4,500 130,000 153,257 23,257 190,000 172,380 (17,620) 9,000 9,000 50,000 50,000 50,000 50,000 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: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 1,803,253 518.984 58 324,336 1,708,539 467,995 94,714 50,989 58 324,336 I Exp·%1 58% 55% 58% 53% 58% 0% 58% nJa 3,091,291 889,687 100 556,005 3,041,291 889,687 50,000 100 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 Actual Variance Variance RESOURCES: Beg. Net Working Capital $ 511,994 $ Revenues Federal Grants 116,341 Title IV -Family Sup/Pres 23,061 HealthyStart Medicaid 49,583 Youth Investment 114,857 State Prevention Funds 28,071 HealthyStart fR-S-G 128,305 OCCF Grant 244,881 Charges for Svcs-Misc 4,667 Program Fees Court Fines & Fees 46,366 Interest on Investments 583 Grants, Private 1,167 Interfund Grants 187,177 567,120 132,015 23,051 21,456 95,433 46,839 109,974 198,165 1,953 4,591 43,277 2,150 135,000 $ 55,126 15,674 (10) (28,127) (19,424) 18,768 (18,331) (46,716) (2,714) 4,591 (3,089) 1,567 (1,167) {52,177~ 100% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 111% 66% 58% 25% 48% 97% 50% 47% 24% nfa 54% 215% nfa 42% a) a) b) a) c) d) $ 511,994 $ 567,120 $ 55,126 199,441 39,533 85,000 196,898 48,122 219,951 419,796 8,000 79,485 1,000 2,000 320,874 251,856 39,533 60,000 196,897 58,022 219,951 391,940 4,000 4,591 75,034 5,000 350,374 52,415 (25,000) (1 ) 9,900 (27,856) (4,000) 4,591 (4,451 ) 4,000 (2,000) 29,500 Total Revenues 945,059 813,904 (131,155) 58% 50% 1,620,100 1,657,198 37,098 Trans from General Fund Total Transfers In 160,999 160,999 161,000 161,000 1 1 58% 58% 58% 58% 275,984 275,984 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: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 377,693 860,998 58 165,962 339,193 686,516 38,500 174,482 58 165,962 1 Exp. %1 58% 52% 58% 47% 58% 0% 58% nfa e) f) 647,474 1,475,997 100 284,507 589,457 1,537,247 58,017 (61,250) 100 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 & 0 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 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 Year to Date Budget I Actual I Variance $ 700,513 $ 807,470 $ 106,957 12,833 10,845 (1,988) 116,667 82,890 (33,777) 501,667 563,632 61,965 766,500 787,033 20,533 2,333,333 2.398,382 65,049 42,583 63,751 21,168 14.583 60,680 46,097 4,375 4,749 374 6,300 6,300 (O) 1.680 1,680 1,451 1,451 26,250 26,743 493 I FY % I Coil. % 100% 115% 58% 49% 58% 41% a} 58% 66% 58% 60% 58% 60% 58% 87% b} 58% 243% c} 58% 63% 58% 58% 58% n/a 58% n/a 58% 59% FY2013 Year End Budget Projection Variance $ 700,513 $ 807,470 $ 106,957 22,000 22,000 200,000 200,000 860.000 900.000 40,000 1,314,000 1,320.000 6,000 4,000,000 4,050,000 50,000 73.000 73,000 25,000 70,000 45,000 7,500 7,500 10,801 10,801 1,680 1,680 1,451 1,451 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 Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Transfers Out Road Capital Reserve Contingency 1.011,104 1,743,766 552,249 48,417 161,159 367,500 349.530 968,953 1,446,958 405,589 58,768 138.136 630,000 42,151 296,808 146,660 (10,351) 23.023 (262,500) 349.530 58% 58% 58% 58% 58% 58% 58% Exp. %1 56% 48% d) 43% e} 71% f} 50% g} 100% h} n/a 1.733,321 2.989,313 946,713 83,000 276,272 630,000 599,195 1,733,321 2,989,313 946,713 83,000 276,272 630,000 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 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Uab/Property Process Fee-EventslParades Miscellaneous Skid Car Training NSF Fee Interest on Investments Other Interest TOTAL. REVENUES TOTAL. RESOURCES AppropriationslExpenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement I Benefit 5202 Defense 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous 5207 Repair / Replacement Total General Liability PROPERTY DAMAGE 5204 Insurance 5207 Repair / Replacement Total Property Damage VEHICLE 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5207 Repair / Replacement Total Vehicle WORKERS' COMPENSATION 5201 Settlement I Benefit 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous Total Workers' Compensation 5201 UNEMPLOYMENT -SettlementlBenefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL. REQUIREMENTS NET Year to Date Budget I Acto I nce I % of FY I % Coli. $2,000,000 $2,240,791 $240,791 100% 112% 153,028 153.028 0 58% 58% 182,863 182,863 0 58% 58% 101,287 101,287 (0) 58% 58% 840,103 840,103 0 58% 58% 145,833 145,922 89 58% 58% 292 (292) 58% 0% 35,000 14,568 (20,432) 58% 24% 1,167 215 (952) 58% 11% 29 37 8 58% 74% 9.333 15,090 5,757 58% 94% 30 30 58% nla 8.750 6.880 (1,870) 58% 46% 29 {29) 58% 0% 1,477,714 1,460,023 117.6911 58% 58% 3,477,714 3,700,814 223,099 58% 82% Budget YearEnd Projection Variance $2,000,000 $2,240,791 $240,791 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 (2,9401 4,533,224 4,771,075 237,851 I %Ex~. I 365,893 37,481 10,174 138.350 a) 8,232 45 200 175,000 560,375 (385,375) 58% 187% 300,000 725,000 (425,000) 159,171 a) 41.463 145,833 200,634 (54,800) 58% 800/0 250,000 230,000 20,000 366 11,421 18,650 58,333 30,438 27,896 100,000 60,000 40,000 233,874 98,178 a) 24,779 22,086 583,333 378,917 204,417 58% 38% 1,000,000 600,000 400,000 145.833 93,403 52,430 58% 37% 250,000 230,000 20,000 1,108,333 1,263,767 (155,433) 58% 67% 1,900.000 1.845.000 55.000 179,606 171.220 8.386 58% 56% 307,896 307.896 98,578 71,405 27.172 58% 42% 168.990 168.990 58 58 58% 0% 100 100 278,242 242.625 35.617 58% 51% 476,986 476.886 100 4,200 3.600 600 58% 50% 7.200 7.200 1,390,775 1,509,992 (119 1217 1 58% 63% 2,384,186 2,329.086 55,100 ..2,086,939 2,190,822 103,883 2,149,038 2,441,989 292,951 a) Annual premium paid in July 2012 .. Contingency Is $2,149,038 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31.2013 Actual Variance Year to Date 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% Total Revenues 4,796,305 6,447,350 1,651,045 580/. 78% 8,222,237 8,028,190 (194,047) TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out-Reserve Fund Contingency 12,796,305 2.531,953 1.195.951 327,833 291,667 5,115,568 15,330,436 2.290,326 1.089,352 46,514 500,000 2,534,131 241,627 106,599 281,319 (208.333) 5,115.568 580/. 58% 58% 58% 58% 58% 95% % Exp·1 53% 53% 8% 100% n/a g) 16,222,237 4,340,490 2.050.202 562.000 500.000 8,769,545 16,911,276 4,000,000 2.050.202 562,000 500.000 689,039 340,490 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) NovlOec 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 FY 2013 Budget Projection Variance RESOURCES Beg. Net Working Capital $13,800,000 $14,551,028 $ 751.028 100% 105% $ 13.800,000 $14,551,028 751,028 Revenues: Internal Premium Charges 7,463,750 7,488,520 24,770 58% 59% 12,795,000 12,838,000 43,000 PIT Emp -Add'i Prem 29,167 19,217 (9,950) 58% 38% 50,000 40,000 (10,000) Employee Prem Contribution 367,500 372,165 4,665 58% 59% 630,000 630,000 COIC 758,333 819,047 60,714 58% 63% 1,300,000 1,400,000 100,000 Retiree I COBRA Co-Pay 437,500 546,857 109,357 58% 13% 750,000 930,000 180,000 Medical Services Reimb 441 441 58% nla 441 441 Prescription Rebates 29,697 29,697 58% nla 29,697 29,697 Claims Reimbursements 50,493 50,493 58% nla 50,493 50,493 Vending MachineS (Wellness Rebate) 105 105 58% nla 105 105 Interest 46,667 44,381 (2,285) 58% 55% 80,000 75,000 (5,000) Total Revenues 9,102,917 9,370,924 268.008 58% 60% 15.605.000 15,993,736 388,736 TOTAL RESOURCES 22,902,917 23,921,952 1,019,035 92% 104% 29,405,000 30,544,764 1,139,764 REQUIREMENTS Expenditures: Personnel Services (all depts) 117,117 113,992 3,125 58% 57% 200,772 200,772 MBterlals & S81Vices Claims Paid-Medical 5,850,950 6,810,612 (959,662) 58% 68% a) 10,030,200 11,805.061 (1,774,861) Claims Paid-Prescription 1,122,100 636,685 485,415 58% 33% a) 1,923,600 1,103,588 820,012 Claims Paid-DentaVVision 1,041,950 1,001,535 40,415 58% 56% a) 1,786,200 1,735,995 50,205 Claims Refunds (84,770) 84,770 58% nla (84,770) 84,770 Insurance Premiums 204,167 197,140 7,027 58% 56% 350,000 350,000 State Assessments 93,333 89,329 4,004 58% 56% 160,000 160,000 Administration Fee 186,667 194,546 (7,879) 56% 61% 320,000 320,000 Preferred Provider Fee 29,167 29,605 (439) 56% 59% 50,000 50,000 Health Impact 32,083 30,456 1,628 58% 55% 55,000 55,000 Refund ERRP 58,552 (58,552) 58% nla b) 58,552 (58,552) Other -Administration 38,123 31,799 6,323 58% 49% 65,353 65,353 Other -Wellness 61,250 15,984 45,266 58% 15% 105,000 105,000 Admin & Wallness 8.659,789 9,011,474 (351,684) 58% 61% 14,845,353 15.723,778 (878,425) Deschutes On-site Clinic Contracted Servicas 399,000 436,127 (37,127) 56% 64% c) 684,000 750,000 (68,000) Medical Supplies 17,500 6,298 11,202 58% 21% 30,000 20,000 10,000 Equipment 583 1,511 (928) 58% 151% 1,000 1,511 (511) Other 12,503 28,779 (16,2n) 58% 134% 21,433 21,433 Total DOC 429.586 472,714 (43,128) 58% 64% 736.433 792.944 (56,511) Deschutes On-site Pharmacy Contracted Services 179,834 236,782 (58,948) 58% 77% c) 308,287 400,000 (91,713) Medication and Drugs 583,333 765,955 (202,621) 58% 79% c) 1,000,000 1,350,000 (350,000) Start Up Costs-Take Care 59,898 59,898 58% nla c) 59,898 (59,898) Other 9,659 10,025 (365) 58% nla 16,559 16,559 Total Pharmacy 772.827 1.094,659 (321.832) 58% nla 1,324.846 1,826,457 (501,611) Capital Outlay 58 58 58% nla 100 100 Contingency 7,173,539 7,173,539 58% nla 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,229,114 7,479,114 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 edministrative and "Ingredient" costs. Also, start up costs for the pharmacy. These items had not been paid as of January 31. 2013. Page 15 I 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) Year to Date Budget (7/12 ofl annual) Actual VarianceI $ 46,373 $ 35,055 $ (11,318) 354,421 156,177 (198,244) 875 30 (845) 33,507 13,844 (19.663) 3,500 (3,500) 17,500 16,367 (1,133) 110,833 61.278 (49,555) 55,417 30,338 (25,079) 11,667 1,400 (10,267) 3,967 2,334 (1,633) IFY % IColi. % 100% 76% 58% 26% 58% 2% 58% 24% 58% 0% 58% 55% 58% 32% 58% 32% 58% 7% 58% n/a 591,686 281,767 (309,919) 58% 28% 99,167 99,169 58% 58% 15,017 15,015 58% 58% 48,300 48,300 58% 58% 154,151 150,000 (4,151 ) 58% 57% FY2013 Budget $ 46,373 607,578 1,500 57,441 6,000 30,000 190,000 95,000 20,000 6,800 1,014,319 170,000 25,744 82,800 264,259 YearEnd Projection $ 35,055 429,177 655 36,844 6,000 46,367 145,278 86,338 20,000 5,934 776,592 170,000 25,744 82,800 207,000 Variance $ (11,318) (178,401 ) (845) (20,597) 16,367 (44,722) (8,662) ~866) (237,727) (57,259) Total Transfers In 316,635 312,484 (4,151) 542,803 485,544 (57,259) TOTAL RESOURCES 954,694 629,306 (325,389) 58% 39% 1,603,495 1,297,191 (306,304) REQUIREMENTS: ! Exp.%! Expenditures: Personnel Services 485,265 470,217 15,048 58% 57% 831,882 816,873 15,009 Materials and Services 295,297 278,913 16,383 58% 55% 506,223 511,031 (4,808) Debt Service 66,569 70,609 (4,039) 58% 62% 114,119 114,119 Capital Outlay 8,318 9,000 (682) 58% 63% 14,259 9,000 5,259 Total Expenditures 855,448 828,739 26,710 1,466,483 1,451,023 15,460 Contingency 79,924 79,924 58% n/a 137,012 137,012 TOTAL REQUIREMENTS 935,372 828,739 106,633 58% 52% 1,603,495 1,451,023 152,472 NET (Resources -Requirements) 19,322 (199,433) (218,755) {153,832} (153,832} Page 16 ,. j CAPITAL PROJECTS • North County Campus • Sisters Health Clinic • Bethlehem Inn P"'~"""""'J'"~'';'.,"",-"V_,<","''' ""_'__'"""MhI4W~.,~,,;,;,"\\\IW~&"""'~~;,;);"l)l\..~'''~''''....uA,;~'''''''',~.~...,~~,_,~~~~~_:Ii " ....' ~;'ik.'~~!f.I:;u..ik;,;..<.~"~~...,;)..,p~""'"'___"'''''''\:_~~~':;':'''''~>\Il~.:;;;v~~:.,.___.",,"""__~""__•.v .. " Deschutes County North County Services Building Inception through January 31,2013 RESOURCES: Beginning Net Working Capital Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in fromFund 142 Interest Revenue Total Resources EXPENDITURES: Materials & Services Architecture/Design Engineering Internal Service Fund Charges Fees, Permits & SDCs Utilities Travel-Meals/Mileage Reimb Total Materials & Services Capital Outlay Land and Building Remodel Total Capital Outlay Contingency Total Expenditures Net ACTUAL Received or Encumbrances Project to Expended & Commitments Date I I Budaet" I I Proiected I I Variance 3,400,000 3,400,000 1,402,013 1,402,013 a) 1,402,013 1,402,013 25,000 25,000 b) 25,000 25,000 600,000 600,000 700,000 700,000 5,573 5,573 13,740 13,740 2,032,586 2,032,586 5,540,753 5,540,753 50,400 25,000 75,400 b) 325,000 325,000 75,000 75,000 8,364 8,364 13,150 13,150 991 991 75,000 75,000 13,230 13,230 20,000 20,000 23 23 23 ~23~ 73,007 25,000 98,007 508,150 508,173 ~23l 1,402,013 1,402,013 a) 1,402,013 1,402,013 230 230 3,300,000 3,300,000 1,402,243 1,402,243 4,702,013 4,702,013 313,513 313,513 1,475,250 25,000 1,500,250 5,523,676 5,210,186 (23) 557,336 (25,000) 532,336 17,077 330,567 313,490 == * The project budget is the consolidation of FY 2012 (actual and unexpended budget) and FY 2013 adopted budget a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve -$1,402,013 b) $25,000 was paid to the architect in FY 2011 with resources from General County Projects Fund (Fund 142) L ... North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through January 31, 2013 Vendor Description Commitment Amount Amount Paid Balance ! Due BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects BLRB/GGL Architects Design Programming Construction Documents Evergreen School Assessment-Estimate Evergreen HHS Lobby Remodel Design Phase Design Development Phase Schematic Design Phase Planning -Redmond Parking Total Fee Reimburseable Expenses Total Payments to Architects 25,000 25,000 13,750 63,750 25,000 25,000 13,750 1,950 840 720 3,745 3,570 300 49,875 25,000 525 50,400 25,000 C- ! RESOURCES: Beginning Net Working Capital Federal Grants Resources from Fund 142 Transfer in (Fund 142) Interest Revenue Total Resources EXPENDITURES: Materials &Services Architecture/Design Engineering Planning Surveying Interfund Charges Fees, Permits & SDCs Utilities Miscellaneous Project Costs Miscellaneous Admin Costs Total Materials &Services Capital Outlay New Construction Total Capital Outlay Contingency Total Expenditures Net Deschutes County Sisters Health Clinic (Fund 464) Inception through January 31,2013 ACTUAL Received and Expended Encumbrances & Commitments Project to Date 40,000 48,626 100,000 296 188,922 40,000 48,626 100,000 296 188,922 56,499 56,499 1,140 2,029 1,028 25,549 1,140 2,029 1,028 25,549 993 26 87,264 993 26 87,264 51,447 51,447 501,283 501,283 552,730 ~52,730 138,711 501,283 639,994 50,211 (501,283) (451,072) 500,000 a) 48,626 100,000 648,626 a) 78,626 15,000 5,000 1,785 30,000 2,000 1,000 133,411 b) 515,215 515,215 648,626 500,000 48,626 100,000 296 648,922 78,626 15,000 5,000 2,029 1,785 30,000 2,000 993 1,000 136,433 552,730 ... 552,730 ... 689,163 (40,241) Variance 296 296 (2,029) (993) {3,022} {37,515~ (37,515) (40,537) (40,241) a) $48,626 paid to the architect in FY 2012 with resources from General County Projects Fund (Fund 142) b) Additional costs due to delay in the project have not yet been determined. Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31,2013 Budget Actual Variance IFY%I Coli. %1 Budget I Projection IVariance RESOURCES: Beg. Net Working Capital $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) Revenues Grants -Private 58,679 (58,679) 58% 0% 100,592 (100,592) Lease Payments 14,238 16,272 2,034 58% 67% 24,408 24,408 Total Revenues 72,917 16,272 (56,645) 58% 13% 125,000 24,408 (100,592) Transfers In: Project Development (140) 962,500 (962,500) 58% 0% 1,650,000 -(1,650,000) Gen Capital Res (143) 618,333 {618,333~ 58% 0% 1,060,000 -~1 ,060,000~ TOTAL RESOURCES (1,056,250) (2,693,901 ) (1,637,651) 58% -2155% 125,000 (2,685,765) (100,765) REQUIREMENTS: Exp. %1 Expenditures Debt Service: Interest Expense 14,583 8,773 5,810 58% 35% a) 25,000 16,500 8,500 Interest Payment 58,333 58,333 58% 0% 100,000 100,000 TOTAL REQUIREMENTS 72,917 8,773 64,144 58% 7% 125,000 16,500 100,000 NET (Resources Requirements) {1,129.1671 {2,702,6741 {1,573.507} b) {2,702,265} F651 a) Interest on January 2013 negative cash balance: $1,322.39. b) Inception through January 31. 2013 Revenues -Lease Payments Expenditures: Net Land/Building (Amertitle) -July 2007 Hickman Williams City of Bend -May 2008 KN EX CO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended $ 65,088 2,241,313 17,578 250,000 5,289 3,732 2,517,913 249,849 2,767,762 $(2,702,674) Deschutes County General Support Services -BOCC Conference/Seminar, EducationfTraining and Travel Expenditures and BOCC -County College Expenditures FY 2013 BOCCConfe Tammy Baney Conf/Sem &EducfTraining Travel Meals .......... Accommodations Airfare Mileage reimbursement Ground Transport/Parking Total Baney -=-:--.................... Alan Unger Conf/Sem &EducfTraining Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport/Parking : I- Total Unger Tony DeBone Conf/Sem &E:c.111l::!Irc:tf6Tng- Travel Meals Accommodations Airfare .._......_._......_....... Mileage reim~lJr!iElIl1ElI'l! Ground Transport Total Other Total -BOCC DepartlTl~nt Conf/Sem &EducfTraining T ravel Meals Accommodations Airfare Mileage Reimbursement Ground Transport Total -BOCC Department I Jul I Aug I Sep I Oct I ! 30 ---: -20 --I -127 -- --- -384 : -790 .._ ..._....._......._....... -35 ! - -, 30 566 i -790, I 65 --305 ---- ---429 : ---- -112 - - -- -- 65 112 -, 734 ' 30 -15 470 ---- ---429 ---- -- -471 - --- 30 -15 1,369 : 125 -15 775 -20 -- -127 -857 -- - - -496 -1,260 -35 -! - 125 678 15 : 2,893 Nov I , i 10 • 66 ! 119 - 683 - 878 . - - --- - .........- 10 - - - - - 10 20 ' 66 119 - 683 - 888 I Dec -! -! , -- ,-i -! -i . - - - -- - - I, -: 76 : ,-, I- 562 i I19 : 657 I , - 76 I - -• 562 19 657 --_.._......_---_.._ FY 2013 Budget Percent of FY 2013 Budget Expended i BOCC County College Office/Copier Supplies --85 - - -................................ ! ----,_. Meeting Supplies - -761 811 869 - I Total BOCC County College --846 811 , 869 . -! ! . i Jan I¥TO Total 65 ............~ 105 82 ................................:.== 168 ............~ -246.. ..............................-- 557 2,414 -35 704, 2,968 65 435 -- -429 -- -112 ...........- 65 : 975 .._....... 35 560 -76 -429 -- -1,033 -19 35 2,117 165 1,100 82 ........................~ 244 -1,104 -- 557 3,558 -54 804 6,060 15,250 39.7% -85 -2,441 -2,526 ~ !...-~---. NOTE: Abovec:tll1~lJl'l!!i include only those expenditures processed for payment. I Additional conference and travel costs may have been incurred, but not processed for payment. I 1/28/2013 Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA March 25, 2013 (1) Monthly Investment Report (2) February 2013 Finandals ... Deschutes County Commercial Paper $ Corporate Notes 8,113,468 Time Certificates 7,235,405 U. S. Treasuries Federal Agencies 3,941,893 Bankers' Acceptances LGIP/BOTC 116,676,731 Total Investments $ 135.967.496 Total Portfolio: By Investment Types Time Corporate Certificates Federal Notes 5% Agencies 6% 3% LGIP/BOTC 86% 0.00% 5.97% 5.32% 0.00% 2.90% 0.00% 85.81% 100.00% Investment Income Investments By County Function Fiscal Year 2012-13 1 Feb-13 I I Y-T-O General $ 135,967,496 $ 60,036 $ 480,170 I -- Total Investments $ 135,967,496 480,170 ITotal Investment Income 60,036 Less Fee: 5% of Invest. Income {3,OO2~ {24,O09~ Investment Income -Net 1$ 57,034 $ 456,1621 Yield Percentages ---~.~ BOTe I LGIP ~ 0.53% 0.59% Investments ~ 0 .74% 0.75% Average ~ 0.56% 0 .61% Category Maximums: U.S. Treasuries 100% 'ILGIP 100% c t\,;omparators ~Federal Agencies 75% 3 Month Treas. ~ 0.11% Banker's Acceptances 25% 12 Month Treas. ~ 0 .16% Time Certificates 25% 3 Month e p ~ 0.16% Commercial Paper 20% Corporate Notes 10% Term Maximums: 0-18 Months 100%t- 19 -24 Months 30% Months to Maturity 18 Months 92% 24 Months 8°,4 aturity 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), Sheriff's (255. 701. 702), Public Health (259), Behavioral Health (275), Community Development (295). Road (325). Community Justice -Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND Statement of Financial Operating Data 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 Financerrax Veterans Property Management Grant Projects Total Revenues Year to Date Budget J Actual I Variance IFY%I Coli. % FY2013 YearEnd $ Budget Projection Variance $ 8,700,000 13,461,040 453,333 1,591,554 499,084 920,015 8,265 123,129 132,600 45,600 66,163 1,333 $ 9,059,394 19.617,452 922,486 2,045,386 677,376 1,060,762 13,313 99,527 208,592 37.324 62,829 1.333 17,302,116 24,746,382 $ 359,394 6.156,412 469,153 453,832 178,292 140,747 5,048 (23,602) 75,992 (8.276) (3.334) 0 7,444,266 100% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 104% 97% 136% 86% 90% 77% 107% 54% 105% 55% 63% 67% 95% a) b) b) b) c) $8,700,000 $9,059,394 $ 20.191.560 20.774,199 680,000 950,988 2,387,331 2,687,331 748,626 873,626 1,380,023 1,620.023 12,398 18,313 184,694 184,694 198,900 248.592 68.400 68,400 99,244 99,244 2,000 2.000 359,394 582,639 270.988 300,000 125,000 240,000 5,915 49,692 25,953,176 27,527,410 1,574,234 TOTAL RESOURCES 26,002,116 33,805,776 7,803,660 67% 98% 34,653,176 36,586,804 1,933,628 REQUIREMENTS: I EXP.%! Expenditures Assessor 2,378,501 2,240,003 138,498 67% 63% 3,567,752 3,467,752 100,000 County Clerk 978,425 856,965 121,460 67% 58% 1,467.638 1,361.638 106,000 BOPTA 48,257 37,238 11.019 67% 51% 72,385 72,385 District Attorney 3,516,445 3.307,224 209,221 67% 63% 5,274,667 5,074,667 200,000 Financeff ax 555,910 529,362 26.548 67% 63% 833,865 833,865 Veterans 173,995 163,044 10,951 67% 62% 260,992 260,992 Property Management 181,351 177.849 3,502 67% 65% 272,027 272,027 Grant Projects 81,566 78,799 2,767 67% 64% 122.349 122,349 Non-Departmental 1.143,114 682,161 460,953 67% 40% d) 1,714,671 1,414,671 300,000 Contingency 4,532,785 4,532,785 67% nla 6,799,178 6,799,178 13,590,349 8,072,645 5.517,704 67% 40% 20,385,524 12,880,346 7,505,178 Transfers Out 9,265,101 8,561,908 703,194 67% 62% 13,897,652 13,897,652 TOTAL REQUIREMENTS 22,855,450 16,634,553 6,220,897 67% 49% 34,283,176 26,777,998 7,505,178 NET (Resources Requirements) 3,146,667 17,171,223 14,024,557 e) 370,000 9,808,806 9,438,806 Beginning Net Working Capital per Requested Budget 9,000,000 I 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 Eight Months Ended February 28, 2013 Budget I Year to Date Actual I Variance IFY% I Coli. % FY 2013 YearEnd Budaet 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 #1 065-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 OVA 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% 1) 125,661 125,661 Interfund Grant -Gen Fund 13,333 10,000 {3,3331 67% 50% d) 20,000 20,000 Total Revenues 505,282 474,611 (30,671) 67% 59-A, 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: I Exp. %1 Expenditures Community Justice-Juvenile Personnel Services 3,383,345 3,300,714 82,631 67% 65% g) 5,075,017 4,964,036 110,981 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 8,400 67% 50% h) 50,400 50,400 Contingency 559,679 559,679 67% n/a 839,519 839,519 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 I 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. 1) 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 HE h) Transfers out recorded quarterly. Page 2 SHERIFF -Fund 255 Statement of Financial Operating Data Eight Months Ended February 28, 2013 Actual Variance Variance RESOURCES: Beg. Net Working Capital $ $ $ 100% nfa $ $ $ Year to Date Revenues Law Enf Dist Countywid e 15 .04 1.084 12.• 2 30 .531 (2 .810,553 ) 67% 54% * 22 ,561.626 18.874 ,105 (3.687 ,521 ) Law Enf Dlst Rura l 9,627,795 8,215,012 ~1,41 2,783l 67% 57% * 14 ,441 .692 12.259.71 7 ~2 , 181 ,975l 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: Exp . %1 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% nfa 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 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% nfa 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% nla 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 Comm issary 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 IncenUve-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% nfa 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: Fund 255 Departments : Sheriffs Services Civil AutofComm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE , Forensic) Non Dept -ISF Charges Contingency Total to Fu nd 255 1,408,838 532,659 444,331 7,253,355 202,001 129,689 620,918 1,775,385 205 ,784 429 ,003 28,475 2 ,010,647 15 ,04 1,084 1 ,403 ,028 486 ,144 488 ,150 6 ,675 ,972 200 ,163 122 ,290 547 ,057 1,668,722 167,848 442 ,685 28,475 12,230,53 1 5,810 46 ,516 (43,818) 577,383 1,838 7,399 73,861 106,663 37,936 (13,682) (0) 2 ,010,647 2 .8 10 ,553 1 Exp . %1 67% 66% 67% 61% 67% 73% 67% 61% 67% 66% 67% 63% 67% 59% 67% 63% 67% 54% 67% 69% 67% 67% 67% nfa 2 ,113,257 798 ,989 666,497 10,880,032 303,001 194,533 931,377 2,663,078 308,676 643,504 42,712 3,015,970 22,56 1,626 2,113 ,257 734 ,889 666,497 10 ,383 ,042 302 ,901 194,433 931,377 2,532 ,978 308,615 663,404 42 ,712 18,874 ,105 64 ,100 496 ,990 100 100 130,100 61 (19 ,900) 3,015 ,970 3.687,52 1 Transfer to Reserve Fund (703) Non Dept -Comm System Res Total Requirements 66 ,667 53,333 15,161,084 100,000 80,000 12,410.531 (33 ,333) (26,667) 2,750,552 67% 100% 67% 100% 67% 55% 100,000 80,000 22,741 ,626 100,000 80 ,000 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 a) Current year taxes due November, February and May b) Less than planned BOJ Criminal Alien Assistance (SCAAP) reimbursement c) Unplanned Homeland Security Grant for Engineering Communication System Study d) Unplanned changes at the State level in Circuit Court revenue d istribution e) Reimbursement from the State will exceed plan due to higher number of S8 395 inmates f) Changes made at State level in distribution of Circuit Court revenue g) Approved carryover of prior year Title III funds 5,541 ,699 1 Page 4 * Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services Fund 702 LED Rural Statement of Financial Operating Data Eight Months Ended February 28, 2013 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 COD 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 ClerlliElection 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 Secu ri ty & 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,801 ,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: 1 Exp . %1 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 276,440 243,556 32,884 67% 59% 414 ,660 414 ,660 130,849 106,727 24 ,122 67% 54% 196,274 196,235 39 28,361 28 ,361 (0) 67% 67% 42 ,541 42 ,541 1,334,491 1,334,491 67% n/a 2,001 ,736 9.827 795 8 2f5.012 1. 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,2131 a) Current year taxes due November, February and May b) JAG grant for 800 MHz radios c) Homeland Security grant Communication System Engineering 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 surplus 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 YearEnd Budget I Actual I Variance JFY % I CoiL % Bud~et Proiection Variance I 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% nia 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 F ac 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 670/0 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°k 9,873,247 9,961,895 88,648 REQUIREMENTS: I Exp·%1 Expenditures Personnel Services 4,303,137 4.186,561 116,576 67% 65% 6,454,705 6.282,220 172,485 Materials and Services 1,427,919 1,247,494 180,425 67% 58% 2,141,878 2.136.883 4.995 Capital Outlay 43,333 43,333 67% 0% c) 65.000 65,000 Transfers Out 104,800 78,600 26.200 67% 50% 157,200 157,200 Contingency 702,976 702,976 67% n/a 1.054,464 1.054,464 TOTAL REQUIREMENTS 6,582,165 5,512,655 1,069,510 67% 56% 9,873,247 8,576,303 1,296,944 NET (Resources -Requirements) 445,353 1,113,983 668,630 1,385,592 1,385,592 Beginning Net Working Capital per Requested Budget 1,385,592 1 a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan Page 6 c) OCHIN System expenditure made in FY 2012 BEHAVIORAl HEALTH Statement of Financial Operating Data Eight Months Ended February 28,2013 Year to Date Actual Variance 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% nfa 1,000 1,000 Miscellaneous 11,154 11,154 67% nfa 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% nfa 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,583l 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. %1 Expenditures t Personnel Services 7,707,135 7.170.723 536,412 67% 62% 11.560,702 10.800,000 760,702 i Materials and Services Capital Outlay Transfers Out Contingency 4,401,970 33,400 136,000 1,370,480 3,558,307 19,645 102,000 843,663 13,755 34.000 1.370,480 67% 67% 67% 67% 54% 39% 50% nfa 6.602,955 50,100 204,000 2.055.720 5,850,000 30,000 204,000 752,955 20,100 2,055,720 TOTAL REQUIREMENTS NET (Resources -Requirements) 13,648,985 1,106,993 10,850,675 3,176,045 2,798,310 2,069,052 67% 53% 20,473,477 16.884,000 3,461,651 3,589,477 3,461,651 Beginning Net Working Capital per Adopted Budget a) Received quarterly, in arrears b) Oregon Health Authority grant projected at amended contract amount c) Contract for services to school districts terminated by mutual agreement 3,461,651 I Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Eight Months Ended February 28, 2013 Year to Date Budget I Actual I Variance I FY % I CoIl. % FY 2013 Year End BudJiet Projection Variance RESOURCES: Beg. Net Working Capital $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 Revenues Admin-Operations 14,727 19,635 4,908 67% 89% 22,090 24,483 2,393 Admin-GIS 833 445 (388) 67% 36% a) 1,250 1,000 (250) Admin-Code Enforcement 110,800 127,598 16,798 67% 77% 166,200 178,000 11,800 Building Safety 849,050 834,450 (14,600) 67% 66% 1,273,575 1,190,747 (82,828) Electrical 170,667 185,667 15,000 67% 73% 256,000 268,496 12,496 Contract Services 74,400 80,206 5,806 67% 72% 111,600 184,800 73,200 Env Health-On Site Prog 208,647 184,981 (23,666) 67% 59% 312,971 283,140 (29,831 ) Planning-Current 424,900 421,998 (2,902) 67% 66% 637,350 613,255 (24,095) Planning-Long Range 150,947 175,081 24,134 67% 77% 226,421 266,897 40,476 Total Revenues 2,004,971 2,030,062 25,091 67% 68% 3,007,457 3,010,818 3,361 Transfers In General Fund -Gen Ops 569,913 569,912 (1 ) 67% 67% 854,872 854,872 General Fund -UR Planning 330,240 330,240 67% 67% 495,360 495,360 A&T Reserve (DIS aSSistance) 59,718 85,409 25,691 67% 95% 89,577 89,577 Other 67 (67~ 67% 0% 100 POOl TOTAL RESOURCES 2,974,909 3,208,105 233,196 67% 72% 4,457,366 4,643,109 185,743 REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Admin-Operations 902,126 877,469 24,657 67% 65% b) 1,353,189 1,311,323 41,866 Admin-GIS 78,519 75,459 3,060 67% 64% 117,778 117,778 Admin-Code Enforcement 152,617 139,182 13,435 67% 61% b) 228,925 216,747 12,178 Building Safety 414,058 405,910 8,148 67% 65% 621,087 621,087 Electrical 135,487 133,116 2,371 67% 65% 203,231 203,231 Contract Services 94,497 100,336 (5,839) 67% 71% 141,745 141,745 Env Health-On Site Pgm 106,424 101,606 4,818 67% 64% 159,636 159,636 Planning-Current 428,210 378,357 49,853 67% 59% c) 642,315 634,887 7,428 Planning-Long Range 308,934 252,427 56,507 67% 54% c,d) 463,401 349,567 113,834 Transfers Out (DIS Fund) 119,437 170,818 (51,381) 67% 95% 179,155 179,155 Contingency 231,269 231,269 67% nla 346,904 346,904 TOTAL REQUIREMENTS 2,971,578 2,634,679 336,899 67% 59% 4,457,366 3,935,156 522,210 NET (Resources -Requirements) 3,331 573,426 570,095 707,953 707,953 Beginning Net Working Capital per Requested Budget 696,290 I 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) p,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 6f30f13 c) Reflects savings due to Planning Director's reduced allocation through 6f30f13 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 Budget I Actual JVariance IFY%J Coli. % FY2013 Year End Budget 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,Q43) 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 (SOC) 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";1. 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 1 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 SOC 166,667 (166,667) 67% 0"10 f) 250,000 (250,000) Trans In-Road Imp Res 8,000 (8,000) 67% 0"/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: I Exp·%1 Expenditures I Personnel Services 3,576,801 3,606,094 (29,293) 67% 67% h) 5,365,202 5,310,875 54,327 Materials and Services 6,292,441 4,072,149 2,220,292 67% 43% i) 9,438,662 8,144,702 1,293,960 Capital Outlay 1,358,200 9,233 1,348,967 67% 0% j) 2,037,300 73,884 1,963,416 l Transfers Out 183,333 275,000 (91,667) 67% 100% 275,000 275,000 Contingency 1,424,945 1,424,945 67% n/a 2,137,418 -2,137,418 I 1 TOTAL REQUIREMENTS 12,835,720 7,962,476 4,873,244 67% 41% 19,253,582 13,804,461 5,449,121 NET (Resources -Requirements) 1,573,189 6,834,451 5,427,929 6,014,368 6,014,368 I Beginning Net Working Capital per Requested Budget 6,014,3681 a) Payment received annually in January r b) Payment received annually in October I c) Actual receipts are lower than projections Id) Billed upon completion of work e) Payments to be received in June 2013 from other Road Department funds f) No SOC qualifying projects in FY 2013; no resources will be transferred in from SOC fund t g) Payments made quarterly h) Retro COLA raises for 701 members, early retirement and resignations Page 9 i) Expenditures are seasonal and higher during summer months j) CIP project reserve carry over FY 2014 ADULT PAROLE & PROBATION Statement of Financial Operating Data Eight Months Ended February 28,2013 Year to Date Budget I Actual I Variance IFY% I Coli. % 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 SB 1145 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% nla 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 FY 2013 Year End Budget Projection Variance Total Revenues 2,354,502 2,627,687 273,185 67% 74% 3,531,755 3,525,322 (6,433) Transfers In-General Fund TOTAL RESOURCES 290,217 3,214,719 290,216 3,548,128 (1 ) 333,409 67% 67% 67% 78% 435,328 4,537,083 435,328 4,590,876 53,793 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 2,060,861 593,125 67 370,670 1,949,466 530,176 111,395 62,949 67 370,670 I Exp. %1 67% 63% 67% 60% 67% 0% 67% nla 3,091,291 889,687 100 556,005 3,041,291 889,687 50,000 100 556,005 TOTAL REQUIREMENTS 3,024,723 2,479,642 545,081 67% 55% 4,537,083 3,930,978 606,105 NET (Resources -Requirements) 189,996 1,068,487 878,491 659,898 659,898 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 697,OOOJ Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Eight Months Ended February 28,2013 Year to Date Actual Variance Variance 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-Misc Program Fees Court Fines & Fees Interest on Investments Grants, Private Interfund Grants Total Revenues $ 511,994 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 $ 567,120 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 $ 55,126 (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 100% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 111% 43% 72% 52% 79% 97% 75% 71% 25% nfa 62% 240% nfa 77% 68% a) a) b) a) c) d) $ 511,994 304,556 39.533 85,000 196,898 48.122 219,951 419,796 8,000 79,485 1,000 2,000 320,874 1,725,215 $ 567,120 251,856 39,533 60,000 196,897 58,022 219,951 391,940 4,000 4,765 75.034 5,000 350,374 1,657,372 $ 55,126 (52,700) (25,000) (1 ) 9.900 (27,856) (4,000) 4,765 (4,451) 4,000 (2,000) 29,500 (67,843) Trans from General Fund Total Transfers In 183,997 183,997 184,000 184,000 3 3 67% 67% 67% 67% 275,984 275,984 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: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 431,649 1,048.984 67 194.762 386,516 708,858 45,133 340,126 67 194,762 I Exp.%l 67% 60% 67% 45% 67% 0% 67% nfa e) f) 647,474 1,573,476 100 292,143 589,457 1,537,247 58,Q17 36,229 100 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 373,773 373,773 Beginning Net Working Capital per Requested Budget 375,7041 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 & 0 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 Year to Date Budget I Actual I Variance $ 700,513 $ 807,470 $ 106,957 14,667 133,333 573,333 876,000 2,666,667 48,667 16,667 5,000 7,200 30,000 11,906 85,501 637,341 868,659 2,731,838 66.208 61,566 5,323 7,201 1,680 1,451 28,593 (2,761 ) (47,832) 64,008 (7.341) 65,171 17,541 44,899 323 1,680 1,451 {1,407l I FY % I CoiL % 100% 115% 67% 54% 67% 43% a) 67% 74% 67% 66% 67% 68% 67% 91% b) 67% 246% c) 67% 71% 67% 67% 67% nfa 67% nfa 67% 64% FY 2013 Year End Budget Projection Variance $ 700,513 $ 807,470 $ 106,957 22,000 22,000 200,000 200,000 860,000 940,000 80,000 1.314,000 1,290,000 (24,000) 4,000,000 4,035,000 35,000 73,000 85,000 12,000 25,000 70,000 45,000 7,500 8,000 500 10,801 10,801 1,680 1,680 1,451 1,451 45,000 42.000 {3.000) Total Revenues 4,371,534 4,507,268 135,733 67% 69% 6,557,301 6.705.932 148.631 TOTAL RESOURCES 5,072.047 5.314,738 242.691 67% 73% 7,257,814 7,513,403 255,589 REQUIREMENTS Expenditures Personnel Services Materials and Services Debt Service Capital Outtay Transfers Out Road Capital Reserve Contingency 1,155,547 1,992,875 631,142 55,333 184,181 420,000 399,463 1,104,621 1,624,346 405,589 61,620 138,136 630,000 50,926 368,529 225,553 (6,287) 46,045 (210,000) 399,463 67% 67% 67% 67% 67% 67% 67% Exp. %1 64% 54% 43% 74% d) e) f) 50% g) 100% h) nla 1,733,321 2,989,313 946,713 83,000 276,272 630,000 599,195 1,707,324 3,047,103 946,713 80,336 276.272 630,000 25,997 (57,790) 2,664 599,195 TOTAL REQUIREMENTS 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 825,655 825,655 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,6551 Page 12 RISK MANAGEMENT Statement of Financial Operating Data Eight Months Ended February 28.2013 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training NSF Fee Interest on Investments Other Interest TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 SetHement / Benefit 5202 Defense 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous 5207 Repair / Replacement Total General Liability PROPERTY DAMAGE 5204 Insurance 5207 Repair / Replacement Total Property Damage VEHICLE 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5207 Repair / Replacement Total Vehicle WORKERS' COMPENSATION 5201 SeWement I Benefit 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous Total Workers' Compensation 5201 UNEMPLOYMENT -SeWementlBenefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials &Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET Beginning Net Working Capital per Requested Budget a) Annual premium paid in July 2012 * Contingency is $2,149,038 Year to Date Bugget I Actual I Variance I % of FY I % Coli. $2,000,000 $2,240,791 174.889 174.889 208.987 208.987 115,757 115,757 960,117 960.117 166,667 166,768 333 40.000 30,112 1,333 390 33 37 10,667 16,490 30 10,000 7.802 33 $240,791 100% 112% 0 67% 67% 0 67% 67% (0) 67% 67% 0 67% 67% 102 67% 67% (333) 67% 0% (9,888) 67% 50% (943) 67% 20% 3 67% 74% 5.823 67% 103% 30 67% nla (2,198) 67% 52% {33~ 67% 0% 1,6881816 11681,379 (7,437} 67% 66% 3,688,816 3,922,170 365,893 37,481 10,174 138,350 8,232 45 200 200,000 560,375 159,171 41,463 166,667 200,634 366 11,421 18,650 66,667 30,438 233,874 98,178 24,779 22.086 666,667 378,917 166,667 93,403 233,354 67% 87% I %Ex~. I a) (360,375) 67% 187% a) (33,967) 67% 800/0 36,229 67% 30% a) 287,750 67% 38% 73,263 67% 37% 1,266,667 1,263,767 2,900 67% 67% 205,264 196,782 8,482 67% 64% 112,660 134,498 (21,838) 67% 80% 67 67 67% 0% 317,991 331,280 (13,289) 67% 69% 4,800 3,600 1,200 67% 50% 1,589,457 1,598,646 19 ,1891 67% 67% 2,099,359 2,323,524 224,165 Budget Year End Projection Variance $2,000,000 $2,240,791 $240,791 262,333 313,480 173,635 1,440,176 250,000 500 60.000 2,000 50 16,000 15,000 50 2,533,224 4,533,224 262,333 313,480 173,635 1,440,176 250,000 500 60.000 2.000 50 16,490 60 12,000 50 21530,n4 4,771,565 490 60 (3,000) {2,45O} 238,341 300,000 700,000 (400,000) 250,000 230,000 20,000 100,000 60,000 40,000 1,000,000 550,000 450,000 250,000 230,000 20,000 1,900,000 1,770,000 130,000 307,896 168,990 100 476,986 307,896 168,990 476.886 100 100 7,200 7.200 f 2,384,186 2,254,086 130.100 2,149,038 2,517.479 368,441 J I rI 2,5171479 I Page 13 l ~ l' Ii DESCHUTES COUNTY 911 Statement of Financial Operating Data Eight Months Ended February 28,2013 Year to Date Actual Variance 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) Misce"aneous 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 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out-Reserve Fund Contingency 13,481,492 2,893,660 1,366,801 374.667 333,333 5.846,363 15,874,811 2,602,030 1,235,063 46,514 500,000 2,393,319 291,630 131,738 328,153 (166,667) 5,846,363 67% 67% 67% 67% 67% 67% 98% % Exp·1 60% 60% 8% 100% n/a i) 16,222,237 4,340,490 2,050,202 562,000 500,000 8,769,545 16,924,046 4,000,000 2,050.202 562,000 500,000 701,809 340,490 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,535 9,811,844 9,811,844 Beginning Net Working Capital per Requested Budget 9,800.000 I 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 $29K 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 Ei ht Months Ended Februa 28,2013 NET (Resources -Requirements) 5,483,231 13,097,905 8,497.905 12,142,435 12,142,435 Beginning NWC per Requested FY Budget 12.100,000 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 67% 84%C}, 89%j::)' 12,795,000 12,871,238 50,000 33.000 630,000 638,000 1,300,000 1,400,000 750,000 923,000 441 66,836 50,493 76,238 (17,000) 8,000 100,000 173,000 441 66,836 50,493 29,405,000 30,607,258 1,202,258 200,772 10,030,200 1,923,600 1,786,200 350,000 160,000 320,000 50,000 200,772 11,556,562 1,028,482 1,848,148 (93,210) 350,000 194,510 320,000 50,000 55.000 55.000 58.552 65.353 65,353 105 000 55 000 14,845,353 15,488,397 684.000 786,719 30.000 17,543 1,000 2.170 21.433 36 000 736,433 842,432 (1,526,362) 895,118 (61,948) 93,210 (34,510) (58,552) 50,000 (643,044) (102,719) 12,457 (1,170) Health Benefits Trust Statement of Financial Operating Data FY2013 Budget PrOjection Variance RESOURCES Beg. Net Working Capital $13,800,000 $14,551,028 $ 751,028 100% 105%~;;;r $ 13,800,000 $14,551,028 751,028 Revenues: Intemal Premium Charges 8,530,000 8,580,636 50,636 PIT Emp -Add'i Prem 33.333 21,857 (11,476) Employee Prem Contribution 420,000 425.550 5,550 COIC 866,667 935,964 69,298 Retiree I COBRA Co-Pay 500,000 615,538 115,538 Medical Services Reimb 441 441 Prescription Rebates 66,836 66,836 Claims Reimbursements 50.493 50,493 Vending Machines (Wellness Rebate) 222 222 Interest 53,333 49,612 (3.722) Total Revenues 10,403,333 10,747,149 343,816 TOTAL RESOURCES 24,203,333 25,298,177 1.094,844 REQUIREMENTS Expenditures: Personnel Services (all depts) 133,848 132,182 1,666 Materials & Services Claims Paid-Medical 6,686,800 7,719,709 (1,032.909) Claims Paid-Prescription 1,282,400 720,481 561,919 Claims Paid-DentalNision 1,190,800 1,191,720 (920) Claims Refunds (93,210) 93,210 Insurance Premiums 233,333 224,928 8,405 State Assessments 106,667 89,329 17,338 Administration Fee 213,333 222,403 (9,070) Preferred Provider Fee 33,333 33,842 (509) Health Impact 36,667 34,799 1.868 Refund ERRP 58,552 (58,552) Other -Administration 43.569 33,448 10,120 Other -Wellness 70,000 17,830 52,170 Admin &Wellness 9,896,902 10,253,831 (356,929) Deschutes On-site Clinic Contracted Services 456,000 544,211 (88,211) Medical Supplies 20,000 17,543 2,457 Equipment 667 2,170 (1.503) Other 14,289 30,239 (15,951) Total DOC 490.955 594,163 (103,207) Oeschutes On-site Phannacy Contracted Services 205,525 260,030 (54,505) 308,287 Medication and Drugs 666,667 888,595 (221,928) 1,000,000 Start Up Costs-Take Care 59,898 59,898 67% n/a!4f; Other 11,039 11,574 (535) 67% Total Phannacy 883,231 1,220,097 (336,866) 67% Total Spec Approp/Expendltures 11,404.936 12,200,272 (795,336) 67% Contingency 8,198,397 8,198,397 67% Total ApproplExpendltures 18,720,103 12,200,272 7,403,061 67% !Revenues less Expenditures (1,453,123) (2,408,59211 a) PrOjection based historical data. b) Disallowance of Ear1y Retiree Reinsurance Program items (Reported as revenue in FY 2012) c) YTD Actual include accruals (January actual paid in March) and estimates (February based on January actual) Page 15 I 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 Horse Stall Rental Concession % -Food Rights (Signage, etc.) Interfund Contract Miscellaneous Year to Date Budget (7/12 of I annual) I Actual I Variance IFY % ICoil. % $ 46,373 $ 35,055 $ (11,318) 405,052 178,477 (226,575) 1,000 (43) (1,043) 38,294 14,303 (23,991) 4,000 2,600 (1,400) 20,000 18,115 (1,886) 126,667 72,250 (54,416) 63,333 30,338 (32,996) 13,333 1,600 (11,733) 4,533 2,534 {2,000) 100% 76% 67% 29% 67% -3% 67% 25% 67% 43% 67% 60% 67% 38% 67% 32% 67% 8% 67% n/a YearEnd FY2013 Budget Projection Variance $ 46,373 $ 35,055 $ (11,318) 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) Total Receipts 676,213 320,174 (356,040) 67% 32% 1,014,319 766,674 (247,645) Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Reserve Rund (617) Annual County Fair (619) Total Transfers In TOTAL RESOURCES 113,333 17,163 55,200 176,173 361,869 1,084,454 113,336 17,160 55,200 150,000 335,696 690,925 (26,173~ (26,173) (393,530) 67% 67% 67% 67% 67"k 67% 67% 67% 57% 43% a) b) 170,000 25,744 82,800 264,259 542,803 1,603,495 320,000 25,744 82,800 50,000 245,000 723,544 1,525,272 150,000 50,000 ~19,259) 180,741 (78,223) REQUIREMENTS: Expenditures: Personnel Services Materials and Services Debt Service Capital Outlay Total Expenditures 554,588 337,482 76,079 9,506 977,655 537,153 349,357 70,609 9,000 966,119 17,435 (11,875) 5,471 506 11,537 I EXP·%I 67% 65% 67% 69% 67% 62% 67% 63% 831,882 506,223 114,119 14,259 1,466,483 814,491 539,305 114,119 9,000 1,476,915 17,391 (33,082) 5,259 (10,432) Contingency 91,341 91,341 67% n/a 137,012 137,012 TOTAL REQUIREMENTS 1,068,997 966,119 102,878 67% 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 ' ~'1<~'i""""",.""""-,-",_~~',"h",""""",','"_,~""",;,,,,:,",,,~,_ol!.,.,.c,,,,,,,,:~,'=,~..\c"""'d~ ...a;~,.,:..;;.:,....':~;."";";'-W:~-0;'~'""~~U:,..",if"'~_,,,,,,~,,,,,,,,,,,,,,,\.u';"""_~~""4>,,,,,,,,,,",,-_,"'''''''''-______4oIi,,"w.o;''''''~~_~%I''''''"'~'''''''''''''''-~'''''''-_·_..... .,...""'..-->,',.,.,""-'''','."'''''.",'''~''''.:~..,-.'=.~,---,,..-.~'-''"'.'."",~-~,~--~-.-"-,,,.~.-..~ .----~',.--'"~--" CAPITAL PROJECTS • North County Campus • Sisters Health Clinic • Bethlehem Inn Deschutes County North County Services Building Inception through February 28, 2013 ACTUAL PROJECTION RESOURCES: Beginning Net Working Capital Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in fromFund 142 Interest Revenue Total Resources EXPENDITURES: Materials & Services Architecture/Design Engineering Internal Service Fund Charges Fees, Permits & SDCs Utilities Travel -Meals/Mileage Reimb Total Materials &Services Capital Outlay Land and Building Remodel Total Capital Outlay Contingency Total Expenditures 1,402,013 25,000 600,000 5,798 2,032,811 51,097 9,321 991 13,900 23 75,332 1,402,013 230 1,402,243 1,477,575 Encumbrances & Commitments 25,000 25,000 25,000 Project to Date I 1,402,013 a) 25,000 b) 600,000 5,798 2,032,811 76,097 b) 9,321 991 13,900 23 100,332 1,402,013 a) 230 1,402,243 1,502,575 Budget * I I Projected I I Variance 3,400,000 3,400,000 1,402,013 1,402,013 25,000 25,000 700,000 700,000 13,740 13,740 5,540,753 5,540,753 325,000 325,000 75,000 75,000 13,150 13,150 75,000 75,000 20,000 20,000 23 {23~ 508,150 508,173 ~23l 1,402,013 1,402,013 3,300,000 3,300,000 4,702,013 4,702,013 313,513 313,513 5,523,676 5,210,18§ (23) Net 555,237 (25,000) 530,237 17,077 330,567 313,490 == = , * The project budget is the consolidation of FY 2012 (actual and unexpended budget) and FY 201~ adopted budget a) The building was purchased in FY 2011 with resources from Project Development and Debt Reserve -$1,402,013 b) $25,000 was paid to the architect in FY 2011 with resources from General County Projects Fund (Fund 142) ~'''''''V~",,_.,~_''''_'_I'~''~'''_'-''-'''''''...-.:r~:-~~'"~f'!l'l:''''''l_~'''~'''''''~~l'',""'~ ¥ '~,I, 'M '.,'~ /'1 •it. '" ',' ,1k,.H~~~i"')~,'" ! ij ~~~.? W • North County Services Building -Fund 462 ENCUMBRANCES AND COMMITMENTS Through February 28, 2013 Vendor Description Commitment Amount Amount Paid Balance Due , BLRB/GGL Architects Design Programming 25,000 25,000 BLRB/GGL Architects Construction Documents 25,000 25,000 BLRB/GGL Architects Evergreen School Assessment-Estimate 13,750 13,750 Evergreen 1,950 HHS Lobby Remodel 840 BLRB/GGL Architects Design Phase 720 BLRB/GGL Architects Design Development Phase 3,745 BLRB/GGL Architects Schematic Design Phase 3,570 BLRB/GGL Architects Planning -Redmond Parking 300 Total Fee 63,750 49,875 25,000 BLRB/GGL Architects Reimburseable Expenses 1,222 Total Payments to Architects 51,097 25,000 ..",-,~,"''''{1''''7''_'''~ __''''''''~'''''_''_'':('i'''''-'''1''··'''''''"'''"'''''':''''''''-'~....~~0>"'r~w_.~~""~~~~.,,,Ii'~"''''''~'''''~'''''''''''''''1l''''''!'~~~_~''''''"_!''J'':'I''''''''~~-'~~~mm"~*~.___' Deschutes County Sisters Health Clinic (Fund 464) Inception through February 28,2013 RESOURCES: Beginning Net Working Capital Federal Grants Resources from Fund 142 Transfer in (Fund 142) Interest Revenue Total Resources EXPENDITURES: Materials & Services ArchitecturelDesign Engineering Planning Surveying Interfund Charges Fees, Permits & SDCs Utilities Miscellaneous Project Costs Miscellaneous Admin Costs Total Materials & Services Capital Outlay New Construction Total Capital Outlay Contingency Total Expenditures Net 40,000 48,626 100,000 316 188,943 500,000 48,626 100,000 500,000 48,626 100,000 316 648,943 Variance , , 56,499 56,499 1,140 1,140 2,029 2,029 1,322 1,322 25,549 25,549 993 993 ;:n 26 87,558 87,5~~ \I 51,447 501,283 78,626 15,000 5,000 1,785 30,000 2,000 1,000 133,411 515,215 51,447 501,283 515,215 139,005 49,938 501,283 !~()1,283) (451 648,626 78,626 15,000 5,000 2,029 1,785 30,000 2,000 993 1,000 136,433 552,730 552,730 689,163 (40,220) 316 316 (2,029) (993) (3,022) (37,515) (37,515) (40,537) (40,220) a) $48,626 paid to the architect in FY 2012 with resources from General County Projects Fund (Fund 142) b) Additional costs due to delay in the project have not yet been determined. Deschutes County Bethlehem Inn (Fund 128) Revenues Grants ~ Private 67,061 (67,061) 67% 0% 100,592 (100,592) Lease Payments 16,272 18.306 2,034 67% 75% 24,408 24,408 Total Revenues 83,333 18,306 (65,027) 67% 15% 125,000 24,408 (100,592) Transfers In: Project Development (140) 1,100,000 (1,100,000) 67% 0% 1,650,000 -(1,650,000)~ Gen Capital Res (143) 706,667 {706,667~ 67% 0% 1,060,000 -(1,060,000) TOTAL RESOURCES (820,000) (2,691,867) (1,871,867) 67"k -2153% 125,000 (2,685,765) (100,765) Eight Months Ended February 28, 2013 ! f Actual Variance I l r Budget I Projection I Variance I RESOURCES: Beg. Net Working Capital $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710.173) $ (173) I NET (Resources· Requirements) (903,333) (2,701,733) (1,798,400) b) ======:!{5!2,==700==,7=65=)=====~(7=65=) a) Interest on February 2013 negative cash balance: $1,1093.33. REQUIREMENTS: Exp·%1 t Expenditures Debt Service: I Interest Expense 16,667 9,866 6,800 67% 39% a) 25,000 15,000 10,000 Interest Payment 66,667 66,667 67% 0% 100,000 100,000 I TOTAL REQUIREMENTS 83,333 9,866 73,467 67% 8% 125,000 15,000 100,000 I I b) Inception through February 31,2013 Revenues -Lease Payments Expenditures: Land/Building (Amertitle) -July 2007 Hickman Williams City of Bend -May 2008 KNEXCO Kleinfelder Total expended on facility Interest on Negative Cash Balance Total expended Net I I ! t$ 67,122 i t2,241,313 17,578 250,000 I I 5,289 3,732 2,517,913 !250,943 2,768,855 t f $(2,701,733) ___ ___ Deschutes County General Support Services -BOCC Conference/Seminar. EducationlTraining and Travel Expenditures and BOCC -County College Expenditures FY 2013 ---:::::--..... ....----:c---.-----j'----r-------r----i----.,.----;------r----r-----; BOCC Conference & Travel I Jul I Aug I Sep I Oct I Nov I Dec I Jan I Feb IYTD Total Tammy Baney -~--~~-~~-~~-~-~~-~---~---~----~---~ . Conf/Sem &Educ!Training~_:_---30-·--·····-----~.~~---.....-.. =--_·-.···..~_-·-=....._-=_65---=8=0-185...=.=··=---:1:-0·;::·--... - Travel Meals --------C.--~20=-----.------66 -82 -····168 Accommodations -127 -........_.....---119 - - -246 ~i1::~e r-ei-mburSelme-nT----: 384 ~----7--9-0-···~··=-=-=6·--=-=8-=-3-=----·---·-·-:-------·····=~=5=7=-··-··-·4---3--2·-=---·=-2-····.-~4--=-6---l Ground TransportlParking--·····----· 35 -------...... -.-..----.-----35 Total Baney 30 566 -790 878 : -704 512 3,480 Alan Unger COnf/Sem & EduCfrraining ------···-6-5--~----=-·--3-0-5-'-.-_=-=---=-_-=--_-.-_..-65 80_._.~ Travel Meals .. ~--.....-.. ---..-...----.... ----.-.--... ·Accommodations~·-· --------:------··-·--~--~-4~29··--·····-----···--··----429 Airfare Mili3age reimbursement 112 112 ~und II a" drkil .....'--__-==-~=--==::::'-~-==::::-=--=:::::::::-~--==-='--.::=::::-=--==-::::::::..-=::::-::=:=--=======:=-::::::-l....."" u r Total Unger .... 65 112 -734 - -65 80 1,055 Tony DeBoneI--:=-"--=:c:c--".--c.·,.-,---=:----.---------. -__,__-....------,--,------..-------___.c-c--J ~==============-~----~--------------------------------~ Conf/SE;m & EduclTraining ___3_0____-....__._.._1_5____47_0 _.__1_0___-=::--__3_5_ 580 1.140 Travel Meals - - - - -76 - -76 /"\\,;I...VII III I lations - - -429 - - -339 768 Airfare 'MIIeagereiffib-u-rse-m-e-nf----------------·-·····--47-1---------=56~2::C--..------=399=-----:1·.-:4=32::-1 Ground Transport .---------------:::---------------19 -._--------'-1-:-:9:--1 =::::~~~~==~~ Total Other 30 -15 1,369 10 657 35 1,318 3,434 Total -BOCC Department Conf/Sem &Educ!Training ...... 125 ......_-·--·-~-7~---2-0-.--······-165··· 740 1,840 Travel Meals---20--··· - -.---66 76 82 244 -Accommodations -.-----~.---...--127 ~~-·--85i·--11 9--- -339 1,443 -~-----=.. - - -.---......------....-.=-c:::=---=--:::-;:-----,--=-=-=-I Mileage R~imbursement ___.___._-___496 __-_...... 1,260 683 562 _55_7__8_31___...:4.:....38.,-9.,-1 Ground Transport -35 - - -19 - -54 Total-Boce Department· 125 678 15 2,893 888 657 _ 804 1,910 ~,~ FY 2013 RllnnAt 15,250 Percent of FY 2013 Budget Ehl-'tlllutld 52.3%1 BOCC County College ---.... -----...--~-------·--~----~---·--·-~-··-····cc_-f Office/Copier Supplies - -85 - - - - -85 _M_e_eti_'n_g .~llPJliie_s_._.~-.......=-::::-=---= -=-=-:==:::7~6~1==:::::-c,:::8~1:1-~-.::::·-::::··~···-8:,,:6~9=__~::::-==::::_=:::-·::::···~~:::::-=-:==:~2,=44=1::J....~~===--= --=To-to-a-=-'=BO=-C=-C==-=e-o-un--:t-y-C·;;;;:-"o=lIe-g-e·-·~--.-.---_-......--.---=-:c8<4:::--tJ-·-':8:-:1i-:------:8=69--··-----.--......----~=-=:"'--2-,5261 --------..... ---.... ~:Above amounts include only those expenditures processed for payment. -;-:-___.,-----------.----1 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: Deschutes County Board of Commissioners From: Nick Lelack, AICP, Interim Director Work Session: March 25, 2013 Re: 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, aI/ plan reviews, and provides office hours 4-5 days per week at city hall. Deschutes County earns 62% of aI/ 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 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 Community or Program Deschutes County 2013-14 Investment Local City and/or Private Sector Investment Estimated Total FY13-14 Program Budget Local Economic Development Capacity 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 & Early Stage 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 Regional Economic Development Capacity Administrative & manager coaching for new local programs $5,000 $10,000 $15,000 Targeted marketing & lead generation $10,000 $10,000 $20,000 Sub Totals: $15,000 $20,000 $35,000 TOTAL: $125,000 $417,000 $537,000 *FoundersPad is not an 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 level” 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. Total Projected FY 2012-13 $60,000 Total per Commissioner FY 2012-13 $20,000 Total Amount Allocated for Each Quarter $15,000 Available per Commissioner Each Qtr $5,000 Expended 1st Qtr $15,100 DeBone $5,200 Baney $4,700 Unger $5,200 Expended 2nd Qtr $22,500 DeBone $11,334 Baney $4,333 Unger $6,833 Amount Remaining for 3rd-4th Qtrs $22,400 DeBone $3,466 Baney $10,967 Unger $7,967 Amount Remaining for Each Qtr $11,200 DeBone $1,733 Baney $5,483.50 Unger $3,983.50 Discretionary Grant Funds: Status as of 3/21/2013 Organization Funded Qtr Rcvd Request DeBone Baney Unger Total Description Brian Wachs N 1 7/5/2012 3,500.00$ -$ -$ -$ -$ Student Restoration Project Training and Experience Cascades Theatrical Company N 1 7/1/2012 2,500.00$ -$ -$ -$ -$ Main Stage Season Community of Christ Church Y 1 4/18/2012 2,400.00$ 500.00$ 1,000.00$ -$ $1,500.00 Local Social Service Coordination Crooked River Ranch Senior Group Y 1 7/1/2012 4,000.00$ 500.00$ 500.00$ 500.00$ $1,500.00 Emergency Fuel for Dial-a-Ride Operations Deschutes County Behavioral Health N 1 7/1/2012 750.00$ -$ -$ -$ $0.00 Client Attendance at County Fair (estimated value of 50 tickets) Deschutes County Historical Society N 1 8/17/2012 3,900.00$ -$ -$ -$ $0.00 Pet Tales Exhibit Deschutes Water Alliance Y 1 7/1/2012 2,000.00$ -$ -$ 2,000.00$ $2,000.00 Voting Member Contribution Heart of Oregon Y 1 7/5/2012 5,000.00$ 1,000.00$ 1,000.00$ -$ $2,000.00 Deck Replacement Hospice of Redmond Y 1 6/14/2012 3,000.00$ 500.00$ 1,000.00$ 500.00$ $2,000.00 2012 Festival of Trees J Bar J Ranch N 1 5/19/2012 5,000.00$ -$ -$ -$ $0.00 High Desert Classic Field Footing La Pine Parks and Recreation District Y 1 6/19/2012 2,000.00$ 2,000.00$ -$ -$ $2,000.00 Rosland Campground Improvements Leadership Redmond Y 1 7/25/2012 1,200.00$ 200.00$ 200.00$ 200.00$ $600.00 Annual Event Nature of Words N 1 4/24/2012 3,500.00$ -$ -$ -$ $0.00 2012 Literary Festival NeighborImpact (1)Y 1 7/1/2012 2,000.00$ -$ -$ 2,000.00$ $2,000.00 Redmond Childcare Alliance Network Orchard Neighborhood N 1 3/29/2012 3,000.00$ -$ -$ -$ $0.00 Let's Pull together Noxious Weed Eradication Event Sunriver Music Festival N 1 7/16/2012 2,500.00$ -$ -$ -$ $0.00 Cultural Tourism Marketing Program Together for Children (1)N 1 4/16/2012 1,200.00$ -$ -$ -$ $0.00 Operational Support Together for Children (2)Y 1 7/1/2012 1,220.00$ 500.00$ 1,000.00$ -$ $1,500.00 Fund Raising Strategy Development Every Idea LLC N 2 9/11/2012 3,000.00$ -$ -$ -$ $0.00 2012 Western Christmas Event Family Access Network Y 2 8/31/2012 2,500.00$ 500.00$ 500.00$ 500.00$ $1,500.00 Luncheon for Children Fundraiser Community Presbyterian Church N 2 9/10/2012 2,500.00$ -$ -$ -$ -Europe 2013 Educational Tour Cloverdale Fire District Y 2 12/3/2012 5,000.00$ 1,000.00$ 1,000.00$ 1,000.00$ $3,000.00 Volunteer Program Cat Rescue, Adoption, Foster Team Y 2 10/2/2012 1,000.00$ 334.00$ 333.00$ 333.00$ $1,000.00 Cans for Cats Trailer Center for Economic Research & Forecast Y 2 10/30/2012 2,500.00$ 500.00$ 500.00$ 500.00$ $1,500.00 4th Annual Central Oregon Economic Forecast Event Deschutes County Healthy Beginnings Y 2 9/17/2012 2,500.00$ 500.00$ 500.00$ 500.00$ $1,500.00 Improved Access / Early Intervention High Desert Museum N 2 9/24/2012 5,000.00$ -$ -$ -$ $0.00 Butterflies and Hummingbirds NeighborImpact (2)Y 2 10/29/2012 5,000.00$ 2,500.00$ -$ 2,500.00$ $5,000.00 La Pine Low/Mod Income Family Assistance New Generations School Y 2 11/26/2012 5,000.00$ 1,000.00$ 1,000.00$ 1,000.00$ $3,000.00 New Generations School Sustainability Oregon State University Extension Y 2 11/20/2012 2,000.00$ `500.00$ 500.00$ $1,000.00 Living on a Few Acres Conference City of La Pine Y 2 12/12/2012 10,000.00$ 5,000.00$ -$ -$ 5,000.00$ Transition LIGI to LEDG Bethlehem Inn 3 2/13/2013 5,000.00$ Spotlight on Homelessness CASA of Central Oregon 3 3/7/2013 2,500.00$ I Am for the Child Project Cascades Theatrical Company 3 1/31/2013 2,500.00$ Main State Season Deschutes River Woods Neighborhood Association 3 2/27/2013 900.00$ Get the Word Out Mailing Campaign Humane Society of Central Oregon 3 1/23/2013 1,245.00$ Automatic External Defibrillator (AED) for Thrift Store La Pine Rodeo Association 3 1/10/2013 1,500.00$ La Pine Rodeo Network of Volunteer Administrators 3 1/10/2013 1,500.00$ 2013 Volunteer of the Year Event Serendipity West Foundation 3 2/19/2013 1,500.00$ Challenge Days in Bend-La Pine Schools Sisters Kiwanis Community Service Foundation 3 2/25/2013 3,000.00$ Food Bank Building Construction Sisters Trails Alliance 3 2/18/2013 5,000.00$ Sisters Country Trails Map St. Vincent de Paul Redmond 3 1/11/2013 484.00$ Parking Striping Tri-County High School Rodeo Club 3 1/1/2013 2,500.00$ Tri-County High School Rodeo Upper Deschutes River Coalition 3 3/11/2013 2,000.00$ Fuel Reduction Maintenance Mailing Cumulative Total 16,534.00$ 9,033.00$ 12,033.00$ 37,600.00$ FY 2012-2013 Discretionary Grant Applications -------------- Video Lottery Fund -FY 2012-13 3rd Quarter Discretionary Grant Awards ~~~~----- Organization Cascades Theatrical Company Big Brothers Big Sisters of Central Oregon --------._----------------- Bethlehem Inn CASA of Central Oregon Humane Society of Central Oregon St Vincent de Paul Redmond Tri-Co~nty High School Rodeo Club Sisters Trail Alliance Sisters Kiwanis Community Service Foundation ---~-- Serendipity West Foundation La Pine Rodeo Network of Volunteer Administrators (NOVA) Deschutes River Woods Neigyhborhood Association Upper Deschutes River Coalition Total --" Allen Un~er Tamm\,~aneYJ_-,:ony DeB~~E! I $250~, $500.001 $0.00 I $O.()~- $200.00 $500·Qgl - -11$750.00, $0.00 ,-I $750.001 $0.00 $1/000.001---$4()~'00Ii .. $0.00 i ,-'" $Cl.§oj $184.00: $~ClO.OO i I---_-H-E:~j-~~E-~I $500.00 i $500.00 I $500.00r-$500.001- $3,950.00 $6,434.00 $0.00 _$o.og! $100.00i $().Cl~ $i~~~I $500.00 , $500.0Qjoeferred to 4th Qtr --, 1Defer!ed to 4th Qt~__ $1,750.001 FUND 165 VIDEO LOTTERY FY 2013-14 EOY Projections Year End Budgeted Projected Difference Revenue State Video Lottery Payments $600,000 $581,786 ($18,214) Q 1-3 payments $8,186 over / Q 4 payment $26,400 less Interest $750 $1,000 $250 Total Revenue $600,750 $582,786 ($17,964) ---_. Expend itu res Personnel $10,589 $2,319 $8,270 Not currently charging Dave Inbody's wages/benefits Community Grants $350,000 $358,800 ($8,800) Extrapolated from first of two anticipated payments Discretionary Grants $60,000 $60,000 $0 Service Partners $116,239 $115,000 $1,239 Shop with a Cop $5,000 $5,000 $0 EDCO $112,200 $112,200 $0 calc $13,758 $12,134 $1,624 Internal Service Charges $11,058 $11,058 $0- Capital Outlay $100 $0 $100 Total Expenditures $678,944 $676,511 $2,433 - Beginning Balance $100,000 $116,562 $16,562 - Total Projected f)iff~~~nce_'----$1,031 I Deschutes County Video Lottery (Fund 165) Through March 19. 2013 Y.arto Date IYearEnd I Budget I Actual IVariance IFY % ICoIl. % I Budget . P!3ectlon. Variance . Revenues State -Video Lottery (8) $450.000 $458.186 $ 8.186 75% 76% $600.000 $681.786 $(18.214) Interest 563 781 219 75% 104% 750 11000 250 Total Revenues 450,563 _967 8,405 75% 78% 600,750 582,786 (17,964) Expenditures Personnel 7,942 1,791 6.151 75% 17% 10.589 2.319 8,270 Matarials and Services: Grants ( 59-20, Community Grants 262,500 315,050 (52,550) 75% 90% 350,000 358,800 (8,800) Discretionary Grants Tammy Baney 15.000 7,333 7.667 75% 37% 20.000 20,000 Tony DeBone 15.000 10.333 4.667 75% 52% 20,000 20.000 Alan Unger 15,000 15,334 (334) 75% 77% 20,000 20,000 COCOA 24.375 10,000 14,376 75% 31% 32,500 32.500 CASA 22,500 10,000 12,500 75% 33% 30,000 30,000 Deschutes County 2-1-1 15,000 16.250 (1,250) 75% 810/0 20,000 20,000 Upper Deschutes Watershed 15,000 15,000 -75% 75% 20.000 20,000 To Be Determined (b) 1°1 304 12.500 (21196) 75% 91% 13,739 121500 1,239 Total Grants 394,679 411,800 (17.121) 75% 78% 526.239 533,800 (7,581) Law Enforcement District #1 5.000 5,000 . 75% 100% 5.000 5,000 Economic Development of CO 84.150 84.150 -75% 75% 112,200 112.200 Memberships &Dues 13,758 12.134 1.624 75% 88% 13.758 12.134 1.624 ISF Charges 8,294 8,294 . 75% 75% 11,058 11.058 Capital Outlay 75 75 75% . 0% 100 100 Total Expenditures (c) 513.898 523,169 (9,271) 75%· 77% 678.944 676.511 2,433 Contingency 471867 47,867 75% 0% 631823 63.823 Revenues less ExpendHures (111,202) (64,201) 47,001 (142,017) (93,725) 48,292 Transfers In -General Fund 89,350 89,350 -75% 100% 89,350 89.350 Transfers Out -Econ Davel Fund (35,500) (35,500) -75% 75% (47,333) (47,333) Change in Fund Balance (57.352) (10,351) 47,001 75% 10% (100,000) (51.708) 48,292 Beginning Balance 1001°00 116,582 16.582 100% 117% 100,000 116,582 16,582 Ending Balance $ 42,648 $106,211 $ 63.563 75% N/A $ $ 64,854 $ 64,854 Beginning Net Working Capital per Requested Budget 100,000 I 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. To: From: Date: Work Session: Re: 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 Deschutes County BOCC Will Groves, Senior Planner March 19, 2013 March 25, 2013 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 (T A-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 Perfonned 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 mayor 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.