Approach · 22 November 2026 · Martijn van Grieken

Forecasting demand you cannot see

A sold-out day hides how many customers still came. Why average sales underestimate demand, and what you know with little history.

Lichte voorraadruimte in een ziekenhuis met witte stellingen en een voorraadscherm

A supermarket that orders fresh bread every day sees at the end of the day how much has been sold. On a day when the shelf was empty at four o’clock, it does not see how many customers came after that. That day’s sales are a lower bound on demand. Anyone forecasting from sales figures is therefore working with a number that is too low, and the figures themselves do not show it.

This page describes how we forecast demand when part of it is invisible.

Average sales are too low

Day Ordered Sold Demand
Monday 20 15 15
Tuesday 20 20 (sold out) 23
Wednesday 20 17 17
Thursday 20 20 (sold out) 26
Friday 20 20 (sold out) 24
Saturday 20 20 (sold out) 28
Sunday 20 13 13
Average per day 20 17.9 20.9

Illustrative calculation. In reality you do not know the last column.

On four of the seven days the product sold out. Average sales are 17.9 a day, actual demand 20.9. Anyone who bases the order on sales will order less than now. The shelf then runs empty more often, sales fall further, and demand looks even lower the following week.

A sold-out day does provide information. You know that demand was at least as large as what you had in stock. A model that links demand, sales and order quantity uses that information instead of throwing it away.

With little history, you give a range

Per product per shop there is often little usable history. On a few weeks of data you cannot estimate Saturday’s demand to the nearest loaf. A statement such as ‘probably between 22 and 32’ is more accurate than ‘27’, and you can do more with it.

The range makes the ordering decision visible. If a missed loaf costs you more than a discarded loaf, you order in the upper part of the range. If waste is more expensive, you order lower. That is the shop’s choice. The model shows what that choice costs.

Beyond the supermarket

The principle applies wherever you only see what was supplied. A possible application in healthcare: if a ward runs out of a consumable, it borrows from another ward or uses an alternative. The consumption records then show less than was needed. In industry the same can happen with spare parts: if a part is out of stock, the customer sometimes orders elsewhere and the demand appears nowhere. We have not yet applied this approach in healthcare or industry. How we approach a planning question in healthcare is described in Smarter rostering in care.

How we approach it

We describe in a model how demand, sales and order settings relate to each other, and estimate demand with Bayesian statistics. It calculates explicitly with uncertainty and therefore gives a range. We then test the forecasts against what you do observe: waste, lost sales and margin. Our work in industry is described under industry and maritime.

For a retailer we examined the order settings for fresh products in this way. For one fresh product in ten supermarkets we calculated that better settings could have increased profit there by 4 to 7 per cent. That is a calculation, not a measured increase in profit. Read the retail case (in Dutch).

What you can organise as an executive

  • Ask for the range with every forecast, and for what happens at its edges.
  • Have it recorded when something ran out, with the time. That one field makes hidden demand estimable.
  • Determine what a shortage costs and what a surplus costs, in money or in care.
  • Test the forecast against outcomes you can see.
  • Start with one product or one ward.

Discussing your forecasting question

Bring one product or one stock where you suspect the figures underestimate demand. That first conversation is without obligation and we aim to respond within one working day.

Discuss your question

Author: Martijn van Grieken, founder of Twentynext. How we make this. AI wrote the first version of the Dutch original, and Martijn read and approved it before it went live. This English version was translated with AI. Twentynext is responsible for the content but cannot guarantee that it is accurate or complete. See our disclaimer.

Related articles