|
<br />Monthly Split Report for Activity during:Apr-14
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />WWMWMC'sMWMC'sBILLING
<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,393$11.68$602,645.56$ 1,508,335.09 $905,689.53$ 4.285 211,363$1.961$414,482.42$491,207.11ok St W
<br />RDSM 938$11.68$10,893.93$ 38,230.19$27,336.26$ 4.285 6,380$1.961$12,510.25$14,826.01ok Code# OF ACCTS
<br />GSLM 4,425$11.68$51,376.42$ 803,286.25$751,909.83$ 5.084 147,897$1.961$290,026.59$461,883.24ok
<br />from EWEB report
<br />GSMM 71 $11.68$829.28$ 56,832.13$56,002.85$ 6.512 8,600$1.961$16,864.49$39,138.36ok STRO3,242
<br />GSHM 141$11.68$1,625.08$ 90,299.93$88,674.85$ 8.417 10,535$1.961$20,659.54$68,015.31ok STR610
<br />VHSM 245$11.68$2,840.96$ 92,167.11$89,326.15$ 10.329 8,648$1.961$16,958.91$72,367.24ok STR715
<br />SHSM 22 $11.68$256.96$ 75,754.44$75,497.48$ 12.236 6,170$1.961$12,099.59$63,397.89ok STR82
<br />GSLH -$11.68$0.00$ -$0.00$ 5.084 0$1.961$0.00$0.00ok STR9107
<br />FSWR 41 $11.68$478.88$ 2,029.81$1,550.93$ 4.285 362$1.961$709.77$841.16oops!STR135,418
<br />FSW2 1$11.68$11.68$ 7,578.38$7,566.70$ 5.084 1,488$1.961$2,918.63$4,648.07ok ST1041
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472$1.961$926.49$1,475.49ok STR4983
<br />SMLM 2$11.68$23.36$ 1,055.41$1,032.05$ 5.084 203$1.961$398.08$633.97ok ST1176
<br />Tot WW58,281$671,005.47$2,677,994.08$2,006,988.61402,119$788,554.76$1,218,433.85STR5691
<br />OKOK$671,005.47STR2470
<br />$1,889,439.32ST121
<br />ST134
<br />New in FY11 - ROW Fees calculationsST141
<br />Summary for
<br />Monthly
<br />Turnover
<br />ST151
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$0STR3339
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$0ST161
<br />Op and Cap both
<br />MWMC TOTAL$1,889,439.3248.91%%Op:%Cap:Reg WW Share:$0ST176
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$788,554.7620.41%15.64%4.77%$0ST180
<br />may have occasional rounding error - ok to adjust on mto
<br />20.41%
<br />STORM$1,185,337.0530.68%25.47%5.22%ST195
<br />30.68%
<br />$3,863,331.13100.0000%$0ST2014
<br />= 6% of Storm share for ROW Fees
<br />$0ST210
<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 />$0ST220
<br />total ROW revenue to fund 131
<br />ST230
<br />TP's direction for FY14 Cap/Op Splits (per FY14 Bud):
<br />Enter current budget here: (bold&shaded items)ST240
<br />% Cap
<br />% OpST2526
<br />OpCap
<br />Net Budget
<br />23%
<br />Local WW76.62%$ 6,764,225 $ 2,063,975 ST266
<br />$ 8,828,200.00
<br />StormW83.00%17%$ 12,034,000 $ 2,465,000 ST270
<br />$ 14,499,000.00
<br />ST280
<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 />ST290
<br />reflect new budget. Other months will populate automatically.
<br />ST306
<br />ST311
<br />ST321
<br />ST330
<br />Monthly WW Summary by ClassificationST341
<br />RESLOWMEDHIGHV HighS HighTOTALST354
<br />Accounts53,3724,430711412452258,281ST360
<br />Flows 218,104 150,061 8,600 10,535 8,648 6,170 402,119 ST370
<br />Avg Flow/Acct 4.09 33.87 121.13 74.72 35.30 280.46 $ 550 ST380
<br />
<br />Local Flow Rev$ 427,702 $ 294,270 $ 16,864 $ 20,660 $ 16,959 $ 12,100 $ 788,555 ST390
<br />Reg Flow Rev$ 506,874$ 468,641 $ 39,138 $ 68,015 $72,367.24$ 63,398 $ 1,218,434 STW043
<br />Reg Base Rev$ 614,018 $ 51,435 $ 829 $ 1,625 2,841$ 257 $ 671,005 STW17,603
<br />Reg Tot Rev$ 1,120,893 $ 520,076 $ 39,968 $ 69,640 $ 75,208 $ 63,655 $ 1,889,439 STW21,453
<br />Tot WW Rev$ 1,548,595 $ 814,345 $ 56,832 $ 90,300 $ 92,167 $ 75,754 $ 2,677,994 STWB31
<br />OK
<br />STW31
<br />STW943
<br />Monthly Stormwater Summary by ClassificationFSTR0
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB12
<br />Accounts3,37637,2091,48488842,9577,69250,649STB21
<br />Revenue24,975$ 406,818$ 29,540$ 15,204$ 476,537 $ 708,8011,185,337.05
<br />OK
<br />Avg Rev/Acct$ 7.40$ 10.93 $ 19.91$ 17.12 $ 11.09$ 92.15$ 23.40 Tot STRM50,649
<br />
<br />Monthly Stormwater Q & Q Summary by Classification
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />w/reductionsw/reductionsreductionsreductionsTOTAL
<br />commercial participates but receives credits
<br />Accounts1341,79131281,984
<br />via lower ESUs
<br />% of TTL Accts3.97%4.81%2.09%3.15%4.62%
<br />April 2014 FY14 split with Tish edits 072913 .xlsx5/13/2014
<br />
<br />
|