Question
Required information Skip to question Elm Manufacturing Company (ELM) is a small manufacturer of backpacks located in Rochelle, Illinois. You have access to ELM's electronic
Required information Skip to question 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 20234th Quarter" and "Cash Disbursements 20234th Quarter" datasets provided below). Detailed information about ELM, instructions for accessing datasets, and a data directory for data sets can be found below.
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: 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.
Determine the total dollar amount ordered from each vendor. What is the total dollar amount ordered from the largest vendor?
Determine what products are ordered most often. What is the total dollar amount of purchases for the product that was ordered most often?
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?
How many orders were made to vendors not on the approved list?
What was the total number of discounts not taken by ELM?
How many times during the 4th quarter was a vendor paid late?
How many purchases did not pass inspection during the 4th quarter?
Determine which of the given statements represents a way that the previous tests will help an auditor during the course of completing the audit.
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