MRO materials and spare parts for equipment maintenance

MRO inventory and procurement optimisation

A project after which critical materials and spare parts are in stock and nothing unnecessary is bought. For each material we calculate criticality, the reorder point and min/max levels, build the calculation into the procurement process and cut excess and above-norm stock.

  • Criticality assessment and ABC matrix
  • Reorder point and reorder quantity
  • Min/max levels for each material
  • Procurement processes driven by the parameters

Material stock level

  • max
  • min, reorder point
  • safety stock
  • order
  • lead time

Min, max and safety stock are calculated from consumption, lead time and material criticality.

Results

What inventory optimisation delivers

A balance between having the materials needed for uninterrupted operation and the cost of buying and storing them.

  • −15 to 20%

    Less excess stock

    With optimal replenishment parameters, inventory falls by 15 to 20%. Turnover grows, working capital is released and storage costs go down.

  • 95 to 99%

    Fewer stock-outs

    When production criticality is built into inventory management, the service level rises to 95 to 99%. Every critical material is available to production.

  • no downtime

    Continuous production

    Optimal inventory parameters cut equipment downtime caused by missing materials and spare parts.

  • 7 to 10%

    Lower procurement budget

    A reliable model removes unnecessary purchases worth 7 to 10% of the annual budget. You buy only what is really needed.

Specifics

How MRO and spare parts inventory differs from trade stock

Methods for trade stock rely on regular demand. Demand for maintenance materials works differently, and the calculation takes this into account.

  • Rare and irregular consumptionA spare part can sit for a year without movement and then be needed at once. For slow movers we use dedicated models, not formulas built for regular demand.
  • The cost of a stock-out: downtimeHow much to hold depends not only on demand but on criticality: what happens to production and safety if the item is missing.
  • Long lead timesWe use actual times from request to receipt and account for their spread.
  • Demand comes from maintenanceThe input comes from the maintenance team, not from sales: expected need under the repair plan and the criticality of spare parts.
  • Duplicates in the material masterOne spare part under different names splits the consumption history and hides stock. We merge the history of duplicates before the calculation.

Equipment data, its hierarchy and criticality are prepared in a separate project: equipment master data for EAM.

How the work goes

Five steps of inventory optimisation

From the ERP data extract to processes where procurement runs on calculated parameters.

  1. 1Data preparationExtract and transform ERP data for analysis and input into the model
  2. 2Criticality and ABCABC matrix: order a material automatically or on request
  3. 3Parameter calculationOptimisation model and min/max levels for each material
  4. 4Process changeAnalytical models built into company processes with your business specifics
  5. 5Inventory reductionProcurement savings with a higher service level

The optimisation steps in detail

  1. 01Step

    Preparing the input data for the model

    We transform and consolidate ERP data to improve its quality and the reliability of the analysis. We calculate actual lead times and consumption, remove outliers and merge the history of duplicates.

    From ERP data to model inputs

    Lead times

    Request date and receipt date for each material

    Average lead time and standard deviation

    Consumption history

    Consumption dates and quantities over the period

    Monthly consumption, average and standard deviation

    Removing outliers

    Min = Q1 − 1.5×(Q3 − Q1)Max = Q3 + 1.5×(Q3 − Q1)Q1 and Q3: first and third quartiles

    Handling duplicates

    Duplicate 11001

    Duplicate 20101

    Total1102

  2. 02Step

    Criticality assessment and ABC classification

    We assess the criticality of each material and build an ABC matrix by criticality and demand. The class decides whether the material is ordered automatically or on request.

    • High criticalitya shortage stops production or affects occupational, industrial or environmental safety
    • Medium criticalityproduction does not stop, but output or quality falls
    • Low criticalitya shortage has no significant effect on production or safety
    ABC matrix: criticality and demand
    Material class by criticality and demand
    Criticality
    HighMediumLow
    High demandAAB
    Low demandABC
    No demandACC
    • AAvoid stock-outs: replenishment via the reorder point
    • BWith high demand and low criticality, we decide whether the material goes into A or B
    • CBought only on request and not held in stock
  3. 03Step

    Inventory parameters calculated with proven models

    For each material we answer two questions. We use analytical models, run the calculations and build them into one inventory management concept. The calculation runs in Synopps' own tool, and the parameters are passed to your ERP.

    1. Replenish the material automatically or order it on request?
    2. What are the optimal reorder point and reorder quantity?
    Inventory parameter modeltwo decisions for each material
    inputscalculationresultExpectedconsumptionHistory ofconsumptionExpertopinionPlanned demandDemand forecastExpertopinionCriticalityfor the businessFrequency ofconsumptionABC-classificationOrder on requestServicelevelProcurementcostsOrder costCostof capitalOrder historyLead timeforecastPurchase historyAverage priceDedicatedmodelsTraditionalmodelsMin/max levels12order on requestreorderpointslow moversfast movers12
    1. Demand

      Expected consumption
      Planned demand
      Consumption historyExpert opinion
      Demand forecast
      Planned demandDemand forecast
      Consumption frequency
    2. 1How to order

      Expert opinionBusiness criticalityConsumption frequency
      ABC classification

      order on requestreorder point: go on

    3. Cost and lead times

      Procurement costs
      Order cost
      Order history
      Lead time forecast
      Purchase history
      Average price
      Service levelCost of capital
    4. 2Model by turnover speed

      slow: dedicated modelsfast: traditional models
      Min/max levels
  4. 04Step

    Inventory management processes in the company

    We design processes that keep inventory optimal and balanced. Analytics is built into the process and draws on international best practice and your business specifics. The procurement team moves from transactional to analytical.

    Typical processprocurement: a transactional team

    1. 1Maintenance requests the spare parts it needs
    2. 2Procurement buys what maintenance requested
    3. 3Excess builds up in the warehouse with an unbalanced service level

    Production suffers from stock-outs and downtime

    Optimal processprocurement: an analytical team

    1. 1Maintenance shares expected demand and spare part criticality
    2. 2Procurement calculates inventory parameters in Synopps
    3. 3Purchases follow optimal parameters and reorder levels

    A warehouse with less stock, a balanced service level, no stock-outs or downtime

  5. 05Step

    Inventory down 20% with a higher service level

    First we buy the critical materials that were missing, and the service level rises. Then warehouse value falls because the excess is no longer bought.

    Warehouse value by month after the projectchange from the start

    100%warehouse value before the project

    +7%purchases in month 2 to raise the service level from 56% to 96%

    −10%after one year, at a 96% service level

    −20%after two years, at the same service level

    service level

    56%96%96%96%

    warehouse value, change from the start

    months after the inventory optimisation project

