The URL can be used to link to this page

2013-36-Minutes for Meeting January 03,2013 Recorded 1/31/2013COUNTY OFFICIAL NANCYUBLANKENSHIP, COUNTY CLERKS Q 41341 COMMISSIONERS' JOURNAL 01/31/2013 08;10;42 AM IIIIIIIIII~IIIIIIIIIIIII I ~II 2013-36 Do not remove this page from original document. Deschutes County Clerk Certificate Page L 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 OF BUDGET MEETING DESCHUTES COUNTY BOARD OF COMMISSIONERS THURSDAY, JANUARY 3, 2013 Allen Room, Deschutes Services Building Present were Commissioners Anthony DeBone, Alan Unger and Tammy Baney. Also present were Tom Anderson, Interim County Administrator; Erik Kropp, Deputy County Administrator; Marty Wynne and Teri Maerki, Finance; Dave Inbody, Administration; Budget Committee members Clay Higuchi, Mike Maier and Bruce Barrett; and for part of the meeting, Scott Johnson of Health Services; Scot Langton, Assessor; and Anna Johnson, Communications. No representatives of the media were in attendance. Mike Maier opened the meeting at 1:30 p.m. Tom Anderson gave an overview of the meeting agenda. He said that one of the biggest issues at this time is the cost of labor, with a 65% increase in PERS and health benefit expenses, and cost of living and merit increases. Marty Wynne talked about general fund numbers. Revenue came in a little higher than anticipated. The main reason for property tax revenue being on target is that they started out being very conservative. This is the main reason for the positive variances the past couple of years. General revenue excluding taxes includes PILT, which has increased. They are unable to get a good answer from the feds whether this is to stay at this level. The Clerk's revenue is higher than the previous year. Room tax and the general fund go towards the Sheriffs Office, and room tax is trending higher. This means that the general fund transfer should be less. Department numbers are coming in as anticipated. Community Development is better than in previous years in most funds. Mr. Anderson said there is an uptick on permits. They have a contract with the City of Sisters and will be working with the City of Bend on inspections. Some laid-off inspectors have remained on call to handle increased volume. They will be cautious about hiring anyone. Minutes of Budget Meeting Thursday, January 3, 2013 Page 1 of 8 Regarding the Health Benefits Trust, Mr. Wynne said the projection is higher than budget for net working capital. The net working capital will be lower than what it started at, but this was done purposely to hold down charges to departments. They budgeted revenue less than expenditures. They need to increase revenue to match expenditures for the year. Mike Maier stated they talked about increasing the amount last year. He asked what I% would do. Mr. Wynne said they may want to do this over a number of years. Mr. Kropp said that EBAC had specific recommendations regarding how the plan can save money. Dave Inbody said employees are notified of the value paid for each employee. Regarding the impact of the DOC clinic and pharmacy, its short-term history shows that it helps with the costs. The one year is pretty comfortable per Commissioner DeBone. Tom Anderson talked about 676, Health Benefits Trust fund, shows charges by department on an employee basis, as projected for this fiscal year. The big unknown is claims in general and when there are some high claims. There is a savings in having the DOC and pharmacy. The increase to departments needs to be set during budget meetings. The proposed 8% increase costs were shown for each department. Mr. Maier said the policy was to have twelve months of premiums or costs on hand. With these projections, this number will not be there. Mr. Wynne said raising rates by 8% will not close this gap but it depends on the amount of claims. Mr. Maier asked if they should aim to be in line with that policy. Discussion was that this probably cannot be done in one year, but there are a lot of variables. It may take three years or more. Mr. Inbody said that taking more from the departments means there will be things they cannot do. The group has to weigh the impacts of having these reserves at the expense of programs. Most plans focus on having three months in place. Nine additional months may offer security for this fund, but in reality, there are impacts to the departments. Mr. Higuchi stated that direct costs for DOC and the pharmacy are hard to measure since it was not in place a few years ago. Chair Unger said that claims amounts seem to be down. Mr. Higuchi said the DOC and pharmacy should be combined. Minutes of Budget Meeting Thursday, January 3, 2013 Page 2 of 8 Mr. Anderson said that it is still less than paying outside vendors. Mr. Wynne stated that there was a savings in pharmacy costs; they might break even this year. Mr. Inbody said that there were start-up costs this year for the pharmacy but those were one-time expenses. Mr. Barrett said that how this is addressed depends on what the final costs are. He wondered if the employee screenings give some kind of indication on how much high-risk there is. Mr. Inbody stated they are tracking those and will have a basis for comparison. Over time, these numbers have gone down, but a year is not a trend. Mr. Barrett suggested they not try to make up more ground than they have to. Mr. Inbody stated there was an incentive for employees to take the HRA last year, and there should be the same for spouses. The number went from 40% to 60% participation. This would be much higher if employees' spouses were involved. Mr. Anderson said they need a clear picture of what one year's expenses are. It is hard when a program is rather new. They can be more accurate once they have better figures, and can move back towards having higher reserves over time. Mr. Wynne said it needs to be not so much based on the dollars, as it is the months. Scot Langton showed a graph showing an example of real market value and assessed value of property. Half of the accounts ended up with a value that was lower than assessed, so there was a minimal increase in value. Redmond showed an 83% decline in value. If an account went below assessed value, revenue went down also. They are on the cusp of a change in the market. Some segments are improving. About 50,000 accounts are in this category and it is hard to determine how much they will change. They have to go through information on subdivisions and areas to make this determination. There is still a lot of uncertainty, so it is hard to project. They look at overall market trends but often have to go through this on an account-by-account basis. He showed information on real estate activity through the Bratton Report. The median home price is increasing per this data, but much depends on the type of property, deferred maintenance and other features. The trend overall is up. There is some new construction adding to growth; about a 23% increase last year over the previous two years. There could be a 3% to b% increase in assessed valuation. A figure of 2.5% of assessed value was used last year, but it came in at I%. Mr. Wynne said using 3% plus new construction might be realistic. Minutes of Budget Meeting Thursday, January 3, 2013 Page 3 of 8 Mr. Wynne said this is only about the current year. Prior year taxes have to do with foreclosures and other aspects. The foreclosures in past years has added to revenue as taxes got paid off. Mr. Anderson talked about COLA's, many of which will be determined through union contracts. Over the last five years, of the rates charged to departments, 5% goes towards the PERS reserve fund, which was built up for four years. With the current increase, using the drawdown scenarios, they have to choose how to pay for the increase from the State. If it stays at a 12.5% rate as it is now for departments, and had the PERS reserve fund of $9.7 million not be in place to absorb the increase, the reserve fund would be gone in a couple of years. If the reserve fund is kept where it is and if they pass the rate on to the departments, the increase for general services would be an increase of 67% in their PERS burden. For example, for the Assessor, it would mean an additional $143,000 in the PERS burden. If they split the difference with the departments and use the reserve fund to pay half, it would mean an increase of 12.5%. Mike Maier said that it has only increased about I% over the past six years. Mr. Higuchi said the County kept costs to departments stable all those years because it was fiscally responsible by setting aside funds for PERS. Mr. Maier asked if this includes any proposed changes by the Governor. Mr. Wynne said they announced rates for two fiscal years. That is based on the valuation ofPERS dollars in the bank and projected liabilities as of 12/31/11. The valuation for the following two years would be based on the valuation and projected liabilities of 12/31/13. The market has not been that great in making up the difference. The Dow shows a 7.5% increase so they may to get to 9% or 10%. Market earnings over that two-year period have to be higher than 16%, or 8% a year. They have said the rates are not fully costed; some costs have been deferred. Whatever changes happen at the Governor's level will be calculated as of 12/31/13. If the market picks up and the liabilities go down, it helps, but it won't make a difference until 2014. If all PERS was added up, it would be about $1 billion. Any loss has a big impact. As bad as things are, Oregon's is the third best rated PERS in the country. Commissioner Baney said that this will have a big impact on education. Minutes of Budget Meeting Thursday, January 3, 2013 Page 4 of 8 Mr. Anderson has advised the departments of this situation, and the majority suggested they split the difference between the fund and the departments. Last year they spent a lot of the reserve fund. Splitting it will have a big drawdown as well. Mr. Maier said the account was established for tough times like this. Mr. Anderson stated that by using part of the reserve fund now, they buy some time to see how the market goes in the future, or whether there is any meaningful PERS reform. Mr. Barrett suggested they do not draw the account down too much. However, this will have an impact on what the departments can do. Mr. Maier would put a ceiling on this and try to string it out. It was intended for this kind of crisis. Mr. Higuchi stated they can make an adjustment next year if things are not improving. They have to decide how much they will have to compromise services. Mr. Maier stated funds can be identified by department. All departments have different abilities to cut services. They should give departments more flexibility. Mr. Higuchi said a good manager will pursue this. Others might depend on the general fund to bail them out if the services are critical. They can choose to use reserves or cut a program or staffing. Mr. Anderson indicated that general fund departments will need to know they can't plan on any more. They will be out of balance with the labor scenario. The department managers will need to decide how to handle it. Commissioner Baney asked about the use of one-time funds. Mr. Kropp stated that there might be capital needs, and it is not sustainable. Mr. Wynne said the bad thing about reserves is keeping rates down at the department level, when eventually they will have to go up. General PERS will go up 67%. Somehow, that has to be met and reserves won't do it. It is not a matter of one year if things don't come back. Chair Unger stated that sharing the cost 50150 with departments still leaves $5 million in reserves after two years, if nothing else changes. Mr. Wynne said that market information will come in at the end of December 2013, and they will have some idea of how the following two years will go. Mr. Higuchi said that the country cannot handle another four years of stagnation. It would be good to have some time to look at this. If the market comes back, they need to keep banking money. Mr. Maier stated he can go with the consensus of the department heads at this point. Minutes of Budget Meeting Thursday, January 3, 2013 Page 5 of 8 Commissioner Baney left the meeting to be present at the retirement ceremony for outgoing Judge Michael Sullivan. Major Budget Issues Interdepartmental Rates - Mr. Anderson said that those providing services will need to increase their fees, but also will need to show how they will try to keep these costs down. Internal service fund departments should not be able to pass on any and all costs to departments without explanation or attempts to control these expenses. Mr. Anderson said that this will be part of the budget process - having the internal services fund departments present their budgets and how they might keep their rates the same. Mr. Wynne stated this is not just expenditures, but can also be based on revenue. The Finance Department is looking at a 5% increase without any changes. Juvenile Justice is going through change, with the work center to be used for this purpose and the current Juvenile facility for part of the adult jail. They will remodel the work center accordingly. There may be significant decreases in this department, although there will be a trade-off. Mr. Maier asked if this change will allow for growth if juvenile detention rates increase. This would mean the same problems as they have with the adult population now, resulting in matrixing. A $3 million expenditure for two years does not make sense otherwise. He asked how much this whole thing is going to cost. Mr. Anderson said there won't be much cost for the jail to expand. Mr. Inbody said the overall changes will cost about $1 million. Commissioner DeBone stated that this should cover needs for a few years. Mr. Anderson said they need to expand the medical side of things there as well. Commissioner Unger stated they hope it can be bonded. Mr. Maier said that once they do all the remodeling, there needs to be a measurable reduction in costs for Juvenile Justice. Mr. Kropp stated that it depends on the layout and what level of staffing is needed. Mr. Anderson said that next year will be a challenge with the Children & Families' Commission, which is losing funding from the State. They are talking about a merger with Health Services to fill in the voids. Mr. Kropp added that there are already fewer positions in the department now. Minutes of Budget Meeting Thursday, January 3, 2013 Page 6 of 8 Mr. Higuchi asked about the Bethlehem Inn and its debt. Someday this fund needs to be replenished. Mr. Wynne said that it was to be funded from a block grant from the federal government and fundraising efforts. However, neither of these materialized, so the only revenue at this time is from lease payments. Commissioner Unger feels that the County should go into the Design Center in Redmond, and with the State lease payments as a tenant there, excess funds can go towards the Bethlehem Inn debt. Teri Maerki went over the budget calendar at this time. Departmental presentations will occur in May. The Committee is supportive of having the same kind of presentations as last year, but would like them to be shorter. Mr. Maier said that the presentation should not be too lengthy so there is time for questions and discussion. Commissioner DeBone asked if there is anything they need to consider now that might be an issue in three to five years, such as equipment or facilities needs. Mr. Anderson said he asked the departments to show their mission and plans for the future. Mr. Barrett said that some department heads will compare what they are doing with what other agencies are doing, as a measurement. Mr. Inbody asked if the presentations should be in any kind of order. Mr. Maier prefers to have similar services present on the same day. Mr. Barrett said that there should be some time allowed between the bigger departments to allow for more discussion. The internal services departments can come during the same timeframe. Mr. Inbody stated that the Board is discussing how to allocate lottery fund dollars and handle community partners. Mr. Maier stated that he does not feel comfortable deciding who gets what. He would like to see all compete on equal footing. The Commissioner on Children & Families used to make these recommendations regarding human services. Mr. Kropp said there are less private and government funds going to the nonprofits. Some have a close working relationship with the Courts and/or the County. Most are worthwhile, but it is hard to decide who gets what when there are limited funds. Minutes of Budget Meeting Thursday, January 3, 2013 Page 7 of 8 Being nofurther discussion, the meeting adjourned at 4:10 p.m. DATED this 5~y Day of 2013 for the Deschutes County Board of Commissio S. alal- LZI~ - Alan Unger, Chair ATTEST: le~- &z6't-- Recording Secretary Tammy Baney, Vice Chair Anthony DeBone, Commissioner Minutes of Budget Meeting Thursday, January 3, 2013 Page 8 of 8 Deschutes County Budget Committee Meeting January 3, 2013 1:30 p.m. - 4:00 p.m. 1) Opening Comments - Tom Anderson 2) Review November Financial Operating Data - Marty Wynne 3) Budget Assumptions • COLAs a. 911-1 (Agreement ended 6/30/2012) b. Deschutes County Sheriff's Employee Association (Agreement ends 6/30/2013) C. AFSCME Min 1.5% Max 3.5% (Agreement ends 6/30/2014) d. IUOE (Public Works) (Agreement ends 6/30/2015) e. F PPO (Agreement ended 6/30/2012) f. Non-represented g. District Attorneys' Association (Agreement ends 6/30/2015) • Health/Dental Insurance Rates • PERS Rates • General Fund 5) Major Budgetary Issues 6) Departmental Presentations 7) Budget Calendar - Teri Maerki 8) Other Revised 12/26/2012 N F u U a ao ti rl N CC V rrµ~VJF~1 o a ~ o a ~ o 0 ~ ~ ~ qC a' ems ' ~ ~ A A w w w Fi d < ' ~R f 0 Q ~ p A ~ a a C1 F ~ F F F F m 3 3 3 .3 3 p x [x l 79 m O [i 14 Q W F r F F e CJ A W F LC. fib., rs iL C Gc a L O pq ~ L (j ~ w O p M w ^9^' v ; V F e b . ~ G b C .b u'. O. p o O O ~ o a a o 3 o a y O p u S b0 O U r> U Q U E E aa X ~ ~ O N fi A Cq V] ¢1 i [7. d ppi]. CL O 8. 49 O O C> C C r, O p a d a d o u'1 yr lj.. dl q7 ^ o o b o 8 a 61 61 61 61 o 0 N 7~i T W _ A y ,C~ b C 7 4 v 'C , G. G _ (x. O M 9 :3 9 LI Memorandum Date: December 20, 2012 To: Board of County Commissioners Tom Anderson, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find November 2012 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 GENERALFUND Statement of Financial Operating Data Five Months Ended November 30, 2012 RESOURCES: Beg. Net Working Capital Revenues Current & Prior Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non-Departmental Contingency Transfers Out TOTAL. REQUIREMENTS NET (Resources - Requirements) Year to Date Budget Actual Variance FY % Coll. $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% Exp. 8,698,817 19,130,655 10,431,838 42% 92% 20,877,160 21,227,160 992,388 1,722,322 729,934 42% 72% a) 2,381,731 2,681,731 311,928 451,977 140,049 42% 60% b) 748,626 748,626 575,010 665,033 90,023 42% 48% 1,380,023 1,470,023 5,166 9,033 3,867 42% 73% b) 12,398 12,398 76,956 48,499 (28,457) 42% 26% 184,694 184,694 82,875 156,039 73,164 42% 78% b) 198,900 198,900 28,500 18,737 (9,763) 42% 27% c) 68,400 68,400 41,352 39,268 (2,084) 42% 40% 99,244 99,244 833 833 0 42% 42% 2,000 2,000 10,813,825 22,242,398 11,428,573 42% 86% 25,953,176 26,693,176 19,513,825 31,301,792 11,787,967 42% 90% 1,486,563 1,387,354 99,209 611,516 584,368 27,148 30,160 23,445 6,715 2,197,778 2,054,007 143,771 347,444 329,138 18,306 108,747 101,427 7,320 113,345 111,060 2,285 50,979 48,979 2,000 714,446 439,903 274,543 3,187, 574 3,187, 574 8,848,552 5,079,681 3,768,871 5,440,272 5,353,309 86,963 14,288,824 10,432,990 3,855,834 5,225,002 20,868,802 15,643,801 FY 2013 Year End $ Bud et Projection Variance $ 8,700,000 $ 9,059,394 $ 359,394 350,000 300,000 90,000 740,000 34,653,176 35,752,570 1,099,394 42% 39% 3,567,752 3,477,752 90,000 42% 40% 1,467,638 1,442,638 25,000 42% 32% 72,385 72,385 - 42% 39% 5,274,667 5,134,667 140,000 42% 39% 833,865 833,865 - 42% 39% 260,992 260,992 - 42% 41% 272,027 272,027 - 42% 40% 122,349 122,349 - 42% 26% d) 1,714,671 1,414,671 300,000 42% n/a 7,650,178 - 7,650,178 42% 24% 21,236,524 13,031,346 8,205,178 42% 41% 13,056,652 13,056,652 - 42% 30% 34,293,176 26,087,998 8,205,178 e) 360,000 9,664,572 9,304,572 a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes two quarters 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 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Bud et Actual Variance FY % Coll. % Bud et 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 2,500 - (2,500) 42% 0% a) 6,000 6,000 - SB #1065-Court Assess. 20,833 13,073 (7,760) 42% 26% 50,000 35,000 (15,000) Discovery Fee 5,417 3,703 (1,714) 42% 28% 13,000 13,000 - Food Subsidy 8,750 9,046 296 42% 43% 21,000 21,000 - OYA Basic & Diversion 156,395 90,993 (65,402) 42% 24% b) 375,347 375,347 - Inmate/Prisoner Housing 25,000 67,800 42,800 42% 113% c) 60,000 145,000 85,000 Inmate Commissary Fees 42 - (42) 42% 0% 100 100 - Contract Payments 50,833 30,981 (19,852) 42% 25% d) 122,000 95,000 (27,000) Miscellaneous 83 - (83) 42% 0% 200 200 - Program Fees 21 - (21) 42% 0% 50 50 - MIP Diversion Fees 417 275 (142) 42% 28% 1,000 1,000 - Interest on Investments 3,333 2,599 (734) 42% 32% 8,000 6,400 (1,600) Leases 500 500 - 42% 42% 1,200 1,200 - Grants - Private 208 866 658 42% 173% c) 500 1,100 600 CFC Interfund Grant 52,359 30,365 (21,994) 42% 24% e) 125,661 125,661 - Interfund Grant - Gen Fund 8,333 5,000 - (3,333) 42% 25% a) 20,000 20,000 - Total Revenues 335,024 255,201 (79,823) 42% 32% 804,058 846,058 42,000 Transfers In-General Fund 2,226,885 2,226,885 - 42% TOTAL RESOURCES 3,572,324 3,477,137 (95,187) 42% REQUIREMENTS: Expenditures Community Justice-Juvenile Personnel Services Materials and Services Capital Outlay Transfers Out Contingency 42% 5,344,523 5,344,523 - 49% 7,158,996 7,185,632 26,636 Exp. 2,114,590 2,062,046 52,544 42% 41% 5,075,017 5,075,017 - 497,483 420,911 76,572 42% 35% 1,193,960 1,193,960 - 42 - 42 42% 0% 100 - 100 21,000 12,600 8,400 42% 25% f) 50,400 50,400 - 349,800 - 349,800 42% n/a 839,519 - 839,519 TOTAL REQUIREMENTS 2,982,915 2,495,556 487,359 42% 35% 7,158,996 6,319,377 839,619 NET (Resources - Requirements) 589,409 981,580 392,171 - 866,255 866,255 a) Grants received quarterly in arrears b) Payments received quarterly c) Revenues trending higher than anticipated - $18,560 billing outstanding d) Contract payment reimbursement requests submitted monthly, receive 1-2 months in arrears e) Grant payments are generated by program activity during the school year and are paid quarterly in arrears f) Transfers out occur quarterly Page 2 SHERIFF - Fund 255 Statement of Financial Operating Data Five Months Ended November 30, 2012 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide terrifltst'41r) La Total Revenues TOTALRESOURCES I Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ - $ - $ - 100% nla $ - $ - $ 9,400,678 7,785,083 (1,6;y1g5,595) 42% 35% " 22,561,626 19,180,094 /(3,t3r81,532) A, ,6 17~ rJ aPeT 42% 35% 144+4 ' je" 1` 4 9 (2,V7 ,7 ) 15,418,050 12,871,419 (2,546,631) 42% 35% 37,003,318 31,542,063 (5,461,255) 15,418,050 12,871,419 (2,546,631) 42% 35% 37,003,318 31,542,063 (5,461,255) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriff's Division 943,179 Civil 332,912 Automotive/Communications 753,104 Investigations/Evidence 628,408 Patrol/Civil/Comm Supp 3,445,566 Records 299,007 Adult Jail 4,309,197 Court Security 126,250 Emergency Services 81,055 Special Services Division 560,849 Regional Work Center 1,109,616 Training Division 210,396 Other Law Enforcement Svcs 268,127 Non-Departmental 35,522 Contingency 2,314,861 TOTAL REQUIREMENTS 15,418,049 Exp.% 956,508 (13,329) 42% 42% a) 2,263,630 2,297,530 (33,900) 284,194 48,718 42% 36% b) 798,989 768,889 30,100 997,955 (244,851) 42% 55% c) 1,807,450 1,807,450 - 610,366 18,042 42% 40% 1,508,180 1,508,080 100 3,275,936 169,630 42% 40% b) 8,269,358 8,219,358 50,000 249,729 49,278 42% 35% 717,617 687,517 30,100 4,214,434 94,763 42% 41% d) 10,342,072 10,563,383 (221,311) 128,375 (2,125) 42% 42% 303,001 302,901 100 76,555 4,500 42% 39% 194,533 194,433 100 552,906 7,943 42% 41% 1,346,037 1,346,037 - 1,034,552 75,064 42% 39% b) 2,663,078 2,612,978 50,100 176,877 33,519 42% 35% 504,950 504,850 100 277,511 (9,384) 42% 43% 643,504 643,404 100 35,522 (0) 42% 42% 85,253 85,253 - - 2,314,861 42% n/a 5,555,666 - 5,555,666 12,871,419 2,546,630 42% 35% 37,003,318 31,542,063 5,461,255 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 $151,340 for six new Correction Technicians and $144,970 for additional bed rental expense. Appropriation will be increased Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Budget Actual Variance I FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $4,507,352 $ 5,883,963 $ 1,376,611 100% 131% $ 4,507,352 $5,883,963 $ 1,376,611 Tax Revenues - Current 6,410,725 14,021,932 7,611,207 42% 91% a) 15,385,740 15,385,740 - Tax Revenues - Prior 183,333 567,791 384,458 42% 129% 440,000 567,791 127,791 Federal Grants & Reimb 12,500 24,510 12,010 42% 82% 30,000 30,000 - State Grant 30,833 66,387 35,554 42% 90% 74,000 74,000 - Transp. of State Wards 2,083 1,056 (1,027) 42% 21% 5,000 5,000 - S61145 616,663 739,996 123,333 42% 50% 1,479,991 1,479,991 - Prisoner Housing 20,833 97,817 76,984 42% 196% b) 50,000 97,817 47,817 Des. Cty Video Lottery Grant 2,083 5,000 2,917 42% 100% 5,000 5,000 - Des Cty Court Security 100,417 100,046 (371) 42% 42% 241,000 241,000 - Des Cty Juvenile Contract 1,742 - (1,742) 42% 0% 4,180 4,180 - Title III Reimbursement - - - 42% n/a c) - 39,916 39,916 Transport 208 919 711 42% 184% 500 1,000 500 Other 1,458 6,500 5,042 42% 186% 3,500 6,500 3,000 DC Fair & Expo Center 1,667 756 (911) 42% 19% 4,000 4,000 - Inmate Commissary Fees 4,167 7,563 3,396 42% 76% 10,000 10,000 - Work Center Work Crews 20,833 22,132 1,299 42% 44% 50,000 50,000 - Concealed Handgun Classes 1,458 2,425 967 42% 69% 3,500 3,500 - Inmate Telephone Fee 33,333 24,315 (9,018) 42% 30% 80,000 80,000 - Soc Sec Incentive-Fed 2,083 6,800 4,717 42% 136% 5,000 6,800 1,800 Miscellaneous 2,083 3,236 1,153 42% 65% 5,000 5,000 - Oregon Mentors 417 - (417) 42% 0% 1,000 1,000 - Debit Card Fee 42 175 133 42% 175% 100 200 100 Medical Services Reimb 5,417 4,422 (995) 42% 34% 13,000 13,000 - Restitution 2,083 - (2,083) 42% 0% 5,000 5,000 Sheriff Fees 104,167 100,811 (3,356) 42% 40% 250,000 250,000 - Interest 11,805 10,835 (970) 42% 38% 28,333 28,333 - Interest on Unsegregated 1,472 1,033 (439) 42% 29% 3,533 3,533 - Donations - "Shop with a Cop" 21,624 35,729 14,105 42% 69% 51,897 51,897 - Sale of Reportable Assets 2,083 574 (1,509) 42% 11% 5,000 5,000 - Total Revenues 7,597,612 15,852,759 8,255,147 42% 87% 18,234,274 18,455,198 220,924 TOTAL RESOURCES 12,104,964 21,736,721 9,631,757 42% 96% 22,741,626 24,339,161 1,597,535 REQUIREMENTS: Exp- Fund 255 Departments: Sheriffs Services 880,524 892,967 (12,444) 42% 42% 2,113,257 2,144,905 (31,648) Civil 332,912 284,194 48,719 42% 36% 798,989 768,889 30,100 Auto/Comm 277,707 367,996 (90,289) 42% 55% 666,497 666,497 - Adult Jail 4,309,197 4,214,434 94,763 42% 41% 10,342,072 10,563,383 (221,311) Court Security 126,250 128,375 (2,125) 42% 42% 303,001 302,901 100 Emergency Services 81,055 76,555 4,500 42% 39% 194,533 194,433 100 Special Services 388,074 382,578 5,496 42% 41% 931,377 931,377 - Work Center 1,109,616 1,034,552 75,064 42% 39% 2,663,078 2,612,978 50,100 Training 128,615 108,125 20,490 42% 35% 308,676 308,615 61 Other (CODE, Forensic) 268,127 277,511 (9,384) 42% 43% 643,504 643,404 100 Non Dept - ISF Charges 17,797 17,797 (0) 42% 42% 42,712 42,712 - Contingency 1,480,804 - 1,480,804 42% n/a 3,553,930 - 3,553,930 Total to Fund 255 9,400,678 7,785,083 1,615,594 22,561,626 19,180,094 3,381,532 Transfer to Reserve Fund (703) 41,667 - 41,667 42% 0% 100,000 100,000 - Non Dept - Comm System Res 33,333 80,000 (46,667) 42% 100% 80,000 80,000 - Total Requirements 9,475,678 7,865,083 1,610,593 42% 35% 22,741,626 19,360,094 3,381,532 Net 2,629,287 13,871,638 11,242,352 - 4,979,067 4,979,067 a) Current year taxes due November, February and May b) Reimbursement from the State will exceed plan due to higher number of SB 395 inmates c) Approved carryover of prior year Title III funds " Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. Page 4 Fund 702 LED Rural Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Budget Actual ( Variance I FY % Coll. % Bud et Projection L Variance RESOURCES: Beg. Net Working Capital $ 2,859,915 $ 3,244,571 $ 384,656 100% 113% $ 2,859,915 $ 3,244,571 $ 384,656 Revenues Tax Revenues - Current 3,145,833 6,826,580 3,680,747 42% 90% a) 7,550,000 7,672,861 122,861 Tax Revenues - Prior 95,833 280,944 185,111 42% 122% 230,000 346,645 116,645 Federal Grants & Reimb 6,250 6,921 671 42% 46% 15,000 15,000 - Federal Grants-BLM 10,833 6,233 (4,601) 42% 24% 26,000 26,000 - US Forest Service 31,250 - (31,250) 42% 0% 75,000 75,000 - Bureau of Reclamation 10,833 9,386 (1,447) 42% 36% 26,000 26,000 - State Grant 78,831 174,383 95,552 42% 92% 189,194 189,194 - SB #1065 Court Assessment 22,917 13,073 (9,844) 42% 24% 55,000 55,000 - Marine Board License Fee 59,205 51,770 (7,435) 42°% 36% 142,091 142,091 - Des Cty General Fund Grant 240,306 - (240,306) 42% 0% b) 576,735 576,735 - Des Cty Transient Room Tax 863,860 863,860 0 42% 42% 2,073,265 2,073,265 - Des Cty Tax Office Contract 208 - (208) 42% 0% 500 500 - City of Sisters 194,983 195,083 100 42% 42% 467,960 467,960 - Des Cty CDD Contract 22,653 22,653 (0) 42% 42% 54,366 54,366 - Des Cty Solid Waste Contr 22,653 22,653 (0) 42% 42% 54,366 54,366 - Des Cty Clerk/Election 417 - (417) 42% 0% 1,000 1,000 - School Districts 16,667 2,758 (13,909) 42% 7% 40,000 40,000 - Claims Reimbursement - 324 324 42% n/a - 324 324 Security & Traffic Reimb 2,083 - (2,083) 42% 0% 5,000 5,000 - Seat Belt Program 4,167 2,345 (1,822) 42% 23% 10,000 10,000 - Miscellaneous 2,500 5,946 3,446 42% 99% 6,000 6,000 - False Alarm Fees 833 2,700 1,867 42% 135% 2,000 4,000 2,000 Restitution 2,083 734 (1,349) 42% 15% 5,000 5,000 - Sheriff Fees 4,167 4,429 262 42% 44% 10,000 10,000 Court Fines & Fees 50,000 48,381 (1,619) 42% 40% 120,000 120,000 Impound Fees 1,667 2,600 933 42% 65% 4,000 4,000 Restitution - Street Crimes 208 - (208) 42% 0% 500 500 Seizure/Forfeiture 417 140 (277) 42% 14% 1,000 1,000 Interest 4,167 4,877 710 42% 49% 10,000 10,000 Interest on Unsegregated 750 505 (245) 42% 28% 1,800 1,800 - Grants-Private - 1,500 1,500 42% n/a - 1,500 1,500 Donations - 4,120 4,120 42% n/a - 4,120 4,120 Sale of Equip & Material 4,167 1,996 (2,171) 42% 20% 10,000 10,000 - Sale of Reportable Assets 16,667 6,817 (9,850) 42% 17% 40,000 40,000 - Total Revenues 4,917,409 8,563,712 3,646,304 50% 73% 11,801,777 12,049,227 247,450 TOTAL RESOURCES 7,777,324 11,808,283 4,030,960 50% 81% 14,661,692 15,293,798 632,106 REQUIREMENTS: ExP. Fund 255 Departments: Sheriff's Services 62,655 63,541 (885) 42% 42% 150,373 152,625 (2,252) Auto/Comm 475,397 629,959 (154,562) 42% 55% 1,140,953 1,140,953 - Investigations 628,408 610,366 18,042 42% 40% 1,508,180 1,508,080 100 Patrol 3,445,566 3,275,936 169,630 42% 40% 8,269,358 8,219,358 50,000 Records 299,007 249,729 49,278 42% 35% 717,617 687,517 30,100 Special Services 172,775 170,328 2,447 42% 41% 414,660 414,660 - Training 81,781 68,752 13,029 42% 35% 196,274 196,235 39 Non Dept - ISF Charges 17,726 17,726 (0) 42% 42% 42,541 42,541 - Contingency 834,057 - 834,057 42% n/a 2,001,736 - 2,001,736 anal t~h t uftd 2 6, 372 338 s 4. X79; 3 Transfer to Reserve Fund (704) 41,667 - 41,667 42% 0% 100,000 100,000 - Non Dept - Comm System Res 50,000 120,000 70,000 42% 100% 120,000 120,000 - Total Requirements 6,109,038 5,206,336 902,702 42% 36% 14,661,692 12,581,969 2,079,723 Net 1,668,285 6,601,946 4,933,661 - 2,711,829 2,711,829 a) Current year taxes due Novem ber, February and May b) Will be received June 2013 Page 5 Payment to Sheriff's Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Five Months Ended November 30, 2012 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 Total Revenues Year to Date LBud2et Actual Variance FY % Coil. % $1,336,051 $ 1,327,199 $ (8,852) 100% 99% 417 8 (409) 42% 1% 1,000 1,000 - - 5,000 5,000 42% n/a - 5,000 5,000 83,333 - (83,333) 42% 0% 200,000 200,000 - 1,214,312 1,041,167 (173,145) 42% 36% 2,914,349 2,934,303 19,954 16,504 8,671 (7,833) 42% 22% a) 39,609 39,609 - 56,142 44,440 (11,702) 42% 33% a) 134,740 134,740 - 261,495 151,804 (109,691) 42% 24% 627,588 627,588 - 147 - (147) 42% n/a 352 352 - 229,167 184,151 (45,016) 42% 33% 550,000 550,000 - 20,000 - (20,000) 42% 0% 48,000 55,200 7,200 38,417 20,936 (17,481) 42% 23% 92,200 92,200 - 43,254 46,140 2,886 42% n/a 103,810 158,354 54,544 - 2,139 2,139 42% n/a - 3,000 3,000 80,500 74,432 (6,068) 42% 39% 193,200 193,200 - 42,958 33,456 (9,502) 42% 32% 103,100 103,100 - 17,083 14,860 (2,223) 42% 36% 41,000 41,000 - 41,667 35,955 (5,712) 42% 36% 100,000 100,000 - 300,021 75,931 (224,090) 42% 11% b) 720,050 720,050 - 5,000 1,995 (3,005) 42% 17% 12,000 12,000 - 2,208 18,931 16,723 42% 357% 5,300 22,277 16,977 66,095 40,901 (25,194) 42% 26% 158,629 158,629 - 333 333 0 42% 42% 800 800 - 2,519,053 1,801,250 (717,803) 42% 30% 6,045,727 6,152,402 106,675 FY 2013 Year End Budget Projection Variance $1,336,051 $1,327,199 $ (8,852) Transfers In-General Fund 978,900 978,900 - 42% 42% 2,349,357 2,349,357 - Transfers In-PH Res Fund 25,057 15,034 (10,023) 42% 25% 60,136 60,136 - Transfers In-Gen. Fund Other 27,125 16,275 10,850 42% 25% 65,100 65,100 - TOTAL RESOURCES 4,886,186 4,138,658 (747,528) 42% 42% 9,856,371 9,954,194 97,823 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 2,680,072 2,580,065 100,007 42% 40% 6,432,172 6,250,000 182,172 888,788 803,336 85,452 42% 38% c) 2,133,090 2,136,883 (3,793) 27,083 - 27,083 42% 0% d) 65,000 - 65,000 65,500 39,300 26,200 42% 25% 157,200 157,200 - 445,379 - 445,379 42% n/a 1,068,909 - 1,068,909 4,106,822 3,422,700 684,122 42% 35% 9,856,371 8,544,083 1,312,288 779,364 715,958 (63,406 - 1,410,111 1,410,111 a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan c) Projection includes grant related expenditures. Appropriation will be increased d) OCHIN System expenditure made in FY 2012 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date - FY 2013 Year End Budget Actual Variance FY -/.T con. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 3,320,968 $ 3,113,095 $ (207,873) 100% 94% $ 3,320,968 $ 3,113,095 $ (207,873) Revenues Marriage Licenses 2,708 2,965 257 42% 46% 6,500 6,500 - Divorce Filing Fees 66,667 51,359 (15,308) 42% 32% 160,000 125,056 (34,944) Domestic Partnership Fee 19 40 21 42% 89% 45 100 55 Federal Grants 105,145 67,702 (37,443) 42% 27% a) 252,349 252,349 - Federal Grant (ARRA) 26,563 - (26,563) 42% 0% 63,750 63,750 - State Grants 3,221,083 3,016,238 (204,845) 42% 39% b) 7,730,599 7,883,477 152,878 State Miscellaneous 25,775 531 (25,244) 42% 1% 61,860 61,860 - Adult Mental Health Initiative 83,333 - (83,333) 42% 0% 200,000 200,000 - Title 19 112,269 71,765 (40,504) 42% 27% 269,446 269,446 - Liquor Revenue 58,958 48,162 (10,796) 42% 34% 141,500 141,500 - School Districts 28,750 10,650 (18,100) 42% 15% c) 69,000 69,000 - Contract Payments - 34 34 42% n/a - 1,000 1,000 Miscellaneous - 4,644 4,644 42% n/a - 5,000 5,000 Patient Insurance Fees 36,472 56,593 20,121 42% 65% 87,532 130,000 42,468 Patient Fees 396 1,002 606 42% 105% 950 1,500 550 Interest on Investments 10,417 8,363 (2,054) 42% 33% 25,000 20,000 (5,000) Rentals 7,708 5,000 (2,708) 42% 27% 18,500 18,500 - Forfeitures - 140 140 42% n/a - 140 140 Administrative Fee 2,205,220 2,171,627 (33,593) 42% 41% 5,292,527 5,292,527 - Interfund Contract-Gen Fund 52,917 38,920 13,997 42% 31% a) 127,000 127,000 - Total Revenues 6,044,400 5,555,733 (486,667) 42% 38% 14,506,558 14,668,705 162,147 Transfers In-General Fund 544,911 544,911 0 42% 42% 1,307,787 1,307,787 - Transfers In-OHP-CDO 201,873 201,873 - 42% 42% 484,494 484,494 - Transfers In-Acute Care Svcs 110,265 110,265 - 42% 42% 264,631 264,631 - Transfers In-ABHA 218,350 218,350 - 42% 42% 524,039 524,039 - TOTAL RESOURCES 10,440,767 9,744,227 (696,540) 42% 48% 20,408,477 20,362,751 (45,726) REQUIREMENTS: ~XP• Expenditures Personnel Services 4,692,633 4,466,090 226,543 42% 40% d) 11,262,320 10,900,000 362,320 Materials and Services 2,747,598 2,077,942 669,656 42% 32% 6,594,235 6,594,235 - Capital Outlay 20,875 14,645 6,230 42% 29% 50,100 15,000 35,100 Transfers Out 85,000 51,000 34,000 42% 25% 204,000 204,000 - Contingency 957,426 - 957,426 42% n/a 2,297,822 - 2,297,822 TOTAL REQUIREMENTS 8,503,532 6,609,677 1,893,855 42% 32% 20,408,477 17,713,235 2,695,242 NET (Resources - Requirements) 1,937,235 3,134,550 1,197,315 - 2,649,516 2,649,516 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 Five Months Ended November 30, 2012 RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range Total Revenues Transfers In General Fund - Gen Ops General Fund - UR Planning A&T Reserve (D/S assistance) Other TOTAL RESOURCES Year to Date =Budet Year End Budget Actual Variance FY % Coll. % Projection Variance $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 9,204 14,274 5,070 42% 65% 22,090 22,090 - 521 355 (166) 42% 28% a) 1,250 1,250 - 69,250 90,735 21,485 42% 55% 166,200 166,200 - 530,656 571,955 41,299 42% 45% 1,273,575 1,273,575 - 106,667 137,035 30,368 42% 54% 256,000 256,000 - 46,500 51,054 4,554 42% 46% 111,600 111,600 - 130,405 132,150 1,745 42% 42% 312,971 312,971 - 265,563 282,089 16,526 42% 44% 637,350 637,350 - 342 94 126,100 31,758 42% 56% 226,421 226,421 - , 1,253,108 1,405,747 152,639 42% 47% 3,007,457 3,007,457 - 356,196 441,604 85,408 42% 52% 854,872 854,872 - 206,400 206,400 - 42% 42% 495,360 495,360 - 37,324 - (37,324) 42% 0% 89,577 89,577 - 42 - ~2) 42% 0% 100 - 100 1,863,070 2,246,233 383,163 42% 50% 4,457,366 4,639,748 182,382 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 563,829 555,170 8,659 Admin-GIS 49,074 47,852 1,222 Admin-Code Enforcement 95,385 88,872 6,513 Building Safety 258,786 254,471 4,315 Electrical 84,680 80,806 3,874 Contract Services 59,060 60,401 (1,341) Env Health-On Site Pgm 66,515 65,605 910 Planning-Current 267,631 237,807 29,824 Planning-Long Range 193,084 178,235 14,849 Transfers Out (D/S Fund) 74,648 170,818 (96,170) Contingency 144,543 - 144,543 TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations Exp. 42% 41% b) 1,353,189 1,311,323 41,866 42% 41% 117,778 117,778 - 42% 39% b) 228,925 216,747 12,178 42% 41% 621,087 621,087 - 42% 40% 203,231 203,231 - 42% 43% 141,745 141,745 - 42% 41% 159,636 159,636 - 42% 37% c) 642,315 634,887 7,428 42% 38% c,d) 463,401 349,567 113,834 42% 95% 179,155 179,155 - 42% n/a 346,904 - 346,904 1,857,235 1,740,037 117,198 42% 39% 5,835 506,196 500,361 1,405, 747 1,740,037 (334,290 4,457,366 3,935,156 522,210 - 704,592 704,592 3,007,457 3,007,457 - 4,457,366 3,935,156 522,210 1,449,909 927,699 522,210 a) Revenue is sporadic throughout the year as GIS services are requested. b) Reflects savings due to CD 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 Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Budget Actual Variance FY % C,11. % Bud et Pro'ection 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 42% n/a - 1,200 1,200 Federal Grant (ARRA) 2,917 - (2,917) 42% 0% 7,000 7,000 - Mineral Lease Royalties 16,667 17,076 409 42% 43% 40,000 40,000 - Forest Receipts 165,344 - (165,344) 42% 0% a) 396,826 396,826 - State Miscellaneous 225,954 542,290 316,336 42% 100% b) 542,290 542,290 - Motor Vehicle Revenue 4,495,851 4,475,216 (20,635) 42% 41% c) 10,790,043 10,450,000 (340,043) City of Bend 10,417 - (10,417) 42% 0% d) 25,000 25,000 - City of Redmond 145,833 10,807 (135,026) 42% 3% d) 350,000 350,000 - City of Sisters 4,167 - (4,167) 42% 0% d) 10,000 10,000 - City of La Pine 4,167 - (4,167) 42% 0% d) 10,000 10,000 - Admin Recovery (SDC) - 1,277 1,277 42% n/a - 2,000 2,000 Miscellaneous 8,333 5,493 (2,840) 42% 27% 20,000 20,000 - Road Vacations 417 - (417) 42% 0% 1,000 1,000 - Interest on Investments 6,250 11,443 5,193 42% 76% 15,000 15,000 - Interlund Contract 287,500 - (287,500) 42% 0% e) 690,000 690,000 - Equipment Repairs 91,667 78,419 (13,248) 42% 36% 220,000 220,000 - Vehicle Repairs 37,500 - (37,500) 42% 0% e) 90,000 90,000 - LID Construction 4,167 - (4,167) 42% 0% e) 10,000 10,000 - Vegetation Management 10,417 - (10,417) 42% 0% e) 25,000 25,000 - Forester 10,417 - (10,417) 42% 0% e) 25,000 25,000 - Car Washes 1,667 862 (805) 42% 22% 4,000 4,000 - Car Rental 417 284 (133) 42% 28% 1,000 1,000 - Sale of Equip & Material 301,500 469,605 168,105 42% 65% 723,600 723,600 - Total Revenues 5,831,569 5,613,927 (217,642) 42% 40% 13,995,759 13,658,916 (336,843) Trans In - Solid Waste 115,113 69,068 (46,045) 42% 25% f) 276,272 276,272 - Trans In - Transp SDC 104,167 62,500 (41,667) 42% 25% f) 250,000 250,000 - Trans In-Road Imp Res 5,000 - 5( 000) 42% 0% 12,000 12,000 - _ TOTAL RESOURCES 10,775,400 10,469,347 (264,386) 42% 56% 19,253,582 18,921,040 (332,542) REQUIREMENTS: Exp. Expenditures Personnel Services 2,235,501 2,256,263 (20,762) 42% 42% g) 5,365,202 5,458,021 (92,819) Materials and Services 3,932,776 3,111,580 821,196 42% 33% h) 9,438,662 9,438,662 - Capital Outlay 848,875 7,726 841,149 42% 0% 2,037,300 2,037,300 - Transfers Out 114,583 - 114,583 42% 0% 275,000 275,000 - Contingency 890,591 - 890,591 42% n/a 2,137,418 - 2,137,418 TOTAL REQUIREMENTS 8,022,326 5,375,569 2,646,757 42% 28% 19,253,582 17,208,983 2,044,599 NET (Resources - Requirements) 2,753,074 5,093,778 2,382,371 - 1,712,057 1,712,057 a) Payment received annually in January b) Payment expected in November 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) Payments made quarterly g) Retro COLA raises for 701 members h\ Fvnnndifi iroc nrn cnncnnn1 nnri hinhcr rlurinn siimmar mnnths Page 9 ADULT PAROLE & PROBATION Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 570,000 $ 630,226 $ 60,226 100% 111% $ 570,000 $ 630,226 $ 60,226 Revenues DOC Measure 57 91,350 219,240 127,890 42% 100% a) 219,240 219,240 - State Miscellaneous 1,792 - (1,792) 42% 0% b) 4,301 4,301 - Alternate Incarceration 6,250 - (6,250) 42% 0% c) 15,000 5,000 (10,000) State Subsidy 5,761 15,415 9,654 42% 111% d) 13,826 21,826 8,000 SB 1145 1,145,232 1,374,277 229,045 42% 50% d) 2,748,556 2,748,556 - Probation Work Crew Fees 9,375 5,908 (3,468) 42% 26% 22,500 14,180 (8,320) Miscellaneous 1,875 2,687 812 42% 60% 4,500 4,500 - Electronic Monitoring Fee 54,167 63,857 9,690 42% 49% 130,000 153,257 23,257 Probation Superv. Fees 79,167 71,825 (7,342) 42% 38% 190,000 172,380 (17,620) Interest on Investments 3,750 2,218 (1,532) 42% 25% 9,000 9,000 - Interfund - Sheriff 20,833 20,833 0 42% 42% 50,000 50,000 - Crime Prevention Grant 20,833 12,500 (8,333) 42% 25% d) 50,000 50,000 - CFC-Domestic Violence 31,180 11,225 19,955 42% 15% d) 74,832 74,832 - Total Revenues 1,471,565 1,799,986 328,421 42% 51% 3,531,755 3,527,072 (4,683) Transfers In-General Fund 181,385 181,385 - 42% 42% 435,328 435,328 - TOTAL RESOURCES 2,222,950 2,611,596 388,646 42% 58% 4,537,083 4,592,626 55,543 REQUIREMENTS: Exp. Expenditures Personnel Services 1,288,038 1,219,533 68,505 42% 39% 3,091,291 3,091,291 - Materials and Services 370,703 326,313 44,390 42% 37% 889,687 889,687 - Capital Outlay 42 - 42 42% 0% 100 - 100 Contingency 231,669 - 231,669 42% n/a 556,005 - 556,005 TOTAL REQUIREMENTS 1,890,452 1,545,846 344,606 42% 34% 4,537,083 3,980,978 556,105 NET (Resources - Requirements) 332,498 1,065,751 733,253 - 611,648 611,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 Five Months Ended November 30, 2012 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart /R-S-G OCCF Grant Charges for Svcs-Mist Program Fees Court Fines & Fees Interest on Investments Grants, Private Interfund Grants Total Revenues Year to Date FY 13 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 511,994 $ 567,120 $ 55,126 100% 111% $ 511,994 $ 567,120 $ 55,126 83,100 66,320 (16,780) 42% 16,472 - (16,472) 42% 35,417 21,456 (13,961) 42% 82,041 - (82,041) 42% 20,051 34,809 14,758 42% 91,646 54,987 (36,659) 42% 174,915 371,636 196,721 42% 3,333 1,166 (2,167) 42% - 4,591 4,591 42% 33,119 30,992 (2,127) 42% 417 1,492 1,075 42% 833 - (833) 42% 133,698 45,000 88,698 42% 675,042 632,448 (42,594) 42% 33% a) 199,441 251,856 52,415 0% 39,533 39,533 - 25% a) 85,000 60,000 (25,000) 0% 196,898 196,898 - 72% b) 48,122 58,022 9,900 25% 219,951 219,951 - 89% a) 419,796 391,940 (27,856) 15% 8,000 4,000 (4,000) n/a - 4,591 4,591 39% C) 79,485 75,034 (4,451) 149% 1,000 5,000 4,000 n/a 2,000 - (2,000) 14% d) 320,874 350,374 29,500 39% 1,620,100 1,657,199 37,099 Trans from General Fund 115,000 115,000 - 42% 42% 275,984 275,984 - Total Transfers In 115,000 115,000 - 42% 42% 275,984 275,984 - TOTAL RESOURCES 1,302,036 1,314,568 12,532 42% 55% 2,408,078 2,500,304 92,226 REQUIREMENTS: Exp. Expenditures Personnel Services 269,781 244,802 24,979 42% 38% e) 647,474 589,457 58,017 Materials and Services 614,999 363,364 251,635 42% 25% f) 1,475,997 1,537,247 (61,250) Capital Outlay 42 - 42 42% 0% 100 - 100 Contingency 118,545 - 118,545 42% n/a 284,507 284,507 TOTAL REQUIREMENTS 1,003,367 608,166 395,201 42% 25% NET (Resources - Requirements) 298,669 706,403 407,734 2,408,078 2,126,704 281,374 - 373,600 373,600 a) Projection based on actual awarded amounts b) Additional GLS grant funds of $3,500 awarded c) State reduced the Circuit Court fees d) Additional grant funds of $17,500 - A & D 70 and $12,000 EUDL projected to be received e) Personnel expenditures projected to be less than appropriated. Open position, due to retirement, will not be filled f) M & S projected to be greater than originally budgeted due to new Federal grant awarded. Appropriation transfer will be requested Page 11 SOLID WASTE Statement of Financial Operating Data Five Months Ended November 30, 2012 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 Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures Personnel Services Materials and Services Debt Service Capital Outlay Transfers Out-Road Trans Out-Capital Res Contingency TOTAL REQUIREMENTS Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 9,167 8,323 (844) 42% 38% 22,000 22,000 - 83,333 14,634 (68,699) 42% 7% a) 200,000 200,000 - 358,333 422,620 64,287 42% 49% 860,000 860,000 - 547,500 628,790 81,290 42% 48% 1,314,000 1,314,000 - 1,666,667 1,775,100 108,433 42% 44% 4,000,000 4,000,000 - 30,417 57,535 27,118 42% 79% b) 73,000 73,000 - 10,417 28,532 18,115 42% 114% c) 25,000 32,000 7,000 3,125 3,444 319 42% 46% 7,500 7,500 - 4,500 5,400 900 42% 50% 10,801 10,801 - 18,750 25,255 6,505 42% 56% 45,000 45,000 - 2,732,209 2,969,632 237,423 42% 45% 6,557,301 6,564,301 7,000 3,432,722 3,777,102 344,380 42% 52% 7,257,814 7,371,771 113,957 Exp. 722,217 690,884 31,333 42% 40% 1,733,321 1,733,321 - 1,245,547 1,002,437 243,110 42% 34% d) 2,989,313 2,989,313 - 394,464 405,589 (11,125) 42% 43% e) 946,713 946,713 - 34,583 241 34,342 42% 0% f) 83,000 83,000 - 115,113 69,068 46,045 42% 25% g) 276,272 276,272 - 262,500 315,000 (52,500) 42% 50% h) 630,000 630,000 - 249,665 - 249,665 42% n/a 599,195 599,195 7,257,814 6,658,619 599,195 3,024,089 2,483,219 540,870 42% 34% NET (Resources - Requirements) 408,633 1,293,884 885,251 713,152 713,152 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) One half of appropriation transferred in September. Balance will be transferred by June 30, 2013 Page 12 RISK MANAGEMENT Statement of Financial Operating Data Five Months Ended November 30, 2012 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 Settlement / 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 / Benefit 5203 Professional Service 5204 Insurance 5205 Loss Prevention 5206 Miscellaneous Total Workers' Compensation 5201 UNEMPLOYMENT - Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personnel Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET a) Annual premium paid in July 2012 Year to Date bro'ection ear End Budget Actual Variance % of FY % Coll. Budget Variance $2,000,000 $2,240,791 $240,791 100% 112% $2,000,000 $2,240,791 $240,791 109,305 109,306 0 130,617 130,617 0 72,348 72,348 (0) 600,073 600,073 0 104,167 104,230 64 208 - (208) 25,000 3,424 (21,576) 833 145 (688) 21 37 16 6,667 6,270 (397) - 30 30 6,250 4,874 (1,376) 21 - (21) 1,055,510 1,031,354 (24,156) 3,055,510 3,272,144 216,634 365,843 35,086 7,610 135,600 6,403 45 200 125,000 550,788 (425,788) 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 42% 0% 42% 6% 42% 7% 42% 74% 42% 39% 42% n/a 42% 32% 42% 0% 42% 41% 42% 72% %E 42% 184% 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 - - 30 30 15,000 15,000 - 50 50 - 2,533,224 2,533,254 30 4,533,224 4,774,045 240,821 a) 300,000 850,000 (550,000) 159,063 a) 5,315 104,167 164,378 (60,211) 42% 66% 366 4,302 11,202 41,667 15,870 25,797 42% 16% 160,540 78,891 23,198 10,776 416,667 273,405 143,262 104,167 50,965 53,202 791,667 1,055,406 (263,739) 128,290 119,691 8,599 70,413 51,391 19,021 42 - 42 198,744 171,082 27,662 3,000 1,800 1,200 993,411 1,228,288 (234,878) 2,062,099 2,043,856 (18,243 250,000 230,000 20,000 100,000 90,000 10,000 a) 42% 27% 1,000,000 900,000 100,000 42% 20% 250,000 230,000 20,000 42% 56% 1,900,000 2,300,000 (400,000) 42% 39% 307,896 307,896 - 42% 30% 168,990 168,990 - 42% 0% 100 - 100 42% 36% 476,986 476,886 100 42% 25% 7,200 7,200 - 42% 52% 2,384,186 2,784,086 (399,900) * 2,149,038 1,989,959 _I159,079 I * Contingency is $2,149,038 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Five Months Ended November 30, 2012 Year to Date FY 2013 Year End Bud et Actual Variance % of FY % Coll. Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 8,000,000 $ 8,883,086 $ 883,086 1009x° 111% $ 8,000,000 $ 8,883,086 $ 883,086 Revenues Property Taxes - Current 2,728,203 5,608,142 2,879,939 42% 86% a) 6,547,687 6,547,687 - Property Taxes - Prior 77,083 222,335 145,252 42% 120% 185,000 222,335 37,335 Federal Grants 100,000 - (100,000) 42% 0% b) 240,000 240,000 - State Reimbursement 15,000 8,458 (6,542) 42% 23% c) 36,000 36,000 - Telephone User Tax 312,500 192,602 (119,898) 42% 26% 750,000 750,000 - Data Network Reimb. 12,500 - (12,500) 42% 0% d) 30,000 30,000 - Jefferson County 12,500 26,787 14,287 42% 89% 30,000 31,262 1,262 User Fee 18,333 2,156 (16,177) 42% 5% e) 44,000 44,000 - Police RMS User Fees 116,229 - (116,229) 42% 0% d) 278,950 278,950 - Contract Payments 12,917 - (12,917) 42% 0% d) 31,000 31,000 - Miscellaneous 3,750 3,650 (100) 42% 41% 9,000 9,000 - Claims Reimbursement - 46,760 46,760 42% n/a f) - 46,760 46,760 Interest 16,667 19,070 2,403 42% 48% 40,000 40,000 - Interest on Unsegregated Tax 250 415 165 42% 69% 600 600 - Total Revenues 3,425,932 6,130,375 2,704,443 42% 75% 8,222,237 8,307,594 85,357 TOTAL RESOURCES 11,425,932 15,013,460 3,587,528 42% 93% 16,222,237 17,190,680 968,443 REQUIREMENTS: % Exp. Expenditures Personnel Services 1,808,538 1,650,505 158,034 42% 38% 4,340,490 3,800,000 540,490 Materials and Services 854,251 845,676 8,575 42% 41% 2,050,202 2,050,202 - Capital Outlay 234,167 - 234,167 42% 0% 562,000 562,000 - Transfers Out-Reserve Fund 208,333 500,000 (291,667) 42% 100% g) 500,000 500,000 - Contingency 3,653,977 - 3,653,977 42% n/a 8,769,545 - 8,769,545 TOTAL REQUIREMENTS 6,759,266 2,996,181 3,763,085 42% 18% 16,222,237 6,912,202 9,310,035 NET (Resources - Requirements) 4,666,666 12,017,279 7,350,613 - 10,278,478 10,278,478 a) Current year taxes due November, February and May b) ODOT Project-reimbursements expected to be received over the next 3-4 months c) Oct/Nov payments outstanding; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance d) Annual billings to Police/Fire agencies to be mailed in December 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 Five Months Ended November 30, 2012 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Addl Prem Employee Prem Contribution COIC Retiree / COBRA Co-Pay Medical Services Reimb Federal Payment (ERRP) Prescription Rebates Claims Reimbursements vending machines (Wellness Rebate) Interest Total Revenues Year to Date FY 20,13 Budget Actual Variance FY % Coll. % Bud et Projection Variance $13,800,000 $14,551,028 S 751,028 100% 105% 513,800,000 $14,551,028 751,028 TOTAL RESOURCES REQUIREMENTS Expenditures: Personnel Services (all depts) Materials & Services Claims Paid-Medical Claims Paid-Prescription Claims Paid-Dental/Vision Claims Refunds Insurance Premiums State Assessments Administration Fee Preferred Provider Fee Health Impact Refund - ERRP Other - Administration Other - Wellness Admin & Wellness Deschutes On-site Clinic Healthstat Medical Supplies Equipment Other Total DOC Deschutes On-site Pharmacy Contracted Services Medication and Drugs Start Up Costs-Take Care Other Total Pharmacy Capital Outlay Contingency 5,331,250 5,337,620 6,370 42% 42% 12,795,000 12,795,000 20,833 13,623 (7,211) 42% 27% 50,000 50,000 262,500 265,460 2,960 42% 42% 630,000 630,000 - 641,667 583,956 42,290 42% 45% 1,300,000 1,385,000 85,000 312,500 356,835 44,335 42% 48% 750,000 900,000 150,000 - 323 323 42% n/a - 323 323 - - 42% Na " - 29,697 29,697 42% n/a 29,697 29,697 50,493 50,493 42% n/a 50,493 50,493 - 105 105 42% n/a 105 105 33,333 32,032 1,301 42% 40% 80,000 80,000 6,502,083 6,670,144 168,060 42% 43% 15,605,000 15,920,618 315,618 20,302,083 21,221,171 919,088 92% 105% 29,405,000 30,471,645 1,066,646 EE 9 83,655 80,820 2,835 42% 40% 200,772 200,772 4,179,250 4,923,281 (744,031) 42% 49% a) 10,030,200 11,636,847 (1,606,647) 801,500 398,981 402,519 42% 21% a) 1,923,600 943,045 980,555 744,250 713,500 30,750 42% 40% a) 1,786,200 1,686,455 99,745 - (46,285) 46,285 42% n/a - (46,285) 46,285 145,833 140,857 4,977 42% 40% 350,000 350,000 - 66,667 89,329 (22,662) 42% 56% 160,000 160,000 133,333 137,684 (4,351) 42% 43% 320,000 320,000 20,833 21,023 (190) 42% 42% 50,000 50,000 22,917 21,658 1,259 42% 39% 55,000 55,000 - 58,552 (58,552) 42% n/a b) - 58,552 (58,552) 27,230 22,033 5,197 42% 34% 65,353 65,353 43,750 8,662 35,088 42% 8% 105,000 105,000 6,185,564 6,489,275 (303,711) 42% 44% 14,845,353 15,383,967 (538,614) 285,000 279,028 5,972 42% 41% c) 684,000 684,000 12,500 5,945 6,555 42% 20% 30,000 30,000 417 369 48 42% 37% 1,000 1,000 8,930 24,789 15,859 42% 116% 21,433 21,433 306,847 310,131 (3,284) 42% 42% 736,433 736,433 128,453 133,223 (4,770) 42% 43% c) 308,287 308,287 41607 528,594 (111,927) 42% 53% c) 1,000,000 1,300,000 (300,000) - 59,898 59,898 42% n/a c) - 59,898 (59,898) 6,900 7,051 _ (152) 42% n/a 16,559 16,559 552,019 728,765 (176,746) 42% n/a 1,324,846 1,684,744 (359,898) 42 - 42 42% n/a 100 - 100 5,123,967 - 5,123,957 42% n/a 12,297,496 - 12,297,496 TOTAL EXPEND/REQUIREMNTS 11,700,064 7,608,991 4,643,092 42% 26% 29,405,000 18,005,915 11,399,085 NET(Resources - Requirements) 8,602,019 13,612,180 5,562,180 12,465,730 12,465,730 Revenues less Expenditures (938,848) (2,085,297) a) Projection based on annualizing 22 weeks of claims paid b) Disallowance of Early Retiree Reinsurance Program items (Reported as revenue in FY 2012) c) YTD Actual include estimates: November Healthstat, July through November Take Care Admin, October & November "ingredient" costs and Start up costs (prior year). These items had not been paid as of November 30, 2012 Pang 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Five Months Ended November 30, 2012 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Annual County Fair (619) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personnel Services Materials and Services Debt Service Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Budget (5/12 of annual) Actual Variance FY % Coll. % Year End FY 2013 Budget Projection Variance $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) 253,158 137,927 (115,231) 42% 23% 607,578 532,505 (75,073) 625 135 (490) 42% 9% 1,500 1,010 (490) 23,934 12,107 (11,827) 42% 21% 57,441 37,548 (19,893) 2,500 - (2,500) 42% 0% 6,000 6,000 - 12,500 16,367 3,867 42% 55% 30,000 46,367 16,367 79,167 50,316 (28,851) 42% 26% 190,000 188,316 (1,684) 39,583 18,000 (21,583) 42% 19% 95,000 97,000 2,000 8,333 1,000 (7,333) 42% 5% 20,000 20,000 - 2,833 958 ,875 42% n/a 6,800 6,058 (742) 422,633 236,810 (185,823) 42% 23% 1,014,319 934,803 (79,516) 70,833 70,835 - 42% 42% 170,000 170,000 - 10,727 10,725 - 42% 42% 25,744 25,744 - 34,500 34,500 - 42% 42% 82,800 82,800 - 110,108 150,000 39,892 42% 57% 264,259 254,259 (10,000) 226,168 266,060 39,892 542,803 532,803 10,000) 695,174 537,925 (157,249) 42% 34% 1,603,495 1,502,661 (100,834) Exp. 346,618 336,976 9,642 42% 41% 831,882 822,268 9,614 210,926 196,622 14,304 42% 39% 506,223 513,080 (6,857) 47,550 70,609 (23,059) 42% 62% 114,119 114,118 1 5,941 9,000 059) 42% 63% 14,259 14,259 - 611,035 613,206 (2,172) 1,466,483 1,463,724 2,759 57,088 - 57,088 42% n/a 137,012 - 137,012 668,123 613,206 54,917 42% 38% 1,603,495 1,463,724 139,771 27,051 (75,282L __[122,332 - 38,937 38,937 Page 16 8 8~~~ ~ 8 8 8 ~ W x x x g Q ti m oC m v~ m u1 A M m m m uNNi . I. rp rA n p ~ ~ OI OI OBI NI V!I hI W nl aII n~ m ~ ~ O F u jM ffi m 3 M 01 mmmmm M cuiuco .1 Xr ~ ae ~ 3e ~ X p~p~~ 7t ~yy ~ ~ ~R a= ~ ae K a~ ~ n Y p Op ppP T m v~i• IiR 4 V m Y N 1~ Q O O O~ o v ae m p ep W M! M1 , 7 C v H ~ Y N a - " - w1 Y Y ~ N ~~yy m N m ^ N P ^ ^ N 4 i.. o vii •c cs m $ ~ w xi n m a v e ~ ~ Fn' S' ~ ~ R rv ~~pp Y_ T h w~ o O r♦ ~i m w ~i r . E n mkt m ^ ~ Y a'rvLL a M p N ^ m N N r A H N w 3e m 't m Q n X0$1 o Y w p IR -R w ep Sri m m N m tl ~i ,wn I ti V .k of of OO W tl 1~ O ~ ~ _ n pf G n o W m m N b m LL e~ N Y Y M M O N N N 8 w A LL ~ ~ p 9 ~ W a ad a'S m N c o a ~ J m sz 2 0 0 -d r-~ is w e e ° p _ v ~ ~ a . ~ ~ ~nw g § _ w U rc~ w_ W n° a V D 4 8 a~ a4 Ss ° ~ c~.~ r°. d y~ w a u 6' Projected HBT Rate Increases by Department (Utilizing FY 2013 FTE) nnual increase per FTE General Fund (001) 02-Assessor 05-Clerk 06-BOPTA 11-District Attorney 18-Tax 23-Veterans'Svcs 25-Property Mgmt 26-Grant Projects General Fund Subtotal FTE (Adjusted) 31.50 8.48 0.52 41.75 5.30 2.75 2.05 1.00 93.35 Scen 4% increase 603.48 19,010 5,118 314 25,195 3,198 1,660 1,237 603 56,335 arios for Incre increase 905.16 28,513 7,676 471 37,790 4,797 2,489 1,856 905 84,497 ase in HBT Charg 8% Increase 1,206.84 38,015 10,234 628 50,386 6,396 3,319 2,474 1,207 112,659 es 10%,Increase~ 1,508.64 47,522 12,793 784 62,986 7,996 4,149 3,093 1,509 140,832 Justice Court (123) 5.00 3,017 4,526 6,034 7,543 Video Lottery (165) 0110 60 91 121 151 Victims' Asst (212) 4.00 2,414 3,621 4,827 6,035 Law Library (215) 0.50 302 453 603 754 Juvenile (230) 53.00 31,984 47,973 63,963 79,958 DC Comm System (245) 1.00 603 905 1,207 1,509 Sheriff's Office Fund (255) 17-SheriffSvcs 10.34 6,240 9,359 12,479 15,599 21-Civil 8.64 5,214 7,821 10,427 13,035 29-Automotive 4.50 2,716 4,073 5,431 6,789 33-Investigations 10.50 6,337 9,504 12,672 15,841 34-Traffic Safety 57.14 34,483 51,721 68,959 86,204 35-Records 8.14 4,912 7,368 9,824 12,280 37-Corrections 77.39 46,703 70,050 93,397 116,754 38-Court Security 2.15 1,297 1,946 2,595 3,244 39-Emergency Svcs 1.20 724 1,086 1,448 1,810 41-Speciol5vcs 6.40 3,862 5,793 7,724 9,655 Q- Work Center 20.00 12,070 18,103 24,137 30,173 43-Training 2.20 1,328 1,991 2,655 3,319 44-Other Low Enforcmnt 4.40 2,655 3,983 5,310 6,638 Sheriff's Office Fund Subtotal 213.00 128,541 192,798 257,058 321,341 Public Health (259) 69.95 42,213 63,316 84;418 105,529 HealthyStart (260) 0.60 362 543 724 905 Behavioral Health (275) 131.20 79,177 118,757 158,337 197,934 CDD (295) 28.50 17,199 25,797 34,395 42,996 GIS Dedicated (305) 3.05 1,841 2,761 3,681 4,601 Road (325) 56.00 33,795 50,689 67,583 84,484 Natural Resource Protection (326) 1.00 603 905 1,207 1,509 Dog Control (350) 0.90 543 815 1,086 1,358 Adult Parole & Probation (355) 32.30 19,492 29,237 38,981 48,729 Children & Families Comm (370) 7.00 4,224 6,336 8,448 10,560 Solid Waste (610) 21.00 12,673 19,008 25,344 31,681 Fair & Expo Center (618) 9.00 5,431 8,146 10,862 13,578 County Fair (619) 1.00 603 905 1,207 1,509 Building Services (620) 23.45 14,152 21,226 28,300 35,378 Admin Svcs (625) 6.40 3,862 5,793 7,724 9,655 BOCC (628) 3.00 1,810 2,715 3,621 4,526 Finance (630) 7.80 4,707 7,060 9,413 11,767 Legal (640) 6.00 3,621 5,431 7,241 9,052 Personnel (650) 6.10 3,681 5,521 7,362 9,203. Information Tech (660) 16.45 9,927 14,890 19,853 24,817 Risk Management (670) 3.25 1,961 2,942 3,922 4,903 HBT(675) 1.90 1,147 1,720 2,293 2,866 Deschutes County 9-1-1(705) 41.50 25,044 37,564 50,084 62,609 Extension/4-H 2.00 1,207 1,810 2,414 3,017 Totals 849.30 512,531 768,751 1,024,972 1,281,289 Projected PERS Increases by Department (Utilizing FY 2013 Subject Wages) 02-Assessor 35,795.15 71,590.30 128,873.87 143,180.60 05-Clerk 10,064.58 20,129.17 36,232.87 40,258.34 08-6000 16,308.40 32,616.79 58,722.37 65,233.59 09-Information Technology 30,544.15 61,088.30 109,969.77 122,176.59 10-Building Services 25,206.45 50,412.91 90,754.04 100,825.81 11-District Attorney 59,863.36 119,734.34 215,546.75 239,461.06 12-Law Library 783.26 1,566.51 2,819.72 3,133.03 14-Finance 23,335.18 46,670.37 84,009.12 93,340.74 15-Children & Fam Comm 7,814.20 15,628.41 28,133.72 31,256.82 16-Juvenile 67,137.99 134,275.98 241,716.67 268,551.96 Sheriff-All Depts 349,108.01 697,725.81 1,256,140.72 1,395,014.40 20-Public Health 71,593.06 143,190.63 257,789.66 286,376.75 22-Behavioral Health 137,882.56 275,765.11 496,468.63 551,530.21 23-Veterans' Svcs 1,824.62 3,649.24 6,570.94 7,298.48 26-Grant Projects 1,675.11 3,350.23 6,030.41 6,700.46 27-Legal Counsel 10,763.77 21,527.55 38,754.44 43,055.10 31-Personnel 11,426.46 22,852.92 41,136.32 45,705.84 36-CDD 40,077.88 80,155.76 144,292,04 160,311.52 50-Road 68,085.66 136,171.32 245,130.61 272,342.64 50-Forester 2,470.61 4,941.24 8,895.79 9,882.46 62-Solid Waste 21,740.64 43,481.28 78,273.79 86,962.56 71-Risk Management 3,737.28 7,474.56 13,454.21 14,949.12 74-Extension/4-H 1,784.14 3,568.27 6,423.60 7,136.54 75- DC 9-1-1 57,805.05 115,610.11 208,118 81 231,220.22 81-Justice Court 5,107.19 10,214.38 18388.35 20,428.75 82-Parole & Probation 41,105.08 82,128.56 147,868.20 164,233.14 96-Fair and Expo 13,176.10 26,352.20 47,436.03 52,704.40 Totals 1,116,215.94 2,231,872.25 4,017,951.45 4,463,271.13 m to r-1 O N G n v a U C ~ O w ❑y N ~ OG ❑ N N N h d 0 to OO1n LLJ CL o a N 00 01 n v 00 O1 N n m N W LID N M N N f0 R w cn r•i .-1 u N 0 N tQ Q O1 001 m m' ti N' r C C N N O M ~ N N ~ 00 n tD n n .••1 O N ' y O Oi f6 n g M 2 v L m o 3 ~~1 v 0 ~ O G U ~ N Wa m .i m a~ t0O N vrnw v 0 aj Ol mmr r q n ~ t ( b O Q N 0 00 N C C Y W N r Q M 00 N' 7 00' 01' to O d I, W O N er 0 7 W n m O ri ri m E U W i tmO r C4 m 0 U, .••1 m 9i Z N O G 0 W W m 0 N O ' j l M 471 r .i (r n W U IL " 0 00 ~ 0 M N 9Q1 m tD CS N 00 ba fr1 m m O r4 n d m W 0 n r o m N N 1 ~ ~ i i yd Ny W ' ( . G fW' OJ .04 M p ~ H Z 0/ a a w ^ ao of tD v V a C4 r4 n n u a a n n y r4 .4 O u O ~ T pp O Q S S O m tri p to D CL E W Y O m 00 N H C? N O 1= a' a .-i m m O H e•i ri N W d CL ai O m u W u iL 2 a to to C u U W a v aL CL 0 a 0 0 w w IL IL tp tT rr~ r ri ko n W1 r•1 L r' n u1 .••1 O N M N' M O r~1 On o m S N N 00 r~ r 0' ti 06 1nv0v 3 N In n m Q v fn n m .4 m O m v v rn It O 0~0 N P, Ono m v ~ rn m rn tD v OD N N 00 -1 d Rt 4o m o0 1n C,r 00 (n mp n ap 0 H O N LO M m0 v N v toN Q1 01 tp W rq N M m V u1 ao N OD to N LO M O1 t0 N O 01 N rn N' r a n 00 0s 00 O N cn m M O n M n m 0o n v fn rM W M ni N tD N r-1 W ri N C N G ~ W `r09 M N 0 O tD n N m 00 V N tD LO N N N N n n n n .-i .4 r-i ri g g g to tD tc to O fr1 00 NO 0m0 M O N N .-1 N a u (U W U in ~LL a W L LL N W c u Cl) U C7 a W •D CL C l7 a Vw1 NA t K IL a 0 0 a a 0 F, iD en S r4 8 rn N 00 rn M n Oo Q rr1 r4 N' l7 H M ~Ntp O QNQ~1 tp 00 00 Ono O in to r N ri w t0 N n m Ln r+ O N m N nl' 2e V 0 M - m ao t0O mm -i :s v to V F, i O rr m OC) N t m w 00 .~•1 N Oi 00 vOM00Is N' O 0 of .4 n 00 tD r-1 v O N d t0 I 1 N cn rn to 4 N rn tD v1 r•1 M rn - Wi 0o rd 00 Ln N in M m 0 N O 01 .-i M N r- ~r 00 M 00 00 lD Q N rn M' fn O N m n m m n v M .4 N li 00 er O r - N M tD 1n In a m <r N N M N tb M Q n 0 d n '!fr"11 M N N'' N .0-1 WMl N Wn'1 m f+m v V N N N N n n n n r.i ri ri ri ggS~ tD tD tD tD OW m W 00 rq O N m m Q N ri .-I N a1 u LL c 01 L, I1 L m ~ c y m u tCU a N p in. Ia.. Q CL a a 0 0 a a (n N O 14 00 n M rI 14 to 000 O n rl N m m n ' (n en r4 r•r N n N d 0o n n n ri N to rn m to v m 3 rnN~~ d v m.Q'Im~m v v m 40 v 0 00 o F'r m a m rn m to 00 N r•1 00 ri 19D' V, Q M 00 n ao 0 ri O N 'It L d' ri N co m 0 rya N (7 0 N ri M ' c6 Mo0 N to M Q1 to N Q 01 -i m N r ~-1 t rn m W' to O N M M' M' Q n m n m 00 n v M N N rl N Im W. 'sn to r v N qr t°n -T a, Ln rri 4 Oq 00 C O tO W N ry N tmD n 0~ rn 0000 N N N N n n n n M W ri ri g g S g Q rn m o .4 ffl m O H H .••1 N N u ~ LL ~ G to LL c u l7 a y ~ a t9 a NA s a ~2 0 Qaa O n 00 M Ln 00 .-1 00 tO ~ m Q tD rf 0 ~ e e~~ 1O 0 •I 0 O M rn -i N' N N N i 0 el' v pp m m op 10c rn tD v o 00 ON 00 m v r 1 01 ~r 0 N ~ 00 0 0 rr l Q m 00 °i n 00 to O N It W ' W ti m rn m u1 ri N m tc Ln -1 ' ' m - Wi 00 M N 00 T N W 01 D N O M 01 r m n r ~r r, 0O01 m 00 W lD Q N M M M' O n m n m ao n v m rl~ -e .4 N ~ tD- 0 N O. v y'y 'N rl w r, ~m 'ONO n d1 A'. W N O N' N N N N N n n n n .4 .4 .-4 H o g g $ %0 tD %0 tD 0! M 00 o r•I mD m O N N N N a u a ` u in 0Y Ln lL N 06 fL u y c y d) U 0 0. y 0 IL O. l9 a COA ON 12 22 0 0 a a d a O O ti e O r I t 41 a d E 4 9 v- 0 q~ O a a a E Q m- 1p ti 9 N a d E O e O 0 r r O ti 0) r O ti CD Nr (c (o C) N m r O rnN " v 0` h N r N CO M M (h C? (fl O (p M Iq co tl0 o co co ~n (o Ci (f1 O (O (~7 L r M M f, M ~ N ( N N fl- N u7 td'] ~0 L ~ rD~ (M~ o 1%10Ar M C4 cr) M r 4 r CA N Cl N O C cM M O N ~ r- Nr LO It M Nr LO r r r O M ~ r r U- N U C C ~ 3 3 N d Q m N W ❑ O .4+ T w to ca ~ cn ~a CO) Ov ca a Wlww G U air W v Y- CL a) U) v C a) Q 0 o c a o c 0 0 0 0 0 0 0) co 0 m 00) C) CD LO d' C) 0 LO ct 00 LO LO C) O IT Q 07 D - ~6 oir r 6a P- ( r 0 0 o d a o o a a p ~ d 0) Lo C) (D o0 - CD C) LO N C) m Ln to 0m V) CD Un cr1 q r- U ) N 0) t75 m Lh -'r c-; N N r r N r r V- r ~ r 0 0 0 0 0 0 n o e o ac C" (S7 cn (D m Uf c) 6 CD tt r'- OD 6 p OD O OD ~ co st a) r rn v r r r 0 0 o a o a o 0 a o o a o c o n' o, o❑ Nr L; I- u°7 v 10 0 6 6 r 4 d? 14 r 6 N' r CMr N C-4 C? T m (D N LC q) (D ~ v (D v 4) N l6 ~ 4) v CD v a) 0) v v m v 0 t3) v m (3) y cn OD CD 4) Co M CD O T t ~ N ~ 7 M r T cc Cb Q Q r 04 ~ >w LL >w ti li N H 'C A 4> U d ea G~ C~ h ~I b a 4 o U ~ pUp ❑U❑ PC' R~~~+" I'y' RCCS' Cl, CC Q Q tC id ~ N ~ N ~ c2 a~ Q d A ~ w c w G w _ ~ a d a d a Q d ~ L1 F o, ~ ~ Q Q A A G~ aC ~ w ~ 3 3 3 3 F L O Q w w CL[] w w F 4 ~ 4 ~ ~ F F F ~ F F F F F w w w 79 ro p c° ~ ~ p F F F v O F w w w w w a 'p C ~ o CJ W c ~ R l~ A O tC b j3 C •t~-L ~ Ul UJ UJ (n ma rte- ^ , y C4 o O ~ ~ E ~ 0. p b~q 20 ~-o O on O v N N U to bbb a j0 00 M r7 w ~ cC v~ m a~, o`er. a m Cq ~ w A 4 Q en 4 In 00 S 4 ~ O r pQ O S S O S Qi o; Mt p b .mr N N] ~ C C C C C C fC 1 'b