Employee Earnings Record 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 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. Name No. ofAllowances MaritalStatus Total HoursWorked Mar. 16–22 Rate Total EarningsJan. 1–Mar. 15 Bacon, Andrea 4 M 44 $14.00 $6,300.00   Cole, Andrew 1 S 40 15.00 6,150.00   Hicks, Melvin 3 M 44 13.50 5,805.00   Leung, Cara 1 S 36 14.00 5,600.00   Melling, Melissa 2 M 40 14.50 5,945.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 $15 withheld and Cole and Hicks have $10 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 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 ending March 22, complete an employee earnings record for Andrew Cole please? (Insert earnings data only for the week of March 22.)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Employee Earnings Record

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 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.


Name
No. of
Allowances
Marital
Status
Total Hours
Worked Mar. 16–22

Rate
Total Earnings
Jan. 1–Mar. 15
Bacon, Andrea 4 M 44 $14.00 $6,300.00  
Cole, Andrew 1 S 40 15.00 6,150.00  
Hicks, Melvin 3 M 44 13.50 5,805.00  
Leung, Cara 1 S 36 14.00 5,600.00  
Melling, Melissa 2 M 40 14.50 5,945.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 $15 withheld and Cole and Hicks have $10 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 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 ending March 22, complete an employee earnings record for Andrew Cole please? (Insert earnings data only for the week of March 22.)

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education