|
<br />Monthly Split Report for Activity during:Feb-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,302$11.68$580,971.81$ 1,420,416.64 $839,444.83$ 4.285 195,903.111$1.961$384,166.00$455,278.83 St WTOTAL BILLED
<br />RDSM 822$11.68$9,495.83$ 32,045.53$22,549.70$ 4.285 5,262.474$1.961$10,319.71$12,229.99 Code# OF ACCTSAMOUNT
<br />GSLM 4,101$11.68$47,497.92$ 743,429.76$695,931.84$ 5.084 136,886.672$1.961$268,434.76$427,497.08
<br />from EWEB reportfrom EWEB report
<br />GSMM 69 $11.68$794.63$ 59,372.93$58,578.30$ 6.512 8,995.439$1.961$17,640.06$40,938.24 STRO2954$22,633.07
<br />GSHM 137$11.68$1,591.98$ 85,360.11$83,768.13$ 8.417 9,952.255$1.961$19,516.37$64,251.76 STR610$72.80
<br />VHSM 239$11.68$2,775.56$ 81,543.07$78,767.51$ 10.329 7,625.860$1.961$14,954.31$63,813.20STR715$71.90
<br />SHSM 20 $11.68$233.60$ 56,089.86$55,856.26$ 12.236 4,564.912$1.961$8,951.79$46,904.47 STR82$8.78
<br />GSLH -$11.68$0.00$ -$0.00$ 5.084 0.000$1.961$0.00$0.00 STR9105$209.81
<br />FSWR 43 $11.68$501.90$ 10,613.02$10,111.12$ 4.285 2,359.655$1.961$4,627.28$5,483.84 STR134119$384,406.40
<br />FSW2 1$11.68$11.68$ 20,000.00$19,988.32$ 5.084 3,931.613$1.961$7,709.89$12,278.43 ST1040$418.40
<br />MSWR 2$11.68$23.36$ 2,425.34$2,401.98$ 5.084 472.459$1.961$926.49$1,475.49 STR4973$6,497.59
<br />SMLM 2$11.68$23.36$ 648.70$625.34$ 5.084 123.002$1.961$241.21$384.13 ST1175$431.33
<br />Tot WW55,738$643,921.63$2,511,944.96$1,868,023.33376,077.450$737,487.88$1,130,535.45STR5691$1,408.92
<br />OKOK$643,921.63STR2397$5,957.82
<br />$1,774,457.08ST120$0.00
<br />ST133$28.38
<br />ST140$0.00
<br />ST151$3.68
<br />STR3303$6,707.84
<br />ST161$20.44
<br />New in FY11 - ROW Fees calculationsST175$55.42
<br />Summar
<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,774,457.0848.46%%Op:%Cap:Reg WW Share:$0ST210$0.00
<br />should match Reg Rev on MTO
<br />double check:
<br />LOCAL WW$737,487.8820.14%15.4315%4.7086%$0ST220$0.00
<br />may have occasional rounding error - ok to adjust on mto
<br />20.14%
<br />STORM$1,149,828.0031.40%26.0623%5.3385%ST230$0.00
<br />31.40%
<br />$3,661,772.96100.0000%$0ST240$0.00
<br />= 6% of Storm share for ROW Fees
<br />$0ST2512$59.64
<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 />$0ST262$9.36
<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)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 ST305$64.95
<br />$ 14,499,000.00
<br />ST310$0.00
<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 HighTOTALST352$13.46
<br />Accounts51,1674,106691372392055,738ST360$0.00
<br />Flows 203,525 141,414 8,995 9,952 7,626 4,565 376,077 ST370$0.00
<br />Avg Flow/Acct 3.98 34.44 130.37 72.64 31.91 228.25 $ 502 ST380$0.00
<br />
<br />Local Flow Rev$ 399,113 $ 277,312 $ 17,640 $ 19,516 $ 14,954 $ 8,952 $ 737,488 ST390$0.00
<br />Reg Flow Rev$ 472,993$ 441,635 $ 40,938 $ 64,252 $63,813.20$ 46,904 $ 1,130,535 STW042$8,206.23
<br />Reg Base Rev$ 590,970 $ 47,556 $ 795 $ 1,592 2,776$ 234 $ 643,922 STW17179$676,070.15
<br />Reg Tot Rev$ 1,063,962 $ 489,191 $ 41,733 $ 65,844 $ 66,589 $ 47,138 $ 1,774,457 STW21439$29,266.67
<br />
<br />Tot WW Rev$ 1,463,075 $ 766,504 $ 59,373 $ 85,360 $ 81,543 $ 56,090 $ 2,511,945 STWB31$93.73
<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,08635,8981,47075341,2077,26448,471STB20$0.00
<br />Revenue22,996$ 393,163$ 29,360$ 13,108$ 458,627 $ 691,2011,149,828.00
<br />OK
<br />Avg Rev/Acct$ 7.45$ 10.95 $ 19.97$ 17.41 $ 11.13$ 95.15$ 23.72 Tot STRM48,471$1,149,8
<br />28.00
<br />Monthly Stormwater Q & Q Summary by ClassificationOK
<br />Small SFD Med SFD Large Resi w/ duplexes w/
<br />TOTAL
<br />w/reductionsw/reductionsreductionsreductions
<br />commercial participates but receives credits
<br />Accounts1321,77931191,961
<br />via lower ESUs
<br />% of TTL Accts4.28%4.96%2.11%2.52%4.76%
<br />Feb 2014 Feb2014 Split Report.xlsx3/17/2014
<br />
|