|
FY09REC.XLS 01 /1 5/09 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 $1 ,255,1 12.25 $541 ,1 19.09 $962,1 92.53 $2,758,423.87 $1 ,255,1 12.25 45.50%
<br /> Nov $1 ,172,963.82 $495,282.91 $937,069.16 $2,605,315.89 $1 ,172,963.82 45.02%
<br /> Dec $1 ,457,485.61 $61 3,459.49 $985,048.08 $3,055,993.18 $1 ,457,485.61 47.69%
<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 $7,843,936.99 $3,400,399.94 $5,770,208.91 $1 7,014,545.84 $7,843,936.99
<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 $0.00
<br /> Oct $2,924,472.81 45.50% $1 ,330,635.13 $1 ,330,635.1 3 $0.00
<br /> Nov $2,228,679.71 45.02% $1 ,003,351 .61 $1 ,003,351 .61 $0.00
<br /> Dec $3,076,012.53 47.69% $1 ,466,950.38 $1 ,466,950.38 $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 $16,440,442.25 $7,583,597.29 $7,583,597.29 $0.00
<br /> Reconciliation of Payments Due VS. Payments Made During FY: Total Payments Due MWMC: $7,583,597.29
<br /> Less Monthly Payments Made: $7,583,597.29
<br /> PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08 Amount Due MWMC: $0.00
<br />
<br />
|