Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
Exhibit MSD 67C JZ Surrebuttal Inflation Rate MIEC Comparison Data File 081811 MIEC 5th DR 090211
Data Expense Account Description # Headquarters Building Personnel Services (All Other) Wages & Salaries & Overtime Group Insurance / OPEB Pension Contribution Supplies (All Other) Machinery & Equipment Parts Construction & Building Supplies 0101 / 0102 0122 / 0130 0123 0203 0205 0211 Chemical Supplies Utilities (All Other) 0306 Electrical Usage 0307 Natural Gas 0308 Water Usage Contractual Services (All Other) 0413 Bond & Liability Insurance 5000 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 Total Capital Outlay MSD MIEC 4 YR Total 4 Year MSD assumption based on union agreements. Avg % Personnel Services Supplies Utilities Contractual Services Non-Discretionary Discretionary water backup Real Property Water Backup Program Orange Blue - Limited Yellow - Inflation Index Validate MSD $ Chg MIEC $ Chg MSD % Chg MIEC % Chg Exhibit MSD 67C $10,731.00 $11,142.00 $11,574.00 $12,029.00 $12,441.00 $10,972.45 1.00 $11,219.33 1.00 $11,471.76 1.00 $11,729.88 1.00 $48,625.00 $50,083.75 1.00 $51,586.26 1.00 $53,133.85 1.00 $54,727.87 1.00 $49,719.06 1.00 $50,837.74 1.00 $51,981.59 1.00 $53,151.18 1.00 $7,124.00 $7,836.40 1.00 $8,620.04 1.00 $9,482.04 1.00 $10,050.97 1.00 $7,782.97 1.00 $8,502.90 1.00 $9,289.41 1.00 $9,777.11 1.00 $8,626.00 $9,505.85 1.00 $10,589.52 1.00 $11,119.00 1.00 $11,674.94 1.00 $9,441.16 1.00 $10,446.64 1.00 $10,890.62 1.00 $11,353.47 1.00 $4,650.00 12092.35 $4,782.50 1.00 7.00 $4,922.98 1.00 3.00 $5,069.66 1.00 1.00 $5,220.75 1.00 1.00 $4,754.63 1.00 $4,861.60 1.00 $4,970.99 1.00 $5,082.84 1.00 $2,417.77 $2,490.30 1.00 $2,565.01 1.00 $2,641.96 1.00 $2,721.22 1.00 $2,472.16 1.00 $2,527.79 1.00 $2,584.66 1.00 $2,642.82 1.00 $1,795.54 $1,849.41 1.00 $1,904.89 1.00 $1,962.04 1.00 $2,020.90 1.00 $1,835.94 1.00 $1,877.25 1.00 $1,919.49 1.00 $1,962.68 1.00 $1,892.01 $1,948.77 1.00 $2,007.24 1.00 $2,067.45 1.00 $2,129.48 1.00 $1,934.58 1.00 $1,978.11 1.00 $2,022.62 1.00 $2,068.13 1.00 $872.62 $16,773.94 $898.80 1.00 $925.76 1.00 $953.53 1.00 $982.14 1.00 $892.25 1.00 $912.33 1.00 $932.85 1.00 $953.84 1.00 $10,347.54 $10,586.97 1.00 71.00 $11,134.25 1.00 35.00 $11,726.63 1.00 20.00 $12,351.60 1.00 20.00 $10,580.36 1.00 $11,082.93 1.00 $11,609.36 1.00 $12,160.81 1.00 $2,401.21 $2,473.25 1.00 $2,609.28 1.00 $2,746.79 1.00 6.00 $2,897.86 1.00 $2,455.24 1.00 $2,571.86 1.00 $2,694.03 1.00 $2,821.99 1.00 $481.86 $496.32 1.00 $511.21 1.00 $526.55 1.00 $542.34 1.00 $492.71 1.00 $503.79 1.00 $515.13 1.00 $526.72 1.00 $30,884.16 $38,329.65 $32,556.95 1.00 283.00 $34,029.01 1.00 7.00 $34,122.32 1.00 1438.00 $35,019.82 1.00 638.00 $32,042.32 1.00 $33,243.91 1.00 $33,245.30 1.00 $33,870.40 1.00 $2,723.01 $2,859.16 1.00 $3,002.11 1.00 $3,152.22 1.00 $3,309.83 1.00 $2,838.73 1.00 $2,959.38 1.00 $3,085.15 1.00 $3,216.27 1.00 $0.00 1.00 $0.00 1.00 $0.00 1.00 $0.00 1.00 $4,300.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $4,300.00 1.00 $4,300.00 1.00 $4,300.00 1.00 $4,300.00 1.00 $932.00 $960.00 $989.00 $1,018.00 $1,049.00 $952.97 1.00 $974.41 1.00 $996.34 1.00 $1,018.75 1.00 $112,629.71 $118,429.07 $123,961.20 $127,736.06 $132,135.03 $116,704.60 $121,373.49 $124,401.44 $127,829.23 $26,174.01 $27,041.34 $28,009.36 $29,014.98 $30,004.69 $26,762.93 $27,426.48 $28,107.87 $28,807.65 $138,803.72 $145,470.42 $151,970.55 $156,751.04 $162,139.71 $143,467.53 $148,799.96 $152,509.31 $156,636.88 0.05 1.00 0.04 0.03 0.03 0.03 1.00 0.04 0.02 0.03 $64,006.00 $66,008.25 $68,083.24 $70,232.51 $72,389.62 $65,446.14 $66,918.67 $68,424.34 $69,963.89 $2,002.25 $2,074.99 $2,149.28 $2,157.11 $8,383.62 $1,440.14 $1,472.54 $1,505.67 $1,539.55 $5,957.89 0.03 0.03 0.03 0.03 0.03 4.00 0.02 0.02 0.02 0.02 0.02 4.00 $20,295.24 $21,404.10 $22,187.73 $23,020.95 $23,903.41 $20,655.14 $21,349.02 $22,073.99 $22,831.49 $1,108.86 $783.63 $833.22 $882.46 $3,608.17 $359.89 $693.88 $724.97 $757.50 $2,536.25 0.05 0.04 0.04 0.04 0.04 4.00 0.02 0.03 0.03 0.03 0.03 4.00 $54,502.48 $58,058.06 $61,699.58 $63,497.57 $65,846.68 $57,366.26 $60,532.27 $62,010.98 $63,841.50 $3,555.59 $3,641.52 $1,797.99 $2,349.11 $11,344.20 $2,863.78 $3,166.02 $1,478.71 $1,830.52 $9,339.02 0.07 0.06 0.03 0.04 0.05 4.00 0.05 0.06 0.02 0.03 0.04 4.00 $138,803.72 $145,470.42 $151,970.55 $156,751.04 $162,139.71 $143,467.53 $148,799.96 $152,509.31 $156,636.88 $6,666.70 $6,500.14 $4,780.49 $5,388.68 $23,335.99 $0.00 $4,663.81 $5,332.43 $3,709.35 $4,127.57 $17,833.16 $0.00 0.05 0.04 0.03 0.03 0.04 4.00 0.03 0.04 0.02 0.03 0.03 4.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.03 0.03 0.03 0.03 0.03 $1,458.75 $1,502.51 $1,547.59 $1,594.02 $6,102.87 $1,576.69 0.03 0.03 0.03 0.03 0.13 1.00 0.03 4.00 $1,094.06 $1,118.68 $1,143.85 $1,169.59 $4,526.18 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 1.00 $712.40 $783.64 $862.00 $568.92 $2,926.97 $273.86 0.10 0.10 0.10 0.06 0.41 0.10 4.00 $658.97 $719.92 $786.52 $487.69 $2,653.11 0.09 7.50E-03 0.09 7.50E-03 0.09 7.50E-03 0.05 7.50E-03 0.37 $879.85 $1,083.67 $529.48 $555.95 $3,048.95 $321.47 0.10 0.11 0.05 0.05 0.35 0.09 4.00 $815.16 $1,005.48 $443.98 $462.85 $2,727.47 0.09 7.50E-03 0.11 7.50E-03 0.04 7.50E-03 0.04 7.50E-03 0.32 $411.00 $432.00 $455.00 $412.00 $1,710.00 0.03 0.03 0.03 0.03 0.16 0.04 4.00 $241.45 $246.88 $252.43 $258.11 $998.88 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $72.53 $74.71 $76.95 $79.26 $303.45 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $54.40 $55.62 $56.88 $58.15 $225.05 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $53.87 $55.48 $57.15 $58.86 $225.36 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $40.40 $41.31 $42.24 $43.19 $167.14 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $56.76 $58.46 $60.22 $62.02 $237.46 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $42.57 $43.53 $44.51 $45.51 $176.11 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $132.50 $140.48 $146.69 $151.09 $570.75 0.03 0.03 0.03 0.03 0.12 0.03 4.00 $104.63 $106.98 $109.39 $111.85 $432.84 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $239.43 $547.28 $592.38 $624.96 $2,004.06 $190.79 0.03 0.06 0.06 0.06 0.19 0.05 4.00 $232.82 $502.57 $526.44 $551.44 $1,813.27 0.02 7.50E-03 0.05 7.50E-03 0.05 7.50E-03 0.05 7.50E-03 0.18 $72.04 $136.03 $137.51 $151.07 $496.65 0.03 0.06 0.06 0.06 0.21 0.05 4.00 $54.03 $116.62 $122.16 $127.97 $420.78 0.02 7.50E-03 0.05 7.50E-03 0.05 7.50E-03 0.05 7.50E-03 0.18 $14.46 $14.89 $15.34 $15.80 $60.48 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $10.84 $11.09 $11.34 $11.59 $44.85 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $26.18 $26.96 $27.77 $28.61 $109.52 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $19.63 $20.08 $20.53 $20.99 $81.23 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $136.15 $142.96 $150.11 $157.61 $586.82 $93.56 0.05 0.05 0.05 0.05 0.22 0.05 4.00 $115.73 $120.65 $125.77 $131.12 $493.27 0.04 7.50E-03 0.04 7.50E-03 0.04 7.50E-03 0.04 7.50E-03 0.18 $1,672.79 $1,472.06 $93.31 $897.50 $4,135.66 $1,150.43 0.05 0.05 0.05 0.05 0.13 0.03 4.00 2.74E-03 0.03 $1,158.16 $1,201.59 $0.39 1.00 $625.10 $2,985.23 0.04 7.50E-03 0.04 7.50E-03 4.19E-05 2.70E-03 0.02 7.50E-03 0.10 $700.00 $0.00 $0.00 $0.00 $700.00 0.00 0.00 0.00 0.00 0.16 0.04 4.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00 0.00 0.00 0.00 0.00 $28.00 $29.00 $29.00 $31.00 $117.00 0.03 0.03 0.03 0.03 0.13 0.03 4.00 $20.97 $21.44 $21.92 $22.42 $86.75 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.02 7.50E-03 0.09 $5,799.37 $5,532.12 $3,774.86 $4,398.97 $19,505.32 0.05 0.05 0.03 0.03 0.17 0.04 4.00 $4,074.89 $4,668.89 $3,027.96 $3,427.79 $15,199.53 0.04 0.04 0.02 0.03 0.14 0.03 4.00 $867.33 $968.01 $1,005.62 $989.71 $3,830.67 0.03 0.04 0.04 0.03 0.15 0.04 4.00 $588.92 $663.55 $681.39 $699.78 $2,633.63 0.02 0.02 0.02 0.02 0.10 0.03 4.00 $6,666.70 $6,500.14 $4,780.49 $5,388.68 $23,335.99 0.05 0.04 0.03 0.03 0.17 0.04 4.00 $4,663.81 $5,332.43 $3,709.35 $4,127.57 $17,833.16 $3,606.79 0.03 0.04 0.02 0.03 0.13 $21,439.95 ($1,896.04) 0.03 4.00