Compute net pay for each employee using the payroll register

Assignment Help Taxation
Reference no: EM131338933

Assignment

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland.

Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland's EIN is 91-7444533 and his Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis.

Students will complete the payroll for the final quarter of 2015, and will file fourth quarter and annual tax reports on the appropriate dates. When writing out the dollar amount for each check, spell out all words and the cents are presented over 100, for example 50 cents would be 50/100.

Federal income tax should be computed using the percentage method tables in Appendix C. FUTA information is in the table below. The Utah state income tax rate and the SUTA (UI) rate are in the table below.

Rounding can create a challenge. For these exercises, the rate for the individuals is not rounded. So take their salary and divide by 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 nonexempt employee, so the calculation will be $42,000/2,080, which would give you $20.19231 per hour. Exempt employees salaries are divided by 24 (number of payrolls for semimonthly.) For example, Chinson's salary is $24,000 and is a full time employee, so the calculation will be $24,000/24, which would give you $1,000. After this hourly rate is determined, than it can be applied to the number of hours worked. After the gross pay has been calculated, round this number to only two decimal points prior to calculating taxes or other withholdings.

For the completion of this project the following information can be located in Appendix C. Students will use the Percentage method for federal income tax and the tax tables have been provided for Utah. Both 401(k) and insurance are pretax for federal income tax and Utah income tax. Round calculations to get to final tax amounts and 401(k) contributions after calculating gross pay.

  Federal Withholding Allowance (less 401(k), Section 125)

$166.70 per allowance claimed

  Semimonthly Federal Percentage Method Tax Table

Appendix C, Page 270, Table #3

  Federal Unemployment Rate (Federal unemployment rate less Section 125 health insurance)

6.0% on the first $7,000 of wages

  State Withholding Rate (less 401(k), Section 125)

See Utah Schedule 3

State Unemployment Rate (less Section 125)

2.6% on the first $31,300 of wages

Wayland Custom Woodworking
Balance Sheet
9/30/2015

Assets

Liabilities & Equity

  Cash

1,125,000.00

Accounts Payable

112,490.00 

  Supplies

27,240.00

Salaries and Wages Payable

 

  Office Equipment

87,250.00

Federal Unemployment Tax Payable

 

  Inventory

123,000.00

Social Security Tax Payable

 

  Vehicle

25,000.00

Medicare Tax Payable

 

  Accumulated Depreciation, Vehicle

 

State Unemployment Tax Payable

 

  Building

164,000.00

Employee Federal Income Tax Payable

 

Accumulated Depreciation, Building

 

Employee State Income Tax Payable

 

  Land

35,750.00

401(k) Contributions Payable

 

 

 

Employee Medical Premiums Payable

 

  Total Assets

1,587,240.00

Notes Payable

244,750.00  

 

 

Utilities Payable


 

 

Total Liabilities

337,240.00 

 

 

 

 

 

 

Owners' Equity

1,250,000.00  

 

 

Retained Earnings

 

 

 

Total Equity

1,250,000.00 

 

 

Total Liabilities and Equity

1,587,240.00 

Wayland Custom Woodworking
Balance Sheet
9/30/2015

Assets

Liabilities & Equity

Cash

1,125,000.00

Accounts Payable

112,490.00

Supplies

27,240.00

Salaries and Wages Payable


Office Equipment

87,250.00

Federal Unemployment Tax Payable


Inventory

123,000.00

Social Security Tax Payable


Vehicle

25,000.00

Medicare Tax Payable


Accumulated Depreciation, Vehicle


State Unemployment Tax Payable


Building

164,000.00

Employee Federal Income Tax Payable


Accumulated Depreciation, Building


Employee State Income Tax Payable


Land

35,750.00

401(k) Contributions Payable




Employee Medical Premiums Payable


  Total Assets

1,587,240.00

Notes Payable

244,750.00



Utilities Payable




Total Liabilities

337,240.00



Owners' Equity

1,250,000.00



Retained Earnings




Total Equity

1,250,000.00



Total Liabilities and Equity

1,587,240.00

October 1:

Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland's staff:

  Employee Number

Name and Address

Payroll information

  00-Chins

