Question: 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

 Please also show answer in excel. Determine the annual cost, average

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!