The URL can be used to link to this page

Home My WebLink About2011-09-26 Work Session Minutes Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 1 of 7 Pages Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, SEPTEMBER 26, 2011 ___________________________ Present were Commissioners Tammy Baney, Alan Unger and Anthony DeBone. Also present were Erik Kropp, Interim County Administrator; Marty Wynne, Finance; Tom Anderson, Nick Lelack and Todd Cleveland, Community Development; media representative Hillary Borrud of The Bulletin; and six other citizens. Chair Baney opened the meeting at 1:30 p.m. _______________________________ 1. Tax/Finance Update. Marty Wynne said that the average rate has not dropped too much recently, but is still much lower than a couple of years ago. The plan was for a 0.4 average and it is still above 0.6. Mortgage rates are very low but many people do not have enough equity in their properties to refinance. Mr. Wynne explained how the County makes cash flow projections. These decisions are made conservatively, over eighteen or twenty-four months, reinvested based on cash flow. The Investment Advisory Committee wants to remain at a consistent and conservative approach: safety, liquidity, and yield, in that order. It is too early to determine this early in the fiscal year to see how the departments are doing. At this point most seem to be as budgeted. He provided the final numbers relating to the annual Fair. Revenue was about $50,000 better than budgeted. Expenses were a bit higher, but the final numbers were positive. Mr. Wynne mentioned that the cost of additional groundwater testing in south County be handled through Fund 296, or use non-departmental dollars instead. Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 2 of 7 Pages 2. COIC Application for a Sustainable Communities Regional Planning Grant. Andrew Spreadborough gave an overview of a grant request application, which is through HUD as a regional sustainable planning proposal. It is a competitive grant process and who gets the grant will not be known for a couple of months. This would be handled over three years, and the project would integrate a framework for housing and economic challenges. It must be built around a consortium. In this case, those partners would be COIC, Bend MPO, HousingWorks, Partnership to End Poverty, COACT, the Central Oregon Environmental Center, the City of Bend, and all three regional counties. Transportation, employment and affordable housing are the focus, and these are of regional concern. With the growing problems comes diminishing revenue, so these must be addressed at a regional level. The plan would look at a twenty-year timeframe. The County would need to provide a letter of support and be willing to enter the consortium for grant application purposes. Staff participation and in-kind contributions would be requested. Each member would contribute $10,000 a year and staff time would be valued at about $20,000. The submission date is early October. Chair Baney asked why just one city is included, as it appears the others might be interested in a regional solution to these issues. Mr. Spreadborough said that the MPO is required, as is a nonprofit. There were timeline concerns in including all the cities. There will be many other partners included in this process. The Regional Solutions group will provide a letter of support, but did not feel they need to be a member. Chair Baney asked if they are trying to do this with current staff. Mr. Spreadborough said they may need to hire a consultant to handle some of the technical issues. Commissioner Unger stated that COIC is the right group to oversee this process. This information will help the County in many ways. Deschutes County has the most capacity and probably the most to gain from this effort. Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 3 of 7 Pages Chair Baney asked if staff can handle this additional workload. Tom Anderson replied that per his understanding, it does not sound like an enormous commitment. The goals sound reasonable, but one can never be sure how involved it might get. If it gets to the point where it is a problem, he will advise the Board. Mr. Kropp said that a minutes motion could be made that Deschutes County is to be a consortium member, and the Board is to sign a support letter. Nick Lelack said that Community Development has a lot going on in a variety of issues. He suggested there be an update on the CDD work plan in a few months to evaluate the various projects. UNGER: Move approval of the grant request, County involvement and a letter of support. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Yes. BANEY: Chair votes yes. 3. Discussion of Well Sampling Funding Agreement. Tom Anderson said that the USGS work done in the area over the past ten years or more have built predictable models, built on scientific data, location and known flow of water in the area. The USGS recommended that in order to validate the information, additional sampling should be done in the future in various increments. This information would be fed into the system and then interpreted. There are two funds that could be used, but those are not being replenished through development in the area. Commissioner Unger asked if they have missed the window to gather data for this year. Mr. Anderson said some sampling has been done in October in the past. Eric Nigg, DEQ Water Quality, said that the staff hydrogeologist feels that it appropriate now before they get too much precipitation. They want to be able to compare this data with the same data from previous years. Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 4 of 7 Pages Commissioner Unger stated that part of the plan was to do future sampling, but it appears no one set aside money for this. Mr. Nigg said that they do not budget their money that far out and have used EPA funding in the past. It has been made clear to upper management that these funds are needed, but the response has been that staffing would have to be reduced to be able to get anything for this project. Commissioner Unger asked if $26,000 is sufficient to pay for what is needed. Mr. Anderson replied that the DEQ has indicated that would provide enough sampling to legitimize previous testing. Chair Baney asked if future sampling is going to be left up to the local entities. Mr. Nigg stated that the DEQ usually wants to do the updated sampling , but is not able to do so at this time due to financial constraints. They want to learn if there is a significant change in the test results from previous years. Chair Baney stated that information was requested regarding the Sunriver Sewer District expansion plan. Commissioner DeBone said that they understand that the funding is out of those funds and not the general fund. Commissioner DeBone asked for details on how the sampling is done. Mr. Nigg stated they will follow standard operating procedures. There is no expectation to put this data back into the model, but its analysis will come eventually. Mr. Anderson asked if the Board wants him to use Fund 296 at this time. Unless the New Neighborhood begins redeveloping, this fund will run out. He will keep the Board informed. He is basing part of this on the recommendation of the Finance Director. UNGER: Move approval of the grant request, County involvement and a letter of support. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Yes. BANEY: Chair votes yes. Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 5 of 7 Pages 4. Discussion of Intergovernmental Agreement with the City of Bend regarding Juniper Utility Co. Settlement. Erik Kropp said that item #3 is likely the most important part of the agreement. The funding would go towards the emergency shelter grant programs through NeighborImpact. DEBONE: Move approval of the agreement. UNGER: Second. VOTE: UNGER: Yes. DEBONE: Yes. BANEY: Chair votes yes. 5. Update of Commissioners’ Meetings and Schedules. Discussion took place regarding transportation issues. COIC is working on a competitive grant process for transportation. At the Transportation Commission meeting last week, support was given for the Redmond project. Chair Baney said a vote was taken to allow publication of the draft TPR, which will go to COACT and the MPO. Mobility standards will be changing as well. They need feedback on what changes would be beneficial, to adjust them in policy outside of politics. There is a lot of support for assisting local governments. Commissioner Unger added that COCOA has been very vocal about this issue. _______________________________ Commissioner Unger said that he would be attending the Workforce Investment Board meeting. He feels the Governor needs to own it and support the workforce policy group. _______________________________ Commissioner Unger is attending a water policy meeting in Boardman later in the week. The purpose is to help counties understand how to work with the integrated water plan and the State. This should be an economic and environmental issue for all counties. _______________________________ Minutes of Board of Commissioners’ Work Session Monday, September 26, 2011 Page 6 of 7 Pages Commissioner DeBone said he attended a meeting of the Upper Deschutes Watershed Coalition. It was very busy and there seems to be growing interest. _______________________________ Chair Baney is attending OTC meetings, and said the timing is right for some huge change. ODOT is too scripted and transportation policy may have to change. The system includes more than just the highways, but also rail and other types of transportation. She is hoping positive change will occur, and soon. _______________________________ Also discussed was how to establish and maintain a relationship between the Judges and the Commissioners. The County ha s done a better job of doing this than has been done in other areas. Specialty courts are a concern as well. _______________________________ Chair Baney is attending a Coordinated Care Organization Committee meeting in Salem, to set up requirements of the CCO and determine what health care reform will look like. HB 3650 set out the organization and how it will operate statewide. The County is establishing much of this. She hopes to retain some flexibility in what is in place. _______________________________ Chair Baney explained that ABHA receives all state and federal dollars, and those dollars would flow through Pacific Source instead and go into utilization. ABHA is a five-county group that oversees accountability and liability for the mental health dollars. Two counties are out of the area; the rest are local. There will be a conversation about the future of ABHA in the near future. Scott Johnson will attend meetings and provide feedback. Chair Baney will speak with Seth Bernstein, the ABHA director, in advance. Commissioner Unger is concerned about the various members, and wondered if there is an exit and a way to continue the services. Chair Baney said that the out of area counties would probably go to a different region’s group. It is not efficient to deal with five counties that are split by a mountai n range. She will know more from the meetings this Thursday and Friday. 6. Other Items. None were discussed. Being no further discussion, the meeting adjourned at 3:05 p.m. ~ DATED this tZ /' Dayof O&h-tvv 2011 for the De ~chutes Couuty Board of commiSSiouers.~ Tammy Baney, Chair Anthony DeBone, Vice Chair G1~~ATTEST: Alan Unger, Commissioner ~~ Rec@rding Secretary Minutes of Board of Commissioners' Work Session Monday, September 26,2011 Page 7 of 7 Pages Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, SEPTEMBER 26, 2011 1. Tax/Finance Update -Marty Wynne 2. COlC Application for a Sustainable Communities Regional Planning Grant COIC Representatives 3. Discussion of Well Sampling Funding Agreement -Tom Anderson 4. Discussion oflntergovemmental Agreement with the City of Bend regarding Juniper Utility Co. Settlement 5. Update of Commissioners' Meetings and Schedules 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 I 92.660(2X d), labor negotiations; or ORS 192.660(2) (b). personnel issues. Meeting dates. times and discussion items are subject to change. All meetings are conducted in the Board o/Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. !fyou 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 nY. Please call (541) 388-6571 regarding alternative formats or for further information. Work Session Mon .. Sept. 26. 2011 (Please Print) Name As;!ency Mailing Address City Zip Phone # e-mail address ~ w JUJ'/A-tj PD {j6 X 9t ~ ia p)u 9 773; -~L. ~I i<..u u < Ie, \ .~~· w-7);j6 ' I :.,.; I"L-& ~ ~ ~ ~1/l/J4fo /0 ~tTU .-2::2. 3 ;l.. ~ I I / ( 1547'5:3" -7 bb9 / lI.dyh(/C;7b(P9~·z .(Ih, ~~~ (J)/J 1II)6rd-S"9'1 .:Jj)Jip fA1-~ ';/ ~"\ 1:7¥/-5 S~-7p7Z~ - (:) ,u ~ A J f. lJI-L ,/ '-' J) J t l~ g{.,vf) Q 7 707 C If /IJ Il IJIJ ol Lgq i ~£,. 47b-/II~~ ~~ ~~~l Er-I'~ M~~ g ", ",~. ~ . ~c • (JOi OZ?EQ z:?i . .. .--J 0/_ 977/)1 .>7h ~~~:;,I,' rJ "LoC" h-. av-~ Gi6 /'/Jtlk~~vv~ ~81M \1tt~\AfvL 1><A~C1> AAJ~St-~~~ Q(')lG ~~'1 .... ~ tt ~Y\-u t'''-'~d ~1ct.. .,'-{ l '5"0'1 3 3l:1 G. 0,":> f>1' CL..<!\:or<::. .l r--® <....:J c,l.. v --- --- - Page # of Pages \ 7 Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA September 26, 2011 (1) Monthly Investment Report (2) August 2011 Financials I I i I ,. Deschutes County Investments By County Function General $ 106,708,663 Total Investments -$ 106,708,663 Total Investment Income I Less Fee: 5% of Invest. Income Investment Income -Net Investment Income Fiscal Year 2011-12 Aug-11 I I Y-T-D $ 53,578 $ 110,093 -- 53,578 110,093 (2,679) (5,505) $ 50,899 $ 104,589 Commercial Paper $ Corporate Notes 8,662,069 Time Certificates 9,324,063 U. S. Treasuries Federal Agencies 39,514,998 Bankers' Acceptances LGIP/BOTC 49,207,532 $ 106.708.663 0.00-,4 8.12% 8.74-,4 0.00-/_ 37.03°,4 0.00% ~ 100.00-,4 Total Portfolio: By Investment Types Time Certificates Corporate 9% Notes 8% Federal Agencies 37% 46% rcategory Maximums: ~ U.S. Treasuries I LGIP 100-,4 100% Federal Agencies 75% Banker's Acceptances 25-,4 Time Certificates 25% Commercial Paper 20% Corporate Notes 10% (;c .tt 3 Month Tr e as. ~ 12 MOlltll Treas. ~ 3 Month C P ~ 0 .02 % 0 .10 % 0 .18 % Average MatuntY in ,Days General ---632 , I ,, t Memorandum j ~ Date: September 15, 2011 ! 1 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director I RE: Monthly Financial Reports 1 Attached please find August 2011 financial reports for the following funds: General (001), Community Justice -Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice -Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERAL FUND f Statement of Financial Operating Data Two Months Ended August 31, 2011 1 \ I j RESOURCES: Actual Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 13% 1 Revenues Property Taxes 3.350,161 281,515 (3,068,646) 17% 1% a) 20,100.967 20,100,967 0% Gen. Rev. -excl. Taxes 397,054 1,090,600 693,546 17% 46% b) 2,382,321 2,382,321 0% Assessor 131,833 186,159 54,326 17% 24% c) 790,996 790,996 0% I County Clerk 244,785 210,171 (34,615) 17% 14% 1,468,707 1,468,707 0% BOPTA 2,066 4,081 2,015 17% 33% c) 12,398 12,398 0% District Attorney 49,778 12,412 (37,366) 17% 4% 298,669 298,669 0% FinancefTax 32,317 61,741 29,424 17% 32% c) 193,900 193,900 0% Veterans 10,224 150 (10,074) 17% 0% 61,341 61,341 0% Property Management 16,033 20,033 4,000 17% 21% 96,200 96,200 0% Grant Projects 333 333 0 17% 17% 2,000 2,000 0% Total Revenues 4,234,584 1,867,196 (2,367,388) 17% 7% 25,407,499 25,407,499 0% TOTAL RESOURCES 11,534,584 10,112,921 (1 ,421 ,663} 17% 31% 32,707,499 33,653,224 945,725 3% REQUIREMENTS: I EXP·%I Expenditures Assessor 567,550 513,602 53,948 17% 15% 3,405,300 3,405,300 0% County Clerk 237,328 169,082 68.246 17% 12% 1,423.965 1,423.965 0% j BOPTA 12,067 11,302 765 17% 16% 72,402 72,402 0%i I j District Attorney 813,216 695,054 118,162 17% 14% 4,879,296 4.879,296 0% FinancefTax 135,608 100,684 34,924 17% 12% 813,648 813,648 0% Veterans 43,686 40,835 2,851 17% 16% 262.115 262.115 0% Property Management 42,944 40,766 2,178 17% 16% 257,664 257,664 0% Grant PrOjects 19,786 19,710 76 17% 17% 118.715 118,715 0% Non-Departmental 261,160 166,363 94,797 17% 11% 1,566,962 1,566,962 O°..{, Contingency 1,162,787 1,162,787 17% nla 6,976,722 6,976,722 100% 3,296,132 1,757,398 1,538,734 17% 9% 19,776,789 12,800,067 6,976,722 35% Transfers Out 2.155,118 1,904,790 250,328 17% 15% 12,930,710 12,930,710 0% TOTAL REQUIREMENTS 5,451,250 3,662,188 1,789,062 17% 11% 32,707,499 25,730,777 6,976,722 21% NET (Resources -Requirements) 6,083,334 6,450,733 367,399 7,922,447 7,922,447 a) Current year property taxes will be collected beginning in October b) Includes annual payments: Tax on Electric Co-ops $489,027, PIL T $471,823 c) A & T Grant received quarterly. 1 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Two Months Ended August 31, 2011 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1 065-Court Assess. Discovery Fee Food Subsidy OVA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants -Private Behavioral Health CFC Interfund Grant Gen Fund Grant-Crime Prev Year to Date Budget I Actual I Variance IFY% I Coli. % $1,101,374 1,667 8,333 2,500 4,167 36,250 14,748 17 11,667 10 7 50 1,250 400 83 1,000 25,688 3,333 $1,099,010 $ (2,364) 100% 100% (1,667) 17% 0% 6,591 (1,742) 17% 13% 2,101 (399) 17% 14% 2,326 (1,841) 17% 9% (36,250) 17% 0% a) 900 (13,848) 17% 1% b) (17) 17% 0% 1,450 (10,217) 17% 2% 177 167 17% 295% c) (7) 17% n/a 745 695 17% 248% c) 1,121 (129) 17% 15% 200 (200) 17% 8% d) 300 217 17% 60% 138 (862) 17% 2% (25,688) 17% 0% e) (3.333} 17% 0% Variance $1,101,374 10,000 50,000 15,000 25,000 217,498 88,490 100 70,000 60 40 300 7,500 2,400 500 6,000 154,128 20,000 $1,099,010 $ (2,364) 10,000 50,000 15,000 25,000 355,730 138,232 88,490 100 70,000 200 140 40 825 525 7,500 1,200 (1,200) 500 6,000 134,620 (19,508) 20.000 Total Revenues 111,170 16,049 (95,121) 17% 2% 667,016 785,205 118,189 Transfers In-General Fund 886,910 886,910 17% 17% 5.321,459 5,321,459 TOTAL RESOURCES 2,099,454 2,001,969 (97,485) 17% 28% 7,089,849 7,205,674 115,825 REQUIREMENTS: 1 Exp. %1 Expenditures Community Justice-Juvenile Personal Services 851,512 818,151 33,361 17% 16% 5,109,069 5,109,069 Materials and Services 199,289 156.018 43,271 17% 13% a)e) 1,195,733 1,182,725 13,008 Capital Outlay 17 17 17% 0% 100 100 Transfers Out 8,400 8,400 17% 0% 50,400 50,400 Contingency 122,425 122.425 17% n/a 734,547 734,547 TOTAL REQUIREMENTS 1,181,643 974,169 207,474 170/0 14% 7,089,849 6,342,194 747,655 NET (Resources -Requirements) 917,811 1.027,800 109,989 863,480 863,480 a) OVA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly b) Billings outstanding -$14,250 for July & August c) Revenues trending greater than antiCipated d) Citizen Review Board vacated. Revenue projected adjusted accordingly e) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly SHERIFF -Fund 255 Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Actual Coli. % RESOURCES: Beg. Net Working Capital $ $ $ 100% nla $ $ $ 17% 13% 17% 13% Total Revenues 6,088,920 4,611,632 (1,477,288) 17% 13% 36,533,516 31,865,481 (4,668,035) TOTAL RESOURCES 6,088,920 4,611,632 (1,477,288) 17% 13% 36,533,516 31,865,481 (4,668,035) REQUIREMENTS: Exp. %1 EXPENDITURES & TRANSFERS Sheriffs Division 416,083 415,864 219 17% 17% 8) 2,496,498 2,583,942 (87,444) Civil 137,349 115,069 22,280 17% 14% 824,095 824,095 Automotive/Communications 244,439 89,735 154,704 17% 6% b) 1,466,632 1,622,207 (155,575) Investigations/Evidence 289,036 279,505 9,531 17% 16% 1,734,218 1,734,218 Patrol/Civil/Comm Supp 1,318,617 1,290,530 28,087 17% 16% 7,911,704 7,911,704 Records 120,118 96,953 23,165 17% 13% 720,710 720,710 Adult Jail 1,690,632 1,422,253 268,379 17% 14% c) 10,143,790 10,443,790 (300,000) Court Security 47,767 45,056 2,711 17% 16% 286,602 286,602 Emergency Services 30,938 28,913 2,025 17% 16% 185,625 185,625 Special Services Division 217,395 200,280 17,115 17% 15% 1,304,370 1,304,370 Regional Work Center 503,078 457,791 45,287 17% 15% 3,018,466 3,018,466 Training Division 54,044 48,292 5,752 17% 15% 324,265 324,265 Other Law Enforcement SVC5 105,376 109,184 (3,808) 17% 17% 632,256 632,256 Non-Departmental 12,205 12,205 17% 17% 73,231 73,231 Contingency 868,509 868,509 17% nla 5,211,054 5,211,054 Transfers Out -D/S Fund 33,333 33,333 17% 0% 200,000 200,000 TOTAL REQUIREMENTS 6,088,919 4,611,630 1,477,289 17% 13% 36,533,516 31,865,481 4,668,035 NET (Resources -Requirements) a) Reclassification open Personnel Assistant position to Operations Captain position b) Carryover of the Motorola communication system contract c) Carryover of the Jail Management Infonnation System Project 1 RESOURCES: Beg. Net Working Capital Tax Revenues -Current Tax Revenues -Prior Federal Grants State Grant Transp. of State Wards S81145 Des. Cty Video Lottery Grant Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Sale of Reportable Assets Total Revenues Fund 701 LED-Countywide Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget $5,108,671 2,384,474 83,500 5,867 8,079 833 256,277 833 15,167 697 25,000 167 638 1,100 8,333 583 833 833 2,500 2,667 833 33,333 4,722 589 167 Budget YearEnd Projection Variance 5,108,671 $6,090,734 $ 982,063 14,306,841 14,306,841 501,000 501,000 35,200 35,200 48,475 48,475 5,000 5,000 1,537,663 1,479,991 (57,672) 5,000 5,000 91,000 91,000 4,180 4,180 150,000 150,000 1,000 1,000 3,825 3,825 6,600 6,600 50,000 50,000 3,500 3,500 5,000 5,000 5,000 5,000 15,000 15,000 16,000 16,000 5,000 5,000 200,000 200,000 28,333 28,333 3,533 3,533 1,000 1,000 I Actual I $ 6,090,734 205,267 215,978 14,957 1,276 2,835 625 800 934 1,900 1,676 1,636 36,255 5,310 45 $ 982,063 (2,384,474) 121,767 (5,867) (8,079) (833) (40,299) (833) (210) (697) (25,000) (167) (638) 176 (5,498) 42 (33) 101 (600) (991) 803 2,922 588 (544) ~1672 Variance I FY %I Coli. % 100% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 119% $ 0% 41% 0% 0% 0% 14%8) 0% 16% 0% 0% 0% 0% 19% 6% 18% 16% 19% 13% 10% 33% 18% 19% 1% n/a 2,846,025 497,309 ~2,348,716} 17% 3% 17,076,150 17,018,478 ~57,672} TOTAL RESOURCES 7,954,696 6,588,043 (1,366,653) 170k 30% 22,184,821 23,109,212 924,391 REQUIREMENTS: To: Fund 255 Departments Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Internal Services Transfer to Debt Service Contingency Total to Fund 255 390,282 137,349 91,467 1,690,632 47,767 30,938 151,135 503,078 32,993 105,376 6,115 33,333 460,340 3,680,804 390,076 115,069 33,578 1,422,253 45,056 28,913 139,237 457,791 29,482 109,184 6,115 2,776,753 205 22,280 57,889 268,379 2,711 2,025 11,899 45,287 3,512 (3,808) 0 33,333 460,340 904,050 1 Exp. %1 17% 17% 17% 14% 17% 6% 17% 14% 17% 16% 17% 16% 17% 15% 17% 15% 17% 15% 17% 17% 17% 17% 17% 0% 17% 0% 2,341,690 824,095 548,799 10,143,790 286,602 185,625 906,811 3,018,466 197,961 632,256 36,689 200,000 2,762,037 22,084,821 2,423,712 824,095 607,014 10,443,790 286,602 185,625 906,811 3,018,466 197,961 632,256 36,689 200,000 19,763,020 (82,022) (58,215) (300,000) 2,762,037 2,321,801 Transfer to Reserve Fund (703) 16,667 16,667 17% 0% 100,000 100,000 Total Requirements 7,378,274 2,776,753 4,601,519 13% 22,184,821 19,863,020 2,321,801 Net 576,422 3,811,290 3,234,867 3,246,192 3,246,192 a) Reduction in State Community Corrections funding for custody of S8 1145 inmates TOTAL RESOURCES REQUIREMENTS: To: Fund 255 Departments Sheriff'S Services AutofComm Investigations Patrol Records Special Services Training Internal Services 4,871,885 25,801 152,972 289,036 1,318,617 120,118 66,260 21,051 6,090 169 3,578,988 25,788 56,157 279,505 1,290,530 96,953 61,043 18.810 6,090 (1,292,897) 14 96,815 9,531 28,087 23,165 5,216 2,241 60% 26% I Exp·%1 17% 17% 17% 6% 17% 16% 17% 16% 17% 13% 17% 15% 17% 17% 14,548,695 154,808 917,833 1,734,218 7,911,704 720,710 397,559 126,304 36,542 7 14,566,348 160,230 1,015,193 1,734,218 7,911,704 720,710 397,559 126,304 36,542 17,653 (5,422) (97,360) Transfer to Reserve Fund (704) 16,667 16,667 17% 0% 100,000 100,000 Total Requirements 4,816,232 1,834,877 2,981,355 13% 14,548,695 12,202,461 2,346,234 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues -Current Tax Revenues -Prior Federal Grants Federal Grants-BLM US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Des Cty General Fund Grant Des Cty Transient Room Tax City of Sisters Des Cty CDD Contract Des Cty Solid Waste Contr Des Cty Clerk/Election School Districts Security &Traffic Reimb Seat Belt Program Miscellaneous Restitution Sheriff Fees Court Fines &Fees Impound Fees Restitution -Street Crimes SeizurefF orfeiture Interest Interest on Unsegregated Donations Sale of Reportable Assets Sale of Equip &Material Total Revenues Fund 702 LED Rural Statement of Financial Operating Data Two Months Ended August 31, 2011 Vearlo Date Budget I Actual I Variance $2,936,523 $2,988,333 $ 51,810 1,224,687 (1,224,687) 42,833 102,318 59,485 2.000 927 (1,073) 4.167 3,377 (790) 17% nfa 13,125 (13,125) 17% 0% 33,495 (33,495) 17% 0% 10,000 6,591 (3,409) 17% 11% 23,722 (23,722) 17% 0% 96,024 (96,024) 17% 0% 345.643 345,643 17% 17% 74,994 74,994 17% 17% 9.061 9.061 17% 17% 9,061 9,061 17% 17% 333 (333) 17% 0% 13.333 (13,333) 17% 0% a) 833 680 (153) 17% 14% 2,000 1,385 (615) 17% 12% 1.667 1.071 (596) 17% 11% 2,004 2,004 17% nfa 1,667 1,724 57 17% 17% 19,167 17,408 (1,759) 17% 15% 1,167 800 (367) 17% 11% 83 (83) 17% 0% 1,324 1,324 17% nfa 1.667 2,460 793 17% 25% 300 22 (278) 17% 1% 2,515 2,515 17% n/a 1,000 374 (626) 17% 6% 3,333 6,916 3,583 17% 35% 1,935,362 590,655 {1,344,7071 60% 6% I FY % I Coli. % 100% 102% 17% 0% 17% 40% 17% 8% Budget Year End Projection Variance $2,936,523 $2,988,333 $ 51,810 7,348,125 7.348.125 257,000 257,000 12,000 12,000 25,000 25,000 78,750 78,750 200,972 200,972 60,000 60.000 142,332 142.332 576,144 576.144 2,073,856 2.073.856 449,961 449.961 54,366 54,366 54,366 54,366 2,000 2,000 80,000 40.000 (40.000) 5,000 5,000 12,000 12.000 10,000 10.000 2,004 2,004 10,000 10,000 115,000 115,000 7,000 7,000 500 500 1,324 1,324 10,000 10.000 1,800 1,800 2,515 2,515 6,000 6.000 20.000 20,000 11,612,172 11,578,015 {34,157} Net 55,653 1,744,111 1,688,458 2,363,886 2,363,886 a) By mutual agreement between the Sheriff'S Office and the School District, fewer SRO deputies will be at the schools PUBLIC HEALTH Statement of Financial Operating Data Two Months Ended August 31, 2011 Variance RESOURCES: Beg. Net Working Capital $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 Revenues Medicare Reimbursement 100 70 (30) 17% 12% 600 600 State Grant 422,782 301,247 (121,535) 17% 12% 2,536,691 2,536,691 Child Dev & Rehab Center 4,101 (4,101) 17% 0% 24,607 24,607 State Miscellaneous 37,472 (37,472) 17% 0% 224,829 224,829 OMAP 87,308 147.387 60,079 17% 28% 523,850 523,850 Family Planning Exp Proj 86,667 38,218 (48,449) 17% 7% 520,000 520,000 Local Grants 7,500 10,000 2,500 17% 22% 45,000 45,000 Water Program-Base Fee 7,000 (7,000) 17% 0% 42,000 42,000 Contract Payments 25,000 25,000 17% nla 25,000 25,000 Water Program-Field Work 9,303 (9,303) 17% 0% 55,817 55,817 H20 Sys Insp-Priv Wells 33 (33) 17% 0% 200 200 Miscellaneous 60 60 17% nla 300 300 Patient Insurance Fees 22,563 19,197 (3,366) 17% 14% 135,380 135,380 Health DepUPatient Fees 19,795 16,138 (3,657) 17% 14% 118,770 118,770 Vital Records-Birth 5,100 7,830 2,730 17% 26% 30,600 30,600 Vital Records-Death 16,667 14,460 (2,207) 17% 14% 100,000 100,000 Environmental Health 117,392 41,664 (75,728) 17% 6% 704,350 704,350 Interest on Investments 2,000 1,417 (583) 17% 12% 12,000 12,000 Donations 4,338 8,045 3,707 17% 31% 26,030 26,030 Interfund Contract 33,065 (33,065) 17% 0% 198,387 198,387 Administrative Fee 2,509 2,509 17% 17% 15,056 15,056 Total Revenues 885,695 633,242 (252,453) 17% 12% 5,314,167 5,339,467 25,300 Transfers In-General Fund Transfers In-PH Res Fund Transfers In-Gen. Fund Other 386,294 5,000 10.850 386.294 (5.000) ~10,850~ 17% 17% 17% 17% 0% 0% 2.317,765 30,000 65,100 2,317,765 30,000 65,100 TOTAL RESOURCES 2,884,757 2,721,665 (163,092) 17% 29% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,035,825 302,641 33,333 25,000 134,525 982,408 234,250 53,417 68,391 33,333 25,000 134,525 I Exp.%l 17% 16% 17% 13% 17% 0% 17% 0% 17% n/a TOTAL REQUIREMENTS 1,531,324 1,216,658 314,666 17% 13% 9,323,950 9,454,461 130,511 6,214,951 1,815,848 200,000 286,000 807,151 6.214.951 1 ,815,848 200,000 286,000 807,151 9,323,950 8,516,799 807,151 NET (Resources -Requirements) 1,353,433 1,505,007 151,574 937,662 937,662 BEHAVIORAL HEAlTH Statement of Financial Operating Data Two Months Ended August 31, 2011 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Two Months Ended August 31. 2011 Year to Date Budget I Actual I Variance I FY % I Coil. % BudQet YearEnd Projection Variance RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range $ 229,822 4.058 167 27,783 200.147 43,192 26,700 46.733 112,483 42,288 136,681 6.587 702 38.644 215.028 52,429 23.357 67,497 102,133 53.020 $ (93,141) 2.529 535 10.861 14.881 9.237 (3.343) 20.764 (10.350) 10.732 100"10 17% 17% 17% 17% 17% 17% 17% 17% 17% 59% 27% 70% 23% 18% 20% 15% 24% 15% 21% a) b) a) a) a) c) a) a) $ 229,822 24,350 1.000 166,700 1.200.880 259.150 160.200 280,400 674,900 253.726 $ 136,681 24.350 1.500 166,700 1,200,880 259,150 160,200 280,400 674,900 253,726 (93,141) 500 Total Revenues 503,551 559,397 55,846 17% 19% 3,021,306 3,021,806 500 Trans In-GF Trans In-GF for Lng Rng Ping Trans In-Other TOTAL RESOURCES 104.938 82.560 17 920,888 104.938 82,560 883,576 (17) (37,312) 17% 17% 17% 17% 17% 17% 0% 20% 629.625 495,360 100 4,376,213 629,625 495,360 100 4,283,572 (92,641) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site pgm Planning-Current Planning-Long Range Transfers Out (DIS Fund) Contingency 235,303 21,293 34.095 93.672 39.570 27,615 23.851 103.167 79.801 28.981 42.021 236,308 19,808 33.626 88,523 46,678 31,993 26.360 91.286 72.109 (1.005) 1,485 469 5.149 (7.108) (4.378) (2,509) 11.881 7.692 28.981 42.021 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% Exp. %1 17% 16% 16% 16% 20% 19% 18% 15% 15% 0% n1a d) d) e) 1,411,818 127.755 204.570 562.032 237,420 165.689 143,108 619.002 478,806 173.885 252,128 1,411.818 127.755 204.570 562.032 237,420 165,689 143,108 619.002 478.806 173.885 252.128 TOTAL REQUIREMENTS 729,369 646,691 82,679 17% 15"10 4,376,213 4,124,085 252,128 NET (Resources· Requirements) 191,519 236,886 45,367 159,487 159,487 Revenues Expenditures Net from OperatiOns 559.397 646.691 (87.294) 3,021.306 4.376,213 (1,354,907) 3.021,806 4.124,085 (1.102,279) 500 252,128 252,628 a) Activity is seasonal b) GIS revenue is sporadic based on the frequency of customer requests c) Contract payments from Redmond and other jurisdictions typically lag one month behind service delivery d) Year to date actual includes payout to retired employee e) Extra Help expenses concentrated in the summer months 1 1 I 1 I1 ! I q 1 I RESOURCES: Beg. Net Working Capital Revenues System Development Charge Federal Reimbursements Federal Grant Mineral Lease Royalties Forest Receipts State Miscellaneous Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SOC) Miscellaneous Road Vacations Interest on Investments Park.ing Fees Interfund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Forester Car Washes Sale of Equip & Material Total Revenues Trans In -Solid Waste Trans In -Transp SOC Trans In-Road Imp Res TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources -Requirements) ROAD Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget I Actual I Variance IFY% I Coli. % $2,834,720 $ 3,417,158 $ 582,438 100% 121% 231 231 17% n/a 100,000 (100,000) 17% 0% 3,333 (3,333) 17% n/a 6,667 3,627 (3,040) 17% 9% 218,527 (218,527) 17% 0% 83,340 500,041 416,701 17% 100% 1,890,000 1,654,805 (235,195) 17% 15% 45,833 (45,833) 17% 0% 58,333 (58,333) 17% 0% 1,667 (1,667) 17% 0% 1,667 (1,667) 17% 0% 167 673 506 17% 67% 3,333 2,345 (988) 17% 12% 167 (167) 17% 0% 3,333 3,297 (36) 17% 16% 24 (24) 17% 0% 121,667 (121,667) 17% 0% 33,333 (33,333) 17% 0% 15,000 (15,000) 17% 0% 1,667 (1,667) 17% 0% 11,917 (11,917) 17% 0% 4,167 (4,167) 17% 0% 583 (583) 17% 0% 105,500 2,379 ~103,121l 17% 0% 2,710,225 2,167,398 (542,827) 17% 13% 47,629 (47,629) 17% 0% 41,667 (41,667) 17% 0% 2,000 (2,000) 17% 0% 5,636,241 5,584,556 (10,018) 170/0 29% 1 EXP.%l 935,887 884,659 51,228 17% 16% 1,695.446 2,340,376 (644,930) 17% 23% 206,115 21,152 184,963 17% 2% 100,000 100,000 17% 0% 336,525 336,525 17% n/a 3,273,973 3,246,187 27,786 17% 17% 2,362,268 2,338,369 17,768 a) Revenue will be received following completion of Cascade Lakes chip seal (October 2011) b) Annual payment-January 2012 c) Annual payment received in August d) Billed upon completion of work. e) Payments to be received in June 2012 from other Road Department funds Budget Year End Projection Variance $ 2,834,720 $ 3,417,158 $ 582,438 231 231 a) 600,000 600,000 20,000 20,000 40,000 40,000 b) 1,311,162 1,311,162 c) 500,041 500,041 11,340,000 11,340,000 d) 275,000 275,000 d) 350,000 350,000 d) 10,000 10,000 d) 10,000 10,000 1,000 1,000 20,000 20,000 1,000 1,000 20,000 20,000 144 144 e) 730,000 730,000 200,000 200,000 90,000 90,000 e) 10,000 10,000 e) 71,500 71,500 e) 25,000 25,000 3,500 3,500 633,000 633,000 16,261,347 16,261,578 285,773 285,773 250,000 250,000 12,000 12,000 19,643,840 20,226,509 582,669 5,615,323 10,172,674 1,236,691 600,000 2,019,152 5,615,323 10,172,674 1,236,691 600,000 2,019,152 19,643,840 17,624,688 2,019,152 2,601,821 2,601,821 231 ADULT PAROLE &PROBATION Statement of Financial Operating Data Two Months Ended August 31,2011 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund -Sheriff Crime Prevention Grant CFC-Domestic Violence Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Year to Date Budget ! Actual ! Variance $ 560,000 $ 634,125 $ 74,125 36,225 717 5,153 2,167 475,942 4,000 683 28,333 33,333 1,500 8,333 8,333 12,472 1,663 401,103 5,608 320 20,466 30,126 805 8,333 (36,225) (717) (5,153) (504) (74,839) 1,608 (363) (7,867) (3,207) (695) (8,333) (12,472) 617,191 468,424 (148,767) 56,382 56,382 1,233,573 1,158,931 (74,642) 528,115 480,313 47,802 147,815 103,027 44,788 17 17 4,800 4,800 86,162 86,162 !FY % 1 Coil. % 100% 113% 17% 0% 17% 0% 17% 0% 17% 13% 17% 14% 17% 23% 17% 8% 17% 12% 17% 15% 17% 9% 17% 17% 17% 0% 17% 0% 17% 13% 17% 17% 17% 25% 1 Exp.%l 17% 15% 17% 12% 17% 0% 17% 0% 17% nfa a) b) c) d) e) e) Budget Year End Projection Variance $ 560,000 $ 634,125 $ 74,125 217,350 217,350 4,301 4,301 30,918 25,000 (5,918) 13,000 13,000 2,855,659 2,748,953 (106,706) 24,000 24,000 4,100 4,100 170,000 170,000 200,000 200,000 9,000 9,000 SO,OOO 50,000 SO,OOO 50,000 74,832 74,832 3,703,160 3,590,536 (112,624) 338,292 338,292 4,601,452 4,562,953 (38,499) 3,168,688 886,890 100 28,800 516,974 3,168,688 886,890 28,800 100 516,974 TOTAL REQUIREMENTS 766,909 583,340 183,569 17% 13% 4,601,452 4,084,378 517,074 NET (Resources -Requirements) 466,664 575,591 108,927 478,575 478,575 a) Annual allocation expected in September b) Annual allocation normally received in February c) State invoiced monthly. Payment of July and August invoices expected in September d) Payments received quarterly; due to lower population and cost savings, revenue will be less than budgeted e) Interfund grant received quarterly ~ J :1 I COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Two Months Ended August 31. 2011 Vearto Date RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV -Family Sup/Pres HealthyStart Medicaid level 7 Services DHS-Runaway Homeless State Prevention Funds HealthyStart /R-S-G OCCFGrant Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Miscellaneous Total Revenues Budget $ 467,111 49,915 6.555 15.833 42,997 4,083 51.973 90,867 1,333 13.000 833 20.146 297,535 I $ Actual 556,143 20,472 588 5 22,969 44,034 I Variance IFY % I Coil. % $ 89,032 100% 119% (49.915) (6,555) (15.833) (42,997) (4,083) (51,973) (90,867) (1.333) 7,472 (245) 5 2,823 (253,501) 17% 0% 17% 0% 17% 0% 17% 0% 17% n/a 17% 0% 17% 0% 17% 0% 17% 0% 17% 26% 17% 12% 17% n/a 17% 19% 17% 2% a) b) a) c) d) a) a) e) f) Trans from General Fund Total Transfers In 45,493 45,493 45,494 45,494 17% 170/_ 17% 17% TOTAL RESOURCES 810,139 645,671 (164,469) 17% 26% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 100,853 281,163 17 38,848 92,183 29,593 8,670 251,570 17 38,848 1 Exp. %1 17% 15% 17% 2% 17% 0% 17% n/a TOTAL REQUIREMENTS 420,881 121,776 299,105 17% 5% NET (Resources -Requirements) 389,258 523,895 134,636 a) FY 12 and FY 13 Intergovernmental Agreement finalized funding levels from OCCF b) Medicaid revenues reduced due to lower projections c) Runaway/homeless youth grant from Department of Human Services d) Youth Suicide Prevention grant increased by $5.000 e) Court fees projected to be higher than estimated in the original budget f) Two additional grants of $55,000 & $180.000 awarded Budget Year End Projection Variance $ 467,111 $ 556,143 $ 299,488 299,488 39,329 39.534 95,000 85,000 257,982 196,898 48,122 24.500 29,500 311,838 258,203 545,203 492,806 8,000 8,000 78,000 85,000 5,000 5,000 5 120,875 355.875 89,032 205 (10,000) (61,084) 48,122 5,000 (53,635) (52,397) 7,000 5 235,000 1,785,215 1,903,431 118,216 272,960 272,960 272,960 272,960 2,525,286 2,732,534 605.119 1.686,979 100 233,088 605,119 1.713.245 100 2,525,286 2,318,464 207,248 (26.266) 233,088 206,822 414,070 414,070 SOLID WASTE Statement of Financial Operating Data Two Months Ended August 31,2011 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 Recyclables Budget $1,092,508 3,667 33,333 143,333 219,000 666,667 12,167 4,167 1,250 5,000 Year to Date I Actual I Variance $ 1,141,691 $ 49,183 3,589 (78) 5,127 (28,206) 166,472 23,139 275,130 56,130 690,065 23,398 22,857 10,690 712 (3,455) 1,617 367 1,393 1,393 15,948 10,948 I FY %1 100% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% Coil. % 105% 16% 3% 19% 21% 17% 31% 3% 22% a) b) n/a c) 53% Budget Year End Projection Variance $1,092,508 $ 1,141,691 $ 49,183 22,000 22,000 200,000 200,000 860,000 860,000 1,314,000 1,314,000 4,000,000 4,000,000 73,000 73,000 25,000 25,000 7,500 7,500 1 10,394 10,393 30,000 30,000 Total Revenues 1,088,584 1,182,910 94,326 17% 18% 6,531,501 6,541,894 10,393 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Contingency 2,181,092 278,600 482,175 161,872 28,667 226,629 92,726 2,324,601 264,353 203,459 143,509 14,247 278,716 161,872 28,667 226,629 92,726 17% 17% 17% 17% 17% 17% 17% 30% Exp·%1 16% 7% 0% 0% 0% n/a d) e) 7,624,009 1,671,598 2,893,052 971,233 172,000 1,359,773 556,353 7,683,585 1,671,598 2,893,052 971,233 172,000 1,359,773 59,576 556,353 TOTAL REQUIREMENTS 1,270,669 467,812 802,857 17% 6% 7,624,009 7,067,656 556,353 NET (Resources· Requirements) 910,423 1,856,789 946,366 615,929 615,929 a} Due April 15, 2012 b} Dependent on special clean-ups such as asbestos and contaminated soil c} Revenue from rent on Rickard Road property, not included in original budget d) To be expended in November ($398,827) and May ($572,406) e) Transfers made quarterly RISK MANAGEMENT Statement of Financial Operating Data Two Months Ended August 31, 2011 RESOURCES: Beginning Net Working Capital $2,100,000 $2,039,937 ($60,063) 100% 97% $2,100,000 $2,039,937 ($60,063) Revenues Inter-fund Charges: General liability 41,809 41,809 (0) 17% 17% 250,855 250,855 Property Damage 51,939 51,939 0 17% 17% 311,633 311,633 Vehicle 29,718 29,718 (0) 17% 17% 178,310 178,310 Workers' Compensation 245,657 245,657 (0) 17% 17% 1,473,944 1,473,944 Unemployment 42,072 42,126 54 17% 17% 252,433 252,433 Claims Reimb-Workers' Compensation 833 (833) 17% 0% 5,000 5,000 Claims Reimb-Gen liab/Property 3,333 3,091 (242) 17% 15% 20,000 20,000 Process Fee-Events/Parades 250 420 170 17% 28% 1,500 1,500 Miscellaneous 8 (8) 17% 0% 50 50 Skid Car Training 3,000 350 (2,650) 17% 2% 18,000 18,000 Interest on Investments 2,500 2,119 (381) 17% 14% 15,000 15,000 Other Interest 8 (8) 17% 0% 50 50 TOTAL REVENUES 421,129 417,229 (3,900) 17% 17% 2,526,775 2,526,775 TOTAL RESOURCES 2,521,129 2,457,166 (63,963) 17% 53% 4,626,775 4,566,712 (60,063) AppropriationslExpendltures I %Exp. I Direct Insurance Costs: GENERAL LIABILITY Settlement I Benefit 2,277 Defense 37,919 Professional Service Insurance 100 Loss Prevention 78 Repair I Replacement 611 Total General Liability 66,667 40,984 25,682 17% 10% 400,000 400,000 PROPERTY DAMAGE Insurance Repair I Replacement 379 Total Property Damage 50,037 379 49,659 17% 0% 300,223 300,223 VEHICLE Professional Service Insurance Loss Prevention Repair I Replacement 4,018 Total Vehicle 16,914 4,018 12,896 17% 4% 101,485 101,485 WORKERS' COMPENSATION Settlement I Benefit 114,052 Defense 134 Professional Service Insurance 54,720 Loss Prevention 7,862 Miscellaneous 14 Total Workers' Compensation 133,333 176,781 (43,448) 17% 22% 800,000 BOO,OOO UNEMPLOYMENT -SettiemenVBenefits 41,667 41,667 17% 0% 250,000 250,000 Total Direct Insurance Costs 308,618 222,162 86,456 17% 12% 1,851,708 1,851,708 Insurance Administration: Personal Services 49,060 48,391 669 17% 16% 294,357 294,357 Materials &Service 27,953 21,988 5,965 17% 13% 167,717 167,717 Capital Outlay 17 17 17% 0% 100 100 Total Insurance Administration 77,029 70,379 6,650 17% 15% 462,174 462,074 100 Transfers Out 1,200 1,200 17% 0% 7,200 7,200 Contingency 384,282 384,282 17% n/a 2,305,693 2,305,693 TOTAL REQUIREMENTS 771,129 292,541 478,588 17% 6% 4,626,n5 2,320,982 2,305,793 NET 1,750,000 2,164,625 414,625 2,245!730 2,245!730 DESCHUTES COUNTY 911 Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date YearEnd Actual Variance Bud!ilet Projection Variance RESOURCES: Beg. Net Working Capital $6,400,000 $ 7,559,639 $ 1,159,639 100% 118% $6,400,000 $7,559,639 $ 1,159,639 Revenues Property Taxes -Current 997,296 (997,296) 17% 0% 5,983,773 5,983,773 Property Taxes -Prior 33,333 77,625 44,292 17% 39% 200,000 200,000 State Reimbursement 9,000 (9,000) 17% 0% a) 54,000 54,000 Telephone User Tax 125,000 (125,000) 17% 0% 750,000 750,000 Data Network Reimb. 4,533 (4,533) 17% 0% b) 27,200 27,200 Jefferson County 5,833 565 (5,268) 17% 2% 35,000 35,000 User Fee 8,667 (8,667) 17% 0% c) 52,000 52,000 Police RMS User Fees 33,167 (33,167) 17% 0% b) 199,000 199,000 Contract Payments 5,333 (5,333) 17% 0% b) 32,000 32,000 Miscellaneous 1,500 1,135 (365) 17% 13% 9,000 9,000 Interest 5,833 6,809 976 17% 19% 35,000 35,000 Interest on Unsegregated Tax 133 19 ~114~ 17% 2% 800 800 Total Revenues 1,229,628 86,153 (1,143,475) 17% 1% 7,377,773 7,377,773 TOTAL RESOURCES 7,629,628 7,645,792 16,164 17% 55% 13,777,773 14,937,412 1,159,639 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 706,806 326,226 85,833 83,333 1,094,097 648,150 343,872 5,928 58,656 (17,646) 79,905 83,333 1,094,097 17% 17% 17% 17% 17% % Exp·1 15% 18% 1% 0% nla 4,240,834 1,957,356 515,000 500,000 6,564,583 4,240,834 1,957,356 515,000 500,000 6,564,583 TOTAL REQUIREMENTS 2,296,295 997,950 1,298,345 17% 7% 13,777,773 7,213,190 6,564,583 NET (Resources -Requirements) 5,333,333 6,647,842 1,314,509 7,724,222 7,724,222 a) GIS/MSAG monthly billings to Oregon Emergency Management b) Invoiced annually in AugusVSeptember c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually in June Health Benefits Trust Statement of Financial Operating Data Two Months Ended August 31, 2011 Year to Date Budget Actual Variance FY% IcolI.%i1 I Year End Budaet Projection Variance I RESOURCES Beg. Net Working Capital $15,500,000 $ 15,829.888 $ 329,888 100% 0 $15.500.000 $ 15,829,888 329,888 Revenues: Internal Premium Charges 2,002.619 2,002,116 (502) 17% 17% 12,015,711 12,015,711 PfT Emp -Add'i Prem 8,333 4,976 (3,358) 17% 10% 50,000 50.000 Employee Prem Contribution 105,000 105,220 220 17% 17% 630,000 630.000 COIC 210,000 205,552 (4,448) 17% 16% 1,260,000 1,260,000 Retiree / COBRA Co-Pay 83,333 159,040 75,706 17% 32% 500,000 500,000 Fees for Clinic Services 200 200 17% nla 200 200 Interest 13.333 14.839 1,506 17% 19% 80,000 80,000 Total Revenues 2,422,619 2,491,943 69,324 17% 17% 14,535,711 14,535,911 200 TOTAL RESOURCES 17,922,619 18,321,831 399,213 92% 102% 30,035,711 30,365,799 330,088 REQUIREMENTS 1 Exp. %1 Expenditures: Personal Services 21.677 20,771 906 17% 16% 130,062 130,062 Materials & ServiCes Claims Paid-MedicallRx 2,079,047 1,610,216 468,832 17% 13% a) 12,474,284 9,303,468 3,170,817 Claims Paid-DentalNision 310,662 214,362 96,300 17% 12% a) 1,863,974 1,238,538 625,435 Refunds 0 (1,685) 1,685 17% nla (1.685) 1,685 Insurance Expense 58,333 57,600 733 17% 16% 350,000 350,000 State Assessments 25.000 70,788 (45.788) 17% 47% 150,000 150,000 Administration Fee 53,333 52,281 1,053 17% 16% 320,000 320,000 PPO Fee 8,333 7,886 448 17% 16% 50,000 50,000 Health Impact 9,167 8,623 543 17% 16% 55,000 55,000 Other 27,053 41,065 !14,012~ 17% 25% 162,318 162,318 Total HBT • Dept 31 2,592,606 2,081,907 510,700 13% 15,555,638 11,757,701 3,797,937 Deschutes On-site Clinic Healthstat 159,533 58,129 101,405 17% 6% 957,200 957,200 Medications/Drugs 54,167 1,422 52,745 17% 0% 325,000 325,000 Equipment 667 667 17% 0% 4,000 4,000 Miscellaneous 1,408 1,332 77 17% 16% 8,450 8,450 Total DOC Capital Outlay Contingency 215,775 33 2,197,537 60,882 164,893 33 2,197,537 17% 17% nla nla 1,294,650 200 13,185,223 1,294.650 - 200 13,185.223 TOTAL REQUIREMENTS 5,005,952 2,142,789 2,863,163 17% 7% 30,035,711 13.052,351 16,983,360 NET (Resources -RequIrements) 12.916,667 16,179.042 3.262,376 17.313,448 17.313,448 a) Projection based on annualizing 9 weeks of claims paid. YTD actual is $202,544 per week. 9/1312011 Deschutes County -Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Two Months Ended August 31,2011 YearEnd Budget Projection Variance I RESOURCES: Beg. Net Working Capital $ 75,000 $ (40,601) $ (115,601) 100% -54% $ 75,000 $ (40,601) $ (115,601) Receipts: Special Events Revenues 100,833 188,444 87,611 17% 31% 605,000 583,444 (21,556) Interest 250 60 (190) 17% 4% 1,500 1,310 (190) Storage 9,667 (9,667) 17% 0% 58,000 58,000 Camping at F & E 1,000 (1,000) 17% 0% 6,000 6,000 Horse Stall Rental 5,000 165 (4,835) 17% 1% 30,000 30,165 165 Concession % -Food 36,667 33,338 (3,329) 17% 15% 220,000 214,338 (5,662) Rights (Signage, etc.) 18,667 16,000 (2,667) 17% 14% 112,000 122,000 10,000 Interfund Contract 7,833 (7,833) 17% 0% 47,000 47,001 1 Miscellaneous 1,135 1,917 783 17% n/a 6,807 7,541 734 Total Receipts 181,051 239,924 58,873 17% 22% 1,086,307 1,069,799 (16,508) Transfers In General Fund (001) 28,333 28,334 17% 17% 170,000 170,000 Room Tax (160) 4,291 4,290 17% 17% 25,744 25,744 Welcome Center (170) 13,800 13,800 17% 17% 82,800 82,800 Annual County Fair (619) 36,667 (36,667) 17% 0% 220,000 220,000 Reserve Fund (617) 17 (17) 17% 0% 100 ~100~ Total Transfers In 83,107 46,424 (36,683) 498,644 498,544 (100) TOTAL RESOURCES 339,159 245,747 (93,411) 17% 15% 1,659,951 1,527,742 (132,209) REQUIREMENTS: Expenditures: Personal Services 144,336 144,397 (61 ) 17% 17% 866,018 866,095 (77) Materials and Services 80,177 95,755 (15,578) 17% 20% 481,060 510,906 (29,846) Debt Service 19,178 19,178 17% 0% 115,068 115,068 Capital Outlay 17 17 17% 0% 100 100 Total Expenditures 243,708 240,152 3,556 1,462,246 1,492,069 (29,823) Transfers Out· Reserve Fund 1,667 1,667 17% 0% 10,000 10,000 Contingency 31,284 31,284 17% n/a 187,705 187,705 TOTAL REQUIREMENTS 276,659 240,152 36,507 17% 140/0 1,659,951 1,502,069 157,882 NET (Resources -Requirements) 62,500 5,595 (56,905) 25,673 25,673 rJ'J u ~ ~ 0 ~ ~ ~ ~ < ~ ~ ~ < U rJJ ::1 0.. E ell U ».....c: ::1 0 u ...c: t:: 0 Z • c:c:- E Il.)...c: Il.)-...c:..... Il.) CO • RESOURCES: Loan Proceeds, net of issuance costs Resources from Fund 140 Resources from Fund 142 Transfer in Interest Revenue Total Resources EXPENDITURES: Materials & Services Arch itecture/Design Engineering Planning Interfund Charges Fees, Permits & SDCs Utilities Travel -Meals/Mileage Reimb Total Materials & Services Deschutes County North County Services Building Inception through August 31,2011 ACTUAL Received and Expended Encumbrances & Commitments Project to Date 1,402,013 25,000 600,000 446 2,027,459 1,402,013 25,000 600,000 446 2,027,459 25,000 25,000 50,000 277 442 25,719 25,000 277 442 50,719 Project Budget 2,000,000 a) 1,402,013 b) 25,000 600,000 4,027,013 b) 100,000 10,000 1,663 60,000 2,000 173,663 PROJECTION Projected 2,000,000 1,402,013 25,000 600,000 446 4,027,459 100,000 10,000 1,663 60,000 2,000 173,663 I Variance 446 446 Capital Outlay Land and Building Remodel 1,402,013 230 1,402,013 230 a) 1,402,013 2,451,337 1,402,013 2,451,337 Total Capital Outlay 1,402,243 1,402,243 3,853,350 3,853,350 Contingency Total Expenditures 1,427,962 25,000 1,452,962 4,027,013 4,027,013 Net 599,498 (25,000) 574,498 446 446- 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) Deschutes County Bethlehem Inn (Fund 128) Two Months Ended August 31, 2011 Bud~et Actual I Variance !FY% I COII.%! Bud~et I Projection IVariance RESOURCES: 8eg. Net Working Capital $(2,711,235) $ (2,716,581) $ (5,346) 100% 100% $ (2,711,235) $(2,716,581) $ (5,346) Revenues Grants -Private 466,971 (466,971) 17% 0% 2,801,827 . (2,801,827) Lease Payments 4,068 6,102 2,034 17% 25% * 24,408 24,408 1 Total Revenues 471,039 6,102 (464,937) 17% 0% 2,826,235 24,408 (2,801,827)I I TOTAL RESOURCES (2,240,196) (2,710,479) (470,283) 17% ·2357% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: Exp. %1 Expenditures Debt Service: I Interest Expense 2,500 2,617 (117) 17% 17% a) 15,000 15,000 Interest Payment 16,667 16,667 17% 0% 100,000 100,000 I TOTAL REQUIREMENTS 19,167 2,617 16,549 17% 2% 115,000 15,000 100,000 NET (Resources -Requirements) (2,259,3631 (2,713,096) {453,734~ b) (2,707,173) (2,707,173) • September lease payment received August 30. a) Interest on August 2011 negative cash balance: $1,293.38 b) Inception through August 31, 2011 Revenues -Lease Payments $ 30,510 Expenditures: Land/Building (Amertitie) -July 2007 2,241,313 Hickman Williams 17,578 City of Bend -May 2008 250,000 KN EXCO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 225,694 Total expended 2,743,606 Net $ ~2,713,096) Deschutes County· Solid Waste Area A Closure and Cell 5 Construction As of August 31,2011 "AreaA" Landfill Closure Fund 611 p:ngineering Contract I G. Friesen Associates, Inc. Original Contract 241,869.00 Change Orders: Change Order #1 (Note a) DEQ requirement for gas detection 19,656.00 Change Order #2 LFG well field management SOPs 21,500.00 Change Order #3 Storm sewer realignment, drainage, Area A thickness 34,316.00 Total Contract 317,341.00 Amount Paid Through June 30, 2011 (Final payment made December 2010) 317,341.00 Balance Due Fonstruction Contract I M A DeAtley Construction Inc Original Contract· @ estimated cu.yd. 2,097,140.50 Amended Contract· @ revised cu.yd. and damages 2,284,885.13 Change Orders: Change Order #1 Meet CEC requirements, increase to electrical panel, Change Order #2 Storm sewer realignment due to refuse encountered 14,302.54 Change Order #3 Revise valve vaults for improved efficiencies 24,885.69 Change Order #4 Add'i cover material from what will be Cell 6 32,690.70 Change Order #5 Environmental controls building, pump station bulkheads Change Order #6 Adjustment to pipe alignment to increase slope 1,332.00 Change Order #7 (not likely to occur) Change Order #8 Additional rock to be set aside for future needs Change Order #9 Manhole covers below grade to meet Road Dept requirements 2,486.98 Change Order #10 Modular Block Wall instead of MSE Wall Change Order #11 Upgrade of cables (pump and leachate) Change Order #12 Leachate Line connection from Cell 5 to Cells 3 & 4 Change Order #13 Additional cover material due to settling 55,853.20 Change Order #14 Well modification, flow meter less LFG vaults 5,938.50 Damages Total Contract 2,422,374.74 Amount Paid Through June 30, 2011 2,343,073.99 July 1, 2011 through August 31, 2011 Balance Due 79,300.75 Total of Engineering and Construction Contracts: Original Contracts 2,526,754.13 Change Orders and Damages 212,961.61 Total Contract 2,739,715.74 Amount Paid Through August 31,2011 2,660,414.99 Balance Due 79,300.75 "Cell 5" SW Capital Projects Fund 613 Total 182,516.00 424,385.00 19,656.00 21,500.00 33,431.00 67,747.00 215,947.00 533,288.00 215,947.00 533,288.00 3,290,779.98 5,387,920.48 3,552,521.82 5,837,406.94 45,095.00 45,095.00 14,302.54 24,885.69 32,690.70 148,958.89 148,958.89 1,332.00 204,700.00 204,700.00 2,486.98 5,167.76 5,167.76 2,200.00 2,200.00 6,354.75 6,354.75 55,853.20 5,938.50 ~35,000.00) (35,000.00) 3,929,998.22 6,352,372.95 3,798,516.46 6,141,590.45 131,481.76 210,782.50 3,735,037.82 6,261,791.94 410,907.40 623,869.01 4,145,945.22 6,885,660.95 4,014,463.46 6,674,878.45 131,481.76 210,782.50 - ------------------- ___ Deschutes County General Support Services -BOCC Conference/Seminar, EducationlTraining and Travel Expenditures and BOCC -County College Expenditures FY 2012 ----.--.....-..------------. -.---;-----,-------r----i ~.Q_CC Confere'!~~__~!!_Ci~~~J Jul I Aug IYTD Total Tammy Baney _ __ Conf/S_~m & ~duc~~ain~rl.9. __ ... 665 665 Travel Meals Accommodations 996 996 -c----·-·-------------. ----..------------------. Airfare ~-----------------.------------------------_._-----_._. _ Mileage reimbursement Ground Transport/Parking r---=--------=-.=----------~-_!_~~I._B_a_ne_y__-_--=-:==--:::.:::~:--_:.-.:__.1.,6.6.1_____.1i1,6.6.1~ Alan Unger ______ __ Conf/Sem & EduclTrainin'g 665 665----=---.._------------------_._--.-._--_ .._-------..__. Travel Meals --- ---------------_... --------_. -.----~----------- Accommodations -- 1,131 -. 1,131------_.------------.---_._._-_.... _..._----------- ~~re - - Mileage reimbursement. Ground Transport/Parking ------------------_.. ---. ____~~l!r1..g~______ ___ _ 1,796 1,796 Iony DeBone ____________________________ _ __ Conf/Sem ~~sl':l~~~C!ining__ 665 665 Travel Meals Accommodations 908 908 ---------~--.--------_._ Airfare Mileage reimbursement 300 300 Ground Transport 54 54 .__._----_.--._--==--------=....:... ----=....:.. Total Other 1,573 354 1,927::=-..:=--=-===._---_._----_._._--::------:._-:.--:.-::.----_....... Iotal -BO_CC ,oepartm~"!!____________.___ .___.___._.______ _~onflS~1!I ~EduclT~Jrlin.£L___ _____ 1,33Q... __ 1,995 Travel Meals Accommodations 1,904 3,034 -_._-----------------------"---------------------------------- Airfare ~ _Mileage Reim}~ursem~_rlL___________ _ _ _ _ 300______ 300. Ground Transport 54 54 ----------------_._-- __Total-BOCC Department . ____3,234..___ 35~ ___5,3~ _~£Y-26-12BUdget-.-------·--------'~.~.~_= __-~-~~=~=__f4,750~ - . .---. ---.--.-----------------cc- Percent of FY 2012 Budget Expended 36,5%r------.---. . .--..-.-.-----.--------.------- _BO_C~ County College ________._________________ Public Information --------------_.. __.------_. __ . Office/Copier S...u2plies __________.____ ._. ______.. ________.__ ... _______ Meeting Supplies ----_._--_. _._-_..__._--------------== ---==----'--==== --------------...------------=-=,..-.--=== 9/2/2011 Deschutes County Fair -Fund 619 Revenues and Expenses FAIR 2011 -August 3 to August 7,2011 Fiscal Year 2012 As of September 16, 2011 FY 2012 Budget Actual- Through September 16,2011 Additional Estimated Projected %of Budget Variance REVENUES Gate Receipts 450,000 456,144 456,144 101% 6,144 Carnival 155,000 172,042 172,042 111% 17,042 Commercial Exhibitors: Outside 80,000 72,325 72,325 90% (7,675) Inside 40,000 38,950 38,950 97% (1,050) Food 14,000 13,625 13,625 97% (375) Livestock Entry Fees 3,274 4,635 4,635 142% 1,361 RN Camping/Horse Stall Rental 17,000 15,510 15,510 91% (1,490) Concessions: Food 150,000 83,463 77,207 160,671 107% 10,671 Fair Sponsorship: Rodeo 20,000 17,232 17,232 86% (2,768) On-ground Stages 8,000 4,000 4,000 8,000 100% Day 5,000 0% (5,000) Golf Carts 5,000 5,400 5,400 108% 400 Concert 35,000 37,800 11,460 49,260 141% 14,260 Presenting Sponsors 12,000 0% (12,000) Barn Sponsors 2,000 2,000 First Aid Sponsor 2,500 2,500 2,500 N/A Transfers In 5,000 5,000 5,000 100% State Grant 20,000 49,673 49,673 248% 29,673 a} Interest 285 285 N/A 285 TOTAL REVENUES 1,021,774 930,911 142,340 1,073,252 105% 49,478 EXPENSES Personnel 117,806 80,048 47,250 127,298 108% (9,492) Materials and Services 656,904 708,088 31,226 739,314 113% (82,410) Contingency 33,064 0% 33,064 TOTAL EXPENSES 807,774 788,136 78,476 866,612 107% (58,838) Net Fair 214,000 142,775 63,864 206,639 (9,361) Transfer to Fund 618 220,000 220,000 220,000 Retained in Annual Fair Fund (6,000) 142,775 (156,136) (13,361) (7,361) Beg NWC at January 1,2011 6,000 53,160 53,160 Ending Balance 195,935 (156,136) 39,799 39,799 a) Due to anticipated reductions in State resources, $20,000 was the amount used for budgeting purposes County was notified in June of the actual amount of the grant which will be received December 2011. DESCHUTES COUNTY -ANNUAL FAIR Budgeted and Actual Materials and Services Fair 2011 As of September 16, 2011 FY 2012 Budget Actual -Through September 16, 2011 Additional Estimated Actual (Over)/Under Medical Contract Temporary Help -Office Temporary Help -Labor Transportation Graphic Design Internal Service -Admin Svcs Internal Service -BOCC Internal Service -Finance Internal Service -Legal Internal Service -Personnel Internal Service -IT Internal Service -IT Reserve Food Booth Cash Control Gate Receipts Cash Control Major Entertainment Grounds Entertainment Open Class Rodeo Security Portable Sanitation Grounds Upkeep, Landscape Vehicle & Equipment R & M Equipment Rental Membership & Dues Conferences & Seminars Bank Charges Program expense Insurance Premiums Cellular Announcements Promotion Printing Travel Premiums-Other (Over) / Short Contributions Custodial supplies Equipment R & M Supplies General supplies Office/Copier Postage Queen Court Demo & Program supplies Bldg/Grounds R & M Supplies Safety supplies Shop supplies Software supplies Special Supplies Straw & Hay Vehicle R & M Supplies Electricity Gas/Oil/Diesel Heating Oil/Propane Natural Gas Signage TOTAL 8,000 2,800 9,000 36,000 15,000 4,768 1,951 4,477 7,381 918 16,514 1,947 4,800 17,000 190,000 32,000 27,000 45,000 51,000 3,000 1,200 50,000 1,200 2,000 38,948 1,000 20,000 2,500 4,100 500 12,000 800 1,800 1,200 2,000 3,000 700 7,000 22,000 2,000 700 3,000 700 11,246 1,400 21,364 26,936 4,835 500 3,800 1,555 3,568 5,821 696 11,871 1,381 4,600 23,002 223,186 25,400 29,047 44,831 56,657 2,730 7,238 660 42,384 1,086 1,072 196 368 29,332 836 2,500 21,425 9,245 1,989 20,000 382 13,006 5,483 933 1,981 1,833 284 3,254 3,988 300 327 5,506 280 20,876 4,689 2,012 196 10,000 1,192 488 1,119 1,845 230 4,129 487 9,737 2,000 11,246 (3,245.50) 1,400 1,400.00 21,364 (12,363.68) 26,936 9,063.76 14,835 165.50 500 (500.00) 4,992 (224.49) 2,043 (91.97) 4,687 (210.47) 7,666 (285.47) 926 (7.50) 15,999 514.51 1,868 78.98 4,600 200.00 23,002 (6,002.27) 223,186 (33,186.00) 25,400 6,600.00 29,047 (2,047.00) 44,831 168.80 56,657 (5,656.96) 2,730 270.00 7,238 (6,037.89) 660 (660.00) 42,384 7,615.99 1,086 114.00 1,072 928.00 196 (196.24) 368 (368.00) 39,069 (120.97) 836 164.46 2,500 17,500.00 21,425 (21,424.80) 9,245 (6,745.03) 3,989 110.75 20,000 (20,000.00) 382 117.70 13,006 (13,005.69) 5,483 6,517.40 933 (132.71) 1,981 (1,981.22) 1,833 (32.60) 284 915.57 3,254 (1,254.33) 3,988 (988.33) 300 (300.40) 700.00 327 (327.25) 5,506 1,494.10 280 (280.00) 20,876 1;123.94 4.689 (2,688.73) 700.00 2,012 987.98 196 503.57 656,904 708,088 31,226 739,314 (82,410) "- Deschutes County Fair -Fund 619 Revenues and Expenditures Annual County Fair Fund 619 Cumulative REVENUES: Gate Receipts 300,372 341,755 320,332 331,536 359,202 455,838 458,691 401,040 284,806 403,756 456,144 4.113,472 Entertainment 118,433 127.727 38,787 48,762 30,000 30,000 30,000 31.940 30,000 40,000 49,260 574,909 Carnival 95,211 99,971 92.345 135,412 133,401 157.705 151.784 160,901 127,997 150,939 172.042 1,477,710 Commercial Exhibitors 122,701 110,596 133,254 142.863 143,275 141,500 148,250 163.500 140,995 131,400 124.900 1 ,503.234 Livestock Entry Fees 6,080 7,373 7,502 5,723 5,144 5,114 4,785 5,259 4,951 5,402 4,635 61,968 RV/Camping 6,296 10,095 10,620 13,635 15,689 18,903 20,650 23,429 18,102 15,180 15,510 168,109 Concessions -Food 66,883 95,915 88,961 103,752 127,038 161,516 164,257 178,594 112,931 145,373 160,671 1,405,891 Fair Sponsorship 37,850 78,360 69,342 74,100 87,335 96,855 102,380 72,700 59,675 50,079 35,132 763,808 T-Shirts Sales 3,815 1,569 2,117 5,506 3,867 4,124 3,726 3,725 28,448 State Grant 43,056 40,868 39,200 35,141 46,456 46,456 49,405 49,405 41,963 36,031 49,673 477,652 Interest 1,130 2,471 1,390 1,401 2,756 5,813 9,753 4,645 791 111 285 30,546 Lottery/General Fund Grant 10,528 15.000 5,000 5,000 5,000 7,500 5,000 5,000 5,000 5,000 68,028 Transfer from Reserve Fund 48,000 48,000 Miscellaneous 3,170 2,581 983 1,981 588 105 3 1,229 478 11,118 TOTAL REVENUES 801,181 932,054 819,285 901,423 961,389 1,128,672 1,151,582 1,100,139 832,165 1,031,749 1,073,252 10,732,892 EXPENSES Personnel 39,121 107,624 124,434 134,533 145,642 162,459 171,189 180,655 181,800 145,388 127,298 1,520,143 Materials and Services 544,651 639,523 578,611 558,993 607,253 665,597 697,533 756,660 590,538 672,320 739,314 7,050,993 TOTAL EXPENSES 583,772 747,147 703,045 693,526 752,895 828,055 868,722 937,314 772,338 817,707 866,613 8,571,135 Transfer to Fair & Expo Fund 154,556 172,102 185,000 191,000 204,300 219,000 280,000 250,000 80,000 166,000 220,000 2,121,958 TOTAL EXPENSES & TRANSFERS 738,328 919,249 888,045 884,526 957,195 1,047,055 1,148,722 1,187,314 852,338 983,707 1,086,613 10,693,093 Retained in Annual Fair Fund 62,853 12,805 168,760) 16,897 4,194 81,617 2,860 (87,175) {20,173~ 48,042 !13,361) 39,799 Revenues 801,181 932,054 819,285 901,423 961,389 1,128,672 1,151,582 1,100,139 832,165 1,031,749 1,073,252 10,732,892 Expenses 583,772 747,147 703,045 693,526 752,895 828,055 868,722 937,314 772,338 817,707 866,613 8,571,135 Net Fair 217,409 184,907 116,240 207,897 208,494 300,617 282,860 162,825 59,827 214,042 206,639 2,161,757 9/21/2011 Community Development Department Ptanning 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: Board of County Commissioners From: Tom Anderson, Director Date: September 26,2011 Re: South County Well Test Funding -Groundwater Partnership Fund (296) BACKGROUND The United States Geological Survey (USGS) work with respect to southern Deschutes County groundwater included predictive models which assessed cumulative long term impacts of nitrates entering area groundwater. The models estimated the directional flow and volume of nitrates over time and their potential impacts on area drinking water resources. The data fed into the models was derived from a variety of sources, including samples taken from approximately 130 wells throughout the study area at different times during the course of the work. In order to assess the predictive accuracy of the models as well as update the future estimations of nitrate contamination, the study also recommended that additional well sampling be done in approximately seven to ten year increments. The Advisory Committee working with the Department of Environmental Quality (DEQ) is very interested in a new round of well sampling and has urged DEQ to undertake the work. However, DEQ is under severe budget constraints and has indicated that no funds are currently available. DEQ has prepared a possible well sampling scope of work and believes that a smaller set of well samples of approximately 70 would provide adequate data to accomplish what is required. Total cost of the project, including sample collection, lab analysis and interpretation is estimated at $25,000. COUNTY FUNDING The Groundwater Partnership Fund (296) was created to account for revenues derived from the Newberry Neighborhood in the City of La Pine, including land sales and Pollution Reduction Credit (PRC) assessments. Use of the money is intended to provide financial assistance to area property owners in reducing nitrates entering the groundwater, as well as other projects which would assist in reducing nitrate contamination on a broader level. Over the past several years, in addition to providing low interest loans to homeowners required to install nitrogen reducing Quality Services Performed with Pride septic systems, and issuing cash rebates to those who have done so, Fund resources have been used to help fund a sewer feasibility study in the Sunriver area. In the opinion of staff, well sampling to support an updated assessment of nitrate contamination is therefore an appropriate use of resources from Fund 296. As development within the Newberry Neighborhood has stagnated within the regional slowdown in new home construction, no new monies are accruing to the Fund at the present time, and it is not anticipated that new revenue will be forthcoming in the near future. Thus, in committing resources to well sampling, the Board must understand that funds designated for other purposes, primarily financial assistance, will be reduced. Attachment A provides an analysis of money currently available in Fund 296, and what the impact would be of designating funds for well sampling. The Newberry Neighborhood Fund (297) was created to ensure that the County has adequate resources to meet debt service requirements on bonds that were in part issued to help finance the expansion of the La Pine sewer plant to serve the Newberry Neighborhood. In addition, as capital improvements may be necessary in the future to prepare the Newberry Neighborhood for continued development, Fund 297 also reserves money for this anticipated purpose. However, the Board may choose to transfer funds from Fund 297 to Fund 296 to support well sampling, if it determines that adequate reserves are in place to accomplish the two objectives outlined above. Attachment B provides an analysis of resources currently available in Fund 297. BOARD DIRECTION It is requested that following discussion, the Board provide direction to staff in the use of Fund 296 resources for South County well sampling, either directly from Fund 296 or in combination with Fund 297. Attachment ~ V.2: PRe Purchases & Sunriver FY 2011 SeDt. '11 Feasibility + Well Testing FY 2007 FY 2008 FY 2009 FY 2010 Actual FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Beginning Net Working Capital Transfers In -NPA Land Sales Transfers In -NPA PRC Fallback (1) DEQ loan -SR Feasibility COCIB grant EPA Grant for loan program (2) Interest (3) Total Revenues $ 92,469 359,109 5 1348 456,926 $ 456,926 20,507 477,433 $ 477,433 12,689 490,122 $ 486,556 25,000 5,083 516,639 $ 291,360 40,000 1/49 333,109 $ 224,113 1,250 225,363 $ 81,195 750 81,945 $ 22,745 75,000 250 97,995 $ 13,795 150,000 250 164,045 $ 4,845 250,000 375,000 250 630,095 $ 371,095 380,000 1,000 752,095 PRC Purchases (4) 101,250 48,750 50,000 Direct assist.lloans to prop . owners (5) 60,000 60,000 Sunriver ;{DEQ Loan Payments (6) 246 9,168 Feasibility County payment Sunriver Feasibility (7) 3,566 124,029 Well Sampling -2011 25 ,000 Total Expenditures 3,566 225,279 108,996 144,168 Ending Fund Balance 456,926 477,433 486,556 291,360 224,113 81,195 Notes & Assumptions: (1) Number of PRCs paid for by developer/builder using fallback price of $7,500 (N1/N2): (2) These grant funds specified for loans to property owners. (3) Assumed 1 % interest rate beginning FY 2009 (4) County PRC purchases assumed to decline when NPA developers begin purchasing credits again Number of PRCs purchased by year: 27 in FY 2010,13 in FY 2011,14 in FY 2012, and 7 in 2013. (5) Assumed assistance fund is capitalized using 80% of the fund balance beginning in 2012. FY 2010 & 2011 are capitalized at a flat rate. Number of households served per year at $9,000-$16,000 per upgrade: 4-5 4-5 (6) DEQ Loan assumed terms: 1.25% interest, max repayment period is 5 years (7) The County payment for the Sunriver Feasibility study includes $65,000 granVloan funds and $62,500 of county funds. 25,000 25,000 9,200 59,200 22,745 2-4 75,000 9,200 84,200 13,795 5/5 5-8 150,000 9,200 159,200 4,845 10/10 10-15 250,000 9,000 259,000 371,095 25/25 15-25 750,000 750,000 2,095 25/25 50-75 158 283 Attachment B Sept. '11 Fund 297-New Neighborhood FY 2010 Actual FY 2011 Actual FY 2012 FY 2013 FY2014 FY 2015 FY 2016 FY 2017 Beginning Net Working Capital $ 237,178 $ 443,827 $ 465,878 $ 408,107 $ 349,896 $ 216,043 $ 156,623 $ 71,552 Land Sales -Pahlish Land Sales -LPUSD Sewer SDC's-LBUSD Sewer SDC's-Deschutes Lodge 18,765 171,000 74,100 79,999 350,000 Interest 4,291 3,235 3!550 3!000 2,500 2!000 1,500 750 Total Revenues Bond Debt Service Future Capital Improvements (1) Fees & Permits Transfer to Fund 296 505,334 61,107 400 527,061 61,183 469,428 61,321 411,107 61,321 61,211 352,396 61,353 75,000 218 1043 61,420 508,123 61,571 125,000 250,000 72,302 61,631 Total Expenditures Ending Fund Balance Notes & Assumptions: 61,507 443,827 , 61,183 61,321 61,211 136,353 465,878 408,107 349,896 216,043 (1) Related to New Neighborhood -May include traffic improvements, water/sewer infrastructure, perimeter trail. 61,420 156,623 436,571 71,552 61,631 10,671 Date: September 21, 2011 To: Board of County Commissioners From: Erik Kropp, Interim County Administrator ~ Re: COIC HUD Grant Request work session item Staff from COIC is scheduled to attend your September 26th work session to discuss a HUD Sustainable Communities Regional Planning Grant proposaL COIC is planning to apply for this grant and is asking for the County to join a consortium of local governments and organizations that would be part of the regional planning process. , The grant will request $1 million over a three year period to create a regional plan that: I1. Integrates transportation, economic development and housing; and 2. Establishes a framework to address our most significant regional challenges and to implement high priority regional projects. I Attached is a draft concept paper developed by COIC. I 1 t t ! ~ ; l l I f ! I I I ! Last saved by Scott Aycock at 9/14/20111:32 PM Central Oregon Regional Sustainability Plan Project Synopsis HUD Sustainable Communities Regional Planning Grant August 30, 2011 DRAFT Brief Purpose Statement This project will support the efforts of the Central Oregon Intergovernmental Council, its consortium partners, and other organizations to create a ng framework that integrates regional planning processes into a Region Plan. The Plan will focus on the integration of economic development, and housing, and will incorporate analysis, planning, and action planning implementation. Problem Since 1990, the Central Oregon region has doubling in size from 102,000 to 200,000 attributed to a high quality of life, many .n,.,'",I""_' region transforms from a natural resource and high-tech, entrepreneurial, service region's twO-largest communities capturing economic growth 1'\1""\",1'\"' decades-long economic slump. number of interrelated nrl"\,nl.:o,rn~ I~T.:l,nt"'.:o commuting:• options (e.g. improved , unities. • communities located on US 97, and development and expansion while requirements and Oregon Highway Plan • infrastructure and alignment of technical employment opportunities. • ng to support economic development. • Unem 14.7%, outstrip state and national averages, demonstrating the need for and economic diversification.1 • Energy supply on capacity shortfalls in some communities. • Destination resort which, while providing jobs and public sector incomes, stresses the capacity of rural infrastructure. • Climate change impacts to regional tourism, agriculture, and forestry sectors; stormwater infrastructure impacts; and the potential for climate-induced in-migration. • Water resource allocation conflicts. The region is struggling to effectively address these and a myriad of other problems. Compounding the challenge, state and federal government funding is declining due to the 1 Central Oregon's 2010 unadjusted unemployment rate was 14.7%; Oregon =10.8%; US =9.6% (Oregon Employment Department). Last saved by Scott Aycock at 9/14/20111:32 PM economic downturn and the end of federal stimulus investments, as well as strict limits on the ability of local governments to raise additional funds to fill the gap. The region must now solve complex regional problems with diminishing financial resources. A new approach to planning and regional problem-solving is needed. These problems can be addressed more effectively and efficiently through regional coordination and planning than could be achieved by individual jurisdictions working independently. Oregon Governor John Kitzhaber has stated that "the state can no longer afford single-objective spending. Agency work, investments and projects need to be better integrated and focused on regional priorities. To grow Oregon's economy and create resources in the community- public, private and civic -must join forces to shape the re and to successfully accelerate on-the-ground projects." Furthermore, the Oregon Chapter of the American recently conducted a study of regional planning deficiencies and "Regional Planning for the 21 st Century" (November, 2010). The Central Oregon as having significant regional-scale challenges planning framework to address these challenges. Oregon region wants to comprehensively tackle these challeng .tnnl-=-th.or to coordinate activities. Central Oregon is now at a "tipping framework to identify and implement the weight of its shared nrn,nuornct Regional Problem Over the past 10 neil and its partners have embarked on anum , and problem-solving initiatives that exemplify to develop the new framework, • • - a regional forum for the discussion, understanding, and coordination of transportation issues affecting the Central Oregon region, and to provide feedback and recommendations to the Oregon Transportation Commission. • Central Oregon Health Impact Assessment - a partnership aimed at informing regional policy by providing data on the public health impact of transportation and land use policy scenarios. Economic Development and Public Infrastructure • Central Oregon Comprehensive Economic Development Strategy (CEDS), including: last saved by Scott Aycock at 9/14/20111:32 PM o an inventory of public infrastructure projects necessary for economic development; o long range issues for which collaborative regional action is necessary; o incorporation of all regional economic development strategies to develop integrated economic development goals and strategies; and o inventory of state and federal funding sources. • Food Policy Council - A regional collaborative working to strengthen communities by securing the future of the local food system, including the agricultural sector. • Clean Energy Works Oregon - a residential housing energy efficiency retrofit financing program (launching November 2011) • Regional Rail Plan -The Rail Plan addressed rail safety and congestion issues, freight mobility, and economic (Jel~elj~ornel't in recommendations on a regional railroad crossing strategy and aeC:ISI()I"] process as well as development of a regional prioritized list of ents. • showed that the region currently serves as an integrated, workforce and commercial amenities, and should be its perceived scale in the market. Local governments are now establishing a regional governance str and market large industrial parcels (50+ acres) in the • • is working to meet new through the cooperation users in the basin. • the region's housing authority and a ng regional priorities within their the ing continuum for the individuals and s includes updating the regional housing needs 1ln':=,I'c:.hllnc:. and leveraging resources, and developing o and resources to bridge the gap between today's barriers This includes expanding the portfolio of housing sustainable programs, and advocating needs and highlig • Bend 2030 -Bend was a community visioning process for the community of Bend, the region's traditional principal city. Local and regional partners helped develop the 2030 Vision, which includes the following visions related to housing and regional planning: o "Bend is part of a formal regional planning organization that promotes collaborative dialogue and coordinated planning"; o Bend has small neighborhood centers offering neighborhood commercial services within walking distance of residents; o Bend has pursued mixed-use development" offering residents employment opportunities in close proximity to housing; Last saved by Scott Aycock at 9/14/20111:32 PM o The supply of affordable housing is preserved and enhanced through partnerships; o "Incentive-Based Sustainability" -planning and growth management policies include incentives for developers to incorporate Sustainable Bend principles into all new developments; o Green building standards and practices are institutionalized into policy and code; o Persons with special needs have appropriate, affordable housing options; o Bend continues to develop continuing care facilities for its growing elder population; • Central Oregon 10 Year Plan to End Homelessness - a regional plan put together by the 10 Year Plan Working Group, a coalition of regional officials, social service providers, educational institutions, and other ....."r~.... "" Project Purpose This project will support the efforts of the Central 'nm,~nt'~1 Council, its consortium partners, and other organizations to In".r!:l"'\/~, and action oriented problem-solving framework that i icelsse~s into a Regional Sustainability Plan. This 'framework will i "vision" and performance benchmarks, b) analysis and i and identification of "pressure points" to affect positive change addressed in isolation from each multi-ju making; and d) coordinated .rYl''I.'....YI' sustainable communities. Scope of Work The scope of work will 1. ional jurisdictions, ional livability; the barriers and effect the al Sustainability Plan adopted by the COIC and jurisdictional Comprehensive Plans. 2. The Consortium and partners will begin by Vision, primarily through the process of integrating existing and priorities. For some issues without an existing regional regional energy production and consumption) the consortium will work to ic priorities. This process will recognize that some regional priorities to be oppositional, and consortium partners will work to identify underlying and needs embedded in each priority, articulate tradeoffs, and look for innovative "third way" solutions. The Vision will focus on Economic Development/Employment, Transportation, and Housing, but will articulate and measure the public health, energy consumption/climate change, social equity/justice, and environmental impacts of different scenarios. The Visioning process will utilize the Sustainability Partnership's Livability Principles (http://www.epa.gov/dcedlpartnershipl) as guideposts to regional sustainability. 3. Interdependency Modeling and Analysis. The consortium will hire a consultant with experience helping regions model and analyze interdependencies among housing, economic development, and transportation in order to develop a model for a) last saved by Scott Aycock at 9/14/20111:32 PM understanding the network of interdependencies and tradeoffs. b) predicting change across the three primary issue areas, c) identification of "pressure points" to positively impact multiple factors at once, and d) the identification of key regional priority projects to promote regional sustainability. 4. Action Planning and Implementation. This task involves the development of regional and community-scale partnerships and teams to implement priority projects. These teams will be convened by COIC, other consortium members. or other lead entities as appropriate to the issue and project. The teams will be coordinated by COIC and the COIC Board, and will be charged with busting barriers to success, coordinating and leveraging resources, and ensuring project implementation. 5. Central Oregon Regional Sustainability Plan. The model, visioning, modeling/analysis, priority projects, and i ntation activities will be captured into a Central Oregon Regional .........,....... The Plan will be organized by short-term (1-5 years), medium-term (5-10 long-term (10+ years) strategies and priorities, and will be Consortium members • COIC board (communities) • Bend MPO • Housing Works • Partnership to End Poverty • City of Bend • City of Redmond • Crook, Deschutes, and engagement with other public I I I