Question
PLEASE HELP WITH A) AND B) 3) Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas
PLEASE HELP WITH A) AND B)
3) Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and analytics center has provided you with a set of Tableau visualizations to consider during your substantive testing procedures:
i. 3-way match of SalesOrderID, InvoiceID, and ShipID based solely on SalesOrders database
ii. Sales by territory
iii. Sales by distributor
iv. Sales by quarter v. Sales by territory by quarter
vi. Product sales by Territory
vii. 4th Quarter Sales by Territory
viii. Sales vs. Sales Goals for 4th quarter by Territory
ix. Sales by quarter by Territory vs 4th Q Sales Goals
a. Using the data visualizations provided in Tableau, compose a memo to be included in the audit documentation file that identifies any patterns in the data that you believe may be indicative of specific audit risks. In your memo, be sure to link the identified risks to the appropriate significant account and relevant assertions.
b. Based on the analysis completed above, what further testing, if any, needs to be performed over the identified risks and the remaining population? Stated differently, do any further tests need to be performed or does the 3-way match visualization, combined with your tests of controls and additional visualizations, provide you with sufficient appropriate evidence to conclude about the occurrence of revenue at Urgent?
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