Kpiloom
Looker Studio version coming soon. We are testing every Looker Studio file before we sell it. The Excel and Google Sheets versions of each dashboard are ready to download now.

Looker Studio 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 Looker Studio 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