Payroll register
SuperClassThe following data for Flexco Inc. relate to the payroll for the week ended December 9, 2016:
Employee | hours Worked | hourly Rate | WeeklySalary | Federal Income Tax | u.S. Savings Bonds |
Carlton | 52 | $50.00 |
| $667.00 | $ 60 |
Grove |
|
| $4,000 | 860.00 | 100 |
Johnson | 36 | 52.00 |
| 355.68 | 0 |
Koufax | 45 | 58.00 |
| 578.55 | 44 |
Maddux | 37 | 45.00 |
| 349.65 | 62 |
Seaver |
|
| 3,200 | 768.00 | 120 |
Spahn | 46 | 52.00 |
| 382.20 | 0 |
Winn | 48 | 50.00 |
| 572.00 | 75 |
Young | 43 | 54.00 |
| 480.60 | 80 |
Employees Grove and Seaver are office staff, and all of the other employees are sales personnel. All sales personnel are paid 1½ times the regular rate for all hours in excess of 40 hours per week. The social security tax rate is 6.0% of each employee’s annual earnings, and Medicare tax is 1.5% of each employee’s annual earnings. The next payroll check to be used is No. 328.
Instructions
1. Prepare a payroll register for Flexco Inc. for the week ended December 9, 2016. Use the following columns for the payroll register: Employee, Total Hours, Regular Earn- ings, Overtime Earnings, Total Earnings, Social Security Tax, Medicare Tax, Federal Income Tax, U.S. Savings Bonds, Total Deductions, Net Pay, Ck. No., Sales Salaries Expense, and Office Salaries Expense.
2. Journalize the entry to record the payroll for the week.
10 years ago
Purchase the answer to view it
payroll_register.xlsx
