Under ISO55000 standards, companies must demonstrate effective management of asset data from project start to end of life. This includes having procedures for spare parts cataloging and inventory management. The document outlines RAMsoft's 6-phase process for improving spare parts inventory: 1) Audit current practices, 2) Define procedures, 3) Cleanse master data, 4) Rationalize inventory, 5) Optimize stock levels, 6) Measure effectiveness. RAMsoft tools and workshops can help companies standardize data, identify issues, reduce duplicates and optimize inventory levels to achieve savings of up to 70% according to case studies.
The document discusses profit maximization for firms in the short run and long run. In the short run, firms take some inputs as fixed and maximize profits by producing at the point where marginal revenue from inputs equals their price. In the long run, firms can vary all inputs and maximize profits where marginal revenue equals marginal cost for all inputs. Firms with decreasing returns have a single profit-maximizing output level, while increasing returns precludes profit maximization. For perfectly competitive firms to exist, constant returns technologies must result in zero economic profits.
This document provides guidelines for state agencies in Texas on evaluating the costs and benefits of leasing versus purchasing information technologies. It discusses key factors to consider such as present value analysis, alternatives for acquisition, technology management issues, and the technology life cycle. The guidelines aim to help agencies determine the most cost-effective option based on their specific needs and processes.
Tail End Spend Management - presented by Olivier ChalonXchanging
Ìý
Olivier Chalon's presentation on Tail End Spend Management was shown at the World Procurement Congress 2014 during a Breakfast Briefing hosted by Xchanging Procurement.
To avoid running out of stock of the products you sell, it's important to use inventory forecasting when building an inventory control strategy.
Learn everything about inventory forecasting from industry veterans
The document discusses relevant costs for decision making. It provides examples of identifying relevant costs when deciding whether to replace an old loader with a new one, whether to accept a special order, and whether to outsource the production of in-flight desserts. Relevant costs are those that differ between alternatives and affect the decision. Sunk costs and future costs that do not differ between alternatives are never relevant.
This document outlines an agenda for a procurement audit training course. It discusses getting the most out of the training by actively participating and focusing on the subject matter. The course objectives are to understand the procurement life cycle, emerging risks and trends, how to audit the cycle, and lean audit techniques. The outline includes an overview of procurement, the procurement cycle components, emerging risks and trends, performing procurement audits, and lean audit techniques.
Strategic sourcing involves systematically analyzing internal and external data to develop an optimal supplier strategy. It aims to optimize spend, improve quality, increase ROI, and cut costs through partnership with a limited number of suppliers. The process identifies current spending and viable suppliers, develops sourcing approaches, issues RFPs, negotiates with suppliers, and integrates and monitors selected suppliers. Benefits include estimated 5-10% savings, collaborative spending improvements, new performance metrics, innovation, and better teamwork. Most Fortune 500 companies use strategic sourcing.
This document contains multiple choice questions about corporate finance concepts like valuation methods, ratios like price-earnings ratio and how they are calculated, capital budgeting techniques like net present value, internal rate of return and payback period. It also includes questions about corporate social responsibility, governance, and decisions around mutually exclusive investment projects.
This document outlines a 6-step process for reducing MRO inventory costs. The phases include auditing data, defining processes and guidelines, cleansing master data, rationalizing items, optimizing stock levels, and monitoring performance. Examples are provided showing how auditing identified duplicates and standardizing items reduced inventory by 60%. Optimizing reorder points and quantities can also save costs by better matching stock to demand. Guidelines are suggested for cleaning data, assigning criticality levels, and challenging vendor recommendations.
New for 2018 MRO master data auditing and cleansingDavid Thompson
Ìý
New Workshop developed due to high number of company's inventory systems with poor data leading to high number of duplicates, lack of focus on cost reduction, excess downtime
Smu mba sem 4 OM spring 2016 assignments, smu solved assignments ,smu assignments ,smu mba assignments ,smu mba solved assignments ,smu mba spring 2016 assignments
This document contains sample questions and answers from a Production and Operations Management exam. It discusses topics like value engineering, supply chain management, business processes, productivity, forecasting, risk management, and factory layouts. For value engineering, it defines the concept and lists its main benefits as cost reduction and an overall culture of cost consciousness. It also provides short notes on various topics, including the key ingredients of a business process, acceptance sampling techniques, work breakdown structures, and defining productivity. The document aims to provide comprehensive yet concise coverage of operations management topics to help students prepare for their exam.
3 Day Spares Optimisation Course (Multiple Venues)David Thompson
Ìý
Ramsoft are offering a 3 day course teaching delegates how to optimise their Spares Inventory and the potential cost savings which can be achieved from improving Spares Management
Mro spare parts optimisation and inventory reduction uk 2017 11David Thompson
Ìý
This 3-day training course covers techniques for optimizing spare parts inventories and reducing costs. It will discuss improving data quality, identifying duplicates, optimizing inventory parameters, challenging vendor recommendations, and selecting the right replenishment strategies. Past delegates have achieved 60-70% reductions in inventory costs. The course uses case studies and worksheets to help attendees develop action plans to optimize their own spare parts management.
The document discusses supply chain management concepts including the SCOR (Supply Chain Operations Reference) model. SCOR is a process reference model developed by the Supply Chain Council to help companies define and measure supply chain processes. It provides a framework to measure performance at different levels, from overall supply chain metrics to more granular process metrics. The document also discusses how benchmarking with SCOR allows companies to compare their supply chain performance to peers.
SCOR uma realidade em LogÃstica. O modelo de pratica de negócio mais atualizado produzido de forma colaborativa por grandes empresas do mercado internacioal e organizado pelo SCC Supply Chain Council.
C3 3 day spares optimisation rationalisation 2017 01David Thompson
Ìý
This 3-day workshop aims to help companies reduce inventory and spare parts costs through effective inventory management practices. It covers topics like recommended spare parts lists, cataloguing, inventory cost reduction tactics, reliability theory, reorder points, and key performance indicators. The course provides case studies, exercises and an Excel tool to help attendees immediately implement strategies in their own companies to optimize spare parts inventory. It is designed for maintenance managers, engineers, warehouse staff, purchasers and others seeking to better manage spare parts inventory.
C3 3 day spares optimisation rationalisation 2017 01Martyn Thompson
Ìý
This 3-day workshop aims to help companies reduce inventory and spare parts costs through effective inventory management practices. It covers topics like recommended spare parts lists, cataloguing, inventory cost reduction tactics, reliability theory, reorder points, and key performance indicators. The training methodology includes presentations, case studies, exercises and discussion. The instructor has over 40 years of experience in maintenance, reliability and spares optimization. Attendees include maintenance managers, engineers, warehouse managers and others interested in improving inventory management.
CIPS award Submission 2012 (Finalist) Version 1Vincent Edwards
Ìý
The Jaguar Land Rover engineering materials rationalization project aimed to reduce costs and inefficiencies in their management of replacement parts across multiple manufacturing sites. A cross-functional team analyzed 88,000 part numbers, reducing duplication and rationalizing the portfolio. Through benchmarking, stock analysis, governance processes and outsourcing, they reduced inventory 20%, parts 20%, prices 5% and procurement card spending. This generated over £1 million in annual savings while simplifying operations and improving stock availability, reducing production costs by £34 per vehicle.
A STUDY OF SPARE PARTS INVENTORY MANAGEMENT CASE STUDY OF REDUCTION HALVE SP...Leslie Schulte
Ìý
This document presents a proposal for reducing the value of spare parts in an organization's inventory by half without impacting production. It outlines an 8-step process: 1) Identifying the problem of too high spare parts value, 2) Performing a Pareto analysis to separate parts into high and low value, 3) Developing strategies for low value parts, 4) Analyzing stock movement of high value parts, 5) Reviewing non-moving parts, 6) Reviewing fast moving parts, 7) Reviewing slow moving parts, and 8) Releasing a recommended spare parts stock list. It also discusses future policies for controlling spare parts, such as standardization, rationalization, and controlling obsolete and slow moving parts.
Bba501 & production and operations managementsmumbahelp
Ìý
Dear students get fully solved assignments
Send your semester & Specialization name to our mail id :
help.mbaassignments@gmail.com
or
call us at : 08263069601
Do you know the current gaps in your lubrication program? If not use this maturity matrix to identify the gaps based on known best practices. This is one great tool anyone can use who are looking to optimize their lubrication program. Review the matrix with your maintenance staff and ask for their comments.(comments by a maintenance staff will give you an indication of their lubrication knowledge)
This document provides information about obtaining fully solved SMU MBA Spring 2014 assignments. Students can send their semester and specialization name to the email address or call the phone number provided to receive the assignments. The assignments cover topics like quality management, production planning and control, technology management, and operations management. Sample questions are listed for reference purposes for subjects like quality management, operations management, and advanced production planning and control.
Six Sigma is a disciplined process focused on reducing defects and achieving near-perfect quality. It was created by Bill Smith in the 1980s at Motorola to increase business performance. Total quality management aims to carefully design products/services and ensure the organization can consistently produce the design. Key Six Sigma concepts include the DMAIC cycle of define, measure, analyze, improve, control to identify and eliminate process variation. Poka-yokes are error-proofing mechanisms to prevent human errors.
PFMEA, Risk Reduction and Effectiveness – Advance (AIAG FMEA #4 Edition)
Is your FMEA performing for you?
This is advance level of PFMEA, Have basic understanding fo Core IATF Tools before refering to this presentation.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper use of codes could support spend analysis and rationalization of suppliers if applied to a company's CMMS. Training is recommended to select codes consistently and understand naming conventions.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper use of codes could support spend analysis and rationalization of suppliers if applied to a company's CMMS. Training is recommended to select codes consistently and understand naming conventions.
More Related Content
Similar to MRO Spare Parts Improvement Programme Conforms to ISO55000 (20)
This document outlines a 6-step process for reducing MRO inventory costs. The phases include auditing data, defining processes and guidelines, cleansing master data, rationalizing items, optimizing stock levels, and monitoring performance. Examples are provided showing how auditing identified duplicates and standardizing items reduced inventory by 60%. Optimizing reorder points and quantities can also save costs by better matching stock to demand. Guidelines are suggested for cleaning data, assigning criticality levels, and challenging vendor recommendations.
New for 2018 MRO master data auditing and cleansingDavid Thompson
Ìý
New Workshop developed due to high number of company's inventory systems with poor data leading to high number of duplicates, lack of focus on cost reduction, excess downtime
Smu mba sem 4 OM spring 2016 assignments, smu solved assignments ,smu assignments ,smu mba assignments ,smu mba solved assignments ,smu mba spring 2016 assignments
This document contains sample questions and answers from a Production and Operations Management exam. It discusses topics like value engineering, supply chain management, business processes, productivity, forecasting, risk management, and factory layouts. For value engineering, it defines the concept and lists its main benefits as cost reduction and an overall culture of cost consciousness. It also provides short notes on various topics, including the key ingredients of a business process, acceptance sampling techniques, work breakdown structures, and defining productivity. The document aims to provide comprehensive yet concise coverage of operations management topics to help students prepare for their exam.
3 Day Spares Optimisation Course (Multiple Venues)David Thompson
Ìý
Ramsoft are offering a 3 day course teaching delegates how to optimise their Spares Inventory and the potential cost savings which can be achieved from improving Spares Management
Mro spare parts optimisation and inventory reduction uk 2017 11David Thompson
Ìý
This 3-day training course covers techniques for optimizing spare parts inventories and reducing costs. It will discuss improving data quality, identifying duplicates, optimizing inventory parameters, challenging vendor recommendations, and selecting the right replenishment strategies. Past delegates have achieved 60-70% reductions in inventory costs. The course uses case studies and worksheets to help attendees develop action plans to optimize their own spare parts management.
The document discusses supply chain management concepts including the SCOR (Supply Chain Operations Reference) model. SCOR is a process reference model developed by the Supply Chain Council to help companies define and measure supply chain processes. It provides a framework to measure performance at different levels, from overall supply chain metrics to more granular process metrics. The document also discusses how benchmarking with SCOR allows companies to compare their supply chain performance to peers.
SCOR uma realidade em LogÃstica. O modelo de pratica de negócio mais atualizado produzido de forma colaborativa por grandes empresas do mercado internacioal e organizado pelo SCC Supply Chain Council.
C3 3 day spares optimisation rationalisation 2017 01David Thompson
Ìý
This 3-day workshop aims to help companies reduce inventory and spare parts costs through effective inventory management practices. It covers topics like recommended spare parts lists, cataloguing, inventory cost reduction tactics, reliability theory, reorder points, and key performance indicators. The course provides case studies, exercises and an Excel tool to help attendees immediately implement strategies in their own companies to optimize spare parts inventory. It is designed for maintenance managers, engineers, warehouse staff, purchasers and others seeking to better manage spare parts inventory.
C3 3 day spares optimisation rationalisation 2017 01Martyn Thompson
Ìý
This 3-day workshop aims to help companies reduce inventory and spare parts costs through effective inventory management practices. It covers topics like recommended spare parts lists, cataloguing, inventory cost reduction tactics, reliability theory, reorder points, and key performance indicators. The training methodology includes presentations, case studies, exercises and discussion. The instructor has over 40 years of experience in maintenance, reliability and spares optimization. Attendees include maintenance managers, engineers, warehouse managers and others interested in improving inventory management.
CIPS award Submission 2012 (Finalist) Version 1Vincent Edwards
Ìý
The Jaguar Land Rover engineering materials rationalization project aimed to reduce costs and inefficiencies in their management of replacement parts across multiple manufacturing sites. A cross-functional team analyzed 88,000 part numbers, reducing duplication and rationalizing the portfolio. Through benchmarking, stock analysis, governance processes and outsourcing, they reduced inventory 20%, parts 20%, prices 5% and procurement card spending. This generated over £1 million in annual savings while simplifying operations and improving stock availability, reducing production costs by £34 per vehicle.
A STUDY OF SPARE PARTS INVENTORY MANAGEMENT CASE STUDY OF REDUCTION HALVE SP...Leslie Schulte
Ìý
This document presents a proposal for reducing the value of spare parts in an organization's inventory by half without impacting production. It outlines an 8-step process: 1) Identifying the problem of too high spare parts value, 2) Performing a Pareto analysis to separate parts into high and low value, 3) Developing strategies for low value parts, 4) Analyzing stock movement of high value parts, 5) Reviewing non-moving parts, 6) Reviewing fast moving parts, 7) Reviewing slow moving parts, and 8) Releasing a recommended spare parts stock list. It also discusses future policies for controlling spare parts, such as standardization, rationalization, and controlling obsolete and slow moving parts.
Bba501 & production and operations managementsmumbahelp
Ìý
Dear students get fully solved assignments
Send your semester & Specialization name to our mail id :
help.mbaassignments@gmail.com
or
call us at : 08263069601
Do you know the current gaps in your lubrication program? If not use this maturity matrix to identify the gaps based on known best practices. This is one great tool anyone can use who are looking to optimize their lubrication program. Review the matrix with your maintenance staff and ask for their comments.(comments by a maintenance staff will give you an indication of their lubrication knowledge)
This document provides information about obtaining fully solved SMU MBA Spring 2014 assignments. Students can send their semester and specialization name to the email address or call the phone number provided to receive the assignments. The assignments cover topics like quality management, production planning and control, technology management, and operations management. Sample questions are listed for reference purposes for subjects like quality management, operations management, and advanced production planning and control.
Six Sigma is a disciplined process focused on reducing defects and achieving near-perfect quality. It was created by Bill Smith in the 1980s at Motorola to increase business performance. Total quality management aims to carefully design products/services and ensure the organization can consistently produce the design. Key Six Sigma concepts include the DMAIC cycle of define, measure, analyze, improve, control to identify and eliminate process variation. Poka-yokes are error-proofing mechanisms to prevent human errors.
PFMEA, Risk Reduction and Effectiveness – Advance (AIAG FMEA #4 Edition)
Is your FMEA performing for you?
This is advance level of PFMEA, Have basic understanding fo Core IATF Tools before refering to this presentation.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper use of codes could support spend analysis and rationalization of suppliers if applied to a company's CMMS. Training is recommended to select codes consistently and understand naming conventions.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper use of codes could support spend analysis and rationalization of suppliers if applied to a company's CMMS. Training is recommended to select codes consistently and understand naming conventions.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper use of codes could support spend analysis and rationalization of suppliers if applied to a company's CMMS. Training is recommended to select codes consistently and understand naming conventions.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to codify items. However, the document finds inconsistent use of UNSPSC codes in one company's data. Proper type guides are needed to consistently assign codes down to the qualifier level to fully map inventory. Applying codes can help organizations conduct spend analysis and rationalize suppliers if populated in their CMMS. Training is recommended to understand naming conventions and properly catalogue items with codes.
Using UNSPSC codes in the MRO Inventory SystemDavid Thompson
Ìý
This document discusses the UNSPSC commodity coding system and its use for asset management. The UNSPSC system provides a hierarchical classification structure with 4 levels (or 5 levels if modified) to classify items. It aims to ensure consistent coding of items but some issues can arise when different codes are assigned to the same item. The document also provides examples of inconsistent UNSPSC coding found during an audit and emphasizes the importance of type guides to ensure consistent naming. It questions how asset managers utilize these codes to support activities like spend analysis and rationalization of suppliers.
Is your mro spare parts reduction program compliant with iso55000 rev 3David Thompson
Ìý
Under ISO55000 standards, companies must demonstrate effective management of asset data from project start to end of life. This includes having procedures for spare parts cataloging and inventory management. The document outlines RAMsoft's 6-phase process for improving spare parts inventory: 1) Audit current practices, 2) Define procedures, 3) Cleanse master data, 4) Rationalize inventory, 5) Optimize stock levels, 6) Measure effectiveness. RAMsoft tools and workshops help companies standardize data, identify issues like duplicates, and reduce inventory costs through optimization.
This document compares inventory control models in SAP and conventional methods. It discusses the reorder point (ROP) and economic order quantity (EOQ) models, as well as the minimum-maximum (Min-Max) model used in SAP. The document uses a case study of inventory for special grease to illustrate how the different models apply and compare total costs. It shows that the standard ROP model is not always appropriate when buying costs are low due to multi-item purchase orders. In these cases, SAP's Min-Max model provides a better solution and lower average stock levels. Rules of thumb for Min-Max levels can result in under or overstocking compared to optimized calculations.
This document compares inventory control models in SAP and conventional methods. It discusses the reorder point (ROP) and economic order quantity (EOQ) models, as well as the minimum-maximum (Min-Max) model used in SAP. The document uses a case study of inventory for special grease to illustrate how the different models apply and compare total costs. It shows that the standard ROP model is not always appropriate when buying costs are low due to grouping multiple items in a single order. In these cases, SAP's Min-Max model provides a better solution and lower average stock levels. Rules of thumb for setting Min-Max levels are also discussed but shown to not consider all relevant costs and risks.
This document contains a list of 129 books related to asset management, maintenance, reliability engineering, and related topics. The books are listed by title along with the author and year of publication. The topics covered include asset management, maintenance management, reliability centered maintenance, maintenance planning and scheduling, machinery maintenance and repair, and lean manufacturing techniques like total productive maintenance.
The document lists 40 topics related to quantitative techniques, root cause analysis, reliability centered maintenance, reliability engineering, maintainability, and asset management. Many of the topics were written about between 1995-2010 and cover subjects such as machinery failure analysis, human factors, proven tips for equipment troubleshooting, applied reliability centered maintenance, reliability data collection, maintenance modeling, and statistical methods in reliability engineering.
This document contains 24 topics related to plant engineering, maintenance, and operations. The topics include guides on energy conservation, functional safety systems, Lean manufacturing techniques like total productive maintenance and quick changeovers, inventory control, maintenance management, planning and scheduling, and petroleum refining. The authors and years of publication range from 1977 to 2016.
This document contains a list of 36 topics related to asset management, maintenance management, and reliability. Each topic includes the title and the author and year. The topics cover a wide range of issues including asset data integrity, aviation maintenance management, international case studies, handbooks, operational performance measurement, maintenance culture change, strategic planning, maintenance systems, resource management, CMMS implementation, life cycle costing, physical asset management, reliability metrics, fleet maintenance, benchmarking, maintenance management, obstacles to reliability, decision making, organization, performance indicators, and process plant reliability.
This document lists 7 topics related to maintenance, repair, reliability assessment, and maximizing uptime of machinery and equipment in an EM (energy and mining) facility. The topics include maintenance and repair of machinery components and major process equipment, machinery reliability assessment, maximizing machinery uptime, improving machinery reliability, a pump users handbook, and a capital equipment buying handbook. The topics were authored by Hein P Bloch between 1990 and 2006 and R G Newman in 1998.
An audit was conducted on a food and drink manufacturer's maintenance spare parts data in their SAP system. The audit found significant issues with the quality of the data cleansing work done by a consultant company. Key findings included inconsistent and improper use of fields, excessive use of generic terms, failure to identify duplicate items, and inconsistent attribute data. The audit highlighted the need for proper spare parts management practices and cataloging standards.
Reducing Costs of Spares and Inventory LevelsDavid Thompson
Ìý
This document discusses how Ramsoft (UK) provides training and consultancy services to help companies optimize and reduce costs associated with spare parts inventory. It outlines Ramsoft's 4-day training course which covers topics like improving spare parts data quality, challenging vendor recommendations, effective cataloging and inventory management processes, reliability concepts, setting reorder points and safety stock levels, alternate inventory strategies, and key performance indicators. The training aims to help companies develop strategic plans, audit current practices, optimize stock levels through rationalization, and achieve cost reductions of over 50% in stored inventory values. Case studies show how Ramsoft's services have helped clients improve data quality and reduce line items by up to 60% through standardization and removal of duplicates.
Indian Soil Classification System in Geotechnical EngineeringRajani Vyawahare
Ìý
This PowerPoint presentation provides a comprehensive overview of the Indian Soil Classification System, widely used in geotechnical engineering for identifying and categorizing soils based on their properties. It covers essential aspects such as particle size distribution, sieve analysis, and Atterberg consistency limits, which play a crucial role in determining soil behavior for construction and foundation design. The presentation explains the classification of soil based on particle size, including gravel, sand, silt, and clay, and details the sieve analysis experiment used to determine grain size distribution. Additionally, it explores the Atterberg consistency limits, such as the liquid limit, plastic limit, and shrinkage limit, along with a plasticity chart to assess soil plasticity and its impact on engineering applications. Furthermore, it discusses the Indian Standard Soil Classification (IS 1498:1970) and its significance in construction, along with a comparison to the Unified Soil Classification System (USCS). With detailed explanations, graphs, charts, and practical applications, this presentation serves as a valuable resource for students, civil engineers, and researchers in the field of geotechnical engineering.
Indian Soil Classification System in Geotechnical EngineeringRajani Vyawahare
Ìý
MRO Spare Parts Improvement Programme Conforms to ISO55000
1. Introduction
Under ISO55000, a company must demonstrate that it is managing its assets from the project phase to
end of life.
For the assets, e.g. spare parts, a company must:
• Demonstrate that it is managing its data (cataloguing, issue, returns, receipts, etc)
• Have procedures in place (cataloguing, initial spares purchasing, inventory man)
• Demonstrate risk-based decisions
• Demonstrate continuous improvement
In our experience the creation of MRO Spare Parts Master Data is typically done very badly at the
project phase and continues into the asset ownership phase. See attached flyer, listing several case
studies.
Poor cataloguing leads to duplicate stock, loss of time trying to find spare parts, emergency purchases,
excess stocking and hence excess costs.
Depending how bad you currently are, there is a potential for significant savings.
RAMsoft have been conducting workshops to help companies optimise and reduce their inventory for
several years.
RAMsoft have developed several tools to support reductions in inventory.
• MRO-Strip, a tool to identify duplicate line items, most companies have between 10-15%
duplicates
• MRO-OPT, a tool to optimise stock levels and to show % cost savings
• MRO-BOM, a tool to support BOM building
• MRO-Auditor, for conducting MRO Spare Parts Master Data Audits very effectively
• MRO-CleanIT, to cleanse the spare part master data with standardised part descriptions and part
numbers
RAMsoft have also developed an inventory reduction process based on the following 6 phases:
Audit
Define Process & Guides
Cleanse
Rationalise
Optimise
Measure Effectiveness
Is Your MRO Spare Parts Improvement
Programme ISO55000 Compliant?
Maintenance, Reliability & MRO Spare Parts Specialists
2. Phase 1 Auditing
The first step for any inventory improvement programme is an understanding of the company’s issues.
The scope of an inventory management audit can cover the following areas:
• MRO Best Practices (a structured questionnaire is used to evaluate best practices in managing
spare parts effectively)
• MRO Written Procedures and Guides (the documents required for each phase of an item’s life)
• Master Data Review (short description formats, nouns and modifiers, Mfg. & Vendor P/Ns,
Vendor and Mfg. names, review of duplicates)
• Inventory replenishment control parameters (an evaluation of current ROP, OQ, Min-Max, etc)
In this document, we will mainly discuss activities related to spare parts master data.
A company’s downloaded inventory data is mapped and imported to our MRO-Auditor tool. MRO-
Auditor contains over 200 saved filters and queries to facilitate the master data review by noun, etc.
A report is issued detailing the findings good and bad - remember poor cataloguing represents potential
savings.
Typical findings from our audits are:
• Short descriptions have inconsistent formatting
• Qualifiers or Modifiers are not identified
• Vendors’ names included in the short description
• Lack of attribute data in the short description, and inconsistent sequencing
• MPNs have inconsistent formatting
• MPNs fields are a mix of Vendors and MPNs
• 10-15% duplicate line items
• Inconsistent abbreviations used
• Abbreviations are not used when they should be
• Multiple suppliers for the similar material
Comments on poor cataloguing will be supported by screen shots from the MRO-Auditor tool, a typical
example is:
The above is an example of the poor cleansing delivered by a consultant.
RAMsoft do not guarantee to find all types of inconsistencies, but the most common. Only during
master data cleansing will all issues be identified.
Phase 2 Procedures and Guides
ISO55000 states that a high level strategic plan (known as a SAMP) needs to be developed. The structure
of the SAMP varies between consultants and the various maintenance associations, this is because the
ISO55000 is not prescriptive.
The SAMP developed by Ramsoft, includes two elements relative to MRO Spare Parts:
• Initial MRO Spare Parts Planning (Project phase)
• MRO Spare Parts Management (Ownership phase)
3. The main reason for poor cataloguing, is that the cataloguing process is not documented in the project
phase, which includes CMMS population.
Even when a so called consultant has carried out the cataloguing or the cleansing the final quality is
poor. Unless you document all the rules and build criteria the cataloguing will not achieve a high quality.
Remember under ISO55000 you must demonstrate the management of data and that means how the
data is populated in the CMMS consistently
During the data cleansing phase, RAMsoft can prepare documentation that supports consistent
cataloguing in the future.
Documentation can include:
• Guides and rules used during the cleansing
• A list of all abbreviations
• Type guides to cover the type of spares stocked and the naming convention
The screen shot below, shows a typical Type Guide for Shaft Bushes.
Phase 3 Cleansing Master Data
The scope of cleansing will vary from company to company and will be CMMS dependant. For example,
Maximo users typically describe their spare parts using up to 75 characters, while SAP users are limited
to 40 characters. This means a SAP user must use many more abbreviations to describe a spare part.
RAMsoft using their MRO-CleanIT tool can clean up your master data. Using standardised descriptions,
a) located in a look up table when matched to a MPN and b) a table containing template descriptions,
when that MPN is not an exact match.
One of the reasons for duplicate stock is manufacturers & vendors use different naming conventions,
e.g. see for stainless steel A2, 304, SS, they could be all the same but used in MPN then you would not
be able to identify these. Therefore Phase 2 is essential, you must clearly identify your naming
conventions.
Benefits of cleansed master data are the identification of potential duplicates, ease of finding spares,
identification of standardisation and rationalisation opportunities and hence inventory reduction.
The following example shows the current part description and the cleansed description.
4. Phase 4 Rationalisation
Rationalisation is about reviewing your material and seeking inventory or cost reduction opportunities
Companies who have proceeded to the cleansing and rationalisation phases have achieved up to 60-70
% reduction in line items (for some material) by:
• Standardising part descriptions and MPNs
• Removing duplicates
• Standardising on the material specification
• Reducing the number of manufacturers
• Removing stock that is not fit for purpose (wrong specification)
The screen shot below shows that this company stocked 23 different manufacturers of bearings.
Rationalisation covers many of the 30 tactics, we cover in our 3 day workshop, including:
• Classifying the criticality of each spare
• Assigning classifications for ABC, HML, XYZ and demand classes
• Identifying OPMs and APMs
• Reducing stocking locations
• Conducting RCA for A items
• Conducting Spend Analysis
• Challenge stocking of slow movers
• Etc.
Further cost savings may be possible by proceeding to Phase 5 MRO Optimisation
Phase 5 Optimisation
Optimisation supports ISO55000 by making decisions based on risk, we set a Stock-out risk for each
spare part based on the item’s criticality. Opportunities for reducing inventory are identified by
determining the optimum ROP and OQ and then the most appropriate replenishment strategy.
Optimum ROPs are determined by:
• Assigning a service level to each spare part based on its criticality
• Identifying the true lead time (company plus supplier)
5. • Determining the average demand rate
RAMsoft propose three main replenishment strategies:
• ROP a fixed ROP and OQ
• Min-Max, a variable OQ to bring the stock level to a maximum
• Constant Vendor Delivery, based on JIT concepts
Costs savings are identified by looking for potential cost savings. Prioritisation is based on differential
financial value between the current average stock level and optimum average stock level.
The case study below is an example, where the optimum values are not appropriate, the options are
then to a) increase one or more control parameters, so that they are not the optimum values or b) move
to a different replenishment strategy. In this example a) was the best option.
The Author
David Thompson holds a B.Sc. (Hons) in Mechanical Engineering and has spent his entire career over 50
years in maintenance, reliability and spare parts management.
David has been a certified trainer in both Reliability and RCA for leading USA companies.
David has worked in many industries Steel, Mining, Utilities, General Manufacturing, Food & Beverage,
and Oil & Gas and worked in over 36 countries
David has conducted over 40 workshops on MRO Optimisation and Inventory Reduction including
CMMS data builds. He has conducted numerous audits of MRO Master Data and conducted optimum
inventory parameter evaluations.
David has developed procedures and guides to support effective CMMS inventory build and
management.
Workshops offered
• MRO Spare Parts Optimisation and Inventory Reduction
• MRO Spare Parts Master Data Auditing & Cleansing
Contact details:
David Thompson
MRO Spares Parts Consultant/Trainer
Ramsoft (UK)
Summerseat, Bury, BL0 5QW, Manchester.
dave@ramsoftuk.com
www.ramsoftuk.com
http://uk.linkedin.com/in/davidthompsonreliability
Ramsoft (UK). 23 Waterside Road, Summerseat. Bury, Lancs, UK. BL9 5QW