Sheridan Hardware has four employees who are paid on an hourly basis plus time-and-a-half for all...

   

Transcribed Image Text:

Sheridan 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, 2022, are presented below. Employee Hours Worked Hourly Rate Federal Income Tax Withholdings United Fund Ben Abel 40 $15.00 $59.00 $5.00 Rita Hager 42 16.00 64.00 5.00 Jack Never 46 13.00 60.00 8.00 Sue Perez 48 13.00 62.00 5.00 Abel and Hager are married. They claim O 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.6%. (a) Prepare a payroll register for the weekly payroll. No employee has reached the Social Security limit of $132,900 or the FUTA/SUTA limit of $7,000. (Round answers to 2 decimal places, e.g. 15.25.) MARRIED Persons-WEEKLY Payroll Period (For Wages Paid through December 2022) If the wages are- But And the number of withholding allowances claimed is- 0 1 2 3 4 5 6 7 8 9 At 10 10 less least than The amount of income tax to be withheld is- 1,316 1,327 124 114 105 95 95 85 75 66 56 46 37 29 1,327 1,338 125 116 106 96 96 88 86 77 67 57 48 38 30 1,338 1,349 127 117 107 97 88 88 78 18 68 59 49 19 39 31 1,349 1,360 128 118 108 99 89 79 70 80 60 50 41 32 1,360 1,371 129 119 110 100 90 90 81 71 69 61 52 42 33 2 1,371 1,382 130 121 111 101 92 82 72 63 53 43 34 1,382 1,393 132 122 112 103 93 83 74 64 54 45 35 1,393 1,404 133 123 114 104 1,404 1,415 134 125 115 105 96 1,415 1,426 136 126 116 107 97 24 94 96 889 85 75 55 65 56 46 36 86 76 67 57 47 38 80 87 78 68 58 49 49 39 1,426 1,437 137 127 118 108 98 89 79 69 60 50 50 40 1,437 1,448 138 129 119 109 100 1,448 1,459 140 130 120 111 101 1,459 1,470 141 131 122 112 102 93 83 73 64 54 44 24 1,470 1,481 142 133 123 113 104 94 84 15 75 #4 65 55 45 8 90 80 71 13 61 51 51 41 223 91 82 22 72 22 62 52 43 1,481 1,492 144 134 124 115 105 95 86 76 76 646 66 56 47 Employee Hours Ben Abel 40 $ Rita Hager 42 12 Jack Never 46 Sue Perez 48 Totals Earnings Regular Overtime Gross Pay $ FICA SHERIDAN HARDWARE Payroll Register For the Week Ending March 15, 2 $ $ $ $ Federal Income Tax Sheridan 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, 2022, are presented below. Employee Hours Worked Hourly Rate Federal Income Tax Withholdings United Fund Ben Abel 40 $15.00 $59.00 $5.00 Rita Hager 42 16.00 64.00 5.00 Jack Never 46 13.00 60.00 8.00 Sue Perez 48 13.00 62.00 5.00 Abel and Hager are married. They claim O 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.6%. (a) Prepare a payroll register for the weekly payroll. No employee has reached the Social Security limit of $132,900 or the FUTA/SUTA limit of $7,000. (Round answers to 2 decimal places, e.g. 15.25.) MARRIED Persons-WEEKLY Payroll Period (For Wages Paid through December 2022) If the wages are- But And the number of withholding allowances claimed is- 0 1 2 3 4 5 6 7 8 9 At 10 10 less least than The amount of income tax to be withheld is- 1,316 1,327 124 114 105 95 95 85 75 66 56 46 37 29 1,327 1,338 125 116 106 96 96 88 86 77 67 57 48 38 30 1,338 1,349 127 117 107 97 88 88 78 18 68 59 49 19 39 31 1,349 1,360 128 118 108 99 89 79 70 80 60 50 41 32 1,360 1,371 129 119 110 100 90 90 81 71 69 61 52 42 33 2 1,371 1,382 130 121 111 101 92 82 72 63 53 43 34 1,382 1,393 132 122 112 103 93 83 74 64 54 45 35 1,393 1,404 133 123 114 104 1,404 1,415 134 125 115 105 96 1,415 1,426 136 126 116 107 97 24 94 96 889 85 75 55 65 56 46 36 86 76 67 57 47 38 80 87 78 68 58 49 49 39 1,426 1,437 137 127 118 108 98 89 79 69 60 50 50 40 1,437 1,448 138 129 119 109 100 1,448 1,459 140 130 120 111 101 1,459 1,470 141 131 122 112 102 93 83 73 64 54 44 24 1,470 1,481 142 133 123 113 104 94 84 15 75 #4 65 55 45 8 90 80 71 13 61 51 51 41 223 91 82 22 72 22 62 52 43 1,481 1,492 144 134 124 115 105 95 86 76 76 646 66 56 47 Employee Hours Ben Abel 40 $ Rita Hager 42 12 Jack Never 46 Sue Perez 48 Totals Earnings Regular Overtime Gross Pay $ FICA SHERIDAN HARDWARE Payroll Register For the Week Ending March 15, 2 $ $ $ $ Federal Income Tax