|
<br />Monthly Split Report for Activity during:Dec-09
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />BILLING
<br />WWMWMC'sMWMC's
<br />RateBasicBasic ChargesTotalAmount billedFY08 Flow RatesKgals billedCityCityMWMCDouble
<br />Code# Accounts(per acct) ChgBilledBilled Amtfor Flow (MWMC + City)this monthRate per KgalRevenueRevenueCheckStormwater Monthly Info
<br />St WTOTAL BILLED
<br />from EWEB reportfrom rate sched= Accts * Basic Chgfrom EWEB report=Tot Billed - Basic Billedfrom rate sched=Amt billed for flow/ratefrom rate sched=WW Flow * City Rate=Flow Billed-City
<br />Rev
<br />RSWM 53,171 $9.98$530,646.58$ 1,445,544.25$914,897.67$ 3.682 248,478$1.696$421,419.46$493,478.21 Code# OF ACCTSAMOUNT
<br />RDSM 1,090$9.98$10,878.20$ 41,261.21$30,383.01$ 3.682 8,252$1.696$13,995.00$16,388.01
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,696$9.98$46,866.08$ 749,820.58 $702,954.50$ 4.365 161,043$1.696$273,129.63$429,824.87 STRO3,459$22,773.18
<br />GSMM 67$9.98$668.66$ 44,021.64$43,352.98$ 5.586 7,761$1.696$13,162.67$30,190.31 STR61$6.28
<br />GSHM 138$9.98$1,377.24$ 72,439.53$71,062.29$ 7.216 9,848$1.696$16,702.00$54,360.29 STR713$55.77
<br />VHSM 236$9.98$2,355.28$ 86,194.14$83,838.86$ 8.849 9,474$1.696$16,068.56$67,770.30STR81$3.79
<br />SHSM 15$9.98$149.70$ 37,482.09$37,332.39$ 10.480 3,562$1.696$6,041.58$31,290.81 STR995$167.12
<br />GSLH - $9.98$0.00$ -$0.00$ 4.365 0$1.696$0.00$0.00 STR136,393$352,277.89
<br />FSWR 50$9.98$499.00$ 1,555.76$1,056.76$ 3.682 287$1.696$486.76$570.00 ST1025$211.97
<br />FSW2 1 $9.98$9.98$ 12,859.56$12,849.58$ 4.365 2,944$1.696$4,992.64$7,856.94 STR4992$5,643.26
<br />MSWR 2 $9.98$19.96$ 2,082.24$2,062.28$ 4.365 472$1.696$801.29$1,260.99 ST1130$137.00
<br />SMLM 2 $9.98$19.96$ 1,076.29$1,056.33$ 4.365 242$1.696$410.43$645.90 STR5681$1,183.50
<br />Tot WW59,468$593,490.64$2,494,337.29$1,900,846.65452,364$767,210.02$1,133,636.63STR2568$7,326.30
<br />OKOK$593,490.64ST120$0.00
<br />$1,727,127.27ST135$40.80
<br />Dec 2008 had a mid lear rate increase on regional only.
<br />ST142$14.32
<br />ST151$3.17
<br />STR3383$7,277.86
<br />ST161$17.63
<br />ST175$56.05
<br />ST180$0.00
<br />Summary for
<br />ST195$15.85
<br />ST2013$106.08
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST210$0.00
<br />MWMC TOTAL$1,727,127.2748.93%%Op:%Cap:ST220$0.00
<br />double check:
<br />LOCAL WW$767,210.0221.73%17.01%4.72%ST230$0.00
<br />21.73%
<br />STORM$1,035,774.7929.34%25.54%3.80%ST240$0.00
<br />29.34%
<br />$3,530,112.08100.0000%ST2519$81.32
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquenciesST262$8.06
<br />ST270$0.00
<br />TP's direction for FY10 Cap/Op Splits (per FY10 Bud):
<br />Enter current budget here: (bold&shaded items)ST280$0.00
<br />% Cap
<br />% OpST290$0.00
<br />OpCap
<br />Net Budget
<br />Local WW78%22%$ 6,220,350 $ 1,727,550 ST305$44.05
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST312$20.80
<br />$ 11,648,100.00
<br />ST321$7.19
<br />We apply these rates to the Local WW and Storm % of total to get the %'s needed for turnover report. In July of each year, update these
<br />to reflect new budget. Other months will populate automatically.ST330$0.00
<br />ST341$3.17
<br />Monthly WW Summary by ClassificationST352$11.62
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts54,3114,701671382361559,468ST370$0.00
<br />Flows 257,017 164,702 7,761 9,848 9,474 3,562
<br /> 452,364 ST380$0.00
<br />Avg Flow/Acct 4.73 35.04 115.84 71.36 40.15 237.48 $
<br /> 505 ST390$0.00
<br />Local Flow Rev$ 435,901 $ 279,334 $ 13,163 $ 16,702 $ 16,069 $ 6,042 $
<br />767,210 STW045$7,049.08
<br />Reg Flow Rev$ 510,436 $ 439,589 $ 30,190 $ 54,360 $67,770.30$ 31,291$ 1,133,637 STW17,720$599,996.01
<br />
<br />Reg Base Rev$ 542,024 $ 46,916 $ 669 $ 1,377 2,355$ 150 $ 593,491 STW21,413$24,659.39
<br />
<br />Reg Tot Rev$ 1,052,460 $ 486,505 $ 30,859 $ 55,738 $ 70,126 $ 31,441 $ 1,727,127 STWB27$72.09
<br />
<br />Tot WW Rev$ 1,488,361 $ 765,839 $ 44,022 $ 72,440 $ 86,194 $ 37,482 $ 2,494,337 STW31$20.67
<br />
<br />OK
<br />STW946$6,480.55
<br />FSTR1$0.00
<br />Monthly Stormwater Summary by ClassificationSTB14$2.97
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB22$0.00
<br />Accounts3,56938,1211,4401,01644,1467,81851,964
<br />Revenue23,006$ 359,454$ 24,731$ 15,055$ 422,246$ 613,5291,035,774.79Tot STRM51,964$1,035,774.79
<br />OK
<br />Avg Rev/Acct$ 6.45$ 9.43$ 17.17$ 14.82$ 9.56$ 78.48 $
<br /> 19.93
<br />Monthly Stormwater Q & Q Summary by Resi Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />w/reductionsw/reductionsreductionsreductionsTOTAL
<br />commercial participates but receives
<br />Accounts1101,72827251,890 credits via lower ESUs
<br />% of TTL Accts3.08%4.53%1.88%2.46%4.28%
<br />Dec 2009 FY10 Split Report .xlsx1/21/2010
<br />
|