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. Waylands 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, Vardens 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, Chinsons 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 293, Table #3
Federal Unemployment Rate (Federal unemployment rate less Section 125 health insurance)	0.6% 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		224,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 Waylands 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 allowances Nonexempt $49,500/year Start Date: 10/1/2015 SSN: 311-22-6698
00-Stude	Student F Success 480-555-3322 Job title: Accounting Clerk	Single, 1 withholding allowance Nonexempt $36,000/year Start Date: 10/1/2015 SSN: 555-55-5555

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.

QQQQQQ*******QQQQQQQ********

November 30 is the end of the final pay period for the month. Employee pay will be disbursed on December 3, 201X. Any hours exceeding 88 are considered overtime. 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 the employees are paid by check). Date the checks 12/3/1X (current year).

The company is closed and pays for the Friday following Thanksgiving. The employees will receive holiday pay for Thanksgiving and the Friday following. For this period, any hours in excess of 88 hours is considered overtime.

Complete the General Journal entries as follows:

30-Nov Journalize employee pay for the period. 30-Nov Journalize employer payroll tax for the November 30 pay date 03-Dec Journalize payment of payroll to employees (use one entry for all checks). 03-Dec Journalize remittance of 401(k) and health insurance premiums deducted 03-Dec Journalize remittance of monthly payroll taxes

Update the Employees' Earnings Records for the periods pay and update the 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). Be sure to capitalize the letters as shown. Enter all dates in mm/dd/yy format where year is entered as 1X.

