Demand Forecasting

Demand Forecasting (Prophet + Transformers)

We implemented a forecasting engine that generates SKU-level demand and safety stock recommendations across channels and locations. The system blends classical time-series with transformer-based models to handle seasonality, promotions, stockouts, and new-item cold starts.

Planners get weekly updated forecasts, exception alerts, and suggested order quantities instead of wrestling with static spreadsheets. Inventory, operations, and finance all work from the same numbers, reducing stockouts while freeing up working capital.

Time-series (Prophet) Transformers for complex patterns Safety stock & reorder points Multi-location & channel
Impact at a glance

↓ Stockouts

Better on-shelf availability

↓ Inventory

Lower working capital

Weekly

Replans & refresh

Exception-led

Focus on what changed

The engine shifted planning from reactive fire-fighting to exception-based management, with planners spending time where forecasts and demand diverge the most.

Problem

Before the forecasting engine:

  • Planning lived in complex spreadsheets that were hard to maintain.
  • Seasonality, promotions, and product life-cycles were handled manually.
  • Stockouts and overstock happened at the same time across different SKUs.
Solution

We introduced a modern forecasting stack:

  • Prophet-based baselines for classic seasonal and holiday effects.
  • Transformer models for complex patterns and cross-SKU signals.
  • Automatic safety stock and reorder point calculations per SKU/location.
  • Weekly runs with promotion calendars, pricing, and events as inputs.
Outcome

The Demand Forecasting engine delivered:

  • More stable in-stock rates on critical SKUs during peak periods.
  • Reduced excess inventory on long-tail items.
  • Aligned view of demand between supply chain, merchandising, and finance.

Architecture overview

The forecasting engine runs as a scheduled pipeline that pulls history, applies models, and writes forecasts and stock recommendations back to planning tools and dashboards.

  • Data consolidation – Sales, inventory, purchase orders, promotions, and calendar events are pulled from the data warehouse per SKU/location.
  • Cleaning & imputation – Stockout periods, outliers, and one-off events are detected and handled to avoid polluting model training.
  • Modeling – Prophet baselines and transformer models run per hierarchy (SKU, category, region), producing short/medium-term forecasts.
  • Inventory logic – Safety stock, reorder points, and suggested order quantities are calculated using service levels, lead times, and variability.
  • Publishing & alerts – Forecasts and recommendations are pushed to dashboards, exports, and exception alerts when deviations are large.
Key features in production
Multi-horizon forecasts

Short-term (week) forecasts for operations, medium-term (month/quarter) for purchasing and budgeting.

Promotion-aware

Promotion flags, price changes, and campaigns are included as regressors to avoid over-forecasting after one-off lifts.

Cold start handling

New items inherit parameters from similar SKUs and categories until they accumulate their own demand history.

Planner-friendly outputs

Forecasts come with confidence intervals and override capabilities, keeping humans in control while using the model as a strong baseline.

The setup lets teams iterate on models and parameters without disrupting downstream planning processes or requiring planners to change tools overnight.

Forecasting capabilities
  • Time-series modeling with Prophet for seasonality and holidays.
  • Transformer-based models for complex demand patterns and cross-SKU effects.
  • Outlier detection and stockout-aware demand reconstruction.
  • Service-level driven safety stock and reorder logic.
Engineering & data platform
  • Python-based modeling pipelines orchestrated by schedulers/workflows.
  • Data warehouse integration for historical data and forecast storage.
  • APIs and exports to planning tools, BI dashboards, and ERP modules.
  • Monitoring of forecast error metrics (MAPE, WAPE, bias) by segment.
Typical use cases
  • Retail and e-commerce SKU/location forecasting.
  • CPG and manufacturing demand for production and raw materials.
  • Distribution center and store-level inventory planning.
  • Any supply chain that needs to balance stockouts vs. inventory cost.