santhoshlk
Board Regular
- Joined
- Feb 6, 2006
- Messages
- 206
hi guyzzz... hopu u can help me
i have listed customers in col-A (150 customer) and col-B got their total collection in past year.
i have 5 sales person with me.
now i need to distribute the customers to each salesperson with following condition
I have 150 customers & 5 Salesmen. so average 30 customers per man
and average of total collection of last year is 20mill.
now each saleman shoul get 30 customers and their last year collection should be around 20 mill.
is it possible
pls help
i have listed customers in col-A (150 customer) and col-B got their total collection in past year.
i have 5 sales person with me.
now i need to distribute the customers to each salesperson with following condition
I have 150 customers & 5 Salesmen. so average 30 customers per man
and average of total collection of last year is 20mill.
now each saleman shoul get 30 customers and their last year collection should be around 20 mill.
is it possible
pls help