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