Days Inventory Outstanding

Days Inventory Outstanding

See Also:
Inventory Turnover Ratio
Inventory to Working Capital Ratio
How to Manage Inventory
Days Sales Outstanding (DSO)
Days Payables Outstanding (DPO)
How to Develop Daily Cash Report
13 Week Cash Flow Report
Supply Chain and Logistics

Days Inventory Outstanding

Days inventory outstanding (DIO), defined also as days sales of inventory, indicates how many days on average a company turns its inventory into sales. Value of DIO varies from industry and company. In general, a lower DIO is better. A useful tool in managing and improving inventory turns is a Flash Report!

Days Inventory Outstanding Explanation

Days inventory outstanding ratio, explained as an indicator of inventory turns, is an important financial ratio for any company with inventory. It shows how quickly management can turn inventories into cash. In general, a decrease in DIO is an improvement to working capital, and an increase is deterioration.

Days Inventory Outstanding Formula

Calculate the days inventory outstanding formula using the following equation:
DIO = (average inventory / cost of goods sold) * 365 days


NOTE: Want the 25 Ways To Improve Cash Flow? It gives you tips that you can take to manage and improve your company’s cash flow in 24 hours!. Get it here!

[button link=”https://strategiccfo.com/25-ways-to-improve-cash-flow” bg_color=”#eb6500″]Download The 25 Ways To Improve Cash Flow[/button]


Days Inventory Outstanding Calculation

Days inventory outstanding calculations cross a myriad of needs and purposes.
For example, a business has $2,500 in inventory on average, $25,000 in cost of goods sold.
DIO = (2,500 / 25,000) * 365 = 37 days

Days Inventory Outstanding Example

For example, James is the owner of a grocery store. His store, a private seller of groceries to a large suburb, has grown to be a household name in his local area. James now wants to find his DIO for his store, as well as, select product lines.
James begins by talking to his accountant. The accountant, skilled in his profession, performs this days inventory outstanding analysis:
James’ store has $2,500 in inventory on average, $25,000 in cost of goods sold.
Days Inventory outstanding = (2,500 / 25,000) * 365 = 37 days
James’ store is keeping pace with the national market of grocery stores. In his state, however, James’ store could use a little improvement. James considers options such as clearance item discounts or running coupons on items which he wants to sell faster. These promotions, including lower prices, could produce the inventory turnover which James is looking for.
James now looks to his bookkeeper for up-to-date information on his days inventory outstanding for certain product lines. James allows time to find these measurements and is confident that with the right team, perspective, and motivations he can grow his store further.
Reducing days inventory outstanding is just one of the many ways to improve the cash flow of a company. If you’re looking for 24 ways to improve cash flow, download the free 25 Ways to Improve Cash Flow whitepaper.
days inventory outstanding
[box]Strategic CFO Lab Member Extra
Access your Cash Flow Tuneup Execution Plan in SCFO Lab. This tool enables you to quantify the cash unlocked in your company.
Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]
days inventory outstanding

Resources

For statistical information about industry financial ratios, please go to the following websites: www.bizstats.com and www.valueline.com.

ARTICLES YOU MIGHT LIKE

The Struggles of Private Company Accounting

Hiring the right accountant  When I meet a business owner operating at a successful $10 million in revenue, they often mention, “My CPA”… I immediately know that CEO/Entrepreneur is referring to their Tax CPA.  That is because one thing that all Entrepreneurs have in common is that they must file a tax return.  So, from

Read More »

IN CRISIS? GET A STRATEGIC CFO! – CEO Blindspots Podcast

Friend of the firm, Birgit Kamps, recently had Strategic CFO President, Dan Corredor, as a guest on her podcast, CEO Blindspots. CEO BLINDSPOTS HOST: Birgit Kamps. She was speaking five languages by the age of 10, and lived in five countries with her Dutch parents prior to becoming an American citizen. Birgit’s professional experience includes starting

Read More »

SHRM calls ICHRA the 401K for Group Health Benefits

Fed-up with group health insurance? ICHRA is the new way to offer great health benefits and avoid ACA penalties, SHRM calls it the 401K for group health benefits.  In 2020 the Department of Labor, HHS and IRS changed the rules for employer health benefits. They changed the Affordable Care Act mandates and penalties for every

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ SERIES

Strategic CFO™ Financial Leadership Workshop
The Art of the CFO®

Days
Hours
Min
Sec

September 12-15th 2022