Using Phase-In and Phase-Out Profiles

Objective

After completing this lesson, you will be able to use phase-in and phase-out profiles.

Product Lifecycle App

The figure shows how to start the Manage Product Lifecycle App in SAP Fiori.

Phase-In and Phase-Out Profiles

Manufacturers introduce new products into their product portfolio regularly. Demand planning aims at making high-quality automated forecasts for the future demand of a product. This is done by sophisticated statistical algorithms that calculate a future time series based on the knowledge of historic sales values. However, for new products, historic values do not exist.

You therefore search for products that have a similar historical sales pattern and assign them as reference products to the new product. These reference products are then taken into account dynamically in the forecast engine at the time of the forecast run for the new product.

When you introduce a new product or phase out an existing product, you expect the demand to be noticeably different to that in the "mature" phase of the product’s life. Phase-in/out modeling lets you take this behavior into account.

To define reference products for a new product in SAP IBP for demand, your planning area must fulfill the following prerequisites:

  • You have defined which attribute of the planning area represents the product ID.

  • You have created the respective planning objects for your new products using key figure upload or the copy operator, or you have created the planning objects in Microsoft Excel.

  • Recommended: You have defined which attribute of the planning area represents the product description and the product group. If you do not do this, the Manage Product Lifecycle app cannot handle descriptions or product groups for the products and the system uses the product ID instead.

  • Recommended: You have set the business meaning Actual Sales for one key figure of the planning area.

The figure shows how to Preconfigure Phase-In and Phase-Out Curves – Linear Curve
The figure shows how to Preconfigure Phase-In and Phase-Out Curves – Superlinear and Sublinear Curves

You can plan the phase-in and phase-out process for a new product by specifying the start and end dates for the phase-in and phase-out and optionally assigning a curve.

The phase-in start date defines the point in time when a product is sold in the market. Forecasting is not generating results for periods with an end date that is before the phase-in start date.

The phase-out start date is the point in time when the product is gradually sold less than in the maturity phase. The phase-out end date is the point in time when the product is no longer sold in the market. The forecast engine does not generate results after this point of time.

The curves show the expected demand development of the product during phase-in and phase-out. Phase-in and phase-out curves represent percentage time series. The percentages are multiplied by the forecast result in the phase-in time horizon that is defined by the phase-in start and end dates.

Predefined Curves

The following curve types are available:

  • Linear:

    The linear curve is calculated by a linear interpolation between 0.1 and 0.9.

  • Sublinear:

    The sublinear curve applies the quadratic function to the time series that we obtain when you do a linear interpolation between 0.316 and 0.949. The boundaries are calculated by applying the reverse function of the quadratic function to the standard boundaries 0.1 and 0.9.

  • Superlinear:

    The superlinear curve applies the square root function to the time series that we obtain when we do a linear interpolation between 0.01 and 0.81. The boundaries are calculated by applying the reverse function of square root to the standard boundaries 0.1 and 0.9.

Custom Curves

You can configure your own phase-in and phase-out curves. To do so, select an existing curve type and adapt the curve parameters to your needs. You can define the following parameters:

  • The number of time periods you want to display

  • The function used to calculate the curve is, for example, square root or quadratic

  • The start and end values of the curve in percent

After changing the parameters, you can simulate the resulting curve and, if you are happy with the result, save it for future use and assign it directly to the relevant launch dimension value. You can use the value label switch to display or hide the values for each point of the curve.

The figure describes how the Launch Dimension can be specified.
The figure describes how the Forecast Start Dates can be specified.
The figure describes how the Phase-In Start Dates, End Dates, and Curves can be specified.
The figure describes how the Phase-In Start Dates, End Dates, and Curves can be specified.

The phase-in start date defines the date from which the new product is sold on the market. The system does not generate any forecasts for time periods that lie before this date. The phase-in end date defines the point in time when the product has reached maturity. Once the phase-in end is reached in the historical horizon of the forecast, forecasting is based on the product's own sales history.

The phase-out start date defines the date from which the product will be gradually withdrawn from the market. The phase-out end marks the date at which the product is no longer being sold. The system does not make any forecasts after this date.

Note

Demand sensing does not consider phase-out dates.

You can generate the phase-out for a reference product based on the phase-in of a new product. The generated phase-out period of the reference product is identical to the phase-in period of the reference product. The generated phase-out curve mirrors the selected phase-in curve: The phase-out curve starts at the end value of the phase-in curve and ends at the start value of this curve. The generated curve name contains the date that the curve was created, for example, Generated 20180205 Superlinear Curve. If there is already a curve with matching parameters, the system uses this curve instead of generating a new one.

Usage Variants of Phase-in/Phase-out Function in SAP IBP

There are six different variants of usage for the phase-in/phase-out function in SAP IBP:

  • Phase-in without curve:

    Weight of reference products can be set to use a % of actual delivery of reference products in the future. Phase-in start and end dates should be similar. In this case, 100% of the forecast for a new product is available starting from the selected date.

  • Phase-in with curve:

    Weight of reference products can be set to use a % of actual delivery of reference products in the future. Phase-in start and end dates should be different. In this case, the forecast for new product is available starting from the selected date and increases in accordance with the selected curve.

  • Phase-out without curve:

    In this usage, you do not need to add additional reference products because it is a phase-out. Set the weight of the product = 100%. Phase-out start and end dates should be similar. In this case, 0% of the forecast for an old product is available starting from the selected date.

  • Phase-out with curve:

  • In this usage, you do not need to add additional reference products because it is a phase-out. Set the weight of the product = 100%. Phase-out start and end dates should be similar. In this case, the forecast for an old product becomes unavailable starting from the selected end date and decreases in accordance with the selected curve.
  • Replace without curve:

    The weight of reference products can be set to use a % of the actual delivery of reference products in the future. Phase-in start and end dates should be similar. In this case, 100% of the forecast for a new product is available starting from the selected date. Choose the necessary curve with only one period inside.

    At the same time, generate the phase-out profile for reference products. The start and end dates should be aligned with the phase-in dates of the new product.

  • Replace with curve:

    The weight of reference products can be set to use a % of the actual delivery of reference products in the future. Phase-in start and end dates should be similar. In this case, 100% of the forecast for a new product is available starting from the selected date. Choose the necessary curve with more than one period inside.

    At the same time, generate the phase-out profile for reference products. The start and end dates should be aligned with the phase-in dates of the new product in accordance with the selected curve.

    Note

    If you execute a statistical forecast at the Product level and, at the same time, a phase-in/out profile is generated at the Product-Customer level, the phase-in/out dates would not be used in the forecast, because they have different planning levels.
The figure shows the Manage Product Lifecycle App - Detail Screen.

Historical data for a new product can be simulated in the Manage Product Lifecycle app to check all related information for the selected reference products, curves, periods, and dates. It can be helpful to generate your own curve with different reference products for different new products and take seasonality, trends, and so on, into account.

Forecast a New Product and Use Phase-In and Phase-Out Dates

The Demand Planner wants to start forecasting for new products as well as stop forecasting for older products.

