|
<br />FY10REC.XLS01/21/10Reconciliation of MWMC Payments w/ EWEB Billing Distribution
<br /> For Payments Made July 2009 through June 2010
<br />EWEB Rpt Titles:MWMC
<br />Total ShareCity ShareStorm TotalBlankGrand Total
<br />RegionalLocalStorm MonthlyRegional Share of EWEB Billings:
<br />San SewerSan SewerDrainageCombinedTotal$%
<br />$1,634,674.49
<br />2009 Jul$684,800.05$1,099,954.59$3,419,429.13$1,634,674.4947.81%
<br /> Aug$1,572,442.26$663,283.57$982,535.03$3,218,260.86$1,572,442.2648.86%
<br /> Sep$1,448,810.45$616,936.05$931,999.11$2,997,745.61$1,448,810.4548.33%
<br /> Oct$1,572,581.25$664,910.36$1,012,314.65$3,249,806.26$1,572,581.2548.39%
<br /> Nov$1,472,162.25$603,521.86$1,003,509.04$3,079,193.15$1,472,162.2547.81%
<br /> Dec$1,536,431.61$682,335.15$921,293.75$3,140,060.51$1,536,431.6148.93%
<br />2010 Jan$0.00$0.000.00%
<br /> Feb$0.00$0.000.00%
<br /> Mar$0.00$0.000.00%
<br /> Apr $0.00$0.000.00%
<br /> May$0.00$0.000.00%
<br /> Jun$0.00$0.000.00%
<br />Year to Date$9,237,102.31$3,915,787.04$5,951,606.17$19,104,495.52$9,237,102.31
<br />Calculation of Regional Share of EWEB Cash Turnovers:
<br />Regional ShareLess Actual PaymentsDifference
<br />EWEB Turnovers X Regional % = EWEB Turnoversto MWMC = due MWMC
<br />2009 Jul$2,941,967.9447.81%$1,406,554.87$1,406,554.87$0.00
<br /> Aug$3,218,260.8648.86%$1,572,442.26$1,572,442.26$0.00
<br /> Sep$2,997,745.6148.33%$1,448,810.45$1,448,810.45$0.00
<br /> Oct$3,249,806.2648.39%$1,572,581.25$1,572,581.25$0.00
<br /> Nov$3,079,193.1547.81%$1,472,162.25$1,472,162.25$0.00
<br /> Dec$3,140,060.5148.93%$1,536,431.61$1,536,431.61
<br />2010 Jan0.00%$0.00$0.00
<br /> Feb0.00%$0.00$0.00
<br /> Mar0.00%$0.00$0.00
<br /> Apr 0.00%$0.00$0.00
<br /> May0.00%$0.00$0.00
<br /> Jun0.00%$0.00$0.00
<br />Year to Date$18,627,034.33$9,008,982.69$7,472,551.08$1,536,431.61
<br />Reconciliation of Payments Due VS. Payments Made During FY:Total Payments Due MWMC:$9,008,982.69
<br />Less Monthly Payments Made:$7,472,551.08
<br />PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08Amount Due MWMC:$1,536,431.61
<br />
|