Answered step by step
Verified Expert Solution
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
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
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