This is what I have done so far I just need the part that is circled to be filled out
QPR 10-3A Wage and tax statement data on employer FICA tax EXCEL TEMPLATE Obj. 2 Ehrlich Co. began business on January 2. 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 the calendar year. Early in the following year, before the Wage and Tax Statements (Form W-2) 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 was withheld at the rate of 6.0% on salary 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 personnel records and payroll records: Employee Date First Employed Monthly Salary Monthly Income Tax Withheld Arnett Nov. 16 Jan. 2 Oct. 1 $ 944 833 1,592 Cruz Edwards Harvin Nicks Shiancoe Ward 1,070 $ 5,500 4,800 8,000 6,000 10,000 11,600 5,220 Dec. 1 Feb. 1 Mar. 1 Nov. 16 2,350 2,600 876 Instructions 1. Compute the amounts to be reported for the year on each employee's Wage and Tax Statement (Form W-2), arranging the data as follows (round to the nearest cent): Employee Gross Earnings Federal Income Tax Withheld Social Security Medicare Tax Tax Withheld Withheld 2. Compute the following employer payroll taxes for the year: (A) social security, (B) Medicare, (C) state unemployment compensation at 5.4% on the first $10,000 of each employee's earnings, (D) federal unemployment compensation at 0.8% on the first $10,000 of each employee's earnings, (E) total. Amounts to Be Reported on Wage and Tax Statements (Form W-2) Gross Earnings Federal Income Tax Withheld Social Security Tax Withheld Medicare Tax Withheld Employee $ $ Amett Cruz Edwards Harvin Nicks Shiancoe Ward Totals $ 8,250.00 57,600.00 24,000.00 6,000.00 110,000.00 116,000.00 7,830.00 $ 329,680.00 1,416.00 9,996.00 4,776.00 1,070.00 25,850.00 26,000.00 1,314.00 $ 495.00 3,456.00 1,440.00 360.00 6,600.00 6,960.00 469.80 $ 19,780.80 123.75 864.00 360.00 90.00 1,650.00 1,740.00 117.45 4,945.20 $ Employer Payroll Taxes A. Social security tax paid by employer $ 19,780.80 B. Medicare tax paid by employer 4,945.20 C. and D. SUTAFUTA Earnings Employee Amett Cruz Edwards Harvin Nicks Shiancoe Ward Total State unemployment compensation tax 3,352.32 7,830.00 $ 62,080.00 Federal unemployment compensation tax 496.64 E. Total employer payroll taxes $ 28,574.96
