Stock is money sitting on a shelf. Buy too little and customers walk away to a competitor; buy too much and your capital is locked up in goods that may never sell at full price. Every merchandiser lives inside this tension. The job is not simply to “have enough stock” but to hold the right depth of assortment while keeping a tight grip on the rupees invested in it. The good news is that this balancing act is measurable. A handful of well-understood metrics tell you exactly how your inventory is performing, what to buy, what to clear, and when to act. This post walks through the core stock objectives and the five numbers that make inventory control a science rather than a guessing game.
Table of Contents
- The dual objective behind every stock plan
- Five decisions for any item in stock
- Days of supply: predicting when you will run out
- Stock turn: how often you replace your inventory
- The trade-off between turn and margin
- Stock to sales ratio: spotting overstock early
- Sell-through percentage: built for seasonal goods
- Using sell-through to plan how much to buy
- Reading the metrics together
The dual objective behind every stock plan
The starting point for setting stock objectives is a simple but demanding goal: maintain a satisfactory assortment for customers while controlling the rupee value of inventory relative to sales. These two pulls work against each other. A wider, deeper assortment delights shoppers but ties up more capital. A leaner inventory frees up cash but risks empty shelves and lost sales. The merchandiser’s task is to find the point where both are satisfied at once.
Getting this balance wrong is expensive in both directions. Stockouts mean missed sales and customers who may not return. Overstocking means money trapped in slow-moving goods, plus the storage, handling, and markdown costs that follow. Retail inventory management is part art and part science, demanding an understanding of sales patterns, profit margins, and seasonality together.
Because of this, stock is not planned as one annual lump. It is planned month by month using BOM (Beginning of Month) and EOM (End of Month) stock levels. The EOM stock of one month becomes the BOM stock of the next, creating a continuous chain that runs through an entire season. In a typical six-month merchandise plan, the planner sets a target stock level at the start of each month to support that month’s forecast sales, then calculates how much to buy to reach it. This monthly rhythm is what keeps assortment and rupee investment aligned as demand rises and falls through the year.
Five decisions for any item in stock
Before reaching for formulas, it helps to know what those formulas are meant to support. For any single item sitting in inventory, a retailer is really choosing between just five actions:
Mark up: raise the price, usually when demand is strong and supply is tight.
Mark down: reduce the price to move stock that is selling slowly or nearing the end of its season.
Buy more: reorder because the item is selling faster than expected.
Buy less: cut future orders because demand is softer than planned.
Do nothing: leave the item alone because it is performing exactly as expected.
Every metric in this post exists to help answer which of these five to choose, and when. A toothpaste brand flying off the shelf signals “buy more.” A winter jacket still hanging in March signals “mark down.” Regular inventory performance analysis turns these decisions from gut calls into evidence-based ones. The four metrics below are the evidence.
Days of supply: predicting when you will run out
Days of supply answers a very practical question: how long will current stock last at the recent rate of sale? If you are selling roughly 10 units a day and you have 300 units on hand, you have about 30 days of supply. This metric is closely related to what accountants call days in inventory, which measures the average number of days funds stay tied up in stock before it sells.
The right time horizon depends on the product. For non-seasonal staples like toothpaste, soap, or packaged grains, a 30- to 60-day basis works well because demand is steady and predictable. For seasonal or fast-moving items like cold drinks in summer, a much shorter window makes sense, since selling rates swing sharply and an outdated average would mislead you.
The real value of days of supply is in managing lead times. Lead time is the gap between placing an order and receiving it. If a supplier takes 15 days to deliver and your fast-mover has only 12 days of supply left, you are heading for a stockout. Watching days of supply lets you trigger reorders early enough to avoid empty shelves without holding excess buffer stock. It is an everyday operational signal, not a year-end report.
Stock turn: how often you replace your inventory
Stock turn, also called inventory turnover or stockturn, measures how many times you sell and replace your average inventory over a period, usually a year. The basic formula is:
Stock turn = Annual sales / Average inventory
A stock turn of 3 means you sold through and replaced your average inventory three times during the year. As the standard definition notes, inventory turnover is calculated to see whether a business is carrying excessive stock compared to its sales level. A higher turn generally signals healthy demand and efficient use of capital, because the same rupees are being recycled into sales again and again rather than sitting idle.
What counts as a “good” turn varies enormously by category. A kirana store or supermarket selling daily essentials may turn its inventory many times a year, while a furniture or jewellery retailer turns far more slowly because shoppers buy those items infrequently. This is why turn should be benchmarked within your own category rather than against retail as a whole.
The trade-off between turn and margin
Increasing stock turn is not automatically good. One reliable way to push turn higher is to cut prices, the strategy Walmart built its empire on. Lower prices drive more volume, which lifts turnover and total sales. But each unit now earns a thinner margin. Sell faster at less profit per item, and you may end up no better off, or worse.
The merchandiser’s job is to find the balance point between turn and margin. A high-turn, low-margin model and a low-turn, high-margin model can both be profitable; the danger is drifting into a combination that maximises neither. Turn is a means to profit, not the goal itself.
Stock to sales ratio: spotting overstock early
The stock to sales ratio compares how much inventory you are holding against how much you are selling in a given period, usually a month. Expressed in units:
Stock to sales ratio = Average units of inventory available / Units sold
A ratio of 3 means you hold three units in stock for every one you sell in the period, roughly three months of supply at that rate. Unlike stock turn, which is best read over a season or year, the stock to sales ratio is a short-term planning tool used to set the right BOM stock for each month. If planned sales for a month are 1,000 units and your target ratio is 3.0, you plan to open the month with 3,000 units on hand.
The ratio is most useful as a warning light. If it rises while sales stay flat, you are accumulating stock faster than you are selling it, which is the classic signature of overstock eating into profitability. If the ratio falls while sales hold steady, you are using inventory more efficiently and freeing up capital. Because it is a clean, comparable number, it is also valuable for intra-industry comparison, letting a retailer judge its inventory health against peers selling similar goods.
Sell-through percentage: built for seasonal goods
Sell-through percentage flips the stock to sales ratio around. Instead of asking how much stock you hold per unit sold, it asks what share of available stock has actually sold:
Sell-through percentage = Units sold / Units of inventory available
It is the exact inverse of the stock to sales ratio. Where the stock to sales ratio rises as inventory piles up, sell-through falls; where sell-through climbs, you are clearing stock efficiently. As inventory specialists explain, sell-through percentage shows the rate at which inventory is consumed relative to sales, and is especially well suited to analysing performance and demand.
This metric earns its keep with seasonal merchandise. For a Diwali gift range, a summer cold-drink line, or a festive apparel collection, the goal is usually to be nearly out of stock by the end of the season. Carrying over seasonal goods means deep markdowns or dead inventory. By planning a target sell-through for each month of the season, a merchandiser can see early whether a line is on pace to clear. If a handbag range expected to fully sell by season end has only reached 40% sell-through at the halfway mark, that is an early signal to mark down or promote, not a problem to discover after the season closes.
Using sell-through to plan how much to buy
Sell-through also works in reverse to guide buying. If you believe you can sell 1,000 units of a seasonal item and you want to sell through 75% before resorting to markdowns, you can work backwards to decide how many units to order in the first place. This makes sell-through both a planning input at the start of a season and a performance check as it unfolds.
Reading the metrics together
No single number tells the whole story. Days of supply manages day-to-day reordering. Stock turn judges the efficiency of your capital over a season or year. The stock to sales ratio sets monthly stock targets and flags overstock. Sell-through keeps seasonal lines on track to clear. Used together, they answer the five core questions for every item: mark it up, mark it down, buy more, buy less, or leave it alone.
The thread connecting all of them is the original dual objective. Each metric is a different lens on the same balancing act between a satisfying assortment and disciplined rupee investment. Master them, and inventory stops being a source of trapped cash and missed sales, and becomes a lever you can actually control.
What do you think? If you were managing a seasonal product line, would you prioritise a high stock turn or a fat profit margin per unit, and why? And for a steady everyday item like packaged tea, which of these five metrics would you watch most closely to decide when to reorder?
References
- https://www.netsuite.com/portal/resource/articles/inventory-management/inventory-turnover-ratio.shtml
- https://www.fibre2fashion.com/industry-article/9354/six-months-buy-plan-for-fashion-merchandising
- https://en.wikipedia.org/wiki/Days_in_inventory
- https://en.wikipedia.org/wiki/Inventory_turnover
- https://courses.lumenlearning.com/wm-retailmanagement/chapter/determining-product-inventory-levels/
- https://www.management-one.com/retail-definitions-stock-to-sales-ratio
- https://parkeravery.com/industry-experience/inventory-planning-methods/
Leave a Reply