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 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
Get step-by-step solutions from verified subject matter experts
