MRO organizations exist in a wide range of  industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all.

For example, at a recent Maximo Utilities Working Group event, several prospects stated that “Our EAM will do that” when asked about requirements for forecasting usage, netting out supply plans, and optimizing inventory policies. They were surprised to learn it did not and wanted to know more.

In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning.   

EAM Systems

EAM systems can’t ingest forecasts of future usage – these systems simply aren’t designed to conduct supply planning and many don’t even have a place to hold forecasts. So, when an MRO business needs to net out known requirements for planned production or capital projects, an add-on application like Smart IP&O is needed.

Inventory Optimization software with features that support planning known future demand will take project-based data not maintained in the EAM system (including project start dates, duration, and when each part is expected to be needed) and compute a period-by-period forecast over any planning horizon. That “planned” forecast can be projected alongside statistical forecasts of “unplanned” demand arising from normal wear and tear. At that point, parts planning software can net out the supply and identify gaps between supply and demand. This ensures that these gaps won’t go unnoticed and result in shortages that would otherwise delay the completion of the projects. It also minimizes excess stock that would otherwise be ordered too soon and needlessly consumes cash and warehouse space. Again, MRO businesses sometimes mistakenly assume that these capabilities are addressed by their EAM package.

ERP Systems

ERP systems, on the other hand, typically do include an MRP module that is designed to ingest a forecast and net out material requirements. Processing will consider current on hand inventory, open sales orders, scheduled jobs, incoming purchase orders, any bill of materials, and items in transit while transferring between sites. It will compare those current state values to the replenishment policy fields plus any monthly or weekly forecasts to determine when to suggest replenishment (a date) and how much to replenish (a quantity).

So, why not use the ERP system alone to net out the supply plan to prevent shortages and excess? First, while ERP systems have a placeholder for a forecast and some systems can net out supply using their MRP modules, they don’t make it easy to reconcile planned demand requirements associated with capital projects. Most of the time, the data on when planned projects will occur is maintained outside of the ERP, especially the project’s bill of materials detailing what parts will be needed to support the project. Second, many ERP systems don’t offer anything effective when it comes to predictive capabilities, relying instead on simple math that just won’t work for service parts due to the high prevalence of intermittent demand. Finally, ERP systems don’t have flexible user-friendly interfaces that support interacting with the forecasts and supply plan.

Reorder Point Logic

Both ERP and EAM have placeholders for reorder point replenishment methods such as Min/Max levels. You can use inventory optimization software to populate these fields with the risk-adjusted reorder point policies. Then within the ERP or EAM systems, orders are triggered whenever actual (not forecasted) demand drives on-hand stock below the Min. This type of policy doesn’t use a traditional forecast that projects demand week-over-week or month-over-month and is often referred to as “demand driven replenishment” (since orders only occur when actual demand drives stock below a user defined threshold).

But just because it isn’t using a period-over-period forecast doesn’t mean it isn’t being predictive. Reorder point policies should be based on a prediction of demand over a replenishment lead time plus a buffer to protect against demand and supply variability. MRO businesses need to know the stockout risk they are incurring with any given stocking policy. After all, inventory management is risk management – especially in MRO businesses when the cost of stockout is so high. Yet, ERP and EAM do not offer any capabilities to risk-adjust stocking policies. They force users to manually generate these policies externally or to use basic rule of thumb math that doesn’t detail the risks associated with the choice of policy.

Summary

Supply chain planning functionality such as inventory optimization isn’t the core focus of EAM  and ERP. You should leverage add-on planning platforms, like Smart IP&O, that support statistical forecasting, planned project management, and inventory optimization. Smart IP&O will develop forecasts and stocking policies that can be input to an EAM or ERP system to drive daily ordering.

For some of our customers, weather has a significant influence on demand. Extreme short-term weather events like fires, droughts, hot spells, and so forth can have a significant near-term influence on demand.

There are two ways to factor weather into a demand forecast: indirectly and directly. The indirect route is easier using the scenario-based approach of Smart Demand Planner. The direct approach requires a tailored special project requiring additional data and hand-crafted modeling.

Indirect Accounting for Weather

The standard model built into Smart Demand Planner (SDP) accommodates weather effects in four ways:

1. If the world is steadily getting warmer/colder/drier/wetter in ways that impact your sales, SDP detects these trends automatically and incorporates them into the demand scenarios it generates.
2. If your business has a regular rhythm in which certain days of the week or certain months of the year have consistently higher or lower-than-average demand, SDP also automatically detects this seasonality and incorporates it into its demand scenarios.
3. Often it is the cussed randomness of weather that interferes with forecast accuracy. We often refer to this effect as “noise”. Noise is a catch-all term that incorporates all kinds of random trouble. Besides weather, a geopolitical flareup, the surprise failure of a regional bank, or a ship getting stuck in the Suez Canal can and have added surprises to product demand. SDP assesses the volatility of demand and reproduces it in its demand scenarios.
4. Management overrides. Most of the time, customers let SDP churn away to automatically generate tens of thousands of demand scenarios. But if users feel the need to touch up specific forecasts using their insider knowledge, SDP can make that happen through management overrides.

Direct Accounting for Weather

Sometimes a user will be able to articulate subject matter expertise linking factors outside their company (such as interest rates or raw materials costs or technology trends) to their own aggregate sales. In these situations, Smart Software can arrange for one-off special projects that provide alternative (“causal”) models to supplement our standard statistical forecasting models. Contact your Smart Software representative to discuss a possible causal modeling project.

Meanwhile, don’t forget your umbrella.

Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory.

Consider a public transit agency.  In most major cities, the annual operating budgets will exceed $3 billion.  Capital expenses for trains, subway cars, and infrastructure may reach hundreds of millions annually. Consequently, a spare parts inventory valued at $150 million might not grab the attention of the CFO or general manager, as it represents a small percentage of the balance sheet.  Moreover, in MRO-based industries, many parts need to support equipment fleets for a decade or more, making additional stock a necessary asset. In some sectors like utilities, holding extra stock can even be incentivized to ensure that equipment is kept in a state of good repair.

We have seen concerns about excess stock arise when warehouse space is limited. I recall, early in my career, witnessing a public transit agency’s rail yard filled with rusted axles valued at over $100,000 each.  I was told the axles were forced to be exposed to the elements due to insufficient warehouse space. The opportunity cost associated with the space consumed by extra stock becomes a consideration when warehouse capacity is exhausted. The primary consideration that trumps all other decisions is how the stock ensures high service levels for internal and external customers.  Inventory planners worry far more about blowback from stockouts than they do from overbuying.  When a missing part leads to an SLA breach or downed production line, resulting in millions in penalties and unrecoverable production output, it is understandable.

Asset-intensive companies are missing one giant point. That is, the extra stock doesn’t insulate against stockouts; it contributes to them. The more excess you have, the lower your overall service level because the cash needed to purchase parts is finite, and cash spent on excess stock means there isn’t cash available for the parts that need it.  Even publicly funded MRO businesses, like utilities and transit agencies, acknowledge the need to optimize spending, now more than ever.  As one materials manager shared, “We can no longer fix problems with bags of cash from Washington.”  So, they must do more with less, ensuring optimal allocation across the tens of thousands of parts they manage.

This is where state-of-the-art inventory optimization software comes in, predicting the required inventory for targeted service levels, identifying when stock levels yield negative returns, and recommending reallocations for improved overall service levels.  Smart Software has helped asset intensive MRO based businesses optimize reorder levels across each part for decades. Give us a call to learn more. 

Some companies invest in software to help them manage their inventory, whether it’s spare parts or finished goods. But a surprising number of others play the Inventory Guessing Game every day, trusting to an imagined “Golden Gut” or to plain luck to set their inventory control parameters. But what kind of results do you expect with that approach?

How good are you at intuiting the right values? This blog post challenges you to guess the best Min and Max values for a notional inventory item. We’ll show you its demand history, give you a few relevant facts, then you can pick Min and Max values and see how well they would work. Ready?

The Challenge

Figure 1 shows the daily demand history of the item. The average demand is 2 units per day. Replenishment lead time is a constant 10 days (which is unrealistic but works in your favor). Orders that cannot be filled immediately from stock cannot be backordered and are lost. You want to achieve at least an 80% fill rate, but not at any cost. You also want to minimize the average number of units on hand while still achieving at least an 80% fill rate. What Min and Max values would produce an 80% fill rate with the lowest average number of units on hand? [Record your answers for checking later. The solution appears below at the end of the article.]

Computing the Best Min and Max Values

The way to determine the best values is to use a digital twin, also known as a Monte Carlo simulation. The analysis creates a multitude of demand scenarios and passes them through the mathematical logic of the inventory control system to see what values will be taken on by key performance indicators (KPI’s).

We built a digital twin for this problem and systematically exercised it with 1,085 pairs of Min and Max values. For each pair, we simulated 365 days of operation a total of 100 times. Then we averaged the results to assess the performance of the Min/Max pair in terms of two KPI’s: fill rate and average on hand inventory.

