|
<br />FY10REC.XLS12/15/09Reconciliation 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 />2009 Jul$1,634,674.49$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$0.00$0.000.00%
<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$7,700,670.70$3,233,451.89$5,030,312.42$15,964,435.01$7,700,670.70
<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
<br /> Dec0.00%$0.00$0.00
<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$15,486,973.82$7,472,551.08$6,000,388.83$1,472,162.25
<br />Reconciliation of Payments Due VS. Payments Made During FY:Total Payments Due MWMC:$7,472,551.08
<br />Less Monthly Payments Made:$6,000,388.83
<br />PAYMENTS ARE NOW PAID BY THE LGIP as of 6/08Amount Due MWMC:$1,472,162.25
<br />
|