1. Establish an employee earnings record for each of the company's four employees. Complete the top portion of each record.
2. Establish and complete the payroll register for each weekly pay period in the fourth quarter. When calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of November 26, Stacey Jones requests that her federal withholding allowances decrease from two to one (Ampersand, Inc., makes this change). Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Payroll checks are remitted to the employees in the same order (Hough, Finnegan, Jones, Stewart) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in October is check #4711. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage
Ampersand, Inc., is a small business that operates in Somerset, VT. The company is located at 732 Appalachian Way, Somerset, VT 05363. Its federal and state identification numbers are 12-3456789, its state unemployme number is 2222222, and its president, who signs all tax forms, is Stacey Jones (telephone #802-555-3917). Th business does not wish to name a 3rd party designee on forms. Within QuickBooks the industry associated wi the company is General Business Service and the business type is Corporation. Ampersand, Inc., is on a weekly payroll schedule. During 2016 four individuals are employed by Ampersand, Inc. These employees are as follows. Social Federal W/H State W/H Marital Name Address Security # Allowances Allowances Status William Finnegan 7 Smith Boulevard 999-99-9999 2 2 Married Somerset, VT 05363 Maggie Hough 13 Spruce Street 222-22-2222 Single Somerset, VT 05363 Stacey Jones 81 10 Browning Place 555-55-5555 2 Single Somerset, VT 05363 Francine Stewart 101 Park Court 888-88-8888 3 3 Married Somerset, VT 05363Social Federal W/H State W/H Marital Name Address Security # Allowances Allowances Status William Finnegan 7 Smith Boulevard 999-99-9999 2 2 Married Somerset, VT 05363 Maggie Hough 13 Spruce Street 222-22-2222 - 7 Single Somerset, VT 05363 Stacey Jones 81 10 Browning Place 555-55-5555 2 Single Somerset, VT 05363 Francine Stewart 101 Park Court 888-88-8888 3 3 Married Somerset, VT 05363 Note that Francine Stewart was hired in September, and her first day of work was Monday, September 26. Additionally, due to an economic downturn, Maggie Hough was laid off in late November, with her last day of work on Friday, November 25.All employees of Ampersand, Inc., work a regular 40-hour workweek, receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Wednesday for the prior week (which runs from Monday through Sunday, although employees never work on weekends). The SUTA tax rate applicable to Ampersand, Inc., is 2.5%, while the SUTA wage base in Vermont is $16,800. Earnings and voluntary deduction information for each of the four employees is as follows. Regular Annual Weekly 401(k) Weekly Charitable Name Wage Rate Salary Deduction Contribution William Finnegan $18/hour N/A 4% of gross pay $5 Maggie Hough $14/hour N/A 5% of gross pay $10 Stacey Jones N/A $262,000.44 N/A $15 Francine Stewart N/A $94,000.40 2% of gross pay N/A The first three quarters of the year have passed, and all payroll-related activity has been properly accounted for as of 9/30/2016. Note that retirement deductions are made in association with the Franklin Insurance Agency. Quarterly payroll data for each of the four employees is as follows.William Finnegan Gross Federal State Social Medicare 401(k) Charitable Quarter Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter $9,360.00 $494.00 $449.28 $580.32 $135.72 $374.40 $65.00 2nd quarter $9,360.00 $494.00 $449.28 $580.32 $135.72 $374.40 $65.00 3rd quarter $9,360.00 $494.00 $449.28 $580.32 $135.72 $374.40 $65.00 Maggie Hough Gross Federal State Social Medicare 401(k) Charitable Quarter Earnings Income Tax Income Tax Security Tax Tax Deduction Cont. 1st quarter $7,280.00 $689.00 $345.80 $451.36 $105.56 $364.00 $130.00 2nd quarter $7,280.00 $689.00 $345.80 $451.36 $105.56 $364.00 $130.00 3rd quarter $7,280.00 $689.00 $345.80 $451.36 $105.56 $364.00 $130.00
