Apr 21 2022 01:44 AM
Hi
I am trying to create a distribution channel model, and I am not sure how to get this done.
The assumptions are
Total Customers from | Total Customers from | |
Tier 1 | 1 | 10 |
Tier 2 | 11 | 20 |
Tier 3 | 21 | 50 |
Tier 4 | 51+ |
1. I want to have 5,000 Customers by the end of 24 months
2. Each sales person will bring 8 new customers per month
3. Each new customer (sales) will be accumulated as a portfolio, to categorize the sales person into tiers based on the above table
I want to create a Table with the above assumptions, to categorize each sales person into different tiers based on the number of total customers they will have at the end of each month
How can I model this in the below format,
To get the number of sales persons at the end of each month at the different Tiers, based on the total customer portfolio, until I reach a total of 5000 customers
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | |
Tier 1 | ||||||
Tier 2 | ||||||
Tier 3 | ||||||
Tier 4 |
Apr 21 2022 11:27 AM