Enter the following data into a spreadsheet and then perform
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.
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help