The names of the employees of Cox Security Systems and their regular salaries are shown in the following payroll register Note that Hall and Short are paid monthly on the last payday, while all others are paid weekly In addition to the regular salaries, the company pays an annual bonus based on the amount of earnings for the year For the current year, the bonus amounts to 8 of the annual salary paid to each employee The bonus is to be paid along with the regular salaries on December 27, but the amount of the bonus and the amount of the regular salary will be shown separately on each employee's earnings statement Assume that all employees received their regular salary during the entire year Prepare the payroll for the pay period ending December 27, showing the following for each employee Use the wage bracket method to withhold federal income tax from the regular salaries Withhold a flat 22 on the annual bonus Total salaries and bonuses are subject to a 2 state income tax and a 1 city income tax Enter all amounts as positive numbers And round all values to the nearest cent THE FOLLOWING TABLE IS FOR 2018 ALL THE RED CHECKED BOXES ARE INCORRECT PLEASE RECALCULATE THE RED CHECKED BOXES No of Earnings Marital W H (a) (b) (c) Status Allowances Regular Supp'l Total OASDI Employee Name Hall, Michael Short, Joy T M 5 $5,000 00 $ 4,800 $ 9,800 $ 607 60 M 2 2,750 00 2,640 5,390 334 18 Abbott, Linda S 1 520 00 2,163 20 2,683 20 166 36 Smith, Joseph M 4 465 00 1,934 40 2,399 40 148 76 Tols, Sean M M 2 380 00 1,580 80 1,960 80 121 57 Villespie, Michelle S 1 350 00 1,456 00 1,806 00 111 97 Smart, Jennifer M N 2 575 00 2,392 2,967 183 95 White, Matthew J S 0 425 00 1,768 00 2,193 135 97 Totals VA 10,465 18,734 40 $ 29,199 40 1,810 36 Deductions (c) FICA (d) (e) (f) (g) OASDI HI FIT SIT CIT Net Pay 607 60 142 10 1,514 X hi 196 98 X $ 7,242 30 334 18 78 16 796 x 107 80 53 90 X X 166 36 38 91 591 80 X 53 66 26 83 X 1,805 64 X 148 76 34 79 483 60 x 47 99 23 99 X 121 57 28 43 39 22 19 61 X X 111 97 26 19 36 12 18 06 x 183 95 43 02 X X X 59 34 29 67 X 135 97 31 80 TON 43 86 21 93 X X 1,810 36 423 40 583 99 291 99 $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 24, 2024

The names of the employees of Cox Security Systems and their regular salaries are shown in the following payroll register. Note that Hall and Short

The names of the employees of Cox Security Systems and their regular salaries are shown in the following payroll register. Note that Hall and Short are paid monthly on the last payday, while all others are paid weekly.

In addition to the regular salaries, the company pays an annual bonus based on the amount of earnings for the year. For the current year, the bonus amounts to 8% of the annual salary paid to each employee. The bonus is to be paid along with the regular salaries on December 27, but the amount of the bonus and the amount of the regular salary will be shown separately on each employee's earnings statement. Assume that all employees received their regular salary during the entire year.

Prepare the payroll for the pay period ending December 27, showing the following for each employee:

Use the wage-bracket method to withhold federal income tax from the regular salaries.
Withhold a flat 22% on the annual bonus.
Total salaries and bonuses are subject to a 2% state income tax and a 1% city income tax.

Enter all amounts as positive numbers. And round all values to the nearest cent.

******THE FOLLOWING TABLE IS FOR 2018 ALL THE RED CHECKED BOXES ARE INCORRECT PLEASE RECALCULATE THE RED CHECKED BOXES*******

No. of Earnings Marital W/H (a) (b) (c) Status Allowances Regular Supp'l. Total OASDI Employee Name Hall, Michael Short, Joy T. M 5 $5,000.00 $ 4,800 $ 9,800 $ 607.60 M 2 2,750.00* 2,640 5,390 334.18 Abbott, Linda S 1 520.00 2,163.20 2,683.20 166.36 Smith, Joseph M 4 465.00 1,934.40 2,399.40 148.76 Tols, Sean M. M 2 380.00 1,580.80 1,960.80 121.57 Villespie, Michelle S 1 350.00 1,456.00 1,806.00 111.97 Smart, Jennifer M N 2 575.00 2,392 2,967 183.95 White, Matthew J. S 0 425.00 1,768.00 2,193 135.97 Totals VA 10,465 18,734.40 $ 29,199.40 1,810.36 Deductions (c) FICA (d) (e) (f) (g) OASDI HI FIT SIT CIT Net Pay 607.60 142.10 1,514 X hi 196 98 X $ 7,242.30 334.18 78.16 796 x 107.80 53.90 X X 166.36 38.91 591.80 X 53.66 26.83 X 1,805.64 X 148.76 34.79 483.60 x 47.99 23.99 X 121.57 28.43 39.22 19.61 X X 111.97 26.19 36.12 18.06 x 183.95 43.02 X X X 59.34 29.67 X 135.97 31.80 TON 43.86 21.93 X X 1,810.36 423.40 583.99 291.99 $