Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Form I9 page 1 and page 2 for Student B Success 2 Employee Information Form 1 Employee Number AMille Department Agricultural Workers Name Tho... View the full answer
Related Book For
Payroll Accounting 2018
ISBN: 978-1259742514
4th edition
Authors: Jeanette Landin, Paulette Schirmer
Posted Date:
Students also viewed these finance questions
-
What follows is the employee earnings record for Sean Steverman of Charles Cleaners. Record his earnings from the July 145 pay in P7-1A. In Problem P7-1A Charles Merrill owns a housekeeping service,...
-
Below is the Employee Earnings Record for Ally Murner of Cosmic Comics. Record her earnings on the September 15, 2017 pay from P7-1B. In P7-1B Tony Stanford owns Cosmic Comics in Greensboro, NC. For...
-
Below is the Employee Earnings Record for Sean Steverman of Charles' Cleaners. Annotate the record for his earnings on the July 12 pay.
-
In 2022, XYZ issued, at par, 75 1,000 K.D, 10% bonds, each convertible into 100 ordinary shares. The liability component of convertible bonds was 950 K.D per bond. XYZ had revenues of 24,800 K.D and...
-
Use a binomial lattice with the following attributes to value an American put option. (a) Current underlying asset value of 40 (b) Exercise price of 45 (c) Volatility of 30% (d) Risk-free rate of 5%...
-
Dehydrohalogenation of the diastereomeric forms of 1-chloro-1,2-diphenylpropane is stereospecific. One diastereomer yields (E )-1,2-diphenylpropene, and the other yields the Z isomer. Which...
-
The case of flow past a cylinder of infinite length normal to the axis was also studied by Stokes. In view of the 2D nature of the problem, it is more convenient to work in \(r, \theta\) coordinates....
-
In the transformer shown in Figure P33.47, the load resistor is 50.0 Ω. The turns ratio N1:N2 is 5:2, and the source voltage is 80.0 V (rms). If a voltmeter across the load measures 25.0 V...
-
Case Study Read the FedEx Office Case before you begin this assignment. For this assignment, you will identify and fully analyze a minimum of three problems that the FedEx Office representative can...
-
Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social Security number is 111-11-1112, and Freida's is...
-
word meidimotiomed ants 101 10 9. Is there an isomorphism op such that p(2) = 15. Complete the mapping if possible or show why it is not possible. (p: Z10 U(Z22) - (15 points) + ENTO 0 10. 1 2 3 4...
-
A physician submits a claim for three different procedures, and all but the first one are denied. What could a coder advise to get all procedures paid?
-
An owner wants to always know the number of units in inventory. What inventory system should the owner use?
-
What is the Project Management Body of Knowledge? What is the PM Competency Development Framework? What is the Talent Triangle? What is the difference between practice standards and practice guides?
-
1. Given the following information about ABC corporation: Security Book Value Amount ($ millions) Common Stock Preferred Stock Bonds Retained Earnings Total 10 5 2 22 The common stock is currently...
-
A contractor operates a rock crusher and stores the material until needed in an adjacent stockpile area. The stockpile area is unpaved, and some of the produced material is contaminated by the...
-
A combustion gas mixture of oxygen and hydrogen at 3466 K and 10.34 MPa (1500 psi) has the composition shown in the table below. The figure below shows that expanding these gases to an exit pressure...
-
Find the APR in each of the following cases: NUMBER OF TIMES COMPOUNDED Semiannually Monthly Weekly Infinite EAR APR 10.4% 8.9 11.6 15.4
-
Leda Inc. is located at 433 Augusta Road, Caribou, Maine, 04736, phone number 201-555-1212. The Federal EIN is 54-3910394, and it has a Maine Revenue Services number of 3884019. Owner Amanda Leda has...
-
Peaceful Cat Pet Foods is a new business owned by Sylvester Hammond. His first year of operation commenced on June 1, 2017. What schedule depositor would his company be for the first year of...
-
MATCH THE FOLLOWING TERMS WITH THEIR DEFINITIONS: Manual payroll Time card Payroll administration using a paper payroll register Paycard A pre-loaded credit card used to pay employees Employee...
-
Personalized medicine may be used a. to characterize types of tumors. b. to predict the outcome of certain types of cancers. c. to determine the proper dosage of drugs. d. in all of the above.
-
Tumor-suppressor genes promote cancer when a. they are overexpressed. b. they are expressed in the wrong cell type. c. their function is inactivated. d. they are expressed at the wrong stage of...
-
Which of the following is a type of genetic change that could produce an oncogene? a. Missense mutation b. Gene amplification c. Chromosomal translocation d. All of the above can produce an oncogene.
Study smarter with the SolutionInn App