olney companies inc payroll register

Name:
CAUTION: See "round" rules in Excel Instructions before calculating OT for slaried 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-B
OLNEY 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 Mangino, R. s 1 40 $8.50 340.00 0 $12.75 - 340.00 313
12 Flores, I. s 0 40 9.25 370.00 10 $13.88 138.80 508.80 314
13 Palmetto, C. m 2 38.5 7.80 300.30 0 $16.05 - 300.30 315
21 Waters, R. m 3 40 10.70 428.00 7 $16.05 112.35 540.35 316
22 Kroll, C. s 2 40 13.80 552.00 0 $20.70 - 552.00 317
31 Ruppert, C. m 3 40 800.00 1 1/4 $30.00 37.50 837.50 318
32 Scott, W. m 4 40 780.00 0 - 780.00