5 Steps to Getting on the Right Track in MRO Inventory Management
Inventory Management is a concern for many organisations, large and small. As experts in analytics, we can show you how organisations can 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.
Utilities, Logistics and Heavy Manufacturing all have 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.
- 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 initiatives 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.
MRO Inventory Management is the first step in the 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.
Version 1’s experienced consultants are on hand to help you understand your SPSS needs – from consultancy and training to finding the best software and license type for your analytical and usage requirements. Contact us to discuss your requirement and identify the best SPSS solution for you.
Take a look through our SPSS Articles covering a broad range of SPSS product and data analytics topics.
The Value of Codebook in IBM SPSS Statistics
Codebook is a valuable resource that presents a comprehensive overview of dictionary information about variables and multiple response sets within a dataset. It contains crucial data details, such as variable names, variable labels, variable types, value labels, missing values, and summary statistics. The summary statistics for nominal and ordinal variables and multiple response sets include counts and percentages, while the summary statistics for scale variables comprise mean, standard deviation, and quartiles.
What’s New in SPSS Statistics v29.0.1?
SPSS Statistics v29.0.1 was launched in April 2023 with the inclusion of the Overview Tab functionality, as part of the SPSS Base module. This post will take a high-level look at these changes plus cover off the key enhancements in v29.0.1.
What’s New in IBM SPSS Statistics v29?
Looking to quickly learn what’s new in IBM SPSS Statistics 29? Rather than reading a list of changes and new procedures, there is a quick way to tour what’s new and access help. Read our post for more info.
What’s New in SPSS Statistics v27?
SPSS Statistics v27 was launched in June 2020 with the biggest change compared to v26 being the inclusion of Data Preparation and Bootstrapping as standard functionality, as part of the SPSS Base module. This post will take a high-level look at these changes plus cover off the key enhancements in v27.
Fixing the Models that COVID Broke
Models are expected to degrade over time – no model lasts forever. With COVID-19, this has just happened more quickly and more radically than before. This post summarises a few tips on how you can ‘fix’ the models COVID-19 broke.
Internal Fraud Can Erode Organisations – Predictive Analytics to the Rescue!
If fraud occurs in an organization, salvaging the situation is paramount. How can this be done? The answer is Predictive Analytics! Read our blog post to find out more.
What’s new in IBM SPSS Statistics Version 26
IBM SPSS Statistics Version 26 includes new statistical tests, enhancements to existing statistics and scripting procedures, and new production facility capabilities. Read our post to find out more.
Infographic: Advanced Analytics for Healthcare
Healthcare systems face multiple challenges, including ageing populations, evolving healthcare needs and rising costs. Take a look at our Infographic on Advance Analytics for Healthcare for more information.
Lost in Translation? 8 tips so Multi-Lingual Text Analytics isn’t too scary!
Were you ever faced with identifying insights from open ended text data? From call centre notes, open ended questions on surveys, complaint letters, and/or online reviews? Read our blog to find out more.
Infographic: What is Forecasting?
What is Forecasting? Take a look at our Infographic on Data Audit: Advanced Analytics for more information.
How to Choose the Right SPSS License for You
Are you a super user fully emerged in analytics, a lone wolf carrying the load, or someone who dabbles in the odd analytics project? Whether you are part of a team or a single user, whatever your analytical requirements are, there is an SPSS license for you! Read to find out more.
How You Can Predict Device Failure
How can manufacturing companies accurately measure the lifetime of a device or even take into account the effect of external factors? Read our article on predictive maintenance to find out more.
How to Plan your Analytics Strategy
Do you have a business crying out for answers to critical questions but find it difficult to generate those answers? In this article we highlight the key issues to address when planning your Data Mining strategy.
The Importance of Strategic Alignment for Successful Analytics Initiatives
If you have ever found that your company has engaged with Analytics initiatives that have not generated the level of success that was envisaged – despite […]
5 Steps to Getting on the Right Track in MRO Inventory Management
Inventory Management is a concern for many organisations, large and small. This article will show you how organisations can take some light touch, manageable steps to reduce MRO inventory levels and costs while maintaining their maintenance SLAs and downtime KPIs.
Deployment in Advanced Analytics Projects
At Version 1, we’ve seen organisations perform best when they take the before, during and after of the deployment of analytics initiatives into consideration. This article will highlight these considerations for the best possible project outcome.
Analytics, Simplicity and Value – A complicated relationship?
Descriptive analytics is illustrated as the foundation and bedrock of analytical activities but limited in the business value potential. This is where the simplification is lacking, in our experience. This blog will share more on this topic.
Advanced Analytics and the quest for Return on Investment in 5 Key Points
Advanced Analytics as a core enterprise capability is there to serve the business to make better-informed decision. In this article, we present some of the challenges and good practices linked to measuring ROI for Advanced Analytics Programmes or Projects.
Creating an Analytics Function
This article takes a look at 4 analytics functions that are essential to consider, especially in organisations where analytics can be used for a variety of applications across multiple lines of business.
What is Analytics?
What is Analytics? Analytics is being discussed more and more often in top table conversations, but why do so many organisations still struggle to get to grips with it? Is it fundamentally down to complexity, or at least the perception of complexity? Read our post to find out more.
Infographic: Data Audit – Advanced Analytics
Forecasting predicts future values of a particular quantity based on previously observed values of that quantity. Take a look at our Infographic on What is Forecasting for more information.
Infographic: Technology Review – Advanced Analytics
Technology Review – Advanced Analytics Take a look at our Infographic on Technology Review: Advanced Analytics for more information.
Is Your Organisation Analytically Mature?
Is it too easy to think of analytical maturity as a step ladder? How can you reliably position yourself on that ladder? Are you too critical or too kind? Have you taken all the key aspects (perhaps even the unknown unknowns in the analytical world) into account? Read our blog to find out.
7 Tips for Transitioning Data Insights into Business as Usual
“Progress is impossible without change, and those who cannot change their minds cannot change anything” George Bernard Shaw The Irish playwright was on the money – […]
The Three Pillars to Actionable Insight
What are the secrets to success with analytics? The truth is that there are many factors and forces at work that help build a successful analytics project and/or programme. The ultimate goal is Actionable Insight. Read the blog post for more information.
“… The beauty of me is that I’m very rich.”
I have absolute belief in the richness of data and its ability to enable us to make evidence based decisions. When we ask ourselves When? What? Where? Why? or Who?, data can provide the answer.
Are you into extinguishing fires or are you into preventing fires?
As a specialised Advanced Analytics Solution company, the majority of the relationships that we build with our customers start with a crisis of some sort. This article takes a look at how we can support customers in addressing these challenges.
Why Analytics makes people nervous?
Why Analytics makes people nervous? The reasons behind, and some hints to help you during difficult conversations and challenging situations! Read our post to find out more.
The 5 Mistakes You Make when You Start with Analytics
When you start with Analytics you might feel overwhelmed, you have all that incredible power in your hands but don’t know how to wield it most effectively. So just how do you go about getting the most from this valuable asset? You can start by avoiding these five common mistakes.
Enhance Customer Experience in Insurance with Analytics
Reports from the insurance industry consistently highlight that the quality of customer experience remains the biggest factor driving customers to remain loyal or switch to another insurance provider. Hence, the focus should be on how to improve the quality of the customer experience rather than reducing fraud. Read our post to find out more.