Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Managers would want to ensure that inventory matches what they ( or their company ) ordered, that invoices aren't paid more than once, and that
Managers would want to ensure that inventory matches what they or their company ordered, that invoices aren't paid
more than once, and that the payments are sent to approved parties.
Auditors are interested in testing the internal controls that govern who can create orders, receive items, and approve
payments. In addition to segregation of duties, they may be interested in matching each of the documents ie purchase
order, receiving report, and vendor invoice in a threeway match.
To answer the following questions, use the Tableau workbook and Excel data files found below. The PP data, shown in
Exhibit have joined together the following tables into one file.
Data: PP Data.zip KB Zip KB Excel
Submit your answers for the following Analysis Questions in the text entry field below.
What do you consider "abnormally high"? Are these suspicious?
What statistical tools can the company use to diagnose behavior that is outside of normal behavior?
How might an outlier be used to focus the auditors on highrisk transactions?
Why aren't the other purchases suspicious?
While you still have your auditor hat on what are some additional analyses you could perform to understand whether the purchase process is being followed or controls are functioning properly?
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