Inventory dashboards
Inventory dashboard examples
The examples
Each dashboard, and the question it answers
Each of these is a Mammoth template, captured as it renders on the sample dataset it ships with, so every figure on them is illustrative rather than a business result. All five run on the same 792-row stock dataset, which is the point: they are five questions about one set of numbers, not five systems.
Example 01
Inventory Management
Which of this stock is working, and which is money sitting still?
Stock value over time on the first page and movement on the second, cut by category and site. Turns and cover sit on the same strip as value deliberately — stock that is worth a lot and moves slowly is a different problem from stock that is worth a lot because it sells.
What is on it· 2 pages · What we hold / What's moving
- Stock value over time
- Where the value is held
- Movement by site
- Turns by category
- Cover spread by category
- Cover by category and site
Your data needsDashboard
- a revenue or money column
- a category (~6 values)
Sample data — illustrative figures, not business results. Cropped; the dashboard continues below. Example 02
Inventory Valuation
Where is the money tied up, and what does a unit of it cost?
What the stock is worth month by month, with held set against sold and unit cost broken out by category. The last chart plots unit cost against how much we hold, which is where an expensive line quietly carrying most of the balance becomes visible.
What is on it
- What the stock is worth, month by month
- Held against sold
- What a unit costs by category
- Which lines hold the money
- Unit cost against how much we hold
- Value by category and site
Your data needsDashboard
- a revenue or money column
- a category (~3 values)
Sample data — illustrative figures, not business results. Cropped; the dashboard continues below. Example 03
Stock Health & Reorder
What needs reordering before it runs dry?
What has fallen below its reorder point, by category, with cover plotted against turns so a line that looks short but barely moves is not treated as urgent. Lines in stock are shown against lines out — the count that says whether this is a handful of lines or a systemic gap.
What is on it
- Below reorder point by category
- Cover against turns
- Which lines hold the value
- Cover spread by site
- Lines in stock against out
Your data needsDashboard
- a count column
- a category (~2 values)
Sample data — illustrative figures, not business results. Cropped; the dashboard continues below. Example 04
Slow & Aged Stock
What has stopped moving, and what is it costing to hold?
Where the dead money sits, by category and site, with how long each category would last at its current rate. Value is split above and below the reorder point, which separates stock that is merely slow from stock that is both slow and overstocked.
What is on it
- Where the dead money is
- How long each category would last
- Overstocked against running short
- Turn spread by category
- Slow movers sit top left
- Value above and below the reorder point
Your data needsDashboard
- a revenue or money column
- a category (~6 values)
Sample data — illustrative figures, not business results. Cropped; the dashboard continues below. Example 05
Warehouse Performance
Is each site keeping up, and which one is running short?
Intake against despatch site by site, with turns and days of supply per site rather than a network total. The cover spread within each site is the chart that matters most: a site can hold healthy average cover while a third of its lines are about to run out.
What is on it
- Intake against despatch by site
- Turns by site
- How much of each site is running short
- Cover spread within each site
- Turns against cover, site by site
- Site ranking, month by month
Your data needsDashboard
- a count column
- a category (~3 values)
Sample data — illustrative figures, not business results. Cropped; the dashboard continues below.
Design notes
What makes an inventory dashboard worth opening
Four things the examples above have in common. They matter more than which chart you pick.
Turns is the number that ties them together
Inventory Turns is the one metric on all five of these strips. Value tells you how much is tied up and units tell you how much is there, but only turns says whether it is working — which is why a valuation dashboard and a reorder dashboard both carry it despite answering opposite questions.
Too much and too little are one chart
Overstock and stockout are usually reported separately and are the same failure of forecasting seen from two ends. Slow & Aged Stock plots overstocked against running short on a single chart, and Stock Health sets cover against turns, so a line that looks short but barely moves is not treated as urgent.
Value and units are different questions
A category can hold a fifth of the units and half the money. Three of these carry inventory value and units on hand on the same strip, and Inventory Valuation adds unit cost and plots it against how much is held — which is where an expensive line quietly carrying the balance shows up.
It resolves to a site or a line
A network total is nobody's job. Almost every chart here lands on a site or a product line — movement by site, cover spread within each site, which lines hold the value, value above and below the reorder point — because those are the units a warehouse or a buyer can actually act on.
From example to live dashboard
Pretty is easy. Current and true is the hard part.
Any of these can be drawn in a slide. What makes one worth keeping is the five steps underneath it, and they are the same five whichever example you start from.
- 01
Connect the source
The dashboard reads the system, not an export somebody saved to their desktop. 100+ tested connectors, plus anything with a REST API.
- 02
Prepare it once
Cleaning, joining and reshaping are recorded as steps you can read, change and re-run — not a formula buried three sheets deep.
- 03
Check it before anyone sees it
Data checks run with the refresh and flag the rows that fail, so a broken upstream file shows up as an alert rather than as a wrong number in a meeting.
- 04
Put it on a schedule
Refresh on a schedule and the dashboard stays current on its own. Starter schedules daily runs; Pro adds hourly refresh and event triggers.
- 05
Publish it and send the link
Public, password-protected or sign-in only. Every sharing mode is available on every plan, including the free one.
Sharing
Everyone can see it.
Nobody pays to look.
Most dashboard tools charge for every person who opens one, which is why so many dashboards end up as a screenshot pasted into a message. Mammoth charges for the people who build. Viewers are unlimited and free on every plan, including the free one.
Free
$0
- Builders
- 1 builder
- Dashboards
- 3 published
- Viewers
- Unlimited, free
Starter
$249/mo
$199/mo billed annually
- Builders
- 5 builders
- Dashboards
- 10 published
- Viewers
- Unlimited, free
Pro
$699/mo
$559/mo billed annually
- Builders
- 10 builders
- Dashboards
- 50 published
- Viewers
- Unlimited, free
Enterprise
From $5,000/mo
- Builders
- Unlimited builders
- Dashboards
- Unlimited published
- Viewers
- Unlimited, free
Published-dashboard counts are per workspace. Drafts, viewers and every sharing mode are unlimited and free on all four plans. Full pricing.
Questions people ask
What should an inventory dashboard show?
Where does the stock data come from?
How often should it refresh?
Can warehouse and store staff see it without a licence?
Build the inventory dashboard you actually need.
Connect a source, prepare it once, and publish. Everyone who needs to see it can, at no per-viewer cost.
- 21-day Pro trial
- No credit card
- Viewers always free