Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I7-33 ACL PROBLEM (OBJECTIVE 17-3) This problem requires the use of ACL software, which can be accessed through the textbook website. Information about downloading and

image text in transcribed

I7-33 ACL PROBLEM (OBJECTIVE 17-3) This problem requires the use of ACL software, which can be accessed through the textbook website. Information about downloading and using ACL and the commands used in this problem can also be found on the textbook website. You should read all of the reference material, especially the material on sampling, to answer questions a. through e. 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. a. 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 20 percent, materiality of $50,000, and expected errors of $2,500. (Sampling/Calculate Sample Size; select "monetary" radio button.) b. What is the sampling size and sampling interval if you increase materiality to $60,000 and decrease expected errors to $1,000 ? c. Select the sample based on the sampling interval determined in part a. (Sampling/ Sample; select "Sample typ" as MUS. For "Sample Parameters" select fixed interval and enter the interval from part a.; use a random start of 3179 .) d. How many items were selected for testing? Why is the number selected for testing less than the sample size determined in part a.? e. What is the largest item selected for testing? How many sample items are larger than the sampling interval? How many items are larger than the sampling interval in the population? I7-33 ACL PROBLEM (OBJECTIVE 17-3) This problem requires the use of ACL software, which can be accessed through the textbook website. Information about downloading and using ACL and the commands used in this problem can also be found on the textbook website. You should read all of the reference material, especially the material on sampling, to answer questions a. through e. 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. a. 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 20 percent, materiality of $50,000, and expected errors of $2,500. (Sampling/Calculate Sample Size; select "monetary" radio button.) b. What is the sampling size and sampling interval if you increase materiality to $60,000 and decrease expected errors to $1,000 ? c. Select the sample based on the sampling interval determined in part a. (Sampling/ Sample; select "Sample typ" as MUS. For "Sample Parameters" select fixed interval and enter the interval from part a.; use a random start of 3179 .) d. How many items were selected for testing? Why is the number selected for testing less than the sample size determined in part a.? e. What is the largest item selected for testing? How many sample items are larger than the sampling interval? How many items are larger than the sampling interval in the population

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

Electronic Health Records An Audit And Internal Control Guide

Authors: Rebecca S. Busch

1st Edition

0470258209, 978-0470258200

More Books

Students also viewed these Accounting questions

Question

3. Identify the methods used within each of the three approaches.

Answered: 1 week ago