Demand Planning capabilities with SAP IBP for sales and operations

Objective

After completing this lesson, you will be able to use SAP IBP forecasting algorithms in the Manage Forecast Models application to generate accurate demand forecasts.

Demand Review Phase

SAP Integrated Business Planning (IBP) for Supply Chain is a dynamic, comprehensive solution that supports various aspects of interactive statistical forecasting and planning:

Types of Forecasting include Immediate Demand Forecasting, Mid-Term or Long Term Demand Forecasting, Quantity Forecasting, and Price and Revenue Forecasting.
  • Immediate demand forecasting (demand sensing): Predicts based on immediate consumer demands.

  • Mid-term or long-term demand forecasting: Aligns business plans strategically by predicting demands over an extended timeframe.

  • Quantity forecasting: Anticipates the exact quantity of products needed, eliminating surplus or shortage concerns.

  • Price and revenue forecasting: Predicts financial aspects, enabling effective financial planning.

The statistical forecasting capabilities of SAP IBP allow for creating forecasts for various scenarios or specific business segments. For example, it can automatically generate quantity forecasts based on shipment history or price and revenue forecasts to predict fluctuations in gasoline prices due to seasonal variations. These tools offer adaptability and predictive accuracy in a changing market environment.

Key Topics

As you progress through this lesson it's important to concentrate on several key topics that are crucial for mastering the content. These areas of focus are not just topics to be learned—they are your stepping stones to a deeper understanding and successful achievement of the course's learning objectives. By emphasizing these crucial areas, you will develop a robust knowledge base that will enhance your proficiency and effectiveness in supply chain management.

Demand Sensing: A method of immediate demand forecasting that predicts consumer demands in real time.

Simple Average: A forecasting algorithm that calculates the mean of all historical data within a specified time horizon.

Simple Moving Average: A forecasting algorithm that calculates the mean of subsets of historical data over a specific number of periods.

Single Exponential Smoothing: A forecasting algorithm that assigns exponentially decreasing weights to older data points, useful for data without trend or seasonality.

Double Exponential Smoothing: A forecasting algorithm that manages both trend and key figure values, useful for data with a trend.

Triple Exponential Smoothing: A forecasting algorithm that manages trend, seasonality, and key figure values, useful for data with both trend and seasonality.

Pre-Processing Steps: Initial steps in a forecast model that address issues in historical data before generating forecasts.

Post-Processing Steps: The final steps in a forecast model, focusing on actions after forecast generation, including error measurement.

Forecast Model Algorithms in SAP IBP for Sales and Operations

The core of statistical forecasting is the predictive capabilities of diverse forecast models. SAP IBP continually enhances its functionalities by introducing new models for increased utility and precision. The 'Manage Forecast Model' application is where these models are defined. Combining multiple robust algorithms elevates business prediction precision.

However, it's crucial to choose a specific perspective for your algorithms. Short-term and mid-term or long-term forecasting algorithms cannot coexist within a single model. This specificity ensures accurate and beneficial results.

Understanding the statistical forecasting algorithms included in the SOP license can significantly enhance demand planning effectiveness, allowing for predictive strategies with proficiency and confidence.

Note

You can only use SAP IBP application algorithms that your company has licensed.

Forecasting Algorithms

Examples of Forecast Model Algorithms included in SAP IBP for Sales and Operations

Forecasting algorithms are sophisticated mathematical methods that help project future product demand based on historical time series values. Here’s an overview of the algorithms used within the Sales and Operations Planning (S&OP) solution:

  • Simple average:

    Computes the mean of all historical values within a specific time horizon, using it as a future prediction. The forecast is a uniform value based on weekly or monthly history.

  • Simple moving average:

    Calculates the mean of time series values in successive subsets of time periods. The number of periods in these subsets is the key parameter.

  • Single exponential smoothing:

    Models a time series without trend or seasonality, assigning less importance to older data through exponentially diminishing weights (alpha coefficient between 0 and 1).

  • Double exponential smoothing:

    Models time series with trend or seasonality, managing trend and key figure values using alpha and beta coefficients (both between 0 and 1).

  • Triple exponential smoothing:

    Manages time series with trend and seasonality, minimizing their influence on projections using alpha, beta, and gamma coefficients (all between 0 and 1).

  • Copy past periods

    Useful for recurring patterns, this algorithm suits scenarios where monthly sales data mirrors previous years' trends.

Using Multiple Algorithms.

When incorporating multiple forecasting algorithms into a model, the system's engagement with each algorithm can be controlled:

  • Choose best forecast:

    The system uses a specified error measure to identify and apply the most accurate forecast algorithm.

  • Calculate weighted average forecast:

    Weights are assigned to forecasting algorithms, and an average forecast is computed by multiplying each result by its corresponding weight.

Note

For more information, see http://help.sap.com/.

Manage Forecast Models

