Incorporating Market Input

Objective

After completing this lesson, you will be able to incorporate market input into a forecast.

Market Input

The figure describes Quantity Key Figures for Mid- to Long-Term Demand Planning.

For manual adjustments, you need to be aware of the properties of the Key Figures (being editable, allowing manual entry).

Key Figure properties can be displayed in SAP IBP, add-in for Microsoft Excel, using the Edit View → Edit Planning View option. Tool-tips are available to show Key Figure properties by mousing over the Key Figure in the Key Figure tab.

Incorporate Market Input into the Forecast

ExerciseStart Exercise

We cannot only rely on the statistical forecast when something happens in the future that did not happen in the past. This can be special events, promotions, or other market changes. For these, we need to adjust the forecast.

Steps

  1. Log in to the add-in for Microsoft Excel, choose your Demand Planning favorite, and ensure that you have the following Key Figures available: Sales Forecast Qty, Demand Planning Qty, and Consensus Demand without Promotions.

    1. Log in to the add-in for Microsoft Excel with the login credentials provided by the instructor.

    2. Choose your favorite Demand Planning.

    3. Choose Edit View, go to the filter section and add attribute filters for Location ID = HD_DC_CA and Customer ID = NA100. Select OK to check the results in the planning view. Make sure to add the Location ID to the planning view.

    4. Notice that the Key Figures Sales Forecast Qty, Demand Planning Qty, and Consensus Demand without Promotions are the same as the Statistical Forecast Qty, unless a manual override has been entered.

  2. Change the value in the Sales Forecast Qty key figure to 2000 PC four weeks from now for Product ID HT_0##, Location ID HD_DC_CA, and Customer ID NA100, and simulate the result.

    1. Locate the Sales Forecast Qty key figure for Product ID HT_0##, Location ID HD_DC_CA, and Customer ID NA100.

    2. Change the value in that row to 2000 PC four weeks from the current week.

    3. In the Data input section, choose the Simulate→Simulate (basic) option to simulate the result.

    4. Notice that the Demand Planning Qty key figure has changed and is now equal to the Sales Forecast Qty.

    5. Notice that the Consensus Demand without Promotions key figure will also be adjusted

  3. Change the value in the Consensus Demand without Promotions key figure to 3000 PC four weeks from now for Product ID HT_0##, Location ID HD_DC_CA, and Customer ID NA100, and simulate the result.

    1. Locate the Consensus Demand without Promotions key figure for Product ID HT_0##, Location ID HD_DC_CA, and Customer ID NA100.

    2. Change the value in that row to 3000 PC four weeks from the current week.

    3. In the Data input section, choose Simulate→Simulate (basic) to simulate the result.

    4. Observe that the value remains 3000 PC for Product ID HT_0##, Location ID HD_DC_CA, and Customer ID NA100.

  4. Using the SAP Fiori UI, observe how the calculations for these Key Figures are configured. Use the search field just above the center of the table to find each key figure and then click on the Key Figure ID to display the calculation.

    1. Log in to the SAP Fiori UI with the login credentials provided by the instructor.

    2. In the Model Configuration group, choose the Planning Areas Model Configuration tile.

    3. Choose the ZSAP6 planning area, and open the Key Figures section to review the calculation of the three Key Figures.

      What is the calculation of SALESFCSTQTY@LOCPRODCUSTWEEKLY?

      What is the calculation of DEMANDPLANNINGQTY@LOCPRODCUSTWEEKLY?

      What is the calculation of CONSENSUSDEMAND@LOCPRODCUSTWEEKLY?

Learning

SAP FacebookSAP YoutubeSAP LinkedIn