|
<br />Monthly Split Report for Activity during:Dec-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 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 52,189 $11.68$609,567.52$ 1,593,157.94$983,590.42$ 4.285 229,543$1.961$450,133.21$533,457.21 Code# OF ACCTSAMOUNT
<br />RDSM 944$11.68$11,025.92$ 40,957.73$29,931.81$ 4.285 6,985$1.961$13,698.08$16,233.73
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,420$11.68$51,625.60$ 802,822.27$751,196.67$ 5.084 147,757$1.961$289,751.51$461,445.16 STRO3,202$24,616.98
<br />GSMM 71$11.68$829.28$ 59,910.59$59,081.31$ 6.512 9,073$1.961$17,791.53$41,289.78 STR610$72.80
<br />GSHM 140$11.68$1,635.20$ 91,238.05$89,602.85$ 8.417 10,645$1.961$20,875.75$68,727.10 STR715$74.55
<br />VHSM 245$11.68$2,861.60$ 93,100.53$90,238.93$ 10.3298,736$1.961$17,132.20$73,106.73STR82$8.78
<br />SHSM 20$11.68$233.60$ 60,875.23$60,641.63$ 12.2364,956$1.961$9,718.72$50,922.91 STR9104$212.64
<br />GSLH -$11.68$0.00$ - $0.00$ 5.084 0$1.961$0.00$0.00 STR135,302$397,667.49
<br />FSWR 46$11.68$537.28$ 11,181.89$10,644.61$ 4.285 2,484$1.961$4,871.43$5,773.18 ST1042$429.56
<br />FSW2 1$11.68$11.68$ 20,000.00$19,988.32$ 5.084 3,932$1.961$7,709.89$12,278.43 STR4987$6,555.11
<br />MSWR 2$11.68$23.36$ 2,425.34 $2,401.98$ 5.084 472$1.961$926.49$1,475.49 ST1176$440.80
<br />SMLM 2$11.68$23.36$ 379.24$355.88$ 5.084 70$1.961$137.27$218.61 STR5685$1,402.40
<br />Tot WW58,080$678,374.40$2,776,048.81$2,097,674.41424,654$832,746.09$1,264,928.32STR2468$7,114.03
<br />OKOK$678,374.40ST121$14.08
<br />$1,943,302.72ST134$37.84
<br />ST141$8.30
<br />ST151$3.68
<br />STR3344$7,534.43
<br />ST161$20.44
<br />ST175$64.95
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,718,422ST195$18.40
<br />EWEB Check =<-- enter this amount each month
<br />Storm Share:$1,112,924ST2015$132.44
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$781,612ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,943,302.7249.05%%Op:%Cap:Reg WW Share:$1,823,886ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$832,746.0921.02%16.10%4.91%$3,718,422ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />21.02%
<br />STORM$1,185,894.5229.93%24.84%5.09%ST240$0.00
<br />29.93%
<br />$3,961,943.33100.0000%$66,775ST2526$129.22
<br />= 6% of Storm share for ROW Fees
<br />$46,897ST262$9.36
<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 />$113,672ST270$0.00
<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)ST280$0.00
<br />% Cap
<br />% OpST290$0.00
<br />Net Budget
<br />OpCap
<br />23%
<br />Local WW77%$ 6,764,225 $ 2,063,975 ST306$77.94
<br />$ 8,828,200.00
<br />StormW83%17%$ 12,034,000 $ 2,465,000 ST311$12.06
<br />$ 14,499,000.00
<br />ST321$8.34
<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 />ST330$0.00
<br />new budget. Other months will populate automatically.
<br />ST341$3.68
<br />Monthly WW Summary by ClassificationST354$26.92
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts53,1794,425711402452058,080ST370$0.00
<br />Flows 239,012 152,231 9,073 10,645 8,736 4,956 424,654 ST380$0.00
<br />
<br />Avg Flow/Acct 4.49 34.40 127.78 76.04 35.66 247.80 $ 526
<br />ST390$0.00
<br />Local Flow Rev$ 468,703 $ 298,525 $ 17,792 $ 20,876 $ 17,132 $ 9,719 $ 832,746 STW043$8,233.76
<br />
<br />Reg Flow Rev$ 555,464$ 475,418 $ 41,290 $ 68,727$73,106.73$ 50,923 $ 1,264,928 STW17,597$694,504.11
<br />Reg Base Rev$ 621,131 $ 51,684 $ 829 $ 1,635 2,862$ 234 $ 678,374 STW21,450$29,403.86
<br />Reg Tot Rev$ 1,176,595 $ 527,102 $ 42,119 $ 70,362 $ 75,968 $ 51,157 $ 1,943,303 STWB31$95.79
<br />
<br />Tot WW Rev$ 1,645,298 $ 825,627 $ 59,911 $ 91,238 $ 93,101 $ 60,875 $ 2,776,049 STW31$23.95
<br />OK
<br />STW944$6,935.83
<br />FSTR0$0.00
<br />Monthly Stormwater Summary by ClassificationSTB10$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB21$0.00
<br />Accounts3,33337,0921,48188742,7937,68550,478
<br />Revenue24,986$ 406,495 $ 29,500 $ 15,240$ 476,221$ 709,6741,185,894.52Tot STRM50,478$1,185,894.52
<br />OK
<br />Avg Rev/Acct$ 7.50$ 10.96$ 19.92$ 17.18$ 11.13$ 92.35$ 23.49
<br />Monthly Stormwater Q & Q Summary by Resi Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />TOTAL
<br />w/reductionsw/reductionsreductionsreductions
<br />commercial participates but receives credits
<br />Accounts1311,79031231,975
<br />via lower ESUs
<br />% of TTL Accts3.93%4.83%2.09%2.59%4.62%
<br />Dec 2013 FY14 split with Tish edits 072913 .xlsx1/10/2014
<br />
|