Question: Problem 3 . Peach Co . provides free term life insurance to its employees. The insurance comes in $ 1 , 0 0 0 units.
Problem Peach Co provides free term life insurance to its employees. The insurance comes in $ units. Thus, an individual's life insurance is equivalent to one year's earnings rounded down to the nearest $ of their salary. The insurance's cost is a function of each employee's age, as indicated in the spreadsheet.
a Use the ROUNDDOWN function to calculate the number of life insurance units for each employee based on the employee's salary in Column D
b In Column E utilize the HLOOKUP function to find the cost of one unit of this insurance based on the employee's age.
c Compute the total cost of providing this insurance to each employee in Column F
For example, Joe is years old with a base salary of $ He would be entitled to units at the cost of $ per unit based on the table provided in the spreadsheet and the total cost for the company is $
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
