5 Steps to Getting on the Right Track in MRO Inventory Management
- Strategic Account Director
The common catch phase is that data is the new oil. I disagree. Oil can be stored data must be used or it …
VIEW PROFILE
In June 2018, I was invited to speak at the UK Manufacturing and Supply Chain Conference in Coventry on the Subject of MRO Inventory Management. Based on the standing room only, it was obvious from the start that this is a growing pain for organisations, large and small.
My focus was not to solve all MRO Inventory Management issues in one foul swoop though. Rather, I wanted to show how organisations could take some light touch, manageable steps to reduce MRO inventory levels and costs while maintaining their maintenance SLAs and downtime KPIs.
Put another way, how to use Advanced Analytics to drive usable insights and visual outputs to help move from ‘trench warfare’ to meaningful collaboration between Finance, Maintenance and Asset Management.
The premise of my talk was that there is some middle ground between advanced MRO spare parts optimisation and the typical minimum or maximum levels of stock.
The main attendees came from Utilities, Logistics and Heavy Manufacturing and they actually all had very similar challenges.
How can we balance the competing goals of maximising our working capital and minimising the risk of downtime due to stock outs?
- How can we identify current obsolete stock? How can we monitor when stock is going to become obsolete? How can we identify what we can remove from our warehouse and balance sheet?
- How can we improve our data quality to include things such as asset criticality?
- How can we get a clear picture of our current MRO stock levels, segmented by stock types, SKUs or location to help us to understand optimum strategies for each?
- How can we look at unusual behaviours to ensure we are alerted to stock out risks or inefficient buying behaviour that is costing us money?
- Ultimately, how can we get decision support information that all different parties can agree on?
Getting MRO Inventory Management Right
Traditionally MRO Inventory Management has been based on gut feel, experience and complex spreadsheets. Centralised Asset Management Systems such as IBM Maximo, store the relevant data (often in very poor quality), but cannot analyse or present it in a way that the business can use to deliver the maintenance required and the optimum stock levels.
Advanced Analytics:
– offers an insight driven approach that delivers outputs through easy to consume visual dashboards,
– delivers an ongoing process rather than a one-time snapshot of your inventory data,
– provides for immediate results to identify and remove obsolete stock and
– enables an on-going capability to maintain your optimal levels of different MRO inventory and improve data quality where required for better and more accurate insights.
Front and centre to the success or failure of a solution is gaining buy-in and trust from all the stakeholders involved. For Finance this means showing that inventory optimisation is not the same as inventory reduction. For operations this means showing clear evidence that inventory reduction will not increase risk of a stock out.
So how can Advanced Analytics bring the right mix of inventory to deliver both cost effectiveness and the highest performance for maintenance?
1. Help in defining what is critical – In a certain Utility, classifying stock items based on recency and frequency allowed them to immediately identify non-moving stock and then use the SKU value to get to work creating a criticality index. This was then added to the analysis. In doing so, they considered the risks and costs associated from a stock out of each non-moving spare part. The impact of downtime on the business and the work around options were investigated, which delivered an accurate criticality for each item.
2. Current inventory segmentation – You can plan and establish inventory control per category and set different strategies, based on lead time, criticality, movement frequency, insurance items, cost, etc. The ability to drill down and segment your stock helps ensure that appropriate policies are applied consistently. Not all spare parts will be managed in the same way. Segmentation will also help focus clear ownership and discussions with the relevant stake holders.
3. Reduce current and future obsolete stock – Visualising the stock usage history, you can quickly see which parts are non-moving, remove the non-critical parts and, on an on-going basis, monitor which parts are becoming obsolete. This can also take into consideration changes of equipment and machinery.
4. Demand forecasting for slow, seasonal and lumpy demand items – As much as 90% of MRO inventory can be defined as slow moving, so it’s important that forecasts for demand also take lead time and irregular usage patterns into account.
5. True Collaboration to achieve business results – All Advanced Analytics initiative come to nought unless the business owner uses the outputs. A critical point raised several times at my talk was that people had seen the technology as “Black Box” where the maintenance operators ignored the outputs because they couldn’t understand the logic behind them. Insights displayed in an “easy to use” format are critical in getting buy-in from the different stakeholders, each with their own respective KPIs.
An interesting point raised by one participant was that they see the MRO Inventory Management as the first step in their journey to full Predictive Maintenance. Given the limited data required to deliver MRO spare parts optimisation and the significant ROI that can be achieved, this is a space that looks set for explosive growth.
More Analytics Blog Posts
Read more >>
Read more >>
- SPSS Statistics Version 26 includes new statistical tests, enhancements to existing statistics and scripting procedures…Read more >>
- Top tips and tricks for running ANOVA and non-parametric tests along with more advanced forms…Read more >>
- SPSS Statistics Version 26 includes new statistical tests, enhancements to existing statistics and scripting procedures…Read more >>
- Healthcare systems face multiple challenges, including ageing populations, evolving healthcare needs and rising costs. Tailored…Read more >>
- Forecasting predicts future values of a particular quantity based on previously observed values of that…Read more >>
- Alan shows you how identify new, data driven, re-order points for your stock items that…Read more >>
- In this short video you will learn how to run a Time Series model within…Read more >>
- Alan now looks more closely at the quality of information you hold on your inventory.…Read more >>
- Alan takes you through the Smart Inventory Management interactive dashboard, showcasing an overview of your…Read more >>
- In this third video, Alan shows you how to extract the key findings from a…Read more >>
- Join us at the Technology Event of the Year! Watch Rob McCullagh present Presidion’s innovative…Read more >>
- This second video concentrates on using Hold-out samples to create more robust predictive models. In…Read more >>
- SPSS is a fully customisable analytical software. Due to the highly flexible nature of SPSS…Read more >>
- In this video, the first of a series, Alan takes you through running a Decision…Read more >>
- If you have ever found that your company has engaged with Analytics initiatives that have…Read more >>
- In the 4th video of our series you will learn how to build stacked tables,…Read more >>
- In this video you will learn how to tailor your tables, run T-test & create…Read more >>
- In June 2018, I was invited to speak at the UK Manufacturing and Supply Chain…Read more >>
- In this video you will learn how to protect respondent's identity and boost the statistical…Read more >>
- Best practices and key considerations before, during and after deploying an analytical initiative to maximise…Read more >>
- In the first video of the IBM SPSS Custom Tables series you will learn: How…Read more >>
- I’ve often seen analytics described primarily by way of the technical complexity of the techniques.…Read more >>
- Being able to effectively measure a RoI on the back of an Advanced Analytics project…Read more >>
- Throughout industries analytics has taken on an almost ubiquitous nature of late. There are increasing…Read more >>
- Analytics is being discussed more and more often in top table conversations, but why do…Read more >>
- Watch Pierre Baviera speaking at “Demystifying Data” Business Breakfast at the Imperial Hotel (Cork), in…Read more >>
- A 3 step process to Understand, Assess and Audit your Data for Advanced Analytics.Read more >>
- Presidion’s Framework Approach for a Technology Review involves a 3 step process, leading to the…Read more >>
- With inspirational quotes from Data and Analytics gurus worldwide.Read more >>
- Take the Analytical Maturity model presented in Thomas Davenport’s “Competing on Analytics”. Would you consider…Read more >>
- There are times when deploying advanced analytics initiatives can feel like you are in a…Read more >>
- After our last A4B “War Stories - Data Analyst Down”, we asked the keynote speaker,…Read more >>
- The truth is that there are many factors and forces at work that help build…Read more >>
- While I’m not sure this statement is true when referring to people, I really believe…Read more >>
- As I observe and read about the raging fires causing massive destruction, I have been…Read more >>
- After our last A4B we asked the keynote speaker, Anthony O’Neill (Director, Analytics Centre of…Read more >>
- The science and psychology to get the 'Bikini Body' you have always wanted (with Predictive…Read more >>
- The reasons behind, and some hints to help you during difficult conversations and challenging situations!Read more >>
- When you start with Analytics you might feel overwhelmed, you have all that incredible power…Read more >>
- Preventative and Conditional Maintenance are often mistaken with Predictive Maintenance. This animation gives you an…Read more >>
- Reports from the insurance industry consistently highlight that the quality of customer experience remains the…Read more >>
- Unlike the consumer sector, manufacturers have been using IoT for years. Properly focused IoT capabilities…Read more >>
- The World is going through the Digital Revolution. What does it practically mean? Well, it…Read more >>
- Does your organisation struggle with understanding how to use analytics? These days it is not…Read more >>
- As a CEO, it’s important that you not just have some good one liners to…Read more >>
- Predictive Maintenance, the modern approach to maintenance that maximises productivity while reducing overall costs.Read more >>
- It is a truism that business need to win new customers and retain existing customers.…Read more >>
- Oil and Gas companies are borrowing from data rich industries to transform their maintenance procedures.…Read more >>
- Will the reign of terror ever end? Can we fight ISIS? Here are the tangible…Read more >>
- Answers to key questions and tips for creating a clear strategy to deliver Big Insights…Read more >>
- More often than not predictive analytics projects represent unfulfilled potential. Is your next project doomed…Read more >>
- Using asset specific data to predict where, when and why a specific asset will fail…Read more >>
- Can one of the most common applications in Retail sector (Market Basket Analysis), determine Next…Read more >>
- With the explosion of Big Data in the past few years there has been a…Read more >>
- One of the most important elements of any data analytics project within any business is…Read more >>
- How many times do you have to be told something before you believe it? Do…Read more >>
- Do you think you are a “good” Analyst? Are there certain traits, attributes and qualities…Read more >>
- Good predictive models take the time and experience of skilled analysts to develop. How do…Read more >>
- We hear that “Data is the new Oil” but how do you extract real value…Read more >>
- Fraud in organizations can be epidemic if not curbed at the inception. According to a…Read more >>
- Were you ever faced with identifying insights from open ended text data? From call center…Read more >>
- The Irish playwright was on the money - no matter what way you look at…Read more >>
- There are two certainties in life, death and taxes. This proverb rings true especially for…Read more >>