Category Archives: Forecasts

Consumer Damnation 74: Demand Planning

Each group of customers are a damnation upon themselves, and they will get the attention they deserve, but demand planning to meet customer demand is its own damnation. Why is this?

Traditional demand planning models require historical data.

To be precise, they require a fair amount of historical sales or usage data in order to be accurate. And sometimes a lot of sales data. But with new product introductions coming fast and furious every day, there are so many categories without a decent amount, if any, historical sales data that it’s hard to make good predictions. Now, one can always use the most similar product, or the product the new product is expected to replace, but this weakens the model and the confidence in the result.

Traditional demand planning models require market predictability.

To be more precise, they expect that the market will not substantially change. That the needs will stay the same. The utilization or replacement curves will stay about the same. That a competitor won’t substantially increase or decrease their market share overnight. That a revolutionary new product won’t be released that causes a huge market shift.

Traditional demand planning models require market foresight.

In addition to requiring historical data and market predictability, traditional demand planning requires market foresight. Knowledge of potential competitor product introductions that could change the market demand. Knowledge of innovations that will begin demand shifts. Knowledge of general market conditions that could delay replacements or result in reduced demand due to cash availability.

Demand Planning requires knowledge of the expected price point.

Most products are services, especially in the end consumer market, are very price dependent. People will pay more if they perceive more value, which could be better quality, more functionality, or owning an iconic brand, but if they don’t perceive more value in your product which is priced higher than a competitor’s product, don’t think for a minute, even if they bought from you last time, they won’t shift. And price prediction is difficult if it is dependent on production cost, which can be variable if transportation can involve unpredictable fuel surcharges, raw material prices can skyrocket due to insufficient supply as a result of a disaster, and labour prices are dependent on contingent labour to meet demands at peak periods.

In other words, sometimes demand prediction models fall flat, and demand projections come from a place that can only be seen by a proctologist with a flashlight, so how do you effectively plan for those as a Procurement Professional? You don’t. It’s damnation.

Finally, a Prediction SI Can Get Behind!

By now, everyone should know how SI, and the LOLCats who live under the desks, feel about futurists and their predictions. (You need only scroll back to December 31’s post if you have forgotten.)

So, needless to say, as per prior years, SI is not going to be jumping on the prediction bandwagon (and risk getting trampled by fellow bloggers on the way) as the new year rolls in.

That being said, it has to give a shout out to one prediction from a fellow blogger who may just have it right. Specifically, Peter Smith of Spend Matters UK who, pressed for a prediction, made the amazingly accurate prediction that we predict that all predictions will be wrong.

SI could not have said it better if asked.

LOLCat approves!

Procurement Trend #26: Increased Accuracy in Demand Planning

Twenty-three lacklustre, backwater, trends from yester-year still remain, so let’s get back to it. The sooner we get through these, the sooner we get back to modern times.

So why do so many historians keep pegging increased accuracy as a future trend, and helping poor LOLCat regress to past lives? There are a number of reasons, but among the top three today are:

    • Hyper-competitive markets make demand planning difficult
      because a one week’s difference in release date due to an unexpected delay can result in a competitor beating you to market and siphoning off a significant portion of your expected market share for the product
  • lack of long-term data in short lifecycle product categories makes trending hard
    which makes it even harder to predict not only when a product instance is going to reach end of useful (sales) life but when the next iteration is going to bomb because the product has reached end of life and needs to be retired
  • most tools are still using outdated inventory models
    because the initial versions were created twenty, thirty, and even forty years ago and it’s just not possible to force fit new, complex, innovative inventory costing and projection models into them

So what do you do?

Hyper-Competitive Markets

As per above, Procurement not only needs to identify suppliers who can add value at little or no incremental cost but needs to identify suppliers who can help it get an edge in these markets. It needs to move to JIT (Just in Time) production and distribution to the extent possible, track product and consumer trends carefully, and adapt as needed.

Lack of Long-Term Data in Short Lifecycle Product Categories

It needs to collect as much market data as it can from analyst and trade bureaus to identify global trends, and analyze all of the data it has on past and current products to predict life-cycle trends that are in-line with current market conditions.

