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 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 You can perform this analysis using Excel, or audit software such as ACL or IDEA 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 NOTE Significant risk is a defined term 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 18, 2024

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. 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. You can perform this analysis using Excel, or audit software such as ACL or IDEA.

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? [NOTE: Significant risk is a defined term.]
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?