Inventory Metrics and the Cash-to-Cash Cycle
A supermarket can sell thousands of items every hour and still run short of cash if money is trapped on shelves for too long. The surprise is this: inventory is not just an operations problem - it is cash wearing a barcode.
- Cash-to-cash cycle measures how many days cash is tied up from paying suppliers to collecting from customers.
- Formula: Cash-to-cash cycle = Days Inventory Outstanding + Days Sales Outstanding - Days Payables Outstanding.
- Inventory turnover shows how many times inventory is sold and replaced in a period: COGS / average inventory.
- High inventory is not always bad if it protects service levels for critical SKUs; slow, obsolete inventory is the real enemy.
- Negative cash-to-cash is powerful when customers pay before suppliers are paid, but it must not come from squeezing suppliers unsustainably.
- The best interview answer links operations metrics to finance: stock availability, working capital, margins and supplier terms.
Big Picture: Inventory Is the Bridge Between Operations and Cash
Inventory metrics answer one practical question: how efficiently does the business convert stocked goods into collected cash? The cash-to-cash cycle connects three worlds that students often revise separately - inventory, receivables and payables.
Core Explanation: The Three Clocks Inside Cash-to-Cash
Think of the cash-to-cash cycle as three clocks running at the same time:
- Inventory clock: how long goods sit before sale.
- Customer clock: how long customers take to pay after sale.
- Supplier clock: how long the firm gets before paying suppliers.
The formula is simple, but the business meaning is powerful:
Cash-to-Cash Cycle = DIO + DSO - DPO
- DIO - Days Inventory Outstanding: days inventory stays before being sold.
- DSO - Days Sales Outstanding: days customers take to pay.
- DPO - Days Payables Outstanding: days the company takes to pay suppliers.
The Inventory Metrics Control Panel
Do not walk into an interview with only one metric. A good manager watches a small control panel because speed, availability and cash pressure must be balanced together.
The trap is to praise a high inventory turnover blindly. A pharmacy, quick-commerce dark store or spare-parts distributor may deliberately carry extra stock for critical items because the cost of a stockout is worse than the cost of holding inventory.
Worked Example: Calculating Cash-to-Cash in 90 Seconds
Assume a retailer has the following annual numbers:
Step 1 - Inventory turnover = ₹120 crore / ₹20 crore = 6 times.
Step 2 - DIO = 365 / 6 = about 61 days.
Step 3 - DSO = ₹6 crore / ₹180 crore × 365 = about 12 days.
Step 4 - DPO = ₹15 crore / ₹120 crore × 365 = about 46 days.
Step 5 - Cash-to-cash cycle = 61 + 12 - 46 = 27 days.
The business funds roughly 27 days of operating activity before cash comes back. To improve it, reduce slow stock, collect faster, or negotiate better supplier terms - but never destroy service levels just to make the number look good.
Diagnosing Inventory: Speed Versus Uncertainty
Inventory decisions become clearer when you classify SKUs by demand velocity and demand uncertainty. This prevents the common mistake of applying one policy to every product.
- Fast-moving, stable SKUs: use lean replenishment, smaller batches and frequent ordering.
- Fast-moving, uncertain SKUs: hold safety stock and monitor demand signals closely.
- Slow-moving, stable SKUs: order in controlled batches and avoid overstocking.
- Slow-moving, uncertain SKUs: challenge whether the SKU should exist, be made-to-order, or be rationalised.
If you want to go deeper into setting reorder points, safety stock and service levels, revise inventory policy for a multi-product business after this topic.
Definitions You Can Say in One Breath
- Inventory turnover: the number of times average inventory is sold and replaced during a period.
- DIO: the average number of days inventory remains before being sold.
- DSO: the average number of days taken to collect cash after a credit sale.
- DPO: the average number of days taken to pay suppliers.
- Cash-to-cash cycle: the days cash is tied up between paying suppliers and collecting from customers.
Case Study: DMart and the Discipline of Fast Cash Retailing
DMart shows how a retail model can use inventory velocity, disciplined assortment and supplier terms to support low prices and efficient cash conversion.
DMart is a useful Indian case because its working-capital strength does not come from one magic lever. The primary driver is high inventory velocity in essential, repeat-purchase categories. Supporting drivers include a focused assortment, value pricing, store-level execution, disciplined procurement and supplier relationships built around predictable volumes.
The strategic move is simple to describe but hard to execute: sell everyday products at sharp prices, keep stock moving, avoid excessive assortment complexity, and use scale and discipline to negotiate supply terms. This reduces the amount of cash trapped in inventory while keeping shelves relevant for shoppers.
Lesson: a strong cash-to-cash cycle is rarely just a finance achievement. It is created by assortment choices, store operations, supplier negotiations and replenishment discipline working together.
How AI Changes Inventory Metrics and the Cash-to-Cash Cycle
AI changes this topic by making inventory decisions more predictive, more granular and faster to simulate.
For a deeper AI-specific revision path, use AI for inventory optimisation and replenishment after you are comfortable with the formulas.
Load this lesson, a company annual report and its balance sheet notes into NotebookLM. Ask: “Identify inventory, receivables and payables risks, then generate five interview questions on the company’s cash-to-cash cycle.”
Interview Relevance
“A retail company has growing sales but worsening cash flow. How would you use inventory metrics and the cash-to-cash cycle to diagnose the problem?”
Use the phrase “I would not optimise C2C in isolation.” It signals maturity because you are balancing cash efficiency with service levels and supplier health.
Common Mistake
The biggest mistake is saying “higher inventory turnover is always better.” It costs candidates because it ignores stockouts, service levels, supplier lead times and demand uncertainty. Fix: always pair turnover or DIO with fill rate, stockout rate and SKU-level segmentation.