A supply chain KPI dashboard puts the numbers that decide cost, service and cash on one screen: are orders shipped on time and in full, how fast inventory turns, what freight really costs per shipment, and which suppliers keep slipping. This guide lists the 15 supply chain metrics worth tracking, shows how to lay them out so a manager can read the page in 30 seconds, and walks through building the dashboard in Excel step by step.
What is a supply chain dashboard?
A supply chain dashboard is a one-page report that pulls data from purchasing, warehousing and transport into a few KPI cards, trend charts and breakdowns. People search for it under different names (supply chain metrics dashboard, supply chain performance dashboard, supply chain analytics dashboard), but the goal is the same: spot a problem early enough to act on it.
- KPI dashboard: 5 to 8 headline numbers against a target (OTIF, fill rate, inventory turns, cost per shipment).
- Metrics or analytics dashboard: the detail behind those numbers, broken down by supplier, route, product or warehouse.
- Performance dashboard: the same KPIs shown over time, so you see whether a change actually worked.
A good template combines all three: KPI cards at the top, trends in the middle and breakdowns at the bottom.
15 supply chain KPIs to put on your dashboard
Do not track all 15 from day one. Pick the 5 to 8 that match your biggest cost or service problem, then add the rest later.
| KPI | What it tells you | Excel formula (idea) |
|---|---|---|
| 1. On-time delivery (OTD) | Share of orders delivered by the promised date | =COUNTIFS(Status,"Delivered",Late,"No")/COUNTA(OrderID) |
| 2. OTIF (on time, in full) | Orders that were both on time and complete, the strictest service KPI | =COUNTIFS(OnTime,"Yes",Complete,"Yes")/COUNTA(OrderID) |
| 3. Order fill rate | Units shipped vs units ordered | =SUM(QtyShipped)/SUM(QtyOrdered) |
| 4. Perfect order rate | On time, complete, undamaged and correctly invoiced | OTIF × damage-free % × invoice-accuracy % |
| 5. Order cycle time | Days from order to delivery | =AVERAGE(DeliveryDate-OrderDate) |
| 6. Inventory turnover | How many times stock is sold and replaced per year | =COGS/AVERAGE(OpeningStock,ClosingStock) |
| 7. Days of inventory (DIO) | How many days current stock will last | =365/InventoryTurnover |
| 8. Stock-out rate | Share of order lines that could not be served from stock | =COUNTIF(Stock,0)/COUNTA(Lines) |
| 9. Freight cost per shipment | Average transport cost of one shipment | =SUM(FreightCost)/COUNTA(ShipmentID) |
| 10. Freight cost as % of sales | Whether logistics is eating your margin | =SUM(FreightCost)/SUM(Revenue) |
| 11. Supplier on-time rate | How reliable each supplier is | =COUNTIFS(Supplier,A2,Late,"No")/COUNTIF(Supplier,A2) |
| 12. Supplier lead time | Average days from purchase order to receipt | =AVERAGEIFS(LeadDays,Supplier,A2) |
| 13. Purchase price variance | Paid price vs standard or budget price | =(ActualPrice-StandardPrice)*Qty |
| 14. Cash-to-cash cycle | Days your cash is tied up in the chain | DIO + DSO − DPO |
| 15. Fleet utilization | How much of your truck capacity is actually used | =SUM(LoadedKm)/SUM(TotalKm) |
Tip: put the target next to every KPI card and colour it with conditional formatting (green on target, amber within 5%, red below). A number without a target is only information, not a signal.
How to lay out a supply chain dashboard
- Top row, the headline KPIs: OTIF, fill rate, inventory turns, freight cost per shipment and supplier on-time rate, each as a card with this month, last month and target.
- Middle, the trends: monthly line or column charts for service level, inventory value and freight spend. Trends show whether a fix is working.
- Bottom, the breakdowns: top suppliers by spend and lateness, cost by route or destination, stock by category. This is where you find out why a KPI moved.
- Left or top, the filters: slicers for month, warehouse, supplier, driver or customer, so one page answers many questions.
Keep it to one screen. If people have to scroll to find the problem, the dashboard is doing the job of a report.
How to build a supply chain KPI dashboard in Excel (step by step)
- Collect the raw data in one table. One row per order, shipment or purchase line with dates, quantities, costs, supplier, route and status. Format it as an Excel Table (Ctrl + T) so formulas and charts grow with new rows.
- Add helper columns. Late (Yes/No), Complete (Yes/No), Lead days, Month, so every KPI becomes a simple COUNTIFS or AVERAGEIFS.
- Calculate the KPIs on a separate sheet. One cell per KPI, with the target next to it. This keeps the dashboard sheet clean.
- Build PivotTables for the trends and breakdowns (by month, supplier, route), then insert PivotCharts.
- Add slicers and a timeline and connect them to every PivotTable (Report Connections), so one click filters the whole page.
-
Design the KPI cards with shapes linked to the KPI cells (select a shape, type
=and click the cell), and add conditional colours. - Refresh monthly: paste the new data into the table and press Data → Refresh All.
Want to see your own data as charts first? Upload an Excel or CSV file to the free dashboard maker and get an instant KPI view in your browser, then build the full version in Excel. You can also let AI write the formulas for you, as shown in how to build an Excel dashboard with AI.
Ready-made supply chain dashboard templates for Excel
If you would rather start from a finished design, these editable Excel templates already include the charts, slicers and KPI cards. Replace the sample data with yours:
- Supply Chain KPI Dashboard – Freight Analytics: monthly and YTD KPI cards, income vs expenses, truck and freight expense breakdowns, driver payroll, a destination map and the shipment cost settlement process.
- Vendor Spend Analysis Dashboard: purchase orders over time, requests and approvals, spend by category, Capex vs Opex, vendor profiles and risk and compliance tracking.
- Logistics & Transport Management Dashboard: total expenses and wages, cost-share gauges, trips by class and route, cargo types and a live log of the last ten trips.
- Enterprise Fleet Management Dashboard: fleet costs, utilization and vehicle performance for real operations.
- Cargo & Vessel Tracking Dashboard: international cargo flows on a trade map, with shipment and vessel analysis.
See them all in the supply chain dashboard templates collection, or browse every business area in KPI dashboard templates. If you want to practise with real numbers first, the supply chain and freight analytics dataset comes with the matching sample data.
Common mistakes to avoid
- Too many KPIs: 25 cards means nobody looks at any of them. Start with 5 to 8.
- No targets: every KPI needs a goal and a colour rule.
- Mixing definitions: agree in writing what "on time" means (promised date, or requested date?) before you measure it.
- Manual copy-paste every month: use an Excel Table and Refresh All, or Power Query if the data comes from several files.
- Only averages: an average lead time of 7 days can hide one supplier at 21 days. Always add a by-supplier or by-route breakdown.
FAQ
What KPIs should a supply chain dashboard include?
Start with OTIF, order fill rate, inventory turnover, freight cost per shipment and supplier on-time rate. They cover service, stock, cost and suppliers. Add cycle time, stock-outs and cash-to-cash once the basics are stable.
Can I build a supply chain dashboard in Excel without Power BI?
Yes. Excel Tables, PivotTables, slicers and conditional formatting are enough for most small and mid-size teams. Power BI becomes useful when the data lives in several live systems or many people need web access.
What is the difference between a supply chain metrics dashboard and a KPI dashboard?
KPIs are the few metrics tied to a target and a decision. A metrics dashboard shows the wider set of measurements behind them. A practical dashboard shows the KPIs first and the supporting metrics as breakdowns underneath.
How often should a supply chain dashboard be updated?
Weekly for operations (deliveries, stock-outs, fleet), monthly for management (costs, supplier scorecards, inventory turns). In Excel this is a paste-and-refresh job of a few minutes.
Is there a free supply chain dashboard template for Excel?
You can try the free dashboard maker with your own file, and practise with the free supply chain dataset. The full editable Excel templates listed above are available in the supply chain collection.
Share:
Build an Interactive Project Finance Dashboard in Excel Without VBA
Warehouse and Sales Dashboard in Excel: Map Charts and Ranking