Nutraceuticals & Functional Foods worked example

Demand Forecast Gap with forecast demand of 62,500 units: a worked example in nutraceuticals & functional foods

This worked example runs the demand forecast gap numbers for a tougher week than the baseline: forecast demand of 62,500 units instead of the typical 125,000 units. Compare forecast demand against actual or committed demand to see the forecast gap in units and percent, so planners can adjust production and purchasing.

The inputs for this scenario

  • Forecast demand: 62,500 units (the input this scenario stresses; the baseline uses 125,000)
  • Actual or committed demand: 100,000 units (held at the documented default)
  • Reference demand for percent: 125,000 units (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Forecast gap amount = forecast demand - actual or committed demand.
  • Forecast gap works out to -30 % at these inputs, and this is the headline figure for the scenario.
  • Forecast gap amount works out to -37,500 units at these inputs.
  • Forecast demand works out to 62,500 units at these inputs.
  • Actual or committed demand works out to 100,000 units at these inputs.

How this compares with the baseline

  • Against the tool's baseline example, where forecast demand sits at 125,000 units and the headline result is 20 %, this scenario comes in 250% below the baseline at -30 %.
  • Use it at each forecasting cycle or after a promotion closes, to quantify how far the plan diverged and whether the forecast model needs adjustment. A result at this level usually justifies acting on the stressed input before touching anything else, because every other figure in the table is downstream of it.

Results at a glance

  • Forecast gap: -30 % (headline result)
  • Forecast gap amount: -37,500 units
  • Forecast demand: 62,500 units
  • Actual or committed demand: 100,000 units

Run it with your numbers

  • To rerun this with your own numbers, open the live Demand Forecast Gap calculator, set forecast demand to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.