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.

  please also do show work how you got the answer

  thanks

Pay Period Pay Date Employee Name Williams, L Olsen, J Upton, N Rodriguez, J Painter, D. Totals: 09/05/2021 09/11/2021 Earnings Regular Regular Regular Overtime Overtime Overtime Hours Rate Earnings Hours Rate Eamings $300.00 4 $7.50 $9.10 $364.00 7 $11.80 S472.00 2 8 $14.00 $16.60 $560.00 $664.00 11 S S S S $2,360.00 40 40 40 40 40 $11.25 $13.65 $17.70 $21.00 $24.90 S S Payroll Register FWT SWT Total Earnings $345.00 $15.00 $14.84 $ $459.55 $507.40 $728.00 $12.00 $17.98 $ $3.00 $25.37S $53.00 $31.67 $ $937.90 $25.00 $44.40 $ $ $ $ $ $ $ $ $ $2,977.85 $108.00 $134.26 $ $45.00 $95.55 $35.40 $168.00 $273.90 $ $ $617.85 Deductions Social Security Medicare Vol. With. S $48.30 $ $100.00 $ - $ $94.64 S $50.00 $ $ $292.94 S $ $ Check Number $ $ $ $ $ $ $ $ Net Pay