Previous  Next          Contents  Index  Navigation    Library

Revenue Non Quota Compensation Examples

The compensation examples employ the following syntax:

<Payment Type>:<Apply Txn>:<Accumulate On/Off>:<Split On/Off>

The methods to use Revenue Non Quota compensation to calculate transactions are:

The Sales Activity table lists the transaction amount, the product sold, and the performance that is being used to calculate the commission for each of these methods. Revenue classes A and B are tied to these plan elements.

Sales Activity
Transaction Amount Product Performance $ (Achievement)
$500 A $500
$500 B $1,000

The RNQ Percentage Rate Table is used to calculate the commission rate for the following payment types:

RNQ Percentage Rate Table
Tier Commission
Percent Percent
From $ To $ %
0 500 5
500 1000 10
1000 9999 15

The RNQ Amount Rate Table is used to calculate the commission amount for the fixed amount payment type.

RNQ Amount Rate Table
Tier Commission
Percent  
From $ To $ Amount
0 500 5.00
500 1000 10.00
1000 9999 15.00

Applied Transaction Amount Percentage : Individually : Accumulate On : Split Off

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission rate depends on revenue achievement and the sales agents receive a percentage of revenue that they earn.

Revenue Non Quota Plan Element Example 1
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Split Off
Accumulate On
Apply Txn Individually
Payment Type Applied Transaction Amount Percentage
Rate Table RNQ Percentage
Discount Option None

This plan element calculates compensation for each transaction. The revenue achievement continues to accumulate throughout the interval. The revenue achievement starts over at the beginning of each quarter. For each transaction, Oracle Sales Compensation adds up the achievement rate, finds the appropriate tier in the RNQ Percentage Rate Table associated with this level of revenue achievement to determine the commission rate, and multiplies this rate by the transaction amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the revenue performance percentage is located in the RNQ Percentage Rate Table.
Commission Commission rate x transaction amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $50 + $75 = $125.

Fixed Amount : Individually : Accumulate On : Split Off

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission rate depends on the fixed amount defined by the level of achievement.

Revenue Non Quota Plan Element Example 2
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Split Off
Accumulate On
Apply Txn Individually
Payment Type Fixed Amount
Rate Table RNQ Amount
Discount Option None

This plan element calculates compensation for each transaction. Revenue achievement continues to accumulate throughout this interval. Revenue achievement starts over at the beginning of each quarter. For each transaction, Oracle Sales Compensation accumulates the transaction on revenue, finds the appropriate tier in the RNQ Amount Rate Table associated with this level of achievement to derive the corresponding commission amount.

Calculation Formula
Commission rate Determined by the tier in which the revenue is located in the RNQ Amount Rate Table.
Commission Commission amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $10 + $15 = $25.

Payment Amount Percentage : Individually : Accumulate On : Split Off

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission rate depends on the percentage of the payment.

Revenue Non Quota Plan Element Example 3
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Split Off
Accumulate On
Apply Txn Individually
Payment Type Payment Amount Percentage
Payment $750.00
Rate Table RNQ Percentage
Discount Option None

This plan element calculates compensation for each transaction. The revenue achievement continues to accumulate throughout the interval. The revenue achievement starts over at the beginning of each interval. For each transaction, Oracle Sales Compensation adds up the achievement rate, finds the appropriate tier in the RNQ Percentage Rate Table associated with this level of revenue achievement to determine the commission rate, and multiplies this rate by the payment amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the revenue is located in the RNQ Percentage Rate Table.
Commission Commission rate x payment.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $75 + $112.50 = $187.50.

Applied Transaction Amount Percentage : Individually : Accumulate On : Split On

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission rate depends on revenue achievement and the sales agents receive a percentage of revenue that they earn.

Revenue Non Quota Plan Element Example 4
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Split On
Accumulate On
Apply Txn Individually
Payment Type Applied Transaction Amount Percentage
Rate Table RNQ Percentage
Discount Option None

This plan element calculates compensation for each transaction. The revenue achievement continues to accumulate throughout the interval. The revenue achievement starts over at the beginning of each quarter. For each transaction, Oracle Sales Compensation adds up the achievement rate, finds the appropriate tier in the RNQ Percentage Rate Table associated with this level of revenue achievement to determine the commission rate, and multiplies this rate by the transaction amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the revenue performance percentage is located in the RNQ Percentage Rate Table.
Commission Commission rate x transaction amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the lower rate to calculate the commission rate for plan elements where the Split check box is checked.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the lower rate to calculate the commission rate for plan elements where the Split check box is checked.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $25 + $50 = $75.

Applied Transaction Amount Percentage : Individually : Accumulate Off

This type of plan element is typically used to compensate sales representatives for large sales for each company.

Revenue Non Quota Plan Element Example 5
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Split Off
Accumulate Off
Apply Txn Individually
Payment Type Applied Transaction Amount Percentage
Rate Table RNQ Percentage
Discount Option None

