A statistical forecast of zero can cause lots of confusion for forecasters, especially when the historical demand is non-zero.  Sure, it’s obvious that demand is trending downward, but should it trend to zero?  When the older demand is much greater than the more recent demand and the more recent demand is very low volume (i.e., 1,2,3 units demanded), the answer is, statistically speaking, yes.  However, this might not jive with the planner’s business knowledge and expected minimum level of demand.  So, what should a forecaster do to correct this? Here are three suggestions:

1. Limit the historical data fed to the model. In a down trending situation, the older data is often much greater than the recent data.   When the older much higher volume demand is ignored, the down trend won’t be nearly as significant.  You’ll still forecast a down trend, but results are more likely to be line with business expectations.

2. Try trend dampening. Smart Demand Planner has a feature called “trend hedging” that enables users to define how a trend should phase out over time. The higher the percentage trend hedge (0-100%), the more pronounced the trend dampening.  This means that a forecasted trend will not continue through the whole forecast horizon.  This means the demand forecast will start to flatten before it hits zero on a downtrend.

3. Change the forecast model. Switch from a trending method like Double Exponential Smoothing or Linear Moving Average to a non-trending method such as Single Exponential Smoothing or Simple Moving Average. You won’t forecast a downtrend, but at least your forecast won’t be zero and thus more likely to be accepted by the business.

5 Steps to Consensus Demand Planning

The whole point of demand forecasting is to establish the best possible view of future demand.  This requires that we draw upon the best data and inputs we can get, leverage statistics to capture underlying patterns, put our heads together to apply overrides based on business knowledge, and agree on a consensus demand plan that serves as cornerstone to the company’s overall demand plan.

Step 1: Develop an accurate demand signal.   What constitutes demand?  Consider how  your organization defines demand – say, confirmed sales orders net of cancellations or shipment data adjusted to remove the impact of historical stockouts  – and use this consistently.  This is your measure of what the market is requesting you to deliver.  Don’t confuse this with your ability to deliver – that should be reflected in the revenue plan.

Step 2: Generate a statistical forecast.  Plan for thousands of items, using a proven forecasting application that automatically pulls in your data and reliably produces accurate forecasts for all of your items.  Review the first pass of your forecast, then make adjustments.  A strike or train wreck may have interrupted shipping last month – don’t let that wag your forecast.  Adjust for these and reforecast.  Do the best you can, then invite others to weigh in.

Step 3: Bring on the experts.  Product line managers, sales leaders, key distribution partners know their markets.  Share your forecast with them.  Smart uses the concept of a “Snapshot” to share a facsimile of your forecast – at any level, for any product line – with people who may know better.  There could be an enormous order that hasn’t hit the pipeline, or a channel partner is about to run their annual promotion.  Give them an easy way to take their portion of the forecast and change it.  Drag this month up, that one down …

Step 4:  Measure Accuracy and Forecast Value Add.  Some of your contributors may be right on the money, other tend to be biased high or low.  Use forecast vs. actuals reporting and measure forecast value add analysis to measure forecast errors and whether changes to the forecast are hurting or helping.  By informing the process with this information, your company will improve it’s ability to forecast more accurately.

Step 5: Agree on the Consensus Forecast.  You can do this one product line or geography at a time, or business by  business.  Convene the team, graphically stack up their inputs, review past accuracy performance, discuss their reasons for increasing or reducing the forecast, and agree on whose inputs to use.  This becomes your consensus plan.  Finalize the plan and send it off – upload forecasts to MRP, send to finance and manufacturing.  You have just kicked off your Sales, Inventory and Operational Planning process.

You can do this.  And we can help.  If you have any questions about collaborative demand planning please reply to this blog, we will follow up.

Belmont, Mass., December 2022 –  Smart Software is pleased to announce that Co-Founder Dr. Thomas R. Willemain’s article “Managing Inventory amid Regime Change” has won 1st place in the Forecasting category of the 2022 Supply Chain Brief MVP Awards.

“Regime change” is a statistical term meaning a major change in the character of the demand for an inventory item. An item’s demand history is the fuel that powers demand planners’ forecasting machines. In general, the more fuel the better, giving us a better fix on the average level,  the shape of any seasonality pattern, and the size and direction of any trend. But there is one big exception to the rule that “more data is better data.” If there is a major shift in your business and new demand doesn’t look like old demand, then old data become dangerous.

Read the MVP Award winner article here  https://smartcorp.com/inventory-optimization/managing-inventory-amid-regime-change/

Supply Chain Brief brings together the best content from hundreds of industry thought leaders. This MVP Award recognizes the Most Valuable Post as judged by Supply Chain Brief’s audience, award committee, and social media. Smart Software has been recognized to provide the highest value to industry professionals and useful information that is strategic in nature. https://www.supplychainbrief.com/mvp-awards/2022-SCB-MVP-AWARDS/forecasting

Dr. Thomas R. Willemain is Co-Founder and Senior VP for Research at Smart Software.  He has been a professor at MIT and the Harvard Kennedy School of Government and is now Professor Emeritus of Industrial and Systems Engineering at Rensselaer Polytechnic Institute.  Tom was a Distinguished Visiting Professor at the FAA and supported the Intelligence Community as Expert Statistical Consultant (GS15) in NSA’s Mathematics Research Group and later at IDA’s Center for Computing Sciences.  He holds degrees from Princeton University (BSE, summa cum laude) and Massachusetts Institute of Technology (MS and PhD), all in Electrical Engineering.

About Smart Software, Inc.
Founded in 1981, Smart Software, Inc. is a leader in providing businesses with enterprise-wide demand forecasting, planning and inventory optimization solutions. Smart Software’s demand forecasting and inventory optimization solutions have helped thousands of users worldwide, including customers at mid-market enterprises and Fortune 500 companies, such as Disney, Arizona Public Service, and Ameren. Smart Inventory Planning & Optimization gives demand planners the tools to handle sales seasonality, promotions, new and aging products, multi-dimensional hierarchies, and intermittently demanded service parts and capital goods items. It also provides inventory managers with accurate estimates of the optimal inventory and safety stock required to meet future orders and achieve desired service levels. Smart Software is headquartered in Belmont, Massachusetts, and can be found online at www.smartcorp.com.

Why Days of Supply Targets Don’t Work when Computing Safety Stocks

CFOs tell us they need to spend less on inventory without impacting sales.  One way to do that is to move away from using targeted day of supply to determine reorder points and safety stock buffers.   Here is how a days of supply model works:

1. Compute average demand per day and multiply the demand per day by supplier lead time in days to get lead time demand
2. Pick a days of supply buffer (i.e., 15, 30, 45 days, etc.). Use larger buffers being used for more important items and smaller buffers for less important items.
3. Add the desired days of supply buffer to demand over the lead time to get the reorder point. Order more when on hand inventory falls below the reorder point

Here is what is wrong with this approach:

1. The average doesn’t account for seasonality and trend – you’ll miss obvious patterns unless you spend lots of time manually adjusting for it.
2. The average doesn’t consider how predictable an item is – you’ll overstock predictable items and understock less predictable ones. This is because the same days of supply for different items yields a very different stock out risk.
3. The average doesn’t tell a planner how stock out risk is impacted by the level of inventory – you’ll have no idea whether you are understocked, overstocked, or have just enough. You are essentially planning with blinders on.

There are many other “rule of thumb” approaches that are equally problematic.  You can learn more about them in this post. 

A better way to plan the right amount of safety stock is to leverage probability models that identify exactly how much stock is needed given the risk of stock-out you are willing to accept.   Below is a screenshot of Smart Inventory Optimization that does exactly that.  First, it details the predicted service levels (probability of not stocking out) associated with the current days of supply logic.  The planner can now see the parts where predicted service level is too low or too costly.  They can then make immediate corrections by targeting the desired service levels and level of inventory investment. Without this information, a planner isn’t going to know whether the targeted days of safety stock is too much, too little, or just right resulting in overstocks and shortages that cost market share and revenue. 

