|
FY09REC.XLS 09/29/08 Reconciliation of MWMC Payments w/ EWEB Billing Distribution
<br />For Payments Made July 2008 through June 2009
<br />EWEB Rat 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 $0.00 0.00%
<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 />Year to Date $2,663,930.36 $1 ,1 82,010.02 $1 ,924,548.71 $5,770,489.09 $2,663,930.36
<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,41 5.76 46.79% $1 ,239,1 93.73 $1 ,239,1 93.73 $0.00
<br />Sep 0.00% $0.00 $0.00
<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 />Year to Date $5,372,488.1 8 $2,481 ,643.16 $2,481 ,643.16 $0.00
<br />Reconciliation of Payments Due VS. Pay ments Made Durin g FY: Total Payments Due MWMC: $2,481 ,643.16
<br /> Less Monthly Paym ents Made: $2,481 ,643.16
<br />PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08 Amount Due MWMC: $0.00
<br />
|