Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Employees who select additional life insurance pay 0.01% times their annual salary. Those who do not take it, pay $0. This life insurance percent is
Employees who select additional life insurance pay 0.01% times their annual salary. Those who do not take it, pay $0. This life insurance percent is listed in the constants area. Compute the cost of the life insurance premium in column I. Note that column D stores Boolean values TRUE or FALSE so the single cell becomes the condition.
B D F G H I J K L M Constants Plan HMOF HMOI E Monthly Premium $1,500 $875 $1,650 2 Bonus Pay Grade 1 3 Bonus Pay Grade 2 4 Bonus Pay Grade 3 5 Life Ins Premium 6 401(k) matching % $3,000 $6,000 $8,000 0.01% 3.00% PPOF None $0 Employee ID Last Name Job Status Additional Life Ins? Pay Grade 401(k) Benefit Age Health Bonus Contact? Cost FT FT FT FT 9 1033 10 1034 11 1035 12 1036 13 1037 14 1038 15 1048 16 1050 17 1055 18 1056 Mccorkle Nightingale Croasdale Lambrechts Palmer Tetreault Watts Jacques Damien Souillante | FALSE FALSE FALSE TRUE TRUE TRUE FALSE TRUE FALSE FALSE Annual Health Life Ins Salary Plan Premium $21,840 None 71 $25,792 PPOF 23 $32,011 PPOF 45 $23,920 HMOF 55 $32,011 None 41 $21,840 PPOF 53 $24,752 None 54 $29,120 PPOF 21 $22,880 PPOF 40 $22.880 HMOI 47Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started