|
<br />Monthly Split Report for Activity during:Nov-08
<br />Wastewater Monthly Info
<br />FLOW-BASED
<br />BILLING
<br />WWMWMC'sMWMC's
<br />RateBasicBasic ChargesTotalAmount billedFY07 Flow RatesKgals billedCityCityMWMCDoubleStormwater Monthly Info
<br />Code# Accounts(per acct) ChgBilledBilled Amtfor Flow (MWMC + City)this monthRate per KgalRevenueRevenueCheckSt WTOTAL BILLED
<br />Code# OF ACCTSAMOUNT
<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 49,757$7.91$393,577.87$ 948,505.65$554,927.78$ 2.941 188,687$1.368$258,123.50$296,804.28
<br />from EWEB reportfrom EWEB report
<br />RDSM 816$7.91$6,454.56$ 20,546.95$14,092.39$ 2.941 4,792$1.368$6,555.05$7,537.34 STRO2,96118,525.28
<br />GSLM 4,074$7.91$32,225.34$ 479,289.21$447,063.87$ 3.482 128,393$1.368$175,641.41$271,422.46 STR616.00
<br />GSMM 62 $7.91$490.42$ 36,094.89$35,604.47$ 4.449 8,003$1.368$10,947.83$24,656.64 STR7832.80
<br />GSHM 130$7.91$1,028.30$ 55,056.89$54,028.59$ 5.740 9,413$1.368$12,876.50$41,152.09 STR800.00
<br />VHSM 221$7.91$1,748.11$ 64,051.86$62,303.75$ 7.032 8,860$1.368$12,120.52$50,183.23STR991147.91
<br />SHSM 15 $7.91$118.65$ 29,272.75$29,154.10$ 8.325 3,502$1.368$4,790.73$24,363.37 STR133,895314,336.10
<br />GSLH 1 $7.91$7.91$ 15,940.15$15,932.24$ 3.482 4,576$1.368$6,259.42$9,672.82 ST10217.26
<br />FSWR 47 $7.91$371.77$ 6,916.76 $6,544.99$ 2.941 2,225$1.368$3,044.39$3,500.60 STR49505,210.27
<br />FSW2 1 $7.91$7.91$ 10,000.00$9,992.09$ 3.482 2,870$1.368$3,925.67$6,066.42 ST111568.49
<br />MSWR 2 $7.91$15.82$ 1,660.92 $1,645.10$ 3.482 472$1.368$646.32$998.78 STR56451,078.24
<br />SMLM 2 $7.91$15.82$ 910.70 $894.88$ 3.482 257$1.368$351.58$543.30 STR23994,930.79
<br />Tot WW55,128$436,062.48$1,668,246.73$1,232,184.25362,049$495,282.91$736,901.34ST1200.00
<br />$436,062.48ST13323.40
<br />$1,172,963.82ST1400.00
<br />ST1513.03
<br />STR33085,586.82
<br />ST16116.87
<br />ST17553.60
<br />ST1800.00
<br />ST19412.12
<br />Summary for
<br />ST201078.00
<br />ST2100.00
<br />FUND SPLITTotal Billed% of TotalFor Local Charges (see Tish)ST2200.00
<br />MWMC TOTAL$1,172,963.8245.02%%Op:%Cap:ST2300.00
<br />double check:
<br />LOCAL WW$495,282.9119.01%13.69%5.32%ST2400.00
<br />19.01%
<br />STORM$937,069.1635.97%28.77%7.19%ST25416.40
<br />35.97%
<br />$2,605,315.89100.0000%ST2626.30
<br />ST2700.00
<br />Figures do not factor in EWEB's per acct charge, Energy Share contributions, or delinquencies
<br />ST2800.00
<br />TP's direction for FY09 Cap/Op Splits (per FY09 Bud):
<br />ST2900.00
<br />These splits come from FY09 budget:
<br />% Cap
<br />% OpST30221.44
<br />OpCap
<br />Net Budget
<br />28%
<br />Local WW72%ST3100.00
<br />$ 5,460,000 $ 2,133,000
<br />$ 7,593,000.00
<br />StormW80%20%ST3216.88
<br />$ 9,258,000 $ 2,265,000
<br />$ 11,523,000.00
<br />ST3300.00
<br />We apply these rates to the Local WW and Storm % of total to get the %'s
<br />ST3413.03
<br />Debbie needs for her data entry into turnover report.
<br />ST35211.12
<br />Monthly WW Summary by ClassificationST3600.00
<br />RESLOWMEDHIGHV HighS HighTOTALST3700.00
<br />Accounts50,6204,080621302211555,128ST3800.00
<br />Flows 195,704 136,568 8,003 9,413 8,860 3,502 362,049 ST3900.00
<br />Avg Flow/Acct 3.87 33.47 129.08 72.40 40.09 233.47 $ 512
<br />STW0446,705.11
<br />Local Flow Rev$ 267,723 $ 186,824 $ 10,948 $ 12,877 $ 12,121 $ 4,791 $ 495,283 STW17,022550,928.30
<br />
<br />Reg Flow Rev$ 307,842$ 288,704 $ 24,657 $ 41,152 $50,183.23$ 24,363 $ 736,901 STW21,37123,015.05
<br />Reg Base Rev$ 400,404 $ 32,273 $ 490 $ 1,028 1,748$ 119 $ 436,062 STWB2728.05
<br />Reg Tot Rev$ 708,246 $ 320,977 $ 25,147 $ 42,180 $ 51,931 $ 24,482 $ 1,172,964 STW3119.77
<br />Tot WW Rev$ 975,969 $ 507,801 $ 36,095 $ 55,057 $ 64,052 $ 29,273 $ 1,668,247 STW9466,179.88
<br />FSTR00.00
<br />STB110.85
<br />Monthly Stormwater Summary by ClassificationSTB200.00
<br />Small SFDMed SFDLarge ResiduplexesQ&Q creditsSubtotal ResiGen + miscGrand Tot
<br />Accounts2,96133,8951,3717261,75740,7107,11347,823Tot STRM47,823$937,069.16
<br />Revenue$ 18,525$ 314,336 $ 23,015 $ 10,664$ 6,714$ 373,255$ 563,814937,069
<br />Avg Rev/Acct$ 6.26 $ 9.27$ 16.79 $ 14.69$ 3.82 $ 9.17 $ 79.27$
<br /> 19.59
<br />Nov 2008 Nov 08.xls12/8/2008
<br />
|