Western Reserve Group

Western Reserve Group Team

Automated Rate Impact Tool

Team: Constant Likudie (Ashesi ’18), Michelle Bae '19, Christian Betre ’19, Mary-Hannah Boyer ’18

Advisors: Jen Bowen (Mathematics) and Ronda Kirsch (Mathematics)

The goal of this AMRE project for Western Reserve Group is to automate the process of calculating the premium of auto insurance when underlying factors change. We were given excel spreadsheets with relevant calculation process and data. We rewrote this process in a program called R. Then we created an application using the algorithm. Now users can both graphically and numerically see the data of how much the premium has changed for how many people in a more efficient manner.