Hello,
I have warehouse where we receive unsold products from shops. These products can have 3 type of quality: good, damaged, broken. We know for each shop the quantities they have return, and we have a total quantity per quality per product. For each shop we have a desired percentage of product per quantity we would like to allocate to them.
I am looking for a way to use formulas to satisfy these criteria... Am I too optimistic?
If someone has an idea of how to handle this problem?
I have warehouse where we receive unsold products from shops. These products can have 3 type of quality: good, damaged, broken. We know for each shop the quantities they have return, and we have a total quantity per quality per product. For each shop we have a desired percentage of product per quantity we would like to allocate to them.
I am looking for a way to use formulas to satisfy these criteria... Am I too optimistic?
If someone has an idea of how to handle this problem?