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)
Bookmarks