Question

gThe following data are available for Martin Solutions, Inc. Year 2 Year 1 Sales $1,139,600 $1,192,320 Beginning inventory 80,000 64,000 Cost of goods sold 500,800 606,000 Ending inventory 72,000 80,000 Required: Assume a 365-day year. Determine for each year:

Answer 1

Answer and Explanation:

The computation is shown below;

For Year 1

Average inventory = (Beginning inventory + Ending inventory)÷ 2

= ($64,000 + $80,000) ÷ 2

= $72,000

Inventory turnover = Cost of goods sold  ÷ Average inventory

= $606,000 ÷ 72,000

= 8.4 times

Days in inventory = 365 ÷ Inventory turnover ratio

= 365 ÷ 8.4

= 43.5 days

For Year 2

Average inventory = (Beginning inventory + Ending inventory) ÷ 2

= ($80,000 + $72,000) ÷ 2

= $76,000

Inventory turnover = Cost of goods sold ÷ Average inventory

= $500,800 ÷ 76,000

= 6.6 times

Days in inventory = 365 ÷ Inventory turnover ratio

= 365 ÷ 6.6

= 55.3 days