Can someone please help me answer the question :( Thank you so much. This question is very confusing

DARI DEDUCTO Date Regular Hour Overtime Pay Regu Overi Pay Hours 1350000 1 84800 12.70 833 00 FICA Gross Pwy Social Security GIL40500 GIL 20700 3.500.00 21100 224805 113938 1833:00 5165 88 00 49 00 Medicare Fed To GIL 2070 GAL 2016 50 15 305.00 3260 1208 0.00 40005 210.00 2000 on 10 16587276538 1124 30189 1764 18 21 142 18 128 2716 Employee Nov. 15 Ray Kramer Jim Adams Nancy Ford Nov. 30 Ray Kramer Jim Adams Nancy Ford Monthly Totals EC 88 00 52 00 350000 1 84800 14 30 88400 45045 350000 229845 88400 21700 14250 54 81 50 75 33.33 12 81 303 00 22100 000 163.87 10439 2968 276538 131 119723 138 184 70 1939 1 24 1300 850501321350 82234 V 19232 103700 59086 1012048 RKV Dec. 15 Ray Kramer Jim Adams Nancy Ford 350000 184800 149000 11 60 1 20 88 00 88 00 3500 00 36540 221340 3060 052660 21700 13723 9465 50 75 3209 22 14 303 00 20300 5100 163 87 100 18 6149 276538 1149 1740 90 1150 124132 1151 WAREN SPORTS SUPPLY Net Pay Calculations Please show the amounts for gross pay, FIT and SIT withheld, FICA taxes and the net pay for each employee and include an explanation of how you calculated each amount. (You don't have to use Microsoft Excel formulas for anything related to this assignment.) Ray Kramer Jim Adams Nancy Ford EMPLOYEE EARNINGS SUBSIDIARY LEDGER *****-4832 Employee's Name Nancy Ford Soc. Sec. No. Home Address 1018 Whittier, Chicago 60823 Phone No. Employed 10/1/22 Date of Termination Date of Birth 5/22/1989 Occupation Clerk 351-5251 Date Hours Worked Period Regular Overtime Ending Paid Hours Hours 10-01-22 Balance Forward Gross Pay 0.00 FICA Social Security Medicare 0.00 000 Federal Income Tax 000 State Income Tax 0.00 Net Pay 10000 50 59 10-15-2210-14 - 22 48.00 10-31-2200 - 3 1 - 22 5 000 Cumulative Annual Total 81 6100 85000 1166600 5270 1183 1233 24.10 000 ooo 000 26/32 2 800 5432 112720 17.5641 1418 422 103/24 8 3300 88 400 313 83.00 01-15-2211 - 15 - 22 4.900 01 - 30-2201-30 - 22 52.00 Cumulative Annual Total 5165 54 81 1209175 208 12 81 149105 0.00 000 00 27/16 29/68 1142 11 7 8 9 10 3 0 13.04 11 2 2 14 2 15 5 000 1/2 41 32 194/65 8 800 120 12-15-22 12-15-22 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Jim Adams Soc. Sec. No. *****.9833 Home Address 2522 Longfellow, Chicago 60823 Phone No. 351-5874 Employed 1/16/18 Date of Termination Date of Birth 10/1/1993 Occupation Accounting Clerk Date Hours Worked FICA Period Regular Overtime Gross Social Ending Paid Hours Hours Pay Security Medicare 10-01-22 Balance Forward 3 4 5 6 7 81 2267 21 53 0 23 Federal Income Tax 325.00 State Income Net Tax Pay CA18 28.104 25 EMPLOYEE EARNINGS SUBSID 10-05-2210 - 14 - 22 8 000 10-31-2200-31 - 2.2 8 800 Cumulative Annual Total 570 8/25 1859 55 210188 40 513 530 01529 03061 215 13 19 26.90 3 056 5 8 11 10 15400 118 4ool 35 53100 148063 19496 16676 081 8803206255 10-15-2211-05-22 8 800 01-30-2201-30 - 22 8800 Cumulative Annual Total 1 2170 14 30 2/2 48/05 2/2 98/45 4.510 8 1180 13938 14 2.50 2 79501 32/60 3333 5369 210.00 122100 3198 A 00 0184 0418 1104139 0192 23 20.25 083 56 2396 2013 00 1740/90 13123 100 18 13209 1160 221 340 12 - 15-22 12-15-22 88.00 FAYROLL JOURNAL NOVET AVEC TUBE Date Regular Hours GIL 20300 GL1010 88.00 49.00 Employee Nov. 15 Ray Kramer Jim Adams Nancy Ford Nov. 30 Ray Kramer Jim Adams Nancy Ford Monthly Totals FC EARNINGS DEDUCTIONS PATHERE FICA Regular Overtime Overtime Gross Pay Pay Social Security Medicare Fedine. Ta Hours Pay GAL. 40500 Stats Inc. Te GIL 20790 GIL 20700 Pwy Check Post GIL 2 350000 3500.00 21700 50 15 303.00 184800 12 10 163.87 40005 2248 05 13939 2765384126 3200 210.00 10184 176 18 121 833 00 183300 51165 12.08 0.00 27 16 1142 11/112.8 350000 350000 217.00 50 15 30200 163.87 276538 137 184800 14 30 45045 2298 45 142.50 3333 221 00 10439 119723138 88400 88400 54 81 1281 000 2968 784 10 139 88 00 52 00 12413.00 850 50 13 26350 82234 192.32 103100 59086 1062098 RKV Dec. 15 Ray Kramer Jim Adams 88 00 88 00 350000 184800 1160 149600 120 36540 3060 3 500 00 221340 52660 21700 13723 19465 50 75 3209 22 14 303 00 20300 5100 163.81 276538 149 100 18 114090 1150 149 129732 1151 Nancy Ford Rate Illus Unid Fung Wit Allowances tot w Ray Kramer $3,400.00 $3.500.00 semimonthly semimonthly M M 12/16/20 12118121 Jim Adams $20.00 $21.00 hourly hourly 12/18/20 12/16/21 WK Nancy Ford $17.00 hourly M 3 10/1/22 Hire date 14 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Ray Kramer Soc. Sec. No. ****** 2376 Home Address 417 Cherry, Chicago, 60912 Phone No. 781-3565 Employed 4/6/11 Date of Termination Date of Birth 2/15/1979 Occupation Manager Date EMPLOYEE EARNINGS SUBSIDIARY LEDGER FICA Hours Worked Period Regular Overtime Ending Paid Hours Hours 10-01-22 Balance Forward Gross Pay 6300000 Social Security 3/90600 Medicare 1913 50 Federal Income Tax 545 400 State Income Net Tax Pay 2 94.96 491 1484 10-15-2210- 14-22 1o-3 1-/2210-31-22 Cumulative Annual Total 350 000 350 000 7oooooo 21700 121700 434000 50 75 50 75 101 500 130 300 302 00 Ulololoo 163 87 1216538 163181 27 6538 327140 553 o 1.o 15075 350 000 350 000 7710 o oloo 11-05-22 01-05-22 11-30-2211-30 - 22 Cumulative Annual Total 217100 2. 17.00 4714100 50 15 il 150 30 300 30 300 161666.00 16387 217 65138 276538 slu 05 08 3.8136 27 65138 30 300 50 15 16381 21100 350 000 112-115-22 12-15-22 DARI DEDUCTO Date Regular Hour Overtime Pay Regu Overi Pay Hours 1350000 1 84800 12.70 833 00 FICA Gross Pwy Social Security GIL40500 GIL 20700 3.500.00 21100 224805 113938 1833:00 5165 88 00 49 00 Medicare Fed To GIL 2070 GAL 2016 50 15 305.00 3260 1208 0.00 40005 210.00 2000 on 10 16587276538 1124 30189 1764 18 21 142 18 128 2716 Employee Nov. 15 Ray Kramer Jim Adams Nancy Ford Nov. 30 Ray Kramer Jim Adams Nancy Ford Monthly Totals EC 88 00 52 00 350000 1 84800 14 30 88400 45045 350000 229845 88400 21700 14250 54 81 50 75 33.33 12 81 303 00 22100 000 163.87 10439 2968 276538 131 119723 138 184 70 1939 1 24 1300 850501321350 82234 V 19232 103700 59086 1012048 RKV Dec. 15 Ray Kramer Jim Adams Nancy Ford 350000 184800 149000 11 60 1 20 88 00 88 00 3500 00 36540 221340 3060 052660 21700 13723 9465 50 75 3209 22 14 303 00 20300 5100 163 87 100 18 6149 276538 1149 1740 90 1150 124132 1151 WAREN SPORTS SUPPLY Net Pay Calculations Please show the amounts for gross pay, FIT and SIT withheld, FICA taxes and the net pay for each employee and include an explanation of how you calculated each amount. (You don't have to use Microsoft Excel formulas for anything related to this assignment.) Ray Kramer Jim Adams Nancy Ford EMPLOYEE EARNINGS SUBSIDIARY LEDGER *****-4832 Employee's Name Nancy Ford Soc. Sec. No. Home Address 1018 Whittier, Chicago 60823 Phone No. Employed 10/1/22 Date of Termination Date of Birth 5/22/1989 Occupation Clerk 351-5251 Date Hours Worked Period Regular Overtime Ending Paid Hours Hours 10-01-22 Balance Forward Gross Pay 0.00 FICA Social Security Medicare 0.00 000 Federal Income Tax 000 State Income Tax 0.00 Net Pay 10000 50 59 10-15-2210-14 - 22 48.00 10-31-2200 - 3 1 - 22 5 000 Cumulative Annual Total 81 6100 85000 1166600 5270 1183 1233 24.10 000 ooo 000 26/32 2 800 5432 112720 17.5641 1418 422 103/24 8 3300 88 400 313 83.00 01-15-2211 - 15 - 22 4.900 01 - 30-2201-30 - 22 52.00 Cumulative Annual Total 5165 54 81 1209175 208 12 81 149105 0.00 000 00 27/16 29/68 1142 11 7 8 9 10 3 0 13.04 11 2 2 14 2 15 5 000 1/2 41 32 194/65 8 800 120 12-15-22 12-15-22 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Jim Adams Soc. Sec. No. *****.9833 Home Address 2522 Longfellow, Chicago 60823 Phone No. 351-5874 Employed 1/16/18 Date of Termination Date of Birth 10/1/1993 Occupation Accounting Clerk Date Hours Worked FICA Period Regular Overtime Gross Social Ending Paid Hours Hours Pay Security Medicare 10-01-22 Balance Forward 3 4 5 6 7 81 2267 21 53 0 23 Federal Income Tax 325.00 State Income Net Tax Pay CA18 28.104 25 EMPLOYEE EARNINGS SUBSID 10-05-2210 - 14 - 22 8 000 10-31-2200-31 - 2.2 8 800 Cumulative Annual Total 570 8/25 1859 55 210188 40 513 530 01529 03061 215 13 19 26.90 3 056 5 8 11 10 15400 118 4ool 35 53100 148063 19496 16676 081 8803206255 10-15-2211-05-22 8 800 01-30-2201-30 - 22 8800 Cumulative Annual Total 1 2170 14 30 2/2 48/05 2/2 98/45 4.510 8 1180 13938 14 2.50 2 79501 32/60 3333 5369 210.00 122100 3198 A 00 0184 0418 1104139 0192 23 20.25 083 56 2396 2013 00 1740/90 13123 100 18 13209 1160 221 340 12 - 15-22 12-15-22 88.00 FAYROLL JOURNAL NOVET AVEC TUBE Date Regular Hours GIL 20300 GL1010 88.00 49.00 Employee Nov. 15 Ray Kramer Jim Adams Nancy Ford Nov. 30 Ray Kramer Jim Adams Nancy Ford Monthly Totals FC EARNINGS DEDUCTIONS PATHERE FICA Regular Overtime Overtime Gross Pay Pay Social Security Medicare Fedine. Ta Hours Pay GAL. 40500 Stats Inc. Te GIL 20790 GIL 20700 Pwy Check Post GIL 2 350000 3500.00 21700 50 15 303.00 184800 12 10 163.87 40005 2248 05 13939 2765384126 3200 210.00 10184 176 18 121 833 00 183300 51165 12.08 0.00 27 16 1142 11/112.8 350000 350000 217.00 50 15 30200 163.87 276538 137 184800 14 30 45045 2298 45 142.50 3333 221 00 10439 119723138 88400 88400 54 81 1281 000 2968 784 10 139 88 00 52 00 12413.00 850 50 13 26350 82234 192.32 103100 59086 1062098 RKV Dec. 15 Ray Kramer Jim Adams 88 00 88 00 350000 184800 1160 149600 120 36540 3060 3 500 00 221340 52660 21700 13723 19465 50 75 3209 22 14 303 00 20300 5100 163.81 276538 149 100 18 114090 1150 149 129732 1151 Nancy Ford Rate Illus Unid Fung Wit Allowances tot w Ray Kramer $3,400.00 $3.500.00 semimonthly semimonthly M M 12/16/20 12118121 Jim Adams $20.00 $21.00 hourly hourly 12/18/20 12/16/21 WK Nancy Ford $17.00 hourly M 3 10/1/22 Hire date 14 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Ray Kramer Soc. Sec. No. ****** 2376 Home Address 417 Cherry, Chicago, 60912 Phone No. 781-3565 Employed 4/6/11 Date of Termination Date of Birth 2/15/1979 Occupation Manager Date EMPLOYEE EARNINGS SUBSIDIARY LEDGER FICA Hours Worked Period Regular Overtime Ending Paid Hours Hours 10-01-22 Balance Forward Gross Pay 6300000 Social Security 3/90600 Medicare 1913 50 Federal Income Tax 545 400 State Income Net Tax Pay 2 94.96 491 1484 10-15-2210- 14-22 1o-3 1-/2210-31-22 Cumulative Annual Total 350 000 350 000 7oooooo 21700 121700 434000 50 75 50 75 101 500 130 300 302 00 Ulololoo 163 87 1216538 163181 27 6538 327140 553 o 1.o 15075 350 000 350 000 7710 o oloo 11-05-22 01-05-22 11-30-2211-30 - 22 Cumulative Annual Total 217100 2. 17.00 4714100 50 15 il 150 30 300 30 300 161666.00 16387 217 65138 276538 slu 05 08 3.8136 27 65138 30 300 50 15 16381 21100 350 000 112-115-22 12-15-22