HomeMy Public PortalAboutExhibit MSD 99I -Year Over Year Variance TablesExhibit MSD 991
Year Over Year Variance Tables
Rate Commission Fourth Discovery Request: Question 19a
Actual Expense Variances FY11 - FY14
General Inflation Rate (1)
Personnel (2)
Group Insurance (3)
Pension Contribution
Electric
Natural Gas
Utilities (All Other)
Bond & Liability Insurance
Ash Hauling (4)
Actual
2011
Actual
2012
Actual
2013
Actual
2014
2.3%
2.1%
2.5%
2.2%
NA
NA
NA
NA
13.2%
15.3%
16.2%
-10.2%
9.9%
4.2%
10.4%
3.5%
18.1%
_
-7.4%
13.5%
1.6%
-
-1.0%
-30.4%
31.4%
15.8%
15.4%
-10.8%
10.9%
-1.0%
-16.4%
-3.7%
9.7%
-1.3%
8.8%
-85.7%
1579.1%
-40.1%
Note: This is reporting year over year variances which have other variables other than inflation
(1) From Federal Reserve Bank of Saint Louis
(2) For personnel increases, see Q19(d)
(3) Insurance contract renewed with a different vendor.
(4) The majority of Ash Hauling is done every other year.
Rate Commission Fourth Discovery Request: Question 19d
Budget 11) Variances FY11 - FY14
Salaries and Wages (2)
Average Annual Salary and Wage Increase (3)
Overtime
Personnel Services (4)
I Budget
Il 2011
Budget
2012
Budget
2013
Budget
2014
Budget
2015
1.37%
3.00%
2.78%
4.33%
2.63%
0.00%
2.50%
_ 3.00%
2.00%
_
2.60%
-29.66%
1.43%
-0.85%
4.99%
5.94%
2.37%
8.91%
3.43%
4.69%
3.43%
(i) Annual Budgets adopted by the Board
(2) This includes other variables such as promotions and changes in FTEs
(3) Average Salary and Wage Increase is Included in Salary and Wages variance
(4) Includes all other Personnel Expenses:
Compensatory Pay Accrual
Sick Leave Accrual
Vacation Accrual
Board Member Fees
Floating Holiday Accrual
Civil Service Commision Fees
Emp Service & Incentive Awards
Workers' Comp Settlements
Membership & Licensing Fees
Education Assistance Program
FICA Taxes
Group Insurance
Pension Contribution
Employee Assistance Program
Unemployment Insurance
Second Injury Insurance/Tax
Other Post Employment Benefits
Temporary Help