Wages and Tax statement data on employer FICA tax.

Ehrlich Co. began business on January 2, 20Y8. Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the required amounts. An employee who is hired in the middle of the month receives half the monthly salary for that month. All required payroll tax reports were filed, and the correct amount of payroll taxes was remitted by the company for calendar year. Early in 20Y9, before the Wage and Tax Statements (From W2) could be prepared for distribution to employees and for filing with the Social Security Administration, the employees earnings records were inadvertently destroyed.

None of the employees resigned or were discharged during the year, and there were no changes in salary rates. The Social security tax withheld at the rate of 6.0% and Medicare tax at the rate of 1.5%. Data on dates of employment, salary,rates, and employees income taxes withheld, which are summarized as follows, were obtained from personal records and payroll records..

Employee

Arnett Date first employed Nov16, Monthly salary $5,500 Monthly Income Tax Withheld $944

Cruz Jan 2, Monthly salary 4,800 Monthly Income Tax Withheld 833

Edwards Oct 1 8,000 1592

Harvin Dec 1 6,000 1,070

Nicks Feb 1 10,000 2,350

Shiancoe Mar 1 11,600 2,600

Ward Nov 16 5,220 876

Question 1

(a) Calculate the amounts to be reported on each employees Wage and Tax statement(Form W2) FOR 20Y8, arranging the data in the following form.

Employee, Gross Earnings, Federal Income Tax Withheld, Social Security Tax Withheld, Medicare Tax Withheld.

(b) Calculate the following employer payroll taxes for the year (1) Social security, (2) Medicare (3) State unemployment compensation at 5.4% on the first $10,000 of each employees earnings. (4) Federal unemployment compensation at 0.6% on the first $10,000 of each employees earnings. (5) Total.