22 MASTERY PROBLEM Abigail Teenkamp owns and operates the Trenkamp Collection Agency. Listed below are the name, number of allowances claimed, marital status, information from time cards on hours worked each day, and the hourly rate of each employee. All houts worked in excess of 40 hours for Monday through Friday are paid at 14 times the regular rate. All weekend hours are paid at double the regular rate. Trenkamp uses a weekly federal income tax withholding table (see Figure 8-4 on pages 288 and 289). Social Security tax is withheld at the rate of 6.2% for the first $128,400 earned. Medicare tax is withheld at 1.45% and state income tax at 3,5%. Each employee has 512 withheld for health insurance. All employees use payroll deduction to the credit union for varying amounts as listed. - Name Berling, James Mera, Linda Goet, Ken Menick, Judd Morales, Eva Heimbrock, Jacob Townsley, Sarah Salaman, Beth Layton, Esther Thompson, David Vadillo, Carmen Trenkamp Collection Agency Payroll Information for the Week Ended November 18, 20- Employee No of Marital Hours Worked No, Allow, Hourly States 5 SMTWTF Rate M 2 2 9 8 8 9 10 $12 4 M 0 0 8 8 8 8 10 15 M 0 0 6 7 8 9 10 13 S 88008 9 13 M 0 0 13 M OO 42 M 40 12 M 62 M 00 88 LO M 0 2 10 9 14 11 S 80488 13 Credit Union Deposit $149.60 117.00 91.30 126.30 112.05 15423 83.05 130,00 88.00 229.90 139.11 Total Earnings 1/1-11/11 5 24.52 30,480 23.400 26,325 24.730 127,440 21 425 6.IS 5,635 25 8 10 24.115 The Trenkamp Collection Agency follows the practice of drawing a single check for the net amount of the payroll and depositing the check in a special payroll account at the bank. Individual checks issued were sumbered consecutively, beginning with No. 331. REQUIRED 1. Prepare a payroll register for Teenkamp Collection Agency for the week ended November 18, 20- (In the Table Earning Unemployment Compensation column, enter 5365 for Salman and S440 for Layton. Leave this column blank for all other employees) Total the amount columns verify the totals, and rale with single and double line 2. Assuming that the wages for the week ended November 18 were paid on November 21. prepare the journal entry for the payment of this payroll The current employee camnings record for Beth Salzman is provided in the work ing paper. Update Salaman's earnings record to reflect the November 18 payroll Although this informaron should have been entered earlier, complete the required information on the eamings record. The necessary information is as follows: Name Beth Salman Address 12 Windmill Lane rumbull, CT 0611 Employee No. Gender Female Department Administraron Occupation Cice Assistant Social Security No. 446-46-6921 Marital Status Named Allowances Pay Rate S11.00 per hour Date of Birth ASUS4 Date Hired 2 22 MASTERY PROBLEM Abigail Teenkamp owns and operates the Trenkamp Collection Agency. Listed below are the name, number of allowances claimed, marital status, information from time cards on hours worked each day, and the hourly rate of each employee. All houts worked in excess of 40 hours for Monday through Friday are paid at 14 times the regular rate. All weekend hours are paid at double the regular rate. Trenkamp uses a weekly federal income tax withholding table (see Figure 8-4 on pages 288 and 289). Social Security tax is withheld at the rate of 6.2% for the first $128,400 earned. Medicare tax is withheld at 1.45% and state income tax at 3,5%. Each employee has 512 withheld for health insurance. All employees use payroll deduction to the credit union for varying amounts as listed. - Name Berling, James Mera, Linda Goet, Ken Menick, Judd Morales, Eva Heimbrock, Jacob Townsley, Sarah Salaman, Beth Layton, Esther Thompson, David Vadillo, Carmen Trenkamp Collection Agency Payroll Information for the Week Ended November 18, 20- Employee No of Marital Hours Worked No, Allow, Hourly States 5 SMTWTF Rate M 2 2 9 8 8 9 10 $12 4 M 0 0 8 8 8 8 10 15 M 0 0 6 7 8 9 10 13 S 88008 9 13 M 0 0 13 M OO 42 M 40 12 M 62 M 00 88 LO M 0 2 10 9 14 11 S 80488 13 Credit Union Deposit $149.60 117.00 91.30 126.30 112.05 15423 83.05 130,00 88.00 229.90 139.11 Total Earnings 1/1-11/11 5 24.52 30,480 23.400 26,325 24.730 127,440 21 425 6.IS 5,635 25 8 10 24.115 The Trenkamp Collection Agency follows the practice of drawing a single check for the net amount of the payroll and depositing the check in a special payroll account at the bank. Individual checks issued were sumbered consecutively, beginning with No. 331. REQUIRED 1. Prepare a payroll register for Teenkamp Collection Agency for the week ended November 18, 20- (In the Table Earning Unemployment Compensation column, enter 5365 for Salman and S440 for Layton. Leave this column blank for all other employees) Total the amount columns verify the totals, and rale with single and double line 2. Assuming that the wages for the week ended November 18 were paid on November 21. prepare the journal entry for the payment of this payroll The current employee camnings record for Beth Salzman is provided in the work ing paper. Update Salaman's earnings record to reflect the November 18 payroll Although this informaron should have been entered earlier, complete the required information on the eamings record. The necessary information is as follows: Name Beth Salman Address 12 Windmill Lane rumbull, CT 0611 Employee No. Gender Female Department Administraron Occupation Cice Assistant Social Security No. 446-46-6921 Marital Status Named Allowances Pay Rate S11.00 per hour Date of Birth ASUS4 Date Hired 2