This is all one problem

ACC1010 Module 5 Discussion Proble eBook Calculator EXD9 04A Algo Instructions Payroll Register and Payroll Entry General Journal PR 08.09A Guided Ag Instructions 1. Prepare a payroll register for Mary's Luxury Travel for the week ended March 22, 20-. (In the Taxable Earnings/Unemployment ompensation column, enter the same amounts as in the Social Security column.) Total the amount columns. Round your answers to nearest cent. Assuming that the wages for the week ended March 22 were paid on March 24, prepare the journal entry for the payment of the ayroll. When required, enter amounts in dollars and cents. If an amount box does not require an entry, leave it blanlk ary Losch operates a travel agency called Mary's Luxury Travel. She has five employees, all of whom are paid on a weekly basis. The ravel agency uses a payroll register, individual employee earnings records, and a general journal ary's Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure 8-4 in the text. The payroll data for each ployee for the week ended March 22, 20-, are given below. Employees are paid 1% times the regular rate for working over 40 ours a week No. of Marital Total Hours Total Earnings Allowances Status Worked Mar. 16-22 Rate Jan. 1-Mar. 15 $5,540 5,760 4,940 5,129 4,734 Name Bacon, Andrea Cole, Andrew Hicks, Melvin Leung, Cara Melling, Melissa $12 12 10.5 40 IM 35 40 10.5 Social Security tax is withheld from the first $118,500 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45% nd city earnings tax at the rate of 196, both applied to gross pay. Bacon and Leung have $14 withheld and Cole and Hicks have $5 thheld and Hicks has $17.75 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 withheld for health insurance. Bacon and Leung have $22 withheld to be invested in the travel agency's credit union. Cole has 39.5 ith Check No. 423