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 DATESINGLE Persons-WEEKLY Payroll Period And the number of withholding allowances claimed is - If the wages are - 8 9 But less 1 2 4 5 6 7 10 At least than 0 he amount of income tax to be withheld is - 60 oooo ooOOO OOOOO 280NU ANEW OUNNO OOOOO OOOOO OOOOO OOOOO OOOO OOOOO 82868 ENONE NOONE FAWN 60... VONDA WNN-O OOO00 190 200 220 230 240 240 250 260 260 270 270 280 290 290 300 300 310 310 320 330 340 340 MARRIED Persons-WEEKLY Payroll Period And the number of withholding allowances claimed is - If the wages are - V 8 9 10 At least But less 2 A than 0 1 he amount of income tax to be withheld is - $125 135 135 140 140 145 145 150 150 155 155 160 165 170 185 ooooo ooooo ooooo ooooo ooooo ooo00 195 OUWNO OVOAW -0000 0OOOO OOOOO OOO0 GLENN NENDO NOONE OOOON VOMAA WN- -O NNNDO JOAN WOW WN-00 00000 0OOOO 230 240 250 260 260 270 280 280 290 290 ooooo ooo0. 330 340 Figure 12-4 Internal Revenue Service Tax Tables
