Ezto.mheducation.com



Appendix A Continuing Payroll Project (1-Month Version) – Wayland Custom Woodworking

Payroll Accounting 2019, by Landin/Schirmer (5th Edition)

Connect Student User Guide

PURPOSE:

This guide is meant to help students navigate and work through the Appendix A Payroll Project for Wayland Custom Woodworking in Connect. The project consists of two parts: Part 1 has students prepare of the sample employee’s onboarding forms (W4 and I9) and payroll for the final two pay periods of 4th quarter for Wayland. Part 2 has students prepare the quarter and year-end federal and state tax forms for Wayland using the payroll information gathered in Part 1.

Before You Begin

NOTE: Your instructor may decide to not assign certain parts of the project at their discretion. If this is the case for your assignment, certain elements of this guide will not be applicable to you.

Before you move into the requirements of the project, take some time to familiarize yourself with the given information in the very first section of the project, which will provide you with the details and information needed to complete the project.

The given information includes:

• Details on Wayland Custom Woodworking (WCW), including its address, EIN, and phone number;

• Tax rates and links to both federal and state (Utah) withholding tax tables;

• WCW’s Balance Sheet as of 11/30/2018.

• Employee marital status, salary information, and voluntary deduction information.

You will need to refer to this information as you work through each part of the project. Specific information for each stage and requirement of the project will be given in each step as appropriate.

Payroll Project - Part 1

Part 1 of the project consists of students preparing the W4 and I9 in for the example student employee (named Student F Success) to start their company file in Requirement 1, as well as the preparation of Wayland’s payroll for the last two pay periods in the 4th quarter of 2017 in Requirement 2. Payroll information from the first four pay periods has been provided to you for the December 15 period. If your instructor has decided to not include the W4 and I9 in your Connect assignment, then you will begin with the pay periods.

Each pay period, with the exception of December 31 (the last of the year), consists of the following parts:

• A table for determining the gross pay for each employee (6 in total) for that period;

• A Payroll Register;

• Employee Earnings Record forms (EERF) for each employee;

• A set of General Journal entries to record the effects of the period’s payroll;

• A General Ledger for the posting of the journal entries to the individual ledger accounts that have been affected.

In each Project part, cells highlighted in yellow are input boxes or dropdown cells. Enter your answers in the appropriate input boxes for each part as you move through the project.

Yellow Shading for Input Boxes/Dropdown Cells

[pic]

To navigate between the requirements, go to the bottom of the page and note the buttons that appears, which are shown in the screenshot below. To move to the next requirement, select the box showing 1 and 2 below or select the blue checkered box, which will show both parts. DO NOT select “Score answer” or the “Submit” button at the top of the page until you are ready to submit your assignment for grading.

Requirement Navigation (Payroll Project Part 1)

[pic]

If you cannot complete your assignment in one sitting, ensure to select the “Save & Exit” button at the top of the screen to save the work that you have done so far.

December 15 Payroll (5th period of the 4th quarter):

Beginning with the Employee Gross Pay table, you will first want to compute an hourly rate for each of the six employees. Information for each employee relative to payroll can be found in the project information for Part 1 – for the Gross Pay table, pay particular attention to the yearly salary for each employee as well as whether or not they are considered an exempt or nonexempt employee, but other information for the employee, such as their marital status, will be used in completing the Payroll Register.

Example of Employee Information:

[pic]

For the December 15 pay period, you need to compute not only each employee’s gross pay (period payment before any deductions or taxes), but also their hourly rate based on their salary.

To compute the hourly rate, you will want to take their yearly salary and divide it by 2,080 (52 weeks per year x 40 hours worked per week). After dividing this number, round the result to 5 decimal places, and input the rate in the appropriate input box in the “Hourly rate” column for each employee.

To compute the period gross pay, you will need to take a different approach depending on whether each employee is considered exempt or nonexempt. For exempt employees, period gross pay is at the same level regardless of if they work an excess of 80 or 88 hours, (depending on what the normal level is for a given pay period) as they are exempt from receiving overtime pay. For nonexempt employees, overtime pay can be earned if they exceed the normal hours for a given pay period, and hours over the normal threshold should be computed at their hourly rate times 1.5.

Putting this in an example, let’s compute the December 15 hourly rate and gross pay for employees Anthony Chinson and Stevon Varden. A screenshot of the results of these calculations can be found on the next page.

• Anthony Chinson is an exempt employee that earns a salary of $24,000 per year, plus commission on sales. For all pay periods in this project, Chinson’s commission is given to you, but to compute his regular pay for the period, you will first start by computing his hourly rate by taking $24,000 and dividing it by 2,080, which gives you $11.53846 when rounded to 5 decimal places. To determine the regular pay for Chinson, remember that he is an exempt employee, thus he receives the same pay per period regardless of the number of hours worked. Thus, for regular pay, you will take his yearly salary and divide it by 24, which is the number of pay periods in a year for an employee that is paid semimonthly. Doing so (24,000 / 24) will give you $1,000 for Chinson’s regular, non-commission pay for the December 15 pay period.

