Once a mechanism has been selected for a program line, it is important that you configure the selected mechanism accurately by using certain settings that will become available to you in the Mechanism section on the left of your page (as shown in the screenshot below, using ‘Targeted % Rate with Monetary Targets’ as an example).
Dimensions
For almost every mechanism you select in Trading Programs, you will need to configure a selection for each of your dimensions on the program line you are creating. This setting is labelled Dimensions and requires you to first choose a dimension collection, then either a 'select all items' option or a 'manually select items' option.
Included dimensions determine which entities earn the rebate (for example, which products, product groups, or product categories earn the rebate specified in that program line).
Choosing 'select all' includes all current items and any future items added to that collection. For more complex program lines, choose 'manually select items' to directly select items, configure selection rules, and nominate items to exclude from the program line.
A program line can be saved as long as each dimension has either direct selections or a selection rule configured. The rule does not need to match any items at the time of saving; if matching items are added later, the rule picks them up automatically. A save is only blocked when a dimension has no selections and no rules at all.
Non-retrospective, retrospective and fully retrospective
Enable is able to retrospectively handle rebate calculations meaning that it is possible for new rates that have been achieved to be applied to past months transactions and to update the earnings for each month.
This is handled through multiple available retrospective settings: Non-retrospective, Retrospective and Fully retrospective.
Retrospective vs. Non-retrospective
If you have a program line with incremental percentage rates for specific target bands then you will be able to choose to make it retrospective or non-retrospective.
If retrospective, the percentage rate for the band of transactions reached will be applied to all historic transactions that apply to the program line. If not, the percentage rate is only applied to the transactions that fall within the qualifying band.
Consider for example a program line that has target bands as follows:
Transactions Target, USD |
Rate, % |
|---|---|
1,000,000 |
2 |
1,500,000 |
3 |
2,000,000 |
4 |
If the total for included transactions is $1,800,000:
Enable will calculate the earnings as: 3% x $1,800,000 = $54,000 if the Retrospective? checkbox is set.
2% x ($1,500,000 - $1,000,000) + 3% x ($1,800,000 - $1,500,000) = $19,000 if the Retrospective? checkbox is clear.
Fully Retrospective
Growth program lines, that are calculated as growth over a baseline value or volume, have an additional setting of Fully retrospective? (with the exception of the rebate earned being a fixed amount).
When Retrospective? is selected without Fully retrospective? being selected, the percentage rate will only be used to update historic transaction earnings on the growth element of the program line.
If both Retrospective? and Fully retrospective? are selected, then the percentage rate will be applied historically to update the earnings for all qualifying transactions.
Consider for example a program line that has growth target type of ‘% by value’ with target bands as follows:
Transactions Target, % |
Rate, % |
|---|---|
110 |
2 |
115 |
3 |
120 |
4 |
If for the above program line the total for included transactions is $2,350,000 and the baseline value is $2,000,000 (such that the % growth by value is 2,350,000 / 2,000,000, or 117.5%), the platform will calculate the earnings as:
3% x $2,350,000 = $70,500 if the Fully retrospective? checkbox is set.
3% x ($2,350,000 - $2,000,000) = $10,500 if the Fully retrospective? checkbox is clear but the Retrospective? checkbox is set.
2% x $2,000,000 x (115% - 110%) + 3% x $2,000,000 x (117.5% - 115%) = $3,500 if the Fully retrospective? and Retrospective? checkboxes are both clear.
Accruals
A user can set their accruals manually within each targeted program line in Trading Programs by navigating to the target band they wish to accrue at and selecting it. To set the accrual band you will need to click on the set accrual/forecast button.
If you have the Forecasting module enabled, it is possible to set the accruals automatically. There is a button next to the set accrual/forecast called Same as forecasted value. Once selected, the program line will use the forecasted figures as the accrual figures and automatically assign this as the accrual band in the program line. When the figures in the forecasting module are changed, the accrual band will automatically adjust to reflect this.
There is also a checkbox within the forecasting module config section, which will automatically use the forecasting figures for accruals within every program line by default.
Once you have set your accrual band and saved the program line, the accrual rate within your reports will display as:
Zero, if the program line has not yet reached the first target band and no accrual band has been selected for the program line.
The accrual rate, if an accrual band has been selected for the program line and both of the following apply:
The actual band is not higher than the accrual band
The current date is not later than the accrual reset period (see below)
The actual rate, if the actual band is higher than the accrual band.
The actual rate, if the current date is later than the accrual reset period for the program line.
Accrual reset period: The timeframe at which your accruals reset (and become actual earning) can be configured by the Enable Customer Success team. For example, this can be configured to reset at the end of a program line or several days, weeks or months after the program line has ended to offer flexibility for your claims/payment processes. Please get in touch if you would like our team to configure any changes.
For more information, read our FAQs article on the target band letters.
Baseline transactions (for Growth program lines)
A user might configure the baseline transactions in a ‘Growth’ program line as the value of the transactions from the previous period, found in the Baseline earnings area of Trading Programs.
Rebate will then be earned based on the transactional value that is achieved over that baseline (the ‘growth element’). This will then encourage growth by acting as a benchmark and incentivizing the improvement on last period’s targets.
Separate target and earning transactions?
The Separate target and earning transactions? checkbox allows you to indicate, on a per-program line basis, whether the program line has separate target and earning transactions.
Often, to encourage overall transactions with a trading partner, rebate rates may be earned for specific dimensions (e.g. products) when targets are achieved against other (or more) dimensions.
For example, a supplier may offer high rebate rates on a few specific high-volume products based on the buyers' overall sales of that trading partner's product range. Enable provides separate target and earning transactions to allow this type of program line to be represented in Trading Programs.
For this setting, which is presented to you as a Separate target and earning transactions? checkbox, the default is not selected. If, however, you select the checkbox for a given program line, the platform will:
Require you to select two sets of dimension items: one for the target transactions and one for the earning transactions.
Use the target dimension item selections to:
Assign matching transaction lines to the program line as target transactions;
Calculate the target transactions for the program line;
Determine which target band applies to the program line.
Use the earning dimension item selections to:
Assign matching transactions to the program line as earning transactions;
Calculate a program line earnings result for each transaction line that is assigned to the program line as earning transactions.
If you accept the default selection or clear the checkbox for the Separate target and earning transactions? option for a given program line, the platform will:
Only allow you to select a single set of dimension items.
Use the selected dimension items to assign matching transaction lines to the program line (as both target and earning transactions).
Use the matching transaction lines to:
Calculate the target transacted value for the program line;
Determine which target band applies to the program line;
Calculate a program line earnings result for each transaction line that is assigned to the program line.
For determining the target transactions, determining which target band applies to the program line, and deriving the earnings, Enable performs two separate calculations: 1 for actual transacted value and 1 for forecast transacted value.
For reporting transacted value for a program line where the Separate target and earning transactions? checkbox is set, Enable’s default approach is to use the earning as opposed to the target transacted value. This default approach is adopted for each of the following:
The Analysis page.
The Program earnings report.
The Daily earnings report.
Discount %
Often, as well as being awarded rebate for earning transactions targets, an initial discount of the list price of a product may be given. It is possible to record the Discount % in Trading Programs so that the rebate is calculated on the transaction net of the discount (the net price).
Deductions
You might find that you have earnings duplicated from the same transactions because two program lines may cover multiple dimensions (for example, one program line’s earnings are calculated from all branches in Warwickshire and another's earnings are calculated from just the Warwick branch — you can see here that there is an overlap where earnings would be duplicated).
It is possible to handle this case in Enable with the use of ‘strung rebates’ where the user can select one or more program lines whose earnings should be deducted from the qualifying transactions before the earnings are calculated for the current program lines.
Below is a simplified example of how this calculation would be carried out:
The user is creating a promotion program line which will give a rebate of 1%. However, there is already an incentive program line which gives rebate of 10%, both being calculated on the same transactions.
Let’s assume in this case that the relevant transaction amount is $100.
Without applying any deductions, Enable will calculate the total earnings for both program lines as $11, with the calculation being (1% of $100) + (10% of $100) = $11.
However, if the user includes the incentive program line in the Deductions area of the settings, the calculation of the rebate will change; the earnings of the incentive program line will be deducted before the promotion program line is calculated.
The earnings of the incentive program line are still 10% of $100 = $10. This is then deducted from the transactions before calculating the 1% for the promotion program line.
Therefore, the calculation of earnings for the promotion program line becomes 1% of ($100 - $10) = $0.90
Therefore, the total earnings for both becomes ($10 + $0.90) = $10.90, rather than $11.
It is clear from this example that configuring Deductions in program lines with a large number of transactions would significantly affect the calculation of earnings.
Manual overrides
Occasionally, adjustments to program lines are agreed outside of Enable. For example, you may be very close to achieving your next target band at the end of a program line and agree with your trading partner that the rate from the next target band will be used in calculating the earnings for the program line. Trading Programs allows Manual overrides to allow this type of agreement to be represented in Enable.
A manual override can be applied to a program line that is linked to any of the following mechanisms:
‘Value incentive $’.
‘Volume incentive $’.
‘Value incentive %’, for which the Retrospective? checkbox is set.
‘Volume incentive $ per unit’, for which the Retrospective? checkbox is set.
‘Volume incentive %’, for which the Retrospective? checkbox is set.
‘Value incentive $ per unit’, for which the Retrospective? checkbox is set.
‘Growth incentive $’.
‘Growth incentive %’, for which the Fully retrospective? checkbox is set.
‘Growth incentive $ per unit’, for which the Fully retrospective? checkbox is set.
Applying a manual override disables Enable’s calculation process for determining which target band applies to the program line.
You can remove the manual override and reinstate Enable’s calculation process to determine which target band applies at any time.
While a manual override is in place for a given program line, the corresponding calculation is disabled, and the corresponding metric is set to n/a, for each of the following:
Risk margin.
Risk amount.
Reward margin.
Reward amount.
Removing a manual override reinstates the corresponding calculations for risk margin, risk amount, reward margin, and reward amount, so these metrics are calculated in the normal way rather than set automatically to n/a.
Any program line to which a manual override has been applied is automatically assigned a ‘Manual override’ flag, which is then reported as part of the set of attributes that are logged for a program line by the version capture process.
‘Externally calculated’ mechanism
The ‘Externally calculated’ mechanism allows program lines for which the earnings cannot be calculated in Trading Programs to be represented.
For program lines that are linked to the ‘Externally calculated’ mechanism, you will be required to select included dimension items for the program line, as per any other program line. You will also be able to enter an earnings value for the program line.
The selected dimension items are then used, in conjunction with the start and end date of the program line, to compile a set of included transaction lines for the program line. Note that, for an inverse earnings program line:
Enable applies the change of sign to convert between positive and negative earnings as part of the calculation routine implemented by the assigned mechanism.
Where the assigned mechanism is ‘Externally calculated’, you should enter the earnings value ‘as is’ and rely on Enable to apply the change of sign.
For a program line linked to the ‘Externally calculated’ mechanism, the program line edit page displays the total earnings value, with a change of sign applied to this total if the inverse earnings checkbox is set.