preview

Kipley Company Payroll Register (Continuing Payroll Problem a)

Satisfactory Essays

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 - - …show more content…

M 3 40 $515.00 1.25 $19.32 24.15 $539.15 22.64 7.82 12.00 16.55 0.43 16.17 40.00 0.85 1.65 318 $421.04 $539.15 $539.15 $539.15 $539.15 32 Robey, Glenda B. M 6 40 $392.31 0 $0.00 - $392.31 16.48 5.69 - 12.04 0.31 11.77 50.00 0.85 1.65 319 $293.52 $392.31 $392.31 $392.31 $392.31 33 Schork, Thomas K. S 1 40 $542.31 0 $0.00 - $542.31 22.78 7.86 47.00 16.65 0.43 16.27 60.00 1.65 320 $369.67 $542.31 $542.31 $542.31 $542.31 51 Hardy, Barbara T. M 5 40 $348.46 4 $13.07 52.28 $400.74 16.83 5.81 - 12.30 0.32 12.02 30.00 0.85 1.65 321 $320.96 $400.74 $400.74 $400.74 $400.74 99 Kipley, Carson C. M 7 40 $1,000.00 $0.00 $0.00 - $1,000.00 42.00 14.50 26.00 30.70 0.80 30.00 80.00 0.85 1.65 322 $773.50 $1,000.00 $1,000.00 $1,000.00 $1,000.00 Totals $4,397.83 234.57 $4,632.40 194.57 67.17 156.00 142.21 3.69 138.96 440.00 6.80 16.50 $3,466.50 $4,632.40 $4,632.40 $4,632.40 $4,632.40

Get Access