Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assume that you are auditing Roberts Wholesale Supply Co. and that you have decided to use data analytics to test the inventory. Specifically, you would
Assume that you are auditing Roberts Wholesale Supply Co. and that you have decided to use data analytics to test the inventory. Specifically, you would like to identify (1) excess and overvalued items in inventory (e.g., possibly obsolete, quantities well over needed) and (2) unusual transactions. From your discussions with management and your review of overall balances, you have determined that the company strives to maintain inventory levels at no more than 60 days sales. Management also requires a minimum of 15% gross margin on all products. To perform your tests, assume you have the following four accounting data files. 1. Inventory Master File at Year-End Item part no. Item description Quantity on hand Quantity on order Preferred vendor no. Preferred vendor name Average item cost 2. Purchases File for the Year Date received Item part no. Item description Number of items Cost per item Total cost Vendor no. 4. Related Parties Name Relationship with company 3. Sales File for the Year Date shipped Customer no. Customer name Sales order Shipping order Item part no. Item description Quantity sold Sales price Shipping cost Required: a. Describe how you can join (or relate) the files 13 so as to allow you to design tests of inventory using the data in all three of them. b. Describe two different data analytic tests that might be used to identify 1. Excess quantities of inventory items. 2. Unusual transactions Assume that you are auditing Roberts Wholesale Supply Co. and that you have decided to use data analytics to test the inventory. Specifically, you would like to identify (1) excess and overvalued items in inventory (e.g., possibly obsolete, quantities well over needed) and (2) unusual transactions. From your discussions with management and your review of overall balances, you have determined that the company strives to maintain inventory levels at no more than 60 days sales. Management also requires a minimum of 15% gross margin on all products. To perform your tests, assume you have the following four accounting data files. 1. Inventory Master File at Year-End Item part no. Item description Quantity on hand Quantity on order Preferred vendor no. Preferred vendor name Average item cost 2. Purchases File for the Year Date received Item part no. Item description Number of items Cost per item Total cost Vendor no. 4. Related Parties Name Relationship with company 3. Sales File for the Year Date shipped Customer no. Customer name Sales order Shipping order Item part no. Item description Quantity sold Sales price Shipping cost Required: a. Describe how you can join (or relate) the files 13 so as to allow you to design tests of inventory using the data in all three of them. b. Describe two different data analytic tests that might be used to identify 1. Excess quantities of inventory items. 2. Unusual transactions
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