3 4 Wayland Custom Woodwork "Wayland" is a firm that manufactures custom cabinets and woodwork for business and residential 5 customers. Students will have the opportunity to establish payroll records and to complete payroll compensation information for 6 Wayland. All employees are on October 1, 2019. 8 Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is 9 Mark Wayland. Wayland's EIN is 91-7444533, and the Utah Employer Account Number is 99992901685WTH. Wayland has 10 determined it will pay their employees on a semimonthly basis. 7 11 12 13 Rounding can create a challenge. For these exercises, the rate for the individuals is not rounded. So take their salary and divide by 14 2,080 (52 weeks at 40 hours per week) for full time, nonexempt employees. For example, Varden's salary is $42,000 and is a 15 nonexempt employee, so the calculation will be $42,000/2,080, which would give you $20.19231 per hour. 16 17 23 18 Exempt employees salaries are divided by 24, which is the number of payroll periods with a semi-monthly pay frequency. This can 19 lead to over 80 hours in a standard pay period without overtime available to nonexempt employees. For holiday pay, determine the 20 number of hours that are holiday pay and multiply it by the hours worked. For weeks with more than 80 hours, you will need to divide 21 the total hours for the pay period by the period salary. For example, if there are 16 hours of holiday during an 80 hour pay period for 22 Chinson, $1,000 X (16/80) - $200 holiday wages and $1,000 x (64/80) $800 regular wages. 24 After the gross pay has been calculated, round the result to only two decimal points on the Payroll Register and Employee 25 Earnings Records. 27 Employees are paid for the following holidays occurring during the final quarter: Thanksgiving day and the day after, Thursday and Friday November 28-29 Christmas, which is a Wednesday. Employees receive holiday pay for Tuesday, December 24, and Wednesday, December 25. 26 28 29 30 31 D E 1 October 11 2 Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The 3 following employees comprise Wayland's staff: 4 Payroll information Employee Name and Address 5 Number 6 00-Chins Anthony Chinson 7 530 Sylvann Avenue 8 Logan, UT 84321 9 435-555-1212 10 Job title: Account Executive 11 00-Wayla Mark Wayland 12 1570 Lovett Street 13 Logan, UT 84321 435-555-1110 15 Job title: President/Owner 16 01-Peppi Sylvia Peppinico 17 291 Antioch Road 18 Logan, UT 84321 19 435-555-2244 20 Job title: Craftsman 21 01-Varde Stevon Varden 22 333 Justin Drive 23 Logan, UT 84321 24 435-555-9981 25 Job title: Craftsman 26 02-Hisso Leonard Hissop 27 531 5 Street 28 Logan, UT 84321 29 435-555-5858 30 Job title: Purchasing Shipping 31 32 Department 00: Sales and Administration 33 Department 01: Factory workers 34 Department 02: Delivery and Customer service 35 Married, 1 withholding allowance Exempt $24,000/year + commission Start Date: 10/1/2019 SSN: 511-22-3333 Married, 5 withholding allowances Exempt $75,000/year Start Date: 10/1/2019 SSN: 505-33-1775 Married, 7 withholding allowances Exempt $43,500/year Start Date: 10/1/2019 SSN: 047-55.9951 Married, 2 withholding allowances Nonexempt $42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 Single, 4 withholding allowances Nonexem $49,500/year Start Date: 10/1/2019 SSN: 311-22-6698 s. 1. You have been hired as of October 1 as the new accounting clerk. Your employee number is 00-SUCCE. Your name is STUDENT SUCCESS. Your address is 1650 South Street, Logan, UT 84321. Your phone number is 435-556-1211, you were born July 16, 1985, your Utah driver's license number is 887743 expiring in 7/2024, and your Social Security number is 555-55-5555. You are nonexempt and paid at a rate of $36,000 36 per year. You contribute 3 percent to a 401(k), and health insurance is $50 per pay period. 37 Employer Info Employee hire info Oct 15 pay info Payroll Register Oct 15 Oct 31 pay info Count: 64 Microsoft Excel October 15: 2 pp 1 3 October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 18, 2019. Any time worked in excess of 88 hours during this pay period is considered 4 overtime for nonexempt employees. Remember that the employees are paid on a semimonthly basis. 5 6 The hours for the employees are as follows: 7 Name Hourly rate Pay Period Hours Regular Overtime Commission (round to 5 10/1-10/15 (round to 2 (round to 2 8 decimals) decimal) decimal) 9 Chinson 88 hours (exempt $ 1,500.00 10 Wayland 88 hours (exempel 11 Peppinico 88 hours (exempt) 12 Varden 88 hours 13 Hissop 93.25 hours 14 You 90 hours 15 16 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. 17 Complete the Payroll Register for October 15. Round wages to five decimal points and all other final answers to two decimal points. 18 Update the Employees' Earning Records for the period's pay and update the YTD amount. 19 Insurance qualifies for Section 125 treatment 20 21 22 Voluntary doductions for each employee are as follows: 23 Name Deduction October 24 Insurance: 550/paycheck 25 Chinson 401(k): 3% of gross PBY Sunday Monday Tuesday Wednesday 2 26 Insurance: $75/paycheck 7 9 27 Wayland 401(6):6% of gross pay 15 16 28 Insurance: $75/paycheck 20 21 22 23 29 Peyninico 401(k): 550 per paycheck 27 28 29 30 30 Insurance: $50/paycheck 31 Varden 401(k): 4% of gross pay 32 Insurance: $75/paycheck 401(k): 3% of gross pay 34 Insurance Silpaycheck 35 Student 401(k): 3% of gross PBY 36 Friday 6 Thursday 3 10 17 24 31 Saturday 5 12 19 26 11 18 25 14 39 40 41 42 Employer Info + Employee hire info Oct 15 pay into Payroll Register Oct 15 Oct 31 pay info Payroll Register Oel G H M N o B C D E 1 Complete the Payroll Register for October 15 2 P/R End Date 10/15/19 3 Check Date 10/18/19 4 Company Name Wayland Custom Woodworking Name M/S Insurance 401(k) Hourly Rate No. of Regular Hours WH No. of Overtime Hours Commissio Gross ns Earning No. of Holiday Hours Taxable Taxable Wages for Wages for Federal WH FICA 6 M 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Pepinico 10 Steven Varden 11 Leonard Hissop 12 Student Success M M M S S 1 5 7 2 4 1 Total 14 15 10 D E G H October 31 5 October 31 is the end of the final pay period for the month. Employee pay will be disbursed on November 4, 2019. Any hours exceeding 96 during this pay period are considered overtime for nonexempt employees. Computer the employee pay below. Update the Employees' Earning Records for the period's pay and update the YTD amount. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for October 31. Round wages to five decimal points and all other final answers to two decimal points. 9 The hours for the employees are as follows: 7 8 10 Name Hourly rate (round to 5 decimals) Pay Period Hours 10/16-10/31 Commission Regular Overtime (round to 2 (round to 2 decimals) decimals) S 1,750.00 96 hours (exempt) 96 hours (exempt) 96 hours (exempt) 100 hours 103 hours 98 hours 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday 21 22 6 23 13 24 20 25 27 26 27 Monday Friday 4 7 14 21 28 October Tuesday Wednesday Thursday 1 2 3 8 9 10 15 16 17 22 23 24 29 30 31 11 18 25 Saturday 5 12 19 26 H 1 K M N 0 P Complete the Payroll Register for October 31. Run Date 10/31/19 Company Name P/R Date 11/4/19 Wayland Custom Woodworking No. of Regular Hours No. of No. of Overtime Holiday Hours Hours Comisio Commissio Grou ns Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Peppinico 10 Steven Varden 11 Leonard Hissop 12 Student Success 13 M/S WH Hourly Rate M 1 M 5 M 7 M 2 S 4 S 1 Total 14 H November 15 Compute the pay for each employee. Update the Employee Earning record for the period's pay and the new YTD amount. Employee pay will be disbursed on November 19, 2019. Any hours exceeding 88 during this pay period are considered overtime for nonexempt employees. Remember that the employees are paid semimonthly. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for November 15. Round wages to five decimal points and all other final answers to two decimal points. 5 7 8 9 The hours for the employees are as follows: 10 Name Commission Hourly rate (round to 5 decimals) Pay Period Hours 11/01-11/15 Regular Overtime (round to 2 (round to 2 decimal) decimal) $ 1,050,00 88 hours (exempt) 88 hours (exempt) 88 hours (exempt) 96 hours 91 hours 93 hours 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday 21 22 23 24 25 26 Monday November Tuesday Wednesday Thursday Friday 3 4 11 18 25 10 17 24 5 12 19 26 6 13 20 27 Saturday 1 2 8 9 15 16 22 23 29 30 7 14 21 28 M N 0 Complete the Payroll Register for November 15. Run Date 11/15/19 Company Name 3 PR Date 11/19/19 Wayland Custom Woodworking 5 No. of No. of Overtime Holiday Hours Hours Commissio Gross ns Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Pepinico 10 Slevon Varden 11 Leonard Hissop 12 Student Success 13 14 15 No. of Regular M/S WH Hourly Rate Hours M 1 M 5 M 7 M 2 S 4 S 1 Total 6 8 Print_Arez fx H B 1 November 30 2 Compute the Net Pay for each employee. Employee pay will be disbursed on December 4, 2019. Update the Employees' Earning Record with the November 3 30 pay and the new YTD amount. 4 The company is closed and pays for the Friday following Thanskgiving. The employees will receive holiday pay for Thanksgiving and the Friday following 5 All the hours over 80 are eligible for overtime for nonexempt employees as they were worked during the nonholiday week. 7 The hours for the employees are as follows: Name Hourly rate Pay Period Hours 11/16 Regular Overtime Holiday Commission (round to 5 11/30 (round to 2 (round to 2 (round to 2 decimal) decimal) decimal) decimal) Chinson 80 hours (exempt - 16 $ 2,325.00 10 hours Holiday) Wayland 80 hours (exempt - 16 11 hours Holiday) Peppinico 80 hours (exempt - 16 12 hours Holiday) 13 Varden 82 hours (16 Holiday) 14 Hissop 83 hours (16 Holiday) 15 You 81 hours (16 Holiday) 16 17 November Sunday Monday Tuesday Wednesday Thursday Friday Saturday 9 18 6 19 20 21 22 23 24 4 11 3 10 17 241 1 8 15 22 29 2 9 16 23 30 12 19 26 18 25 14 21 28 20 27 Cell Styles Print_Area x v fx G H M N 0 P B C D E F Complete the Payroll Register for November 30, 2 Run Date 11/30/19 Company Name 3 PR Date 12/4/19 Waylund Custom Woodworking 4 5 No. of No. of Overtime Holiday Hours Hours Taxable Wages for Federal WH Commissio Gross Earning Taxable Wages for FICA Insurance 401(k) Name 7 Anthony Chinson 8 Mark Wayland 9 Sylvia Peppinico 10 Steven Varden 11 Leonard Hissop 12 Student Success 13 14 15 16 No. of Regular MS WH Hourly Rate Hours M 1 M 5 M 7 M 2 S S 1 Total op pay and update the Employees' Earning Record with the December 15 pay and the new YTD information. Employee pay will be disbu 019. Any hours worked in excess of 80 hours during this pay period are considered overtime for nonexempt employees. e employees are as follows: Hourly rate (round to 5 decimal) Pay Period Hours 12/01-12/15 Commission Regular Overtime (round to 2 (round to 2 decimal) decimal) Holiday (round to 2 decimal) $ 1,680.00 0 80 hours (exempt) 80 hours (exempt) 80 hours (exempt) 84 hours 80 hours 83 hours 1 12 13 14 15 yroll register for the December 15 pay. Employee pay will be disbursed on December 20, Monday Tuesday Friday 16 17 18 19 20 21 22 23 24 25 2 9 6 December Wednesday Thursday 3 4 5 10 11 12 17 18 19 24 25 26 31 Saturday 7 14 16 23 30 13 20 27 21 28 G H 1 M N O P 1 Complete the Payroll Register for December 15. 2 Run Date 12/15/19 Company Name 3 PR Date 12/19/19 Wayland Custom Woodworking No of No. of Overtime Holiday Hours Hours Commissio Gross Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthony Chinson 8 Mark Wayland 9 Sylvia Ruppinico 10 Steven Varden 11 Leonard Hisop 12 Student Success 13 14 15 16 No. of Regular M/S WH Hourly Rate Hours M 1 M 5 M 7 M 2 S S Total DE A16 fx Calculate hourly rates, regular and overtime. Amount of commiss A B D E F 1 October 15: 2 3 October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 18, 2019. Any time worked in excess of 88 hours during this pay period is considered 4 overtime for nonexempt employees. Remember that the employees are paid on a semimonthly basis. 5 6 The hours for the employees are as follows: 7 8 Name Hourly rate Pay Period Hours Regular Overtime Commission (round to 5 10/1-10/15 (round to 2 (round to 2 decimals) decimal) decimal) 9 Chinson 88 hours (exempt) $ 1,500.00 10 Wayland 88 hours (exempt) 11 Peppinico 88 hours (exempt) 12 Varden 88 hours 13 Hissop 93.25 hours 14 You 90 hours 15 16 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. 17 Complete the Payroll Register for October 15. Round wages to five decimal points and all other final answers to t 18 Update the Employees' Earning Records for the period's pay and update the YTD amount. 19 Insurance qualifies for Section 125 treatment. 20 + 21 Employer Info Employee hire info Oct 15 pay info Payroll Register Oc es Oct 15, 2019 pay period Jees Oct 15, 2019 pay period C@ e Next 3 4 Wayland Custom Woodwork "Wayland" is a firm that manufactures custom cabinets and woodwork for business and residential 5 customers. Students will have the opportunity to establish payroll records and to complete payroll compensation information for 6 Wayland. All employees are on October 1, 2019. 8 Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is 9 Mark Wayland. Wayland's EIN is 91-7444533, and the Utah Employer Account Number is 99992901685WTH. Wayland has 10 determined it will pay their employees on a semimonthly basis. 7 11 12 13 Rounding can create a challenge. For these exercises, the rate for the individuals is not rounded. So take their salary and divide by 14 2,080 (52 weeks at 40 hours per week) for full time, nonexempt employees. For example, Varden's salary is $42,000 and is a 15 nonexempt employee, so the calculation will be $42,000/2,080, which would give you $20.19231 per hour. 16 17 23 18 Exempt employees salaries are divided by 24, which is the number of payroll periods with a semi-monthly pay frequency. This can 19 lead to over 80 hours in a standard pay period without overtime available to nonexempt employees. For holiday pay, determine the 20 number of hours that are holiday pay and multiply it by the hours worked. For weeks with more than 80 hours, you will need to divide 21 the total hours for the pay period by the period salary. For example, if there are 16 hours of holiday during an 80 hour pay period for 22 Chinson, $1,000 X (16/80) - $200 holiday wages and $1,000 x (64/80) $800 regular wages. 24 After the gross pay has been calculated, round the result to only two decimal points on the Payroll Register and Employee 25 Earnings Records. 27 Employees are paid for the following holidays occurring during the final quarter: Thanksgiving day and the day after, Thursday and Friday November 28-29 Christmas, which is a Wednesday. Employees receive holiday pay for Tuesday, December 24, and Wednesday, December 25. 26 28 29 30 31 D E 1 October 11 2 Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The 3 following employees comprise Wayland's staff: 4 Payroll information Employee Name and Address 5 Number 6 00-Chins Anthony Chinson 7 530 Sylvann Avenue 8 Logan, UT 84321 9 435-555-1212 10 Job title: Account Executive 11 00-Wayla Mark Wayland 12 1570 Lovett Street 13 Logan, UT 84321 435-555-1110 15 Job title: President/Owner 16 01-Peppi Sylvia Peppinico 17 291 Antioch Road 18 Logan, UT 84321 19 435-555-2244 20 Job title: Craftsman 21 01-Varde Stevon Varden 22 333 Justin Drive 23 Logan, UT 84321 24 435-555-9981 25 Job title: Craftsman 26 02-Hisso Leonard Hissop 27 531 5 Street 28 Logan, UT 84321 29 435-555-5858 30 Job title: Purchasing Shipping 31 32 Department 00: Sales and Administration 33 Department 01: Factory workers 34 Department 02: Delivery and Customer service 35 Married, 1 withholding allowance Exempt $24,000/year + commission Start Date: 10/1/2019 SSN: 511-22-3333 Married, 5 withholding allowances Exempt $75,000/year Start Date: 10/1/2019 SSN: 505-33-1775 Married, 7 withholding allowances Exempt $43,500/year Start Date: 10/1/2019 SSN: 047-55.9951 Married, 2 withholding allowances Nonexempt $42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 Single, 4 withholding allowances Nonexem $49,500/year Start Date: 10/1/2019 SSN: 311-22-6698 s. 1. You have been hired as of October 1 as the new accounting clerk. Your employee number is 00-SUCCE. Your name is STUDENT SUCCESS. Your address is 1650 South Street, Logan, UT 84321. Your phone number is 435-556-1211, you were born July 16, 1985, your Utah driver's license number is 887743 expiring in 7/2024, and your Social Security number is 555-55-5555. You are nonexempt and paid at a rate of $36,000 36 per year. You contribute 3 percent to a 401(k), and health insurance is $50 per pay period. 37 Employer Info Employee hire info Oct 15 pay info Payroll Register Oct 15 Oct 31 pay info Count: 64 Microsoft Excel October 15: 2 pp 1 3 October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 18, 2019. Any time worked in excess of 88 hours during this pay period is considered 4 overtime for nonexempt employees. Remember that the employees are paid on a semimonthly basis. 5 6 The hours for the employees are as follows: 7 Name Hourly rate Pay Period Hours Regular Overtime Commission (round to 5 10/1-10/15 (round to 2 (round to 2 8 decimals) decimal) decimal) 9 Chinson 88 hours (exempt $ 1,500.00 10 Wayland 88 hours (exempel 11 Peppinico 88 hours (exempt) 12 Varden 88 hours 13 Hissop 93.25 hours 14 You 90 hours 15 16 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. 17 Complete the Payroll Register for October 15. Round wages to five decimal points and all other final answers to two decimal points. 18 Update the Employees' Earning Records for the period's pay and update the YTD amount. 19 Insurance qualifies for Section 125 treatment 20 21 22 Voluntary doductions for each employee are as follows: 23 Name Deduction October 24 Insurance: 550/paycheck 25 Chinson 401(k): 3% of gross PBY Sunday Monday Tuesday Wednesday 2 26 Insurance: $75/paycheck 7 9 27 Wayland 401(6):6% of gross pay 15 16 28 Insurance: $75/paycheck 20 21 22 23 29 Peyninico 401(k): 550 per paycheck 27 28 29 30 30 Insurance: $50/paycheck 31 Varden 401(k): 4% of gross pay 32 Insurance: $75/paycheck 401(k): 3% of gross pay 34 Insurance Silpaycheck 35 Student 401(k): 3% of gross PBY 36 Friday 6 Thursday 3 10 17 24 31 Saturday 5 12 19 26 11 18 25 14 39 40 41 42 Employer Info + Employee hire info Oct 15 pay into Payroll Register Oct 15 Oct 31 pay info Payroll Register Oel G H M N o B C D E 1 Complete the Payroll Register for October 15 2 P/R End Date 10/15/19 3 Check Date 10/18/19 4 Company Name Wayland Custom Woodworking Name M/S Insurance 401(k) Hourly Rate No. of Regular Hours WH No. of Overtime Hours Commissio Gross ns Earning No. of Holiday Hours Taxable Taxable Wages for Wages for Federal WH FICA 6 M 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Pepinico 10 Steven Varden 11 Leonard Hissop 12 Student Success M M M S S 1 5 7 2 4 1 Total 14 15 10 D E G H October 31 5 October 31 is the end of the final pay period for the month. Employee pay will be disbursed on November 4, 2019. Any hours exceeding 96 during this pay period are considered overtime for nonexempt employees. Computer the employee pay below. Update the Employees' Earning Records for the period's pay and update the YTD amount. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for October 31. Round wages to five decimal points and all other final answers to two decimal points. 9 The hours for the employees are as follows: 7 8 10 Name Hourly rate (round to 5 decimals) Pay Period Hours 10/16-10/31 Commission Regular Overtime (round to 2 (round to 2 decimals) decimals) S 1,750.00 96 hours (exempt) 96 hours (exempt) 96 hours (exempt) 100 hours 103 hours 98 hours 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday 21 22 6 23 13 24 20 25 27 26 27 Monday Friday 4 7 14 21 28 October Tuesday Wednesday Thursday 1 2 3 8 9 10 15 16 17 22 23 24 29 30 31 11 18 25 Saturday 5 12 19 26 H 1 K M N 0 P Complete the Payroll Register for October 31. Run Date 10/31/19 Company Name P/R Date 11/4/19 Wayland Custom Woodworking No. of Regular Hours No. of No. of Overtime Holiday Hours Hours Comisio Commissio Grou ns Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Peppinico 10 Steven Varden 11 Leonard Hissop 12 Student Success 13 M/S WH Hourly Rate M 1 M 5 M 7 M 2 S 4 S 1 Total 14 H November 15 Compute the pay for each employee. Update the Employee Earning record for the period's pay and the new YTD amount. Employee pay will be disbursed on November 19, 2019. Any hours exceeding 88 during this pay period are considered overtime for nonexempt employees. Remember that the employees are paid semimonthly. 6 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Complete the Payroll Register for November 15. Round wages to five decimal points and all other final answers to two decimal points. 5 7 8 9 The hours for the employees are as follows: 10 Name Commission Hourly rate (round to 5 decimals) Pay Period Hours 11/01-11/15 Regular Overtime (round to 2 (round to 2 decimal) decimal) $ 1,050,00 88 hours (exempt) 88 hours (exempt) 88 hours (exempt) 96 hours 91 hours 93 hours 11 12 Chinson 13 Wayland 14 Peppinico 15 Varden 16 Hissop 17 You 18 19 20 Sunday 21 22 23 24 25 26 Monday November Tuesday Wednesday Thursday Friday 3 4 11 18 25 10 17 24 5 12 19 26 6 13 20 27 Saturday 1 2 8 9 15 16 22 23 29 30 7 14 21 28 M N 0 Complete the Payroll Register for November 15. Run Date 11/15/19 Company Name 3 PR Date 11/19/19 Wayland Custom Woodworking 5 No. of No. of Overtime Holiday Hours Hours Commissio Gross ns Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthohy Chinson 8 Mark Wayland 9 Sylvia Pepinico 10 Slevon Varden 11 Leonard Hissop 12 Student Success 13 14 15 No. of Regular M/S WH Hourly Rate Hours M 1 M 5 M 7 M 2 S 4 S 1 Total 6 8 Print_Arez fx H B 1 November 30 2 Compute the Net Pay for each employee. Employee pay will be disbursed on December 4, 2019. Update the Employees' Earning Record with the November 3 30 pay and the new YTD amount. 4 The company is closed and pays for the Friday following Thanskgiving. The employees will receive holiday pay for Thanksgiving and the Friday following 5 All the hours over 80 are eligible for overtime for nonexempt employees as they were worked during the nonholiday week. 7 The hours for the employees are as follows: Name Hourly rate Pay Period Hours 11/16 Regular Overtime Holiday Commission (round to 5 11/30 (round to 2 (round to 2 (round to 2 decimal) decimal) decimal) decimal) Chinson 80 hours (exempt - 16 $ 2,325.00 10 hours Holiday) Wayland 80 hours (exempt - 16 11 hours Holiday) Peppinico 80 hours (exempt - 16 12 hours Holiday) 13 Varden 82 hours (16 Holiday) 14 Hissop 83 hours (16 Holiday) 15 You 81 hours (16 Holiday) 16 17 November Sunday Monday Tuesday Wednesday Thursday Friday Saturday 9 18 6 19 20 21 22 23 24 4 11 3 10 17 241 1 8 15 22 29 2 9 16 23 30 12 19 26 18 25 14 21 28 20 27 Cell Styles Print_Area x v fx G H M N 0 P B C D E F Complete the Payroll Register for November 30, 2 Run Date 11/30/19 Company Name 3 PR Date 12/4/19 Waylund Custom Woodworking 4 5 No. of No. of Overtime Holiday Hours Hours Taxable Wages for Federal WH Commissio Gross Earning Taxable Wages for FICA Insurance 401(k) Name 7 Anthony Chinson 8 Mark Wayland 9 Sylvia Peppinico 10 Steven Varden 11 Leonard Hissop 12 Student Success 13 14 15 16 No. of Regular MS WH Hourly Rate Hours M 1 M 5 M 7 M 2 S S 1 Total op pay and update the Employees' Earning Record with the December 15 pay and the new YTD information. Employee pay will be disbu 019. Any hours worked in excess of 80 hours during this pay period are considered overtime for nonexempt employees. e employees are as follows: Hourly rate (round to 5 decimal) Pay Period Hours 12/01-12/15 Commission Regular Overtime (round to 2 (round to 2 decimal) decimal) Holiday (round to 2 decimal) $ 1,680.00 0 80 hours (exempt) 80 hours (exempt) 80 hours (exempt) 84 hours 80 hours 83 hours 1 12 13 14 15 yroll register for the December 15 pay. Employee pay will be disbursed on December 20, Monday Tuesday Friday 16 17 18 19 20 21 22 23 24 25 2 9 6 December Wednesday Thursday 3 4 5 10 11 12 17 18 19 24 25 26 31 Saturday 7 14 16 23 30 13 20 27 21 28 G H 1 M N O P 1 Complete the Payroll Register for December 15. 2 Run Date 12/15/19 Company Name 3 PR Date 12/19/19 Wayland Custom Woodworking No of No. of Overtime Holiday Hours Hours Commissio Gross Earning Taxable Taxable Wages for Wages for Federal WH FICA Insurance 401(k) 6 Name 7 Anthony Chinson 8 Mark Wayland 9 Sylvia Ruppinico 10 Steven Varden 11 Leonard Hisop 12 Student Success 13 14 15 16 No. of Regular M/S WH Hourly Rate Hours M 1 M 5 M 7 M 2 S S Total DE A16 fx Calculate hourly rates, regular and overtime. Amount of commiss A B D E F 1 October 15: 2 3 October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 18, 2019. Any time worked in excess of 88 hours during this pay period is considered 4 overtime for nonexempt employees. Remember that the employees are paid on a semimonthly basis. 5 6 The hours for the employees are as follows: 7 8 Name Hourly rate Pay Period Hours Regular Overtime Commission (round to 5 10/1-10/15 (round to 2 (round to 2 decimals) decimal) decimal) 9 Chinson 88 hours (exempt) $ 1,500.00 10 Wayland 88 hours (exempt) 11 Peppinico 88 hours (exempt) 12 Varden 88 hours 13 Hissop 93.25 hours 14 You 90 hours 15 16 Calculate hourly rates, regular and overtime. Amount of commission pay is provided. 17 Complete the Payroll Register for October 15. Round wages to five decimal points and all other final answers to t 18 Update the Employees' Earning Records for the period's pay and update the YTD amount. 19 Insurance qualifies for Section 125 treatment. 20 + 21 Employer Info Employee hire info Oct 15 pay info Payroll Register Oc es Oct 15, 2019 pay period Jees Oct 15, 2019 pay period C@ e Next
