Seasonal Sales Index Calculator
Turn a month’s sales into a seasonal index against your monthly average, and project a target year across the same seasonal pattern.
How it works
Average month = annual sales ÷ 12 · Seasonal index = month sales ÷ average month × 100 · Projected month = target annual × (month share of annual)
A seasonal index restates a month’s sales relative to the average month, where 100 is exactly average. An index of 130 means the month runs 30% above the yearly norm; 70 means 30% below. Once you know each month’s index or share of the annual total, you can spread a new annual target across the year in a way that respects the seasonal pattern — far more realistic than assuming an even one-twelfth every month.
Worked example
A store with $480,000 in annual sales averages $40,000 a month. A month with $55,000 in sales has an index of 55,000 ÷ 40,000 × 100 = 138 and represents 11.5% of the year. Applied to a $540,000 target year, that same month would be projected at about $61,875.
Frequently asked questions
What does a seasonal index of 100 mean?
It means that month sells exactly at the average monthly level. Above 100 is a stronger-than-average month; below 100 is weaker. An index of 120 is 20% above average, 80 is 20% below.
How is a seasonal index useful for planning?
It lets you build realistic monthly budgets and staffing from an annual target, ordering more stock and labor for peak months and less for slow ones — instead of naively splitting the year into twelve equal months.
How many years of data do I need?
A single year gives a usable first pass, but averaging the index for each month across two or three years smooths out one-off events like a weather disruption or a large one-time order.
Related calculators
Educational estimate, not financial advice.