Skip to content

Inventory dashboards

Inventory dashboard examples

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.

Inventory Valuation dashboard: Inventory Value, Units On Hand, Unit cost and Inventory Turns tiles.
Stock Health & Reorder dashboard: Units On Hand, Reorder Point, Days Of Supply and Inventory Turns tiles.
Inventory Management dashboard: Inventory Value, Units On Hand, Inventory Turns and Days Of Supply tiles.

Three of the five examples. All figures are sample data.

Stock in Shopify, or in a spreadsheet?Pick where your data is. Each opens a free template that builds a dashboard like these.

The examples

Five inventory dashboard examples and templates

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

  1. Inventory Management dashboard: Inventory Value, Units On Hand, Inventory Turns and Days Of Supply tiles.
    Sample data

    Inventory management dashboard

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

    • Inventory value
    • Units on hand
    • Inventory turns
    • Days of supply
    Use template
  2. Inventory Valuation dashboard: Inventory Value, Units On Hand, Unit cost and Inventory Turns tiles.
    Sample data

    Inventory valuation dashboard

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

    • Inventory value
    • Units on hand
    • Unit cost
    • Inventory turns
    Use template
  3. Stock Health & Reorder dashboard: Units On Hand, Reorder Point, Days Of Supply and Inventory Turns tiles.
    Sample data

    Inventory tracking dashboard

    What needs reordering before it runs out?

    • Units on hand
    • Reorder point
    • Days of supply
    • Inventory turns
    Use template
  4. Slow & Aged Stock dashboard: Inventory Value, Days Of Supply, Inventory Turns and Units On Hand tiles.
    Sample data

    Aged inventory dashboard

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

    • Inventory value
    • Days of supply
    • Inventory turns
    • Units on hand
    Use template
  5. Warehouse Performance dashboard: Units Sold, Units Received, Inventory Turns and Days Of Supply tiles.
    Sample data

    Warehouse dashboard

    Is each site keeping up, and which one is running short?

    • Units sold
    • Units received
    • Inventory turns
    • Days of supply
    Use template
  6. Your data

    Want this on your own numbers?

    Pick where your data is. Mammoth turns it into a dashboard like these.

Definition

What an inventory dashboard is

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.

  • Four core numbers

    Value, units, turns and days of supply.

  • Problems at both ends

    What is about to run out, and what has stopped selling.

  • One valuation method

    So the totals match the ledger.

The metrics

The metrics an inventory dashboard is built from

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.

  • Stock value

    How much cash is sitting in the warehouse?

    What the data needs

    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.

  • Inventory turns

    How many times does the stock sell through in a year?

    What the data needs

    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.

  • Days of supply

    How long will current stock last?

    What the data needs

    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.

  • Stockout risk

    What is about to run out?

    What the data needs

    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.

  • Aged and slow-moving stock

    What is not selling, and for how long?

    What the data needs

    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.

  • Inventory accuracy

    Does the system count match the shelf?

    What the data needs

    Stock count results against system quantities, by location, over a period. Adjustments posted without a reason hide where the gap comes from.

  • Fill rate

    What share of orders ship in full, first time?

    What the data needs

    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.

  • Sell-through rate

    How much of what came in has sold?

    What the data needs

    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.

  • Carrying cost

    What does it cost to hold stock, on top of buying it?

    What the data needs

    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.

  • Supplier lead time

    How long does a reorder take to arrive?

    What the data needs

    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

How to build your own inventory dashboard

From one of the examples above to a live dashboard on your own data.

  1. 1

    Pick a template

    Start from any of the five boards above.

  2. 2

    Add your data

    Upload a spreadsheet, or connect one of 100+ tested connectors.

  3. 3

    Clean it once

    Fix and combine your data once. Mammoth repeats those steps for you.

  4. 4

    Set it to refresh

    The dashboard updates on a schedule and flags data that fails a check.

  5. 5

    Share the link

    Public, password-protected or sign-in only, on every plan.

Start with a template

14-day Pro trial · No credit card

FAQ

Inventory dashboard questions

Last reviewed against the template catalogue.

What should an inventory dashboard show?
What you hold, what it is worth and how fast it sells, then the problems at both ends. The five above split that up: the inventory management dashboard is the everyday view, valuation follows the money, the tracking dashboard catches what is about to run out, aged inventory catches what has stopped selling, and the warehouse dashboard compares sites.
What KPIs should an inventory dashboard track?
Stock value, inventory turns and days of supply are the core three, with stockout risk and aged stock as the warning signs. Then inventory accuracy, fill rate, sell-through, carrying cost and supplier lead time. The list above shows all ten, with the data each one needs.
How do I build an inventory dashboard?
Start with one question, usually what to reorder or what is tying up cash. Then follow five steps.
  1. Connect the stock system and sales history: the ERP or warehouse system for what you hold, and orders or invoices for what sells.
  2. Agree the definitions once: one valuation method, one sales period for days of supply and what counts as movement.
  3. Check the totals against the last stock count before anyone reads the board.
  4. Build the board around value, units, turns and days of supply, with the problems below: products below reorder point and stock that has stopped selling.
  5. Set a refresh schedule and share it with every site, so the board shows this morning's stock, not last week's export.
What is the difference between an inventory dashboard and a warehouse dashboard?
An inventory dashboard is about the stock: what you hold, what it is worth and what to reorder. A warehouse dashboard is about moving it: goods in, goods out and how fast stock turns. The warehouse dashboard above is the second kind. The other four are the first.
Where does the stock data come from?
The ERP or warehouse system, usually combined with a purchasing spreadsheet and sales data. Mammoth has 100+ tested connectors, and can also connect to anything with a REST API. Combining stock with sales is what turns a stock list into days of supply.
How often should it refresh?
It depends which of the five. Valuation and aged stock are month-end questions, so overnight is plenty. Reorder points and warehouse activity are worth refreshing as often as your plan allows. See plans and refresh rates
Can warehouse and store staff see it without a licence?
Yes. Viewers are unlimited and free on every Mammoth plan, including the free one, so every site can have its own view at no extra cost. Only the people who build dashboards count as users.

Build the inventory dashboard you actually need.

Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free