An ERP produces thousands of numbers. A management team needs about a dozen, read every week, with the same definitions every time. A KPI (key performance indicator) is one of those: a measure that tells you whether a part of the business is getting better or worse, and that someone owns.
This article gives the KPIs consultants set up first in a trading or manufacturing company, the formula for each, and where to read or calculate it in Voltrus. Where Voltrus does not show a KPI directly, it says so and shows how to compute it from an export.
Rules for good KPIs
- Defined once, in writing. "Inventory turns" means nothing until you agree whether it uses cost or sales value, and average or closing stock.
- Owned by one person, who explains the movement each week.
- Read as a trend. One month's figure tells you little; twelve months tell you a lot. Record each month's value in a simple table.
- Few. If everything is a KPI, nothing is.
Cash and working capital
Working capital is the cash tied up in running the business: receivables plus inventory minus payables. These are usually the first KPIs to improve after an ERP go-live, because the data finally becomes reliable.
| KPI | Formula | Good direction |
|---|---|---|
| DSO (days sales outstanding) | Accounts receivable ÷ revenue for the period × days in period | Down |
| DPO (days payables outstanding) | Accounts payable ÷ cost of goods sold for the period × days in period | Stable, within agreed terms |
| DIO (days inventory outstanding) | Inventory value ÷ cost of goods sold for the period × days in period | Down |
| Cash conversion cycle | DSO + DIO − DPO | Down |
| Overdue receivables % | Overdue AR ÷ total AR | Down |
Worked example, for a quarter of 90 days:
| Figure | Value |
|---|---|
| Revenue (quarter) | 3,000,000,000 |
| Cost of goods sold (quarter) | 2,100,000,000 |
| Accounts receivable (end) | 1,200,000,000 |
| Inventory (end) | 1,400,000,000 |
| Accounts payable (end) | 700,000,000 |
| DSO = 1,200 ÷ 3,000 × 90 | 36 days |
| DIO = 1,400 ÷ 2,100 × 90 | 60 days |
| DPO = 700 ÷ 2,100 × 90 | 30 days |
| Cash conversion cycle = 36 + 60 − 30 | 66 days |
Every rupiah of sales is out of the company's hands for 66 days. Cutting DIO by 15 days frees about 350 million of cash (2,100,000,000 ÷ 90 × 15) without selling anything more.
Profitability
| KPI | Formula | Where in Voltrus |
|---|---|---|
| Gross margin % | (Revenue − COGS) ÷ revenue | Income statement on Financial statements |
| Operating margin % | Operating profit ÷ revenue | Income statement |
| Margin by department or project | (Revenue − expense) ÷ revenue, per cost centre or project | P&L by cost centre or project |
| Budget variance | Actual − budget, per account and cost centre | Budget vs actual |
| Production variance | Actual work order cost − standard output value | Work order cost panel; variance account 5-9000 on the statements |
Gross margin is only as good as your inventory costing. If the margin jumps around from month to month, check item costs and the variance account before celebrating or panicking. See Inventory valuation and Product costing, WIP and variances.
Inventory
| KPI | Formula | Where in Voltrus |
|---|---|---|
| Inventory turns | COGS for 12 months ÷ average inventory value | COGS from the income statement; inventory from Stock → Valuation (valuation as of any date) |
| Slow-moving and dead stock value | Value of items with no issue in 90 / 180+ days | Stock → Valuation → Slow-moving |
| Inventory record accuracy | Count lines within tolerance ÷ count lines counted | Posted stock counts and the Stock → Cycle counting tab |
| Items below reorder point | Count of items whose on-hand is below the reorder point | Dashboard and Stock |
Inventory record accuracy is the KPI that decides whether MRP can be trusted. World-class operations run above 95% of count lines within tolerance; below 90%, planners stop believing the system and go back to spreadsheets. Count by ABC class (Voltrus schedules A items 12 times a year, B 4 times, C once) and record accuracy per count.
Sales and service
| KPI | Formula | How to get it |
|---|---|---|
| On-time delivery (OTD) | Order lines shipped on or before the promised date ÷ lines shipped | Sales order lines carry a promised date and delivery orders a ship date. There is no OTD report yet: export delivery orders and order lines to Excel and compare. |
| Order backlog | Value of confirmed sales orders not yet shipped | Sales orders filtered to confirmed; Finance → Overview shows open sales orders by age |
| Quote conversion rate | Quotations converted ÷ quotations sent | Sales quotations filtered by status |
Purchasing and suppliers
| KPI | Formula | How to get it |
|---|---|---|
| Supplier on-time delivery | Receipts on or before the PO expected date ÷ receipts | POs carry an expected date; compare it with receipt dates in an export. No report on screen yet. |
| GRNI age | Value of goods received but not billed, older than 30 days | The month-end checklist flags old Received, not billed items |
| Open purchase orders by age | Count and value of approved POs not yet received | Finance → Overview; Dashboard Purchase orders to receive |
Production and maintenance
| KPI | Formula | Where in Voltrus |
|---|---|---|
| Work order schedule adherence | Work orders done by their due date ÷ work orders done | Work orders list (export and compare); Dashboard shows work orders due this week |
| Production variance % | Cost variance ÷ standard output value | Work order cost panel per order |
| PM compliance | Preventive maintenance jobs done by due date ÷ PM jobs due | Maintenance (overdue first); the Dashboard shows overdue maintenance |
A weekly KPI routine
- Monday morning, each owner updates their figures in one shared sheet (or, better, reads them from the screens above).
- Thirty minutes of management meeting: only the KPIs that moved the wrong way, each explained by its owner, each with one action and a date.
- Actions are logged as activities on the relevant Voltrus records (the overdue customer, the late supplier's PO), so they are followed up where the work happens.
Checklist
- Write down the definition and owner of each KPI you adopt.
- Record twelve months of history as soon as Voltrus has it, to read trends.
- Schedule the stock-below-reorder and finance journal reports to the people who own those numbers.
- Review inventory record accuracy before trusting MRP suggestions.