The URL can be used to link to this page

2012-118-Minutes for Meeting March 07,2012 Recorded 4/3/2012DESCHUTES COUNTY OFFICIAL RECORDS NANCY BLANKENSHIP, COUNTY CLERK U N1242 CON . H . ISSIO . NER . S - J . OURNAL 04/03/2012 08:17:40 AM 2012-11 Do not remove this page from original document. Deschutes County Clerk Certificate Page Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, MARCH 7,2012 Present were Commissioners Anthony DeBone andAlan Unger; Commissioner Tammy Baney was out of the office. Also present were Erik Kropp, Interim County Administrator; Tanner Wark-, Parole & Probation; Marty Wynne and Chris Edelston, Finance; Sarah Peterson, Children & Families' Commission; Tom Kuhn, Environmental Health; and media representative Hillary Borrud of The Bulletin. Chair DeBone opened the meeting at L-30p.m. 1. Economic Development Loan Fund Request. — Roger Lee, EDCO This item was delayed to an unspecifledfuture date. 2. Finance/Tax Update. Mr. Wynne indicated that overall figures are still better than budgeted. The County is able to sell some old bonds now, and this will save the County at least $100,000. (He referred to the Finance Update document.) Commissioner Unger asked why the County has so much money being held in reserves. Mr. Wynne explained that the Health Benefits Trust is close to $5 0 million, PERS is a big part, there is working capital as required in all 90 funds, and the Solid Waste closure fund. The general fund has about $8 million. It is not money that can be spent easily; there is very little discretion. There is a section in the budget summary that gives the overall picture. PERS estimates that rates will go up within the next two years, perhaps as much as 5%. The percentage of payroll now is about 8%. Statewide, most agencies are already at 12%. Therefore, they may have to use some of the PERS reserves in the future. The State is involved in what is being called 'collaring', which means some expenses have been deferred but eventually need to be covered. Minutes of Board of Commissioners' Work Session Wednesday, March 7, 2012 Page I of 4 Pages Community Development will have a lower net beginning capital. The year-to- date projection indicates that revenues will be over $1 million less than expenditures. This will put some pressure on the general fund. Mr. Kropp said he has been meeting with the department head to review options. There needs to be a general fund transfer and/or service level reductions. Staffing is about as low as it can be without decreasing services. Already $1 million has been transferred in. Mr. Wynne indicated that the discussion has been, after having $5 million in reserves previously, whether that is adequate to build towards in the future. Regarding Parole and Probation, funding is down and this will show itself during the budget process. Solid Waste revenue is down but they have more flexibility with transfers. Mr. Schinike has indicated that he is going to request a rise in tipping fees in two years. Commissioner Unger asked about the Fair & Expo fund. Mr. Wynne said they would be transferring funds out of capital reserves. In regard to the North County Campus, what transpires the next few months regarding the budget and bond issue will relate to the State's decision on the lease. So much is not known at this time. 3. Discussion and Approval of Grant Application — Children & Families' Commission. Sarah Peterson of the Children & Families' Commission and Tanner Wark of Parole & Probation said they are asking for authorization of Interim County Administrator to sign grant applications once the applications are generated. It would be around $300,000. Commissioner Unger stated that these are ongoing programs. Stated that they got a grant for 2010-12, but this is a new program. (See the attached information for details.) Much has to do with domestic violence and supporting the victim. Training was completed, so this will support ongoing Mr. Wark said this enables curfew checks, working with Saving Grace, and the success rate has been around 96%. The violation numbers are up but that is because they are stopping things before they escalate. This helps greatly with domestic violence cases. Minutes of Board of Commissioners' Work Session Wednesday, March 7, 2012 Page 2 of 4 Pages Ms. Peterson added that law enforcement and Saving Grace are providing follow-up to victims, many of which may have never connected with these services. This is a federal grant through the Department of Justice. Commissioner Unger stated that this is a potentially dangerous situation and it makes sense to deal with it at this level. Ms. Peterson said that with the combination of training and the participation of Parole and Probation, it has been successful. UNGER: Move approval of Chair and Interim County Administrator signatures of the MOU and other grant documents. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Chair votes yes. 4. Discussion of Implementation of 1113 2868, Environmental Health Temporary Restaurant License Fees. Chris Edelston and Tom Kuhn explained that historically there have been issues with incensing temporary restaurants at events. Mr. Kuhn said this will reduce staff time, and they can provide an operational review that will help with public health controls and give the owners the ability to stay within these controls. There will be a significant savings to the restaurant owners. For instance, a food vendor at a farmer's market for 90 days would pay $210, with one inspection. Before it could have been up to $960 with inspections every week for 12 weeks. The operational review is more comprehensive. There are a lot of benefits and a whole lot fewer inspections required. Because these are new fees, they can be adapted administratively. If fees were going to be revised, this could only be done through a budget supplement. Mr. Kuhn said that the numbers quoted are those that the State has determined are appropriate. UNGER: Mover approval of the implementation of HB 2868. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Chair votes yes. Minutes of Board of Conunissioners' Work Session Wednesday, March 7, 2012 Page 3 of 4 Pages 5. Request to Apply for Grants to Fund the Community Wildfire Protection Plan. Mr. Kropp stated the County Forester wishes to apply for two grants up to $100,000 each for wildfire protection plans. The grant applications are due by March 9 this year. UNGER: Move approval of applications for the grants. DEBONE: Second. VOTE: UNGER: Yes. DEBONE: Chair votes yes. Mr. Kropp said that the Audit Committee is working on a policy regarding grant applications, to make sure the proper process is being followed. 6. Other Items. None were offered. Being no further discussion, the meeting ended at 2:25p.m. 7 0A DATED this 11�4 -- Day !f 61pta'— 2012 for the Deschutes County Board of Commissioners. ATTEST: fia2�� 6du� Recording Secretary Anthony DeBone, Chair W4^1 U4-t� Alan Unger, Vice Chair — �'"wx Tammy 14�(ney, Coml�issioner Minutes of Board of Commissioners' Work Session Wednesday, March 7, 2012 Page 4 of 4 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., WEDNESDAY, MARCH 7,2012 1. Economic Development Loan Fund Request — Roger Lee, EDCO 2. Finance/Tax Update — Marty Wynne 3. Discussion and Approval of Grant Application — Children & Families' Commission — Hillary Saraceno 4. Discussion of Implementation of H13 2868, Environmental Health Temporary Restaurant License Fees — Health Services Department 5. Request to Apply for Grants to Fund the Community Wildfire Protection Plan — Erik Kropp 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 191660(2) (h), litigation; ORS 192.660(2)(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 of Commissioners'meeting rooms at 1300 NW Wall St., Bend, unless whenvise indicated. Ifyou have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations me wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf hearing impaired or speech disabled, dial 7-1 -1 to access the state transfer relay service for TTY. Please call (541) 389-6571 regarding alternative formats or for further information. CN to cc ro Cli rA Monthly Meeting with Board of Commissioners Finance Director/Treasurer FITCRIT MO, March 7, 2012 (1) Montl-�y Investment Report (2) januaty2012 FmianciL e -.t e'$ s at Q M CD 0; E -00 > 4) 2? -6 E -00 E � 0 6 0 E F3 0 0 w C) C) 0 to 0 E 0 E z LL 0 0 > 0 0 0 U L) C E E e -.t e'$ s at Q M CD 0; E -00 > 4) 2? -6 E -00 E � 0 6 0 E F3 0 0 w C) C) 0 I w E 0 0 CL 'a V Document Reproduces Poorly (Archived) eeeeoee E E IM 0 2 E E El 0 0 0 ::i M �-- 0 C) 5z - . . . . . . . . . ... 0 a� 81� z 000 0 0 1100 u < o 1.0 1 IR To . . . . . . . . . . . . . a 'o E 0 7 LO v > Z S 2 2 IQ! > 0 0 'o o . . . . . . . . . . . co z a-, Iz z 6 CN 00 C-1 1�1 C-1 R> Q < 3: m z > z 'M 0 < 00 < < 0 0 z z Z Z 0 0 < z 0 < D 0 z < 0 < z z z z z z z z z z z z z z z z z z z z z z 7! z z z z < z < > z < z E -E L6 x m m W M E X CD CD 0 (3 0 3 3: 0 0 z x x (D . . . . . . . . . ... 0 a� 81� z 000 0 0 1100 u < o 1.0 1 IR To . . . . . . . . . . . . . a 'o E 0 7 LO v > Z S 2 2 IQ! > 0 0 'o o . . . . . . . . . . . co z a-, Iz z 6 CN 00 C-1 1�1 C-1 R> Q < 3: m z > z .dA, 0 < 00 < < 0 0 z z Z Z 0 0 < z 0 < D 0 z < 0 < z z z z < z < > z < z Of E X CD CD 0 (3 0 3 3: 0 0 z x x (D z z z Z cl ou 0 cl 0 cl 0 U u 0 L) Z m z �6 (o 6 0 > 8 tJ z-, E , - E w w o o w 0 m u 0 �o m m ca w m E m C3 z (-) E u E E 0 0 E 0 z 0 z E 0- Z) D = (.) , m 3: n 0 D 3 c) Memorandum Date: February 15, 2012 To: Board of County Commissioners Erik Kropp, Interim County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find January 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 Seven Months Ended January 31, 2012 a) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823 b) A & T Grant received quarterly -July, October, January & April c) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes three months of receipts) d) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June Page 1 Year to Date Revised YearEnd $ Budget Actual I Variance IFY% I Coll. % Budg Projection Variance RESOURCES: Beg. Net Working Capital $ 7,300,000 $ 8,245,725 $ 945,725 100% 113% $7,300,000 $8,245,725 $ 945,725 Revenues Property Taxes 11,725,564 18,888,201 7,162,637 58% 94% 20,100,967 20,800,967 700,000 Gen. Rev. - excl. Taxes 1,389,687 1,709,524 319,837 58% 72% 2,382,321 2,382,321 - Assessor 461,414 588,620 127,206 58% 74% b) 790,996 790,996 County Clerk 856,746 797,850 (58,896) 58% 54% 1,468,707 1,412,207 (56,500) BOPTA 7,232 11,773 4,541 58% 95% b) 12,398 12,398 District Attorney 174,224 118,292 (55,932) 58% 40% C) 298,669 325,676 27,007 Finance/Tax 113,108 168,600 55,492 58% 87% b) 193,900 193,900 - Veterans 35,782 17,694 (18,089) 58% 29% 61,341 64,351 3,010 Property Management 56,117 57,617 1,500 58% 60% 96,200 96,200 - Grant Projects 1,167 1,167 (0) 58% 68% 2,000 2,000 - Total Revenues 14,821,041 22,359,336 7,538,295 58% 88% 25,407,499 26,081,016 673,517 TOTALRESOURCES ss% 94% 32,707,499 34,326,741 1,619,242 22,121,041 30,605,061 8,484,020 REQUIREMENTS: Ei�g Expenditures Assessor 1,986,425 1,891,346 95,079 58% 56% 3,405,300 3,305,300 100,000 County Clerk 830,646 595,003 235,643 58% 42% 1,423,965 1,223,965 200,000 BOPTA 42,235 31,144 11,091 58% 43% 72,402 72,402 - District Attorney 2,846,256 2,589,516 256,740 58% 53% 4,879,296 4,511,771 367,525 FinancefTax 474,628 464,236 10,392 58% 57% 813,648 813,648 - Veterans 152,900 146,787 6,113 58% 56% 262,115 260,100 2,015 Property Management 150,304 148,293 2,011 58% 58% 257,664 257,664 - Grant Projects 69,250 66,982 2,268 58% 56% 118,715 118,715 Non -Departmental 1,059,895 547,415 512,480 58% 30% d) 1,816,962 1,816,962 - Contingency 3,923,921 3,923,921 58% n/a 6,726,722 - 6,726,722 11,536,460 6,480,722 5,055,738 58% 331/6 19,776,789 12,380,527 7,396,262 Transfers Out 7,542,914 7,464,933 77,981 58% 58% 12,930,710 12,930,710 - TOTAL REQUIREMENTS 19,079,374 13,945,655 5,133,719 sa% 43% 32,707,499 25,311,237 7,396,262 NET (Resoumes - Requirements) 3,041,668 16,659,406 13,617,739 9,015,504 9,015,504 a) Includes annual payments: Tax on Electric Co-ops $489,027, PILT $471,823 b) A & T Grant received quarterly -July, October, January & April c) DA revenue includes: $155,069 HIDTA Grant to be received later in fiscal year and $122,400 Discovery Fee received monthly (YTD actual includes three months of receipts) d) Budget includes $576,144 for payment to LED #2. This payment normally made annually in June Page 1 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -Court Assess. Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous Program Fees MIP Diversion Fees Interest on Investments Leases Grants - Private Behavioral Health CFC Interfund Grant Gen Fund Grant -Crime Prev Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) COMM JUSTICE -JUVENILE Statement of Financial Operating Data Seven Months Ended January 31, 2012 IYear to Date I Budget Actual I Variance __ FFY Coll. % $ 1,101,374 $ 1,099,010 $ (2,364) 100% 100% $ 1,101,374 $ 1,099,010 $ (2,364) 5,833 Year End I (3,733) Budget Projection a) $ 1,101,374 $ 1,099,010 $ (2,364) 5,833 2,100 (3,733) 58% 21% a) 10,000 10,000 - 29,167 28,799 (368) 58% 58% 1,100,000 50,000 50,000 - 8,750 7,729 (1,021) 58% 52% 100 15,000 15,000 - 14,583 12,196 (2,387) 58% 49% b) 25,000 25,000 - 126,874 181,704 54,830 58% 84% c) 217,498 355,730 138,232 51,619 30,100 (21,519) 58% 34% d) 88,490 60,000 (28,490) 58 - (58) 58% 0% 100 100 - 40,833 41,785 952 58% 60% e) 70,000 100,000 30,000 35 301 266 58% 502% f) 60 500 440 23 - (23) 58% n1a 40 40 - 175 715 540 58% 238% f) 300 825 525 4,375 5,048 673 58% 67% 7,500 7,500 - 1,400 800 (600) 58% 33% 2,400 1,200 (1,200) 292 300 8 58% 60% 500 500 3,500 138 (3,362) 58% 2% h) 6,000 331 (5,669) 89,908 71,434 (18,474) 58% 46% i@ 154,128 134,620 (19,508) 11,667 10,000 (1,667) 58% 50% j) 20,000 20,000 - 389,092 393,149 4,057 58% 59% 667,016 781,346 114,330 3,104,185 3,104,185 - 58% 58% 5,321,459 5,321,459 - 4,594,651 4,596,344 1,693 58% 65% 7,089,849 7,201,815 111,966 Ei:� 2,980,290 2,869,169 111,121 58% 56% k) 5,109,069 4,975,000 134,069 697,511 613,347 84,164 58% 51% c)!) 1,195,733 1,100,000 95,733 58 - 58 58% 0% 100 - 100 29,400 25,200 4,200 58% 50% 50,400 50,400 - 428,486 - 428,486 58% n/a 734,547 - 734,547 4,135,745 3,507,716 628,029 581/6 49% 7,089,849 6,125,400 964,449 458,906 1,088,628 629,722 1,076,415 1,076,415 a) Outstanding $2,167 Federal Grant billing, reimbursed quarterly in arrears b) $1,727 billing outstanding c) OYA Basic and Diversion funding increased after budget was submitted. Projections for revenue and expenditures adjusted accordingly. Payments received quarterly, $91,000 billing outstanding d) Fees paid for housing for youth from other jurisdictions, need fluctuates and trending lower than anticipated Billings outstanding - $5,550 e) Contract payments reimbursement requests submitted monthly. Received 1-2 months in arrears, trending higher than anticipated f) Revenues trending greater than anticipated - dependent on use of programs or services (MIP Diversion Fees, photocopies, etc) g) Citizen Review Board vacated. Revenue projected adjusted accordingly h) Due to change in practice, Behavioral Health's referrals for functional family therapy have decreased. Anticipated as permanent i) CCF (JCP) funding less than anticipated. Projections of revenue and expenditures adjusted accordingly j) Grants paid quartedy-$5,000 outstanding payment for General Fund Grant -Crime Prevention Page 2 k) Actual for the year projected to be less than budgeted due to vacant positions SHERIFF - Fund 255 Statement of Financial Operating Data Seven Months Ended January 31, 2012 IYear to Date I Budget Actual I Variance FY % I coil. RESOURCES: Beg. Net Working Capital $ - $ $ Revenues Law Enf Dist Countywide 12,882,812 10,449,235 (2,433,577) Law Erl� 19444 8,428,405 6,753,4W (1,674,V25) Total Revenues 21,311,217 17,202,715 (4,108,502) TOTALRESOURCES 21,311,217 17,202,715 (4,108,502) REQUIREMENTS: Year I a) Budget EXPENDITURES & TRANSFERS 48,000 58% 5 3 QZ' Sheriff's Division 1,507.299 1,414,889 92,410 Civil 480,722 436,384 44,338 Automotive/Communications 946,287 959,512 (13,225) Investigations/Evidence 1,011,627 858,563 153,064 Patrol/Civil/Comrn Supp 4,615,161 4,559,611 55,550 Records 420,414 366,570 53,844 Adult Jail 6,128,807 5,389,586 739,221 Court Security 167,185 163,940 3,245 Emergency Services 108,281 100,101 8,180 Special Services Division 778,844 663,288 115,556 Regional Work Center 1,760,772 1,639,352 121,420 Training Division 189,155 146,456 42,699 Other Law Enforcement Svcs 368,816 361,745 7,071 Non -Departmental 42,718 42,718 - Contingency 2,668,463 - 2,668,463 Transfers Out - DIS Fund 116,667 100,000 16,667 TOTAL REQUIREMENTS 21,311,218 17,202,715 4,108,503 NET (Resources - Requirements) 100% 58% 58% 58% Revised Year I a) Budget Proje 48,000 n/a $ $ $ 47% 470/, 47% 58% 47% 22,084,821 18,925,250 (3,159,571) _14*806 '111[Alr3,404 ;f2,57.5291) 36,533,516 30,798,654 (5,734,862) 36,533,516 30,798,654 (5,734,862) 58% 550/,, a) 2,583,941 2,535,941 48,000 58% 5 3 QZ' b 1 824,095 770,995 53,100 58% 59% c) 1,622,207 1,672,107 (49,900) 58% 500% b) 1,734,218 1,546,664 187,554 58% 58% b 7,911,704 7,848,704 63,000 58% 510% 720,710 704,610 16,100 58% 519% d 10,506,527 9,836,527 670,000 58% 570% 286,602 286,502 100 58% 5 4 0/(� 185,625 185,525 100 58% 50%, 1,335,161 1,335,161 - 58% 54%. b) 3,018,466 2,846,366 172,100 58% 45%. 324,265 324,165 100 58% 5 7 0/1. 632,256 632,156 100 58% 580/o 73,231 73,231 - 58% n/a 4,574,508 - 4,574,508 58% 500/,� e) 200,000 200.000 - 58% 47% 36,533,516 30,798,654 5,734,862 * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Less than planned software maintenance expenditures b) Less than planned personnel expenditures due to open positions which may not be filled c) Fuel expenses will be above plan for the year d) Less than planned personnel expenditures due to open positions, jail bed rental expenses, and jail management software costs e) Semi-annual transfer in November and May Page 3 $ 5,108,671 $6,090,734 $ 982,063 14,306,841 14,627,128 320,287 501,000 516,106 15,106 35,200 35,200 - 48,475 48,475 5,000 5,000 1,537,663 1,479,991 (57,672) - 78,087 78,087 5,000 5,000 - 91,000 91,000 - 4,180 4,180 - 150,000 150,000 - 1,000 1,000 - - 3,570 3,570 3,825 3,826 - 6,600 10,000 3,400 50,000 50,000 - 3,500 3,500 - 48,000 84,000 36,000 5,000 5,000 - 5,000 7,000 2,000 15,000 15,000 - - 100 100 16,000 16,000 - 5,000 5,000 200,000 200,000 - 28,333 42,000 13,667 3,533 3,533 - - 11,972 11,972 1,000 5,817 4,817 17,076,IiO 17,507,484 431,334 22,184,821 23,598,218 1,413,397 2,423,711 2,378,687 45,024 824,095 770,995 53,100 607,014 625,686 (18,672) 10,506,527 9,836,527 670,000 286,602 286,502 100 185,625 185,525 100 928,217 928,217 - 3,018,466 2,846,366 172,100 197,961 197,899 61 632,256 632,156 100 36,689 36,689 - 200,000 200,000 - 2,237,659 - 2,237,659 22,084,821 18,925,250 3,169,571 100,000 100,000 22,184,821 19,025,250 3,159,571 Net . 2,128,613 10,992,867 8,864,254 - 4,572,969 4,572,969 ' Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 c) Reimbursement requested semiannually in January and June d) Change to new vendor resulting in revenue increase a) Accounting change for Shop with a Cop donations Page 4 Year E Fund 701 LED -Countywide Budget Project Statement of Financial Operating Data Seven Months Ended January 31, 2012 Year to Date Budget Actual Varian RESOURCES: Beg. Net Working Capital $5,108,671 $ 6,090,734 $ 982,063 100% 119% Tax Revenues - Current 8,345,657 13,396,849 5,051,192 58% 94% Tax Revenues - Prior 292,250 516,106 223,856 58% 103% Federal Grants & Reimb 20,533 30,784 10,251 58% 87% State Grant 28,277 19,257 (9,020) 58% 40% Transp. of State Wards 2,917 4,686 1,769 58% 94% SB 1146 896,970 1,109,994 213,024 5a% 72% a) Prisoner Housing - 26,492 26,492 58% n/a b) Des. Cty Video Lottery Grant 2,917 5,000 2,083 58% 100% Des Cty Court Security 53,083 52,348 (735) 58% 58% Des Cty Juvenile Contract 2,438 3,224 786 58% 77% Title III Reimbursement 87,500 - (87,500) 58% 0% C) Transport 683 255 (328) 58% 26% Other - 3,570 3,570 58% n/a DC Fair & Expo Center 2,231 - (2,231) 58% 0% Inmate Commissary Fees 3,850 7,065 3,215 58% 107% Work Center Work Crews 29,167 25,665 (3,502) 58% 51% Concealed Handgun Classes 2,042 2,250 208 58% 64% Inmate Telephone Fee 28,000 49,391 21,391 58% 103% d) Soc Sec; Incentive -Fed 2,917 4,600 1,683 58% 92% Miscellaneous 2,917 5,107 2,190 58% 102% Oregon Mentors 8,750 4,300 (4,450) 58% 29% Debit Card Fee - 100 100 58% n/a Medical Services Reimb 9,333 9,197 (136) 58% 57% Restitution 2,917 1,727 (1,190) 58% 35% Sheriff Fees 116,667 127,111 10,444 58% 64% Interest 16,528 27,445 10,917 58% 97% Interest on Unsegregated 2,061 1,057 (1,004) 58% 30% Donations - "Shop with a Cop" - 11,972 11,972 58% n/a a) Sale of Reportable Assets 583 5,817 5,234 58% n/a Total Revenues 9,961,088 15,451,369 5,490,281 58% 90% TOTAL RESOURCES 15,069,759 21,542,103 6,472,344 5a% g7% REQUIREMENTS: [ED Fund 255 Departments: Sheriffs Services 1,413,831 1,327,152 86,680 58% 55% Civil 480,722 436,384 44,338 58% 53% Auto/Comm 354,091 359,040 (4,949) 58% 59% Adult Jail 6,128,807 5,389,586 739,221 58% 51% Court Security 167,185 163,940 3,245 58% 57% Emergency Services 108,281 100,101 8,180 58% 54% Special Services 541,460 461,124 80,336 58% 50% Work Center 1,760,772 1,639,352 121,420 58% 54% Training 115,477 89,410 26,067 58% 45% Other (CODE, Forensic) 368,816 361,745 7,071 58% 57% Non Dept - ISF Charges 21,402 21,402 0 58% 58% Non Dept - Jamison DIS 116,667 100,000 16,667 58% 50% Contingency 1,305,301 - 1,305,301 58% 0% Total to Fund 255 12,882,812 10,449,236 2,433,677 Transfer to Reserve Fund (703) 58,333 100,000 (41,667) 58% 100% Total Requirements 12,941,146 10,549,236 2,391,909 58% 48% $ 5,108,671 $6,090,734 $ 982,063 14,306,841 14,627,128 320,287 501,000 516,106 15,106 35,200 35,200 - 48,475 48,475 5,000 5,000 1,537,663 1,479,991 (57,672) - 78,087 78,087 5,000 5,000 - 91,000 91,000 - 4,180 4,180 - 150,000 150,000 - 1,000 1,000 - - 3,570 3,570 3,825 3,826 - 6,600 10,000 3,400 50,000 50,000 - 3,500 3,500 - 48,000 84,000 36,000 5,000 5,000 - 5,000 7,000 2,000 15,000 15,000 - - 100 100 16,000 16,000 - 5,000 5,000 200,000 200,000 - 28,333 42,000 13,667 3,533 3,533 - - 11,972 11,972 1,000 5,817 4,817 17,076,IiO 17,507,484 431,334 22,184,821 23,598,218 1,413,397 2,423,711 2,378,687 45,024 824,095 770,995 53,100 607,014 625,686 (18,672) 10,506,527 9,836,527 670,000 286,602 286,502 100 185,625 185,525 100 928,217 928,217 - 3,018,466 2,846,366 172,100 197,961 197,899 61 632,256 632,156 100 36,689 36,689 - 200,000 200,000 - 2,237,659 - 2,237,659 22,084,821 18,925,250 3,169,571 100,000 100,000 22,184,821 19,025,250 3,159,571 Net . 2,128,613 10,992,867 8,864,254 - 4,572,969 4,572,969 ' Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 c) Reimbursement requested semiannually in January and June d) Change to new vendor resulting in revenue increase a) Accounting change for Shop with a Cop donations Page 4 Year E Budget Project $ 5,108,671 $6,090,734 $ 982,063 14,306,841 14,627,128 320,287 501,000 516,106 15,106 35,200 35,200 - 48,475 48,475 5,000 5,000 1,537,663 1,479,991 (57,672) - 78,087 78,087 5,000 5,000 - 91,000 91,000 - 4,180 4,180 - 150,000 150,000 - 1,000 1,000 - - 3,570 3,570 3,825 3,826 - 6,600 10,000 3,400 50,000 50,000 - 3,500 3,500 - 48,000 84,000 36,000 5,000 5,000 - 5,000 7,000 2,000 15,000 15,000 - - 100 100 16,000 16,000 - 5,000 5,000 200,000 200,000 - 28,333 42,000 13,667 3,533 3,533 - - 11,972 11,972 1,000 5,817 4,817 17,076,IiO 17,507,484 431,334 22,184,821 23,598,218 1,413,397 2,423,711 2,378,687 45,024 824,095 770,995 53,100 607,014 625,686 (18,672) 10,506,527 9,836,527 670,000 286,602 286,502 100 185,625 185,525 100 928,217 928,217 - 3,018,466 2,846,366 172,100 197,961 197,899 61 632,256 632,156 100 36,689 36,689 - 200,000 200,000 - 2,237,659 - 2,237,659 22,084,821 18,925,250 3,169,571 100,000 100,000 22,184,821 19,025,250 3,159,571 Net . 2,128,613 10,992,867 8,864,254 - 4,572,969 4,572,969 ' Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to countywide services. a) Reduction in State Community Corrections funding for custody of SB 1145 inmates b) Prisoner housing reimbursement SB 395 c) Reimbursement requested semiannually in January and June d) Change to new vendor resulting in revenue increase a) Accounting change for Shop with a Cop donations Page 4 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Federal Grants & Reimb Federal Grarl US Forest Service State Grant SB #1065 Court Assessment Marine Board License Fee Bureau of Reclamation Des Cty General Fund Grant Des Cly Transient Room Tax Des Cty Tax�Fin Contract City of Sisters Des Cty CDD Contract Des Cty Sold Waste Contr Des Cty Clerk/Election School Districts Claims Reimbursement Security & Traffic Reimb Seat Belt Program Miscellaneous False Alarm Fees Restitution Sheriff Fees Court Fines & Fees Impound Fees Restitution - Street Crimes Seizure/Forfeiture Interest Interest on Unsegregated Grants -Private Donations Sale of Equip & Material Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments: Shenfrs Services Auto/Comm Invesfigations Patrol Records Special Services Training Non Dept - iSF Charges Contingency Total tD fund 255 Fund 702 LED Rural Statement of Financial Operating Data Seven Months Ended January 31, 2012 F -year to Date I Budget I Actual _,%T col. % $2,936,523 $3,004,533 $ 68,010 100% 102% $2,936,523 $3,004,533 $ 68,010 4,286,406 Year End I I L Budget Proectimn Variance $2,936,523 $3,004,533 $ 68,010 4,286,406 6,762,236 2,475,830 58% 9 2 7,348,125 7,512,627 164,502 149,917 257,743 107.826 58% 1 o c 257,000 257,743 743 7,000 11,377 4,377 58% 95%. 12,000 12,000 - 14,583 8,873 (5,710) 58% n/a 25,000 25,000 - 45,938 39.375 (6,563) 58% 5o,%, 78,750 78,750 - 117.234 74,437 (42,797) s8% 37'X, 200,972 200,972 - 35.000 28.799 (6,201) 58% 48% 60,000 60.000 - 83,027 - (83,027) 58% 0%, 3) 142,332 142,332 - - 4,189 4,189 58% ink, b ) - 20,000 20.000 336,084 - (336,084) 58% 0 % C) 576,144 576,144 - 1,209,749 1,209,749 - 58% 58% 2,073,856 2,073,856 - - 540 540 58% - 540 540 262,477 262.477 - 58% 58o/c 449,961 449,961 - 31,714 31,714 - 58% 58% 54,366 54.366 - 31,714 31,714 - 58% 58% 54,366 54,366 - 1,167 - (1,167) 58% 0 D/C 2,000 2,000 - 46,667 3,457 (43,210) 58% 4% d 80,000 40.000 (40,000) - 2,750 2,750 58% n1a - 2,750 2,750 2,917 680 (2,237) 58% 14% 5,000 5,000 - 7,000 5,215 (1,785) 58% 43% 12,000 12,000 - 4,667 2,015 (2,652) 58% 25% 8,000 8,000 - 1,167 1.300 133 58% 65% 2,000 2,000 - - 2,069 2,069 58% n/a - 5,000 5,000 5.833 5,187 (646) 58% 52% 10,000 10,000 - 67,083 70,063 2,980 58% 61% 115,000 115,000 - 4,083 2,200 (1,883) 58% 31% 7,000 7,000 - 292 - (292) 58% 0% 500 500 - - 1,324 1,324 58% n1a - 1,324 1,324 5,833 12,358 6,525 58% 124% 10,000 20,000 10,000 1,050 533 (517) 58% 30% 1,800 1.000 (800) - 7,000 7,000 5n% n/a - 7,000 7,000 - 6,555 6,555 58% n1a - 6,555 6,555 3,500 11,354 7,854 58% 189% 6,000 15,000 9,000 11,667 42.177 30,510 58% 211% e) 20,000 50,000 30,000 6,773,769 8,899,460 2,125,691 50% 77% 11,612,172 11,828.786 216,614 9,710,292 11,903,993 2,193,701 50% 82% 14,548,695 14,833,319 284,624 93,468 87,737 5,730 58% 55% 160,230 157,254 2,976 592,196 600,472 (8.276) 5a% 59% 1,015,193 1,046,421 (31,228) 1,011,627 358,563 153,064 58% 50% 1,734,218 1,546.664 187,554 4,615,161 4,559,611 55,550 58% 58% 7,911.704 7,848,704 63,000 420,414 366,570 53,844 5 8 % 51% 720,710 704,610 16,100 237,384 202,164 35,220 58% 50% 406,944 406,944 - 73,678 57,046 16,632 58% 45% 126,304 126,266 39 21,316 21316 - 58% 58% 36,542 36,542 - 1,363,162 - 1,363.162 58% 0% 2,336.849 - 2,336,849 8.428.4D5 6,753,479 1,674.926 14A.48,695 11,873,404 2.575,291 Transfer to Reserve Fund (704) 58,333 100,000 (41,667) 58% 100% 100,000 100,000 - Total Requirements 8,486,739 6.853,479 1,633,259 58% 47% 14,548,695 11,973,404 2,575,291 Net 1.223,553 5,050.514 3,826.960 - 2,859,915 2,859.915 Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services. a) Reimbursement requested semiannually in January and June b) BOR patrol contract signed after budget adopted c) Received annually in June Page 5 dill Reimbursement for SRO deputies will be less than planned trom the Bend La Pine School District e) Proceeds tor sale ot used patrol vehicles higher than planned RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous OMAP Title 19 Family Planning Exp Proj Local Grants Water Program -Base Fee Contract Payments Water Program -Field Work H20 Sys Insp-Priv Wells Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital ReGords-Birth Vital Records -Death Environmental Health Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues PUBLIC HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2012 Year to Date Budget Actual I Variance IFY% I CO.% $1,596,918 $ 1,702,129 $ 105,211 100% 107% $1,596,918 $1,702,129 $ 105,211 350 Year End 111 [Reivised !Bu I Projection 58% $1,596,918 $1,702,129 $ 105,211 350 461 111 58% 77% 58% 600 600 - 1,580,917 1,351,875 (229,042) 58% 50% 30,000 2,710,144 2,729,165 19,021 14,354 15,379 1,025 58% 62% 65,100 24,607 30,759 6,152 131,150 64,074 (67,076) 58% 28% a)b) 224,829 127,000 (97,829) 305,579 336,922 31,343 58% 64% 4,664,723 523,850 523,850 - - 352 352 58% n/a 871,630 - 500 500 303,333 277,911 (25,422) 58% 53% 520,000 520,000 - 26,250 50,627 24,377 58% 113% 45,000 53,000 8,000 24,500 18,772 (5,728) 58% 45% a) 42,000 42,000 - - 25,000 25,000 58% n/a - 25,000 25,000 32,560 23,675 (8,885) 58% 42% a) 55,817 55,817 - 117 - (117) 58% 0% 200 200 - - 3,740 3,740 58% n1a - 7,000 7,000 78,972 97,309 18,337 58% 72% 135,380 135,380 - 69,283 55,061 (14,222) 58% 46% 118,770 118,770 - 17,850 23,925 6,075 58% 78% 30,600 30,600 - 58,333 54,365 (3,968) 58% 54% 100,000 100,000 - 410,871 639,784 228,913 58% 91% c) 704,350 704,350 - 7,000 6,205 (795) 58% 52% 12,000 12,000 - 15,184 9,102 (6,082) 58% 35% 26,030 15,000 (11,030) 115,726 36,706 (79,020) 58% 19% a) 198,387 153,200 (45,187) 8,783 8,783 - 58% 58% 15,056 15,056 3,201,112 3,100,028 (101,084) 58% 561/6 5,487,620 5,399,247 (88,373) Transfers In -General Fund 1,352,029 1,352,029 - 58% 58% 2,317,765 2,317,765 Transfers In -PH Res Fund 17,500 15,000 (2,500) 58% 50% 30,000 30,000 Transfers In -Gen. Fund Other 37,975 32,550 (5,425) 58% 50% 65,100 65,100 TOTALRESOURCES 6,205,534 6,201,736 (3,798) 58% 65% 9,497,403 9,514,241 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) EiE 16,838 3,630,948 3,502,191 128,757 58% 56% 6,224,483 6,100,000 124,483 1,1 112�238 1,019,532 92,706 58% 53% 1,906,694 1,800,000 106,694 116,667 - 116,667 58% 0% 200,000 100,000 100,000 166,833 143,000 23,833 58% 500% 286,000 286,000 - 513,465 - 513,465 58% n/a 880,226 - 880,226 5,540,151 4,664,723 875,428 53% 49% 9,497,403 8,286,000 1,211,403 665,383 1,537,013 871,630 . 1,228,241 1,228,241 a) Received quarterly, in arrears b) Elimination of the State self sufficiency program c) Line includes, among other items, 1) Restaurant Fees (FY 2012 Budget=$450,000) and 2) Pool & Spa Fee (FY 2012 Budgei 10,000). These are due annually and collected primarily in December and January Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Seven Months Ended January 31, 2012 Total Revenues 7,414,640 7,689,874 275,234 58% 60% Revised YearEnd Year to Date Budget I Projection � Variance 100 Budget Actual Variance FY % Coll. % 6,964,202 RESOURCES: 602,534 124,173 61,860 (62,313) - 170,000 Beg. Not Working Capital $3,268,759 $ 3,108,163 $ (160,596) 100% 95% 36,500 Revenues 75,600 - 14,000 14,000 113,700 Marriage Licenses 3,208 3,500 292 58% 64% 26,700 Divorce Filing Fees 77,583 90,354 12,771 58% 68% 200 Domestic Partnership Fee 58 55 (3) 58% 55% 127,000 Federal Grants 161,377 99,202 (62,175) 58% 36% State Grants 4,062,451 4,428,314 365,863 58% 64% a) State Miscellaneous 72,434 10,310 (62,124) 58% 8% b)c) ABHA - 163,569 163,569 58% n/a d) Title 19 164,673 87,596 (77,077) 58% 31% Liquor Revenue 61,250 82,505 21,255 58% 79% School Districts 44,100 45,200 1,100 58% 60% Miscellaneous 8,167 8,059 (108) 58% 58% Patient Insurance Fees 66,325 53,016 (13,309) 58% 47% Patient Fees 1,054 657 (397) 58% 36% Interest on Investments 14,583 15,521 938 58% 62% Rentals 7,642 5,625 (2,017) 58% 43% b) Donations - 108 108 58% n/a Administrative Fee 2,583,985 2,558,271 (25,714) 58% 68% Sheriff 11,667 - (11,667) 58% 0% e) Interfund Contract -Gen Fund 74,083 37,287 (36,796) 58% 29% b) Comm. on Children & Fam - 725 725 58% n1a Total Revenues 7,414,640 7,689,874 275,234 58% 60% Revised YearEnd 2,500 Budget I Projection � Variance $ 3,268,759 $ 3,108,163 $ (160,596) 5,500 8,000 2,500 133,000 150,000 17,000 100 100 - 276,647 276,647 - 6,964,202 7,566,736 602,534 124,173 61,860 (62,313) - 170,000 170,000 282,297 200,000 (82,297) 105,000 141,500 36,500 75,600 75,600 - 14,000 14,000 113,700 100,000 (13,700) 1,807 1,150 (657) 25,000 26,700 1,700 13,100 13,100 - - 200 200 4,429,689 4,429,689 - 20,000 - (20,000) 127,000 127,000 - - 725 725 12,710,815 13,363,007 652,192 Transfers In -General Fund 737,051 737,051 - 58% 58% 1,263,515 1,263,515 - Transfers In-OHP-CDO 158,318 158,319 - 58% 58% 271.402 396,077 124,675 Transfers In -Acute Care Svcs 147,301 147,301 - 58% 58% 252,515 252,515 - Transfers In-ABHA 175,503 150,432 (25,071) 58% 50% 1]1 300,863 387,473 86,610 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resi:iurces - Requirements) 11,901,572 1111,9911,`140 89,567 58% 661% [E] 5,771,611 5,411,615 359,996 58% 55% 3,302,104 3,071,297 230,807 58% 54% 242,083 63,199 178,8B4 58% 15% 166,833 143,000 23,833 58% 50% 1,056,959 - 1,056,959 58% n1a 10,539,590 8,689,111 1,850,479 58% 48% 1,361,982 3,302,029 1,940,046_ a) Department of Human Services Grant projected at amended contract amount b) Received quarterly, in arrears c) Elimination of State contract for Temporary Assistance for Needy Families (TANF) program d) Revenue for Adult Mental Health Initiative clients, not included in original budget e) Funding for Mental Health Court from the Sheriffs Department eliminated f) Transfer made quarterly 118,067,869 18,770,750 702,881 9,894,191 9,483,681 410,510 5,660,749 5,265,100 395,649 415,000 415,000 - 286,000 286,000 - 1,811,929 - 1,811,929 18,067,869 15,449,781 2,618,088 - 3,320,969 3,320,969 Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Seven Months Ended January 31, 2012 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 823,561 Year to Date 9,289 Admin -GIS 74,524 70,301 Year Admin -Code Enforcement 119,333 Bud2et Actual Building Safety FY % Col. % 3,458 Budget Proje 131,000 RESOURCES: Contract Services 96,652 103,084 (6,432) Env Health -On Site Pgm 83,480 88,997 (5,517) Planning -Current Beg. Net Working Capital $ 229,822 131,776 $ (98,046) 100% 57% 22,633 $ 229,822 $ 131,776 (98,046) Revenues Contingency 147,075 - 147,075 619,002 600,000 19,002 58% Admin -Operations 14,204 16,612 2,408 58% 68% 92% 24,350 24,790 440 Admin -GIS 583 1,207 624 58% 121% a) 1,000 1,850 850 Admin -Code Enforcement 97,242 97,286 44 58% 58% 166,700 166,200 (500) Building Safety 700,513 551,738 (148,775) 58% 46% b) 1,200,880 1,090,575 (110,305) Electrical 151,171 130,226 (20,945) 68% 50% b) 259,150 225,800 (33,350) Contract Services 93,450 54,374 (39,076) 58% 34% c) 160,200 130,200 (30,000) Env Health -On Site Prog 163,567 164,759 1,192 58% 59% 280,400 298,700 18,300 Planning -Current 393,692 351,290 (42,402) 58% 52% b) 674,900 625,550 (49,350) Planning -Long Range 148,007 134,589 (13,418) 58% 53% d) 253,726 234,800 (18,926) Total Revenues 1,762,429 1,502,080 (260,349) 58% 50% 3,021,306 2,798,465 (222,841) Trans In -GF 367,283 367,283 - 58% 58% 629,625 629,625 Trans In.GF for Lng Rng Ping 288,960 288,960 - 58% 58% 495,360 495,360 - Trans In -Other 58 - (58) 58% 0% 100 - (100) TOTALRESOURCES 2,648,552 2,290,100 (358,452) 58% 52% 4,376,213 4,055,226 (320,987) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations 823,561 814,272 9,289 Admin -GIS 74,524 70,301 4,223 Admin -Code Enforcement 119,333 121,262 (1,929) Building Safety 327,852 324,394 3,458 Electrical 138,495 131,000 7,495 Contract Services 96,652 103,084 (6,432) Env Health -On Site Pgm 83,480 88,997 (5,517) Planning -Current 361,085 347,641 13,444 Planning -Long Range 279,304 256,671 22,633 Transfers Out (D/S Fund) 101,433 160,242 (58,809) Contingency 147,075 - 147,075 58% 58% 1,411,818 1,411,818 - 58% 55% 127,755 127,000 755 58% 59% 204,570 204,570 - 58% 58% 562,032 545,000 17,032 58% 55% 237,420 230,000 7,420 58% 62% e) 165,689 167,000 (1,311) 58% 62% 1) 143,108 144,000 (892) 58% 56% 619,002 600,000 19,002 58% 54% d) 478,806 443,500 35,306 58% 92% g) 173,885 173,885 - 58% n/a 252,128 - 252,128 TOTAL REQUIREMENTS 2,552,794 2,417,864 134,930 58% 55% NET (Resources -Requirements) 95,758 (127,765) (223,523) Revenues 1,502,080 Expenditures 2,417,864 Net from Operations ___TL5.7841 a) GIS revenue is sporadic based on the frequency of customer requests b) Fall activity less than anticipated c) Contract payments from Redmond are currently on hold pending finalization of a new contract d) As Tumalo area wetland inventory grant will not be received, budgeted expenses will not occur e) Year to date actual includes payout to retired employee f) Extra Help expenditures occur primarily in the summer months g) Transfers made November ($160,242) & May ($13,643) 4,376,213 4,046,773 329,440 8,453 8,453 3,021,306 2,798,465 (222,841) 4,376,213 4,046,773 329,440 (1,354,907) (1,21§,308L 106,599 Page 8 Expenditures Personal Services 3,275,605 3,109,715 ROAD 58% 55% 5,615,323 5,351,169 264,154 Materials and Services 5,934,060 6,002,594 Statement of Financial Operating Data 59% h) 10,172,674 10,036,129 136,545 Capital Outlay 721,403 Seven Months Ended January 31, 2012 696,115 58% 2% i) 1,236,691 90,936 1,145,755 Year to Date 350,000 600,000 (250,000) L Year End 600,000 600,000 Budget Actual I Variance -- FFY % Col. % 58% Budget Projection Variance RESOURCES: TOTAL REQUIREMENTS 11,458,907 9,737,597 1,721,310 58% 50% 19,643,840 16,078,234 3,565,606 Beg. Net Working Capital $2,834,720 $ 3,417,158 $ 582,438 100% 121% $ 2,834,720 $ 3,417,158 582,438 Revenues System Development Charge - 924 924 58% n/a - 924 924 Federal Reimbursements 350,000 600,000 250,000 58% 100% a) 600,000 600,000 - Federal Grant (ARRA) 11,667 20,000 8,333 58% 100% b) 20,000 20,000 Mineral Lease Royalties 23,333 23,589 256 58% 59% 40,000 40,000 - Forest Receipts 764,845 1,322,661 557,816 58% 101% c) 1,311,162 1,322,661 11,499 State Miscellaneous 291,691 500,041 208,350 58% 100% d) 500,041 500,041 - Motor Vehicle Revenue 6,615,000 6,224,049 (390,951) 58% 55% a) 11,340,000 10,810,307 (529,693) City of Bend 160,417 29,941 (130,476) 58% 11% f) 275,000 275,000 City of Redmond 204,167 4,248 (199,919) 58% 1% 0 350,000 350,000 City of Sisters 5,833 - (5,833) 58% 0% 0 10,000 - (10,000) City of La Pine 5,833 - (5,833) 58%. 0% 0 10,000 - (10,000) Admin Recovery (SDC) 583 1,527 944 58% 153% 1,000 2,000 1,000 Miscellaneous 11,667 20,453 8,786 58% 102% 20,000 26,000 5,000 Road Vacations 583 500 (83) 58% 50% 1,000 1,000 - Interest on Investments 11,667 10,514 (1,153) 58% 53% 20,000 17,000 (3,000) Parking Fees 84 - (84) 58% 0% 144 144 Interfund Contract 425,833 - (425,833) 58% 0% g) 730,000 730,000 - Equipment Repairs 116,667 137,946 21,279 58% 69% 200,000 220,000 20,000 Vehicle Repairs 52,500 - (52,500) 58% 0% 90,000 78,800 (11,200) LID Construction 5,833 - (5,833) 58% 0% g) 10,000 - (10,000) Vegetation Management 41,708 - (41,708) 58% 0% g) 71,600 71,500 Forester 14,583 - (14,583) 58% 0% g) 25,000 25,000 Car Washes 2,042 3,030 988 58% 87% 3,500 3,500 - Car Rental - 758 758 58% n/a - 1,000 1,000 Sale of Equip & Material 369,250 529,997 160,747 58% 84% 633,000 718,306 85,306 Total Revenues 9,485,786 9,430,178 (55,608) 58% 58% 16,261,347 15,812,183 ("9,164) Trans In - Solid Waste 166,701 142,887 (23,814) 58% 50% 285,773 285,773 Trans In - Transp SDC 145,833 125,000 (20,833) 58% 50% 250,000 250,000 Trans IwRoad Imp Res 7,000 - (7,000) 58% 0% 12,000 12,000 - TOTAL RESOURCES 12,640,040 13,115,223 496,016 58% 64% 19,643,840 19,777,114 133,274 REQUIREMENTS: EiEg Expenditures Personal Services 3,275,605 3,109,715 165,890 58% 55% 5,615,323 5,351,169 264,154 Materials and Services 5,934,060 6,002,594 (68,534) 58% 59% h) 10,172,674 10,036,129 136,545 Capital Outlay 721,403 25,288 696,115 58% 2% i) 1,236,691 90,936 1,145,755 Transfers Out 350,000 600,000 (250,000) 58% 100% 600,000 600,000 - Contingency 1,177,839 - 1,177,839 58% n1a 2,019,152 - 2,019,152 TOTAL REQUIREMENTS 11,458,907 9,737,597 1,721,310 58% 50% 19,643,840 16,078,234 3,565,606 NET (Resources - Requirements) 1,181,133 3,377,626 2,217,326 3,698,880 3,698,980 a) Revenue received in November at completion of the Cascade Lakes chip sea] project b) Payment received in December c) Received annually in January d) Annual payment received in August e) Revenues trending less than estimates provided by COOT D Billed upon completion of work g) Payments to be received in June 2012 from other Road Department funds h) Expenditures are seasonal and higher during summer. YTD includes $2-5 million paid to Knife River on the Page 9 Full Depth Reclamation Project in South County i) Budget includes $1,096,691 for 19th Street Extension. This will not be expened in FY 2012. 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 TOTAL REQUIREMENTS NET (Resaurws - Requirements) ADULT PAROLE & PROBATION Statement of Financial Operating Data Seven Months Ended January 31, 2012 IYear to Date I Budget I A IFY % I Coll. %I $ 560,000 $ 634,125 $ 74,125 100% 113% I [Budget Year End � 92,452 58% Projection a) $ 560,000 $ 634,125 $ 74,125 126,788 219,240 92,452 58% 101% a) 217,350 219,240 1,890 2,509 4,301 1,792 58% 100% a) 4,301 4,301 - 18,036 - (18,036) 58% 0% b) 30,918 21,000 (9,918) 7,583 10,370 2,787 58% 80% c) 13,000 13,000 58% 1,665,800 2,061,417 395,617 58% 72% c) 2,855,659 2,748,953 (106,706) 14,000 13,150 (850) 58% 55% 957,577 24,000 24,000 - 2,392 1,830 (562) 58% 45% 4,100 2,100 (2,000) 99,167 75,200 (23,967) 58% 44% 170,000 170,000 - 116,667 103,544 (13,123) 58% 52% 200,000 200,000 - 5,250 3,495 (1,755) 58% 39% 9,000 9,000 - 29,167 29,167 - 58% 58% 50,000 50,000 - 29,167 12,500 (16,667) 58% 25% d) 50,000 50,000 - 43,652 18,708 (24,944) 58% 25% d) 74,832 74,832 - 2,160,178 2,552,922 392,744 58% 69% 3,703,160 3,586,426 (116,734) 197,337 197,337 - 58% 58% 338,292 338,292 2,917,515 3,384,384 466,869 58% 74% 4,601,452 4,558,843 (42,609) IE9 1,848,401 1,766,456 81,945 58% 56% 3,168,688 3,168,688 517,353 412,616 104,737 58% 47% 886,890 886,890 - 58 - 58 58% 0% 100 - 100 16,800 14,400 2,400 58% 50% 28,800 28,800 - 301,568 - 301,568 58% n/a 516,974 - 516,974 2,684,180 2,193,472 490,708 581/6 48% 4,601,452 4,094,378 517,074 233,335 1,190,912 957,577 - 474,465 474,465 a) Annual allocation received in January b) State invoiced quarterly. Payment from State pending c) State invoiced quarterly. Payments received from State at beginning of quarter d) Interfund grant received quarterly. Payments have been requested Page 10 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Level 7 Services State Prevention Funds HealthyStart IR -S -G OCCF Grant Program Fees Charges for Svcs-Misc Court Fines & Fees Interest on Investments Donations Interfund Grants Total Revenues CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Seven Months Ended January 31, 2012 Year to Date Budget Actual I Variance IFY % I C-11 % $ 467,111 $ 556,143 $ 89,032 100% 119% 174,701 192,200 17,499 22,942 30,155 7,213 55,417 19,205 (36,212) 150,490 154,986 4,496 14,292 58,017 43,725 181,906 193,653 11,747 318,035 383,499 65,464 - 2,710 2,710 4,667 1,161 (3,506) 45,500 54,213 8,713 2,917 2,435 (482) - 71 71 70,510 150,437 79,927 1,041,377 1,242,742 201,365 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% Trans from General Fund 159,229 159,229 58% Total Transfers In 159,229 159,229 580/0 TOTALRESOURCES 1,667,717 1,958,114 290,397 s8% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS $ 467,111 $ 556,143 $ 89,032 64% Year End I 299,488 Budqet Projection F;Z�] $ 467,111 $ 556,143 $ 89,032 64% a) 299,488 305,416 5,928 77% a)b) 39,329 39,534 205 20% a)c) 95,000 85,000 (10,000) 60% a)b) 257,982 196,898 (61,084) 237% d) 24,500 77,622 53,122 62% a)b) 311,838 258,203 (53,635) 70% a)b) 545,203 509,579 (35,624) n/a e) - 3,500 3,500 15% 8,000 8,000 - 70% f) 78,000 85,000 7,000 49% 5,000 5,000 - n/a e) - 300 300 124% g) 120,875 320,875 200,000 70% 1,785,215 1,894,927 109,712 58% 272,960 272,960 - 58% 272,960 272,960 78% 2,525,286 2,724,030 198,744 EiEq 352,986 343,456 9,530 58% 57% h) 605,119 579,945 25,174 984,071 785,707 198,364 58% 47% i) 1,686,979 1,766,175 (79,196) 58 - 58 58% 0% 100 100 - 135,968 - 135,968 58% n/a 233,088 233,088 1,473,083 1,129,163 343,920 58% 45% NET (Resour�s - Requirements) 194,634 828,951 634,317 2,525,286 2,346,220 179,066 - 377,810 377,810 a) Grant payments received normally within 60 days after the end of each quarter b) FY 12 and FY 13 Intergovernmental Agreement finalized funding levels from OCCF. Community Schools grant included in year- end projection at $9,484. Additional Casey Foundation grant of $11,214 received c) Medicaid revenues reduced due to lower projections d) Youth Suicide Prevention grant increased by $5,000. Runaway/homeless youth grant from DHS not budgeted for $48,122 e) Youth Suicide Prevention training donations & fees expected to be received f) Court fees projected to be higher than estimated in the original budget g) Two additional grants of $55,000 & $180,000 awarded. $55,000 received in last fiscal year, $20,000 grant from OHP expected h) Personnel costs lower due to part-time Early Childhood Specialist i) Sub -grant expenditures paid quarterly. Federal grant amount increased and SPF -SIG grant expenditures added $21,214 in expenditures added, remaining $10,000 for staff expenses Page 11 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Leases Donations Sale of Reportable Assets Recyclables Total Revenues TOTALRESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out -Road Trans Out -Post Closure Trans Out -Equip Reserve Trans Out -Capital Res Contingency TOTAL REQUIREMENTS SOLID WASTE Statement of Financial Operating Data Seven Months Ended January 31, 2012 Year to Date Budget Actual I Variance I FY %I Coll. % $ 1,092,508 $ 1,141,691 $ 49,183 100% 105% � Year (1,520) Budget Proje 1,671,598 $ 1,092,508 $ 1,141,691 $ 49,183 12,833 11,313 (1,520) 58% 51% 1,671,598 22,000 22,000 - 116,667 83,057 (33,610) 58% 42% a) 200,000 200,000 - 501,667 510,841 9,174 58% 59% 860,000 860,000 - 766,500 778,993 12,493 58% 59% 166,701 1,314,000 1,314,000 - 2,333,333 2,330,928 (2,405) 58% 58% 200,000 4,000,000 4,000,000 - 42,583 55,893 13,310 58% 77% b) 73,000 80,000 7,000 14,583 3,007 (11,576) 58% 12% c) 25,000 10,000 (15,000) 4,375 6,620 2,245 58% 88% n/a 7,500 9,500 2,000 1 5,893 5,892 58% n/a d) 1 10,394 10,393 - 2,880 2,880 58% n/a e) - 2,880 2,880 - 15,100 15,100 58% n/a f) - 15,100 15,100 17,500 49,462 31,962 58% 165% g) 30,000 70,000 40,000 3,810,042 3,853,987 43,945 58% 59% 6,531,501 6,593,874 62,373 4,902,550 4,995,678 93,128 58% 66% 7,624,009 7,735,565 111,556 975,099 931,349 43,750 58% 56% 1,671,598 1,614,765 56,833 1,687,614 1,502,700 184,914 58% 52% 2,893,052 3,006,522 (113,470) 566,553 398,826 167,727 58% 41% h) 971,233 971,233 100,333 111,030 (10,697) 58% 65% 172,000 183,930 (11,930) 166,701 142,887 23,815 58% 50% 285,773 285,773 - 233,333 200,000 33,333 58% 50% 400,000 400,000 - 145,833 250,000 (104,167) 58% 100% i) 250,000 250,000 - 247,333 212,000 35,333 58% 50% 424,000 424,000 - 324,539 324,539 58% n/a 556,353 556,353 4,447,338 3,748,792 698,547 58% 49% 7,624,009 7,136,223 487,786 NET (Resources - Requirements) 455,212 1,246,887 791,675 a) Due April 15, 2012 b) Seasonal item -Fall and Spring c) Dependent on special clean-ups such as asbestos and contaminated soil d) Revenue from rent on Rickard Road property, not included in original budget e) Incentive for energy efficient lighting upgrade in Knott Transfer Station building 0 Sold glass crusher at auction g) Recycling markets are higher than expected. Often it can be seasonal h) To be expended in November ($398,827) and May ($572,406) I) Budgeted amount transferred in September. 599,342 599,342 Page 12 RESOURCES: Beginning Not 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 Interest on Investments Other Interest TOTALREVENUES TOTALRESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Repair/ Replacement Total General Liability PROPERTY DAMAGE Insurance Repair/ Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair I Replacement Total Vehicle WORKERS'COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation RISK MANAGEMENT Statement of Financial Operating Data Seven Months Ended January 31, 2012 Year to Date Budget I Actual I Variance I % o $2,100,000 $2,039,937 ($60,063) 100% 97% 146,332 146,332 (0) 181,786 181,786 0 104,014 104,014 (0) 859,801 859,801 0 147,253 147,441 188 2,917 224 (2,693) 11,667 64,439 52,772 875 700 (175) 29 - (29) 10,500 9,170 (1,330) 8,750 8,742 (8) 29 - (29) 1,473,952 1,522,649 48,697 3,573,952 3,562,586 (11,367) 110,162 156,719 196 109,664 5,517 233,333 382,258 (148,924) 116,097 67,043 175,130 183,140 (8,010) 376 10,276 34,207 59,200 ",859 14,340 526,989 74,782 37,347 21,772 466,667 660,889 (194,222) UNEMPLOYMENT - Settlement/Benefits 145,833 53,465 92,368 Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 58% 4% 322% 47% 0% 51% 58% 0% 60% 58% 77% 58% 96% 58% 61% 58% 44% 58% 83% $2,100,000 $2,039,937 ($60,063) 250,855 Year End I I Budget Projection Vari.�,. $2,100,000 $2,039,937 ($60,063) 250,855 250,855 - 311,633 311,633 - 178,310 178,310 - 1,473,944 1,473,944 - 252,433 252,433 - 5,000 5,000 - 20,000 75,000 55,000 1,500 1,500 - 50 50 - 18,000 18,000 - 15,000 15,000 - 50 50 - 2,526,775 2,581,775 55,000 4,626,775 4,621,712 (5,063) 400,000 475,000 (75,000) 300,223 278,000 22,223 101,485 80,000 21,485 800,000 980,000 (180,000) 58% 21% 250,000 250,000 1,080,163 1,324,611 (244,448) 58% 72% 171,708 153,402 18,306 58% 52% 97,835 82,561 15,274 58% 49% 58 - 58 58% 0% 269,602 235,963 33,639 58% 51% 4,200 3,600 600 58% 50% 1,353,965 1,564,174 (210,210) 58% 67% 2,219,988 1,998,±IL_L221,5761 1,851,708 2,063,000 (211,292) 294,357 294,357 167,717 167,717 100 - 100 462,174 462,074 100 7,200 7,200 2,321,082 2,532,274 (211,192) 2,305,693 2,089,438 _jjjL255L * Contingency is $2,305,693. Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Seven Months Ended January 31, 2012 a) GIS/MSAG monthly billings to Oregon Emergency Management -projected revenue overestimated. Projection revised to $27,000 b) Invoiced annually; all expected revenues received c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually June 30th. Payment will not be received from Crooked River Ranch until FY 13 d) Fees expected to be billed in March e) Entire amount budgeted transferred to reserve fund in September Page 14 Year to Date Revised Year E -n -dT -------1 Budget Actual I Variance 1%ofFY1 % Coll. Budget Projection I Variance__1 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 3,490,534 5,560,748 2,070,214 58% 93% 5,983,773 6,117,731 133,958 Property Taxes - Prior 116,667 199,650 82,983 58% 100% 200,000 200,000 - Federal Grants - 184,578 184,578 58% n/a - 203,958 203,958 State Reimbursement 31,500 10,836 (20,664) 58% 20% a) 54,000 27,000 (27,000) Telephone User Tax 437,500 381,366 (56,134) 58% 51% 750,000 750,000 - Data Network Remb. 15,867 34,698 18,831 58% 128% b) 27,200 34,698 7,498 Jefferson County 20,417 26,381 5,964 58% 75% 35,000 35,000 - User Fee 30,333 2,156 (28,177) 58% 4% c) 52,000 52,000 Police RMS User Fees 116,083 - (116,083) 58% 0% d) 199,000 199,000 - Contract Payments 18,667 33,061 14,394 58% 103% b) 32,000 33,061 1,061 Miscellaneous 5,250 7,073 1,823 58% 79% 9,000 9,000 - Interest 20,417 31,864 11,447 58% 91% 35,000 35,000 Interest on Unsegregated Tax 467 439 (28) 58% 55% 800 800 - Donations - 750 750 58% n/a - 750 750 Total Revenues 4,303,702 6,473,600 2,169,898 58% 88% 7,377,773 7,697,998 320,225 TOTALRESOURCES 58% 102% 10,703,702 14,033,239 3,329,537 13,777,773 15,257,637 1,479,864 REQUIREMENTS: EEO Expenditures Personal Services 2,473,820 2,202,926 270,894 58% 52% 4,240,834 4,040,834 200,000 Materials and Services 1,124,291 1,049,560 74,731 58% 54% 1,927,356 1,927,356 - Capital Outlay 661,862 353,657 308,205 58% 31% 1,134,620 1,134,620 Transfers Out 291,667 500,000 (208,333) 58% 100% e) 500,000 500,000 - Contingency 3,485,395 - 3,485,395 58% n/a 5,974,963 - 5,974,963 TOTAL REQUIREMENTS 8,037,035 4,106,143 3,930,892 58% 30% 13,777,773 7,602,810 6,174,963 NET (Resounces - Requirements) 2,666,667 9,927,096 7,260,429 7,654,827 7,654,827 a) GIS/MSAG monthly billings to Oregon Emergency Management -projected revenue overestimated. Projection revised to $27,000 b) Invoiced annually; all expected revenues received c) US Forest Service invoiced $2156.25 quarterly. Crooked River Ranch invoiced annually June 30th. Payment will not be received from Crooked River Ranch until FY 13 d) Fees expected to be billed in March e) Entire amount budgeted transferred to reserve fund in September Page 14 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'l Prem Employee Frain Contribution COIC Retires / COBRA Co -Pay Fees for Clinic Services Federal Payment (ERRP) Prescription Rebates Interest Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: personal Servkes Materials & Semkes Claims Paid-Medical/Rx Claims Paid-Dentaltvision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Other Total HIST - Dept 31 Deschutes On-site Clinic Healthstat MedicationslDnigs Medical Supplies Equipment Miscellaneous Total DOC Deschutes On-site Pharmacy Remodeling Costs Total Pharmacy Capital Outlay Contingency TOTAL Health Benefits Trust Statement of Financial Operating Data Seven Months Ended January 31, 2012 IYear to Date Revised Year E I Budget Actual I Variance FY % Coll % 11 [:E udget I Project $15,500,000 $ 15,829,888 $ 329,888 100% 0 $15,500,000 $ 15,829,888 329,885 7,009,165 7,026,222 17,058 58% 58% 12,015,711 12,015,711 - 29,167 17,372 (11,796) 58% 35% 60,000 30,000 (20,000) 367,500 366,845 (665) 58% 58% 630,000 630,000 735,000 754,045 19,045 58% 60% 1,260,000 1,260,000 - 291,667 506,974 215,307 58% 101% 500,000 760,000 250,000 - 200 200 58% n/a - 200 200 150,431 150,431 58% rv. - 150,431 160,431 - 81,117 81,117 58% n/a, - 81,117 81,117 46,667 64,743 18,076 58% 81% 80,000 90,000 10,000 8,479,165 8,967,949 488,784 58Y. 62% 14,535,711 15,007,459 471,748 23,979,165 24,797,837 818,672 92% 103% 30,035,711 30,837,348 801,637 1�9 88,211 78,702 9,508 58% 52% 151,218 151,218 - 7,276,666 6,873,151 403,515 58% 55% a) 12,474,284 11,529,252 945,032 1,087,318 1,105,776 (18,458) 58% 59% a) 1,863,974 1.854,850 9,124 - (50,753) 50,753 58% n/a - (50,753) 50,753 204,167 206,307 (1,140) 58% 59% 350,000 350,000 - 87,500 155,263 (67,763) 58% 104% 150,000 155,263 (6,263) 186,667 185,344 1,323 58% 58% 320,000 320,000 - 29,167 28,320 847 58% 57% 50,000 50,000 - 32,083 29,946 2,138 58% 54% 55,000 55,000 - 82,345 78,223 4,121 58% 55% 141,162 141,162 - 9,074,122 8,689.278 384,844 56% 15,555,638 14,555,992 999,646 558,367 361,773 196,594 58% 38% b) 957,200 957,200 - 189,583 81,413 108,171 58% 25% 325,000 325,000 1,750 18,878 (17,128) 58% 629% 3,000 30,000 (27,000) 2,333 150 2,183 58% 4% 4,000 4,000 3,179 7,250 (4,071) 58% 133% c) 5,450 10,000 (4,550) 755,213 469,"3 285,749 1,294,650 1,326,200 (31,550) 13,870 - 13,870 (13,870) 117 - 117 7,691,380 - 7,691,380 17,520,831 9,172,611 8,348,220 40,000 58% nia 40,000 (40,000) 58% n/a 200 - 200 58% nla 13,185,223 - 13,185,223 58% 31% 30,035,711 15,922,192 14,113,519 NET (Resixiroas - Requrements) = 6,458,333 15,62 �,2269,1�66,893 14,91 Early Retirement Reinsurance Program (ERRP). Federal program to help pay the cost of insuring retirees who are not yet Medicare eligible. a) Projection based on annualizing 31 weeks of claims paid. YTD actual is $255,748 per week. Page 15 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) Reserve Fund (617) Total Transfers In TOTALRESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Total Expenditures Transfers Out - Reserve Fund Contingency TOTAL REQUIREMENTS NET (Res�iumes - Requirements) Deschutes County - Fair and Expo Center YTD -Budget Basis Commissioners Statement of Financial Operating Data Seven Months Ended January 31, 2012 IYear to Date Budget (7/12 of annual) Actual Variance I FY % � Coll. % Year End Projection Variance FBudgeHtl ! $ 75,000 $ (40,601) $ (115,601) 100% -54% S 75,000 $ (40,601) $ (115,601) 352,917 307,399 (45,518) 58% 51% 605,000 551,399 (53,601) 875 195 (680) 58% 13% 1,500 878 (622) 33,833 13,112 (20,722) 58% 23% 58,000 36,112 (21,888) 3,500 - (3,500) 58% 0% 6,000 6,000 - 17,500 4,186 (13,314) 58% 14% 30,000 34,186 4,186 128,333 75,549 (52,784) 58% 34% 220,000 173,549 (46,451) 65,333 31,000 (34,333) 58% 28% 112,000 114.000 2,000 27,417 - (27,417) 58% 0% 47,000 47,000 - 3,971 7,986 4,015 58% n/a 6,807 9,608 2,801 633,679 439,426 (194,253) 58% 40% 1,086,307 972,732 (113,575) 99,167 99,169 - 58% 58% 170,000 170,000 - 15,017 15,015 - 58% 58% 25,744 25,744 - 48,300 48,300 - 58% 58% 82,800 82,800 - 128,333 220,000 91,667 58% 100% 220,000 220,000 - 58 - (58) 58% 0% 100 - (100) 290,876 382,484 91,608 498,644 498,544 (100) 999,555 781,309 (218,246) 58% 47% 1,659,951 1,430,675 (229,276) EEE 505,177 485,176 20,001 58% 56% 866,018 846,074 19,944 280,618 370,202 (89,584) 58% 77% 481,060 563,365 (82,305) 67,123 71,266 (4,143) 58% 62% 115,068 115,068 - 58 - 58 58% 0% 100 - 100 852,977 926,644 (73,668) 1,462,246 1,524,507 (62,261) 5,833 10,000 (4,167) 58% 100% 10,000 10,000 - 109,495 109,495 58% n1a 187,705 - 187,705 968,305 936,644 31,660 58% 56-A 31,250 (155,335) 186,5851 1,659,951 1,534,507 125,444 (103,832) ( �,832 Page 16 FIA W'd C-4 cli 0 2 ;- co a) C/) cm 2 0 �i w 0 0 U) ui it C, C) Ct cl� C 0 I CD N C� C� C6 �li F Fl? C! -I CD m m C) m to co m CD C) m (D m r� 0 CD CD , C� C) � M o 0 co � C) (o M C� C� Ct Ct Cli q (D C) CD to m Cf) CD cli 0 C� C\1 0) 6 C4 C6 - - CN , - Cl) CD 0 CN 0 N 0 LO V) cm Vi cc� CN! V 16 M n wi CD m 0 cn, en C) m CD 0 m r� C) � CD C) 00 to cm CD (D M U) 0 0 cn� 0 00 (D 0 C) co Cl) m 0 vi L6 (5 rz 66 -7 C5 cli C6 cli 1: cli CD CD N CD C4 0 CD O�m C� CO 0 q1t oc� C14 CIJ Cl) ca .0 m ca CO) CD CD m to 0 o m 0 (D m 0 m , C� C� , N 0 r- M V co Lo ct C� C� m Ci 0 m 0 CN CN C\l � cn, cli (D 0 L6 (o - ci cli CD C-4 IT fD C%l 0 Lo 0 0 —7 a to LO Lo Lo Ln to w Eli crt cli 04 0 0 N C4 C) 0 C4 m v � M Cl) Ce) IV C%4 CD ce) cq C� r- n 0) - r- - 0 Cli It C14 I I C4 L6 ci cli 0; 0) Ld L6 (4 cli q 11: cb C> CN C) C14 0 C0 0 0 m 1: (D v Ln CD 04 'T >1 m Cc (D OM 0 a LL L- a) TO c E E = 0 �a Mo vi 'a 2 0 r- CO -6 cm 7u 03 > 0 d) tm CL 10 C 0 w 5.4 a 4) a o 'a CL CL z 2 . m E = t: (a 0 7i x o o w I > E W m 4L) m IL - < w a. -2 s (a CD 0 X U- � x LU z CD va, a) a) LL CL 0 0 L) > (D E 2 E w 0 0 w 0 CN LL CN LL Q c Q) 2 ID 2 = = 0 a - cc cc CL W CD CD C> a) (14 (1) CD P- I�t z -0 LU 04 :2 0 -� C') OZ m < U) LU z o 02 Q D o Z Z LLI U� LO It C) C� 04 C) C. C) C; LO I Deschutes County Bethlehem Inn (Fund 128) Seven Months Ended January 31, 2012 a) Interest on January 2012 negative cash balance: $1,371.89 b) Inception through January 31, 2012 Revenues - Lease Payments Budget Actual Variance FY % I Coll. %I Hickman Williams Budget I Projection Variance RESOURCES: 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 234,441 Total expended Beg. Not Working Capital $(2,711,235) $(2,716,581) $ (5,346) 100% l00% $(2,711,235) $(2,716,581) $ (5,346) Revenues Grants - Private 1,634,399 - (1,634,399) 58% 0% 2,801,827 - (2,801,827) Lease Payments 14,238 14,238 - 58% 58% 24,408 24,408 Total Revenues 1,648,637 14,238 (1,634,399) 58% 1% 2,826,235 24,408 (2,801,827) TOTALRESOURCES (1,062,598) (2,702,343) (1,639,745) 58% -2350% 115,000 (2,692,173) (2,807,173) REQUIREMENTS: EE� Expenditures Debt Service: Interest Expense 8,750 11,365 (2,615) 58% 76% a) 15,000 17,000 (2,000) Interest Payment 58,333 - 58,333 58% 0% 100,000 - 100,000 TOTAL REQUIREMENTS 67,083 11,365 55,719 58% 10% 115,000 17,000 100,000 NET (Resources - Requirements) b) (1,129,681) (2,713,708) (1,584,026) (2,709,173) (2,707,173) a) Interest on January 2012 negative cash balance: $1,371.89 b) Inception through January 31, 2012 Revenues - Lease Payments $ 38,646 Expenditures: Land/Building (Amertitle) - July 2007 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KIN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 234,441 Total expended 2,752,354 Net 6 Deschutes County General Support Services - BOCC Conference/Seminar, EducationfTraining and Travel Expenditures and BOCC - County College Expenditures IFY 2012 ROCC-Conference ii�Tmvei Jul Aug Sep Oct Nov Dec Jan YTD Total Tammy Baney Conf/Sem & Educ/Training 305 15 5 i 1,060 Travel Meals — -- -modath - Accom ions 996 1 22C---- 211 --- 30 90 1,518 340 3,154 Airfare Mileage reimbursement - 794 677 309 - 529 - 2,309 Ground Transport/Parking 150 150 Total Baney Conf/Sem & Educ/Training 665 1,375 734 305 722'396- 49 2,123 75 7,013 1,090 Travel Meals - Accommodations 1,131 322 1,452 Airfare Mileage reimbursement Gmund- TransporUParking Total Unger Tony DeBone Conf/Sem & EductTraining --travel Meals 1,796 665 - 627 305 :i 45 45 75 535 - 2,542 1,550 Accommodations 908 -429 1,337 Airfare 57-3 fleage reimbursement 300 146 163 138 1 748 Ground Transport Totil Other Total - BOCC Department - 1,573 54 354 - 880 45 1 163 1,246 54 4,261 Conf/Sem & Educ/Training- Travel Meals -c -o -m -m- -d- -a -i 1,330 - i 226 610 60 30 90 610 3,700 340 A c o t o n s 1,904 211 8u-7 r--- 1,518 i 5,943 Airfare --milea-ge-Reim -�-794 --- 573 — 573 .- 6U rsement 3-0-0 146 1 677 472- 668 Ground Transport F-- 1-50 54 - - --- - 204 -Totill C 3,234 354 i 1,375 1,613 767 562 3,369 13,816 IFY 2W� 14,750 Percent of FY 2012 Budget Ex"d 93.7% BOCC County College ir Public Information- Office/Copier Supplies Mee�ting —Supplies 556 829 59 M18-�- 11 12 M —2,17-2- T 675 829 847 1-2- 2—,373- 1/30/2012 I MA 1:11 MA [Q 5R.Al OLI Bill LTA Date: March 7, 2012 To: Board of County Commissioners From: Finance Department Subject: Proposed Emergency Fee Additions to FY 2012 Fee Schedule Background: Over the past few years, there has been growth in the number of temporary restaurants at locations such as farmers markets and amateur sporting events. A restaurant booth that is located at a farmers market often operates in more than one market per week. Current statute requires the owner to obtain a temporary license and get inspected every time they operate. The passage of House Bill 2868, which provides for licensing of intermittent temporary restaurants and seasonal temporary restaurants, brings about the need to approve and add four new fees to the FY 2012 Fee Schedule. The measure establishes a licensing system for two new types of temporary restaurants: [11 seasonal temporary restaurant license — good for 90 days (same event, same location and same menu) e.g. farmers market, little league concessions; and [2] intermittent temporary restaurant license —good for 30 days (different events, same location, same menu) e.g. Les Schwab Amphitheater having several different events in a 30 day period. Note: Single events, such as The Bite of Bend will use fees that are currently included in the FY 2012 Fee Schedule. Discussion: Under current law, there is only one type of temporary restaurant license valid for 30 days or until a temporary food vendor ceases operation. HB 2868 differentiates three categories of temporary restaurants by the Oregon Health Authority: 1. Intermittent temporary restaurant category — allows an establishment operating at the same location over several days at events sponsored by different organizations to apply for an intermittent temporary license that is valid for 30 days. Under existing law, these restaurants are required to obtain a license and be inspected every time they operate. 2. Seasonal temporary restaurants — allows an establishment operating periodically at the same location and with the same oversight group (e.g. vendors at weekly farmers markets) to apply for a seasonal temporary license valid for 90 days. Under existing law these temporary restaurants are required to obtain a license and be inspected every time they operate. 3. Single -event temporary restaurants — allows establishments operating in one location in connection with a single event to apply for a single -event temporary license valid for 30 days or until the operation ceases. HB 2868 also requires an "Operational Review" plus fee for Seasonal and Intermittent TRLs. IMPACT: HB 2868 should have a minimal fiscal impact on Deschutes County. There will be a reduction in licensing applications, and therefore a reduction in revenue; however, there should be a corresponding reduction in workload due to a decrease in licensing and inspection activities. Emergency Fees to be added to FY 2012 Fee Schedule: Intermittent Temporary Restaurant License Seven days or more before event start date 125.00 Less than seven days before event start date 150.00 Seasonal Temporary Restaurant License Seven days or more before event start date 125.00 Less than seven days before event start date 150.00 Operational Review Re -check fee for Temporary Restaurant 85.00 Requested Action: Discussion regarding and approval of addition of emergency fees to FY 2012 Fee Schedule. Information regarding the new fees for Environmental Health that go into effect on March 1. Pursuant to House Bill 2868, starting March 1t, 2012, all county EH programs in Oregon must offer 3 types of Temporary Restaurant Licenses (TRL's): 1) Single Event TRL (which we've always had) 2) Seasonal TRL —good for 90 days (same event, same location, same menu — e.g. farmers market, little league concessions) 3) Intermittent TRL — good for 30 days (different events, same location, same menu- e.g. Les Schwab Amphitheater having several different events in a 30 day period) Both 2 and 3 above will require what's being called an Operational Review. Because of when the Governor signed the bill, March 1 is when the laws (ORS's) go into effect. 3 new fees on March 1st: 1) Seasonal TRL: $125 2) Intermittent TRL: $125 3) Operational Review: $85 The Oregon Health Authority may require a new fee called a Re -check Fee for these new TRL's but nothing in place yet. I have calculated how I arrived at those above fees if anybody needs them. Also, all our existing Single Event TRL's fees will stay the same. I will meet with Diana Jackson (IT) and Sandy to get these rolling in Accuterm and our fee schedule. I know EH is going away from Accuterm starting July I as we will transition to the state electronic inspection system (called the acronym EHLIS) but Accuterm will still need to be used for TRL's until around 2013 since I'm told EHLIS does not support TRL's at this time. Let me know if you need more information or have questions. Thanks to everybody for your help with this. Eric More, REUS Environmental Health Supervisor Deschutes County Environmental Health 541-388-6566