What is Days Sales in Inventory?
Days Sales in Inventory (DSI) calculates the number of days it takes a company on average to convert its inventory into revenue.
How to Calculate Days Sales in Inventory (Step-by-Step)
Days sales in inventory (DSI) measure how much time is necessary for a company to turn its inventory into sales.
The inventory line item on the balance sheet captures the dollar value of the following:
- Raw Materials
- Work-in-Progress (WIP)
- Finished Goods
The fewer days required for inventory to convert into sales, the more efficient the company is.
- Short DSI → A shorter DSI suggests that the company’s current strategy for customer acquisitions, sales and marketing, and product pricing is effective.
- Long DSI → The reverse is true for a long DSI, which could be a potential sign that the company should adjust its business model and spend more time researching its target customer (and their spending patterns).
Days Sales in Inventory Formula (DSI)
Calculating a company’s days sales in inventory (DSI) consists of first dividing its average inventory balance by COGS.
Next, the resulting figure is multiplied by 365 days to arrive at DSI.
Days Sales in Inventory Calculation Example (DSI)
For example, let’s say that a company’s DSI is 50 days.
A 50-day DSI means that, on average, the company needs 50 days to clear out its inventory on hand.
Alternatively, another method to calculate DSI is to divide 365 days by the inventory turnover ratio.
How to Interpret DSI Ratio (High or Low)
Comparing a company’s DSI relative to that of comparable companies can offer useful insights into the company’s inventory management.
While the average DSI depends on the industry, a lower DSI is viewed more positively in most cases.
If a company’s DSI is on the lower end, it is converting inventory into sales more quickly than its peers. Moreover, a low DSI indicates that purchases of inventory and the management of orders have been executed efficiently.
Companies attempt to minimize their DSI in an effort to limit the time that inventory is sitting around waiting to be sold.
Common issues that can cause a company’s DSI to increase are the following:
- Lack of Consumer Demand
- Trailing Behind Competitors
- Pricing is Excessive
- Mismatch with Target Customer
- Poor Marketing