This plan element calculates the compensation for each transaction. The revenue achievement is not accumulated throughout the interval. The transaction amount on the transaction is treated separately from any other transaction. For each transaction, Oracle Sales Compensation finds the appropriate tier in the RNQ Percentage Rate Table associated with this level of revenue achievement to determine the commission rate, and multiplies this rate by the transaction amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the revenue is located in the RNQ Percentage Rate Table.
Commission Commission rate x transaction amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $50 + $50 = $100.

Fixed Amount : Individually : Accumulate Off

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission amount depends on the fixed amount defined by the achievement.

Revenue Non Quota Plan Element Example 6
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Accumulate Off
Apply Txn Individually
Payment Type Fixed Amount
Rate Table RNQ Amount
Discount Option None

This plan element calculates the compensation for each transaction. The revenue achievement is not accumulated throughout the interval. The transaction amount on the transaction is treated separately from any other transaction. For each transaction, Oracle Sales Compensation finds the appropriate tier in the RNQ Amount Rate Table associated with this level of achievement, and pays the corresponding commission amount defined for that tier.

Calculation Formula
Commission rate Determined by the tier in which the revenue is located in the RNQ Amount Rate Table.
Commission Commission amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $10 + $10 = $20.

Payment Amount Percentage : Individually : Accumulate Off

This type of plan element is typically used to compensate external agents on sales revenue. There is no quota defined; however, the commission rate depends on the percentage of the payment.

Revenue Non Quota Plan Element Example 7
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Accumulate Off
Apply Txn Individually
Payment Type Payment Amount Percentage
Payment $750.00
Rate Table RNQ Percentage
Discount Option None

This plan element calculates the compensation for each transaction. The revenue achievement is not accumulated throughout the interval. The transaction amount on the transaction is treated separately from any other transaction. For each transaction, Oracle Sales Compensation finds the appropriate tier in the RNQ Percentage Rate Table corresponding to that level of revenue achievement, and multiplies this rate by the payment amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the revenue is located in the RNQ Percentage Rate Table.
Commission Commission rate x payment amount.

   To calculate the commission for product A:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for product B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

   To calculate the commission for products A and B:

Calculate the commission for products A and B.

The total commission for products A and B for the quarter is: $75 + $75 = $150.

Applied Transaction Amount Percentage : Grouped By Interval

This type of plan element is typically used to provide a bonus to the sales representatives based on revenue achievement. There is no quota defined; however, the commission rate depends on the revenue achievement. The sales representatives receive a percentage of the revenue they earn.

Revenue Non Quota Plan Element Example 8
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Apply Txn Grouped By Interval
Payment Type Applied Transaction Amount Percentage
Rate Table RNQ Percentage
Discount Option None

This plan element pays once per quarter. Oracle Sales Compensation totals the transaction amount for all sales transactions during each quarter, finds the tier in the RNQ Percentage Rate Table for the commission rate, and multiplies this rate by the total transaction amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the total transaction amount is located in the RNQ Percentage Rate Table.
Commission Commission rate x total transaction amount.

   To calculate the commission for products A and B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

Fixed Amount : Grouped By Interval

This type of plan element is typically used to provide a bonus to sales representatives based on revenue achievement. There is no quota defined; however, the commission amount depends on the revenue achievement. The sales representatives receive a fixed dollar amount as commission.

Revenue Non Quota Plan Element Example 9
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Apply Txn Grouped By Interval
Payment Type Fixed Amount
Rate Table RNQ Amount
Discount Option None

This plan element pays once per quarter. Oracle Sales Compensation totals the transaction amount for all sales transactions during each quarter, finds the appropriate tier in the RNQ Amount Rate Table and determines the commission amount.

Calculation Formula
Commission rate Determined by the tier in which the total transaction amount is located in the RNQ Amount Rate Table.
Commission Commission amount.

   To calculate the commission for products A and B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission amount for plan elements where the Split check box is unchecked or not applicable.

Payment Amount Percentage : Grouped By Interval

This type of plan element is typically used to provide a bonus to sales representatives based on revenue achievement. There is no quota defined; however, the commission rate depends on the revenue achievement. The sales representatives receive a percentage of payment or incentive quota as commission.

Revenue Non Quota Plan Element Example 10
Active Periods JAN-97 to DEC-97
Interval Type Quarter
Apply Txn Grouped By Interval
Payment Type Payment Amount Percentage
Payment $1,000.00
Rate Table RNQ Percentage
Discount Option None

This plan element pays once per quarter. Oracle Sales Compensation totals the transaction amount for all sales transactions during each quarter, finds the appropriate tier in the RNQ Percentage Rate Table to determine the commission rate, and multiplies this rate by the payment amount to derive the commission.

Calculation Formula
Commission rate Determined by the tier in which the unit is located in the RNQ Percentage Rate Table.
Commission Commission rate x payment amount.

   To calculate the commission for products A and B:

Note: When the performance is on the border of two tiers, Oracle Sales Compensation uses the higher rate to calculate the commission rate for plan elements where the Split check box is unchecked or not applicable.

         Previous  Next          Contents  Index  Navigation    Library