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.

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter12: Intangibles
Section: Chapter Questions
Problem 2MC
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
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
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
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning