Kipley Company Payroll Register (Continuing Payroll Problem a)

Only available on StudyMode
  • Topic: Payroll tax, Tax, Federal Insurance Contributions Act tax
  • Pages : 3 (718 words )
  • Download(s) : 2640
  • Published : February 21, 2013
Open Document
Text Preview
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 ENDINGJanuary 8, 20 - -
MARITAL STATUSNO. OF W/H ALLOW.REGULAR EARNINGSOVERTIME EARNINGSDEDUCTIONSNET PAYTAXABLE EARNINGS
HOURS WORKEDRATE PER HOURHOURS WORKEDRATE PER HOUR
TOTALFICA GROUPHEALTHCHECK
EMPLOYEEAMOUNTAMOUNTEARNINGSOASDIHIFITSITSUTACITSIMPLEINSURANCEINSURANCENO.AMOUNTOASDIHIFUTASUTA
11 Carson, Fran M. S140$7.50$300.000$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.S040$7.25$290.008$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. M237.5$8.10$303.750$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. M440$7.90$316.006$11.85 71.10 $387.10 16.26 5.61 - 11.88 0.31 11.61 50.00...
tracking img