Free purchasing and inventory tools
Calculators, templates and benchmarks for buyers and planners at manufacturers.
- Tool
Safety stock formula and calculation for purchased parts
Safety stock formula, Z table and a free calculator that turns a supplier's quoted lead-time range into a buffer and reorder point. Worked example included.
- Tool
Economic order quantity (EOQ) formula and calculator for purchased parts
The EOQ formula with a worked example, and a free calculator that fits your order quantity to the supplier's MOQ, pack size and price breaks.
- Tool
MRP calculator with a worked MRP example, week by week
Free MRP calculator: enter your build plan, open POs, lead time and MOQ, and see net requirements, planned orders and why each PO lands when it does.
- Tool
Open PO tracker and open purchase order report
Paste your open purchase order lines and see which are late, unacknowledged or slipping, and which run out of stock first. Free CSV template included.
- Tool
Supplier scorecard template that fills itself from your POs
A free supplier scorecard template in Excel, and an online version that scores each supplier from your PO dates: on time, in full and lead-time spread.
- Tool
Average supplier on-time delivery: benchmark, formula and calculator
The median supplier delivers 90% of orders on time. Measure your suppliers' on-time rate to request and to promise, and see how late the late lines run, free.