-
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!
Problem Sample.xlsx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules