Problem 11-03A a-d Concord Hardware has four employees who are paid on an hourly basis plus time-and-a-half for all hours worked in excess of 40 a week. Payroll data for the week ended March 15, 2020, are presented below. Hours Worked Hourly Rate Federal Income Tax Withholdings United Fund $5 5 Employee Ben Abel Rita Hager Jack Never Sue Perez 40 41 44 $15 16 13 13 ? 60 8 5 46 61 Abel and Hager are married. They claim 0 and 4 withholding allowances, respectively. The following tax rates are applicable: FICA 7.65%, state income taxes 3%, state unemployment taxes 5.4%, and federal unemployment 0.8%. Prepare a payroll register for the weekly payroll. (Round answers to 2 decimal places, e.g. 15.25.) MARRIED Persons WEEKLY Payroll Period (For Wages Paid through December 2017) If the wages are And the number of withholding allowances claimed is - But less o 2 1 3 At least 4 5 6 7 8 9 10 than The amount of income tax to be withheld is 500 510 34 27 19 11 4 0 0 0 0 510 520 35 28 20 12 5 0 0 0 0 0 0 520 530 37 29 21 13 6 0 0 0 0 0 0 530 540 38 30 22 14 7 0 0 0 0 0 540 550 40 31 23 15 8 0 000 0 0 550 560 41 32 24 16 9 1 0 0 0 0 0 560 570 43 33 25 17 10 2 0 0 0 0 0 570 580 44 34 26 18 | 11 3 0 0 00 0 580 590 46 35 27 19 12 4 0 0 0 0 0 590 600 47 36 28 2013 5 0 0 0 0 600 610 38 39 610 620 630 640 650 620 630 640 49 50 52 53 55 21 22 23 24 29 30 31 32 33 41 42 44 14 15 16 17 18 6 7 8 9 10 25 0 0 0 0 0 0 0 1 0 0 0 2000 0 3 000 0 4 0 0 0 0 5 o 0 0 0 6 0 0 0 0 7 0 0 0 0 8 0 0 0 650 11 660 670 680 56 58 59 12 45 47 48 50 51 660 670 680 690 34 35 37 38 40 ovou WN- 26 27 28 29 30 19 20 21 22 23 690 700 61 62 13 14 15 CONCORD HARDWARE Payroll Register For the Week Ending March 15, 2020 Deductions Federal Income Tax State Income Tax Earnings Overtime Employee Hours Regular Gross Pay FICA United Fund Total Net Pay Salaries and Wages Expense Ben Abel 40 $ $ $ $ $ $ $ $ $ Rita Hager 41 Jack Never 44 Sue Perez 46 Totals $ $ $ $ SHOW LIST OF ACCOUNTS DELLE Journalize the payroll on March 15, 2020, and the accrual of employer payroll taxes. (Round answers to 2 decimal places, e.g. 15.25. Credit account titles are automatically indented when amount is entered. Do not indent manually.) Account Titles and Explanation Debit Credit Date Mar. 15 (To record payroll) Mar. 15 (To record accrual of payroll taxes.) SHOW UST OF ACCOUNTS UNK TO TEXT Journalize the payment of the payroll on March 16, 2020. (Round answers to 2 decimal places, e.g. 15.25. Credit account titles are automatically indented when amount is entered. Do not indent manually.) Date Account Titles and Explanation Debit Credit Mar. 16 SHOW UST OF ACCOUNTS UNK TO TEXT Journalize the deposit in a Federal Reserve bank on March 31, 2020, of the FICA and federal income taxes payable to the government. (Round answers to 2 decimal places, e.g. 15.25. Credit account titles are automatically indented when amount is entered. Do not indent manually.) Debit Credit Date Account Titles and Explanation Mar. 31