Lessons From Superstorm Sandy

The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

The destructive impact of Hurricane Sandy has been both staggering and instructive. Our thoughts and best wishes for rapid recovery go out to all who have suffered personal or economic loss or damage. Now, in Sandy’s aftermath, we find ourselves thinking about accelerating recovery and planning for the next unforeseen event.

Our work with clients in the heavily hit mass transit sector presented a sobering view of damaged infrastructure, heavy equipment, and losses of essential inventory. Those most affected have seen a crush of work as inventory managers take stock of what they have, what they need and procure a mountain of replacement parts and products. This uniquely massive replenishment cycle presents all sorts of opportunities and considerations. For those who are still in this phase, and to help our collective preparation for the Next Big Event, here are a few thoughts:

Opportunity to immediately “right size” inventory

You may be in a position to receive a large, one-time infusion of funding for replacement inventory. It could be insurance money, federal relief or rainy day funds from your own treasury. Use the funding to establish the best possible inventory mix. Do not order to previously established Min/Max levels. Doing so may simply repeat excesses and shortfalls of the past.

A major event like Sandy presents a rare opportunity to transform your inventory. Start with an accurate demand forecast over the replenishment period, and generate safety stocks and reorder points that would address your critical needs. This can be accomplished in a matter of hours or days. Ordinarily, implementing optimal inventory levels may occur over several years, as excess inventory is gradually depleted. Now, however, you have a one-time opportunity to jump to the right answer. This shift can substantially reduce replenishment spending, freeing hundreds of thousands of dollars for other, more critical recovery uses.

Prioritize classes to be replenished

Be clear on what you need for crucial operations, and prioritize your replenishment. Which parts have long lead-times, and which are readily available? Obviously short lead-time items can be acquired in stages—getting just enough now, making funds available for the longer lead-time items.

Determine how much is “just enough”

This is where an accurate demand forecast, safety stocks and reorder point calculations come into play. Consider the service level you require—the likelihood that products will be on the shelves when you need them—which is really your tolerance for risk. Do this for each item, or class of items. This will tell you how much safety stock, in addition to your expected lead time forecast, you should have on hand. Iterating on service level-driven requirements will enable you to maximize the value of the replenishment budget at hand.

Statistical forecasting for intermittent demand vs. ‘rule of thumb’ methods

Now is the time to shift from ‘the way we’ve done it’ to the most accurate demand forecasting and inventory optimization process available to you. Greater forecast accuracy requires less safety stock—again, making inventory dollars available for other users. The greatest single category for improvement is intermittent demand. Most organizations do not apply solid statistical methods to this, instead resorting to the “heavy hammer rule”—have lots on hand because no one knows. Here is an area where SmartForecasts is especially adept, with a patented solution for forecasting intermittent demand. The resulting safety stock recommendations hit the service level goal nearly 100% of the time. Getting this right will save lots of spending now, and help minimize the potential for excess, obsolete inventory in the future.

Nelson Hartunian, PhD, co-founded Smart Software, formerly served as President, and currently oversees it as Chairman of the Board. He has, at various times, headed software development, sales and customer service.

Leave a Comment

Related Posts

Why MRO Businesses Need Add-on Service Parts Planning & Inventory Software

Why MRO Businesses Need Add-on Service Parts Planning & Inventory Software

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. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning.

The Forecast Matters, but Maybe Not the Way You Think

The Forecast Matters, but Maybe Not the Way You Think

True or false: The forecast doesn’t matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes.

Why MRO Businesses Should Care About Excess Inventory

Why MRO Businesses Should Care About Excess Inventory

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.

Recent Posts

  • Finding Your Spot on the Inventory Tradeoff CurveFinding Your Spot on the Inventory Tradeoff Curve
    This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium. […]
  • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
    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. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
  • Descriptive, Predictive, and Prescriptive AnalyticsThe Three Types of Supply Chain Analytics
    In this video blog, we explore the critical roles of Descriptive, Predictive, and Prescriptive Analytics in inventory management, highlighting their essential contributions to driving supply chain optimization through strategic foresight and insightful data analysis. […]
  • Warning Signs that You Have a Supply Chain Analytics GapWarning Signs that You Have a Supply Chain Analytics Gap
    “Business is war” may be an overdone metaphor but it’s not without validity. Like the “Bomber Gap” and the “Missile Gap,” worries about falling behind the competition, and the resulting threat of annihilation, always lurk in the minds of business executives, If they don’t, they should, because not all gaps are imaginary (the Bomber Gap and the Missile Gap were shown to not exist between the US and the USSR, but the 1980’s gap between Japanese and American productivity was all too real). The difference between paranoia and justified concern is converting fear into facts. This post is about organizing your attention toward possible gaps in your company’s supply chain analytics. […]
  • The Objectives in ForecastingThe Objectives in Forecasting
    A forecast is a prediction about the value of a time series variable at some time in the future. For instance, one might want to estimate next month’s sales or demand for a product item. A time series is a sequence of numbers recorded at equally spaced time intervals; for example, unit sales recorded every month. The objectives you pursue when you forecast depend on the nature of your job and your business. Every forecast is uncertain; in fact, there is a range of possible values for any variable you forecast. Values near the middle of this range have a higher likelihood of actually occurring, while values at the extremes of the range are less likely to occur. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
      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. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
    • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
      True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
    • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
      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. […]
    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]