Set up a worksheet to calculate the annual cost, the monthly cost, and the burden markup of

Question:

Set up a worksheet to calculate the annual cost, the monthly cost, and the burden markup of a salaried employee. The spreadsheet should allow you to enter the annual salary, annual bonus ($/year), monthly allowances ($/month), the amount of employee expenses that are not subject to social security and Medicare taxes, social security percentage rate and limit, Medicare percentage rate, FUTA percentage rate and limit, SUTA percentage rate and limit, workers’ compensation insurance rate ($/$100), general liability percentage rate, 401(k) matching rate and limit, monthly health insurance payment, monthly union payments, and other monthly benefits. Assume the employee takes full advantage of the 401(k) benefit. Check your answer against Problem 2.


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

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: