Inventory Management Dilemma: Stock Spare Parts or Order As Needed - A Guide on Decision Making Formula

Question:

Is there a method for deciding whether to stock spare parts in the inventory or order them as needed? My previous supervisor believes there is a definitive formula for this decision, but I disagree. Can anyone provide guidance on this inventory management dilemma?

Top Replies

Investing in software systems can help businesses determine the necessary spare parts to keep in stock and how many of each to store. One such system is the Spares Optimisation System (SOS), which streamlines inventory management. Check out more information about SOS at http://www.strategicorp.com/products-sos.htm. There are also other similar systems available in the market.

After reviewing the website, I have come across various sources of information, including the "Standard Handbook of Plant Engineering, 2nd Edition," discussing the important topic of Identifying Necessary Spares. The consensus seems to be that there is no precise scientific method for determining which spare parts should be kept in the Maintenance stockroom. Factors such as equipment experience, manufacturer recommendations, and the process's reliance on equipment reliability all play a crucial role. My previous boss was looking for a formula that considers acquisition and inventory carrying costs against production downtime expenses when deciding whether to purchase a spare part. This formula would ultimately determine whether it is more cost-effective to buy the spare or risk waiting for it to arrive during equipment repairs. Are there any other costs or variables that should be taken into account in this decision-making process?

A critical component is lacking: the application of common sense. While working under my supervisor, I learned firsthand how frustrating it can be to report to the higher-ups that production has come to a halt due to a faulty $15 oil seal or a simple $5 fuse.

I have utilized spreadsheet tools to consider all factors mentioned, such as acquisition, inventory carrying costs, and downtime costs. These tools were developed in-house by a team of material specialists, CMMS experts, and IT professionals to optimize inventory values and establish new ones for newly identified materials in equipment BOM. Despite the valuable data provided by CMMS materials, downtime costs are not typically included in inventory analyses. Have you classified your materials using ABC indicators based on equipment criticality levels and target availability percentages? For example, Vital A materials should be available 99% of the time, Essential B materials 97%, and General C materials 95%. Maintenance and materials teams often sign service level agreements (SLAs) as part of ISO9000 procedures. Have you engaged in material cataloging to define characteristics and equipment bills of materials (BOM)? This is crucial for categorizing materials as stock or non-stock based on various factors. For lower-priced materials, consider petty purchases if there is no established price agreement for common stock or consumable items.

Hello Eugene, It is essential to only keep spare parts in the stockroom that are prone to random failures, as these failures can happen unexpectedly. These spare parts are considered "just in case" inventory for unplanned maintenance. Other parts should be ordered "just in time" for planned maintenance purposes. If you have categorized your materials based on ABC indicators related to equipment criticality, you can utilize the discrete Poisson probability distribution to determine the optimal ordering point. For example, if a part fails randomly once every 1,000 hours and there are 20 units of the same part running 24 hours a day, with a vendor lead time of 3 days, and a requirement for the part to be available 95% of the time, the ordering point can be calculated. By using the formula N*r*LT, where N is the number of units, r is the failure rate, and LT is the lead time, you can determine the appropriate stock level to ensure availability. It is important to consider various iterations to find the optimal ordering point. In the given example, it was determined that ordering should be done when the stock level reaches a minimum of 4 units to meet the 95% availability requirement. Adjustments can be made based on different criticality levels to determine the most suitable ordering point. These calculations can be easily performed using Excel with the predefined function =POISSON(k;N*r*LT;1). However, additional factors such as wear-out failure modes, preventive replacements, stockholding costs, and opportunity costs need to be considered for a more comprehensive analysis. I hope this information is helpful for your inventory management. Kind regards, Rui

I think the decision to stock spare parts or order on an as-needed basis largely depends on factors like your lead time, availability of parts, cost of inventory holding, and the urgency of replacement. If the lead times are short and reliability of the supplier is high, you may lean more towards ordering parts as and when needed. However, if downtime is expensive for your operations and parts are hard to procure quickly, it makes more sense to hold spare parts in inventory. So, I wouldn't say there's one 'definitive formula', but rather a risk-cost analysis tailored to your unique circumstances.

There isn't a one-size-fits-all formula for this as it really depends on several factors. The decision to stock spare parts or order them as needed could hinge on things like the reliability of your supplier, how quickly parts can be delivered, the cost of storage, and the cost of not having the part available when it's needed (like potential lost sales or damaged customer relationships). Creating a cost-benefit analysis for each part could help you make a more informed decision. Also, employing modern inventory management software could assist in predicting demand and ensuring optimal stock levels. That being said, it's a sophisticated balancing act that often requires continuous assessment and adjustment.

You're right that it's not as straightforward as having a definitive formula. It's more about striking a balance between the cost of inventory holding and the risk of stockouts. Generally, I'd suggest keeping those parts in stock that are critical for operation, have high demand, or come from suppliers with long lead times. For parts that are less crucial, have low demand, or can be sourced quickly, just-in-case ordering might be a more cost-efficient solution. Using an inventory management system can also help manage these decisions based on realtime data and trends.

While there might not be a definitive 'one-size-fits-all' formula to decide between keeping spare parts in inventory versus ordering as needed, you can factor in elements such as the cost of inventory storage, the reliability of your suppliers, parts' shelf life, and frequency of orders. The EOQ (Economic Order Quantity) model might be a useful tool to calculate the ideal order quantity to minimize costs. It also crucial to consider potential costs of not having a part available when needed, which could lead to operational downtime. Coincidentally, this whole decision-making process becomes a balancing act between risk management and cost efficiency.

More Replies →

Streamline Your Asset Management
See How Oxmaint Works!!

✅   Work Order Management

✅   Asset Tracking

✅   Preventive Maintenance

✅   Inspection Report

We have received your information. We will share Schedule Demo details on your Mail Id.

To add a comment, please sign in or register if you haven't already..   

Frequently Asked Questions (FAQ)

FAQ: FAQs:

Answer: 1. Is there a specific formula or method for determining whether to stock spare parts in inventory or order them as needed? - While some may argue that there is a definitive formula for this decision, in reality, the best approach may vary depending on the specific circumstances of each situation. Factors such as cost, lead time, criticality of the spare parts, and storage space should be considered when making this decision. 2. What are some key considerations to keep in mind when deciding whether to stock spare parts or order them as needed? - Important factors to consider include the frequency of usage of the spare parts, the cost of holding inventory, lead times from suppliers, the criticality of the spare parts to operations, and the availability of storage space.

FAQ: 3. How can I evaluate the cost-effectiveness of stocking spare parts in inventory versus ordering them as needed?

Answer: - Conducting a cost-benefit analysis that takes into account the carrying costs of inventory, ordering costs, and potential downtime costs can help you determine the most cost-effective approach for your specific situation.

FAQ: 4. Are there any best practices or guidelines for making decisions regarding spare parts inventory management?

Answer: - While there may not be a one-size-fits-all formula, following industry best practices such as implementing an ABC analysis to categorize spare parts based on usage frequency and criticality, setting reorder points based on demand forecasts, and regularly reviewing and adjusting inventory levels can help optimize spare parts management.

Ready to Simplify Maintenance?

Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.

Request Demo  â†’