In: Accounting
Complete the following payroll register for Thorndike Manufacturing Company. All workers receive time and one-half for hours worked in excess of 40 hours per week. Compute Social Security using 6.2% and Medicare using 1.45%. Medical insurance and union dues deductions are shown in the payroll register. Use the wage bracket method to determine federal income tax. Total each column and verify the total net pay amount.
Register | |||||||||||||||
Earnings | Deductions | ||||||||||||||
Employee Name | Allow. | Status | Hours Worked | Pay Rate |
Regular | Overtime | Gross Earnings |
Fed. Inc. Tax |
Social Security |
Medicare | Medical Ins. Pre-tax |
Union Dues |
Total Deductions |
Net Pay | |
1.5 | 6.2% | 1.45% | |||||||||||||
Bell, L. | 0 | S | 40 | 10.80 | 14.00 |
Based on the information available in the question, we can setup the employee payroll register as follows:-
Employee | Hours Worked | Pay Rate | Gross Earnings | Medicare | Medical Insurance pre tax | Social Security | Total deductions | Net Pay |
A (Hours worked * Pay rate) | A * 1.45% | A*6.2% | B | A-B | ||||
Bell L | 40 | 10.8 | 432 | 6.26 | 14.00 | 26.78 | 47.05 | 384.95 |
Please let me know if you have any questions via comments and all the best :)