Figure 2 shows the results. The inherent tradeoff between inventory size and fill rate is clear in the figure: if you want a higher fill rate, you have to accept a larger inventory. However, at each level of inventory there is a range of fill rates, so the game is to find the Min/Max pair that yields the highest fill rate for any given size inventory.

A different way to interpret Figure 2 is to focus on the dashed green line marking the target 80% fill rate. There are many Min/Max pairs that can hit near the 80% target, but they differ in inventory size from about 6 to about 8 units. Figure 3 zooms in on that region of Figure 2 to show  quite a number of Min/Max pairs that are competitive.

We sorted the results of all 1,085 simulations to identify what economists call the efficient frontier. The efficient frontier is the set of most efficient Min/Max pairs to exploit the tradeoff between fill rate and units on hand. That is, it is a list of Min/Max pairs that provide the least cost way to achieve any desired fill rate, not just 80%. Figure 4 shows the efficient frontier for this problem. Moving from left to right, you can read off the lowest price you would have to pay (as measured by average inventory size) to achieve any target fill rate. For example, to achieve a 90% fill rate, you would have to carry an average inventory of about 10 units.

Figures 2, 3, and 4 show results for various Min/Max pairs but do not display the values of Min and Max behind each point. Table 1 displays all the simulation data: the values of Min, Max, average units on hand and fill rate. The answer to the guessing game is highlighted in the first line of the table: Min=7 and Max=13¹. Did you get the right answer, or something close²? Did you maybe get onto the efficient frontier?

Conclusions

Maybe you got lucky, or maybe you do indeed have a Golden Gut, but it’s more likely you didn’t get the right answer, and it’s even more likely you didn’t even try. Figuring out the right answer is extremely difficult without using the digital twin. Guessing is unprofessional.

One step up from guessing is “guess and see”, in which you implement your guess and then wait a while (months?) to see if you like the results. That tactic is at least “scientific”, but it is inefficient.

Now consider the effort to work out the best (Min,Max) pairs for thousands of items. At that scale, there is even less justification for playing the Inventory Guessing Game. The right answer is to play it… Smart³.

¹ This answer has a bonus, in that it achieves a bit more than 80% fill rate at a lower average inventory size than the Min/Max combination that hit exactly 80%. In other words, (7,13) is on the efficient frontier.

² Because these results come from a simulation instead of an exact mathematical equation, there is a certain margin of error associated with each estimated fill rate and inventory level. However, because the average results were based on 100 simulations each 365 days long, the margins of error are small. Across all experiments, the average standard errors in fill rate and mean inventory were, respectively, only 0.009% and 0.129 units.

³ In case you didn’t know this, one of the founders of Smart Software was … Charlie Smart.

Over forty years ago, Smart Software consisted of three friends working to start a company in a church basement. Today, our team has expanded to operate from multiple locations across Massachusetts, New Hampshire and Texas, with team members in England, Spain, Armenia and India. Like many of you in your jobs,  we have found ways to make distributed teams work for us and for you.

This note is about a different kind of teamwork: the collaboration between you and our software that happens at your fingertips. I often write about the software itself and what goes on “under the hood”. This time, my subject is how you should best team up with the software.

Our software suite, Smart Inventory Planning and Optimization (Smart IP&O™) is capable of massively detailed calculations of future demand and the inventory control parameters (e.g., reorder points and order quantities) that would most effectively manage that demand. But your input is required to make the most of all that power. You need to team up with the algorithms.

That interaction can take several forms. You can start by simply assessing how you are doing now. The report writing functions in Smart IP&O (Smart Operational Analytics™) can collate and analyze all your transactional data to measure your Key Performance Indicators (KPIs), both financial (e.g., inventory investment) and operational (e.g., fill rates).

The next step might be to use SIO (Smart Inventory Optimization™), the inventory analytics within SIP&O, to play “what-if” games with the software. For example, you might ask “What if we reduced the order quantity on item 1234 from 50 to 40?” The software grinds the numbers to let you know how that would play out, then you react. This can be useful, but what if you have 50,000 items to consider? You would want to do what-if games for a few critical items, but not all of them.

The real power comes with using the automatic optimization capability in SIO. Here you can team with the algorithms at scale. Using your business judgement, you can create “groups”, i.e., collections of items that share some critical features. For example, you might create a group for “critical spare parts for electric utility customers” consisting of 1,200 parts. Then again calling on your business judgement, you could specify what item availability standard should apply to all the items in that group (e.g., “at least 95% chance of not stocking out in a year”). Now the software can take over and automatically work out the best reorder points and order quantities for every one of those items to achieve your required item availability at the lowest possible total cost. And that, dear reader, is powerful teamwork.