Question

Lily Company has the following data for the weekly payroll ending January 31. Hours Employee M...

Lily Company has the following data for the weekly payroll ending January 31.

Hours

Employee

M

T

W

T

F

S

Hourly Rate

Federal Income Tax Withholding

Health Insurance

L. Helton 9 8 8 8 10 2 $12 $35 $11
R. Kenseth 7 9 8 7 7 4 14 37 26
D. Tavaras 9 11 9 9 9 0 15 58 25


Employees are paid 1.5 times the regular hourly rate for all hours worked in excess of 40 hours per week. FICA taxes are 7.65% on the first $127,200 of gross earnings. Lily Company is subject to 5.4% state unemployment taxes and 0.8% federal unemployment taxes on the first $7,000 of gross earnings.

a. Prepare the payroll register for the weekly payroll. (Round answers to 2 decimal places, e.g. 15.25.)

LILY COMPANY
Payroll Register
For the Week Ending January 31

Earnings

Deductions

Employee

Total Hours

Regular

Overtime

Gross Pay

FICA Taxes

Federal Income Taxes

Health Insurance

Total

Net Pay

L. Helton

$

$

$

$

$

$

$

$

R. Kenseth
D. Tavaras

Totals

$

$

$

$

$

$

$

$

b. Prepare the journal entries to record the payroll and Lily’s payroll tax expense. (Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to 2 decimal places, e.g. 15.25.)

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1
Lily Company
Payroll Register
For the Week ending Jan.31
Earnings Deductions Paid
Employee Total Hours Regular
(a)
(40 HourX Hourly rate)
Over-Time
(b)
Gross
(c=a+b)
FICA
(d=c*7.65%)
Federal I Tax Withholding
(e )
Health Insurance (f) Total
(g=d+e+f)
Net Pay
(c-g)
M Pinson 45 $480.00 $90.00 $570.00 $43.61 $35.00 $11.00 $89.61 $480.40
E. Tavaras 42 $560.00 $36.00 $596.00 $45.59 $37.00 $26.00 $108.59 $487.41
K. Helton 47 $600.00 $126.00 $726.00 $55.54 $58.00 $25.00 $138.54 $587.46
Total $1,640.00 $252.00 $1,892.00 $144.74 $130.00 $62.00 $336.74 $1,555.26
Journal Entry
Date Account Tittle Debit Credit
31-Jan Office Salaries $1,892.00
FICA $144.74
Fedearl Tax Withholding $130.00
Health Insurance $62.00
Office Salaries Payable A/c $1,555.26
31-Jan Payroll Tax Exp. $117.30
State Unemployment Tax
(1892*5.4%)
$102.17
Federal Unemployment Tax
(1892*0.8%)
$15.14
Add a comment
Know the answer?
Add Answer to:
Lily Company has the following data for the weekly payroll ending January 31. Hours Employee M...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • EI1.11 (LO 3) Ramirez Company has the following data for the weekly payroll ending January 31. Federal Income Tax Withholding $34 37 58 Health Insurance $10 25 25 Hours Hourly Employee L. Helton R...

    EI1.11 (LO 3) Ramirez Company has the following data for the weekly payroll ending January 31. Federal Income Tax Withholding $34 37 58 Health Insurance $10 25 25 Hours Hourly Employee L. Helton R. Kenseth 8 8 8 8 8 2 D. Tavaras 9 10 8 8 9 0 M T W TF S Rate 8 8 9 8 10 3 $12 14 15 Employees are paid 112 times the regular hourly rate for all hours worked in excess of...

  • PLEASE CORRECT PART (b). COLUMNS (total) and (Net Pay). PLEASE FIX THE HIGHLIGHTED IN [RED]. Lily...

    PLEASE CORRECT PART (b). COLUMNS (total) and (Net Pay). PLEASE FIX THE HIGHLIGHTED IN [RED]. Lily Company has the following data for the weekly payroll ending January 31. Hours Employee MTWTFS Hourly Rate Federal Income Tax Withholding Health Insurance L. Helton 9 8 8 8 10 2 $12 $35 $11 R. 7 9 8 7 7 4 Kenseth 14 37 26 D. 911 9990 15 Tavaras 58 25 Employees are paid 1.5 times the regular hourly rate for all hours...

  • VERSIONBACK Exercise 11-11 Ramirez Company has the following data for the weekly payroll ending January 31...

    VERSIONBACK Exercise 11-11 Ramirez Company has the following data for the weekly payroll ending January 31 Hourly Federal Income Health Employee M T w T F S Rate Tax LHeton 87981| 2 S12 IR,Kenseth 7 9 7 7 84 14 $11 25 uey D. Tavaras 908 95 57 Employees are paid 1.5 times the reguiar hourly rate for all hours worked in excess of 40 houns per week FICA taxes are 7.65% Ramirez Company is subject to S4% state nemployment...

  • For the year ended December 31, 2020, Lily Electrical Repair Company reports the following summary payroll...

    For the year ended December 31, 2020, Lily Electrical Repair Company reports the following summary payroll data. Gross earnings:     Administrative salaries $199,000     Electricians’ wages 375,000 Total $574,000 Deductions:     FICA taxes $38,951     Federal income taxes withheld 175,000     State income taxes withheld (3%) 17,220     United Fund contributions payable 28,700     Health insurance premiums 18,500 Total $278,371 Lily’s payroll taxes are Social Security tax 6.2%, Medicare tax 1.45%, state unemployment 2.5% (due to a stable employment record), and 0.8% federal unemployment. Gross earnings subject...

  • PRINTER VERSION BACK NEXT Problem 11-3A (Part Level Submission) Mann Hardware has four employees who are...

    PRINTER VERSION BACK NEXT Problem 11-3A (Part Level Submission) Mann Hardware has four employees who are paid on an hourly basis plus time-and-a-half for all hours worked in excess of 40 a week. Payroll data for the week ended March 15, 2017, are presented below. Employee Hours Worked Hourly Rate Federal Income Tax Withholdings United Fund Ben Abel 40 $15.00 $7 $5.00 Rita Hager 41 14.00 7 5.00 Jack Never 13.00 60.00 8.00 Sue Perez 46 13.00 61.00 5.00 Abel...

  • (5) The payroll records of a company provided the following data for the weekly pay period...

    (5) The payroll records of a company provided the following data for the weekly pay period ended December 7: Earnings to End of Previous Week S 54,000 40,500 45.000 Federal Income Taxes $216 Union Dues $15 Medical Insurance Deduction $125 125 150 United Way $15 Gross Pay $1,200 900 1.000 Employee Ronald Arthur John Baines Ted Carter 30 15 162 180 -0- The FICA social security tax rate is 6.2% and the FICA Medicare tax rate is 1.45% on all...

  • Problem 11-3A (Part Level Submission) Mann Hardware has four employees who are paid on an hourly...

    Problem 11-3A (Part Level Submission) Mann Hardware has four employees who are paid on an hourly basis plus time and a half for all hours worked in excess of 40 a week. Payroll data for the week ended March 15, 2017, are presented below. Employee Hours Worked United Fund Federal Income Tax withholdings $? 2 Ben Abel Rita Hager Jack Never Sue Perez Hourly Rate $15.00 14.00 13.00 13.00 40 41 44 46 $5.00 5.00 8.00 5.00 60.00 61.00 Abel...

  • Quiz Company is preparing the payroll report and wants to look at one particular employee. The...

    Quiz Company is preparing the payroll report and wants to look at one particular employee. The following data is available for a recent week: Hours Worked: 60 Hourly Pay Rate: $20.00 Federal Withholding: 25% FICA Withholding: 6.20% Medicare Withholding: 1.45% Illinois Withholding: 5% 401-K Deduction: 5% (employer matches) Federal and State Unemployment: 6% Required . Calculate the gross pay Calculate the net pay Calculate the total cost to the employer Calculate the % of total cost to gross pay for...

  • During the first week of January, an employee works 49 hours. For this company, workers earn...

    During the first week of January, an employee works 49 hours. For this company, workers earn 150% of their regular rate for hours in excess of 40 per week. Her pay rate is $20 per hour, and her wages are subject to no deductions other than FICA Social Security, FICA Medicare, and federal income taxes. The tax rate for Social Security is 6.2% of the first $118,500 earned each calendar year and the FICA tax rate for Medicare is 1.45%...

  • During the first week of January, an employee works 47 hours. For this company, workers earn...

    During the first week of January, an employee works 47 hours. For this company, workers earn 150% of their regular rate for hours in excess of 40 per week. Her pay rate is $15 per hour and her wages are subiect to no deductions other than FICA Social Security, FICA Medicare, and federal income taxes. The tax rate for Social Security is 6.2% of the first $128,400 earned each calendar year and the FICA tax rate for Medicare is 1.45%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT