I need help to solve my 3 month project for payroll accounting.
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 053637. Based on the QuickBooks reports previously generated, complete Copy A of Form W2 for each of the four employees using the blank PDF form available in the Student Exercise Files download from the Learning Resource Center (labyrinthelab.com/lrc). State wages were the same as federal wages for each of the four employees, and the state identication number for Ampersand, Inc., is the same as its federal Employer Identication Number. 8. Based on the QuickBooks reports previously generated, complete Form W3 for Ampersand, Inc. Note that the company les the paper version of the form and selects "None apply\" in the Kind of Employer section. 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 - 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
