Question
Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee NumberName and AddressPayroll informationA-Mille Thomas
Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff:
Employee
NumberName and AddressPayroll informationA-MilleThomas MillenHire Date: 2-1-20171022 Forest School RdDOB: 12-16-1982Woodstock, VT 05001Position: Production Manager802-478-5055PT/FT: FT, exemptSSN: 031-11-3456No. of Exemptions: 4401(k) deduction: 3%M/S: MPay Rate: $39,500/yearA-TowleAvery TowleHire Date: 2-1-20174011 Route 100DOB: 7-14-1991Plymouth, VT 05102Position: Production Worker802-967-5873PT/FT: FT, nonexemptSSN: 089-74-0974No. of Exemptions: 1401(k) deduction: 5%M/S: SPay Rate: $10.80/hourA-LongCharlie LongHire Date: 2-1-2017242 Benedict RoadDOB: 3-16-1987S. Woodstock, VT 05002Position: Production Worker802-429-3846PT/FT: FT, nonexemptSSN: 056-23-4593No. of Exemptions: 2401(k) deduction: 2%M/S: MPay Rate: $12.00/hourB-ShangMary ShangrawHire Date: 2-1-20171901 Main Street #2DOB: 8-20-1994Bridgewater, VT 05520Position: Administrative Assistant802-575-5423PT/FT: PT, nonexemptSSN: 075-28-8945No. of Exemptions: 1401(k) deduction: 3%M/S: SPay Rate: $9.80/hourB-LewisKristen LewisHire Date: 2-1-2017840 Daily Hollow RoadDOB: 4-6-1960Bridgewater, VT 05523Position: Office Manager802-390-5572PT/FT: FT, exemptSSN: 076-39-5673No. of Exemptions: 3401(k) deduction: 4%M/S: MPay Rate: $34,700/yearB-SchwaJoel SchwartzHire Date: 2-1-201755 Maple Farm WayDOB: 5-23-1985Woodstock, VT 05534Position: Sales802-463-9985PT/FT: FT, exemptSSN: 021-34-9876No. of Exemptions: 2401(k) deduction: 5%M/S: MPay Rate: $26,250/year base plus3% commission per case soldB-PrevoToni PrevostiHire Date: 2-1-201710520 Cox Hill RoadDOB: 9-18-1967Bridgewater, VT 05521Position: Owner/President802-673-2636PT/FT: FT, exemptSSN: 055-22-0443No. of Exemptions: 5401(k) deduction: 6%M/S: MPay Rate: $51,300/yearStudent SuccessStudent B. SuccessHire Date: 2-1-20171644 Smitten RdDOB: 1-1-1991Woodstock/VT/05001Position:555-555-5555PT/FT: PT, nonexemptSSN: 555-55-5555No. of Exemptions: 2M/S: SPay Rate: $24,024/year
The departments are as follows:
Department A: Agricultural Workers
Department B: Office Workers
Part 1
The first day of work for Prevosti Farms and Sugarhouse for all employees is February 6, 2017. February 10 is the end of the first pay period and includes work completed during the week of February 6-10. Compute the employee gross pay using 35 hours as the standard work week 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 $3,600 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.
The hours for the nonexempt employees are as follows:
NameHourly rateHours worked
2/6-2/10Towle$10.8000035 hoursLong$12.0000040 hoursShangraw$9.8000021 hoursSuccess (You)$13.2000035 hours
Required:
Complete the payroll register for the period's gross pay. Pay will be disbursed on February 13, 2017 starting with check number 6628.
-(NOTE): (Do not round intermediate computations. Round your answers for "Hourly Rate" to 5 decimal places and all other answers to 2 decimal places. Hours should be entered as whole numbers.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started