1
Using a single total for every pastry line
Record sales by product or category. A combined pastry total cannot show which item needs replenishment, which is frequently unavailable and which tends to remain unsold.
All Guides
Ordering Guide•4 min read
Forecasting Wholesale Pastry Orders from Sales Data
Turn past sales, stockouts and service changes into a more useful order plan.
A useful pastry forecast starts with what the venue actually sold, not what it hopes to sell. Item-level records help separate steady demand from a one-off event, promotion or unusual trading week.
Use the method below to inform an order, then adjust for lead time, carton quantities, freezer space and the service plan. It does not predict demand with certainty.
2
Treating one unusual week as normal
Note public holidays, events, menu changes and altered opening hours beside the sales record. Use comparable weeks where possible and treat atypical periods separately.
3
Forecasting sales without checking stock
Before ordering, count usable stock and check product dates and storage condition. The required order is based on expected need minus suitable stock already on hand.
4
Forgetting supply lead time and pack size
The supplier's ordering window and carton quantity affect when and how much to order. Confirm the current specification for each product rather than applying one pack assumption to the whole range.
The Professional Advantage
Use a rolling order worksheet
A simple worksheet makes assumptions visible and easier to update.
- Record sales and stockouts by item and service period.
- Mark events or trading changes that make a week unusual.
- Subtract suitable stock on hand from expected demand.
- Check lead time, carton quantity and freezer capacity before sending the order.
Questions about this guide? Use our contact form and we’ll respond within one business day.
Frequently Asked Questions
How much past sales data should I use?
Use enough comparable trading periods to understand normal variation, then review the forecast against actual sales. A venue with seasonal or event-driven demand should keep those periods separate.
Should stockouts be included in a pastry forecast?
Yes. A sold-out product may have had more demand than the recorded sales show. Note when it ran out and use that context when reviewing future orders.