|
<br />Monthly Split Report for Activity during:Apr-10
<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 51,718$9.98$516,145.64$ 1,312,694.70$796,549.06$ 3.682 216,336$1.696$366,905.81$429,643.25ok St W
<br />RDSM 951$9.98$9,490.98$ 32,604.58$23,113.60$ 3.682 6,277$1.696$10,646.57$12,467.03ok Code# OF ACCTS
<br />GSLM 4,371$9.98$43,622.58$ 656,291.15$612,668.57$ 4.365 140,359$1.696$238,049.46$374,619.11ok
<br />from EWEB report
<br />GSMM 66 $9.98$658.68$ 43,512.48$42,853.80$ 5.586 7,672$1.696$13,011.11$29,842.69ok STRO3,222
<br />GSHM 139$9.98$1,387.22$ 74,824.86$73,437.64$ 7.216 10,177$1.696$17,260.29$56,177.35ok STR61
<br />VHSM 233$9.98$2,325.34$ 80,240.79$77,915.45$ 8.849 8,805$1.696$14,933.28$62,982.17ok STR712
<br />SHSM 15 $9.98$149.70$ (10,412.73) -$10,562.43$ 10.480 -1,008$1.696-$1,709.34-$8,853.09ok STR81
<br />GSLH -$9.98$0.00$ - $0.00$ 4.365 0$1.696$0.00$0.00ok STR9104
<br />FSWR 50 $9.98$499.00$ 12,208.36$11,709.36$ 3.682 3,180$1.696$5,393.56$6,315.80ok STR135,288
<br />FSW2 1$9.98$9.98$ 13,200.00$13,190.02$ 4.365 3,022$1.696$5,124.92$8,065.10ok ST1024
<br />MSWR 2$9.98$19.96$ 2,082.24 $2,062.28$ 4.365 472$1.696$801.29$1,260.99ok STR4985
<br />SMLM 2$9.98$19.96$ 1,128.68 $1,108.72$ 4.365 254$1.696$430.79$677.93ok ST1132
<br />Tot WW57,548$574,329.04$2,218,375.11$1,644,046.07395,547$670,847.73$973,198.34STR5682
<br />OKOK$574,329.04STR2476
<br />$1,547,527.38ST120
<br />ST134
<br />ST140
<br />ST150
<br />STR3346
<br />ST161
<br />ST175
<br />Summary for ST180
<br />ST195
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST2012
<br />MWMC TOTAL$1,547,527.3847.89%%Op:%Cap:ST210
<br />double check:
<br />LOCAL WW$670,847.7320.76%16.25%4.51%ST220
<br />20.76%
<br />STORM$1,012,838.0431.35%27.29%4.06%ST230
<br />31.35%
<br />$3,231,213.15100.0000%ST240
<br />ST2515
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST262
<br />TP's direction for FY10 Cap/Op Splits (per FY10 Bud):
<br />Enter current budget here: (bold&shaded items)ST270
<br />% Cap
<br />% OpST280
<br />OpCap Net Budget
<br />22%
<br />Local WW78%$ 6,220,350 $ 1,727,550 ST290
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST304
<br />$ 11,648,100.00
<br />ST311
<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
<br />reflect new budget. Other months will populate automatically.
<br />ST330
<br />Monthly WW Summary by ClassificationST341
<br />RESLOWMEDHIGHV HighS HighTOTALST352
<br />Accounts52,7194,376661392331557,548ST360
<br />Flows 225,794 144,108 7,672 10,177 8,805 (1,008) 395,547 ST370
<br />Avg Flow/Acct 4.28 32.93 116.24 73.22 37.79 (67.19) $ 197
<br />ST380
<br />Local Flow Rev$ 382,946 $ 244,406 $ 13,011 $ 17,260 $ 14,933 $ (1,709) $ 670,848 ST390
<br />Reg Flow Rev$ 448,426$ 384,623 $ 29,843 $ 56,177 $62,982.17$ (8,853) $ 973,198 STW045
<br />Reg Base Rev$ 526,136 $ 43,672 $ 659 $ 1,387 2,325$ 150 $ 574,329 STW17,344
<br />Reg Tot Rev$ 974,562 $ 428,296 $ 30,501 $ 57,565 $ 65,308 $ (8,703) $ 1,547,527 STW21,404
<br />Tot WW Rev$ 1,357,508 $ 672,702 $ 43,512 $ 74,825 $ 80,241 $ (10,413) $ 2,218,375 STWB28
<br />OK
<br />STW31
<br />STW946
<br />Monthly Stormwater Summary by ClassificationFSTR0
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB10
<br />Accounts3,34037,0111,43287642,6597,43550,094STB20
<br />Revenue21,340$ 348,065 $ 24,592 $ 13,211$ 407,208$ 605,6301,012,838.04
<br />OK
<br />Avg Rev/Acct$ 6.39 $ 9.40$ 17.17$ 15.08$ 9.55 $ 81.46$ 20.22Tot
<br />STRM50,094
<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 />Accounts1181,72328201,889
<br />via lower ESUs
<br />% of TTL Accts3.53%4.66%1.96%2.28%4.43%
<br />April 2010 5/17/2010
<br />
<br />
|