I want to allocate campaign products to various stores.
Idea is for example we have product A in stock and we want to allocate this product to No. of stores.
We give input like 50 (what we have in stock) than excel make calculation and come up with proposal for allocation. Where allocation proposal based on what we have available in stock and last year sales. Stores with high rank will get more stock then stores with low rank.
Where stores have their own ranking based on their size and sales.
We can also allocate stock based on percentage, as we have to allocate 75% of available stock to all locations.
Data input
Excel worksheets containing product data like: (possibility to choose item worksheets like shoes, t-shirts, house holding) etc.
Excel sheets with stores id’s with their respective names and priority ranks.
When the application start comes up user form containing 3 como boxes
User form having button like allocate, reset to rest selected data in user form and close to exit user form.
Idea is for example we have product A in stock and we want to allocate this product to No. of stores.
| Product | Stock |
| A | 50 |
We give input like 50 (what we have in stock) than excel make calculation and come up with proposal for allocation. Where allocation proposal based on what we have available in stock and last year sales. Stores with high rank will get more stock then stores with low rank.
Where stores have their own ranking based on their size and sales.
| Stores | Ranking | Allocation |
1 | 2 | 10 |
2 | 1 | 3 |
3 | 2 | 5 |
We can also allocate stock based on percentage, as we have to allocate 75% of available stock to all locations.
Data input
Excel worksheets containing product data like: (possibility to choose item worksheets like shoes, t-shirts, house holding) etc.
- Item name
- Item description
- Current stock
- Last year sales
- Demand
Excel sheets with stores id’s with their respective names and priority ranks.
- Small stores in size and sales = 1
- Medium stores in size and sales =2
- Big stores in size and sales = 3
When the application start comes up user form containing 3 como boxes
- Product (where products are shoes, t-shirts and house holding) can be selected to allocate particular product
- Month jan to dec (in which month we want to allocate our stock (based on last year sales in respective months.
- Quantity (how much we want to allocate. (Input box)
User form having button like allocate, reset to rest selected data in user form and close to exit user form.