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

The top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts

The top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts

We often encounter Excel-based reorder point planning methods. In this post, we’ve detailed an approach that a customer used prior to proceeding with Smart. We describe how their spreadsheet worked, the statistical approaches it relied on, the steps planners went through each planning cycle, and their stated motivations for using (and really liking) this internally developed spreadsheet.

Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning

Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning

When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think.

Spare Parts Planning Isn’t as Hard as You Think

Spare Parts Planning Isn’t as Hard as You Think

When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think.

Recent Posts

  • Fifteen questions that reveal how forecasts are computed in your companyFifteen questions that reveal how forecasts are computed in your company
    In a recent LinkedIn post, I detailed four questions that, when answered, will reveal how forecasts are being used in your business. In this article, we’ve listed questions you can ask that will reveal how forecasts are created. […]
  • Businessman and businesswoman reading and analysing spreadsheetThe top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts
    We often encounter Excel-based reorder point planning methods. In this post, we’ve detailed an approach that a customer used prior to proceeding with Smart. We describe how their spreadsheet worked, the statistical approaches it relied on, the steps planners went through each planning cycle, and their stated motivations for using (and really liking) this internally developed spreadsheet. […]
  • Style business group in classic business suits with binoculars and telescopes reproduce different forecasting methodsHow to interpret and manipulate forecast results with different forecast methods
    This blog explains how each forecasting model works using time plots of historical and forecast data. It outlines how to go about choosing which model to use. The examples below show the same history, in red, forecasted with each method, in dark green, compared to the Smart-chosen winning method, in light green. […]
  • Factory worker engineer working in factory using tablet computer to check maintenance boiler water pipe in factory.Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning
    When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
  • What to do when a statistical forecast doesn’t make senseWhat to do when a statistical forecast doesn’t make sense
    Sometimes a statistical forecast just doesn’t make sense. Every forecaster has been there. They may double-check that the data was input correctly or review the model settings but are still left scratching their head over why the forecast looks very unlike the demand history. When the occasional forecast doesn’t make sense, it can erode confidence in the entire statistical forecasting process. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Businessman and businesswoman reading and analysing spreadsheetThe top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts
      We often encounter Excel-based reorder point planning methods. In this post, we’ve detailed an approach that a customer used prior to proceeding with Smart. We describe how their spreadsheet worked, the statistical approaches it relied on, the steps planners went through each planning cycle, and their stated motivations for using (and really liking) this internally developed spreadsheet. […]
    • Factory worker engineer working in factory using tablet computer to check maintenance boiler water pipe in factory.Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning
      When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
    • Portrait of factory worker woman with blue hardhat holds tablet and stand in spare parts workplace area. Concept of confident of working with spare parts planning software.Spare Parts Planning Isn’t as Hard as You Think
      When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
    • Worker on a automotive spare parts warehouse using inventory planning softwareService-Level-Driven Planning for Service Parts Businesses
      Service-Level-Driven Service Parts Planning is a four-step process that extends beyond simplified forecasting and rule-of-thumb safety stocks. It provides service parts planners with data-driven, risk-adjusted decision support. […]