Supply Chain KPI Dashboard
- Source
- sample-data.csv · 8 rows
OTIF
94.1%
+1.3ppInventory turns
8.2
+0.4Fill rate
96.8%
+0.5ppFreight cost / unit
$2.84
-$0.11OTIF by week
Sample data — trailing 8 weeks
Supply-chain performance is a set of trade-offs — service level against inventory cost against freight spend. A good dashboard shows all three corners so improving one number can't silently wreck another.
OTIF
94.1%
+1.3ppInventory turns
8.2
+0.4Fill rate
96.8%
+0.5ppFreight cost / unit
$2.84
-$0.11OTIF by week
Sample data — trailing 8 weeks
Live render with sample data — upload your own export and this structure regenerates from your numbers, with the computation attached to every figure.
Everything you need to know about using AnalyzeData.
OTIF, inventory turnover, fill rate, order cycle time, and freight cost per unit — service, capital, and cost in one view, so trade-offs are visible instead of accidental.
Export orders, shipments, and inventory snapshots as CSV, upload, and ask for the weekly S&OP view. Every ratio computes from your rows with the code attached.
Because they pull against each other. Higher inventory turns mean less capital sleeping in the warehouse, but push turns too hard and you thin stock until fill rate, demand satisfied from stock on the first attempt, starts to suffer. Showing both on one dashboard keeps the trade-off visible, so a win on capital efficiency does not quietly become a service failure customers feel.
Because OTIF requires an order to arrive both on the promised date and complete, while a plain on-time metric ignores whether the shipment was short. An order that lands on time but missing items still fails the customer, and OTIF counts that as a miss. That makes it the more honest customer-truth metric, and the summary of everything upstream, picking, inventory accuracy, and cycle time, landing correctly.
Upload the export you already have — the dashboard computes itself, verifiably.
Open the workspace