Question
Answered

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

Employee IDName 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 (555)555-5555. 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. 

8 Attachments
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Background image of page 1
1 page
Answer & Explanation
Verified Solved by verified expert
<p>trices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

dictum vitae odio. Donec aliquet. Lor
s a molestie consequat, ultrices ac magna.Fusce dui lect
risus ante, dapibus a molesec facilisis. Pellentesque dapibus efficitur
ipsum dolor sit amet, consectetur adipiscing eliiscing elit. Nam lacinia
iscing elit. Nam lacinia pulvinar tortor necsus ante, dapibus a molestie cons
congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsac
, ultrices acec facilisis. Pellen
inia pulvinar tortor nec faciliss ante, dapibus a molestie co
dictum vitae odio. Donec aliicitur laoreet. Nam risus a
congue vel laoreet ac, diipsum dolor sit amet, consectet
lestie consequat, ultrices ac

et, consectetur adipisci
sus ante, dapibus a molestie consequat,

psum dolor sit amet, consectetur adi

fficitur laoreet. Nam risus ante, dapibus a molestie c

, ultrices ac magna. F

m risus ante, dapibus a