can someone please help me by giving the FIT (federal income tax) per employee and date in order for me to be able complete the whole payroll ?

UTF-8'Payroll project in Excel renra modify - Saved Rene Ramirez & File Home Insert Draw Formulas Data Review View Formula Bar Gridlines Headings Sheet Tabs Sheet Right-to-Left Zoom In Zoom Out Freeze Panes fx BODEFGHI JKLMNO P Q R S T U v w X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW PAYROLL REGISTER GLO-BRITE PAINT COMPANY W N Regular Earnings Overtime Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution Lo.W/ Allow iling Status Rat Rate Per Per NAME Hour Total Group Union OASDI SUTA CIT Dues SIMPLE No. Amount OASDI FUTA SUTA Admin. 20 Payday, October 23, 20.. For Period Ending October Bonno, A. 93.84 Checkpoints 22 Ferguson, 1.513.60 1.513.60 15.778.37 23 Ford MFJ N/A 8 8 8 NA 4 8 8 8 8 80 .250.00 39.50 139.00 9.08 683 ,746.94 2,250.00 1,220.00 2,250.00 82.00 MFJ NA 684 2.250.00 Total eamings. 75.64 24 Mann, D. 17.69 37.45 944.86 1,220.00 1,220.00 12,401.43 Net paid 1? 83.70 19.58 39.00 25 O'Neill, J. 41.45 1 350 00 1.220.00 1,220.00 MFJ N/A 8 8 8 8 8 .097.30 .350.00 07.69 143.08 70.85 250.00 1,350.00 46.00 1.350.00 26 Russell, V. ,307.69 S NA 8 8 8 8 8 8.00 ,307.69 74.40 2,307.69 10.00 27 Ryan, N. 30.00 MFJ N/A 8 8 1,656.00 MFJ N/A 8 8 8 8 8 8 27.00 216.00 1,200.00 28 Sokowski, T. 8 8 80 18.00 1.440.00 102.6 24.01 19.00 200.00 1.200.00 80 29 (Student) 8 8 2,050.00 56.00 1,656.00 S NA 72 14.00 1.008.00 2,050.00 127-10 8.00 8 8 8 8 6.00 1.599.64 ,050 col 1.656.00 8 1,008.00 2,050.00 30 Williams, R NIA 3 08 62.50 14.62 2,050.00 75.83 .008.00 1,008.00 442.00 1.008.00 1,008.00 1,223.08 32 33 34 TOTALS 15.456.77 321.60 15.778.37 978.26 228.80 836.00 484.42 9.45 610.81 12.401.43 15,778.37 15.778.37 692.00 4.778.00 2.307.69 4.651.08 3.600.00 5.219.60 Payday. November 6. 20-- For Period Ending October 31, 20- 36 Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 17.60 MFJ N/A 8 1,408.00 1,408.00 Checkpoints 37 Ferguson, J. 2.250.00 87.30 Ford, C. S NA 8 8 8 8 8 2.250.00 39.50 20.4 -148.70 1408.00 1,408.00 1,408.00 8 8 8 8 8 80 75.64 ,250.00 Total eamings. 15,411.54 1.220.00 MFJ N/A 8 8 8 8 8|8 8 8 8 8 80 17.69 2,250.00 2,250.00 Net paid 12.240.52 Mann, D. 1,350.00 9.26 1,220.00 1.220.00 1.220.00 40 O'Neill, J. 8 8 8 2.307.69 1,350.00 83.70 19.58 9.00 80 307.69 1,350.00 3 8 8 33.46 1.113.20 1,350.00 1.350.00 1,350.00 Russell, V. S N/A 8 8 78 15.00 1.170.00 1.170.00 143.0 146.0 1.823.58 2,307.69 2,307.69 2,307.69 Ryan, N. 16.97 MFJ N/A 918.58 43 Sokowski, T. S NA 8 8 8 80 18.00 1.440.00 1.440.00 8 8 1,170.00 1,170.00 2,050.00 89.28 20.88 698 2.02 1.440.00 1.170.00 1.440.00 44 2.050.00 127.1 SNA 8 8 8 8 4 29.73 18.0 1,008.00 .631.64 2.050.00 2.050.00 1.440.00 [Student) 2,050.0 45 Williams, 1,008.00 NA 8 8 8 4 72 14.62 8 8 8 6.00 804. 31 79 15.29 1.207.8 74 8 7 57 1.008.00 1.008.00 1.207.85 2 00 700 1,008.00 948 89 1.207.85 1.207.85 48 49 TOTALS 15.411.54 15.411.54 836.00 473.16 596.62 16.00 0.00 12.301.52 15,411.54 15.411.54 Payday. November 13, 20-- For Perio 0.00 4.748.00 2,307.69 3,600.00 0.00 Williams, R. NA 52 2.079.32 2.079.32 128.92 30.15 268.00 63.84 14.40 1.492.27 2.079.32 2.079.32 Checkpoints 2.079.32 Total eamings 2,079.32 53 TOTALS 2.079.32 2.079.32 128 92 30.15 268.00 63.84 1.25 80.49 14 0.00 0.00 1.492.27 2.079.32 2.079.32 Payday. November 20. 20-- For Period Ending November 14. 20-- 0.oo 0.00 0.00 2.079.32 Net paid 1,567.27 0.00 55 Bonno, A. MFJ N/A 56 Ferguson, J. MFJ N/A & 8 8 8 64 17.60 1.126.40 1.126.40 69.84 Checkpoints 2.250.00 936.86 Total eamings 13,922.09 57 Ford, C. S NA 8 8 8 8 80 16.00 1.220.00 75.64 500.00 .393.94 Net paid | 9.444.49 Mann, D. MFJ N/A 8 8 8 59 O'Neill, J. 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 MFJ N/A 8 8 8 8 8 83.70 .026.86 8 8 8 8 8 80 2.307.69 250.00 886.30 2,307.69 60 Russell, V 143.08 33.46 S NA 6 8 8 8 8 8 8 8 8 8 78 15.75 1,170.00 700.00 242.58 MFJ N/A 62 Sokowski, T. 8 8 72.54 16.97 Ryan, N. 8 8 8 80 18.00 1 170.00 S NA 1.440.00 8 8 8 8 8 8 8 8 8 8 89.28 2,050.00 2.050.00 127.10 200.00 63 (Student) 64 5N/A 8 8 8 8 4 8 8 8 84 29.73 72 14.00 1.008.00 1,008.00 62.50 14.62 .725.64 39.02 11.70 848.61 65 67 68 TOTALS 13,922.09 13.922.09 8 201.89 0.00 427.43 8.34 538.96 166.80 16.00 1.650.00 10.049.49 0.00 0.00 0.00 0.00 69 Payday. December 4. 20-- For Period Ending No 0.00 0.00 0.00 70 Bonno, A. 71 Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 8 80 17.60 1.408.00 8 35.20 281.60 1.689.60 MENA 8 8 8 8 8 8 8 8 8 8 80 104.76 24.50 2.250.00 2 250 00 139 50 51.87 1.01 65.41 69.08 1.35 87.10 8.00 500.00 1.434.05 Checkpoints 1.420.34 Total eamings 15,724.29 Net paid 11,009.44 + Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records 31 O M 2 2:20UTF-8'Payroll project in Excel renra modify - Saved Rene Ramirez & File Home Insert Draw Formulas Data Review View Formula Bar Gridlines Headings Sheet Tabs Sheet Right-to-Left Zoom In Zoom Out Freeze Panes fx BODEFGHI JKLMNO P Q R S T U v w X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW PAYROLL REGISTER GLO-BRITE PAINT COMPANY W N Regular Earnings Overtime Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution Lo. W/H Allow iling Status Rat kate Per Per NAME Total Hour Group Union OASDI ICK SUTA CIT Dues SIMPLE NO. OASDI FUTA SUTA Admin. Payday, November 20, 20-. For Period Ending Novemb 55 Bonno, A. MFJ N/A 8 8 8 8 8 Checkpoints 56 Ferguson, J. 8 8 8 64 17.60 1.126.40 MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2.250.00 .126.40 69.84 2.250.00 16.35 39.50 32.63 500.00 936.86 13,922.09 57 Ford, C. 220 00 58 S NA 8 8 8 8 8 8 8 8 8 8 80 16.00 7.10 393.94 Total eamings 1.220.00 75.64 8 8 8 17.69 Net paid 9,444.49 ann, D. MFJ N/A 8 8 8 8 80 59 O'Neill , J . 1,350.00 19 58 .026.86 250.00 886.30 2,307.69 60 Russell, V. MFJN/A 8 8 8 8 8 8 8 8 8 8 2,307.69 143.08 700.00 SNA 6 8 8 8 8 8 8 8 8 8 78 15.75 242.58 1.170.00 61 1,170.00 MFJ N/A 8 8 8 72.54 440 90 16.97 8 8 8 80 18.00 984.48 Ryan, N. 62 1.440.00 89.28 20.88 .004.22 Sokowski, T. NA 8 8 80 200.00 (Student) NA 8 8 8 8 4 8 8 8 4 72 14.00 1,008.00 2.050.00 .008.00 62 50 -725.64 848 67 65 66 68 TOTALS 13.922.09 13.922.09 863.18 201.89 0.00 427.43 16.00 1.650.00 10.049.49 0.00 0.00 69 Payday. December 4. 20-. For Period Ending November 28, 20- 0.00 000 0.00 70 Bonno, A. Checkpoints Ferguson, J. MFJ N/A MFJ N/A 8 8 8 8 8 8 8 8 8 8 8 80 17.60 1.408.00 8 35.20 281.60 A 8 8 8 8 8 8 8 8 8 8 80 2.250.00 1.689.60 2,250.00 104.76 24.50 8.00 1.434.05 Total eamings 15.724.29 72 Ford, C. S NA 8 80 16.00 1.280.00 .280.00 500.00 1.420.34 73 Mann, D. 74 MFJ NA 8 8 8 8 8 8 8 8 8 8 80 79.36 1,350.00 MFJ N/A 8 .350.00 83.70 .092.46 Net paid 11.009.44 80 43.08 19.58 250.00 902.20 75 Russell, V S NA 307.69 80 15.75 1,260.00 1.269.58 76 Ryan, N. 76 18.00 1,260.00 MFJ NA 1.368.00 .075.39 1,449.00 S NA 3 27.00 78.12 77 Sokowski, T. 80 2,050.00 2.050 00 8.00 200.00 028.71 78 (Student) NA 1,008.00 .749.64 79 Woods, B NA 72 14.00 .008.00 72 15.00 080 00 860.31 80 21.76 81 82 TOTALS 15,361.69 362.60 15,724.29 974.92 228.02 0.00 4 9.43 608.72 0.00 16.00 1,650.00 11,754.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payday, December 14, 20-- For Period Ending Dec Russell, V. 85 S N/A 8 8 8 8 8 8 8 8 8 0 |152 15.75 2.394.00 2.394.00 148.43 34.71 1.44 14.70 722 2.194.72 2.394.00 2.394.00 Checkpoints 2.394.00 Total eamings 2,394.00 86 TOTALS 2:394.00 2.394.00 34.71 0.00 1.44 2,194.72 0.00 0.00 14.70 0.00 0.00 2.194.72 2,394.00 2.394.00 0.00 0.00 2.394.00 Net paid 0.00 Payday. December 18. 20-- For Period Ending Bonno, A. MFJ N/A 4 8 8 8 8 8 8 8 8 8 8 8 80 17.60 1.408.00 12 35.20 422.40 89 Ferguson, J. MFJ N/A 8 8 8 8 8|8 8 8 8 8 80 1.830.40 113.48 26.54 2.250.00 139.50 $9.00 1.10 2,250.00 1.35 70.86 9.00 723 1.447.73 1,830.40 1.830.40 Checkpoints 10.00 16.50 6.40 500.00 724 1,830.40 90 NA 8 8 8 8 8 8 76 16.00 280.00 32.63 Total eamings 101,151.09 Ford. C. 79.36 9.00 1,313.94 2,250.00 2,250.00 1.280.00 18.56 49.5 725 988.46 1.280.00 2.250.00 Net paid 63,992.10 Mann, D. MFJN/A 1,350.00 83.70 5.00 92 O'Neill, J. 8 8 8 5.90 250.00 726 871.30 1.280.00 1,280.00 87.307.69 52.2 1,350.00 1,350.00 1,350.00 93 MFJ N/A 8 8 8 8 8 MFJ N/A 8 9 9 9 9 8 8 8 8 80 8 8 9 8 80 18.00 1,440.00 87,307.69 5,747.40 1,265.96 18,700.00 2,680.35 101.00 SNA 8 8 8 8 8 7 27.00 189.00 52.38 3.379.86 27.00 1.629.00 94 Sokowski, T. 23.62 47.00 50 07 0.98 63.06 16.80 2.000.00 727 53,454.74 87,307.69 87,307.69 80 2,050.00 200.00 728 1.117.53 1.629.00 1.629.00 87,307.69 2,050.00 127.10 9.00 29.73 186.00 62.94 95 (Student) NA 8 8 7 8 4 4 8 8 8 4 71 14.00 1.23 79.36 24.00 729 1.629.00 1,539.64 2,050.00 994.00 ,050.00 2,050.00 994.00 61.63 14.41 54.00 30.52 96 Woods, B. NA 8 8 8 8 8 8 8 8 8 8 0.60 38.48 11.70 730 80 15.00 1,200.00 782.66 994.00 994.00 .200.00 74.40 17.40 994.00 Checkpoints-Annual 97 Young. P 98 NA 8 8 8 8 8 8 8 8 8 8 8 80 15.75 1,260.00 80.00 36.84 0.72 16.45 14.10 731 1.260.00 78.12 18.27 38.68 18.78 930.09 1,200.00 1,200.00 4.70 732 1,200.00 973.69 Total earnings 1,260.00 1.260.00 1.260.00 Qtr's taxable OASDI eamings 99 Total earnings for FIT 100 Total earnings 101 TOTALS 100.539.69 611.40 101.151.09 6,605.69 1.466.70 19.427.00 3,105.36 Total earnings for FUTA 102 60.70 3,915.76 182.10 18.00 2,950.00 63.419.78 101,151.09 101,151.09 0.00 0.00 87,307.69 3,474.00 4.860.00 5.509.4 103 QTR 104 YEAR 181.917.47 2.637.90 22 203.00 5,511.52 109.08 324.142.04 20,431.18 4.700.17 38,120.00 9,877.81 19 6,949.73 559.20 130.00 6.250.00 125.953.78 152,271.09 152.271.09 105 274.00 6.250.00 4.510.00 14,304.00 94,230.76 20,849.48 12,060.00 20.525.00 230.349.33 294.495.66 294.495.66 70.000.00 97.794.00 + Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records 31 M 0 2 7 2:20