Ferret Out Spreadsheet Errors

Ferret Out Spreadsheet Errors - 8.90 40 3 356.00 40.05...

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 502.00 0.00 502.00 Carlton 9.60 40 2 384.00 38.80 422.80 Daniels 10.20 35 0 408.00 0.00 408.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 432.00 0.00 432.00 Hartford 9.90 40 9 396.00 133.65 529.65 Totals: 305 21 $3,324.00 $319.15 $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: $14.00 40.00 10.00 $560.00 Maximims found: $12.55 40.00 9.00 $502.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: 3/15/XX Payroll totals Adams
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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

Ferret Out Spreadsheet Errors - 8.90 40 3 356.00 40.05...

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