Supply chain thinking from the Automcore team.
MAPE and bias metrics, safety stock formulas, POS velocity signals, BOM demand propagation — written for the planner running the actual spreadsheet, not the analyst writing about it.
POS Velocity Signals: What Your Transaction Data Is Already Telling You
Hourly sell-through velocity contains demand signals that weekly reports obscure. Here’s how to extract them.
How Weather Patterns Drive Demand Shifts That ERPs Never See
A three-day cold front in the Pacific Northwest can shift jacket demand by 40% in 72 hours. Your ERP won’t react in time.
Supplier Lead Time Variability: The Hidden Input Your Forecast Is Missing
A supplier’s stated lead time and actual delivery window are rarely the same. Measuring the gap is step one.
Inventory Planning in Excel vs. AI Forecasting: An Honest Comparison
Excel works until it doesn’t. Here’s the specific thresholds at which a spreadsheet-based demand plan stops being adequate.
The Mid-Market Retail Forecasting Gap: Why $50M–$200M Brands Get Left Behind
Enterprise forecasting platforms require data science teams. Simple reorder tools are too blunt. The gap is real and expensive.
The Safety Stock Formula Revisited: Why Z-Scores Alone Aren’t Enough
The classic safety stock formula assumes normally distributed demand and constant lead times. Neither is true for most SKUs.
Demand Sensing vs. Demand Forecasting: When You Need Each
Sensing is short-horizon (1–3 weeks). Forecasting is medium-horizon (4–12 weeks). They solve different problems and need different data.
BOM Demand Propagation: How Finished-Goods Forecasts Should Drive Component Purchasing
Most manufacturers forecast at the finished-goods level and hope the BOM math works out. It rarely does without explicit propagation logic.
Seasonal Demand Pattern Detection: Reading the Cycle Before It Peaks
Seasonality isn’t just “Q4 is big.” At SKU level, patterns are complex, overlapping, and shift year-over-year. Here’s how to detect them early.
Connecting FP&A to Supply Chain: Why Finance and Demand Planning Need the Same Forecast
When Finance uses revenue assumptions and Supply Chain uses sell-through velocity, the company is working from two different views of the future.
Reduce Dead Stock: A Retail Planner’s Playbook for 2026
Dead stock isn’t just a margin problem — it’s a forecasting failure that compounds over buying cycles. Here’s how to break the cycle.