Kipley Company Payroll Register (Continuing Payroll Problem a)
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 - - MARITAL STATUS NO. OF W/H ALLOW. REGULAR EARNINGS OVERTIME EARNINGS DEDUCTIONS NET PAY TAXABLE EARNINGS HOURS WORKED RATE PER HOUR HOURS WORKED RATE PER HOUR TOTAL FICA GROUP HEALTH CHECK EMPLOYEE AMOUNT AMOUNT EARNINGS OASDI HI FIT SIT SUTA CIT SIMPLE INSURANCE INSURANCE NO. AMOUNT OASDI HI FUTA SUTA 11 Carson, Fran M. S 1 40 $7.50 $300.00 0 $0.00 - $300.00 12.60 4.35 17.00 9.21 0.24 9.00 20.00 0.85 1.65 313 $225.10 $300.00 $300.00 $300.00 $300.00 12 Wilson, William A. S 0 40 $7.25 $290.00 8 $10.88 87.04 $377.04 15.84 5.47 34.00 11.58 0.30 11.31 50.00 0.85 1.65 314 $246.04 $377.04 $377.04 $377.04 $377.04 13 Utley, Harry T. M 2 37.5 $8.10 $303.75 0 $0.00 - $303.75 12.76 4.40 - 9.33 0.24 9.11 40.00 0.85 1.65 315 $225.41 $303.75 $303.75 $303.75 $303.75 21 Fife, Lawrence R. M 4 40 $7.90 $316.00 6 $11.85 71.10 $387.10 16.26 5.61 - 11.88 0.31 11.61 50.00 0.85
Continuing Payroll Problem-A KIPLEY COMPANY, INC.
PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 - - MARITAL STATUS NO. OF W/H ALLOW. REGULAR EARNINGS OVERTIME EARNINGS DEDUCTIONS NET PAY TAXABLE EARNINGS HOURS WORKED RATE PER HOUR HOURS WORKED RATE PER HOUR TOTAL FICA GROUP HEALTH CHECK EMPLOYEE AMOUNT AMOUNT EARNINGS OASDI HI FIT SIT SUTA CIT SIMPLE INSURANCE INSURANCE NO. AMOUNT OASDI HI FUTA SUTA 11 Carson, Fran M. S 1 40 $7.50 $300.00 0 $0.00 - $300.00 12.60 4.35 17.00 9.21 0.24 9.00 20.00 0.85 1.65 313 $225.10 $300.00 $300.00 $300.00 $300.00 12 Wilson, William A. S 0 40 $7.25 $290.00 8 $10.88 87.04 $377.04 15.84 5.47 34.00 11.58 0.30 11.31 50.00 0.85 1.65 314 $246.04 $377.04 $377.04 $377.04 $377.04 13 Utley, Harry T. M 2 37.5 $8.10 $303.75 0 $0.00 - $303.75 12.76 4.40 - 9.33 0.24 9.11 40.00 0.85 1.65 315 $225.41 $303.75 $303.75 $303.75 $303.75 21 Fife, Lawrence R. M 4 40 $7.90 $316.00 6 $11.85 71.10 $387.10 16.26 5.61 - 11.88 0.31 11.61 50.00 0.85