Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 20, 2016. Any

October 15 is the end of the first pay period for the month of October. Employee pay will be disbursed on October 20, 2016. Any time worked in excess of 80 hours during this pay period is considered overtime for nonexempt employees. Remember that the employees are paid on a semimonthly basis.

Employee Grosspay

Complete the Employee Gross Pay tab.

Complete the Payroll Register for October 15.

Refer to the Employee Earning Record Forms for each employee for the current YTD amounts after you have completed the October 15 Payroll Register. Amounts from the current period are auto-populated from the Payroll Register.

Complete the General Journal entries for the October 15 payroll.

Post the journal entries to the General Ledger.

Payroll Register

Chinson EERF

Wayland EERF

Peppinico EERF

Varden EERF

Hissop EERF

F Success EERF

General Journal

General Ledger

Compute the hourly rates as well as the gross earnings for regular and overtime pay for each employee for the October 15 pay period. Remember that while you are computing an hourly rate for all employees, the regular 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. (Round answers for hourly rate to 5 decimal places and all other answers to 2 decimals.)

Last Name

Hourly Rate (Rounded to 5 Decimals)

Pay Period Hours 10/1-10/15

Regular

Overtime

Commission

Chinson

$11.53846

80 hours (exempt)

$923.08

$0.00

$1,500.00

Wayland

$36.05769

80 hours (exempt)

$2,884.62

$0.00

Peppinico

$20.91346

80 hours (exempt)

$1,672.98

$0.00

Varden

$20.19230

88 hours

$1,615.38

$242.31

Hissop

$23.79807

85.25 hours

$1,903.85

$187.41

Success

$17.30769

82 hours

$1,384.62

$51.92

October 31

October 31 is the end of the final pay period for the month. Employee pay will be disbursed on November 4, 2016. Any hours exceeding 88 during this pay period are considered overtime for nonexempt employees. Compute the employee pay below. Update the Employees' Earning Records for the period's pay and update the YTD amount. Remember that the employees are paid semi-monthly.

Complete the Employee Gross Pay tab.

Complete the Payroll Register for October 31.

You must update the Employee Earning Record Forms for each employee with the ending YTD amounts from October 15 (the prior pay period) in the "Prior Period YTD" rows. Amounts from the current period are auto-populated from the Payroll Register on the row for October 31.

Complete the General Journal entries for the October 31 payroll.

Update the General Ledger with the ending ledger balances from the October 15 pay period ledger accounts first, and then post the journal entries from the current period to the General Ledger.

Compute the gross earnings for regular and overtime pay for each employee for the October 31 pay period. Remember that while an hourly rate is shown for all employees, the regular 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. The pay rates for each employee have been given from the prior period. (Round your answers to 2 decimals.)

Show less

Last Name

Hourly Rate (Rounded to 5 Decimals)

Pay Period Hours 10/16-10/31

Regular

Overtime

Commission

Chinson

$11.53846

88 hours (exempt)

$1,750.00

Wayland

$36.05769

88 hours (exempt)

Peppinico

$20.91346

88 hours (exempt)

Varden

$20.19231

92 hours

Hissop

$23.79808

95 hours

Success

$17.30769

90 hours

Compute the Net Pay for each employee. Employee pay will be disbursed on December 5, 2016. Update the Employees' Earning Record with the November 30 pay and the new YTD amount.

The company is closed and pays for the Friday following Thanksgiving. The employees will receive holiday pay for Thanksgiving and the Friday following. All the hours over 88 are eligible for overtime for nonexempt employees as they were worked during the non-holiday week.

  • Complete the Employee Gross Pay tab.
  • Complete the Payroll Register for November 30.
  • You must update the Employee Earning Record Forms for each employee with the ending YTD amounts from November 15 (the prior pay period) in the "Prior Period YTD" rows. Amounts from the current period are auto-populated from the Payroll Register on the row for November 30.
  • Complete the General Journal entries for the November 30 payroll.
  • Update the General Ledger with the ending ledger balances from the November 15 pay period ledger accounts first, and then post the journal entries from the current period to the General Ledger.
  • Compute the gross earnings for regular, overtime, and holiday pay for each employee for the November 30 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. The pay rates for each employee have been given from the prior period. (Round your answers to 2 decimals.)

    Show less
    Last Name Hourly Rate (Rounded to 5 Decimals) Pay Period Hours 11/16-11/30 Regular Overtime Holiday Commission
    Chinson $11.53846 88 hours (exempt - 16 hours Holiday) $2,325.00
    Wayland $36.05769 88 hours (exempt - 16 hours Holiday)
    Peppinico $20.91346 88 hours (exempt - 16 hours Holiday)
    Varden $20.19231 90 hours
    Hissop $23.79808 91 hours
    Success $17.30769 89 hours

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Top Accounting And Auditing Issues For 2023

Authors: CCH Tax Law Editors

1st Edition

0808059335, 978-0808059332

More Books

Students also viewed these Accounting questions

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago

Question

Explain the characteristics of a good system of control

Answered: 1 week ago

Question

State the importance of control

Answered: 1 week ago

Question

explain what is meant by the terms unitarism and pluralism

Answered: 1 week ago