Please help

1.Prepare the payroll register for Trenkamp Collection Agency for the week ended November 18, 20--. (In the Taxable Earnings/Unemployment Compensation column, enter $365 for Salzman and $440 for Layton. Leave this column blank for all other employees.) Total the amount columns.?

FEDERAL WITHOLDING TAX TABLES SINGLE Persons-WEEKLY Payroll Period (For Wages Paid through December 31, 2015) And the wages are And the number of withholding allowances claimed is- 2 3 4 5 6 7 8 9 10 At least But less than The amount of income tax to be withheld is- $300 $310 $30 $19 $11 $3 $0 $0 $0 $0 $0 50 0 0 0 310 320 32 20 12 4 0 0 0 320 330 33 22 13 0 0 0 0 0 0 0 330 340 35 23 14 0 0 0 6 0 0 0 0 0 0 0 340 350 36 25 15 7 0 0 0 0 0 350 360 38 26 16 8 0 0 0 0 0 O 0 0 0 0 O 28 9 1 360 370 39 17 O O O 370 380 41 29 18 10 2 0 0 0 O 0 0 O 42 3 380 390 31 19 11 0 0 0 O O 400 44 32 21 12 4 0 0 0 390 0 0 O 400 410 45 34 22 13 5 0 0 24 14 6 0 0 0 0 O O 410 420 47 35 0 0 O 7 0 0 15 420 430 48 37 25 0 0 0 440 50 38 27 16 8 O O 430 28 17 9 2 0 0 0 0 51 40 440 450 O 10 3 0 0 0 0 460 53 41 30 18 450 0 0 0 0 0 54 43 31 20 11 4 460 470 21 12 5 0 0 0 0 56 33 470 480 44 O 23 13 6 0 0 0 0 57 46 34 480 490 0 0 O 47 36 24 14 7 0 0 500 59 490 0 15 8 0 0 0 0 60 49 37 26 500 510 O O 1 0 0 62 50 39 27 16 9 510 520 0 0 0 2 0 530 63 52 40 29 17 10 520 0 O 11 3 0 0 540 65 53 42 30 19 530 0 0 0 0 20 12 A 550 66 55 43 32 540 0 0 0 5 0 56 45 33 22 13 560 68 O 550 0 0 0 35 570 69 58 46 23 14 6 O 560 7 0 0 0 25 15 59 48 36 O 580 71 0 570 26 8 0 590 72 61 49 38 16 580FEDERAL WITHOLDING TAX TABLES SINGLE Persons - WEEKLY Payroll Period ( For Wages Paid through December 31 , 2015 ) And the wages are - At least O And the number of withholding allowances claimed is - But less than 3 4 5 7 8 590 9 10 600 The amount of income tax to be withheld is - 74 600 57 39 610 28 17 9 75 04 610 620 70 70 LL 620 54 4 6 37 630 79 78 67 630 55 44 32 21 640 80 68 540 57 45 34 2.7 650 87 70 650 47 35 660 24 83 71 60 660 48 670 37 25 15 84 670 73 61 50 38 N 680 86 74 63 680 51 40 28 690 87 76 64 690 53 41 30 18 700 68 77 66 54 700 43 37 710 20 90 79 67 56 710 44 33 21 720 92 80 69 57 46 720 34 23 730 93 OZ 70 59 47 730 36 24 740 14 95 83 72 60 49 37 740 26 750 96 85 73 62 39 27 16 750 760 86 86 75 63 52 40 17 760 770 88 16 65 53 42 30 78 770 11 780 102 89 10 66 55 43 32 20 12 780 790 104 91 $56 45 33 21 73 5 790 800 107 92 81 69 58 46 35 23 14FEDERAL WITHOLDING TAX TABLES MARRIED Persons - WEEKLY Payroll Period ( For Wages Paid through December 31 , 2015 ) And the wages are* And the number of withholding allowances claimed is - 3 At least 7 8 9 10 But less than The amount of income tax to be withheld is - $300 $310 $ 74 DU 80 80 80 DO OS 310 320 75 320 330 16 330 340 71 9 340 3.50 78 350 360 19 11 360 370 20 12 370 380 21 13 0 10 0 38( 390 22 14 O O 10OOOO 0 0 390 400 23 15 00 400 410 24 16 0 O 410 420 25 17 10 ~ 30 0 0 420 430 26 18 O' 430 440 27 19 12 0 440 450 28 20 0 450 460 29 21 14 0 0 460 170 30 22 15 470 480 31 23 16 00 O 480 490 32 24 OOO 490 500 33 25 18 N 0 500 510 34 26 79 0 510 520 35 27 20 12 0 520 530 JO 28 21 w 530 540 85 29 22 14 540 550 30 68 23 15 550 560 47 37 24 16 00 560 570 4 L 25 17 9 580 26 18 10 O 570 3 3 O 44 w 580 590 45 34 27 19 17 O O 0 O OFEDERAL WITHOLDING TAX TABLES MARRIED Persons - WEEKLY Payroll Period ( For Wages Paid through December 31 , 2015 ) And the wages are - And the number of withholding allowances claimed is - 8 9 10 At least But less than The amount of income tax to be withheld is - 590 600 41 35 20 20 72 600 610 87 37 27 73 6 610 620 50 JU 620 630 LG 40 LE 75 630 640 53 47 24 78 76 9 640 650 54 43 33 25 17 650 660 56 44 34 26 18 11 660 670 57 46 35 27 19 12 670 680 59 47 36 28 20 13 680 690 60 49 37 29 21 14 690 700 62 50 39 30 22 15 700 710 63 52 40 31 23 710 720 65 53 42 32 24 17 720 730 66 55 43 33 25 18 O 730 740 68 56 45 34 26 19 740 750 58 46 35 27 20 N 6.9 750 760 71 59 48 36 28 21 13 760 770 72 67 49 30 29 22 14 770 780 74 57 23 75 780 790 GA 1.4 37 24 76 8 790 800 77 Vy 41 32 25 17 9 800 810 78 67 5.5 23. 3 26 78 10 1 , 300 1 , 310 153 742 730 179 707 96 84 72 67 4.9 38 1 , 310 1 , 320 155 143 732 120 709 74 62 51 39 1 , 320 1 , 330 156 145 133 122 110 87 75 64 52 47 1 , 330 1 , 340 158 146 135 123 712 100 77 54 4 6 88 1 , 340 1 , 350 159 148 136 125 1 13 90 78 4 4 GG 19 1 , 360 161 149 138 126 115 91 57 45 1 , 350 103 80 68 1 , 360 1 , 370 162 151 139 128 116 105 93 81 70 58 47FEDERAL WITHOLDING TAX TABLES MARRIED Persons-WEEKLY Payroll Period (For Wages Paid through December 31, 2015) And the wages are- And the number of withholding allowances claimed is- 0 2 3 5 6 7 8 9 10 At least But less than The amount of income tax to be withheld is- 1,370 1,380 164 152 141 129 118 106 94 83 71 60 48 1,380 1,390 165 154 142 131 119 108 96 84 73 61 50 1,390 1,400 167 155 144 132 121 109 97 86 74 63 51Instructions Friday are paid at 1%% times the regular rate. All weekend hours are paid at double the regular rate the credit union for varying amounts as listed. Trenkamp Collection Agency Payroll Information for the Week Ended November 18, 20-- Employee No of Marital Regular Hours Worked Hourly Credit Union Total Earnings Name No. Allow. Status S S M T WT F Rate Deposit 1/1-11/11 Berling, James 3 M 2 2 9 8 8 9 10 $12 $149.60 $24,525 Merz, Linda 4 M 0 0 8 8 8 8 10 15 117.00 30,480 Goetz, Ken 3 M 0 0 6 7 8 9 10 11 91.30 21,500 Menick, Judd 8 8 0 0 8 8 9 11 126.50 22,625 Morales, Eva M 0 0 8 8 8 6 8 13 117.05 24,730 Heimbrock, Jacob 5 M 0 0 8 8 8 8 8 34 154.25 117,540 Townsley, Sarah 7 M 4 0 6 6 6 6 4 9 83.05 21,425 Salzman, Beth 8 M 6 2 8 8 6 6 6 11 130.00 6,635 Layton, Esther M 0 0 8 8 8 8 8 11 88.00 5,635 Thompson, David 10 M 0 2 10 9 7 7 10 11 128.90 21,635 Vadillo, Carmen 11 2 S 8 0 4 8 8 8 9 13 139.11 24, 115Instructions The Trenkamp Collection Agency follows the practice of drawing a single check for the net amount of the payroll and depositing the check in a special payroll account at the bank . Individual checks issued were numbered consecutively , beginning with No . 331 . Required :" 1 . Prepare a payroll register for Trenkamp Collection Agency for the week ended November 18 . 20 -. In the Taxable Earnings / Unemployment Compensation column , enter $36.5 for Salzman and $440 for Layton . Leave this column blank for all other employees . ) Total the amount columns .Chart Of ACCOUNTS CHART OF ACCOUNTS Trenkamp Collection General Ledger ASSETS REVENUE 101 Cash 401 Sales 142 Supplies 145 Prepaid Insurance* EXPENSES 181 Office Equipment 51 1 Wages and Salaries Expense 181. 1 Accumulated Depreciation - Office Equipment 521 Rent Expense 523 Office Supplies Expense* LIABILITIES 5.3.3 Utilities EXPENSE* 202 Accounts Payable* 535 Insurance Expense* 203 United Way Contributions Payable 541 Depreciation Expense - Office Equipment 211 Employee Federal Income Tax Payable* 549 Miscellaneous EXPENSE 212 Social Security Tax Payable 213 Medicare Tax Payable* 215 State Income Tax Payable* 216 Health Insurance Premiums Payable 217 Credit Union Payable*_hart of Accounts 101 Cash 40 1 Sales 142 Supplies 145\\ Prepaid Insurance* EXPENSES 181 Office Equipment 571 Wages and Salaries Expense 181 . 1 Accumulated Depreciation - Office Equipment* 521 Rent Expense 523 Office Supplies Expense LIABILITIES 5.3.3 Utilities Expense* 202 Accounts Payable 5.35 Insurance Expense* 203 United Way Contributions Payable* 541 Depreciation Expense - Office Equipment* 211 Employee Federal Income Tax Payable* 549 Miscellaneous Expense* 212 Social Security Tax Payable* 213 Medicare Tax Payable 215 State Income Tax Payable* 216 Health Insurance Premiums Payable* 217 Credit Union Payable* EQUITY 31 1 Capital 313 Income Summary 321 DrawingPayroll hiegister Payroll Register Instructions* PAYROLL REGISTER FOR THE PERIOD ENDED* 20 -- EARNINGS TAXABLE EARNINGS DEDUCTIONS NAME NO . ALLOW*\\ MARIT . STATUS* REGULAR\\\\ OVERTIME TOTAL\\ CUM . TOTAL\\ UNEMPLOYP .\\ SOC . SEC.` FED . INC . TAX| SOC . SEC . TAX\\ MEDICARE TAX| STATE INCOME TAX\\ HEALTH INSUR .\\\\ CREDIT UNION\\\\ TOTAL NET PAY CK . NO. \\N \\M \\\\OOOOOOOOO |O \\OOOOOOOOODY JOOOOOOO OOO ! \\DOODOODOOOLD