Days Inventory Outstanding

What is Days Inventory Outstanding (DIO)?

Days inventory outstanding ratio simply speaks of the time, a business takes, to convert its inventory into sales. Also known as days sales of inventory, it is an important performance indicator in inventory and working capital management.

Days Inventory Outstanding Formula

The formula for DIO is simply expressed as follows:

Average Inventory
Days Inventory Outstanding = —————— * 365
Cost of Goods Sold

where,

  • Average inventory is the average inventory value at the beginning and at the ending of the financial year.
  • Cost of Goods Sold is same as represented in the income statement. It includes all the expenses relating to the production of goods and services that are sold.  It normally includes material, labor, and overheads.

Note that ‘sales’ is used at times for calculating this ratio due to difficulty in finding the right cost of goods sold for any reason. But it is not a right practice when inventory i.e. our numerator is valued at cost, the denominator should also be valued at cost.

Reciprocal of this ratio gives you inventory turnover ratio which is expressed in times rather than no. of days.

Days Inventory Outstanding Calculation with Example

Let’s take a small example and look at how we can calculate this metric.

Inventory value at the beginning = $40,000

Inventory value at the ending = $60,000

Cost of goods sold = $300,000

Days Inventory Outstanding = ($40,000 + $60,000) / 2 * 365 /  $300000 = 60 Days

Days Inventory Outstanding

Explanation of Days Inventory Outstanding

We can call 60 days as 2 months. From another angle of looking at it, we can also say that the frequency of replacing the inventory is 2 months. So, effectively, the firm, in the example, is converting its inventory into sales 6 times a year (6 = 12 Months / 2 Months).

The figure of 60 days in above example represents that the inventory that enters the entry gates of a firm will go out of exit gates in 60 days becoming part of the finished goods of the firm. If the firm is a manufacturing concern, these 60 days would comprise of the days of storing the raw material, processing of the material on the production floor, staying in the stage of goods in process, finishing of the goods in process, packaging, and dispatching.

In bookkeeping or accounting terms, the following process takes place. If we look at it, the inventory is created as an asset in the balance sheet on the date of receipt of the inventory or it could be on the date of booking of the invoice in the accounting system.

Series of Events Dates Accounting Event
Purchase Order for raw material is placed by the purchasing team 10 June
Vendor accepts the order and raises the invoice 13 June Days of Inventory Begins or 
Vendor dispatches the raw materials from his factory. 14 June
RM received at the factory & a goods inward receipt is prepared after proper verification of quality and quantity of goods with PO. 20 June Days of Inventory Begins
Issued for Production 30 June
Becomes a Goods in Process 25 July
Becomes Finished Goods and Stored 30 July
Sold to Customer and Dispatched 10 Aug Days of Inventory Ends

Interpretation of Days Inventory Outstanding and an Ideal Ratio

Lower is Better

The apparent interpretation of this metric is “Lower the Better”. Why is lower better? Assume the firm in the example above has blocked the working capital of $20,000 in the inventories. Now, at the rate of 12% a year, the interest cost of holding the inventory would be $2,400. I have a simple question for you. Will the interest cost change, if the company is able to reduce the inventory conversion cycle from 2 months to 1.5 months. No, because the interest cost is a fixed cost. It will neither change if the conversion time becomes 4 months nor when it becomes 1 month. Here is the real opportunity of taking advantage of financial leverage. When we know that interest cost will remain fixed, the management of the firm should focus on speeding up the inventory movement. That will directly show its positive impact on gross profits and consequently in net profits in the income statement.

Compare Only within Same Industries

Different companies may have different days sales of inventory. Can we say company A whose DIA is 60 days is better off than company B with a DIA of 240 days?  The first instinct of anybody will say that company A is better off. In reality, we can’t judge by just looking at this metric alone. Along with this metric, we also should also first look at whether both the companies are in same industry. Why should we do this?  There is a vast difference between the business operations in different industries. Let me introduce more information here. Company A is trading in plywood and company B is manufacturing aircraft and manufacturing time alone takes 200 days. Has your opinion changed? I believe ‘Yes’. It has to. So, the first important thing is ‘When comparing DIO of 2 companies, they should exist in SAME INDUSTRY’.

Benefits

There are various benefits of this metric and we will discuss them below:

Comparison tool for Investors

By now, you would agree that it can work as a great tool for investors when they are rating two companies on their efficiency in inventory management. We have already covered in details, what we should be careful about while comparing two companies.

Performance Indicator

The internal management can also use it as their tool or as a performance indicator for employees responsible for effective inventory management. When the appraisal of relevant employees is linked with this metric, they are bound to think, focus and bring positive change in the overall inventory processes.

Disadvantages of Days Inventory Outstanding

Like any other ratio, this ratio also has its own limitations. Let’s look at them.

Risk of Faulty Average Inventory

The real idea behind taking average is to take an average inventory hold by the company throughout the year. For the sake of ease, we take an average of opening and closing inventory for finding out this ratio. This thing creates a mess. If a company has intentionally increased its inventory at the time of year closing genuinely in expectation of a sudden big order. The figure of average inventory as per the stated formula will not represent a true average inventory of the firm in a real sense. One of the ways to overcome the problem of calculation of average inventory is to take average of beginning inventory is of 12 months.  this to a great extent eliminate the problem of seasonality that we just discussed. Or we can also take help of sophisticated ERP for this purpose for Greater accuracy.

DIO Alone not Sufficient

This metric is not sufficient alone. By this, I mean you can’t say with confidence that the inventory management of a company is good or bad without comparing it with the peers in the same industry. Even after that, suppose a company is heavily investing inventory because it has started catering to retail customers (where the orders are urgent) directly from the factory which the other players in the sector are not doing. In this case, the extra margins earned by serving directly to retail markets compensate for the cost of holding inventory.

How to Improve Days Sales of Inventory Ratio?

A firm can see significant improvement in this ratio and achieve overall efficiency in managing their inventory by following the steps given below:

  • Accurate planning and forecasting of inventory can not only improve the ratio but will also ensure smooth working capital cycle.
  • Increased sales with better marketing strategy without a compensating increase in the investment in inventory can significantly improve the days of inventory outstanding.
  • Competitive pricing of the product of the firm can also boost the sales if the product sales are price sensitive.
  • Lower the input prices with the help of techniques like negotiations with the vendor, bulk purchases, group purchases, etc
  • Working on product mix of the firm and determining the top selling products. Implement Pareto’s 80:20 Principle on the inventory to invest in right inventory contributing maximum to the profits.
  • Focus on building advance order book so that the planning of inventory becomes even more efficient.
  • With effective planning and forecasting, curb safety and dead inventory.
  • Optimize the level of stock with the help of techniques like EOQ, Just in Time etc.

For an in-depth explanation, you can visit, How to Analyze and Improve Inventory Turnover Ratio?

Last updated on : June 30th, 2018

** Disclaimer: This post may contain Affiliate Links marked as ** and we may earn a commission on sale.

What’s your view on this? Share it in comments below.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.