please please please! work on this assignment as fast as possible! I have 76 hours to get this assignment turned in! please again help me get this assignment complete by Friday!

thanks

Pdx Inc. is paying payroll for their employees on monthly basis. They're also on a Monthly Depositer plan for taxes. *The Social Security (OASDI) rate is 6.2% with a wage-base maximum of $127,200. The Medicare rate is 1.45% on all earnings "The FUTA tax rate is 0.8% for the first $7,000 of wages. *The SUTA tax rate is 5.7% for the first $7,000 of wages. BLUE REQUIREMENTS: (Use color for all answers you fill out in all tabs in this excel file) 1- Fill up the tables in the "Wages & Taxes" tab. (That's in the 2nd tob here in this file). 24 points on this requirement. 2- Fill up the "Payroll Register for DECEMBER". (3rd tab). 15 points on this requirement. (Note: You will get EXTRA CREDIT if you do Payroll Register for October, November as well). (6th & 7th tabs). 3- Record the following "Journal Entries" for the month of OCTOBER NOVEMBER,& DECEMBER (4th tab), 50 points on this (Note: Look for my hints on the journal entries in the "Orientation about COMP ASSIGNMENT" file. a-ACCRUAL of payroll at the due dates. (Also called "journalise the Payroll Register in the book b-ACCRUAL of all taxes by the end of the period. C-PAYMENT of payroll on the 3rd day of the following month after accrual. d- PAYMENT of taxes by the 15th day of the following month after accrual. 4- Complete form 941 (a separate file uploaded as a PDF in D2L). 11 points on this requirement 10 Wage Bracket Method Tables for Income Tax Withholding SINGLE PersonsMONTHLY Payroll Period (For Wages Paid through December 31, 2017) And the wages are- And the number of withholding allowances claimed is At least But less 0 1 2 3 4 5 7 19 than The amount of income tax to be withheld is $2,400 $2,440 $295 $245 $194 $144 $93 $54 $20 $ 2,440 2,480 301 251 200 150 99 58 24 2,480 2,520 307 257 206 156 105 62 28 2,520 2,560 313 263 212 162 111 66 32 2,560 2,600 319 218 168 117 70 36 2,600 2,640 325 275 224 174 123 74 40 2,640 2.680 281 230 180 129 78 44 2.680 2,720 337 287 236 186 135 Bl 48 2,720 2,760 343 293 242 192 141 90 52 2,760 2,800 349 299 248 198 147 96 56 2,800 2,840 355 254 204 153 102 60 2,840 2.880 361 311 260 210 - 159 108 64 2,880 2,920 317 266 216 165 114 68 2,920 2,960 373 323 272 222 171 120 72 2,960 379 3,000 329 278 228 177 126 76 3,000 3,040 385 335 284 234 183 132 82 269 331 30009 THww but uooooooooooood oo seogo goooooooooo 305 367 899 3,040 3.080 3.120 3,160 3.200 3,240 3,280 3,320 3.360 3.400 3,440 3.480 3,520 3,560 3,600 3640 3,680 3.720 3,760 3.800 3.840 10 3.920 3.960 4.000 4,040 4,080 4.120 4,160 3,080 3,120 3,160 3,200 3,240 3.280 3,320 3,360 3,400 3,440 3.480 3,520 3,560 3,500 3,640 3.680 3.720 3.760 3.800 3,840 100 3,920 3.960 4000 4,040 4,080 4,120 4,160 4,200 ES 3 3 885 83x %$& P" S32 >8 tooooo 29Bee -ooooooooooooo | 558 40 262 268 4,200 4,240 4,280 4,320 4,360 4.400 4,440 4.480 4.520 4,560 4,600 274 568 578 ge 598 600 518 620 662 672 062 692 702 712 722 732 742 838 4,240 4.280 4,320 4.360 4,400 4,440 4,400 4,520 4.560 4,600 4,640 4.680 4.720 4,760 4,800 4840 4,080 4,020 4,960 5.000 5,040 5.080 414 420 426 432 439 449 459 489 479 489 400 509 519 529 530 483 493 503 513 523 533 543 553 569 578 580 593 603 613 623 033 843 653 663 673 383 693 648 088 688 678 688 690 708 4,6-40 312 318 324 330 336 342 348 354 350 306 372 378 394 390 396 400 383 369 375 381 387 393 399 405 411 417 423 429 435 444 454 484 474 484 4944 504 514 524 782 772 782 792 B02 812 822 110 115 122 128 134 140 145 952 158 164 170 178 182 188 194 200 200 212 280 286 292 298 304 310 316 322 328 334 340 346 352 358 364 370 376 382 388 211 217 223 229 235 241 247 253 250 265 271 277 283 289 295 301 307 313 319 325 331 337 160 106 172 170 184 190 196 202 209 214 220 226 232 238 244 250 256 262 200 274 280 286 59 73 77 83 89 95 101 107 113 119 125 131 137 4,630 4,720 4,750 4.800 4,840 4,880 4,920 4,960 5,000 5,0401 BRT gu%9 710 540 408 149 32 155 542 32 802 728 730 748 758 768 770 550 569 579 009 509 600 414 420 420 432 440 210 101 107 2214 230 236 $5,000 and over 170 185 Une Table 4) for a SINGLE person on page 45. Also on the instructions on page 3 Pannen 9 10 $ Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-MONTHLY Payroll Period (For Wagos Paid through December 31, 2017) And the wages are And the number of withholding allowances claimed is At least But less 0 1 2 3 4 5 6 7 8 than The amount of income tax to be withheld is $0 $720 $ SO $0 720 760 750 800 800 840 10 840 880 800 920 18 920 950 22 960 1,000 1,000 1,040 1,040 1,000 1,080 1,120 1,120 1,160 1,160 1.200 1,200 1,240 1,240 1,280 20 1.280 1,320 1,320 1,350 1,360 1,400 1,400 1,440 70 1,440 1.480 40 %% #88888 88888 Naso ang 88 882 DOO OOOOO 008 ON OOOOOOOOOOOOOOOOO8 OOOOOOOOOOOOOOOOOOO SOO OOOOO OOOOO OOOOO OO COOOOOOOOOOOOOOOOOO ooOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOO DOS OOOOOOOOOOOOOOOOO COS OOOOOOOOOOOOOOOOO DOS SOOOOOOOOOOOOOOOOOOO 1,520 1.560 1,500 1,640 1.6.0 1.720 1,760 1.800 1. 1.520 1,560 1.600 1.640 1.680 1,720 1,760 1.800 1840 1.880 1.920 1,960 2.000 2,040 2,080 2.120 2,160 2,200 2.240 2.280 2,320 2,360 2.400 2,440 2.480 1,840 1.880 1,920 1,960 2,000 2.040 2,080 2,120 2,160 2,200 88888 88 99 epoo ooooo oooooooooooooooooo 2,520 2.560 2,560 2,600 2,600 2,640 2,680 2,720 2,760 2,800 2,840 2,880 2,920 2,960 3,000 3,040 3,080 3,120 3,160 3,200 3,240 3,280 3,320 3,360 2,640 2,680 2,720 2,760 2,800 2,840 2,880 2.920 2,960 3,000 3,040 3,080 3,120 3,160 3,200 3,240 3,280 88 888 8888 9888 88 89 90 6 988 89 88 Nat Gewoo ooooo ooooo 145 3,320 3,360 3,400 169 10 59 50 Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-MONTHLY Payroll Period (For Wages Paid through December 31, 2017) And the wages are And the number of withholding wlowances claimed in Al last But less 0 1 than 2 3 4 5 7 8 The amount of income tax to be withheld $3,400 $3,440 $327 $277 S226 3,440 3,480 $175 $135 333 $101 $67 $34 283 232 3,480 3.520 181 330 130 105 71 289 238 38 3,520 3,560 187 143 109 345 75 42 B 295 244 3,560 3,600 193 351 147 113 79 12 301 250 199 151 117 83 50 16 3,600 3,640 357 307 256 205 155 3.600 121 3,640 87 303 313 54 20 262 211 125 3,680 161 91 3,720 58 369 319 268 217 167 129 95 3,720 3,760 62 375 325 274 3,760 223 173 133 99 3,800 56 381 331 280 229 179 132 103 70 36 3,000 3,840 387 337 286 235 185 141 3,800 107 74 3,840 40 393 343 292 241 195 145 111 3.880 78 3,920 349 390 296 247 197 149 115 3,920 405 3,960 82 355 304 253 203 153 30 119 52 3,960 4,000 411 361 259 209 158 123 58 4,000 4,040 310 265 215 164 94 00 4,040 4,080 423 373 322 271 221 170 131 98 84 4,080 4,120 429 379 328 277 227 176 135 102 88 4,120 4,160 435 385 334 283 233 182 139 106 4,160 4,200 441 391 340 289 239 188 143 110 70 , w 42 ROOOO OOOOO 9.8888888 SODOO OOOOOOOOOOOOO 310 22 417 367 30 447 Lunch Meeting - Zoom 295 -301 - 307 346 352 358 364 370 376 382 40 54 58 02 269 92 16 20 24 28 114 118 122 120 130 136 138 142 146 150 154 159 388 32 36 254 4A 52 165 4,200 4,240 4,280 4.320 4,360 4,400 4,440 4,480 4,520 4,560 4,600 4,640 4,680 4,720 4,760 4,800 4,840 4,880 4,920 4,960 5,000 5,040 5,080 5,120 5,160 5,200 5,240 5,280 5,320 5,360 94 4.240 4,280 4,320 4,360 4,400 4,440 4,480 4,520 4,560 4,600 4,640 4,680 4,720 4,760 4,800 4,840 4,880 4,920 4.960 5,000 5,040 5,080 5,120 5,160 5,200 5,240 5,280 5,320 5,360 5,400 453 459 465 471 477 483 489 495 501 507 513 519 525 531 537 543 549 555 561 567 573 579 585 591 597 603 397 403 409 415 421 427 433 419 445 451 457 463 469 475 481 487 493 499 505 511 517 523 529 535 541 547 553 559 565 571 313 319 325 331 337 343 349 355 361 367 373 379 385 391 397 403 409 415 421 427 10 - Intro 245 194 251 200 257 205 263 212 218 275 224 281 230 287 236 293 242 299 248 305 311 280 317 266 323 272 329 278 335 284 341 290 347 296 353 302 359 308 365 314 371 320 377 383 332 389 338 395 344 401 350 407 356 413 362 419 JEL 171 177 394 400 408 412 418 424 430 436 442 448 454 460 466 472 478 490 496 502 508 514 520 147 151 155 161 167 173 17 185 191 197 203 209 215 221 227 233 239 245 251 257 263 269 275 281 287 293 299 305 311 317 183 100 104 10 112 116 120 124 128 132 136 140 144 148 152 156 162 158 174 180 186 www 102 106 110 114 118 122 60 54 72 75 10 %%Ywwg HE% 92 126 326 433 189 195 201 207 213 219 225 231 237 243 240 256 251 287 100 TOS 192 439 445 451 457 463 469 130 134 138 142 1 150 154 150 165 615 621 198 204 210 216 112 116 120 124 128 TO 577 532 222 595 475 481 437 493 499 505 511 773 270 285 291 207 300 172 179 184 190 196 209 200 214 300 517 5,400 5,440 5,480 5,520 5,560 5,600 5,640 5.650 5,720 5,760 5,800 5,840 5,800 5,920 5.960 6,000 6,040 6,080 425 431 437 443 449 455 461 467 473 479 485 491 315 5.440 5,400 5,520 5,560 5,600 5,640 5,600 5,720 5.760 5,800 5,840 5,880 5.920 5,960 6,000 6,040 6,080 6,120 527 6:13 639 645 651 657 863 669 675 681 687 093 690 705 711 717 723 729 601 607 613 619 625 631 637 643 649 655 661 067 544 550 556 562 568 574 580 586 592 598 604 610 610 822 628 523 529 535 541 547 553 559 565 571 577 374 380 380 392 398 404 410 416 422 428 434 440 446 452 459 484 470 476 323 329 333 341 347 353 350 365 371 377 383 389 395 401 407 413 419 425 228 234 240 246 252 250 254 270 278 252 28 294 300 306 312 327 333 330 345 351 357 363 300 375 226 20 2010 244 250 112 136 140 144 TA 152 157 169 100 175 181 187 103 199 205 211 217 223 497 503 500 515 521 527 673 318 20 679 324 274 Pdx Inc. is paying payroll for their employees on monthly basis. They're also on a Monthly Depositer plan for taxes. *The Social Security (OASDI) rate is 6.2% with a wage-base maximum of $127,200. The Medicare rate is 1.45% on all earnings "The FUTA tax rate is 0.8% for the first $7,000 of wages. *The SUTA tax rate is 5.7% for the first $7,000 of wages. BLUE REQUIREMENTS: (Use color for all answers you fill out in all tabs in this excel file) 1- Fill up the tables in the "Wages & Taxes" tab. (That's in the 2nd tob here in this file). 24 points on this requirement. 2- Fill up the "Payroll Register for DECEMBER". (3rd tab). 15 points on this requirement. (Note: You will get EXTRA CREDIT if you do Payroll Register for October, November as well). (6th & 7th tabs). 3- Record the following "Journal Entries" for the month of OCTOBER NOVEMBER,& DECEMBER (4th tab), 50 points on this (Note: Look for my hints on the journal entries in the "Orientation about COMP ASSIGNMENT" file. a-ACCRUAL of payroll at the due dates. (Also called "journalise the Payroll Register in the book b-ACCRUAL of all taxes by the end of the period. C-PAYMENT of payroll on the 3rd day of the following month after accrual. d- PAYMENT of taxes by the 15th day of the following month after accrual. 4- Complete form 941 (a separate file uploaded as a PDF in D2L). 11 points on this requirement 10 Wage Bracket Method Tables for Income Tax Withholding SINGLE PersonsMONTHLY Payroll Period (For Wages Paid through December 31, 2017) And the wages are- And the number of withholding allowances claimed is At least But less 0 1 2 3 4 5 7 19 than The amount of income tax to be withheld is $2,400 $2,440 $295 $245 $194 $144 $93 $54 $20 $ 2,440 2,480 301 251 200 150 99 58 24 2,480 2,520 307 257 206 156 105 62 28 2,520 2,560 313 263 212 162 111 66 32 2,560 2,600 319 218 168 117 70 36 2,600 2,640 325 275 224 174 123 74 40 2,640 2.680 281 230 180 129 78 44 2.680 2,720 337 287 236 186 135 Bl 48 2,720 2,760 343 293 242 192 141 90 52 2,760 2,800 349 299 248 198 147 96 56 2,800 2,840 355 254 204 153 102 60 2,840 2.880 361 311 260 210 - 159 108 64 2,880 2,920 317 266 216 165 114 68 2,920 2,960 373 323 272 222 171 120 72 2,960 379 3,000 329 278 228 177 126 76 3,000 3,040 385 335 284 234 183 132 82 269 331 30009 THww but uooooooooooood oo seogo goooooooooo 305 367 899 3,040 3.080 3.120 3,160 3.200 3,240 3,280 3,320 3.360 3.400 3,440 3.480 3,520 3,560 3,600 3640 3,680 3.720 3,760 3.800 3.840 10 3.920 3.960 4.000 4,040 4,080 4.120 4,160 3,080 3,120 3,160 3,200 3,240 3.280 3,320 3,360 3,400 3,440 3.480 3,520 3,560 3,500 3,640 3.680 3.720 3.760 3.800 3,840 100 3,920 3.960 4000 4,040 4,080 4,120 4,160 4,200 ES 3 3 885 83x %$& P" S32 >8 tooooo 29Bee -ooooooooooooo | 558 40 262 268 4,200 4,240 4,280 4,320 4,360 4.400 4,440 4.480 4.520 4,560 4,600 274 568 578 ge 598 600 518 620 662 672 062 692 702 712 722 732 742 838 4,240 4.280 4,320 4.360 4,400 4,440 4,400 4,520 4.560 4,600 4,640 4.680 4.720 4,760 4,800 4840 4,080 4,020 4,960 5.000 5,040 5.080 414 420 426 432 439 449 459 489 479 489 400 509 519 529 530 483 493 503 513 523 533 543 553 569 578 580 593 603 613 623 033 843 653 663 673 383 693 648 088 688 678 688 690 708 4,6-40 312 318 324 330 336 342 348 354 350 306 372 378 394 390 396 400 383 369 375 381 387 393 399 405 411 417 423 429 435 444 454 484 474 484 4944 504 514 524 782 772 782 792 B02 812 822 110 115 122 128 134 140 145 952 158 164 170 178 182 188 194 200 200 212 280 286 292 298 304 310 316 322 328 334 340 346 352 358 364 370 376 382 388 211 217 223 229 235 241 247 253 250 265 271 277 283 289 295 301 307 313 319 325 331 337 160 106 172 170 184 190 196 202 209 214 220 226 232 238 244 250 256 262 200 274 280 286 59 73 77 83 89 95 101 107 113 119 125 131 137 4,630 4,720 4,750 4.800 4,840 4,880 4,920 4,960 5,000 5,0401 BRT gu%9 710 540 408 149 32 155 542 32 802 728 730 748 758 768 770 550 569 579 009 509 600 414 420 420 432 440 210 101 107 2214 230 236 $5,000 and over 170 185 Une Table 4) for a SINGLE person on page 45. Also on the instructions on page 3 Pannen 9 10 $ Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-MONTHLY Payroll Period (For Wagos Paid through December 31, 2017) And the wages are And the number of withholding allowances claimed is At least But less 0 1 2 3 4 5 6 7 8 than The amount of income tax to be withheld is $0 $720 $ SO $0 720 760 750 800 800 840 10 840 880 800 920 18 920 950 22 960 1,000 1,000 1,040 1,040 1,000 1,080 1,120 1,120 1,160 1,160 1.200 1,200 1,240 1,240 1,280 20 1.280 1,320 1,320 1,350 1,360 1,400 1,400 1,440 70 1,440 1.480 40 %% #88888 88888 Naso ang 88 882 DOO OOOOO 008 ON OOOOOOOOOOOOOOOOO8 OOOOOOOOOOOOOOOOOOO SOO OOOOO OOOOO OOOOO OO COOOOOOOOOOOOOOOOOO ooOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOO DOS OOOOOOOOOOOOOOOOO COS OOOOOOOOOOOOOOOOO DOS SOOOOOOOOOOOOOOOOOOO 1,520 1.560 1,500 1,640 1.6.0 1.720 1,760 1.800 1. 1.520 1,560 1.600 1.640 1.680 1,720 1,760 1.800 1840 1.880 1.920 1,960 2.000 2,040 2,080 2.120 2,160 2,200 2.240 2.280 2,320 2,360 2.400 2,440 2.480 1,840 1.880 1,920 1,960 2,000 2.040 2,080 2,120 2,160 2,200 88888 88 99 epoo ooooo oooooooooooooooooo 2,520 2.560 2,560 2,600 2,600 2,640 2,680 2,720 2,760 2,800 2,840 2,880 2,920 2,960 3,000 3,040 3,080 3,120 3,160 3,200 3,240 3,280 3,320 3,360 2,640 2,680 2,720 2,760 2,800 2,840 2,880 2.920 2,960 3,000 3,040 3,080 3,120 3,160 3,200 3,240 3,280 88 888 8888 9888 88 89 90 6 988 89 88 Nat Gewoo ooooo ooooo 145 3,320 3,360 3,400 169 10 59 50 Wage Bracket Method Tables for Income Tax Withholding MARRIED Persons-MONTHLY Payroll Period (For Wages Paid through December 31, 2017) And the wages are And the number of withholding wlowances claimed in Al last But less 0 1 than 2 3 4 5 7 8 The amount of income tax to be withheld $3,400 $3,440 $327 $277 S226 3,440 3,480 $175 $135 333 $101 $67 $34 283 232 3,480 3.520 181 330 130 105 71 289 238 38 3,520 3,560 187 143 109 345 75 42 B 295 244 3,560 3,600 193 351 147 113 79 12 301 250 199 151 117 83 50 16 3,600 3,640 357 307 256 205 155 3.600 121 3,640 87 303 313 54 20 262 211 125 3,680 161 91 3,720 58 369 319 268 217 167 129 95 3,720 3,760 62 375 325 274 3,760 223 173 133 99 3,800 56 381 331 280 229 179 132 103 70 36 3,000 3,840 387 337 286 235 185 141 3,800 107 74 3,840 40 393 343 292 241 195 145 111 3.880 78 3,920 349 390 296 247 197 149 115 3,920 405 3,960 82 355 304 253 203 153 30 119 52 3,960 4,000 411 361 259 209 158 123 58 4,000 4,040 310 265 215 164 94 00 4,040 4,080 423 373 322 271 221 170 131 98 84 4,080 4,120 429 379 328 277 227 176 135 102 88 4,120 4,160 435 385 334 283 233 182 139 106 4,160 4,200 441 391 340 289 239 188 143 110 70 , w 42 ROOOO OOOOO 9.8888888 SODOO OOOOOOOOOOOOO 310 22 417 367 30 447 Lunch Meeting - Zoom 295 -301 - 307 346 352 358 364 370 376 382 40 54 58 02 269 92 16 20 24 28 114 118 122 120 130 136 138 142 146 150 154 159 388 32 36 254 4A 52 165 4,200 4,240 4,280 4.320 4,360 4,400 4,440 4,480 4,520 4,560 4,600 4,640 4,680 4,720 4,760 4,800 4,840 4,880 4,920 4,960 5,000 5,040 5,080 5,120 5,160 5,200 5,240 5,280 5,320 5,360 94 4.240 4,280 4,320 4,360 4,400 4,440 4,480 4,520 4,560 4,600 4,640 4,680 4,720 4,760 4,800 4,840 4,880 4,920 4.960 5,000 5,040 5,080 5,120 5,160 5,200 5,240 5,280 5,320 5,360 5,400 453 459 465 471 477 483 489 495 501 507 513 519 525 531 537 543 549 555 561 567 573 579 585 591 597 603 397 403 409 415 421 427 433 419 445 451 457 463 469 475 481 487 493 499 505 511 517 523 529 535 541 547 553 559 565 571 313 319 325 331 337 343 349 355 361 367 373 379 385 391 397 403 409 415 421 427 10 - Intro 245 194 251 200 257 205 263 212 218 275 224 281 230 287 236 293 242 299 248 305 311 280 317 266 323 272 329 278 335 284 341 290 347 296 353 302 359 308 365 314 371 320 377 383 332 389 338 395 344 401 350 407 356 413 362 419 JEL 171 177 394 400 408 412 418 424 430 436 442 448 454 460 466 472 478 490 496 502 508 514 520 147 151 155 161 167 173 17 185 191 197 203 209 215 221 227 233 239 245 251 257 263 269 275 281 287 293 299 305 311 317 183 100 104 10 112 116 120 124 128 132 136 140 144 148 152 156 162 158 174 180 186 www 102 106 110 114 118 122 60 54 72 75 10 %%Ywwg HE% 92 126 326 433 189 195 201 207 213 219 225 231 237 243 240 256 251 287 100 TOS 192 439 445 451 457 463 469 130 134 138 142 1 150 154 150 165 615 621 198 204 210 216 112 116 120 124 128 TO 577 532 222 595 475 481 437 493 499 505 511 773 270 285 291 207 300 172 179 184 190 196 209 200 214 300 517 5,400 5,440 5,480 5,520 5,560 5,600 5,640 5.650 5,720 5,760 5,800 5,840 5,800 5,920 5.960 6,000 6,040 6,080 425 431 437 443 449 455 461 467 473 479 485 491 315 5.440 5,400 5,520 5,560 5,600 5,640 5,600 5,720 5.760 5,800 5,840 5,880 5.920 5,960 6,000 6,040 6,080 6,120 527 6:13 639 645 651 657 863 669 675 681 687 093 690 705 711 717 723 729 601 607 613 619 625 631 637 643 649 655 661 067 544 550 556 562 568 574 580 586 592 598 604 610 610 822 628 523 529 535 541 547 553 559 565 571 577 374 380 380 392 398 404 410 416 422 428 434 440 446 452 459 484 470 476 323 329 333 341 347 353 350 365 371 377 383 389 395 401 407 413 419 425 228 234 240 246 252 250 254 270 278 252 28 294 300 306 312 327 333 330 345 351 357 363 300 375 226 20 2010 244 250 112 136 140 144 TA 152 157 169 100 175 181 187 103 199 205 211 217 223 497 503 500 515 521 527 673 318 20 679 324 274