Essential Inventory KPIs Every Business Should Track
Why KPIs Matter
You can't improve what you don't measure. These 7 KPIs tell you if your inventory management is working.
KPI #1: Inventory Turnover Rate
What it is:
How many times per year you sell and replace your entire inventory.
Formula:
Turnover = Cost of Goods Sold (COGS) / Average Inventory Value
Example:
What's good:
Too low = Cash tied up in slow-moving stock
Too high = Risk of stockouts
KPI #2: Stockout Rate
What it is:
% of time a product is unavailable when a customer wants to buy it.
Formula:
Stockout Rate = (Days Out of Stock / Total Days) × 100
Example:
What's good:
Impact:
For a business with $50K/month revenue, a 10% stockout rate = $5,000/month in lost sales ($60K/year).
KPI #3: Carrying Cost
What it is:
Total cost of holding inventory (storage, insurance, spoilage, opportunity cost).
Formula:
Carrying Cost = (Storage + Insurance + Spoilage + Opportunity Cost) / Average Inventory Value
Example:
Carrying Cost = ($1,100 × 12) / $30,000 = 44% per year
What's good:
KPI #4: Order Accuracy
What it is:
% of orders received with correct items and quantities.
Formula:
Order Accuracy = (Correct Orders / Total Orders) × 100
Example:
What's good:
Impact:
Low accuracy = wasted time on returns, re-orders, and customer complaints.
KPI #5: Days of Inventory on Hand (DOH)
What it is:
How many days of sales you have in current inventory.
Formula:
DOH = (Current Inventory Value / COGS) × 365
Example:
What's good:
Too low = Risk of stockouts
Too high = Cash tied up unnecessarily
KPI #6: Gross Margin Return on Investment (GMROI)
What it is:
How much gross profit you earn for every dollar invested in inventory.
Formula:
GMROI = Gross Margin / Average Inventory Cost
Example:
Interpretation:
For every $1 in inventory, you earn $4 in gross profit.
What's good:
KPI #7: Backorder Rate
What it is:
% of orders you can't fulfill immediately due to stockouts.
Formula:
Backorder Rate = (Backordered Units / Total Units Ordered) × 100
Example:
What's good:
Impact:
High backorder rates = lost sales (customers cancel) + customer frustration.
How to Track These KPIs
Manual (Spreadsheet):
Automated (Software):
Monthly KPI Review Checklist
□ Inventory turnover: Is it within target range?
□ Stockout rate: Any products consistently out of stock?
□ Carrying cost: Are we holding too much inventory?
□ Order accuracy: Any supplier quality issues?
□ DOH: Do we have too many or too few days of stock?
□ GMROI: Which products are most/least profitable?
□ Backorder rate: Are we fulfilling orders on time?
Taking Action on KPIs
If turnover is too low:
If stockout rate is too high:
If carrying cost is too high:
Summary
The 7 essential inventory KPIs:
1. Inventory turnover (sales / inventory value)
2. Stockout rate (% of time out of stock)
3. Carrying cost (% of inventory value)
4. Order accuracy (% of correct deliveries)
5. Days of inventory on hand (days of sales in stock)
6. GMROI (profit per $ of inventory)
7. Backorder rate (% of unfulfilled orders)
Track these monthly. Improve 1-2 at a time. Your business will become more profitable and less stressful.
Ready to automate your inventory?
Connect your POS and let AI handle the rest. Free to start.
Get Started Free