{"id":12010,"date":"2021-10-28T12:25:46","date_gmt":"2021-10-28T12:25:46","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/wayland-custom-woodworking-is-a-firm-that-manufactures-custom\/"},"modified":"2021-10-28T12:25:46","modified_gmt":"2021-10-28T12:25:46","slug":"wayland-custom-woodworking-is-a-firm-that-manufactures-custom","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/wayland-custom-woodworking-is-a-firm-that-manufactures-custom\/","title":{"rendered":"Wayland custom woodworking is a firm that manufactures custom"},"content":{"rendered":"<div>\n<p>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.<br \/>\u00a0<br \/>Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland\u2019s 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.\u00a0<br \/>\u00a0\u00a0<br \/>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.<\/p>\n<p>\u00a0<\/p>\n<p>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.<\/p>\n<p>\u00a0<\/p>\n<p>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\u2019s 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\u2019s 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.<\/p>\n<p>\u00a0<\/p>\n<p>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.\u00a0<\/p>\n<p>\u00a0\u00a0<\/p>\n<table border=\"0\">\n<tbody>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 Federal Withholding Allowance (less 401(k), Section 125)<\/td>\n<td>$166.70 per allowance claimed<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Semimonthly Federal Percentage Method Tax Table<\/td>\n<td><a rel=\"nofollow noopener\" target=\"_blank\" style=\"font-size: 14px; color: #326195; text-align: inherit; vertical-align: baseline;\" href=\"http:\/\/ezto.mheducation.com\/extMedia\/bne\/accounting\/Landin_2e\/Appendix_C.pdf\">Appendix C<\/a>, Page 270, Table #3<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Federal Unemployment Rate (Federal unemployment rate less Section 125 health insurance)<\/td>\n<td>6.0% on the first $7,000 of wages<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 State Withholding Rate (less 401(k), Section 125)<\/td>\n<td>See\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" style=\"font-size: 14px; color: #326195; text-align: inherit; vertical-align: baseline;\" href=\"http:\/\/ezto-demo.mheducation.com\/bec_spi\/13570164304578960388.tp4?REQUEST=SHOWmedia&amp;media=utah.png\">Utah Schedule 3<\/a><\/td>\n<\/tr>\n<tr>\n<td>State Unemployment Rate (less Section 125)<\/td>\n<td>2.6% on the first $31,300 of wages<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<table width=\"750\" border=\"0\">\n<tbody>\n<tr>\n<td colspan=\"7\">Wayland Custom Woodworking<br \/>Balance Sheet<br \/>9\/30\/2015<\/td>\n<\/tr>\n<tr>\n<td colspan=\"3\">Assets<\/td>\n<td>\u00a0<\/td>\n<td colspan=\"3\">Liabilities &amp; Equity<\/td>\n<\/tr>\n<tr>\n<td width=\"31%\">\u00a0\u00a0Cash<\/td>\n<td width=\"2%\">$<\/td>\n<td width=\"10%\">1,125,000.00<\/td>\n<td width=\"3%\">\u00a0<\/td>\n<td width=\"42%\">Accounts Payable<\/td>\n<td width=\"2%\">$<\/td>\n<td width=\"10%\">112,490.00\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Supplies<\/td>\n<td>\u00a0<\/td>\n<td>27,240.00<\/td>\n<td>\u00a0<\/td>\n<td>Salaries and Wages Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Office Equipment<\/td>\n<td>\u00a0<\/td>\n<td>87,250.00<\/td>\n<td>\u00a0<\/td>\n<td>Federal Unemployment Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Inventory<\/td>\n<td>\u00a0<\/td>\n<td>123,000.00<\/td>\n<td>\u00a0<\/td>\n<td>Social Security Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Vehicle<\/td>\n<td>\u00a0<\/td>\n<td>25,000.00<\/td>\n<td>\u00a0<\/td>\n<td>Medicare Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Accumulated Depreciation, Vehicle<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>State Unemployment Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Building<\/td>\n<td>\u00a0<\/td>\n<td>164,000.00<\/td>\n<td>\u00a0<\/td>\n<td>Employee Federal Income Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Accumulated Depreciation, Building<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>Employee State Income Tax Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Land<\/td>\n<td>\u00a0<\/td>\n<td>35,750.00<\/td>\n<td>\u00a0<\/td>\n<td>401(k) Contributions Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td align=\"right\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td align=\"right\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td>\u00a0<\/td>\n<td>Employee Medical Premiums Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a0Total Assets<\/td>\n<td>\u00a0<\/td>\n<td>1,587,240.00<\/td>\n<td>\u00a0<\/td>\n<td>Notes Payable<\/td>\n<td>\u00a0<\/td>\n<td>244,750.00\u00a0\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td align=\"right\">\n<hr\/>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td align=\"right\">\n<hr\/>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td>\u00a0<\/td>\n<td>Utilities Payable<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td><em>Total Liabilities<\/em><\/td>\n<td>\u00a0<\/td>\n<td>337,240.00\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>Owners&#8217; Equity<\/td>\n<td>\u00a0<\/td>\n<td>1,250,000.00\u00a0\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>Retained Earnings<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td><em>Total Equity<\/em><\/td>\n<td>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td>\n<hr\/>\n<p>1,250,000.00\u00a0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td><em>Total Liabilities and Equity<\/em><\/td>\n<td>\u00a0<\/td>\n<td>1,587,240.00\u00a0<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\n<hr\/>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<td>\n<hr\/>\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<td>\u00a0<\/td>\n<\/tr>\n<tr>\n<td colspan=\"7\" align=\"left\" valign=\"middle\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<p>October 1:<\/p>\n<p>Wayland Custom Woodworking (WCW) pays its employees according to their job classification. The following employees comprise Wayland\u2019s staff:<\/p>\n<p>\u00a0<\/p>\n<table width=\"550\" border=\"0\">\n<tbody>\n<tr>\n<td>\u00a0\u00a0Employee Number<\/td>\n<td>Name and Address<\/td>\n<td>Payroll information<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a000-Chins<\/td>\n<td>Anthony Chinson<br \/>530 Sylvann Avenue<br \/>Logan, UT 84321<br \/>435-555-1212<br \/>Job title: Account Executive<\/td>\n<td>Married, 1 withholding allowance<br \/>Exempt<br \/>$24,000\/year + commission<br \/>Start Date: 10\/1\/2015<br \/>SSN: 511-22-3333<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a000-Wayla<\/td>\n<td>Mark Wayland<br \/>1570 Lovett Street<br \/>Logan, UT 84321<br \/>435-555-1110<br \/>Job title: President\/Owner<\/td>\n<td>Married, 5 withholding allowances<br \/>Exempt<br \/>$75,000\/year<br \/>Start Date: 10\/1\/2015<br \/>SSN: 505-33-1775<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a001-Peppi<\/td>\n<td>Sylvia Peppinico<br \/>291 Antioch Road<br \/>Logan, UT 84321<br \/>435-555-2244<br \/>Job title: Craftsman<\/td>\n<td>Married, 7 withholding allowances<br \/>Exempt<br \/>$43,500\/year<br \/>Start Date: 10\/1\/2015<br \/>SSN: 047-55-9951<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a001-Varde<\/td>\n<td>Stevon Varden<br \/>333 Justin Drive<br \/>Logan, UT 84321<br \/>435-555-9981<br \/>Job title: Craftsman<\/td>\n<td>Married, 2 withholding allowances<br \/>Nonexempt<br \/>$42,000\/year<br \/>Start Date: 10\/1\/2015<br \/>SSN: 022-66-1131<\/td>\n<\/tr>\n<tr>\n<td>\u00a0\u00a002-Hisso<\/td>\n<td>Leonard Hissop<br \/>531 5<sup>th<\/sup>\u00a0Street<br \/>Logan, UT 84321<br \/>435-555-5858<br \/>Job title: Purchasing\/Shipping<\/td>\n<td>Single, 4 withholding allowance<br \/>Nonexempt<br \/>$49,500\/year<br \/>Start Date: 10\/1\/2015<br \/>SSN: 311-22-6698<\/td>\n<\/tr>\n<tr>\n<td colspan=\"3\" align=\"left\" valign=\"middle\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0\u00a0<br \/>Voluntary deductions for each employee are as follows:<br \/>\u00a0\u00a0<\/p>\n<table>\n<tbody>\n<tr>\n<td>Name \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/td>\n<td>Deduction \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Chinson<\/td>\n<td>Insurance: $50\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): 3% of gross pay<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Wayland<\/td>\n<td>Insurance: $75\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): 6% of gross pay<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Peppinico<\/td>\n<td>Insurance: $75\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): $50 per paycheck<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Varden<\/td>\n<td>Insurance: $50\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): 4% of gross pay<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Hissop<\/td>\n<td>Insurance: $75\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): 3% of gross pay<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\">\u00a0\u00a0Student<\/td>\n<td>Insurance: $50\/paycheck<\/td>\n<\/tr>\n<tr>\n<td>401(k): 3% of gross pay<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\">\n<hr\/>\n<p>\u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0\u00a0<br \/>The departments are as follows:<\/p>\n<p>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0Department 00: Sales and Administration<\/p>\n<p>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0Department 01: Factory workers<\/p>\n<p>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0Department 02: Delivery and Customer service<br \/>\u00a0\u00a0<br \/>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.<br \/>\u00a0<\/p>\n<p>\u00a0<br \/>2. Complete the headers of the Employees&#8217; Earnings Records for all company employees. Enter the YTD earnings for each employee.<\/p>\n<p><span>rev: 03_30_2016_QC_CS-46759, 07_09_2016_QC_CS-52845, 07_13_2016_QC_CS-52845<\/span><\/p>\n<p>\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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.\u00a0Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-12010","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/12010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=12010"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/12010\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=12010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=12010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=12010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}