Free Supply Chain Excel Tools
Real Excel files with working formulas — safety stock, OTIF, inventory turnover, ABC analysis, and a supplier scorecard. Free — just sign in to download.
A free, lite calculator for safety stock and reorder point based on demand and lead-time variability — five inputs, two ready outputs.
Log orders and get automatic On-Time %, In-Full %, and combined OTIF — both overall and broken down by supplier.
Track monthly inventory turnover and Days of Inventory (DIO) from simple COGS and beginning/ending inventory inputs.
A quick A/B/C classification of inventory items by annual consumption value alone — a light, single-axis version.
A fast supplier scorecard based on on-time delivery and quality, with automatic tiering into Preferred/Acceptable/At Risk.
Calculate the optimal internal production batch size, accounting for gradual output rather than instant delivery.
Break down freight cost into base rate, fuel surcharge, handling, and insurance for an apples-to-apples carrier comparison.
Calculate the real per-unit cost of an imported item after freight, insurance, customs duty, and clearance fees.
Track demand forecast accuracy over time with three complementary metrics: MAPE, MAD, and Bias.
See and measure how order variability amplifies as it moves from retailer up to manufacturer.
Rank warehouse items by pick velocity and get a recommended slotting zone for each.
Calculate three complementary fill-rate metrics — unit, line, and order — from real order data.
Calculate the minimum number of kanban cards/containers needed to circulate without stockouts.
Calculate DIO, DSO, DPO, and the final cash conversion cycle to see exactly where working capital is trapped.
Calculate the volume utilization % of a loading plan, to compare packaging options before booking a shipment.