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

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?

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

References
  1. https://www.netsuite.com/portal/resource/articles/inventory-management/inventory-turnover-ratio.shtml
  2. https://www.fibre2fashion.com/industry-article/9354/six-months-buy-plan-for-fashion-merchandising
  3. https://en.wikipedia.org/wiki/Days_in_inventory
  4. https://en.wikipedia.org/wiki/Inventory_turnover
  5. https://courses.lumenlearning.com/wm-retailmanagement/chapter/determining-product-inventory-levels/
  6. https://www.management-one.com/retail-definitions-stock-to-sales-ratio
  7. https://parkeravery.com/industry-experience/inventory-planning-methods/

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Buying and Merchandising – I

1 Introduction to Buying and Merchandising

  1. Merchandise Management
  2. Principles of Merchandising
  3. Merchandise Planning Process
  4. Merchandising Strategy
  5. Merchandise Mix

2 Merchandise Management

  1. Buying and Merchandise Management
  2. Planning Merchandise Assortments
  3. Buying System
  4. The Buying Organisation
  5. Brand Management
  6. Buying Principles

3 Organizing Buying Process by Categories

  1. Category Management
  2. Partnering Group
  3. Category Captain
  4. Buying Merchandise through Open to Buy
  5. Fashion and Seasonal Merchandise versus Basic In-Stock Items
  6. Budget Planning
  7. Groceries Store/Staple products

4 Sales Forecasting

  1. Importance of Sales Forecasting
  2. Factors Affecting Sales Forecasting
  3. Sources and Magnitude of Consumer Demands
  4. Methods of Sales Forecasting
  5. Category Life Cycle
  6. Do’s and Don’ts in Sales Forecasting
  7. Annual Budgeting

5 Merchandise Objectives

  1. Merchandise Planning Components
  2. Setting Sales Objectives
  3. Setting Stock Objectives
  4. Setting Margin Objective

6 Pricing

  1. Importance of Pricing
  2. Factors Affecting Retail Pricing
  3. Break-Even Pricing and Mark-Up Pricing
  4. Nine Laws of Price Sensitivity
  5. Pricing Methods
  6. Reductions

7 Assortment Planning

  1. Necessity and Guidelines for Planning
  2. Assortment Planning
  3. Factors Influencing Assortment Planning
  4. Commercial Factors in Assortment Planning
  5. Process Overview
  6. Assortment Width Planning

8 Vendor Selection Process

  1. Vendor Selection Process
  2. Factors Influencing Vendor Selection
  3. Steps in Vendor Selection
  4. Phases for Selection of Vendor
  5. Vendor Evaluation Parameters

9 Retail Mathematics for Buying and Merchandising

  1. Practice of Retail Financial Management
  2. Terms Used for Retail Buying and Merchandising
  3. Vendor Negotiations
  4. In Store Merchandise Loss
  5. Financial while Buying for Retail
  6. Financial while Buying for Merchandising
  7. Financial while Pricing for Merchandising
  8. Retail Pricing Strategies

10 Retail Mathematics for Performance Analysis

  1. Inventory
  2. Turn Returns into Sales
  3. Financial for Store Operation and Performance
  4. Break Even Analysis
  5. GMROI
  6. Profit and Loss Account

11 Brand V/S Private Label

  1. Concept of Brand
  2. Global Brand
  3. Local Brand
  4. Ambient Brand
  5. Brand Name
  6. Brand Identity
  7. Brand Extension & Brand Dilution
  8. Multi-Brands
  9. Private Labels
  10. Branding By ITC a Case Study