Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

15-34 ACL Problem (OBIECrive 15-7) This problem requires the use of ACL sof tware, which can be accessed through the textbook website. Information about downloading

image text in transcribed

image text in transcribed

15-34 ACL Problem (OBIECrive 15-7) This problem requires the use of ACL sof tware, 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 f. 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. How many records are included in the Invoices file as noted at the bottom of the screen? b. Using the Invoices file, calculate the sample size and sampling interval for a record sample to be used for tests of transactions. Use a confidence level of 90 percent, upper e:ror limit of 6 percent (tolerable error rate or precision), and expected error rate of zero. (Sampling/Calculate Sample Size; select "Record" radio button.) c. What is the sample size if you increase the confidence level to 95 percent and do not change the other sampling parameters? What is the sample size if you increase the upper error limit to 8 percent, with a confidence level of 90 percent and expected error rate of zero? d. Select the sample based on the sample size determined in part b. (Sampling/Sample; select the "Record" radio button under "Sample type." For "Sample Parameters" select the "Random" radio button and sample size you determined in part b., use a seed of 5.) Save the file using a naming convention such as invoice_sample. e. What is the invoice number of the largest invoice selected for testing? Does your sampling plan consider invoice amount? (Quick Sort) f. Assume you found one error in the sample. Without using ACL, will your results be acceptable? Explain. Now use ACL to calculate the upper error limit frequency. (Sampling/Evaluate Error; input the confidence level, sample size, and one error.) 15-34 ACL Problem (OBIECrive 15-7) This problem requires the use of ACL sof tware, 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 f. 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. How many records are included in the Invoices file as noted at the bottom of the screen? b. Using the Invoices file, calculate the sample size and sampling interval for a record sample to be used for tests of transactions. Use a confidence level of 90 percent, upper e:ror limit of 6 percent (tolerable error rate or precision), and expected error rate of zero. (Sampling/Calculate Sample Size; select "Record" radio button.) c. What is the sample size if you increase the confidence level to 95 percent and do not change the other sampling parameters? What is the sample size if you increase the upper error limit to 8 percent, with a confidence level of 90 percent and expected error rate of zero? d. Select the sample based on the sample size determined in part b. (Sampling/Sample; select the "Record" radio button under "Sample type." For "Sample Parameters" select the "Random" radio button and sample size you determined in part b., use a seed of 5.) Save the file using a naming convention such as invoice_sample. e. What is the invoice number of the largest invoice selected for testing? Does your sampling plan consider invoice amount? (Quick Sort) f. Assume you found one error in the sample. Without using ACL, will your results be acceptable? Explain. Now use ACL to calculate the upper error limit frequency. (Sampling/Evaluate Error; input the confidence level, sample size, and one error.)

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

Quality Auditing Note Book Journal Notes Checklist Questions Observations Evidence Log

Authors: Just Visualize It, The Quality Guy

1st Edition

1726688402, 978-1726688406

More Books

Students also viewed these Accounting questions

Question

=+ (c) Show that $ is countable if and only if L2 is separable.

Answered: 1 week ago