Question
The following data for Flexco Inc. relate to the payroll for the week ended December 9, 2016: Employee Hours Worked Hourly Rate Weekly Salary Federal
The following data for Flexco Inc. relate to the payroll for the week ended December 9, 2016:
Employee | Hours Worked | Hourly Rate | Weekly Salary | 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 employees annual earnings, and Medicare tax is 1.5% of each employees annual earnings. The next payroll check to be used is No. 328.
Required: | |
1. | Prepare a payroll register for Flexco Inc. for the week ended December 9, 2016. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers and round your intermediate calculations and final answers to the nearest whole cent (two decimal places). |
2. | Journalize the entry to record the payroll for the week. If required, round your answers to two decimal places. Refer to the Chart of Accounts for exact wording of account titles. |
Chart of Accounts
CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Flexco Inc. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Payroll Register
1. Prepare a payroll register for Flexco Inc. for the week ended December 9, 2016. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers and round your intermediate calculations and final answers to the nearest whole cent (two decimal places).
Payroll for Week Ending December 9, 2016 |
1 |
|
| Earnings | Earnings | Earnings | Deductions | Deductions | Deductions | Deductions | Deductions | Paid | Paid | Account Debited | Account Debited |
2 | Employee | Total Hours | Regular | Overtime | Total | Social Security Tax | Medicare Tax | Federal Income Tax | U.S. Savings Bond | Total | Net Pay | Ck. No. | Sales Salaries Expense | Office Salaries Expense |
3 | Carlton | 52.00 | $667.00 | $60.00 | #328 | |||||||||
4 | Grove |
| 860.00 | 100.00 | #329 | |||||||||
5 | Johnson | 36.00 | 355.68 |
| #330 | |||||||||
6 | Koufax | 45.00 | 578.55 | 44.00 | #331 | |||||||||
7 | Maddux | 37.00 | 349.65 | 62.00 | #332 | |||||||||
8 | Seaver |
| 768.00 | 120.00 | #333 | |||||||||
9 | Spahn | 46.00 | 382.20 |
| #334 | |||||||||
10 | Winn | 48.00 | 572.00 | 75.00 | #335 | |||||||||
11 | Young | 43.00 | 480.60 | 80.00 | #336 | |||||||||
12 |
|
| $5,013.68 | $541.00 |
|
Journal
2. Journalize the entry to record the payroll for the week. If required, round your answers to two decimal places. Refer to the Chart of Accounts for exact wording of account titles.
PAGE 1
JOURNAL
DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT | |
---|---|---|---|---|---|
1 |
| ||||
2 |
| ||||
3 |
| ||||
4 |
| ||||
5 |
| ||||
6 |
| ||||
7 |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started