90.2K

Verified Solution

Link Copied!

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up

Sugarhouse's staff:

The company has the following departments:

Department A: Agricultural Workers

Department B: Office Workers

Initial pre$-$tax deductions for each employee are as follows:

The first day of work for Prevosti Farms and Sugarhouse for all employees is February $1,2023.$ February $10$ is the end of the first pay

period and includes work completed during the week of February $1-10($weekdays only$).$ Using the payroll register, compute the

employee gross pay using $40$ hours as the standard workweek for all employees except Mary Shangraw, who works $32$ 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 paid biweekly. The pay frequency for federal income tax purposes is

biweekly. For nonexempt employees, over $64$ hours $(8$ days at $8$ hours per day, except Shangraw who works $4$ hours per day$)$ in the

first payroll will be overtime. Federal withholding tax should be computed using the wage$-$bracket tables in Appendix C$.$ State

withholding tax for Vermont is computed at $3\mathrm{.}35$ percent of taxable wages $($i$.$e$.,$ gross pay less pre$-$tax deductions$).$ The same

deductions are allowed for state as for federal.

February

February $24,2023,$ is the end of the final pay period for the month. Schwartz has sold $$7,500$ of products during this pay period at a $3$

percent commission. Pay will be disbursed on February $28,2023,$ and check numbers will continue from the prior payroll. For all

employees, over $32$ hours in the first week will be overtime.

When determining the amount an exempt employee receives for partial weeks, take their salary divided by the number of weeks times

days worked. Annual salary: $$35,200(525)=$$$35,200260=$$$135\mathrm{.}38462($rounded to five decimal points$)$ per day. Once you

have a per$-$day rate, multiply it by the number of days worked. Exempt employee salary information is as follows:

Required:

Complete the payroll register for this pay period and update the Employee Earnings Record form for each employee with the

corresponding information. The Step$-2$ of Form W$-4$ is unchecked. 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,30026,$ or $$50.$ All

insurance and $401($k$)$ deductions are pre$-$tax for federal and state.

Benefit$-$related payroll deductions will take effect on the first pay period of March.

$\backslash$table$[[$Employee Millen,Flex$-$Time,Child Care Assistance $($under $$5,000$ annually$),$FSA $($annual$),$Educational Assistance $($$$4,000$ annually$),$Life Insurance $($at $1\%$ of annual salary value$),\backslash$table$[[$Long$-$Term Care$],[$Insurance $($ $$15$ per Month$]],],[$Millen$,$Yes,Yes,$$500\mathrm{.}00,,,,]]$complete this question by entering your answers in the table below.

Update the Employee Earnings Record form for Thomas Millen with the corresponding information.

Note: Round your answers for "Hourly Rate" or "Period Wage" to $5$ decimal places. Round all other intermediate computations and final answers tc

$\backslash$table$[[,,$EMPLOYEE EARNINGS REGISTER$],[$Name$,$Thomas Millen,,Hire Date,$2/1/2023],[$Address$,1022$ Forest School Road,,Date of Birth,$12/16/1992],[$City or State or Zip,Woodstock, VT $05001,,$Position,Production Ma$],[$Telephone$,802-478-5055,,$Filing Status,Married Filing$],[$Social Security Number,$031-11-3456,,$Exempt or Nonexempt,Exempt$],[,,,,,,$Pay Rate,$$35,200$ per $y$ i$],[$Flex$-$time,Child Care,FSA amount,Education Assistance,Life Insurance,Long$-$tem care,Gym Membership,Total Benefit,$],[$Yes$,$Yes,$19\mathrm{.}23077,$No$,13\mathrm{.}53846,$No$,6\mathrm{.}92308,,],[$Period Ended,Hours Worke$,$Regular Pay,Overtime Pay,Holiday Pay,Commissions,Gross Pay,$401($k$),$Section $125],[2/10/2023,,,,,,$$$0\mathrm{.}00,,],[2/24/2023,,,,,,$$ $0\mathrm{.}00,,],[$Period Ended,Taxable Pay $($Federal$),$Taxable Pay $($FICA$),$Federal Income Tax,Social Security Tax,Medicare,State Income Tax,Total Deductions,Net Pay$],[2/10/2023,,,,,,,,],[2/24/2023,,,,,,,,]]$

Itations and final answers to $2$ decimal places.

Answer & Explanation Solved by verified expert

See Answer