Contact us

Case · Master data cleansing · Oil producer

30,000 MRO records cleansed and stock classified by ABC

An oil producer with two assets and a central warehouse in equatorial Africa asked us to bring its material master to one standard and prepare its stock for optimisation.

  • Oil producer
  • Equatorial Africa
  • 2023
  • 30,000 records
Discuss your catalogue Master data cleansing
  • 30,000MRO records cleansed
  • $0.5Mprocurement savings in 23 months
  • 2assets served by one central warehouse
  • ABCstock classes by consumption frequency and criticality

The task

A material master the warehouse can rely on

The client wanted clean data first, and then a way to rank stock by how often it is used and how critical it is for production, as the basis for inventory optimisation.

What we did

Cleansing and classification

  • 30,000 MRO records cleansed under the cleansing methodology and master data maintenance SOP developed for the project
  • Material criticality assessed together with production engineers
  • An ABC approach built on consumption frequency and criticality for production
  • Duplicates found and confirmed. A planned purchase was stopped because the items were already in stock under duplicate records

Scope

One catalogue, one warehouse

  • Oil producer with two assets
  • Central warehouse in equatorial Africa
  • 30,000 MRO records
  • Production engineers involved in the criticality assessment

Results

Procurement savings and a basis for inventory optimisation

  • Better data quality, search and identification of materials, spend reporting and procurement

  • $0.5M saved on procurement over 23 months by merging duplicates and making stock visible

  • A basis for inventory optimisation after the criticality assessment and ABC classification

Contact

Let's look at your material master

Tell us the size of your catalogue and your systems. We will propose a cleansing plan and the first steps.

  1. 1
    Task and systems

    What you have now and what you need

  2. 2
    Quick assessment

    Data, processes and IT landscape

  3. 3
    Work plan

    Stages, timeline and scope

0
200000
We use your details to respond to your request. See our Privacy Policy.