ap5

profilealex1911
SC_EX_5-2.xlsx
Home>Business & Finance homework help>Operations Management homework help>ap5

Annual Totals

Annual Payroll Totals
Employee ID Hours Worked Gross Pay
JS214
JH873
SF297
PW122
Total

Qtr 1

Quarter One Totals
Employee Rate of Pay Hours Worked Gross Pay
JS214 13.22 260
JH873 10.25 500
SF297 19.08 520
PW122 18.55 495.5
Total

Qtr 2

Quarter Two Totals
Employee Rate of Pay Hours Worked Gross Pay
JS214 13.22 255
JH873 10.25 492
SF297 19.08 496
PW122 18.55 520
Total

Qtr 3

Quarter Three Totals
Employee Rate of Pay Hours Worked Gross Pay
JS214 13.22 220
JH873 10.25 520
SF297 19.08 476
PW122 18.55 512
Total

Qtr 4

Quarter Four Totals
Employee Rate of Pay Hours Worked Gross Pay
JS214 13.22 260
JH873 10.25 502
SF297 19.08 480
PW122 18.55 505.5
Total