CAN AN ACCOUNTANT PLEASE HELP ME WITH MY PAYROLL REGISTER PLEASE :)

The following data for Throwback Industries Inc. relate to the payroll for the week ended December 9, 2016: Employ ee Hours Hourly Weekly Federal Income U.S. Savings Worked Rate Salary Tax Bonds Aaron 45 $62 $641.84 $100 Cobb 42 67 623.92 110 Clement 49 68 835.88 120 DiMaggio 38 54 376.68 0 Griffey, 46 63 681.60 130 292.45 120 418.40 130 370.24 125 702.60 80 e Jr. Mantle $1,600 Robinson 38 56 Williams Vaughn 1,900 46 63 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. 1. Prepare a payroll register for Throwback Industries Inc. for the week ended December 9, 2016. Assume the normal working hours in a week are 40 hours. Enter amounts as positive numbers and round your intermediate calculations and final answers to the nearest whole cent (two decimal places). Score: 15/315 Payroll for Week Endin Earni Earni Earni Dedu Dedu 1 ngs ngs ngs ctions ctions Dedu Dedu ction ction s 2 Empl To Regul Overt Total Social Medic Fede oyee tal ar ime s U.S. Secur are ral Savin Ho ity Tax Inco gs ur Tax me Bond Dedu ctions Total P Paid ai d Accou Accou nt nt Debit Debit ed ed Net C Sales Office Pay k. Salari Salari N es es o. Expen Expen s 3 Aaro 45. n 4 Cobb 5 6 7 8 9 00 42. 00 Clem 49. ente 00 DiMa 38. ggio 00 Griffe 46. y, Jr. 00 Mantl e Robi 38. nson 00 1 2 84 00 623.9 110.0 2 0 835.8 120.0 8 0 0 0 418.4 130.0 4 00 702.6 0 0 0 # 90 2 # 90 3 # 90 5 # 90 6 # 90 7 # 90 8 # 80.00 90 9 $4,94 $915. 3.61 1 4 681.6 130.0 0 90 90 8 0 # 43.00 # 376.6 370.2 125.0 ms hn $641. $100. 5 1 Vaug 46. 1 se 292.4 120.0 1 Willia 0 Tax 00 se