Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2013-1054-Minutes for Meeting June 05,2013 Recorded 6/28/2013
COUNTY NANCYUBLANKENSHIP,F000NTY CLERK°S Vd ~0~3.10~4 COMMISSIONERS' JOURNAL 06/29/2013 10;34;11 AM 1 IIII Do not remove this page from original document. Deschutes County Clerk Certificate Page Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF WORK SESSION DESCHUTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, JUNE 5, 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, Nick Lelack and Peter Russell, Community Development; John Skidmore and Nick Arnis of the City of Bend; Marty Wynne, Finance; Susan Ross and Teresa Rozic, Property & Facilities; and Anna Johnson, Communications. No representatives of the media or other citizens were present. Chair Unger opened the meeting at 1:30 p.m. 1. Finance/Tax Update. Marty Wynne said rates and average return are about the same as previously discussed. Bond rates have risen dramatically, which is not good if you are trying to sell bonds. It is still within projected parameters. The economy is still in turmoil so it is hard to know what to expect. General Fund shows a forecast of above $10 million in revenue, with the variance being non-departmental. Most departments are close to budget for FY 2012-13. The budget was $9.5 million revenue. Commissioner Baney said that the State might be cutting payments, and that will impact next year. Mr. Anderson said that appropriation numbers from the State are not final, but there will be a loss in revenue primarily for Parole & Probation. Contingency can cover this short-term only. Minutes of Board of Commissioners' Work Session Wednesday, June 5, 2013 Page 1 of 5 2. Discussion of Next Public Real Property Auction. She said there is a request from ODOT relating to property affected by the Parkway. ODOT purchased some property from the U.S. Forest Service in order to realign a street. The vacated strip actually belongs to the County. The County is being asked to give that property back to the U.S. Forest Service. The auction would happen this summer. The County took deeds on several properties, and the market is improving. There are thirteen properties to consider for auction. The group went into executive session under ORS 192.660(2)(c), real estate negotiations, at this time. 3. Other Items. Anna Johnson discussed ideas for the State of the County presentation. It will be the top ten, and she needs themes. They need to keep the audience engaged. One section would be budget, another goals and objectives, and another accomplishments/highlights. Mr. Anderson said there would be a stack of photos at each table, and the audience would pick one out and ask a relevant question. Tom Anderson was asked to act as Master of Ceremonies. He said he would prefer to talk about budget items; Chair Unger will M.C. Commissioner DeBone spoke about the conference involving eastern counties that he attended earlier in the week, where they discussed issues affecting central and eastern Oregon counties. John Skidmore of the City of Bend asked for a letter of support from the County for a TGM (transportation growth management) grant. They are applying for $150,000, which is the entire grant; and will work with partners for the balance of $100,000. They do not yet have all the particulars regarding the OSU campus siting. The grant is due next week. The project would involve OSU Cascades, the City, the County and Bend Metro Park and Recreation. Minutes of Board of Commissioners' Work Session Wednesday, June 5, 2013 Page 2 of 5 The grant would address the area off Simpson and 14th Street that remains mostly vacant. As properties are rezoned, they bring out transportation impacts that require expansion of roundabouts and other changes. Mr. Anderson said the County was in the midst of applying for its own grant for the Deschutes River Woods community plan and other projects. Nick Arnis said that he spoke with a variety of partners, and they will reach out to the owners of larger parcels in the area as well. This may eliminate some of the logjam for the entitlement process. (He referred to a map of the area, a copy of which is attached for reference) They do not want to preclude anything at this point. However, there will be some properties that need to be included. Mr. Anderson asked if they know what results they may have in getting the grant. Mr. Arnis stated that DLCD thought it was a viable project. Chair Unger said that other agencies in this region might also want grant funds, so they need to be asked if this is that important to Region 4. Commissioner Baney stated that perhaps they could offer support next year to another agency. Region 4 runs from the Columbia River to the California state line, down the middle of Oregon. Mr. Arnis said that the Governor's Office encouraged them to go for this grant. Chair Unger stated that the County has a brownfields grant that could add value to the project, for the demolition landfill or any of the other properties in the area with potential brownfields issues. Mr. Arnis said they seem to be willing to be flexible with the scope of the project. The grant is due by June 14, and the award will occur in about a year. The whole amount is needed and more, but they feel fairly confident this project will be given a lot of consideration. Mr. Lelack said that the timeline for this application and the brownfields grant for the County are very similar, and they can look at the same areas. The brownfields grant is for three years, and they need to identify various sites. This could be focused to certain locations. Minutes of Board of Commissioners' Work Session Wednesday, June 5, 2013 Page 3 of 5 Commissioner Baney asked if the City should be the lead applicant. She also asked if there is something that can be offered to other communities who are seeking smaller amounts. Mr. Arnis stated he could speak to the City Council about perception issues and how to mitigate those. Chair Unger said that he is interested in the project, but there has to be lasting value for the county's property. Commissioner Baney stated they want to see this succeed, so she feels they should put off the Deschutes River Woods planning process.. Mr. Russell said that ideally, there will be grant funds to do the DRW process, but they can do much of it in house, it will just take longer. There biggest concerns are transportation improvements, dealing with the at-grade railroad crossing, better access to the river, and a transitional plan to become part of the City in the future. Chair Unger said it appears the Board is supportive and wants to be a viable partner. They can bring something to the table when the time is right. Commissioner Baney asked if other counties might support this as a regional improvement. She wants to avoid the perception that it is just a Bend application. Chair Unger said the regional solutions group has this as a priority, and there are representatives from a variety of entities on that committee. Being no further items addressed, the work session ended at 4: 00 p.m. Minutes of Board of Commissioners' Work Session Wednesday, June 5, 2013 Page 4 of 5 DATED this % Day of qt"X~ 2013 for the Deschutes County Board of Commissioner . ATTEST: Recording Secretary "A,- L/6~ Alan Unger, Chair 2 r ~Y-t4 , Tammy Baney, Vi Chair Anthony DeBone, Commissioner Minutes of Board of Commissioners' Work Session Page 5 of 5 Wednesday, June 5, 2013 Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.or> WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., WEDNESDAY, JUNE 5, 2013 Finance/Tax Update - Marty Wynne 2. Discussion of Next Public Real Property Auction - Teresa Rozic (some possibly in executive session) 3. 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 192.660(2) (b), personnel issues. Meeting dates, times and discussion items are subject to change. All meetings are conducted in the Board of Commissioners' meeting rooms at 1300 NW Wall St., Bend, unless otherwise indicated. 1f you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA June 5, 2013 (1) Monthly Investment Report (2) April 2013 Financials rn ° M n ~ c ' r N O! 4) 0 LO n It E l r ~ Q cc w CO t~O 0 V I C4 ~ C N r.r C N N ~ ER tri E U) 0 v r v v ' Ci > ii M 0 CD C CD CO t f C D t o t G a 69 v► LO in ao ac C N 00 CO N a) O It E C CN C4 d d .g E x LL ~ 0 r ~ ~ m _ - c E 3 O y O U U E c a m N y N N c LL E C 4t N d 41 E y, U) w J C U) N C C ~p r c H d U 0 eeeeeee o O LO Cat O 4 4 ~ O 4 f` tq C! C! 0 O M to n M O O r r~ CO C) N N t (C Cl t 1 t n vc tp e'J ao 00 N CO ~ N ~ It N I` r -I ti OI N Ca 144 N CL CO n U H C rn a) CO a) a) a- p CO "C C U E 70 Z .2 air Ca Q¢~ a~ a) C2 a) E 5L) tLo ~m C CU a) Y ( E EL _0 d O O •E Q) C6 Ur p L) L) LL CO J f- 7+ ° o }r r 01 L 7 O 4. N t N N ~.u O C C X22 Co Nt !W' N Document Reproduces Poorly (archived) 0 0 e e e O o e e CO C) O ti N N r r O r M N a) d 7 C w M O N E Ch M N (D CU 0 O ~ (U CO a 15 7 to N L t ~ U ea z E C c Q L O •0 r ~ w O O CO m U E o L a) E a E °r N (n 0 C rn Uj-1LL mHUU ° rn N CL N ~(D ~ C e ~ ~ y d C O LL E Q F F C U 4 d ao m t~ J ~ C 0 N e EL O a m 0 H ! I , I 0 m C) U U U U U U U U U U U U U1 U U 0 In co 0 0 C ) a K A IZ Z Z Z Z z z z z z z z z z Z2 o ti to o c o In c d I c ai tri a d d ~ a z I ,I I _ O 0 i N N .d "t M c! Cp O r r 0 O M M rn O a O s O co 1n O Q r r M M M O P7 ao r cm Io ~t n cm N 41 N Iq Q G CG O m Il- IN cm M 00 N M c0 Cl) to N m 11] 6 R I o N 1l M ' n N IN O r M 4 Co N P7 N O O to ' O W O N ! co N co an O m CD Cl M r O _ M O O Q7 O C 47 47 CO (Yl u) ~ O? C j. O O Ili R BOO O N LO CD S 0 M N O M Nr ~ S S O ccoo co N M 00 <00 co N r' N Q O fV r r O r N N I r, r r r fD M R N n d N N N C SF N N N O O r N N ~ O N C I r r r - er► w O cO7 N N n ~ 00 t: 0 O CO M Lo CO rn po O O r~ w 0 O o O O O N N O O .0 O M O M co r N C5 N q (O iN O M t+ ap O R C7 4 O) O fV 00 co O n jd ►J O 1 C, R r co N n N N R O o M al CD cC CO n ao 01 r O N ao V cD ci N u1 O u) M N ~ O cm O 10 r O to 4 M (D 0 c, O m O m 0 0 1- b N IN u) 6 W O O O N N 0 0 N 4 O r d r _ p co 0 R (V R N co M O O r ch r 7 Cr t) r O M to V N Of O N N N N N N r N N O) r 4 (D r N cc r Will 0 0 0 0 0 4 8 0 0 0 S 0 4 0 0 0 0 a 0 -~r -3 CS O V ''r M O M d~ ry O O O O O O O o C : r O 0 S 0 0 0 0 0 0 0 0 Ci 0 0 0 0 0 4 S O O u) ti 0 co 0 S 0 1- 0 R ~ ,cD N C. N co u o CS Q ~ 0 1 0 O N O O v M c j 4 N S jd p S O Co o O o ' O O O N O v O v O O CS v N ll7 p S O o N o M u) CD' C N O o O t r r v r C 7 r r N I N CO r r r f r cwt r N N N N N N r N N o; cd r ~ o 0 r r • a O w y o to OL 4) _ m d o . l N U E eE a o 0 0 o a o 0 0 0 l o a z c j N i u') r CD rM o t j 0o o Lo Lo o r o nl, 0 1 u) r n O o v O 0 m O 0 n . o I Co O N to I,- t_n ' I I co n A a 1o a N n m W! o rnm n} N m C - I a O r 0 0 0 0 0 0 c 0 4 6 cs a 4 a o E N H ~ p~ Y d E o , ` E cn U U 1= =1 LL co -1 H o e o OR c o m Oo °o t ° n ° o t °n o 3 to i n i to v r~ ) n r o (K u u C c U E Y M G ' a a ~1 o v Y ~ E o o - • M ~ m I I 2 1 i d - IE o - - _ c 3 a O r, o N M ^ 1- ;g Lf) ;s LO M r ti rn t v (j o i o f v O 'I Lo (D O (MI N n -t O n N' n I M so m ~ C - Z O Y C ~ M M M v v v v ~ Ul tn tn tn 0 o L... ' r r r r r r r r r r 1 rn o 1 u E g O 47 o N Ill o N co CD O 1, o O co o C1 a O N O o O c0 o u7 C7 O n 0 a N r o r M r o C. ~N o M C7 O 1 m J Q _ I V ~ ! ! m r ~ ° m F 1 + m W r r - N N . M r M r M r T I ~ ` r B N O N O ` N O O 4 ~1 4 r _ r O O r 4 O _ r Nt O 11,- (0 0 4 0 1 0 _ O r C, r r Q j 0 4 0 0 4 r _ S N r N C7 N r f0 o n 0 0 d' 0 cV 0 M 0 O Q L1 Q LL CO } 7 i m Z F IL ~ LL Q d Z Q Q m m U U x Y i a 0. x V! V1 D VJ j m C] C3 LL F F sdRl V ❑ V d n ~ ~ I ❑ U ~I I d U U U 1 - >fuse U u D! LL 2t LL 2 LL'' U Ci ~ z U) a Q u u 2 LL U . : - I - - z CO oo I co E CO m 2 2 ao Y d 2 ¢ ¢ m a 0 z ca o to C7; 2 7 O. to 1. N n N N co cy S u) C14 O S = O 7. 7 rn rn co v cD w w v E N € U M y rn a 0 ❑ U Z U ❑ I ❑ ❑ z L) c) (n N cn Y ' Y ` N C - N G~ l a) O d ❑ U ` o O U I U = N Co M t p in t c m c a m m . ae c: O L 0 -lid U) cm m L7 U) Y m ❑ U O EL c co co U ❑ a) ❑ L) ❑ V I c' m c cC I N ~ CJ m U 7d ~ 12 fn Z c O o c~ ¢ z 4) C a Q z cd m rn p C ) ~ cu U 01 - 0 6 U S? 1 0 O ~ n ' c= ffi ❑ o m c ol ¢ ° U c~~i l w C U _C > C m . O c` Q) id C co L U C C', N U I L U N O ! c c j a E 3 N E m - d N U m c z Q a s m y c E E o E ~ N n~ N F- • 0> ro Co LM -0 4) N 5 m c Co LM l co m m m r il m U o U o 2 m Y a d~ m w a~ n w cn E ~ m ~ w ~ o m 0 U 0 U 5 O > 01 c :3 LL LL - -5 - LL ro _ o < LL 1. dl m cry 1 L ~ C m Q a co - N E E a a a 0 M Q a E N c O 0 (ED rp E W W ~ - - - W m - - 7 m 6 d E a) o o E a E ' o , a o! 0 o t9 w to ° _ 3: W vw 5 ~ z o 5 5 - 1 U L m ~ Memorandum Date: May 28, 2013 To: Board of County Commissioners Tom Anderson, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find April 2013 financial reports for the following funds: General (001), Community Justice Juvenile (230), Sheriffs (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705), Health Benefits Trust (675), and Fair & Expo Center (618). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End $ Bud et Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 8,700,000 $ 9,059,394 $ 359,394 100% 104% $8,700,000 $9,059,394 $ 359,394 Revenues Tax Revenues - Current 16,826,300 19,800,722 2,974,422 83% 98% 20,191,560 20,774,199 582,639 Tax Revenues - Prior 566,667 1,008,137 441,470 83% 148% 680,000 1,008,137 328,137 Gen. Rev. - excl. Taxes 1,989,443 2,312,829 323,386 83% 97% a) 2,387,331 2,687,331 300,000 Assessor 623,855 833,554 209,699 83% 111% b) 748,626 833,626 85,000 County Clerk 1,150,019 1,315,137 165,118 83% 95% 1,380,023 1,620,023 240,000 BOPTA 10,332 16,419 6,087 83% 132% b) 12,398 16,419 4,021 District Attorney 153,912 132,809 (21,103) 83% 72% 184,694 184,694 - Finance/Tax 165,750 248,736 82,986 83% 125% b) 198,900 288,736 89,836 Veterans 57,000 55,836 (1,164) 83% 82% c) 68,400 74,198 5,798 Property Management 82,703 78,537 (4,166) 83% 79% 99,244 99,244 - Grant Projects 1,667 1,667 (0) 83% 83% 2,000 2,000 - Total Revenues 21,627,648 25,804,382 4,176,734 83% 99% 25,953,176 27,588,607 1,635,431 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) 30,327,648 34,863,776 4,536,128 83% 101% 2,973,127 2,832,496 140,631 1,223,032 1,058,555 164,477 60,321 50,394 9,927 4,395,556 4,162,435 233,121 694,888 652,528 42,360 217,493 207,635 9,858 226,689 229,853 (3,164) 101,958 102,262 (304) 1,428,893 813,555 615,338 5,045,440 5,045,440 16,367,397 10,109,713 6,257,684 11,581,377 11,609,971 28,594 27,948,774 21,719,684 6,229,090 2,378,875 13,144,093 10,765,219 Beginning Net Working Capital per Proposed Budget 9,500,000 a) Includes annual payments: PILT $730,983. FY 2012 PILT was $471,723 b) A & T Grant received quarterly. YTD includes four quarters - July, October, January and April c) State payment received quarterly. YTD includes three quarters. 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 Exp. 34,653,176 36,648,001 1,994,825 83% 79% 3,567,752 3,467,752 100,000 83% 72% 1,467,638 1,361,638 106,000 83% 70% 72,385 72,385 - 83% 79% 5,274,667 5,074,667 200,000 83% 78% 833,865 833,865 - 83% 80% 260,992 260,992 - 83% 84% 272,027 272,027 - 83% 84% 122,349 122,349 - 83% 47% d) 1,714,671 1,414,671 300,000 83% n/a 6,054,528 - 6,054,528 83% 51% 19,640,874 12,880,346 6,760,528 83% 84% 13,897,652 13,897,652 - 83% 65% 33,538,526 26,777,998 6,760,528 e) 1,114,650 9,870,003 _ 8,755,353 Page 1 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $1,010,415 $ 995,051 $ (15,364) 100% 98% $1,010,415 $ 995,051 $ (15,364) Revenues Federal Grants 5,000 - (5,000) 83% 0% a) 6,000 6,000 - SB #1065-Court Assess. 3,223 6,786 3,563 83% 175% b) 3,867 7,000 3,133 Jail Funding HB #2712 - 27,849 27,849 83% 60% b) 46,133 37,000 (9,133) Discovery Fee 10,833 7,383 (3,451) 83% 57% 13,000 9,800 (3,200) Food Subsidy 17,500 20,589 3,089 83% 98% C) 21,000 28,000 7,000 OYA Basic & Diversion 312,789 285,112 (27,677) 83% 76% d) 375,347 375,347 - Inmate/Prisoner Housing 50,000 110,280 60,280 83% 184% c) 60,000 140,000 80,000 Inmate Commissary Fees 83 231 148 83% 231% 100 250 150 Contract Payments 101,667 80,734 (20,933) 83% 66% e) 122,000 100,000 (22,000) Miscellaneous 167 59 (108) 83% 29% 200 100 (100) Program Fees 42 - (42) 83% 0% 50 - (50) MIP Diversion Fees 833 275 (558) 83% 28% 1,000 375 (625) Interest on Investments 6,667 5,241 (1,426) 83% 66% 8,000 6,250 (1,750) Leases 1,000 1,100 100 83% 92% 1,200 1,200 - Grants - Private 417 1,424 1,007 83% 285% c) 500 1,500 1,000 CFC Interfund Grant 104,718 91,856 (12,862) 83% 73% f) 125,661 125,661 - Interfund Grant - Gen Fund 16,667 15,000 1,667 83% 75% d) 20,000 20,000 - Total Revenues 631,606 653,917 22,311 83% 81% 804,058 858,483 54,425 Transfers In-General Fund 4,453,770 4,453,770 - 83% 83% 5,344,523 5,344,523 - TOTAL RESOURCES 6,095,791 6,102,738 6,947 83% 85% 7,158,996 7,198,057 39,061 REQUIREMENTS: Exp. °r° Expenditures Community Justice-Juvenile Personnel Services 4,229,181 4,099,576 129,605 83% 81% g) 5,075,017 4,964,036 110,981 Materials and Services 994,967 875,587 119,380 83% 73% g) 1,193,960 1,050,000 143,960 Capital Outlay 83 - 83 83% 0% 100 - 100 Transfers Out 42,000 37,800 4,200 83% 75% h) 50,400 50,400 - Contingency 699,599 - 699,599 83% n/a 839,519 - 839,519 TOTAL REQUIREMENTS 5,965,830 5,012,963 952,867 83% 70% 7,158,996 6,064,436 1,094,560 NET (Resources - Requirements) 129,961 1,089,775 959,814 - 1,133,621 1,133,621 Beginning Net Working Capital 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 - $600 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 Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 100% n/a $ - $ - $ - Revenues Law Enf Dist Countywide 18,801,355 15,456,549 (3,344,806) 83% 69% * 22,561,626 18,928,451 (3,633,175) Law Enf Dist Rural 12,034,743 10,168,505 1,866,238 83% 70% * 14,441,692 _ 12,203,032 (2,238,660) Total Revenues 30,836,098 25,625,054 (5,211,044) 83% 69% 37,003,318 31,131,483 (5,871,835) TOTAL RESOURCES 30,836,098 25,625,054 (5,211,044) 83% 69% 37,003,318 31,131,483 (5,871,835) REQUIREMENTS: EXPENDITURES TRANSFERS Sheriffs Division 1,886,358 Civil 665,824 Automotive/Communications 1,506,208 Investigations/Evidence 1,256,817 Patrol/Civil/Comm Supp 6,891,132 Records 598,014 Adult Jail 9,066,693 Court Security 252,501 Emergency Services 162,111 Special Services Division 1,121,698 Regional Work Center 2,219,232 Training Division 420,792 Other Law Enforcement Svcs 536,253 Non-Departmental 71,044 Contingency 4,181,422 TOTAL REQUIREMENTS 30,836,099 Exp. 1,893,340 (6,982) 83% 84% 2,263,630 2,263,630 - 601,687 64,137 83% 75% a) 798,989 744,889 54,100 1,535,222 (29,014) 83% 85% b) 1,807,450 1,812,450 (5,000) 1,195,245 61,572 83% 79% a) 1,508,180 1,468,080 40,100 6,816,266 74,866 83% 82% a) 8,269,358 8,113,497 155,861 576,396 21,618 83% 80% a) 717,617 677,517 40,100 8,497,292 569,401 83% 78% c) 10,880,032 10,425,532 454,500 249,271 3,230 83% 82% 303,001 302,901 100 155,460 6,651 83% 80% 194,533 194,433 100 984,990 136,708 83% 73% 1,346,037 1,328,069 17,968 2,110,653 108,579 83% 79% d) 2,663,078 2,522,978 140,100 377,743 43,049 83% 75% 504,950 508,850 (3,900) 560,446 (24,193) 83% 87% e) 643,504 683,404 (39,900) 71,044 (0) 83% 83% 85,253 85,253 - - 4,181,422 83% n/a 5,017,706 - 5,017,706 25,625,054 5,211,045 83% 69% 37,003,318 31,131,483 5,871,835 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, $76,417 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 Ten Months Ended April 30, 2013 RESOURCES: Beg. Net Working Capital Tax Revenues - Current Tax Revenues - Prior Federal Grants & Reimb State Grant Jail Funding HB 2712 Transp. of State Wards S61145 Prisoner Housing Des. Cty Video Lottery Grant Grants Des Cty Court Security Des Cty Juvenile Contract Title III Reimbursement Transport Other DC Fair & Expo Center Inmate Commissary Fees Work Center Work Crews Concealed Handgun Classes Inmate Telephone Fee Soc Sec Incentive-Fed Miscellaneous Oregon Mentors Debit Card Fee Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Grants Donations - "Shop with a Cop" Land Sale Revenue Sale of Reportable Assets Total Revenues TOTAL RESOURCES REQUIREMENTS: Fund 255 Departments: Sheriffs Services Civil Auto/Comm Adult Jail Court Security Emergency Services Special Services Work Center Training Other (CODE, Forensic) Non Dept - ISF Charges Contingency Total to Fund 255 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $4,507,352 $ 5,883,963 $ 1,376,611 100% 131% $ 4,507,352 $5,883,963 $ 1,376,611 12,821,450 15,109,793 2,288,343 83% 98% 3) 15,385,740 15,642,467 256,727 366,667 739,750 373,083 83% 168% 440,000 739,750 299,750 25,000 24,510 (490) 83% 82% b) 30,000 24,510 (5,490) 61,667 105,734 44,067 83% 143% c) 74,000 140,448 66,448 - 27,849 27,849 83% n/2 d - 46,133 46,133 4,167 3,289 (878) 83% 66% 5,000 5,000 - 1,233,326 1,479,991 246,665 83% 100% 1,479,991 1,479,991 0 41,667 185,538 143,871 83°% 371% e) 50,000 185,538 135,538 4,167 5,000 833 83% 100% 5,000 5,000 - - 17,640 17,640 83% n/a - 17,640 17,640 200,833 77,731 (123,103) 83% 32% f) 241,000 116,597 (124,403) 3,483 6,183 2,700 83% 148°% 4,180 8,000 3,820 - 26,795 26,795 83% n/a g) - 39,916 39,916 417 1,753 1,336 83% 351% 500 1,820 1,320 2,917 7,288 4,371 83% 208% 3,500 7,288 3,788 3,333 756 (2,577) 83% 19°% 4,000 4,000 - 8,333 17,368 9,035 83% 174% 10,000 19,823 9,823 41,667 34,007 (7,660) 83% 68% 50,000 50,000 - 2,917 7,075 4,158 83% 202°% 3,500 8,000 4,500 66,667 64,283 (2,384) 83% 80% 80,000 80,000 - 4,167 11,400 7,233 83% 228% 5,000 11,400 6,400 4,167 6,276 2,109 83% 126% 5,000 6,628 1,628 833 - (833) 83% 0% 1,000 1,000 - 83 462 379 83% 462% 100 500 400 10,833 12,683 1,850 83% 98% 13,000 13,000 - 4,167 - (4,167) 83% 0% 5,000 5,000 208,333 247,394 39,061 83% 99% 250,000 250,000 - 23,611 36,127 12,516 83% 128°% 28,333 39,666 11,333 2,944 1,302 (1,642) 83% 37% 3,533 3,533 - - 3,000 3,000 83% n/a - 3,000 3,000 43,248 52,790 9,542 83% 102% 51,897 52,790 893 - 3,309 3,309 83% n/a - 3,309 3,309 4,167 574 (3,593) 83°% 11% 5,000 5,000 - 15,195,231 18,317,650 3,122,419 83% 100% 18,234,274 19,016,746 782,472 19,702,583 24,201,612 4,499,029 83% 106% 22,741,626 24,900,709 2,159,083 Exp. 1,761,048 1,767,565 (6,518) 83°% 665,824 601,687 64,137 83% 555,414 566,113 (10,699) 83% 9,066,693 8,497,292 569,402 83% 252,501 249,271 3,230 83% 162,111 155,460 6,651 83°% 776,147 681,554 94,593 83% 2,219,232 2,110,653 108,579 83% 257,230 230,914 26,316 83% 536,253 560,446 (24,193) 83% 35,593 35,593 (0) 83% 2,513,309 - 2,513,309 83% 18,801,355 15,456,549 3,344,806 84% 2,113,257 2,113,257 - 75% 798,989 744,889 54,100 85% 666,497 668,341 (1,844) 78°% 10,880,032 10,425,532 454,500 82% 303,001 302,901 100 80% 194,533 194,433 100 73% 931,377 918,944 12,433 79% 2,663,078 2,522,978 140,100 75% 308,676 311,060 (2,384) 87% 643,504 683,404 (39,900) 83% 42,712 42,712 - n/a 3,015,970 - 3,015,970 22, 561,626 18,928,451 3,633,175 Transfer to Reserve Fund (703) 83,333 100,000 (16,667) 83% 100°% 100,000 100,000 Non Dept - Comm System Res 66,667 80,000 (13,333) 83% 100% 80,000 80,000 - Total Requirements 18,951,355 15,636,549 3,314,805 83% 69% 22,741,626 19,108,451 3,633,175 Net 751,228 8,565,064 7,813,836 - 5,792,258 5,792,258 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 Fen Months Ended April 30, 2013 F_ Year to Date FY 2013 Year End Budget Actual Variance FY % Coll, % Budget. Pro ection 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 TaxRevenues - Current 6,291,667 7,356,206 1,064,539 83% 97% a) 7,550,000 7,615,538 65,538 Tax Revenues - Prior 191,667 366,542 174,875 83% 159% 230,000 366,542 136,542 Federal Grants & Reimb 12,500 35,037 22,537 83% 234% b) 15,000 35,037 20,037 Federal Grants-BLM 21,667 14,759 (6,908) 83% 57% 26,000 26,000 - US Forest Service 62,500 59,063 (3,438) 83% 79% 75,000 75,000 Bureau of Reclamation 21,667 18,830 (2,838) 83% 72% 26,000 26,000 - State Grant 157,662 205,740 48,078 83% 109% c) 189,194 262,800 73,606 SB #1065 Court Assessment 45,833 6,786 (39,047) 83% 12% d) 55,000 6,786 (48,214) Marine Board License Fee 118,409 57,765 (60,644) 83% 41% 142,091 142,091 Des Cty General Fund Grant 480,613 - (480,613) 83% 0% c) 576,735 576,735 Des Cty Transient Room Tax 1,727,721 1,727,721 (0) 83% 83% 2,073,265 2,073,265 - Des Cty Tax Office Contract 417 540 123 83% 108% 500 540 40 Asset Forfeiture - 11,760 11,760 83% n/a - 11,760 11,760 City of Sisters 389,967 390,067 100 83% 831y. 467,960 467,960 - Des Cty CDD Contract 45,305 45,305 0 83% 831/ 54,366 54,366 Des Cty Solid Waste Contr 45,305 45,305 0 83% 83% 54,366 54,366 - Des Cty Clerk/Election 833 1,068 235 83% 107% 1,000 1,400 400 School Districts 33,333 31,742 (1,591) 83% 79% 40,000 40,000 - Claims Reimbursement - 860 860 83% n/a - 860 860 Security & Traffic Reimb 4,167 - (4,167) 83% 0% 5,000 5,000 - Seat Belt Program 8,333 4,410 (3,923) 83% 44% 10,000 10,000 - Miscellaneous 5,000 9,298 4,298 83% 155% 6,000 10,000 4,000 False Alarm Fees 1,667 3,400 1,733 83% 170% 2,000 4,000 2,000 Restitution 4,167 1,324 (2,843) 83% 26% 5,000 5,000 - Sheriff Fees 8,333 7,877 (456) 83% 79% 10,000 10,000 Court Fines & Fees 100.000 102,914 2,914 83% 86% 120,000 120,000 Impound Fees 3,333 3,726 393 83% 93% 4,000 4,000 Restitution - Street Crimes 417 - (417) 83%> 0% 500 500 Seizure/Forfeiture 833 140 (693) 83% 141/ 1,000 1,000 - Interest 8,333 17,229 8,896 83% 172% 10,000 17,500 7,500 Interest on Unsegregated 1,500 635 (865) 830/o 35% 1,800 1,800 - Grants-Private - 6,500 6,500 83% n/a - 6,500 6,500 Donations 9,120 9,120 83% n/a 9,120 9,120 Land Sale Revenue 1,611 1,611 830/,, n/a 1,611 1,611 Sale of Equip & Material 8,333 3,706 (4,627) 83% 37% 10,000 5,000 (5,000) Sale of Reportable Assets 33 333 12,167 (21,166) 83% 30% f) 40,000 20,000 20,000 Total Revenues 9,834,816 10,559,152 724,338 50% 89% 11,801,777 12,068,077 266,300 TOTAL RESOURCES 12,694,731 13,803,723 1,108,993 50% 94% 14,661,692 15,312,648 650,956 REQUIREMENTS: Exp. Fund 255 Departments, Sheriff's Services 125,311 125,775 (464) 83% 84% 150,373 150,373 Auto/Comm 950,794 969,109 (18,315) 83% 85% 1,140,953 1,144,109 (3,156) Investigations 1,256,817 1,195,245 61,572 83% 79% 1,508,180 1,468,080 40,100 Patrol 6,891,132 6,816,266 74,866 83% 82% 8,269,358 8,113,497 155,861 Records 598,014 576,396 21,618 83% 80% 717,617 677,517 40,100 Special Services 345,550 303,436 42,114 83% 73% 414,660 409,125 5,535 Training 163,562 146,829 16,733 83% 75% 196,274 197,790 (1,516) Non Dept - ISF Charges 35,451 35,451 (0) 83% 83% 42,541 42,541 - Contingency 1,668,113 - 1,668,113 83% n/a 2,001,736 - 2,001,736 Total to Fund 255 12,034,743 10,168,505 1,866,238 14,441,692 12,203,032 2,238,660 Transfer to Reserve Fund (704) 83,333 100,000 (16,667) 83% 100% 100,000 100,000 - Non Dept - Comm System Res 100,000 120,000 (20,000 83% 100% 120,000 120,000 - Total Requirements ^12,218,077 10,388,505 1,829,571 83% 71% 14,661,692 12,423,032 2,238,660 Net 476,654 3,415,217 2,938,564 - 2,889,616 2,889,616 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 f) Less than planned revenue from sale of surplus vehicles Page 5 Payment to Sheriffs Fund adjusted monthly to equal actual expenditures attributable to rural services PUBLIC HEALTH Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End I 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 833 68 (766) 83% 7% 1,000 100 (900) Federal Grant - 9,000 9,000 83% n/a - 9,000 9,000 Federal Grant (ARRA) 166,667 212,500 45,833 83% 106% 200,000 212,500 12,500 State Grant 2,428,624 2,033,002 (395,622) 83% 70% 2,914,349 2,934,303 19,954 Child Dev & Rehab Center 33,008 20,039 (12,969) 83% 51% a) 39,609 39,609 - State Miscellaneous 112,283 120,320 8,037 83% 89% a) 134,740 134,740 - OMAP 522,990 446,863 (76,127) 83% 71% 627,588 608,494 (19,094) Title 19 293 - (293) 83% n/a 352 - (352) Family Planning Exp Proj 458,333 389,838 (68,495) 83% 71% 550,000 550,000 - Local Grants 40,000 10,000 (30,000) 83% 21% 48,000 40,150 (7,850) Environmental Health-Water 76,833 51,678 (25,155) 83% 56% 92,200 92,200 - Contract Payments 86,508 131,614 45,106 83% n/a 103,810 173,404 69,594 Miscellaneous - 2,172 2,172 83% n/a - 3,000 3,000 Patient Insurance Fees 161,000 184,249 23,249 83% 95% 193,200 193,200 - Health Dept/Patient Fees 85,917 78,338 (7,579) 83% 76% 103,100 85,000 (18,100) Vital Records-Birth 34,167 27,655 (6,512) 83% 67% 41,000 32,000 (9,000) Vital Records-Death 83,333 92,765 9,432 83% 93% 100,000 100,000 - Environmental Health-Lic Fac 600,042 705,047 105,005 83% 98% b) 720,050 740,050 20,000 NSF Fee - 30 30 83% n/a - 30 30 Interest on Investments 10,000 5,059 (4,941) 83% 42% 12,000 5,800 (6,200) Grants-private 14,063 33,753 19,690 83% 200% 16,876 34,000 17,124 Donations 4,417 19,219 14,802 83% 363% 5,300 22,277 16,977 Interfund Contract 132,191 122,949 (9,242) 83% 78% 158,629 164,000 5,371 Administrative Fee 667 667 (0) 83% 83% 800 800 - Total Revenues 5,052,169 4,696,824 (355,345) 83% 77% 6,062,603 6,174,657 112,054 Transfers In-General Fund 1,957,800 1,957,800 - 83% 83% 2,349,357 2,349,357 - Transfers In-PH Res Fund 50,113 45,102 (5,011) 83% 75% 60,136 60,136 - Transfers In-Gen. Fund Other 54,250 48,825 (5,425) 83% 75% 65,100 65,100 TOTAL RESOURCES 8,450,383 8,075,750 (374,633) 83% 82% 9,873,247 9,976,449 103,202 REQUIREMENTS: Exp. °i° Expenditures Personnel Services 5,378,921 5,274,067 104,854 83% 82% 6,454,705 6,325,000 129,705 Materials and Services 1,784,898 1,587,490 197,408 83% 74% 2,141,878 2,136,883 4,995 Capital Outlay 54,167 - 54,167 83% 0% c) 65,000 - 65,000 Transfers Out 131,000 117,900 13,100 83% 75% 157,200 157,200 - Contingency 878,720 - 878,720 83% n/a 1,054,464 - 1,054,464 TOTAL REQUIREMENTS 8,227,706 6,979,457 1,248,249 83% 71% 9,873,247 8,619,083 1,254,164 NET (Resources - Requirements) 222,677 1,096,293 873,616 - 1,357,366 1,357,366 Beginning Net Working Capital per Proposed Budget 1,385,592 a) Received quarterly in arrears b) Restaurant and Pool/Spa fees a re due annually and received i n Dec/Jan Page 6 c) OCHIN System expenditure made in FY 2012 BEHAVIORAL HEALTH Statement of Financial Operating Data Ten Months Ended April 30, 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 Total Revenues Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance $3,320,968 $ 3,113,095 $ (207,873) 100% 5,417 4,375 (1,042) 83% 133,333 102,496 (30,837) 83% 38 85 47 83% 210,291 124,784 (85,507) 83% 53,125 42,500 (10,625) 83% 6,496,333 6,186,752 (309,581) 83% 51,550 31,461 (20,089) 83% 166,667 229,038 62,371 83% 224,538 82,042 (142,496) 83% 117,917 79,479 (38,438) 83% 57,500 18,150 (39,350) 83% - 34 34 83% - 12,291 12,291 83% 72,943 83,372 10,429 83% 792 1,265 473 83% 20,833 16,791 (4,042) 83% 15,417 12,625 (2,792) 83% - 168 168 83% 4,410,439 4,332,474 (77,965) 83% 105,833 78,084 (27,749 83% 12,142,966 11,438,265 (704,701) 83% 94% 67% 64% 189% 49% a) 67% 79% b) 51% 115% 30% 56% 26% C) n/a n/a 95% 133% 67% 68% n/a 82% 61% a) 78% Transfers In-General Fund 1,089,822 1,089,823 0 83% 83% Transfers In-OHP-CDO 403,745 403,745 - 83% 83% Transfers In-Acute Care Svcs 220,530 220,530 - 83% 83% Transfers In-ABHA 436,700 436,700 - 83% 83% TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 17,614,731 16,702,157 (912,574) 83% 82% Exp. 9,633,918 9,032,357 601,561 83% 78% 5,502,463 4,567,446 935,017 83% 69% 41,750 (33,417) 75,167 83% -67% 170,000 153,000 17,000 83% 75% 1,713,100 - 1,713,100 83% n/a 17,061,231 13,719,385 3,341,846 83% 67% 553,500 2,982,772 2,429,271 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 $ 3,320,968 $ 3,113,095 $ (207,873) 6,500 6,500 - 160,000 125,056 (34,944) 45 100 55 252,349 252,349 - 63,750 63,750 - 7,795,599 7,883,477 87,878 61,860 61,860 - 200,000 230,000 30,000 269,446 125,000 (144,446) 141,500 100,000 (41,500) 69,000 21,900 (47,100) - 100 100 - 12,500 12,500 87,532 100,000 12,468 950 1,500 550 25,000 20,500 (4,500) 18,500 18,500 - - 168 168 5,292,527 5,292,527 - 127.000 127.000 - 14,571,558 14,442,787 (128,771) 1,307,787 1,307,787 - 484,494 484,494 - 264,631 264,631 - 524,039 524,039 - 20,473,477 20,136,833 (336,644) 11,560,702 10,835,000 725,702 6,602,955 5,550,000 1,052,955 50,100 30,000 20,100 204,000 204,000 - 2,055,720 - 2,055,720 20,473,477 16,619,000 3,854,477 - 3,517,833 3,517,833 3,461,651 Page 7 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Ten Months Ended April 30, 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 % Call. % Budget Pro'ection Variance $ 10,000 192,482 $ 182,482 100% 1925% $ 10,000 $ 192,482 182,482 18,408 24,915 6,507 63% 113% 22,090 24,483 2,393 1,042 543 (500) 83% 43% a) 1,250 1,000 (250) 138,500 190,898 52,398 83% 115% 166,200 178,000 11,800 1,061,313 1,237,714 176,401 83% 97% 1,273,575 1,190,747 (82,828) 213,333 267,376 54,043 83% 104% 256,000 268,496 12,496 93,000 99,931 6,931 83% 90% 111,600 184,800 73,200 260,809 260,710 (99) 83% 83% 312,971 283,140 (29,831) 531,125 602,149 71,024 83% 94% 637,350 613,255 (24,095) 188,684 271,529 82,845 83% 120% 226,421 266,897 40,476 2,506,214 2,955,765 449,551 83% 98% 3,007,457 3,010,818 3,361 712,390 712,390 - 83% 83% 854,872 854,872 - 412,800 412,800 - 83% 83% 495,360 495,360 - 74,648 85,409 10,761 83% 95% 89,577 89,577 - 83 - 83 83% 0% 100 - 100 3,716,135 4,358,846 642,711 83% 98% 4,457,366 4,643,109 185,743 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations 1,127,658 1,094,003 33,655 Admin-GIS 98,148 96,193 1,955 Admin-Code Enforcement 190,771 174,075 16,696 Building Safety 517,573 500,673 16,900 Electrical 169,359 165,696 3,663 Contract Services 118,121 128,988 (10,867) Env Health-On Site Pgm 133,030 129,957 3,073 Planning-Current 535,263 483,105 52,158 Planning-Long Range 386,168 308,027 78,141 Transfers Out (D/S Fund) 149,296 170,818 (21,522) Contingency 289,087 - 289,087 TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 83% 81% b) 1,353,189 1,311,323 41,866 83% 82% 117,778 117,778 - 83% 76% b) 228,925 216,747 12,178 83% 81% 621,087 621,087 - 83% 82% 203,231 203,231 - 83% 91% C) 141,745 141,745 - 83% 81% 159,636 159,636 - 83% 75% d) 642,315 634,887 7,428 83% 66% d,e) 463,401 349,567 113,834 83% 95% 179,155 179,155 - 83% n/a 346,904 - 346,904 3,714,474 3,251,535 462,939 83% 73% 1,661 1,107,311 1,105,650 Beginning Net Working Capital per Proposed Budget Revenues Expenditures Net from Operations 2,955,765 3,251,535 (295,770) 4,457,366 3,935,156 522,210 - 707,953 707,953 696,290 3,007,457 3,010,818 3,361 4,457,366 3,935,156 522,210 1,449,909 924,338525,571 a) Revenue is sporadic throughout the year as GIS services are requested b) Reflects savings due to combined CDD & Planning Director positions c) Additional costs incurred for on-call building safety and electrical staff due to increased business activity d) Reflects savings due to Planning Director's reduced allocation e) Reflects savings from retired employee through 6/30/13 Page 8 ROAD Statement of Financial Operating Data Ten Months Ended April 30, 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 NET (Resources - Requirements) Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. 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 83% n/a - 3,000 3,000 5,833 7,335 1,502 83% 105% 7,000 71335 335 33,333 139,156 105,823 83% 348% 40,000 145,000 105,000 330,688 1,265,121 934,433 83% 319% a) 396,826 1,265,121 868,295 - 2,618 2,618 83% n/a - 2,618 2,618 451,908 542,290 90,382 83% 100% b) 542,290 542,290 - 8,991,703 8,854,056 (137,647) 83% 82% C) 10,790,043 10,450,000 (340,043) 20,833 - (20,833) 83% 0% d) 25,000 309,350 284,350 291,667 11,554 (280,113) 83% 3% d) 350,000 387,240 37,240 8,333 1,008 (7,325) 83% 10% d) 10,000 2,000 (8,000) 8,333 10,000 1,667 83% 100% d) 10,000 10,000 - - 2,662 2,662 83% n/a - 3,500 3,500 16,667 20,312 3,645 83% 102% 20,000 23,000 3,000 833 - (833) 83% 0% 1,000 500 (500) 12,500 26,163 13,663 83% 174% 15,000 32,000 17,000 - 1,948 1,948 83% n/a - 1,948 1,948 575,000 - (575,000) 83% o% e) 690,000 590,000 (100,000) 183,333 172,254 (11,079) 83% 78% 220,000 185,000 (35,000) 75,000 - (75,000) 83% 0% e) 90,000 80,000 (10,000) 8,333 - (8,333) 83% 0% 0 10,000 - (10,000) 20,833 - (20,833) 83% 0% e) 25,000 50,000 25,000 20,833 - (20,833) 83% o% e) 25,000 25,000 - 3,333 1,630 (1,703) 83% 41% 4,000 2,500 (1,500) 833 852 19 83% 85% 1,000 1,000 - 603,000 688,297 85,297 83% 95% 723,600 823,851 100,251 11,663,129 11,749,566 86,437 83% 84% 13,995,759 14,942,253 946,494 230,227 207,204 (23,023) 83% 75% g) 276,272 276,272 - 208,333 - (208,333) 83% 0% 0 250,000 - (250,000) 10,000 - (10,000) 83% 0% f) 12,000 - 12,000 - 6,333,706 6,333,706 6,014,368 16,831,240 16,680,622 57,715 83% 87% 19,253,582 19,942,377 688,795 Exp. 4,471,002 4,456,788 14,214 83% 83% h) 5,365,202 5,327,941 37,261 7,865,552 4,986,941 2,878,611 83% 53% i) 9,438,662 7,931,846 1,506,816 1,697,750 60,676 1,637,074 83% 3% j) 2,037,300 73,884 1,963,416 229,167 275,000 (45,833) 83% 100% 275,000 275,000 - 1,781,182 - 1,781,182 83% n/a 2,137,418 - 2,137,418 16,044,653 9,779,405 6,265,248 83% 51% 19,253,582 13,608,671 5,644,911 786,587 6,901,217 6,322,963 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 Page 9 ADULT PAROLE & PROBATION Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 570,000 $ 630,226 $ 60,226 100% 111% $ 570,000 $ 630,226 $ 60,226 Revenues DOC Measure 57 182,700 219,240 36,540 83% 100% a) 219,240 219,240 - State Miscellaneous 3,584 - (3,584) 83% 0% b) 4,301 4,301 - Alternate Incarceration 12,500 - (12,500) 83% 0% c) 15,000 (15,000) State Subsidy 11,522 22,329 10,807 83% 161% d) 13,826 22,329 8,503 SB 1145 2,290,462 2,7487555 458,093 83% 100% 2,748,556 2,748,556 - Probation Work Crew Fees 18,750 127126 (6,625) 83% 54% e) 22,500 14,180 (8,320) Miscellaneous 3,750 4,089 339 83% 91% 4,500 4,500 - Electronic Monitoring Fee 108,333 138,654 30,321 83% 107% f) 130,000 160,000 30,000 Probation Superv. Fees 158,333 148,594 (9,739) 83% 78% 190,000 178,000 (12,000) Interest on Investments 7,500 4,765 (2,735) 83% 53% 9,000 5,717 (3,283) Interfund - Sheriff 41,667 41,667 (0) 83% 83% 50,000 50,000 - Sale of Equipment - 250 250 83% n/a - 250 250 Crime Prevention Grant 41,667 37,500 (4,167) 83% 75% g) 50,000 50,000 - CFC-Domestic Violence 62,360 46,345 16,015) 83% 62% g) 74,832 74,832 - Total Revenues 2,943,128 3,424,112 480,984 83% 97% 3,531,755 3,531,905 150 Transfers In-General Fund 362,770 362,770 - 83% 83% 435,328 435,328 - TOTAL RESOURCES 3,875,898 4,417,108 541,210 83% 97% 4,537,083 4,597,459 60,376 REQUIREMENTS: Exp. Expenditures Personnel Services 2,576,076 2,447,801 128,275 83% 79% 3,091,291 3,041,291 50,000 Materials and Services 741,406 682,512 58,894 83% 77% 889,687 889,687 - Capital Outlay 83 - 83 83% 0% 100 - 100 Contingency 463,338 - 463,338 83% n/a 556,005 - 556,005 TOTAL REQUIREMENTS 3,780,903 3,130,313 650,590 83% 69% 4,537,083 3,930,978 606,105 NET (Resources - Requirements) 94,995 1,286,795 1,191,800 - 666,481 666,481 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 $8,000 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 Ten Months Ended April 30, 2013 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Youth Investment State Prevention Funds HealthyStart /R-S-G OCCF Grant Charges for Svcs-Misc Program Fees Court Fines & Fees Interest on Investments Grants, Private Interfund Grants Total Revenues Year to Date FY 13 Year End Budget Actual Variance FY % Coll. % L Budget Projection Variance $ 511,994 $ 567,120 $ 55,126 100% 111% $ 511,994 $ 567,120 $ 55,126 253,797 192,261 (61,536) 32,944 28,545 (4,399) 70,833 62,745 (8,088) 164,082 154,986 (9,096) 40,102 58,870 18,768 183,291 164,961 (18,330) 349,830 296,149 (53,681) 6,667 3,781 (2,886) - 4,765 4,765 66,238 61,674 (4,564) 833 3,117 2,284 1,667 - (1,667) 267,395 247,718 (19,6 1,437,679 1,279,573 (158,106) Trans from General Fund 230,000 230,000 - Total Transfers In 230,000 230,000 - TOTAL RESOURCES REQUIREMENTS: Expenditures Personnel Services Materials and Services Capital Outlay Contingency 2,179,673 2,076,693 (102,980) 539,562 484,543 55,019 1,311,230 1,049,996 261,234 83 - 83 243,453 - 243,453 TOTAL REQUIREMENTS 2,094,328 1,534,539 559,789 83% 63% a) 304,556 251,856 (52,700) 83% 72% 39,533 39,533 - 83% 74% a) 85,000 85,000 - 83% 79% 196,898 196,897 (1) 83% 122% b) 48,122 65,270 17,148 83% 75% 219,951 219,951 - 83% 71% a) 419,796 391,940 (27,856) 83% 47% 8,000 6,500 (1,500) 83% n/a - 4,885 4,885 83% 78% 0) 79,485 75,034 (4,451) 83% 312% 1,000 5,000 4,000 83% n/a 2,000 - (2,000) 83% 77% d) 320,874 350,374 29,500 83% 74% 1,725,215 1,692,240 (32,975) 83% 83% 275,984 275,984 - 83% 83% 275,984 275,984 - 83% 83% 2,513,193 2,535,344 22,151 Exp. 83% 75% e) 647,474 567,051 80,423 83% 67% 1,573,476 1,561,808 11,668 83% 0% 100 - 100 83% n/a 292,143 292,143 83% 61% 2,513,193 2,128,859 384,334 NET (Resources - Requirements) 85,345 542,154 456,809 - 406,485 406,485 Beginning Net Working Capital per Proposed Budget 375,704 a) Projection based on actual awarded amounts-Medicaid reimbursements increased b) Projection adjusted to actual - grant has ended, and all funds expended 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 Page 11 SOLID WASTE Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date FY 2013 Year End Budget Actual Variance FY % Coll. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ 700,513 $ 807,470 $ 106,957 100% 115% $ 700,513 $ 807,470 $ 106,957 Revenues Miscellaneous 18,333 15,415 (2,918) 83% 70% 22,000 22,000 - Franchise 3% Fees 166,667 203,851 37,184 83% 102% a) 200,000 203,851 3,851 Commercial Disp. Fees 716,667 794,117 77,450 83% 92% 860,000 940,000 80,000 Private Disposal Fees 1,095,000 1,092,007 (2,993) 83% 83% 1,314,000 1,290,000 (24,000) Franchise Disposal Fees 3,333,333 3,307,058 (26,275) 83% 83% 4,000,000 4,035,000 35,000 Yard Debris 60,833 83,009 22,176 83% 114% b) 73,000 85,000 12,000 Special Waste 20,833 68,634 47,801 83% 275% c) 25,000 70,000 45,000 Interest 6,250 6,725 475 83% 90% 7,500 8,000 500 Leases 9,000 9,001 1 83% 83% 10,801 10,801 - Donations - 1,680 1,680 83% n/a - 1,680 1,680 Sale of Assets - 1,451 1,451 83% n/a - 1,451 1,451 Recyclables 37,500 35,911 (1,589) 83% 80% 45,000 42,000 3,000) Total Revenues 5,464,416 5,618,859 154,442 83% 86% 6,557,301 6,709,783 152,482 TOTAL RESOURCES 6,164,929 6,426,329 261,400 83% 89% 7,257,814 7,517,254 259,440 REQUIREMENTS EXa- °i° Expenditures Personnel Services 1,444,434 1,381,825 62,609 83% 80% 1,733,321 1,707,324 25,997 Materials and Services 2,491,094 2,109,834 381,260 83% 71% d) 2,989,313 3,050,954 (61,641) Debt Service 788,928 405,589 383,339 83% 43% e) 946,713 946,713 - Capital Outlay 69,167 74,310 (5,143) 83% 90% 83,000 80,336 2,664 Transfers Out Road 230,227 207,204 23,023 83% 75% 276,272 276,272 - Capital Reserve 525,000 630,000 (105,000) 83% 100% f) 630,000 630,000 - Contingency 499,329 - 499,329 83% n/a 599,195 599,195 TOTAL REQUIREMENTS 6,048,179 4,808,762 1,239,417 83% 66% 7,257,814 6,691,599 566,215 NET (Resources - Requirements) 116,750 1,617,567 1,500,817 - 825,655 825,655 Beginning Net Working Capital per Proposed Budget 825,655 a) Due April 15, 2013--All payments have been received 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 Ten Months Ended April 30, 2013 Year to Date Year End Budget Actual Variance % of FY % Coil. Budget Projection Variance RESOURCES: Beginning Net Working Capital $2,000,000 $2,240,791 $240,791 100% 112% $2,000,000 $2,240,791 $240,791 Revenues Inter-fund Charges: General Liability 218,611 218,611 0 83% 83% 262,333 262,333 - Property Damage 261,233 261,233 0 83% 83% 313,480 313,480 - Vehicle 144,696 144,696 (0) 83% 83% 173,635 173,635 - Workers' Compensation 1,200,147 1,200,147 0 83% 83% 1,440,176 1,440,176 - Unemployment 208,333 208,461 127 83% 83% 250,000 250,000 - Claims Reimb-Workers' Compensation 417 - (417) 83% 0% 500 500 - Claims Reimb-Gen Liab/Property 50,000 32,207 (17,793) 83% 54% 60,000 60,000 - Process Fee-Events/Parades 1,667 705 (962) 83% 35% 2,000 2,000 - Miscellaneous 42 37 (5) 83% 74% 50 50 - Skid Car Training 13,333 20,540 7,207 83% 128% 16,000 22,000 6,000 NSF Fee - 30 30 83% n/a - 60 60 Interest on Investments 12,500 9,984 (2,516) 83% 67% 15,000 12,000 (3,000) Other interest 42 - 42 83% 0% 50 50 - TOTAL REVENUES 2,111,020 _ 2,096,650 (14,370) 83% 83% 2,533,224 2,536,284 3,060 TOTAL RESOURCES 4,111,020 4,337,441 226,421 83% 96% 4,533,224 4,777,075 243,851 Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY 5201 Settlement / Benefit 372,053 5202 Defense 43,971 5203 Professional Service 59,896 5204 Insurance 148,035 a) 5205 Loss Prevention 8,744 5206 Miscellaneous 45 5207 Repair / Replacement 200 Total General Liability 250,000 632,943 (382,943) 83% 211% 300,000 700,000 (400,000) PROPERTY DAMAGE 5204 Insurance 159,171 a) 5207 Repair / Replacement 48,753 Total Property Damage 208,333 207,924 410 83% 83% 250,000 230,000 20,000 VEHICLE 5203 Professional Service - 5204 Insurance 366 5205 Loss Prevention 15,416 5207 Repair! Replacement 42,056 Total Vehicle 83,333 57,838 25,496 83% 58% 100,000 70,000 30,000 WORKERS' COMPENSATION 5201 Settlement / Benefit 293,259 5203 Professional Service - 5204 Insurance 131,788 a) 5205 Loss Prevention 33,420 5206 Miscellaneous 33,170 Total Workers' Compensation 833,333 491,638 341,696 83% 49% 1,000,000 550,000 450,000 5201 UNEMPLOYMENT - Settlement/Benefits 208,333 116,017 92,311 83% 46% 250,000 230,000 20,000 Total Direct Insurance Costs 1,583,333 1,506,359 76,975 83% 79% 1,900,000 1,780,000 120,000 Insurance Administration: Personnel Services 256,580 252,795 3,785 83% 82% 307,896 307,896 - Materials & Service 140,825 101,854 38,971 83% 60% 168,990 168,990 - Capital Outlay 83 - 83 83% 0% 100 - 100 Total Insurance Administration 397,488 354,650 42,839 83% 74% 476,986 476,886 100 Transfers Out 6,000 5,400 600 83% 75% 7,200 7,200 - TOTAL REQUIREMENTS 1,986,822 1 .866,408 120,413 83% 78% 2,384,186 2,264,086 120,100 NET 2,124,198 2,471,032 346,834 2149,038 2,512 989 363,951 Beginning Net Working Capital per Proposed Budget 2,517 479 a) Annual premium paid in July 2012 Page 13 * Contingency is $2,149,038 DESCHUTES COUNTY 911 Statement of Financial Operating Data Ten Months Ended April 30, 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 5,456,406 6,042,775 586,369 83% 92% a) 6,547,687 6,256,420 (291,267) Property Taxes - Prior 154,167 290,752 136,585 83% 157% 185,000 290,752 105,752 Federal Grants 200,000 - (200,000) 83% 0% b) 240,000 240,000 - State Reimbursement 30,000 24,674 (5,326) 83% 69% c) 36,000 36,000 - Telephone User Tax 625,000 383,681 (241,319) 83% 51% 750,000 767,242 17,242 Data Network Reimb. 25,000 31,856 6,856 83% 106% d) 30,000 43,804 13,804 Jefferson County 25,000 29,210 4,210 83% 97% 30,000 31,262 1,262 User Fee 36,667 4,313 (32,354) 83% 10% e) 44,000 44,000 - Police RMS User Fees 232,458 212,647 (19,811) 83% 76% f) 278,950 252,000 (26,950) Contract Payments 25,833 1,988 (23,845) 83% 6% g) 31,000 1,988 (29,012) Miscellaneous 7,500 8,683 1,183 83% 96% 9,000 9,000 - Claims Reimbursement - 46,760 46,760 83% n/a h) - 46,760 46,760 Interest 33,333 44,619 11,286 83% 112% 40,000 50,000 10,000 Interest on Unsegregated Tax 500 522 22 83% 87% 600 600 - Total Revenues 6,851,864 7,122,480 270,616 83% 87% 8,222,237 8,069,828 (152,409) TOTAL RESOURCES 14,851,864 16,005,566 1,153,702 83% 99% 16,222,237 16,952,914 730,677 REQUIREMENTS: % Exp. Expenditures Personnel Services 3,617,075 3,267,811 349,264 83% 75% 4,340,490 4,000,000 340,490 Materials and Services 1,708,502 1,443,631 264,871 83% 70% 2,050,202 2,050,202 - Capital Outlay 468,333 71,814 396,519 83% 13% 562,000 562,000 - Transfers Out-Reserve Fund 416,667 500,000 (83,333) 83% 100% i) 500,000 500,000 - Contingency 7,307,954 - 7,307,954 83% n/a 8,769,545 - 8,769,545 TOTAL REQUIREMENTS 13,518,531 5,283,257 8,235,274 83% 33% 16,222,237 7,112,202 9,110,035 NET (Resources - Requirements) 1,333,333 10,722,309 9,388,976 - 9,840,712 9,840,712 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) Mar/Apr 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 8, 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 Ten Months Ended April 30, 2013 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I 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 Budget Pro'ectinn Variance $13,800,000 $ 14,551,028 $ 751,028 100% 105% $ 13,800,000 $14,551,028 751,028 10,662,500 10,728,980 66,480 83% 84% 12,795,000 12,871,238 76,238 41,667 26,069 (15,598) 83% 52% 50,000 31,000 (19,000) 525,000 539,113 14,113 83% 86% 630,000 645,000 15,000 1,083,333 1,174,827 91,494 83% 90% 1,300,000 1,410,000 110,000 625,000 771,094 146,094 83% 103% 750,000 925,000 175,000 - 716 716 83% n/a - 716 716 - 66,836 66,836 83% n/a - 66,836 66,836 - 50,493 50,493 83% n/a 50,493 50,493 - 371 371 83% n/a - 371 371 66,667 60,690 5,977 83% 76% 80,000 71,000 9,000 13,004,167 13,419,189 415,022 83% 86% 15,605,000 16,071,655 466,655 TOTAL RESOURCES 26,804,167 27,970,216 1,166,050 REQUIREMENTS Expenditures: Personnel Services (all depts) 167,310 170,055 (2,745) Materials & Services Claims Paid-Medical 8,358,500 9,947,050 (1,588,550) Claims Paid-Prescription 1,603,000 886,105 716,895 Claims Paid-Dental/Vision 1,488,500 1,522,273 (33,773) Claims Refunds - (116,427) 116,427 Insurance Premiums 291,667 280,559 11,108 State Assessments 133,333 194,510 (61,177) Administration Fee 266,667 278,074 (11,408) Preferred Provider Fee 41,667 42,325 (658) Health Impact 45,833 43,495 2,339 Refund - ERRP - 58,552 (58,552) Other - Administration 54,461 37,751 16,709 Other - Wellness 87,500 27,780 59,720 Admin & Wellness 12,371,128 13,202,046 (830,919) Deschutes On-site Clinic Contracted Services 570,000 682,887 (112,887) Medical Supplies 25,000 24,101 899 Equipment 833 2,170 (1,337) Other 17,861 35,399 (17,5381 Total DOC 613,694 744,556 (130,862) Deschutes On-site Pharmacy Contracted Services 256,906 290,779 (33,874) Medication and Drugs 833,333 1,167,307 (333,974) Start Up Costs-Take Care - 59,898 59,898 Other 13,799 14,840 (1,041) Total Pharmacy 1,104,038 1,532,825 (428,786) Contingency 10,247,897 - 10,247,997 TOTAL EXPEND/REQUIREMNTS 23,400,128 15,649,482 8,854,685 NET (Resources - Requirements) 3,404,038 12,320,735 10,020,735 Net Workine Capital per FY 2014 92% 104% Exp. 83% 85% 83% 99% a) 83% 46% a) 83% 85% a) 83% n/a 83% 80% 83% 122% 83% 87% 83% 85% 83% 79% 83% n/a b) 83% 58% 83% 26% 83% 89% 83% 100% c) 83% 80% 83% 217% 83% 165% 83% 101% 29,405,000 200,772 10,030,200 1,923,600 1,786,200 350,000 160,000 320,000 50,000 55,000 65,353 105,000 14,845,353 684,000 30,000 1,000 21,433 736,433 30,622,682 200,772 12,156,193 1,058,245 1,787,124 (116,427) 350,000 194,510 333,674 50,785 52,175 58,552 65,353 70,000 16,060,184 786,719 30,000 2,170 36,000 854,889 1,217,682 (2,125,993) 865,355 (924) 116,427 (34,510) (13,674) (785) 2,826 (58,552) 35,000 (1,214,831) (102,719) (1,170) (14,567) (118,456) 83% 94% c) 308,287 343,325 (35,038) 83% 117% c) 1,000,000 1,500,000 (500,000) 83% n/a c) - 59,898 (59,898) 83% n/a 16,559 30,000 13,441 83% nia 1,324,846 1,933,223 (608,377) 83% n/a 12,297,596 - 12,297,596 83% 53% 29,405,000 19,049,068 10,355,932 - 11,573,61S 11,573,615 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 - March actual paid in May and April accrual based on March actual 84.37% Page 15 Deschutes County - Fair and Expo Center YTD-Budget Basis Commissioners Statement of Financial Operating Data Ten Months Ended April 30, 2013 Year to Date Year End Budget (10/12 FY 2013 of annual) Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 46,373 $ 35,055 $ (11,318) 100% 76% $ 46,373 $ 35,055 $ (11,318) Receipts: Special Events Revenues 506,315 300,307 (206,008) 83% 49% 607,578 404,307 (203,271) Interest 1,250 (109) (1,359) 83% -7% 1,500 141 (1,359) Storage 47,868 35,283 (12,585) 83% 61% 57,441 35,283 (22,158) Camping at F & E 5,000 7,100 2,100 83% 118% 6,000 10,100 4,100 Horse Stall Rental 25,000 21,445 (3,556) 83% 71% 30,000 39,445 9,445 Concession % - Food 158,333 126,230 (32,104) 83% 66% 190,000 159,230 (30,770) Rights (Signage, etc.) 79,167 35,338 (43,829) 83% 37% 95,000 91,338 (3,662) Interfund Contract 16,667 47,000 30,333 83% 235% 20,000 45,000 25,000 Miscellaneous 5,667 2,598 (3,069 83% n/a 6,800 5,298 1,502 Total Receipts 845,266 575,192 (270,075) 83% 57% 1,014,319 790,142 (224,177) Transfers In General Fund (001) 141,667 258,333 - 83% 152% a) 170,000 320,000 150,000 Room Tax (160) 21,453 21,450 - 83% 83% 25,744 25,744 - Welcome Center (170) 69,000 69,000 - 83% 83% 82,800 82,800 - Reserve Fund (617) - 50,000 50,000 83% n/a - 50,000 50,000 Annual County Fair (619) 220,216 245,000 24,784 83% 93% 264,259 245,000 19,259 Total Transfers In 452,336 643,783 74,784 542,803 723,544 180,741 TOTAL RESOURCES 1,343,975 1,254,030 (89,945) 83% 78% 1,603,495 1,548,740 (54,755) REQUIREMENTS: Exp. Expenditures: Personnel Services 693,235 686,312 6,923 83% 83% 831,882 825,014 6,868 Materials and Services 421,853 443,481 (21,629) 83% 88% 506,223 549,089 (42,866) Debt Service 95,099 70,609 24,491 83% 62% 114,119 114,119 - Capital Outlay 11,883 9,000 2,883 83% 63% 14,259 9,000 5,259 Total Expenditures 1,222,069 1,209,401 12,668 1,466,483 1,497,223 (30,740) Contingency 114,177 - 114,177 83% n/a 137,012 - 137,012 TOTAL REQUIREMENTS 1,336,246 1,209,401 126,844 83% 75% 1,603,495 1,497,223 106,272 NET (Resources - Requirements) 7,729 44,628 36,899 - 51,517 51,517 Beginning Net Working Capital per Proposed Budget 48,827 a) $100,000 budgeted as Trans fer GF to Reserve fund will instead be transferred to Operating Fun d and an additional $50,000 will be transferred from the General Fund Page 16 H U W O a a a Ae~ H a U U 0 xi 0 z U U v Cd a V] a~ v i CY) M C rO CO M C ~ ~ o U-L) Q a~ ~ m D ❑ U o t d Z N N 4( d d d M O O C? 4] d (h M CO C? C" 7 O r 0 0-'r 117 d d w O O N I, r d r CD d d d r- I- O O d d r C? C) C7 CD 04 Cn Co CO U7 U7 C7 U7 0 co CV Q cV C) Q N r I,- r N N L ~ IT C7 d M M r 117 r M d Or7Odd0 OOCOOO 0 MOM p r O O'Rt M C 0 Cn d d U7 T Co T O Ca C) C) I,- I,- d d r 0 CD - d d d O N ko C? M 0- U7 M Ln O U) C6 N O N N r ti r N C) C) r- ~ M LO Irr M C7 r 117 r C"] M O O co 41 0 CD r r M U7 C'7 CO M T C7 d 0) CD co m U'7 N m r CO tt 0 C? N M ti' N CD I- dr C? N N d T L6 V N N C) N C ~ r r C? O C) T N r r C> CO L6 N a a 0 C) U7 N C7 d d co 0) U) co r r M U7 C N O N ' Ci M ti ' N 0) tt It N U7 0 Cfl CO) U] CA N Q 417 r r h CD CD r N to O C. ~ ro ~ r r ~ O C C r C LL LL U as C O W Z CD 0 3 V 0 8 W H ~'~a ~ ~N NIA O= c G O c ro itm -j M co C) Col) C5 N N O O It It N rn d1 E V L of L) w -0 L) (D cm U) w C co CD C ❑ =3 ro (D CD 'Ch O CD LL L ad O 4 iy c 0 C uj A2 0: 05 N j" CD E N m C 3 cn 75 © 10 m o co a U) R O m X WZ .ro 16- L p C3) ; C O O ,~VcC 0 - w sLL~ H -1 W ¢ U Ch m r N U7 m r Cn w ~ r O N ICS U7 co C6 Off C7 U77 % iw i IDIJw r a 0 Ici N ' lcwol r T f/J 7 C C d (D rn CL c X W o m U p H 0 C71 cf) r Ch ti ID 0 M Ch ti ti C ti T T" w W) 0 0 0 U7 N T r 1!f a) Z Ch r O N Cl It r ti7 N C71 ~ -0 r -0 O N C LL T O a o ro if LL ch Cn (D C: N O LL D LL U "O ❑ N c n 'd ro d CT o C m O. c oV CU ro a>i C ❑ c 0 CL C~ c 'a E O 7 a L U 7 Ln D O O N d L V- Cn N } L r r LL d O N O d LL _ N C ro > - C] LL C CIO U U V1 ro a) o -C ` O An U) ID 3 a H 6q co 'S cr) ~ O N COQ C LL U•~Q Cn L U q) L O L U) N wL+ ❑ N O N C1 U1 C w 1 MIM O CO O r r O N 0 CD OD Ca CDOMCA C) co C) w 0 qT (D Lf) r O co 0 CD O D O CD N CN ' C) OD (D LO ~ ~ CtY O O CD O r lti 0 N O CD CD U CU O to (D ce) Q! CU fa 0 Co O co d 0 NT 0 w d i I i i I O CD O r I,- C> CN 000070 ocoOM0 o Oo 0 ao O go r r r M m V c ~ r Y c N ~ 3 LL L .O ~ U) V) G1 Z C C ` LL CU lU L- R~~ U,~~o is I y -0 LU CL y N +d CU o It LL of 0 M N LO 0 ~ O ' LO In N ~ C M ~ C 7 s 0 0 0 0 0 0 0 M O M O O N O O N W Q 0 O 0 M C`7 M 0CDC)0Il- OO OO It ~ ~ D Ln Ln N r p N O r N D C CO LO L r LO LO Q O 0 C) - coOO 0 N O r - (o 0 0 ' ti O C ' O .rt V N N Oo LO LO O N r C/) LO LO N r C7 LO LO 0) 00)0)0) m CD LO 0 0 ~ N ~ ti ti ~ ' O ~ LO ' CD CD r N r Ln r N N LO N 00 O LO L 0 0 N N O L O LO O It m D N C CD N 0 ~r ' r 0 Itt Ln ' O r-- (6 r C NI LO t- r r V) N CO LO LCD O O O UU 0 N U R C 0 c atf Q>'N NV) o_° U 00 Lu 0 U) U) 'r- of 'b 0) E 0 0 CL CO 0) (D ~ D1 ~ -O CU C C oV c c a~i v; m a 5 O 3 z - X ro¢LLIaCn E LL CoZ W U ' cq II- CF M L!f ' r r 4: o w V Cp O r w co ' N N r r~ Ln to LO M ' r cc M qr e^ U ~ C C Co k rn w U H 41 z N 'O C 7 LL c 7 LL N U O Q CL 7ti C D 4 'C3 U a) 6 m C N O E C O 4-- A C7 0 O U 7+ O O C y Cll L ro L 3 ~ N Q). mN Q O m LL +J ~ C C r~r U m y 0 N c o 0 U- M 0 C- c~ C a z ~ v ¢ m N Deschutes County Bethlehem Inn (Fund 128) Ten Months Ended April 30, 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 Budget Actual Variance FY % Coll. % I Budget I Projection Variance J $(2,710,000) $(2,710,173) $ (173) 100% 100% $(2,710,000) $(2,710,173) $ (173) 83,827 - (83,827) 83% 20,340 22,374 2,034 83% 104,167 22,374 (81,793) 83% 0% 100,592 - (100,592) 92% 24,408 24,408 - 18%' 125,000 24,408 (100,592) 1,375,000 - (1,375,000) 83% 0% 1,650,000 - (1,650,000) 883,333 - (883,333) 83% 0% 1,060,000 - (1,060,000 (347,500) (2,687,799) (2,340,299) 83% -2150% 125,000 (2,685,765) (100,765) Exp. 20,833 12,296 8,537 83% 83,333 - 83,333 83% 104,167 12,296 91,871 83% 49% = 25,000 15,000 10,000 0% > 100,000 - 100,000 10% 125,000 15,000 100,000 - (2,700,765) (765) NET (Resources - Requirements) 451,667 2,700,095 2,248,428 a) Interest on April 2013 negative cash balance: $1,200.21. b) Inception through April 30, 2013 Revenues - Lease Payments $ 71,190 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 253,372 Total expended 2,771,285 ) Net $(2,700,095 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Travel Expenditures and BOCC - County College Expenditures FY 2013 I BOCC Conference & Travel Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr YTD Total Tammy Bane Conf/Sem & EducJTramm _9 30 - f rt 5 82 80 25 810 Travel Meals 20 66 - 240 - 40 8 Accommodations 1 119 ! I 1 715 5 1, 1,961 1 Airfare ' I I 632 ' 632 ~ Mileage reimbursement bursement 84 3 - I 683 790 ~ - - 557 ~ - 432 23 2 262 3,340 GroundTra_ns 9 - ort/Parkin ~ - 5 _ ~ - - _ 142 177 ~ _ _ Total Bane 30 566 ' - 790 878 - 704 + 512 1 3,686 586 262 7,327 Alan Unger ConflSem & Educ/Training 65 - - 305 - - 65 80 75 65 655 Travel Meals - - - - - - ! - - - Accommodations - . 429 - 429 Airfare Mileage reimbursement 112 - - - - - - - - 112 Ground Transport/Parking - - Total Unyer 65 112 - 734 - - 85 80r 75 65 1,195 Tong DeBone . - - - _ ~ Conf/Sem & EduclTrarnrng _ 30 15 470 10 5 80 1 00 ~ - -1.240 Travel Meals - - i 76~ - - 76 _ Accommodations - - 429 - 7 339 - -_768 Airfare . Milea a reimbursement g - - 71 L 562 - 399 - 405 - 1,836 Ground Transport - - - - 19 - - - - 19 Total DeBone 30 15 1,369 10 657 35 1,$18 505 - 3,939, Other - Education/Conference - - 375 315 Total - BOCC Department _ Conf/Sem & Educ/Trainmg 125 15 20 165 740 1,115 65 3,020 - - Travel Meals - 2 6 6 82 - 240 484 - Accommodations - - 27 - - 57 119 4- - 39 1, 715 - - 3.157 Airfare - - ~ - 632 - 632 - ~ Mileage Reimbursement - 496 - 0 1,260 683 ! 569 55 57 _ t 831 831 _ 637 262 ' 5,288 Ground Transport rt - 35 - _ - _ 42 - 196 Total - BOCC Department 125 678 15 2,893 888 657 804 ; 1,910 1 4,480 327 , 12,777 FY 2013 Budget 15,250 Percent of FY 2013 Budget Expended 83.8% - - BOCC County College _ Offce/CoSuer upplies 85 - 85 P - - 761 811 ' 869 T _ Meetin 9 Pp - - 2,441 811.889 ~ Total BOCC County Colle e 2,526 ures a m~ NOTE: Above amounts include only those expenditures processed for P. y ea + Additional conference and travel costs may have been incurred, but not processed for payment. 5/8/2013 J I 1 w - 5 Nz-. _1 Go~'C 1 Cl r M I 5 141 I I Imo- I 1... 7~7 U) F~I - j4 ~ r rrhh w i 8 (7 J U) r- 0 0 5 c~ _ .y r J t , ny. , i _ I , 1 n to - 1 i _ CI z 5,. Y m I O I Lrt~ , L ~ I I I ~ IL - r_ - lr F G _ - LI ~ ! j .1_~'.... r ( l v I d1; , _ i . f t. • I I ~F O +1 ~j s r.' al f v yam? \ k 'V~ , a., r ~ - - 721 ~I v = Ll ML l + - 0D