|
<br />Monthly Split Report for Activity during:Mar-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 54,091$11.68$623,552.25$ 1,532,497.47 $908,945.22$ 4.285 212,123$1.961$415,972.36$492,972.86 St WTOTAL BILLED
<br />RDSM 1,060$11.68$12,433.74$ 42,770.85$30,337.11$ 4.285 7,080$1.961$13,883.56$16,453.55 Code# OF ACCTSAMOUNT
<br />GSLM 4,723$11.68$54,934.56$ 824,231.37$769,296.81$ 5.084 151,317$1.961$296,733.09$472,563.72
<br />from EWEB reportfrom EWEB report
<br />GSMM 71 $11.68$829.28$ 55,504.00$54,674.72$ 6.512 8,396$1.961$16,464.55$38,210.17 STRO3,483$26,654.83
<br />GSHM 142$11.68$1,658.56$ 83,563.48$81,904.92$ 8.417 9,731$1.961$19,082.28$62,822.64 STR610$72.80
<br />VHSM 250$11.68$2,860.44$ 85,928.08$83,067.64$ 10.329 8,042$1.961$15,770.71$67,296.93STR716$77.20
<br />SHSM 22 $11.68$256.96$ 72,716.40$72,459.44$ 12.236 5,922$1.961$11,612.70$60,846.74 STR82$8.78
<br />GSLH -$11.68$0.00$ -$0.00$ 5.084 0$1.961$0.00$0.00 STR9106$212.22
<br />FSWR 43 $11.68$490.56$ 2,657.19$2,166.63$ 4.285 506$1.961$991.54$1,175.09 STR136,476$410,673.94
<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 ST1042$439.32
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472$1.961$926.49$1,475.49 STR4996$6,604.29
<br />SMLM 2$11.68$23.36$ 791.05$767.69$ 5.084 151$1.961$296.11$471.58 ST1178$446.41
<br />Tot WW60,407$697,074.75$2,723,085.23$2,026,010.48407,671$799,443.29$1,226,567.19STR5695$1,413.57
<br />OKOK$697,074.75STR2549$8,239.77
<br />$1,923,641.94ST122$28.16
<br />ST135$47.30
<br />ST142$16.60
<br />ST151$3.68
<br />STR3371$8,270.33
<br />ST161$20.44
<br />New in FY11 - ROW Fees calculationsST174$51.96
<br />Summary for
<br />ST180$0.00
<br />EWEB Check +$3k =<-- enter this amount each month
<br />Storm Share:$0ST195$18.40
<br />Op and Cap both
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)Local WW Share:$0ST2014$132.44
<br />Op and Cap both
<br />MWMC TOTAL$1,923,641.9448.85%%Op:%Cap:Reg WW Share:$0ST210$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$799,443.2920.30%15.56%4.75%$0ST220$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />20.30%
<br />STORM$1,214,580.4730.85%25.60%5.24%ST230$0.00
<br />30.85%
<br />$3,937,665.70100.0000%$0ST240$0.00
<br />= 6% of Storm share for ROW Fees
<br />$0ST2540$198.80
<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 />$0ST2610$46.80
<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)
<br />ST270$0.00
<br />% Cap
<br />% OpST280$0.00
<br />OpCap
<br />Net Budget
<br />23%
<br />Local WW76.62%$ 6,764,225 $ 2,063,975 ST290$0.00
<br />$ 8,828,200.00
<br />StormW83.00%17%$ 12,034,000 $ 2,465,000 ST307$90.93
<br />$ 14,499,000.00
<br />ST312$24.12
<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 HighTOTALST356$40.38
<br />Accounts55,1944,728711422502260,407ST360$0.00
<br />Flows 219,708 155,872 8,396 9,731 8,042 5,922 407,671 ST370$0.00
<br />Avg Flow/Acct 3.98 32.97 118.25 68.53 32.17 269.17 $ 525 ST380$0.00
<br />
<br />Local Flow Rev$ 430,847 $ 305,666 $ 16,465 $ 19,082 $ 15,771 $ 11,613 $ 799,443 ST390$0.00
<br />Reg Flow Rev$ 510,601$ 486,789 $ 38,210 $ 62,823 $67,296.93$ 60,847 $ 1,226,567 STW044$8,261.29
<br />Reg Base Rev$ 636,477 $ 54,993 $ 829 $ 1,659 2,860$ 257 $ 697,075 STW17,965$705,854.90
<br />Reg Tot Rev$ 1,147,078 $ 541,782 $ 39,039 $ 64,481 $ 70,157 $ 61,104 $ 1,923,642 STW21,458$29,571.85
<br />
<br />Tot WW Rev$ 1,577,926 $ 847,448 $ 55,504 $ 83,563 $ 85,928 $ 72,716 $ 2,723,085 STWB33$98.57
<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,61738,2871,4911,02244,4178,05252,469STB22$0.00
<br />Revenue27,026$ 419,578$ 29,670$ 17,266$ 493,540 $ 721,0411,214,580.47
<br />OK
<br />Avg Rev/Acct$ 7.47$ 10.96 $ 19.90$ 16.89 $ 11.11$ 89.55$ 23.15 Tot STRM52,471$1,214,5
<br />80.47
<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.62%4.65%2.08%2.74%4.44%
<br />March 2014 March 14 Monthly Traditiional Split.xlsx4/4/2014
<br />
|