Dashboard template

Throughput, delays and capacity, on the wall by 7am.

The operations page for the daily stand-up: what was produced or shipped yesterday against plan, what is late and why, where capacity is tight this week, and what each unit cost.

Operations KPIs

Throughput, delays and capacity on one wall.

Operations data is spread across an ERP, a warehouse or production system, a rota and a lot of spreadsheets. This template pulls the daily numbers from each into one page built for a screen on the wall — big figures at the top, causes underneath — so the morning meeting starts with the same facts for everyone.

It fits manufacturing lines, warehouses and fleets, and service operations that process orders, claims or cases. Swap the unit — pallets, units, jobs, cases — and the layout holds. Each site manager sees their own site; the operations director sees them ranked.

Planned figures usually live in a spreadsheet, so connect it: plan vs actual is the first chart on the page. Cost per unit needs the ledger, which is why finance systems appear in the source list below.

  • Plant, warehouse and depot managers who run a 15-minute daily stand-up from one screen.
  • Operations directors who want every site on one page, ranked, with the same definitions.
  • Finance partners who need cost per unit from the ledger next to output from the floor.
The metrics

What a operations kpis dashboard should show.

Each figure below is on the template from the first minute — rename, redefine or remove any of them.

Throughput

Units, orders, jobs or cases completed yesterday and week to date, against plan.

On time, in full

Orders delivered on the promised date with nothing missing ÷ orders delivered. The customer’s view of operations.

Cycle time

Median hours from order received to order complete, by product family or service type.

Capacity utilisation

Hours used ÷ hours available, by line, bay, vehicle or team. Under 70% and over 95% are both problems.

Backlog

Orders or jobs waiting, in age bands, valued where possible.

Defect or error rate

Rework, returns or corrections ÷ output, by cause. Quality shown next to volume so one is not traded for the other unnoticed.

Cost per unit

Direct labour, materials and overhead ÷ units, monthly, from the ledger.

Overtime hours

Overtime as a share of total hours, by team. The earliest sign that plan and capacity have drifted apart.

The panels

The charts on the page, and the decision each one supports.

Throughput vs plan by day

Bars for actual, a line for plan, 30 days. Shows whether a miss is one bad day or a trend that needs a capacity decision.

Delays by cause

Late orders by reason — materials, capacity, quality, customer change — as a ranked bar. Decides which fix gets the meeting’s attention.

Capacity by site and line

Utilisation per line, bay or team for the current and next week, colour-coded. Decides where to move work or people.

Backlog ageing

Waiting work by age band and site, with the oldest listed. Makes “we are a bit behind” a number.

Cost per unit trend

Monthly cost per unit split into labour, materials and overhead. Shows which component moved and when.

Exceptions today

A table of orders late, stopped or failed inspection, with owner and next step. The list that gets worked through before the meeting ends.

Where the numbers come from

Connect the systems you already run.

The template expects data like this. Connect it live or import it, relate the tables once, and every panel fills in.

See all 50+ connectors
SASAPNeNetSuiteMiMicrosoft DynamicsMiMicrosoft SQL ServerOrOracleMiMicrosoft ExcelGoGoogle SheetsREREST APIs
FAQ

Operations KPIs template questions.

Something else on your mind? Ask us directly — a person answers.

What KPIs belong on an operations dashboard?

Throughput against plan, on-time-in-full delivery, cycle time, capacity utilisation, backlog by age, defect rate and cost per unit. Seven is enough for a wall screen; put causes underneath, not more totals.

Can each site see only its own numbers?

Yes. A row-level rule on the site column gives every site manager their own view of the same dashboard, and head office a ranked view of all sites.

How often does it refresh?

Live connections to your ERP or production database update as the data changes; imported sources refresh on a schedule — every 15 minutes is common for a wall display.

Can we start from this template and change it?

Yes. Change the unit of output, add a shift split or a safety panel, and it becomes your own dashboard. The layout is a starting point, not a fixed report.

Your operations kpis dashboard, this week.

Bring your data and we'll set this template up on it live — then shape it around the questions you actually ask.

Talk to sales

Prefer to see plans first? See pricing

Contact usWhatsApp