How to Calculate DIO

by Luke Kim; Updated September 26, 2017
Calculating DIO is very simple but is also very essential for a business.

Calculating DIO, or Day's Inventory Outstanding is very important in calculating the growth of the business as well as management. You may want to adjust your purchases to match the rise of demand or lower to adjust to the lower demands. The calculation is very simple and will take no more than 5 minutes if you have all the information at hand. No skills beyond a basic understanding of addition and division is necessary.

Items you will need

  • Calculator
  • Beginning inventory
  • Ending inventory
  • Cost of goods per day
Step 1

Calculate your beginning inventory by checking the value of your goods at the start of the day. Calculate your ending inventory by checking the value of your goods at the end of the day. Calculate the cost of goods per day by taking your monthly cost and divide that by the number of days in that month.

Step 2

Add beginning inventory to ending inventory. Divide that number by 2. That is your average inventory.

Step 3

Take your average inventory and divide that by the cost of goods per day.

Tips

  • The equation is: ( ( beginning inventory + ending inventory ) / 2 ) / cost of goods per day

About the Author

Luke Kim started writing in 2008, with work published in magazines such as Korea's "ICON." Kim has written extensively for SEO consultants and has abundant experience with writing in most technical fields. He has a B.A. in English from Northwestern Polytechnic University.

Photo Credits

  • Jupiterimages/Goodshoot/Getty Images