|
<br />Monthly Split Report for Activity during:Jun-10
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC's
<br />BILLING
<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,727$9.98$516,235.46$ 1,217,012.83$700,777.37$ 3.682 190,325$1.696$322,791.53$377,985.84ok St WTOTAL BILLED
<br />RDSM 954$9.98$9,520.92$ 29,955.61$20,434.69$ 3.682 5,550$1.696$9,412.61$11,022.08ok Code# OF ACCTSAMOUNT
<br />GSLM 4,380$9.98$43,712.40$ 592,104.66$548,392.26$ 4.365 125,634$1.696$213,075.21$335,317.05ok
<br />from EWEB reportfrom EWEB report
<br />GSMM 66 $9.98$658.68$ 41,483.27$40,824.59$ 5.586 7,308$1.696$12,395.01$28,429.58ok STRO3,202$21,063.68
<br />GSHM 135$9.98$1,347.30$ 71,920.83$70,573.53$ 7.216 9,780$1.696$16,587.13$53,986.40ok STR61$6.28
<br />VHSM 236$9.98$2,355.28$ 76,930.11$74,574.83$ 8.849 8,427$1.696$14,293.02$60,281.81ok STR713$55.77
<br />SHSM 15 $9.98$149.70$ 33,428.53$33,278.83$ 10.480 3,175$1.696$5,385.58$27,893.25ok STR81$3.79
<br />GSLH -$9.98$0.00$ - $0.00$ 4.365 0$1.696$0.00$0.00ok STR9101$170.95
<br />FSWR 49 $9.98$489.02$ 11,721.23$11,232.21$ 3.682 3,051$1.696$5,173.77$6,058.44oops!STR135,301$340,987.41
<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 ST1030$270.60
<br />MSWR 2$9.98$19.96$ 2,082.24 $2,062.28$ 4.365 472$1.696$801.29$1,260.99ok STR4979$5,571.57
<br />SMLM 2$9.98$19.96$ 735.82$715.86$ 4.365 164$1.696$278.14$437.72ok ST1131$155.00
<br />Tot WW57,567$574,518.66$2,090,575.13$1,516,056.47356,909$605,318.21$910,738.26STR5678$1,175.37
<br />OKOK$574,518.66STR2476$6,165.60
<br />$1,485,256.92ST120$0.00
<br />ST134$32.64
<br />ST140$0.00
<br />ST150$0.00
<br />STR3349$6,585.49
<br />ST161$17.63
<br />ST175$56.05
<br />Summary for ST180$0.00
<br />ST195$15.85
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST2012$97.92
<br />MWMC TOTAL$1,485,256.9247.86%%Op:%Cap:ST210$0.00
<br />double check:
<br />LOCAL WW$605,318.2119.50%15.26%4.24%ST220$0.00
<br />19.50%
<br />STORM$1,013,028.8632.64%28.41%4.23%ST230$0.00
<br />32.64%
<br />$3,103,603.99100.0000%ST240$0.00
<br />ST2516$64.06
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST264$9.13
<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 />ST311$10.40
<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$11.62
<br />Accounts52,7304,385661352361557,567ST360$0.00
<br />Flows 198,926 129,292 7,308 9,780 8,427 3,175 356,909 ST370$0.00
<br />Avg Flow/Acct 3.77 29.49 110.73 72.45 35.71 211.70 $ 464 ST380$0.00
<br />
<br />Local Flow Rev$ 337,378 $ 219,280 $ 12,395 $ 16,587 $ 14,293 $ 5,386 $ 605,318 ST390$0.00
<br />Reg Flow Rev$ 395,066$ 345,081 $ 28,430 $ 53,986 $60,281.81$ 27,893 $ 910,738 STW045$7,356.36
<br />Reg Base Rev$ 526,245 $ 43,762 $ 659 $ 1,347 2,355$ 150 $ 574,519 STW17,345$592,003.45
<br />Reg Tot Rev$ 921,312 $ 388,843 $ 29,088 $ 55,334 $ 62,637 $ 28,043 $ 1,485,257 STW21,419$24,671.98
<br />
<br />Tot WW Rev$ 1,258,690 $ 608,123 $ 41,483 $ 71,921 $ 76,930 $ 33,429 $ 2,090,575 STWB29$75.12
<br />OK
<br />STW31$20.67
<br />STW946$6,314.48
<br />Monthly Stormwater Summary by ClassificationFSTR1$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB14$4.83
<br />Accounts3,31837,0191,44888242,6677,44150,108STB20$0.00
<br />Revenue21,300$ 348,160 $ 24,747 $ 13,142$ 407,350$ 605,6791,013,028.86
<br />OK
<br />Avg Rev/Acct$ 6.42 $ 9.40$ 17.09$ 14.90$ 9.55 $ 81.40$ 20.22Tot
<br />STRM50,108$1,013,028.86
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />TOTAL
<br />w/reductionsw/reductionsreductionsreductions
<br />commercial participates but receives credits
<br />Accounts1161,71829221,885
<br />via lower ESUs
<br />% of TTL Accts3.50%4.64%2.00%2.49%4.42%
<br />June 2010 June 10.xlsx7/13/2010
<br />
|