please help with all the employees

Complete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Stuffent Success Complete the Employee Information Form for Student Success. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Student Success Hire Date 2/1/2019 Address 1644 Smittin Rd Date of Birth 1/1/1991 City/State/Zip Woodstock/VT/05001 Exempt/Nonexempt Nonexempt Telephone (555) 555-5555 Married/Single (M or S) S Social Security Number 555-55-5555 Number of exemptions 2 Position Accounting Clerk Pay Rate $ 18,928.00 Year Child Care FSA amount Life Ins. Long-term Flex-time Educ. Assist. care Gym Total Benefit PILTTV COLIIIIGIOU 26 = $4.40 insurance amount per pay period. Complete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Student Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Success Complete the Employee Information Form for Thomas Millen. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Thomas Millen Hire Date 2/1/2019 Address 1022 Forest School Rd Date of Birth 12/16/1982 City/State/Zip Woodstock/VT/05001 Exempt/Nonexempt Exempt Telephone 802-478-5055 Married/Single (M or S) M Social Security Number 031-11-3456 Number of exemptions 4 Position Production Manager Pay Rate $ 36,000.00 / Year Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Total Benefit Yes NoComplete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success Complete the Employee Information Form for Mary Shangraw. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Mary Shangraw Hire Date 2/1/2019 Address 1901 Main St #2 Date of Birth 8/20/1994 City/State/Zip Bridgewater/VT/05520 Exempt/Nonexempt Nonexempt Telephone 802-575-5423 Married/Single (M or S) S Social Security Number 075-28-8945 Number of exemptions Position Administrative Assistant Pay Rate $ 9.10 hour Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Total Benefit g Kristen Lewis > Yes NoB-Lewis Kristen Lewis 840 Daily Hollow Road Hire Date: 2-1-2019 Bridgewater, VT 05523 DOB: 4-6-1960 802-390-5572 Position: Office Manager SSN : 076-39-5673 PT/FT: FT, exempt 401 (k) deduction: 4% No. of Exemptions : 3 M/S : M Pay Rate: $32, 600/year B-Schwa Joel Schwartz Hire Date: 2-1-2019 55 Maple Farm Way DOB: 5-23-1985 Woodstock, VT 05534 Position: Sales 802-463-9985 PT/FT: FT, exempt SSN: 021-34-9876 No. of Exemptions : 2 401 (k) deduction: 5% M/S : M Pay Rate: $24,500/year base plus 38 commission per case sold B-Prevo Toni Prevosti Hire Date: 2-1-2019 10520 Cox Hill Road DOB: 9-18-1967 Bridgewater, VT 05521 Position: Owner /President 802-673-2636 PT/FT: FT, exempt SSN: 055-22-0443 No. of Exemptions : 5 401 (k) deduction: 6% M/S : M Pay Rate: $46, 400/year Student Student B. Success Him: Date: 2-1-2019 Success 1644 Smitten Rd DOB: 1-1-1991 Woodstock/VT/05001 Position: Accounting Clerk (555) 555-5555 PT/FT: FT, nonexempt SSN: 555-55-5555 No. of Exemptions : 2 M/S : S Pay Rate: $18, 928/yearPrevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Number Name and Address Payroll information A-Mille Thomas Millen 1022 Forest School Rd Hire Date: 2-1-2019 Woodstock, VT 05001 DOB: 12-16-1982 802-478-5055 Position: Production Manager SSN: 031-11-3456 PT/FT: FT, exempt No. of Exemptions : 4 401 (k) deduction: 3% M/S : M Pay Rate: $36, 000/year A-Towle Avery Towle Hire Date: 2-1-2019 4011 Route 100 DOB: 7-14-1991 Plymouth, VT 05102 Position: Production Worker 802-967-5873 PT/FT: FT, nonexempt SSN: 089-74-0974 No. of Exemptions: 1 401(k) deduction: 5% M/S: S Pay Rate: $10.20/hour A-Long Charlie Long Hire Date: 2-1-2019 242 Benedict Road DOB: 3-16-1987 S. Woodstock, VT 05002 Position: Production Worker 802-429-3846 PT/FT: FT, nonexempt SSN: 056-23-4593 No. of Exemptions : 2 401(k) deduction: 28 M/S : M Pay Rate: $11. 30/hour B-Shang Mary Shangraw Hire Date: 2-1-2019 1901 Main Street #2 DOB: 8-20-1994 Bridgewater, VT 05520 Position: Administrative Assistant 802-575-5423 PT/FT: PT, nonexempt SSN: 075-28-8945 No. of Exemptions : 1 401(k) deduction: 38 M/S : S Pay Rate: $9 . 10/hourComplete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Provosti Student Success Complete the Employee Information Form for Toni Prevosti. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Toni Prevosti Hire Date 2/1/2019 Address 10520 Cox Hill Rd Date of Birth 9/18/1967 City/State/Zip Bridgewater/VT/05521 Exempt/Nonexempt Exempt Telephone 802-673-2636 Married/Single (M or S) M Social Security Number 055-22-0443 Number of exemptions 5 Position Owner/President Pay Rate $ 46,400.00 1 Year Long-term Flex-time Child Care FSA amount Educ. Assist. Life Ins. care Gym Total Benefit Complete the question by entering your answers in the tabs below. Thomas Millen |Avery Towle Charlie Long Mary Kristen Lewis Joel Schwartz |Toni Prevosti Student Shangraw Success Complete the Employee Information Form for Avery Towle. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Avery Towle Hire Date 2/1/2019 Address 4011 Route 100 Date of Birth 7/14/1991 City/State/Zip Plymouth/VT/05102 Exempt/Nonexempt Nonexempt Telephone 802-967-5873 Married/Single (M or S) S Social Security Number 089-74-0974 Number of exemptions Position Production Worker Pay Rate 10.20 1 hour Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Total Benefit Yes NoComplete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success Complete the Employee Information Form for Kristen Lewis. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Kristen Lewis Hire Date 2/1/2019 Address 840 Daily Hollow Rd Date of Birth 4/6/1960 City/State/Zip Bridgewater/VT/05523 Exempt/Nonexempt Exempt Telephone 802-390-5572 Married/Single (M or S) M Social Security Number 076-39-5673 Number of exemptions 3 Position Office Manager Pay Rate $ 32,600.00 1 Year Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Total Benefit Yes NoComplete the question by entering your answers in the tabs below. Thomas Millen Avery Towle Charlie Long Mary Shangraw Kristen Lewis Joel Schwartz Toni Prevosti Student Success Complete the Employee Information Form for Charlie Long. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) EMPLOYEE EARNINGS RECORD Name Charlie Long Hire Date 2/1/2019 Address 242 Benedict Rd Date of Birth 3/16/1987 City/State/Zip S. Woodstock/VT/05002 Exempt/Nonexempt Nonexempt Telephone 802-429-3846 Married/Single (M or S) M Social Security Number 056-23-4593 Number of exemptions 2 Position Production Worker Pay Rate $ 11.30 hour Flex-time FSA amount Educ. Assist. Life Ins. Long-term Child Care care Gym Total Benefit Yes NoAlthough the company has already established medical and retirement plan benefits, Toni Prevosti wants to consider other benefits to attract employees. As the company's accountant, you have been tasked with annotating employee earnings records with benefit elections for each employee. The gym membership is for a dedicated facility for employees and spouses. The following sheet contains details of employee choices. These costs are employer paid and will take effect on the first pay period of March. Child Care Educational Assistance Flex- (under $5,000 Assistance Life Insurance Long-Term Care Gym FSA Employee Time ($4, 000 annually ) (at 18 of annual Insurance ( $15 Membership Millen ( annual ) Yes annually ) Yes salary value) 500 .00 per period) ($15 per month) No Yes Towle No Yes No NO $ 1, 200.00 Yes No No Yes Long Yes Yes 700 . 00 Yes Yes No Yes Shangraw Yes No 200 .00 No Yes No No Lewis No No $ 1, 600 .00 No Yes Yes No Schwartz No No 450 .00 Yes Yes No Yes Prevosti Yes No 900 .00 No Yes No Yes Student No NO 300.00 Yes No No Yes Annotate the Employee Earning Records with payroll-related benefit elections. The amount per period should be included in the record. As an example, if an employee elected to contribute $1,300 to his or her FSA, the period payroll deduction would be $1,300/26, or $50. The estimated yealy earnings used to compute the life insurance deduction for the hourly employees is: (hourly wages times number of hours worked per week x 52 weeks). Multiply the yearly earnings by 1% and divide by 26 pay periods to get the insurance per pay period. Example: Employee earns $11 per hour and works 20 hours a week. ($11 x 20 x 52) = $11,440 estimated annual earnings. $11,440 x 1% = $114.40. $114.40 / 26 = $4.40 insurance amount per pay period