For this problem, use the Invoices file in the Sales and Collection subfolder under tables in the
Question:
For this problem, use the “Invoices” file in the “Sales and Collection” subfolder under tables in the ACL_Rockwood project. This file contains information on sales invoices generated during calendar year 2014, including those that have been paid versus those still outstanding. Suggested commands, where applicable, are indicated at the end of the problem requirements.
Using the Invoices file, filter the file to retain only those invoices that are still outstanding and save this filter as “Accounts_Receivable.” (Filter) Determine the total dollar amount of the outstanding invoices (Total). Using the “Accounts_Receivable” data, calculate the sample size and sampling interval for an MUS sample based on total Invoice Amount. Use a confidence level of 90%, materiality of $50,000, and expected errors of $2,500. Insert a screen shot of the output. (Sampling/Calculate Sample Size; select “monetary” radio button)
What is the sampling size and sampling interval if you increase materiality to $60,000 and decrease expected errors to $1,000?
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley