Bronys Bike (Ch. 8 Sampling)

Module III: Control Testing Sales Processing

In this module you will apply attribute sampling to Bronys Bikes pre-numbered sales invoices to evaluate whether sales have been processed properly. Recall from Module II that several deficiencies in the design of the controls suggest an increased likelihood of material misstatement. However, the audit team believes that the use of pre-numbered sales invoices and the related requirements (agree invoice to bill of lading and customer invoice, agree prices on invoice to master price list, agree calculations on invoice, and agree that customer balance is within authorized credit limit) is an effectively designed control activity and the audit team would like to rely on that control. Accordingly, the audit team has decided to test sales transactions to see whether this control activity is operating effectively. If the control is operating effectively, the audit team would be able to reduce the assessed level of control risk for the relevant assertions related to sales and accounts receivable, thereby enabling them to decrease the extent of accounts receivable confirmation and other substantive procedures related to the revenue cycle.

Specifically, you want to determine whether the control related to sales invoices is performed effectively. Knowing whether the control is operating effectively will help the audit team determine whether all recorded sales were shipped (occurrence assertion for sales) and whether all shipments were invoiced and recorded at appropriate amounts (completeness assertion for sales). As discussed previously in the case, invoices are mailed to customers prior to shipment; therefore, customers may have received invoices for goods not yet or never shipped. Also, in the absence of pre-numbered bills of lading, goods may have been shipped but never billed to the customer. The second possible processing problem is that customers may have exceeded existing credit limits without home office knowledge; you need to test the degree to which this has occurred. Finally, because of lack of input editing, the prices, customer number, and/or product number may be incorrect; you will test for this as well.

Derick has asked you to complete the sampling plan worksheet that he began earlier. This worksheet (WP C) file is labeled 20X9_atrib.xlsx (Link). He has defined the sampling unit as the pre-numbered sales invoice, and the relevant attributes as:

1. Bill of lading attached and signed by the carrier;

2. Product prices in agreement with master price list stored in computer;

3. Extensions and footings correct;

4. Quantities and product type in agreement with customer order; and

5. Customer balance within the authorized credit limit.

You are NOT required to perform the sample selection process. In this Module the sample has already been selected and has already been audited. The following information lets you know what would have been done as part of the sample selection process. The population for attribute sampling purposes is the numeric file of sales invoices. During 20X9, 22,400 sales invoices were processed, with document numbers ranging from 10610 to 33009 inclusive. For each sales invoice number drawn at random and included in the sample, you would request the client to supply the invoice/bill of lading packet and the corresponding customer order. Thesales invoice/bill of lading packet could be obtained from the numeric file maintained in CBIS. The customer order, the number of which appears on the face of the invoice, is stored in the computer and could be printed out on demand. You then would examine the documents for the above attributes.

Requirements

1. Based on the deficiencies in the design of controls identified in the sales processing subset of the revenue cycle as explained in the first two paragraphs of this module, does the sampling plan and testing described in the previous paragraph address all relevant financial statement assertions related to sales and accounts receivable? If not, which assertion(s) are not considered in the initial plan, and how could the plan be adjusted to address these assertions?

2. Retrieve the file titled 20X9_attrib. (Link) Using the sample size and sample evaluation tables from Exhibits 8-5 (Link) and 8-6 (Link) in the textbook Chapter 8 and the following data, complete the attribute sampling plan worksheet (in using the Sample Results Evaluation table, select the sample size that is closest to your sample size):

The auditor sets the risk of overreliance at 5% (implying that the auditor is willing to accept a 5% chance that inferences from the sample will be incorrect). A 5% risk of overreliance (sampling risk) is reflected in the 20X9_attrib file.

Misstatements have been defined, and expected deviation rates set for each attribute as follows:

Bill of lading not attached to packet: 1%

Incorrect prices: 1%

Extension and/or footing errors: 0.5%

Quantities and/or product type not in agreement with customer order: 1%

Customer balance exceeds authorized credit limit: 1.5%

Tolerable deviation rates (sometimes referred to as the tolerable failure rate) of 4% have been set for all attributes; and

Assume that the sample has already been selected and audited and the following misstatements were found in examining the sample:

Sales Order Number Misstatement

12511 Bill of lading not signed by carrier

15439 Invoice causing customer to exceed authorized credit limit

18616 Bill of lading missing

23468 Bill of lading missing

27891 Bill of lading missing

3. What conclusions can you draw based on your completed sampling plan worksheet? What impact might your findings have on the substantive audit programs for Bronys Bikes? Based on the results of your testing, should the aggregate materiality threshold be changed for any part of the revenue cycle?