I need help completing this mainly with hourly rate and gross...

I need help completing this mainly with hourly rate and gross profit!

Thomas Millen

1022 Forest School Rd Woodstock, VT 05001

802-478-5055

SSN: 031-11-3456

401(k) deduction: 3%

Section 125 deduction: $155

Hire Date: 2-3-2020

DOB: 12-16-1982

Position: Production Manager

PT/FT: FT, exempt

M/S: Married/Joint

Pay Rate: $39,500/year

Dependents under 17: 3

Dependents over 17: 1

Step 4 information: none

Avery Towle

4011 Route 100 Plymouth, VT 05102

802-967-5873

SSN: 089-74-0974

401(k) deduction: 5%

Section 125 deduction: $100

Hire Date: 2-3-2020

DOB: 7-14-1991

Position: Production Worker

PT/FT: FT, nonexempt

M/S: Single

Pay Rate: $10.80/hour

Dependents under 17: 0

Dependents over 17: 0

Step 4 information: none

Charlie Long

242 Benedict Road S. Woodstock, VT 05002

802-429-3846

SSN: 056-23-4593

401(k) deduction: 2%

Section 125 deduction: $155

Hire Date: 2-3-2020

DOB: 3-16-1987

Position: Production Worker

PT/FT: FT, nonexempt

M/S: Married/Joint

Pay Rate: $12.00/hour

Dependents under 17: 2

Dependents over 17: 0

Step 4 information: none

Mary Shangraw

1901 Main Street #2 Bridgewater, VT 05520

802-575-5423

SSN: 075-28-8945

401(k) deduction: 3%

Section 125 deduction: $100

Hire Date: 2-3-2020

DOB: 8-20-1994

Position: Administrative

Assistant

PT/FT: PT, nonexempt

M/S: Single

Pay Rate: $9.80/hour

Dependents under 17: 0

Dependents over 17: 1

Step 4 information: none

Kristen Lewis

840 Daily Hollow Road Bridgewater, VT 05523

802-390-5572

SSN: 076-39-5673

401(k) deduction: 4%

Section 125 deduction: $155

Hire Date: 2-3-2020

DOB: 4-6-1960

Position: Office Manager

PT/FT: FT, exempt

M/S: Married/Joint

Pay Rate: $34,700/year

Dependents under 17: 2

Dependents over 17: 1

Step 4 information: none

Joel Schwartz

55 Maple Farm Way Woodstock, VT 05534

802-463-9985

SSN: 021-34-9876

401(k) deduction: 5%

Section 125 deduction: $100

Hire Date: 2-3-2020

DOB: 5-23-1985

Position: Sales

PT/FT: FT, exempt

M/S: Married/Joint

Pay Rate: $26,250/year base plus

3% commission per case sold

Dependents under 17: 2

Dependents over 17: 0

Step 4 information: none

Toni Prevosti

820 Westminster Road Bridgewater, VT 05520

802-555-3456

SSN: 055-22-0443

401(k) deduction: 6%

Section 125 deduction: $155

Hire Date: 2-3-2020

DOB: 9-18-1967

Position: Owner/President

PT/FT: FT, exempt

M/S: Married/Joint

Pay Rate: $51,300/year

Dependents under 17: 3

Dependents over 17: 2

Step 4 information: none

 

Student B. Success

1644 Smitten Rd Woodstock/VT/05001

[phone]

SSN: 555-55-5555

Section 125 deduction: $100

 Hire Date: 2-3-2020

DOB: 1-1-1991

Position: Accounting Clerk

PT/FT: FT, nonexempt

M/S: Single

Pay Rate: $24,024/year

Dependents under 17: 0

Dependents over 17: 0

Step 4 information: none

Image transcription text

February 21, 2020, is the end of the final pay period of the month and includes work completed during the weeks of February 10-14 and 17-21. 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. The other hourly employees receive overtime pay when they work more than 35 hours in one week. Joel Schwartz has sold $5,400 of product during this pay period at a 3 percent commission. Remember that the employees are paid biweekly. The hours for the nonexempt employees are as follows: Hours worked 2/10- Name Hourly rate 2/21 Towle $ 10.80 30 hours Long $ 12.00 70 hours Shangraw $ 9.80 42 hours Success (You) $ 13.20 70 hours Required: Complete the payroll register for the period's gross pay. Pay will be disbursed on February 26, 2020. Check numbers will continue from the prior payroll period. (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.) P/R End Date 2/21/2020 Company Name: Prevosti Farms and Sugarh Check Date 2/26/2020 No. of Dependents No. of Regular Name Overtime No. of Holiday Filing Status Dependents Hourly Rate or Commissions Gross Earnings Under 17 Over 17 Period Wage Hours Hours Hours Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success

... Show more