Skip to content

Sales Forecast Narrative for S&OP

Turn your sales forecast numbers into the narrative your S&OP meeting needs.

What is the Sales Forecast Narrative for S&OP?

The Sales Forecast Narrative for S&OP is a free AI skill that turns a sales team's raw forecast numbers into the written narrative a Sales & Operations Planning meeting needs. You give it your forecast by SKU or category, the period, what changed since the last submission, and known risks; it returns a narrative on what is driving the number up or down, which assumptions the forecast depends on, a confidence read by SKU or segment, the supply and inventory risks operations should plan around, and a specific ask for manufacturing, supply planning, or finance. It is built for sales and demand-planning teams who submit a spreadsheet every cycle but watch it get questioned because nobody explained the story behind the numbers. Because it forces every material change to name a driver and a confidence level, the forecast survives cross-functional scrutiny instead of reading as a guess. Grounding the demand drivers in live food and beverage trend data helps separate a real shift in demand from ordinary forecast noise.

Who it's for

  • Sales leaders submitting a forecast into a monthly S&OP cycle
  • Key-account managers explaining a forecast change for their accounts
  • Demand planners translating sales input into a supply-ready narrative
  • Sales operations analysts preparing the S&OP deck for leadership

What you get

  • A narrative explaining what's driving the forecast up or down
  • The key assumptions the forecast depends on, stated explicitly
  • A confidence level by SKU, account, or segment
  • Supply and inventory risks operations should plan around
  • A specific ask for manufacturing, supply planning, or finance
  • A one-paragraph executive summary for the S&OP deck

How to use it

  1. 1Paste the prompt into ChatGPT, Claude or Gemini.
  2. 2Fill in the bracketed inputs (forecast numbers, period, changes, risks).
  3. 3Answer its clarifying questions about what's driving the biggest swings.
  4. 4Ask it to shorten the narrative into speaking notes for the S&OP meeting.

See it in action

Example input

Forecast: fictional 'Halden Creamery' oat-based ice cream, Q3 forecast is up 22% versus our last submission, driven mostly by one SKU (Salted Caramel Pint) after a strong summer promo period at a major grocery chain. Risk: our co-packer has a capacity ceiling we're not sure we can hit if all 3 flavors grow at the forecasted rate. We need supply planning to flag capacity constraints before this forecast gets finalized.

Example output

S&OP forecast narrative — Halden Creamery oat-based ice cream, Q3

Executive summary:
Q3 forecast is up 22% versus our last submission, concentrated almost entirely in one SKU — Salted Caramel Pint — following strong sell-through from a summer promotion at [insert retailer name]. The other two flavors are forecasted roughly flat. Before this number gets finalized, we need supply planning to confirm our co-packer can support the Salted Caramel volume; the growth is real, but capacity is the open question, not demand.

What's driving the number:
Salted Caramel Pint drove a promo-supported sell-through lift at [insert retailer] through July and August that materially outperformed our original forecast assumption. [Insert actual sell-through or scan-data lift percentage if available.] The other two flavors, Vanilla Bean and Coffee Toffee, are tracking close to our prior forecast with no material driver to call out this cycle.

Key assumptions this forecast depends on:
1. The Salted Caramel lift observed during the promo period continues at a similar rate once the promotion ends in September — this is the single biggest assumption in the number, and it is not yet confirmed. Treat the post-promo run-rate as an assumption to validate against the first few weeks of September scan data.
2. No incremental distribution gains or losses at any other retailer during Q3 beyond what's already confirmed.
3. No new competitive launch in the oat-based ice cream set during the quarter that would pressure our share. Flag if you're aware of one.

Confidence by SKU:
- Salted Caramel Pint: moderate confidence on direction (up), low confidence on magnitude — the post-promo run-rate is the open variable.
- Vanilla Bean: high confidence — stable, well-established demand pattern.
- Coffee Toffee: high confidence — stable, tracking close to prior forecast.

Supply and inventory risks operations should plan around:
Our co-packer has a stated capacity ceiling [insert actual units/week or cases/month ceiling], and if all three flavors grow at the forecasted rate simultaneously, combined volume may approach or exceed that ceiling in peak weeks. This is the single most important flag for this S&OP cycle: the demand forecast may be real, but production capacity — not shopper demand — could become the actual constraint on Q3 sales.

Our ask:
1. Supply planning: confirm co-packer capacity against the combined SKU forecast before we finalize Q3 numbers, and flag which weeks are highest-risk for a ceiling breach.
2. Manufacturing: if a ceiling breach is likely, tell us now whether prioritizing Salted Caramel production over the other two flavors is feasible, since that SKU is carrying the growth.
3. Finance: model the downside case where Salted Caramel's post-promo demand reverts closer to our original, lower forecast, so we have a range, not a single point estimate, going into the meeting.

Bottom line for the room:
This is a good problem — real, promo-driven demand growth on one SKU — but it needs a capacity answer before we commit a 22%-higher number company-wide. Recommend the S&OP meeting treat Q3 as a range (base case: prior forecast +10-15%; upside case: +22% if capacity and post-promo demand both hold) rather than a single confirmed number, until supply planning responds.

Want this trimmed into 90 seconds of speaking notes for the S&OP meeting itself?

The prompt

Here's the start of the prompt. Download the free bundle for the full, ready-to-paste version — plus the installable Claude Skill and Custom-GPT instructions.

# Role
You are a CPG sales operations lead who translates sales forecasts into the narrative an S&OP meeting needs. You explain drivers and assumptions, not just numbers, and you flag supply risk before it becomes a surprise in the room.

# Context I'll provide
- Forecast numbers: [FORECAST BY SKU/CATEGORY, PERIOD, VS. PRIOR FORECAST]
- What changed versus the last forecast: [DRIVERS OF THE CHANGE]
- Known supply or capacity risks: [RISKS e.g. co-packer capacity, ingredient supply]
- The audience and meeting cadence: [AUDIENCE e.g. monthly S&OP, leadership review]
- Specific asks you already know you need (optional): [ASKS]

# Your task
1. If the forecast numbers, drivers, or audience are missing or vague, ask up to 3 clarifying questions BEFORE writing anything.

Frequently asked questions

What is a sales forecast narrative for S&OP?
It's the written explanation that accompanies a sales forecast into a Sales & Operations Planning meeting — what's driving each number up or down, which assumptions it depends on, and the supply or capacity risks operations should plan around. A spreadsheet alone invites questions nobody in the room can answer; this skill builds the narrative that answers them before they're asked.
How is this different from the Category Review Analyst skill?
The Category Review Analyst builds a category performance story for an external, buyer-facing audience — framed around a retailer's growth for a line review or planning session. This skill is internal: it turns your own sales forecast into the cross-functional narrative a monthly S&OP meeting needs, aimed at supply planning, manufacturing, and finance rather than a retail buyer. Use the category review for the retailer conversation, and this skill for the internal planning cycle.
Which AI models can run this prompt?
Any capable chat model — ChatGPT, Claude, or Google Gemini. The prompt is model-agnostic, so paste your forecast into a chat each cycle, save the prompt as a Custom GPT, or store it as a reusable skill so every S&OP submission follows the same driver-and-assumption discipline regardless of who on the sales team is submitting it.
What if I'm not sure what's driving a forecast change yet?
Say so — the skill will flag that driver as unconfirmed rather than inventing a plausible-sounding explanation, and it will list it among the assumptions to validate before the meeting. A forecast narrative that honestly says 'we don't yet know why this moved' is more useful to supply planning than a confident-sounding guess, because it tells operations exactly where the real risk sits.

Related skills

Want the live data behind sharper outputs?

These skills get better with real-time F&B intelligence. See what Tastewise can do for your team.