Planning Retail Stocks: Methods to Optimize Inventory Investment

Every rupee a retailer puts into stock is a rupee that cannot be spent on anything else. That single idea sits at the heart of merchandise planning. Stock sitting on the floor or in the backroom is money locked up, and the buyer’s job is to lock up exactly the right amount: enough to satisfy demand, but not so much that capital is wasted on goods that may end up on the markdown rack. Planning stocks on the floor is the discipline of deciding how much inventory, in value terms, should be available at the start and end of each month so that sales targets are met without tying up unnecessary cash. This post breaks down four established methods buyers use to make that decision.

Why stock planning is a working capital decision 🔗

Inventory is a current asset, and the funds parked in it form a large part of a retailer’s working capital. When too much stock is bought, three problems follow. The retailer is forced into markdowns to clear unsold goods, which directly erodes margins. New and fresher varieties cannot be introduced because the floor and the budget are already full. And the return on the money invested falls, because the same capital is generating fewer sales. Overstocking ties up capital in slow-moving or obsolete goods, raises storage and insurance costs, and increases the risk of products losing value before they sell.

To control this, the buying and merchandising team plans stock in value terms, not just in units. The two anchor figures are Beginning of Month (BOM) stock and End of Month (EOM) stock, calculated for every month of a season. A useful rule keeps the chain consistent: the EOM stock of one month becomes the BOM stock of the next month. Get these numbers right across a six-month plan, and the rest of the merchandise budget, including planned purchases, falls into place.

Stock turnover: the ratio behind every method 🔗

Before applying any planning method, a buyer needs to understand stock turnover, also called the sales-to-stock ratio. It measures the number of times average stock is sold and replaced within a given period.

How it is calculated 🔗

The formula is straightforward: Stock turnover = Net sales at retail ÷ Average stock value. If a category records net sales of Rs 50 lacs over six months and carries an average stock of Rs 25 lacs, the turnover is 2 for that period. A turnover of 6 over six months would mean the stock is fully sold roughly once every month. Healthy turnover ratios in retail generally range between 5 and 9, though the right figure depends heavily on the category.

Advantages of high turnover 🔗

A high turnover keeps investment in stock low because goods are converted into cash quickly. It reduces storage and insurance costs since less inventory sits idle. It also allows the buyer to refresh assortments faster, bringing in new styles while older ones are still selling well. Faster turnover means better cash flow, quicker returns on investment, and less money tied up in stock, which matters a great deal in a market where working capital is expensive.

The risks of pushing turnover too high 🔗

Chasing turnover blindly has a cost. Carrying very little stock raises the risk of stockouts, where a customer wants a product that is not on the shelf, leading to lost sales and possibly a lost customer. It also forces more frequent ordering, which increases administrative effort and ordering costs. The goal is balance, not the highest possible number. This is exactly why turnover feeds into the three planning methods that follow: each one translates a desired turnover into a concrete stock figure for each month.

Method 1: The basic stock method 🔗

The basic stock method suits retailers who must keep a minimum, or reserve, quantity of goods available at all times, regardless of how sales fluctuate. Think of staple items such as standard-size men’s white shirts or everyday denim, where a customer always expects to find their size. The basic stock is the constant cushion the retailer carries on top of the month’s expected sales.

The method works through two formulas. First, the basic stock itself: Basic Stock Value = Average Stock Value − Average Expected Monthly Sales. Then the opening stock for any month: BOM Stock = Sales for the Month + Basic Stock.

A worked example makes this concrete. Suppose a season’s sales are planned at Rs 50 lacs with a turnover ratio of 2. Average stock works out to Rs 50 lacs ÷ 2 = Rs 25 lacs. With six months in the season, average monthly sales are Rs 50 lacs ÷ 6 = Rs 8.33 lacs. The basic stock is therefore Rs 25 lacs − Rs 8.33 lacs = Rs 16.67 lacs. If March is expected to bring in Rs 8 lacs of sales, the BOM stock for March becomes Rs 8 lacs + Rs 16.67 lacs = Rs 24.67 lacs. The strength of this method is that it guarantees a base level of inventory is always present, which protects against stockouts and broken size ranges. It works best when turnover is relatively low or steady; when turnover is very high, the basic stock cushion can become unnecessarily large.

