3. Complete employee earnings record for the 4th quarter for each of the four employees. Divide the voluntary deductions from the payroll register appropriately across the associated columns within the employee earnings records. If directed to do so by your instructor, record the necessary journal entries for each pay period.
4. Complete Form 941 for both the 3rd and 4th quarters. Assume that the employees earned the same amount during each pay period of the 3rd quarter and that there were four, four, and five pay periods during the months of July, August, and September, respectively. Note that based on the lookback period, the company is a monthly depositor. Assume that all necessary deposits were made on a timely basis and that the employer made deposits equal to the total amount owed for each quarter. Although Vermont quarterly state payroll forms are also filed by Ampersand, Inc., you will not complete these. If directed to do so by your instructor, record the necessary journal entries associated with each Form 941 (including those required for any tax payments made).
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