AutoSave O OFF A A P . C ... Project (1) - Saved to my Mac Q Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri (Body) 20 AA = ab Wrap Text v General LY AP - O. Paste BI UV MvAv EE Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Add-ins Formatting as Table Styles Filter Select A1 X V fx PAYROLL PROJECT D E F G H K L M N 0 Q R S T U V W X PAYROLL PROJECT N 3 General Information: 4 Home office and the Manufacturing Plant of Glo-Brite Paint Company are located at 2215 Salavador Street, Philadelphia, PA 19175-0682 5 Their Federal Identification number is 00-0000660; State account number 000-0-3300 and city identifying number 000-0001855 6 The workweek for all employees is 40 hours except for the student who has 36 hour work week 7 All employees are paid time and a half for any hours worked over 40 hours a week and for work on Saturdays and they get double time for working on Sundays 8 Employees are paid biweekly on Friday. Since the weekly time clerk's report is not finished until the Monday following the end of each week, the first pay on 9 October 23rd will be for the weeks ending October 10th and October 17th Federal Income Taxes- Use the tax tables or the manual method to calculate federal taxes 11 Pennsylvania State Income Tax Rate- 3.07% 12 Philadelphia City Income Tax Rate 3.8712% 13 Pennsylvania State Unemployment Tax Rate: Employee .06% on total gross earnings (no limit for the employee's portion); Employer 3.6890% on first $10,000 gross earnings paid each employee during calander year 15 Federal Unemployment Tax Rate: Employer Net tax of 0.6% on first $7,000 gross earnings paid each worker in the calander year 16 FICA Taxes-Employee and Employer: OASDI (Social security) 6.2% on first $137,700; Employee: Medicare 1.45% on total gross earnings per 17 calandar year plus additional 0.9% on wages over $200,000 18 Each month they deduct 30 cents for each $1,000 of insurance coverage from the employee's earnings to pay a portion of the 19 premium cost. The amount withheld is credited to a liabilty account entitled Group Insurance Premiums Collected. 20 Both workers in the plant (Bonno and Ryan) are union members. $8 is deducted each payday from the plant worker's earnings for union dues, assessments, and initiation fees. 21 Employee Personal Information 3 BONNO, ANTHONY, Married Fililing Joint(MFJ), Postion: Mixer Operator in Plant, Wages $17.60 per hour. Group Insurance $55,000 24 FERGUSON JAMES, Married Fililing Joint(MFJ), Postion: Sales Manager, Salary $58,500 per year. Group Insurance $88,000. Department: Sales 25 FORD, CATHERINE, Single, Postion: Executive Secretary, Salary $2,643.33 per month. Group Insurance $48,000, Department: Office 26 MANN DEWEY, Married Filing Jointly (MFJ), Postion: Sales Representative, Salary $2,925 per month. Group Insurance $53,000, Department:Sales 27 O'NEILL JOSEPH, Married Filing Joint(MFJ), Postion: Executive Secretary, Salary $60,000 per year, paid $2,307.69 biweekly. Group Insurance $90,000, Department: Adminstrative 28 RUSSELL VIRGINIA, Single, Postion: Time Clerk, Salary $2,600 per month. Group Insurance $47,000, Department: Office 29 RYAN NORMAN, Married Filing Joint (MFJ), Postion: Electrician in Plant, Wages $18 per hour. Group Insurance $56,000 30 SOKOWSKI THOMAS, , Married Filing Joint (MFJ) Postion: Supervisor in Plant, Salary $1,025 per week. Group Insurance $80,000 31 STUDENT, Single, Postion: Accounting Trainee, Wages $14 per hour. Group Insurance $39,000, Department: Office 32 WILLIAMS RUTH, Single, Postion:Programer, Salary $2,650 per month. Group Insurance $48,000, Department: Office 33 Glo Brite Labor Cost Accounts 35 Personnel IAccounts to be Charged Information & Instructions Payroll Register Journal + Ready Accessibility: Investigate + 100%AutoSave O OFF A A P . C ... Project (1) - Saved to my Mac Q Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri (Body) v 11 AA ab Wrap Text v General LY AP - O. Paste IUV DV Av E Merge & Center v $ ~ % " 00 80 Conditional Format Cell Insert Delete Format Sort & Find & Add-ins Formatting as Table Styles Filter Select L18 X V fx B D F G H M N P Q R W Z REGULAR EARNINGS OVERTIME EARNINGS DEDUCTIONS NET PAID TAXABLE EARNINGS LABOR Name Rate Rat TOTAL Status Marital Per Amount OASDI Hours Hours Worked Worker Pe Amount EARNINGS HI FIT SIT SUTA CIT Group Union Dues SIMPLE Check Hou Tax Tax Amount HI SUTA Hour Ins . OASDI Deduction No . FUTA Admin Page Page B Information & Instructions Payroll Register Journal + Ready ux Accessibility: Investigate + 90%AutoSave O OFF A A P . C ... Project (1) - Saved to my Mac Q Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri (Body) v 11 AA = ab Wrap Text v General IX LY AP - O. V v = $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Add-ins Paste BIUV DVAv E E Merge & Center v Formatting as Table Styles Filter Select U25 fx B E G H J K M N P Q R S T U A Date Description Debit Credit 1 36 37 36 38 37 39 38 40 39 41 40 42 41 43 42 44 43 Information & Instructions Payroll Register Journal + 100% Ready Accessibility: Investigate +