Payroll summary The following data for Flexco Inc. relate to the payroll for the week ended December 9: Federal U.S. Hours Hourly Weekly Income Savings Employee Worked Rate Salary Tax 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 6 52.00 382.20 0 Winn 8 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 1/2 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. Required: 1. Prepare a payroll summary for Flexco Inc. for the week ended December 9. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers. Round intermediate calculations and final answers to two decimal places1. Prepare a payroll summary for Flexco Inc. for the week ended December 9. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers. Round intermediate calculations and final answers to two decimal places. Payroll for Week Ending December 9 DEDUCTIONS DEDUCTIONS DEDUCTIONS ACCOUNTS DEBITED ACCOUNTS DI Social DEDUCTIONS Federal U.S. Sales Office Total EARNINGS EARNINGS EARNINGS Security Medicare Income Savings PAID PAID Salaries Salarie: Employee Hours Regular Overtime Total Tax Tax Tax Bands Total Net Pay Ck. No. Expense ExpenSI Carlton 52 $| | $| | $l l $| | $| | $667.00 $60.00 $[:] $[:] 328 $[: Koufax 45 | | | | l l | | | | 578.55 44.00 :] [:] 331 C] 5. S S S :1 755.5. .20... S E 555 C 4. I | I | I I I I I I :l :l :1 I... 48 I I I I I I I I I I [:1 [:1 [:1 4. I I I I I I I I I I $:] 3:] $[:] Totals $| | $| | $l l $| | $| | $l l $| | $l l $l l $[:J 3C Feedback