|
<br />Monthly Split Report for Activity during:Mar-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 53,376$9.98$532,692.48$ 1,352,885.21$820,192.73$ 3.682 222,757$1.696$377,796.54$442,396.19 St W
<br />RDSM 1,082$9.98$10,798.36$ 38,351.35$27,552.99$ 3.682 7,483$1.696$12,691.44$14,861.55oops!Code# OF ACCTS
<br />GSLM 4,700$9.98$46,906.00$ 729,631.88$682,725.88$ 4.365 156,409$1.696$265,269.90$417,455.98
<br />from EWEB report
<br />GSMM 67 $9.98$668.66$ 43,027.29$42,358.63$ 5.586 7,583$1.696$12,860.77$29,497.86 STRO3,486
<br />GSHM 138$9.98$1,377.24$ 75,856.22$74,478.98$ 7.216 10,321$1.696$17,505.04$56,973.94 STR61
<br />VHSM 234$9.98$2,335.32$ 81,160.96$78,825.64$ 8.849 8,908$1.696$15,107.73$63,717.91STR715
<br />SHSM 15 $9.98$149.70$ 39,664.34$39,514.64$ 10.480 3,770$1.696$6,394.74$33,119.90 STR81
<br />GSLH -$9.98$0.00$ - $0.00$ 4.365 0$1.696$0.00$0.00 STR9106
<br />FSWR 49 $9.98$489.02$ 6,079.16 $5,590.14$ 3.682 1,518$1.696$2,574.93$3,015.21 STR136,504
<br />FSW2 1$9.98$9.98$ 14,881.91$14,871.93$ 4.365 3,407$1.696$5,778.42$9,093.51 ST1029
<br />MSWR 2$9.98$19.96$ 2,082.24 $2,062.28$ 4.365 472$1.696$801.29$1,260.99 STR4990
<br />SMLM 2$9.98$19.96$ 884.24$864.28$ 4.365 198$1.696$335.81$528.47 ST1133
<br />Tot WW59,666$595,466.68$2,384,504.80$1,789,038.12422,828$717,116.59$1,071,921.53STR5677
<br />OKOK$595,466.68STR2560
<br />$1,667,388.21ST120
<br />ST135
<br />ST142
<br />ST152
<br />STR3381
<br />ST161
<br />ST175
<br />Summary for ST180
<br />ST195
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST2013
<br />MWMC TOTAL$1,667,388.2148.71%%Op:%Cap:ST210
<br />double check:
<br />LOCAL WW$717,116.5920.95%16.40%4.55%ST220
<br />20.95%
<br />STORM$1,038,558.7330.34%26.41%3.93%ST230
<br />30.34%
<br />$3,423,063.53100.0000%ST240
<br />ST2521
<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 ST305
<br />$ 11,648,100.00
<br />ST312
<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 />Accounts54,5074,705671382341559,666ST360
<br />Flows 231,759 160,487 7,583 10,321 8,908 3,770 422,828 ST370
<br />Avg Flow/Acct 4.25 34.11 113.18 74.79 38.07 251.37 $ 516 ST380
<br />
<br />Local Flow Rev$ 393,063 $ 272,185 $ 12,861 $ 17,505 $ 15,108 $ 6,395 $ 717,117 ST390
<br />Reg Flow Rev$ 460,273$ 428,339 $ 29,498 $ 56,974 $63,717.91$ 33,120 $ 1,071,922 STW045
<br />Reg Base Rev$ 543,980 $ 46,956 $ 669 $ 1,377 2,335$ 150 $ 595,467 STW17,729
<br />Reg Tot Rev$ 1,004,253 $ 475,295 $ 30,167 $ 58,351 $ 66,053 $ 33,270 $ 1,667,388 STW21,417
<br />Tot WW Rev$ 1,397,316 $ 747,480 $ 43,027 $ 75,856 $ 81,161 $ 39,664 $ 2,384,505 STWB29
<br />OK
<br />STW31
<br />STW946
<br />Monthly Stormwater Summary by ClassificationFSTR0
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB10
<br />Accounts3,60938,2331,4461,00944,2977,82052,117STB21
<br />Revenue23,054$ 359,761 $ 24,791 $ 15,009$ 422,616$ 615,9431,038,558.73
<br />OK
<br />Avg Rev/Acct$ 6.39 $ 9.41$ 17.14$ 14.88$ 9.54 $ 78.77$ 19.93Tot
<br />STRM52,118
<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 />Accounts1091,70028241,861
<br />via lower ESUs
<br />% of TTL Accts3.02%4.45%1.94%2.38%4.20%
<br />March 2010 Mar 10.xlsx4/9/2010
<br />
<br />
|