Problem DC 10-2, Page 547 The following are auditor judgments

Problem DC 10-2, Page 547 The following are auditor judgments and audit sampling results for six populations. Assume large population sizes. 1 2 3 4 5 6 TER (in percentage) 6 3 8 5 20 15 ARACR (in percentage) 5 5 10 5 10 10 100 100 60 100 20 60 2 0 1 4 1 8 Actual sample size Actual number of exceptions in the sample REQUIRED a.For each population, did the auditor select a smaller sample size than is indicated by using attribute sampling tables for determining sample size? (Assume K 0 in sample size planning). Evaluate, selecting either a larger or smaller size than those determined in the tables. b.Calculate Sample Deviation Rate (SDR) and Upper Error Limit (UEL) for each population. c.For which of the six populations should the sample results be considered unacceptable? What options are available to the auditor? d.Why is analysis of the exceptions necessary even when the populations are considered acceptable? e.For the following terms, identify which is an audit decision, which is a non-statistical estimate made by the auditor, which is a sample result, and which is a statistical conclusion about the population. a. Estimated population deviation rate. b. Tolerable deviation rate. c. Acceptable risk of overreliance on internal control. d. Actual sample size. e. Actual number of deviations in the sample. f. Sample deviation rate. g. Achieved P or UEL What is K? The confidence factor. Revenue Cycle 1

Same Table 11-8, Page 355 – for calculating K Confidence Factors for MUS Sample Size Design (ARIA in brackets) Number of Errors 99% (1%) 97.5% (2.5%) 95% (5%) 90% (10%) 85% (15%) 80% (20%) 75% (25%) 0 4.51 3.69 3.00 2.31 1.90 1.61 1.39 1 6.64 5.58 4.75 3.89 3.38 3.00 2.70 2 8.41 7.23 6.30 5.33 4.73 4.28 3.93 3 10.05 8.77 7.76 6.69 6.02 5.52 5.11 4 11.61 10.25 9.16 8.00 7.27 6.73 6.28 5 13.11 11.67 10.52 9.28 8.50 7.91 7.43 6 14.58 13.06 11.85 10.54 9.71 9.08 8.56 7 16.00 14.43 13.15 11.78 10.90 10.24 9.69 8 17.41 15.77 14.44 13.00 12.08 11.38 10.81 9 18.79 17.09 15.71 14.21 13.25 12.52 11.92 10 20.15 18.40 16.97 15.41 14.42 13.66 13.03 In this example K will either be 3.00, or 2.31, depending on the value of ARIA Revenue Cycle 2

ACTUAL NUMBER OF DEVIATIONS FOUND Sample size 0 1 2 3 4 5 6 7 8 9 10 5 PERCENT RISK OF OVER RELIANCE (RIA or Beta Risk) 20 25 14.0 11.3 21.7 17.7 28.3 23.2 34.4 28.2 40.2 33.0 45.6 37.6 50.8 42.0 55.9 46.3 60.7 50.4 65.4 54.4 69.9 58.4 30 35 40 45 50 55 60 65 70 75 80 90 100 125 150 200 300 400 500 9.6 8.3 7.3 6.5 5.9 5.4 4.9 4.6 4.2 4.0 3.7 3.3 3.0 2.4 2.0 1.5 1.0 0.8 0.6 14.9 12.9 11.4 10.2 9.2 8.4 7.7 7.1 6.6 6.2 5.8 5.2 4.7 3.8 3.2 2.4 1.6 1.2 1.0 19.6 17.0 15.0 13.4 12.1 11.1 10.2 9.4 8.8 8.2 7.7 6.9 6.2 5.0 4.2 3.2 2.1 1.6 1.3 23.9 20.7 18.3 16.4 14.8 13.5 12.5 11.5 10.8 10.1 9.5 8.4 7.6 6.1 5.1 3.9 2.6 2.0 1.6 28.0 24.3 21.5 19.2 17.4 15.9 14.7 13.6 12.7 11.8 11.1 9.9 9.0 7.2 6.0 4.6 3.1 2.3 1.9 31.9 27.8 24.6 22.0 19.9 18.2 16.8 15.5 14.5 13.6 12.7 11.4 10.3 8.3 6.9 5.2 3.5 2.7 2.1 35.8 31.1 27.5 24.7 22.4 20.5 18.8 17.5 16.3 15.2 14.3 12.8 11.5 9.3 7.8 5.9 4.0 3.0 2.4 39.4 34.4 30.4 27.3 24.7 22.6 20.8 19.3 18.0 16.9 15.9 14.2 12.8 10.3 8.6 6.5 4.4 3.3 2.7 43.0 37.5 33.3 29.8 27.1 24.8 22.8 21.2 19.7 18.5 17.4 15.5 14.0 11.3 9.5 7.2 4.8 3.6 2.9 46.6 40.6 36.0 32.4 29.4 26.9 24.8 23.0 21.4 20.1 18.9 16.9 15.2 12.3 10.3 7.8 5.2 3.9 3.2 50.0 43.7 38.8 34.8 31.6 28.9 26.7 24.7 23.1 21.6 20.3 18.2 16.4 13.2 11.1 8.4 5.6 4.3 3.4 Revenue Cycle 3

ACTUAL NUMBER OF DEVIATIONS FOUND Sample size 0 1 2 3 4 5 6 7 8 9 10 10 % Risk of Incorrect Acceptance (RIA or Beta Risk) 20 10.9 18.1 24.5 30.5 36.1 41.5 46.8 51.9 56.8 61.6 66.2 25 30 35 40 45 50 55 60 65 70 75 80 90 100 125 150 200 300 400 500 8.8 7.4 6.4 5.6 5.0 4.6 4.2 3.8 3.5 3.3 3.1 2.9 2.6 2.3 1.9 1.6 1.2 0.8 0.6 0.5 14.7 12.4 10.7 9.4 8.4 7.6 6.9 6.4 5.9 5.5 5.1 4.8 4.3 3.9 3.1 2.6 2.0 1.3 1.0 0.8 20.0 16.8 14.5 12.8 11.4 10.3 9.4 8.7 8.0 7.5 7.0 6.6 5.9 5.3 4.3 3.6 2.7 1.8 1.4 1.1 24.9 21.0 18.2 16.0 14.3 12.9 11.8 10.8 10.0 9.3 8.7 8.2 7.3 6.6 5.3 4.4 3.4 2.3 1.7 1.4 29.5 24.9 21.6 19.0 17.0 15.4 14.1 12.9 12.0 11.1 10.4 9.8 8.7 7.9 6.3 5.3 4.0 2.7 2.0 1.6 34.0 28.8 24.9 22.0 19.7 17.8 16.3 15.0 13.9 12.9 12.1 11.3 10.1 9.1 7.3 6.1 4.6 3.1 2.4 1.9 38.4 32.5 28.2 24.9 22.3 20.2 18.4 16.9 15.7 14.6 13.7 12.8 11.5 10.3 8.3 7.0 5.3 3.5 2.7 2.1 42.6 36.2 31.4 27.7 24.8 22.5 20.5 18.9 17.5 16.3 15.2 14.3 12.8 11.5 9.3 7.8 5.9 3.9 3.0 2.4 46.8 39.7 34.5 30.5 27.3 24.7 22.6 20.8 19.3 18.0 16.8 15.8 14.1 12.7 10.2 8.6 6.5 4.3 3.3 2.6 50.8 43.2 37.6 33.2 29.8 27.0 24.6 22.7 21.0 19.6 18.3 17.2 15.4 13.9 11.2 9.4 7.1 4.7 3.6 2.9 54.8 46.7 40.6 35.9 32.2 29.2 26.7 24.6 22.8 21.2 19.8 18.7 16.7 15.0 12.1 10.1 7.6 5.1 3.9 3.1 Revenue Cycle 4

Solution to DC 10-2 a) Note: K the number of expected errors, and P TER. See table on the next page. Case 1: K 3, and P 6%. Thus n 3/0.06 50 Case 2: K 3, and P 3%. Thus n 3/0,03 100 Case 3: K 2.31, and P 8%. Thus n 2.31/0.08 29 Case 4: K 3, and P 5%. Thus n 3/0.05 60 Case 5: K 2.31, and P 20%. Thus n 2.31/.2 12 Case 6: K 2.31,and P 15%. Thus n 2.31/.15 16 Anything larger than these discovery sample sizes reduces efficiency risk, while effectiveness risk (1 – confidence level) remains constant. i.e. the auditor is doing to much work. Not being efficient. Anything smaller than a discovery sample size means that the auditor has more effectiveness risk than planned. i.e. the auditor is not being effective. Revenue Cycle 5

