Days sales in inventory (DSI) refers to a financial ratio showing the number of days a company takes to turn over all its inventory. All inventories are a summation of finished goods, work in progress and progress payments. Days sales in inventory can also be called day’s inventory outstanding or the average age of an inventory.
Managers generally prefer lower days sales in inventory because it shows that the company is efficient in its operations and increases cash flow better within the company. On the other hand, a larger number of days or a higher days sales in inventory shows that the company has made a huge investment in the inventory and the possibility of goods being faced out in the market is very high. At the same time, a larger number of days increases the storage cost and exposes the stock to a risk of theft
Some goods are perishable and expire within a short duration making it necessary for a business to analyze approximately the average amount of time necessary to sell its inventory before they stock the shelves. This can only be realized with a deeper understanding of days sales in inventory ratio concept for managers to be able to assess the average amount of time for their companies to sell its inventory to decrease the chances of inventory getting obsolete and can cost the company money. Managers also must know when purchasing new inventory items is necessary to keep the business operating smoothly
Days Sales in Inventory Formula
$$Days\:Sales\:in\:Inventory =\dfrac{ Average\:Inventory}{Cost\:of\:Goods\:Sold} \:x \:365\:days$$
This formula has three different versions which can be used depending on what you’re looking for.
In the formula above, both beginning and closing inventories are summed up and then divided by two to give the average inventory value. Then the average found here is divided by the cost of goods sold to give days sales in inventory value “during” that particular period.
$$Days\:of\:Sales\:in\:Inventory =\dfrac{ Ending\:Inventory}{Cost\:of\:Goods\:Sold} \:x\:365\:days$$
In the formula above, the ending inventory figure is obtained from the balance sheet. Ending inventory can be from finished goods for a retail company. But for other companies that have even the work in process goods, all the accounts must be added up to get the exact ending inventory. The days sales in inventory value found here will represent DSI value “as of” the mentioned date.
$$Days\:sales\:in\:Inventory =\dfrac{1}{Inventory\:Turnover} \:x\:365\:days$$
In the formula above, a new and related concept of inventory is introduced which is the number of times a company is able to its stock over the course of a particular time period, say annually. To calculate inventory turnover you divide the cost of goods sold is by the average inventory.
Note that the cost of goods sold does not change in all the three formulas and it is always the cost that was incurred in producing the goods sold.The days of sales in inventory uses ending inventory whereas inventory turnover uses average inventory. Also, The number of days in a year is using 365 days but in some cases, you can be directed to use 360 which is widely accepted.
Days Sales in Inventory Example
Example 1
XYZ Limited is a leading retail corporation with an average inventory of $15 million. Cost of goods sold on their annual financial statements for 2018 was $300m. Assuming that the year ended in 365 days, determine XYZ Limited’s Days of Sales in Inventory.
For this, we use the average inventory formula:
$$DSI =\dfrac{ Average\:Inventory}{COGS}\:x \:365\:days$$
Now let’s break it down and identify the values of different variables in the problem.
- Average Inventory = $15m
- COGS = $300m
$$DSI = \dfrac{15}{300}\:x \:365\:days = 18.25\: days$$
Example 2
ABC Limited, a Microsoft Corp. recorded a total of $3 billion as ending inventory. The company spent a total of $40 billion to produce the goods that were sold in the fiscal year 2017. Since Microsoft manufactures both hardware and software products, by the end of the fiscal year 2017 the inventory was in different forms. Finished goods were worth $1.95 billion, work in progress was worth $385 million and raw materials of around $665 million. Assuming that fiscal year ended in 360 days, determine ABC Limited’s Days of Sales in Inventory.
For this, we use the ending inventory formula:
$$DSI = \dfrac{Ending\:Inventory}{COGS} \:x\:360\:days$$
Now let’s break it down and identify the values of different variables in the problem.
- Ending Inventory = $3 billion
- COGS = $40 billion
$$DSI = \dfrac{\$3\:billion}{\$40\:billion}\:x \:360\:days = 27\: days$$
ABC Limited takes 27 days to clear its inventory.
Days Sales in Inventory Analysis
From the examples above, the DSI concept is very simple and computing it takes the shortest time possible so long as one can identify the required variables from the problem. The three formulas above provide room for one easily compute DSI depending upon the accounting practice.
DSI concept is important in a company’s inventory management as it informs managers on the number of days the stock will last in the stores. Management, therefore, may find it beneficial to ensure that inventory moves fast to reduce costs and increase cash flows. The more time that the inventory remains on the shelves, the longer the company’s cash is held and cannot be used for other operations and hence costing the company extra money.
DSI values can be used to show the efficiency of the company in terms of its operations. For instance, when the DSI is low it means that the company is more efficient in its operations because it is taking the shortest time possible to clear its stock and restock again or use that money for other purposes within the company.
A lower DSI is also preferred because it ensures that the company reduces the storage cost. By selling the whole stock within a short period for the case of foodstuff, consumers are guaranteed fresh and healthy. However, a high DSI could also mean that the company’s management maybe has decided to maintain high inventory levels to achieve high order fulfillment rates.
One key point to remember is that DSI figures often vary across different industries so it is advisable not to compare the performance of companies operating in different industries. Thus, DSI should only be used to compare the performance of companies within the same industry.
Days Sales in Inventory Conclusion
- Days sales in inventory is the average number of days it takes for a firm to sell off inventory.
- A high days sales in inventory suggests a company is poorly managing its inventory.
- Days sales in inventory requires two variables: Inventory (average or ending) Change and cost of goods sold.
- Depending on the accounting practice, you can divide the average or ending inventory by the cost of goods sold.
- Days sales in inventory is computed within a period of one year but can be adjusted depending on what you need.
Days Sales in Inventory Calculator
You can use the days sales in inventory calculator below to quickly calculate the number of days a company needs to sell all its inventory by entering the required numbers.