The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9, 2016:

Can an accountant please help answer this question? I have attached a copy of the instructions and a copy of the format in which it should be setup.

**I have completed the majority of the assignment, but I need help with the total of the net amount, it is NOT $15,424.10 or $15,424.12, and I also need help on the salaries payable!

Thank you!

\fMODULE EXCEL PROBLEM 6 PR 11-4A Payroll register The following data for Throwback Industries, Inc. relate to the payroll for the week ended December 9, 2016: Employee Aaron Cobb Clemente DiMaggio Griffey, Jr. Mantle Robinson Williams Vaughn Hours Worked 46 41 48 35 45 N/A 36 N/A 42 Hourly Rate $68.00 62.00 70.00 56.00 62.00 Total only 54.00 Total only 62.00 Weekly Salary $1,800 2,000 Federal Income Tax $750.20 537.68 832.64 366.04 641.84 342.45 382.56 398.24 584.72 U.S. Savings Bonds $100 110 120 0 130 120 130 125 50 Employees Mantle and Williams 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%, 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 register for Throwback Industries, Inc. for the week ended December 9, 2016. 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. Put a zero in blank cell for grading purposes. 2. Journalize the entry to record the payroll for the week. Problem 11-4A Name: Section: Score: Key Code: Instructions Ninah Lee Module 6 Excel Problem- Payroll Register 98% [Key code here] Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. Enter a zero in cells you would otherwise leave blank. 1. PAYROLL FOR WEEK ENDING December 9, 2016 EARNINGS Name Aaron Cobb Clemente DiMaggio Griffey, Jr. Mantle Robinson Williams Vaughn Total Hours 46 41 48 35 45 36 42 Regular $2,720 $2,480 $2,800 $1,960 $2,480 $0 $1,944 $2,480 $16,864 Overtime $612 $93 $840 $465 $186 $2,196 Total Social Security Tax $3,332 $2,573 $3,640 $1,960 $2,945 $1,800 $1,944 $2,000 $2,666 $22,860 $199.92 $154.38 $218.40 $117.60 $176.70 $108.00 $116.64 $120.00 $159.96 $1,371.60 Medicare Tax $49.98 $38.60 $54.60 $29.40 $44.18 $27.00 $29.16 $30.00 $39.99 $342.91 DEDUCTIONS Federal Income Tax $750.20 $537.68 $832.64 $366.04 $641.84 $342.45 $382.56 $398.24 $584.72 $4,836.37 2. Sales Salaries Expense Office Salaries Expense Social Security Tax Payable Medicare Tax Payable Employees Federal Income Tax Payable Bond Deductions Payable Salaries Payable 19,060.00 3,800.00