Loading...
12. Evergreen Sewer District Rate for FY 2011/20121•Kali*spell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758 -7758 REPORT TO. Mayor Fisher & City Council Members FROM: Rick Wills, Assistant Finance Director Jane Howington, City Manager SUBJECT: Evergreen Sever Rate for Fiscal Year 2011 /2012 MEETING DATE: August 15, 2011 BACKGROUND: please find attached several sheets of information. This compilation is for the Wastewater Treatment Punt operations only and does not include the billing costs, bad debt expense, depreciation or sanitary serer expenses. The first sheet is a compilation of the expenses of the WWTP for the fiscal year 2011. Our operating expenses decreased slightly from the prior year. FY2010 expenses are included for comparison. Evergreen Sewer District's FY2012 rate is based on our operational expenses for FY2011 prorated at the percent of usage based on meter readings at the lift station and the plant. A page is attached with the meter readings and usage. Evergreen's usage is up 15.49%, while the total plant usage is up 13.93%. As a result, Evergreen's share of the total flows has increased from 15.9% to 1 G.12%. This is not a percent of capacity only a percent offlows f ows treated at the plant. The percent of usage (16.12%) is applied to our operating expenses and replacement fund requirements to arrive at the total cost for treating Evergreen's sewage. The cost is then divided by their gallons of usage to arrive at the rate per thousand. This calculates to $1.54 (down $0.22 from FY2011) per thousand and is the new rate for FY2012. Due to the expansion of the plant, beginning in FYI I the district will pay 12% of the debt service costs regardless of the usage. The Evergreen debt service expense for FY12 is $12,467.35 per month, down from $12,518.50 for FYI 1 - The amended Evergreen agreement calls for Evergreen to share in the equity of the WWTP Replacement Reserve account. A reconciliation of the reserve account is included. The items for which replacement funds were used are listed on the reconciliation page. The account earned $6,534.17 M* interest. The equipment replacement schedule has been adjusted and updated for the reconciliation of the reserve account. Evergreens total equity in the replacement reserve account is $1945045.15. c mmen 'o Motion to approve Evergreen sewer rate for fiscal year 2011 /2012. Rick Wills, Assistant Finance Director Yane Howington, City Man Report compiled: July 29, 2011 2011 WWTP... FISCAL YEAR 2011 Prepared: 7/25/11 City Finance Offlce Wagesffica/medt/wc/uziemp. $ 451,559.00 Overtime $ 20,292.00 Health Ins. $ 73,462.00 PERD $ 30, ,203.00 Supplies & equipment 139461.00 Non -capital equipment $ 7!)920.00 Lab supplies $ 7,347.00 Alum $ 15,368.00 Chemicals $ 14,659.4® Gas & Oil $ 105,527.00 Postage & freight $ 772.00 Licenses & fees $ 61,646.00 Electricity $ 159,496.00 Water $ 519475.00 Natural Gas $ .520717.00 plione lease/charges/pagers/arms la $ 4t,292.00 Auditing $ 21>750.00 Contract Sere -Glacier Gold 1069814.00 Other Contract Sere 495047.00 Consultants $ 199609-00 Misc. Maintenance $ 895757.00 School & Training $ 10,339.00 Medical services/drug testing $ 306.00 Property & Liability Ins. $ 515379-00 Central Garage $ 3$500.00 Admin. Transfer $ 1051)424.00 Data Processing $ 1811,305.00 Total Operating Expenses $ 19332,326.00 X 0.1612 $ 2141)781.49 $ 1. 180 per thousand gallons Replacement $ 411 ,598.48 X 0.1612 $ 66,352.93 $ 0.364 per thousand gallons Annual cost to Evergreen $ 2817134.43 $ 1.54 per thousand gallons Debt service / Evergreen 12% 149,608.20 annual Ever en Flows 182,065,477 16.12% Total Kalispell Flows 1912%3833000 12,467.35 per month 2010 WWTP... FISCAL YEAR 2010 Prepared: 7/27/10 City Finance Office Wageslfica/medt/wclunemp. $ 501,145.00 Overtime $ 20, 877.00 Health Ins. $ 82,616.00 PERD $ 32,721.00 Supplies & equipment $ 9,820.00 Non -capital equipment $ 7,597.00 Lab supplies $ 8,211.00 Alum $ 20,156.00 Chemicals $ 7,738.00 Gas & Oil $ 12,545.00 Consumable tools $ 1,0I0.00 Postage & freight $ 231.00 Memberships & dues $ 401.00 Licenses & fees $ 6,783.00 Electricity $ 168,619.00 Water $ 5,344.00 Natural Gas $ 507002.00 phone leas elchargeslpagerslalarms $ 5,179.00 Auditing $ 2,750.00 Contract Serv-Glacier Gold $ 128,712.00 Other Contract Sery $ 52,479.00 Consultants $ 23,679.00 Misc. Maintenance $ 11,030.00 School & Training $ 8,202.00 Medical services/drug testing $ 482.00 Property &. Liability Ins. $ 46,941.00 Central Garage $ 4,000.00 Admin. Transfer $ 957228.00 Data Processing $ 19,504.00 Equipment rental $ 75.00 Total Operating Expenses $ 113347077.00 x 0.1590 $ 21.2, I53.13 $ 1.346 per thousand gallons Replacement $ 411,598.48 x 0.1590 $ 65,454.92 $ 0.415 per thousand gallons Ani-ival cost. to Evergreen $ 277,608.05 $ 1.76 per thousand gallons Debt service 1 Evergreen 12% $ 150,222.00 annual $ 12,518.50 per month Ever een Flows 15.7,645.410 15.90% Total Kalispell Flows 991. , 315,000 I 333$ i � 1 o000000000 ( aaa©oo0 I�?000n❑o0o CD o❑ © C� �a MI _© S 0 (D co co Lo 0') Lo r Co r " "t d' N � Liz 4J C7 Liy �t colr� N M i� a.[ . j_ c+} co T CD CO OD .�. �t CC! t8 € p L) 0 CD LO N. CY3 0 cr) € T- Cn m oo r• r-_r• nt W N 00 co © N N 0 CL CD C I o o D >, (DF.; cc 00000001000000 oomm(ncDo;coC CDC v ai �t o 0o r= CO? LCj CS] T L11 -t ❑ N Lf) t- -r--- tQ . r ❑ T~ C\! r € cr) 0) i G3 LO M Lt7 CD N (0 d CD 0 d' co a) 0')f � I--cr) a) r- Lo Ln CS] C'r3 C7 066 00 co (D LC] CV M CD Liz lqt CD 00 00� € T-- CV Cr'7 ',,t' Lo co i-_ C8') �yy }co[ f0 }4�_ )- 0)- )- €€ € F j € =) fIf{tkiii co (D cn t © Q Jj]j1 ~ 00 f cn 1 N co P € M F 0) t` co 1 M o i a/ C37 N wo©00❑❑00000C) ©.©aan©oo©�on� I ©C! ! a, o o LO CY) LO N ❑ Q Cr:CD D N I cq CD r RI CO 0 16 Tt- OQ CV L7 CD p©L7mocnt�r,-u0,-tDwt❑❑ CD LjC3C]CV CV cf N CV vC]a �, c "o p� r�fiC TN r r T r r r r r^ r CO oo 4r_ r U W l a E © tm 0 as !D Q J N U_ w =0 0 0 0 ❑ 0 000 ❑ 0 00 % o o 0 C7o o o 0❑ o o 0 o N W ¢ 00 LO U) C3] C6- CD 0 to r, N "t 0 r" LC] co "Zr Q) 0 C07 Lf# .r.+ V1 , �+ t r, -r—r-- 0) cf) CD ❑ d CD N LO N L J CO r- Lf) LO CO r^ OD bt LO r CO (0 P­ J (D = � � �" W ,- of m © Lf] T t, ❑ C6 tD a T LCj OC] r� 00e-- N M 0 M 0 0 r M "�f LO t` ❑ d Q1 LO CD Lid Liz LO ii 3 LO LO CD (D CQ CO tD CCU t• � � � C ) o fA o ❑ o❑ 0❑ 0 cz s. r-- r- r r r- 1- r r o 0 0 0 0 0 0 0❑ 0 0 0 0 N N N N CV N N N N N Cif N N '� = � Q r© 1! 1 1 1 1 1 1 1 1 1 1 1 � T r r- r r- r r r r r r T T• � € 6] O nj Chi C17 f LO 7 Ui 0 T.. N 0 N Ri € r-• T r ® Q] (� �] a 0 CO 03 Cl z [.: Ww W C) KALI$PEL� WASTFWATER TREATMENT PLANT EVERGRE=EN SEWER D1STR1CT/KAL1SFELL, WWTP FLOW DATA FY10/11 ACCOUNT#9262 11E-01 (90) Outflow Meter Reading Evergreen's Usage Average Daily Use at the Evergreen for the for the Influent Meter Reading Date Main Lift Station Preceeding- Period, Preceeding Perin-d- at the WWT 7/1/2010 525,619;000 16,056,600 535,220 9, 087, 548, 600 811/2010 541,143,600 1!5,524)600 50U,794 91183,904,600 911/2010 554,5165J00 1313721500 4311371 9,269)5201600 10/1/2010 5671518,300 13V002f200 4331407 9,351,658,600 11/1/2010 580)3961300 1218781000 415;419 9,425,271,600 12/1/2010 5936137)100 12174OT800 424,693 91495,616,600 11112011 60698621900 13,725,,800 442,768 9,56914651600 2/1/2011 61914047000 1215411100 4041552 976531919,600 3/1/2011 631,540,400 121136V400 4331443 9)740,001,6()0 4/1/2011 645,1871700 1316471300 440,235 938681412)600 5/1/2()11 658,6251800 13$438t100 447,937 9, 980, 992,600 6/1/2011 6777658,500 191032t70O 613,958 10)08713171600 7/1/2011 7081724,200 319065)700 11035,523 1012160931,600 TSS/BOD SURCHARGE PER CONTRACT Anal to Date Result ppm Calculated Surcharg B.O.D. T. S. s CITY OF KALJSPELL-MnNTP REPLACEMENT EQUIPMENT SCHEDULE Fiscal year ending 6/30: Refrigerator sam ter 2C.09 DELETES -2730.37 2009 ADDS 4672.1 2009 DELETES L009 ADDS 201i] DELETES 2010 ADDS 2011 DELETES 2011 ADDS huian�e $4,672.10 2005 GMC 3/4 TON P/U $18,243.28 2005 GMC 3/4 TON PIU WI PLOW $25,330.27 Interim Phos horns equip $31,498.80 E ui went, etc. 1994 Plant: -657332.68 1272791.48 -6608.25 7425 -458.8 975293.79 $1,610,566.75 Misc. 2rocess equipment $45,000.00 Mechanical Bar Screen -40000 145000 39751.55 $184,751.55 Grit removal & dewatering -70000 97350 38415.85 $135,765.85 Lift station puTyL, motors & controls -12000 24000 38616 $195,616.00 Prim. Clarifier slud e collecting equip -50000 61875 85293.87 $147,168.87 Prim. Clarifier scum collecting equip -16000 29000 1876.12 $30,876.12 Bioreactor mechanical mixers -24000 49280 503705.62 $828,985.62 Final clarifier Rim Drive, mechanism,etc. 210600 $730,516,92 Dissolved Air floatation $300,000,00 Belt filter press $350,000.00 Chemical feed system $125,612.27 Effluent filters $400,000.00 UV Disinfection -22000 68205 -100000 306795 17513.94 $392,513.94 Process air equipment -155912.63 381000 73914 $454,914.00 Fernienter mixers -42000 75000 318120 $393,120.00 Odor Control scrubber -102000 179000 25948.78 $204,948.79 Slide and_stop gates -35000 52206 -8927.59 10031 190242.79 $278,552.20 Emer ency Power generator $45.000.00 Sludge belt conveyor -8000 12090.05 $64,090.05 Pumps- rimary sludge, primary &final scum -65000 $15,000.00 Pum s-WAS,Fermenter Su ernatant,RAS -3920.45 4405 77234.3 $162,718.85 Pum s-DAF float,Di ested sludge,Fermenter recycle -30000 $60,000.00 Pum s-filtrate waste return $35,000.00 Pum s-non- otable water $4.500.00 Pum s-anaerobic and Denitrification recyc -45428.56 237600 43005.6 $280,605.60 Laboratory equipment $60,646.33 Sludge hauling truck 30385 $30,385.00 Scum um s(moyno um s)-2 $23,200.81 Gas detections stem -12141.68 16617.45 $16,617,45 Gorman -Rupp 4" trash um !trailer $14,334.95 John Deere tractor mower $4,000.00 Gas Monitor -1975 15048 $15,048.00 Kenworth Sludge Truck $208,614,80 Utility Tractor w160" mower/loader $12,375.00 Pro ammable Logic Control Unit. 11257.48 $177,927.53 Move Fence to E Boundar -7060 87749.63 $87,749,63 misc. re lacement equipment -55032 $ 61,833.53 -41263.28 46363.24 $25,502.30 (1.206.523.45) $ 2.394.413.11 (305.176.00) $ 768,109.29 � . (2.925.719.49) 2,77UO4.77 �...... � - $5,530,137.94 $7,924.551.05 $7,619,375.05 $8,387,484.34 $5,461,764.85 $8,231,969.62 $8,231,969,62 $8,231,969.62 $8,231,969.62 276,506.90 $ 396,22T55 $ 380,968.75 419.374.22 273,088.24 411,598.48 411,598.48 411.598.48 Original notes: mote: 1985 facility equipment amount reduced to arrive at replacement value of $300,000. The $31,000 from the original contract is removed by the demolition from the 1985 plant. FY2000 Notes: A Kenworth sludge hauling truck was added to the fleet_ No truck was taken out of service. Added to the equipment list for future replacement. Original purchase not taken from City/Evergreen replacement funds. The Generator Project is new equipment designed to keep the system on line during power outages. FY2001 Notes: No changes to list. FY2002 Notes: A Kubota Tractor model BX2200D added to equipment. All other additions replaced worn out equipment. Replacediworn out equipment deducted from worksheet in year of acquisition. FY2005 Notes: No additions, everything replaced worn out or obsolete equipment. FY2006 Notes: No additions, everything replaced worn out or obsolete equipment. FY2008 Notes: Unidentifiable replacement equipment -original cost estimated FY2010 Notes: Expansion complete -consolidated items from prior equipment list Prepared by: Rick Wills, Assistant Finance Director 7/28/2010 cn �+ .� � � � � � .� .•� � + � � c� '�' cam] Al- IT4,C cNQ�10 \0 Qr-- 4:11 zl-C�V-"Z*m CamC= n c c v 01 o v ra c ca W) W) �o v--q C,4 ,Ir kei 00 = t— t— Ch ON ID ON v o a 00 Cam] m I* C 1 \0 M ON t- r-- 10 Q ON 0'% � a N m 110 = = �o C-11 = C 5 C`7. C� (Yi 06 C5 � 06 6 4�.7 cq 4,o *^ ^+ a., is �o m Z C -,I` t- a\ r„ n n n 4+ n n e n n In n n n an n n n illsI&S IEPS fas, 6A, 60!�in m Q tr1 $r CT Cs� Lit C Cr1 - C = Cs"Cs CCU m C+7 C3� C:,7 C� Chi .'ems ►-.a � n a n n n h n n n n n n n n n r•-t a� 4C7 Qi ---i �' C �l C ON - �" 4 v" N -5q rQoq JOS eg� 6S 69) SS �QS3 4�oq m C7 Q C= INO 0' ['- Un C� Q m 00 d" VIC t- \0 m z 00 W? �° Q C7 C3 C C� t'�3 }f7 C C,4 k N €` C N fi in d Itt In � � Q i_ i_ �' C� C� + h n n n n h n n n n n 9% h n n n n n� � � �4D 00 kn C� '-ti- C-4 Q CAI ►-� m _M r2 m eycya n�Z�6���a�� 4-04 ON I'll m Gam) •�' •S ` .0 W