1 Attachment(s)
Allocating buyers based on expertise and performance
Hello all - I'm working on a problem that has me stuck for a while now so I was wondering if anyone here would lend their expertise and help me out:
- Context: I have purchasing categories that are expected to have a certain workload (in # of purchase orders per year) going forward. I also have a set of buyers that have historically (1) processed X purchase orders per year and (2) dealt with selected categories so have expertise with them
- Problem: How can I allocate the buyers to the purchasing categories while factoring in their performance and historical category expertise?
A sample file is attached for reference but feel free to restructure. Any guidance would be much appreciated!
Attachment 21598