Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I would gladly appreciate it if you could explain how to figure out the life insurance and the gym calculation. Chapter 4 - Continuing Payroll
I would gladly appreciate it if you could explain how to figure out the life insurance and the gym calculation.
Chapter 4 - Continuing Payroll Project 6 Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: 100 points Employee Number Name and Address Payroll information A-Mille eBook Thomas Millen Hire Date: 2-1-2019 1022 Forest School DOB: 12-16-1982 Position Production Woodstock, VT 05001 Manager 802-479-5055 PT/FT: FI, exempt SSN: 031-11-3456 No. of Exemptions: 4 401(k) deduction 36 M/S: M Pay Rate: $35,000/year Print References A-Towle Avery Towe Hire Date: 2-1-2019 4011 Route 100 DOB: 7-14-1991 Position: Production Plymouth, VT 05102 Worker 802-967-5873 PT/FTI TI, nonexempt SSN: 089-74-0974 No. of Exemptions! 1 401(k) deduction: 56 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 Hire Date: 2-1-2019 DOB: 3-16-1987 Position Production Worker PT/FTI TI, nonexempt No. of Exemptions: 2 M/S: M Pay Rate: $12.50/hour 26 B-Shang Mary Shangraw Hire Date 2-1-2019 1901 Main Street #2 DOB: 8-20-1994 Bridgewater, VT Position: Administrative 05520 Assistant 802-575-5423 PT/FTI PT nonexempt SSN: 075-28-9945 No. of Exemptions! 1 401(k) deduction: 36 M/S: S Pay Rate: $11.00/hour B-Lewis Kristen Lewis Hire Datei 2-1-2019 840 Daily Hollow DOB: 4-6-1960 Road Bridgewater, VT Position Office Manager 05523 802-390-5572 PT/ETI PT, exempt SSN: 076-39-5673 No. of Exemptions: 3 401(k) deduction: 46 M/S: M Pay Rate: $32,000/year B-Schwa Joel Schwartz Hire Date: 2-1-2019 55 Maple Tarm Way DOB: 5-23-1985 Woodstock, VT 05534 Position: Sales 802-463-9985 PT/FTI TT, exempt SSN: 021-34-9876 No. of Exemptions! 2 401(k) deduction: 56 M/S: M Pay Rates $24,000/year base plus 38 commission per case sold Chapter 4 - Continuing Payroll Project B-Prevo 100 Toni Prevosti Hire Date: 2-1-2019 10520 Cox Hill Road DOB: 9-18-1967 Bridgewater, VT Position: 05521 Owner/President 802-673-2636 PT/FTI TT, exempt SSN: 055-22-0443 No. of Exemptions: 5 401(k) deduction: 66 M/S: M Pay Rate: $45,000/year points eBook Student Success Student B. Success 1644 Smitten Rd Print Woodstock/VT/05001 (555) 555-5555 SSN: 555-55-5555 Hire Date: 2-1-2019 DOB: 1-1-1991 Position Accounting clerk PT/ETI PT, nonexempt No. of Exemptions: 2 M/S: S Pay Rate: $34,000/year References The departments are as follows: Department A Agricultural Workers Department B: Office Workers The first day of work for Prevosti Farms and Sugarhouse for all employees is February 4, 2019. February 8 Is the end of the first pay period and includes work completed during the week of February 4-8. 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 recelves 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 the 2/9 pay period. Joel Schwartz's sales are subject to commissions for the 2/22 pay period of $7,500. 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 blweekly. Name Notes Millen Annual Salary $35,000 $32,000 $24,000 Lewis Schwartz plus 36 Commission on Sales Prevosti $45,000 The hours for the nonexempt employees are as follows: Nours worked 2/4-2/8 Name Towle Hourly rate $12.00000 hours Long $12.50000 hours Shangra $11.00000 hours Success $18.68132 (You) hours worked 2/11-2/22 Name Towle Hourly rate $12.00000 hours Long $12.50000 hours Shangra $11.00000 hours $18.68132 Success (You) hours Although the company has already established medical and retirement plan benefits, Toni Prevostl 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 following sheet contains details of employee choices These costs are employer paid and will take effect on the first pay period of March. Chapter 4 - Continuing Payroll Project Saved Name Towle Houray rate $12.00000 4/11-2/22 hours Long $12.50000 hours 100 points Shangra $11.00000 hours $18.68132 Success (You) hours eBook Although the company has already established medical and retirement plan benefits, Toni Prevostl 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 following sheet contains details of employee choices These costs are employer paid and will take effect on the first pay period of March Print References Flex- Employee Tine annually) Life Child Care Insurance Long-Term Assistance Educational at 11 of Care Gym under Assistance annual Insurance Membership $5,000 FSA ($4,000 salary ($15 per ($15 per (annual) annually) value) period) month) Yes $ 500.00 No $1,200.00 No Yes $ 700.00 Yes Yes YE No $ 200.00 No Yes $1,500.00 Yes No $ 450.00 Yes Yes No $ 900.00 Yes No $ 300.00 Yes Yes Millen Yes Towle No Long Yes Shangra Yes Lewis No Schwartz No Prevosti Yes Student No Yes No NO 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 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. ($1120 x 52) = $11.440 estimated annual earnings. $11,440 * 1% = $114.40. $114.40 / 26 = $4.40 Insurance amount per pay period. Complete the question by entering your answers in the tabs below. Thomas Avery Charlie Mary Kristen Joel Toni Student Millen Towle Long Shangraw Lewis Schwartz Prevosti 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 IName Student Success Hire Date 2/1/2019 Address I 1644 Smittin Rd Date of Birth 1/1/1991 City/State/Zip Woodstock/VT/05001 Exempt/Nonexempt Nonexempt Telephone (555) 555-5555 Married Single (Mors S) Number of Social Security Number 555-55-5555 exemptions Position Accounting Clerk Pay Rate $ 34,000.00 1 Year Child FSA Flex-time Educ. Total Long- Care amount Assist. yh Benefit TS 11.54 Yes te Inserm care Gym NoStep 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