Can you help me solve Hourly Rate.

Name Filing Status Dependents Under 17 Dependents Over 17 Hourly Rate or Period No.of Regular No.of Overtime No.of Holiday Wage Hours Hours Hours Commissions Gross Earnings MJ 3 1 35 0 0 $ 0.00 $ 673.08 S 0 0 12.00000 35 0 0 MJ Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz 2 0 12.50000 0.00 0.00 35 420.00 531.25 5 0 S 0 1 11.00000 20 1 0 0.00 236.50 MJ 2 1 35 0 0 0.00 615.38 MJ 2 0 35 0 0 150.00 Toni Prevosti MJ 3 2 35 0 0 0.00 611.54 865.38 653.80 Student Success S 18.68000 35 0 0 0.00 Totals s 4.606.93 Taxable Wages Number Name and Address Thomas Millen 1022 Forest School Rd Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% Section 125 deduction: $155 Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-0974 401(k) deduction: 5% Section 125 deduction: $100 Payroll information Hire Date: 2-3-2020 DOB: 12-16-1982 Position: Production Manager 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 Worker PT/FT: FT, nonexempt M/S: Single Pay Rate: $12.00/hour Dependents under 17: 0 Dependents over 17: O Step 4 information: none Hire Date: 2-3-2020 DOB: 3-16 -1987 Position: Production Worker PT/FT: FT, nonexempt M/S: Married/Joint E Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 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 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 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 Assistant PT/FT: PT, nonexempt M/S: Single Pay Rate: $11.00/hour 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 Dependents under 17: 2 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales B-Lewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 deduction: $155 B-Schwa Joel Schwartz 55 Maple Farm Way Woodstock VT A5534 401(k) deduction: 4% Section 125 deduction: $155 B-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 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 Pay Rate: $32,000/year Dependents under 17: 2 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $24,000/year base plus 3% commission per case sold Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 9-18-1967 Position: Owner/President 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 Clerk PT/FT: FT, nonexempt M/S: Single Pay Rate: $34,000/year Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none Student Success Student B. Success 1644 Smitten Rd Woodstock/VT/05001 (555) 555-5555 SSN: 555-55-5555 Section 125 deduction: $100 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 $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. Exempt employee pay information is as follows: Notes Name Millen Lewis Schwartz Prevosti Annual Salary $ 35,000 $ 32,000 $ 24,000 $ 45,000 plus 3% commission on sales The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 12.00 $ 12.50 $ 11.00 $ 18.68 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours Name Filing Status Dependents Under 17 Dependents Over 17 Hourly Rate or Period No.of Regular No.of Overtime No.of Holiday Wage Hours Hours Hours Commissions Gross Earnings MJ 3 1 35 0 0 $ 0.00 $ 673.08 S 0 0 12.00000 35 0 0 MJ Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz 2 0 12.50000 0.00 0.00 35 420.00 531.25 5 0 S 0 1 11.00000 20 1 0 0.00 236.50 MJ 2 1 35 0 0 0.00 615.38 MJ 2 0 35 0 0 150.00 Toni Prevosti MJ 3 2 35 0 0 0.00 611.54 865.38 653.80 Student Success S 18.68000 35 0 0 0.00 Totals s 4.606.93 Taxable Wages Number Name and Address Thomas Millen 1022 Forest School Rd Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% Section 125 deduction: $155 Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-0974 401(k) deduction: 5% Section 125 deduction: $100 Payroll information Hire Date: 2-3-2020 DOB: 12-16-1982 Position: Production Manager 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 Worker PT/FT: FT, nonexempt M/S: Single Pay Rate: $12.00/hour Dependents under 17: 0 Dependents over 17: O Step 4 information: none Hire Date: 2-3-2020 DOB: 3-16 -1987 Position: Production Worker PT/FT: FT, nonexempt M/S: Married/Joint E Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 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 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 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 Assistant PT/FT: PT, nonexempt M/S: Single Pay Rate: $11.00/hour 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 Dependents under 17: 2 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales B-Lewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% Section 125 deduction: $155 B-Schwa Joel Schwartz 55 Maple Farm Way Woodstock VT A5534 401(k) deduction: 4% Section 125 deduction: $155 B-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 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 Pay Rate: $32,000/year Dependents under 17: 2 Dependents over 17: 1 Step 4 information: none Hire Date: 2-3-2020 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt M/S: Married/Joint Pay Rate: $24,000/year base plus 3% commission per case sold Dependents under 17: 2 Dependents over 17: 0 Step 4 information: none Hire Date: 2-3-2020 DOB: 9-18-1967 Position: Owner/President 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 Clerk PT/FT: FT, nonexempt M/S: Single Pay Rate: $34,000/year Dependents under 17: 0 Dependents over 17: 0 Step 4 information: none Student Success Student B. Success 1644 Smitten Rd Woodstock/VT/05001 (555) 555-5555 SSN: 555-55-5555 Section 125 deduction: $100 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 $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. Exempt employee pay information is as follows: Notes Name Millen Lewis Schwartz Prevosti Annual Salary $ 35,000 $ 32,000 $ 24,000 $ 45,000 plus 3% commission on sales The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Success (You) Hourly rate $ 12.00 $ 12.50 $ 11.00 $ 18.68 Hours worked 2/3-2/7 35 hours 40 hours 21 hours 35 hours