The COVID-19 pandemic has and will continue to radically shift the workplace. An increasing percentage of the workforce desires flexible working options and, as such, firms are likely to require less office space going forward. Additionally, the economic downturn caused by the pandemic provides an opportunity for companies to secure favorable rent rates on new lease agreements. This project aims to evaluate and measure Company X’s potential cost savings from terminating current leases and downsizing office space in five selected cities. Along with city-specific real estate market research and forecasts, we employ a four-stage model of Company X’s real estate negotiation process to analyze whether existing lease agreements in these cities should be renewed or terminated.

This paper serves as an analysis of the current operational conditions of a real-world company – referred to as “Company X” – with respect to the IC substrate industry. The cost of substrates, a crucial component in the production of Company X’s product, has recently diverged from Company X’s predictions and is contributing to declining profitability. This analysis aims to discover the underlying cause for price divergence and recommend potential resolutions to improve the forecast of substrate costs and profitability. The paper is organized as follows: Chapter 1 is an introduction to IC substrates and the industry as a whole, Chapter 2 is a breakdown of the specific factors responsible for substrate prices, and Chapter 3 delivers a final recommendation to Company X and concludes the paper.

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.