Excel Template for Stock allocation
Budget: $10 – $30 USD
I have various stocks and various sales persons and different origins. I need an excel template that MUST keep in account the following;
1. Given the Total stock available, allocate a certain preferred percentage to sales persons.
2. Each origin can only be sold by two sales people.
3. Origins are many and each has six products with varying quantity for each.
4. Based on products availability, there must be equal distribution to sales people per origin
More details to follow. Project will be awarded with prove of understanding.
1. Given the Total stock available, allocate a certain preferred percentage to sales persons.
2. Each origin can only be sold by two sales people.
3. Origins are many and each has six products with varying quantity for each.
4. Based on products availability, there must be equal distribution to sales people per origin
More details to follow. Project will be awarded with prove of understanding.