What will our optimized plan deliver in December?
Welcome to the Sellforte MCP Use Case Library. Each post takes one question that marketing teams really ask their AI assistant through Sellforte MCP, which is now in general availability and accessible to all marketers worldwide. It strips out anything customer-specific and walks through what the assistant does with it, step by step. We run every question on our demo account so the numbers you see are illustrative, not anyone's real results. The idea is simple: steal the prompts, try them on your own model, and see what you get back. We hope you find this series inspiring!
-Juha, CEO at Sellforte
Turning an optimized media plan into a sales outlook
You've built an optimized media scenario, and now finance wants to know what it means for sales. Not ROI, not incremental sales per channel, just the number: what do we expect to sell in December, and how much of that is media? It's a common ask for marketing and finance leads who own the outlook, and the scenario already has the answer if you read it the right way.
What you ask
What does our optimized Q4 scenario forecast for total and media-driven sales in December 2026, and how does it compare with the same weeks last year?
How did the same scenario's forecast for October 2026 compare with what actually happened?
What Sellforte MCP does
First, the assistant lists your saved optimizer scenarios and picks the optimized one that covers the period. On our demo account, that's a flat-budget Q4 plan running from 2026-09-27 to 2027-01-09. It also tells you something easy to miss: the scenario was created before the latest model update, so its numbers come from the previous model. That's worth saying out loud before anyone quotes the forecast.
Next, it deals with the calendar. Optimizer plans run in whole weeks, so "December" becomes the four weeks starting 2026-11-29, 2026-12-06, 2026-12-13 and 2026-12-20. The assistant states that window rather than pretending it's an exact calendar month, and lines up the same four weeks of last year (starting 2025-11-30) for the comparison.
Then it reads the forecast split into base, promotion and media-driven sales and puts it next to last year's actuals:
| December, 4 weeks | Optimized forecast 2026 | Actual, same weeks 2025 | Change |
|---|---|---|---|
| Base sales | $7 174 143 | $7 431 756 | -3.5% |
| Promotion-driven sales | $3 691 367 | $2 817 732 | +31.0% |
| Media-driven sales | $5 292 867 | $6 320 435 | -16.3% |
| Weather effect | not in scenario | -$20 744 | |
| Total sales | $16 158 378 | $16 549 179 | -2.4% |
| Weekly average | $4 039 594 | $4 137 295 |
Illustrative demo data.
Total sales land close to last year, but the mix is different. Promotions do more work and media does less. The assistant explains the media part from the plan itself: the scenario holds media investment at $285 082 a week, $1 140 328 over the four weeks, while the same weeks last year had $1 615 161 of actual spend. Less money in, less media-driven sales out.
The follow-up is the reality check. October 2026 is already in the data, so the assistant compares the scenario's forecast for the four weeks starting 2026-10-04 with the actuals for the same weeks:
- Forecast total sales were $13 884 139; actual total sales were $13 181 202, about 5% lower.
- Base and promotion-driven sales came in above the forecast: $5 997 231 against $5 597 915 for base, and $3 242 259 against $2 939 419 for promotions.
- Media-driven sales were $4 031 540 against a forecast of $5 346 805, about 25% lower.
- Actual media spend was $938 733 against the plan's $1 140 328, about 18% less.
So the gap is mostly media, and part of it is simply that less was spent than the plan assumed. The assistant also points out what it can't separate: the scenario was built on the previous model, and the actuals include a small weather effect the scenario doesn't forecast. All figures are illustrative demo data.
Why it matters
An optimized scenario answers "what's the best allocation?". The forecast question is different: "what happens to sales if we follow it?". When you hand that number to finance, they need to know three things: which weeks it covers, which assumptions sit behind it, and how much depends on media at all.
The October check is the habit worth building. If a plan's forecast and the actuals drift apart, you want to know whether it was the market, the model or the fact that the plan wasn't followed. Here the spend gap explains a good part of it, which is a very different conversation from "the forecast was wrong".
If you don't have a suitable scenario yet, the assistant can propose the settings for one and create it once you've confirmed them.
Try these follow-ups
- Show the December forecast week by week, with base, promotion and media-driven sales as separate lines.
- Compare the optimized scenario's December forecast with the business-as-usual scenario for the same weeks.
- Which assumptions in this scenario affect the base and promotion forecast, and how were they set?
- How much of the October gap between forecast and actuals comes from each channel?
Related
- Sellforte MCP
- Sellforte Optimizer
- Media Planner Agent
- Ask Sellforte MCP: What does this saved Q4 plan really change?
- Ask Sellforte MCP: How should we split next year's media budget?
Try it yourself
Curious what your own plans forecast? Book a demo, or read how to connect Sellforte MCP to your LLM client. The Sellforte MCP launch post has the background.
We add new use cases to this library regularly.
You May Also Like
These Related Stories
