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]

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]

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

3 Ways to Calculate Days in Inventory - wikiHow

Finding the days in inventory for your business will show you the average number of days it takes to sell your inventory. The lower the number you calculate, the better return on your assets you're getting. If you're not sure where to...

www.wikihow.com

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.