|
<br />Monthly Split Report for Activity during:Nov-10
<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 KgalRevenueRevenueCheck
<br />Stormwater Monthly Info
<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 50,135 $10.48$525,414.80$ 1,233,110.09 $707,695.29$ 3.934179,892$1.849$332,620.38$375,074.91 St WTOTAL BILLED
<br />RDSM 828$10.48$8,677.44$ 27,230.38$18,552.94$ 3.9344,716$1.849$8,719.98$9,832.96 Code# OF ACCTSAMOUNT
<br />GSLM 4,056$10.48$42,506.88$ 623,595.64$581,088.76$ 4.651124,938$1.849$231,011.21$350,077.55
<br />from EWEB reportfrom EWEB report
<br />GSMM 64$10.48$670.72$ 43,429.62$42,758.90$ 5.9347,206$1.849$13,323.43$29,435.47 STRO2,969$19,428.32
<br />GSHM 131$10.48$1,372.88$ 74,545.72$73,172.84$ 7.6459,571$1.849$17,697.39$55,475.45 STR62$3.98
<br />VHSM 233$10.48$2,441.84$ 79,202.91$76,761.07$ 9.3608,201$1.849$15,163.59$61,597.48STR713$51.63
<br />SHSM 15$10.48$157.20$ 31,168.16$31,010.96$ 11.0722,801$1.849$5,178.76$25,832.20 STR81$3.79
<br />GSLH -$10.48$0.00$ -$0.00$ 4.6510$1.849$0.00$0.00 STR9102$176.79
<br />FSWR 48$10.48$503.04$ 12,545.48$12,042.44$ 3.9343,061$1.849$5,660.01$6,382.43 STR134,112$329,550.59
<br />FSW2 1$10.48$10.48$ 13,200.00$13,189.52$ 4.6512,836$1.849$5,243.48$7,946.04 ST1033$294.65
<br />MSWR 2$10.48$20.96$ 2,218.37$2,197.41$ 4.651472$1.849$873.58$1,323.83 STR4973$5,583.60
<br />SMLM 2$10.48$20.96$ 923.25$902.29$ 4.651194$1.849$358.70$543.59 ST1137$182.33
<br />Tot WW55,515$581,797.20$2,141,169.62$1,559,372.42343,889$635,850.51$923,521.91STR5678$1,191.42
<br />OKOK$581,797.20STR2392$5,084.22
<br />$1,505,319.11ST120$0.00
<br />ST133$24.48
<br />ST140$0.00
<br />ST150$0.00
<br />STR3308$5,868.20
<br />ST161$17.63
<br />Summary for
<br />New in FY11 - ROW Fees calculationsST176$56.42
<br />Monthly
<br />$3,181,222ST180$0.00
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$1,004,630ST195$15.85
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$646,424ST2014$103.36
<br />Op and Cap both
<br />MWMC TOTAL$1,505,319.1148.10%%Op:%Cap:Reg WW Share:$1,530,168ST210$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$635,850.5120.32%15.90%4.42%$3,181,222ST220$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />20.32%
<br />STORM$988,221.9031.58%27.49%4.09%ST230$0.00
<br />31.58%
<br />$3,129,391.52100.0000%$60,278ST240$0.00
<br />= 6% of Storm share for ROW Fees
<br />$38,785ST2511$47.08
<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 />$99,063ST262$8.06
<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)ST270$0.00
<br />% Cap
<br />% OpST280$0.00
<br />OpCap Net Budget
<br />22%
<br />Local WW78%$ 6,220,350 $ 1,727,550 ST290$0.00
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST304$44.80
<br />$ 11,648,100.00
<br />ST310$0.00
<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 to
<br />ST321$7.19
<br />reflect new budget. Other months will populate automatically.
<br />ST330$0.00
<br />Monthly WW Summary by ClassificationST341$3.17
<br />RESLOWMEDHIGHV HighS HighTOTALST352$7.75
<br />Accounts51,0114,061641312331555,515ST360$0.00
<br />Flows 187,669 128,441 7,206 9,571 8,201 2,801 343,889 ST370$0.00
<br />Avg Flow/Acct 3.68 31.63 112.59 73.06 35.20 186.72 $ 443 ST380$0.00
<br />
<br />Local Flow Rev$ 347,000 $ 237,487 $ 13,323 $ 17,697 $ 15,164 $ 5,179 $ 635,851 ST390$0.00
<br />Reg Flow Rev$ 391,290 $ 359,891 $ 29,435 $ 55,475$61,597.48$ 25,832$ 923,522 STW043$7,163.04
<br />Reg Base Rev$ 534,595 $ 42,559 $ 671 $ 1,373 2,442$ 157 $ 581,797 STW17,012$582,062.32
<br />Reg Tot Rev$ 925,886 $ 402,450 $ 30,106 $ 56,848 $ 64,039 $ 25,989 $ 1,505,319 STW21,424$24,827.04
<br />Tot WW Rev$ 1,272,886 $ 639,937 $ 43,430 $ 74,546 $ 79,203 $ 31,168 $ 2,141,170 STWB28$73.87
<br />OK
<br />STW31$20.67
<br />STW946$6,318.36
<br />Monthly Stormwater Summary by ClassificationFSTR1$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB11$1.29
<br />Accounts3,08735,8331,45275141,1237,10348,226STB20$0.00
<br />Revenue$ 19,665$ 336,803$ 24,901$ 11,309$ 392,677 $ 595,545 988,221.90
<br />OK
<br />Avg Rev/Acct$ 6.37$ 9.40$ 17.15$ 15.06$ 9.55$ 83.84$ 20.49Tot STRM48,226$988,221.90
<br />
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />w/reductionsw/reductionsreductionsreductionsTOTAL
<br />Accounts1181,72128191,886
<br />% of TTL Accts3.82%4.80%1.93%2.53%13.08%
<br />Nov 2010 Nov 10.xlsx12/16/2010
<br />
|