Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started