Anthony Chinson
530 Sylvann Avenue
Logan, UT 84321
435-555-1212
Job title: Account Executive

Married, 1 withholding allowance
Exempt
$24,000/year + commission
Start Date: 10/1/2015
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/2015
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/2015
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/2015
SSN: 022-66-1131

  02-Hisso

Leonard Hissop
531 5th Street
Logan, UT 84321
435-555-5858
Job title: Purchasing/Shipping

Single, 4 withholding allowance
Nonexempt
$49,500/year
Start Date: 10/1/2015
SSN: 311-22-6698

Voluntary deductions for each employee are as follows:

Name

Deduction         

  Chinson

Insurance: $50/paycheck

401(k): 3% of gross pay

  Wayland

Insurance: $75/paycheck

401(k): 6% of gross pay

  Peppinico

Insurance: $75/paycheck

401(k): $50 per paycheck

  Varden

Insurance: $50/paycheck

401(k): 4% of gross pay

  Hissop

Insurance: $75/paycheck

401(k): 3% of gross pay

  Student

Insurance: $50/paycheck

401(k): 3% of gross pay

The departments are as follows:
Department 00: Sales and Administration
Department 01: Factory workers
Department 02: Delivery and Customer service

1. You have been hired as of October 1 as the new accounting clerk. Your name is Student F. Success and your employee number is 00-STUDE. Your Utah drivers license is 887743 expiring in 7/2018 and social security number is 555-55-5555, and you are non-exempt and paid at a rate of $36,000 per year. Using the information provided, complete the W-4 and the I-9 to start your employee file. Complete as if Single with 1 withholding, you decide to contribute 3% to 401(k) and health insurance is $50 per pay period.

2. Complete the headers of the Employees' Earnings Records for all company employees. Enter the YTD earnings for each employee.

1. Required information

December 15 is the end of the first pay period for the month of December. Employee pay will be disbursed on December 18. Any time worked in excess of 80 hours is considered overtime. Remember that the employees are paid on a semi-monthly basis. Compute the employee gross pay.

Compute the Net Pay for each employee using the payroll register. Once you have computed the net pay, complete the paycheck for each employee (assume that all employees are paid by check). Date the checks 12/18/1X (current year).

Complete the General Journal entries as follows:

3-Dec Journalize remittance of 401(k) and health insurance premiums deducted in November. (Refer to the general ledger for account balances.)

3-Dec Journalize remittance of monthly payroll taxes for November. (Refer to the general ledger for account balances.)

3-Dec Journalize payment of payroll to employees for November 30 payroll. (Refer to the general ledger for account balances.)
15-Dec Journalize employee pay including the issuance of paychecks (Use one entry for all checks)

15-Dec Journalize employer payroll tax for the December 15 pay date

18-Dec Journalize payment of payroll to employees

Update the Employee Earnings records for the period's pay and the new YTD amount.

-NOTE 1: Do not round intermediate calculations and round hourly rate to 5 decimal places & remaining answers to 2 decimal places. If no entry is required for a transaction/event, select "No journal entry required" in the first account field.

-NOTE 2: When writing out the net amount of an employee's check, be sure to write it in the correct format (e.g. Three Hundred Ninety-nine and 75/100 Dollars). Be sure to capitalize the letters as shown. Enter all dates in mm/dd/yy format where year is entered as 1X.

2. Required information

December 31 is the end of the final pay period for the month of December. Employee pay will be dispersed on January 3. The company pays for the day before and the day of Christmas, and if the holiday is on a weekend, the company pays for the Friday before. Christmas fell on a Tuesday, so employees will be paid for both the Monday and Tuesday as holiday pay. (Employees worked extra hours on Saturday during the week of 12/23-12/29. Remember, holidays and vacations do not incur overtime if the employee does not work more than 8 hours in a day.) Compute the employee gross pay.

Compute the Net Pay for each employee using the payroll register. Once you have computed the net pay, complete the paycheck for each employee (assume that all employees are paid by check). Date the checks 1/3/1X (next year).

Complete the General Journal entries as follows:

31-Dec Journalize employee pay including the issuance of paychecks (use one entry for all checks)

31-Dec Journalize employer payroll tax for the December 31 pay date

