Mary's Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure 8-4 in the text. The payroll data for each empioyee for the week ended March 22,20 -, are given. Employees are paid 11/2 times the regular rate for working over 40 hours a week. 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 $15 withheld and Cole and Hicks have $7 withheld for health insurance. Bacon and Leung have $18 withheld to be invested in the travel agency's credit union. Cole has $38.75 withiheld and Hicks has $19.00 withheld under a savings bond purchase plan. Mary's Luxury Travel's payroil 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 Socisl 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 onily for the week of March 22.) Andrew Cole, employee number 62 , is employed as a manager in the tidket sales department. He was born on May 8 , 1986 , and was hired on June 1 of last year, His Social Secunty number is 544-67-1283, He lives of 28 Quamy Drive, Vemon, CT, 06066. Required: For the week ended March 22, complete an employee earnings rocord for Andrew Cole. (Insert earnings data only for the week of March 22.) rtment. He was born on May 8,1986 , and was hired on June 1 eernon, CT, 06066. (Insert earnings data only for the week of March 22.) Mary's Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure 8-4 in the text. The payroll data for each empioyee for the week ended March 22,20 -, are given. Employees are paid 11/2 times the regular rate for working over 40 hours a week. 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 $15 withheld and Cole and Hicks have $7 withheld for health insurance. Bacon and Leung have $18 withheld to be invested in the travel agency's credit union. Cole has $38.75 withiheld and Hicks has $19.00 withheld under a savings bond purchase plan. Mary's Luxury Travel's payroil 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 Socisl 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 onily for the week of March 22.) Andrew Cole, employee number 62 , is employed as a manager in the tidket sales department. He was born on May 8 , 1986 , and was hired on June 1 of last year, His Social Secunty number is 544-67-1283, He lives of 28 Quamy Drive, Vemon, CT, 06066. Required: For the week ended March 22, complete an employee earnings rocord for Andrew Cole. (Insert earnings data only for the week of March 22.) rtment. He was born on May 8,1986 , and was hired on June 1 eernon, CT, 06066. (Insert earnings data only for the week of March 22.)