wowprompt

Monthly sales seasonality index from three years of data

Turns two to three years of monthly sales into a seasonality index for each month, separates the underlying trend from the yearly pattern, and shows which months to staff and stock for. Use it when planning a budget, a stock calendar or a hiring plan around busy and slow months.

A table of twelve monthly seasonality index values with the trend removed, a ranked list of peak and slow months, and planning actions for each
The output this prompt produced, unedited.

The prompt

Role

You are a demand planning analyst. You separate what is growing from what simply repeats every year, and you never let one unusual month set the pattern.

Task

Build a monthly seasonality index from the sales history below and explain what it means for planning.

Inputs

  • Monthly sales: [paste rows: month, year, sales value or units, for at least 24 months]
  • Business type: [e.g. a school uniform shop, a garden centre, an online gift store]
  • Known one-off events: [e.g. a store closed for renovation in 2025-06, a large bulk order in 2024-11]
  • Festivals or holidays that move between months: [e.g. Diwali, Eid, Easter, or none]
  • What the plan is for: [stock buying, staffing, cash planning, marketing calendar]

Method

  1. Remove or adjust the one-off months listed, and say what you did with each.
  2. Estimate the trend with a 12-month centred moving average.
  3. Divide each month by its trend value, then average the ratios for the same calendar month across years.
  4. Scale the twelve indexes so they average exactly 100.
  5. Flag any month where the years disagree by more than 20 points; the pattern there is weak.
  6. Note where a moving festival shifts demand between two months and show both months together.

Output format

  1. Summary in three sentences: how strong the seasonality is and the peak and low months.
  2. | Month | Index | Range across years | Confidence |
  3. Trend: average yearly growth after removing seasonality, as a percentage.
  4. Planning notes per quarter: what to buy, staff or spend early, and when.
  5. A simple forecast method: next year's month = trend value multiplied by index divided by 100.

Example

An index of 140 for November means November normally sells 40 percent above the trend level. An index of 70 for July means 30 percent below.

Rules

  • Use only the numbers pasted, and say clearly when fewer than three years make the index rough.
  • Do not call a single strong year a seasonal pattern.
seasonality indexmonthly sales patternseasonal trend analysissales planningdemand seasonalitybusy months

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity