Employee ID Name and Address Payroll information A-Mille Thomas...

Employee ID	Name and Address	Payroll information
A-Mille	Thomas Millen  1022 Forest School Rd  Woodstock, VT 05001  802-478-5055  SSN: 031-11-3456  401(k) deduction: 3%	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
A-Towle	Avery Towle  4011 Route 100  Plymouth, VT 05102  802-967-5873  SSN: 089-74-0974  401(k) deduction: 5%	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
A-Long	Charlie Long  242 Benedict Road  S. Woodstock, VT  05002  802-429-3846  SSN: 056-23-4593  401(k) deduction: 2%	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
B-Shang	Mary Shangraw  1901 Main Street #2  Bridgewater, VT 05520  802-575-5423  SSN: 075-28-8945  401(k) deduction: 3%	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
B-Lewis	Kristen Lewis  840 Daily Hollow Road  Bridgewater, VT 05523  802-390-5572  SSN: 076-39-5673  401(k) deduction: 4%	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
B-Schwa	Joel Schwartz  55 Maple Farm Way  Woodstock, VT 05534  802-463-9985  SSN: 021-34-9876  401(k) deduction: 5%	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
B-Prevo	Toni Prevosti  10520 Cox Hill Road  Bridgewater, VT 05521  802-673-2636  SSN: 055-22-0443  401(k) deduction: 6%	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.


You (Student F Success) have been hired to start on February 9, 2015, as the new accounting clerk. Your employee number is B-XXXXX, where "B" denotes that you are an office worker and "XXXXX" is the first five letters of your last name. If your last name is fewer than five letters, use the first few letters of your first name to complete the employee number. Your Social Security number is 555-55-5555, and you are full-time, nonexempt, and paid at a rate of $34,000 per year. You have elected to contribute 2% of your gross pay to your 401(k). Complete the W-4 and the I-9 to start your own employee file. You are single with only one job (claiming two exemptions). You live at 1644 Smitten Road, Woodstock, VT 05001. Your date of birth is 01/01/1991. Your phone number is [phone]. You are a citizen of the United States and provide a Vermont driver's license #88110009 expiring 1/1/2017 in addition to your Social Security card for verification of your identity.

The hours for the nonexempt employees are as follows: 

Name	Hourly rate	Hours worked 2/9-2/13/15
Towle	$12.00	35 hours
Long	$12.50	40 hours
Shangraw	$10.50	21 hours
Student F Success	$18.68 ($34,000 annual salary/26 pay periods/70 hours per pay period)	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 2/14-2/27
Towle	$12.00	80 hours
Long	$12.50	70 hours
Shangraw	$10.50	42 hours
Student F Success	$18.68	71 hours

 -(NOTE): Enter all dates in mm/dd/yyyy format. Do not round intermediate computations and round final answers to two decimal places.  

SOME OF THE EMPLOYEES HAVE WRONG ANSWERS IN THE BOXES.  I ATTEMPTED TO GET THE RIGHT ANSWERS BUT  I FAILED :( SAD PANDA 

I have attached the employees as a file. It seemed to be easier that way. If not I'm sorry. Thank you very much for all the help.