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 companys 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:
FICAOASDI …………………………………………. 6.2% on first $118500
FICAHI ……………………………………………….. 1.45% on total earnings
SUTA ……………………………………………………… 0.5% on first $8000
Tax on Employer:
FICAOASDI …………………………………………. 6.2% on first $118500
FICAHI ……………………………………………….. 1.45% on total earnings
FUTA ……………………………………………………… 0.6% on first $7000
SUTA ……………………………………………………… 1.8% on first $8000
In the appropriate columns of the form on page 6-45 do the following: 1. 2. Compute the amount to be withheld from each employees earnings on October 14 for (a) FICAOASDI (b) FICAHI and (c) SUTA and determine the total employee taxes. Record the portion of each employees earnings that is taxable under FICA FUTA and SUTA and calculate the total employers payroll taxes on the October 14 payroll.