Professional Template
Materials KPI Register
Definition, formula, target, actual, variance, owner and review frequency.
Recommended Fields
Use a controlled item or master-data key, transaction date, responsible function, source document and review status. Add fields only where they support the management decision.
| Field Group | Typical Controls |
|---|---|
| Master Data | Item code, description, UOM, category, criticality, location |
| Transaction Data | Date, document number, quantity, rate/value, supplier/customer |
| Control Data | Owner, status, due date, variance, action, closure date |
| Management Data | KPI, target, actual, exception, priority, review frequency |
Control Principle
The template should support a decision, not merely store data. Define the business rule, source transaction, responsible owner and escalation condition before operational use.