|
<br />Monthly Split Report for Activity during:Oct-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 54,238$11.68$633,499.84$ 1,457,483.07 $823,983.23$ 4.285 192,295$1.961$377,090.11$446,893.12 Code# OF ACCTSAMOUNT
<br />RDSM 1,074$11.68$12,544.32$ 38,367.82$25,823.50$ 4.285 6,026$1.961$11,817.94$14,005.56
<br />from EWEB reportfrom EWEB report
<br />GSLM 4,750$11.68$55,480.00$ 718,128.96$662,648.96$ 5.084 130,340$1.961$255,596.89$407,052.07 STRO3,479$26,430.02
<br />GSMM 71 $11.68$829.28$ 55,164.87$54,335.59$ 6.512 8,344$1.961$16,362.42$37,973.17STR611$80.08
<br />within $1
<br />GSHM 144$11.68$1,681.92$ 89,041.61$87,359.69$ 8.417 10,379$1.961$20,353.14$67,006.55 STR717$79.52
<br />VHSM 246$11.68$2,873.28$ 83,892.67$81,019.39$ 10.329 7,844$1.961$15,381.84$65,637.55STR81$4.39
<br />SHSM 15 $11.68$175.20$ 48,638.64$48,463.44$ 12.236 3,961$1.961$7,766.98$40,696.46 STR9105$215.35
<br />GSLH -$11.68$0.00$ -$0.00$ 5.084 0$1.961$0.00$0.00STR136,634$407,310.52
<br />within $5
<br />FSWR 45 $11.68$525.60$ 11,057.81$10,532.21$ 4.285 2,458$1.961$4,819.99$5,712.22 ST1041$426.77
<br />FSW2 1$11.68$11.68$ 16,843.80$16,832.12$ 5.084 3,311$1.961$6,492.48$10,339.64 STR4990$6,580.05
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472$1.961$926.49$1,475.49 ST1174$417.03
<br />SMLM 2$11.68$23.36$ (200,682.80)-$200,706.16$ 5.084 -39,478$1.961-$77,416.36-$123,289.80 STR5687$1,412.61
<br />Tot WW60,588$707,667.84$2,320,361.79$1,612,693.95325,952$639,191.93$973,502.02STR2551$8,280.40
<br />OKOK$707,667.84ST122$28.16
<br />$1,681,169.86ST136$47.30
<br />ST142$16.60
<br />ST151$3.68
<br />STR3380$8,363.99
<br />ST161$20.44
<br />ST177$65.38
<br />New in FY11 - ROW Fees calculationsST180$0.00
<br />Summary for
<br />$3,688,599ST195$18.40
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$1,261,870ST2014$132.44
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$668,374ST210$0.00
<br />Op and Cap both
<br />MWMC TOTAL$1,681,169.8647.67%%Op:%Cap:Reg WW Share:$1,758,355ST220$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$639,191.9318.12%13.89%4.24%$3,688,599ST230$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />18.12%
<br />STORM$1,206,566.8134.21%28.39%5.82%ST240$0.00
<br />34.21%
<br />$3,526,928.60100.0000%$75,712ST2540$198.80
<br />= 6% of Storm share for ROW Fees
<br />$40,102ST262$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 />$115,814ST270$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 />OpCap
<br />Net Budget
<br />23%
<br />Local WW77%$ 6,764,225 $ 2,063,975 ST307$89.20
<br />$ 8,828,200.00
<br />StormW83%17%$ 12,034,000 $ 2,465,000 ST312$24.12
<br />We apply these $ 14,499,000.00
<br />ST321$8.34
<br />rates to the Local
<br />ST330$0.00
<br />ST341$3.68
<br />Monthly WW Summary by ClassificationST356$30.73
<br />RESLOWMEDHIGHV HighS HighTOTALST360$0.00
<br />Accounts55,3574,755711442461560,588ST370$0.00
<br />Flows 200,779 94,645 8,344 10,379 7,844 3,961 325,952 ST380$0.00
<br />
<br />Avg Flow/Acct 3.63 19.90 117.52 72.08 31.89 264.05 $ 509 ST390$0.00
<br />
<br />Local Flow Rev$ 393,728 $ 185,600 $ 16,362 $ 20,353 $ 15,382 $ 7,767 $ 639,192 STW044$8,261.29
<br />
<br />Reg Flow Rev$ 466,611$ 295,577 $ 37,973 $ 67,007 $65,637.55$ 40,696 $ 973,502 STW18,014$701,380.48
<br />Reg Base Rev$ 646,570 $ 55,538 $ 829 $ 1,682 2,873$ 175 $ 707,668 STW21,458$29,569.02
<br />Reg Tot Rev$ 1,113,181 $ 351,116 $ 38,802 $ 68,688 $ 68,511 $ 40,872 $ 1,681,170 STWB32$98.88
<br />Tot WW Rev$ 1,506,909 $ 536,715 $ 55,165 $ 89,042 $ 83,893 $ 48,639 $ 2,320,362 STW31$23.95
<br />OK
<br />STW944$6,935.83
<br />FSTR0$0.00
<br />$ 3,526,928.60
<br />Monthly Stormwater Summary by ClassificationSTB10$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB20$0.00
<br />Accounts3,61338,4261,4901,02944,5588,10252,660
<br />Revenue$ 26,809$ 416,147$ 29,668$ 17,365$ 489,989 $ 716,5781,206,567Tot STRM52,660$1,206,566.81
<br />OK
<br />Avg Rev/Acct$ 7.42$ 10.83 $ 19.91$ 16.88 $ 11.00$ 88.44$ 22.91
<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 />Accounts1341,792321,1033,061
<br />via lower ESUs
<br />% of TTL Accts3.71%4.66%2.15%107.19%6.87%
<br />Oct 2013 FY14 split with Tish edits 072913 .xlsx11/15/2013
<br />
|