Supply Chain ML: Forecasting + Replenishment Optimizer

An end-to-end demo for retail supply chain analytics: generate realistic dummy data, engineer features, train a weekly demand-forecast model, and optimize replenishment under budget using linear programming. Exposed via a FastAPI service.

Problem Contract

This project is driven by a clear problem contract that defines what is forecasted and what the optimizer decides:

• Forecast target: weekly demand_qty per SKU × location, with horizon (H = 4) weeks ahead.
• Optimizer output: order_qty per SKU–location–period, minimizing total inventory cost (holding + stockout + ordering) under budget/capacity.
• Key constraints: lead time, MOQ, capacity, optional shelf-life, and budget cap.
• Pass/fail KPIs:
  • Forecasting: WAPE and MASE vs naive baseline.
  • Inventory/ops: fill-rate, stockout days, and total cost vs baseline or target.

For a more detailed description, see docs/problem_contract.md.

Preview

Streamlit dashboard screenshots (example):

• Landing page (metrics + charts):
  • assets/landingpage1.png
  • assets/landingpage2.png
• SKU-location details table:
  • assets/detail.png

Tech Stack

• Language: Python 3.11
• API: FastAPI + Uvicorn
• ML: pandas, numpy, scikit-learn, LightGBM (fallback to RandomForest)
• Optimization: SciPy linprog
• Packaging: Docker

Project Structure

app/            FastAPI app & services
  main.py
  services/
    inference.py
    optimizer.py
etl/            Dummy data + features + processed
  generate_dummy.py
  build_features.py
models/         Training code & artifacts
  train_forecast.py
  artifacts/
scripts/        Utilities (e.g., backtest placeholder)
tests/          Pytest for API
docker/         Dockerfile

Prerequisites

• Python 3.11
• Windows PowerShell or a POSIX shell
• Optional: Docker (24+) for container runs

Setup (Windows PowerShell)

python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install --upgrade pip
pip install -r requirements.txt

Setup (macOS/Linux)

python3 -m venv .venv
source .venv/bin/activate
pip install --upgrade pip
pip install -r requirements.txt

Quickstart

Option A: Training & Evaluation Pipeline

1. Generate data and build features

python etl/generate_dummy.py
python etl/build_features.py

2. Train forecasting model (with time-based split)

python -m src.forecasting.train

3. Evaluate and generate predictions

python -m src.forecasting.evaluate

Option B: Streamlit Dashboard (Visual)

Setelah menjalankan pipeline di atas, jalankan dashboard:

streamlit run streamlit_app.py

Dashboard akan terbuka di browser (default: http://localhost:8501).

Fitur Dashboard:

• 📈 Summary metrics (WAPE untuk naive, seasonal, model)
• 📉 Forecast vs Actual comparison chart (interaktif)
• 📊 Error distribution histograms
• 🔍 Detail metrics per SKU-location (opsional)

Option C: FastAPI Service

uvicorn app.main:app --host 0.0.0.0 --port 8000 --reload

4. Smoke tests (untuk API)

Invoke-RestMethod -Uri "http://localhost:8000/health" -Method Get
Invoke-RestMethod -Uri "http://localhost:8000/forecast" -Method Post -ContentType "application/json" -Body '{"horizon_weeks":4,"pairs":[{"store_id":"S001","product_id":"P001"}]}'
Invoke-RestMethod -Uri "http://localhost:8000/replenish" -Method Post -ContentType "application/json" -Body '{"target_service":0.95,"capacity":50000}'

Alternatively, using Make (macOS/Linux or Windows with make installed):

make setup && make data && make train && make run

API Reference

• GET /health → { "status": "ok" }

• POST /forecast

  • Request

    { "horizon_weeks": 8, "pairs": [{"store_id":"S001","product_id":"P001"}] }

  • Response (excerpt)

    {
      "horizon_weeks": 8,
      "forecasts": [
        {"store_id":"S001","product_id":"P001","forecast":[6.2,6.1,6.0, ...]}
      ]
    }

• POST /replenish

  • Request

    { "target_service": 0.95, "capacity": 50000 }

  • Response (excerpt)

    {
      "target_service": 0.95,
      "capacity": 50000.0,
      "orders": [
        {"store_id":"S001","product_id":"P001","order_qty":12,"unit_price":50.0,"cost":600}
      ]
    }

Notes:

• If no trained model is found, /forecast returns a reasonable naive forecast.
• Replenishment solves a linear program; if the solver fails, it falls back to needs.

Testing

pytest -q

Docker

docker build -t scm-ml .
docker run -p 8000:8000 scm-ml
curl http://localhost:8000/health

Troubleshooting

• Parquet errors: ensure pyarrow is installed (included in requirements.txt).
• Windows without make: use the PowerShell commands above or install make via choco install make.
• Port already in use: change --port 8001 when running Uvicorn.

Deployment

Streamlit Cloud (Recommended for MVP)

1. Push repo ke GitHub
2. Login ke streamlit.io
3. Connect GitHub repo
4. Set main file: streamlit_app.py
5. Deploy!

Note: Pastikan data/processed/predictions.csv sudah ada di repo atau generate via GitHub Actions.

Vercel (Future: Next.js Frontend)

Untuk deployment production dengan custom UI, bisa build Next.js frontend yang call FastAPI backend.

Roadmap

• ✅ Streamlit dashboard untuk visualisasi
• ETA/lead-time module
• Anomaly detection
• Deployment notes for AWS (ECS/Lambda)
• Next.js frontend untuk production

supplychain-ml-forecasting-optimizer