NEED HELP ASAP!

Complete the Payroll Register for the week of Oct 4-17 using the provided excel template?

All employees are paid on a biweekly basis and according to their W-4 are all married and do not request any additional withholding (Use the tables that start on page 11 of the Pub 15-T that is posted under the Chapter 12 Module). Each employee has requested that 5% of their pay is withheld for the retirement plan.

The employees with an hourly rate are the Sales reps and those earning a salary are the Office staff.

The merit rating for SUTA is 4.8%.

Prepare the necessary journal entries.

(provided excel template that is suppose to be filled out)

(tables of the Pub 15 document)

BTU - OA- 5. % Condo format De Port ZY Sort fore Anaye Det Soy K19 Name YTD Reg Hours Rate Salary Tamings OT Total Lamnings Earnings Sales Sal Office Sal Exp PUT Total FICA OASEN FRA Med Retirement Deduction Net Pey PICA-OASDE FICA-Med FUTA SUITA A 5,000.00 45 562.00 72.000 DO 1800 110.00 1658400 7.400.00 3. 415030 1 May 13,100.00 $10.00 2.000 125.170.00 100.00 56200 OS OS 08 0$ 0 0 0$ 0$ OS 0$ 0$ OS OS OS 03 os 01 0 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or Later BIWEEKLY Payroll Period the Adjusted Wage Married Filing Jointly Head of Household Amount this Single or Married Filing Separately FormW-4. Step 2 Form W-4, Step 2 FoW-4. Step 2 Standard Checkbox Standard Checkbox Standard Checkbox But loss withholding witholding withholding withholding withholding withholding At least Par The Tentative Withholding Amount $0 5240 50 5240 $250 $250 5250 $260 $270 $270 $o 5280 10 $0 $200 5200 30 $200 $300 SO $$ $300 50 50 3310 $6 $0 $310 5320 S7 $0 $320 $0 $350 $ $0 SO $ $9 $330 $340 SO $0 $340 $350 $40 $350 $300 $0 $13 $360 $0 $370 $12 3370 $380 513 $300 $390 $390 $400 SIS $400 $410 $16 $410 $420 $17 $420 5430 $18 50 $430 $445 1445 30 5460 18 520 $460 $475 $475 $11 5490 1490 $1 $12 $505 $2 $ $14 $505 5520 $ $520 15 $4 $29 3535 $535 $17 3550 $550 5565 $565 SSBO 38 310 521 510 $580 5596 $11 $595 38 3610 SO $13 $ 5610 5625 $13 $40 $0 $14 $20 5625 3640 50 $16 $14 3540 $16 $655 fo $17 $17 3655 5670 10 $19 5570 3605 347 10 320 SA 5685 $700 549 30 $22 5700 5715 $51 $23 $35 $715 5730 $25 $730 5745 526 3745 5760 528 542 $750 5775 $29 $444 5775 5790 331 500 $780 SOS 561 $47 350 S805 5820 $820 $34 $03 549 $34 $11 $35 $85 351 5835 $85 $35 557 $37 $13 5865 $27 $850 $30 14 569 554 5380 $30 $40 570 $ $40 3600 soos SO 562 $17 8895 5910 $74 $43 5910 5925 543 $70 $45 20 $925 1940 $47 $22 $940 3955 563 149 165 581 $955 5970 $1 551 $25 5985 $970 RO $2 $52 3905 $80 $1.000 54 $54 28 $1,000 554 S1015 $71 55 556 30 $1,015 S1035 $50 S7 $55 $31 $09 51,035 $1.055 $9 $61 $33 51,055 $1.075 sos $ $1.075 $83 $1.095 13 $70 $101 SES $82 $1.095 51.115 $65 $100 $15 TER $39 51,115 51.135 360 517 5110 STO $70 DES CS FC BES 9880 8888888888888888888888888888888888888888888888888888888 9988 332 3338 3398 89830888888888888888888888888888888888888888 28888 88888 2880 88028 Saana 58882383398533338939 SIEGE EGNE 888888888888888888888885038089 RE: ECD: 338 339 3385 23383 38388 155 995 95 098 625 195 115 Publication 15-T (2020) Page 11 5140 $104 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or Later DIWEEKLY Payroll Period of the Adjusted Wage Married Filing Jointly Amount net Head of Household Single or Married Filling Separately Form W-4, Sep 2 Standard Form W-4 Step 2 Form W-4. Step 2 Checkbox Standard withholding Checkbox Standard Checibox withholding withholding withholding At least wthholding withholding The Tentative witholding Amounts $1,135 $5,155 $19 573 $1,155 $1.175 $21 $43 sap 573 $75 $118 $1,175 591 $1,195 523 $45 $75 $123 51,195 577 $25 547 $1.215 504 577 540 $127 $1,215 $80 $1,235 596 $80 $132 361 $1.235 5.90 $1,255 $29 $135 $85 $50 $1,255 $1.275 331 3101 $85 $1,275 $87 $1.295 $33 S56 5103 $87 $145 $1,295 $1,318 $89 $35 $57 STOG 589 $149 $1,315 $1,335 $92 $50 $108 592 $154 594 $62 $1,335 5111 SIS 51.355 $39 S07 564 $1,355 $113 $97 $1.375 $41 31,375 $1.395 590 $67 $115 300 $43 $1,395 $167 5101 $45 $1,415 $60 $118 5101 $104 $171 $1,415 51.435 547 572 5122 $176 $106 574 $120 $1,435 $105 $180 51,455 549 5100 $26 5130 $1,455 $1,475 $100 $164 $1.475 551 5511 $1,495 $135 $79 $111 $113 $189 $1.495 $81 $139 $1,515 $55 $115 $193 $1,515 $116 $54 $144 $116 $190 $1.535 $57 $118 SA 514 $110 Se $1.535 $1.555 559 $121 $1.555 $88 $150 $1.575 561 $123 $121 $1.575 591 3157 $1,595 563 $123 1211 $125 $1,595 $90 $161 $1,615 ses $120 $125 $215 $1.615 $100 $1.635 500 $123 $220 $130 $.90 $170 $130 $224 $1,635 $1.655 560 $1,655 51.675 $130 $100 $174 $130 $220 $71 $100 51.675 $135 51.695 $179 $73 $135 5230 5137 $1,695 $105 51.715 $150 $137 5237 $75 $140 $100 51 715 51.735 $160 $180 977 5242 5142 $110 5205 51,735 $1.755 $80 $1,75 $145 $112 $195 51.775 $165 050 582 $147 $115 3201 $1.775 $1,795 $85 $149 $117 $205 $1,795 $1.815 587 $140 $152 $120 20 $264 $1.815 S1 $1.835 $154 $122 5214 5154 $200 $1,635 $1.655 $90 $124 $1.855 $94 $1.875 $157 5210 $150 $1,675 $127 $1,895 5223 $150 597 $161 $129 $277 5227 $180 $1,895 $1.925 $100 $164 $132 $230 $281 $164 51.925 $105 $267 $168 SI 12:39 $1,055 $1.985 3205 $107 $172 $130 Sau 51,085 $2.015 $110 $175 $143 $302 $2.015 $2.045 $114 $180 $147 SO $309 $2.045 $2.075 SITO $188 $150 $180 $310 $267 $2.075 $2,105 5121 $190 $150 $274 $154 5323 $123 $231 $2,105 52,135 $125 $200 5157 52,135 $2,165 $281 $200 $206 $161 $2,195 52,165 $200 5132 $288 1945 52,195 5215 5165 $25 $213 $2.225 $130 $52 $219 $168 52.255 $309 210 52 225 $130 $172 $310 $2.255 $2.285 $143 $230 $175 $317 $233 $2.315 $374 52.265 $160 $230 5170 $324 $2315 $2.345 $150 $230 $381 246 52.345 $180 32 52.375 538 3154 $245 325 5100 $339 1395 32.375 $252 $2405 $157 $190 $250 5403 52.405 32.435 $161 $206 $190 52.435 $2165 5363 $164 5200 $410 $272 $197 $300 52,465 52.495 $160 $273 $417 3279 5.201 Si 3274 52,525 $572 5285 $424 $204 12.525 32.555 $375 5205 $175 5431 $200 5430 52.555 $2.585 $170 $290 $211 tas $299 52.565 52.615 $182 52.615 $305 $300 $2.645 5215 $305 5453 5156 $219 $312 201 $2.545 5312 1460 $190 52.675 5318 $453 318 $467 52.575 $2.705 5193 $325 $220 1075 $157 $272 5175 $123 S2ANS Page 12 Publication 15-T (2020) $338 $378 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or later BIWEEKLY Payroll Period If the Adjusted Wage Married Filling Jointly Amount (line Head of Household Single or Married Filing Separately FormW-4, Sep 2 For W-4 Sep 2 Form W-4 SA 2 Standard Checkbox Standard Checko Standard Checkbox But loss withholding witholding withholding withholding withholding withholding At least than The Tentative Wholding Amount $2,705 $2,735 $197 $332 $225 $2.735 52.765 $200 3425 $32 $233 5432 $2,765 $398 $2,795 See 5200 $345 5237 $440 $345 $2.795 $2,825 5208 $351 $243 5494 $447 $351 52.825 52,855 $350 S250 $454 3511 $2,855 52.885 5215 3365 5256 3481 $355 SSTE 52.885 $2,915 5218 $371 $263 $2,915 $468 5371 $2.945 5222 $250 $525 $2,945 5476 $2,975 5220 Sara 5532 $384 $276 5483 $354 $2.975 $530 $3,005 5220 $991 5283 5490 $391 5567 $3,005 $3,035 5230 $398 $289 5497 $390 $3.035 $3,065 5236 $404 $290 $504 $3,065 $3,095 $404 $411 5300 5561 $512 $611 $3,095 $3,125 $244 $417 S309 $566 $3,125 $3,155 5519 $417 5575 $247 $424 $316 $3,155 5580 $3,18 $251 $431 5322 5533 $3,185 $3,215 $431 5500 S254 $437 $3.215 3.300 5540 SEY $3,245 5258 5507 $444 $335 $3,245 $3,275 5548 $262 $450 $504 $3.275 5342 $3,305 5555 $450 $265 S613 $457 $349 $45 $619 $3,305 $3,335 $200 $454 S355 $3,365 $500 $464 5272 3626 $470 $362 $3.365 5576 $3,395 $470 5278 $477 8358 $3395 5584 $3,435 $477 S280 S64 5640 $376 $3.435 $3,475 5582 5454 S651 $40 5654 $8.475 $3.515 5290 55ce $394 $3.515 5611 $3,555 $295 $502 $511 $3.555 5677 5403 $3,595 9624 5299 5511 $2.595 5411 $520 $3,635 $636 SEO 5520 $304 Se $420 $700 $3.635 $3.675 5649 3300 5837 $528 $429 STIS 5862 $530 $3.875 ST28 $3.715 S014 5546 $438 $3,715 $3.755 3319 $575 $545 3741 5555 $447 $2.755 $3.795 $323 SSBB SSSS 5584 3754 5455 $700 $3.795 53.835 1573 3-14 $564 $70 S3835 53,875 S713 5573 5333 $583 $473 ST78 $720 3583 5792 $200 $3,335 5633 Au Publication 15-T (2020) Page 13 BTU - OA- 5. % Condo format De Port ZY Sort fore Anaye Det Soy K19 Name YTD Reg Hours Rate Salary Tamings OT Total Lamnings Earnings Sales Sal Office Sal Exp PUT Total FICA OASEN FRA Med Retirement Deduction Net Pey PICA-OASDE FICA-Med FUTA SUITA A 5,000.00 45 562.00 72.000 DO 1800 110.00 1658400 7.400.00 3. 415030 1 May 13,100.00 $10.00 2.000 125.170.00 100.00 56200 OS OS 08 0$ 0 0 0$ 0$ OS 0$ 0$ OS OS OS 03 os 01 0 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or Later BIWEEKLY Payroll Period the Adjusted Wage Married Filing Jointly Head of Household Amount this Single or Married Filing Separately FormW-4. Step 2 Form W-4, Step 2 FoW-4. Step 2 Standard Checkbox Standard Checkbox Standard Checkbox But loss withholding witholding withholding withholding withholding withholding At least Par The Tentative Withholding Amount $0 5240 50 5240 $250 $250 5250 $260 $270 $270 $o 5280 10 $0 $200 5200 30 $200 $300 SO $$ $300 50 50 3310 $6 $0 $310 5320 S7 $0 $320 $0 $350 $ $0 SO $ $9 $330 $340 SO $0 $340 $350 $40 $350 $300 $0 $13 $360 $0 $370 $12 3370 $380 513 $300 $390 $390 $400 SIS $400 $410 $16 $410 $420 $17 $420 5430 $18 50 $430 $445 1445 30 5460 18 520 $460 $475 $475 $11 5490 1490 $1 $12 $505 $2 $ $14 $505 5520 $ $520 15 $4 $29 3535 $535 $17 3550 $550 5565 $565 SSBO 38 310 521 510 $580 5596 $11 $595 38 3610 SO $13 $ 5610 5625 $13 $40 $0 $14 $20 5625 3640 50 $16 $14 3540 $16 $655 fo $17 $17 3655 5670 10 $19 5570 3605 347 10 320 SA 5685 $700 549 30 $22 5700 5715 $51 $23 $35 $715 5730 $25 $730 5745 526 3745 5760 528 542 $750 5775 $29 $444 5775 5790 331 500 $780 SOS 561 $47 350 S805 5820 $820 $34 $03 549 $34 $11 $35 $85 351 5835 $85 $35 557 $37 $13 5865 $27 $850 $30 14 569 554 5380 $30 $40 570 $ $40 3600 soos SO 562 $17 8895 5910 $74 $43 5910 5925 543 $70 $45 20 $925 1940 $47 $22 $940 3955 563 149 165 581 $955 5970 $1 551 $25 5985 $970 RO $2 $52 3905 $80 $1.000 54 $54 28 $1,000 554 S1015 $71 55 556 30 $1,015 S1035 $50 S7 $55 $31 $09 51,035 $1.055 $9 $61 $33 51,055 $1.075 sos $ $1.075 $83 $1.095 13 $70 $101 SES $82 $1.095 51.115 $65 $100 $15 TER $39 51,115 51.135 360 517 5110 STO $70 DES CS FC BES 9880 8888888888888888888888888888888888888888888888888888888 9988 332 3338 3398 89830888888888888888888888888888888888888888 28888 88888 2880 88028 Saana 58882383398533338939 SIEGE EGNE 888888888888888888888885038089 RE: ECD: 338 339 3385 23383 38388 155 995 95 098 625 195 115 Publication 15-T (2020) Page 11 5140 $104 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or Later DIWEEKLY Payroll Period of the Adjusted Wage Married Filing Jointly Amount net Head of Household Single or Married Filling Separately Form W-4, Sep 2 Standard Form W-4 Step 2 Form W-4. Step 2 Checkbox Standard withholding Checkbox Standard Checibox withholding withholding withholding At least wthholding withholding The Tentative witholding Amounts $1,135 $5,155 $19 573 $1,155 $1.175 $21 $43 sap 573 $75 $118 $1,175 591 $1,195 523 $45 $75 $123 51,195 577 $25 547 $1.215 504 577 540 $127 $1,215 $80 $1,235 596 $80 $132 361 $1.235 5.90 $1,255 $29 $135 $85 $50 $1,255 $1.275 331 3101 $85 $1,275 $87 $1.295 $33 S56 5103 $87 $145 $1,295 $1,318 $89 $35 $57 STOG 589 $149 $1,315 $1,335 $92 $50 $108 592 $154 594 $62 $1,335 5111 SIS 51.355 $39 S07 564 $1,355 $113 $97 $1.375 $41 31,375 $1.395 590 $67 $115 300 $43 $1,395 $167 5101 $45 $1,415 $60 $118 5101 $104 $171 $1,415 51.435 547 572 5122 $176 $106 574 $120 $1,435 $105 $180 51,455 549 5100 $26 5130 $1,455 $1,475 $100 $164 $1.475 551 5511 $1,495 $135 $79 $111 $113 $189 $1.495 $81 $139 $1,515 $55 $115 $193 $1,515 $116 $54 $144 $116 $190 $1.535 $57 $118 SA 514 $110 Se $1.535 $1.555 559 $121 $1.555 $88 $150 $1.575 561 $123 $121 $1.575 591 3157 $1,595 563 $123 1211 $125 $1,595 $90 $161 $1,615 ses $120 $125 $215 $1.615 $100 $1.635 500 $123 $220 $130 $.90 $170 $130 $224 $1,635 $1.655 560 $1,655 51.675 $130 $100 $174 $130 $220 $71 $100 51.675 $135 51.695 $179 $73 $135 5230 5137 $1,695 $105 51.715 $150 $137 5237 $75 $140 $100 51 715 51.735 $160 $180 977 5242 5142 $110 5205 51,735 $1.755 $80 $1,75 $145 $112 $195 51.775 $165 050 582 $147 $115 3201 $1.775 $1,795 $85 $149 $117 $205 $1,795 $1.815 587 $140 $152 $120 20 $264 $1.815 S1 $1.835 $154 $122 5214 5154 $200 $1,635 $1.655 $90 $124 $1.855 $94 $1.875 $157 5210 $150 $1,675 $127 $1,895 5223 $150 597 $161 $129 $277 5227 $180 $1,895 $1.925 $100 $164 $132 $230 $281 $164 51.925 $105 $267 $168 SI 12:39 $1,055 $1.985 3205 $107 $172 $130 Sau 51,085 $2.015 $110 $175 $143 $302 $2.015 $2.045 $114 $180 $147 SO $309 $2.045 $2.075 SITO $188 $150 $180 $310 $267 $2.075 $2,105 5121 $190 $150 $274 $154 5323 $123 $231 $2,105 52,135 $125 $200 5157 52,135 $2,165 $281 $200 $206 $161 $2,195 52,165 $200 5132 $288 1945 52,195 5215 5165 $25 $213 $2.225 $130 $52 $219 $168 52.255 $309 210 52 225 $130 $172 $310 $2.255 $2.285 $143 $230 $175 $317 $233 $2.315 $374 52.265 $160 $230 5170 $324 $2315 $2.345 $150 $230 $381 246 52.345 $180 32 52.375 538 3154 $245 325 5100 $339 1395 32.375 $252 $2405 $157 $190 $250 5403 52.405 32.435 $161 $206 $190 52.435 $2165 5363 $164 5200 $410 $272 $197 $300 52,465 52.495 $160 $273 $417 3279 5.201 Si 3274 52,525 $572 5285 $424 $204 12.525 32.555 $375 5205 $175 5431 $200 5430 52.555 $2.585 $170 $290 $211 tas $299 52.565 52.615 $182 52.615 $305 $300 $2.645 5215 $305 5453 5156 $219 $312 201 $2.545 5312 1460 $190 52.675 5318 $453 318 $467 52.575 $2.705 5193 $325 $220 1075 $157 $272 5175 $123 S2ANS Page 12 Publication 15-T (2020) $338 $378 2020 Wage Bracket Method Tables for Manual Payroll Systems With Forms W-4 From 2020 or later BIWEEKLY Payroll Period If the Adjusted Wage Married Filling Jointly Amount (line Head of Household Single or Married Filing Separately FormW-4, Sep 2 For W-4 Sep 2 Form W-4 SA 2 Standard Checkbox Standard Checko Standard Checkbox But loss withholding witholding withholding withholding withholding withholding At least than The Tentative Wholding Amount $2,705 $2,735 $197 $332 $225 $2.735 52.765 $200 3425 $32 $233 5432 $2,765 $398 $2,795 See 5200 $345 5237 $440 $345 $2.795 $2,825 5208 $351 $243 5494 $447 $351 52.825 52,855 $350 S250 $454 3511 $2,855 52.885 5215 3365 5256 3481 $355 SSTE 52.885 $2,915 5218 $371 $263 $2,915 $468 5371 $2.945 5222 $250 $525 $2,945 5476 $2,975 5220 Sara 5532 $384 $276 5483 $354 $2.975 $530 $3,005 5220 $991 5283 5490 $391 5567 $3,005 $3,035 5230 $398 $289 5497 $390 $3.035 $3,065 5236 $404 $290 $504 $3,065 $3,095 $404 $411 5300 5561 $512 $611 $3,095 $3,125 $244 $417 S309 $566 $3,125 $3,155 5519 $417 5575 $247 $424 $316 $3,155 5580 $3,18 $251 $431 5322 5533 $3,185 $3,215 $431 5500 S254 $437 $3.215 3.300 5540 SEY $3,245 5258 5507 $444 $335 $3,245 $3,275 5548 $262 $450 $504 $3.275 5342 $3,305 5555 $450 $265 S613 $457 $349 $45 $619 $3,305 $3,335 $200 $454 S355 $3,365 $500 $464 5272 3626 $470 $362 $3.365 5576 $3,395 $470 5278 $477 8358 $3395 5584 $3,435 $477 S280 S64 5640 $376 $3.435 $3,475 5582 5454 S651 $40 5654 $8.475 $3.515 5290 55ce $394 $3.515 5611 $3,555 $295 $502 $511 $3.555 5677 5403 $3,595 9624 5299 5511 $2.595 5411 $520 $3,635 $636 SEO 5520 $304 Se $420 $700 $3.635 $3.675 5649 3300 5837 $528 $429 STIS 5862 $530 $3.875 ST28 $3.715 S014 5546 $438 $3,715 $3.755 3319 $575 $545 3741 5555 $447 $2.755 $3.795 $323 SSBB SSSS 5584 3754 5455 $700 $3.795 53.835 1573 3-14 $564 $70 S3835 53,875 S713 5573 5333 $583 $473 ST78 $720 3583 5792 $200 $3,335 5633 Au Publication 15-T (2020) Page 13