College Accounting, Chapters 1-27
23rd Edition
ISBN: 9781337794756
Author: HEINTZ, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 8, Problem 10SPA
EMPLOYEE EARNINGS RECORD Mary’s Luxury Travel in Problem 8-9A keeps employee earnings records. 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.)
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Use the information below to complete the first quarter Employee Earnings Record for Linda
Morris. Linda is a sales manager and she is a salaried employee. Her social security number is
345-44-8577. The weekly pay period ended February 15, 2009.
Earnings
Deductions
United
Employee Employee Marital No. of Regular Overtime
Health
Way Insurance
No.
Name
Status
Allowances
Morris,
$789.0
121
S
1
Linda
0
Moyer,
$845.0
122
M
4
$36.00
$36.00
Elizabeth
0
Nethers,
$978.0
123
M
2
$78.00
$48.00
Porter
0
Russ,
124
S
0
$576.0
0
$28.00
George
EARNINGS RECORD FOR QUARTER ENDED
Employee No.
Marital
Withholding
Last Name
First
Social Security No.
Position
Rate of Pay
Pay Period
Earnings
Accumulated
Earnings
2,367.00
No Ended
Overtime Total
Medicare Other Total
Federal Social
Income Security
Tax
Tax
Regular
Status
Deductions
Deduction
$15.00
$25.00
Allowances
Net Pay
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
Bacon, Andrea
Cole, Andrew
Hicks, Melvin
Leung, Cara
Melling, Melissa
No. of
Allowances
4
1
3
1
2
Marital Total Hours
Status Worked Mar. 16-22
44
40
M
S
M
S
M
44
36
40
Earnings
Rate
$14.00
15.00
13.50
14.00
14.50
Total Earnings
Jan. 1-Mar. 15
$6,300.00
6,150.00
5,805.00
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…
Payroll Register and Payroll Journal Entry
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. 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…
Chapter 8 Solutions
College Accounting, Chapters 1-27
Ch. 8 - Prob. 1TFCh. 8 - Prob. 2TFCh. 8 - Prob. 3TFCh. 8 - Prob. 4TFCh. 8 - A payroll register is a multi-column form used to...Ch. 8 - Prob. 1MCCh. 8 - Prob. 2MCCh. 8 - Prob. 3MCCh. 8 - Prob. 4MCCh. 8 - Social Security Tax Payable and Medicare Tax...
Ch. 8 - Prob. 1CECh. 8 - Prob. 2CECh. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Identify the four factors that determine the...Ch. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - Prob. 10RQCh. 8 - Prob. 1SEACh. 8 - COMPUTING OVERTI ME RATE OF PAY AND GROSS WEEKLY...Ch. 8 - Prob. 3SEACh. 8 - CALCUL ATING SOCIAL SECURITY AND MEDICARE TAXES...Ch. 8 - Prob. 5SEACh. 8 - JOURNALIZING PAYROLL TRANSACTIONS On December 31,...Ch. 8 - PAYROLL JOURNAL ENTRY Journalize the following...Ch. 8 - Prob. 8SPACh. 8 - PAYROLL REGISTER AND PAYROLL JOURNAL ENTRY Mary...Ch. 8 - EMPLOYEE EARNINGS RECORD Marys Luxury Travel in...Ch. 8 - COMPUTING WEEKLY GROSS PAY Manuel Sotos regular...Ch. 8 - Prob. 2SEBCh. 8 - Prob. 3SEBCh. 8 - CALCULATING SOCIAL SECURITY AND MEDICARE TAXES...Ch. 8 - Prob. 5SEBCh. 8 - JOURNALIZING PAYROLL TRANSACTIONS On November 30,...Ch. 8 - PAYROLL JOURN AL ENTRY Journalize the following...Ch. 8 - Prob. 8SPBCh. 8 - Prob. 9SPBCh. 8 - Prob. 10SPBCh. 8 - Prob. 1MYWCh. 8 - Prob. 1ECCh. 8 - Prob. 1MPCh. 8 - Prob. 1CP
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Payroll Register and Payroll Journal Entry 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. 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…arrow_forwardPayroll Register and Payroll Journal Entry 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. 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…arrow_forwardPayroll Register and Payroll Journal Entry 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. Refer to Figure 8-4 in the text. The payroll data for each employee for the week ended March 22, 20—, are shown. 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 45 $12.00 $5,540.00 Cole, Andrew 1 S 40 12.00 5,860.00 Hicks, Melvin 3 M 44 10.50 4,960.00 Leung, Cara 1 S 35 11.00 5,144.50 Melling, Melissa 2 M 40 13.00 4,732.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…arrow_forward
- PAYROLL REGISTER AND PAYROLL JOURNAL ENTRY Mary Losch operates a travel agency called Mary'sLuxury 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 generaljournal . Mary's Luxury Travel uses a weekly federal income tax withholding table like the one in Figure 8-4 on pages 288 and 289.The payroll data for each employee for the week ended March 22,20-, are given below_ Employees are paid 1Y,times the regular rate for working over 40 hours a week. $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…arrow_forwardCompleting the Payroll Register The Employee Payroll Register presents all the computations previously performed as it applies to this payroll period. Complete the following steps (if a field should be blank, leave it blank): Record the amount to be withheld for group insurance. Record the amount to be withheld for health insurance. Each worker is to be paid by check. Assign check numbers provided to the correct employee. Compute the net pay for each employee. Total the input columns. KIPLEY COMPANY, INC.Payroll RegisterFor Period Ending January 8, 20-- EARNINGS DEDUCTIONS NET PAY Name Gross OASDI HI FIT SIT SUTA CIT SIMPLE Grp. Ins. Health Ins. Ck. No. Amount Carson, F. $700.00 $43.40 $10.15 $48.00 $21.49 $0.42 $21.00 $20.00 Wilson, W. 897.04 55.62 13.01 68.00 27.54 0.54 26.91 50.00 Utley, H. 678.75 42.08 9.84 14.00 20.84 0.41 20.36 40.00 Fife, L. 877.10 54.38 12.72 33.00 26.93 0.53 26.31 50.00 Smith, L. 790.00 48.98 11.46 59.00…arrow_forwardAccounting Scenario 1 Clara Tate an employee of Harrow's Accounting Firm, worked 44 hours during the week of June 8 through 12. Her rate of pay is $15 per hour and she receives time-and-a-half for work in excess of 40 hours per week. She is married and claims two allowances on her W-4 form. Her wages are subject to the following deductions: Federal income tax (use the table in the link below). Social Security tax at 6.2 percent. Medicare tax at 1.45 percent. Union dues, $30.00 What you must do: Compute Clara’s: regular pay overtime pay gross pay net pay Submission Format To help you calculate the amounts to be withheld for Clara, use the attached 2016 Withholding Table (Word.doc).arrow_forward
- 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…arrow_forwardEmployee 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…arrow_forwardayroll Register and Payroll Journal Entry 1. Prepare a payroll register for Mary’s Luxury Travel for the week ended March 22, 20--. (In the Taxable Earnings/Unemployment Compensation column, enter the same amounts as in the Social Security column.) Total the amount columns. Round your answers to the nearest cent. 2. Assuming that the wages for the week ended March 22 were paid on March 24, prepare the journal entry for the payment of the payroll. When required, enter amounts in dollars and cents. If an amount box does not require an entry, leave it blank. 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. Refer to Figure 8-4 in the text. The payroll data for each employee for the week ended March 22, 20—, are given below. Employees…arrow_forward
- A weekly time ticket for Joyce Caldwell follows: Labor Time Ticket Ticket Number: TT 338 Employee: Joyce Caldwell % Date Monday, 8/12 Tuesday, 8/13 Wednesday, 8/14 Thursday, 8/15 Friday, 8/16 View transaction list < 1 Time Started Journal entry worksheet 7:00 AM 7:00 AM 7:00 AM Transaction a 7:00 AM 12:00 PM 7:00 AM Note: Enter debits before credits. Record entry Dates: Monday 8/13 Record Joyce's wages to be paid at a later date. Required: Prepare a journal entry to record Joyce's wages. Note: If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field. 1 General Journal Clear entry Friday 8/17 Time Ended 11:00 AM 4:00 PM 3:00 PM Weekly Totals Hourly Labor Rate Total Wages Earned 3:00 PM 3:00 PM 3:00 PM Total Hours 8 hours 8 hours 8 hours Debit 4 hours 4 hours 8 hours 40 hours × $29 $ 1,160 Credit Job Number Job 271 Job 271 Job 272 Job 272 Maintenance Job 273 View general journalarrow_forwardThe payroll department is asked to make a payroll summary of the workers employed by A-Z Company. The two workers, Jane and Max work for the selling department and the rest for admin department . Jane also contributes $45 to Canada Bond Saving and has instructed the employer to deduct from her pay. Each worker contributes $25 for Union Dues and $55 for hospital insurance. Further information is given to the accountant. Weekly Pay Employees Hours worked Hourly rate $ John 52 28 Jane 43 35 Max 47 42 REQUIRED Calculate the following Gross salary of each worker Tax to be deducted if the rate is 18% Employment insurance for both employee and employer [1.87%] Canada pension for both employee and employer [4.95%] Make a schedule for the employees using the format. Journalize the pay roll information of employees only. Calculate the total contributions that the employer has to make on his employees in terms of CPP and EIarrow_forwardеВook General Journal Chart of Accounts Payroll Register Instructions Karen Jolly operates a bakery called Karen's Cupcakes. She has five employees, all of whom are paid on a weekly basis. Karen's Cupcakes uses a payroll register, individual employee earnings records, and a general journal. Karen's Cupcakes uses a weekly federal income tax withholding table like the one in Figure 8-4 in the text. The payroll data for each employee for the week ended February 15, 20-, are given below. Employees are paid 1% times the regular rate for working over 40 hours a week. No. of Marital Total Hours Total Earnings Name Allowances Status Worked Feb. 9-15 Rate Jan. 1-Feb. 8 S. 40 $14.00 $3,360.00 Barone, William 4 M. 45 15.00 3,870.00 Hastings, Gene 46 12.00 3,168.00 Nitobe, Isako Smith, Judy 21 42 13.00 3,276.00 39 14.50 3,480.00 Tarshis, Dolores 1 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
How JOURNAL ENTRIES Work (in Accounting); Author: Accounting Stuff;https://www.youtube.com/watch?v=Y-_Q3rANyxU;License: Standard Youtube License