Hi
I am trying to create a distribution channel model, and I am not sure how to get this done.
Please assist
Based on the above table,
I want to create a Distribution Network Table, with the below assumptions,
1. Each sales person will do 5 sales per month
2. Each sales will be accumulated as a portfolio, to categorize the sales person into tiers
How can I model this in the below format,
To get the number of Partners that will be at the end of each month at the different Tiers, based on the total sales porfolio
I am trying to create a distribution channel model, and I am not sure how to get this done.
Please assist
| Units from | Units to | Commission per Unit | |
| Tier 1 | 1 | 10 | $ 10 |
| Tier 2 | 11 | 20 | $ 20 |
| Tier 3 | 21 | 50 | $ 30 |
| Tier 4 | 51+ | $ 50 |
Based on the above table,
I want to create a Distribution Network Table, with the below assumptions,
1. Each sales person will do 5 sales per month
2. Each sales will be accumulated as a portfolio, to categorize the sales person into tiers
How can I model this in the below format,
To get the number of Partners that will be at the end of each month at the different Tiers, based on the total sales porfolio
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | |
| Tier 1 | ||||||
| Tier 2 | ||||||
| Tier 3 | ||||||
| Tier 4 |
