Loading...
2008-18-Minutes for Meeting November 26,2007 Recorded 1/9/2008DESCHUTES COUNTY OFFICIAL RECORDS CJ 7408'18 NANCY BLANKENSHIP, COUNTY CLERK COMMISSIONERS' JOURNAL 01/09/2008 11;43;19 AM 0 I I IIIIIIIIIIIIII III ZII11 -3 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 01 ❑ -t 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, NOVEMBER 26, 2007 Present were Commissioners Michael M. Daly, Dennis R. Luke and Tammy Baney. Also present were Erik Kropp, Deputy County Administrator; David Inbody, Assistant to the County Administrator; Anna Johnson, Communications; and, for a portion of the meeting, Andrew Spreadborough, COIC,- Marty Wynne, Finance; Peter Russell, Community Development Department; Mike Dugan, District Attorney; Mark Nelson and Erica Haaggendorn from the Public Affairs Counsel; and one other citizen. Chair Daly opened the meeting at 1:30 p.m. 1. Discussion of February Legislative Session. - Mark Nelson, Public Affairs Counsel Mr. Nelson said the legislature plans to meet but will call it a supplemental session and not an emergency or special session. However, there is a lot that they can do in that period of time and a lot of bills may be considered. It is difficult to get the representatives and senators together for meetings. There are a hundred bills to consider and that will be narrowed down to about thirty very quickly; this number may be reduced even more. Most will probably be bipartisan and consensus items, although some issues relating to lending, paid family leave and budgets could be contentious. The message seems to be also that there won't be any revisiting of previous issues. Environmental issues including emission standards are active. The Healthy Kids initiative failure at the election is also being discussed and general funds might be used to fill some of this gap. Housing is also a hot topic, in regard to increased recording fees that are perceived to be a tax. Federal subsidies for housing are being lost and grants are being sought from consortiums and others; these involve HUD properties that have been in affordable housing status. Minutes of Board of Commissioners' Work Session Page 1 of 5 Pages Monday, November 26, 2007 Mike Dugan said that the Oregon District Attorneys Association discussed the property crimes measure (Measure 40), which will be very expensive. (He distributed a handout in this regard.) It will result in other programs being lost. A lengthy discussion then took place about the possible ramifications of this Measure and other, similar actions. Commissioner Luke asked about the Court of Appeals ruling that makes volunteers employees. This was in regard to ski patrol members receiving passes at the ski resorts, but could potentially impact other organizations that rely on volunteers. Mr. Kanner asked that in regard to a Senate Bill last year that would have reallocated road funds, is there any chance to change it? Mr. Nelson said that ODOT wants it reconsidered but it is unlikely to change at this time. Commissioner Luke stated that this represents about $7 million in Central Oregon. Mr. Kanner added that it also represents about $1.2 million to the County Road Department. The prognosis for federal timber funds is not good; at best, it could be paid out at 50% the next year and reduced every year thereafter. Mr. Kanner asked if the regional investment boards will receive any support. Mr. Nelson said that he has not heard this discussed. Commissioner Luke pointed out that leadership is from the metro area and regional investment boards may not receive the attention they need. Commissioner Baney asked if anything in the mental health arena would be addressed. Ms. Haggendorn said that there might be some small changes but nothing significant. Mr. Nelson stated that in the 2009 session, there could be changes in the makeup of the House and Senate. Eight Republicans and four Democrats probably won't run again. Some seats will be highly contested but the general makeup probably won't change much; the majority will likely still be Democrats. Mr. Nelson asked about the County's priorities. Mr. Kanner said that there will likely be a similar process as last year, with input from the departments, to decide on what the priorities are. This will be part of goal setting early next year. Minutes of Board of Commissioners' Work Session Monday, November 26, 2007 Page 2 of 5 Pages Mr. Kanner said that the companion bills to SB 400 will create a big problem in bargaining with the unions. There is also a big problem with south County groundwater issues that the State should support. Commissioner Baney pointed out that there are major issues with mental health needs and housing for these residents. Mr. Kanner said that grants are being sought to help with this type of housing and programs. However, the Mental Health Division at the State is not interpreting the bill to the benefit of the County. The Commissioners would also like to see the Justice Court within the City of Bend established; this has failed in the past. Mr. Nelson said they are working with judges and attorneys on the indigent defense issue. Commissioner Luke stated that there needs to be a way to obtain transportation funding. There is no new ODOT construction scheduled in the entire region next year, from state border to state border. Mr. Kanner stated that there is some action anticipated for an increase in the gas tax, but Mr. Nelson said this would be a hard sell because of the overall high cost of gasoline at this time. Commissioner Baney is concerned about CCF and Family Access funding. For the most part these funds will not be available in the future. She will provide information on this issue to Mr. Nelson. Commissioner Luke said that the cigarette tax measure failed due to the fact that the funding was not allocated towards children's health needs. Mr. Nelson stated that the legislature has been trying to institute universal health care but were trying to do this in a roundabout way. If they were more direct and explained exactly what would be covered, it might be successful. At this point even the children who are now eligible are not receiving the services they need. Mr. Nelson said he would like input from the County around the end of January regarding priorities. It needs to be narrowed down to a reasonable number of issues so that his efforts can be more effective. Minutes of Board of Commissioners' Work Session Monday, November 26, 2007 Page 3 of 5 Pages 2. Overview of COIC/COCIB Economic and Investment Strategy. Andrew Spreadborough gave an overview of the COIC strategy for the upcoming year. He stated that at this point there appears to be little or no funding to come from the State for this program. However, the public hearing scheduled for the Wednesday Board business meeting is a required step for the program to proceed. (A copy of the information discussed is attached.) 3. Finance/Tax Update. Marty Wynne gave an overview of the current finance/tax situation. Commissioner Luke asked for specifics regarding the Solid Waste construction fund. Mr. Wynne said that rates are plummeting, which means that there is concern about the effect of the housing slump on various industries, resulting in a drop in the stock market and a lower return on treasury notes. He then explained the status of the local improvement district construction fund. (A copy of the information is attached.) Mr. Kanner pointed out that the County has a moratorium on accepting roads into the system; Mr. Wynne asked how any ending debt service funds should be handled if funds remains after the debt service for construction is paid since the fund will eventually become inactive. There is working capital in the fund to cover the projects. Mr. Wynne then gave a comparison of the 2006-07 and 2007-08 property taxes collected and distributed. (A copy of his report is attached.) 4. Discussion of Hidden Canyon Resort MOU. Peter Russell gave an overview of the item, which is in regard to traffic impacts on Deschutes County from the Hidden Canyon Resort located in Crook County. An attorney representing Hidden Canyon attended the meeting to answer any questions the Board might have. Laurie Craghead pointed out that a Memorandum of Understanding is non-binding but that it will be written to obtain a more firm commitment Minutes of Board of Commissioners' Work Session Monday, November 26, 2007 Page 4 of 5 Pages 5. Consideration of Economic Development Grant Requests. There were no requests to consider at this time. 6. Update of Commissioners' Meetings and Schedules. Dave Kanner said he would like to schedule Thursday, January 31 for the Board's goal setting meeting. 7. Other Items. In regard to the Commission on Children & Families' Board membership openings, Mr. Kanner stated that the Board of the CCF would like all four applicants appointed. Being no further discussion, the meeting adjourned at 3:40 p.m. DATED this 26th Day of November 2007 for the Deschutes County Board of Commissioners. ATTEST: Recording Secretary Michael M. Daly, Ch r Dennis R. Luke, Vice Chair Tammy Baney, Commis oner Minutes of Board of Commissioners' Work Session Page 5 of 5 Pages Monday, November 26, 2007 Vk,O l 02 lU 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, NOVEMBER 26, 2007 Discussion of February Legislative Session - Mark Nelson, Public Affairs Counsel 2. Overview of COIC/COCIB Economic and Investment Strategy -Andrew Spreadborough, COIC 3. Finance/Tax Update - Marty Wynne 4. Discussion of Hidden Canyon Resort MOU - Peter Russell 5. Consideration of Economic Development Grant Requests 6. Update of Commissioners' Meetings and Schedules 7. 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 otherivise indicated. If you have questions regarding a meeting, please call 388-6572. Deschutes County meeting locations are wheelchair accessible. Deschutes County provides reasonable accommodations for persons with disabilities. For deaf, hearing impaired or speech disabled, dial 7-1-1 to access the state transfer relay service for TTY. Please call (541) 388-6571 regarding alternative formats or for further information. z W A z U^ W A~ O~ ~a ~W ~o a W z 0 a 0 U r 4 O O O O O O O A A A A A A A 1 1 ~ o U a 0 C) P.., a ~ ~ a 0 ~ P., a ~ ~ ifi ~ ~r ( ~ FG L i] ~ Fri •M-+ ~y ~ p4 ( ] ~ F~ N ~ 0 ~ ~ U O U O U O , U 0 0 ~ 4 ~ o ~ a 0 o ~ ~x A ~ x 'O . a ~ b b A A A L. \p \p " b O 'O U o 0 0p oM 0p o O 0 M cn fx fYi N U -d b A A rn A cd o y V O en O cn O a °M O a oM ° G 0 ~ x orn r N O O o 0 oU a OVA 19 19 N 0 19 b 'b b r O ° ° ° C~ O orb cqs 00 z z ~ o * v b o * y ; o * b o * b o * ~ b o * ~ b o * ~ b o ~ b O ~ 0~ O ~ m O cl O 0 cd O 0 cl O d Cd P' O P. en m M E en cd cd en cl m M O~ Q\ w w w w i. V N > O U bA b0 bA bA bA an to N N to N y N N N " O En L+ b $ -d ~v v " U O to to 9) a, a 3 0 N to ~ N N ~ N O t U O ,b R ~ V U U U U U O z 4-4 a) W ~ " ~ ~ C C C G ~ a ~ i C rn En O O "C1 b O O O O Q x ~ c cd x ~ pp,, w g w ~ ~ _ ~ H r" ~ Q OO z O z F~ .--i ~ ~ ~ M M Q M t.i en w 00 wr 00 y C~ U ~ 0 ~ .Q = ~ ~ C y V1 0. 1 H ~ ~ w ~ ~ F A C6 0 v N 0 •4+ cd U •4+ b C~ op o ~ U O O ~ .b cd w 4) ) - O L. U wO a 0 0 N N C) O O N O N O~ 0 b V U COMPARISON - MEASURE 40 vs. ODAA vs. CURRENT GUIDELINES (PROPERTY CRIMES) Measure 40 other basic provisions: • Local corrections is reimbursed by the state for any costs associated with pre-conviction incarceration. • Offender serve sentences in state prison or work camps • Effectively eliminates early release for AIP for each of the affected crimes. ODAA other basic provisions: Repeat Property Offenders: • Robbery 3 is added as both a predicate and RPO crime. • Felony fraudulent use of CC and criminal possession of a forged instrument 1 are added to the list of crimes for which a person can receive an RPO sentence (already predicates). • Offender is not eligible for a downward departure from the presumptive sentence if at the time the defendant committed the crime the defendant was under supervision for a felony crime. • All RPO offenders are eligible for a sentence reduction after completing AIP unless they have already been granted a reduction in sentence for completion of an AIP. • Require judicial findings prior to a downward departure from the presumptive RPO sentence: o The defendant has not previously received a downward departure from a RPO sentence; o Considering the nature of the offense and the harm to the victim, the defendant's reduction in sentence through a downward departure would not unduly reduce the appropriate punishment; o The downward departure would not risk public safety and increase the likelihood that the defendant will be rehabilitated; o The defendant was not on felony supervision at the time he/she committed the crime for which the downward departure is sought; o The harm or loss caused by the crime is less than is usual for that type of crime; and o The crime was not part of an organized criminal activity. • Attempts qualify as predicates. • Mail theft becomes a felony, a RPO predicate and a RPO crime. • Minimum and maximum sentence must be announced in open court. Alternative Incarceration Program • Reverse the presumption on AIP. • Offenders may only receive one reduction in sentence for participating in AIP. • To be eligible the court must find: o The defendant has not previously participated in AIP; o That considering the nature of the offense and the harm to the victim, the defendant's reduction in sentence through an AIP would not unduly reduce the appropriate punishment and would not risk public safety and would enhance the likelihood that the defendant will be rehabilitated; o The defendant was not on supervision at the time he/she committed the crime for which AIP is sought; o The harm or loss caused by the crime is less than is usual for that type of crime; o The crime was not part of an organized criminal activity. • No eligibility for crimes involving serious physical injury or death or crimes that require sex offender registration. • The maximum sentence reduction for AIP participation is 20% + 20% for earned time (This would go in ORS 421.504). • All AIP inmates must serve at least 12 months, and the 12 months includes jail time if credit for time served was granted and includes the transitional leave time. • Transitional leave is reduced from 90 to 30 days. • Offenders who fail in AIP may not reenter while serving the sentence under which they previously failed the AIP. • Parties may to stipulate to AIP eligibility or ineligibility at any time with the consent of both the state and defendant. Created on 9/20/2007 2:21:00 PM _ C~ C) O O LO .r CV LO O O O O CD 04 N co co O U C M d d 00 C) O co 0) N C:> - d) c (S3 O) CO LO j a) M N M U tf) e L c a) c d> O ti N co co N O O O 0 C: Q a "g, ~ 0) (0 co '4;T 04 Q = Co -0 a) -C ca. fn U > Ef3 4" >1 cn (D 0 c: C C 0 :L- O m O CD Q O L o c co c0 E c- M Q N ) L m a) C m f- O O O O O O O O O CO U) 0 0 CU a) o c U c U c -0 Q 00 ca (n F C O <n U rn c o a) V cn C O 7 rn CO E o E 3 cL a) =3 a) = c C a) 0) C= ~c am E° 5° m n-° m O a) U '5 E v> c =3 a) c c E N O c ca L- E y a) ° a) ° L o c > a) ° a) L E yO p~ U o E 4- E (D Ecma0 0 Q m o~~ ~ ~m a co d C a) ca a) o cn v o a) ° o o I m~ co E ~r 7 c EO 'C a p p OL J _ o c a>i o n O ° ° ° " a) a c a) m ° cn 75 o Ems' c m i O L - O c 00 ~U c N Ec ~0 m co ° o»v 00) M -0 C (n O c a) c3 c -c~ 5a O cn i = a) O a) a) , - ^ L to O M V a) C > O y Q O p c a c o • •N a) .r a) % - 4- c > a) ° ` a) o CD 0) =3 o o c ao w cu CL - C L O uJ c) a W a E a~i c 7 cn Q• O+• L- cnZ ~N Na)o=mc a)ca a)~rn ' o AU) v -2 E 3 aa))•0 °c~ Emr- m you (1) ~cE m~ ~o -0 CD d O a) C v D~° cn J n.•v 0 0)a) (1) U~ o cn a LL~ (1) Cz Q m cn ca C Y Q c 0 O c a~Ni c c C: cu a) C O C O O O p U N V a) U v) (n c h U ° m U c O i 4- 0 0 0 ° - O ` U c m U U) C N - to c I > E-0 O O cm) c~c c~c m : m cn a) m o g - J~ m~ c co O O p O O O (n L J L Y rZ a) o 0 C) tr_ Q = L U c c J U d U Q Q a) O 06 m a) a) 0 U) Y) a) U o o Q j 0 0 E 0 a) cn c E 4- Z O C to Q) 0> c c° rn ~ rn c a) n W U co N~-~ N ° c my coa a coax E o-°_ ai a O o cn v aoi Eii E am) mm Um Um oW 4 co U~ > U U U N rn'(ncEcac o ° U c co W c O p 0 M d ti co c a) > o O Q, Z p -a r. X R U o 0 0 It Cc C. a) m a) a> c C~ C) C) C) 04 0 °o oo 0) ti U Q`~ N~ 0Oj 00 00 0) O cli CO a) p) ° a) wp. C~ m O r O O c) M l) a) C O Q 0 4= 0 U) CD E ID 2 -21 O C y p- U N a~i m ~ tm m ui ;n V 'C C O C _ j (D 3 E (D a z N c c ca N a) o E ° C~ E- m 7 a) O O o d x a U) m C W cn O 6 O c c w U m e U N m o ami o r\ 4- L o " c - ~ m a) cn o o a) o ~ ° U) ~ _ N p OOH V.N m = a oU L oc U ° O LO :3 c cs~ - V o °3 g ~O o ~cn co 30 J O O- ca o E to c (n c U) 1° Z O E a) p J Q p o ai a) X V a L0 E a) " m a) U N m U m o c j N Cl) a) a) 0) co m a) E m o c c N O a u) o O o aNi-° ~.N 4 ami m aci m a) m m " a) m U ~ o Z w v a) cn cc 'p m a a) m W O o a) O > AC o U~ ~ > o ~ n J U LL .0.0 cv o CD 0 co 0 Lf) Lf) GF~ aC ti. h O N O O N J w N O O O O N ti O) In O ti co U C O CA f- O LO LO 00 ~ L 00 N CA 00 N O d• t- CO I O 0 a) C L ( (o ~ ~ CO O C7 ti CA C O « (L) 00 N O 0) - C- 1-- co d > E CA O N CD CA ti (O (A LO CO L L d 0) C) 69 K? c- 69 r• . 69 ER E9 Ff3 69 69 O c > cu 'O Q) .a (D C W 't CD co O LO N O O O co O O Cl) L() N N - C7 M U~ (n U ~ ~ ! U (D v0 N , (n r_ c 7 C cn a) (n (o 3 Q) C ~ 4) L O C C U (CS U ~ N m p O O U o . N ° - (n c ' 0 0 O ((nnEo > N o ~ c v ( ~ 0 of ~ a) (D in (v cu CL C O 0 2 2 -p 0 (6 V a) a) U 7 V O O O O y (n " O - a a) CO .J c Q 7 Q C (n a) E C E C ca Q .U t0 a) c: (n c 0 r% p c c O p o c' c II X c O (Q 0=3 C ui 'U p V a) O X U a) U a) U 4) p) X O c U V p " in~Z a 7N EQ Eo ~c Eo - Eo - E.9 O 0)42 c c Q O • a • = O : . Q fl • = : o- C - 0 : C 7 o~(n ~V ~c ~ ~N ~N ~ U ern >c a x a) W in c - (o (n U co w W (n 6 c =3 W c6 c (D LL a o W c v a) W c to LL Q W .;o M G LL 'Q O ca E x W a A C C C c c c C c C C 7 O 7 O 7 O .J p C O O 7 O 7 O 7 O c +r a) C =3 7 -0 O O O "OV 'OU _0 - o OV OU OU "OU - O = O c OV a)U .c C (n c N C N > C N C h c N c n E (n > C U a) a) a) I m C Y (D m a) m a) m 4) m C Y C Y -0 7 0 0 L ` O d o ~ ~ - t C: O d O C O a O a)~ U ` cn 0)) cn of of (n (n cn 0) U U U ) O D O O 0 o CL 0) Q) ( C T p c 0 c (1) p c a) in c (1) 0 c (1) p c (1) p c a) p C a) p c a) p c a) F- U p = a) N (A N (n m (n to to (n N mE co E co E NE cn E (nE wE u) E Y) E coE a) E a) a o a) o a) a a) a o a a) a a) a o a a) ) E(a c0 co co c0 c0 co co co cp c0 O cu O LL <n a) rn a) N a) c a) N a) to a) N a) h a) -w a) to a) a` U > > > > > > > > m m m m m m m m m co p O O O O O O O O O O O O O O O O O O O O O O O O O c~ O O O O 00 O O O O O O O N 3 Q O CA O N to M co CV Cn r- N N O N O O ('7 O LO O N p E9 69 69 61> E9 69 FA EA 64 69 69 C C O (n o (n ` o _ to rn c (a J cn c c ca (D c ` c tC a) Q w rn c in a W N C c ` y c m m U O c c o o co o CO =3 c cn 0 oo c aoi a) ayi ac) o o CO o c a) N H e m O > U C 4 Z) n U cu C co C7 0 X a D N c N rn 'c U 3 C c Co U L c o p cn U W O Q a) ° a) p Q 0) U O L p Ca a) O E N U c ~ Ica cc°) - co o ca U~ U) c U U N a ~'U)) _ CC J - U J a) X J :3 W Q- U H Z) d Q U F- Q--i W Q CO W N C d E C m O In O M Cl co 0 ~ o c o It C) M 0 o C) o co It C) C> C) 0 Z o LI) 6 6 Lr) ~ N N Vy 6 9 69 6 9 U9, 6f 69 69 C t~ N Nt O O O O O O Z Lf) vi cn 3 o c a) E c c c o o E a) co c O_ =3 fn u) o L- o~ C E o 0 rn N 0 30) O cv c - N O Y U is a) CL O rn U a) p 'o O O pY 3" o O C c E E m c a)a r rn c ca a) N a) U) c c a) O O mv a) N c c0 m p o_ " a 3 v O U U N c 0 a) (D U r O UC i c a) N c> v> " > L) =3 N 0) (n (n 02 cu O c ° o + p c 0 a O ° O x _0 O CD c700 c a) c O a) ,Y ov - "p p ' - 6 o c ca 21+- co G) m O E En Q) E i5 Cl N O 3 O O N 0 > p C m (U4 U) cu -O C I- 0 CL C CU CL C M a) U c: (D O c c Q 70 p C 7 E NU LL Q. px w a) Qx w a) OO4) U M v ()a)> W -O a) NN c co a) cA E a) J c - rn Q N p0 p p cn a) Y N O a) Y E 7 N O V N O L C U) O 3 C O -a _ C d s > O a) o c` 0 o > O a) o 0 ` o a) p p p p p cv ca c U o c U m cn cam a) U 0 J Q d d 006 6 p o U m a) a) Y y w c o pc N pc O pc O w U c U ~rn C c>. c>, ~ i ` I= n E vi E n E E 'v c6 E - E o a) a c0 a) a Co a) CL CO (n EN U) ao Et° Em c 0) > 7 > ~ cu Ou" m co U Ou pLL E 7 > ` U C U U Q co co co O O O O 0 M lL O O O C O O M N N Lo ~ - CT M d M L6 ~ In 69 Et> 69 Ei> 69 63 69 69 ff3 69 C co O U c x n c 0 C _ p 7 C o O c X (C3 7 O W ► 5 _C N J co x 2) v a) cB J C Q r_ C W 0 > U) 0 x m o c U) (D E c Q w L rn a) j mZ3 0 (6 4) a) C U s C C C p a p - CD y > 0 p p ~ - pU ) ) = rno ccp oac) p a)- CU o a°'i0 w a = 'v) ii U U~ J Y m o U 02 t O 0 Q C O cri L a cu d L p L 00 O) M N ti ) I- c L O a)~ N M C7 M O N 6F> Ef> tf> a Co O O N 0 CL w -0 r- C: N 0 M 00 , CD o a ) ~ co O Co C0 CD O O Cl N i a) Q- 0 -,cu, E . C14 It* NT a 0 C,3 c U - coo_ co C) N L M a E C4 m N a 0 6R 6f} 61} 0 Lo O O O N C Y O N L 0 L O U U N 0 IQ) 0 IM Z C L d O .Q O C O i O i rr C v O O O Z w O ca w O w w V d C i O 4 > C C O O ,C O~ t a) a) E O U 0 aL) E co t c O E v O U CD C ca U) U w I Local Improvement Districts Construction Fund (430) July 1, 2007 Cash Balance $ 681,291 Estimated Revenue thru 6/30/08 Assessments and Interest Earnings 22,543 Manzanita Assessments 75,973 $ 98,516 July 1, 2007 Cash Balance plus Estimated Revenue Estimated Expenditures thru 6/30/08 LID Construction Costs thru 11/19/07 (Pumice Butte & Manzanita) LID Construction Costs thru 6/30/08 (Manzanita & Admin Costs) June 30, 2008 Estimated Cash Balance $ 779,807 (396,604) (247,411) $ (644,015) $ 135,792 * Does not include estimated construction costs of $1,046,315 for Beaver Special Road District LID Note: The following are LID debt service funds: (1) 2000 Series Limited Tax Improvement (521) (2) Local Improvement District 2003 (522) (3) Local Improvement District 2005 (523) (4) Local Improvement District 2007 (524) Comparison of 2006-07 and 2007-08 Current Year Property Taxes Tax Year Tax Year 2006-07 2007-08 Total Tax Roll $ 214,410,461.55 Total Tax Roll $ 233,330,396.12 Actual % Estimated % Collected at 6/30/07: 94.5% Collected at 6/30/08: 94.5% Dollars Distributed % of total Actual/Estimated Fiscal Year Collections Dollars Distributed Year to Date $ % of total Actual/Estimated Fiscal Year Collections Dollars Distributed Year to Date $ % of total Actual/Estimated Fiscal Year Collections Dollars Distributed Year to Date $ % of total Actual/Estimated Fiscal Year Collections Tax Year 2006-07 Turnover $ Turnover Date Turnover % 10/31/2006 $ 13,178,619.64 6.1% 11/8/2006 24,990,601.78 38,169,221.42 17.8% 11/15/2006 64,783,277.76 102,952,499.18 48.0% 11/22/2006 67,951,056.52 170,903,555.70 79.7% Tax Year 2007-08 Turnover $ Turnover Date Turnover % 10/31/2007 $ 26,767,820.44 11.5% 11/8/2007 19,221,683.49 45,989,503.93 19.7% 11/16/2007 97,074,383.11 143,063,887.04 61.3% 11/26/2007 39,836,339.12 182,900,226.16 78.4% Deschutes County 2007-08 Tax Collections by Source Official Date 10/12/2007 Prepays Payments 1,068,080.02 Banks Lockbox Data Exchange Tax Office Total 10/15/2007 7,613.39 50, 711.31 1,118, 791.33 10/16/2007 2,857.07 114,600.37 122,213.76 10/17/2007 6,079.16 153,063.47 155,920.54 10/18/2007 12,902.94 39 832 61 112,772.66 118,851.82 10/19/2007 , . 470,966.69 523,702.24 10/22/2007 27 289 28 300,849.36 336,931.58 637,780.94 10/23/2007 , . 8 609 53 468,978.30 594,044.18 1,090,311.76 1 0/24/2007 , . 8 723 39 4,155, 800.29 524,586.79 4,688,996.61 10/25/2007 , . 25,655.56 216,129.90 721,527.58 2 668 852 55 432,555.15 1,162,806.12 10/26/2007 1 0/29/2007 17,206.51 426,790.59 , , . 1,869,563.08 672,502.13 652,489.40 3,583,140.14 2 966 049 58 10/30/2007 21,492.62 18 640 01 167,378.89 1,418,680.04 762,076.59 , , . 2,369,628.14 10/31/2007 , . 15,044.07 2,762,557.35 2 010 937 97 681,528.72 3,462,726.08 11/1/2007 14,727.16 302,308.18 , , . 1 489 341 96 661,917.16 2,687,899.20 11/2/2007 13,779.59 223,935.90 , , . 2 195 789 46 734,040.94 2,540,418.24 11/5/2007 35,808.66 , , . 4 546 858 68 703,833.44 3,137,338.39 11/6/2007 11/7/2007 45,497.79 456,355.51 , , . 1,951,065.73 795,183.82 1,599,312.89 5,377,851.16 4 052 231 92 11/8/2007 9,917.80 28,374.34 361,016.08 421,038.88 5,344,551.74 2 315 715 30 1,666,828.35 , , . 7,382,313.97 11/9/2007 26,611.81 , , . 4 278 347 46 1,359,979.88 4,125,108.40 11/13/2007 192,360.98 1,033,687.58 , , . 2 943 382 40 1,450,034.35 5,754,993.62 1 1/14!2007 11/15/2007 62,514.93 , , . 10,836,864.90 40,032,779.86 2,854,464.24 4,290,438.13 7,023,895.20 55 222 597 82 11/16/2007 122,995.97 167 371 59 2,067,740.67 14,535,759.02 6,655,147.00 , , . 23,381,642.66 11/19/2007 , . 14,185.48 952,122.54 3,808,151.41 7 874 284 42 3,170,981.07 7 ,146,504.07 11/20/2007 11/21/2007 11,162.00 2,422,940.50 , , . 11,374,757.83 330,719.16 2,768,512.55 8,840,592.44 16 908 092 04 Tot als to date 38.12 11068,080.02 917,459.75 503,707.27 7,487,411.82 4,328,814.32 81 773 245 41 4 8 2,485,268.26 , , . 7,317,827.97 of Total % 0 5% 4 1% , , . ° , 99,258.04 36,754,771.12 182,900,226.16 . . 44.7 /0 ° 30.0 /0 20.1% 100.0% Monthly Meeting with Board of Commissioners Finance Director/Treasurer AGENDA November 26, 2007 (1) Monthly Investment Report (2) October 2007 Financial Statements (3) LID Funding and Financial Projections (4) Property Tax Collections - FY 2007/08 In 1n M N Lc) ~ co 00 ' O d 00 O r COi N O ' ~ OD O " ti r V o r ~ = O N r C ~ U9 tR d ~ E N V N N O M 1L 0 ' N M in O r-: 1: C4 v Lef 1 V O E9 69 ~ cr O C O U M (0 M C C j Z 3 LL U9 r H4 ` V a C c E d o o E~ _ U L m 0 C 6 > N 41 y N C U- N . ~ a > d 'A N o ~ J C N C 76 C ' C H m C7 0 0 t 0 O Y 1 0 co OOf O~O~ CD 'i O O O r O M U) O O CO ' I ' In 0 O M N M O O CO qT CA 01 O il- ~ 00 M I- LO co I-T co LO r r U9 1fR w N ~ C ry+ to CL 0 CD c w M D U a 4) a 0 C U w U ;E C6 Q 1- di " m 2 Q O C EU~ coo (D E (D -ld m m o UH ~LL co J H ml m C I co N C 0) U' 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 0 0 0 0 0 0 0 0 0 0 0 Cl lf) O LO 0 0 0 O O I- ti O to N O LO N CT L6 CT ~ co O) N 7 O E Q R .0 0 O O Lo to In C ~ C O C °6 U m cvm ym U m C Y C co m co N CD ~C U co > ii Y c o E 0) C Cu ,c Cc C CO Cc 7 E~ Y a E E CD N E N O O r r P N N N ~ N E ~ Co Q X U 10 •C 3 C 0 U Q ti I Co U m 4) C 0) U _(D T. (0 ) U C d C N N p ) Q H w C d E fn W N C ~ U o O U m O (D d E m m w O U 0 m n a~ J N `o N 'a N d n a d d d d d a s d ~ dI d id a a d a d a d I dia d a ' d d d d I d a d a d N' d a s'a d a ~ d Il d o a d a d a ' l ' ! I I I I I d ~a m m m co m m m m Co m m m m a m m I a m m m s i m `g g m m m '-I m a m m Co m a m i sm ml m m m m m m m m m co m a ' m m al= m m m m m m d d ala m m d a m ! o Ino a D ° v o o e o 1 Y Y ; Y Y I Y Y Y m co m1 c 5 Y I I Y Y Y Y = Y Y Y m m m rn o D o c m' U 2 Z Z Z Z c jU ZIZ U c c U Z Z c Z c iZ c U,Z o Z U U o Z 0 Z o Z IZ Z Z Z U Ui o c Z o c Z c o Z U U U ao ao v < o ~ I C T - r... } M M O O O O O O O O O V O O m i CO ! O W O H O n 0 0 M M M M t- 0 CO N I O O N N i a a O O M ( m n m n I N O N 0 0) o 00 O n 6 O O O p I O O 0 O 1 O 0 O O 00 O .0 O fD r O O N n 00 N I O t0 w C d W 0 O O 0 O O O O O O OI m cp O CO n 01 0 C M M W COI r p N O O O O m N T O q c N n 0 0 1 0 n 0 ! W O N r O 1 n! ! 'O m r O N O O 1 I O O O M M O O O O I O O O O O n COI Co N Cb 0 0 N N O O P_, I 0 O CO O N N: O N m O M o0 M O Nn N N0 6 0 0 co 0-- 0 O 1 1 V M O) W COI (O O at O q I W I Im In O In O at N 7 d N u7 O , O N ;0 O O O O O O V CO n O n m 1 W 00 1 ! 1 O O m 1 O O N M C M O n In O M m O L n (O!O n m r M O O N mI0 Lo Ce) m IO OI CO O N CO M (O' V im LO I Co O CO n O O) lO) O O 'MI iCO l" N d• M m O1 07 ~ C N i N I O O N N 0 c N N N o N f o1O O N N N M N O N' O N N N N O O N N N N N N N I~ ! N N N N N N O N O (O p ; c 10' ' CD- n In n c0 _e0 '0 M 16 I 'D C) :Lo t A M! I 69 1 M 1 1 O O ° m O M M O O O 0 0 CO 0 O O m n O O CO O O O O O O - O O C? O N 0 N l 0 6 O l 0 O 0 O 0 0 0 O o 0 O 0 O 0 O O O o O c:) Oj C> o 0 O i O ! O ccpp C`7 M O m O IA j ~ O O O W M W W N N O i O M O N ' N O N c6 i CD m (O' CO O O O CO V O N O O N O O O N m 0 1 O 0 0 0 01 0 0 00 O V 0 O 0 O 0 0 O O 0 V O I co O O o O ! O o _O O 0) N CO O n d ! N 0 U O O 10 1 O V m O 0) . i O m 1 m 6 M , V r- a n V m m O I CO] 0) C) n 06 O co CA O m m N f~ m I CO m n M° . n O n l m i CD m 0 O 0 O co 0 O O o O V O m O V m N 6 n m N M ro M n co m l m O 0) o O 0 O o 1 V m 0 o 0 f.. m 0 W 0 m 00 m 0 0 1o 0 6. 0 06n m',- m' M o0 N m co 1 0 o 1 O O N 0 0 010 O I o O O 0 O j 1 c0 O M n W ° n N I O ; CO : Co M V N CO d I I - N I ~ - N ) ! + M N N 1 N c N N n O O C) m N r us 1 1 l E m d O' N d N d Cdj ! a 4 d : I t ~ Iy ! d m ? ~ dl U U E ._r.. , . O d d Cp ' o O 6 ! N ri oo V O O LO 7 i n 1 0 N V : 7 V i o ~I~ dl~ o O N O O N n N I N - i i f io ! o Co 7 ~ ~ oIo 0 M 0 m co! m O m! O i 0 N 7 0 O O i O O O W i O O i o V 1 - ~ o CO C) M O 1 0 i lo 0 n O v 0 6 M of 00 0 0 M 0 0 CO M o0 ; N i 0 N M 00 0 M !o o ' N O 1 0 n V I N o O V O ol O N O I o o O O O n V W no O l n M I e n M ~ i go O 6 N i o t O O M o o O N 6 1 N u) - o ° - ED 2 d E UI wij v V) U m d l. 0) ¢ m I H a Q I~ C0 Iy > C I 'I, } r LO r u u a LO 6 1 6 v u I LO r 1 r r 6 6, u 1 Uc u v ri ri ri ui v v v ri c ui ! v a ° 1 O ° d d y n - ! II _ o • O U I EIS I-I d LL M10 mIJ 10 :H - C' a; .d, m Q'I U o 0 III O N IO 1 ' o° o~° t o f 0 0 6 O M; N N OI CO O MIV e 0 (O c0 C'> o 0 co 00 ! o O O N !O e: O (OI c0 NI o O O 'M o O O V V a o O o O O 6 0 V V I o • O n W V 0 O' m V o 0 O Co 61 0 0 O M 0 0 O F V M o 0 II O O O OI V o00 6, OI n V; OIV O M0 n O C E j : o ~ d U a - H o 0 cII 7 d I i I i I I p O w m a I N ~ O ' I i I I I i I I I I 1 I d E a O i I c U I I I I ' I . I ' o H I II I c El d i o • O n N oI m Z M W I IT b O i b' c0 - V I O A c') op AC MI O N V V O M MI I V O TD O O V l m oz? O V V I n O V ! V CO n i O M' CO CO 0 O l) M n O ~ O I O n V!M V I A O O O ! 61 I ~ VO IM I- 1 I W O I ~ M V i M N !n no M n M O a C E d d 7 C y 4 I F: T , i r- aI ~II I n o n n o a n n O O i 00 00 W 0 0 0 tb 0 00 C0' W 0 0 0 W i 0 M 0 N W O o O 0 W 0 Co w 0 c. W 1 0 W 0 W W W 0 0 0 oO 0 co 0 00 m 0 0 m 0 m i m m O ) m d ' j O O! j I'I • d V m Q m' O I Un 4 N O M M O N 1 n o0 N O N O O O NI N' N O 11 N m M NIN c- NIN M o; O 0 6 N C+) 0 . C3341 C'7 0 NIN O O 0 N I~ 0 o0 N n 0 , 44 O O_ W W 0 0 m O O 0 O 00 0 1 N 0 u) M' \ m' O 0 0 M O 1z \ N Z N N O V N N O I 0 0 f_ N (O O o o; - 0 0 n O 1> I Q 1 C _ O Q U O 1 ~ • d ~ I I I H Ji m 1 i N CO d I n O CD n O o n o n 0 0 n n n ; O O O. (O O - n n O O O CD O CO O O I (OI O O n O CO O O O O O n O O 0 n n n 01 0 0 n 0 n 0 n n 0 0 n 0 n n n 0 0 0 n 0 L ` m N O W V N N V V O O n m N W N O W- In N n NI m N O N N M N M N 1~ c0 O' m O O nO N O O V N! M (O N O N n 00 N N O 1 O G LO O O m CD O O O O O j m OO m o: _ N r ~ O O ` O r ` O 0 O OO n O o 6O' 0Ol I m o i O mO C O _ O n m m ' m LL 11 N LL l ¢ a I ~ I ~ U _ U D_ 2~ fA fA p 3 U F l L C ¢ ¢Io a LLI ¢ ¢ EL CL ol ¢ ¢ o ¢ ¢ ¢I ¢ t o o ¢o¢ ¢ ¢ r ¢o ¢ ¢ t -0dRl1 LL LL: I- U Ui LL LL!LL LLI , LLIU UI F- LL : LL;H LL LL l LULL F LL f-~IILL LLI LL LL F LL LL J_ LL. - - ! B due M a I Z IY V), U m¢ di m M Z LL a cn' ~ Z U) Z m z fn af (A 0) m Ot m' > j 0: U)I m x CO x Z CO U) of co LL 0 Z¢ Z U) co! ) Z U) Q co co U w; m Z c! Z Z cn mI 6 Z'! cn! 1 ~ ~ I d j a E , V ' 'Y I Q r M U ! cD M IN N On' n 'c~i ! 0I I~ O 0 I- i ~ O Cp s n F i0 > I i m ~ V n Y W Z CO' v -1 i m M LL ' LLI i M; m Mil n1 m LL CO m W Y M LL I V CO. V UI ~1Y ! N X I I I O 2 • to 7 , 'IY X, :I M i U CO O MI M' m co m O O p O I ~ CO I 'IV W X LL X O M cy) M M M M j M ~ I i 0 MI M ~ J U O N 6 CD MIm N M I M M ! i 2 X M M M } , M' MI CY) .-I i N I M U X A M VI )X CA COj N M- M 6. N I X CA, ¢ N M I M ¢ to M M I, Y; i XI M J X I M co 6 . cp M M a - oo C, IX W, ' MIM cm~ M I M I M N ) M ! ' I I 0 I c o l o a; UI p UI c°~ N I y c~ I ' d p o ~ - - V U cl c! m v m I ' 1 I Q U y c j O U ' I N ) " . ; I . I U -I m U N m U d > I m. n LL I i ~ t U 7 Cn U 7 d mO y C p m I I I N d L l m d N d Cp d - a ! V c y d 10 m 0 m U LL y c I C m m I O I m d, El . (I t' W y T M ~ T o y O1 U: : m l a ~ ! D a+ N > U O Ui U «U , U Q m Im I U= , I ~ LL ml t UI I'G N U ¢ o I m al E m e co 7 E m c - mZl p dl > m e mIi m d Cl U l ¢ o y m- N c2 E cI _ 1 N d WIC U d yI c! m = d1 E'' I i d y c m y c m 3 o E d oa n 1 U ml mld L S o N E~~ ou) E m t y c y ml l pl c ~L ! m m U U 1 _ d: xw n F d U~LL ¢ E ¢ ¢ LL ¢ E ( - Im :J ~ 7 N m m J ~ J ~ di C;~ m m J m v J J m J ~ ~ J d E! y~ J J ¢I m J m!y J ¢I m mi¢ am m, J ' Y N d ' C !2 LL Z O LL 0 ! O= R 1 21Z 2 LL LL LL Z LL Z dIL'0 LL O' 1 Z) fnl D S L 7 2 0 U) L 2 SI Z S a J O 0 C S m 2 Z S I c SI m ' z U LLIS Z S C m I a L L LL LL LL LL LL co LL LL LL LL co LL LL I LL LL LL IM Memorandum Date: November 19, 2007 To: Board of County Commissioners Dave Kanner, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find October 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 GENERAL FUND Statement of Financial Operating Data Four Months Ended October 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA Board of County Comm. District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues Year to Date Year to Date Budget Actual Variance FY % Coll. $ 5,920,000 $ 6,713,253 $ 793,253 100% 113% 6,184,000 2,428,192 (3,755,808) 33% 13% 18,552,000 18,552,000 - 0% 842,191 1,195,161 352,970 33% 47% a) 2,526,574 2,625,669 99,095 4% 359,057 519,163 160,106 33% 48% b)c) 1,077,170 1,002,170 (75,000) -7% 760,033 612,753 (147,280) 33% 27% d) 2,280,100 1,949,100 (331,000) -15% 5,821 9,311 3,490 33% 53% b) 17,464 17,464 - 0% 33 222 189 33% 222% 100 250 150 150% 91,133 104,306 13,173 33% 38% e) 273,400 331,744 58,344 21% 83,282 127,361 44,079 33% 51% b) 249,845 249,845 - 0% 24,000 17,550 (6,450) 33% 24% f) 72,000 72,000 - 0% 28,333 30,332 1,999 33% 36% 85,000 85,000 - 0% 667 668 1 33% 33% 2,000 2,000 - 0% 8,378,550 5,045,019 (3,333,531) 33% 20% 25,135,653 24,887,242 (248,411) -1% Revised Year End $ oa Bud et Projection Variance Variance $ 5,920,000 $ 6,713,253 $ 793,253 13% TOTAL RESOURCES 14,298,550 11,758,272 (2,540,278) 33% 38% 31,055,653 31,600,495 544,842 2% REQUIREMENTS: Exp. Expenditures Assessor 1,256,704 1,093,548 163,156 33% 29% g) 3,770,112 3,595,112 175,000 5% County Clerk 538,352 454,497 83,855 33% 28% h) 1,615,056 1,564,856 50,200 3% BOPTA 22,005 22,460 (455) 33% 34% 66,016 66,016 - 0% BOCC 258,993 227,632 31,361 33% 29% 776,979 776,979 - 0% District Attorney 1,528,953 1,374,946 154,007 33% 30% i) 4,586,859 4,300,000 286,859 6% Finance/Tax 283,083 262,398 20,685 33% 31% 849,249 849,249 - 0% Veterans 88,494 66,901 21,593 33% 25% 265,481 265,481 - 0% Property Management 81,323 72,812 8,511 33% 30% i) 243,970 236,070 7,900 3% Grant Projects 32,320 31,488 832 33% 32% 96,960 96,960 - 0% Non-Departmental 434,537 288,431 146,106 33% 22% 1,303,612 1,303,612 - 0% Contingency 1,730,952 - 1,730,952 33% n/a 5,192,855 - 5,192,855 100% 6,255,716 3,895,113 2,360,603 33% 21% 18,767,149 13,054,335 5,712,814 30% Transfers Out 4,096,168 4,018,496 77,672 33% 33% 12,288,504 12,288,504 - 0% TOTAL REQUIREMENTS 10,351,884 7,913,609 2,438,275 33% 25% 31,055,653 25,342,839 5 712 814 18% NET (Resources - Requirements) 3,946,666 3,844,663 (102,003) - 6,257,656 , , 6,257,656 a) Receipts of Cigarette Tax and Liquor Revenue trending higher than anticipated. b) A&T grant payment received quarterly. Two payments reflected in actuals. c) Revenue projection reduction for GIS transfer funds related to a State project that may discontinue. (See footnote g.) d) Projection adjustment based on trending of Filing & Recording Fees and A&T Recording Fees. e) Additional revenues expected from the Department of Justice HIDTA grant. f) Payments received quarterly. One payment reflected in actuals. g) Projection adjusted $100,000 for salary savings and $75,000 for costs that will not be incurred if State project is discontinued. h) Reduction in projection reflects costs not incurred with elimination of September election and reduced cost of capital expenditure. i) Personnel services projection decreased to reflect anticipated salary savings. COMM JUSTICE-JUVENILE Statement of Financial Operating Data Four Months Ended October 31, 2007 I Year to Date Revised Year End I I Budget Actual Variance FY % Coll. % I I Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 900,000 $ 987,986 $ 87,986 100% 110% $ 900,000 $ 987,986 $ 87,986 Revenues Federal Grants 51,333 - (51,333) 33% 0% a) 153,998 153,998 - SB #1065-Court Assess. 16,000 20,110 4,110 33% 42% 48,000 66,000 18,000 State Miscellaneous 1,531 - (1,531) 33% 0% b) 4,594 - (4,594) Discovery Fee 3,333 6,015 2,682 33% 60% c) 10,000 21,000 11,000 Food Subsidy 13,000 6,574 (6,426) 33% 17% d) 39,000 39,000 - Juvenile Crime Prevention 90,130 74,120 (16,010) 33% 27% a) 270,391 296,480 26,089 Inmate/Prisoner Housing 26,667 10,200 (16,467) 33% 13% e) 80,000 60,000 (20,000) Inmate Commissary Fees 400 243 (157) 33% 20% 1,200 1,200 - Contract Payments 221,571 54,589 (166,982) 33% 8% f) 664,712 320,000 (344,712) Miscellaneous 167 150 (17) 33% 30% 500 500 - Program Fees - 103 103 33% n/a - 103 103 MIP Diversion Fees 1,333 625 (708) 33% 16% 4,000 4,000 - Interest on Investments 12,000 20,115 8,115 33% 56% 36,000 60,000 24,000 Leases 11,571 9,140 (2,431) 33% 26% 34,714 13,403 (21,311) Grants - Private - 1,741 1,741 33% n/a - 1,741 1,741 Leve17 41,946 26,352 (15,594) 33% 21% a) 125,839 105,409 (20,430) Total Revenues 490,982 230,077 (260,905) 33% 16% 1,472,948 1,142,834 (330,114) Transfers In-General Fund 1,977,741 1,977,741 - 33% 33% 5,933,223 5,933,223 - TOTAL RESOURCES 3,368,723 3,195,804 (172,919) 33% 38% 8,306,171 8,064,043 (242,128) REQUIREMENTS: Exp. Expenditures Community Justice-Juvenile Personal Services 873,902 826,151 47,751 33% 32% g) 2,621,706 2,592,706 29,000 Materials and Services 608,051 389,407 218,644 33% 21% h) 1,824,154 1,624,154 200,000 Capital Outlay 33 - 33 33% 0% 100 100 - Juvenile Resource Center Personal Services 990,636 882,264 108,372 33% 30% g) 2,971,908 2,781,908 190,000 Materials and Services 78,852 63,691 15,161 33% 27% 236,557 220,557 16,000 Capital Outlay 33 - 33 33% 0% 100 100 - Contingency 217,215 - 217,215 33% n/a 651,646 - 651,646 TOTAL REQUIREMENTS 2,768,722 2,161,513 607,209 33% 26% 8,306,171 7,219,525 1,086,646 NET (Resources - Requirements) 600,001 1,034,291 434,290 - 844,518 844,518 a) Reimbursements requested quarterly. Federal (Byme Grant-Functional Family Therapy) grant request submitted in November. Juvenile Crime Prevention and Level 7 projections adjusted for a change in funding by the State finalized in August. b) Projection eliminated due to receipt of revenue in prior year. c) Requests for discovery documents are higher than anticipated. d) Restructuring of Food Subsidy system caused delays in payment. August and September payments received in October, July in November. Anticipate total budgeted amount to be received by year end. e) Due to increased population of in-county youth (WellSpring Program), housing for out-of-county youth decreased. With the discontinuance of the WellSpring Program on August 31 st, out-of-county youth population and associated revenues should increase. f) Billing to DHS is generated in succeeding month with payments being received 6-8 weeks after billing. Projection adjusted for elimination of WellSpring Program. g) Projection adjusted for salary savings from unfilled positions and estimated savings on Resource Center on-call personnel. h) Projection adjusted to reflect reduction in anticipated expenditures including DHS match for WeIlSpring Program. SHERIFF - Rev Detail Statement of Financial Operating Data Four Months Ended October 31, 2007 RESOURCES: Beg. Net Working Capital Revenues Law Enf Dist Countywide Law Enf Dist Rural Interest Interest on Unsegregated Total Revenues TOTAL RESOURCES Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 2,562,148 $ 2,648,830 $ 86,682 100% 6,146,251 4,871,181 4,035,439 3,667,452 - 40,276 (1,275,070) 33% (367,987) 33% 40,276 33% - 33% 10,181,690 8,578,909 (1,602,781) 33% 12,743,838 11,227,739 (1,516,099) 33% 103% $ 2,562,148 $ 2,648,830 $ 86,682 26% a) 18,438,752 30% a) 12,106,316 n/a - n/a - 28% 30,545,068 28,942,287 (1,602,781) 34% 33,107,216 31,591,117 (1,516,099) 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. 730,519 577,794 152,725 33% 26% b) 2,191,557 2,091,557 100,000 221,110 220,368 742 33% 33% 663,327 663,327 - 426,602 487,987 (61,385) 33% 38% c) 1,279,803 1,279,803 - 691,760 691,233 527 33% 33% 2,075,281 2,075,281 - 2,462,195 2,242,819 219,376 33% 30% d) 7,386,586 7,286,586 100,000 193,735 185,228 8,507 33% 32% 581,205 581,205 - 2,906,678 2,533,592 373,086 33% 29% e) 8,720,033 8,520,033 200,000 80,787 62,467 18,320 33% 26% 242,360 242,360 - 45,405 47,592 (2,187) 33% 35% 136,215 136,215 - 250,566 234,760 15,806 33% 31% 751,698 751,698 - 1,211,323 1,119,368 91,955 33% 31% 0 3,633,970 3,433,970 200,000 65,430 62,409 3,021 33% 32% 196,289 196,289 - 928,962 2,594,371 (1,665,409) 33% 93% g) 2,786,885 2,873,567 (86,682) 804,002 - 804,002 33% n/a 2,412,007 - 2,412,007 Transfers Out 16,667 12,500 4,167 33% TOTAL REQUIREMENTS 11,035,741 11,072,488 (36,747) 33% NET (Resources - Requirements) 1,708,097 155,251 (1,552,846) 25% 50,000 50,000 - 33% 33,107,216 30,181,891 2,925,325 1,409,226 1,409,226 17,163,682 (1,275,070) 11,738,329 (367,987) 40,276 40,276 Sheriff Notes Statement of Financial Operating Data Four Months Ended October 31, 2007 a) Projection reflects adjustment for first quarter actual expenditures reimbursed. b) Variance due to open Undersheriff position and timing of capital expenditures. c) The annual $231,610 transfer to Fund 245 (Communication System) for the year was made in September. d) Five open Patrol positions will be filled in December/Janurary. Personnel expenditures will end the year below budget. e) The open deptuty positions (6) will be filled by January. Personnel expenditures will end the year below budget. f) Variance due to timing of filling open positions for opening the Work Center. Personnel expenditures will be below budget for the year. Part of the labor savings will offset higher than budgeted renovation expenses. g) Allocation of beginning net working capital to County wide and Rural Law Enforcement Districts. Projection revised for fiscal year 2006-07 year end adjustments. Sheriff 701 Statement of Financial Operating Data Four Months Ended October 31, 2007 I Year to Date Revised Year End Budget Actual Variance FY % Con. % Bud et Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 33% n/a $ - $ - $ _ Revenues Tax Revenues - Current 4,647,115 1,659,700 (2,987,415) 33% 12% 13,941,344 13,941,344 - Tax Revenues - Prior 84,813 79,704 (5,109) 33% 31% 254,440 254,440 - State Grant 15,052 12,382 (2,670) 33% 27% 45,156 45,156 - Transp. of State Wards 1,667 5,406 3,739 33% 108% 5,000 8,000 3,000 SB 1145 667,868 1,088,898 421,030 33% 54% a) 2,003,604 2,023,208 19,604 Des. Cty Video Lottery Grant 116,667 - (116,667) 33% 0% b) 350,000 350,000 - Des Cty Sheriffs Office 429,212 1,295,648 866,436 33% 101% c) 1,287,636 1,327,064 39,428 Des Cty Court Security 33,335 33,336 1 33% 33% 100,006 100,006 - Des Cty Juvenile Contract 3,200 6,628 3,428 33% 69% 9,600 9,600 - Des Cty Parole & Prb Cnt 267 - (267) 33% 0% 800 800 - Title III Reimbursement - - - 33% n/a d) - 75,000 75,000 Inmate Commissary Fees 26,667 21,151 (5,516) 33% 26% 80,000 80,000 - Work Center Work Crews 25,000 - (25,000) 33% 0% e) 75,000 75,000 - Soc Sec Incentive-Fed 1,333 2,000 667 33% 50% 4,000 4,000 - Miscellaneous 4,500 741 (3,759) 33% 5% 13,500 13,500 - Medical Services Reimb 5,600 881 (4,719) 33% 5% 16,800 16,800 - Restitution 350 141 (209) 33% 13% 1,050 1,050 - Sheriff Fees 51,205 54,851 3,646 33% 36% 153,615 153,615 - Interest 30,000 (24,179) (54,179) 33% -27% f) 90,000 90,000 - Interest on Unsegregated 2,400 1,440 (960) 33% 20% 7,200 7,200 - Rentals - 14,589 14,589 33% 1458900% g) 1 21,882 21,881 Total Revenues 6,146,251 4,253,317 (1,892,935) 33% 23% 18,438,752 18,597,665 158,913 TOTAL RESOURCES 6,146,251 4,253,317 (1,892,935) 33% 23% 18,438,752 18,597,665 158,913 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS - Materials and Services 6,146,252 4,871,182 1,275,070 33% 26% h) 18,438,752 17,163,682 1,275,070 TOTAL REQUIREMENTS 6,146,252 4,871,182 1,275,070 33% 26% 18,438,752 17,163,682 1,275,070 NET (Resources - Requirements) (1) (617,866) (617,865) - 1,433,983 1,433,983 a) Projection adjusted for increase in 2007-09 State Budget Grant Allocation. Actual amount includes two quarterly payments. b) Contribution toward Work Center remodel. c) Allocation of beginning net working capital from Sheriffs Fund. Projection revised for fiscal year 2006-07 year end adjustments. d) Title III approved allocation to Sheriffs Office. e) Revenue from work crews is planned in third and fourth quarters after the work center reopens in January 2008. f) Interest variance reflects timing of property tax revenue. g) Delay in FBI relocation resulting in unexpected rental revenue. h) Projection reflects adjustment for first quarter actual expenditures reimbursed. Sheriff 702 Statement of Financial Operating Data Four Months Ended October 31, 2007 Year to Date Revised Year r End Budget Actual Variance FY % i Coll. % I I Budget Projection Variance RESOURCES: Beg. Net Working Capital $ - $ - $ - 33% n/a $ - $ - $ - Revenues Tax Revenues - Current 2,246,667 821,404 (1,425,263) 33% 12% 6,740,000 6,740,000 - Tax Revenues - Prior 40,537 78,560 38,023 33% 65% 121,610 121,610 - Federal Grants 6,167 6,544 377 33% 35% a) 18,500 18,500 - US Forest Service 24,000 24,000 - 33% 33% 72,000 72,000 - State Grant 26,464 13,718 (12,746) 33% 17% b) 79,392 79,392 - SB #1065 Court Assessment 14,167 20,110 5,943 33% 47% c) 42,500 67,000 24,500 Marine Board License Fee 32,981 - (32,981) 33% 0% d) 98,944 98,944 - Narcotic Task Force 36,667 - (36,667) 33% 0% e) 110,000 110,000 - Des Cty General Fund Grnt 121,749 - (121,749) 33% 0% f) 365,247 365,247 - Des Cty Transient Room Tax 761,584 761,584 - 33% 33% 2,284,753 2,284,753 - Des Cty Other Grant 20,161 - (20,161) 33% 0% g) 60,483 60,483 - Des Cty Sheriffs Office 424,837 1,290,475 865,638 33% 101% h) 1,274,512 1,321,766 47,254 City of Sisters 131,085 131,085 - 33% 33% 393,255 393,255 - Des Cty Tax/Fin Contract 917 - (917) 33% 0% i) 2,750 2,750 - Des Cty CDD Contract 17,178 - (17,178) 33% 0% i) 51,535 51,535 - Des Cty Solid Waste Cntrt 17,178 - (17,178) 33% 0% i) 51,535 51,535 - Des Cty Clerk/Election 1,000 - (1,000) 33% 0% i) 3,000 3,000 - Security & Traffic Reimb 21,500 9,178 (12,322) 33% 14% j) 64,500 64,500 - Seat Belt Program 2,000 3,025 1,025 33% 50% 6,000 6,000 - Miscellaneous - 1,007 1,007 33% n/a - 1,500 1,500 Sheriff Fees - 2,844 2,844 33% n/a - 5,000 5,000 Court Fines & Fees 41,667 27,027 (14,640) 33% 22% k) 125,000 85,000 (40,000) Impound Fees 25,000 25,300 300 33% 34% 75,000 75,000 - Restitution - Street Crimes - 40 40 33% n/a - 500 500 Interest 20,000 (9,259) (29,259) 33% -15% 1) 60,000 60,000 - Interest on Unsegregated 1,600 792 (808) 33% 17% 4,800 4,800 - Sale of Equip & Material 333 906 573 33% 91% 1,000 1,000 - Total Revenues 4,035,439 3,208,340 (827,099) 33% 27% 12,106,316 12,145,070 38,754 TOTAL RESOURCES 4,035,439 3,208,340 (827,099) 33% 27% 12,106,316 12,145,070 38,754 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Materials and Services 4,035,439 3,667,452 367,987 33% 30% m) 12,106,316 11,738,329 367,987 TOTAL REQUIREMENTS 4,035,439 3,667,452 367,987 33% 30% 12,106,316 11,738,329 367,987 NET (Resources - Requirements) - (459,112) (459,112) - 406,741 406,741 a) HIDTA reimbursements received as billed. Justice Assistance Grant (JAG) to be received ? b) DUII and Safety Belt grants payment of $21,000 received early November. Anticipate collection of budgeted total by year end. c) Court assessment revenues are higher than anticipated. Projection adjusted to reflect increased in collections. d) Marine board license fees are received in February and June. e) Payments are received after the quarterly progress report is submitted and approved. f) Payment from General Fund occurs in June. g) Portion of court fines and fees collected by Justice Court to be paid in June. h) Allocation of beginning net working capital from Sheriffs Fund. Projection revised for fiscal year 2006-07 year end adjustments. i) Departments are billed when services are utilized. j) Organizations and groups are billed when services are utilized. k) Court fines and fees collected by Circuit Courts are less than anticipated. Projection adjusted to reflect trend. 1) Interest variance reflects timing of property tax revenue. m) Projection reflects adjustment for first quarter actual expenditures reimbursed. HEALTH Statement of Financial Operating Data Four Months Ended October 31, 2007 Year to Date Revised Ye En RESOURCES: Bud et Var iance YY % Coll. Bud et = Pro nce Beg. Net Working Capital Revenues $ 600,000 $ 804,209 $ 204,209 100% 134% $ 600,000 $ 804,209 $ 204,209 Medicare Reimbursement 1,667 290 (1,377) 33% 6% a) 5 000 5 000 State Grant Child Dev & Rehab Center 486,013 373,511 (112,502) 33% 26% b) , 1,458,040 , 1,535,103 77,063 State Miscellaneous 11,134 8,350 (2,784) 33% 25% c) 33,401 33,401 OMAP 58,509 43,194 (15,315) 33% 25% d) 175,528 175,528 Family Planning Exp Proj 87,300 183 3 66,270 (21,030) 33% 25% e) 261,900 261,900 Grants , 33 85,241 (98,092) 33% 15% fl 550,000 550,000 _ School Districts 7,307 - (7,307) 33% 0% g) 21,922 21,922 Contract Payments/ESD 5,041 3 667 - (5,041) 33% 0% h) 15,123 15,123 Miscellaneous , - (3,667) 33% 0% h) 11,000 11,000 Patient Insurance Fees - 19,267 150 25 533 150 6 266 33% 33% n/a - 150 150 Health Dept/Patient Fees 64,517 , 72 263 , 7 746 33 44% 57,800 57,800 Vital Records-Birth 13,333 , 11,880 , (1 453) % 33% 37% 30% 193,550 193,550 _ Vital Records-Death 30,667 28,485 , (2,182) 33% 31% 40,000 92 000 40,000 9 Interest on investments 10,000 13,616 3,616 33% 45% , 30 000 2,000 40 000 10 Donations 3,950 3,564 (386) 33% 30% , 11 850 , 11 850 ,000 Interfund Contract Administrative Fee 39,094 15,707 (23,387) 33% 13% 1) , 117,283 , 80,795 (36,488) Interfund Grant 4,000 4,000 - 33% 33% 12,000 12,000 Total Revenues - 1,028,799 11,721 763,775 11,721 (265 024) 33% 33% n/a 25% i ) - 51,246 51,246 , 3,086,397 3,188,368 101,971 Transfers In-Reserve Fund 33 - (33) 33% 0 Transfers In-General Fund 851,162 850 662 (500) 33% % 100 100 TOTAL RESOURCES 2,479,994 , 2,418,646 (61 315) 33% 33% 39% 2,553,485 2,553,485 , 6,239,982 6,546,162 306,180 REQUIREMENTS: Exp. Expenditures Personal Services Materials and Services 1,380,197 1,301,835 78,362 33 ° 31% j) 4,140,591 3,840,591 300,000 Capital Outlay 463,338 424,461 38,877 33% 31% 1,390,013 1,390,013 Transfers Out 1,667 550,000 - 37 500 1,667 512 500 33% 33% 0% 5,000 5,000 Contingency 184 793 , , 25% 150,000 150,000 , - 184,793 33% n/a 554,378 - 554,378 TOTAL REQUIREMENTS 2,579,995 1,763,796 816,199 33% 28% 6,239,982 5,385,604 854,378 NET (Resources - Requirements) (100,001) 654,850 754 884 , - 1,160,558 1,160,558 a) Actual collected includes receipts for July and August. b) Monthly state grant payments received one month in arrears. c) Payments received quarterly. Actual reflects first quarter payment. d) Actuals include monthly payments for the Family Planning program staff (L Thistle/K Fost), and a quarterly payment for the Maternal Child Health (MAC match funds). Payments lag a month behind billing period. e) Revenues for Family Planning and Maternity Case Management programs lag a month behind. Total budgeted revenues are expected to be collected. f) Actual collected includes receipts for July and August encounters. g) Grant will be received by end of fiscal year for Central Oregon Community Investment Board program. h) School year starts in September with billing occurring one month in arrears. i) Service contract with Juvenile Department totalling $80,795 billed quarterly. Projection for grant funding of $51,246 for Drug Court from Mental Health moved to Interfund Grants. j) Anticipated salary savings due to unfilled positions. MENTAL HEALTH Statement of Financial Operating Data Four Months Ended October 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 Year to Date Revised Year End ance Budget Actual Variance FY % Coll. % Bud et Projection Vari $ 2,900,000 $ 2,876,903 $ (23,097) 100% 99% 1,833 2,465 632 53,333 54,859 1,526 48,539 (8,036) (56,575) 1,276,205 1,268,237 (7,968) 124,711 34,594 (90,117) 50,800 111,993 61,193 35,333 34,721 (612) 13,333 - (13,333) 33,333 6,900 (26,433) 2,400 600 (1,800) 7,691 4,769 (2,922) 28,371 30,813 2,442 72,500 73,820 1,320 7,933 4,469 (3,464) - 20,215 20,215 48,080 51,277 3,197 5,500 3,325 (2,175) 667 - (667) 1,333 1,040 (293) 817,313 817,316 3 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 45% 34% -6% a) 33% b) 9% C) 73% 33% 0% d) 7% e) 8% 21% 36% 34% 19% n/a f) 36% 20% 0% 26% 33% Total Revenues 2,629,208 2,513,377 (115,831) 33% Transfers In-General Fund 487,505 490,005 2,500 33% Transfers In-Other 142,731 139,397 (3,334) 33% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 32% 34% 33% 6,159,444 6,019,682 (139,762) 33% 47% Exp. $ 2,900,000 $ 2,876,903 $ (23,097) 5,500 5,500 - 160,000 160,000 - 145,618 137,618 (8,000) 3,828,614 4,611,473 782,859 374,134 374,134 - 152,400 200,000 47,600 106,000 106,000 - 40,000 40,000 - 100,000 100,000 - 7,200 7,200 - 23,072 23,072 - 85,114 85,114 - 217,500 217,500 - 23,800 23,800 - - 20,215 20,215 144,240 144,240 - 16,500 16,500 - 2,000 2,000 - 4,000 4,000 - 2,451,940 2,451,940 - 7,887,632 8,730,306 842,674 1,462,516 1,462,516 428,193 428,193 - 12,678,341 13,497,918 819,577 2,445,041 2,316,642 128,399 33% 32% g) 7,335,124 7,010,124 325,000 1,253,568 945,583 307,985 33% 25% h) 3,760,704 3,810,704 (50,000) 33 - 33 33% 0% 100 100 - 50,000 37,500 12,500 33% 25% 150,000 150,000 - 471 477 471 - 477 33% n/a 1,432,413 - 1,432,413 , , TOTAL REQUIREMENTS 4,226,113 3,299,725 926,388 33% 26% 12,678,341 10,970,928 1,707,413 NET (Resources - Requirements) 1,933,331 2,719,957 786,626 - 2,526,990 2,526,990 a) Negative YTD actual revenue represents an adjustment for revenue accrued June 30, 2007. Grant billing paid quarterly, in arrears. b) Projection increased to reflect additional DHS State Grant funding for FY 07/08. c) State miscellaneous variance a result of historical 30-60 day lag time in receiving payment. d) First payment expected in November. e) Services to school districts commence at start of school year and are billed monthly in arrears. f) Revenues are unpredictable, not typically budgeted. g) Anticipated salary savings due to unfilled positions. h) Projection increased for new contracts related to additional grant funding and increased costs on existing contracts. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Four Months Ended October 31, 2007 Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 489,444 $ 211,661 $ (277,783) 100% 43% $ 489,444 $ 211,661 (277,783) Revenues Admin-Operations 26,058 13,203 (12,855) 33% 17% a) 78,175 65,000 (13,175) Admin-GIS 2,667 899 (1,768) 33% 11% b) 8,000 5,000 (3,000) Admin-Code Enforcement 142,150 113,008 (29,142) 33% 26% c) 426,450 390,000 (36,450) Building Safety 822,650 643,144 (179,506) 33% 26% c) 2,467,950 2,100,000 (367,950) Electrical 201,300 167,428 (33,872) 33% 28% c) 603,900 550,000 (53,900) Contract Services 260,833 280,156 19,323 33% 36% 782,500 782,500 - Env Health-On Site Prog 319,150 184,692 (134,458) 33% 19% c) 957,450 650,000 (307,450) Env Health-Lic Facilities 182,150 67,055 (115,095) 33% 12% d) 546,450 546,450 - Env Health - Drinking H2O 17,333 12,901 (4,432) 33% 25% e) 52,000 52,000 - EPA Grant 51,892 - (51,892) 33% 0% e) 155,675 155,675 - Planning-Current 517,150 456,854 (60,296) 33% 29% c) 1,551,450 1,450,000 (101,450) Planning-Long Range 238,117 154,440 (83 677) 33% 22% c) 714 350 650 000 (64 350) , , , Total Revenues 2,781,450 2,093,780 (687,670) 33% 25% 8,344,350 7,396,625 (947,725) Trans In-CDD Reserve 66,667 - (66,667) 33% 0% 200,000 200,000 - Trans In-CDD Bldg/Elec 26,380 - (26,380) 33% 0% 79,139 79,139 - Trans In-General Fund 25,000 18,750 (6,250) 33% 25% 75,000 75,000 - Transln-Other 33 - (33) 0% 0% 100 100 - TOTAL RESOURCES 3,362,561 2,324,191 (1,038,370) 33% 25% 9,188,033 7,883,286 (1,225,508) REQUIREMENTS: Exp. 9/61 EXPENDITURES & TRANSFERS Admin-Operations Division 871,721 776,053 95,668 33% 30% f) 2,615,163 2,550,000 65,163 Admin-GIS Division 101,325 93,681 7,644 33% 31% 303,974 303,974 - Admin-Code Enforcement 76,590 56,687 19,903 33% 25% 229,770 229,770 - Building Safety Division 436,950 421,024 15,926 33% 32% f) 1,310,851 1,150,000 160,851 Electrical Division 144,004 131,926 12,078 33% 31% 432,013 432,013 - Contract Services 212,421 197,510 14,911 33% 31% f) 637,262 550,000 87 262 Env Health-On Site Pgm 197,395 166,799 30,596 33% 28% f) 592,186 510,000 , 82 186 Env Health-Lic Facilities 166,381 149,098 17,283 33% 30% 499,143 499,143 , - Env Health - Drinking H2O 23,138 22,467 671 33% 32% 69,415 69,415 - EPA Grant 41,217 38,258 2,959 33% 31% 123,651 123,651 - Planning-Current Division 447,758 395,724 52,034 33% 29% f) 1,343,273 1,275,000 68 273 Planning-Long Range Div 183,337 149,243 34,094 33% 27% 550,011 550,011 , - Contingency 160,440 - 160,440 33% n/a 481 321 - 481 321 , , TOTAL REQUIREMENTS 3,062,677 2,598,470 464,207 33% 28% 9,188,033 8,242,977 945,056 NET (Resources - Requirements) 299,884 (274,279) (574,163) - (359 691) (280 452) , , a) Revenue is low in relation to budget as payments for Redmond addressing contract are billed later in the year. b) Payments for custom GIS work are received as work is requested. c) Although revenue is seasonal based on development patterns, year end projections are estimated below budget. d) Revenue is received primarily in January and February after license renewal statements are mailed out. e) Payments are received in installments or as billed. 0 Year end figures adjusted downward to reflect unfilled vacancies associated with lower permit volume. ROAD Statement of Financial Operating Data Four Months Ended October 31, 2007 Year to Date Revised I Year End I Budget Actual Variance FY % Coll. % I Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 5,302,706 $ 5,605,930 $ 303,224 100% 106% $ 5,302,706 $ 5,605,930 $ 303,224 Revenues System Development Ch 22,333 6,237 (16,096) 33% 9% 67,000 67,000 - Mineral Lease Royalties - 4,777 4,777 33% n/a - 4,777 4,777 Forest Receipts 1,022,667 - (1,022,667) 33% 0% a) 3,068,000 3,068,000 - State Grant 124,148 - (124,148) 33% 0% 372,445 372,445 - Motor Vehicle Revenue 2,800,000 2,686,944 (113,056) 33% 32% 8,400,000 8,400,000 - City of Bend 58,333 - (58,333) 33% 0% b) 175,000 175,000 - City of Redmond 141,667 175 (141,492) 33% 0% b) 425,000 425,000 - City of Sisters 5,000 - (5,000) 33% 0% b) 15,000 15,000 - Miscellaneous 16,667 14,879 (1,788) 33% 30% 50,000 50,000 - Road Vacations 333 1,000 667 33% 100% 1,000 1,000 - Interest on Investments 50,000 93,680 43,680 33% 62% 150,000 150,000 - Donations 800 2,440 1,640 33% 102% 2,400 2,440 40 Interfund Contract 300,767 - (300,767) 33% 0% c) 902,300 902,300 - Equipment Repairs 84,100 76,151 (7,949) 33% 30% d) 252,300 252,300 - Vehicle Repairs 33,333 - (33,333) 33% 0% e) 100,000 100,000 - LID Construction 50,000 - (50,000) 33% 0% f) 150,000 150,000 - Vegetation Management 30,600 - (30,600) 33% 0% g) 91,800 91,800 - Inter-fund: Forester 7,000 - (7,000) 33% 0% g) 21,000 21,000 - Car Washes - 1,614 1,614 33% n/a d) - 1,614 1,614 Sale of Eqp & Material 200,000 114,982 (85,018) 33% 19% 600,000 600,000 - Sale of Public Lands 167 - (167) 33% 0% 500 500 - Total Revenues 4,947,915 3,002,879 (1,945,036) 33% 20% 14,843,745 14,850,176 6,431 Trans In-Solid Waste 309,000 - (309,000) 33% 0% h) 927,000 695,250 (231,750) Trans In-Road Imp Res 5,220 - (5,220) 33% 0% i) 15,660 15,660 - TOTAL RESOURCES 10,564,841 8,608,809 (1,956,032) 33% 50% 21,089,111 21,167,016 77,905 REQUIREMENTS: Exp. Expenditures Personal Services 1,883,824 1,830,995 52,829 33% 32% 5,651,471 5,531,813 119,658 Materials and Services 2,876,319 2,430,366 445,953 33% 28% j) 8,628,958 7,742,761 886,197 Capital Outlay 1,381,667 7,485 1,374,182 33% 0% k) 4,145,000 1,281,000 2,864,000 Transfers Out 300,000 - 300,000 33% 0% 900,000 900,000 - Contingency 894 587 - 587,894 33% n/a 1,763,682 - 1,763,682 , TOTAL REQUIREMENTS 7,029,704 4,268,846 2,760,858 33% 20% 21,089,111 15,455,574 5,633,537 NET (Resources - Requirements) 3,535,137 4,339,963 804,826 - 5,711,442 5,711,442 a) Annual payment anticipated to be received in December. b) Billed upon completion of work. c) Payment to be received in June 2007 from Funds 328 & 329. d) Billed to County departments monthly in arrears. e) Payment to be received in June 2007 from Fund 340. 0 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. Rate increase for transfer postponed until October 1 st. i) Payment to be received in June 2007 from Fund 335. j) Seasonal expense includes overlays to occur spring 2008. k) Funding reserved for Deschutes Junction project. ADULT PAROLE & PROBATION Statement of Financial Operating Data Four Months Ended October 31, 2007 RESOURCES: Beg. Net Working Capital Revenues State Grant State Miscellaneous Probation Work Crew Fees Alcohol and Drug Treatment Polygraph Testing Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Cognitive Program Interest on Investments Leases Rentals Drug Court - Byrne Total Revenues Year to Date Revised Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 200,000 $ 311,856 $ 111,856 100% 156% 887,251 1,330,906 443,655 4,433 3,023 (1,410) 17,000 10,682 (6,318) 167 85 (82) 800 1,025 225 3,000 1,355 (1,645) 30,000 32,309 2,309 68,333 83,038 14,705 1,433 15 (1,418) 9,500 7,570 (1,930) - 3,000 3,000 1,000 150 (850) 3,333 5,162 1,829 1,026,250 1,478,320 452,070 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 50% a) 23% b) 21% 17% 43% 15% 36% 41% c) 0% 27% n/a d) 5% e) 52% 48% $ 200,000 $ 311,856 $ 111,856 2,661,752 2,661,752 - 13,300 13,300 - 51,000 51,000 - 500 500 - 2,400 2,400 - 9,000 9,000 - 90,000 90,000 - 205,000 249,000 44,000 4,300 4,300 - 28,500 25,000 (3,500) - 3,000 3,000 3,000 3,000 - 10,000 10,000 - 3,078,752 3,122,252 43,500 Transfers In-General Fund 113,333 113,333 - 33% 33% 340,000 340,000 Transfers In-Video Lottery 35,333 35,333 - 33% 33% 106,000 106,000 - Transfers In-Sheriff 16,667 12,500 (4,167) 33% 25% f) 50,000 50,000 - Transfers In-Other (GF) 1,000 750 (250) 33% 25% f) 3,000 3,000 - TOTAL RESOURCES 1,392,583 1,952,092 559,509 33% 52% 3,777,752 3,933,108 155,356 REQUIREMENTS: Exp. Expenditures Personal Services 938,511 858,007 80,504 33% 30% g) 2,815,532 2,735,532 (80,000) Materials and Services 209,087 207,448 1,639 33% 33% 627,262 627,262 - Capital Outlay 33 - 33 33% 0% 100 100 - Contingency 111,619 - 111,619 33% n/a 334,858 - (334 858) TOTAL REQUIREMENTS 1,259,250 1,065,455 193,795 33% 28% 3,777,752 3,362,894 (414,858) NET (Resources - Requirements) 133,333 886,637 753,304 - 570 214 570 214 , , a) State Grant is paid quarterly. Two quarters have been received. b) Subsidy funds were not included with State Grant in the quarterly payment. Second quarter payment received in early November. c) Number of clients on supervision increased. In addition, a concerted effort to collect restitution affected Probation Supervison Fee collection positively. d) The Bethlehem Inn occupancy continued into new fiscal year resulting in unexpected revenue. e) Rent not collected due to closure of transitional house for two months. f) Transfers processed quarterly. g) Projection adjusted to reflect salary savings on unfilled positions. COMM ON CHILDREN & FAMILIES Statement of Financial Operating Data Four Months Ended October 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 91,646 62,497 (29,149) 33% 23% 274,939 274,939 - Title IV - Family Sup/Pres 13,867 - (13,867) 33% 0% a)i) 41,601 37,650 (3,951) HealthyStart Medicaid 46,667 36,051 (10,616) 33% 26% b) 140,000 130,000 (10,000) Child Care Block Grant 18,899 - (18,899) 33% 0% a)c) 56,698 58,668 1,970 Level 7 Services 68,656 - (68,656) 33% 0% a)i) 205,969 175,191 (30,778) Juvenile Crime Prevention 129,969 - (129,969) 33% 0% d)i) 389,908 452,792 62,884 State Prevention Funds 45,833 46,875 1,042 33% 34% e) 137,500 187,500 50,000 HealthyStart /R-S-G 110,231 - (110,231) 33% 0% a)i) 330,694 374,000 43,306 OCCF Grant 125,201 - (125,201) 33% 0% a)i) 375,603 472,124 96,521 Miscellaneous 1,167 3,894 2,727 33% 111% f) 3,500 7,000 3,500 Court Fines & Fees 8,000 8,440 440 33% 35% 24,000 24,000 - Interest on Investments 8,333 10,356 2,023 33% 41% g) 25,000 45,000 20,000 Grants-Private 4,000 - (4,000) 33% 0% h) 12,000 11,000 (1,000) Total Revenues 672,469 168,113 (504,356) 33% 8% 2,017,412 2,249,864 232,452 Trans from General Fund 116,400 116,400 - 33% 33% 349,200 349,200 - Oth f 099 57 824 42 275) (14 33% 25% 171,297 171,297 - er rom Trans , , , Total Transfers In 173,499 159,224 (14,275) 33% 31% 520,497 520,497 - TOTAL RESOURCES 1,388,179 941,137 (447,042) 33% 31% 3,080,120 3,384,161 304,041 REQUIREMENTS: Exp. Expenditures Personal Services 182,240 165,823 16,417 33% 30% j) 546,721 546,721 - Materials and Services 716,705 587,529 129,176 33% 27% k) 2,150,116 2,284,206 (134,090) Capital Outlay 33 - 33 33% 0% 100 100 - Contingency 127,728 - 127,728 33% n/a 383,183 - 383,183 TOTAL REQUIREMENTS 1,026,706 753,352 273,354 33% 24% NET (Resources - Requirements) 361,473 187,785 (173,688) 3,080,120 2,831,027 249,093 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) Federal funds to be requested later in the fiscal year. d) JCP funding allocations increased. e) Safe & Drug Free Schools grant budgeted at $50,000, actual is $100,000. f) Partner reimbursements for office expenses, and project contributions expected to increase. g) Interest income projection increased due to higher cash balance and additional grant funding. h) Youth conference donations decreased to match 06/07 actual amount. Payments anticipated to be received in full by year end. i) Grant funds totalling $917,204 received from OCCF in early November. j) Savings in personal services will be used to fund a temporary, hourly position for the remainder of the fiscal year. k) Some quarterly payments to service providers were still pending at the end of October. Projection adjusted for increase in grant revenue that will be paid to service providers during the course of the fiscal year. SOLID WASTE Statement of Financial Operating Data Four Months Ended October 31, 2007 RESOURCES: Beg. Net Working Capital Revenues State Grant Miscellaneous Franchise 3% Fees Commercial Disp. Fees Private Disposal Fees Franchise Disposal Fees Yard Debris Special Waste Interest Sale of Equip & Material Total Revenues Year to Date LBd sed Year End Budget Actual Variance FY % Coll. % et Pr ojection Variance $ 2,280,356 $ 2,678,908 $ 398,552 100% 117% $ 2,280,356 $ 2,678,908 $ 398,552 - 88,693 88,693 11,667 11,228 (439) 53,333 - (53,333) 686,667 576,393 (110,274) 690,000 598,566 (91,434) 1,791,822 1,561,649 (230,173) 18,883 35,931 17,048 10,000 9,212 (788) 40,000 60,477 20,477 15,000 27,796 12,796 3,317,372 2,969,945 (347,427) 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% 33% n/a a) - 88,693 88,693 32% 35,000 35,000 - 0% b) 160,000 160,000 - 28% c) 2,060,000 2,004,000 (56,000) 29% c) 2,070,000 2,038,500 (31,500) 29% c) 5,375,465 5,231,215 (144,250) 63% d) 56,650 56,650 - 31% 30,000 30,000 - 50% 120,000 181,000 61,000 62% e) 45,000 45,000 - 30% 9,952,115 9,870,058 (82,057) Trans In-North Area Dev 683,333 - (683 333) 33% TOTAL RESOURCES 6,281,061 5,648,853 (632,208) 33% REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 0% f) 2,050,000 2,050,000 - 40% 14,282,471 14,598,966 316,495 Exp. 578,009 545,513 32,496 33% 31% g) 1,664,998 876,094 788,904 33% 18% h) 322,651 - 322,651 33% 0% i) 59,800 70,884 (11,084) 33% 40% 1,942,333 - 1,942,333 33% 0% j) 193,031 - 193,031 33% n/a TOTAL REQUIREMENTS 4,760,822 1,492,491 3,268,331 33% 10% NET (Resources - Requirements) 1,520,239 4,156,362 2,636,123 1,734,028 1,701,532 32,496 4,994,995 4,994,995 - 967,954 967,954 - 179,400 179,400 - 5,827,000 5,595,250 231,750 579,094 - 579,094 14, 282, 471 13, 439,131 843,340 1,159,835 1,159,835 a) Unanticipated EPA grants passed thru Solid Waste. b) Franchise fees are due April 15th. c) Rate increase was budgeted to occur July 1 st, but was delayed until October 1 st. d) Seasonal material. e) Recycling revenues higher than expected and seasonal. f) Transfer will occur after project completion anticipated in November 2007. g) Projection reduced to reflect salary savings on unfilled positions. h) Large dollar expenditures for items, projects, and events are scheduled throughout the year. i) Debt service payments occur in December and June. j) Transfer to Road Department reduced to reflect postponed fee increase and will occur in the last three quarters of fiscal year. Remaining transfers are processed twice a year. Health Benefits Trust Statement of Financial Operating Data Four Months Ended October 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 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Pro'ection Variance $10,500,000 $10,760,885 $ 260,885 100% 102% 3,700,000 4,047,423 347,423 33% 36% 50,633 58,863 8,230 33% 39% 115,010 108,500 (6,510) 33% 31% 258,592 284,760 26,168 33% 37% 133,333 180,752 47,418 33% 45% - - - 33% n/a - 28,550 28,550 33% n/a 150,000 187,276 37,276 33% 42% 4,407,568 4,896,125 488,556 33% 37% TOTAL RESOURCES 14,907,568 15,657,010 749,442 92% 66% REQUIREMENTS Exp. Expenditures: Personal Services 36,262 34,491 1,771 33% Materials & Services Conferences and Seminars 1,000 - 1,000 33% Claims Paid-Medical/Rx 3,279,376 2,695,177 584,200 33% Claims Paid-DentalNision 433,556 396,939 36,617 33% Refunds - (53,852) 53,852 33% n/a Insurance Expense 141,050 108,214 32,836 33% State Assessments 20,000 - 20,000 33% Administration Fee 86,800 76,450 10,350 33% PPO Fee 12,658 10,524 2,134 33% Health Impact 13,333 14,990 (1,656) 33% Printing 4,000 256 3,744 33% Program Expense/Supplies 3,667 - 3,667 33% Other 6,817 6,629 188 33% Total Materials & Services 4,002,258 3,255,326 746,932 33% Capital Outlay - - - 33% Contingency 3,869,015 - 3,869,015 33% 32% $10,500,000 $10,760,885 $ 260,885 11,100,000 11,600,000 500,000 151,900 151,900 - 345,030 345,030 - 775,775 775,775 - 400,000 400,000 - - 28,550 28,550 450,000 510,000 60,000 13,222,705 13,811,255 588,550 23,722,705 24,572,141 849,436 108,786 108,786 - 0% 3,000 3,000 - 27% a) 9,838,129 8,243,932 1,594,197 31% a) 1,300,669 1,214,167 86,502 - (53,852) 53,852 26% 423,150 423,150 - 0% 60,000 60,000 - 29% 260,400 260,400 - 28% 37,975 37,975 - 37% 40,000 40,000 - 2% 12,000 12,000 - 0% 11,000 11,000 - 32% 20,452 20,452 - 27% 12,006,775 10,272,224 1,734,551 0% 100 - 100 0% 11,607,044 - 11,607,044 TOTAL REQUIREMENTS 7,907,535 3,289,817 4,617,718 33% 14% NET (Resources - Requirements) 7,000,033 12,367,193 5,367,160 23,722,705 10,381,010 '13,341,695 - 14,191,130 14,191,130 a) Based on annualizing 17 weeks of claims paid. DESCHUTES COUNTY 911 Statement of Financial Operating Data Four Months Ended October 31, 2007 Year to Date Revised Year End Budget Actual Variance % of FY % Coll. Bud et Projection Variance RESOURCES: Beg. Net Working Capital $2,600,000 $2,947,210 $ 347,210 Revenues Property Taxes - Current 795,420 278,749 (516,671) Property Taxes - Prior 18,333 46,441 28,108 State Reimbursement 7,333 2,191 (5,142) Telephone User Tax 253,213 68,278 (184,935) Data Network Reimb. 11,333 29,473 18,140 Jefferson County 5,333 4,816 (517) User Fee 11,000 27,439 16,439 Contract Payments 23,333 - (23,333) Miscellaneous 2,667 2,330 (337) Interest 15,000 39,849 24,849 Interest on Unsegregated Tax 427 298 (129) Total Revenues 1,143,392 499,864 (643,528) TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 100% 113% $ 2,600,000 $ 2,947,210 $ 347,210 33% 12% 2,386,259 2,386,259 - 33% 84% 55,000 55,000 - 33% 10% a) 22,000 22,000 - 33% 9% b) 759,640 759,640 - 33% 87% c) 34,000 34,000 - 33% 30% 16,000 16,000 - 33% 83% d) 33,000 33,000 - 33% 0% e) 70,000 70,000 - 33% 29% 8,000 8,000 - 33% 89% 0 45,000 100,000 55,000 33% 23% 1,280 1,280 - 33% 15% 3,430,179 3,485,179 55,000 3,743,392 3,447,074 (296,318) 33% 57% 6,030,179 6,432,389 402,210 Exp. 1,146,466 1,000,562 145,904 33% 29% g) 3,439,398 3,293,398 146,000 252,783 255,802 (3,019) 33% 34% 758,349 758,349 - 15,300 - 15,300 33% 0% 45,900 45,900 - 595,511 - 595,511 33% n/a 1,786,532 - 1,786,532 2,010,060 1,256,364 753,696 33% 21% 6,030,179 4,097,647 1,932,532 1,733,332 2,190,710 457,378 - 2,334,742 2,334,742 a) Office of Emergency Management billed monthly in arrears. Actual reflects revenue received for the month of July. b) Telephone tax received quarterly in two separate payments. Actual consists of one payment for first quarter with second payment received in early November. c) Majority of fees billed to agencies have been received. d) Crooked River Ranch annual payment received. Forest Service payments are received quarterly. e) Contract payments from participating agencies normally received in November and December. f) Projection increased for higher than anticipated earnings. g) Decrease of projection on Personal Services represents salary savings on unfilled positions. N N 0 ~j o N N LD C M N CL°om X N U O W N O Y c = t n m aO C 7 O N 21" LL a~-7 W o a :3 a) NE U c > U O O. (D 7 Z 7 n u C J Z aN)~ QO 0 = F f- Q 5 > O Of 2 N N Ajn n OI. 0010 NIM 1O! NI I r in 1 IN17 1710; I^~ ;N r N C C 7 A 7 O O ONO n; A A tD r ' 10 O O e- MI r NI M N ~II 1ac :M OI7 MII O' cn ;O O! lO tp O r M 0 LA N M M M II y', N cot M n COI D! O! 1~ O X10 tff O cO LC0'4 > I 1 I l O O OO LA i010 ~ OI OI O:LOiM N.p 0 IO LOOiWi 110 : OI Om OI O NI rir O N O j 0 O OILO O O n 0 0 0 .010 O O co l7~O O-tO O N n O O N d'Ia aD~ O 0101 O O LO O m O OHO 0 Oi O c1f N N N h r , 0 0 N O ' N O I NOI 71tp1 I LOCOON rIC0 0 N . 0liri' Ncp LO 011'7 to Qj. Oiler 0 0 101 to e l j r . 10 p~ 0 OO r M OIIOO I CD i tp o O'O Co 0 I ~M 1 'O aD cp1 i 1A N I ~N N ICI`" l 00 V 0+ N Ir 7~ r.-: 0 O.iN M O N 0 MII MII LOIO 01I O0 N 0 0 7 0 COI0~01N O M n ''O co O r M O 00O OIL r C IC to 'N m.v as tD O Ito ,C) Co Op O tO1 0 itb c0 O-~' O O O s- O ce) O LO O,M O O O 01010 O O O N am tO O i0 U N 7 N N ~ tN O aD~O p~000~ 7 LC) ~LMA tD t I N O N ~I 0 ' ~ O!~ r!M 0 0 p l l O1i ol 7 m, ILOI 100 00 c 0 a T 0 ~ N iN Ie-I co I ~ N! N 1 A N1~ N p N Q LL a CI 1 1 1' 1 l 1 r! 1 i I~I I I 1 I I 1 I III ' ~O~ I LNO INO co Lo IN O U !0) I 10 IN N : ~ I ~ ~ ~ I I a! N I I I N O O ~ M co ; co INI O ~ M L OO~C) 0 O c0 OI O 00'. a0 C 0 I C IOI ' ' -(0 V'IO' M:CD tM , N N ! iN O O LO LOI I Ol O t 7 i ' 0 lI7' INI 7100 t+f iO fD O~ lO t~In' O'. Itp IrICOI 7 'EM co: ' M' M CD 0 0 041 N ~ I I . 1 I r r r r I I L- O OI ~ O r- ~ O ~ 0: 10 r I T o N O c I O i i IpI :CD i CD 'ti10' M M N iNI N O O O,' O' CD ~ COD1 00 ,q c0 M r co'. co O' LO O LA ' ' v In I M M d N 1 N j 1 - _-!I ~ ' I 0 CrO r co n'. A r0 OO 0 O 1 O O N M r N.O ' ~ OI M1 a O ' I ..O ' O'..' O IO c0 V 0 O O ' . Q LO OD CV 10 W : M N' O C0: O N 1 N N 7 n 1 0.,, co t0 ~ L o opp~ I. O_a0 O co 0 O O'~O o'o O I'Ir r 7', (D n ''Ir O O''O O.O O 0 Cpl N M.. O n LO O 01 O 0J: O tp' ` O O O O'OIO ~ I.O OM M r '.N N CD 0 to i C) O: (D V) LO 0'~ 00 U') 00 co 00 tO''. 7 W ! M N CD C O'I r n ! CD Oi r C M'I M r (0 I : It M M' CD. LO O O LO T O O C) O O r1oa0. N'aDI n M O co O M I :,I C4 Y M N 'O O n, 7 ) 0)1 ~ 1 O O O ' to d'10 : C NIc p CO I 1 LL . I N tO A p O. tD t+ : A. Im. A 01 , I 1 IO O CD nl~, N,OI O N O'.OIO ON O. '.cOIVI01 1 M'10M N O, N O' ' C LO 7 O V O m M O CO; M j LL') co 06 t0 7'. I 0 O O O CO rn III 11 N I C>0 ' O O I N C) O O 0 O 000 O0f N l E N I IO., 'MII OI O M1 'N OI'N ap ' In. LAtAI L N•. OI N ! co lL i j 1 i 1 ' ' Q ~ 7 OO A P.- O ' p r t10 cD M m v' r tc,v m co c ' l o a) , , A i l N E l r O':O O 01,0IO 01. O In n'.7 OIL A 0 O O 1 'o 0 O' OI MI O ' OI N ' O O N r I N ' O , C D j It I 0 D I ' ' ' O I i N1 ' 10 'LOI ~ ' 1 ' > O ~ ILA! rl 7 1 17!COi M M . OfI 101(0 t+f aD! 10-', I 171 co M cO" 71 tA' Ol' OI. I ' 1 I I Imo: i- . . 1 ' ' m O O O, 0 M LO O tO V V ap y t0 M N O O N LO Lo 7 WO O00 O d'nt0 O n tq LO C4 00 C, 00 C. 001 p :3 rCl OD ncM oc ' Orn7 coo r cm 00 (oN CD0 LO LAO Ot0 N }OQU 0 O1Ne 0 m co O V 7 M00 N O; Gi OLIN rM MOOT co rl. ~ M co IT CO Cl) N _ c to N N N r N OOM O n C)toNtO'. OICO M n 'n iD O ' ~O OO' ty CD M.LO 0 N OIr10 M'. r-- O n'M tO. O I O C I : M Cl) OD ' t . 01 0' : ' ' ' ' ' 0 : O Mi CO W M :LO M .O C) a .CO N O p ' 'O 01 O'er nLO LO IM NI t N tt 7I~ ' T. co co IM' Cl) M O I N NI m L 00 O. LOOD:. O MIs r r~ N Iof 100.0 OTr 0 W: O N LL` o o °f a vlvl~l i°I o U E d 7 CD n o th r L " i ' f p 7 W N a0'. cD A O (D r n r 1 Llf t U-) ' co m, I, N N l Co n , 1 u! N- O M O N' I 0 Co n 0'. N CO'I O to 7 n n 01CD n, N CA O n. 7 aDl M 17 2I 0 -00N cD a O 0 1 O O' ' , . , D . . N 6 i ' ' ' D Q 0. m 710,. M tO cD : 0 .n OI. : tOl to V: n n 0 CO. 00 - M O r M M - co LA ao N O 0 OI LA MM ' LO C O 0'00 N 0 M1 1 e ~ O : O , to o I ' n ;;1 1 O r 0„ O 01 CD C0 O ItO 0 0 01 O O O t O 0 ~ ' I I 1tO1 t'7 ' II N: n~ 00 7 010 Lri r.NI O'I A N', I,Ln m: co IOI IO mI 1M Ir V v' ao t-I t- ~ . I . ~ 1 ~ I I~ LL; I m I 7 i m 11 I 1 I~ 1 i . 1 O j 1 V1~ ! 7 I C I C) I 1 O I I 1 IN I C, I d ~ I 1 I, I _ 4) I N i O U) U m ZI CL X W d 7 pi OI CO V I O j~ 7 N N` m, 7 N! N C aIL N C N C1 11 N O N N U) NI O X W ll yj I; "f N', F" ' "I ~I j >1 O L c LL Li l - LL ' V rod lU K - V) U c'O N O o ~ 0 O ~ X U fO U c t6 7 S 2 ` to d t0 1 0 U al LL m; E O C I y c =3 7 ' X O 7LL a1 cc C1 > 1 1 0 Q,'. m c1 M 4) c (n a~ g 2 LL •y N c C 01 m V c C N1 N 7 ° m Q O W C 0 w Q c l0 p1 O R U. O U' 7 c l U c > (L Z R C c 0 LL ='I• !A Z L" I LL ta'V tp CO Q Z N E _ L U m W 1 C O N E a3I tp u_ y U 'O c c `c m m `ro :z to tD m 21 01 to > N v V 2 C m N V) U) O O c O O C O > N t0 75 ' L O o m , c c o m t0 l0 1 m t_ c - ~A c t m o m m EL Om ~ ' I a c ~ Lu ( Z 0 > a m rL a,~U of u t a 1 F m z LL 0 I~ Om ura I i v Deschutes County - Fair and Expo Center YTD-Budget Basis Statement of Financial Operating Data Four Months Ended October 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 TOTAL RESOURCES 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% 14% $ 75,000 $ 10,606 $ (64,394) 438,000 438,747 747 33% 48% 920,000 920,747 747 30,000 29,323 (677) 33% 70% 42,000 41,323 (677) - - - 33% 0% 6,000 6,000 - 18,000 10,853 (7,147) 33% 18% 60,000 52,853 (7,147) 85,000 78,410 (6,590) 33% 29% 270,000 263,608 (6,392) - 3,340 3,340 33% 6% 55,000 58,340 3,340 90,000 128,888 38,888 33% 40% 320,000 358,888 38,888 1,000 198 (802) 33% 10% 2,000 1,000 (1,000) 5,000 10,000 5,000 33% 21% 47,000 52,000 5,000 - 5,000 5,000 33% 5% 95,000 100,000 5,000 1,668 4,771 3,103 33% 95% 5,000 8,103 3,103 2,668 4,791 2,123 33% 60% 8,000 10,122 2,122 671,336 714,321 42,985 33% 39% 1,830,000 1,872,983 42,983 310,088 309,088 1,000 33% 44% 705,353 705,353 - 1,056,424 1,034,015 (20,409) 33% 40% 2,610,353 2,588,942 (21,411) Exp. 297,304 273,664 23,640 33% 300,724 328,146 (27,422) 33% - - - 33% 45,000 - 45,000 33% 125,000 234,000 (109,000) 33% - - - 33% 768,028 835,810 (67,782) 33% 288,396 198,205 (88,191) Accrued Revenue (Accounts Receivable): Current Month Events 13,969 Prior Months 2,505 Total Accounts Receivable 16,474 J 31% 891,983 868,272 23,711 36% 902,542 963,878 (61,336) 0% 359,101 359,101 - 0% 45,000 45,000 - 94% 250,000 250,000 - n/a 161,727 - 161,727 32% 2,610,353 2,486,251 124,102 - 102,692 102,692 Deposits Received for Future Events: 2007: November 30,153 December 775 2008: January 2,000 February 3,200 March 1,050 April 5,280 May 2,200 June 1,700 September 800 October 785 November 1,250 December 575 2009 and Beyond 40,427 TOTAL 90,195 r Deschutes County Fair and Expo Center Statement of Financial Operating Data October 2007 Budget Actual Variance RESOURCES: Beg. Net Working Capital $ - $ _ $ - Receipts: Events 53,000 54,368 1,368 Telephone Fees - Events - 330 330 Parking Fees - - - Storage 18,000 10,853 (7,147) RV / Camping 10,000 2,371 (7,629) Horse Stall Rental - 690 690 Concession % - Food 21,000 19,927 (1,073) Vending Machines 1,000 - (1,000) Interfund Contract - 10,000 10,000 Rights (Signage, etc.) 1,000 1,000 Miscellaneous 417 92 (325) Interest 667 1,376 709 Total Receipts 104,084 101,007 (3,077) Transfer In: Transfer from Annual County Fair 235,000 234,000 (1,000) Total Transfers 235,000 234,000 (1,000) TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 339,084 335,007 (4,077) 74,326 65,870 8,456 75,181 69,950 5,231 45,000 - 45,000 125,000 234,000 (109,000) 319,507 369,820 (50,313) 19,577 (34,813) (54,390) Deschutes County Fair and Expo Center Accounts Receivable October 31, 2007 Current Month Sarah Fisher 515 T-Mobile 154 4-H 300 Food & Beverage - estimate 13,000 Total Current Month 13,969 Prior Months: September 2006 OHSET Training 365 October 2006 Angus Banquet 125 April, 2006 NW Expo & Trade show 2,015 Total Prior Months 2,505 Total Accrued Revenue as of October 31, 2007 16,474 ~e Cn H U w 0 w' CL ry w 2 F- 0 0 C N Y Q n ~ O C ~ N D Z U Z) (LL N Z 70 0 w L) O O Q' to I- Q U) Z 0 U w' w Z w U O CL X w C LL tD i i c r M mAgo -MANN MGM j* -0N et Nco et NI- COr- O N M0e-MNN e- 0000OIA CO0•--DOIn e-OMNNOO t0 N01 N O CN CON"tC 't CflMCOLO0 ti O t 0 ~ co r N N CO r NCONN Cr, ~t d co" V O I N O V 0 C 000 Lnn N N O O (A N N d• d' ~ N -0 U O N CM It 41 O r d' LO N N M r Mj, ~ O N IT N M 00 R' N N 00 r- O N M LO C`M I` N T- 0000OLO C 0)~-000A ~0MNN0 O w a N c CO C\~( V O M Cfl Ifs d 1-7 ti O N O 'I 00 V' N~ N t0 - c- M N CO N N W I-t tt M ~ I-i M `ct ~ O ~ V CO N M M c M ct r O N to Ncn00 V Nl- d c LO NCnLO~ n[) - CN 1- 00000 to 0OCD co 't ~ 0MNNCD O V N 0 c CDc" C d i(dCCOIACO r- ti 0N N r- N r- d tM m It 0 (N CO N It N T- t0 I-z 'I C U) fn O U Cu U C to c T) 0 0 ce) a) -0 C C O d ui LL V U) -0 w a) O O V C) O ` d a' Oa N co to m Cc :a -w j c F- ~ d CC 0 CL ~ N ~ a~i to 0) > Q) v u) L- v, rn a O (U O N y tSf i~~ 0) = 'C O U (n ca Cn C= am; OUag N ~<C OYv U i °a u c m" 0 rn m O to o a m U O mQa 0 0 CLM ~0 m> >F- <iD Z U rn L 3 C d Q X w r O H W 0 M t0 M M O M IA M tey to O N M d Z C Cl) U) U O N C O O 0 C c O O N x X (ll O N co U c a) O O ~ O N 00 N (B 69 O Y U 0 L 00 04 > ~ J O 04 a) U) tt j, M (0 (0 C O O (a o Q O CU L Cl. ' C), U c U') o N C13 00 O O a a) 0064 O ~ a w 0 N .rO N N 0 C LL ~ C t - co O N LL ` N O O U O to - = N LL = ` u, c a) to - c. m c c`a:c~ o a) c 0 0) o 0 +L-U y C N - In O C - U O (B O O O O U) p) , O (n v w .O N LO LL N 0 ~ ~ H a 0 O U 'O O 0 0 N r Y Q n > ry 0 Z D LL Z O r~ c U N r ) C M a?Z~ ~0 0 V U 0 W O W U O n x W C ca Q LL ~ ~L-C)NN M-M,t~ M i i N~ co CA N M LO e- N e - CDO~OM ' ~-OMNr~- ' M N CO N " CO CO M' CO O CO O r CO I` N O co v r M C'7 Ch M ACA IT LO NN M~M"Te- M N 00 V) M000N N1l- 00 0) COO.--oc!L NMLO CN r-OMNf- e - ' M ~Q)Nco NCON~CD ~COChC00) CO N~Nf~ r-M N M t00 M M M M M ~ ~ 00 O CA NMOOM M M o0 O N ' ' ' ' ' CV r` r 47 O O N r C NI ti M M M c6 ~a U N r" tt "t O N M oO M -'I LO N N , Cl) M V M 00 O N N f - 00 e- O) CD C l M L N M LO - CN O M N P,-: I M - O 00 O O N r N CO N .T CO O CO ti . ' rt CO M co O co N- N 1~ r r M N O co M M C7 C1 M co co ilM NM010 M ~CON N I` -t CO Lo cn -CO N CO LO N M OO O N CO O) O o0 d' O M N P- ' r O O CA N co e N CO N -t O) r CO co I- ~ O M' CO m CO N N ~ r CO N co COO M M C'7 C7 M O U U C c0 7 N N O O N ~ C C N 7 cn L- V W Q) O O V U 't-- y O ~ d O a LU ca cu a) ~J d V (n N O f0 O 7 CU U > in " cA N CL 0 N O 0) N cv o U) cm -t-- O C2. 73 cc c: < CD CL ad OUag Q V U otS 4- 0 O m CL 9) - " CD Qm c`ccc> I- C L co < CL F-O v) w Z V U d 7 c d Q x W c0 F0- w 0 M CO O M i CO CA M CA M r O t0 O M V Z C ~ Y y co a N > Y U O O cn O C N O U O cu 4) (0 m C x (1) > to O U N O N O (0 CL) O L °0 ~ o O M O N M LO N N ~ N O N j cu U O C L U U N L O d cu m O It - 'IT U E 00 0 O O (0 N Q) p LLJ C LL 06 .0)'5- U) M-: 0 0 0 O LL a) ~ « w+ N O O m O N LL W M C C O C C L cu ' U cu > CU ~O O 0 CD CL= 0 j 2 L N 0 0 c9 a°i N cj ` 3 > ff U N p N 69 LL Nr CD c~9 LL CD c Efl 3 ca L U O 0) 0 0 r ti 0 0 N co r r U) Y Z ca d W ~ c ~ O o O N 0 ~ Z ~ c Q o U L o0O Z o X w~Q -0 m cu ca U Z W M M M ~ r. i i V- V- am ~ M ti O V- ' N O O C 00 M t0 N T CO ~ to 0) N N 1lf iii 110 r tiM I* NM co co r O N r ~ W ao M rl Lo 't m CD LO 0 00 It N ~ N ~t! " I C", I I I I IM a) . 7-0 C N 0 Q. Of ao o) ' m - o U U Q ` N U (Q L- c Y O W C/) m U QI U Q) U c m SU S O y dO N U C N (Q ' O G V d L v 06 C) N 0 U) Q ac Q Ch c a~i v a °d a 4) > T U p o cm: as O C Y L) N = v> > W R (13 c O O d a _ ~ 0 0 w U Q F - a F - C ~ N E°o CN O O M N L ~ O QO >1 C 7 O to 7 L U to O L L tf j O Z~ j O Q 0 U U) C 0 W 1 l 1 1 I I ! ' II (a / I I I ~ II ! I I I I I I I I I I I ' I I Z O C - LL O N I`OU7'N CO r-.- CO O t M ~ 10 I ~ I O co M I V 00 I ~ OMO(s rl.10p l CO O N ~ COO~CO10 CO~' v o A I o'~ N IO O 0 I iNMO ~ A I O O ~ O 1 F- U a) OIL L1 I 0 w 'CIO C7't6t0 M f` CO I _ : IM M' O p ~ (n a jC* O ~ N co d O N I to M CO t A N O ~ ,III r I I I I i I I~cq ~i I r I I I I ! I, Of rn I I d W I 4? N O m I r I !04 CD CO ~II,~''~'~ d d IIO I o O I ! I -r- I 1 I I I 1 o 1 N tl w 0 7 LIn O''(A O to a m ; 0 1 00'iM -I N j to o I N O' r I ~ e- OI i I ~ I I I I I I O m ~ ~ v L I a'I I II EI 0 f-- O'OIU')I N I to co MIOIln10 CO!M 1n 100 OI00 OIr'I~ O tiCO d LOI OIN O O ~!O r LO O p co 0-- ~I CII Old '',~i' 00-0 N CO! O!d' co co ;t a): N:tM'O to p O; O ~ "i 10 O Cif U") O O LO IO O!M M r-: Lo ti O O O O M ti 00 OOM co M V N O O O LO p 71 OI 00!M N tt f O r I N'' O N co to CO U! O I II L r ~ I I r I N I CO M: C' N J U) Q ~C) P t OMO ~aNO Di O O LO O - to - O II ~ 0) C U O o , 0) M to 1 COI '0)1 I OI ~I ICO Cl 4 .`I, 0 C cu E O ch ~ !n t0 r to 0) Q a E r O tO % = E C I ' 7 U O I I I ° W U O' N!! I I I II I I ' I I I ~I I OI I L I ~ I~ N!O 'OI U7 le I M M' I tf)101'CO IIOI~; tA co IV; o L - - O O p O ~I 1 ;COO _ co MltblO ~iM tO l~!00 00 1 N!Cfl O'.cf COitOI~f NI 1 N p O ~'M'~ r fni ti N > C V'O to I U) O tt! p O d IChI!MI1--C'jIIr,I IO) 01 CO O I C (Y) 00 )100 M r r CO CO I N LO M ti l O E 00 O[ C" CU O O co O N I 01 ( O N 'I O N M t0 N M N 1~ ~ I a) x W ~ , OIL W LLI ~I69 I I -0 'ICIN Ci C6 ' tQ I I II , I I I I I I I I N w. o I I I I I I I I I I I I , O ~ I I I O 10 ~ I `O I I I I ' ! I O, 'O ' N 7 N I N III I C n I I m O I U) N O ' N " I O I ) U ''I I~- Cc ml tn' ~ U C 06 Q) J LL LL Cll O CU U) c,:, sI av `i mI aD E X m I I U I ' I C ItLIIt_Iz E C! - W d y VI' O O'! W'!~-' ' ~ ' cu O C N N . 0 v-I a rn ! fn .0, E : I 3 c ` O M N U = M N 06 a~~0 c O)~LL E °i cn I o l N j d ° E O L1 0 D ° ~II~! I' CD c. ° to LI W~ OI C ~ m od cl CV) p_ i C'; ° ! I o cu w1 cal' j 70 0) O N ° L ~ 06! N~ i f01 cm I I 3 O I W t1 c O a~ U O E> L.L `r to W tQ (n c t~ t_ L N c y '~I C L CL 0) 1 Ic 3 °;U~UI_c,;x l L Q) a L,L m CH ~ J L O cl 01+- N MQUIW U CLL CL M Q p Q Oj N l W 0 O I N N n . x~ m p . r+ U V IZIf'F- W ~ * ;zI Cc U cif O 0 Z W N > O (n > > O~ 7 0 N O U c+) O Q ~ L L O O C6 ZA 3: O w cn O CS U C C (a 0) N~O ~ to 1M'00 O ~~~t co OIM O AIM M O '1 lA <t In ! -i001co1(m 'T 0'co1 001 C0 M LO 1 ~II Q (a N ~C 010 _I OOHC)DCOOIO~COM- OO NCO d_I M L1CO I~I~ to MMO;NtOI~COiMMM~ CO 0000 I~ ~'CO N~,- CA I~OiO O CO tP M M 10 ~f O a) C ~10 O(O(n CCf O O O Of O M O~M'~ r MI<<j,.- COCO,t~N(bCO NCA B ~ ~OCOtO:O,Vj N MIM hf~ : rt, I f- > '(D ~O OOO i O) D ; 10 O N 1 ND O N I N MCD MI ;M Ifs IN ~ I < X W ' i N C . M IM' I N IM ~ I~ i I I I t I 1 1 'I I 1 I ~ I I I ~I I i I p O I I O i I 1 I I ~~10 CD! O,.O fA:d'' NMI 0 r- CO D! r- M M I~ HIV' 00 IO ~ ~ICO'I~ItO ~ ! Cl) I 0 A1 O O O N I F. ) I ~ M M tO M !ItC) ~ I ~ O CO ;tn a-I IN I(01 -1 - CO Ol~lpll~,plp~ O~COI I, ce) <0 CO lO ! 0) I M ' 0 0 CO CO ' CO O ;M I 101 , V I 1C) d' I V LPL co 00 O i . 0 ~ N M M I r N CONI r- NON N' N M c 'j N 0 ~ I 1 ~ n C O_ C 0 0 L6 N C6 ti III CD i1~',. O co ~I ! a0 OI co I O O I 'IO~ N N~-CA O 'ln 'q- CD CO ~ IS O M CO ',O IC'AI 'O O n p' ' ~O 0 1 ' ' ''.CO I 0 ' O O C6 O 10 . . M INCO'0.. ~ CO ~1 NI IN.01Cn 7 iO N COQ 0 0' : ' ~V Lf~ . ~ 'I 0 n V '.p N 0i- O M N M r-::" ciI '.N N 0 CO CO IN.1~ CO I N r N CO -q N O 'N O 00 0 LL O " co . W N 0 I 00 00 I- 1 Of I co 00 0 0 I'- IO O O n (10 L0! 1 CO O' O M 1 CO e- O 10 CO N 'O 0) N } c l): ''I NIO M IN CO O I It In COIN N COI 'di M tl- C LL I N. ;r CO r CEO 000 O n I - 0 T ' V-1 j O p c) 0 N ~ v- 1 ' co Lr) N ~ 1 M 'O I M 00. IN N ! r IM I i II 11 IN, N 'q' l1) LO O O O N NII I co 10 CO . ! p I- I .O CO0: O ~ x`00 O 1 O Co M of co 0 C 0 A ' h 0 CO } , 1 CIO ti _ i CnN1 N CO I~'.~i~ : U O jC) CA IOD 'N x 00 CA CO 1 ''I I I N co M _ . I'. N et _ I I 04 ' 11 d' d r I M O CO 1 I 00 I 4) 0 I A } 0 CU i(O U) 1 ' ' l1 CD t0 1 ' C A N CO 0 I ! r- O O w.. 7 I O 1 I a) ! to to Q I U), a) ~ C L I p I m. C to C > d I O). I I O CI Cn >'1 V I Ca ! U O C N~ p.IW !Q L 8I I Eli ~ QI N1 COI 7' (6 f6 1 1 i C! L -D' 1 (O Cn LL p C a) E > 3 0 - " d C, C OI> Or 01 0&1 U) a O_ CI O O, O.' j a) (m I I 7 d I CI 3 ° ' N C ' 0) N C 00 ` + Z I U) I , I- IO COI U) O' I 3 1 10 O ~ 2 a) I i N 1 01 ' b oa, I Cd 'O C L C. U I (D Cn (n I c a) L to O I U) Q N 1 U (V U' 1 7 7 C O E (O °a1 I O-I CO 7 i CD I N to a) U c O o a 7~;' R ~ 1 ` 0! 5 1 O 'D a) U a) a) Z W °d a,~ 01 ~I E, LL c,~ H c ° m CL , m c ° 0)" m`IIw' m1 (o c'' CL co ° a) U) 0 (6 4) C 1 , I : (n 1 o f9' cn 01 U) a ) ° w ° c0 c a) a CO: a) a) c ~I 01O O LL c a) 1 (61 ` 0 L j 'N1 O 1 N ~N (O = ~ O C`1 c I co , ~ ( O 1 ` O C F- 1 N to 7 0j O (O 1 N ~ ~ L . 1' > O~F 1 aW ~1- c 3 g cI E1 .a) L QI c1U c~-I °I AIL °I c1 °'I ` °l v R O Q' C : X W I 1.!-i O a), O fO!.~I C a) f0 Q):. 0'I 71 a)I O .alY V. Li y C OL_ ~1 to O,~i a D `L U) 10 U', CL Q ;tn!~'~ S'Y',~ _1cn1p O:~ R' Y' LL LL UI ~ N C ' I I 1-: H U I m W C O E 0- 0 N N 0 ca a) Q O Z C 7 O U t U 0 ti O O N r M N O U 0 co C N E E E O oU c CU o (D • U U) N E U C W 0 O Y Nl0OI 00ii 'coI' CD Il C I , i ~ ca E U r r O Im Gf fa O 7 E m t- C O U W I iL 'O co co m OO I - - - <D O N a - O;O'M; ' N d ~ CU C I0)i ONO M COoIN E 0 o co C)! O O O co I O O r O - to C N Y 0 0 OI N O N m c: 7 O O N ~'O, LO CN co 't ONO O O O U EE Q r C U W i Y c N I I E c o i IM ! L :r o ~Iw c cal N cll OI c i o' E.g UII QI O p N 0 O C ? O', O' L, 7 L - /o Q'Q U' /O\ i'0^ U V/ 'i O Y o l o o U o U O , ^ A alm c °)'m Y 0 0! (a IIC chi CI a) cal a.0 > 1 0 D 0, YIQ ! F- r O O N M 0- O U E c cn a) O N L L U C MO O O U C '0 CD C, 0 0 O O 0 0 O O O CD Ql) ~ ~ LO l 11 O N ~ co U- M N ~ m -1 N1 N N 000 O O o O O O O O l c O O ~ 0 LO ~ l I O h V) N ti co Lo m N - m -1 N1 N N N .D U 7 C ~ d C a in d CD 'a N j O dLLJa ~ Q: : N N LO C7 'ct ~ I~i L to N M C NF I- r~ l o o M_ O M Cl) co r- P' 06 llq- N M N N N d w W d C a 'p x a) Lu c LU c 0 L N O M 3 O N N d Z N N C L (D .Q O cV U C O~ N ~ N Efl y N O) L C O C ~ U O U to ,N O c a O •N U 00 ~O w N N } .D LL C M L W O O Cn L N C c N C "C O U O L -C U O L M ) L m C N cn O U O C Co p ) Q) CD Y fl. N m O NL~. CLn m p U m c N m c o C O =3 Q C . C O CL (D O > > N ui > p Q O y N V E M CL U O M C O 4) O O h c6 w m E U L N 69 L C U L O O " D - N U Cf) 3 W . U O N M et r tC IM mI- NMN .--CD ~COMCp f~MM O 00 N M ~ N IV C c r r p N C14 M r r. N LO 0) 00 to M r 00 E O O N CO O O O U U ~ (D OO o CU U t C) E - O ~ w L C U) f~ I~ M N CO M M M~Nr-. LAM O CO N M M r- N r r ICT M ~ ~ O U') I LO Co C CD C> O r-- CONCD wM N M I r- r t0 M U') 00 1- co r 1~ -t c- M r r N r rn O Y_ 0 C N Q X N V V) CU ti C U O f0 CL X Cn O io U L p j . . O a) o z rn t_n U CU ms a N E ° ' o o c as d m Y _ N U N N O CL K V C = c W O C j o aD vr-.. ~a a mQQU aQaO 0 m U U O co c m E a O C m C7 C 7 LL N C m a x W w a~ c > 7 N U ~ CO v .m. N 7 ~ } N LL (D C 0 m 0) C C N t= cc m c O Ul W C E m d w c 0 U .m-. ~p C14 O !COI co I0) n~ n aDj I O to C M NI ~O) M 'O N fp NI W n M OIU) O O) im N O IGD M C b ! i0 MICD, O b O MI O N 0 n 0 C) O n~ O I I IN r Ir 1 11.7 NI O ' O I O r N H I I O a C 7 I I I ! I I I ! I li I I ! 0 O I _ I ~ I I I I I CL C I I I ; I I I I I f- I I I~ I I O a Q I I I I I I I, ~ ' v co ! I I ; I I I I m ` I I li I m m - m I ! I I I ' I I I I I - I I I I I I m I ~ , Q : c i O F - O cu i U m I 4/ ! I I I t0 m. > Z I ~ I I II I ~ min ~ atS •c - I I I ~ U ~nlo,u~ nI n IO.M CO 10 '.M N M 1!Y N !n M I,O Ic) Ico O t0 1 0!~ !MIN O'. ICONIM Cl), IF.CI i!MI r + I MIN Irl M'I ~ ,MI co ,t H L c ED O m r 'I I ! r C-41 I r ~p c 0 M C! n 0) I C! ! O O r_ - ''I M M' W y N d 0 co I w r ! I m m , C N ' ' I ' L I - w I E v m Lf) Lc) cc) In NNO ;M. N N N 0 Of I ~ ~ 101 COIN N o O M 0 ' t - I OOI N I OM D 7 Cnd Q I 1 I N cN C r ^I vl y I I I I ' I I I I I I I ! I U m c - - U U O I m c cI co rnl I _ ' C C m I I cI I I ! CI e I I OI I I c I - , c E ! i _ I ' •C ' M e CC ! ' n O w O) a -I I 4) ~I E . I cI - ! EI T C C Ici I - c L_ I IcE LI EI alb E I EI IM ' F y ) m m 0 w I C N I p -01 1 7 7 y- L II ~ C 1 O \ y N~ . L7 ~ y ~ I m y I' y N~ I ~ 7 C O 7 c O Q 71 C 7 O O 0 •0 W O m NC I C W O y W p a H U W O I, .a N O W m ;r m ICJ m 1 00 N m E c m mLv -m m CIE O) OI ~H m l m C I?~ °tsll al m v E m O m EI ~J- G c 1 y y Cx E mlv IE w,ts _m ym cO; v m m e:7 m p/DIVI O IU °D!f0 'fl ImI O m E m o J I ;m Y I l 'm o N O m m m!MiE- Imp ~ I(A- E' m; O) . C I>,mM E'' m~ f4 m tm- E:' I o IA i ~ I, El F- U E f M14- , I m2 E ;m m m2'E IO mlM E H ' 00 J N:- lip I I~ m •p i~ IO 3 E ` ' g ' '4 E En= m L m D"w m l E:c > QQ m m7:o E o EII- U h- QIQ~~ C7 ~ li m Ic c> QQIm m Im o ~ic~ t m;o ~II J9 U F- Q Q O y'.`i : I c . . m m . C . .ci Id OCR m EIL I pJ o > Q m 7 0. > q m 3 o N 7 0! ~ o ~°'I~ ~I° I- `m 0401 c'~IF- o l~! CIO HI I} 1 Lo U ~ o F- C m ~ ~ I I I i H Q Q C7 « U~F- Q Q O C U!I-IQ QI~ C7 1LL m 0 I I I o i l o I I I I I ~ I ~ z 4µj ~ a l fi Community Development Department Planning Division Building Safety Division Environmental Health Division 117 NW Lafayette Avenue Bend Oregon 97701-1925 (541)388-6575 FAX(541)385-1764 http://www.co.deschutes.or.us/cdd/ February 14, 2007 Bill Zelenka, Planning Director Crook County Community Development Planning Department 300 NE Td Street Prineville, OR 97754 RE: 3rd Deschutes County letter regarding types of traffic mitigation, timing of improvements, and cost shares for Hidden Canyon destination resort (File C-CU-DES-03-06) Deschutes County appreciates the calculations provided today by the applicant's traffic analyst regarding mitigations for the Powell Butte Highway/Neff-Alfalfa Market Road and Powell Butte Highway/Butler Market Road intersections. Deschutes County staff has agreed that Powell Butte Highway/Butler Market intersection will not be an all-way stop, but Deschutes County would agree in concept to a roundabout. Today Kittleson & Associates (KAI) has provided Deschutes County with a cost estimate of $1.5 million in 2007 dollars for each roundabout for a total of $3 million. KAI based the applicant's proportionate share on the applicant's proportionate share of the traffic. Specifically, at Powell Butte/Neff-Alfalfa Market the applicant's share would be $278,680 as they have 18.6% of the traffic. For Powell Butte/Butler Market, the applicant's share would be $36,247 based on having 2.42% of the traffic. Deschutes County agrees with these figures and requests Crook County as a condition of approval require the applicant enter into a Memorandum of Understanding (MOU) to pay these amounts. The amounts would be tied to thresholds as the Hidden Canyon Resort develops. For Powell Butte Highway/Neff-Alfalfa Market the mitigation is needed with the occupancy permit of the 257th unit. For Powell Butte Highway/Butler Market the mitigation is needed with the occupancy permit of the 1,102 unit. Please enter this transmittal into the public record and provide me with copies of any staff reports, findings, decisions, or public hearing dates. If you have any questions, please feel free to contact me at (541) 383-6718. Thank you. Peter Russell Senior Transportation Planner cc: Tom Blust George Kolb Catherine Morrow Quality Services Performed with Pride REVIEWED LEGAL COUNSEL MEMORANDUM OF UNDERSTANDING THIS AGREEMENT is made and entered into by and between Deschutes County, a political subdivision of the State of Oregon, acting by and through its elected officials and RMG Development, Inc., an Oregon corporation, acting by and through its senior officers, hereinafter referred to as "RMG"; referred to hereafter collectively as the "Parties." A. RECITALS Pursuant to Crook County File No. C-CU-DES-003-06 (the "Resort Decision"), in which Crook County approved RMG's Development Plan for the Hidden Canyon destination resort (the "Resort"), RMG must contribute to the cost of the construction of certain improvements to the Powell Butte Highway/Alfalfa Market Road-Neff Road Intersection and the Powell Butte Highway/Butler Market Road Intersection (the "Intersection Improvements"). 2. Condition No. 32 of the Resort Decision requires the Parties to enter into a memorandum of understanding to ensure that RMG timely contributes its proportional share to the cost of the Intersection Improvements. 3. Deschutes County and RMG wish to execute this memorandum of understanding to govern RMG's obligations to contribute towards the costs of the Intersection Improvements. 4. This MOU is a binding agreement between the Parties. NOW, THEREFORE, the premises being in general as stated in the foregoing recitals, it is agreed by and between the Parties hereto as follows: B. TERMS OF AGREEMENT: Intersection Improvements. Deschutes County and RMG agree that the Intersection Improvements are required to maintain safety and functionality of the affected intersections and to comply with the conditions of the Resort Decision. The Intersection Improvements required by Condition 32 of the Resort Decision are governed by this Agreement as follows: Page 1 of 5 - MOU BETWEEN RMG AND DESCHUTES COUNTY FOR POWELL BUTTE HWY IMPROVEMENTS Deschutes County Document No. 2007-580 a. Powell Butte/Neff-Alfalfa Market. Pursuant to Condition 32 of the Resort Decision and the February 14, 2007 letter from Peter Russell, Senior Transportation Planner with Deschutes County to Bill Zelenka, Planning Director, Crook County Community Development, RMG shall contribute to the cost of the Intersection Improvements at the Powell Butte/Neff-Alfalfa Market intersection pursuant to the following terms: (i) RMG's contribution to the Intersection Improvements at the Powell Butte/Neff-Alfalfa Market intersection shall be Two Hundred Seventy Eight Thousand Six Hundred and Eighty Dollars and no/100 ($278,680.00), in 2007 dollars; and (ii) RMG shall pay its contribution by depositing cash with Deschutes County no later than the date upon which Crook County issues a certificate of occupancy for the 257th dwelling unit in the Resort. (iii) The County shall credit RMG's deposit to the County Road Department fund designated for road improvements. (iv) Upon recordation of each plat in the Resort, RMG shall provide the County with progress reports identifying the then current number of dwelling units in the Resort. (v) RMG's proportionate share set forth above was calculated as follows: (Hidden Canyon Added Trips) / (Total Trips in Year 2026) * (Total Improvement Cost). RMG's proportionate share calculations were reviewed and approved by the County pursuant to the terms and conditions of the letter from Peter Russell, Senior Transportation Planner with Deschutes County to Bill Zelenka, Planning Director, Crook County Community Development attached hereto as Exhibit A and incorporated by reference herein. b. Powell Butte/Butler Market. Pursuant to Condition 32 of the Resort Decision and the February 14, 2007 letter from Peter Russell, Senior Transportation Planner with Deschutes County to Bill Zelenka, Planning Director, Crook County Community Development, RMG shall contribute to the cost of the Intersection Improvements at the Powell Butte/Butler Market intersection pursuant to the following terms: (i) RMG's contribution to the Intersection Improvements at the Powell Butte/Butler Market intersection shall be Thirty Six Thousand Two Hundred and Forty Seven and no/100 Dollars ($36,247.00), in 2007 dollars; and (ii) RMG shall pay its contribution by depositing cash with Deschutes County no later than the date upon which Crook County issues a certificate of occupancy for the 1,102nd dwelling unit in the Resort. Page 2 of 5 - MOU BETWEEN RMG AND DESCHUTES COUNTY FOR POWELL BUTTE HWY IMPROVEMENTS Deschutes County Document No. 2007-580 (iii) The County shall credit that amount to the County Road Department fund designated for road improvements. Upon recordation of each plat in the Resort RMG shall provide the County with progress reports identifying the then current number of dwelling units in the Resort. (iv) RMG's proportionate share set forth above was calculated as follows: (Hidden Canyon Added Trips) / (Total Trips in Year 2026) * (Total Improvement Cost). RMG's proportionate share calculations were reviewed and approved by the County pursuant to the terms and conditions of the letter from Peter Russell, Senior Transportation Planner with Deschutes County to Bill Zelenka, Planning Director, Crook County Community Development attached hereto as Exhibit A. c. Interest. The County shall retain the interest, if any, earned on the case deposited with the County to defray any costs due to inflation. d. No Obligation. The County's acceptance of the funds described in subsections (a) and (b) above does not obligate the County to construct the identified improvements. C. GENERAL PROVISIONS 1. No Third Party Beneficiaries. a. County and RMG are the only parties to this MOU and are the only parties entitled to enforce its terms. b. Nothing in this MOU gives or provides any benefit or right, whether directly, indirectly, or otherwise, to third persons unless such third persons are individually identified by name in this MOU and expressly described as intended beneficiaries of the MOU. 2. Successors in Interest. The provisions of this MOU shall be binding upon and inure to the benefit of the Parties and their successors and approved assigns, if any. 3. RMG Not an Agent of County. a. It is agreed by and between the parties that RMG is not carrying out a function on behalf of County, and County does not have the right of direction or control of the manner in which RMG delivers services under this MOU or exercise any control over the activities of RMG. b. RMG is not an officer, employee or agent of County as those terms are used in ORS 30.265. Page 3 of 5 - MOU BETWEEN RMG AND DESCHUTES COUNTY FOR POWELL BUTTE HWY IMPROVEMENTS Deschutes County Document No. 2007-580 c. RMG covenants for itself and its successors in intereset and assigns that it will not claim or assert that RMG is an officer, employee or agent of the County, as those terms are used in ORS 30.265. 4. Partnership. County is not, by virtue of this contract, a partner or joint venturer with RMG in connection with activities carried out under this contract, and shall have no obligation with respect to RMG's debts or any other liabilities of each and every nature. 5. Governing Law. This MOU shall be governed by and construed in accordance with the laws of the State of Oregon without regard to principles of conflicts of law. a. Any claim, action, suit or proceeding (collectively, "Claim") between County and RMG that arises from or relates to this MOU shall be brought and conducted solely and exclusively within the Circuit Court of Deschutes County for the State of Oregon; provided, however, if a Claim shall be brought in federal forum, then it shall be brought and conducted solely and exclusively within the United States Distrist Court for the District of Oregon. b. RMG, BY EXECUTION OF THIS CONTRACT, HEREBY CONSENTS TO THE IN PERSONAM JURISDICTION OF SAID COURTS. The parties agree that the UN Convention on International Sales of Goods shall not apply. 6. Severability. If any term or provisions of this MOU is declared by a court of competent jurisdiction to be illegal or in conflict with any law, the validity of the remaining terms and provisions shall not be affected, and the rights and obligations of the parties shall be construed and enforced as if this MOU did not contain the particular term or provision held invalid. 7. Attorney Fees. In the event an action, lawsuit or proceeding, including appeal therefrom, is brought for failure to observe any of the terms of this contract, each party shall be responsible for their own attorney fees, expenses, costs and disbursements for said action, lawsuit, proceeding or appeal. 8. Entire Agreement. This Agreement and attached exhibits constitute the entire agreement between the Parties on the subject matter hereof. There are no understandings, agreements, or representations, oral or written, not specified herein regarding this Agreement. No waiver, consent, modification, or change of terms of this Agreement shall bind either party unless in writing and signed by both Parties and all necessary approvals have been obtained. Such waiver, consent, modification, or change, if made, shall be effective only in the specific instance and for the specific purpose given. The failure of State to enforce any provision of this Agreement shall not constitute a waiver by State of that or any other provision. IN WITNESS WHEREOF, the Parties hereto have set their hands and affixed their seals as of the day and year hereinafter written. Page 4 of 5 - MOU BETWEEN RMG AND DESCHUTES COUNTY FOR POWELL BUTTE HWY IMPROVEMENTS Deschutes County Document No. 2007-580 Dated this of , 2007 BOARD OF COUNTY COMMISSIONERS MICHAEL M. DALY, CHAIR ATTEST: Recording Secretary DENNIS R. LUKE, VICE CHAIR TAMMY BANEY, COMMISSIONER Return Document to: Deschutes County Community Development Department 117 NW Lafayette Avenue Bend, Oregon 97701 Attn: Mr. Peter Russell With a copy to: Crook County Community Development Department Planning Department 300 NE 3rd Street Prineville, Oregon 97754 Attn: Mr. Bill Zelenka RMG, INC. By Its Date Page 5 of 5 - MOU BETWEEN RMG AND DESCHUTES COUNTY FOR POWELL BUTTE HWY IMPROVEMENTS Deschutes County Document No. 2007-580