Excel Assignment 10

Excel Assignment 10 - 3/15/XX Payroll totals Adams 8.90 40 3 356.00 40.05 396.05 Baker 35 502.00 0.00 502.00 Carlton 9.60 40 2 384.00 38.80 422.80

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Choi Construction Company Payroll for week ending: 3/15/XX Payrate Regular pay Payroll totals Adams 8.90 40 3 356.00 40.05 396.05 Baker 12.55 35 0 439.25 0.00 439.25 Bampire 10.00 40 0 400.00 0.00 400.00 Carlton 9.60 40 2 384.00 38.80 422.80 Daniels 10.20 35 0 357.00 0.00 357.00 Englert 9.60 40 5 384.00 72.00 456.00 Franklin 11.55 40 2 462.00 34.65 496.65 Griffin 10.80 35 0 378.00 0.00 378.00 Hartford 9.90 40 9 396.00 133.65 529.65 Patel 11.11 40 5 444.40 83.33 527.73 Young 12.00 35 10 420.00 180.00 600.00 Totals: 420 36 $4,420.65 $582.48 $5,003.13 Audit module Counts: 11 7 Payroll column total: $5,003.13 Sum: Regular pay + Overtime pay: 5,003.13 Match? Yes Maximums allowed: $14.00 40.00 10.00 $560.00 Maximims found: $12.55 40.00 10.00 $462.00 Values acceptable? Yes Yes Yes Yes ________________________________________________ (Signature) I have examined this spreadsheet and vouch for its accuracy and completeness. Regular hours Overtime hours Overtime pay
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Choi Construction Company Payroll for week ending:
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3/15/XX Payroll totals Adams 8.90 40 3 356.00 40.05 396.05 Baker ### 35 502.00 0.00 502.00 Carlton 9.60 40 2 384.00 38.80 422.80 Daniels ### 35 408.00 0.00 408.00 Englert 9.60 40 5 384.00 72.00 456.00 Franklin ### 40 2 462.00 34.65 496.65 Griffin ### 35 432.00 0.00 432.00 Hartford 9.90 40 9 396.00 133.65 529.65 Totals: 305 21 ### ### $3,643.15 Audit module Counts: 8 5 Payroll column total: $3,643.15 Sum: Regular pay + Overtime pay: 3,643.15 Match? Yes Maximums allowed: ### 40.00 10.00 ### Maximims found: ### 40.00 9.00 ### Values acceptable? Yes Yes Yes Yes ________________________________________________ (Signature) I have examined this spreadsheet and vouch for its accuracy and completeness. Pay rate Regula r hours Overti me hours Regular pay Overti me pay...
View Full Document

This note was uploaded on 03/28/2012 for the course ACC 319 taught by Professor William during the Spring '12 term at Columbia College.

Page1 / 2

Excel Assignment 10 - 3/15/XX Payroll totals Adams 8.90 40 3 356.00 40.05 396.05 Baker 35 502.00 0.00 502.00 Carlton 9.60 40 2 384.00 38.80 422.80

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online