Health Coverage Costs Business Model: Develop an application to track employee healthcare expenses and company healthcare costs. Healthcare premiums continue to increase, and the company has changed insurance carriers several times in the past 10 years. This application should allow business modeling of various scenarios as well as tracking and analyzing current and past employee healthcare expenses and company healthcare costs. This application must be secure and run on the current intranet so several managers and analysts can access it and download selected data for further analysis.

The new application must also import data from the current systems that track employee expenses submitted to the company and the company’s costs to the insurance provider.

You believe that having this data will help you revise policies concerning employee contributions to healthcare premiums and help you negotiate for lower premiums with insurance companies. You estimate that this application would save your company about

$20/employee/year for full-time employees over the next four years and cost about

$100,000 to develop.

LO.1