Messing here with Days sales of inventory (DSI) ratio

tpBlacks

Everyone says,
DSI = average inventory ÷ cost of goods sold × 365

Now my problem is about avg inventory and cost of goods sold.

Does average inventory means average inventory that we had each day ? And does cost of goods sold means average cost of goods sold per each day ?

Please help mee ! Thanks very much

Fidget

VIP Member
Not a ratio I'm familiar with, but I expect average inventory will be opening inventory + closing inventory divided by 2. Cost of goods sold, will be the cost of goods sold figure rather than any sort of average of it.

Werner Reisacher

VIP Member
You will find all the theoretical information on the topic under this ULR.

When it comes to the practical application of these ratios, focus on the definition: "within the same accounting period". You can calculate the turnover ratio or days of sales for each month or quarter or annually. Average meaning opening balance plus closing balance during the period you measure divided by 2. The only change in the conversion formula from the turnover ratio into days of sales is that you have to divide 30, or 90, instead of 360 days by the turnover ratio.
One other thing you have to be careful about is not to mix apples with bananas. Make sure that the value of the inventory does only include the "trading items" and not items that are not finished saleable products. (spare parts, tools, etc.) The same applies to the COGS. Depending on the companies activities and the costing system they use, the Cost of Sales line item may include costs that are directly related to the amount of product you sold during that period.

Asha Kanta Sharma

From my view Average Inventory is calculated by dividing Opening and Closing Inventory by 2.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Members online

No members online now.

Threads
11,666
Messages
27,639
Members
21,470
Latest member
Batty