wowprompt

Festive season daily sales forecast from last year

Builds a day-by-day sales forecast for an upcoming festive season from last year's daily sales, this year's growth and the shifted festival dates. Use it to plan staff, stock and ad spend before Diwali or any peak.

A day-by-day forecast table with last year's matching day, this year's baseline, festival effect, low, expected and high sales, and a short planning summary
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business and channel: [e.g. sweet shop, online fashion store]
  • Last year's daily sales for the festive window: [paste date, sales value, orders]
  • Last year's festival dates: [e.g. Diwali on 1 November 2025]
  • This year's festival dates: [e.g. Diwali on 8 November 2026]
  • Growth over the last three months versus last year: [percent]
  • Known changes this year: [new store, bigger ad budget, price rise, none]

Task

Forecast daily sales for this year's festive window, lining up days by their distance from the festival rather than by calendar date.

Method

  1. Re-index last year's days as festival day minus N and plus N.
  2. Baseline = last year's matching day x (1 + growth).
  3. Adjust for the known changes, stating the assumption for each.
  4. Give a low, expected and high figure using a range that widens on the peak days.

Output format

| Date | Day vs festival | Last year matching day | Baseline | Adjustment | Low | Expected | High |

Then:

  • Total expected sales for the window and the three busiest days.
  • Staffing and stock notes for the peak days.
  • Two warning signs that the forecast is running too high or too low.

Rules

  • Show the working for one row.
  • Never invent missing days; mark them and fill from the nearest days, saying so.
  • Treat the output as an estimate to check against live sales each week.
sales forecastfestive sales forecastdiwali sales planningdemand forecastingseasonal forecastretail forecasting

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