The departments are as follows: Department A: Agricultural Workers Department B: Office Workers The first day...

Transcribed Image Text:

The departments are as follows: Department A: Agricultural Workers Department B: Office Workers 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 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 40 hours in one week. Joel Schwartz has made $5,000 in case sales at a 3 percent commission rate during this pay period. Joel Schwartz's sales are subject to commissions for the 2/18 pay period of $7,500. Remember that the employees are paid biweekly. Note that the first pay period comprises only four days of work, but the pay frequency for federal income tax purposes is biweekly. Exempt employee pay information is as follows: Name Millen Lewis Schwartz Prevosti Annual Salary $ 35,000 $ 32,000 Notes $ 32,000 plus 3% commission on sales $ 45,000 The hours for the nonexempt employees are as follows: Hourly rate Hours worked 2/1-2/4 Name Towle $ 15.00000 32 hours Long $ 15.00000 33 hours Shangraw $ 15.00000 16 hours Success (You) $ 16.34615 32 hours Name Hourly rate Towle Long $ 15.00000 Hours worked 2/5-2/18 82 hours $ 15.00000 80 hours Shangraw $ 15.00000 42 hours Success (You) $ 16.34615 81 hours Although the company has already established medical and retirement plan benefits, Toni Prevosti wants to consider other benefits to attract employees. As the company's accountant, you have been tasked with annotating employee earnings records with benefit elections for each employee. The following sheet contains details of employee choices. These costs are employer-paid and will take effect on the first pay period of March. Multiply the employee's annual salary by 1 percent to calculate the life insurance benefit. For example, if an employee earned $50,000 per year, the life insurance would be $50,000 0.01 = $500. Employee Millen Flex-Time Yes Childcare Assistance (under $5,000 annually) Flexible Spending Educational Assistance Yes Arrangement (FSA) (annual) $500.00 ($4,000 annually) Life Insurance (at 1% of annual salary value) Long-Term Care Insurance ($15 per period) Gym Membership ($15 per month) No Yes No Yes Towle No No $1,200.00 Yes No No Yes Long Yes Yes $700.00 Yes Yes No Yes Shangraw Yes No $200.00 No Yes No No Lewis No No $1,600.00 No Yes Yes No Schwartz No No $450.00 Yes Yes No Yes Prevosti Yes No $900.00 No Yes No Yes Success No No $300.00 Yes No No Yes Required: Annotate the Employee Earning Records with payroll-related benefit elections. The amount per period should be included in the record. As an example, if an employee elected to contribute $1,300 to his or her FSA, the period payroll deduction would be $1,300 26, or $50. The estimated yearly earnings used for insurance purposes for the hourly employees are computed as follows: (hourly wages times number of hours worked per week 52) then divide by 26 pay periods to get an amount per pay period. For example: If Shangraw worked 20 hours per week, the computation is $15 per hour 20 hours per week 52 weeks = $15,600 per year. Insurance is computed as $15,600 1% = $156.00 26 = $6.00 per pay period. Complete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Student Kristen Lewis Joel Schwartz Toni Prevosti Success Complete the Employee Information Form for Thomas Millen. Note: Do not round intermediate calculations. Round your final answers to 2 decimal places. Name Address City/State/Zip Telephone Social Security Number Thomas Millen 1022 Forest School Road Woodstock, VT 05001 EMPLOYEE EARNINGS RECORD Hire Date Date of Birth Position 2/1/2022 12/16/1992 Dependent child <17 Dependent other Production Manager /full-time Step 4a W-4 information 802-478-5055 031-11-3456 Filing Status Exempt/Nonexempt Married Filing Jointly Step 4b W-4 information Exempt Step 4c W-4 information Pay Rate $ 35,000.00 per Year Flex-Time Child Care FSA Amount Educational Assistance Life Insurance Long-Term Care Gym Membership Total Benefit Yes Yes $ 500.00 Yes No < Thomas Millen Avery Towle > The departments are as follows: Department A: Agricultural Workers Department B: Office Workers 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 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 40 hours in one week. Joel Schwartz has made $5,000 in case sales at a 3 percent commission rate during this pay period. Joel Schwartz's sales are subject to commissions for the 2/18 pay period of $7,500. Remember that the employees are paid biweekly. Note that the first pay period comprises only four days of work, but the pay frequency for federal income tax purposes is biweekly. Exempt employee pay information is as follows: Name Millen Lewis Schwartz Prevosti Annual Salary $ 35,000 $ 32,000 Notes $ 32,000 plus 3% commission on sales $ 45,000 The hours for the nonexempt employees are as follows: Hourly rate Hours worked 2/1-2/4 Name Towle $ 15.00000 32 hours Long $ 15.00000 33 hours Shangraw $ 15.00000 16 hours Success (You) $ 16.34615 32 hours Name Hourly rate Towle Long $ 15.00000 Hours worked 2/5-2/18 82 hours $ 15.00000 80 hours Shangraw $ 15.00000 42 hours Success (You) $ 16.34615 81 hours Although the company has already established medical and retirement plan benefits, Toni Prevosti wants to consider other benefits to attract employees. As the company's accountant, you have been tasked with annotating employee earnings records with benefit elections for each employee. The following sheet contains details of employee choices. These costs are employer-paid and will take effect on the first pay period of March. Multiply the employee's annual salary by 1 percent to calculate the life insurance benefit. For example, if an employee earned $50,000 per year, the life insurance would be $50,000 0.01 = $500. Employee Millen Flex-Time Yes Childcare Assistance (under $5,000 annually) Flexible Spending Educational Assistance Yes Arrangement (FSA) (annual) $500.00 ($4,000 annually) Life Insurance (at 1% of annual salary value) Long-Term Care Insurance ($15 per period) Gym Membership ($15 per month) No Yes No Yes Towle No No $1,200.00 Yes No No Yes Long Yes Yes $700.00 Yes Yes No Yes Shangraw Yes No $200.00 No Yes No No Lewis No No $1,600.00 No Yes Yes No Schwartz No No $450.00 Yes Yes No Yes Prevosti Yes No $900.00 No Yes No Yes Success No No $300.00 Yes No No Yes Required: Annotate the Employee Earning Records with payroll-related benefit elections. The amount per period should be included in the record. As an example, if an employee elected to contribute $1,300 to his or her FSA, the period payroll deduction would be $1,300 26, or $50. The estimated yearly earnings used for insurance purposes for the hourly employees are computed as follows: (hourly wages times number of hours worked per week 52) then divide by 26 pay periods to get an amount per pay period. For example: If Shangraw worked 20 hours per week, the computation is $15 per hour 20 hours per week 52 weeks = $15,600 per year. Insurance is computed as $15,600 1% = $156.00 26 = $6.00 per pay period. Complete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Student Kristen Lewis Joel Schwartz Toni Prevosti Success Complete the Employee Information Form for Thomas Millen. Note: Do not round intermediate calculations. Round your final answers to 2 decimal places. Name Address City/State/Zip Telephone Social Security Number Thomas Millen 1022 Forest School Road Woodstock, VT 05001 EMPLOYEE EARNINGS RECORD Hire Date Date of Birth Position 2/1/2022 12/16/1992 Dependent child <17 Dependent other Production Manager /full-time Step 4a W-4 information 802-478-5055 031-11-3456 Filing Status Exempt/Nonexempt Married Filing Jointly Step 4b W-4 information Exempt Step 4c W-4 information Pay Rate $ 35,000.00 per Year Flex-Time Child Care FSA Amount Educational Assistance Life Insurance Long-Term Care Gym Membership Total Benefit Yes Yes $ 500.00 Yes No < Thomas Millen Avery Towle >

Answer rating: 100% (QA)

It appears that you are tasked with filling out an Employee Earnings Record for Thomas Millen with the associated payrollrelated benefit elections as ... View the full answer