Excel Templates
25 free templates — one for every calculator. Pre-built formulas, example data, and instructions. Download, edit, and use offline.
ABC Analysis Template
Categorize inventory items by their contribution to total annual value.
Carrying Cost Calculator
Calculate the annual cost of holding inventory.
Cycle Stock Calculator
Calculate the average inventory consumed between replenishment orders.
Days Inventory Outstanding Calculator
Calculate how many days inventory sits in stock before sale.
Economic Batch Quantity Calculator
Find the optimal batch size for manufacturing with finite production capacity.
Economic Order Quantity Calculator
Find the optimal order quantity that minimizes total inventory costs.
Exponential Smoothing Template
Forecast demand with a smoothing factor balancing responsiveness and noise.
Inventory Accuracy Calculator
Measure how closely physical inventory counts match system records.
Inventory Turnover Calculator
Measure how many times inventory is sold and replaced per year.
Lead Time Analysis Template
Summarize supplier lead time reliability from observed orders.
Mean Absolute Deviation (MAD) Template
Measure the average magnitude of your forecast error.
Mean Absolute Percentage Error (MAPE) Template
Measure forecast error as a scale-independent percentage.
MOQ Optimizer Template
Compare Minimum Order Quantity options for the lowest cost per unit.
Moving Average Forecast Template
Forecast next-period demand from the average of recent periods.
Picking Productivity Calculator
Measure units picked per labor hour.
Pipeline Inventory Calculator
Calculate stock in transit between locations during lead time.
Reorder Point Calculator
Determine when to place a new order based on demand and lead time.
Safety Stock Calculator
Calculate the buffer inventory needed to protect against demand spikes.
Space Utilization Calculator
Measure inventory value generated per unit of space.
Stockout Cost Calculator
Estimate the annual cost of inventory shortages.
Storage Density Calculator
Measure units stored per unit of available space.
Supplier Scorecard Template
Roll up quality, delivery, cost, and service into one weighted score.
Total Cost of Ownership Calculator
Calculate the fully-loaded per-unit cost of a purchase.
Warehouse Capacity Calculator
Measure how much of total warehouse capacity is occupied.
Weighted Moving Average Template
Forecast demand by weighting recent periods more heavily than older ones.