When you are sitting at the terminal waiting for your flight or taking the bus to get to work, have you ever thought about who used your seat last? More importantly, have you ever thought about the last time that seat was cleaned? Sadly, it is uncertain to see if it was properly sanitized in the last hour, yesterday, in the last week, or even last month. Especially during these tough times, everyone wants to be assured that they are always in a safe and healthy environment. Through the Founders Lab, our team is collaborating with an engineering capstone team to bring automated seat cleaning technology into the market. This product is a custom-designed seat cover that is tear-resistant and provides a sanitary surface for anyone to sit on. When someone leaves the seat, a pressure sensor is triggered, and the cover is replaced with a secondary cover that was stored in a UV radiated container. The waterproof fabric and internal filters prevent spills and food crumbs from remaining when the user changes. The reason for bringing this product into the market is due to the unsanitary conditions in many high traffic areas. This technology can be implemented in public transportation, restaurants, sports stadiums, and much more. It will instantly improve the efficiency of sanitation for many businesses and keep a promise to its users that they will never bring something they sat on back home. #Safeseating

The objective of this study is to build a model using R and RStudio that automates ratemaking procedures for Company XYZ’s actuaries in their commercial general liability pricing department. The purpose and importance of this objective is to allow actuaries to work more efficiently and effectively by using this model that outputs the results they otherwise would have had to code and calculate on their own. Instead of spending time working towards these results, the actuaries can analyze the findings, strategize accordingly, and communicate with business partners. The model was built from R code that was later transformed to Shiny, a package within RStudio that allows for the build-up of interactive web applications. The final result is a Shiny app that first takes in multiple datasets from Company XYZ’s data warehouse and displays different views of the data in order for actuaries to make selections on development and trend methods. The app outputs the re-created ratemaking exhibits showing the resulting developed and trended loss and premium as well as the experience-based indicated rate level change based on prior selections. The ratemaking process and Shiny app functionality will be detailed in this report.