Loading...
2005-176-Minutes for Meeting January 26,2005 Recorded 3/16/2005COUNTY OFFICIAL TES NANCYUBLANKENSHIP, COUNTY CLERKDS Ind COMMISSIONERS' JOURNAL 0311612005 10;33;44 AM 11ill[II2 i7 DESCHUTES COUNTY CLERK CERTIFICATE PAGE - r r. This page must be included if document is re-recorded. Do Not remove from original document. Deschutes County Board of Commissioners 1300 NW Wall St., Bend, OR 97701-1960 (541) 388-6570 - Fax (541) 385-3202 - www.deschutes.org MINUTES OF DEPARTMENT UPDATE — FINANCE/TAX DEPARTMENT DESCHUTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, JANUARY 26, 2005 Commissioners' Conference Room - Administration Building - 1300 NW Wall St.., Bend Present were Commissioners Michael M. Daly, Tom De Wolf and Dennis R. Luke. Also present were Mike Maier, County Administrator; and Marty Wynne, Director of Finance. No representatives of the media or other citizens were present. The meeting began at 9 a.m.; copies of the agenda and other documents are attached for reference. The group reviewed the Department's monthly financial and investment reports. They also discussed the proposed Fiscal Year 2004-05 supplemental budget, and reviewed in detail the remodeling projects fund. Mr. Wynne also explained the need for the purchase of computers for his Department. Mr. Wynne provided an overview of the PERS/OPSRP funds, and composite versus separate rates. He also updated the Commissioners on the financial policies used by the Sunriver Service District. After discussing the Health Benefits Trust Fund, the Board took action as follows. LUKE: Move that $400,000 be transferred from the Health Benefits Trust Fund to the Insurance Reserve Fund. DEWOLF: Second. Minutes of Department Update — Tax/Finance Department Wednesday, January 26, 2005 Page 1 of 2 Pages VOTE: LUKE: Yes. DALY: Yes. DEWOLF: Chair votes yes. The Commissioners also approved the transfer of $26,000 to cover the cost of computers for the Finance Department. Being no further items addressed, the meeting adjourned at 9:45 a.m. DATED this 26th Day of January 2005 for the Deschutes County Board of Commissioners. /ATTEST: Recording Secretary Tom DeWolf, Chair Vw. Daly, ommissioner Dennis R. Luke, Commissioner Minutes of Department Update — Tax/Finance Department Wednesday, January 26, 2005 Page 2 of 2 Pages Board of Commissioners' Monthly Meeting Finance Director/Treasurer AGENDA January 26, 2005 (1) Monthly Financial Reports (2) Monthly Investment Report (3) Supplemental Budget (4) Finance Department Computer Purchases (5) Sunriver Service District Financial Policies (6) PERS/OPSRP — Composite vs. Separate Rates MEMORANDUM To: See Distribution From: Teri Maerki RE: Remodel Projects Fund Date: January 12, 2005 Here is the statement for Fund 452 - Remodel Projects Fund from inception through December 31, 2004. This statement is complete for the actual transactions that have occurred through December 31, 2004 and the encumbrances, commitments and contracts known as of December 31, 2004. On the November 30, 2004 report, "available" resources were shown as $(211,732). As of December 31, 2004, the "available" resources have decreased by $3,032. Following is a reconciliation: Available Resources as of November 30, 2004 $ (211,732) Expenditures not previously identified as encumbrances, commitments or contracts: Interest Earnings -All Projects (4,018) Steele Associates/Architect Fees -Road 302 Carlson Testing Services -Justice Center 3,268 Denfeld Paints-CCF/UN/FRC/Risk 240 HHD Electrical -Road 3,240 Total additional expenditures 3,032 Available Resources as of December 31, 2004 $ 214,764 Distribution: Mike Daly Tom De Wolf Dennis Luke Mike Maier Mark Pilliod Susan Ross N V V to 7 V v a C C Oy L L d CL Ny W O m O RAJ Cf -H coCN CO U9 ' 00 U C) M O r- Cl) It � CO M Co r O O Cb r- C O CO r- M r r LO O Il r I- M r a (6 r Cl) U) O 00 (0 Z C N r O M O CL Cl) Cl) O (O 0 CO O (5 CO 00 U O N O LO LO a) p C W 00 N 00 N O M OD O V V V CO r t M co (O M E M M V 1• p Ln CO (O V I� L V r- O 00 M O 00 O M N = p U U ) r O h r r M CL W r O LO (q Cl) V N O O O O CO °` 0) O O O O L �L' d a O O O O w C O .� to O M O M m toVLnV U M M 1` ' V O M 0 0 N M O r O CO O Cl O M M V Q Q (n 00 N 00 N O CO CO CA V V V O r O O 00 M m m O O O O O LOO n r V N V r (O Cl) Cl) OC Lf) (O (O V ti L V (_ O O M M Ma' .O. M Lo O co O f� r r M N 00 O V C V M V N O Cl) M M O CR (0 OO l L U CO O O O i i LL o O C a) +- V M 00 fQ O w O U Ch CC4N E0 .. _.>,. .._..., .. .._...._.m. _,..,. E O 0 E a N O a LO O CO O O O O Cl r 0 CO O O N 00 N O O 00 O O V CN LC) E 0 7 p to 00 O V V V (O (O O O O O (-- CO � r 0 0 a M f� qr M N N V 0) r O m CO � 0 M M 1• UL 64 U7 O CO V M L6 (l U6 U .) U O CD U N h I� r r O N .�J E 1• CLO E N V 0 Z5 O Q L y V D E U a`) a) 0 o Q w U h ca CO O O CO < tG a N O O O n co V O I- N (O N w N m O L O = O- CO L M O O N N N L to -0 U CO)El LO O 00 M r r M r M r M a N r O M C M M O CO N N M cm o o (c CN O M Go N O w N C N V V to 7 V v a C C Oy L L d CL Ny W O m O RAJ Cf -H coCN O� C) M O r- Cl) It � r r O O Cb r- O V m r r LO O Il r N r a (a C N 0) 00 V O M O O N M O r 0 CO O O co 00 O C) N a) p C N 00 N 00 N O M OD O V V V CO r O O O r- CO O (O Q p O O O r 0 V M N M V O r M M CO N O O t- r- V 1• p Ln CO (O V I� L V r- O 00 M O 00 O r V = p U U ) r O h r r M O M O I- N I,- r O LO (q Cl) V N N r CO O N CO °` M M V L �L' d w C O .� to •0 N N (D_ (D rn m a a a Z ' V O M 0 0 N M O r O CO O Cl C) C)' ' O O ' V Q Q (n 00 N 00 N O CO CO CA V V V O r O O 00 M m m O O O O O LOO r V N V r (O Cl) Cl) OC Lf) (O (O V ti L V (_ O O M M Ma' E O f� r r M N 00 O V C V M V N O Cl) 1• (0 OO l L M M M i i LL o C a) O w O .. _.>,. .._..., .. .._...._.m. _,..,. E a N O N 00 LO O CO O O O O Cl r 0 CO O O N 00 N O O 00 O O V M LC) E 0 7 p to 00 O V V V (O (O O O O O (-- CO M le O) 0 0 a M f� qr M N N V 0) r O m CO N (O O Il� I- 1• UL 64 U7 O CO V M L6 (l U6 C M O 00 O M CD n .a) a h I� r r O O M C) I,- Nm 1• w O O C N V N N r co O r E (0 M M V O - O ; U U a`) a) °c m a (D M U CO O O CO CO tG a N O O O n co V O I- N (O N w N m O L O = O- CO L M O O N N N L to -0 U M r r M r M r M +r 0 C• 7 0 T Q m2-' N N N N Lo c)N N U N O w > CD LO CO -0 (o O O_ O C (q CL CO N — O CD N O LO O 00 O O O O O r 0 to O co CO N' ' CO 00 r (0 M d.0 O T XN Ci O O t` N CO N O M 00 M V V V CO CO O 0) O 0) w 1- " N O � V O N N V O) r O M O NN V r V j L L CO CO d' M Lp V ti Ln 06 O ao r to co • j O (o � I- f r r O O O O N M � ' M N V N M 1- r r r N N 7 N a N U a a O V O T M E 0 cn LL U- 0 y EE� O m a C O (D VL T N to L (D ` 7 C,3 M N d N a) N U j U co C L V C r0 U C C t9 m w O E tT C a) N w Z fn fn a) N O O .. i- C m N .O N C y ,0L O V C 0 C �, 00 > 6 O •C y U v� U (n U 0 0 U N 7 y C U E y d D U C) N OD vi Z °) n m a� R E a) L W .� (U d L (0 U d '� t� T N~ U a7 N 01 0) (6 '� E Q) (n 7 7 N A L O) N -j a L r0+ (B (m E C CL 'a 619--a s N � og V co U) (a U y .y a. N 0 O- td T `m Ems_ 0 0 0) m 0 C H o (D cin �°� O cO cV a ommO X m Zo rn co `- > c a) LL) ;g 0 � � c ;a � j �= ami W` �Qm-j �QULLU)0 10 4Hm001- a O O 0 CL L 7 K� U o 4) Qa`aLUF-m W F- Z to a O� J O >+cn0N C j Z _- 0Aa Mc) C)o U riW0 F- . a) E O O U F- o DQ O U cD U a) O M M 0 O OD N 0 h � r �N V" 1 w O 0 LO �I&0 co w O 00 100 0 0I0I 0 �7 cn cn a)E E E U O c 06 I N 0) cn V YR 0 0 o a) 0 d N w M (D O M 0 O 00 0CC) 0(DM O 'a' I- M (D 0 N r ti 0 N O M (C) C) I 00 0000 (DM O 'I I- M (D L6 C �: r- N O M 0 O O � ti M (D 0 N �7 ti 0 T- N O M 0 O r - C) 00 O (D M O d' Il- M (D 0 N � ti 0 N N Iq ti C-0 N O 00 Il O O O O L O ( ti v (D O N N .- 0 0 U le 04 a) M O �7 cn cn a)E E E U O c 06 I N 0) cn V YR 0 0 o a) 0 d N w M (D O M 0 O 00 0CC) 0(DM O 'a' I- M (D 0 N r ti 0 N O M (C) C) I 00 0000 (DM O 'I I- M (D L6 C �: r- N O M 0 O O � ti M (D 0 N �7 ti 0 T- N O M 0 O r - C) 00 O (D M O d' Il- M (D 0 N � ti 0 N 0 Z a) O Q V C a Z a) (A m o c U)o 0 p 0 cad c++ N O 7 �_ 0 Q U 0) O E O a) C 0 T�F-!0 � O O cn O- IC 0 O c a) cn v -Eo O °c V a) �E0-0 o a") 0 mQm sFT)I- F-mUH � U N C m CL x w is 0 F- m Z LO C-0 o�oLO Il O O M M r (D Oe- N v (D O N N le 04 0) CN M 00 0 O d N N OMO'IT r -- LO (n LO O N ' N O O co O co O co to N O N 0 N M 0 0 V- M N O I- 00 0 O q -T N N O co O � PI- N N r N 0 In ' 0 0 0 O O 113 O 114 V co M M N to to rn LO N (N ti ti 00 00 (A 00 O O M M (N N N ('O 0 Z a) O Q V C a Z a) (A m o c U)o 0 p 0 cad c++ N O 7 �_ 0 Q U 0) O E O a) C 0 T�F-!0 � O O cn O- IC 0 O c a) cn v -Eo O °c V a) �E0-0 o a") 0 mQm sFT)I- F-mUH � U N C m CL x w is 0 F- m Z J W � O p >1(o2N M0.6 N W m N Z E O uj U aUi U_ o O f— cn U) Q D O L a 2! I V 0 c) q 0 CD CD O N M O T- C) O L() O tG r LO LO M P� n N N cn N N C U N m E E E a UC W 06 I V O O I V' (D (D O N M I- O r O Ln O CC r M to N N N N l) :3 (.) LL LIJ Uc O 0 L ayi L v0 a ( � Na) CU W0 +- L O wJ cHF- O O mO ' co MOM o ' ' ' ' ' ' ' ' ' � o � ;:, ti OC) V• N LO M V_ CD N CO r LC) M (D I� 0) ti LO I- M U CD O OI] L17 C:) 00 (D(L) 7 cnN rN ti LO C 0) (D N (O�ILO00 1- ((7 V' cr C6 O to CO (a vN N N 0) O ti M O O M r LO I,-rLO LO w N L (D LO M V (D N (D r- LO (D N N 1-- M M CO V I� V N O V O O IV 1-: O O C) M aCDM V'M M M O M r ti m C CD O O N (7) O O M M O (D r LO (0 1` CC) to N M1 -Or r- co 1w w -0 O L() O (6 O O (D Ni CO V' 1- (D CD CO Ln CO N 1l- LO LO :` M U') r I,- r-- U') 1- O a) M U) N M M t` N O N N N N N E cn W O O O O ' O— O N O O M V M N N O O a) O O� Or OI-MMO(D to M M O r O CO O co O M IT CD N 0) LO Cl) co(D ( O Oo -a O O O CO O O O V• 0 'i ( O O M to N Ce) Lor N r N M CNC N M N (D O N N N N N O L a 2! I V 0 c) q 0 CD CD O N M O T- C) O L() O tG r LO LO M P� n N N cn N N C U N m E E E a UC W 06 I V O O I V' (D (D O N M I- O r O Ln O CC r M to N N N N l) :3 (.) LL LIJ Uc O 0 L ayi L v0 a ( � Na) CU W0 +- L O wJ cHF- O O r �CONOaOM� I'- MOM N 0) to .� 1` O 1� CO O O O T- LO O r I- OC) V• N LO M V_ CD N CO r LC) M (D I� M co I- M O O CD r Ln O OI] L17 00 (D(L) 7 cnN rN ~ LO t d � (O�ILO00 U) cn ((7 V' II- � .- r O N O OO M V t- N N N 0) 1 - .-. 0 N N N v U LO rO M r- N r r �.m0 U 06 �+ a) 7 4) (1) (D(L) 7 cnN 0 O t d aa)) (T) Q U) cn ani rn H � .- r O N O OO M V t- O' CA M 0) O ti M O O M r LO M LO Lo N 0) (D LO M V (D N (D r- LO (D N N 1-- M M CO V I� V O O a) 1-: CCT ) LO r M N N 1l- 1l- (7) to N Z C N N L a) C O N N E E O U T C O U O N O m a) .0 T '0 a) O Q Q N N a) N C 7 LL E O v-. O O C O LO N d4 N C O 'O ca C t9 O C a) a) CA C Cl.cc CL 4 0 cn - .-. 0 v U N w �.m0 U 06 �+ a) 7 4) (1) (D(L) 7 cnN 0 O t d aa)) (T) Q U) cn ani rn H coa � �cn �_'U CQLL f- iL �c<co--j UmUI— W N Z C N N L a) C O N N E E O U T C O U O N O m a) .0 T '0 a) O Q Q N N a) N C 7 LL E O v-. O O C O LO N d4 N C O 'O ca C t9 O C a) a) CA C Cl.cc CL 4 0 cn J W In -1. O0 In2N C 5 W - 00 M N n' a +. Q) W E U O W Q) a) (D D m 0 0 co O ¢ w 7 m U Q) O CL N O W UC Q) O E �0 c 06 cm0vo N M (D 00 N O T N O M 00 I` W) rl- co M M O M M O Il- I O � � M M N O M 00 I— &0 M co I 0 O O N OI O O mm M M M ' T- 0 N r - IP) O M 00 I-- (D — In M N 00 I- to IT 00 00 C N Lf M O U') 0) M 00 ' 0 N r Lf) 0 CO 00 I.- (D t- Il') M N 00 I- to � 00 00 d N (6 M LO � 0 (M n 0 M 00 ' , 0 N co I 00 I- (D IAMN Il- I-(OCM `- 00 00 N N M M U-) 0 M M I � M N U � � I(f M N � M 00 00 N N M M O (n N U w Z 0 0 0 v O O N v N N N r 1 1 �¢LL Cm � U (D Q to Ni I -i N (D co co m co M co M 000 000 O In In O I- tiCD 11 M M M 'IT co a CD to (D (D ti IT d It ai M M 00 M M M co co co co LO N LO w co N co co O O N r ai c6 tb ti ch N N M N U w Z 0 O In . - 06N in U In Ina U 0) O N 0 N 0 U .0 d IC O C Q) Iv 2 i cc C Q) r -c-53U) /a oa V roU.Nd _ r� N m t` O Q) Q) O �¢LL Cm � U rn E C Q) G. X W 0 I-- a� 2 J W ❑ v 00 N c � W 0 .— CY) 2 CO N a W U L O W U U E Lu Q) O) N c ❑_ ❑ J O U Q Q LL 4) U c m .` N 7 m T U O) O L a (D N ❑ 0 U ) O CL N "n U c N cu E E E U O �U 04 0) SIU) IT �10 M M N CD I cm N 00 O 00 tO eP cr N N (0 1� r T 0) LI I ISI' Ce) I � ((00 M () LO N o L O M M N LU (11) 0 m ❑ CL N 0LLI c nz W •� w -j E H (O O Q) w Z N m c W C wa O(0 i ' O m m m IT Iq N LO 0) O Ln O O) O M N N r N M O (O ' ' O I- O O (0 t0 M 0) O LO 0 NT 0) N O LO M N N T- N CN M a LOi i ((1 0) ONO LO � 'IT N Cf) N N N (0 O N (' r N O O O f - O 00 O Ln 00 LO O (0 r r r N r O � Ln O N O O "t O O r 0 0 rN0001- 00 O v 00 t0 O r r r N r 0) r qq O O N O O O O r 0 0 T- N 0 0 0 fl - 00 O In 00 L O r r r N r r I I M' O r LO N I, - O LO d' ti r O (O ' ' m r- O O 0 LO N Nr LO [I- N O O M (0 N O m d• ICP N N tt O r� r LO r LO Q) 00 (O O 0) 0) • N Il- O N tO N N N 00 O N O CO N c O L in • a O U U U V7N a) 0 :3d 0 U c c � z cn N U LL U cn 06 U N U 75 a) O) y N .N. N 'D O ❑ U 0) d O N ( M N c O) Q) L (0 LL U ' p_ " O) (D j = CD `mU c�� as mom❑ TLL cu U t=U U) Z OLL LL U N°�m U U cp ❑> ULLOU,1m— �Q-jP s¢U)OLL10- �c ❑Jca+ �m � U N00 00 N ti N t- 00 C7 r r r r r LO N O e- O (0 00 1, c r N M O N O Il- 00 00 O n CO O) N r T r o) ti O 00 CA co T N M co to LO r T T 00 co 00 00 00 00 r r r O M CD (A M %— r_: r_ 00 N O N 00 T T 1 1 1 1 O U C fB (Q m 001 C N N E T7. r O O O T r W E cn N W N co ' co m N N a T r m O O 1 I 1 1 . co co 1 1 N N N co N � O� O1 N O O T T -L r CO � O Ir 1 1 I In a O a C T _O N N N_ , O O T r O .92 m 00 CN co 04 co LO a U T r O aC O O a O 0 T r d C to fn T r (, U ++ 7 Z Q)U .O O N 6i W U 2).5 N N C N >. N r r w rnN co N L f6 Q, "a V U 0 H N ��� U� � U G. 0 M p W 1_ C .� a is x U cn n CD tau E O w )O J Q ¢ m- fo- m m I- mIL .r W p 0 X0 a U m Z E<C) U 0 F- m W o ¢ w ca L Q cn co w C%4 w LO a N C r O a (a O T O r O T � � C d N x U w N _O N N N_ , O O T r O N d U O O T r 1 I 11 I / I 1 I N d U d C to fn a la LM O ++ 7 Q)U N O N N O N 6i W U 2).5 N N C N >. N r r 20) N L f6 Q, "a V U 0 H N ��� U� � U G. O 0 1_ ca- -o �- .� a is x a mi ti Q) o c �' O w p U) ca� ra w ¢ m- fo- m m I- mIL .r W p 0 X0 a U m Z w -j I- W F- Cn I— z w O N N t 0 •o r U M L 0 aza Z Q E O w N U 0 Q o m Q 2 D U z LU N N N C C C () a) a) E N E E a) a) O a) > U > > N am) am) O_ Q Q p EU)EE0 wwwo�IYw 0 >1 L >, aaa) CM a) O,000 0 o 0 o o =a==-3 (D o I CL CO W mmmmmm O O O ' ' M ' O • M CIJ C) 04 LO � r N Iq Cl d ti M66 O 7 C6 O ti O co co N � M Oo a as0aa a c m m 70 0 0 O o 0 0 0 0 0 0 E:3 U _ o am) am) am) am) am) am) am) ami am) IY w0� wwwo�IYw 0 >1 L mmmmm0) mm mm a) 101 �0 D E lo i M N O mm mm mmmmmm 'IT O N' V' O co ' ' M ' O • M L LO � r N M I- r O ti E O 7 C6 O ti (~p 1- It � M' co CD r- V-: 1-: v r r- 1� a) �_ c m m O ov E a� E:3 U _ rn 0 E CCD 0 o N= � c 0 >1 L N LL E N =3 a) 101 �0 D E lo i M N O O O .= co co N I� � C N N N I- O v 0 0 C) I � CD O O O N O O w O w O't O O COLOOCflOOD CD d N O U 0r -co 0 r- � M d � WE E m c co E Y U i �n a1 O U rn 0 C CO0 z 0) y � C 7 Y U ICT Oco IM M -M C O U 0 N C O U 0 c 0 O a � OI-- N OO N I- O N O a0 O (D N O N 0 0 0 0 0 0 0 0 0 0 0 0 000001I- 0 0 0 0 0 0 r a� a) (D Z c m m a) N ov E a� E:3 U N rn 0 IX i50 E o 0 o N= o c 0 >1 L N LL E N =3 a) U U LL �0 D E Cp i M N O LL,>af-00�- z .= vL- N O H O U C N c E O avi aCi w � Q ) a U U U .o o 0 � � o o ate) o •- r- UU oLL E y C C L, \ L U Q F�00 "=t=wo °oma 0 U -0 C X X= w O Uww==i- - 0r -co 0 r- � M d � WE E m c co E Y U i �n a1 O U rn 0 C CO0 z 0) y � C 7 Y U ICT Oco IM M -M C O U 0 N C O U 0 c 0 O a � OI-- N OO N I- O N O a0 O (D N O N 0 0 0 0 0 0 0 0 0 0 0 0 000001I- 0 0 0 0 0 0 r a� a) c m m ov E o E:3 U LL 0 IX i50 N 0 CO c � c 0 o N= m N 0 >1 N LL N N LL E O LL C > > 'O U U LL o U a) 0 co N co N N 0 c m m N o > v `o c � c ~ E ti> a) 0 a) o m > > 'O o C U U_ U_ Cp N U 0- O o LL,>af-00�- N co N On SUNRIVER OWNERS ASSOCIATION MAINTAINING SUNRIVER AS A PREMIER RESIDENTIAL AND RESORT COMMUNITY PROTECTING AND ENHANCING ITS QUALITY OF LIFE, NATURAL ENVIRONMENT AND PROPERTY VALUES. January 7, 2005 Marty Wynne Deschutes County 1340 NW Wall BEND OR 97701 Dear Marty: Enclosed are proposed Sunriver Service District financial polices for your review .-! co mi 1 Tl-. rl's-tl,- t T a gil .Aryl o it 1 J t licie tanu .,vi i imeii�. i i is ✓i�u int �VYanc%ying BCa� u `vv ii(:s:d Ilse to .a�..Iiipt i�i:.�."� I�Giev� � �. a future meeting. Please feel free to make any suggestions you feel are appropriate. We will wait to hear back from you before taking any action. Hope you had a great holiday. If you have a new address please pass it on to me. Sincerely, RI R OWNERS ASSOCIATION Pete Nielsen Controller P.O. BOX 3278 • SUNRIVER, OREGON 97707 • (541) 593-2411 • TOLL FREE (888) 284-6639 • FAX (541) 593-5669 SUNRIVER SERVICE DISTRICT GENERAL POLICIES TABLE OF CONTENTS CHAPTER 11: FINANCIAL MANAGEMENT & INVESTMENTS POLICY 11.1: GENERAL FINANCIAL ................................... 1 A. FINANCIAL AND ACCOUNTING SERVICES ................... 1 B. FINANCIAL TRANSACTIONS ............................... 1 C. ACCOUNTING RECORDS ................................... 2 D. INTERNAL CONTROLS ..................................... 2 POLICY 11.2: AUDIT..................................................3 A. SELECTION OF AUDITOR .................................. 3 B. PURPOSE OF AUDIT ........................................ 3 C. ADOPTION OF AUDIT ...................................... 3 POLICY 11.3: AUTHORIZATION ....................................... 3 A. PURCHASING.............................................3 B. SIGNATURES..............................................4 C. EXPENSE REIMBURSEMENT ................................ 4 D. CONTRACTS..............................................4 POLICY 11.4: ASSET MANAGEMENT ................................... 5 A. INVESTMENTS ............................................ 5 B. ACCOUNTING FOR CAPITAL ASSETS ........................ 5 C. DISPOSAL OF DISTRICT PROPERTY .......................... 6 D. REPLACEMENT RESERVES ................................. 6 POLICY 11.5: BUDGET PREPARATION AND CONTROL .................. 7 A. BUDGETING...............................................7 B. BUDGET CONTROL ........................................ 8 SUNRIVER SERVICE DISTRICT GENERAL POLICIES POLICY 11.1: GENERAL FINANCIAL A. FINANCIAL AND ACCOUNTING SERVICES 1. Sunriver Service District (the "District") does not employee staff to perform financial and accounting services. These services are provided by the Sunriver Owners Association (the "Association") through an Agreement dated June 14, 2003. 2. These policies are intended to govern the actions of District Managing Board (the "Board") members and District employees as well as Association employees engaged in carrying out the accounting services provided to the District by the Association. 3. References in these policies to the "Controller" means the Controller of the Association. The Controller functions as the Chief Financial Officer and Investment Officer for the District. References to "accounting staff' means employees of the Association Accounting Department. B. FINANCIAL TRANSACTIONS 1. Accounting for financial transactions shall be in accordance with generally accepted accounting principles (GAAP) and with the requirements of the Governmental Accounting Standards Board (GASB). 2. Financial statements shall be prepared on the accrual basis of accounting where revenues are recorded when earned and expenses are recorded when incurred. 3. The District has established two funds for accounting and reporting purposes. The General Fund is composed of accounts for resources and expenditures for general operations and administration. The Reserve Fund accumulates funds designated for future major repair and replacement of capital assets. 4. Financial institutions providing banking services must be insured by the Federal Deposit Insurance Corporation, must be able to provide Collateral Pool Certificates as required by Oregon Statutes, and must be able to facilitate transfers to and from the Local Government Investment Pool. 5. The District will invoice for all amounts due to the District on a current basis with amount due within 30 days of the invoice date. A finance charge of one and one-half percent per month will be charged on all balances due over 30 days. This section does not apply to billings for ambulance services. 6. The District will maintain good relations with vendors by paying bills in a timely manner to meet each vendor's terms for payment. Invoices will be paid to optimize District cash flows while taking advantage of available discounts. C. ACCOUNTING RECORDS 1. The fiscal year of the District shall be the same as that established for Deschutes County. 2. All accounting records shall be kept in such a manner that they may be easily audited at the conclusion of the fiscal year. 3. The general ledger and subsidiary ledgers will be balanced and posted monthly. All bank statements will be reconciled and posted monthly. 4. Monthly statements shall be approved by the Board. 5. Payroll records will be maintained in sufficient detail to produce statutorily required reports, leave of absence and overtime accruals and usage, and management of employee benefits and voluntary deductions. All payments shall be supported by properly authorized time sheets. No changes in pay rates or other payroll status shall be made without a properly executed Employee Status Report form. 6. Accounting records, especially computer files, shall be backed up regularly and copies shall be stored off site to ensure the safety of the files. D. INTERNAL CONTROLS 1. Duties will be assigned to individuals in such a manner that no one individual can control all phases of processing financial transactions in a way that permits errors or omissions to go undetected. 2. All District bank accounts must be authorized and approved by the Board Chairman. 3. All checks will be pre -numbered and accounted for. Voided checks will be retained and defaced. Checks will be stored in a safe place that is available only to accounting staff. Persons with signature authority will not have access to checks. 4. All checks must be manually signed and the Controller will be responsible for maintaining a current signature card with the appropriate financial institutions. Officers of the Board are the only persons authorized to sign District checks. Checks presented for signature must have all documentation attached K The Fire and Police Departments may maintain District credit cards with a credit limit not to exceed $5,000 for each department. The Chiefs shall monitor credit card use and bills to ensure they are only used for legitimate District purchases. No personal expenses or cash advances are allowed to be charged to District cards. All credit card purchases must comply with regular purchasing authorization policy. Employees may be held personally liable for any purchases appearing on the credit card bill which were not pre -approved. POLICY 11.2: AUDIT A. SELECTION OF AUDITOR The District Governing Body shall engage the services of a qualified Certified Public Accountant (CPA) to conduct an annual audit of the District's financial statements and supporting documentation. B. PURPOSE OF AUDIT The purpose of the audit is to insure that the financial statements are properly presented in accordance with generally accepted accounting principles and fairly present the financial position of the District. C. ADOPTION OF AUDIT The annual audit shall be presented to the Board for approval and recommendation for adoption by the Governing Body. Summary results of the audit shall be published in the "Sunriver Scene" within sixty days following the close of the fiscal year and the entire audit will be made available to members of the public on request. POLICY 11.3: AUTHORIZATION A. PURCHASING Purchase Orders or Check Request forms shall be approved as follows: 1. The Chiefs may delegate authority to specific employees to authorize single purchases of $500 or less, without approval of the Chief; 2. The Chiefs may authorize single purchases of less than $2,500, without approval of a Board Officer; 3. The Chiefs may authorize single purchases greater than $2,500 in emergencies with verbal authorization of one Board Officer for purchases up to $5,000 and two Board Officers for purchases of $5,000 ore more; 4. A Board Officer may authorize purchases of up to $5,000; 5. A Board Officer may authorize payroll -related expenses in an amount not to exceed $35,000 per budget account per month. Such authorizations must be reported to the Board. 6. The Board must authorize purchases of more than $5,000 and capital purchases of $1,500 or more, including purchases of individual items costing less than $1,500 if such items are aggregated and treated as a capital asset for reserve purposes (Section 11.4 D.3.). B. SIGNATURES Checks shall be signed as follows: 1. Checks in the amount of less than $5,000 may be signed by a Board Officer; 2. Checks in the amount of $5,000 or more may be signed by a Board Officer with prior approval of the Board; 3. Payroll -related checks in an amount not to exceed $35,000 may be signed by a Board Officer; 4. Paychecks in any amount may be signed by a Board Officer; 5. Any check payable to a Board Officer must be signed by a Board Officer other than the payee; 6. Payments of payroll checks and payroll -related expenses by electronic funds transfers must be approved by a Board Officer. C. EXPENSE REIMBURSEMENT 1. The Board shall enforce the Deschutes County Expense Reimbursement Policies for each Board member, District employee and contractors. 2. The maximum amounts allowed for certain reimbursements are set forth in "Exhibit 1 ". 3. The Chiefs may approve all requests for reimbursement of employee expenses that do not exceed the Chiefs' purchasing authorization (Section 11.3 A.). 4. All requests for reimbursement of Board member expenses, Chiefs' expenses and employee expenses that exceed the Chiefs' purchasing authorization shall be approved by the Chairman. Requests for reimbursement of expenses incurred by the Chairman shall be approved by the Vice -Chairman. 4 D. CONTRACTS V '. 1. The Chiefs may sign contracts with a term of one year or less and in an amount that does not exceed the Chiefs' purchasing authorization (Section 11.3 A.). 2. All other contracts must be approved by the Board and signed by the Board Chairman or other Board Officer. 3. All other contract policies are contained in Policy P003-6 — Purchasing Policy and Contracting. POLICY 11,4: ASSET MANAGEMENT A. INVESTMENTS 1. Investment objectives are preservation of capital, liquidity and rate of return, in that order. - 2. All District funds shall be invested with the Local Government Investment Pool managed by the Oregon State Treasurer unless the Board specifically directs the Investment Officer otherwise. 3. In such cases, the following policies will apply: a. The investment portfolio will be structured so that securities maturity dates match cash requirements. In addition, the portfolio will include a prudent amount of securities with an active secondary market providing liquidity through sale of a security prior to maturity, should that be necessary. b. The investment portfolio will be diversified by limiting principal investment to no more than $1 million dollars in any one issuer, except the U.S. Government and its agencies. c. Principal and accrued interest on maturity for certificates of deposit shall not exceed $100,000 and shall be insured by FDIC or FSLIC. d. Investment securities may be held by the commercial and investment banks that perform investment services for the District. e. Investments exceeding one year must be approved by the Board. 5 B. ACCOUNTING FOR CAPITAL ASSETS 1. Any item of a capital nature with a fair market value of at least $1,500 and is expected to have a useful life of three years or more shall be capitalized as a fixed asset. The total acquisition cost should include delivery, taxes and costs to prepare the item for service. 2. The Chiefs shall keep an inventory of all capitalized fixed assets, adding assets as they are acquired and removing assets as they are disposed of. The inventory will contain the following information: asset identification number, description of asset, date of acquisition, acquisition cost, accounting life, and accumulated depreciation. 3. It is the responsibility of the person acquiring a fixed asset to inform the Chief of its acquisition and to provide inventory information. 4. It is the responsibility of the person disposing of a fixed asset to inform the Chief. Proceeds from the disposal of an asset should accrue to the fund used to acquire the asset and be credited to the appropriate department. 5. The District will conduct a physical inventory of all capitalized fixed assets every three years as part of the reserve study update. The results of this inventory shall be reported to the Board. C. DISPOSAL OF DISTRICT PROPERTY 1. Property may only be disposed of after being declared surplus by the Board. 2. If property is being replaced, it should be traded -in as part of the purchase of the new property, unless: a. The vendor of the new property will not accept the surplus property as a trade-in; b. The new property is being acquired through a state contract that does not allow for trade-ins; c. The surplus property can be sold for substantially more money than offered by the vendor accepting the trade-in. 3. Surplus property that is not traded -in will be disposed of by the Board as follows: a. The property may be assigned to another District department and authorized as an addition to the Reserve Study, if necessary; b. The District may sell, donate or trade the property in compliance with OAR 60.015 — OAR 60.030. D. REPLACEMENT RESERVES 1. The District shall maintain a reserve fund for replacement or major repair of District fixed assets which normally require replacement in whole or in part between three and twenty years. Capital expenditures will be made by the General Fund and reimbursed by the Reserve Fund. 2. The Reserve Study estimates the funds necessary for replacement and major repair of current assets in future years. This estimate is based on the current replacement or major repair cost of each asset, the useful life of the asset, and assumptions concerning inflation and earnings. Individual items that do not meet the capital asset definition with a useful life of at least three years may be aggregated with similar items that are scheduled for replacement at the same time and included in the Reserve Study. 3. To meet reserve goals, the District will contribute General Fund revenues to the Reserve Fund in an amount established by the Governing Body during adoption of the annual budget. The District will use a cash flow model to test the reserve contribution level. The cash flow model will take into account increased costs due to inflation and interest earnings on fund balances. 4. The Reserve Study will be updated every three years to ensure that current replacement costs, life cycles and model assumptions are as accurate as possible. The Budget Officer and the Chiefs will prepare recommended revisions for Board approval. 5. The Board shall authorize additions to the Reserve Study as part of the Reserve Study update. The Board may authorize additions at other times during the budget preparation process. POLICY 11.5: BUDGET PREPARATION AND CONTROL A. BUDGETING 1. District budgeting shall be in compliance with Oregon's Local Budget Law (ORS 294.305 — ORS 294.565). 2. The Board shall appoint a Budget Officer who will work with the Chiefs, the Board and any Board -appointed sub -committees to prepare budget drafts and supplementary information to assist with budgeting decisions. 3. The Board, or a sub -committee appointed by the Board, shall prepare a requested budget including a base budget request, requests for modifications to the base budget, and requests for minor equipment and capital outlay items. 7 4. After review and modification, the requested budget will be approved by the Board as the District's proposed budget. The proposed budget shall be presented to the Budget Committee established pursuant to ORS 294.336 after review and approval by the Association Board of Directors. 5. The District Governing Body, acting as members of the Budget Committee, shall participate in the review and adoption of the proposed budget and shall assume responsibility for compliance with all publication, notice and hearing requirements for the budget process. B. BUDGET CONTROL 1. Expenses in major budget categories (e.g. Personal Services, Materials & Services, Capital Outlay) in each department shall not exceed the appropriated budget for the fiscal year. 2. The Board shall monitor monthly financial statements to ensure that expenditures are tracking the year-to-date budget. The Board may require the Chiefs to explain variances, and/or to provide revenue and expenditure projections. A Notice of Intent to apply for grant funds must be approved by the Board before application is made. The notice must explain the grant program, its benefits to the District, the amount and source of required matching funds, impacts of the grant -funded program on operating costs and additions to reserve requirements, potential impacts when grant funds run out, potential impacts of "strings and red tape" attached to the grant, and staff time requirements to administer the grant. 4. When grant application deadlines do not provide time for Board approval, the Chairman may approve application for a grant as long as the Notice of Intent is brought to the Board as soon as possible. Such grant applications will be withdrawn if the Board does not approve the Notice of Intent. 5. The Board will recommend mid -year budget adjustments, such as appropriation transfers, interfund transfers, or supplemental budgets to the Governing Body. 8 * / A y 0 O LL t0 O yO N U o M c L C (1)p 7 U D r CO x y `O m W y L O O C �- N (0 O M � C co-, 00 tL n�MN U T N W L E mN 0 7 J d C N(D > mQ Z y C O � p U O W CL O 0 T w t a O Im OIOICO O!i COV O (O'N Ofi COIOt�O M O O f` O OO j� IO r NI(AI i`7 tU N O V.W ISI coIM N O O VIII fir- O)INI CD HO) ' M ' ItO O) N = ICO M NIO CD of v M t0 I�OIOI ISI ,O 'N M N r0! 10 - ��i d'I N p• N IN ICO �I ��I vl iNlr �I O 0 O M MIM�Vi�-M' ! zI v I N U) O h O n 11 co 1, (D > > ! I I 1 1 I! l I l �p 0 O cO c0!NIV'O OI(DIN:� NiII10 OI N IM V OINI IOIol c0 O O N + 0)17 NI- c01(D!NIO t010'(D11- O OI (TI y!o01 h•I IN N!t�.00Co n1011 O O y 7 tT Ol OltO OIC 7 M W U I�INiO)I� co OO (f) M O N ' O) N I� If�ld• M t0 :N OiM O f� O O M O ICO M 7 (U N'I- IN f -!V NI 1l- N N t0 LOI CD N lO O 4lol M'O tOi(D O N �0 IN O } �O NIM OIN N) M IO N MIS 01t` ITI OI IM M M q.MI O M W vyl !� Q LL a I �!! Iiv I � I N O CO CO O O N 7 N coq N co O co CD T V O M O ' N n ' O) CO N 7 N N CI ao CC N Ito O) M CO ' N O (DtD CD O to r M m, 0 CD N r- t0 Cn to .- .- v CD CD c0 M n to V c0 n a I I t0 000000000000 Ny O V O- 0(00N 00 O(D O c 0 0000000 0 0 0 0 00 C. V'OOt0M 0 0 0 0 V.0) C-4 r, 'It O) 0 � O O t00 M f� O 00 O t00 M 00 -W C= p O LL (D N V' N r �_ N 0 V 0 7 M t0 M W M COMO O O t0 c0 O c CD M } m M O t() W N M t O t` (O V t` t0 c0 V ; 7 M V M O M 0) o `-' h t0 LL y CL t}i 1 OO I O C) CD C OO t0 t) ON N M C t00 > O N y (D I Ol CU C f O 0 c0 ' co O O O 1000 O O O(OMN O 1 't LLcc N MN O) ' M M Of tU > N O t00 S ' O O O ' O t0 7 CO c n Cl7 N E� t0 0 C (Ii N N M 7 0 LL y N O LL L N t0 ! y 1:3O ti W O 0 T C r N LL (a c co 7 O M r (� M(D N C > N d LL N N LL LL N U t\ m N 7 O) O O L C y 0 D O O co LL C Ot n O O N N 7 •N O O N -;g O c m c y 0 OFo- O T V O C) O O N (n Z a)p Of -M N0 N (` N n ayi.E C '� M O N` 67 - O M M M M c0 t0 t0 ' V M N OCL t0 n' M O �2,~ c0 Oa2v� ' t0 OUc�wa�,O¢��Z n r V z N N 10. tND NC 000 0000 O to t0 O.- T tD O (D t0 - 'Q Ln V 0 O 0 O) 0 0 0 0 t0 N 0 a ' O f V co N h N L O) n' M O D N M to , 1 Q t0tp f` 7 co C0) N N t+1 N r) O O r t0 co N r 000 00 toM 0 O O O O L ` t 0 0 0 O 0 O ' O O O ' N f.- V M O O N t0 m 'n ' M c 0 M L O O ' M t0 c0 co N c0 r N O) N N Of N to n c 0 N O t0 co N r r h Z` 0 0 o O O O t O t 0 0 o r O o O c9 7 (000 O O 000 ' N M N n M N h NO) t0 n' r M t0 O' M c0 ' O O ' M to �` n '- N d' N co to N N M N M d co N t0 O N tD tT Of LL �+ O O O 00 t O Lo 0 O r O O O t000 00 N1- N N(n CO MO M 7 rOtn ' ' OO ' V MO U') ' M N t0O N VcO�� �N r Lo(ND N NN N O O CO CO N N M N:M1 t0 4: r C>) O- N 0 O"tD Of c0 C"N. � co (p O M N 'tt (D O t0 NON ' (D CO C O�'f to (D N N , M T n - N co cy;..- N 0= U � O M .- .- O) n . N N �eyh� ` C70 c6:�tD 0;,. .: N - '•:W O 'tCf O.a'.M gyOpp. co i ¢ ` M N' N < r tt0 eR M- c0 f- M N O 'C} N M(' .- M t0= �: 07, CD f` N (O (A MOO M0) OO O) O O O ,p E O O O c0 M to O M ti) N Cb h t` r O) O O t0 t0 M O f` M t0 O O M t0 (T N U) 00 LOO N M M N n N O NOOO O Lo U) (DN(DN_0)rCD 0) m N (D Of a E O c0 7 1` (OM M V MN N O M ' V N V r v < 0(D O t0 Oc0 f-- N N N to ' a0 n ' ti N > OC t0 N M Go to to N O N N M M Z O)O(DN M1,0 70 � tD 0) N e} O O 0 oMO�� N N� O U N tiff O)N � CD UM7 ' ' ' ' ' ' N U N [D O) O) Ln W) Lo t00 CII N N O � N N M O O f` O OO V r r i`7 O O O O N E CD M 7 N M N co RN co 1 V MM O ' N CD CD of M t0 O CD OO ' M N tO O N p• ICO N O 0 O M 7 W O) N U) O h O n 11 co 1, (D h O) O_ N O O'7 c0 O M (D r to O O O y 7 tT M m' co f, 1- O .- O 7 M ' t0 N M co OO (f) M O N ' O) N co N M t0 ' M U m Q O O tp 00 co M (D N 000 N N N N N O CO CO O O N 7 N coq N co O co CD T V O M O ' N n ' O) CO N 7 N N N 0 M CP N n n N Ito O) M CO ' N O O to r M m, 0 CD N r- t0 Cn to .- .- CD q CD CD c0 M n to V c0 n I I Ny C o -W C= O LL 0)+�' 7 M O c a E Co Z5 � a) CC > i 0) ; y CL t}i 1 � I W C C LL > O N y IM C Z y 0` a) FO- LLcc j LL tU > S ' N C W y y a) N c C c NL E� 'CO c 0 C y CO N 7 0 LL y y y LL L N C O ! y 1:3O ti W x 0 W U 0 T C A N LL (a c p U 7 O U 7 '� LL (� C > N d LL N N LL LL C O g U N N 7 O) IQ L C y 0 C m._ LL LL C N y c m o t rnmp •N O N -;g O c m c y 0 OFo- 0 E LL U� Z� a) t9 m d 7 (n Z a)p N N (` N c (` Y ayi.E C '� U O N` 67 - O '�' y ��� C L C d C d d r OCL W>,�ininlinav> �2,~ Oa2v� z OUc�wa�,O¢��Z n z Deschutes County - Fair and Expo Center YTD -Budget Basis Transfer from General Fund 150,000 150,000 - 50% Transfer from Annual County Fair 100,000 100,000 - 50% Total Transfers 250,000 250,000 - 50% TOTALRESOURCES REQUIREMENTS: Expenditures: 904,022 873,199 (30,123) 50% Personal Services Statement of Financial Operating Data 338,601 18,459 50% Materials and Services Six Months Ended December 31, 2004 89,773 50% Debt Service 36,782 Budgeti Actual I Variance I F 45,970 Budget I Projection I Variance RESOURCES: 3,176 3,176 - 50% Contingency - - Beg. Net Working Capital $ 140,800 $ 138,098 $ (2,702) 100% 98% $ 140,800 $ 138,098 $ (2,702) Receipts: Deposits Received for Future Events: 2004: Events 294,690 285,881 (8,809) 50% 45% 631,000 622,191 (8,809) Telephone Fees - Events 9,000 20,240 11,240 50% 127% 16,000 27,240 11,240 Parking Fees 49,500 19,562 (29,938) 50% 22% 87,000 57,062 (29,938) Storage 27,500 13,420 (14,080) 50% 26% 52,000 37,920 (14,080) RV / Camping 1,700 1,818 118 50% 45% 4,000 4,118 118 Horse Stall Rental 500 1,088 588 50% n/a 2,000 2,588 588 Concession % - Food 109,777 117,401 7,624 50% 55% 215,000 222,624 7,624 Vending Machines 700 1,400 700 Interfund Contract - - - 50% 0% 32,000 32,000 - Rights (Signage, etc.) - - - 50% 0% 45,000 45,000 - Grants 15,180 20,177 4,997 50% 66% 30,355 35,354 4,999 Miscellaneous 2,250 2,892 642 50% 64% 4,500 5,142 642 Interest 2,425 2,622 197 50% 52% 5,000 5,196 196 Total Receipts 513,222 485,101 (27,421) 50% 43% 1,125,255 1,097,135 (27,420) Transfer from General Fund 150,000 150,000 - 50% Transfer from Annual County Fair 100,000 100,000 - 50% Total Transfers 250,000 250,000 - 50% TOTALRESOURCES REQUIREMENTS: Expenditures: 904,022 873,199 (30,123) 50% Personal Services 357,060 338,601 18,459 50% Materials and Services 376,650 286,877 89,773 50% Debt Service 36,782 36,782 - 50% Capital Outlay 45,970 44,775 1,195 50% Transfers Out 3,176 3,176 - 50% Contingency - - 50% TOTAL REQUIREMENTS 819,638 710,211 109,427 50% NET (Resources - Requirements) 84,384 162,988 79,304 Deposits Received for Future Events: 2004: January 6,290 February 4,181 March 9,850 April 5,371 May 935 June 6,820 Beyond 31,746 TOTAL 65,193 50% 300,000 52% 191,000 51%, 491,000 50% 1,757,055 Effx-P-No (1) 47% 714,240 38% 753,494 100% 36,782 n/a 45,970 3% 97,357 n/a 109,212 300,000 191,000 491,000 1,726,233 (30,822) 695,722 18,518 710,484 43,010 36,782 - 44,775 1,195 97,358 (1) - 109,212 40% 1,757,055 1,585,121 171,934 . 141,112 141,112 Deschutes County Fair and Expo Center Statement of Financial Operating Data December 2004 TOTALRESOURCES 64,280 101,110 39,330 REQUIREMENTS: Expenditures: Personal Services 59,510 52,775 6,735 Materials and Services 62,775 58,094 4,681 Debt Service - - - Capital Outlay - 26,500 (26,500) Transfers Out - - Contingency - TOTAL REQUIREMENTS Budget Actual Variance RESOURCES: (58,005) (36,259) 24,246 Beg. Net Working Capital $ - - $ - Receipts: Events 33,750 9,687 (24,063) Telephone Fees - Events - - Parking Fees 2,500 - Storage 15,000 1,605 (13,395) RV / Camping - 36 36 Horse Stall Rental - - - Concession % - Food 9,000 11,519 2,519 Vending Machines 700 - (700) Interfund Contract - - Rights (Signage, etc.) - - Grants 2,530 2,530 - Miscellaneous 375 230 (145) Interest 425 503 78 Total Receipts 64,280 26,110 (35,670) Transfer from General Fund - 75,000 75,000 Transfer from Annual County Fair - - Total Transfers 75,000 75,000 TOTALRESOURCES 64,280 101,110 39,330 REQUIREMENTS: Expenditures: Personal Services 59,510 52,775 6,735 Materials and Services 62,775 58,094 4,681 Debt Service - - - Capital Outlay - 26,500 (26,500) Transfers Out - - Contingency - TOTAL REQUIREMENTS 122,285 137,369 (15,084) NET (Resources - Requirements) (58,005) (36,259) 24,246 Deschutes County Fair - Fund 619 Revenues and Expenditures FAIR 2004 - Boots, Bulls and Blue Ribbons RESOURCES: Beg Net Working Capital (7-1-04) Carryover as of January 1, 2004 REVENUES Gate Receipts Major Entertainment: Stacie Orrico Lover Boy Phil Vasser Carnival Commercial Exhibitors: Outside Inside Food Livestock Entry Fees RN Camping Concessions: Food Entertainment Fair Sponsorship: Rodeo On -ground Stages Day Golf Carts Food Court Concert Petting Zoo Presenting Sponsors Barn Sponsors Building Sponsors Grants T -Shirts Telephone Fees State Grant Interest Miscellaneous TOTAL REVENUES TOTALRESOURCES EXPENDITURES Expenses: Personnel Materials and Services Contingency TOTAL EXPENDITURES Transfers Out TOTAL EXPENDITURES/TRANSFERS NET (Resources less Expenditures) 27,195 6,899 334,000 Actual Dollar _1% Approved Jan 1 - Variance Percentage FY 04-05 Dec 31, From Variance -Budget 2004 Budget from Budget 27,195 6,899 334,000 331,535 (2,465) _1% 56,000 11,547 (44,453) -79% 56,000 9,715 (46,285) -83% 27,500 27,500 - 123,000 135,412 12,412 10% 76,000 90,625 14,625 19% 37,000 38,175 1,175 3% 14,000 14,063 63 0% 7,000 5,723 (1,277) -18% 13,300 13,635 335 3% 96,000 103,452 7,452 8% 1,200 300 (900) -75% 28,000 28,500 500 2% 7,500 7,500 - 0% 9,000 9,000 - 0% 2,000 1,800 (200) -10% 3,500 3,500 - 0% 3,500 3,500 - 0% 2,500 2,500 - 0% 11,000 11,000 - 0% 7,500 4,300 (3,200) -43% - 2,500 2,500 N/A 8,000 5,000 (3,000) -38% 2,000 2,117 117 6% 1,981 1,981 N/A 35,000 39,200 4,200 12% - 1,401 1,401 N/A - - NIA 960,500 905,481 (55,019) -6% 987,695 912,380 (75,315) -8% 138,011 134,533 3,478 3% 643,033 558,993 84,040 13% 15,651 - 15,651 100% 796,695 693,526 103,169 13% 191,000 191,000 - 0% 987,695 884,526 103,169 10% - 27,854 27,854 DESCHUTES COUNTY - ANNUAL FAIR Budgeted and Actual Materials and Services Fair 2004 as of December 31, 2004 Medical Contract Mailing service Temporary Help - Office Temporary Help - Labor Transportation Consulting Fee Graphic Design Indirect Charge - Legal Indirect Charge - Finance Indirect Charge - IT Indirect Charge - Tech Reserve Indirect Charge - Admin Svcs Indirect Charge - Personnel Food Booth Cash Control Gate Receipts Cash Control Major Entertainment Grounds Entertainment Livestock Competition Open Class Rodeo Security Water & Sewer Portable Sanitation Garbage Custodial/Janitorial Building Repair & Maintenance Equipment R & M Equipment Rental Membership & Dues Conferences & Seminars Bank Charges Software Licenses Fees & Permits Insurance Premiums Cellular Promotion Printing Travel Premiums -Other Refunds Custodial supplies Equipment R & M Suplies General supplies Office/Copier Postage Queen Court Program supplies Bldg/Grounds R & M Supplies Safety supplies Shop supplies Special Supplies Straw & Hay Vehicle R & M Supplies Electricity Gas/Oil/Diesel Natural Gas Meeting Supplies Subscriptions Minor Tools and Equipment Computers & Peripherals TOTAL 2,800 11,800 500 11,000 38,000 8,000 5,750 7,174 12,744 1,842 3,604 1,542 5,000 16,500 118,000 44,000 13,000 44,000 44,000 51,000 3,000 2,400 11,000 8,000 2,100 40,500 1,200 600 250 200 28,977 500 25,000 6,500 4,200 21,000 1,000 6,000 5,000 3,500 250 2,100 3,000 1,500 1,200 250 2,900 1,500 15,000 1,000 150 3,000 3,M) 3,400 17,535 26,496 9,550 243 180 2,874 7,001 6,372 924 3,528 1,513 5,000 13,096 73,500 40,200 30,854 49,321 53,238 3,595 3,180 2,227 8,750 6,800 718 62,369 1,140 412 241 21,990 414 24,448 6,731 1,421 19,979 469 6,129 239 1,861 1,010 1,458 1,641 636 54 102 1,183 438 19 18,277 2,135 840 197 tzuo) 8,400 500 (6,535) 11,504 (1,550) (243) (180) 2,876 173 6,372 918 76 29 3,404 44,500 3,800 13,000 13,146 (5,321) (2,238) (3,595) (180) 173 2,250 1,200 1,382 (21,869) 60 600 (162) (241) 200 6,987 86 552 (231) 2,779 1,021 531 (129) 4,761 1,639 (760) 642 1,359 1,500 564 196 (102) 1,717 1,062 (19) (3,277) (1,135) (840) (197) 150 3,000 10,000 k400) (1,600) 500 (6,535) 11,504 (1,550) (243) (180) 2,876 173 6,372 918 76 29 3,404 44,500 3,800 13,000 13,146 (5,321) (2,238) (3,595) (180) 173 2,250 1,200 1,382 (21,869) 60 600 (162) (241) 200 6,987 86 552 (231) 2,779 1,021 531 (129) 4,761 1,639 (760) 642 1,359 1,500 564 196 (102) 1,717 1,062 (19) (3,277) (1,135) (840) (197) 150 3,000 643,033 548,993 94,040 10,000 84,040 (Over)/Under (Over)/Under Budget Actual Actual Estimated Estimated 2,800 11,800 500 11,000 38,000 8,000 5,750 7,174 12,744 1,842 3,604 1,542 5,000 16,500 118,000 44,000 13,000 44,000 44,000 51,000 3,000 2,400 11,000 8,000 2,100 40,500 1,200 600 250 200 28,977 500 25,000 6,500 4,200 21,000 1,000 6,000 5,000 3,500 250 2,100 3,000 1,500 1,200 250 2,900 1,500 15,000 1,000 150 3,000 3,M) 3,400 17,535 26,496 9,550 243 180 2,874 7,001 6,372 924 3,528 1,513 5,000 13,096 73,500 40,200 30,854 49,321 53,238 3,595 3,180 2,227 8,750 6,800 718 62,369 1,140 412 241 21,990 414 24,448 6,731 1,421 19,979 469 6,129 239 1,861 1,010 1,458 1,641 636 54 102 1,183 438 19 18,277 2,135 840 197 tzuo) 8,400 500 (6,535) 11,504 (1,550) (243) (180) 2,876 173 6,372 918 76 29 3,404 44,500 3,800 13,000 13,146 (5,321) (2,238) (3,595) (180) 173 2,250 1,200 1,382 (21,869) 60 600 (162) (241) 200 6,987 86 552 (231) 2,779 1,021 531 (129) 4,761 1,639 (760) 642 1,359 1,500 564 196 (102) 1,717 1,062 (19) (3,277) (1,135) (840) (197) 150 3,000 10,000 k400) (1,600) 500 (6,535) 11,504 (1,550) (243) (180) 2,876 173 6,372 918 76 29 3,404 44,500 3,800 13,000 13,146 (5,321) (2,238) (3,595) (180) 173 2,250 1,200 1,382 (21,869) 60 600 (162) (241) 200 6,987 86 552 (231) 2,779 1,021 531 (129) 4,761 1,639 (760) 642 1,359 1,500 564 196 (102) 1,717 1,062 (19) (3,277) (1,135) (840) (197) 150 3,000 643,033 548,993 94,040 10,000 84,040 Deschutes County Fair - Fund 619 Revenues and Expenditures Annual County Fair (Fair 2004 through December 31, 2004) REVENUES: Gate Receipts Entertainment Carnival Commercial Exhibitors Livestock Entry Fees RV/Camping Concessions - Food Concessions - Entertainment Fair Sponsorship T - Shirts Sales State Grant Interest Lottery Grant Miscellaneous TOTAL REVENUES EXPENDITURES: Personnel Materials and Services TOTAL EXPENDITURES Gross Profit Transfer to Fair & Expo Fund TOTAL EXPENDITURES NET Retained Annual County Fair Fund 300,373 341,755 320,332 331,535 Fund 619 Fair 2001 1 Fair 20021 Fair 20031 Fair 200411 Cumulative 300,373 341,755 320,332 331,535 1,293,995 118,433 127,727 38,787 48,762 333,709 95,211 99,971 92,345 135,412 422,939 122,701 110,596 133,254 142,863 509,414 6,080 7,373 7,502 5,723 26,678 6,296 10,095 10,620 13,635 40,646 65,621 94,675 88,961 103,452 352,709 1,262 1,240 - 300 2,802 37,850 78,360 69,342 74,100 259,652 - 3,815 1,569 2,117 7,501 43,056 40,868 39,200 39,200 162,323 1,130 2,471 1,390 1,401 6,392 - 10,528 15,000 5,000 30,528 3,170 2,581 983 1,981 8,715 801,182 932,054 819,285 905,481 3,458,002 39,121 107,624 124,434 134,533 405,712 544,651 639,523 578,611 558,993 2,321,778 583,772 747,147 703,045 693,526 2,727,490 217,410 184,907 116,240 211,955 730,512 154,556 172,102 185,000 191,000 702,658 738,328 919,249 888,045 884,526 3,430,148 62,854 12,805 (68,760) 20,955 27,854 NOTICE OF SUPPLEMENTAL BUDGET HEARING A public hearing on a proposed supplemental budget for Deschutes County, State of Oregon, for the fiscal year July 1, 2004 to June 30, 2005, will be held at the Deschutes Services Center, 1300 NW Wall Street, Suite 200, Bend, Oregon. The hearing will take place on the 7th day of February, 2005, at 10 a.m. The purpose of the hearing is to discuss the supplemental budget with interested persons. A copy of the supplemental budget document may be inspected or obtained on or after January 28, 2005, at the Deschutes County Board of Commissioners' Office, 1300 NW Wall Street, Suite 200, Bend, Oregon, between the hours of 8 a.m. and 5 p.m. For more information, contact Teri Maerki, Financial/Budget Analyst, at 541-388-6536. A summary of the supplemental budget is as follows: [Bulletin: INSERT ATTACHMENT HERE] E Z3 0 LL 0 m �5 m a) (D a) m C: 0 L) u m 0 =3 06 .0 .0 U) 0 .0 E E E: co 0 L) C: 0 :3 —0 15 —0 CL x 0 U) c c zo 0 C: 0) M *E C c c w 2 2 w > > a) 0 C 0 .Ln L) C: 0 c 0 a) (D cn 0 0 ts 0 cn cn 0) 2 2 2 a) < '0 2 2 '0 a) a) (n cu 0 E 0 0 0 L) < > E 0 a) E E -J 0 0 L) c: E 0 z 2 0 E E 0 .2 0 0) rn 0 2 'o m S "C3 cm =3 0 * 76 1 c �o .0 E cn a) 7'a 16 Ira 'FD .0 C: .9 C: 2 2 z 75 - - - rn c a) En (n 2 Z3 CL Z 0 In -�; (D C: CL -0 0 Co cn tn (n b 0. < C) 0 W (D z 0 0 (D 6 of 0 0 a u 0 () c < < — tn LO M C:) CD 0 CD C:) CD CD CD C:) 0 0 CD CD 0 CD 0) 0 CD a) m Cl) r.- C) C:) C) CD 0 C) CD C� 0 C� C� C� CD 0 C� C� CD C� C� 0 C) 0:� 0 R C\l 0 0 ll*� Ci C� C%l a) m I-- (D 0) CD Cd cNi a; CT 06 C; r-: 1- t-- t-. 0 C CD 0) CD cli 0 'T > 0') m LO C) 0) CD C) CD (0 0 CD w 0) LO CD w 0) co C%j It I-- r -- co a) (0 CN Lo CD C) 0 Cl C� C) 0 CD 0 0 0 CD CD C) 0 CD 0 C) 0 0) C� 0 N 0 CD (D N ce) Cl) m 0) 0 CD 0 C) — — 0 CD CD CD 0 Cl C) 0 CD CD cq R "Iz� C� C� It C) E (d(d 66 P.: 1-: r-: PZ 0 0 CD m 0) 0 CD cli 0 cli CY) 00 C:) CD 00 LQ IR 4) (D (a (D o CL CL C) C) m CD 0 0 C) C:) C) CD (D = m (D C) C) r-- P� C) C) 0 CD C) 0 CD CD 24 C\f ci C6 6 C; 6 6 C4 (D C) C%F co > CR LO C') Lo 0) CD cli cc 4) -0 Cy� Ct 0 C? CD C:) CD C� C� —. 0 9 C) C� LO U') C) 7 c� 0 C) 0 9 9 9 4) 0) C14 CD — 0) U? 17 02 m C4 Cl? O� C! (1 7 0 C� C� U? cl) 17 LO m LO OD to ce) (D 0) 0) 0) LO - Ce) co (D I* Cl) C? Cl) Cl) I IT I? C? C? 0 CD CD C) C) I 0 C) CD 0 C) 0 0 0 C) CD C) c) CD C:) C) C) 0 0 C) C) C) 0 U') LO 00 00 OD 9 9 9 0 9 co 9 C) 0 co OD 00 C) 0 C) Ln 0 0 0 C4 C%j LO LO LO CD CD �2 �2 (D (D (D C> C) to C� CD E C%4 U) w U) 0) U) cu W a) rr (D V (n 0: w < cr c c = LL 0 0 co 4) E > 0 0 cn CL E cu 0 ,Z-- 0 U. 'n m cn lu co L) r :3 0 C: 0 4) U. 0) 0 C: > I= 0 0 0 2 L) a) -0 U) 7�; LLL CD 0 (D :3 — E E c a) a U ua)) z ;>, c>: -j o :3 E CL 2 w z a) 0 L) o (n 0 0 m 0) cn > m CL cc CD C: LL C: 0 c 0 7FD _j 0 0 c: 0 a) 0) o a) 0 r- (D — 0 L) 'a -E wa) c E M (-) C: (n (D C: 76 co m :E — 0 a o 01 'Ei) ID cu C: E (C2 0 -Z5 0 co 0 L) C: m 0 3: 2 a) 0 :2 a) :2 0 1-- 4) 0 o 0 P 65 I-- co Lu < z > m > — L) 0 z -1 -01 CD t- N in CD LL A Wo (D LO (D 0 0 0 0 0 C: C4 0 cu .9 E E E E E E E a CD 4-- c > z 0 LL 0 x m LU C: 0 c c c c c c c 0 c 0 0 0.0 .0 .0 .0 iE iD 'a LL '0 .- .- -L- It- := :t.! := 0 Q) 0 0 w 0 w w 0 cu > 0 0 0 0 0 0 0 L) ow CL CL CL CL CL CL cu < 3 0 (D 0 0 0 0 0 0 0 < 2 fn — E E E E E E E r- 0 0 12 CY) 0 _0 0) 0- CL CL C� CL cl (D > :3 m - 0 0 0 0 0 0 0 (D 0 0 w 0 w w w 0) m cu m m m m m m m c '�5 0 0 0 2 E m 0 �o L) cu < LL 2 < 0- 0) m ce) LO Go CD I- r- LO CO M co T LO 00 "cl- r-- le cli C%l C:) co Cl) 0 - M M CD - r- 0 en CD - 0 N 0 r- 1q, m 4) r- le (D 0) M M LO IT CN C4 (D CD co r- co (0 - co co U) IM C6 (6 'i C6 C� —7 r_: (d a; Ld as r-: 06 C6 0� -.: 6 cr� -0 m r- C\j 0) w a) Cl) N w f- V) co m cli 't 04 Cq 1-t :3 04 r- C4 CM CQ 1, t.. C� cl! C14 M M V - m a) r- to Go 0 LO CD 00 CD C. m Go C) 0 C) 40 co co 0 co co C\j N 0) m m C) to C) C> C) LO CO 0 C.) C) 40 0 CD cli N 0 CN N 14, IT m 0) Lo co C) m r- (0 LD C) CD CD Cl (D co CD (D w w 'i Ld (d Ir: cli Cq i Ld W� L6 L6 06 06 L6 C6 C6 E Cl) 1:T 04 04 C) C14 00 co CC) co CL U) C) CD C) C) 40 C, o') r- U') — CC) It 0) w M CD CD 0 CD C, C) to 0) 00 (D (D CD C) to r- — cc Cli �R LQ W LO W r— co co co r- co CD LO CC) C\l Ln W lzr cm 0 cli r- 1- L6 (3i Ld 1-- 6 C -i C\F vl� (d r_: 0) W co LO Lo co CY) 04 LO 0 to W C� N 0) N C14 cm 04 w w N Ln 0 0 o C) CO C:> 0 - - - - - C) C) w C4 CD CD M79R9999 CD (n I I . I CD co C:) m 0) C) cl� Z� " m 0 (D r— . I C> CD LO P- 0 Lq C� C'� " 04 " 0) 17 q Cl O� L) U'j C� C� CIJ 04 C14 CIJ N - CD (D CD 0) - - - - - - 0 C\j 0 04 C) c w I�t ",It 't 'IT 't U') V* Cl) to IT C? C? C) 0 C) 0 0 0 C) C) 0 0 0 C) C� C) 0 C) C) CD C) 0 co C) C) C) r— C> 0) Ln 0 C� C) 7 7 0 N 'IT to . I U) C� C� C� C� C� C� C� C� C� C� L6 LO Lf) LO I:r a Lf) LO LO �4 C%j (n N 04 U) C4 C\l a) E E E 0 m 0 0 cr 0 a 0 CD W 4) U) > U) E E E 4) c U) U) 0 0 E E E E 0 4) E U) CD U') a) 0 0 C2. rr co C: a E L) U) C\l Z3 m U) W LL a) CD L) C E -C cm U) L) L) C 0 OL) 0 cm :3 c: c Co L) L) LL cn (n cu co r C: 0 a) U) E -9 *A cn ca 0 0 c �i S (n cn CD n Z E r 0 a) LL -5 0 a, —M c CD U) 0 co CL 12 _j .0 (D CL 0 0 E 0 0 0 >, CD Co Qc E E -Z5 L) c: u 0 4) (n z a > t5 E 0 L>)' W 0 U) LLJ w z U) C.) (n 0 :2 < — 0 -0 a) '0 >1 .2 C) 0) 4) 0) 4) 0 L) > C3) U) < n c c - ca (1) 0 a) > -0 -j to c c _0 (D U) U) U) C: 0 E 'c2n C-- c 'ra CD c E U) 0 0 :�t 0: E o a) a) [2 lau) 0 uj o 0 4) 0- a) 0 Im FL a- :5 0 0 m C -0 U-) cm La = (D 't LO CM N U- A a_q x LLI C/) (D (1) C: CL x > CD C) m 0 0 0 0 m r-- m m 'IT co r- N m (0 r- 0 0 LO 0 Nr 4) 9 9 9 9 9 1r cp 7 C� 9 C? C? C? 91 cp cp T 7 9 R —1 9 04 0 0 (0 CD (D w w w w w w w m m w — C� C; (6 flL co CO LO r.- 0 — — — — — — — — — — — — — — — — Cl) Cl) 0) co r— It I- It 'IT It -r 'IT qT It IT IT Nr Nt 't It 0 C? C? IT "T IT IT IT i IT IT 'IT IT i IT IT '7 17 i 9 C? L? 0 0 CD 0 0 0 CD CD C) 0 C) CD 0 0 CD 0 0 CD CD 0 CD C) CD 0 C) CD CD C) C) 0 C) C) 0 0 0 0 CD 0 CD CD CD 0 0 0 CD C) CD C) C> 0 0 CD CD 0 C� 0 0 C) CD 4) C) C:) " 04 C\l C\l C\l 04 04 04 " 04 CN Cq Cq " Cq N Cq 04 C\J C4 N 04 C> " 04 C%4 C*4 0 CD C) C\l N N CIJ N Cq CN N Cq N 04 C14 N 04 C\l 04 " 04 C\l C4 04 04 CD cq N cq N L6 L6 Lh 6 L6 6 6 Lh Lh 6 6 6 6 Lh us L6 L6 6 us 6 Lh Lh 6 6 6 6 6 6 6 r- r-_ rl- rl- rl- P.- P- r- r-- r-- rl- r- r- rl- r- r-- rl- CD co co CC) co 04 04 04 (N 04 LI) 0 U) 4) 4) 4) E a) E cu =3 > 4) 0 (1) rr 0 CL cu U) .,n 0) (D Z; C: cu in F- L) C < 0 m 2, 0 E 2:! 0 M — CD .0 E2 = 0 m 16 d 0) a) L) co :3 (a -F, 0 E (n cu < U) (D 0) W a) 0) CD- CL a 0 C M 0 a) 3: 13 2 (D cn -Fu U) CL — a) CD a) -R m m L) X a) LL (5 a- U) U) (n < 0 a. LL AG) 75E2 cE C) L) 80 L) - m a) 0 CL 0 > m 4.2 o a) , M zs '4= E 0 6 M 0 0 0 0 E- s Q) o) -o >1 0 CD ca < U) a) 0 a) 0 m 0 0) CL Mn cm Ln - 8 z = = o s m c c 0 . :� (n E c < S a) —0 -,5 -Z� 2- C) a t o o w CD 0 0 0 E -c5 -c5- c E cu '5)'E L) u C: 2 2 4) -Z5 0 0 0 0 0 -0 C (D w 0 0 0 000000 a) < CL < U) U) U) < 2 U) 1D U- 0- :Cc: o 0 0 LD CD r-- Go C14 C%4 LL E rr (D CL 0 -a 0 I-- :,4 C') LO co co CD m -,t -,t C) m p 0) 00 C'4 LO Co 00 ;t t (0 C> CD --t ce) Lo C> 40 CD LO 1 r- 40 cli le omoNrl-om"r-- N w a w r- CD m 'IT m r- N m v CD 0 0 LO m CL Ln CL Ot (C� (Q LQ n Ci LQ C\L "IL cl� LQ P-� C� Ci CL C�L p-:. (q rl-L Cli oc� rl-� Ci c:I cl q C,� c Cli x M Cl) C) CD C14 C\l CIJ "'T Cl) LO LO r- 00 0) — V) (D — M 04 It 1- 00 �T t- -0 -1 -1 I.i� -0 -0 -.0 -OR -1 -0 -1 -0�� -1 C) r- C) 0) .2 :!-- '0 r-_ w (o co C\l N� 1- (D CIJ r- LO CO 0 04 " 0) LO 04 N C\l C\J C14 CD — C14 M tl- 0-0 0-0 0-0 0-0 0-1 0-1 0-1 0-1 C) C) 0 C> C) C) CD C) CD C) CD 0 0 C) CD 0 C) 0 C) CD CD co w W) cq 'a 0 cu co CD r- — CY) LO (D C\l I- co P- N m cli in 2- , Z 04 Cl) 06 Cj :3 LL n -0 m �o -0 no -0 m m -0 m n m m M.0 �o n -0 mo tr_ tt-- 4-- -a 0 E 0) C a) :3 2) a: 0 w w 0 w 0 w w w 0 w 0 w w 0 0 w w 0 0 w Q)LL cu 16 — — — — — - 615 — — — — — — - 6 — — — — — — 00000 000000 000000 .9 '0 §.2= — — — — — — — — — — — — — — — — — — — — — cu L) :3 -Fo -Fo -ib 76 -Fu 75 'Fo -Fu -Fo -ru -ffi 76 -Fu 'ffi 7ffi 'Fu 76 76 76 "ffi 'ffi a) a) -Fo -(6 .0 -C r- r_ U) 2 0 0 0 w w w 0 0 w 0 w 0 w w 0 w 0 w 0 (n U) fn cu cu cu .2 . _0 _0 '0 c c c c c S.S.S ce) Cl) m U') co Il- m CD rl- w 0 'IT LO m m 'T It 'T m 't It I�r C) U*) 00 co le CD N a) (0 m (D m (0 r- co C� I;t w It r- It m 'IT M �; M (D M 0 M 04 cm CD U') LO CO eq a) LQ CL C31 C\[ LCI (Cl cl� P,-� -� -I LQ (q 1'� ot "I v! v! N - Iq zt oc� It! cy� LQ rl:. LQ C\! Ci cci rl.� ol (D m 1- (0 M (0 M LO r.- M 00 0) N M [.- I'- N M N (D [,- M t (0 r- (.0 m co 0) r-- LO m V — (0 N M M 0 LO M U') N N (D n N N N r- T N M W �; (D 1, 04 r- 04 U) 1, a, LO It C%l M U) rl- r- co C*4 w — N Ln 05 cli W� 1-: o) 0 cn 04 CO 0 "It r- 0) IT 00 C� CO 0) 0) �D '1* CC) 't -I- CD C) CY) 'IT CD 0 00 (D It 'T 0 -e m 00 (D rl- r- LO (1- (0 (0 CN co m -It (D (D 0) m le rl- ;; 'IT CN C14 CD C) LO 0 Cl C� R LQ OCL --I LQ r- (CI cl! CL n Lq P-� (Q Vi "Zt lc� OCL r-� R LQ Iq Lq Ci Ci C� W� m 0 m (D (=) CD q:t cl) — — — — — — 0) co m f.0 co co CD I— C> w LO U') 'IT CD Ln (D C-4 0 m CD LO 00 — co r- LO C14 CO a* CD C) m 0 0 0 0 m r-- m m 'IT co r- N m (0 r- 0 0 LO 0 Nr 4) 9 9 9 9 9 1r cp 7 C� 9 C? C? C? 91 cp cp T 7 9 R —1 9 04 0 0 (0 CD (D w w w w w w w m m w — C� C; (6 flL co CO LO r.- 0 — — — — — — — — — — — — — — — — Cl) Cl) 0) co r— It I- It 'IT It -r 'IT qT It IT IT Nr Nt 't It 0 C? C? IT "T IT IT IT i IT IT 'IT IT i IT IT '7 17 i 9 C? L? 0 0 CD 0 0 0 CD CD C) 0 C) CD 0 0 CD 0 0 CD CD 0 CD C) CD 0 C) CD CD C) C) 0 C) C) 0 0 0 0 CD 0 CD CD CD 0 0 0 CD C) CD C) C> 0 0 CD CD 0 C� 0 0 C) CD 4) C) C:) " 04 C\l C\l C\l 04 04 04 " 04 CN Cq Cq " Cq N Cq 04 C\J C4 N 04 C> " 04 C%4 C*4 0 CD C) C\l N N CIJ N Cq CN N Cq N 04 C14 N 04 C\l 04 " 04 C\l C4 04 04 CD cq N cq N L6 L6 Lh 6 L6 6 6 Lh Lh 6 6 6 6 Lh us L6 L6 6 us 6 Lh Lh 6 6 6 6 6 6 6 r- r-_ rl- rl- rl- P.- P- r- r-- r-- rl- r- r- rl- r- r-- rl- CD co co CC) co 04 04 04 (N 04 LI) 0 U) 4) 4) 4) E a) E cu =3 > 4) 0 (1) rr 0 CL cu U) .,n 0) (D Z; C: cu in F- L) C < 0 m 2, 0 E 2:! 0 M — CD .0 E2 = 0 m 16 d 0) a) L) co :3 (a -F, 0 E (n cu < U) (D 0) W a) 0) CD- CL a 0 C M 0 a) 3: 13 2 (D cn -Fu U) CL — a) CD a) -R m m L) X a) LL (5 a- U) U) (n < 0 a. LL AG) 75E2 cE C) L) 80 L) - m a) 0 CL 0 > m 4.2 o a) , M zs '4= E 0 6 M 0 0 0 0 E- s Q) o) -o >1 0 CD ca < U) a) 0 a) 0 m 0 0) CL Mn cm Ln - 8 z = = o s m c c 0 . :� (n E c < S a) —0 -,5 -Z� 2- C) a t o o w CD 0 0 0 E -c5 -c5- c E cu '5)'E L) u C: 2 2 4) -Z5 0 0 0 0 0 -0 C (D w 0 0 0 000000 a) < CL < U) U) U) < 2 U) 1D U- 0- :Cc: o 0 0 LD CD r-- Go C14 C%4 LL E rr (D CL 0 -a 0 I-- :,4 C') LO co co CD m -,t -,t C) m p 0) 00 C'4 LO Co 00 ;t t (0 C> CD --t ce) Lo C> 40 CD LO 1 r- 40 cli le omoNrl-om"r-- N w a w r- CD m 'IT m r- N m v CD 0 0 LO F. Ln CL Ot (C� (Q LQ n Ci LQ C\L "IL cl� LQ P-� C� Ci CL C�L p-:. (q rl-L Cli oc� rl-� Ci c:I cl q C,� Cli m M Cl) le CD C14 C\l CIJ "'T Cl) LO LO r- 00 0) — V) (D — M 04 It 1- 00 �T t- le C) r- C) 0) 'IT r-_ > tm (o N N� 1- (D CIJ r- LO CO 0 04 " 0) LO 04 N C\l C\J C14 CD — C14 M tl- C%l co w W) cq CN co CD r- — CY) LO (D C\l I- co P- N m cli Cl) 06 Cj 4 0 CD C) m 0 0 0 0 m r-- m m 'IT co r- N m (0 r- 0 0 LO 0 Nr 4) 9 9 9 9 9 1r cp 7 C� 9 C? C? C? 91 cp cp T 7 9 R —1 9 04 0 0 (0 CD (D w w w w w w w m m w — C� C; (6 flL co CO LO r.- 0 — — — — — — — — — — — — — — — — Cl) Cl) 0) co r— It I- It 'IT It -r 'IT qT It IT IT Nr Nt 't It 0 C? C? IT "T IT IT IT i IT IT 'IT IT i IT IT '7 17 i 9 C? L? 0 0 CD 0 0 0 CD CD C) 0 C) CD 0 0 CD 0 0 CD CD 0 CD C) CD 0 C) CD CD C) C) 0 C) C) 0 0 0 0 CD 0 CD CD CD 0 0 0 CD C) CD C) C> 0 0 CD CD 0 C� 0 0 C) CD 4) C) C:) " 04 C\l C\l C\l 04 04 04 " 04 CN Cq Cq " Cq N Cq 04 C\J C4 N 04 C> " 04 C%4 C*4 0 CD C) C\l N N CIJ N Cq CN N Cq N 04 C14 N 04 C\l 04 " 04 C\l C4 04 04 CD cq N cq N L6 L6 Lh 6 L6 6 6 Lh Lh 6 6 6 6 Lh us L6 L6 6 us 6 Lh Lh 6 6 6 6 6 6 6 r- r-_ rl- rl- rl- P.- P- r- r-- r-- rl- r- r- rl- r- r-- rl- CD co co CC) co 04 04 04 (N 04 LI) 0 U) 4) 4) 4) E a) E cu =3 > 4) 0 (1) rr 0 CL cu U) .,n 0) (D Z; C: cu in F- L) C < 0 m 2, 0 E 2:! 0 M — CD .0 E2 = 0 m 16 d 0) a) L) co :3 (a -F, 0 E (n cu < U) (D 0) W a) 0) CD- CL a 0 C M 0 a) 3: 13 2 (D cn -Fu U) CL — a) CD a) -R m m L) X a) LL (5 a- U) U) (n < 0 a. LL AG) 75E2 cE C) L) 80 L) - m a) 0 CL 0 > m 4.2 o a) , M zs '4= E 0 6 M 0 0 0 0 E- s Q) o) -o >1 0 CD ca < U) a) 0 a) 0 m 0 0) CL Mn cm Ln - 8 z = = o s m c c 0 . :� (n E c < S a) —0 -,5 -Z� 2- C) a t o o w CD 0 0 0 E -c5 -c5- c E cu '5)'E L) u C: 2 2 4) -Z5 0 0 0 0 0 -0 C (D w 0 0 0 000000 a) < CL < U) U) U) < 2 U) 1D U- 0- :Cc: o 0 0 LD CD r-- Go C14 C%4 LL E rr (D CL 0 -a 0 I-- A Wil 03 0) cu 0 0 04 00 0 (D C) N 0 0 0 COD U) 0 It 00 1: co -0 N LO CO to to N co P— I-- C14 co —1 IT IT C14 0 r— 0 0 LL 2� 21 0 0 cu cu Q- 0 -j r— — C) t -- r— -0 -0 0 tl- to m C) 00 cn d < & (d a C: C: c v 0 1* M '4ZT Lr) a) cn cn u) 0) c c c -a 12 12 2 D — — — Q) — 73 — 0) — cn C: C: C: — — c c c iF — (o 2 -T < m 0- (L 0- cl CD Go r- C) C) m 0 a) fl- 0 C) r- ce) co V) — 0 Go ui wi cr� 6 6 Le C0 CIO LO r- r- co - (D I�r cl) CD C) Cl CD CD C:) CD r— C� C) r -- r- 0 0 1 - (0 C.0 (0 m ce) Cl) 'IT 0 0 le C6 C� C6 C5 6 a; 0) 0) Ln P� r— im 00 co It Cl) co 0) cu 0 0 04 00 0 (D C) N 0 0 0 COD U) 0 It 00 1: co -0 N LO CO to to N co P— I-- C14 co —1 IT IT C14 0 r— 0 0 LL 0 0 0 cu cu Q- 0 -j r— — C) t -- r— C14 0 tl- to m C) 00 cn d ci & (d a Lr) v C) Cl) 1* M '4ZT Lr) a) r- C) r- r.- r- 0 r- 1�- 't Lf) Lc) U') in It It 4t U) 0 0 04 00 0 (D C) N 0 0 0 COD U) Ci It 00 1: co -0 N LO CO to to N co P— I-- C14 co —1 IT IT C14 0 r— 0 0 0 0 cu 0 Lo LO LO co 00 Go : N co co Go LO I�t cli Z LL 0 c 2 .2 —0 E >1 co 0- C:) I:r r - C) Ln C) L6 0) V-: C14 0) co (D C14 (6 C) CD CD C) C) C> Ld Ld N 04 LO C14 oo r— CV 0 0) (D CO 0 0 — 0 0) 0 73 In - M —1 IT IT 0 r— 0 0 0 cu 0 c 0 (D co (0 rl� C6 r�L 16 I'L P -L c U� r�� 0 C� C� ll� O� O� C� Ci 1� Q) — — 0) — — — IL — C:) m Cl) cl CD Go co Go 0 a) (D C) 0) C? 1-7 �7 — Cl) CD IT U? Lc) "T le Cl) CIO co co C) (D C) CD C) Cl CD CD C:) CD CD Cl C) (0 C.0 (0 m ce) Cl) 0 CD C,) m C0 eq C) m V) m CD C) 0) C) U) m Lo LO LO co 00 Go : N co co Go LO I�t cli Z LL 0 c 2 .2 —0 E >1 co 0- C:) I:r r - C) Ln C) L6 0) V-: C14 0) co (D C14 (6 C) CD CD C) C) C> Ld Ld N 04 LO C14 oo r— CV 0 0) (D CO 0 0 — 0 0) 0 73 In - 9 —1 IT IT 0 r— 0 0 0 cu 0 C 0 (D co (0 rl� C6 r�L I'L P -L c U� r�� 0 C� C� ll� O� O� C� Ci 1� L) — — 0) — — — — 0 In LO Lr) CD Go co Go 0 0 L? 0) C? C) L? ci — Cl) CD IT U? Lc) LO LO 0 C) C) I C) 0 C� 0 CD Cl C) 0 C) 0 C) 0 C:) C) C) C) C) C) (0 C.0 (0 m ce) Cl) 0 CD Lo LO LO co 00 Go : N co co Go LO I�t cli Z LL 0 c 2 .2 —0 E >1 co 0- C:) I:r r - C) Ln C) L6 0) V-: C14 0) co (D C14 (6 C) CD CD C) C) C> Ld Ld N 04 LO C14 oo r— CV 0 0) (D CO 0 0 — 0 0 In - 9 —1 IT IT 0 r— 0 0 0 0 0 (D CD 0 (D co (0 rl� C6 r�L I'L P -L U� r�� 0 C� C� ll� O� O� C� Ci 1� L) — — 0) — — — — C) C? (M C? ::� 0 L? I? 0 L? 0) C? C) L? — Cl) CD IT U? 0 0 C) I C) 0 C� 0 C:) C) 0 CD 0 0 C) 0 C) C) C) C) C) (0 C.0 (0 m ce) Cl) 0 CD CD co Cl) n C) (D ce) C) C) (D U) Cl 0 U) m — LO LO I . Lh 0) L6 L6 us 0) m 0) 0 CD 0 C) a 04 0 0 4 CD c LO LO cq 04 cli co co cn m Cl) 4) E ce) 4) cq E CNI C\l CY) ce) to LO Lo Cl) 0 04 r_ m 0 m CN 0 U) cr 'a E 'D 4) E '0 (n Cr a) C:) C') C: T 0: 0 --a U- C:) .3 .3 U- U - U) 4) C: 0 =) 4) Cl) 'our 0 0 4) cr 4) -0 4) E 0 a) E U) to 4) c D c a 4) CL E 4) CL 4) r. 4) 0 In E E Z -2 E E E CL 0) m CL a) 4) (D Q) > q a) U) > m m a) it 0 0 U) a) 4) 0 cm Im 4) a) a tm 0 tm 0 LO fn a cu 0 a) 0) L) 4) W 0 0 0: > 4) u) Q) "0 (D — > 0) CD > 4) > 4) :�, E 0. E —` 0- E E 0) c di w E m tm 'a 'a 0 E E 0 E LL .2 w E 0 E :2 E > 0 0 0 > o - 0 CL a. (D cr w z E —' —' —' E (D C-) E a a! m 0: z E :3 =3 = 000 E E a) E E 0 cc 0) 0 0 0 -0 L) co C 0 0 :3 C: E2 co c E2 L) E2 4) (D S 'E E Mu 2 -a -a c 0) E -OS) 0 w U) U) c c c 0 E 'n -6 (coo —0 C' —0 c- —0 —0 :3 = 0 a) 12 2 2 o C': 0 0 C3 2 0 0 0 co 0 L) 0 ul �— 0 0 0 0: 0 'a Ln C%j an C) CM CD C) CD eq LL Ap. Wo . 0 15 0 0 0 L) 0 cu 0 0 0 0 0 0 (1) t5 CD 0) 0) cm 0) 0) 0 0 .= .0 :t! 'D 2 2 .2 cu cu cu .2 2 2 ca m m m C: Mn T "0 '0 0 Q 0 L) L) () c CL 2 co a) a) a) CD a) a) co — S2 0 (2) > (1) > .9 it L 2-1 x a) 0 0 a) a) a) a) (1) a) w a) (1) 0 C.) U) En En (D (n U) CD 0 Zi 25 U) 'IT a) CD 04 a) a) a) 'a 'a �o (1) a) (1) 'a 'a 'D C; L) 'T CD CD a) It 0 0 0 0 0 0 L) CD co >- C,) CL CL CL U) U) '0 c _0 c :: :: — 5 15 LL (n :3 =) :3 .2 Q) CD a) c LL LL 0 0 0 0 0 0 E C: . 9 C: cn u) u) (n u) E2 U) 2 =) 0)— LL 0- a- E E E �5 - — IT � � 2 .2 -0 E :3 cu m -j 2 0 Lo cn u) a c c cn U) (n C: c C: > 0 0 0 0 2 12 T E2 12 P 0 11= cn c cn C: > > > -0 0 2 [2 cu 0 m 0 0 0 > > > 0 0 0 < 0 -1 (D (D -j E 2 2 2 :2 2 C> 0 C� pl- 0 1- 'IT 11, 0 1�1 0') CD N co It C) ;z m 0 N to C) 0 CD 40 cq 0 CD m LO - -�r C�j - LO 0 C) — co (0 0 CD (D V) rl- CD CD 0 0 CD 0 00 It (D co I-- 0 gn tm C6 .5 .0 L6 d as 6 T-7 06 r-: m �r 6 a; Cq C� -: G� cr; 4 06 1,: — CO = to (0 C> Itt (0 ;: CD IT CD 0 N LO LO — a) M CN CN CD (0 fm — W — N w M Cq ci C4 cli cl; (D It CD LO t 0 LO 0 40 0 0 Co Lo CD CN CD 0 CD CD O)o N CD C) to co O)o I-- (.0 U") rl- w CD CD o CD 0 C) CD 0 Cl 00 d- N (D m CD cq Cq LO Cl m co E cli C6 r-: 06 6 L6 d I': d L6 6 6 6 6 cr� 1-7 C\i -�i td " flo C) CD (0 (D (n 0 to LO W) CN V) 00 CL rl. cq m N C> m C4 cm N N CL U) It , C� m s2 0 CO 0 40 CN 40 CO IT CN C) Ln C=� C� C) Ci CD C=� 0 C� 0 C� N C� fl. C� C) 00 V) V� Cli Cli Ln C� mo > o) Ln N LM Lo le C) CD w cv CD 0 w — 0 Ln (N -�t FO t- CD m 0) m co m w — CN Ln pl- Co 0 C4 Cq C4 0) C� 0 CD 999 — M C) 9 9 ll� CD 9 0 17 9 9 U? — CN 9 9 0 m 0) , �2 0) m m U? U� Iq m N �; �; 0 �; �; L) CD CD 0) (D Im 'T L? C? C? M r-- r� m Nr CD C� 0 CD CD CD 0 6 C) 0 CD CD 0 C) CD coo 6 0 C) C) CD C) LO LO E 0 CD 0 9 9 9 (D (D C.0 1? C? C? 0 9 co N CN N 19 19 co 00 co 6 6 v �t 0) — — — — — — N 9 N �) CD 0 0 9 9 9 co co co cn co — — — 'T v — — — It I�t LO LO — — — (0 (0 CD — — — (D (D (D cr 0 E C: :3 a) U- cn a) (D CL a) 0 :3 06 U) 4) rr 0 CL 0 =3 tr (D 7u- a) 0: >1 0 a) U 0 2 LL a) w C: cu 0 0 0 0 =3 0 tn 06 a) of 0 0 (D 0 w :5 'Fu rr 0 CD 0) '25 0 a) 0 — 2 0 LL 76 CL Z5 V 0 E m LL U) CL CL = 0 o 0 co I c (D U) a) .2) u (1) 'a "101) -a c= LL x (1) 2D 'D 0 a. CL — w z z �: C (n a) M — 'a z 3: 0 0 E E 0 E 0 0 Cli 65 ad a) > C: 0 4) z 6 c co 4) Z w w D (r (D cn S? L ]'� 2 0 0 x i! it 0) CD I C: cn 4) Z C: - cn m '00 cm a) a) U) r, LLJ (D CD .6 (n U) U- = 0 c '0 0 aj "0 0 can E 0 0 -0 cn 2 Zi r:) m M 0 m Q) 0 a) 0 0 0 0 0 0 0) (D 0 > Z M LL -i U- -i -i cr co U) C) 0 LL CM Ln co C4) LL. le A Wo x LLI a 0 0 a U) V m t3) iz� -0 0 0 L) 0 0 tl- - C:) 0 C) �T C) Go CL OCL q It 0 0) co C%4 04 04 0 -(D 04 ce) C:) in 0 C� C? C? 9 9 0 cl) 04 C� " q . M (D — 'T CD C? C? C? C? C) CD 0 CD C) CD CD CD C) CD CD C) CD CD 0 C) 6 L6 L6 L6 r- rl- I- r - co (D (0 (0 a) 0_ 0 0 - ti C) M I�T 0 0 0 04 r-. 0 E q7 CT cs 0 — 0) CD (1) a) a) (1) cc :3 m U) a) CD a) 16 1� -Z6 , m C) — — CM a) cn E E E E 15.0 (n 0) Im (n C -a — 0 c CD cn C: .0 0 cn m o �: — cm 0 0 CL — 0 0 a) a) a) C: C: 0 (D (� co w w w C2. 0 CO Lf) Ln Ln u) 0 L) m :3,5 *5 *5: CD (D 04 m . > > > > C) co N a) a) a) r-- 0 0 0 0 - G� co ci w w w to w w Ix w rr 0 cli (0 co C:) C) C> (0 m C) Cl) C) ;t in r- CD CD 0 V) CD CO 0 (D LO — C) CD LO CN C) 'T 0 r-: r,: CT "Zi 4 -� C4 4 vi d -e V) CO — LO LO Lo CD — CD Ln C:) U') Cl) m — cy Ln co CD cu 06 C6 C%i LO co C) 9 E 9 00 C) C� C� 0 r-- 04 C\l 9 LO a) f- CD 1- 0 r- (D C) U) cl! C� -: C! It v! CR C! --: 0. 0 C14 cli C:) co co CO LO CO le co CN IT -6 > @ 1�2 z, 0 tl- - C:) 0 C) �T C) Go CL OCL q It 0 0) co C%4 04 04 0 -(D 04 ce) C:) in 0 C� C? C? 9 9 0 cl) 04 C� " q . M (D — 'T CD C? C? C? C? C) CD 0 CD C) CD CD CD C) CD CD C) CD CD 0 C) 6 L6 L6 L6 r- rl- I- r - co (D (0 (0 a) 0_ 0 0 - ti 0 cu a) L) CL E 0 CL E 0 06 0 06 0) C) CD .2 c cu 0 a) 2 U) a) a) = .L) U) > en C: cu - .- w a) d) U) c 0 0 3: C 0 cL 2 c: < a) (D cl 0 z 0 0 cli m C) M I�T 0 0 0 04 r-. 0 E q7 CT cs 0 — 0) CD co v cc :3 m U) a) CD a) C14 N C) — — CM a) cn cl! C� 15.0 (n 0) Im (n C -a — 0 c CD cn C: .0 0 cn m o �: — cm 0 0 CL — 0 0 -0 C: C: 0 (D (� co 0 C2. 0 CO z 0 L) m CC) m CD (D 04 m 0) C14 C) co N 0 1- r-- (6 ce - G� co ci U') to w rr 0 LO Lo 00 co CD (D cq co m m C� co 0 C! C� — P,-� C� co to 0) (0 to V) W) — cl) W) 0 cu a) L) CL E 0 CL E 0 06 0 06 0) C) CD .2 c cu 0 a) 2 U) a) a) = .L) U) > en C: cu - .- w a) d) U) c 0 0 3: C 0 cL 2 c: < a) (D cl 0 z 0 0 cli m C) M I�T 0 0 0 04 r-. — 0 r - C; q7 CT cs 0 — 0) CD co v co Iq ci ci C14 N C) — — CM ;r le 0 N cq IT cl! C� — C� -L Ot 0) Im LO 0) tR CC) co CC) co 0) r- CC) to LO LO U) CD � rl- LO 0) I:t co CN CN W (D cc LQ Cli Oc� C%! It tR tR E Ci co co m LO cm E 04 0 U) C14 0 Ln P- M C, 0 cm C14 d) w 4) w 00 co Cl) CM 0 (D to w rr 0 LO Lo 00 cvi cq te fA U) 2 Ln CD 2 a_ cy Ln co CD cu C:) LO co C) 9 E 9 E C� C� a. 9 U) C� —. N U) CN CL 0 co co C14 0. 0 cli co Cl) N U� O� 17 7 cl C� -6 > @ 1�2 z, W) W) LO LO 0 Cl) m 0) c Cl) a) c 0 IL U) (n a) > CO 0) co — — — U? 0 (D C? m a) C? 'IT IT IT 0 (D C:) C� CD > -j 0 L) C: C� C:) CD 1:3 0 C) () E c CD c CD C) C) 0 CD CD C) 0 :;� 1 C: a) U) C C) -j CD C:) 0 C, cu :3 En CD CD C) C) co co 00 co OD IM C: 0 Cl 0 E E c: 00 00 00 CD cn 75 c 0 co co co C CD CD C) 0 CD C: U) CD 0 0 a) cu S 1� '56 C) 4, c 0 C) CD L6 L6 us L6 6 0 6 0 6 6 6 C� w 2 o C� C� C� r- rl_ r- r- r- 'T I�t Ilzr 11, 'r m L) a. NT Nt (D (D CD (D co It �T 'IT It (D 'T I- U) r_ U) U) E U) U) P E (D E 0 U) rr 0 rr cn -a 0 '0 d) w 4) w U) 4) 0 to rr 0 4) U) U) fA U) 2 2 a_ cy 0 - cu E E -u) '0 a. 0. U) 0 U) 0 CL 0 0. 0 u 0, 0 'a to c U) C: a) (D �2 E In -6 > @ 1�2 z, C) 0 0 E = :3 U) E C2 a) c IL U) (n a) > CO (1) -- (2) c: E CL co o .0 ca 0 0 (D m a) 4) z Q) a) rn CL :3 > -j 4) L) C: a) 1:3 0 a) C () E c CD c 4) 0) 0 c a) :;� 1 C: a) U) C 4) -j C, cu :3 En cu CL :n IM C: 0 0 E E c: CL cn 75 c 0 a. -i -Fa C: U) 0 a) cu S 1� '56 -0 4, c 0 c '5� 0 0 '0 c 0 '5� w 2 o I-- a) o a) 0) a) 0 :3 1- m L) a. w CD -,= C L o CL (D LU M z (D w m m LO C4 LL W cn co co V C%F cli (6 C)o 0) a� IR Iq C14 N Lr) 60. 1 643� w LO 9 LU LU 11 00 LU _j LO U) < 9 5: F. le LU Z w _j w -i w CL U) 0 (L 5; w L, 0 0 U) =3 co C? L) ll� C� C� u) a) 9 a) =) d) c U) 5 Ln tn ch a) U) C -0 =3 — 0 c CU (n �o 0 D) 0 a) 0 0 a) CL 0 a) a) CL 0 m z 0 C) m 0) C) (3) C) (7) 'T C) cl) — IT Cl) 00 C:! cl! (0 LO cli N N 0) N I'li rl.: CD 0) C) 0) 0 (D �t cl) — v CN C� Cli f"i 1% (D LO N CM 04 0) cli LQ Vi C14 cn co co V C%F cli (6 C)o 0) a� IR Iq C14 N Lr) 60. 1 643� w LO 9 LU LU 11 00 LU _j LO U) < 9 5: F. le LU Z w _j w -i w CL U) 0 (L 5; w 0 LO 00 0 0 U) =3 C? ll� C� C� 9 c 0 a ch m 0 C\j AQ m _0 0 0 17 -0 0 CU a) 0 cu C0 z C) m Cl) 00 (D IT 0) Cli I'li rl.: rl- LO Cl) r- CN 1- f"i 1% r"i pl.� 04 N CN C14 — T- cl) OD CD (D I�T — c C-4 W r- C,4 C6 vi tz Ld C-; r— f- It N 1- r% rli r1i r% 04 C14 04 CN cn co co V C%F cli (6 C)o 0) a� IR Iq C14 N Lr) 60. 1 643� w LO 9 LU LU 11 00 LU _j LO U) < 9 5: F. le LU Z w _j w -i w CL U) 0 (L 5; w 0 LO 00 0 0 00 C) C? ll� C� C� 9 C� C� CN co m CNI C\j Cl) CN 17 7 C� C� 17 Cl? (3� Cl) C0 Cl) co 0) 0) LO Lr) C? C? 0 C> C) 0 C> CD C) 0 C) 0 C) 0 C) 00 00 00 C) C) C) 0 00 00 u a C) 0 C) 0 0 LO co 0) to LO 4) LO LO LO LO U) 00 u 00 00 E co 0 co CD 0) a) E 0 U) m rr w a, u .4) 6 u �o CL IL (D a) IL a) 0 a) a 0 0 u 4) 2 IL 2 0 LL 0 0 c a. " 'a a. E E .2 -0 , 0 — C u 0 0 0 73 m 0 0 E c x M x 4) -0 0 .2 0 0.0 w 0 w cp a) t = 0 m U) L) c 2 0 06 0 c 06 0 cu CL =3 a 0 x m co 0 0 W U. cn 0 LL. C) C: 0 [2 3: 0 c 0 c 0 0 a) 1-- 0 (D a) 0 (1) 0 0 w co z LL. 0 m z to LO LC) co IT to LL. cn co co V C%F cli (6 C)o 0) a� IR Iq C14 N Lr) 60. 1 643� w LO 9 LU LU 11 00 LU _j LO U) < 9 5: F. le LU Z w _j w -i w CL U) 0 (L 5; w Memorandum Date: January 13, 2005 To: Board of County Commissioners Mike Maier, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find December 2004 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriff's (255), 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 RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA District Attorney Finance/Tax Veterans Property Management Surveyor Total Revenues TOTALRESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA BOCC District Attorney Finance/Tax Veterans Property Management Surveyor Non -Departmental Contingency Transfers Out TOTAL REQUIREMENTS Appropriation Transfers NET (Resources - Requirements) GENERALFUND Statement of Financial Operating Data Six Months Ended December 31, 2004 IYear to Date Revised Bud Actual I Variance tFY % I coil. % $4,700,000 $4,994,433 $ 294,433 100% 7,147,500 12,863,485 5,715,985 835,289 905,922 70,633 512,396 610,859 98,463 692,750 1,098,800 406,050 6,993 8,557 1,564 164,405 85,105 (79,300) 108,725 139,613 30,888 4,900 5,036 136 33,150 48,289 15,139 93,500 127,668 34,168 9,599,608 15,893,334 6,293,726 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 14,299,608 20,887,767 6,588,159 50% 1,688,667 1,570,964 117,703 591,024 574,597 16,427 25,689 19,056 6,633 287,681 281,334 6,347 1,696,487 1,539,582 156,905 393,283 367,148 26,135 75,884 67,924 7,960 71,119 57,912 13,207 81,968 78,256 3,712 407,570 385,129 22,441 969,855 - 969,855 6,289,227 4,941,902 1,347,325 5,162,258 4,802,852 359,406 11,451,485 9,744,754 1,706,731 2,848,123 11,143,013 8,294,890 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Revised Year End $ 60% Budget Projection Variance 1,385,500 106% $4,700,000 $4,994,433 $ 294,433 90% 14,295,000 14,295,000 - 54% 1,670,578 1,670,578 - 60% 1,024,792 1,124,792 100,000 79% 1,385,500 1,885,500 500,000 61% 13,986 13,986 - 26% 328,810 328,810 - 64% 217,450 217,450 - 51% 9,800 9,800 - 73% 66,300 66,300 - 68% 187,000 187,000 - 83% 19,199,216 19,799,216 600,000 87% 23,899,216 24,793,649 894,433 47% 3,377,333 3,277,333 100,000 49% 1,182,047 1,182,047 - 37% 51,377 51,377 49% 575,361 575,361 - 45% 3,392,973 3,267,973 125,000 47% 786,565 786,565 - 45% 151,767 151,767 - 41% 142,237 142,237 - 48% 163,936 163,936 - 47% 815,140 815,140 - n/a a) 1,939,710 - 1,939,710 39% 12,578,446 10,413,736 2,164,710 47% 10,324,515 10,324,515 - 43% 22,902,961 20,738,251 2,164,710 b) 996,255 4,055,398 3,059,143 6% 0% 0% 10% 36% 0% 0% 0% 0% 0% 0% 3% 4% 3% 0% 0% 0% 4% 0% 0% 0% 0% 0% 100% 17% 0% 9% a) The Contingency in the Adopted budget was $2,252,265. The reduction of $312,555 is due to (1) transferring $296,255 of appropriation to other funds, (2) transferring appropriation to "Transfers Out": Adult P & P - $6,300 and Legal - $10,000. b) The Unappropriated Ending Fund Balance in the Adopted Budget was $700,000. The increase of $296,255 is due to transferring appropriation to (1) Adult P&P - $71,255, (2) CDD COPs Debt Service - $215,000 and (3) Legal - $10,000 RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1 065 -Court Assess. Discovery Fee Food Subsidy Juvenile Crime Prevention Inmate/Prisoner Housing Inmate Commissary Fees Contract Payments Miscellaneous MIP Diversion Fees Interest on Investments Leases Total Revenues COMM JUSTICE -JUVENILE Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Budget Actual Variance I FY % Coll. % $ 314,190 $ 199,202 $ (114,988) 100% 92,898 40,270 (52,628) 19,669 21,618 1,949 2,019 2,401 382 16,700 17,697 997 114,970 65,406 (49,564) 25,000 44,730 19,730 750 1,053 303 193,977 95,146 (98,831) 50,000 28,360 (21,640) 719 1,401 682 2,125 2,784 659 17,435 16,109 (1,326) 536,262 336,975 (199,287) 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Transfers In -General Fund 2,449,520 2,449,520 - 50% Transfers In -Sheriff 26,250 26,250 - 50% TOTALRESOURCES 3,326,222 3,011,947 (314,275) 50% REQUIREMENTS: Expenditures Juv Community Justice Juv Resource Center Contingency n/a a), $ 314,190 $ 199,202 $(114,988) 22% Year End 185,796 Budget Projection Variance n/a a), $ 314,190 $ 199,202 $(114,988) 22% b) 185,796 150,350 (35,446) 55% 50% 50% 39,338 39,338 97,547 59% 195,093 - 195,093 4,038 4,038 53% 33,400 33,400 - 28% c) 229,939 261,622 31,683 89% d), 50,000 75,000 25,000 70% % 1,500 1,500 - 25% e) 387,953 387,953 - 28%, f) 100,000 100,000 - 97% 1,437 1,437 - 66%-.11- 4,250 4,250 46% g) 34,870 33,032 (1,838) 31%,- 1,072,521 1,091,920 19,399 50% 4,899,039 4,899,039 50% 52,500 52,500 48% 6,338,250 6,242,661 (95,589) 1,841,891 1,668,252 173,639 50% 45% 3,683,779 3,662,028 21,751 1,229,689 1,227,283 2,406 50% 50% 2,459,378 2,459,378 - 97,547 - 97,547 50% n/a 195,093 - 195,093 TOTAL REQUIREMENTS 3,169,127 2,895,535 273,592 50% 46% 6,338,250 6,121,406 216,844 NET (Resources - Requirements) 157,095 116,412 (40,683) 121,255 121,255 a) Actual "Beginning Net Working Capital" less than budgeted due to FY 03-04 expenditures related to employee reclass & temporary help greater than projected and a change to an interfund contract. b) Sex Offender Grant reduced by $25,000; JAIBG reduced by $10,446. Pending reimbursements total approximately $43,759 for JAIBG, CWS Contract with South County, and Sex Offender Grant. Anticipate reimbursements to be received in January. c) JCP costs reimbursed quarterly for Maplestar, a foster care treatment facility. Increased from 8 to 9 beds November 1 st. d) Outstanding billing as of 12/31/04 totals $7,970. e) Behavioral Rehabilitation Services billing through December totals $148,908. Additional revenues will be realized through CWS Contract with Solid Waste and the contract with Central & Eastern Oregon Juvenile Justice Consortium (CEOJJC). f) Level 7 funding reimbursed quarterly. Each quarter reimbursement will be $24,414. g) Proposed Lease to BOCC with Rimrock Adolescent Treatment for Jan -June 2005. Year End Projection revised accordingly. SHERIFF Statement of Financial Operating Data Six Months Ended December 31, 2004 Transfers Out TOTAL REQUIREMENTS - 130,250 208,000 (77,750) 50% 80% 9,260,285 9,077,511 182,774 50% 49% 260,500 260,500 18,520,566 18,520,566 NET (Resources - Requirements) 100,000 5,785,467 5,685,467 - 975,046 975,046 IYear to Date [ Yea r I Budget I Actual I Variance FY%j Coll.% I B udget Proje,c RESOURCES: Beg. Net Working Capital $ 200,000 $1,028,627 $ 828,627 100% 514% $ 200,000 $1,028,627 $ 828,627 Revenues Tax Revenues - Current 5,975,009 11,065,277 5,090,268 50% 93% 11,950,018 11,950,018 - Tax Revenues - Prior 203,300 209,158 5,858 50% 51% 406,600 406,600 - Federal Grants 33,750 34,571 821 50% 51% 67,500 67,500 - U.S. Forest Service 36,000 30,000 (6,000) 50% 42% 72,000 72,000 - State Grant 57,774 39,772 (18,002) 50% 34% a) 115,548 94,192 (21,356) SB #1 065 -Court Assess. 21,250 21,618 368 50% 51% 42,500 42,500 Marine Board Lic. Fee 42,500 - (42,500) 50% 0% b) 85,000 85,000 Narcotic Task Force Grt. 55,000 82,500 27,500 50% 75% 110,000 110,000 - Transp. of State Wards 1,500 3,172 1,672 50% 106% 3,000 5,000 2,000 SB 1145 649,864 780,106 130,242 50% 60% c) 1,299,727 1,560,212 260,485 City of Sisters 163,645 163,645 - 50% 50% 327,290 327,290 - Security & Traffic Reimb 60,100 15,560 (44,540) 50% 13% d) 120,200 120,200 - Seat Belt Program 1,750 4,250 2,500 50% 121% 3,500 6,000 2,500 Inmate/Prisoner Housing 500 2,287 1,787 50% 229% 1,000 5,000 4,000 Contract Payments 8,608 8,936 328 50% 52% 17,216 17,216 - Inmate Commissary Fees 25,000 31,901 6,901 50% 64% 50,000 50,000 - Soc Sec Incentive -Fed 1,500 800 (700) 50% 27% 3,000 3,000 - Miscellaneous 11,100 5,667 (5,433) 50% 26% 22,200 22,200 - Medical Services Reimb 6,000 6,896 896 50% 57% 12,000 12,000 - Restitution 2,500 545 (1,955) 50% 11% 5,000 5,000 - Sheriff Fees 73,500 54,800 (18,700) 50% 37% 147,000 147,000 - Court Fines and Fees 116,500 60,771 (55,729) 50% 26% e) 233,000 125,000 (108,000) Impound Fees 37,000 41,000 4,000 50% 55%',, 74,000 74,000 Interest 15,108 11,728 (3,380) 50% 39% 30,215 30,215 - Interest on Unsegregated 1,247 3,308 2,061 50% 133% 2,493 3,308 815 Rentals 21,667 21,973 306 50% 51% 43,333 43,333 - Interfund Contract 211,113 84,681 (126,432) 50% 20% f) 422,226 422,226 Transport Reimbursements 2,500 628 (1,872) 50% 13% 5,000 5,000 - Sale of Eqp & Material 5,975 5,975 50% n/a - 5,975 5,975 Total Revenues 7,835,285 12,791,525 4,956,240 50% 82% 15,670,566 15,816,985 146,419 Transfers In 1,325,000 1,042,826 (282,174) 50% 39% 2,650,000 2,650,000 - TOTAL RESOURCES 9,360,285 14,862,978 5,502,693 50% 80% 18,520,566 19,495,612 975,046 REQUIREMENTS: F _ExT _9/61 EXPENDITURES & TRANSFERS Sheriffs Division 615,430 645,355 (29,925) 50% 52% g) 1,230,859 1,548,078 (317,219) Automotive/Communications 409,742 536,078 (126,336) 50% 65% h) 819,484 819,484 - Investigations Division 796,837 842,634 (45,797) 50% 53% 1,593,674 1,593,674 - Patrol Safety Division 3,285,334 3,276,640 8,694 50% 50% i) 6,570,667 6,570,667 - Records 300,226 279,075 21,151 50% 46% 600,452 600,452 - Corrections (Jail) Div. 3,142,212 2,910,191 232,021 50% 46% j) 6,284,424 6,284,424 - Transport/Court Security 87,927 66,308 21,619 50% 38% k) 175,854 175,854 - Emergency Services 52,911 48,694 4,217 50% 46% 105,821 105,821 - Special Services Division 205,672 189,006 16,666 50% 46% 411,344 411,344 - Training Division 75,134 75,530 (396) 50% 50% 150,268 150,268 - Contingency 158,610 - 158,610 50% 0% 1) 317,219 - 317,219 Transfers Out TOTAL REQUIREMENTS - 130,250 208,000 (77,750) 50% 80% 9,260,285 9,077,511 182,774 50% 49% 260,500 260,500 18,520,566 18,520,566 NET (Resources - Requirements) 100,000 5,785,467 5,685,467 - 975,046 975,046 Sheriff Notes Statement of Financial Operating Data Six Months Ended December 31, 2004 a) Due to funding reductions at the Federal level the Local Law Enforcement Block Grant will be $21,356 less that budgeted. Year to Date variance due to timing of Emergency Planning Grant reimbursement. b) Marine Board billing is completed semi-annually in January and July. c) Reduction to Community Corrections funding has been fully restored statewide. Year End Projection revised to $1,560,212. d) US Forest Service reimbursement for fire overtime has not been required to date. e) Revenue not as high as anticipated due to personnel changes on traffic team. Revenue expected to increase as traffic team is fully staffed. Court Fines & Fees will be below budget by $108,000 at year end. f) Variance due to timing on receipt of Title 11/111 reimbursements and Code Enforcement Service Transfers from Federal Forest Title 111, CDD and Solid Waste Funds. g) Year End Projection adjust to include budgeted contingency for aniticipated expenses. These expenses include microwave project, Street Crimes Unit, uniforms and other items identified by the Captains and approved by the Sheriff. h) Year to date actual includes annual interfund contract payment of $196,874 to Deschutes County Communications System (Fund 245) paid in September. i) Year to date variance due to timing on filling open positions and payment of prisoner board invoices. j) Year to date variance due to timing on filling open positions. k) Year to date variance due to timing of expenses related to Marine Patrol. Expenses will be incurred in April to June. 1) $205,329 of the Adopted Budget Contingency of $522,548 has been appropriated as Personnel ($154,433), forensic software ($2,700), evidence lockers ($16,000), space saver file system ($15,811) building remodel costs ($9,035) and sheriff K-9 ($7,350). RESOURCES: Beg. Net Working Capital Revenues Medicare Reimbursement State Grant Child Dev & Rehab Center State Miscellaneous STARS Foundation OMAP Family Planning Exp Proj School Districts Contract Payments/ESD Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Year End Budget Actual I Variance IFY% I Coll.% Budget Projection Variance $ 663,322 $ 844,015 $ 180,693 i00% 127% $ 663,322 $ 844,015 $ 180,693 1,500 - (1,500) 650,489 620,062 (30,427) 15,895 16,214 319 65,705 39,123 (26,582) 2,700 2,612 (88) 86,875 76,565 (10,310) 228,500 179,311 (49,189) 5,200 114 (5,086) 32,538 5,175 (27,363) 24,960 16,647 (8,313) 64,625 57,466 (7,159) 8,250 13,900 5,650 31,125 39,225 8,100 4,700 7,437 2,737 6,275 4,167 (2,108) 29,805 21,838 (7,967) - 3,600 3,600 1,259,142 1,103,456 (155,686) 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Transfers In -General Fund 1,144,706 1,144,706 - 50% TOTAL RESOURCES 3,067,170 3,092,177 25,007 50% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 1,713,238 1,605,136 108,102 50% 585,053 545,667 39,386 50% 35,295 47,546 (12,251) 50% 75,000 75,000 - 50% 176,923 - 176,923 50% 0% 3,426,475 3,000 3,000 - 48% a) 1,300,978 1,318,523 17,545 51% 589 31,790 31,790 - 30% b) 131,410 131,410 353,846 48% 5,400 5,400 44% C) 173,750 167,000 (6,750) 39% C) 457,000 430,000 (27,000) 1% b) 10,400 10,400 8% b) 65,075 65,075 33% C) 49,920 36,300 (13,620) 44% C) 129,250 125,400 (3,850) 84% d 16,500 26,000 9,500 63% 62,250 62,250 - 79% 9,400 9,400 33% 12,550 9,100 (3,450) 37% 59,610 52,410 (7,200) n/a - 7,200 7,200 44% 2,518,283 2,490,658 (27,625) 50% 2,289,411 2,289,411 - 57% 5,471,016 5,624,084 153,068 47% e) 3,426,475 3,322,500 103,975 47% 1,170,106 1,204,900 (34,794) 67% a) 70,589 70,000 589 50% 150,000 150,000 - n/a 353,846 - 353,846 TOTAL REQUIREMENTS 2,585,509 2,273,349 312,160 50% 44% NET (Resources - Requirements) 337,167 481,661 818,828 * Unappropriated Ending Fund Balance 5,171,016 4,747,400 423,616 300,000 876,684 576,684_ a) Additional grant funding is expected. Approximately $50,000 of that funding is an IT capital expenditure requirement. b) Patient fee revenue has been negatively impacted by the lack of available flu shots and loss in OHP Standard coverage. c) Collections for patient fees lags one month. Family Planning Exp Proj is paid through November. d) Births are projected to be higher than last year increasing revenue to $26,000. RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees Federal Grants State Grants State Miscellaneous ABHA-Inpatient Title 19 Liquor Revenue ABHA Client Support Funds School Districts Mental Health Jail Comp Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Donation Interfund Contracts Administrative Fee Total Revenues MENTAL HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Year End Budget Actual I variance I FY % I Coll. %I F Budget I Projection LiEEI $1,402,580 $ 1,634,080 $ 231,500 100% 117% a) , $1,402,580 $1,634,080 $ 231,500 2,750 2,975 225 50,000 56,391 6,391 49,705 - (49,705) 4,031,757 4,402,836 371,079 204,844 125,079 (79,765) 64,595 79,346 14,751 57,323 162,270 104,947 43,000 44,240 1,240 7,500 15,000 7,500 121,500 66,450 (55,050) 3,820 3,600 (220) 22,875 20,109 (2,766) 64,979 107,372 42,393 8,211 8,745 534 15,000 22,645 7,645 8,000 8,148 148 - 75 75 28,454 28,548 94 1,206,512 1,206,516 4 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 5,990,825 6,360,345 369,520 50% Transfers In -General Fund 470,361 470,361 - 50% Transfers In -Other 200,000 200,000 - 50% TOTAL RESOURCES 'REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 8,063,766 8,664,786 601,020 50% 54% 2,694,066 122,153 5,500 5,500 3,777,387 56% 50% 100,000 100,000 - 5,000 0% C) 99,410 99,410 - 55% d) 8,063,514 8,772,935 709,421 31%: C) 409,687 409,687 - 61% 129,189 129,189 - 142% e) 114,645 219,593 104,948 51% 86,000 86,000 - 100%. 15,000 15,000 - 27%, f)� 243,000 243,000 - 47% 7,640 7,640 - 44%1 45,750 45,750 - 83%. e) 129,957 172,351 42,394 53% 16,421 16,421 - 75% g) 30,000 45,290 15,290 51%, 16,000 16,000 - n/a, - 75 75 50% 56,907 56,907 - 50% 2,413,023 2,413,023 53% 11,981,643 12,853,771 872,128 50%, 940,722 940,722 50% 400,000 400,000 59% " � 14,724,945 15,828,573 1,103,628 2,816,219 2,694,066 122,153 50% 48% 3,777,387 3,464,804 312,583 50% 46% 5,000 - 5,000 50% 0% 75,000 75,000 - 50% 50% 688,867 - 688,867 50% n/a 7,362,473 6,233,870 1,128,603 50% 42% NET (Resources - Requirements) 701,293 2,430,916 1,729,623 b) 5,632,438 5,632,438 - h), 7,554,774 7,554,774 - 10,000 10,000 - 150,000 150,000 - 1,377,733 - 1,377,733 14,724,945 13,347,212 1,377,733 - 2,481,361 2,481,361_ a) Beginning Net Working Capital higher than projected primarily due to $170,000 of restricted funds in the balance. These funds must be spent this fiscal year or be returned to the State. b) Several unfilled positions and 9 month position have resulted in salary savings. Return to 40 -hr week on 1/1/05 for part of staff will use up most of the savings realized during the first half of the fiscal year. c) Revenues generated by billings to other government agencies. Billings and payments lag behind normal schedule the first 3-6 months of fiscal year. Full amount budgeted expected to be received. d) Received amendments increasing state contract revenues. Increase is related to equity structure and is a permanent increase. e) Non -OHP client revenues are very high to start the fiscal year. If trend continues, adjustments in the 2005/06 budget will be made. f) School District contracts are paid at the end of their first quarter. Mental Health services to the schools begins in September and billing commences at the end of October. g) Growth of cash balance, due to new revenues and a reduced work week for most staff, has contributed to higher interest earnings than expected. h) Result of expected lag in billing from vendors. COMMUNITY DEVELOPMENT Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Year End Budget Actual I variance I FY % I Coll. % Budget Proiection KC0UUK%.*C%1): Beg. Net Working Capital $ Revenues 235,900 $ 1,135,377 899,477 100% n/a a) $ 235,900 $ 1,135,377 899,477 Admin -Operations 17,600 40,777 23,177 50% 116% b) 35,200 60,000 24,800 Admin -GIS 6,500 3,818 (2,682) 50% 29% c) 13,000 13,000 - Admin -Code Enforcemeni 122,175 154,774 32,599 50% 63% d) 244,350 275,000 30,650 Building Safety 958,643 1,112,872 154,229 50% 58% d), 1,917,285 2,070,000 152,715 Electrical 251,125 295,164 44,039 50% 59% d), 502,250 545,000 42,750 Contract Services 301,310 457,142 155,832 50% 76% d) 602,620 755,000 152,380 Env Health -On Site Prog 349,010 349,224 214 50% 50% d), 698,020 698,020 - Env Health-Lic Facilities 192,188 205,261 13,073 50% 53% e)', 384,375 384,375 - Env Health -Grant 59,000 24,212 (34,788) 50% 21% f)' 118,000 118,000 - Env Health - Drinking H2( 20,085 36,110 16,025 50% 90% g) 40,170 40,170 - Plan ni ng -Current 426,963 479,335 52,372 50% 56% d)- 853,925 905,000 51,075 Planning -Long Range 235,504 263,816 28,312 50% 56% d) 471,007 471,007 Total Revenues 2,940,103 3,422,505 482,402 50% 58% 5,880,202 6,334,572 454,370 Trans In -CDD, Reserve 50 (50) 50% 0% 100 (100) Trans In -CDD Bldg/Elec 100 - (100) 50% 0% 200 - (200) TOTAL RESOURCES 3,176,153 4,557,882 1,381,729 50% 75% 6,116,402 7,469,949 1,353,547 REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Divisio 1,085,590 1,018,579 67,011 50% 47% 2,171,179 2,171,179 - Admin -GIS Division 84,352 85,786 (1,434) 50% 51% 168,703 168,703 - Admin -Code Enforcemeni 76,022 58,156 17,866 50% 38% 152,044 152,044 - Building Safety Division 462,202 460,840 1,362 50% 50% 924,403 924,403 - Electrical Division 168,676 181,208 (12,532) 50% 54% h) 337,352 337,352 - Contract Services 176,262 169,044 7,218 50% 48% 352,523 352,523 - Env Health -On Site Pgm 186,661 174,413 12,248 50% 47% 373,322 373,322 - Env Health-Lic Facilities 155,999 142,022 13,977 50% 46% 311,997 311,997 - Env Health -Grant Divisior 47,761 28,494 19,267 50% 30% 95,521 95,521 - Env Health - Drinking H2( 21,918 20,466 1,452 50% 47% 43,835 43,835 - Planning -Current Division 390,058 366,043 24,015 50% 47% 780,115 780,115 - Planning -Long Range Div 202,704 208,000 (5,296) 50% 51% 405,408 405,408 - TOTAL REQUIREMENTS 3,058,205 2,913,051 145,154 50% 48% 6,116,402 6,116,402 - NET (Resources - Requirements, 117,948 1,644,831 1,526,883 - _1,353,547 1,353,547 a) Due to budgeting error in FY 03-04, transfer from operating fund to reserve fund was not made, resulting in higher than estimated beginning capital. Transfer will be budgeted and made in FY 04-05. b) Higher fund balance (footnote a) has generated additional interest earnings. Road access permits higher than expected. c) GIS staff have been involved with non -revenue producing (internal) projects. d) Seasonal volume -permit volume higher in warmer months. Year-end totals may be higher than expected. e) Licensed Facility revenue is primarily received in January/February after license renewal notices are issued. f) EPA grant bills typically lag behind billing 2-3 months. g) Revenue is received in lump payments --year end estimate is still valid. RESOURCES: Beg. Net Working Capital Revenues Forest Receipts Federal Mineral Leases Motor Vehicle Revenue City of Bend City of Redmond City of Sisters Miscellaneous Fees Miscellaneous Road Vacations Interest on Investments Interfund Bldg Rentals Donations Equipment Repairs Vehicle Repairs LID Construction Vegetation Managernent Sale of Eqp & Material Sale of Public Lands Total Revenues ROAD Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Year End Budget Actual I Variance IFY% I Coll.% Budget Projection , Variance $ 4,992,257 $ 5,475,344 $ 483,087 100% 110% 1 $ 4,992,257 $ 5,475,344 $ 483,087 1,480,000 3,500,000 25,000 100,000 16,000 16,000 1,000 30,000 7,500 1,200 100,000 35,000 50,000 15,000 122,500 250 2,967,469 2,177 3,888,213 70,255 255,755 39,998 36,979 1,000 47,576 11,754 2,684 100,586 133,013 443 1,487,469 2,177 388,213 45,255 155,755 39,998 (16,000) 20,979 17,576 4,254 1,484 586 (35,000) (50,000) (15,000) 10,513 193 5,499,450 7,557,902 2,058,452 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% Transfers In -Road Imprvmt 145,000 - - (145,000) 50% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 10,636,707 13,033,246 2,396,539 50% l00% a) 2,960,000 2,967,469 7,469 n/a 4,272,702 - - 2,177 2,177 56% 50% 7,000,000 7,000,000 - 141% b) 50,000 70,255 20,255 128% b) 200,000 255,755 55,755 n/a 870,000 - 39,998 39,998 0% 50% 32,000 32,000 - 116% 32,000 36,979 4,979 50% 2,000 2,000 - 79% 60,000 60,000 78% 15,000 15,000 - 112%, 2,400 2,684 284 50% C) 200,000 200,000 - o% d) 70,000 70,000 - 0% e) 100,000 100,000 - 0%, 30,000 30,000 - 54% 245,000 245,000 - 89% 500 500 - 69% 10,998,900 11,129,817 130,917 0% 290,000 290,000 - 65% 16,281,157 16,895,161 614,004 2,136,351 2,080,870 55,481 50% 49% 4,272,702 4,272,702 - 3,143,991 3,138,636 5,355 50% 50% 6,287,981 6,287,981 - 2,062,880 8,220 2,054,660 50% 0% g) 4,125,760 4,125,760 - 435,000 870,000 (435,000) 50% 100% 870,000 870,000 - 362,357 - 362,357 50% n/a 724,714 - 724,714 TOTAL REQUIREMENTS 8,140,579 6,097,726 2,042,853 50% 37% NET (Resources - Requirements) 2,496,128 6,935,520 4,439,392 a) Forest Receipts, received in December, exceeded amount estimated in FY 04-05 Budget. b) Bills are issued on completion of work. Revenue is higher than anticipated. c) County departments billed monthly in arrears. d) Revenue to be received in June 2005 from 340 fund. e) Revenue to be received in June 2005 from 430 fund. f) Approximately half of aggregate and asphalt budget expended in summer months. g) Capital projects to be paid at completion. 16,281,157 15,556,443 724,714 - 1,338,718 1,338,718 RESOURCES: Beg. Net Working Capital Revenues State Grant State Miscellaneous Probation Work Crew Fees Alcohol and Drug Treatment Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Cognitive Program Sex Offender Treatment Fees Day Reporting Fees Interest on Investments Leases Rentals Interfund Contract Total Revenues Transfers In -General Fund TOTALRESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS I NET (Resources - Requirements) ADULT PAROLE & PROBATION Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date 953,462 60,605 Revised Year End 5,035 Budget Actual I Variance I FY % I Coll. % 50% Budget Projection (8) $ 413,036 $ 424,448 $ 11,412 100% 103% 892,857 953,462 60,605 50% 5,664 5,035 (629) 50% 5,930 13,635 7,705 50% 400 392 (8) 50% 4,550 9,725 5,175 50% 91,500 52,309 (39,191) 50% 87,500 103,613 16,113 50% - 70 70 50% 1,000 360 (640) 50% 1,500 240 (1,260) 50% 1,800 5,154 3,354 50% 6,600 7,870 1,270 50% 1,800 625 (1,175) 50% 71,255 71,255 - 50% 1,172,356 1,223,745 51,389 50% 6,300 6,300 50% 1,585,392 1,654,493 69,101 50% 1,039,499 996,703 42,796 50% 260,841 259,768 1,073 50% 50 - 50 50% 42,856 - 42,856 50% 1,343,246 1,256,471 53% a) 44% 115% b) 49% 107% C) 29% d) 59% n/a 18% d) 8% d) 143% 60% e) 17% 9 100% g) 54% n/a 62% 48% 50% 0% n/a 86,775 50% 47% 242,146 398,022 155,876 $ 413,036 $ 424,448 $ 11,412 1,785,713 1,906,924 121,211 11,327 11,327 - 11,859 23,000 11,141 800 800 - 9,100 12,000 2,900 183,000 150,000 (33,000) 175,000 175,000 - - 70 70 2,000 1,000 (1,000) 3,000 1,000 (2,000) 3,600 8,000 4,400 13,200 7,870 (5,330) 3,600 3,600 71,255 71,255 - 2,273,454 2,371,846 98,392 - 6,300 6,300 2,686,490 2,796,294 109,804 2,078,997 2,078,997 521,681 521,681 100 100 - 85,712 - 85,712 2,686,490 2,600,778 85,712 - 195,516 195,516 a) $8.9 million restored statewide to community corrections resulting in an approximate $300,000 increase for Deschutes County to be divided between Parole and Probation and the Sheriffs Office. b) More offenders than anticipated being assigned work crew/community service. c) Unexpected vehicle sale. d) Revenue lower than anticipated. e) Lessee relocated to downtown office. f) Revenue lower than anticipated. Full amount budgeted may still be received. g) Appropriation Transfer from General Fund was required to allow for the expenditure of the un -budgeted resource received from Comm. on Children & Families Statement of Financial Operating Data Six Months Ended December 31, 2004 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 201,877 191,855 Year to Date 50% 48% C) 403,754 383,561 Year End 1,008,539 517,054 Budget Actual I Variance IFY% I Coll.% 110,000 Budget Projection Variance RESOURCES: 43% 4,500 4,500 - 162,607 - 162,607 50% Beg. Net Working Capital $519,640 $ 642,357 $ 122,717 100% 124%. $ 519,640 $ 642,357 $ 122,717 Revenues 1,375,273 710,823 664,450 50% 26% 2,750,544 2,295,138 455,406 Federal Grants 72,853 40,000 (32,853) 50% 27% 145,706 145,706 - Title IV - Family Sup/Pres 17,797 16,741 (1,056) 50% 47% 35,594 35,594 - HealthyStart Medicaid 100,000 - (100,000) 50% 0% 200,000 200,000 - Child Care Block Grant 26,697 28,362 1,665 50% 53% 53,393 53,393 - Level 7 Services 87,766 93,614 5,848 50% 53% 175,531 175,533 2 Juvenile Crime Prevention 170,355 152,280 (18,075) 50% 45% 340,710 340,710 - State Prevention Funds 39,068 32,556 (6,512) 50% 42% 78,135 78,135 HealthyStart /R -S -G 112,567 130,582 18,015 50% 58% a) 225,134 130,582 (94,552) OCCF Grant 175,770 339,520 163,750 50% 97% b) 351,539 339,520 (12,019) Sale Map Photo or Copies - 2;403 2,403 50% n/a, - 2,403 2,403 Miscellaneous 8,500 9,720 1,220 50% 57% 17,000 15,000 (2,000) Interest on Investments 6,000 8,683 2,683 50% 72% 12,000 12,000 Grants -Private 9,831 2,400 (7,431) 50% 12%,,,, 19,662 19,662 Total Revenues 827,204 856,861 29,657 1,654,404 1,548,238 (106,166) Trans from General Fund 200,000 200,000 - 50% 50% 400,000 400,000 Trans from Other 88,250 88,250 - 50% 50% 176,500 176,500 Total Transfers In 288,250 288,250 50% 50% 576,500 576,500 TOTAL RESOURCES 50% 65% 2,750,544 2,767,095 16,551 1,635,094 1,787,468 152,374 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS 201,877 191,855 10,022 50% 48% C) 403,754 383,561 20,193 1,008,539 517,054 491,485 50% 26% d) 2,017,077 1,907,077 110,000 2,250 1,914 336 50% 43% 4,500 4,500 - 162,607 - 162,607 50% n/a 325,213 - 325,213 1,375,273 710,823 664,450 50% 26% 2,750,544 2,295,138 455,406 NET (Resources - Requirements) 259,821 1,076,645 816,824 - 471,957 471,957 a) Second year of biennium for HealthyStart general funds are being reduced for Federal Medicaid match. b) Crisis Nursery funds reduced in second year of biennium. c) Personnel projection reduced due to unfilled Director position. d) Materials & Services projection reduced by $110,000 for Medicaid match. 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 TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) SOLID WASTE Statement of Financial Operating Data Six Months Ended December 31, 2004 Year to Date Year End Budget Actual I Variance I FY % I Coll. % Budget Projection $1,142,974 $ 1,665,740 $ 522,766 100% 146% $1,142,974 $ 1,665,740 $ 522,766 26,550 - (26,550) 11,500 12,239 739 60,000 25,915 (34,085) 400,000 541,098 141,098 787,500 902,451 114,951 1,925,000 2,048,102 123,102 12,500 26,238 13,738 12,500 41,164 28,664 15,000 22,067 7,067 7,500 39,825 32,325 3,258,050 3,659,099 401,049 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 4,401,024 5,324,839 923,815 50% 663,522 647,595 15,927 50% 1,574,234 1,144,665 429,569 50% 62,125 49,306 12,819 50% 1,240,514 1,415,514 (175,000) 50% 289,143 - 289,143 50% o% a) 53,100 53,100 53% 23,000 23,000 22% b) 120,000 68% 800,000 800,000 57% 1,575,000 1,575,000 53% 3,850,000 3,850,000 - 105% C) 25,000 40,000 15,000 165% d) 25,000 50,000 25,000 74% 30,000 30,000 - 266% e) 15,000 39,825 24,825 56% 6,516,100 6,580,925 64,825 70% 7,659,074 8,246,665 587,591 49% 1,327,043 1,327,043 - 36% f) 3,148,468 3,148,468 - 40% 124,250 124,250 - 57% 2,481,028 2,481,028 - n/a 578,285 - 578,285 3,829,538 3,257,080 572,458 50% 43% 7,659,074 7,080,789 578,285 571,486 2,067,759 1,496,273 a) Grant monies generally received after projects are completed. b) Franchise fees due April 15, 2005. c) Seasonal revenues. d) Local clean up projects unanticipated. e) High return on sale of recylables at present time. f) Many larger expenditures in M&S have not been done i.e. engineering, and special waste events. 1,165,876 1,165,876 Health Benefits Trust Statement of Financial Operating Data Six Months Ended December 31, 2004 NET (Resources - Requirements) -14,107 4,045,335 4,059,442 - 5,142,003 5,142,003 a) Year End Projection: 26 weeks of claims annualized equals $5,472,558 for Medical/Rx and $964,886 for Dental/Vision. b) Revised Budget of $8,352,256: $7,164,174 Aggregate Stop -Loss ($1.0 million limit) for medical & pharmacy drugs; $1,188,082 budget for dental and vision claims. Year to Date -0 Revised Year End Budget Actual Variance I FY -1, TC 1 71% Budget Projection RESOURCES Beg. Net Working Capital $ 3,057,642 $3,057,642 $ - 100% 100% $3,057,642 $3,057,642 $ Revenues: Internal Premium Charges 3,792,244 3,934,378 142,134 50% 52% 7,584,487 7,684,487 100,000 PIT Emp - Add'I Prem 78,273 67,432 (10,841) 50% 43% 156,545 156,545 - Employee Prem Contribution 146,000 158,240 12,240 50% 54% 292,000 292,000 - COIC 293,778 293,998 220 50% 50% 587,556 587,556 - Retiree / COBRA Co -Pay 205,801 188,474 (17,327) 50% 46% 411,601 411,601 - Interest 14,000 29,602 15,602 50% 106% 28,000 55,000 27,000 Prescription Rebates - 18,281 18,281 50% n/a - 18,281 18,281 Total Revenues 4,530,096 4,690,405 160,309 50% 52% 9,060,189 9,205,470 145,281 TOTALRESOURCES 7,587,738 7,748,047 160,309 92% 64% 12,117,831 12,263,112 145,281 REQUIREMENTS Expenditures: Personal Services 54,718 54,598 120 50% 50% 109,435 109,435 Materials & Services Conferences and Seminars 1,500 915 585 50% 31%_ 3,000 3,000 - Claims Paid-Medical/Rx 3,582,087 2,885,880 696,207 50% 40% a) b), 7,164,174 5,472,558 1,691,616 Claims Paid-DentalNision 594,041 482,443 111,598 50% 41% a) 1,188,082 964,886 223,196 Insurance Expense 152,210 149,888 2,322 50% 49% 304,419 304,419 - State Assessments 15,937 13,967 1,970 50% 44% 31,874 31,874 - Administrators West 81,594 81,944 (350) 50% 50% 163,188 163,188 - PPO Fee 15,100 14,375 725 50% 48% 30,200 30,200 - Printing 11,364 1,195 10,169 50% 5% 22,728 22,728 - Program Expense/Supplies 1,949 2,684 (735) 50% 69% 3,898 3,898 - Other 5,438 14,823 (9,385) 50% 136% 10,876 14,823 (3,947) Total Materials & Services 4,461,220 3,648,114 813,106 50% 41% 8,922,439 7,011,574 1,910,865 Capital Outlay 50 - 50 50% 0% 100 100 - Contingency 3,085$857 - 3,085,857 50% 0% 3,085,857 - 3,085,857 TOTAL REQUIREMENTS 7,601,845 3,702,712 3,899,133 50% 31% 12,117,831 7,121,109 4,996,722 NET (Resources - Requirements) -14,107 4,045,335 4,059,442 - 5,142,003 5,142,003 a) Year End Projection: 26 weeks of claims annualized equals $5,472,558 for Medical/Rx and $964,886 for Dental/Vision. b) Revised Budget of $8,352,256: $7,164,174 Aggregate Stop -Loss ($1.0 million limit) for medical & pharmacy drugs; $1,188,082 budget for dental and vision claims. RESOURCES: Beg. Net Working Capital Revenues Property Taxes - Current Property Taxes - Prior State Reimbursement Telephone User Tax Data Network Reimb. Jefferson County Alarm Monitoring Fees User Fee Miscellaneous Interest Interest on Unsegregated Tax Total Revenues TOTALRESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) DESCHUTES COUNTY 911 Statement of Financial Operating Data Six Months Ended December 31, 2004 I Year to Date Year End I Budget Actual Variance I % of FY I % Coll. Budget Projection I Va $ 600,000 $1,230,708 $ 630,708 100% 205% $ 600,000 $1,230,708 $ 630,708 1,400,000 2,546,163 1,146,163 50% 91% 2,800,000 2,800,000 - 30,000 50,171 20,171 50% 84% 60,000 60,000 - 1,500 1,919 419 50% 64% 3,000 3,000 - 260,000 149,295 (110,705) 50% 29% a) 520,000 520,000 - 12,500 22,054 9,554 50% 88% 25,000 25,000 - 10,000 23,119 13,119 50% 116% 20,000 25,000 5,000 3,000 6,960 3,960 50% 116% 6,000 6,960 960 10,000 2,156 (7,844) 50% 11% b) 20,000 14,475 (5,525) 2,250 4,438 2,188 50% 99%, 4,500 4,500 - 5,000 11,373 6,373 50% 114% 10,000 20,000 10,000 350 766 416 50% 109% 700 900 200 1,734,600 2,818,414 1,083,814 50% 81% 3,469,200 3,479,835 10,635 2,334,600 4,049,122 1,714,522 50% 100% 4,069,200 4,710,543 641,343 1,182,121 1,100,620 81,501 50% 47% 2,364,242 2,364,242 - 251,920 275,794 (23,874) 50% 55% 503,840 503,840 - 192,647 129,911 62,736 50% 34% 385,293 385,293 - 65,000 - 65,000 50% 0% 130,000 130,000 - 342,913 - 342,913 50% n/a 685,825 - 685,825 2,034,601 1,506,325 528,276 299,999 2,542,797 2,242,798 a) Distribution of telephone tax occurs quarterly. b) Invoice for $14,475 to Crook River Ranch pending. 50% 37% 4,069,200 3,383,375 685,825 - 1,327,168 1,327,168 . of �.,- *oe .,- *.9 'e, Owocobs ": Iq - 0, OR 0 0 0 -: CD cv) C14 C*4 (n co v- Ic Lf� T -L CD 0 Go C) N w IT ll�. C� Iq cr) V) 0(� CCL Ili Ct V) 90) (o A 0 > io c 0.9 0 w C) �- Z) U- m -i R C) 0 64 fa 0) cf� I 0) C14 M N I- (D E 0 U LL 6—q > E 0 0 E --, e I- Lo U) > -v E IA E — E w U) 4) 0 (D > r E > > . of �.,- *oe .,- *.9 'e, Owocobs ": Iq - 0, OR 0 0 0 -: CD cv) C14 C*4 (n co v- Ic Lf� T -L CD 0 Go C) N w IT ll�. C� Iq cr) V) 0 69, C: CL U) 4) CL A 0 > io c 0.9 0 w C) �- Z) U- m -i 0000000000 0 0 0 C) a a a C> a a C� C� Ct Ct :::t C� ::� Ct Ct Ct 0 C) 0 C) C> 0 a 0 C> n a00000000a ctctvw-"NooN a w 6, ci Cq LD 61, 06 M se M w M M M Co LL E Z" o cn < lu g �6 m > co in U- 0 0 E E -le E 0 o m m f� *-R 1.9 lot R loe %.*, V) U) to 0 I%- cm C4 C4 Li E E .- w X 0) U) ctl a) w a ca ca C: 0 C.) ID () W- ca co cn 0) E he a) C E E a) M 0 LL M P 0 CL co 79 U- C) 0 a .0 2 m .2 B -T .0 2 Z .2 m 2 m 0 35 2 m a) 3 .2 Z 0 4, 2 Z .2 .0 2 �O 2 M 4) 2 M 0 v 0 2 M 2 M 2 M 2 M A 2.2 .02 A A 22 2 2 .2 A a . a Z to A ag a A 2 .2'a eeeeeeg 00C)O0,00 5 t*% 0 IR 0 lu C C C 5 C C c 0 Y C Y C Y c 0 0 z:gzzzz-2zzzzz 0 0 0 0 0 0 0 0 0 zzzzz 0 0 0 0 0 zz 0 0 zzz 0 0 q fl: 9 q 9 N LQ q q 4p M CR q q 0) C4 00 q CD 7 2 . C4 q 0 0 Cm Ns 8 2 - 2 " -98 2 N ;I r- 0 OT 0 10 Ln Ln CN 0 fn W Cli (0 in Cli N af at m IN 0 w 0 L6 0; "Ir q —0 0 N a too q ': P- mt m P� a'-) (6 w8mmil-m"oom It CON (6 L—n C4 'i C6 Gi c; "I Ld td w Gi w 9f C4 6 " -L r, Ci C4 Ul CO ai 'V IR CL C,,[ ct q 0 — q Ct , CZ Ct q ,,I tn act o C4 N C4 Cq C4 C4 N Cm (N N N N N C4 — C4 N Cm C4 C4 Cq in 0 9 C, 401, 2 0 98 8 8 8 00 8 8 88 0000 8 ton son 8 00 8 8 8 8 Cql P. C w D A r "It CC",, 2 § § 8 § 8 a r� 0 Co . § . 11 . . . C, 9 . . . . . is Iq G .14 0) g 4k (D _M N C! a! Ul - q Cq Ul CL - - - - - - 0- 0 -00 g 0) 2 r- 9i 8 0 C', 8 0 8 f.- M 0 N 8 8 0 C-4 Cl C%l ak Vi 0 C� 0 C, w C6 m Ci 0 C4 Csi C-4 C4 C-4 C%i C4 Cli �z �: CIF C4 N — — — C4 C*4 N CM cis 6 VP r - CL IV — — — ZR 2R 2R 0 Cv to u, OR in 8 Cq a I r fe In Cq m CR r- Ci CD 8 04 C� p 8 0 C� C� 'D 'D 0 — — — — — — — — — — - - - — — C4 C%i C4 Ci o E ro= 0 1-- E U) 0 r Ct 0 D LL0 Ca -1 121 1 1 1 aR Z9 8— w W , W , W N 0 Ln , LD — 8 8�p, 8 U, -, § 0 a - W 613, CQ Cq X� �5 CQ q -7 F-: rl� '4;t Cq C! q — — — CD f.- T� Ln C%l N M M luo� fn 0 > C-4 1 15 0. W E 2 d (A 0 M 0 0 8 W) a F- IT 0) w 00 Ln q 00 9 (0 (0 P, -m 0 M 0 r r, C4 ;z 9 > r - z W) .1 sj� kf) ul U7 Lf) kn tn 4) Lf) W r� r- to ra ;: Lr) if) if) in - :9 L.- -D -0 0 > > 0 0 0 Q Ln _- OD Ul s- ig 8 C-, 4 C iz: a Cl. ;0i, tN C4 (N P o c. 0 — — — 'A 100 M q q 06 4 —10 1 " Q —0 C8, C-1 C61, 2 NO— 60 C-4 —N 5 000— 0— 0 o c, �, 0 o gwu-mz>UlU- OIL <9 I T I I I — 1 0 1<1�10 < < ;� u< u- u- u - , ,lugs z z zlzlz ZI m lzlzlzl<. LL 0 z lzlz Co z 9 LL 1>161c" (1) U) (1) V) 0 to 3: (1) . . . D V) 3: 0 J2 E '0 '0 v 00 04 Cl 'T in Co 0) CO 0 C', x (D V 0 z -j 22- EROS AMR M X C's M V) ca. to 0 CL U) CD 0 CL C3 D -Ice a 00 0 (go M o 0 0 LL. Co g 0) . , C) r r tv A. Prx 2 4) E 3 E 11 E E E < m m 1 ca 10 100 w 0 Oq :,03 0 in 0 1 ow it- 0 7S 5 U_ NJ ca E 46 -E - — — — — - 6 :3 I�C:-,Ca > :a E C14 m > m m X:r mix z T T: I T m 0 m T z X X X m 0 0 LU LL. U- LL LL U- LZ LL LL LL m LL LL LL LLIC0,01MILLILL LL U - LL. ca Cf) 0 ell 0) Go 0) #A 7.1 0 a. 0 Ic (M In CR Ci C4 C4 Cli 4OW 41-� 0 0 0 0 0 fl- 0 (C) 0) co "T 0 0 00 C) qt CD 0 CN U) C) (30 C3 C� �T r-- 04 r-- U-) 0) 0 CY) 04 00 (0 a C14 C) a 0 0 U') 0) C) Ci) 0 0 (D 0 OD CY) 04 U -i 0 6 04 G) cc) co a U-) CD r-� 4 o 0 'gr o o C,4 Oo C) C) 0 (D 0 t- I- Cv) C) 04 LO w CD v a U) 0 0 0 C14 00 0 (D ti) (D o M tr) tr) C14 0 00 0) r- OD 0(00 1-- 0000 (Y) CD (N V-:, �� V:, L6 CNF (6 L6 -7 tti cli V-: C6 (6 V-: qf LO r- LO U') 04 U') Lr) (D CY) 0 (D C) -he M 0 0 to 0 E V 0 M E M M 0 C) I o .2 E .2 0 0 0 T C) C) C) C.) :3 m < a (D (0) E 'I C) (1) E E 0) m w 0) 4) m E m CO 0 U) CL 0 IL W r_ cq 4>) (b 0 U) w (1) CO) 0)-6 E CL lu U) x 0 0 cu f: M Co ca CU CO 0 0 m 4) 4) (D (D c () (9 T- it 0� ly it D 0 W r- C U) 0 - - :I =3 c 0 < m m im -X m :3 1 a U) io C o o 4" - u (1) co 0 .2 (L) - q) C13 m 0 0 -6 E 0 2)2)(0 --m C: CL 0 .- -?5 > U- a .5; :3 :3 n z =1 =3 2 CO - - - - 0 c 0 . >, 0 > 0 0 (D W co -�g >, E IX >, c (D �- �- F- �- �- F- 0 0 M " M 1 (9 < LL LL a- a- U) cu < ca m = -�d -�e -�e -,z -�e .- -�d -,e p 0 > m m m 0 m 0 m m m m C LL E E a 10 E a) t5 (6 6 (6 UJ U), U). U). (D. w wm =a co o -0 a 0 . co o o rn -I U) J . . . . . . . . 0 :J :) Z) Z) D :) D 0 I-.- JudlHasse From: Marty Wynne Sent: Friday, January 07, 2005 3:23 PM To: Mike Maier Cc: Judi Hasse Subject: Computers for Finance Department W ---O NI i Fam I PC-replacement200 5.x1s (24 KB)... Mike, As we have discussed, many of our staff have been experiencing difficulties in accessing data due to limitations of our current computers. These difficulties have not prevented anyone from getting his or her job done, but have been more of a nuisance to this point. The problem is that these difficulties are becoming more common, especially for certain employees. most of our computers were purchased in 1998/1999 and need to be upgraded. Kevin Furlong did an analysis of the issues we have been dealing with in our department and has made recommendations with regard to which computer hardware we should purchase (please see the attached file). As you can see, the total number of replacements will be eleven, plus the replacement of our laptop. In addition to the CPU upgrades, the recommendation is to purchase four 19 inch monitors for the individuals in our department who work with large spreadsheets on a regular basis. The total amount required will be approximately $26,000. As we have also discussed, because we do not plan to have our new staff accountant position filled until approximately the middle of February, these unbudgeted purchases will not have a negative impact on next year's beginning net working capital. If you approve, I would recommend transfers from the General Fund Contingency for all Tax related costs and the Finance Internal Service Fund (630) Contingency for all Finance/Accounting related costs. The General Fund would be $4,600 and Fund 630 would be $21,400. I plan to review this with you next week at our weekly meeting, but thought you might like to have some time to look at this in advance of our discussion. Thank you. Marty I PC Recommendations for Finance & Tax Exist Compute Option A Option B Option C Finance: Purchase Date Base System 19 Tube 17 LCD 19 LCID Insufficient mem & Dell Inspirion 8600 Laptop Oct -98 software capab. w/internet antennae 3170 N/A N/A N/A ADA Apr -96 Insufficient mem & DELL 8400 w/2Gb software capab. RAM,DVD+/-RW 1800 200 Exists NO Robinl Nov -00 N/A WBT works fine 200 Exists NO Insufficient mem & Dell 8400 w/2GB CherylC Dec -98 software capab. RAM,DVD+/-RW 1800 200 Exists 619 ChrisE Dec -98 Insufficient mem & Dell 8400 w/2GB software capab. RAM,DVD+/-RW 1800 200 Exists NO Insufficient mem & Dell 8400 w/2GB JeanineF Dec -98 software capab. RAM,DVD+/-RW 1800 200 Exists 619 Insufficient mem & Dell 8400 w/2GB SherriP Dec -98 software capab. RAM,DVD+/-RW 1800 200 Exists NO Insufficient mem & Dell 8400 w/2GB Judil-1 Nov -99 software capab. RAM,DVD+/-RW 1800 200 Exists NO Marilyn Apr -04 N/A WBT works fine Exists NO Insufficient mem & Dell 8400 w/2GB MartyW Dec -98 software capab. RAM,DVD+/-RW 1800 200 Exists NO Insufficient mem & Dell 8400 w/2GB TeriM Dec -98 software capab. RAM,DVD+/-RW 1800 200 Exists 619 New Position None N/A Dell 8400 w/2GB RAM,DVD+/-RW 1800 200 Use Teri's NO SubTotal 19370 2000 0 1857 Finance Total 21370 19370 21227 TAX: Amy Nov -00 N/A WBT works fine Exists NO Connie Jul -02 Insufficient mem & DELL 8400 w/2GIJ software capab. RAM,DVD+/-RW 1800 200 Exists NO Already has new PC, Carlie Apr -04 N/A just needs MS Publisher 100 Exists NO Insufficient mem & DELL 8400 w/1 Gb Davel- Jan -99 software capab. RAM,DVD,DVD+/- RW w/scanner 2000 200 Exists 619 Karen Oct -03 N/A WBT works fine Exists NO LacyN Apr -04 N/A Already has new PC Exists NO Work room Jan -99 Insufficient mem & WBT will replace PC software capab. 200 Jse Dave's NO SubTotal 3900 600 0 619 Tax Total 4500 3900 4519 Grand Totals 25870 23270 25746