Solutions
Synopps software: one engine, three modules for master data tasks
Academy
Master data training built on real project practice
MRO materials and spare parts for equipment maintenance
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.
Material stock level
Min, max and safety stock are calculated from consumption, lead time and material criticality.
Results
A balance between having the materials needed for uninterrupted operation and the cost of buying and storing them.
With optimal replenishment parameters, inventory falls by 15 to 20%. Turnover grows, working capital is released and storage costs go down.
When production criticality is built into inventory management, the service level rises to 95 to 99%. Every critical material is available to production.
Optimal inventory parameters cut equipment downtime caused by missing materials and spare parts.
A reliable model removes unnecessary purchases worth 7 to 10% of the annual budget. You buy only what is really needed.
Specifics
Methods for trade stock rely on regular demand. Demand for maintenance materials works differently, and the calculation takes this into account.
Equipment data, its hierarchy and criticality are prepared in a separate project: equipment master data for EAM.
How the work goes
From the ERP data extract to processes where procurement runs on calculated parameters.
01Step
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.
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
02Step
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.
| Criticality | |||
|---|---|---|---|
| High | Medium | Low | |
| High demand | A | A | B |
| Low demand | A | B | C |
| No demand | A | C | C |
03Step
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.
Demand
1How to order
order on requestreorder point: go on
Cost and lead times
2Model by turnover speed
04Step
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
Production suffers from stock-outs and downtime
Optimal processprocurement: an analytical team
A warehouse with less stock, a balanced service level, no stock-outs or downtime
05Step
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.
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
warehouse value, change from the start
Get a free assessment of your dataContact us and we will help you assess your initiative.
Assess my dataTrack record
A completed project: from scattered manual work to procurement on calculated parameters.
Client
What we did
Our clients include
FAQ
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.
Any organisation that holds warehouse stock and uses consumable materials for production. Optimisation cuts costs, prevents disruptions and improves operational efficiency.
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.
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.
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.
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.
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.
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.
A typical project takes 3 to 4 months, but the timeline depends on your business and your requirements.
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 cleansingFree assessment
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.
Excel from your ERP
Data quality, criticality, ABC
Approach, timeline and cost