Question

In: Accounting

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 Median
Accounts payable turnover days

31

30

29

30

Cost of goods sold to average accounts payable

10.7

11.2

10.9

11.1

Current ratio

1.9

2.2

2.3

2.1

Required

  1. Calculate the following information and ratios for years 2, 3, 4, and 5:

    1. Purchases.

    2. Accounts payable turnover in days.

    3. Cost of goods sold to average accounts payable.

    4. Current ratio.

  2. Describe the implications of the resulting ratios for the audit strategy in year 5. What specific audit objectives are likely to be misstated? How should the auditor respond in terms of potential audit procedures?

Solutions

Expert Solution



Related Solutions

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 Calculate the...
The following information was taken from the accounting records of JBD Company as of December 31,...
The following information was taken from the accounting records of JBD Company as of December 31, 2020: Inventory ................. $17,000 Accounts Payable .......... $36,000 Common Stock .............. $78,000 Accounts Receivable ....... $11,000 Retained Earnings ......... $24,000 (at January 1, 2020) Copyright ................. $20,000 Salaries Expense .......... $28,000 Supplies .................. $12,000 Mortgage payable .......... $80,000 (due March 1, 2040) Land ...................... $93,000 Notes Payable ............. $17,000 (due November 1, 2022) Trademark ................. $37,000 Sales Revenue ............. $97,000 Equipment ................. $85,000 Income...
The following information was taken from the accounting records of CJTR Company as of December 31,...
The following information was taken from the accounting records of CJTR Company as of December 31, 2020: Accounts Payable .......... ? Accounts Receivable ....... $44,000 Building .................. $68,000 Cash ...................... $17,000 Common Stock .............. $56,000 Cost of Goods Sold ........ $41,000 Dividends ................. ? Equipment ................. $79,000 Interest Revenue .......... $40,000 Inventory ................. $63,000 Land ...................... $82,000 Notes Payable ............. $67,000 Rent Expense .............. $23,000 Retained Earnings ......... ? Salaries Expense .......... $52,000 Salaries Payable .......... $34,000 Sales Revenue ................
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 information was taken from the accounting records of Dunbar Mifflin Company in 2018. ​​​​​​Beginning...
The following information was taken from the accounting records of Dunbar Mifflin Company in 2018. ​​​​​​Beginning of 2018​Ending of 2018 Direct materials inventory​​​135,000​​83,000 Work-in-process inventory​​​185,000​​154,000 Finished-goods inventory​​​255,000​​216,000 Purchases of direct materials​​​​​​270,000 Direct manufacturing labor​​​​​​225,000 Indirect manufacturing labor​​​​​​103,000 Plant insurance​​​​​​​11,000 Depreciation-plant, building, and equipment​​​​48,000 Plant utilities​​​​​​​​29,500 Repairs and maintenance-plant​​​​​13,500 Equipment leasing costs​​​​​​66,800 Marketing, distribution, and customer-service costs​​​129,500 General and administrative costs​​​​​72,500 Required: 1. Prepare a schedule of cost of goods manufactured. Question 2​​​​​​​​​(Total: 38 marks) Following are the account balances for...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,400 $ $6,000 $165,300 Purchases of direct materials 86,400 52,600 258,800 Total direct materials available for use 394,600 111,600 Direct Materials Inventory, ending 26,700 59,350 Direct materials used in production 90,800 Direct labor 212,700 25,500 299,100 Total manufacturing overhead...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,900 $ $6,500 $166,000 Purchases of direct materials 86,400 52,600 258,900 Total direct materials available for use 394,900 112,000 Direct Materials Inventory, ending 26,200 59,750 Direct materials used in production 91,100 Direct labor 212,000 25,000 298,500 Total manufacturing overhead...
The following selected data were taken from the accounting records of Manitoba Manufacturing Company. The company...
The following selected data were taken from the accounting records of Manitoba Manufacturing Company. The company uses direct-labor hours as its cost driver for overhead costs.   Month Direct-Labor Hours Manufacturing Overhead   January 37,000       $ 753,500   February 36,000       737,000   March 39,000       798,000   April 34,000       698,000   May 41,000       801,000   June 46,000       896,000 June’s costs consisted of machine supplies ($248,400), depreciation ($31,000), and plant maintenance ($616,600). These costs Exhibit the following respective behavior: variable, fixed, and semivariable....
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses direct-labor hours as its cost driver for overhead costs. Month Direct-Labor Hours Manufacturing Overhead January 31,000 $ 695,000 February 33,000 734,000 March 43,000 893,000 April 34,000 752,750 May 38,000 796,500 June 36,000 793,500 March’s costs consisted of machine supplies ($219,300), depreciation ($29,500), and plant maintenance ($644,200). These costs exhibit the following respective behavior: variable, fixed, and semivariable. The manufacturing overhead figures presented in the...
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses direct-labor hours as its cost driver for overhead costs. Month Direct-Labor Hours Manufacturing Overhead January 37,000 $ 701,000 February 39,000 740,000 March 52,000 899,000 April 40,000 754,250 May 44,000 805,500 June 42,000 802,500 March’s costs consisted of machine supplies ($296,400), depreciation ($32,500), and plant maintenance ($570,100). These costs exhibit the following respective behavior: variable, fixed, and semivariable. The manufacturing overhead figures presented in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT