Every organization that runs equipment needs spare parts. All of them must cope with issues that are generic no matter what their business. Some of the problems, however, are industry specific. This post discusses one universal problem that manifested in a nuclear plant and one that is especially acute for any electric utility.

The Universal Problem of Data Quality

We often post about the benefits of converting parts usage data into smart inventory management decisions. Advanced probability modeling supports generation of realistic demand scenarios that feed into detailed Monte Carlo simulations that expose the consequences of decisions such as choices of Min and Max governing the replenishment of spares.

However, all that new and shiny analytical tech requires quality data as fuel for the analysis. For some public utilities of all kinds, record keeping is not a strong suit, so the raw material going into analysis can be corrupted and misleading. We recently chanced upon documentation of a stark example of this problem at a nuclear power plant (see Scala, ­­­­­­­Needy and Rajgopal: Decision making and tradeoffs in the management of spare parts inventory at utilities. American Association of Engineering Management, 30th ASEM National Conference, Springfield, MO. October 2009). Scala et al. documented the usage history of a critical part whose absence would result in either a facility de-rate or a shutdown. The plant’s usage record for that part spanned more than eight years of data. During that time, the official usage history reported nine events in which positive demand occurred with sizes ranging from one to six units each. There were also five events marked by negative demands (i.e., returns to warehouse) ranging from one to three units each. Careful sleuthing discovered that the true usage occurred in just two events, both with demand of two units. Obviously, calculating the best Min/Max values for this item requires accurate demand data.

The Special Problem of Health and Safety

In the context of “regular” businesses, shortages of spare parts can damage both current revenue and future revenue (related to reputation as a reliable supplier). For an electric utility, however, Scala et al. noted a much greater level of consequence attached to stockouts of spare parts. These include not only a heightened financial and reputational risk but also risks to health and safety: “Ramifications of not having a part in stock include the possibility of having to reduce output or quite possibly, even a plant shut down. From a more long-term perspective, doing so might interrupt the critical service of power to residential, commercial, and/or industrial customers, while damaging the company’s reputation, reliability, and profitability. An electric utility makes and sells only one product: electricity. Losing the ability to sell electricity can be seriously damaging to the company’s bottom line as well its long-term viability.”

All the more reason for electric utilities to be leaders rather than laggards in the deployment of the most advanced probability models for demand forecasting and inventory optimization.

Utilities in the electrical, natural gas, urban water and wastewater, and telecommunications fields are all asset intensive. Generation, production, processing, transmission, and distribution of electricity, natural gas, oil, and water, are all reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management.

A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. Impeding these efforts are out-of-date IT systems, evolving security threats, frequent supply chain disruptions, and extreme demand variability.  However, the convergence of these challenges with mature cloud technology and recent advancements in data analytics, probabilistic forecasting, and technologies for data management, present utilities a generational opportunity to digitally transform their enterprise.

Here are seven digital transformations that require relatively small upfront investments but will generate seven-figure returns.

1. Inventory Management is the first step in MRO inventory optimization. It involves analyzing current inventory levels and usage patterns to identify opportunities for improvement. This should include looking for overstocked, understocked, or obsolete items.  New probabilistic forecasting technology will help by simulating future parts usage and predicting how current stocking policies will perform.  Pats planners can use the simulation results to proactively identify where policies should be modified.

2. Accurate forecasting and demand planning are very important in optimizing MRO service parts inventories. An accurate demand forecast is a critical supply chain driver. By understanding demand patterns that result from capital projects and planned and unplanned maintenance, parts planners can more accurately anticipate future inventory needs, budget properly, and better communicate anticipated demand to suppliers. Parts forecasting software can be used to automatically house an accurate set of historical usage that details planned vs. unplanned parts demand.

3. Managing suppliers and lead times are important components of MRO inventory optimization. It involves selecting the best vendors for the job, having backup suppliers that can deliver quickly if the preferred supplier fails, and negotiating favorable terms.  Identifying the right lead time to base stocking policies on is another important component. Probabilistic simulations available in parts planning software can be used to forecast the probability for each possible lead time that will be faced. This will result in a more accurate recommendation of what to stock compared to using a supplier quoted or average lead time.

4. SKU rationalization and master data management removes ineffective or out-of-date SKUs from the product catalog and ERP database. It also identifies different part numbers that have been used for the same SKU. The operating cost and profitability of each product are assessed during this procedure, resulting in a common list of active SKUs.  Master data management software can assess product catalogs and information stored in disparate data bases to identify SKU rationalizations ensuring that inventory policies are based on the common part number.

5.  Inventory control systems are key to synchronizing inventory optimization.    They provide a cost-efficient way for utilities to track, monitor, and manage their inventory. They helps ensure that the utility has the right supplies and materials when and where needed while minimizing inventory costs.

6. Continuous improvement is essential for optimizing MRO inventories. It involves regularly monitoring and adjusting inventory levels and stocking policies to ensure the most efficient use of resources. When operating conditions change, the utility must detect the change and adjust its operations accordingly. This means planning cycles must operate at a tempo high enough to stay up with changing conditions. Leveraging probabilistic forecasting to recalibrate service parts stocking policies each planning cycle ensures that stocking policies (such as min/max levels) are always up-to-date and reflect the latest parts usage and supplier lead times.

7. Planning for intermittent demand with modern Spare Parts Planning Software.  The result is a highly accurate estimate of safety stocks, reorder points, and order quantities, leading to higher service levels and lower inventory costs.   Smart Software’s patented probabilistic spare parts forecasting software simulates the probability for each possible demand, accurately determining how much to stock to achieve a utility’s targeted service levels.  Leveraging software to accurately simulate the inflow and outflow of repairable spare parts will better predict downtime, service levels, and inventory costs associated with any chosen pool size for repairable spares.