Question

In: Accounting

Calculate the amounts to be reported on each employee's Wage and Tax Statement (Form W-2) for 20Y8.

Wage 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 the calendar year. Early in 20Y9, 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% 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
ArnettJan. 2$3,200
$448
CruzOct. 15,400
972
EdwardsApr. 162,700
338
HarvinNov. 12,400
300
NicksJan. 165,800
1,305
ShiancoeDec. 13,400
527
WardFeb. 16,400
1,376

Required:

1. Calculate the amounts to be reported on each employee's Wage and Tax Statement (Form W-2) for 20Y8.

Note: Round amounts to the nearest whole dollar and enter all amounts as positive values.


Employee
Gross
Earnings
Federal Income
Tax Withheld
Social Security
Tax Withheld
Medicare
Tax Withheld
Arnett$
$
$
$
Cruz







Edwards







Harvin







Nicks







Shiancoe







Ward










$
$

2. Calculate 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.6% on the first $10,000 of each employee’s earnings; (e) total.

Note: Round amounts to the nearest whole dollar and enter all amounts as positive values.

(a)$
(b)$
(c)$
(d)$
(e)$

Solutions

Expert Solution

1.Amounts to be reported on each employee's Wage and Tax Statement (Form W-2) for 20Y8.
Employee Date Employed No.of months To Dec.31 Monthly Salary Gross Earnings Mthly. Federal Income Tax Withheld Total tax with-held Social Security Tax withheld Medicare Tax withheld Net Earnings
1 2 3 4=2*3 5 6=2*5 7=4*6% 8=4*1.5% 9=4-6-7-8
Arnett Jan. 2 12 3200 38400 448 5376 2304 576 30144
Cruz Oct. 1 3 5400 16200 972 2916 972 243 12069
Edwards Apr. 16 8.5 2700 22950 338 2873 1377 344.25 18355.75
Harvin Nov. 1 2 2400 4800 300 600 288 72 3840
Nicks Jan. 16 11.5 5800 66700 1305 15008 4002 1001 46690
Shiancoe Dec. 1 1 3400 3400 527 527 204 51 2618
Ward Feb. 1 11 6400 70400 1376 15136 4224 1056 49984
TOTAL 222850 42436 13371 3343 163701
2.       Employer Payroll taxes
(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.6% on the first $10,000 of each employee’s earnings; (e) total.
a b c d e
2304 576 540 60 3480
972 243 540 60 1815
1377 344 540 60 2321
288 72 259 29 648
4002 1001 540 60 5603
204 51 184 20 459
4224 1056 540 60 5880
13371 3343 3143 349 20206

Related Solutions

1. Calculate the amounts to be reported on each employee's Wage and Tax Statement (Form W-2). Enter amounts to the nearest cent if required. Enter all amounts as positive numbers.
Wage and Tax Statement Data on Employer Federal Insurance Contributions Act tax used to finance federal programs for old-age and disability benefits (social security) and health insurance for the aged (Medicare).FICA TaxEhrlich 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...
Sarah received a 2018 Form W-2 from 2 different employers. The amounts reported in Boxes 3...
Sarah received a 2018 Form W-2 from 2 different employers. The amounts reported in Boxes 3 and 4 of her W-2s is provided below. What amount of excess social security tax (if any) should she report on her 2018 Schedule 5, Line 72? Box 3: Social security wages Box 4: Social security tax withheld Employer #1 87,600.00 5,431.20 Employer #2 55,250.00 3,425.50
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.
age and Tax Statement Data on Employer FICA TaxEhrlich 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...
Calculate amounts for each case
Calculate amounts for each case
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2,...
Wage 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...
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2....
Wage and Tax Statement Data on Employer FICA Tax 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...
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2,...
Wage 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...
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2,...
Wage 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...
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2,...
Wage 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...
Wage and Tax Statement Data on Employer FICA Tax Ehrlich Co. began business on January 2....
Wage and Tax Statement Data on Employer FICA Tax 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT