Payroll Accounting 2012 Continuing Payroll Problem a
Name:
Ashley Pitchford
CAUTION: See "round" rules in Excel Instructions before calculating OT for salaried employees. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
Continuing Payroll Problem-A KIPLEY COMPANY, INC.
PAYROLL REGISTER
FOR PERIOD ENDING
January 8, 20 - NO. OF W/H ALLOW.
REGULAR EARNINGS
HOURS WORKED HOURS WORKED
OVERTIME EARNINGS TOTAL AMOUNT EARNINGS OASDI FICA HI FIT SIT
DEDUCTIONS GROUP SUTA CIT SIMPLE INSURANCE HEALTH INSURANCE
MARITAL STATUS
EMPLOYEE
RATE PER HOUR
AMOUNT
RATE PER HOUR
11 Carson, Fran M. 12 Wilson, William A. 13 Utley, Harry T. 21 Fife, Lawrence R. 22 Smith, Lucy K. 31 Fay, Gretchen R. 32 Robey, Glenda B. 33 Schork, Thomas K. 51 Hardy, Barbara T. 99 Kipley, Carson C. Totals
S S M M S M M S M M
1 0 2 4 2 3 6 1 5 7
40 40 37.5 40 40 40 40 40 40 40
$7.50 $7.25 $8.10 $7.90 $9.75
300.00 290.00 303.75 316.00 390.00 515.00 392.31 542.31 348.46 1,000.00 4,397.83 4 $13.07 52.28 234.57 1.25 $19.32 24.15 6 $11.85 71.10 8 $10.88 87.04
300.00 377.04 303.75 387.10 390.00 539.15 392.31 542.31 400.74 1,000.00 4,632.40
18.60 23.38 18.83 24.00 24.18 33.43 24.32 33.62 24.85 62.00 287.21
4.35 5.47 4.40 5.61 5.66 7.82 5.69 7.86 5.81 14.50 67.17
18.00 35.00 21.00 13.00 48.00 28.00 163.00
9.21 11.58 9.33 11.88 11.97 16.55 12.04 16.65 12.30 30.70 142.21
0.24 0.30 0.24 0.31 0.31 0.43 0.31 0.43 0.32 0.80 3.69
9.00 11.31 9.11 11.61 11.70 16.17 11.77 16.27 12.02 30.00 138.96
20.00 50.00 40.00 50.00 20.00 40.00 50.00 60.00 30.00 80.00 440.00
0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 6.80
1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 16.50
JOURNAL
DATE DESCRIPTION DEBIT CREDIT
20-Jan. 12
Wages and Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable Group
Ashley Pitchford
CAUTION: See "round" rules in Excel Instructions before calculating OT for salaried employees. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
Continuing Payroll Problem-A KIPLEY COMPANY, INC.
PAYROLL REGISTER
FOR PERIOD ENDING
January 8, 20 - NO. OF W/H ALLOW.
REGULAR EARNINGS
HOURS WORKED HOURS WORKED
OVERTIME EARNINGS TOTAL AMOUNT EARNINGS OASDI FICA HI FIT SIT
DEDUCTIONS GROUP SUTA CIT SIMPLE INSURANCE HEALTH INSURANCE
MARITAL STATUS
EMPLOYEE
RATE PER HOUR
AMOUNT
RATE PER HOUR
11 Carson, Fran M. 12 Wilson, William A. 13 Utley, Harry T. 21 Fife, Lawrence R. 22 Smith, Lucy K. 31 Fay, Gretchen R. 32 Robey, Glenda B. 33 Schork, Thomas K. 51 Hardy, Barbara T. 99 Kipley, Carson C. Totals
S S M M S M M S M M
1 0 2 4 2 3 6 1 5 7
40 40 37.5 40 40 40 40 40 40 40
$7.50 $7.25 $8.10 $7.90 $9.75
300.00 290.00 303.75 316.00 390.00 515.00 392.31 542.31 348.46 1,000.00 4,397.83 4 $13.07 52.28 234.57 1.25 $19.32 24.15 6 $11.85 71.10 8 $10.88 87.04
300.00 377.04 303.75 387.10 390.00 539.15 392.31 542.31 400.74 1,000.00 4,632.40
18.60 23.38 18.83 24.00 24.18 33.43 24.32 33.62 24.85 62.00 287.21
4.35 5.47 4.40 5.61 5.66 7.82 5.69 7.86 5.81 14.50 67.17
18.00 35.00 21.00 13.00 48.00 28.00 163.00
9.21 11.58 9.33 11.88 11.97 16.55 12.04 16.65 12.30 30.70 142.21
0.24 0.30 0.24 0.31 0.31 0.43 0.31 0.43 0.32 0.80 3.69
9.00 11.31 9.11 11.61 11.70 16.17 11.77 16.27 12.02 30.00 138.96
20.00 50.00 40.00 50.00 20.00 40.00 50.00 60.00 30.00 80.00 440.00
0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 6.80
1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 16.50
JOURNAL
DATE DESCRIPTION DEBIT CREDIT
20-Jan. 12
Wages and Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable Group