|
FY09REC.XLS 06/12/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 /> 2008 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 /> 2009 Jan $1 ,520,567.58 $657,700.02 $1 ,070,059.59 $3,248,327.19 $1 ,520,567.58 46.81
<br /> Feb $1 ,268,492.37 $512,835.79 $860,1 77.69 $2,641 ,505.85 $1 ,268,492.37 48.02%
<br /> Mar $1 ,390,791 .94 $572,851 .89 $966,953.1 1 $2,930,596.94 $1 ,390,791 .94 47.46%
<br /> Apr $1 ,365,1 01 .75 $560,865.83 $966,029.75 $2,891 ,997.33 $1 ,365,101 .75 47.20%
<br /> May $1 ,289,209.71 $509,496.22 $966,389.61 $2,765,095.54 $1 ,289,209.71 46.62%
<br /> Jun $0.00 0.00%
<br />
<br /> Year to Date $14,678,1 00.34 $6,214,149.69 $1 0,599,81 8.66 $31 ,492,068.69 $14,678,100.34
<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 /> 2008 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 /> 2009 Jan $2,844,027.72 46.81 % $1 ,331 ,289.38 $1 ,331 ,289.38 $0.00
<br /> Feb $2,645,692.1 O 48.02% $1 ,270,461 .35 $1 ,270,461 .35 $0.00
<br /> Mar $3,159,348.45 47.46% $1 ,499,426.77 $1 ,499,426.77 $0.00
<br /> Apr $2,347,735.38 47.20% $1 ,1 08,1 31 .1 O $1 ,1 08,1 31 .1 O $0.00
<br /> May $2,659,698.77 46.62% $1 ,239,951 .57 $1 ,239,951 .57
<br /> Jun 0.00% $0.00 $0.00
<br />
<br /> Year to Date $30,096,944.67 $14,032,857.46 $12,792,905.89 $1 ,239,951 .57
<br /> Reconciliation of Payments Due VS. Payments Made During FY: Total Payments Due MWMC: $14,032,857.46
<br /> Less Monthly Payments Made: $12,792,905.89
<br /> PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08 Amount Due MWMC: $1 ,239,951 .57
<br />
<br />
|