General Journal Employee Grosspay AC Paycheck Payroll Register SP Paycheck SV Paycheck LH Paycheck SFS MW Paycheck Paycheck Semi-monthly Wage or Hourly Hours Worked Regular Name 11/16-11/30 Holiday Overtime Commission rate 88 hours (exempt) $ Chinson 2,325.00 Wayland 88 hours (exempt) 88 hours (exempt) Peppinico 90 hours (16 Holiday) Varden 91 hours (16 Holiday) Hissop 89 hours (16 Holiday) Student F Success previous next General Journal SP Paycheck AC Paycheck SV Paycheck Employee Grosspay Payroll Register MW LH Paycheck SFS Paycheck Paycheck Run Date 12/03/1X Company Name Wayland Custom Woodworking P/R Date 11/30/1X No. of No. of Hourly Rate or Semi- monthly wage Marital No. of Regular Hours Overtime No. of Gross Withholdings Earning Name Status hours Holiday Hours Commission Anthony Chinson Mark Wayland Sylvia Peppinico Stevon Varden Leonard Hissop Student F Success previ Taxable wages Taxable wages for for Federal W/H (After pre tax deductions and Social Federal W/H Medicare W/H Federal W/H Security ax (After pre tax deductions) State W/H 401(k) Net Pay Check No Check Date Insurance withholding allowances) Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174574 Anthony Chinson Date Dollars Payee: Anthony Chinson 530 Sylvann Ave Address: City/State/Zip: Logan, UT 84321 Signed: Mark Wayland Check # 174574 Payroll End Date: Payroll Pay Date: Anthony Chinson Employee # Rate Employee Name: 00-CHINS 11.54 Earnings YTD Gross Description YTD Deductions Description Deductions Regular Federal W/H Holiday SSI Commissions Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street 174575 Logan, UT 84321 Mark Wayland Date Dollars Mark Wayland Payee: 1570 Lovett St Address: City/State/Zip Logan, UT 84321 Signed: Mark Wayland Payroll Pay Date Check # 174575 Payroll End Date: Mark Wayland 36.06 Employee Name: Employee #: 00-WAYLA Rate: Description Description Earnings YTD Gross Deductions YTD Deductions Regular Federal W/H Holiday SSI Medicare State SD Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street 174576 Logan, UT 84321 Sylvia Peppinico Date Dollars Sylvia Peppinico Payee: Address: 291 Antioch Rd City/State/Zip: Signed: Mark Wayland Logan, UT 84321 Payroll Pay Date: Check #: Payroll End Date: 174576 Sylvia Peppinico Employee #: Employee Name: Rate: 01-PEPPI 20.91 Description Deductions Earnings YTD Gross Description YTD Deductions Regular Federal W/H Holiday SSI Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174577 Stevon Varden Date Dollars Payee: Stevon Varden Address: 333 Justin Dr City/State/Zip: Logan, UT 84321 Signed: Mark Wayland Check #: Payroll End Date: Payroll Pay Date: 174577 Stevon Varden 01-VARDE Rate: Employee Name: Employee #: 20.19 Description Earnings YTD Gross Deductions Description YTD Deductions Regular Federal W/H Overtime SSI Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174578 Leonard Hissop Date Dollars Leonard Hissop Payee: Address: 531 5th St City/State/Zip: Signed: Mark Wayland Logan, UT 84321 Payroll End Date: Check #: Payroll Pay Date: 174578 Leonard Hissop Employee # Employee Name: 02-HISSO Rate: 23.80 YTD Gross Description YTD Deductions Description Earnings Deductions Regular Federal W/H Overtime SSI Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174579 Student F Success Date Dollars Payee: Student F Success Address from student Address: City/State/Zip City/State/Zip Signed: Mark Wayland Payroll Pay Date: Check # 174579 Payroll End Date: Student F Success Employee Name: 17.31 Employee #: 00-STUDE Rate: YTD Gross Description YTD Deductions Description Earnings Deductions Federal W/H Regular SSI Overtime Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions view transaction list view general journal Journal Entry Worksheet 12 3 4 5 6 Journalize employee pay. General Journal Credit Date Debit Nov 30 *Enter debits before credits done clear entry record entry General Journal Employee Grosspay AC Paycheck Payroll Register SP Paycheck SV Paycheck LH Paycheck SFS MW Paycheck Paycheck Semi-monthly Wage or Hourly Hours Worked Regular Name 11/16-11/30 Holiday Overtime Commission rate 88 hours (exempt) $ Chinson 2,325.00 Wayland 88 hours (exempt) 88 hours (exempt) Peppinico 90 hours (16 Holiday) Varden 91 hours (16 Holiday) Hissop 89 hours (16 Holiday) Student F Success previous next General Journal SP Paycheck AC Paycheck SV Paycheck Employee Grosspay Payroll Register MW LH Paycheck SFS Paycheck Paycheck Run Date 12/03/1X Company Name Wayland Custom Woodworking P/R Date 11/30/1X No. of No. of Hourly Rate or Semi- monthly wage Marital No. of Regular Hours Overtime No. of Gross Withholdings Earning Name Status hours Holiday Hours Commission Anthony Chinson Mark Wayland Sylvia Peppinico Stevon Varden Leonard Hissop Student F Success previ Taxable wages Taxable wages for for Federal W/H (After pre tax deductions and Social Federal W/H Medicare W/H Federal W/H Security ax (After pre tax deductions) State W/H 401(k) Net Pay Check No Check Date Insurance withholding allowances) Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174574 Anthony Chinson Date Dollars Payee: Anthony Chinson 530 Sylvann Ave Address: City/State/Zip: Logan, UT 84321 Signed: Mark Wayland Check # 174574 Payroll End Date: Payroll Pay Date: Anthony Chinson Employee # Rate Employee Name: 00-CHINS 11.54 Earnings YTD Gross Description YTD Deductions Description Deductions Regular Federal W/H Holiday SSI Commissions Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street 174575 Logan, UT 84321 Mark Wayland Date Dollars Mark Wayland Payee: 1570 Lovett St Address: City/State/Zip Logan, UT 84321 Signed: Mark Wayland Payroll Pay Date Check # 174575 Payroll End Date: Mark Wayland 36.06 Employee Name: Employee #: 00-WAYLA Rate: Description Description Earnings YTD Gross Deductions YTD Deductions Regular Federal W/H Holiday SSI Medicare State SD Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street 174576 Logan, UT 84321 Sylvia Peppinico Date Dollars Sylvia Peppinico Payee: Address: 291 Antioch Rd City/State/Zip: Signed: Mark Wayland Logan, UT 84321 Payroll Pay Date: Check #: Payroll End Date: 174576 Sylvia Peppinico Employee #: Employee Name: Rate: 01-PEPPI 20.91 Description Deductions Earnings YTD Gross Description YTD Deductions Regular Federal W/H Holiday SSI Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174577 Stevon Varden Date Dollars Payee: Stevon Varden Address: 333 Justin Dr City/State/Zip: Logan, UT 84321 Signed: Mark Wayland Check #: Payroll End Date: Payroll Pay Date: 174577 Stevon Varden 01-VARDE Rate: Employee Name: Employee #: 20.19 Description Earnings YTD Gross Deductions Description YTD Deductions Regular Federal W/H Overtime SSI Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174578 Leonard Hissop Date Dollars Leonard Hissop Payee: Address: 531 5th St City/State/Zip: Signed: Mark Wayland Logan, UT 84321 Payroll End Date: Check #: Payroll Pay Date: 174578 Leonard Hissop Employee # Employee Name: 02-HISSO Rate: 23.80 YTD Gross Description YTD Deductions Description Earnings Deductions Regular Federal W/H Overtime SSI Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions Wayland Custom Woodworking 1716 Nichol street Logan, UT 84321 174579 Student F Success Date Dollars Payee: Student F Success Address from student Address: City/State/Zip City/State/Zip Signed: Mark Wayland Payroll Pay Date: Check # 174579 Payroll End Date: Student F Success Employee Name: 17.31 Employee #: 00-STUDE Rate: YTD Gross Description YTD Deductions Description Earnings Deductions Federal W/H Regular SSI Overtime Holiday Medicare State W/H Total Earnings Pretax Insurance 401(k) Total Deductions view transaction list view general journal Journal Entry Worksheet 12 3 4 5 6 Journalize employee pay. General Journal Credit Date Debit Nov 30 *Enter debits before credits done clear entry record entry