Unformatted Attachment Preview
Complete the Payroll Register for the 2/12 and 2/26 biweekly pay periods. Use the Wage Bracket Method
Tables for Income Tax Withholding in Appendix C.
Employee
Number
A-Mille
Name and Address
Thomas Millen
1022 Forest School Rd
Woodstock, VT 05001
802-478-5055
SSN: 031-11-3456
401(k) deduction: 3%
Payroll information
Hire Date: 2-1-2016
DOB: 12-16-1982
Position: Production Manager
PT/FT: FT, nonexempt
No. of Exemptions: 4
M/S: M
Pay Rate: $35,000/year
A-Towle
Avery Towle
4011 Route 100
Plymouth, VT 05102
802-967-5873
SSN: 089-74-0974
401(k) deduction: 5%
Hire Date: 2-1-2016
DOB: 7-14-1991
Position: Production Worker
PT/FT: FT, nonexempt
No. of Exemptions: 1
M/S: S
Pay Rate: $12.00/hour
A-Long
Charlie Long
242 Benedict Road
S. Woodstock, VT 05002
802-429-3846
SSN: 056-23-4593
401(k) deduction: 2%
Hire Date: 2-1-2016
DOB: 3-16-1987
Position: Production Worker
PT/FT: FT, nonexempt
No. of Exemptions: 2
M/S: M
Pay Rate: $12.50/hour
B-Shang
Mary Shangraw
1901 Main Street #2
Hire Date: 2-1-2016
DOB: 8-20-1994
Position: Administrative
Assistant
PT/FT: PT, nonexempt
No. of Exemptions: 1
M/S: S
Pay Rate: $10.50/hour
Bridgewater, VT 05520
802-575-5423
SSN: 075-28-8945
401(k) deduction: 3%
B-Lewis
Kristen Lewis
840 Daily Hollow Road
Bridgewater, VT 05523
802-390-5572
SSN: 076-39-5673
401(k) deduction: 4%
Hire Date: 2-1-2016
DOB: 4-6-1950
Position: Office Manager
PT/FT: FT, exempt
No. of Exemptions: 3
M/S: M
Pay Rate: $32,000/year
B-Schwa
Joel Schwartz
55 Maple Farm Way
Woodstock, VT 05534
802-463-9985
SSN: 021-34-9876
401(k) deduction: 5%
Hire Date: 2-1-2016
DOB: 5-23-1985
Position: Sales
PT/FT: FT, exempt
No. of Exemptions: 2
M/S: M
Pay Rate: $24,000/year base
plus
3% commission per case sold
B-Prevo
Toni Prevosti
10520 Cox Hill Road
Bridgewater, VT 05521
802-673-2636
SSN: 055-22-0443
401(k) deduction: 6%
Hire Date: 2-1-2016
DOB: 9-18-1967
Position: Owner/President
PT/FT: FT, exempt
No. of Exemptions: 5
M/S: M
Pay Rate: $45,000/year
Student
Success
Student F. Success
1644 Smitten Rd
Woodstock/VT/05001
555-555-5555
SSN: 555-55-5555
Hire Date: 2-1-2016
DOB: 1-1-1991
Position:
PT/FT: PT, nonexempt
No. of Exemptions: 2
M/S: S
Pay Rate: $34,000/year
The departments are as follows:
Department A: Agricultural Workers
Department B: Office Workers
Employee overtime hours are listed in tabs PRF Feb 12 and PRF Feb 26.
Voluntary deductions for each employee are as follows:
Name
Thomas Millen
Deduction
Insurance: $155/paycheck
401(k): 3% of gross pay
Marital Status: Married
Avery Towle
Insurance: $100/paycheck
401(k): 5% of gross pay
Marital Status: Single
Charlie Long
Insurance: $155/paycheck
401(k): 2% of gross pay
Marital Status: Married
Mary Shangraw
Insurance: $100/paycheck
401(k): 3% of gross pay
Marital Status: Single
Kristen Lewis
Insurance: $155/paycheck
401(k): 4% of gross pay
Marital Status: Married
Joel Schwartz
Insurance: $100/paycheck
401(k): 5% of gross pay
Marital Status: Married
Toni Prevosti
Insurance: $155/paycheck
401(k): 6% of gross pay
Marital Status: Married
Student F SuccessInsurance: $100/paycheck
401(k): 2% of gross pay
Marital Status: Single
Required:
1. February 12 is the end of the first pay period for Prevosti Farms and Sugarhouse and includes work
completed during the week of February 8-12. Using the payroll register, compute the employee gross pay
and net pay using 35 hours as the standard workweek for all employees except Mary Shangraw, who works
20 hours per week and receives overtime for any time worked past that point. All employee hours have
been given to you on the payroll register. Joel Schwartz has made $5,000 in case sales at a 3% commission
rate during this pay period. Remember that the employees are paid biweekly. The first day of work for
Prevosti Farms and Sugarhouse for all employees is February 8, 2016. Note that the first pay period
comprises only one week of work, but the pay frequency for federal income tax purposes is biweekly.
Federal withholding tax should be computed using the wage-bracket tables in Appendix C. State witholding
tax for Vermont is computed at 3.55% of taxable wages (i.e., gross pay less pre-tax deductions). Complete
the payroll register for this pay period. Ensure to input an hourly rate for each employee (including those
that are salaried) that is rounded to 5 decimal places.
2. February 26 is the end of the final pay period for the month and includes work completed during the
weeks of February 15-19 and 22-26. Using the payroll register, compute the employee gross pay using 70
hours as the standard biweekly total (35 hours per week) for all employees except Mary Shangraw, who
works 20 hours per week and receives overtime for any time worked past that point. All employee hours
have been given to you on the payroll register Joel Schwartz has sold $7,500 of product during this pay
period at a 3% commission. Federal withholding tax should be computed using the wage-bracket tables in
Appendix C. State witholding tax for Vermont is computed at 3.55% of taxable wages (i.e., gross pay less
pre-tax deductions). Complete the payroll register for this pay period. Ensure to input an hourly rate for
each employee (including those that are salaried) that is rounded to 5 decimal places.
3. Complete the General Journal entries as follows:
February 12 Journalize the employee pay.
February 12 Journalize the employer payroll tax for the February 12 pay
period. Use 5.4% SUTA and 0.6% FUTA. No employees will
exceed the FUTA or SUTA wage base.
February 15 Issue the employee pay.
February 26 Journalize the employee pay.
February 26 Journalize the employer payroll tax for the February 26 pay
period. Use 5.4% SUTA and 0.6% FUTA. No employee will
exceed the FUTA or SUTA wage base.
February 29 Issue the employee pay.
4. Post all February journal entries to the appropriate accounts on the General Ledger.
Part 1 PRF Feb12
Part 2 Feb 26
Answer on the blue box. Just show the calculation