Summarizing Purchasing Data with IDEA. You have been assigned the task of understanding the clients purchasing habits, including their use of authorized vendors and payment time frames, and you must use IDEA to gather this information.

Required:

1. Determine the total dollar amount ordered from each vendor. What companies are the three largest vendors by dollar amount? How would this information assist an auditor in planning the audit?

2. Determine what products are ordered most often. What item is ordered most often? How might this information affect the audit?

   page 376

3. Determine the accounts payable amount for each vendor as of March 31. What companies have the three largest accounts payable balances? How would this information assist an auditor in planning the audit?

4. Were any orders made to vendors not on the approved vendor list? How would this information assist an auditor in planning the audit?

5. Were there any discounts available that were not taken? Why is this important?

6. Were there any vendors paid late? Why is this important?

7. Were there any items that did not pass inspection? Why is this information important to the auditor?