Data ACL Problem Analytics (Objective 12-70) 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? (Stratify) 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. (Gaps and Duplicates) Activate Windows d. How many purchase orders relate to purchases 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 purchases without a requisition. e. Determine and print the percent of total purchases by vendor number. Do any vendors account for more than 5 percent of total purchases? (Classify and Quick Sort). 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. (Filter) Activate Window Go to Settings to active Data ACL Problem Analytics (Objective 12-70) 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? (Stratify) 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. (Gaps and Duplicates) Activate Windows d. How many purchase orders relate to purchases 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 purchases without a requisition. e. Determine and print the percent of total purchases by vendor number. Do any vendors account for more than 5 percent of total purchases? (Classify and Quick Sort). 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. (Filter) Activate Window Go to Settings to active
