Cash balance, December 16 Question 1 options Question 2 (1 point) Payroll cash balance, December 20 Question 2 options Question 3 (1 point) Total FICA taxes paid during November and December Question 3 options Question 4 (1 point) FICA taxes owed December 31 Question 4 options Question 5 (1 point) SIMPLE contributions for November Question 5 options Question 6 (1 point) Amount paid to employees, December 4 Question 6 options Question 7 (1 point) Union dues deducted, December 18 Question 7 options Question 8 (1 point) Total payroll deductions, December 4 Question 8 options Question 9 (1 point) O'Neill's taxable OASDI earnings, December 18 Question 9 options Question 10 (1 point) Total Plant Wages, December 18 Question 10 options Question 11 (1 point) Catherine Ford, total yearly earnings Question 11 options Question 12 (1 point) How many employees had SIMPLE deductions Question 12 options Question 13 (1 point) Total amount paid for overtime, fourth quarter Question 13 options Question 14 (1 point) Overtime rate for Bonno during October Question 14 options Question 15 (1 point) Ferguson's CIT deduction, November 20 Question 15 options Question 16 (1 point) Ferguson's FIT deduction, November Question 16 options Question 17 (1 point) Glo Brite Paint Company's total cost pertaining to payroll for the year Question 17 options Question 18 (1 point) Total Union Dues paid during the quarter Question 18 options Question 19 (1 point) Amount of State Income Tax paid, October 20 Question 19 options Question 20 (1 point) Total unemployment tax on wages for the quarter Question 20 options Question 21 (1 point) Norman Ryan's W 2 amount Box 3 Question 21 options Question 22 (1 point) Total wages reported on PA Form UC 2 Question 22 options Question 23 (1 point) Amount on Line 5 of Form 940 Question 23 options Question 24 (1 point) How much is the difference between Box 5a and Box 5c, Form 941, Column 1 Question 24 options Question 25 (1 point) Philadelphia Monthly Wage Tax for November Question 25 options Excel Templates for Payroll Project's Short Version The payroll project that follows is the Excel version of the Chapter 7 project beginning on page 7 16 of your text For this project, you will use the Appendix A Payroll Project Short Version file that is downloadable from the student companion Web site, linked in the Study Tools tab of your CNOWv2 course You are employed by Glo Brite Paint Company as the person in the Accounting Department responsible for the company's payroll processing using Excel This is the short version of the payroll project presented in Chapter 7 You will complete the payrolls for the month of December and the optional last quarter and year end activities The opening balance file you will use already contains all the processing through the first two months of the fourth quarter In order for you to complete all the transactions for the month of December, a review of the transactions starting with the November 20 payroll are explained In subsequent pay period processing, whenever a new operational procedure is used for the first time, additional instruction will be provided The Excel workbook has been set up like the project in Chapter 7 As explained earlier, there are five worksheets a worksheet including basic Excel instructions, the journal, the general ledger, the payroll register, and employees' earnings records Figure A 1, below, shows the five worksheets To navigate between worksheets, click the appropriate tab Figure A 1Worksheet Tabs 1 Excel Instructions worksheet has a shortened explanation of Excel The first part of this appendix should be reviewed whenever you have a question about Excel In addition, each Excel worksheet has been protected This means certain cells have been protected so changes can't be made to the information in those cells Cells have been protected because of formatting and when common equations are used Looking at the partial payroll register worksheet in Figure A 2, if you try to enter an amount in cell Z55 you will receive an error message that looks like the screen below The cell contains a formula used to automatically calculate total earnings for you and is protected so you aren't able to change it Figure A 2Protected Cell Error Message 2 Journal is called the book of original entry Transactions are recorded and then posted to the general ledger accounts Information for each payroll is taken from the Payroll Register to record the payroll entry 3 General Ledger is used to keep a continuous record of each account balance The chart of accounts in Figure A 3 is a partial list of Glo Brite's accounts and only includes the accounts necessary to complete this payroll project Figure A 3 Partial Chart of Accounts Account Title Account No Cash 11 Payroll Cash 12 FICA Taxes PayableOASDI 20 1 FICA Taxes PayableHI 20 2 FUTA Taxes Payable 21 SUTA Taxes PayableEmployer 22 Employees PIT Payable 24 Employees SIT Payable 25 Employees SUTA Payable 25 1 Employees CIT Payable 26 Group Insurance Premiums Collected 27 Union Dues Payable 28 Administrative Salaries 51 Office Salaries 52 Sales Salaries 53 Plant Wages 54 Payroll Taxes 56 4 Payroll Register provides the information needed for journalizing each payroll and for posting to the employees' earnings records 5 Employees' Earnings Records provides a summary of each employee's earnings, deductions, and taxable wages The information recorded in this worksheet is posted from the Payroll Register In addition, information in these records is used to prepare a Form W 2 Wage and Tax Statement for each employee From the personnel data given in Figure A 4, an employee's earnings record has been maintained for each employee These records have been maintained through the November 20 payroll and represent all earnings, wage changes, etc , through November 30 Figure A 4 Glo Brite Employees Personnel DataNovember 30, 20 BONNO, Anthony Victor, 694 Bristol Avenue, Philadelphia, PA 19135 0617 Married, claiming 4 withholding allowances Telephone, 555 9827 Social Security No 000 003481 Position, mixer operator in plant Wages, $17 60 per hour Group insurance, $55,000 FERGUSON, James Claude, 808 Sixth Street, Philadelphia, PA 19106 0995 Married, claiming 5 withholding allowances Telephone, 555 8065 Social Security No 000 008645 Position, sales manager Salary, $58,500 per year Group insurance, $88,000 Department Sales FORD, Catherine Louise, 18 Dundee Avenue, Philadelphia, PA 19151 1919 Divorced, claiming 2 withholding allowances Telephone, 555 0235 Social Security No 000 004567 Position, executive secretary Salary, $2,773 33 per month Group insurance, $50,000 Department Ofce MANN, Dewey Wilson, 3007 Bisque Drive, Philadelphia, PA 19199 0718 Married, claiming 0 withholding allowances Telephone, 555 0774 Social Security No 000 009352 Position, sales representative Salary, $2,925 per month Group insurance, $53,000 Department Sales O'NEILL, Joseph Tyler, 2100 Broad Street, Philadelphia, PA 19121 7189 Married, claiming 3 withholding allowances Telephone, 555 2332 Social Security No 000 001534 Position, president Salary, $60,000 per year, paid $2,307 69 biweekly Group insurance, $90,000 Department Administrative RUSSELL, Virginia Aloise, 8004 Dowling Road, Philadelphia, PA 19135 9001 Single, claiming 2 withholding allowances Telephone, 555 3681 Social Security No 000 006337 Position, time clerk Salary, $2,730 per month Group insurance, $49,000 Department Ofce RYAN, Norman Allen, 7300 Harrison Street, Philadelphia, PA 19124 6699 Married, claiming 4 withholding allowances Telephone, 555 6660 Social Security No 000 001223 Position, electrician in plant Wages, $18 00 per hour Group insurance, $56,000 SOKOWSKI, Thomas James, 133 Cornwells Street, Philadelphia, PA 19171 5718 Single, claiming 2 withholding allowances Telephone, 555 5136 Social Security No 000 00 8832 Position, supervisor in plant Salary, $1,025 per week Group insurance, $80,000 STUDENT, 7018 Erdrick Street, Philadelphia, PA 19135 8517 Single, claiming 1 withholding allowance Position, accounting trainee Wages, $14 00 per hour Group insurance, $39,000 Department Ofce WILLIAMS, Ruth Virginia, 9433 State Street, Philadelphia, PA 19149 0819 Single, claiming 0 withholding allowances Telephone, 555 5845 Social Security No 000 006741 Position, programmer Salary, $2,650 per month Group insurance, $48,000 Department Ofce WOODS, Beth Anne, 8102 Franklin Court, Philadelphia, PA 19105 0915 Single, claiming 1 withholding allowance Telephone, 555 1128 Social Security No 000 001587 Position, programmer Salary, $2,600 per month Group insurance, $47,000 Department Office Additional information from Chapter 7 you will need while completing the short version 1 General company information for Glo Brite Paint Company located at 2215 Salvador Street, Philadelphia, PA 19175 0682, phone number is 215 555 9559, federal identification number is 00 0000660, state account number is 000 0 3300, and city identifying number is 0000001855 2 In completing the time record columns of the payroll register for all workers, you should place an 8 in the day column for each full day worked If an employee works less than a full day, show the actual hours for which the employee will be paid 3 In the case of an employee who begins work during a pay period, compute the earnings by paying the employees their weekly rate for any full week worked For any partial week, compute the earnings for that week by multiplying the hours worked by the hourly rate of pay 4 If time lost is to be deducted from a salaried employee's pay, the employee's pay must be determined by multiplying the actual hours worked for that week by the hourly rate If hours are missed but no pay is deducted, include those hours in the Time Record columns on the payroll register The following schedule shows the weekly and hourly wage rates of the salaried employees Employee Weekly Rate Hourly Rate Ferguson, James C $1,125 00 $28 13 Ford, Catherine L 610 00 15 25 Mann, Dewey W 675 00 16 88 O'Neill, Joseph T 2,307 69 28 85 Russell, Virginia A 600 00 15 00 Sokowski, Thomas J 1,025 00 25 63 Williams, Ruth V 611 54 15 29 5 The workweek for all employees is 40 hours, except for the student's 36hour workweek 6 Overtime is paid to all employees except exempt administrative employeesthe president (O'Neill), the sales manager (Ferguson), the sales representative (Mann), and the supervisor (Sokowski) Overtime is paid at time and a half for any overtime exceeding 40 hours a week Bonno and Ryan are paid time and a half for any hours worked over eight each workday and for work on Saturdays and twice the regular hourly rate of pay for work on Sundays or holidays 7 Employees are paid biweekly on Friday Information for each pay period is provided in the time clerk's report 8 Federal income tax withholding is determined using the Biweekly Wage Bracket Tables located on pages T 7 and T 8 in the back of the textbook If in any pay period the taxable earnings exceed the table values, you will need to use the percentage method to determine FIT The filing status and withholding allowances for each employee can be located on the Employees' Earnings Records 9 Group term life insurance is carried on all employees in an amount equal to one and one half times the annual salary or wages paid each employee (rounded to the nearest thousand) A notation has been made on each employee's earnings record to show that each month, on the last payday of the month, 30 for each $1,000 of insurance coverage is deducted from the employee's earnings to pay a portion of the premium cost The amount deducted is credited to the liability account titled Group Insurance Premiums Collected The taxable portion of group term life insurance in excess of $50,000 is ignored since the employees pay for the insurance Example Anthony Bonno's earnings record indicates group insurance coverage in the amount of $55,000 The deduction for Group Insurance Premiums Collected would be $16 50 ($55,000 $1,000) $ 30 The $5,000 in coverage in excess of $50,000 is not taxable since Bonno is paying for the insurance coverage 10 Union dues of $8 are deducted each pay period from the wages of Bonno and Ryan The amount deducted is credited to the liability account titled Union Dues Payable The amount withheld during the preceding month is remitted to the union treasurer on or before the tenth of the month 11 Figure A 5 shows how salaries and wages are to be debited to the labor cost accounts This information is first entered in the Payroll Register in the columns titled Labor Cost Distribution Remember the Payroll Register is completed first and is used to update Employees' Earnings Records and to make the Journal entry Figure A 5Glo Brite Labor Cost Accounts 12 Payroll taxes are levied upon Glo Brite Company and its employees as shown in Figure A 6 Figure A 6 Glo Brite Payroll Taxes Payroll Taxes Levied upon Glo Brite Paint Company and Its Employees Federal Income Taxes (FIT) Withheld from each employee's gross earnings in accordance with information given on Form W 4 and employee's earnings record Wage bracket method is use to determine FIT withholding Pennsylvania State Income Taxes (SIT) 3 07 percent withheld from each employee's gross earnin during the fourthquarter Philadelphia City IncomeTaxes (CIT) 3 8809 percent withheld from gross earnings of each resident employee Pennsylvania State Unemployment Taxes (SUTA) Employee 0 06 percent (0 0006) on total gross earnings (no limit for theemployee's portion) Employer 3 6890 percent on rst $10,000 gross earnings paid each employee during th calendar year (PA rate for new employe Federal UnemploymentTaxes (FUTA) Employer Net tax rate of 0 6 percent on rst $7,0 gross earnings paid each worker in the calendar year Federal InsuranceContributions OASDI Employee and 6 2 percent on rst $132,900 of gross earnings paid each worker in the calend Act (FICA) Employer year (maximum OASDI tax of $8,239 80 HIEmployee 1 45 percent on total gross earnings pa each worker in thecalendar year, plus a additional 0 9 percent on wages over$200,000 HIEmployer 1 45 percent on total gross earnings pa each worker in thecalendar year 13 Payroll taxes are deposited according the rules shown in Figure A 7 Figure A 7 Deposit Rules Deposit Rules for Glo Brite Paint Company Federal The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in which the taxes were withheld Since Glo Brite is a new employer and has no tax liabilities during the lookback period, the company is subject to the monthly deposit mie Pennsylvan ia Since the state income taxes withheld total $1,000 or more each quarter, the company must remit the withheld taxes semimonthly The taxes must be remitted within three banking days after the semimonthly periods ending on the 15th and the last day of the month Philadelphi a Since the city income taxes withheld are more than $350 but less than $16,000 each month, the company is subject to the monthly rule The city income taxes withheld during the month must be remitted by the 15th day of the following month Excel Instructions CAUTION Read Appendix A for specific instructions relating to these templates 1 Enter the appropriate numbers formulas in the shaded (gray) cells An asterisk ( ) will appear to the right of an incorrect answer 2 A formula begins with an equals sign ( ) and can consist of any of the following elements Operators such as (for addition), (for subtraction), (for multiplication), and (for division) Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3 You can enter a formula into a cell manually (typing it in) or by pointing to the cells To enter a formula manually, follow these steps Move the cell pointer to the cell that you want to hold the formula Type an equals sign ( ) to signal the fact that the cell contains a formula Type the formula, then press Enter 4 Rounding These templates have been formatted to round numbers to either the nearest whole number or the nearest cent For example, 17 65 x 1 5 26 475 The template will display and hold 26 48, not 26 475 There is no need to use Excel's rounding function 5 Remember to save your work When saving your workbook, Excel overwrites the previous copy of your file You can save your work at any time You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter 7 long version Your Name xlsx To save under a different name, follow these steps Select File, Save As to display the Save As Type drop box, chose Excel Workbook ( xlsx) Select the folder in which to store the workbook Enter the new filename in the File name box Click Save Page 41 JOURNAL DATE DESCRIPTION POST REF DEBIT CREDIT 20 Oct 9 Payroll Cash Cash 12 11 12,315 64 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable OASDI FICA Taxes Payable HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20 1 20 2 24 25 25 1 26 28 12 2,307 69 4,651 08 3,600 00 4,898 00 9 Payroll Taxes FICA Taxes Payable OASDI FICA Taxes Payable HI FUTA Taxes Payable SUTA Taxes Payable Employer 56 20 1 20 2 21 22 1,381 61 12,315 64 958 33 224 14 859 00 474 55 9 25 599 86 16 00 12,315 64 958 32 224 12 22 91 176 26 Page 42 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT Page 43 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT Page 44 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT Page 45 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT Page 46 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT Page 47 JOURNAL DATE DESCRIPTION POST REF DEBIT CREDIT 20 Page 48 JOURNAL DATE 20 DESCRIPTION POST REF DEBIT CREDIT GENERAL LEDGER ACCOUNT Checkpoints CASH BALANCE POST DATE ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 Debit Balance ACCOUNT NO 11 a J41 199,846 33 12,315 64 187,530 69 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT PAYROLL CASH ITEM REF DEBIT J41 J41 12,315 64 CREDIT DEBIT 12,315 64 12,315 64 0 00 20 Oct 9 9 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 12 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT FICA TAXES PAYABLE OASDI ACCOUNT NO 20 1 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 9 J41 J41 958 33 958 32 DEBIT CREDIT Oct 31, 20 Nov 30, 20 958 33 Dec 31, 20 1,916 65 Checkpoints Debit Balance Credit Balance ACCOUNT FICA TAXES PAYABLE HI ACCOUNT NO 20 2 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 9 J41 J41 224 14 224 12 DEBIT CREDIT Oct 31, 20 Nov 30, 20 224 14 Dec 31, 20 448 26 Checkpoints Debit Balance Credit Balance ACCOUNT FUTA TAXES PAYABLE ACCOUNT NO 21 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 1 Balance 9 a J41 22 91 DEBIT CREDIT Oct 31, 20 Nov 30, 20 392 94 Dec 31, 20 415 85 Checkpoints Debit Balance Credit Balance ACCOUNT SUTA TAXES PAYABLE EMPLOYER ACCOUNT NO 22 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 J41 176 26 DEBIT CREDIT Oct 31, 20 Nov 30, 20 176 26 Dec 31, 20 Checkpoints Debit Balance Credit Balance ACCOUNT EMPLOYEES FIT PAYABLE ACCOUNT NO 24 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 J41 859 00 DEBIT CREDIT Oct 31, 20 Nov 30, 20 859 00 Dec 31, 20 Checkpoints Debit Balance Credit Balance ACCOUNT EMPLOYEES SIT PAYABLE ACCOUNT NO 25 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 J41 474 55 DEBIT CREDIT Oct 31, 20 Nov 30, 20 474 55 Dec 31, 20 Checkpoints Debit Balance Credit Balance ACCOUNT EMPLOYEES SUTA PAYABLE ACCOUNT NO 25 1 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 J41 9 25 DEBIT Checkpoints Debit Balance CREDIT Oct 31, 20 Nov 30, 20 9 25 Dec 31, 20 Credit Balance ACCOUNT EMPLOYEES CIT PAYABLE ACCOUNT NO 26 BALANCE POST DATE ITEM REF DEBIT CREDIT 20 Oct 9 J41 599 86 DEBIT CREDIT Oct 31, 20 Nov 30, 20 599 86 Dec 31, 20 Checkpoints Debit Balance Credit Balance ACCOUNT GROUP INSURANCE PREMIUMS COLLECTED 20 ITEM REF Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 27 DEBIT CREDIT DEBIT CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT UNION DUES PAYABLE ITEM REF DEBIT CREDIT 20 Oct 9 J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 28 16 00 DEBIT CREDIT Oct 31, 20 Nov 30, 20 16 00 Dec 31, 20 Credit Balance ACCOUNT SIMPLE CONTRIBUTIONS PAYABLE 20 ITEM REF Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 29 DEBIT CREDIT DEBIT CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT ADMINISTRATIVE SALARIES ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 a J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 51 2,307 69 42,692 27 44,999 96 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT OFFICE SALARIES ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 a J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 52 4,651 08 28,350 00 33,001 08 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT SALES SALARIES ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 a J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 53 3,600 00 28,525 00 32,125 00 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT PLANT WAGES ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 a J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 54 4,898 00 42,657 30 47,555 30 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance ACCOUNT PAYROLL TAXES ITEM REF DEBIT CREDIT DEBIT 20 Oct 1 Balance 9 a J41 Debit Balance BALANCE POST DATE Checkpoints ACCOUNT NO 56 1,381 61 14,353 07 15,734 68 CREDIT Oct 31, 20 Nov 30, 20 Dec 31, 20 Credit Balance Payday, October 9, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R No W H Allow NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs Hour For Period Ending October 3, 20 M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 8 8 8 8 8 8 8 8 8 8 TOTALS GLO BRITE PAINT COMPANY 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17 60 80 80 80 80 80 80 18 00 80 72 14 00 80 Amount Overtime Earnings Rate Per Hrs Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 87 30 139 50 75 64 83 70 143 08 74 40 89 28 127 10 62 50 75 83 20 42 32 63 17 69 19 58 33 46 17 40 20 88 29 73 14 62 17 73 31 00 104 00 83 00 25 00 150 00 99 00 33 00 138 00 75 00 121 00 43 23 69 08 37 45 41 45 70 85 36 84 44 21 62 94 30 95 37 55 0 84 1 35 0 73 0 81 1 38 0 72 0 86 1 23 0 60 0 73 15,456 77 15,456 77 958 33 224 14 859 00 474 55 9 25 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Payday, October 23, 20 For Period Ending October 17, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R TOTALS Payday, November 6, 20 For Period Ending October 31, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R TOTALS Payday, November 13, 20 For Period Ending November 14, 20 Williams, R TOTALS No W H Allow NAME Marital Status PAYROLL REGISTER Time Record S M T W T GLO BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs Hour Amount Overtime Earnings Rate Per Hrs Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA Payday, November 20, 20 For Period Ending November 14, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) TOTALS Payday, December 4, 20 For Period Ending November 28, 20 Bonno, A M 4 8 8 8 8 8 8 Ferguson, J M 5 8 8 8 8 8 Ford, C M 2 8 8 8 8 8 Mann, D M 0 8 8 8 8 8 O'Neill, J M 3 8 8 8 8 8 Russell, V S 2 8 8 8 8 8 Ryan, N M 4 8 8 8 8 8 Sokowski, T S 2 8 8 8 8 8 (Student) S 1 8 8 8 4 8 Woods, B S 1 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 10 8 8 8 8 8 8 8 8 8 8 TOTALS 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 88 80 80 80 80 80 79 80 72 72 17 60 28 12 16 00 16 88 28 85 15 75 18 00 25 63 14 00 15 00 1,548 80 2,249 60 1,280 00 1,350 40 2,308 00 1,260 00 1,422 00 2,050 40 1,008 00 1,080 00 15,557 20 8 26 40 0 00 0 00 0 00 211 40 1,760 20 2,249 60 1,280 00 1,350 40 2,308 00 1,260 00 1,422 00 2,050 40 1,008 00 1,080 00 109 13 139 48 79 36 83 72 143 10 78 12 88 16 127 12 62 50 66 96 25 52 32 62 18 56 19 58 33 47 18 27 20 62 29 73 14 62 15 66 211 40 15,768 60 977 65 228 65 0 00 0 00 0 00 0 00 0 00 0 00 0 00 54 04 69 06 39 30 41 46 70 86 38 68 43 66 62 95 30 95 33 16 1 06 1 35 0 77 0 81 1 38 0 76 0 85 1 23 0 60 0 65 0 00 484 12 9 46 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Payday, December 14, 20 For Period Ending December 12, 20 Russell, V TOTALS Payday, December 18, 20 For Period Ending December 12, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Ryan, N Sokowski, T (Student) Woods, B Young, P TOTALS QTR YEAR No W H Allow NAME Marital Status PAYROLL REGISTER Time Record S M T W T GLO BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs Hour Amount Overtime Earnings Rate Per Hrs Hour Amount Deductions Total Earnings OASDI HI 31,225 37 1,935 98 452 79 173,449 94 10,753 90 2,515 06 FIT SIT 859 00 958 67 16,776 00 5,324 96 SUTA 18 71 104 05 Deductions NAME Payday, October 9, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R TOTALS Net Paid CIT Group Ins Union Dues Ck SIMPLE No 0 00 16 00 Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin Office Sales Plant Checkpoints For Period Ending October 3, 20 54 64 8 00 87 32 47 35 52 39 89 56 46 57 55 88 8 00 79 56 39 12 47 47 599 86 Taxable Earnings 672 673 674 675 676 677 678 679 680 681 0 00 1,162 57 1,816 12 958 14 1,127 07 1,819 36 925 07 1,187 89 1,611 44 785 21 922 77 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 12,315 64 15,456 77 15,456 77 1,408 00 2,250 00 700 00 1,350 00 1,220 00 1,350 00 0 00 0 00 0 00 1,350 00 2,307 69 760 00 1,200 00 1,200 00 1,440 00 2,050 00 1,008 00 1,008 00 3,818 00 4,778 00 1,008 00 1,223 08 2,307 69 4,651 08 3,600 00 4,898 00 Checkpoints Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, November 6, 20 For Period Ending October 31, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, November 13, 20 For Period Ending November 14, 20 Williams, R TOTALS 0 00 0 00 0 00 15,456 77 12,315 64 1,220 00 Payday, October 23, 20 For Period Ending October 17, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) Williams, R TOTALS Total earnings Net paid Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 2,079 32 1,494 06 Deductions NAME Net Paid CIT Group Ins Union Dues Ck SIMPLE No Taxable Earnings Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin Office Sales Plant Checkpoints Payday, November 20, 20 For Period Ending November 14, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Russell, V Ryan, N Sokowski, T (Student) TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 TOTALS 611 96 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 4, 20 For Period Ending November 28, 20 Bonno, A 68 31 Ferguson, J 87 30 Ford, C 49 68 Mann, D 52 41 O'Neill, J 89 57 Russell, V 48 90 Ryan, N 55 19 Sokowski, T 79 57 (Student) 39 12 Woods, B 41 91 1,502 14 1,919 79 1,092 33 1,152 42 1,969 62 1,075 27 1,213 52 1,749 80 860 21 921 66 0 00 13,456 76 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 14, 20 For Period Ending December 12, 20 Russell, V TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 18, 20 For Period Ending December 12, 20 Bonno, A Ferguson, J Ford, C Mann, D O'Neill, J Ryan, N Sokowski, T Total earnings Net paid Checkpoints Annual (Student) Woods, B Young, P TOTALS Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Total earnings for SIT CIT Total earnings for FUTA 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Deductions NAME QTR YEAR Net Paid CIT 1,211 82 6,731 42 Group Ins 0 00 930 40 Union Ck Dues SIMPLE No 16 00 0 00 160 00 0 00 Taxable Earnings Amount OASDI HI FUTA 25,772 40 15,456 77 15,456 77 3,818 00 130,154 15 157,681 34 157,681 34 69,308 00 Labor Cost Distribution SUTA 4,778 00 88,268 00 Admin 2,307 69 Office 4,651 08 Sales 3,600 00 Plant 4,898 00 DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S S ACCOUNT NO 000 00 3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 $ 30 M 20 PAYDAY HRS RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 OVERTIME EARNINGS HRS RATE 10,293 40 1,408 00 YEAR TO DATE 1 $8 each pay REGULAR EARNINGS 17 60 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 11,322 00 12,730 00 Victor 17 60 26 40 W H MARITAL ALLOW STATUS 4 M DEDUCTIONS NET PAID FICA OASDI 1,028 60 0 00 0 00 0 00 0 00 0 00 0 00 MIDDLE OTHER HI 701 96 87 30 164 17 20 42 FIT SIT 810 00 31 00 SUTA 347 59 43 23 CIT 6 79 0 84 SIMPLE 439 40 54 64 CK DEDUCTIONS NO 216 80 8 00 AMOUNT 8,635 29 1,162 57 672 QTR TOT YR TOT Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S S ACCOUNT NO 000 00 8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 RATE AMOUNT HRS RATE 23,125 00 2,250 00 AMOUNT W H MARITAL ALLOW STATUS 5 M NET PAID 1,433 75 139 50 OTHER HI 335 31 32 63 FIT 2,291 00 104 00 SIT SUTA 709 94 69 08 QTR TOT YR TOT Checkpoint Claude FICA OASDI 23,125 00 25,375 00 James 58,500 yr 1,125 00 28 13 DEDUCTIONS EARNINGS YEAR TO DATE 1 CUMULATIVE MIDDLE Checkpoint 13 88 1 35 CIT 897 46 87 32 SIMPLE CK DEDUCTIONS NO AMOUNT 132 30 673 17,311 36 1,816 12 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S ACCOUNT NO M Office Executive Secretary x PA 000 00 4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 HRS RATE 80 Catherine 2,643 33 mo 610 00 15 25 22 88 Louise OASDI 6,300 00 7,520 00 W H MARITAL ALLOW STATUS 2 S DEDUCTIONS NET PAID FICA AMOUNT 6,300 00 1,220 00 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS MIDDLE F OTHER HI 390 60 75 64 91 35 17 69 FIT 639 00 83 00 SIT SUTA 193 41 37 45 3 78 0 73 CIT SIMPLE CK DEDUCTIONS NO 244 50 47 35 AMOUNT 37 80 4,699 56 958 14 674 QTR TOT YR TOT Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Sales Sales Representative S S ACCOUNT NO x PA 000 00 9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 CUMULATIVE 80 RATE AMOUNT HRS RATE 5,400 00 1,350 00 AMOUNT Wilson MARITAL ALLOW STATUS M NET PAID 334 80 83 70 OTHER HI 78 30 19 58 FIT 332 00 25 00 SIT 165 78 41 45 SUTA 3 24 0 81 CIT SIMPLE 209 57 52 39 TR TOT YR TOT Checkpoint W H 4 FICA OASDI 5,400 00 6,750 00 Dewey 2,925 mo 675 00 16 88 DEDUCTIONS EARNINGS HRS MIDDLE F Checkpoint CK DEDUCTIONS NO AMOUNT 31 50 675 4,244 81 1,127 07 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S ACCOUNT NO M Administrative President x PA 000 00 1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST O'NEILL $ $ $ $ SALARY UNION DUES OTHER BI WEEKLY RATE HOURLY RATE $90,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 HRS RATE 80 Joseph 60,000 yr 2,307 69 Tyler OASDI 42,692 27 44,999 96 W H MARITAL ALLOW STATUS 3 M DEDUCTIONS NET PAID FICA AMOUNT 42,692 27 2,307 69 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS MIDDLE F OTHER HI 2,646 92 143 08 619 04 33 46 FIT 6,116 00 150 00 SIT SUTA 1,310 65 70 85 25 62 1 38 CIT SIMPLE 1,656 84 89 56 CK DEDUCTIONS NO AMOUNT 202 50 30,114 70 1,819 36 676 TR TOT YR TOT Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Office Time Clerk x PA S S ACCOUNT NO NAME LAST 000 00 6337 RUSSELL OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 14 CUMULATIVE 80 RATE AMOUNT HRS RATE 6,240 00 1,200 00 AMOUNT Aloise MARITAL ALLOW STATUS S NET PAID 386 88 74 40 OTHER HI 90 48 17 40 FIT 642 00 99 00 SIT 191 56 36 84 SUTA 3 74 0 72 CIT SIMPLE 242 17 46 57 TR TOT YR TOT Checkpoint W H 1 FICA OASDI 6,240 00 7,440 00 Virginia 2,600 mo 600 00 15 00 22 50 DEDUCTIONS EARNINGS HRS MIDDLE F Checkpoint CK DEDUCTIONS NO AMOUNT 31 50 677 4,651 67 925 07 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Plant Electrician S S ACCOUNT NO x PA 000 00 1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 $ 30 M 20 $8 each pay REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 HRS RATE 13,287 50 1,440 00 YEAR TO DATE 1 OVERTIME RATE CUMULATIVE 18 00 18 00 27 00 OASDI 14,685 30 16,125 30 MARITAL ALLOW STATUS 4 M NET PAID FICA AMOUNT 1,397 80 0 00 0 00 0 00 0 00 0 00 0 00 Allen W H DEDUCTIONS EARNINGS HRS MIDDLE F OTHER HI 910 49 89 28 212 94 20 88 FIT 1,070 00 33 00 SIT SUTA 450 84 44 21 8 81 0 86 CIT SIMPLE 569 92 55 88 CK DEDUCTIONS NO 235 70 8 00 AMOUNT 678 11,226 60 1,187 89 QTR TOT YR TOT Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Plant Supervisor x PA S S ACCOUNT NO NAME LAST 000 00 8832 SOKOWSKI OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 CUMULATIVE 80 RATE AMOUNT HRS RATE 16,650 00 2,050 00 AMOUNT 1,025 00 25 63 STATUS M NET PAID 1,032 30 127 10 OTHER HI 241 43 29 73 FIT 2,002 00 138 00 SIT 511 16 62 94 SUTA 9 99 1 23 CIT SIMPLE 646 17 79 56 QTR TOT YR TOT Checkpoint MARITAL ALLOW 2 FICA OASDI 16,650 00 18,700 00 James W H DEDUCTIONS EARNINGS HRS MIDDLE F Checkpoint CK DEDUCTIONS NO AMOUNT 94 50 679 12,112 45 1,611 44 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S ACCOUNT NO M Office Accounting Trainee PA FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 72 HRS RATE 14 00 14 00 21 00 OASDI 5,550 00 6,558 00 W H MARITAL ALLOW STATUS 1 S DEDUCTIONS NET PAID FICA AMOUNT 5,550 00 1,008 00 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS MIDDLE Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST F OTHER HI 344 10 62 50 80 48 14 62 FIT 409 00 75 00 SIT SUTA 170 38 30 95 3 33 0 60 CIT SIMPLE CK DEDUCTIONS NO 215 39 39 12 AMOUNT 32 40 4,294 92 785 21 680 QTR TOT YR TOT Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Office Programmer x PA S S ACCOUNT NO NAME LAST 000 00 6741 WILLIAMS OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST Ruth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000 $ 30 M 20 OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 13 CUMULATIVE 80 RATE AMOUNT HRS RATE 10,260 00 1,223 08 AMOUNT MARITAL ALLOW STATUS S NET PAID 636 12 75 83 OTHER HI 148 77 17 73 FIT 1,606 00 121 00 SIT 314 98 37 55 SUTA 6 16 0 73 CIT SIMPLE 398 18 47 47 5 6 QTR TOT YR TOT Checkpoint W H 0 FICA OASDI 10,260 00 11,483 08 Virginia 2,650 mo 611 54 15 29 22 94 DEDUCTIONS EARNINGS HRS MIDDLE F Checkpoint CK DEDUCTIONS NO AMOUNT 59 40 681 7,090 39 922 77 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S ACCOUNT NO OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20 REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS RATE MARITAL STATUS NET PAID FICA AMOUNT W H ALLOW DEDUCTIONS EARNINGS HRS MIDDLE F OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK DEDUCTIONS NO AMOUNT YEAR TO DATE 1 2 3 4 5 12 4 6 12 18 QTR TOT YR TOT Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S ACCOUNT NO OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST UNION DUES $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20 REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS RATE AMOUNT STATUS OASDI OTHER HI FIT SIT SUTA CIT SIMPLE 1 2 3 4 5 12 18 QTR TOT YR TOT Checkpoint MARITAL NET PAID FICA YEAR TO DATE 6 W H ALLOW DEDUCTIONS EARNINGS HRS MIDDLE F Checkpoint CK DEDUCTIONS NO AMOUNT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S ACCOUNT NO OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20 REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS RATE MARITAL STATUS NET PAID FICA AMOUNT W H ALLOW DEDUCTIONS EARNINGS HRS MIDDLE F OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK DEDUCTIONS NO AMOUNT YEAR TO DATE 1 2 3 4 5 6 QTR TOT YR TOT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S ACCOUNT NO OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME LAST FIRST UNION DUES $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20 REGULAR EARNINGS OVERTIME EARNINGS PAYDAY 1 2 3 4 5 6 QTR TOT YR TOT CUMULATIVE RATE AMOUNT HRS RATE AMOUNT W H MARITAL ALLOW STATUS DEDUCTIONS EARNINGS HRS YEAR TO DATE MIDDLE F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK DEDUCTIONS NO AMOUNT

Question

Cash balance, December 16 Question 1 options  Question 2 (1 point) Payroll cash balance, December 20 Question 2 options  Question 3 (1 point) Total FICA taxes paid during November and December Question 3 options  Question 4 (1 point) FICA taxes owed December 31 Question 4 options  Question 5 (1 point) SIMPLE contributions for November Question 5 options  Question 6 (1 point) Amount paid to employees, December 4 Question 6 options  Question 7 (1 point) Union dues deducted, December 18 Question 7 options  Question 8 (1 point) Total payroll deductions, December 4 Question 8 options  Question 9 (1 point) O'Neill's taxable OASDI earnings, December 18 Question 9 options  Question 10 (1 point) Total Plant Wages, December 18 Question 10 options  Question 11 (1 point) Catherine Ford, total yearly earnings Question 11 options  Question 12 (1 point) How many employees had SIMPLE deductions  Question 12 options  Question 13 (1 point) Total amount paid for overtime, fourth quarter Question 13 options  Question 14 (1 point) Overtime rate for Bonno during October Question 14 options  Question 15 (1 point) Ferguson's CIT deduction, November 20 Question 15 options  Question 16 (1 point) Ferguson's FIT deduction, November Question 16 options  Question 17 (1 point) Glo Brite Paint Company's total cost pertaining to payroll for the year Question 17 options  Question 18 (1 point) Total Union Dues paid during the quarter Question 18 options  Question 19 (1 point) Amount of State Income Tax paid, October 20 Question 19 options  Question 20 (1 point) Total unemployment tax on wages for the quarter Question 20 options  Question 21 (1 point) Norman Ryan's W 2 amount  Box 3 Question 21 options  Question 22 (1 point) Total wages reported on PA Form UC 2 Question 22 options  Question 23 (1 point) Amount on Line 5 of Form 940 Question 23 options  Question 24 (1 point) How much is the difference between Box 5a and Box 5c, Form 941, Column 1 Question 24 options  Question 25 (1 point) Philadelphia Monthly Wage Tax for November Question 25 options  Excel Templates for Payroll Project's Short Version The payroll project that follows is the Excel version of the Chapter 7 project beginning on page 7 16 of your text  For this project, you will use the Appendix A  Payroll Project Short Version file that is downloadable from the student companion Web site, linked in the Study Tools tab of your CNOWv2 course  You are employed by Glo Brite Paint Company as the person in the Accounting Department responsible for the company's payroll processing using Excel  This is the short version of the payroll project presented in Chapter 7  You will complete the payrolls for the month of December and the optional last quarter and year end activities  The opening balance file you will use already contains all the processing through the first two months of the fourth quarter  In order for you to complete all the transactions for the month of December, a review of the transactions starting with the November 20 payroll are explained  In subsequent pay period processing, whenever a new operational procedure is used for the first time, additional instruction will be provided  The Excel workbook has been set up like the project in Chapter 7  As explained earlier, there are five worksheets  a worksheet including basic Excel instructions, the journal, the general ledger, the payroll register, and employees' earnings records  Figure A 1, below, shows the five worksheets  To navigate between worksheets, click the appropriate tab  Figure A 1Worksheet Tabs 1  Excel Instructions worksheet has a shortened explanation of Excel  The first part of this appendix should be reviewed whenever you have a question about Excel  In addition, each Excel worksheet has been protected  This means certain cells have been protected so changes can't be made to the information in those cells  Cells have been protected because of formatting and when common equations are used  Looking at the partial payroll register worksheet in Figure A 2, if you try to enter an amount in cell Z55 you will receive an error message that looks like the screen below  The cell contains a formula used to automatically calculate total earnings for you and is protected so you aren't able to change it  Figure A 2Protected Cell Error Message 2  Journal is called the book of original entry  Transactions are recorded and then posted to the general ledger accounts  Information for each payroll is taken from the Payroll Register to record the payroll entry  3  General Ledger is used to keep a continuous record of each account balance  The chart of accounts in Figure A 3 is a partial list of Glo Brite's accounts and only includes the accounts necessary to complete this payroll project  Figure A 3 Partial Chart of Accounts Account Title Account No  Cash 11 Payroll Cash 12 FICA Taxes PayableOASDI 20 1 FICA Taxes PayableHI 20 2 FUTA Taxes Payable 21 SUTA Taxes PayableEmployer 22 Employees PIT Payable 24 Employees SIT Payable 25 Employees SUTA Payable 25 1 Employees CIT Payable 26 Group Insurance Premiums Collected 27 Union Dues Payable 28 Administrative Salaries 51 Office Salaries 52 Sales Salaries 53 Plant Wages 54 Payroll Taxes 56 4  Payroll Register provides the information needed for journalizing each payroll and for posting to the employees' earnings records  5  Employees' Earnings Records provides a summary of each employee's earnings, deductions, and taxable wages  The information recorded in this worksheet is posted from the Payroll Register  In addition, information in these records is used to prepare a Form W 2 Wage and Tax Statement for each employee  From the personnel data given in Figure A 4, an employee's earnings record has been maintained for each employee  These records have been maintained through the November 20 payroll and represent all earnings, wage changes, etc , through November 30  Figure A 4 Glo Brite Employees Personnel DataNovember 30, 20  BONNO, Anthony Victor, 694 Bristol Avenue, Philadelphia, PA 19135 0617  Married, claiming 4 withholding allowances  Telephone, 555 9827  Social Security No  000 003481  Position, mixer operator in plant  Wages, $17 60 per hour  Group insurance, $55,000  FERGUSON, James Claude, 808 Sixth Street, Philadelphia, PA 19106 0995  Married, claiming 5 withholding allowances  Telephone, 555 8065  Social Security No  000 008645  Position, sales manager  Salary, $58,500 per year  Group insurance, $88,000  Department  Sales  FORD, Catherine Louise, 18 Dundee Avenue, Philadelphia, PA 19151 1919  Divorced, claiming 2 withholding allowances  Telephone, 555 0235  Social Security No  000 004567  Position, executive secretary  Salary, $2,773 33 per month  Group insurance, $50,000  Department  Ofce  MANN, Dewey Wilson, 3007 Bisque Drive, Philadelphia, PA 19199 0718  Married, claiming 0 withholding allowances  Telephone, 555 0774  Social Security No  000 009352  Position, sales representative  Salary, $2,925 per month  Group insurance, $53,000  Department  Sales  O'NEILL, Joseph Tyler, 2100 Broad Street, Philadelphia, PA 19121 7189  Married, claiming 3 withholding allowances  Telephone, 555 2332  Social Security No  000 001534  Position, president  Salary, $60,000 per year, paid $2,307 69 biweekly  Group insurance, $90,000  Department  Administrative  RUSSELL, Virginia Aloise, 8004 Dowling Road, Philadelphia, PA 19135 9001  Single, claiming 2 withholding allowances  Telephone, 555 3681  Social Security No  000 006337  Position, time clerk  Salary, $2,730 per month  Group insurance, $49,000  Department  Ofce  RYAN, Norman Allen, 7300 Harrison Street, Philadelphia, PA 19124 6699  Married, claiming 4 withholding allowances  Telephone, 555 6660  Social Security No  000 001223  Position, electrician in plant  Wages, $18 00 per hour  Group insurance, $56,000  SOKOWSKI, Thomas James, 133 Cornwells Street, Philadelphia, PA 19171 5718  Single, claiming 2 withholding allowances  Telephone, 555 5136  Social Security No  000 00 8832  Position, supervisor in plant  Salary, $1,025 per week  Group insurance, $80,000  STUDENT, 7018 Erdrick Street, Philadelphia, PA 19135 8517  Single, claiming 1 withholding allowance  Position, accounting trainee  Wages, $14 00 per hour  Group insurance, $39,000  Department  Ofce  WILLIAMS, Ruth Virginia, 9433 State Street, Philadelphia, PA 19149 0819  Single, claiming 0 withholding allowances  Telephone, 555 5845  Social Security No  000 006741  Position, programmer  Salary, $2,650 per month  Group insurance, $48,000  Department  Ofce  WOODS, Beth Anne, 8102 Franklin Court, Philadelphia, PA 19105 0915  Single, claiming 1 withholding allowance  Telephone, 555 1128  Social Security No  000 001587  Position, programmer  Salary, $2,600 per month  Group insurance, $47,000  Department  Office  Additional information from Chapter 7 you will need while completing the short version  1  General company information for Glo Brite Paint Company  located at 2215 Salvador Street, Philadelphia, PA 19175 0682, phone number is 215 555 9559, federal identification number is 00 0000660, state account number is 000 0 3300, and city identifying number is 0000001855  2  In completing the time record columns of the payroll register for all workers, you should place an 8 in the day column for each full day worked  If an employee works less than a full day, show the actual hours for which the employee will be paid  3  In the case of an employee who begins work during a pay period, compute the earnings by paying the employees their weekly rate for any full week worked  For any partial week, compute the earnings for that week by multiplying the hours worked by the hourly rate of pay  4  If time lost is to be deducted from a salaried employee's pay, the employee's pay must be determined by multiplying the actual hours worked for that week by the hourly rate  If hours are missed but no pay is deducted, include those hours in the Time Record columns on the payroll register  The following schedule shows the weekly and hourly wage rates of the salaried employees  Employee Weekly Rate Hourly Rate Ferguson, James C  $1,125 00 $28 13 Ford, Catherine L  610 00 15 25 Mann, Dewey W  675 00 16 88 O'Neill, Joseph T  2,307 69 28 85 Russell, Virginia A  600 00 15 00 Sokowski, Thomas J  1,025 00 25 63 Williams, Ruth V  611 54 15 29 5  The workweek for all employees is 40 hours, except for the student's 36hour workweek  6  Overtime is paid to all employees except exempt administrative employeesthe president (O'Neill), the sales manager (Ferguson), the sales representative (Mann), and the supervisor (Sokowski)  Overtime is paid at time and a half for any overtime exceeding 40 hours a week  Bonno and Ryan are paid time and a half for any hours worked over eight each workday and for work on Saturdays and twice the regular hourly rate of pay for work on Sundays or holidays  7  Employees are paid biweekly on Friday  Information for each pay period is provided in the time clerk's report  8  Federal income tax withholding is determined using the Biweekly Wage Bracket Tables located on pages T 7 and T 8 in the back of the textbook  If in any pay period the taxable earnings exceed the table values, you will need to use the percentage method to determine FIT  The filing status and withholding allowances for each employee can be located on the Employees' Earnings Records  9  Group term life insurance is carried on all employees in an amount equal to one and one half times the annual salary or wages paid each employee (rounded to the nearest thousand)  A notation has been made on each employee's earnings record to show that each month, on the last payday of the month, 30 for each $1,000 of insurance coverage is deducted from the employee's earnings to pay a portion of the premium cost  The amount deducted is credited to the liability account titled Group Insurance Premiums Collected  The taxable portion of group term life insurance in excess of $50,000 is ignored since the employees pay for the insurance  Example  Anthony Bonno's earnings record indicates group insurance coverage in the amount of $55,000  The deduction for Group Insurance Premiums Collected would be $16 50  ($55,000 $1,000) $ 30   The $5,000 in coverage in excess of $50,000 is not taxable since Bonno is paying for the insurance coverage  10  Union dues of $8 are deducted each pay period from the wages of Bonno and Ryan  The amount deducted is credited to the liability account titled Union Dues Payable  The amount withheld during the preceding month is remitted to the union treasurer on or before the tenth of the month  11  Figure A 5 shows how salaries and wages are to be debited to the labor cost accounts  This information is first entered in the Payroll Register in the columns titled Labor Cost Distribution  Remember the Payroll Register is completed first and is used to update Employees' Earnings Records and to make the Journal entry  Figure A 5Glo Brite Labor Cost Accounts 12  Payroll taxes are levied upon Glo Brite Company and its employees as shown in Figure A 6  Figure A 6 Glo Brite Payroll Taxes Payroll Taxes Levied upon Glo Brite Paint Company and Its Employees Federal Income Taxes (FIT) Withheld from each employee's gross earnings in accordance with information given on Form W 4 and employee's earnings record  Wage bracket method is use to determine FIT withholding  Pennsylvania State Income Taxes (SIT) 3 07 percent withheld from each employee's gross earnin during the fourthquarter  Philadelphia City IncomeTaxes (CIT) 3 8809 percent withheld from gross earnings of each resident employee  Pennsylvania State Unemployment Taxes (SUTA) Employee  0 06 percent (0 0006) on total gross earnings (no limit for theemployee's portion)  Employer  3 6890 percent on rst $10,000 gross earnings paid each employee during th calendar year (PA rate for new employe Federal UnemploymentTaxes (FUTA) Employer  Net tax rate of 0 6 percent on rst $7,0 gross earnings paid each worker in the calendar year  Federal InsuranceContributions OASDI Employee and 6 2 percent on rst $132,900 of gross earnings paid each worker in the calend Act (FICA) Employer  year (maximum OASDI tax of $8,239 80 HIEmployee  1 45 percent on total gross earnings pa each worker in thecalendar year, plus a additional 0 9 percent on wages over$200,000  HIEmployer  1 45 percent on total gross earnings pa each worker in thecalendar year  13  Payroll taxes are deposited according the rules shown in Figure A 7  Figure A 7 Deposit Rules Deposit Rules for Glo Brite Paint Company Federal The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in which the taxes were withheld  Since Glo Brite is a new employer and has no tax liabilities during the lookback period, the company is subject to the monthly deposit mie  Pennsylvan ia Since the state income taxes withheld total $1,000 or more each quarter, the company must remit the withheld taxes semimonthly  The taxes must be remitted within three banking days after the semimonthly periods ending on the 15th and the last day of the month  Philadelphi a Since the city income taxes withheld are more than $350 but less than $16,000 each month, the company is subject to the monthly rule  The city income taxes withheld during the month must be remitted by the 15th day of the following month  Excel Instructions CAUTION  Read Appendix A for specific instructions relating to these templates  1  Enter the appropriate numbers formulas in the shaded (gray) cells  An asterisk ( ) will appear to the right of an incorrect answer  2  A formula begins with an equals sign ( ) and can consist of any of the following elements  Operators such as   (for addition),   (for subtraction),   (for multiplication), and   (for division)  Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3  You can enter a formula into a cell manually (typing it in) or by pointing to the cells  To enter a formula manually, follow these steps  Move the cell pointer to the cell that you want to hold the formula  Type an equals sign ( ) to signal the fact that the cell contains a formula  Type the formula, then press Enter  4  Rounding  These templates have been formatted to round numbers to either the nearest whole number or the nearest cent  For example, 17 65 x 1 5 26 475  The template will display and hold 26 48, not 26 475  There is no need to use Excel's rounding function  5  Remember to save your work  When saving your workbook, Excel overwrites the previous copy of your file  You can save your work at any time  You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name  To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar  It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter 7 long version Your Name xlsx To save under a different name, follow these steps  Select File, Save As to display the Save As Type drop box, chose Excel Workbook (  xlsx) Select the folder in which to store the workbook  Enter the new filename in the File name box  Click Save  Page 41 JOURNAL DATE DESCRIPTION POST  REF  DEBIT CREDIT 20   Oct  9 Payroll Cash Cash 12 11 12,315 64 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable   OASDI FICA Taxes Payable   HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20 1 20 2 24 25 25 1 26 28 12 2,307 69 4,651 08 3,600 00 4,898 00 9 Payroll Taxes FICA Taxes Payable   OASDI FICA Taxes Payable   HI FUTA Taxes Payable SUTA Taxes Payable   Employer 56 20 1 20 2 21 22 1,381 61 12,315 64 958 33 224 14 859 00 474 55 9 25 599 86 16 00 12,315 64 958 32 224 12 22 91 176 26 Page 42 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT Page 43 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT Page 44 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT Page 45 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT Page 46 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT Page 47 JOURNAL DATE DESCRIPTION POST  REF  DEBIT CREDIT 20                   Page 48 JOURNAL DATE 20   DESCRIPTION POST  REF  DEBIT CREDIT GENERAL LEDGER ACCOUNT  Checkpoints CASH BALANCE POST  DATE ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 Debit Balance ACCOUNT NO  11 a J41 199,846 33 12,315 64 187,530 69 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  PAYROLL CASH ITEM REF  DEBIT J41 J41 12,315 64 CREDIT DEBIT 12,315 64 12,315 64 0 00 20   Oct  9 9 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  12 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  FICA TAXES PAYABLE   OASDI ACCOUNT NO  20 1 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 9 J41 J41 958 33 958 32 DEBIT CREDIT Oct  31, 20 Nov  30, 20 958 33 Dec  31, 20 1,916 65 Checkpoints Debit Balance Credit Balance ACCOUNT  FICA TAXES PAYABLE   HI ACCOUNT NO  20 2 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 9 J41 J41 224 14 224 12 DEBIT CREDIT Oct  31, 20 Nov  30, 20 224 14 Dec  31, 20 448 26 Checkpoints Debit Balance Credit Balance ACCOUNT  FUTA TAXES PAYABLE ACCOUNT NO  21 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  1 Balance 9 a J41 22 91 DEBIT CREDIT Oct  31, 20 Nov  30, 20 392 94 Dec  31, 20 415 85 Checkpoints Debit Balance Credit Balance ACCOUNT  SUTA TAXES PAYABLE   EMPLOYER ACCOUNT NO  22 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 176 26 DEBIT CREDIT Oct  31, 20 Nov  30, 20 176 26 Dec  31, 20   Checkpoints Debit Balance Credit Balance ACCOUNT  EMPLOYEES FIT PAYABLE ACCOUNT NO  24 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 859 00 DEBIT CREDIT Oct  31, 20 Nov  30, 20 859 00 Dec  31, 20   Checkpoints Debit Balance Credit Balance ACCOUNT  EMPLOYEES SIT PAYABLE ACCOUNT NO  25 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 474 55 DEBIT CREDIT Oct  31, 20 Nov  30, 20 474 55 Dec  31, 20   Checkpoints Debit Balance Credit Balance ACCOUNT  EMPLOYEES SUTA PAYABLE ACCOUNT NO  25 1 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 9 25 DEBIT Checkpoints Debit Balance CREDIT Oct  31, 20 Nov  30, 20 9 25 Dec  31, 20   Credit Balance ACCOUNT  EMPLOYEES CIT PAYABLE ACCOUNT NO  26 BALANCE POST  DATE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 599 86 DEBIT CREDIT Oct  31, 20 Nov  30, 20 599 86 Dec  31, 20   Checkpoints Debit Balance Credit Balance ACCOUNT  GROUP INSURANCE PREMIUMS COLLECTED 20   ITEM REF  Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  27 DEBIT CREDIT DEBIT CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  UNION DUES PAYABLE ITEM REF  DEBIT CREDIT 20   Oct  9 J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  28 16 00 DEBIT CREDIT Oct  31, 20 Nov  30, 20 16 00 Dec  31, 20   Credit Balance ACCOUNT  SIMPLE CONTRIBUTIONS PAYABLE 20   ITEM REF  Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  29 DEBIT CREDIT DEBIT CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  ADMINISTRATIVE SALARIES ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 a J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  51 2,307 69 42,692 27 44,999 96 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  OFFICE SALARIES ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 a J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  52 4,651 08 28,350 00 33,001 08 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  SALES SALARIES ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 a J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  53 3,600 00 28,525 00 32,125 00 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  PLANT WAGES ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 a J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  54 4,898 00 42,657 30 47,555 30 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance ACCOUNT  PAYROLL TAXES ITEM REF  DEBIT CREDIT DEBIT 20   Oct  1 Balance 9 a J41 Debit Balance BALANCE POST  DATE Checkpoints ACCOUNT NO  56 1,381 61 14,353 07 15,734 68 CREDIT Oct  31, 20 Nov  30, 20 Dec  31, 20   Credit Balance Payday, October 9, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  No  W H Allow  NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs  Hour For Period Ending October 3, 20 M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 8 8 8 8 8 8 8 8 8 8 TOTALS GLO BRITE PAINT COMPANY 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17 60 80 80 80 80 80 80 18 00 80 72 14 00 80 Amount Overtime Earnings Rate Per Hrs  Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 87 30 139 50 75 64 83 70 143 08 74 40 89 28 127 10 62 50 75 83 20 42 32 63 17 69 19 58 33 46 17 40 20 88 29 73 14 62 17 73 31 00 104 00 83 00 25 00 150 00 99 00 33 00 138 00 75 00 121 00 43 23 69 08 37 45 41 45 70 85 36 84 44 21 62 94 30 95 37 55 0 84 1 35 0 73 0 81 1 38 0 72 0 86 1 23 0 60 0 73 15,456 77 15,456 77 958 33 224 14 859 00 474 55 9 25 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Payday, October 23, 20   For Period Ending October 17, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  TOTALS Payday, November 6, 20   For Period Ending October 31, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  TOTALS Payday, November 13, 20   For Period Ending November 14, 20 Williams, R  TOTALS No  W H Allow  NAME Marital Status PAYROLL REGISTER Time Record S M T W T GLO BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs  Hour Amount Overtime Earnings Rate Per Hrs  Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA Payday, November 20, 20   For Period Ending November 14, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) TOTALS Payday, December 4, 20   For Period Ending November 28, 20 Bonno, A  M 4 8 8 8 8 8 8 Ferguson, J  M 5 8 8 8 8 8 Ford, C  M 2 8 8 8 8 8 Mann, D  M 0 8 8 8 8 8 O'Neill, J  M 3 8 8 8 8 8 Russell, V  S 2 8 8 8 8 8 Ryan, N  M 4 8 8 8 8 8 Sokowski, T  S 2 8 8 8 8 8 (Student) S 1 8 8 8 4 8 Woods, B  S 1 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 10 8 8 8 8 8 8 8 8 8 8 TOTALS 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 88 80 80 80 80 80 79 80 72 72 17 60 28 12 16 00 16 88 28 85 15 75 18 00 25 63 14 00 15 00 1,548 80 2,249 60 1,280 00 1,350 40 2,308 00 1,260 00 1,422 00 2,050 40 1,008 00 1,080 00 15,557 20 8 26 40 0 00 0 00 0 00 211 40 1,760 20 2,249 60 1,280 00 1,350 40 2,308 00 1,260 00 1,422 00 2,050 40 1,008 00 1,080 00 109 13 139 48 79 36 83 72 143 10 78 12 88 16 127 12 62 50 66 96 25 52 32 62 18 56 19 58 33 47 18 27 20 62 29 73 14 62 15 66 211 40 15,768 60 977 65 228 65 0 00 0 00 0 00 0 00 0 00 0 00 0 00 54 04 69 06 39 30 41 46 70 86 38 68 43 66 62 95 30 95 33 16 1 06 1 35 0 77 0 81 1 38 0 76 0 85 1 23 0 60 0 65 0 00 484 12 9 46 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Payday, December 14, 20   For Period Ending December 12, 20 Russell, V  TOTALS Payday, December 18, 20   For Period Ending December 12, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Ryan, N  Sokowski, T  (Student) Woods, B  Young, P  TOTALS QTR YEAR No  W H Allow  NAME Marital Status PAYROLL REGISTER Time Record S M T W T GLO BRITE PAINT COMPANY Regular Earnings Rate Per F S S M T W T F S Hrs  Hour Amount Overtime Earnings Rate Per Hrs  Hour Amount Deductions Total Earnings OASDI HI 31,225 37 1,935 98 452 79 173,449 94 10,753 90 2,515 06 FIT SIT 859 00 958 67 16,776 00 5,324 96 SUTA 18 71 104 05 Deductions NAME Payday, October 9, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  TOTALS Net Paid CIT Group Ins  Union Dues Ck  SIMPLE No  0 00 16 00 Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin  Office Sales Plant Checkpoints For Period Ending October 3, 20 54 64 8 00 87 32 47 35 52 39 89 56 46 57 55 88 8 00 79 56 39 12 47 47 599 86 Taxable Earnings 672 673 674 675 676 677 678 679 680 681 0 00 1,162 57 1,816 12 958 14 1,127 07 1,819 36 925 07 1,187 89 1,611 44 785 21 922 77 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 1,408 00 2,250 00 1,220 00 1,350 00 2,307 69 1,200 00 1,440 00 2,050 00 1,008 00 1,223 08 12,315 64 15,456 77 15,456 77 1,408 00 2,250 00 700 00 1,350 00 1,220 00 1,350 00 0 00 0 00 0 00 1,350 00 2,307 69 760 00 1,200 00 1,200 00 1,440 00 2,050 00 1,008 00 1,008 00 3,818 00 4,778 00 1,008 00 1,223 08 2,307 69 4,651 08 3,600 00 4,898 00 Checkpoints Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, November 6, 20   For Period Ending October 31, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, November 13, 20   For Period Ending November 14, 20 Williams, R  TOTALS 0 00 0 00 0 00 15,456 77 12,315 64 1,220 00 Payday, October 23, 20   For Period Ending October 17, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) Williams, R  TOTALS Total earnings Net paid Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 2,079 32 1,494 06 Deductions NAME Net Paid CIT Group Ins  Union Dues Ck  SIMPLE No  Taxable Earnings Amount OASDI HI FUTA Labor Cost Distribution SUTA Admin  Office Sales Plant Checkpoints Payday, November 20, 20   For Period Ending November 14, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Russell, V  Ryan, N  Sokowski, T  (Student) TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 TOTALS 611 96 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 4, 20   For Period Ending November 28, 20 Bonno, A  68 31 Ferguson, J  87 30 Ford, C  49 68 Mann, D  52 41 O'Neill, J  89 57 Russell, V  48 90 Ryan, N  55 19 Sokowski, T  79 57 (Student) 39 12 Woods, B  41 91 1,502 14 1,919 79 1,092 33 1,152 42 1,969 62 1,075 27 1,213 52 1,749 80 860 21 921 66 0 00 13,456 76 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 14, 20   For Period Ending December 12, 20 Russell, V  TOTALS 0 00 0 00 0 00 Total earnings Net paid 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Checkpoints Payday, December 18, 20   For Period Ending December 12, 20 Bonno, A  Ferguson, J  Ford, C  Mann, D  O'Neill, J  Ryan, N  Sokowski, T  Total earnings Net paid Checkpoints Annual (Student) Woods, B  Young, P  TOTALS Total earnings Qtr's taxable OASDI earnings Total earnings for FIT Total earnings for SIT CIT Total earnings for FUTA 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Deductions NAME QTR YEAR Net Paid CIT 1,211 82 6,731 42 Group Ins  0 00 930 40 Union Ck  Dues SIMPLE No  16 00 0 00 160 00 0 00 Taxable Earnings Amount OASDI HI FUTA 25,772 40 15,456 77 15,456 77 3,818 00 130,154 15 157,681 34 157,681 34 69,308 00 Labor Cost Distribution SUTA 4,778 00 88,268 00 Admin  2,307 69 Office 4,651 08 Sales 3,600 00 Plant 4,898 00 DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S S  ACCOUNT NO  000 00 3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000   $ 30 M 20    PAYDAY HRS  RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 OVERTIME EARNINGS HRS  RATE 10,293 40 1,408 00 YEAR TO DATE 1 $8 each pay REGULAR EARNINGS 17 60 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 11,322 00 12,730 00 Victor 17 60 26 40 W H MARITAL ALLOW  STATUS 4 M DEDUCTIONS NET PAID FICA OASDI 1,028 60 0 00 0 00 0 00 0 00 0 00 0 00 MIDDLE OTHER HI 701 96 87 30 164 17 20 42 FIT SIT 810 00 31 00 SUTA 347 59 43 23 CIT 6 79 0 84 SIMPLE 439 40 54 64 CK  DEDUCTIONS NO  216 80 8 00 AMOUNT 8,635 29 1,162 57 672 QTR  TOT  YR  TOT  Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S S  ACCOUNT NO  000 00 8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS  10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 RATE AMOUNT HRS  RATE 23,125 00 2,250 00 AMOUNT W H MARITAL ALLOW  STATUS 5 M NET PAID 1,433 75 139 50 OTHER HI 335 31 32 63 FIT 2,291 00 104 00 SIT SUTA 709 94 69 08 QTR  TOT  YR  TOT  Checkpoint Claude FICA OASDI 23,125 00 25,375 00 James 58,500  yr  1,125 00 28 13 DEDUCTIONS EARNINGS YEAR TO DATE 1 CUMULATIVE MIDDLE Checkpoint 13 88 1 35 CIT 897 46 87 32 SIMPLE CK  DEDUCTIONS NO  AMOUNT 132 30 673 17,311 36 1,816 12 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S  ACCOUNT NO  M Office Executive Secretary x PA 000 00 4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000  $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 HRS  RATE 80 Catherine 2,643 33  mo  610 00 15 25 22 88 Louise OASDI 6,300 00 7,520 00 W H MARITAL ALLOW  STATUS 2 S DEDUCTIONS NET PAID FICA AMOUNT 6,300 00 1,220 00 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS  MIDDLE F OTHER HI 390 60 75 64 91 35 17 69 FIT 639 00 83 00 SIT SUTA 193 41 37 45 3 78 0 73 CIT SIMPLE CK  DEDUCTIONS NO  244 50 47 35 AMOUNT 37 80 4,699 56 958 14 674 QTR  TOT  YR  TOT  Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Sales Sales Representative S S  ACCOUNT NO  x PA 000 00 9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 CUMULATIVE 80 RATE AMOUNT HRS  RATE 5,400 00 1,350 00 AMOUNT Wilson MARITAL ALLOW  STATUS M NET PAID 334 80 83 70 OTHER HI 78 30 19 58 FIT 332 00 25 00 SIT 165 78 41 45 SUTA 3 24 0 81 CIT SIMPLE 209 57 52 39 TR  TOT  YR  TOT  Checkpoint W H 4 FICA OASDI 5,400 00 6,750 00 Dewey 2,925  mo  675 00 16 88 DEDUCTIONS EARNINGS HRS  MIDDLE F Checkpoint CK  DEDUCTIONS NO  AMOUNT 31 50 675 4,244 81 1,127 07 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S  ACCOUNT NO  M Administrative President x PA 000 00 1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST O'NEILL $ $ $ $ SALARY UNION DUES OTHER BI WEEKLY RATE HOURLY RATE $90,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 HRS  RATE 80 Joseph 60,000  yr  2,307 69 Tyler OASDI 42,692 27 44,999 96 W H MARITAL ALLOW  STATUS 3 M DEDUCTIONS NET PAID FICA AMOUNT 42,692 27 2,307 69 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS  MIDDLE F OTHER HI 2,646 92 143 08 619 04 33 46 FIT 6,116 00 150 00 SIT SUTA 1,310 65 70 85 25 62 1 38 CIT SIMPLE 1,656 84 89 56 CK  DEDUCTIONS NO  AMOUNT 202 50 30,114 70 1,819 36 676 TR  TOT  YR  TOT  Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Office Time Clerk x PA S S  ACCOUNT NO  NAME   LAST 000 00 6337 RUSSELL OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 14 CUMULATIVE 80 RATE AMOUNT HRS  RATE 6,240 00 1,200 00 AMOUNT Aloise MARITAL ALLOW  STATUS S NET PAID 386 88 74 40 OTHER HI 90 48 17 40 FIT 642 00 99 00 SIT 191 56 36 84 SUTA 3 74 0 72 CIT SIMPLE 242 17 46 57 TR  TOT  YR  TOT  Checkpoint W H 1 FICA OASDI 6,240 00 7,440 00 Virginia 2,600  mo  600 00 15 00 22 50 DEDUCTIONS EARNINGS HRS  MIDDLE F Checkpoint CK  DEDUCTIONS NO  AMOUNT 31 50 677 4,651 67 925 07 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Plant Electrician S S  ACCOUNT NO  x PA 000 00 1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000    $ 30 M 20    $8 each pay REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 80 HRS  RATE 13,287 50 1,440 00 YEAR TO DATE 1 OVERTIME RATE CUMULATIVE 18 00 18 00 27 00 OASDI 14,685 30 16,125 30 MARITAL ALLOW  STATUS 4 M NET PAID FICA AMOUNT 1,397 80 0 00 0 00 0 00 0 00 0 00 0 00 Allen W H DEDUCTIONS EARNINGS HRS  MIDDLE F OTHER HI 910 49 89 28 212 94 20 88 FIT 1,070 00 33 00 SIT SUTA 450 84 44 21 8 81 0 86 CIT SIMPLE 569 92 55 88 CK  DEDUCTIONS NO  235 70 8 00 AMOUNT 678 11,226 60 1,187 89 QTR  TOT  YR  TOT  Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Plant Supervisor x PA S S  ACCOUNT NO  NAME   LAST 000 00 8832 SOKOWSKI OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 CUMULATIVE 80 RATE AMOUNT HRS  RATE 16,650 00 2,050 00 AMOUNT 1,025 00 25 63 STATUS M NET PAID 1,032 30 127 10 OTHER HI 241 43 29 73 FIT 2,002 00 138 00 SIT 511 16 62 94 SUTA 9 99 1 23 CIT SIMPLE 646 17 79 56 QTR  TOT  YR  TOT  Checkpoint MARITAL ALLOW  2 FICA OASDI 16,650 00 18,700 00 James W H DEDUCTIONS EARNINGS HRS  MIDDLE F Checkpoint CK  DEDUCTIONS NO  AMOUNT 94 50 679 12,112 45 1,611 44 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S S  ACCOUNT NO  M Office Accounting Trainee PA FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 10 9 2 10 23 3 11 6 4 11 20 5 12 4 6 12 18 72 HRS  RATE 14 00 14 00 21 00 OASDI 5,550 00 6,558 00 W H MARITAL ALLOW  STATUS 1 S DEDUCTIONS NET PAID FICA AMOUNT 5,550 00 1,008 00 YEAR TO DATE 1 CUMULATIVE EARNINGS HRS  MIDDLE Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST F OTHER HI 344 10 62 50 80 48 14 62 FIT 409 00 75 00 SIT SUTA 170 38 30 95 3 33 0 60 CIT SIMPLE CK  DEDUCTIONS NO  215 39 39 12 AMOUNT 32 40 4,294 92 785 21 680 QTR  TOT  YR  TOT  Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M Office Programmer x PA S S  ACCOUNT NO  NAME   LAST 000 00 6741 WILLIAMS OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FIRST Ruth $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000    $ 30 M 20    OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR TO DATE 1 10 9 2 10 23 3 11 6 4 11 13 CUMULATIVE 80 RATE AMOUNT HRS  RATE 10,260 00 1,223 08 AMOUNT MARITAL ALLOW  STATUS S NET PAID 636 12 75 83 OTHER HI 148 77 17 73 FIT 1,606 00 121 00 SIT 314 98 37 55 SUTA 6 16 0 73 CIT SIMPLE 398 18 47 47 5 6 QTR  TOT  YR  TOT  Checkpoint W H 0 FICA OASDI 10,260 00 11,483 08 Virginia 2,650  mo  611 54 15 29 22 94 DEDUCTIONS EARNINGS HRS  MIDDLE F Checkpoint CK  DEDUCTIONS NO  AMOUNT 59 40 681 7,090 39 922 77 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S  ACCOUNT NO  OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20    REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS  RATE MARITAL STATUS NET PAID FICA AMOUNT W H ALLOW  DEDUCTIONS EARNINGS HRS  MIDDLE F OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK  DEDUCTIONS NO  AMOUNT YEAR TO DATE 1 2 3 4 5 12 4 6 12 18 QTR  TOT  YR  TOT  Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S  ACCOUNT NO  OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST UNION DUES $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20    REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS  RATE AMOUNT STATUS OASDI OTHER HI FIT SIT SUTA CIT SIMPLE 1 2 3 4 5 12 18 QTR  TOT  YR  TOT  Checkpoint MARITAL NET PAID FICA YEAR TO DATE 6 W H ALLOW  DEDUCTIONS EARNINGS HRS  MIDDLE F Checkpoint CK  DEDUCTIONS NO  AMOUNT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S  ACCOUNT NO  OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20    REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE RATE AMOUNT HRS  RATE MARITAL STATUS NET PAID FICA AMOUNT W H ALLOW  DEDUCTIONS EARNINGS HRS  MIDDLE F OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK  DEDUCTIONS NO  AMOUNT YEAR TO DATE 1 2 3 4 5 6 QTR  TOT  YR  TOT  OCCUPATION DEPARTMENT WORKS IN (STATE) SEX M S S  ACCOUNT NO  OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME   LAST FIRST UNION DUES $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20    REGULAR EARNINGS OVERTIME EARNINGS PAYDAY 1 2 3 4 5 6 QTR  TOT  YR  TOT  CUMULATIVE RATE AMOUNT HRS  RATE AMOUNT W H MARITAL ALLOW  STATUS DEDUCTIONS EARNINGS HRS  YEAR TO DATE MIDDLE F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK  DEDUCTIONS NO  AMOUNT

Accepted Answer

The Answer is in the image, click to view ...

Question

Cash balance, December 16 Question 1 options: Question 2 (1 point) Payroll cash balance, December 20 Question 2 options: Question 3 (1 point) Total FICA

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Introduction To Financial Accounting

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question