Get a free assessment of your dataContact us and we will help you assess your initiative.

Assess my data

Track record

Inventory optimisation for a gold mining company

A completed project: from scattered manual work to procurement on calculated parameters.

Client

  • Severe shortages and excess stock at the same time: an expensive warehouse and unavailable equipment
  • No alignment between maintenance and procurement
  • Inventory management processes were not formalised and were done by hand

What we did

  • Introduced procurement automation tools for replenishment and material creation
  • The maintenance team started providing an annual demand forecast and material criticality
  • The procurement team moved to calculating the correct replenishment level
  • −21%of working capital in the first year
  • +19%service level for the most critical materials
  • 11 weeksand the client team is fully trained and works on its own

Our clients include

  • Nornickel
  • Nordgold
  • Highland Gold
  • Tiger Realm Coal
  • Vale
  • Shell
  • Statoil
  • Weatherford
  • Trident Energy

More projects

FAQ

Inventory optimisation: frequently asked questions

What is inventory optimisation?

Inventory optimisation is the process of managing the supply of materials to the warehouse efficiently. The goal is a balance between enough stock for uninterrupted operation and minimal storage costs. Benefits: lower storage costs, no stock-outs or downtime, better procurement and better maintenance. Methods: demand forecasting, ABC analysis, EOQ calculation and data analysis.

Who needs inventory optimisation?

Any organisation that holds warehouse stock and uses consumable materials for production. Optimisation cuts costs, prevents disruptions and improves operational efficiency.

How is MRO and spare parts inventory different from trade stock?

Spare parts and MRO materials have rare and irregular consumption and long lead times, and a stock-out means equipment downtime. So besides demand we take into account material criticality, actual lead times and the repair plan, and use dedicated models for slow movers.

What do we do with excess and obsolete stock?

The calculation shows which items sit above the maximum and which belong to class C, meaning they are bought only on request. These items are no longer replenished automatically. The company decides what to do with the remaining stock: use it, move it between warehouses or sell it. We prepare a list of items with quantities and values.

Is inventory optimisation the same as setting stock norms?

Setting norms gives a stock norm for each material. In an optimisation project the norm is calculated: the reorder point and min/max levels from demand, lead times, criticality and holding cost. Replenishment then follows these parameters.

Do you work with SAP?

Yes. We take an extract from SAP or another ERP, and pass the calculated min/max levels and reorder points back to the system, where replenishment runs on them.

How is this different from equipment master data?

Equipment master data prepares data about equipment for EAM: hierarchy, data sheets, equipment criticality. Inventory optimisation answers a different question: which materials and spare parts to hold and in what quantity. Equipment criticality helps assess the criticality of its spare parts.

How do we send you our data?

Send your data to info@synopps.com with a short description of the task, and we will propose a possible solution. An Excel extract from your corporate system is enough. The minimum is the item description with its attributes.

How long does inventory optimisation take?

A typical project takes 3 to 4 months, but the timeline depends on your business and your requirements.

How do you keep data confidential?

We follow our privacy policy and are ready to sign an NDA for every project or data assessment.

Duplicates in the material master distort the consumption historyBefore calculating parameters, the material master should be put in order.

Master data cleansing

Free assessment

We will assess your data for free

Send a request or email an Excel extract from your corporate system to info@synopps.com with a short description of the task. We will assess the data and propose an approach.

  1. 1
    Extract

    Excel from your ERP

  2. 2
    Data assessment

    Data quality, criticality, ABC

  3. 3
    Proposal

    Approach, timeline and cost

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