Enter the following data into a spreadsheet and then perform the following tasks:

a. Calculate examples of these batch totals:
• A has total
• A financial total
• A record count
b. Assume the following rules govern normal data:
• Employee numbers are five-digits in length and range from 10000 through 99999.
• Maximum pay rate is $25, and minimum is $9.
• Hours worked should never exceed 40.
• Deductions should never exceed 40% of gross pay.
Give a specific example of an error or probable error in the data set that each of the following controls would detect:
• Field check
• Limit check
• Reasonableness test
• Cross-footing balance test
c. Create a control procedure that would prevent, or at least detect, each of the errors in the dataset.

  • CreatedDecember 19, 2014
  • Files Included
Post your question