|
<br />Monthly Split Report for Activity during:Nov-09
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />BILLING
<br />WWMWMC'sMWMC's
<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,963 $9.98$498,630.74$ 1,174,515.91 $675,885.17$ 3.682183,565$1.696$311,325.71$364,559.46 St WTOTAL BILLED
<br />RDSM 825$9.98$8,233.50$ 25,998.96$17,765.46$ 3.6824,825$1.696$8,183.11$9,582.35 Code# OF ACCTSAMOUNT
<br />GSLM 4,057$9.98$40,488.86$ 590,485.65$549,996.79$ 4.365126,002$1.696$213,698.64$336,298.15
<br />from EWEB reportfrom EWEB report
<br />GSMM 63$9.98$628.74$ 42,663.27$42,034.53$ 5.5867,525$1.696$12,762.36$29,272.17 STRO2,958$19,342.02
<br />GSHM 132$9.98$1,317.36$ 66,602.14$65,284.78$ 7.2169,047$1.696$15,344.09$49,940.69 STR61$6.28
<br />VHSM 225$9.98$2,245.50$ 74,455.95$72,210.45$ 8.8498,160$1.696$13,839.86$58,370.59STR711$47.19
<br />SHSM 15$9.98$149.70$ 34,019.64$33,869.94$ 10.4803,232$1.696$5,481.24$28,388.70 STR81$3.79
<br />GSLH 1$9.98$9.98$ 3,800.98$3,791.00$ 4.365868$1.696$1,472.98$2,318.02 STR995$160.68
<br />FSWR 48$9.98$479.04$ 9,195.70$8,716.66$ 3.6822,367$1.696$4,015.06$4,701.60 STR134,094$329,241.01
<br />FSW2 1$9.98$9.98$ 13,200.00$13,190.02$ 4.3653,022$1.696$5,124.92$8,065.10 ST1021$172.89
<br />MSWR 2$9.98$19.96$ 2,082.24$2,062.28$ 4.365472$1.696$801.29$1,260.99 STR4963$5,516.96
<br />SMLM 2$9.98$19.96$ 984.63$964.67$ 4.365221$1.696$374.82$589.85 ST1127$135.00
<br />Tot WW55,334$552,233.32$2,038,005.07$1,485,771.75349,307$592,424.08$893,347.67STR5669$1,167.51
<br />OKOK$552,233.32STR2395$5,166.63
<br />$1,445,580.99ST120$0.00
<br />ST133$24.48
<br />ST140$0.00
<br />ST151$3.17
<br />STR3314$5,882.96
<br />ST161$17.63
<br />Summary for
<br />ST175$56.05
<br />Monthly Turnover
<br />ST180$0.00
<br />ST195$15.11
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST2011$89.76
<br />MWMC TOTAL$1,445,580.9947.81%%Op:%Cap:ST210$0.00
<br />double check:
<br />LOCAL WW$592,424.0819.59%15.34%4.26%ST220$0.00
<br />19.59%
<br />STORM$985,449.1532.59%28.37%4.22%ST230$0.00
<br />32.59%
<br />$3,023,454.22100.0000%ST240$0.00
<br />ST257$29.96
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST262$8.06
<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 ST302$22.40
<br />$ 11,648,100.00
<br />ST310$0.00
<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 />Accounts50,8364,063631322251555,334ST360$0.00
<br />Flows 190,757 130,585 7,525 9,047 8,160 3,232 349,307 ST370$0.00
<br />Avg Flow/Acct 3.75 32.14 119.44 68.54 36.27 215.46 $ 476 ST380$0.00
<br />
<br />Local Flow Rev$ 323,524 $ 221,473 $ 12,762 $ 15,344 $ 13,840 $ 5,481 $ 592,424 ST390$0.00
<br />Reg Flow Rev$ 378,843 $ 348,532 $ 29,272 $ 49,941$58,370.59$ 28,389$ 893,348 STW043$7,001.62
<br />Reg Base Rev$ 507,343 $ 40,549 $ 629 $ 1,317 2,246$ 150 $ 552,233 STW16,946$580,374.59
<br />Reg Tot Rev$ 886,187 $ 389,081 $ 29,901 $ 51,258 $ 60,616 $ 28,538 $ 1,445,581 STW21,393$24,370.39
<br />Tot WW Rev$ 1,209,711 $ 610,554 $ 42,663 $ 66,602 $ 74,456 $ 34,020 $ 2,038,005 STWB26$66.75
<br />OK
<br />STW31$20.67
<br />STW946$6,480.55
<br />Monthly Stormwater Summary by ClassificationFSTR0$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB14$3.06
<br />Accounts3,06635,7741,41975141,0107,03948,049STB20$0.00
<br />Revenue$ 19,560$ 336,233$ 24,437$ 11,359$ 391,589 $ 593,860 985,449.15
<br />OK
<br />Avg Rev/Acct$ 6.38$ 9.40$ 17.22$ 15.12$ 9.55$ 84.37$ 20.51Tot STRM48,049$985,449.15
<br />
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />w/reductionsw/reductionsreductionsreductionsTOTAL
<br />Accounts1081,68026191,833
<br />% of TTL Accts3.52%4.70%1.83%2.53%12.58%
<br />Nov 2009 FY10 Split Report .xlsx12/15/2009
<br />
|