[go: up one dir, main page]

100% found this document useful (4 votes)
4K views5 pages

Statistical Attributes Sampling Data Sheet: Sales: Oceanview Marine Company

The document summarizes the results of statistical attribute sampling tests performed on Oceanview Marine Company's sales transactions for the year ended December 31, 2018. The tests found low exception rates for most attributes tested, except for proper approval of customer credit which had a higher exception rate of 10.3%. Overall, the results support reducing the scope of the year-end substantive tests of balances but also identified the need to reexamine accounts receivable write-offs and collections to evaluate credit quality. Management was also recommended to emphasize the importance of credit approval and implement verification of proper transaction classifications.

Uploaded by

Faaiz Yousaf
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
100% found this document useful (4 votes)
4K views5 pages

Statistical Attributes Sampling Data Sheet: Sales: Oceanview Marine Company

The document summarizes the results of statistical attribute sampling tests performed on Oceanview Marine Company's sales transactions for the year ended December 31, 2018. The tests found low exception rates for most attributes tested, except for proper approval of customer credit which had a higher exception rate of 10.3%. Overall, the results support reducing the scope of the year-end substantive tests of balances but also identified the need to reexamine accounts receivable write-offs and collections to evaluate credit quality. Management was also recommended to emphasize the importance of credit approval and implement verification of proper transaction classifications.

Uploaded by

Faaiz Yousaf
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Oceanview Marine Company 12-6

Statistical Attributes Sampling Data Sheet: 19/03/2021


Sales
December 31, 2018

Define the objective: Evaluation of internal controls and the accounting system for sales.

Define the population precisely: Sales transactions that occurred between Jan. 1, 2018 and Dec. 31, 2018, inclusive.

Define the sampling unit, organization of population items, and random selection procedures:
Sales transactions as identified by sales invoice number, recorded sequentially in the sales journal. Computer-generated random sample.
Computer-generated random sample.

Planning Actual Results


Sample Sample Number of
EPER TER ARO CUER
Description of Attributes Size Size Exceptions

1. Proper approval of customer credit


1.50 8 10 48 50 2 10.3%
information. (E)

2. Goods have been shipped to


0.00 5 10 45 50 0 4.6%
customer. (E)

3. Amount recorded in journal agrees


0.00 7 10 32 50 0 4.6%
with invoice total. (A)

4. Footings and extensions on the sales


0.50 8 10 48 50 0 4.6%
invoice are correct. (A)

5. Price(s) per unit on invoice agree


1.00 8 10 48 50 0 4.6%
with approved price list. (A)
6. Quantity(ies) on sales invoice agree
with quantity(ies) on bill of lading and 1.50 8 10 48 50 0 4.6%
customer order. (A)
7. Proper accounts were debited and
2.00 8 10 48 50 1 7.6%
credited. (Cl)

8. Sales transaction recorded promptly


1.50 9 10 42 50 1 7.6%
after shipment. (T)

Audit Objective for Tests of Controls and Substantive Tests of Transactions:


Accuracy Existence Classification Posting & summarization Completeness Timing
Oceanview Marine Company 14-4
Audit Program (performance format) 19/03/2021
Tests of Controsl and Substantive Tests of Transactions:
Acquisitions (continued)
December 31, 2018

1. CONCLUSIONS
The preliminary assessment of control risk indicates the classification objective was high.
Consequently, controls over classification were not tested. On the basis of unfavorable
results of tests of attribute #1, it predicts that approval of customer credit and control risk
for the Existence or occurrence objective is increased to medium. (This will also affect the
Realizable Value objective for year-end tests of balances.) It can be concluded that results of
substantive tests of transactions were favorable and support reduction of year-end
substantive tests of balances.

2. EFFECT OF RESULTS ON AUDIT PLAN


Excluding as noted above, controls over sales and accounts receivable appear to be operating
as documented and may be relied on.

Acoount receivalbe write-offs and collections subsequent to year-end should be reexamined


to evaluate whether a decline in credit quality requires an increase in the allowance for bad
debts account.

2. RECOMMENDATIONS TO MANAGEMENT
It is recommand that client is importance of credit approval.
It also recommend that client implement an internal verification policy to check for proper
debit/credit classification for sales transactions
Oceanview Marine Company 14-7
Nonstatistical Attributes Sampling Data Sheet: 19/03/2021
Acquisitions
December 31, 2018

Define the objective: Evaluation of internal controls and the accounting system for acquisitions.

Define the population precisely: Purchase transactions that occurred between Jan. 1, 2018 and Dec. 31, 2018, inclusive.

Define the sampling unit, organization of population items, and random selection procedures:
Purchase transactions as identified by voucher numbers recorded sequentially in voucher register.
Computer-generated random sample.

Planning Actual Results


Initial Sample Estimated
Sample Number of
EPER TER ARO sample Exception Sampling CUER
Size Exceptions
Description of Attributes Size Rate Risk
1. Document package includes all
documents appropriate for the 1% 7% 10% 55 77 1 1.3% 4.0% 5.3%
transaction. (E)
2. Proper approval of purchase order.
2% 8% 10% 48 70 4 5.7% 4.0% 9.7%
(E)

3. Goods have been received. (E) 1% 7% 10% 55 70 0 0.0% 4.0% 4.0%

4. Amount in voucher register agrees


1% 7% 10% 55 70 1 1.4% 4.0% 5.4%
with amount on vendor’s invoice. (A)

5. Quantities on vendor’s invoice agree


with related receiving report and P.O.,
1% 8% 10% 55 70 1 1.4% 4.0% 5.4%
and invoice is mathematically correct.
(A)

6. All documents in voucher package


1% 8% 10% 48 70 3 4.3% 4.0% 8.3%
have been stamped “paid”. (E)

7. Proper accounts were debited and


1% 8% 10% 48 70 1 1.4% 4.0% 5.4%
credited. (Cl)

8. Acquisitions recorded promptly after


2% 8% 10% 65 70 0 0.0% 4.0% 4.0%
receipt of goods. (T)

Audit Objective for Tests of Controls and Substantive Tests of Transactions:


Accuracy Existence Classification Posting & summarization Completeness Timing
Oceanview Marine Company 14-8
Attributes Sampling Exception Form: 19/03/2021
Acquisitions
December 31, 2018

This form is to be used to document the findings of tests of controls and substantive tests of transactions. In the
column on the left, write the document number for each document tested. The numbers across the top of the matrix
correspond to the “Description of Attributes” column on the Attributes Sampling Data Sheet.

For each document in column one, place an “X” in the column below the number of the attribute being tested by that
document if there is an exception. Also use an “X” if one or more documents required to perform the test are missing
(assuming the missing document(s) are applicable to the transaction). Leave it blank if there is no exception.

RECORD OF EXCEPTIONS

Identity of Item Selected Attributes

Document number 1 2 3 4 5 6 7 8

Voucher 677 X

1010 X X X

1409 X X

2280 X X

3028 X X

50 additional items 0 0 0 0 0 0 0 0

Total number of exceptions 1 3 0 1 1 3 1 0

Total sample size


2021

You might also like