70.2K

Verified Solution

Link Copied!

Compute the benefit analysis assuming:

$3$ percent increase in pay.

Reese will increase the $401($k$)$ contribution to $8$ percent with a company match of $50$ percent up to a $3$ percent contribution by the employer.

$15$ percent increase in medical and dental insurance premiums.KaI Is the president of Lebra Ant$$ques$.$ An employee, Keese rrancis, is due a ralse. Keese's current benet$$t analysis is as tollows:

$\backslash$table$[[$Yearly Benefit Costs,$\backslash$table$[[$Company Cost$],[($Current$)]],\backslash$table$[[$Employee Cost$],[($Current$)]]],[$Medical insurance,$$8,000\mathrm{.}00,$$$1,200\mathrm{.}00],[$Dental insurance,$120\mathrm{.}00,120\mathrm{.}00],[$Life insurance,$300\mathrm{.}00,0],[$AD&D$,150\mathrm{.}00,0],[$Short$-$term disability,$60\mathrm{.}00,0],[$Long$-$term disability,$30\mathrm{.}00,0],[401($k$),750\mathrm{.}00,1,500\mathrm{.}00],[$Social Security,$3,018\mathrm{.}16,3,018\mathrm{.}16],[$Medicare$,705\mathrm{.}86,705\mathrm{.}86],[$Tuition reimbursement,$$2,000\mathrm{.}00,0],[$Total yearly benefit costs $($employer$),$$$15,134\mathrm{.}02,],[$Employee$\text{'}$s annual salary,$50,000\mathrm{.}00,],[$The total value of the employee's compensation,$$65,134\mathrm{.}02,]]$

Required:

Compute the benefit analysis assuming:

$3$ percent increase in pay.

Reese will increase the $401(k)$ contribution to $8$ percent with a company match of $50$ percent up to a $3$ percent contribution by the employer.

$15$ percent increase in medical and dental insurance premiums.

Note: Round your answers to $2$ decimal places.

$\backslash$table$[[,\backslash$table$[[$Company Cost$],[($New$)]],\backslash$table$[[$Employee Cost$],[($New$)]]],[$Medical insurance,$9,200\mathrm{.}00,1,380\mathrm{.}00]]$

Answer & Explanation Solved by verified expert

See Answer