The following information is available for Lumberton Co. for the week ending June 28, 2016. All employees

Question:

The following information is available for Lumberton Co. for the week ending June 28, 2016. All employees are paid time and one-half for all hours over 40. Each employee has cumulative salary of over $7,000, but less than $110,000. Assume the Social Security tax rate is 6 percent on the first $110,000 of wages and the Medicare tax rate is 1.5 percent of total wages. The company contributes the retirement cost to a retirement plan for the employee.
The following information is available for Lumberton Co. for the

Required
a. Set up a spreadsheet to compute the net pay for each of the above employees. You will need to insert the appropriate Excel formulas.

The following information is available for Lumberton Co. for the

b. What is the total amount of compensation cost (salary cost plus payroll tax cost) for Lumberton Co. for the week ending June 28, 2016?
c. Lumberton is considering adding group health insurance coverage for its employees to its benefits package. If the average cost of health insurance per employee is $3,900 per year, how much additional cost would be added to weekly compensation cost for Lumberton? Assume the addition of health insurance and re-compute the total compensation cost for Lumberton for the week ending June 28, 2016.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Fundamental Financial Accounting Concepts

ISBN: 978-0078025907

9th edition

Authors: Thomas Edmonds, Christopher Edmonds

Question Posted: