Field notes
Guides to stock, suppliers and purchasing
Worked examples and the exact Excel formulas — written from a parts warehouse, not a textbook. Each guide comes with a free tool that does the work for you.
How to calculate a reorder point (with the Excel formulas)
The formula on one example product, why stock on order matters, how much to order, and the Excel formulas.
Read the guide →Safety stock formula: four ways to calculate it, and which to use
Max − average, demand-only, lead-time-only and combined, on one product — with a service-level table and Excel formulas.
Read the guide →How to chase a late supplier: 7 email templates in English and Chinese
Seven copy-ready follow-ups for late POs, in English and Simplified Chinese, with when to send each one.
Read the guide →Next up
In the forge
- ABC-XYZ analysis in Excel, step by step
- Finding dead and slow-moving stock — and what to do with it
- A supplier scorecard that measures real lead times