|
<br />Monthly Split Report for Activity during:Nov-13
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC's
<br />BILLING
<br />RateBasicBasic ChargesTotalAmount billedFY14 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 52,205$11.68$609,754.40$ 1,359,560.97$749,806.57$ 4.285 174,984$1.961$343,143.68$406,662.89 St WTOTAL BILLED
<br />RDSM 952$11.68$11,119.36$ 33,127.30$22,007.94$ 4.285 5,136$1.961$10,071.78$11,936.16 Code# OF ACCTSAMOUNT
<br />GSLM 4,423$11.68$51,660.64$ 703,629.37$651,968.73$ 5.084 128,239$1.961$251,477.32$400,491.41
<br />from EWEB reportfrom EWEB report
<br />GSMM 72$11.68$840.96$ 53,500.46$52,659.50$ 6.512 8,087$1.961$15,857.69$36,801.81 STRO3,206$24,621.45
<br />GSHM 140$11.68$1,635.20$ 81,116.64$79,481.44$ 8.417 9,443$1.961$18,517.66$60,963.78 STR612$79.84
<br />VHSM 241$11.68$2,814.88$ 79,616.63$76,801.75$ 10.329 7,436$1.961$14,581.10$62,220.65STR715$74.55
<br />SHSM 20$11.68$233.60$ 39,750.65$39,517.05$ 12.236 3,230$1.961$6,333.19$33,183.86 STR81$4.39
<br />GSLH -$11.68$0.00$ - $0.00$ 5.084 0$1.961$0.00$0.00 STR9103$212.78
<br />FSWR 45$11.68$525.60$ 9,612.89$9,087.29$ 4.285 2,121$1.961$4,158.73$4,928.56 STR135,282$396,794.92
<br />FSW2 1$11.68$11.68$ 18,409.50$18,397.82$ 5.084 3,619$1.961$7,096.41$11,301.41 ST1041$428.86
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472$1.961$926.49$1,475.49 STR4982$6,538.24
<br />SMLM 2$11.68$23.36$ 557.18$533.82$ 5.084 105$1.961$205.91$327.92 ST1172$417.60
<br />Tot WW58,103$678,643.04$2,381,306.93$1,702,663.89342,871$672,369.96$1,030,293.93STR5684$1,401.18
<br />OKOK$678,643.04STR2474$7,112.52
<br />$1,708,936.97ST121$14.08
<br />ST134$37.84
<br />ST141$8.30
<br />ST151$3.68
<br />STR3346$7,573.83
<br />ST161$20.44
<br />November - Energy Share is now in EWEB's per account charge, per new contract.
<br />New in FY11 - ROW Fees calculationsST175$64.95
<br />Summary for
<br />$3,235,185ST180$0.00
<br />EWEB Check =<-- enter this amount each month
<br />Storm Share:$1,071,493ST195$18.40
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$610,803ST2014$132.44
<br />Op and Cap both
<br />MWMC TOTAL$1,708,936.9748.00%%Op:%Cap:Reg WW Share:$1,552,889ST210$0.00
<br />double check:should match Reg Rev on MTO
<br />LOCAL WW$672,369.9618.88%14.47%4.42%$3,235,185ST220$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />18.88%
<br />STORM$1,179,177.5733.12%27.49%5.63%ST230$0.00
<br />33.12%
<br />$3,560,484.50100.0000%$64,290ST240$0.00
<br />= 6% of Storm share for ROW Fees
<br />$36,648ST2526$129.22
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies= 6% of local WW share for ROW Fees
<br />$100,938ST262$9.36
<br />total ROW revenue to fund 131
<br />TP's direction for FY14 Cap/Op Splits (per FY14 Bud):
<br />Enter current budget here: (bold&shaded items)ST270$0.00
<br />% Cap
<br />% OpST280$0.00
<br />OpCap Net Budget
<br />23%
<br />Local WW77%$ 6,764,225 $ 2,063,975 ST290$0.00
<br />$ 8,828,200.00
<br />StormW83%17%$ 12,034,000 $ 2,465,000 ST306$77.94
<br />$ 14,499,000.00
<br />ST311$12.06
<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 reflect
<br />ST321$8.34
<br />new budget. Other months will populate automatically.
<br />ST330$0.00
<br />Monthly WW Summary by ClassificationST341$3.68
<br />RESLOWMEDHIGHV HighS HighTOTALST354$26.92
<br />Accounts53,2024,428721402412058,103ST360$0.00
<br />Flows 182,241 132,436 8,087 9,443 7,436 3,230 342,871 ST370$0.00
<br />
<br />Avg Flow/Acct 3.43 29.91 112.31 67.45 30.85 161.48 $ 405
<br />ST380$0.00
<br />Local Flow Rev$ 357,374 $ 259,706 $ 15,858 $ 18,518 $ 14,581 $ 6,333 $ 672,370 ST390$0.00
<br />Reg Flow Rev$ 423,528 $ 413,596 $ 36,802 $ 60,964 $62,220.65$ 33,184 $ 1,030,294 STW043$8,233.76
<br />Reg Base Rev$ 621,399 $ 51,719 $ 841 $ 1,635 2,815$ 234 $ 678,643 STW17,605$688,648.35
<br />Reg Tot Rev$ 1,044,927 $ 465,315 $ 37,643 $ 62,599 $ 65,036 $ 33,417 $ 1,708,937 STW21,451$29,409.61
<br />
<br />Tot WW Rev$ 1,402,301 $ 725,021 $ 53,500 $ 81,117 $ 79,617 $ 39,751 $ 2,381,307 STWB31$95.79
<br />OK
<br />STW31$23.95
<br />STW944$6,935.83
<br />Monthly Stormwater Summary by ClassificationFSTR0$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB13$2.47
<br />Accounts3,33737,0611,48289442,7747,69550,469STB20$0.00
<br />Revenue$ 24,993 $ 405,581$ 29,505$ 15,278 $ 475,357$ 703,8201,179,177.57
<br />OK
<br />Avg Rev/Acct$ 7.49 $ 10.94$ 19.91$ 17.09 $ 11.11$ 91.46$ 23.36 Tot
<br />STRM50,469$1,179,177.57
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />TOTAL
<br />w/reductionsw/reductionsreductionsreductions
<br />Accounts1311,77931231,964
<br />% of TTL Accts3.93%4.80%2.09%2.57%13.39%
<br />Nov 2013 FY14 split with Tish edits 072913 .xlsx12/20/2013
<br />
|