The URL can be used to link to this page

2013-973-Minutes for Meeting April 29,2013 Recorded 6/4/2013COUNTY NANCYUBLANKENSHIP,F000NTY CLERKpS ~J Za13.913 COMMISSIONERS' JOURNAL 11111)[1111111111111111111111 06/04/2013 08:10:30 AM Do not remove this page from original document. Deschutes County Clerk Certificate Page Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS MONDAY, APRIL 29, 2013 Present were Commissioners Alan Unger, Tammy Baney and Anthony DeBone. Also present were Tom Anderson, County Administrator; Erik Kropp, Deputy County Administrator; and, for a portion of the meeting, Susan Ross, Property & Facilities; Marty Wynne, Finance; Nick Lelack and Peter Gutowsky, Community Development; Laurie Craghead, County Counsel; Chris Doty, Road; Timm Schimke, Solid Waste; Scott Johnson, Health Services; Anna Johnson, Communications; and media representative Shelby King of the Bulletin, plus two other citizens. Chair Unger called the meeting to order at 2:30 p.m., after the conclusion of an executive session. 1. Finance/Tax Update. Marty Wynne indicated that the interest rate is still above what was budgeted, at 0.4%. He looked at higher rates over three to five years, but there is greater risk. Discussion of the Investment Advisory Committee took place regarding hiring an advisory specialist. This would be a professional advisor in the investment field who would work for a flat rate. The cost would be fairly low, and that person could answer questions during discussions regarding investment decisions, and could review policies to see if anything should be changed. He said that about 20% of the portfolio can go out over two years. If some of it could go out for five years, they would get a higher yield. That would take down the LGIP total. They are looking at finding someone who does that kind of work. There are two firms in the state involved in this. Chair Unger stated that this would give a little more continuity during times of change. Commissioner DeBone added that someone asked at the Finance Director interviews last week if we were doing this. Minutes of Board of Commissioners' Work Session Monday, April 29, 2013 Page 1 of 5 Mr. Wynne said that one important piece of information is that there are those the County is working with already who recommended this. The ending working capital for department funds show that most are on target for the fiscal year. The north County campus project is on hold; others have not changed much. They cannot do the one for the jail project just yet but will be tracking that activity next month. 2. Discussion of Testimony Stemming from the February 26 and March 12 Hearings on the Newberry Country Plan & Next Steps. Peter Gutowsky went over suggested revisions for the South County Plan. It has been a very positive process, using a Partnership to End Poverty grant, and involving the educational coordinator for COCC. The process captured the need for adult education and learning. They facilitated the discussions with OSU Cascades and COCC. There are emerging issues, and this is an active group that meets regularly to talk about higher education. Commissioner DeBone said they need to get the word out about adult education. Mr. Gutowsky indicated that there was a meeting with the steering committee, and they discussed some information regarding groundwater. DEQ comments are italicized. (He referred to his report, a copy of which is attached.) When they were formulating, they coordinated with a soils scientist. Density is an issue in regard to soil capability, and there is an association to rural subdivisions coupled with rapidly draining soils. There may be a different way to say it. Mr. Anderson said it is dense when you are talking about rural subdivisions. Commissioner Baney agreed that it is significantly dense when you think of other unincorporated areas. Commissioner DeBone said he is not opposed to the language, but would like a recommendation. They should aim for sewers if one acre or less. It would make his life easier. Otherwise, it is not cost effective. Commissioner Baney added that what matters is proximity to the units. Some may be on narrow but deep lots. Minutes of Board of Commissioners' Work Session Monday, April 29, 2013 Page 2of5 Commissioner DeBone read the last paragraph, and asked if the DEQ Steering Committee is involved. Mr. Gutowsky replied that they have acknowledged the circumstances, but he doesn't know how or if they will respond to the critical issues. Mr. Anderson said he does not remember any of these things being discussed. Commissioner DeBone stated he got input from a couple of members about specific items. They can't really proceed with any of those. They have been discussed in the past. Commissioner Baney noted that she feels the changes as noted are appropriate. Chair Unger was okay with having the last part of the last paragraph deleted. Mr. Gutowsky clarified that they would include the three paragraphs, indent the DEQ language to show that it is an excerpt from the DEQ. It was taken off the URL. Commissioner DeBone asked if there is any way to incorporate other points that were made. The water in La Pine is good now; but is this documented or an assumption. Mr. Gutowsky said that some areas have higher concentrations of nitrates than others. They want to protect or maintain the quality of the groundwater. Commissioner DeBone stated that it is a marketing campaign anyway, having everyone want filtered or bottled water. He said someone told him he has wells that have been low in iron for some time, but occasionally it shows up. Groundwater does move around and can change. Laurie Craghead reminded the group that ex parte contact is allowed, but the record is closed and this can't be relied upon for a decision. Mr. Gutowsky noted that anything submitted after the end of March is not considered in the record. Most were discussed already anyway. He referred to a table in the packet, which mostly has to do with better ways to wordsmith language. Chair Unger asked about information on page 1, 2.9. Mr. Gutowsky said that it recognizes the role than an individual needs to have regarding community support. Commissioner Baney stated that they hope to get away from government assistance. Maybe it is more towards a healthy or productive life, with worker productivity, or contributing to the community. Mr. Gutowsky said he could scratch the language after best practices. Minutes of Board of Commissioners' Work Session Monday, April 29, 2013 Page 3 of 5 Chair Unger asked about page 3, 6. 1, regarding maintaining and supporting La Pine's involvement in EDCO. He asked about the `investment' part. He wants to encourage and will help as much as possible. Commissioner Baney asked if they need to call out a specific organization. What if the organization goes away? Mr. Gutowsky said that the strong statements underscore the need for regional economic coordination. They could substitute `economic development'. He did not see it as a financial commitment as much as a seat at the table. Chair Unger asked about page 4, 16.11. They also have the Deschutes Water Alliance. There is a difference, and both should be listed. Commissioner Baney again asked why specific organizations are being named. This is a problem if something changes or a group does something egregious. Mr. Gutowsky stated that there is an area-specific plan. They received feedback about keeping it general or identifying organizations. This information is more general in the comprehensive plan, but identified in local plans. Commissioner Baney noted that some partners are missing. Chair Unger said that having it more generic is okay. The Deschutes River Coalition has a lot of buy-in in that area, too. They suggested that they take all the names off or just say `all partners'. Regarding page 19's graphic, Commissioner DeBone asked that they make it a circle and take off the bumps. He would also like to change the statement under non-governmental groups. LIGI no longer exists. The new name is La Pine Economic Development Committee. Mr. Gutowsky asked if the Board wants to honor any of the correspondence that came in after the record was closed. Testimony was to strike out references to high groundwater lots. This is a higher priority policy, and he does not recommend removing the language. Commissioner Baney noted that no one else mentioned this at other meetings or hearings. They will try for the first reading of the Ordinance on May 8. Minutes of Board of Commissioners' Work Session Monday, April 29, 2013 Page 4of5 3. Executive Session - Real Estate Negotiations. This item was addressed at the beginning of the meeting. 4. Other Items. In regard to the letter from Kathy Phillips, complaining that she arrived at the end of the posted timeframe for the hearing but it had just ended, Mr. Anderson said he will see if there is a way to show no end time at all, but it will be at the discretion of the Board. There will be second interviews for Finance Manager, four people, probably later in the week. One Commissioner can sit if desired. Being no further items addressed, the work session ended at 5:10 p.m. DATED this Day of 2013 for the Deschutes County Board of Commissioners. a&4-,(42~ - (,Unger, Chair =2 Tammy 13 ney, Vice hair ATTEST: Anthony DeBone, Commissioner T Recording Secretary Minutes of Board of Commissioners' Work Session Monday, April 29, 2013 Page 5 of 5 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, APRIL 29, 2013 Finance/Tax Update T-- Marty Wynne 2. Discussion of Testimony Stemming from the February 26 and March 12 Hearings on the Newberry Country Plan & Next Steps - Peter Gutowsky 3. Executive Session - Real Estate Negotiations 4. Other Items PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to ORS 192,660(2) (e), real property negotiations; ORS 192.660(2) (h), litigation; ORS 192.660(2)(d), labor negotiations; or ORS 191660(2) (b), personnel issues. Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. If you have questions regarding a meeting, please call 388-6571. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. C O v to a W tiC -r' c Z _Qd of CL ~4-. O zit: Q) w ca a Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA April 29, 2013 (1) Monthly Investment Report (2) March 2013 Financials to w M M in LO Nt N N N 4 C M d N r E LO LO V 0 = N r.r ~ d 60 to 41 ~ C d ~ CO G o 7 y U. 4 G o O N go CD M It c") tOD 60 vi Q o c W O in W E + r C) 0 M M o 3 60, u O C O E Z LL U aa) C E 0 c o c0i L) E T m L w U) C T aj d = N C U- V1 E E N ' y 7 o c J - ~ N d ~ c ~ alG- O ~ N C~ 0 0 0 0 0 0 0 0- 0 0- 0- a 0 0 CO ti O 4 CO CO 4 O O g r._ Q R 4 4' t or►uio.-oUi o i M M UI) it QCO ~~dd cp ch LO O w r M EH d4 C(i y y "i C O N a M d 41 Q7 U r-L C d Z w M 80 ¢ 7 N T w 0 E O C.~ H O m E EL OVi- ca 4 0 O O W l6 6 O LL CO -j CO 0 H N U) ~.u O C C g o 0 22 wit r N 0 0 0 o a o 0 0 0 d 0 N N N N~ O M r r r CH h E U fn C13 Cn a) CL N E X M O N c~' a o E r L N¢2Z 'x c 0 Q y L- a) O 2 E LO Chi ~ a a) m E O_ E N fn - 4 E L UJ -i iio~OHUU o rn Document Reprodmes Poorly (Archived) H 40 Q T w N N E ~ a~ NLQ H 7 m e E U w a CO T m U ~ J O y m ~ EL 0 c O Z U O I n lf I b Ca U IUiU ` UjU ` U U U 0 0 0 UIU U 'I(U o;m ( o lo o' °b k l o~ z Iz z z jz z z 4 z zz Z z Z1Z a,ao 4 I n d ui o o d r o.to b o b 1 1 Z I oD ' r (0 (D CD C] i O d N R . M ap O M n 0 O O r N I a Iq cq 't. I 04 H M O j (D O M O d` N Cn ! CO m Ca h O N n R C1 O r M CO O N I t2 r O M M LL7 N ~ GO COI to LO R L I Q/ oil- N M Cn . CD n co In CC) CD O M CO O r m h O n CO N m R j b r 3 3 LL] CO lA ' m M O O O d CD (h M N, m R OI N RICO (n (n LL7 ILL] M O (G Cl co Cn M f 1 M N O V CD 01 I C/ y - N 1 G O O r N N O O N r 0 r N N O r l r C? O C•H (B N r , m N LO l 7 N N N N C %i r N m C Ci b o M I , .0 r n ! I r Q M i C I r F . I . . . . . . . . CD O O O O O LL7 M (r7 R R O O M CO N ao (O to O I- O CO O 0 0 O a mp ! O N Uj CCOO j (D M ti O LO N m m CO r • R R Q d N N O CD O N CD CO O 4 CD O R CO m O h O n O LO R M U) 1 O R co I O CO O R n C7 I,R O M O 4q l I I , m N O M O M N N_ LO co O !C7 R - mi CD i O O 4 0) O N R N n co lO J O (0j R I M, M n L(7 LL CO O 4 N Nt r^ I 11 4 , Y W Ir O N N O N O N O N r . N N r r N co M , I I O rl I W'.. - I . ~ O O' O O O I CD pp' b 1 O O O O O O R . R Co M 1 ry 0 0 0 0 0 0 0 0 C7 p 0 O O C~ 1 0 O O O O O CO 0 R O CD R co N LO O R N M ! II G 0 R 0 n 0 0 0 0 0 0 0 0 0 0 0 O 0 i R 1 1 0 0 I O O 0 R 1 C )J N 0 0 O 0 P- ~ O n O Cl) rI O M O i r , I jC n R 0 O O D ' Co O O I C51 N O O O N CO LO LO n'.. l G • m CC! N'0 r'N 0 C C O 10 r Q R r r O r OIr R N R I N O (p R M ,r r O r M O 0 N ~I M I m .G N N N IN '.i 04 cm N m o M M CLI U) U) I, E- 3 'eE 3Q c ° ° `oE „ m U) = N a) ¢ 'p d w O CO n m (fi 0 0! O (O O LO O 47 p n R lo w O (n r n 0 O R 0 4 0 O F-- (P 00 O 11 ti N 1► n O O c 1[i N co U n ` C7 Y N y Cd . d m C d O r r C7 C7 r r C7 C) I a C) 4 O O O O Q l 6 4 ! C7 E O d 2- h - N Y j CL " I I I E 0 e- oI E U) a F ' j U U'F- Z3 U- A O o O 0 ° o I - ' a ° ~ ....E , C LO (n CD IR n w LO n M LO L6 I (D C) ~ o 0 ' ' E a 0 ms, 0 I , I 1 • u i a 1 ! I 2 r c a • ~ _ M ; I in ~ I C d~. ~ _ I _ 'I I ~ • ~ I O S AS r- n LO r C) R O O I R m C • O • S O m n 5 A LO I,- M M o ti M m M R m O R r M rm n , LL~ m N (O n R N°' ' r I R m n (D M~,. G R r ire n O n N rn too E c _ d 10,0 I~ I I f ; a o 0 0 ' 0 r o M' o 'ro V I 10 `R O 55 O 0 O ti O S 0 -I 0, A • 1 (n (20 a o ol , `n'm 0',O NI O O', ~r a ~ S Ia IH C m I m I , r N I L. N N N N l N M M O7 t II co co I O I m m co m M m d n r (0 m n' . 0 'N R N N tt7 r Q N (O O ° NI O m S o ~N iz N OI n N (OD r c, OI O, n r O O N M C) C) U. 1 in z IL ~I } I U In x'Y LLI LL )i ,5 U 3: ) 4 0 LL - adRl LL r U ~ H U O O U 10 - l - - cg 7 U~ rq LL LL LL LL 2i U =EL z 1 0- cn0; 3. aluZi LL ~ ~ m 7 CO LL l m ml M z! = Y l I Z ~I = I ❑ L N n n I u~ N C7 N = O. A .t , rn (D cmo co V F.~ m _ i ~I H Y ' U,' U U U n Q ` c m m G N Y CI L Cl m a c , , ' a Q1 C U Y 1 N Q n Q) U N m ca U f/J m a 0 n. l0 N U "a CCa;p - x' p U ❑ of c' o l 1U cn' CD a, m 2 ~I ~ s LLI d I I' 1 d N tl> 7 U- G (6 m'U a~ fCICO m' U w U ❑ U~ U U (p ~ 01 (n '0 T ~ .O m -x (Q - ~ 7 } Z m m' w Q rn m ~ z N X 1 7 z m V C Y U ~I II~ ' [ I U' O O O E W ~I MI 4) N C C LL N I E O 0, U'. N r O w x _ ~ (611 C L o~ m0 ~li m ~ C C cIm a ] rp ~ ~ m' o ' Y rr a CO ca _0 0 ~ U U O7 E 0 ~'Yl a E ~ I L) i' in CT CL inl~ L m V) Y E EL mc~ci! 0 ~i N ~ I O ca ~ I z I , 01 CU t ~ ` - .ti 0 I oI E - n n E C O U) E ' a~ w c~ c 1 j . . H m a ~iin a nal?'U E E ~a i a) Q ~ m I Memorandum Date: April 10, 2013 To: Board of County Commissioners Tom Anderson, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find March 2013 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriff's (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non-Departmental Contingency Transfers Out TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date FY 2013 Year End $ Budget Actual Variance FY % Coll.% Budget Projection Variance $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% $ 8,700,000 $ 9,059,394 $ 359,394 15,143,670 19,688,139 4,544,469 75% 98% 20,191,560 20,774,199 582,639 510,000 955,734 445,734 75% 141% 680,000 955,734 275,734 1,790,498 2,175,659 385,161 75% 91% a) 2,387,331 2,687,331 300,000 561,470 679,625 118,155 75% 91% b) 748,626 873,626 125,000 1,035,017 1,187,176 152,159 75% 86% 1,380,023 1,620,023 240,000 9,299 13,313 4,014 75% 107% b) 12,398 18,313 5,915 138,521 99,976 (38,545) 75% 54% 184,694 184,694 - 149,175 209,747 60,572 75% 105% b) 198,900 249,747 50,847 51,300 37,399 (13,901) 75% 55% 0) 68,400 68,400 - 74,433 70,683 (3,750) 75% 71% 99,244 99,244 - 1,500 1,500 0 75% 75% 2,000 2,000 - 19,464,883 25,118,951 5,654,068 75% 97% 25,953,176 27,533,311 1,580,135 28,164,883 34,178,345 6,013,462 75% 99% 34,653,176 36,592,705 1,939,529 Exp. 2,675,814 2,524,839 150,975 1,100,729 956,516 144,213 54,289 43,147 11,142 3,956,000 3,714,293 241,707 625,399 594,350 31,049 195,744 184,746 10,998 204,020 200,556 3,464 91,762 88,721 3,041 1,286,003 738,019 547,984 4,540,896 4,540,896 14,730,656 9,045,187 5,685,469 10,423,239 9,825,110 598,129 25,153,895 18,870,297 6,283,598 3,010,989 15,308,048 12,297,060 Beginning Net Working Capital per Proposed Budget 75% 71% 3,567,752 3,467,752 100,000 75% 65% 1,467,638 1,361,638 106,000 75% 60% 72,385 72,385 - 75% 70% 5,274,667 5,074,667 200,000 75% 71% 833,865 833,865 - 75% 71% 260,992 260,992 - 75% 74% 272,027 272,027 - 75% 73% 122,349 122,349 - 75% 43% d) 1,714,671 1,414,671 300,000 75% n/a 6,054,528 - 6,054,528 75% 46% 19,640,874 12,880,346 6,760,528 75% 71% 13,897,652 13,897,652 - 75% 56% 33,538,526 26,777,998 6,760,528 e) 1,114,650 9,814,707 8,700,057 9,500,9070771 a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes three quarters - July, October & January c) State payment received quarterly. YTD includes one quarter d) Budget includes $576,736 payment to LED#2. Will not be expended until June 2013 and is projected to be $300,000 less than budgeted due to available Transient Room Tax revenues e) Appropriation Transfers (authority to expend): County School Fund $360,000, Grant Fund $10,000 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,010,415 $ 995,051 $ (15,364) 100% 98% $1,010,415 $ 995,051 $ (15,364) Revenues Federal Grants 4,500 - (4,500) 75% 0% a) 6,000 6,000 - SB #1065-Court Assess. 2,900 5,995 3,095 75% 155% b) 3,867 7,000 3,133 Jail Funding HB #2712 - 27,849 27,849 75% 60% b) 46,133 37,000 (9,133) Discovery Fee 9,750 7,383 (2,368) 75% 57% 13,000 9,800 (3,200) Food Subsidy 15,750 18,432 2,682 75% 88% c) 21,000 28,000 7,000 OYA Basic & Diversion 281,510 188,030 (93,480) 75% 50% d) 375,347 375,347 - Inmate/Prisoner Housing 45,000 105,060 60,060 75% 175% c) 60,000 140,000 80,000 Inmate Commissary Fees 75 231 156 75% 231% 100 250 150 Contract Payments 91,500 63,017 (28,483) 75% 52% e) 122,000 100,000 (22,000) Miscellaneous 150 59 (91) 75% 29% 200 100 (100) Program Fees 38 - (38) 75% 0% 50 - (50) MIP Diversion Fees 750 275 (475) 75% 28% 1,000 375 (625) Interest on Investments 6,000 4,703 (1,297) 75% 59% 8,000 6,250 (1,750) Leases 900 1,000 100 75% 83% 1,200 1,200 - Grants - Private 375 1,237 862 75% 247% c) 500 1,500 1,000 CFC Interfund Grant 94,246 60,731 (33,516) 75% 48% f) 125,661 125,661 - Interfund Grant - Gen Fund 15,000 10,000 (5,00 75% 50% d) 20,000 20,000 - Total Revenues 568,444 494,001 (74,443) 75% 61% 804,058 858,483 54,425 Transfers In-General Fund 4,008,393 4,008,393 - 75% 75% 5,344,523 5,344,523 - TOTAL RESOURCES 5,587,252 5,497,445 (89,807) 75% 77% 7,158,996 7,198,057 39,061 REQUIREMENTS: Exp. Expenditures Community Justice-Juvenile Personnel Services 3,806,263 3,692,260 114,003 75% 73% g) 5,075,017 4,964,036 110,981 Materials and Services 895,470 786,556 108,914 75% 66% g) 1,193,960 1,050,000 143,960 Capital Outlay 75 - 75 75% 0% 100 - 100 Transfers Out 37,800 37,800 - 75% 75% h) 50,400 50,400 - Contingency 629,639 - 629,639 75% n/a 839,519 - 839,519 TOTAL REQUIREMENTS 5,369,247 4,516,616 852,631 75% 63% 7,158,996 6,064,436 1,094,560 NET (Resources - Requirements) 218,005 980,830 762,825 - 1,133,621 1,133,621 Beginning Net Working Capita l per Proposed Budget 1,125,000 a) Grant payment anticipated in last quarter, pending completion of project b) HB #2712 replaced SB #1065 effective January 1, 2012 c) Revenues trending higher than anticipated - billing outstanding for inmate/prisoner housing d) Payments received quarterly e) Contract payment reimbursement request submitted monthly, received 1-2 months in arrears f) Grant payments are generated by program activity during the school year and are received quarterly in arrears g) Expenditures trending lower than anticipated. Currently 6.8 unfilled FTE; Eliminating 4.8 FTE h) Transfers out recorded quarterly Page 2 SHERIFF - Fund 255 Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - Revenues Law Enf Dist Countywide 16,921,220 13,837,237 (3,083,983) Law Entt fh#10 1,n 9,167,564 (1,03 , Total Revenues 27,752,489 23,004,801 (4,747,688) 100% n/a $ - $ - $ 75% 61% 22,561,626 18,928,451 (3,633,175) 58, 4.3 2,182 7$9 75% 63% 4,4 1'fRg 12,2. 75% 62% 37,003,318 31,187,344 (5,815,974) TOTAL RESOURCES 27,752,489 23,004,801 (4,747,688) REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division 1,697,723 1,689,886 7,837 Civil 599,242 541,887 57,355 Automotive/Communications 1,355,588 1,432,314 (76,726) Investigations/Evidence 1,131,135 1,069,348 61,787 Patrol/Civil/Comm Supp 6,202,019 6,135,823 66,196 Records 538,213 519,398 18,815 Adult Jail 8,160,024 7,610,286 549,739 Court Security 227,251 224,590 2,661 Emergency Services 145,900 137,245 8,655 Special Services Division 1,009,528 879,109 130,419 Regional Work Center 1,997,309 1,883,488 113,821 Training Division 378,713 318,660 60,053 Other Law Enforcement Svcs 482,628 498,827 (16,199) Non-Departmental 63,940 63,940 0 Contingency 3,763,280 - 3,763,280 TOTAL REQUIREMENTS 27,752,493 23,004,801 4,747,692 75% 62% 37,003,318 31,187,344 (5,815,974) Exp. 75% 75% 2,263,630 2,263,630 - 75% 68% a) 798,989 744,889 54,100 75% 79% b) 1,807,450 1,812,450 (5,000) 75% 71% 3) 1,508,180 1,468,080 40,100 75% 74% a) 8,269,358 8,169,358 100,000 75% 72% a) 717,617 677,517 40,100 75% 70% c) 10,880,032 10,425,532 454,500 75% 74% 303,001 302,901 100 75% 71% 194,533 194,433 100 75% 65% 1,346,037 1,328,069 17,968 75% 71% d) 2,663,078 2,522,978 140,100 75% 63% 504,950 508,850 (3,900) 75% 78% e) 643,504 683,404 (39,900) 75% 75% 85,253 85,253 - 75% n/a 5,017,706 - 5,017,706 75% 62% 37,003,318 31,187,344 5,815,974 NET (Resources - Requirements) - - - - - * Revenues from LED #1 & LED #2 adjusted monthly to equal actual expenditures a) Projected variance due to Personnel expenditures projected to be less than budgeted due to open positions and overtime b) FY 2013 appropriated amount, $360,690 for payment Deschutes County Communication System Fund, expended in July 2012 c) Personnel budget was increased for the annual cost of six Correction Technicians. Technicians will be hired in March, resulting in projected difference between actual and budget of $428,000. Also, $90,000 budgeted for Capital Outlay will not be expended d) Personnel and Materials & Services expenditures projected to be less than budgeted due to timing of filling positions and savings in the cost of inmates' meals e) Projected variance due to extra help and additional overtime for CHL, Street Crimes and CODE activities Page 3 Fund 701 LED-Countywide Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to ri FY 2013 Year End I I Budget Actual Var iance FY % Coll. % I 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 11,539,305 15,025,021 3,485,716 75% 98% a) 15,385,740 15,642,467 256,727 Tax Revenues - Prior 330,000 701,365 371,365 75% 159% 440,000 701,365 261,365 Federal Grants & Reimb 22,500 24,510 2,010 75% 82% b) 30,000 24,510 (5,490) State Grant 55,500 105,734 50,234 75% 143% c) 74,000 140,448 66,448 Jail Funding HB 2712 - 27,849 27,849 75% n/a d - 46,133 46,133 Transp. of State Wards 3,750 3,289 (461) 75% 66% 5,000 5,000 - SB 1145 1,109,993 1,109,993 0 75% 75% 1,479,991 1,479,991 - Prisoner Housing 37,500 139,501 102,001 75% 279% e) 50,000 185,538 135,538 Des. Cty Video Lottery Grant 3,750 5,000 1,250 75% 100% 5,000 5,000 - Grants - 17,640 17,640 75% n/a - 17,640 17,640 Des Cty Court Security 180,750 77,731 (103,020) 75% 32% f) 241,000 116,597 (124,403) Des Cty Juvenile Contract 3,135 3,462 327 75% 83% 4,180 4,180 - Title III Reimbursement - 26,795 26,795 75% n/a g) - 39,916 39,916 Transport 375 1,520 1,145 75% 304% 500 1,820 1,320 Other 2,625 7,288 4,663 75% 208% 3,500 7,288 3,788 DC Fair & Expo Center 3,000 756 (2,244) 75% 19% 4,000 4,000 - Inmate Commissary Fees 7,500 16,823 9,323 75% 168% 10,000 19,823 9,823 Work Center Work Crews 37,500 32,308 (5,194) 75% 65% 50,000 50,000 - Concealed Handgun Classes 2,625 7,075 4,450 75% 202% 3,500 8,000 4,500 Inmate Telephone Fee 60,000 61,214 1,214 75% 77% 80,000 80,000 - Soc Sec Incentive-Fed 3,750 9,800 6,050 75% 196% 5,000 9,800 4,800 Miscellaneous 3,750 5,828 2,078 75% 117% 5,000 6,628 1,628 Oregon Mentors 750 - (750) 75% 0% 1,000 1,000 - Debit Card Fee 75 409 334 75% 409% 100 500 400 Medical Services Reimb 9,750 10,855 1,105 75% 84% 13,000 13,000 - Restitution 3,750 - (3,750) 75% 0% 5,000 5,000 Sheriff Fees 187,500 216,217 28,717 75% 86% 250,000 250,000 - Interest 21,250 32,046 10,796 75% 113% 28,333 39,666 11,333 Interest on Unsegregated 2,650 1,281 (1,369) 75% 36% 3,533 3,533 - Grants - 3,000 3,000 75% n/a - 3,000 3,000 Donations - "Shop with a Cop" 38,923 50,290 11,367 75% 97% 51,897 51,897 - Land Sale Revenue - 3,309 3,309 75% n/a - 3,309 3,309 Sale of Reportable Assets 3,750 _ 574 (3,176) 75% 11% 5,000 5,000 - Total Revenues 13,675,706 17,728,482 4,052,776 75% 97% 18,234,274 18,972,049 737,775 TOTAL RESOURCES 18,183,058 23,612,445 5,429,387 75% 104% 22,741,626 24,856,011 2,114,385 REQUIREMENTS: EE 9 Fund 255 Departments: Sheriffs Services 1,584,943 1,577,626 7,316 75% 75% 2,113,257 2,113,257 - Civil 599,242 541,887 57,354 75% 68% 798,989 744,889 54,100 Auto/Comm 499,873 528,166 (28,293) 75% 79% 666,497 668,341 (1,844) Adult Jail 8,160,024 7,610,286 549,739 75% 70% 10,880,032 10,425,532 454,500 Court Security 227,251 224,590 2,661 75% 74% 303,001 302,901 100 Emergency Services 145,900 137,245 8,654 75% 71% 194,533 194,433 100 Special Services 698,533 608,291 90,242 75% 65% 931,377 918,944 12,433 Work Center 1,997,309 1,883,488 113,820 75% 71% 2,663,078 2,522,978 140,100 Training 231,507 194,797 36,710 75% 63% 308,676 311,060 (2,384) Other (CODE, Forensic) 482,628 498,827 (16,199) 75% 78% 643,504 683,404 (39,900) Non Dept - ISF Charges 32,034 32,034 (0) 75% 75% 42,712 42,712 - Contingency 2 261 978 - 2,261,978 75% n/a 3,015,970 - 3,015,970 Totdt to Fund 255 18,921,220 0,03t237 3,00,03 22; 16,926,451 3;833;175 Transfer to Reserve Fund (703) 75,000 100,000 (25,000) 75% 100% 100,000 100,000 - Non Dept - Comm System Res 60,000 80,000 (20,000) 75% 100% 80,000 80,000 - Total Requirements 17,056,220 14,017,237 3,038,982 75% 62% 22,741,626 19,108,451 3,633,175 Net 1,126,839 9,595,208 8 468370 - 5,747,560 _ __5 747,560 Beginning Net Working Capital per Proposed Budget 5,541,699 a) Current year taxes due November, February and May b) Less than planned BOJ Criminal Alien Assistance (SCARP) reimbursement c) Unplanned Homeland Security Grant for Engineering Communication System Study d) Unplanned changes at the State level in Circuit Court revenue distribution e) Reimbursement from the State will exceed plan due to higher number of SB 395 inmates f) Changes made at State level in distribution of Circuit Court revenue g) Approved carryover of prior year Title I I I 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 Nine Months Ended March 31, 2013 Year to Date I FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $2,859,915 $3,244,571 $ 384,656 100% 113% $2,859,915 $3,244,571 $ 384,656 Revenues Tax Revenues - Current 5,662,500 7,314,935 1,652,435 75% 97% a) 7,550,000 7,615,538 65,538 Tax Revenues - Prior 172,500 347,472 174,972 75% 151% 230,000 347,472 117,472 Federal Grants & Reimb 11,250 35,037 23,787 75% 234% b) 15,000 35,037 20,037 Federal Grants-BLM 19,500 14,759 (4,741) 75% 57% 26,000 26,000 - US Forest Service 56,250 59,063 2,813 75% 79% 75,000 75,000 Bureau of Reclamation 19,500 18,830 (671) 75% 72% 26,000 26,000 - State Grant 141,896 205,740 63,844 75% 109% c) 189,194 262,800 73,606 SB #1065 Court Assessment 41,250 5,995 (35,255) 75% 11% d) 55,000 5,995 (49,005) Marine Board License Fee 106,568 57,765 (48,803) 75% 41% 142,091 142,091 Des Cty General Fund Grant 432,551 - (432,551) 75% 0% e) 576,735 576,735 Des Cty Transient Room Tax 1,554,949 1,554,949 (0) 75% 75% 2,073,265 2,073,265 - Des Cty Tax Office Contract 375 540 165 75% 108% 500 540 40 Asset Forfeiture - 11,760 11,760 75% n/a - 11,760 11,760 City of Sisters 350,970 351,070 100 75% 75% 467,960 467,960 - Des Cty CDD Contract 40,775 40,775 (0) 75% 75% 54,366 54,366 Des Cty Solid Waste Contr 40,775 40,775 (0) 75% 75% 54,366 54,366 - Des Cty Clerk/Election 750 1,068 318 75% 107% 1,000 1,400 400 School Districts 30,000 15,141 (14,859) 75% 38% 40,000 40,000 - Claims Reimbursement - 860 860 75% n/a - 860 860 Security & Traffic Reimb 3,750 - (3,750) 75% 0% 5,000 5,000 - Seat Belt Program 7,500 4,165 (3,335) 75% 42% 10,000 10,000 - Miscellaneous 4,500 7,758 3,258 75% 129% 6,000 8,000 2,000 False Alarm Fees 1,500 3,200 1,700 75% 160% 2,000 4,000 2,000 Restitution 3,750 1,304 (2,446) 75% 26% 5,000 5,000 - Sheriff Fees 7,500 6,922 (578) 75% 69% 10,000 10,000 Court Fines & Fees 90,000 86,045 (3,955) 75% 72% 120,000 120,000 Impound Fees 3,000 3,600 600 75% 90% 4,000 4,000 Restitution - Street Crimes 375 - (375) 75% 0% 500 500 Seizure/Forfeiture 750 140 (610) 75% 14% 1,000 1,000 - Interest 7,500 15,221 7,721 75% 152% 10,000 17,500 7,500 Interest on Unsegregated 1,350 625 (725) 75% 35% 1,800 1,800 - Grants-Private - 6,500 6,500 75% n/a - 6,500 6,500 Donations 9,120 9,120 75% n/a 9,120 9,120 Land Sale Revenue - 1,611 1,611 75% n/a 1,611 1,611 Sale of Equip & Material 7,500 2,829 (4,671) 75% 28% 10,000 5,000 (5,000) Sale of Reportable Assets 30,000 12,167 17,833 75% 30% f) 40,000 20,000 (20,000) Total Revenues 8,851,335 10,237,739 1,386,406 50% 87% 11,801,777 12,046,217 244 440 TOTALRESOURCES 11,711,250 13,482,310 1,771,062 5o% 92% 14,661,692 15,290,787 629,095 REQUIREMENTS: Exp. % Fund 255 Departments. Sheriffs Services 112,780 112,259 521 75% 75% 150,373 150,373 - Auto/Comm 855,715 904,148 (48,434) 75% 79% 1,140,953 1,144,109 (3,156) Investigations 1,131,135 1,069,348 61,787 75% 71% 1,508,180 1,468,080 40,100 Patrol 6,202,019 6,135,823 66,195 75% 74% 8,269,358 8,169,358 100,000 Records 538,213 519,398 18,815 75% 72% 717,617 677,517 40,100 Special Services 310,995 270,818 40,177 75% 65% 414,660 409,125 5,535 Training 147,206 123,863 23,342 75% 63% 196,274 197,790 (1,516) Non Dept - ISF Charges 31,906 31,906 (0) 75% 75% 42,541 42,541 - Contingency 1,501,302 - 1,501,302 75% n/a 2,001,736 - 2,001,736 e>t~atdty uwi~, 10 31I 9,1 , 2,162,799 Transfer to Reserve Fund (704) 75,000 100,000 (25,000) 75% 100% 100,000 100,000 - Non Dept - Comm System Res 90,000 120,000 30,000 75% 100% 120,000 120,000 Total Requirements 10,996,269 9,387,564 1,608,705 75% 64% 14,661,692 12,478,893 2,182,799 Net 714,981 4,094,746 3,379,765 - 2,811,894 2,811194 Beginning Net Working Capital per Proposed Budget 2,620,213 a) Current year taxes due November, February and May b) JAG grant for 800 MHz radios c) Homeland Security grant Communication System Engineering Study d) Changes made at State level in distribution of Circuit Court revenue e) Will be received June 2013 Page 5 f) Less than planned revenue from sale of surplus vehicles Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Nine Months Ended March 31, 20 13 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,336,051 $ 1,327,199 $ (8,852) 100% 99% $1,336,051 $1,327,199 $ (8,852) Revenues Medicare Reimbursement 750 8 (742) 75% 1% 1,000 100 (900) Federal Grant - 9,000 9,000 75% n/a - 9,000 9,000 Federal Grant (ARRA) 150,000 106,250 (43,750) 75% 53% 200,000 212,500 12,500 State Grant 2,185,762 2,033,002 (152,760) 75% 70% 2,914,349 2,934,303 19,954 Child Dev & Rehab Center 29,707 16,360 (13,347) 75% 41% a) 39,609 39,609 - State Miscellaneous 101,055 86,551 (14,504) 75% 64% a) 134,740 134,740 - OMAP 470,691 393,338 (77,353) 75% 63% 627,588 608,494 (19,094) Title 19 264 - (264) 75% n/a 352 - (352) Family Planning Exp Proj 412,500 353,682 (58,818) 75% 64% 550,000 550,000 - Local Grants 36,000 10,000 (26,000) 75% 21% 48,000 55,200 7,200 Environmental Health-Water 69,150 49,648 (19,502) 75% 54% 92,200 92,200 - Contract Payments 77,858 104,380 26,522 75% n/a 103,810 158,354 54,544 Miscellaneous - 2,170 2,170 75% n/a - 3,000 3,000 Patient Insurance Fees 144,900 161,920 17,020 75% 84% 193,200 193,200 - Health Dept/Patient Fees 77,325 69,696 (7,629) 75% 68% 103,100 85,000 (18,100) Vital Records-Birth 30,750 24,475 (6,275) 75% 60% 41,000 32,000 (9,000) Vital Records-Death 75,000 75,425 425 75% 75% 100,000 100,000 - Environmental Health-Lic Fac 540,038 688,578 148,540 75% 96% b) 720,050 740,050 20,000 Interest on Investments 9,000 4,385 (4,615) 75% 37% 12,000 5,800 (6,200) Grants-private 12,657 33,753 21,096 75% 200% 16,876 34,000 17,124 Donations 3,975 19,216 15,241 75% 363% 5,300 22,277 16,977 InterFund Contract 118,972 81,850 (37,122) 75% 52% 158,629 164,000 5,371 Administrative Fee 600 600 0 75% 75% 800 800 - Total Revenues 4,546,954 4,324,287 (222,667) 75% 71% 6,062,603 6,174,627 112,024 Transfers In-General Fund 1,762,020 1,762,020 - 75% 75% 2,349,357 2,349,357 - Transfers In-PH Res Fund 45,102 45,102 - 75% 75% 60,136 60,136 - Transfers In-Gen. Fund Other 48,825 48,825 - 75% 75% 65,100 65,100 - TOTAL RESOURCES 7,738,952 7,507,433 (231,519) 75% 76% 9,873,247 9,976,419 103,172 REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 4,841,029 4,707,832 133,197 75% 73% 6,454,705 6,282,220 172,485 1,606,409 1,372,052 234,357 75% 64% 2,141,878 2,136,883 4,995 48,750 - 48,750 75% 0% c) 65,000 - 65,000 117,900 117,900 - 75% 75% 157,200 157,200 - 790,848 - 790,848 75% n/a 1,054,464 - 1,054,464 7,404,936 6,197,784 1,207,152 75% 63% 334,016 1,309,649 975,633 Beginning Net Working Capital per Proposed Budget a) Received quarterly in arrears b) Restaurant and Pool/Spa fees are due annually and received in Dec/Jan c) OCHIN System expenditure made in FY 2012 9,873,247 8,576,303 1,296,944 1,400,116 1,400,116 1,385,592 Page 6 BEHAVIORAL HEALTH Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Domestic Partnership Fee Federal Grants Federal Grant (ARRA) State Grants State Miscellaneous Adult Mental Health Initiative Title 19 Liquor Revenue School Districts Contract Payments Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Forfeitures Administrative Fee Interfund Contract-Gen Fund Year to Date Budget Actual Variance FY % Coll. % $3,320,968 $ 3,113,095 $ (207,873) 100% 4,875 4,080 (795) 120,000 92,258 (27,742) 34 65 31 189,262 124,784 (64,478) 47,813 21,250 (26,563) 5,846,699 5,520,835 (325,864) 46,395 26,306 (20,089) 150,000 229,038 79,038 202,085 69,011 (133,074) 106,125 79,479 (26,646) 51,750 14,400 (37,350) - 34 34 - 11,866 11,866 65,649 69,836 4,187 713 1,190 477 18,750 15,221 (3,529) 13,875 11,125 (2,750) - 140 140 3,969,395 3,901,430 (67,965) 95,250 78,084 (17,16 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% FY 2013 Year End Bud et Projection Variance 94% $ 3,320,968 $ 3,113,095 $ (207,873) 63% 6,500 6,500 - 58% 160,000 125,056 (34,944) 144% 45 100 55 49% a) 252,349 252,349 - 33% 63,750 63,750 - 71% b) 7,795,599 7,883,477 87,878 43% 61,860 61,860 - 115% 200,000 230,000 30,000 26% 269,446 125,000 (144,446) 56% 141,500 120,000 (21,500) 21% c) 69,000 14,400 (54,600) n/a - 100 100 n/a - 12,000 12,000 80% 87,532 130,000 42,468 125% 950 1,500 550 61% 25,000 20,500 (4,500) 60% 18,500 18,500 - n/a - 140 140 74% 5,292,527 5,292,527 - 61% a) 127,000 127,000 - Total Revenues 10,928,670 10,270,431 (658,239) 75% 70% 14,571,558 14,484,759 (86,799) Transfers In-General Fund 980,840 980,840 - 75% 75% 1,307,787 1,307,787 - Transfers In-OHP-CDO 363,371 363,371 - 75% 75% 484,494 484,494 - Transfers In-Acute Care Svcs 198,477 198,477 - 75% 75% 264,631 264,631 - Transfers In-ABHA 393,030 393,030 - 75% 75% 524,039 524,039 - TOTAL RESOURCES 16,185,356 15,319,244 (866,112) 75% 75% 20,473,477 20,178,805 (294,672) REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 8,670,527 8,075,804 594,723 75% 70% 11,560,702 4,952,216 4,129,188 823,028 75% 63% 6,602,955 37,575 (33,417) 70,992 75% -67% 50,100 153,000 153,000 - 75% 75% 204,000 1,541,790 - 1,541,790 75% n/a 2,055,720 15,355,108 12,324,575 3,030,533 75% 60% 830,248 2,994,669 2,164,422 Beginning Net Working Capital per Proposed Budget a) Received quarterly, in arrears b) Oregon Health Authority grant projected at amended contract amount c) Contract for services to school districts terminated by mutual agreement 10,800,000 760,702 5,850,000 752,955 30,000 20,100 204,000 - - 2,055,720 20,473,477 16,884,000 3,589,477 - 3,294,805 3,294,805 3,461,651 Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Planning-Current Planning-Long Range Total Revenues Transfers In General Fund - Gen Ops General Fund - UR Planning A&T Reserve (D/S assistance) Other TOTAL RESOURCES Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 16,568 21,695 5,127 75% 98% 22,090 24,483 2,393 938 543 (396) 75% 43% a) 1,250 1,000 (250) 124,650 159,516 34,866 75% 96% 166,200 178,000 11,800 955,181 1,020,615 65,434 75% 80% 1,273,575 1,190,747 (82,828) 192,000 225,517 33,517 75% 88% 256,000 268,496 12,496 83,700 87,063 3,363 75% 78% 111,600 184,800 73,200 234,728 219,202 (15,526) 75% 70% 312,971 283,140 (29,831) 478,013 494,227 16,214 75% 78% 637,350 613,255 (24,095) 169,816 223,787 53,971 75% 99% 226,421 266,897 40,476 2,255,594 2,452,165 196,571 75% 82% 3,007,457 3,010,818 3,361 641,151 641,151 - 75% 75% 854,872 854,872 - 371,520 371,520 - 75% 75% 495,360 495,360 - 67,183 85,409 18,226 75% 95% 89,577 89,577 - 75 - 75 75% 0% 100 - 100 3,345,523 3,742,727 397,204 75% 84% 4,457,366 4,643,109 185,743 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 1,014,892 984,572 30,320 Admin-GIS 88,334 84,785 3,549 Admin-Code Enforcement 171,694 156,789 14,905 Building Safety 465,815 450,265 15,550 Electrical 152,423 149,282 3,141 Contract Services 106,309 113,783 (7,474) Env Health-On Site Pgm 119,727 113,945 5,782 Planning-Current 481,736 429,993 51,743 Planning-Long Range 347,551 276,985 70,566 Transfers Out (D/S Fund) 134,366 170,818 (36,452) Contingency 260,178 - 260,178 TOTAL REQUIREMENTS NET (Resources - Requirements) EXp. 75% 73% b) 1,353,189 1,311,323 41,866 75% 72% 117,778 117,778 - 75% 68% b) 228,925 216,747 12,178 75% 72% 621,087 621,087 - 75% 73% 203,231 203,231 - 75% 80% 141,745 141,745 - 75% 71% 159,636 159,636 - 75% 67% c) 642,315 634,887 7,428 75% 60% c,d) 463,401 349,567 113,834 75% 95% 179,155 179,155 - 75% n/a 346,904 - 346,904 3,343,025 2,931,215 411,810 75% 66% 2,498 811,511 809 013 Beginning Net Working Capital per Proposed Budget 4,457,366 3,935,156 522,210 - 707,953 707,953 696,290 Revenues 2,452,165 3,007,457 3,010,818 3,361 Expenditures 2,931,215 4,457,366 3,935,156 522,210 Net from Operations (4791051) (1,449,909) (924,338) 525,571 a) Revenue is sporadic throughout the year as GIS services are requested b) Reflects savings due to CD Director's appointment as County Administrator through 6/30/13 c) Reflects savings due to Planning Director's reduced allocation through 6130/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 Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues System Development Charge Federal Grant (ARRA) Mineral Lease Royalties Forest Receipts State Grant State Miscellaneous Motor Vehicle Revenue City of Bend City of Redmond City of Sisters City of La Pine Admin Recovery (SDC) Miscellaneous Road Vacations Interest on Investments Grants-Private Interfund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Forester Car Washes Car Rental Sale of Equip & Material Total Revenues Trans In - Solid Waste Trans In - Transp SDC Trans In-Road Imp Res TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS Year to Date FY 2013 Year End Bud et Actual Variance FY % CoU. % Budget Projection Variance $4,719,551 $ 4,723,852 $ 4,301 100% 100% $4,719,551 $4,723,852 $ 4,301 - 2,310 2,310 75% n/a - 3,000 3,000 5,250 7,335 2,085 75% 105% 7,000 7,335 335 30,000 133,186 103,186 75% 333% 40,000 140,000 100,000 297,620 1,265,121 967,501 75% 319% a) 396,826 1,265,121 868,295 - 2,618 2,618 75% n/a - 2,618 2,618 406,718 542,290 135,572 75% 1oo% b) 542,290 542,290 - 8,092,532 8,065,482 (27,050) 75% 75% c) 10,790,043 10,450,000 (340,043) 18,750 - (18,750) 75% 0% d) 25,000 309,350 284,350 262,500 10,807 (251,693) 75% 3% d) 350,000 387,240 37,240 7,500 - (7,500) 75% 0% d) 10,000 2,000 (8,000) 7,500 10,000 2,500 75% 100% d) 10,000 10,000 - - 2,174 2,174 75% n/a - 2,500 2,500 15,000 18,537 3,537 75% 93% 20,000 20,000 - 750 - (750) 75% 0% 1,000 500 (500) 11,250 23,016 11,766 75% 153% 15,000 32,000 17,000 - 1,948 1,948 75% n/a - 1,948 1,948 517,500 - (517,500) 75% 0% e) 690,000 590,000 (100,000) 165,000 155,205 (9,795) 75% 71% 220,000 185,000 (35,000) 67,500 - (67,500) 75% 0% e) 90,000 80,000 (10,000) 7,500 - (7,500) 75% 0% f) 10,000 - (10,000) 18,750 - (18,750) 75% 0% e) 25,000 50,000 25,000 18,750 - (18,750) 75% 0% e) 25,000 25,000 - 3,000 1,612 (1,388) 75% 40% 4,000 4,000 - 750 284 (466) 75% 28% 1,000 1,000 - 542,700 655,332 112,632 75% 91% 723,600 823,851 100,251 10,496,820 10,897,257 400,437 75% 78% 13,995,759 14,934,753 938,994 207,204 207,204 - 75% 75% g) 276,272 276,272 - 187,500 - (187,500) 75% 0% f) 250,000 - (250,000) 9,000 - (9,000) 75% 0% 0 12,000 - (12,000) 15,620,075 15,828,313 395,738 75% 81% 19,253,582 19,934,877 681,295 Exp. 4,023,902 4,025,156 (1,254) 75% 75% h) 5,365,202 5,310,875 54,327 7,078,997 4,641,767 2,437,230 75% 49% i) 9,438,662 8,144,702 1,293,960 1,527,975 9,826 1,518,149 75% o% j) 2,037,300 73,884 1,963,416 206,250 275,000 (68,750) 75% 100% 275,000 275,000 - 1,603,064 - 1,603,064 75% n/a 2,137,418 - 2,137,418 14,440,188 8,951,749 5,488,439 75% 46% NET (Resources - Requirements) 1,179,887 6,876,564 5,884,177 Beginning Net Working Capital per Proposed Budget a) Payment received annually in January b) Payment received annually in October c) Actual receipts are lower than projections d) Billed upon completion of work e) Payments to be received in June 2013 from other Road Department funds f) No SDC qualifying projects in FY 2013; no resources will be transferred in from SDC fund g) Payments made quarterly h) Retro COLA raises for 701 members, early retirement and resignations i) Expenditures are seasonal and higher during summer months j) CIP project reserve carry over FY 2014 19,253, 582 13, 804,461 5,449,121 - 6,130,416 6,130,416 s,n1a,36a Page 9 ADULT PAROLE & PROBATION Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 570,000 $ 630,226 $ 60,226 100% 111% $ 570,000 $ 630,226 $ 60,226 Revenues DOC Measure 57 164,430 219,240 54,810 75% 100% a) 219,240 219,240 - State Miscellaneous 3,226 - (3,226) 75% 0% b) 4,301 4,301 - Alternate Incarceration 11,250 - (11,250) 75% 0% c) 15,000 (15,000) State Subsidy 10,370 18,872 8,502 75% 136% d) 13,826 21,826 8,000 SB 1145 2,061,416 2,061,416 0 75% 75% 2,748,556 2,748,556 - Probation Work Crew Fees 16,875 9,725 (7,150) 75% 43% e) 22,500 14,180 (8,320) Miscellaneous 3,375 4,089 714 75% 91% 4,500 4,500 - Electronic Monitoring Fee 97,500 124,239 26,739 75% 96% f) 130,000 153,257 23,257 Probation Superv. Fees 142,500 133,339 (9,161) 75% 70% 190,000 172,380 (17,620) Interest on Investments 6,750 4,268 (2,482) 75% 47% 9,000 9,000 - Interfund - Sheriff 37,500 37,500 0 75% 75% 50,000 50,000 - Sale of Equipment - 250 250 75% n/a - 250 250 Crime Prevention Grant 37,500 25,000 (12,500) 75% 50% g) 50,000 50,000 - CFC-Domestic Violence 56,124 28,785 X27,339 75% 38% g) 74,832 74,832 - Total Revenues 2,648,816 2,666,722 17,906 75% 76% 3,531,755 3,522,322 (9,433) Transfers In-General Fund 326,493 326,493 - 75% 75% 435,328 435,328 - TOTAL RESOURCES 3,545,309 3,623,441 78,132 75% 80% 4,537,083 4,587,876 50,793 REQUIREMENTS: EXp. Expenditures Personnel Services 2,318,468 2,188,417 130,051 75% 71% 3,091,291 3,041,291 50,000 Materials and Services 667,265 614,067 53,198 75% 69% 889,687 889,687 - Capital Outlay 75 - 75 75% 0% 100 - 100 Contingency 417,004 - 417,004 75% n/a 556,005 - 556,005 TOTAL REQUIREMENTS 3,402,812 2,802,484 600,328 75% 62% 4,537,083 3,930,978 606,105 NET (Resources - Requirements) 142,497 820,957 678,460 - 656,898 656,898 Beginning Net Working Capital per Proposed Budget 707,953 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) Received a one time only $8000 distribution in addition to quarterly payments e) Present economy has resulted in clients working off fees rather than paying f) Increased use of Electronic Monitoring pre-trial in lieu of jail g) State/County invoiced quarterly-3rd quarter payment not yet received Page 10 CHILDREN & FAMILIES COMMISSION Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 13 Year End Budget Actual Variance FY % Call. % L Budget Projection Variance 4 -To T1:19_: &I Beg. Net Working Capital $ 511,994 $ 567,120 $ 55,126 100% 111% $ 511,994 $ 567,120 $ 55,126 Revenues Federal Grants 228,417 132,015 (96,402) 75% 43% a) 304,556 251,856 (52,700) Title IV- Family Sup/Pres 29,650 28,545 (1,105) 75% 72% 39,533 39,533 - HealthyStart Medicaid 63,750 44,234 (19,516) 75% 52% a) 85,000 85,000 - Youth Investment 147,674 154,986 7,312 75% 79% 196,898 196,897 (1) State Prevention Funds 36,092 46,839 10,747 75% 97% b) 48,122 58,022 9,900 HealthyStart /R-S-G 164,961 164,961 - 75% 75% 219,951 219,951 - OCCF Grant 314,847 296,149 (18,698) 75% 71% a) 419,796 391,940 (27,856) Charges for Svcs-Misc 6,000 2,051 (3,949) 75% 26% 8,000 4,000 (4,000) Program Fees - 4,765 4,765 75% n/a - 4,765 4,765 Court Fines & Fees 59,614 55,531 (4,083) 75% 70% c) 79,485 75,034 (4,451) Interest on Investments 750 2,780 2,030 75% 278% 1,000 5,000 4,000 Grants, Private 1,500 - (1,500) 75% n/a 2,000 - (2,000) Interfund Grants 240,656 247,718 7,062 75% 77% d) 320,874 350,374 29,500 Total Revenues 1,293,911 1,180,575 (113,336) 75% 68% 1,725,215 1,682,372 (42,843) Trans from General Fund 207,000 207,000 - 75% 75% 275,984 275,984 - Total Transfers In 207,000 207,000 - 75% 75% 275,984 275,984 - TOTAL RESOURCES 2,012,905 1,954,695 (58,210) 75% 78% 2,513,193 2,525,477 12,284 REQUIREMENTS: Exp. Expenditures Personnel Services 485,606 434,074 51,532 75% 67% e) 647,474 567,051 80,423 Materials and Services 1,180,107 740,919 439,188 75% 47% f) 1,573,476 1,561,808 11,668 Capital Outlay 75 - 75 75% 0% 100 - 100 Contingency 219,107 - 219,107 75% n/a 292,143 292,143 TOTAL REQUIREMENTS 1,884,895 1,174,993 709,903 NET (Resources - Requirements) 128,010 779,703 651,693 Beginning Net Working Capital per Proposed Budget 75% 47% 2,513,193 2,128,859 384,334 - 396,618 396,618 375,704 a) Projection based on actual awarded amounts-Medicaid reimbursements increased 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 positions 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 Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 Revenues Miscellaneous 16,500 13,603 (2,897) 75% 62% 22,000 22,000 - Franchise 3% Fees 150,000 87,834 (62,166) 75% 44% a) 200,000 200,000 - Commercial Disp. Fees 645,000 719,168 74,168 75% 84% 860,000 940,000 80,000 Private Disposal Fees 985,500 978,009 (7,491) 75% 74% 1,314,000 1,290,000 (24,000) Franchise Disposal Fees 3,000,000 3,023,002 23,002 75% 76% 4,000,000 4,035,000 35,000 Yard Debris 54,750 72,691 17,941 75% 100% b) 73,000 85,000 12,000 Special Waste 18,750 62,109 43,359 75% 248% c) 25,000 70,000 45,000 Interest 5,625 5,997 372 75% 80% 7,500 8,000 500 Leases 8,100 9,001 901 75% 83% 10,801 10,801 - Donations - 1,680 1,680 75% n/a - 1,680 1,680 Sale of Assets - 1,451 1,451 75% n/a - 1,451 1,451 Recyclables 33,750 31,993 (1,757 75% 71% 45,000 42,000 3,000 Total Revenues 4,917,975 5,006,539 88,564 75% 76% 6,557,301 6,705,932 148,631 TOTAL RESOURCES 5,618,488 5,814,010 195,521 75% 80% 7,257,814 7,513,403 255,589 REQUIREMENTS Exp. Expenditures Personnel Services 1,299,991 1,239,228 60,763 75% 71% 1,733,321 1,707,324 25,997 Materials and Services 2,241,985 1,860,874 381,111 75% 62% d) 2,989,313 3,047,103 (57,790) Debt Service 710,035 405,589 304,446 75% 43% e) 946,713 946,713 - Capital Outlay 62,250 62,020 230 75% 75% 83,000 80,336 2,664 Transfers Out Road 207,204 207,204 - 75% 75% 276,272 276,272 - Capital Reserve 472,500 630,000 (157,500) 75% 100% f) 630,000 630,000 - Contingency 449,396 - 449,396 75% n/a 599,195 599,195 TOTAL REQUIREMENTS 5,443,361 4,404,915 1,038,446 75% 61% 7,257,814 6,687,748 570,066 NET (Resources - Requirements) 175,127 1,409,095 1,233,967 - 825,655 825,655 Beginning Net Working Capital per Proposed Budget 825,655 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) All of FY 2013 budgeted transfer made because resources needed for Fund 613's capital projects Page 12 RISK MANAGEMENT Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date Year End Budget Actual Variance % of FY % Coll. Budget Projection Variance RESOURCES: Beginning Net Working Capital $2,000,000 $2,240,791 $240,791 Revenues Inter-fund Charges: General Liability 196,750 196,750 0 Property Damage 235,110 235,110 0 Vehicle 130,226 130,226 (0) Workers' Compensation 1,080,132 1,080,132 0 Unemployment 187,500 187,615 115 Claims Reimb-Workers' Compensation 375 - (375) Claims Reimb-Gen Liab/Property 45,000 30,143 (14,857) Process Fee-Events/Parades 1,500 425 (1,075) Miscellaneous 38 37 (1) Skid Car Training 12,000 17,840 5,840 NSF Fee - 30 30 Interest on Investments 11,250 8,887 (2,363) Other Interest 38 - 38 TOTAL REVENUES 1,899,918 1,887,195 (12,723) TOTAL RESOURCES 3,899,918 4,127,986 228,068 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement / Benefit 370,803 5202 Defense 40,708 5203 Professional Service 57,723 5204 Insurance 138,350 5205 Loss Prevention 8,630 5206 Miscellaneous 45 5207 Repair/ Replacement 200 Total General Liability 225,000 616,459 (391,459) PROPERTY DAMAGE 5204 Insurance 159,171 5207 Repair / Replacement 48,484 Total Property Damage 187,500 207,655 (20,155) VEHICLE 5203 Professional Service 5204 Insurance 366 5205 Loss Prevention 11,876 5207 Repair / Replacement 32,897 Total Vehicle 75,000 45,139 29,861 WORKERS' COMPENSATION 5201 Settlement / Benefit 275,510 5203 Professional Service - 5204 Insurance 121,532 5205 Loss Prevention 25,360 5206 Miscellaneous 22,086 Total Workers' Compensation 750,000 444,488 305,512 5201 UNEMPLOYMENT - Settlement/Benefits 187,500 93,403 _ 94,097 Total Direct Insurance Costs 1,425,000 1,407,144 17,856 Insurance Administration: Personnel Services Materials & Service Capital Outlay Total Insurance Administration Transfers Out TOTAL REQUIREMENTS NET Beginning Net Working Capital pei a) Annual premium paid in July 2012 * Contingency is $2,149,038 230,922 222,345 8,577 126,743 92,167 34,576 75 - 75 357,740 314,511 43,228 5,400 5,400 - 1,788,140 1,727,056 61,084 2,111,779 21400,930 289,151 Proposed Budget 100% 112% $2,000,000 $2,240,791 $240,791 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 75% 0% 75% 50% 75% 21% 75% 74% 75% 112% 75% n/a 75% 59% 75% 0% 75% 74% 75% 91% Ex . a) 75% 205% a) 75% 83% 75% 45% a) 262,333 262,333 - 313,480 313,480 - 173,635 173,635 - 1,440,176 1,440,176 - 250,000 250,000 - 500 500 - 60,000 60,000 - 2,000 2,000 - 50 50 - 16,000 17,840 1,840 - 60 60 15,000 12,000 (3,000) 50 50 - 2,533,224 2,532,124 (11100) 4,533,224 4,772,915 239,691 300,000 700,000 (400,000) 250,000 230,000 20,000 100,000 60,000 40,000 75% 44% 1,000,000 534,488 465,512 75% 37% 250,000 230,000 20,000 75% 74% 1,900,000 1,754,488 145,512 75% 72% 307,896 307,896 - 75% 55% 168,990 168,990 - 75% 0% 100 - 100 75% 66% 476,986 476,886 100 75% 75% 7,200 7,200 - 75% 72% 2,384,186 2,238,574 145,612 * 2,149,038 2,534,341 385,303 2,517,479 Page 13 DESCHUTES COUNTY 911 Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance % of FY % Coll. Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 8,000,000 $ 8,883,086 $ 883,086 100% 111% $ 8,000,000 $ 8,883,086 $ 883,086 Revenues Property Taxes - Current 4,910,765 6,009,016 1,098,251 75% 92% a) 6,547,687 6,256,420 (291,267) Property Taxes - Prior 138,750 275,937 137,187 75% 149% 185,000 279,126 94,126 Federal Grants 180,000 - (180,000) 75% 0% b) 240,000 240,000 - State Reimbursement 27,000 17,729 (9,271) 75% 49% c) 36,000 36,000 - Telephone User Tax 562,500 383,681 (178,819) 75% 51% 750,000 767,242 17,242 Data Network Reimb. 22,500 25,030 2,530 75% 83% d) 30,000 43,804 13,804 Jefferson County 22,500 28,819 6,319 75% 96% 30,000 31,262 1,262 User Fee 33,000 4,313 (28,687) 75% 10% e) 44,000 44,000 - Police RMS User Fees 209,213 210,958 1,745 75% 76% f) 278,950 252,000 (26,950) Contract Payments 23,250 1,988 (21,262) 75% 6% g) 31,000 1,988 (29,012) Miscellaneous 6,750 7,793 1,043 75% 87% 9,000 9,000 - Claims Reimbursement - 46,760 46,760 75% n/a h) - 46,760 46,760 Interest 30,000 39,694 9,694 75% 99% 40,000 50,000 10,000 Interest on Unsegregated Tax 450 514 64 75% 86% 600 600 - Total Revenues 6,166,678 7,052,231 885,553 75% 66% 8,222,237 8,058,202 (164,035) TOTAL RESOURCES 14,166,678 15,935,317 1,768,639 75% 98% 16,222,237 16,941,288 719,051 REQUIREMENTS: % Exp. Expenditures Personnel Services 3,255,368 2,923,111 332,257 75% 67% 4,340,490 4,000,000 340,490 Materials and Services 1,537,652 1,323,977 213,675 75% 65% 2,050,202 2,050,202 - Capital Outlay 421,500 46,514 374,986 75% 8% 562,000 562,000 - Transfers Out-Reserve Fund 375,000 500,000 (125,000) 75% 100% i) 500,000 500,000 - Contingency 6,577,159 - 6,577,159 75% n/a 8,769,545 - 8,769,545 TOTAL REQUIREMENTS 12,166,679 4,793,602 7,373,077 75% 30% 16,222,237 7,112,202 9,110,035 NET (Resources - Requirements) 1,999,999 11,141,715 9,141,716 - 9,829,086 9,829,086 Beginning Net Working Capital per Proposed Budget 9,800,000 a) Current year taxes due November, February and May b) ODOT Project-reimbursements expected to be received over the next 2-3 months c) Jan/Feb payments outstanding; ongoing monthly reimbursements from Office of Emergency Mgmt for MSAG/GIS maintenance d) Annual billings are arriving from Police/Fire agencies e) US Forest Service invoiced $2,156.25 quarterly. Crooked River Ranch billed annually end of June f) RMS - Projection reduced to reflect actuals & the $29,103 expected from agency billings g) Protection reduced to reflect $29K now included in Police RMS User Fees line item h) Reimbursement for faulty UPS - American Power Conversion i) Amount appropriated was transferred September 15, 2012 Page 14 Health Benefits Trust Statement of Financial Operating Data Nine Months Ended March 31, 2013 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 Prescription Rebates Claims Reimbursements Vending Machines (Wellness Rebate) Interest Total Revenues Year to Date FY 2013 Budget Actual Variance FY % Coil. % Bud et Projection Variance $13,800,000 $ 14,551,028 $ 751,028 100% 105% $ 13,800,000 $14,551,028 751,028 9,596,250 9,653,233 56,983 75% 75% 12,795,000 12,871,238 76,238 37,500 23,994 (13,506) 75% 48% 50,000 33,000 (17,000) 472,500 478,625 6,125 75% 76% 630,000 638,000 8,000 975,000 1,055,396 80,396 75% 81% 1,300,000 1,400,000 100,000 562,500 694,291 131,791 75% 93% 750,000 930,000 180,000 - 441 441 75% n/a - 441 441 66,836 66,836 75% n/a 66,836 66,836 - 50,493 50,493 75% n/a 50,493 50,493 - 222 222 75% n/a - 222 222 60,000 55,310 (4.690) 75% 69% T 80,000 73,000 (7,000) 11,703,750 12,078,841 375,091 75% 77% 15,605,000 16,063,231 458,231 TOTAL RESOURCES 25,503,750 26,629,869 1,126,119 REQUIREMENTS Expenditures: Personnel Services (all depts) 150,579 148,139 2,440 Materials & Services Claims Paid-Medical 7,522,650 8,894,268 (1,371,618) Claims Paid-Prescription 1,442,700 801,742 640,958 Claims Paid-Dental/Vision 1,339,650 1,379,543 (39,893) Claims Refunds - (98,752) 98,752 Insurance Premiums 262,500 252,771 9,729 State Assessments 120,000 194,510 (74,510) Administration Fee 240,000 250,309 (10,309) Preferred Provider Fee 37,500 38,088 (588) Health Impact 41,250 39,151 2,099 Refund - ERRP - 58,552 (58,552) Other - Administration 49,015 36,056 12,959 Other - Wellness 78,750 25,681 53,069 Admin & Wellness 11,134,015 11,871,919 (737,905) Deschutes On-site Clinic Contracted Services 513,000 628,359 (115,359) Medical Supplies 22,500 17,543 4,957 Equipment 750 2,170 (1,420) Other 16,075 31,665 15,590 Total DOC 552,325 679,737 (127,412) Deschutes On-site Pharmacy Contracted Services 231,215 288,374 (57,159) Medication and Drugs 750,000 1,061,838 (311,838) Start Up Costs-Take Care - 59,898 59,898 Other 12,419 13,304 (884) Total Pharmacy 993,635 1,423,413 (429,779) Contingency 9,223,197 - 9,223,197 TOTAL EXPEND/REQUIREMNTS 21,060,116 14,123,208 7,930,542 NET (Resources - Requirements) 4,443,635 12 506 661 9,056,661 Net 92% 104% 29,4053000 30,614,258 1,209,258 Exp. 75% 74% 200,772 200,772 - 75% 89% a) 10,030,200 11,911,781 (1,881,581) 75% 42% 8) 1,923,600 1,044,979 878,621 75% 77% a) 1,786,200 1,844,173 (57,973) 75% n/a - (98,752) 98,752 75% 72% 350,000 350,000 - 75% 122% 160,000 194,510 (34,510) 75% 78% 320,000 320,000 75% 76% 50,000 50,000 75% 71% 55,000 55,000 75% n/a b) - 58,552 (58,552) 75% 55% 65,355 65,353 - 75% 24% 105,000 55,000 50,000 75% 80% 14,845,353 15,850,596 (1,005,243) 75% 92% c) 684,000 786,719 (102,719) 75% 58% 30,000 17,543 12,457 75% 217% 1,000 2,170 (1,170) 75% 148% 21,433 36,000 (14,567) 75% 92% 736,433 842,432 (105,999) 75% 94% c) 308,287 343,325 (35,038) 75% 106% C) 1,000,000 1,500,000 (500,000) 75% n/a C) - 59,898 (59,898) 75% n/a 16,559 30,000 (13,441) 75% n/a 1,324,846 1,933,223 (608,377) 75% n/a 12,297,596 - 12,297,596 75% 48% 29,405,000 18,827,023 10,577,977 11,787,235 11,787, 235 Percentage of Expenditures covered by Revenues a) Projection based on historical data b) Disallowance of Early Retiree Reinsurance Program items (Reported as revenue in FY 2012) c) YTD Actual include accruals - February actual paid in April and March accrual based on February actual Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Receipts: Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Interfund Contract Miscellaneous Total Receipts Transfers In General Fund (001) Room Tax (160) Welcome Center (170) Reserve Fund (617) Annual County Fair (619) Total Transfers In TOTAL RESOURCES REQUIREMENTS: Expenditures: Personnel Services Materials and Services Debt Service Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Budget (7/12 of annual) Actual Variance FY % Con. Year End FY 2013 Budget Projection Variance $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) 455,684 237,014 (218,669) 75% 39% 607,578 417,014 (190,564) 1,125 (105) (1,230) 75% -7% 1,500 270 (1,230) 43,081 22,401 (20,680) 75% 39% 57,441 22,401 (35,040) 4,500 4,900 400 75% 82% 6,000 10,900 4,900 22,500 19,810 (2,691) 75% 66% 30,000 43,810 13,810 142,500 97,313 (45,187) 75% 51% 190,000 150,313 (39,687) 71,250 33,338 (37,912) 75% 35% 95,000 89,338 (5,662) 15,000 1,800 (13,200) 75% 9% 20,000 20,000 - 5,100 2,534 2,566) 75% n/a 6,800 5,234 1,566 760,739 419,005 (341,736) 75% 41% 1,014,319 759,280 (255,039) 127,500 202,503 - 75% 119% a) 170,000 320,000 150,000 19,308 19,305 - 75% 75% 25,744 25,744 - 62,100 62,100 - 75% 75% 82,800 82,800 - b) - 50,000 50,000 198,194 207,000 8,806 75% 78% 264,259 245,000 19,259 407,102 490,908 8,806 542,803 723,544 180,741 1,214,215 944,968 (269,247) 75% 59% 1,603,495 1,517,878 (85,617) Exp. 623,912 604,089 19,822 75% 73% 831,882 812,109 19,773 379,667 403,398 (23,731) 75% 80% 506,223 551,175 (44,952) 85,589 70,609 14,981 75% 62% 114,119 114,119 - 10,694 9,000 1,694 75% 63% 14,259 9,000 5,259 1,099,862 1,087,096 12,766 1,466,483 1,486,404 (19,921) 102,759 - 102,759 75% n/a 137,012 - 137,012 1,202,621 1,087,096 115,525 75% 68% 1,603,495 1,486,404 117,091 NET (Resources - Requirements) 11,593 142,128 153,721 Beginning Net Working Capital per Proposed Budget a) $100,000 budgeted as Transfer GF to Reserve fund will instead be transferred to Operating Fund and an additional $50,000 will be transferred from the General Fund b) $50,000 will be transferred from the F & E Reserve fund, pending the adoption of a supplemental budget 31,474 31,474 48,827 Page 16 H v w ti 0 a a a H a U U 0 0 z U U a~ a~ a~ C z3 N M CO C U [a to O O U C ~ ❑ O C ~ O 'C oa O z C i 1 1 1 I I a M d00 ~ d O LAM COD r O d d q P -J O N Lo CD M ~ CD N O r M r IM C"1 on r M OO 0 0 'Or ~ O O C? O I'ti O N Lt) Q M O 0 N O r CO r Ign In c~ C) 0 0 0 0 W U U r ' d d O O O U N 0 N C 0 O a 1-: LEI 1 1 1 1 I I C') d d O M r O O Lo w ' O O d 0 0 N 0 O CD M Q N ~ r N .O-. O LO U y U Q C W N CD cq N r r -0 -0 Cj O O LL LL C 0 y E a C ` U) -D W Z U O O LL (D j O U IM v to 0 C U Q C O U U 7 A L L ~ O E- C o G rn a~ - wd ~m-JLL'~I-- ~h 1 1 1 1 1 N N 1 1 1 0 0 0 0 0 m m M CD M 0 C) n ~ N 0 0 0 r d 0 0 Lo pmLoc3 GO NO N h r r` N CD CD Q Q M LO ~ M r M Il 0 0 LO 00 Lo rO r q O r O d ' r 0 0 0 in in Cr) Lo 00 N d C4 N fl- r f~ N O 00 0 m LO ~ M r-- r M ~ in to W r N ti co M m co CA It It f- ' Cl CA CD c O N N co ° O o 0 r r 0 (D 1 1 1 1 1 1 1 1 L6 Ld N N ~ CD ( N fl- N ' N ( D C O O N r O Itt I,- N N Lo r r 1,- 0 r 0 r ~ fA rn E L of O C ❑ L1d' ~ LU (3) LL U) 0) O © LLJ N w N _ Cl) E tCi aU.r A O CL U C (D U) U U ctl m LO C V H (D C) ca C) W C: (D W ~ C C E 0 CL C: CL Ltr7 N M r O O 1 T O N Ln r ~ Lo co N CM L!! LC! O 'I= LC! lr~ ,41 O O 1 O La N ' I d1 I rn T U C ~ U m Q C7l X W 'E Z U r H M r M t~D Lrj Q M M ti ti O h T V LNCI O O O Lli N M u7 O z M r O N O r d9 ~ O O "O N .O C r QJ 7 Q - C U O LL Cf) (D N ~ LL LL O U -D❑ U c O cCS c ~ ma m U C 0 a O 0 U O C 0 C LU a~0 4- - E O O tl ~ E u) O U 7 (nn 7 cC 4 N 7 N O - r-C) a) 3 LL 3 N 4- O r" 1} c T; O 0 LL N C L7 LL V O C U U) :E CC) tU) N 4) M (D U to O CV) m CIL U N =0 p . O Do o CL 0) L6 H ~ m :ra U) M M ~ r O N c m 7 a! ` U 0 m c ~ yUL CY) L :tM! Q Q ~ C ` O CL h ' ' Cl) M QNOM C (C O M s d 00 O CD uO ~ C) O N (0 CD O N O ccp O ' (9Q a CD C) et C) Q t17 a co C) 0) LO 0 C14 C) ce) ~ ~ C7 CD r r L i Ii 0 (O 0 O) O N Co M C) (O O Cl) O co C) co ~ ~ O w C. U L- C O 7 r ??T? ~ a i O - c wZ ~ S ~ h C s ' r- cc ~ a~ O c ~ ro W d nc Co LL N I- H ~ M N p i C 0 CNT C6 NOONaDCD O(7)0m lD000tiOC tMaIt W LO LC) N r C) N r (D M co r (O00 LnaQ 4r cq cm CO O O ' O V co LO LO r O N r M P- r M M e^• m ~ 'rr C) N CV) w co N N It 0 N 0 l ' r O Cl) LCl ' LO LS r N r N O co 1 1 1 1 I 1 1 1 0) O M N Cb Cl) CO 00 ~ r ' N ' a ' C) 0) LO C4 LO C14 00 LO LO r r IQ LO 'C m M ~ I,- N N Ul) LO LO Lf) LO LO C '%L LO LO Ln LO M ( LO LO NIN u°~ Ln LO LO S O U U CL) 4) : U) La c Q •E °!S U Cl) Vices aQ w o0 v) N m 'C V LL, L 4) ,C 0)U N N y 0 0) c O C C~ C V O a~vi W 7+ d (C Lo 0 U Z ct3 v rn M Z a~i vUi ai ° 3 0 IL I c - Q) F^ a) i- x (0¢w(L ()ELL E)22 ~z w Z U h M O ' T tp N Go CC) M L ~ N 0 LO 'IOI Ch !rl r U C C ~ a) d L) G. c X w o (o U p H g T 'LY M N M LO d• M N r a (D C1 z N r C 7 LL C LL y U a) .O C U ~ c [2 E 4) ~ a) 0 "O E ED: O rte. N +r QO U 7+ O C y a) 7 L N N r O co N a .d a) m LL C C V T a) 3 L ~ c E o Ce (D (D a) n~ p U- L ~ N OL f~ IL ~D C) ~ 4 z 0~ Q CD N m Deschutes County Bethlehem Inn (Fund 128) Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Grants - Private Lease Payments Total Revenues Transfers In: Project Development (140) Gen Capital Res (143) TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Interest Expense Interest Payment TOTAL REQUIREMENTS I Budget Actual Variance FY Coll. Budget Prdection Variance $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) 75,444 - (75,444) 75% 0% ` 100,592 - (100,592) 18,306 18,306 - 75% 75% 24,408 24,408 - 93,750 18,306 (75,444) 75% 15%' 125,000 24,408 (100,592) 1,237,500 - (1,237,500) 75% 0% 1,650,000 - (1,650,000) 795,000 - (795,000 75% 0% r 1,060,000 - (1,060,000) (583,750) (2,691,867) (2,108,117) 75% -2153% 125,000 (2,685,765) (100,765) Exp. 18,750 11,096 7,654 75% 44% a) 25,000 15,000 10,000 75,000 - 75,000 75% 0% ' 100,000 - 100,000 93,750 11,096 82,654 75% 9% 125,000 15,000 100,000 Cj) - (2,700,765) (765) NET (Resources - Requirements) (677,5001 (2,702,963)_ (2,025,4631 a) Interest on March 2013 negative cash balance: $1,229.50. b) Inception through February 31, 2013 Revenues - Lease Payments $ 67,122 Expenditures: Land/Building (Amertitle) - July 2007 2,241,313 Hickman Williams 17,578 City of Bend - May 2008 250,000 KN EX CO 5,289 Kleinfelder 3,732 Total expended on facility 2,517,913 Interest on Negative Cash Balance 252,172 Total expended 2,770,085 Net $(2,702,963) .t Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2013 BOCC Conference & Travel. Jul Aut Tammy Baney Conf/Sem & Educ/Trainin 30 Travel Meals - 20 Accommodations ' Airfare Mileage reimbursement Ground Transport/Parking Total Baney 384 Alan Unger Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport/Parking Total Unger 35 30 LL 566 - 80 1 625 810 82 240 408 - - 1,715 _1,961 632 632 - r 432 5 557 L 232 3,078 ,078 - 142 177 704 T; 512 3,586 7,066 80 75 590 65 305 65 Tony DeBone Conf/Sem & Educ/Trai_ning Travel Meals _ Accommodations Airrare Mileage reimbursement Ground Transport Total DeBone Other - Education/Conference 30 30 otal - BOCC Department Conf/Sem & Educ/Training Travel Meals Accommodations Airfare . 125 - Mileage Reimbursement - Ground Transport - Total - BOCC Department 125 FY 2013 Budget Percent of FY 2013 Budget Expended IL/ 496 35 678 Oct I Nov I Dec I Jan I Feb I Mar YTD Total 15 470 10 3 - -..580 100 i 1,240 76 76 _ 429 I 339 768 - 471 - 562 399 405 - 1,836 - i 19 19 ~ 15 1,369 _ . - 10 657 35 , 1,318 505 , - 3,939 ~ 315 315 - - 15 775 20 1 740 1,115 2,955 66 6 ' 7 82 240 484 - 857 119 . 339 1,715 3 1157 _ - - - - 632 T 632 1,260 - 683 ' 562 557 83 1 637 5,026 . - ---19 . 142 196 15 2,893 888 657 804 1,910 4,480 12,450 15,250 81.6% _ BOCC Count College --O--ffice/Cop t . - - _ 85 ierSu lies 2,441 p 761 - Meeting Supplies 811 869 I t T- _ 2 526 Total BOGG County College 846, 811 869 - - - - i NOTE: Above amounts include only those expenditures processed. for payment. Additional conference and travel costs may have been incurred, but not processed for payment. 3/29/2013 RV Park (Fund 601) Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ - $ 27,855 $ 27,855 100% n/a ! $ - $ 27,855 $ 27,855 Revenues RV Park Fees < 31 Days 101,020 76,336 (24,684) 67% 50%'. 151,530 151,530 151,530 - RV Park Fees a 30 Days 4,667 12,015 7,348 67% 172% a) 7,000 12,015 5,015 Tent Space Rental 133 - (133) 67% 0% 200 200 - Washer / Dryer 759 766 7 67% 67%; 1,139 1,139 - Vending Machines 267 332 65 67% 83% 400 400 - Interest on Investments - 155 155 67% n/a - 155 155 Cancellation Fees 533 841 308 67% n/a ; 800 841 41 Total Revenues 107,379 90,445 (16,934) 67% 56% 161,069 166,280 5,211 Transfers In-Fund 130 120,000 130,476 10,476 67% 72%' b) 180,000 180,000 - TOTAL RESOURCES 227,379 248,776 21,397 67% 73% 341,069 374,135 33,066 REQUIREMENTS: EXp. Expenditures Materials & Services 65,083 76,214 (11,131) 67% 78% 97,625 97,625 - Debt Service 162,296 161,477 819 67% 66% b) 243,444 243,444 - Contingency - - - 67% n!a TOTAL REQUIREMENTS 227,379 237,691 (10,312) 67% 70% . 341,069 341,069 - NET (Resources - Requirements) - 11,085 11,085 - 33,066 33,066 Beg NWC per FY 2014 Requested Budget 12,289 a) 2,761 RV spaces rented b) Transfer In from Fund 130 and the debt service payment are recorded semi-annually - November and May. 0 o v ~ o ~ o a o ~ T N A N O `7 l!] ~ d Q Q Q O T CD M N CO CA CT O Q Q 1{7 brQCprdrrMCDoa Q r N N rn O C)i ~ CD .r ~ c 4 CO C yea U O IL co o Q U) U co p CU U U co z N 7 j N M 7 N IT O~t CCOCCDDMLOLdAn co LD n CD N N r` N ~r N N h b ti It 0 r CMp Lfl O O n l ~ CNC) CCOO O M b N 0 Q r r r CQ a N N N RU o•ooa°a°~aooop N M CD Q b d t• CD M~ CD r N ,;tP- 0 O Q M b M Ln Log - r ~ N m r-- N Q r O N n N CD ~ ~MMMCQDQMr~~CAM C? CO N N P LC) I` r 4 M (O LD r m o b N--t 0 0 CD r aD ?I- OP, OO ~ C Q7 ~ C NM N M C D 10 M (D co CO M Cl- N r Nr-Lo h Q ~r N r N r 1[9 r a o 0 0 0 0❑ o 0 0 0 Mf+NCAcD W N~CAnQQ C+1 CD N r--~ r N lIS CO M Ln OR ti V: M M N 0 0 M Q r N LO -t N N N M ~ r r- r Cp 67 N r Q Q M d eP Ln CO f~ N N M LCD r r MOM 0 ~ COO ti r --i "7C N MC' C NNM L _ r-- LA M l17 Q N 0 O r qt O O CO O oc CD ti N Q D) O ti s 0O IT T LO M r N LC) T N LN 0 3° a o 0 of o 0 0 0 0 0 3~ Q r 4 Lo N Cp Q lA CO r f` CO N N Q O t0 I- CT co rCSCDONQNNCiaDQO CD N r r N l17 b d m O N t b CO b O M U) 00 f+ M N CD ~ co N N CN CD M N Of CD 7 m 0 c l N N N CD P- LO W Q ' m Cj ) In In P- LO CD 0 N N C N ` U CD Q Cp Q d OD V Q d CD N M O lfj r M -N ~ I] I M N O CO Q N N N m W~ N r- = CM N T A 7 G S , CD p c R O C -Q - aE O O O O O O ~ O O O O iS~ ~ U - Q CO f O O Q M LA N A M CD CO bCOId: Lq--N l17tiCD O SVK d w C7 lA r 6 O O Vn CO N 1'- CO N CL Ln 10 CU O co IT N O Q LA O O N 00 MN b NNN 1N► Q N - b O C O M C 04 11 N CD vNCD co CO W vNco N LO d M r Q N CO CD M M YT`Ct Cp Ln ' c f! Q CD Id- CO IT O ~ LA r M CD r ~ rl- n M f► Ln ';r r r N O ~ U M C {L1 7 C6 (D ~ E U) U a d v o O L a) (D CD Z OL CO (D in E (D E E ca ° 1 cA o 4) a) U Q) 4 D 2 r+ 7+ j) C Lt O C.0 m CCU CO C - 0 O f.}a 4L . a~QCnOZLa-103 LTm m r F Building Services - 620 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Cleaning/Maintenance Utility Reimbursement Facilities Charge to State Add'I Services Interest on Investments Interfund contract ISF Charges Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Total Expenditures Year to Date Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $ 415,000 $ 455,993 $ 40,993 100% 148,178 130,930 (17,247) 2,250 2,657 407 142,451 121,043 (21,408) - 53,455 53,455 2,250 2,077 (173) 7,500 7,500 (0) 1,611,095 1,611,091 - 1,913,723 1,923,753 15,033 2,328,723 2,384,746 56,027 1,371,413 576,150 29,700 75 1,392,455 533,026 29,700 75% 75% 75% 75% 75% 75% 75% 75% 75% (21,042) 75% 43,124 75% - 75% 75 75% 1,977,338 1,955,181 22,158 75% Contingency 247,631 - 247,631 75% TOTAL REQUIREMENTS 2,224,970 1,955,181 269,789 75% NET (Resources - Requirements) 103,753 429,566 325,816 Beginning NWC per FY 2014 Proposed Budget n/a $ 415,000 $ 455,993 $ 40,993 66% : 197,570 197,570 - 89% ' - 3,000 3,000 - 64%, : 189,934 189,934 - n/a - 53,455 53,455 69% 3,000 3,000 75% 10,000 10,000 - 75% 2,148,122 2,148,122 - 76%- 2,551,626 2,605,081 53,455 80% , 2,966,626 3,061,074 94,448 Exp. % ' , 76% 1,828,551 1,828,551 - 69% 768,200 768,200 - 75% 39,600 39,600 - 0% 100 100 - 74% 2,636,451 2,636,451 - 0% 330,175 - 330,175 66%' 2,966,626 2,636,451 330,175 424,623 424,623 380,000 Admin Services - 625 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Sale of Photo Copies Miscellaneous Interest on Investments ISF Charges Total Revenues Transfers In-General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Transfer to Veh Reserve Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 140,000 $ 207,208 $ 67,208 100% n/a $ 140,000 $ 207,208 $ 67,208 - 398 398 75% n/a - 398 398 - 24 24 75% n/a - 24 24 375 1,199 824 75% 240% > 500 1,500 1,000 697,414 697,507 93 75% 75% 929,885 929,885 - 697,789 699,127 1,338 75% 75% 930,385 931,807 1,422 30,000 30,000 - 75% 75% . 40,000 40,000 - 867,789 936,335 68,546 75% 84% 1,110,385 1,179,015 68,630 Exp. 646,358 575,263 71,094 75% 67% 861,810 781,810 80,000 82,953 67,976 14,977 75% 61% 110,604 110,604 - 2,700 2,700 - 75% 75% 3,600 3,600 - 75 - 75 75% 0% 100 100 - 732,086 645,939 86,147 75% 66% 976,114 896,114 80,000 100,703 - 100,703 75% 0%: 134,271 - 134,271 832,789 645,939 186,850 NET (Resources - Requirements) 35,000 290,396 255,396 Beginning NWC per FY 2014 Proposed Budget 75% 58%; 1,110,385 896,114 214,271 - 282,901 282,901 200,000 BOCC - 628 Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Protection Variance RESOURCES: Beg. Net Working Capital $ 60,000 $ 37,907 $ (22,093) 100% Revenues Sale Map Photo or Copies - 6 6 75% Interest on Investments 375 226 (149) 75% ISF Charges 323,909 323,909 - 75% Total Revenues 324,284 324,140 (144) 75% TOTAL RESOURCES 384,284 362,047 (22,237) 75% REQUIREMENTS: Expenditures Personal Services 258,089 258,478 (389) 75% Materials and Services 66,951 70,467 (3,516) 75% Capital Outlay 75 - 75 75% Total Expenditures 325,115 328,945 (3,830) 75% Contingency 44,169 - 44,169 75% TOTAL REQUIREMENTS 369,284 328,945 40,339 75% NET (Resources - Requirements) 15,000 33,102 18,102 n/a $ 60,000 $ 37,907 $ (22,093) n/a - 6 6 n/a 500 300 (200) 75% ' 431,879 431,879 - 75% 432,379 432,185 195 74% : 492,379 470,091 (22,288) Exp. % , 75% 344,119 344,119 - 79% 89,268 102,268 (13,000) 0% 100 - 100 76% 433,487 446,387 (12,900) 0% 58,892 - 58,892 67% 492,379 446,387 45,992 - 23,704 23,704 Beginning NWC per FY 2014 Proposed Budget 20,000 Finance - 630 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Investment Fee Photo copies IGA Contracts Interest on Investments Interfund Contracts ISF Charges Total Revenues Transfer In - General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 540,000 $ 583,527 $ 43,527 100% n/a $ 540,000 $ 583,527 $ 43,527 24,000 27,218 3,218 - 183 183 11,585 5,446 (6,139) 3,000 2,232 (768) 9,000 9,000 - 721,823 721,823 - 769,408 765,902 (3,506) - 41,000 41,000 1,309,408 1,390,429 81,021 75% 75% 75% 75% 75% 75% 75% 75% 75% 789,594 662,497 127,098 75% 194,519 191,902 2,616 75% 45,000 39,350 5,650 75% 1,029,113 893,749 135,364 75% 145,295 - 145,295 75% 1,174,408 893,749 280,659 75% NET (Resources - Requirements) M,090- 496,680 361,680 Beginning NWC per FY 2014 Proposed Budget a) Includes payment of annual contract $52,762 85% 32,000 36,000 4,000 n/a - 183 183 35% 15,446 5,446 (10,000) 56% 4,000 3,000 (1,000) 75% 12,000 12,000 - 75% 962,431 962,431 - 75% 1,025,877 1,019,060 (6,818) NIA - 41,000 41,000 89% 1,565,877 1,643,586 77,709 Exp. 63% 1,052,792 952,792 100,000 74% 259,358 259,358 - 66% 60,000 60,000 - 65% 1,372,150 1,272,150 100,000 0% 193,727 - 193,727 57%, - 1,565,877 1,272,150 293,727 - 371,436 371,436 377,000 Legal-640 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Miscellaneous Interest on Investments Interfund Contract ISF Charges Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Year End I Actual Variance FY % COII. % Budget Projection Variance Budget $ 150,000 $ 188,093 $ 38,093 100% n1a $ 150,000 $ 188,093 $ 38,093 225 71 (155) 75% 750 18,459 17,709 75% 750 840 90 75% 3,000 574 (2,426) 75% 576,779 576,778 0 75% 581,504 596,722 15,219 731,504 784,816 53,312 75% 592,148 578,371 13,777 75% 27,902 34,966 (7,064) 75% 10,575 - 10,575 75% 630,626 613,337 17,288 75 63,378 - 63,376 75% 694,004 613,337 80,666 75% NET (Resources - Requirements) 37,500 171,479 133,979 24%: 300 300 - 1846% 1,000 18,459 17,459 84% 1,000 1,100 100 14% 4,000 1,000 (3,000) 75%' 769,038 769,038 - 775,338 789,897 14,559 85% 925,338 977,990 52,652 Exp. 73% 789,531 777,531 12,000 94%~ 37,203 44,203 (7,000) 0% 14,100 14,000 100 73% 840,834 835,734 5,100 0% 84,504 - 84,504 66%! 925,338 835,734 89,604 - 142,256 % % 142,256 Beginning NWC per FY 2014 Proposed Budget 150,000 Personnel - 650 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Miscellaneous Interest on Investments ISF Charges Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Total Expenditures Contingency TOTAL REQUIREMENTS Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 290,000 $ 327,178 $ 37,178 100% 750 95 (655) 75% 2,250 1,407 (843) 75% 600,470 600,470 0 75% 603,470 601,972 (1,497) 75% 893,470 929,150 35,681 510,483 511,211 (728) 75% 226,777 134,515 92,262 75% 75 - 75 75% 737,335 645,726 91,609 75% 83,635 - 83,635 75% 820,970 645,726 175,244 75% nla; $ 290,000 $ 327,178 $ 37,178 10% ) 1,000 95 (905) 47% 3,000 1,850 (1,150) 75% 800,626 800,626 - 75% 804,626 802,571 (2,055) 1,094,626 1,129,749 35,123 Exp. 75% 680,644 680,644 - 44% 302,369 210,000 92,369 0% 100 - 100 66% 983,113 890,644 92,469 0% 111,513 - 111,513 59%'; ` 1,094,626 890,644 203,982 NET (Resources - Requirements) 72,500 283,424 210,924 - 239,105 239,105 Beginning NWC per FY 2014 Proposed Budget 240,000 a) Manley Services Payment Information Tech - 660 Statement of Financial Operating Data Nine Months Ended March 31, 2013 RESOURCES: Beg. Net Working Capital Revenues Interest on Investments Inter/Ether/Date/Phone ISF Charges Total Revenue Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 568,550 $ 731,330 $ 162,780 100% n/a $ 568,550 $ 731,330 $ 162,780 3,000 3,159 159 75% 20,250 31,258 11,008 75% 1,569,633 1,569,633 0 75% 1,592,883 1,604,050 11,167 75% Transfers In-General Fund 49,500 49,500 - 75% TOTAL RESOURCES 2,210,933 2,384,879 173,946 75% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Total Expenditures 1,452,631 1,387,632 64,999 75% 392,367 248,263 144,104 75% 75 - 75 75% 1,845,073 1,635,895 209,178 75% Contingency 223,723 - 223,723 75% TOTAL REQUIREMENTS 2,068,796 1,635,895 432,901 75% NET (Resources - Requirements) 142,138 748,985 606,847 79% " 4,000 4,200 200 116% 27,000 31,258 4,258 75% 2,092,844 2,092,844 - 76% 2,123,844 2,128,302 4,458 75% 66,000 66,000 - 86°k 2,758,394 2,925,631 167,237 Exp. 72% 1,936,841 1,850,000 86,841 47% 523,156 465,000 58,156 0% 100 - 100 66% 2,460,097 2,315,000 145,097 0% 298,297 - 298,297 59% 2,758,394 2,315,000 443,394 - 610,631 610,631 Beginning NWC per FY 2014 Proposed Budget 611,077 IT Reserve - 661 Statement of Financial Operating Data Nine Months Ended March 31, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Pro jection RESOURCES: Beg. Net Working Capital $ 365,593 $ 480,196 $ 114,603 100% n/a $ 365,593 $ 480,196 $ 114,603 Revenues Interest 1,125 1,989 864 75% 133% 1,500 2,650 1,150 ISF Charges 175,500 175,500 0 75% 75% 234,000 234,000 - Total Revenue 176,625 177,489 864 75% 75% - 235,500 236,650 1,150 TOTAL RESOURCES 542,218 657,686 115,468 75% 109% 601,093 716,846 115,753 REQUIREMENTS: EXP. Expenditures Materials and Services 57,450 22,528 34,922 75% 29% b) 76,600 76,600 - Capital Outlay 108,750 93,276 15,474 75% 64% b) 145,000 145,000 - Total Expenditures 166,200 115,804 50,396 75% 52% 221,600 221,600 - Res for Future Expenditure 284,620 - 284,620 75% 0% 379,493 - 379,493 TOTAL REQUIREMENTS 450,820 115,804 335,016 75% 19% 601,093 221,600 379,493 NET (Resources - Requirements) 91,398 541,882 450,484 Beginning NWC per FY 2014 Proposed Budget - 495,246 495,246 494,096 Groundwater Quality A majority of the lots and subdivisions platted in southern Deschutes County predate statewide planning laws and state environmental regulations. Residential development, commencing in the 1960s and 1970s occurred without an understanding of whether rapidly draining soils in densely platted rural subdivisions could properly treat effluent through the use of conventional on-site septic systems. Beginning in the 1970s and continuing through early 2000, several studies evaluated groundwater conditions in southern Deschutes County. The results prompted local, state and federal agencies to undertake certain measures to mitigate nitrate pollution. As an example, in 1987, a sewer system was constructed in the core area of La Pine to provide better treatment and land disposal of wastewater in order to protect drinking water supplies from nitrogen concentrations. Since 2010, DEQ has assembled a steering committee of community members to discuss and make recommendations to protect groundwater in southern Deschutes and northern Klamath counties. DEQ posted statements on their website describing the Groundwater Protection Project. Excerpts are cited below: The DEQ, the US Geological Survey and Deschutes County have determined that the safety of the groundwater in southern Deschutes and northern Klamath counties is threatened by nitrate contamination from traditional onsite septic wastewater treatment systems. The groundwater aquifer provides the drinking water source for most residents in this area. Most wells tap into an aquifer within 50 feet of the ground surface. The aquifers have no natural barriers to the ground surface and are very vulnerable to contamination from the surface. Groundwater in the southern Deschutes and northern Klamath aquifer is becoming contaminated with the nitrate at unsafe levels. Infants and pregnant or nursing women are especially vulnerable to increased nitrate levels. High levels of nitrate may also cause other health problems. To protect the quality of the drinking water in the aquifer, Deschutes County passed an ordinance in 2008 requiring upgrades on all septic systems; voters overturned the ordinance in a special election in March 2009. Deschutes County then asked DEQ to take the lead to resolve the issue. As of the date of this Plan's adoption, the DEQ Steering Committee is in the final stages of developing recommendations to protect the groundwater, while also addressing other factors noted in this Plan, including wetlands and floodplain development, high groundwater lots, inadequate roads, and open space. DES 0~2{ Community Development Department Planning Division Building Safety Division Environmental Soils Division P.O. Box 6005 117 NW Lafayette Avenue Bend, Oregon 97708-6005 (541)388-6575 FAX (541)385-1764 http://www.co.deschutes.or.us/cdd/ MEMORANDUM DATE: March 21, 2012 TO: Deschutes County Board of Commissioners FROM: Peter Gutowsky, Principal Planner RE: Newberry Country: A Plan for Southern Deschutes County / Work Session The Deschutes County Board of Commissioners (BOCC) conducted its second hearing on March 12, 6:00 p.m. at the Sunriver Homeowners Aquatic and Recreation Center to take public testimony on Newberry Country: A Plan for Southern Deschutes County.' At the conclusion of the meeting, the BOCC closed the record for oral testimony, but left the written record open until March 29 at 5:00 p.m. The BOCC is holding a work session on the Newberry Plan on April 3 at 1:30 p.m. The purpose is to discuss suggested revisions raised during the BOCC's two public hearings to determine which sections of the Plan warrant revision. Attached is a matrix that includes a column to allow staff, in certain instances, to provide additional context on a particular issue. In most cases, the potential revisions speak for themselves. An updated matrix will be provided at the work session to capture written testimony submitted by the March 29 deadline. After receiving the BOCC's direction at the work session, staff will then schedule a regular meeting for the BOCC to deliberate and consider first reading of Ordinance 2013-007.2 A tentative date is Monday, April 15 at 10:00 a.m. httl2://www.deschutes.o!2g/southcountyplan 2 Ordinance 2013-007 officially adopts Newberry Country: A Plan for Southern Deschutes County into the Deschutes County Comprehensive Plan. Quality Services Performed with Pride H C O O O CL a, 7 0 V H d1 s v H d 0 C d s a O N L R E 0 V d .Q m Z E V N m O N N C C A 7. m t4 --pp = v~ +O C I- ° 0 N,p d1 U d ~ 0 C v C~' p C m Iv: 7 O p~ m_a oU o` u C _ 0 m c L CO Cfi O C U N m f0 U p N U m p 0 N ` 3 N E m y C N c 'O - m N N U C 'N r 0 O C1 N 0 7 Vj E ~ O ` N (D 1 2 O a 0- LO C p U m > N 7 L to 7 !A C y a) 4) 4) O 0 C` ~ c6 N 7 c-°0 - 0 0 O c 00 p c~ ' 0 E C w-. O O 0 a'~ ~ro E (D a) o L (D E O m m ° ° M ` Uf ~ V 'C C C 0 N. N O t Q U U.. p O 0 7 E T p p` N 3 y s E N Cd 0 - > N O 8 O! cy, o U) v C (D a? M m ; 0) v E c y to CL n, CO :d AD co _0 a 0 m, p O am y p z CD E 0- 0 G p W;. w N t0 Ol C la O 4 f O c0 C ~p C E 7 0 3' ~o cv 'E N (D 4 1 C a U ~ ~ ~ Q c 0 a y ~v 0 3~v m c c°q o 0 p C m , $ M It 15 m 2 m m 0 E 7 0-0 p N 3 8 p cn 0 ° 0 C ~ '2 N C L$ O m 0 N r- C c c0 CO q y p CO 'p Y p ° Q 0 c N cc 7 wH NNE ~ ' co CL N ' ca m E Z5 M m Cl o CV G ' CV N CV - C 1{1 7+ U O O 2 ° ziLZ L(n V ~ s C o U N ° o R m D- -6 a a. a ~ $ I ¢ QI l ¢ I Q o s w co m C j N O~j N.& N rn N to CD U (D $ U O U m ° CL Q as 4 Q 0. c 0 N w c r~+ O CL_ 7 V d W O d O N L C EL 3 O V d Z e E 0 v > ns r as N 0 E O I- o c ;R m c r W G 0 ` O U 0 CL a m m L w 0 to 0 W O 0- E U O m N C U C V1 O m E c`v c Q c c0 _ lC 0 O a) rn L 0 o O O O L 7 N a' :3 m m a> CL 0 a) a a`) a = m is a~ 0 cm N ro w /1 tl! G Ctl ' c w N 7 C ' O - G U 7 ( U O m ~ m c N to m t~ C O ~ C ~p G U CA } c C w ~ m m 0 p m A 4 Y ai U m ' G o O N c E 0] c c 3 " co m n c r aci Ll o y o m e (a O O IA G C Q7 G A rn N p a J IV r .r co C E m - U m m 0 U ' co CL d 0 ~ N ~ C 0 G; 7 Q CD 0 c E 7 m= m 0 7 v c W_0 a a~+ c-0 $ r o - m i (D ,Z 0 FL a v c t0 wa`°ia~ ~ p~3 L to 0= •0§ 0 s E (D ii t: vm co . E 0 c 3 c O C m wo c O 3 5 m L 3 m 0 O 0, N 0 L b/ U) a7 . N L C fQ G $ a) y O co Q) N O A_ m 7 `O. OV' • 0 N 1 . v _lC 0 CC w . m j E w rn= (M.0 O U . t G H Z A r o c 3, y L r.m m 2m E cm a. Q ) O -O m 3 ca G. ' C N m a) ro a w M G y r~+ t..~p E.,. V ~~.c - ro4p Ea~ C 07 C; m N d" T ch O m 7+ to N Q 'O 7 GCn~c L A cuQ 0 U ca OQ 9 5 c a. cL m Z < U M- u a _ _ - O 7 ~ O C a . d g o c 0. O U v7 ca w ,a 0 CL to rs ci o ai w: cA c ~c .r:t E~ -0 a. ~ a c~ Yi Q c O j r-O C"i t}p c•i e. tiN (o r- % U U Q f ~ aS a CL M N C to d C N O a C 3 Q V V H (D 0 N 0 U) w Q a C 0 V d d z N E E O v a U, C in I -M 'P U W G C C 0 N E O r Q. S C N O ~ 3 isao v O °cL c E= roc m q m E 7 x1 $f ;a W r a ~o $ C v c o N _ ME 0 0 21 (D E .9 r- Q U, S C c"y N UO Z,g mo - I E E a o -3° L1 O y C E O C~ M L Q c 4 C ° $ ' v 2 co 3 S. (D ° CL c c m .0 =3 w ° -0 m 3 - U U) 0 E E 4 S -0 C ~ L N a L M O O G L tC C .y U N a ~J U N m (b E E cy c U) r_ - a a) c E ` U U C1 O U c O ,9 0 O C U1 U U _V.e 0 ~iV 7 w V O E O 0 C U ~ ~ - ~ Cc 0 „c[~ f O e E 3 ca O. O ,a M V O$ E O U c° a C 5 t~ 2: U 8 N 3 C O O N • . O d U l0 'C B O N N ° V OIL ` C O S E U) a~m °i G f0 4) he c U 0I O ~ fp E moo' itz E E', am 3 _m - c a m aI ro~ `m Um~ ° ' ~ c~ ` ~c c V w O 4 a I O U N ~ ° cu 0 Z O U . 7 Of (D j O _ C N 0 U ~ C DCl O. 0 10 m O _J V 0 L 7 ( 7 L ~ 0 E + + C G a 0 N 53 W m . . O O ZE r 0 U N O } j CD r- w ° -0 C O . m .0 C 0.0 O ' C N n ~T o o O LL o t: 7 a° r N Co CL (D cam N° ld V y J N OI 0 In OI p O N m L - tla m N U S Q O 7 c . . Cm LL I CD N U e- o C a U N a o~ ;E N U U co v(6 a 3 ° 0 ~ z CL m 0 v aZ) ❑c QI N N~ Q N V~ F aC)~ cpc~q ).n ti F ti F F U) U - WW (D U rI (0 0 U &D ((~O U C7I (O CL 0~ CL CL N C O N C1 C 0 a C 0 0 V N .Q: 7 t U N d 0 d t 0 N L 102 C N FL G O V G1 z m 8 0 v , cn C - ' C N S ~ ~ " 3 ~ C N 0 C p j d X Qy ~ V m ~ o ~ ca U a c d N C C t C? O C 7 tO U ' C Z-7 (d G " ~ O A N j lp N _pp p N C 7 C!!!! CL N C C 12 U C x O N d O N 7S (6 U L ~p O LL La C C C O b V C N 15 _0 m CL 0 N C c M (b O U) 0 a C• ~ U Q1 c ~ m w CL C 0 s O O z O C; N d cm C E y R o a .8 - a i V o c 3 O CD E y c o c .0 E C ~ U N c 3 0 Z C E U) Lo y U E2 > r- O C 0 c ) N I G N ~ -0 CL O C N m m 0 r_ -0 C y o IM W I w CO •C j Of CV 2 p O H fl. m o 7+ tD C j N cI d E y E r5 c!) U f6 cc U C-o E Q co ' Of o w (D (L ° g z m o Co 5 -6 rn c r_ ~ Cd -6 dOC I U o H Q U U G rM- N co .U co U r F ~SL Q ~ N F Q Q Q CL Q Q f/J N m R C O a C d V s V 0 C d s O N C m a a G 7 O V 41 Q Z 0 p 9,,~~ E cL2 ~ N ~ O p~ ~ ~~.0 m v m cdr,~in E 4- 0) 5a'-2:.c 7 m c O. ~L EZ C 3 O.m N N mw ~.0 , a .0 0-0 N . O N m Q m Q O M a a ,N 30 O m m O T O c 4)z C m ro C cC'J N.~ o c a c c c rno~ 0- L U o r~ CO S,aZ; 8 'O arm 1°m.2~xm1O U s 5 E E mNNO~bi'O $m E°, b°.0 E. K~ 0 '1 O ? p c~ 0 ~ L i° ° N N :3 G O O Y 1~ m m ~p j Z 0= cr OcO N O C N L N 'm c> H WrswQ.- 0 I- m C7 RU-~'T7 b7C N 2.2,GZa-0 ~ i C 'p j 0 < m ~ 0 C d 0 O1 L O W N m W C3 O LL ca. o~ C5 CO o 0 N $ a`)~ 12 a 0 o°oNx m N F G N tII E U 5 O O_ m N C y L O N N O c~ C N C _ to fNm e C m f❑ Y O r N~ N: O m 0 c ~ m y U) ~ N E 0), Um~ v a c 0 C ~-m ao o E c y cN o ' c c C. m 41 ry a.~ 3 m O 0-0 + + 2°. Umm0°:3 0 --0 E tea) O $ 'm ° m ° m 2 O! U E -C .m., C O Q N C 7 mcy ~0 0 : ; W m 7 a Z m ate - I C7 2 ;'2 m ~ E o ~ 3¢ ° - ° - 0 , CF) ~ E t _ 75 C a~ m T 0, 75 L° 7 U O ~ Cj E O' O C 7 N y O N a O E E Q' Q1 m .s.. CL QQ V N m U c c 0 c 7 W M N N 4c °I m N U) J , m c L MB . 0 U ~ a c 0 0 O N m O j T m L . tl 0 CL a~ w Ica r7w E ro U o rnow° o O o cr. C, v CL 10 U) m C ' .c U) v m aC ~ v 151 m I, CL 7 CS Q - ...N cp N V .N d c m Q c 3 O V H v N m N 3 O 1.. C a C O V d d Z n, Y CE E O V 1 1 c 4 O ~ . w o N 9 3 E m m ~ O c k ro E c 3 N . d 3 n 6~ N _ Q y U 3 U) N 0 0 N ~ y C O is a N c N O c CL O C - ~ O ca , .C CD N > 2 7 3 7 U N O 1C 4 O E S ( 1 Qi 6 N Y O OU O 0) U) M O N 7 - .O+ N E w C G C tp c~D O J ~ C L C C ~ , O N E E- 9 O -o m '0- r ' ' c c u 7 N O 2 O mo 7 _ _ :n U M V l U c d O ~ ~ Of ~ d a i I ~ ¢ ¢I ~ NN O k ~C k k ~t fi V~ m4 m ~Q Q CV Q N ~ ~ ~ ti 1