The URL can be used to link to this page

2005-1323-Minutes for Meeting August 24,2005 Recorded 11/22/2005�J[ES C ❑ Deschutes County Board of Commissioners 1130 NW Harriman St., Bend, OR 97701-1947 (541) 388-6570 - Fax (541) 388-4752 - www.deschutes.org MINUTES OF DEPARTMENT UPDATE — FINANCE/TAX DEPARTMENT DESCHUTES COUNTY BOARD OF COMMISSIONERS WEDNESDAY, AUGUST 24, 2005 Commissioners' Conference Room - Administration Building - 1300 NW Wall St.., Bend Present was Commissioner Dennis R. Luke, Tom De Wolf and Michael M. Daly. Also present were Mike Maier, County Administrator; and Marty Wynne, Finance/Tax. No representatives of the media or other citizens were present. The meeting began at 9: 00 a.m., and a copy of the agenda is attached for reference. Commissioner Daly will schedule a presentation regarding juvenile long-term care through ABHA. No formal action was taken by the Board. The meeting adjourned at 9:45 a.m. DATED this 24th day of August 2005 for the Deschutes County Board of Commissioners. ATTEST: 1TTI ��lluw_L Recording Secretary Tom DeWolf, Chair Mi C_ D`aTy— C o/nmi s s i oner Dennis R. Luke COUNTY NANCYUTES BLANKENSHIP,FFICIAL COUNTY CLERKS COMMISSIONERS' JOURNAL MC ii 11/12/2045 04,41,11 PM Board of Commissioners' Monthly Meeting Finance Director/Treasurer AGENDA August 24, 2005 (1) Monthly Investment Report (2) Preliminary Year End and July Financial Reports (3) Children's System of Care Initiative (CSCI) (4) 911 Financial Projections t©kR k%%q C! ��oRo/m C) - CO m ■ R C. CD 0 C� �k 00 co $ OD K0) , m _ U) k©�$2 C a2±f(D E §deo<Re a) effn E��k \/\U-00 | ■ § EM � o I k c k tn U- ' 0ck � 0 ®0 \ § R 2 CN � � a § ARm � § � k ECS cm ° r § m # ■ � Sf \ mn S ■ u � # o >� R , q2C - W)R M2q 9q N N k m # c C E k C)kek� c �E2z LL a #S-■ � a E 0 k E\� m c > $ E 2 EEL >/ / \ / m - ( 0 t©kR k%%q C! ��oRo/m C) - CO m ■ R C. CD 0 C� �k 00 co $ OD K0) , m _ U) k©�$2 C a2±f(D E §deo<Re a) effn E��k \/\U-00 | ■ § EM � o I © c k tn U- ' 2+EE � 0 ®0 e > 3 ° \ � § ARm � � 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0C� o p a6666o0000 77kG2Gg0aN 0 S m o N / � e � (D 4 § m 2 « Z / R \ LL I k � E & v § cn ° < a m' ® § » m � �f§f7�f� § Q$ k 2 7 i m COW m m 0 0 o m m 5 4 4 a@aaa@ oo�nmo oo�NC4N E § EM U) X -5-4)M # c &/2D tn U- ' 2+EE vSgLM 0 ®0 § CL # c tn U- § « � !)§ ®0 > 3 ° § ARm � k ECS a ° e 0 � Sf mn S m o A m m m m m d Ao ID w m m m d tna m a m n m M d n v a) d a) 0) m@ n n d d a to y 'n y.0 m M m H d v a e u u q 9 Y A Y m R @ U 0 0 0 `(p` O O CO O O O O U O U O O U O U" O O U O U O U O O O U O OO OI G b O M 0 U Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z O 0 o O 0 0 O 0 O 0 o 0 O 0 O O O N N n 10 O 0 O 0 O 0 O g O 0 O 0 n W M M M M M M O O r Q V O M O M m 0 W o- W p O N N O O g O 0 O N N U7 N O A a(,) N N O W E 0O p 0 0 0 O O 0 0 0 O 0 O pp 0 p pp 0 0 O 0 . 0 t0 N 0 O W N N M t_ O v 1(! m v O O W t[) n D) 0 p O 0 p O 0 t0 N W r 11') M M W M n a0 N O pp . W v W v 0 (7 O M a0 O W 10 t() t0 O O V W 0 V 0 O 0 O 10 V N Q) n r V co M ICJ M m 07 A O O O O O M W r v Oi CO m A 7 t0 O O O O O M O O O O t v M W W (0 N O W n W W O W pp O W W N 0) v 0) r n M W to M O W n v v W N 0) M v n O O n W N m 0 M N U1 01 r r to 0 N N 0 W M 01 O to M O M N W t0 r O W O O) M M O n W O O O S W t0 r Q) O) O O C o�000poororoov_oN0000p000rMrrr N N N N N N N N N N' o N CV r N N N N N N N N N N N N N N N r rr ntn o on Cl) n O O 00 N N Cf (O C% W W W V N W w fA O O O n o (n r r 0 o 0 o 0 0 0 a O o O o g 0 o 00000000080 o to o 0 o o o o mo O o 0 g o 0 0 o o 0 o 0 o 0 o 8 O O 00 o o M nM N O M 10 N o O O O 0 O W N [o v 0 p uC 00 O tD v o O n to o W n 0 0 0 0 0 0 0 0 0 N W n N n O N O N O N a e� t7 Ci O O O o O w N M 03 N r 0 W i0 0 0 v� v N 0� 0 0 O M 0 0 0 0 0 0 0 0 0 a 0 0 O 0 0 06 0 0 0 0 66 0 0 0 0 CO R (D LO M co d O U O p R I- n n 0) W M 4) GD n N t0 n W W O p O o O O O n Q) (D V 0) M N W O 0 O 0 W W rn W n n N O W pp W O n o 0 0 0 0 00 0 o 0 v M O O O O t0 T (o O W O M M O I- W M W U J O Q> to 0) Co 0) 0) W r O r 0 O W r 0) C C O) 0) to O 0) O N O O O r O O r to C A V N N r r N N N r r N r N N r r N r N N N N N N N O t0 N W W r W C 0 0 0 0 0 0 0 0 �T' ee o 0 N N ti 0 Ip O W N N O O n n M W O O m p t0 n O t0 CO W n n O n M O M CO pp 0 W O t0 O O M CO o O 0 0 10 0 0 O 0 0 M N 0 O 0 W 0 M O N O v W O) 0 GO N 0 O 0 a- N O t0 n O O O R7 01 O e- O (p A o '` 0 'V y a a -�! m C y CM ('7 c7 r M M r r r N N (V N M M (M !M M M M pi tD N N 0 M M M co M ('� M M �T N r N O M M M r V W N N N M N co O f9 O 00 p pE �8E-7LLmJ�F 8 U a? N F- _ a C o 0 0 C 0 0 0 0 0 0 0 0 0 o e o 0 0 o 0 0 y 0o g o0 V 000 W 0 0 to n g0000p0000 o r n n t0 N co O O o O no n 0 y jq p K n n t0 r LO U0 N n O M aD O O N M N N M O LO O M r U r N M N M r M M M M M V M C d U E � U') c t N V Ea $ c w co C C 3L: Y F K 4 100 n WornovWWnW O N M to '7 n M V tt motDWWM v W v v V n M t0 V' ? N D) W N W W V' o M o MNvv n o 01 0) N >— V t0r rr t0r N10 to 0 Mtn M t0 M M t0 to to to M tD to O My n wo n n n n to W C Ty w y w n 0 n� 0 n 0 n� 0 n Q nt�, Q ntntntntn(DW(DW Q Q p Q o Q Q o Q (D Q mtDWQ� Q o W Q W CO o Q W Q tD Q W Q Bonn` O Q m� c0 g � E A Q N r 0D Q W W t0 Q W M Q` O O M M r 0 m r 0 N 0 p abb (D r r Q Q 0, Q W, O O t� D) N LV m M r O W N n N i W `_ W F a y o 0 0 0 0 0 0 a o r r _r r o 0 0 o 10 0 W o W 0 W 0 n 0 n n 0 0 W O) 0 0 M 0 o r r_ N r o 0 0 > 4 +0 F 0^ J ~ fYY v ntotnv Q Q Q Q ou�vvvvvvv Q Q Q Q Q Q Q o n Q nv1.-V Q Q o Q Q nvtOtntn Q Q Q Q nvvtnvvv Q Q Q o Q Q Q Q n Q n Q n Q L WQ Q N r t0 M Q r M O 07 O M (� W O W r Q) r V' N O r N V (0 r O W v Q N V (� M Q n Q n Q n r W co W r Q r M [� Q t0 r W IL O(O�OOOOo00pQrQQpO00pr�ro0000000pprOrrpprOOpp0 v (O W W r r "a N h m N Q r (� n n mpoUUPub��3�l&F-a0a0 °0� Lai. v U U LL U LL LL LL 4- F- LLL U. Lai � LL LL LL O� LL U. La laL Loi La)_ laL lai lay. Lai. I- F LLL F- HLtEB 3:U)wDtZi)(Zi)(Z�)wt/wM M(Zi)vZimU3 aD(063m�w3w3�3w ca -1Mw,m 00 a �nr~iv Y ��Nxva`o' COn� _ cd O E M co 2 LLX00�ijx ��cC((9 teX=0(L0L`i LL U Z N M )0 M M M t'' M M t7 M M M N co M W M M (h W M M t0 M M M M tMy M to M M to (') m to M to (o to (cn C,) o Cl) m ov w c C @ @ a o p c ( o a_ M U U = Y _ @ p C v m8 iu (C ma Ny6 °u�cc4i) N E R E m Y c U 0 E W (r Ymm C ?� W C O� tu E d1) U �°i Qrm'cmZ^�c °)LmtN� @ nmaa E c E E o mLi'y YYEE c3E,�o(At�wEEtj'$� E v' a� _ a1161�1188D0w��3�=8DL�m mmt�pE=mmm�mm�mzmm4�m�m�m � m ntW >�a°mmc S LL.D(03S Ut LLU.mUMLLiL=iuzLZLI=LCL=LI=LLLI=LLL4Zl=LIZLI=LmL=LinU LLLLm J -H mITL t- i* OIN N O aO I O U C VItO O N N OO O O O P O N c! In V N N IN OV v� N t(f' V r O ILO M O h 'C T N W W N O < r M 0 IN O N O O O O O O N O (p OIC n (71 N O O O O C) T N N N N O O N OC) O o 0 O O a 0 �- O O N CL N O C O N V` ! V O N V V O O O O O N N U O a) W N M O D) N N N V N N f0 N c7 M c0 V W M O M f`7 C M O V O N M N cc! } U N r N Lr) N W (O M T (p I V V N cl) I r V O V O O c0 O M CD h O N N � n Lf) N_ '- r- N CO N .- N . M N 2 c0 O ' co a0 O O co O U 00 co O s Q 0 O N O 0 O 0 0 0 0 C- 0 O O 0 0 O 0 O N 0< c0 M tD 0 N O V N c0 h O O N N O cO O V O O O O O O O O P O to O N N n a N O C C O O C O O C V O O N< < m 0 C Q) O M O O O co O M M M co p 'O N O M O O� N N N V' th O tD N O) N N O O Cl) O V LN N t0 O O W7 r- N N N N O N M N n n V N ") N V I` V O 0 W O P N N N M N V' O 0 0 0 0 O O LO Lp O N N M N O O O h aD N O O O O O O O r O V N N N O O 0 N !r O Cl) O a C N a n O cn N M t') N r- V N N V' to t0 a0 N N O O O N O N N N V' < O N M Cl) co O t0 N N N r co co V' < < N O O O O O O N r T 0 O Cl 0 0 O r N Lf) Cl) O r r N N to W N h h N CND N M V O r r OO O O O O O N t1Y co V N O O r — .Q O r O O W C O O O O N C) O V r M N V N N V• a0 M N M to M Q N a0 O N r N th V N tD tV N N h N cD t0 N < L O O O O N N O co V N a0 O O O aD U O O O O N Ih a h V N r M O M O c0 M co M O O co N V M 0) t0 r- d' N N V• V' w O N N O N h h O co V M c0 c0 N < h co OO O O O N N O O V N N O O N N O O 00 a N C O h V N N M M W p_ C N co r V M O N V• It N O a0 LN V � O V N t0 w N N M a) v O w t0 N t0 t0 U- < C N O O O O N N O c0 V N N O O O N ° O C O N O O N f` O f� V N N M O M to N O N V �-- V M W .- N It to N N O O N M M N V t0 O c0 N t0 tc) d N O O O O N N O O V N N O N O W 'V E O O O O O O N V N V O M L. r- V N N N V: I M N W V O O V' O h t0 U O M O M N LO co (0 N T M r- V' N Q < a) 6 O O O O0 NNOa0 V O N N O i N p �D O O 00 O N r O r V O N N M 0) w co E O N C N C V M W N O V' tD N N O t0 a) N O r M t0 N V N 0) N N N t0 ej t0' 0 N M < t0 w M N N tt) P z O O O O O N N O W V O N N O O N O O 0 0 0 N r- O r V O N N M M Q) ° N O N O i-- V M N < N O V• O N t0 M U NV N N N N O M N N O) teq q O N < Sl I N 0a a 0 N N O c0 V O N N O a co O O O C O 0 C O N V r O M co Ih V 0 N O N N V t0 Cl) N O C M M W O N a) Cl) N C N V M C -i V N N h N N O O O. a) w t0 N N to O r N W N N N y 0 a 0 N NN O V N O a O p 0 _N O O O O O O O N V f- < M V N M M co QV CO CO N co N V' t0 N N L N O ON tp 'O OHO OOO M fV0 CD N V N O N' n0) 0O -' O1 a0° ° rp' Otq .. ! c0 O.O '< t0 n .` (O' �, N' -'a ,O co, • N ,Nl 7: C", O.O CO ,V.W i O_ '.T'. N < N'=O 75U W LM < -t0 [-, MI �' 00 O N N 0 0 0 0 0 n O_ � ' N_ O O O O_ N O O L N V N Oct O V M N r N 75 -� N N O O m V t"1 V Q) N (D ap ty r N O N N N tD r M N Ico I c0 y I Ol N L2 O d 3 N p C CO c y IC N C c E in rn i> m (D ! 13 U y U e � I U .ta ° ° c W >° y C a) W °) �` 7 0 ayi C l6 I c a) ` I 3 O v t jj a) Ep "O L y a1 N Vl y a L C y K Q T l0 N LL i N > A N o. W U = m 10 H C: LL. LL 0 c L ° a� li l o g U I O c N p rnl U y to t l0 o L a) a� ZT t>) m v rn @ C 0 p` U c C N a) m a) 7 Q Z O m C C N N t0 U 'O A A ° f0 a) = w w `y .0 C y Y a Qcl ) a) — m `o ` C C a) o c a) c U O y ~ Ql y a� m to O F d L to d N C O m° C m C C7 Q N a Q) w d z W C V O w F,in in to a U> —,— O a J� IZ O co C� o p F z /4 Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data One Month Ended July 31, 2005 RESOURCES: Beg. Net Working Capital Receipts: Events Telephone Fees - Events Parking Fees Storage RV/Camping Horse Stall Rental Concession % - Food Vending Machines Interfund Contract Rights (Signage, etc.) Grants Miscellaneous Interest Total Receipts Transfer from General Fund Transfer from Park Fund Transfer from Annual County Fair Total Transfers TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Budget I Actual I Variance IF Budget I Projection I Variance $ 125,000 $ 179,409 $ 54,409 100% 144%= = $ 125,000 $ 179,409 $ 54,409 125,000 171,040 46,040 8% 25% - 672,212 718,252 46,040 20,000 22,565 2,565 8% 113% ,= 20,000 22,565 2,565 - 2,000 2,000 8% 2% 87,000 89,000 2,000 - - - 8% 0% ' 53,000 53,000 - - 1,215 1,215 8% 2% : 50,000 51,215 1,215 - 80 80 8% n/a-"F 50,000 50,080 80 40,000 80,000 40,000 8% 36%: 225,000 265,000 40,000 - 382,926 193,143 8% 0%;",= 1,400 1,400 - - - - 8% 0%; 35,000 35,000 - 3,000 36,140 33,140 8% 52%,,;"; 70,000 103,140 33,140 2,530 2,530 - 8% 6%,;:; 40,355 40,355 - 375 160 (215) 8% 4% , 4,500 4,285 (215) 300 1,010 710 8% 20% 5,000 5,710 710 191,205 316,740 125,535 8% 24%.;, 1,313,467 1,439,002 125,535 8% 8% 8% - - - 8% 316,205 496,149 179,944 8% 0%; 300,000 300,000 a; 0%,, 85,000 85,000 0%„ 204,300 204,300 0%, 589,300 589,300 24%E 2,027,767 2,207,711 179,944 64,178 59,068 5,110 8% 8% 4 770,138 765,028 5,110 62,244 54,154 8,090 8% 7% " 746,926 746,926 0 - - - 8% 0% 243,048 243,048 - - - - 8% n/a 42,000 42,000 - - - - 8% 0% :; 105,300 105,300 - - - - 8% n/a 120,355 - 120,355 126,422 113,222 13,200 8% 6% 2,027,767 1,902,302 125,465 189,783 382,926 193,143 - 305,409 305,409 Accrued Revenue (Accounts Receivable): Current Month Events 111,946 Prior Months 1,150 Total Accounts Receivable 113,096 Deposits Received for Future Events: 2005: August 6,390 September 1,860 October 4,159 November 8,400 December 1,460 2006: 15,905 2007 and Beyond 9,794 TOTAL 47,968 r' Deschutes County Fair and Expo Center Accounts Receivable July 31, 2005 Current Month - July 2005 Food & Beverage (estimate) 80,000.00 GNARR 31,000.00 Deschutes County Sheriff's Office 476.20 Cantastic 470.00 Total current month 111,946.20 Prior Months From June 2005 La Mesa RV 840.00 From March 2005 Owen Wedding 310.00 Total Accrued Revenue as of July 31, 2005 113,096.20 f� Deschutes County Fair and Expo Center Statement of Financial Operating Data July 2005 TOTAL REQUIREMENTS 129,079 Year to Date 15,857 8% 6% NET (Resources - Requirements) 16,466 Budget Actual Variance I FY % Coll. % RESOURCES: Beg. Net Working Capital $ 125,000 $ 179,409 $ 54,409 100% 0% Receipts: Events 8,440 171,040 162,600 8% 25% Telephone Fees - Events - 22,565 22,565 8% 113% Parking Fees - 2,000 2,000 8% 2% Storage - - - 8% 0% RV / Camping - 1,215 1,215 8% 2% Horse Stall Rental - 80 80 8% n/a Concession % - Food 8,900 80,000 71,100 8% 36% Vending Machines - - - 8% 0% Interfund Contract - - - 8% 0% Rights (Signage, etc.) 36,140 36,140 8% 35% Grants 2,530 2,530 - 8% 6% Miscellaneous 375 160 (215) 8% 4% Interest 300 1,010 710 8% 20% Total Receipts 20,545 316,740 296,195 8% 24% Transfer from General Fund - - 8% 0% Transfer from Annual County Fair - - - 8% 0% Total Transfers - - - 8% 0% TOTAL RESOURCES 145,545 496,149 350,604 8% 25% REQUIREMENTS: Exp. Expenditures: Personal Services 59,158 59,068 90 8% 8% Materials and Services 62,921 54,154 8,767 8% 7% Debt Service - - - 8% 0% Capital Outlay 7,000 - 7,000 8% 0% Transfers Out - - - 8% 0% Contingency - - - 8% n/a TOTAL REQUIREMENTS 129,079 113,222 15,857 8% 6% NET (Resources - Requirements) 16,466 382,926 366,460 y U C OIp) NIANMMOfM0001n N I- A NNO O N F 0 CD p V h NIA M W (DO r' 00 NOSOMO (� O) I^A 1 � I r r GOA NN � pp SO p OOOA f'' pp 0 Som C 0 a j0 Oi0 (Li1 LIMA ry1A OA I"- M O(70 m OOOM O) L (O N N'Q ppN INAN Nlfl��l� VCV '� (� NNQ00^O�pN MnM� NIAN Cb7� SOMCAf } (DO O 0O r N C, IAOA V- 1- M�Mb /'n I� f�Nr IA I� SL c� ' r r N b O O O N O0pp OOSSSS7SOIOA opOpo0p0p0ppppppo OA y c pvov CO)AO v O N olI�C�ppM OIAOM (O OD p OSO (a O p) O tim (grlA CD NNIA�� _ (O U) CV O�i1 00 CON ArNtn�Of � _ M IA a Or O N V �IAI\ r- M'I�V IA O) I^A 1 � I r r 00 a N 00 �5� M �A� o� p OOOA f'' pp 0 Som 0 0 a j0 Oi0 (Li1 LIMA OarD OM I"- M O(70 ' OOOM N'Q V Nlfl��l� NNQ00^O�pN Cb7� SOMCAf } (DO O 0O r N C, IAOA V- 1- M�Mb /'n I� f�Nr IA I� SL c� ' r r N b O O N O p OA y c N (O OD C N 0 N `r M Nf O N N r 'bA O f00 r M N n --------------- N N ' a" I!Y ' CA ' IA L M (D O� f0 st 'NV ' O r �T N MO O ON O A N (b") IYII��A IA (NO r r IA N M N � �m8A( (may a 00 p p� N� c)� n � p M CL Q _ L N N M N O M O IA N b N r a0 IA � M = M Om L LO Nr� bA aSNppO U M' cri aD rr N M rt IA Op (� A (0 cn V) copON NlA .- ' OM L(AOCND I� V' ' ONi M M M CO N N CV (h N 1 �0pp V O0 IA IA (,- IA C N N lA N ' b N (N Z. ------------------------ IA I� O O L N L N (O w r N O) A M (0)) 8 p� V' (O A IA N OA O) O (U 8 ' 00 A h do O) C14 Oto 0 O CO 00 �7 N N MO OM b 0) LO (O a c r„ b IA NLv r ' 0 CA 0 v--tT O) M r M CAD f0 O(h (O ��pp O N OM000 IAN p InvOO) �OIOA pp�� O n pp Of O b N INA ILA N cc M L N O ' a n � r r E ��8U)NO O , � M N O(�(D ppb 1� LO 00 Of O CD Q) N co W) ' N IMNO N Z r v COO (D M M CO N 1A N M (� N pp O L N A (D pp�� N b � O M C) O N f0 O) 01 W b b O N (A N pp IA M O r tc� A eF (MA CV ' ' b Cj y Q f7�NM �(MV- b Cell, IA OCL OD' tbD� N 00 ' a) (O N O O r N � O IA•. M (NOO� co O M (D h m O p V) 0) ' (-r0M ' MNat MNO ' w N Q O CA co CO V 00 M (O CD N O) 00 N r IAO(p�N , N '(�VtNLa 0 N (LQ�94 V N (O It IODO '00 Ln lamb eC N N C of i th a) Q Ir U- 0. N N > 7 V' U �°n) «° (l' °� x y c e LLJ > S = yl C a IV O bi o o LL c w rn w 2 a`�i L o � fc-. (�° o v 'D E v c c U) a) al a U p 7 y W O b as i LL of 0 7 m m e d oLL c (i _ > mCL cal c (iIi(i �U �c0 y a) 3 O wo p v_l� `LLQ awtmalalp)(oilccN�a y-c�00 C v� Uy�mZ OL W as c v a o m ( dU� A .� o 'Om c ca > N O O 5 R r N al f/l C W N I� F y = (p aj N` cl ID C� Q w Owl - (A in (na0> 0a�U Deschutes County - Fair and Expo Center _ YTD -Budget Basis Statement of Financial Operating Data FYE June 30, 2005 Year to Date Revised Year End RESOURCES: Budget Actual Variance FY % Coll. % Budget Projection Variance Beg. Net Working Capital $ 140,800 $ 138,098 $ (2,702) 100% 98%: $ 140,800 $ 138,098 $ (2,702) Receipts: Events 631,000 541,278 (89,722) 100% 86% 631,000 541,278 (89,722) Telephone Fees - Events 16,000 22,275 6,275 100% 139% 16,000 22,275 6,275 Parking Fees 87,000 34,941 (52,059) 100% 40% ! 87,000 34,941 (52,059) Storage 52,000 54,502 2,502 100% 105% 52,000 54,502 2,502 RV / Camping 4,000 4,923 923 100% 123% 4,000 4,923 923 Horse Stall Rental 2,000 42,173 40,173 100% n/a 2,000 42,173 40,173 Concession % - Food 215,000 241,263 26,263 100% 112%,,,:_` 215,000 241,263 26,263 Vending Machines 1,400 (1,400) 100% 0% 1,400 - (1,400) Interfund Contract 32,000 29,730 (2,270) 100% 93% 32,000 29,730 (2,270) Rights (Signage, etc.) 45,000 67,000 22,000 100% 149% ` 45,000 67,000 22,000 Grants 30,355 35,355 5,000 100% 116%,.' 30,355 35,355 5,000 Miscellaneous 4,500 8,195 3,695 100% 182% 4,500 8,195 3,695 Interest 5,000 5,539 539 100% 111% 5,000 5,539 539 Total Receipts 1,125,255 1,087,174 (38,081) 100% 97% 1,125,255 1,087,174 (38,081) Transfer from General Fund 300,000 300,000 - 100%° 100% 300,000 300,000 - Transfer from Annual County Fair 191,000 191,000 - 100% 100% 191,000 191,000 - Total Transfers 491,000 491,000 - 100% 100%;; 491,000 491,000 - TOTAL RESOURCES 1,757,055 1,716,272 (40,783) 100% 98%= ^ 1,757,055 1,716,272 (40,783) REQUIREMENTS: Exp. °i° ,.- Expenditures: Personal Services 714,240 679,011 35,229 100% 95% 3 714,240 679,011 35,229 Materials and Services 753,494 678,935 74,559 100% 90% °; 753,494 678,935 74,559 Debt Service 43,133 43,133 - 100% 100%, 43,133 43,133 Capital Outlay 47,970 44,775 3,195 100% n/a '' 47,970 44,775 3,195 Transfers Out 91,006 91,006 - 100% 100%:; 91,006 91,006 - Contingency 107,212 - 107,212 100% n/a 107,212 - 107,212 TOTAL REQUIREMENTS 1,757,055 1,536,860 220,195 100% 87% '` 1,757,055 1,536,860 220,195 NET (Resources - Requirements) - 179,412 179,412 - 179,412 179,412 Beginning NWC per FY 05-06 Adopted Budget 125,000: Accrued Revenue (Accounts Receivable): Deposits Received for Future Events: 2005: June 2005 Events 9,587 July 127,853 March 2005 Events 510 August 6,390 September 1,860 Total Accounts Receivable 10,097 October 3,319 November 8,400 December 680 2006 and Beyond 15,537 TOTAL 164,039 Deschutes County Accounts Receivable - Fair Expo Center (Fund 618) As of June 30, 2005 Current Month - June 2005 Food & Beverage 8,747.25 La Mesa RV 840.00 Total current month 9,587.25 Prior Months From March 2005 Owen Wedding 510.00 Total Accrued Revenue as of June 30, 2005 10,097.25 Memorandum Date: August 18, 2005 To: Board of County Commissioners Mike Maier, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports for Fiscal Year End 2004-2005 Attached please find the year-end financial report for Fiscal Year 2004-2005 for the following funds: General (001), Community Justice — Juvenile (230), Sheriffs (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 Board of County Comm. District Attorney Finance/Tax Veterans Property Management Surveyor Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA BOCC District Attorney Finance/Tax Veterans Property Management Surveyor Non -Departmental Contingency Transfers Out TOTAL REQUIREMENTS GENERALFUND Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Revised Bud I Actual Variance FY % I Coll. $ 4,700,000 $ 4,994,433 $ 294,433 100% 106% : r 14,295,000 14,800,999 505,999 100% 104% 1,670,578 1,944,894 274,316 100% 116%; 1,024,792 1,124,474 99,682 100% 110% 1,385,500 2,350,755 965,255 100% 170%.._,: 13,986 15,502 1,516 100% 111% - 9,562 9,562 100% n/a .� 328,810 328,004 (806) 100% 100% • 217,450 246,099 28,649 100% 113% s 9,800 7,554 (2,246) 100% 77%_:,_,,:.;; 66,300 82,039 15,739 100% 124% 187,000 246,026 59,026 100% 132% 19,199,216 21,155,908 1,956,692 100% 110% 23,899,216 26,150,341 2,251,125 100% 109%,,,,:,.1 3,388,079 3,259,929 128,150 100% 1,182,047 1,121,001 61,046 100% 51,377 42,642 8,735 100% 585,361 572,307 13,054 100% 3,392,973 3,196,564 196,409 100% 791,165 730,166 60,999 100% 151,767 148,345 3,422 100% 142,237 116,506 25,731 100% 163,936 160,089 3,847 100% 815,140 785,675 29,465 100% 1,627,429 - 1,627,429 100% 12,291,511 10,133,224 2,158,287 100% 10,452,450 10,452,450 - 100% 22,743,961 20,585,674 2,158,287 100% Appropriation Transfers NET (Resources - Requirements) 1,155,255 5,564,667 4,409,412 Beginning NWC per FY 05-06 Adopted Budget 4,800,000; Exp. 95% 83% 98% 94% 98% 82% 98% 96% n/a 82% 100% 91% a) The Contingency in the Adopted budget was $2,252,265. The reduction of $624,836 is due to (1) transferring $455,255 of appropriation to other funds, (2) transferring appropriation to "Transfers Out": Adult P & P - $22,300, CCF - $4,000, Victims Assistance - $46,935, Juvenile - $10,000, Sheriff - $6,000, Admin Svcs - $45,000 and Legal - $10,000, and (3) transferring appropriation to Finance/Tax - $4,600, Assessor - $10,746 and BOCC - $10,000. b) The Unappropriated Ending Fund Balance in the Adopted Budget was $700,000. The increase of $455,255 is due to transferring appropriation to (1) Adult P&P - $71,255, (2) CDD COPs Debt Service - $215,000, (3) Legal - $10,000, (4) County School Fund - $6,000 Juvenile - $10,000, Admin Svcs - $46,000, Transportation Fund - $97,000. b) COMM JUSTICE -JUVENILE Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Year Budget I Actual I Variance FY % I Coll. RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -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 $ 314,190 $ 199,202 $ (114,988) 100% n/a a) $ 314,190 185,796 n (20,950) Budget Pro'ection Variance $ 314,190 $ 199,202 $ (114,988) 100% n/a a) $ 314,190 185,796 164,846 (20,950) 100% 89%'-'b)` 4,909,039 185,796 39,338 47,210 7,872 100% 120% f), , 39,338 4,038 7,285 3,247 100% 180% 4,038 33,400 45,612 12,212 l00% 137% .;G);' 33,400 229,939 261,622 31,683 l00% 114% :d). 229,939 50,000 98,872 48,872 l00% 198% ,e)y 50,000 1,500 2,640 1,140 l00% 176% ,:f) 1,500 387,953 361,865 (26,088) 100% 93% g) 387,953 100,000 108,259 8,259 100% 108% h) 100,000 1,437 2,482 1,045 l00% 173% 1,437 4,250 6,654 2,404 l00% 157%' :f) 4,250 34,870 34,139 (731) 100% 98% 34,870 1,072,521 1,141,486 68,965 100% 106% 1,072,521 $ 199,202 $ (114,988) 158,808 46,646 6,852 42,033 261,622 88,000 2,750 385,146 107,089 2,500 7,240 34,067 1,142,753 Transfers In -General Fund 4,909,039 4,909,039 - 100% 100% xi) 4,909,039 4,909,039 Transfers In -Sheriff 52,500 52,500 - 100% 100% 52,500 52,500 TOTAL RESOURCES 6,348,250 6,302,227 (46,023) 100% 99% " :' 6,348,250 6,303,494 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services 2,281,684 2,248,903 32,781 100% Materials and Services 232,694 211,767 20,927 l00% Contingency 120,093 - 120,093 l00% 2,204,657 2,161,118 43,539 100% 98% ' 2,204,657 2,204,657 1,509,022 1,425,533 83,489 100% 94% .j) 1,509,022 1,509,022 100 - 100 100% 0% 100 100 99% A 91% I n/a 2,281,684 2,281,122 232,694 212,694 120,093 - (26,988) 7,308 2,814 8,633 31,683 38,000 1,250 (2,807) 7,089 1,063 2,990 70,232 (44,756) 562 20,000 120.093 TOTAL REQUIREMENTS 6,348,250 6,047,321 300,929 100% 95% 6,348,250 6,207,595 140,655 NET (Resources - Requirements) - 254,906 254,906 - 95,899 95,899 Beginning NWC per FY 05-06 Adopted Budget 182,218. 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 $20,542 due to projected extension to 12/31/05; JAIBG reduced by $10,446. c) Food Subsidy Revenues exceeding projections due to increased participation in Snack/Commodities Program. d) JCP costs reimbursed quarterly for Maplestar, a treatment foster care provider. Quarterly Reimbursements are $65,406. e) $85,322 Billed through 5/31/05. f) Year End Projections revised accordingly. g) Behavioral Rehabilitation Services billing through May totals $296,139, .05% less than projected at 11 Months into the Fiscal Year. h) Level 7 funding reimbursed quarterly. Each quarter reimbursement is approx. $24,299. Revised YE projection to include Trillium Reimbursement for Aramark Food Expenses. Trillium obtained its own contract on 1/27/05. i) Additional $10,000 authorized by BOCC for JCJ Flex Funds j) Actual Expenditures to date do not include Accrued Liability for BRS WellSpring Program in the amount of $89,866. k) Resource Center On -Call is trending over budget due to turnover in both FT/PT, Employees, Additional Training, and Extended Vacations by FT Personnel. 1) Food and Medication Costs trending higher due to steady increase in the Average Daily Population in the Resource Center. SHERIFF Rev Detail Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Year End RESOURCES: Bud et Actual I Variance FY % I Coll. % Budget I Projectionl Variance Beg. Net Working Capital $1,028,628 $1,028,628 $ - 100% 100% $1,028,628 $1,028,628 $ - Revenues Tax Revenues- Current 11,950,018 12,543,555 593,537 l00% 105% 11,950,018 12,550,018 600,000 Tax Revenues - Prior 406,600 310,842 (95,758) 100% 76% 406,600 306,600 (100,000) Federal Grants 67,500 135,710 68,210 l00% 201% a)' 67,500 89,603 22,103 U.S. Forest Service 72,000 72,000 - 100% 100% 72,000 72,000 - State Grant 115,548 77,846 (37,702) l00% 67% ti)` 115,548 94,192 (21,356) SB #1 065 -Court Assess. 42,500 47,210 4,710 l00% 111% 42,500 42,500 - Marine Board Lic. Fee 85,000 92,744 7,744 l00% 109% c) 85,000 85,000 - Narcotic Task Force Grt. 110,000 137,500 27,500 l00% 125% 110,000 110,000 - Transp. of State Wards 3,000 4,595 1,595 l00% 153% 3,000 4,000 1,000 SB 1145 1,299,727 1,560,211 260,484 100% 120%,d)„ 1,299,727 1,560,212 260,485 City of Sisters 327,290 327,290 - 100% 100%,.;327,290 327,290 - Security & Traffic Reimb 120,200 26,394 (93,806) l00% 22% e)° 120,200 30,000 (90,200) Seat Belt Program 3,500 6,725 3,225 10o% fi 192%,, 3,500 6,500 3,000 Inmate/Prisoner Housing 1,000 2,362 1,362 l00% 236% 1,000 3,000 2,000 Contract Payments 17,216 - (17,216) l00% 0% _ 17,216 - (17,216) Inmate Commissary Fees 50,000 82,946 32,946 l00% 166% 50,000 60,000 10,000 Soc Sec Incentive -Fed 3,000 3,200 200 l00% 107% 3,000 3,000 - Miscellaneous 22,200 21,890 (31 0) l00% 99% 22,200 22,200 - Medical Services Reimb 12,000 16,194 4,194 l00% 135% 12,000 15,000 3,000 Restitution 5,000 1,576 (3,424) l00% 32% 5,000 5,000 - Sheriff Fees 147,000 118,178 (28,822) l00% 80% 147,000 147,000 - Court Fines and Fees 233,000 129,743 (103,257) 100% 56% g) 233,000 135,000 (98,000) Impound Fees 74,000 96,072 22,072 l00% 130% " 74,000 93,000 19,000 Interest 30,215 57,834 27,619 l00% 191% 30,215 60,000 29,785 Interest on Unsegregated 2,493 5,358 2,865 l00% 215% 2,493 6,000 3,507 Rentals 43,333 43,996 663 l00% 102% 43,333 43,333 - Interfund Contract 422,226 323,286 (98,940) l00% 77%11 422,226 322,226 (100,000) Transport Reimbursements 5,000 3,221 (1,779) 10o% 64%-"],- 5,000 5,000 - Sale of Eqp & Material - 25,655 25,655 l00% n/a 4 - 25,655 25,655 Total Revenues 15,670,566 16,274,133 603,567 l00% 1041/6 15,670,566 16,223,329 552,763 Transfers In 2,650,000 2,650,000 - 100% 100% j 2,650,000 2,650,000 - TOTAL RESOURCES 19,349,194 19,952,761 603,567 100% 103% 19,349,194 19,901,957 552,763 REQUIREMENTS: Exp EXPENDITURES & TRANSFERS Sheriffs Division 1,237,657 1,366,156 (128,499) l00% 110% I)'' 1,237,657 1,349,250 (111,593) Automotive/Communications 875,184 975,017 (99,833) 100% 111% j) 875,184 957,579 (82,395) Investigations/Evidence 1,602,734 1,652,609 (49,875) l00% 103% .k)":; 1,602,734 1,639,184 (36,450) Patrol/Civil/Comm Supp 6,700,350 6,437,295 263,055 l00% 96% I)' 6,700,350 6,401,235 299,115 Records 604,738 581,078 23,660 l00% 96% m) 604,738 578,478 26,260 Adult Jail 6,382,874 6,187,172 195,702 100% 97% n)' 6,382,874 6,152,705 230,169 Transport/Court Security 175,854 154,191 21,663 100% 88% 175,854 152,690 23,164 Emergency Services 105,821 97,533 8,288 l00% 92% 105,821 97,457 8,364 Special Services Division 422,021 430,792 (8,771) l00% 102% '' 422,021 420,057 1,964 Training Division 278,391 257,214 21,177 100% 92% 278,391 263,340 15,051 Contingency 703,070 - 703,070 100% o% 703,070 - 703,070 Transfers Out 260,500 260,500 - 100% 100% 260,500 260,500 - TOTAL REQUIREMENTS 19,349,194 18,399,557 949,637 100% 95% 19,349,194 18,272,475 1,076,719 NET(Resources- Requirements) - 1,553,204 1,553,204 - 1,629,482 1,629,482 Beginning NWC per FY 05-06 Adopted Budget 1. 1648;031a RESOURCES: Beg. Net Working Capital Total Revenues Transfers In TOTAL RESOURCES REQUIREMENTS: Sheriffs Services Personnel Materials & Services Capital Outlay Total Sheriffs Services Automotive/Communications Personnel Materials & Services Capital Outlay Total Automotive/Communication: Investigations/Evidence Personnel Materials & Services Capital Outlay Total Investigations/Evidence Patrol/Civil/Comm Support Personnel Materials & Services Capital Outlay Transfers Out Total Patrol/Civil/Comm Supp Records Personnel Materials & Services Capital Outlay Total Records Adult Jail Personnel Materials & Services Capital Outlay Total Adult Jail Transport/Court Security Personnel Materials & Services Total Transport/Court Security Emergency Services Personnel Materials & Services Capital Outlay Total Emergency Services Special Services Personnel Materials & Services Capital Outlay Total Special Services Training Personnel Materials & Services Capital Outlay Total Training _Non -Departmental Materials & Services Transfers Out Contingency Total Non -Departmental Total Requirements 156,132 148,250 14,822 SHERIFF Exp Detail 170,954 154,191 89,656 89,098 18,165 Statement of Financial Operating Data 100 - 107,921 Twelve Months Ended June 30, 2005 87,656 88,870 (1,214) 46% 18,165 8,587 9,578 n/a: Year End 105,821 Year to Date 8,364 Budget Actual Variance FY % Coll. % Bud et Pro'ection Variance 100% 10,677 10,677 - $1,028,628 $1,028,628 $ - 100% 100% $1,028,628 $1,028,628 $ 15,670,566 16,274,133 603,567 100% 104% 15,670,566 16,223,329 552,763 2,650,000 2,650,000 - 100% 100% 2,650,000 2,650,000 _ 100% 208,000 208,000 19,349,194 19,952,761 603,567 100% 103% 19,349,194 19,901,957 552,763 703,070 19, 349,194 18, 272, 475 1,0769719 - 1,629,482 711,930 706,313 5,617 100% 100%::706,930 709,184 (2,254) 645,908 645,134 774 100% 125% 515,908 625,357 (109,449) 6,898 1,364,736 6,688 1,358,135 210 6,601 100% 98% 6,798 6,688 110 3 1,229,636 1,341,229 (111,593) 214,140 210,160 3,980 100% 980/c 214,140 210,230 3,910 740,344 30,800 740,317 24,540 27 6,260 100% 117% 630,344 722,809 (92,465) 985,284 975,017 10,2671 100% 80% 30,700 24,540 6,160 875,184 957,579 (82,395) 1,346,612 1,334,046 12,566 100% 101% 1,326,612 1,332,788 (6,176) 261,562 77,560 248,328 13,234 100% 123% " 201,562 228,900 (27,338) 1,685,734 70,235 1,652,609 7,325 33,125 100% 94% 74,560 77,496 (2,936) 1,602,734 1,639,184 (36,450) 5,608,721 5,517,595 91,126 100% 95%5,823,221 5,500,842 322,379 553,061 454,068 538,134 381,566 14,927 72,502 100% 100% 127% , 423,061 490,157 (67,096) 52,500 52,500 84% 454,068 410,236 43,832 6,668,350 6,489,795 - 178,555 100% 100% _ 52,500 6,752,850 52,500 6,453,735 2997115 500,899 481,744 19,155 100% 93%,.",515,899 481,767 34,132 92,353 89,205 3,148 100% 115% 77,353 85,743 (8,390) 11,486 604,738 10,129 581,078239660 1,357 100% 88% 11,486 10,968 518 604,738 578,478 26,260 4,963,728 4,851,297 112,431 100% 95%115,123,728 4,856,824 266,904 1,213,539 1,209,129 4,410 100% 109% 1,113,539 1,149,210 (35,671) 150,607 6,327,874 126,746 6,187,172 23,861 140,702 100% 87% 145,607 146,671 (1,064) 6,382,874 6,152,705 2307169 156,132 148,250 14,822 5,941 170,954 154,191 89,656 89,098 18,165 8,435 100 - 107,921 97,533 369,945 61,399 21,731 453,075 100,404 82,364 148,123 330,891 365,288 54,827 10,677 430,792 99,642 62,442 95,130 257,214 7,882 100% 8,881 100% 16,763 558 100% 9,730 1 00% 100 100% 10,388 4,657 100% 6,572 100% 11,054 100% 22,283 762 100% 19,922 100% 52,993 100% 73,677 8,021 8,021 - 100% 208,000 208,000 - 100% 434,116 434,116 100% 650,137 216,021 434,116 19,349,694 18,399,557 950,137 NET (Resources - Requirements) (500) 1,553,204 1,553,704 92%:161,132 147,588 13,544 40%,14,722 5,102 9,620 175,854 152,690 23,164 102% 87,656 88,870 (1,214) 46% 18,165 8,587 9,578 n/a: 105,821 97,457 8,364 100%.,:364,945 362,467 2,478 118% 46,399 46,913 (514) 100% 10,677 10,677 - 422,021 420,057 1,964 102% 97,904 99,955 (2,051) 193%,. 32,364 58,569 (26,205) 64% 148,123 104,816 43,307 278,391 263,340 15,051 100% 8,021 8,021 - 100% 208,000 208,000 - 0%; 703,070 - 703,070 919,091 216,021 703,070 19, 349,194 18, 272, 475 1,0769719 - 1,629,482 1,629,482 Sheriff Notes Statement of Financial Operating Data Twelve Months Ended June 30, 2005 a) Unplanned grant revenue received for Bullet Proof Vests of $11,099 and SCAAP of $10,393. b) Reductions in actual amount of grant revenue. c) Marine Board billing is completed semi-annually in January and July resulting in year-to-date variance. d) Reduction to Community Corrections funding has been fully restored statewide. Budget was based on lower level of state-wide funding. e) US Forest Service reimbursement for fire overtime has not been required to date. Forecast has been reduced by $90,000. f) Other Mug Shot system users are paying maintenance directly to the vendors. g) 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 $98,000 at year end due to traffic team staffing shortages. h) Title II/III reimbursements are estimated to be $100,000 less than planned and will be unspent funds will carry over to next fiscal year. 1) Year end projections included IT consultant for $68,800, additional bullet proof vests for $21,850 and productivity tools (PC's and office furniture) funded from contingency and savings in other areas. j) Fuel costs (gasoline) is expected to be above plan by $15,000. Other expenditures for auto repair equipment, new car preparation and mobile communications equipment was funded with savings in other Divisions. k) Year end projections include Street Crimes unit startup costs and additional computer forensic equipment. 1) Year end projections included $100,000 for additional patrol vehicles which are funded from savings due to delays in filling open positions. m) Year end projections includes labor savings and spending less than planned for supplies and purchased services. n) Year end projections includes savings from delays in filling open positions partially offset by the the jail parking lot expansion project for $63,000 and new productivity tools (PC's and office furniture) HEALTH Statement of Financial Operating Data Twelve Months Ended June 30, 2005 a) Medicare fees are collected as part of Patient Insurance Fees. b) Family Planning reimbursements fees were lowered and no longer include STD visits, which impacted revenue significantly. c) Increases in vital record fee rates, combined with the impact of population increases has resulted in higher vital record fees. Year to Date Year End I Bud et Actual Variance FY % I Coll. % Budget Pro'ection Variance RESOURCES: Beg. Net Working Capital $ 663,322 $ 844,015 $ 180,693 100% 127% ",_ ', $ 663,322 $ 844,015 $ 180,693 Revenues Medicare Reimbursement 3,000 16,356 13,356 100% 545% a}`"! 3,000 - (3,000) State Grant 1,373,415 1,432,108 58,693 100% 04% 104%,:" 1,373,415 1,318,523 (54,892) Child Dev & Rehab Center 31,790 32,428 638 100% 102% 31,790 31,790 - State Miscellaneous 131,410 140,003 8,593 100% 107% 131,410 121,300 (10,110) STARS Foundation 5,400 7,296 1,896 100% 135% 5,400 5,400 - OMAP 173,750 214,792 41,042 100% 124% 173,750 210,389 36,639 Family Planning Exp Proj 457,000 459,984 2,984 100% 101% b},; 457,000 415,651 (41,349) Grants - 4,880 4,880 100% n/a School Districts 10,400 14,664 4,264 100% 141% 10,400 18,000 7,600 Contract Payments/ESD 65,075 63,403 (1,672) 100% 970X 65,075 65,075 - Miscellaneous - 7,671 7,671 100% n/a -s,! - 7,671 Patient Insurance Fees 49,920 68,287 18,367 100% 137% 49,920 56,805 6,885 Health Dept/Patient Fees 129,250 133,343 4,093 100% 103% 129,250 129,058 (192) Vital Records -Birth 16,500 27,555 11,055 100% 167%,z,c `; 16,500 27,093 10,593 Vital Records -Death 62,250 82,015 19,765 100% 132% ;u c),, 62,250 82,778 20,528 Interest on Investments 9,400 20,020 10,620 100% 213% 9,400 19,224 9,824 Donations 12,550 11,741 (809) 100% 94% 12,550 10,717 (1,833) Interfund Contract 59,610 52,410 (7,200) 100% 88% 59,610 52,410 (7,200) Administrative Fee - 7,200 7,200 100% n/a - 7,200 7,200 Total Revenues 2,590,720 2,796,156 205,436 100% 108%, :"i 2,590,720 2,579,084 (19,307) Transfers In -General Fund 2,289,411 2,289,411 - 100% 100% 2,289,411 2,289,411 - TOTAL RESOURCES 5,543,453 5,929,582 386,129 100% 107% 5,543,453 5,712,510 161,386 REQUIREMENTS:Exp °i° Expenditures Personal Services 3,426,475 3,228,470 198,005 100% 94% 3,426,475 3,242,000 184,475 Materials and Services 1,282,543 1,238,185 44,358 100% 97%. 1,282,543 1,222,600 59,943 Capital Outlay 70,589 49,474 21,115 100% 70% ".' 70,589 59,600 10,989 Transfers Out 150,000 150,000 - 100% 100% 150,000 150,000 - Contingency 313,846 - 313,846 100% n/a 313,846 - 313,846 TOTAL REQUIREMENTS 5,243,453 4,666,129 577,324 100% 89% 5,243,453 4,674,200 569,253 NET (Resources - Requirements) *` 300,000 1,263,453 963,453 300,000 1,038,310 730,639 Beginning NWC per FY 05-06 Adopted Budget 908,900` * Unappropriated Ending Fund Balance a) Medicare fees are collected as part of Patient Insurance Fees. b) Family Planning reimbursements fees were lowered and no longer include STD visits, which impacted revenue significantly. c) Increases in vital record fee rates, combined with the impact of population increases has resulted in higher vital record fees. TOTAL RESOURCES 15,227,994 15,740,860 512,866 10001a 103016 15,227,994 15,816,041 588,047 REQUIREMENTS: Exp °i° Expenditures ,p Personal Services 5,826,717 5,537,265 289,452 1000% 959% b)'' 5,826,717 5,575,555 251,162 Materials and Services 7,554,774 7,494,605 60,169 100% 99% i):' 7,554,774 7,383,928 170,846 Capital Outlay 10,000 - 10,000 100% 0% 10,000 5,000 5,000 Transfers Out 150,000 150,000 - 100% 100% 150,000 150,000 - Contingency 1,686,503 - 1,686,503 100% n/a 1,686,503 - 1,686,503 TOTAL REQUIREMENTS 15,227,994 13,181,870 2,046,124 100% 87% 15,227,994 13,114,483 2,113,511 NET (Resources - Requirements) - 2,558,990 2,558,990 - 2,701,558 2,701,558 Beginning NWC per FY 05-06 Adopted Budget 2;690;341. 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) Mental Health has been running an average vacancy rate of 5-6 FTE for 2004/05. c) Revenues generated by billings to other government agencies. Billings and payments lag behind normal schedule the first 9 months of fiscal year. Full amount budgeted expected to be received. d) Grant for $25,000 approved subsequent to 2004/05 budget adoption. e) Non -OHP client revenues have been very high for fiscal year 2004/05. Adjustments are reflected in the 2005/06 budget. I) 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. Will typically always be 1 or 2 payments behind. 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 conscious decision to direct more ABHA funds to this area of need. i) Not spending about $105,000 set aside as a type of contingency for possible cost over -runs at Sage View. MENTAL HEALTH Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year End Year to Date Budget Actual Variance F %% Coll. % Budget I Projection Variance RESOURCES: Beg. Net Working Capital $1,402,580 $ 1,634,080 $ 231,500 100% 117% a) $1,402,580 $1,634,080 $ 231,500 Revenues Marriage Licenses 5,500 5,590 90 100% 102% 5,500 5,203 (297) Divorce Filing Fees 100,000 110,309 10,309 100% 11o% 100,000 109,725 9,725 Federal Grants 99,410 - (99,410) 100% 0% C�,�--.; 99,410 99,410 - State Grants 8,516,563 8,613,664 97,101 100% 101% 8,516,563 8,585,367 68,804 State Miscellaneous 409,687 334,892 (74,795) 100% 82% c) 409,687 409,687 - ABHA-Inpatient 129,189 130,971 1,782 100% 101% 129,189 117,393 (11,796) Title 19 114,645 274,481 159,836 100% 239% e) ` 114,645 263,768 149,123 Liquor Revenue 86,000 101,896 15,896 100% 118%,,86,000 P 86,000 - ABHA Client Support Funds 15,000 30,000 15,000 100% 200% .h} " 15,000 30,000 15,000 School Districts 243,000 243,000 - 100% 100% ' 243,000 243,000 - Mental Health Jail Comp 7,640 7,200 (440) 100% 94% 7,640 7,237 (403) Miscellaneous 45,750 68,726 22,976 100% 150% d) 45,750 70,750 25,000 Patient Insurance Fees 129,957 206,406 76,449 100% 159% 6)!,sj 129,957 198,423 68,466 Patient Fees 16,421 15,374 (1,047) 100% 94% 16,421 15,542 (879) Seizure/Forfeiture - 25,937 25,937 100% n/a ;` ' - Interest on Investments 30,000 60,636 30,636 100% 202% §)k 30,000 58,587 28,587 Rentals 16,000 15,878 (122) 100% 99% 16,000 16,000 - Donation - 100 100 100% n/a - 100 100 Interfund Contracts 56,907 57,975 1,068 100% 102% 56,907 62,024 5,117 Administrative Fee 2,463,023 2,463,023 - 100% 100% 21463,023 2,463,023 - Total Revenues 12,484,692 12,766,058 281,366 100% 102% 12,484,692 12,841,239 356,547 Transfers In -General Fund 940,722 940,722 - 100% 100% 940,722 940,722 - Transfers In -Other 400,000 400,000 - 100% 100% i 400,000 400,000 - TOTAL RESOURCES 15,227,994 15,740,860 512,866 10001a 103016 15,227,994 15,816,041 588,047 REQUIREMENTS: Exp °i° Expenditures ,p Personal Services 5,826,717 5,537,265 289,452 1000% 959% b)'' 5,826,717 5,575,555 251,162 Materials and Services 7,554,774 7,494,605 60,169 100% 99% i):' 7,554,774 7,383,928 170,846 Capital Outlay 10,000 - 10,000 100% 0% 10,000 5,000 5,000 Transfers Out 150,000 150,000 - 100% 100% 150,000 150,000 - Contingency 1,686,503 - 1,686,503 100% n/a 1,686,503 - 1,686,503 TOTAL REQUIREMENTS 15,227,994 13,181,870 2,046,124 100% 87% 15,227,994 13,114,483 2,113,511 NET (Resources - Requirements) - 2,558,990 2,558,990 - 2,701,558 2,701,558 Beginning NWC per FY 05-06 Adopted Budget 2;690;341. 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) Mental Health has been running an average vacancy rate of 5-6 FTE for 2004/05. c) Revenues generated by billings to other government agencies. Billings and payments lag behind normal schedule the first 9 months of fiscal year. Full amount budgeted expected to be received. d) Grant for $25,000 approved subsequent to 2004/05 budget adoption. e) Non -OHP client revenues have been very high for fiscal year 2004/05. Adjustments are reflected in the 2005/06 budget. I) 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. Will typically always be 1 or 2 payments behind. 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 conscious decision to direct more ABHA funds to this area of need. i) Not spending about $105,000 set aside as a type of contingency for possible cost over -runs at Sage View. RESOURCES: Beg. Net Working Capital Revenues Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Prog Env Health-Lic Facilities Env Health -Grant Env Health - Drinking H2O Planning -Current Planning -Long Range Total Revenues Trans In -CDD Reserve Trans In -CDD Bldg/Elec TOTAL RESOURCES COMMUNITY DEVELOPMENT Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Budget Actual Variance FY % Coll. % $ 1,135,377 $ 1,135,377 - 100% n/a:;: Year End Budget I Proiection Variance $1,135,377 $1,135,377 - 35,200 140,065 104,865 100% 398% a}:; 35,200 120,000 84,800 13,000 12,502 (498) 100% 96% 932,344 13,000 11,700 (1,300) 244,350 310,973 66,623 100% 127% 15) 244,350 292,000 47,650 1,917,285 2,295,983 378,698 100% 120% b).`, 1,917,285 2,175,000 257,715 502,250 599,863 97,613 100% 119% b} 502,250 571,000 68,750 602,620 951,391 348,771 100% 158% b) 602,620 1,040,000 437,380 698,020 821,825 123,805 100% 118% (32,592) 698,020 738,000 39,980 384,375 448,229 63,854 100% 117% c} 384,375 435,000 50,625 118,000 55,239 (62,761) 100% 47% tl) ` 118,000 105,500 (12,500) 40,170 57,030 16,860 100% 142% eff' 40,170 48,270 8,100 853,925 994,201 140,276 100% 116% b)•' 853,925 960,000 106,075 471,007 509,018 38,011 100% 108%,471,007 487,000 15,993 REQUIREMENTS: EXPENDITURES & TRANSFERS 5,880,202 7,196,319 1,316,117 100% 122% 5,880,202 6,983,470 1,103,268 7,015,579 8,331,696 1,316,117 Admin -Operations Division 3,070,656 2,740,043 330,613 Admin -GIS Division 168,703 165,326 3,377 Admin -Code Enforcement 152,044 155,254 (3,210) Building Safety Division 924,403 932,344 (7,941) Electrical Division 337,352 365,910 (28,558) Contract Services 352,523 353,791 (1,268) Env Health -On Site Pgm 373,322 386,133 (12,811) Env Health-Lic Facilities 311,997 303,764 8,233 Env Health -Grant Division 95,521 46,826 48,695 Env Health - Drinking H2O 43,835 44,155 (320) Planning -Current Division 780,115 806,242 (26,127) Planning -Long Range Div 405,408 439,897 (34,489) 100% 0% 100% 0% 100% 119% Exp. % 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% TOTAL REQUIREMENTS 7,015,879 6,739,685 276,194 100% NET (Resources - Requirements) (300) 1,592,011 1,592,311 Beginning NWC per FY 05-06 Adopted Budget 100 - (100) 200 - (200) 7,015,879 8,118,847 1,102,968 89% , 3,070,656 2,775,000 295,656 98%• 168,703 168,000 703 102%; 152,044 158,000 (5,956) 101% 924,403 910,000 14,403 108% ,f}j 337,352 356,000 (18,648) 100% 352,523 346,000 6,523 103% 373,322 372,000 1,322 97% 311,997 311,000 997 49% e).i 95,521 84,000 11,521 101% 43,835 44,000 (165) 103% 780,115 778,000 2,115 109% ;g)! 405,408 438,000 (32,592) 96% 7,015,879 6,740,000 275,879 - 1,378,847 1,378,847 4;466,053:= a) Increased amount is due to 1) revenue associated with a new addressing services contract with the City of Redmond, 2) Higher than expected fund balance which generated additional interest earnings, and 3) Road access permits higher than expected. b) Seasonal volume -permit volume higher in warmer months. Year-end totals projected to be higher than expected. c) Licensed Facility revenue is primarily received in January/February after license renewal notices are issued. d) EPA grant bills typically lag behind billing 2-3 months, although revenue/expense will be lower than budgeted. e) Revenue is received in lump payments --year end estimate has been modified based on experience. f) Expenses high due to use of part time extra help to meet demand. g) Expenses high due primarily to expenses tied to previously received grant funds (tree thinning). 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 Interfund Contract Donations Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Sale of Eqp & Material Sale of Public Lands Total Revenues ROAD Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Year End Budget Actual I Variance FY % I Coll. % Budget Projection Variance $4,992,257 $ 5,475,344 $ 483,087 100% 110% $ 4,992,257 $ 5,475,344 $ 483,087 2,960,000 2,967,469 7,469 100% 100% - 2,177 2,177 100% n/a 7,000,000 7,390,686 390,686 100% 106% 50,000 70,255 20,255 100% 141%` 200,000 409,490 209,490 100% 205%; - 39,998 39,998 100% n/a 32,000 - (32,000) 100% 0%'' 32,000 64,960 32,960 100% 203% 2,000 1,500 (500) 100% 75% 60,000 138,273 78,273 100% 230%'I`'. 15,000 23,500 8,500 100% 157%'' - 26,640 26,640 100% n/a g 2,400 2,684 284 100% 112%'1' 200,000 231,697 31,697 100% 116%i 70,000 84,667 14,667 100% 121%_' 100,000 47,749 (52,251) 100% 48% " 30,000 45,964 15,964 100% 153% 245,000 376,604 131,604 100% 154%< 500 443 (57) 100% 89% 10,998,900 11,924,756 925,856 100% 108% Transfers In -Road Imprvmt 290,000 290,000 - 100% 100% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 16,281,157 17, 690,100 1,408, 943 100% 4,272,702 4,201,666 71,036 100% 6,672,981 6,388,464 284,517 100% 4,125,760 562,936 3,562,824 100% 870,000 870,000 - 100% 339,714 - 339,714 100% 16,281,157 12,023,066 4,258,091 100% NET (Resources - Requirements) - 5,667,034 5,667,034 Beginning NWC per FY 05-06 Adopted Budget 2,960,000 2,967,469 7,469 - 2,177 2,177 7,000,000 7,400,000 400,000 50,000 80,000 30,000 200,000 380,000 180,000 - 39,998 39,998 32,000 - (32,000) 32,000 65,644 33,644 2,000 2,000 - 60,000 134,320 74,320 15,000 23,508 8,508 2,400 2,684 284 200,000 200,000 - 70,000 78,000 8,000 100,000 45,000 (55,000) 30,000 15,000 (15,000) 245,000 265,000 20,000 500 443 (57) 10,998,900 11,701,243 702,343 290,000 290,000 - i 100% 16,281,157 17,466,587 1,185,430 Exp. 98% 4,272,702 4,214,985 57,717 96% f) 6,672,981 6,713,790 (40,809) 14% g)' 4,125,760 611,500 3,514,260 100% 870,000 870,000 - n/a 339,714 - 339,714 74% i 16,281,157 12,410,275 3,870,882 - 5,056,312 5,056,312 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) Gas prices and asphalt prices have increased substantially. g) Capital projects to be paid at completion. 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 Misdemeanor Probation Fees Interest on Investments Leases Rentals Interfund Contract Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) ADULT PAROLE & PROBATION Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Revised Year End Budget Actual Variance FY % I Coll. % Budget Projection Variance $ 413,036 $ 424,448 $ 11,412 100% 103%:_.::'7$ 413,036 $ 424,448 $ 11,412 1,785,713 1,906,926 121,213 100% 107%' 11,327 12,523 1,196 100% 111%k:, 11,859 31,877 20,018 100% 269%'".!' 800 769 (31) 100% 96% 9,100 12,235 3,135 100% 134%`' 183,000 104,079 (78,921) 100% 57%, 175,000 219,383 44,383 100% 125% ° - 70 70 100% n/a i. 2,000 571 (1,429) 100% 29% 3,000 553 (2,447) 100% 18%m'. - 1,755 1,755 100% n/a 11 3,600 11,244 7,644 100% 312%';'` 13,200 15,727 2,527 100% 119% 3,600 1,545 (2,055) 100% 43%,.; 71,255 71,255 - 100% 100%'' 2,273,454 2,390,512 117,058 100% 105% 22,300 22,300 100% n/a 1,785,713 11,327 11,859 800 9,100 183,000 175,000 2,000 3,000 3,600 13,200 3,600 71,255 2,273,454 1,906,926 121,213 11,327 - 31,000 19,141 750 (50) 14,700 5,600 108,000 (75,000) 213,000 38,000 70 70 600 (1,400) 540 (2,460) 10,950 7,350 15,000 1,800 1,350 (2,250) 71,255 - 2,385,468 112,014 300 22.300 2,686,490 2,837,260 150,770 100% 106% 2,686,490 2,809,916 123,426 2,099,923 1,969,979 129,944 100% 541,081 538,468 2,613 100% 100 - 100 100% 45,386 - 45,386 100% 2,686,490 2,508,447 178,043 100% Beginning NWC per FY 05-06 Adopted Budget 328,813 328,813 94% 2,099,923 2,000,000 99,923 100% 541,081 541,081 - 0% 100 100 - n/a 45,386 - 45,386 93% 2,686,490 2,541,181 145,309 - 268,735 268,735 _ . 200,0001: 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) Appropriation Transfer from General Fund was required to allow for the expenditure of the un -budgeted resource received from Risk Management related to general liability settlement. Comm. on Children & Families Statement of Financial Operating Data Twelve Months Ended June 30, 2005 Year to Date Year End Budget Actual Variance I FY % I Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 519,640 $ 642,357 $ 122,717 100% 124% $ 519,640 $ 642,357 $ 122,717 Revenues Federal Grants 145,706 145,706 - 100% 100% 145,706 145,706 - Title IV - Family Sup/Pres 35,594 35,594 - 100% 100% 35,594 35,594 - HealthyStart Medicaid 200,000 218,884 18,884 100% 109% 200,000 218,884 18,884 Child Care Block Grant 53,393 53,394 1 100% 100% 3 53,393 53,394 1 Level 7 Services 175,531 175,533 2 100% 100% 175,531 175,533 2 Juvenile Crime Prevention 340,710 340,710 - 100% 100% 1 340,710 340,710 - State Prevention Funds 78,135 78,635 500 100% 101% 78,135 78,135 - HealthyStart /R -S -G 225,134 130,582 (94,552) 100% 58% a} 225,134 130,582 (94,552) OCCF Grant 351,539 339,520 (12,019) 100% 97% b) 351,539 339,520 (12,019) LotteryGrant - 6,234 6,234 100% n/a 6,234 6,234 Sale Map Photo or Copies - 2,453 2,453 100% n/a - 2,453 2,453 Miscellaneous 17,000 33,992 16,992 100% 2000/c 17,000 18,000 1,000 Interest on Investments 12,000 19,571 7,571 100% 163% = 12,000 21,000 9,000 Grants -Private 19,662 7,800 (11,862) 100% 40%.1.1119,662 7,800 (11,862) Total Revenues 1,654,404 1,588,608 (65,796) 1,654,404 1,573,545 (80,859) Trans from General Fund 400,000 404,000 4,000 100% -101% ,' 400,000 400,000 - Trans from Other 176,500 176,500 - 100% 100% 176,500 176,500 - Total Transfers In 576,500 580,500 4,000 100% 101% 576,500 576,500 - TOTAL RESOURCES 100% 102% 2,750,544 2,811,465 60,921 2,750,544 2,792,402 41,858 REQUIREMENTS: Exp Expenditures Personal Services 403,754 403,628 126 100% 100% c)` 403,754 402,995 759 Materials and Services 2,017,077 1,814,515 202,562 100% 90% d) 2,017,077 1,820,037 197,040 Capital Outlay 8,500 4,546 3,954 100% 53% 8,500 8,500 - Contingency 321,213 - 321,213 100% n/a 321,213 - 321,213 TOTAL REQUIREMENTS 2,750,544 2,222,689 527,855 100% 81% 2,750,544 2,231,532 519,012 NET (Resources - Requirements) - 588,776 588,776 - 560,870 560,870 Beginning NWC per FY 05-06 Adopted Budget 560,870: 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 increased due to Director position being filled. d) Materials & Services projection reduced by $110,000 for Medicaid match. SOLID WASTE Statement of Financial Operating Data Twelve Months Ended June 30, 2005 a) Grant monies generally received after projects are completed. b) Franchise revenues are up due to continued growth in County. c) Seasonal revenues. d) Local clean up projects unanticipated. e) High return on sale of recylables at present time. D Many larger expenditures in M&S have not been done i.e. engineering, and special waste events. g) Deficit to made up by an appropriations transfer from contingency and excess M & S. Year to Date Year End Budget Actual Variance I FY % I Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $1,142,974 $ 1,665,740 $ 522,766 100% 146% $1,142,974 $ 1,665,740 $ 522,766 Revenues State Grant 53,100 - (53,100) 100% 0% a) < 53,100 28,100 (25,000) Miscellaneous 23,000 25,730 2,730 100% 112% 23,000 24,000 1,000 Franchise 3% Fees 120,000 164,855 44,855 100% 137% :,b} 120,000 164,855 44,855 Commercial Disp. Fees 800,000 1,005,708 205,708 100% 126% ; 800,000 1,000,000 200,000 Private Disposal Fees 1,575,000 1,799,381 224,381 100% 114% ;, 1,575,000 1,723,000 148,000 ;. Franchise Disposal Fees 3,850,000 3,912,395 62,395 100% 102% 7'I 3,850,000 3,950,000 100,000 Yard Debris 25,000 48,136 23,136 100% 193%c = 25,000 45,000 20,000 Special Waste 25,000 58,479 33,479 100% 234% m} 25,000 60,000 35,000 Interest 30,000 54,909 24,909 100% 183% All .; 30,000 51,000 21,000 Sale of Equip & Material 15,000 58,933 43,933 100% 393% .e) 15,000 56,000 41,000 Total Revenues 6,516,100 7,128,526 612,426 100% 109% 6,516,100 7,101,955 585,855 TOTAL RESOURCES 100% 715% '; 7,659,074 8,794,266 1,135,192 7,659,074 8,767,695 1,108,621 REQUIREMENTS Exp Expenditures Personal Services 1,331,543 1,333,596 (2,053) 100% 100% 1,331,543 1,324,531 7,012 Materials and Services 2,972,253 2,568,829 403,424 100% 86% f) 2,972,253 2,678,869 293,384 Debt Service 381,028 381,028 - 100% 100% 381,028 381,028 Capital Outlay 124,250 119,491 4,759 100% 96% 124,250 124,402 (152) Transfers Out 2,850,000 2,850,000 - 100% 100% g)„ 2,850,000 2,850,000 - Contingency - - - 100% n/a TOTAL REQUIREMENTS 7,659,074 7,252,944 406,130 100% 95% 7,659,074 7,358,830 300,244 NET (Resources - Requirements) - 1,541,322 1,541,322 - 1,408,865 1,408,865 Beginning NWC per FY 05-06 Adopted Budget 1 378;01.0. a) Grant monies generally received after projects are completed. b) Franchise revenues are up due to continued growth in County. c) Seasonal revenues. d) Local clean up projects unanticipated. e) High return on sale of recylables at present time. D Many larger expenditures in M&S have not been done i.e. engineering, and special waste events. g) Deficit to made up by an appropriations transfer from contingency and excess M & S. Health Benefits Trust • Statement of Financial Operating Data Twelve Months Ended June 30, 2005 TOTAL RESOURCES 12,154,009 Year to Date 353,147 100% 103%'3 Budget Actual Variance FY % Coll. % RESOURCES Expenditures: Beg. Net Working Capital $ 3,057,642 $3,057,642 $ - 100% 100% Revenues: Materials & Services Internal Premium Charges 7,584,487 7,874,292 289,805 100% 104% .- P/T Emp - Add'I Prem 156,545 132,695 (23,850) 100% 85% Employee Prem Contribution 292,000 313,885 21,885 100% 107% COIC 587,556 595,708 8,152 100% 101% Retiree / COBRA Co -Pay 411,601 380,243 (31,358) 100% 92% Medical Services Reimb - 50,000 50,000 100% n/a Interest 54,000 81,832 27,832 100% 152% Prescription Rebates 10,178 20,859 10,681 100% n/a: Total Revenues 9,096,367 9,449,514 353,147 100% 100% TOTAL RESOURCES 12,154,009 12,507,156 353,147 100% 103%'3 REQUIREMENTS Exp. % Expenditures: Personal Services 110,935 110,510 425 100% 100%=; ' Materials & Services Conferences and Seminars 3,000 1,382 1,618 100% 46%'^ Claims Paid-Medical/Rx 7,164,174 5,694,488 1,469,686 100% 79% i3a b Claims Paid-Dental/Vision 1,188,082 1,080,897 107,185 100% 91w,a) b}' Insurance Expense 304,419 307,636 (3,217) 100% 101w State Assessments 31,874 34,901 (3,027) 100% 109% c) Administrators West 163,188 166,963 (3,775) 100% 102%. PPO Fee 30,200 29,169 1,031 100% 97%.,.;•, ,:•,''. Printing 22,728 7,948 14,780 100% 35% . Program Expense/Supplies 3,898 2,844 1,054 100% 73% Refunds - 35,252 (35,252) 100% n/a d} Other 21,978 28,920 (6,942) 100% 132% ` Total Materials & Services 8,933,541 7,390,400 1,543,141 100% 83%. Capital Outlay 100 - 100 100% 0% Trans Out - Insurance Fund 420,000 420,000 - 100% 100% d) Contingency 2,689,433 - 2,689,433 100% 0% TOTAL REQUIREMENTS 11,734,009 7,920,910 4,233,099 100% 65%;. NET (Resources - Requirements) 420,000 4,586,246 4,586,246 Beginning NWC per FY 05-06 Adopted Budget x`. 4;400 ROM a) 52 weeks of claims paid. $5,746,759 for Medical/Rx and $1,080,897 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. c) State Assessments: August=$13,966.64; January=$20,934.15 d) Repayment of reserves, plus accrued interest, to COIC and Insurance Fund. DESCHUTES COUNTY 911 Statement of Financial Operating Data Twelve Months Ended June 30, 2005 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 2,370,156 2,208,368 161,788 100% 605,840 581,319 24,521 Year End 496,753 394,254 Year to Date 100% 130,000 130,000 Budget Actual Variance I % of FY % Coll. 100% Bud et Projection Variance RESOURCES: - 1,720,945 1,720,945 1,600,000'-` Beg. Net Working Capital $ 600,000 $1,230,708 $ 630,708 100% 205% $ 600,000 $1,230,708 $ 630,708 Revenues Property Taxes - Current 2,800,000 2,885,765 85,765 100% 103% 2,800,000 2,897,190 97,190 Property Taxes - Prior 60,000 73,336 13,336 100% 122% 60,000 75,286 15,286 State Reimbursement 3,000 17,311 14,311 100% 577% 3,000 18,500 15,500 Telephone User Tax 520,000 728,404 208,404 100% 140% a 520,000 600,000 80,000 Data Network Reimb. 25,000 27,437 2,437 100% 110%,,,. -` 25,000 28,000 3,000 Jefferson County 20,000 31,785 11,785 100% 159% 20,000 32,000 12,000 Alarm Monitoring Fees 6,000 6,960 960 100% 116% 6,000 6,960 960 User Fee 20,000 8,653 (11,347) 100% 43% 20,000 8,653 (11,347) Miscellaneous 4,500 6,898 2,398 100% 153% 4,500 6,500 2,000 Interest 10,000 38,140 28,140 100% 381% 10,000 35,000 25,000 Interest on Unsegregated Tax 700 1,238 538 100% 177%.',,700 1,238 538 Total Revenues 3,469,200 3,825,927 356,727 100% 110% 3,469,200 3,709,327 240,127 TOTAL RESOURCES 4,069,200 5,056,635 987,435 100% 124% , 4,069,200 4,940,035 870,835 REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 2,370,156 2,208,368 161,788 100% 605,840 581,319 24,521 100% 496,753 394,254 102,499 100% 130,000 130,000 - 100% 466,451 - 466,451 100% 4,069,200 3,313,941 755,259 100% NET (Resources - Requirements) - 1,742,694 1,742,694 Beginning NWC per FY 05-06 Adopted Budget 93% 2,370,156 2,180,250 189,906 96% 605,840 605,840 - 79% 496,753 303,000 193,753 100% 130,000 130,000 - n/a 466,451 - 466,451 81%::.: 4,069,200 3,219,090 850,110 - 1,720,945 1,720,945 1,600,000'-` a) Distribution of telephone tax occurs quarterly. Actual to Date does not include 4th quarter. Memorandum Date: August 18, 2005 To: Board of County Commissioners Mike Maier, County Administrator From: Marty Wynne, Finance Director RE: Monthly Financial Reports Attached please find July 2005 financial reports for the following funds: General (001), Community Justice — Juvenile (230), Sheriffs (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 Board of County Comm. District Attorney Finance/Tax Veterans Property Management Grant Projects Total Revenues GENERALFUND Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Revised Bud Actual I Variance I FY % FColi. $ 4,800,000 $ 5,564,668 $ 764,668 100% 116% $4,800,000 $5,564,668 $ 764,668 16% 1,308,333 Year End $ % Budget Projection Variance Variance $4,800,000 $5,564,668 $ 764,668 16% 1,308,333 57,446 (1,250,887) 8% 0% 15,700,000 15,700,000 - 0% 148,263 342,392 194,129 8% 19%,` 1,779,160 1,779,160 - 0% 86,075 236,165 150,090 8% 23% �"' 1,032,897 1,032,897 - 0% 140,533 221,440 80,907 8% 13% ti 1,686,400 1,686,400 - 0% 1,166 3,847 2,681 8% 28% '; , 13,986 13,986 - 0% - - - 8% n/a - - - n/a 21,070 - (21,070) 8% r 0% 252,843 252,843 - 0% 18,496 55,345 36,849 8% 25% ";` 221,950 221,950 - 0% 833 - (833) 8% 0% - ? 10,000 10,000 - 0% 4,708 4,767 59 8% 3� 8% s 56,500 56,500 - 0% 8,933 167 (8,766) 8% 8% 107,200 107,200 - 0% 1,738,410 921,569 (816,841) 8% 4% 20,860,936 20,860,936 - 0% TOTAL RESOURCES 6,538,410 6,486,237 (52,173) 8% 25% 25,660,936 26,425,604 764,668 3% REQUIREMENTS: Exp 0 Expenditures_, Assessor 272,425 231,085 41,340 8% 7% 3,269,098 3,269,098 - 0% County Clerk 109,892 78,418 31,474 8% 6%."11,1,318,705 1,318,705 - 0% BOPTA 4,508 3,343 1,165 8% 6% 54,091 54,091 - 0% BOCC 48,783 39,415 9,368 8% 7% 585,393 585,393 - 0% District Attorney 292,775 244,905 47,870 8% 7% 3,513,299 3,513,299 - 0% Finance/Tax 61,816 44,000 17,816 8% 6% 741,786 741,786 - 0% Veterans 13,009 10,069 2,940 8% 6% 156,106 156,106 - 0% Property Management 12,705 9,121 3,584 8% 6%::..152,454 152,454 - 0% Grant Projects 12,417 6,213 6,204 8% 4%..,149,005 149,005 - 0% Non -Departmental 58,068 68,702 (10,634) 8% 10% • 696,811 696,811 - 0% Contingency 249,465 249,465 8% n/a 2,993,585 - 2,993,585 100% 1,135,863 735,271 400,592 8% 5%. .:.' 13,630,333 10,636,748 2,993,585 22% Transfers Out 922,863 873,916 48,947 8% 8% `: 11,074,353 11,074,353 - 0% TOTAL REQUIREMENTS 2,058,726 1,609,187 449,539 8% 7% s; 24,704,686 21,711,101 2,993,585 12% Appropriation Transfers _ NET (Resources - Requirements) 4,479,684 4,877,050 397,366 ' ' 956,250 4,714,503 3,758,253 * Unappropriated Ending Fund Balance RESOURCES: Beg. Net Working Capital Revenues Federal Grants SB #1065 -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 Level 7 Total Revenues COMM JUSTICE -JUVENILE Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Budget Actual I Variance FY % I Coll. $ 182,218 $ 254,905 $ 72,687 100% n/a 5,081 ear n (5,081) 8% 3,512 3,036 (476) 8% 507 14,263 (507) 8% 3,169 171,159 (3,169) 8% 18,845 107,266 (18,845) 8% 5,833 72,687 72,687 (5,833) 8% 233 (233) 8% 56,397 24,571 (31,826) 8% 277 (277) 8% 211 125 (86) 8% 500 1,207 707 8% 2,850 2,660 (190) 8% 97,415 31,599 (65,816) 8% 0% 7% 0% 0% 0% 0% 0% 4% 0% 5% 20% 8% 0% 2% $ 182,218 $ 254,905 $ 72,687 60,977 42,146 6,088 38,033 226,138 70,000 2,800 676,758 3,324 2,526 6,000 34,200 97,176 1,266,166 Transfers In -General Fund 439,193 430,193 (9,000) 8% 8% e 5,270,310 Transfers In -Sheriff 2,500 (2,500) 8% 0% 30,000 TOTAL RESOURCES 721,326 716,697 (2,129) 8% 11%, 6,748,694 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 191,185 180,583 10,602 8% 137,861 70,929 66,932 8% - - - 8% 202,002 ear n 7,672 Bud et Pro ection I Variance $ 182,218 $ 254,905 $ 72,687 60,977 42,146 6,088 38,033 226,138 70,000 2,800 676,758 3,324 2,526 6,000 34,200 97,176 1,266,166 Transfers In -General Fund 439,193 430,193 (9,000) 8% 8% e 5,270,310 Transfers In -Sheriff 2,500 (2,500) 8% 0% 30,000 TOTAL RESOURCES 721,326 716,697 (2,129) 8% 11%, 6,748,694 REQUIREMENTS: Expenditures Community Justice -Juvenile Personal Services Materials and Services Capital Outlay Juvenile Resource Center Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 191,185 180,583 10,602 8% 137,861 70,929 66,932 8% - - - 8% 202,002 194,330 7,672 16,822 9,275 7,547 250 - 250 14,263 3,000 14,263 n/a 171,159 171,159 - 562,383 455,117 107,266 158,943 261,580 105,137 8% 8% 8% 8% 8% 60,977 42,146 6,088 38,033 226,138 70,000 2,800 676,758 3,324 2,526 6,000 34,200 97,176 1,266,166 5,270,310 30,000 6,821,381 72,687 8%.2,294,214 2,294,214 4% -j 1,654,332 1,654,332 0% :.;. 100 100 - 8% 2,424,020 2,424,020 - 5% :' 201,869 201,869 - 0%: 3,000 3,000 - n/a 171,159 171,159 - 7%;:,'.'' 6,748,694 6,748,694 - - 72,687 72,687 SHERIFF Rev Detail Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End RESOURCES: Budget Actual Variance FY % Coll. % Budget I Projection Variance Beg. Net Working Capital $1,648,031 $1,553,204 $ (94,827) 100% 94% $1,648,031 $1,553,204 $ (94,827) Revenues Tax Revenues - Current 1,129,167 (1,129,167) 8% 0% 13,550,000 13,550,000 - Tax Revenues - Prior 25,583 46,034 20,451 8% 15% .. 307,000 307,000 - Federal Grants 5,208 (5,208) 8% 0% 62,500 62,500 - U.S. Forest Service 6,000 (6,000) 8% 0% 72,000 72,000 - State Grant 6,879 (6,879) 8% 0%., 82,548 82,548 - SB#1065-Court Assess. 3,542 3,036 (506) 8% 7% 42,500 42,500 - Marine Board Lic. Fee 8,174 (8,174) 8% 0% 98,082 98,082 - Narcotic Task Force Grt. 9,167 (9,167) 8% 0% 110,000 110,000 - Transp. of State Wards 417 (417) 8% 0% ' 5,000 5,000 - SB 1145 123,255 (123,255) ° 8/° ° 0% 1,479,061 1,479,061 - City of Sisters 29,725 29,725 - 8% 8% " 356,694 356,694 - Security & Traffic Reimb 11,875 1,436 (10,439) 8% 1% 3 142,500 142,500 - Seat Belt Program 500 (500) 8% 0% 6,000 6,000 - Inmate/Prisoner Housing 250 (250) 8% 0% 3,000 3,000 - Inmate Commissary Fees 0% 1 64,000 64,000 - Soc Sec Incentive -Fed 250 (250) 8% 0%r 3,000 3,000 - Miscellaneous 1,000 826 (174) 8% 7% 12,000 12,000 - Contracted Training - 50 50 8% n/a - 50 50 Medical Services Reimb 1,167 (1,167) 8% 0% 14,000 14,000 - Restitution 167 (167) 8% 0% 9' 2000, 2,000 - Sheriff Fees 12,250 10,724 (1,526) 8% 7% 147,000 147,000 - Court Fines and Fees 14,583 13,399 (1,184) 8% 8% 175,000 175,000 - Impound Fees 6,667 6,200 (467) 8% 8% 80,000 80,000 - Interest 4,167 3,789 (378) 8% 8%' 50,000 50,000 Interest on Unsegregated 333 62 (271) 8% 2% 41000 4,000 - Rentals 3,611 3,662 51 8% 8 1, 43,333 43,333 - Interfund Contract 34,918 10,703 (24,215) 8% 3% 419,018 419,018 - Transport Reimbursements 83 (83) 8% 0%-- ='i 1,000 1,000 - Sale of Eqp &Material - - 8% Total Revenues 1,438,938 129,646 (1,309,292) 8% 1% 17,331,236 17,331,286 50 Transfers In 220,833 177,369 (43,464) 8% 7% 2,650,000 2,650,000 - TOTALRESOURCES 3,307,802 1,860,219 (1,447,583) 8% 9%>,;a 21,629,267 21,534,490 (94,777) REQUIREMENTS:Exp °i° EXPENDITURES & TRANSFERS Sheriffs Division 120,747 95,867 24,880 8% 7% 1,448,961 1,448,961 - Automotive/Communications 85,202 41,234 43,968 8% 4% ;; 1,022,422 1,022,422 - Investigations/Evidence 141,304 135,568 5,736 8% 8% 1,695,651 1,695,651 - Patrol/Civil/Comm Supp 562,497 518,220 44,277 8% 8% ..; 6,749,959 6,749,959 - Records 50,134 48,465 1,669 8% 8% 601,608 601,608 - Adult Jail 571,667 482,407 89,260 8% 7% 6,860,002 6,860,002 - Transport/Court Security 16,120 15,603 517 8% 8% 193,440 193,440 - Emergency Services 9,081 8,152 929 8% 7% - 108,972 108,972 - Special Services Division 38,951 50,795 (11,844) 8% 11%- ` 467,409 467,409 - Training Division 10,872 8,753 2,119 8% 7% 130,461 130,461 - Contingency 176,699 - 176,699 8% 0% 2,120,382 - 2,120,382 Transfers Out 19,167 - 19,167 8% 0% 230,000 230,000 - TOTAL REQUIREMENTS 1,802,441 1,405,064 397,377 8% 6% 21,629,267 19,508,885 2,120,382 NET(Resources- Requirements) 1,505,361 455,155 (1,050,206) 2,025,605 2,025,605 SHERIFF Exp Detail Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance I FY/. T Coll. % L Budget I Projection Variance RESOURCES: Beg. Net Working Capital $1,648,031 $1,553,204 $ (94,827) 100% 94% $1,648,031 $1,553,204 $ (94,827) Total Revenues 1,438,938 129,646 (1,309,292) 8% 1% 3 17,331,236 17,331,286 50 Transfers In 220,833 177,369 (43,464) 8% 7% 2,650,000 2,650,000 - TOTAL RESOURCES 3,307,802 1,860,219 (1,447,583) 8% 9% 21,629,267 21,534,490 (94,777) REQUIREMENTS: EXp. Y Sheriff's Services Personnel 63,482 59,214 4,268 8% 8% 761,780 761,780 - Materials & Services 54,545 34,475 20,070 8% 5% 654,542 654,542 Capital Outlay 542 - 542 8% 0% 6,500 6,500 - Total Sheriffs Services 118,569 93,689 24,880 1,422,822 1,422,822 - Automotive/Communications ; z, Personnel 18,691 18,681 10 8% 8% 224,297 224,297 Materials & Services 60,885 22,553 38,332 8% 3% 730,625 730,625 Capital Outlay 5,625 5,625 8% 0% 67,500 67,500 - Total Automotive/Communications 85,201 41,234 43,967 1,022,422 1,022,422 - Investigations/Evidence Personnel 120,306 127,823 (7,517) 8% 9% 1,443,676 1,443,676 - Materials & Services 18,081 7,745 10,336 80/0 40X 216,975 216,975 - Capital Outlay 2,917 2,917 8% 0% 351000 35,000 - Totallnvestigations/Evidence 141,304 135,568 5,736 1,695,651 1,695,651 - Patrol/Civil/Comm Support Personnel 504,526 495,433 9,093 8% 8% 6,054,306 6,054,306 - Materials & Services 39,592 22,787 16,805 8% 5% 475,104 475,104 - Capital Outlay 18,379 - 18,379 8% 0% 220,549 220,549 - Transfers Out 2,500 - 2,500 8% 0% 30,000 30,000 - Total Patrol/Civil/Comm Supp 564,997 518,220 46,777 6,779,959 6,779,959 - Records Personnel 41,519 41,030 489 8% 80/c 498,229 498,229 Materials & Services 8,607 7,435 1,172 8% 7% 103,279 103,279 - Capital Outlay - - - 8% 0% A. 100 100 - Total Records 50,126 48,465 1,661 4 601,608 601,608 - Adult Jail Personnel 450,079 437,122 12,957 8% 8% , 5,400,947 5,400,947 - Materials & Services 114,992 31,939 83,053 8% . 2% t' 1,379,909 1,379,909 - Capital Outlay 6,596 13,346 (6,750) 8% 17% , 79,146 79,146 - Total Adult Jail 571,667 482,407 89,260 6,860,002 6,860,002 - Transgort/Court Security u Personnel 14,896 15,278 (382) 8% 9% 178,746 178,746 - Materials & Services 1,216 325 891 8% 2%.:.,.:,- 14,594 14,594 Capital Outlay - - - 8% 0% 100 100 - Total Transport/Court Security 16,112 15,603 509 193,440 193,440 - Emergency Services Personnel 7,874 7,874 - 8% 8% 94,490 94,490 - Materials & Services 1,199 278 921 8% 2%.'14,382 14,382 Capital Outlay - - - 8% n/a 100 100 - Total Emergency Services 9,073 8,152 921 108,972 108,972 - Special Services Personnel 32,165 35,794 (3,629) 8% 9% 385,983 385,983 - Materials & Services 4,573 2,451 2,122 8% 4% 54,876 54,876 - Capital Outlay 2,213 12,550 (10,337) 8% 47% >' 26,550 26,550 - Total Special Services 38,951 50,795 (11,844) 467,409 467,409 - Training If Personnel 8,729 8,557 172 8% 8% 104,747 104,747 - Materials & Services 2,135 196 1,939 8% 1% 25,614 25,614 - Capital Outlay - - - 8% 0% : ; 100 100 - Total Training 10,864 8,753 2,111 130,461 130,461 - Non -Departmental Materials & Services 2,178 2,178 - 8% 8% - 26,139 26,139 - Transfers Out 16,667 - 16,667 8% 0% 200,000 200,000 - Contingency 176,699 - 176,699 8% 0% 2,120,382 - 2,120,382 Total Non -Departmental 195,544 2,178 193,366 2,346,521 226,139 2,120,382 Total Requirements 1,802,408 1,405,064 397,344 21,629,267 19,508,885 2,120,382 NET(Resources- Requirements) 1,505,394 455,155 (1,050,239) - 2,025,605 2,025,605 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 Miscellaneous 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 One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance FY % I Coll. % Budget Projection Variance $ 908,900 $ 1,263,452 $ 354,552 100% 139% - 26,878 - 8% n/a 44,445 109,933 1,917 - (109,933) 8% 0% 2,649 8% (2,649) 8% 0% 11,060 195,000 (11,060) 8% 0% 450 10,400 (450) 8% 0% 15,858 182 (15,676) 8% 0% 30,833 5,638 (25,195) 8% 2% 867 6,400 5,533 8% 62% 5,423 - (5,423) 8% 0% - 66,016 - 8% n/a 3,943 799 (3,144) 8% 2% 11,292 2,397 (8,895) 8% 2% 2,083 4,095 2,012 8% 16% 5,500 3,910 (1,590) 8% 6% 1,000 2,548 1,548 8% 21% 971 554 (417) 8% 5% 5,501 750 (4,751) 8% 1% - - 8% n/a 207,363 27,273 (180,090) 8% 1% Transfers In -General Fund 183,215 183,215 - 8% 8% '' TOTAL RESOURCES 1,299,478 1,473,940 174,462 8% 26% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS 300,157 273,279 26,878 8% 106,016 61,571 44,445 8% 1,917 - 1,917 8% 12,500 - 12,500 8% 20,732 - 20,732 8% 441,322 334,850 106,472 8% NET (Resources - Requirements) 858,156 1,139,090 280,934 * Unappropriated Ending Fund Balance $ 908,900 $ 1,263,452 $ 354,552 - 15,000 15,000 1,319,200 1,319,200 - 31,790 31,790 - 132,721 132,721 - 5,400 5,400 - 190,300 195,000 4,700 370,000 425,000 55,000 10,400 10,400 - 65,075 65,075 - 47,320 68,000 20,680 135,500 133,000 (2,500) 25,000 27,000 2,000 66,000 82,000 16,000 12,000 12,000 - 11,650 11,650 - 66,016 66,016 - 2,488,372 2,599,252 110,880 2,198,585 2,198,585 - 5,595,857 6,061,289 465,432 8% 3,601,880 3,601,880 - 5% 1,272,189 1,272,189 OW:23,000 23,000 0%,150,000 150,000 - n/a 248,788 - 248,788 6% 5,295,857 5,047,069 248,788 300,000 1,014,220 714,220 RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees State Grants State Miscellaneous 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 Transfers In -General Fund Transfers In -Other TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) MENTAL HEALTH Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date i Year End Budget Actual I Variance FY % I Coll. % I udget I Projection I Variance $2,690,341 $ 2,658,399 $ (31,942) 100% 99% $2,690,341 $2,658,399 $ (31,942) 458 940 482 12,658 11,100 (1,558) 682,195 698,122 15,927 26,542 14,047 (12,495) 20,685 1,274 (19,411) 7,167 9,117 1,950 2,500 - (2,500) 5,833 - (5,833) 600 - (600) 4,958 - (4,958) 15,798 40,439 24,641 778 781 3 4,167 6,733 2,566 1,375 - (1,375) - 50 50 5,596 9,339 (5,596) 230,407 230,407 - 50,000 - 8% 0% ` t 1,021,717 1,013,010 (8,707) 101,252 101,252 - 42,619 40,870 (1,749) 67,157 - 8% 8% 3,855,929 3,813,531 (42,398) 524,116 479,827 44,289 655,658 546,737 108,921 417 - 417 12,500 - 12,500 197,095 - 197,095 1,389,786 1,026,564 363,222 2,466,143 2,786,967 320,824 8% 170/c ; 5,500 5,500 - 8% �a 7% : 151,900 151,900 - 8% 9% 8,186,344 8,186,344 - 8% 4%. (3) 318,500 318,500 - 8% 1 % O 248,219 248,219 - 8% 11 % 86,000 86,000 - 8% 0% (cj 30,000 30,000 - 8% 0%2� � 70,000 70,000 - 8% s 0% 7,200 7,200 - 8% 0%O a"'! 59,500 59,500 - 8% 21% °(} 189,579 189,579 - 8% % 8%,,,,,"" 9,339 9,339 - 8% 13% :f) 50,000 50,000 - 8% 0% ` t 16,500 16,500 - 8% n/a .r, - 50 50 8% 0% `(g) 67,157 67,157 - 8% 8% 2,764,887 2,764,887 - 8% 8% .._ ;', 12,260,625 12,260,675 50 8% 8% ,;'� 1,215,022 1,215,022 - 8% 8% 511,430 511,430 - 8% 23% ° -; 16,677,418 16,645,526 (31,892) 8% 8% (h); 6,289,388 6,289,388 - 8% 7% (i) 7,867,894 7,867,894 - 8% 0% 5,000 5,000 - 8% 0% 150,000 150,000 - 8% n/a 2,365,136 - 2,365,136 8% 6% 16,677,418 14,312,282 2,365,136 - 2,333,244 2,333,244 COMMUNITY DEVELOPMENT Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End RESOURCES: Budget Actual Variance FY % Coll. % Budget Projection Variance Beg. Net Working Capital $ 1,466,053 $ 1,592,012 125,959 100% n/a $1,466,053 $1,592,012 125,959 Revenues Admin -Operations 6,829 11,527 4,698 8% 14%,,81,950 81,950 - Admin -GIS 708 324 (384) 8% 4% 8,500 8,500 - Admin -Code Enforcement 29,413 30,148 735 8% 9% 352,950 352,950 - Building Safety 183,705 223,629 39,924 8% 10% 2,204,465 2,204,465 - Electrical 48,867 52,564 3,697 8% 9% 586,400 586,400 - Contract Services 81,250 107,824 26,574 8% 11% Lz 975,000 975,000 - Env Health -On Site Prog 66,137 69,615 3,478 8% 9% 793,643 793,643 - Env Health-Lic Facilities 37,074 21,294 (15,780) 8% 5% i444,890 444,890 - Env Health -Grant 29,167 369,310 340,143 8% 106% a)� 350,000 369,310 19,310 Env Health - Drinking H2O 3,723 140 (3,583) 8% 0% E 44,675 44,675 - EPA Grant 13,833 -833 13 , ( ) 0 /0 ° /o 0 } 166,000 166,000 - Planning -Current 89,246 72,885 (16,361) 8% 7%3, ;= 1,070,950 1,070,950 - Planning -Long Range 39,583 38,595 (988) 8% 8% 475,000 475,000 - Total -Revenues 629,535 997,855 368,320 8% 13%, 101 7,554,423 7,573,733 19,310 Trans In -CDD Reserve - - - 8% 0%, 100 - (100) Trans In -CDD Bldg/Elec - - - 8% 00/( 200 - (200) TOTAL RESOURCES 2,095,588 2,589,867 494,279 8% 29% - 9,020,776 9,165,745 144,969 REQUIREMENTS: Exp. EXPENDITURES & TRANSFERS Admin -Operations Division 269,242 148,435 120,807 8% 5% 3,230,900 3,230,900 - Admin -GIS Division 14,627 13,287 1,340 8% 8w''175,518 175,518 - Admin -Code Enforcement 17,388 11,291 6,097 8% 5% 208,657 208,657 - Building Safety Division 69,658 68,616 1,042 8% 8% . 835,893 835,893 - Electrical Division 31,361 29,105 2,256 8% 8%' 376,329 376,329 - Contract Services 50,885 48,913 1,972 8% 8%,,:'610,615 610,615 - Env Health -On Site Pgm 30,369 27,667 2,702 8% 8% 364,429 364,429 - Env Health-Lic Facilities 32,473 30,394 2,079 8% 8% 389,670 389,670 - Env Health -Grant Division 29,204 38 29,166 8% 0%' 350,450 350,450 - Env Health - Drinking H2O 3,827 3,620 207 8% 8% ` 45,928 45,928 - EPA Grant 13,566 4,925 8,641 0% 3% 162,786 162,786 - Planning -Current Division 77,311 64,762 12,549 8% 7%: 927,726 927,726 - Planning -Long Range Div 36,715 26,618 10,097 8% 6% 440,579 440,579 - Contingency 75,108 - 75,108 0% 0% 901,296 - 901,296 TOTAL REQUIREMENTS 676,626 477,671 198,955 8% 5%!' 9,020,776 8,119,480 901,296 NET (Resources - Requirements) 1,418,962 2,112,196 693,234 - 1,046,265 1,046,265 a) The grant, which was higher than expected, was received as a lump sum payment in July. RESOURCES: Beg. Net Working Capital Revenues Federal Mineral Leases Forest Receipts Motor Vehicle Revenue City of Bend City of Redmond Miscellaneous Road Vacations Interest on Investments Donations Interfund Contract Equipment Repairs Vehicle Repairs LID Construction Vegetation Management Sale of Eqp & Material Sale of Public Lands Total Revenues Trans In -Road Imp Res TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency ROAD Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance FY % Coll. % Budget Projection Variance $5,078,915 $ 5,667,033 $ 588,118 100% 112% $ 5,078,915 $ 5,667,033 $ 588,118 167 - (167) 8% 0%) t 2,000 2,000 - 249,750 - (249,750) 8% 0% a) 21997,000 2,997,000 - 625,000 643,274 18,274 8% 9% 7,500,000 7,500,000 - 6,667 - (6,667) 8% 0%,t]) ; 80,000 80,000 - 23,333 - (23,333) 8% 0% ,) ', 280,000 280,000 - 3,333 4,916 1,583 8% 12% 40,000 40,000 - 167 500 333 8% 25% `` 2,000 2,000 - 6,667 14,575 7,908 8% 18% 80,000 80,000 - 200 - (200) 8% 0% :' v 2,400 2,400 - 74,167 - (74,167) 8% 00/c 890,000 890,000 - 16,667 - (16,667) 8% t 0%',c)i 200,000 200,000 - 5,833 - (5,833) 8% 0% -d� = 70,000 70,000 - 8,333 - (8,333) 8% 0% ,e) 100,000 100,000 - 13,333 - (13,333) 8% 0% 1'14 160,000 160,000 - 20,833 - (20,833) 8% 0% 250,000 250,000 - 42 - (42) 8% 0% 500 500 - 1,054,325 663,265 (391,060) 8% 5% , Z 12,653,900 12,653,900 - 290,000 (290,000) 8% 0% '= 329,000 329,000 - 6,423,240 6,330,298 (92,942) 8% 36% .; `' ;f 18,061,815 18,649,933 588,118 419,221 455,923 (36,702) 8% 555,676 161,239 394,437 8% 381,542 - 381,542 8% 75,000 75,000 8% 73,713 - 73.713 8% TOTAL REQUIREMENTS 1,505,152 617,162 887,990 8% NET (Resources - Requirements) 4,918,088 5,713,136 795,048 9% 5,030,654 5,030,654 - 2% 6,668,111 6,668,111 - 0% 4,578,500 4,578,500 - 0% 900,000 900,000 - n/a 884,550 - 884,550 3% 18,061,815 17,177,265 884,550 - 1,472,668 1,472,668 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 Sex Offender Treatment Fees Day.Reporting Fees Interest on Investments Leases Rentals Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS ADULT PAROLE & PROBATION Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance FY % Coll. % Budget Projection Variance $ 200,000 $ 328,812 $ 128,812 100% 164% $ 200,000 $ 328,812 $ 128,812 184,908 833 2,417 63 467 8,750 17,583 67 42 917 1,500 108 217,655 1,160 15 185 5,550 14,410 588 12 787 2,000 150 (184,908) (833) (1,257) (48) (282) (3,200) (3,173) 521 (30) (130) 500 42 24,857 (192,798) 8% 0% a? 2,218,896 2,218,896 8% 0% :?F 10,000 10,000 8% 4% 29,000 29,000 8% 2%'� 750 750 8% 3%5,600 5,600 8% 5% 105,000 105,000 8% 7% g 211,000 211,000 8% 74% 3;µ 800 800 8% 2% 500 500 8% 7%' , 11,000 11,000 8% 11% 18,000 18,000 8% 12% 1,300 1,300 8% 1% 2,611,846 2,611,846 - 8% n/a 417,655 353,669 (63,986) 8% 13% 176,497 170,457 6,040 8% 47,964 29,974 17,990 8% 8 8 8% 9,851 - 9,851 8% 234,320 200,431 33,889 8% NET (Resources - Requirements) 183,335 153,238 (30,097) a) Payments received quarterly. 1 st quarter payment received in August. 2,811,846 2,940,658 128,812 7% ;' 2,811,846 2,693,629 118,217 247,029 247,029 RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Child Care Block Grant Level 7 Services Juvenile Crime Prevention State Prevention Funds HealthyStart /R -S -G OCCF Grant Sale Map Photo or Copies Miscellaneous Interest on Investments Grants -Private Total Revenues Comm. on Children & Families Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance j FY % I Coll. % Budget Projection Variance $ 560,870 $ 588,776 $ 27,906 100% 105% 6, $ 560,870 $ 588,776 $ 27,906 7,343 (7,343) 8% 0% 88,110 88,110 2,583 (2,583) 8% 0% 31,000 31,000 16,667 (16,667) 8% 0% 200,000 200,000 4,449 (4,449) 8% 0% 53,393 53,393 14,628 (14,628) 8% 0% ;++ 175,531 175,531 26,111 (26,111) 8% 00/ 313,333 313,333 15,625' (15,625) 8% 0%"'r� 187,500 187,500 23,290 (23,290) 8% 0% 279,481 279,481 25,056 (25,056) 8% 0% 300,671 300,671 167 (167) 8% s :e n/a 2,000 2,000 917 (917) 8% 0% 11,000 11,000 833 1,966 1,133 8% 20% 10,000 10,000 1,083 (1,083) 8% ' 0% 13,000 13,000 138,752 1,966 (136,786) 1,665,019 1,665,019 Trans from General Fund 34,983 (34,983) 8% Trans from Other 13,492 (13,492) 8% Total Transfers In 48,475 - (48,475) 8% TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency 748,097 590,742 (157,355) 8% 37,425 30,922 6,503 8% 157,322 11,811 145,511 8% 417 - 417 8% 38,802 - 38,802 8% TOTAL REQUIREMENTS 233,966 42,733 191,233 8% NET (Resources - Requirements) 514,131 548,009 33,878 0% 419,800 419,800 - 0% a 161,900 161,900 - 0% 581,700 581,700 - 21% ;' 2,807,589 2,835,495 27,906 Exp 7%1. 449,100 449,100 - 1% , 1,887,860 1,887,860 - 0% 5,000 5,000 - n/a 465,629 - 465,629 2% 2,807,589 2,341,960 465,629 - 493,535 493,535 SOLID WASTE Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance I FY % Coll. % Budget Projection Variance RESOURCES: 115,038 4,929 308,421 36,893 271,528 376,672 Beg. Net Working Capital $1,378,010 $ 1,541,321 $ 163,311 100% Revenues - 46,057 0%. 192,000 192,000 - State Grant 1,667 2,400,000 - (1,667) 8% Miscellaneous 2,000 3,095 1,095 8% Franchise 3% Fees 12,917 (12,917) 8% Commercial Disp. Fees 83,333 89,248 5,915 8% Private Disposal Fees 150,000 204,344 54,344 8% Franchise Disposal Fees 345,833 375,185 29,352 8% Yard Debris 4,167 9,313 5,146 8% Special Waste 2,500 2,910 410 8% Interest 3,333 4,969 1,636 8% Sale of Equip & Material 1,250 4,536 3,286 8% Total Revenues 607,000 693,600 86,600 8% TOTAL RESOURCES REQUIREMENTS Expenditures Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency 112% 0% 13% 0% 9% 11% 9% 19% 10% 12% 30% 10% $1,378,010 $ 1,541,321 $ 163,311 20,000 24,000 155,000 1,000,000 1,800,000 4,150, 000 50,000 30,000 40,000 15,000 7,284,000 20,000 24,000 155,000 1,000,000 1,800,000 4,150, 000 50,000 30,000 40,000 15,000 7,284,000 1,985,010 2,234,921 249,911 8% 26% „ 8,662,010 8,825,321 163,311 119,967 115,038 4,929 308,421 36,893 271,528 376,672 - 376,672 16,000 - 16,000 200,000 - 200,000 46,057 - 46,057 8% 8% 8% 8% 8% 8% TOTAL REQUIREMENTS 1,067,117 151,931 915,186 8% NET (Resources - Requirements) 917,893 2,082,990 1,165,097 8% '- ' 1,439,603 1,439,603 - 1% 3,701,051 3,701,051 - 0%-.' 376,672 376,672 - 0%. 192,000 192,000 - 0% 2,400,000 2,400,000 - n/a 552,684 - 552,684 2% ; : 8,662,010 8,109,326 552,684 - 715,995 715,995 RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges P/T Emp - Addl Prem Employee Prem Contribution COIC Retiree / COBRA Co -Pay Interest Miscellaneous Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid-Medical/Rx Claims Paid-DentalNision Insurance Expense State Assessments Administrators West PPO Fee Printing Program Expense/Supplies Other Total Materials & Services Capital Outlay Contingency TOTAL REQUIREMENTS Health Benefits Trust Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance $ 4,400,000 $4,586,247 $ 186,247 100% 104%.:'..,:$4,400,000 175,501 $4,586,247 $ 186,247 735,833 753,206 17,373 8% 9% : 8,830,000 8,830,000 - 15,000 13,332 (1,668) 8% 7% . 180,000 180,000 - 27,500 25,795 (1,705) 8% 8%-' 932 330,000 330,000 - 50,083 48,104 (1,979) 8% 8%-" 0% .' 601,000 601,000 - 31,833 35,656 3,823 8% 9% - 382,000 382,000 6,250 10,758 4,508 8% 14% 75,000 75,000 - - 8% - 8% n/a 100 8% 0% 866,499 886,851 20,352 8% 9% .x 3 10,398,000 10,398,000 - 5,266,499 5,473,098 206,599 92% 37% 14,798,000 14,984,247 186,247 10,134 9,898 236 8% 8% 250 - 250 686,142 510,641 175,501 113,858 104,988 8,870 29,167 25,961 3,206 2,917 36,032 (33,115) 14,167 14,252 (85) 2,667 2,480 187 1,000 - 1,000 917 - 917 1,205 932 273 852,290 695,286 157,004 370,736 - 370,736 1,233,160 705,184 527,976 NET (Resources - Requirements) 4,033,339 4,767,914 734,575 121,604 121,604 - 8% 0% , 3,000 3,000 - 8% 6% .3 a) 8,233,706 5,412,801 2,820,905 8% 8%;` 1,366,294 1,112,870 253,424 8% 7% 350,000 350,000 - 8% 103% 35,000 35,000 - 8% 8% 170,000 170,000 - 8% 8% 32,000 32,000 - 8% 0% .' 12,000 12,000 - 8% 0% 11,000 11,000 - 8% 6%'- 14,459 14,459 - 8% 7% 10,227,459 7,153,131 3,074,328 8% 0% 100 - 100 8% 0% 4,448,837 - 4,448,837 8% 5%- 14,798,000 7,274,735 7,523,265 - 7,709,512 7,709,512 a) Year End Projection: 5 weeks of claims annualized equals $5,412,801 for Medical/Rx and $1,112,870 for DentalNision. DESCHUTES COUNTY 911 Statement of Financial Operating Data One Month Ended July 31, 2005 Year to Date Year End Budget Actual I Variance I % of FY I % Coll. Budget Projection Variance RESOURCES: 210,418 26,371 49,822 36,094 13,728 Beg. Net Working Capital $1,600,000 $1,742,694 $ 142,694 Revenues - 122,897 5,000 5,000 - Property Taxes - Current 256,325 - (256,325) Property Taxes - Prior 5,150 10,267 5,117 State Reimbursement 667 (667) Telephone User Tax 50,000. - (50,000) Data Network Reimb. 1,917 (1,917) Jefferson County 3,417 156 (3,261) User Fee 1,925 (1,925) Miscellaneous 417 200 (217) Interest 1,083 3,767 2,684 Interest on Unsegregated Tax 67 14 (53) Total Revenues 320,968. 14,404 (306,564) TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency 100% 109% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 1,920,968 1,757,098 (163,870) 8% 236,789 210,418 26,371 49,822 36,094 13,728 33,958 2,000 31,958 10,833 - 10,833 122,897 - 122,897 TOTAL REQUIREMENTS 454,299 248,512 205,787 NET (Resources - Requirements) 1,466,669 1,508,586 41,917 a) 1st qtr State 9-1-1- telephone tax payment occurs in Oct b) Billing for data network reiumbursement occurs in Oct c) User fee billed - waiting on payment 0% 17% 0% 0% 0% 0% 0% 4% 29% 2% 0% 32% $1,600,000 $1,742,694 $ 142,694 3,075,900 3,075,900 61,800 61,800 8,000 8,000 - 600,000 600,000 - 23,000 23,000 - 41,000 41,000 - 23,100 23,100 - 5,000 5,000 - 13,000 13,000 - 800 800 - 3,851,600 . 3,851,600 5,451,600 5,594,294 142,694 8% 7% 2,841,471 2,841,471 - 8% 6% . 597,866 597,866 - 8% 0% 407,500 407,500 - 8% 0% 130,000 130,000 - 8% n/a 1,474,763 - 1,474 763 8% 5%:5,451,600 3,976,837 1,474,763 - 1,617,457 1,617,457 O O N I L,21 0 0 O O O_ (A u7 O 1 0 O O M v Lo O C1 o V IOI(ni O ' 0 O O O O h N M r ' O O d' ? b to c (n co p V' C N 10 C N I N O I R v tV cn �0 O O N ca O Ohf t q M N N O l L. 0 I 0 0 0 0 0 cn O N O O O (p -O p+ y) L') N N (o O cn O N 0 O O 0 0 O V O O 0 h N N N OIm 11ry O'O v M< V R O O O O M O h p 7 C) - (n < N M N N In O (n o) (n 0 (� r u) M N V N N I (p N M a0 O O M M O V cn cn M to Q h O (p R V h tCD h V O V O O 0 O O O LL LL @ I 0 O co c COD O COO O V 0 W O O Q O N O O O O O O O O O O N c0 O O- N O cn O c0 O O O O P w N p O N 0 0 O O 0 O 0 O 0 0 O O 0 V 0 O 0 0< O (O r M r N o) O co 0 0 N O O O N M O 7 O O 0 0 O M 0 O 0 0 M M I c4 0 M 0 7 �'- N cn V M O (o N O h In O O M O V cn N c0 O O m O N (Mn (n (� cohN N O N h'T h h '�r h N N V' h '7 O O 0 O h �vl N N h M N M N r O 0 0 0 0 OO N N O N N M No O O h W O O ' O O O O O O h h 0 V N N N O O O N h C O O c Cl) c O 0 tt7 h 0 O N N M M to V N N V w O co N N c O c N c N N N O 0 N Cl) M CD co O N M N h 0 !b et r < N O O O O O O N h app N M 0 0 O 00 T O ' O O O O O h P N N M O h M f- co N O 0 c (c V M N of Lo O O to'7 h N h 0 tp V' N c0 N t- O N tq tIJ h N N r O O N C) V O r r O O — ,a C) h 0 0 0 c 0 0 0 0 N O o h R c) N r N a W u N M Q N 0 O N h N m V N w N N N I-- N r to co N r L O O O O N N O 0 V N co O OO tD O O O V N N h M O M O O M 0 M co N (h', pOj ICI 'V N t0 O N O cn to h O co R M O (o N h h co O O O O O to N O CD a N N O m ` O O O O O O NM O h N h "t ('M 0 c h < V N N N M N m N cn O L N V r O VN w cD N N Cl)N tf t0 O (O N t0 tv LL O O 0 0O ccD O OD V N N O O O N 7 O O O N O O O N N h V M 0 h h .- V N N 7 N O M N O O M h 0) M Cl) V �- O t N to W N O N M Ap to (o co N r to r N a N O O O O N (n O 0 V N N O N O CO 'R M E O O O c O O an V N h R co 0 P h r V' N N N h M N 0 V O O IT O h lc a) 0 M O N co C) v) to coN N < OMi r V (Nn O C) O O O O O N 117 O 0 7 0 N N O in N f� 2] O O O Lo 0 C 0 0 N C N h V m 0'T CD r d' N O N 0 v N t0 M N O cl7 O O co tC () co o) h M (o N V NM N N N (p c0' >O N M r co O M N In N h z OO O O O N N O 0 7 0 N N C) O N L O O N O O O O N O O h N h V c) O N h .- v N O N O? N O M L' M N cb M U N N N N d' N0 7 < N N cn Q R N co O to M r h er N O 0 00 0 N O 0 R O N N O O O O O O 0 0 0 N h 0 h C O N N M O O M O E O Oa O M co r N 0 a} (O 0 O Cl) tti N N M r cn V' M <f N O h N N -, -T a N M to (o (O N< OO h N N coN o N 0 0 0 N N N 0 N O O O O O 0 0 0 N t- r h V N M M co Qa O O 0 O O 0 N v M O M �- N tD (17 N N N p (D (NO N p. O <t u) t0 - -til r O a0' O c) a"D- O O c0 c):, . oD (D V"- N h •. r- lh:O 3 4 r A p,r b,. N . N=. V ASD O. V" M �• h 'N . ;ro N O Q r N r N+ O O O�. CD- In N h N • , : tD 1" (tD Il). t- - t0 h M� < , CD 7 ,N U Q O (n cn OO O O O O 0 R N h O O O O cD T R O O cn N 0 O O O O 0 O r h o (D O N •- N N V O O M N h N 75 N 1-7 N 00 CD O V M -T o) N O O tD 01 N r h N N N cD h M N CD M � to C d C O o7 N Io n p c E Nrn c > �I N G) a) > W cu3 U N c V w L) a W I C p j U � O O I > OI C) V C Z N w> L 4) 7 N LL to to N LL U C 7 i x a W 'O @ v d LL N 0 7 7 O Otj C A 7 U >, > o m °' a) a) c o o (D g o U O a� w a U c m y U L a z c m— LL LL t o U LL d U c C tU � 0I L., 17) LL- tT LL- t71 LL N CI N O C a 7 m N 0 w C C f0 C@ N Q Q f0 A O lo U C N (n C1 y (n (`l w N 7 Y o d 0 C O C `,y @ (C c6 Y U "O C U O C O c (C (D C r > QI O O in O io N o 2 C) m F d N N@ (C F•- d L O tT N L DI o C N Q Q 4. W' Z F W O U w f-,io aIU > Ola : U Z m C7 O H Z RESOURCES: Beg. Net Working Capital Receipts: Events Telephone Fees - Events Parking Fees Storage RV / Camping Horse Stall Rental Concession % - Food Vending Machines Interfund Contract Rights (Signage, etc.) Grants Miscellaneous Interest Total Receipts Transfer from General Fund Transfer from Park Fund Transfer from Annual County Fair Total Transfers TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) Deschutes County - Fair and Expo Center YTD -Budget Basis Statement of Financial Operating Data One Month Ended July 31, 2005 Budget I Actual I Variance IF % Coll. % Budget I Projection I Variance $ 125,000 $ 179,409 $ 54,409 100% 144% $ 125,000 $ 179,409 $ 54,409 8% 8% 8% 8% 316,205 496,149 179,944 8% 0%j' 300,000 300,000 0% 85,000 85,000 0%., 204,300 204,300 0% r 589,300 589,300 24%,2,027,767 2,207,711 64,178 59,068 5,110 8% 8%s:= 770,138 765,028 62,244 54,154 8,090 8% 7%; 746,926 746,926 125,000 171,040 46,040 8% 25%<'`r 672,212 718,252 46,040 20,000 22,565 2,565 8% 113% , 20,000 22,565 2,565 - 2,000 2,000 8% 2% 87,000 89,000 2,000 - - - 8% 0%,- 53,000 53,000 - - 1,215 1,215 8% 2%,,",- 50,000 51,215 1,215 - 80 80 8% n/a 50,000 50,080 80 40,000 80,000 40,000 8% 36%��' 225,000 265,000 40,000 - 8% 0% ; 1,400 1,400 - - - - 8% 0% 35,000 35,000 - 3,000 36,140 33,140 8% 52%. 70,000 103,140 33,140 2,530 2,530 - 8% 6% 40,355 40,355 - 375 160 (215) 8% 4% 4,500 4,285 (215) 300 1,010 710 8% 20%;4 5,000 5,710 710 191,205 316,740 125,535 8% 24%,"",1,313,467 1,439,002 125,535 8% 8% 8% 8% 316,205 496,149 179,944 8% 0%j' 300,000 300,000 0% 85,000 85,000 0%., 204,300 204,300 0% r 589,300 589,300 24%,2,027,767 2,207,711 64,178 59,068 5,110 8% 8%s:= 770,138 765,028 62,244 54,154 8,090 8% 7%; 746,926 746,926 - - - 8% 0% 243,048 243,048 - - - 8% n/a 42,000 42,000 - - - 8% 0% 105,300 105,300 - - - 8% n/a 120,355 - 126,422 113,222 13,200 8% 189,783 382,926 193,143 Accrued Revenue (Accounts Receivable): Current Month Events 111,946 Prior Months 1,150 Total Accounts Receivable 113,096 179,944 5,110 0 120,355 6% r 2,027,767 1,902,302 125,465 Deposits Received for Future Events: 2005: August 6,390 September 1,860 October 4,159 November 8,400 December 1,460 2006: 15,905 2007 and Beyond 9,794 TOTAL 47,968 Deschutes County Fair and Expo Center Accounts Receivable July 31, 2005 Current Month - July 2005 Food & Beverage (estimate) 80,000.00 GNARR 31,000.00 Deschutes County Sheriff's Office 476.20 Cantastic 470.00 Total current month 111,946.20 Prior Months From June 2005 La Mesa RV 840.00 From March 2005 Owen Wedding 310.00 Total Accrued Revenue as of July 31, 2005 113,096.20 ` Deschutes County Fair and Expo Center Statement of Financial Operating Data July 2005 Transfer from General Fund - - 8% 0% Transfer from Annual County Fair - - - 8% 0% Total Transfers - - - 8% 0% TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 145,545 496,149 350,604 8% 25% Exp. 59,158 59,068 Year to Date 8% 8% 62,921 Budget Actual Variance FY % Coll. % RESOURCES: - 8% 0% 7,000 - Beg. Net Working Capital $ 125,000 $ 179,409 $ 54,409 100% 0% Receipts: 0% - - - 8% Events 8,440 171,040 162,600 8% 25% Telephone Fees - Events - 22,565 22,565 8% 113% Parking Fees - 2,000 2,000 8% 2% Storage - - - 8% 0% RV / Camping - 1,215 1,215 8% 2% Horse Stall Rental - 80 80 8% n/a Concession %- Food 8,900 80,000 71,100 8% 36% Vending Machines - - - 8% 0% Interfund Contract - - - 8% 0% Rights (Signage, etc.) 36,140 36,140 8% 35% Grants 2,530 2,530 - 8% 6% Miscellaneous 375 160 (215) 8% 4% Interest 300 1,010 710 8% 20% Total Receipts 20,545 316,740 296,195 8% 24% Transfer from General Fund - - 8% 0% Transfer from Annual County Fair - - - 8% 0% Total Transfers - - - 8% 0% TOTAL RESOURCES REQUIREMENTS: Expenditures: Personal Services Materials and Services Debt Service Capital Outlay Transfers Out Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) 145,545 496,149 350,604 8% 25% Exp. 59,158 59,068 90 8% 8% 62,921 54,154 8,767 8% 7% - - - 8% 0% 7,000 - 7,000 8% 0% - - - 8% 0% - - - 8% n/a 129,079 113,222 15,857 8% 6% 16,466 382,926 366,460