Question

In: Civil Engineering

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.

  1. 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 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 The total amount paid to employees for a certain period.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 A detailed record of each employee's earnings.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% on salary. 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:

    EmployeeDate First EmployedMonthly SalaryMonthly Income Tax Withheld
    ArnettNov. 16$3,300
    $488
    CruzJan. 25,100
    959
    EdwardsOct. 12,500
    310
    HarvinDec. 12,600
    322
    NicksFeb. 110,200
    2,295
    ShiancoeMar. 13,600
    551
    WardNov. 168,400
    1,814

    Required:

    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.

    EmployeeGross EarningsFederal Income Tax WithheldSocial Security Tax WithheldMedicare 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.8% on the first $10,000 of each employee's earnings; (e) total. Round your answers to two decimal places.

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


Solutions

Expert Solution

PART 1: FORM W-2

Based on employment date, numbers of months are calculated and taxes are calculated in below table:

Accordingly form W-2 is generated below in desired format:

PART 2: Employer payroll taxes for the year:

Employer payroll taxes are calculated in below table:

Answers are listed here:

a

Social security

$14,223.00

b

Medicare

$   3,555.75

c

State unemployment compensation

$   2,972.70

d

Federal unemployment compensation

$      440.40

e

Total

$21,191.85


Related Solutions

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 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...
Journalize the transactions​ (explanations are not​ required). ​(Round all amounts to the nearest cent. Record debits​...
Journalize the transactions​ (explanations are not​ required). ​(Round all amounts to the nearest cent. Record debits​ first, then credits. Exclude explanations from journal​ entries.) Trevor Publishing completed the following transactions during 2016 Oct 1   Sold a​ six-month subscription​ (starting on November​ 1), collecting cash of $390 ​, plus sales tax of 4 % Nov 15 Remitted​ (paid) the sales tax to the state of Tennessee. Dec 31 Made the necessary adjustment at​ year-end to record the amount of subscription revenue...
For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent:...
For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent: ​Employee: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​% up to $200,000​, 2.35​% on earnings above $200,000. ​Employer: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​%; ​FUTA: 0.6​% on first $7,000 ​earned; SUTA: 5.4​% on first $7,000 earned. Robinson works at College of Boston and is paid $30 per hour for a​ 40-hour workweek and​ time-and-a-half for hours above 40. For all payroll​ calculations,...
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
Calculate the missing items in the following. Enter all numbers as positive values. Sales Sales Returns...
Calculate the missing items in the following. Enter all numbers as positive values. Sales Sales Returns and Allowances Net Sales Beginning Merchandise Inventory Net Purchases Cost of Goods Available for Sale Ending Merchandise Inventory Cost of Goods Sold Gross Profit a. $242,000   $6,000   $   $152,000   $170,000   $   $136,000         $186,000   $   b. 304,000      297,000   134,000      404,000   176,000         228,000      c.    10,000   628,000      416,000   486,000   89,000           
For each of the following independent cases (1–4), compute the missing values. (Enter all amounts as...
For each of the following independent cases (1–4), compute the missing values. (Enter all amounts as positive values.) Case 1 Case 2 Case 3 Case 4 Beginning raw materials $5,400 $23,000 $106,000 Raw material purchases 54,000 11,850 42,640 Indirect materials issued 600 1,100 1,400 2,800 Ending raw materials 1,200 4,150 93,700 Direct materials used 13,900 33,520 Direct labor 32,000 122,350 Manufacturing overhead 54,000 40,250 30,080 541,730 Total current manufacturing costs 75,600 94,600 Beginning work in process 48,000 36,600 101,820 Ending...
For each employee listed, use the wage-bracket method to calculate federal income tax withholding. 1:Phil McGlynn...
For each employee listed, use the wage-bracket method to calculate federal income tax withholding. 1:Phil McGlynn (Married; 3 federal withholding allowances) earned weekly gross pay of $750. Federal income tax withholding = $ 2:Gary Williams (single; 1 federal withholding allowance) earned biweekly gross pay of $1,920. He participates in a flexible spending account, to which he contributes $50 during the period. Federal income tax withholding = $ 3:Lila Downing (single; 2 federal withholding allowances) earned monthly gross pay of $1,285....
Tax Return #2, Partnership Return (Form 1065, only Page 1 and Schedule K required) Background The...
Tax Return #2, Partnership Return (Form 1065, only Page 1 and Schedule K required) Background The Rowdy Fun is a limited partnership and was formed on June 1, 2005, by Thomas Kyle, its general partner, and two other limited partners when they each contributed an equal amount of cash to start the new enterprise. Rowdy Fun is an outdoor equipment retailer focused on selling outdoor activities gear. Thomas has a 33.33% profits and capital interest and the limited partners hold...
1 (Disposal of depreciating assets) Required: The following are all resident taxpayers. In each case, calculate...
1 (Disposal of depreciating assets) Required: The following are all resident taxpayers. In each case, calculate the deduction available for decline in value as well as any assessable income (if any) arising from the disposals during the 2017/18 tax year. 1) Hannah sold equipment from her factory on 31 May 2018 for $9,200. The equipment had originally cost $11,000 and was depreciated using the prime cost method using an effective life of 5 years. The opening adjustable value was $6,000...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT