In: Accounting
Paloma Co. has four employees. FICA Social Security taxes are 6.2% of the first $118,500 paid to each employee, and FICA Medicare taxes are 1.45% of gross pay. Also, for the first $7,000 paid to each employee, the company’s FUTA taxes are 0.6% and SUTA taxes are 2.15%. The company is preparing its payroll calculations for the week ended August 25. Payroll records show the following information for the company’s four employees.
| Current Week | ||||||||||||||
| Name | Gross Pay through Aug. 18 |
Gross Pay | Income Tax Withholding | |||||||||||
| Dali | $ | 116,150 | $ | 4,300 | $ | 611 | ||||||||
| Trey | 116,800 | 1,700 | 274 | |||||||||||
| Kiesha | 9,400 | 680 | 59 | |||||||||||
| Chee | 3,350 | 630 | 47 | |||||||||||
In addition to gross pay, the company must pay one-half of the $106 per employee weekly health insurance; each employee pays the remaining one-half. The company also contributes an extra 8% of each employee’s gross pay (at no cost to employees) to a pension fund.
Required:
Compute the following for the week ended August 25.
(Round your intermediate calculations and final answers to
2 decimal places.):
| 1) Employees' FICA Withholdings for Social Security | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 2350 | 6.20% | 145.70 | ||
| Trey | 1700 | 6.20% | 105.40 | ||
| Kiesha | 680 | 6.20% | 42.16 | ||
| Chee | 630 | 6.20% | 39.06 | ||
| Total | 332.32 | ||||
| 2) Employees' FICA Withholdings for Medicare | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 4300 | 1.45% | 62.35 | ||
| Trey | 1700 | 1.45% | 24.65 | ||
| Kiesha | 680 | 1.45% | 9.86 | ||
| Chee | 630 | 1.45% | 9.14 | ||
| Total | 106.00 | ||||
| 3) Employer's FICA Taxes for Social Security | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 2350 | 6.20% | 145.70 | ||
| Trey | 1700 | 6.20% | 105.40 | ||
| Kiesha | 680 | 6.20% | 42.16 | ||
| Chee | 630 | 6.20% | 39.06 | ||
| Total | 332.32 | ||||
| 4) Employer's FICA Taxes for Medicare | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 4300 | 1.45% | 62.35 | ||
| Trey | 1700 | 1.45% | 24.65 | ||
| Kiesha | 680 | 1.45% | 9.86 | ||
| Chee | 630 | 1.45% | 9.14 | ||
| Total | 106.00 | ||||
| 5) Employer's FUTA Taxes | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 0.60% | ||||
| Trey | 0.60% | ||||
| Kiesha | 0.60% | ||||
| Chee | 630 | 0.60% | 3.78 | ||
| Total | 3.78 | ||||
| 6) Employer's SUTA Taxes | |||||
| Employee |
Earnings Subject to Tax |
Tax Rate | Tax Amount | ||
| Dali | 2.15% | ||||
| Trey | 2.15% | ||||
| Kiesha | 2.15% | ||||
| Chee | 630 | 2.15% | 13.55 | ||
| Total | 13.55 | ||||
| 7) Each Employee's Net (take-home) Pay | |||||
| Employee | Dali | Trey | Kiesha | Chee | Total |
| Gross Pay | 4300.00 | 1700.00 | 680.00 | 630.00 | 7310.00 |
| Income tax withholding | 611.00 | 274.00 | 59.00 | 47.00 | 991.00 |
| FICA - Social Security | 145.70 | 105.40 | 42.16 | 39.06 | 332.32 |
| FICA - Medicare | 62.35 | 24.65 | 9.86 | 9.14 | 106.00 |
| Health Insurance | 53.00 | 53.00 | 53.00 | 53.00 | 212.00 |
| Net Pay | 3427.95 | 1242.95 | 515.98 | 481.80 | 5668.68 |
| 8) Total Payroll Related Expense for Each Employee | |||||
| Employee | Dali | Trey | Kiesha | Chee | Total |
| Gross Pay | 4300.00 | 1700.00 | 680.00 | 630.00 | 7310.00 |
| FICA - Social Security | 145.70 | 105.40 | 42.16 | 39.06 | 332.32 |
| FICA - Medicare | 62.35 | 24.65 | 9.86 | 9.14 | 106.00 |
| FUTA | 0.00 | 0.00 | 0.00 | 3.78 | 3.78 |
| SUTA | 0.00 | 0.00 | 0.00 | 13.55 | 13.55 |
| Health Insurance | 53.00 | 53.00 | 53.00 | 53.00 | 212.00 |
| Pension | 344.00 | 136.00 | 54.40 | 50.40 | 584.80 |
| Total Payroll Expense | 4905.05 | 2019.05 | 839.42 | 798.93 | 8562.45 |