Purchase Solution

Analytical Procedures Casuccio Aurora Manufacturing Inc.

Not what you're looking for?

Ask Custom Question

(Analytical procedures) The following data was taken from the production and account­ing records for Casuccio Manufacturing, Inc.

From the book, Modern Auditing 8th Edition, Part 4: Auditing the Transaction Cycles. Chapter 15: The Expenditure Cycle (Pages 729-730) Q15-23 and Chapter 14: The Revenue Cycle (Page 675) Q14-26.

Operating Data
Capacity in Units



Production in Units 450,000 400,000 300,000
Inventory in Units 32,000 28,000 21,000
Financial Data ($000)
Total Revenues $ 35,200 $27,500 $21,200
Total Assets $23,000 $ 19,500 $15,700
Accounts Receivable, Net $5,900 $4,300 $3,900
Bad Debt Expense $175 $135 $105
Accounts Receivable Written Off $165 $125 $100


1. Calculate the following ratios for 20x9, 20x8 and 20x7:
a. Sales to total assets b. Sales to production
c. Revenue per unit sold
d. Accounts receivable growth to sales growth
e. Uncollectable accounts expense to net credit sales
f. Uncollectable accounts expense to accounts receivable written off g. Accounts receivable turn days
2. a. Describe the implications of the resulting ratios for the auditor's audit strategy for year 20x9.
b. What specific audit objectives are likely to be misstated?
c. How should the auditor respond in terms of potential audit tests?


The following information was taken from the accounting records for Aurora Manufacturting, Inc.:

$ 460,000
$ 390,000
$ 225,000
Current Assets $1,350,000 $1,175,000 $950,000 $750,000 $ 600,000
Accounts Payable $115,000 $113,000 $ 97,500 $ 850,000 $ 70,000
Current Liabilities $ 545,000 $535,000 $ 440,000 $ 380,000 $320,000
Sales $2,700,000 $ 2,050,000 $1,750,000 $ t400,000 $ uoo,ooo
Cost of Goods Sold $1,650,000 $ 1)25,000 $1,025,000 $ 850,000 $ 725,000
Industry Median
Accounts Payable
Turn Days 31 30 29 30
Cost of Goods Sold to
Accounts Payable 10.7 11.2 10.9 11.1
Current Asset to
Current Liabilities 1.9 2.2 2.3 2.1

a. Calculate the following information and ratios for years 2, 3, 4, and 5:
Accounts payable turn days
Cost of goods sold to accounts payable
Current ratio

b. Describe the implications of the resulting ratios for the auditor's audit strategy.
What specific audit objectives are likely to be misstated? How should the
respond in terms of potential audit tests?

Purchase this Solution

Solution Summary

Your tutorial is 807 words plus an excel analysis of the accounts given and ratios requested. Click on separate tabs in excel to get analysis. Calculations are not explained but the computations can be viewed by clicking in the cells and seeing what was done (formulas are there).

Solution Preview

(see attached for excel sheet)

P15-33 Expenditure Cycle

See ratio analysis in excel, attached. Click in cells to see computations.

Implications of analytical review

The implications of the analytical review is that balances are not as expected. This signals higher risk. For instance, the auditor needs to review why sales and purchases are up about 35% from the prior year but AP is not. The days in AP is much higher than the industry and out of line with expectations given sales growth. For instance, look at AP as a percent of purchases. Except for the outlier in Year 2, this had been running just under 9%. Now it is 6.7%.

Also implied in the analytical review is that receivables may need attention. The current ratio is trending up, partially from AP not keeping up with growth, but also from AR not growing with sales. Also, the sharp increase in sales is always a risk signal, especially if the entire industry is not also enjoying such growth.

Audit Objectives

In the expenditure cycle, the risk is that items have been LEFT OFF, rather than included inappropriately. So, there is a risk that not all purchases have been accrued. Therefore, the specific audit objectives that are likely to be misstated are the ?completeness? of payables.
In the revenue cycle, the risk is that ...

Solution provided by:
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution

Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Lean your Process

This quiz will help you understand the basic concepts of Lean.