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 |
||||||||||||||||||
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.)
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 | ||
Lily Company has the following data for the weekly payroll ending January 31. Hours Employee M...
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 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 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 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 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 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 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 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 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 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%...