a. Use Quick Sort for each column in the table and iden¬tify any concerns you have about the data. What are the internal control implications of the problems with the data? (Quick Sort)
b. Determine the total cost of all purchases, ignoring any concerns in part (a). What audit procedures would you conduct using the total figure? (Total)
c. Determine if there are any duplicates or missing numbers in the voucher file (Invoice column). State your audit concerns with any gaps or duplicates. Provide a possible explanation for any gaps or duplicates that you find. (Gaps and Duplicates)
d. Determine and print the total purchase for the period by product. (Summarize) Determine if the total cost is the same as in part (b). (Total) What product number has the greatest amount of purchases: (Quick Start) How would you further use this information during the conduct of the audit engagement?
e. Determine and print the percent of the total purchases by product. Save the classified file for use in requirement (f). (Classified) Based on that output, what percentage is product number 02413 3112 of the total amount?
f. Using the classified file from requirement (e), stratify and print the purchases by product. Exclude all items smaller than $1,000. Sort the items to determine the smallest and largest amounts. Use the smallest amount as the minimum in the Stratify window. Because the largest amount is significantly larger than all the other items, use the second highest amount as the maximum in the Stratify window. (Filter, Quick Sort, and Stratify) How would the auditor use this information during the audit?
This problem requires the use of ACL software. For this problem, use the Metaphor_Trans_2002 file in ACL_Demo, which is a file of purchase transactions. The suggest command or other source of information needed to solve the problem requirement is included at the end of each question.