FAQ - Rate Lookup

Rate LookUp is a method of calculation that is used to calculate commission rates for a payee. The commission rates obtained using this Rate Lookup will be used in plan calculation to determine the payout amount.

Basic Commission and Tier Rate are the two types of Rate Lookups that are used in calculation to determine the payout amount.

Basic Commission Rate method deploys matrices to calculate the commission rate. Five types of matrices can be applied, namely Rows Only, Rows with Ranges, Row Column, Row Column with Ranges, Row with Ranges Column with Ranges. You may use variables (e.g. attainment, credit amount) to assign range values to rows or columns of a matrix. These variables can be selected from Row As, Column As fields. Enter the values into the rows and columns appropriately. This matrix can be saved in the name of your choice. This table may later be referred in Plan while setting up credit rules.

Tier Rate is meant for payees whose performance has crossed a threshold. Such payees get commission on a split basis, the part that falls above the threshold getting the higher rate. Tier Rate Calculation allows treating input values as Percent of Attainment or Attainment Credits.

The Percent of Attainment option is one of the two methods by which you calculate Tier Rate. The range values specified in the matrix will be in terms of percentage. i.e., if the Attainment Percent falls within the specified range, the corresponding value will be taken as the commission rate.

You can specifically create a rate lookup for a payee, product etc., using Sub Selection Key and Sub Selection value from Rate Lookup maintenance form.

Yes, You can split credit amount between payees.