The Manage Forecast Models application allows for creating and modifying models that underpin forecasting processes within SAP IBP. Users can outline pre-processing, forecasting, and post-processing steps within distinct tabs for straightforward navigation.

  • General settings

    Establish parameters applicable to the entire model.

  • Pre-Processing Steps:

    Select algorithms to mitigate issues in the time series data before generating forecasts.

  • Post-Processing Steps:

    Select settings for actions performed by the system after forecasting, including error measure computations.

Video Summary

When defining a statistical forecasting model, the user has flexibility in three key areas: pre-processing, which involves data preparation; forecast steps, which include running the forecast; and post-processing, which involves tasks such as saving error measures. These sections are organized as tabs in the statistical models configuration screen, allowing for a clear and structured setup process.

You can choose settings that are valid for the entire model regardless of the algorithms selected by selecting General.

By selecting Pre-Processing Steps, you can select algorithms that are used to solve possible issues in the time series data before the forecast is calculated. The following types of issues can occur:

  • Some key figure values may be missing from the input data.

  • The input data may contain unusual values (outliers).

By selecting Forecasting Steps, you can choose the settings that define how the system calculates the forecasts for the selected key figures. Forecasts are calculated both for the past and future with the help of the selected algorithms.

By selecting Post-Processing Steps, you can choose the settings for the steps that are performed by the system after forecasting. You can select methods for calculating error measures.

Forecasting with SAP IBP for sales and operations

Statistical forecasting operates on forecast models built on a planning area, determining algorithms for predictions. Mid-term and long-term forecasting can be implemented at both base planning and aggregated levels of the key figure. Short-term forecasting, however, is limited to product, location, and customer levels.

Prerequisites for Statistical Forecasting Run

The image shows a dropdown menu from a software application under the Simulate button. The options listed include: Simulate (Basic) Inventory Planning (Advanced) Inventory Planning Profile S&OP Operator Time-Series-Based Forecast Consumption Time-Series-Based Supply Planning Compute Quotas Time-Series-Based Supply Planning Heuristic Time-Series-Based Supply Planning Optimizer Time-Series-Based Supply Planning Optimizer - Fair Share Statistical Forecasting Forecast with assigned models AdvForecasting_GradientBoosting This menu is part of a software interface for managing and simulating various supply chain planning processes, including advanced forecasting techniques like Gradient Boosting.

You can run mid-term and long-term statistical forecasting at the base planning level, and at the aggregated level of the key figure. Short-term forecasting runs at product, location, and customer level only. You can execute a forecast only at the time period level that is specified in the forecast model.

Prerequisites for the Statistical Forecasting Run

The following are prerequisites for the statistical forecasting run:

  • A forecast model has been defined.

  • You have the required authorizations to run statistical forecasting.

    If you don't have the required authorizations, the Statistical Forecasting button does not appear on the SAP IBP tab in Microsoft Excel.

Executing Forecast in SAP Integrated Business Planning

Forecast execution can be essential as an ad hoc event or part of a regular schedule. Planners can execute forecasts interactively or schedule them to run in the background. Execution is possible through the SAP IBP Web UI or Excel UI, allowing planners to access results readily.

The image shows a dropdown menu from a software application under the Simulate button. The options listed include: Inventory Planning (Advanced) Inventory Planning Profile S&OP Operator Time-Series-Based Forecast Consumption Time-Series-Based Supply Planning Compute Quotas Time-Series-Based Supply Planning Heuristic Time-Series-Based Supply Planning Optimizer Time-Series-Based Supply Planning Optimizer - Fair Share Statistical Forecasting Forecast with assigned models This menu is part of a software interface for managing and simulating supply chain planning processes.

Video Summary

The SAP IBP, add-in for Microsoft Excel allows you to review and modify your planning data and run simulations.

Running a forecast can be necessary as on an on-demand occasion as well as part of a regular schedule. Planner might want to run the forecast in the background interactively and have the results ready as soon as possible.

Executing forecast run is possible both from the SAP IBP Web UI (by first defining the Template and then creating an Application Job that executes the template), and from Excel UI.

A planner may want to schedule the forecast to run in the background. This could be a weekly process after the business units have updated their sales history. This would allow the planners to have the results ready when they start work.

From Statistical Forecast to Consensus Demand

Technical flow for demand planning in SAP IBP includes Statistical Forecast Quantity, Local Demand Planning Quantity, Demand Planning Quantity, Global Demand Plan Quantity for SOP, and Consensus Demand Plan Quantity.

Technical Flow – Demand Planning

