Excel inventory tracking and fair allocation

  • hi all!

    I'm building a spreadsheet to track inventory from the supplier and assigned to my butchers. I'd like to be able to assign the inventory based on a performance KPI (higher the better) but also it needs to be fair..eg if top KPI gets 1 inventory, doesn't mean he gets everything...

    I have tried to use Large to find top values, but not sure where to go from there, eg how do I sort the values and assign the inventory and then make it more fair?

    simplified spreadsheet attached.

    TL:DR basically, many butchers make the requests...and we only have limited amounts to give out as per the spreadsheet, I don't want to give Tony everything...butcher inventory match.xlsx

    many thanks for the help!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!