|
<br />Monthly Split Report for Activity during:Dec-08
<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 />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 52,946$8.46$447,923.16$ 1,165,106.62$717,183.46$ 3.052 234,988$1.368$321,463.62$395,719.84
<br />RDSM 1,078$8.46$9,119.88$ 32,796.89$23,677.01$ 3.052 7,758$1.368$10,612.76$13,064.25
<br />GSLM 4,671$8.46$39,516.66$ 648,198.85$608,682.19$ 3.630 167,681$1.368$229,387.67$379,294.52
<br />GSMM 64 $8.46$541.44$ 40,741.25$40,199.81$ 4.665 8,617$1.368$11,788.50$28,411.31
<br />GSHM 135$8.46$1,142.10$ 65,078.66$63,936.56$ 6.046 10,575$1.368$14,466.62$49,469.94
<br />VHSM 233$8.46$1,971.18$ 66,115.57$64,144.39$ 7.429 8,634$1.368$11,811.75$52,332.64
<br />SHSM 15 $8.46$126.90$ 27,867.14$27,740.24$ 8.812 3,148$1.368$4,306.47$23,433.77
<br />GSLH 1 $8.46$8.46$ 14,523.38$14,514.92$ 3.630 3,999$1.368$5,470.09$9,044.83
<br />FSWR 50 $8.46$423.00$ 5,523.41 $5,100.41$ 3.052 1,671$1.368$2,286.16$2,814.25
<br />FSW2 1 $8.46$8.46$ 2,241.01 $2,232.55$ 3.630 615$1.368$841.36$1,391.19
<br />MSWR 2 $8.46$16.92$ 1,660.92 $1,644.00$ 3.630 453$1.368$619.56$1,024.44
<br />SMLM 2 $8.46$16.92$ 1,091.40 $1,074.48$ 3.630 296$1.368$404.93$669.55
<br />Tot WW59,198$500,815.08$2,070,945.10$1,570,130.02448,435$613,459.49$956,670.53
<br />OKOK$500,815.08
<br />$1,457,485.61
<br />Dec 2008 had a mid lear rate increase on regional only.
<br />Summary for
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)
<br />MWMC TOTAL$1,457,485.6147.69%%Op:%Cap:
<br />double check:
<br />LOCAL WW$613,459.4920.07%14.45%5.62%
<br />20.07%
<br />STORM$985,048.0832.23%25.79%6.45%
<br />32.23%
<br />$3,055,993.18100.0000%
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />TP's direction for FY09 Cap/Op Splits (per FY09 Bud):
<br />These splits come from FY09 budget:
<br />% Cap
<br />% Op
<br />OpCap Net Budget
<br />28%
<br />Local WW72%
<br />$ 5,460,000 $ 2,133,000
<br />$ 7,593,000.00
<br />StormW80%20%
<br />$ 9,258,000 $ 2,265,000
<br />$ 11,523,000.00
<br />We apply these rates to the Local WW and Storm % of total to get the %'s
<br />Debbie needs for her data entry into turnover report.
<br />Monthly WW Summary by Classification
<br />RESLOWMEDHIGHV HighS HighTOTAL
<br />Accounts54,0744,677641352331559,198
<br />Flows 244,417 173,044 8,617 10,575 8,634 3,148 448,435
<br />Avg Flow/Acct 4.52 37.00 134.65 78.33 37.06 209.87 $ 501
<br />
<br />Local Flow Rev$ 334,363 $ 236,724 $ 11,788 $ 14,467 $ 11,812 $ 4,306 $ 613,459
<br />Reg Flow Rev$ 411,598$ 391,425 $ 28,411 $ 49,470 $52,332.64$ 23,434 $ 956,671
<br />Reg Base Rev$ 457,466 $ 39,567 $ 541 $ 1,142 1,971$ 127 $ 500,815
<br />Reg Tot Rev$ 869,064 $ 430,992 $ 28,953 $ 50,612 $ 54,304 $ 23,561 $ 1,457,486
<br />Tot WW Rev$ 1,203,427 $ 667,716 $ 40,741 $ 65,079 $ 66,116 $ 27,867 $ 2,070,945
<br />OK
<br />Monthly Stormwater Summary by Classification
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand Tot
<br />Accounts3,57638,0101,41599443,9957,80951,804
<br />Revenue22,066$ 343,556 $ 23,309 $ 14,301$ 403,231$ 581,817985,048.08
<br />OK
<br />Avg Rev/Acct$ 6.17 $ 9.04$ 16.47 $ 14.39$ 9.17 $ 74.51$ 19.01
<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 />Accounts1081,63327221,790
<br />via lower ESUs
<br />% of TTL Accts3.02%4.30%1.91%2.21%4.07%
<br />Dec 2008 Dec 08.xls1/12/2009
<br />
|