Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Number Payroll information Hire Date: 2-1-2017 Name and Address A-Mille Thomas Millen 1022 Forest School Rd DOB: 12-16-1982 Woodstock, VT 05001 Position: Production Manager 802-478-5055 PT/FT: FT, exempt No. of Exemptions: 4 M/S: M Pay Rate: $35, 000/year SSN: 031-11-3456 401 (k) deduction: 3% A-Towle Avery Towle Hire Date: 2-1-2017 4011 Route 100 DOB: 7-14-1991 Plymouth, VT 05102 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $12.00/hour 802-967-5873 SSN: 089-74-0974 401 (k) deduction: 5% A-Long Charlie Long Hire Date: 2-1-2017 242 Benedict Road DOB: 3-16-1987 s. Woodstock, VT 05002 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 2 M/S: M Pay Rate: $12.50/hour 802-429-3846 SSN: 056-23-4593 401 (k) deduction: 2% B-Shang Mary Shangraw 1901 Main Sstreet #2 Hire Date: 2-1-2017 DOB: 8-20-1994 Bridgewater, VT 05520 Position: Administrative Assistant PT/FT: PT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $10.50/hour 802-575-5423 SSN: 075-28-8945 401 (k) deduction: 3% B-Lewis Kristen Lewis Hire Date: 2-1-2017 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 DOB: 4-6-1960 Position: Ooffice Manager PT/FT: FT, exempt No. of Exemptions: 3 M/S: M Pay Rate: $32,000/year SSN: 076-39-5673 401 (k) deduction: 4% B-Schwa Joel Schwartz Hire Date: 2-1-2017 55 Maple Farm Way Woodstock, VT 05534 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt No. of Exemptions: 2 M/S: M 802-463-9985 SSN: 021-34-9876 401 (k) deduction: 5% Pay Rate: $24,000/year base plus 3% Commission on Sales B-Prevo Toni Prevosti Hire Date: 2-1-2017 10520 Cox Hill Road DOB: 9-18-1967 Bridgewater, VT 05521 Position: Owner/President PT/FT: FT, exempt No. of Exemptions: 5 M/S: M Pay Rate: $45,000/year 802-673-2636 SSN: 055-22-0443 401 (k) deduction: 6% Hire Date: 2-1-2017 B-Student Student Success 1644 Smitten Road DOB: 1-1-1991 Woodstock, VT 05001 Position: Accounting clerk PT/FT: FT, nonexempt 555-555-5555 SSN: 555-55-5555 401 (k) deduction: 2% No. of Exemptions: 2 M/S: S Pay Rate: $34,000/year The departments are as follows: Department A: Agricultural Workers Department B: Office Workers Initial pre-tax deductions for each employee are as follows: Name Deduction Thomas Millen Insurance: $155/paycheck 401 (k): 3% of gross pay Marital Status: Married Avery Towle Insurance: $100/paycheck 401 (k): 5% of gross pay Marital Status: Single Charlie Long Insurance: $155/paycheck 401 (k): 2% of gross pay Marital Status: Married Insurance: $100/paycheck 401 (k): 3% of gross pay Marital Status: Single Mary Shangraw Kristen Lewis Insurance: $155/paycheck 401 (k): 4% of gross pay Marital Status: Married Insurance: $100/paycheck 401 (k): 5% of gross pay Joel Schwartz Marital Status: Married Insurance: $155/paycheck 401 (k): 6% of gross pay Marital Status: Married Toni Prevosti Student Success Insurance: $100/paycheck 401 (k): 2% of gross pay Marital Status: Single 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 for Prevosti Farms and Sugarhouse and includes work completed during the week of February 6-10. Using the payroll register, compute the employee gross pay and net 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 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. Federal withholding tax should be computed using the wage-bracket tables in Appendix C. State witholding tax for Vermont is computed at 3.55 percent of taxable wages (i.e., gross pay less pre-tax deductions). February 24, 2017, is the end of the final pay period for the month. Schwartz has sold $7,500 of product during this pay period at a 3 percent commission. Pay will be disbursed on February 27, 2017, and check numbers will continue from prior payroll. The hours for the nonexempt employees are as follows: Hours worked 2/6-2/10 35 hours Hourly rate $12.00000 $12.50000 $10.50000 Name Towle 40 hours Long Shangraw Success (You) 21 hours $18.68132 35 hours Name Towle Hours worked 2/13-2/24 80 hours Hourly rate $12.00000 $12.50000 $10.50000 $18.68132 70 hours Long Shangraw Success (You) 42 hours 71 hours Required: Complete the payroll register for this pay period and update the Employee Earnings Record form for each employee with the corresponding information. Ensure to input an hourly rate for each employee (including those that are salaried) that is rounded to 5 decimal places. Benefit-related payroll deductions will take effect on the first pay period of March. Educational assistance $4,000 annually Child care Long-term care insurance $15 per period No assistance Life insurance (at 1% of annual salary value) Gym membership $15 per month Flex- (under $5,000 annually) FSA Employee time Millen (annual) Yes Yes 500.00 No Yes Yes $ 1,200.00 700.00 Towle No No Yes No No Yes Yes No Yes Long Shangraw Lewis Yes Yes Yes Yes No 200.00 No Yes No No No No $ 1,600.00 No Yes Yes No Schwartz No 450.00 900.00 No Yes Yes No Yes Prevosti Yes No No Yes No Yes Student No No 300.e0 Yes No No Yes 022417 Update the Employee Earnings Record form for Thomas Millen with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermedlate computations and final answers to 2 decimal places. Hours should be EMPLOYEE EARNINGS RECORD Name Thomas Millen 1022 Forest School Rd Woodstock/VT/05001 802-478-5055 Hire Date 2/1/2017 Address City/State/Zip Telephone Social Security Number Date of Birth 12/16/1982 Exempt/Nonexempt Married/Single (M or S) Number of exemptions Exempt IM 031-11-3456 4 Pay Rate (Hourly. Yearly, Yearly + Commission) Position Production Manager 535,000/year Flex time Child Care FSA amount Educ Assist Lifa Ins Lang-tem care Gym Yas Yes $500 00 No Yes No Yes Fes Total Hours Worked (Reg +O.T. Long-term Care Taxable Pay Taxable Pay (Federal) Rag Pay OT Pay Commissions Gross Pay 401(k) Child Care FSA Educ. Assiet Life Ins Period Ended Holiday Pay Insurance (FICA) + O.T.) 2/10/2017 35 0.00 2/24/2017 35 0.00 State Income Taxable Pey (Federal) Taxable Pey (FICA) Federal Income Tax Social Security Tax Total Deductions Perlod Ended Medicare Gym Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 2/24/2017