HomeMy WebLinkAbout2010-08-30 Work Session MinutesTES 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, AUGUST 30, 2010 Present were Commissioner Dennis R. Luke, Alan Unger and Tammy Baney. Also present were Erik Kropp, Deputy County Administrator; and, for part of the meeting, Marty Wynne, Finance; David Inbody, Assistant to the Administrator; Tom Anderson and Nick Lelack, Community Development; Laurie Craghead, County Counsel; and one other citizen. Erik Kropp introduced citizen Steven Pless, who is a resident of Shepherd's House, and is job shadowing today. He has worked for several electrical contractors in the past and is investigating other careers. Chair Luke opened the meeting at 1:30 p.m. 1. Signature of Order No. 2010-048, regarding Reconveyance Deeds — Elkhorn Properties. Laurie Craghead gave a brief overview of the item. BANEY: Move approval. UNGER: Second. VOTE: BANEY: Yes. UNGER: Yes. LUKE: Chair votes yes. 2. Tax/Finance Update. Marty Wynne said the average yield is still below 1 %, and is headed lower. Rates are unprecedented. The County budget 0.7%, so there are no surprises. The investments should stay above 1% depending on the pool. No significant changes are anticipated for at least two years. Minutes of Board of Commissioners' Work Session Wednesday, August 30, 2010 Page 1 of 4 Pages There are only two areas of the various operating funds that are of concern, Community Development and the Health Benefits Trust fund . It is too early for projections, but Community Development is still operating at a loss. The Health Benefits Trust fund shows that based on experience, it could end up with increased claims and less revenue. If it continues, rates charged to the departments would have to be increased to make up the shortfall. The Fair & Expo report showed the results of the Annual Fair. Attendance was up from the previous year, and earnings were up significantly, not even counting the revenue from concessions that have not yet been tallied. The RV Park has been operating well, and the Family Motor Coach Association event is anticipated to bring in excellent revenue. It is hoped that this trend will help bring in enough to cover capital projects and maintenance funds. 3. Economic Development Grant Requests. David Inbody advised the Commissioners of how much they still have in their economic development grant fund accounts. • COIC — Food Summit The Commissioners agreed to split the amount equally: Commissioners Luke and Baney, $333 each; Commissioner Unger, $334. • Redmond Chamber of Commerce — Retail Development Project Commissioners Luke and Unger granted $1,000 each. • Upper Deschutes River Coalition — Web Contact Management System The three Commissioners granted $250 each. • Daughters of the American Revolution — COCC Nursing Scholarship Commissioners Unger and Luke suggested the group pursue other avenues for funding at this time since the County already contributes towards nursing scholarships at COCC. 4. Bend Airport Master Plan Update. Erik Kropp asked the Commissioners what involvement they would like to see the County have in this project. The City is ready to kick off their one-year process and have hired a consultant to oversee it. There will be a technical advisory committee, and the application process is happening at this time. Minutes of Board of Commissioners' Work Session Wednesday, August 30, 2010 Page 2 of 4 Pages There will be public information meetings held regularly, as well as stakeholder meetings. They have offered a seat on the technical advisory committee to the County. The kickoff is scheduled in about a month. The County recommended an increase in the public informational aspects, which the City agreed to. Nick Lelack explained that the County is a review body, since their Airport Plan is referenced in the County's Comprehensive Plan. This is a legislative land use matter but could become quasi-judicial if, for instance, boundaries were to be added. Any can be appealed. The Commissioners like the idea of a County Planner being on the committee. A Commissioner cannot do so due to a potential conflict of interest or ex parte contacts. The Commissioners could also choose to remand the Plan back to the City for changes. Commissioner Unger does not want the County to allow individuals to exercise any kind of veto power just because they do not want to see growth. Mr. Lelack stated that the County will approach this with a team approach, since different planners have been involved in various aspects, such as transportation issues. 5. Approval of Document No. 2010-601, a Legal Services Agreement with Crook County. Mark Pilliod said Crook County's legal counsel will be out of the country for three weeks, and asked that Deschutes County cover in the event of an urgent legal matter in that jurisdiction. BANEY: Move approval. UNGER: Second. VOTE: BANEY: Yes. UNGER: Yes. LUKE: Chair votes yes. 6. Other Items. Executive Session, under ORS 192.660(2)(d), Labor Negotiations; and ORS 192.660(2)(h), Pending or Threatened Litigation. Minutes of Board of Commissioners' Work Session Wednesday, August 30, 2010 Page 3 of 4 Pages Being no further items discussed, the meeting adjourned at 3:40 p.m. DATED this Day of Deschutes County Board of Commissioners. ATTEST: Recording Secretary 2010 for the De is R. Luke, hair Alan Unger, Vice Chair ip_ Tammy Baney, , Commissibrner Minutes of Board of Commissioners' Work Session Wednesday, August 30, 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.org WORK SESSION AGENDA DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, AUGUST 30, 2010 1. Signature of Order No. 2010-048, regarding Reconveyance Deeds — Elkhorn Properties — Laurie Craghead 2. Tax/Finance Update — Marty Wynne 3. Economic Development Grant Requests — David Inbody • COIC — Food Summit • Redmond Chamber of Commerce — Retail Development Project • Upper Deschutes River Coalition — Web Contact Management System • Daughters of the American Revolution — COCC Nursing Scholarship 4. Bend Airport Master Plan Update — Erik Kropp 5. Other Items Executive Session, under ORS 192.660(2)(d), Labor Negotiations — Mark Pilliod 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 Si,.Bend, unless otherwise indicated. Ifyou 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 August 30, 2010 (1) Monthly Investment Report (2) July 2010 Financials • eschutes Count j 47 00.1 otal lnves m-nt portfolio As 0 Investment Income Fiscal Year 2010-11 0 > O 3 $ 91,402 $ 91,402 Total Investment Income 91,402 91,402 Less Fee: 5% of Invest. Income (4,570) (4,570 Investment Income - Net $ 86,832 $ 86,832 Investments By County Function General $ 113,454,088 Total Investments $ 113,454,088 CD T .13 415 tl1 et 3 0 'O oli• :r- ec \ c c O 0 o — o r 0 O M O P rM f4 to o tr (fl (0 In cn (6 4) 4) U N Z 4= Q E o (3 1— m 0 0 O O F— D ii LGIP/BOTC 113,454,088 4- d 0 0 to O U) y- N M O Average Maturity in Days M a o 0 0 0 0 0 0 0 in to in 0 0 0 0 ti N N N N 0 E o •x am) a m ca q) ca --C U 6 a_ t 0 2 ( m U —co Z as Q Q ( a) 2 m Ii c6 Ea. o `o O D _l 11 m H U U Total Portfolio: By investment Types r O N Market Value Original Cost O N N c o a a o U 7 N O b N � 0 E 1- O T O N ❑ T 7 1V TO 0 N N N C! L a co TT UUUUUUUUUUUUUUUUUUUUU_U_UUUU_U_,(,, U_UwU_oyt) Z Z z z z z z z z z z z z z z z Z z z z Z Z Z Z z Z Z r 9 Z Z m Z Z Z N 0 0) 7 0 0 Q 0- 01 N 0 O 0 of N 0 Ln O r C 0 O N 0 0 0 of CO of N CO r Q O. 4 Nr CO O 0) V 0 C) o 0 r 0 r N O O O O O O 4 0 0 4 0 V 0 0 r C) 0 0 0 0 O Q r 101.296.00 2,004,380.00 O 0 O 0 CO 0 0 0 0 r O O O 0 N O O 0) O CO 0 0 0 0 0 v o 0 o O O N O O O O r O r N 2,091,687 50 2.013.760 00 2,063,360 00 N r 0 0 CO 0 0 0 0 0 h (0 0 10 r (n c0 0 co r p O 0 O r N r 2.047,250.00 2.011, 200 00 0 0 4 CO N h N 0 O O LC) 0 CO N L00 (O O N (O N h O O of V 0 N M O r O r of (0 0 (0 0 C7 C) 1n O 0 V 0 0 N 0 0 r rr r 0 N N N N N 102.047.50 V N O V N O 4 h O 4 0 (f) 10 0 N N 0 N C") N 0 O 0 N N N N O (0 O <V N O O r N 0 N 0 C) O 0 (n O (n r N 0 N O C) O N m O N (0 N O N (p r O N r (0 (n C) N of h N CO PLC) r O) h h of R V N c0 O V co O co (0 (0 C) 0 0 0 0 0 0 0 r 7 0 O O) r O r O O r 0 0 0 N r N r N N N N 0 0 0 0 0 CO 0 0 0 of 0 0 0 0 0 10 0 0 0 0 0 0) 0 0 0 h 0 co O h co 0 0 <V O (n O V 0 1n 0 (p O CO 0 0 0 (p 0 9 10 r 0 CO O M O 0) O (0 V h O O O 0) 0 0 0 0 00-000)--,---0 N r N N r N N 1.999,540 00 0 0 O O O O O O O 0 O O 0 0 0 V 0 0 0 co 0 0 o h O O O 0) O 0 0) N N r 2.198, 333.33 2.109000 00 2.158.360 00 O 0 CO O 0 Lf) 0 0 (f) 10 O 0) 10 10 V O 0) N (0 r O 0 N N N 0 0 0 0 O O V O CO O L0 N C) co (0 0) CD CD O O N N N 2,017 188 89 2,006 260 00 2.000,000 00 N- O r O CO O CO 0 7 0 (U O CO O r O 1() 0 0 0 2 2 2 Oco co O h N CO N CO 0 O N V N O 10 C) O O O N N N N N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO 0 0 10 0 0 C) 0 0 r N O V 0 N cO 10 0 N- 0 0 0 CO 0 0 0 0 0 0 0 N N N N N N 0 0 0 0 C) O 0 0 0 0 10 0 O O O O 0) O (0 0 0 0 (0 0 0 o (O O co O (0010 0 r 0 ID 0 0 0 V 0 0000,-0 N N N N N N 2,036,722 22 2,015,620.00 2,004,720.00 2.030.500.00 2, 001, 388.89 2,000,000.00 c0 co 7 co 0 O 0 0 LC) CO (n O C) O 0 0 r 0 (n 0 0 CO O C) (n 0 C) 0 O N co 0 0 0 O 0 0 0 O O 0) 0 (h o O N 0) h C7 C) C) N 0Oh r h 0) O O O N 0 h h O h 2 co 2 O (n h (0 O N 10 C) o co co 0) 06 R- R h O Q O 0) N 0 N-- 00 N 0 r C7 C) 2 0) 10 N. -- L0 ` 10 V N (� N O h 0 O cO v CO 0 Q co 6, - co 1n V 7.577.997 33 $113,454,088.09 112,264,555.62 $112,370,976.97 0 0 0 .0 0 0 0 0 0 o 0 0 0 o o o 0 0 o e o 0 O 0 (0 0 0 0 0 0 0 CO 0 N 0 0 0 CJ CO 0 0 0 0 0 0 0 0 0 0) O (n 0 0 0 0 0 0 0 ('C) O O M 0 CO N V O N (n 0 (n CO 1n co V r 10 0 (n CO N 0 0 CO CO 0 (n CO (n O 0 r 0 (n h O (O O c0 0 0 0 (V O r O r N )- 10 N r 0) CO CO co V r CO N r O (0 CO CO h O h O O CO 0 0 10 N (O CD 0) C) r r r r r (0 (0 r r r O N - O - O r r r O r r r 0 0 0 0 r O - r O - r r 0 0 O Lc) o �n 0 o 0 00000 0 0 0 0 0 0 0 0 0 0 10 0 0 0 N. (n r r O O (n noon 10100010100000000 h (0 N C) 0) r (n CO 0 1n co co r co co O (0 (0 r r C) h r co 0 N N C) r C) V V r 0 O (() O r O c0 1n r 0 0 CO O r 0 (n r r r C a) N Z75 N al Ea 0 c C a 7, in 0 c E Y o �co O O h (n CO (0 V O) (n O 0) 0 00 (n r 0.1 (O h h 0 h 0) O) (0 CO h O C7 co (0 0 0 0 0 V >> co V (n (O V 0 N 0 (0 h V h (n CO 0 CO V V V V V CO N V C) (0 10 4 (n V (0 V h V V C) M E Y N- (n V co (n V 1n h (0 1n 1n r (n 7 C) 1n in 1n 1n (n (n (n V (n (n 7 1n 1n c0 (n (0 Ln CO (n (n h (A N j O 0 0 0 0 0 0 0 0 0 N N N I > O� CC7O) O V O 7 V 1� r m 7--7 1n m O O iT O) 1n cO 7-7 7 moNto 1n O (") r r r -()N N O O O O r C) r N N O N N N O O N 0 0 0 0 r N O N r N O N r(6FO O O r N r .- 7 (0 C) V 1n to c0 (p r (f (f 0) 0) 0 07 O) 0 O O 7 r (nU0 0 0 O r r r rr 00000000000000000000 r r r'- 0 0 0 o O 0 H J m c0 Cr, 0) 0) Cr, Cr, Cr, CO 0) 0) 0) 0 0 0) 0 O) 0) 0) 0) O) 0 0 0 0 00 0 O 0) 0 0 0 0 0 0 O O O O 0 0 0 0 O O 0 0 r 0 0 r 0 0 0 0 0 r r O r (n O V CO- 1n r 0 0 O O O 'N aa0 0-- (0 n O In L7 in ....7 N r r N N O r 0 r C) N N r r N N N r r N 0 r N C) r O O N r N 0 N r N (p O) 0 cp (n N O 0 0 r N m N N O C) (h (n 10 0 N 0 (n 0 0 (n O O O O O O O r r O 0 0 0 r O O r r r r O 0 0 0 0 0 0 0 r 0 0 0 0 0 0 0 ad Al 0 0 < yueg OJ CO CO 1.J_ E z7 a U Investment Desc <<Z <0<0<0 ZO Z <0 00 <Z Z 0< 0 0 0 Q< Z<< 0 0< ll LL U LL H L- H m H U H U L- H H H U H tL Li_ 0 L- L- L- U LL LL H H L_ Z m a D m a Q Li U- CC Z z> H CO Z a Z Z Z CO Li CO LL CO a U U- CC D 00 I C) - CCDm=U n n n nY nab Dd(n n(.0 0 � Dm3 c0 O O N h (0 (D In (n c0 0) co m h W (n ZH D m 1n 0 1 Q H H 0 co O a< N Z CC a 0 m a s> m D -i i a XW C O N X X X X n X co co (`� C) (ND (`� hco co conNn0mnn ca O) O co co co h C) C) O c0 C) N N C) 0 d 0)'-‘) '- Csi P 0r CD O) N M C) (") (") C) 0) (")0 nn (") 0 Q 0 0 3 a 1 N 0 00 U 0 Z CD U Y U 0 . U C 0 Y N c Y C al 0 c Z 0 O°'c CZJ @Z Ym 0 :Q 0 P U° m0 0 <! , al(0m O. a) 0 CO O 0 Z U Y 0 , N a) (a 0 C C o m o T- U U C o c U m Q0)) a) (a m a) 0 o > ' o m m a) Li m m< m a, W c o) co o CO J m o m a U m o W 'o m > O) m m U 0 U (0 o (c CO E CO m o 0 a_, Q c E 5 2 2 m? _� m 2 ID- 00 2 m m 0 Tm 2 ac 2 01011 ° E2 E o o a o m= o° o a E L L222LL o2Z E (aZ J m LL 2 LL LL U' LL D LL D m 2 5 U U LL (n u) Y LL D s D LL LL LL LL u_ LL H LL U_ D m LL 3136FMSQ8 BOTC balance earns LGIP rate + 25 basis points O CO'f 7 O N � V N h 0 0 _J r (p c0 C) N O f) r 0) O 0 of V (-09 N (0 O nn non nm Non 0.14 000 (0 n O O O O U N aN 0) a C a o > E N Z o a) U_ O ad, a7 0 Q y 1] c Y E a a7 0 H C Z o O E (n 0 1a 7 O OOH -ID - 0 z J Q 0 u- 0:1 z>I-aa ¢az<❑ CO CO U2Y .J CL a'(n(n In7 n000 I- H 0 Memorandum Date: August 18, 2010 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find July 2010 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriff's (255, 701, 702), Public Health (259), Behavioral Health (275), Community Development (295), Road (325), Community Justice — Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Insurance Fund (670), 9-1-1 (705) and Health Benefits Trust (675). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads 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 Transfers Out TOTAL REQUIREMENTS NET (Resources - Requirements) GENERAL FUND Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % Budget Year End Projection Variance $ 8,300,000 $ 9,687,099 $ 1,387,099 100% 117% $8,300,000 $9,687,099 $ 1,387,099 1,713,833 199,762 66,308 101,726 1,033 26,175 15,017 5,656 7,593 170 2,137,273 135,416 552,277 181,787 118,444 378 2,694 45,689 7,511 167 1,044,363 (1,578,417) 352,515 115,479 16,718 (655) (23,481) 30,672 (5,656) (82) (3) (1,092,910) 10,437,273 281,852 123,677 6,284 406,844 70,576 21,850 21,102 9,350 182,657 623,565 8% 1% a) 20,566,000 20,566,000 8% 23% b) 2,397,138 2,397,138 8% 23% b) 795,690 795,690 8% 10% 1,220,714 1,220,714 8% 3% 12,398 12,398 8% 1% 314,100 314,100 8% 25% c) 180,200 180,200 8% 0% 67,866 67,866 8% 8% 91,132 91,132 8% 8% 2,000 2,000 8% 4% 25,647,238 25,647,238 10,731,462 294,189 8% 32% 33,947,238 35,334,337 1,387,099 246,942 108,033 3,634 381,590 50,156 20,815 19,951 8,895 84,868 34,910 15,644 2,650 25,254 20,420 1,035 1,151 455 97,789 623,565 1,747,757 924,884 822,873 1,081„180 1,291,209 (210,029) 2,828,937 2,216,093 612,844 7,608,336 8,515,369 907,033 8% 8% 8% 8% 8% 8% 8% 8% 8% 4% 8% n/a 4% 8% 10% 7% Exp. % 7% 7% 5% 8% 6% 8% 8% 8% 8% 8% a) Approximately 85% of the property taxes are collected in October and November b) YTD Actual includes annual federal payment in lieu of taxes - $471,913 c) YTD Actual includes A&T grant received quarterly in advance 3,382,219 1,484,127 75,403 4,882,127 846,910 262,197 253,227 112,203 2,191,887 7,482,774 20,973,074 12,974,164 33,947,238 3,382,219 1,484,127 75,403 4,882,127 846,910 262,197 253,227 112,203 2,191,887 7,482,774 13,490,300 7,482,774 12,974,164 26,464,464 7,482,774 8,869,873 8,869,873 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -Court Assess. Discovery Fee Food Subsidy OYA Basic & Diversion Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Grants - Private Health & Human Svcs Chg CCF Interfund Grant Interfund Grant Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) COMM JUSTICE -JUVENILE Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % $ 987,000 $ 961,879 $ (25,121) 100% 97% $ 987,000 $ 961,879 $ (25,121) 1,294 5,000 1,333 3,167 28,334 8,333 8 7,374 25 83 1,417 200 42 500 5,041 1,667 2,133 20 875 200 84 (1,294) (2,867) (1,333) (3,167) (28,334) (8,333) (8) (7,374) (5) (83) (542) 42 (500) (5,041) (1,667) 63,818 3,312 (60,506) 461,932 461,932 1,512,750 8% 0% a) 8% 4% 8% 0% 8% 0% 8% 0% a) 8% 0% 8% 0% 8% 0% 8% 7% 8% 0% 8% 5% 8% 8% 8% 17% 8% 0% 8% 0% a)b) 8% 0% a) 8% 0% 8% 8% 1,427,123 (85,627) 8% 20% Exp. % 15,527 60,000 16,000 38,000 340,006 100,000 100 88,490 300 1,000 17,000 2,400 500 6,000 60,495 20,000 15,527 60,000 16,000 38,000 340,006 100,000 100 88,490 300 1,000 17,000 2,400 500 6,000 96,500 20,000 36,005 765,818 801,823 36,005 5,543,186 7,296,004 5,543,186 7,306,888 246,996 225,312 21,684 8% 8% 2,963,956 2,963,956 99,991 67,120 32,871 8% 6% 1,199,886 1,199,886 8 - 8 8% 0% 100 100 194,622 182,958 11,664 8% 8% 2,335,462 2,335,462 14,625 15,194 (569) 8% 9% c) 175,494 175,494 51,759 - 51,759 8% n/a 621,106 10,884 621,106 608,001 490,584 117,417 8% 7% 7,296,004 6,674,898 621,106 904,749 936,539 31,790 a) Reimbursements received quarterly in arrears b) Additional funding from CCF allocated for Juvenile programs c) Negative variance due to a $10,000 annual subscription expended in July 631,990 631,990 Year End Budget Projection Variance $ 987,000 $ 961,879 $ (25,121) 100% 97% $ 987,000 $ 961,879 $ (25,121) 1,294 5,000 1,333 3,167 28,334 8,333 8 7,374 25 83 1,417 200 42 500 5,041 1,667 2,133 20 875 200 84 (1,294) (2,867) (1,333) (3,167) (28,334) (8,333) (8) (7,374) (5) (83) (542) 42 (500) (5,041) (1,667) 63,818 3,312 (60,506) 461,932 461,932 1,512,750 8% 0% a) 8% 4% 8% 0% 8% 0% 8% 0% a) 8% 0% 8% 0% 8% 0% 8% 7% 8% 0% 8% 5% 8% 8% 8% 17% 8% 0% 8% 0% a)b) 8% 0% a) 8% 0% 8% 8% 1,427,123 (85,627) 8% 20% Exp. % 15,527 60,000 16,000 38,000 340,006 100,000 100 88,490 300 1,000 17,000 2,400 500 6,000 60,495 20,000 15,527 60,000 16,000 38,000 340,006 100,000 100 88,490 300 1,000 17,000 2,400 500 6,000 96,500 20,000 36,005 765,818 801,823 36,005 5,543,186 7,296,004 5,543,186 7,306,888 246,996 225,312 21,684 8% 8% 2,963,956 2,963,956 99,991 67,120 32,871 8% 6% 1,199,886 1,199,886 8 - 8 8% 0% 100 100 194,622 182,958 11,664 8% 8% 2,335,462 2,335,462 14,625 15,194 (569) 8% 9% c) 175,494 175,494 51,759 - 51,759 8% n/a 621,106 10,884 621,106 608,001 490,584 117,417 8% 7% 7,296,004 6,674,898 621,106 904,749 936,539 31,790 a) Reimbursements received quarterly in arrears b) Additional funding from CCF allocated for Juvenile programs c) Negative variance due to a $10,000 annual subscription expended in July 631,990 631,990 SHERIFF - Fund 255 Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ Revenues $ 207,689 $ 207,689 100% nla $ $ 207,689 $ 207,689 Law Enf Dist Countywide 1,902,455 1,902,455 8% 8% 22,829,457 22,829,457 - Law Enf Dist Rural 1,138,828 1,138,828 - 8% 8% 13,665,939 13,665,939 - Interest 1,059 1,059 8% n/a - 1,059 1,059 Total Revenues 3,041,283 3,042,342 1,059 8% 8% 36,495,396 36,496,455 1,059 TOTAL RESOURCES REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications Investigations/Evidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non -Departmental Contingency 3,041,283 3,250,031 208,748 8% 9% 36,495,396 36,704,144 208,748 Exp. 233,806 224,818 8,988 8% 8% 2,805,668 2,805,668 66,536 58,599 7,937 8% 7% 798,436 798,436 121,086 326,787 (205,701) 8% 22% a) 1,453,036 1,453,036 137,566 139,058 (1,492) 8% 8% 1,650,792 1,650,792 652,388 603,754 48,634 8% 8% 7,828,651 7,828,651 55,032 49,209 5,823 8% 7% 660,386 660,386 829,475 634,843 194,632 8% 6% 9,953,695 9,953,695 20,071 21,787 (1,716) 8% 9% 240,851 240,851 14,537 14,389 148 8% 8% 174,441 174,441 94,784 115,353 (20,569) 8% 10% 1,137,404 1,137,404 230,784 199,000 31,784 8% 7% 2,769,411 2,769,411 27,500 22,647 4,853 8% 7% 330,000 330,000 - 48,076 42,700 5,376 8% 7% 576,917 576,917 23,585 6,918 16,667 8% 2% 283,018 283,018 469,390 469,390 8% n/a 5,632,690 - 5,632,690 Transfers Out - D/S Fund 16,667 16,667 8% 0% 200,000 200,000 TOTAL REQUIREMENTS 3,041,283 2,459,862 581,421 8% 7% 36,495,396 30,862,706 5,632,690 NET (Resources - Requirements) 790,169 790,169 5,841,438 5,841,438 a) Annual expenditure for Interagency Communications System was made in July Year End Budget Projection Jariance $ $ 207,689 $ 207,689 Law Enf Dist Countywide 1,902,455 1,902,455 8% 8% 22,829,457 22,829,457 - Law Enf Dist Rural 1,138,828 1,138,828 - 8% 8% 13,665,939 13,665,939 - Interest 1,059 1,059 8% n/a - 1,059 1,059 Total Revenues 3,041,283 3,042,342 1,059 8% 8% 36,495,396 36,496,455 1,059 TOTAL RESOURCES REQUIREMENTS: EXPENDITURES & TRANSFERS Sheriffs Division Civil Automotive/Communications Investigations/Evidence Patrol/Civil/Comm Supp Records Adult Jail Court Security Emergency Services Special Services Division Regional Work Center Training Division Other Law Enforcement Svcs Non -Departmental Contingency 3,041,283 3,250,031 208,748 8% 9% 36,495,396 36,704,144 208,748 Exp. 233,806 224,818 8,988 8% 8% 2,805,668 2,805,668 66,536 58,599 7,937 8% 7% 798,436 798,436 121,086 326,787 (205,701) 8% 22% a) 1,453,036 1,453,036 137,566 139,058 (1,492) 8% 8% 1,650,792 1,650,792 652,388 603,754 48,634 8% 8% 7,828,651 7,828,651 55,032 49,209 5,823 8% 7% 660,386 660,386 829,475 634,843 194,632 8% 6% 9,953,695 9,953,695 20,071 21,787 (1,716) 8% 9% 240,851 240,851 14,537 14,389 148 8% 8% 174,441 174,441 94,784 115,353 (20,569) 8% 10% 1,137,404 1,137,404 230,784 199,000 31,784 8% 7% 2,769,411 2,769,411 27,500 22,647 4,853 8% 7% 330,000 330,000 - 48,076 42,700 5,376 8% 7% 576,917 576,917 23,585 6,918 16,667 8% 2% 283,018 283,018 469,390 469,390 8% n/a 5,632,690 - 5,632,690 Transfers Out - D/S Fund 16,667 16,667 8% 0% 200,000 200,000 TOTAL REQUIREMENTS 3,041,283 2,459,862 581,421 8% 7% 36,495,396 30,862,706 5,632,690 NET (Resources - Requirements) 790,169 790,169 5,841,438 5,841,438 a) Annual expenditure for Interagency Communications System was made in July SHERIFF 701 Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY Coll. % RESOURCES: Beg. Net Working Capital $ 4,722,862 $ 5,479,242 $ 756,380 100% Revenues Tax Revenues - Current 1,237,800 - (1,237,800) 8% Tax Revenues - Prior 53,500 97,538 44,038 Federal Grants 2,917 (2,917) 8% State Grant 4,040 (4,040) 8% Transp. of State Wards 417 (417) 8% SB 1145 164,555 493,665 329,110 8% Des. Cty Video Lottery Grant 417 (417) 8% Des Cty Court Security 7,917 7,905 (12) 8% Title III Reimbursement 12,500 (12,500) 8% Transport 333 (333) 8% Inmate Commissary Fees 4,000 (4,000) 8% Work Center Work Crews 2,083 (2,083) 8% Concealed Handgun Classes 500 650 150 8% Soc Sec Incentive -Fed 417 600 183 8% Miscellaneous 417 430 13 8% Oregon Mentors 1,000 1,000 8% Medical Services Reimb 1,000 (1,000) 8% Restitution 83 2,695 2,612 8% Sheriff Fees 13,333 24,484 11,151 8% Interest 2,361 3,683 1,322 8% Interest on Unsegregated 294 32 (262) 8% Total Revenues 1,508,883 632,682 (876,201) 8% 8% TOTAL RESOURCES 116% $ 4,722,862 $ 5,479,242 $ 756,380 0% 15% 0% 0% 0% 25% 0% 8% 0% 0% 0% 0% 11% 12% 9% n/a 0% 270% 15% 13% 1% 3% a) 14,853,594 642,000 35,000 48,475 5,000 b) 1,974,660 5,000 95,000 150,000 4,000 48,000 25,000 6,000 5,000 5,000 12,000 1,000 160,000 28,333 3,533 14,853,594 642,000 35,000 48,475 5,000 1,974,660 5,000 95,000 150,000 4,000 48,000 25,000 6,000 5,000 5,000 5,000 12,000 5,000 160,000 28,333 3,533 5,000 4,000 18,106,595 18,115,595 9,000 6,231,745 6,111,924 (119,822) 8% 27% 22,829,457 23,594,837 765,380 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,902,455 TOTAL REQUIREMENTS NET (Resources - Requirements) 1,902,455 1,902,455 1,902,455 4,329,290 4,209,469 (119,822) Exp. % 8% 8% 22,829,457 22,829,457 8% a) Approximately 85% of the property taxes are collected in October and November b) Quarterly payments received in advance 8% 22,829,457 22,829,457 765,380 765,380 Year End Budget Projection Variance 116% $ 4,722,862 $ 5,479,242 $ 756,380 0% 15% 0% 0% 0% 25% 0% 8% 0% 0% 0% 0% 11% 12% 9% n/a 0% 270% 15% 13% 1% 3% a) 14,853,594 642,000 35,000 48,475 5,000 b) 1,974,660 5,000 95,000 150,000 4,000 48,000 25,000 6,000 5,000 5,000 12,000 1,000 160,000 28,333 3,533 14,853,594 642,000 35,000 48,475 5,000 1,974,660 5,000 95,000 150,000 4,000 48,000 25,000 6,000 5,000 5,000 5,000 12,000 5,000 160,000 28,333 3,533 5,000 4,000 18,106,595 18,115,595 9,000 6,231,745 6,111,924 (119,822) 8% 27% 22,829,457 23,594,837 765,380 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,902,455 TOTAL REQUIREMENTS NET (Resources - Requirements) 1,902,455 1,902,455 1,902,455 4,329,290 4,209,469 (119,822) Exp. % 8% 8% 22,829,457 22,829,457 8% a) Approximately 85% of the property taxes are collected in October and November b) Quarterly payments received in advance 8% 22,829,457 22,829,457 765,380 765,380 SHERIFF 702 Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $1,905,939 $ 2,398,498 $ 492,559 100% Revenues Tax Revenues - Current 625,686 - (625,686) 8% Tax Revenues - Prior 26,167 50,360 24,193 8% Federal Grants 167 - (167) 8% US Forest Service 6,375 - (6,375) 8% State Grant 15,636 (15,636) 8% SB #1065 Court Assessment 5,583 2,133 (3,450) 8% Marine Board License Fee 11,869 - (11,869) 8% Des Cty General Fund Grant 58,530 - (58,530) 8% Des Cty Transient Room Tax 162,304 162,304 - 8% City of Sisters 36,055 36,055 8% Des Cty Tax/Fin Contract 83 - (83) 8% Des Cty CDD Contract 4,531 4,531 8% Des Cty Solid Waste Contr 4,531 4,531 - 8% Des Cty Clerk/Election 167 - (167) 8% School Districts 8,333 - (8,333) 8% Security & Traffic Reimb 1,083 1,081 (2) 8% Seat Belt Program 500 450 (50) 8% Miscellaneous 833 332 (501) 8% Restitution 42 - (42) 8% Sheriff Fees 833 631 (202) 8% Court Fines & Fees 7,083 9,694 2,611 8% Impound Fees 1,250 500 (750) 8% Restitution - Street Crimes 42 - (42) 8% Interest 833 1,339 506 8% Interest on Unsegregated 150 16 (134) 8% Sale of Reportable Assets 833 - (833) 8% Sale of Equip & Material 500 31 (469) 8% Total Revenues 979,999 273,988 (706,011) 8% TOTAL RESOURCES 2,885,938 REQUIREMENTS: EXPENDITURES & TRANSFERS Materials and Services 1,138,828 2,672,486 (213,452) 1,138,828 TOTAL REQUIREMENTS 1,138,828 1,138,828 NET (Resources - Requirements) 1,747,110 1,533,658 (213,452) 8% 8% 126% $ 1,905,939 $2,398,498 $ 492,559 0% a) 16% 0% 0% 0% 3% 0% 0% 8% 8% 0% 8% 8% 0% 0% 8% 8% 3% 3% 0% 13% 1% 0% 1% 7,508,247 314,000 2,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 13,000 6,000 10,000 500 10,000 85,000 15,000 500 10,000 1,800 10,000 6,000 7,508,247 314,000 2,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 13,000 6,000 10,000 500 10,000 85,000 15,000 500 10,000 1,800 10,000 6,000 2% 11,760,000 11,760,000 20% 13,665,939 14,158,498 492,559 Exp. 8% 13,665,939 13,665,939 8% 8% 13,665,939 13,665,939 a) Approximately 85% of the property taxes are collected in October and November 492,559 492,559 Year End Budget Projection Jariance 126% $ 1,905,939 $2,398,498 $ 492,559 0% a) 16% 0% 0% 0% 3% 0% 0% 8% 8% 0% 8% 8% 0% 0% 8% 8% 3% 3% 0% 13% 1% 0% 1% 7,508,247 314,000 2,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 13,000 6,000 10,000 500 10,000 85,000 15,000 500 10,000 1,800 10,000 6,000 7,508,247 314,000 2,000 76,500 187,633 67,000 142,433 702,358 1,947,642 432,655 1,000 54,366 54,366 2,000 100,000 13,000 6,000 10,000 500 10,000 85,000 15,000 500 10,000 1,800 10,000 6,000 2% 11,760,000 11,760,000 20% 13,665,939 14,158,498 492,559 Exp. 8% 13,665,939 13,665,939 8% 8% 13,665,939 13,665,939 a) Approximately 85% of the property taxes are collected in October and November 492,559 492,559 PUBLIC HEALTH Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % CoII. % RESOURCES: Beg. Net Working Capital $1,100,000 $ 1,319,878 $ 219,878 100% 120% $1,100,000 $1,319,878 $ 219,878 Revenues Medicare Reimbursement 667 - (667) 8% 0% 8,000 8,000 State Grant 207,915 136,934 (70,981) 8% 5% a) 2,494,977 2,494,977 Child Dev & Rehab Center 2,563 (2,563) 8% 0% 30,759 30,759 - State Miscellaneous 17,490 - (17,490) 8% 0% 209,875 209,875 - OMAP 39,817 15,765 (24,052) 8% 3% 477,800 477,800 Family Planning Exp Proj 41,250 - (41,250) 8% 0% 495,000 495,000 - Grants 2,083 27,000 24,917 8% 108% b) 25,000 52,000 27,000 Water Program -Base Fee 3,500 (3,500) 8% 0% 42,000 42,000 Water Program -Field Work 4,651 - (4,651) 8% 0% 55,817 55,817 - H20 Sys Insp-Priv Wells 17 (17) 8% 0% 200 200 Patient Insurance Fees 15,855 8,022 (7,833) 8% 4% 190,260 190,260 Health Dept/Patient Fees 12,415 8,984 (3,431) 8% 6% 148,975 148,975 Vital Records -Birth 3,000 2,740 (260) 8% 8% 36,000 36,000 Vital Records -Death 8,167 11,055 2,888 8% 11% 98,000 98,000 Environmental Health 57,279 19,540 (37,739) 8% 3% 687,350 687,350 Interest on Investments 1,408 1,087 (321) 8% 6% 16,900 16,900 Donations 500 229 (271) 8% 4% 6,000 6,000 Interfund Contract 15,782 - (15,782) 8% 0% 189,378 189,378 Administrative Fee 2,250 2,250 8% 8% 27,000 27,000 Total Revenues 436,609 233,606 (203,003) 8% 4% 5,239,291 5,266,291 27,000 Transfers In -General Fund Transfers In -Other Transfers In -Gen. Fund Other TOTAL RESOURCES 193,147 193,147 8% 8% 2,317,765 2,317,765 5,594 (5,594) 8% 0% 67,123 67,123 5,651 (5,651) 8% 0% 67,812 67,812 1,741,001 1,746,631 5,630 8% 20% 8,791,991 9,038,869 246,878 REQUIREMENTS: Expenditures Personal Services 485,161 Materials and Services 169,458 Capital Outlay 2,083 Transfers Out 12,500 Contingency 63,464 TOTAL REQUIREMENTS Exp. % 438,914 46,247 8% 8% 5,821,927 5,821,927 89,931 79,527 8% 4% 2,033,496 2,033,496 2,083 8% 0% 25,000 25,000 12,500 8% 0% 150,000 150,000 63,464 8% n!a 761,568 761,568 732,666 528,845 203,821 8% 6% 8,791,991 8,030,423 761,568 NET (Resources - Requirements) 1,008,335 1,217,786 209,451 - 1,008,446 1,008,446 a) State grant consists of several programs and not all programs are funded monthly b) Health Matters -local grant for Chronic Care Program is $17,000 & Bioterrorism NACCHO grant is $10,000 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,100,000 $ 1,319,878 $ 219,878 100% 120% $1,100,000 $1,319,878 $ 219,878 Revenues Medicare Reimbursement 667 - (667) 8% 0% 8,000 8,000 State Grant 207,915 136,934 (70,981) 8% 5% a) 2,494,977 2,494,977 Child Dev & Rehab Center 2,563 (2,563) 8% 0% 30,759 30,759 - State Miscellaneous 17,490 - (17,490) 8% 0% 209,875 209,875 - OMAP 39,817 15,765 (24,052) 8% 3% 477,800 477,800 Family Planning Exp Proj 41,250 - (41,250) 8% 0% 495,000 495,000 - Grants 2,083 27,000 24,917 8% 108% b) 25,000 52,000 27,000 Water Program -Base Fee 3,500 (3,500) 8% 0% 42,000 42,000 Water Program -Field Work 4,651 - (4,651) 8% 0% 55,817 55,817 - H20 Sys Insp-Priv Wells 17 (17) 8% 0% 200 200 Patient Insurance Fees 15,855 8,022 (7,833) 8% 4% 190,260 190,260 Health Dept/Patient Fees 12,415 8,984 (3,431) 8% 6% 148,975 148,975 Vital Records -Birth 3,000 2,740 (260) 8% 8% 36,000 36,000 Vital Records -Death 8,167 11,055 2,888 8% 11% 98,000 98,000 Environmental Health 57,279 19,540 (37,739) 8% 3% 687,350 687,350 Interest on Investments 1,408 1,087 (321) 8% 6% 16,900 16,900 Donations 500 229 (271) 8% 4% 6,000 6,000 Interfund Contract 15,782 - (15,782) 8% 0% 189,378 189,378 Administrative Fee 2,250 2,250 8% 8% 27,000 27,000 Total Revenues 436,609 233,606 (203,003) 8% 4% 5,239,291 5,266,291 27,000 Transfers In -General Fund Transfers In -Other Transfers In -Gen. Fund Other TOTAL RESOURCES 193,147 193,147 8% 8% 2,317,765 2,317,765 5,594 (5,594) 8% 0% 67,123 67,123 5,651 (5,651) 8% 0% 67,812 67,812 1,741,001 1,746,631 5,630 8% 20% 8,791,991 9,038,869 246,878 REQUIREMENTS: Expenditures Personal Services 485,161 Materials and Services 169,458 Capital Outlay 2,083 Transfers Out 12,500 Contingency 63,464 TOTAL REQUIREMENTS Exp. % 438,914 46,247 8% 8% 5,821,927 5,821,927 89,931 79,527 8% 4% 2,033,496 2,033,496 2,083 8% 0% 25,000 25,000 12,500 8% 0% 150,000 150,000 63,464 8% n!a 761,568 761,568 732,666 528,845 203,821 8% 6% 8,791,991 8,030,423 761,568 NET (Resources - Requirements) 1,008,335 1,217,786 209,451 - 1,008,446 1,008,446 a) State grant consists of several programs and not all programs are funded monthly b) Health Matters -local grant for Chronic Care Program is $17,000 & Bioterrorism NACCHO grant is $10,000 BEHAVIORAL HEALTH Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 2,616,050 $ 2,598,253 $ (17,797) 100% 99% $ 2,616,050 $ 2,598,253 Revenues Marriage Licenses 458 855 397 8% 16% 5,500 5,500 Divorce Filing Fees 10,833 10,313 (520) 8% 8% 130,000 130,000 Domestic Partnership Fee 83 (83) 8% 0% 1,000 1,000 Federal Grants 8,081 (8,081) 8% 0% 96,969 96,969 State Grants 441,155 400,487 (40,668) 8% 8% 5,293,862 5,293,862 State Miscellaneous 12,348 (12,348) 8% 0% 148,173 148,173 Title 19 25,077 7,671 (17,406) 8% 3% 300,925 300,925 Liquor Revenue 8,783 (8,783) 8% 0% 105,400 105,400 School Districts 5,833 (5,833) 8% 0% 70,000 70,000 Miscellaneous 1,408 1,055 (353) 8% 6% 16,900 16,900 Patient Insurance Fees 12,833 3,024 (9,809) 8% 2% 154,000 154,000 Patient Fees 1,083 116 (967) 8% 1% 13,000 13,000 Interest on Investments 3,632 2,264 (1,368) 8% 5% 43,585 43,585 Rentals 1,092 (1,092) 8% 0% 13,100 13,100 Interfund Contract -Gen. Fund 10,583 (10,583) 8% 0% 127,000 127,000 Comm. on Children & Fam 2,000 (2,000) 8% 0% 24,000 24,000 Administrative Fee 330,096 323,012 (7,084) 8% 8% 3,961,146 3,961,146 Total Revenues (17,797) 875,378 748,797 (126,581) 8% 7% 10,504,560 10,504,560 Transfers In -General Fund 109,680 109,680 - 8% 8% 1,316,158 1,316,158 Transfers In-OHP-CDO 8,333 8,333 - 8% 8% 100,000 100,000 Transfers In -Acute Care Svcs 30,471 30,471 - 8% 8% 365,657 365,657 Transfers In-ABHA 55,688 - (55,688) 8% 0% 668,252 668,252 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 3,695,600 3,495,534 (200,066) 8% 22% 15,570,677 15,552,880 Exp. % (17,797) 731,597 696,947 34,650 8% 8% 8,779,158 8,779,158 333,575 147,883 185,692 8% 4% 4,002,901 4,002,901 61,667 - 61,667 8% 0% 740,000 740,000 - 13,097 13,097 8% 0% 157,164 157,164 157,621 - 157,621 8% n/a 1,891,454 - 1,891,454 TOTAL REQUIREMENTS 1,297,557 844,830 452,727 8% 5% 15,570,677 13,679,223 1,891,454 NET (Resources - Requirements) 2,398,043 2,650,704 252,661 - 1,873,657 1,873..657 Year End Budget Projection Variance Total Revenues (17,797) 875,378 748,797 (126,581) 8% 7% 10,504,560 10,504,560 Transfers In -General Fund 109,680 109,680 - 8% 8% 1,316,158 1,316,158 Transfers In-OHP-CDO 8,333 8,333 - 8% 8% 100,000 100,000 Transfers In -Acute Care Svcs 30,471 30,471 - 8% 8% 365,657 365,657 Transfers In-ABHA 55,688 - (55,688) 8% 0% 668,252 668,252 TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 3,695,600 3,495,534 (200,066) 8% 22% 15,570,677 15,552,880 Exp. % (17,797) 731,597 696,947 34,650 8% 8% 8,779,158 8,779,158 333,575 147,883 185,692 8% 4% 4,002,901 4,002,901 61,667 - 61,667 8% 0% 740,000 740,000 - 13,097 13,097 8% 0% 157,164 157,164 157,621 - 157,621 8% n/a 1,891,454 - 1,891,454 TOTAL REQUIREMENTS 1,297,557 844,830 452,727 8% 5% 15,570,677 13,679,223 1,891,454 NET (Resources - Requirements) 2,398,043 2,650,704 252,661 - 1,873,657 1,873..657 COMMUNITY DEVELOPMENT Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. RESOURCES: Beg. Net Working Capital $ 686,081 603,258 $ (82,823) 100% 88% $ 686,081 $ 603,258 (82,823) Revenues Admin -Operations 1,375 1,443 68 8% 9% 16,500 16,500 Admin -GIS 229 (229) 8% 0% a) 2,750 2,750 Admin -Code Enforcement 13,477 15,229 1,752 8% 9% 161,718 161,718 Building Safety 90,101 89,587 (514) 8% 8% 1,081,217 1,081,217 - Electrical 22,221 27,190 4,969 8% 10% 266,652 266,652 Contract Services 15,333 1,379 (13,954) 8% 1% b) 184,000 184,000 Env Health -On Site Prog 23,653 26,294 2,641 8% 9% 283,830 283,830 Planning -Current 64,747 56,047 (8,700) 8% 7% 776,962 776,962 Planning -Long Range 29,481 21,355 (8,126) 8% 6% c) 353,771 353,771 Total Revenues 260,617 238,524 (22,093) 8% 8% 3,127,400 3,127,400 Trans In -GF 21,116 21,116 8% 8% 253,387 253,387 - Trans In -GF for Lng Rng Ping 43,000 43,000 8% 8% 516,000 516,000 TOTAL RESOURCES 1,010,814 905,898 (104,916) 8% 20% 4,582,868 4,500,045 (82,823) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations Exp. % 116,866 108,382 8,484 8% 8% 1,402,396 1,402,396 18,011 16,935 1,076 8% 8% 216,135 216,135 15,394 14,863 531 8% 8% 184,732 184,732 41,694 39,436 2,258 8% 8% 500,330 500,330 15,634 13,670 1,964 8% 7% 187,606 187,606 20,354 19,353 1,001 8% 8% 244,251 244,251 19,334 18,478 856 8% 8% 232,006 232,006 57,524 47,454 10,070 8% 7% 690,290 690,290 41,036 30,079 10,957 8% 6% 492,427 492,427 14,443 - 14,443 8% 0% 173,310 173,310 21,615 - 21,615 8% n/a 259,385 259,385 381,905 308,650 73,255 8% 7% 4,582,868 4,323,483 259,385 628,909 597,248 (31,661) 176,562 176,562 238,524 308,650 3,127,400 4,323,483 (70,126) (1,196,083) a) Custom GIS work revenue sporadic b) City of Redmond receipts lag one month behind c) Grant payments received irregularly Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 686,081 603,258 $ (82,823) 100% 88% $ 686,081 $ 603,258 (82,823) Revenues Admin -Operations 1,375 1,443 68 8% 9% 16,500 16,500 Admin -GIS 229 (229) 8% 0% a) 2,750 2,750 Admin -Code Enforcement 13,477 15,229 1,752 8% 9% 161,718 161,718 Building Safety 90,101 89,587 (514) 8% 8% 1,081,217 1,081,217 - Electrical 22,221 27,190 4,969 8% 10% 266,652 266,652 Contract Services 15,333 1,379 (13,954) 8% 1% b) 184,000 184,000 Env Health -On Site Prog 23,653 26,294 2,641 8% 9% 283,830 283,830 Planning -Current 64,747 56,047 (8,700) 8% 7% 776,962 776,962 Planning -Long Range 29,481 21,355 (8,126) 8% 6% c) 353,771 353,771 Total Revenues 260,617 238,524 (22,093) 8% 8% 3,127,400 3,127,400 Trans In -GF 21,116 21,116 8% 8% 253,387 253,387 - Trans In -GF for Lng Rng Ping 43,000 43,000 8% 8% 516,000 516,000 TOTAL RESOURCES 1,010,814 905,898 (104,916) 8% 20% 4,582,868 4,500,045 (82,823) REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Pgm Planning -Current Planning -Long Range Transfers Out (D/S Fund) Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Revenues Expenditures Net from Operations Exp. % 116,866 108,382 8,484 8% 8% 1,402,396 1,402,396 18,011 16,935 1,076 8% 8% 216,135 216,135 15,394 14,863 531 8% 8% 184,732 184,732 41,694 39,436 2,258 8% 8% 500,330 500,330 15,634 13,670 1,964 8% 7% 187,606 187,606 20,354 19,353 1,001 8% 8% 244,251 244,251 19,334 18,478 856 8% 8% 232,006 232,006 57,524 47,454 10,070 8% 7% 690,290 690,290 41,036 30,079 10,957 8% 6% 492,427 492,427 14,443 - 14,443 8% 0% 173,310 173,310 21,615 - 21,615 8% n/a 259,385 259,385 381,905 308,650 73,255 8% 7% 4,582,868 4,323,483 259,385 628,909 597,248 (31,661) 176,562 176,562 238,524 308,650 3,127,400 4,323,483 (70,126) (1,196,083) a) Custom GIS work revenue sporadic b) City of Redmond receipts lag one month behind c) Grant payments received irregularly ROAD Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Col I. % RESOURCES: Beg. Net Working Capital $3,430,429 $ 3,281,820 $ (148,609) 100% 96% $ 3,430,429 $ 3,281,820 $ (148,609) Revenues Mineral Lease Royalties 1,667 (1,667) 8% 0% 20,000 20,000 - Forest Receipts 186,417 (186,417) 8% 0% a) 2,237,000 2,237,000 State Miscellaneous 8,082 (8,082) 8% 0% 96,984 96,984 - Motor Vehicle Revenue 833,333 631,999 (201,334) 8% 6% b) 10,000,000 10,000,000 City of Bend 22,917 (22,917) 8% 0% 275,000 275,000 - City of Redmond 29,167 (29,167) 8% 0% 350,000 350,000 - City of Sisters 833 (833) 8% 0% 10,000 10,000 City of La Pine 833 (833) 8% 0% 10,000 10,000 - Admin Recovery (SDC) - 234 234 8% n/a - 500 500 Miscellaneous 1,667 3,465 1,798 8% 17% 20,000 20,000 - Road Vacations 83 (83) 8% 0% 1,000 1,000 Interest on Investments 3,333 2,747 (586) 8% 7% 40,000 40,000 Other Bank/LGIP Interest - 21 21 8% n/a - 100 100 Parking Fees 75 (75) 8% 0% 900 900 Interfund Contract 62,500 (62,500) 8% 0% 750,000 750,000 Equipment Repairs 20,833 (20,833) 8% 0% 250,000 250,000 Vehicle Repairs 7,500 (7,500) 8% 0% 90,000 90,000 LID Construction 833 (833) 8% 0% 10,000 10,000 Vegetation Management 2,917 (2,917) 8% 0% 35,000 35,000 Forester 2,083 (2,083) 8% 0% 25,000 25,000 Car Washes 250 (250) 8% 0% 3,000 3,000 Car Rental 42 (42) 8% 0% 500 500 Sale of Equip & Material 50,292 329 (49,963) 8% 0% 603,500 603,500 - Total Revenues 1,235,657 638,795 (596,862) 8% 4% 14,827,884 14,828,484 600 Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res TOTAL RESOURCES 24,313 16,667 1,003 (24,313) 8% 0% (16,667) 8% 0% (1,003) 8% 0% 291,740 200,000 12,040 291,740 200,000 12,040 4,708,069 3,920,615 (770,787) 8% 25% 18,762,093 18,614,084 (148,009) REQUIREMENTS: Expenditures Personal Services 479,414 439,787 39,627 8% Materials and Services 783,419 281,111 502,308 8% Capital Outlay 97,641 - 97,641 8% Transfers Out 33,333 - 33,333 8% Contingency 169,701 - 169,701 8% Exp. % 8% 3% 0% 0% n/a 5,752,967 9,401,023 1,171,691 400,000 2,036,412 5,752,967 9,401,023 1,171,691 400,000 2,036,412 TOTAL REQUIREMENTS 1,563,508 720,898 842,610 8% 4% 18,762,093 16,725,681 2,036,412 NET (Resources - Requirements) 3,144,561 3,199,717 71,823 1,888,403 1,888,403 a) Annual payment -January 2011 b) Gas tax will increase by 25% ($.06/gal.) effective January 2011 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $3,430,429 $ 3,281,820 $ (148,609) 100% 96% $ 3,430,429 $ 3,281,820 $ (148,609) Revenues Mineral Lease Royalties 1,667 (1,667) 8% 0% 20,000 20,000 - Forest Receipts 186,417 (186,417) 8% 0% a) 2,237,000 2,237,000 State Miscellaneous 8,082 (8,082) 8% 0% 96,984 96,984 - Motor Vehicle Revenue 833,333 631,999 (201,334) 8% 6% b) 10,000,000 10,000,000 City of Bend 22,917 (22,917) 8% 0% 275,000 275,000 - City of Redmond 29,167 (29,167) 8% 0% 350,000 350,000 - City of Sisters 833 (833) 8% 0% 10,000 10,000 City of La Pine 833 (833) 8% 0% 10,000 10,000 - Admin Recovery (SDC) - 234 234 8% n/a - 500 500 Miscellaneous 1,667 3,465 1,798 8% 17% 20,000 20,000 - Road Vacations 83 (83) 8% 0% 1,000 1,000 Interest on Investments 3,333 2,747 (586) 8% 7% 40,000 40,000 Other Bank/LGIP Interest - 21 21 8% n/a - 100 100 Parking Fees 75 (75) 8% 0% 900 900 Interfund Contract 62,500 (62,500) 8% 0% 750,000 750,000 Equipment Repairs 20,833 (20,833) 8% 0% 250,000 250,000 Vehicle Repairs 7,500 (7,500) 8% 0% 90,000 90,000 LID Construction 833 (833) 8% 0% 10,000 10,000 Vegetation Management 2,917 (2,917) 8% 0% 35,000 35,000 Forester 2,083 (2,083) 8% 0% 25,000 25,000 Car Washes 250 (250) 8% 0% 3,000 3,000 Car Rental 42 (42) 8% 0% 500 500 Sale of Equip & Material 50,292 329 (49,963) 8% 0% 603,500 603,500 - Total Revenues 1,235,657 638,795 (596,862) 8% 4% 14,827,884 14,828,484 600 Trans In - Solid Waste Trans In - Transp SDC Trans In -Road Imp Res TOTAL RESOURCES 24,313 16,667 1,003 (24,313) 8% 0% (16,667) 8% 0% (1,003) 8% 0% 291,740 200,000 12,040 291,740 200,000 12,040 4,708,069 3,920,615 (770,787) 8% 25% 18,762,093 18,614,084 (148,009) REQUIREMENTS: Expenditures Personal Services 479,414 439,787 39,627 8% Materials and Services 783,419 281,111 502,308 8% Capital Outlay 97,641 - 97,641 8% Transfers Out 33,333 - 33,333 8% Contingency 169,701 - 169,701 8% Exp. % 8% 3% 0% 0% n/a 5,752,967 9,401,023 1,171,691 400,000 2,036,412 5,752,967 9,401,023 1,171,691 400,000 2,036,412 TOTAL REQUIREMENTS 1,563,508 720,898 842,610 8% 4% 18,762,093 16,725,681 2,036,412 NET (Resources - Requirements) 3,144,561 3,199,717 71,823 1,888,403 1,888,403 a) Annual payment -January 2011 b) Gas tax will increase by 25% ($.06/gal.) effective January 2011 ADULT PAROLE & PROBATION Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278 Revenues DOC Measure 57 18,109 217,350 199,241 8% 100% a) 217,305 217,350 45 State Miscellaneous 358 (358) 8% 0% 4,301 4,301 Alternate Incarceration 2,577 30,918 28,341 8% 100% a) 30,918 30,918 State Subsidy 1,083 3,327 2,244 8% 26% b) 13,000 13,000 SB 1145 246,833 740,497 493,664 8% 25% b) 2,961,990 2,961,990 Probation Work Crew Fees 3,167 2,095 (1,072) 8% 6% 38,000 38,000 Miscellaneous 250 350 100 8% 12% 3,000 3,000 Electronic Monitoring Fee 14,167 19,528 5,361 8% 11% 170,000 170,000 Probation Superv. Fees 17,500 17,999 499 8% 9% 210,000 210,000 Interest on Investments 750 987 237 8% 11% 9,000 9,000 Interfund - Sheriff 4,167 4,167 - 8% 8% 50,000 50,000 - Interfund - General 4,167 - (4,167) 8% 0% c) 50,000 50,000 - Total Revenues 313,128 1,037,218 724,090 8% 28% 3,757,514 3,757,559 45 Transfers In -General Fund 9,586 9,586 8% 8% 115,029 115,029 TOTAL RESOURCES 939,085 1,775,453 836,368 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 8% 40% 4,488,914 4,601,237 112,323 Exp. % 262,742 249,483 13,259 8% 8% 3,152,899 3,152,899 74,523 48,401 26,122 8% 5% 894,274 894,274 8 8 8% 0% 100 100 36,803 36,803 8% n/a 441,641 TOTAL REQUIREMENTS 374,076 297,884 76,192 NET (Resources- Requirements) 565,009 1,477,569 912,560 a) Annual payment received in July b) Payment received quarterly in advance c) Payment received quarterly in arrears 8% 7% 441,641 4,488,914 4,047,273 441,641 553,964 553,964 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 616,371 $ 728,649 $ 112,278 100% 118% $ 616,371 $ 728,649 $ 112,278 Revenues DOC Measure 57 18,109 217,350 199,241 8% 100% a) 217,305 217,350 45 State Miscellaneous 358 (358) 8% 0% 4,301 4,301 Alternate Incarceration 2,577 30,918 28,341 8% 100% a) 30,918 30,918 State Subsidy 1,083 3,327 2,244 8% 26% b) 13,000 13,000 SB 1145 246,833 740,497 493,664 8% 25% b) 2,961,990 2,961,990 Probation Work Crew Fees 3,167 2,095 (1,072) 8% 6% 38,000 38,000 Miscellaneous 250 350 100 8% 12% 3,000 3,000 Electronic Monitoring Fee 14,167 19,528 5,361 8% 11% 170,000 170,000 Probation Superv. Fees 17,500 17,999 499 8% 9% 210,000 210,000 Interest on Investments 750 987 237 8% 11% 9,000 9,000 Interfund - Sheriff 4,167 4,167 - 8% 8% 50,000 50,000 - Interfund - General 4,167 - (4,167) 8% 0% c) 50,000 50,000 - Total Revenues 313,128 1,037,218 724,090 8% 28% 3,757,514 3,757,559 45 Transfers In -General Fund 9,586 9,586 8% 8% 115,029 115,029 TOTAL RESOURCES 939,085 1,775,453 836,368 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 8% 40% 4,488,914 4,601,237 112,323 Exp. % 262,742 249,483 13,259 8% 8% 3,152,899 3,152,899 74,523 48,401 26,122 8% 5% 894,274 894,274 8 8 8% 0% 100 100 36,803 36,803 8% n/a 441,641 TOTAL REQUIREMENTS 374,076 297,884 76,192 NET (Resources- Requirements) 565,009 1,477,569 912,560 a) Annual payment received in July b) Payment received quarterly in advance c) Payment received quarterly in arrears 8% 7% 441,641 4,488,914 4,047,273 441,641 553,964 553,964 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data One Month Ended July 31, 2010 RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 18,871 (18,871) 8% 0% 226,450 $ 226,450 Title IV - Family Sup/Pres 5,313 (5,313) 8% 0% 63,750 $ 63,750 HealthyStart Medicaid 7,917 (7,917) 8% 0% 95,000 $ 95,000 Level 7 Services 21,499 (21,499) 8% 0% 257,984 $ 257,984 State Prevention Funds 1,208 (1,208) 8% 0% 14,500 $ 14,500 HealthyStart /R -S -G 25,744 (25,744) 8% 0% 308,924 $ 308,924 OCCF Grant 50,360 (50,360) 8% 0% 604,323 $ 604,323 Charges for Svcs-Misc 667 (667) 8% 0% 8,000 $ 8,000 Court Fines & Fees 6,250 6,188 (62) 8% 8% 75,000 $ 75,000 Interest on Investments 1,667 605 (1,062) 8% 3% 20,000 $ 20,000 Grants -Private 417 (417) 8% 0% 5,000 $ 5,000 Miscellaneous 21,546 - (21,546) 8% 0% 258,554 $ 258,554 Total Revenues 161,459 6,793 (154,666) 8% 0% 1,937,485 1,937,485 Trans from General Fund Trans from GF -Other Total Transfers In TOTAL RESOURCES 23,694 23,694 8% 2,083 - (2,083) 8% 25,777 23,694 (2,083) 8% 8% 284,333 284,333 0% 25,000 25,000 8% 309,333 309,333 749,998 665,827 (84,171) 8% 24% 2,809,580 2,882,158 72,578 REQUIREMENTS: Expenditures Personal Services 49,963 41,037 8,926 8% Materials and Services 150,114 10,209 139,905 8% Capital Outlay 8 - 8 8% Contingency 34,046 - 34,046 8% Exp. % 7% 599,559 599,559 1% 1,801,367 1,801,367 0% 100 100 n/a 408,554 - 408,554 TOTAL REQUIREMENTS 234,131 51,246 182,885 8% 2% 2,809,580 2,401,026 408,554 NET (Resources - Requirements) 515,867 614,581 98,714 481,132 481,132 Year to Date Budget Budget Actual Variance FY % Coll. % RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 18,871 (18,871) 8% 0% 226,450 $ 226,450 Title IV - Family Sup/Pres 5,313 (5,313) 8% 0% 63,750 $ 63,750 HealthyStart Medicaid 7,917 (7,917) 8% 0% 95,000 $ 95,000 Level 7 Services 21,499 (21,499) 8% 0% 257,984 $ 257,984 State Prevention Funds 1,208 (1,208) 8% 0% 14,500 $ 14,500 HealthyStart /R -S -G 25,744 (25,744) 8% 0% 308,924 $ 308,924 OCCF Grant 50,360 (50,360) 8% 0% 604,323 $ 604,323 Charges for Svcs-Misc 667 (667) 8% 0% 8,000 $ 8,000 Court Fines & Fees 6,250 6,188 (62) 8% 8% 75,000 $ 75,000 Interest on Investments 1,667 605 (1,062) 8% 3% 20,000 $ 20,000 Grants -Private 417 (417) 8% 0% 5,000 $ 5,000 Miscellaneous 21,546 - (21,546) 8% 0% 258,554 $ 258,554 Total Revenues 161,459 6,793 (154,666) 8% 0% 1,937,485 1,937,485 Trans from General Fund Trans from GF -Other Total Transfers In TOTAL RESOURCES 23,694 23,694 8% 2,083 - (2,083) 8% 25,777 23,694 (2,083) 8% 8% 284,333 284,333 0% 25,000 25,000 8% 309,333 309,333 749,998 665,827 (84,171) 8% 24% 2,809,580 2,882,158 72,578 REQUIREMENTS: Expenditures Personal Services 49,963 41,037 8,926 8% Materials and Services 150,114 10,209 139,905 8% Capital Outlay 8 - 8 8% Contingency 34,046 - 34,046 8% Exp. % 7% 599,559 599,559 1% 1,801,367 1,801,367 0% 100 100 n/a 408,554 - 408,554 TOTAL REQUIREMENTS 234,131 51,246 182,885 8% 2% 2,809,580 2,401,026 408,554 NET (Resources - Requirements) 515,867 614,581 98,714 481,132 481,132 Year End Budget Projection Jariance RESOURCES: Beg. Net Working Capital $ 562,762 $ 635,340 $ 72,578 100% 113% $ 562,762 $ 635,340 $ 72,578 Revenues Federal Grants 18,871 (18,871) 8% 0% 226,450 $ 226,450 Title IV - Family Sup/Pres 5,313 (5,313) 8% 0% 63,750 $ 63,750 HealthyStart Medicaid 7,917 (7,917) 8% 0% 95,000 $ 95,000 Level 7 Services 21,499 (21,499) 8% 0% 257,984 $ 257,984 State Prevention Funds 1,208 (1,208) 8% 0% 14,500 $ 14,500 HealthyStart /R -S -G 25,744 (25,744) 8% 0% 308,924 $ 308,924 OCCF Grant 50,360 (50,360) 8% 0% 604,323 $ 604,323 Charges for Svcs-Misc 667 (667) 8% 0% 8,000 $ 8,000 Court Fines & Fees 6,250 6,188 (62) 8% 8% 75,000 $ 75,000 Interest on Investments 1,667 605 (1,062) 8% 3% 20,000 $ 20,000 Grants -Private 417 (417) 8% 0% 5,000 $ 5,000 Miscellaneous 21,546 - (21,546) 8% 0% 258,554 $ 258,554 Total Revenues 161,459 6,793 (154,666) 8% 0% 1,937,485 1,937,485 Trans from General Fund Trans from GF -Other Total Transfers In TOTAL RESOURCES 23,694 23,694 8% 2,083 - (2,083) 8% 25,777 23,694 (2,083) 8% 8% 284,333 284,333 0% 25,000 25,000 8% 309,333 309,333 749,998 665,827 (84,171) 8% 24% 2,809,580 2,882,158 72,578 REQUIREMENTS: Expenditures Personal Services 49,963 41,037 8,926 8% Materials and Services 150,114 10,209 139,905 8% Capital Outlay 8 - 8 8% Contingency 34,046 - 34,046 8% Exp. % 7% 599,559 599,559 1% 1,801,367 1,801,367 0% 100 100 n/a 408,554 - 408,554 TOTAL REQUIREMENTS 234,131 51,246 182,885 8% 2% 2,809,580 2,401,026 408,554 NET (Resources - Requirements) 515,867 614,581 98,714 481,132 481,132 SOLID WASTE Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY Coll. RESOURCES: Beg. Net Working Capital $ 392,509 $ 339,501 $ (53,008) 100% 86% $ 392,509 $ 339,501 $ (53,008) Revenues Miscellaneous 2,333 2,910 577 8% 10% 28,000 28,000 Franchise 3% Fees 16,667 2,659 (14,008) 8% 1% 200,000 200,000 Commercial Disp. Fees 70,000 78,007 8,007 8% 9% 840,000 840,000 Private Disposal Fees 109,500 143,246 33,746 8% 11% 1,314,000 1,314,000 Franchise Disposal Fees 304,917 372,649 67,732 8% 10% 3,659,000 3,659,000 Yard Debris 6,083 11,454 5,371 8% 16% 73,000 73,000 Special Waste 2,083 948 (1,135) 8% 4% 25,000 25,000 Interest 1,042 585 (457) 8% 5% 12,500 12,500 Sale of Carbon Credits 6,667 (6,667) 8% 0% 80,000 80,000 Recyclables 1,667 2,490 823 8% 12% 20,000 20,000 Total Revenues 520,959 614,948 93,989 8% 10% 6,251,500 6,251,500 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 913,468 954,449 40,981 8% 14% 6,644,009 6,591,001 (53,008) Exp. % 133,343 132,548 795 8% 8% 1,600,118 1,600,118 238,819 44,599 194,220 8% 2% 2,865,829 2,865,829 80,839 80,839 8% 0% 970,066 970,066 9,833 9,833 8% 0% 118,000 118,000 24,312 24,312 8% 0% 291,740 291,740 66,521 66,521 8% n/a 798,256 553,667 177,147 376,520 8% 798,256 3% 6,644,009 5,845,753 798,256 NET (Resources - Requirements) 359,801 777,302 417,501 745,248 745,248 Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 392,509 $ 339,501 $ (53,008) 100% 86% $ 392,509 $ 339,501 $ (53,008) Revenues Miscellaneous 2,333 2,910 577 8% 10% 28,000 28,000 Franchise 3% Fees 16,667 2,659 (14,008) 8% 1% 200,000 200,000 Commercial Disp. Fees 70,000 78,007 8,007 8% 9% 840,000 840,000 Private Disposal Fees 109,500 143,246 33,746 8% 11% 1,314,000 1,314,000 Franchise Disposal Fees 304,917 372,649 67,732 8% 10% 3,659,000 3,659,000 Yard Debris 6,083 11,454 5,371 8% 16% 73,000 73,000 Special Waste 2,083 948 (1,135) 8% 4% 25,000 25,000 Interest 1,042 585 (457) 8% 5% 12,500 12,500 Sale of Carbon Credits 6,667 (6,667) 8% 0% 80,000 80,000 Recyclables 1,667 2,490 823 8% 12% 20,000 20,000 Total Revenues 520,959 614,948 93,989 8% 10% 6,251,500 6,251,500 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 913,468 954,449 40,981 8% 14% 6,644,009 6,591,001 (53,008) Exp. % 133,343 132,548 795 8% 8% 1,600,118 1,600,118 238,819 44,599 194,220 8% 2% 2,865,829 2,865,829 80,839 80,839 8% 0% 970,066 970,066 9,833 9,833 8% 0% 118,000 118,000 24,312 24,312 8% 0% 291,740 291,740 66,521 66,521 8% n/a 798,256 553,667 177,147 376,520 8% 798,256 3% 6,644,009 5,845,753 798,256 NET (Resources - Requirements) 359,801 777,302 417,501 745,248 745,248 RESOURCES: Beginning Net Working Capital Revenues Inter -fund Charges: RISK MANAGEMENT Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance % of FY Coll. $2,500,000 $2,372,861 ($127,140) 100% 95% $2,500,000 $2,372,861 ($127,140) General Liability 27,986 27,986 (0) 8% 8% 335,833 335,833 Property Damage 24,502 24,502 0 8% 8% 294,019 294,019 Vehicle 15,226 15,226 0 8% 8% 182,710 182,710 Workers' Compensation 75,530 75,042 (488) 8% 8% 906,361 906,361 Unemployment 14,203 14,169 (34) 8% 8% 170,437 170,437 Claims Reimb-Workers' Compensation 2,500 - (2,500) 8% 0% 30,000 30,000 Claims Reimb-Gen Liab/Property 1,667 100 (1,567) 8% 1% 20,000 20,000 Process Fee-Events/Parades 125 420 295 8% 28% 1,500 1,500 Miscellaneous 167 - (167) 8% 0% 2,000 2,000 Skid Car Training 1,833 560 (1,273) 8% 3% 22,000 22,000 Interest on Investments 2,500 1,892 (608) 8% 6% 30,000 30,000 TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Insurance Total General Liability PROPERTY DAMAGE Total Property Damage 25,000 25,000 VEHICLE Professional Service 1,050 Repair / Replacement 273 Total Vehicle 10,000 1,323 8,677 8% 1% 120,000 120,00( WORKERS' COMPENSATION Settlement / Benefit 66,802 Insurance 46,424 Loss Prevention 7,500 Total Workers' Compensation 54,167 120,726 (66,559) 8% 19% 650,000 670,001 (20,000) 166,238 159,897 (6,341) 8% 8% 1,994,860 1,994,860 2,666,238 2,532,758 (133,481) 8% 56% 4,494,860 4,367,721 (127,140) % Exp. 230 1,418 33,333 1,648 31,685 8% 0% 400,000 400,000 8% (% 300,000 300,000 UNEMPLOYMENT - Settlement/Benefits 13,333 13,333 8% 0% 160,000 160,00 i Total Direct Insurance Costs 135,833 123,697 12,136 8% 8% 1,630,000 1,650,00) (20,000) Insurance Administration: Personal Services 24,121 23,708 413 8% 8% 289,453 289,4E 3 Materials & Service 19,070 13,748 5,321 8% 6% 228,834 228,8( 4 Capital Outlay 8 - 8 8% 0% 100 1C J Total Insurance Administration 43,199 37,456 5,743 8% 7% 518,387 518,3E 7 Contingency 195,539 - 195,539 8% n/a 2,346,473 - 2,346,473 TOTAL REQUIREMENTS 374,572 161,153 213,419 8% 4% 4,494,860 2,168,31 7 2,326,473 NET 2,291,667 2,371,605 79,938 - 2,199,3: 4 2,199,334 Year End Budget Projection Variance $2,500,000 $2,372,861 ($127,140) 100% 95% $2,500,000 $2,372,861 ($127,140) General Liability 27,986 27,986 (0) 8% 8% 335,833 335,833 Property Damage 24,502 24,502 0 8% 8% 294,019 294,019 Vehicle 15,226 15,226 0 8% 8% 182,710 182,710 Workers' Compensation 75,530 75,042 (488) 8% 8% 906,361 906,361 Unemployment 14,203 14,169 (34) 8% 8% 170,437 170,437 Claims Reimb-Workers' Compensation 2,500 - (2,500) 8% 0% 30,000 30,000 Claims Reimb-Gen Liab/Property 1,667 100 (1,567) 8% 1% 20,000 20,000 Process Fee-Events/Parades 125 420 295 8% 28% 1,500 1,500 Miscellaneous 167 - (167) 8% 0% 2,000 2,000 Skid Car Training 1,833 560 (1,273) 8% 3% 22,000 22,000 Interest on Investments 2,500 1,892 (608) 8% 6% 30,000 30,000 TOTAL REVENUES TOTAL RESOURCES Appropriations/Expenditures Direct Insurance Costs: GENERAL LIABILITY Settlement / Benefit Insurance Total General Liability PROPERTY DAMAGE Total Property Damage 25,000 25,000 VEHICLE Professional Service 1,050 Repair / Replacement 273 Total Vehicle 10,000 1,323 8,677 8% 1% 120,000 120,00( WORKERS' COMPENSATION Settlement / Benefit 66,802 Insurance 46,424 Loss Prevention 7,500 Total Workers' Compensation 54,167 120,726 (66,559) 8% 19% 650,000 670,001 (20,000) 166,238 159,897 (6,341) 8% 8% 1,994,860 1,994,860 2,666,238 2,532,758 (133,481) 8% 56% 4,494,860 4,367,721 (127,140) % Exp. 230 1,418 33,333 1,648 31,685 8% 0% 400,000 400,000 8% (% 300,000 300,000 UNEMPLOYMENT - Settlement/Benefits 13,333 13,333 8% 0% 160,000 160,00 i Total Direct Insurance Costs 135,833 123,697 12,136 8% 8% 1,630,000 1,650,00) (20,000) Insurance Administration: Personal Services 24,121 23,708 413 8% 8% 289,453 289,4E 3 Materials & Service 19,070 13,748 5,321 8% 6% 228,834 228,8( 4 Capital Outlay 8 - 8 8% 0% 100 1C J Total Insurance Administration 43,199 37,456 5,743 8% 7% 518,387 518,3E 7 Contingency 195,539 - 195,539 8% n/a 2,346,473 - 2,346,473 TOTAL REQUIREMENTS 374,572 161,153 213,419 8% 4% 4,494,860 2,168,31 7 2,326,473 NET 2,291,667 2,371,605 79,938 - 2,199,3: 4 2,199,334 RESOURCES: Beg. Net Working Capital Revenues Property Taxes - Current Property Taxes - Prior Federal Grants State Reimbursement Telephone User Tax Data Network Reimb. Jefferson County User Fee COPS Reimbursements Contract Payments Miscellaneous Interest Interest on Unsegregated Tax Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency DESCHUTES COUNTY 911 Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance $5,861,335 $ 6,684,966 $ 823,631 %ofFY %Coll. 100% 114% Budget Year End Projection Variance $ 5,861,335 $ 6,684,966 $ 823,631 529,802 (529,802) 8% 0% a) 6,357,621 6,357,621 11,500 38,343 26,843 8% 28% 138,000 138,000 39,500 (39,500) 8% 0% 474,000 474,000 833 (833) 8% 0% 10,000 10,000 45,833 - (45,833) 8% 0% 550,000 550,000 1,000 (1,000) 8% 0% 12,000 12,000 2,583 204 (2,379) 8% 1% 31,000 31,000 4,167 - (4,167) 8% 0% 50,000 50,000 2,500 (2,500) 8% 0% 30,000 30,000 5,833 (5,833) 8% 0% 70,000 70,000 708 745 37 8% 9% 8,500 8,500 3,333 4,813 1,480 8% 12% 40,000 40,000 167 13 (154) 8% 1% 2,000 2,000 647,759 44,118 (603,641) 8% 1% 7,773,121 7,773,121 6,509,094 6,729,084 219,990 8% 49% 13,634,456 14,458,087 823,631 % Exp. 334,067 296,421 37,646 8% 7% 4,008,798 4,008,798 127,012 150,803 (23,791) 8% 10% 1,524,144 1,524,144 46,917 46,917 8% 0% 563,000 563,000 84,505 84,505 8% 0% 1,014,061 1,014,061 543,704 543,704 8% n/a 6,524,453 6,524,453 TOTAL REQUIREMENTS 1,136,205 447,224 688,981 8% 3% 13,634,456 7,110,003 6,524,453 NET (Resources - Requirements) 5,372,889 6,281,860 908,971 7,348,084 7,348,084 a) Approximately 85% of the property taxes are collected in October and November Health Benefits Trust Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % Budget Year End Projection Variance RESOURCES Beg. Net Working Capital $ 16,400,000 $ 16,988,140 $ 588,140 100% 104% $16,400,000 $16,988,140 588,140 Revenues: Internal Premium Charges 937,167 941,135 3,969 8% 8% 11,246,000 11,246,000 P/T Emp - Add'l Prem 4,167 3,063 (1,104) 8% 6% 50,000 50,000 Employee Prem Contribution 41,667 40,050 (1,617) 8% 8% 500,000 500,000 COIC 81,250 108,431 27,181 8% 11% 975,000 975,000 - Retiree / COBRA Co -Pay 37,500 59,395 21.895 8% 13% 450,000 450,000 - Prescription Rebates 8% n/a - Interest 8,333 12,337 4,004 8% 12% 100,000 100,000 - Total Revenues 1,110,083 1,164,411 54,328 8% 9% 13,321,000 13,321,000 TOTAL RESOURCES 17,510,083 18,152,551 642,468 92% 61% 29,721,000 30,309,140 588,140 REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-Dental/Vision Refunds Insurance Expense State Assessments Administration Fee PPO Fee Health Impact Printing Program Supplies Workplace Clinic Other Total Materials & Services Capital Outlay Contingency TOTAL REQUIREMENTS Exp .% 10,773 10,201 573 8% 8% 129,280 129,280 250 250 8% 0% 3,000 - 3,000 1,130,104 1,443,086 (312,982) 8% 11% a) 13,561,242 15,008,091 (1,446,849) 169,865 184,007 (14,142) 8% 9% a) 2,038,378 1,913,673 124,705 (1,898) 1,898 8% n/a - (1,898) 1,898 27,500 32,004 (4,504) 8% 10% 330,000 330,000 6,250 6,250 8% n/a 75,000 75,000 25,000 24,953 47 8% 8% 300,000 300,000 3,333 3,253 80 8% 8% 40,000 40,000 4,250 4,259 (9) 8% 8% 51,000 51,000 833 263 571 8% 3% 10,000 10,000 8,333 680 7,653 8% 1% 100,000 100,000 295 (295) 8% n/a - 295 (295) 3,178 1,552 1,627 8% 4% 38,141 38,141 1,378,897 1,692,452 -313,556 8% 10% 16,546,761 17,864,302 (1,317,541) 100.00 100 8% 0% 100 100 1,087,072 1,087,072 8% 0% 13,044,859 13,044,859 2,476,842 1,702,653 774,189 8% 6% 29,721,000 17,993,582 11,727,418 NET (Resources - Requirements) ' 15,033,241.67 16,449,898 1,416,656 12,315,558 12,315,558 a) Projection based on annualizing 5 weeks of claims paid. YTD actual is $325,039 per week. 8/17/2010 o ^_ O C C C Q > ✓ N O m N D } • m (0 2 7 0 CU 2 0 2 O E 3) 0 0) E O Z N E -9.61) N 0) CA 0 m } Q V 0 (O CO 09 O 40 0 00 (O p (n ✓ Ch l() O D- CO :D of 0'1 N n CD, O O CO cfi V d (O 0 M c0 M N V 4. O CO M o Oi r O 0) (0 0) N 0 0 0 0 0 0 c0 c, ) (O O O N 0 0 0 0 o CO O N O O CO o V 0 0 0 0 0 � 0 u) m O O n N O O O O C D r n 0 0) 0 n 7 V n CO O O O O O O CO CO r (D Q1C0 O O O to 0) 0) O N' CP M 00 00 n r Q) N r 0 OCO O O N CO N N to n V 0 r m O n n Ch. O to O N V 41 O 0) 4. V v O - O N m M --O M 40 r r r N CL) r .-- CO 00 u) W V O0) N 41- ,f) 00 n O000 M 0 CO ON OCP (O (") O O (O O r O n n N m O r Cl M O O D CO r n 0 C') 00 ti D- N 0 0 N n (D O r n CO O O 00 CO O O O u) O) CO O N m N 0) O (D m V .-- r(0 (D N (0 ON n 0) CO- N N to n V O r 0) N m 40 0) 1- N O0) V O cO N N O 0 0 0 ' O O 0 O Cr- V V y O 0 0 O CO ,I' O N NO n 0) 0) 0) O (01 O 'O O 0 U) N O CO CO O (D n 0 (0 CO O O O ' O 0 n r y O ' O V N' I am,' O P D ) N 0) (D V n O) n (D O V N 00 n M r .M... M V " n M O 0 0 0 O CO CO r - 0 CO (V O 0 0 0 0 4) N CO 000 O O ((0 r O ' O O O ' O O n CO CO O CO ' (0 r- .1.- .0- V .- (0 n (h N V V (O O O 0 0 0 0 O (O V N CO n n N O 0 0 0 0 0 O u) N CO CO (0 00 0 O O O O' O O CD n C+) lD ' ' ' r (0 n (h V r (1') (0 n O) n N yj V .-- r V N n CO n- 0 O O 0 0 CO 00 n Q CO n 0 CO (f) N O 0 0 0 0) M (O N CO O CO CO rLO CV O' ' O O O (O ' ' (C) O n CO CDN OO 0 N 60 N N (0 n 0) n O O) (D N N O nCO r V N O 0 0 0 O 00 CO CO co 0 0 0 O (O N 00 - (q co (0 O ' ' O O ' O CD 0 CO Crt. ' ' ' 'CV N N N (O n O) r if) r (O n CO ( ) (1) O O 0 CO V N N 0 n n (I1 O 0 0 LO N OO O O CD (0 O' ' O 0 0 n M CO ' 0 ' ' N N 0) n 0) r (D u) (n D t` n CO r v y O O 0 CO CO0 0 n v M o' O ' 0 L' M (0 N (O O n m n (0 N M n co ()] n co O c0 c0 O c0 ✓ O V N (0 . O co 0 O O co co 0) n(0 O O 0 0 0 u) N 00 a- (0 (() 0 O' 0 0 ' O CO n' CO CO ' p CO � V CD N O N 01 n n (`7 0) 4- n 60 r v N 0 0 NN V N 0 '3 0 0 V (f) N 00 t} N0'' r (D n ' M (O ( 0 O i O 0) hr. O) n N co N r O n )') N. O O 0 CO a0 n v r ('9 0 n O O(0 M u) N co t{ O CD O' ' O (f) ' N (D n M O ' ' N n 0) n O) r h N v R n CO r m o O o O O CO Lrir v v (0 v o CO V O a' (n o v o N 0 0 CO " N N O 0 (f) N O O ' 00 (D n ' M CO o (41 r m C) O n CO (O CO n o N V O co O O N O V O) co o (") n r 0) N r CD u) r (0 • n N O O M M O) o CO O (0 o ' CO CO CD O O V O) 60 0 C0 O) CD O CO CO 4-.. 0) N r (O n n ' M ✓ V u) O (0 (- N 0 a O in O d L u) 7 y N 7 N a)r0 • C > N (0 N O W C > U N Q) O a' N Z 7t d 7 (n c (9 ;� N i) W C> 0 a1. 'L C j C N NO -0' C Q - '17 O 2O'> o3U a2i m KU m m F -- u) -o )0 m W = (n O w' a= W' Q N C (n (u O C m a O C W .0 a O O- O O C O 0 _0 C O 2 Ta O C 't) C6 y U 'p ` U `�, C5 N> O) O. (0 O O N N O () (0 O .i OWH-(nU=c» c fr oa�U 0 CO 0) O (D O (0 O c- c., M CO O ' r ' (0 O Net Fair & Expo Center o CO CO V N 0) 0) O O (01 co 0) D N ti 00 N N CD (0 u) 00 CO N 00 CO 00 m N n N m O On O -O N C O ] r/) ✓ (D v ?` 0 0 (0 O i(i o 2 N W W it. v f t C O L G 0) E ,i U 3 D m W a> 0(� m ono � (U >. r z o U L m,- E s m t 3) 3) ��� E o m o 2 d L m N .N. N u) ,n N O___c) C> N O - C L ., ` N RiU` rrQ W Q_ y W O Om�C� �o Z zu Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY % Coll. % Year End Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 2,809 $ 9,639 $ 6,830 100% 343% $ 2,809 $ 9,639 ` 6,830 Receipts: Miscellaneous Vending Machines Telephone Fees - Events Special Events Revenues Interest Storage Camping at F & E Horse Stall Rental Concession % - Food Rights (Signage, etc.) Grants Interfund Contract Total Receipts Transfers In TOTAL RESOURCES - 179 179 8% n/a - 179 179 - - - 8% 0% 1,614 1,614 - - 5,430 5,430 8% 679% 800 6,230 5,430 75,000 118,044 43,044 8% 17% 677,742 720,786 43,044 - 176 176 8% 9% 2,000 2,009 9 166 (166) 8% 0% 51,000 51,000 - - 8% 0% 9,000 9,000 - - 255 255 8% 1% 42,000 42,255 255 40,000 40,708 708 8% 19% 211,000 211,708 708 - 13,000 13,000 8% 14% 93,000 93,000 - 2,000 2,000 - - 8% 0% 45,000 45,000 115,166 177,792 62,448 8% 16% 1,135,156 1,184,781 49,625 8% 0% 534,124 534,024 (100) 117,975 187,431 69,277 8% 11% 1,672,089 1,728,444 56,355 REQUIREMENTS: Expenditures: Personal Services 77,658 74,590 3,068 8% Materials and Services 39,724 25,723 14,001 8% Debt Service - 8% Capital Outlay - 8% Transfers Out - 8% Contingency 8% Exp. % 8% 931,893 928,825 3,068 5% 476,685 476,685 0 115,563 115,563 100 100 10,000 9,900 100 137,848 - 137,848 0% 0% 0% n/a TOTAL REQUIREMENTS 117,382 100,313 17,069 8% 6% 1,672,089 1,531,073 141,016 NET (Resources - Requirements) 593 87,118 86,346 197,371 197,371 Accrued Revenue (Accounts Receivable): Current Month Events 32,648 Prior Months 3,424 Total Accounts Receivable 36,071 Deposits Received for Future Events: 2011: August 90,020 September 5,032 October 2,720 November 4.550 December 835 January 100 February 620 March 500 April 1,800 May 1,600 June 800 FY 2012 & Beyond 6,730 TOTAL 115,307 r PROJECTION O Ln v c 7 LL U O C O O O • — U @ CO • 7 � U � _ r • U TD" 0 O EL 2E- a)I-- (0 C O 0) 0 (0 0 F— U a) � (7 -O CL CO NEW O Q) (p o 0 0 Encumbrances & Commitments r� 0) O) O 0) ILO N n N r M O O O O O O 0 O 0 O O O O O in v 0) C•1_ COW Ln 'Cr 0) LO N o0 M r` co O (o r` O O 0) ' CO N O' O O co co O t1) 0) co- v CO co 0) co O) O 0) N O O- M CO co1nco0v c7OOco r`O0) co v O O () N O in c0 O O Ln O v 0 0 0Ln 0) CD v O Ln co 00 COLO O O co in O N- 71- ' O O) O v O If) CO LC) c- M v 0 0 0 0 0 LC) O O O N O O CO Ln CO N CO LIQ O CO CO CO O 0) CO CO r•- 6) �0) 0 0 0 CO 0 c0 N N d- N ID O O N O O 0) 0 CD v v N 0) v v Ln LI) M co Ln Ln N CO CO O O r` O RESOURCES: N- CO LO LO 0) CO CO c0 o0 LD N N- C r- M CO- LO r- CO LO 0) O LO N N O Total Resources EXPENDITURES: 0) v 0) N In N 0 c7 c7 co co co Ln O M CO O CO r� O O) CO Ln rn v O N O r CO O CO IC) r-- O Ln 6 Ln r c v(. CO In O 0) O ' N 0) v 0) N I1') N O M M CO O CO Ln 0 CO CO 0 CO ti 0 0) CO Ln 0) v O N O c- CO 0 CO ID CMO O If ) N in a c- co ,71- O In co 0) O M N CO O 0) N N I N a) m •- _U 0• z m .0 (./) c 0 O U O ` otj a) 0) E C > V) C U a) a) 0) 06 C 5' O j i 0 U N • Li LL '� () O Ci) c 0 a) a� c >, 2 a) a c a) o E 0 U ca E v,� a) 03.c c c d a) 0 O' a.� F a) a) m a) • .L - c 2 O 1 3 O %<wHo LL¢ELD20~ Uz0 LC) Ln CO CO CO N CO C Lf) 0) v c0 v in - co 0r0 O co v O r` r` N • • 5 T 0 C 0 Total Expenditures co H -c Z W a) 2 c) O O UCN m Q aZM co Q U � � W 2 .2 U o EL • Q C • U CD W O Amount Paid N O N N N- Lf) N N O CO N O U') I- CO O N CO CO CO N O I— O - N- CO O f� N O 00 U7 CO O) - CO N- CO N I- CO CO CO N CO N O) CO I- O CO CS) N- O) lf) O) In O In N— CO CO In a0 - N- Ln O N c ,— 117 = Cfl O a0 co- M N a0 CO N M M a0 Lo r CO r N CO N N CO CO N— N N N— N— N— N— O 0 co �0 co; rn 0 co M a0 Lo N lNf) — a? a) to Efl p 0 M U 0 N cO o N o o O CO CO O o op > 0) N • `J °� �� o 0 0 N'- a O co o 69 O O o N O° o O o p 4-00 �0 00 : (•-.) �0 00 �cfl co O O 00 CO C p lO co p o N o a) 0 0 o@ —co .0 N O CS)o ▪ u) rno o U���� cfl N C O CO °o 0 .a) E R ea luf) co co ',1) Eia O U o di .E O O O CS)c • m C_ Cr 0) 0 sC°� o c °)cn��6 ° ,q,80 Cla --, 69 o �� o� o CO NC-cc o0 CO TC C U CCo O O1• . Fm O O) o Cp.. �•03 ' O O o c@cCo U o OW X co fi NO (73 Q) >' UU O' op , U N N min o Ca..O N@ o C °S � 6C CL) CO C O (13 D>, 7:10- amU ��° ai CI) ` COQ mO2 -• E E c °• U�U c 2 m Om cmaiCO a) a) U (o m ox — o= m o p p uvoa°°U O io U) ID C_ cz 2 «Q52li5 _ 9 C O N CO Ln 67 Ln O N CO O m co ,— N CO to co O N N N N N CO CO CO CO LCA Architects LCA Architects Total Architect Engineered Structures Inc CO N N N c6 c0 co ir) - - Total Chance Orders Total Engineered Structures, Inc. 5,018,187 vi C a) E E E O U a� a) C_ -o E O U UJ (:1 F.. PROJECTION J H U @ O H N a) O) O D 0_ co a) co O o 0 Encumbrances & Commitments Received and RESOURCES: CO N I"-- CO r-- co- CO -coCO O) CO ti ti N (NI CO CO Cr) CO ti r co r- N CO- N CO o Ln CO N CO CO N CO M • N CO 0 CO (T 0 0 N CO 0 cr CO O O O) Cb Ln Ln O) N CO N CO • N CO 1— C) (T N. co CO CO O r -- co- (0 co- 0) Lc) (0 N- CO N CO CO CO 1— CO 1— Cr) Cr) I� - co CO N O 0 N- CO CO O (3) (n CO N CO CO C) N CO N M CO CO EXPENDITURES: Materials & Services �t CO LO CO V Ln CO r O 0) CO (7) ' ' V CO CO ' V CO CXJ 7 N CV- 71 - CO C) CO LO '1- CYC CO 0 N CO V O Ln 0 0 I- • 0) C) 0 CO (7) (7) 0 CO Cr) 0 0) 0 O(0 CO 0 cr CO 0 1.0 N O N I- r N N I� tf) N (3) N � O CO 0 0 V 1— N 10 O I- O O O O O 10 O O O O 0 1—' 0 0'' 0 0 co O ,— O N Lc) Lc) r-- '1- ' 0 CO 0 h CO 10 Ln O N • CO CO N O) (7) CO CO (T Cr) CD O O N CO CO Ln cr CO Cr O L() Cb O N N N CO N N O) r-- 00 00 0) (0 N N- 0 CO O I- (O cr CO Ln 0 N '71 - ▪ CO CO N () 0) CO CO (n 0) 0) N r Cr) N CO CO Ln 7r co O (6 O N N (. N N Architecture/Design co O N C) Cr) O CO 10 CO LO CO (O O CO M (7) CO c0 (7) CO N CO (O O Cr) CO a) (n X a) U o _ LL ' O U °2S y O >, CO O O I- N O O 0) I-- O ' 0) co O (0 O N O) N CO LO 10 0 0 0 I- 0 CO Ln 0 0 0 0) 0 o0 0 0 0 CO- Ln 10 6) - CO C`7 O CO CO I- N CO N '— N CO O) N 1— I-- O O O I-- O O O Ln ' ' O O O 0) CO N d Ln N CO CO- r- N- ) 00 O CO ' Cr)c0 () Ln CO C) cr 0) CO N 0) N CO O cc , i (0 ti (7) O 10 O O 10 Lc co CO O C) N 0 rt 0 0) CNI CON r (0 r 10 O) CO N C0 CO ' I- V co r (o cCr) LO c`) O) V N CO co (O Ln O) N c0 co cr N N- 1- N- N CO- r• U z a) 2 to u, E (a a) o o) c.:5 .• o 2� coo a) c Q Q L (d CC; Cii cu (� a o o 3 0 :� E m o U (3) c c c d (T v �O o c To me o c0 c L oO 3-2 n E_E5 o Ouci ~ wl-d c U < J02 UZDOOU H� Total Expenditures 10 z PROJECTION O U � Q) ❑ a Received and N c Q) 0_ X W RESOURCES: O N O 0 CO 0 N O O CV(f) LS)n CO N CO C'7 O CO N (f) CO CO N CO c) r- 0 CV CO- CO LriO (C) CO CO N CO c) CO N (O 03 CA 01 - CO C CA (D (f) (D (D (D M ▪ (p in0-71- Io0) O• co C0) ' co CO CO CO ("\iN- V CVC') .7t CO CO O N CO rt 0 10 0 0) O • 0) CO 0 C9 0) 0) 0 00 0) O O d' 0 CO CO CO 0 CO 00 0 N- N O N N N �- O CO O 7t CO (0 O r O a0 O - N O N O O ' O rt O co O r- O co in O (7) N - CO CO N 0) 0) O CO 0) d- 0) N- O N CO CO U) ,zt CO CO i co- 7r. O N � N 00 CD O ' N N- O co O r co a0 in O 0) N - O CO — N C7) 0) CO CO 0) 0) N'Ch 0) N (O CO (0) r CO CO 71- CO 00 �h O N r- r N CO N 0) N 0 (0 oo (n N (o r- 71 - LO ()0 CO N 0) CO (() CO co 0) (0 N CO N ()0 CO N O U Q) (n U N cU (a 0 _ D U w V)00 4 U Z a) Q) co O () c ❑ U c ' c c N vi a) a) (T (�s L ca o E (ll '> 0 L a O 0 Q o, o CF- (KS • - • 0 a c _ c.T-o aa 0 m c c ca•- n O— U . p O Q) O X w co<L1J1-0C CLLQ a.D O -c-..- ZDO m 11 C F- (o 0 (C) 0) co co (0 co N (0 N CO (0 N 0) N (o 0 (O (0• r CO LO- CO 0 03 N N Total Expenditures V D D 0 Z Amount Paid 0 Q U a) 0 co 0 0) o CO p N tt N -- CO O O O CO N Total Architect 0 O 0 O Lc) Interior modular walls Herman Miller LO 0 ti CO 0- 0 1- CO CO 0 N O 0 CO CO `- CV 0 7 O `- - LO CO 1 - CO CO CO CO 0) - 0 CO 0) N- N 0 0) CO N M O) moi' co) c- I— L() N 1- 0) CO CO d- 0) 0 LO 0 0 CO 7 CO 0 `- N LO CM O 0 0 00 - co -71-O) ti `-- coN O CO CO 7 t- 0 'Cr 7 0 d - N -CO CO N O ti N 7 CO CO 1- co 0 d' 71-O CO N N 0 O co N M O O f` O? co f) N CV co- LO M d- M O �j ticv EA O N 0 69 O O ,— co M O N p Oo Oo CO tO f) OS--' o O(NIO M NN.NQcp o O OO E/5 0 N E 0 t '71- OOO `�Cmt`NO O `.- 0p0 CO O ttp o • 64 CO M o C wcc Ea 64 O `- SO oM O n O (‘5 °- 6NCO a 03 O .='(�o�Voc���� o .> > 0 o �r - 76 �. - O 'cr C U 0_ 0 D -O "� 0 U ca m O C �, is o o a' ca w o .2 ca 6 o 1 .LE U n C O (a Cll (6 (U O U (a U O (> .. o C "_ 'D a) (a (a . U -2 U•• C O T (.__0) C a) C o O o 2 2 o 7 °) 7 CJ c`a T° 7 a Q c 0 m i n 0 (a N O (a U C U C a_ 3 E 0 N E 2 2 c.) > ,s To 0 — CJ:... 0 7---D(i)D <0�< 001a) oMn22E-1—ww -) C 0)2 Q D u_ O O C r N M L() CO CO O N M LC) CO r---- cr)O S m ca 7 NCO 1` co 6) e- r `- ,— ,— N N N N N N N (NI N M M c� N ) OU It*kIt*k4t*kIt *k ItIt*kIt*k*kIt*k*kIt**k4t t f. Engineered Structures Inc Total Engineered Structures, Inc. O O CT CO CO 0,1 Total Encumbrances & Commitments O U 0 N (6 0 a` -o Encumbrances & Commitments Received and RESOURCES: COLID LO C) M CO 67 ' CXJ CO Federal Grants O O O CO - CO O Total Resources EXPENDITURES: Materials & Services N M c- Cp co Cf) Cp O O O O O to CO cl' N O CO c- oo O O O 0 ti O O O O to N N O N N CO R1 0 0 N- 0 0 0 6) 0 0 0 0 0 0 0 0 O O O 000000 CO �- lO O (0 O u5O M c- N- "71- 0 CO N- (0 CO N N N- L- O 0 0 O O 0 0 0 0 0 0 CO CO 0 M O N Furniture & Fixtures N 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C.O co- CO O CO c)- ,7)- r O O r- CO CO N C'7 co co O 67 O) I 6) 6) c- 6) CD 0 O O 0 0 (5 CO- M (0 (.19 N O CC)CO CO r �t 0 1 N O 0 0 0 CO CO CO 6) CT O) • E 0 — LL c Cll c6 U 6 0 O 0 .r c 06 c a) 0 E LlJ co E CD > a) 3 fX Cc P E O N 0 076 J N L O >, C> Cn >, CO .O E. E U 0 o (3) a °6 co 5 .5o_ is p '03_c _o aY.?_ 1 Q C C O'a 0 7 L` < ~ D Z U) CO Z 0 w . l c _ U_ U N n p r' z d Q (1) W U 0 LL Q Q X z2 0) Z W Amount Paid 0' O CO CO V V N a) 0 V 71- a)" a7 O7 0 co 0 0 O7 Radio Dispatch System in V 0) 0) PROJECTION 0 U N o 0 eL y O U C U (D E E O C U W ors RESOURCES: 1-00000 0') 10 10 10 10 CO O O O O N N O CD CO N N f— O O O O O O O O O O O M O (. O C(') N TT N- CD O CO O TT O) O M O N CO O O M CO O N N CO CO LO N N N- O M O TT O) O M O N CO O O CO 145 O N N Cb CO CO N N N - State Grant i m O d a) C W c) 0 cc .0 Th. 0! 0 • 0 O H a C F„ EXPENDITURES: CO O 0) — N 0) co co co co O O N 0) O CO V O N CO V O ' O Ci) N CO N N Mui LO 10 N CO CO CO V O 0) CO N N O) O M t— Cr) '71- 00 CD O CO Cr) N,- O Cr) O) N CO V O I� CO O rt O O T- CO r CO N- CO CD CO CO M CO M N CO — O) N N T- M M TT TT CO 0 0 C0 O N O O CO O 0 O 0 O O 0 0 N-- 1.0 TT 0 0 0 CO 0 0 CO 0 O O 0 O CO C7) 0 O 0) CO CO O O O ' M N O ' O ' N. N I� Cr) N Cf) O CO N O co 10) CO TT O N- o Ct O 0) N CO O) N CO N- Cr) CO CD 0 CO 0) N co 0) 0) in V O N- co N CO O.— CO 1— N CO CO CO Cf) O N CO CO CO N O 0 C!) M ' of (0 O rt 0 0) N CD 0) N CO N- Cr) N- CD Lt) CO O) N CO 0) c- O) C5) rt CO N-- CO N CO O 1 CO N CO N CO CO 0 NO CO U) CN r CO O CO CO N TT TT N 0- N O O V Cr) CO CO O CC) O M O O O O O N O u' E °) a) m .c V a) E y O E a) 0 Z _amU)co 0 0 UC CO_ O j CU •� y Cr) y 07 C EO. 0 w >, C E .Q C a) U m ca .0 cc Eo f0 O C C w O U c C O - 0 .0 "O •� C co`F. .D O o F- N Q 111111 J 0_ c li 0_ Q D•a I- c U F U Transfer Out Debt Service Fund Total Expenditures 0• co CD Co 4) Z U a) O O. O a) co co co > co O f u) O CO a) 64 0 o O• O Na, U O C a_ U1 v O U a) O U 7 C O O N N Cf) @ C O.-. O O T O _a o O a) N co 'j O as a m a) C _ 0 O a) (1) 0 C C > O C6 0 O U O C U co O Cn co /7 CO w- r M O CO C41 rsio CN U y + O O r /) .0co N y CD U Q 4) 0! 0 2Q1_ a O C, — O C O C\_ 0 maw-, 0 a) C Q) 7 Toa co Amount Paid C E c E O E Q U c O U a) 0 O a) In CO 7t' O CO CO CON O N - LO (' O (6 C O O O O O N - ti -o a) U x a) O 0 U a) o a) u a) a) LE E Q Pinnacle Architecture Pinnacle Architecture CO O O ti ' N O O O) LD CO CO O CO c`') N O CO O CC) CO LO O CO- N N O OOO 0 C O) O CO iOf) O O IOCD 0 O V O CO- In O O N 7' N -ct N N O) N CO U CD c) O Q) O a) a) c •— c a C a C o a)) U (.1)C •-o U c) c C Q U W J (n < Pinnacle Architecture Pinnacle Architecture (1) — -o CU (o C_ CD a I • (3 ca Q) C O U c C O oU U C z (0 C oU U Li (i co • c s U io c O n3 a C _ O C ' O (a U vci o C E 112 co C a nz D U a 0 oN 1k *k C "O 0 C 0 CD C) C) O CO CO c`o C.) C.) U < H Change Order #3 co co O O c`') c) co co O O O I� 71' CO coOCO- O ti Total HSW Builders [Engineering Contract Deschutes County - Solid Waste Area A Closure and Cell 5 Construction As of July 31, 2010 "Area A" "Cell 5" Landfill Closure Fund 611 SW Capital Projects Fund 613 Total G. Friesen Associates, Inc. Original Contract Change Orders: Change Order #1 (Note a) Total Paid through July 31, 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 Change Order #7 (probably not occur) Change Order #8 Change Order #9 (pending) Change Order #10 (pending) Total Paid through July 31, 2010 Balance 241,869.00 19,656.00 261,525.00 254,413.43 7,111.57 2,097,140.50 14,302.54 24,885.69 152,500.00 1,332.00 182,516 00 182,516.00 153, 904.43 28,611.57 3,290,779.98 45,094.00 152, 500.00 148,958.89 225,000.00 424, 385.00 19,656.00 444,041.00 408,317.86 35,723.14 5,387,920.48 45,094.00 14,302.54 24,885.69 305,000.00 148,958.89 1,332.00 225,000.00 2,290,160.73 3,862,332.87 6,152,493.60 1,707,132.00 2,054,537.51 3,761,669.51 583,028.73 1.807,795.36 2,390,824.09 Total of Engineering & Construction Contracts Original Contracts Change Orders Total Paid through July 31, 2010 Balance 2,339,009.50 19,656.00 2,358,665.50 1,961,545.43 397,120.07 3,473,295.98 45,094.00 3,518,389.98 2,208,441.94 1,309,948.04 5,812,305.48 103,938.23 5,916,243.71 4,169,987.37 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. RESOURCES: Beg. Net Working Capital Revenues Grants - Private Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Debt Service: Negative Interest Revenue Interest Payment Deschutes County Bethlehem Inn (Fund 128) One Month Ended July 31, 2010 Year to Date Budget Actual Variance FY Coll. % $ (2,725,000) $ (2,722,510) $ 2,861,000 2,861,000 2,490 100% 100% $ (2,725,000) $ (2,722,510) a 2,490 - (2,861,000) 8% 0% 2,861,000 - (2,861,000) - (2,861,000) 8% 0% 2,861,000 - (2,861,000) 136,000 (2,722,510) (2,858,510) 8% -2002% Exp. % 136,000 (2,722,510) (2,858,510) 36,000 2,054 33,946 8% 6% 36,000 36,000 100,000 100,000 8% 0% a) 100,000 - 100,000 TOTAL REQUIREMENTS 136,000 2,054 133,946 8% 2% 136,000 100,000 NET (Resources - Requirements) - (2,724,564) (2,724,564) b) - (2,722,510) (2,758,510) a) July 2010 interest expense - $2,054.36. b) Recap of expenditures - inception through July, 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 206,652 Total expended $ 2,724,564 Year End Budget Projection /ariance 2,490 100% 100% $ (2,725,000) $ (2,722,510) a 2,490 - (2,861,000) 8% 0% 2,861,000 - (2,861,000) - (2,861,000) 8% 0% 2,861,000 - (2,861,000) 136,000 (2,722,510) (2,858,510) 8% -2002% Exp. % 136,000 (2,722,510) (2,858,510) 36,000 2,054 33,946 8% 6% 36,000 36,000 100,000 100,000 8% 0% a) 100,000 - 100,000 TOTAL REQUIREMENTS 136,000 2,054 133,946 8% 2% 136,000 100,000 NET (Resources - Requirements) - (2,724,564) (2,724,564) b) - (2,722,510) (2,758,510) a) July 2010 interest expense - $2,054.36. b) Recap of expenditures - inception through July, 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 206,652 Total expended $ 2,724,564 Deschutes County General Support Services - BOCC Conference/Seminar, Education/Training and Related Travel Expenditures FY 2011 Tammy Baney Conf/Sem & Educ/Training Travel Meals Accommodations Mileage reimbursement Ground Transport/Parking Total Baney Dennis Luke Conf/Sem & Educ/Training_ Travel Meals Accommodations Mileage reimbursement Ground Transport/Parking Total Luke Alan Unger Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage reimbursement Ground Transport/Parking Total Unger Other Conf/Sem & Educ/Training Total Other Total - BOCC Department Conf/Sem & Educ/Training Travel Meals Accommodations Airfare Mileage Reimbursement Ground Transport Total - BOCC Department Jul YTD Total 1,133 1,133 1,133 1,133 Romms FY 2011 Budget Percent of FY 2011 Budget Expended 1,133 1,133 20,100 5.6% 8/ /2010 0) a) 0 O a O) O O 0 O _ O O N O C c C O • (11 O v y 0 a) 7 � L O Y O ❑ O m 0 E Z T CO CO (0 a) C a) . 0) N cv 0 a (13 0) (0co 06 LL CO 01 ✓ • CD V COV O7) F M . M 01 0) r- ti N ' N (n 1111- r- r- r co O co co M .- •t - It) (n CO 0) 0 CO N • N co O ✓ 0 M 0 CO M (0 h M O ll) (n CO ▪ N N N N 00 N • r ((1 r N O '0 'et ( CO COOD CO air W r n CO N r CO O (0 (0 01 r- N 01 (( M (~ N CO 00 st Q Senior/Child Total Daily Passes Season Passes 7 Q Senior/Child Total Season Passes (0 (0 of 0) n N O 0) M M CO 0) N (0 10 (0 (0 N W O r CO N N O M Total Tickets Sold M N M co ' O r -- co M O) N O) ti O) CO M M N 0) 01 (0 (0 0 O CO 00 O O 0) I0 01 11) CCt. 01 N O) O Total Estimated Attendance M� 0) 0) o M N 01 0 N tt (N 0 'Q O 00 i