I would like help with Problem 12-9 Preparing a Payroll please, any help is appreciated!

PROBLEM 12-9 Preparing the Payroll Register Showbiz Video has six employees who are paid weekly. The hourly employees are paid overtime for hours worked over 40 in a week, at a rate 11/2 times their regular rate of pay. Employee information follows: Employee Mary Arcompora Employee Number Marital Status Allowances 105 Barbara Fox Married 137 Married John French 135 Chris German Single 141 Married David Izbecki 139 Single Susan Tilbert 129 Married HODHAN Mary Arcompora, the store manager, NO. 141 is paid a salary of $300.00 per week plus NAME Chris German 1% of all rental sales. Barbara Fox and SOC. SEC. NO. 449-XX-XXXX WEEK ENDING October 24, 20-- John French, salespeople, are paid a salary DAY IN OUT IN OUT IN OUT TOTAL of $200.00 per week plus a 6% commis- M 8:05 12:03 1:00 5:05 sion on all rentals from the "Oldies but 8:00 12:05 1:10 5:00 W Goodies" section. Chris German and 9:05 12:05 1:15 6:05 Th 8:30 11:55 1:15 6:00 David Izbecki, office workers, are paid F 8:00 12:00 1:00 6:15 an hourly wage of $7.25. Susan Tilbert, a S stock person, is paid $7.40 per hour. TOTAL HOURS The payroll deductions include federal HOURS RATE AMOUNT income tax, social security tax of 6.2%, REGULAR Medicare tax of 1.45%, and state income OVERTIME tax of 1.8%. Chris German and Susan TOTAL EARNINGS Tilbert have $12.50 deducted each week for hospital insurance. During the week ending October 24, "Oldies but Goodies" rentals were $484.90 for Barbara Fox and $641.70 for John French. Total rental revenue for the week was $3,917.30. CONTINUEINSTRUCTIONS Prepare a payroll register in your working papers for the week ending October 24. NO. 139 NAME David Izbecki Complete time cards to the nearest quarter of an hour. SOC. SEC. NO. 461-XX-XXXX NO. 129 WEEK ENDING October 24, 20- NAME Susan Tilbert Use the federal income tax tables provided in the SOC. SEC. NO. 401-XX-XXXX DAY IN OUT IN OUT IN OUT WEEK ENDING October 24, 20- chapter. M 8:00 12:05 1:00 5:00 T 8:10 12:00 1:00 5:05 DAY IN OUT IN OUT IN OUT TOTAL W 1:30 5:00 M 8:05 12:00 Analyze 8:05 12:30 1:00 5:00 Compute the total net pay of all 10 Th 8:00 12:00 1:00 5:10 T 8:10 12:00 1:15 5:00 employees for the pay period. F 8:05 12:05 1:05 3:30 W 8:30 12:00 1:00 6:00 S Th 9:00 12:00 12:45 5:00 F 9:00 11:50 TOTAL HOURS S S HOURS RATE TOTAL HOURS REGULAR HOURS RATE AMOUNT OVERTIME TOTAL EARNINGS REGULAR OVERTIME aubuta sill SIGNATURE DATE TOTAL EARNINGS SIGNATURE DATE