# Question: This problem requires the use of ACL software which is 144835

This problem requires the use of ACL software, which is included in the CD attached to the text. Information about installing and using ACL and solving this problem can be found in Appendix, pages 838-842. You should read all of the reference material preceding the instructions about "Quick Sort" before locating the appropriate command to answer questions a-f. For this problem use the Metaphor-Trans-2002 file in ACL- Demo which is a file of purchase transactions. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.

Required

a. Use Quick Sort for each column in the table and identify any concerns you have about the data. (Quick Sort)

b. Determine the total cost of all purchases, ignoring any concerns in part a. (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 purchases 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 Sort)

e. Determine and print the percent of total purchases by product. Save the classified file for use in requirement f. (Classify) Based on that output, what percentage is product number 024133112 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 other items, use the second highest amount as the maximum in the Stratify window. (Filter, Quick Sort, and Stratify)

Required

a. Use Quick Sort for each column in the table and identify any concerns you have about the data. (Quick Sort)

b. Determine the total cost of all purchases, ignoring any concerns in part a. (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 purchases 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 Sort)

e. Determine and print the percent of total purchases by product. Save the classified file for use in requirement f. (Classify) Based on that output, what percentage is product number 024133112 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 other items, use the second highest amount as the maximum in the Stratify window. (Filter, Quick Sort, and Stratify)

## Relevant Questions

The proliferation of information technology (IT) has made governance of IT an important issue for businesses of all sizes and types, as well as their auditors. The IT Governance Institute has developed a wide range of ...State a test of control audit procedure to test the effectiveness of the following control: Approved wage rates are used in calculating employees' earnings.State a substantive test of transactions audit procedure to ...For each of the eight types of evidence discussed in Chapter 7, identify whether it is applicable for risk assessment procedures, tests of controls, substantive tests of transactions, analytical procedures, and tests of ...Multiple Choice QuestionsThe following questions concern types of audit tests.Choose the best response.a. The auditor looks for an indication on duplicate sales invoices to see whether the accuracy of invoices has been ...Following are several decisions that the auditor must make in an audit of a nonpublic company. Letters indicate alternative conclusions that could be made.Requireda. Identify the sequence in which the auditor should make ...Post your question