Siebel Consumer Goods Guide > Trade Promotions >

Creating Plans (End User)


Key account managers can create plans and then create account promotions for their plans. These plans depict results of the promotions. For each plan, key account managers can also enter an ROI (return on investment) target. After a key account manager has run promotions in a plan, the key account manager can check to see whether the ROI target was met.

NOTE:  Key account managers can also create a plan by copying an existing plan and giving it a new name. This can save considerable time if the plans have similar attributes. When copying a plan, all active discretionary promotions within the plan, as well as their promoted products, are copied.

This task is a step in Process of Managing Trade Promotions.

To create a plan

  1. Navigate to the Plans screen > Plan List view.
  2. Create a new record, and complete the fields as described in the following table.
    Fields
    Comments

    Name

    Name of the plan.

    Status

    The status of the plan. It can have one of the following values:

    • New
    • Cancelled
    • Pending

    Revision

    Revision number of the plan.

    Account

    Select the account for which you are creating a plan.

    Period

    Time period for which the plan is active.

    Organization

    Organization where the plan is implemented.

To add a new promotion to a plan

  1. Navigate to the Plans screen.
  2. Drill down on the Name field hyperlink for a selected plan, and click the Promotions view tab.
  3. In the Promotions list, create a new record, and complete the necessary fields.

    Some fields are described in the following table.

    Field
    Description

    Actual Baseline Revenue

    Actual baseline revenue.

    Actual Baseline Volume

    Equal to the estimated baseline volume.

    Actual Incremental COGS

    (Actual Incremental Cases) multiplied by COGS.

    Actual Incremental Revenue

    (Actual Total Revenue minus Actual Baseline Revenue).

    Actual Incremental Volume

    (Actual Total Volume minus Actual Baseline Volume).

    Actual ROI

    (Actual Incremental Revenue minus Actual Incremental COGS) divided by Actual Total Spend.

    Actual Total Spend

    Actual total payments.

    Actual Total Revenue

    (Actual Incremental Revenue plus Actual Baseline Revenue).

    Actual Total Volume

    Sum of the shipments.

    Consumption End

    Date when consumer purchases under this promotion end. This date can be after the promotion end date.

    Consumption Start

    Date when the products are available for purchase by consumers. If consumption information for each promotion is obtained from external databases, the start and end dates can be used to restrict the list of consumption records. This date must be within the period of the promotion.

    Corporate Promotion

    Name of an existing promotion created by brand or sales management, or by the key account manager. This field is automatically completed if the account has a primary account promotion profile.

    Can also be a new name given to the promotion you create.

    Est Baseline Revenue

    Sum of Est Baseline Volume multiplied by (List Price minus Est Variable Spend Per Unit).

    Est Baseline Volume

    By default, the sum of all estimated baselines associated with the promoted products for the plan's promotions.

    Any baseline quantity can be associated with multiple accounts, periods, or products within the plan.

    Est Fixed Spend

    Estimated fixed payments.

    Est Fund Allocations

    Sum of all deals.

    Est Incremental COGS

    Sum of (COGS multiplied by Est Incremental Volume).

    Est Incremental Revenue

    Sum of Est Incremental Volume multiplied by (List Price minus Est Variable Spend Per Unit).

    Est Incremental Volume

    Total incremental volume rolled up from promoted products.

    Est ROI

    (Est Incremental Revenue minus Est Incremental COGS) divided by Est Total Spend.

    Est Total Spend

    (Est Variable Spend plus Est Fixed Spend).

    Est Total Volume

    (Estimated Baseline Volume plus Estimated Incremental Volume).

    Est Variable Spend

    (Est Total Volume multiplied by Est Variable Spend).

    Est Variable Spend Per Unit

    (Est Total Volume divided by Est Variable Spend).

    Lift

    This field interacts with the Est Baseline Volume field. When one field is updated, the other is updated automatically.

    Name

    Name of the promotion.

    Organization

    Name of the organization executing the promotion.

    Period

    Time period for which the plan is active.

    Phasing Enable

    Indicates if phasing is enabled for the promotion. You can use phasing if you want to allocate the aggregate cost, volume, and payment information throughout the weeks of a promotion period.

    Price List

    The price list associated with the promotion.

    Promotion End

    End date for the promotion.

    Promotion Start

    Start date for the promotion.

    Revision

    Revision number.

    Shipment End

    Date when the shipments for this promotion end. This date cannot be after the promotion end date.

    Shipment Start

    Date when the shipments for this promotion can begin. This date can be before the promotion start date.

    Status

    Status of the plan.

    Total Revenue

    (Baseline Revenue plus Incremental Revenue).

Siebel Consumer Goods Guide Copyright © 2006, Oracle. All rights reserved.