Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prevostl Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff. Employee Number Name and Address Payroll

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Prevostl Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff. Employee Number Name and Address Payroll information A-Mille Thomas Millen Hire Date: 2-1-2022 1022 Forest School Road Date of Birth: 12-16-1992 Woodstock, VT 05001 Position: Production Manager 802-478-5055 Part Time or Full Time: Full Time, SSN: 031-11-3456 exempt 401 (k) deduction: 3% Marital Status: Married Filing Jointly Section 125 deduction: $155 Pay Rate: $35,090 per year Dependents under 17: 3 Dependents over 17: 1 Step 4 information: none A-Towle Avery Towle Hire Date: 2-1-2022 4011 Route 109 Date of Birth: 7-14-2901 Plymouth, VT 05102 Position: Production Worker 802-967-5873 Part Time or Full Time: Full Time, SSN: 089-74-8974 nonexempt 401(k) deduction: 5% Marital Status: Single Section 125 deduction: $108 Pay Rate: $15.08 per hour Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none A-Long Charlie Long Hire Date: 2-1-2022 242 Benedict Road S. Date of Birth: 3-16-1997 Woodstock, VT 05902 Position: Production Worker 802-429-3846 Part Time or Full Time: Full Time, SSN: 056-23-4593 nonexempt 401 (k) deduction: 2% Marital Status: Married Filing Jointly Section 125 deduction: $155 Pay Rate: $15.00 per hour Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none B-Shang Mary Shangraw Hire Date: 2-1-2022 1901 Main Street number 2 Date of Birth: 8-20-1980 Bridgewater, VT @5520 Position: Administrative 802-575-5423 Assistant SSN: 075-28-8945 Part Time or Full Time: Part Time, 401(k) deduction: 3% nonexempt Section 125 deduction: $108 Marital Status: Single Pay Rate: $15.08 per hour Dependents under 17: @ Dependents over 17: 1 Step 4 information: none B-Lewis Kristen Lewis Hire Date: 2-1-2022 840 Daily Hollow Road Date of Birth: 4-6-1991 Bridgewater, VT @5523 Position: Office Manager 802-390-5572 Part Time or Full Time: Full Time, SSN: 076-39-5673 exempt 401(k) deduction: 4% Marital Status: Married Filing Jointly Section 125 deduction: $155 Pay Rate: $32,090 per year Dependents under 17: 2 Dependents over 17: 1 Step 4 information: none B-Schwa Joel Schwartz Hire Date: 2-1-2022 55 Maple Farm Way Date of Birth: 5-23-1993 Woodstock, VT 05534 Position: Sales 802-463-9985 Part Time or Full Time: Full Time,SSN: 021-34-9876 exempt 401 (k) deduction: 5% Marital Status: Married Filing Jointly Section 125 deduction: $108 Pay Rate: $32,080 per year base plus 3% commission per case sold Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none B-Prevo Toni Prevosti Hire Date: 2-1-2022 820 Westminster Road Date of Birth: 9-19-1987 Bridgewater, VT 05520 Position: Owner or President 802-555-3456 Part Time or Full Time: Full Time, SSN: 055-22-9443 exempt 401 (k) deduction: 6% Marital Status: Married Filing Jointly Section 125 deduction: $155 Pay Rate: $45,080 per year Dependents under 17: 3 Dependents over 17: 2 Step 4 information: none Student Success Student B. Success Hire Date: 2-1-2022 1644 Smitten Road Date of Birth: 1-1-2901 Woodstock, VT 05801 Position: Accounting Clerk 555-555-5555 Part Time or Full Time: Full Time, SSN: 555-55-5555 nonexempt Section 125 deduction: $109 Marital Status: Single Pay Rate: $34,090 per year Dependents under 17: @ Dependents over 17: 0 Step 4 information: none The departments are as follows: Department A: Agricultural Workers Department B: Office WorkersPart 1 (Static) The first day of work for Prevosti Farms and Sugarhouse for all employees is February 1, 2022. February 4 Is the end of the first pay period and includes work completed during the week of February 1-4. Compute the employee gross pay, using 40 hours as the standard work week for all employees except Mary Shangraw, who works 20 hours per week and receives overtime for any time worked past that point per company policy. The other hourly employees receive overtime pay when they work more than 40 hours In one week. Joel Schwartz has made $5.000 in case sales at a 3 percent commission rate during this pay period. Remember that the employees are pald biweekly. Note that the first pay perlod comprises only four days of work, but the pay frequency for federal Income tax purposes is biweekly. For nonexempt employees, over 32 hours In the first week will be overtime. Exempt employees pay Information is as follows: Name Annual Salary First Payroll Notes: Notes Millen $ 35,090 (Annual + 26) x (4 + 10 days) Lewis $ 32,080 (Annual + 26) x (4 + 10 days) Schwartz $ 32,090 (Annual + 26) x (4 + 10 days) plus 3% commission on sales Prevosti $ 45,080 (Annual + 26) x (4 + 10 days) The hours for the nonexempt employees are as follows: Hours worked Name Hourly rate 2/1-2/4 Towle $ 15. 09090 32 hours Long $ 15.06090 33 hours Shangraw $ 15. 09090 16 hours Success (You) $ 16. 34615 32 hours Required: Complete the payroll register for the period's gross pay. Pay will be disbursed on February 8, 2022, starting with check number 6628. Note: Round your answers for "Hourly Rate or Period Wage" to 5 decimal places and all other answers to 2 decimal places. Hours should be entered as whole numbers.P/R End Date 2/4/2022 Company Name Prevosti Farms and Sugarhouse Check Date 2/8/2022 Dependents Dependents Hourly Rate or Period Number of Number of Taxable Name Filing Status Number of Under 17 Over 17 Regular Overtime Holiday Hours Commissions Gross Earnings 401(k) Section 125 Taxable Wages for Wage Hours Hours Federal W/H Wages for FICA Thomas Millen MJ 3 S 38.46153 40 O 0 S 0.00 S 538.46 Avery Towle S 480.00000 32 0.00 S 480.00 Charlie Long MJ 2 15.00000 33 0.00 S 602.50 Mary Shangraw S 15.00000 16 O 0.00S 240.00 Kristen Lewis MJ 492.30769 40 0.00 S 192.31 Joel Schwartz MJ N 492.30769 40 150.00 S 642.31 Toni Prevosti MJ 3 2 892.30769 40 0.00 S 892.31 Student Success S 16.34615 32 0.00 Totals $ 150.00 S 3.587.89 Taxable Wages Name Gross Earnings for Federal Taxable Wages Federal VV/H Social for FICA Security Tax Medicare W/H State W/H Tax Garnishment United Way Net Pay Check W/H Number Thomas Millen S 538.46 3628 Avery Towle 480.00 3629 Charlie Long 502.50 8630 Mary Shangraw 240.00 363 Kristen Lewis 492.31 8632 Joel Schwartz 842.31 3633 Toni Prevosti 892.31 3634 Student Success 3635 Totals S 3.587.89 $ 3.587.89

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Plus

Authors: Robert Libby, Patricia Libby, Daniel Short

7th Edition

0077480015, 9780077480011

More Books

Students also viewed these Accounting questions