|
<br />Monthly Split Report for Activity during:Feb-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 49,964$9.98$498,640.72$ 1,246,401.22$747,760.50$ 3.682 203,085$1.696$344,432.86$403,327.64 St W
<br />RDSM 823$9.98$8,213.54$ 28,354.06$20,140.52$ 3.682 5,470$1.696$9,277.11$10,863.41 Code# OF ACCTS
<br />GSLM 4,051$9.98$40,428.98$ 620,665.22$580,236.24$ 4.365 132,929$1.696$225,448.03$354,788.21
<br />from EWEB report
<br />GSMM 63 $9.98$628.74$ 40,272.57$39,643.83$ 5.586 7,097$1.696$12,036.51$27,607.32 STRO1
<br />GSHM 132$9.98$1,317.36$ 69,677.70$68,360.34$ 7.216 9,473$1.696$16,066.95$52,293.39 STR612
<br />VHSM 227$9.98$2,265.46$ 78,063.80$75,798.34$ 8.849 8,566$1.696$14,527.52$61,270.82STR71
<br />SHSM 15 $9.98$149.70$ 38,265.22$38,115.52$ 10.480 3,637$1.696$6,168.31$31,947.21 STR8103
<br />GSLH -$9.98$0.00$ - $0.00$ 4.365 0$1.696$0.00$0.00 STR934,056
<br />FSWR 50 $9.98$499.00$ 12,963.28$12,464.28$ 3.682 3,385$1.696$5,741.29$6,722.99 STR124
<br />FSW2 1$9.98$9.98$ 13,200.00$13,190.02$ 4.365 3,022$1.696$5,124.92$8,065.10 ST10961
<br />MSWR 2$9.98$19.96$ 2,082.24 $2,062.28$ 4.365 472$1.696$801.29$1,260.99 STR431
<br />SMLM 2$9.98$19.96$ 1,277.09 $1,257.13$ 4.365 288$1.696$488.45$768.68 ST11673
<br />Tot WW55,330$552,193.40$2,151,222.40$1,599,029.00377,425$640,113.25$958,915.75STR5398
<br />OKOK$552,193.40STR20
<br />$1,511,109.15ST123
<br />ST130
<br />ST142
<br />ST15312
<br />STR31
<br />ST165
<br />ST170
<br />Summary for ST185
<br />ST1911
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST200
<br />MWMC TOTAL$1,511,109.1548.15%%Op:%Cap:ST210
<br />double check:
<br />LOCAL WW$640,113.2520.40%15.96%4.43%ST220
<br />20.40%
<br />STORM$987,162.5731.45%27.38%4.07%ST230
<br />31.45%
<br />$3,138,384.97100.0000%ST2410
<br />ST252
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST260
<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 ST292
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST300
<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 />ST320
<br />reflect new budget. Other months will populate automatically.
<br />ST331
<br />Monthly WW Summary by ClassificationST342
<br />RESLOWMEDHIGHV HighS HighTOTALST350
<br />Accounts50,8374,056631322271555,330ST360
<br />Flows 211,941 136,711 7,097 9,473 8,566 3,637 377,425 ST370
<br />Avg Flow/Acct 4.17 33.71 112.65 71.77 37.73 242.47 $ 502 ST380
<br />
<br />Local Flow Rev$ 359,451 $ 231,863 $ 12,037 $ 16,067 $ 14,528 $ 6,168 $ 640,113 ST3944
<br />Reg Flow Rev$ 420,914$ 364,883 $ 27,607 $ 52,293 $61,270.82$ 31,947 $ 958,916 STW06,947
<br />Reg Base Rev$ 507,353 $ 40,479 $ 629 $ 1,317 2,265$ 150 $ 552,193 STW11,398
<br />Reg Tot Rev$ 928,267 $ 405,362 $ 28,236 $ 53,611 $ 63,536 $ 32,097 $ 1,511,109 STW227
<br />Tot WW Rev$ 1,287,719 $ 637,225 $ 40,273 $ 69,678 $ 78,064 $ 38,265 $ 2,151,222 STWB1
<br />OK
<br />STW347
<br />STW90
<br />Monthly Stormwater Summary by ClassificationFSTR2
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB10
<br />Accounts3,09335,7451,42575641,0197,04048,059STB248,059
<br />Revenue19,657$ 336,856 $ 24,510 $ 11,413$ 392,437$ 594,726987,162.57
<br />OK
<br />Avg Rev/Acct$ 6.36 $ 9.42$ 17.20$ 15.10$ 9.57 $ 84.48$ 20.54Tot
<br />STRM93,142
<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 />Accounts1171,68927201,853
<br />via lower ESUs
<br />% of TTL Accts3.78%4.73%1.89%2.65%4.52%
<br />Feb 2010 Feb 10.xlsx3/15/2010
<br />
<br />
|