Posted: March 16th, 2017

# Record the portion of each employee’s earnings that is taxable under FICA, FUTA, and SUTA, and calculate the total employer’s payroll taxes on the October 14 payroll.

I have attached an Excel spreadsheet that has to be done with it. I have figured out the employees’s taxes that are due but am having a hard time figuring out the employers side of them.
The form on page 6-45 shows the amounts that appear in the Earnings to Date column of the employees’ earnings records for 10 full-time and part-time workers in Unger Company. These amounts represent the cumulative earnings for each worker as of October 7, the company’s last payday. The form also gives the gross amount of earnings to be paid each worker on the next payday, October 14. In the state where Unger Company is located, the tax rates and bases are as follows:
Tax on Employees:
FICA—OASDI …………………………………………. 6.2% on first \$118,500
FICA—HI ……………………………………………….. 1.45% on total earnings
SUTA ……………………………………………………… 0.5% on first \$8,000
Tax on Employer:
FICA—OASDI …………………………………………. 6.2% on first \$118,500
FICA—HI ……………………………………………….. 1.45% on total earnings
FUTA ……………………………………………………… 0.6% on first \$7,000
SUTA ……………………………………………………… 1.8% on first \$8,000
In the appropriate columns of the form on page 6-45, do the following: 1. 2. Compute the amount to be withheld from each employee’s earnings on October 14 for (a) FICA—OASDI, (b) FICA—HI, and (c) SUTA, and determine the total employee taxes. Record the portion of each employee’s earnings that is taxable under FICA, FUTA, and SUTA, and calculate the total employer’s payroll taxes on the October 14 payroll.

### Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00