
Inventory management dashboard
Which stock is selling, and which is money sitting still?
- Inventory value
- Units on hand
- Inventory turns
- Days of supply
Inventory dashboards
Five inventory dashboards: inventory management, valuation, stock tracking and reorder, aged stock and warehouse performance. Open any of them to see it in full, then use it as a template for your own data.



Three of the five examples. All figures are sample data.
The examples
Click a board to see all of it. Click Use template to start your own copy in Mammoth. All figures are sample data.

Which stock is selling, and which is money sitting still?

Where is cash tied up, and what does each unit cost?

What needs reordering before it runs out?

What has stopped selling, and what does it cost to hold?

Is each site keeping up, and which one is running short?
Your data
Want this on your own numbers?
Pick where your data is. Mammoth turns it into a dashboard like these.
Definition
An inventory dashboard is one screen that shows what stock you hold, what it is worth and how fast it sells. The main version, often called an inventory management dashboard, is built on four numbers: value, units, turns and days of supply.
Value, units, turns and days of supply.
What is about to run out, and what has stopped selling.
So the totals match the ledger.
The metrics
Ten numbers. Most depend on a decision made before the chart: which valuation method, which sales period, what counts as movement and what counts as an order shipped in full. Open each one to see the data it needs.
How much cash is sitting in the warehouse?
Units on hand times a cost, with one valuation method used throughout. FIFO and weighted average give different totals for the same stock, and a board that mixes them cannot match the ledger.
How many times does the stock sell through in a year?
Cost of goods sold divided by average inventory over the same period. Using the closing balance instead of the average makes a seasonal business look efficient in January and idle in November.
How long will current stock last?
Units on hand and a recent sales rate for each product at each site. A company-wide rate hides the site about to run out while another holds a year's stock.
What is about to run out?
Reorder point, supplier lead time and open purchase orders. Without open orders, you reorder stock already on its way, which turns a stockout report into overstock.
What is not selling, and for how long?
A receipt date for each batch and a last-movement date. The record's last-modified date is not movement: a stock count updates every row without anything leaving the building.
Does the system count match the shelf?
Stock count results against system quantities, by location, over a period. Adjustments posted without a reason hide where the gap comes from.
What share of orders ship in full, first time?
Order lines with ordered and shipped quantities and a due date. A backorder that ships in full later is still a miss on the day it was due.
How much of what came in has sold?
Units received and units sold for the same products over the same period. Counting transfers between sites as sales inflates it at the sending site.
What does it cost to hold stock, on top of buying it?
Average stock value over the period, plus the costs of holding it: storage, insurance, losses and the cost of the cash tied up. Leave out the cost of cash and slow stock looks free to keep.
How long does a reorder take to arrive?
Purchase order dates and delivery dates per supplier and product, over enough orders to show the range. Using the promised lead time instead of the real one sets every reorder point too low.
How to build one
From one of the examples above to a live dashboard on your own data.
Start from any of the five boards above.
Upload a spreadsheet, or connect one of 100+ tested connectors.
Fix and combine your data once. Mammoth repeats those steps for you.
The dashboard updates on a schedule and flags data that fails a check.
Public, password-protected or sign-in only, on every plan.
14-day Pro trial · No credit card
FAQ
Last reviewed against the template catalogue.
Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.
More dashboard examples