|
<br />Monthly Split Report for Activity during:Jan-14
<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,198$11.68$609,672.64$ 1,577,491.04 $967,818.40$ 4.285 225,861.94$1.961$442,915.26$524,903.14 St WTOTAL BILLED
<br />RDSM 940$11.68$10,979.20$ 40,838.02$29,858.82$ 4.285 6,968.22$1.961$13,664.68$16,194.14 Code# OF ACCTSAMOUNT
<br />GSLM 4,432$11.68$51,765.76$ 781,792.22$730,026.46$ 5.084 143,592.93$1.961$281,585.74$448,440.72
<br />from EWEB reportfrom EWEB report
<br />GSMM 71 $11.68$829.28$ 58,136.49$57,307.21$ 6.512 8,800.25$1.961$17,257.28$40,049.93 STRO3,209$24,709.22
<br />GSHM 142$11.68$1,658.56$ 86,388.85$84,730.29$ 8.417 10,066.57$1.961$19,740.54$64,989.75 STR610$72.80
<br />VHSM 243$11.68$2,838.24$ 84,287.63$81,449.39$ 10.329 7,885.51$1.961$15,463.48$65,985.91STR715$74.55
<br />SHSM 20 $11.68$233.60$ 50,534.72$50,301.12$ 12.236 4,110.91$1.961$8,061.50$42,239.62 STR82$8.78
<br />GSLH -$11.68$0.00$ -$0.00$ 5.084 0.00$1.961$0.00$0.00 STR9104$213.21
<br />FSWR 46 $11.68$537.28$ 10,689.28$10,152.00$ 4.285 2,369.19$1.961$4,645.99$5,506.01 STR135,294$397,658.53
<br />FSW2 1$11.68$11.68$ 5,932.93$5,921.25$ 5.084 1,164.68$1.961$2,283.94$3,637.31 ST1041$428.86
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472.46$1.961$926.49$1,475.49 STR4976$6,531.27
<br />SMLM 2$11.68$23.36$ 491.09$467.73$ 5.084 92.00$1.961$180.41$287.32 ST1177$444.86
<br />Tot WW58,097$678,572.96$2,699,007.61$2,020,434.65411,385$806,725.31$1,213,709.34STR5686$1,408.38
<br />OKOK$678,572.96STR2470$7,130.28
<br />$1,892,282.30ST121$14.08
<br />ST134$37.84
<br />ST141$8.30
<br />ST151$3.68
<br />STR3339$7,501.73
<br />New in FY11 - ROW Fees calculationsST161$20.44
<br />$3,961,007ST176$74.04
<br />EWEB Check +$3k =<-- enter this amount each month
<br />SummarStorm Share:$1,208,107ST180$0.00
<br />Op and Cap both
<br />Local WW Share:$822,701ST195$18.40
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Reg WW Share:$1,930,199ST2014$132.44
<br />should match Reg Rev on MTO
<br />MWMC TOTAL$1,892,282.3048.73%%Op:%Cap:$3,961,007ST210$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />double check:
<br />LOCAL WW$806,725.3120.77%15.92%4.86%ST220$0.00
<br />20.77%
<br />STORM$1,184,297.7030.50%25.31%5.18%$72,486ST230$0.00
<br />= 6% of Storm share for ROW Fees
<br />30.50%
<br />$3,883,305.31100.0000%$49,362ST240$0.00
<br />= 6% of local WW share for ROW Fees
<br />$121,848ST2527$129.72
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />total ROW revenue to fund 131
<br />ST266$28.08
<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
<br />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
<br />ST321$8.34
<br />reflect 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,1844,437711422432058,097ST360$0.00
<br />Flows 235,199 145,322 8,800 10,067 7,886 4,111 411,385 ST370$0.00
<br />Avg Flow/Acct 4.42 32.75 123.95 70.89 32.45 205.55 $ 470 ST380$0.00
<br />
<br />Local Flow Rev$ 461,226 $ 284,977 $ 17,257 $ 19,741 $ 15,463 $ 8,061 $ 806,725 ST390$0.00
<br />Reg Flow Rev$ 546,603$ 453,841 $ 40,050 $ 64,990 $65,985.91$ 42,240 $ 1,213,709 STW043$8,233.76
<br />Reg Base Rev$ 621,189 $ 51,824 $ 829 $ 1,659 2,838$ 234 $ 678,573 STW17,591$692,809.08
<br />Reg Tot Rev$ 1,167,792 $ 505,665 $ 40,879 $ 66,648 $ 68,824 $ 42,473 $ 1,892,282 STW21,451$29,432.27
<br />
<br />Tot WW Rev$ 1,629,018 $ 790,642 $ 58,136 $ 86,389 $ 84,288 $ 50,535 $ 2,699,008 STWB31$95.79
<br />OK
<br />STW31$23.95
<br />STW943$6,924.42
<br />Monthly Stormwater Summary by ClassificationFSTR0$0.00
<br />Small SFDMed SFDLarge ResiduplexesSubtotal ResiGen + miscGrand TotSTB10$0.00
<br />Accounts3,34037,0741,48288942,7857,67850,463STB21$0.00
<br />Revenue25,079$ 406,472$ 29,528$ 15,252$ 476,330 $ 707,9671,184,297.70
<br />OK
<br />Avg Rev/Acct$ 7.51$ 10.96 $ 19.92$ 17.16 $ 11.13$ 92.21$ 23.47 Tot STRM50,463$1,184,2
<br />97.70
<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 />commercial participates but receives credits
<br />Accounts1311,78031281,970
<br />via lower ESUs
<br />% of TTL Accts3.92%4.80%2.09%3.15%4.60%
<br />Jan 2014 FY14 split with Tish edits 072913 .xlsx2/14/2014
<br />
|