Question: Problem 3 . Peach Co . provides free term life insurance to its employees. The insurance comes in $ 1 , 0 0 0 units.

Problem 3. Peach Co. provides free term life insurance to its employees. The insurance comes in $1,000 units. Thus, an individual's life insurance is equivalent to one year's earnings rounded down to the nearest $1,000 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 38 years old with a base salary of $65,700. He would be entitled to 65 units at the cost of $10.53 per unit (based on the table provided in the spreadsheet), and the total cost for the company is 65**10.53=$684.45
 Problem 3. Peach Co. provides free term life insurance to its

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!