The purpose of this exercise is to familiarize the student with how health insurance companies price insurance products. Broadly, health insurance premiums represent the product of provider costs per unit x provider utilization per unit + administrative costs and profit. The goal of this exercise is to see how changes in provider costs, provider utilization, and co-pays affect overall health insurance premiums.
Step 1. Copy & Save IDS Medical Budget Model to your disk from the S Drive. Do Not make changes to the S drive file.
Step 2. Make a 2nd copy of the IDS Medical Budget Model. Do this in order to have one copy to work from and one to refer back to should you so desire.
FULL ASSIGNMENT IN PDF FILE