Messing here with Days sales of inventory (DSI) ratio

Joined
Feb 14, 2020
Messages
4
Reaction score
0
Country
Sri Lanka
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
Joined
Jan 6, 2013
Messages
753
Reaction score
139
Country
United Kingdom
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
Joined
Jun 30, 2017
Messages
236
Reaction score
27
Country
Netherlands
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.
 
Joined
Apr 25, 2017
Messages
58
Reaction score
4
Country
India
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.

Ask a Question

Top