I need help filling out the employee record for these three employees, I have the rest of the problem figured out.

Kristen Lewis Joel Schwartz Toni Prevosti

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Number A-Mille Name and Address Thomas Millen 1022 Forest School Rd Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% A-Towle Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-0974 401(k) deduction: 5% A-Long Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 401(k) deduction: 2% B-Shang Mary Shangraw 1901 Main Street #2 Bridgewater, VT 05520 802-575-5423 SSN: 075-28-8945 401(k) deduction: 3% B-Lewis Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% B-Schwa Joel Schwartz 55 Maple Farm Way Woodstock, VT 05534 802-463-9985 SSN: 021-34-9876 401(k) deduction: 5% B-Prevo Toni Prevosti 10520 Cox Hill Road Bridgewater, VT 05521 802-673-2636 SSN: 055-22-0443 401(k) deduction: 6% Payroll information Hire Date: 2-1-2015 DOB: 12-16-1982 Position: Production Manager PT/FT: FT, exempt No. of Exemptions: 4 M/S: M Pay Rate: $35,000/year Hire Date: 2-4-2015 DOB: 7-14-1991 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $12.00/hour Hire Date: 2-7-2015 DOB: 3-16-1987 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 2 M/S: M Pay Rate: $12.50/hour Hire Date: 2-5-2015 DOB: 8-20-1994 Position: Administrative Assistant PT/FT: PT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $10.50/hour Hire Date: 2-2-2015 DOB: 4-6-1950 Position: Office Manager PT/FT: FT, exempt No. of Exemptions: 3 M/S: M Pay Rate: $32,000/year Hire Date: 2-1-2015 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt No. of Exemptions: 2 M/S: M Pay Rate: $24,000/year base plus 3% commission on case sales Hire Date: 2-1-2015 DOB: 9-18-1967 Position: Owner/President PT/FT: FT, exempt No. of Exemptions: 5 M/S: M Pay Rate: $45,000/year The Departments are as follows: Department A: Agricultural Workers Department B: Office Workers February 16 is the first pay date for Prevosti Farms and Sugarhouse and includes work completed during the week of February 9-13. 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 made $5,000 in case sales during this pay period. Remember that the employees are paid biweekly. The first day of work for Prevosti Farms and Sugarhouse for all employees is February 9, 2015. Note that the first pay period comprises only one week of work, but the pay frequency for Federal income tax purposes is biweekly. The hours for the nonexempt employees are as follows: Name Towle Long Shangraw Student F Success Hourly rate $12.00 $12.50 $10.50 $18.68 ($34,000 anuual salary/26 pay periods/70 hours per pay period) Hours worked 2/9-2/13/15 35 hours 40 hours 21 hours 35 hours Update the Employee Earning record for the period's pay and the new YTD amount. February 27, 2015, is the final payday for the month. Compute the employee gross pay and update the Employee Earning Record with the February 27 pay and the new YTD amount. Schwartz has sold $7,500 of product during this pay period. The hours for the nonexempt employees are as follows: Name Hourly rate Hours worked Towle Long Shangraw Student F Success 2/14-2/27 80 hours 70 hours 42 hours 71 hours $12.00 $12.50 $10.50 $18.68 -(NOTE): Enter all dates in mm/dd/yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student F Success NAME Thomas Millen HIRE DATE 02/01/2015 ADDRESS 1022 Forest School Rd. DATE OF BIRTH 12/16/1982 M CITY/STATE/ZIP Woodstock/ VT/05001 POSITION Production Manager FT TELEPHONE 802-478-5055 NO. OF EXEMPTIONS 4 SOCIAL SECURITY 031-11-3456 NUMBER Period Hrs. Worked Reg. Pay Ended PAY RATE O.T. Pay Gross Pay 02/13/2015 0.00 02/27/2015 0.00 Social Sec. Tax Medicare Tax Fed. Inc. Tax previous State Inc. Tax $35,000 per year next rev: 03_07_2016_QC_CS-42315, 09_10_2016_QC_CS-60271 References eBook & Resources Employee Information Form Learning Objective: 03-02 Compute Gross Pay for Different Pay Bases Difficulty: 2 Medium Learning Objective: 03-03 Calculate Pay Based on Hours and Fractions of Hours Learning Objective: 03-01 Analyze Minimum Wage Pay for Nonexempt Workers Learning Objective: 03-04 Apply Combination Pay Methods Check my work Learning Objective: 03-05 Explain Special Pay Situations SDI 401(k) Other