Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1,408.00 8 35.20 281.60 1,689.60 104.76 24.50 68.00 51.87 2,250.00 1.01 64.88 8.00 2,250.00 39.50 712 1,366.58 32.63 74.00 69.08 1,689.60 1,689.60 Checkpoints 1,280.00 1.35

image text in transcribed
1,408.00 8 35.20 281.60 1,689.60 104.76 24.50 68.00 51.87 2,250.00 1.01 64.88 8.00 2,250.00 39.50 712 1,366.58 32.63 74.00 69.08 1,689.60 1,689.60 Checkpoints 1,280.00 1.35 1,280.00 86.40 500.00 713 15,796.29 18.56 1,347.04 1,689.60 Total earnings 79.36 86.00 39.30 2,250.00 2,250.00 0.77 49.15 714 1,006.86 2,250.00 1,350.00 ,350.00 19.58 41.45 1,280.00 Net paid 11, 109.84 83.70 0.00 1,280.00 51.84 1,280.00 2,307.69 0.81 2,307.69 43.08 250.00 715 33.46 892.62 60.00 70.85 ,350.00 1,260.00 1.38 1,350.00 88.61 1,350.00 1,260.00 78.12 700.00 716 18.27 1,210.31 84.0 2,307.69 2,307.69 1,368.00 3 27.00 38.68 2,307.69 81.00 0.76 1,449.00 18.38 89.84 21.01 717 24.00 991.79 14.48 0.87 1,260.00 1,260.00 1,260.00 2,050.00 2,050.00 55.64 27 .10 8.00 200.00 718 29.73 179.00 62.94 1,005.16 1,449.00 1.23 1,449.00 66.96 15.66 62.0 1,571.28 1,449.00 1,080.00 1,080.00 78.72 719 33.16 2,050.00 1,080.00 0.65 41.47 2,050.00 720 860.10 1,080.00 1,080.00 2,050.00 1,080.00 66.96 15.66 $2.00 33.16 0.65 41.47 721 860.10 1,080.00 1,080.00 1,080.00 1,080.00 1,080.00 1,080.00 15,433.69 362.60 15,796.29 979.38 229.06 709.00 484.97 9.48 606.56 0.00 16.00 1,650.00 11,111.84 15,796.29 15,796.29 1,080.00 1,080.00 2,307.69 4,700.00 3,600.00 5,188.60 2,394.00 2,394.00 148.43 34.71 1.44 14.70 722 2,194.72 Checkpoints 2,394.00 Total eamings 2,394.00 2,394.00 148.43 34.71 0.00 0.00 .44 0.00 14.70 0.00 0.00 2, 194.72 0.00 0.00 Net paid 0.00 0.00 2, 194.72 0.00 0.00 0.00 0.00 1,408.00 12 35.20 422.40 1,830.40 113.48 26.54 85.00 56.19 2,250.00 1.10 70.28 2,250.00 16.50 9.00 139.50 |723 32.63 1,452.31 69.08 1,830.40 1,830.40 Checkpoints 74.00 1.35 86.40 26.40 500.00 724 1,830.40 1,280.00 1,280.00 1,320.64 2,250.00 2,250.00 Total earnings 111,222.09 79.36 18.56 86.00 2,250.00 1,350.00 39.30 0.77 1,350.00 49.15 14.40 725 992.46 1,280.00 1,280.00 Net paid 70,494.00 83.70 19.58 10.00 41.45 0.81 51.84 15.90 250.00 726 1,280.00 37,307.69 97,307.69 7 27.00 5,751.68 1,410.96 20,900.00 2,987.35 876.72 1,350.00 58.38 3,736.42 1,350.00 27.00 2,000.00 727 60,435.90 1,350.00 1,440.00 189 1,629.00 101.00 23.62 42.00 2,050.00 50.01 0.98 ,646.92 97,307.69 62.55 14.10 127.10 9.00 200.00 728 97,307.69 2,050.00 29.73 179.00 62.94 1.23 1, 125.74 1,629.00 1,629.00 1,629.00 1,065.00 78.72 1,065.00 16.80 729 66.03 15.44 1,554.48 0.00 32.70 2,050.00 0.64 2,050.00 1,200.00 40.89 24.00 1,200.00 730 74.40 17.40 76.00 825.30 2,050.00 36.84 0.72 1,065.00 1,065.00 46.08 12.60 731 935.96 1,065.00 1,260.00 1,260.00 78.12 18.27 84.00 38.68 1,200.00 0.76 1,200.00 48.38 14.70 1,200.00 1,200.00 Checkpoints-Annual 732 977.09 1,200.00 1,260.00 1,260.00 1,260.00 1,260.00 Total eamings 1,260.00 334,573.04 Qtr's taxable OASDI eamings Total eamings for FIT 10,610.69 Total earnings for SIT/CIT 61 1.40 111,222.09 6,614.37 1,612.73 21,596.00 3,414.54 66.74 4,270.71 182.40 18.00 2,950.00 70,496.60 16,561.32 111,222.09 2,460.00 Total earnings for FUTA 73,540.00 2,460.00 97,307.69 5,369.00 3,600.00 4,945.40 192,348.47 11,644.24 2,789.13 25,575.00 5,831.75 115.37 7,293.94 561.30 98.00 6,250.00 334,573.04 20,462.16 4,851.40 41,492.00 10,198.04 200.71 12,755.08 1,491.70 132,189.74 95,293.70 189,954.47 8,050.00 19,920.00 108,846.14 29,742.33 21,600.00 29,766.00 242.00 6,250.00 236,629.95 237,518.27 332,179.04 73,540.00 103,410.00 #REF! #REF! #REF! #REF! A Excel Instructions Payroll Register Employees' Earnings Records +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

324300980, 978-0324300987

More Books

Students also viewed these Accounting questions