Loading...
2010-2779-Minutes for Meeting July 26,2010 Recorded 8/10/2010COUNTY NANCYUBLANKENSHIP,F000NTY CLERKDS COMMISSIONERS' JOURNAL 08110/2010 11.20.31 AM II 111111111111111111111111 II III 2 30-2779 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, JULY 269 2010 Present were Commissioners Dennis R. Luke, Alan Unger and Tammy Baney. Also present were Dave Kanner, County Administrator; and, for portions of the meeting, Cynthia Smidt, Community Development; Mark Pilliod, Chris Bell and Laurie Craghead, County Counsel; Marty Wynne, Finance; Debbie Legg, Personnel; media representative Erin Golden of The Bulletin, and one other citizen. Chair Luke opened the meeting at 1:30 p.m. Commissioner Luke stated that this is a discussion that continues from the recent joint meeting of the Board and the City of Sisters Council. Brad Bailey of High Country Disposal asked to address the Board regarding the planned recycling center outside Sisters. The center will be open seven days a week during normal working hours. The area will need to be secured because there is no one there to monitor activity in the evenings, and the City of Sisters will provide some staffing at the site. Service is not mandatory at this time. The area around Sisters will have a new boundary, and rates will be increasing slightly, effective August 1. 1. Consideration of Signature of Document No. 2010-510, Approving a Conditional Use Permit for a Room and Board Arrangement (Applicant: Anderson). Cynthia Smidt and Laurie Craghead came before the Board. Ms. Smidt said that this is the last day for signature of the appropriate document. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 1 of 4 Pages Commissioner Unger stated that the document says the stay has to be thirty days or longer. He pointed out that it appears the room has to be set aside for that period of time even if the guests leave early. Commissioner Luke asked Marty Wynne if there needs to be a room tax collected. Mr. Wynne stated that there is a tax charged for under thirty days. Commissioner Unger stated that since there is no bed and breakfast provision, this is the best there is at this time until it is addressed otherwise. Ms. Smidt said that there would need to be an applicant-initiated or County- initiated text amendment to clarify this issue. UNGER: Move approval of Document No. 2010-510. BANEY: Second. VOTE: UNGER: Yes. BANEY: Yes. LUKE: Chair votes yes. 2. Finance Update. Marty Wynne gave a brief overview of current finances and the investment report. CD rates are down to 0.08. Bankers' acceptance notes are issued by banks on behalf of corporations and are more competitive, and commercial paper is up. The average investment is 1.26. Departments have been asked to project out to 0.7. Maturity for investments occurs beyond the end of the next fiscal year. Even though loan rates are low, it does not make a difference if no one can qualify for a loan. Housing values continue to fall. Mr. Wynne distributed the preliminary beginning net working capital for the fiscal year. Some funds are down because revenue in the form of grants has not yet been received. The general fund is significantly higher. A sheet comparing May to current shows projections was reviewed. Several categories came in higher than anticipated. Regarding the landfill area closure and cell construction, there were some change orders required. There were additional change orders when it was decided that the size of the Oregon State Police/9-1-1 building was increased. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 2 of 4 Pages 3. County College Update. Mr. Kanner stated this is modeled on the Citizens Academy that the Sheriff's Office hosts. The first meeting is September 14 and it would be good if the Commissioners could attend at that time. One class will be held on election night and attendees will be able to see the election process. He shared the schedule with the Board, which will take place on Tuesday evenings. He wants the department directors to be involved in interactive activities. 4. Other Items. UNGER: Move approval of the Consent Agenda. LUKE: Second. VOTE: UNGER: Yes. BANEY: Yes. LUKE: Chair votes yes. Consent Aizenda Items 6. Signature of Order No. 2010-041, Declaring Certain County Personal Property Surplus and Authorizing Its Sale 7. Signature of a Letter Appointing Michael Waggoner to the Newberry Estates Special Road District Board, through December 31, 2011 8. Approval of Minutes: Business Meeting of July 19 Work Session of July 19 Mr. Kanner asked about scheduling a joint hearing with the Planning Commission on text amendment regarding La Pine. Commissioner Luke said he was waiting to see what the City of La Pine wants to do. The Commissioners do not want to cause any delays. Discussion occurred regarding scheduling as two of the Commissioners will be out of the office part of August. Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 3 of 4 Pages Commissioner Baney stated that the U.S. Forest Service welcome center is now back on track. It is hoped that the project will be able to use local contractors. Commissioner Unger gave an overview of his recent trip to Washington D.C. in search of grant funding for landscape management issues. The U.S. Forest Service lead staff person will be the head person in this area later in the year. Collaborative partners need to get together and communicate their support of the process. 9. Executive Session, called under ORS 192.660(2)(d), labor negotiations. The Board went into executive session at 2: 35 p.m.; which ended at 2:50 p.m. Being no further items addressed, the meeting adjourned at 3:10 p. m. APPROVED this% Day of Deschutes County Board of Commissioners. 2010 for the R. Luke, Chair ATTEST: Recording Secretary ro.C.. Gc/t,~,- Alan Unger, Vice Chair Lw~~~ Tammy Baney, Com sioner Minutes of Board of Commissioners' Work Session Monday, July 26, 2010 Page 4 of 4 Pages Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.orc WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, JULY 26, 2010 1. Consideration of Signature of Document No. 2010-510, Approving a Conditional Use Permit for a Room and Board Arrangement (Applicant: Anderson) - Cynthia Smidt, Community Development 2. Finance Update - Marty Wynne 3. County College Update - Dave Kanner 4. Other Items Consent Agenda 6. Signature of Order No. 2010-041, Declaring Certain County Personal Property Surplus and Authorizing Its Sale 7. Signature of a Letter Appointing Michael Waggoner to the Newberry Estates Special Road District Board, through December 31, 2011 8. Approval of Minutes: • Business Meeting of July 19 • Work Session of July 19 9. Executive Session, called under ORS 192.660(2)(d), labor negotiations 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), pending or threatened litigation; 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. If 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 July 26, 2010 (1) Monthly Investment Report (2) June 2010 Preliminary Financials co ~ r ~ r N lA oc Ln O r O O m 00 r to r O O N W~ r L M A W N C> O CD O "T to > > LL c ' 00 N O C O 't In to r O O to ~ C r r 3 7 Efl ER w to t o O O E E _ C O t D C) o C ° c Y c0 6,9, ar' E Z O V > to C C E O U U to c E o Y Y m N d Qj a7 r c ~ ~ E d E - 4) E ~ a~+ ; 0 JC U) > (D C ~6 Y C F- a> C~ 0 o o o \ o o co M o 1- o ty 0 O O N O O O N O O a) co O r r O 0 'r.; O N le 0 cl) V O N n 1 00 r M M t0 LO O 0p O co O N v LO O C \L i~ ( N M v rn CD r N M It N tt3 I fI► U L C N (/J Y c6 Q U) Q) d 76 'C O C 0 a) U E mZw w ~~U YvJ QQF- m E o C) -U) m c E aa) 6 E "6 C - Y UU1-~Lim~ H ~I CN N C to 21 6 a) C a) 0 0 l 0 0 0 0 0 0 0 0 000 O O r r I- N N N r E 0 E ~ C O A U a U O t6 ~ l6 ' L C U a' O m Q Q o U O m 0 L a) E CD n N Y a> tZ U UU D-j tim 1- I ~ !I N i O. C CD E Y N d C m O_ O O a 'Fa O H y m ~ ~ U o N ~ C N N M E .V m LL U m ~ a~ o °a o o Z U U O m CL v 0 J 0 0 O T O T 0 U N U_ U_ U_ U_ U_ V_ U_. U_ U_ U O' N U U U U U U U U U V U U U U U U U U U U U U O O U m c'J U ' O m M O n O M '.O x pm _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ z Z Z Z'.Z Z ZZ Z Z ZZ Z Z Z Z Z Z ZZ Z Z Z Z Z Z Z Z Z Z Z.~ Q.Z Z m z C' m °.~NOOD.c ' o ' ' O O N ,,,0.~ O Z O u O Q O O U U M n N m N 0 0 0 m O O m n o o f co N n N O N O M 0 o (o m n O. O (p n O N 0 O. m o N n N O I N P, Q M(ON Mn NOmO~-mOnm OOOmmcO :NmCNOMOOmmmO ~O mm ONOO.' mmN O ~--m' N ~ O O C 2 M m n m 7 M O n O N n O m m 0 m co O N w n V n O M o 0 m m m O O m O N O O'. n (o m m V O m (O m m m m m m n O m V m N O~ V m M m O m m' o O o. m o N o o' M O N ~ oo A. (o M M m' N n d d z 7 (O o n O N m V M (O n m N m"t m coo m m N M m m n m m' m m. 0 O n O m''. M m { (D: m M M (D > E 7 O (D O m V N m m M n m 0 o m M' N N 7 N m C O m n n N co N co m o co o C O m v. m O. m O o m NR oOM N~0OO0OOMM_OOOOV 000 OOn...000OO 0000 mN 000 0 O ~ m~m c0 'm NO r m > ; . . . N a ' ' c V N N N N N N N N N.N N N N N.. N.N N N N N N N N.N N N 0.~.N N' N N, c~~J ~ r N n m non r- m O O O O o o co o M M o m V o m (D o 0 0 m o 0 O o o O O o o o o o m 0, N j (O m M'~ n n 0 0 0 0 0 m O O M M O m V O N m O O O n 0 0 0 0 0 0 0 0 0. 0 0 0 m iN M m m N n'(O n O N 0 0 O' m m a W o N n 0 (0 m o o o n o o O' o 0 o o o o o o o m O N m > m N M: cD M m v n N N N m m o o m N V cD N M m N N N- m m w O co N O O (O O O O m m (O n O m' m (o M M n m m n m N m_ m M r -Z co m n M M m n co o q N m 6 o m v n m e c d _ O m CO.m O(Om m m MM O N N mo (D m o 7~ n co (o' Mm m a N O m ' N o'm ' M _ O O o m o O O. O O m M N.~ O, m. 0 O o N cO O M O o O m O O O n O O O n ~.O O O O O OHO ~.m O OO 0 0 0 0 0 OO 0 0 0 0 OO OO n n m m m a (0 V N C V~ N N N N N N ~ N N N N N N N N N NN N NN N N NNN mn N Of : m o o o o o o o O O m o c o o o c O O O O o, o O O M o O o o 0 O o o o n O N T H O. O (D O o Cl 0 o. O o 0 o o o O. O O' o o o o o o o o O. O O O N O o o o 0 m N N p U O O m 0 0 0 O. O O N O m m. O O O O O O. n 0 0 0 0 0 0 0 0 0 0 0 O O O' m 0 0 0 O'. O O o m o 0 0 o m O m m M O o N O O V o m y O O O co O O O cD O. O O N OO 0 0 N m -It M M co m m q O M n 0 0 0 O 'o m o O m m o O n 0 0 ' O o ~ O O O OOO a m m m q m 0 O O 0 7 m O Il co V O M m o 0 m o m It o m o' M n o m o o m o M m 0 o n m o 0 o M o n o ~ o o v'o o o m o m m C O O N N m 0 N O O m v n O O o o O. o c m. 0 o o m m m o o o m 0 0 0 V O O a o. O'. O O O O 0 0 0 0 O O o m o O m 0 0 0 0 0 0 O O-- o O o o o ~.m n (O m m M - O V N V V ~ N N N N N N N N N N ~ N N N N N N N N N N N N N N N m 1~ N r (O M T r N ' U rn C , ~ o . . _ m o U \ \ o o 0 o o 0 0 0o 0o ~o o oo o o~ \ ~ \ \ o e Z ? m Q o o o 0 0 0 o w o 0 o o 0 o m' O O O O m (D O O O O. O O O o o m o m o o 0 o o o o m o ' (Di. O N y Q N O > d o o : O V m N a O N m o m m M m M V m o m M N O O m m O m m m O m o n~ n (O O m: m m m: O V N O O N n N m m m m V x N O (D: (n: m n o n O m q m o N m m O N N L N I` U `'m c d N N' N M e- M M N O O O o c) O OO O O q q r O E Y m . : r a w F- N d m _ UUF-Dti co F- C o o o 0 0 0 0 0 o o o o o o o o o o o o o 0 0 o o o o ' Q d ' m O m m O O 0 0 0 O O O m . 0 0 0 O O. O O O m O O O O O n m n n 0 O m M O' O m m n o O m m N m O m N m O O o n . jp m N M m ~ m m m m co m I M M O' O U0 n' n m n ~ m 0 0 0 N p M. M' V V m O m. O O co (n O O (+i O e- O. m O'- r U d O C N C p y O m o E a c N O N : y C IL r ' (n C ~ Y'p w O O ~ N m NCO r, O On m m fo T m m (om O.O m n N co n n 0 nm m M,M n m mm (O m m 0 0 ~ N Q m a O V M 7 m (o m N 0 u) n m m (O m ~t V V m N a M (p N V' m V M M V n M M N m m: m m n m V M m 7 m n M m m m V M m m m m m m m v m m v m m m m (p m m (O n n' . (O C Z . c y > C O O O 0 O: 0 0'. 0 0 0 0 0 0 0 7 N~ N : j O' p m N m N Imo' r m O O V rz r m m . m (O O h m (A ~ m m m (n m1 O M m . rz ' m m . 0 0 N N a 6 N N O. 0 0 0 M~ N N O N N N O O N O O O O N O N N6 N~ ~ r r r r O O O N ` F- E f , m M ( ~ V (n m co. m n m m m: m m m m m O O O r N (n > o 0 0 00 0 0'0 0'~ o 0 0 0 000 0'0 0 0 0 0 0 0 0 0 0 0 0 Q . O o 010 . N N m m O m O m m m m m m' m o] m m m m m O m m m m m 0 0 0 0 0 0 0 0 m 0 0 0. 0. O m 0 m y O O O • O O O O O O 0 0 0 0 0 0 0 O O O O O' O ~ O - - - ' U Om : r - m O 7 ~ . (A m ti O m O O m m O O m m. M : I m LL~ O O O N N ~ N ~ ~ ~ N O ~ O N N E N N N E N O N M. B O O N N N ~ ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~2 ~ O L d 0 0 0 . 0 0 o o ' O O o O , O Q U W LL (D 00 m U SIY m M m. Z'> F- (L L Q'.(L Z Q Q J LL M N fn N a M-L)..U LL FrF ad Fl ❑ ❑ ❑ U ❑ ❑ ❑ O ❑ ❑ ❑ ❑ ❑ ❑ m' O < < m LL LL a a a a a a a . (C) F- L i t i. L U U t L L U ( L t i t i t i U Nueg m❑ m m m m m o= 3: o 3 2. 7 CL S=~ U U U 0 m U a.3 = d: (n cn (n 2' 3 rr co co co z 2 3 of U M E M m M N m O n m m m t0 m co m n n m m m Q w Z F- Co m ~ Z W a Q Y Z LL SUwY vmm N F- ❑ Z . : LL of m Q a n m m O M r m m M r M M M px0 M M N M, m M (LLp ~ o mm M N. M M m p. M M M M M M. m M M N m.. M _M M m 0 O - o m m m m M M M M M M M m M M M M O ( 1 _ . . . C 2 ❑ ~ N N Y N ❑ ~ ❑ ❑ C) C) C) c C) C) i U ou N U c m m m J N ` Y U❑ m' m m c) m m U m m m - o N U E Y [0 m Z m~ a y> in Z z U Um ~m. U y m mU m ZU E a ~ D ro Q nm m cZ . m U mN, Z. m U U d d m m U U m - U Q ma i ~ T LL i t ,y~4? m t 0 m N > C Y Y . ❑ m Y Y E U U O U U C N U C C~ m j U co E m Y ~ m E U N ❑ N T r QLLnY E p L p Y . m N m mN(n N. 'Om E mN:N d CE U Cc OE T ` Z N! N mUmp a_cEE"N a o no _ m m m m a) m m d o o m m co U=Y o m (n (n > m U U 11 F- ~a~ n w m m c m 5 m w m U m m > U 0 O m . Z W d Q) IT n Qmmm~mco mm<m< Y Y Y Y Y m m m N m T N m c m E L Y c a 0 a J E J J C U J >U (n c=u C: C m c E N O O LL C S m E m m ma S oSS mLL ESE o o m E -j -j tU S S S L lU O LL S Z L Z a'. . L , l i L > m D m m co J. co - u- S LL LL 0 LL D LL D S> U C7 LL '(5 1 LL V> ~.LL LL LL '.LL LL LL F LL LL LL LL LL W J m co ' Memorandum Date: July 20, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find June 2010 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) and Health Benefits Trust (675). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 Year to Date Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 6,050,000 $ 6,775,995 $ 725,995 100% 112% Revenues Property Taxes 19,822,847 21,289,179 1,466,332 100% 107% Gen. Rev. - excl. Taxes 2,921,462 3,150,964 229,502 100% 108% Assessor 820,704 847,684 26,980 100% 103% County Clerk 1,043,171 1,599,757 556,586 100% 153% BOPTA 13,791 14,432 641 100% 105% District Attorney 332,800 332,606 (194) 100% 100% Finance/Tax 187,049 194,914 7,865 100% 104% Veterans 70,192 70,154 (38) 100% 100% Property Management 86,450 98,370 11,920 100% 114% Grant Projects 2,000 2,000 - 100% 100% Total Revenues 25,300,466 27,600,061 2,299,595 100% 109% TOTAL RESOURCES 31,350,466 34,376,056 3,025,590 100% 110% REQUIREMENTS: Exp, Expenditures Assessor 3,290,631 3,082,496 208,135 100% 94% County Clerk 1,460,704 1,301,868 158,836 100% 89% BOPTA 60,358 59,883 475 100% 99% District Attorney 4,622,263 4,580,458 41,805 100% 99% Finance/Tax 755,971 747,699 8,272 100% 99% Veterans 234,222 234,030 192 100% 100% Property Management 239,685 238,431 1,254 100% 99% Grant Projects 105,673 103,728 1,945 100% 98% Non-Departmental 1,613,006 1,423,351 189,655 100% 88% Contingency 5,515,042 - 5,515,042 100% 0% 17,897,555 11,771,944 6,125,611 100% 66% Transfers Out 13,046,911 12,960,911 86,000 100% 99% TOTAL REQUIREMENTS 30,944,466 24,732,855 6,211,611 100% 80% NET (Resources - Requirements) 406,000 9,643,201 9,237,201 Beginning NWC per Adopted Budget 8,300,000 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $1,085,000 $1,200,041 $ 115,041 100% 111% Revenues Federal Grants 31,775 53,491 21,716 100% 168% SB #1065-Court Assess. 60,000 56,535 (3,465) 100% 94% Discovery Fee 16,000 15,989 (11) 100% 100% Food Subsidy 30,000 26,251 (3,749) 100% 88% OYA Basic & Diversion 332,450 225,712 (106,738) 100% 68% Inmate/Prisoner Housing 60,000 107,507 47,507 100% 179% Inmate Commissary Fees 800 279 (521) 100% 35% Contract Payments 208,141 98,551 (109,590) 100% 47% Miscellaneous 300 153 (147) 100% 51% MIP Diversion Fees 1,000 400 (600) 100% 40% Interest on Investments 13,000 15,779 2,779 100% 121% Leases 2,448 2,500 52 100% 102% Grants - Private - 1,721 1,721 100% n/a Health & Human Svcs Chg - 1,660 1,660 100% n/a CCF Interfund Grant 68,000 46,272 (21,728) 100% 68% Crime Prv Svcs Interfnd Grnt 20,000 20,000 - 100% 100% Total Revenues 843,914 672,798 (171,116) 100% 80% Transfers In-General Fund 5,543,186 5,543,186 - 100% 100% TOTAL RESOURCES 7,472,100 7,416,025 (56,075) 100% 99% REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Capital Outlay Contingency Exp. 2,830,152 2,847,680 (17,528) 100% 101% 1,322,097 1,116,945 205,152 100% 84% 100 - 100 100% 0% 2,532,154 2,301,600 230,554 100% 91% 184,903 181,695 3,208 100% 98% 100 - 100 100% 0% 602,594 - 602,594 100% n/a TOTAL REQUIREMENTS 7,472,100 6,447,920 1,024,180 100% 86% NET (Resources - Requirements) - 968,105 968,105 Beginning NWC per Adopted Budget 987,000 SHERIFF - Fund 255 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ - $ 183,677 $ 183,677 100% nla Revenues Law Enf Dist Countywide 20,242,936 16,777,094 (3,465,842) 100% 83% Law Enf Dist Rural 12,717,322 10,919,465 (1,797,857) 100% 86% Interest - 24,013 24,013 100% n/a Total Revenues 32,960,258 27,720,571 (5,239,687) 100% 84% TOTAL RESOURCES 32,960,258 27,904,248 (5,056,010) 100% 85% REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Sheriffs Division 2,190,388 2,131,685 58,703 100% 97% Civil 746,874 724,992 21,882 100% 97% Automotive/Communications 1,397,884 1,353,489 44,395 100% 97% Investigations/Evidence 1,697,327 1,522,296 175,031 100% 90% Patrol/Civil/Comm Supp 7,585,967 7,257,604 328,363 100% 96% Records 642,363 594,992 47,371 100% 93% Adult Jail 9,154,909 8,493,844 661,065 100% 93% Court Security 215,908 196,026 19,882 100% 91% Emergency Services 192,071 182,209 9,862 100% 95% Special Services Division 1,193,690 1,105,660 88,030 100% 93% Regional Work Center 2,737,842 2,372,843 364,999 100% 87% Training Division 465,053 419,548 45,505 100% 90% Other Law Enforcement Svcs 587,702 548,650 39,052 100% 93% Non-Departmental 463,044 463,044 - 100% 100% Contingency 3,199,236 - 3,199,236 100% n/a Transfers Out 490,000 490,000 - 100% 100% TOTAL REQUIREMENTS 32,960,258 27,856,883 5,103,375 100% 85% NET (Resources - Requirements) - 47,365 47,365 Beginning NWC per Adopted Budget - SHERIFF 701 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 2,470,519 $ 3,343,461 $ 872,942 100% n/a Revenues Tax Revenues - Current 14,819,703 15,331,889 512,186 100% 103% Tax Revenues - Prior 500,000 837,220 337,220 100% 167% Federal Grants 35,000 122,411 87,411 100% 350% State Grant 45,156 71,283 26,127 100% 158% Transp. of State Wards 5,000 6,102 1,102 100% 122% SB 1145 1,721,192 1,974,660 253,468 100% 115% Des. Cty Video Lottery Grant 5,000 5,000 - 100% n/a Des Cty Court Security 129,000 121,050 (7,950) 100% 94% Des Cty Juvenile Contract 3,000 5,456 2,456 100% 182% Title III Reimbursement 150,000 47,259 (102,741) 100% n/a Transport 2,000 2,837 837 100% n/a Other - 1,320 1,320 100% n/a Claims Reimbursement - 37,528 37,528 100% n/a DC Fair & Expo Center - 2,100 2,100 100% n/a Inmate Commissary Fees 60,000 61,084 1,084 100% 102% Work Center Work Crews 42,450 22,350 (20,100) 100% 53% Concealed Handgun Classes 6,000 6,875 875 100% 115% Soc Sec Incentive-Fed 5,000 11,400 6,400 100% 228% Miscellaneous 4,000 9,382 5,382 100% 235% Oregon Mentors 5,000 2,136 (2,864) 100% n/a Medical Services Reimb 12,000 14,575 2,575 100% 121% Restitution 1,050 1,449 399 100% 138% Sheriff Fees 160,000 212,606 52,606 100% 133% Interest 28,333 57,104 28,771 100% 202% Interest on Unsegregated 3,533 3,473 (60) 100% 98% Rentals 30,000 85,094 55,094 100% 284% Donations - 50 50 100% n/a Total Revenues 17,772,417 19,053,693 1,281,276 100% 107% TOTAL RESOURCES 20,242,936 22,397,154 2,154,218 100% 111% REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Materials and Services 20,242,936 16,777,094 3,465,842 100% 83% TOTAL REQUIREMENTS 20,242,936 16,777,094 3,465,842 100% 83% NET (Resources - Requirements) - 5,620,060 5,620,060 Beginning NWC per Adopted Budget 4,722,862 SHERIFF 702 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $1,287,473 $ 1,433,708 $ 146,235 100% n/a Revenues Tax Revenues - Current 7,239,702 7,464,529 224,827 100% 103% Tax Revenues - Prior 239,000 430,504 191,504 100% 180% Federal Grants 2,000 79,159 77,159 100% 3958% US Forest Service 76,500 57,375 (19,125) 100% 75% State Grant 187,633 139,487 (48,146) 100% 74% SB #1065 Court Assessment 67,000 56,535 (10,465) 100% 84% Marine Board License Fee 124,468 78,500 (45,968) 100% 63% Grants - 3,468 3,468 100% n/a Des Cty General Fund Grnt 863,163 643,163 (220,000) 100% 75% Des Cry Transient Room Tax 1,786,837 2,016,837 230,000 100% 113% City of Sisters 420,015 416,015 (4,000) 100% 99% Des Cty Tax/Fin Contract 1,000 1,405 405 100% 141% Des Cty CDD Contract 27,183 27,183 - 100% 100% Des Cty Solid Waste Contr 81,548 81,545 (3) 100% 100% Des Cty Clerk/Election 2,000 2,084 84 100% 104% School Districts 100,000 57,745 (42,255) 100% n/a Claims Reimbursement - 36,232 36,232 100% n/a Security & Traffic Reimb 13,000 12,761 (239) 100% 98% Seat Belt Program 6,000 9,150 3,150 100% 153% Miscellaneous 10,000 10,222 222 100% 102% Sheriff Fees 5,000 12,291 7,291 100% 246% Court Fines & Fees 85,000 134,040 49,040 100% 158% Impound Fees 75,000 12,400 (62,600) 100% 17% Restitution - Street Crimes - 1,074 1,074 100% n/a Seizure/Forfeiture - 1,122 1,122 100% n/a Interest 10,000 16,695 6,695 100% 167% Interest on Unsegregated 1,800 1,701 (99) 100% 95% Sale of Reportable Assets - 6,779 6,779 100% n/a Sale of Equip & Material 6,000 13,656 7,656 100% 228% Total Revenues 11,429,849 11,823,656 393,807 100% 103% TOTAL RESOURCES 12,717,322 13,257,364 540,042 100% 104% REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Materials and Services 12,717,322 10,919,465 1,797,857 100% 86% TOTAL REQUIREMENTS 12,717,322 10,919,465 1,797,857 100% 86% NET (Resources - Requirements) - 2,337,899 2,337,899 Beginning NWC per Adopted Budget 1,905,939 PUBLIC HEALTH Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 900,000 $ 1,120,355 $ 220,355 100% 124% Revenues Medicare Reimbursement 4,000 346 (3,654) 100% 9% State Grant 2,709,730 2,095,576 (614,154) 100% 77% Child Dev & Rehab Center 34,737 23,069 (11,668) 100% 66% State Miscellaneous 213,240 207,395 (5,845) 100% 97% OMAP 303,000 540,420 237,420 100% 178% Family Planning Exp Proj 475,000 493,165 18,165 100% 104% Grants - 55,755 55,755 100% n/a FY 2008-2009 - 4,568 4,568 100% n/a Miscellaneous - 2,440 2,440 100% n/a Patient Insurance Fees 133,800 151,004 17,204 100% 113% Health Dept/Patient Fees 152,150 126,603 (25,547) 100% 83% Vital Records-Birth 36,000 33,250 (2,750) 100% 92% Vital Records-Death 98,000 99,540 1,540 100% 102% Interest on Investments 38,000 16,220 (21,780) 100% 43% Donations 8,800 42,535 33,735 100% 483% Interfund Contract 91,692 60,381 (31,311) 100% 66% Administrative Fee 27,000 27,000 - 100% 100% Drug Court Byrne 40,082 20,452 (19,630) 100% n/a Total Revenues 4,365,231 3,999,719 (365,512) 100% 92% Transfers In-Reserve Fund 25,000 25,000 - 100% 100% Transfers In-General Fund 2,317,765 2,317,765 - 100% 100% TOTAL RESOURCES 7,607,996 7,462,839 (145,157) 100% 98% REQUIREMENTS: Exp. Expenditures Personal Services 4,548,325 4,265,820 282,505 100% 94% Materials and Services 1,912,716 1,707,520 205,196 100% 89% Capital Outlay 86,902 26,414 60,489 100% 30% Transfers Out 150,000 150,000 - 100% 100% Contingency 910,053 - 910,053 100% n/a TOTAL REQUIREMENTS 7,607,996 6,149,753 1,458,243 100% 81% NET (Resources - Requirements) - 1,313,086 1,313,086 Beginning NWC per Adopted Budget 1,100,000 BEHAVIORAL HEALTH Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 2,725,000 $ 2,589,996 $ (135,004) 100% 95% Revenues Marriage Licenses 5,500 5,265 (235) 100% 96% Divorce Filing Fees 125,000 129,371 4,371 100% 103% Domestic Partnership Fee 2,000 95 (1,905) 100% 5% Federal Grants 99,819 95,346 (4,473) 100% 96% State Grants 5,277,086 5,367,146 90,060 100% 102% State Miscellaneous 184,716 166,755 (17,961) 100% 90% Title 19 300,705 126,735 (173,970) 100% 42% Liquor Revenue 106,000 132,272 26,272 100% 125% School Districts 70,000 89,900 19,900 100% 128% Miscellaneous 40,800 37,413 (3,387) 100% 92% Patient Insurance Fees 247,500 144,882 (102,618) 100% 59% Patient Fees 11,500 3,235 (8,265) 100% 28% Seizure/Forfeiture - 13,129 13,129 100% n/a Interest on Investments 32,000 38,903 6,903 100% 122% Rentals 16,500 13,500 (3,000) 100% 82% Donations 3,000 7,000 4,000 100% 233% Interfund Contract 3,120 - (3,120) 100% 0% Administrative Fee 3,034,954 3,001,703 (33,251) 100% 99% Comm. on Children & Fam 22,000 50,686 28,686 100% 230% Crime Prevention Services 127,000 120,632 (6,368) 100% 95% Total Revenues 9,709,200 9,543,969 (165,231) 100% 98% Transfers In-General Fund 1,316,158 1,316,158 - 100% 100% Transfers In-Other 255,636 363,129 107,493 100% 142% TOTAL RESOURCES 14,005,994 13,813,252 (192,742) 100% 99% REQUIREMENTS: Exp. Expenditures Personal Services 8,070,245 7,483,656 586,589 100% 93% Materials and Services 4,053,514 3,621,096 432,418 100% 89% Capital Outlay 80,000 - 80,000 100% 0% Transfers Out 150,000 150,000 - 100% 100% Contingency 1,652,235 - 1,652,235 100% n/a TOTAL REQUIREMENTS 14,005,994 11,254,752 2,751,242 100% 80% NET (Resources - Requirements) - 2,558,500 2,558,500 Beginning NWC per Adopted Budget 2,616,050 COMMUNITY DEVELOPMENT Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 413,471 629,659 $ 216,188 100% 152% Revenues Admin-Operations 3,650 17,639 13,989 100% 483% Admin-GIS 2,075 38,809 36,734 100% 1870% Admin-Code Enforcement 189,450 171,136 (18,314) 100% 90% Building Safety 974,775 953,909 (20,866) 100% 98% Electrical 280,500 261,645 (18,855) 100% 93% Contract Services 255,500 124,685 (130,815) 100% 49% Env Health-On Site Prog 292,850 241,626 (51,225) 100% 83% Env Health-Lic Facilities 690,475 737,517 47,042 100% 107% Env Health - Drinking H2O 95,311 93,874 (1,437) 100% 98% Planning-Current 984,150 670,045 (314,105) 100% 68% Planning-Long Range 428,900 311,651 (117,249) 100% 73% Total Revenues 4,197,636 3,622,537 (575,099) 100% 86% Trans In-GF 1,216,627 1,216,627 - 100% 100% Trans In-GF for Lng Rng Ping 300,000 300,000 - 100% 100% Trans In-Other 115,799 114,734 (1,065) 100% 99% TOTAL RESOURCES 6,243,533 5,883,556 (359,977) 100% 94% REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Admin-Operations 1,708,112 1,604,912 103,200 100% 94% Admin-GIS 215,606 206,124 9,482 100% 96% Admin-Code Enforcement 180,969 167,604 13,365 100% 93% Building Safety 725,145 633,966 91,179 100% 87% Electrical 206,719 189,207 17,512 100% 92% Contract Services 264,781 249,136 15,645 100% 94% Env Health-On Site Pgm 240,687 236,986 3,701 100% 98% Env Health-Lic Facilities 495,946 519,440 (23,494) 100% 105% Env Health - Drinking H2O 80,598 83,219 (2,621) 100% 103% Planning-Current 809,783 771,285 38,498 100% 95% Planning-Long Range 551,828 458,298 93,530 100% 83% Transfers Out (D/S Fund) 177,660 177,660 - 100% 100% Contingency 585,699 - 585,699 100% n/a TOTAL REQUIREMENTS 6,243,533 5,297,837 945,696 100% 85% NET (Resources - Requirements) - 585,719 585,719 Beginning NWC per Adopted Budget 686,081 Revenues 3,622,537 Expenditures 5,297,837 Net from Operations (1,675,301) ROAD Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual I Variance IFY % I Coll. %I RESOURCES: Beg. Net Working Capital $ 4,871,665 $ 4,891,649 $ 19,984 100% 100% Revenues Federal Reimbursements 490,000 - (490,000) 100% 0% System Development Chrg - 693 693 100% n/a Mineral Lease Royalties 10,000 115,306 105,306 100% 1153% Forest Receipts 2,482,000 2,482,310 310 100% 100% State Grant 415,477 - (415,477) 100% 0% State Miscellaneous - 54,322 54,322 100% n/a Motor Vehicle Revenue 8,000,000 7,728,198 (271,802) 100% 97% City of Bend 225,000 297,294 72,294 100% 132% City of Redmond 250,000 316,603 66,603 100% 127% City of Sisters 10,000 - (10,000) 100% 0% City of La Pine 10,000 - (10,000) 100% n/a Admin Recovery (SDC) 500 1,431 931 100% n/a Miscellaneous 130,000 157,272 27,272 100% 121% Road Vacations 1,000 500 (500) 100% 50% Interest on Investments 50,000 45,226 (4,774) 100% 90% Other Bank/LGIP Interest - 1,736 1,736 100% n/a Parking Fees - 300 300 100% n/a Interfund Contract 700,000 715,469 15,469 100% 102% Equipment Repairs 275,000 254,617 (20,383) 100% 93% Vehicle Repairs 90,000 78,089 (11,911) 100% 87% Vegetation Management 35,000 - (35,000) 100% 0% Inter-fund: Forester 22,000 12,153 (9,847) 100% 55% Car Washes 2,500 3,818 1,318 100% 153% Car Rental - 406 406 100% n/a Forester - - - 100% n/a Sale of Eqp & Material 800,000 745,748 (54,252) 100% 93% Total Revenues 13,998,477 13,011,491 (986,986) 100% 93% Trans In - CDD 18,190 18,190 - 100% 100% Trans In - Solid Waste 708,568 708,567 (1) 100% 100% Trans In - Transp SDC 75,000 75,000 - 100% 100% Trans In-Road Imp Res 10,000 - (10,000) 100% 0% TOTAL RESOURCES 19,606,900 18,704,897 (977,003) 100% 100% REQUIREMENTS: Exp. Expenditures Personal Services 5,665,373 5,302,283 363,090 100% 94% Materials and Services 9,133,210 8,368,366 764,844 100% 92% Capital Outlay 2,700,000 1,302,528 1,397,472 100% 48% Transfers Out 400,000 400,000 - 100% 100% Contingency 1,783,316 - 1,783,316 100% n/a TOTAL REQUIREMENTS 19,681,899 15,373,177 4,308,722 100% 78% NET (Resources - Requirements) (74,999) 3,331,719 3,331,718 Beginning NWC per Adopted Budget 3,430,429 ADULT PAROLE & PROBATION Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 RESOURCES: Beg. Net Working Capital Revenues DOC Measure 57 State Miscellaneous Alternate Incarceration State Subsidy SB 1145 Probation Work Crew Fees Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Interest on Investments Interfund - Sheriff Crime Prevention Services Total Revenues Year to Date Budget Actual Variance FY % Coll. % $ 467,892 $ 487,674 $ 19,782 100% 104% 217,305 217,350 45 100% 100% 8,000 4,301 (3,699) 100% 54% - 30,918 30,918 100% n/a 29,500 13,306 (16,194) 100% 45% 2,839,925 2,961,989 122,064 100% 104% 40,000 32,475 (7,526) 100% 81% 3,000 4,580 1,580 100% 153% 160,000 191,291 31,291 100% 120% 220,000 235,217 15,217 100% 107% 9,000 12,377 3,377 100% 138% 50,000 50,000 - 100% 100% 50,000 50,000 - 100% 100% 3,626,730 3,803,803 177,073 100% 105% Transfers In-General Fund 115,029 115,029 - 100% 100% TOTAL RESOURCES 4,209,651 4,406,506 196,855 100% 105% REQUIREMENTS: Exp. Expenditures Personal Services 2,988,079 2,871,561 116,518 100% 96% Materials and Services 792,073 787,515 4,558 100% 99% Capital Outlay 40,100 10,448 29,652 100% 26% Contingency 389,399 - 389,399 100% n/a TOTAL REQUIREMENTS 4,209,651 3,669,523 540,128 100% 87% NET (Resources - Requirements) - 736,983 736,983 Beginning NWC per Adopted Budget 616,371 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 624,543 $ 668,626 $ 44,083 100% 107% Revenues Federal Grants 367,800 330,337 (37,463) 100% 90% Title IV - Family Sup/Pres 37,652 12,545 (25,107) 100% 33% HealthyStart Medicaid 95,000 79,223 (15,777) 100% 83% Child Care Block Grant 81,275 - (81,275) 100% 0% Level 7 Services 175,193 210,673 35,480 100% 120% State Prevention Funds - 8,374 8,374 100% n/a HealthyStart /R-S-G 307,577 308,924 1,347 100% 100% OCCF Grant 614,052 501,959 (112,093) 100% 82% Local Government Grants - 7,849 7,849 100% n/a Charges for Svcs-Misc 8,000 4,262 (3,738) 100% 53% Court Fines & Fees 75,000 77,623 2,623 100% 103% Interest on Investments 30,000 9,005 (20,995) 100% 30% Grants-Private 2,000 - (2,000) 100% 0% Donations - 4,000 4,000 100% n/a Video Lottery - 2,000 2,000 100% n/a Interfund Grants 187,500 169,900 (17,600) 100% 91% Crime Prevention Services 74,350 49,565 (24,785) 100% 67% Total Revenues 2,055,399 1,776,238 (279,161) 100% 86% Trans from General Fund 284,333 284,333 - 100% 100% Total Transfers In 284,333 284,333 - 100% 100% TOTAL RESOURCES 2,964,275 2,729,197 (235,078) 100% 92% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Exp. 539,978 528,678 11,300 100% 98% 1,917,843 1,402,221 515,622 100% 73% 100 - 100 100% 0% 506,354 - 506,354 100% n/a 2,964,275 1,930,899 1,033,376 100% 65% - 798,298 798,298 Beginning NWC per Adopted Budget 562,762 SOLID WASTE Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 338,611 $ 466,325 $ 127,714 100% 138% Revenues State Grant - 37,850 37,850 100% n/a Miscellaneous 30,000 26,562 (3,438) 100% 89% Franchise 3% Fees 200,000 209,129 9,129 100% 105% Commercial Disp. Fees 1,396,400 842,145 (554,255) 100% 60% Private Disposal Fees 1,541,300 1,405,964 (135,336) 100% 91% Franchise Disposal Fees 4,743,500 3,826,290 (917,210) 100% 81% Yard Debris 75,000 75,843 843 100% 101% Special Waste 30,000 34,181 4,181 100% 114% Interest 14,000 12,298 (1,702) 100% 88% Leases - 241 241 100% n/a Interfund-Miscellaneous - 5,952 5,952 100% n/a Sale of Equip & Material 35,000 33,577 (1,423) 100% 96% Total Revenues 8,065,200 6,510,034 (1,555,166) 100% 81% TOTAL RESOURCES 8,403,811 6,976,359 (1,427,452) 100% 83% REQUIREMENTS Exp. Expenditures Personal Services 1,763,578 1,735,389 28,189 100% 98% Materials and Services 3,748,254 3,108,642 639,612 100% 83% Debt Service 968,765 968,765 (0) 100% 100% Capital Outlay 149,000 52,897 96,103 100% 36% Transfers Out 1,439,767 708,567 731,200 100% 49% Contingency 334,447 - 334,447 100% n/a TOTAL REQUIREMENTS 8,403,811 6,574,260 1,829,551 100% 78% NET (Resources - Requirements) - 402,099 402,099 Beginning NWC per Adopted Budget 392,509 RESOURCES: Beginning Net Working Capital Revenues Inter-fund Charges: General Liability Property Damage Vehicle Workers' Compensation Unemployment Claims Reimb-Workers' Compensation Claims Reimb-Gen Liab/Property Process Fee-Events/Parades Miscellaneous Skid Car Training Interest on Investments TOTAL REVENUES Transfers In-PERS Reserve TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Defense Professional Service Insurance Loss Prevention Repair/ Replacement Total General Liability PROPERTY DAMAGE Insurance Repair / Replacement Total Property Damage VEHICLE Professional Service Insurance Loss Prevention Repair / Replacement Total Vehicle WORKERS' COMPENSATION Settlement / Benefit Insurance Loss Prevention Miscellaneous Total Workers' Compensation UNEMPLOYMENT - Settlement/Benefits Total Direct Insurance Costs Insurance Administration: Personal Services Materials & Service Capital Outlay Total Insurance Administration Contingency TOTAL REQUIREMENTS NET RISK MANAGEMENT Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/19/2010 Budget Actual Variance % of FY % Coll. $2,491,977 $2,669,291 $177,314 100% 107% 456,964 456,964 - 286,294 286,079 (215) 184,195 184,195 - 855,854 861,712 5,858 160,191 161,683 1,492 25,000 - (25,000) 10,000 121,666 111,666 900 1,830 930 4,000 14 (3,987) 22,000 11,760 (10,240) 30,000 32,539 2,539 2,035,398 2,118,441 83,043 100 - (100) 4,527,475 4,787,732 260,257 84,849 3,184 2,546 153,953 25 4,883 365,112 249,439 115,673 136,185 128,602 340,000 264,787 75,213 3,080 411 15,668 171,340 200,000 190,498 9,502 723,362 109,886 36,023 32,594 800,000 901,866 (101,866) 220,000 236,784 (16,784) 1,925,112 1,843,374 81,738 274,034 272,148 1,886 246,493 194,009 52,484 100 - 100 520,627 466,157 54,471 2,081,736 - 2,081,736 4,527,475 2,309,531 2,217,944 - 2,478,201 2,478,201 100% 100% 100% 100% 100% 100% 100% 101% 100% 101% 100% 0% 100% 1217% 100% 203% 100% 0% 100% 53% 100% 108% 100% 104% 100% 0% 100% 106% Ex . 100% 68% 100% 78% 100% 95% 100% 113% 100% 108% 100% 96% 100% 99% 100% 79% 100% 0% 100% 90% 100% n/a 100% 51% Beginning NWC per Adopted Budget 2,500,000 DESCHUTES COUNTY 911 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7119/2010 Year to Date Budget Actual Variance % of FY % Coll. RESOURCES: Beg. Net Working Capital $ 5,137,000 $ 5,611,168 $ 474,168 100% 109% Revenues Property Taxes - Current 6,130,782 6,328,544 197,762 100% 103% Property Taxes - Prior 100,000 301,139 201,139 100% 301% State Reimbursement 24,500 7,096 (17,404) 100% 29% Telephone User Tax 536,000 653,956 117,956 100% 122% Data Network Reimb. 34,000 26,032 (7,968) 100% 77% Jefferson County 28,000 44,499 16,499 100% 159% User Fee 60,500 55,706 (4,794) 100% 92% Contract Payments 70,000 25,574 (44,426) 100% 37% Miscellaneous 8,500 9,006 506 100% 106% Interest 36,000 83,624 47,624 100% 232% Interest on Unsegregated Tax 3,750 1,439 (2,311) 100% 38% Total Revenues 7,032,032 7,536,616 504,584 100% 107% Transfers In-Other 100 - (100) 100% 0% TOTAL RESOURCES 12,169,132 13,147,784 978,652 100% 108% REQUIREMENTS: % Exp. Expenditures Personal Services 3,816,287 3,498,519 317,768 100% 92% Materials and Services 1,289,522 1,197,101 92,421 100% 93% Capital Outlay 175,000 39,300 135,700 100% 22% Transfers Out 1,938,939 1,938,939 - 100% 100% Contingency 4,949,384 - 4,949,384 100% n/a TOTAL REQUIREMENTS 12,169,132 6,673,859 5,495,273 100% 55% NET (Resources - Requirements) - 6,473,925 6,473,925 Beginning NWC per Adopted Budget 5,861,335 Health Benefits Trust Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/19/2010 I Budget Actual Variance FY % Coll. RESOURCES Beg. Net Working Capital $ 17,894,797 $ 17,894,797 $ (0) 100% 100% Revenues: Internal Premium Charges 10,480,000 10,479,809 (191) 100% 100% P/T Emp - Add'I Prem 55,000 43,758 (11,242) 100% 80% Employee Prem Contribution 330,000 340,983 10,983 100% 103% COIC 1,000,000 1,135,675 135,675 100% 114% Retiree / COBRA Co-Pay 500,000 610,377 110,377 100% 122% Prescription Rebates - 42,066 42,066 100% n/a Interest 225,000 208,595 (16,405) 100% 93% Total Revenues 12,590,000 12,861,265 271,265 100% 102% TOTAL RESOURCES 30,484,797 30,756,061 271,264 92% 101% REQUIREMENTS Exp. Expenditures: Personal Services 109,297 103,742 5,555 100% 95% Materials & Services Conferences and Seminars 3,000 749 2,251 100% 25% Claims Paid-Medical/Rx 14,247,576 11,225,228 3,022,348 100% 79% Claims Paid-DentalNision 1,822,000 1,687,568 134,432 100% 93% Refunds - (108,289) 108,289 100% n/a Insurance Expense 372,540 374,287 (1,747) 100% 100% State Assessments 11,500 1,039 10,461 100% n/a Administration Fee 292,764 358,744 (65,980) 100% 123% PPO Fee 81,648 37,838 43,810 100% 46% Health Impact 49,572 49,865 (293) 100% 101% Printing 10,000 10,800 (800) 100% 108% Program Supplies 100,000 1,239 98,761 100% 1% Workplace Clinic - 3,959 (3,959) 100% n/a Other 29,059 24,741 4,318 100% 85% Total Materials & Services 17,019,659 13,667,768 3,351,891 100% 80% Capital Outlay 100.00 - 100 100% 0% Contingency 13,355,741 - 13,355,741 100% 0% TOTAL REQUIREMENTS 30,484,797 13,771,510 16,713,287 100% 45% NET (Resources - Requirements) ' - 16,984,551 16,984,551 Beginning NWC per Adopted Budget 16,400,000 Note: Actual average weekly claims FY 2010 = $266,761 0 O LL N W Uo c L N M v c G co W y d = C CA C N > LL1 O N O j U c y > > L J CA Q ~ m H U oa _T .Oi. c O 2 N > B N OO f~Lo t01 CO O M N 'I. r tO c0 to iC0 N O t0. at1 Ic010 O r_I 1 N I,NI4r0 ION r M O aDl f0 co O M I 8; I a;0 tOr 1 N sT Of CD ~ i 3 I cc 11-i2 C DI et ~it~f' 0 N ! O N '(O vN ~I 'N n ~ O,tO"t0 INI N W M It'- OItOI tOr' N ~Ic ~ CIJ CO r co > I II I i I I I I I I I I i I I I I I i I I I,. O OfO O~ OlOT O 0101 0 01 l O!M'~ : M' O I O O~CO I[n tt')IOI I ~ N 4I I NI N O N V OIO O'N O r 0 O O o lo OO; 010 C NF h tO O O tO ico o 0 10 OI CO ;O!P 0 CI;OO t0' n~ r:QI et tO t0 tA N lr to i t01 O 'O : M N O CO to O IOe'-i WI~'0 v CO N CO I~ N O N I-- m C to a ' Y91t0 OfIOf r l 7 LL co v Ito rtO d' M N j I .•7 a NM LO i0 tn: MI -r; O Iefl ~ ;I. cO tT~N c0 v r 0) r ~ N i~ N'N r ~ O ~ Cc IOiO 1(10- m i' MI;tO to COICO'I~ M 00 V 0) M tO 0110 0110)! 'I IM C-4 'M O t0 t+ M 910IC0 2 l0 O' ;t0! IP; tpl to I i N~ M N O 01 OI OIMIaII cAit010 0: iv 'COlo M N EPIC 0~ O! O 0 O O r d' N N N t6 d t) 1 I(rj' 00 I i I ; IM t` CV 04 ~ M , r:M M r i~lt0 i, O 'v M 0)I 'tbj tO , N ~I tO r ~MI tp I~iNiO r N, CD O CO O t0 tff ti t0 r } Q IMI I rl 1 t01 t~ t01; NI i w IrI v N CO N c INI IVi' IO ",N Olli co ' ~ N j O tO co 11 ~r ^i I I O) ION ^I co COOT " ' 'i M N, I 1 rI III 4' ' 1 N 1 I r TI N y t0 C00 co l I i~ Lo 1 ,II I i to Mi Go : 7 1' I I I l I, I I I I'" I I I I I i I l l v t0 I O ' , ' O 0 N 1 00 ' ' I CO . ) N~ CO MAI COI O M f O O O f` N M i t0 t0 O) t[) n M II co n N to -r0 tD O) O M f CO CV I M COIN OI ~ IrI I I r v ' N ' ~ I t r L.. _ ~M v O i -P- ' f`, CO O t0i N M ol 0 00 v M CO I A1 i v t0 i0)I Clio O 'ICI N N O 0 O ' c I MI r [1 M I l M N i III d a I I.- r 1 0 I CO a 01 CM m y ~I I 'a I~ I I 4 N I ~ ~ I 41 N' I CI i t ! N j 'O 00' n 1 O 1 1 0 ~ d' I o O a rl -'4i t0 M N ( r O MI N CA ~ O 0 O w r Cc N l O CO 3 rI CO r ~ O ' O tO ' co P-1 et' CO NI M ' O) t~ I ~ W 0 tO ' ' I O O r Y')' r p I MI I d' N- COIM p t01 V' I N M M e I 1 , l Z N LO N ' M M ' I f~I VI rnl O v tO a N I Ir 0)jN n to I CO) 'Q ' CO NI M' M IOII I o ';Ot N I , ~ ' co ~ fi l a I ~ O ~ ' vi I C I r ' N CO M O jv , ~ I I I LL I ~I I ; ! I iI 1 7 Z` N -00f co IM' I OD NI 'I to N O) n O v j ' CO~ N MI OI n NI OItO L" v co N I~~I~i, ' 10 It0 In IN j ' ' ~ O O O r 1 O O O ' O to c0 tff t0 M O Mi CA a M A ~ M E M O N O Q C t 1 r: I I f I I N, ` Ow I I aD v~ ' II I ,II 1 I I 10I I I t0 I; N 1 y I ! LO N ' MI n Mi a0 1 OI O O) l N aD O' t01 "OI ' ~ O, r' I ' i ' I 010= 0 0, ~ 0 04 Oi c0! r (A: ' ' OI 0 I ' r to r 3 I E T o I CO . I to l IMI~ Ii ~ l A I MI O rI I v V! l COI I O I M I N M . ! O r I .0 N' co tD vi O I O) t0 ! 1, I 00 Mi l 01 V1 tOI I O MI I tO O) COI ! I i N E ! I O C ' I O r' I 1 I I i 0 ~ t ' MI r S M -0iCp 1 'l COI7I r M' ^ I ' f0 N N 'I O O OI' ^ tON `.O , ' ' M O) O O r M > CO V' 1 I cV( a0 t0 CO I I d•'bI O O O IMi M M CO v n n CO p OI ! I r I v j I I ~ r O O O h co co 01 to co l CO'c1 ih r 0 r M N l N N CV OI O ' I ' 0 ' 7 l' ' a M 1 I 1 " O thl'iV~ O I 1 i II A 1 ~ I O U O It- N Ln I r v a I ' I I I I i I ' j I I I N m O M N V IN I O d N r I I~'M I COIN I 0 O r I O ' N M O CID O) O O ' M O Yf' O. E ; " N N i i V7 r 1 f~ N In OCOI', o CID t0 , ' I ' 'I 0) (q to C O ' C IL I CL ~ I I l IN I I(D Nt CD LM... C O T r on ~ I 7 Z) (O M M II ' I ' O n 0 r A y In MI I~~ NI DI WI, r' , ' O CO ~ M ; M I Ol I 1 IN st N ~ ! r r C16 CID I Q r CO O I co c0 O In N ' to O p O N N 'O' OT' co co r , 1p~ Ito M N N ~ I I , N CO I r co a 0 I I I U I o th j O y LL 0 w O N W I Cy01 Q V ^i 'CO^O j _ to I U) I lL CL ' L 0 3 C 0 U) 1 N 7 Cy1 0j C 7 I C y a C 'r ' C y C1 C C y 0 fy -0 c X W v U CD N ''v C v :3 Y E N C C M 0 >G1 X N > ILL o (D ~ ~ m V O 2 O U Oo C ` X W U c l4 ~ O i7 tc ~ ~ l U. R C i O °3 ~ - O " 1~ V N 7 O V 7 LL tc V U I 1 X W e 4) 0' O a CtS 0 N C Cn N O C n 0 ' to S N C r y ~ .1 s ~y 1 C o lfi LL w L y 0 Z CM c v) y inc LL y~' tu H E E l 0 - ~ O N C rn w ta C d 0 _ E ` O c c a1 to N a m Z V •C . ' «O V; U) wO C O 0 C 0 y O C & > W N 9 to w o O = O U i- a a 2 cc U o d ol tc c 1 T Z c Q 0 ILL O O 0 CIO 10 t5 IQ I Z Z IU Deschutes County - Fair and Expo Center YTD-Budget Basis Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 1 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 75,000 $ 42,232 $ (32,768) 100% 56% Receipts: Security & Traffic Reimb 12,000 - (12,000) 100% 0% Miscellaneous 4,000 3,658 (342) 100% 91% Vending Machines 2,300 1,319 (981) 100% 57% Telephone Fees - Events 1,200 740 (460) 100% 62% Special Events Revenues 540,000 383,679 (156,321) 100% 71% Interest 2,000 213 (1,787) 100% 11% Storage 58,000 43,463 (14,537) 100% 75% Camping at F & E 7,000 7,365 365 100% 105% Horse Stall Rental 45,000 22,875 (22,125) 100% 51% Concession % - Food 235,000 123,539 (111,461) 100% 53% Rights (Signage, etc.) 86,420 115,000 28,580 100% 133% Donations - 3,300 3,300 100% n/a Interfund Contract 45,000 45,000 - 100% 100% Total Receipts 1,037,920 750,151 (287,769) 100% 72% Transfers In General Fund 197,919 197,919 - 100% 100% Transient Room Tax 22,765 22,765 - 100% 100% Welcome Center 80,000 80,000 - 100% 100% County Fair (619) 197,421 80,000 (117,421) 100% 41% a) F & E Reserve (617) - 250,000 250,000 100% n/a b) Total Transfers In 498,105 630,684 132,579 TOTAL RESOURCES 1,611,025 1,423,066 (187,959) 100% 88% REQUIREMENTS: Exp. Expenditures: Personal Services 824,769 774,532 50,237 100% 94% Materials and Services 531,604 516,092 15,512 100% 97% Debt Service 116,188 116,188 0 100% 100% Capital Outlay 100 - 100 100% 0% Transfer to Reserve Fund (617) 16,412 - 16,412 100% 0% b) Contingency 121,952 - 121,952 100% n/a TOTAL REQUIREMENTS 1 ,611,025 1,406,812 204,213 100% 87% NET (Resources - Requirements) - 16,254 16,254 Beginning NWC per Adopted Budget 2,809 a) Transfer from Annual County Fair fund will be $117,421 less than budgeted. b) Instead of a transfer TO the Reserve Fund, a transfer will be made FROM the Reserve Fund. e Current Month Events Prior Months Accounts Receivable 12,360 15,831 FY 2011 July 104,764 August 89,300 September 4,170 28,191 October 2,600 November 4,550 December 275 January 100 February 620 March 500 April 1,800 May 600 June 800 FY 2012 & beyond 6,550 TOTAL 216,629 Deschutes County Bethlehem Inn (Fund 128) Year Ended June 30, 2010 and FY 2011 Budget FY 2011 FY 2010 Adopted Budget Actual Variance FY % Coll. % Budget RESOURCES: Beg. Net Working Capital $ (2,666,469) $ (2,689,172) $ (22,703) 100% 101% $ (2,725,000) Revenues Grants - Private 2,766,469 - (2,766,469) 100% 0% 2,861,000 Total Revenues 2,766,469 - (2,766,469) 100% 0% 2,861,000 TOTAL RESOURCES 100,000 (2,689,172) (2,789,172) 100% -2689% 136,000 REQUIREMENTS: Exp. Expenditures Debt Service: Negative Interest Revenue 36,000 Interest Payment 100,000 33,338 66,662 100% 33% a) 100,000 TOTAL REQUIREMENTS 100,000 33,338 66,662 100% 33% 136,000 NET (Resources - Requirements) - (2,722,510) (2,722,510) Beginning NWC per Adopted Budget a) June 2010 interest expense - $2,221.55. b) Recap of expenditures - inception through June, 2010 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 204,597 Total expended $ 2,722,510 b) - U U O m C ~ O V U ~ to ~ O O L CL N a a) 3 U) N N C a) C9 rn 3 c a) Q x w N H v a) m a) It c m N LL C O co 3 w L - co c E m N U C N c O U t0 I0 0 Uo to ,N to 10 t() 00 V IN O) 0 U) , co M N CC 0 It ro O to Un o 0 US ' M 0 co t0 M 0 ~0 U-) (D U-) jto U-) lu- 10 0 U*) I r` Uo N O co M 0 (0 0) t_ I M co tO w c M c M CO I It 0 LO M r ' 0 0 M r C O) t() r, cl 1 et CV et r- r M N (h 0 (V N LO r r ( i i I r N c . 0 O) N , M co I N , t. O t j i t. Go , t0 O L , O) C ' I N I 7 l I I O O ~ ' ' ' ' O I O N lto M ~ ~ co o ' N in O Lf) I O N O 0 O co r• I S t0 co N p I r c I N i i , , I r l I l i ' Q 0 O 0 N Op co CO I m CO cc I ~ J ti LO t1) ~ I to II- O N r 0 Lo M I O i ' ' r ' ' I ' m M . M M iM ~ m ' co I ('7 O M O O O M I- N c7 IM ~ I I I N M i ~ II I I I N . i ~ ' I I i I ' IO N ~ ~ (O co ' I M W ' LO ~ LO N p rr co IM I O I CO ' I t M IN M , , I M N I ~ I i r i I ~ C t00 i N O O In O t- I M ~ j I U OI 0 M 0 (O ao O N h h O r ti p rl lA CO N O M O N O o IN r` 0 O i m m I O` L (O N ' I N ' N 0 Q) ' w N I , 0 , to I ~ .r ~ r i ~ I I I I tmn > O I O N 0 N O M 1 O T- B Go IT co o I d I c CL Z ' i ' I M I I 00 I G x I ' 0 U O LO M O tO 0 to M to to d I O L O LO M tO N N 0 It t. to N er I 00 r 0i to ' N ' i~ I M O I ~ ~I r M O n (D O c = O O r C ) O O co l ( C I I r r I r ~i ~ IN I I CO CL co I Go LO N ~C4 co 0 Q I I 0 O N t I Lcoq ti~ MO I M to ~ I UO co I co I N I ' y I I i co 3 I~ 1 20 I I j i i ~ L I I ' a L rn c j rn c c' +r c I 4) w may L o 0 cc -2 co `i a) a I ~ ` 3 a~ E a I I E a E v i v E a CIO O o 1 ~ I 0 rn o 3i I rn 2 . I 3 y c N ~ D l c W O ' h o. w of 3 a L ' w d o v p 0 a u ai N d C °iS ~ a E c m d c m 'o m E . 2 a, Y otS N - c0 ca -0 . w c d O! 06 d w V w (1) to w c v O tT -0 ( 3 LL x O (a m E ~ a) ~ O E ~ m i- O01 Y ~ E a) N 2 O E ~ 7 L d E a) 2 O E 2 ~ 2 F- c E p C~ 0 E O 0) I O O a) IX t`0 F- m i co 0 a~ V) (D E p m a 3 -a J M j E (D (p 7 m O E a, N o j m a) ~ 2 6 E E I 2 m C r O N c m E c O U a ) - o I- ~c c 0 v a) O O _ p > p U a) O O L c O c > O U m ) 3 N C G O U ` F- U Q _ ~ 9 c 0 p U N l- U Q m 9 F C (o U N L l- U Q = ~I L C~ F d . O U F l0 O U Q Q - ~ O C9 - LL a) C N I H D Q' 0 IF'I I I , I I Z O 0 N tT ti O (No Q wN w a 0 0 N 0) e- iz: N QOM LO Lf) N O .~-MO0to0 0 OOCo I- d' U IT 0in to to I- MN M ~Oto't O 000 to O C MOO ' 0 ' MN N ' ww0MM ` 00 COON co 00 CCi qct tt•) O t} Cv v 00 00 N Cv M . N d• to r V Z a r v 0 0 r ~ N O co CO C H ~ U W 0 I~ O t~ O 0 to 0 0 N 00 0 T- M W 0 r~ CO O O CO M a' ~O o0000g9tMNaM~Otoe- N 00N qt O n. 36 00 CO~toOMN~to00O0COtn0 LO COO e- r co p Iq LO 0 O d o O o o CO T. Oo N o.- M co N d• to co T- LC) N ti to M OO CO r- O CO q9t O P- N r M to r- co M N O CA d' L 0 0 V to to W 0 0 0 OO CO O d 00 O co N N O j+ O 000 Mto OIl- 00 0CO ' M M O V p -0 O O O O ; 7 0 O 0 O 0 ' ' ' N co 5 v S T m ' i CO O C C CG C C S A CA O O O 0 N't M 00 tn ~M O O O Q a m 00 co co 0 Cp to CO W m O O I- 0 d to N N o0 M M 00 0 0 CO CO N f- O 0 M W ~ LO 0 P- M N 0 M ~ 0 to to t q N N co CO LC) Q O 0M o t 0N~r COM0tol-- to to N O N N P.: O r.: (fl to to to 00 r 00 CV CO r O 06 OO 0 OO C OD N~ M M co N ~ N a C O O C7 C T- LL W CC) CO d ' tt) r- w o o H : o O o 0 0 co dN Q C m N N c o rn 0 U M Z J N E N C NF d (6 Co W ti ~QO Q. E E X ~U~ W ~ U E Uo L o~ Q CU w o ° o Z a a~ O C ti ao 0~0N~N00Mr- 0000toCO O O CO N N OeF 0 d M 0c'totofl- MNOM. OLOCO M t t I to to 1 1 r M N ' o o t 0 N~ r 00 CO CO LO -T 00 co M O -O a q~i N ti 00 rl: CO to Ld 6 C V-: OO C NF V-: OO M M N & 0 > a NN CM LO) M co ~co CO ) 0 to 1* 0 cm N Q V X 0 CO M M " r O 0 I Z O U J a) d W o . CD f a 7 Z U c~ z a) N C Ct0 O h p) U ( 06 E 3 C M c>C W :3 U) V N N Of OtS C O 0 0 > 0 rn v; m w LL o ' w a) = CO U Ern ~ 0 CO CL w_- V 0 y °d rnv v `m y o V c m D, m a> 0).C c ca 0)m0`.- p o U o cl ° o O a z.~L ~}c-- to O , ZS . c x H -o N- W U 0) to Co N O> C - c t a? c a~ •H v cr N 3 L . a~ O D0~- W L C 0 ° - . . a ac m¢wF- a ~wQa:~O . Uz0 o d ~ m w z O Co tl- 0) U N N 0 co ~ C \f d CO 'Fa m 0 ~ ~ 00 Lo cC co O ti c a) ~ co a O M O o0 lll~ M M 00 00 Co Itt Co V- V C 00 M N r r O Co O -.~r O Co E M I~i Q C 00 O 00 O N N O N N I- LO N N Co CO N 0 LO I- Cfl O ct ~ Co I- 00 ~ w. LO0 LO LO 0 0 cT t,-00.-0r-N000LOMO~ C•M f-- c'MN Cl) N 00 C OO O 00 It 0 Co r, a)MCD 1-Cncn~0LO 0 gLO14'~It Co O 0 OM M It cn 1 NNd'NIr c6 1-C6 -I_000C6 C•Mcl 0000 ~i m L 00)CM cN r r NO CONNC'OCD - 04 N M M 0 E Q rt U M N 0 O O C7? 00 IT F- O O O Z C M ^ vw N M Lo NL O It _ *4 . + I 603 ~ 6H ^ O O CO V r- 4 C14 C-4 42p O 0 6 (5 V7 co o° M a) 2C o _O co Co ON > L- 0 CL O N Co L o coo p Ctoo - K> od U co 0~~~ ^N V m 4- w CU C) a C X00^0 ^ C14r- Nn N aNi O 3 ce) CD CO mZ c o 0 o°O~°p o~~c°p~q c c~ U ~o Q C o cu ti o , C~ v 0 c) 0 O co co C ~ U 3 W i CD Cco D ^N O o ~U CL N rn 0 ~ oc o~ o a^ M~' CD- m 3= Ei~~ v O Z a a ~ 0 rn N co O E J 7 N O N 69 0 0 0 C:3 CO ~ aI Q a. 0) CO (D Cr o~ N O to O 0 O a O M C C L- U) 0 ° U U CD - c""p co 'O - c N cu CU N co O O o 0) O N> O N O M 6g - 3 O C O O C3 U) O o Co >,C CU Co ' Co NCvm LO Q O N CD c o U O Ca e X N o co (C) O O N O 0 0 Co O m U N LC) '5 E - ti Cu d W U O d° j U N N O fn o o C p~ c a N C y~ O O O O` C-0 o U) N c`0 (0 °ZS O O w N_ O c w M O ~c o C Ca~ ~°d~rn°~~cr~ C Ca U o~ ccU3c2 E>, ' CL cc u, L a) ° °:r ca mQOmm j a C 2 QQQD =W=0 NM V LO f-co 0 c E 5) cu NM to O O CJ E E uS O ° a U 06 CA U N o +`U O U c0 E O ` C U N O rn rn N 0 > U U C fn N E w U Q C) C 4- V 0) C O U Q W m O W W Q Q cCi O O U U o o C ~ J J ° a H W E- O O ti "O C N O O U C 7 U O O Y O C 2 N 7 a. O U C M a) O C U a L C7I cn -0 a) C ~ 0 O O f6 ~ a) U a) O a N O. Co U O U) W O N W w CO N O CO ct CD CO to O N O O O N r-- (l9 CO rl- CO vm m LO0 co OM 00 O O co N 1.- N ' N N O ' N ' d' co O ' t co 'h ~ 't O ' O ' II- M V- M1~ ~t0 co It vN I~ v~ My Of, CO v g CO O O Ln O Cl) N CO ; ti N N ' N N r v v CO CO ((7 C 0)0)gq ~tmm0N0m0O0001~ WOO ONOO I- CO I- (OMttN ~OM0CO M000d 00~ NOO OOOCO CA N I~-oONO O'It NOCOCOOO'It d qTl 'It d'0 0001- CO r co N Cb O d' O rIct N O N 1` 0 CO L() h 0 O r LO O Co 4Y LO CO NCD 00 Il- O N O MO MOCM CO O~te- O 1~ C N[ tt q N I-- - M N N (O CO w LO co N (O o d O OMOON OCO Oil- 00 00Lo f~ 000Il- N ON co 00 0m OCo OO OOO rl- OOCD ~ (0 0It Co ON 0'I ' 0~ ' 00 OOCO O 000 O N ' 6 O06 O(7 11: - NO 6 SON Il OCOL()O M O O N Co t} (00 N O O d• O co N d• O of Nco It 0 N I~r O NCO Ul) (O M N (Cl M ~ O CD (O r O N I-- qt O O O 1,- CO O CO O O CO N 1` Co N M M 0 co Il- 'Ict m O O ~ (o CO - CO O CD co CO V* h CO r- N 0 co 0 1-. I~ 1l. co C)lqt 1~ M -"M~W0O-T 't COCON I (D CoN I* N M CO CO 06 w LC) C6 O N I, d CO M O O m CO e- ao OMI- com I- N O Oh M NO(A M O N M CO co N N CO M N m LO N r M O N (li l r 00 co qql Co 1-t N (D I- I It co co N N Ni I: N --i ~ o ( 0 CO ~CD N1-- I,- 0001-0mmLO0 00 N0 tt CN CD Co a I- M O LO ~ 0 M ~ M O CO 0 M r- CO r N O O N d' T- I,- 000ttI~ Nc-NO~000OItt 4CO CO LO Fl- O~~ (O ~ MCOCOCO01 MCO.1i 6 N1I 'i COO O OOCO co C4 OMIl- coM n N O Or- CO NCD00 O CO N CO O M N N (O co N I` O O ti M ((Y r N M r N U Cl) U O w (A C C13 p- y X U LL .y y O w U dS r;) Z a> IA rn a) E Fa D U N y 3 N c C N N > H ~ C N N p L ~ fA C LL w► d tA~m N rn Y~eo CL LL 'i W v ° o U > v}.° X E 3 U) U) rn ~ 0 M 1 3 0) j c a i U 0 o 0 m m CL _ CZS R c c y C9 o F- c8 rn v U o •y o C rn 4 O c w E o U Y o o m o L 0 „ . D, a) a) O C ~ cm cc ~v p CD a) U o cR k o•• (D z c m 't >cimoo L a Fn a._ o W na i -0 O i a i a O)w WL (D C F- ' U a? Q C w3v , 0 c 4 E O 7 N F- W C 2 0 CO a) a) O c a) CL u M<WF-0- ~SLLaCL w0M - ZDO ULL1- m LL F- S F- jy~ U Z G W D V Q W co Q N o W CO ~t O ~ j N LL Q 0 `0 Z U c 0. O O 7 x a- -C W c~v ~ J ~U-Z ~p rn ~ D a Q Z J W a O N O 14T 0 Co CO 0 Cn 0) a0 O 000) It co I,- CO 00 M f- O CO W 'T 0 M It O O It T- N fl- N' It O' N' It CO O' q* d co ' r- It O r- t0 T- M f` M 00 lq v N fl r f` r. O N 0 0 O W 0 t0 • • • ~t • v f\ Co O Cl) - M P` N N N N 0 r 00 tp (000(o 00 0 0 N CO 0 0 ~0 0 c0 0 0 00 0 0 co w Il- 00f` r 0MCD000O0o0'-* 00N NOON N f~00f~ 0t7No000000I'li ' c00cc diV 000 V MCnLf) M U) ~ 1'NCD Nr:r qc 0) tor- CO co 00 0 Co O CO N f- Co N 0 CO CM O M f1- !r f` N d• f` N It CO N CO T- 0 co of N C \f 0 N 0 N O00 Oil- OO O0 fl- f- N OCcOt0 O0 O00 OO O00 ti f~ t0 O N O N O"t , C" ' 0 0 ' O CO to ' V N ' O N to f.. ti ~ N O O N d• d• f-. Lo r-- co CO 0 Co N Co 0 CD 0 00 C N! 0 N M V) V) 01 M M M M C C Co 000f-C0000Cp00000M co co T- 0 I- Lo ~CO M~CO 0to CO00ICtCD 1I- C0 N N 0 ti f~ CO T-1 O C~ V- N M ~ CO O V) 't "t CO to It Nt cif o co co Nt 0 Co 00 ~ O N ~ .4 1- N Co Co 0 c U') m co 0 N N 0 ti 0 t 0 CVM M M co co M N N N co co 14, It N N CO O O IV IV N C \F ' ti f; CO MO 1-000f-- 00000000m 0 11• 0 T- I- d CC) f- r- CO M r 00 0 CO CO 00 d O 1~ CO N N 00 O ti0~0 N~NO~COOCO'-T VM0 t f- r- M M co d w m co It O CV rl: O O N d' co 0 0 N 0 0 0 t N 0 N 0 0 0 0 N co co M 1 1 N r O U v U ~ N U 01 R U Z a) U w O c o U _ ad c 3 uj D) to U) a) c> 0 c N 0 E H m c N N' V N N ~ °tS ~ jCc t0 V d L O co L 3 tq y V c L W N w c v 0 U j O 2 -0 2 W a) 3 U E a j R o. R n c 0 ~ 0) ~ ots 0 m~ Q o2 ) EU 73 c e u i o we c c c rnw G m a) 'C 0 OU m a)Ta . x dc am~ m c a) Z 0 c ~`ta):r=o 00 c'ts CL W O ` va)~~ W a)ocmm~?NyvcwH =mc~H eo W o aa)) 0 x co<LU L5 ~ILQdO az o p d OG co IL 5 E- W U F- Z 00 ' O 00 O O ' ' r N U C O C O O N O N N LO N ti (0 0 ~ ~ m O ' O CO O d NN N CO V O _ +r C O V Lo N f- co CO 0 M 70 N N 0 0 O E r N Q c a) , co Cl -O 00 - O O O LO CO CA LO M O 1- Cfl O O Il- CO (fl CD N 0 0 M 0MM0 e-000rl-r~N0MM M 0 M O CO E C OO (n O CO I C) 0M~00LO CD 00Ar M0T-N 00 00 =3 O NI, Lo r O CO O LO r C ~ e-NCfl 00M1"O~1-: OvN Cl) r r 00 In O M CO CO E E Q N N O N N 0 N O N U co ~ CD Co CD 't LO Z W C cNi M Cl CN Sri Lx~ 00 ~ 6NR _ - O N p p .H O ~ `F- ~ CC C) M N 0 M O _ p O co ~O N M to- 0 CO ^N « d0' O o UFO c _ 69v O ~~N U9, 0 O Z CO °Q c O 69 Q O 00 O O 0 w- cfl c c c U) a e ° S C i LO-'t V7 >z a U) cc " o E ~It0 o X00 V w cr) 0- m o FLqNM~t 0Z, 50 O d Z (D 00 p . d E 7 CO p O nj 69 -m c " m m U Q a O 603, o N N ° 69 a) awi 3 ~ m o ,jr N o o>1 rn v o c6 ~ cm 0 C7 06 \ m'N rn ~ N M 2 O _ CD O M O C O _ L N L C :0 - 0 0 Q 0 z X o ~ N c a O o It v 0 - L O O cr co a) ~ ~00 v L~~ ~ a) ° W ~ 0 rn a~C:'9t cmc O O U) 0 5 o CC m Mod ~Eogo 3 ~U C;) c o U O c rn ~a N ~ n oW • E ':^g U ~ a) O O o w.CT' a ov 0 = c U ~ L O 'L U) CL c _ ~ ~ V 0 5 vJ 5 L Q U Q LL0Z) w C E ` H E O CD NMLO 0000O fOr'N0r` ~e-r-.-c-e-e-N O O c E _ E vi o c O ~ p ` E w . , fn U c V cc c U V a) a E > ; U U N = Q ,E O C U E E Q O W I W Q Q t C C O C W + E a) U UU 0) a o a o J J m a F- W O .0 C O 7 _ ~LL O C ~N O ~ O U CL U) 0 c ~ a C L L 0 Z 0 w V OC O U) w Ix 0 CA 00~0G) MOco Itv 0A)rNN II,O~N~t00 CO t` N t0 N 0 O O M O O O 0 0 r ' O Co d ti to fl- Nr N O Or- N co T- N M ~ Go 0 N e- CO d cM f` CO 0 O 1 lr~ M M O O r r N N ~ I- C)m N N N N ti I- O O O O O O In lf) ti ti LO LO 00 0 C V d' N N N Ln N O O N O O O N O Ln vi to V-: M r N c- N O O 0 Co CD O O O 000 cn Ln O co O N N Ln N N co ' NI~ CO Nf IO O to cn o o~ c c LL LL ~ ~ C L c p , (6 C L L ~ tV N 5 19 L F- LLSH O O , aS CS N N N N L X LL 06 U) ad N c`Da v E W LL 'C 3 v H ~ ~ ~ 0 N 2 O B 0 W i O O. a E cri U X U ' N LO 0 Ln N N N L .C L LL U O- C mE p uDi U 25W Ow LL ~Uv 06 N L N E 2 L a tp C fT y O ~j w 0 LL LL N I Its Ln ti N et 0 0 Cl 0 0 0 N M 0 0 0 0 0 0 0 1 0 0 0 0 0 0 M N Ld Ln0L0 1- O ~tNtO~MM N ~ N 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 O ' LA O Ln O L O t0 tD N r 0 w T r- N co co W 0 ' CO CO co N CO N r r 0 N 4 V- 0 N N r r M M M M ' er r` ti 0 w 0) w 0 to 0 14 ti N N If O O N V r r C t0 to ~ m O E w > m 0 L n E E ca O E 2 w r0 N R y O 5' in to 0 fZ 03 Cl) m O rn to rn V O C O C CL N (a ~co Mmw~UF°- f- tY 7 C d t?. k w ttl H d Z H Z oW ~F- c - o p o U N 0-00 a c U - w Cc U Z o 9 U) 3 a m Z ~U Z w 0 O c CO v a~ c6 cc o~i 0) m LO LO ca ~ ~ d a; O E c a) I ce) 00 I M co E c o co O E CO 0) ( CY) Q cm a) U c O a E r a~ p c! 2 m a O v ca O c N U C C O N N a`> C N U O U O y r r Gr O C O N U C) C ~ D C U ~ L m 'V L a) ~ E m a) H d O U V/ d MO e- Cfl~tOrn ;:I Mrn V M 0 N MO 0 M0Q- OOH N 0 LO O ' .-O ' 0 CAVOIl ' OOCOO ' - - M r- O N Iq C) (M v 00 N V' M v 00 co 1` LO O 00 N N v r- COOMOO 07 W V C)MMNMMO V 0) a) f-- Oco 0CD CD MWC)-COMM.-ON 0 0 O O - O O T- 0 V O f-- M 0 0 0 O l M N CA N 0 00 ~ ~ O CO LO C i to ~ N V C'f- O r M ~ N 000 c o 000 M-0 O CO O 000 0 0 000 0000 O M LO 0 0 0 0 0 0 0 0 ' M N O ' O' r- M O c s; L P O N lA O CO N LO U') N C0 LO ~ N 03 .G COOM0~ CD Odt00N-CD ON V, I- O N f`OMON co (OO - OMN - CMN - CA - CAO.-OM lnlqOrlMNMCL ~--00 0 MONN00 00 N000O00LOC)NMr-LO Cn LO N C co N O N N N C) 0 CD 0) LO It CA M N r COOC'MO- O O~OON~-COtAN~ 1~ 0 N f*- O CM O N M f- CO CCU CO p CV M N r- 0) f- OOe-OCM et CA V COI~MNMO e-00 -0 Cn O N N 00 00 N 00 N 00 M O N CO LO r- N O CC') N st h N -0 v C %i O - N N N W V OC O N W w w y U U c Ca 7 O H C ~ a) m y N 3 V C C Y - > c C r- C m CL .2 3 C O O cm 2 o Y B Lu 'o J(AH-O cH 0 NO N 0 co ' O C O 0 U') M N C~ C) 0 O O O O O O ' ~ ' O O O O I- I~t _ Cn - r*- O N CD Cl N N 0 O ' 0 co 0 0 0 N O O M N N N 0A 11 O p ' I LO 0 d M r r r co r C* 0 W) tn L L v O O M M co co Go co p 0 co o d' ~ ' !C Of M ~ co m o 0 CO co 00 T- IrZ L E 0 a U O o rn t~'o Z Co :3 Co prn to C/) U Q 0) y U O ~atS 7 Z~ a)O W 65 E OC 4) Co 76 (D 0) C c d U ~ ea m a) ea C y m ac~i c c c d rn y w v U V 0 12 O Z i- L C t 0) 76 C': CA w aa) _ 0 O>+ w w C;) CD W ~QW WJCL_LLCLQUUf- C 0A 7 LL U OU)X ,2MW cod ti Fo d Z U a) O C CL i O N .a Ca m M M r- Cn Cn Efl U O OIL Y N U r O CD O C U- 0 U C O ~ C Y O O O °o_ a N 'O Ch > O 69 O_ y C _ L w 3 O a) O U 7 C _ CC > N O Y m 0 U U C 0 O O y Cl) rn M O C'4 W 603, O -N U U) C t .LO O CO to co UyM O H D N Q noCD c a) N m 0 cm L O LO d' .O C 7 LL L c H a~ Uw a~iH O 4) N ~Uo N Cl) Z c v Q ~ 0 W 0) O L :U m ~ U- .r cU OZ Lu H N O U CD U) LOM co N00 M M U 'IT A M MO V- V) 0 C 0 M C LO Kt m 7 M C \F C cri N M O O 00 m ~ O i M ~ LO O Cn CO O O Cp ~ CO 00 Cl) ~ CO tt M a Itf O O CNN O C rl- M M O CO r- 0 E Q c 00 O 0000 000 CA CO co Cfl ) 00 0 V)(D00 Of*- CAM M c OO O MCACD O u1 rn It 0) a) pl- _ C~ ~ NEO N 04 q ~ (3i 1-7 E E v - 04 M 0 Q m O r r M U N a CO N x fCf 3 N N U O Y w c O C .5 O C O- Cc O L N rn O.0 Cv~~ U) CU 6 3 ~ V 0) o L-: O. C 7 O a) to CO N 0 ~ Z n C_ c = aL i In O O O U U C O V v cv m N O C c 0) O i U 0 O N ` a E cm V O O V N O CO d C C C a U O . a N V N C 5 (D U C C CAS - Q~ LU -jU)< U LL~ t)~ O: 7 0 0 - w N M CU 0 c 0 ~ (D Q) L L L O + L y N N W O O 0 'O In C C 0I C = V U U U O O CO c c `~c to c c N (a CO UU ~ _ Ca c c c c ca 0 aa U •r (L Q. UQ I Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of June 30, 2010 G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through June 30, 2010 Balance Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order #1 Change Order #2 Change Order #3 Total Paid through June 30, 2010 Balance Closure Fund Projects Fund 611 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 - 19,656.00 261,525.00 182,516.00 444,041.00 254,413.43 153,904.43 408,317.86 7,111.57 28,611.57 35,723.14 2,097,140.50 3,290,779.98 5,387,920.48 - 45,094.00 45,094.00 - 14,302.54 14,302.54 - 24,885.69 24,885.69 2,097,140.50 3,375,062.21 5,472,202.71 1,707,132.00 2,054,537.51 3,761,669.51 390,008.50 1,320,524.70 1,710,533.20 Total of Engineering & Construction Contracts Original Contracts 2,339,009.50 3,473,295.98 5,812,305.48 Change Orders 19,656.00 84,282.23 103,938.23 Total 2,358,665.50 3,557,578.21 5,916,243.71 Paid through June 30, 2010 1,961,545.43 2,208,441.94 4,169,987.37 Balance 397,120.07 1,349,136.27 1, 746, 256.34 Notes: a) Additional landfill gas investigation per DEQ as part of a requirement to address offsite landfill gas migration. b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678 has been expended and reported as "Construction in Progress" on the County's CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction, Taylor NW, KN EX Co, Jack Robinson & Sons. c) To date in FY 2010, payment has been made to Central Electric Co-op: $13,311 for the Closure of Area A and $20,822 for Cell 5. RV Park (Fund 601) Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 50,000 $ 2,431 $ (47,569) 100% n/a $ 50,000 $ 2,431 $ (47,569) Revenues RV Park Fees < 31 Days 158,580 96,572 (62,008) 100% 61% a) 158,580 96,572 (62,008) RV Park Fees > 30 Days - 10,710 10,710 100% n/a a) - 10,710 10,710 Restitution - 3,643 3,643 100% n/a - 3,643 3,643 Washer / Dryer 800 948 148 100% 118% 800 948 148 Vending Machines - 450 450 100% n/a - 450 450 City of Redmond - 500 500 100% n/a - 500 500 Room Tax Collection Fee 500 500 100% n/a - 500 500 Interest on Investments 300 326 26 100% 109% 300 326 26 Cancellation Fees - 1,803 1,803 100% n/a - 1,803 1,803 Total Revenues 159,680 115,453 (44,228) 100% 72% 159,680 115,453 (44,227) Transfers In-Fund 130 190,000 190,000 - 100% 100% 190,000 190,000 - TOTAL RESOURCES 399,680 307,884 (91,797) 100% 77% 399,680 307,884 (91,796) REQUIREMENTS: Exp. Expenditures Materials & Services 83,760 80,732 3,028 100% 96% 83,760 80,732 3,028 Debt Service 242,571 242,571 0 100% 100% 242,571 242,571 - Contingency 73,349 - 73,349 100% n/a 73,349 - 73,349 TOTAL REQUIREMENTS 399,680 323,302 76,378 100% 81% 399,680 323,303 76,377 NET (Resources - Requirements) - (15,419) (15,419) - (15,419) (15,419) Beg NWC per Adopted Budget 15,000 15,000 a) Approximately 3,353 space rentals. ( $96,572+ $10,710) / $32 = 3,353) -0 0 0 0 0 0 0 0 0 0 0 0 0 0 O~00N~0r`0LO 00~P~ r`000'tT00NNr ~00CD to v-O W O N O N N M W O O W N - N ri) N RC N LOM0MOI-~Itm0mCOM 4 CUM r LO 00 T O r` Co 0 LO N M 0 t- MNM NNNtDM N a 0 (L M > W CU Lj- 0 N *k LL cDIct Nt It 00 NT 0000 N N w N ' ` M N 00 ti Ln 00 CD N t` Ln O 0 N m 00 Wqt 0000NM0LO ~MMN d 4) N 1 00 O N cV N CA 00 P- O ~ r N~ r- NO \0 \o \o \o \o \°0R \o0\00 0 0 0 0 0 0 0 0 0 0 U 0 00 1 V CD 0 00 cM LO ~ N It M Co 00 0) 00 CO It LO ~ N LO I- CO 0 OL 4000L6 ~0004 r-~ CDNI-: U r- N 0 N O 0 0- r LL N CD 0 O N OCOq* N.-MOqt 00~00 ' C C ~ O U C7 M 0 ` 0~ CO0MMLO d MNNN ~MN~- ~NNt`~ O L CO 00 0 N CL 07 N L U) 0 O O N ~C N N C } LL LL CL m > O- O - N qct CD NT N co 00 00 00 It N co N V LO d'0d M~ONCOIt(DMM ' V C O V) C M~O~- COqt (O~ gCD 000 0 0. Ln oS co 1-: v r1 rl C r~: C >LL N00 0) a -0 Co U Co :3 3 to O O o 80, 0 0 0 0 0 0 0 0 0 0 o m C N co r• d' ti M Co 0 O r- CO LO 0) O Q)= > O ~CDc-rrOd~OLngctCl) II f0 U OL r-: 6 00N~00r-N0~001 N O MN 7 U > 69 O O ~ N N o 0 rn U O 00 } p OL U LL cp C6 U) cn 04 000001.- LoMNr-N0(O QLO 0'a `M e M ~Mp N 1 O N~ p 0 ca 2 CU 4 00( )cocoo C Mc c O N N C am M 7-0 0 O~ ~ O C`>> LL O m c p k LL p N O O ~ M co CO N O CD ~ co ct (0 0 ' 0 N o O a) ~ Mc M~ qt 00c'M00LnNC'Or-00M 00 U00 LL OOMN~ ~t0CD CD 0IRT 0 M CL N0 of 00 06 N CV O 1 O - II Y MN ~~N NCO NM (0 ' d (o 0 (1)~ ~Ul CD cn U 0 M 0) N O 3+ O O N E y 9.- r M u (9 O > Q N U = CU O O co y C C O N 6 L v7 U j E O O a) E E ca 4.1 cD to O : O m y V j 0 U O(DM p, cc j d Q-~Qf)OZ0~LLmQm~>0 ^ Building Services - 620 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 272,938 $ 439,838 $ 166,900 100% Revenues Cleaning/Maintenance 85,475 61,643 (23,832) 100% Utility Reimbursement 9,000 8,102 (898) 100% Facilities Charge to State 136,464 183,693 47,229 100% Miscellaneous - 63 63 100% Interest on Investments 10,000 5,934 (4,066) 100% Building Svcs Indirect Chgs 1,745,275 1,745,275 - 100% Total Revenues 1,986,214 2,004,711 18,497 100% Transfers In 222,844 186,844 (36,000) 100% TOTAL RESOURCES 2,481,996 2,631,393 149,397 100% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS n/a 72% 90% 135% n/a 59% 100% 101% 84% 106% Exp. 1,554,315 1,510,151 44,164 100% 97% 799,681 748,334 51,347 100% 94% 36,000 - 36,000 100% 0% 92,000 - 92,000 100% 0% 2,481,996 2,258,486 223,510 100% 91% NET (Resources - Requirements) - 372,907 372,907 Beginning NWC per Adopted Budget 310,000 Admin Services - 625 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. /01 RESOURCES: Beg. Net Working Capital $ 120,000 $ 117,586 $ (2,414) 100% Revenues Miscellaneous - 81 81 100% Interest on Investments 4,000 1,680 (2,320) 100% Admin Dept Indirect Chgs 692,295 692,041 (254) 100% Total Revenues 696,295 693,802 (2,493) 100% Transfers In-General Fund 40,000 40,000 - 100% TOTAL RESOURCES 856,295 851,388 (4,907) 100% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS n/a n/a 42% 100% 100% 100% 99% Exp. 640,536 640,355 181 100% 100% 148,443 147,799 644 100% 100% 100 - 100 100% 0% 67,216 - 67,216 100% 0% 856,295 788,155 68,140 100% 92% NET (Resources - Requirements) - 63,233 63,233 Beginning NWC per Adopted Budget 1' 20 ,000 BOCC - 628 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 RESOURCES: Beg. Net Working Capital Revenues Sale Map Photo or Copies Interest on Investments Admin Dept Indirect Chgs TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Budget Actual Variance FY % Coll. % $ 50,000 $ 68,511 $ 18,511 100% n/a 100 69 (32) 100% n/a 500 1,263 763 100% n/a 573,417 573,207 (210) 100% 100% 624,017 643,049 19,033 100% 103% Exp. 490,156 488,305 1,851 100% 100% 74,247 58,244 16,003 100% 78% 100 - 100 100% 0% 59,514 - 59,514 100% 0% 624,017 546,550 77,467 100% 88% NET (Resources - Requirements) - 96,499 96,500 Beginning NWC per Adopted Budget 100,000 Finance - 630 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 740,000 $ 777,692 $ 37,692 100% n/a Revenues Investment Fee 95,000 81,828 (13,172) 100% 86% Photo copies - 47 47 100% n/a Interest on Investments 18,000 8,277 (9,723) 100% 46% Interfund Contracts 28,000 28,000 - 100% 100% Administrative Fee 12,000 12,000 - 100% 100% Finance Dept Indirect Chgs 716,422 716,161 (261) 100% 100% Total Revenues 869,422 846,314 (23,108) 100% 97% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 1,609,422 1,624,006 14,584 100% 101% Exp. 834,911 833,369 1,542 100% 100% 354,486 222,153 132,333 100% 63% 80,000 - 80,000 100% 0% 340,025 - 340,025 100% 0% TOTAL REQUIREMENTS 1,609,422 1,055,522 553,900 100% 66% NET (Resources - Requirements) - 568,484 568,484 Beginning NWC per Adopted Budget 500,000 Legal-640 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 87,000 $ 102,125 $ 15,125 100% n/a Revenues Sale Map Photo or Copies 300 54 (246) 100% 18% Miscellaneous 3,000 32,222 29,222 100% 1074% a) Interest on Investments 1,500 1,619 119 100% 108% Interfund Contract 2,000 10,846 8,846 100% 542% b) Legal Counsel Indirect Chgs 699,907 699,907 - 100% 100% Total Revenues 706,707 744,648 37,941 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 793,707 846,773 53,066 100% 107% Exp. 679,034 677,691 1,343 100% 100% 54,252 43,186 11,066 100% 80% 100 - 100 100% 0% 60,321 - 60,321 100% 0% 793,707 720,877 72,830 100% 91% NET (Resources - Requirements) - 125,896 125,896 Beginning NWC per Adopted Budget 90,000 a) Charges to 911. b) Contract with DA's office for Steve Griffin Personnel - 650 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 360,525 $ 423,562 $ 63,037 100% n/a Revenues Miscellaneous 500 1,064 564 100% 213% Interest on Investments 4,000 5,198 1,198 100% 130% Personnel Indirect Chgs 632,941 631,069 (1,872) 100% 100% Total Revenues 637,441 637,330 (111) 100% 100% TOTAL RESOURCES 997,966 1,060,893 62,927 REQUIREMENTS: Exp. Expenditures Personal Services 583,859 569,669 14,190 100% 98% Materials and Services 336,007 139,466 196,541 100% 42% Capital Outlay 100 - 100 100% 0% Contingency 78,000 - 78,000 100% 0% TOTAL REQUIREMENTS 997,966 709,134 288,832 100% 71% NET (Resources - Requirements) - 351,758 351,758 Beginning NWC per Adopted Budget 290,000 Information Tech - 660 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 437,214 $ 538,155 $ 100,941 100% n/a Revenues City of Redmond - 14,310 14,310 100% n/a Miscellaneous 1,000 189 (811) 100% 19% Interest on Investments 12,000 7,184 (4,816) 100% 60% Leases - 12,222 12,222 100% n/a I T Indirect Chgs 1,910,076 1,910,076 - 100% 100% Total Revenue 1,923,076 1,943,980 20,904 100% 101% Transfers In-General Fund 65,001 65,001 - 100% 100% TOTAL RESOURCES 2,425,291 2,547,136 121,845 100% 105% REQUIREMENTS: Exp. Expenditures Personal Services 1,729,580 1,717,735 11,845 100% 99% Materials and Services 502,227 342,352 159,875 100% 68% Capital Outlay 100 - 100 100% 0% Contingency 193,384 - 193,384 100% 0% TOTAL REQUIREMENTS 2,425,291 2,060,087 365,204 100% 85% NET (Resources - Requirements) - 487,049 487,049 Beginning NWC per Adopted Budget 435,000 IT Reserve - 661 Statement of Financial Operating Data Year Ended June 30, 2010 PRELIMINARY AS OF 7/20/2010 RESOURCES: Beg. Net Working Capital Revenues Interest IT Reserve Charges Transfer In-General Fund Total Revenue TOTAL RESOURCES REQUIREMENTS: Expenditures Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS Budget Actual Variance FY % Coll. $ 350,938 $ 373,691 $ 22,753 100% n/a 2,000 5,504 3,504 100% 275% 234,000 234,000 - 100% 100% - 90,000 90,000 100% 100% 236,000 329,504 93,504 100% 101% 586,938 703,195 116,257 100% 104% Exp. 489,990 447,835 42,155 100% 91% 106,000 43,001 62,999 100% 41% 80,948 - 80,948 100% 0% 676,938 490,835 186,103 100% 73% NET (Resources - Requirements) (90,000) 212,360 302,360 Beginning NWC per Adopted Budget 161,896 Page 1 of 2 Marty Wynne From: Mark_S_Hudspeth@KeyBank.com Sent: Monday, July 26, 2010 9:16 AM Subje : KeyBank - Indicative CD Rates 1 YEAR- 0.05 1.5 years- 0.08 years - 0.17 3 years - 0.50 Please call or email us for specific rate quote _ Mark Hudspeth - 503-790-7682 - mark s_hudspeth@keybank.com Melissa Greenough - Toll Free: 1-866- 878-1235 / Direct: 425-709-4545 - melissa_greenough@keybank.com Listed above are current indicate rates for our CDs. Interest rates may vary from day to day and on the CD size. The daily deadline for purchasing Certificates of Deposit is 3:00 p.m. EST. Mark S. Hudspeth KeyBank 1211 SW 5th Avenue, Suite 400 Portland, OR 97202 Ph. 503-790-7682 Fax 503-790-7574 Email mark_s_hudspeth@keybank.com Email Classification: KeyCorp Public This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material-in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 7/26/2010 Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2010 PRELIMINARY, as of 7/23/2010 - Additional FY 2010 Revenues and Expenditures WILL BE recorded Fund # Fund Name BUDGETED ACTUAL Difference Contingency Res for Future Ex Unappropriated' OPERATNG FUNDS 001 ~ General 8,300,000 9,633,457.87 1,333,458 ! 7,482,774 - 701 Law Enforcement-County 4,722,862 5,620,060.33 897,198 - - 705 Des Co 911 5,861,335 6,484,136.93 ! 622,802 6,524,4$3 - 675 Health Benefits Trust 16,400,000 16,988,139.69 588,140 12,965,479 - 702 Law Enforcement-Rural 1,905,939 2,356,082.41 450,143 - - 220 j Comm on Child & Fam 562,762 841,831.41 279,069 408,554 - 259 'Health 1,100,000 1,343,237.96 243,238 761,568 - 142 General County Projects 1,210,000 1,40 183.051 197,183 1,681,831 - 355 ; Adult P & P 616,371 735,699.14 119,328 441,641 - 215 Law Library 150,000 254,383.28 104,383 182,474 1 - 630 Finance 500,000 568,179.77 68,180 308,486 1 - 350 Do Control 133,711 198,215.53 64,505 44,699 25,000 327 Forest Title III 515,592 577,575.52 61,984 408,200 1 - 650 ; Personnel 290,000 351,451.98 ! 61,452 ! 81,000 - 620 Building Services 310,000 370,224.42 60,224 209,683 - 661 Citrix 161,896 212,359.54 50,464 - 199,896 - 660 Information Tech 435,000 484,763.44 49,763 203,511 - 105 Business Loan 75,000 119,736.15 44,736 I - - 280 , OHP-CDO 528,000 1 572,377.83 44,3781 275,1961 - 706 1 911 New Facility Property 370,939 408,693.48 1 37,754 640 Legal 90,000 125,671.04 1 35,671 67,500 - 329 Public Land Corner 990,401 1,025,419.191 35,018 721,001 - 270 ABHA 3,014,373 3,045,125.05 30,7521 2,076,2081 - 305 GIS Dedicated 348,000 378,298.50 30,299 53,000 116,672 115 ! Crime Prevention Services - 28,722.57 28,723 123 ! Justice Courts 145,000 173,478.20 28,478 ! 59,116 - 720 Extension 4-H 282,176 305,408.61 23,233 141,970 1 - 255 Sheriffs Office - 19,742.22 19,742: 5,632,690 - 260 HealthyStart 550,000 561,250.75 11,251 L 386,936 1 - 165 ! Video Lottery 30,000 37,226.33 7,226 42,914 618 Fair & Expo Center 2,809 9,756.45: 6,947 137,848 ! - 240 Court Security - ! 5,212.79 1 5,213 - 1 - 208 ] Liquor Enforcement 10,000 14,708.21 4,708 1 12,818 - 245 DC Communication System 85,000 87,574.88 2,575 89,813 - 143 ; General Capital Reserve 1,084,000 1,086,105.09 2,105 - 589,300 - 212 ; Victims' Assistance 74,000 75,878.32 1 1,878 1 35,088 - 145 ! County School - 199.78 1 200 - - 200 Industrial Development 45,000 44,578.96 1 (421)! 11,452 - 235 Asset Forfeiture 25,000 24,478.37 ! (522)1 25,9171 - 328 Surveyor 2,665 j 1,173.54 1,491)1 2,665 ! - 628 BOCC 100,000 95,213.66 ! (4,786)1 27,129 1 - 610 Solid Waste 392,509 387,006.31 (5,503)1 798,256 1 - 619 1 Deschutes County Fair - (17,354.46)' 17,354 ! 86,603 - 330 ; Road Building & Equip 558,304 540,712.00 ' (17,592) 1 492,297 - 230 Juvenile 987,000 965,722.68 (21,277)1 621,106 - 218 Clerk's Records 332,491 306,814.18 (25,677) 330,341 - 601 RV Park 1 15,000 1 (16,375.33) (31,375) 24,190 - 276 Acute Care Services 1,001,701 969,703.87: (31,997) 921,844 : - 340 (Vehicle Maint & Res 1,048,257 I 1,012,668.01 (35,589) - 1,024,557 - 670 1nnsurance 2,500,000 2,460,108.56 (39,891) 2,346,473 - 625 ;Administrative Services 120,000 1 61,236.901 (58,763) 80,628 - 297 Newberry Neighborhood 505,793 443,826.45: (61,967) 86,960 11 185,000 275 Mental Health 2,616,050 j 2,551,766.18 ! (6 284)1 1,891,454 - 295 CDD 686,081 612,736.45 (73,345)1 259,385 1 - 205 Land Sale Maintenance 197,000 116,150.59 (80,849) 1 103,945 - 325 Road 1 3,430,429 i 3,308,308.65 (122,120) 2,036,412 - 326 1Natural Resource Protection 58,747 (118,523.32) (177,270) 1 42,027 ; - i i 1 1 7/23/2010 I Deschutes County and CSDs Comparison of Actual and Budgeted Beginning Net Working Capital July 1, 2010 PRELIMINARY, as of 7123/2010 - Additional FY 2010 Revenues and Expenditures WILL BE recorded Fund # I Fund Name CAPITAL PROJECT FUNDS 430 Local Impr District 456 !Jail Construction 457 Jamison Aco & Remodel 613 (Solid Waste Cap Projects 1 DEBT SERVICE FUNDS 5211 3 2005 (U S Bank) 524 I LID 2007 (ROTC) 525 LID 2009 BOTC) 530 CDD Bldg DS 535 Full Faith & Credit 2003 536 ! Full Faith & Credit 2005 538 , Full Faith & Credit 2007 539 Full Faith & Credit 2008 540 HHS/BJCC DS 541 Full Faith & Credict, 2010 560 Public Safety DS 575 PERS D/S 590 Fairgrounds DS 731 Bend Library DS 741 1 Redmond Libra DS 751 1 Sunriver Library DS OHTER FUNDS 120 ' Grant Projects 125 ' La Pine Industrial 128 Bethlehem Inn 130 Park Acquisition & Devel 132 Park Development Fees 150 Special Transportation 155 'Taylor Grazing 160 Transient Room Tax 170 Welcome Center 290 Code Abatement 296 1 CDD-TDC RESERVE FUNDS 111 Court Technology Reserve 114 A & T Reserve 135 PERS Reserve 140 Project Development 261 Health Department Reserve 335 Road Improvement Res 336 Countywide Trans SDC 611 Landfill Closure 612 Landfill Postclosure 614 !Solid Waste Equip Res 615 Solid Waste Enviro Remed 617 Fair & Expo Center Reserve 703 LED County Capital Reserve 704 LED Rural Capital Reserve 710 Des Co 911 - Equip Res 721 j Extension 4-H Bldg Res I Total ,GETED ACTUAL Difference 218,949 214,336.23 (4,613; 580,000 578,012.20 (1,988; 535,574 1,924,106.80 ! 1,388,533 1,000,000 1,166,888.65 ! 166,889 170,000 1,373,730.80 1,203,731 759,834 1,080,618.56 320,785 1 - 319.49 319 - 27,173.30 27,173 - 7,414.89 7,415 15,900 16,003.65 104 50,900 I 63,805.48 j 12,905 3,300 1 3,935.60 636 - 235.72 236 309,000 ' 309,939.23 939 10,8001 9,459.44: (1,341 200,000 332,390.32 132,390 120,000 119,887.181 (113 100,000 1 260,234.58 160,235 60,000 128,326.26. 68,326 10,000 j 28,186.19 18,186 8,000 13,427.95 5,428 - 15,421.43 15,421 - 950.66 951 2,725,000)4 (2,722,509.91) 2,490 - 9,618.771 9,619 119,000 119,423.16 423 50,000 1 377,510.25 327,510 9,500 8,914.52 (585 - 1,695.61 1,696 - 965.78 966 95,8001 94,919.81 (880 207,338 1 291,359.81 84,022 I I _ 9 a67 11 . 9 Fin? 12,200,000 1 12,481,623.94 281,624 2,800,000 2,842,790.95 42,791 518,532 517,541.25 i (991 12,040 12,027.33 13 181,957 212,238.801 30,282 1.081.221 1.567, 871.15 1 486.650 320,0001 335,194.03 15,194 953,180 959,000.05 5,820 942,085 947,676.97 5,592 1,278,000 1,021,733.86 (256,266 75,100 75,347.34 247 I 97,376.00 100,569,190.43 9,371,814 I i 221,466 590,047 - I - I - I 110,438 184,957 30,430 Future 192,100 3,218,900 1,923,206 458,482 10,200 306,221 115.772 1 53,014 15,100 15,000 38,396 1,400 511,000 10,300 39,057 150,000 120,000 100,000 139 7/23/2010 GENERALFUND Statement of Financial Operating Data Twelve Months Ended June 30, 2010 PRELIMINARY as of 7/23/2010 RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Grant Projects Non-Departmental Contingency Annual Actual Projection Actual;vs. Budget 30-Jun-10 31-May-10 May _Projection $ 6,050,000 $ 6,775,995 $ 6,775,995 19,822,847 21,289,179 21,116,939 2,921,462 3,150,964 2,921,462 820,704 847,684 848,204 1,043,171 1,599,757 1,552,066 13,791 14,432 14,432 332,800 332,606 384,185 187,049 194,914 197,827 70,192 70,154 63,871 86,450 98,370 86,450 2,000 2,000 2,000 25,300,466 27,600,061 27,187,436 172,240 229,502 (520) 47,691 0 (51,579) (2,913) 6,283 11,920 412,625 31,350,466 34,376,056 33,963,431 412,625 3,290,631 3,082,496 3,157,631 (75,135) 1,460, 704 1,301,868 1,293,000 8,868 60,358 59,883 59,714 169 4,622,263 4,580,459 4,587,263 (6,804) 755,971 747,699 755,971 (8,272) 234,222 234,030 233,701 329 239,685 238,431 239,685 (1,254) 105,673 103,728 105,673 (1,945) 1,613,006 1,423,351 1,483,006 (59,655) 5,515,042 - - _ 17,897,555 11,771,944 11,915,644 (143,700) Transfers Out 13,046,911 12,960,911 13,046,911 (86,000) TOTAL REQUIREMENTS 30,944,466 24,732,855 24,962,555 (229,700) NET (Resources - Requirements) 406,000 9,6431201 9,000,876 642,325 Beginning NWC per Adopted Budget 8,300,000 OO~OOOf~~f~Otc")MOtnCp~00 O O N MO1l- 0~,T ~1- 000COr-~nOO0OO O to LnOa0tAa0aoOInNOOMCL)CO~r-NO O N L- OOf~OM000001~~00000000Nf~0 O O v0W-019t 1 0 00000 ENO N LO to D T- to rn cM (fl T-~ rn cfl u6 t r O ~N N ~M CD M Q N m aj ~-C) 0r-V CMOtnMOLO C0It 0000 O 7r -O o I~ O W q 7 ti M O CO r- In 0 O U') O O O O CO C It 000-000It ~OONCOO~V- OOOO 11 tC W M CD 00 00 N 0 0 00 0 00 N 00 0 0 0 co ` 1qN C ) ) v m O v v f- O V N M O N O O m C) U a rnti1mr:rnN C4 06 NL6 r1~Om O Q } (M N (0 r- 0) 0) 04 M O O - v v LO r O M W l p C 0 0 0 0 0 0 0 0 0 00 O O O O O m , N 0 0 0 0 0 0 0 0 0 00 O O O O O ` 00000000 O v 0000 O CV O tT to 0 0 CM 0 0 0 Un 0 0. 0 0 0 O to d c ' 0 0 O O O CA V In LO 0o O O O O IV M C= Q m r NOOLOtoON L6 C4 InLnti O 00 M N (D r- M O V X ~ N ~ IT N O ~ N V LL x d ` w/ Y _ O vv U) CA c (a CL cn W W • ~ y r o w` O to A ^ ` , (D W 'EL C O N W N 1 U rn m p S ~LLZ x `VU O co O C C rn~ crf U Q O U) O N i 0 c c .j U rn t7) H O 0 m O N N L- 0 O C 0) > or W O~ W c o E W H c c c O , t p H m , CO) LL LL L N C C = LL O C N~ N O Lm- 0 0 N U M 0) O O J C Q ~ N O O 0 J A a s Q . .Q E «s w m O M C O p to 2) m fn J-1 -71< -mow LLD C C~~CAfn 0 H Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of June 30, 2010 G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through June 30, 2010 Balance Construction Contract M A DeAtley Construction Inc Original Contract Change Orders: Change Order #1 Change Order #2 Change Order #3 Change Order #4 Change Order #5 Change Order #6 Total Paid through June 30, 2010 Balance "Area A" Closure Fund Projects Fund 611 613 Total 241,869.00 182,516.00 424,385.00 19,656.00 - 19,656.00 261,525.00 182,516.00 444,041.00 254,413.43 153,904.43 408,317.86 7,111.57 28, 611.57 35, 723.14 2,097,140.50 3,290,779.98 5,387,920.48 - 45,094.00 14,302.54 - 24,885.69 - 152, 500.00 152, 500.00 - 148,958.89 - 225,000.00 2,288,828.73 3,862,332.87 1,707,132.00 2,054,537.51 581,696.73 1,807,795.36 45,094.00 14, 302.54 24,885.69 305,000.00 148,958.89 225,000.00 6,151,161.60 3,761,669.51 2,389,492.09 Total of Engineering & Construction Contracts Original Contracts 2,339,009.50 3,473,295.98 5,812,305.48 Change Orders 19,656.00 45,094.00 103,938.23 Total 2,358,665.50 3,518,389.98 5,916,243.71 Paid through June 30, 2010 1,961,545.43 2,208,441.94 4,169,987.37 Balance 397,120.07 1,309,948.04 1,746,256.34 Notes: a) Additional landfill gas investigation per DEQ as part of a requirement to address offsite landfill gas migration. b) Construction of Cell #5 began in FY 2008. Through June 30, 2009, $3,557,678 has been expended and reported as "Construction in Progress" on the County's CAFR FYE June 30, 2009. Expenditures include payments to JAL Construction, Taylor NW, KN EX Co, Jack Robinson & Sons. c) To date in FY 2010, payment has been made to Central Electric Co-op: $13,311 for the Closure of Area A and $20,822 for Cell 5. Deschutes County College CRAFT IMI PR and print ads (Bulletin) begin 2-Aug Application deadline 20-Aug Application review/final 24-Aug Applicant notification 25-Aug CLASS FOCUS DATE Admin/BOCC/Cty overview Sept. 14 Road/Solid Waste Sept. 21 Sheriff's Office/911 Sept. 28 DA/ CCF/ Juv & P&P Oct. 5 Health Services Oct. 12 CDD Oct. 19 Clerk/ Fair & Expo Oct. 26 Elections/Assessor/Tax & Finance Nov. 2