b) Using the tables from the following two pages: Case 1: Actual sample size 100, number of deviations 2, and ARACR 5%. SDR 2/100 2%, From the table - UEL 0.062 Case 2: Actual sample size 100, number of deviations 0, and ARACR 5%. SDR 0, UEL 0.030 Case 3: Actual sample size 60, number of deviations 1, and ARACR 10%. SDR 1/60 1.7%, UEL 0.064 Case 4: Actual sample size 100, number of deviations 4, and ARACR 5%. SDR 4/100 4%, UEL 0.090 Case 5: Actual sample size 20, number of deviations 1, and ARACR 10%. SDR 1/20 5%, UEL 0.181 Case 6: Actual sample size 60, number of deviations 8, and ARACR 10%. SDR 8/60 13.3%, UEL 0.208 Revenue Cycle 6

c) The population results are unacceptable for cases 1, 4, and 6. . In each of those cases, the UEL exceeds TER. The auditor’s options are to; i.change tolerable exception rate or ARACR ii.increase the sample size iii. or perform other substantive tests to determine whether there are actually material errors in the population d) Sources of error helps auditor asses whether error is intentional or unintentional, and to assess qualitative aspects of internal control (for example, whether a particular individual, department, or time period is affected). e) 2. 3. 4. 5. 6. 7. 1. auditor estimate auditor decision auditor decision auditor decision, or by formula sample result sample result sample result: achieved P or UEL is the maximum error rate at the stated confidence level. Revenue Cycle 7

Problem DC 11-4, Page 612 Control Weakness: Shipping and Billing: Ajax Inc. recently implemented a new accounting system to process the shipping, billing, and accounts receivable records more efficiently. During the interim work of Ajax’s auditors an assistant completed the review of the accounting system and the internal controls. The assistant determined the following information concerning the computer systems and the processing and control of shipping notices and customer invoices. The computer system documentation consists of the following items: program listings, error listings, logs, and database dictionaries. The system and documentation are maintained by the IT administrator. To increase efficiency, batch totals, and processing controls are not used in the system. Ajax ships its product directly from two warehouses, which forward shipping invoices to general accounting. There, the billing clerk enters the price of the item and accounts for the numerical sequence of the shipping notices. The billing clerk also manually prepares daily adding machines tapes of the units shipped and the sales amounts. The computer processing output consists of the following: a)A three-copy invoice that is forwarded to the billing clerk b)A daily sales register showing the aggregate total of units shipped and sales amounts that the billing clerk compares with the adding machine tapes The billing clerk mails two copies of each invoice to the customer and retains the third copy in an open invoice file that serves as detailed accounts receivable record. Required: a.Prepare a list of weaknesses in internal control (manual and computer), and for ,each weakness make one or more recommendations. b.Suggest how Ajax’s computer processing over shipping and billing could be improved through the use of remote terminals to enter shipping notices. Describe appropriate controls for such an online data entry system. Revenue Cycle 8

a) Weaknesses Recommendations Lack of segregation of duties The billing clerk both enters sales data and checks the output. There is a risk that errors will not be detected when a person is checking his or her own work. There is an opportunity for shipper and billing clerk to cover up unauthorized shipments since no one but the billing clerk checks that valid invoices are issued for every shipment. Deficient documentation Need documentation of flowcharts, program changes, systems software, testing. Lack of control totals Error-checking validations need control totals for effective operation. No computer price list For manual entry process, clerk should not need to enter the sales price. It should be in a database. Numerical sequence The computer should be used to check numerical sequence. Control total The billing clerk’s control total of sales should be used to compare to total sales processed by the computer. Customer accounts The computer system should be used to maintain customer accounts instead of using a manual open invoice file. Revenue Cycle 9

b) Shipping clerks could enter the date, customer identification, shipment quantities, and product identification numbers in a terminal. Then the computer system could automatically produce a sales invoice. Controls include: 1. 2. 3. 4. 5. 6. 7. Autoclock date checking Self-checking customer identification numbers Self-checking product identification numbers Terminal batch hash total of customer ID numbers Automatic numbering of sales invoices Authorized price list in database Control total comparison of hash ID numbers in run-to-run totals Revenue Cycle 10