Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ACL problem 12-35 ACL Problem (OBJECTIve 12-7) This problem requires the use of ACL software, which can be accessed through the textbook website. Information about
ACL problem
12-35 ACL Problem (OBJECTIve 12-7) 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) 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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started