The Smart Forecaster

Pursuing best practices in demand planning,

forecasting and inventory optimization

In order to reap the efficiency benefits of forecasting, you need the most accurate forecasts—forecasts built on the most appropriate historical data. Most discussions of this issue tend to focus on the merits of using demand vs. shipment history—and I’ll comment on this later. But first, let’s talk about the use of net vs. gross data.

Net vs. Gross History

Many planners are inclined to use net sales data to create their forecasts. Systems that track sales capture transactions as they occur and aggregate results into weekly or monthly periodic totals. In some cases, sales records account for returned purchases as negative sales and compute a net total. These net figures, which often mask real sales patterns, are fed into the forecasting system. The historical data used actually presents a false sense of what the customer wanted, and when they wanted it. This will carry forward into the forecast, with less than optimal results.

Suppose your sales data is aggregated into monthly totals. If monthly net figures are used, and returns occur in the same month that they are purchased, no problem. The net activity for the month reflects actual demand. But what if the product is returned three or four months after it was purchased, as often occurs? The net figures are underestimate interest in the product for the month when the return is counted, and (it would seem) overestimate demand for the month of the initial sale. Reflecting product demand at the wrong time in this way interferes with the forecasting system’s ability to properly identify the pattern (or lack thereof) in the data.

Since you fill orders you as you get them, you are hardly going to decline to ship because you think they might return the product in a few months. Customers wouldn’t stand for that. So of course you want to know that such demand is likely to occur. If the orders are going to come, you need stock in your inventory to meet the demand, regardless of later returns. Using net figures is not the best practice in these situations.

In most cases, data used in preparing forecasts needs to be based on gross figures. Returns can be forecast as a separate variable and used as a source of incoming supply. This will result in fewer unnecessary orders of new inventory. Ultimately, this approach better captures the true patterns in the data—the heart of forecasting.

Shipment vs. Demand Data

A second important distinction regarding historical data may seem counter-intuitive. Forecasters are nearly always encouraged to use demand data because it is assumed to better reflect what the customer wanted and when. However, when you have the choice, it can sometimes be smarter to use shipment data.

One guiding principle is to consider the accuracy of the data. In most businesses, the shipment data accurately reflects exactly what was shipped, while the demand data is often plagued with inaccuracies. Here are a few examples:

Customers may know, for example, that you will be unable to fill their order. In that case, they may refrain from placing the order, holding off until they believe you have stock on hand to meet their needs. On the other hand, anxious customers may file multiple electronic orders, concerned that some miscommunication could prevent a vital order from being processed. When assured that one order has been accepted, they may cancel the additional orders. Then there is the case of a customer that has experienced stockouts with you in the past. They may increase the size of their orders to maximize the chance that inventory will be allocated to them.

If such practices plague your order history, it may be more prudent to use shipping data. You can then use SmartForecasts’ “adjust history” feature to fine tune the shipment data—so it better reflects demand. You can certainly do the same on inaccurate demand data but often this will require much more effort than simply correcting for obvious cases where shipments are low one month and high the next due to a stock-out situation.

Before making a decision on whether to use shipment or demand data, it is important to understand how orders and returns are accounted for in your system. Talk to your customer service reps and ask them about how they would account for these situations. Don’t take your IT department’s word for it. Exercise your judgment to get the best results.

Making the right data choices will go a long way toward achieving valuable supply chain efficiencies. Take the time to read Michael Gilliland’s post on this topic at the Institute of Business Forecasting and Planning’s blog, at demand-planning.com.

Gregory Hartunian serves as President of Smart Software and as a member of the Board of Directors. He previously held the position of Vice President of Sales.

Leave a Comment

Related Posts

You Need to Team up with the Algorithms

You Need to Team up with the Algorithms

This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software.

Rethinking forecast accuracy: A shift from accuracy to error metrics

Rethinking forecast accuracy: A shift from accuracy to error metrics

Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information.

Every Forecasting Model is Good for What it is Designed for

Every Forecasting Model is Good for What it is Designed for

With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do.

Recent Posts

  • Direct to the Brain of the Boss- Inventory AnalysisDirect to the Brain of the Boss – Inventory Analytics and Reporting
    In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies. […]
  • You need to team up with the algorithms for Inventory ManagementYou Need to Team up with the Algorithms
    This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software. […]
  • Rethinking forecast accuracy, A shift from accuracy to error metricsRethinking forecast accuracy: A shift from accuracy to error metrics
    Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information. […]
  • Using Key Performance Predictions to Plan Stocking Policies
    I can't imagine being an inventory planner in spare parts, distribution, or manufacturing and having to create safety stock levels, reorder points, and order suggestions without using key performance predictions of service levels, fill rates, and inventory costs. […]
  • Every forecasting model is good for what it is designed forEvery Forecasting Model is Good for What it is Designed for
    With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • 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. […]
    • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
      In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
    • 5 Steps to Improve the Financial Impact of Spare Parts Planning5 Steps to Improve the Financial Impact of Spare Parts Planning
      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. […]
    • Bottom Line strategies for Spare Parts Planning SoftwareBottom Line Strategies for Spare Parts Planning
      Managing spare parts presents numerous challenges, such as unexpected breakdowns, changing schedules, and inconsistent demand patterns. Traditional forecasting methods and manual approaches are ineffective in dealing with these complexities. To overcome these challenges, this blog outlines key strategies that prioritize service levels, utilize probabilistic methods to calculate reorder points, regularly adjust stocking policies, and implement a dedicated planning process to avoid excessive inventory. Explore these strategies to optimize spare parts inventory and improve operational efficiency. […]