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 data set.

Employee Numbeir 12355 2178g 24456 34567 HourS Net pay 275.90 45.00 8405.00 505.00 Pay rate worked 38 40 90 40 Gross Pa Deductions 10.55 11.00 95.00 10.00 400.90 440.00 8550.00 400.00 125.00 395.00 145.00 105.00