|
<br />Monthly Split Report for Activity during:Aug-10
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC'sBILLING
<br />RateBasicBasic ChargesTotalAmount billed 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,282$10.48$547,915.36$ 1,362,820.03$814,904.67$ 3.934 207,144$1.849$383,009.34$431,895.33 Code# OF ACCTSAMOUNT
<br />RDSM963$10.48$10,092.24$ 33,237.50$23,145.26$ 3.934 5,883$1.849$10,878.39$12,266.87
<br />from EWEB reportfrom EWEB report
<br />GSLM4,393$10.48$46,038.64$ 689,997.88$643,959.24$ 4.651 138,456$1.849$256,005.30$387,953.94 STRO3,333$21,078.48
<br />GSMM66$10.48$691.68$ 44,675.56$43,983.88$ 5.934 7,412$1.849$13,705.12$30,278.76 STR61$6.28
<br />GSHM135$10.48$1,414.80$ 75,251.84$73,837.04$ 7.645 9,658$1.849$17,858.04$55,979.00 STR713$55.77
<br />VHSM238$10.48$2,494.24$ 82,659.57$80,165.33$ 9.360 8,565$1.849$15,836.08$64,329.25STR81$3.79
<br />SHSM17$10.48$178.16$ 44,656.90$44,478.74$ 11.072 4,017$1.849$7,427.85$37,050.89 STR9103$172.39
<br />GSLH0$10.48$0.00$ - $0.00$ 4.651 0$1.849$0.00$0.00 STR135,684$341,490.48
<br />FSWR47$10.48$492.56$ 12,730.19$12,237.63$ 3.934 3,111$1.849$5,751.75$6,485.88 ST1036$305.78
<br />FSW21$10.48$10.48$ 13,200.00$13,189.52$ 4.651 2,836$1.849$5,243.48$7,946.04 STR4978$5,601.04
<br />MSWR2$10.48$20.96$ 2,218.37 $2,197.41$ 4.651 472$1.849$873.58$1,323.83 ST1137$180.84
<br />SMLM2$10.48$20.96$ 555.83$534.87$ 4.651 115$1.849$212.64$322.23 STR5690$1,203.38
<br />Tot WW58,146$609,370.08$2,362,003.67$1,752,633.59387,670$716,801.56$1,035,832.03STR2473$6,139.28
<br />OKOK$609,370.08ST120$0.00
<br />$1,645,202.11ST134$32.64
<br />ST140$0.00
<br />ST150$0.00
<br />STR3356$6,596.12
<br />$2,362,003.67
<br />ST161$17.63
<br />ST175$56.05
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,433,309ST195$15.85
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$1,032,396ST2013$99.55
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$728,548ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,645,202.1148.71%%Op:%Cap:Reg WW Share:$1,672,365ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$716,801.5621.22%15.91%5.31%$3,433,309ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />21.22%
<br />STORM$1,015,423.6230.07%25.99%4.07%ST240$0.00
<br />30.07%
<br />$3,377,427.29100.0000%$61,944ST2518$69.62
<br />= 6% of Storm share for ROW Fees
<br />$43,713ST262$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 />$105,657ST270$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 />25%
<br />Local WW75%$ 6,410,000 $ 2,139,000 ST305$56.00
<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 ClassificationST357$27.30
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts53,2924,398661352381758,146ST370$0.00
<br />Flows 216,138 141,879 7,412 9,658 8,565 4,017 387,670 ST380$0.00
<br />Avg Flow/Acct 4.06 32.26 112.31 71.54 35.99 236.31 6.67 ST390$0.00
<br />
<br />Local Flow Rev$ 399,639 $ 262,335 $ 13,705 $ 17,858 $ 15,836 $ 7,428 $ 716,802 STW045$7,356.36
<br />
<br />Reg Flow Rev$ 450,648$ 397,546 $ 30,279 $ 55,979 $64,329.25$ 37,051 $ 1,035,832 STW17,442$593,551.68
<br />Reg Base Rev$ 558,500 $ 46,091 $ 692 $ 1,415 2,494$ 178 $ 609,370 STW21,426$24,863.83
<br />Reg Tot Rev$ 1,009,148 $ 443,637 $ 30,970 $ 57,394 $ 66,823 $ 37,229 $ 1,645,202 STWB30$75.47
<br />Tot WW Rev$ 1,408,788 $ 705,972 $ 44,676 $ 75,252 $ 82,660 $ 44,657 $ 2,362,004 STW31$20.67
<br />OK
<br />STW946$6,318.36
<br />FSTR0$0.00
<br />Monthly Stormwater Summary by ClassificationSTB12$0.16
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB20$0.00
<br />Accounts3,45137,4251,45689343,2257,53550,760
<br />Revenue$ 21,317$ 348,782 $ 24,939 $ 13,160$ 408,197$ 607,2271,015,424Tot STRM50,760$1,015,423.62
<br />OK
<br />Avg Rev/Acct$ 6.18 $ 9.32$ 17.13$ 14.74$ 9.44 $ 80.59$ 20.00
<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 />Accounts1181,74130201,909
<br />via lower ESUs
<br />% of TTL Accts3.42%4.65%2.06%2.24%4.42%
<br />Aug 2010 Aug 10.xlsx9/16/2010
<br />
|