|
<br />Monthly Split Report for Activity during:Jul-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 />RSWM52,159$10.48$546,626.32$1,343,715.19$797,088.87$ 3.934 202,615$1.849$374,635.82$422,453.05 Code# OF ACCTSAMOUNT
<br />RDSM961$10.48$10,071.28$32,836.79$22,765.51$ 3.934 5,787$1.849$10,699.91$12,065.60
<br />from EWEB reportfrom EWEB report
<br />GSLM4,390$10.48$46,007.20$651,539.95$605,532.75$ 4.651 130,194$1.849$240,728.89$364,803.86 STRO3,284$21,069.86
<br />GSMM66$10.48$691.68$44,437.06$43,745.38$ 5.934 7,372$1.849$13,630.81$30,114.57 STR61$6.28
<br />GSHM135$10.48$1,414.80$79,999.82$78,585.02$ 7.645 10,279$1.849$19,006.37$59,578.65 STR713$55.77
<br />VHSM235$10.48$2,462.80$80,623.58$78,160.78$ 9.360 8,351$1.849$15,440.09$62,720.69STR81$3.79
<br />SHSM15$10.48$157.20$40,071.27$39,914.07$ 11.072 3,605$1.849$6,665.56$33,248.51 STR9104$175.19
<br />GSLH0$10.48$0.00$0.00$0.00$ 4.651 0$1.849$0.00$0.00 STR135,600$340,717.00
<br />FSWR52$10.48$544.96$12,277.53$11,732.57$ 3.934 2,982$1.849$5,514.37$6,218.20 ST1037$296.76
<br />FSW21$10.48$10.48$13,200.00$13,189.52$ 4.651 2,836$1.849$5,243.48$7,946.04 STR4986$5,616.94
<br />MSWR2$10.48$20.96$2,218.37$2,197.41$ 4.651 472$1.849$873.58$1,323.83 ST1137$181.17
<br />SMLM2$10.48$20.96$602.34$581.38$ 4.651 125$1.849$231.13$350.25 STR5683$1,197.23
<br />Tot WW58,018$608,028.64$2,301,521.90$1,693,493.26374,619$692,670.00$1,000,823.26STR2481$6,137.09
<br />OKOK$608,028.64ST120$0.00
<br />$1,608,851.90ST134$32.64
<br />ST140$0.00
<br />ST150$0.00
<br />STR3349$6,472.61
<br />ST161$17.63
<br />ST175$56.05
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,103,229ST195$15.85
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$948,347ST2017$112.33
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$648,575ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,608,851.9048.54%%Op:%Cap:Reg WW Share:$1,506,307ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$692,670.0020.90%15.67%5.23%$3,103,229ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />20.90%
<br />STORM$1,012,946.0330.56%26.42%4.14%ST240$0.00
<br />30.56%
<br />$3,314,467.93100.0000%$56,901ST2519$72.19
<br />= 6% of Storm share for ROW Fees
<br />$38,915ST262$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 />$95,816ST270$0.00
<br />total ROW revenue to fund 131
<br />FY11 Cap/Op Splits (per FY11 Bud):
<br />Enter current budget here: (bold&shaded items)ST280$0.00
<br />% Cap
<br />% OpST290$0.00
<br />OpCap Net Budget
<br />25%
<br />Local WW75%$ 6,410,000 $ 2,139,000 ST304$44.80
<br />$ 8,549,000.00
<br />StormW86%14%$ 10,342,000 $ 1,620,000 ST311$10.40
<br />$ 11,962,000.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 to
<br />ST330$0.00
<br />reflect new budget. Other months will populate automatically.
<br />ST341$3.17
<br />Monthly WW Summary by ClassificationST355$17.81
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts53,1724,395661352351558,018ST370$0.00
<br />Flows 211,385 133,627 7,372 10,279 8,351 3,605 374,619 ST380$0.00
<br />Avg Flow/Acct 3.98 30.40 111.70 76.14 35.53 240.33 $ 498 ST390$0.00
<br />
<br />Local Flow Rev$ 390,850 $ 247,077 $ 13,631 $ 19,006 $ 15,440 $ 6,666 $ 692,670 STW045$7,356.36
<br />
<br />Reg Flow Rev$ 440,737$ 374,424 $ 30,115 $ 59,579 $62,720.69$ 33,249 $ 1,000,823 STW17,447$592,164.06
<br />Reg Base Rev$ 557,243 $ 46,060 $ 692 $ 1,415 2,463$ 157 $ 608,029 STW21,424$24,684.01
<br />Reg Tot Rev$ 997,979 $ 420,484 $ 30,806 $ 60,993 $ 65,183 $ 33,406 $ 1,608,852 STWB28$74.76
<br />Tot WW Rev$ 1,388,830 $ 667,561 $ 44,437 $ 80,000 $ 80,624 $ 40,071 $ 2,301,522 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 TotSTB22$0.00
<br />Accounts3,40337,3431,45289643,0947,53850,632
<br />Revenue$ 21,311$ 348,009 $ 24,759 $ 13,028$ 407,107$ 605,8391,012,946Tot STRM50,634$1,012,946.03
<br />OK
<br />Avg Rev/Acct$ 6.26 $ 9.32$ 17.05$ 14.54$ 9.45 $ 80.37$ 20.01
<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 />Accounts1191,74328201,910
<br />via lower ESUs
<br />% of TTL Accts3.50%4.67%1.93%2.23%4.43%
<br />July 2010 July 10.xlsx8/18/2010
<br />
|