Loading...
CR 08-112 Proposed Water and Sanitary Sewer Utility and Refuse and Recycling Rate IncreasesDecember 16, 2008 PROPOSED WATER AND SANITARY SEWER UTILITY AND REFUSE AND RECYCLING RATE INCREASES Council Report 2008 -112 Proposed Action Staff recommends adoption of the following resolution: Move to adopt Resolution No. 2008 -067 which increases water, sanitary sewer and storm sewer utility and refuse and recycling rates effective for service provided in January 2009 and billed in February 2009. Adoption of this motion will result in increasing the water rate from $1.65 to $1.86 per 1,000 gallons, the sanitary sewer rate from $2.70 to $3.10 per 1,000 gallons of water used, the storm sewer rate by $0.50 a unit, or to $5.00 from $4.50, the refuse rates to $15.85 for a 30- gallon container, $18.55 fora 60- gallon container, $21.25 for a 90- gallon container, and the recycling rate from $3.25 to $3.50 per month effective for service provided in January 2009 and thereafter. Overview Water and Sewer Funds — In 2007 staff prepared a Utility Master Plan which sets forth operational, debt and capital requirements of the water, sanitary sewer and storm sewer sytems for the next 10 years. As a result of that plan we presented a schedule for rate adjustments over that same period of time that will allow us to meet the needs of the utility system while maintaining our utility infrastructure. These proposed rate increases are a result of the prior adoption of the Utility Master Plan. Refuse Fund — The present refuse and recycling rates have currently do not fully fund the operation of the refuse and recycling programs. Operating costs overall have increased from $655,000 in 2004 to an estimated $851,000 in 2009 primarily due to contractual obligations and fuel related costs. Currently the disposal fees are subsidizing the recycling program in addition to the yard waste /leaf, bulk and brush collection programs. Even with the proposed recycling rate increase we project a 2009 recycling program deficit. Primary Issues to Consider • How will the increased rates effect the residents and businesses in the City of Hopkins? • Why is the rate increase recommended? • What are the proposed capital improvement projects? Staff Recommendation To provide funding for the operation, debt and capital needs of the water, sewer and refuse funds finance recommends approval of the resolution. The change in rates would take effect January 1 2009. Supporting Information • Resolution No. 2008 -067 • Water, Sanitary Sewer, Storm Sewer and Refuse CIP Cash Flow analysis • Water, Sanitary Sewer and Storm Sewer Utility Master Plan 10 year cash flow analysis • Water, Sanitary Sewer and Storm Sewer Capital Requirements • Water and Sewer rates as compared to other municipalities Christine M. Harkess, CPA, CGFM Finance Director Financial Impact: $146,000 water, $228,000 sewer; $80 000 refuse Budgeted: Y/N X N Source: Water, Sewer, Refuuse Funds Related Documents (CIP, ERP, etc.): CIP and 2007 Utility Master Plan Notes: Additional Information Regarding Rate Increases Rate Increases and Effect on Residents Water — The rate adjustment will increase an average residential water bill approximately $1.50 per month and will maintain Hopkins' rank as in the bottom 1 /3rd of Metro cities. The rate increase proposed are important in allowing staff to make necessary improvements to the reliability of the water system. Sanitary Sewer — The rate adjustment will increase an average residential sanitary sewer bill by approximately $2.25 per month and also will maintain Hopkins' rank in the bottom 1 /3rd of Metro cities. The rate increase is a result of Met Council advising us that their annual increase will be in the 5- 7% range for the next 5 years and to provide for necessary improvemetns to the sanitary sewer system. Storm Sewer — The rate adjustment will increase a residental bill by a flat 500 per month. The impact on commercial properties varies depending on the size of their property. This is the last rate increase proposed in the 2007 Utility Master Plan for the near future and allows us to continue to improve storm drainiage systems throughout the city. Refuse & Recycling - Refuse rates were last increased in 2005. As a result of the 2009 budget process and an analysis of increasing operational costs of contractual arrangements and fuel related costs a refuse rate adjustement was proposed. The rate increase will afect a residential customer using a 60 gallon container, the most common size used, by $2.65 a month. The recycling rate adjustment will increase residential recycling bills by a flat 50¢ per month. There is not effect on businesses as the city does not service commercial customers. Why are the Rate Increases Recommended ? In 2007 staff developed a Utility Master Plan covering the next 10 years. Operations, debt service requirements, capital and infrastructure needs were all reviewed along with associated revenues. In order for us to meet the needs in the water, sanitary sewer and storm sewer funds scheduled rate increases are necessary. In the past rates were adusted every 3 -5 years and in the case of the sanitary sewer rates were actually decreased for a 6 year period. Rates unfortunately have not kept up with the needs of the water and sanitary sewer funds and staff recommends annual incremental increases to minimize the effect on users budgets. What are the proposed capital improvement projects? Water — Over the next 9 years we have scheduled $5,386,000 in capital infrastructure needs the largest of which is a $2 million water treatment plant upgrade and painting of the Moline Standpipe at $900,000 and the Blake Tower at $300,000. In addition annual water improvements done in conjunction with street improvements are budgeted and will total $1 million over the next 9 years. Sanitary Sewer — Over the next 9 years we have scheduled $1,349,000 in capital improvemnts with the largest project being rehab of the sewer lines totaling $1 million. Storm Sewer — Over the next 9 years we have scheduled $1,409,000 in capital improvements with the largest project being storm drainage work done in conjuction with street and utility reconstruction. The complete detail for all scheduled capital improvements can be found further in this report. With any scheduled capital improvement before deciding to move forward they are reanalyzed for feasibilty, financial availabilty and the capital schedule revised if necessary. Refuse Fund — The only capital item currently scheduled is replacement of the garbage truck which is on a 5 -year replacement plan. All equipment scheduled for replacement is re- evaluated before a final commitment is made for replacement. CITY OF HOPKINS HENNEPIN COUNTY, MINNESOTA RESOLUTION 2008 -067 WATER, SANITARY SEWER AND STORM SEWER UTILITY AND REFUSE AND RECYCLING RATE INCREASES WHEREAS, the City of Hopkins has established Ordinance No. 92 -712 Sewer and Water Utility rates, City Code section 715.03 which defines water rates and section 715.07 which defines sanitary sewer rates; Ordinance No. 89 -640, City Code section 720.05 which defines storm sewer drainage utility rates; and Ordinance No. 92 -707, City Code section 605.04 which defines refuse charges for collection services; and WHEREAS, the ordinances authorizes water, sanitary sewer and storm sewer utility and refuse and recycling rates to be set forth by council resolution; and WHEREAS, it is estimated the present water and sewer utility rates are not sufficient to cover operating expenses over the next five years and will not provide sufficient funding for capital improvement projects identified in the 2009 - 2013 Capital Improvement Plan and the 10 year Utility Master Plan completed in 2007; and WHEREAS, it is estimated the present storm sewer drainage rates are not sufficient to provide for capital improvements as defined in the 2009 -2013 Capital Improvement Plan and the 10 year Utility Master Plan completed in 2007: and WHEREAS, it is estimated the present refuse and recycling rates are not sufficient to cover current and future operating expenses for the refuse and recycling program; NOW, THEREFORE, be it hereby resolved that the City Council of the City of Hopkins hereby sets the service charge for the Water, Sanitary Sewer and Storm Sewer Utililities and Refuse and Recycling Programs at the following rates to be paid to the City upon billing therefore as follows: The water service usage charge for all classes of users on the system at $1.86 per 1,000 gallons of water used. The sanitary sewer service charge for all classes of users on the system at $3.10 per 1,000 gallons of water used. The refuse rates at $15.85 for a 30 gallon container, $18.55 for a 60 gallon container; and $21.25 for a 90 gallon container. The recycling service charge for all users on the system at $3.50 per month, per recycling unit. ATTEST: The storm sewer charges be set as follows: REF *Class Land Uses Rate 1 Single family & duplex residential 1/3 2 Multiple family residential 3 3 Commercial institutional uses 5 4 Public and private schools 1.25 5 Churches 3 6 Parks 025 7 Golf courses 025 8 Vacant improved and unimproved 0 9 Industrial 5 *as established by Ordinance code section 720.05 Terry Obermaier, City Clerk Charge Rate Per REF $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 Storm Water Drainage Rate /Month $5.00 /unit $45.00 /acre $75.00 /acre $18.75 /acre $45.00 /acre $3.75 /acre $3.75 /acre $0.00 /acre $75.00 /acre The monthly storm water drainage fee is determined by multiplying the storm water drainage rate by the parcel's acreage for all classes except single family and duplex residential (Class 1). Single family and duplex residential is determined by the storm water drainage unit rate for each Class 1 parcel regardless of acreage. EFFECTIVE DATE: The provisions of this resolution shall be effectiver for service provided in January 2009 and billed February 2009. Adopted by the City Council of the City of Hopkins, Minnesota, this 16th day of December 2008. Eugene J. Maxwell, Mayor 0 p O 000) ° N VI v co O y a` a rn o 0 0 �Nl 'o d°_00O O N N to) M O a r d 15 ;--1 CO N OA .0 N C r M A 0. r N ti O N a ` Yu . AO G N M O O o ti 0 o) (0 ( 0 0 M CI) 0 co W 0 0 0 ._..0 CV r N a N A 0 0 IO N N 0 r O o N N co co a `� y O O r N 0 co N r A N r O' 0 N 0 d' (0 col O CO 0 M 7 o Q N N O M N 3 0 d N c E o � d n c 0 c c t o N • a) C N N CO N 0 C C L 0 c ;O OSi -ro CO N 0 0 CO M 0 o 03 0 ° A CO. 0 co 4 IC co d N co 42 0 CO O O O O co co co, o co (o 0 V 0 O V 0 CV O co N N A a a. CO 0 o O co co 0 W O 0 0 0 0 0 0 0 C5 (0 a O 0 0 O O O O N fl A 10 0 0 0 0 0 0 M r V 0 0 0 0 0 O 09 C5 0 V V V N M M N. 0 O (0 O ((0 N N. M V N W M 0 ( r 0 (� 0 0 (O (0 ( N M CV V LO y O O N V 0 0 CO V A N V O o o 8n v M N a O r N N co 0 0) a N CO A O N N M a 'NO N0 O 'O C a.1 ro 3 g o 3 ^ c a � L`d N� Ind C t3 wd a)m9 N N U C N C a) a T T >> 0 C c O a a) a} ca... a o o y y a IL�7 00 a ( �o �axx' 10%E E °� ft_ 1 - a ww w —N-- a fO a — a )a 2 @N (0( a v C N 0 001 -0 00a w A CO 0 N < • t L C N E o S' W n a - Le t Ce co `m 15 2 0 0 C) c 0 A C OO co a O we O a) 0 co (( 80 69 C E N N (Ao co N O .NO. N E O N N t 0 -0 CJ 0. v �M M 691- N N n + N d. to y m 2 m 2 c7) Tr ao E o LO .1:75 w N6 N00 0 (0 (0 10 E N '1 N O a c C r N 0 r i k N . 0 N V v ... N O o O c N `aC O.O (` � E c n Tr C ai 15 CO P (CO N N C N C _ 2 U O N N O) —O N O) y T 9 _ O v @ N N N c E C O) O�w� M N N W N N° N w co r (v N N. (0t a N. CO a W 01 0 (3 O =N N O x cu A 0 0 c a w (6 N (0 I000‘cr ON (O r CO O Or N d'Z. (000) 0? 0) OO r r N 9»6)6)61 ' 69 69696,969 (1 69 K CO A O(() CO 0 0 r N CO d' LO CO A CO 0 0 0 0 1 - 0 0 0 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r N N a N N N N N N N N N N o 0 o N o O N O ON a co 0 0 CO 0 CO 0 0 CO 0 0 0 0 V ( N N 1 n '1 N 3` r O 0 N o SD 0 1 n dco N O N t0 N N N O d co N co V 0 r d O N CL N 0 01.001. 00(0000 00 0) 0 0 0) N O N N N CD le N (+i d CD 0 CD 1 0 0 0 0 0 of co (•i lri o O N 0 O a` r ( 000 00 goI O O O 0 0 ° r'O0 0l- O CO CO N c 0 0 N D r (Y CD CD 0 N (O n 0 0 0 ( v N 0 O N p N L°. N 1` n W n N r I (0 0 CO N U 0 V co 0 r O Q N Cl- 1... r CO N0) CO COI r W LO CO 00 CI O O O a a N N O N N • 0 0 U) N 0 0 0 0 0 CO 0 m O hNN O O 000N 10 1'- O (0 V CD C-• O O N V N O ` m N (O N r N O 0 V o 0 0 0 0 0 (0 ci t o I Q co O 000(0 t0 O N r N. N O 0 0 0 0) t 0 V 1. N N r ON OO o t0 N co N 1- a. I� O(0 N „A. O N r (V r N Q O ° OJ ( O 0 O CO CO 9 LO a) W N c O C N V O 1') CO N r co co co r N o a r 0 0 0 0 ° o co Q. ai co O ( N ( co ( O ( (V r of 1 n 0 ° 0 0 0(0 CO ° 0 O O O O O CO c0 ID CO ~ O r 0 CO N r N O) 0 0 O W m ( ° ( o o ( 1.. C N ( W O 0 W M CO O CO O 0) O N O A 10 W e h e-Y 0) 0 O CO 1') r CID n CO W N N 0 10 1 M r CO 10 0 N W O 0 O 0 ) O CO 0 0 10 0) ° ta O V N O 0 O (0 co C) n N 1 0 (0 ( W (0 N 0) (0 'a a .p -o C o 1 0 II- 0 .O > LL CO o 0 p G N > N. �' N µ ii, CO C y N a a C • > c U j E o f O .... E W 10 c c E E CD C ) N C_ O 0) -co c o � o 0 N a d El) a as x y C O 8 t. % O) CO Y co- O C C d w d' C m o yj W.c N D? 'a a a o o m o m p N cO x O c E E O dw NV01) - -o W H m 053£4 aa- 0 0 N 0) 0 O U O N C 0 O. V - c . _ a a r d E o a a $ 10 m ° 0 a(0 C C(0 0> OOSrm t xO2OEO2 OO a.0.Q co 0 so 4) C O o 0 0 oE O 0)10 O pt N a E x c C z O � m x � � J a 0 0 ° o NO o c E ° E ) a 9 > > N O O E EE o 0 p d d 00 0 i0 co 0 C 0 0) o N (0 0 0: 0 a)) 0O O 0 N c < W d r . CC c E a 3 U N a) w (0 0 0 � ry A 0 N o o 10 o o 0 o 0 0 0 0 0 0 N O N 1'0 010 N o /N r, V^ 0 CO OO N N r r NN = NC) CO Ma'Q'9 10 N = 4f 4) 4i4 69 yj - 949 to 4l 4i 4i(9 0 coOrM 0 co O) O rN(0V N (0 I. O W 0 0 0 0 0 0 r CC 0 0 0 0 0 N a N N N N N N N N N N 0 O 0 0 0 r CO e- O 0 o r - N 10 O o O r 0 N a 0 (0 0 0 0 0 O L-000 O N O U N O O I 6 O O r 0 N N 00 a V O N O U r N <000 0 0 N- O O O O N 00 a a . U 0 N - 0 1 1 0 N 0 0 1 O NI V O 0 N ir . O N O S Q. 7 r O N OI O M 0 0 0 Q N 0) N CO 0 V 0 0 NN LO CO r O N CO Or 0 O N N CO CO �o °o N 0 O M eY CO cD co M N 0) N 0 n o O 1 O N 1 CO 1100 r N 0 0i M (0 N 0 N CO 0 0 0 0 0 0 O 0 0 0 0 0 0 M O O O O O O O O 0 N O O O 10 O O O N N (O r r r 0 N v 0 0 0 0 0 CO r ' 0 0 0 o o CO O 0 O r 6 N O) e CO M r CO CO 0 0 0 0 00 0 N O) (O O 10 0 O to N 0 0 r r O N O r N r r t r r 0 0 0 0 0 0 0 0 0 0 0 0 0 O N M O O O 0000 M r n 0 0 N 0 0 N N N CO r r r r r N 7 0 03 0 0 0 0 0 CO 0 O O O O O o O r (OO 000 V V m N v O < O N 00 r N < N 0) m CO 0 0 0 0 0 0 0 0 r 0 CO 0 0 0 0 0 ( CO M 00 0 o O 1 0 N N r N r N o Lo N V N- 0) O 0 0 0 0 o O O O O N O 1n O 10 co O N O N 0 10 0 0 0 0 O r 0 0 0 O or 0000 0) 6 O N 10 10 r O 0) eY N 7 c - o W 0 0 m C E' C 0) c 3 0 0) 0 (0 0 0 .0 N 0) O j U a d E .TA .�. = ( � c �LL Z` d' . N . . dQ Q 'O N LL Z` 0) 0) N _o W c c V "0 'O c d - 0 ( v (0 c 0 0 0 c c c a 07 m m m N O N _ N (n � 0 0 W 0 U O x c' N O E o 10 a a o ct 0 ) 5� 0 ) r'. E Ec cc 0 b oi c 0) o x O Ec c a a co co a W Ny � �.5 d o _ d a 4) N L N c c c 0 0 0 L c c 'a a a 0 0 0 O' O a O S l` 0 0 a (� (6 ( - U U (6 0 0 0 N O h H m w O O h h U r N N U CC O O co CO W O O N (0 O O r 0 V' (O LO N rn 0 CO r CO ` N ° CO N V O (O N W 1M O r CO o 0) m M 0 0) ) M O v N N o m CO N CO W 0) r V w 0) M O 0 0 0) 10 N- O o O 0 O (AO a (0 O O O N c O ' 010 0 E;' E 0 m 0 2 O c O C a0 a o) E c E a 0 O 0) 1 0 0 O)E(q (0 0 316 a 0) w¢ '2 E (0 O 00 M M o N CI) O o O Z N N 0 r E J o" 0' 0 0) 0) a s 0 0 0 0 0 0 0 0 o N 0 (O ON O 00 (N Q (O (V (") 0) 9 7 1() e(A69(A 0 N CO CO O CO 0) 0 00 ( 0) 0) 0) 0) 0) 0) N 0 0 ( CO O a N � r 0) co. (A Iv co O N O 01 0 r r O N p o a r OC N V M co O C O r O O N v V co O N O a 0) 0)) 0 O 0 IS r r n (n oN- O N CO M N 0 CO CD a) 0 0 N U O er LO O N 0I CO O O (n 0) N O N CO a Qs O � 07 n co O O D C) in O O 0 (0 0 O r N C'/ N O O N 01 (y r N r CO CL CC CO 0 0 V $2 001 C 0 0 IN U 0 0 (D O co O N 0) co N r CL N n 7 0I U < N 0 0 ) N O 0 ) N N U) (O at m C CO CO N N CO r N fl 7 OI Q N N CO U O CO N cri N 0 0 0 0 CO 0 d 0 'l N N 10 If) to 0 16 W N N O CO O) r N 0)) 0 0 N CO O co W N O Cn OD O co co O O O) N co • 0) M _ 0) 01 N 0 N . N P CO 0 0 (0 o Oi 0 CO N 0) O O 0) O 0 A N N- N CO 0 O 0) N CO n 0 0 r N M W O r CO O 00 10 N CO N O V N N 0 O 0 EC a_ v m co CC Oly r c r (0 0) a CO p c 0) a 0)) — : a a N a' O in To I j 7 N a) N W O co C O N C Q OO J W U C L ) C a Q O. C N@ c Q m 00 C6 (0 0 c2. C7 0 0E - 000 W W 03 1() 0) 0) V O) 0 U) of ID r 10 V N C CO M 07 0) N CO O CO r. 0 03 N 0) N cf) 0) 0 r N 0) n U W O) O C C V O N N 01 r N a) 0) U c 0 (O V (D O 0 7 N 0) fl T CO 6 0) m N 0 CC 11 0 it CO it er CO 0 0 ° r ) 0 5 0) N (O 1- v CO CO 0)� N r co O) O 0) r 0) N 0) co = n d w 0) ` L N ® D ) N a) N w 0 r in �..- c 0 r 0 r O 4- (n d ' U w '- aN C O N 0 TNp C.N CC() V T) 0) N 0 -) a0 r 1() ) r U N 2r o CO ON t' - L L Qc N 9 Nffl�O (0 (0t ti00 r 0 n co N N CO Ge Cfl Cfl te (f j e, la �3 69- N 0)r- N u) C0 0 0) O , CO00) 0 0000 r li r r r N N O N N N N N 1 X m z 0 c 01 co 01 n m m c 0 1 — z m co mz v-i_ Z mvZ pm r o mm m0 z l i 1 X m z 0 c 01 co 01 n m m c 0 1 — z m co mz v-i_ Z mvZ pm r o mm m0 z !TOTAL EQUIPEMENT EXPENDITURES EQUIPMEI TOTAL CF [CAPITAL I Generator Billing System Radio System 1 314 Ton Truck Telephone System NT EXPENDITURES 1PITAL EXPENDITURES Regular LS Major Maint. Blake Road Sewer Imp. Rehab Sewer (10% of TV'd Areas) Rehab LS No. 4 EXPENDITURES [Eliminate LS No. 1 S01 $100,000 $100,000 2008 $01 $100,000 $100,000] 2009 [ $01 $335,000 l $35,000 $200,000 $100,000 2010 $6,600 009'9$ $100,000 $100,000I H 2011 [ $01 $5,000 $115,000 $15,000 100.000 2012 $5,000 $100,000 $100,000 2013 1 $35,700 $35,700 $120,000 $20,000, 1 $10Q000 2014 1 sot $100,000 $100,000 20151 $33,6001 $33,600 $125,000 $25,0001 I $100.000 2016 $26,4001 $26,400 $100,0001 I I $100,0001 2017 1 $59,700 $59,7001 $154,000 $154,0001 2018 D b Z O m mD O m <2 z mz � m m � m m z mz o mzN m zmD mN x m m z 0 c m CO 0 D 2 0 P C 330 m y � ymZ P 5 Z Z 0 -1m mm Zt> y mm v m z 0 C m OE 9E9 83'£2$ LE 3$ L9 6Z$ L8'LZ$ LZ'9Z$ 91'12$ 9£'6Z$ 89139 60'929 69'439 81'E3$ 49'LZ$ 96•93$ L4'43$ 90'839 4L'LZ$ 61103$ 1.8•939 L3'939 Z8'839 94'33$ 91'13$ 96'619 ZL'9Z$ 81'939 4L'£Z$ 82•339 60•1.3$ 88'619 48'939 92'43$ 96•339 49•139 04'OZ$ 23•61.9 69•939 31'43$ EL 339 E4'13$ 03'039 40'61$ 94'239 28'1.39 L9'0Z$ 62'61.$ 8Z'819 23' 06'Z39 69139 98'039 81.'619 80'819 PO L19 92•33$ 80'139 L8'619 £1'83 99•21.9 49'919 69'139 94'039 L3'63 LL'83 Z1 L3 41'919 49'139 3039 41'61$ 40'91$ 10219 20'919 L6'039 9L'63 29'819 99' 99'91$ 09'91.$ 98'61$ 1L'819 49'L1$ Z9'919 L9•91$ LL'41$ 06'93 1.821$ 6.919 38'91$ Z6'419 90'41$ 14819 L9 ' L1$ 99'93 19'91$ 11'419 L8 'E1$ 84'81$ Z4 L1$ 34'919 84'919 69'419 91'219 46' 16'91$ 46'919 20'919 91'41$ 92'219 8323 63'91.9 92'919 L4'419 49'219 98'319 8123 61•919 93'919 8E149 99'219 8(319 £1'94$ OZ 919 22171.$ $t&3 ` '.; 2.319 00'31$ 29'919 £L'419 68'23 Cs9 fl ;.142'319 29'419 29•919 £L'419 68'21$ 60'219 Z1$ $ 29'13 L1'919 02•41$ 84'219 1(33 196 149 S 63'119 L1'93 02143 94'21$ 1.. 319 96'13 631.19 19'43 89'219 06'319 91'33 9413 08'019 931714 88'£4$ 88'£1$ ' Yia 09'OIS 19'219 2831$ 01319 04'11$ 9(019 21'019 90'219 02319 69'119 26'04$ 02'01$ 1(69 0633 91•319 94'119 08'019 81'019 09'6$ L(1.1.$ 01'119 94'019 98'69 6Z'69 9(89 09'119 26'019 02'03 1(69 91'69 29'8$ 01'119 94'03 98•6$ 02'6$ 9(89 93'89 ZLOZ LLOZ 010Z 600Z BOOS 900Z suP!doH ;nq pe Jo; esee ou! °L !!!8 A14 ;uoyy spi8 Je ;eM aBeJeny jo lueb sllodeeuum e6ene9 e!uooep sly6!efi ejopum a)Ie Kind Pla9yo2! Ined punon Ipewo;yeW s4416!eH wooled Wed '19 ;saM sau!d 910. ulidweyo uo;6ulwool8 Ma!n spunow Jenopuy ue6e9 Resweb fallen eiddy >lied u fploa8 SAOJD e6egoo uo;6ulwJed e)Iuo ;auu!W Ted s!nol IS £E 32 12 02 6Z 8Z LZ 9Z 93 43 23 ZZ 13 OZ 61. 81. L1 91 91 41 £1. Z1 11 01 e)ISey7 6 s ;y6ie sleupen 9 swildoH: L eu!eJd uep3 9 e)Iej;saJod g uo ;y6ue MeN 4 y ;now/Id E LaIPud 3 GAOJ0 eidew 1 I(;!!ed!a!unI!I muea 1£'02$ L8•83$ E9'6Z$ 14'87$ 29'63$ 17'82$ E8 14'8Z$ L9•6Z$ 93'82$ 19'6Z$ LL an 92'63$ 96 61'6Z$ 0813$ 170 6Z$ 9922$ 88'93$ 0913$ ZLSZ$ 9213$ ZL 8Z$ 9213$ 3L93$ 9223$ ZL83S 9223$ 99'8Z$ OZ'LZ$ 99'83$ oz1Z$ 9CLZ$ 44 9Z$ bb2Z$ £• 93$ 3VLZ$ 29 ZL23$ 28'93$ 96 99•93$ 08'93 29'93$ 08'93$ 2593$ 91'93$ 3611Z$ 91 Z6173$ b8'9Z$ 19173$ 29'93$ i.etz$ 29•93$ 29•93$ 3E173$ L£'9Z$ 91'42$ L£'93$ 91173$ £1•93$ 68 4 tZ$ OL£3$ £1.'93$ 68143$ OL'EZ$ 29•93$ 14'43$ 93'83$ 29'93$ 14'43$ 9Z•EZ$ 29•97$ 1417Z$ 93 97'93$ 93173$ 60 94'93$ 9343$ 607Z$ 97 9Z 60'23$ 63 60 76•33$ EL 9Z$ 26'23$ 6273$ 811SII9L'LZ$ 09'93$ 39173$ 94'23$ EE'3Z$ 3913$ 9V'£Z$ 22•3$ 39173$ 9V23$ 22•3$ 6123$ 99'33$ 89 9b'EZ$ 22•33$ L3' LZ$ 19ZZ$ 49'12$ •9 8L'13$ 4L'03$ 9L'61$ 46'03$ 46'61$ 66'81$ 01'03$ 41'61$ 23'81.$ 6021$ L3'91$ 09'91$ Z10Z 11o3 0103 6002 su!HdoH inq Ile Jo; asealoul %9 28•1£$ 3£'1.£$ 3£' 1E$ 32'1.2$ 91' 1E$ 66•02$ 38•02$ 99•02$ 64'0£$ Z£'0£$ 91 91'02$ 91'02$ 86'63$ 91'63$ 18'93$ 84 83$ 84 83$ 12'83$ 41'83$ 71'83$ L4'LZ$ L42Z$ b12Z$ 08'93$ 08'93$ 08'93$ 29'93$ 29'93$ 64'L3* 9023$ 90'13$ 9023$ 16•93$ LL'9Z$ £9•93$ 87'93$ 4£•93$ 61'97$ 90'93$ 90'93$ 90'93$ 90•93$ 06•93$ 06'93$ 81'93$ 68'73$ 09'73$ 09'73$ 94'47$ 1E'1Z$ 12'73$ EL'£3$ EL£Z$ 91. 23$ 91'23$ 10'23$ 10'22$ L9•3S L9 ZZ$ b1'Z3$ 14'33$ 4172$ 66'13 66'12$ 66'12$ 98'LZ$ 1013$ LC 12$ LC 1Z$ LZ' •Z$ 99'03$ 93'03$ 29'61$ 18'81$ 60•81.$ 92'11.$ 9L'41$ 9!•93$ LC9Z$ LL'9Z$ LLSZ$ 29•93$ 09•93$ 92'93$ 33•93$ 80•93$ 46'43$ 18'73$ 18'43$ 18'43$ 18•bZ$ L9'4Z$ L9'P3$ 86'23$ OL£3$ Eb £3$ £4'£Z$ 63'23$ 91'23$ 91'83$ 09•33$ 09•37$ ££•ZZ$ 90•33$ 90•33$ 90'33$ 16'13$ 16'13$ 09'13$ 09' 13$ 60'12$ 60' L3 s60'y2$ i96 :OZ$ 96'03$ 96'OZ$ 18'03$ L9'0Z$ 93'03$ 93'03$ 93'03$ L9'61$ 63'61$ 09'81$ 3621$ £Z2 L$ P9'91$ 90'71$ 8003 9L £Z$ 82•23$ even wen 9Z'£Z$ v23$ 00'£3$ 88'33$ 9033$ 29•33$ 09'33$ 09'33$ 09•3$ 09'33$ 8£73$ 92'33$ 9(17$ 09'13 93'1-3 93' LZ$ £C 1Z$ 00'13$ 00'12$ 09'03$ 0503$ 93'03$ 00'03$ 00 00•03$ 88'61$ 89'61$ 09'61$ 09'61$ 21'61$ £1'61$ 61'61$ 00'61$ 00'61$ 00'61$ 98'91$ 9(814 4 4 8 1 $ °r .._k 82'81$ 82'81$ 92'81$ 9CL1$ 0921$ 88'91$ 93'91$ £9•91$ 00'91$ 9031$ 9002 II!8 LlgiuoW sing camas /Ue ;iues abereny ;o Auea may\ spunoyy lned'is Wog eulp3 ulidwey3 uesseyuey3 a!gnswng lungpooM Meld aidelni dlysumol eildw3 sly6laH amp .Jams1 eadoyeyg epeue3 awn lelsti0 seuld elalm Ted smog luleg eu!e!g Ilelpuel aNe Woo alepaapne1 AolleA elddy poome deyy a)le-I aeag al %UM sllodeauulyy snloeiluog linen lunowasoH uol6u!xaw oess° lodmaN elopuayy apinaxe1 s6ugseH uopas maN sly6laH wooled uol6ulwJed e oJe e6euoo lied Ined lule3 Aelpud s114610H elgwnloo Plellgol2i alepAin m>ido es oleuul4y an0J0 aldeyy NJed uAj ooi eplald uap3 sly6laH elopuaW uol6u!woolg apinasoa ue6e3 dolli!H a6eneS l(i!Ied!a!unyy Z9 LS 09 64 84 Lb 94 917 P4 £b Z4 1.4 0 LE 92 92 bE 22 Z£ 1.2 02 6Z 8Z 93 43 23 73 12 03 61. 81. t1 s1. 91. 41 £1 31. EG 0 1 6 8 L 9 9 £ Z >IUea 6Z' LOS 96'98$ 1878$ 98'81$ 1l'9L$ £ 1'89$ 82'43 28'03 9419$ 53179$ 61'1.9$ 09'99$ 99179$ 89'1 99'89$ 98'99$ 03 93'84$ 86'39$ 66'65$ 9129$ 14175$ 31.9$ 0074$ 09'29$ 90'19$ 39114$ 12'94$ 01'44$ 00'04$ 26'1.9$ 94'64$ 01'14$ 98174$ 3L74$ 9(82$ 93'09$ 9874$ 85'94$ 14'24$ 42 0972$ 1.6'84$ 89'941 L2174$ 93748 43'048 05'93 06'941 19'44$ 49741 39'041 382$ 00'92$ 06'941 L9174$ 49741 29'04$ 6972$ 00 EL'44$ 09741 19'041 49'83 09'92$ 823$ 33'44$ 31'34$ 1.1'04$ 03'9£$ 923$ 007£$ 993$ 84'14$ 09'62$ 3972$ 293$ OS'Z2$ 99 94 09'63 3972$ 293$ 0972$ 89'1.41 88'63 - 9622$ 81.'92$ 94'42$ 83'13 13'141 933$ 823$ 09'92$ 063$ 91'02$ 49'04$ 1.9'82$ 11'92$ 303$ 92'22$ 93'03 45'041 1.93$ LL'92$ 30'92$ 923$ 93'02$ 03 63'9£$ 14'9£$ 21172$ 80'2£$ 00'0£$ 362$ 1622$ 91.'92$ 44'43 08'32$ 91'63$ 362$ 9912$ 9852$ 91.13 3972$ 09'63 20'69$ 1122$ 04'92$ 313$ 1.1.'32$ £L 6Z$ OL 82$ 98'92$ 01'9£$ £4'29$ 28'1.2$ 99'93$ 61 '82$ 39£$ 17917£$ 6672$ 34'1£$ 09'83$ 3922$ 41 92$ 20143 1422$ 18'02* 00'83$ 69•92$ 46172$ 322$ 69'1.3 81. '02$ 92•13$ 81.'92$ 943$ 3972$ 9Z'Let LL'6Z$ 00'17$ 89'96$ 86'£2$ 92 39'02$ 92'63$ 29'93 893$ 86'92$ 9272$ 38'03 92'63 29'93$ 1.93$ 383$ 1.3'32$ 89'0£$ 33'63$ 09'93$ 1.93$ 3872$ 1.3 89 33'63$ 09'93$ 923$ 9972$ 9072$ 29'02$ 80'63$ 92'93$ 91.3$ 052£$ 1.6'1.2$ 62 46'83$ 93'93$ 81.3$ 09'22$ 1.6'1.2$ 62'02$ 46'83 93'93$ 1.0'92$ 427£$ 91'1.2$ 43'0£$ 08'83$ 91'93$ 19 303$ 94'1.2$ 96'63 29'83$ 99'933 9972$ 00'1£$ 363$ 1.1'8Z$ 09'93$ 0017£$ 62 32$ 48'02$ L£'6Z$ 86'LZ$ 9£3$ 004£$ 6272$ 48'023 12•63$ 8623$ 82'93$ 19'22$ 1032$ 179 60'63$ OL'LZ$ 21'93$ 093$ 1.6'1,3 62'02$ 46'83$ 99736 00'93 0972$ 16'16$ 62'03 46113$ 9523$ 00'93 09'EES 1.6'1.2$ 62'0£$ 46•83$ 99•13$ 00•93$ L1. 'EE$ 69'1.£$ 80•02$ 99'83$ 6377$ 91173$ 11.'2E$ 69'1.2$ 803$ 99'83$ 6313 91'43 98'32$ 313 81'63$ 92733 1.0'133 0917Z$ 283$ L3'1.2$ 8163$ 383$ 1.023 0543 097£$ 96'0£$ 84'63$ 10'83 11'93$ 93'43$ 91.72$ 29'0£$ 11'63$ 8L'LZ$ 94'93$ 00'13$ 91.'323 29'02$ 11.'63 8L73$ 94'93$ 001733 66'1.2$ L4'O£$ 30•63$ 19•133 32•93$ 88 3103 11.03 01.03 6002 9003 900Z sundoH 1nq He .wJ eseenu! %9 1118 )!gluon sum Jamas Aievues a6eJany ;o *uea eouapuedepui £O1, Plauuaale 301. ouolo 1.0 Aeg emuol 001. e!uoaeM 66 a !el 48e10d 96 e;sulauu!W L6 awl 6uoi g6 poomeJogg 96 10Ed 'IS 1 .11-1oN 176 punoW £6 d!gsumol eAe1 ;scrod 36 poomueaJ0 1.6 uanegdaaa 06 >I�ed 6uudg 68 sll!H u3PJV 88 (eswey 18 !Pawolgeyy 98 poomgQJ!9 98 1alu93 ui(poag 48 edoH maN £8 eu!pew 38 Jo!slaox3 1.8 sale ou!1 O8 1 al?M1114S 61 eNe1Jopd 91 euo ;o!n LL Ined lu!eS 91 e)!ouy 91 O60H 41 emmelua0 £1 Ted e)lel 6uudS 31 elehzeM 1.1 me!naJoug 01 d!gsumol m eg el14M 69 Janopuy 99 6apeA uaplo0 a9 eiepsungo il 99 eIepNEO 99 S>IEOIIPON 49 slg61aH s!eupen 29 sl1161eH )(Jed AEO Z9 d!gsumol umo ;aNel 1.9 eyyd!gsumolJelemll!lS 09 Aogluy lu!nS 69 Ined'48 %SMM 99 sp!dea u0o3 19 yodAe9 99 e!well!M 99 4Oe09 emuolauu!yy 49 1 1100w/Id 29 Amed!O!unyy >fued [Surplus over minimum carryover Min. Cash Balance @ 20% of Operating Costs 'Ending Cash Balance Ilnventory Change Change in Available Funds [Adjustment for Depreciation 1123 !CAPITAL EXPENSES SUBTOTAL NON - OPERATING INCOME (LOSS). INOP 1NET SUBTOTAL OPERATING EXPENDITURES ' Depreciation Total - Taxes and Insurance Total - Contracted Services (Total - Utilities Total - Materials, Supplies and Services Total Salaries and Employee Benefits 1 IEXPENDITURES H (SUBTOTAL REVENUE Miscellaneous Llnterest Earned (5.5% on ending balance) (Antenna Lease [Permits 1 Penalties Charges for Services 1 Beginning Cash Balance REVENUE [Average Large Commercial Bill (50,000 gallons) Average Small Commercial 801 (20,000 gallons) 1 [Heavy Watering Residential Bill (15,000 gallons) Average Residential Bill (7,500 gallons) !Revenue - Per Gallon Charge Rate per 1,000 gallons - 1 (Average Annual Sewer Flow - Million Gallons (MG) I 1SALES/USAGE DATA ' INCOME (LOSS) 'AL - LOANS AND PRINCIPLE PAYMENTS [Storm Fund Loan [New Water Bond (Water Bond AS AND PRINCIPLE PAYMENTS 'AL - CAPITAL EXPENSES Construction Other Equipment (ERP) [Capital Lease Fiscal Agent Fee _ Bonding (15 yrs @ 5 %) [Interest Expense (new bonds) 'Interest Expense ' i- OPERATING INCOME (LOSS) ' OPERATING INCOME (LOSS) - 1 [ r 790 [ 930 840 830 r [ [Budvet Codes [370 1 [a 19 [417 1 418 sapo0 laapngl 1 _ .. $561,051 L ($1,393) • ($96,919) L $211,929 L (5308,848) r $115,000 L $115,000 L $66,809 I $53,954 $12,855 L ($124,532) I $45,000 $400 MY $79,132 L ($2,507)1 1 51,000,861 r - $211,929 I 531,663 531,472 r $294,831 r . 8101,749_ $329,217 j L $998,354 $6,476 $10,213 1 $21,709 L ($1,164)1 I $11,882 $949,238 1 $659,363 $60,00] $24.00 $18.00 1 $9.00. $949,238 I $1.201 791 1 $264,618. $208,666 L . 8473,284 L ($612) ($87,155) $196,882 (5284,037) $120,000 $120,000 $85,675 [ - $36,446 $49,229 (8118,707) 545,000 5490 $73,217 1 $40,3451 0££`£60`1$ 1 I $196,882 i $35,376 $34,994 $287,432 , I $130,444 $358,202 1 $1,083,675 $9,346 L $20,314 $26,394 ($5, $0 $1,032,802 1 $561,051 1 $70.00 528.00 $21.00 L $10.50 81,032,802 1 51.401 738 1 $205,872 L 5210,919 I _$416,791 L (556,493) 1 $265,000 1 (5321,493) 1 $125,000 $125,000 1 $95,500 L $75,000 L $20,500 1 ($114,999) 1 $45,000 $300 ,. y � L $69,699 I -' 514,006 66S`PS0`IS 1 $265,000 $31,916 1 549,300 ' L - $276,905 L $120,665 L $310,808 1 $1,068,600 $10,000 $18,000 1 L $18,000 L $3,000 $0 1 $1,019,600 ' $473,284 L - $70.00 1 528.00 $21.00 $10.50 $1,019,600 51.40 1 728 1 1 Current FY $8,115 • $216,346 • $224,461_ ($192,330) $265,000 r (8457,330) r $130,000 L $130,000 L - $397,800 L $374,700 1 $23,100 1 ($108,355) [ $45,000 1 $63,355 L 8178,825 1 $1,081,730 L $265,000 L $33,352 [__ $50,779 1 8287,175 S321,140 i 9SS`09Z`1S _. _ $12,000 $18,756 1 1 $18,000 1 $1,211,800, $416,791 1_ 583.00 $33.20 524.90 1 $12.45 1 $1,211,8001 $1.66 730 1 Future Projected Operations 1 545,963 r $221,972 r $267,934 L 543,473 r 5265,000 (LZS r $140,000 $140,000 r $543,000 r $543,000 $0 r $173,430 r $45,000 1 $56,570 r 5288,043 1 $ 1,109,1 [ $265,1 [ $34,855 552,302 r 8297,856 r $128,013 _ $331,831 r $1,397,901 $12,000 L $10,101 [ 518,000 $224,461 1 $93.00 1 $37.20 ' 1 527.90 1 L $13.95 1 $1,357,800 $1.86 730 1 $62,640 H_ 5227,803 $290,442 $22,508 $265,000 ($242,492) $145,000 $145,000 $393,200 $381,000 $12,200 $5,663 $45,000 $49,337 5290,045 _ 51,139,014 [ 8265,000. [ -- $36,428 $53,871 5308,964 $131,854 $342,897 1 51,429,059 $12,001 [ $12,057 $18,001 5267,934 - $95.00... $38.00 $28.50 I L _ $14.25 [_ _ $1,387,0001 _- $L901 1 7301 1 2010 1 1 "$93,219. L $233,848 I 5327,067 $36,624 1 $265,000 ($228,376) 1 $255,000 $100,000 $155,000 5176,800 $170,000 ' L $6,800 1 ($86,610) 1 $45,000 $41,610 1 5290,034 1 $1,169,240 [ 5265,0001 838,074 1 1 $55,488 $320,51 L $135,810 1 L $354,350 1 $1,459,274 $12,002 1 $13,071 L 518,0021 I $1,416,200 - $290,442 L - $97.00 I $38,801 1 529.10 [ $14.55 1 $1,416,2001 1 $1.94 730 1 2011 1 1 ;, - $83,118 $240,: [ S323,5 E ($3,833) L 5265,000 1 (8268,833) 1 $310,000 1 $15Q000 I $160,000 fl $170,000 1 $170,000 $0 1 (878,380) L $45,000 L $33,380 1 r 5289,541 1 $1,200,577 $265,000 7 $39,7981 _ $57,152 8332,538 1 7 - 5139,884 1 5366,205 $1,490,124 $12,0031 $14,718 1 1 $18,003 1 $1,445,400 $327,067 599.00 1 839.60 I 529.70 $14.85 1 $1,445,40 $1.981 7301 2012 1 1 530,229 1 _ $246,614 I $276,843 L, ($46,391) L $265,000 1 (5311,391) 1 $170,000 $170,000 L $357,800 1 $218,000 $139,800 L (569,675) L $45,000 $24,675 L .' $286,04 L $1,233,069 8265,000 1 L $41,602 L $58,867 - 5345,044 r _$144,080 1 $378,477 1 ' $1,519,154 1 $12,004 $14,546 L $18,004 1 L $1,474,600 $323,234 1 $101 r $40.401 530.30 1 $15.15 $1,474,600 1 $2.021 7301 2013 1 I - - $43,686. _ $253,352 r- $297,038 r $20,196 r $265,000 1 ($244,804) 1 $305,000 $125,000 $180,000 r $159,000 1 $159,000 50 r ($60,310) F $45,000_ $15,310 ' $279506 [ - $1,266,762 $265,000_ [ 543,491_ $60,633 [ $358,055 [ $148,403_ $391,181_ $1,546,268 $12,005 $12,458_ I $18,005 $1,503,800 $276,843 $10 3.001 $41.20 $30.90 1 -_- $15.451 $1,503,8001 $2.061 73 2014 1 I, $94,248 L $260,341 L _ _ $354,589 $57,551 I $265,000 ($207,449) 5190,000 $190,000 $249,200 $235,000 L $14,200 ($50,225) $45,000 $5,225 $281,976' $1,301,703 $265,000 $45,461 562,452 $371,59 L $152,855 1 $404,334 1 $1,583,679 1 $12,006 1 _ $13,3671 L . $18,0061 $1,540,300 $297,038 $10530 1 $42,201 531.65 1 315,83 1 51,540,30 $2.11 7301 2015 1 $481,830 $267,588 L. _$749,418 L . $394,829 L $265,000 $129,829 1 SO $110,000 L 8110,000 $0 ($45,000) L $45,000 hr 5284,829 51,337,941 $265,000 $47,540 L 564,325 $385,684 $157,440 1 $417,952 $1,622,771 $12,007 $15,957 r $18,007 L. 008`9L5`I $ - L 543.20 82.16 730 2016 $61,700 1 1 5400,348 1 L $1,677,94c L $1,613,300 L $749,418 S33.15 1 1 $1,613,3001 I 2017 I Z o O mo m - Cm Z A �_ C C m - Z z Z M m X (n O m m —I N D 1Surplus over minimum carryover. ...... 1Min. Cash Balance @ 20% of Operating Costs Ending Cash Balance Inventory Change 1Change in Available Funds Adjustment for Depreciation NET INCOME (LOSS) (Other Equipment (ERP) Motor Vehicles Computers CAPITAL EXPENSES Interest on Bonds E 9 y77, 4 u Ir tfi. FifiL 11r'ri'T w . w. . ...,...- Capital Lease NET NON - OPERATING INCOME (LOSS) NON - OPERATING INCOME (LOSS) NET OPERATING INCOME (LOSS) 3% 1Depreciation SUBTOTAL OPERATING EXPENDITURES Total - Contracted Services Total - Taxes and Insurance 2% (Communications (Telephone, Cellular) Total - Utilities 13% (Administration Chargeback 5% Electricity 3% Garbage Utilities 5% IHeating Fuel - Gas (Total - Materials, Supplies and Services 13% 1Maint. & Repair 13% (Pares and Supplies 3% Office, Uniforms, General Supplies, and Postage 3% Equipment and Vehicles (Materials, Supplies and Services (Total Salaries and Employee Benefits 5% 3% 13% 13% 3% 3% !Salaries and Employee Benefits ;Interest Earned (5.5% on ending balance) 'Reimbursements Permits Penalties Charges for Services (Beginning Cash Balance REVENUE (Average Large Commercial Bill (50,000 gallons) (Average Small Commercial Bill (20,000 gallons) Average Residential Bill (7,500 gallons) !Revenue - Per Gallon Charge Average Annual Sewer Flow - Million Gallons (MG) Rate per 1,000 gallons SALES/USAGE DATA 'AL - LOANS AND PRINCIPLE PAYMENTS Sewer Bond - Principal Payment (15 yr) Sewer Bond 2 - Principal Payment (15 yr) (Loan from Storm Fund ,NS AND PRINCIPLE PAYMENTS Insurance (SL Conv/LTD, Health, WC) Paid Leave Accrual FICA IPERA Regular Employees Overtime & Part-Time 1 790 740 760 930 680 1584,586 1622 -. - -_ 1604 Ckk , 623 602 1544, 565, 567 r545 540, 541, 542, 560 543,549,563 524,527,531 535 1526 1525 500 501,503 370 446 419 418 400 Budvet Codes $420,723 • ($848) ($233,064)1 597,457 1 1 (tZ5`0££s) $0 1 (000`05$) 7 000`05$ (f90`$81$) $97,457 51,475,588 $16,103 $15,837 $2,662 $1,124,286 1 $181,641 086`5$ Z58`o1$ $410 $49,744 $11,352 1 $ 55,783 $32,609 5172,161 1 $18,871 $6,959 $9,449 1 $6,9461 $115,618 $14,318 1 IEL`Z1$ 50 $5,059 $14,320 81,258,415 $654,635 1 $112.501 545.00 1 $16.88 $1,258,415 1 559 1 $2.251 $414,387 ($6,336) $123,337 ($129,673) SO $32,229 557,278 $17,000 (000`os$) 000`05$ $65,899. $123,337 $1,608,116 530,634 $17,181 $3,176 51,217,306 $234,808 511,251 3P/W. 58,400 $372 534,199 $8,915 $2,295 900`51$ £86`L$ $185,459 523,233 ($200) $10,433 58,099 $129,233 514,661 $26,504 520,000 $195,855 $2,794 51,428,862 $420,723 5125.00 550.00 518.75 $1,428,862 572 52.50 2006 513,532 __ ($400,855)1 5150,000 1 ,(558`055$) 1 50 1 1 $26,000 ' t P 0 1 $$0,000 $50,000 (5299,855)) $150,000 51,779,755 68I'0Z$ 00L*S$ 54,800 51,282,360 1 $236,553 $14,000 1 $6,000_ $750 1 575,300 522,000 50 1 001 zvs Ooz i rs 1 $197,2061 $27,506 1 52,3041 1 59,550 • 1 $8,516 $142,560 $6,770 000'LZ$ 1 $8,000_ $15,000 006`62915 1 $414,357 1 1 sso.00J $18.75 1 $1,429,900 572 52.501 Current FY 2007 1 570,493 1 5379,591 5450,085 $436,5531 $154,500 $282,053 1 SO $ SMTIY 000'OSL$ 000'05$ 1,13 t1e4 'M'1 (5278,347)1 $154,500 $1,897,956 556,341 521,198 $4,896 $1,351,686 1 $243,650 081`95 00L`bl$ 5788 577,559 I__ _$22,660 50 1 $11,536 $43,363 r_ $236,672 1 528,881 1 52,373 1 $9,837 $8,771 $179,837 $6,973 -- 51,619,609 $609 50 L $8,000 $15,000 51,596,000 _ $13,532 1 $140.001 $56.00 521.00 $1,596,0001 570 52.80 r ($286,448) F -- _ $397,720 $111,272 (5338,813)1 5159,135 ($497,948) 540,000 540,000 $0 (000'06$) 000'05$ 000`06$ ($178,348)' 209886l$ 5E1`65l$ 558,031 522,258 $4,994 51,424,941 $250,959 $15,435 1E5k w ' $6,365 $827 $79,886_ $23,340 50 511,882 $44,664 $244,350_ $30,325 52,444 $10,132 $9,035 - $185,232 $7,182 51,810,254 el iv el u Q th 515 5.001 562.00 1 523.25 1 570 S3,I0� 20009 I 5122,415 1 5410,195 -. 5532,611 5421,339 1 -_ $163,909 r- 5257,430 545,000 000`54$ 1 5 0 OOOYI85 000'05$ Otort li 000`8£5 (584,970)'. 5163,909 52,050,977 559,772 523,371 $5,094 $502,355 1 5258,488 1 $16,207 56,556 L 5868 1 $82,282 L $24,040 $0 $12,239 546,004 5219,287 $31,842 $2,518 1. -- 510,436 [_ $9,306 $157,789 $7,398 S1,966,007 L- VI io 1 5170.001 1 568.00 1 525.50 1 -..._. 570 53.401 1 $64,828 1 $430,071 5494,899 ( 53 7 ,7 12 ) ' $168,826 (5206,538) 590,000 $50,000 540,000 [_ $6,800 OSZ'PL$ 000'oss twit r " OSL`$L$ $5,612.1 $168,826 52,150,356 $61,565 524,540 IL 1 961`SS L $266,242 517,017 $6,753 I___ $912 1 $84,751 1 $24,761 $0 $12,606 547,384 1 5226,5031 $33,434 1 $2,593 1 1 $10,749 1 1 $9,585 $162,523 $7,620 52,155,967 1 - $23,967 $0 1 $8,000 1 $15,000 1 52,109,000 1 $532,611 1 - __$185.00] $74.00[ 527.75 52,109,0001 570 53.70 2011 1 $162,242 5450,995 5613,236 5118,338 5173,891 (555,554) 5100,000 000`54$ 000`55$ $0 0SL'8L1$ 000`05s OSZ`IL$ ! 1 570,296: $173,891 $2,254,974 563,412 525,767 1 00£'5$ $274,230 $17,868 'Sic : $6,956 5957 r 587,293 525,504 $0 508`86$ b86`ZI$ $233,966 r- $35,105 1 $2,671 1 511,071 $9,872 $167,398 $7,848 r 52,325,270 $22,270 $0 58,000 000`51$ 1 52,280,000 $494,899 5200.001 880.00 1 530.00 ! 52,280,000 570 $4.00 1 $269,541 1 5473,025 1 $742,566 1 $129,329 $179,108 1 (549,779) 5115,000 000`05$ 000'59$ 000`5$ 1 OSL'E£$ 000`05$ 0 Z'99$ ,:....., $136,471 6Zl'S9f`Z$ 801`6L15 565,315 527,055 55,406 51,762,047 $282,457 518,761 13'4":x7 { 'X_tr: $7,164 $1,005 1 $89,912 1_ 526,269 1 50 $13,373 550,270 $241,687 536,861 $2,751 $11,403 [ 510,169 5172,420 58,084 52,501,596 527,596 50 1_ 58,000 1 $15,000 1 52,451,000 5613,236 $215.00 586.00 532.25 52,451,000 570 $4.30 1 5231,924 5496,223 5728,147 ($14,419) $184,481 (5198,900)1 $130,000 000`55s 000 1 1 1 $35,700 $60,500 $50,000 (5110,500) $197,300 $184,481 1 52,481,115 1 567,274 1 528,408 1 $5,514 1 51,858,667 1 1 $290,930 1 1 $19,699 1 57,379 $1,055 _ $92,610 527,057 50 513,775 1 551,778 5249,6751 538,704 52,834 511,745 1 510,4741 $177,593 $8,326 52,678,415 I 1 $33,415 1 1 50 1 $8,000 1_ $15,000 52,622,000 $742,566 __.. $230.001 592.00 1 534.50 1 $2,622,000) 570 $4.60 1 $299,001 $520,655 5819,656 1 $91,509 5190,016 1 598,507) 5140,000 1 580,000 560,000 $0 )ice (000`6015) 000`055 000`45$ 1 5245,493 $190,016 1 52,603,274 1 569,292 1 529,828 $5,624 51,960,810 $299,658 520,684 $7,601 51,108 $95,388_ $27,869 $0 514,188 553,331 5257,940 $40,639 $2,919 512,098 510,788 $182,921 58,576 $2,848,767 $32,767 $0 $8,000 $15,000 52,793,000 5728,147 5245.00 598.00 $36.75 52,793,000 570 $4.90 2015 1 $146,323 1 $546,389 5692,711 1 (5126,944) $195,716 1 (5322,660)1 5245,000 1 000`59$ 1 000`08$ 1 $100,000 009`££$ $47,000 $50,000 ($97,000) $177,940: $195,716 1 52,731,945 1 531,320 , 52,068,798 • 521,719 57,829 L $98,249 528,705 50 5266,491 1 542,671 53,006 512,461 1 511,111 1 5188,408 52,909,885 50 58,000 L $15,000 52,850,000 5819,656 L 5250.00 537.50 1 570' 55.001 (5291,972) 5255,000 585,000 570,000 5100,000 1 526,400 r2i 1 5179,178 1 573,512 532,886 5317,907 529,566 5275,339 544,804 512,834 511,445 5194,060 59,098 52,992,500 5262.50 5105.00 539.38 52,992,500 570 0 00 0 U 'z 2 0 rn 0 m X O to z z Z k D cn C j m zmZ mpm v cn m Q m D ci (Surplus over minimum carryover Min. Cash Balance @ 20% of Operating Costs [Ending Cash Balance Inventory Change Change in Available Funds Adjustment for Depreciation [NET INCOME (LOSS% TOTAL - LOANS AND PRINCIPLE PAYMENTS I 12003 Principal Bondy Payment 1 2001 Principal Bond Payment 1999 Principal Bond Payment [LOANS AND PRINCIPLE PAYMENTS [CAPITAL EXPENSES [NET NON - OPERATING INCOME (LOSS[ Trans In"S Sanitaz} Sewer Fund':;: l.1�Yn�]- t C,O`01r�.S:fJa;1 nI Capital L Fiscal Agent Fee Interest Expense 1NON- OPERATING INCOME (LOSS 1 NET OPERATING INCOME (LOSS) SUBTOTAL OPERATING EXPENDITURES 3% [Depreciation [Total - Taxes and Insurance Total - Contracted Services Total - Utilities Total - Materials, Supplies and Services (Total Salaries and Employee Benefits SUBTOTAL REVENUE OPERATING EXPENDITURES Interest Earned (5.5% on ending balance) Reimbursements Permits Penalties Charges for Services Beginning Cash Balance 1 REVENUE Animal Revenue - Per Acre Charge I [Rate per REF - Monthly [Average REF'S Charged LL SALES/USAGE DATA 'AL - CAPITAL EXPENSES Construction Other Equipment (ERP) 790 930 1 840 820 680 I Budpet Codes 370 446 419 418 400 I Budaet Codes 1 5661,202 1 1 1 $4.00 5894,371 ($40,968), $182,928 [ (5223,896)' 5325,000 $45,000 1 $195,000 $85,000 $99,210 [ 599,210 (5155,213) $25,000 $679 5129,534 1 5355,527 [ 5326,970 I $182,928 $1,956 57,849 $77,232 516,979 540,026 5682,497 $15,649 50 $5,646 5661,202 $935,339 13,775 2005 1 5923,842 529,471 $185,004 1 (5155,533) 5330,000 [ $45,000 $195,000 1 $90,000 $164,115 L , $155,115 1 $9,000 (5144,445) $25,000 $962 $118,483 1 5483,027 $292,234 1 $185,004 1 51,690 52,828 $68,654 $6,165 527,893 5775,261 540,078 $0 $7,257 5727,926 $894,371 5727,926 [ $4.50 13,480 2006 $680,446 L 569,615 L 5750,061 [ ($173,781) [ 5185,000 1 ($358,781) $350,000 ✓ sso,000 ✓ 5205,000 $95,000 r- - 5173,000 1 $173,000 1 (5236,605) $25,000 H :.rl $111,605 r 5400,824 1 5348,076 F $185,000 1 52,009 520,900 oo$`rf$ 1 535,248 f $748,900 , $22,000 1 $0 000`5$ 1 5721,900 $923,842 5721,900 $430 1 13,369 2007 Current FY L - 5507,538 L 570,906 I $578,444 (5171,617) $190,550 1 ($362,167) I 5365,0001 1000`05$ _I r - $215,000 1 $10Q000 F $280,000 $280,0001 $0 (5130,816)1 $25,000 1 [ $105,816 [ 5413,649 $354,531 I [ - $190,550 [_ $2,109_ [_ _ 521,527 [ 531,724_1 5768,179 1_ 541,253 1 $0 $5,000 1 $721,926 I 5750,061 I _5721,926 $4.50 [ 13,369 Future Projected Operations 1 -- $327,397 $73,061 r 5400,458 ($177,986) $196,267 (5374,252) l 5365,000 000`05$ 1 [ 5215,000 $10 591,000 591,000 $0 (5391,901) $25,000 591,901 I $473,649 69Z`961$ -1 52,215 $22,173 574,389 532,676 537,586 $31,814 onus 5578,444 I asoo $31,234) $75,282 544,048_ [ ($356,410) $202,154 [ ($558,565) [ - 5385,000 $55,000 $225,000 $105,000 5324,000 [_ 5324,000 [ 50 [ (5302,319) 525,000 $77,319 r $452,754 [ $376,411 $202,154 S2,326 1 522,838 576,621 L 533,656 r 538,816 $22,025 $5,000 1_ 5802,140 5400,458 5802,140 $5.00 13,369 $115,329 [ 577,571 L 5192,900 [ - $148,852 [ $208,219 [ ($59,367) [ - 5165,000 000'sgs I 5110,000 5125,000 1 5125,000 $0 I ($191,073) 525,000 ;: . ;: $100,00 $66,073 $421,706 $387,856 5208,219 52,442 • $23,523 $78,920 534,666 540,087 5809,563 1 52,423 $0 $5,000 5802,140 L 544,048 1 - 5802,140 1 $5.00 13,369 $234,078 1 1 $79,931 1 $314,008 L . $121,108 I 5214,466 I ($93,358) I 5170,000 000`55$ L $115,000 1 $108,000 1 $108,000 $0 1 (5233,454)1 I OOOSZ$ , , $150,000; $58,454 5418,096 5399,653 $214,466 $2,564 524,229 581,287 ' $35,706 L 541,402 5817,750 $1Q610 $0 $5,000 5802,140 5192,900 ' 1 5802,140 $5.00 13,369 5337,251 $82,362 5419,614 $105,605 5220,900 ($115,294) $180,000 $60,000 [ $120,000 $122,500 5120,000 52,500 (f6£`SZZ5) $25,000 $50,393 5412,599 5411,812 5220,900 52,692 524,956 L 583,726 536,777 542,762 5824,410 517,270 $0 $5,000 5802,140 5314,008 _ $802,140 1 $5.00 L 13,369 $716,344 1 1 $84,869 5801,213 5381,599 1 $227,527 $154,072 5190,000 $60,000 5130,000 1 5120,000 1 1 $120,000 1 $0 558,197 $25,0001 $12 5,000 [ $41,803 $405,875 [ S424,3431 [ $227,527 52,827 525,704 586,238 [ $37,880 $44,168 $830,219 1 $23,079 $ 0 1 000`$$ J 5802,140 1 $419,614 1 5802,140 1 $5.00 13,369 $982,383 587,452 51,069,835 $268,622 $234,352 $34,270 $200,000 1 $65,000 1 5135,000 I 5122,000 I $122,000 50 1 ($57,677) EMW $25,0001 $32,677 I 5413,947 5437,260 I I 5234,352 52,968 1 526,475 1 588,825 539,017 � 545,623 5851,207 L 544,067 50 . 000`5$ 5802,140 1 $801,213 $802,140 $5.00 1 13,369 $1,487,873 1 $90,115 51,577,988 $508,153 $241,383 $266,770 565,000 $65,000 $132,000 $132,000 $0 $48,363 000'$Z$ 4100 001$ `21: 526,637 I 5415,407 $450,574 $241,383 [ $3,117 $27,270 1 591,489 540,187 $47,128 5865,981 1 $58,841 SO 1 $5,000 1 5802,140 51,069,835 5802,140 1 $5.00 -- 13,369 L $812,586 $92,859 I 5905,446 ($672,542)1 5248,625 I 1 ($921,167)1 570,000 1 570,000 1 I 5132,000 I $132,000 1 1 so 400810 1 000'SZ$ Infliatar 000`001$ I'z $23,800 1 1 $429,6331 $464,296 1 $2 528,0881 594,2341 541,393 1 $48,685 1 5893,929 $86,789 1 so $5,000 5802,140T $1,577,988 1 5802,1401 1 $5.001 13,369 Z o O n I m X 0 m Z p0) m A m m - 'J r" Z °Z m ' O z m D cn