|
<br />Monthly Split Report for Activity during:Oct-10
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC'sBILLING
<br />RateBasicBasic ChargesTotalAmount billedFY07 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 51,790$10.48$542,759.20$ 1,325,616.85$782,857.65$ 3.934 198,998$1.849$367,947.08$414,910.57 Code# OF ACCTSAMOUNT
<br />RDSM 949$10.48$9,945.52$ 32,803.48$22,857.96$ 3.934 5,810$1.849$10,743.36$12,114.60
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,395$10.48$46,059.60$ 303,593.03$257,533.43$ 4.651 55,372$1.849$102,382.14$155,151.29 STRO3,217$21,051.98
<br />GSMM 67 $10.48$702.16$ 44,323.28$43,621.12$ 5.934 7,351$1.849$13,592.09$30,029.03 STR62$8.79
<br />GSHM 135$10.48$1,414.80$ 78,473.67$77,058.87$ 7.645 10,080$1.849$18,637.26$58,421.61 STR713$55.77
<br />VHSM 238$10.48$2,494.24$ 82,982.41$80,488.17$ 9.360 8,599$1.849$15,899.85$64,588.32STR81$3.79
<br />SHSM 16 $10.48$167.68$ 44,621.27$44,453.59$ 11.072 4,015$1.849$7,423.65$37,029.94 STR9106$178.82
<br />GSLH -$10.48$0.00$ - $0.00$ 4.651 0$1.849$0.00$0.00 STR135,275$340,719.87
<br />FSWR 50 $10.48$524.00$ 12,947.69$12,423.69$ 3.934 3,158$1.849$5,839.20$6,584.49 ST1037$308.49
<br />FSW2 1$10.48$10.48$ 13,200.00$13,189.52$ 4.651 2,836$1.849$5,243.48$7,946.04 STR4978$5,617.70
<br />MSWR 2$10.48$20.96$ 2,218.37 $2,197.41$ 4.651 472$1.849$873.58$1,323.83 ST1138$186.50
<br />SMLM 2$10.48$20.96$ 732.56$711.60$ 4.651 153$1.849$282.90$428.70 STR5688$1,193.03
<br />Tot WW57,645$604,119.60$1,941,512.61$1,337,393.01296,844$548,864.57$788,528.44STR2467$6,115.62
<br />OKOK$604,119.60ST120$0.00
<br />$1,392,648.04ST134$32.64
<br />ST140$0.00
<br />ST150$0.00
<br />STR3349$6,608.93
<br />ST161$17.63
<br />ST176$55.68
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,267,271ST195$15.85
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$1,119,367ST2014$107.17
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$607,386ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,392,648.0447.16%%Op:%Cap:Reg WW Share:$1,540,845ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$548,864.5718.59%14.55%4.04%$3,267,598ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />18.59%
<br />STORM$1,011,625.0634.26%29.82%4.43%ST240$0.00
<br />34.26%
<br />$2,953,137.67100.0000%$67,162ST2517$72.76
<br />= 6% of Storm share for ROW Fees
<br />$36,443ST262$8.06
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies= 6% of local WW share for ROW Fees
<br />$103,605ST270$0.00
<br />total ROW revenue to fund 131
<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 Net Budget
<br />22%
<br />Local WW78%$ 6,220,350 $ 1,727,550 ST305$56.00
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST311$10.40
<br />$ 11,648,100.00
<br />We apply these
<br />ST321$7.19
<br />rates to the Local
<br />ST330$0.00
<br />ST341$3.17
<br />Monthly WW Summary by ClassificationST355$20.92
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts52,7894,400671352381657,645ST370$0.00
<br />Flows 207,966 58,833 7,351 10,080 8,599 4,015 296,844 ST380$0.00
<br />Avg Flow/Acct 3.94 13.37 109.72 74.66 36.13 250.93 $ 489 ST390$0.00
<br />
<br />Local Flow Rev$ 384,530 $ 108,782 $ 13,592 $ 18,637 $ 15,900 $ 7,424 $ 548,865 STW045$7,322.35
<br />
<br />Reg Flow Rev$ 433,610$ 164,850 $ 30,029 $ 58,422 $64,588.32$ 37,030 $ 788,528 STW17,381$590,478.67
<br />Reg Base Rev$ 553,229 $ 46,112 $ 702 $ 1,415 2,494$ 168 $ 604,120 STW21,427$24,932.70
<br />Reg Tot Rev$ 986,838 $ 210,962 $ 30,731 $ 59,836 $ 67,083 $ 37,198 $ 1,392,648 STWB30$77.43
<br />Tot WW Rev$ 1,371,368 $ 319,744 $ 44,323 $ 78,474 $ 82,982 $ 44,621 $ 1,941,513 STW31$20.67
<br />OK
<br />STW946$6,318.36
<br />FSTR0$0.00
<br />Monthly Stormwater Summary by ClassificationSTB16$18.12
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB20$0.00
<br />Accounts3,33937,0161,45787942,6917,47850,169
<br />Revenue$ 21,299$ 348,026 $ 25,010 $ 13,153$ 407,488$ 604,1381,011,625Tot STRM50,169$1,011,625.06
<br />OK
<br />Avg Rev/Acct$ 6.38 $ 9.40$ 17.17$ 14.96$ 9.55 $ 80.79$ 20.16
<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 credits
<br />Accounts1221,741309692,862
<br />via lower ESUs
<br />% of TTL Accts3.65%4.70%2.06%110.24%6.70%
<br />Oct 2010 Oct 10.xlsx11/15/2010
<br />
|