Steps

  1. Create a Lifecycle Profile to forecast your new product. Use the new Product ID NEW_## and use the reference product HT_###. The launch dimension of the new product is Customer ID

    1. Log in to the SAP Fiori Web UI.

    2. In the Demand Planner group, choose the Manage Product Lifecycle tile.

    3. Choose planning area ZSAP6, Choose Add → Product Replacement.

    4. Choose the new product ID NEW_## and choose an old product ID HT_### then choose the next step. Observe the warning message pop up for filter adjustments. Choose OK and continue.

    5. Confirm that the proposed reference product ID matches the old product ID from the last step and choose the next step.

    6. Ensure that your reference product ID is correct and choose the next step.

    7. Choose Add to add the launch dimension as Customer ID and dimension values as NA100 and choose the next step.

    8. You will get the information as Add phase-in start and end dates for all entries. Select the customer id and choose Edit. You can see the forecast start as the current date and enter the phase-in start date as the first day of next month and a phase-in end date of the last day of the month that is four months from the start date. Choose the phase-in curve as Superlinear.

    9. Choose OK.

    10. Phase-in start and phase-in end date details of the new product are displayed. Choose Next step.

    11. Phase-out start and phase-out end details of the old product or reference product HT_### are generated based on phase-in start and phase-in end dates of NEW_##. Choose Save.

    12. Use the SAP IBP Back arrow to return to the main screen. Choose the forecast dates tab and see all the details of new and old products.

  2. Create the planning objects needed to plan your NEW_## product.

    1. In the main screen of Manage Product lifecycles, ensure that you are on the Product Assignment tab, select NEW_##, choose Planning Object Actions and select Create Planning Objects for selected Assignments.

    2. Select key figure Statistical Forecast Qty and Actuals Qty, choose OK and then choose Simulate. Display Rows with Copied from Reference to ensure that the relevant planning objects are being created.

    3. Choose Create All and a pop up message will appear for an asynchronous job started for the creation of planning objects. Check the details in the application log. Close the pop up and continue to the next task.

  3. Ensure that the forecast model SimpleMovingAvg## created in a previous exercise considers the product lifecycle information. Make sure to use manual forecasting and 60 Forecast Periods.

    1. Log in to the SAP Fiori launchpad and in the Demand Planner group, choose the Manage forecast model tile.

    2. Choose your SimpleMovingAvg## forecast profile and choose Edit Model.

    3. On the General tab, select the Consider Product Lifecycle Information checkbox

    4. Select the Manual Forecasting checkbox (we will be using that in the next exercise).

    5. Change the number of Forecast Periods to 60.

    6. Save your profile.

  4. In your Demand Planning favorite, update your Prod ## filter to include your NEW_### Product ID. Make sure to log off and log back into Microsoft Excel to see the new product created.

    1. In the add-in for Microsoft Excel, choose Favorites → Demand Planning.

    2. In the Planning View section, choose your filter Prod ## → Edit.

    3. Add your NEW_## Product ID and select -> (upward arrow) "Update".

    4. Choose OK to display your planning view and stay in the planning view for the next step.

  5. Use the SimpleMovingAvg## Forecast Profile that you updated earlier to execute a forecast for your Prod ## selection at the Product ID and Customer ID level.

    1. In the add-in for Microsoft Excel, in the Application Jobs section, choose Statistical Forecasting → Run.

    2. A message will pop up informing you that the settings of the view will be copied over to the job prompt. Choose OK.

    3. Ensure that the Product ID and Customer ID attributes are selected.

    4. Choose Weekly as the Time Period.

    5. Select your SimpleMovingAvg## forecast profile.

    6. Choose UOM To ID KG and Baseline.

    7. Select the Filter tab and choose your Prod ## filter.

    8. Choose Next and Run (the Reason Code and Comment are optional).

    9. A message will pop up informing you of the status of the job with navigation to the status. Choose Navigate to Status to see the status of the job or choose OK to close the pop up.

    10. When the status of the job shows Finished, go to the next exercise step.

  6. Refresh your planning view to see the results of the forecasting run.

    1. In the Data Input section, choose the Refresh icon.

    2. Observe that your NEW_## product now appears and has values in the Statistical Forecast Qty key figure in the future weeks, but no historical data.

  7. Check the values of MAPE and MASE in the Business Log.

    1. In the add-in for Microsoft Excel, in the Application Job section, choose Status → Statistical Forecasting.

    2. Locate your planning run and choose Show Business Log.

    3. You do not need to filter the list, just choose OK.

    4. What was the MAPE value for your NEW_## Product for each Product, Customer combination?

    5. What was the MASE value for NEW_## Product for each Product, Customer combination?