Show TOC

Function documentationTrade Promotion Monitoring Locate this document in the navigation structure

 

You can monitor trade promotions and view their statuses from red, yellow, or green traffic lights. For this, there are alerts that are predefined in Business Planning and Simulation (BPS). You can also modify existing alerts or define your own ones.

Note Note

For more information, see KPI Valuation for an Alert in the SAP Strategic Enterprise Management (SAP SEM) component of SAP ERP Central Component.

End of the note.

Features

You can use the following four predefined alerts that are contained in the CP: Sales Planning with Promotions planning profile (4TPM9000) in BPS:

  • Incremental Costs (4TPM9596)

    This alert shows the ratio of promotion budget to uplift quantity. This ratio gives you an idea of how high the costs for the expected uplift can be.

    Calculation: Budget (0BUDGET) / Uplift Quantity (0UPLI_QTY)

    The higher the value of this ratio, the better. The following traffic lights are displayed:

    • Red traffic light, if incremental costs are lower than 0.5

    • Yellow traffic light, if incremental costs are higher than 0.5 and lower than 2

    • Green traffic light, if incremental costs are higher than 2

  • Incremental margin (4TPM9598)

    This alert shows the ratio of net revenue to billed quantity. This ratio gives you an idea of how the margin can develop as a result of the planned trade promotion.

    Calculation: Net Revenue (0COPANETRV) / Billed Quantity (0BILL_QTY)

    The higher the value of this ratio, the better. The following traffic lights are displayed:

    • Red traffic light, if incremental margin is lower than 1

    • Yellow traffic light, if incremental margin is higher than 1 and lower than 10

    • Green traffic light, if incremental margin is higher than 10

  • Return on Investment (4TPM9594)

    This alert shows the return on investment (ROI) that a trade promotion can generate.

    Calculation: (Uplift Quantity (0UPLI_QTY) / Billing Quantity (0BILL_QTY)) x (Net Revenue (0COPANETRV) / Budget (0BUDGET))

    The higher the value of this ratio, the better. The following traffic lights are displayed:

    • Red traffic light, if ROI is lower than 1

    • Yellow traffic light, if ROI is higher than 1 and lower than 5

    • Green traffic light, if ROI is higher than 5

  • Uplift Ratio (4TPM9592)

    This alert shows the ratio of uplift quantity to base quantity. This ratio gives you an idea of the effect the planned trade promotion can have on sales.

    Calculation: Uplift Ratio = Uplift Quantity (0UPLI_QTY) / (Billing Quantity (0BILL_QTY) – Uplift Quantity (0UPLI_QTY))

    The higher the value of this ratio, the better. The following traffic lights are displayed:

    • Red traffic light, if uplift ratio is lower than 0.01

    • Yellow traffic light, if uplift ratio is higher than 0.01 and lower than 0.10

    • Green traffic light, if uplift ratio is higher than 0.10

Activities

You assign these predefined alerts in Customizing for Customer Relationship Management under   Trade Promotion Management   Key Figure Planning   Define Planning Profile Groups   Assignment of Traffic Lights  .