PSc 3-8 Populate a Payroll Register

Complete the FWT (wage-bracket method) and SWT columns of the payroll register using the employee data listed below. The associated pay period ends on 8/09/2019, 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. Shelley Brothers earns $9.25/hour, and worked 46 hours during the most recent week. She makes a 401(k) retirement plan contribution of 8% of gross pay each period. Shelley Brothers is married, and claims two withholding allowances for both federal and state.
2. Don Beldon earns $7.50/hour, and worked 43 hours during the most recent week. He participates in a cafeteria plan, to which he pays $100 each period. Don Beldon is single, and claims three federal and two state withholding allowances.
3. Alex Donaldson earns $21.75/hour, and worked 49 hours during the most recent week. He does not make any voluntary deductions per period. Alex Donaldson is single, and claims one withholding allowance for both federal and state.
4. Jason Kindler earns $11/hour, and worked 45 hours during the most recent week. He makes a 403(b) retirement plan contribution of 13% of gross pay. Jason Kindler is married, and claims three withholding allowances for both federal and state.
5. Sam Wilder earns $19.35/hour, and worked 53 hours during the most recent week. She participates in a flexible spending account, to which she contributes $50 each period. Sam Wilder is married, and claims four federal and three 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

Payroll Register

Pay Period

Pay Date

EarningsDeductionsEmployee

NameRegular HoursRegular RateRegular EarningsOvertime HoursOvertime

RateOvertime EarningsTotal

EarningsFWTSWTSocial SecurityMedicareVol. With.Check NumberNet Pay

Totals: