EliconStart a project →
← ALL WORK

CASE 13

12 weeks

ML Demand Forecasting for a Retailer

Fewer stockouts, less overstock, fewer spreadsheets.

  • Python
  • FastAPI
  • Prophet/PyTorch
  • Postgres
  • dbt

THE PROBLEM

A category manager forecasted demand weekly by pasting last year's sales next to 'gut feel' columns. Peaks meant stockouts; lulls meant writedowns.

WHAT WE DID

  1. 01

    Built a SKU-level forecasting pipeline (hierarchical reconciliation so category totals always match).

  2. 02

    Mixed a statistical baseline with a trained neural model for the long-tail SKUs.

  3. 03

    Integrated with the warehouse management system so reorder suggestions land where purchase orders actually get written.

  4. 04

    Weekly back-tests and accuracy dashboards so the category team sees exactly when the model helped and when it didn't.

OUTCOME

Stockouts down meaningfully on A-tier SKUs. Inventory holding cost down a double-digit percentage, freeing cash.

HAVE A PROJECT LIKE THIS?

Let’s talk about yours.

Start a project →