I really need some help with this. The first picture has the directions, the second picture is what I have done so far. can someone help me finish this chart?
P 8-9A Payroll Register and Payroll Journal Entry Rate (LO2/3/4) Mary Losch operates a travel agency called Mary's Luxury Travel. She has five employees, all of whom are paid on a weekly basis. The travel agency uses a payroll register, individual employee earnings records, and a general journal. Mary's Luxury Travel uses a weekly federal income tax withholding table like the one in Figure 8-4. The payroll data for each employee for the week ended March 22, 20-, are given below. Employees are paid 15 times the regular rate for working over 40 hours a week. Name No. of Allowances Marital Status Total Hours Worked Total Earnings Jan. 1- Mar. 16-22 Mar. 15 Bacon, Andrea $14.00 $6,300.00 Cole, Andrew 15.00 6,150.00 Hicks, Melvin 13.50 5,805.00 Leung, Cara 5,600.00 Melling, Melissa 5,945.00 Social Security tax is withheld from the first S128,400 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city carnings tx at the rate of 1%, both applied to gross pay. Bacon and Leung have $15 withheld and Cole and Hicks have to withheld for health insurance. Bacon and Leung have 20 withheld to be invested in the travel agency's credit union. Cole has $38.75 withheld and Hicks has $18.75 withheld under a suvings 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 1 3 S M S M 44 40 44 36 14.00 14.50 40 Exercise: P8-9A - Worksheet Taxable Earnings Deductions Earnings No of Man Allow us Regular overtime Total NET PAY NO Namo Curu lative To Unem ploymt . Sot Federal Socal Medica income Security Sec Taxe Tax CF Tax TID Health Ins OTHER TOTAL Bacon, Andrea 4 560 34 644 6944 644 644 10 39 380.34 G 44 20 100.71 534 20 423 15 Car Linion 10 Bords 000 000 6750 000 600 51 372 87 0.00 38.75 151.60 448.36 424 Cole, Andrew Hicks, Melvin 1 3 M 1 S Leupo. Cara Melling, Melissa 2