Elm Manufacturing Company (ELM) is a small manufacturer of backpacks located in Rochelle, Illinois. You have access to ELM's electronic records (via the "Purchases 2017 - 4th Quarter" and "Cash Disbursements 2017 - 4th Quarter" datasets provided below). Detailed information about ELM, instructions for accessing datasets, and a data directory for data sets can be found below. Required Data Files: Chapter 8 ELM Files (click to download a .zip file) Chapter 8 Exercises 8.60 to 8.62 Student Step Guide rev: 01_27_2018_QC_CS-115443 You have identified relevant controls for several assertions within the revenue cycle, and you must use IDEA to perform several tests of controls. Required: Using the information above, complete all of the related steps shown below using IDEA. After completing each step, answer each question by supplying the required information. (Enter your answers exactly as they appear in IDEA.) a. Determine the total dollar amount ordered from each vendor. What is the total dollar amount ordered from the largest vendor? b. Determine what products are ordered most often. What is the total dollar amount of purchases for the product that was ordered most often? c. Determine the accounts payable amount for each vendor as of March 31. What is the vendor number of the supplier with the highest accounts payable balance as of 3/31? d. How many orders were made to vendors not on the approved list? e. What was the total number of discounts not taken by ELM? f. How many times during the 4th quarter was a vendor paid late? g. How many purchases did not pass inspection during the 4th quarter? h. Determine which of the given statements represents a way that the previous tests will help an auditor during the course of completing the audit.

a. Determine the total dollar amount ordered from each vendor. What is the total dollar amount ordered from the largest vendor?

b. Determine what products are ordered most often. What is the total dollar amount of purchases for the product that was ordered most often?

c. Determine the accounts payable amount for each vendor as of March 31. What is the vendor number of the supplier with the highest accounts payable balance as of 3/31?

d. How many orders were made to vendors not on the approved list?

e. What was the total number of discounts not taken by ELM?

f. How many times during the 4th quarter was a vendor paid late?

g. How many purchases did not pass inspection during the 4th quarter?