AutoSave Off H D - 15e_PR 10-4A - Excel 0 - 0 X Comments File Home Insert Draw Page Layout Formulas Data Review View Help Search Share C2 X foc A B C D E F 12 Enter a zero in cells you would otherwise leave blank. G H I J K L M N O P Q R S T U V W X Y Z AA AB A PAYROLL FOR WEEK ENDING December 9 EARNINGS PAID DEDUCTIONS Federal Income Tax Social Security Tax Total Hours ACCOUNTS DEBITED Sales Office Salaries Salaries Expense Expense U.S. Savings Bond Medicare Tax Net Amount Ck. No. Name Regular Overtime Total Total Aaron Cobb Clemente DiMaggio Griffey, Jr. Mantle Robinson Williams Vaughn 36 Pr. 10-4A + 90% NA 2. Ci il ENG 6:53 AM 11/4/2019 PR_10-4A_data - Windows Photo Viewer File Print E-mail Burn Open - PR 10-4A Payroll summary Obj. 2 The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9. Employee Hours Worked Hourly Rate Weekly Salary Aaron Cobb Clemente DiMaggio Griffey, Jr. Mantle Robinson Williams Vaughn $68.00 62.00 70.00 56.00 62.00 Federal U.S. Savings Income Tax Bonds $750.20 $100 537.68 110 832.64 120 366.04 0 641.84 130 342.45 120 382.56 130 398.24 125 584.72 $1,800 54.00 2,000 62.00 Employees Mantle and williams are office staff, and all of the other employees are sales personnel. All sales personnel are paid 11/2 times the regular rate for all hours in excess of 40 hours per week. The social security tax rate is 6.0%, and Medicare tax is 1.5% of each employee's annual earnings. The next payroll check to be used is No. 901. Instructions 1. Prepare a payroll summary for Throwback Industries Inc. for the week ended December 9. Use the following columns: 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. Answer Check Figure: Total net pay $15,424.12 2. Journalize the entry to record the payroll for the week. 1 @ @ @ @ hp x n o p w 9 9 B . C all ENG 6:57 AM 11/4/2019