50.1K

Verified Solution

Link Copied!

Having trouble figuring out the hourly rate for exempt workers.

I appreciate any help you can provide.

Return to ques 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 and includes work completed during the week of February 3-7. Compute the employee gross 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 $4,600 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. Exempt employee pay information is as follows: Notes Name Millen Lewis Schwartz Prevosti Annual Salary $ 42,000 $ 36,200 $ 27,500 $ 54,800 plus 3% commission on sales The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 11.30 $ 12.50 $ 10.30 $ 15.20 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours Required: Complete the payroll register for the period's gross pay. Pay will be disbursed on February 12, 2020, starting with check number 6628. -(NOTE): (Do not round intermediate computations. 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.) Answer is complete but not entirely correct. P/R End Date Check Date Prevosti Farms and Sugarhouse 2/7/2020 2/12/2020 Company Name: Name Filing Status Dependents Under 17 Gross Earnings 40 3 3 0 MJ 2 Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success Totals Dependents Hourly Rate or Over 17 Period Wage 1s 1 26.00000 X 0 11.30000 0 0 12.50000 1 10.30000 1 1 26.00000 x 0 0 26.00000 x 2 2 26.00000 0 15.20000 WEEEEE No.of Regular Hours 35 35 35 20 35 35 35 35 No.of Overtime Hours 0 0 0 0 5 1 0 0 0 0 0 0 0 0 No.of Holiday Commissions Hours 0 0s 0.00 0 0.00 0 0 0.00 0 0 0.00 0 0 0.00 0 0 138.00 0 0 0.00 0 0 0.00 lolololololololo lolololololololo MJ MJ 807.69 395.50 531.25 221.45 696.15 666.85 1,053.85 532.00 4.904.74 2 2 2 3 3 0 MJ Gross Taxable Wages for Taxable Wages for Social Security Name Medicare Federal WIH State W/H Tax Garnishment Return to ques 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 and includes work completed during the week of February 3-7. Compute the employee gross 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 $4,600 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. Exempt employee pay information is as follows: Notes Name Millen Lewis Schwartz Prevosti Annual Salary $ 42,000 $ 36,200 $ 27,500 $ 54,800 plus 3% commission on sales The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 11.30 $ 12.50 $ 10.30 $ 15.20 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours Required: Complete the payroll register for the period's gross pay. Pay will be disbursed on February 12, 2020, starting with check number 6628. -(NOTE): (Do not round intermediate computations. 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.) Answer is complete but not entirely correct. P/R End Date Check Date Prevosti Farms and Sugarhouse 2/7/2020 2/12/2020 Company Name: Name Filing Status Dependents Under 17 Gross Earnings 40 3 3 0 MJ 2 Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success Totals Dependents Hourly Rate or Over 17 Period Wage 1s 1 26.00000 X 0 11.30000 0 0 12.50000 1 10.30000 1 1 26.00000 x 0 0 26.00000 x 2 2 26.00000 0 15.20000 WEEEEE No.of Regular Hours 35 35 35 20 35 35 35 35 No.of Overtime Hours 0 0 0 0 5 1 0 0 0 0 0 0 0 0 No.of Holiday Commissions Hours 0 0s 0.00 0 0.00 0 0 0.00 0 0 0.00 0 0 0.00 0 0 138.00 0 0 0.00 0 0 0.00 lolololololololo lolololololololo MJ MJ 807.69 395.50 531.25 221.45 696.15 666.85 1,053.85 532.00 4.904.74 2 2 2 3 3 0 MJ Gross Taxable Wages for Taxable Wages for Social Security Name Medicare Federal WIH State W/H Tax Garnishment

Answer & Explanation Solved by verified expert

See Answer