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