Supply chain dashboards and demand planning KPIs that refresh themselves
We build the dashboards your planning process needs to work: inventory, forecast accuracy, service and plan adherence. Connected to the ERP, with agreed definitions and in the tool you already use, Power BI or Excel.
- Power BI or Excel
- Connected to the ERP or scheduled extracts
- Automatic refresh
- Documented KPI definitions
The problem they solve
Almost every company has inventory reports. Few have an inventory dashboard that answers planning questions without opening three files: how many days of coverage do I have per family? Which items are at risk of stock-out next month? How much capital is tied up in SKUs with no turnover? Did last cycle's forecast hit?
The typical report is assembled by hand on Monday, each area computes coverage its own way and the S&OP meeting is spent arguing about which number is right. A well-built dashboard ends that argument: one definition per KPI, one data source and a refresh that depends on nobody.
Which dashboards we build
Inventory dashboard
Coverage in days and money, turns, excess and obsolescence, stock-out risk by item and family, with threshold alerts.
Forecast accuracy
MAPE, WAPE and bias by item, family, customer and planner, cycle after cycle. Where the forecast misses and in which direction.
S&OP dashboard
Demand plan versus actual, supply plan versus executed and adherence to the approved plan. What the executive meeting needs to see on one screen.
Customer service
Fill rate, OTIF and backorders by customer and channel, crossed with the inventory that explains them.
Working capital
Valued inventory by category, stock age and coverage projection with the approved forecast.
Tailored
If your process needs a view that is not here, we design it with you. What matters is that it answers a decision question.
The KPIs we include, with their definition
| KPI | What it measures | Question it answers |
|---|---|---|
| Coverage (days) | Available inventory divided by forecast daily demand | How many days will what I have last? |
| Turns | Annual cost of sales divided by average inventory | How many times a year does stock renew? |
| Excess and obsolescence | Inventory above target coverage or with no sales in N months | How much capital is tied up? |
| MAPE / WAPE | Percentage forecast error, simple or volume-weighted | How well do we forecast? |
| Bias | Signed error: whether the forecast runs systematically high or low | Do we always miss in the same direction? |
| Fill rate | Units delivered over units ordered | What share of demand do we serve? |
| OTIF | Complete and on-time orders over total orders | Do we deliver what we promised? |
| Plan adherence | Executed over approved in the S&OP cycle | Do we do what we decided? |
Exact formulas are agreed with you at the start and documented inside the dashboard.
How we work
Questions before charts
We define with each area which decisions it makes and what it needs to see to make them. The KPI list comes from there, not from a generic catalog.
Data and definitions
We connect the ERP (or scheduled extracts), agree the formula of each indicator and validate the numbers against what you compute by hand today.
Build
Data model, measures and visuals in Power BI or Excel. Views by level: leadership, planning and operations, with drill-down by family, customer and item.
Delivery and adoption
Automatic refresh, documentation of every KPI and team training. A dashboard nobody opens is a badly designed dashboard; we measure that it is used.
Frequently asked questions
Power BI or Excel?
It depends on who will use it and which licenses you have. Power BI for dashboards shared with many users, drill-down and scheduled refresh. Excel when the team is small, already lives there and needs to cross the dashboard with its own work. In both cases the data model is the same.
Which ERP do you connect to?
Any from which sales, inventory and orders can be extracted on a schedule: SAP, Oracle, Microsoft Dynamics, Odoo, local systems or your own database. If today you only have exported files, that also works to start.
How long does it take?
An inventory dashboard with agreed definitions and ERP connection is usually in use within a few weeks. What takes longest is not the chart but agreeing definitions and cleaning master data. The diagnosis gives you a concrete calendar.
Does it include the forecast?
The accuracy dashboard needs a forecast to measure. If you already have one, we connect it. If not, we generate it with ForecastSolve or DemandSolve, which also save every cycle so the comparison against actuals is automatic.
What happens when my data or catalog changes?
The model is built on master data, so new items, families and customers flow in on their own. When the structure changes (a new hierarchy, another warehouse), we adjust the model; that is why we document it.
Still assembling the inventory report by hand?
Tell us which questions you need answered every week. We will propose the dashboard and the path to connect it to your data.
Book 15 minutes →