Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please also show answer in excel. Determine the annual cost, average hourly cost, and burden markup of an hourly employee given the following information. Assume

image text in transcribed

Please also show answer in excel.

Determine the annual cost, average hourly cost, and burden markup of an hourly employee given the following information. Assume the employee takes full advantage of the 401(k) benefit. The employee's health insurance is paid for entirely by the employer. Last year the employee worked 2,104 hours and was paid for an additional 80 hours of vacation. The employee was paid for at least 40 hours each week and is to be paid time and a half on any work over 40 hours per week. Item Cost Wages $22/hr Bonus $500 Allowances None Social Security Medicare 6.2% of wages to $128,700 1.45% of wages FUTA 0.8% of wages to $7,000 2.0% of wages to $20,000 SUTA Worker's Compensation $0.85 per $100 of wages General Liability 401(k) 0.65% of wages 50% match up to 6% of wages Health Insurance $200/month Use Excel to complete this

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Statements A Manager S Guide

Authors: David S. Murphy Ph.D. ,Ernest W. Murphy

1st Edition

1530688787, 978-1530688784

More Books

Students also viewed these Accounting questions