In Smart Software’s forty-plus years of providing forecasting software, we’ve met many people who find themselves, perhaps surprisingly, becoming demand forecasters. This blog is aimed primarily at those fortunate individuals who are about to start this adventure (though seasoned pros may enjoy the refresher).

Welcome to the field! Good forecasting can make a big difference to your company’s performance, whether you are forecasting to support sales, marketing, production, inventory, or finance.

There is a lot of math and statistics underlying demand forecasting methods, so your assignment suggests that you are not one of those math-phobic people who would rather be poets. Luckily, if you are feeling a bit shaky and not yet healed from your high school geometry class, a lot of the math is built into forecasting software, so your first job is to leave the math for later while you get a view of the big picture. It is indeed a big picture, but let’s isolate few of the ideas that will most help you succeed.

1. Demand Forecasting is a team sport. Even in a small company, the demand planner is part of a team, with some folks bringing the data, some bringing the tech, and some bringing the business judgment. In a well-run business, your job will never be to simply feed some data into a program and send out a forecast report. Many companies have adopted a process called Sales and Operations Planning (S&OP) in which your forecast will be used to kick off a meeting to make certain judgments (e.g., Should we assume this trend will continue? Will it be worse to under-forecast or over-forecast?) and to blend extra information into the final forecast (e.g., sales force input, business intelligence on competitors’ moves, promotions). The implication for you is that your skills at listening and communicating will be important to your success.

2. Statistical Forecasting engines need good fuel. Historical data is the fuel used by statistical forecasting programs, so bad or missing or delayed data can degrade your work product. Your job will implicitly include a quality control aspect, and you must keep a keen eye on the data that are supplied to you. Along the way, it is a good idea to make the IT people your friends.

3. Your name is on your forecasts. Like it or not, if I send forecasts up the chain of command, they get labeled as “Tom’s forecasts.” I must be prepared to own those numbers. To earn my seat at the table, I must be able to explain what data my forecasts were based on, how they were calculated, why I used Method A instead of Method B to do the calculations, and especially how firm or squishy they are. Here honesty is important. No forecast can reasonably be expected to be perfectly accurate, but not all managers can be expected to be perfectly reasonable. If you’re unlucky, your management will think that your reports of forecast uncertainty suggest either ignorance or incompetence. In truth, they indicate professionalism. I have no useful advice about how best to manage such managers, but I can warn you about them. It’s up to you to educate those who use your forecasts. The best managers will appreciate that.

4. Leave your spreadsheets behind. It’s not uncommon for someone to be promoted to forecaster because they were great with Excel. Unless you are with an unusually small company, the scale of modern corporate forecasting overwhelms what you can handle with spreadsheets. The increasing speed of business compounds the problem: the sleepy tempo of annual and quarterly planning meetings is rapidly giving way to weekly or even daily re-forecasts as conditions change. So, be prepared to lean on a professional vendor of modern, scalable cloud-based demand planning and statistical forecasting software for training and support.

5. Think visually. It will be very useful, both in deciding how to generate demand forecasts and in presenting them to management, so take advantage of the visualization capabilities built into forecasting software. As I noted above, in today’s high-frequency business world, the data you work with can change rapidly, so what you did last month may not be the right thing to do this month. Literally keep an eye on your data by making simple plots, like “timeplots” that show things like trend or seasonality or (especially) changes in trend or seasonality or anomalies that must be dealt with. Similarly, supplementing tables of forecasts with graphs comparing current forecasts to prior forecasts to actuals can be very helpful in an S&OP process. For example, timeplots showing past values, forecasted values, and “forecast intervals” indicating the objective uncertainty in the forecasts provide a solid basis for your team to fully appreciate the message in your forecasts.

That’s enough for now. As a person who’s taught in universities for half a century, I’m inclined to start into the statistical side of forecasting, but I’ll save that for another time. The five tips above should be helpful to you as you grow into a key part of your corporate planning team. Welcome to the game!