Pay Rate	Hours Worked	Gross Pay	Deductions	Net Pay
Employee Number
	468921	15.00	28	420.00	325.00	95.00
	357942	16.50	50	825.00	205.00	620.00
	816543	5.00	40	200.00	45.00	245.00
	963248	57.60	40	2,304.00	10.00	2,294.00

1. Calculate examples of these batch totals:

• hash total
• financial total
• record count

Assume the following rules govern normal data:

• Employee numbers are five digits in length and range from 1000 through 99999.
• Maximum pay rate is $35, and minimum is $15.
• Hours worked should never exceed 40.
• Deductions should be between 10% and 35% of gross pay .

2. 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
• range check
• reasonableness test
• cross-footing balance test

3. Create a control procedure that would prevent, or at least detect, each of the errors in the data set.