Question

In: Accounting

Crane Company has a July 31 fiscal year end and uses a perpetual inventory system. The...

Crane Company has a July 31 fiscal year end and uses a perpetual inventory system. The records of Crane Company show the following data:

	2021	2020	2019
Income statement:
Sales	$350,000	$325,000	$360,000
Cost of goods sold	247,000	228,000	273,000
Operating expenses	70,000	70,000	70,000
Balance sheet:
Merchandise inventory	52,000	44,000	35,000

After its July 31, 2021, year end, Crane discovered two errors:

1.		At July 31, 2020, Crane had $10,000 of goods held on consignment at another company that were not included in the physical count.
2.		In July 2020, Crane recorded a $15,000 inventory purchase on account that should have been recorded in August 2020.

Prepare corrected income statements for Crane for the years ended July 31, 2019, 2020, and 2021.
Calculate the incorrect and correct inventory turnover ratios for 2020 and 2021. (Round answers to 2 decimal places, e.g. 52.75.)

	2020		2021
Incorrect inventory turnover		times		times
Correct inventory turnover

Solutions

Expert Solution

Answer:

	2020		2021
Incorrect inventory turnover	5.77	Times	5.15	Times
Correct inventory turnover	8.44	Times	8.1	Times

Explanations:

Step 1: Calculation of corrected COGS and inventory

COGS 2020	228,000
Less: consignment inventory	10,000
Less: purchase of next year	15,000
Corrected COGS	$203,000

COGS 2021	247,000
Add: Purchase not recorded	15,000
	262,000

Merchandise inventory 2020	44,000
Less: consignment inventory	10,000
Less: purchase of next year	15,000
Corrected amount	19,000

Merchandise inventory 2021	52,000
Less: consignment inventory	10,000
Corrected amount	42,000

Step 2: Calculation of inventory turnover ratios

Inventory turnover ratio = COGS ÷ Average inventory

a.) Incorrect inventory turnover

2020:

= 228,000 ÷ (35,000 + 44,000 ÷ 2)

= 228,000 ÷ 39,500

= 5.77

2021:

=247,000 ÷ (44,000 + 52,000 ÷ 2 )

=247,000 ÷ 48,000

= 5.15

a.) correct inventory turnover

2020:

= 203,000 ÷ (35,000 + 19,000 ÷ 2)

= 228,000 ÷ 27,000

= 8.44

2021:

=262,000 ÷ (19,000 + 42,000 ÷ 2 )

=247,000 ÷ 30,500

= 8.1

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Harrison Company has a July 31 fiscal year end and uses a perpetual inventory system. The...

Harrison Company has a July 31 fiscal year end and uses a perpetual inventory system. The records of Harrison Company show the following data: 2021 2020 2019 Income statement: Sales $350,000 $330,000 $310,000 Cost of goods sold 245,000 235,000 225,000 Operating expenses 76,000 76,000 76,000 Balance sheet: Merchandise inventory 55,000 45,000 35,000 After its July 31, 2021, year end, Harrison discovered two errors: 1. At July 31, 2020, Harrison had $10,000 of goods held on consignment at another company that...

Whispering Winds Warehouse Store has an August 31 fiscal year end and uses a perpetual inventory...

Whispering Winds Warehouse Store has an August 31 fiscal year end and uses a perpetual inventory system. An alphabetical list of its account balances at August 31, 2021, follows: All accounts have normal balances. Accounts payable $29,500 Interest revenue $930 Accounts receivable 21,000 Merchandise inventory 58,000 Accumulated depreciation—equipment 26,920 Notes payable 49,710 Notes receivable 32,500 Cash 13,500 Rent expense 16,500 Cost of goods sold 575,500 Sales 700,000 Depreciation expense 6,730 Sales discounts 3,800 Equipment 67,300 Sales returns and allowances 14,400...

Nix’It Company’s ledger on July 31, its fiscal year-end, includes the following selected accounts that have normal balances (Nix’It uses the perpetual inventory system)

Nix’It Company’s ledger on July 31, its fiscal year-end, includes the following selected accounts that have normal balances (Nix’It uses the perpetual inventory system). Merchandise inventory $ 38,800 Sales returns and allowances $ 6,300 T. Nix, Capital 117,300 Cost of goods sold 105,600 T. Nix, Withdrawals 7,000 Depreciation expense 10,500 Sales 159,800 Salaries expense 33,500 Sales discounts 3,100 Miscellaneous expenses 5,000 A physical count of its July 31 year-end inventory discloses that the cost of the merchandise inventory still available...

The Lippert Company uses the perpetual inventory system. The following July data are for an item...

The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 60 units @ $11 per unit 10 Purchased 80 units @ $12 per unit 15 Sold 90 units @ 26 Purchased 55 units @ $13 per unit Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods. Round your final answers to the...

Jayson Products uses a perpetual inventory system. At year-end, the Inventory account had a balance of...

Jayson Products uses a perpetual inventory system. At year-end, the Inventory account had a balance of $280,000, but a complete year-end physical inventory indicated goods on hand costing only $273,000. Jayson should:

Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the...

Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Date: July 1: 8 units $110 cost of units July 6: 7 sales units July 11: 12 units $126 cost of units July 14: 5 sales units July 21: 13 units $137 cost of units July 27: 10 sales units a) Calculate the average cost per unit at July 1, 6, 11, 14, 21, & 27. b)...

Lyon Center began operations on July 1. It uses a perpetual inventory system. During July, the...

Lyon Center began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Date Units Unit Cost Sales Units July 1 7 $62 July 6 5 July 11 3 $66 July 14 3 July 21 4 $71 July 27 3 New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect. Calculate average cost for each unit. (For calculation and answers...

A company that uses the PERPETUAL inventory system has the following records for 2017 Beginging inventory...

A company that uses the PERPETUAL inventory system has the following records for 2017 Beginging inventory Units Unit cost Purcahses: 120 $48 Febuary 8th 60 52 June 15th 70 54 22-Aug 55 57 Novemeber 29 45 61 Salkes: 30-Mar 145 20-Jul 90 December 15th 60 Please compute the cost of ending inventory and the cost of goods sold using the follow methods: Please also show all steps/work A) FIFO B) Weighted Average c) LIFO

At the end of last year, Helen's, Inc. (uses a perpetual inventory system) had merchandise costing...

At the end of last year, Helen's, Inc. (uses a perpetual inventory system) had merchandise costing $115,000 in inventory. During January of the current year, the company purchased merchandise costing $35,000, and sold merchandise which it had purchased at a total cost of $55,000. Based on the foregoing information, the amount of costs transferred from the Inventory account to the Cost of Goods Sold account during January was:

At the end of its fiscal year, the adjusted trial balance of Crane Company is as...

At the end of its fiscal year, the adjusted trial balance of Crane Company is as follows: CRANE COMPANY Adjusted Trial Balance July 31, 2017 Debit Credit Cash $2,850 Accounts receivable 11,420 Prepaid rent 500 Supplies 750 Debt investments 8,000 Equipment 19,950 Accumulated depreciation—equipment $5,700 Patents 18,300 Accounts payable 4,265 Interest payable 750 Unearned revenue 2,050 Notes payable (due on July 1, 2019) 45,300 B. Crane, capital 28,285 B. Crane drawings 16,900 Service revenue 74,100 Interest revenue 320 Depreciation expense...

Subjects