Loading...
3. Evergreen Sewer District Rate for FY 2012-2013City of Kalispell Post Office Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758-7000 Fax - (406) 758-7758 REPORT TO: Doug Russell, City Manager�2— FROM: Rick Wills, Finance Director SUBJECT: Evergreen Sewer Rate for Fiscal Year 2012/2013 MEETING DATE: September 17, 2012 BACKGROUND: Please find attached several sheets of information. This compilation is for the City of Kalispell Wastewater Treatment Plant (WWTP) 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 2012. The WWTP operating expenses decreased about 3% from the prior year. FY2011 expenses are included for comparison. Evergreen Sewer District's FY2013 rate is based on our operational expenses for FY2012 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 6.94%, while the total plant usage is down 13.47%. As a result, Evergreen's share of the total flows has increased from 16.12% to 17.34%. This is not a percent of capacity only a percent of flows treated at the plant. The percent of usage (17.34%) 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.67 (up $0.19 from FY2012) per thousand and is the new rate for FY2013. Due to the expansion of the plant, beginning in FYI the district pays 12% of the debt service costs regardless of the usage. The Evergreen debt service expense for FYI is $10,973.38 per month, down from $12,467.35 for FYI 2. The current 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 $9,301.36 in 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 $246,981.28. RECOMMENDATION: It is recommended that the City Council move to adopt $1.67 per thousand gallons and $10,973.38 per month as the FY2013 Evergreen Sewer District's sewage treatment rate and d service charge. Rick Wills Finance Director Report compiled: August 29, 2012 2012 WWTP... FISCAL YEAR 2012 Prepared: 8/28/12 City Finance Office Wages/fica/medt/wc/unemp. $ 440,701.00 Overtime $ 18,522.00 Health Ins. $ 74,964.00 PERD $ 28,673.00 Supplies & equipment $ 13,454.00 Non -capital equipment $ 1,696.00 Lab supplies $ 7,940.00 Alum $ 3,283.00 Chemicals $ 9,717.00 Gas & Oil $ 14,731.00 Postage & freight $ 298.00 Licenses & fees $ 7,325.00 Electricity $ 158,225.00 Water $ 5,603.00 Natural Gas $ 50,405.00 phone lease/charges/pagers/alarms $ 4,851.00 Auditing $ 2,750.00 Contract Serv-Glacier Gold $ 114,009.00 Other Contract Sery $ 42,560.00 Consultants $ 5,820.00 Misc. Maintenance $ 20,543.00 School & Training $ 6,235.00 Medical services/drug testing $ 196.00 Property & Liability Ins. $ 41,680.00 Central Garage $ 4,000.00 Admin. Transfer $ 122,598.00 Data Processing $ 18,705.00 Total Operating Expenses $ 1,219,484.00 x 0.1734 $ 211,408.19 $ 1.248 per thousand gallons Replacement $ 411,598.48 x 0.1734 $ 71,354.19 $ 0.421 per thousand gallons Annual cost to Evergreen $ 282,762.37 $ 1.67 per thousand gallons Debt service / Evergreen 12% $ 131,680.56 annual $ 10,973.38 per month Evergreen Flows 169,423,477 17.34% Total Kalispell Flows 977,300,000 2011 WWTP... FISCAL YEAR 2011 Prepared: 7/25/11 City Finance Office Wages/fica/medt/wc/unemp. $ 451,559.00 Overtime $ 20,292.00 Health Ins. $ 73,462.00 PERD $ 30,203.00 Supplies & equipment $ 13,461.00 Non -capital equipment $ 7,920.00 Lab supplies $ 7,347.00 Alum $ 15,368.00 Chemicals $ 14,659.00 Gas & Oil $ 10,527.00 Postage & freight $ 772.00 Licenses & fees $ 6,646.00 Electricity $ 159,496.00 Water $ 5,475.00 Natural Gas $ 52,717.00 phone lease/charges/pagers/alarms $ 4,292.00 Auditing $ 2,750.00 Contract Serv-Glacier Gold $ 106,814.00 Other Contract Sery $ 49,047.00 Consultants $ 19,609.00 Misc. Maintenance $ 18,145.00 School & Training $ 10,339.00 Medical services/drug testing $ 806.00 Property & Liability Ins. $ 51,379.00 Central Garage $ 3,500.00 Admin. Transfer $ 105,424.00 Data Processing $ 18,705.00 Total Operating Expenses $ 1,260,714.00 x 0.1612 $ 203,237.07 $ 1.116 per thousand gallons Replacement $ 411,598.48 x 0.1612 $ 66,352.93 $ 0.364 per thousand gallons Annual cost to Evergreen $ 269,590.01 $ 1.48 per thousand gallons Debt service / Evergreen 12% $ 149,608.20 annual $ 12,467.35 per month Evergreen Flows 182,065,477 16.12% Total Kalispell Flows 1,129,383,000 0 ZO 0") a. C, C�l CD CD 0 C> 0 0 C� 0 0 CD C) 0 (D (D a CD 0 5 0 a (D a Q a 00 6 c, a 0 06 a 6 a 0 r -0 f- - CD CV) - (D M - to LO - Lf) to - CO I�r -- 147 I- (6 (D �z co 1-: C"4 V7 0) If) 0) a. a) LO lzr (D LO 00 LO to t-- CD 0) Lf) 0; vi (6 W "i (D 1-: r-- W L6 W (L 0 LL O (sa 0 C, CD (Q C) C, (q C) C) (Q C> 0 (Q CD a (Q C) 0 (Q 0 CD Iq C) CD (C� C) C> (Q C:) a (Q C) C) (Q O 0 (q a CD co it - Mil- W M o"T Iq M M '44' Looll- 0 IT 0 V'N - N ITM 0 6) V: cr� to C Ci LQ llz� cl� C\� (q (C cl� 0) a) (D (=> O 0 03 ";r (Ompp- to (D M 00 M (D -moo (0 CN 0) -m c5 00 "ZI: V: 6 v! 0 (1Z 00 1"., r", b oc� o G! 0 c'! 0- Ct - - 0 - - - - - - - - - - - - ----- ----- 4> 0 O 0) a. (D a U- > LU NN LO Q) - O LL m U> CD a C> C) C) a C> CD 0 C) CD 0 a CD 19 4) 0 a 0 r-� c, C'! CD V� 0 cc� CD C� C) '4! 0 tQ c, Cl! 0 r,� c, r,� c, C'! o C:) C) r r LO 'It CO C) M �; LO ;: (D 0) C*4 M CD (D v (D CD C14 (Q 0) cc� co C'! t- LQ C� 0 C"! r- 0) (Q 'IT t-� cl) t'-� 00 LQ C'! r, 00 4) (D , �; . �! V - Z: ;: �! �! t� Z� - V: a) a 21 C\j C: co a. > -2 LL o cu (D 4> 0 C) 0 cl� 0 0 C\� C, C) Oi CD a N C, C) (Q 0 0 ll;� C) 0 Vi C. 0 cc CD C) lq: C, a (Q 0 a p 0 C) C, q 00 (D fl- CD N r- 00 LO 'IT Cli rl- Ci Cli M a) LOCO > - N i-I 'T C'I ;r C,� q (Q 00 t- r-- T't 0) C'4 ;: cli W ui --I -� V: C\! D) (D 41 ct C"! C� (D N It LO to M M CD N IT U'j 1- .2 (D NC-4 co o I- rl- 00 co co co 00 0 .0 — C\l 04 N C\1 C4 C14 04 CD 0 0 0 0 0 0 0 0 0 0 0 0 C: Q Q < C, LU Z �-- 7 - z z z C-0 N C, C14 I- CO M N M It LO (D I- CL > Eu ui L U- wl� z w o 0 0 0 o a o 0 0 0 o 0 0 0 0 0 0 0 W rA , r O 01 N U1 d' N N M h O h N 01 h � --� iD � M M � N h d' V' N ^t w rr tt h oo oo a� O Oti 01 0\ c� oN c� h oo N C1 M N O\ M N h '-+ 00 N w M 10 00 Q\ .�-� N �O 00 M 00 7 h M O N 0) It — 'It Q\ �c h h M O 00 .- N Cl 00 Ch N N t- r- N W r- O M N t- �o 2 O <t t 0) C� O �O �c �t Cl h v) et h O r-ct M M a0 C h M h 0o C h <t - 41 � N M C) dl w w M M h a, 01 '0 v) O et 00 C rt N h 'o 69 00 00 7 N M 6s 7 �-^ W W) 'n �t 64 69 69 69 64 69 G9 69 EA 69 64 M 64 6s rA N a 6� 69 W W W 0 0 0 0 o 0 0 o 0 0 0 0 0 0 0 0 0 0 o O O O O O h 00 M v1 � N rt rn o0 00 h h O1 d, D D` V• O O O O O � 0 W M V Q1 � M 00 0) [- h 1D O C, C, .-• o ,-• M v'� O O N O 3 oo O h N N N N O Oo V M h D CCN O o " ey M EA 69 69 6s 66 w 0 x a O O M N M 00 M O) v) N 00 M W O O NM M ol N N <t 00 <t V� h �- [� �a �C .-� M h Q W O O \0 N O 6 0- N N M oo O D N 00 C:,�o 0) z U O O 00 00 r-00 N 00 C) ON W) V M �o 00 �t t- G� r,- p 00 M h GO h M N M 0) N oo O O 00 h v1 C\ t- 0) N 00 r- Cl)7 h r-00 y CN us V) W) O M N 00 7 7 M Q1 N �o h .- 7 00 N 10 10 U f< ^. 00 '-•� O et o0 .- N V) W) -,rh r-M M '0 O) G ^ N eV N N N 6H 64 69 6R y ,>. GQ 69 69 69 69 ss 69 6s 6s 66 I�s L4 U y i N N hCyl 00 O --I'M N h r-C> O h 7 W) O O � y �_ Op U M o N th N N 7 W) W C1 oo O) M_ a, 00 r-h Op U 00 C) O M N 'C 0, O 00 r-O 'o C) C 2 7 M 00 N M N C O (0 0� rt -- N h Vr E U ~N U U O) Vi ^t M C1 a1 7 00 r N W . J W W O) M 7 M� 00 00 '^yam U Q. RS to = bA U c 0 J 69 6s 69 64 64 fA 69 6H 65 69 66 66 6s rA 69 b l Cl)m o 0 0 a a Z3 O .0 a T Y O O O M 00 et � hcM Ot O O N O M O M M U i ti 0-D ZO o00 - MM o�� n�v o�C�W)CD io tea, -o o O O O h 'ct '0 N M 'Zt , O N N t- C) M O O) Cl C) , H O O O 00 h O <t h h <t - t� 00 y V) M ON L0. U Q O O O Mn ,-• 7 V) h [� O t- W) M 10 oo W) 00 CDO1 O 6' 0. U Rt Q O O O M <t O r- M t- m '^ t- t- 00 N O N �t N N U U Lam' "C; M d' rt rt et p U L1 C U s5 MV?- 64 GIs � � (A �- "q 6M4 66 r s 6s 66 69 ss 69 6s 6s Q 6s rA 64 4r. Qp1 w cn 10 h w 0) O a1 C) O) 0� O O o 0 C) C) 0 0 0 0 ,.._, C, c, C1 0, O O O O O O o 0 0 0 6 0 0 Q ^^^ N N N N N N N N N N N N N O O O o O O O O O O O O O O O O 10 10 �o �o 10 10 10 10 10 �C �o �a 10 \C