|
<br />
<br />Monthly Split Report for Activity during:May-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 50,508$11.68$581,413.53$ 1,344,916.28 $763,502.75$ 4.285178,180$1.961$349,411.64$414,091.11ok St WTOTAL BILLED
<br />RDSM 818$11.68$9,497.01$ 29,932.20$20,435.19$ 4.2854,769$1.961$9,352.02$11,083.17ok Code# OF ACCTSAMOUNT
<br />GSLM 4,111$11.68$47,679.31$ 699,010.92$651,331.61$ 5.084128,114$1.961$251,231.57$400,100.04ok
<br />from EWEB reportfrom EWEB report
<br />GSMM 68 $11.68$790.74$ 53,069.86$52,279.12$ 6.5128,028$1.961$15,743.14$36,535.98ok STRO2,975$22,600.86
<br />GSHM 136$11.68$1,588.48$ 86,879.01$85,290.53$ 8.41710,133$1.961$19,871.06$65,419.47ok STR610$72.80
<br />VHSM 241$11.68$2,776.73$ 81,423.14$78,646.41$ 10.329 7,614$1.961$14,931.32$63,715.09ok STR714$69.58
<br />SHSM 22 $11.68$256.96$ 65,701.95$65,444.99$ 12.236 5,349$1.961$10,488.53$54,956.46ok STR82$8.78
<br />GSLH -$11.68$0.00$ -$0.00$ 5.0840$1.961$0.00$0.00ok STR9106$208.48
<br />FSWR 42 $11.68$474.66$ 1,993.99$1,519.33$ 4.285355$1.961$695.31$824.02ok STR134,273$384,965.72
<br />FSW2 1$11.68$11.68$ 20,000.00$19,988.32$ 5.0843,932$1.961$7,709.89$12,278.43ok ST1040$418.40
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084472$1.961$926.49$1,475.49ok STR4967$6,462.33
<br />SMLM 2$11.68$23.36$ 836.80$813.44$ 5.084160$1.961$313.76$499.68ok ST1177$440.61
<br />Tot WW55,951$644,535.82$2,386,189.49$1,741,653.67347,106$680,674.74$1,060,978.93STR5691$1,408.52
<br />OKOK$644,535.82STR2392$5,923.28
<br />$1,705,514.75ST120$0.00
<br />ST133$28.38
<br />New in FY11 - ROW Fees calculations
<br />Summary for
<br />Monthly
<br />TurnoverST140$0.00
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$0ST151$3.68
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$0STR3302$6,713.04
<br />Op and Cap both
<br />MWMC TOTAL$1,705,514.7548.21%%Op:%Cap:Reg WW Share:$0ST161$20.44
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$680,674.7419.24%14.74%4.94%$0ST175$64.95
<br />may have occasional rounding error - ok to adjust on mto
<br />19.68%
<br />STORM$1,151,476.6932.55%27.02%5.53%ST180$0.00
<br />32.55%
<br />$3,537,666.18100.0000%$0ST195$18.40
<br />= 6% of Storm share for ROW Fees
<br />$0ST2014$132.44
<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 />$0ST210$0.00
<br />total ROW revenue to fund 131
<br />ST220$0.00
<br />ST230$0.00
<br />↓
<br />ST240$0.00
<br />*Op/Cap totals below changed incorrectly to slide $200k from Op to Cap in WW.
<br />ST2512$59.64
<br />this was left as is and will correct on June Report.
<br />ST262$9.36
<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 />Local WW76.62%23%$ 6,764,225 $ 2,063,975 ST290$0.00
<br />$ 8,828,200.00
<br />StormW83.00%17%$ 12,034,000 $ 2,465,000 ST305$64.95
<br />$ 14,499,000.00
<br />ST311$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
<br />ST320$0.00
<br />reflect new budget. Other months will populate automatically.
<br />ST330$0.00
<br />Monthly WW Summary by ClassificationST341$3.68
<br />RESLOWMEDHIGHV HighS HighTOTALST353$13.46
<br />Accounts51,3684,116681362412255,951ST360$0.00
<br />Flows 183,304 132,678 8,028 10,133 7,614 5,349 347,106 ST370$0.00
<br />Avg Flow/Acct 3.57 32.23 118.06 74.51 31.59 243.12 $ 503 ST380$0.00
<br />
<br />Local Flow Rev$ 359,459 $ 260,182 $ 15,743 $ 19,871 $ 14,931 $ 10,489 $ 680,675 ST390$0.00
<br />Reg Flow Rev$ 425,998$ 414,354 $ 36,536 $ 65,419 $63,715.09$ 54,956 $ 1,060,979 STW042$8,206.23
<br />Reg Base Rev$ 591,385 $ 47,738 $ 791 $ 1,588 2,777$ 257 $ 644,536 STW17,197$677,346.75
<br />Reg Tot Rev$ 1,017,383 $ 462,091 $ 37,327 $ 67,008 $ 66,492 $ 55,213 $ 1,705,515 STW21,442$29,156.65
<br />
<br />Tot WW Rev$ 1,376,842 $ 722,273 $ 53,070 $ 86,879 $ 81,423 $ 65,702 $ 2,386,189 STWB30$92.70
<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 TotSTB13$5.87
<br />Accounts3,10736,0481,47274841,3757,28548,660STB20$0.00
<br />Revenue22,961393,69629,249$ 13,088 $ 458,993 692,4831,151,476.69
<br />OK
<br />Avg Rev/Acct$ 7.39$ 10.92 $ 19.87$ 17.50$ 11.09$ 95.06$ 23.66 Tot STRM48,660$1,151,476.
<br />69
<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 />Accounts1321,77530191,956
<br />via lower ESUs
<br />% of TTL Accts4.25%4.92%2.04%2.54%4.73%
<br />May 2014 May traditional split report.xlsx6/13/2014
<br />
|