|
<br />Monthly Split Report for Activity during:Sep-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 52,292$10.48$548,020.16$ 1,363,499.30$815,479.14$ 3.934 207,290$1.849$383,279.34$432,199.80 Code# OF ACCTSAMOUNT
<br />RDSM 964$10.48$10,102.72$ 32,953.99$22,851.27$ 3.934 5,809$1.849$10,740.21$12,111.06
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,382$10.48$45,923.36$ 1,039,037.96$993,114.60$ 4.651 213,527$1.849$394,811.63$598,302.97 STRO3,284$21,104.81
<br />GSMM 66 $10.48$691.68$ 44,486.22$43,794.54$ 5.934 7,380$1.849$13,646.12$30,148.42 STR61$6.28
<br />GSHM 136$10.48$1,425.28$ 73,901.53$72,476.25$ 7.645 9,480$1.849$17,528.92$54,947.33 STR713$55.77
<br />VHSM 241$10.48$2,525.68$ 83,159.64$80,633.96$ 9.360 8,615$1.849$15,928.65$64,705.31STR81$3.79
<br />SHSM 15 $10.48$157.20$ 28,397.54$28,240.34$ 11.072 2,551$1.849$4,716.08$23,524.26 STR9101$176.85
<br />GSLH -$10.48$0.00$ - $0.00$ 4.651 0$1.849$0.00$0.00 STR135,647$341,461.74
<br />FSWR 50 $10.48$524.00$ 9,105.35 $8,581.35$ 3.934 2,181$1.849$4,033.28$4,548.07 ST1038$309.38
<br />FSW2 1$10.48$10.48$ 18,367.02$18,356.54$ 4.651 3,947$1.849$7,297.62$11,058.92 STR4978$5,611.69
<br />MSWR 2$10.48$20.96$ 2,218.37 $2,197.41$ 4.651 472$1.849$873.58$1,323.83 ST1137$179.17
<br />SMLM 2$10.48$20.96$ 686.06$665.10$ 4.651 143$1.849$264.41$400.69 STR5697$1,203.73
<br />Tot WW58,151$609,422.48$2,695,812.98$2,086,390.50461,395$853,119.85$1,233,270.65STR2478$6,131.85
<br />OKOK$609,422.48ST120$0.00
<br />$1,842,693.13ST135$32.64
<br />ST141$7.16
<br />ST151$3.17
<br />STR3352$6,628.81
<br />ST161$17.63
<br />ST175$56.05
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,117,516ST195$15.85
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$852,952ST2013$106.08
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$716,717ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,842,693.1349.65%%Op:%Cap:Reg WW Share:$1,547,847ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$853,119.8522.99%17.99%5.00%$3,117,516ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />22.99%
<br />STORM$1,015,266.8827.36%23.82%3.54%ST240$0.00
<br />27.36%
<br />$3,711,079.86100.0000%$51,177ST2521$70.34
<br />= 6% of Storm share for ROW Fees
<br />$43,003ST262$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 />$94,180ST270$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 ClassificationST353$11.42
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts53,3064,387661362411558,151ST370$0.00
<br />Flows 215,280 218,089 7,380 9,480 8,615 2,551 461,395 ST380$0.00
<br />Avg Flow/Acct 4.04 49.71 111.82 69.71 35.75 170.04 7.93 ST390$0.00
<br />
<br />Local Flow Rev$ 398,053 $ 403,247 $ 13,646 $ 17,529 $ 15,929 $ 4,716 $ 853,120 STW046$7,356.36
<br />
<br />Reg Flow Rev$ 448,859$ 611,086 $ 30,148 $ 54,947 $64,705.31$ 23,524 $ 1,233,271 STW17,440$593,302.87
<br />Reg Base Rev$ 558,647 $ 45,976 $ 692 $ 1,425 2,526$ 157 $ 609,422 STW21,424$24,914.83
<br />Reg Tot Rev$ 1,007,506 $ 657,062 $ 30,840 $ 56,373 $ 67,231 $ 23,681 $ 1,842,693 STWB28$74.76
<br />Tot WW Rev$ 1,405,559 $ 1,060,309 $ 44,486 $ 73,902 $ 83,160 $ 28,398 $ 2,695,813 STW31$20.67
<br />OK
<br />STW946$6,318.36
<br />FSTR0$0.00
<br />Monthly Stormwater Summary by ClassificationSTB10$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB20$0.00
<br />Accounts3,40037,3971,45289643,1457,53250,677
<br />Revenue$ 21,348$ 348,766 $ 24,990 $ 13,186$ 408,289$ 606,9781,015,267Tot STRM50,677$1,015,266.88
<br />OK
<br />Avg Rev/Acct$ 6.28 $ 9.33$ 17.21$ 14.72$ 9.46 $ 80.59$ 20.03
<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 />Accounts1161,75028231,917
<br />via lower ESUs
<br />% of TTL Accts3.41%4.68%1.93%2.57%4.44%
<br />Sept 2010 Sept 10.xlsx10/15/2010
<br />
|