The following outlines the key figures progression in the Sample Planning Model (SAPIBP1) and their respective descriptions:

  • Statistical Forecast Quantity (STATISTICALFORECASTQTY)

    This is the output from statistical forecasting. It can be selected as the target key figure for forecast models defined in the Manage Forecast Models app.

  • Local Demand Planning Quantity (LOCALDEMANDPLNQTY)

    This output is used by the local demand planner to override the Statistical Forecast Quantity.

  • Demand Planning Quantity (DEMANDPLANNINGQTY)

    This output is used by the global demand planner to override the Local Demand Planning Quantity.

  • Global Demand Plan Quantity for SOP (SOPDEMANDPLANNINGQTY)

    This is the result of the interactive planning process in the demand review phase of the Sales and Operations Planning (S&OP) process. The Copy Operator function is used to set this value based on the Demand Planning Quantity.

  • Consensus Demand Plan Quantity (CONSENSUSDEMANDPLANQTY)

    This defaults to the Global Demand Plan Quantity for SOP and represents the agreed-upon demand plan after the demand review phase of the S&OP process.

These key figures and their interactions help streamline and accurately manage the demand planning process within SAP IBP.

Once a statistical forecast is deployed using forecast models, it can be finalized to represent the consensus debated during the sales and operations process's Demand Review stage.

Sample planning area SAPIBP1 contains several key figures and copy operators that model the technical progression of demand key figures.

The flexible model allows for manual forecasting entries if users have specific knowledge of events and patterns influencing demand. Without manual entries, calculations revert to existing data. Key figures like Sales Forecast Quantity and Sales Manager Forecast Quantity offer additional input possibilities for demand generation. The SAP IBP implementation team can tailor the configuration based on business requirements, complexity, and S&OP process maturity.

  • Demand Sensing: A method of immediate demand forecasting that predicts consumer demands in real time.

  • Simple Average: A forecasting algorithm that calculates the mean of all historical data within a specified time horizon.

  • Simple Moving Average: A forecasting algorithm that calculates the mean of subsets of historical data over a specific number of periods.

  • Single Exponential Smoothing: A forecasting algorithm that assigns exponentially decreasing weights to older data points, useful for data without trend or seasonality.

  • Double Exponential Smoothing: A forecasting algorithm that manages both trend and key figure values, useful for data with a trend.

  • Triple Exponential Smoothing: A forecasting algorithm that manages trend, seasonality, and key figure values, useful for data with both trend and seasonality.

  • Pre-Processing Steps: Initial steps in a forecast model that address issues in historical data before generating forecasts.

  • Post-Processing Steps: The final steps in a forecast model, focusing on actions after forecast generation, including error measurement.

Personal Reflection

Reflect on a time when your organization faced challenges in predicting demand for a product or service. How did these challenges impact your operations, and what steps did your team take to address them? How could the forecasting methods and tools described in SAP IBP have helped improve your demand planning process?

Pause here for a moment and take some time to jot down your thoughts on the personal reflection question. Once you've recorded your response, you'll have the opportunity to compare it with an answer from an expert in SAP Supply Chain. This exercise will give you insight into your understanding and how it aligns with professional perspectives.

Expert Response

Reflecting on past challenges in predicting demand, a retail company struggled with stockouts during peak seasons and excess inventory during off-seasons. This led to lost sales, increased costs, and inefficient warehouse use. To address these issues, the team used basic statistical models, periodic forecast reviews, and improved communication between departments. However, these efforts had limitations.

SAP IBP could greatly improve this situation. Immediate demand forecasting (demand sensing) would provide accurate short-term forecasts, reducing stockouts. Mid-term and long-term forecasting would align strategic plans with market trends, better preparing for seasonal fluctuations. Advanced quantity forecasting tools would precisely predict product needs, minimizing surplus and shortages.

Using sophisticated algorithms like triple exponential smoothing would enhance accuracy by considering trends and seasonality. The Manage Forecast Models application would allow for flexible and precise forecasts tailored to business needs. Integrating stakeholder inputs to create a consensus demand forecast would align all departments, improving overall demand planning.

In summary, SAP IBP's advanced forecasting methods and tools would enhance forecast accuracy, reduce inefficiencies, and better meet customer demand, leading to improved business performance.

Lesson Wrap-Up

In this lesson, we explored the key elements of demand forecasting using SAP Integrated Business Planning (IBP) for Supply Chain. We discussed different types of forecasting, including demand sensing, which focuses on immediate consumer data, and mid-term and long-term forecasting that aligns business plans with market trends over extended periods. We also covered quantity, price, and revenue forecasting to predict precise product needs and financial aspects for better planning.

The lesson introduced various forecasting algorithms, such as simple average and simple moving average for basic forecasts, and exponential smoothing methods (single, double, and triple) to manage trends and seasonality in data. We also looked at the "Copy Past Periods" method for replicating historical patterns.

We delved into managing forecast models using the "Manage Forecast Models" application, which allows defining and combining algorithms for accurate predictions. This includes pre-processing, forecasting, and post-processing steps to handle data and forecasts effectively. We also learned about executing forecasts through the SAP IBP Web UI or Excel UI, either interactively or on a schedule, and integrating stakeholder inputs for consensus demand planning.

Overall, by leveraging SAP IBP's advanced tools and methods, organizations can significantly improve demand planning accuracy, reduce inefficiencies, and better meet customer needs, ultimately enhancing overall business performance.

Log in to track your progress & complete quizzes