Present a sampling spreadsheet for the audit program.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

ACCOUNTING QUESTION On January 1, 2025, XYZ Enterprises had the following transactions: 1. The owner invested $50.000 in cash to start the business. 2. Purchased office equipment for $12.000 on credit. 3. Paid $2,000 for January rent. 4. Provided services to a client and recived $5,000 in cash. 5. Paid $3,000 to settle part of the office equipment liability. 6. Received a utility bill for $600, to be paid in February. a) Record the journal entries for each of the above transactions.

Carla Vista Leasing Company leases a new machine to Sandhill Corporation. The machine has a cost of $65,000 and fair value of $94,500. Under the 3-year, non-cancelable contract, Sandhill will receive title to the machine at the end of the lease. The machine has a 3-year useful life and no residual value. The lease was signed on January 1, 2025. Carla Vista expects to earn an 8% return on its investment, and this implicit rate is known by Sandhill. The annual rentals are payable on each December 31, beginning December 31, 2025. Click here to view factor tables. (b). Prepare an amortization schedule that would be suitable for both the lessor and the lessee and that covers all the years involved. (For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answers to O decimal places e.g. 5,275.) Interest (8%) Revenue/ Rent Receipt/Payment Reduction of Principal Expense Receivable/Liability (c) Prepare the journal entry at commencement of the…

Assume that IBM leased equipment that was carried at a cost of $97,000 to Crane Company. The term of the lease is 5 years beginning December 31, 2024, with equal rental payments of $30,200 beginning December 31, 2024. The fair value of the equipment at commencement of the lease is $128,040. The equipment has a useful life of 5 years with no salvage value. The lease has an implicit interest rate of 9%, no bargain purchase option, and no transfer of title. Collectibility of lease payments for IBM is probable. Prepare IBM's December 31, 2024, journal entries at commencement of the lease. (List all debit entries before credit entries. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. For calculation purposes, use 5 decimal places as displayed in the factor table provided and round final answers to O decimal places e.g. 5,275.) Click here to view…

Answer 2

Question

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Answer 6

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

Answer 7

Chapter 18, Problem 30C

I.

To determine

Present a sampling spreadsheet for the audit program.

Answer 8

I.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	2	2	0	0	5
2	Unusual entries having errors	0	5	m	10	10	1	10	-5
3	Cash disbursement in book not matching with bank	0	5	m	50	50	3	6	-1
7	Checks not mailed under authorization	1	6	m	20	20	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	20	20	1	5	0
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	30	30	4	13	-8
9b 2	Documents not matching cash disbursement journals	0	5	m	30	30	2	7	-2
9b 3	Particulars of suppliers not matching with entries	0	5	m	30	30	2	7	-2
9b 4	discounts are not obtained when appropriate	0	5	m	10	10	1	10	-5
9b 5	Suppliers invoice not internally verified	0	5	m	30	30	2	7	-2
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	30	30	2	7	-2
9b 7	invoices are not approved	0	5	m	10	10	1	10	-5
9b 8	purchase orders/requisitions are not approved	0	5	m	10	10	1	10	-5
9b 9	Prices are not adequately charged	0	5	m	30	30	0	0	5
9b 10	Quantities and description does not tally in documents	0	5	m	30	30	1	3	2
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	30	30	2	7	-2
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	30	30	1	3	2
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	30	30	2	7	-2
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	30	30	3	10	-5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	10	10	1	10	-5

Table (1)

Following procedures are not included in the spreadsheet since sampling is not applicable to these procedures:

Procedure to check whether bank reconciliation is prepared by the controller.
Procedure to check whether balances in accounts payable and master file are periodically reconciled to vendors' statement.
Procedure to check whether controller balances the accounts payable to the general ledger every month.
Procedure to check whether numerical sequence of check is accounted and prepared by separate individuals

Abbreviations used in the spreadsheet are listed as follows:

EPER: Estimated population exception rate. Exceptions that auditor expects to be present before undertaking any procedures.
TER: Tolerable exception rate. Exception up to this rate is assessed as tolerable by the auditor.
ARO: Acceptable risk of overreliance. It is considered as medium (m) for all the procedures. It is the level of risk that auditor assumes for evaluating the controls as effective or for assessing the risk as tolerable, when the exceptions are higher than the tolerable rate.
SER: Sample exception rate. It is the exception demonstrated in percentage form. It is computed by dividing exceptions by the total sample size.
TER-SER: It is the excess of tolerable risk over the exception rate. For example, if tolerable rate is 5% and exceptions found is 3% than it shows that tolerable rate is 2% higher than the actual deviation which is a favorable situation.

Answer 9

I.

Expert Solution

Answer 10

I.

Expert Solution

Answer 11

Expert Solution

Answer 12

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5

Table (2)

Answer 13

II.

a.

To determine

Present a sampling spreadsheet for the audit program.

Answer 14

II.

a.

Expert Solution

Explanation of Solution

Spreadsheet to be used under audit program to check the accounts payables, cash disbursements, and acquisition of inventories:

		Planned audit				Actual Results
Procedure	Description of attributes	EPER	TER	ARO	Initial Sample Size	Sample size	Exceptions	SER	(TER-SER)
1	Totals disbursement & acquisition journals does not match general journal	0	5	m	50	50	0	0	5
2	Unusual entries having errors	0	5	m	50	50	2	4	1
3	Cash disbursement in book not matching with bank	0	5	m	50	50	0	0	5
7	Checks not mailed under authorization	1	6	m	50	50	0	0	6
9a	cancelled checks not matching with entries and signatures	0	5	m	50	50	0	0	5
	In relation with supplier invoice, purchase order and receiving reports
9b 1	supporting documents not attached to supplier invoice	0	5	m	50	50	2	4	1
9b 2	Documents not matching cash disbursement journals	0	5	m	50	50	0	0	5
9b 3	Particulars of suppliers not matching with entries	0	5	m	50	50	0	0	5
9b 4	discounts are not obtained when appropriate	0	5	m	50	50	0	0	5
9b 5	Suppliers invoice not internally verified	0	5	m	50	50	4	8	-3
9b 6	Cash disbursements is not reasonable to account codes	0	5	m	50	50	0	0	5
9b 7	invoices are not approved	0	5	m	50	50	0	0	5
9b 8	purchase orders/requisitions are not approved	0	5	m	50	50	0	0	5
9b 9	Prices are not adequately charged	0	5	m	50	50	1	2	3
9b 10	Quantities and description does not tally in documents	0	5	m	50	50	0	0	5
9b 11	Invoices are not marked paid and check numbers are not included while signing checks	0	5	m	50	50	0	0	5
9c	Entries in cash disbursement journals are not matching with the accounts payable master file	0	5	m	50	50	0	0	5
	In relation to receiving report, suppliers invoice, and acquisition journal
10a	Supplier's name, receipt date, quantity, price, and type are not matching	0	5	m	50	50	0	0	5
10b	Check number for paid transactions in acquisition journal does not tally with the cash disbursement journals	0	5	m	50	50	0	0	5
10b	Reasons for not making the payment to the unpaid accounts are not valid	0	5	m	50	50	0	0	5