Picture this: your spring asparagus special flies off the menu one week, then sits untouched the next. You're left with expensive ingredients going bad while your food costs spiral. Creating advance scenarios for best, realistic, and worst case sales helps you estimate orders and protect your margins.
Why scenario planning matters for seasonal items
Seasonal dishes operate on borrowed time. Order too little and you miss revenue opportunities. Order too much and you're tossing expensive ingredients - the kind of thing you only learn after closing your first month at a loss. The gap between profit and disaster often hinges on smart planning.
⚠️ Note:
Seasonal products cost more at season start and end. Build your scenarios week by week, not for the entire season.
Breaking down the three scenarios
Best case scenario: Stars align perfectly. Weather cooperates, marketing hits, guests can't get enough. You sell way more than expected.
Realistic scenario: Built from historical data and typical sales patterns. This becomes your ordering foundation.
Worst case scenario: Murphy's law strikes. Bad weather, fierce competition, fewer covers. Sales fall short of hopes.
Step 1: Mine your historical data
Dig into last year's numbers for the same timeframe. How many seasonal portions moved each week? Focus on these metrics:
- Weekly portion counts
- Peak and valley weeks
- Weather's impact on sales
- Waste from spoilage
💡 Example - Last year's asparagus dish:
6-week season, 80 portions weekly average:
- Week 1: 45 portions (slow launch)
- Weeks 2-4: 95 portions each (prime time)
- Week 5: 70 portions (winding down)
- Week 6: 35 portions (season finale)
Total: 480 portions across 6 weeks
Step 2: Set your scenario percentages
Use historical data as your 100% baseline, then create variations:
- Best case: 30% to 50% above baseline
- Realistic: Your historical average
- Worst case: 30% to 40% below baseline
💡 Example - Asparagus projections:
Baseline: 480 portions over 6 weeks
- Best case (+40%): 672 portions
- Realistic: 480 portions
- Worst case (-35%): 312 portions
Step 3: Calculate smart ordering amounts
For each scenario, work out ingredient needs. But here's the catch: never order for best case! That's financial suicide.
Smart ordering formula: Order 80% of realistic scenario + keep reorder capacity ready.
💡 Example - Order math:
Asparagus dish needs 200g per portion:
- Realistic scenario: 480 portions × 0.2kg = 96kg
- Smart initial order: 96kg × 0.8 = 77kg
- Hold back for reorders: 19kg worth
Set weekly reorder triggers if sales exceed expectations.
Step 4: Map out margin impacts
Each scenario hits your bottom line differently. Calculate potential profits and losses for each case.
💡 Example - Profit projections:
Asparagus dish: €24.00 price, €8.50 cost, €15.50 margin each
- Best case: 672 × €15.50 = €10,416 margin
- Realistic: 480 × €15.50 = €7,440 margin
- Worst case: 312 × €15.50 = €4,836 margin
Gap between best and worst: €5,580 swing!
Step 5: Build your reorder strategy
Don't wait and hope - plan your reorder triggers now. Seasonal suppliers often need longer lead times, so timing matters.
- Week 1: Check sales velocity after 3 days
- 20% above projections: trigger week 2 reorder
- 50% above projections: shift to best case mode
Tools for scenario planning
Excel works but gets messy fast with multiple seasonal items. Tools like KitchenNmbrs help you model different scenarios quickly and track food costs as supplier prices shift throughout the season.
How do you create seasonal scenarios? (step by step)
Analyze last year
Find out how many seasonal dishes you sold per week last year. Also count how much you had to throw away due to spoilage. This becomes your realistic scenario.
Define three scenarios
Create a best case (+40%), realistic (last year), and worst case (-35%) scenario. Calculate for each scenario how many portions you expect to sell.
Calculate orders and margin
Calculate how many ingredients you need per scenario and what each scenario yields in margin. Order for 80% of your realistic scenario with the possibility to reorder.
✨ Pro tip
Track your seasonal dish performance by week, not just overall season. Plan reorders every 4-5 days during peak weeks to capture maximum sales without overcommitting to inventory.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
Should I order for my best case scenario?
Never order for best case - that's too risky. Order 80% of your realistic scenario and plan weekly reorders if sales take off. This prevents getting stuck with expensive perishables.
What if I don't have historical data?
Study similar dishes you've run before for patterns. Start conservative with small quantities and reorder weekly based on actual sales. Better to sell out than throw out expensive seasonal ingredients.
How do I calculate the financial impact of each scenario?
Multiply expected portions per scenario by your margin per portion. The difference between best and worst case shows your potential profit swing for that seasonal dish.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Purchase smarter with real-time insights
Seasonal prices fluctuate — so do your recipe costs. KitchenNmbrs automatically recalculates your margins when purchase prices change. Never get surprised again. Start free.
Start free trial →