Loading...
4. Evergreen Sewer Rate for Fiscal Year 2009-2010City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 REPORT TO: Mayor Kennedy and City Council Members FROM: Rick Wills, Assistant Finance Director Jane Howington, City Manager SUBJECT: Evergreen Sewer Rate for Fiscal Year 2009/2010 MEETING DATE: August 17, 2009 BACKGROUND: Please find attached several sheets of information. This compilation is for the Wastewater Treatment Plant operations only and does not include the billing costs, bad debt expense, depreciation or sanitary sewer expenses. The first sheet is a compilation of the expenses of the WWTP for the fiscal year 2009. Our operating expenses increased by about 7% from the prior year. FY2008 expenses are included for comparison. Evergreen Sewer District's FY2010 rate is based on our operational expenses for FY2009 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 down 4.49%, while the total plant usage is down 5.69%. As a result, Evergreen's share of the total flows has increased from 15.99% to 16.19%. This is not a percent of capacity only a percent of flows treated at the plant. The percent of usage (16.19%) 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.85 (up $0.22 from FY2009) per thousand and is the new rate for FY2010. The district pays 22% of the debt service costs regardless of the usage. The Evergreen debt service expense for FY10 is $9,581.55 per month, down from $9,655.21 for FY09. 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 $11,948.22 in interest. The equipment replacement schedule was adjusted for the items listed on the sheet for the reconciliation of the reserve account. Evergreens total equity in the replacement reserve account is $148,894.34. MMEN TION: Approve new rate. Jane Howington Assistant Finance Director City Manager Report compiled: August 7, 2009 ►11! WWTP... FISCAL YEAR 2009 Prepared: 8/7/09 City Finance Office Wages/fica/medt/wc/unemp. $ 515,478.00 Overtime $ 20,903.00 Health Ins. $ 82,616.00 PERD $ 32,184.00 Office Supplies $ 917.00 Small office equip $ 155.00 Computer supplies/equipment $ 3,187.00 Safety equip $ 1,552.00 Lab supplies $ 4,020.00 Janitorial Supplies $ 205.00 Alum $ 38,257.00 Chemicals $ 9,064.00 Other supplies $ 6,507.00 Gas & Oil $ 7,889.00 Consumable tools $ 4,758.00 Postage & freight $ 828.00 Memberships & dues $ 1,388.00 Licenses & fees $ 5,794.00 Electricity $ 190,767.00 Water $ 6,564.00 Natural Gas $ 52,539.00 phone lease/charges/pagers/alarms $ 5,908.00 Newly mandated pretreatement testing $ 14,622.00 Auditing $ 2,750.00 Contract Serv-Glacier Gold $ 120,550.00 Other Contract Sery $ 34,893.00 Consultants $ 21,206.00 Misc. Maintenance $ 32,043.00 Building maint. $ 2,225.00 School & Training $ 15,157.00 Medical services/drug testing $ 610.00 Property & Liability Ins. $ 43,409.00 Central Garage $ 3,500.00 Admin. Transfer $ 93,014.00 Data Processing $ 18,197.00 Equipment rental $ 960.00 Total Operating Expenses $ 1,394,616.00 x 0.1619 $ 225,786.85 $ 1.423 per thousand gallons Replacement $ 419,374.22 x 0.1619 $ 67,896.24 $ 0.428 per thousand gallons Annual cost to Evergreen $ 293,683.10 $ 1.85 per thousand gallons Debt service / Evergreen 22% $ 114,978.60 annual $ 9,581.55 per month Evergreen Flows 158,691,400 16.19% Total Kalispell Flows 980,188,000 WWTP... FISCAL YEAR 2008 Prepared: 7/24/08 City Finance Office Wages/fica/medt/wc/unemp. $ 445,879.00 Overtime $ 21,111.00 Health Ins. $ 82,441.00 PERD $ 28,660.00 Office Supplies $ 1,885.00 Small office equip $ 5,039.00 Computer supplies/equipment $ 5,586.00 Safety equip $ 5,165.00 Lab supplies $ 5,010.00 Janitorial Supplies $ 77.00 Alum $ 4,202.00 Chemicals $ 16,508.00 Other supplies $ 3,948.00 Gas & Oil $ 10,597.00 Consumable tools $ 2,461.00 Postage & freight $ 705.00 Memberships & dues $ 949.00 Licenses & fees $ 5,943.00 Electricity $ 219,627.00 Water $ 10,474.00 Natural Gas $ 69,499.00 phone lease/charges/pagers/alarms $ 5,660.00 Lab Services $ 8,652.00 Auditing $ 2,160.00 Contract Serv-Glacier Gold $ 121,606.00 Other Contract Sery $ 36,471.00 Consultants $ 11,913.00 Building maint. $ 1,991.00 School & Training $ 15,463.00 Medical services/drug testing $ 666.00 Property & Liability Ins. $ 49,351.00 Central Garage $ 3,500.00 Admin. Transfer $ 83,786.00 Data Processing $ 12,036.00 Equipment Total Operating Expenses $ 1,299,021.00 x 0.1599 $ 207,671.96 $ 1.250 per thousand gallons Replacement $ 396,227.55 x 0.1599 $ 63,344.13 $ 0.381 per thousand gallons Annual cost to Evergreen $ 271,016.09 $ 1.63 per thousand gallons Debt service / Evergreen 22% $ 115,862.56 annual Evergreen Flows 166,156,500 15.99% Total Kalispell Flows 1,039,335,200 $ 9,655.21 per month CA O O N Ln O a 0 L o y i ALL- oO00000000000 O 0 o o 0 0 0 0 0 0 0 0 0 O _ a O T CD d M CO Ln T M O O I� C6 '-000(DWo t00TLO O(o rn (D r• a a°i r` LC) 00 00 w N co I- O m F- 0 CA ,t d' CO CC) T( T M M O � � Q d 0) CO 00 o a d 4 m M � Y ,+- wn, 0000000000CDOO o O o O o o o o O o O O O O w O O M O (0 (0 M (D (0 O (D M V L Ln -,t o O co O o r- M M oS r dr (O uS d 6 m c6 T d r- o CO M M O O cr (3 Ln d N T cl O M r N (D N M O r (O W Ln O O 00 m (0 T N O M Ln N O 1- d' M M T O (C� , CCj C�4444 M � v= C O 0-0 -0-0 cm O IR � 00 a o Ln 0 M� 0 0 O 0 r. 0 f� 0 M 0 0 N� 0 0 N 0 00 0 d o N m r N 0 r O M d O t CM t 00 Il- N Ln Ln N (D *' O O r t- (O to It N N T M O N O O co d V r N O N CC CO CD N N CO O (O w d� Ln It N M r M C r N N Ct M L r w n 4- m Q = o U. d d 0 y- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 y O O N 4, CF) m t+ CO r M 00 In N Ln 0 CO 0 Cd 0 Ln 0 0 Ln 0 I� O C2 i L d 4) CO CO O O Ln M O CV 00 M (fl 0 Lc) +� > 00 I r (O Co O 00 (D O CA a) N O (O tp N d W N �t Ln 00 d T CA T O CC N N Cr r CO) Q J Cn 00 O It (007) M It f- O d' N 4-CO M yam $ d C O N It N N M N Ln N CO N N M N O CO r M N M 'It M Ln M CO M 4- (O d 0 a. ,F 0 t- T O C 00 00 co 00 00 00 0) a) a) C) m m m L 0 0 0 0 0 0 0 0 0 0 0 0 0 i O L 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N 0 N Q M O 00 y y r T N r M r N N N r r T r m 00 N O W 4- N m m O r N r N M I.n , r N Q T T T YI� L Q W ILL LU CU z U h 00 00 0; O Oi 0\ 01 0\ 01 0; h 00 — w cq — -. .-. .-r — N M > w D\ M Cl h ^+ G7 N 00 m �o ^ 00 .. N rt et O o0 h NV) h h N 00 h --� O M 0, z Ci' w M N M 01 h h 00 01 h a\ l0 N 00 i i ri m rrm rn mrnIC ryrvi m m r, , �ij r-� ti- h vi oo w <t N 69 69 6s bs 693 a -- w w 8Reeeeeee-e o�ry 000rn h In 0� In kn�c N 7 In w 00 h h 0\ 0\ 00 00 cm <t Cl 1 M 00 Q1 l h 10 Cl 0, Orn -. O N O O O O N 00 0 h O V o0 0 0 D O v O N _ a D\ N M O O 3 ^ ^' ^' ^-' .-. .-. .-, .-. ,--, .-. N N N l� M 0 7 0 V ^+ U t- 7 h O 00 � � O O M 64 64 69 ff-1 EA 69 69 b w 0 y R o" O O M 00 In N W Q W O O N M a, N 7 00 �t 10 h -. h �D �0 Z U O O �o N O O O^ N N M w O 0 N 00 O O w w h w N �0 --� 'n �c m Z o0 "t yp 00 O ^+ 00 V) 00 Vi M h N M p O O 00 r N 0; h 01 N 00 t` M rY h h h p N O M N 00 "t- M N t h^ d' 00 <t V) 00 O rt 00 NLr) �n It M C O y w bs ^ ^ N N N N N N "a bs y � }, CO 6s 6s 6s ifl 64 69 S.) 6s 6s 6s 1it ¢ k � [� QA oo O <t M N [� h O h 'cY ^• N sue.. y � � �., m O V') h N N -Y 00 0, 00 0, 0y CO E.: _m 0� 00 0, O c+1 N �0 (a,CD00 h O C V' M oo N M N av O cl DA a 0 ti abi o .a u 6s 6s bs 6s 6s Els 69 64 6s 6s 6s Elos to Z r- m� O O O C O N N 0. U O O O^ M M� 0.0 O N oll'O N't ❑ p, P. FO O O O h rt �D N h O O w h O h h 't Vc r a1 ^ h N 17 0 cVc O O O M n -� 7 n [� h O h in m �O oo ❑ �D --� co � op" Q CD O M O r M_ h M �; h h 00 N O .� 0� ^+ O e) �' �? ❑ Q 6s 6s 6s bs 6s 613 f!3 7 6s 6s EA b p �j 69, 69 6s V) q p p w awG]w n lc h 00 0\ O N M <t V7 \O t--00 01 w a �0�rn0,o�0000000000 E rnrnrnoN0o00000000 N�N Q N N� N .� 0 s 0 s 0 0 0 0 0 0 0 0 0 0 0 0 Q N N m Z5Q M M MC-)�m M M M M �O �O �0 �O �O �O �0 �O �D `O �D �c �0 In o 0� o r-- O q o 00 q M M d a, O O N O M O IO W O � w � ca , 0 0 N 00 N n o �or-oopo 0 N O M O Oc O N N Q N �10 N �O d" O\ C� N Q r � N O O N 00 O O O O O O O O O M Ln W O N O CDO O O CD O O M M O O O N O 11O �t N W kn L1 � CD O 0 N 00 ON M M 00 06 M O Q 00 ONO O 00 N O N r N 00 M O o0 M .W..1 W Li Cl Cl 0 N U N 2 OM C OU b4 "U •C • � °� � � � � � Q sue, N . CL . Q, � a O R. �. � 'C cci 7 � • C �. N U c3 o 0 3 N 3 Z Z Clo� q an 3 d E CL 5 E U u U ,� id v' +-s Q R. as �' > 's.. •s.; 64 > u+ U ai ti U Q C7 C7 o n "ate `o �tA U U tA � Q y n x F� w �r , N N— a, a hw> a w � xc7:"aaa ca u. c� Q wuw� a f \r- - < n y __a J00 \ \ \ \ / In / 2 @ % / / / j � y \ \ \ \ \ \ \ » 2 < g r / / g 2 % % a 2 _ \ c \ / 7 \ \ » } k 6 y \ /Ln Ln - <cq % � _ 00 \ \ ƒ m w y \ $ 00 \ \ \ 4 s Q & 5 u u ) a e ) � �\k / 4 j C'p\ / ) 0 \ \ \ [ ( 5 = / g 3 © \ Q _ § � J a \ / « � \ { � \ » � \ � / / \ 7 •e © s ® ° o e u § 2 & \ § \ © & # (�) \ / k R & } & a ) \ /) 4 ) = / 6 \ / § %- { y to/ '\ 3 /� \ e u 0 o= §- _ \ . t , , § U _ « u § £ & & £ E & _ » �.e « % .2 j 5 _ e 2 2 = a a ° 4 ( § / » » § \ § = e [ % S § 2 \ / R \ d § / u = » § 2 2 U w 0 2 4 z U § \ § a a a § § § Q= a 5 = 3 ©a 4 2 z 2 @ A 2 § 2 U 4= ( o o» @ u » t o , 0 0%» 4 Q 2 Q§ o\ z » CIS C o 0 o, bA .0 z C a- w EXPENSE DETAIL: PO # PO Date 749 7/112008 73110 71V/20p8 73109 7/V2008 71532 7142008 71531 7/1/2008 71529 7/1/2008 78533 7/8/2008 71536 7/11/2008 73118 7/29/2(M 71530 7/1/2008 71546 8/712M 71545 8/7/2008 71548 8111/1008 71549 W1.2/2008 73155 8AV2008 T1550 W12/2008 73156 8/18/2008 73157 8/18/2008 73158 8/18/2008 73162 ES/Zl/ZINRf 73163 8/29/2008 73164 9/4/2008 73166 9/9/2008 73173 9/16J2008 73167 9/912008 73170 9/10/2008 73171 9/11%20W 71538 7/21/2008 71510 5/22/2008 71544 814"2008 73169 9/10/2008 73205 9/15/2008 73157 9/17/2008 73175 9/27/2W8 Petty Cash 10/7/2008 71510 9/24/2008 73179 1W442008 73178 1W 2008 73186 1W/15/2008 73181 10/Q/2008 73183 10/14/2008 73180 10/4/2008 73187 IW2212M Petty Cash 111,V2008 73211 10/21/2008 731% 11/13/2008 73211 10,21/2008 73194 11/13/2008 73197 IV2W2008 73135 11/19/2008 73190 11/3/2008 73199 12/4/2008 71472 4%2008 73225 12/31/2008 73218 1 12A412 08 Paid Date Amount Vendor: 7/25/2008 $ 462.01 USA Bluebook 7/25/2008 $ 605.12 HD Supply 7/25/2008 $ 650.00 Mild Fence Co 7/28/2008 $ 287.65 Grainger 7/25/2008 $ 13.48 Kalispell Auto Parts 7/25/2008 $ 215.50 Park Lighting Suppl 8/11/2008 $ 7256 North Star Equipme 8/11/2008 $ 126.99 USA Bluebook 8/25/2008 $ 52.93 Murdock's 8/25/2(M $ (75.95) 1 USA Bluebook $ 467.28 1 Grainger $ 1,379.99 Mountain Controls Inc. $ 610.89 Kaman Bearings $ 473.04 Grainger $ 100.83 CED Electric $ 58.71 Applied Industrial Tech, Inc $ 314.17 14D Supply $ 56.20 USA Bluebook $ 88.40 MDM Supply $ 452.22 1 Grainger $ 142.65 MDM Supply $ 86.32 Mountain Controls Inc. $ 167.63 Grainger $ 107.47 Cardinal $ 56.98 North Star Equipment $ 8278 Johnstone Supply $ 40.23 McMaster -Carr $ 77.00 Johnstone Supply $ 350.00 Kalispell Electric $ 1,260.00 Kalispell Electric $ 95.76 CDW Government, Inc. $ 1,307.03 CEW Government Inc. $ (41.80) USA Bluebook $ 111.13 Grainger $ 6.40 Murdock's $ 90.00 Kalispell Electric $ 118.31 McMaster -Carr $ 123.06 Fastenal $ 12.99 Cardinal $ 31.40 Grainger $ 120.18 CED Electric $ 55.19 Fastenal $ 16.93 McMaster -Carr $ 21.07 WBC $ 370.50 Diversified Plastics Inc. $ 210.00 Montana Garage Door $ 504.00 Diversified Plastics Inc. $ 56.01 Les Schwab $ 9.50 Grainger $ 229.55 Power Services of MT $ 2,063.06 Diversified Plastics Inc. $ 51.75 Grainger $ 231.64 Ingersoll-Rand $ 488.40 Napa $ 30.96 Fastenal Pro & Sensaphone Card ants & Parts for new new Fuses, Race Way, U.PS. for press area Cal Filters for G.T. Ballasts & Lens Unloader assembly for pressure washer RAS sump floats Fittings for air hoses Return of CorePro Pleated Air Filters Actuator for Blower #3 BFP bearings Fuses for Air Compressor Fuses for Air Compressor Seals, loclmuts & washer 4" Mueller Gate Valve - NPW System Chain Wheel - NPW System 20' Galvin pipe -1 1/2" Parts to repair strainers on BrP P.V.0 supplies Blower Actuator repair 24 Power Supply - main P.L.0 Surge Protector & Electric Insect Killer Flow Switch - pressure washer Temp controller for Digester Building Couplers & elbows schedule 80 Aqua stat relay - main boiler Trouble shoot blower #1 Trouble shoot Lift Station Backup UPS & one belt UPS XL 3000 PLC & Computer backup Return of Chain Wheel Belts, bathroom fan & Moyno belts Mics. Fasteners Install Auxiliary Contacts on Blower #1 Stainless steel hangers - L.S. wet well. 3/4 x 3 bolts & nuts - Dig. Decant valves Weather Stripping - Digester building Parts for ups back up power Digester Gas Alarm light Lift Station floor drain hangers Fuses & 2004 KW knob Lamp, Faucet stuff UNMW Rail for the B.F.P. conveyer belt -leadworks door repair 3FP Scraper Blades (6) <ubota Tire Repair Cime delay relay - muffin monster Tunnels & a jet pump - fly tank equip,) sprockets & Shoes - Prim Clarifier. 'ressure relief valve, R.A.S. boiler filters - plant air compressor & supplies for old backhoe ,ton wear ring bolts 73222 12/22/2008 1/20/2009 $ 335.26 Grainger Sola 24v power supplies 73185 10/15/2008 1/20/2009 $ 45.36 MDM Supply Faucet cartridge of lab sink 73224 12/30/2008 1/20/2009 $ 206.78 Grainger Line reactor for new polymer pump 73228 1/21/2009 1/31/2009 $ 38.56 Murdock's Pipe fittings - Lift Station 74853 1/9/2009 1/31/2009 $ 17.48 Applied Industrial Tech, Inc Oil Seals - recirculation pump 74857 1/15/2009 1/31/2009 267.68 Grainger U.P.S. & light ballast- Dig Building 73229 1/21/2009 1/31/2009 82.05 McMaster -Carr Sight glass and electrical terminals - Boiler. 73229 2/4/2009 2/25/2009 217.58 Grainger Ball valves - main boiler replacement 73237 74VO09 2/25/2009 4800.00 Riebe's Machine Works Digester Mix Pump Wear Rings - 2 74852 12/29/2008 2/25/2009 2160.18 Kalispell Electric computer ends, poly VFD, terminal block, blower 73215 1211/2008 3/11/2009 240.64 Ingersoll-Rand Oil separator & air filter. 73246 2/13/2009 3/11/2009 74.98 Staples APC 550 battery backup - L.S. PLC. 73193 11/11/2008 3/11/2009 1422.50 Ingersoll-Rand Oil filters, Separator filters, & 5 gal oil. Petty Cash 2/17/2009 3/11/2009 36.76 Mics. Napa, Joe's Rad, Penco, & MDM 73227 1/19/2009 3/11/2009 70.00 K.E.I. Trouble shoot mixer #9 73247 2/17/2009 3/11/2009 2001.24 Water Control Corp. U.V. Bulbs 73231 1/27/2009 3/11/2009 11.18 Davis Pipe & Machinery Pipe fittings - Main boiler 73244 2/1WM09 3/11/2009 274.00 Grainger Sump pump & 8' slin 73242 2/11/2009 3/25/2009 270.18 MDM Supply Moen Lab faucets 73249 2/24/2009 3/25/2009 61.58 MDM Supply 2" check valves - dig, Sump pumps 73245 2/13/2009 3/25/2009 983.52 RPM Sales Blast Tube - main boiler 74901 2/2 O09 3/25/2009 201.32 Border States Electric N-Tron Ethernet switch - PLC 73232 1/28/2009 4/5/2009 280.00 Kalispell Electric Wire up 6" pump for bio-startup 74870 3/2/2009 4/10/2009 21.65 North Star Equipment Inlet filter assembly - pressure washer 74873 3/9/2009 4/10/2009 124.39 USA Bluebook Sludge judge 73241 2/9/2009 4/10/2009 215.34 HD Supply 6"x1 1/2 SS Saddles - Fenn sample ports 74876 3/12/2009 4/10/2009 80.80 Grain er Rubber cou ler sleeves - Supernatant pumps 74871 3/5/2009 4/10/2009 49.05 1 Grainger lHeadworks grease fittings 74872 3/9/2009 4/10/2009 203.09 Grainger 3" ball valve, water cannon - U.V. fuses 74874 3/11/2009 4/10/2009 101.38 Grainger Ball valves & nipples - Ferm. Sample port Pe Cash V25/2009 4/10/2009 110.64 Target, NAPA & Joe's Radiators Blender, Backhoe electrical, & Burner boil out 74981 3/17/2009 4/10/2009 145.46 Associated Bag Co. Headworks rags & grit bags 74903 2/26/2009 4/10/2009 14.99 Staples Surge Protector- Lift Station PLC 74878 3/16/2009 4/10/2009 35.00 Tire Rama Tire repair on the 2004 KW 74880 3/17/2009 4/10/2009 35.00 Tire Rama Tire repair on the 2001 KW 73250 2/24/2009 4/10/2009 $ 128.24 Pacific Steel Metal supply - barrel stands 74868 2/26/2009 4/10/2009 $ 34.86 Pacific Steel Metal supply - barrel stands 74953 4/9/2009 5/11/2009 1441.55 Water Works Industries Hardened impeller 74954 4/9/2009 5/11/2009 2178.90 Water Works Industries Hardened wear rings (2) 74896 4/14/2009 5/11/2009 594.00 Grain er RASSum Pump 74897 4/14/2009 5/11/2009 20.61 Grainger 4" PVC male adapter - supernatant 74891 3/31/2009 5/11/2009 50.00 Curriers Welding Weld G.T. scum arm 74973 4/14/2009 5/25/2009 3748.72 Endress Hauser/Brock Easley Flow Meter - east D.A.F. 74960 4/28/2009 5/25/2009 241.95 Grainger N.P.W. pump install - pipe fittings 74894 4/7/2009 5/25/2009 910.72 HD Supply 6" DeZurik Valve - digested sludge line replace. 74963 4/29/2009 5/25/2009 127.00 Grainger Mini lamps & roto water meter. 74964 4/29/2009 5/25/2009 61.92 Grainger Backflow preventer repair Mt. 74966 SVV2009 5/25/2009 32.72 Grainger Pressure Washer handle 74968 5/6)2009 5/25/2009 115.93 Grainger Boiler feed valve, piping fittings, toilet repair 74898 4/16/2009 6/11/2009 1582.80 Midland Implement Co. New NPW pump replacement 74970 5/14/2009 6/11/2009 109.22 McMaster -Carr Pump packing - Digester Mix #2 Petty Cash 5/27/2009 6/11/2009 6.23 Cardinal Gasket rope 74972 5/19/2009 6/11/2009 188.54 Grainger Plumbing of headworks backflow preventer 74975 5/19/2009 6/11/2009 133.90 Grainger Primary Sludge pump belts 74971 5/14/2009 6/25/2009 241.82 Fastenal Stainless screws - digester mix pump #2 74979 5/27/2009 6/25/2009 503.30 USA Bluebook Sludge judge 75013 6/19/2009 7/10/2009 68.97 Northwest Pipe Fittin s, Inc. NPW hydrant repair 74988 6/15/2009 7/10/2009 253.82 Grainger Old Fermenter roof drain repair material 75014 6AW009 7/10/2009 192.96 Murdock's Replacement sump pump 74996 6AW009 7/10/2009 29.50 Les Schwab Tire repair - 2004 Kenworth 74961 4/29/2009 7/10/2009 750.00 Riebe's Machine Works Slide Gate - cell #11 74904 2/20/2009 7/10/2009 220.00 Riebe's Machine Works Primary Clarifier shear pins 74997 6/26/2009 7/10/2009 29.50 Les Schwab Tire Repair - 2001 Kenworth 74991 6/17/2009 7/10/2009 140.98 HD Supply Drilled flanges - non potabel replacement 74987 6/30/2009 7/27/2009 693.55 Polland Water Portable Sludge Interface 74890 3/31/2009 7/27/2009 620.23 Ingersoll-Rand Oil seperator filters (3) & coolant filters (2) 74956 4/21/2009 7/27/2009 208.58 Pacific Steel Aluminum slide gate - cell #11 EXPENDITURE DETAIL: FY09 WWTP REPLACEMENT FUND 6310-466-430646-940 P.O. # Date Vendor Item Description REPLACE BELT FILTER PRESS CONVEYOR BELT PANS 74974 4/16/2009 Serpentex Corporation Serpentex belt pans REPLACE DIGESTER BUILDING WASTE GAS BURNER 74863 2/6/2009 Universal Combustion REPLACE EXISTING BIOREACTOR SLIDE GATES 74936 6/8/2009 Waco Products, Inc. REPLACE SUPERNATENT PUMP IMPELLER AND CONE 75019 6/18/2009 Goble Sampson Inc. Waste gas burner Slide gates for existing bioreactor Impeller and cone GRAND TOTAL Amount $ 12,090.05 7,425.00 10,031.00 4,405.00 $ 33,951.05 UND: gb702-kl ACCOUNT NUMBER SEWER FUND ACCOUNT TITLE CITY OF KALISPELL MONTH: 6 Page 1 G/L TRIAL BALANCE FISCAL YR: 2009 rgw BAL FWRD YTD DEBITS YTD CREDITS YTD BALANCE ------------------------------------------------------------------------------------------------------------------------------------ 5310-000-010100-000 CASH, SEWER & WWTP OPERATIONS 2,098,067.17 14,668,855.24 15,015,095.00- 1,751,827.41 5310-000-010103-000 CASH, PETTY CASH-WWTP 150.00 .00 .00 150.00 5310-000-010123-000 CASH, IMPACT FEES -SANITARY SEWER 1,988,945.16 290,946.68 218,566.85- 2,061,324.99 5310-000-010124-000 CASH, IMPACT FEES - WWTP 3,418,893.73 6,083,474.20 8,809,640.83- 692,727.10 5310-000-010125-000 CASH, CITY/EVERGREEN-WWTP 747,282.87 956,753.41 1,316,687.66- 387,348.62 5310-000-010126-000 CASH, SEWER R&D 218,863.93 100,000.00 126,144.78- 192,719.15 5310-000-010130-000 CASH, BOND RESERVE 630,260.00 .00 .00 630,260.00 5310-000-010131-000 CASH, BOND RESERVE WWTP -restricted 802,787.68 310,038.07 371,923.75- 740,902.00 5310-000-010135-000 CASH, OPERATING RESERVE 213,000.00 .00 .00 213,000.00 5310-000-010192-000 CASH, 1992 SRF S & I 4.0o WWTP 648.04 285,140.04 285,140.00- 648.06 5310-000-012200-000 ACCOUNTS RECEIVABLE 254,831.93 3,747,233.31 3,751,133.44- 250,931.80 5310-000-012210-000 SUNDRY ACCTS RECEIVABLE .00 3,619.35 .00 3,619.35 5310-000-012300-000 ALLOW. FOR UNCOL. ACCTS. 17,109.01- 8,564.70 35.00- 8,579.31- 5310-000-013293-000 DUE FROM DNRC 2,302,154.00 .00 2,302,154.00- .00 5310-000-018100-000 LAND 221,512.67 .00 .00 221,512.67 5310-000-018600-000 EQUIPMENT, WWTP 494,425.35 .00 .00 494,425.35 5310-000-018601-000 ALLOWANCE FOR DEPR-EQUIP 357,513.76- .00 .00 357,513.76- 5310-000-018802-000 PLANT EXPANSION-CONSTR IN PROGRESS 14.204.352.58 .00 .nn 14.2n4_11;9 SR 5310-000-018930-000 TREATMENT PLANT 15,645,252.20 .00 .00 15,645,252.20 5310-000-018931-000 ALLOWANCE FOR DEPR-WWTP 12,283,094.45- .00 .00 12,283,094.45- 5310-000-018940-000 TRANSMISSION & DISTRIB. 22,903,312.02 .00 .00 22,903,312.02 5310-000-018941-000 ALLOW DEPR TRANS & DIST, 4,953,311.41- .00 .00 4,953,311.41- 5310-000-018950-000 GENERAL PLANT, SWR 1,024,837.91 .00 .00 1,024,837.91 5310-000-018951-000 ALLOW DEPR GENERAL PLANT 780,712.01- .00 .00 780,712.01- ** SUB -TOTALS FOR TYPE: A 48,777,836.60 27,170,919.40 32,912,815.71- 43,035,940.29 5310-000-020200-000 ACCOUNTS PAYABLE 2,740,591.73- 18,202,960.35 15,999,660.31- 537,291.69- 5310-000-020620-000 payroll payable 23,558.37- 583,492.89 587,133.52- 27,199.00- 5310-000-021249-000 DUE CONTRACTOR-RETAINAGE 583,682.48- 410,736.49 285,337.40- 458,283.39- 5310-000-023102-000 2002 BONDS PAYABLE 665,000.00- 215,000.00 .00 450,000.00- 5310-000-023121-000 SRF LOAN PAYABLE 4$ WWTP 1,163,000.00- 241,000.00 .00 922,000.00- 5310-000-023193-000 SRF LOAN PAYABLE (Hwy 93 So.) 1,257,000.00- 58,000.00 .00 1,199,000.00- 5310-000-023197-000 2007 SRF 08164 LOAN PAY-WWTP 3.750 10,216,713.00- 212,000.00 3,903,287.00- 13,908,000.00- 5310-000-023900-000 COMPENSATED ABSENCES PAY. 104,843.49- .00 20,468.56- 125,312.05- ** SUB -TOTALS FOR TYPE: L 16,754,389.07- 21,571,098.24 22,443,795.30- 17,627,086.13- 5310-000-025230-000 RESERVE BOND CONTINGENCY 1,433,047.68- .00 .00 1,433,047.68- 5310-000-025235-000 RESERVE OPER. CONTINGENCY 213,000.00- .00 .00 213,000.00- 5310-000-025300-000 RESERVE FOR R&D SEWER 218,863.93- .00 .00 218,863.93- 5310-000-025325-000 RESERVE FOR R & D/EVERGREEN 747,282.87- .00 .00 747,282.87- 5310-000-025355-000 RESERVE SANITARY IMPACT FEES 1,988,945.16- .00 .00 1,988,945.16- 5310-000-025356-000 RESERVE WWTP IMPACT FEES 3,418,893.73- .00 .00 3,418,893.73- 5310-000-027200-000 RETAINED EARNINGS 24,003,414.16- .00 .00 24,003,414.16- ** SUB -TOTALS FOR TYPE: Q 32,023,447.53- .00 .00 32,023,447.53- 5310-000-343310-000 SEWER SERVICE CHARGES .00 353,704.37 3,738,810.90- 3,385,106.53- 5310-000-343330-000 IMPACT FEES (SANITARY) .00 .00 166,279.59- 166,279.59- 5310-000-343335-000 IMPACT FEES (WWTP) .00 .00 206,377.64- 206,377.64- 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER .00 .00 1,287.54- 1,287.54- 5310-000-371010-000 INVESTMENT EARNINGS .00 23,721.45 299,006.01- 275,284.56- O8/07/09 11:54.19 FUND: CITY OF KALISPELL MONTH: 6 Page 2 gb702-kl SEWER FUND G/L TRIAL BALANCE FISCAL YR: 2009 rgw ACCOUNT NUMBER ------------------------------------------------------------------------------------------------------------------------------------ ACCOUNT TITLE BAL FWRD YTD DEBITS YTD CREDITS YTD BALANCE - SUB -TOTALS FOR TYPE: R .00 377,884.18 4,412,220.04- 4,034,335.86- 5310-454-430620-110 SALARIES -SEWER BILLING .00 90,111.40 1,971.24- 88,140.16 5310-454-430620-153 HEALTH INSURANCE .00 22,485.36 .00 22,485.36 5310-454-430620-155 RETIREMENT .00 5,624.64 124.54- 5,500.10 5310-454-430620-218 COMPUTERS/SUPPLIES .00 1,289.64 .00 1,289.64 5310-454-430620-335 MEMBERSHIP & DUES .00 257.50 .00 257.50 5310-454-430620-353 AUDITING .00 1,500.00 .00 1,500.00 5310-454-430620-354 CONTRACT SERVICES .00 7,087.05 .00 7,087.05 5310-454-430620-355 BILLING COSTS .00 25,710.25 .00 25,710.25 5310-454-430620-373 SCHOOL & TRAVEL .00 1,115.00 62.50- 1,052.50 5310-454-430620-522 ADMINISTRATIVE TRANSFER .00 6,508.74 .00 6,508.74 5310-454-430620-528 DATA PROCESSING TRANSFER .00 21,196.08 .00 21,196.08 5310-454-430620-532 OFFICE RENT .00 5,500.00 .00 5,500.00 5310-454-430630-110 SALARIES -SANITARY SEWER .00 355,613.25 7,825.36- 347,787.89 5310-454-430630-121 OVERTIME .00 7,193.50 42.75- 7,150.75 5310-454-430630-153 HEALTH INSURANCE .00 68,094.23 3,233.96- 64,860.27 5310-454-430630-155 RETIREMENT _00 2S_,AF2 n9 aan 7n- 5310-454-430630-210 OFFICE SUPPLIES .00 323.98 .00 323.98 5310-454-430630-213 SMALL OFFICE EQUIPMENT .00 158.33 .00 158.33 5310-454-430630-214 GIS SUPPLIES .00 2,164.76 .00 2,164.76 5310-454-430630-215 COMPUTER SUPPLIES .00 2,020.01 .00 2,020.01 5310-454-430630-216 COMPUTER EQUIPMEMT .00 630.00 .00 630.00 5310-454-430630-218 EQUIPMENT (NON CAPITAL) .00 800.67 .00 800.67 5310-454-430630-221 SAFETY EQUIP & SUPPLIES .00 1,135.79 .00 1,135.79 5310-454-430630-224 JANITORIAL SUPPLIES .00 734.81 .00 734.81 5310-454-430630-229 OTHER SUPPLIES .00 599.12 .00 599.12 5310-454-430630-231 GAS & OIL .00 9,109.93 .00 9,109.93 5310-454-430630-241 CONSUMABLE TOOLS .00 1,330.55 .00 1,330.55 5310-454-430630-312 POSTAGE .00 611.66 .00 611.66 5310-454-430630-320 PRINTING .00 105.00 .00 105.00 5310-454-430630-336 LICENSES & FEES .00 560.00 .00 560.00 5310-454-430630-341 ELECTRICITY .00 37,215.88 .00 37,215.88 5310-454-430630-342 WATER .00 131.92 .00 131.92 5310-454-430630-344 NATURAL GAS .00 14,066.48 762.37- 13,304.11 5310-454-430630-345 TELEPHONE & COMMUNICATION .00 20,965.49 .00 20,965.49 5310-454-430630-353 AUDITING .00 2,000.00 .00 2,000.00 5310-454-430630-354 CONTRACT SERVICES .00 24,570.98 5.76- 24,565.22 5310-454-430630-356 CONSULTANTS .00 9,018.21 .00 9,018.21 5310-454-430630-358 IMPACT FEE REVIEW .00 4,512.18 .00 4,512.18 5310-454-430630-362 EQUIPMENT MAINTENANCE .00 5,813.06 .00 5,813.06 5310-454-430630-366 BUILDING MAINTENANCE .00 451.79 .00 451.79 5310-454-430630-369 RADIO EQUIPMENT & MAINT. .00 270.00 .00 270.00 5310-454-430630-373 SCHOOL & TRAVEL .00 1,602.96 .00 1,602.96 5310-454-430630-388 MEDICAL SERVICES .00 806.00 .00 806.00 5310-454-430630-410 CONSTRUCTION MATERIALS .00 5,746.47 .00 5,746.47 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. .00 13,433.18 .00 13,433.18 5310-454-430630-510 PROPERTY & LIABILITY INS. .00 15,726.00 .00 15,726.00 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE .00 48,727.45 .00 48,727.45 5310-454-430630-521 CENTRAL GARAGE TRANSFER .00 2,499.96 .00 2,499.96 O8/07/09 11:54:19 FUND: gb702-kl SEWER FUND ACCOUNT NUMBER ACCOUNT TITLE CITY OF KALISPELL MONTH: 6 Page 3 G/L TRIAL BALANCE FISCAL YR: 2009 rgw DAL FWRD YTD DEBITS YTD CREDITS YTD BALANCE ------------------------------------------------------------------------------------------------------------------------------------ 5310-454-430630-522 ADMINISTRATIVE TRANSFER .00 50,110.26 .00 50,110.26 5310-454-430630-528 DATA PROCESSING TRANSFER .00 13,497.72 .00 13,497.72 5310-454-430630-532 OFFICE RENT .00 6,275.00 .00 6,275.00 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK .00 20,003.17 .00 20,003.17 5310-454-430630-810 BAD DEBT EXPENSE .00 .00 8.12- 8.12- 5310-454-430630-940 MACHINERY & EQUIPMENT .00 18,510.50 .00 18,510.50 5310-454-430633-940 MACHINERY & EQUIPMENT .00 121,677.97 44.27- 121,633.70 5310-454-430633-944 VEHICLES .00 4,511.08 .00 4,511.08 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE .00 49,168.09 .00 49,168.09 5310-454-430635-957 GRANDVIEW PUMP STA/GRAVITY MAIN 520 .00 74,396.08 .00 74,396.08 5310-454-490204-620 INTEREST-2004 BONDS .00 46,612.50 .00 46,612.50 5310-455-430640-110 SALARIES-WWTP .00 407,103.43 11,588.90- 395,514.53 5310-455-430640-121 OVERTIME .00 21,695.81 792.58- 20,903.23 5310-455-430640-153 HEALTH INSURANCE .00 73,599.69 8,685.69- 64,914.00 5310-455-430640-155 RETIREMENT .00 25,288.35 764.13- 24,524.22 5310-455-430640-210 OFFICE SUPPLIES .00 917.07 .00 917.07 5310-455-430640-213 SMALL OFFICE EQUIPMENT .00 154.82 .00 154.82 5310-455-430640-215 COMPUTER SUPPLIES .00 739.95 nn 5310-455-430640-216 COMPUTER EQUIPMEMT .00 2,142.87 .00 2,142.87 5310-455-430640-221 SAFETY EQUIP & SUPPLIES .00 1,551.60 .00 1,551.60 5310-455-430640-222 LABORATORY SUPPLIES .00 3,235.69 1,607.73- 1,627.96 5310-455-430640-224 JANITORIAL SUPPLIES .00 205.42 .00 205.42 5310-455-430640-225 ALUM .00 38,256.99 .00 38,256.99 5310-455-430640-226 CHLORINE & CHEMICALS .00 9,064.44 .00 9,064.44 5310-455-430640-229 OTHER SUPPLIES .00 7,043.30 579.47- 6,463.83 5310-455-430640-231 GAS & OIL .00 7,889.10 .00 7,889.10 5310-455-430640-241 CONSUMABLE TOOLS .00 4,800.06 41.98- 4,758.08 5310-455-430640-312 POSTAGE .00 827.73 .00 827.73 5310-455-430640-335 MEMBERSHIP & DUES .00 1,388.00 .00 1,388.00 5310-455-430640-336 LICENSES & FEES .00 5,514.00 .00 5,514.00 5310-455-430640-341 ELECTRICITY .00 201,688.40 10,921.25- 190,767.15 5310-455-430640-342 WATER .00 6,564.45 .00 6,564.45 5310-455-430640-344 NATURAL GAS .00 53,275.77 736.77- 52,539.00 5310-455-430640-345 TELEPHONE & COMMUNICATION .00 5,907.66 .00 5,907.66 5310-455-430640-353 AUDITING .00 2,750.00 .00 2,750.00 5310-455-430640-354 CONTRACT -GLACIER GOLD .00 120,550.27 .00 120,550.27 5310-455-430640-355 OTHER CONTRACT SERVICES .00 34,892.77 .00 34,892.77 5310-455-430640-356 CONSULTANTS .00 18,065.90 .00 18,065.90 5310-455-430640-358 CONSULTANT-TMDL .00 3,140.41 .00 3,140.41 5310-455-430640-360 REPAIR & MAINT SERVICES .00 16,907.85 .00 16,907.85 5310-455-430640-361 MAINT.-DIGESTER CLEAN/INSPECT .00 13,347.51 .00 13,347.51 5310-455-430640-366 BUILDING MAINTENANCE .00 2,225.00 .00 2,225.00 5310-455-430640-373 SCHOOL & TRAVEL .00 13,145.00 .00 13,145.00 5310-455-430640-380 TRAINING MATERIALS .00 164.95 .00 164.95 5310-455-430640-388 MEDICAL SERVICES .00 609.50 .00 609.50 5310-455-430640-510 PROPERTY & LIABILITY INS. .00 43,409.00 .00 43,409.00 5310-455-430640-521 CENTRAL GARAGE TRANSFER .00 3,500.04 .00 3,500.04 5310-455-430640-522 ADMINISTRATIVE TRANSFER .00 93,013.68 .00 93,013.68 5310-455-430640-528 DATA PROCESSING TRANSFER .00 18,196.68 .00 18,196.68 5310-455-430640-940 MACHINERY & EQUIPMENT .00 959.73 .00 959.73 O2/07/09 11:54:19 FUND: CITY OF KALISPELL MONTH: 6 Page 4 gb702-kl SEWER FUND G/L TRIAL BALANCE FISCAL YR: 2009 rgw ACCOUNT NUMBER ------------------------------------------------------------------------------------------------------------------------------------ ACCOUNT TITLE BAL FWRD YTD DEBITS YTD CREDITS YTD BALANCE 5310-455-430644-933 WWTP CONSTRUCTION -IMPACT FEES .00 2,825,054.54 43,341.24- 2,781,713.30 5310-455-430644-934 BOND CONSTRUCT ACCOUNT less reserve .00 4,018,748.90 115,461.90- 3,903,287.00 5310-455-430644-935 WWTP- REPLACEMENT (10125) .00 687,795.00 .00 687,795.00 5310-455-430645-362 EQUIPMENT MAINTENANCE .00 48,219.80 1,856.56- 46,363.24 5310-455-430645-940 MACHINERY & EQUIPMENT .00 33,951.05 .00 33,951.05 5310-455-430646-110 SALARIES .00 119,962.89 .00 119,962.89 5310-455-430646-153 HEALTH INSURANCE .00 17,702.28 .00 17,702.28 5310-455-430646-155 RETIREMENT .00 7,660.33 .00 7,660.33 5310-455-430646-216 COMPUTER EQUIPMENT .00 304.00 .00 304.00 5310-455-430646-222 LAB SUPPLIES .00 2,391.94 .00 2,391.94 5310-455-430646-225 OTHER SUPPLIES .00 43.00 .00 43.00 5310-455-430646-336 LICENSES & FEES .00 280.00 .00 280.00 5310-455-430646-349 LAB SERVICES .00 14,621.50 .00 14,621.50 5310-455-430646-362 EQUIPMENT MAINTENANCE .00 1,960.65 173.63- 1,787.02 5310-455-430646-373 SCHOOL & TRAVEL .00 1,847.12 .00 1,847.12 5310-455-490210-620 DEBT-2002 INTEREST .00 26,507.50 .00 26,507.50 5310-455-490210-630 FISCAL AGENT FEES-2002 BONDS .00 600,00 .00 600.00 5310-455-490215-620 DEBT SRF 92003-INTEREST _nn 44.14n.nn nn as ian nn 5310-455-490227-620 SRF 2007WWTP INTEREST .00 674,356.87 207,091.27- 467,265.60 ** SUB -TOTALS FOR TYPE: X .00 11,169,721.21 520,791.98- 10,648,929.23 **** FUND TOTAL **** .00 60,289,623.03 60,289,623.03- .00