You have just been assigned to the audit of Ferguson Manufacturing. You have been asked to help
Question:
You have just been assigned to the audit of Ferguson Manufacturing. You have been asked to help a new CPA who is performing audit data analytics using the client’s payroll file. The only analytic that has been performed thus far is calculating the reasonability of deductions as a percentage of gross wages for the 12 months of the year. The results were summarized in the following scatter chart:
A scatterplot is displayed. The vertical axis ranges from 0.0% to 60.0%, in increments of 10.0%. A keynote representing the data points at the top right reads, Deductions as a % of gross wages. Horizontal and vertical lines are plotted at every value. A majority of the data points are clustered along the horizontal line that extends from a value of 30.0% on the vertical axis.
Required
Provide an interpretation of the visualization. Include any notable items you identified in your interpretation, along with potential causes, and the steps you would take next.
Access the full dataset associated with the payroll records for the year 2020 in WileyPLUS. Complete the additional substantive tests on the data:
Reasonability of wage rate by job title
Accuracy of the gross wage and net pay calculations
Create a working paper for the audit file that includes the following:
Documented steps you performed
Your initial conclusions
Areas requiring further investigation
What did you document to meet documentation requirements?
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley