Answered step by step
Verified Expert Solution
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
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 thisStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started