Proposed Project for the MSU Industrial Math Students

Deeper Understanding of Average Daily Balance Method Over a Large Dataset

This project will involve a review of the Average Daily Balance calculations that the Municipal Employees’ Retirement System (MERS) uses when allocating out quarterly investment gains and losses to the 2,000+ municipal divisions that make up MERS. MERS runs a Defined Benefit Pension Plan for the municipalities in the State of Michigan. On a quarterly basis MERS allocates the investment gains or losses for the quarter to the individual municipal divisions based on the average daily balance (ADB) of assets of that municipal division. The average daily balance fluctuates based on contributions coming into the divisions from the municipalities and pensions going out to retirees from the divisions.

The Industrial Mathematics Students at Michigan State University will receive from MERS an Excel file containing the beginning asset numbers and all the financial activity for the quarters/year. The students will also be given a dollar amount to allocate out for each of the four quarters in the year. The project’s goal is for the students to replicate the amount calculated for each of the 2,000+ divisions compared with MERS software calculations. This project had been run a few years ago and the results were what we expected. Since then however we have had new software installed for the ADB calculation so re-running this project is desirable. The data from MERS will not have municipal names or Social Security numbers. The calculations themselves will probably not require any really complicated software, but an understanding of how the process and design works will be critical. The database will be very large with probably over 400,000 lines of information.

Top of Page