Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I need help coming up with an equation for this question inside the excel sheet please. Home Insert Draw Comments Arial Page Layout 10
Hi, I need help coming up with an equation for this question inside the excel sheet please.
Home Insert Draw Comments Arial Page Layout 10 A Formulas Data Review View AA = = = D E General D E Insert Delete Format Share A- 49- O ur? Sort & Find & X Filter Select 4 E $% 88 0 70 Ideas Formatting as Table Styles Paste 3 (23 BIU v fx x | L | M N O P Q R S T U | 1 Human Resources provides free term life insurance to its employees. The Insurance comes in $1,000 2 units. Thus, an individual's free life insurance is equivalent to one year's earnings rounded DOWN to the nearest 3 $1,000 of salary. The cost of the insurance is a function of each employee's age as indicated in the table below 4 Calculate the cost to the company of providing this insurance to each employee. Use a HLOOKUP function and format 5 the cost in dollars with zero decimals. For example, a 38-year old employee with a base salary of $35,700 would 6 be entitled to 35 units of $1,000 each) at a cost of $10.53 per unit, or a total cost of $369 No. of $1,000 units of Life Insurance Base Salary Total Cost for Units of Insurance Age 34.500 10 Doe, John 11 Garza. Esperanza 12 Hamandez, Joey 42.000 39.600 14 Smith, Sammy 49,500 15 16 17 Age 18 Cast per $1,000 unit of Insurance 17 8.34 18 8.34 19 8.34 20 8.34 21 8.34 22 8.34 23 8.34 24 8.34 25 8.34 26 8.34 27 8.34 28 8.34 29 8.34 30 8.34 31 8.34 32 8.34 33 8.81 34 .95 35 .31 8.34 8 9 19 Problemi Problem2 Problem3 +Step 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