+ Reply to Thread
Results 1 to 2 of 2

Ranking based conditional allocation of inventory to a set of customer

  1. #1
    Registered User
    Join Date
    09-04-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    25

    Ranking based conditional allocation of inventory to a set of customer

    hello forum friends,

    i need help in the attached excel. as per the below details :

    Scene: i have an inventory. which i need to sell to a list of buyers (A-D). These buyer has made a contract with me in which each buyer has been assigned with a contractual quantity which they can ask from me. which i will distribute among them based on some criteria.

    These Buyer are free to ask quantity more than the contract quantity.Criteria: i have created a master data ('Rank' worksheet in the workbook) where i have divided the process of allocating the inventory on the basis of 3 iterations. Iteration 1 & 2 has a ranking of customer along with the iteration pecentage, which signifies the buyer will get on the basis of there rank and upto the iteration percentage of there requirement. For iteration 3 there is only rank which signifies that any extra requirement(additional requirement beyond the contractual quantity) will be provided in this iteration. Provided inventory is remaining.

    There is a cap of inventory is maintained for each buyer also, so that the iteration 1+2+3 should not exceed the cap.

    Query : i want a formula which will satisfy my criteria and provide me the quantity in iteration 1, 2 & 3 (Dashboard in uploaded excel)
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,886

    Re: Ranking based conditional allocation of inventory to a set of customer

    I have gone with your attach file, but sorry to say, idea not clear. Can you input manually required result in respective cell.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fifo allocation of inventory & extract name of associated bin & store name.
    By GAURAVVOHRA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2019, 11:57 AM
  2. [SOLVED] Inventory Allocation based on Warehouses near expiry and less Qty location
    By majidsiddique in forum Excel General
    Replies: 9
    Last Post: 03-11-2019, 06:43 AM
  3. Generate a separate staff customer list based on larger customer table
    By CARROLLJP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2018, 04:40 PM
  4. Need assistance on coming up with an inventory allocation formula
    By GTK-Irvine in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2014, 02:24 PM
  5. Inventory allocation automation
    By vgr in forum Excel General
    Replies: 3
    Last Post: 04-05-2014, 10:24 AM
  6. Conditional Allocation based on specific values
    By blog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2010, 01:25 PM
  7. Allocation of inventory items
    By northenalias in forum Excel General
    Replies: 4
    Last Post: 08-17-2009, 07:18 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1