Question

In: Accounting

The payroll records of Barnes Co. provided the following data for the current weekly pay period...

The payroll records of Barnes Co. provided the following data for the current weekly pay period ended March 12.

Employees Earnings to End of Previous Week Gross Pay Federal Income Taxes Medical Insurance Deduction Union Dues United Way

R.Short $5,800 $800 $120 $35 $10 $10

L. Skyler 6,850 1,000 180 35 10 15

C. Richard 12,900 1,440 404 35 10 10

The Earnings to End of Previous Week are gross earnings for the year prior to the current weekly pay period ended March 12. Assume that the Social Security portion of the FICA taxes is 6.2% on the first $117,000 and the Medicare portion is 1.45% of all wages paid to each employee for this pay period. The federal and state unemployment tax rates are 0.8% and 5.4%, respectively, on the first $7,000 paid to each employee. Calculate the net pay for each employee. The federal and state unemployment taxes are paid by the employer only. (Check: Net pay for R. Short should be a number between $550 and $575. (3 points)

Solutions

Expert Solution

Compute the net pay for each employee as follows:

Particulars Short Skyler Richard
Gross Pay (a) $800.00 $1,000.00 $1,440.00
Deduct:
          Social security @ 6.2% $49.60 $62.00 $89.28
          Medicare tax @ $1.45% $11.60 $14.50 $20.88
          Federal income tax $120.00 $180.00 $404.00
          Medical insurance deduction $35.00 $35.00 $35.00
          Union dues $10.00 $10.00 $10.00
          United way $10.00 $15.00 $10.00
          Total deductions (b) $236.20 $316.50 $569.16
Net pay of each employee (ab) $563.80 $683.50 $870.84
Note:
Short Skyler Richard
Gross Pay $800.00 $1,000.00 $1,440.00
×   Social security rate 6.20% 6.20% 6.20%
Social security deduction $49.60 $62.00 $89.28
Gross Pay $800.00 $1,000.00 $1,440.00
×   Medicare rate 1.45% 1.45% 1.45%
Social security deduction $11.60 $14.50 $20.88

Related Solutions

The payroll records of Airtech Solutions, Ltd. are provided for the period ended December 7:   Required:...
The payroll records of Airtech Solutions, Ltd. are provided for the period ended December 7:   Required: Compute the necessary information for the payroll journal entries. Complete the entry to accrue the payroll. Complete the entry to record the payroll tax expense. PLEASE show all you work so it is easier to understand, thank you!                      Employee Earnings to End of Previous Week Gross Pay Federal Income Taxes Medical Insurance Deduction Union Dues United Way State Income...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have been intentionally omitted: Earnings: 1. At regular rate ? 2. At overtime rate $79,100 3. Total earnings ? Deductions: 4. Social security tax 31,620 5. Medicare tax 7,905 6. Income tax withheld 134,500 7. Medical insurance 18,200 8. Union dues ? 9. Total deductions 195,000 10. Net amount paid 332,000 Accounts debited: 11. Factory Wages 279,300 12. Sales Salaries ? 13. Office Salaries 105,400...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have been intentionally omitted: Earnings: 1. At regular rate ? 2. At overtime rate $65,400 3. Total earnings ? Deductions: 4. Social security tax 26,220 5. Medicare tax 6,555 6. Income tax withheld 111,200 7. Medical insurance 15,000 8. Union dues ? 9. Total deductions 162,000 10. Net amount paid 275,000 Accounts debited: 11. Factory Wages 231,600 12. Sales Salaries ? 13. Office Salaries 87,400...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have been intentionally omitted: Earnings: 1. At regular rate ? 2. At overtime rate $73,500 3. Total earnings ? Deductions: 4. Social security tax 29,460 5. Medicare tax 7,365 6. Income tax withheld 125,000 7. Medical insurance 16,900 8. Union dues ? 9. Total deductions 182,000 10. Net amount paid 309,000 Accounts debited: 11. Factory Wages 260,200 12. Sales Salaries ? 13. Office Salaries 98,200...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have...
Summary Payroll Data In the following summary of data for a payroll period, some amounts have been intentionally omitted: Earnings: 1. At regular rate ? 2. At overtime rate $70,900 3. Total earnings ? Deductions: 4. Social security tax 28,380 5. Medicare tax 7,095 6. Income tax withheld 120,500 7. Medical insurance 16,300 8. Union dues ? 9. Total deductions 175,000 10. Net amount paid $298,000 Accounts debited: 11. Factory Wages 250,700 12. Sales Salaries ? 13. Office Salaries 94,600...
For each of the following employees, calculate the Social Security tax for the weekly pay period...
For each of the following employees, calculate the Social Security tax for the weekly pay period described: NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation. 1: Ronald McCarthy earned gross pay of $925. Each period he makes a 401(k) contribution of 6% of gross pay. His current year taxable earnings for Social Security tax, to date, are $29,500. Total Social Security tax = $ 2: Jill...
For each of the following employees, calculate the Medicare tax for the weekly pay period described:...
For each of the following employees, calculate the Medicare tax for the weekly pay period described: NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation. 1: Mark Dailey's filing status is Married Filing Jointly, and he has earned gross pay of $3,450. Each period he makes a 403(b) contribution of 9% of gross pay. His current year taxable earnings for Medicare tax, to date, are $312,500. Total...
For each of the following employees, calculate the Medicare tax for the weekly pay period described:...
For each of the following employees, calculate the Medicare tax for the weekly pay period described: NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation. 1:Paul Robinson's filing status is married filing jointly, and he has earned gross pay of $2,700. Each period he makes a 403(b) contribution of 7% of gross pay . His current year taxable earnings for Medicare tax, to date, are $268,000. Total...
The summary of the payroll for the monthly pay period ending July 15 indicated the following:...
The summary of the payroll for the monthly pay period ending July 15 indicated the following: Sales salaries $125,000 Federal income tax withheld 32,300 Office salaries 35,000 Medical insurance withheld 7,370 Social security tax withheld 10,200 Medicare tax withheld 2,550 a. Journalize the entry to record the payroll. If an amount box does not require an entry, leave it blank or enter 0. b. Journalize the entry to record the employer's payroll tax expense for the month. The state unemployment...
The summary of the payroll for the monthly pay period ending December 15 indicated the following...
The summary of the payroll for the monthly pay period ending December 15 indicated the following Sales salaries $165,000 Federal income tax withheld 32,300 Office salaries 34,000 Medical insurance withheld 14,370 Social security tax withheld 12,200 Medicare tax withheld 4,550 Journalize the entries to record (a) the payroll and (b) the employer's payroll tax expense for the month. The state unemployment tax rate is 3.1%, and the federal unemployment tax rate is 0.8%. Only $30,000 of salaries are subject to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT