Seasonal demand calculator

Black Friday and Q4 concentrate a huge share of annual retail revenue. If you plan with the monthly average, you finance it with debt.

  • Instant result
  • No sign-up
  • Visible assumptions
  • Deterministic calculation

In 30 seconds: Model 12 months with seasonal factors by category and get monthly forecasts, peak and valley months, and the purchase and staffing plan that sustains each one. Deterministic calculation with auditable formulas. The result is indicative — adjust the assumptions to reflect your real operation.

Methodology

Projected demand for month = Base demand × Month's seasonal factor

Month gap = Projected demand − Capacity

Gap % = (Gap ÷ Capacity) × 100

Peak/trough = month with highest/lowest projected demand of the year

Peak/trough ratio = Peak demand ÷ Trough demand (seasonal intensity)

Variables

Monthly Base Demand
Average monthly demand without seasonal effect (the 'mean line' of the year).
Seasonal Factors (12)
Monthly multipliers (1.0 = neutral, 1.5 = 50% above, 0.7 = 30% below).
Base Capacity
Units you can produce/sell per month with your current operational capacity.
Lead Time (weeks)
How many weeks you need to adjust capacity (hire, expand inventory, install).
Average Price
Price per unit to estimate monthly and annual revenue potential.

Practical example

A clothing store has base demand of 2,000 units/month and capacity of 2,200 units/month. Its seasonal factors are high in June (1.3), November (1.8) and December (1.5).

Projected June = 2,000 × 1.3 = 2,600 units → gap +400 units (18% over capacity).

Projected November = 2,000 × 1.8 = 3,600 units → gap +1,400 units (64% over).

Projected December = 2,000 × 1.5 = 3,000 units → gap +800 units.

With a 6-week lead time to adjust capacity, they must start scaling staff/inventory in September to absorb the November peak.

Trough month: February (0.7 factor) → 1,400 units, plenty of spare capacity → ideal window for maintenance or rotating vacation.

Interpretation

A peak/trough ratio above 2.0 indicates a highly seasonal business: it needs explicit capacity and cash planning to survive the trough.

A large positive peak gap = lost sales if you don't scale capacity. Every unit you can't produce is lost contribution.

A large negative trough gap = idle capacity (payroll burning cash without revenue). The time for maintenance, training or vacation.

Recommended start month to adjust = peak month − lead time. If the peak is November and lead time is 8 weeks, decide in September.

Fixed capacity that only covers average demand will leave money on the table at peaks. Peak-sized capacity creates expensive idleness at troughs. The usual answer is hybrid capacity (base + temporary flex).

Assumptions and limitations

  • Assumes historical seasonal factors repeat — valid for businesses with years of history, risky for new products.
  • Does not incorporate trend (year-over-year growth or decline) — for that, multiply base demand by the expected trend factor.
  • Assumes capacity scales linearly — in reality expanding staff/equipment comes in discrete steps.
  • Does not model the queue: if the peak catches you understocked, some demand can be absorbed the following month, not lost entirely.

When to use this calculator

  • To plan temporary staffing: how many extra employees you need in high season and when to start hiring.

  • To negotiate inventory contracts: show your supplier the demand calendar to get better terms in peak months.

  • Before investing in a permanent capacity expansion: if there are only 2 peak months a year, permanent expansion may not pay for the idleness of the other 10.

  • To plan annual cash flow: low-demand months are also low-cash months — you need reserves or a credit line.

  • When introducing a product in a new category: start with factors from a known analog and recalibrate each quarter with real data.

Common mistakes

  • Confusing seasonal factor with trend. If your sales grow 30% year over year, seasonal factors must be calculated on the de-seasonalized year, not on absolute figures.

  • Taking 1 year of data as reference. At least 3 years so that an atypical event (pandemic, local crisis) doesn't distort the factors.

  • Assuming zero lead time: the decision to expand capacity must be made weeks before the demand hits, not when it's already there.

  • Ignoring the cascade effect: if you subcontract inventory for the December peak, you also need logistics and post-sale capacity in January.

Industry use cases

Fashion retail

Typical peaks: Black Friday, December, back-to-school, Mother's Day. Peak/trough ratio 2.5-4×. Inventory decisions 4-6 months ahead.

Tourism and lodging

Peaks during school holidays and local seasons. Peak/trough ratio 3-5×. Temporary staffing and dynamic pricing are the main levers.

Restaurants

Weekly seasonality (weekends) more than monthly, but there are peaks at December, Father's/Mother's Day, Valentine's Day. Human capacity is the critical lever.

E-commerce

Synthetic peaks created by promotions (Hot Sale, Black Friday, Cyber Monday) on top of natural ones. Factors must be recalibrated each year as dates shift.

Accounting / tax services

Extreme peaks at fiscal year-end (March-April in Mexico) and monthly filings. Peak/trough ratio can exceed 5×. Specialized temporary capacity is a priority.

Methodology and assumptions

How results are calculated, what we assume when modeling, and where the method loses precision.

Formula

Demand(t) = Trend(t) × Seasonal index(t) · Cash peak ≈ Demand × Variable cost × Lead time

Assumptions

  • Seasonal index inferred from the monthly volumes you enter.
  • Trend treated as flat within the year (no organic growth).
  • Variable cost stable across the cycle.

Applicability limits

  • With less than 24 months of history the seasonal index is approximate.
  • Structural changes (new channels, geographic expansion) invalidate the previous index.
  • Does not replace a regression / Holt-Winters forecast when the trend is strong.

Sources

Related calculators

Break-Even Point

How much you need to sell to cover costs

VAT Calculator

Add or remove VAT from any amount

Profit Margin

Calculate your gross and net margin

ROI

Return on your investment

ROAS & ad break-even

Calculate your break-even ROAS and check whether your ad campaign is profitable.

Quick Cash Flow

Calculate revenue minus expenses in seconds

Freelance hourly rate

Work out what to charge per hour to reach the income you want after costs and taxes.

LTV and Churn

LTV, LTV:CAC ratio and SaaS payback

Cohort Retention

Cohort decay and cumulative revenue

CAC and Payback

CAC, payback and SaaS Magic Number

EOQ and Reorder Point

Economic order quantity and safety stock

Occupancy Break-Even

Minimum occupancy to cover costs

Interés Compuesto

Proyecta cuánto crece tu dinero con aportaciones periódicas e interés compuesto.

You projected your seasonal demand. Now simulate how it impacts your cash during peak and trough months. Advanced Cash Flow Simulator →

Want to go beyond the quick calculation?

The advanced simulators model complete scenarios — 12-month cash flow, pricing with sensitivity analysis, credit risk, delivery routes — with your own data and no sign-up.

Explore the simulators

Calculator guide

What it calculates and who it is for

This calculator projects your demand month by month from a base demand and twelve seasonal factors, then crosses it against your capacity to flag the months you'll fall short, the months you'll carry excess structure, and when you must start preparing given your lead time.

It is built for retailers, manufacturers and operators with marked seasonality — gifting, fashion, weather, school calendar — who plan the year on the monthly average and discover the peaks when there is no time left to react.

Inputs

Base monthly demand
Units in a 'normal' month, without seasonal effect: your average of quiet months, not the annual average.
Seasonal factors (12)
One multiplier per month: 1.0 is a normal month, 1.3 a month 30% above, 0.8 one 20% below. Derive them from historic sales by dividing each month by your typical month.
Base capacity
The units you can produce, store or dispatch per month with your current structure.
Lead time (weeks)
The weeks it takes to add capacity or receive extra inventory: production, importing, hiring.
Price per unit
Used to translate the unit projection into estimated annual revenue.

Results you get

Monthly projection
Each month's expected demand (base × factor, normalized) against your capacity, with the gap in units and percent.
Peak and trough months
The months of highest and lowest projected demand, with their volumes.
Peak-to-trough ratio
How many times the highest month exceeds the lowest: the measure of how seasonal your business is.
Month to start adjusting
The month you must trigger peak preparation, stepping your lead time back from the peak month.
Monthly recommendation
An operational label per month based on the gap's size and sign: expand capacity, optimize shifts, base operations, reduce capacity or rotate vacations.
Estimated annual revenue
The twelve months' projected demand priced at the per-unit price.

Methodology and assumptions

Month demand = Base demand × Month factor (normalized over the 12 factors' average)

Month gap = Projected demand − Capacity

Gap % = Gap ÷ Capacity × 100

Adjustment month = Peak month − Lead time (in months, rounded up)

Annual revenue = Σ Monthly demand × Price

Factors are normalized over their own average, so the annual total depends on base demand rather than the factors' arbitrary scale: you can enter them as indexes (1.2) or relative percentages without breaking the total.

The monthly recommendation is assigned by thresholds on the percentage gap: large positive gaps call for expanding capacity, moderate positive ones for optimizing shifts, and large negative gaps suggest reducing structure or rotating vacations and maintenance into the troughs.

Worked example

Hypothetical example for illustration. The numbers reproduce exactly when entered into the calculator on this page.

Worked example: base demand of 2,000 units, factors [0.8, 0.8, 0.9, 1.0, 1.1, 1.2, 1.3, 1.3, 1.1, 1.0, 1.1, 1.4] from January to December, 2,400 units of monthly capacity, a 6-week lead time and a $250 price.

Peak month: December, with 2,585 projected units — 185 units (7.7%) above capacity.

Trough month: January, with 1,477 units — 38.5% below installed capacity.

Peak-to-trough ratio: 1.75 — this business's December moves 75% more volume than its January.

Adjustment month: October. With a 6-week lead time, preparation for the December peak must trigger no later than that month.

Estimated annual revenue: $6,000,000. The monthly recommendations mark the January-February troughs for structure reduction or vacation rotation, and flag December's overflow to be solved with shifts, early inventory or temporary capacity.

How to interpret the result

The percentage gap is the operational number: a peak 7.7% above capacity, like the example's, is solved with overtime or early inventory; a 40% one demands external capacity or giving up sales. Size the response to the gap, not to peak anxiety.

The adjustment month is the most valuable alarm: the typical failure is not ignoring the peak but starting late. If your real lead time is longer than entered — imports with customs, hiring with training — the adjustment month moves earlier in proportion.

Troughs are a decision, not a fate: the same projection that shows January's excess capacity tells you how much structure you can switch off, rotate or dedicate to maintenance without risking service.

Limitations and when not to use it

  • The result's quality depends on your seasonal factors: derived from a single year of history, they blend true seasonality with one-off events. Use two or three averaged years when available.
  • It models seasonality as a fixed monthly pattern: it does not capture growth trends, one-off promotions or moving dates that change month across years.
  • Capacity is treated as constant: if you already have expansions scheduled, run the scenario with and without them.
  • It is not a statistical forecast: it computes no confidence intervals and does not adjust for historic error. It is a capacity-planning tool, not advanced forecasting.
  • Do not use it for unit-level inventory purchasing: reorder point and order size belong to the EOQ and ROP calculator, which can be fed with the monthly demand projected here.

From theory to calculation

The calculator on this page runs with your numbers — no forms, no login. Scroll up and try it.

Try the calculator

Frequently asked questions

1Where do I get my seasonal factors?
From your sales history: divide each month's units by your typical month's (or by the monthly average). If your history has a month distorted by a one-off event — an aggressive promotion, a stockout — correct it before using it as a factor.
2What if my business is new and has no history?
Start from qualitative factors: identify your expected strong and weak months and assign conservative indexes (1.2, 0.9). The projection becomes a working hypothesis you refine monthly with real data.
3Why doesn't the adjustment month match the peak month?
Because capacity doesn't switch on instantly: the engine steps your lead time back from the peak. With a 6-week lead time and a December peak, triggering in October is on time; triggering in November is late.
4How do I read a month with a small positive gap?
As a peak manageable with current structure: overtime, optimized shifts or early inventory usually suffice. The month's recommendation label reflects exactly that severity level.
5Does it work for services without inventory?
Yes: 'capacity' can be appointments, rooms or available staff per month. The gap logic and the adjustment month apply the same — lead time is then hiring and training time.

Last updated: July 19, 2026

View methodology