What is Days Inventory Outstanding (DIO)?

Days Inventory Outstanding is the average number of days inventory sits in the warehouse before being sold. It is calculated by dividing 365 by your inventory turnover ratio.

What is a good inventory turnover ratio for D2C brands?

A good inventory turnover ratio for D2C brands typically ranges from 4.0x to 6.0x per year, meaning inventory rotates every 60 to 90 days.

E-commerce Inventory Turnover Calculator

Q: What is inventory turnover ratio?

Inventory turnover ratio measures how many times your average inventory is sold and replaced over a year. A higher ratio indicates efficient sales velocity and low storage costs.

Optimize inventory velocity. Input annual Cost of Goods Sold and beginning/ending stock levels to calculate turnover ratios and Days Inventory Outstanding.

Select Turnover Scenario

Annual Cost of Goods Sold (COGS)

Beginning Inventory Value

Ending Inventory Value

Share Your Feedback

Have a suggestion or found a calculation discrepancy? Let us know!

Methodology: Resolving Inventory Assets Rotation and Days Inventory Outstanding

The Inventory Rotation Formulas

We resolve the inventory rotation speed and days inventory outstanding by comparing annual COGS against average book values:

Average Inventory = (Beginning + Ending) / 2

Turnover Ratio = Annual COGS / Average Inventory

Days Outstanding (DIO) = 365 / Turnover Ratio

In retail accounting and corporate finance, inventory is a double-edged sword. While holding inventory is necessary to fulfill orders promptly, excessive inventory locks up operating capital, increases warehousing holding costs, and exposes the brand to obsolescence write-downs.

To evaluate inventory efficiency, operations managers track the **Inventory Turnover Ratio**. This ratio measures how many times your average inventory is sold and replaced over a year. A higher ratio indicates strong sales velocity and efficient capital rotation.

Dividing 365 days by the turnover ratio yields **Days Inventory Outstanding (DIO)**, representing the average number of days inventory sits in the warehouse before selling. A low DIO (e.g. 45 days) keeps working capital liquid. A high DIO (e.g. 120 days) locks up cash, raising financing needs.

Example Calculation Walkthrough

D2C Brand Annual Operational Profile

Let's evaluate a D2C home goods brand tracking inventory performance over a fiscal year under the following financial benchmarks:

Annual Cost of Goods Sold (COGS) = $240,000.00
Beginning Inventory Value (Jan 1) = $45,000.00
Ending Inventory Value (Dec 31) = $35,000.00

Step-by-Step Turnover Resolution

1. Solve for Average Inventory Value:
($45,000.00 + $35,000.00) / 2 = $40,000.00.

2. Solve for Inventory Turnover Ratio:
$240,000.00 (COGS) / $40,000.00 (Average Inventory) = 6.00 turns per year.

3. Solve for Days Inventory Outstanding (DIO):
365 days / 6.00 turns = 60.8 days.

This store turns its inventory **6.0 times per year**, meaning items spend an average of **60.8 days** in the warehouse before selling. This inventory velocity is highly efficient, minimizing warehousing storage fees and capital opportunity drag.

The Connection to the Cash Conversion Cycle (CCC)

Inventory turnover is a primary driver of your store's **Cash Conversion Cycle (CCC)**. CCC measures the number of days it takes to convert cash investments in inventory back into cash from sales:

Days Inventory Outstanding (DIO) represents the first phase of the cycle. If you buy inventory and it sits in the warehouse for 90 days, your cash is locked up.

To optimize CCC, you must minimize DIO by increasing inventory turnover. Combined with negotiating longer payment terms with suppliers (Days Payable Outstanding) and securing prompt payment from customers, lowering DIO helps ensure you generate cash from sales before paying supplier bills.

Common Pitfalls in Turnover Evaluations

Calculating Turnover Using Sales Revenue Instead of COGS

A common error is dividing total sales revenue by average inventory. Because sales revenue includes your retail markup, this error overestimates your turnover ratio. Always divide Cost of Goods Sold (COGS) by average inventory to evaluate turnover accurately.

Overlooking Slow-Moving SKU Categories in Averages

A healthy average turnover ratio can hide underperforming SKU categories. For example, a high turnover rate on your top-selling items can mask slow-moving, obsolete stock in other lines. Segment your turnover calculations by SKU category to audit performance accurately.

Guidelines for Turnover Management

COGS Alignment: Always use Cost of Goods Sold (COGS) to calculate turnover.
SKU Segmentation: Audit turnover ratios by product category to identify dead stock.
DIO Monitoring: Monitor Days Inventory Outstanding (DIO) monthly to manage cash flow.