Menu
support@graduatecourseshelp.com
+1(805) 568 7317

set up a worksheet to calculate the annual cost average hourly cost and the burden m 735223

Set up a worksheet to calculate the annual cost, average hourly cost, and the burden markup of an hourly employee. The spreadsheet should allow you to enter the hourly wages, the average number of hours paid for each week, number of days off per year, 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 Example 8 11.

4. 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.

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"GET15"

Order Now