Reorder & Safety Stock Parameters
These thresholds are used by the compute worker for signal scoring. Changes take effect on the next worker run.
| Parameter | Value | Description |
|---|---|---|
| Safety Stock Z-score | 1.65 = 95% service level | |
| Reorder Lead Time (days) | Default supplier lead time | |
| Review Period (days) | Replenishment review cycle | |
| Spike Multiplier | 7d velocity vs 30d average |
Deadstock Thresholds
| Parameter | Value |
|---|---|
| No-movement days threshold | |
| Min on-hand value (Rp) | |
| NG write-off age (days) | |
| Transit overdue multiplier |
Connections
| Service | Host | Status |
|---|---|---|
| DWH PostgreSQL | 172.16.1.161:5434 |
checking… |
| Compute Worker | 100.74.186.103:8001 |
checking… |
SOR Benchmark Ranges
Stock-to-Order Ratio = avg_on_hand_6m / avg_monthly_sales_6m
| Range | Status |
|---|---|
| < 1.0 | Critical — stockout imminent |
| 1.0 – 1.5 | Warning — low buffer |
| 1.5 – 3.0 | Healthy |
| 3.0 – 6.0 | Watch — potential overstock |
| > 6.0 | Deadstock risk |
About SIGMA
SGI Inventory Monitoring & Analytics — Version 1.0
Architecture: DWH (PostgreSQL) → Flask API → Browser. Heavy computation (forecasting, signal scoring, transfer optimization) runs on the Ollama compute machine at 100.74.186.103:8001.
Data pipeline: SAP HANA → Airflow → raw.* → dbt → dbt_mart.*