Skip to main content
Skip to content
Machine Learning

Forecasting

Demand, sales, stock, cash, load: forecast from your history and the outside factors that move it, with a range you can plan against, delivered into the tools you plan with.

01 / 04

Last year plus a percentage

The spreadsheet extrapolates the trend and misses the turns. Weather, prices and the calendar sit in other files. One number, no range, so planning guesses the buffer.

CH.01 · The problem

The forecast is last year plus a percentage.

  1. It misses the turns

    A spreadsheet extrapolates the trend. It cannot see the promotion, the holiday shift or the new competitor until the month has already gone wrong.

  2. The outside world is not in it

    Weather, prices, calendar, the customer's own forecast. The factors that move your numbers sit in other files, unread.

  3. One number, no range

    A forecast of 1,200 units with no idea whether 900 or 1,500 is plausible. Planning cannot size the buffer, so it guesses.

Our answer

A model on your history and the factors that drive it

We build a forecast from your own series and the external signals that matter, tested on the months it never saw, and deliver it with a range into the planning tool your teams already use.

CH.02 · What we build

How we build it

Three parts: the data, the model, the delivery.

More than the trendOutside factors includedA range around the numberDelivered where planning happens
01

Data strategy

Your series, and what moves them.

  • Collect the history at the grain you plan at
  • Clean gaps, stock-outs and one-off events
  • Add the external factors with a plausible link
  • Build the calendar: holidays, promotions, closures
  • Hold out the last periods for testing
02

Model development

Tested on the months it never saw.

  • Start from a simple baseline and beat it
  • Try statistical and machine learning models
  • Measure error on the held-out periods
  • Produce intervals, and check they hold
  • Choose the model per series, when it pays
03

Operationalisation

A forecast that runs itself.

  • Automate the data refresh and the run
  • Deliver into the planning tool
  • Track error each period against actuals
  • Alert when error drifts
  • Retrain on a schedule
CH.03 · How it runs

How it runs

Four phases from the current spreadsheet to a forecast in production.

  1. 01Phase 1

    Discovery

    What is forecast, at what grain, for which decision.

    • Map the decisions the forecast feeds
    • Fix the grain: product, site, week
    • Measure the current forecast's error
  2. 02Phase 2

    Data pipeline

    History and factors, refreshed on schedule.

    • Connect the source systems
    • Clean and align the series
    • Build the calendar and external feeds
  3. 03Phase 3

    Model

    Baseline, candidates, held-out test.

    • Build the baseline
    • Train candidate models
    • Test on the held-out periods
  4. 04Phase 4

    Production

    Deliver, track, retrain.

    • Deliver into the planning tool
    • Run beside the current forecast for a cycle
    • Track error against actuals
CH.04 · What changes

What changes

Fewer surprises, buffers sized to the uncertainty, and a forecast people use.

Error you can measure

Forecast against actuals, every period, against the baseline it replaced. Improvement is a number the planning team reports.

Buffers sized to the range

Stock, staff and cash planned for the interval. Less over-stock in the calm weeks, fewer shortages in the uncertain ones.

A forecast in the workflow

It lands where the plan is made and refreshes on its own. The team spends its time on the decision.

Side by sideSpreadsheetModel
InputsLast year's numbersHistory plus the factors that move it
PatternsTrend and a guess at seasonSeason, promotions, calendar, lead times
OutputOne numberA number and a range
When things changeSomeone edits the sheetRetrained on the new data, error tracked
AccuracyRarely measuredMeasured every period, against the baseline
CH.05 · Questions

Questions

Anything with a history and a decision behind it: demand by product and site, sales by segment, stock and replenishment, cash flow, call or ticket volume, energy and machine load. The first series we pick in discovery, by the value of the decision it feeds and the quality of its history.

Enough to cover the patterns you want captured: two or three full seasons for a seasonal series, less for a stable one. Short histories can borrow from similar series. We say in discovery what the data supports, and measure the baseline before promising anything.

Every forecast comes with an interval, and we check on the held-out periods that actuals fall inside it as often as the interval claims. Planning then sizes buffers to the range. Weeks with wide intervals are flagged so the team looks at them first.

Yes. The forecast is delivered into the ERP, the planning tool or the sheet your team uses, on the schedule they plan on. The data comes from your systems through their APIs or exports, and the refresh runs without anyone pressing a button.

More in Machine Learning

The map of the practice

Back to Machine Learning
Start

Bring us the problem nobody has cracked yet.

We are a small team of senior specialists. We pick the right model and the right layer, and we build the least machinery that does the job. You get a call with an engineer, not a sales deck.