Compensation Plan Exercise

profilequ_4-iver
compensation_package_worksheet.xlsx

Sheet1

Compensation Package Summary
Adamskia Division Manerus Division
Salary / Fringe Benefit Monthly Cost Annual Cost Monthly Cost Annual Cost
Salary
PPO Inc
HMO Inc
Deductibles R US
Fitness 123
Autoluxurious
Auto Cheapus
Tooth 2000
Dental Dynamo
Other*
Total $10,000 $120,000 $10,000 $120,000
After Tax Income (annual only) XX XX
* Describe anything you put in the other category in detail
Observation: Your company is spending $120,000 per year on each employee. If you add a fringe benefit then its cost must come out somewhere else.

Sheet2

Sheet3