Question

In: Accounting

AP11.2 (LO 2)  Analytical procedures The following data was taken from the production and accounting records for...

AP11.2 (LO 2)  Analytical procedures The following data was taken from the production and accounting records for Casuccio Manufacturing, Inc.

Unaudited
2023
Audited
2022
Audited
2021
Operating Data
Capacity in units

450,000

450,000

450,000

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

Required

  1. Calculate the following ratios for 2023, 2022, and 2021:

  1. Sales to total assets.

  2. Sales to production.

  3. Revenue per unit sold.

  4. Accounts receivable growth to sales growth.

  5. Uncollectible accounts expense to net credit sales.

  6. Uncollectible accounts expense to accounts receivable written off.

  7. Accounts receivable turnover in days.

    1. Describe the implications of the resulting ratios for the auditor's audit strategy for the year 2023.

    2. What specific assertions are likely to be misstated?

    3. How should the auditor respond in terms of potential audit tests?

    Solutions

    Expert Solution


    Related Solutions

    AP12.2 (LO 2)  Analytical procedures The following information was taken from the accounting records for Aurora Manufacturing,...
    AP12.2 (LO 2)  Analytical procedures The following information was taken from the accounting records for Aurora Manufacturing, Inc.: Year 5 Unaudited Year 4 Audited Year 3 Audited Year 2 Audited Year 1 Audited Inventory $ 525,000 $ 460,000 $ 390,000 $ 310,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 85,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 1,400,000 1,200,000 Cost of goods sold 1,650,000 1,225,000 1,025,000 850,000 725,000 Industry...
    2. The following data from the just completed year are taken from the accounting records of...
    2. The following data from the just completed year are taken from the accounting records of Mason Company: sales $700,000 direct labor cost $100,000 raw material purchase $115,000 selling expenses $150,000 administrative expenses $65,000 Manufacturing overhead applied to work in process $100,000 Actual manufacturing overhead costs $120,000 Inventories Beginning Ending Raw materials $10,000 $15,000 Work in process $10,000 $2,000 Finished goods $20,000 $35,000 a) Prepared a schedule of cost of goods manufactured. Assume all raw materials used in production were...
    The following cost and inventory data are taken from the accounting records of a Company for...
    The following cost and inventory data are taken from the accounting records of a Company for the year just completed: Costs incurred: Direct labor cost ................................................... $140,000 Purchases of raw materials .................................. $236,000 Manufacturing overhead ...................................... $160,000 Advertising expense ............................................. $180,000 Sales salaries ....................................................... $100,000 Depreciation, office equipment ............................ $6,000 Inventories: Beginning the Year End the Year Raw materials ............................ $14,000 $30,000 Work in process .......................... $20,000 $10,000 Finished goods ............................ $40,000 $70,000 Required: 1. Prepare the cost of goods...
    The following cost and inventory data are taken from the accounting records of a Company for...
    The following cost and inventory data are taken from the accounting records of a Company for the year just completed: Costs incurred: Direct labor cost ................................................... $140,000 Purchases of raw materials .................................. $236,000 Manufacturing overhead ...................................... $160,000 Advertising expense ............................................. $180,000 Sales salaries ....................................................... $100,000 Depreciation, office equipment ............................ $6,000 Inventories: Beginning the Year End the Year Raw materials ............................ $14,000 $30,000 Work in process .......................... $20,000 $10,000 Finished goods ............................ $40,000 $70,000 Required: 1. Prepare the cost of goods...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 650,000 Direct labor cost $ 81,000 Raw material purchases $ 137,000 Selling expenses $ 101,000 Administrative expenses $ 43,000 Manufacturing overhead applied to work in process $ 202,000 Actual manufacturing overhead costs $ 225,000 Inventories Beginning Ending Raw materials $ 8,400 $ 10,400 Work in process $ 5,100 $ 20,200 Finished goods $ 71,000 $ 25,900 Required: 1. Prepare a...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 653,000 Direct labor cost $ 85,000 Raw material purchases $ 136,000 Selling expenses $ 110,000 Administrative expenses $ 45,000 Manufacturing overhead applied to work in process $ 208,000 Actual manufacturing overhead costs $ 221,000 Inventories Beginning Ending Raw materials $ 8,200 $ 10,300 Work in process $ 5,300 $ 20,000 Finished goods $ 75,000 $ 25,800 1. Prepare a schedule...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company: Sales $ 656,000 Direct labor cost $ 86,000 Raw material purchases $ 132,000 Selling expenses $ 107,000 Administrative expenses $ 42,000 Manufacturing overhead applied to work in process $ 207,000 Actual manufacturing overhead costs $ 223,000 Inventories Beginning Ending Raw materials $ 8,100 $ 10,300 Work in process $ 5,800 $ 20,300 Finished goods $ 79,000 $ 25,400 Required: 1. Prepare a schedule...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 653,000 Direct labor cost $ 87,000 Raw material purchases $ 132,000 Selling expenses $ 105,000 Administrative expenses $ 42,000 Manufacturing overhead applied to work in process $ 208,000 Actual manufacturing overhead costs $ 229,000 Inventories Beginning Ending Raw materials $ 9,000 $ 11,000 Work in process $ 5,100 $ 20,700 Finished goods $ 77,000 $ 25,400 Required: 1. Prepare a...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 651,000 Direct labor cost $ 88,000 Raw material purchases $ 138,000 Selling expenses $ 103,000 Administrative expenses $ 48,000 Manufacturing overhead applied to work in process $ 206,000 Actual manufacturing overhead costs $ 228,000 Inventories Beginning Ending Raw materials $ 8,500 $ 10,900 Work in process $ 5,400 $ 20,000 Finished goods $ 76,000 $ 25,000 Required: 1. Prepare a...
    The following data from the just completed year are taken from the accounting records of Mason...
    The following data from the just completed year are taken from the accounting records of Mason Company:    Sales $ 656,000 Direct labor cost $ 80,000 Raw material purchases $ 137,000 Selling expenses $ 104,000 Administrative expenses $ 45,000 Manufacturing overhead applied to work in process $ 205,000 Actual manufacturing overhead costs $ 225,000 Inventories Beginning Ending Raw materials $ 8,200 $ 10,900 Work in process $ 5,600 $ 20,600 Finished goods $ 74,000 $ 25,200 Required: 1. Prepare a...
    ADVERTISEMENT
    ADVERTISEMENT
    ADVERTISEMENT