omplete the FWT column (wage-bracket method) and SWT column of the payroll register using the employee data listed below. The associated pay period ends on 09/05/2021 (enter the year using four digits), with paychecks being printed and distributed six days later. Every employee earns hourly overtime wages 1.5 times greater than their regular wage rate. Enter all employees' names in the format Last Name, First Initial (for example: Rick Smith would be written as Smith, R). The state income tax withholding rate is 5.0% of taxable pay, with taxable pay being the same for federal and state income tax withholding. Note that the Voluntary Withholding column, for which partial information is provided below, has been populated based on the partial information shown here. Luisa Williams earns $7.50/hour, and worked 44 hours during the most recent week. She makes a 401(k) retirement plan contribution of 14% of gross pay each period. Luisa Williams is single, and claims one withholding allowance for both federal and state. Jonathan Olsen earns $9.10/hour, and worked 47 hours during the most recent week. He participates in a cafeteria plan, to which he pays $100 each period. Jonathan Olsen is single, claims two federal withholding allowances, and one state withholding allowance. Nathan Upton earns $11.80/hour, and worked 42 hours during the most recent week. He does not make any voluntary deductions each period. Nathan Upton is married, and claims three withholding allowances for both federal and state. Juan Rodriguez earns $14.00/hour, and worked 48 hours during the most recent week. He makes a 403(b) retirement plan contribution of 13% of gross pay each period. Juan Rodriguez is single, and claims one withholding allowance for both federal and state. Drew Painter earns $16.60/hour, and worked 51 hours during the most recent week. He participates in a flexible spending account, to which he contributes $50 each period. Drew Painter is married, claims five federal withholding allowances and four state withholding allowances. Notes: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter12: Current Liabilities
Section: Chapter Questions
Problem 11EA: Use information from EA10. Compute the interest expense due when Barkers honors the note. Show the...
icon
Related questions
Question

Complete the FWT column (wage-bracket method) and SWT column of the payroll register using the employee data listed below. The associated pay period ends on 09/05/2021 (enter the year using four digits), with paychecks being printed and distributed six days later. Every employee earns hourly overtime wages 1.5 times greater than their regular wage rate. Enter all employees' names in the format Last Name, First Initial (for example: Rick Smith would be written as Smith, R). The state income tax withholding rate is 5.0% of taxable pay, with taxable pay being the same for federal and state income tax withholding. Note that the Voluntary Withholding column, for which partial information is provided below, has been populated based on the partial information shown here.

  1. Luisa Williams earns $7.50/hour, and worked 44 hours during the most recent week. She makes a 401(k) retirement plan contribution of 14% of gross pay each period. Luisa Williams is single, and claims one withholding allowance for both federal and state.
  2. Jonathan Olsen earns $9.10/hour, and worked 47 hours during the most recent week. He participates in a cafeteria plan, to which he pays $100 each period. Jonathan Olsen is single, claims two federal withholding allowances, and one state withholding allowance.
  3. Nathan Upton earns $11.80/hour, and worked 42 hours during the most recent week. He does not make any voluntary deductions each period. Nathan Upton is married, and claims three withholding allowances for both federal and state.
  4. Juan Rodriguez earns $14.00/hour, and worked 48 hours during the most recent week. He makes a 403(b) retirement plan contribution of 13% of gross pay each period. Juan Rodriguez is single, and claims one withholding allowance for both federal and state.
  5. Drew Painter earns $16.60/hour, and worked 51 hours during the most recent week. He participates in a flexible spending account, to which he contributes $50 each period. Drew Painter is married, claims five federal withholding allowances and four state withholding allowances.

Notes:

  • For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.
Pay Period
Pay Date
Employee
09/05/2021
09/11/2021
Earnings
Regular Regular Regular Overtime Overtime Overtime
Hours
Rate
Earnings
Hours
Rate
$300.00 4
$7.50
$9.10
$364.00
7
2
$11.80 $472.00
$14.00 $560.00
$16.60 $664.00
8
11
$
$
$
$
$2,360.00
Name
Williams, L
Olsen, J
Upton, N
40
40
40
Rodriguez, J 40
Painter, D
40
Totals:
Payroll Register
Total
FWT
Earnings Earnings
$45.00
$345.00 $
$95.55
$459.55
$35.40
$507.40
$168.00
$728.00
$273.90 $937.90
$
$
$
$617.85
$11.25
$13.65
$17.70
$21.00
$24.90
$
$
$2,977.85
GA
$
$
GA
FA
$
$
$
$
$
A LA
$
$
$
SWT
$
GA
$
$
EA
$
$
$
$
$
Deductions
Social
Security
Medicare Vol. With.
$
$48.30
$100.00
$94.64
$50.00
$
$
$292.94
$
$
$
FA
Check
Number
$
$
SA
$
$
$
$
SA
Net Pay
Transcribed Image Text:Pay Period Pay Date Employee 09/05/2021 09/11/2021 Earnings Regular Regular Regular Overtime Overtime Overtime Hours Rate Earnings Hours Rate $300.00 4 $7.50 $9.10 $364.00 7 2 $11.80 $472.00 $14.00 $560.00 $16.60 $664.00 8 11 $ $ $ $ $2,360.00 Name Williams, L Olsen, J Upton, N 40 40 40 Rodriguez, J 40 Painter, D 40 Totals: Payroll Register Total FWT Earnings Earnings $45.00 $345.00 $ $95.55 $459.55 $35.40 $507.40 $168.00 $728.00 $273.90 $937.90 $ $ $ $617.85 $11.25 $13.65 $17.70 $21.00 $24.90 $ $ $2,977.85 GA $ $ GA FA $ $ $ $ $ A LA $ $ $ SWT $ GA $ $ EA $ $ $ $ $ Deductions Social Security Medicare Vol. With. $ $48.30 $100.00 $94.64 $50.00 $ $ $292.94 $ $ $ FA Check Number $ $ SA $ $ $ $ SA Net Pay
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Payroll register
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College