Required information

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 $2023-4$th Quarter" and "Cash Disbursements $2023-4$th 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($click to download a $.$zip file$)$

Student Setup Guide for Ex$.8-64-8\mathrm{.}66$

Note: There are differences in years in the guide, but the solutioning is the same.

Rights managed content: IDEA $($text$)$

You have been assigned the task of understanding the client's purchasing habits, including their use of authorized vendors and

payment time frames, and you must use IDEA to gather this information.

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.

Note: 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 $\frac{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 $4$ th quarter was a vendor paid late?

g$.$ How many purchases did not pass inspection during the $4$ th 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.