w
<br />
<br /> r
<br /> MWMC Adjustment 1106
<br /> In July 2005 there was a rate increase in the Wastewater Collection fee for the City's portion from $1.06 to $1.19. Due to an oversight by one of
<br /> our (COE) staff, we did not update the change in the FY06REC.XLS spreadsheet resulting in the City overpaying MWMC by $275,280.79.
<br /> AJE #52191
<br /> July 1, 2005 August 1, 2005
<br /> Adjustment Original Revised Original Revised
<br /> 533-9951-45992 $ (275,280.79) $ 951,290.13 $ 900,543.92 $ 1,098,626.09 $ 1,039,834.37
<br /> 534-8911-45551 $ 251,170.38 $ 384,019.96 $ 430,335.95 $ 445,306.00 $ 498,903.27
<br /> 532-9332-45551 $ 24,325.21 $ 38,059.66 $ 42,489.89 $ 44,152.82 $ 49,347.27
<br /> 531-9332-45550 $ - $ - $ (0.01) $ - $ 0.01
<br /> 533-9951-45992 $ (6,809.31) $ 24,589.15 $ 23,277.45 $ 27,336.16 $ 25,873.29
<br /> 533-9951-99302 $ 6,809.30 $ (24,589.15) $ (23,277.45) $ (27,336.15) $ (25,873.29)
<br /> 534-8911-45551 $ 6,814.58 $ 10,910.00 $ 12,221.70 $ 12,178.78 $ 13,641.64
<br /> 534-8911-61880 $ (6,814.58) $ (10,910.00) $ (12,221.70) $ (12,178.78) $ (13,641.64)
<br /> September 1, 2005 October 1, 2005 November 1, 2005
<br /> Original Revised Original Revised Original Revised
<br /> $ 1,017,912.89 $ 963,569.79 $ 1,064,934.77 $ 1,008,387.52 $ 1,041,528.58 $ 986,676.07
<br /> $ 412,191.36 $ 461,808.97 $ 426,758.64 $ 478,228.18 $ 415,407.35 $ 465,577.32
<br /> $ 40,811.03 $ 45,751.31 $ 42,237.33 $ 47,315.05 $ 41,250.86 $ 45,933.39
<br /> $ - $ - $ 0.01 $ - $ - $ 0.01
<br /> $ 24,995.08 $ 23,660.67 $ 28,285.21 $ 26,783.29 $ 22,755.13 $ 21,556.72
<br /> $ (24,995.08) $ (23,660.67) $ (28,285.21) $ (26,783.29) $ (22,755.13) $ (21,556.72)
<br /> $ 11,123.57 $ 12,463.26 $ 12,456.77 $ 13,958.70 $ 9,976.99 $ 11,175.39
<br /> $ (11,123.57) $ (12,463.26) $ (12,456.77) $ (13,958.70) $ (9,976.99) $ (11,175.39)
<br /> * While fixing MWMC/City WW revenue allocations, we discovered a .01 % rounding error in 9/05 split report. This created a $214.90 over-
<br /> allocation (off-set in Stm CAP) -per TP 2/6/06 -this isn't significant enough for follow up.
<br /> "*Ignore $5+ amount due to rounding
<br />
<br />
|