Planning Sales for Your Merchandise Plan: A Data-Driven Approach

Every successful retail season begins long before the first customer walks through the door. It starts with a number-a sales target for the period ahead. Getting that number right is one of the most important jobs in merchandising, because almost everything else flows from it: how much stock to order, how much money to commit, and how many staff to schedule. Plan too high and you sit on unsold inventory. Plan too low and you run out of goods just as demand peaks. This guide breaks down how retailers plan sales for the current period using a structured, data-backed approach rather than guesswork.

Why last year’s sales are the starting point 🔗

The single most reliable input for any sales plan is what actually happened last year during the same season. Past performance gives you a realistic baseline and a ready-made pattern of how demand rose and fell across the months. This technique sits within what forecasters call time series forecasting-a simple and inexpensive method that uses historical data to produce dependable estimates for the near future.

The logic is straightforward. If a category sold a certain amount last winter, that figure tells you what the market can absorb under normal conditions. You then adjust upward or downward based on what has changed. A merchandise planner for a category like swimwear, for instance, might decide to plan an increase over the prior year if the previous season fell short of its potential.

Using last year as the baseline does two things. First, it keeps your projection grounded-neither so high that the target becomes unachievable, nor so low that it fails to push the team. Second, it reveals the product composition within a category: which sizes, colours, price points, or sub-categories drove the bulk of sales. That mix is just as valuable as the total, because it tells you what to buy more of and what to scale back.

Reading the month-wise percentage breakup 🔗

Annual or seasonal totals are useful, but retailers actually operate month by month. So planners convert last year’s figures into a percentage breakup-what share of the season’s total sales each month contributed. Suppose October delivered 30% of an entire season’s sales. That percentage becomes a template you apply to the new, revised total for the coming year. Monthly estimates are widely considered the best operational basis for budgetary planning because they give far tighter control over the buying process than a single annual number ever could.

Internal factors that shift the plan 🔗

Last year’s baseline assumes the business stays roughly the same. In reality, retailers change things deliberately, and every change affects the plan. These are the internal factors-the variables within your own control.

Strategic and merchandise changes 🔗

Decisions about pricing directly move sales. Lowering prices may lift unit volume; raising them may lift value per transaction but reduce footfall in price-sensitive segments. Changes to product composition and the overall category mix-adding a premium line, dropping a slow segment, or introducing private labels-reshape what the category can earn. A planner has to estimate the net effect of each move before committing to a number.

Promotions, store experience, and expansion 🔗

Planned promotional schemes during the season are a major lever. A festive discount campaign or a bundling offer can pull sales forward and lift the total, so the plan must account for the timing and depth of each scheme. Improvements to the store environment-better ambience, new fixtures, sharper displays, and stronger sales training-also nudge conversion upward. These gains are harder to quantify, but experienced merchants build them in.

The most obvious internal factor is the number of stores. If a chain adds new outlets during the period, total sales will rise simply because there are more points of sale. A like-for-like comparison (same stores, same period) is needed to separate genuine growth from growth that merely comes from expansion.

External factors: the economy and the competition 🔗

No retailer operates in a vacuum. External forces-conditions you cannot control but must anticipate-can lift or sink even a well-built plan.

The economic environment 🔗

Broad economic conditions set the ceiling for consumer spending. A downturn, such as the global recession of 2008-2009, suppresses discretionary purchases across almost every category. A recovery does the opposite. To read these conditions, Indian planners lean on independent forecasts. The Centre for Monitoring Indian Economy (CMIE) publishes short- to medium-term projections drawn from time-series data covering hundreds of thousands of indicators on the Indian economy. The National Council of Applied Economic Research (NCAER) issues its own GDP and demand forecasts, often factoring in elements like monsoon performance, inflation, and rural demand.

Beyond these think tanks, research from the banking industry and studies from trade organisations help validate growth assumptions. Recent festive data shows how sharply the macro picture matters: industry surveys reported that India’s festive-season retail trade rose around 25% in one recent year, helped by lower GST rates that improved price competitiveness. A planner who ignored such signals would badly misjudge the season.

Competition, fashion, and substitutes 🔗

Competitor behaviour can rewrite your forecast overnight. If a rival floods the market with low-priced items, your volume assumptions may no longer hold. Fashion and trend shifts move demand within a category-what sold last year may look dated this year, especially in apparel and lifestyle goods.

Then there are substitutes: products from outside your category that quietly steal demand. The classic example is laptops eroding desktop computer sales. A desktop planner who watched only other desktop brands, and not the rise of laptops, would consistently overestimate. Good external analysis looks beyond the obvious rivals to the wider set of choices a customer actually has.

Calculating the growth target and applying the trend 🔗

Once the planner has weighed the internal and external factors, the analysis comes down to a single growth percentage. This is the adjustment factor-a blend of judgement, experience, and analytical skill applied to last year’s figure.

The calculation is simple in form. Suppose last season’s sales for a category were ₹2,00,000 and, after assessing all factors, the team targets a 20% increase. The projection for the current season becomes:

₹2,00,000 + (20% of ₹2,00,000) = ₹2,00,000 + ₹40,000 = ₹2,40,000

Now the month-wise percentages from last season come into play. If October historically delivered 30% of the seasonal total, you allocate 30% of the new ₹2,40,000 figure-₹72,000-to October. Repeat this for every month using last year’s percentage pattern, and you have a complete, month-by-month sales plan for the period. This is the bridge between a single growth number and an operational schedule the buying team can act on.

A quick worked structure 🔗

The flow works like this in practice. Start with last season’s actual sales. Apply the agreed growth percentage to get the new seasonal total. Then distribute that total across the months using each month’s historical share. The result respects both the scale of the business and its natural rhythm-peaks during festive months, troughs in quieter periods. Because Indian retail is heavily seasonal, this distribution step is what allows a business to stock up before the surge and manage cash through the slow months.

Revising the plan as actual sales come in 🔗

A sales plan is not a one-time document locked away at the start of the season. It is a living tool that must be revised as real numbers arrive. The whole point of monthly planning is to compare the plan against actual performance early enough to act.

Here is how the revision works. Imagine the plan expected certain sales in October and November, but actual sales came in lower-say, an average shortfall of 13.33% across those two months. That gap is a signal. It suggests demand is softer than assumed, perhaps because of weaker economic sentiment, an aggressive competitor, or a fashion miss. The merchandising team responds by lowering the projections for the months still ahead, such as December and January, by a comparable amount. If the early months had instead overshot the plan, the later months would be revised upward.

This continuous adjustment is what keeps inventory aligned with reality. Sales targets feed directly into purchasing decisions, so a revised sales plan immediately translates into revised orders. By catching a trend in October and November, the team can scale back or accelerate December buys before the stock is committed-avoiding both the dead weight of unsold goods and the lost revenue of empty shelves. Modern planners increasingly support this with predictive analytics that fold in fresh data like promotions and local events to refine guidance in near real time.

Why real-time revision matters most 🔗

The cost of ignoring early signals is steep. Inaccurate forecasts lead either to stockouts that send customers to competitors, or to excess inventory that eventually has to be cleared through profit-eroding markdowns. A disciplined revision cycle-plan, measure, adjust, reorder-turns the sales plan from a static prediction into an active control system. It is the difference between reacting to the season and steering through it.

What do you think? If your category’s early-month sales fell short by more than 13%, would you cut the rest of the season’s plan immediately, or wait to see whether a festive month could close the gap? And how would you weigh a confident economic forecast against a competitor’s surprise price cut when setting your growth target?

References

1. https://www.mbaknol.com/management-concepts/sales-planning-in-retail-merchandising/
2. https://courses.lumenlearning.com/wm-retailmanagement/chapter/forecasting-sales-numbers-for-merchandise-categories/
3. https://www.cmie.com/
4. https://www.business-standard.com/article/pti-stories/ncaer-predicts-economic-growth-at-7-5-this-fiscal-115082100751_1.html
5. https://www.newsonair.gov.in/indias-retail-sector-recorded-its-highest-ever-festive-season-sales-this-year-between-navratri-to-diwali-with-trade-touching-an-unprecedented-5-4-lakh-crore-rupees-in-goods-and-65-thousand-cr/
6. https://www.retaildogma.com/seasonality/
7. https://retalon.com/blog/retail-merchandise-planning