Ch E HW 3 Employee Earnings Record eBook 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. No. of Marital Name Total Hours Allowances Status Worked Mar. 16-22 Total Earnings Rate 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 Melling, Melissa 2 M 40 14.00 14.50 5,600.00 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 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 March 22 20-- 20 -- Period Ended Regular Overtime Total Cumulative Total Unemploy. Comp. Social Security Federal Income Tax Social Security Tax Medicare Tax City Tax Health Insurance Other Total Ck. No. Amount 3/8 3/15 3/22 600 0 ✓ 600 X × 37.20 ✓ 8.70 6 ✓ 10 ✔ Savings bond 38.75 X 424 ✓ x 3/29 Gender Department Check My Work 0 more Check My Work uses remaining. Occupation Social Security No. Marital Status Allowances Pay Rate Date of Birth Date Hired Name/Address Emp. No. Previous

Financial & Managerial Accounting
13th Edition
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter10: Current Liabilities And Payroll
Section: Chapter Questions
Problem 10.4APR: Payroll register The following data for Throwback Industries Inc. relate to the payroll for the week...
icon
Related questions
Question
Ch E HW 3
Employee Earnings Record
eBook
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.
No. of Marital
Name
Total Hours
Allowances Status Worked Mar. 16-22
Total Earnings
Rate
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
Melling, Melissa
2
M
40
14.00
14.50
5,600.00
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 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
March 22
20--
20 --
Period
Ended
Regular
Overtime
Total
Cumulative
Total
Unemploy.
Comp.
Social
Security
Federal
Income Tax
Social
Security Tax
Medicare
Tax
City Tax
Health
Insurance
Other
Total
Ck. No.
Amount
3/8
3/15
3/22
600
0
✓
600
X
×
37.20 ✓
8.70
6 ✓
10
✔ Savings bond
38.75
X
424 ✓
x
3/29
Gender
Department
Check My Work 0 more Check My Work uses remaining.
Occupation
Social Security No.
Marital Status
Allowances
Pay Rate
Date of Birth
Date Hired
Name/Address
Emp. No.
Previous
Transcribed Image Text:Ch E HW 3 Employee Earnings Record eBook 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. No. of Marital Name Total Hours Allowances Status Worked Mar. 16-22 Total Earnings Rate 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 Melling, Melissa 2 M 40 14.00 14.50 5,600.00 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 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 March 22 20-- 20 -- Period Ended Regular Overtime Total Cumulative Total Unemploy. Comp. Social Security Federal Income Tax Social Security Tax Medicare Tax City Tax Health Insurance Other Total Ck. No. Amount 3/8 3/15 3/22 600 0 ✓ 600 X × 37.20 ✓ 8.70 6 ✓ 10 ✔ Savings bond 38.75 X 424 ✓ x 3/29 Gender Department Check My Work 0 more Check My Work uses remaining. Occupation Social Security No. Marital Status Allowances Pay Rate Date of Birth Date Hired Name/Address Emp. No. Previous
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
Recommended textbooks for you
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning