This problem requires the use of ACL software, which can be accessed through the textbook website. Information about downloading and using ACL and the commands used in this problem can also be found on the textbook website.
You should read all of the reference material preceding the instructions about “Quick Sort” before locating the appropriate command to answer parts a. through f. For this problem, use the file labeled “Purchase_Orders” in the “Acquisitions_Payment” subfolder of the ACL_Rockwood project. The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
a. Determine the total amount of all purchases. (Total)
b. To better understand the purchasing activity, stratify and print the purchases by purchase amount. Use $100 as the minimum value and $100,000 as the maximum value, and create 10 strata. Which stratum accounts for the greatest number of purchases?
Required
Research
Required
Research
Required
Data
Analytics
412Part 2 / THE AUDIT PROCESS
c. Determine whether there are any duplicates or missing purchase order numbers in
the file. State your audit concerns with any gaps or duplicates. Provide a possible
explanation for any gaps or duplicates that you find.
d. How many purchase orders relate to purchases that did not have a requisition ? What is the total dollar amount of purchases made without a requisition? State your audit concerns related to purchases without a requisition.
e. Determine and print the percent of total purchases by vendor number. Do any ven-
dors account for more than 5 percent of total purchases?
f. Rockwood requires a second approval for all purchases exceeding $100,000. Select
all purchases greater than $100,000 and print the list for follow-up testing of proper
approval.
