$12-35($OBJECTIVE $12-7)$ This problem requires the use of ACL software, which can be

accessed through the textbook Web site. Information about downloading and using ACL

and the commands used in this problem can also be found on the textbook Web site. 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 cre$-$

ate $10$ strata. Which stratum accounts for the greatest number of purchases? $($Stratify$)$

c$.$ Determine if 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. $($Gaps and Duplicates$)$

d$.$ How many purchase orders relate tolpurchases that did not have a requisition $($based

on the Requisition Number column$)?$ What is the total dollar amount of purchases

made without a requisition? $($Summarize$).$ State your audit concerns related to pur$-$

chases without a requisition.

e$.$ Determine and print the percent of total purchases by vendor number. Do any ven$-$

dors account for more than $5\%$ of total purchases? $($Classify and Quick Sort$).$

f$.$ Rockwood requires a sccond 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. $($Filter$)$