Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This problem is based on the JA Tires data that was first introduced in problem 6-35. If you have not already accessed the data, it

This problem is based on the JA Tires data that was first introduced in problem 6-35. If you have not already accessed the data, it can be downloaded from the textbook website or from the attached Excel filePreview the document. As part of risk assessment procedures, you have been asked to perform some preliminary data analytics on the sales file to assess whether individual transactions or classes of sales transactions represent increased inherent risk because they are large, unusual, or involve related parties. Please import the Excel file into IDEA, then complete items 1-3 below. Required Identify the five largest sales transactions. Indicate whether you believe these transactions should require an increase in inherent risk. Do you believe any of these transactions individually, or in the aggregate, should be considered a significant risk? Identify any other transactions that appear to involve unusual product numbers, customers, or prices. Customer 1027, New York Tire Depot, is considered a related party to JA Tires. What is the total amount of sales to this customer? Submittal instructions: Upload a Microsoft Word document. Include a table showing the 5 largest sales transactions; you may export the table from IDEA as an Excel file, then copy as a table into Word. Do not copy as an embedded object or link. Respond to the remaining questions in the same Word document. We will work a portion of this assignment in class.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

1 Import the Excel file into IDEA Open IDEA Go to File Import Microsoft Excel Select the provided Excel file and import it 2 Identify the five largest ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Cost Management

Authors: Don R. Hansen, Maryanne M. Mowen

2nd edition

1111824401, 978-1111824402

More Books

Students also viewed these Accounting questions

Question

What is SQL?

Answered: 1 week ago

Question

How does a collection differ from an array?

Answered: 1 week ago

Question

What is an API?

Answered: 1 week ago