|
FY09REC.XLS 10/08/08 Reconciliation of MWMC Payments w/ EWEB Billing Distribution
<br /> For Payments Made July 2008 through June 2009
<br /> EWEB Rpt Titles: MWMC
<br /> Total Share City Share Storm Total Blank Grand Total
<br /> Regional Local Storm Monthly Regional Share of EWEB Billings:
<br /> San Sewer San Sewer Drainage Combined Total $
<br /> 2007 Jul $1 ,396,71 1 .53 $61 7,226.16 $1 ,048,088.26 $3,062,025.95 $1 ,396,71 1 .53 45.61
<br /> Aug $1 ,267,21 8.83 $564,783.86 $876,460.45 $2,708,463.14 $1 ,267,21 8.83 46.79%
<br /> Sep $1 ,294,444.95 $568,528.43 $961 ,350.43 $2,824,323.81 $1 ,294,444.95 45.83%
<br /> OCt $0.00 0.00%
<br /> Nov $0.00 0.00%
<br /> DeC $0.00 0.00%
<br /> 2008 Jan $0.00 0.00%
<br /> Feb $0.00 0.00%
<br /> Mar $0.00 0.00%
<br /> Apr $0.00 0.00%
<br /> May $0.00 0.00%
<br /> Jun $0.00 0.00%
<br />
<br /> Year to Date $3,958,375.31 $1 ,750,538.45 $2,885,899.14 $8,594,812.90 $3,958,375.31
<br /> Calculation of Regional Share of EWEB Cash Turnovers:
<br /> Regional Share Less Actual Payment Difference
<br /> EWEB Turnovers X Regional % = EWEB Turnovers to MWMC = due MWMC
<br /> 2007 Jul $2,724,072.42 45.61 % $1 ,242,449.43 $1 ,242,449.43 $0.00
<br /> Aug $2,648,415.76 46.79% $1 ,239,193.73 $1 ,239,193.73 $0.00
<br /> Sep $2,838,789.02 45.83% $1 ,301 ,01 7.01 $1 ,301 ,01 7.01
<br /> OCt 0.00% $0.00 $0.00
<br /> Nov 0.00% $0.00 $0.00
<br /> DeC 0.00% $0.00 $0.00
<br /> 2008 Jan 0.00% $0.00 $0.00
<br /> Feb 0.00% $0.00 $0.00
<br /> Mar 0.00% $0.00 $0.00
<br /> Apr 0.00% $0.00 $0.00
<br /> May 0.00% $0.00 $0.00
<br /> Jun 0.00% $0.00 $0.00
<br />
<br /> Year to Date $8,21 1 ,277.20 $3,782,660.17 $2,481 ,643.16 $1 ,301 ,01 7.01
<br /> Reconciliation of Payments Due VS. Payments Made During FY: Total Payments Due MWMC: $3,782,660.17
<br /> Less Monthly Payments Made: $2,481 ,643.16
<br /> PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08 Amount Due MWMC: $1 ,301 ,01 7.01
<br />
<br />
|