Audit data analytics (ADA) techniques are helpful when the data are reliable, clean, and come from an information system with strong internal controls. In addition, it is helpful if the population is large and the data are available in electronic form. You are auditing a client in the construction industry and have the data for construction projects for the month of June 2019. You want to know if recorded revenue is complete and actually occurred. You start with ADA and if you see something unexpected, you will use detailed testing. The client records revenue with a markup over costs to result in gross margins between 40% and 60%. The visualization titled Costs, Revenue, Margins by Customer shows recorded amounts by customer in the month of June. You can open the Tableau file in this problem statement with Tableau Desktop software. If you do not have a version of Tableau Desktop, you can open the file with Tableau Reader. Tableau Reader is a free download that allows you to open visualizations built with Tableau Desktop. To find a free download of Tableau Reader on the Tableau website, search for Tableau Reader in your internet browser, or click here. Ch10 Costs and Revenue Part a Do any of the margins for the customers seem like they deserve follow up?

Customer 17272 seems to have an extremely low margin that requires follow up.

Customer 21652 has revenue that appears too high compared to the rest of the customers. It should be investigated.

Customers 17272 and 25866 have low margins that should be investigated.

No. All the margins and costs appear to be fairly similar, as one would expect with margins a bit above and a bit below 50%.