A shared MRO procurement register for multiple sites
Consolidate purchases of identical parts while retaining each site’s quantity, required date and receipt. A register example for checking units and measuring delivery performance.
Separate product records from demand rows
Combining maintenance, repair and operations needs from several sites requires more than joining spreadsheets. The product record holds the full code, revision, approved unit and documents. A demand row holds site, equipment, quantity, required date and recipient. Purchasing can then consolidate the same part while preserving who needs how much and when. Retain the change history for each demand row.
An illustrative unit-normalisation example
The quantities below are illustrative. Do not add kits to pieces until kit contents are confirmed. Even with the same code, verify revision and package contents separately.
| Site and demand | Normalisation decision |
|---|---|
| Site A: 2 pieces of an approved part | Link to product record and required date |
| Site B: 3 pieces of the same part | After compatibility confirmation, purchase 5 pieces; retain separate receipts |
| Site C: 1 kit | Keep a separate row until contents are clarified |
Preserve substitution and receipt history
Technical approval of an alternative belongs to a specific product record and application. Approval at one site does not automatically cover the entire fleet. After approval, connect order stages, packaging and receipt documents to the demand rows. Partial delivery should leave the outstanding requirement visible. Where serial or batch identification is needed, add it to the receipt record; a shared delivery-note number does not replace individual product identity.
Measure results against agreed definitions
When evaluating lead time, define its starting event: receipt of an incomplete enquiry or technical approval. Measuring on-time, complete delivery requires requested date, receipt date and open quantity. Track returns caused by incorrect identification separately. Assess savings for the same purchasing scope and comparison period; measure supply reliability against requirements fulfilled by their agreed dates. The register makes the decision, remaining demand and next responsible action visible.
Industrial supply enquiry
Plan equipment selection, spare parts, procurement and delivery around your production requirements.
Explore the technologies
Putting it into practice
- Fasteners for operating trusts
- 3-year centralised procurement
- Electrical and mechanical goods
- 3-year head-office supply programme
SOCAR: maintenance supply programmes
Recurring supply for SOCAR units: fasteners, electrical and mechanical goods under three-year programmes, plus seals and pumps for individual enterprises.
Model + serial number
Location + function
Full code + revision
A complete identification card for industrial spare parts
Bring the full part number, drawing revision and application into one card. Add the information specific to bearings, chains or seals and define how alternatives will be approved.