• Stevon Varden is a nonexempt employee that earns a salary of $42,000 per year. As he is a nonexempt employee, Varden will receive regular pay based on his hourly rate times the normal hours for the period but will also receive overtime at a rate of 1.5 times his hourly rate against any hours considered overtime. First, start by computing Varden’s hourly rate, which is $20.19231 ($42,000 / 2,080) when rounded to 5 decimal places. For December 15, 80 hours is considered normal, but Varden worked 84 hours during this period, so you will first take Varden’s hourly rate times 80 hours, which will give you $1,615.38 when rounded to 2 decimal places. Then, take his hourly rate and multiply it by 1.5, which will give you $30.28847 when rounded to 5 decimal places, and multiply this by the 4 hours of overtime, which will give you $121.15 when rounded to 2 decimal places.

Example of Hourly Rate and Regular/Overtime Pay Calculation for December 15:

[pic]

For additional step-by-step instructions for this process, please view the following video. (NOTE: this video uses calculations for the October 15 pay period, but the methods used to compute the answers are the same that you must use to compute December 15 pay.)

Moving on past the Employee Gross Pay table, complete the Payroll Register for this pay period using the gross pay information that you just calculated, and use the other information is given in the project information at the very beginning, such as employee 401(k) percentages and the tax tables for both federal and Utah withholding tax.

After you have completed the Payroll Register, complete each employees Employee Earnings Record form (EERF) by inputting their information from the Register where required. For each EERF, the payroll information from the prior four pay periods has been given to you. These amounts, combined with the payroll information from December 15, will be used in Part 2 of the project.

After completing the EERFs, complete the General Journal entries and post them to the General Ledger accounts, taking care to enter each transaction in the order that they were journalized (note the date of each transaction in the General Journal for reference). Similar to the EERFs, ledger account postings and balances from the prior pay periods are shown. The ending balances for each ledger account will be used in the following pay period.

December 31 Payroll (6th and last pay period of the 4th quarter):

The December 31 pay period will require you to complete an Employee Gross Pay table along with a Payroll Register, but there are no EERFs for this pay period, as the accrued payroll will not be disbursed to employees until January 2, 2019. Note that the December 31 pay period shows that employees have paid holidays. When paid holidays occur, ensure to distribute pay to the “Holiday” column of the Gross Pay table for the amount of hours that are stated as being holidays, and the rest in either the “Regular” or “Overtime” columns as appropriate.

For Nonexempt employees, you will simply take their hourly rate and multiply it by the holiday hours to determine this amount, but for salaried workers, use a percentage of the hours to multiply their salary by for regular and overtime calculations. Using Chinson again as an example, you would take his 16 hours of holiday and divide it by 80 hours in the pay period = 20% holiday pay and 80% regular. Then, multiply by the salary for the pay period, or ($24,000/24)*.80 for Chinson regular hours.

Complete the Payroll Register for December 31 after completing the Gross Pay worksheet. As discussed above, there are no EERFs for this pay period as payroll will not be disbursed until after the end of the year. Once the Payroll Register has been completed, complete the General Journal entries and post them to the General Ledger accounts, taking care to enter each transaction in the order that they were journalized (note the date of each transaction in the General Journal for reference). In addition to posting the current period amounts, you must also add in the prior period’s ending balance to the “Ending account balance from the prior period” rows for each ledger account as needed.

For example, let’s assume that the ending balance for the Payroll Taxes Expense account was $125,000.00 after the December 15 pay period. For the December 31 pay period, this amount should be entered into the input box for the “Ending account balance from the prior period”, such as in the screenshot below. If we further assume that one transaction occurred for the December 31 pay period that resulted in a debit to the Payroll Taxes Expense account of $12,500.00, posting this transaction to the Cash ledger account will recalculate the ending balance for the December 31 pay period as $137,500.00.

[pic]

For additional step-by-step instructions for this process, please view the following video.

After completing the General Ledger for December 31, you have completed Part 1 of the Payroll Project. Take some time to look over each requirement for Part 1 to ensure that all data has been entered, and then submit your assignment.

Payroll Project - Part 2

Part 2 of the Payroll Project consists of completing a set of tax forms for Wayland for both the end of the quarter and end of the year. These forms include:

• U.S. Form 941

• U.S. Form 940

• Utah Form TC-941

• Utah Form 33H

• Form W-2s for all 6 employees

• Form W-3 for WCW

In order to successfully complete each form, you will need to use the payroll information for Wayland’s 4th quarter that you prepared and submitted for Part 1 of the project. In particular, the EERFs for each employee for the December 15 pay period and the General Ledger tabs for all pay periods will provide you with the amounts needed for each form, but you must also refer to the given information for Wayland and its employees, such as addresses and social security numbers, for the forms.

To navigate between the requirements, go to the bottom of the page and note the buttons that appears, which are shown in the screenshot below. To move to the next requirement, select the box showing 1, 2, 3, and 4 below or select the blue checkered box, which will show all 4 parts. DO NOT select “Score answer” or the “Submit” button at the top of the page until you are ready to submit your assignment for grading.

Requirement Navigation (Payroll Project Part 2)

[pic]

If you cannot complete your assignment in one sitting, ensure to select the “Save & Exit” button at the top of the screen to save the work that you have done so far.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download