Book PrintItem Employee Earnings Record Mary's Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure B-4 in the text. The payroll data for each employee for the week ended March 22, 20-, are given. Employees are paid 1 times the regular rate for working over 40 hours a week. No. of Marital Total Hours Total Earnings Allowances Status Worked Mar. 16-22 Rate Jan. 1-Mar. 15 Name Bacon, Andrea 4 M 45 $12.00 $5,520.00 Cole, Andrew 1 S 40 12.00 5,800.00. Hicks, Melvin 3 M 44 10.50 5,000.00 Leung, Cara 1 S 35 11.00 5,054.00 Melling, Melissa 2 M 40 13.00 4,746.00 Social Security tax is withheld from the first $128,400 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city earnings tax at the rate of 1%, both applied to gross pay. Bacon and Leung have $13 withheld and Cole and Hicks have $7 withheld for health insurance. Bacon and Leung have $20 withheld to be invested in the travel agency's credit union. Cole has $38.50 withheld and Hicks has $19.25 withheld under a savings bond purchase plan. Mary's Luxury Travel's payroll is met by drawing checks on its regular bank account. The checks were issued in sequence, beginning with Check No. 423. Andrew Cole, employee number 62, is employed as a manager in the ticket sales department. He was born on May 8, 1986, and was hired on June 1 of last year. His Social Security number is 544-67-1283. He lives at 28 Quarry Drive, Vernon, CT, 06066. Required: For the week ended March 22, complete an employee earnings record for Andrew Cole. (Insert earnings data only for the week of March 22.) Employee Earnings Record for Period Ended Earnings Taxable Earnings Deductions 20- Period Ended Regular Overtime Total Cumulative Unemploy. Social Total Comp. Security Federal Income Tax Social Security Tax Medicare Tax City Tax Health Insurance 3/8 lane Check My Work Previous All work saved. Email Instructor Save and Exit Submit Assignment for Grading ng, Melissa 2 Print Item M 40 13.00 4,746.00 al Security tax is withheld from the first $128,400 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city earnings tax of 1%, both applied to gross pay. Bacon and Leung have $13 withheld and Cole and Hicks have $7 withheld for health insurance. Bacon and Leung ham held to be invested in the travel agency's credit union. Cole has $38.50 withheld and Hicks has $19.25 withheld under a savings bond purchase plan. y's Luxury Travel's payroll is met by drawing checks on its regular bank account. The checks were issued in sequence, beginning with Check No. 423. drew Cole, employee number 62, is employed as a manager in the ticket sales department. He was born on May 8, 1986, and was hired on June 1 of las Social Security number is 544-67-1283. He lives at 28 Quarry Drive, Vernon, CT, 06066. equired: or the week ended March 22, complete an employee earnings record for Andrew Cole. (Insert earnings data only for the week of March 22.) Employee Earnings Record for Period Ended Earnings Taxable Earnings Deductio 20- Period Ended Regular Overtime Total Cumulative Unemploy.. Social Total Comp. Security Federal Income Tax Social Security Tax Medicare Tax City Tax Healt Insuran 3/8 3/15 3/22 3/29 Marital Gender Department M Ticket Sales Occupation Manager Social Security No. Status Allowances Pay Rate Date of Birth Date Hire 544-67-1283 S 1 $12.00 5/8/86 6/1/- Check My Work All work saved. Previous Email Instructor Save and Exit Submit Assignment for Gradim Book Print Item 4,746,00 of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city earnings tax at the Cole and Hicks have $7 withheld for health insurance. Bacon and Leung have $20 thheld and Hicks has $19.25 withheld under a savings bond purchase plan. count. The checks were issued in sequence, beginning with Check No. 423. ales department. He was born on May 8, 1986, and was hired on June 1 of last year. on, CT, 06066. drew Cole. (Insert earnings data only for the week of March 22.) ord for Period Ended Je Earnings March 221 Deductions 20- y.. Social Security Federal Income Tax Social Tax Security Medicare Tax City Tax Health Insurance Other Total Ck. No, Amount Marital Security No. Status Allowances Pay Rate 44-67-12831 Check My Work S Date of Birth Date Hired $12.00 5/8/86 6/1/-- Andrew Cole 28 Quarry Drive, Vernon, CT, 06066 Name/Address Emp. No. 62 Previous