semi monthly
B e Wayland Custom Woodworking Gross Pay Assignment 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 5 Wayland. All employees are on October 1, 2019. 3 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 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. 23 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 32 Print Arec fx 1. You have been hired as of October 1 as the new accounting clerk. Your employee number B 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 after 13 Wa 16 Employee Name and Address 5 Number 6 00-Chins Anthony Chinson 7 530 Sylvann Avenue ers 8 Logan, UT 84321 9 435-555-1212 wil 10 Job title: Account Executive 11 00-Wayla Mark Wayland 12 1570 Lovett Street Logan, UT 84321 14 435-555-1110 15 Job title: President Owner 01-Peppi Sylvia Peppinico 17 291 Antioch Road addi 18 Logan, UT 84321 19 435-555-2244 20 Job title: Craftsman 21 01-Varde Stevon Verden 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 S42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 Single, 4 withholding allowances Neexempt $49,500 year Start Date: 10/1/2019 SSN: 311-22-6698 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 phonch number is 435-556-1211, you were bom 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 38 2008 Employer Info Employee hire info Oct 15 pay info Payroll Register Oct 15 Oct 31 pay info Ready Count: 64 etv A ? WO W ? . y Paste Conditional Formatting % Format as Table Font Alignment Editing Ideas Cell Styles 4 x fx Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Number Cells Sensitivity A16 B F G H UCLUDUT + 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 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 deductions for each employee are as follows: Sunday Monday October Wednesday Saturday 7 9 Deduction Insurance: 850/paycheck 401(k): 3% of gross pay Insurance: $75/paycheck 401(k): 6% of gross pay Insurance: $75/paycheck 401(k): $50 per paycheck Insurance: $50 paycheck 401(k): 4% of gross pay Insurance $75/paycheck 401(k): 3% of gross pay Insurance: 550/paycheck 401(k): 3% of gross pay 6 13 20 27 Tuesday 1 8 15 22 29 Thursday 3 10 17 24 31 Friday 4 11 18 25 14 21 28 16 23 23 Name 24 25 Chinson 26 27 Wayland 28 29 Peppinico 30 31 Varden 32 33 Hisson 34 35 Student 36 37 38 39 40 30 42 43 $5 44 B e Wayland Custom Woodworking Gross Pay Assignment 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 5 Wayland. All employees are on October 1, 2019. 3 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 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. 23 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 32 Print Arec fx 1. You have been hired as of October 1 as the new accounting clerk. Your employee number B 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 after 13 Wa 16 Employee Name and Address 5 Number 6 00-Chins Anthony Chinson 7 530 Sylvann Avenue ers 8 Logan, UT 84321 9 435-555-1212 wil 10 Job title: Account Executive 11 00-Wayla Mark Wayland 12 1570 Lovett Street Logan, UT 84321 14 435-555-1110 15 Job title: President Owner 01-Peppi Sylvia Peppinico 17 291 Antioch Road addi 18 Logan, UT 84321 19 435-555-2244 20 Job title: Craftsman 21 01-Varde Stevon Verden 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 S42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 Single, 4 withholding allowances Neexempt $49,500 year Start Date: 10/1/2019 SSN: 311-22-6698 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 phonch number is 435-556-1211, you were bom 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 38 2008 Employer Info Employee hire info Oct 15 pay info Payroll Register Oct 15 Oct 31 pay info Ready Count: 64 etv A ? WO W ? . y Paste Conditional Formatting % Format as Table Font Alignment Editing Ideas Cell Styles 4 x fx Calculate hourly rates, regular and overtime. Amount of commission pay is provided. Number Cells Sensitivity A16 B F G H UCLUDUT + 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 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 deductions for each employee are as follows: Sunday Monday October Wednesday Saturday 7 9 Deduction Insurance: 850/paycheck 401(k): 3% of gross pay Insurance: $75/paycheck 401(k): 6% of gross pay Insurance: $75/paycheck 401(k): $50 per paycheck Insurance: $50 paycheck 401(k): 4% of gross pay Insurance $75/paycheck 401(k): 3% of gross pay Insurance: 550/paycheck 401(k): 3% of gross pay 6 13 20 27 Tuesday 1 8 15 22 29 Thursday 3 10 17 24 31 Friday 4 11 18 25 14 21 28 16 23 23 Name 24 25 Chinson 26 27 Wayland 28 29 Peppinico 30 31 Varden 32 33 Hisson 34 35 Student 36 37 38 39 40 30 42 43 $5 44
