Standard commissions are defined in the commission grid by creating a commission table to pay salespeople based on the total dollar amount of each invoice and the percentage of gross profit made on that sale. This is accomplished by first defining invoice and gross profit breakpoints. Finally, commission percentages are entered into the grid of the commission table.

 

The concept of the commission table is similar to find a town on a road map. If you were to look up a town in the index, it might tell you it can be found at "E5." You would find the town by finding the "E" row across the top and next finding the "5" column on the side. Where these two points intersect is where you will find the town. From this illustration, the "E" row would represent the invoice dollar amount, the "5" column would represent the gross profit percent, and the town would represent the commission.

 

The maximum commission percentages that may be entered is 99.9%.

 

There must be an Sales Amount breakpoint defined for 9999.

 

There must be a Gross Profit percentage breakpoint defined for 999.

 

 

Using the following commission table, if the salesperson had taken an order for a total of $160 and an 10% gross profit, the commission would be 13%.  If the salesperson had taken an order for $995 and with 22% gross profit, the Commission earned would be 16%.

                Invoice Amount ($) ==>

Gross Profit (%) | 50   | 100  | 125  | 150  | 200  | 9999  |

      15        | 9.0%  | 10.0% | 11.0% | 12.0% | 13.0% | 14.0% |

      20        | 10.0% | 11.0% | 12.0% | 13.0% | 14.0% | 15.0% |

    999        | 11.0% | 12.0% | 13.0% | 14.0% | 15.0% | 16.0% |