|
<br />Monthly Split Report for Activity during:Oct-09
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC'sBILLING
<br />RateBasicBasic ChargesTotalAmount billedFY07 Flow RatesKgals billedCityCityMWMCDouble
<br />Code# Accounts(per acct) ChgBilledBilled Amtfor Flow (MWMC + City)this monthRate per KgalRevenueRevenueCheckStormwater Monthly Info
<br />St WTOTAL BILLED
<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,688$9.98$515,846.24$ 1,276,023.93$760,177.69$ 3.682 206,458$1.696$350,152.46$410,025.23 Code# OF ACCTSAMOUNT
<br />RDSM 957$9.98$9,550.86$ 31,534.68$21,983.82$ 3.682 5,971$1.696$10,126.17$11,857.65
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,383$9.98$43,742.34$ 666,978.93$623,236.59$ 4.365 142,780$1.696$242,155.61$381,080.98 STRO3,221$21,010.27
<br />GSMM 65 $9.98$648.70$ 45,326.50$44,677.80$ 5.586 7,998$1.696$13,564.90$31,112.90 STR61$6.28
<br />GSHM 134$9.98$1,337.32$ 72,121.21$70,783.89$ 7.216 9,809$1.696$16,636.57$54,147.32 STR712$51.48
<br />VHSM 231$9.98$2,305.38$ 79,951.84$77,646.46$ 8.849 8,775$1.696$14,881.73$62,764.73STR81$3.79
<br />SHSM 15 $9.98$149.70$ 35,898.00$35,748.30$ 10.480 3,411$1.696$5,785.22$29,963.08 STR997$163.43
<br />GSLH 1$9.98$9.98$ 4,013.99 $4,004.01$ 4.365 917$1.696$1,555.74$2,448.27 STR135,346$340,412.99
<br />FSWR 49 $9.98$489.02$ 9,200.55 $8,711.53$ 3.682 2,366$1.696$4,012.70$4,698.83 ST1016$114.25
<br />FSW2 1$9.98$9.98$ 10,000.00$9,990.02$ 4.365 2,289$1.696$3,881.57$6,108.45 STR4977$5,569.67
<br />MSWR 2$9.98$19.96$ 2,082.24 $2,062.28$ 4.365 472$1.696$801.29$1,260.99 ST1128$140.00
<br />SMLM 2$9.98$19.96$ (36.78)-$56.74$ 4.365 -13$1.696-$22.05-$34.69 STR5677$566.12
<br />Tot WW57,528$574,129.44$2,233,095.09$1,658,965.65391,233$663,531.92$995,433.73STR2482$6,239.66
<br />OKOK$574,129.44ST120$0.00
<br />$1,569,563.17ST134$32.64
<br />ST141$7.16
<br />ST151$3.17
<br />STR3352$6,579.60
<br />ST161$17.63
<br />ST175$56.05
<br />ST180$0.00
<br />Summary for ST194$12.15
<br />ST2013$97.92
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST210$0.00
<br />MWMC TOTAL$1,569,563.1748.39%%Op:%Cap:ST220$0.00
<br />double check:
<br />LOCAL WW$663,531.9220.45%16.01%4.45%ST230$0.00
<br />20.45%
<br />STORM$1,010,800.1631.16%27.13%4.03%ST240$0.00
<br />31.16%
<br />$3,243,895.25100.0000%ST2512$45.08
<br />ST262$8.06
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST270$0.00
<br />TP's direction for FY10 Cap/Op Splits (per FY10 Bud):
<br />Enter current budget here: (bold&shaded items)ST280$0.00
<br />% Cap
<br />% OpST290$0.00
<br />OpCap Net Budget
<br />22%
<br />Local WW78%$ 6,220,350 $ 1,727,550 ST303$33.60
<br />$ 7,947,900.00
<br />StormW87%13%$ 10,140,100 $ 1,508,000 ST311$10.40
<br />$ 11,648,100.00
<br />ST322$6.95
<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 />ST330$0.00
<br />reflect new budget. Other months will populate automatically.
<br />ST341$3.17
<br />Monthly WW Summary by ClassificationST352$11.62
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts52,6944,389651342311557,528ST370$0.00
<br />Flows 214,794 146,446 7,998 9,809 8,775 3,411 391,233 ST380$0.00
<br />Avg Flow/Acct 4.08 33.37 123.05 73.20 37.99 227.41 $ 499 ST390$0.00
<br />
<br />Local Flow Rev$ 364,291 $ 248,372 $ 13,565 $ 16,637 $ 14,882 $ 5,785 $ 663,532 STW045$7,166.83
<br />
<br />Reg Flow Rev$ 426,582$ 390,864 $ 31,113 $ 54,147 $62,764.73$ 29,963 $ 995,434 STW17,349$591,432.21
<br />Reg Base Rev$ 525,886 $ 43,802 $ 649 $ 1,337 2,305$ 150 $ 574,129 STW21,406$24,513.02
<br />Reg Tot Rev$ 952,468 $ 434,666 $ 31,762 $ 55,485 $ 65,070 $ 30,113 $ 1,569,563 STWB27-$26.55
<br />Tot WW Rev$ 1,316,759 $ 683,038 $ 45,327 $ 72,121 $ 79,952 $ 35,898 $ 2,233,095 STW31$20.67
<br />OK
<br />STW946$6,480.55
<br />FSTR1$0.00
<br />Monthly Stormwater Summary by ClassificationSTB14$10.29
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB20$0.00
<br />Accounts3,33237,0441,43388742,6967,44550,141
<br />Revenue$ 21,235$ 346,803 $ 24,486 $ 13,186$ 405,710$ 605,0901,010,800Tot STRM50,141$1,010,800.16
<br />OK
<br />Avg Rev/Acct$ 6.37 $ 9.36$ 17.09$ 14.87$ 9.50 $ 81.27$ 20.16
<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 />Accounts1111,698279772,813
<br />via lower ESUs
<br />% of TTL Accts3.33%4.58%1.88%110.15%6.59%
<br />Oct 2009 FY10 Split Report .xlsx11/17/2009
<br />
|