Lustful Salmon
New Member
- Joined
- Jan 18, 2012
- Messages
- 13
Good Morning,
I am trying to create a commission calculator for a point system incentive plan similar to the plan found here.
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL></COLGROUP>
Here is an example of how the calculator should work based on the sales examples provided...see the Points rewarded.
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL span=4></COLGROUP>
How do I set up formulas that will allow me to populate my "Points Rewarded" section while tying up the incentive plan criteria to the sales examples found here?
<TBODY>
</TBODY>
Thank you in advance for any help or suggestions in helping work out how to formulate this table...
I am trying to create a commission calculator for a point system incentive plan similar to the plan found here.
Incentive Points Plan</SPAN> | |||||
Product</SPAN> | Pricing</SPAN> | Base Pts</SPAN> | Comp Conv</SPAN> | Comp Conv Over</SPAN> | Upgrade</SPAN> |
Quart</SPAN> | $64,000</SPAN> | 4</SPAN> | 4</SPAN> | 6</SPAN> | 1</SPAN> |
Quart Tier 1</SPAN> | $60,000</SPAN> | 3</SPAN> | 3</SPAN> | 5</SPAN> | 1</SPAN> |
Quart Tier 2</SPAN> | $54,000</SPAN> | 2</SPAN> | 2</SPAN> | 4</SPAN> | 1 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL></COLGROUP>
Here is an example of how the calculator should work based on the sales examples provided...see the Points rewarded.
Sales Examples with Points</SPAN> | Points Rewarded</SPAN> | |||||||
Invoiced Qty</SPAN> | Item Group</SPAN> | Program</SPAN> | Net Price</SPAN> | Base Pts</SPAN> | Comp Conv</SPAN> | Comp Conv Over</SPAN> | Upgrade</SPAN> | Total Pts</SPAN> |
1</SPAN> | Quart</SPAN> | Rollover</SPAN> | $54,000</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 2</SPAN> |
1</SPAN> | Quart</SPAN> | Upgrade</SPAN> | $64,000</SPAN> | 4</SPAN> | 0</SPAN> | 0</SPAN> | 1</SPAN> | 5</SPAN> |
2</SPAN> | Quart</SPAN> | Comp Conv</SPAN> | $140,000</SPAN> | 8</SPAN> | 4</SPAN> | 0</SPAN> | 0</SPAN> | 12</SPAN> |
3</SPAN> | Quart</SPAN> | Comp Conv Over</SPAN> | $250,000</SPAN> | 12</SPAN> | 0</SPAN> | 6</SPAN> | 0</SPAN> | 18</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL span=4></COLGROUP>
How do I set up formulas that will allow me to populate my "Points Rewarded" section while tying up the incentive plan criteria to the sales examples found here?
A | B | C | D | E | F | G | H | I | |
1 | Product | Pricing | Base Pts | Comp Conv | Comp Conv Over | Upgrade | |||
2 | Quart | $64,000 | 4 | 4 | 6 | 1 | |||
3 | Quart T1 | $60,000 | 3 | 3 | 5 | 1 | |||
4 | Quart T2 | $54,000 | 2 | 2 | 4 | 1 | |||
5 | Invoiced Qty</SPAN> | Item Group | Program | Net Price</SPAN> | Base Pts</SPAN> | Comp Conv | Comp Conv Over | Upgrade | Total Pts |
6 | 1 | Quart | Rollover | $54,000 | |||||
7 | 1 | Quart | Upgrade | $64,000 | |||||
8 | 2 | Quart | Comp Conv | $150,000 | |||||
9 | 3 | Quart | Comp Conv Over | $250,000 |
<TBODY>
</TBODY>
Thank you in advance for any help or suggestions in helping work out how to formulate this table...