The following data for Flexco Inc. relate to the payroll for the week ended December 7, 2014

The following data for Flexco Inc. relate to the payroll for the week ended December 7, 2014:
















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 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 7, 2014. Use the following columns for the payroll register: Employee, Total Hours, Regular Earnings, 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.


Answer:

1. PAYROLL FOR WEEK ENDING December 7, 2014
Employee
Total
Hours
EARNINGS DEDUCTIONS PAID ACCOUNT DEBITED
Regular Overtime Total
Social
Security
Tax
Medicare
Tax
Federal
Income
Tax
U.S.
Savings
Bonds Total
Net
Pay
Ck.
No.
Sales
Salaries
Expense
Office
Salaries
Expense
Carlton 52 2,000.00 900.00 2,900.00 174.00 43.50 667.00 60.00 944.50 1,955.50 328 2,900.00
Grove 4,000.00 240.00 60.00 860.00 100.00 1,260.00 2,740.00 329 4,000.00
Johnson 36 1,872.00 1,872.00 112.32 28.08 355.68 496.08 1,375.92 330 1,872.00
Koufax 45 2,320.00 435.00 2,755.00 165.30 41.33 578.55 44.00 829.18 1,925.82 331 2,755.00
Maddux 37 1,665.00 1,665.00 99.90 24.98 349.65 62.00 536.53 1,128.47 332 1,665.00
Seaver 3,200.00 192.00 48.00 768.00 120.00 1,128.00 2,072.00 333 3,200.00
Spahn 46 2,080.00 468.00 2,548.00 152.88 38.22 382.20 573.30 1,974.70 334 2,548.00
Winn 48 2,000.00 600.00 2,600.00 156.00 39.00 572.00 75.00 842.00 1,758.00 335 2,600.00
Young 43 2,160.00 243.00 2,403.00 144.18 36.05 480.60 80.00 740.83 1,662.17 336 2,403.00
14,097.00 2,646.00 23,943.00 1,436.58 359.16 5,013.68 541.00 7,350.42 16,592.58 16,743.00 7,200.00
2. Sales Salaries Expense 16,743.00
Office Salaries Expense 7,200.00
Social Security Tax Payable 1,436.58
Medicare Tax Payable 359.16
Employees Federal Income Tax Payable 5,013.68
Bond Deductions Payable 541.00
Salaries Payable 16,592.58