Outdated Inventory & Forecasting Models

It needs to update its inventory management and demand planning tools ASAP to not only plan with more data, more resolution, and more options, but support forecasting under different conditions.

8 Key Design Considerations for Optimizing Your Demand Planning Process: Part II


Today’s guest post is from Josh Peacher, a Senior Consultant in the Operations Practice of Archstone Consulting, A Hackett Group Company.

In the first installment, we focused on defining the 4 basic design considerations for optimizing your organization’s demand planning process. These considerations included:

  1. Utilization of time series forecasting and exception management to drive a base forecast
  2. Selecting the right software tool for your business
  3. Identifying a set of core metrics and KPIs that help to identify opportunities and drive accountability
  4. Effectively leveraging external information to elicit a more accurate forecast

These design considerations are foundational in nature and effectively addressing each will ensure that your organization’s demand planning process has a solid base. However, to truly move the needle towards world class performance, a set of more advanced considerations must be applied.

5. Drive Towards a Consensus Demand Plan

A formal demand planning process should conclude with an aligned set of forecast numbers that the entire organization understands and can speak to. This doesn’t necessarily mean that a “One-Number” forecast must be reached as this can be very difficult and cause a whole set of different issues. However, organizations should look to align on a set of numbers and be prepared to speak to and manage to the gaps. Key participants in the consensus demand plan conversation include Sales and Account Teams, Finance, Supply Planning, and Demand Planning. Each of these groups will bring a different perspective and set of information to the discussion resulting in a more informed final demand plan.

6. Identify the Right Level of Detail

When defining the appropriate level of detail to forecast at, leading companies strike a balance between importance to the business and complexity of the process. The diagram below defines a general set of guidelines for identifying the appropriate level of forecast detail based on the situation. As a general rule of thumb, the more important and complex the set of items is to the business, the higher the required level of detail and rigor.

Complexity vs. Importance

7. Ensure Adequate Resources

As I mentioned in the first installment, demand planning is commonly an overlooked element of supply chain planning. This often leads to an insufficient allocation of resources by the organization. Demand planning is an arduous process that requires a high level of dedication and attention. More times than not, I see organizations that have failed to realize this and leave their demand planning team without the necessary bandwidth to perform effectively. The net effect is a less accurate forecast, poor demand signals trickling through the system, and a higher turnover rate. A few simple rules of thumb to ensure that your organization is not falling into this trap include the following:

  • Install dedicated analysts for demand planning.
    This will ensure that demand planners are focusing on value-add activities and have the right information on hand to make informed decisions.
  • Make sure that your demand planners aren’t wearing too many organizational hats.
    It’s an odd phenomenon but demand planners often end up taking on responsibilities that are well outside of their job scope and not essential to their core function. The best way to decipher this is just to simply ask them where their pain points are. Trust me … they will tell you!
  • Understand which segments are the most critical and complex to the business and distribute them across your demand planner resources.
    Ideally, each of your demand planners will have a portfolio of demand responsibilities that are evenly distributed amongst the four quadrants of the above diagram.

8. Define your Organization Process Model

Too often I have seen organizations operating in an environment of chaos because they lack a defined process and cadence for their demand planning cycle. You may believe that you have a process in place, but can you articulate what it is? Can the demand planning resources in your organization define the calendar of events that make up the process? Many times what people believe to be a process is actually floating tribal knowledge and tends to vary depending on who you ask within the organization. Without a well-defined process, it’s difficult to hold others accountable and overall performance tends to suffer. An optimal process must be defined for each organization based upon it’s unique set of variables and constraints. However, the list below is a set of monthly activities that can be found in most leading company processes.

  • Prepare Data –
    Cleanse and gather all required data for the demand planning process (internal and external)
  • Generate Initial Forecast –
    Generate both the base statistical forecast and manage exception SKUs manually
  • Incorporate Market Intelligence –
    Collaborate with trade partners and external contacts to incorporate quantitative and qualitative data into the forecast (e.g., POS Data, Customer Forecast, Promotional Calendars, Pull-Forward Buys)
  • Consensus Reconciliation Meeting –
    Meet with sales and finance to reconcile the bottoms up forecast with top down financials and sales forecasts
  • Refine and Publish Final Forecast –
    Make final adjustments to forecast before transmitting to ERP
  • Monitor Performance –
    Monitor forecast for large anomalies and diagnose root cause of error

Thanks, Josh!

8 Key Design Considerations for Optimizing Your Demand Planning Process: Part I


Today’s guest post is from Josh Peacher, a Senior Consultant in the Operations Practice of Archstone Consulting, A Hackett Group Company.

Demand Planning was once an overlooked element of supply chain management. However, more and more companies are beginning to understand how essential this component is to overall operational well-being. After all, a demand forecast is the genesis of the supply chain process. If poor demand signals are being sent through the system, it becomes extremely difficult to manage raw material and finished goods inventories, execute an efficient manufacturing process, effectively service customers, and ultimately drive an accurate financial forecast. So if your organization hasn’t already taken a long, hard look at improving its demand planning process, it’s time to begin. As a starting point for your journey, let’s take a look at the 8 key design considerations for optimizing your demand planning process. In this first installment, we’ll focus on the 4 most basic design considerations and then move to more advanced principals in the second installment.

1. Start with Statistical Forecasting and Exception Management

  • Statistical forecasting should always drive the original forecast. A simple set of formulas such as exponential smoothing, weighted moving average, and Holt-Winters can deliver more accurate, reliable, and efficient forecasts across the entire sku base than manual forecasts. This can often be a change management challenge for many organizations as demand planners feel a pride of ownership over their forecast and have trouble with relinquishing control to a set of arithmetic functions. This is where exception reporting comes into play.
  • Exception reporting utilizes a set of pre-defined criteria to identify skus that are not ideal candidates for statistical forecasting. Since the strength of statistical forecasting comes from identifying patterns in demand history, highly erratic and/or variable skus are not good candidates and require manual intervention of the forecast. While exception criteria are customizable, common filters include frequent zero demand periods, high variance between last 6 months history and next 6 months forecast, high variance in month-over-month demand history, and frequent shortages. Exception reporting is also an excellent way for demand planners to prioritize their time across the sku set and focus their efforts on the skus that truly require attention.

2. Select the Right Software Tool

In today’s environment of sku proliferation and real time information, it’s become a necessity to utilize a demand planning tool to assist with the demand planning process. Software solutions such as Manugistics, SAP APO, and Logility all have their strengths and weaknesses. Key criteria to evaluate when selecting a solution include:

  • Customer service reputation of the provider
  • The tool’s ability to handle forecasting nuances (i.e., 5-4-4 calendar recognition and promotional forecasts)
  • Transparency and reliability of the generated statistical forecast
  • Forecast performance reporting and exception reporting capabilities
  • Flexibility to forecast at multiple levels (e.g., sku, customer, category, business unit)

3. Track the Right Metrics

Demand planning metrics should serve two purposes:

  1. Identify improvement opportunities and
  2. Drive accountability.

The appropriate metrics will vary based on the characteristics of the industry and company in question. However, a few core, agnostic metrics are routinely found in leading organizations. These include:

  • WAPE (Weighted Absolute Percent Error) – In my opinion, WAPE is the most balanced and telling measure of forecast error. Some professionals will advocate for MAPE. However, MAPE doesn’t effectively account for volume as the forecast error % for each period is treated equally.
  • BIAS – Bias is similar to forecast error. However, bias provides a measurement of whether your forecast tends to be above or below actual demand thus signaling a forecasting over/under “bias”.
  • Period-over-Period Error Trend – You’ll want to understand whether your demand planning process is improving or digressing. Measuring the forecast accuracy over time will also help to identify meaningful changes occurring in the business.

4. Leverage the Correct Data

Statistical forecasting and exception management will help to get a reasonably accurate forecast. However , to drive forecast error down to best-in-class levels, demand planners must leverage external information.

There is an abundance of information that demand planners could call upon to help them adjust their forecast. The real art of demand planning is knowing which of these data sources to use and when. Over time, your organization will get a sense for which information streams are most relevant and can begin to build a rules-based process around the use of external information.

Thanks, Josh! We look forward to Part II.