The URL can be used to link to this page

2007-1604-Minutes for Meeting September 24,2007 Recorded 10/26/2007DESCHUTES COUNTY OFFICIAL RECORDS p} NANCY BLANKENSHIP, COUNTY CLERK w 2007-1604 COMMISSIONERS' JOURNAL „1„„1 1,,., 10/26/2007 01:48:58 PM 2007-1604 Do not remove this page from original document. Deschutes County Clerk Certificate Page If this instrument is being re-recorded, please complete the following statement, in accordance with ORS 205.244- Re-recorded to correct [give reason] previously recorded in Book or as Fee Number and Page A& A 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, SEPTEMBER 24, 2007 Present were Commissioners Michael M. Daly, Dennis R. Luke and Tammy Baney. Also present were Dave Kanner, County Administrator; David Inbody, Assistant to the Administrator; and Anna Johnson, Communications; and, for a portion of the meeting, Marty Wynne, Finance Director. No representatives of the media or other citizens were in attendance. Chair Daly opened the meeting at 1: 30 p. m. 1. Finance/Tax Update. Commissioner Baney said a citizen asked about his road district and work that was done in that regard. Mr. Wynne replied that special road districts are their own entities and handle their own contracting and work. The only time the Commissioners are involved is when they are asked to appoint a new member if a member resigns mid-term. The County collects taxes for them and disburses it as appropriate. Mr. Wynne stated that the City of La Pine has four different tax codes, somewhat based on whether they are part of the rural fire protection district or are assessed by the Department of Forestry. It will likely be confusing to the citizens who receive their tax bills in November. There will be increases in all of the categories as well. Concerning the investment portfolio, the recent drop in the federal rate will impact the basis points. The average yield should hold for a while, but when tax money comes in some funds must be invested at that time, regardless of the rate. Regarding the "big ten" departments, the Clerk's income is still down and the overall negative impact could be over $400,000. Home building is down and there are fewer permits and recordings. The beginning balance is strong, which helps to offset the lack of income. Minutes of Administrative Work Session Monday, September 24, 2007 Page I of 5 Pages Several positions in the Assessor's Office remain unfilled. Revenue for mental health has increased somewhat, but only new programs can be instituted. In regard to 9-1-1, some projections have been drawn up for the executive board meeting tomorrow. They need to decide what they should approach the voters for. A new category is a debt service amount for a $3 million capital expense. They may not go out for a vote this year; it could be next May. The RV park report does not show the $30,000 change order from the RFP process; this issue has not yet been worked out. Solid Waste has an estimated contingency at this point of $600M. The work center remodel shows no revenue; it is just a budget within a fund. It should come in within budget. In regard to the Solid Waste arbitrage rate, after three years it will become a liability. You can bring in as much as you want from bonds as long as you spend it within 18 months. The Bethlehem Inn loan will show a net loss for some time until revenue comes in. Commissioner Luke said that at least the County owns the land, which is worth a considerable amount. 2. Project Management Update. None were offered. 3. Capital Projects Update. None were offered. 4. Continued Discussion of Parole & Probation Domestic Violence Caseload. Dave Kanner said he is trying to figure out how to get the funds for another Parole Officer. The easiest way to fund the position is to not fill Becky Wanless' position when she leaves. This saves about $77,000. A Parole Officer would cost $52,500 through the end of the fiscal year. minutes of Administrative Work Session Monday, September 24, 2007 Page 2 of 5 Pages He suggested that Ken Hales be made Acting Director of Parole and Probation, with an office there and also at Juvenile. They have budgeted for two more positions and do not have room for offices, so one of the conference rooms may end up being converted. The management team is supportive of this idea. Commissioner Luke asked about sustainability of the position. Mr. Kanner replied that general fund would need to subsidize it as in the past. General fund subsidies to the Sheriff will decline as transient lodging revenue increases. Also, the 1145 split is being evaluated. In addition, a cable franchise fee may bring in revenue. Part of the transient lodging revenue could go to the Fair rather than general funds. The Parole Officer position may not continue after the end of the fiscal year and any applicant would be made aware of this. Commissioner Baney asked for an explanation of the caseload and how it is handled, and why additional help is needed. Mr. Kanner indicated that any new money only can be used for felony cases. They cannot assign someone to just one type of caseload since the cases are scattered all over the County. Additional work would be added to each Parole Officer. An additional person would help make the numbers manageable. They still have 60-70 cases per Parole Officer; adding the misdemeanors increases this. Commissioner Luke said that the state only provides funding for felonies; the misdemeanants, including sex abuse and domestic violence offenders, are not included and this work is subsidized by the County. The Commissioners would like to see an additional analysis of the domestic violence and sex offender caseload. DK said Ken will analyze how the dept is structured and whether a full time director is needed in the future. TB asked how the diversion program affects this caseload. DL the total cost is more than the general funds into P & P. There is a cost to monitor the programs and offenders. He will support a new PO through the end of the year but what happens next year is unknown. Commissioner Daly would like to know what GPS units would do, and how the existing ones are working out. He feels this newer technology will help a lot. Commissioner Baney said that long-term monitoring has been shown to work much better than short-term. Mr. Kanner said that the Sheriff and Ms. Wanless have been limiting the number of sanctioned beds at this point, which has reduced the need to matrix. Minutes of Administrative Work Session Monday, September 24, 2007 Page 3 of 5 Pages 5. Other Items. The group working on the indigenous fisheries issue has asked who the representative from the County should be. Commissioner Luke has volunteered, along with the assistant of Joe Stutler and Peter Russell. Regarding the landfill ribbon cutting, it will be held for the departments on November 19. The Chamber charges to publicize and coordinate another grand opening. The County can publicize it, and October 23 is almost two weeks prior to the facility being operational. Commissioner Luke feels it is important for the Chamber to be involved. It will enhance the relationship between businesses and the County. Mr. Kanner said that it is important for the media to be there when the trucks are coming in. Commissioner Luke suggested that the Chamber event be called under business after hours, separate from the ribbon cutting. Commissioner Baney stated that Family Access Network dollars may be looked at as an administrative change, and the County may lose the Medicaid match of $650M. Further analysis is being done to see if this can be salvaged. Millard Fuller, the founder of Habitat for Humanity, will be in Sisters this weekend to speak. Commissioner Luke stated that the White House liaison will be in town this coming week. Commissioner Baney will be attending a meeting in La Pine at 8 a.m. on Sunday. Commissioner Luke stated there are some issues being raised due to the COIC's consideration of a business loan. Commissioner Daly said that the last he heard it was being reevaluated, and the claims of what kind of services will be provided, the type of insurance in place and other issues are being examined. It will be before the full COIC Board for consideration at its next meeting. Minutes of Administrative Work Session Monday, September 24, 2007 Page 4 of 5 Pages Commissioner Baney stated that she understands that a homeless camp is being set up at China Hat Road and Jan Ward, who is the owner, said he doesn't care that they are there and because it is private property, nothing can be done about it. Being no further items to come before the Board, Commissioner Daly adjourned the meeting at 3:10 p. m. DATED this 24th Day of September 2007 for the Deschutes County Board of Commissioners. M. Daly, ATTEST: Recording Secretary D nnis R. Luke, Vice Chair jo~o Tammy, aney, Com issioner Minutes of Administrative Work Session Page 5 of 5 Pages Monday, September 24, 2007 too a 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 - FOR THE WEEK DESCHUTES COUNTY BOARD OF COMMISSIONERS 1:30 P.M., MONDAY, SEPTEMBER 24, 2007 1. Finance/Tax Update - Marty Wynne 2. Project Management Update - Susan Ross 3. Capital Projects Update - Susan Ross 4. Continued Discussion of Parole & Probation Domestic Violence Caseload 5. Other Items PLEASE NOTE: At any time during this meeting, an executive session could be called to address issues relating to: ORS 192.660(2) (e), real property negotiations; ORS 192.660(2) (h), 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. Ifyou have questions regardinga 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 September 24, 2007 (1) Monthly Investment Report (2) August 2007 Financial Statements - includes a financial statement/projection for the Project Development Fund (140) o c ' O M c co E O CD co V O ~ = O N r+ C CEO d tR tU ~ m CD y OD ' w O LO LK N M _ C Cn N D v O 7 Q C O N O N ( o ttoo O t+ N N U c 0 O o ~ E z EF? a !R V N a~+ C C E C 7 y O tj O E~ c U m N dj 5 (D E C E en y Cn J > C ~ C C O N H O C7 0 o o e O CO) ~-v OOOOON O C,CfOC4OM O V CD LO r-_ 0 O In r r- O Cl ' to ' O 04 CO r- O tG c M to to LO M 64 N C N N M ~ w N •O 0. 0 CL m c C a) E U CO Q H G> a) 0 C E U N(D Co a) a Y a ~a o .9 ~ N cc 0 U1=::j LL mJ H i 6 N C O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO O O O O O r- co N O LO U) C ~ O 3 O v> Q 2 ~ to Y F- Y V O C C la co C6 Co C CO cc CO O Y w 41 .V i m m co U ii Y Y C6 O N Q' rT. C a) > O Q w c0 C m M U) C CO 2 t6 T > 0) m :3 LL Y Y E E7 E a) .L.., 'C m fA 7 d N m co U U (n Z o o 1.-0 0 0 OOOLoLO O OO1-- NN N r r N E U E rn ca O a) O X a U CD V d c c Cl) co < O ip t a) (D H d d0 C N E -i L LCD U V L m N (D o ~ N V o c LO Q C (D (D N V e d H r M > C U T m O o p a at E ° 0 N H H 00 m c) a J ° m m m m m a m m m m m m m a m m m m m cu m H m a m m m m m m m m m m m a m m m m m a m a m a m m 'm m m a m m m m m H m m a m m m m m m m m m a m s m m a m s ° : ' e ^ ~ a m m m m m m m m m U w U m m m m m m U m m m m m m m m m m m m U m U m m m U fff~ pppj m co m U w m m U m m M ~ a ~ . 2 0 p A w 0 p w N p 0 m U O O O O U O O O D U O O O O O U O O D U U O O U O O D U O C O O O O D U 0 U U M O O M, O U 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 - - - - - - - n O w O M M O O O O n w 0 O 0 O 0 O 0 O N N O O M M 0 O Ln 0 0 0 0 0 0 Q7 w Ln w n O O MM M M n w w N 8 - 'N - - O O o 0 - n 0 - n ~ 0 0 o w - w n O N o O o O a N to eT n m p O O n N w n 01 C C y co O w 0 M 0 O 0 O 0 w w 8 O o o a N O O n O 0 w 0 O 0 L0 0 0 0 0 0 O) w w w n w O O M M w O w w w o O N N 0 0 w O 0 0) N O O a0 M N O n n O O o o n U) O w A O V co (6 m E O N O O v O O 0 0 0 N 0 10 O O M M q L0 O w n N aD O N n O O N 0 w m N N O O O) N W O O M w On) N O m O W O 0 0 M w 0 O O 0 O O 0 R) 0) 0 O O 0 N w N W w l(7 R 1n O N N O O N O O O O m n ^ M cG w 0) O O N M (A M w I- n 0 Of W Ln L0 w t0 M O O In M T w O fo w w Ln n N n O n M N ( cc w ( o n ( Np N N N N N 0 N 0 0 O O O O O O N O O O r r N N w V w N O (O r M N C N N N N N N N N N N (V N M N N N N N N N N N N N N N O n In r (D O C4 r 60 cn (o U) t M o O H O O O O O O n w 0 O 0 O 0 O a) n O O o 0 0 0 0 0 0 0 o 0 0 W O O O O w (D O o O q O O O O O O O O O O O O O N O N O (n O O 0 O 0 O 0 O 0 o 0 0 0 0 0 0 0 0 w O In n m N O C n v N V_ O w 0 w O (n G Ln O , n N 2 w w A M o O O o O O O L0 N W A 0I N O O 0 w M 7 w w 0? N M O O O C Nw M Of ' N Q) N N O) w O O 0 o O 0 O w C N w OO O O O N w LL7 O N O N w LL7 N M O O O o a0 w O V v O 0 0 G 0 O O 0 I N G 0 0 O 0 0 G 0 0 (o N N N 01 o 10 O N m O U O Ln D) 01 a O? n M w 01 C O ] l[ (0 W TO w O O O O w n N N Ln D) O O O O W O) O n O O n w w w n n O O O o w 0 V O O C LA n cp C; n w O O D) w 1~ Oi w O O w (n 10 O 0 O 0 n w 47 M N a U' N N O N 0I O O) a1 0 N 0 M 0 N 0) 0) 0) 0) 0) - 0) w 0I O N O) O N O N n w O v (n ^ w T N ~ J • mp 0 m - - - - - - - - - - - - - - - - - - ' ~ tp m O. m w 0 0 O M CO 0 O N 0 M 0 w 0 'o V 0 47 W 0 w n 0 O 2 o O O a O L0 o O O) 0 O L0 0 V O 0 o w 0 I0 a 0 O O o N N v O n o O w 0 O O) 0 O w 0 O N 0 O O 0 O N 0 O w 0 O L0 o v o w O 0 O 0 O 0 M 0 N 0 O 0 N 0 0 0 0 o LI7 e Of O 0 O 2° (o w a m ' C m ti m c~i ¢ H U a m m m O N In 0 Ln Ln M M ' O ' M ri M M N i N 6 N er N N . . O N q ^ ^ O O Ln M O M M N M Ln M O V n N O n M N N M N O • ` m m ¢ ` m C } U) U ) U ) L LO Ln r u L 0 0 0 w 0 0 N Ln ri n vi ri ri I vi vi ui ri ri ci ri v vi ui tri Ln of ui o E m ~ m Y LL m o I I oo l U H 7 .1L m F c o ° 0 0 o e o 0 0 0 0 0 0 0 0 0 0 o e o 0 0 0 0 0 0 o O CL y o o (n M ' o o 0 0 0 o 0 Ln o o o co (n N o (o o w o Ln 0 U) 0 (0 0 o 0 0 00 0 o w n 0 o 0 In 0 Ln o o Ln n LO (n O (p d' r) M ` M N LO Ln M N N N Ln n M (o CO m CO m N LO N Ln w N M r 7 L0 10 C O0 v 0) V M LO M LO C U) M V) N iy O U m - - - - - - - - - - - - - - - E o a; w m p > m a w N y E a • ° c 0 m I a i m z fn ~ O Q O T m n n 0) v w w w N - O n L0 M 10 O w 7 00 co 3 M ~ M w M C2 w M C w N w 0 (0 M V n M 0 a0 M o N V M w w M O w w n w R W n ,r L0 v n n (0 M M M w n co o w w M M M V c E m C M I z 1 w w n v v L0 Ln u n n n CCC G Q y An o 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 n 0 co 0 w 0 w 0 w 0 w 0 w 0 w 0 w 0 w 0 w 0 w 0 w 0 ww 0 0 w 0 w 0 w 0 w 0 w 0 w 0 0) 0 rn 0 0) o m Lm C p (7 0 3 m ° L0 0) G ^ N M O o M S2 n 0 0 N a 5 o to ! R N M O n w N O N N N \ O L0 N w N W N N M N w N R I et O C Ln O n_ a N O V E m W Q7 W W a 0 0 0 0 N N N N M (1 M C n f~ fzz a0 w co W O m « (0 0 0 0 0 0 0 O O O O O o o 0 0 0 0 0 00 0 0 - ^ O O O Q O O O H - - - - - - - - - - - - - - - - - - - - - - - - - - - - H J m y Lp w n O O ~ w O n O n O w O n O n O w O w O w o w 0 n 0 w 0 n 0 n Q n 0 n 0 n Q w 0 w 0 n Q w 0 w 0 w Q w 0 n 0 w Q w w 0 0 w 0 n Q n 0 n 0 n 0 n 0 n 0 n 0 n O ` N N 1 N N N ~ N O (h O (O O r O O ~ (O V N N O 0I N V N O 1~ 0) N - N ^ O I O) O M M n (O O f~ N ^ (h ~ (n " j 7 (L ll N 0I 0 0 (O 0 M 0 _ Ln 0 M 0 L0 0 n 0 ~ _ O O o O n O ~ ' O (p O ~ O ~ O z ~ O N N N N 0 N O) 0 N - N N N - - N O N 0 0 0~ 0 0 0 N O N O . 0 C) 0 I O O O O ¢ M U to R' Ul LL u J a lYI . (/1 > N M 7 LL ° ~F LL U F LL BdFl LL LL IL I LL F- LL LL LL LL LL U - U U - - - LL - LL - LL - O - 0 - - - LL - I - LL LL ~ L L - LL F LL LL LLLLOLL LL LL LL LL ~ LL U LL Z ~1es ffmca z m Z Z m m m m Z m ¢ Z LL Z Z , Ln m m > co m Z m LL Z Z Z ¢ m U Z (n c,) m <n (n(4 J x x v7 d cn U m a (n 3 u~ m IL ~ m rl ~ ~ ~ mmU (n v~ m ~ m m U) I m G O n N N 0 = 0) W w W 0 X v W Y ~ (h (Mi) w i) ( 2 C'0 Y co w 0) M M O 0) w N Z X m -0 w O M U) L n ca o 14 X M LL I V. X X w X w Y .X U w w m O w v LL w w M Y M = M } M m O M M X O 10 X ry= Q w J X J X J N C N O M w M O O M w to w N N N ( j M M w m m m M M M m M m M N M M a 0 W C., N a D N A (Oj CM7 m m 7 CD M n M M w w n M N N (i) M M (y M O co M M M M M M M M M M M M co M M M . t N a. U CL U V U V a cc (D ° .r a cL Q m m Y o m v cc m CL ~ ca m . UU c U ~ ~ ~ m d n m ? m z. LL l a m a G1 N U U) to m C m E L l' ` N Y !t i0 > m N N N Q Q a. m m ` m m Q m (0 C to J o N m Z L m m m Q m p N c p U > m U U 0 0 2 E~ I m O m Z ~ m m I U 41 d m ID i a (3 ' d m c c ~ a 0 m m o vi mE a m E m m m m m m L y Y m c m m m m o U o U~ a m a i v~ v» 3l- U y ~ LL U ~ m m V U U ¢ a E ¢ c > U U ~ U U ° d m J J ) m m J 4 O 91 W - J J J m J ? N m J m J ¢ ¢ m J m m J m J w m ¢ E ¢ m m Y m m wl Y N m C 2 0 2 LL a LL N 0 0 a 2 L O o U U J 2 S 2 2 Z o - 2 Z 2 Z Z 2 L~ S 2 o S2 ZS o 2 2 Z S 2 N 2 S I Li L LL LL lL LL LL U LL LL LL LL LL LL LL LL (n LL LL LL LL U LL LL LL LL LL m lL LL J m H Memorandum Date: September 17, 2007 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find August 2007 financial reports for the following funds: General (001), Community Justice - Juvenile (230), Sheriff's (255, 701, 702), Health (259), Mental Health (275), Community Development (295), Road (325), Community Justice - Adult (355), Commission on Children & Families (370-399), Solid Waste (610), Health Benefits Trust Fund (675) and 9-1-1 (705). The projected information has been reviewed and updated, where appropriate, by the respective departments. Cc: All Department Heads GENERALFUND Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Year to Date Revised Year End $ Budget Actual Variance FY % Coll. % Budget Projection Variance Variance RESOURCES: Beg. Net Working Capital $ 5,920,000 $ 6,715,987 $ 795,987 100% 113% $ 5,920,000 $ 6,715,987 $ 795,987 13% Revenues Property Taxes 3,092,000 132,905 (2,959,095) 17% 1% 18,552,000 18,552,000 - 0% Gen. Rev. - excl. Taxes 421,096 567,944 146,848 17% 22% 2,526,574 2,526,574 - 0% Assessor 179,528 225,869 46,341 17% 21% 1,077,170 1,077,170 - 0% County Clerk 380,017 364,815 (15,202) 17% 16% 2,280,100 2,280,100 - 0% BOPTA 2,911 4,426 1,515 17% 25% 17,464 17,464 - 0% Board of County Comm. 17 212 195 17% 212% 100 250 150 150% District Attorney 45,567 16,101 (29,466) 17% 6% 273,400 273,400 - 0% Finance/Tax 41,641 61,761 20,120 17% 25% 249,845 249,845 - 0% Veterans 12,000 17,550 5,550 17% 24% 72,000 72,000 - 0% Property Management 14,167 16,166 1,999 17% 19% 85,000 85,000 - 0% Grant Projects 333 334 1 17% 17% 2,000 2,000 - 0% Total Revenues 4,189,277 1,408,083 (2,781,194) 17% 6% 25,135,653 25,135,803 150 0% TOTAL RESOURCES 10,109,277 8,124,070 (1,985,207) 17% 26% 31,055,653 31,851,790 796,137 3% REQUIREMENTS: - Exp. Expenditures - Assessor 628,352 508,381 119,971 17% 13% 3,770,112 3,770,112 - 0% County Clerk 269,176 193,166 76,010 17% 12% 1,615,056 1,615,056 - 0% BOPTA 11,003 15,435 (4,432) 17% 23% 66,016 66,016 - 0% BOCC 129,497 113,760 15,737 17% 15% 776,979 776,979 - 0% District Attorney 764,477 677,652 86,825 17% 15% 4,586,859 4,586,859 - 0% Finance/Tax 141,542 109,021 32,521 17% 13% 849,249 849,249 - 0% Veterans 44,247 33,603 10,644 17% 13% 265,481 265,481 - 0% Property Management 40,662 34,523 6,139 17% 14% 243,970 243,970 - 0% Grant Projects 16,160 15,913 247 17% 16% 96,960 96,960 - 0% Non-Departmental 217,269 119,687 97,582 17% 9% 1,303,612 1,303,612 - 0% Contingency 865,476 - 865,476 17% n/a 5,192,855 - 5,192,855 100% 3,127,861 1,821,141 1,306,720 17% 10% 18,767,149 13,574,294 5,192,855 28% Transfers Out 2,048,084 1,914,725 133,359 17% 16% 12,288,504 12,288,504 - 0% TOTAL REQUIREMENTS 5,175,945 3,735,866 1,440,079 17% 12% 31,055,653 25,862,798 5,192,855 17% NET (Resources - Requirements) 4,933,332 4,388,204 (545,128) - 5,988,992 5,988,992 COMM JUSTICE-JUVENILE Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065-Court Assess. State Miscellaneous Discovery Fee Food Subsidy Juvenile Crime Prevention Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Grants - Private Level 7 Total Revenues I Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 900,000 $ 987,986 $ 87,986 100% 110% $ 900,000 $ 987,986 $ 87,986 25,666 3,413 (22,253) 17% 2% a) 153,998 153,998 - 8,000 8,042 42 17% 17% 48,000 48,000 - 766 - (766) 17% 0% 4,594 4,594 - 1,667 3,739 2,072 17% 37% b) 10,000 10,000 - 6,500 - (6,500) 17% 0% 39,000 39,000 - 45,065 - (45,065) 17% 0% a) 270,391 270,391 - 13,333 5,250 (8,083) 17% 7% 80,000 80,000 - 200 - (200) 17% 0% 1,200 1,200 - 110,785 13,702 (97,083) 17% 2% c) 664,712 664,712 - 83 150 67 17% 30% 500 500 - 667 150 (517) 17% 4% 4,000 4,000 - 6,000 10,284 4,284 17% 29% 36,000 50,000 14,000 5,786 3,354 (2,432) 17% 10% 34,714 34,714 - - 352 352 17% n/a - 352 352 20,973 - (20,973) 17% 0% a) 125,839 125,839 - 245,491 48,436 (197,055) 17% 3% 1,472,948 1,487,300 14,352 Transfers In-General Fund 988,871 988,871 - 17% 17% 5,933,223 5,933,223 - TOTAL RESOURCES 2,134,362 2,025,293 (109,069) 17% 24% 8,306,171 8,408,509 102,338 REQUIREMENTS: Expenditures Community Justice-Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Capital Outlay Contingency Exp. 436,951 402,590 34,361 17% 15% d) 2,621,706 2,621,706 304,026 164,208 139,818 17% 9% 1,824,154 1,824,154 17 - 17 17% 0% 100 100 495,318 457,579 37,739 39,426 34,566 4,860 17 - 17 108,608 - 108,608 17% 15% d) 2,971,908 2,971,908 - 17% 15% 236,557 236,557 - 17% 0% 100 100 - 17% n/a 651,646 - 651,646 TOTAL REQUIREMENTS 1,384,363 1,058,943 325,420 17% 13% 8,306,171 7,654,525 651,646 NET (Resources - Requirements) 749,999 966,350 216,351 - 753,984 753,984 a) Payments received quarterly. b) Requests for discovery documents are higher than anticipated. c) Billing is generated in succeeding month with payments being received 4-6 weeks after billing. d) Four unfilled positions and leave without pay for two individuals contribute to variances in Personnel Services in both departments. SHERIFF - Rev Detail Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Interest on Unsegregated Total Revenues TOTAL RESOURCES I Year to Date Revised Year End Budget Actual Variance FY % Coll. % L Budget Projection Variance $ 2,562,148 $ 2,648,830 $ 86,682 100% 103% $ 2,562,148 $ 2,648,830 $ 86,682 3,073,125 3,073,124 (1) 17% 17% 18,438,752 18,510,746 71,994 2,017,719 2,017,718 (1) 17% 17% 12,106,316 12,090,316 (16,000) - 26,434 26,434 17% n/a - 26,434 26,434 - - - 17% n/a - - - 5,090,844 5,117,276 26,432 17% 17% 30,545,068 30,627,496 82,428 7,652,992 7,766,106 113,114 17% 23% 33,107,216 33,276,326 169,110 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 Non-Departmental Contingency Exp. 365,260 267,940 97,320 17% 12% a) 2,191,557 2,191,557 - 110,556 97,760 12,796 17% 15% 663,327 663,327 - 213,302 140,295 73,007 17% 11% b) 1,279,803 1,279,803 - 345,880 326,645 19,235 17% 16% 2,075,281 2,075,281 - 1,231,098 1,100,874 130,224 17% 15% c) 7,386,586 7,386,586 - 96,868 90,793 6,075 17% 16% 581,205 581,205 - 1,453,339 1,213,580 239,759 17% 14% d) 8,720,033 8,620,033 100,000 40,393 34,384 6,009 17% 14% 242,360 242,360 - 22,703 26,149 (3,446) 17% 19% 136,215 136,215 - 125,283 117,238 8,045 17% 16% 751,698 751,698 - 605,662 216,406 389,256 17% 6% e) 3,633,970 3,433,970 200,000 32,715 33,762 (1,047) 17% 17% 196,289 196,289 - 464,481 2,590,247 (2,125,766) 17% 93% 2,786,885 2,786,885 - 402,001 - 402,001 17% n/a 2,412,007 - 2,412,007 Transfers Out 8,333 - 8,333 17% TOTAL REQUIREMENTS 5,517,874 6,256,073 (738,199) 17% NET (Resources - Requirements) 2,135,118 1,510,033 (625,085) 0% 50,000 50,000 - 19% 33,107,216 30,395,209 2,712,007 2,881,117 2,881,117 Sheriff Notes Statement of Financial Operating Data Two Months Ended August 31, 2007 a) Variance due to open positions and timing of capital expenditures. b) Variance due to timing of purchasing vehicle supplies and payments for fuel purchases. c) Variance due to delay in filling open positions and timing of payment for new patrol vehicles. d) Variance due to delay in filling open positions and timing of supplies and capital purchases. Personnel expenditures projected to be below budget due to unfilled positions. e) Variance due to timing of filling open positions for opening the Work Center and payment of expenses for the Work Center renovation project. Personnel expenditures projected to be below budget due to unfilled positions. Sheriff 701 Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Tax Revenues - Current Tax Revenues - Prior State Grant Transp. of State Wards SB 1145 Des. Cty Video Lottery Grant Des Cty Sheriffs Office Des Cty Court Security Des Cty Juvenile Contract Des Cty Parole & Prb Cnt Inmate Commissary Fees Work Center Work Crews Soc Sec Incentive-Fed Miscellaneous Medical Services Reimb Restitution Sheriff Fees Interest Interest on Unsegregated Rentals Total Revenues Year to Date Revised Year End Budget Actual Variance FY % Cou. % Budget Projection Variance $ - $ - $ - 17% Na $ - $ - $ - 2,323,557 - (2,323,557) 17% 0% 13,941,344 13,941,344 - 42,407 55,986 13,579 17% 22% 254,440 254,440 - 7,526 12,382 4,856 17% 27% 45,156 45,156 - 833 - (833) 17% 0% 5,000 5,000 - 333,934 544,449 210,515 17% 27% a) 2,003,604 2,023,208 19,604 58,333 - (58,333) 17% 0% 350,000 350,000 - 214,606 1,295,648 1,081,042 17% 101% 1,287,636 1,295,648 8,012 16,668 - (16,668) 17% 0% 100,006 100,006 - 1,600 - (1,600) 17% 0% 9,600 9,600 - 133 - (133) 17% 0% 800 800 - 13,333 757 (12,576) 17% 1% 80,000 80,000 - 12,500 - (12,500) 17% 0% 75,000 75,000 - 667 800 133 17% 20% 4,000 4,000 - 2,250 637 (1,613) 17% 5% 13,500 13,500 - 2,800 373 (2,427) 17% 2% 16,800 16,800 - 175 85 (90) 17% 8% 1,050 1,050 - 25,603 26,636 1,033 17% 17% 153,615 153,615 - 15,000 (7,531) (22,531) 17% -8% 90,000 90,000 - 1,200 112 (1,088) 17% 2% 7,200 7,200 - - 7,294 7,294 17% 729400% b) 1 21,882 21,881 3,073,125 1,937,628 (1,135,498) 17% 11% 18,438,752 18,488,249 49,497 TOTAL RESOURCES 3,073,125 1,937,628 (1,135,498) 17% REQUIREMENTS: EXPENDITURES & TRANSFERS - Materials and Services 3,073,126 3,073,124 2 17% TOTAL REQUIREMENTS NET (Resources - Requirements) 3,073,126 3,073,124 2 17% (1) (1,135,497) (1,135,496) 11% 18,438,752 18,488,249 49,497 Exp. 17% 18,438,752 18,438,752 - 17% 18,438,752 18,438,752 - - 49,497 49,497 a) 2007-09 State W&M Budget Grant Allocation. b) Delay in FBI relocation resulting in unexpected rental revenue. Sheriff 702 Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget L Pro'ection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 17% n/a $ - $ - $ _ Revenues Tax Revenues - Current 1,123,333 - (1,123,333) 17% 0% 6,740,000 6,740,000 - Tax Revenues - Prior 20,268 55,312 35,044 17% 45% 121,610 121,610 - Federal Grants 3,083 622 (2,461) 17% 3% 18,500 18,500 - US Forest Service 12,000 12,000 - 17% 17% 72,000 72,000 - State Grant 13,232 13,718 486 17% 17% 79,392 79,392 - SB #1065 Court Assessment 7,083 8,042 959 17% 19% 42,500 42,500 - Marine Board License Fee 16,491 - (16,491) 17% 0% 98,944 98,944 - Narcotic Task Force 18,333 - (18,333) 17% 0% 110,000 110,000 - Des Cty General Fund Grnt 60,875 - (60,875) 17% 0% 365,247 365,247 - Des Cty Transient Room Tax 380,792 380,792 - 17% 17% 2,284,753 2,284,753 Des Cty Other Grant 10,081 - (10,081) 17% 0% 60,483 60,483 - Des Cty Sheriffs Office 212,419 1,290,475 1,078,056 17% 101% 1,274,512 1,290,475 15 963 City of Sisters 65,543 65,543 - 17% 17% 393,255 393,255 , - Des Cty Tax/Fin Contract 458 - (458) 17% 0% 2,750 2,750 - Des Cty CDD Contract 8,589 - (8,589) 17% 0% 51,535 51,535 - Des Cty Solid Waste Cntrt 8,589 - (8,589) 17% 0% 51,535 51,535 - Des Cty Clerk/Election 500 - (500) ° 17% ° 0 3,000 3,000 - Security & Traffic Reimb 10,750 5,333 (5,417) 17% 8% 64,500 64,500 - Seat Belt Program 1,000 1,725 725 17% 29% 6,000 6,000 - Miscellaneous - 578 578 17% n/a - 1,000 1 000 Sheriff Fees - 1,100 1,100 17% n/a - 5,000 , 5 000 Court Fines & Fees 20,833 14,806 (6,027) 17% 12% 125,000 125,000 , - Impound Fees 12,500 12,000 (500) 17% 16% 75,000 75,000 - Restitution - Street Crimes - 40 40 17% n/a - 500 500 Interest 10,000 (2,439) (12,439) 17% -4% 60,000 60,000 - Interest on Unsegregated 800 111 (689) 17% 2% 4,800 4,800 - Sale of Equip & Material 167 776 609 17% 78% 1,000 1,000 - Total Revenues 2,017,719 1,860,534 (157,185) 17% 15% 12,106,316 12,128,779 22,463 TOTAL RESOURCES 2,017,719 1,860,534 (157,185) 17% 15% 12,106,316 12,128,779 22,463 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Materials and Services 2,017,719 2,017,718 1 17% 17% 12,106,316 12,106,316 - TOTAL REQUIREMENTS 2,017,719 2,017,718 1 17% 17% 12,106,316 12,106,316 - NET (Resources - Requirements) - (157 184) (157 184) - 22,463 22 463 , HEALTH Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget Actual I Variance I FY % Coll. % Bud et Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 600,000 $ 686,578 $ 86,578 10001. 114% $ 600,000 $ 686,578 $ 86,578 Revenues Medicare Reimbursement 833 290 (543) 17% 6% 5,000 5,000 - State Grant 243,007 230,711 (12,296) 17% 16% 1,458,040 1,458,040 - Child Dev & Rehab Center 5,567 - (5,567) 17% 0% 33,401 33,401 - State Miscellaneous 29,255 - (29,255) 17% 0% 175,528 175,528 - OMAP 43,650 32,086 (11,564) 17% 12% 261,900 261,900 - Family Planning Exp Proj 91,667 - (91,667) 17% 0% 550,000 550,000 - Grants 3,654 - (3,654) 17% 0% 21,922 21,922 - School Districts 2,521 - (2,521) 17% 0% 15,123 15,123 - Contract Payments/ESD 1,833 - (1,833) 17% 0% 11,000 11,000 - Miscellaneous - 100 100 17% n/a - 100 100 Patient Insurance Fees 9,633 11,303 1,670 17% 20% 57,800 57,800 - Health Dept/Patient Fees 32,258 34,313 2,055 17% 18% 193,550 193,550 - Vital Records-Birth 6,667 5,645 (1,022) 17% 14% 40,000 40,000 - Vital Records-Death 15,333 12,935 (2,398) 17% 14% 92,000 92,000 - Interest on Investments 5,000 6,364 1,364 17% 21% 30,000 30,000 - Donations 1,975 1,016 (959) 17% 9% 11,850 11,850 - Interfund Contract 19,547 - (19,547) 17% 0% 117,283 117,283 - Administrative Fee 2,000 2,000 - 17% 17% 12,000 12,000 - Total Revenues 514,400 336,763 (177,637) 17% 11% 3,086,397 3,086,497 100 Transfers In-Reserve Fund 17 - (17) 17% 0% 100 100 - Transfers In-General Fund 425,581 424,581 (1,000) 17% 17% 2,553,485 2,553,485 - TOTAL RESOURCES 1,539,998 1,447,922 (92,059) 17% 23% 6,239,982 6,326,660 86,678 REQUIREMENTS: Exp. Expenditures - Personal Services 690,099 636,502 53,597 17% 15% 4,140,591 3,840,591 300,000 Materials and Services 231,669 151,779 79,890 17% 11% 1,390,013 1,390,013 - Capital Outlay 833 - 833 17% 0% 5,000 5,000 - Transfers Out 525,000 - 525,000 17% 0% 150,000 150,000 - Contingency 92,396 - 92,396 17% n/a 554,378 - 554 378 , TOTAL REQUIREMENTS 1,539,997 788,281 751,716 17% 13% 6,239,982 5,385,604 854,378 NET (Resources - Requirements) 1 659,641 659,657 - 941,056 941,056 MENTAL HEALTH Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Federal Grants State Grants State Miscellaneous Title 19 Liquor Revenue Local Grants School Districts Mental Health Jail Comp Contract Payments Miscellaneous Patient Insurance Fees Patient Fees Seizure/Forfeiture Interest on Investments Rentals Donation Interfund Contract Administrative Fee Total Revenues Year to Date Budget Actual Variance FY % Coll. % $ 2,900,000 $ 2,889,297 $ (10,703) 100% 100% L Revised Year End Budget Projection Variance $ 2,900,000 $ 2,889,297 $ (10,703) 917 1,595 678 17% 29% 5,500 5,500 - 26,667 27,083 416 17% 17% 160,000 160,000 - 24,270 - (24,270) 17% 0% (a) 145,618 145,618 - 638,102 600,031 (38,071) 17% 16% (b) 3,828,614 5,001,106 1,172,492 58,522 5,915 (52,607) 17% 2% (c) 351,134 351,134 - 25,400 33,297 7,897 17% 22% 152,400 152,400 - 17,667 - (17,667) 17% 0% (d) 106,000 106,000 - 6,667 - (6,667) 17% 0% (d) 40,000 40,000 - 16,667 - (16,667) 17% 0% (e) 100,000 100,000 - 1,200 600 (600) 17% 8% 7,200 7,200 - 3,845 878 (2,967) 17% 4% 23,072 23,072 - 14,186 3,065 (11,121) 17% 4% 85,114 85,114 - 36,250 29,765 (6,485) 17% 14% 217,500 217,500 - 3,967 1,356 (2,611) 17% 6% 23,800 23,800 - - 20,215 20,215 17% n/a (f) - 20,215 20,215 24,040 26,724 2,684 17% 19% 144,240 144,240 - 2,750 875 (1,875) 17% 5% 16,500 16,500 - 333 - (333) 17% 0% 2,000 2,000 - 667 520 (147) 17% 13% 4,000 4,000 - 408,657 408,658 1 17% 17% 2,451,940 2,451,940 - 1,310,774 1,160,577 (150,197) 17% 15% 7,864,632 9,057,339 1,192,707 Transfers In-General Fund 243,753 243,753 - Transfers In-Other 71,366 69,699 (1,667) TOTAL RESOURCES 4,525,893 4,363,326 (162,567) REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 17% 17% 1,462,516 1,462,516 - 17% 16% 428,193 428,193 - 17% 34% 12,655,341 13,837,345 1,182,004 Exp. 1,209,393 1,144,217 65,176 17% 16% (g) 7,256,355 6,931,355 325,000 636,079 429,391 206,688 17% 11% (h) 3,816,473 3,866,473 (50,000) 17 - 17 17% 0% 100 100 - 25,000 - 25,000 17% 0% 150,000 150,000 - 238,736 - 238,736 17% n/a 1,432,413 - 1,432,413 2,109,225 1,573,608 535,617 17% 12% 12,655,341 10,947,928 1,707,413 2,416,668 2,789,718 373,050 - 2,889,417 2,889,417 (a) Grants are billed on a quarterly basis. Actual revenue will lag behind budget all year. (b) DCMH has recieved notice of DHS State Grant funding increases totaling $1,172,492 for 2007/08. (c) Variance primarily a result of historical 30-60 day time lag from billing to payment from State for most contracts. (d) It is expected that payments will begin being received shortly. (e) School District revenues correlate with the school year causing a negative variance for most of the year. (f) This is an unpredictable revenue source and is typically not budgeted. (g) Due to unfilled positions DCMH expects savings vs budget of about $500,000, but due to new positions created related to item (b) & about 1/2 year of employment for new positions, $175,000 currently unbudgeted funds will be spent. Net savings is $325,000. (h) Based upon historical M&S underspending, DCMH expects savings vs budget of about $200,000, but due to new and increased dollar amount on existing contracts we expect to pass-through about $250,000 more than currently budgeted tied to item (b). Net savings about $325,000. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Admin-Operations Admin-GIS Admin-Code Enforcement Building Safety Electrical Contract Services Env Health-On Site Prog Env Health-Lic Facilities Env Health - Drinking H2O EPA Grant Planning-Current Planning-Long Range Total Revenues Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 489,444 $ 211,661 $ (277,783) 100% 43% $ 489,444 $ 211,661 (277,783) 13,029 8,379 (4,650) 17% 11% 78,175 78,175 - 1,333 531 (802) 17% 7% 8,000 8,000 - 71,075 59,233 (11,842) 17% 14% 426,450 426,450 - 411,325 347,881 (63,444) 17% 14% 2,467,950 2,467,950 - 100,650 90,492 (10,158) 17% 15% 603,900 603,900 - 130,417 120,880 (9,537) 17% 15% 782,500 782,500 - 159,575 96,907 (62,668) 17% 10% 957,450 957,450 - 91,075 40,741 (50,334) 17% 7% a) 546,450 546,450 - 8,667 - (8,667) 17% 0% b) 52,000 52,000 - 25,946 - (25,946) 17% 0% b) 155,675 155,675 - 258,575 244,129 (14,446) 17% 16% 1,551,450 1,551,450 - 119,058 80,068 (38,990) 17% 11% 714,350 714,350 - 1,390,725 1,089,241 (301,484) 17% 13% 8,344,350 8,344,350 - Trans In-CDD Reserve 33,333 - (33,333) 17% 0% Trans In-CDD Bldg/Elec 13,190 - (13,190) 17% 0% Trans In-General Fund 12,500 - (12,500) 17% 0% Trans In-Other 17 - (17) 0% 0% TOTAL RESOURCES 1,926,002 1,300,902 (625,100) 17% 14% REQUIREMENTS: EXPENDITURES & TRANSFERS Admin-Operations Division 435,861 390,349 45,512 Admin-GIS Division 50,662 46,332 4,330 Admin-Code Enforcement 38,295 28,374 9,921 Building Safety Division 218,475 214,375 4,100 Electrical Division 72,002 66,999 5,003 Contract Services 106,210 103,843 2,367 Env Health-On Site Pgm 98,698 78,945 19,753 Env Health-Lic Facilities 83,191 73,028 10,163 Env Health - Drinking H2O 11,569 11,177 392 EPA Grant 20,609 17,743 2,866 Planning-Current Division 223,879 184,216 39,663 Planning-Long Range Div 91,669 70,620 21,049 Contingency 80,220 - 80,220 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% 17% Exp. 79/6 15% 15% 12% 16% 16% 16% 13% 15% 16% 14% 14% 13% n/a TOTAL REQUIREMENTS 1,531,340 1,286,001 245,339 17% 14% NET (Resources - Requirements) 394,662 14,901 (379,761) 200,000 200,000 - 79,139 79,139 - 75,000 75,000 - 100 100 - 9,188,033 8,831,011 (277,783) 2,615,163 2,615,163 - 303,974 303,974 - 229,770 229,770 - 1,310,851 1,310,851 - 432,013 432,013 - 637,262 637,262 - 592,186 592,186 - 499,143 499,143 - 69,415 69,415 - 123,651 123,651 - 1,343,273 1,343,273 - 550,011 550,011 - 481,321 - 481,321 9,188,033 8,706,712 481,321 - 124,299 203,538 a) Revenue is received primarily in January and February after license renewal statements are mailed out. b) Payments are received in installments or as billed. ROAD Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget Actual Variance FY % Coll. % ( Budget I Projection Variance RESOURCES: Beg. Net Working Capital $ 5,302,706 $ 5,548,129 $ 245,423 100% 105% $ 5,302,706 $ 5,548,129 $ 245,423 Revenues System Development Ch 11,167 3,234 (7,933) 17% 5% 67,000 67,000 - Mineral Lease Royalties - 3,011 3,011 17% n/a - 3,011 3,011 Forest Receipts 511,333 - (511,333) 17% 0% a) 3,068,000 3,068,000 - State Grant 62,074 - (62,074) 17% 0% 372,445 372,445 - Motor Vehicle Revenue 1,400,000 1,191,463 (208,537) 17% 14% 8,400,000 8,400,000 - City of Bend 29,167 - (29,167) 17% 0% b) 175,000 175,000 - City of Redmond 70,833 - (70,833) 17% 0% b) 425,000 425,000 - City of Sisters 2,500 - (2,500) 17% 0% b) 15,000 15,000 - Miscellaneous 8,333 7,645 (688) 17% 15% 50,000 50,000 - Road Vacations 167 - (167) 17% 0% 1,000 1,000 - Interest on Investments 25,000 48,753 23,753 17% 33% 150,000 150,000 - Donations 400 - (400) 17% 0% 2,400 2,400 - Interfund Contract 150,383 - (150,383) 17% 0% c) 902,300 902,300 - Equipment Repairs 42,050 18,247 (23,803) 17% 7% d) 252,300 252,300 - Vehicle Repairs 16,667 - (16,667) 17% 0% e) 100,000 100,000 - LID Construction 25,000 - (25,000) 17% 0% f) 150,000 150,000 - Vegetation Management 15,300 - (15,300) 17% 0% g) 91,800 91,800 - Inter-fund: Forester 3,500 - (3,500) 17% 0% g) 21,000 21,000 - Sale of Eqp & Material 100,000 67,650 (32,350) 17% 11% 600,000 600,000 - Sale of Public Lands 83 - (83) 17% 0% 500 500 - Total Revenues 2,473,957 1,340,003 (1,133,954) 17% 9% 14,843,745 14,846,756 3,011 Trans In-Solid Waste 154,500 - (154,500) 17% 0% h) 927,000 927,000 - Trans In-Road Imp Res 2,610 - (2,610) 17% 0% i) 15,660 15,660 - TOTAL RESOURCES 7,933,773 6,888,132 (1,045,641) 17% 38% 21,089,111 21,337,545 248,434 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency Exp. 941,912 951,976 (10,064) 17% 17% 5,651,471 5,531,813 119,658 1,438,160 882,131 556,029 17% 10% j) 8,628,958 7,742,761 886,197 690,833 4,217 686,616 17% 0% 4,145,000 1,281,000 2,864,000 150,000 - 150,000 17% 0% 900,000 900,000 - 293,947 - 293,947 17% n/a 1,763,682 - 1,763,682 TOTAL REQUIREMENTS 3,514,852 1,838,324 1,676,528 17% 9% 21,089,111 15,455,574 5,633,537 NET (Resources - Requirements) 4,418,921 5,049,808 630,887 - 5,881,971 5,881,971 a) Annual payment anticipated to be received in December. b) Billed upon completion of work. c) Payment to be received in June 2007 from Fund 328 & 329. d) Billed to County departments monthly in arrears. e) Payment to be received in June 2007 from Fund 340. f) Payment to be received in June 2007 from Fund 430. g) Payment to be received in June 2007 from Fund 326. h) Payment to be received quarterly from Solid Waste. i) Payment to be received in June 2007 from Fund 335. j) Seasonal expenditures, includes overlays to take place in spring 2008. ADULT PAROLE & PROBATION Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 200,000 $ 311,856 $ 111,856 100% 156% $ 200,000 $ 311,856 $ 111,856 Revenues State Grant 443,625 665,468 221,843 17% 25% 2,661,752 2,661,752 - State Miscellaneous 2,217 - (2,217) 17% 0% 13,300 13,300 - Probation Work Crew Fees 8,500 3,972 (4,528) 17% 8% 51,000 51,000 - Alcohol and Drug Treatment 83 55 (28) 17% 11% 500 500 - Polygraph Testing 400 900 500 17% 38% 2,400 2,400 - Miscellaneous 1,500 3,938 2,438 17% 44% 9,000 9,000 - Electronic Monitoring Fee 15,000 14,788 (212) 17% 16% 90,000 90,000 - Probation Superv. Fees 34,167 40,976 6,809 17% 20% 205,000 205,000 - Cognitive Program 717 - (717) 17% 0% 4,300 4,300 - Interest on Investments 4,750 2,798 (1,952) 17% 10% 28,500 28,500 - Leases - 3,000 3,000 17% n/a - 3,000 3,000 Rentals 500 150 (350) 17% 5% 3,000 3,000 - Drug Court - Byrne 1,667 - (1,667) 17% 0% 10,000 10,000 - Total Revenues 513,126 736,045 222,919 17% 24% 3,078,752 3,081,752 3,000 Transfers In-General Fund 56,667 56,667 - 17% 17% 340,000 340,000 - Transfers In-Video Lottery 17,667 17,667 - 17% 17% 106,000 106,000 - Transfers In-Sheriff 8,333 - (8,333) 17% 0% 50,000 50,000 - Transfers In-Video Lottery 500 - (500) 17% 0% 3,000 3,000 - TOTAL RESOURCES 796,293 1,122,235 325,942 17% 30% 3,777,752 3,892,608 114,856 REQUIREMENTS: Exp. Expenditures Personal Services 469,255 405,466 63,789 17% 14% 2,815,532 2,815,532 - Materials and Services 104,544 100,045 4,499 17% 16% 627,262 627,262 - Capital Outlay 17 - 17 17% 0% 100 100 Contingency 55,810 - 55,810 17% n/a 334,858 - (334 858) , TOTAL REQUIREMENTS 629,626 505,511 124,115 17% 13% 3,777,752 3,442,894 (334,858) NET (Resources - Requirements) 166,667 616,724 450,057 - 449,714 449,714 COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 542,211 $ 613,800 $ 71,589 100% 113% $ 542,211 $ 613,800 $ 71,589 Revenues Federal Grants 45,823 - (45,823) 17% 0% 274,939 274,939 - Title IV - Family Sup/Pres 6,934 - (6,934) 17% 0% a) 41,601 37,650 (3,951) HealthyStart Medicaid 23,333 - (23,333) 17% 0% b) 140,000 130,000 (10,000) Child Care Block Grant 9,450 - (9,450) 17% 0% a) 56,698 58,668 1,970 Level 7 Services 34,328 - (34,328) 17% 0% a) 205,969 175,191 (30,778) Juvenile Crime Prevention 64,985 - (64,985) 17% 0% c) 389,908 452,792 62,884 State Prevention Funds 22,917 46,875 23,958 17% 34% d) 137,500 187,500 50,000 HealthyStart /R-S-G 55,116 - (55,116) 17% 0% a) 330,694 374,000 43,306 OCCF Grant 62,601 - (62,601) 17% 0% a) 375,603 472,124 96,521 Miscellaneous 583 625 42 17% 18% e) 3,500 7,000 3,500 Court Fines & Fees 4,000 4,167 167 17% 17% 24,000 24,000 - Interest on Investments 4,167 5,588 1,421 17% 22% 0 25,000 45,000 20,000 Grants-Private 2,000 - (2,000) 17% 0% g) 12,000 11,000 (1,000) Total Revenues 336,237 57,255 (278,982) 17% 3% 2,017,412 2,249,864 232,452 Trans from General Fund 58,200 58,200 - 17% 17% 349,200 349,200 - Trans from Other 28,550 - (28,550) 17% 0% 171,297 171,297 - Total Transfers In 86,750 58,200 (28,550) 17% 11% 520,497 520,497 - TOTAL RESOURCES 965,198 729,255 (235,943) 17% 24% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources- Requirements) Exp. 3,080,120 3,384,161 304,041 91,120 84,669 6,451 17% 15% 546,721 546,721 - 358,353 82,534 275,819 17% 4% 2,150,116 2,284,206 (134,090) 17 - 17 17% 0% 100 100 - 63,864 - 63,864 17% n/a 383,183 - 383,183 513,354 167,203 346,151 17% 5% 3,080,120 2,831,027 249,093 451,844 562,052 110,208 - 553,134 553,134 a) Grant amounts finalized according to the OCCF budget workgroup and allocation formulas. b) Local Medicaid reimbursements trending downward due to new guidelines. c) JCP funding allocations increased. d) Safe & Drug Free Schools grant budgeted at $50,000, actual is $100,000. e) Partner reimbursements for office expenses, and project contributions expected to increase. f) Interest income projection increased due to higher cash balance and additional grant funding. g) Youth conference donations decreased to match 06/07 actual amount. SOLID WASTE Statement of Financial Operating Data Two Months Ended August 31, 2007 Year to Date Revised Year End Budget et Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: : Beg. Net Working Capital $ 2,280,356 $ 2,678,908 $ 398,552 100% 117% $ 2,280,356 $ 2,678,908 $ 398,552 Revenues State Grant - 88,693 88,693 17% n/a - 88,693 88,693 Miscellaneous 5,833 5,673 (160) 17% 16% 35,000 35,000 - Franchise 3% Fees 26,667 - (26,667) 17% 0% a) 160,000 160,000 - Commercial Disp. Fees 343,333 299,746 (43,587) 17% 15% 2,060,000 2,060,000 - Private Disposal Fees 345,000 327,500 (17,500) 17% 16% 2,070,000 2,070,000 - Franchise Disposal Fees 895,911 786,054 (109,857) 17% 15% 5,375,465 5,375,465 - Yard Debris 9,442 19,779 10,337 17% 35% b) 56,650 56,650 - Special Waste 5,000 6,043 1,043 17% 20% 30,000 30,000 - Interest 20,000 27,483 7,483 17% 23% 120,000 120,000 - Sale of Equip & Material 7,500 13,813 6,313 17% 31% c) 45,000 45,000 - Total Revenues 1,658,686 1,574,784 (83,902) 17% 16% 9,952,115 10,040,808 88,693 Trans In-North Area Dev 341,667 - (341 667) 17% 0% d) 2,050,000 2,050,000 - TOTAL RESOURCES 4,280,709 4,253,692 (27,017) 17% 30% 14,282,471 14,769,716 487,245 REQUIREMENTS Exp Expenditures Personal Services 289,005 274,583 14,422 17% 16% 1,734,028 1,734,028 Materials and Services 832,499 380,179 452,320 17% 8% e) 4,994,995 4,994,995 - Debt Service 161,326 - 161,326 17% 0% 967,954 967,954 - Capital Outlay 29,900 2,406 27,494 17% 1% 179,400 179,400 - Transfers Out 971,167 - 971,167 17% 0% 5,827,000 5,827,000 - Contingency 96,516 - 96,516 17% n/a 579,094 - 579,094 TOTAL REQUIREMENTS 2,380,413 657,168 1,723,245 17% 5% 14,282,471 13,703,377 579,094 NET (Resources - Requirements) 1,900,296 3,596,524 1,696,228 - 1,066,339 1,066,339 a) Franchise fees are due Apri l 15th. b) Seasonal material. c) Recycling revenues higher than expected and seasonal. d) Transfer will occur after proj ect completion anticipated in November 2007 . e) Larger dollar items/projects/events/purchases are scheduled thro h t t h ug ou e yea r. Health Benefits Trust Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Add'I Prem Employee Prem Contribution COIC Retiree / COBRA Co-Pay Medical Services Reimb Prescription Rebates Interest Total Revenues TOTAL RESOURCES Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $10,500,000 $10,760,885 $ 260,885 100% 102% 1,850,000 2,017,099 167,099 17% 18% 25,317 28,348 3,032 17% 19% 57,505 53,270 (4,235) 17% 15% 129,296 136,448 7,152 17% 18% 66,667 82,741 16,075 17% 21% - - - 17% n/a - 19,632 19,632 17% n/a 75,000 89,926 14,926 17% 20% 2,203,784 2,427,464 223,680 17% 18% 12,703,784 13,188,350 484,565 92% 56% REQUIREMENTS Exp. Expenditures: Personal Services 18,131 17,236 895 17% Materials & Services Conferences and Seminars 500 - 500 17% Claims Paid-Medical/Rx 1,639,688 1,439,488 200,200 17% Claims Paid-Dental/Vision 216,778 83,403 133,375 17% Refunds - (16,162) 16,162 17% n/a Insurance Expense 70,525 52,461 18,064 17% State Assessments 10,000 - 10,000 17% Administration Fee 43,400 37,888 5,512 17% PPO Fee 6,329 5,229 1,100 17% Health Impact 6,667 7,446 (779) 17% Printing 2,000 - 2,000 17% Program Expense/Supplies 1,833 - 1,833 17% Other 3,409 2,560 849 17% Total Materials & Services 2,001,129 1,612,312 388,817 17% Capital Outlay - - - 17% Contingency 1,934,507 - 1,934,507 17% 16% $10,500,000 $10,760,885 $ 260,885 11,100,000 11,100,000 - 151,900 151,900 - 345,030 345,030 - 775,775 775,775 - 400,000 400,000 - - 19,632 19,632 450,000 450,000 - 13,222,705 13,242,337 19,632 23,722,705 24,003,223 280,518 108,786 108,786 - 0% 3,000 3,000 - 15% a) 9,838,129 7,594,123 2,244,006 6% a) 1,300,669 1,204,540 96,128 - (16,162) 16,162 12% 423,150 423,150 - 0% 60,000 60,000 - 15% 260,400 260,400 - 14% 37,975 37,975 - 19% 40,000 40,000 - 0% 12,000 12,000 - 0% 11,000 11,000 - 13% 20,452 20,452 - 13% 12,006,775 9,650,479 2,356,296 0% 100 - 100 0% 11,607,044 - 11,607,044 TOTAL REQUIREMENTS 3,953,768 1,629,548 2,324,220 17% 7% NET (Resources - Requirements) 8,750,017 11,558,802 2,808,785 a) Based on annualizing 9 weeks of claims paid. 23,722,705 9,759,265 13,963,440 - 14,243,958 14,243,958 DESCHUTES COUNTY 911 Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital $2,600,000 $2,975,172 $ 375,172 Revenues Property Taxes - Current 397,710 - (397,710) Property Taxes - Prior 9,167 25,316 16,149 State Reimbursement 3,667 2,191 (1,476) Telephone User Tax 126,607 - (126,607) Data Network Reimb. 5,667 - (5,667) Jefferson County 2,667 168 (2,499) User Fee 5,500 - (5,500) Contract Payments 11,667 - (11,667) Miscellaneous 1,333 1,215 (118) Interest 7,500 21,137 13,637 Interest on Unsegregated Tax 213 52 (161) Total Revenues 571,698 50,079 (521,619) TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Year to Date Revised Year End Budget Actual Variance % of FY % Coll. Budget Projection Variance 100% 114% $2,600,000 $2,975,172 $ 375,172 17% 0% 2,386,259 2,386,259 - 17% 46% 55,000 55,000 - 17% 10% 22,000 22,000 - 17% 0% 759,640 759,640 - 17% 0% 34,000 34,000 - 17% 1% 16,000 16,000 - 17% 0% 33,000 33,000 - 17% 0% 70,000 70,000 - 17% 15% 8,000 8,000 - 17% 47% 45,000 45,000 - 17% 4% 1,280 1,280 - 17% 1% 3,430,179 3,430,179 - 3,171,698 3,025,251 (146,447) 17% 50% 6,030,179 6,405,351 375,172 Exp. 573,233 501,796 71,437 17% 15% 3,439,398 3,439,398 - 126,392 114,816 11,576 17% 15% 758,349 758,349 - 7,650 - 7,650 17% 0% 45,900 45,900 - 297,755 - 297,755 17% n/a 1,786,532 - 1,786,532 1,005,030 616,612 388,418 17% 10% 6,030,179 4,243,647 1,786,532 2,166,668 2,408,639 241,971 - 2,161,704 2,161,704 V a C C O M M U. a) M O L' O. yN. O C O LL O U y ~ O L N w U O r 44))ao O w N wLL c 0 4)) 0 a w U L O)F O O 1 O Q) N (O O LO N M }o LL N v rn ~ O rN C. LL (G co o N co 0 } Ci LL O N r Q N N CD 0) O O O N U) LO O N t LL Ln M ~ O O C N 0o } M LL er M cc W N ° LL N d' V N a O M N N M LL ~ O LL O LL 00 } LL O N LL O N LL F y "m r Ti ~ro0 N O 01N Q O O a 2m 7 L M O U Q = Co Q z Q N M O Cl) N N rn v V O Ln N N O co N M ai I O N M t0 m M M M 0 ro M m N c (O LO co O f-- 0) r N O O) co .0 ;1 r o 'n n LO Ln N (O 'IT 04 O (00 M v O N 0) '4r M M C) Q O O M V (3i 0 CD n O LO N M r to N N O r 1- O O O O co W LO Ln O o o O It o L°n °n a N a LO N N M V r O O N CO N r q O O O cO co rn Ln O O 04 M M ~ r O r M ~ ~N M N O r M M 0 0 co Cl) r N N N M N w r L) N N 0 e~ ~ O 0 O O O V V N clM O O N O O d'.-• pQ 00 LO NE N .r-Co V eN-r V W a N (O nrM OOM 'T M Ln r N 0 C (O N IT LO 00 W V LO r) LOn r LO° i i Ln d' Lo r' CD CD O O V rn o rn env ooo'It V (O L0 V OON r ~ ~~r N LO M O M r M ti r (00 O O LLO (NO N ,q t,, OO V' v LO vu) r oor LO. 0 04 "1" r ~ N W M r V LO O O Lo M r ' OOtO O (O vLO Ooo r O tp v O M O r COr °o°o c o o r (fir OOrn C v r Lo OO(V LO O 0 t0 N r Cq 00 Lo CD CD col m Lo c(Oi n °o °o P 0ro coo M CO N LOO (MO w M ~N a0 r co Lr~ao ooco r r r O O O N O N V' O O (O M (O M r `n Lon Lon r LO M N O O r; D) O OO W W N ' L°n_ LOn_ O W 0) rr LO n r coM V R V 0o N N ' Ln LO (O M N, LOOO 0CD C, m 00 O 0 O N N N r M rrN 0) M r (D C> w Q co L N O 0) Ln N co N v co V M a LO N rn M O M M O) C L m co o V co 0 m w ~f r V r 0) r 0 O r M C) Q co co co N co c o M w LO m O ~ Ln O ~ O C. Ln (O 0) vo U) n r (O 1 m M m V co M O M co n 0 CD M L Cc Ln O v M O O C N co ~ O w w 0 co co M r LO M c r N LNO O ~ N co OV 0) Ln W M O O co 0Mo N M M a co M O 0) Lri O M O M (O OMO 000 O W M tt aD V N M a V r r_: N ap co M O M n r-M O co O LM M O co O O LO O _ O V M co 0 m O N 0D O O M co 0 r ~ O 7 0 r O O C O M LOO d' M (00 R N M 0 0 (°0n LO co M N V 0 co 0 V) N 0 O O r O 0 0 M aO M ( ° (0 M N N M r 0 N M C N co co CD O M r V O N N M O O M L N N co M co r- LO O M m V ~ V O (°n_ r c a0o_ (O_ N M M N co r to N 00 M LO O M r v C5 0 0 0 't M m C0 O 0 O LO (O l C V N co M 0) o p r oo o c G 0 m V co W) O N O Ln N 0) M 000 MIn V w 0 m M M O 00 N O N O V Ln V O C 0o co Ln Ln N r M M It a co ( o 0 N( O M ww Gor Ln C n M N M N LO It m OD LO LO L L I ~ 00 co M 0 O M 0 0 N M L O co co 0) m OD CD m CD ~ co - M y 0 co co co co N O I COI w NI rl LO Lb N C O CA N C 0 O N ua" aaUim ° •o d O o, c a) rn..vo U C C N M O D= U) U N € m Q T LL d CD ova urLL v ° a) a)° L M C o E N j LL LL o o co O V O U d C V m a) 0 U) £c a) M M(n n O a N O d 10 N C 2 O$ N U LL ~a7„ O C a - c, m to C N 3 ~ s} w m Z y c w 'MOO C m [L a3 C O N O ° a N N r E 0) wQ C, M CO d 0 y M M' L C ` V~ N O L M d o ) 2 n O G aC oC 0,V) 0) Z ai 0 0= N r O) Q O O V d n 3 o c a O U N -0 N 'O ° IL N m .MO U~ j N ti w~ fn x d C E Q y C LLLL (a C N 1 a) O 2 ca N M M (A M F 'O 0) a) 4) C: 6CL 22 C D U WU.~ LL Q~ ~fO U) • •0 11] U G 0) a r- 1 a) U 0) V C-0-0 W V > m v o2iLLx 2w c 39°'9°' .2 4% 0 cm 4) m io Q m y U La Z M U li C7 0 2 c M of c c c a v o 0 0 C L a) M W LU LQ'-.....r.E2 U 0 0 a)d Y._~Mv a 0 c. c V nU E1= a2ioo rn o V E~ d° Z 0 n Ln o U c m 0v a)U a v c NNL cO ENS > > m z m N U W fL-' O d d W Z V COl m d h N d C r y o w cc p cc .L.. O r LL LL z N 1Oa u o° p) c C o m~~ o d d Z o! m c c d o y N 0 0 O) w 0 co a o > a 1.- 06 o>> o (n (n O. d U m° w a A E w w 5 w v c c yw m d O w pm c LaUUaU x u Z co 0= c aci m c c c z y L° O U O- M c Q a' Z m m e as as 3 as w 01 0) E c c 0 m o. m p 0 a) W w Y C_ co M CLL LL LL 0) A C O J J H H c~ F woo` aO2~~ o o ~aCM~~-~a ALL L~zLL o c c uy, m Q:J0 C H H X~rU F- F- w aQm000 W Li 0:e N O CD LL p O fLj1 N On Up(o1 N m N N c m~(v1~ O C= N CDf QN tD)O` X N LL N Q c C L n m U o1 O c O N m LL ~ ~ r n > o N E O c N j m ~ m 7VI 7 ~ U CD1 Z N"aO 4 ~ F F- p Q' > p Lr. LL' c d O 2 m m U 'O On u'1 , 0!~ INI iVI iOinV;OI n; ';CO' IOit0.0 OI .VI ' NI ' Oi0'NIp '01r ICiO; i0i 'Q) 0' ' ' ICI O R L-iC'f COOItO O V'O ! 01 OI I I ' I vl ! 1011 I IN;n :M iN Iff O1 c c m N !~I In! I! J T N! N. i CO I ~'In~ ~ A e In IM I ; !(DI I M O IV , , , , MI 1 1 ;O' Ain Itt)I~ O I i ! i 1 l I... ~1 Cv ! j CO A j I ~ I O I i ; I! I; ! I I i I I I f I I I I I 0 0 . 1CD to 0 0 0 O IO O OIOiO OIO OIOiOI O O O O C) O; IO 0 010 OIOiO O jM N OI'y a0'VIO;NI IO !pl I~'i N 10!0101 O;O O'~ i0 'I I I0 o ~ OIOIO I ! ! IOIMIOI010!NI O R1!O O O tn• AIns N'N O tT N 'O 3 ; i0 NIO V (O , I ! 0 (10- iN n; 0I 1OI tp'; tO V t0 y !010 Iri 01 N'VIO ~I O'I I 1V tOI ! ;OIV!N ' O O I- Itn!Ln;O 10 COIO!O10INI IN M 0 IN ~Im A n N I LL I ! IM I . ; I M' I~! 1 Ic0 0 I~ CI n n1011 INI ~I n OI LO M ~ I( OI0 (t 0 N! IN N., IN CO ~ ~ 0 + a N O (a U N CC m } O O MICR 't0 M O CA RC n 0I0 ! C V O I I I ! ICI O N OIVIOiO n V O' n O.tD O'O (O Q); e-I MIV IOIN'O OIO N'N .C;(O n• I N!N!Q)IicOIt10l ; C N I ~ 1 1 n 01 0'tp 0 O N O n'O n tOlp'I 1 Oj O ~ V M (pi le- 10' ! 'iN I I I VL- M (D'o'(p I OIL I i IOf; In (O!~! cO n C4I I I j I IC OLD- iOl0 I IC O!~I OIW 0f; ~:O (O I I I I- ~I- OIM;O'OIOIpp O (Oi010 OitO' 1 ! O;Mi0 O 000• IOOO,IAIOtriI n M WIN 1O I I Itn O M I vi ! l.L Q a I M I 1 VI ' I i ; I I 0 0i OI N INI I ! Mi . ; .0 N 1N~N!N ' iA _,__T I ~ I I I I _ I _ _ I I I i i I I ~ I I I I I I i i m j l t 1 1 1 ~ I~ IMI i t ! I I j NI i ~ U i I I ! I I I ! ! I i ~ ! ! I 1 10 IO 01 i Of I N N O W I i i INi i (O I I I I i. I ~i ! i ! ;O '.0f Q L~! ~I L i 1 !~~-i- : I I I j r I I I I_ I i I ~r `I i I __i II I ! '.N.. j 1 i I I _I i! I I I-~~I-_L m c jOl ! 0 1 , o0 IC .MM t0i 1 (D AI '01 IOi (DIN O!, (DI !n N 0 O M07 iMl I MI N OIO O 0 OItD ;NIN;O Oi o 101 Oi01 01 IOI00! :(O(O ' I O Itq Of tci !(OI !COI NI N N, j ITI 1 V00 iMl n'(DI :V MI (p'(DIO, 1Cn IM. ! Ifni COI I !n n O C CD '',pp 'O i0! Ip , °p IM - nin!V' 0 o (D!~I00 :(O V,O C iA! N 001 O MID M -M; 'NI N' OICO 'tn 01101 N N!OI I O O V O 0 10 ! 1 0 CDi ' ' I I~ g :,~I i m toI I Iv cd" ri1 InICD i Aj (p ((jlpl ! !(n of I O O7• '(ri 1611 ' 'nj1 ! 1 1 1 Imo! ~ 'MI iMl M V N' N V. IV i0I Oi IO! .psi. olnnV CD In AI olo! T .Q j0 ICI ' I - oo 1001 IOI((01V~CD i 1 ! ! M S. e°n nl ' NlNipl ! 1 ' I 'N Q I(O n iN;,. 0 rn INI tp ,N VI N.I NOD'. IM nIO, N 1 M C COIO IM M! ! ! N I 0i L ` 010 O ~O O O. 010 '0 ' O CIO; ,n:n VI O 010! '(OIL-aDI O 0 0: '!(D N O 'Oi A ;N a0 10 M Q1- 'M nl n; O OI COiOi(°q ! - O W O(Vi l ' N' p m 1 ! 1m 0 (O~; 1 I I 010 M; I tp! :V M. M n, c4i NNIO lco (D~OI ' ! I 1 to O!~ 1 p ° Inlnl tnlpi . i i~I 0 nIC. LV MI M (O ~ v Z' (a .O O! .OI 101 1 'O ' O 10'O~ nIn V O!O !Ci.- W 1 OIO CI !A :N 0; O M N !0 010 I:> 1 1 -L 1 'MI N, C ` j IMI IM j COIN aOaI !N .(O C3 IM ! •~M 1 N O NICIO p ICM ' 1 ,i iv, !N ! :t0. a I -N Z+ T~` yr-~- ;OI p I O' njn V p! C - !(D In 0 MI ! 100!0! ° -1-~ 101 0. : O! -f=__ M d 7 ! O O. OIN O Mi0 1 m N ICIN!0 0 ;O ! ;M ' ' OI iv 1 iii 'V 1 O! N' nl 'VI(OI M n!o1 V M1 n: O_(0MI i0 , lOl O! v ° I IOfI v' - i j I I _L_ a :01 O! 0 0' ' Oi I(OI~IOVO O cD V O IN a0. 0 CO CA Ni O i0 O ! M i 00j1 ;O 0W I U . IM NI I 1 I ' 10' ! V I . Cyl in,~ N INp; o Njtq ! OCO:M. n i0. ;C rn ' N ;n n V! , E 10 010;, 1010 0 Olplp ' 10! Oi 101 O ! (O!~ OVD 0 I 0 iN 01 OI n', O!OIp 1 ° n C A.., (01 ~0 - I__ Of m l, C V•~ 00 N O 1 (D 1 CI n' N M 011 I IC ! , Aj O, I OIN10I IOI(D M ! ! N 0 NI 00 !p1 IV I O I 1 ' . INi ~i ,V n C, ~ I I~ Q7 1 i ~i ~:'Oi Z I I d O O' IQ , OO , Oi0 n1n I 100;001 t0 001 C V [D !O,A. IC14 Oi0 M 01 M IN' OIO O OIOI 1 ! I O 'Ip p,, 101 0 p ' ',A, ;A : r0 ! M NI CI I, IO ! V. ' !0, M. i !V 0 1A 1061 I NI C=Njao 1 !O~(D M j O".p O' (O: (O O 10! O _ N iOf ! V;O in (O ° v~ ICI I N A I'• j I ! j N ! I .M , ! Imo'. (COIN 0' !M m "M INI ONO°D ' IMM1 1 ' O' .i(OI a ~i j 1nI aii Ivlco (+i1 0l 1 Itri'cD!00 1 I n1n tri Imo; m IC! ! In COI V I:~,' i INi Imo; ii0 'ni i~ li O ~0 M V ' N ' ' VNIN ~OVD O ' CO A CVO COLD 0 00 ~ (0 ° 0._- j L~ }~Q NN W NN in NCO N A N 00 r-r,: (D O O V ' ( p ~ 1 i i V ( M V P) ° N (0 7 N NICO 10 CD,COI ICD 0- ' IM N (Oi OI In V 01j~ V O! !0iN 101' N 01 ` IV 01 MI (O OD 'O -N V - ! 1 j0151 (+Vj OQ1!~- - : ! I ~Ir. ! ! 1 ; Q Q I ~,tnl ICI r n- , ! I~OOI IN1 e►; NICD N 0 .(AI ' ~ i N ~ I t0 I , 1 1 0D • . 1001 O ;0101 I iN O) I 1 ! M I tO (O V N. Ip.~IN n ' ' IOICnIV ; ! (O 01 ! M O IAI CI O1.. ' ~ t) M1 1 1 ! M1(DIm ! O 01101 I '-L~ O'Oi ! tDIOI 1 Ito 1 I(°pl ; I 1011 IGI 7 O IoM ~ 1 j ICI I~ ! ! j I n N ICI ;CD OI Imo. ICI co Mi ; 10 V1 ! A I I i I I ' I ~a' ~I 1 1 I ' ~ i~i i I i- j ~ - ! ~ I}: ' 1 i 1 1 NI i o. ILL! I m ( m . MI ! 1 m ' I ! O' n I > m I I 7 I to ( ! > u Im ° ! I•- m: of i CI ;a, w INi I I INI I . ~ l a>il ml i3 I ~di IW' r 7I N. N I I mlm OI 0! i -I m I .Ca.. UI ml U: I~ c' NI NiyA L C NI Q' V :ml m Z x m tnl (D WI m O 1>' a i01 G x W. ! , ~ I U I.-: ! to O' OI 3 Ir ' m 06 1 O , I LL` ILL! a Olat I ! I I > CILLI I 010 m >1 mi j O;Otl m c o1 O O m c m o m m ogVl mI ~I c ml « LLII miw U c a xl mI m; lw ml ml I `I O 10 1 ! Ito' G1I mI ( 'O'! m > > C N ILL ~I ml o Z c m C j N C m f xl oi'Sii f0 U- co rn INI > i cm ml cl jl e L rn a N v an o~ a' m a! c1 m cl Ni=ICI m c•-' I ml c c m ai !~1 1 mI = c'I c ~i t l ( i I LL (ma of 2 ` V~ 0 F UI m i I mIQ 2 ml aci I._ C. ~ is ml al Ei of °~I ! U a`C m! m 1 61Ic;c U ' m m1 N O Oi an d-n-; . m! 2i Y; ..m m m' ' l nZ) > m C V •~--i m ,~Iw m 7 m'w c o c Ial f O' I q1 cl I >I m m CL in Ul a o ml O xla;C-) i =I =,2 FI nIa 2IU 0 I a i a I~.u1S ~ L ~ t o1 a: m o C9 ~'Q'a ~ z m ~ I cl I i I LL O I I I I I! I I I t -I OI I I I I >I ICI I i I mI._ m Io,mi~ oi~j I W Ci) iz Deschutes County - Fair and Expo Center YTD-Budget Basis Statement of Financial Operating Data Two Months Ended August 31, 2007 RESOURCES: Beg. Net Working Capital Receipts: Events Telephone Fees - Events Parking Fees Storage RV / Camping Horse Stall Rental Concession % - Food Vending Machines Interfund Contract Rights (Signage, etc.) Miscellaneous Interest Total Receipts Transfers In TOTALRESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Budget Actual Variance FY % Coll. % Budget Projection Variance $ 75,000 $ 10,606 $ (64,394) 100% 149/6 $ 75,000 $ 10,606 $ (64,394) 330,000 327,950 (2,050) 17% 36% 920,000 917,950 (2,050) 30,000 28,853 (1,147) 17% 69% 42,000 40,853 (1,147) - - - 17% 0% 6,000 6,000 - - - - 17% 0% 60,000 60,000 - 50,000 67,374 17,374 17% 25% 270,000 287,064 17,064 - 1,472 1,472 17% 3% 55,000 56,472 1,472 62,000 89,264 27,264 17% 28% 320,000 347,264 27,264 - - - 17% 0% 2,000 2,000 - 5,000 - (5,000) 17% 0% 47,000 42,000 (5,000) - 4,000 4,000 17% 4% 95,000 99,000 4,000 834 2,128 1,294 17% 43% 5,000 6,294 1,294 1,334 2,401 1,067 17% 30% 8,000 9,067 1,067 479,168 523,442 44,274 17% 29% 1,830,000 1,873,964 43,964 - - - 17% 0% 705,353 705,353 - 554,168 534,048 (20,120) 17% 20% 2,610,353 2,589,923 (20,430) Exp. 148,652 141,757 6,895 17% 16% 891,983 885,017 6,966 150,362 189,715 (39,353) 17% 21% 902,542 975,810 (73,268) - - - 17% 0% 359,101 359,101 - - - - 17% 0% 45,000 45,000 - - - - 17% 0% 250,000 250,000 - - - - 17% n/a 161,727 - 161,727 299,014 331,472 (32,458) 17% 255,154 202,576 (52,578) Current Month Events Prior Months Total Accounts Receivable 40,000 19,190 59,190 13% 2,610,353 2,514,928 95,425 74,995 74,995 Deposits Received for Future Events: 2007: September 34,906 October 6,297 November 12,480 December 775 2008 10,705 2009 and Beyond 41,037 TOTAL 106,200 Deschutes County Fair and Expo Center Statement of Financial Operating Data August 2007 RESOURCES: Beg. Net Working Capital Receipts: Events Telephone Fees - Events Parking Fees Storage RV / Camping Horse Stall Rental Concession % - Food Vending Machines Interfund Contract Rights (Signage, etc.) Miscellaneous Interest Total Receipts Transfer from General Fund Transfer from Annual County Fair Total Transfers TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency Year to Date Budget Actual Variance FY % Coll. $ - $ - $ - 100% 0% 165,000 157,662 (7,338) 17% 17% 15,000 15,863 863 17% 38% - - - 17% 0% - - - 17% 0% 25,000 28,344 3,344 17% 10% - 1,472 1,472 17% n/a 31,000 40,541 9,541 17% 13% - - - 17% 0% 5,000 - (5,000) 17% 0% - - 17% 0% 417 1,210 793 17% 24% 667 896 229 17% 11% 242,084 245,988 3,904 17% 13% 242,084 245,988 - 17% #REF! - 17% #REF! 17% #REF! 3,904 17% #REF! Exp. 74,326 74,642 (316) 17% 8% 75,181 85,789 (10,608) 17% 10% - - - 17% 0% - - - 17% 0% - - - 17% 0% - - - 17% n/a TOTAL REQUIREMENTS 149,507 160,431 (10,924) 17% 6% NET (Resources - Requirements) 92,577 85,557 (7,020) Deschutes County Fair and Expo Center Accounts Receivable August 31, 2007 Current Month FMCA 60,000 Food & Beverage (estimate) 40,000 Total Current Month 100,000 Prior Months: July 2007 The Rally 17,000 October 2006 Angus Banquet 125 April, 2006 NW Expo & Trade show 2,065 Total Prior Months 19,190 Total Accrued Revenue as of August 31, 2007 119,190 MEMORANDUM To: Board of County Commissioners, Dave Kanner and Marty Wynne From: Jeanine Faria RE: RV Park Date: September 17, 2007 Attached is the report on the RV Park Construction Project, reflecting activity through August 31, 2007 and updates on commitments through the end of the project. Two change orders submitted by Corp Inc. have not been approved by Deschutes County, but have been included in the total cost of the project. There have been on-going meetings to discuss these. Copy: Mark Pilliod Dan Despotopulos 9/17/2007 t~ O O N H U W 0 w d w 2 F- 0 C Ca Y a O C= ~ N 7 ULL DLL 0) Z j 70 O CD _3 o V) ¢ Z 0 U Q' W H Z W U 0 a X W -D C Ca LL to t` N le 00 CO O O M LO 00 t` CO ti t` CO ~t co LO CO 00 O O N 00 O O r- 00 MrC'M 0CD rfMO r V ' CO t; Ca O 00 ti CD C \F C \f N Iti O 0) r 'R 1.4, N 00 N CO CO 00 tf) r- N 00 00 00 co r r r r r MI- NN CO 00 LO OO MN~-OCO CO 0D C N CO It M It 00 00 0 0) N M M h (O to h ca CD M T.- CO r M 0 d- N O 00 V CD 00 OD P. I 1- rN -I:i CO q~i 00 L O M' CA I O N It N O 00 (0 CO 0) V 00 M 0 L6 N~NCO r ~M NCONN t0 tO ,~T q C O Cli co CD co co 0 0 0 00 co ' r- O N ' L L O ' 0) NO ti M M N In CO Ic f` 0 P' M c° CEO N V d0- t` N N N _ N N C7 0 C v) Ca -0 0 "a a) v^- _ O X. j N O M h N N 00 00 CO O 0) Cl) N r- 0 00 CO O 0) E NCO'IT M ~tCD 000O NMMtitn LO t` Ca 00 M r : V C0 ~ M tO r d N O 00 V CO 3: a) O0ti If 1-t`NI-f to 1100t60M OA Ili > NIt N0 00 (.0 C40 0) Ict 00M O a N - N CO M N CD N N M O 0 0 d M d If m 0 L _ C 0 LO v It I-T co 00 O '0 0) N 0 CO Co O ' 0 0 0 M r O O O O 00 U N N N N ~ C N 6 9 Ca N CU CD tT C O Ca M P- N N co M o O M M 00 r Cl N 0o I* L NC0IT C'9 V rrOC- NLO CMt-00 IO t` U iT COMrr qt`OMv --LONOO a t 00 O O 00 00 rl- V I CO N I;t It 'T 00 tf) CO fh - 00 tf) O N 0- N t N O N W 04 00 00 00 M d ~ co 00 O CO N 0) IV M LO N ` CL N W +r N 1 ti M M q 'p O 7 U C4 -O 0) a) ° o X o - O N O O cn N W ca cu 0 V N .C 0) Q U ca C: C~ a) o 0 N Y CA 4) CD rn a O m -C C V LL > C ~ cc > U O - V N ' O 0 C to O U) V) ^ N C~0 D C ! C C 7 Ca ce) O U 06 0 3 Q 4 cc 0 L E O o v c°'i u, Z rn U) ' a O M as 0 0 0 ° k C O M E j O O O U) cc Nis V 3 v O i C6 LL O o m E - 0 Cc 0 a) O ` M O W a) E 3 V U Z C a) V OUdrL > U) O ~Q Y V C 0 O N co O 0 0 (a 2 3 V N , y - Y c ) ` U Q. m « Y CU N Ca 0 O L 0) O U 06 cn M 0 0 v> Co 1t U N ca cm 7 N a U) ` ° N rn r a) c D a W odCA O Erd C m O n (A C C t- OS oo " " ~ DO0 Ca > > H la LL LL O m N > C W co ~ p C L Ca¢d CLL ccaF-~¢J "p 4) 6F." W M. U m -1 9 H z U I- Z m U v a -a Y Q a Q.' Z D LL Z Oti N U~M N ~ N w0 Z 7 ~0 rn Q O W 0 z Q Lu U 0 CL X w C co LL ,~t ti N M It 00 O O C-7 O (O ti (O 't co O co co O O N 00 O O r- 00 Cl) ~ M O CO ~ m O r 1* CO ' 1l- to O C6 N 0 N v~ E v~ O c 0 0 C O CD 0 to r N 00 r r 00 00 0 0 1~ N O CO 00 O O (3) C7 N O IV (O NCOqt C'9 x(0000 0) NCV) LO to ti M C 'l 'q Cfl r- C7 O -I ct O ' r CO f-001~ N ~I- N qT O 'RT 00 04 00 0) 11 N ti 00 r CO O O ) o co N N (O r r C7 N C7 (O Ch M M M ti ti O O r- CD (6 CV) cr) 04 C%4 co co M M ~ ~ co (0 L U 'O CU .F ZA ~i-N O 00000 0 C7N O (O N Cfl ;t M It co CO O CA N M to to I- M M co I-t (O r C) O .~,.a. tf) ' (O P- 00 P1 N ~ P% C \f CfO _ q oO C CO N~N ~CO M O CCD N M o t M M M M' C 01) LO w co 0) O co 00 ' f O c cr CA C; 0 N N to W N N v 1~N O CD 0CD O to C7 CO t0 er NCD d M ct~~O f~ NLO co O P- C,! M r O d_ O 0) V O Cfl ' r CO I-- 00 C4 ICON t -t c700 N P O O W N C* ~ CD CD I'll O r to N N tD - CM O O IV N C7 M M M M N 0 CU y Ca c C V O N O 0) S N _ y N U C C > T 0 _ y C 0' O 3 y ~ CL 0 m y y R a) U) 0) .L Q. m ~ y O LL L. 0 ° cts°: r + a r W a ° 0 cu o 1 oUd~ V a t j , a- d 41 y U l3 0 y c0 CC O K Oa CD c c w N N ;a CD ~ > c Co 0 W 0 c CDQCL LL c 4 caF-a O ` ~JF- ~F- U U H Z C ca H O (6 ~ U) U) LO U N 4 N N 64 > (0 c O O "0 N C ( E a c m c X O a) E cu co > > i O 0 O L N co N O Eg C O N L co C C\F ffl ca N 0) ~ L r~ o m r. U 0 O O ` L O N a ` N ` C C a0- it w y -0 ` CM N 0 CL N O to 7 O -0 c w 7 N } (1) N Q 06 LL L CU L.: LL N y 7 O o N O V -OL CU cu L ~ w U1 `p 0 CC O O N N O CA co -0 C 0 a) C C -a CU C: C 0 cu =1 O N " C) ca O 0 " 0 O I- C *k O U j -0 -O cu .y+ C U) o O C pO N (0 4- 0 m = "d NM a~~n -0 co0 N O N E ~ CC C odui ch 4) w cu . U LL L 6-0 (C .n U 'C0 N y. O ti 0 0 N 0 0 N ti r 0) Y 1- ~Z Cl. LU c~°o OON C U 3 M L Z C Q O (n > U W 0UQ X O W m Q m U Z W N O 0 U C co (d m ca a C O O E Q C a) E C E O E O Q U c O Q- U rn a~ O c CU ti 00 CA N O O O Ch N ~ M CO V N 0 0 0 ~ N N I M 0 ti c cp O m U rn c Y c ~ U c O U L U) c O ~ U r Q ~ L OL Y U V c Q O v H ti l f` r r O_ O o o N N ~ r 00 co ~ r CV N O rn m L U m U U N c N C LL ~ L N V o v U N (/j C c E° a0 Off CD O w N m co Icy M ~ qT O 1` I` r~ N to co IV O N M Ch 0 Co I r co It Ln r - CD It CO N ~ co IV C[ r N M a~ m c a) U) N a LL c 7 O U m rn CO c M U C O .0) II\ LL QW N ~ V CU •U d c y Y 0 U) otS OC Q ao a C C (D m> v ~w O a O > r H C O O a0 O N oN a C O 7 L U a) L t: CT O O Z O L (n c CO O C U 0 C 0 (D C LO Cn iCD ' co LID N O O H et o IV 10: IM!N p p i ~ I r- CO iICD!'!qqt LO it IC N 0 I 00 M O O O ao IM O O O I tF (0 co O IO N N CO co M I Lo I M' to r Cs) l vI Mjv v CO ~ I M IN N O CO O co w I > i 00 I I N jM I i I I i I ' ~ I I ~ I I I v iv I I !~ci ! j I I l i I , ! I I ! I I ! i ~ I I ! I ' T j i z co C II- iO• 00 CO O qtr M M i Ol Oi 0 NIOiN M 0100 0 Vi0'N NM I co 'M I COI 0 O 0 iCD !0 O O co co E- U- -O 001 00 N 0) O Co 0 PI M In I i I q O q T.- CO O i '-T l M '-t O 00 I C cr to l N- 0 0 1 LO r 0 M to d• O O [I M U LU M O m 1 I p ~ 1- 1 0) O O OM! NM I Cfl IMI ~ qt 0 N 'IT co (3 N O co 1 O 0 l ~ e•• i I I I i I mo; ~ ~ i I ! ~ d ~ W I l I I I I i I I! l I I~ ' ~ i I ! I i I 1 O N 0) O I o I CV I N! Imo ! tt O;VIO 1~ l 010!~' Ni CO' F Ln 10 LO ~I 0) j c-!01\ C CL (D ! L U a) a) 0) I IL ~iCn!O N 6 410 ' Lo I • 010' ' 0, ' IOI o o co d M C'j N N O N "IN o I.. O 0 O O 10 0 N .Cn CO oI Ln11 M O OIM1 1~1 I OI. I M IMIN Cn O p t ! co M d CO I CO N I 0 1 , I co IM I O I : i i I I I I i I I I I I I I I i I I i~ CO 0 O ItiI IO C - 10) Oio U) OIOIMINj00 01 ' O O co 1 La 1 I~ O O I~1 O'M o "t f"00 r- IV I CM !00 0 0 f~ ICO O ~ICnj~ ill 010 i0 iU') 0 LO ti IM 1 ti v a 7 O ice! j0tn IoI .-:CO Iui Mltn tnlf~l0 ~1 co CO,M1 0j r=1M v l d I It co 10 ti (O O Y U O. 00 1 W! O e- N 0 0 04 N N Cp j CO IL O ~ I r ! ! I ' r ~ I ! I I ! I I I I 0) l ! a W N O 1- ! O N I ! j j ~ co I j fa Q L 00' f` j C~ I•-i N 10 N ;CN O e! 0 O in ; N n U Q) c cu ~i 00 co COI e- co l ~ I 0 0 t e_ i M Oi I IMI co INI IN c %j I a) U O i I ~ ! I ! I CAI y C CQ V LL ; ~ I I 1 I I I I 13~ o - 0 O , I1~ -j CM LO IO10j0 10 N 00 10 0 0 I0 '00 I~ 010 Cn \ 0I r- O 0 I I • M M o ~t1M N 00 O' 1 1 - I O I r` D O I CO) i : ! 0 C0 I-ICO'O;"t LQ,N ICOI o . ' iM It 11~ N M co 0) jCI p a) - C CI O ° O ~ i ~IC7 r- M!tn M'f`I0 iCO I O <n CO I M V i IOIMrS f7 1 N I In I IO 0 01 Cp (010 ` I N O O U d X o l 00 0 II IN a o CO I N r fn to 101 0 ! r 0 M U a) 06 ` W I 1 ! LL a) ~I ti I ~ I CI N I • !O ~'I CO ! I j pI a) I O li Q) ~I ! 0 NI I 04 :3 IU (On (0 ! ! 0 U Cn c: E LI (D I 1 ! : LL LL a) IL C; O U) 3 Ui tnI 0 Q) CAI I~ IU `I a)I~ j NI U...I N O O U 7 W l Oi 0 I N U) ~I i 0 > a) 'J I o D C 1L E N : (n ! I 0 z I ° c ml ~I ~ ~I~s L O I 3 I : ! ! N a) l c r a )I„-! ' o (~I cl Ca' o' L 16 CA d •w c l o) H a) odl~-' U;'c c NI aIwlrn 0) 3 w of 2l o co las l , o Imo. :3 O o ~ U o l a i - 4) 0 U j , a) N (a O O - C - ca r- U) C CAI ` y w! w g l 'a c c rn c a) (D U O U i 31 V I Q' : c 1 lal a) I c c o ~!m" olc ~I ol:° cl o IH -0 f ir.a O c 0 IV ~1~I 21 Q It QIU WIU -Iola. Q l oI i _ _ a)I~IC o z (n O W o R , l 0~ Z F- I , ~x~ I I I ~ I W I c) o I . ~i 1 ~ F- I Z (a w O 0 a)) j a 0.} O co i op N Q C7 a c O U U) 7 L U N CD L O Z to (Cf O Cn 0 N 7 C) 7 L 3 O L .r C O a U C N I,- CD O 0) Ir-O In j0 iLA!N '-TIItI 0'! 00 CO I 00 0 0010 o ce) O!lp!Mit MIOINI0010 OOMLAIDO10'MOIV- COgN0O!IL 100 N CD 001 I 'O 00 Q a) O IM jr~ 0) ~ N LA CIO LA CO LAILQ t- LAIC ILIOI~I~iC'O I") 0) 1 ~O M O O (1) C O CI O 10 LA O ti ( IOiC) Uj M LA 11 ! 00 O M LOIN (1)iLAI~ ~ vlq NILAILOI(3) CO CO N C141 M co ! O ! 10 j ! I OI j CO l ! 10) I CO F- U > a (D CL 10 00 O 1 ~ !00 C IOILf)! ' Icoi ! I co I ' 101 10 Q X W ~ N ICI I IC e-i01 ! i r I~ ILA! LO ~ I I! I i i ! ! I I! I I!! i I I l I l l I I I ! ~ I l i O O I I m I I' ! to i! I I I 1 i 1 I 1* Lo lo I M!~I COIN O'M aD O IOM tild i iI ! ! ! i iI ILA IN co 1 ! SO !0)! IO ! I CAI ! d ! l O oo N N ~i O N V M ~ L (R LA rl 0) LO li COILAILf) ICMI 'e-; ~ ct ! N N 00 O 1001 O! co 1 0 0) 0) ! ! coI I ( ' Ico s OI 0 0 O i ! I ! I j ! i I ~ v ~LA i L0 1 I I I ! i I 1 I I I 1 i i I ! I ~ I I LAILAI U.) ~i I O ! O MI- -tao00010 ! ' ! i l O 0: NI~ICA 00'f- I,O It l0 (O'01CD 1M LAIOI O' rnicOlt~lo0 N ! 1 i I CO It ICD p ! O V C) N OMI O!ICA O chM NILAI0;0 LA!COI ' ' 00 CA1LAV00 NI IN Lei; MlOjO lA!C7 CO I,- It 0) N !<t I - P INI O co } 0 ~I O M ! N M NI0) OOI,COiN f~i ! 04 jN I N ICO I ! N ! 'OI 0) 10 1 00 0 CO LL ao co ! 00 O ! 1 ( i to ! I . 0 o I O 1 I I i I LA LA LA LA I rl co O CIO '100 ! e I ti 100 COI d O: M LA I O CO CD 10 ' '!tt N! COI IO! - N CA N ) N c 0 I 1' I N I qt I ! Lo 'I N! two ' Lf) ! i T I O N q Ito tt! ! ! v ! ! e-I C LA 0 (O ! J 1 O MIO ' r- C) IM r- ICD i Y COI 10) IN M c-i ! l ICO co N I l II N CAI C5 LA to to 0 LO M j j ! j q l i 00 ! CM } VI N i I j ICI ! 1 ! ! IW r C-4, N qt I ' V CO LL ~i 1 I ! ! , 1 I I I i 1 ~ ! ! L6 1 ! ! N ! O N CO 10 to ' 1 ! O ~ ~M O co, IN I- co CO : ! COI ! ! p l C), ! I co CM C0 qj ! 0 i 1- CO 00 N jLAIO IO I Id i0 of ! OI !tA LA, NI !COI N 00! Ln!~I LO Id ! ! ILA ! ICO: 101 O ! !00 N ao ti 0 I LA I L NI , r !O j ! oo I I i ~ N MI I LA LA I 0) N LL . ! LO NiNI d ! ! MI ! M M O IT IT 00 tA !CA ' !et l ! ` O ~I ! !r`I jtA, ;Ln l CA S I ' ! CA O N O N N 11 j co Ip! ;O o co CO I 10 'rn ! co ! 0 to 1 I to ! CA LA l I I! I I I I I i ! I ! ! i I I I 1! j 11! I I ~i i ----r- i ! ! I I' I I! ii i i i I ' O V ! tn; j ~I ! ! 1 to I pl y INI i= ! ! 1, (VI C I a) 0 W c c ! UI ~I Ci IQ I 1i ! i9 c W1 N 7 N L cu : l O (qI !LL v. iC IE!m O C)IY oZf! yl CI UI L, y 7 !UI ( o.-I III Iato!O' ;c ca;.=! olz O!U) c N l~' o ! ImI 1 i CI O U 1 ~m NI a)I O > ! Uj ! d ! ! c O O i c Co I. (n' t7 LI.-•Z -I mI rn -a tnI . b! O ~ LILT N i UI cn " < a). CL O I E! 1•UI 3 C I A c6 c O Cn L y.I ' l i INI t O 0)1 O (VIN 0)ZI L L W!LL.I L IL O d1 O E a) N, a LL I N a L ca ! Co I CL N 1 N; C L ! U) I~!v' Y W i C co I cc ,d? j d tn td 10) I U) « : c c L C. O ! : ..1 , talm uJ C x CL m 0) I Nj I- ! ~ I- O Imo!>10 >,;OI 'p - > C O -0 C O c U Z Cp 0) Co O F- L ca N ! W 7 "I I~I N 1 I~I N I L 0) 1 ! _CI C m 0) 0) N N cis H! > O c L 0) Ji-LF- M C N N •L~ NI C! L C •''i a!fni 3! C 21 C E a' c UIL; co l p!.r 'tC +)I q) ! 0 i N 0 N CO ~ I UI N I N L ~ 1 C - C C j ICI O O j X. t6 0 > I O I0iw W D cy U'a Q a fA w~= YI- ~ (L I I I . I I i , , LL < H- LLI 5 , co I W C a) E a O a~ m 0 a ai Q L O Z c O U L U a~ ti O O N co N Q m c (D E E E O 0 Q) > ~o 0 U O C 7 U C W N c IN COi 00 co I,- CD O ! I1~ c N ~ICCI N ItO :e-0 I O O~ L~ f3 O 1 1 I I~'i I I~ 7 m I I N N V O w U ~ I j i i ~ I 1 I I O ODo.M N'O j N a p©I rn'Oqt ~ e°- CU 7 M Lo I' Ci o Lo E~ ~ Oi I ~ O! 0 Q I I I ' I N C a) c~OiO 0) 1010; ~10 1N0 1 ,vV ` C N E w 7 O ~jlOjO 001 i OI Lam O ' ONO '00 E E 7! , ei 1 U 1~1 j 1 ~ W ! ; II i, I i IE i C O a 0 C! rn! C: i,~ C Vi 1 (D 1 ~ tV Q) a) C 0 od °i of C! j o, 0 w.! c9! V! U; c 7 V 7i ~IOI~ L ~ ~ to ci I~ Iw 1 i tq ' cU I I U `I-Q O QIQUj O; '0 . Ulcg I I I i l ~ i p~ ; c Co . I O U i n p jj ~IUpi > L, U a) a~ I ' c! ! O Oi Ica ca,~ j l Uisl ~ i UIrL !Zi ~i C Cn ~I a'I II I > o Di01al iyl< 1 I-- O O 0 E O O N W - z., ` M C N O N cm 0 Y a L L 7 y ~ L O U.. 0 EFE c 0 N Q U C L Cl) i 0000N00CO MCD N OIt Mf- V- tnMM to M00NCO I- N 0 O f` r ~ 1, Op co 1l- "Cr w N M r r N w Cl M V- m 0co 0NCOco co 0 Od Mr-- LOM to c l! N CO I- co O fl r co N M o N p p i i i co o r r r r O M e N CC) M M t- o OCDM~ IM LO M Co r CG N 00 r r N CU CO) C N CL x tq U _ W U " O C i O z U U U) w F= U U) U) O O O r 0 co ` LL 0) U 0., otS. (D d of U U U 'm f19 L y vi O) w ~ C O ` C Q W U 0 O p 0 CA 7 L O 0 0 N } LL C C6 N N w. C O CL x 0 E cn N O E c a~ U Y O U O N .r- U) c O U N t U N O I O O N M 55 7 rn Q 0 c O E E E O U c cu v7 U c .D E 7 U c w \ U C I i0 1p 10 1 I~ U . I ~i~ cql c I°i .cu E c CU j co ~ ! ui E E v O m J U ! ! 1 U I i ~ C)i Qj O w. (C Lo i co i M o I I CI IN ' I ! Ico O O E F' Q ~ I i I I I ! I i I O c N OIOiO ~i0!oooo i0 IM Cfl N O I 'O IN 7 O Lo;0I(D s- I 10 IM 1 ! M M ICI I I ice !ti ' j E E E Q N N C O U w 1 Co I a ~ I o~ O c l E c o `jam a o!U ! c~I ~ 0 ~I101 c I C1 E E10 U'Q U 01 UIQ caIi ~ ` ~ Q N I ca ! I-, c I Mi U) O',fQ ` M ; I I a>I i c i I L c fIIi a i ~ I I' I I I i °a . c > . 0 m~ ~ L Q cII Z I i I- C) O N M c in c o rn U E to O Q (D O) 0 « O W 0 c O Q U C . I . . O O O O O O O O O O O O O LO O L f oo Lrl- O M -1 N1 O O O O O O N N M N N O O O O O O O O O O O O LO O O O I- ti co LO M N t0 Q U 1 1 . 1 1 . I I . ~ C C ` d m v> 7 O c _ to > O ~ :6 O L E- Cn J a O O O O O O U') O M O N P N M N N 'O N Ce) CO M N LO d to N n- M N N M M ' WO D! L6 W~ V! N Cl) M to ~ co to N N N N N L d V d r c N LU K C O w r t0 O Lo M M N t0 M O L Lo N tD 01 LO N N a z N c N 7 O O ~ < Q N O ~ N N rn -0 c O N U w O L c L1 O N O• U o0 Cl) CD 0 N O U- L 'Q C L M 0 W ) C ^WL^`` W ~ c a) (D ^0) -C C -C O L co O Co N co m -C ~ N N c O U O > C Lr) U O . U Q ~ mo N L O LO O" O U c m n c O O CU m C tU O~+ c N :3 Q c . c O CL Q) (D O > > Y N N ` o Q j O > CD CL E - Cl. t.U i. O O N E U C L E 7 O O O L (0 Jc~C~aS 3 N 0 'O N n 0 0 N n W U U O m C N r n. (D m m C N 0 V C 7 LL c N CL x w 2 N 0 o ~ N em+ 7 ca (D 10 O = m O) c H v c m c O L W N C E w c 0 U ° I 'L i2 Lo ao ! n i i mn V'IN NI N 00 ' i ! i u~ u~ i o 100 N O N! M ! I 1 I n I ! n O)I, W ! 'co 00 10) Ul) Go o l i 1010 N ItOj O M 0 Ief ' C 0 i j 4 I Inl !O ! 1 1 Ih I ! IMI IN y O 7 ' ' ! ! ' ! , I ! ' ('III ' ' ' I' ' O ~ I i~ l I ! I i l j i I I i 1 I I 'I I I I I' i I I 1 1 i l I ! a 125 ca 1 ! 'I g ! C Q I I i I I i ! i t I' I ! ! ' i I I I I I I' I'j' ;'II'I I I i I m I ~I 'I I- I I I I I I' I I i I j i I I I 1 I I I I I I i i N mT I ~ ! I II I ( 1 I i I i I I I I i I I I ! I I ' I I I i~ I I i i II •I a-mi ° ~ , j i 1 1 ' I ' I I I I I, 1 I I I , I I I I j '11!1! I I,,! I I I I I ! ! I I I ~ m ld ! I I' I ~ ! i ! I . II I ' i I ' I ! ! . 1 i ~ ~ I I ! rn I I ~ 1 ~ I 1 I I I I I ! I ~ m I ~ 1 1 1 I ( ! I ~ I 1 _ ~i i ! I ~ I I I I '1 I ~ ' ~ E 1 j I I I I ~ I , I~ i I i I i II ~ i I I i E ! ' ! I I I 1 i II i j l a vi LO O I~ hf-+-- ( I c M E ° ' Z ~ I I _ i I i 1 I I 1 T 1 I I i y F. I i 1 I I i ' I I I I I I I I I ~ CD O ! ! _ "s o 7 U ! I j i , I i t 16 W - ! I co ~ rn Q ! 7 1 ~ 110 :00~i, n I b ! lnlw !O N Nj0 M IO Co IN ISn INI NI Ni m0 !N. IiM n r- im j0) ' i ' N i 0100' OiM iMl O O iN o M INI II~ ) n • y- I I I i . + I I I i I I I I jT C 7 . • m c m I i I ! I I I i I I : I I I I , I I U c V l l I j l i I- lcl j i t I ! L,I m a IS c1 NI N CI c l N °a c1 4) S I a = I ,N 'E E I I N c ~ I m a E' N m CY) L i I E ii !E ? 1 yl ,11 I t' ll I L IC o C. of I • l ' Ei ~ INI I~I~ ! c o' N~ ! V 71 INI j~l c o 0 I ! , to ai 7 , l N) NI rn ~'C OI 1.. c 7 o!V! l . ,7p 0 O o o ° vl I0I I7 a i 7 .21 W a w ml Wi .o,W- N M f0 c! C tl1 76 I C T. aiS E. olji- E• ai W o IM •m m N i o to IE CIYI vI oI p W u) Id _ NCI NIfO' :C't N D CI W .6 a N o la I (n rn y N •E CO) l• 7 m o (p O U m co 10 - = INOj m I~I~Im!I E N OI ` H1Ia! toI !-,_,I 1 Ii~_ E m N~ E INiO' AjNZ EI NIA Y m E 22 N O !IJ H J CD E NIO - E N ! f0• O ~ I F- ~ I IOl o N~IE IV l,t~ p E N f0L N•10 ,m1 INIo1 i~!F-I m m E Nv co I O m N fn- E O Ni!C w~ -'EN Twq 011 N•II°Ilo~ >}2 t~01 (O7Q >I E o ~!c~ 5 I 7 EII-I NIo ~ ~Ei~I ! E N mIC N~ j $mC N 7 O IE o 14 c~ t'~_ o F = fn-EINC imw >I 1013 O Im o 1`I~1Cio H - l I' I- C o EIN ITCI 10 IIIqQ l0 7!O IN > _IEI~: I> 12 ' 1 t O C Q3 U Ala a ~ic~ U!F- a al~ c~ . UF- a a c r U ~Iala ' I .U H a a 0 I 1LL ~ ~I I13 1 1 l0, ! mo ! I z