03-Jan Journalize remittance of 401(k) and health insurance premiums deducted

03-Jan Journalize remittance of monthly payroll taxes

03-Jan Journalize payment of payroll to employees

Update the Employee Earnings records for the period's pay and the new YTD amount.

3. Complete the Employee Earning Record and YTD amount for the semimonthly pay.

4. Post all journal entries to the General Ledger accounts for the fourth quarter.

5. Complete Form 941 for the remittance of quarterly federal taxes.

6. Complete Form 940 for Wayland Custom Woodworking.

7. Complete forms for the remittance of quarterly state taxes.

Reference no: EM131338933

Questions Cloud

Game theory of money and banking : These questions concentrate on the game theory of money and banking. Consider the Principle-Agent problem in relation to banking.
Write an equation that models the situation : How long was the trucker driving in the city to the nearest hundredth of an hour?
What is the moral hazard : Explain their difficulty with this concept of  "Bail Out" in accordance with moral hazard concerns. What is the moral hazard? What is one possible remedy for this moral hazard problem (what are the good and bad points of this remedy)?
Write an abstract of the articlels : Research one or more scholarly articles referencing information security access controls.Write an abstract of the articlels.The abstract must be written in your own words - If you quote from the artiele(s) you must properly cite it in MIA format.Abst..
Compute net pay for each employee using the payroll register : Compute the Net Pay for each employee using the payroll register. Once you have computed the net pay, complete the paycheck for each employee (assume that all employees are paid by check). Date the checks 1/3/1X (next year).
Find the excluded value of the related function : Find the excluded value(s) of the related function.
Effect on the size of the money supply : When the reserve requirement is increased, what is the effect on the size of the money supply? What is the practical justification of the reserve requirement, besides as a monetary policy tool?
Examples of economies in the world : Although there are many different examples of economies in the world, all of them demonstrate one or more of the four basic types of market structure. For this assignment, in your own words,
What is the lcd of the rational expressions : What is the LCD of the rational expressions?

Reviews

Write a Review

 

Taxation Questions & Answers

  Prepare a memorandum that outlines the tax consequences

Prepare a memorandum that outlines the tax consequences of each of the three alternative acquisitions

  Schubert mahler and tull are resident australian seamen

schubert mahler and tull are resident australian seamen employed on the fishing trawler mv st cecilia. whilst on a

  The u s continue on the path to bring liberty and freedom

Due to our financial issues and social strains, is it prudent for the U.S. to continue with a policy of intervention with countries that are not a threat to us or should the U.S. continue on the path to bring liberty and freedom to all corners of the..

  Monetary policy actions made by the federal reserve impact

1. How do monetary policy actions made by the Federal Reserve impact interest rates? 2. What is the repricing gap? In using this model to evaluate interest rate risk, what is meant by rate sensitivity? On what financial performance variable does the ..

  Determine the amount of income tax

Prepare the business combinations 2013 consolidation worksheet; ignore income taxeffects - determine the amount of income tax for Travers and Yarrow on a consolidated tax returnfor 2013

  Determine net capital gain or net capital loss

Determine Dave Solomons net capital gain or net capital loss for the year ended 30 June of the current tax year - Advise Periwinkle of its FBT consequences arising out of the above information, including calculation of any FBT liability.

  Tax return and partnership return

The Rowdy Fun is a limited partnership and was formed on June 1, 2005, by Thomas Kyle, its general partner, and two other limited partners when they each contributed an equal amount of cash to start the new enterprise.

  The sanding department of richards furniture company has

the sanding department of richards furniture company has the subsequent production and manufacturing cost data for

  Identification of legal issues and articulation of arguments

Identification of correct legal issues and articulation of arguments and application of law to facts; and - Analyze and then advice ABC of its FBT consequences arising out of the above information, including calculation of any FBT liability, for the..

  Determine emilys itemized deductions

Determine Emily's itemized deductions. Which of these items can and cannot be listed as medical deductions? What is her 2011 taxable income?

  How do you see social networking sites being used

How do you see social networking sites being used in the future professional world? In the educational world?

  Comprehensive analysis of the authority

Expenses, Losses and Itemized Deductions - Fundamentals of Income Taxation

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd