Transcribed Image Text: PSb 3-10 Populate a Payroll Register Complete the FWT column (wage-bracket method) and SWT column of the payroll register using the employee data listed below. The associated

Transcribed Image Text: PSb 3-10 Populate a Payroll Register
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 07/19/2020 (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. Jimmy Troffa earns $7.80/hour, and worked 41 hours during the most recent week. He makes a 401(k) retirement plan contribution of 9.0% of gross pay each period. Jimmy Troffa is married, and claims 3
withholding allowances for both the federal and state.
2. Tyler Thomas earns $10.90/hour, and worked 45 hours during the most recent week. He participates in a cafeteria plan, to which he pays $75 each period. Tyler Thomas is single, claims 3 federal withholding
allowances, and 2 state withholding allowances.
3. Ryan Brown earns $14.60/hour, and worked 48 hours during the most recent week. He does not make any voluntary deductions each period. Ryan Brown is single, and claims 2 withholding allowances for
both federal and state.
4. Michael Kaminski earns $16.00/hour, and worked 55 hours during the most recent week. He makes a 403(b) retirement plan contribution of 10% of gross pay each period. Michael Kaminski is single, and
claims 3 withholding allowance for both federal and state.
5. Tina Baldwin earns $17.10/hour, and worked 50 hours during the most recent week. She contributes $110 to a flexible spending account each period. Tina Baldwin is married, claims 4 federal withholding
allowances, and 3 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.
Open Directions in Popup Window
Send Email with Screen Capture
Payroll Register
07/19/2020
Pay Period
Pay Date
07/25/2020
Earnings
Deductions
Employee
Regular Regular
Regular
Overtime
Overtime
Overtime
Total
FWT
SWT
Social
Medicare
Vol. With.
Check
Net Pay
Name
Hours
Rate
Earnings
Hours
Rate
Earnings
Earnings
Security
Number
Troffa, J
40
$7.80
$312.00
1
$11.70
$11.70
$323.70
$
$
$
2$
$29.13
2$
Thomas, T
40
$10.90
$436.00
5
$16.35
$81.75
$517.75
$
2$
2$
$
$75.00
$
Brown, R
40
$14.60
$584.00
8
$21.90
$175.20
$759.20
$
2$
2$
2$
2$
Kaminski, M
40
$16.00
$640.00
15
$24.00
$360.00
$1,000.00
2$
$
2$
2$
$100.00
2$
Baldwin, T
40
$17.10
$684.00
10
$25.65
$256.50
$940.50
$
$
$
$
$110.00
2$
$
2$
$
$
2$
$
$
2$
2$
$
2$
2$
2$
$
$
$
$
$
$
$
2$
Totals:
$2,656.00
$885.15
$3,541.15
2$
$
$
2$
$314.13
2$

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer