Kpiloom

Excel Inventory Dashboard Templates

A inventory dashboard shows what is in stock, what is about to run out and where money is stuck in slow stock. Pick your industry below to see a live preview of the Excel version.

Choose your industry

KPIs in every inventory dashboard

KPIWhat it tells youFormula
Stock valueValue of all stock on hand at cost.SUM of (Quantity × Unit cost)
Stock turnoverHow many times stock is sold and replaced in a year.Cost of goods sold ÷ Average stock value
Out-of-stock itemsItems with zero quantity on hand.COUNT of items where Quantity = 0
Reorder alertsItems at or below their reorder level.COUNT of items where Quantity ≤ Reorder level
Days of inventoryHow many days current stock would last.Stock value ÷ Average daily cost of sales
Fill rateShare of order lines shipped complete from stock.Lines filled ÷ Lines ordered
Dead stock valueValue of items with no sales in 90+ days.SUM of stock value where Last sale > 90 days
ShrinkageStock lost to damage, theft or errors.(Book stock − Physical stock) ÷ Book stock