Question

At December 31, 2020, the following information was available for Concord Corporation: ending inventory $35,750, beginning inventory $63,500, cost of goods sold $263,000, and sales revenue $376,000.
a. Calculate the inventory turnover for Oakley, Inc. (Round inventory turnover to 2 decimal places, e.g. 5.12.)
b. Calculate the days in inventory for Oakley, Inc. (Round days in inventory to 0 decimal places, e.g. 125.)

Answer 1

Answer:

a. Inventory Turnover = 5.299 times or 5.30 times

b. Days in Inventory = 69 days

Explanation:

a)

To calculate the inventory turnover, we first need to find out the avergae inventory. The average inventory is calculated by adding the opening and the closing inventory and dividing the sum by 2.

• Average Inventory = (35750 + 63500) / 2 = $49625

The inventory turnover is,

• Inventory Turnover = Cost of Sales / Average Inventory

• Inventory Turnover = 263000 / 49625 = 5.299 times or 5.3 times

b)

Days in inventory is the period for which, on average, the inventory is kept and sold completely.

We can calculate days in inventory simply by dividing the number of days for which we are calculating the ratio for, say in this case one years or 365 days by the inventory turnover ratio we calculated.

Days in inventory = 365 / 5.30 = 68.8679 or 69 days