Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. this problem is based on the ja tires data.. as pa

This problem is based on the JA Tires data.. As part of risk assessment procedures,...

80.2K

Verified Solution

Question

Accounting

This problem is based on the JA Tires data.. 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.

Required:

a. 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.] b. Identify any other transactions that appear to involve unusual product numbers, customers, or prices. c. Customer 1027, New York Tire Depot, is considered a related party to JA Tires. What is the total amount of sales to this customer?

Please show how to solve on excel : show steps :

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Question 4: Homogeneous Second Order Differential equation Solve the following equation for the particular solution. i. 2???...

Basic Math
1.2K views

Grooming Time.   Listed below are times (minutes) spent on hygiene and grooming in the morning (by randomly...

Biology
1.2K views

Drag the correct term to the correct definition. Condensed area of DNA found within prokaryotic...

Biology
1.2K views

It is widely believed today that viruses came from parts of A fungi C degraded...

Basic Math
1.2K views

Suppose there are five firms in an industry. Their sales (that is, total revenue) are...

Basic Math
1.2K views

What is the result when this equation is solved for y?4x + 10x - 2y...

Algebra
1.2K views

Decide which method of data collection you would use to collect data for the study...

Accounting
1.2K views

Question 5 (10 marks) ABC Superannuation Plan controls a number of assets with the following...

Accounting
1.2K views

The following pertains to Paylor (P) and Swift (S): On...

Accounting
1.2K views

CM Manufacturing has provided the following unit costs pertaining to a component they manufacture and...

Finance
1.2K views

Things Get Messi Enterprises is issuing new bonds for a capital budgeting project. The bonds...

Finance
1.2K views

Discuss the relationship between social responsibility and corporate performance.