Inventory Turns, Days of Supply & the Cash-to-Cash Cycle
A warehouse manager can have a full building and still be in trouble: shelves packed with slow stock, cash trapped in cartons, and stores asking why the fast SKUs are unavailable. Inventory is not just a pile of products - it is cash wearing a barcode.
- Inventory turns measure speed: how many times inventory is sold and replaced in a period.
- Days of supply measures cover: how many days current inventory can support demand or usage.
- Cash-to-cash cycle links operations to finance: DIO + DSO - DPO.
- Higher turns are good only if service levels hold. Very high turns can mean stockouts, lost sales or emergency freight.
- Low days of supply is not automatically lean. It is dangerous if lead time, demand variability or supplier reliability is ignored.
- The best answer connects inventory to working capital: buy inventory, sell it, collect cash, pay suppliers.
- Benchmark by category. Grocery, fashion, jewellery, spares and pharma need very different inventory speeds.
Big Picture
Inventory turns, days of supply and the cash-to-cash cycle are three views of the same operating truth: how quickly money moves through the business. Inventory turns look at speed, days of supply looks at cover, and cash-to-cash shows how inventory, receivables and payables combine into working capital pressure.
Core Explanation
The easiest way to understand the topic is to separate three questions:
- How fast is inventory moving? - inventory turns.
- How long can we survive with current stock? - days of supply.
- How long is cash trapped in the operating cycle? - cash-to-cash cycle.
1. Inventory Turns - The Speed Metric
Inventory turnover is usually calculated as:
Inventory Turns = Cost of Goods Sold / Average Inventory
Use COGS, not sales revenue, because inventory is carried at cost. Average inventory is normally:
Average Inventory = (Opening Inventory + Closing Inventory) / 2
If a company has COGS of ₹120 crore and average inventory of ₹20 crore, inventory turns are:
₹120 crore / ₹20 crore = 6 turns
That means the firm sells through and replaces its average inventory six times during the year. But never say “6 is good” in isolation. It depends on the business: grocery should move faster than jewellery; spare parts may deliberately move slowly because availability matters more than speed.
2. Days of Supply - The Cover Metric
Days of supply converts inventory into time:
Days of Supply = Inventory on Hand / Average Daily Demand
If a plant uses 500 units per day and has 5,000 units available, days of supply is:
5,000 / 500 = 10 days
For financial analysis, the related measure is Days Inventory Outstanding:
DIO = Average Inventory / COGS × 365
Inventory turns and DIO are mirror images:
DIO = 365 / Inventory Turns
So, if turns are 6, DIO is about 61 days. This connects directly to Little's Law and reading a process mathematically: more inventory in the system usually means longer flow time, unless throughput rises too.
3. Cash-to-Cash Cycle - The Working Capital Metric
The cash-to-cash cycle measures how long cash is tied up between paying for inputs and collecting from customers.
Cash-to-Cash Cycle = DIO + DSO - DPO
- DIO - Days Inventory Outstanding: how long inventory sits before sale.
- DSO - Days Sales Outstanding: how long customers take to pay.
- DPO - Days Payable Outstanding: how long the firm takes to pay suppliers.
A company can have decent inventory turns and still suffer poor cash flow if customers pay late. Similarly, supplier credit can reduce the cash burden even when inventory is significant.
Definitions
- Inventory Turnover: COGS divided by average inventory; it shows how many times inventory is sold and replaced in a period.
- Days of Supply: inventory on hand divided by average daily demand; it estimates how long current stock can cover usage.
- DIO: average inventory divided by COGS, multiplied by 365; it measures average days inventory stays before sale.
- DSO: accounts receivable divided by credit sales, multiplied by 365; it measures average collection time.
- DPO: accounts payable divided by COGS or purchases, multiplied by 365; it measures average supplier payment time.
- Cash-to-Cash Cycle: DIO plus DSO minus DPO; it measures operating cash tied up in the business cycle.
Key Metrics to Track
In interviews, do not stop at formulas. State what each metric is trying to protect: speed, availability, cash or supplier health.
Worked Example - From Inventory Turns to Cash-to-Cash
Assume a retailer has the following annual numbers:
- COGS = ₹120 crore
- Average inventory = ₹20 crore
- Credit sales = ₹180 crore
- Average receivables = ₹15 crore
- Average payables = ₹30 crore
Step 1: Inventory Turns
Inventory Turns = ₹120 crore / ₹20 crore = 6 turns
Step 2: DIO
DIO = ₹20 crore / ₹120 crore × 365 = 60.8 days
Step 3: DSO
DSO = ₹15 crore / ₹180 crore × 365 = 30.4 days
Step 4: DPO
DPO = ₹30 crore / ₹120 crore × 365 = 91.3 days
Step 5: Cash-to-Cash
C2C = 60.8 + 30.4 - 91.3 = -0.1 days
This business is almost cash-neutral in its operating cycle: supplier credit roughly offsets the time cash is tied in inventory and receivables. The interview insight is not “negative C2C is always good”; it is good only if supplier terms are sustainable and service quality is not being sacrificed.
Case Study - DMart: Inventory Velocity as a Cash Engine
DMart, operated by Avenue Supermarts, shows how a value retailer can use focused assortment, high store throughput and supplier discipline to keep inventory moving in India's grocery-led retail market.
DMart's model is useful because it is not a glamorous “zero inventory” story. It is a disciplined retail operating model. The business sells food, FMCG and general merchandise through physical stores, as described on the DMart company profile. These categories demand availability, low prices and high stock movement.
Situation: Indian value retail is price-sensitive. Customers expect daily essentials to be available, but margins can be thin. Holding too much stock blocks cash; holding too little stock creates lost sales and weak store trust.
The move: DMart's inventory performance comes chiefly from high-velocity assortment discipline - focusing on products that sell repeatedly and quickly. Supporting drivers include store-level replenishment discipline, supplier relationships, everyday-value positioning, controlled operating costs and demand density in catchment areas. The point is not that one lever creates the result; the operating system reinforces inventory speed.
The lesson: Good inventory turns are not achieved by randomly cutting stock. They come from choosing the right assortment, replenishing reliably and matching inventory depth to real demand. For a deeper operating link, revise demand sensing, signals and point-of-sale data, because faster turns need better demand visibility.
So what: DMart demonstrates the correct interview answer: inventory velocity is not just a warehouse KPI. It is the result of business strategy, category choices, supplier economics and store execution working together.
How AI Changes Inventory Turns, Days of Supply & the Cash-to-Cash Cycle
AI makes this topic more dynamic because it shifts analysis from monthly reporting to near-real-time decision support.
- Demand sensing improves days of supply decisions. ML models can combine POS sales, promotions, local events, weather and seasonality to recommend different stock cover by SKU-location instead of one blanket rule.
- Replenishment becomes exception-based. AI can flag SKUs where days of supply looks safe on average but is risky because demand volatility or supplier lead time has changed.
- Cash-to-cash analysis becomes explainable. LLM-based finance tools can summarize whether C2C worsened because of inventory build-up, slower collections or changed supplier terms.
Use NotebookLM: upload a company's annual report and your notes, then ask, “Break down the company's cash-to-cash cycle into DIO, DSO and DPO drivers, and generate five interview questions on its working-capital risk.”
Interview Relevance
“A retailer has improved inventory turns from 4 to 6 and reduced days of supply. Is this definitely good? How would you evaluate the impact on the cash-to-cash cycle?”
If the interviewer gives only inventory turns, immediately ask for stockout rate, gross margin and supplier payment terms. That shows you understand operations and finance together.
Common Mistake
The mistake is saying “higher inventory turns are always better.” It costs candidates because it ignores stockouts, lost sales, emergency logistics, supplier strain and category differences. The one-line fix: higher turns are better only when service level, margin and supply reliability are protected.