I would like help with Problem 12-8 Preparing a Payroll please, any help is appreciated!
PROBLEM 12-8 Preparing the Payroll Outback Guide Service has six employees and pays each week. Hourly employees are paid overtime for all hours worked over 40 in a week. The overtime rate is 11/2 times the regular rate of pay. Outback pays its employees by hourly rate, salary, or salary plus a 5% commission on total amount of sales. Method of Computing Earnings Employee Hourly Wage Salary Plus Salary Cummings, Carol Commission Dame, Ted $270.00 $7.60 Lengyel, Tom Robinson, Jean $ 160.00 plus 5% Usdavin, James $7.40 $140.00 plus 5% Wong, Kim $140.00 plus 5% Employee deductions include federal income taxes (use the tables on page 320), FICA taxes at 6.2% for social security and 1.45% for Medicare, state income taxes of 1.5%, and hospital insurance premiums of $5.43 for single employees and $9.37 for married employees. Also, Kim Wong and Tom Lengyel have $10.00 withheld each week to purchase U.S. savings bonds. During the pay period ending October 17, the sales were: Tom Lengyel $1,204.76, Jean Robinson $1,925.80, and Kim Wong $2, 135.65. The hourly employees filled in the following time cards. NO. 73 NAME Ted Dame SOC. SEC. NO. 093-XX-XXXX NO. 92 WEEK ENDING 10/17/20-- NAME James Usdavin SOC. SEC. NO. 087-XX-XXXX DAY IN OUT IN OUT IN OUT WEEK ENDING 10/17/20-- 8:58 12:03 12:55 5:09 OUT IN OUT TOTAL 8:55 11:55 1:00 4:00 DAY IN OUT IN W 9:30 12:10 1:04 3:30 M 8:55 12:06 1:01 5:40 Th T 7:58 11:01 12:03 6:38 8:57 12:03 12:59 6:00 F 8:58 12:00 1:00 W 9:03 1:10 2:00 6:00 6:05 9:00 12:00 Th 7:59 11:55 1:10 4:51 F 9:01 12:06 1:05 3:47 S 9:00 12:03 TOTAL HOURS S HOURS RATE TOTAL HOURS REGULAR HOURS RATE AMOUNT OVERTIME REGULAR TOTAL EARNINGS OVERTIME SIGNATURE TOTAL EARNINGS DATE DATE SIGNATUREINSTRUCTIONS On the forms in your working papers: 1. Complete the time cards to the nearest quarter hour. 2. Prepare a payroll register for the week ending October 17. The date of payment is also October 17. Each employee's number, marital status, and number of allowances claimed are listed on her or his employee's earnings record. 3. Prepare a payroll check and stub for each employee. 4. Record the payroll information for each employee on her or his employee's earnings record