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

Top Five Tips for New Demand Planners and Forecasters

Top Five Tips for New Demand Planners and Forecasters

Good forecasting can make a big difference to your company’s performance, whether you are forecasting to support sales, marketing, production, inventory, or finance. This blog is aimed primarily at those fortunate individuals who are about to start this adventure. Welcome to the field!

Recent Posts

  • Epicor Prophet 21 with Forecasting Inventory PlanningExtend Epicor Prophet 21 with Smart IP&O’s Forecasting & Dynamic Reorder Point Planning
    Smart Inventory Planning & Optimization (Smart IP&O) can help with inventory ordering functionality in Epicor P21, reduce inventory, minimize stockouts and restore your organization’s trust by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning. […]
  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Mature bearded mechanic in uniform examining the machine and repairing it in factoryService Parts Planning: Planning for consumable parts vs. Repairable Parts
    When deciding on the right stocking parameters for spare and replacement parts, it is important to distinguish between consumable and repairable servoce parts. These differences are often overlooked by inventory planning software and can result in incorrect estimates of what to stock. Different approaches are required when planning for consumables vs. repairable service parts. […]
  • Four Common Mistakes when Planning Replenishment TargetsFour Common Mistakes when Planning Replenishment Targets
    How often do you recalibrate your stocking policies? Why? Learn how to avoid key mistakes when planning replenishment targets by automating the process, recalibrating parts, using targeting forecasting methods, and reviewing exceptions. […]
  • Smart Software is pleased to introduce our series of webinars, offered exclusively for Epicor Users.Extend Epicor Kinetic’s Forecasting & Min/Max Planning with Smart IP&O
    Epicor Kinetic can manage replenishment by suggesting what to order and when via reorder point-based inventory policies. The problem is that the ERP system requires that the user either manually specify these reorder points, or use a rudimentary “rule of thumb” approach based on daily averages. In this article, we will review the inventory ordering functionality in Epicor Kinetic, explain its limitations, and summarize how to reduce inventory, and minimize stockouts by providing the robust predictive functionality that is missing in Epicor. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Blanket Orders Smart Software Demand and Inventory Planning HDBlanket Orders
      Our customers are great teachers who have always helped us bridge the gap between textbook theory and practical application. A prime example happened over twenty years ago, when we were introduced to the phenomenon of intermittent demand, which is common among spare parts but rare among the finished goods managed by our original customers working in sales and marketing. This revelation soon led to our preeminent position as vendors of software for managing inventories of spare parts. Our latest bit of schooling concerns “blanket orders.” […]
    • Hand placing pieces to build an arrowProbabilistic Forecasting for Intermittent Demand
      The New Forecasting Technology derives from Probabilistic Forecasting, a statistical method that accurately forecasts both average product demand per period and customer service level inventory requirements. […]
    • Engineering to Order at Kratos Space – Making Parts Availability a Strategic Advantage
      The Kratos Space group within National Security technology innovator Kratos Defense & Security Solutions, Inc., produces COTS s software and component products for space communications - Making Parts Availability a Strategic Advantage […]
    • wooden-figures-of-people-and-a-magnet-team-management-warehouse inventoryManaging the Inventory of Promoted Items
      In a previous post, I discussed one of the thornier problems demand planners sometimes face: working with product demand data characterized by what statisticians call skewness—a situation that can necessitate costly inventory investments. This sort of problematic data is found in several different scenarios. In at least one, the combination of intermittent demand and very effective sales promotions, the problem lends itself to an effective solution. […]