Answered step by step
Verified Expert Solution
Question
1 Approved Answer
October 1: Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland's staff: Employee Number 00-Chins Name and
October 1: Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland's staff: Employee Number 00-Chins Name and Address Anthony Chinson 530 Sylvann Avenue Logan, UT 84321 435-555-1212 Job title: Account Executive Payroll information Married, 1 Withholding allowance Exempt $24,000/year + commission Start Date: 10/1/2019 SSN: 511-22-3333 00-Wayla Mark Wayland 1570 Lovett Street Logan, UT 84321 435-555-1110 Job title: President/Owner Married, 5 withholding allowances Exempt $75,000/year Start Date: 10/1/2019 SSN: 505-33-1775 01-Peppi Sylvia Peppinico 291 Antioch Road Logan, UT 84321 435-555-2244 Job title: Craftsman Married, 7 withholding allowances Exempt $43,500/year Start Date: 10/1/2019 SSN: 047-55-9951 01-Varde Stevon Varden 333 Justin Drive Logan, UT 84321 435-555-9981 Job title: Craftsman Married, 2 withholding allowances Nonexempt $42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 02-Hisso Leonard Hissop 531 5th Street Logan, UT 84321 435-555-5858 Job title: Purchasing/Shipping Single, 4 withholding allowances Nonexempt $49,500/year Start Date: 10/1/2019 SSN: 311-22-6698 00-Succe Student Success 1650 South Street Logan, UT 84321 435-556-1211 Job title: Accounting Clerk Single, 1 withholding allowance Nonexempt $36,000/year Start Date: 10/1/2019 SSN: 555-55-5555 December 15 December 15 is the end of the first pay period for the month of December. Employee pay will be disbursed on December 19, 2019. Remember that the employees are paid on a semimonthly basis. Compute the net pay and update the Employees' Earnings Records with the December 15 pay and the new YTD information. Any hours worked in excess of 80 hours during this pay period are considered overtime for nonexempt employees. Complete the Employee Gross Pay tab. Compute the gross earnings for regular, overtime, and holiday pay for each employee for the December 15 pay period. Remember that while an hourly rate is shown for all employees, the period pay for exempt employees should be calculated by taking their yearly salary and dividing it by the number of semimonthly pay periods in a year, which should then be split between the number of hours considered regular time and holiday time. (Round answers for hourly rate to 5 decimal places and all other answers to 2 decimals. Last Name Regular Overtime Holiday Commission $ 1,680.00 Chinson Wayland Peppinico Varden Hourly Rate (Rounded ed Pay Period Hours 12/01-12/15 to 5 Decimals) 80 hours (exempt) 80 hours (exempt) 80 hours (exempt) 84 hours Hissop 80 hours 83 hours Success October 1: Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland's staff: Employee Number 00-Chins Name and Address Anthony Chinson 530 Sylvann Avenue Logan, UT 84321 435-555-1212 Job title: Account Executive Payroll information Married, 1 Withholding allowance Exempt $24,000/year + commission Start Date: 10/1/2019 SSN: 511-22-3333 00-Wayla Mark Wayland 1570 Lovett Street Logan, UT 84321 435-555-1110 Job title: President/Owner Married, 5 withholding allowances Exempt $75,000/year Start Date: 10/1/2019 SSN: 505-33-1775 01-Peppi Sylvia Peppinico 291 Antioch Road Logan, UT 84321 435-555-2244 Job title: Craftsman Married, 7 withholding allowances Exempt $43,500/year Start Date: 10/1/2019 SSN: 047-55-9951 01-Varde Stevon Varden 333 Justin Drive Logan, UT 84321 435-555-9981 Job title: Craftsman Married, 2 withholding allowances Nonexempt $42,000/year Start Date: 10/1/2019 SSN: 022-66-1131 02-Hisso Leonard Hissop 531 5th Street Logan, UT 84321 435-555-5858 Job title: Purchasing/Shipping Single, 4 withholding allowances Nonexempt $49,500/year Start Date: 10/1/2019 SSN: 311-22-6698 00-Succe Student Success 1650 South Street Logan, UT 84321 435-556-1211 Job title: Accounting Clerk Single, 1 withholding allowance Nonexempt $36,000/year Start Date: 10/1/2019 SSN: 555-55-5555 December 15 December 15 is the end of the first pay period for the month of December. Employee pay will be disbursed on December 19, 2019. Remember that the employees are paid on a semimonthly basis. Compute the net pay and update the Employees' Earnings Records with the December 15 pay and the new YTD information. Any hours worked in excess of 80 hours during this pay period are considered overtime for nonexempt employees. Complete the Employee Gross Pay tab. Compute the gross earnings for regular, overtime, and holiday pay for each employee for the December 15 pay period. Remember that while an hourly rate is shown for all employees, the period pay for exempt employees should be calculated by taking their yearly salary and dividing it by the number of semimonthly pay periods in a year, which should then be split between the number of hours considered regular time and holiday time. (Round answers for hourly rate to 5 decimal places and all other answers to 2 decimals. Last Name Regular Overtime Holiday Commission $ 1,680.00 Chinson Wayland Peppinico Varden Hourly Rate (Rounded ed Pay Period Hours 12/01-12/15 to 5 Decimals) 80 hours (exempt) 80 hours (exempt) 80 hours (exempt) 84 hours Hissop 80 hours 83 hours Success
Step 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