I would like help with Problem 12-8 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 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.SINGLE 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
