|
<br />Monthly Split Report for Activity during:Apr-11
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC'sBILLING
<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,140$10.48$525,467.20$ 1,330,360.87$804,893.67$ 3.934 204,599$1.849$378,304.12$426,589.55ok St WTOTAL BILLED
<br />RDSM 824$10.48$8,635.52$ 30,028.60$21,393.08$ 3.934 5,438$1.849$10,054.86$11,338.22ok Code# OF ACCTSAMOUNT
<br />GSLM 4,068$10.48$42,632.64$ 685,218.75$642,586.11$ 4.651 138,161$1.849$255,459.41$387,126.70ok
<br />from EWEB reportfrom EWEB report
<br />GSMM 63 $10.48$660.24$ 48,019.47$47,359.23$ 5.934 7,981$1.849$14,756.86$32,602.37ok STRO2,936$19,334.61
<br />GSHM 133$10.48$1,393.84$ 89,591.36$88,197.52$ 7.645 11,537$1.849$21,331.22$66,866.30ok STR66$26.38
<br />VHSM 241$10.48$2,525.68$ 83,224.02$80,698.34$ 9.360 8,622$1.849$15,941.37$64,756.97oops!STR713$53.48
<br />SHSM 15 $10.48$157.20$ 51,973.42$51,816.22$ 11.072 4,680$1.849$8,653.20$43,163.02ok STR81$3.79
<br />GSLH -$10.48$0.00$ - $0.00$ 4.651 0$1.849$0.00$0.00ok STR9102$175.78
<br />FSWR 48 $10.48$503.04$ 3,282.66 $2,779.62$ 3.934 707$1.849$1,306.44$1,473.18ok STR134,119$330,402.74
<br />FSW2 1$10.48$10.48$ 13,200.00$13,189.52$ 4.651 2,836$1.849$5,243.48$7,946.04ok ST1033$297.66
<br />MSWR 2$10.48$20.96$ 2,218.37 $2,197.41$ 4.651 472$1.849$873.58$1,323.83ok STR4980$5,590.76
<br />SMLM 2$10.48$20.96$ 1,541.83 $1,520.87$ 4.651 327$1.849$604.62$916.25ok ST1148$231.83
<br />Tot WW55,537$582,027.76$2,338,659.35$1,756,631.59385,359$712,529.15$1,044,102.44STR5681$1,197.87
<br />OKOK$582,027.76STR2394$5,114.90
<br />$1,626,130.20ST120$0.00
<br />ST133$24.48
<br />New in FY11 - ROW Fees calculationsST140$0.00
<br />Summary for
<br />Monthly
<br />Turnover
<br />$3,191,433ST150$0.00
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$950,409STR3307$5,871.41
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$682,648ST161$17.63
<br />Op and Cap both
<br />MWMC TOTAL$1,626,130.2048.82%%Op:%Cap:Reg WW Share:$1,558,058ST175$56.05
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$712,529.1521.39%16.74%4.65%$3,191,115ST180$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />21.39%
<br />STORM$991,904.6729.78%25.93%3.86%ST195$15.85
<br />29.78%
<br />$3,330,564.02100.0000%$57,025ST2012$97.92
<br />= 6% of Storm share for ROW Fees
<br />$40,959ST210$0.00
<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 />$97,984ST220$0.00
<br />total ROW revenue to fund 131
<br />ST230$0.00
<br />TP's direction for FY10 Cap/Op Splits (per FY10 Bud):
<br />Enter current budget here: (bold&shaded items)ST240$0.00
<br />% Cap
<br />% OpST2512$48.65
<br />OpCap Net Budget
<br />22%
<br />Local WW78%$ 6,220,350 $ 1,727,550 ST262$8.06
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST270$0.00
<br />$ 11,648,100.00
<br />ST280$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 />ST290$0.00
<br />reflect new budget. Other months will populate automatically.
<br />ST305$56.00
<br />ST310$0.00
<br />ST321$7.19
<br />ST330$0.00
<br />Monthly WW Summary by ClassificationST341$3.17
<br />RESLOWMEDHIGHV HighS HighTOTALST352$11.62
<br />Accounts51,0124,073631332411555,537ST360$0.00
<br />Flows 210,744 141,796 7,981 11,537 8,622 4,680 385,359 ST370$0.00
<br />Avg Flow/Acct 4.13 34.81 126.68 86.74 35.77 312.00 $ 600 ST380$0.00
<br />
<br />Local Flow Rev$ 389,665 $ 262,181 $ 14,757 $ 21,331 $ 15,941 $ 8,653 $ 712,529 ST390$0.00
<br />Reg Flow Rev$ 439,401$ 397,313 $ 32,602 $ 66,866 $64,756.97$ 43,163 $ 1,044,102 STW043$7,117.33
<br />Reg Base Rev$ 534,606 $ 42,685 $ 660 $ 1,394 2,526$ 157 $ 582,028 STW17,201$584,908.57
<br />Reg Tot Rev$ 974,007 $ 439,998 $ 33,263 $ 68,260 $ 67,283 $ 43,320 $ 1,626,130 STW21,440$24,969.48
<br />
<br />Tot WW Rev$ 1,363,672 $ 702,179 $ 48,019 $ 89,591 $ 83,224 $ 51,973 $ 2,338,659 STWB28$74.76
<br />OK
<br />STW31$20.67
<br />STW945$6,163.98
<br />Monthly Stormwater Summary by ClassificationFSTR1$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB11$2.05
<br />Accounts3,05835,8611,46875141,1387,29348,431STB22$0.00
<br />Revenue19,594$ 337,721 $ 25,044 $ 11,354$ 393,713$ 598,192991,904.67
<br />OK
<br />Avg Rev/Acct$ 6.41 $ 9.42$ 17.06$ 15.12$ 9.57 $ 82.02$ 20.48Tot
<br />STRM48,431$991,904.67
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />w/reductionsw/reductionsreductionsreductionsTOTAL
<br />commercial participates but receives credits
<br />Accounts1221,74228181,910
<br />via lower ESUs
<br />% of TTL Accts3.99%4.86%1.91%2.40%4.64%
<br />April 2011 April 11.xlsx5/17/2011
<br />
|