Method 2: The week’s supply method 🔗

Departmental stores and supermarkets often plan on a weekly rather than a monthly rhythm, and the week’s supply method fits that pattern. Instead of asking how much stock a month needs, it asks how many weeks of sales the retailer wants to have covered at any time.

The calculation begins by converting the desired annual turnover into weeks: Weeks’ supply = Number of weeks in the period ÷ Stock turnover required. For a target turnover of 6 per year, the weeks’ supply is 52 ÷ 6 = roughly 9 weeks. The stock value then follows: Average stock value = (Annual sales ÷ 52) × Weeks’ supply. So the retailer maintains enough stock to cover about nine weeks of average selling.

In practice, coverage varies by category. Indian large-format stores frequently hold closer to 12 weeks of coverage for apparel, because clothing comes in many styles, colours, and sizes that need to be available together for the assortment to look complete. A useful caution applies here: weeks of supply is based on past sales and shows where you have been, not where you are going. During festive peaks such as Diwali, when sales spike, a fixed weeks-supply figure can understate how much stock is really needed, so buyers adjust the coverage for the season.

Method 3: The stock to sales ratio 🔗

The stock to sales ratio is the quickest of the four methods and is widely used because it gives an instant read on coverage. It links the opening stock directly to the month’s planned sales.

The formula is: Stock to Sales Ratio = BOM Stock Value ÷ Sales for the Month. Rearranged, it lets a buyer plan next season’s opening stock from a known ratio: the stock-to-sales ratio for a month equals opening stock divided by planned sales for that month. A ratio of 1.6 means the retailer holds Rs 1.60 of stock at retail value for every Rs 1 of monthly sales.

Here is how it is applied. Suppose last season a category ran a stock to sales ratio of 1.6, holding Rs 16 lacs of BOM stock against Rs 10 lacs of monthly sales. If this season the same month is expected to sell Rs 15 lacs, the required BOM stock is 1.6 × Rs 15 lacs = Rs 24 lacs. The ratio also connects neatly to turnover: a higher turnover produces a lower stock to sales ratio, because faster-selling stock needs less coverage. The stock-to-sales ratio gives a planner a guideline of expected inventory turnover, which is why it remains a staple of monthly merchandise budgets.

Choosing the right method 🔗

No single method is correct for every situation. The basic stock method protects continuity for staple lines. The week’s supply method suits high-volume formats that replenish frequently. The stock to sales ratio offers speed and a clear link to turnover for monthly planning. Many retailers use a combination, applying different methods to different categories within the same store. What ties them together is the underlying goal: converting a desired stock turnover into a defensible BOM and EOM figure for each month, so that capital is neither starved nor wasted. Behind all of this sits the larger measure of efficiency, gross margin return on inventory investment, which tells the retailer how much profit each rupee of inventory actually earns.

What do you think? If you were planning stock for an apparel section heading into the festive season, which method would you trust most, and why? And where do you think the bigger danger lies for a retailer today: holding too much stock, or risking a stockout that sends a customer to a competitor?

References

1. https://www.kotak.bank.in/en/stories-in-focus/business/working-capital/working-capital-formula-and-ratio.html
2. https://weareprocarrier.com/news/article/inventory-turnover-ratio-what-it-is-and-how-to-improve
3. https://www.cottonworks.com/wp-content/uploads/2017/11/Part_4_4-1_1.pdf
4. https://www.tatacapital.com/blog/loan-for-business/working-capital-turnover-ratio/
5. https://plutuseducation.com/blog/inventory-turnover-ratio/
6. https://courses.lumenlearning.com/wm-retailmanagement/chapter/determining-product-inventory-levels/
7. https://www.fibre2fashion.com/industry-article/9354/six-months-buy-plan-for-fashion-merchandising
8. https://parkeravery.com/industry-experience/inventory-planning-methods/
9. https://en.wikipedia.org/wiki/Gross_margin_return_on_inventory_investment