Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The Sugarhouse's staff: Employee Number A-Mille Name and Address Thomas Millen 1022 Forest

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The Sugarhouse's staff: Employee Number A-Mille Name and Address Thomas Millen 1022 Forest School Road Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% Section 125 deduction: $155.00 A-Towle Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-9974 401(k) deduction: 5% Section 125 deduction: $100.00 A-Long Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 401(k) deduction: 2% Section 125 deduction: $155.00 Payroll informatic Hire Date: 2-3-2020 DOB: 12-16-1982 Position: Production Man PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $35,000/year Dependents under 17: 3 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 7-14-1991 Position: Production Work PT/FT: FT, nonexempt M/S: Single Pay Rate: $12.00/hour Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 3-16-1987 Position: Production Worker PT/FT: FT, nonexempt M/S: Married/Joint Pay Rate: $12.50/hour Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 8-20-1994 Position: Administrative Ass PT/FT: PT, nonexempt M/S: Single Pay Rate: $11.00/houn Dependents under 17: 0 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 4-6-1960 Position: Office Manager PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $32,000/year B-Shang Mary Shangraw 1901 Main Street #2 Bridgewater, VT 05520 802-575-5423 SSN: 075-28-8945 401(k) deduction: 3% Section 125 deduction: $100.00 B-Lewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 aeauction: $100.00 ewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 deduction: $155.00 -Schwa Joel Schwartz 55 Maple Farm Way Woodstock, VT 05534 802-463-9985 SSN: 021-34-9876 401(k) deduction: 5% Section 125 deduction: $100.00 vepenaents under 17: Dependents over 17: Step 4 information: Hire Date: 2-3-2020 DOB: 4-6-1960 Position: Office Mana PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $32,000/yea Dependents under 17: Dependents over 17: 1 Step 4 information: nc Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $24,000/yean 3% commission per case Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 9-18-1967 Position: Owner/Presiden PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $45,000/year Dependents under 17: 3 Dependents over 17: 2 Step 4 information: none Hire Date: 2-3-2020 DOB: 1-1-1991 Position: Accounting Cler PT/FT: Non-exempt M/S: Single Pay Rate: $34,000/year Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none B-Prevo Toni Prevosti 820 Westminster Road Bridgewater, VT 05520 802-555-3456 SSN: 055-22-0443 401(k) deduction: 6% Section 125 deduction: $155.00 B-Student Student Success 1644 Smitten Road Woodstock, VT 05001 (555)-555-5555 SSN: 555-55-5555 401(k) deduction: 2% Section 125 deduction: $100.00 The departments are as follows: Department A: Agricultural Workers Department B: Office Workers Initial ro Name Thomas Millen Avery Towle Charlie Long Mary Shangraw Deduction Insurance: $155/paycheck 401(k): 3% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 5% of gross pay Marital Status: Single Insurance: $155/paycheck 401(k): 2% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 3% of gross pay Marital Status: Single Insurance: $155/paycheck 401(k): 4% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 5% of gross pay Marital Status: Married Insurance: $155/paycheck 401(k): 6% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 2% of gross pay Marital Status: Single Kristen Lewis Joel Schwartz Toni Prevosti Student Success The first day of work for Prevosti Farms and Sugarhouse for all employees is February 3, 2020. February period for Prevosti Farms and Sugarhouse and includes work completed during the week of February 3-7 compute the employee gross pay and net pay using 35 hours as the standard workweek for all employee who works 20 hours per week and receives overtime for any time worked past that point per company pc employees receive overtime pay when they work more than 35 hours in one week. Joel Schwartz has ma 3 percent commission rate during this pay period. Remember that the employees are paid biweekly. Note comprises only one week of work, but the pay frequency for federal income tax purposes is biweekly. Fed be computed using the wage-bracket tables in Appendix C. State withholding tax for Vermont is computec wages (i.e., gross pay less pre-tax deductions).The same deductions are allowed for state as for federal. February 21, 2020, is the end of the final pay period for the month. Schwartz has sold $7,500 of product du percent commission. Pay will be disbursed on February 26, 2020, and check numbers will continue from pi The hours for the nonexempt employees are as follows: The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 12.00000 $ 12.50000 $ 11.00000 $ 18.68132 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours Name Towle Long Shangraw Success (You) Hourly rate $ 12.00000 $ 12.50000 $ 11.00000 $ 18.68132 Hours worked 2/10-2/21 80 hours 70 hours 42 hours 71 hours Required: Complete the payroll register for this pay period and update the Employee Earnings Record form fo corresponding information. The Step -2 of Form W-4 is unchecked. The amount per period should b example, if an employee elected to contribute $1,300 to his or her FSA, the period payroll deductior Ensure to input an hourly rate for each employee (including those that are salaried) that is rounded t Benefit-related payroll deductions will take effect on the first pay period of March. Child Care Assistance (under $5,000 annually) Employee Millen Towle Long Shangraw Lewis Schwartz Prevosti Student Flex-Time Yes No Yes Yes No No Yes No Educational Assistance ($4,000 annually) No Yes Yes Yes No Yes No No No No No FSA (annual) $ 500.00 $ 1,200.00 $ 700.00 $ 200.00 $ 1,600.00 $ 450.00 $ 900.00 $ 300.00 Life Insurance Cat annual salary val Yes No Yes Yes Yes Yes Yes No No INO Yes INo Yes Position Update the Employee Earnings Record form for Toni Prevost with the corresponding information: (Round your answers for "Hourly Rate" or "Perlod Wagetos decimal places Round all other intermediate computations and in EMPLOYEE EARNINGS REGISTER 2/3/2020 Hire Date Toni Prevost 3 Dependent child 17 Name 9/18/1967 Date of Birth 820 Westminster Road 2 Dependent other Address City State Zip Bridgewater VT05520 Owner/President none Step 4 W4 Info 802-555-3456 Telephone Filing Status Married Step 4b W 4 Info nghe Social Security Number 055-22.0443 Exempt Nonexemp! Exempl Step 4c W4 Info non Pay Rate 545.000/year Educational Flexime Child Care FSA amount Lileins Long-tem care Gym Membership Total Benefit Assistance Yes No $900 00 NO Yos NO Yes Tarable Pay His Worked Period Ended Reg Pay OT Pay Holiday Comm Grass Pay 4010 Soc 125 Taxable Play Federal FICA 217/2020 221/2020 5 $ 0.00 0.001 Taxable Pay Federal Taxable Pay FICA) and Election Federal Income Tax Social Security Tax Medicare State Income Tax Total Deductions Net Pay YTD Net Pay YTD Gross Pay Penod Ended 2/7/2020 2/21/2020 3/22/2020 175/2030 1/19/2020 Name Deduction Thomas Millen 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 Success Insurance: $100/paycheck 401(k): 2% of gross pay Marital Status: Single The first day of work for Prevosti Farms and Sugarhouse for all employees is February 3, 2020. February 7 is the end of the first pay period for Prevosti Farms and Sugarhouse and includes work completed during the week of February 3-7. 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 per company policy. The other hourly employees receive overtime pay when they work more than 35 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 paid biweekly. 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 withholding tax for Vermont is computed wages (i.e., gross pay less pre-tax deductions).The same deductions are allowed for state as for federal. t 3.35 percent of taxable February 21, 2020, is the end of the final pay period for the month. Schwartz has sold $7,500 of product during this pay period at a 3 percent commission. Pay will be disbursed on February 26, 2020, and check numbers will continue from prior payroll. The hours for the nonexempt employees are as follows: Hours worked Name Prevosti Farms and Sugarhouse pays its employees according to their job classification. The Sugarhouse's staff: Employee Number A-Mille Name and Address Thomas Millen 1022 Forest School Road Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% Section 125 deduction: $155.00 A-Towle Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-9974 401(k) deduction: 5% Section 125 deduction: $100.00 A-Long Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 401(k) deduction: 2% Section 125 deduction: $155.00 Payroll informatic Hire Date: 2-3-2020 DOB: 12-16-1982 Position: Production Man PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $35,000/year Dependents under 17: 3 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 7-14-1991 Position: Production Work PT/FT: FT, nonexempt M/S: Single Pay Rate: $12.00/hour Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 3-16-1987 Position: Production Worker PT/FT: FT, nonexempt M/S: Married/Joint Pay Rate: $12.50/hour Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 8-20-1994 Position: Administrative Ass PT/FT: PT, nonexempt M/S: Single Pay Rate: $11.00/houn Dependents under 17: 0 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 4-6-1960 Position: Office Manager PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $32,000/year B-Shang Mary Shangraw 1901 Main Street #2 Bridgewater, VT 05520 802-575-5423 SSN: 075-28-8945 401(k) deduction: 3% Section 125 deduction: $100.00 B-Lewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 aeauction: $100.00 ewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 deduction: $155.00 -Schwa Joel Schwartz 55 Maple Farm Way Woodstock, VT 05534 802-463-9985 SSN: 021-34-9876 401(k) deduction: 5% Section 125 deduction: $100.00 vepenaents under 17: Dependents over 17: Step 4 information: Hire Date: 2-3-2020 DOB: 4-6-1960 Position: Office Mana PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $32,000/yea Dependents under 17: Dependents over 17: 1 Step 4 information: nc Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $24,000/yean 3% commission per case Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 9-18-1967 Position: Owner/Presiden PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $45,000/year Dependents under 17: 3 Dependents over 17: 2 Step 4 information: none Hire Date: 2-3-2020 DOB: 1-1-1991 Position: Accounting Cler PT/FT: Non-exempt M/S: Single Pay Rate: $34,000/year Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none B-Prevo Toni Prevosti 820 Westminster Road Bridgewater, VT 05520 802-555-3456 SSN: 055-22-0443 401(k) deduction: 6% Section 125 deduction: $155.00 B-Student Student Success 1644 Smitten Road Woodstock, VT 05001 (555)-555-5555 SSN: 555-55-5555 401(k) deduction: 2% Section 125 deduction: $100.00 The departments are as follows: Department A: Agricultural Workers Department B: Office Workers Initial ro Name Thomas Millen Avery Towle Charlie Long Mary Shangraw Deduction Insurance: $155/paycheck 401(k): 3% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 5% of gross pay Marital Status: Single Insurance: $155/paycheck 401(k): 2% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 3% of gross pay Marital Status: Single Insurance: $155/paycheck 401(k): 4% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 5% of gross pay Marital Status: Married Insurance: $155/paycheck 401(k): 6% of gross pay Marital Status: Married Insurance: $100/paycheck 401(k): 2% of gross pay Marital Status: Single Kristen Lewis Joel Schwartz Toni Prevosti Student Success The first day of work for Prevosti Farms and Sugarhouse for all employees is February 3, 2020. February period for Prevosti Farms and Sugarhouse and includes work completed during the week of February 3-7 compute the employee gross pay and net pay using 35 hours as the standard workweek for all employee who works 20 hours per week and receives overtime for any time worked past that point per company pc employees receive overtime pay when they work more than 35 hours in one week. Joel Schwartz has ma 3 percent commission rate during this pay period. Remember that the employees are paid biweekly. Note comprises only one week of work, but the pay frequency for federal income tax purposes is biweekly. Fed be computed using the wage-bracket tables in Appendix C. State withholding tax for Vermont is computec wages (i.e., gross pay less pre-tax deductions).The same deductions are allowed for state as for federal. February 21, 2020, is the end of the final pay period for the month. Schwartz has sold $7,500 of product du percent commission. Pay will be disbursed on February 26, 2020, and check numbers will continue from pi The hours for the nonexempt employees are as follows: The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 12.00000 $ 12.50000 $ 11.00000 $ 18.68132 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours Name Towle Long Shangraw Success (You) Hourly rate $ 12.00000 $ 12.50000 $ 11.00000 $ 18.68132 Hours worked 2/10-2/21 80 hours 70 hours 42 hours 71 hours Required: Complete the payroll register for this pay period and update the Employee Earnings Record form fo corresponding information. The Step -2 of Form W-4 is unchecked. The amount per period should b example, if an employee elected to contribute $1,300 to his or her FSA, the period payroll deductior Ensure to input an hourly rate for each employee (including those that are salaried) that is rounded t Benefit-related payroll deductions will take effect on the first pay period of March. Child Care Assistance (under $5,000 annually) Employee Millen Towle Long Shangraw Lewis Schwartz Prevosti Student Flex-Time Yes No Yes Yes No No Yes No Educational Assistance ($4,000 annually) No Yes Yes Yes No Yes No No No No No FSA (annual) $ 500.00 $ 1,200.00 $ 700.00 $ 200.00 $ 1,600.00 $ 450.00 $ 900.00 $ 300.00 Life Insurance Cat annual salary val Yes No Yes Yes Yes Yes Yes No No INO Yes INo Yes Position Update the Employee Earnings Record form for Toni Prevost with the corresponding information: (Round your answers for "Hourly Rate" or "Perlod Wagetos decimal places Round all other intermediate computations and in EMPLOYEE EARNINGS REGISTER 2/3/2020 Hire Date Toni Prevost 3 Dependent child 17 Name 9/18/1967 Date of Birth 820 Westminster Road 2 Dependent other Address City State Zip Bridgewater VT05520 Owner/President none Step 4 W4 Info 802-555-3456 Telephone Filing Status Married Step 4b W 4 Info nghe Social Security Number 055-22.0443 Exempt Nonexemp! Exempl Step 4c W4 Info non Pay Rate 545.000/year Educational Flexime Child Care FSA amount Lileins Long-tem care Gym Membership Total Benefit Assistance Yes No $900 00 NO Yos NO Yes Tarable Pay His Worked Period Ended Reg Pay OT Pay Holiday Comm Grass Pay 4010 Soc 125 Taxable Play Federal FICA 217/2020 221/2020 5 $ 0.00 0.001 Taxable Pay Federal Taxable Pay FICA) and Election Federal Income Tax Social Security Tax Medicare State Income Tax Total Deductions Net Pay YTD Net Pay YTD Gross Pay Penod Ended 2/7/2020 2/21/2020 3/22/2020 175/2030 1/19/2020 Name Deduction Thomas Millen 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 Success Insurance: $100/paycheck 401(k): 2% of gross pay Marital Status: Single The first day of work for Prevosti Farms and Sugarhouse for all employees is February 3, 2020. February 7 is the end of the first pay period for Prevosti Farms and Sugarhouse and includes work completed during the week of February 3-7. 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 per company policy. The other hourly employees receive overtime pay when they work more than 35 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 paid biweekly. 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 withholding tax for Vermont is computed wages (i.e., gross pay less pre-tax deductions).The same deductions are allowed for state as for federal. t 3.35 percent of taxable February 21, 2020, is the end of the final pay period for the month. Schwartz has sold $7,500 of product during this pay period at a 3 percent commission. Pay will be disbursed on February 26, 2020, and check numbers will continue from prior payroll. The hours for the nonexempt employees are as follows: Hours worked Name

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

More Books

Students also viewed these Accounting questions

Question

a. How do you think these stereotypes developed?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago