Question

1. Total net pay, $16.592.58 Excel PR 11-4B Payroll register OBJ. 2,3 The following data for Flexco Inc. relate to the payroll for the week ended December, 2016 Hours Hourly Weekly Federal Retirement Employee Worked Rate Salary Income Tax Savings Carlton 52 $50.00 $667.00 $ 60 Grove $4,000 860.00 100 Johnson 36 52.00 355.68 Koufax 58.00 578.55 Maddux 45.00 349.65 Seaver 3,200 768.00 Spahn 52.00 382.20 0 Winn 75 48 50.00 572.00 54.00 43 480.60 0 46 80 Young Employees Grove and Seaver are office staff, and all of the other employees are sales personnel. All sales personnel are paid 15 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, 20Y8. 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, Retirement Savings, 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

ns Tax iton 52 3 4 5 6 7 8 9 Employe Total e Hours Carlton Grove Johnson 36 Koufax Maddux 37 Seaver Spahn 46 Winn Young 43 Total Payroll for Week Ending December 9, 2016 Deductio Deduction Deduction Deductio Deductio Earnings Earnings Earnings S Paid Social Federal U.S. Security Medicare Income Savings Regular Overtime Total Tax Tax Bond Total Net Pay 2000 900 2900 174 $60.00 944.5 1955.5 4000 2401 60 860 1001 1260 2740 1872) 1872 112.32 28.08 355.68 496.08 1375.92 2320 2755 165.3 41.33 578.55 44 829.18) 1925.82 1665 1665 99.9 24.98 349.65 621 536.53 1128.47 3200192 48 768 1201 11282072 2080 468) 2548 152.88 38.22 382.2 573.3 1974.7| 2000 600 2600 156 39 572 751 842 1758 2160 243 2403 144.18 36.05 480.6 801 740.83 1662.17 140971 2646 23943 1436.58 359.15 $5,013.68 $541.001 7350.41 16592.6 Account Account Paid Debited Debited Sales Office Salaries Salaries Ck. No. Expense Expense #328 2900 #329 4000 #330 1872 #331 2755 #332 1665 #333 3200 #334 2548 #335 2600 #3361 2403 14340 7200 10 48 11 12

JOURNAL POST. REF. | DATE DESCRIPTION 7/12/2014 Sales salary Expenses Office Salaries Expenses Social Security Tax Payable Medicare Tax Payable Employee Federal Income Tax Payable Bond Dedection Payable Salaries Payable DEBIT CREDIT 16743 7200 1436.58 359.15 5013.48 541 16592.8