Robinson’s Plastic Pipe Corporation uses a computerized inventory data processing system. The basic input record to this system has the format shown in Table 9-8. You are performing an audit of source data controls for this system, and you have decided to use an input controls matrix for this purpose.

Required Prepare an input controls matrix using the same format and listing the same input controls as shown in Figure 9-3; however, replace the field names shown in Figure 9-3 with those of the inventory transaction file shown in Table 9-8. Place checks in the cells of the matrix that represent input controls you might expect to find for each field.

Figure 9-3 Input Controls Matrix Record Name: Field Names: Employee Weekly Time Report Input Controls Financial totals Hash totals Record counts Cross-footing balance Visual inspection Check digit verification Prenumbered forms Turnaround document Employee number Last name Department number Transaction code - Week ending (date) Regular hours Overtime hours Edit program Sequence check Field check Sign check Validity check Limit check Reasonableness test Redundant data check Completeness check Overflow procedure Other: Comments Yes No All fields No No Yes 223