Compare Proposal

Nothing to compare.

Merchandise planning and allocation tool where we can get allocation proposal

  • Posted at : 1 month ago
  • Post Similar Project
10

Budget
4
Proposals
156
Views
Open
Status
Skills Required

Posted By -

RB

0.0
Projects Posted : 1
Projects Paid : 0
Services Purchased : 0
Total Spent :
0
Feedbacks : 0 %

Project Details show (+) hide (-)

Create Merchandise Planning and allocation tool.We 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.  

Product 
Stock
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. 
1. Small stores in size and sales = 1
2. Medium stores in size and sales =2
3. Big stores in size and sales = 3
 When the application start comes up user form containing 3como boxes 
1. Product (where are product are shoes, t-shirts and house holding) can be selected to allocate particular product
2. Month jan to dec (in which month we want to allocate our stock (based on last year sales in respective months. 
 
3. Quantity (how much we want to allocate. (Input box)
 
4.  
Then hit the allocate button and excel make calculations in back ground based on store rank and allocation rank, demand and last year sales and provide us an allocation proposal for respective item in respective month in sheet allocation shoes in allocation Colum.  User form having button like allocate, reset to rest selected data in user form and close to exit user form.

Your Job Feed