Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

2nd Edition

0078110823, 9780078110825

More Books

Students also viewed these Accounting questions