Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello looking for help on 10.2b question its a long question on both pictures Give a specific example of an error or probable error in
Hello looking for help on 10.2b question its a long question on both pictures
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 data set. 10.2 Excel Problem Enter the data below into a spreadsheet, and then perform the following tasks: HOURS WORKED EMPLOYEE NUMBER 12355 21789 24456 34567 PAY RATE 10.55 11.00 95.00 10.00 GROSS PAY 400.90 440.00 8,550.00 400.00 40 DEDUCTIONS 125.00 395.00 145.00 105.00 NET PAY 275.90 45.00 8,405.00 505.00 90 a. Calculate examples of these batch totals: A hash 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 Maximum pay rate is $25, and minimum is $9. Hours worked should never exceed 40. Deductions should never exceed 40% of gross pay. through 99999. 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 data set. 10.2 Excel Problem Enter the data below into a spreadsheet, and then perform the following tasks: HOURS WORKED EMPLOYEE NUMBER 12355 21789 24456 34567 PAY RATE 10.55 11.00 95.00 10.00 GROSS PAY 400.90 440.00 8,550.00 400.00 40 DEDUCTIONS 125.00 395.00 145.00 105.00 NET PAY 275.90 45.00 8,405.00 505.00 90 a. Calculate examples of these batch totals: A hash 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 Maximum pay rate is $25, and minimum is $9. Hours worked should never exceed 40. Deductions should never exceed 40% of gross pay. through 99999Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started